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.IEX_MERGE_PVT dependencies on IEX_DEBUG_PUB

Line 87: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.SCORE_HISTORY_MERGE BEGIN');

83: l_count NUMBER;
84: BEGIN
85:
86: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
87: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.SCORE_HISTORY_MERGE BEGIN');
88: END IF;
89:
90: IF process_mode='LOCK' THEN
91: NULL;

Line 100: IEX_DEBUG_PUB.logMessage('IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE=IEX_ACCOUNT');

96: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
97:
98: /* process IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE='IEX_ACCOUNT' */
99: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
100: IEX_DEBUG_PUB.logMessage('IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE=IEX_ACCOUNT');
101: END IF;
102: open merged_records1;
103: LOOP
104: FETCH merged_records1 BULK COLLECT INTO

Line 156: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

152: hz_utility_pub.LAST_UPDATED_BY);
153: END IF;
154:
155: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
156: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');
157: END IF;
158: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
159: UPDATE IEX_SCORE_HISTORIES yt SET
160: SCORE_OBJECT_ID = NUM_COL1_NEW_LIST(I)

Line 184: IEX_DEBUG_PUB.logMessage('IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE=IEX_ACCOUNT_SITE');

180: MERGE_HEADER_ID_LIST.delete;
181: PRIMARY_KEY_ID_LIST.delete;
182: l_count := 0;
183: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
184: IEX_DEBUG_PUB.logMessage('IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE=IEX_ACCOUNT_SITE');
185: END IF;
186: open merged_records2;
187: LOOP
188: FETCH merged_records2 BULK COLLECT INTO

Line 241: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

237: hz_utility_pub.LAST_UPDATED_BY);
238: END IF;
239:
240: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
241: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');
242: END IF;
243: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
244: UPDATE IEX_SCORE_HISTORIES yt SET
245: SCORE_OBJECT_ID = NUM_COL2_NEW_LIST(I)

Line 266: IEX_DEBUG_PUB.logMessage('IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE=IEX_BILLTO');

262: MERGE_HEADER_ID_LIST.delete;
263: PRIMARY_KEY_ID_LIST.delete;
264: l_count := 0;
265: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
266: IEX_DEBUG_PUB.logMessage('IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE=IEX_BILLTO');
267: END IF;
268: open merged_records3;
269: LOOP
270: FETCH merged_records1 BULK COLLECT INTO

Line 322: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

318: hz_utility_pub.LAST_UPDATED_BY);
319: END IF;
320:
321: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
322: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');
323: END IF;
324: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
325: UPDATE IEX_SCORE_HISTORIES yt SET
326: SCORE_OBJECT_ID = NUM_COL3_NEW_LIST(I)

Line 418: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE BEGIN');

414: IF process_mode='LOCK' THEN
415: NULL;
416: ELSE
417: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
418: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE BEGIN');
419: END IF;
420:
421: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
422: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_DUNNING',FALSE);

Line 428: IEX_DEBUG_PUB.logMessage('IEX_DUNNING.DUNNING_OBJECT_ID');

424: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
425:
426: /* process IEX_STRATEGIES.CUST_ACCOUNT_ID */
427: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
428: IEX_DEBUG_PUB.logMessage('IEX_DUNNING.DUNNING_OBJECT_ID');
429: END IF;
430: open merged_records1;
431: LOOP
432: FETCH merged_records1 BULK COLLECT INTO

Line 487: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

483: hz_utility_pub.LAST_UPDATED_BY);
484: END IF;
485:
486: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
487: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');
488: END IF;
489: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
490: UPDATE IEX_DUNNINGS yt SET
491: DUNNING_OBJECT_ID = NUM_COL1_NEW_LIST(I)

Line 515: IEX_DEBUG_PUB.logMessage('IEX_DUNNINGS.DUNNING_OBJECT_ID.TYPE=ACCOUNT');

511: MERGE_HEADER_ID_LIST.delete;
512: PRIMARY_KEY_ID_LIST.delete;
513: l_count := 0;
514: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
515: IEX_DEBUG_PUB.logMessage('IEX_DUNNINGS.DUNNING_OBJECT_ID.TYPE=ACCOUNT');
516: END IF;
517: open merged_records2;
518: LOOP
519: FETCH merged_records2 BULK COLLECT INTO

Line 574: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

570: hz_utility_pub.LAST_UPDATED_BY);
571: END IF;
572:
573: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
574: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');
575: END IF;
576: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
577: UPDATE IEX_DUNNINGS yt SET
578: DUNNING_OBJECT_ID = NUM_COL2_NEW_LIST(I)

Line 596: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNNING_MERGE END');

592:
593: arp_message.set_name('AR','AR_ROWS_UPDATED');
594: arp_message.set_token('NUM_ROWS',to_char(l_count));
595: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
596: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNNING_MERGE END');
597: END IF;
598:
599: END IF;
600: EXCEPTION

Line 710: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.STRATEGY_MERGE BEGIN');

706: IF process_mode='LOCK' THEN
707: NULL;
708: ELSE
709: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
710: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.STRATEGY_MERGE BEGIN');
711: END IF;
712:
713: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
714: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_STRATEGIES',FALSE);

Line 720: IEX_DEBUG_PUB.logMessage('IEX_STRATEGIES.CUST_ACCOUNT_ID');

716: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
717:
718: /* process IEX_STRATEGIES.CUST_ACCOUNT_ID */
719: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
720: IEX_DEBUG_PUB.logMessage('IEX_STRATEGIES.CUST_ACCOUNT_ID');
721: END IF;
722: open merged_records1;
723: LOOP
724: FETCH merged_records1 BULK COLLECT INTO

Line 777: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

773: hz_utility_pub.LAST_UPDATED_BY);
774: END IF;
775:
776: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
777: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');
778: END IF;
779: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
780: UPDATE IEX_STRATEGIES yt SET
781: CUST_ACCOUNT_ID = NUM_COL1_NEW_LIST(I)

Line 808: IEX_DEBUG_PUB.logMessage('IEX_STRATEGIES.JTF_OBJECT_ID.TYPE=IEX_ACCOUNT');

804: PARTY_ID_LIST.delete;
805: STATUS_CODE_LIST.delete; --Added for bug#6974531 by schekuri on 14-Aug-2008
806: l_count := 0;
807: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
808: IEX_DEBUG_PUB.logMessage('IEX_STRATEGIES.JTF_OBJECT_ID.TYPE=IEX_ACCOUNT');
809: END IF;
810: open merged_records2;
811: LOOP
812: FETCH merged_records2 BULK COLLECT INTO

Line 867: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

863: hz_utility_pub.LAST_UPDATED_BY);
864: END IF;
865:
866: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
867: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');
868: END IF;
869: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
870: UPDATE IEX_STRATEGIES yt SET
871: JTF_OBJECT_ID = NUM_COL2_NEW_LIST(I)

Line 904: IEX_DEBUG_PUB.logMessage('IEX_STRATEGIES.JTF_OBJECT_ID.TYPE=IEX_BILLTO');

900: PRIMARY_KEY_ID_LIST.delete;
901: STATUS_CODE_LIST.delete; --Added for bug#6974531 by schekuri on 14-Aug-2008
902: l_count := 0;
903: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
904: IEX_DEBUG_PUB.logMessage('IEX_STRATEGIES.JTF_OBJECT_ID.TYPE=IEX_BILLTO');
905: END IF;
906: open merged_records3;
907: LOOP
908: FETCH merged_records3 BULK COLLECT INTO

Line 963: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

959: hz_utility_pub.LAST_UPDATED_BY);
960: END IF;
961:
962: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
963: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');
964: END IF;
965: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
966: UPDATE IEX_STRATEGIES yt SET
967: -- CUST_ACCOUNT_ID = NUM_COL3_NEW_LIST(I) Updated for bug#6974531 by schekuri on 14-Aug-2008

Line 998: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.STRATEGY_MERGE END');

994: arp_message.set_name('AR','AR_ROWS_UPDATED');
995: arp_message.set_token('NUM_ROWS',to_char(l_count));
996:
997: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
998: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.STRATEGY_MERGE END');
999: END IF;
1000:
1001: END IF;
1002: EXCEPTION

Line 1209: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DELINQUENCY_MERGE BEGIN');

