316: IF process_mode='LOCK' THEN
317: NULL;
318: ELSE
319:
320: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
321: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','LNS_LOAN_HEADERS',FALSE);
322: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
323: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
324:
317: NULL;
318: ELSE
319:
320: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
321: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','LNS_LOAN_HEADERS',FALSE);
322: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
323: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
324:
325:
406: END IF;
407:
408: END LOOP;
409: LogMessage(FND_LOG.LEVEL_STATEMENT,'Total processed ' || l_count || ' ACCOUNT records');
410: arp_message.set_name('AR','AR_ROWS_UPDATED');
411: arp_message.set_token('NUM_ROWS',to_char(l_count));
412:
413: <
414: /* merging CUST_ACCT_SITE_ID */
407:
408: END LOOP;
409: LogMessage(FND_LOG.LEVEL_STATEMENT,'Total processed ' || l_count || ' ACCOUNT records');
410: arp_message.set_name('AR','AR_ROWS_UPDATED');
411: arp_message.set_token('NUM_ROWS',to_char(l_count));
412:
413: <
414: /* merging CUST_ACCT_SITE_ID */
415:
500: END IF;
501:
502: END LOOP;
503: LogMessage(FND_LOG.LEVEL_STATEMENT,'Total processed ' || l_count || ' CUST_ACCT_SITES records');
504: arp_message.set_name('AR','AR_ROWS_UPDATED');
505: arp_message.set_token('NUM_ROWS',to_char(l_count));
506:
507: END IF;
508:
501:
502: END LOOP;
503: LogMessage(FND_LOG.LEVEL_STATEMENT,'Total processed ' || l_count || ' CUST_ACCT_SITES records');
504: arp_message.set_name('AR','AR_ROWS_UPDATED');
505: arp_message.set_token('NUM_ROWS',to_char(l_count));
506:
507: END IF;
508:
509: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' END -');
510:
511: EXCEPTION
512: WHEN OTHERS THEN
513: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' EXCEPTION');
514: arp_message.set_line( 'MERGE_LOAN_HEADERS_ACC');
515: RAISE;
516: END MERGE_LOAN_HEADERS_ACC;
517:
518:
584: NULL;
585:
586: ELSE
587:
588: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
589: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','LNS_PARTICIPANTS',FALSE);
590: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
591: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
592:
585:
586: ELSE
587:
588: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
589: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','LNS_PARTICIPANTS',FALSE);
590: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
591: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
592:
593: LogMessage(FND_LOG.LEVEL_STATEMENT,'Searching for ACCOUNT records...');
671: END IF;
672:
673: END LOOP;
674: LogMessage(FND_LOG.LEVEL_STATEMENT,'Total processed ' || l_count || ' ACCOUNT records');
675: arp_message.set_name('AR','AR_ROWS_UPDATED');
676: arp_message.set_token('NUM_ROWS',to_char(l_count));
677:
678:
679: <
672:
673: END LOOP;
674: LogMessage(FND_LOG.LEVEL_STATEMENT,'Total processed ' || l_count || ' ACCOUNT records');
675: arp_message.set_name('AR','AR_ROWS_UPDATED');
676: arp_message.set_token('NUM_ROWS',to_char(l_count));
677:
678:
679: <
680: /* merging CUST_ACCT_SITE_ID */
764: END IF;
765:
766: END LOOP;
767: LogMessage(FND_LOG.LEVEL_STATEMENT,'Total processed ' || l_count || ' CUST_ACCT_SITES records');
768: arp_message.set_name('AR','AR_ROWS_UPDATED');
769: arp_message.set_token('NUM_ROWS',to_char(l_count));
770:
771: END IF;
772:
765:
766: END LOOP;
767: LogMessage(FND_LOG.LEVEL_STATEMENT,'Total processed ' || l_count || ' CUST_ACCT_SITES records');
768: arp_message.set_name('AR','AR_ROWS_UPDATED');
769: arp_message.set_token('NUM_ROWS',to_char(l_count));
770:
771: END IF;
772:
773: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' END -');
774:
775: EXCEPTION
776: WHEN OTHERS THEN
777: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' EXCEPTION');
778: arp_message.set_line( 'MERGE_PARTICIPANTS_ACC');
779: RAISE;
780: END MERGE_PARTICIPANTS_ACC;
781:
782: