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.16 2010/11/18 06:53:53 vpusulur 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 1210: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment ()+');

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

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

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

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

1309:
1310:
1311: IF PG_DEBUG in ('Y', 'C') THEN
1312: arp_util.debug ( 'Adjustment ID : ' || l_new_adjust_id);
1313: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment ()-');
1314: END IF;
1315:
1316: EXCEPTION
1317: WHEN OTHERS THEN

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

1315:
1316: EXCEPTION
1317: WHEN OTHERS THEN
1318: IF PG_DEBUG in ('Y', 'C') THEN
1319: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment : ' || SQLERRM);
1320: arp_util.debug( 'p_adj_id : ' || p_adj_id);
1321: END IF;
1322: RAISE;
1323:

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

1360:
1361: BEGIN
1362:
1363: IF PG_DEBUG in ('Y', 'C') THEN
1364: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment ()+');
1365: END IF;
1366:
1367: /*------------------------------------------------------+
1368: | For each assignment, non accounting adjustment |

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

1433:
1434: END LOOP;
1435:
1436: IF PG_DEBUG in ('Y', 'C') THEN
1437: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment ()-');
1438: END IF;
1439:
1440: EXCEPTION
1441: WHEN OTHERS THEN

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

1439:
1440: EXCEPTION
1441: WHEN OTHERS THEN
1442: IF PG_DEBUG in ('Y', 'C') THEN
1443: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment () ');
1444: arp_util.debug('Reverse_Assignments_Adjustment: ' || 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);
1445: arp_util.debug('Reverse_Assignments_Adjustment: ' || 'p_acceptance_flag : ' || p_acceptance_flag);
1446: END IF;
1447: IF (assignment_cur%ISOPEN)

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

1470:
1471: BEGIN
1472:
1473: IF PG_DEBUG in ('Y', 'C') THEN
1474: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt ()+');
1475: END IF;
1476:
1477: SELECT cash_receipt_id
1478: INTO p_cash_receipt_id

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

1482: WHERE applied_customer_trx_id = p_customer_trx_id
1483: AND status = 'APP' );
1484:
1485: IF PG_DEBUG in ('Y', 'C') THEN
1486: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt ()-');
1487: END IF;
1488:
1489: EXCEPTION
1490: WHEN NO_DATA_FOUND THEN

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

1488:
1489: EXCEPTION
1490: WHEN NO_DATA_FOUND THEN
1491: IF PG_DEBUG in ('Y', 'C') THEN
1492: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt () ');
1493: arp_util.debug ('Find_Last_Receipt: ' || 'No receipt was found for the BR');
1494: END IF;
1495: RAISE;
1496:

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

1495: RAISE;
1496:
1497: WHEN OTHERS THEN
1498: IF PG_DEBUG in ('Y', 'C') THEN
1499: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt () ');
1500: arp_util.debug('Find_Last_Receipt: ' || 'p_customer_trx_id : ' || p_customer_trx_id);
1501: END IF;
1502: RAISE;
1503:

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

1534:
1535: BEGIN
1536:
1537: IF PG_DEBUG in ('Y', 'C') THEN
1538: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_STD ()+');
1539: END IF;
1540:
1541: /*-----------------------------------------------+
1542: | Fetch last Short Term Debt Application |

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

1560: CLOSE last_std_application_cur;
1561:
1562:
1563: IF PG_DEBUG in ('Y', 'C') THEN
1564: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_STD ()-');
1565: END IF;
1566:
1567: EXCEPTION
1568:

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

1567: EXCEPTION
1568:
1569: WHEN OTHERS THEN
1570: IF PG_DEBUG in ('Y', 'C') THEN
1571: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_STD : ' || SQLERRM);
1572: END IF;
1573: IF (last_std_application_cur%ISOPEN)
1574: THEN
1575: CLOSE last_std_application_cur;

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

1605:
1606: BEGIN
1607:
1608: IF PG_DEBUG in ('Y', 'C') THEN
1609: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt ()+');
1610: END IF;
1611:
1612: /* SSA change */
1613: l_org_id := p_trh_rec.org_id;

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

1616: p_return_status =>l_org_return_status);
1617:
1618: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1619:
1620: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_receipt : l_org_return_status <> SUCCESS');
1621: ELSE
1622: /*------------------------------------------------------+
1623: | Reverse a receipt using Receipt API |
1624: +-------------------------------------------------------*/

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

1677: END IF;
1678: END IF;
1679:
1680: IF PG_DEBUG in ('Y', 'C') THEN
1681: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt ()-');
1682: END IF;
1683:
1684: EXCEPTION
1685: WHEN OTHERS THEN

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

1683:
1684: EXCEPTION
1685: WHEN OTHERS THEN
1686: IF PG_DEBUG in ('Y', 'C') THEN
1687: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt : ' || SQLERRM);
1688: arp_util.debug ( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1689: arp_util.debug ( 'p_reversal_reason : ' || p_reversal_reason);
1690: arp_util.debug ( 'p_called_from : ' || p_called_from);
1691: END IF;

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

1719:
1720: BEGIN
1721:
1722: IF PG_DEBUG in ('Y', 'C') THEN
1723: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt ()+');
1724: END IF;
1725:
1726: /* SSA change */
1727: l_org_id := p_trh_rec.org_id;

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

1730: p_return_status =>l_org_return_status);
1731:
1732: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1733:
1734: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt : l_org_return_status <> SUCCESS');
1735: ELSE
1736:
1737: /*------------------------------------------------------+
1738: | Unapply a receipt using Receipt API |

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

1792: END IF;
1793:
1794:
1795: IF PG_DEBUG in ('Y', 'C') THEN
1796: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt ()-');
1797: END IF;
1798:
1799: EXCEPTION
1800: WHEN OTHERS THEN

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

1798:
1799: EXCEPTION
1800: WHEN OTHERS THEN
1801: IF PG_DEBUG in ('Y', 'C') THEN
1802: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt : ' || SQLERRM);
1803: arp_util.debug ( 'p_cash_receipt_id : ' || p_cash_receipt_id );
1804: arp_util.debug ( 'p_called_from : ' || p_called_from );
1805: arp_util.debug ( 'p_ps_id : ' || p_ps_id );
1806: arp_util.debug ( 'p_trh_rec.customer_trx_id : ' || p_trh_rec.customer_trx_id );

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

1845: l_org_id NUMBER;
1846: BEGIN
1847:
1848: IF PG_DEBUG in ('Y', 'C') THEN
1849: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD ()+');
1850: END IF;
1851:
1852:
1853: /* SSA change */

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

1857: p_return_status =>l_org_return_status);
1858:
1859: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1860:
1861: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD l_org_return_status <> SUCCESS');
1862: ELSE
1863:
1864: /*------------------------------------------------------+
1865: | Fetch the Cash Receipt Information |

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

1942: END IF;
1943:
1944:
1945: IF PG_DEBUG in ('Y', 'C') THEN
1946: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD ()-');
1947: END IF;
1948:
1949: EXCEPTION
1950: WHEN OTHERS THEN

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

1948:
1949: EXCEPTION
1950: WHEN OTHERS THEN
1951: IF PG_DEBUG in ('Y', 'C') THEN
1952: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD : ' || SQLERRM);
1953: END IF;
1954: RAISE;
1955:
1956: END Apply_STD;

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

1985:
1986: BEGIN
1987:
1988: IF PG_DEBUG in ('Y', 'C') THEN
1989: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD ()+');
1990: END IF;
1991:
1992: /* SSA change */
1993: l_org_id := p_trh_rec.org_id;

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

1996: p_return_status =>l_org_return_status);
1997:
1998: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1999:
2000: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD : l_org_return_status <> SUCCESS');
2001: ELSE
2002:
2003: /*-----------------------------------------------+
2004: | Fetch last Short Term Debt Application |

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

2056: END IF;
2057: END IF;
2058:
2059: IF PG_DEBUG in ('Y', 'C') THEN
2060: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD ()-');
2061: END IF;
2062:
2063: EXCEPTION
2064: WHEN OTHERS THEN

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

2062:
2063: EXCEPTION
2064: WHEN OTHERS THEN
2065: IF PG_DEBUG in ('Y', 'C') THEN
2066: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD : ' || SQLERRM);
2067: END IF;
2068: RAISE;
2069:
2070: END Unapply_STD;

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

2095:
2096: BEGIN
2097:
2098: IF PG_DEBUG in ('Y', 'C') THEN
2099: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unpaid ()+');
2100: END IF;
2101:
2102: -- Fetch the remittance method if it exists
2103:

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

2243: END IF;
2244:
2245:
2246: IF PG_DEBUG in ('Y', 'C') THEN
2247: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unpaid ()-');
2248: END IF;
2249:
2250: EXCEPTION
2251: WHEN OTHERS THEN

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

2249:
2250: EXCEPTION
2251: WHEN OTHERS THEN
2252: IF PG_DEBUG in ('Y', 'C') THEN
2253: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Unpaid () ');
2254: END IF;
2255: RAISE;
2256:
2257: END Unpaid;

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

2291:
2292: BEGIN
2293:
2294: IF PG_DEBUG in ('Y', 'C') THEN
2295: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse ()+');
2296: END IF;
2297:
2298:
2299: /* SSA change */

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

