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.VEA_LAYERS_SV dependencies on VEA_TPA_UTIL_PVT

Line 95: VEA_TPA_UTIL_PVT.Convert_from_ext_to_int(

91: --
92: --
93: p_tps_parameter_name := parameter_rec.name;
94: p_tps_parameter_int_value :=
95: VEA_TPA_UTIL_PVT.Convert_from_ext_to_int(
96: p_layer_provider_code,
97: parameter_rec.name,
98: p_tps_parameter_value);
99: --

Line 121: vea_tpa_util_pvt.add_exc_message_and_raise

117: --}
118: WHEN OTHERS
119: THEN
120: --{
121: vea_tpa_util_pvt.add_exc_message_and_raise
122: (
123: p_package_name => G_PACKAGE_NAME,
124: p_api_name => l_api_name,
125: p_location => l_location

Line 172: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

168: l_api_name CONSTANT VARCHAR2(30) := 'saveBranchToGlobal';
169: l_location VARCHAR2(32767);
170: --
171: --
172: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
173: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
174: --
175: --
176: l_index BINARY_INTEGER;

Line 173: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

169: l_location VARCHAR2(32767);
170: --
171: --
172: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
173: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
174: --
175: --
176: l_index BINARY_INTEGER;
177: --

Line 336: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

332: l_api_name CONSTANT VARCHAR2(30) := 'saveBranchCriteria';
333: l_location VARCHAR2(32767);
334: --
335: --
336: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
337: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
338: --
339: --
340: l_tps_parameter1_int_value ece_xref_data.xref_int_value%TYPE;

Line 337: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

333: l_location VARCHAR2(32767);
334: --
335: --
336: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
337: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
338: --
339: --
340: l_tps_parameter1_int_value ece_xref_data.xref_int_value%TYPE;
341: l_tps_parameter2_int_value ece_xref_data.xref_int_value%TYPE;

Line 443: vea_tpa_util_pvt.add_exc_message_and_raise

439: --}
440: WHEN OTHERS
441: THEN
442: --{
443: vea_tpa_util_pvt.add_exc_message_and_raise
444: (
445: p_package_name => G_PACKAGE_NAME,
446: p_api_name => l_api_name,
447: p_location => l_location

Line 473: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

469: l_api_name CONSTANT VARCHAR2(30) := 'findParameterValue';
470: l_location VARCHAR2(32767);
471: --
472: --
473: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
474: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
475: --
476: --
477: BEGIN

Line 474: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

470: l_location VARCHAR2(32767);
471: --
472: --
473: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
474: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
475: --
476: --
477: BEGIN
478: --{

Line 598: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

594: l_api_name CONSTANT VARCHAR2(30) := 'findBranchParameters';
595: l_location VARCHAR2(32767);
596: --
597: --
598: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
599: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
600: --
601: --
602: l_layer_count NUMBER;

Line 599: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

595: l_location VARCHAR2(32767);
596: --
597: --
598: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
599: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
600: --
601: --
602: l_layer_count NUMBER;
603: l_execution_priority NUMBER := 0;

Line 695: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

691: l_api_name CONSTANT VARCHAR2(30) := 'findParameterCombination';
692: l_location VARCHAR2(32767);
693: --
694: --
695: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
696: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
697: --
698: --
699: l_execution_priority NUMBER;

Line 696: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

692: l_location VARCHAR2(32767);
693: --
694: --
695: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
696: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
697: --
698: --
699: l_execution_priority NUMBER;
700: --

Line 793: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

789: l_api_name CONSTANT VARCHAR2(30) := 'checkOverlapExists';
790: l_location VARCHAR2(32767);
791: --
792: --
793: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
794: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
795: --
796: --
797: l_curr_index BINARY_INTEGER;

Line 794: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

790: l_location VARCHAR2(32767);
791: --
792: --
793: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
794: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
795: --
796: --
797: l_curr_index BINARY_INTEGER;
798: l_cmpr_index BINARY_INTEGER;

Line 931: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

927: l_api_name CONSTANT VARCHAR2(30) := 'switchLayerPositions';
928: l_location VARCHAR2(32767);
929: --
930: --
931: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
932: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
933: --
934: --
935: l_curr_index BINARY_INTEGER;

Line 932: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

928: l_location VARCHAR2(32767);
929: --
930: --
931: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
932: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
933: --
934: --
935: l_curr_index BINARY_INTEGER;
936: l_cmpr_index BINARY_INTEGER;

Line 1140: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

1136: l_api_name CONSTANT VARCHAR2(30) := 'checkConflictingLayers';
1137: l_location VARCHAR2(32767);
1138: --
1139: --
1140: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
1141: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
1142: --
1143: --
1144: l_curr_index BINARY_INTEGER;

Line 1141: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

1137: l_location VARCHAR2(32767);
1138: --
1139: --
1140: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
1141: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
1142: --
1143: --
1144: l_curr_index BINARY_INTEGER;
1145: l_cmpr_index BINARY_INTEGER;

Line 1267: vea_tpa_util_pvt.add_message

1263: THEN
1264: --{
1265: l_location := '0020';
1266: --
1267: vea_tpa_util_pvt.add_message
1268: (
1269: p_error_name => 'VEA_TP_LAYERS_CONFLICT',
1270: p_token1 => 'PROGRAM_UNIT_NAME',
1271: p_value1 => p_program_unit_name,

Line 1307: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

1303: l_api_name CONSTANT VARCHAR2(30) := 'saveConflictDetails';
1304: l_location VARCHAR2(32767);
1305: --
1306: --
1307: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
1308: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
1309: --
1310: --
1311: l_curr_index BINARY_INTEGER;

Line 1308: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

1304: l_location VARCHAR2(32767);
1305: --
1306: --
1307: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
1308: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
1309: --
1310: --
1311: l_curr_index BINARY_INTEGER;
1312: l_cmpr_index BINARY_INTEGER;

Line 1383: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

1379: l_api_name CONSTANT VARCHAR2(30) := 'processConflictingLayers';
1380: l_location VARCHAR2(32767);
1381: --
1382: --
1383: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
1384: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
1385: --
1386: --
1387: l_program_unit_name vea_program_units.name%TYPE;

Line 1384: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

1380: l_location VARCHAR2(32767);
1381: --
1382: --
1383: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
1384: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
1385: --
1386: --
1387: l_program_unit_name vea_program_units.name%TYPE;
1388: l_program_unit_id vea_program_units.program_unit_id%TYPE;

Line 1573: vea_tpa_util_pvt.add_exc_message_and_raise

1569: --}
1570: WHEN OTHERS
1571: THEN
1572: --{
1573: vea_tpa_util_pvt.add_exc_message_and_raise
1574: (
1575: p_package_name => G_PACKAGE_NAME,
1576: p_api_name => l_api_name,
1577: p_location => l_location

Line 1606: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

1602: l_api_name CONSTANT VARCHAR2(30) := 'validateUniqueBranchSequence';
1603: l_location VARCHAR2(32767);
1604: --
1605: --
1606: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
1607: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
1608: --
1609: --
1610: CURSOR layer_cur

Line 1607: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

1603: l_location VARCHAR2(32767);
1604: --
1605: --
1606: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
1607: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
1608: --
1609: --
1610: CURSOR layer_cur
1611: IS

Line 1649: vea_tpa_util_pvt.add_message_and_raise

1645: THEN
1646: --{
1647: l_location := '0020';
1648: --
1649: vea_tpa_util_pvt.add_message_and_raise
1650: (
1651: p_error_name => 'VEA_LM_UNIQ_BRANCH_SEQ',
1652: p_token1 => 'PROGRAM_UNIT_NAME',
1653: p_value1 => layer_rec.program_unit_name,

Line 1674: vea_tpa_util_pvt.add_exc_message_and_raise

1670: --}
1671: WHEN OTHERS
1672: THEN
1673: --{
1674: vea_tpa_util_pvt.add_exc_message_and_raise
1675: (
1676: p_package_name => G_PACKAGE_NAME,
1677: p_api_name => l_api_name,
1678: p_location => l_location

Line 1730: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

1726: l_api_name CONSTANT VARCHAR2(30) := 'validate';
1727: l_location VARCHAR2(32767);
1728: --
1729: --
1730: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
1731: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
1732: --}
1733: BEGIN
1734: --{

Line 1731: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

1727: l_location VARCHAR2(32767);
1728: --
1729: --
1730: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
1731: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
1732: --}
1733: BEGIN
1734: --{
1735: l_location := '0010';

Line 1737: IF vea_tpa_util_pvt.validate

1733: BEGIN
1734: --{
1735: l_location := '0010';
1736: --
1737: IF vea_tpa_util_pvt.validate
1738: THEN
1739: --{
1740: l_location := '0020';
1741: --

Line 1764: vea_tpa_util_pvt.add_exc_message_and_raise

1760: --}
1761: WHEN OTHERS
1762: THEN
1763: --{
1764: vea_tpa_util_pvt.add_exc_message_and_raise
1765: (
1766: p_package_name => G_PACKAGE_NAME,
1767: p_api_name => l_api_name,
1768: p_location => l_location

Line 1820: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

1816: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
1817: l_location VARCHAR2(32767);
1818: --
1819: --
1820: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
1821: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
1822: --}
1823: BEGIN
1824: --{

Line 1821: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

1817: l_location VARCHAR2(32767);
1818: --
1819: --
1820: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
1821: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
1822: --}
1823: BEGIN
1824: --{
1825: l_location := '0010';

Line 1877: vea_tpa_util_pvt.add_exc_message_and_raise

1873: --{
1874: WHEN OTHERS
1875: THEN
1876: --{
1877: vea_tpa_util_pvt.add_exc_message_and_raise
1878: (
1879: p_package_name => G_PACKAGE_NAME,
1880: p_api_name => l_api_name,
1881: p_location => l_location

Line 1933: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

1929: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
1930: l_location VARCHAR2(32767);
1931: --
1932: --
1933: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
1934: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
1935: --}
1936: BEGIN
1937: --{

Line 1934: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

1930: l_location VARCHAR2(32767);
1931: --
1932: --
1933: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
1934: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
1935: --}
1936: BEGIN
1937: --{
1938: l_location := '0010';

Line 1979: vea_tpa_util_pvt.add_exc_message_and_raise

1975: --{
1976: WHEN OTHERS
1977: THEN
1978: --{
1979: vea_tpa_util_pvt.add_exc_message_and_raise
1980: (
1981: p_package_name => G_PACKAGE_NAME,
1982: p_api_name => l_api_name,
1983: p_location => l_location

Line 2023: vea_tpa_util_pvt.add_exc_message_and_raise

2019: --{
2020: WHEN OTHERS
2021: THEN
2022: --{
2023: vea_tpa_util_pvt.add_exc_message_and_raise
2024: (
2025: p_package_name => G_PACKAGE_NAME,
2026: p_api_name => l_api_name,
2027: p_location => l_location

Line 2119: vea_tpa_util_pvt.add_exc_message_and_raise

2115: --{
2116: WHEN OTHERS
2117: THEN
2118: --{
2119: vea_tpa_util_pvt.add_exc_message_and_raise
2120: (
2121: p_package_name => G_PACKAGE_NAME,
2122: p_api_name => l_api_name,
2123: p_location => l_location

Line 2197: vea_tpa_util_pvt.add_exc_message_and_raise

2193: --{
2194: WHEN OTHERS
2195: THEN
2196: --{
2197: vea_tpa_util_pvt.add_exc_message_and_raise
2198: (
2199: p_package_name => G_PACKAGE_NAME,
2200: p_api_name => l_api_name,
2201: p_location => l_location

Line 2233: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

2229: l_api_name CONSTANT VARCHAR2(30) := 'isLayerActive';
2230: l_location VARCHAR2(32767);
2231: --
2232: --
2233: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
2234: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
2235: --
2236: --
2237: CURSOR layer_cur

Line 2234: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

2230: l_location VARCHAR2(32767);
2231: --
2232: --
2233: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
2234: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
2235: --
2236: --
2237: CURSOR layer_cur
2238: IS

Line 2315: vea_tpa_util_pvt.add_exc_message_and_raise

2311: --{
2312: WHEN OTHERS
2313: THEN
2314: --{
2315: vea_tpa_util_pvt.add_exc_message_and_raise
2316: (
2317: p_package_name => G_PACKAGE_NAME,
2318: p_api_name => l_api_name,
2319: p_location => l_location

Line 2371: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

2367: l_api_name CONSTANT VARCHAR2(30) := 'process_code_conversion';
2368: l_location VARCHAR2(32767);
2369: --
2370: --
2371: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
2372: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
2373: --}
2374: BEGIN
2375: --{

Line 2372: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

2368: l_location VARCHAR2(32767);
2369: --
2370: --
2371: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
2372: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
2373: --}
2374: BEGIN
2375: --{
2376: l_location := '0010';

Line 2378: vea_tpa_util_pvt.process_code_conversion

2374: BEGIN
2375: --{
2376: l_location := '0010';
2377: --
2378: vea_tpa_util_pvt.process_code_conversion
2379: (
2380: p_layer_provider_code => p_layer_provider_code,
2381: p_layer_header_id => p_layer_header_id,
2382: p_tps_parameter_id => p_tps_parameter1_id,

Line 2389: vea_tpa_util_pvt.process_code_conversion

2385: --
2386: --
2387: l_location := '0020';
2388: --
2389: vea_tpa_util_pvt.process_code_conversion
2390: (
2391: p_layer_provider_code => p_layer_provider_code,
2392: p_layer_header_id => p_layer_header_id,
2393: p_tps_parameter_id => p_tps_parameter2_id,

Line 2400: vea_tpa_util_pvt.process_code_conversion

2396: --
2397: --
2398: l_location := '0030';
2399: --
2400: vea_tpa_util_pvt.process_code_conversion
2401: (
2402: p_layer_provider_code => p_layer_provider_code,
2403: p_layer_header_id => p_layer_header_id,
2404: p_tps_parameter_id => p_tps_parameter3_id,

Line 2411: vea_tpa_util_pvt.process_code_conversion

2407: --
2408: --
2409: l_location := '0040';
2410: --
2411: vea_tpa_util_pvt.process_code_conversion
2412: (
2413: p_layer_provider_code => p_layer_provider_code,
2414: p_layer_header_id => p_layer_header_id,
2415: p_tps_parameter_id => p_tps_parameter4_id,

Line 2422: vea_tpa_util_pvt.process_code_conversion

2418: --
2419: --
2420: l_location := '0050';
2421: --
2422: vea_tpa_util_pvt.process_code_conversion
2423: (
2424: p_layer_provider_code => p_layer_provider_code,
2425: p_layer_header_id => p_layer_header_id,
2426: p_tps_parameter_id => p_tps_parameter5_id,

Line 2433: vea_tpa_util_pvt.process_code_conversion

2429: --
2430: --
2431: l_location := '0060';
2432: --
2433: vea_tpa_util_pvt.process_code_conversion
2434: (
2435: p_layer_provider_code => p_layer_provider_code,
2436: p_layer_header_id => p_layer_header_id,
2437: p_tps_parameter_id => p_tps_parameter6_id,

Line 2444: vea_tpa_util_pvt.process_code_conversion

2440: --
2441: --
2442: l_location := '0070';
2443: --
2444: vea_tpa_util_pvt.process_code_conversion
2445: (
2446: p_layer_provider_code => p_layer_provider_code,
2447: p_layer_header_id => p_layer_header_id,
2448: p_tps_parameter_id => p_tps_parameter7_id,

Line 2455: vea_tpa_util_pvt.process_code_conversion

2451: --
2452: --
2453: l_location := '0080';
2454: --
2455: vea_tpa_util_pvt.process_code_conversion
2456: (
2457: p_layer_provider_code => p_layer_provider_code,
2458: p_layer_header_id => p_layer_header_id,
2459: p_tps_parameter_id => p_tps_parameter8_id,

Line 2466: vea_tpa_util_pvt.process_code_conversion

2462: --
2463: --
2464: l_location := '0090';
2465: --
2466: vea_tpa_util_pvt.process_code_conversion
2467: (
2468: p_layer_provider_code => p_layer_provider_code,
2469: p_layer_header_id => p_layer_header_id,
2470: p_tps_parameter_id => p_tps_parameter9_id,

Line 2477: vea_tpa_util_pvt.process_code_conversion

2473: --
2474: --
2475: l_location := '0100';
2476: --
2477: vea_tpa_util_pvt.process_code_conversion
2478: (
2479: p_layer_provider_code => p_layer_provider_code,
2480: p_layer_header_id => p_layer_header_id,
2481: p_tps_parameter_id => p_tps_parameter10_id,

Line 2490: vea_tpa_util_pvt.add_exc_message_and_raise

2486: --{
2487: WHEN OTHERS
2488: THEN
2489: --{
2490: vea_tpa_util_pvt.add_exc_message_and_raise
2491: (
2492: p_package_name => G_PACKAGE_NAME,
2493: p_api_name => l_api_name,
2494: p_location => l_location

Line 2565: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;

2561: IS
2562: --{
2563: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS';
2564: l_api_version CONSTANT NUMBER := 1.0;
2565: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;
2566: --
2567: --
2568: l_location VARCHAR2(32767);
2569: l_savepoint_name VARCHAR2(30);

Line 2632: IF NOT( vea_tpa_util_pvt.is_vea_installed() )

2628: BEGIN
2629: --{
2630: l_location := '0010';
2631: --
2632: IF NOT( vea_tpa_util_pvt.is_vea_installed() )
2633: THEN
2634: RETURN;
2635: END IF;
2636: --

Line 2642: vea_tpa_util_pvt.api_header

2638: -- Standard API Header
2639: --
2640: l_location := '0020';
2641: --
2642: vea_tpa_util_pvt.api_header
2643: (
2644: p_package_name => G_PACKAGE_NAME,
2645: p_api_name => l_api_name,
2646: p_api_type => l_api_type,

Line 2701: vea_tpa_util_pvt.add_message_and_raise

2697: p_tps_parameter10_name IS NULL
2698: AND p_tps_parameter10_value IS NOT NULL
2699: )
2700: THEN
2701: vea_tpa_util_pvt.add_message_and_raise
2702: (
2703: p_error_name => 'VEA_INCOMPATIBLE_LAYER_FILE'
2704: );
2705:

Line 2737: vea_tpa_util_pvt.get

2733: --
2734: l_location := '0040';
2735: --
2736: BEGIN
2737: vea_tpa_util_pvt.get
2738: (
2739: p_key => p_new_program_unit_id,
2740: p_cache_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_tbl,
2741: p_cache_ext_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_ext_tbl,

Line 2740: p_cache_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_tbl,

2736: BEGIN
2737: vea_tpa_util_pvt.get
2738: (
2739: p_key => p_new_program_unit_id,
2740: p_cache_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_tbl,
2741: p_cache_ext_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_ext_tbl,
2742: x_value => l_new_program_unit_id
2743: );
2744: EXCEPTION

Line 2741: p_cache_ext_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_ext_tbl,

2737: vea_tpa_util_pvt.get
2738: (
2739: p_key => p_new_program_unit_id,
2740: p_cache_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_tbl,
2741: p_cache_ext_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_ext_tbl,
2742: x_value => l_new_program_unit_id
2743: );
2744: EXCEPTION
2745: WHEN FND_API.G_EXC_ERROR THEN

Line 3096: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code

3092: --{
3093: l_location := '0360';
3094: --
3095: --
3096: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code
3097: THEN
3098: SELECT NVL( p_id, vea_layers_s.NEXTVAL )
3099: INTO l_layer_id
3100: FROM DUAL;

Line 3267: vea_tpa_util_pvt.api_footer

3263: -- Standard API Footer
3264: --
3265: l_location := '0420';
3266: --
3267: vea_tpa_util_pvt.api_footer
3268: (
3269: p_commit => p_commit,
3270: x_msg_count => x_msg_count,
3271: x_msg_data => x_msg_data

Line 3280: vea_tpa_util_pvt.handle_error

3276: WHEN FND_API.G_EXC_ERROR
3277: THEN
3278: --{
3279: --RAISE;
3280: vea_tpa_util_pvt.handle_error
3281: (
3282: p_error_type => vea_tpa_util_pvt.G_ERROR,
3283: p_savepoint_name => l_savepoint_name,
3284: p_package_name => G_PACKAGE_NAME,

Line 3282: p_error_type => vea_tpa_util_pvt.G_ERROR,

3278: --{
3279: --RAISE;
3280: vea_tpa_util_pvt.handle_error
3281: (
3282: p_error_type => vea_tpa_util_pvt.G_ERROR,
3283: p_savepoint_name => l_savepoint_name,
3284: p_package_name => G_PACKAGE_NAME,
3285: p_api_name => l_api_name,
3286: p_location => l_location,

Line 3296: vea_tpa_util_pvt.handle_error

3292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3293: THEN
3294: --{
3295: --RAISE;
3296: vea_tpa_util_pvt.handle_error
3297: (
3298: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
3299: p_savepoint_name => l_savepoint_name,
3300: p_package_name => G_PACKAGE_NAME,

Line 3298: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,

3294: --{
3295: --RAISE;
3296: vea_tpa_util_pvt.handle_error
3297: (
3298: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
3299: p_savepoint_name => l_savepoint_name,
3300: p_package_name => G_PACKAGE_NAME,
3301: p_api_name => l_api_name,
3302: p_location => l_location,

Line 3312: vea_tpa_util_pvt.handle_error

3308: WHEN OTHERS
3309: THEN
3310: --{
3311: --RAISE;
3312: vea_tpa_util_pvt.handle_error
3313: (
3314: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
3315: p_savepoint_name => l_savepoint_name,
3316: p_package_name => G_PACKAGE_NAME,

Line 3314: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,

3310: --{
3311: --RAISE;
3312: vea_tpa_util_pvt.handle_error
3313: (
3314: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
3315: p_savepoint_name => l_savepoint_name,
3316: p_package_name => G_PACKAGE_NAME,
3317: p_api_name => l_api_name,
3318: p_location => l_location,