1205: l_count NUMBER;
1206: BEGIN
1207:
1208: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1209: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DELINQUENCY_MERGE BEGIN');
1210: IEX_DEBUG_PUB.logMessage('Input parameters:');
1211: IEX_DEBUG_PUB.logMessage('req_id = ' || req_id);
1212: IEX_DEBUG_PUB.logMessage('set_num = ' || set_num);
1213: IEX_DEBUG_PUB.logMessage('process_mode = ' || process_mode);

Line 1210: IEX_DEBUG_PUB.logMessage('Input parameters:');

1206: BEGIN
1207:
1208: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1209: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DELINQUENCY_MERGE BEGIN');
1210: IEX_DEBUG_PUB.logMessage('Input parameters:');
1211: IEX_DEBUG_PUB.logMessage('req_id = ' || req_id);
1212: IEX_DEBUG_PUB.logMessage('set_num = ' || set_num);
1213: IEX_DEBUG_PUB.logMessage('process_mode = ' || process_mode);
1214: END IF;

Line 1211: IEX_DEBUG_PUB.logMessage('req_id = ' || req_id);

1207:
1208: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1209: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DELINQUENCY_MERGE BEGIN');
1210: IEX_DEBUG_PUB.logMessage('Input parameters:');
1211: IEX_DEBUG_PUB.logMessage('req_id = ' || req_id);
1212: IEX_DEBUG_PUB.logMessage('set_num = ' || set_num);
1213: IEX_DEBUG_PUB.logMessage('process_mode = ' || process_mode);
1214: END IF;
1215:

Line 1212: IEX_DEBUG_PUB.logMessage('set_num = ' || set_num);

1208: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1209: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DELINQUENCY_MERGE BEGIN');
1210: IEX_DEBUG_PUB.logMessage('Input parameters:');
1211: IEX_DEBUG_PUB.logMessage('req_id = ' || req_id);
1212: IEX_DEBUG_PUB.logMessage('set_num = ' || set_num);
1213: IEX_DEBUG_PUB.logMessage('process_mode = ' || process_mode);
1214: END IF;
1215:
1216: IF process_mode='LOCK' THEN

Line 1213: IEX_DEBUG_PUB.logMessage('process_mode = ' || process_mode);

1209: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DELINQUENCY_MERGE BEGIN');
1210: IEX_DEBUG_PUB.logMessage('Input parameters:');
1211: IEX_DEBUG_PUB.logMessage('req_id = ' || req_id);
1212: IEX_DEBUG_PUB.logMessage('set_num = ' || set_num);
1213: IEX_DEBUG_PUB.logMessage('process_mode = ' || process_mode);
1214: END IF;
1215:
1216: IF process_mode='LOCK' THEN
1217: NULL;

Line 1225: IEX_DEBUG_PUB.logMessage('l_profile_val = ' || l_profile_val);

1221: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1222: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1223:
1224: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1225: IEX_DEBUG_PUB.logMessage('l_profile_val = ' || l_profile_val);
1226: END IF;
1227:
1228: l_count := 0;
1229: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1230: IEX_DEBUG_PUB.logMessage('Searching for ACCOUNT records...');

1226: END IF;
1227:
1228: l_count := 0;
1229: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1230: IEX_DEBUG_PUB.logMessage('Searching for ACCOUNT records...');
1231: END IF;
1232:
1233: /* merging cust_account_id */
1234: open merged_records;

Line 1248: IEX_DEBUG_PUB.logMessage('Fetched ' || MERGE_HEADER_ID_LIST.COUNT || ' records');

1244: l_last_fetch := TRUE;
1245: END IF;
1246:
1247: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1248: IEX_DEBUG_PUB.logMessage('Fetched ' || MERGE_HEADER_ID_LIST.COUNT || ' records');
1249: END IF;
1250:
1251: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
1252: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1253: IEX_DEBUG_PUB.logMessage('Exiting fetch');

1249: END IF;
1250:
1251: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
1252: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1253: IEX_DEBUG_PUB.logMessage('Exiting fetch');
1254: END IF;
1255: goto iex_delinquency_acc_site_use;
1256: END IF;
1257:

Line 1264: IEX_DEBUG_PUB.logMessage('Inserting into HZ_CUSTOMER_MERGE_LOG...');

1260: END LOOP;
1261:
1262: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1263: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1264: IEX_DEBUG_PUB.logMessage('Inserting into HZ_CUSTOMER_MERGE_LOG...');
1265: END IF;
1266: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1267: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1268: MERGE_LOG_ID,

Line 1297: IEX_DEBUG_PUB.logMessage('...done');

1293: hz_utility_pub.LAST_UPDATE_DATE,
1294: hz_utility_pub.LAST_UPDATED_BY);
1295:
1296: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1297: IEX_DEBUG_PUB.logMessage('...done');
1298: END IF;
1299:
1300: END IF;
1301: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1302: IEX_DEBUG_PUB.logMessage('Updating IEX_DELINQUENCIES_ALL...');

1298: END IF;
1299:
1300: END IF;
1301: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1302: IEX_DEBUG_PUB.logMessage('Updating IEX_DELINQUENCIES_ALL...');
1303: END IF;
1304:
1305: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1306: UPDATE IEX_DELINQUENCIES_ALL yt SET

Line 1319: IEX_DEBUG_PUB.logMessage('...done');

1315: , PROGRAM_UPDATE_DATE = SYSDATE
1316: WHERE DELINQUENCY_ID=PRIMARY_KEY_ID_LIST(I);
1317: l_count := l_count + SQL%ROWCOUNT;
1318: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1319: IEX_DEBUG_PUB.logMessage('...done');
1320: END IF;
1321:
1322: IF l_last_fetch THEN
1323: goto iex_delinquency_acc_site_use;

Line 1328: IEX_DEBUG_PUB.logMessage('Total processed ' || l_count || ' ACCOUNT records');

1324: END IF;
1325: END LOOP;
1326:
1327: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1328: IEX_DEBUG_PUB.logMessage('Total processed ' || l_count || ' ACCOUNT records');
1329: END IF;
1330:
1331: arp_message.set_name('AR','AR_ROWS_UPDATED');
1332: arp_message.set_token('NUM_ROWS',to_char(l_count));

Line 1342: IEX_DEBUG_PUB.logMessage('Searching for CUSTOMER_SITE_USE_ID records...');

1338: PRIMARY_KEY_ID_LIST.delete;
1339: l_count := 0;
1340:
1341: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1342: IEX_DEBUG_PUB.logMessage('Searching for CUSTOMER_SITE_USE_ID records...');
1343: END IF;
1344:
1345: open merged_records1;
1346: LOOP

Line 1354: IEX_DEBUG_PUB.logMessage('Fetched ' || MERGE_HEADER_ID_LIST.COUNT || ' records');

1350: , NUM_COL2_ORIG_LIST
1351: limit G_Batch_Size;
1352:
1353: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1354: IEX_DEBUG_PUB.logMessage('Fetched ' || MERGE_HEADER_ID_LIST.COUNT || ' records');
1355: END IF;
1356:
1357: IF merged_records1%NOTFOUND THEN
1358: l_last_fetch := TRUE;

Line 1363: IEX_DEBUG_PUB.logMessage('Exiting fetch');

1359: END IF;
1360:
1361: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
1362: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1363: IEX_DEBUG_PUB.logMessage('Exiting fetch');
1364: END IF;
1365: exit;
1366: END IF;
1367:

Line 1376: IEX_DEBUG_PUB.logMessage('Inserting into HZ_CUSTOMER_MERGE_LOG...');

1372:
1373: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1374:
1375: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1376: IEX_DEBUG_PUB.logMessage('Inserting into HZ_CUSTOMER_MERGE_LOG...');
1377: END IF;
1378:
1379: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1380: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1410: IEX_DEBUG_PUB.logMessage('...done');

1406: hz_utility_pub.LAST_UPDATE_DATE,
1407: hz_utility_pub.LAST_UPDATED_BY);
1408:
1409: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1410: IEX_DEBUG_PUB.logMessage('...done');
1411: END IF;
1412:
1413: END IF;
1414:

Line 1416: IEX_DEBUG_PUB.logMessage('Updating IEX_DELINQUENCIES_ALL...');

1412:
1413: END IF;
1414:
1415: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1416: IEX_DEBUG_PUB.logMessage('Updating IEX_DELINQUENCIES_ALL...');
1417: END IF;
1418:
1419: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1420: UPDATE IEX_DELINQUENCIES_ALL yt SET

Line 1432: IEX_DEBUG_PUB.logMessage('...done');

