60:
61: IF process_mode='LOCK' THEN
62: NULL;
63: ELSE
64: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
65: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','dpp_customer_claims_all',FALSE);
66: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
67: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
68:
61: IF process_mode='LOCK' THEN
62: NULL;
63: ELSE
64: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
65: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','dpp_customer_claims_all',FALSE);
66: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
67: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
68:
69: open merged_records;
130: EXIT;
131: END IF;
132: END LOOP;
133:
134: arp_message.set_name('AR','AR_ROWS_UPDATED');
135: arp_message.set_token('NUM_ROWS',to_char(l_count));
136: END IF;
137: EXCEPTION
138: WHEN OTHERS THEN
131: END IF;
132: END LOOP;
133:
134: arp_message.set_name('AR','AR_ROWS_UPDATED');
135: arp_message.set_token('NUM_ROWS',to_char(l_count));
136: END IF;
137: EXCEPTION
138: WHEN OTHERS THEN
139: arp_message.set_line( 'merge_claim_account');
135: arp_message.set_token('NUM_ROWS',to_char(l_count));
136: END IF;
137: EXCEPTION
138: WHEN OTHERS THEN
139: arp_message.set_line( 'merge_claim_account');
140: RAISE;
141: END merge_claim_account;
142:
143: /*-------------------------------------------------------------
195:
196: IF process_mode='LOCK' THEN
197: NULL;
198: ELSE
199: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
200: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','dpp_customer_claims_log',FALSE);
201: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
202: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
203:
196: IF process_mode='LOCK' THEN
197: NULL;
198: ELSE
199: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
200: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','dpp_customer_claims_log',FALSE);
201: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
202: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
203:
204: open merged_records;
265: EXIT;
266: END IF;
267: END LOOP;
268:
269: arp_message.set_name('AR','AR_ROWS_UPDATED');
270: arp_message.set_token('NUM_ROWS',to_char(l_count));
271: END IF;
272: EXCEPTION
273: WHEN OTHERS THEN
266: END IF;
267: END LOOP;
268:
269: arp_message.set_name('AR','AR_ROWS_UPDATED');
270: arp_message.set_token('NUM_ROWS',to_char(l_count));
271: END IF;
272: EXCEPTION
273: WHEN OTHERS THEN
274: arp_message.set_line( 'merge_claim_account_log');
270: arp_message.set_token('NUM_ROWS',to_char(l_count));
271: END IF;
272: EXCEPTION
273: WHEN OTHERS THEN
274: arp_message.set_line( 'merge_claim_account_log');
275: RAISE;
276: END merge_claim_account_log;
277:
278: