eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_PROCESS_BR_REMIT dependencies on ARP_UTIL

Line 128: arp_util.debug('ARP_PROCESS_BR_REMIT.create_remit_batch (+)');

124:
125: BEGIN
126:
127: IF PG_DEBUG in ('Y', 'C') THEN
128: arp_util.debug('ARP_PROCESS_BR_REMIT.create_remit_batch (+)');
129: END IF;
130:
131: SAVEPOINT create_remit_batch_PVT;
132:

Line 263: arp_util.debug('create_remit_batch: ' || 'Commit -- Insertion du Batch '||l_batch_id||' status '||l_batch_applied_status);

259: l_batch_id,
260: l_batch_name,
261: l_batch_applied_status);
262: IF PG_DEBUG in ('Y', 'C') THEN
263: arp_util.debug('create_remit_batch: ' || 'Commit -- Insertion du Batch '||l_batch_id||' status '||l_batch_applied_status);
264: arp_util.debug('create_remit_batch: ' || 'NB selected BR :'|| TOTAL_COUNT);
265: arp_util.debug('create_remit_batch: ' || 'Remittance total amount :'|| TOTAL_AMOUNT);
266: END IF;
267: ELSE

Line 264: arp_util.debug('create_remit_batch: ' || 'NB selected BR :'|| TOTAL_COUNT);

260: l_batch_name,
261: l_batch_applied_status);
262: IF PG_DEBUG in ('Y', 'C') THEN
263: arp_util.debug('create_remit_batch: ' || 'Commit -- Insertion du Batch '||l_batch_id||' status '||l_batch_applied_status);
264: arp_util.debug('create_remit_batch: ' || 'NB selected BR :'|| TOTAL_COUNT);
265: arp_util.debug('create_remit_batch: ' || 'Remittance total amount :'|| TOTAL_AMOUNT);
266: END IF;
267: ELSE
268: -- NO BR have been selected -> the remittance batch row isn't inserted in the table AR_BATCHES

Line 265: arp_util.debug('create_remit_batch: ' || 'Remittance total amount :'|| TOTAL_AMOUNT);

261: l_batch_applied_status);
262: IF PG_DEBUG in ('Y', 'C') THEN
263: arp_util.debug('create_remit_batch: ' || 'Commit -- Insertion du Batch '||l_batch_id||' status '||l_batch_applied_status);
264: arp_util.debug('create_remit_batch: ' || 'NB selected BR :'|| TOTAL_COUNT);
265: arp_util.debug('create_remit_batch: ' || 'Remittance total amount :'|| TOTAL_AMOUNT);
266: END IF;
267: ELSE
268: -- NO BR have been selected -> the remittance batch row isn't inserted in the table AR_BATCHES
269: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_REMIT');

Line 282: arp_util.debug('ARP_PROCESS_BR_REMIT.create_remit_batch (-)');

278:
279: COMMIT;
280:
281: IF PG_DEBUG in ('Y', 'C') THEN
282: arp_util.debug('ARP_PROCESS_BR_REMIT.create_remit_batch (-)');
283: END IF;
284:
285:
286: EXCEPTION

Line 290: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR: ARP_PROCESS_BR_REMIT.create_remit_batch');

286: EXCEPTION
287:
288: WHEN FND_API.G_EXC_ERROR THEN
289: IF PG_DEBUG in ('Y', 'C') THEN
290: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR: ARP_PROCESS_BR_REMIT.create_remit_batch');
291: END IF;
292: ROLLBACK TO create_remit_batch_PVT;
293:
294: IF CUR_BR%ISOPEN THEN

Line 302: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROCESS_BR_REMIT.create_remit_batch');

298: x_return_status := FND_API.G_RET_STS_ERROR;
299:
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
301: IF PG_DEBUG in ('Y', 'C') THEN
302: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROCESS_BR_REMIT.create_remit_batch');
303: END IF;
304: ROLLBACK TO create_remit_batch_PVT;
305:
306: IF CUR_BR%ISOPEN THEN

Line 314: arp_util.debug('EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.create_remit_batch');

310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311:
312: WHEN OTHERS THEN
313: IF PG_DEBUG in ('Y', 'C') THEN
314: arp_util.debug('EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.create_remit_batch');
315: arp_util.debug('create_remit_batch: ' || SQLERRM);
316: END IF;
317: ROLLBACK TO create_remit_batch_PVT;
318:

Line 315: arp_util.debug('create_remit_batch: ' || SQLERRM);

311:
312: WHEN OTHERS THEN
313: IF PG_DEBUG in ('Y', 'C') THEN
314: arp_util.debug('EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.create_remit_batch');
315: arp_util.debug('create_remit_batch: ' || SQLERRM);
316: END IF;
317: ROLLBACK TO create_remit_batch_PVT;
318:
319: IF CUR_BR%ISOPEN THEN

Line 414: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.select_and_assign_br_to_remit (+)');

410:
411: BEGIN
412:
413: IF PG_DEBUG in ('Y', 'C') THEN
414: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.select_and_assign_br_to_remit (+)');
415: END IF;
416:
417: SAVEPOINT select_and_assign_PVT;
418:

Line 522: arp_util.debug('create_remit_batch: ' || 'BR Remittance number :'||l_batch_rec.name);

518: p_control_count := l_batch_rec.control_count;
519: p_control_amount := l_batch_rec.control_amount;
520:
521: IF PG_DEBUG in ('Y', 'C') THEN
522: arp_util.debug('create_remit_batch: ' || 'BR Remittance number :'||l_batch_rec.name);
523: arp_util.debug('create_remit_batch: ' || 'Count :'||l_control_count);
524: arp_util.debug('create_remit_batch: ' || 'Amount :'||l_control_amount);
525: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.select_and_assign_br_to_remit (+)');
526: END IF;

Line 523: arp_util.debug('create_remit_batch: ' || 'Count :'||l_control_count);

519: p_control_amount := l_batch_rec.control_amount;
520:
521: IF PG_DEBUG in ('Y', 'C') THEN
522: arp_util.debug('create_remit_batch: ' || 'BR Remittance number :'||l_batch_rec.name);
523: arp_util.debug('create_remit_batch: ' || 'Count :'||l_control_count);
524: arp_util.debug('create_remit_batch: ' || 'Amount :'||l_control_amount);
525: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.select_and_assign_br_to_remit (+)');
526: END IF;
527:

Line 524: arp_util.debug('create_remit_batch: ' || 'Amount :'||l_control_amount);

520:
521: IF PG_DEBUG in ('Y', 'C') THEN
522: arp_util.debug('create_remit_batch: ' || 'BR Remittance number :'||l_batch_rec.name);
523: arp_util.debug('create_remit_batch: ' || 'Count :'||l_control_count);
524: arp_util.debug('create_remit_batch: ' || 'Amount :'||l_control_amount);
525: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.select_and_assign_br_to_remit (+)');
526: END IF;
527:
528: EXCEPTION

Line 525: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.select_and_assign_br_to_remit (+)');

521: IF PG_DEBUG in ('Y', 'C') THEN
522: arp_util.debug('create_remit_batch: ' || 'BR Remittance number :'||l_batch_rec.name);
523: arp_util.debug('create_remit_batch: ' || 'Count :'||l_control_count);
524: arp_util.debug('create_remit_batch: ' || 'Amount :'||l_control_amount);
525: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.select_and_assign_br_to_remit (+)');
526: END IF;
527:
528: EXCEPTION
529: WHEN OTHERS THEN

Line 531: arp_util.debug('create_remit_batch: ' || 'EXCEPTION : ARP_PROGRAM_BR_REMIT.select_and_assign_br_to_remit - ROLLBACK');

527:
528: EXCEPTION
529: WHEN OTHERS THEN
530: IF PG_DEBUG in ('Y', 'C') THEN
531: arp_util.debug('create_remit_batch: ' || 'EXCEPTION : ARP_PROGRAM_BR_REMIT.select_and_assign_br_to_remit - ROLLBACK');
532: END IF;
533: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
534: ROLLBACK TO select_and_assign_PVT;
535: RAISE;

Line 598: arp_util.debug('create_remit_batch: ' || '-----------ARP_PROCESS_BR_REMIT.construct_select_br_for_remit (+)-------------');

594:
595: BEGIN
596:
597: IF PG_DEBUG in ('Y', 'C') THEN
598: arp_util.debug('create_remit_batch: ' || '-----------ARP_PROCESS_BR_REMIT.construct_select_br_for_remit (+)-------------');
599: END IF;
600:
601: /*-------------------------------------------------------------------------------------*/
602: /* clause Where set up */

Line 704: arp_util.debug('create_remit_batch: ' || 'Where clause completed.');

700: ''''||p_drawee_class3_code||''') ';
701: END IF;
702:
703: IF PG_DEBUG in ('Y', 'C') THEN
704: arp_util.debug('create_remit_batch: ' || 'Where clause completed.');
705: END IF;
706:
707:
708: /*-------------------------------------------------------------------------------------*/

Line 722: arp_util.debug('create_remit_batch: ' || 'Order by clause completed.');

718: l_order_clause := l_order_clause || ',' || p_drawee_sort_criteria || ' ' || p_drawee_order;
719: END IF;
720:
721: IF PG_DEBUG in ('Y', 'C') THEN
722: arp_util.debug('create_remit_batch: ' || 'Order by clause completed.');
723: END IF;
724:
725:
726: /*-------------------------------------------------------------------------------------*/

Line 747: arp_util.debug('create_remit_batch: ' || '-----------ARP_PROCESS_BR_REMIT.construct_select_br_for_remit (-)-------------');

743: l_where_clause ||
744: l_order_clause;
745:
746: IF PG_DEBUG in ('Y', 'C') THEN
747: arp_util.debug('create_remit_batch: ' || '-----------ARP_PROCESS_BR_REMIT.construct_select_br_for_remit (-)-------------');
748: END IF;
749:
750:
751: EXCEPTION

Line 754: arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.construct_select_br_for_remit ');

750:
751: EXCEPTION
752: WHEN OTHERS THEN
753: IF PG_DEBUG in ('Y', 'C') THEN
754: arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.construct_select_br_for_remit ');
755: END IF;
756: RAISE;
757:
758: END construct_select_br_for_remit;

Line 822: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.validate_br_search_criteria (+)');

818:
819: BEGIN
820:
821: IF PG_DEBUG in ('Y', 'C') THEN
822: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.validate_br_search_criteria (+)');
823: END IF;
824:
825: -- remittance total amount
826: IF (p_remit_total_low IS NULL) AND (p_remit_total_high IS NULL) THEN

Line 828: arp_util.debug('create_remit_batch: ' || 'p_remit_total_low and p_remit_total_high are NULL');

824:
825: -- remittance total amount
826: IF (p_remit_total_low IS NULL) AND (p_remit_total_high IS NULL) THEN
827: IF PG_DEBUG in ('Y', 'C') THEN
828: arp_util.debug('create_remit_batch: ' || 'p_remit_total_low and p_remit_total_high are NULL');
829: END IF;
830: ELSIF (p_remit_total_low IS NULL) OR
831: (p_remit_total_high IS NULL) OR
832: (p_remit_total_high < p_remit_total_low) THEN

Line 840: arp_util.debug('create_remit_batch: ' || 'p_maturity_date_low and p_maturity_date_high are NULL');

836:
837: -- maturity date
838: IF (p_maturity_date_low IS NULL) AND (p_maturity_date_high IS NULL) THEN
839: IF PG_DEBUG in ('Y', 'C') THEN
840: arp_util.debug('create_remit_batch: ' || 'p_maturity_date_low and p_maturity_date_high are NULL');
841: END IF;
842: ELSIF (p_maturity_date_low IS NULL) OR
843: (p_maturity_date_high IS NULL) OR
844: (p_maturity_date_high < p_maturity_date_low) THEN

Line 852: arp_util.debug('create_remit_batch: ' || 'p_br_number_low and p_br_number_high are NULL');

848:
849: -- BR number
850: IF (p_br_number_low IS NULL) AND (p_br_number_high IS NULL) THEN
851: IF PG_DEBUG in ('Y', 'C') THEN
852: arp_util.debug('create_remit_batch: ' || 'p_br_number_low and p_br_number_high are NULL');
853: END IF;
854: ELSIF (p_br_number_low IS NULL) OR
855: (p_br_number_high IS NULL) OR
856: (p_br_number_high < p_br_number_low) THEN

Line 864: arp_util.debug('create_remit_batch: ' || 'p_br_amount_low and p_br_amount_high are NULL');

860:
861: -- BR amount
862: IF (p_br_amount_low IS NULL) AND (p_br_amount_high IS NULL) THEN
863: IF PG_DEBUG in ('Y', 'C') THEN
864: arp_util.debug('create_remit_batch: ' || 'p_br_amount_low and p_br_amount_high are NULL');
865: END IF;
866: ELSIF (p_br_amount_low IS NULL) OR
867: (p_br_amount_high IS NULL) OR
868: (p_br_amount_high < p_br_amount_low) THEN

Line 876: arp_util.debug('create_remit_batch: ' || 'p_drawee_number_low and p_drawee_number_high are NULL');

872:
873: -- Drawee number
874: IF (p_drawee_number_low IS NULL) AND (p_drawee_number_high IS NULL) THEN
875: IF PG_DEBUG in ('Y', 'C') THEN
876: arp_util.debug('create_remit_batch: ' || 'p_drawee_number_low and p_drawee_number_high are NULL');
877: END IF;
878: ELSIF (p_drawee_number_low IS NULL) OR
879: (p_drawee_number_high IS NULL) OR
880: (p_drawee_number_high < p_drawee_number_low) THEN

Line 942: arp_util.debug('create_remit_batch: ' || 'p_br_sort_criteria is NULL');

938:
939: -- parameter BR sort criteria
940: IF p_br_sort_criteria IS NULL THEN
941: IF PG_DEBUG in ('Y', 'C') THEN
942: arp_util.debug('create_remit_batch: ' || 'p_br_sort_criteria is NULL');
943: END IF;
944: ELSIF p_br_sort_criteria NOT IN ('PS.TRX_NUMBER',
945: 'PS.AMOUNT_DUE_REMAINING',
946: 'TRX_TYPE.NAME') THEN

Line 957: arp_util.debug('create_remit_batch: ' || 'p_drawee_sort_criteria is NULL');

953:
954: -- parameter drawee sort criteria
955: IF p_drawee_sort_criteria IS NULL THEN
956: IF PG_DEBUG in ('Y', 'C') THEN
957: arp_util.debug('create_remit_batch: ' || 'p_drawee_sort_criteria is NULL');
958: END IF;
959:
960: /* Bug 3550612, should check for party_name and account_number instead of
961: Customer_name and Customer Number */

Line 976: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.validate_br_search_criteria (-)');

972: APP_EXCEPTION.raise_exception;
973: END IF;
974:
975: IF PG_DEBUG in ('Y', 'C') THEN
976: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.validate_br_search_criteria (-)');
977: END IF;
978:
979: EXCEPTION
980: WHEN OTHERS THEN

Line 982: arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.validate_br_search_criteria ');

978:
979: EXCEPTION
980: WHEN OTHERS THEN
981: IF PG_DEBUG in ('Y', 'C') THEN
982: arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.validate_br_search_criteria ');
983: END IF;
984: RAISE;
985:
986:

Line 1045: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.assign_br_to_remit(+)');

1041:
1042: BEGIN
1043:
1044: IF PG_DEBUG in ('Y', 'C') THEN
1045: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.assign_br_to_remit(+)');
1046: END IF;
1047:
1048: SAVEPOINT assign_br_to_remit_PVT;
1049:

Line 1071: arp_util.debug('create_remit_batch: ' || 'no limit for the remittance');

1067: TOTAL_AMOUNT := 0;
1068:
1069: IF (p_remit_total_high IS NULL) THEN
1070: IF PG_DEBUG in ('Y', 'C') THEN
1071: arp_util.debug('create_remit_batch: ' || 'no limit for the remittance');
1072: END IF;
1073: LOOP
1074: FETCH CUR_BR INTO l_ps_rec;
1075: EXIT WHEN CUR_BR%NOTFOUND;

Line 1077: arp_util.debug('create_remit_batch: ' || 'BR '||l_ps_rec.payment_schedule_id||' assign to the remittance '||p_batch_id);

1073: LOOP
1074: FETCH CUR_BR INTO l_ps_rec;
1075: EXIT WHEN CUR_BR%NOTFOUND;
1076: IF PG_DEBUG in ('Y', 'C') THEN
1077: arp_util.debug('create_remit_batch: ' || 'BR '||l_ps_rec.payment_schedule_id||' assign to the remittance '||p_batch_id);
1078: END IF;
1079: AR_BILLS_MAINTAIN_PUB.Select_BR_Remit(p_batch_id,l_ps_rec.payment_schedule_id,l_new_status);
1080: TOTAL_COUNT := TOTAL_COUNT + 1;
1081: TOTAL_AMOUNT := TOTAL_AMOUNT + NVL(l_ps_rec.amount_due_remaining,0);

Line 1085: arp_util.debug('create_remit_batch: ' || 'limit for the remittance '||p_remit_total_high);

1081: TOTAL_AMOUNT := TOTAL_AMOUNT + NVL(l_ps_rec.amount_due_remaining,0);
1082: END LOOP;
1083: ELSE
1084: IF PG_DEBUG in ('Y', 'C') THEN
1085: arp_util.debug('create_remit_batch: ' || 'limit for the remittance '||p_remit_total_high);
1086: END IF;
1087: LOOP
1088: FETCH CUR_BR INTO l_ps_rec;
1089: EXIT WHEN CUR_BR%NOTFOUND;

Line 1092: arp_util.debug('create_remit_batch: ' || 'BR '||l_ps_rec.payment_schedule_id||' assign to the remittance '||p_batch_id);

1088: FETCH CUR_BR INTO l_ps_rec;
1089: EXIT WHEN CUR_BR%NOTFOUND;
1090: IF (TOTAL_AMOUNT + NVL(l_ps_rec.amount_due_remaining,0) <= p_remit_total_high) THEN
1091: IF PG_DEBUG in ('Y', 'C') THEN
1092: arp_util.debug('create_remit_batch: ' || 'BR '||l_ps_rec.payment_schedule_id||' assign to the remittance '||p_batch_id);
1093: END IF;
1094: AR_BILLS_MAINTAIN_PUB.Select_BR_Remit(p_batch_id,l_ps_rec.payment_schedule_id,l_new_status);
1095: TOTAL_COUNT := TOTAL_COUNT + 1;
1096: TOTAL_AMOUNT := TOTAL_AMOUNT + NVL(l_ps_rec.amount_due_remaining,0);

Line 1104: arp_util.debug('create_remit_batch: ' || 'NB remitted BR :'|| TOTAL_COUNT);

1100:
1101: CLOSE CUR_BR;
1102:
1103: IF PG_DEBUG in ('Y', 'C') THEN
1104: arp_util.debug('create_remit_batch: ' || 'NB remitted BR :'|| TOTAL_COUNT);
1105: arp_util.debug('create_remit_batch: ' || 'Remittance total amount :'|| TOTAL_AMOUNT);
1106: END IF;
1107:
1108: p_control_count := TOTAL_COUNT;

Line 1105: arp_util.debug('create_remit_batch: ' || 'Remittance total amount :'|| TOTAL_AMOUNT);

1101: CLOSE CUR_BR;
1102:
1103: IF PG_DEBUG in ('Y', 'C') THEN
1104: arp_util.debug('create_remit_batch: ' || 'NB remitted BR :'|| TOTAL_COUNT);
1105: arp_util.debug('create_remit_batch: ' || 'Remittance total amount :'|| TOTAL_AMOUNT);
1106: END IF;
1107:
1108: p_control_count := TOTAL_COUNT;
1109: p_control_amount := TOTAL_AMOUNT;

Line 1112: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.assign_br_to_remit(-)');

1108: p_control_count := TOTAL_COUNT;
1109: p_control_amount := TOTAL_AMOUNT;
1110:
1111: IF PG_DEBUG in ('Y', 'C') THEN
1112: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.assign_br_to_remit(-)');
1113: END IF;
1114:
1115: EXCEPTION
1116: WHEN OTHERS THEN

Line 1118: arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.assign_br_to_remit');

1114:
1115: EXCEPTION
1116: WHEN OTHERS THEN
1117: IF PG_DEBUG in ('Y', 'C') THEN
1118: arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.assign_br_to_remit');
1119: END IF;
1120: ROLLBACK TO assign_br_to_remit_PVT;
1121:
1122: IF CUR_BR%ISOPEN THEN

Line 1183: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit(+)');

1179:
1180: BEGIN
1181:
1182: IF PG_DEBUG in ('Y', 'C') THEN
1183: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit(+)');
1184: END IF;
1185:
1186: SAVEPOINT add_or_rm_br_to_remit_PVT;
1187:

Line 1239: arp_util.debug('create_remit_batch: ' || 'Action Deselect - Remove the BR '||p_ps_id||' from its remittance');

1235: l_br_amount := l_ps_rec.amount_due_remaining;
1236:
1237: IF (p_action_flag = 'D') THEN
1238: IF PG_DEBUG in ('Y', 'C') THEN
1239: arp_util.debug('create_remit_batch: ' || 'Action Deselect - Remove the BR '||p_ps_id||' from its remittance');
1240: END IF;
1241: AR_BILLS_MAINTAIN_PUB.DeSelect_BR_Remit(p_ps_id,l_new_status);
1242: l_control_count := l_control_count - 1;
1243: l_control_amount := l_control_amount - l_br_amount;

Line 1246: arp_util.debug('create_remit_batch: ' || 'Action Erase - Remove the BR '||p_ps_id||' from its remittance');

1242: l_control_count := l_control_count - 1;
1243: l_control_amount := l_control_amount - l_br_amount;
1244: ELSIF (p_action_flag = 'E') THEN
1245: IF PG_DEBUG in ('Y', 'C') THEN
1246: arp_util.debug('create_remit_batch: ' || 'Action Erase - Remove the BR '||p_ps_id||' from its remittance');
1247: END IF;
1248: AR_BILLS_MAINTAIN_PUB.cancel_br_remit(p_ps_id);
1249: l_control_count := l_control_count - 1;
1250: l_control_amount := l_control_amount - l_br_amount;

Line 1253: arp_util.debug('create_remit_batch: ' || 'Action Select - BR '||l_ps_rec.payment_schedule_id||' assign to the remittance '||p_batch_id);

1249: l_control_count := l_control_count - 1;
1250: l_control_amount := l_control_amount - l_br_amount;
1251: ELSE
1252: IF PG_DEBUG in ('Y', 'C') THEN
1253: arp_util.debug('create_remit_batch: ' || 'Action Select - BR '||l_ps_rec.payment_schedule_id||' assign to the remittance '||p_batch_id);
1254: END IF;
1255: AR_BILLS_MAINTAIN_PUB.Select_BR_Remit(p_batch_id,p_ps_id,l_new_status);
1256: l_control_count := l_control_count + 1;
1257: l_control_amount := l_control_amount + l_br_amount;

Line 1267: arp_util.debug('create_remit_batch: ' || 'commit');

1263: arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);
1264:
1265: IF FND_API.To_Boolean(p_commit) THEN
1266: IF PG_DEBUG in ('Y', 'C') THEN
1267: arp_util.debug('create_remit_batch: ' || 'commit');
1268: END IF;
1269: COMMIT;
1270: END IF;
1271:

Line 1276: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit(-)');

1272: p_control_count := l_control_count;
1273: p_control_amount := l_control_amount;
1274:
1275: IF PG_DEBUG in ('Y', 'C') THEN
1276: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit(-)');
1277: END IF;
1278:
1279: EXCEPTION
1280: WHEN FND_API.G_EXC_ERROR THEN

Line 1282: arp_util.debug('create_remit_batch: ' || 'EXCEPTION FND_API.G_EXC_ERROR: ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit');

1278:
1279: EXCEPTION
1280: WHEN FND_API.G_EXC_ERROR THEN
1281: IF PG_DEBUG in ('Y', 'C') THEN
1282: arp_util.debug('create_remit_batch: ' || 'EXCEPTION FND_API.G_EXC_ERROR: ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit');
1283: END IF;
1284: x_return_status := FND_API.G_RET_STS_ERROR;
1285: ROLLBACK TO add_or_rm_br_to_remit_PVT;
1286:

Line 1289: arp_util.debug('create_remit_batch: ' || 'EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit');

1285: ROLLBACK TO add_or_rm_br_to_remit_PVT;
1286:
1287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1288: IF PG_DEBUG in ('Y', 'C') THEN
1289: arp_util.debug('create_remit_batch: ' || 'EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit');
1290: END IF;
1291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1292: ROLLBACK TO add_or_rm_br_to_remit_PVT;
1293:

Line 1296: arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit');

1292: ROLLBACK TO add_or_rm_br_to_remit_PVT;
1293:
1294: WHEN OTHERS THEN
1295: IF PG_DEBUG in ('Y', 'C') THEN
1296: arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit');
1297: arp_util.debug('create_remit_batch: ' || SQLERRM);
1298: END IF;
1299: ROLLBACK TO add_or_rm_br_to_remit_PVT;
1300: IF (SQLCODE = -20001) THEN

Line 1297: arp_util.debug('create_remit_batch: ' || SQLERRM);

1293:
1294: WHEN OTHERS THEN
1295: IF PG_DEBUG in ('Y', 'C') THEN
1296: arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit');
1297: arp_util.debug('create_remit_batch: ' || SQLERRM);
1298: END IF;
1299: ROLLBACK TO add_or_rm_br_to_remit_PVT;
1300: IF (SQLCODE = -20001) THEN
1301: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1403: arp_util.debug('ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req (+)');

1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: END IF;
1401:
1402: IF PG_DEBUG in ('Y', 'C') THEN
1403: arp_util.debug('ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req (+)');
1404: END IF;
1405:
1406: x_return_status := FND_API.G_RET_STS_SUCCESS;
1407:

Line 1517: arp_util.debug('create_remit_batch: ' || 'Submitted Request - '||l_program||'. Request ID ='||to_char(l_request_id));

1513: FND_MESSAGE.set_token('PROCEDURE','ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');
1514: APP_EXCEPTION.raise_exception;
1515: ELSE
1516: IF PG_DEBUG in ('Y', 'C') THEN
1517: arp_util.debug('create_remit_batch: ' || 'Submitted Request - '||l_program||'. Request ID ='||to_char(l_request_id));
1518: END IF;
1519: END IF;
1520:
1521: p_control_count := l_batch_rec.control_count;

Line 1533: arp_util.debug('ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req (-)');

1529:
1530: COMMIT;
1531:
1532: IF PG_DEBUG in ('Y', 'C') THEN
1533: arp_util.debug('ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req (-)');
1534: END IF;
1535:
1536: EXCEPTION
1537: WHEN FND_API.G_EXC_ERROR THEN

Line 1539: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR: ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');

1535:
1536: EXCEPTION
1537: WHEN FND_API.G_EXC_ERROR THEN
1538: IF PG_DEBUG in ('Y', 'C') THEN
1539: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR: ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');
1540: END IF;
1541: x_return_status := FND_API.G_RET_STS_ERROR;
1542: ROLLBACK TO create_conc_req_PVT;
1543:

Line 1546: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');

1542: ROLLBACK TO create_conc_req_PVT;
1543:
1544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1545: IF PG_DEBUG in ('Y', 'C') THEN
1546: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');
1547: END IF;
1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1549: ROLLBACK TO create_conc_req_PVT;
1550:

Line 1553: arp_util.debug('EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');

1549: ROLLBACK TO create_conc_req_PVT;
1550:
1551: WHEN OTHERS THEN
1552: IF PG_DEBUG in ('Y', 'C') THEN
1553: arp_util.debug('EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');
1554: arp_util.debug('create_remit_batch: ' || SQLERRM);
1555: END IF;
1556: ROLLBACK TO create_conc_req_PVT;
1557: IF (SQLCODE = -20001) THEN

Line 1554: arp_util.debug('create_remit_batch: ' || SQLERRM);

1550:
1551: WHEN OTHERS THEN
1552: IF PG_DEBUG in ('Y', 'C') THEN
1553: arp_util.debug('EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');
1554: arp_util.debug('create_remit_batch: ' || SQLERRM);
1555: END IF;
1556: ROLLBACK TO create_conc_req_PVT;
1557: IF (SQLCODE = -20001) THEN
1558: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1626: arp_util.debug('ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req (+)');

1622: l_org_id number;
1623: BEGIN
1624:
1625: IF PG_DEBUG in ('Y', 'C') THEN
1626: arp_util.debug('ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req (+)');
1627: END IF;
1628:
1629: SAVEPOINT maintain_conc_req_PVT;
1630:

Line 1751: arp_util.debug('maintain_remit_batch_conc_req: ' || 'Submitted Request - '||l_program||'. Request ID ='||to_char(l_request_id));

1747: FND_MESSAGE.set_token('PROCEDURE','ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');
1748: APP_EXCEPTION.raise_exception;
1749: ELSE
1750: IF PG_DEBUG in ('Y', 'C') THEN
1751: arp_util.debug('maintain_remit_batch_conc_req: ' || 'Submitted Request - '||l_program||'. Request ID ='||to_char(l_request_id));
1752: END IF;
1753: END IF;
1754:
1755: -- Update the batch row with the request id and the batch applied status

Line 1776: arp_util.debug('ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req (-)');

1772:
1773: COMMIT;
1774:
1775: IF PG_DEBUG in ('Y', 'C') THEN
1776: arp_util.debug('ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req (-)');
1777: END IF;
1778:
1779: EXCEPTION
1780: WHEN FND_API.G_EXC_ERROR THEN

Line 1782: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR: ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');

1778:
1779: EXCEPTION
1780: WHEN FND_API.G_EXC_ERROR THEN
1781: IF PG_DEBUG in ('Y', 'C') THEN
1782: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR: ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');
1783: END IF;
1784: x_return_status := FND_API.G_RET_STS_ERROR;
1785: ROLLBACK TO maintain_conc_req_PVT;
1786:

Line 1789: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');

1785: ROLLBACK TO maintain_conc_req_PVT;
1786:
1787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1788: IF PG_DEBUG in ('Y', 'C') THEN
1789: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');
1790: END IF;
1791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1792: ROLLBACK TO maintain_conc_req_PVT;
1793:

Line 1796: arp_util.debug('EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');

1792: ROLLBACK TO maintain_conc_req_PVT;
1793:
1794: WHEN OTHERS THEN
1795: IF PG_DEBUG in ('Y', 'C') THEN
1796: arp_util.debug('EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');
1797: arp_util.debug('maintain_remit_batch_conc_req: ' || SQLERRM);
1798: END IF;
1799: ROLLBACK TO maintain_conc_req_PVT;
1800: IF (SQLCODE = -20001) THEN

Line 1797: arp_util.debug('maintain_remit_batch_conc_req: ' || SQLERRM);

1793:
1794: WHEN OTHERS THEN
1795: IF PG_DEBUG in ('Y', 'C') THEN
1796: arp_util.debug('EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');
1797: arp_util.debug('maintain_remit_batch_conc_req: ' || SQLERRM);
1798: END IF;
1799: ROLLBACK TO maintain_conc_req_PVT;
1800: IF (SQLCODE = -20001) THEN
1801: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1851: arp_util.debug('ARP_PROCESS_BR_REMIT.update_batch_status (+)');

1847:
1848: BEGIN
1849:
1850: IF PG_DEBUG in ('Y', 'C') THEN
1851: arp_util.debug('ARP_PROCESS_BR_REMIT.update_batch_status (+)');
1852: END IF;
1853:
1854: SAVEPOINT update_batch_status_PVT;
1855:

Line 1883: arp_util.debug('ARP_PROCESS_BR_REMIT.update_batch_status (-)');

1879:
1880: commit;
1881:
1882: IF PG_DEBUG in ('Y', 'C') THEN
1883: arp_util.debug('ARP_PROCESS_BR_REMIT.update_batch_status (-)');
1884: END IF;
1885:
1886: EXCEPTION
1887: WHEN FND_API.G_EXC_ERROR THEN

Line 1889: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_PROCESS_BR_REMIT.update_batch_status');

1885:
1886: EXCEPTION
1887: WHEN FND_API.G_EXC_ERROR THEN
1888: IF PG_DEBUG in ('Y', 'C') THEN
1889: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_PROCESS_BR_REMIT.update_batch_status');
1890: END IF;
1891: x_return_status := FND_API.G_RET_STS_ERROR;
1892: ROLLBACK TO update_batch_status_PVT;
1893:

Line 1896: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_PROCESS_BR_REMIT.update_batch_status');

1892: ROLLBACK TO update_batch_status_PVT;
1893:
1894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1895: IF PG_DEBUG in ('Y', 'C') THEN
1896: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_PROCESS_BR_REMIT.update_batch_status');
1897: END IF;
1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1899: ROLLBACK TO update_batch_status_PVT;
1900:

Line 1903: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_PROCESS_BR_REMIT.update_batch_status');

1899: ROLLBACK TO update_batch_status_PVT;
1900:
1901: WHEN OTHERS THEN
1902: IF PG_DEBUG in ('Y', 'C') THEN
1903: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_PROCESS_BR_REMIT.update_batch_status');
1904: arp_util.debug('update_batch_status: ' || SQLERRM);
1905: END IF;
1906: ROLLBACK TO update_batch_status_PVT;
1907: IF (SQLCODE = -20001) THEN

Line 1904: arp_util.debug('update_batch_status: ' || SQLERRM);

1900:
1901: WHEN OTHERS THEN
1902: IF PG_DEBUG in ('Y', 'C') THEN
1903: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_PROCESS_BR_REMIT.update_batch_status');
1904: arp_util.debug('update_batch_status: ' || SQLERRM);
1905: END IF;
1906: ROLLBACK TO update_batch_status_PVT;
1907: IF (SQLCODE = -20001) THEN
1908: x_return_status := FND_API.G_RET_STS_ERROR;