eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EC_CODE_CONVERSION_PVT dependencies on EC_CODE_CONVERSION_PVT

Line 1: PACKAGE BODY EC_Code_Conversion_PVT AS

1: PACKAGE BODY EC_Code_Conversion_PVT AS
2: -- $Header: ECVXREFB.pls 120.2.12000000.2 2007/02/09 17:32:02 cpeixoto ship $
3:
4: debug_mode_on_int BOOLEAN := FALSE;
5:

Line 151: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.Convert_from_ext_to_int');

147: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
148:
149: BEGIN
150: if EC_DEBUG.G_debug_level >= 2 then
151: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.Convert_from_ext_to_int');
152: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
153: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
154: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
155: EC_DEBUG.PL(3, 'p_commit: ',p_commit);

Line 360: /* p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;

356: END IF;
357: */
358: if l_Int_val is null
359: then
360: /* p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;
361: fnd_message.set_name('EC','ECE_XREF_NOT_FOUND');
362: fnd_message.set_token('DATA', p_Ext_val1);
363: p_msg_data := fnd_message.get; */
364:

Line 383: EC_DEBUG.POP('EC_Code_Conversion_PVT.Convert_from_ext_to_int');

379: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
380: p_data => p_msg_data);
381:
382: if EC_DEBUG.G_debug_level >= 2 then
383: EC_DEBUG.POP('EC_Code_Conversion_PVT.Convert_from_ext_to_int');
384: end if;
385: EXCEPTION
386: WHEN FND_API.G_EXC_ERROR THEN
387: -- ROLLBACK TO Convert_from_ext_to_int_PVT;

Line 561: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.Convert_from_int_to_ext');

557:
558: BEGIN
559:
560: if EC_DEBUG.G_debug_level >= 2 then
561: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.Convert_from_int_to_ext');
562: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
563: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
564: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
565: EC_DEBUG.PL(3, 'p_commit: ',p_commit);

Line 779: /* p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;

775: and l_Ext_val3 is null
776: and l_Ext_val4 is null
777: and l_Ext_val5 is null
778: then
779: /* p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;
780: fnd_message.set_name('EC','ECE_XREF_NOT_FOUND');
781: fnd_message.set_token('DATA', p_Int_val);
782: p_msg_data := fnd_message.get; */
783:

Line 817: EC_DEBUG.POP('EC_Code_Conversion_PVT.Convert_from_int_to_ext');

813: -- Standard call to get message count and if count is 1, get message info.
814: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,p_data => p_msg_data);
815:
816: if EC_DEBUG.G_debug_level >= 2 then
817: EC_DEBUG.POP('EC_Code_Conversion_PVT.Convert_from_int_to_ext');
818: end if;
819: EXCEPTION
820: WHEN FND_API.G_EXC_ERROR THEN
821: -- ROLLBACK TO Convert_from_int_to_ext_PVT;

Line 904: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');

900:
901: BEGIN
902:
903: if EC_DEBUG.G_debug_level >= 2 then
904: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');
905: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
906: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
907: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
908: EC_DEBUG.PL(3, 'p_commit: ',p_commit);

Line 1032: EC_Code_Conversion_PVT.Convert_from_int_to_ext

1028:
1029: -- Now we know the int_value, the actual value of the key1-5,
1030: -- so we just need to call int_2_ext APIs to get the
1031: -- the ext1-5 value
1032: EC_Code_Conversion_PVT.Convert_from_int_to_ext
1033: (p_api_version_number => 1.0,
1034: p_return_status => l_return_status,
1035: p_msg_count => l_msg_count,
1036: p_msg_data => l_msg_data,

Line 1180: if l_return_status = EC_Code_Conversion_PVT.G_XREF_NOT_FOUND

1176: -- Standard call to get message count and if count is 1, get message info.
1177: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1178: p_data => p_msg_data);
1179:
1180: if l_return_status = EC_Code_Conversion_PVT.G_XREF_NOT_FOUND
1181: then
1182: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;
1183: end if;
1184:

Line 1182: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;

1178: p_data => p_msg_data);
1179:
1180: if l_return_status = EC_Code_Conversion_PVT.G_XREF_NOT_FOUND
1181: then
1182: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;
1183: end if;
1184:
1185: if EC_DEBUG.G_debug_level >= 2 then
1186: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');

Line 1186: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');

1182: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;
1183: end if;
1184:
1185: if EC_DEBUG.G_debug_level >= 2 then
1186: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');
1187: end if;
1188: EXCEPTION
1189: WHEN FND_API.G_EXC_ERROR THEN
1190: ROLLBACK TO populate_plsql_tbl_PVT;

Line 1273: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');

1269:
1270: BEGIN
1271:
1272: if EC_DEBUG.G_debug_level >= 2 then
1273: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');
1274: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
1275: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
1276: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
1277: EC_DEBUG.PL(3, 'p_commit: ',p_commit);

Line 1425: EC_Code_Conversion_PVT.Convert_from_int_to_ext

