52: BEGIN
53: IF process_mode='LOCK' THEN
54: NULL;
55: ELSE
56: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
57: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ISC_BOOK_SUM2_PDUE_F',FALSE);
58: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
59: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
60:
53: IF process_mode='LOCK' THEN
54: NULL;
55: ELSE
56: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
57: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ISC_BOOK_SUM2_PDUE_F',FALSE);
58: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
59: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
60:
61: open merged_records;
129: EXIT;
130: END IF;
131: END LOOP;
132:
133: arp_message.set_name('AR','AR_ROWS_UPDATED');
134: arp_message.set_token('NUM_ROWS',to_char(l_count));
135: END IF;
136: EXCEPTION
137: WHEN OTHERS THEN
130: END IF;
131: END LOOP;
132:
133: arp_message.set_name('AR','AR_ROWS_UPDATED');
134: arp_message.set_token('NUM_ROWS',to_char(l_count));
135: END IF;
136: EXCEPTION
137: WHEN OTHERS THEN
138: arp_message.set_line( 'ISC_BOOK_SUM2_PDUE_F_AM');
134: arp_message.set_token('NUM_ROWS',to_char(l_count));
135: END IF;
136: EXCEPTION
137: WHEN OTHERS THEN
138: arp_message.set_line( 'ISC_BOOK_SUM2_PDUE_F_AM');
139: RAISE;
140: END ISC_BOOK_SUM2_PDUE_F_AM;
141:
142: PROCEDURE ISC_BOOK_SUM2_PDUE2_F_AM (
190: BEGIN
191: IF process_mode='LOCK' THEN
192: NULL;
193: ELSE
194: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
195: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ISC_BOOK_SUM2_PDUE2_F',FALSE);
196: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
197: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
198:
191: IF process_mode='LOCK' THEN
192: NULL;
193: ELSE
194: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
195: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ISC_BOOK_SUM2_PDUE2_F',FALSE);
196: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
197: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
198:
199: open merged_records;
267: EXIT;
268: END IF;
269: END LOOP;
270:
271: arp_message.set_name('AR','AR_ROWS_UPDATED');
272: arp_message.set_token('NUM_ROWS',to_char(l_count));
273: END IF;
274: EXCEPTION
275: WHEN OTHERS THEN
268: END IF;
269: END LOOP;
270:
271: arp_message.set_name('AR','AR_ROWS_UPDATED');
272: arp_message.set_token('NUM_ROWS',to_char(l_count));
273: END IF;
274: EXCEPTION
275: WHEN OTHERS THEN
276: arp_message.set_line( 'ISC_BOOK_SUM2_PDUE2_F_AM');
272: arp_message.set_token('NUM_ROWS',to_char(l_count));
273: END IF;
274: EXCEPTION
275: WHEN OTHERS THEN
276: arp_message.set_line( 'ISC_BOOK_SUM2_PDUE2_F_AM');
277: RAISE;
278: END ISC_BOOK_SUM2_PDUE2_F_AM;
279:
280: PROCEDURE ISC_BOOK_SUM2_BKORD_F_AM (
328: BEGIN
329: IF process_mode='LOCK' THEN
330: NULL;
331: ELSE
332: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
333: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ISC_BOOK_SUM2_BKORD_F',FALSE);
334: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
335: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
336:
329: IF process_mode='LOCK' THEN
330: NULL;
331: ELSE
332: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
333: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ISC_BOOK_SUM2_BKORD_F',FALSE);
334: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
335: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
336:
337: open merged_records;
405: EXIT;
406: END IF;
407: END LOOP;
408:
409: arp_message.set_name('AR','AR_ROWS_UPDATED');
410: arp_message.set_token('NUM_ROWS',to_char(l_count));
411: END IF;
412: EXCEPTION
413: WHEN OTHERS THEN
406: END IF;
407: END LOOP;
408:
409: arp_message.set_name('AR','AR_ROWS_UPDATED');
410: arp_message.set_token('NUM_ROWS',to_char(l_count));
411: END IF;
412: EXCEPTION
413: WHEN OTHERS THEN
414: arp_message.set_line( 'ISC_BOOK_SUM2_BKORD_F_AM');
410: arp_message.set_token('NUM_ROWS',to_char(l_count));
411: END IF;
412: EXCEPTION
413: WHEN OTHERS THEN
414: arp_message.set_line( 'ISC_BOOK_SUM2_BKORD_F_AM');
415: RAISE;
416: END ISC_BOOK_SUM2_BKORD_F_AM;
417:
418: