APPS.PNP_CMERGE dependencies on ARP_MESSAGE

Line 140: arp_message.set_line ( 'PNP_CMERGE.MERGE()+');

136: FOR UPDATE NOWAIT;
137:
138: BEGIN
139:
140: arp_message.set_line ( 'PNP_CMERGE.MERGE()+');
141:
142: IF( process_mode = 'LOCK' ) THEN
143:
144: /* Lock leases */

Line 145: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

141:
142: IF( process_mode = 'LOCK' ) THEN
143:
144: /* Lock leases */
145: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
146: arp_message.set_token( 'TABLE_NAME', 'PN_LEASES', FALSE );
147:
148: OPEN leases;
149: CLOSE leases;

Line 146: arp_message.set_token( 'TABLE_NAME', 'PN_LEASES', FALSE );

142: IF( process_mode = 'LOCK' ) THEN
143:
144: /* Lock leases */
145: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
146: arp_message.set_token( 'TABLE_NAME', 'PN_LEASES', FALSE );
147:
148: OPEN leases;
149: CLOSE leases;
150:

Line 152: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

148: OPEN leases;
149: CLOSE leases;
150:
151: /* Lock Tenancies */
152: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
153: arp_message.set_token( 'TABLE_NAME', 'PN_TENANCIES', FALSE );
154:
155: OPEN tenencies;
156: CLOSE tenencies;

Line 153: arp_message.set_token( 'TABLE_NAME', 'PN_TENANCIES', FALSE );

149: CLOSE leases;
150:
151: /* Lock Tenancies */
152: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
153: arp_message.set_token( 'TABLE_NAME', 'PN_TENANCIES', FALSE );
154:
155: OPEN tenencies;
156: CLOSE tenencies;
157:

Line 159: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

155: OPEN tenencies;
156: CLOSE tenencies;
157:
158: /* Lock Tenancies History */
159: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
160: arp_message.set_token( 'TABLE_NAME', 'PN_TENANCIES_HISTORY', FALSE );
161:
162: OPEN tenencies_history;
163: CLOSE tenencies_history;

Line 160: arp_message.set_token( 'TABLE_NAME', 'PN_TENANCIES_HISTORY', FALSE );

156: CLOSE tenencies;
157:
158: /* Lock Tenancies History */
159: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
160: arp_message.set_token( 'TABLE_NAME', 'PN_TENANCIES_HISTORY', FALSE );
161:
162: OPEN tenencies_history;
163: CLOSE tenencies_history;
164:

Line 166: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

162: OPEN tenencies_history;
163: CLOSE tenencies_history;
164:
165: /* Lock Term Templates */
166: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
167: arp_message.set_token( 'TABLE_NAME', 'PN_TERM_TEMPLATES', FALSE );
168:
169: OPEN term_templates;
170: CLOSE term_templates;

Line 167: arp_message.set_token( 'TABLE_NAME', 'PN_TERM_TEMPLATES', FALSE );

163: CLOSE tenencies_history;
164:
165: /* Lock Term Templates */
166: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
167: arp_message.set_token( 'TABLE_NAME', 'PN_TERM_TEMPLATES', FALSE );
168:
169: OPEN term_templates;
170: CLOSE term_templates;
171:

Line 173: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

169: OPEN term_templates;
170: CLOSE term_templates;
171:
172: /* Lock Terms */
173: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
174: arp_message.set_token( 'TABLE_NAME', 'PN_PAYMENT_TERMS', FALSE );
175:
176: OPEN pmt_terms;
177: CLOSE pmt_terms;

Line 174: arp_message.set_token( 'TABLE_NAME', 'PN_PAYMENT_TERMS', FALSE );

170: CLOSE term_templates;
171:
172: /* Lock Terms */
173: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
174: arp_message.set_token( 'TABLE_NAME', 'PN_PAYMENT_TERMS', FALSE );
175:
176: OPEN pmt_terms;
177: CLOSE pmt_terms;
178:

Line 180: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

176: OPEN pmt_terms;
177: CLOSE pmt_terms;
178:
179: /* Lock Items */
180: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
181: arp_message.set_token( 'TABLE_NAME', 'PN_PAYMENT_ITEMS', FALSE );
182:
183: OPEN pmt_items;
184: CLOSE pmt_items;

Line 181: arp_message.set_token( 'TABLE_NAME', 'PN_PAYMENT_ITEMS', FALSE );

177: CLOSE pmt_terms;
178:
179: /* Lock Items */
180: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
181: arp_message.set_token( 'TABLE_NAME', 'PN_PAYMENT_ITEMS', FALSE );
182:
183: OPEN pmt_items;
184: CLOSE pmt_items;
185:

Line 187: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

183: OPEN pmt_items;
184: CLOSE pmt_items;
185:
186: /* Lock Recovery Agreements */
187: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
188: arp_message.set_token( 'TABLE_NAME', 'PN_REC_AGREEMENTS', FALSE );
189:
190: OPEN rec_agreements;
191: CLOSE rec_agreements;

Line 188: arp_message.set_token( 'TABLE_NAME', 'PN_REC_AGREEMENTS', FALSE );

184: CLOSE pmt_items;
185:
186: /* Lock Recovery Agreements */
187: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
188: arp_message.set_token( 'TABLE_NAME', 'PN_REC_AGREEMENTS', FALSE );
189:
190: OPEN rec_agreements;
191: CLOSE rec_agreements;
192:

Line 194: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

190: OPEN rec_agreements;
191: CLOSE rec_agreements;
192:
193: /* Lock Area Class Line Details */
194: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
195: arp_message.set_token( 'TABLE_NAME', 'PN_REC_ARCL_DTLLN', FALSE );
196:
197: OPEN rec_arcl_dtlln;
198: CLOSE rec_arcl_dtlln;

Line 195: arp_message.set_token( 'TABLE_NAME', 'PN_REC_ARCL_DTLLN', FALSE );

191: CLOSE rec_agreements;
192:
193: /* Lock Area Class Line Details */
194: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
195: arp_message.set_token( 'TABLE_NAME', 'PN_REC_ARCL_DTLLN', FALSE );
196:
197: OPEN rec_arcl_dtlln;
198: CLOSE rec_arcl_dtlln;
199:

Line 201: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

197: OPEN rec_arcl_dtlln;
198: CLOSE rec_arcl_dtlln;
199:
200: /* Lock Expense Class Line Details */
201: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
202: arp_message.set_token( 'TABLE_NAME', 'PN_REC_EXPCL_DTLLN', FALSE );
203:
204: OPEN rec_expcl_dtlln;
205: CLOSE rec_expcl_dtlln;

Line 202: arp_message.set_token( 'TABLE_NAME', 'PN_REC_EXPCL_DTLLN', FALSE );

198: CLOSE rec_arcl_dtlln;
199:
200: /* Lock Expense Class Line Details */
201: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
202: arp_message.set_token( 'TABLE_NAME', 'PN_REC_EXPCL_DTLLN', FALSE );
203:
204: OPEN rec_expcl_dtlln;
205: CLOSE rec_expcl_dtlln;
206:

Line 208: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

204: OPEN rec_expcl_dtlln;
205: CLOSE rec_expcl_dtlln;
206:
207: /* Lock Recovery Period Lines */
208: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
209: arp_message.set_token( 'TABLE_NAME', 'PN_REC_PERIOD_LINES', FALSE );
210:
211: OPEN rec_period_lines;
212: CLOSE rec_period_lines;

Line 209: arp_message.set_token( 'TABLE_NAME', 'PN_REC_PERIOD_LINES', FALSE );

205: CLOSE rec_expcl_dtlln;
206:
207: /* Lock Recovery Period Lines */
208: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
209: arp_message.set_token( 'TABLE_NAME', 'PN_REC_PERIOD_LINES', FALSE );
210:
211: OPEN rec_period_lines;
212: CLOSE rec_period_lines;
213:

Line 215: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

211: OPEN rec_period_lines;
212: CLOSE rec_period_lines;
213:
214: /* Lock Customer Assignments */
215: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
216: arp_message.set_token( 'TABLE_NAME', 'PN_SPACE_ASSIGN_CUST', FALSE );
217:
218: OPEN cust_assignments;
219: CLOSE cust_assignments;

Line 216: arp_message.set_token( 'TABLE_NAME', 'PN_SPACE_ASSIGN_CUST', FALSE );

212: CLOSE rec_period_lines;
213:
214: /* Lock Customer Assignments */
215: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
216: arp_message.set_token( 'TABLE_NAME', 'PN_SPACE_ASSIGN_CUST', FALSE );
217:
218: OPEN cust_assignments;
219: CLOSE cust_assignments;
220:

Line 280: arp_message.set_line ( 'PNP_CMERGE.MERGE()-');

276: );
277:
278: END IF;
279:
280: arp_message.set_line ( 'PNP_CMERGE.MERGE()-');
281:
282: EXCEPTION
283: WHEN OTHERS THEN
284: arp_message.set_error( 'PNP_CMERGE.MERGE');

Line 284: arp_message.set_error( 'PNP_CMERGE.MERGE');

280: arp_message.set_line ( 'PNP_CMERGE.MERGE()-');
281:
282: EXCEPTION
283: WHEN OTHERS THEN
284: arp_message.set_error( 'PNP_CMERGE.MERGE');
285: RAISE;
286:
287: END MERGE;
288:

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

352:
353: IF process_mode='LOCK' THEN
354: NULL;
355: ELSE
356: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
357: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_LEASES',FALSE);
358: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
359: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
360:

Line 357: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_LEASES',FALSE);

353: IF process_mode='LOCK' THEN
354: NULL;
355: ELSE
356: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
357: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_LEASES',FALSE);
358: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
359: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
360:
361: OPEN merged_records;

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

429: END IF;
430:
431: END LOOP;
432:
433: arp_message.set_name('AR','AR_ROWS_UPDATED');
434: arp_message.set_token('NUM_ROWS',to_char(l_count));
435:
436: END IF;
437: EXCEPTION

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

430:
431: END LOOP;
432:
433: arp_message.set_name('AR','AR_ROWS_UPDATED');
434: arp_message.set_token('NUM_ROWS',to_char(l_count));
435:
436: END IF;
437: EXCEPTION
438: WHEN OTHERS THEN

Line 439: arp_message.set_line( 'update_leases');

435:
436: END IF;
437: EXCEPTION
438: WHEN OTHERS THEN
439: arp_message.set_line( 'update_leases');
440: RAISE;
441: END update_leases;
442:
443: /*===========================================================================+

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

515:
516: IF process_mode='LOCK' THEN
517: NULL;
518: ELSE
519: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
520: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_TENANCIES',FALSE);
521: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
522: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
523:

Line 520: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_TENANCIES',FALSE);

516: IF process_mode='LOCK' THEN
517: NULL;
518: ELSE
519: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
520: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_TENANCIES',FALSE);
521: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
522: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
523:
524: OPEN merged_records;

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

599: END IF;
600:
601: END LOOP;
602:
603: arp_message.set_name('AR','AR_ROWS_UPDATED');
604: arp_message.set_token('NUM_ROWS',to_char(l_count));
605:
606: END IF;
607:

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

600:
601: END LOOP;
602:
603: arp_message.set_name('AR','AR_ROWS_UPDATED');
604: arp_message.set_token('NUM_ROWS',to_char(l_count));
605:
606: END IF;
607:
608: EXCEPTION

Line 610: arp_message.set_line( 'update_tenancies');

606: END IF;
607:
608: EXCEPTION
609: WHEN OTHERS THEN
610: arp_message.set_line( 'update_tenancies');
611: RAISE;
612: END update_tenancies;
613:
614: /*===========================================================================+

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

686:
687: IF process_mode='LOCK' THEN
688: NULL;
689: ELSE
690: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
691: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_TENANCIES_HISTORY',FALSE);
692: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
693: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
694:

Line 691: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_TENANCIES_HISTORY',FALSE);

687: IF process_mode='LOCK' THEN
688: NULL;
689: ELSE
690: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
691: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_TENANCIES_HISTORY',FALSE);
692: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
693: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
694:
695: OPEN merged_records;

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

770: END IF;
771:
772: END LOOP;
773:
774: arp_message.set_name('AR','AR_ROWS_UPDATED');
775: arp_message.set_token('NUM_ROWS',to_char(l_count));
776: END IF;
777: EXCEPTION
778: WHEN OTHERS THEN

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

771:
772: END LOOP;
773:
774: arp_message.set_name('AR','AR_ROWS_UPDATED');
775: arp_message.set_token('NUM_ROWS',to_char(l_count));
776: END IF;
777: EXCEPTION
778: WHEN OTHERS THEN
779: arp_message.set_line( 'update_tenancies_history');

Line 779: arp_message.set_line( 'update_tenancies_history');

775: arp_message.set_token('NUM_ROWS',to_char(l_count));
776: END IF;
777: EXCEPTION
778: WHEN OTHERS THEN
779: arp_message.set_line( 'update_tenancies_history');
780: RAISE;
781: END update_tenancies_history;
782:
783: /*===========================================================================+

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

865:
866: IF process_mode='LOCK' THEN
867: NULL;
868: ELSE
869: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
870: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_TERM_TEMPLATES',FALSE);
871: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
872: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
873:

Line 870: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_TERM_TEMPLATES',FALSE);

866: IF process_mode='LOCK' THEN
867: NULL;
868: ELSE
869: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
870: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_TERM_TEMPLATES',FALSE);
871: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
872: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
873:
874: OPEN merged_records;

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

955: END IF;
956:
957: END LOOP;
958:
959: arp_message.set_name('AR','AR_ROWS_UPDATED');
960: arp_message.set_token('NUM_ROWS',to_char(l_count));
961: END IF;
962: EXCEPTION
963: WHEN OTHERS THEN

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

956:
957: END LOOP;
958:
959: arp_message.set_name('AR','AR_ROWS_UPDATED');
960: arp_message.set_token('NUM_ROWS',to_char(l_count));
961: END IF;
962: EXCEPTION
963: WHEN OTHERS THEN
964: arp_message.set_line( 'update_term_templates');

Line 964: arp_message.set_line( 'update_term_templates');

960: arp_message.set_token('NUM_ROWS',to_char(l_count));
961: END IF;
962: EXCEPTION
963: WHEN OTHERS THEN
964: arp_message.set_line( 'update_term_templates');
965: RAISE;
966: END update_term_templates;
967:
968: /*===========================================================================+

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

1052:
1053: IF process_mode='LOCK' THEN
1054: NULL;
1055: ELSE
1056: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1057: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_PAYMENT_TERMS',FALSE);
1058: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1059: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1060:

Line 1057: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_PAYMENT_TERMS',FALSE);

1053: IF process_mode='LOCK' THEN
1054: NULL;
1055: ELSE
1056: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1057: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_PAYMENT_TERMS',FALSE);
1058: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1059: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1060:
1061: OPEN merged_records;

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

1142: END IF;
1143:
1144: END LOOP;
1145:
1146: arp_message.set_name('AR','AR_ROWS_UPDATED');
1147: arp_message.set_token('NUM_ROWS',to_char(l_count));
1148: END IF;
1149: EXCEPTION
1150: WHEN OTHERS THEN

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

1143:
1144: END LOOP;
1145:
1146: arp_message.set_name('AR','AR_ROWS_UPDATED');
1147: arp_message.set_token('NUM_ROWS',to_char(l_count));
1148: END IF;
1149: EXCEPTION
1150: WHEN OTHERS THEN
1151: arp_message.set_line( 'update_payment_terms');

Line 1151: arp_message.set_line( 'update_payment_terms');

1147: arp_message.set_token('NUM_ROWS',to_char(l_count));
1148: END IF;
1149: EXCEPTION
1150: WHEN OTHERS THEN
1151: arp_message.set_line( 'update_payment_terms');
1152: RAISE;
1153: END update_payment_terms;
1154:
1155: /*===========================================================================+

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

1237:
1238: IF process_mode='LOCK' THEN
1239: NULL;
1240: ELSE
1241: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1242: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_PAYMENT_ITEMS',FALSE);
1243: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1244: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1245:

Line 1242: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_PAYMENT_ITEMS',FALSE);

1238: IF process_mode='LOCK' THEN
1239: NULL;
1240: ELSE
1241: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1242: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_PAYMENT_ITEMS',FALSE);
1243: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1244: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1245:
1246: OPEN merged_records;

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

1328: END IF;
1329:
1330: END LOOP;
1331:
1332: arp_message.set_name('AR','AR_ROWS_UPDATED');
1333: arp_message.set_token('NUM_ROWS',to_char(l_count));
1334: END IF;
1335: EXCEPTION
1336: WHEN OTHERS THEN

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

1329:
1330: END LOOP;
1331:
1332: arp_message.set_name('AR','AR_ROWS_UPDATED');
1333: arp_message.set_token('NUM_ROWS',to_char(l_count));
1334: END IF;
1335: EXCEPTION
1336: WHEN OTHERS THEN
1337: arp_message.set_line( 'update_payment_items');

Line 1337: arp_message.set_line( 'update_payment_items');

1333: arp_message.set_token('NUM_ROWS',to_char(l_count));
1334: END IF;
1335: EXCEPTION
1336: WHEN OTHERS THEN
1337: arp_message.set_line( 'update_payment_items');
1338: RAISE;
1339: END update_payment_items;
1340:
1341: /*===========================================================================+

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

1412:
1413: IF process_mode='LOCK' THEN
1414: NULL;
1415: ELSE
1416: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1417: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_AGREEMENTS',FALSE);
1418: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1419: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1420:

Line 1417: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_AGREEMENTS',FALSE);

1413: IF process_mode='LOCK' THEN
1414: NULL;
1415: ELSE
1416: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1417: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_AGREEMENTS',FALSE);
1418: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1419: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1420:
1421: OPEN merged_records;

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

1495: END IF;
1496:
1497: END LOOP;
1498:
1499: arp_message.set_name('AR','AR_ROWS_UPDATED');
1500: arp_message.set_token('NUM_ROWS',to_char(l_count));
1501: END IF;
1502: EXCEPTION
1503: WHEN OTHERS THEN

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

1496:
1497: END LOOP;
1498:
1499: arp_message.set_name('AR','AR_ROWS_UPDATED');
1500: arp_message.set_token('NUM_ROWS',to_char(l_count));
1501: END IF;
1502: EXCEPTION
1503: WHEN OTHERS THEN
1504: arp_message.set_line( 'update_rec_agreements');

Line 1504: arp_message.set_line( 'update_rec_agreements');

1500: arp_message.set_token('NUM_ROWS',to_char(l_count));
1501: END IF;
1502: EXCEPTION
1503: WHEN OTHERS THEN
1504: arp_message.set_line( 'update_rec_agreements');
1505: RAISE;
1506: END update_rec_agreements;
1507:
1508: /*===========================================================================+

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

1571:
1572: IF process_mode='LOCK' THEN
1573: NULL;
1574: ELSE
1575: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1576: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_ARCL_DTLLN',FALSE);
1577: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1578: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1579:

Line 1576: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_ARCL_DTLLN',FALSE);

1572: IF process_mode='LOCK' THEN
1573: NULL;
1574: ELSE
1575: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1576: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_ARCL_DTLLN',FALSE);
1577: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1578: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1579:
1580: OPEN merged_records;

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

1647: END IF;
1648:
1649: END LOOP;
1650:
1651: arp_message.set_name('AR','AR_ROWS_UPDATED');
1652: arp_message.set_token('NUM_ROWS',to_char(l_count));
1653: END IF;
1654: EXCEPTION
1655: WHEN OTHERS THEN

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

1648:
1649: END LOOP;
1650:
1651: arp_message.set_name('AR','AR_ROWS_UPDATED');
1652: arp_message.set_token('NUM_ROWS',to_char(l_count));
1653: END IF;
1654: EXCEPTION
1655: WHEN OTHERS THEN
1656: arp_message.set_line( 'update_rec_arcl_dtln');

Line 1656: arp_message.set_line( 'update_rec_arcl_dtln');

1652: arp_message.set_token('NUM_ROWS',to_char(l_count));
1653: END IF;
1654: EXCEPTION
1655: WHEN OTHERS THEN
1656: arp_message.set_line( 'update_rec_arcl_dtln');
1657: RAISE;
1658: END update_rec_arcl_dtln;
1659:
1660: /*===========================================================================+

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

1722:
1723: IF process_mode='LOCK' THEN
1724: NULL;
1725: ELSE
1726: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1727: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_EXPCL_DTLLN',FALSE);
1728: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1729: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1730:

Line 1727: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_EXPCL_DTLLN',FALSE);

1723: IF process_mode='LOCK' THEN
1724: NULL;
1725: ELSE
1726: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1727: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_EXPCL_DTLLN',FALSE);
1728: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1729: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1730:
1731: OPEN merged_records;

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

1797: EXIT;
1798: END IF;
1799: END LOOP;
1800:
1801: arp_message.set_name('AR','AR_ROWS_UPDATED');
1802: arp_message.set_token('NUM_ROWS',to_char(l_count));
1803: END IF;
1804: EXCEPTION
1805: WHEN OTHERS THEN

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

1798: END IF;
1799: END LOOP;
1800:
1801: arp_message.set_name('AR','AR_ROWS_UPDATED');
1802: arp_message.set_token('NUM_ROWS',to_char(l_count));
1803: END IF;
1804: EXCEPTION
1805: WHEN OTHERS THEN
1806: arp_message.set_line( 'update_rec_expcl_dtln');

Line 1806: arp_message.set_line( 'update_rec_expcl_dtln');

1802: arp_message.set_token('NUM_ROWS',to_char(l_count));
1803: END IF;
1804: EXCEPTION
1805: WHEN OTHERS THEN
1806: arp_message.set_line( 'update_rec_expcl_dtln');
1807: RAISE;
1808: END update_rec_expcl_dtln;
1809:
1810: /*===========================================================================+

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

1872:
1873: IF process_mode='LOCK' THEN
1874: NULL;
1875: ELSE
1876: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1877: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_PERIOD_LINES',FALSE);
1878: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1879: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1880:

Line 1877: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_PERIOD_LINES',FALSE);

1873: IF process_mode='LOCK' THEN
1874: NULL;
1875: ELSE
1876: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1877: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_PERIOD_LINES',FALSE);
1878: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1879: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1880:
1881: OPEN merged_records;

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

1946: EXIT;
1947: END IF;
1948: END LOOP;
1949:
1950: arp_message.set_name('AR','AR_ROWS_UPDATED');
1951: arp_message.set_token('NUM_ROWS',to_char(l_count));
1952: END IF;
1953: EXCEPTION
1954: WHEN OTHERS THEN

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

1947: END IF;
1948: END LOOP;
1949:
1950: arp_message.set_name('AR','AR_ROWS_UPDATED');
1951: arp_message.set_token('NUM_ROWS',to_char(l_count));
1952: END IF;
1953: EXCEPTION
1954: WHEN OTHERS THEN
1955: arp_message.set_line( 'update_rec_period_lines');

Line 1955: arp_message.set_line( 'update_rec_period_lines');

1951: arp_message.set_token('NUM_ROWS',to_char(l_count));
1952: END IF;
1953: EXCEPTION
1954: WHEN OTHERS THEN
1955: arp_message.set_line( 'update_rec_period_lines');
1956: RAISE;
1957: END update_rec_period_lines;
1958:
1959: /*===========================================================================+

Line 2037: arp_message.set_name('AR','AR_UPDATING_TABLE');

2033:
2034: IF process_mode='LOCK' THEN
2035: NULL;
2036: ELSE
2037: arp_message.set_name('AR','AR_UPDATING_TABLE');
2038: arp_message.set_token('TABLE_NAME','PN_SPACE_ASSIGN_CUST',FALSE);
2039: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2040: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
2041:

Line 2038: arp_message.set_token('TABLE_NAME','PN_SPACE_ASSIGN_CUST',FALSE);

2034: IF process_mode='LOCK' THEN
2035: NULL;
2036: ELSE
2037: arp_message.set_name('AR','AR_UPDATING_TABLE');
2038: arp_message.set_token('TABLE_NAME','PN_SPACE_ASSIGN_CUST',FALSE);
2039: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2040: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
2041:
2042: OPEN merged_records;

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

2116: EXIT;
2117: END IF;
2118: END LOOP;
2119:
2120: arp_message.set_name('AR','AR_ROWS_UPDATED');
2121: arp_message.set_token('NUM_ROWS',to_char(l_count));
2122: END IF;
2123: EXCEPTION
2124: WHEN OTHERS THEN

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

2117: END IF;
2118: END LOOP;
2119:
2120: arp_message.set_name('AR','AR_ROWS_UPDATED');
2121: arp_message.set_token('NUM_ROWS',to_char(l_count));
2122: END IF;
2123: EXCEPTION
2124: WHEN OTHERS THEN
2125: arp_message.set_line( 'update_space_assign_cust');

Line 2125: arp_message.set_line( 'update_space_assign_cust');

2121: arp_message.set_token('NUM_ROWS',to_char(l_count));
2122: END IF;
2123: EXCEPTION
2124: WHEN OTHERS THEN
2125: arp_message.set_line( 'update_space_assign_cust');
2126: RAISE;
2127: END update_space_assign_cust;
2128:
2129: END PNP_CMERGE;