DBA Data[Home] [Help]

APPS.QP_CUST_MERGE dependencies on ARP_MESSAGE

Line 71: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

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:

Line 72: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OE_AGREEMENTS_B',FALSE);

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;

Line 144: arp_message.set_name('AR','AR_ROWS_UPDATED');

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

Line 145: arp_message.set_token('NUM_ROWS',to_char(l_count));

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');

Line 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:

Line 252: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

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:

Line 253: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','QP_QUALIFIERS',FALSE);

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;

Line 354: arp_message.set_name('AR','AR_ROWS_UPDATED');

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

Line 355: arp_message.set_token('NUM_ROWS',to_char(l_count));

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');

Line 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:

Line 367: arp_message.set_line('QP_CUST_MERGE.Merge()+');

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:

Line 372: 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:
372: arp_message.set_line('QP_CUST_MERGE.Merge()-');
373:
374: EXCEPTION
375: when others then
376: raise;