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.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_AAD_LOADER_UTIL_PVT

Line 1: PACKAGE BODY xla_aad_loader_util_pvt AS

1: PACKAGE BODY xla_aad_loader_util_pvt AS
2: /* $Header: xlaalutl.pkb 120.20.12020000.2 2013/01/30 11:57:19 sgullape ship $ */
3:
4: --=============================================================================
5: -- **************** declaraions ********************

Line 35: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_aad_loader_util_pvt';

31: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
32: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
33:
34: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
35: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_aad_loader_util_pvt';
36:
37: g_log_level NUMBER;
38: g_log_enabled BOOLEAN;
39:

Line 59: (p_location => 'xla_aad_loader_util_pvt.trace');

55: RAISE;
56:
57: WHEN OTHERS THEN
58: xla_exceptions_pkg.raise_message
59: (p_location => 'xla_aad_loader_util_pvt.trace');
60: END trace;
61:
62:
63: --=============================================================================

Line 161: xla_aad_loader_util_pvt.stack_error

157: END IF;
158: return l_code;
159: EXCEPTION
160: WHEN OTHERS THEN
161: xla_aad_loader_util_pvt.stack_error
162: (p_appli_s_name => 'XLA'
163: ,p_msg_name => 'XLA_COMMON_ERROR'
164: ,p_token_1 => 'LOCATION'
165: ,p_value_1 => 'xla_aad_loader_util_pvt.create_staging_context_code'

Line 165: ,p_value_1 => 'xla_aad_loader_util_pvt.create_staging_context_code'

161: xla_aad_loader_util_pvt.stack_error
162: (p_appli_s_name => 'XLA'
163: ,p_msg_name => 'XLA_COMMON_ERROR'
164: ,p_token_1 => 'LOCATION'
165: ,p_value_1 => 'xla_aad_loader_util_pvt.create_staging_context_code'
166: ,p_token_2 => 'ERROR'
167: ,p_value_2 => 'unhandled exception');
168: RAISE;
169:

Line 222: xla_aad_loader_util_pvt.insert_aadloaderlog(

218: AND amb_context_code = p_amb_context_code;
219:
220: -- Bug : --Bug 16208537
221: -- API Call to Insert messages into AAD Loader Log Table.
222: xla_aad_loader_util_pvt.insert_aadloaderlog(
223: p_amb_context_code => p_amb_context_code,
224: p_application_id => p_application_id,
225: p_request_code => 'IMPORT' ,
226: p_log_type_code => 'MERGE',

Line 245: xla_aad_loader_util_pvt.insert_aadloaderlog(

241: AND amb_context_code = p_amb_context_code;
242:
243: -- Bug : 16208537
244: -- API Call to Insert messages into AAD Loader Log Table.
245: xla_aad_loader_util_pvt.insert_aadloaderlog(
246: p_amb_context_code => p_amb_context_code,
247: p_application_id => p_application_id,
248: p_request_code => 'IMPORT' ,
249: p_log_type_code => 'MERGE',

Line 265: xla_aad_loader_util_pvt.insert_aadloaderlog(

261: AND amb_context_code = p_amb_context_code;
262:
263: -- Bug : 16208537
264: -- API Call to Insert messages into AAD Loader Log Table.
265: xla_aad_loader_util_pvt.insert_aadloaderlog(
266: p_amb_context_code => p_amb_context_code,
267: p_application_id => p_application_id,
268: p_request_code => 'IMPORT' ,
269: p_log_type_code => 'MERGE',

Line 285: xla_aad_loader_util_pvt.insert_aadloaderlog(

281: AND amb_context_code = p_amb_context_code;
282:
283: -- Bug : 16208537
284: -- API Call to Insert messages into AAD Loader Log Table.
285: xla_aad_loader_util_pvt.insert_aadloaderlog(
286: p_amb_context_code => p_amb_context_code,
287: p_application_id => p_application_id,
288: p_request_code => 'IMPORT' ,
289: p_log_type_code => 'MERGE',

Line 305: xla_aad_loader_util_pvt.insert_aadloaderlog(

301: AND amb_context_code = p_amb_context_code;
302:
303: -- Bug : 16208537
304: -- API Call to Insert messages into AAD Loader Log Table.
305: xla_aad_loader_util_pvt.insert_aadloaderlog(
306: p_amb_context_code => p_amb_context_code,
307: p_application_id => p_application_id,
308: p_request_code => 'IMPORT' ,
309: p_log_type_code => 'MERGE',

Line 325: xla_aad_loader_util_pvt.insert_aadloaderlog(

321: AND amb_context_code = p_amb_context_code;
322:
323: -- Bug : 16208537
324: -- API Call to Insert messages into AAD Loader Log Table.
325: xla_aad_loader_util_pvt.insert_aadloaderlog(
326: p_amb_context_code => p_amb_context_code,
327: p_application_id => p_application_id,
328: p_request_code => 'IMPORT' ,
329: p_log_type_code => 'MERGE',

Line 345: xla_aad_loader_util_pvt.insert_aadloaderlog(

341: AND amb_context_code = p_amb_context_code;
342:
343: -- Bug : 16208537
344: -- API Call to Insert messages into AAD Loader Log Table.
345: xla_aad_loader_util_pvt.insert_aadloaderlog(
346: p_amb_context_code => p_amb_context_code,
347: p_application_id => p_application_id,
348: p_request_code => 'IMPORT' ,
349: p_log_type_code => 'MERGE',

Line 365: xla_aad_loader_util_pvt.insert_aadloaderlog(

361: AND amb_context_code = p_amb_context_code;
362:
363: -- Bug : 16208537
364: -- API Call to Insert messages into AAD Loader Log Table.
365: xla_aad_loader_util_pvt.insert_aadloaderlog(
366: p_amb_context_code => p_amb_context_code,
367: p_application_id => p_application_id,
368: p_request_code => 'IMPORT' ,
369: p_log_type_code => 'MERGE',

Line 385: xla_aad_loader_util_pvt.insert_aadloaderlog(

381: AND amb_context_code = p_amb_context_code;
382:
383: -- Bug : 16208537
384: -- API Call to Insert messages into AAD Loader Log Table.
385: xla_aad_loader_util_pvt.insert_aadloaderlog(
386: p_amb_context_code => p_amb_context_code,
387: p_application_id => p_application_id,
388: p_request_code => 'IMPORT' ,
389: p_log_type_code => 'MERGE',

Line 405: xla_aad_loader_util_pvt.insert_aadloaderlog(

401: AND amb_context_code = p_amb_context_code;
402:
403: -- Bug : 16208537
404: -- API Call to Insert messages into AAD Loader Log Table.
405: xla_aad_loader_util_pvt.insert_aadloaderlog(
406: p_amb_context_code => p_amb_context_code,
407: p_application_id => p_application_id,
408: p_request_code => 'IMPORT' ,
409: p_log_type_code => 'MERGE',

Line 425: xla_aad_loader_util_pvt.insert_aadloaderlog(

421: AND amb_context_code = p_amb_context_code;
422:
423: -- Bug : 16208537
424: -- API Call to Insert messages into AAD Loader Log Table.
425: xla_aad_loader_util_pvt.insert_aadloaderlog(
426: p_amb_context_code => p_amb_context_code,
427: p_application_id => p_application_id,
428: p_request_code => 'IMPORT' ,
429: p_log_type_code => 'MERGE',

Line 445: xla_aad_loader_util_pvt.insert_aadloaderlog(

441: AND amb_context_code = p_amb_context_code;
442:
443: -- Bug : 16208537
444: -- API Call to Insert messages into AAD Loader Log Table.
445: xla_aad_loader_util_pvt.insert_aadloaderlog(
446: p_amb_context_code => p_amb_context_code,
447: p_application_id => p_application_id,
448: p_request_code => 'IMPORT' ,
449: p_log_type_code => 'MERGE',

Line 465: xla_aad_loader_util_pvt.insert_aadloaderlog(

461: AND amb_context_code = p_amb_context_code;
462:
463: -- Bug : 16208537
464: -- API Call to Insert messages into AAD Loader Log Table.
465: xla_aad_loader_util_pvt.insert_aadloaderlog(
466: p_amb_context_code => p_amb_context_code,
467: p_application_id => p_application_id,
468: p_request_code => 'IMPORT' ,
469: p_log_type_code => 'MERGE',

Line 485: xla_aad_loader_util_pvt.insert_aadloaderlog(

481: AND amb_context_code = p_amb_context_code;
482:
483: -- Bug : 16208537
484: -- API Call to Insert messages into AAD Loader Log Table.
485: xla_aad_loader_util_pvt.insert_aadloaderlog(
486: p_amb_context_code => p_amb_context_code,
487: p_application_id => p_application_id,
488: p_request_code => 'IMPORT' ,
489: p_log_type_code => 'MERGE',

Line 508: xla_aad_loader_util_pvt.insert_aadloaderlog(

504: AND amb_context_code = p_amb_context_code;
505:
506: -- Bug : 16208537
507: -- API Call to Insert messages into AAD Loader Log Table.
508: xla_aad_loader_util_pvt.insert_aadloaderlog(
509: p_amb_context_code => p_amb_context_code,
510: p_application_id => p_application_id,
511: p_request_code => 'IMPORT' ,
512: p_log_type_code => 'MERGE',

Line 528: xla_aad_loader_util_pvt.insert_aadloaderlog(

524: AND amb_context_code = p_amb_context_code;
525:
526: -- Bug : 16208537
527: -- API Call to Insert messages into AAD Loader Log Table.
528: xla_aad_loader_util_pvt.insert_aadloaderlog(
529: p_amb_context_code => p_amb_context_code,
530: p_application_id => p_application_id,
531: p_request_code => 'IMPORT' ,
532: p_log_type_code => 'MERGE',

Line 552: xla_aad_loader_util_pvt.insert_aadloaderlog(

548: AND segment_rule_detail_id IS NULL; -- bug 4367287: delete ADR on demand
549:
550: -- Bug : 16208537
551: -- API Call to Insert messages into AAD Loader Log Table.
552: xla_aad_loader_util_pvt.insert_aadloaderlog(
553: p_amb_context_code => p_amb_context_code,
554: p_application_id => p_application_id,
555: p_request_code => 'IMPORT' ,
556: p_log_type_code => 'MERGE',

Line 616: xla_aad_loader_util_pvt.insert_aadloaderlog(

612: AND dp.amb_context_code = p_amb_context_code);
613:
614: -- Bug : 16208537
615: -- API Call to Insert messages into AAD Loader Log Table.
616: xla_aad_loader_util_pvt.insert_aadloaderlog(
617: p_amb_context_code => p_amb_context_code,
618: p_application_id => p_application_id,
619: p_request_code => 'IMPORT' ,
620: p_log_type_code => 'MERGE',

Line 639: xla_aad_loader_util_pvt.insert_aadloaderlog(

635: AND amb_context_code = p_amb_context_code);
636:
637: -- Bug : 16208537
638: -- API Call to Insert messages into AAD Loader Log Table.
639: xla_aad_loader_util_pvt.insert_aadloaderlog(
640: p_amb_context_code => p_amb_context_code,
641: p_application_id => p_application_id,
642: p_request_code => 'IMPORT' ,
643: p_log_type_code => 'MERGE',

Line 659: xla_aad_loader_util_pvt.insert_aadloaderlog(

655: AND amb_context_code = p_amb_context_code;
656:
657: -- Bug : 16208537
658: -- API Call to Insert messages into AAD Loader Log Table.
659: xla_aad_loader_util_pvt.insert_aadloaderlog(
660: p_amb_context_code => p_amb_context_code,
661: p_application_id => p_application_id,
662: p_request_code => 'IMPORT' ,
663: p_log_type_code => 'MERGE',

Line 679: xla_aad_loader_util_pvt.insert_aadloaderlog(

675: AND amb_context_code = p_amb_context_code;
676:
677: -- Bug : 16208537
678: -- API Call to Insert messages into AAD Loader Log Table.
679: xla_aad_loader_util_pvt.insert_aadloaderlog(
680: p_amb_context_code => p_amb_context_code,
681: p_application_id => p_application_id,
682: p_request_code => 'IMPORT' ,
683: p_log_type_code => 'MERGE',

Line 699: xla_aad_loader_util_pvt.insert_aadloaderlog(

695: AND amb_context_code = p_amb_context_code;
696:
697: -- Bug : 16208537
698: -- API Call to Insert messages into AAD Loader Log Table.
699: xla_aad_loader_util_pvt.insert_aadloaderlog(
700: p_amb_context_code => p_amb_context_code,
701: p_application_id => p_application_id,
702: p_request_code => 'IMPORT' ,
703: p_log_type_code => 'MERGE',

Line 722: xla_aad_loader_util_pvt.insert_aadloaderlog(

718: AND amb_context_code = p_amb_context_code;
719:
720: -- Bug : 16208537
721: -- API Call to Insert messages into AAD Loader Log Table.
722: xla_aad_loader_util_pvt.insert_aadloaderlog(
723: p_amb_context_code => p_amb_context_code,
724: p_application_id => p_application_id,
725: p_request_code => 'IMPORT' ,
726: p_log_type_code => 'MERGE',

Line 742: xla_aad_loader_util_pvt.insert_aadloaderlog(

738: AND amb_context_code = p_amb_context_code;
739:
740: -- Bug : 16208537
741: -- API Call to Insert messages into AAD Loader Log Table.
742: xla_aad_loader_util_pvt.insert_aadloaderlog(
743: p_amb_context_code => p_amb_context_code,
744: p_application_id => p_application_id,
745: p_request_code => 'IMPORT' ,
746: p_log_type_code => 'MERGE',

Line 762: xla_aad_loader_util_pvt.insert_aadloaderlog(

758: AND amb_context_code = p_amb_context_code;
759:
760: -- Bug : 16208537
761: -- API Call to Insert messages into AAD Loader Log Table.
762: xla_aad_loader_util_pvt.insert_aadloaderlog(
763: p_amb_context_code => p_amb_context_code,
764: p_application_id => p_application_id,
765: p_request_code => 'IMPORT' ,
766: p_log_type_code => 'MERGE',

Line 783: xla_aad_loader_util_pvt.stack_error

779: p_level => C_LEVEL_PROCEDURE);
780: END IF;
781: EXCEPTION
782: WHEN OTHERS THEN
783: xla_aad_loader_util_pvt.stack_error
784: (p_appli_s_name => 'XLA'
785: ,p_msg_name => 'XLA_COMMON_ERROR'
786: ,p_token_1 => 'LOCATION'
787: ,p_value_1 => 'xla_aad_loader_util_pvt.purge'

Line 787: ,p_value_1 => 'xla_aad_loader_util_pvt.purge'

783: xla_aad_loader_util_pvt.stack_error
784: (p_appli_s_name => 'XLA'
785: ,p_msg_name => 'XLA_COMMON_ERROR'
786: ,p_token_1 => 'LOCATION'
787: ,p_value_1 => 'xla_aad_loader_util_pvt.purge'
788: ,p_token_2 => 'ERROR'
789: ,p_value_2 => sqlcode ||' - '||sqlerrm); --16208537
790: RAISE;
791:

Line 1154: xla_aad_loader_util_pvt.insert_aadloaderlog(

1150: l_retcode := 'SUCCESS';
1151:
1152: -- Bug : 12969337
1153: -- API Call to Insert messages into AAD Loader Log Table.
1154: xla_aad_loader_util_pvt.insert_aadloaderlog(
1155: p_amb_context_code => p_amb_context_code,
1156: p_application_id => p_application_id,
1157: p_request_code => 'IMPORT' ,
1158: p_log_type_code => 'MERGE',

Line 1173: xla_aad_loader_util_pvt.insert_aadloaderlog(

1169: CLOSE c_product_rules_b;
1170:
1171: -- Bug : 12969337
1172: -- API Call to Insert messages into AAD Loader Log Table.
1173: xla_aad_loader_util_pvt.insert_aadloaderlog(
1174: p_amb_context_code => p_amb_context_code,
1175: p_application_id => p_application_id,
1176: p_request_code => 'IMPORT' ,
1177: p_log_type_code => 'MERGE',

Line 1192: xla_aad_loader_util_pvt.insert_aadloaderlog(

1188: CLOSE c_product_rules_tl;
1189:
1190: -- Bug : 12969337
1191: -- API Call to Insert messages into AAD Loader Log Table.
1192: xla_aad_loader_util_pvt.insert_aadloaderlog(
1193: p_amb_context_code => p_amb_context_code,
1194: p_application_id => p_application_id,
1195: p_request_code => 'IMPORT' ,
1196: p_log_type_code => 'MERGE',

Line 1211: xla_aad_loader_util_pvt.insert_aadloaderlog(

1207: CLOSE c_prod_acct_headers;
1208:
1209: -- Bug : 12969337
1210: -- API Call to Insert messages into AAD Loader Log Table.
1211: xla_aad_loader_util_pvt.insert_aadloaderlog(
1212: p_amb_context_code => p_amb_context_code,
1213: p_application_id => p_application_id,
1214: p_request_code => 'IMPORT' ,
1215: p_log_type_code => 'MERGE',

Line 1230: xla_aad_loader_util_pvt.insert_aadloaderlog(

1226: CLOSE c_aad_hdr_acct_attrs;
1227:
1228: -- Bug : 12969337
1229: -- API Call to Insert messages into AAD Loader Log Table.
1230: xla_aad_loader_util_pvt.insert_aadloaderlog(
1231: p_amb_context_code => p_amb_context_code,
1232: p_application_id => p_application_id,
1233: p_request_code => 'IMPORT' ,
1234: p_log_type_code => 'MERGE',

Line 1249: xla_aad_loader_util_pvt.insert_aadloaderlog(

1245: CLOSE c_aad_header_ac_assgns;
1246:
1247: -- Bug : 12969337
1248: -- API Call to Insert messages into AAD Loader Log Table.
1249: xla_aad_loader_util_pvt.insert_aadloaderlog(
1250: p_amb_context_code => p_amb_context_code,
1251: p_application_id => p_application_id,
1252: p_request_code => 'IMPORT' ,
1253: p_log_type_code => 'MERGE',

Line 1268: xla_aad_loader_util_pvt.insert_aadloaderlog(

1264: CLOSE c_mpa_header_ac_assgns;
1265:
1266: -- Bug : 12969337
1267: -- API Call to Insert messages into AAD Loader Log Table.
1268: xla_aad_loader_util_pvt.insert_aadloaderlog(
1269: p_amb_context_code => p_amb_context_code,
1270: p_application_id => p_application_id,
1271: p_request_code => 'IMPORT' ,
1272: p_log_type_code => 'MERGE',

Line 1287: xla_aad_loader_util_pvt.insert_aadloaderlog(

1283: CLOSE c_mpa_jlt_ac_assgns;
1284:
1285: -- Bug : 12969337
1286: -- API Call to Insert messages into AAD Loader Log Table.
1287: xla_aad_loader_util_pvt.insert_aadloaderlog(
1288: p_amb_context_code => p_amb_context_code,
1289: p_application_id => p_application_id,
1290: p_request_code => 'IMPORT' ,
1291: p_log_type_code => 'MERGE',

Line 1306: xla_aad_loader_util_pvt.insert_aadloaderlog(

1302: CLOSE c_mpa_jlt_adr_assgns;
1303:
1304: -- Bug : 12969337
1305: -- API Call to Insert messages into AAD Loader Log Table.
1306: xla_aad_loader_util_pvt.insert_aadloaderlog(
1307: p_amb_context_code => p_amb_context_code,
1308: p_application_id => p_application_id,
1309: p_request_code => 'IMPORT' ,
1310: p_log_type_code => 'MERGE',

Line 1325: xla_aad_loader_util_pvt.insert_aadloaderlog(

1321: CLOSE c_mpa_jlt_assgns;
1322:
1323: -- Bug : 12969337
1324: -- API Call to Insert messages into AAD Loader Log Table.
1325: xla_aad_loader_util_pvt.insert_aadloaderlog(
1326: p_amb_context_code => p_amb_context_code,
1327: p_application_id => p_application_id,
1328: p_request_code => 'IMPORT' ,
1329: p_log_type_code => 'MERGE',

Line 1344: xla_aad_loader_util_pvt.insert_aadloaderlog(

1340: CLOSE c_aad_line_defn_assgns;
1341:
1342: -- Bug : 12969337
1343: -- API Call to Insert messages into AAD Loader Log Table.
1344: xla_aad_loader_util_pvt.insert_aadloaderlog(
1345: p_amb_context_code => p_amb_context_code,
1346: p_application_id => p_application_id,
1347: p_request_code => 'IMPORT' ,
1348: p_log_type_code => 'MERGE',

Line 1363: xla_aad_loader_util_pvt.insert_aadloaderlog(

1359: CLOSE c_line_definitions_b;
1360:
1361: -- Bug : 12969337
1362: -- API Call to Insert messages into AAD Loader Log Table.
1363: xla_aad_loader_util_pvt.insert_aadloaderlog(
1364: p_amb_context_code => p_amb_context_code,
1365: p_application_id => p_application_id,
1366: p_request_code => 'IMPORT' ,
1367: p_log_type_code => 'MERGE',

Line 1382: xla_aad_loader_util_pvt.insert_aadloaderlog(

1378: CLOSE c_line_definitions_tl;
1379:
1380: -- Bug : 12969337
1381: -- API Call to Insert messages into AAD Loader Log Table.
1382: xla_aad_loader_util_pvt.insert_aadloaderlog(
1383: p_amb_context_code => p_amb_context_code,
1384: p_application_id => p_application_id,
1385: p_request_code => 'IMPORT' ,
1386: p_log_type_code => 'MERGE',

Line 1402: xla_aad_loader_util_pvt.insert_aadloaderlog(

1398:
1399:
1400: -- Bug : 12969337
1401: -- API Call to Insert messages into AAD Loader Log Table.
1402: xla_aad_loader_util_pvt.insert_aadloaderlog(
1403: p_amb_context_code => p_amb_context_code,
1404: p_application_id => p_application_id,
1405: p_request_code => 'IMPORT' ,
1406: p_log_type_code => 'MERGE',

Line 1421: xla_aad_loader_util_pvt.insert_aadloaderlog(

1417: CLOSE c_line_defn_adr_assgns;
1418:
1419: -- Bug : 12969337
1420: -- API Call to Insert messages into AAD Loader Log Table.
1421: xla_aad_loader_util_pvt.insert_aadloaderlog(
1422: p_amb_context_code => p_amb_context_code,
1423: p_application_id => p_application_id,
1424: p_request_code => 'IMPORT' ,
1425: p_log_type_code => 'MERGE',

Line 1440: xla_aad_loader_util_pvt.insert_aadloaderlog(

1436: CLOSE c_line_defn_ac_assgns;
1437:
1438: -- Bug : 12969337
1439: -- API Call to Insert messages into AAD Loader Log Table.
1440: xla_aad_loader_util_pvt.insert_aadloaderlog(
1441: p_amb_context_code => p_amb_context_code,
1442: p_application_id => p_application_id,
1443: p_request_code => 'IMPORT' ,
1444: p_log_type_code => 'MERGE',

Line 1459: xla_aad_loader_util_pvt.insert_aadloaderlog(

1455: CLOSE c_seg_rules_b;
1456:
1457: -- Bug : 12969337
1458: -- API Call to Insert messages into AAD Loader Log Table.
1459: xla_aad_loader_util_pvt.insert_aadloaderlog(
1460: p_amb_context_code => p_amb_context_code,
1461: p_application_id => p_application_id,
1462: p_request_code => 'IMPORT' ,
1463: p_log_type_code => 'MERGE',

Line 1478: xla_aad_loader_util_pvt.insert_aadloaderlog(

1474: CLOSE c_seg_rules_tl;
1475:
1476: -- Bug : 12969337
1477: -- API Call to Insert messages into AAD Loader Log Table.
1478: xla_aad_loader_util_pvt.insert_aadloaderlog(
1479: p_amb_context_code => p_amb_context_code,
1480: p_application_id => p_application_id,
1481: p_request_code => 'IMPORT' ,
1482: p_log_type_code => 'MERGE',

Line 1497: xla_aad_loader_util_pvt.insert_aadloaderlog(

1493: CLOSE c_seg_rule_details;
1494:
1495: -- Bug : 12969337
1496: -- API Call to Insert messages into AAD Loader Log Table.
1497: xla_aad_loader_util_pvt.insert_aadloaderlog(
1498: p_amb_context_code => p_amb_context_code,
1499: p_application_id => p_application_id,
1500: p_request_code => 'IMPORT' ,
1501: p_log_type_code => 'MERGE',

Line 1516: xla_aad_loader_util_pvt.insert_aadloaderlog(

1512: CLOSE c_acct_line_types_b;
1513:
1514: -- Bug : 12969337
1515: -- API Call to Insert messages into AAD Loader Log Table.
1516: xla_aad_loader_util_pvt.insert_aadloaderlog(
1517: p_amb_context_code => p_amb_context_code,
1518: p_application_id => p_application_id,
1519: p_request_code => 'IMPORT' ,
1520: p_log_type_code => 'MERGE',

Line 1535: xla_aad_loader_util_pvt.insert_aadloaderlog(

1531: CLOSE c_acct_line_types_tl;
1532:
1533: -- Bug : 12969337
1534: -- API Call to Insert messages into AAD Loader Log Table.
1535: xla_aad_loader_util_pvt.insert_aadloaderlog(
1536: p_amb_context_code => p_amb_context_code,
1537: p_application_id => p_application_id,
1538: p_request_code => 'IMPORT' ,
1539: p_log_type_code => 'MERGE',

Line 1555: xla_aad_loader_util_pvt.insert_aadloaderlog(

1551: CLOSE c_jlt_acct_attrs;
1552:
1553: -- Bug : 12969337
1554: -- API Call to Insert messages into AAD Loader Log Table.
1555: xla_aad_loader_util_pvt.insert_aadloaderlog(
1556: p_amb_context_code => p_amb_context_code,
1557: p_application_id => p_application_id,
1558: p_request_code => 'IMPORT' ,
1559: p_log_type_code => 'MERGE',

Line 1574: xla_aad_loader_util_pvt.insert_aadloaderlog(

1570: CLOSE c_descriptions_b;
1571:
1572: -- Bug : 12969337
1573: -- API Call to Insert messages into AAD Loader Log Table.
1574: xla_aad_loader_util_pvt.insert_aadloaderlog(
1575: p_amb_context_code => p_amb_context_code,
1576: p_application_id => p_application_id,
1577: p_request_code => 'IMPORT' ,
1578: p_log_type_code => 'MERGE',

Line 1593: xla_aad_loader_util_pvt.insert_aadloaderlog(

1589: CLOSE c_descriptions_tl;
1590:
1591: -- Bug : 12969337
1592: -- API Call to Insert messages into AAD Loader Log Table.
1593: xla_aad_loader_util_pvt.insert_aadloaderlog(
1594: p_amb_context_code => p_amb_context_code,
1595: p_application_id => p_application_id,
1596: p_request_code => 'IMPORT' ,
1597: p_log_type_code => 'MERGE',

Line 1612: xla_aad_loader_util_pvt.insert_aadloaderlog(

1608: CLOSE c_desc_priorities;
1609:
1610: -- Bug : 12969337
1611: -- API Call to Insert messages into AAD Loader Log Table.
1612: xla_aad_loader_util_pvt.insert_aadloaderlog(
1613: p_amb_context_code => p_amb_context_code,
1614: p_application_id => p_application_id,
1615: p_request_code => 'IMPORT' ,
1616: p_log_type_code => 'MERGE',

Line 1631: xla_aad_loader_util_pvt.insert_aadloaderlog(

1627: CLOSE c_descript_details_tl;
1628:
1629: -- Bug : 12969337
1630: -- API Call to Insert messages into AAD Loader Log Table.
1631: xla_aad_loader_util_pvt.insert_aadloaderlog(
1632: p_amb_context_code => p_amb_context_code,
1633: p_application_id => p_application_id,
1634: p_request_code => 'IMPORT' ,
1635: p_log_type_code => 'MERGE',

Line 1650: xla_aad_loader_util_pvt.insert_aadloaderlog(

1646: CLOSE c_conditions;
1647:
1648: -- Bug : 12969337
1649: -- API Call to Insert messages into AAD Loader Log Table.
1650: xla_aad_loader_util_pvt.insert_aadloaderlog(
1651: p_amb_context_code => p_amb_context_code,
1652: p_application_id => p_application_id,
1653: p_request_code => 'IMPORT' ,
1654: p_log_type_code => 'MERGE',

Line 1669: xla_aad_loader_util_pvt.insert_aadloaderlog(

1665: CLOSE c_mapping_sets;
1666:
1667: -- Bug : 12969337
1668: -- API Call to Insert messages into AAD Loader Log Table.
1669: xla_aad_loader_util_pvt.insert_aadloaderlog(
1670: p_amb_context_code => p_amb_context_code,
1671: p_application_id => p_application_id,
1672: p_request_code => 'IMPORT' ,
1673: p_log_type_code => 'MERGE',

Line 1787: xla_aad_loader_util_pvt.stack_error

1783: END IF;
1784: return l_staging_amb_context_code;
1785: EXCEPTION
1786: WHEN OTHERS THEN
1787: xla_aad_loader_util_pvt.stack_error
1788: (p_appli_s_name => 'XLA'
1789: ,p_msg_name => 'XLA_COMMON_ERROR'
1790: ,p_token_1 => 'LOCATION'
1791: ,p_value_1 => 'xla_aad_loader_util_pvt.get_staging_context_code'

Line 1791: ,p_value_1 => 'xla_aad_loader_util_pvt.get_staging_context_code'

1787: xla_aad_loader_util_pvt.stack_error
1788: (p_appli_s_name => 'XLA'
1789: ,p_msg_name => 'XLA_COMMON_ERROR'
1790: ,p_token_1 => 'LOCATION'
1791: ,p_value_1 => 'xla_aad_loader_util_pvt.get_staging_context_code'
1792: ,p_token_2 => 'ERROR'
1793: ,p_value_2 => sqlcode ||' - '||sqlerrm); --Bug 16208537
1794: RAISE;
1795:

Line 2021: xla_aad_loader_util_pvt.stack_error

2017: END IF;
2018:
2019: EXCEPTION
2020: WHEN OTHERS THEN
2021: xla_aad_loader_util_pvt.stack_error
2022: (p_appli_s_name => 'XLA'
2023: ,p_msg_name => 'XLA_COMMON_ERROR'
2024: ,p_token_1 => 'LOCATION'
2025: ,p_value_1 => 'xla_aad_loader_util_pvt.merge_history'

Line 2025: ,p_value_1 => 'xla_aad_loader_util_pvt.merge_history'

2021: xla_aad_loader_util_pvt.stack_error
2022: (p_appli_s_name => 'XLA'
2023: ,p_msg_name => 'XLA_COMMON_ERROR'
2024: ,p_token_1 => 'LOCATION'
2025: ,p_value_1 => 'xla_aad_loader_util_pvt.merge_history'
2026: ,p_token_2 => 'ERROR'
2027: ,p_value_2 => sqlcode ||' - '||sqlerrm); --Bug 16208537
2028: RAISE;
2029:

Line 2080: xla_aad_loader_util_pvt.stack_error

2076: RETURN l_ret_segment;
2077:
2078: EXCEPTION
2079: WHEN OTHERS THEN
2080: xla_aad_loader_util_pvt.stack_error
2081: (p_appli_s_name => 'XLA'
2082: ,p_msg_name => 'XLA_COMMON_ERROR'
2083: ,p_token_1 => 'LOCATION'
2084: ,p_value_1 => 'xla_aad_loader_util_pvt.get_segment'

Line 2084: ,p_value_1 => 'xla_aad_loader_util_pvt.get_segment'

2080: xla_aad_loader_util_pvt.stack_error
2081: (p_appli_s_name => 'XLA'
2082: ,p_msg_name => 'XLA_COMMON_ERROR'
2083: ,p_token_1 => 'LOCATION'
2084: ,p_value_1 => 'xla_aad_loader_util_pvt.get_segment'
2085: ,p_token_2 => 'ERROR'
2086: ,p_value_2 => sqlcode ||' - '||sqlerrm); --Bug 16208537
2087: RAISE;
2088:

Line 2144: xla_aad_loader_util_pvt.stack_error

2140: p_level => C_LEVEL_PROCEDURE);
2141: END IF;
2142: EXCEPTION
2143: WHEN OTHERS THEN
2144: xla_aad_loader_util_pvt.stack_error
2145: (p_appli_s_name => 'XLA'
2146: ,p_msg_name => 'XLA_COMMON_ERROR'
2147: ,p_token_1 => 'LOCATION'
2148: ,p_value_1 => 'xla_aad_loader_util_pvt.reset_errors'

Line 2148: ,p_value_1 => 'xla_aad_loader_util_pvt.reset_errors'

2144: xla_aad_loader_util_pvt.stack_error
2145: (p_appli_s_name => 'XLA'
2146: ,p_msg_name => 'XLA_COMMON_ERROR'
2147: ,p_token_1 => 'LOCATION'
2148: ,p_value_1 => 'xla_aad_loader_util_pvt.reset_errors'
2149: ,p_token_2 => 'ERROR'
2150: ,p_value_2 => sqlcode ||' - '||sqlerrm); --Bug 16208537
2151: RAISE;
2152:

Line 2413: (p_location => 'xla_aad_loader_util_pvt.stack_error');

2409: RAISE;
2410:
2411: WHEN OTHERS THEN
2412: xla_exceptions_pkg.raise_message
2413: (p_location => 'xla_aad_loader_util_pvt.stack_error');
2414:
2415: END stack_error;
2416:
2417: --=============================================================================

Line 2500: trace(p_msg => 'In exception of xla_aad_loader_util_pvt.insert_errors'

2496: l_excp_code := sqlcode;
2497:
2498:
2499: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2500: trace(p_msg => 'In exception of xla_aad_loader_util_pvt.insert_errors'
2501: ,p_module => l_log_module
2502: ,p_level => C_LEVEL_PROCEDURE);
2503: END IF;
2504:

Line 2506: trace(p_msg => 'Error in xla_aad_loader_util_pvt.insert_errors is : '||l_excp_code||'-'||l_exception

2502: ,p_level => C_LEVEL_PROCEDURE);
2503: END IF;
2504:
2505: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2506: trace(p_msg => 'Error in xla_aad_loader_util_pvt.insert_errors is : '||l_excp_code||'-'||l_exception
2507: ,p_module => l_log_module
2508: ,p_level => C_LEVEL_PROCEDURE);
2509: END IF;
2510:

Line 2511: xla_aad_loader_util_pvt.stack_error

2507: ,p_module => l_log_module
2508: ,p_level => C_LEVEL_PROCEDURE);
2509: END IF;
2510:
2511: xla_aad_loader_util_pvt.stack_error
2512: (p_appli_s_name => 'XLA'
2513: ,p_msg_name => 'XLA_COMMON_ERROR'
2514: ,p_token_1 => 'LOCATION'
2515: ,p_value_1 => 'xla_aad_loader_util_pvt.insert_errors'

Line 2515: ,p_value_1 => 'xla_aad_loader_util_pvt.insert_errors'

2511: xla_aad_loader_util_pvt.stack_error
2512: (p_appli_s_name => 'XLA'
2513: ,p_msg_name => 'XLA_COMMON_ERROR'
2514: ,p_token_1 => 'LOCATION'
2515: ,p_value_1 => 'xla_aad_loader_util_pvt.insert_errors'
2516: ,p_token_2 => 'ERROR'
2517: ,p_value_2 => sqlcode ||' - '||sqlerrm); --Bug 16208537
2518: RAISE;
2519:

Line 2571: xla_aad_loader_util_pvt.stack_error

2567: ,p_module => l_log_module);
2568: END IF;
2569:
2570: l_retcode := 'ERROR';
2571: xla_aad_loader_util_pvt.stack_error
2572: (p_appli_s_name => 'XLA'
2573: ,p_msg_name => 'XLA_COMMON_ERROR'
2574: ,p_token_1 => 'LOCATION'
2575: ,p_value_1 => 'xla_aad_loader_util_pvt.wait_for_request'

Line 2575: ,p_value_1 => 'xla_aad_loader_util_pvt.wait_for_request'

2571: xla_aad_loader_util_pvt.stack_error
2572: (p_appli_s_name => 'XLA'
2573: ,p_msg_name => 'XLA_COMMON_ERROR'
2574: ,p_token_1 => 'LOCATION'
2575: ,p_value_1 => 'xla_aad_loader_util_pvt.wait_for_request'
2576: ,p_token_2 => 'ERROR'
2577: ,p_value_2 =>
2578: 'Technical problem : FND_CONCURRENT.WAIT_FOR_REQUEST returned FALSE');
2579: ELSE

Line 2606: xla_aad_loader_util_pvt.stack_error

2602: END IF;
2603: return l_retcode;
2604: EXCEPTION
2605: WHEN OTHERS THEN
2606: xla_aad_loader_util_pvt.stack_error
2607: (p_appli_s_name => 'XLA'
2608: ,p_msg_name => 'XLA_COMMON_ERROR'
2609: ,p_token_1 => 'LOCATION'
2610: ,p_value_1 => 'xla_aad_loader_util_pvt.wait_for_request'

Line 2610: ,p_value_1 => 'xla_aad_loader_util_pvt.wait_for_request'

2606: xla_aad_loader_util_pvt.stack_error
2607: (p_appli_s_name => 'XLA'
2608: ,p_msg_name => 'XLA_COMMON_ERROR'
2609: ,p_token_1 => 'LOCATION'
2610: ,p_value_1 => 'xla_aad_loader_util_pvt.wait_for_request'
2611: ,p_token_2 => 'ERROR'
2612: ,p_value_2 => sqlcode ||' - '||sqlerrm); --Bug 16208537
2613: RAISE;
2614:

Line 2663: xla_aad_loader_util_pvt.stack_error

2659:
2660: RETURN l_req_id;
2661: EXCEPTION
2662: WHEN OTHERS THEN
2663: xla_aad_loader_util_pvt.stack_error
2664: (p_appli_s_name => 'XLA'
2665: ,p_msg_name => 'XLA_COMMON_ERROR'
2666: ,p_token_1 => 'LOCATION'
2667: ,p_value_1 => 'xla_aad_loader_util_pvt.submit_compile_report_request'

Line 2667: ,p_value_1 => 'xla_aad_loader_util_pvt.submit_compile_report_request'

2663: xla_aad_loader_util_pvt.stack_error
2664: (p_appli_s_name => 'XLA'
2665: ,p_msg_name => 'XLA_COMMON_ERROR'
2666: ,p_token_1 => 'LOCATION'
2667: ,p_value_1 => 'xla_aad_loader_util_pvt.submit_compile_report_request'
2668: ,p_token_2 => 'ERROR'
2669: ,p_value_2 => sqlcode ||' - '||sqlerrm); --Bug 16208537
2670: RAISE;
2671:

Line 2708: xla_aad_loader_util_pvt.stack_error

2704: (p_application_id => p_application_id);
2705:
2706: IF (l_req_id = 0) THEN
2707: l_retcode := FALSE;
2708: xla_aad_loader_util_pvt.stack_error
2709: (p_appli_s_name => 'XLA'
2710: ,p_msg_name => 'XLA_COMMON_ERROR'
2711: ,p_token_1 => 'LOCATION'
2712: ,p_value_1 => 'xla_aad_loader_util_pvt.compile'

Line 2712: ,p_value_1 => 'xla_aad_loader_util_pvt.compile'

2708: xla_aad_loader_util_pvt.stack_error
2709: (p_appli_s_name => 'XLA'
2710: ,p_msg_name => 'XLA_COMMON_ERROR'
2711: ,p_token_1 => 'LOCATION'
2712: ,p_value_1 => 'xla_aad_loader_util_pvt.compile'
2713: ,p_token_2 => 'ERROR'
2714: ,p_value_2 => 'Unable to submit compilation report request');
2715: END IF;
2716:

Line 2728: xla_aad_loader_util_pvt.stack_error

2724: RETURN l_retcode;
2725: EXCEPTION
2726:
2727: WHEN OTHERS THEN
2728: xla_aad_loader_util_pvt.stack_error
2729: (p_appli_s_name => 'XLA'
2730: ,p_msg_name => 'XLA_COMMON_ERROR'
2731: ,p_token_1 => 'LOCATION'
2732: ,p_value_1 => 'xla_aad_loader_util_pvt.compile'

Line 2732: ,p_value_1 => 'xla_aad_loader_util_pvt.compile'

2728: xla_aad_loader_util_pvt.stack_error
2729: (p_appli_s_name => 'XLA'
2730: ,p_msg_name => 'XLA_COMMON_ERROR'
2731: ,p_token_1 => 'LOCATION'
2732: ,p_value_1 => 'xla_aad_loader_util_pvt.compile'
2733: ,p_token_2 => 'ERROR'
2734: ,p_value_2 => 'unhandled exception');
2735: RAISE;
2736:

Line 2777: xla_aad_loader_util_pvt.stack_error

2773: ,p_pkg_name => p_pkg_name)) THEN
2774:
2775: l_error_text := fnd_msg_pub.get(fnd_msg_pub.G_FIRST, FND_API.G_FALSE);
2776:
2777: xla_aad_loader_util_pvt.stack_error
2778: (p_appli_s_name => 'XLA'
2779: ,p_msg_name => 'XLA_COMMON_ERROR'
2780: ,p_token_1 => 'LOCATION'
2781: ,p_value_1 => 'xla_aad_loader_util_pvt.compatible_api_call'

Line 2781: ,p_value_1 => 'xla_aad_loader_util_pvt.compatible_api_call'

2777: xla_aad_loader_util_pvt.stack_error
2778: (p_appli_s_name => 'XLA'
2779: ,p_msg_name => 'XLA_COMMON_ERROR'
2780: ,p_token_1 => 'LOCATION'
2781: ,p_value_1 => 'xla_aad_loader_util_pvt.compatible_api_call'
2782: ,p_token_2 => 'ERROR'
2783: ,p_value_2 => l_error_text);
2784:
2785: l_retcode := FALSE;

Line 2796: xla_aad_loader_util_pvt.stack_error

2792: END IF;
2793: RETURN l_retcode;
2794: EXCEPTION
2795: WHEN OTHERS THEN
2796: xla_aad_loader_util_pvt.stack_error
2797: (p_appli_s_name => 'XLA'
2798: ,p_msg_name => 'XLA_COMMON_ERROR'
2799: ,p_token_1 => 'LOCATION'
2800: ,p_value_1 => 'xla_aad_loader_util_pvt.compatible_api_call'

Line 2800: ,p_value_1 => 'xla_aad_loader_util_pvt.compatible_api_call'

2796: xla_aad_loader_util_pvt.stack_error
2797: (p_appli_s_name => 'XLA'
2798: ,p_msg_name => 'XLA_COMMON_ERROR'
2799: ,p_token_1 => 'LOCATION'
2800: ,p_value_1 => 'xla_aad_loader_util_pvt.compatible_api_call'
2801: ,p_token_2 => 'ERROR'
2802: ,p_value_2 => 'unhandled exception');
2803: RAISE;
2804:

Line 2840: IF (NOT xla_aad_loader_util_pvt.compatible_api_call

2836: p_level => C_LEVEL_PROCEDURE);
2837: END IF;
2838:
2839: -- Standard call to check for call compatibility.
2840: IF (NOT xla_aad_loader_util_pvt.compatible_api_call
2841: (p_current_version_number => l_api_version
2842: ,p_caller_version_number => p_api_version
2843: ,p_api_name => l_api_name
2844: ,p_pkg_name => C_DEFAULT_MODULE))

Line 2962: IF (NOT xla_aad_loader_util_pvt.compatible_api_call

2958: ', p_amb_context_code = '||p_amb_context_code,
2959: p_module => l_log_module,
2960: p_level => C_LEVEL_PROCEDURE);
2961: END IF;
2962: IF (NOT xla_aad_loader_util_pvt.compatible_api_call
2963: (p_current_version_number => l_api_version
2964: ,p_caller_version_number => p_api_version
2965: ,p_api_name => l_api_name
2966: ,p_pkg_name => C_DEFAULT_MODULE))

Line 2991: xla_aad_loader_util_pvt.insert_aadloaderlog(

2987: WHERE staging_amb_context_code = l_staging_context_code;
2988:
2989: -- Bug 16208537
2990: -- API Call to Insert messages into AAD Loader Log Table.
2991: xla_aad_loader_util_pvt.insert_aadloaderlog(
2992: p_amb_context_code => l_staging_context_code,
2993: p_application_id => p_application_id,
2994: p_request_code => 'IMPORT' ,
2995: p_log_type_code => 'MERGE',

Line 3010: xla_aad_loader_util_pvt.insert_aadloaderlog(

3006: WHERE staging_amb_context_code = l_staging_context_code;
3007:
3008: -- Bug 16208537
3009: -- API Call to Insert messages into AAD Loader Log Table.
3010: xla_aad_loader_util_pvt.insert_aadloaderlog(
3011: p_amb_context_code => l_staging_context_code,
3012: p_application_id => p_application_id,
3013: p_request_code => 'IMPORT' ,
3014: p_log_type_code => 'MERGE',

Line 3029: xla_aad_loader_util_pvt.insert_aadloaderlog(

3025: WHERE staging_amb_context_code = l_staging_context_code;
3026:
3027: -- Bug 16208537
3028: -- API Call to Insert messages into AAD Loader Log Table.
3029: xla_aad_loader_util_pvt.insert_aadloaderlog(
3030: p_amb_context_code => l_staging_context_code,
3031: p_application_id => p_application_id,
3032: p_request_code => 'IMPORT' ,
3033: p_log_type_code => 'MERGE',

Line 3048: xla_aad_loader_util_pvt.insert_aadloaderlog(

3044: WHERE staging_amb_context_code = l_staging_context_code;
3045:
3046: -- Bug 16208537
3047: -- API Call to Insert messages into AAD Loader Log Table.
3048: xla_aad_loader_util_pvt.insert_aadloaderlog(
3049: p_amb_context_code => l_staging_context_code,
3050: p_application_id => p_application_id,
3051: p_request_code => 'IMPORT' ,
3052: p_log_type_code => 'MERGE',

Line 3069: xla_aad_loader_util_pvt.insert_aadloaderlog(

3065: WHERE staging_amb_context_code = p_amb_context_code;
3066:
3067: -- Bug 16208537
3068: -- API Call to Insert messages into AAD Loader Log Table.
3069: xla_aad_loader_util_pvt.insert_aadloaderlog(
3070: p_amb_context_code => p_amb_context_code,
3071: p_application_id => p_application_id,
3072: p_request_code => 'IMPORT' ,
3073: p_log_type_code => 'MERGE',

Line 3088: xla_aad_loader_util_pvt.insert_aadloaderlog(

3084: WHERE staging_amb_context_code = p_amb_context_code;
3085:
3086: -- Bug 16208537
3087: -- API Call to Insert messages into AAD Loader Log Table.
3088: xla_aad_loader_util_pvt.insert_aadloaderlog(
3089: p_amb_context_code => p_amb_context_code,
3090: p_application_id => p_application_id,
3091: p_request_code => 'IMPORT' ,
3092: p_log_type_code => 'MERGE',

Line 3107: xla_aad_loader_util_pvt.insert_aadloaderlog(

3103: WHERE staging_amb_context_code = p_amb_context_code;
3104:
3105: -- Bug 16208537
3106: -- API Call to Insert messages into AAD Loader Log Table.
3107: xla_aad_loader_util_pvt.insert_aadloaderlog(
3108: p_amb_context_code => p_amb_context_code,
3109: p_application_id => p_application_id,
3110: p_request_code => 'IMPORT' ,
3111: p_log_type_code => 'MERGE',

Line 3126: xla_aad_loader_util_pvt.insert_aadloaderlog(

3122: WHERE staging_amb_context_code = p_amb_context_code;
3123:
3124: -- Bug 16208537
3125: -- API Call to Insert messages into AAD Loader Log Table.
3126: xla_aad_loader_util_pvt.insert_aadloaderlog(
3127: p_amb_context_code => p_amb_context_code,
3128: p_application_id => p_application_id,
3129: p_request_code => 'IMPORT' ,
3130: p_log_type_code => 'MERGE',

Line 3147: xla_aad_loader_util_pvt.insert_aadloaderlog(

3143: AND application_id = p_application_id;
3144:
3145: -- Bug 16208537
3146: -- API Call to Insert messages into AAD Loader Log Table.
3147: xla_aad_loader_util_pvt.insert_aadloaderlog(
3148: p_amb_context_code => p_amb_context_code,
3149: p_application_id => p_application_id,
3150: p_request_code => 'IMPORT' ,
3151: p_log_type_code => 'MERGE',

Line 3167: xla_aad_loader_util_pvt.insert_aadloaderlog(

3163: AND application_id = p_application_id;
3164:
3165: -- Bug 16208537
3166: -- API Call to Insert messages into AAD Loader Log Table.
3167: xla_aad_loader_util_pvt.insert_aadloaderlog(
3168: p_amb_context_code => p_amb_context_code,
3169: p_application_id => p_application_id,
3170: p_request_code => 'IMPORT' ,
3171: p_log_type_code => 'MERGE',

Line 3187: xla_aad_loader_util_pvt.insert_aadloaderlog(

3183: AND application_id = p_application_id;
3184:
3185: -- Bug 16208537
3186: -- API Call to Insert messages into AAD Loader Log Table.
3187: xla_aad_loader_util_pvt.insert_aadloaderlog(
3188: p_amb_context_code => p_amb_context_code,
3189: p_application_id => p_application_id,
3190: p_request_code => 'IMPORT' ,
3191: p_log_type_code => 'MERGE',

Line 3207: xla_aad_loader_util_pvt.insert_aadloaderlog(

3203: AND application_id = p_application_id;
3204:
3205: -- Bug 16208537
3206: -- API Call to Insert messages into AAD Loader Log Table.
3207: xla_aad_loader_util_pvt.insert_aadloaderlog(
3208: p_amb_context_code => p_amb_context_code,
3209: p_application_id => p_application_id,
3210: p_request_code => 'IMPORT' ,
3211: p_log_type_code => 'MERGE',

Line 3227: xla_aad_loader_util_pvt.insert_aadloaderlog(

3223: AND application_id = p_application_id;
3224:
3225: -- Bug 16208537
3226: -- API Call to Insert messages into AAD Loader Log Table.
3227: xla_aad_loader_util_pvt.insert_aadloaderlog(
3228: p_amb_context_code => p_amb_context_code,
3229: p_application_id => p_application_id,
3230: p_request_code => 'IMPORT' ,
3231: p_log_type_code => 'MERGE',

Line 3247: xla_aad_loader_util_pvt.insert_aadloaderlog(

3243: AND application_id = p_application_id;
3244:
3245: -- Bug 16208537
3246: -- API Call to Insert messages into AAD Loader Log Table.
3247: xla_aad_loader_util_pvt.insert_aadloaderlog(
3248: p_amb_context_code => p_amb_context_code,
3249: p_application_id => p_application_id,
3250: p_request_code => 'IMPORT' ,
3251: p_log_type_code => 'MERGE',

Line 3267: xla_aad_loader_util_pvt.insert_aadloaderlog(

3263: AND application_id = p_application_id;
3264:
3265: -- Bug 16208537
3266: -- API Call to Insert messages into AAD Loader Log Table.
3267: xla_aad_loader_util_pvt.insert_aadloaderlog(
3268: p_amb_context_code => p_amb_context_code,
3269: p_application_id => p_application_id,
3270: p_request_code => 'IMPORT' ,
3271: p_log_type_code => 'MERGE',

Line 3287: xla_aad_loader_util_pvt.insert_aadloaderlog(

3283: AND application_id = p_application_id;
3284:
3285: -- Bug 16208537
3286: -- API Call to Insert messages into AAD Loader Log Table.
3287: xla_aad_loader_util_pvt.insert_aadloaderlog(
3288: p_amb_context_code => p_amb_context_code,
3289: p_application_id => p_application_id,
3290: p_request_code => 'IMPORT' ,
3291: p_log_type_code => 'MERGE',

Line 3307: xla_aad_loader_util_pvt.insert_aadloaderlog(

3303: AND application_id = p_application_id;
3304:
3305: -- Bug 16208537
3306: -- API Call to Insert messages into AAD Loader Log Table.
3307: xla_aad_loader_util_pvt.insert_aadloaderlog(
3308: p_amb_context_code => p_amb_context_code,
3309: p_application_id => p_application_id,
3310: p_request_code => 'IMPORT' ,
3311: p_log_type_code => 'MERGE',

Line 3327: xla_aad_loader_util_pvt.insert_aadloaderlog(

3323: AND application_id = p_application_id;
3324:
3325: -- Bug 16208537
3326: -- API Call to Insert messages into AAD Loader Log Table.
3327: xla_aad_loader_util_pvt.insert_aadloaderlog(
3328: p_amb_context_code => p_amb_context_code,
3329: p_application_id => p_application_id,
3330: p_request_code => 'IMPORT' ,
3331: p_log_type_code => 'MERGE',

Line 3347: xla_aad_loader_util_pvt.insert_aadloaderlog(

3343: AND application_id = p_application_id;
3344:
3345: -- Bug 16208537
3346: -- API Call to Insert messages into AAD Loader Log Table.
3347: xla_aad_loader_util_pvt.insert_aadloaderlog(
3348: p_amb_context_code => p_amb_context_code,
3349: p_application_id => p_application_id,
3350: p_request_code => 'IMPORT' ,
3351: p_log_type_code => 'MERGE',

Line 3367: xla_aad_loader_util_pvt.insert_aadloaderlog(

3363: AND application_id = p_application_id;
3364:
3365: -- Bug 16208537
3366: -- API Call to Insert messages into AAD Loader Log Table.
3367: xla_aad_loader_util_pvt.insert_aadloaderlog(
3368: p_amb_context_code => p_amb_context_code,
3369: p_application_id => p_application_id,
3370: p_request_code => 'IMPORT' ,
3371: p_log_type_code => 'MERGE',

Line 3387: xla_aad_loader_util_pvt.insert_aadloaderlog(

3383: AND application_id = p_application_id;
3384:
3385: -- Bug 16208537
3386: -- API Call to Insert messages into AAD Loader Log Table.
3387: xla_aad_loader_util_pvt.insert_aadloaderlog(
3388: p_amb_context_code => p_amb_context_code,
3389: p_application_id => p_application_id,
3390: p_request_code => 'IMPORT' ,
3391: p_log_type_code => 'MERGE',

Line 3407: xla_aad_loader_util_pvt.insert_aadloaderlog(

3403: AND application_id = p_application_id;
3404:
3405: -- Bug 16208537
3406: -- API Call to Insert messages into AAD Loader Log Table.
3407: xla_aad_loader_util_pvt.insert_aadloaderlog(
3408: p_amb_context_code => p_amb_context_code,
3409: p_application_id => p_application_id,
3410: p_request_code => 'IMPORT' ,
3411: p_log_type_code => 'MERGE',

Line 3427: xla_aad_loader_util_pvt.insert_aadloaderlog(

3423: AND application_id = p_application_id;
3424:
3425: -- Bug 16208537
3426: -- API Call to Insert messages into AAD Loader Log Table.
3427: xla_aad_loader_util_pvt.insert_aadloaderlog(
3428: p_amb_context_code => p_amb_context_code,
3429: p_application_id => p_application_id,
3430: p_request_code => 'IMPORT' ,
3431: p_log_type_code => 'MERGE',

Line 3447: xla_aad_loader_util_pvt.insert_aadloaderlog(

3443: AND application_id = p_application_id;
3444:
3445: -- Bug 16208537
3446: -- API Call to Insert messages into AAD Loader Log Table.
3447: xla_aad_loader_util_pvt.insert_aadloaderlog(
3448: p_amb_context_code => p_amb_context_code,
3449: p_application_id => p_application_id,
3450: p_request_code => 'IMPORT' ,
3451: p_log_type_code => 'MERGE',

Line 3467: xla_aad_loader_util_pvt.insert_aadloaderlog(

3463: AND application_id = p_application_id;
3464:
3465: -- Bug 16208537
3466: -- API Call to Insert messages into AAD Loader Log Table.
3467: xla_aad_loader_util_pvt.insert_aadloaderlog(
3468: p_amb_context_code => p_amb_context_code,
3469: p_application_id => p_application_id,
3470: p_request_code => 'IMPORT' ,
3471: p_log_type_code => 'MERGE',

Line 3487: xla_aad_loader_util_pvt.insert_aadloaderlog(

3483: AND application_id = p_application_id;
3484:
3485: -- Bug 16208537
3486: -- API Call to Insert messages into AAD Loader Log Table.
3487: xla_aad_loader_util_pvt.insert_aadloaderlog(
3488: p_amb_context_code => p_amb_context_code,
3489: p_application_id => p_application_id,
3490: p_request_code => 'IMPORT' ,
3491: p_log_type_code => 'MERGE',

Line 3508: xla_aad_loader_util_pvt.insert_aadloaderlog(

3504: AND application_id = p_application_id;
3505:
3506: -- Bug 16208537
3507: -- API Call to Insert messages into AAD Loader Log Table.
3508: xla_aad_loader_util_pvt.insert_aadloaderlog(
3509: p_amb_context_code => p_amb_context_code,
3510: p_application_id => p_application_id,
3511: p_request_code => 'IMPORT' ,
3512: p_log_type_code => 'MERGE',

Line 3534: xla_aad_loader_util_pvt.insert_aadloaderlog(

3530:
3531:
3532: -- Bug 16208537
3533: -- API Call to Insert messages into AAD Loader Log Table.
3534: xla_aad_loader_util_pvt.insert_aadloaderlog(
3535: p_amb_context_code => p_amb_context_code,
3536: p_application_id => p_application_id,
3537: p_request_code => 'IMPORT' ,
3538: p_log_type_code => 'MERGE',

Line 3559: xla_aad_loader_util_pvt.insert_aadloaderlog(

3555: AND h.application_id = p_application_id);
3556:
3557: -- Bug 16208537
3558: -- API Call to Insert messages into AAD Loader Log Table.
3559: xla_aad_loader_util_pvt.insert_aadloaderlog(
3560: p_amb_context_code => p_amb_context_code,
3561: p_application_id => p_application_id,
3562: p_request_code => 'IMPORT' ,
3563: p_log_type_code => 'MERGE',

Line 3584: xla_aad_loader_util_pvt.insert_aadloaderlog(

3580: AND h.application_id = p_application_id);
3581:
3582: -- Bug 16208537
3583: -- API Call to Insert messages into AAD Loader Log Table.
3584: xla_aad_loader_util_pvt.insert_aadloaderlog(
3585: p_amb_context_code => p_amb_context_code,
3586: p_application_id => p_application_id,
3587: p_request_code => 'IMPORT' ,
3588: p_log_type_code => 'MERGE',

Line 3610: xla_aad_loader_util_pvt.insert_aadloaderlog(

3606: AND h.application_id = p_application_id);
3607:
3608: -- Bug 16208537
3609: -- API Call to Insert messages into AAD Loader Log Table.
3610: xla_aad_loader_util_pvt.insert_aadloaderlog(
3611: p_amb_context_code => p_amb_context_code,
3612: p_application_id => p_application_id,
3613: p_request_code => 'IMPORT' ,
3614: p_log_type_code => 'MERGE',

Line 3631: xla_aad_loader_util_pvt.insert_aadloaderlog(

3627: AND application_id = p_application_id;
3628:
3629: -- Bug 16208537
3630: -- API Call to Insert messages into AAD Loader Log Table.
3631: xla_aad_loader_util_pvt.insert_aadloaderlog(
3632: p_amb_context_code => p_amb_context_code,
3633: p_application_id => p_application_id,
3634: p_request_code => 'IMPORT' ,
3635: p_log_type_code => 'MERGE',

Line 3651: xla_aad_loader_util_pvt.insert_aadloaderlog(

3647: AND application_id = p_application_id;
3648:
3649: -- Bug 16208537
3650: -- API Call to Insert messages into AAD Loader Log Table.
3651: xla_aad_loader_util_pvt.insert_aadloaderlog(
3652: p_amb_context_code => p_amb_context_code,
3653: p_application_id => p_application_id,
3654: p_request_code => 'IMPORT' ,
3655: p_log_type_code => 'MERGE',

Line 3671: xla_aad_loader_util_pvt.insert_aadloaderlog(

3667: AND application_id = p_application_id;
3668:
3669: -- Bug 16208537
3670: -- API Call to Insert messages into AAD Loader Log Table.
3671: xla_aad_loader_util_pvt.insert_aadloaderlog(
3672: p_amb_context_code => p_amb_context_code,
3673: p_application_id => p_application_id,
3674: p_request_code => 'IMPORT' ,
3675: p_log_type_code => 'MERGE',

Line 3692: xla_aad_loader_util_pvt.insert_aadloaderlog(

3688: AND application_id = p_application_id;
3689:
3690: -- Bug 16208537
3691: -- API Call to Insert messages into AAD Loader Log Table.
3692: xla_aad_loader_util_pvt.insert_aadloaderlog(
3693: p_amb_context_code => p_amb_context_code,
3694: p_application_id => p_application_id,
3695: p_request_code => 'IMPORT' ,
3696: p_log_type_code => 'MERGE',

Line 3717: xla_aad_loader_util_pvt.insert_aadloaderlog(

3713: AND p.amb_context_code IN (p_amb_context_code, l_staging_context_code));
3714:
3715: -- Bug 16208537
3716: -- API Call to Insert messages into AAD Loader Log Table.
3717: xla_aad_loader_util_pvt.insert_aadloaderlog(
3718: p_amb_context_code => p_amb_context_code,
3719: p_application_id => p_application_id,
3720: p_request_code => 'IMPORT' ,
3721: p_log_type_code => 'MERGE',

Line 3740: xla_aad_loader_util_pvt.insert_aadloaderlog(

3736: AND application_id = p_application_id);
3737:
3738: -- Bug 16208537
3739: -- API Call to Insert messages into AAD Loader Log Table.
3740: xla_aad_loader_util_pvt.insert_aadloaderlog(
3741: p_amb_context_code => p_amb_context_code,
3742: p_application_id => p_application_id,
3743: p_request_code => 'IMPORT' ,
3744: p_log_type_code => 'MERGE',

Line 3760: xla_aad_loader_util_pvt.insert_aadloaderlog(

3756: AND application_id = p_application_id;
3757:
3758: -- Bug 16208537
3759: -- API Call to Insert messages into AAD Loader Log Table.
3760: xla_aad_loader_util_pvt.insert_aadloaderlog(
3761: p_amb_context_code => p_amb_context_code,
3762: p_application_id => p_application_id,
3763: p_request_code => 'IMPORT' ,
3764: p_log_type_code => 'MERGE',

Line 3780: xla_aad_loader_util_pvt.insert_aadloaderlog(

3776: AND application_id = p_application_id;
3777:
3778: -- Bug 16208537
3779: -- API Call to Insert messages into AAD Loader Log Table.
3780: xla_aad_loader_util_pvt.insert_aadloaderlog(
3781: p_amb_context_code => p_amb_context_code,
3782: p_application_id => p_application_id,
3783: p_request_code => 'IMPORT' ,
3784: p_log_type_code => 'MERGE',

Line 3800: xla_aad_loader_util_pvt.insert_aadloaderlog(

3796: AND application_id = p_application_id;
3797:
3798: -- Bug 16208537
3799: -- API Call to Insert messages into AAD Loader Log Table.
3800: xla_aad_loader_util_pvt.insert_aadloaderlog(
3801: p_amb_context_code => p_amb_context_code,
3802: p_application_id => p_application_id,
3803: p_request_code => 'IMPORT' ,
3804: p_log_type_code => 'MERGE',

Line 3820: xla_aad_loader_util_pvt.insert_aadloaderlog(

3816: AND application_id = p_application_id;
3817:
3818: -- Bug 16208537
3819: -- API Call to Insert messages into AAD Loader Log Table.
3820: xla_aad_loader_util_pvt.insert_aadloaderlog(
3821: p_amb_context_code => p_amb_context_code,
3822: p_application_id => p_application_id,
3823: p_request_code => 'IMPORT' ,
3824: p_log_type_code => 'MERGE',

Line 3840: xla_aad_loader_util_pvt.insert_aadloaderlog(

3836: AND application_id = p_application_id;
3837:
3838: -- Bug 16208537
3839: -- API Call to Insert messages into AAD Loader Log Table.
3840: xla_aad_loader_util_pvt.insert_aadloaderlog(
3841: p_amb_context_code => p_amb_context_code,
3842: p_application_id => p_application_id,
3843: p_request_code => 'IMPORT' ,
3844: p_log_type_code => 'MERGE',

Line 3872: xla_aad_loader_util_pvt.stack_error

3868: WHEN OTHERS THEN
3869: ROLLBACK;
3870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3871:
3872: xla_aad_loader_util_pvt.stack_error
3873: (p_appli_s_name => 'XLA'
3874: ,p_msg_name => 'XLA_COMMON_ERROR'
3875: ,p_token_1 => 'LOCATION'
3876: ,p_value_1 => 'xla_aad_util_pvt.purge_aad'

Line 3930: xla_aad_loader_util_pvt.stack_error

3926: END IF;
3927: EXCEPTION
3928:
3929: WHEN OTHERS THEN
3930: xla_aad_loader_util_pvt.stack_error
3931: (p_appli_s_name => 'XLA'
3932: ,p_msg_name => 'XLA_COMMON_ERROR'
3933: ,p_token_1 => 'LOCATION'
3934: ,p_value_1 => 'xla_aad_util_pvt.rebuild_ac_views'

Line 4039: xla_aad_loader_util_pvt.stack_error

4035: p_level => C_LEVEL_PROCEDURE);
4036: END IF;
4037:
4038: l_retcode := 'ERROR';
4039: xla_aad_loader_util_pvt.stack_error
4040: (p_appli_s_name => 'XLA'
4041: ,p_msg_name => 'XLA_AAD_INCOMPATIBLE_ADR_VERS'
4042: ,p_token_1 => 'APP_NAME'
4043: ,p_value_1 => l_err.application_name

Line 4069: xla_aad_loader_util_pvt.stack_error

4065: return l_retcode;
4066: EXCEPTION
4067:
4068: WHEN OTHERS THEN
4069: xla_aad_loader_util_pvt.stack_error
4070: (p_appli_s_name => 'XLA'
4071: ,p_msg_name => 'XLA_COMMON_ERROR'
4072: ,p_token_1 => 'LOCATION'
4073: ,p_value_1 => 'xla_aad_util_pvt.validate_adr_compatibility'

Line 4107: IF (NOT xla_aad_loader_util_pvt.compatible_api_call

4103: p_module => l_log_module,
4104: p_level => C_LEVEL_PROCEDURE);
4105: END IF;
4106:
4107: IF (NOT xla_aad_loader_util_pvt.compatible_api_call
4108: (p_current_version_number => l_api_version
4109: ,p_caller_version_number => p_api_version
4110: ,p_api_name => l_api_name
4111: ,p_pkg_name => C_DEFAULT_MODULE))

Line 4191: (p_location => 'xla_aad_loader_util_pvt.insert_aadloaderlog');

4187: WHEN xla_exceptions_pkg.application_exception THEN
4188: RAISE;
4189: WHEN OTHERS THEN
4190: xla_exceptions_pkg.raise_message
4191: (p_location => 'xla_aad_loader_util_pvt.insert_aadloaderlog');
4192: END insert_aadloaderlog;
4193:
4194:
4195: --=============================================================================

Line 4211: END xla_aad_loader_util_pvt;

4207: IF NOT g_log_enabled THEN
4208: g_log_level := C_LEVEL_LOG_DISABLED;
4209: END IF;
4210:
4211: END xla_aad_loader_util_pvt;