2303: p_return_status =>l_org_return_status);
2304:
2305: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2306:
2307: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse : l_org_return_status <> SUCCESS');
2308: ELSE
2309:
2310: /*-----------------------------------------------+
2311: | Check if the receipt number is inherited |

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

2426:
2427: END IF;
2428:
2429: IF PG_DEBUG in ('Y', 'C') THEN
2430: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse ()-');
2431: END IF;
2432:
2433: EXCEPTION
2434: WHEN OTHERS THEN

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

2432:
2433: EXCEPTION
2434: WHEN OTHERS THEN
2435: IF PG_DEBUG in ('Y', 'C') THEN
2436: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse : ' || SQLERRM);
2437: END IF;
2438: RAISE;
2439:
2440: END Factore_Recourse;

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

2469:
2470: BEGIN
2471:
2472: IF PG_DEBUG in ('Y', 'C') THEN
2473: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse ()+');
2474: END IF;
2475:
2476: /* SSA change */
2477: l_org_id := p_ps_rec.org_id;

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

2480: p_return_status =>l_org_return_status);
2481:
2482: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2483:
2484: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse : l_org_return_status <> SUCCESS');
2485: ELSE
2486:
2487: /*-----------------------------------------------+
2488: | Check if the receipt number is inherited |

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

2595: END IF;
2596:
2597:
2598: IF PG_DEBUG in ('Y', 'C') THEN
2599: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse ()-');
2600: END IF;
2601:
2602: EXCEPTION
2603: WHEN OTHERS THEN

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

2601:
2602: EXCEPTION
2603: WHEN OTHERS THEN
2604: IF PG_DEBUG in ('Y', 'C') THEN
2605: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse : ' || SQLERRM);
2606: END IF;
2607: RAISE;
2608:
2609: END Factore_Without_Recourse;

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

2635:
2636: BEGIN
2637:
2638: IF PG_DEBUG in ('Y', 'C') THEN
2639: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_Receipt ()+');
2640: END IF;
2641:
2642: /* SSA change */
2643: l_org_id := p_trh_rec.org_id;

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

2646: p_return_status =>l_org_return_status);
2647:
2648: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2649:
2650: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_receipt : l_org_return_status <> SUCCESS');
2651: ELSE
2652:
2653: /*----------------------------------------------+
2654: | Create normal application using Receipt API |

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

2715: END IF;
2716:
2717:
2718: IF PG_DEBUG in ('Y', 'C') THEN
2719: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_Receipt ()-');
2720: END IF;
2721:
2722: EXCEPTION
2723: WHEN OTHERS THEN

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

2721:
2722: EXCEPTION
2723: WHEN OTHERS THEN
2724: IF PG_DEBUG in ('Y', 'C') THEN
2725: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Apply_Receipt : ' || SQLERRM);
2726: END IF;
2727: RAISE;
2728:
2729: END Apply_Receipt;

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

2757:
2758: BEGIN
2759:
2760: IF PG_DEBUG in ('Y', 'C') THEN
2761: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Link_Application_History ()+');
2762: END IF;
2763:
2764: /*----------------------------------------------+
2765: | Fetch last Application |

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

2799: WHERE receivable_application_id = last_application_rec.receivable_application_id;
2800:
2801:
2802: IF PG_DEBUG in ('Y', 'C') THEN
2803: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Link_Application_History ()-');
2804: END IF;
2805:
2806: EXCEPTION
2807: WHEN OTHERS THEN

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

2805:
2806: EXCEPTION
2807: WHEN OTHERS THEN
2808: IF PG_DEBUG in ('Y', 'C') THEN
2809: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Link_Application_History : ' || SQLERRM);
2810: END IF;
2811: IF (last_application_cur%ISOPEN)
2812: THEN
2813: CLOSE last_application_cur;

Line 2820: END AR_BILLS_MAINTAIN_LIB_PVT ;

2816:
2817: END Link_Application_History;
2818:
2819:
2820: END AR_BILLS_MAINTAIN_LIB_PVT ;