DBA Data[Home] [Help]

APPS.MRPP_CMERGE_FCST dependencies on ARP_MESSAGE

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

68: BEGIN
69: IF process_mode='LOCK' THEN
70: NULL;
71: ELSE
72: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
73: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_FORECAST_DATES',FALSE);
74: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
75: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
76:

Line 73: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_FORECAST_DATES',FALSE);

69: IF process_mode='LOCK' THEN
70: NULL;
71: ELSE
72: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
73: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_FORECAST_DATES',FALSE);
74: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
75: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
76:
77: open merged_records;

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

154: EXIT;
155: END IF;
156: END LOOP;
157:
158: arp_message.set_name('AR','AR_ROWS_UPDATED');
159: arp_message.set_token('NUM_ROWS',to_char(l_count));
160: END IF;
161: EXCEPTION
162: WHEN OTHERS THEN

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

155: END IF;
156: END LOOP;
157:
158: arp_message.set_name('AR','AR_ROWS_UPDATED');
159: arp_message.set_token('NUM_ROWS',to_char(l_count));
160: END IF;
161: EXCEPTION
162: WHEN OTHERS THEN
163: arp_message.set_line( 'MRP_FD');

Line 163: arp_message.set_line( 'MRP_FD');

159: arp_message.set_token('NUM_ROWS',to_char(l_count));
160: END IF;
161: EXCEPTION
162: WHEN OTHERS THEN
163: arp_message.set_line( 'MRP_FD');
164: RAISE;
165: END MRP_FD;
166:
167:

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

234: BEGIN
235: IF process_mode='LOCK' THEN
236: NULL;
237: ELSE
238: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
239: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_FORECAST_DESIGNATORS',FALSE);
240: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
241: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
242:

Line 239: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_FORECAST_DESIGNATORS',FALSE);

235: IF process_mode='LOCK' THEN
236: NULL;
237: ELSE
238: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
239: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_FORECAST_DESIGNATORS',FALSE);
240: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
241: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
242:
243: open merged_records;

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

324: EXIT;
325: END IF;
326: END LOOP;
327:
328: arp_message.set_name('AR','AR_ROWS_UPDATED');
329: arp_message.set_token('NUM_ROWS',to_char(l_count));
330: END IF;
331: EXCEPTION
332: WHEN OTHERS THEN

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

325: END IF;
326: END LOOP;
327:
328: arp_message.set_name('AR','AR_ROWS_UPDATED');
329: arp_message.set_token('NUM_ROWS',to_char(l_count));
330: END IF;
331: EXCEPTION
332: WHEN OTHERS THEN
333: arp_message.set_line( 'MRP_FDE');

Line 333: arp_message.set_line( 'MRP_FDE');

329: arp_message.set_token('NUM_ROWS',to_char(l_count));
330: END IF;
331: EXCEPTION
332: WHEN OTHERS THEN
333: arp_message.set_line( 'MRP_FDE');
334: RAISE;
335: END MRP_FDE;
336:
337:

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

399: BEGIN
400: IF process_mode='LOCK' THEN
401: NULL;
402: ELSE
403: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
404: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_FORECAST_UPDATES',FALSE);
405: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
406: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
407:

Line 404: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_FORECAST_UPDATES',FALSE);

400: IF process_mode='LOCK' THEN
401: NULL;
402: ELSE
403: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
404: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_FORECAST_UPDATES',FALSE);
405: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
406: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
407:
408: open merged_records;

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

488: EXIT;
489: END IF;
490: END LOOP;
491:
492: arp_message.set_name('AR','AR_ROWS_UPDATED');
493: arp_message.set_token('NUM_ROWS',to_char(l_count));
494: END IF;
495: EXCEPTION
496: WHEN OTHERS THEN

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

489: END IF;
490: END LOOP;
491:
492: arp_message.set_name('AR','AR_ROWS_UPDATED');
493: arp_message.set_token('NUM_ROWS',to_char(l_count));
494: END IF;
495: EXCEPTION
496: WHEN OTHERS THEN
497: arp_message.set_line( 'MRP_FU');

Line 497: arp_message.set_line( 'MRP_FU');

493: arp_message.set_token('NUM_ROWS',to_char(l_count));
494: END IF;
495: EXCEPTION
496: WHEN OTHERS THEN
497: arp_message.set_line( 'MRP_FU');
498: RAISE;
499: END MRP_FU;
500:
501:

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

586: BEGIN
587: IF process_mode='LOCK' THEN
588: NULL;
589: ELSE
590: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
591: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_SALES_ORDER_UPDATES',FALSE);
592: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
593: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
594:

Line 591: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_SALES_ORDER_UPDATES',FALSE);

587: IF process_mode='LOCK' THEN
588: NULL;
589: ELSE
590: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
591: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_SALES_ORDER_UPDATES',FALSE);
592: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
593: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
594:
595: open merged_records;

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

692: EXIT;
693: END IF;
694: END LOOP;
695:
696: arp_message.set_name('AR','AR_ROWS_UPDATED');
697: arp_message.set_token('NUM_ROWS',to_char(l_count));
698: END IF;
699: EXCEPTION
700: WHEN OTHERS THEN

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

693: END IF;
694: END LOOP;
695:
696: arp_message.set_name('AR','AR_ROWS_UPDATED');
697: arp_message.set_token('NUM_ROWS',to_char(l_count));
698: END IF;
699: EXCEPTION
700: WHEN OTHERS THEN
701: arp_message.set_line( 'MRP_SOU');

Line 701: arp_message.set_line( 'MRP_SOU');

697: arp_message.set_token('NUM_ROWS',to_char(l_count));
698: END IF;
699: EXCEPTION
700: WHEN OTHERS THEN
701: arp_message.set_line( 'MRP_SOU');
702: RAISE;
703: END MRP_SOU;
704:
705: /*-------------------------------------------------------------

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

808: BEGIN
809: IF process_mode='LOCK' THEN
810: NULL;
811: ELSE
812: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
813: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_SR_ASSIGNMENTS',FALSE);
814: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
815: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
816:

Line 813: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_SR_ASSIGNMENTS',FALSE);

809: IF process_mode='LOCK' THEN
810: NULL;
811: ELSE
812: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
813: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_SR_ASSIGNMENTS',FALSE);
814: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
815: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
816:
817: /* Fix for bug 1292873, part 2. */

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

997: EXIT;
998: END IF;
999: END LOOP;
1000:
1001: arp_message.set_name('AR','AR_ROWS_UPDATED');
1002: arp_message.set_token('NUM_ROWS',to_char(l_count));
1003: END IF;
1004: EXCEPTION
1005: WHEN OTHERS THEN

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

998: END IF;
999: END LOOP;
1000:
1001: arp_message.set_name('AR','AR_ROWS_UPDATED');
1002: arp_message.set_token('NUM_ROWS',to_char(l_count));
1003: END IF;
1004: EXCEPTION
1005: WHEN OTHERS THEN
1006: arp_message.set_line( 'MRP_SA');

Line 1006: arp_message.set_line( 'MRP_SA');

1002: arp_message.set_token('NUM_ROWS',to_char(l_count));
1003: END IF;
1004: EXCEPTION
1005: WHEN OTHERS THEN
1006: arp_message.set_line( 'MRP_SA');
1007: RAISE;
1008: END MRP_SA;
1009:
1010:

Line 1016: arp_message.set_line( 'MRPP_CMERGE_FCST.MERGE()+' );

1012:
1013: PROCEDURE MERGE (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
1014: BEGIN
1015:
1016: arp_message.set_line( 'MRPP_CMERGE_FCST.MERGE()+' );
1017:
1018: MRP_FD( req_id, set_num, process_mode );
1019: MRP_FDE( req_id, set_num, process_mode );
1020: MRP_FU( req_id, set_num, process_mode );

Line 1024: arp_message.set_line( 'MRPP_CMERGE_FCST.MERGE()-' );

1020: MRP_FU( req_id, set_num, process_mode );
1021: MRP_SOU( req_id, set_num, process_mode);
1022: MRP_SA( req_id, set_num, process_mode); /* Bug 1848916 */
1023:
1024: arp_message.set_line( 'MRPP_CMERGE_FCST.MERGE()-' );
1025:
1026: END MERGE;
1027:
1028: end MRPP_CMERGE_FCST;