[Home] [Help]
117: CLOSE c;
118: l_lock_error := FALSE;
119:
120: IF (l_retcode = 'SUCCESS') THEN
121: l_retcode := xla_aad_loader_util_pvt.lock_area
122: (p_application_id => g_application_id
123: ,p_amb_context_code => g_amb_context_code);
124:
125: IF (l_retcode <> 'SUCCESS') THEN
122: (p_application_id => g_application_id
123: ,p_amb_context_code => g_amb_context_code);
124:
125: IF (l_retcode <> 'SUCCESS') THEN
126: xla_aad_loader_util_pvt.stack_error
127: (p_appli_s_name => 'XLA'
128: ,p_msg_name => 'XLA_AAD_MGR_LOCK_FAILED');
129: l_retcode := 'WARNING';
130: END IF;
151: p_module => l_log_module,
152: p_level => C_LEVEL_PROCEDURE);
153: END IF;
154:
155: xla_aad_loader_util_pvt.stack_error
156: (p_appli_s_name => 'XLA'
157: ,p_msg_name => 'XLA_AAD_MGR_LOCK_FAILED');
158:
159: RETURN l_retcode;
157: ,p_msg_name => 'XLA_AAD_MGR_LOCK_FAILED');
158:
159: RETURN l_retcode;
160: ELSE
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_merge_pvt.pre_merge'
237: END IF;
238:
239: l_retcode := 'SUCCESS';
240:
241: l_retcode := xla_aad_loader_util_pvt.validate_adr_compatibility
242: (p_application_id => g_application_id
243: ,p_amb_context_code => g_amb_context_code
244: ,p_staging_context_code => g_staging_context_code);
245:
250: OPEN c_updated;
251: FETCH c_updated INTO l_exists;
252: IF (c_updated%NOTFOUND) THEN
253: l_retcode := 'WARNING';
254: xla_aad_loader_util_pvt.stack_error
255: (p_appli_s_name => 'XLA'
256: ,p_msg_name => 'XLA_AAD_MER_AMB_UPDATED');
257: END IF;
258: CLOSE c_updated;
261: -- If merge analysis is not run, make sure no AAD has a higher version in
262: -- working area than the original version of the one in the staging area
263: FOR l_err in c_invalid_versions LOOP
264: l_retcode := 'WARNING';
265: xla_aad_loader_util_pvt.stack_error
266: (p_appli_s_name => 'XLA'
267: ,p_msg_name => 'XLA_AAD_MER_INVALID_AAD_VERS'
268: ,p_token_1 => 'PROD_RULE_NAME'
269: ,p_value_1 => l_err.name);
278:
279: return l_retcode;
280: EXCEPTION
281: WHEN OTHERS THEN
282: xla_aad_loader_util_pvt.stack_error
283: (p_appli_s_name => 'XLA'
284: ,p_msg_name => 'XLA_COMMON_ERROR'
285: ,p_token_1 => 'LOCATION'
286: ,p_value_1 => 'xla_aad_merge_pvt.validation'
398: p_level => C_LEVEL_STATEMENT);
399: END IF;
400: -- Bug : 9923803
401: -- API Call to Insert messages into AAD Loader Log Table.
402: xla_aad_loader_util_pvt.insert_aadloaderlog(
403: p_amb_context_code => g_amb_context_code,
404: p_application_id => g_application_id,
405: p_request_code => 'IMPORT' ,
406: p_log_type_code => 'MERGE',
432: END IF;
433:
434: -- Bug : 9923803
435: -- API Call to Insert messages into AAD Loader Log Table.
436: xla_aad_loader_util_pvt.insert_aadloaderlog(
437: p_amb_context_code => g_amb_context_code,
438: p_application_id => g_application_id,
439: p_request_code => 'IMPORT' ,
440: p_log_type_code => 'MERGE',
464: END IF;
465:
466: -- Bug : 9923803
467: -- API Call to Insert messages into AAD Loader Log Table.
468: xla_aad_loader_util_pvt.insert_aadloaderlog(
469: p_amb_context_code => g_amb_context_code,
470: p_application_id => g_application_id,
471: p_request_code => 'IMPORT' ,
472: p_log_type_code => 'MERGE',
493: p_level => C_LEVEL_STATEMENT);
494: END IF;
495: -- Bug : 9923803
496: -- API Call to Insert messages into AAD Loader Log Table.
497: xla_aad_loader_util_pvt.insert_aadloaderlog(
498: p_amb_context_code => g_amb_context_code,
499: p_application_id => g_application_id,
500: p_request_code => 'IMPORT' ,
501: p_log_type_code => 'MERGE',
516: p_level => C_LEVEL_STATEMENT);
517: END IF;
518: -- Bug : 9923803
519: -- API Call to Insert messages into AAD Loader Log Table.
520: xla_aad_loader_util_pvt.insert_aadloaderlog(
521: p_amb_context_code => g_amb_context_code,
522: p_application_id => g_application_id,
523: p_request_code => 'IMPORT' ,
524: p_log_type_code => 'MERGE',
538: p_level => C_LEVEL_STATEMENT);
539: END IF;
540: -- Bug : 9923803
541: -- API Call to Insert messages into AAD Loader Log Table.
542: xla_aad_loader_util_pvt.insert_aadloaderlog(
543: p_amb_context_code => g_amb_context_code,
544: p_application_id => g_application_id,
545: p_request_code => 'IMPORT' ,
546: p_log_type_code => 'MERGE',
559: END IF;
560:
561: EXCEPTION
562: WHEN OTHERS THEN
563: xla_aad_loader_util_pvt.stack_error
564: (p_appli_s_name => 'XLA'
565: ,p_msg_name => 'XLA_COMMON_ERROR'
566: ,p_token_1 => 'LOCATION'
567: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_aads'
641: p_level => C_LEVEL_STATEMENT);
642: END IF;
643: -- Bug : 9923803
644: -- API Call to Insert messages into AAD Loader Log Table.
645: xla_aad_loader_util_pvt.insert_aadloaderlog(
646: p_amb_context_code => g_amb_context_code,
647: p_application_id => g_application_id,
648: p_request_code => 'IMPORT' ,
649: p_log_type_code => 'MERGE',
674: p_level => C_LEVEL_STATEMENT);
675: END IF;
676: -- Bug : 9923803
677: -- API Call to Insert messages into AAD Loader Log Table.
678: xla_aad_loader_util_pvt.insert_aadloaderlog(
679: p_amb_context_code => g_amb_context_code,
680: p_application_id => g_application_id,
681: p_request_code => 'IMPORT' ,
682: p_log_type_code => 'MERGE',
706: p_level => C_LEVEL_STATEMENT);
707: END IF;
708: -- Bug : 9923803
709: -- API Call to Insert messages into AAD Loader Log Table.
710: xla_aad_loader_util_pvt.insert_aadloaderlog(
711: p_amb_context_code => g_amb_context_code,
712: p_application_id => g_application_id,
713: p_request_code => 'IMPORT' ,
714: p_log_type_code => 'MERGE',
737: p_level => C_LEVEL_STATEMENT);
738: END IF;
739: -- Bug : 9923803
740: -- API Call to Insert messages into AAD Loader Log Table.
741: xla_aad_loader_util_pvt.insert_aadloaderlog(
742: p_amb_context_code => g_amb_context_code,
743: p_application_id => g_application_id,
744: p_request_code => 'IMPORT' ,
745: p_log_type_code => 'MERGE',
769: p_level => C_LEVEL_STATEMENT);
770: END IF;
771: -- Bug : 9923803
772: -- API Call to Insert messages into AAD Loader Log Table.
773: xla_aad_loader_util_pvt.insert_aadloaderlog(
774: p_amb_context_code => g_amb_context_code,
775: p_application_id => g_application_id,
776: p_request_code => 'IMPORT' ,
777: p_log_type_code => 'MERGE',
801: p_level => C_LEVEL_STATEMENT);
802: END IF;
803: -- Bug : 9923803
804: -- API Call to Insert messages into AAD Loader Log Table.
805: xla_aad_loader_util_pvt.insert_aadloaderlog(
806: p_amb_context_code => g_amb_context_code,
807: p_application_id => g_application_id,
808: p_request_code => 'IMPORT' ,
809: p_log_type_code => 'MERGE',
835: p_level => C_LEVEL_STATEMENT);
836: END IF;
837: -- Bug : 9923803
838: -- API Call to Insert messages into AAD Loader Log Table.
839: xla_aad_loader_util_pvt.insert_aadloaderlog(
840: p_amb_context_code => g_amb_context_code,
841: p_application_id => g_application_id,
842: p_request_code => 'IMPORT' ,
843: p_log_type_code => 'MERGE',
870: p_level => C_LEVEL_STATEMENT);
871: END IF;
872: -- Bug : 9923803
873: -- API Call to Insert messages into AAD Loader Log Table.
874: xla_aad_loader_util_pvt.insert_aadloaderlog(
875: p_amb_context_code => g_amb_context_code,
876: p_application_id => g_application_id,
877: p_request_code => 'IMPORT' ,
878: p_log_type_code => 'MERGE',
893: p_level => C_LEVEL_STATEMENT);
894: END IF;
895: -- Bug : 9923803
896: -- API Call to Insert messages into AAD Loader Log Table.
897: xla_aad_loader_util_pvt.insert_aadloaderlog(
898: p_amb_context_code => g_amb_context_code,
899: p_application_id => g_application_id,
900: p_request_code => 'IMPORT' ,
901: p_log_type_code => 'MERGE',
917: p_level => C_LEVEL_STATEMENT);
918: END IF;
919: -- Bug : 9923803
920: -- API Call to Insert messages into AAD Loader Log Table.
921: xla_aad_loader_util_pvt.insert_aadloaderlog(
922: p_amb_context_code => g_amb_context_code,
923: p_application_id => g_application_id,
924: p_request_code => 'IMPORT' ,
925: p_log_type_code => 'MERGE',
933: END IF;
934:
935: EXCEPTION
936: WHEN OTHERS THEN
937: xla_aad_loader_util_pvt.stack_error
938: (p_appli_s_name => 'XLA'
939: ,p_msg_name => 'XLA_COMMON_ERROR'
940: ,p_token_1 => 'LOCATION'
941: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_jlds'
1005: p_level => C_LEVEL_STATEMENT);
1006: END IF;
1007: -- Bug : 9923803
1008: -- API Call to Insert messages into AAD Loader Log Table.
1009: xla_aad_loader_util_pvt.insert_aadloaderlog(
1010: p_amb_context_code => g_amb_context_code,
1011: p_application_id => g_application_id,
1012: p_request_code => 'IMPORT' ,
1013: p_log_type_code => 'MERGE',
1028: p_level => C_LEVEL_STATEMENT);
1029: END IF;
1030: -- Bug : 9923803
1031: -- API Call to Insert messages into AAD Loader Log Table.
1032: xla_aad_loader_util_pvt.insert_aadloaderlog(
1033: p_amb_context_code => g_amb_context_code,
1034: p_application_id => g_application_id,
1035: p_request_code => 'IMPORT' ,
1036: p_log_type_code => 'MERGE',
1050: p_level => C_LEVEL_STATEMENT);
1051: END IF;
1052: -- Bug : 9923803
1053: -- API Call to Insert messages into AAD Loader Log Table.
1054: xla_aad_loader_util_pvt.insert_aadloaderlog(
1055: p_amb_context_code => g_amb_context_code,
1056: p_application_id => g_application_id,
1057: p_request_code => 'IMPORT' ,
1058: p_log_type_code => 'MERGE',
1073: p_level => C_LEVEL_STATEMENT);
1074: END IF;
1075: -- Bug : 9923803
1076: -- API Call to Insert messages into AAD Loader Log Table.
1077: xla_aad_loader_util_pvt.insert_aadloaderlog(
1078: p_amb_context_code => g_amb_context_code,
1079: p_application_id => g_application_id,
1080: p_request_code => 'IMPORT' ,
1081: p_log_type_code => 'MERGE',
1095: p_level => C_LEVEL_STATEMENT);
1096: END IF;
1097: -- Bug : 9923803
1098: -- API Call to Insert messages into AAD Loader Log Table.
1099: xla_aad_loader_util_pvt.insert_aadloaderlog(
1100: p_amb_context_code => g_amb_context_code,
1101: p_application_id => g_application_id,
1102: p_request_code => 'IMPORT' ,
1103: p_log_type_code => 'MERGE',
1117: p_level => C_LEVEL_STATEMENT);
1118: END IF;
1119: -- Bug : 9923803
1120: -- API Call to Insert messages into AAD Loader Log Table.
1121: xla_aad_loader_util_pvt.insert_aadloaderlog(
1122: p_amb_context_code => g_amb_context_code,
1123: p_application_id => g_application_id,
1124: p_request_code => 'IMPORT' ,
1125: p_log_type_code => 'MERGE',
1140: p_level => C_LEVEL_STATEMENT);
1141: END IF;
1142: -- Bug : 9923803
1143: -- API Call to Insert messages into AAD Loader Log Table.
1144: xla_aad_loader_util_pvt.insert_aadloaderlog(
1145: p_amb_context_code => g_amb_context_code,
1146: p_application_id => g_application_id,
1147: p_request_code => 'IMPORT' ,
1148: p_log_type_code => 'MERGE',
1164: p_level => C_LEVEL_STATEMENT);
1165: END IF;
1166: -- Bug : 9923803
1167: -- API Call to Insert messages into AAD Loader Log Table.
1168: xla_aad_loader_util_pvt.insert_aadloaderlog(
1169: p_amb_context_code => g_amb_context_code,
1170: p_application_id => g_application_id,
1171: p_request_code => 'IMPORT' ,
1172: p_log_type_code => 'MERGE',
1187: p_level => C_LEVEL_STATEMENT);
1188: END IF;
1189: -- Bug : 9923803
1190: -- API Call to Insert messages into AAD Loader Log Table.
1191: xla_aad_loader_util_pvt.insert_aadloaderlog(
1192: p_amb_context_code => g_amb_context_code,
1193: p_application_id => g_application_id,
1194: p_request_code => 'IMPORT' ,
1195: p_log_type_code => 'MERGE',
1210: p_level => C_LEVEL_STATEMENT);
1211: END IF;
1212: -- Bug : 9923803
1213: -- API Call to Insert messages into AAD Loader Log Table.
1214: xla_aad_loader_util_pvt.insert_aadloaderlog(
1215: p_amb_context_code => g_amb_context_code,
1216: p_application_id => g_application_id,
1217: p_request_code => 'IMPORT' ,
1218: p_log_type_code => 'MERGE',
1234: END IF;
1235:
1236: EXCEPTION
1237: WHEN OTHERS THEN
1238: xla_aad_loader_util_pvt.stack_error
1239: (p_appli_s_name => 'XLA'
1240: ,p_msg_name => 'XLA_COMMON_ERROR'
1241: ,p_token_1 => 'LOCATION'
1242: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_jlts'
1308: p_level => C_LEVEL_STATEMENT);
1309: END IF;
1310: -- Bug : 9923803
1311: -- API Call to Insert messages into AAD Loader Log Table.
1312: xla_aad_loader_util_pvt.insert_aadloaderlog(
1313: p_amb_context_code => g_amb_context_code,
1314: p_application_id => g_application_id,
1315: p_request_code => 'IMPORT' ,
1316: p_log_type_code => 'MERGE',
1333: END IF;
1334:
1335: -- Bug : 9923803
1336: -- API Call to Insert messages into AAD Loader Log Table.
1337: xla_aad_loader_util_pvt.insert_aadloaderlog(
1338: p_amb_context_code => g_amb_context_code,
1339: p_application_id => g_application_id,
1340: p_request_code => 'IMPORT' ,
1341: p_log_type_code => 'MERGE',
1360: p_level => C_LEVEL_STATEMENT);
1361: END IF;
1362: -- Bug : 9923803
1363: -- API Call to Insert messages into AAD Loader Log Table.
1364: xla_aad_loader_util_pvt.insert_aadloaderlog(
1365: p_amb_context_code => g_amb_context_code,
1366: p_application_id => g_application_id,
1367: p_request_code => 'IMPORT' ,
1368: p_log_type_code => 'MERGE',
1385: p_level => C_LEVEL_STATEMENT);
1386: END IF;
1387: -- Bug : 9923803
1388: -- API Call to Insert messages into AAD Loader Log Table.
1389: xla_aad_loader_util_pvt.insert_aadloaderlog(
1390: p_amb_context_code => g_amb_context_code,
1391: p_application_id => g_application_id,
1392: p_request_code => 'IMPORT' ,
1393: p_log_type_code => 'MERGE',
1407: p_level => C_LEVEL_STATEMENT);
1408: END IF;
1409: -- Bug : 9923803
1410: -- API Call to Insert messages into AAD Loader Log Table.
1411: xla_aad_loader_util_pvt.insert_aadloaderlog(
1412: p_amb_context_code => g_amb_context_code,
1413: p_application_id => g_application_id,
1414: p_request_code => 'IMPORT' ,
1415: p_log_type_code => 'MERGE',
1429: p_level => C_LEVEL_STATEMENT);
1430: END IF;
1431: -- Bug : 9923803
1432: -- API Call to Insert messages into AAD Loader Log Table.
1433: xla_aad_loader_util_pvt.insert_aadloaderlog(
1434: p_amb_context_code => g_amb_context_code,
1435: p_application_id => g_application_id,
1436: p_request_code => 'IMPORT' ,
1437: p_log_type_code => 'MERGE',
1451: p_level => C_LEVEL_STATEMENT);
1452: END IF;
1453: -- Bug : 9923803
1454: -- API Call to Insert messages into AAD Loader Log Table.
1455: xla_aad_loader_util_pvt.insert_aadloaderlog(
1456: p_amb_context_code => g_amb_context_code,
1457: p_application_id => g_application_id,
1458: p_request_code => 'IMPORT' ,
1459: p_log_type_code => 'MERGE',
1468: END IF;
1469:
1470: EXCEPTION
1471: WHEN OTHERS THEN
1472: xla_aad_loader_util_pvt.stack_error
1473: (p_appli_s_name => 'XLA'
1474: ,p_msg_name => 'XLA_COMMON_ERROR'
1475: ,p_token_1 => 'LOCATION'
1476: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_descriptions'
1535: p_level => C_LEVEL_PROCEDURE);
1536: END IF;
1537: -- Bug : 9923803
1538: -- API Call to Insert messages into AAD Loader Log Table.
1539: xla_aad_loader_util_pvt.insert_aadloaderlog(
1540: p_amb_context_code => g_amb_context_code,
1541: p_application_id => g_application_id,
1542: p_request_code => 'IMPORT' ,
1543: p_log_type_code => 'MERGE',
1616: p_level => C_LEVEL_STATEMENT);
1617: END IF;
1618: -- Bug : 9923803
1619: -- API Call to Insert messages into AAD Loader Log Table.
1620: xla_aad_loader_util_pvt.insert_aadloaderlog(
1621: p_amb_context_code => g_amb_context_code,
1622: p_application_id => g_application_id,
1623: p_request_code => 'IMPORT' ,
1624: p_log_type_code => 'MERGE',
1639: p_level => C_LEVEL_STATEMENT);
1640: END IF;
1641: -- Bug : 9923803
1642: -- API Call to Insert messages into AAD Loader Log Table.
1643: xla_aad_loader_util_pvt.insert_aadloaderlog(
1644: p_amb_context_code => g_amb_context_code,
1645: p_application_id => g_application_id,
1646: p_request_code => 'IMPORT' ,
1647: p_log_type_code => 'MERGE',
1661: p_level => C_LEVEL_STATEMENT);
1662: END IF;
1663: -- Bug : 9923803
1664: -- API Call to Insert messages into AAD Loader Log Table.
1665: xla_aad_loader_util_pvt.insert_aadloaderlog(
1666: p_amb_context_code => g_amb_context_code,
1667: p_application_id => g_application_id,
1668: p_request_code => 'IMPORT' ,
1669: p_log_type_code => 'MERGE',
1683: p_level => C_LEVEL_STATEMENT);
1684: END IF;
1685: -- Bug : 9923803
1686: -- API Call to Insert messages into AAD Loader Log Table.
1687: xla_aad_loader_util_pvt.insert_aadloaderlog(
1688: p_amb_context_code => g_amb_context_code,
1689: p_application_id => g_application_id,
1690: p_request_code => 'IMPORT' ,
1691: p_log_type_code => 'MERGE',
1706: p_level => C_LEVEL_STATEMENT);
1707: END IF;
1708: -- Bug : 9923803
1709: -- API Call to Insert messages into AAD Loader Log Table.
1710: xla_aad_loader_util_pvt.insert_aadloaderlog(
1711: p_amb_context_code => g_amb_context_code,
1712: p_application_id => g_application_id,
1713: p_request_code => 'IMPORT' ,
1714: p_log_type_code => 'MERGE',
1728: p_level => C_LEVEL_STATEMENT);
1729: END IF;
1730: -- Bug : 9923803
1731: -- API Call to Insert messages into AAD Loader Log Table.
1732: xla_aad_loader_util_pvt.insert_aadloaderlog(
1733: p_amb_context_code => g_amb_context_code,
1734: p_application_id => g_application_id,
1735: p_request_code => 'IMPORT' ,
1736: p_log_type_code => 'MERGE',
1750: p_level => C_LEVEL_STATEMENT);
1751: END IF;
1752: -- Bug : 9923803
1753: -- API Call to Insert messages into AAD Loader Log Table.
1754: xla_aad_loader_util_pvt.insert_aadloaderlog(
1755: p_amb_context_code => g_amb_context_code,
1756: p_application_id => g_application_id,
1757: p_request_code => 'IMPORT' ,
1758: p_log_type_code => 'MERGE',
1767: END IF;
1768:
1769: EXCEPTION
1770: WHEN OTHERS THEN
1771: xla_aad_loader_util_pvt.stack_error
1772: (p_appli_s_name => 'XLA'
1773: ,p_msg_name => 'XLA_COMMON_ERROR'
1774: ,p_token_1 => 'LOCATION'
1775: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_adrs'
1901: END IF;
1902:
1903: -- Bug : 9923803
1904: -- API Call to Insert messages into AAD Loader Log Table.
1905: xla_aad_loader_util_pvt.insert_aadloaderlog(
1906: p_amb_context_code => g_amb_context_code,
1907: p_application_id => g_application_id,
1908: p_request_code => 'IMPORT' ,
1909: p_log_type_code => 'MERGE',
1975: END IF;
1976:
1977: EXCEPTION
1978: WHEN OTHERS THEN
1979: xla_aad_loader_util_pvt.stack_error
1980: (p_appli_s_name => 'XLA'
1981: ,p_msg_name => 'XLA_COMMON_ERROR'
1982: ,p_token_1 => 'LOCATION'
1983: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_acs'
2010:
2011: clean_oracle_aads;
2012: -- Bug : 12969337
2013: -- API Call to Insert messages into AAD Loader Log Table.
2014: xla_aad_loader_util_pvt.insert_aadloaderlog(
2015: p_amb_context_code => g_amb_context_code,
2016: p_application_id => g_application_id,
2017: p_request_code => 'IMPORT' ,
2018: p_log_type_code => 'MERGE',
2020: p_component_code => 'clean_oracle_aads');
2021: clean_oracle_jlds;
2022: -- Bug : 12969337
2023: -- API Call to Insert messages into AAD Loader Log Table.
2024: xla_aad_loader_util_pvt.insert_aadloaderlog(
2025: p_amb_context_code => g_amb_context_code,
2026: p_application_id => g_application_id,
2027: p_request_code => 'IMPORT' ,
2028: p_log_type_code => 'MERGE',
2030: p_component_code => 'clean_oracle_jlds');
2031: clean_oracle_jlts;
2032: -- Bug : 12969337
2033: -- API Call to Insert messages into AAD Loader Log Table.
2034: xla_aad_loader_util_pvt.insert_aadloaderlog(
2035: p_amb_context_code => g_amb_context_code,
2036: p_application_id => g_application_id,
2037: p_request_code => 'IMPORT' ,
2038: p_log_type_code => 'MERGE',
2040: p_component_code => 'clean_oracle_jlts');
2041: clean_oracle_descriptions;
2042: -- Bug : 12969337
2043: -- API Call to Insert messages into AAD Loader Log Table.
2044: xla_aad_loader_util_pvt.insert_aadloaderlog(
2045: p_amb_context_code => g_amb_context_code,
2046: p_application_id => g_application_id,
2047: p_request_code => 'IMPORT' ,
2048: p_log_type_code => 'MERGE',
2050: p_component_code => 'clean_oracle_descriptions');
2051: clean_oracle_adrs;
2052: -- Bug : 12969337
2053: -- API Call to Insert messages into AAD Loader Log Table.
2054: xla_aad_loader_util_pvt.insert_aadloaderlog(
2055: p_amb_context_code => g_amb_context_code,
2056: p_application_id => g_application_id,
2057: p_request_code => 'IMPORT' ,
2058: p_log_type_code => 'MERGE',
2060: p_component_code => 'clean_oracle_adrs');
2061: clean_oracle_acs;
2062: -- Bug : 12969337
2063: -- API Call to Insert messages into AAD Loader Log Table.
2064: xla_aad_loader_util_pvt.insert_aadloaderlog(
2065: p_amb_context_code => g_amb_context_code,
2066: p_application_id => g_application_id,
2067: p_request_code => 'IMPORT' ,
2068: p_log_type_code => 'MERGE',
2076: END IF;
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_merge_pvt.clean_oracle_components'
2218: p_level => C_LEVEL_PROCEDURE);
2219: END IF;
2220: -- Bug : 9923803
2221: -- API Call to Insert messages into AAD Loader Log Table.
2222: xla_aad_loader_util_pvt.insert_aadloaderlog(
2223: p_amb_context_code => g_amb_context_code,
2224: p_application_id => g_application_id,
2225: p_request_code => 'IMPORT' ,
2226: p_log_type_code => 'MERGE',
2278: p_level => C_LEVEL_PROCEDURE);
2279: END IF;
2280: -- Bug : 9923803
2281: -- API Call to Insert messages into AAD Loader Log Table.
2282: xla_aad_loader_util_pvt.insert_aadloaderlog(
2283: p_amb_context_code => g_amb_context_code,
2284: p_application_id => g_application_id,
2285: p_request_code => 'IMPORT' ,
2286: p_log_type_code => 'MERGE',
2338: p_level => C_LEVEL_PROCEDURE);
2339: END IF;
2340: -- Bug : 9923803
2341: -- API Call to Insert messages into AAD Loader Log Table.
2342: xla_aad_loader_util_pvt.insert_aadloaderlog(
2343: p_amb_context_code => g_amb_context_code,
2344: p_application_id => g_application_id,
2345: p_request_code => 'IMPORT' ,
2346: p_log_type_code => 'MERGE',
2366: p_level => C_LEVEL_PROCEDURE);
2367: END IF;
2368: -- Bug : 9923803
2369: -- API Call to Insert messages into AAD Loader Log Table.
2370: xla_aad_loader_util_pvt.insert_aadloaderlog(
2371: p_amb_context_code => g_amb_context_code,
2372: p_application_id => g_application_id,
2373: p_request_code => 'IMPORT' ,
2374: p_log_type_code => 'MERGE',
2393: p_level => C_LEVEL_STATEMENT);
2394: END IF;
2395: -- Bug : 9923803
2396: -- API Call to Insert messages into AAD Loader Log Table.
2397: xla_aad_loader_util_pvt.insert_aadloaderlog(
2398: p_amb_context_code => g_amb_context_code,
2399: p_application_id => g_application_id,
2400: p_request_code => 'IMPORT' ,
2401: p_log_type_code => 'MERGE',
2419: p_level => C_LEVEL_STATEMENT);
2420: END IF;
2421: -- Bug : 9923803
2422: -- API Call to Insert messages into AAD Loader Log Table.
2423: xla_aad_loader_util_pvt.insert_aadloaderlog(
2424: p_amb_context_code => g_amb_context_code,
2425: p_application_id => g_application_id,
2426: p_request_code => 'IMPORT' ,
2427: p_log_type_code => 'MERGE',
2446: p_level => C_LEVEL_STATEMENT);
2447: END IF;
2448: -- Bug : 9923803
2449: -- API Call to Insert messages into AAD Loader Log Table.
2450: xla_aad_loader_util_pvt.insert_aadloaderlog(
2451: p_amb_context_code => g_amb_context_code,
2452: p_application_id => g_application_id,
2453: p_request_code => 'IMPORT' ,
2454: p_log_type_code => 'MERGE',
2475: p_level => C_LEVEL_STATEMENT);
2476: END IF;
2477: -- Bug : 9923803
2478: -- API Call to Insert messages into AAD Loader Log Table.
2479: xla_aad_loader_util_pvt.insert_aadloaderlog(
2480: p_amb_context_code => g_amb_context_code,
2481: p_application_id => g_application_id,
2482: p_request_code => 'IMPORT' ,
2483: p_log_type_code => 'MERGE',
2517: p_level => C_LEVEL_STATEMENT);
2518: END IF;
2519: -- Bug : 9923803
2520: -- API Call to Insert messages into AAD Loader Log Table.
2521: xla_aad_loader_util_pvt.insert_aadloaderlog(
2522: p_amb_context_code => g_amb_context_code,
2523: p_application_id => g_application_id,
2524: p_request_code => 'IMPORT' ,
2525: p_log_type_code => 'MERGE',
2539: p_level => C_LEVEL_STATEMENT);
2540: END IF;
2541: -- Bug : 9923803
2542: -- API Call to Insert messages into AAD Loader Log Table.
2543: xla_aad_loader_util_pvt.insert_aadloaderlog(
2544: p_amb_context_code => g_amb_context_code,
2545: p_application_id => g_application_id,
2546: p_request_code => 'IMPORT' ,
2547: p_log_type_code => 'MERGE',
2566: p_level => C_LEVEL_STATEMENT);
2567: END IF;
2568: -- Bug : 9923803
2569: -- API Call to Insert messages into AAD Loader Log Table.
2570: xla_aad_loader_util_pvt.insert_aadloaderlog(
2571: p_amb_context_code => g_amb_context_code,
2572: p_application_id => g_application_id,
2573: p_request_code => 'IMPORT' ,
2574: p_log_type_code => 'MERGE',
2594: p_level => C_LEVEL_STATEMENT);
2595: END IF;
2596: -- Bug : 9923803
2597: -- API Call to Insert messages into AAD Loader Log Table.
2598: xla_aad_loader_util_pvt.insert_aadloaderlog(
2599: p_amb_context_code => g_amb_context_code,
2600: p_application_id => g_application_id,
2601: p_request_code => 'IMPORT' ,
2602: p_log_type_code => 'MERGE',
2613: p_level => C_LEVEL_STATEMENT);
2614: END IF;
2615: -- Bug : 9923803
2616: -- API Call to Insert messages into AAD Loader Log Table.
2617: xla_aad_loader_util_pvt.insert_aadloaderlog(
2618: p_amb_context_code => g_amb_context_code,
2619: p_application_id => g_application_id,
2620: p_request_code => 'IMPORT' ,
2621: p_log_type_code => 'MERGE',
2633: p_level => C_LEVEL_STATEMENT);
2634: END IF;
2635: -- Bug : 9923803
2636: -- API Call to Insert messages into AAD Loader Log Table.
2637: xla_aad_loader_util_pvt.insert_aadloaderlog(
2638: p_amb_context_code => g_amb_context_code,
2639: p_application_id => g_application_id,
2640: p_request_code => 'IMPORT' ,
2641: p_log_type_code => 'MERGE',
2653: p_level => C_LEVEL_STATEMENT);
2654: END IF;
2655: -- Bug : 9923803
2656: -- API Call to Insert messages into AAD Loader Log Table.
2657: xla_aad_loader_util_pvt.insert_aadloaderlog(
2658: p_amb_context_code => g_amb_context_code,
2659: p_application_id => g_application_id,
2660: p_request_code => 'IMPORT' ,
2661: p_log_type_code => 'MERGE',
2673: p_level => C_LEVEL_STATEMENT);
2674: END IF;
2675: -- Bug : 9923803
2676: -- API Call to Insert messages into AAD Loader Log Table.
2677: xla_aad_loader_util_pvt.insert_aadloaderlog(
2678: p_amb_context_code => g_amb_context_code,
2679: p_application_id => g_application_id,
2680: p_request_code => 'IMPORT' ,
2681: p_log_type_code => 'MERGE',
2688: END IF;
2689:
2690: EXCEPTION
2691: WHEN OTHERS THEN
2692: xla_aad_loader_util_pvt.stack_error
2693: (p_appli_s_name => 'XLA'
2694: ,p_msg_name => 'XLA_COMMON_ERROR'
2695: ,p_token_1 => 'LOCATION'
2696: ,p_value_1 => 'xla_aad_merge_pvt.merge_aads'
2772: p_level => C_LEVEL_PROCEDURE);
2773: END IF;
2774: -- Bug : 9923803
2775: -- API Call to Insert messages into AAD Loader Log Table.
2776: xla_aad_loader_util_pvt.insert_aadloaderlog(
2777: p_amb_context_code => g_amb_context_code,
2778: p_application_id => g_application_id,
2779: p_request_code => 'IMPORT' ,
2780: p_log_type_code => 'MERGE',
2833: p_level => C_LEVEL_PROCEDURE);
2834: END IF;
2835: -- Bug : 9923803
2836: -- API Call to Insert messages into AAD Loader Log Table.
2837: xla_aad_loader_util_pvt.insert_aadloaderlog(
2838: p_amb_context_code => g_amb_context_code,
2839: p_application_id => g_application_id,
2840: p_request_code => 'IMPORT' ,
2841: p_log_type_code => 'MERGE',
2899: p_level => C_LEVEL_PROCEDURE);
2900: END IF;
2901: -- Bug : 9923803
2902: -- API Call to Insert messages into AAD Loader Log Table.
2903: xla_aad_loader_util_pvt.insert_aadloaderlog(
2904: p_amb_context_code => g_amb_context_code,
2905: p_application_id => g_application_id,
2906: p_request_code => 'IMPORT' ,
2907: p_log_type_code => 'MERGE',
2966: p_level => C_LEVEL_PROCEDURE);
2967: END IF;
2968: -- Bug : 9923803
2969: -- API Call to Insert messages into AAD Loader Log Table.
2970: xla_aad_loader_util_pvt.insert_aadloaderlog(
2971: p_amb_context_code => g_amb_context_code,
2972: p_application_id => g_application_id,
2973: p_request_code => 'IMPORT' ,
2974: p_log_type_code => 'MERGE',
3037: p_level => C_LEVEL_PROCEDURE);
3038: END IF;
3039: -- Bug : 9923803
3040: -- API Call to Insert messages into AAD Loader Log Table.
3041: xla_aad_loader_util_pvt.insert_aadloaderlog(
3042: p_amb_context_code => g_amb_context_code,
3043: p_application_id => g_application_id,
3044: p_request_code => 'IMPORT' ,
3045: p_log_type_code => 'MERGE',
3117: p_level => C_LEVEL_PROCEDURE);
3118: END IF;
3119: -- Bug : 9923803
3120: -- API Call to Insert messages into AAD Loader Log Table.
3121: xla_aad_loader_util_pvt.insert_aadloaderlog(
3122: p_amb_context_code => g_amb_context_code,
3123: p_application_id => g_application_id,
3124: p_request_code => 'IMPORT' ,
3125: p_log_type_code => 'MERGE',
3207: p_level => C_LEVEL_PROCEDURE);
3208: END IF;
3209: -- Bug : 9923803
3210: -- API Call to Insert messages into AAD Loader Log Table.
3211: xla_aad_loader_util_pvt.insert_aadloaderlog(
3212: p_amb_context_code => g_amb_context_code,
3213: p_application_id => g_application_id,
3214: p_request_code => 'IMPORT' ,
3215: p_log_type_code => 'MERGE',
3293: p_level => C_LEVEL_PROCEDURE);
3294: END IF;
3295: -- Bug : 9923803
3296: -- API Call to Insert messages into AAD Loader Log Table.
3297: xla_aad_loader_util_pvt.insert_aadloaderlog(
3298: p_amb_context_code => g_amb_context_code,
3299: p_application_id => g_application_id,
3300: p_request_code => 'IMPORT' ,
3301: p_log_type_code => 'MERGE',
3327: p_level => C_LEVEL_STATEMENT);
3328: END IF;
3329: -- Bug : 9923803
3330: -- API Call to Insert messages into AAD Loader Log Table.
3331: xla_aad_loader_util_pvt.insert_aadloaderlog(
3332: p_amb_context_code => g_amb_context_code,
3333: p_application_id => g_application_id,
3334: p_request_code => 'IMPORT' ,
3335: p_log_type_code => 'MERGE',
3355: p_level => C_LEVEL_STATEMENT);
3356: END IF;
3357: -- Bug : 9923803
3358: -- API Call to Insert messages into AAD Loader Log Table.
3359: xla_aad_loader_util_pvt.insert_aadloaderlog(
3360: p_amb_context_code => g_amb_context_code,
3361: p_application_id => g_application_id,
3362: p_request_code => 'IMPORT' ,
3363: p_log_type_code => 'MERGE',
3385: p_level => C_LEVEL_STATEMENT);
3386: END IF;
3387: -- Bug : 9923803
3388: -- API Call to Insert messages into AAD Loader Log Table.
3389: xla_aad_loader_util_pvt.insert_aadloaderlog(
3390: p_amb_context_code => g_amb_context_code,
3391: p_application_id => g_application_id,
3392: p_request_code => 'IMPORT' ,
3393: p_log_type_code => 'MERGE',
3418: p_level => C_LEVEL_STATEMENT);
3419: END IF;
3420: -- Bug : 9923803
3421: -- API Call to Insert messages into AAD Loader Log Table.
3422: xla_aad_loader_util_pvt.insert_aadloaderlog(
3423: p_amb_context_code => g_amb_context_code,
3424: p_application_id => g_application_id,
3425: p_request_code => 'IMPORT' ,
3426: p_log_type_code => 'MERGE',
3449: p_level => C_LEVEL_STATEMENT);
3450: END IF;
3451: -- Bug : 9923803
3452: -- API Call to Insert messages into AAD Loader Log Table.
3453: xla_aad_loader_util_pvt.insert_aadloaderlog(
3454: p_amb_context_code => g_amb_context_code,
3455: p_application_id => g_application_id,
3456: p_request_code => 'IMPORT' ,
3457: p_log_type_code => 'MERGE',
3478: p_level => C_LEVEL_STATEMENT);
3479: END IF;
3480: -- Bug : 9923803
3481: -- API Call to Insert messages into AAD Loader Log Table.
3482: xla_aad_loader_util_pvt.insert_aadloaderlog(
3483: p_amb_context_code => g_amb_context_code,
3484: p_application_id => g_application_id,
3485: p_request_code => 'IMPORT' ,
3486: p_log_type_code => 'MERGE',
3519: p_level => C_LEVEL_STATEMENT);
3520: END IF;
3521: -- Bug : 9923803
3522: -- API Call to Insert messages into AAD Loader Log Table.
3523: xla_aad_loader_util_pvt.insert_aadloaderlog(
3524: p_amb_context_code => g_amb_context_code,
3525: p_application_id => g_application_id,
3526: p_request_code => 'IMPORT' ,
3527: p_log_type_code => 'MERGE',
3562: p_level => C_LEVEL_STATEMENT);
3563: END IF;
3564: -- Bug : 9923803
3565: -- API Call to Insert messages into AAD Loader Log Table.
3566: xla_aad_loader_util_pvt.insert_aadloaderlog(
3567: p_amb_context_code => g_amb_context_code,
3568: p_application_id => g_application_id,
3569: p_request_code => 'IMPORT' ,
3570: p_log_type_code => 'MERGE',
3606: p_level => C_LEVEL_STATEMENT);
3607: END IF;
3608: -- Bug : 9923803
3609: -- API Call to Insert messages into AAD Loader Log Table.
3610: xla_aad_loader_util_pvt.insert_aadloaderlog(
3611: p_amb_context_code => g_amb_context_code,
3612: p_application_id => g_application_id,
3613: p_request_code => 'IMPORT' ,
3614: p_log_type_code => 'MERGE',
3629: p_level => C_LEVEL_STATEMENT);
3630: END IF;
3631: -- Bug : 9923803
3632: -- API Call to Insert messages into AAD Loader Log Table.
3633: xla_aad_loader_util_pvt.insert_aadloaderlog(
3634: p_amb_context_code => g_amb_context_code,
3635: p_application_id => g_application_id,
3636: p_request_code => 'IMPORT' ,
3637: p_log_type_code => 'MERGE',
3658: p_level => C_LEVEL_STATEMENT);
3659: END IF;
3660: -- Bug : 9923803
3661: -- API Call to Insert messages into AAD Loader Log Table.
3662: xla_aad_loader_util_pvt.insert_aadloaderlog(
3663: p_amb_context_code => g_amb_context_code,
3664: p_application_id => g_application_id,
3665: p_request_code => 'IMPORT' ,
3666: p_log_type_code => 'MERGE',
3688: p_level => C_LEVEL_STATEMENT);
3689: END IF;
3690: -- Bug : 9923803
3691: -- API Call to Insert messages into AAD Loader Log Table.
3692: xla_aad_loader_util_pvt.insert_aadloaderlog(
3693: p_amb_context_code => g_amb_context_code,
3694: p_application_id => g_application_id,
3695: p_request_code => 'IMPORT' ,
3696: p_log_type_code => 'MERGE',
3708: p_level => C_LEVEL_STATEMENT);
3709: END IF;
3710: -- Bug : 9923803
3711: -- API Call to Insert messages into AAD Loader Log Table.
3712: xla_aad_loader_util_pvt.insert_aadloaderlog(
3713: p_amb_context_code => g_amb_context_code,
3714: p_application_id => g_application_id,
3715: p_request_code => 'IMPORT' ,
3716: p_log_type_code => 'MERGE',
3728: p_level => C_LEVEL_STATEMENT);
3729: END IF;
3730: -- Bug : 9923803
3731: -- API Call to Insert messages into AAD Loader Log Table.
3732: xla_aad_loader_util_pvt.insert_aadloaderlog(
3733: p_amb_context_code => g_amb_context_code,
3734: p_application_id => g_application_id,
3735: p_request_code => 'IMPORT' ,
3736: p_log_type_code => 'MERGE',
3748: p_level => C_LEVEL_STATEMENT);
3749: END IF;
3750: -- Bug : 9923803
3751: -- API Call to Insert messages into AAD Loader Log Table.
3752: xla_aad_loader_util_pvt.insert_aadloaderlog(
3753: p_amb_context_code => g_amb_context_code,
3754: p_application_id => g_application_id,
3755: p_request_code => 'IMPORT' ,
3756: p_log_type_code => 'MERGE',
3768: p_level => C_LEVEL_STATEMENT);
3769: END IF;
3770: -- Bug : 9923803
3771: -- API Call to Insert messages into AAD Loader Log Table.
3772: xla_aad_loader_util_pvt.insert_aadloaderlog(
3773: p_amb_context_code => g_amb_context_code,
3774: p_application_id => g_application_id,
3775: p_request_code => 'IMPORT' ,
3776: p_log_type_code => 'MERGE',
3788: p_level => C_LEVEL_STATEMENT);
3789: END IF;
3790: -- Bug : 9923803
3791: -- API Call to Insert messages into AAD Loader Log Table.
3792: xla_aad_loader_util_pvt.insert_aadloaderlog(
3793: p_amb_context_code => g_amb_context_code,
3794: p_application_id => g_application_id,
3795: p_request_code => 'IMPORT' ,
3796: p_log_type_code => 'MERGE',
3808: p_level => C_LEVEL_STATEMENT);
3809: END IF;
3810: -- Bug : 9923803
3811: -- API Call to Insert messages into AAD Loader Log Table.
3812: xla_aad_loader_util_pvt.insert_aadloaderlog(
3813: p_amb_context_code => g_amb_context_code,
3814: p_application_id => g_application_id,
3815: p_request_code => 'IMPORT' ,
3816: p_log_type_code => 'MERGE',
3835: p_level => C_LEVEL_STATEMENT);
3836: END IF;
3837: -- Bug : 9923803
3838: -- API Call to Insert messages into AAD Loader Log Table.
3839: xla_aad_loader_util_pvt.insert_aadloaderlog(
3840: p_amb_context_code => g_amb_context_code,
3841: p_application_id => g_application_id,
3842: p_request_code => 'IMPORT' ,
3843: p_log_type_code => 'MERGE',
3850: END IF;
3851:
3852: EXCEPTION
3853: WHEN OTHERS THEN
3854: xla_aad_loader_util_pvt.stack_error
3855: (p_appli_s_name => 'XLA'
3856: ,p_msg_name => 'XLA_COMMON_ERROR'
3857: ,p_token_1 => 'LOCATION'
3858: ,p_value_1 => 'xla_aad_merge_pvt.merge_journal_line_defns'
3939: END IF;
3940:
3941: -- Bug : 9923803
3942: -- API Call to Insert messages into AAD Loader Log Table.
3943: xla_aad_loader_util_pvt.insert_aadloaderlog(
3944: p_amb_context_code => g_amb_context_code,
3945: p_application_id => g_application_id,
3946: p_request_code => 'IMPORT' ,
3947: p_log_type_code => 'MERGE',
3993: p_level => C_LEVEL_PROCEDURE);
3994: END IF;
3995: -- Bug : 9923803
3996: -- API Call to Insert messages into AAD Loader Log Table.
3997: xla_aad_loader_util_pvt.insert_aadloaderlog(
3998: p_amb_context_code => g_amb_context_code,
3999: p_application_id => g_application_id,
4000: p_request_code => 'IMPORT' ,
4001: p_log_type_code => 'MERGE',
4058: p_level => C_LEVEL_PROCEDURE);
4059: END IF;
4060: -- Bug : 9923803
4061: -- API Call to Insert messages into AAD Loader Log Table.
4062: xla_aad_loader_util_pvt.insert_aadloaderlog(
4063: p_amb_context_code => g_amb_context_code,
4064: p_application_id => g_application_id,
4065: p_request_code => 'IMPORT' ,
4066: p_log_type_code => 'MERGE',
4091: p_level => C_LEVEL_STATEMENT);
4092: END IF;
4093: -- Bug : 9923803
4094: -- API Call to Insert messages into AAD Loader Log Table.
4095: xla_aad_loader_util_pvt.insert_aadloaderlog(
4096: p_amb_context_code => g_amb_context_code,
4097: p_application_id => g_application_id,
4098: p_request_code => 'IMPORT' ,
4099: p_log_type_code => 'MERGE',
4118: p_level => C_LEVEL_STATEMENT);
4119: END IF;
4120: -- Bug : 9923803
4121: -- API Call to Insert messages into AAD Loader Log Table.
4122: xla_aad_loader_util_pvt.insert_aadloaderlog(
4123: p_amb_context_code => g_amb_context_code,
4124: p_application_id => g_application_id,
4125: p_request_code => 'IMPORT' ,
4126: p_log_type_code => 'MERGE',
4144: p_level => C_LEVEL_STATEMENT);
4145: END IF;
4146: -- Bug : 9923803
4147: -- API Call to Insert messages into AAD Loader Log Table.
4148: xla_aad_loader_util_pvt.insert_aadloaderlog(
4149: p_amb_context_code => g_amb_context_code,
4150: p_application_id => g_application_id,
4151: p_request_code => 'IMPORT' ,
4152: p_log_type_code => 'MERGE',
4170: p_level => C_LEVEL_STATEMENT);
4171: END IF;
4172: -- Bug : 9923803
4173: -- API Call to Insert messages into AAD Loader Log Table.
4174: xla_aad_loader_util_pvt.insert_aadloaderlog(
4175: p_amb_context_code => g_amb_context_code,
4176: p_application_id => g_application_id,
4177: p_request_code => 'IMPORT' ,
4178: p_log_type_code => 'MERGE',
4192: p_level => C_LEVEL_STATEMENT);
4193: END IF;
4194: -- Bug : 9923803
4195: -- API Call to Insert messages into AAD Loader Log Table.
4196: xla_aad_loader_util_pvt.insert_aadloaderlog(
4197: p_amb_context_code => g_amb_context_code,
4198: p_application_id => g_application_id,
4199: p_request_code => 'IMPORT' ,
4200: p_log_type_code => 'MERGE',
4221: p_level => C_LEVEL_STATEMENT);
4222: END IF;
4223: -- Bug : 9923803
4224: -- API Call to Insert messages into AAD Loader Log Table.
4225: xla_aad_loader_util_pvt.insert_aadloaderlog(
4226: p_amb_context_code => g_amb_context_code,
4227: p_application_id => g_application_id,
4228: p_request_code => 'IMPORT' ,
4229: p_log_type_code => 'MERGE',
4250: p_level => C_LEVEL_STATEMENT);
4251: END IF;
4252: -- Bug : 9923803
4253: -- API Call to Insert messages into AAD Loader Log Table.
4254: xla_aad_loader_util_pvt.insert_aadloaderlog(
4255: p_amb_context_code => g_amb_context_code,
4256: p_application_id => g_application_id,
4257: p_request_code => 'IMPORT' ,
4258: p_log_type_code => 'MERGE',
4270: p_level => C_LEVEL_STATEMENT);
4271: END IF;
4272: -- Bug : 9923803
4273: -- API Call to Insert messages into AAD Loader Log Table.
4274: xla_aad_loader_util_pvt.insert_aadloaderlog(
4275: p_amb_context_code => g_amb_context_code,
4276: p_application_id => g_application_id,
4277: p_request_code => 'IMPORT' ,
4278: p_log_type_code => 'MERGE',
4291: p_level => C_LEVEL_STATEMENT);
4292: END IF;
4293: -- Bug : 9923803
4294: -- API Call to Insert messages into AAD Loader Log Table.
4295: xla_aad_loader_util_pvt.insert_aadloaderlog(
4296: p_amb_context_code => g_amb_context_code,
4297: p_application_id => g_application_id,
4298: p_request_code => 'IMPORT' ,
4299: p_log_type_code => 'MERGE',
4307: END IF;
4308:
4309: EXCEPTION
4310: WHEN OTHERS THEN
4311: xla_aad_loader_util_pvt.stack_error
4312: (p_appli_s_name => 'XLA'
4313: ,p_msg_name => 'XLA_COMMON_ERROR'
4314: ,p_token_1 => 'LOCATION'
4315: ,p_value_1 => 'xla_aad_merge_pvt.merge_journal_line_types'
4381: p_level => C_LEVEL_PROCEDURE);
4382: END IF;
4383: -- Bug : 9923803
4384: -- API Call to Insert messages into AAD Loader Log Table.
4385: xla_aad_loader_util_pvt.insert_aadloaderlog(
4386: p_amb_context_code => g_amb_context_code,
4387: p_application_id => g_application_id,
4388: p_request_code => 'IMPORT' ,
4389: p_log_type_code => 'MERGE',
4425: p_level => C_LEVEL_PROCEDURE);
4426: END IF;
4427: -- Bug : 9923803
4428: -- API Call to Insert messages into AAD Loader Log Table.
4429: xla_aad_loader_util_pvt.insert_aadloaderlog(
4430: p_amb_context_code => g_amb_context_code,
4431: p_application_id => g_application_id,
4432: p_request_code => 'IMPORT' ,
4433: p_log_type_code => 'MERGE',
4472: p_level => C_LEVEL_PROCEDURE);
4473: END IF;
4474: -- Bug : 9923803
4475: -- API Call to Insert messages into AAD Loader Log Table.
4476: xla_aad_loader_util_pvt.insert_aadloaderlog(
4477: p_amb_context_code => g_amb_context_code,
4478: p_application_id => g_application_id,
4479: p_request_code => 'IMPORT' ,
4480: p_log_type_code => 'MERGE',
4505: p_level => C_LEVEL_STATEMENT);
4506: END IF;
4507: -- Bug : 9923803
4508: -- API Call to Insert messages into AAD Loader Log Table.
4509: xla_aad_loader_util_pvt.insert_aadloaderlog(
4510: p_amb_context_code => g_amb_context_code,
4511: p_application_id => g_application_id,
4512: p_request_code => 'IMPORT' ,
4513: p_log_type_code => 'MERGE',
4532: p_level => C_LEVEL_STATEMENT);
4533: END IF;
4534: -- Bug : 9923803
4535: -- API Call to Insert messages into AAD Loader Log Table.
4536: xla_aad_loader_util_pvt.insert_aadloaderlog(
4537: p_amb_context_code => g_amb_context_code,
4538: p_application_id => g_application_id,
4539: p_request_code => 'IMPORT' ,
4540: p_log_type_code => 'MERGE',
4557: p_level => C_LEVEL_STATEMENT);
4558: END IF;
4559: -- Bug : 9923803
4560: -- API Call to Insert messages into AAD Loader Log Table.
4561: xla_aad_loader_util_pvt.insert_aadloaderlog(
4562: p_amb_context_code => g_amb_context_code,
4563: p_application_id => g_application_id,
4564: p_request_code => 'IMPORT' ,
4565: p_log_type_code => 'MERGE',
4585: p_level => C_LEVEL_STATEMENT);
4586: END IF;
4587: -- Bug : 9923803
4588: -- API Call to Insert messages into AAD Loader Log Table.
4589: xla_aad_loader_util_pvt.insert_aadloaderlog(
4590: p_amb_context_code => g_amb_context_code,
4591: p_application_id => g_application_id,
4592: p_request_code => 'IMPORT' ,
4593: p_log_type_code => 'MERGE',
4612: p_level => C_LEVEL_STATEMENT);
4613: END IF;
4614: -- Bug : 9923803
4615: -- API Call to Insert messages into AAD Loader Log Table.
4616: xla_aad_loader_util_pvt.insert_aadloaderlog(
4617: p_amb_context_code => g_amb_context_code,
4618: p_application_id => g_application_id,
4619: p_request_code => 'IMPORT' ,
4620: p_log_type_code => 'MERGE',
4641: p_level => C_LEVEL_STATEMENT);
4642: END IF;
4643: -- Bug : 9923803
4644: -- API Call to Insert messages into AAD Loader Log Table.
4645: xla_aad_loader_util_pvt.insert_aadloaderlog(
4646: p_amb_context_code => g_amb_context_code,
4647: p_application_id => g_application_id,
4648: p_request_code => 'IMPORT' ,
4649: p_log_type_code => 'MERGE',
4663: p_level => C_LEVEL_STATEMENT);
4664: END IF;
4665: -- Bug : 9923803
4666: -- API Call to Insert messages into AAD Loader Log Table.
4667: xla_aad_loader_util_pvt.insert_aadloaderlog(
4668: p_amb_context_code => g_amb_context_code,
4669: p_application_id => g_application_id,
4670: p_request_code => 'IMPORT' ,
4671: p_log_type_code => 'MERGE',
4690: p_level => C_LEVEL_STATEMENT);
4691: END IF;
4692: -- Bug : 9923803
4693: -- API Call to Insert messages into AAD Loader Log Table.
4694: xla_aad_loader_util_pvt.insert_aadloaderlog(
4695: p_amb_context_code => g_amb_context_code,
4696: p_application_id => g_application_id,
4697: p_request_code => 'IMPORT' ,
4698: p_log_type_code => 'MERGE',
4719: p_level => C_LEVEL_STATEMENT);
4720: END IF;
4721: -- Bug : 9923803
4722: -- API Call to Insert messages into AAD Loader Log Table.
4723: xla_aad_loader_util_pvt.insert_aadloaderlog(
4724: p_amb_context_code => g_amb_context_code,
4725: p_application_id => g_application_id,
4726: p_request_code => 'IMPORT' ,
4727: p_log_type_code => 'MERGE',
4738: p_level => C_LEVEL_STATEMENT);
4739: END IF;
4740: -- Bug : 9923803
4741: -- API Call to Insert messages into AAD Loader Log Table.
4742: xla_aad_loader_util_pvt.insert_aadloaderlog(
4743: p_amb_context_code => g_amb_context_code,
4744: p_application_id => g_application_id,
4745: p_request_code => 'IMPORT' ,
4746: p_log_type_code => 'MERGE',
4759: p_level => C_LEVEL_STATEMENT);
4760: END IF;
4761: -- Bug : 9923803
4762: -- API Call to Insert messages into AAD Loader Log Table.
4763: xla_aad_loader_util_pvt.insert_aadloaderlog(
4764: p_amb_context_code => g_amb_context_code,
4765: p_application_id => g_application_id,
4766: p_request_code => 'IMPORT' ,
4767: p_log_type_code => 'MERGE',
4778: p_level => C_LEVEL_STATEMENT);
4779: END IF;
4780: -- Bug : 9923803
4781: -- API Call to Insert messages into AAD Loader Log Table.
4782: xla_aad_loader_util_pvt.insert_aadloaderlog(
4783: p_amb_context_code => g_amb_context_code,
4784: p_application_id => g_application_id,
4785: p_request_code => 'IMPORT' ,
4786: p_log_type_code => 'MERGE',
4797: p_level => C_LEVEL_STATEMENT);
4798: END IF;
4799: -- Bug : 9923803
4800: -- API Call to Insert messages into AAD Loader Log Table.
4801: xla_aad_loader_util_pvt.insert_aadloaderlog(
4802: p_amb_context_code => g_amb_context_code,
4803: p_application_id => g_application_id,
4804: p_request_code => 'IMPORT' ,
4805: p_log_type_code => 'MERGE',
4812: END IF;
4813:
4814: EXCEPTION
4815: WHEN OTHERS THEN
4816: xla_aad_loader_util_pvt.stack_error
4817: (p_appli_s_name => 'XLA'
4818: ,p_msg_name => 'XLA_COMMON_ERROR'
4819: ,p_token_1 => 'LOCATION'
4820: ,p_value_1 => 'xla_aad_merge_pvt.merge_descriptions'
4944: END IF;
4945:
4946: -- Bug : 9923803
4947: -- API Call to Insert messages into AAD Loader Log Table.
4948: xla_aad_loader_util_pvt.insert_aadloaderlog(
4949: p_amb_context_code => g_amb_context_code,
4950: p_application_id => g_application_id,
4951: p_request_code => 'IMPORT' ,
4952: p_log_type_code => 'MERGE',
4993: p_level => C_LEVEL_PROCEDURE);
4994: END IF;
4995: -- Bug : 9923803
4996: -- API Call to Insert messages into AAD Loader Log Table.
4997: xla_aad_loader_util_pvt.insert_aadloaderlog(
4998: p_amb_context_code => g_amb_context_code,
4999: p_application_id => g_application_id,
5000: p_request_code => 'IMPORT' ,
5001: p_log_type_code => 'MERGE',
5062: END IF;
5063:
5064: -- Bug : 9923803
5065: -- API Call to Insert messages into AAD Loader Log Table.
5066: xla_aad_loader_util_pvt.insert_aadloaderlog(
5067: p_amb_context_code => g_amb_context_code,
5068: p_application_id => g_application_id,
5069: p_request_code => 'IMPORT' ,
5070: p_log_type_code => 'MERGE',
5116: p_level => C_LEVEL_STATEMENT);
5117: END IF;
5118: -- Bug : 9923803
5119: -- API Call to Insert messages into AAD Loader Log Table.
5120: xla_aad_loader_util_pvt.insert_aadloaderlog(
5121: p_amb_context_code => g_amb_context_code,
5122: p_application_id => g_application_id,
5123: p_request_code => 'IMPORT' ,
5124: p_log_type_code => 'MERGE',
5144: p_level => C_LEVEL_STATEMENT);
5145: END IF;
5146: -- Bug : 9923803
5147: -- API Call to Insert messages into AAD Loader Log Table.
5148: xla_aad_loader_util_pvt.insert_aadloaderlog(
5149: p_amb_context_code => g_amb_context_code,
5150: p_application_id => g_application_id,
5151: p_request_code => 'IMPORT' ,
5152: p_log_type_code => 'MERGE',
5175: END IF;
5176:
5177: -- Bug : 9923803
5178: -- API Call to Insert messages into AAD Loader Log Table.
5179: xla_aad_loader_util_pvt.insert_aadloaderlog(
5180: p_amb_context_code => g_amb_context_code,
5181: p_application_id => g_application_id,
5182: p_request_code => 'IMPORT' ,
5183: p_log_type_code => 'UPLOAD',
5205: p_level => C_LEVEL_STATEMENT);
5206: END IF;
5207: -- Bug : 9923803
5208: -- API Call to Insert messages into AAD Loader Log Table.
5209: xla_aad_loader_util_pvt.insert_aadloaderlog(
5210: p_amb_context_code => g_amb_context_code,
5211: p_application_id => g_application_id,
5212: p_request_code => 'IMPORT' ,
5213: p_log_type_code => 'MERGE',
5242: p_level => C_LEVEL_STATEMENT);
5243: END IF;
5244: -- Bug : 9923803
5245: -- API Call to Insert messages into AAD Loader Log Table.
5246: xla_aad_loader_util_pvt.insert_aadloaderlog(
5247: p_amb_context_code => g_amb_context_code,
5248: p_application_id => g_application_id,
5249: p_request_code => 'IMPORT' ,
5250: p_log_type_code => 'MERGE',
5267: p_level => C_LEVEL_STATEMENT);
5268: END IF;
5269: -- Bug : 9923803
5270: -- API Call to Insert messages into AAD Loader Log Table.
5271: xla_aad_loader_util_pvt.insert_aadloaderlog(
5272: p_amb_context_code => g_amb_context_code,
5273: p_application_id => g_application_id,
5274: p_request_code => 'IMPORT' ,
5275: p_log_type_code => 'MERGE',
5295: p_level => C_LEVEL_STATEMENT);
5296: END IF;
5297: -- Bug : 9923803
5298: -- API Call to Insert messages into AAD Loader Log Table.
5299: xla_aad_loader_util_pvt.insert_aadloaderlog(
5300: p_amb_context_code => g_amb_context_code,
5301: p_application_id => g_application_id,
5302: p_request_code => 'IMPORT' ,
5303: p_log_type_code => 'MERGE',
5324: p_level => C_LEVEL_STATEMENT);
5325: END IF;
5326: -- Bug : 9923803
5327: -- API Call to Insert messages into AAD Loader Log Table.
5328: xla_aad_loader_util_pvt.insert_aadloaderlog(
5329: p_amb_context_code => g_amb_context_code,
5330: p_application_id => g_application_id,
5331: p_request_code => 'IMPORT' ,
5332: p_log_type_code => 'MERGE',
5347: p_level => C_LEVEL_STATEMENT);
5348: END IF;
5349: -- Bug : 9923803
5350: -- API Call to Insert messages into AAD Loader Log Table.
5351: xla_aad_loader_util_pvt.insert_aadloaderlog(
5352: p_amb_context_code => g_amb_context_code,
5353: p_application_id => g_application_id,
5354: p_request_code => 'IMPORT' ,
5355: p_log_type_code => 'MERGE',
5379: END IF;
5380:
5381: -- Bug : 9923803
5382: -- API Call to Insert messages into AAD Loader Log Table.
5383: xla_aad_loader_util_pvt.insert_aadloaderlog(
5384: p_amb_context_code => g_amb_context_code,
5385: p_application_id => g_application_id,
5386: p_request_code => 'IMPORT' ,
5387: p_log_type_code => 'MERGE',
5411: p_level => C_LEVEL_STATEMENT);
5412: END IF;
5413: -- Bug : 9923803
5414: -- API Call to Insert messages into AAD Loader Log Table.
5415: xla_aad_loader_util_pvt.insert_aadloaderlog(
5416: p_amb_context_code => g_amb_context_code,
5417: p_application_id => g_application_id,
5418: p_request_code => 'IMPORT' ,
5419: p_log_type_code => 'MERGE',
5439: p_level => C_LEVEL_STATEMENT);
5440: END IF;
5441: -- Bug : 9923803
5442: -- API Call to Insert messages into AAD Loader Log Table.
5443: xla_aad_loader_util_pvt.insert_aadloaderlog(
5444: p_amb_context_code => g_amb_context_code,
5445: p_application_id => g_application_id,
5446: p_request_code => 'IMPORT' ,
5447: p_log_type_code => 'MERGE',
5471: p_module => l_log_module,
5472: p_level => C_LEVEL_PROCEDURE);
5473: END IF;
5474:
5475: xla_aad_loader_util_pvt.stack_error
5476: (p_appli_s_name => 'XLA'
5477: ,p_msg_name => 'XLA_COMMON_ERROR'
5478: ,p_token_1 => 'LOCATION'
5479: ,p_value_1 => 'xla_aad_merge_pvt.merge_analytical_criteria'
5562: END IF;
5563:
5564: -- Bug : 9923803
5565: -- API Call to Insert messages into AAD Loader Log Table.
5566: xla_aad_loader_util_pvt.insert_aadloaderlog(
5567: p_amb_context_code => g_amb_context_code,
5568: p_application_id => g_application_id,
5569: p_request_code => 'IMPORT' ,
5570: p_log_type_code => 'MERGE',
5606: p_level => C_LEVEL_PROCEDURE);
5607: END IF;
5608: -- Bug : 9923803
5609: -- API Call to Insert messages into AAD Loader Log Table.
5610: xla_aad_loader_util_pvt.insert_aadloaderlog(
5611: p_amb_context_code => g_amb_context_code,
5612: p_application_id => g_application_id,
5613: p_request_code => 'IMPORT' ,
5614: p_log_type_code => 'MERGE',
5644: p_level => C_LEVEL_STATEMENT);
5645: END IF;
5646: -- Bug : 9923803
5647: -- API Call to Insert messages into AAD Loader Log Table.
5648: xla_aad_loader_util_pvt.insert_aadloaderlog(
5649: p_amb_context_code => g_amb_context_code,
5650: p_application_id => g_application_id,
5651: p_request_code => 'IMPORT' ,
5652: p_log_type_code => 'MERGE',
5666: p_level => C_LEVEL_STATEMENT);
5667: END IF;
5668: -- Bug : 9923803
5669: -- API Call to Insert messages into AAD Loader Log Table.
5670: xla_aad_loader_util_pvt.insert_aadloaderlog(
5671: p_amb_context_code => g_amb_context_code,
5672: p_application_id => g_application_id,
5673: p_request_code => 'IMPORT' ,
5674: p_log_type_code => 'MERGE',
5688: p_level => C_LEVEL_STATEMENT);
5689: END IF;
5690: -- Bug : 9923803
5691: -- API Call to Insert messages into AAD Loader Log Table.
5692: xla_aad_loader_util_pvt.insert_aadloaderlog(
5693: p_amb_context_code => g_amb_context_code,
5694: p_application_id => g_application_id,
5695: p_request_code => 'IMPORT' ,
5696: p_log_type_code => 'MERGE',
5710: p_level => C_LEVEL_STATEMENT);
5711: END IF;
5712: -- Bug : 9923803
5713: -- API Call to Insert messages into AAD Loader Log Table.
5714: xla_aad_loader_util_pvt.insert_aadloaderlog(
5715: p_amb_context_code => g_amb_context_code,
5716: p_application_id => g_application_id,
5717: p_request_code => 'IMPORT' ,
5718: p_log_type_code => 'MERGE',
5734: p_level => C_LEVEL_STATEMENT);
5735: END IF;
5736: -- Bug : 9923803
5737: -- API Call to Insert messages into AAD Loader Log Table.
5738: xla_aad_loader_util_pvt.insert_aadloaderlog(
5739: p_amb_context_code => g_amb_context_code,
5740: p_application_id => g_application_id,
5741: p_request_code => 'IMPORT' ,
5742: p_log_type_code => 'MERGE',
5760: p_level => C_LEVEL_STATEMENT);
5761: END IF;
5762: -- Bug : 9923803
5763: -- API Call to Insert messages into AAD Loader Log Table.
5764: xla_aad_loader_util_pvt.insert_aadloaderlog(
5765: p_amb_context_code => g_amb_context_code,
5766: p_application_id => g_application_id,
5767: p_request_code => 'IMPORT' ,
5768: p_log_type_code => 'MERGE',
5787: p_level => C_LEVEL_STATEMENT);
5788: END IF;
5789: -- Bug : 9923803
5790: -- API Call to Insert messages into AAD Loader Log Table.
5791: xla_aad_loader_util_pvt.insert_aadloaderlog(
5792: p_amb_context_code => g_amb_context_code,
5793: p_application_id => g_application_id,
5794: p_request_code => 'IMPORT' ,
5795: p_log_type_code => 'MERGE',
5807: p_level => C_LEVEL_STATEMENT);
5808: END IF;
5809: -- Bug : 9923803
5810: -- API Call to Insert messages into AAD Loader Log Table.
5811: xla_aad_loader_util_pvt.insert_aadloaderlog(
5812: p_amb_context_code => g_amb_context_code,
5813: p_application_id => g_application_id,
5814: p_request_code => 'IMPORT' ,
5815: p_log_type_code => 'MERGE',
5828: p_level => C_LEVEL_STATEMENT);
5829: END IF;
5830: -- Bug : 9923803
5831: -- API Call to Insert messages into AAD Loader Log Table.
5832: xla_aad_loader_util_pvt.insert_aadloaderlog(
5833: p_amb_context_code => g_amb_context_code,
5834: p_application_id => g_application_id,
5835: p_request_code => 'IMPORT' ,
5836: p_log_type_code => 'MERGE',
5844: END IF;
5845:
5846: EXCEPTION
5847: WHEN OTHERS THEN
5848: xla_aad_loader_util_pvt.stack_error
5849: (p_appli_s_name => 'XLA'
5850: ,p_msg_name => 'XLA_COMMON_ERROR'
5851: ,p_token_1 => 'LOCATION'
5852: ,p_value_1 => 'xla_aad_merge_pvt.merge_adrs'
5914: p_level => C_LEVEL_STATEMENT);
5915: END IF;
5916: -- Bug : 9923803
5917: -- API Call to Insert messages into AAD Loader Log Table.
5918: xla_aad_loader_util_pvt.insert_aadloaderlog(
5919: p_amb_context_code => g_amb_context_code,
5920: p_application_id => g_application_id,
5921: p_request_code => 'IMPORT' ,
5922: p_log_type_code => 'MERGE',
5939: p_level => C_LEVEL_STATEMENT);
5940: END IF;
5941: -- Bug : 9923803
5942: -- API Call to Insert messages into AAD Loader Log Table.
5943: xla_aad_loader_util_pvt.insert_aadloaderlog(
5944: p_amb_context_code => g_amb_context_code,
5945: p_application_id => g_application_id,
5946: p_request_code => 'IMPORT' ,
5947: p_log_type_code => 'MERGE',
5959: p_level => C_LEVEL_STATEMENT);
5960: END IF;
5961: -- Bug : 9923803
5962: -- API Call to Insert messages into AAD Loader Log Table.
5963: xla_aad_loader_util_pvt.insert_aadloaderlog(
5964: p_amb_context_code => g_amb_context_code,
5965: p_application_id => g_application_id,
5966: p_request_code => 'IMPORT' ,
5967: p_log_type_code => 'MERGE',
5982: p_level => C_LEVEL_STATEMENT);
5983: END IF;
5984: -- Bug : 9923803
5985: -- API Call to Insert messages into AAD Loader Log Table.
5986: xla_aad_loader_util_pvt.insert_aadloaderlog(
5987: p_amb_context_code => g_amb_context_code,
5988: p_application_id => g_application_id,
5989: p_request_code => 'IMPORT' ,
5990: p_log_type_code => 'MERGE',
6008: p_level => C_LEVEL_STATEMENT);
6009: END IF;
6010: -- Bug : 9923803
6011: -- API Call to Insert messages into AAD Loader Log Table.
6012: xla_aad_loader_util_pvt.insert_aadloaderlog(
6013: p_amb_context_code => g_amb_context_code,
6014: p_application_id => g_application_id,
6015: p_request_code => 'IMPORT' ,
6016: p_log_type_code => 'MERGE',
6035: p_level => C_LEVEL_STATEMENT);
6036: END IF;
6037: -- Bug : 9923803
6038: -- API Call to Insert messages into AAD Loader Log Table.
6039: xla_aad_loader_util_pvt.insert_aadloaderlog(
6040: p_amb_context_code => g_amb_context_code,
6041: p_application_id => g_application_id,
6042: p_request_code => 'IMPORT' ,
6043: p_log_type_code => 'MERGE',
6056: p_level => C_LEVEL_STATEMENT);
6057: END IF;
6058: -- Bug : 9923803
6059: -- API Call to Insert messages into AAD Loader Log Table.
6060: xla_aad_loader_util_pvt.insert_aadloaderlog(
6061: p_amb_context_code => g_amb_context_code,
6062: p_application_id => g_application_id,
6063: p_request_code => 'IMPORT' ,
6064: p_log_type_code => 'MERGE',
6072: END IF;
6073:
6074: EXCEPTION
6075: WHEN OTHERS THEN
6076: xla_aad_loader_util_pvt.stack_error
6077: (p_appli_s_name => 'XLA'
6078: ,p_msg_name => 'XLA_COMMON_ERROR'
6079: ,p_token_1 => 'LOCATION'
6080: ,p_value_1 => 'xla_aad_merge_pvt.merge_mapping_sets'
6156: p_level => C_LEVEL_STATEMENT);
6157: END IF;
6158: -- Bug : 9923803
6159: -- API Call to Insert messages into AAD Loader Log Table.
6160: xla_aad_loader_util_pvt.insert_aadloaderlog(
6161: p_amb_context_code => g_amb_context_code,
6162: p_application_id => g_application_id,
6163: p_request_code => 'IMPORT' ,
6164: p_log_type_code => 'MERGE',
6181: END IF;
6182:
6183: -- Bug : 9923803
6184: -- API Call to Insert messages into AAD Loader Log Table.
6185: xla_aad_loader_util_pvt.insert_aadloaderlog(
6186: p_amb_context_code => g_amb_context_code,
6187: p_application_id => g_application_id,
6188: p_request_code => 'IMPORT' ,
6189: p_log_type_code => 'MERGE',
6225: p_level => C_LEVEL_STATEMENT);
6226: END IF;
6227: -- Bug : 9923803
6228: -- API Call to Insert messages into AAD Loader Log Table.
6229: xla_aad_loader_util_pvt.insert_aadloaderlog(
6230: p_amb_context_code => g_amb_context_code,
6231: p_application_id => g_application_id,
6232: p_request_code => 'IMPORT' ,
6233: p_log_type_code => 'MERGE',
6272: p_level => C_LEVEL_STATEMENT);
6273: END IF;
6274: -- Bug : 9923803
6275: -- API Call to Insert messages into AAD Loader Log Table.
6276: xla_aad_loader_util_pvt.insert_aadloaderlog(
6277: p_amb_context_code => g_amb_context_code,
6278: p_application_id => g_application_id,
6279: p_request_code => 'IMPORT' ,
6280: p_log_type_code => 'MERGE',
6349: p_level => C_LEVEL_STATEMENT);
6350: END IF;
6351: -- Bug : 9923803
6352: -- API Call to Insert messages into AAD Loader Log Table.
6353: xla_aad_loader_util_pvt.insert_aadloaderlog(
6354: p_amb_context_code => g_amb_context_code,
6355: p_application_id => g_application_id,
6356: p_request_code => 'IMPORT' ,
6357: p_log_type_code => 'MERGE',
6364: END IF;
6365:
6366: EXCEPTION
6367: WHEN OTHERS THEN
6368: xla_aad_loader_util_pvt.stack_error
6369: (p_appli_s_name => 'XLA'
6370: ,p_msg_name => 'XLA_COMMON_ERROR'
6371: ,p_token_1 => 'LOCATION'
6372: ,p_value_1 => 'xla_aad_merge_pvt.merge_acctg_methods'
6434: END IF;
6435:
6436: EXCEPTION
6437: WHEN OTHERS THEN
6438: xla_aad_loader_util_pvt.stack_error
6439: (p_appli_s_name => 'XLA'
6440: ,p_msg_name => 'XLA_COMMON_ERROR'
6441: ,p_token_1 => 'LOCATION'
6442: ,p_value_1 => 'xla_aad_merge_pvt.merge_aads_and_setups'
6477: p_level => C_LEVEL_STATEMENT);
6478: END IF;
6479: -- Bug : 9923803
6480: -- API Call to Insert messages into AAD Loader Log Table.
6481: xla_aad_loader_util_pvt.insert_aadloaderlog(
6482: p_amb_context_code => g_amb_context_code,
6483: p_application_id => g_application_id,
6484: p_request_code => 'IMPORT' ,
6485: p_log_type_code => 'MERGE',
6494: p_level => C_LEVEL_STATEMENT);
6495: END IF;
6496: -- Bug : 9923803
6497: -- API Call to Insert messages into AAD Loader Log Table.
6498: xla_aad_loader_util_pvt.insert_aadloaderlog(
6499: p_amb_context_code => g_amb_context_code,
6500: p_application_id => g_application_id,
6501: p_request_code => 'IMPORT' ,
6502: p_log_type_code => 'MERGE',
6511: p_level => C_LEVEL_STATEMENT);
6512: END IF;
6513: -- Bug : 9923803
6514: -- API Call to Insert messages into AAD Loader Log Table.
6515: xla_aad_loader_util_pvt.insert_aadloaderlog(
6516: p_amb_context_code => g_amb_context_code,
6517: p_application_id => g_application_id,
6518: p_request_code => 'IMPORT' ,
6519: p_log_type_code => 'MERGE',
6526: END IF;
6527:
6528: EXCEPTION
6529: WHEN OTHERS THEN
6530: xla_aad_loader_util_pvt.stack_error
6531: (p_appli_s_name => 'XLA'
6532: ,p_msg_name => 'XLA_COMMON_ERROR'
6533: ,p_token_1 => 'LOCATION'
6534: ,p_value_1 => 'xla_aad_merge_pvt.purge_mapping_sets'
6569: p_level => C_LEVEL_STATEMENT);
6570: END IF;
6571: -- Bug : 9923803
6572: -- API Call to Insert messages into AAD Loader Log Table.
6573: xla_aad_loader_util_pvt.insert_aadloaderlog(
6574: p_amb_context_code => g_amb_context_code,
6575: p_application_id => g_application_id,
6576: p_request_code => 'IMPORT' ,
6577: p_log_type_code => 'MERGE',
6586: p_level => C_LEVEL_STATEMENT);
6587: END IF;
6588: -- Bug : 9923803
6589: -- API Call to Insert messages into AAD Loader Log Table.
6590: xla_aad_loader_util_pvt.insert_aadloaderlog(
6591: p_amb_context_code => g_amb_context_code,
6592: p_application_id => g_application_id,
6593: p_request_code => 'IMPORT' ,
6594: p_log_type_code => 'MERGE',
6603: p_level => C_LEVEL_STATEMENT);
6604: END IF;
6605: -- Bug : 9923803
6606: -- API Call to Insert messages into AAD Loader Log Table.
6607: xla_aad_loader_util_pvt.insert_aadloaderlog(
6608: p_amb_context_code => g_amb_context_code,
6609: p_application_id => g_application_id,
6610: p_request_code => 'IMPORT' ,
6611: p_log_type_code => 'MERGE',
6620: p_level => C_LEVEL_STATEMENT);
6621: END IF;
6622: -- Bug : 9923803
6623: -- API Call to Insert messages into AAD Loader Log Table.
6624: xla_aad_loader_util_pvt.insert_aadloaderlog(
6625: p_amb_context_code => g_amb_context_code,
6626: p_application_id => g_application_id,
6627: p_request_code => 'IMPORT' ,
6628: p_log_type_code => 'MERGE',
6637: p_level => C_LEVEL_STATEMENT);
6638: END IF;
6639: -- Bug : 9923803
6640: -- API Call to Insert messages into AAD Loader Log Table.
6641: xla_aad_loader_util_pvt.insert_aadloaderlog(
6642: p_amb_context_code => g_amb_context_code,
6643: p_application_id => g_application_id,
6644: p_request_code => 'IMPORT' ,
6645: p_log_type_code => 'MERGE',
6652: END IF;
6653:
6654: EXCEPTION
6655: WHEN OTHERS THEN
6656: xla_aad_loader_util_pvt.stack_error
6657: (p_appli_s_name => 'XLA'
6658: ,p_msg_name => 'XLA_COMMON_ERROR'
6659: ,p_token_1 => 'LOCATION'
6660: ,p_value_1 => 'xla_aad_merge_pvt.purge_analytical_criteria'
6696: p_level => C_LEVEL_STATEMENT);
6697: END IF;
6698: -- Bug : 9923803
6699: -- API Call to Insert messages into AAD Loader Log Table.
6700: xla_aad_loader_util_pvt.insert_aadloaderlog(
6701: p_amb_context_code => g_amb_context_code,
6702: p_application_id => g_application_id,
6703: p_request_code => 'IMPORT' ,
6704: p_log_type_code => 'MERGE',
6713: p_level => C_LEVEL_STATEMENT);
6714: END IF;
6715: -- Bug : 9923803
6716: -- API Call to Insert messages into AAD Loader Log Table.
6717: xla_aad_loader_util_pvt.insert_aadloaderlog(
6718: p_amb_context_code => g_amb_context_code,
6719: p_application_id => g_application_id,
6720: p_request_code => 'IMPORT' ,
6721: p_log_type_code => 'MERGE',
6731: p_level => C_LEVEL_STATEMENT);
6732: END IF;
6733: -- Bug : 9923803
6734: -- API Call to Insert messages into AAD Loader Log Table.
6735: xla_aad_loader_util_pvt.insert_aadloaderlog(
6736: p_amb_context_code => g_amb_context_code,
6737: p_application_id => g_application_id,
6738: p_request_code => 'IMPORT' ,
6739: p_log_type_code => 'MERGE',
6749: p_level => C_LEVEL_STATEMENT);
6750: END IF;
6751: -- Bug : 9923803
6752: -- API Call to Insert messages into AAD Loader Log Table.
6753: xla_aad_loader_util_pvt.insert_aadloaderlog(
6754: p_amb_context_code => g_amb_context_code,
6755: p_application_id => g_application_id,
6756: p_request_code => 'IMPORT' ,
6757: p_log_type_code => 'MERGE',
6765: END IF;
6766:
6767: EXCEPTION
6768: WHEN OTHERS THEN
6769: xla_aad_loader_util_pvt.stack_error
6770: (p_appli_s_name => 'XLA'
6771: ,p_msg_name => 'XLA_COMMON_ERROR'
6772: ,p_token_1 => 'LOCATION'
6773: ,p_value_1 => 'xla_aad_merge_pvt.purge_adrs'
6797: p_module => l_log_module,
6798: p_level => C_LEVEL_PROCEDURE);
6799: END IF;
6800:
6801: xla_aad_loader_util_pvt.purge
6802: (p_application_id => g_application_id
6803: ,p_amb_context_code => g_staging_context_code);
6804:
6805: purge_mapping_sets;
6813: END IF;
6814:
6815: EXCEPTION
6816: WHEN OTHERS THEN
6817: xla_aad_loader_util_pvt.stack_error
6818: (p_appli_s_name => 'XLA'
6819: ,p_msg_name => 'XLA_COMMON_ERROR'
6820: ,p_token_1 => 'LOCATION'
6821: ,p_value_1 => 'xla_aad_merge_pvt.purge_staging_area'
6853: END IF;
6854:
6855: EXCEPTION
6856: WHEN OTHERS THEN
6857: xla_aad_loader_util_pvt.stack_error
6858: (p_appli_s_name => 'XLA'
6859: ,p_msg_name => 'XLA_COMMON_ERROR'
6860: ,p_token_1 => 'LOCATION'
6861: ,p_value_1 => 'xla_aad_merge_pvt.template_api'
6910: p_module => l_log_module,
6911: p_level => C_LEVEL_PROCEDURE);
6912: END IF;
6913:
6914: l_staging_context_code := xla_aad_loader_util_pvt.get_staging_context_code
6915: (p_application_id => p_application_id
6916: ,p_amb_context_code => p_amb_context_code);
6917:
6918: xla_aad_merge_pvt.merge
6949: ROLLBACK;
6950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6951: x_merge_status := 'ERROR';
6952:
6953: xla_aad_loader_util_pvt.stack_error
6954: (p_appli_s_name => 'XLA'
6955: ,p_msg_name => 'XLA_COMMON_ERROR'
6956: ,p_token_1 => 'LOCATION'
6957: ,p_value_1 => 'xla_aad_merge_pvt.merge'
7001: p_level => C_LEVEL_PROCEDURE);
7002: END IF;
7003:
7004: -- Standard call to check for call compatibility.
7005: IF (NOT xla_aad_loader_util_pvt.compatible_api_call
7006: (p_current_version_number => l_api_version
7007: ,p_caller_version_number => p_api_version
7008: ,p_api_name => l_api_name
7009: ,p_pkg_name => C_DEFAULT_MODULE))
7036:
7037: merge_aads_and_setups;
7038:
7039:
7040: xla_aad_loader_util_pvt.merge_history
7041: (p_application_id => g_application_id
7042: ,p_staging_context_code => g_staging_context_code);
7043:
7044:
7043:
7044:
7045: purge_staging_area;
7046:
7047: xla_aad_loader_util_pvt.rebuild_ac_views;
7048:
7049: IF (p_compile_flag = 'Y') THEN
7050: IF (NOT xla_aad_loader_util_pvt.compile
7051: (p_application_id => g_application_id
7046:
7047: xla_aad_loader_util_pvt.rebuild_ac_views;
7048:
7049: IF (p_compile_flag = 'Y') THEN
7050: IF (NOT xla_aad_loader_util_pvt.compile
7051: (p_application_id => g_application_id
7052: ,p_amb_context_code => g_amb_context_code)) THEN
7053: RAISE G_EXC_WARNING;
7054: END IF;
7079: ROLLBACK;
7080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7081: x_merge_status := 'ERROR';
7082:
7083: xla_aad_loader_util_pvt.stack_error
7084: (p_appli_s_name => 'XLA'
7085: ,p_msg_name => 'XLA_COMMON_ERROR'
7086: ,p_token_1 => 'LOCATION'
7087: ,p_value_1 => 'xla_aad_merge_pvt.merge'