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_PACKAGES_SV dependencies on VEA_TPA_UTIL_PVT

Line 42: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

38: l_api_name CONSTANT VARCHAR2(30) := 'validateNamingConventions';
39: l_location VARCHAR2(32767);
40: --
41: --
42: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
43: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
44: --
45: --
46: l_curr_layer_provider_code vea_packages.layer_provider_code%TYPE;

Line 43: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

39: l_location VARCHAR2(32767);
40: --
41: --
42: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
43: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
44: --
45: --
46: l_curr_layer_provider_code vea_packages.layer_provider_code%TYPE;
47: l_prefix VARCHAR2(32767);

Line 58: l_curr_layer_provider_code := vea_tpa_util_pvt.get_curr_layer_provider_code;

54: BEGIN
55: --{
56: l_location := '0010';
57: --
58: l_curr_layer_provider_code := vea_tpa_util_pvt.get_curr_layer_provider_code;
59: --
60: --
61: l_location := '0020';
62: --

Line 63: IF l_curr_layer_provider_code = vea_tpa_util_pvt.G_ORACLE

59: --
60: --
61: l_location := '0020';
62: --
63: IF l_curr_layer_provider_code = vea_tpa_util_pvt.G_ORACLE
64: THEN
65: --{
66: l_location := '0030';
67: --

Line 102: || vea_tpa_util_pvt.G_WILD_CARD;

98: --
99: l_location := '0090';
100: --
101: l_file_name_prefix := l_prefix
102: || vea_tpa_util_pvt.G_WILD_CARD;
103: --
104: --
105: l_location := '0100';
106: --

Line 109: || vea_tpa_util_pvt.G_UNDERSCORE

105: l_location := '0100';
106: --
107: l_package_name_prefix := l_prefix
108: || '\'
109: || vea_tpa_util_pvt.G_UNDERSCORE
110: || vea_tpa_util_pvt.G_WILD_CARD;
111: --
112: --
113: l_location := '0110';

Line 110: || vea_tpa_util_pvt.G_WILD_CARD;

106: --
107: l_package_name_prefix := l_prefix
108: || '\'
109: || vea_tpa_util_pvt.G_UNDERSCORE
110: || vea_tpa_util_pvt.G_WILD_CARD;
111: --
112: --
113: l_location := '0110';
114: --

Line 120: vea_tpa_util_pvt.add_message_and_raise

116: THEN
117: --{
118: l_location := '0120';
119: --
120: vea_tpa_util_pvt.add_message_and_raise
121: (
122: p_error_name => l_package_message_name,
123: p_token1 => 'PACKAGE_NAME',
124: p_value1 => p_name

Line 137: vea_tpa_util_pvt.add_message_and_raise

133: THEN
134: --{
135: l_location := '0140';
136: --
137: vea_tpa_util_pvt.add_message_and_raise
138: (
139: p_error_name => l_file_message_name,
140: p_token1 => 'FILE_NAME',
141: p_value1 => p_specification_filename

Line 155: vea_tpa_util_pvt.add_message_and_raise

151: THEN
152: --{
153: l_location := '0160';
154: --
155: vea_tpa_util_pvt.add_message_and_raise
156: (
157: p_error_name => l_file_message_name,
158: p_token1 => 'FILE_NAME',
159: p_value1 => p_body_filename

Line 174: vea_tpa_util_pvt.add_exc_message_and_raise

170: --}
171: WHEN OTHERS
172: THEN
173: --{
174: vea_tpa_util_pvt.add_exc_message_and_raise
175: (
176: p_package_name => G_PACKAGE_NAME,
177: p_api_name => l_api_name,
178: p_location => l_location

Line 207: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

203: l_api_name CONSTANT VARCHAR2(30) := 'validateUniqueServerFileNames';
204: l_location VARCHAR2(32767);
205: --
206: --
207: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
208: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
209: --
210: --
211: CURSOR pkg_spec_file_cur

Line 208: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

204: l_location VARCHAR2(32767);
205: --
206: --
207: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
208: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
209: --
210: --
211: CURSOR pkg_spec_file_cur
212: (

Line 252: vea_tpa_util_pvt.add_message_and_raise

248: THEN
249: --{
250: l_location := '0030';
251: --
252: vea_tpa_util_pvt.add_message_and_raise
253: (
254: p_error_name => 'VEA_IMPORT_UNIQ_SPEC_FILE',
255: p_token1 => 'FILE_NAME',
256: p_value1 => p_specification_filename,

Line 289: vea_tpa_util_pvt.add_message_and_raise

285: THEN
286: --{
287: l_location := '0070';
288: --
289: vea_tpa_util_pvt.add_message_and_raise
290: (
291: p_error_name => 'VEA_IMPORT_UNIQ_BODY_FILE',
292: p_token1 => 'FILE_NAME',
293: p_value1 => p_body_filename,

Line 316: vea_tpa_util_pvt.add_exc_message_and_raise

312: --}
313: WHEN OTHERS
314: THEN
315: --{
316: vea_tpa_util_pvt.add_exc_message_and_raise
317: (
318: p_package_name => G_PACKAGE_NAME,
319: p_api_name => l_api_name,
320: p_location => l_location

Line 350: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

346: l_api_name CONSTANT VARCHAR2(30) := 'validateUniqueClientFileNames';
347: l_location VARCHAR2(32767);
348: --
349: --
350: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
351: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
352: --
353: --
354: CURSOR pkg_spec_file_cur

Line 351: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

347: l_location VARCHAR2(32767);
348: --
349: --
350: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
351: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
352: --
353: --
354: CURSOR pkg_spec_file_cur
355: (

Line 384: vea_tpa_util_pvt.add_message_and_raise

380: THEN
381: --{
382: l_location := '0030';
383: --
384: vea_tpa_util_pvt.add_message_and_raise
385: (
386: p_error_name => 'VEA_IMPORT_UNIQ_CLIENT_FILE',
387: p_token1 => 'FILE_NAME',
388: p_value1 => p_specification_filename,

Line 409: vea_tpa_util_pvt.add_exc_message_and_raise

405: --}
406: WHEN OTHERS
407: THEN
408: --{
409: vea_tpa_util_pvt.add_exc_message_and_raise
410: (
411: p_package_name => G_PACKAGE_NAME,
412: p_api_name => l_api_name,
413: p_location => l_location

Line 450: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

446: l_api_name CONSTANT VARCHAR2(30) := 'validate';
447: l_location VARCHAR2(32767);
448: --
449: --
450: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
451: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
452: --}
453: BEGIN
454: --{

Line 451: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

447: l_location VARCHAR2(32767);
448: --
449: --
450: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
451: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
452: --}
453: BEGIN
454: --{
455: l_location := '0010';

Line 457: IF vea_tpa_util_pvt.validate

453: BEGIN
454: --{
455: l_location := '0010';
456: --
457: IF vea_tpa_util_pvt.validate
458: AND NOT(vea_tpa_util_pvt.isLayerMergeOn)
459: THEN
460: --{
461: l_location := '0020';

Line 458: AND NOT(vea_tpa_util_pvt.isLayerMergeOn)

454: --{
455: l_location := '0010';
456: --
457: IF vea_tpa_util_pvt.validate
458: AND NOT(vea_tpa_util_pvt.isLayerMergeOn)
459: THEN
460: --{
461: l_location := '0020';
462: --

Line 516: vea_tpa_util_pvt.add_exc_message_and_raise

512: --}
513: WHEN OTHERS
514: THEN
515: --{
516: vea_tpa_util_pvt.add_exc_message_and_raise
517: (
518: p_package_name => G_PACKAGE_NAME,
519: p_api_name => l_api_name,
520: p_location => l_location

Line 557: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

553: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
554: l_location VARCHAR2(32767);
555: --
556: --
557: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
558: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
559: --}
560: BEGIN
561: --{

Line 558: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

554: l_location VARCHAR2(32767);
555: --
556: --
557: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
558: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
559: --}
560: BEGIN
561: --{
562: l_location := '0010';

Line 598: vea_tpa_util_pvt.add_exc_message_and_raise

594: --{
595: WHEN OTHERS
596: THEN
597: --{
598: vea_tpa_util_pvt.add_exc_message_and_raise
599: (
600: p_package_name => G_PACKAGE_NAME,
601: p_api_name => l_api_name,
602: p_location => l_location

Line 639: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

635: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
636: l_location VARCHAR2(32767);
637: --
638: --
639: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
640: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
641: --}
642: BEGIN
643: --{

Line 640: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

636: l_location VARCHAR2(32767);
637: --
638: --
639: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
640: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
641: --}
642: BEGIN
643: --{
644: l_location := '0010';

Line 669: vea_tpa_util_pvt.add_exc_message_and_raise

665: --{
666: WHEN OTHERS
667: THEN
668: --{
669: vea_tpa_util_pvt.add_exc_message_and_raise
670: (
671: p_package_name => G_PACKAGE_NAME,
672: p_api_name => l_api_name,
673: p_location => l_location

Line 694: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

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

Line 695: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

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

Line 703: IF vea_tpa_util_pvt.get_curr_layer_provider_code = vea_tpa_util_pvt.G_ORACLE

699: BEGIN
700: --{
701: l_location := '0010';
702: --
703: IF vea_tpa_util_pvt.get_curr_layer_provider_code = vea_tpa_util_pvt.G_ORACLE
704: THEN
705: --{
706: delete vea_packages PK
707: where tpa_flag = 'Y'

Line 721: vea_tpa_util_pvt.add_exc_message_and_raise

717: --{
718: WHEN OTHERS
719: THEN
720: --{
721: vea_tpa_util_pvt.add_exc_message_and_raise
722: (
723: p_package_name => G_PACKAGE_NAME,
724: p_api_name => l_api_name,
725: p_location => l_location

Line 769: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

765: l_api_name CONSTANT VARCHAR2(30) := 'delete_rows';
766: l_location VARCHAR2(32767);
767: --
768: --
769: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
770: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
771: --
772: --
773: CURSOR package_cur

Line 770: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

766: l_location VARCHAR2(32767);
767: --
768: --
769: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
770: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
771: --
772: --
773: CURSOR package_cur
774: (

Line 865: vea_tpa_util_pvt.add_exc_message_and_raise

861: --{
862: WHEN OTHERS
863: THEN
864: --{
865: vea_tpa_util_pvt.add_exc_message_and_raise
866: (
867: p_package_name => G_PACKAGE_NAME,
868: p_api_name => l_api_name,
869: p_location => l_location

Line 925: vea_tpa_util_pvt.add_exc_message_and_raise

921: --{
922: WHEN OTHERS
923: THEN
924: --{
925: vea_tpa_util_pvt.add_exc_message_and_raise
926: (
927: p_package_name => G_PACKAGE_NAME,
928: p_api_name => l_api_name,
929: p_location => l_location

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

958: IS
959: --{
960: l_api_name CONSTANT VARCHAR2(30) := 'updateVersionNumber';
961: l_api_version CONSTANT NUMBER := 1.0;
962: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;
963: --
964: --
965: l_location VARCHAR2(32767);
966: l_savepoint_name VARCHAR2(30);

Line 978: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

974: AND package_id = p_package_id;
975: --
976: --
977: l_version_number vea_packages.version_number%TYPE;
978: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
979: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
980:
981: l_version_text VARCHAR2(200);
982:

Line 979: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

975: --
976: --
977: l_version_number vea_packages.version_number%TYPE;
978: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
979: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
980:
981: l_version_text VARCHAR2(200);
982:
983: --}

Line 991: vea_tpa_util_pvt.api_header

987: -- Standard API Header
988: --
989: l_location := '0010';
990: --
991: vea_tpa_util_pvt.api_header
992: (
993: p_package_name => G_PACKAGE_NAME,
994: p_api_name => l_api_name,
995: p_api_type => l_api_type,

Line 1062: vea_tpa_util_pvt.api_footer

1058: -- Standard API Footer
1059: --
1060: l_location := '0060';
1061: --
1062: vea_tpa_util_pvt.api_footer
1063: (
1064: p_commit => p_commit,
1065: x_msg_count => x_msg_count,
1066: x_msg_data => x_msg_data

Line 1075: vea_tpa_util_pvt.handle_error

1071: WHEN FND_API.G_EXC_ERROR
1072: THEN
1073: --{
1074: --RAISE;
1075: vea_tpa_util_pvt.handle_error
1076: (
1077: p_error_type => vea_tpa_util_pvt.G_ERROR,
1078: p_savepoint_name => l_savepoint_name,
1079: p_package_name => G_PACKAGE_NAME,

Line 1077: p_error_type => vea_tpa_util_pvt.G_ERROR,

1073: --{
1074: --RAISE;
1075: vea_tpa_util_pvt.handle_error
1076: (
1077: p_error_type => vea_tpa_util_pvt.G_ERROR,
1078: p_savepoint_name => l_savepoint_name,
1079: p_package_name => G_PACKAGE_NAME,
1080: p_api_name => l_api_name,
1081: p_location => l_location,

Line 1091: vea_tpa_util_pvt.handle_error

1087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1088: THEN
1089: --{
1090: --RAISE;
1091: vea_tpa_util_pvt.handle_error
1092: (
1093: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
1094: p_savepoint_name => l_savepoint_name,
1095: p_package_name => G_PACKAGE_NAME,

Line 1093: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,

1089: --{
1090: --RAISE;
1091: vea_tpa_util_pvt.handle_error
1092: (
1093: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
1094: p_savepoint_name => l_savepoint_name,
1095: p_package_name => G_PACKAGE_NAME,
1096: p_api_name => l_api_name,
1097: p_location => l_location,

Line 1107: vea_tpa_util_pvt.handle_error

1103: WHEN OTHERS
1104: THEN
1105: --{
1106: --RAISE;
1107: vea_tpa_util_pvt.handle_error
1108: (
1109: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
1110: p_savepoint_name => l_savepoint_name,
1111: p_package_name => G_PACKAGE_NAME,

Line 1109: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,

1105: --{
1106: --RAISE;
1107: vea_tpa_util_pvt.handle_error
1108: (
1109: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
1110: p_savepoint_name => l_savepoint_name,
1111: p_package_name => G_PACKAGE_NAME,
1112: p_api_name => l_api_name,
1113: p_location => l_location,

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

1146: IS
1147: --{
1148: l_api_name CONSTANT VARCHAR2(30) := 'updateVersionNumber';
1149: l_api_version CONSTANT NUMBER := 1.0;
1150: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;
1151: --
1152: --
1153: l_location VARCHAR2(32767);
1154: l_savepoint_name VARCHAR2(30);

Line 1169: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

1165:
1166: --
1167: --
1168: l_version_number vea_packages.version_number%TYPE;
1169: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
1170: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
1171: --
1172: --
1173: l_version_text VARCHAR2(200);

Line 1170: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

1166: --
1167: --
1168: l_version_number vea_packages.version_number%TYPE;
1169: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
1170: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
1171: --
1172: --
1173: l_version_text VARCHAR2(200);
1174: --}

Line 1182: vea_tpa_util_pvt.api_header

1178: -- Standard API Header
1179: --
1180: l_location := '0010';
1181: --
1182: vea_tpa_util_pvt.api_header
1183: (
1184: p_package_name => G_PACKAGE_NAME,
1185: p_api_name => l_api_name,
1186: p_api_type => l_api_type,

Line 1251: vea_tpa_util_pvt.api_footer

1247: -- Standard API Footer
1248: --
1249: l_location := '0060';
1250: --
1251: vea_tpa_util_pvt.api_footer
1252: (
1253: p_commit => p_commit,
1254: x_msg_count => x_msg_count,
1255: x_msg_data => x_msg_data

Line 1264: vea_tpa_util_pvt.handle_error

1260: WHEN FND_API.G_EXC_ERROR
1261: THEN
1262: --{
1263: --RAISE;
1264: vea_tpa_util_pvt.handle_error
1265: (
1266: p_error_type => vea_tpa_util_pvt.G_ERROR,
1267: p_savepoint_name => l_savepoint_name,
1268: p_package_name => G_PACKAGE_NAME,

Line 1266: p_error_type => vea_tpa_util_pvt.G_ERROR,

1262: --{
1263: --RAISE;
1264: vea_tpa_util_pvt.handle_error
1265: (
1266: p_error_type => vea_tpa_util_pvt.G_ERROR,
1267: p_savepoint_name => l_savepoint_name,
1268: p_package_name => G_PACKAGE_NAME,
1269: p_api_name => l_api_name,
1270: p_location => l_location,

Line 1280: vea_tpa_util_pvt.handle_error

1276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1277: THEN
1278: --{
1279: --RAISE;
1280: vea_tpa_util_pvt.handle_error
1281: (
1282: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
1283: p_savepoint_name => l_savepoint_name,
1284: p_package_name => G_PACKAGE_NAME,

Line 1282: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,

1278: --{
1279: --RAISE;
1280: vea_tpa_util_pvt.handle_error
1281: (
1282: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
1283: p_savepoint_name => l_savepoint_name,
1284: p_package_name => G_PACKAGE_NAME,
1285: p_api_name => l_api_name,
1286: p_location => l_location,

Line 1296: vea_tpa_util_pvt.handle_error

1292: WHEN OTHERS
1293: THEN
1294: --{
1295: --RAISE;
1296: vea_tpa_util_pvt.handle_error
1297: (
1298: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
1299: p_savepoint_name => l_savepoint_name,
1300: p_package_name => G_PACKAGE_NAME,

Line 1298: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,

1294: --{
1295: --RAISE;
1296: vea_tpa_util_pvt.handle_error
1297: (
1298: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
1299: p_savepoint_name => l_savepoint_name,
1300: p_package_name => G_PACKAGE_NAME,
1301: p_api_name => l_api_name,
1302: p_location => l_location,

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

1416: IS
1417: --{
1418: l_api_name CONSTANT VARCHAR2(30) := 'process';
1419: l_api_version CONSTANT NUMBER := 1.0;
1420: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;
1421: --
1422: --
1423: l_location VARCHAR2(32767);
1424: l_savepoint_name VARCHAR2(30);

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

1464: BEGIN
1465: --{
1466: l_location := '0010';
1467: --
1468: IF NOT( vea_tpa_util_pvt.is_vea_installed() )
1469: THEN
1470: RETURN;
1471: END IF;
1472: --

Line 1478: vea_tpa_util_pvt.api_header

1474: -- Standard API Header
1475: --
1476: l_location := '0020';
1477: --
1478: vea_tpa_util_pvt.api_header
1479: (
1480: p_package_name => G_PACKAGE_NAME,
1481: p_api_name => l_api_name,
1482: p_api_type => l_api_type,

Line 1499: IF (VEA_TPA_UTIL_PVT.isLayerMergeOn)

1495: --g_package_id := p_id;
1496: l_tp_layer_id := p_tp_layer_id;
1497: g_tp_layer_id := NULL;
1498: --
1499: IF (VEA_TPA_UTIL_PVT.isLayerMergeOn)
1500: AND p_tp_layer_id IS NOT NULL
1501: THEN
1502: --{
1503: vea_tpa_util_pvt.get

Line 1503: vea_tpa_util_pvt.get

1499: IF (VEA_TPA_UTIL_PVT.isLayerMergeOn)
1500: AND p_tp_layer_id IS NOT NULL
1501: THEN
1502: --{
1503: vea_tpa_util_pvt.get
1504: (
1505: p_key => p_tp_layer_id,
1506: p_cache_tbl => VEA_TPA_UTIL_PVT.g_tpLyr_fileId_dbId_tbl,
1507: p_cache_ext_tbl => VEA_TPA_UTIL_PVT.g_tpLyr_fileId_dbId_ext_tbl,

Line 1506: p_cache_tbl => VEA_TPA_UTIL_PVT.g_tpLyr_fileId_dbId_tbl,

1502: --{
1503: vea_tpa_util_pvt.get
1504: (
1505: p_key => p_tp_layer_id,
1506: p_cache_tbl => VEA_TPA_UTIL_PVT.g_tpLyr_fileId_dbId_tbl,
1507: p_cache_ext_tbl => VEA_TPA_UTIL_PVT.g_tpLyr_fileId_dbId_ext_tbl,
1508: x_value => l_tp_layer_id
1509: );
1510: --}

Line 1507: p_cache_ext_tbl => VEA_TPA_UTIL_PVT.g_tpLyr_fileId_dbId_ext_tbl,

1503: vea_tpa_util_pvt.get
1504: (
1505: p_key => p_tp_layer_id,
1506: p_cache_tbl => VEA_TPA_UTIL_PVT.g_tpLyr_fileId_dbId_tbl,
1507: p_cache_ext_tbl => VEA_TPA_UTIL_PVT.g_tpLyr_fileId_dbId_ext_tbl,
1508: x_value => l_tp_layer_id
1509: );
1510: --}
1511: ELSE

Line 1562: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code

1558: l_location := '0070';
1559: --
1560: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Inserting a row in vea_packages');
1561: --
1562: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code
1563: THEN
1564: SELECT NVL( p_id, vea_packages_s.NEXTVAL )
1565: INTO l_package_id
1566: FROM DUAL;

Line 1678: vea_tpa_util_pvt.api_footer

1674: -- Standard API Footer
1675: --
1676: l_location := '0130';
1677: --
1678: vea_tpa_util_pvt.api_footer
1679: (
1680: p_commit => p_commit,
1681: x_msg_count => x_msg_count,
1682: x_msg_data => x_msg_data

Line 1691: vea_tpa_util_pvt.handle_error

1687: WHEN FND_API.G_EXC_ERROR
1688: THEN
1689: --{
1690: --RAISE;
1691: vea_tpa_util_pvt.handle_error
1692: (
1693: p_error_type => vea_tpa_util_pvt.G_ERROR,
1694: p_savepoint_name => l_savepoint_name,
1695: p_package_name => G_PACKAGE_NAME,

Line 1693: p_error_type => vea_tpa_util_pvt.G_ERROR,

1689: --{
1690: --RAISE;
1691: vea_tpa_util_pvt.handle_error
1692: (
1693: p_error_type => vea_tpa_util_pvt.G_ERROR,
1694: p_savepoint_name => l_savepoint_name,
1695: p_package_name => G_PACKAGE_NAME,
1696: p_api_name => l_api_name,
1697: p_location => l_location,

Line 1707: vea_tpa_util_pvt.handle_error

1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1704: THEN
1705: --{
1706: --RAISE;
1707: vea_tpa_util_pvt.handle_error
1708: (
1709: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
1710: p_savepoint_name => l_savepoint_name,
1711: p_package_name => G_PACKAGE_NAME,

Line 1709: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,

1705: --{
1706: --RAISE;
1707: vea_tpa_util_pvt.handle_error
1708: (
1709: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
1710: p_savepoint_name => l_savepoint_name,
1711: p_package_name => G_PACKAGE_NAME,
1712: p_api_name => l_api_name,
1713: p_location => l_location,

Line 1723: vea_tpa_util_pvt.handle_error

1719: WHEN OTHERS
1720: THEN
1721: --{
1722: --RAISE;
1723: vea_tpa_util_pvt.handle_error
1724: (
1725: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
1726: p_savepoint_name => l_savepoint_name,
1727: p_package_name => G_PACKAGE_NAME,

Line 1725: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,

1721: --{
1722: --RAISE;
1723: vea_tpa_util_pvt.handle_error
1724: (
1725: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
1726: p_savepoint_name => l_savepoint_name,
1727: p_package_name => G_PACKAGE_NAME,
1728: p_api_name => l_api_name,
1729: p_location => l_location,