1428: , PROGRAM_UPDATE_DATE = SYSDATE
1429: WHERE DELINQUENCY_ID=PRIMARY_KEY_ID_LIST(I);
1430: l_count := l_count + SQL%ROWCOUNT;
1431: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1432: IEX_DEBUG_PUB.logMessage('...done');
1433: END IF;
1434: IF l_last_fetch THEN
1435: EXIT;
1436: END IF;

Line 1440: IEX_DEBUG_PUB.logMessage('Total processed ' || l_count || ' CUSTOMER_SITE_USE_ID records');

1436: END IF;
1437: END LOOP;
1438:
1439: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1440: IEX_DEBUG_PUB.logMessage('Total processed ' || l_count || ' CUSTOMER_SITE_USE_ID records');
1441: END IF;
1442:
1443: arp_message.set_name('AR','AR_ROWS_UPDATED');
1444: arp_message.set_token('NUM_ROWS',to_char(l_count));

Line 1447: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DELINQUENCY_MERGE END');

1443: arp_message.set_name('AR','AR_ROWS_UPDATED');
1444: arp_message.set_token('NUM_ROWS',to_char(l_count));
1445:
1446: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1447: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DELINQUENCY_MERGE END');
1448: END IF;
1449:
1450: END IF;
1451: EXCEPTION

Line 1454: IEX_DEBUG_PUB.logMessage('In IEX_MERGE_PVT.DELINQUENCY_MERGE exception');

1450: END IF;
1451: EXCEPTION
1452: WHEN OTHERS THEN
1453: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1454: IEX_DEBUG_PUB.logMessage('In IEX_MERGE_PVT.DELINQUENCY_MERGE exception');
1455: END IF;
1456: arp_message.set_line('DELINQUENCY_MERGE');
1457: RAISE;
1458: END DELINQUENCY_MERGE;

Line 1481: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: Begin');

1477: -- End - 10/12/2005 - Andre Araujo - Add exception handling
1478:
1479: BEGIN
1480: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1481: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: Begin');
1482: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );
1483: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );
1484: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_fk_id: ' || p_from_fk_id );
1485: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_fk_id: ' || p_to_fk_id );

Line 1482: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );

1478:
1479: BEGIN
1480: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1481: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: Begin');
1482: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );
1483: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );
1484: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_fk_id: ' || p_from_fk_id );
1485: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_fk_id: ' || p_to_fk_id );
1486: END IF;

Line 1483: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );

1479: BEGIN
1480: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1481: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: Begin');
1482: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );
1483: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );
1484: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_fk_id: ' || p_from_fk_id );
1485: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_fk_id: ' || p_to_fk_id );
1486: END IF;
1487:

Line 1484: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_fk_id: ' || p_from_fk_id );

1480: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1481: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: Begin');
1482: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );
1483: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );
1484: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_fk_id: ' || p_from_fk_id );
1485: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_fk_id: ' || p_to_fk_id );
1486: END IF;
1487:
1488: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1485: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_fk_id: ' || p_to_fk_id );

1481: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: Begin');
1482: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );
1483: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );
1484: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_fk_id: ' || p_from_fk_id );
1485: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_fk_id: ' || p_to_fk_id );
1486: END IF;
1487:
1488: x_return_status := FND_API.G_RET_STS_SUCCESS;
1489:

Line 1712: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: End success!');

1708:
1709: /* end raverma 02032003 */
1710:
1711: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1712: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: End success!');
1713: END IF;
1714:
1715: RETURN;
1716:

Line 1779: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: Null party_ids received!!!');

1775: FND_MESSAGE.SET_TOKEN('NULL_PARAM', null);
1776: FND_MSG_PUB.ADD;
1777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1778:
1779: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: Null party_ids received!!!');
1780: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );
1781: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );
1782: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_fk_id: ' || p_from_fk_id );
1783: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_fk_id: ' || p_to_fk_id );

Line 1780: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );

1776: FND_MSG_PUB.ADD;
1777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1778:
1779: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: Null party_ids received!!!');
1780: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );
1781: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );
1782: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_fk_id: ' || p_from_fk_id );
1783: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_fk_id: ' || p_to_fk_id );
1784:

Line 1781: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );

1777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1778:
1779: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: Null party_ids received!!!');
1780: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );
1781: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );
1782: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_fk_id: ' || p_from_fk_id );
1783: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_fk_id: ' || p_to_fk_id );
1784:
1785: FND_FILE.PUT_LINE(FND_FILE.LOG,'MERGE_DELINQUENCY_PARTIES: Null party_ids received!!!');

Line 1782: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_fk_id: ' || p_from_fk_id );

1778:
1779: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: Null party_ids received!!!');
1780: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );
1781: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );
1782: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_fk_id: ' || p_from_fk_id );
1783: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_fk_id: ' || p_to_fk_id );
1784:
1785: FND_FILE.PUT_LINE(FND_FILE.LOG,'MERGE_DELINQUENCY_PARTIES: Null party_ids received!!!');
1786: FND_FILE.PUT_LINE(FND_FILE.LOG,'MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );

Line 1783: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_fk_id: ' || p_to_fk_id );

1779: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: Null party_ids received!!!');
1780: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );
1781: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );
1782: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_fk_id: ' || p_from_fk_id );
1783: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_fk_id: ' || p_to_fk_id );
1784:
1785: FND_FILE.PUT_LINE(FND_FILE.LOG,'MERGE_DELINQUENCY_PARTIES: Null party_ids received!!!');
1786: FND_FILE.PUT_LINE(FND_FILE.LOG,'MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );
1787: FND_FILE.PUT_LINE(FND_FILE.LOG,'MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );

Line 1799: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: EXCEPTION!!!');

1795: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1796: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1797: FND_MSG_PUB.ADD;
1798:
1799: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: EXCEPTION!!!');
1800: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: ' || SQLERRM);
1801:
1802: FND_FILE.PUT_LINE(FND_FILE.LOG,'MERGE_DELINQUENCY_PARTIES: EXCEPTION!!!');
1803: FND_FILE.PUT_LINE(FND_FILE.LOG,'MERGE_DELINQUENCY_PARTIES: ' || SQLERRM);

Line 1800: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: ' || SQLERRM);

1796: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1797: FND_MSG_PUB.ADD;
1798:
1799: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: EXCEPTION!!!');
1800: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: ' || SQLERRM);
1801:
1802: FND_FILE.PUT_LINE(FND_FILE.LOG,'MERGE_DELINQUENCY_PARTIES: EXCEPTION!!!');
1803: FND_FILE.PUT_LINE(FND_FILE.LOG,'MERGE_DELINQUENCY_PARTIES: ' || SQLERRM);
1804:

Line 1827: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.CASE_CONTACT_MERGE BEGIN');

1823: l_api_version_number CONSTANT NUMBER := 1.0;
1824: l_merge_reason_code VARCHAR2(30);
1825: BEGIN
1826: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1827: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.CASE_CONTACT_MERGE BEGIN');
1828: END IF;
1829: x_return_status := FND_API.G_RET_STS_SUCCESS;
1830:
1831: select merge_reason_code into l_merge_reason_code

Line 1911: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.CASE_CONTACT_MERGE EXCEPTION:');

1907: END IF;
1908: EXCEPTION
1909: WHEN OTHERS THEN
1910: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1911: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.CASE_CONTACT_MERGE EXCEPTION:');
1912: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT' || '.' || l_api_name || ': ' || sqlerrm);
1913: END IF;
1914: arp_message.set_line('IEX_MERGE_PVT' || '.' || l_api_name || ': ' || sqlerrm);
1915: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1912: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT' || '.' || l_api_name || ': ' || sqlerrm);

1908: EXCEPTION
1909: WHEN OTHERS THEN
1910: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1911: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.CASE_CONTACT_MERGE EXCEPTION:');
1912: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT' || '.' || l_api_name || ': ' || sqlerrm);
1913: END IF;
1914: arp_message.set_line('IEX_MERGE_PVT' || '.' || l_api_name || ': ' || sqlerrm);
1915: x_return_status := FND_API.G_RET_STS_ERROR;
1916: raise;

Line 1921: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.CASE_CONTACT_MERGE END');

1917: END;
1918: END IF;
1919:
1920: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1921: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.CASE_CONTACT_MERGE END');
1922: END IF;
1923:
1924: END CASE_CONTACT_MERGE;
1925: