67: BEGIN
68: IF process_mode='LOCK' THEN
69: NULL;
70: ELSE
71: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
72: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OE_AGREEMENTS_B',FALSE);
73: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
74: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
75:
68: IF process_mode='LOCK' THEN
69: NULL;
70: ELSE
71: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
72: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OE_AGREEMENTS_B',FALSE);
73: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
74: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
75:
76: open merged_records;
140: EXIT;
141: END IF;
142: END LOOP;
143:
144: arp_message.set_name('AR','AR_ROWS_UPDATED');
145: arp_message.set_token('NUM_ROWS',to_char(l_count));
146: END IF;
147: EXCEPTION
148: WHEN OTHERS THEN
141: END IF;
142: END LOOP;
143:
144: arp_message.set_name('AR','AR_ROWS_UPDATED');
145: arp_message.set_token('NUM_ROWS',to_char(l_count));
146: END IF;
147: EXCEPTION
148: WHEN OTHERS THEN
149: arp_message.set_line( 'Agreement_Merge');
145: arp_message.set_token('NUM_ROWS',to_char(l_count));
146: END IF;
147: EXCEPTION
148: WHEN OTHERS THEN
149: arp_message.set_line( 'Agreement_Merge');
150: RAISE;
151: END Agreement_Merge;
152:
153:
248: BEGIN
249: IF process_mode='LOCK' THEN
250: NULL;
251: ELSE
252: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
253: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','QP_QUALIFIERS',FALSE);
254: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
255: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
256:
249: IF process_mode='LOCK' THEN
250: NULL;
251: ELSE
252: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
253: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','QP_QUALIFIERS',FALSE);
254: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
255: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
256:
257: open merged_records;
350: EXIT;
351: END IF;
352: END LOOP;
353:
354: arp_message.set_name('AR','AR_ROWS_UPDATED');
355: arp_message.set_token('NUM_ROWS',to_char(l_count));
356: END IF;
357: EXCEPTION
358: WHEN OTHERS THEN
351: END IF;
352: END LOOP;
353:
354: arp_message.set_name('AR','AR_ROWS_UPDATED');
355: arp_message.set_token('NUM_ROWS',to_char(l_count));
356: END IF;
357: EXCEPTION
358: WHEN OTHERS THEN
359: arp_message.set_line( 'Qualifier_Merge');
355: arp_message.set_token('NUM_ROWS',to_char(l_count));
356: END IF;
357: EXCEPTION
358: WHEN OTHERS THEN
359: arp_message.set_line( 'Qualifier_Merge');
360: RAISE;
361: END Qualifier_Merge;
362:
363:
363:
364: PROCEDURE Merge (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) IS
365: BEGIN
366:
367: arp_message.set_line('QP_CUST_MERGE.Merge()+');
368:
369: Agreement_Merge(req_id, set_num, process_mode);
370: Qualifier_Merge(req_id, set_num, process_mode);
371:
368:
369: Agreement_Merge(req_id, set_num, process_mode);
370: Qualifier_Merge(req_id, set_num, process_mode);
371:
372: arp_message.set_line('QP_CUST_MERGE.Merge()-');
373:
374: EXCEPTION
375: when others then
376: raise;