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 89: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.SCORE_HISTORY_MERGE BEGIN');

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

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

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

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

154: hz_utility_pub.LAST_UPDATED_BY);
155: END IF;
156:
157: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
158: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');
159: END IF;
160: --FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
161: -- Changed for all loop to for loop to fix 14492050 Snuthala
162: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT loop

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

191: MERGE_HEADER_ID_LIST.delete;
192: PRIMARY_KEY_ID_LIST.delete;
193: l_count := 0;
194: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
195: IEX_DEBUG_PUB.logMessage('IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE=IEX_ACCOUNT_SITE');
196: END IF;
197: open merged_records2;
198: LOOP
199: FETCH merged_records2 BULK COLLECT INTO

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

248: hz_utility_pub.LAST_UPDATED_BY);
249: END IF;
250:
251: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
252: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');
253: END IF;
254: --FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
255: -- Changed for all loop to for loop to fix 14492050 Snuthala
256: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT loop

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

281: MERGE_HEADER_ID_LIST.delete;
282: PRIMARY_KEY_ID_LIST.delete;
283: l_count := 0;
284: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
285: IEX_DEBUG_PUB.logMessage('IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE=IEX_BILLTO');
286: END IF;
287: open merged_records3;
288: LOOP
289: FETCH merged_records1 BULK COLLECT INTO

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

337: hz_utility_pub.LAST_UPDATED_BY);
338: END IF;
339:
340: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
341: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');
342: END IF;
343: --FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
344: -- Changed for all loop to for loop to fix 14492050 Snuthala
345: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT loop

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

442: BEGIN
443: IF process_mode='LOCK' THEN
444: NULL;
445: ELSE
446: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE BEGIN');
447: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
448: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE BEGIN');
449: IEX_DEBUG_PUB.logMessage('Input parameters:');
450: IEX_DEBUG_PUB.logMessage('req_id = ' || req_id);

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

444: NULL;
445: ELSE
446: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE BEGIN');
447: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
448: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE BEGIN');
449: IEX_DEBUG_PUB.logMessage('Input parameters:');
450: IEX_DEBUG_PUB.logMessage('req_id = ' || req_id);
451: IEX_DEBUG_PUB.logMessage('set_num = ' || set_num);
452: IEX_DEBUG_PUB.logMessage('process_mode = ' || process_mode);

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

445: ELSE
446: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE BEGIN');
447: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
448: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE BEGIN');
449: IEX_DEBUG_PUB.logMessage('Input parameters:');
450: IEX_DEBUG_PUB.logMessage('req_id = ' || req_id);
451: IEX_DEBUG_PUB.logMessage('set_num = ' || set_num);
452: IEX_DEBUG_PUB.logMessage('process_mode = ' || process_mode);
453:

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

446: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE BEGIN');
447: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
448: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE BEGIN');
449: IEX_DEBUG_PUB.logMessage('Input parameters:');
450: IEX_DEBUG_PUB.logMessage('req_id = ' || req_id);
451: IEX_DEBUG_PUB.logMessage('set_num = ' || set_num);
452: IEX_DEBUG_PUB.logMessage('process_mode = ' || process_mode);
453:
454: END IF;

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

447: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
448: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE BEGIN');
449: IEX_DEBUG_PUB.logMessage('Input parameters:');
450: IEX_DEBUG_PUB.logMessage('req_id = ' || req_id);
451: IEX_DEBUG_PUB.logMessage('set_num = ' || set_num);
452: IEX_DEBUG_PUB.logMessage('process_mode = ' || process_mode);
453:
454: END IF;
455:

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

448: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE BEGIN');
449: IEX_DEBUG_PUB.logMessage('Input parameters:');
450: IEX_DEBUG_PUB.logMessage('req_id = ' || req_id);
451: IEX_DEBUG_PUB.logMessage('set_num = ' || set_num);
452: IEX_DEBUG_PUB.logMessage('process_mode = ' || process_mode);
453:
454: END IF;
455:
456: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

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

456: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
457: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_DUNNING',FALSE);
458: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
459: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
460: IEX_DEBUG_PUB.logMessage('l_profile_val = ' || l_profile_val);
461: /* process IEX_STRATEGIES.CUST_ACCOUNT_ID */
462: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
463: IEX_DEBUG_PUB.logMessage('IEX_DUNNING.DUNNING_OBJECT_ID');
464: END IF;

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

459: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
460: IEX_DEBUG_PUB.logMessage('l_profile_val = ' || l_profile_val);
461: /* process IEX_STRATEGIES.CUST_ACCOUNT_ID */
462: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
463: IEX_DEBUG_PUB.logMessage('IEX_DUNNING.DUNNING_OBJECT_ID');
464: END IF;
465: open merged_records1;
466: LOOP
467: FETCH merged_records1 BULK COLLECT INTO

Line 480: IEX_DEBUG_PUB.logMessage('MERGE_HEADER_ID_LIST.COUNT is 0');

476:
477: END IF;
478:
479: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
480: IEX_DEBUG_PUB.logMessage('MERGE_HEADER_ID_LIST.COUNT is 0');
481: goto iex_account;
482: END IF;
483:
484: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP

Line 487: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE merged_records1 old : '||NUM_COL1_ORIG_LIST(I)||' new : '||NUM_COL1_NEW_LIST(I));

483:
484: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
485: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
486:
487: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE merged_records1 old : '||NUM_COL1_ORIG_LIST(I)||' new : '||NUM_COL1_NEW_LIST(I));
488:
489: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE merged_records1 dunning id : '||PRIMARY_KEY_ID_LIST(I));
490:
491:

Line 489: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE merged_records1 dunning id : '||PRIMARY_KEY_ID_LIST(I));

485: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
486:
487: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE merged_records1 old : '||NUM_COL1_ORIG_LIST(I)||' new : '||NUM_COL1_NEW_LIST(I));
488:
489: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE merged_records1 dunning id : '||PRIMARY_KEY_ID_LIST(I));
490:
491:
492: END LOOP;
493:

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

528: hz_utility_pub.LAST_UPDATED_BY);
529: END IF;
530:
531: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
532: IEX_DEBUG_PUB.logMessage('Merging mergerecord1 : ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');
533:
534:
535: END IF;
536:

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

571: MERGE_HEADER_ID_LIST.delete;
572: PRIMARY_KEY_ID_LIST.delete;
573: l_count := 0;
574: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
575: IEX_DEBUG_PUB.logMessage('IEX_DUNNINGS.DUNNING_OBJECT_ID.TYPE=ACCOUNT END');
576:
577: END IF;
578: open merged_records2;
579: LOOP

Line 587: IEX_DEBUG_PUB.logMessage('MERGE_HEADER_ID_LIST.COUNT for billto is 0');

583: , NUM_COL2_ORIG_LIST
584: limit G_Batch_Size;
585:
586: IF merged_records2%NOTFOUND THEN
587: IEX_DEBUG_PUB.logMessage('MERGE_HEADER_ID_LIST.COUNT for billto is 0');
588: l_last_fetch := TRUE;
589: END IF;
590:
591: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then

Line 599: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE merged_records2 old : '||NUM_COL2_ORIG_LIST(I)||' new : '||NUM_COL2_NEW_LIST(I));

595: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
596: --NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
597: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I)); -- 5874874 gnramasa 25-Apr-2007
598:
599: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE merged_records2 old : '||NUM_COL2_ORIG_LIST(I)||' new : '||NUM_COL2_NEW_LIST(I));
600:
601: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE merged_records2 dunning id : '||PRIMARY_KEY_ID_LIST(I));
602:
603: END LOOP;

Line 601: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE merged_records2 dunning id : '||PRIMARY_KEY_ID_LIST(I));

597: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I)); -- 5874874 gnramasa 25-Apr-2007
598:
599: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE merged_records2 old : '||NUM_COL2_ORIG_LIST(I)||' new : '||NUM_COL2_NEW_LIST(I));
600:
601: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNING_MERGE merged_records2 dunning id : '||PRIMARY_KEY_ID_LIST(I));
602:
603: END LOOP;
604: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
605: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

637: hz_utility_pub.LAST_UPDATED_BY);
638: END IF;
639:
640: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
641: IEX_DEBUG_PUB.logMessage('Merging merge_record2' || MERGE_HEADER_ID_LIST.COUNT || ' Records');
642:
643: END IF;
644: --FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
645: -- Changed for all loop to for loop to fix 14492050 Snuthala

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

669: arp_message.set_name('AR','AR_ROWS_UPDATED');
670: arp_message.set_token('NUM_ROWS',to_char(l_count));
671: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
672:
673: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DUNNNING_MERGE END');
674: END IF;
675:
676: END IF;
677:

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

787: IF process_mode='LOCK' THEN
788: NULL;
789: ELSE
790: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
791: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.STRATEGY_MERGE BEGIN');
792: END IF;
793:
794: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
795: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_STRATEGIES',FALSE);

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

797: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
798:
799: /* process IEX_STRATEGIES.CUST_ACCOUNT_ID */
800: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
801: IEX_DEBUG_PUB.logMessage('IEX_STRATEGIES.CUST_ACCOUNT_ID');
802: END IF;
803: open merged_records1;
804: LOOP
805: FETCH merged_records1 BULK COLLECT INTO

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

854: hz_utility_pub.LAST_UPDATED_BY);
855: END IF;
856:
857: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
858: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');
859: END IF;
860: --FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
861: -- Changed for all loop to for loop to fix 14492050 Snuthala
862: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT loop

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

894: PARTY_ID_LIST.delete;
895: STATUS_CODE_LIST.delete; --Added for bug#6974531 by schekuri on 14-Aug-2008
896: l_count := 0;
897: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
898: IEX_DEBUG_PUB.logMessage('IEX_STRATEGIES.JTF_OBJECT_ID.TYPE=IEX_ACCOUNT');
899: END IF;
900: open merged_records2;
901: LOOP
902: FETCH merged_records2 BULK COLLECT INTO

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

953: hz_utility_pub.LAST_UPDATED_BY);
954: END IF;
955:
956: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
957: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');
958: END IF;
959: --FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
960: -- Changed for all loop to for loop to fix 14492050 Snuthala
961: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT loop

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

1005: PRIMARY_KEY_ID_LIST.delete;
1006: STATUS_CODE_LIST.delete; --Added for bug#6974531 by schekuri on 14-Aug-2008
1007: l_count := 0;
1008: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1009: IEX_DEBUG_PUB.logMessage('IEX_STRATEGIES.JTF_OBJECT_ID.TYPE=IEX_BILLTO');
1010: END IF;
1011: open merged_records3;
1012: LOOP
1013: FETCH merged_records3 BULK COLLECT INTO

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

1064: hz_utility_pub.LAST_UPDATED_BY);
1065: END IF;
1066:
1067: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1068: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');
1069: END IF;
1070: --FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1071: -- Changed for all loop to for loop to fix 14492050 Snuthala
1072: for I in MERGE_HEADER_ID_LIST.first..MERGE_HEADER_ID_LIST.last loop

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

1106: arp_message.set_name('AR','AR_ROWS_UPDATED');
1107: arp_message.set_token('NUM_ROWS',to_char(l_count));
1108:
1109: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1110: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.STRATEGY_MERGE END');
1111: END IF;
1112:
1113: END IF;
1114: EXCEPTION

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

1327: l_count NUMBER;
1328: BEGIN
1329:
1330: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1331: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DELINQUENCY_MERGE BEGIN');
1332: IEX_DEBUG_PUB.logMessage('Input parameters:');
1333: IEX_DEBUG_PUB.logMessage('req_id = ' || req_id);
1334: IEX_DEBUG_PUB.logMessage('set_num = ' || set_num);
1335: IEX_DEBUG_PUB.logMessage('process_mode = ' || process_mode);

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

1328: BEGIN
1329:
1330: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1331: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DELINQUENCY_MERGE BEGIN');
1332: IEX_DEBUG_PUB.logMessage('Input parameters:');
1333: IEX_DEBUG_PUB.logMessage('req_id = ' || req_id);
1334: IEX_DEBUG_PUB.logMessage('set_num = ' || set_num);
1335: IEX_DEBUG_PUB.logMessage('process_mode = ' || process_mode);
1336: END IF;

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

1329:
1330: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1331: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DELINQUENCY_MERGE BEGIN');
1332: IEX_DEBUG_PUB.logMessage('Input parameters:');
1333: IEX_DEBUG_PUB.logMessage('req_id = ' || req_id);
1334: IEX_DEBUG_PUB.logMessage('set_num = ' || set_num);
1335: IEX_DEBUG_PUB.logMessage('process_mode = ' || process_mode);
1336: END IF;
1337:

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

1330: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1331: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DELINQUENCY_MERGE BEGIN');
1332: IEX_DEBUG_PUB.logMessage('Input parameters:');
1333: IEX_DEBUG_PUB.logMessage('req_id = ' || req_id);
1334: IEX_DEBUG_PUB.logMessage('set_num = ' || set_num);
1335: IEX_DEBUG_PUB.logMessage('process_mode = ' || process_mode);
1336: END IF;
1337:
1338: IF process_mode='LOCK' THEN

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

1331: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DELINQUENCY_MERGE BEGIN');
1332: IEX_DEBUG_PUB.logMessage('Input parameters:');
1333: IEX_DEBUG_PUB.logMessage('req_id = ' || req_id);
1334: IEX_DEBUG_PUB.logMessage('set_num = ' || set_num);
1335: IEX_DEBUG_PUB.logMessage('process_mode = ' || process_mode);
1336: END IF;
1337:
1338: IF process_mode='LOCK' THEN
1339: NULL;

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

1343: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1344: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1345:
1346: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1347: IEX_DEBUG_PUB.logMessage('l_profile_val = ' || l_profile_val);
1348: END IF;
1349:
1350: l_count := 0;
1351: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1348: END IF;
1349:
1350: l_count := 0;
1351: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1352: IEX_DEBUG_PUB.logMessage('Searching for ACCOUNT records...');
1353: END IF;
1354:
1355: /* merging cust_account_id */
1356: open merged_records;

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

1366: l_last_fetch := TRUE;
1367: END IF;
1368:
1369: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1370: IEX_DEBUG_PUB.logMessage('Fetched ' || MERGE_HEADER_ID_LIST.COUNT || ' records');
1371: END IF;
1372:
1373: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
1374: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1371: END IF;
1372:
1373: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
1374: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1375: IEX_DEBUG_PUB.logMessage('Exiting fetch');
1376: END IF;
1377: goto iex_delinquency_acc_site_use;
1378: END IF;
1379:

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

1382: END LOOP;
1383:
1384: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1385: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1386: IEX_DEBUG_PUB.logMessage('Inserting into HZ_CUSTOMER_MERGE_LOG...');
1387: END IF;
1388: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1389: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1390: MERGE_LOG_ID,

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

1415: hz_utility_pub.LAST_UPDATE_DATE,
1416: hz_utility_pub.LAST_UPDATED_BY);
1417:
1418: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1419: IEX_DEBUG_PUB.logMessage('...done');
1420: END IF;
1421:
1422: END IF;
1423: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1420: END IF;
1421:
1422: END IF;
1423: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1424: IEX_DEBUG_PUB.logMessage('Updating IEX_DELINQUENCIES_ALL...');
1425: END IF;
1426:
1427: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1428: UPDATE IEX_DELINQUENCIES_ALL yt SET

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

1437: , PROGRAM_UPDATE_DATE = SYSDATE
1438: WHERE DELINQUENCY_ID=PRIMARY_KEY_ID_LIST(I);
1439: l_count := l_count + SQL%ROWCOUNT;
1440: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1441: IEX_DEBUG_PUB.logMessage('...done');
1442: END IF;
1443:
1444: IF l_last_fetch THEN
1445: goto iex_delinquency_acc_site_use;

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

1446: END IF;
1447: END LOOP;
1448:
1449: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1450: IEX_DEBUG_PUB.logMessage('Total processed ' || l_count || ' ACCOUNT records');
1451: END IF;
1452:
1453: arp_message.set_name('AR','AR_ROWS_UPDATED');
1454: arp_message.set_token('NUM_ROWS',to_char(l_count));

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

1460: PRIMARY_KEY_ID_LIST.delete;
1461: l_count := 0;
1462:
1463: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1464: IEX_DEBUG_PUB.logMessage('Searching for CUSTOMER_SITE_USE_ID records...');
1465: END IF;
1466:
1467: open merged_records1;
1468: LOOP

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

1472: , NUM_COL2_ORIG_LIST
1473: limit G_Batch_Size;
1474:
1475: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1476: IEX_DEBUG_PUB.logMessage('Fetched ' || MERGE_HEADER_ID_LIST.COUNT || ' records');
1477: END IF;
1478:
1479: IF merged_records1%NOTFOUND THEN
1480: l_last_fetch := TRUE;

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

1481: END IF;
1482:
1483: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
1484: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1485: IEX_DEBUG_PUB.logMessage('Exiting fetch');
1486: END IF;
1487: exit;
1488: END IF;
1489:

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

1494:
1495: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1496:
1497: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1498: IEX_DEBUG_PUB.logMessage('Inserting into HZ_CUSTOMER_MERGE_LOG...');
1499: END IF;
1500:
1501: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1502: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

1528: hz_utility_pub.LAST_UPDATE_DATE,
1529: hz_utility_pub.LAST_UPDATED_BY);
1530:
1531: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1532: IEX_DEBUG_PUB.logMessage('...done');
1533: END IF;
1534:
1535: END IF;
1536:

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

1534:
1535: END IF;
1536:
1537: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1538: IEX_DEBUG_PUB.logMessage('Updating IEX_DELINQUENCIES_ALL...');
1539: END IF;
1540:
1541: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1542: UPDATE IEX_DELINQUENCIES_ALL yt SET

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

1550: , PROGRAM_UPDATE_DATE = SYSDATE
1551: WHERE DELINQUENCY_ID=PRIMARY_KEY_ID_LIST(I);
1552: l_count := l_count + SQL%ROWCOUNT;
1553: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1554: IEX_DEBUG_PUB.logMessage('...done');
1555: END IF;
1556: IF l_last_fetch THEN
1557: EXIT;
1558: END IF;

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

1558: END IF;
1559: END LOOP;
1560:
1561: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1562: IEX_DEBUG_PUB.logMessage('Total processed ' || l_count || ' CUSTOMER_SITE_USE_ID records');
1563: END IF;
1564:
1565: arp_message.set_name('AR','AR_ROWS_UPDATED');
1566: arp_message.set_token('NUM_ROWS',to_char(l_count));

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

1565: arp_message.set_name('AR','AR_ROWS_UPDATED');
1566: arp_message.set_token('NUM_ROWS',to_char(l_count));
1567:
1568: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1569: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.DELINQUENCY_MERGE END');
1570: END IF;
1571:
1572: END IF;
1573: EXCEPTION

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

1572: END IF;
1573: EXCEPTION
1574: WHEN OTHERS THEN
1575: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1576: IEX_DEBUG_PUB.logMessage('In IEX_MERGE_PVT.DELINQUENCY_MERGE exception');
1577: END IF;
1578: arp_message.set_line('DELINQUENCY_MERGE');
1579: RAISE;
1580: END DELINQUENCY_MERGE;

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

1599: -- End - 10/12/2005 - Andre Araujo - Add exception handling
1600:
1601: BEGIN
1602: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1603: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: Begin');
1604: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );
1605: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );
1606: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_fk_id: ' || p_from_fk_id );
1607: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_fk_id: ' || p_to_fk_id );

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

1600:
1601: BEGIN
1602: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1603: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: Begin');
1604: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );
1605: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );
1606: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_fk_id: ' || p_from_fk_id );
1607: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_fk_id: ' || p_to_fk_id );
1608: END IF;

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

1601: BEGIN
1602: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1603: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: Begin');
1604: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );
1605: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );
1606: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_fk_id: ' || p_from_fk_id );
1607: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_fk_id: ' || p_to_fk_id );
1608: END IF;
1609:

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

1602: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1603: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: Begin');
1604: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );
1605: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );
1606: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_fk_id: ' || p_from_fk_id );
1607: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_fk_id: ' || p_to_fk_id );
1608: END IF;
1609:
1610: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1603: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: Begin');
1604: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );
1605: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );
1606: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_fk_id: ' || p_from_fk_id );
1607: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_fk_id: ' || p_to_fk_id );
1608: END IF;
1609:
1610: x_return_status := FND_API.G_RET_STS_SUCCESS;
1611:

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

1830:
1831: /* end raverma 02032003 */
1832:
1833: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1834: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: End success!');
1835: END IF;
1836:
1837: RETURN;
1838:

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

1897: FND_MESSAGE.SET_TOKEN('NULL_PARAM', null);
1898: FND_MSG_PUB.ADD;
1899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1900:
1901: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: Null party_ids received!!!');
1902: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );
1903: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );
1904: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_fk_id: ' || p_from_fk_id );
1905: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_fk_id: ' || p_to_fk_id );

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

1898: FND_MSG_PUB.ADD;
1899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1900:
1901: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: Null party_ids received!!!');
1902: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );
1903: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );
1904: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_fk_id: ' || p_from_fk_id );
1905: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_fk_id: ' || p_to_fk_id );
1906:

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

1899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1900:
1901: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: Null party_ids received!!!');
1902: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );
1903: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );
1904: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_fk_id: ' || p_from_fk_id );
1905: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_fk_id: ' || p_to_fk_id );
1906:
1907: FND_FILE.PUT_LINE(FND_FILE.LOG,'MERGE_DELINQUENCY_PARTIES: Null party_ids received!!!');

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

1900:
1901: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: Null party_ids received!!!');
1902: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );
1903: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );
1904: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_fk_id: ' || p_from_fk_id );
1905: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_fk_id: ' || p_to_fk_id );
1906:
1907: FND_FILE.PUT_LINE(FND_FILE.LOG,'MERGE_DELINQUENCY_PARTIES: Null party_ids received!!!');
1908: FND_FILE.PUT_LINE(FND_FILE.LOG,'MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );

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

1901: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: Null party_ids received!!!');
1902: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );
1903: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );
1904: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_from_fk_id: ' || p_from_fk_id );
1905: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: p_to_fk_id: ' || p_to_fk_id );
1906:
1907: FND_FILE.PUT_LINE(FND_FILE.LOG,'MERGE_DELINQUENCY_PARTIES: Null party_ids received!!!');
1908: FND_FILE.PUT_LINE(FND_FILE.LOG,'MERGE_DELINQUENCY_PARTIES: p_from_id: ' || p_from_id );
1909: FND_FILE.PUT_LINE(FND_FILE.LOG,'MERGE_DELINQUENCY_PARTIES: p_to_id: ' || p_to_id );

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

1917: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1918: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1919: FND_MSG_PUB.ADD;
1920:
1921: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: EXCEPTION!!!');
1922: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: ' || SQLERRM);
1923:
1924: FND_FILE.PUT_LINE(FND_FILE.LOG,'MERGE_DELINQUENCY_PARTIES: EXCEPTION!!!');
1925: FND_FILE.PUT_LINE(FND_FILE.LOG,'MERGE_DELINQUENCY_PARTIES: ' || SQLERRM);

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

1918: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1919: FND_MSG_PUB.ADD;
1920:
1921: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: EXCEPTION!!!');
1922: IEX_DEBUG_PUB.LOGMESSAGE('MERGE_DELINQUENCY_PARTIES: ' || SQLERRM);
1923:
1924: FND_FILE.PUT_LINE(FND_FILE.LOG,'MERGE_DELINQUENCY_PARTIES: EXCEPTION!!!');
1925: FND_FILE.PUT_LINE(FND_FILE.LOG,'MERGE_DELINQUENCY_PARTIES: ' || SQLERRM);
1926:

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

1945: l_api_version_number CONSTANT NUMBER := 1.0;
1946: l_merge_reason_code VARCHAR2(30);
1947: BEGIN
1948: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1949: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.CASE_CONTACT_MERGE BEGIN');
1950: END IF;
1951: x_return_status := FND_API.G_RET_STS_SUCCESS;
1952:
1953: select merge_reason_code into l_merge_reason_code

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

2029: END IF;
2030: EXCEPTION
2031: WHEN OTHERS THEN
2032: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2033: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.CASE_CONTACT_MERGE EXCEPTION:');
2034: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT' || '.' || l_api_name || ': ' || sqlerrm);
2035: END IF;
2036: arp_message.set_line('IEX_MERGE_PVT' || '.' || l_api_name || ': ' || sqlerrm);
2037: x_return_status := FND_API.G_RET_STS_ERROR;

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

2030: EXCEPTION
2031: WHEN OTHERS THEN
2032: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2033: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.CASE_CONTACT_MERGE EXCEPTION:');
2034: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT' || '.' || l_api_name || ': ' || sqlerrm);
2035: END IF;
2036: arp_message.set_line('IEX_MERGE_PVT' || '.' || l_api_name || ': ' || sqlerrm);
2037: x_return_status := FND_API.G_RET_STS_ERROR;
2038: raise;

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

2039: END;
2040: END IF;
2041:
2042: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2043: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.CASE_CONTACT_MERGE END');
2044: END IF;
2045:
2046: END CASE_CONTACT_MERGE;
2047: