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.AR_BILLS_MAINTAIN_LIB_PVT dependencies on AR_BILLS_MAINTAIN_LIB_PVT

Line 1: PACKAGE BODY AR_BILLS_MAINTAIN_LIB_PVT AS

1: PACKAGE BODY AR_BILLS_MAINTAIN_LIB_PVT AS
2: /* $Header: ARBRMALB.pls 120.14 2005/06/03 20:38:29 vcrisost ship $ */
3:
4:
5: /* =======================================================================

Line 109: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Get_Doc_Seq ()+');

105:
106: BEGIN
107:
108: IF PG_DEBUG in ('Y', 'C') THEN
109: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Get_Doc_Seq ()+');
110: END IF;
111:
112:
113: SELECT count(*)

Line 361: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Get_Doc_Seq ()-');

357:
358: END IF;
359:
360: IF PG_DEBUG in ('Y', 'C') THEN
361: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Get_Doc_Seq ()-');
362: END IF;
363:
364: EXCEPTION
365: WHEN OTHERS THEN

Line 394: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Set_API_Error ()+');

390: l_data varchar2(4000);
391: l_msg_index_out number;
392:
393: BEGIN
394: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Set_API_Error ()+');
395:
396: FND_MSG_PUB.Get (FND_MSG_PUB.G_FIRST, FND_API.G_TRUE, l_data, l_msg_index_out);
397: FND_MESSAGE.Set_Encoded (l_data);
398: app_exception.raise_exception;

Line 399: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Set_API_Error ()-');

395:
396: FND_MSG_PUB.Get (FND_MSG_PUB.G_FIRST, FND_API.G_TRUE, l_data, l_msg_index_out);
397: FND_MESSAGE.Set_Encoded (l_data);
398: app_exception.raise_exception;
399: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Set_API_Error ()-');
400:
401: EXCEPTION
402: WHEN OTHERS THEN
403: arp_util.debug('>>>>>>>>>> EXCEPTION : Set_API_Error () ');

Line 429: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Get_Remittance_Batch ()+');

425: l_nocopy_batch_id ar_batches.batch_id%TYPE;
426:
427: BEGIN
428: IF PG_DEBUG in ('Y', 'C') THEN
429: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Get_Remittance_Batch ()+');
430: END IF;
431:
432:
433: -- Get the remittance batch id in ra_customer_trx_id

Line 454: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Get_Remittance_Batch ()-');

450: IF PG_DEBUG in ('Y', 'C') THEN
451: arp_util.debug ( 'Remittance Batch ID : ' || p_batch_rec.batch_id);
452: arp_util.debug ( 'Remittance Method : ' || p_batch_rec.remit_method_code);
453: arp_util.debug ( 'With Recourse Flag : ' || p_batch_rec.with_recourse_flag);
454: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Get_Remittance_Batch ()-');
455: END IF;
456:
457: EXCEPTION
458: WHEN NO_DATA_FOUND THEN

Line 492: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Update_Reserved_Columns ()+ ');

488: l_ps_rec ar_payment_schedules%ROWTYPE;
489:
490: BEGIN
491: IF PG_DEBUG in ('Y', 'C') THEN
492: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Update_Reserved_Columns ()+ ');
493: END IF;
494:
495: arp_ps_pkg.lock_p(p_payment_schedule_id);
496:

Line 506: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Update_Reserved_Columns ()- ');

502:
503: arp_ps_pkg.update_p (l_ps_rec, l_ps_rec.payment_schedule_id);
504:
505: IF PG_DEBUG in ('Y', 'C') THEN
506: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Update_Reserved_Columns ()- ');
507: END IF;
508:
509: EXCEPTION
510: WHEN OTHERS THEN

Line 544: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates()+ ');

540:
541: BEGIN
542:
543: IF PG_DEBUG in ('Y', 'C') THEN
544: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates()+ ');
545: END IF;
546:
547: ---- Default the action date if NULL
548: IF (p_trx_date IS NULL) THEN

Line 570: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates()-');

566:
567: IF PG_DEBUG in ('Y', 'C') THEN
568: arp_util.debug( 'Default_gl_date Return_status : '||l_return_status);
569: arp_util.debug( 'GL Date defaulted : ' || p_gl_date);
570: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates()-');
571: END IF;
572:
573: EXCEPTION
574: WHEN OTHERS THEN

Line 622: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Complete_Or_Accept ()+');

618:
619: BEGIN
620:
621: IF PG_DEBUG in ('Y', 'C') THEN
622: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Complete_Or_Accept ()+');
623: END IF;
624:
625: /*----------------------------------------------+
626: | For each assignment, create a non accounting |

Line 707: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Complete_Or_Accept ()-');

703:
704: END LOOP;
705:
706: IF PG_DEBUG in ('Y', 'C') THEN
707: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Complete_Or_Accept ()-');
708: END IF;
709:
710: EXCEPTION
711: WHEN OTHERS THEN

Line 751: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Complete_Acc_Required ()+');

747:
748: BEGIN
749:
750: IF PG_DEBUG in ('Y', 'C') THEN
751: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Complete_Acc_Required ()+');
752: END IF;
753:
754: /*----------------------------------------------+
755: | For each assignment, update the reserved |

Line 764: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Complete_Acc_Required ()-');

760: update_reserved_columns (assignment_rec.br_ref_payment_schedule_id, 'TRANSACTION', p_customer_trx_id);
761: END LOOP;
762:
763: IF PG_DEBUG in ('Y', 'C') THEN
764: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Complete_Acc_Required ()-');
765: END IF;
766:
767: EXCEPTION
768: WHEN OTHERS THEN

Line 815: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment ()+');

811:
812: BEGIN
813:
814: IF PG_DEBUG in ('Y', 'C') THEN
815: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment ()+');
816: END IF;
817:
818: /* SSA change */
819: l_org_id := p_trh_rec.org_id;

Line 826: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Create_adjustment : l_org_return_status <> SUCCESS');

822: p_return_status =>l_org_return_status);
823:
824: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
825:
826: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Create_adjustment : l_org_return_status <> SUCCESS');
827: ELSE
828:
829: adj_rec.type := 'INVOICE' ;
830: adj_rec.payment_schedule_id := p_ps_rec.payment_schedule_id ;

Line 903: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment ()-');

899: END IF;
900:
901: IF PG_DEBUG in ('Y', 'C') THEN
902: arp_util.debug ( 'Adjustment ID created : ' || p_adj_id);
903: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment ()-');
904: END IF;
905:
906: EXCEPTION
907: WHEN OTHERS THEN

Line 940: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment ()+');

936:
937: BEGIN
938:
939: IF PG_DEBUG in ('Y', 'C') THEN
940: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment ()+');
941: END IF;
942:
943: SELECT max(adjustment_id)
944: INTO p_adj_id

Line 949: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment ()-');

945: FROM ar_adjustments
946: WHERE customer_trx_id = p_customer_trx_id;
947:
948: IF PG_DEBUG in ('Y', 'C') THEN
949: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment ()-');
950: END IF;
951:
952: EXCEPTION
953: WHEN NO_DATA_FOUND THEN

Line 961: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment () ');

957: RAISE;
958:
959: WHEN OTHERS THEN
960: IF PG_DEBUG in ('Y', 'C') THEN
961: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment () ');
962: arp_util.debug('Find_Last_Adjustment: ' || 'p_customer_trx_id : ' || p_customer_trx_id);
963: END IF;
964: RAISE;
965:

Line 995: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Approve_Adjustment ()+');

991:
992: BEGIN
993:
994: IF PG_DEBUG in ('Y', 'C') THEN
995: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Approve_Adjustment ()+');
996: END IF;
997:
998: /* SSA change */
999: select org_id

Line 1009: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Approve_Adjustment : l_org_return_status <> SUCCESS');

1005: p_return_status =>l_org_return_status);
1006:
1007: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1008:
1009: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Approve_Adjustment : l_org_return_status <> SUCCESS');
1010: ELSE
1011:
1012:
1013: IF PG_DEBUG in ('Y', 'C') THEN

Line 1060: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Approve_Adjustment ()-');

1056: END IF;
1057: END IF;
1058:
1059: IF PG_DEBUG in ('Y', 'C') THEN
1060: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Approve_Adjustment ()-');
1061: END IF;
1062:
1063: EXCEPTION
1064: WHEN OTHERS THEN

Line 1066: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Approve_Adjustment : ' || SQLERRM);

1062:
1063: EXCEPTION
1064: WHEN OTHERS THEN
1065: IF PG_DEBUG in ('Y', 'C') THEN
1066: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Approve_Adjustment : ' || SQLERRM);
1067: arp_util.debug( 'p_adj_id : ' || p_adj_id);
1068: END IF;
1069: RAISE;
1070:

Line 1099: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment ()+');

1095:
1096: BEGIN
1097:
1098: IF PG_DEBUG in ('Y', 'C') THEN
1099: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment ()+');
1100: END IF;
1101:
1102: /* SSA change */
1103: select org_id

Line 1113: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment : l_org_return_status <> SUCCESS');

1109: p_return_status =>l_org_return_status);
1110:
1111: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1112:
1113: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment : l_org_return_status <> SUCCESS');
1114: ELSE
1115:
1116: l_adj_rec.status := p_status;
1117:

Line 1165: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment ()-');

1161: END IF;
1162:
1163:
1164: IF PG_DEBUG in ('Y', 'C') THEN
1165: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment ()-');
1166: END IF;
1167:
1168: EXCEPTION
1169: WHEN OTHERS THEN

Line 1171: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment : ' || SQLERRM);

1167:
1168: EXCEPTION
1169: WHEN OTHERS THEN
1170: IF PG_DEBUG in ('Y', 'C') THEN
1171: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment : ' || SQLERRM);
1172: arp_util.debug( 'p_adj_id : ' || p_adj_id);
1173: arp_util.debug( 'p_status : ' || p_status);
1174: END IF;
1175: RAISE;

Line 1207: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment ()+');

1203:
1204: BEGIN
1205:
1206: IF PG_DEBUG in ('Y', 'C') THEN
1207: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment ()+');
1208: END IF;
1209:
1210: /* SSA change */
1211: l_org_id := p_trh_rec.org_id;

Line 1218: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment : l_org_return_status <> SUCCESS');

1214: p_return_status =>l_org_return_status);
1215:
1216: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1217:
1218: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment : l_org_return_status <> SUCCESS');
1219: ELSE
1220:
1221: IF PG_DEBUG in ('Y', 'C') THEN
1222: arp_util.debug( '--------------------------------------------------------------');

Line 1275: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment ()-');

1271: END IF;
1272:
1273: IF PG_DEBUG in ('Y', 'C') THEN
1274: arp_util.debug ( 'Adjustment ID : ' || l_new_adjust_id);
1275: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment ()-');
1276: END IF;
1277:
1278: EXCEPTION
1279: WHEN OTHERS THEN

Line 1281: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment : ' || SQLERRM);

1277:
1278: EXCEPTION
1279: WHEN OTHERS THEN
1280: IF PG_DEBUG in ('Y', 'C') THEN
1281: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment : ' || SQLERRM);
1282: arp_util.debug( 'p_adj_id : ' || p_adj_id);
1283: END IF;
1284: RAISE;
1285:

Line 1326: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment ()+');

1322:
1323: BEGIN
1324:
1325: IF PG_DEBUG in ('Y', 'C') THEN
1326: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment ()+');
1327: END IF;
1328:
1329: /*------------------------------------------------------+
1330: | For each assignment, non accounting adjustment |

Line 1399: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment ()-');

1395:
1396: END LOOP;
1397:
1398: IF PG_DEBUG in ('Y', 'C') THEN
1399: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment ()-');
1400: END IF;
1401:
1402: EXCEPTION
1403: WHEN OTHERS THEN

Line 1405: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment () ');

1401:
1402: EXCEPTION
1403: WHEN OTHERS THEN
1404: IF PG_DEBUG in ('Y', 'C') THEN
1405: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment () ');
1406: arp_util.debug('Reverse_Assignments_Adjustment: ' || 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);
1407: arp_util.debug('Reverse_Assignments_Adjustment: ' || 'p_acceptance_flag : ' || p_acceptance_flag);
1408: END IF;
1409: IF (assignment_cur%ISOPEN)

Line 1436: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt ()+');

1432:
1433: BEGIN
1434:
1435: IF PG_DEBUG in ('Y', 'C') THEN
1436: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt ()+');
1437: END IF;
1438:
1439: SELECT cash_receipt_id
1440: INTO p_cash_receipt_id

Line 1448: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt ()-');

1444: WHERE applied_customer_trx_id = p_customer_trx_id
1445: AND status = 'APP' );
1446:
1447: IF PG_DEBUG in ('Y', 'C') THEN
1448: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt ()-');
1449: END IF;
1450:
1451: EXCEPTION
1452: WHEN NO_DATA_FOUND THEN

Line 1454: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt () ');

1450:
1451: EXCEPTION
1452: WHEN NO_DATA_FOUND THEN
1453: IF PG_DEBUG in ('Y', 'C') THEN
1454: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt () ');
1455: arp_util.debug ('Find_Last_Receipt: ' || 'No receipt was found for the BR');
1456: END IF;
1457: RAISE;
1458:

Line 1461: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt () ');

1457: RAISE;
1458:
1459: WHEN OTHERS THEN
1460: IF PG_DEBUG in ('Y', 'C') THEN
1461: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt () ');
1462: arp_util.debug('Find_Last_Receipt: ' || 'p_customer_trx_id : ' || p_customer_trx_id);
1463: END IF;
1464: RAISE;
1465:

Line 1500: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_STD ()+');

1496:
1497: BEGIN
1498:
1499: IF PG_DEBUG in ('Y', 'C') THEN
1500: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_STD ()+');
1501: END IF;
1502:
1503: /*-----------------------------------------------+
1504: | Fetch last Short Term Debt Application |

Line 1526: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_STD ()-');

1522: CLOSE last_std_application_cur;
1523:
1524:
1525: IF PG_DEBUG in ('Y', 'C') THEN
1526: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_STD ()-');
1527: END IF;
1528:
1529: EXCEPTION
1530:

Line 1533: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_STD : ' || SQLERRM);

1529: EXCEPTION
1530:
1531: WHEN OTHERS THEN
1532: IF PG_DEBUG in ('Y', 'C') THEN
1533: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_STD : ' || SQLERRM);
1534: END IF;
1535: IF (last_std_application_cur%ISOPEN)
1536: THEN
1537: CLOSE last_std_application_cur;

Line 1571: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt ()+');

1567:
1568: BEGIN
1569:
1570: IF PG_DEBUG in ('Y', 'C') THEN
1571: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt ()+');
1572: END IF;
1573:
1574: /* SSA change */
1575: l_org_id := p_trh_rec.org_id;

Line 1582: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_receipt : l_org_return_status <> SUCCESS');

1578: p_return_status =>l_org_return_status);
1579:
1580: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1581:
1582: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_receipt : l_org_return_status <> SUCCESS');
1583: ELSE
1584: /*------------------------------------------------------+
1585: | Reverse a receipt using Receipt API |
1586: +-------------------------------------------------------*/

Line 1643: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt ()-');

1639: END IF;
1640: END IF;
1641:
1642: IF PG_DEBUG in ('Y', 'C') THEN
1643: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt ()-');
1644: END IF;
1645:
1646: EXCEPTION
1647: WHEN OTHERS THEN

Line 1649: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt : ' || SQLERRM);

1645:
1646: EXCEPTION
1647: WHEN OTHERS THEN
1648: IF PG_DEBUG in ('Y', 'C') THEN
1649: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt : ' || SQLERRM);
1650: arp_util.debug ( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1651: arp_util.debug ( 'p_reversal_reason : ' || p_reversal_reason);
1652: arp_util.debug ( 'p_called_from : ' || p_called_from);
1653: END IF;

Line 1685: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt ()+');

1681:
1682: BEGIN
1683:
1684: IF PG_DEBUG in ('Y', 'C') THEN
1685: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt ()+');
1686: END IF;
1687:
1688: /* SSA change */
1689: l_org_id := p_trh_rec.org_id;

Line 1696: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt : l_org_return_status <> SUCCESS');

1692: p_return_status =>l_org_return_status);
1693:
1694: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1695:
1696: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt : l_org_return_status <> SUCCESS');
1697: ELSE
1698:
1699: /*------------------------------------------------------+
1700: | Unapply a receipt using Receipt API |

Line 1758: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt ()-');

1754: END IF;
1755:
1756:
1757: IF PG_DEBUG in ('Y', 'C') THEN
1758: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt ()-');
1759: END IF;
1760:
1761: EXCEPTION
1762: WHEN OTHERS THEN

Line 1764: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt : ' || SQLERRM);

1760:
1761: EXCEPTION
1762: WHEN OTHERS THEN
1763: IF PG_DEBUG in ('Y', 'C') THEN
1764: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt : ' || SQLERRM);
1765: arp_util.debug ( 'p_cash_receipt_id : ' || p_cash_receipt_id );
1766: arp_util.debug ( 'p_called_from : ' || p_called_from );
1767: arp_util.debug ( 'p_ps_id : ' || p_ps_id );
1768: arp_util.debug ( 'p_trh_rec.customer_trx_id : ' || p_trh_rec.customer_trx_id );

Line 1811: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD ()+');

1807: l_org_id NUMBER;
1808: BEGIN
1809:
1810: IF PG_DEBUG in ('Y', 'C') THEN
1811: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD ()+');
1812: END IF;
1813:
1814:
1815: /* SSA change */

Line 1823: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD l_org_return_status <> SUCCESS');

1819: p_return_status =>l_org_return_status);
1820:
1821: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1822:
1823: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD l_org_return_status <> SUCCESS');
1824: ELSE
1825:
1826: /*------------------------------------------------------+
1827: | Fetch the Cash Receipt Information |

Line 1908: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD ()-');

1904: END IF;
1905:
1906:
1907: IF PG_DEBUG in ('Y', 'C') THEN
1908: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD ()-');
1909: END IF;
1910:
1911: EXCEPTION
1912: WHEN OTHERS THEN

Line 1914: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD : ' || SQLERRM);

1910:
1911: EXCEPTION
1912: WHEN OTHERS THEN
1913: IF PG_DEBUG in ('Y', 'C') THEN
1914: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD : ' || SQLERRM);
1915: END IF;
1916: RAISE;
1917:
1918: END Apply_STD;

Line 1951: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD ()+');

1947:
1948: BEGIN
1949:
1950: IF PG_DEBUG in ('Y', 'C') THEN
1951: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD ()+');
1952: END IF;
1953:
1954: /* SSA change */
1955: l_org_id := p_trh_rec.org_id;

Line 1962: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD : l_org_return_status <> SUCCESS');

1958: p_return_status =>l_org_return_status);
1959:
1960: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1961:
1962: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD : l_org_return_status <> SUCCESS');
1963: ELSE
1964:
1965: /*-----------------------------------------------+
1966: | Fetch last Short Term Debt Application |

Line 2022: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD ()-');

2018: END IF;
2019: END IF;
2020:
2021: IF PG_DEBUG in ('Y', 'C') THEN
2022: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD ()-');
2023: END IF;
2024:
2025: EXCEPTION
2026: WHEN OTHERS THEN

Line 2028: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD : ' || SQLERRM);

2024:
2025: EXCEPTION
2026: WHEN OTHERS THEN
2027: IF PG_DEBUG in ('Y', 'C') THEN
2028: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD : ' || SQLERRM);
2029: END IF;
2030: RAISE;
2031:
2032: END Unapply_STD;

Line 2061: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unpaid ()+');

2057:
2058: BEGIN
2059:
2060: IF PG_DEBUG in ('Y', 'C') THEN
2061: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unpaid ()+');
2062: END IF;
2063:
2064: -- Fetch the remittance method if it exists
2065:

Line 2209: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unpaid ()-');

2205: END IF;
2206:
2207:
2208: IF PG_DEBUG in ('Y', 'C') THEN
2209: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unpaid ()-');
2210: END IF;
2211:
2212: EXCEPTION
2213: WHEN OTHERS THEN

Line 2215: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Unpaid () ');

2211:
2212: EXCEPTION
2213: WHEN OTHERS THEN
2214: IF PG_DEBUG in ('Y', 'C') THEN
2215: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Unpaid () ');
2216: END IF;
2217: RAISE;
2218:
2219: END Unpaid;

Line 2257: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse ()+');

2253:
2254: BEGIN
2255:
2256: IF PG_DEBUG in ('Y', 'C') THEN
2257: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse ()+');
2258: END IF;
2259:
2260:
2261: /* SSA change */

Line 2269: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse : l_org_return_status <> SUCCESS');

2265: p_return_status =>l_org_return_status);
2266:
2267: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2268:
2269: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse : l_org_return_status <> SUCCESS');
2270: ELSE
2271:
2272: /*-----------------------------------------------+
2273: | Check if the receipt number is inherited |

Line 2392: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse ()-');

2388:
2389: END IF;
2390:
2391: IF PG_DEBUG in ('Y', 'C') THEN
2392: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse ()-');
2393: END IF;
2394:
2395: EXCEPTION
2396: WHEN OTHERS THEN

Line 2398: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse : ' || SQLERRM);

2394:
2395: EXCEPTION
2396: WHEN OTHERS THEN
2397: IF PG_DEBUG in ('Y', 'C') THEN
2398: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse : ' || SQLERRM);
2399: END IF;
2400: RAISE;
2401:
2402: END Factore_Recourse;

Line 2435: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse ()+');

2431:
2432: BEGIN
2433:
2434: IF PG_DEBUG in ('Y', 'C') THEN
2435: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse ()+');
2436: END IF;
2437:
2438: /* SSA change */
2439: l_org_id := p_ps_rec.org_id;

Line 2446: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse : l_org_return_status <> SUCCESS');

2442: p_return_status =>l_org_return_status);
2443:
2444: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2445:
2446: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse : l_org_return_status <> SUCCESS');
2447: ELSE
2448:
2449: /*-----------------------------------------------+
2450: | Check if the receipt number is inherited |

Line 2561: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse ()-');

2557: END IF;
2558:
2559:
2560: IF PG_DEBUG in ('Y', 'C') THEN
2561: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse ()-');
2562: END IF;
2563:
2564: EXCEPTION
2565: WHEN OTHERS THEN

Line 2567: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse : ' || SQLERRM);

2563:
2564: EXCEPTION
2565: WHEN OTHERS THEN
2566: IF PG_DEBUG in ('Y', 'C') THEN
2567: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse : ' || SQLERRM);
2568: END IF;
2569: RAISE;
2570:
2571: END Factore_Without_Recourse;

Line 2601: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_Receipt ()+');

2597:
2598: BEGIN
2599:
2600: IF PG_DEBUG in ('Y', 'C') THEN
2601: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_Receipt ()+');
2602: END IF;
2603:
2604: /* SSA change */
2605: l_org_id := p_trh_rec.org_id;

Line 2612: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_receipt : l_org_return_status <> SUCCESS');

2608: p_return_status =>l_org_return_status);
2609:
2610: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2611:
2612: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_receipt : l_org_return_status <> SUCCESS');
2613: ELSE
2614:
2615: /*----------------------------------------------+
2616: | Create normal application using Receipt API |

Line 2681: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_Receipt ()-');

2677: END IF;
2678:
2679:
2680: IF PG_DEBUG in ('Y', 'C') THEN
2681: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_Receipt ()-');
2682: END IF;
2683:
2684: EXCEPTION
2685: WHEN OTHERS THEN

Line 2687: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Apply_Receipt : ' || SQLERRM);

2683:
2684: EXCEPTION
2685: WHEN OTHERS THEN
2686: IF PG_DEBUG in ('Y', 'C') THEN
2687: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Apply_Receipt : ' || SQLERRM);
2688: END IF;
2689: RAISE;
2690:
2691: END Apply_Receipt;

Line 2723: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Link_Application_History ()+');

2719:
2720: BEGIN
2721:
2722: IF PG_DEBUG in ('Y', 'C') THEN
2723: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Link_Application_History ()+');
2724: END IF;
2725:
2726: /*----------------------------------------------+
2727: | Fetch last Application |

Line 2765: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Link_Application_History ()-');

2761: WHERE receivable_application_id = last_application_rec.receivable_application_id;
2762:
2763:
2764: IF PG_DEBUG in ('Y', 'C') THEN
2765: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Link_Application_History ()-');
2766: END IF;
2767:
2768: EXCEPTION
2769: WHEN OTHERS THEN

Line 2771: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Link_Application_History : ' || SQLERRM);

2767:
2768: EXCEPTION
2769: WHEN OTHERS THEN
2770: IF PG_DEBUG in ('Y', 'C') THEN
2771: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Link_Application_History : ' || SQLERRM);
2772: END IF;
2773: IF (last_application_cur%ISOPEN)
2774: THEN
2775: CLOSE last_application_cur;

Line 2782: END AR_BILLS_MAINTAIN_LIB_PVT ;

2778:
2779: END Link_Application_History;
2780:
2781:
2782: END AR_BILLS_MAINTAIN_LIB_PVT ;