1421: END IF;
1422: -- Now we know the int_value, the actual value of the key1-5,
1423: -- so we just need to call int_2_ext APIs to get the
1424: -- the ext1-5 value
1425: EC_Code_Conversion_PVT.Convert_from_int_to_ext
1426: (p_api_version_number => 1.0,
1427: p_return_status => l_return_status,
1428: p_msg_count => l_msg_count,
1429: p_msg_data => l_msg_data,

Line 1573: if l_return_status = EC_Code_Conversion_PVT.G_XREF_NOT_FOUND

1569: -- Standard call to get message count and if count is 1, get message info.
1570: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1571: p_data => p_msg_data);
1572:
1573: if l_return_status = EC_Code_Conversion_PVT.G_XREF_NOT_FOUND
1574: then
1575: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;
1576: end if;
1577:

Line 1575: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;

1571: p_data => p_msg_data);
1572:
1573: if l_return_status = EC_Code_Conversion_PVT.G_XREF_NOT_FOUND
1574: then
1575: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;
1576: end if;
1577:
1578: if EC_DEBUG.G_debug_level >= 2 then
1579: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');

Line 1579: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');

1575: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;
1576: end if;
1577:
1578: if EC_DEBUG.G_debug_level >= 2 then
1579: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');
1580: end if;
1581: EXCEPTION
1582: WHEN FND_API.G_EXC_ERROR THEN
1583: ROLLBACK TO populate_plsql_tbl_PVT;

Line 1669: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');

1665: k INTEGER;
1666:
1667: BEGIN
1668: if EC_DEBUG.G_debug_level >= 2 then
1669: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');
1670: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
1671: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
1672: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
1673: EC_DEBUG.PL(3, 'p_commit: ',p_commit);

Line 1936: EC_Code_Conversion_PVT.Convert_from_ext_to_int

1932:
1933: -- Now we know the int_value, the actual value of the key1-5,
1934: -- so we just need to call int_2_ext APIs to get the
1935: -- the ext1-5 value
1936: EC_Code_Conversion_PVT.Convert_from_ext_to_int
1937: (p_api_version_number => 1.0,
1938: p_return_status => l_return_status,
1939: p_msg_count => l_msg_count,
1940: p_msg_data => l_msg_data,

Line 2013: if l_return_status = EC_Code_Conversion_PVT.G_XREF_NOT_FOUND

2009: -- Standard call to get message count and if count is 1, get message info.
2010: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2011: p_data => p_msg_data);
2012:
2013: if l_return_status = EC_Code_Conversion_PVT.G_XREF_NOT_FOUND
2014: then
2015: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;
2016: end if;
2017:

Line 2015: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;

2011: p_data => p_msg_data);
2012:
2013: if l_return_status = EC_Code_Conversion_PVT.G_XREF_NOT_FOUND
2014: then
2015: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;
2016: end if;
2017:
2018: if EC_DEBUG.G_debug_level >= 2 then
2019: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');

Line 2019: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');

2015: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;
2016: end if;
2017:
2018: if EC_DEBUG.G_debug_level >= 2 then
2019: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');
2020: end if;
2021: EXCEPTION
2022: WHEN FND_API.G_EXC_ERROR THEN
2023: ROLLBACK TO populate_plsql_tbl_PVT;

Line 2110: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');

2106: k INTEGER;
2107:
2108: BEGIN
2109: if EC_DEBUG.G_debug_level >= 2 then
2110: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');
2111: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
2112: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
2113: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
2114: EC_DEBUG.PL(3, 'p_commit: ',p_commit);

Line 2410: EC_Code_Conversion_PVT.Convert_from_ext_to_int

2406:
2407: -- Now we know the int_value, the actual value of the key1-5,
2408: -- so we just need to call int_2_ext APIs to get the
2409: -- the ext1-5 value
2410: EC_Code_Conversion_PVT.Convert_from_ext_to_int
2411: (p_api_version_number => 1.0,
2412: p_return_status => l_return_status,
2413: p_msg_count => l_msg_count,
2414: p_msg_data => l_msg_data,

Line 2491: if l_return_status = EC_Code_Conversion_PVT.G_XREF_NOT_FOUND

2487: -- Standard call to get message count and if count is 1, get message info.
2488: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2489: p_data => p_msg_data);
2490:
2491: if l_return_status = EC_Code_Conversion_PVT.G_XREF_NOT_FOUND
2492: then
2493: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;
2494: end if;
2495:

Line 2493: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;

2489: p_data => p_msg_data);
2490:
2491: if l_return_status = EC_Code_Conversion_PVT.G_XREF_NOT_FOUND
2492: then
2493: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;
2494: end if;
2495:
2496: if EC_DEBUG.G_debug_level >= 2 then
2497: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');

Line 2497: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');

2493: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;
2494: end if;
2495:
2496: if EC_DEBUG.G_debug_level >= 2 then
2497: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');
2498: end if;
2499: EXCEPTION
2500: WHEN FND_API.G_EXC_ERROR THEN
2501: ROLLBACK TO populate_plsql_tbl_PVT;

Line 2522: END EC_Code_Conversion_PVT;

2518: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2519: p_data => p_msg_data);
2520: END populate_plsql_tbl_with_intval;
2521:
2522: END EC_Code_Conversion_PVT;