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_BILLS_RECEIVABLE_MAIN dependencies on STANDARD

Line 144: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Delete_Acct()+');

140:
141:
142: BEGIN
143: IF PG_DEBUG in ('Y', 'C') THEN
144: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Delete_Acct()+');
145: END IF;
146:
147: /*----------------------------------------------------+
148: | Copy Document/Event Data to Global |

Line 161: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Delete_Acct()-');

157:
158: END IF;
159:
160: IF PG_DEBUG in ('Y', 'C') THEN
161: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Delete_Acct()-');
162: END IF;
163:
164: EXCEPTION
165: WHEN OTHERS THEN

Line 167: arp_standard.debug( 'EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.Delete_Acct');

163:
164: EXCEPTION
165: WHEN OTHERS THEN
166: IF PG_DEBUG in ('Y', 'C') THEN
167: arp_standard.debug( 'EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.Delete_Acct');
168: END IF;
169: RAISE;
170:
171: END Delete_Acct;

Line 206: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Execute()+');

202:
203:
204: BEGIN
205: IF PG_DEBUG in ('Y', 'C') THEN
206: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Execute()+');
207: END IF;
208: /*------------------------------------------------------+
209: | Initialize Accounting Entry Header and Lines |
210: +------------------------------------------------------*/

Line 248: arp_standard.debug( 'bills receivable... p_ea_created = TRUE');

244:
245: IF g_ae_line_tbl.EXISTS(g_ae_line_ctr) THEN
246:
247: IF PG_DEBUG in ('Y', 'C') THEN
248: arp_standard.debug( 'bills receivable... p_ea_created = TRUE');
249: END IF;
250: p_ae_created := TRUE;
251:
252: ELSE

Line 255: arp_standard.debug( 'bills receivable... p_ea_created = FALSE');

251:
252: ELSE
253:
254: IF PG_DEBUG in ('Y', 'C') THEN
255: arp_standard.debug( 'bills receivable... p_ea_created = FALSE');
256: END IF;
257: p_ae_created := FALSE;
258:
259: END IF;

Line 262: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Execute()-');

258:
259: END IF;
260:
261: IF PG_DEBUG in ('Y', 'C') THEN
262: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Execute()-');
263: END IF;
264:
265: EXCEPTION
266: WHEN NO_DATA_FOUND THEN

Line 268: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Execute - NO_DATA_FOUND' );

264:
265: EXCEPTION
266: WHEN NO_DATA_FOUND THEN
267: IF PG_DEBUG in ('Y', 'C') THEN
268: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Execute - NO_DATA_FOUND' );
269: END IF;
270: RAISE;
271:
272: WHEN OTHERS THEN

Line 274: arp_standard.debug( 'EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.Execute');

270: RAISE;
271:
272: WHEN OTHERS THEN
273: IF PG_DEBUG in ('Y', 'C') THEN
274: arp_standard.debug( 'EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.Execute');
275: END IF;
276: RAISE;
277:
278: END Execute;

Line 296: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Init_Ae_Lines()+');

292:
293: BEGIN
294:
295: IF PG_DEBUG in ('Y', 'C') THEN
296: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Init_Ae_Lines()+');
297: END IF;
298:
299: g_ae_line_tbl := g_empty_ae_line_tbl;
300:

Line 302: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Init_Ae_Lines()-');

298:
299: g_ae_line_tbl := g_empty_ae_line_tbl;
300:
301: IF PG_DEBUG in ('Y', 'C') THEN
302: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Init_Ae_Lines()-');
303: END IF;
304: EXCEPTION
305:
306: WHEN OTHERS THEN

Line 308: arp_standard.debug( 'EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.Init_Ae_Lines');

304: EXCEPTION
305:
306: WHEN OTHERS THEN
307: IF PG_DEBUG in ('Y', 'C') THEN
308: arp_standard.debug( 'EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.Init_Ae_Lines');
309: END IF;
310: RAISE;
311:
312: END Init_Ae_Lines;

Line 330: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Derive_Accounting_Entry()+');

326: PROCEDURE Derive_Accounting_Entry IS
327:
328: BEGIN
329: IF PG_DEBUG in ('Y', 'C') THEN
330: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Derive_Accounting_Entry()+');
331: END IF;
332:
333: /*------------------------------------------------------------+
334: | Create Accounting Entries at the Document Entity level. |

Line 368: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Derive_Accounting_Entry()-');

364:
365: END IF; -- accounting_entity_level = ALL?
366:
367: IF PG_DEBUG in ('Y', 'C') THEN
368: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Derive_Accounting_Entry()-');
369: END IF;
370:
371: EXCEPTION
372: WHEN OTHERS THEN

Line 374: arp_standard.debug( 'EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.Derive_Accounting_Entry');

370:
371: EXCEPTION
372: WHEN OTHERS THEN
373: IF PG_DEBUG in ('Y', 'C') THEN
374: arp_standard.debug( 'EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.Derive_Accounting_Entry');
375: END IF;
376: RAISE;
377: END Derive_Accounting_Entry;
378:

Line 407: arp_standard.debug('ARP_BILLS_RECEIVABLE_MAIN.Delete_TH()+');

403: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
404:
405: BEGIN
406: IF PG_DEBUG in ('Y', 'C') THEN
407: arp_standard.debug('ARP_BILLS_RECEIVABLE_MAIN.Delete_TH()+');
408: END IF;
409:
410: /*-------------------------------------------------------------------+
411: | Verify that the source id is a valid candidate for deletion |

Line 446: arp_standard.debug('ARP_BILLS_RECEIVABLE_MAIN.Delete_TH()-');

442: -- p_key_value_list => l_ar_dist_key_value_list);
443: --}
444:
445: IF PG_DEBUG in ('Y', 'C') THEN
446: arp_standard.debug('ARP_BILLS_RECEIVABLE_MAIN.Delete_TH()-');
447: END IF;
448:
449: EXCEPTION
450: WHEN NO_DATA_FOUND THEN

Line 452: arp_standard.debug('ARP_BILLS_RECEIVABLE_MAIN.Delete_TH - NO_DATA_FOUND' );

448:
449: EXCEPTION
450: WHEN NO_DATA_FOUND THEN
451: IF PG_DEBUG in ('Y', 'C') THEN
452: arp_standard.debug('ARP_BILLS_RECEIVABLE_MAIN.Delete_TH - NO_DATA_FOUND' );
453: END IF;
454: p_ae_deleted := FALSE;
455: RAISE;
456:

Line 459: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.Delete_TH');

455: RAISE;
456:
457: WHEN OTHERS THEN
458: IF PG_DEBUG in ('Y', 'C') THEN
459: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.Delete_TH');
460: END IF;
461: p_ae_deleted := FALSE;
462: RAISE ;
463:

Line 585: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Reverse_BR()+');

581: l_ard_rec ar_distributions%ROWTYPE;
582:
583: BEGIN
584:
585: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Reverse_BR()+');
586: --{HYUDETUPT change the structure of this code so that it does not break everytime schema changes
587:
588: OPEN get_old_ard;
589: LOOP

Line 639: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Reverse_BR()-');

635:
636: END LOOP;
637: CLOSE get_old_ard;
638: --}
639: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Reverse_BR()-');
640:
641: EXCEPTION
642: WHEN NO_DATA_FOUND THEN
643: arp_standard.debug('ARP_BILLS_RECEIVABLE_MAIN.Reverse_BR - NO_DATA_FOUND' );

Line 643: arp_standard.debug('ARP_BILLS_RECEIVABLE_MAIN.Reverse_BR - NO_DATA_FOUND' );

639: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Reverse_BR()-');
640:
641: EXCEPTION
642: WHEN NO_DATA_FOUND THEN
643: arp_standard.debug('ARP_BILLS_RECEIVABLE_MAIN.Reverse_BR - NO_DATA_FOUND' );
644: RAISE;
645:
646: WHEN OTHERS THEN
647: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.Reverse_BR');

Line 647: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.Reverse_BR');

643: arp_standard.debug('ARP_BILLS_RECEIVABLE_MAIN.Reverse_BR - NO_DATA_FOUND' );
644: RAISE;
645:
646: WHEN OTHERS THEN
647: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.Reverse_BR');
648: RAISE ;
649:
650: END Reverse_BR;
651:

Line 678: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Get_Doc_Entitity_Data()+');

674:
675: BEGIN
676:
677: IF PG_DEBUG in ('Y', 'C') THEN
678: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Get_Doc_Entitity_Data()+');
679: END IF;
680:
681: /*----------------------------------------------------------------------------+
682: | Retrieve the data required for accounting for a bills receivable document |

Line 819: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Get_Doc_Entitity_Data()-');

815:
816: initialize_global_variables(p_trh_rec);
817:
818: IF PG_DEBUG in ('Y', 'C') THEN
819: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Get_Doc_Entitity_Data()-');
820: END IF;
821:
822: EXCEPTION
823: WHEN NO_DATA_FOUND THEN

Line 825: arp_standard.debug('ARP_BILLS_RECEIVABLE_MAIN.Get_Doc_Entitity_Data - NO_DATA_FOUND' );

821:
822: EXCEPTION
823: WHEN NO_DATA_FOUND THEN
824: IF PG_DEBUG in ('Y', 'C') THEN
825: arp_standard.debug('ARP_BILLS_RECEIVABLE_MAIN.Get_Doc_Entitity_Data - NO_DATA_FOUND' );
826: END IF;
827: RAISE;
828:
829: WHEN OTHERS THEN

Line 831: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.Get_Doc_Entitity_Data');

827: RAISE;
828:
829: WHEN OTHERS THEN
830: IF PG_DEBUG in ('Y', 'C') THEN
831: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.Get_Doc_Entitity_Data');
832: END IF;
833: RAISE ;
834:
835: END Get_Doc_Entitity_Data;

Line 863: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Create_Ae_Lines_Common()+');

859:
860: BEGIN
861:
862: IF PG_DEBUG in ('Y', 'C') THEN
863: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Create_Ae_Lines_Common()+');
864: END IF;
865:
866: /*-------------------------------------------------------------+
867: | Get Document Entitity specific data |

Line 892: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Create_Ae_Lines_Common()-');

888:
889: END IF;
890:
891: IF PG_DEBUG in ('Y', 'C') THEN
892: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Create_Ae_Lines_Common()-');
893: END IF;
894:
895: EXCEPTION
896: WHEN OTHERS THEN

Line 898: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.Create_Ae_Lines_Common');

894:
895: EXCEPTION
896: WHEN OTHERS THEN
897: IF PG_DEBUG in ('Y', 'C') THEN
898: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.Create_Ae_Lines_Common');
899: END IF;
900: RAISE;
901:
902: END Create_Ae_Lines_Common;

Line 942: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Create_Ae_Lines_BR()+');

938: l_ae_deleted BOOLEAN := FALSE;
939:
940: BEGIN
941: IF PG_DEBUG in ('Y', 'C') THEN
942: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Create_Ae_Lines_BR()+');
943: END IF;
944:
945: /*-------------------------------------------------------------------------+
946: | Create accounting based on the record status and event that took place |

Line 1037: | When status becomes STANDARD_REMITTED the old accounting is |

1033: p_app_rec.applied_payment_schedule_id);
1034:
1035: ELSIF p_trh_rec.status = C_REMITTED THEN
1036: /*-------------------------------------------------------------------+
1037: | When status becomes STANDARD_REMITTED the old accounting is |
1038: | reversed. Autoaccounting is called called with class REMITTANCE. |
1039: +-------------------------------------------------------------------*/
1040:
1041: l_account_class := C_REMITTANCE;

Line 1069: arp_standard.debug('ARP_BILLS_RECEIVABLE_MAIN.Create_Ae_Lines_BR - status '||p_trh_rec.status||' not supported');

1065: /*--------------------------------------------------------------------------+
1066: | Not supported, raise an error to notify that this has to be implemented. |
1067: +--------------------------------------------------------------------------*/
1068: IF PG_DEBUG in ('Y', 'C') THEN
1069: arp_standard.debug('ARP_BILLS_RECEIVABLE_MAIN.Create_Ae_Lines_BR - status '||p_trh_rec.status||' not supported');
1070: END IF;
1071: APP_EXCEPTION.raise_exception;
1072:
1073: END IF;

Line 1103: arp_standard.debug('ARP_BILLS_RECEIVABLE_MAIN.Create_Ae_Lines_BR - AutoAccounting Failed' );

1099:
1100: EXCEPTION
1101: WHEN arp_auto_accounting.no_ccid THEN
1102: IF PG_DEBUG in ('Y', 'C') THEN
1103: arp_standard.debug('ARP_BILLS_RECEIVABLE_MAIN.Create_Ae_Lines_BR - AutoAccounting Failed' );
1104: END IF;
1105: RAISE;
1106: WHEN OTHERS THEN
1107: RAISE;

Line 1146: | because of standards and that the User Hook could override accounting |

1142: FOR l_ctr IN l_ae_line_tbl.FIRST .. l_ae_line_tbl.LAST LOOP
1143:
1144: /*-----------------------------------------------------------------------+
1145: | It is necessary to populate the record and then call assign elements |
1146: | because of standards and that the User Hook could override accounting |
1147: | so need to populate this record (rather than direct table assignments)|
1148: +-----------------------------------------------------------------------*/
1149: l_ael_line_rec := l_empty_ael_line_rec;
1150: l_ael_line_rec := l_ae_line_tbl(l_ctr);

Line 1172: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Create_Ae_Lines_BR()-');

1168: END IF; --end if Maturity date event for a Bill
1169:
1170:
1171: IF PG_DEBUG in ('Y', 'C') THEN
1172: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Create_Ae_Lines_BR()-');
1173: END IF;
1174:
1175: EXCEPTION
1176: WHEN NO_DATA_FOUND THEN

Line 1178: arp_standard.debug('EXCEPTION: NO_DATA_FOUND' );

1174:
1175: EXCEPTION
1176: WHEN NO_DATA_FOUND THEN
1177: IF PG_DEBUG in ('Y', 'C') THEN
1178: arp_standard.debug('EXCEPTION: NO_DATA_FOUND' );
1179: END IF;
1180: RAISE;
1181:
1182: WHEN OTHERS THEN

Line 1184: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.Create_Ae_Lines_BR');

1180: RAISE;
1181:
1182: WHEN OTHERS THEN
1183: IF PG_DEBUG in ('Y', 'C') THEN
1184: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.Create_Ae_Lines_BR');
1185: END IF;
1186: RAISE;
1187:
1188: END Create_Ae_Lines_BR;

Line 1220: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Assign_Ael_Elements()+');

1216:
1217: BEGIN
1218:
1219: IF PG_DEBUG in ('Y', 'C') THEN
1220: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Assign_Ael_Elements()+');
1221: END IF;
1222:
1223: /*------------------------------------------------------+
1224: | Call Hook to Override Account |

Line 1306: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Assign_Ael_Elements()-');

1302: g_ae_line_tbl(g_ae_line_ctr).ref_account_class := p_ae_line_rec.ref_account_class;
1303: --}
1304:
1305: IF PG_DEBUG in ('Y', 'C') THEN
1306: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Assign_Ael_Elements()-');
1307: END IF;
1308:
1309: EXCEPTION
1310: WHEN OTHERS THEN

Line 1312: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.Assign_Ael_Elements');

1308:
1309: EXCEPTION
1310: WHEN OTHERS THEN
1311: IF PG_DEBUG in ('Y', 'C') THEN
1312: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.Assign_Ael_Elements');
1313: END IF;
1314: RAISE;
1315:
1316: END Assign_Ael_Elements;

Line 1338: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.initialize_global_variables()+');

1334: PROCEDURE initialize_global_variables(p_trh_rec IN ar_transaction_history%ROWTYPE) IS
1335:
1336: BEGIN
1337: IF PG_DEBUG in ('Y', 'C') THEN
1338: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.initialize_global_variables()+');
1339: END IF;
1340:
1341: /*-----------------------------+
1342: | Fetch the previous status |

Line 1385: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.initialize_global_variables()-');

1381: g_event := NULL;
1382: END IF;
1383:
1384: IF PG_DEBUG in ('Y', 'C') THEN
1385: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.initialize_global_variables()-');
1386: END IF;
1387:
1388: EXCEPTION
1389: WHEN OTHERS THEN

Line 1391: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.initialize_global_variables');

1387:
1388: EXCEPTION
1389: WHEN OTHERS THEN
1390: IF PG_DEBUG in ('Y', 'C') THEN
1391: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.initialize_global_variables');
1392: END IF;
1393: RAISE;
1394:
1395: END initialize_global_variables;

Line 1420: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.trx_history_status()');

1416: history_status_rec history_status_cur%ROWTYPE;
1417:
1418: BEGIN
1419: IF PG_DEBUG in ('Y', 'C') THEN
1420: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.trx_history_status()');
1421: END IF;
1422:
1423: /*------------------+
1424: | fetch the status |

Line 1444: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.trx_history_status');

1440:
1441: EXCEPTION
1442: WHEN OTHERS THEN
1443: IF PG_DEBUG in ('Y', 'C') THEN
1444: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.trx_history_status');
1445: END IF;
1446: RAISE;
1447:
1448: END trx_history_status;

Line 1464: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.reverse_single_dist_line()+');

1460: l_ael_line_rec ae_line_rec_type;
1461: l_ael_empty_line_rec ae_line_rec_type;
1462: BEGIN
1463: IF PG_DEBUG in ('Y', 'C') THEN
1464: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.reverse_single_dist_line()+');
1465: END IF;
1466:
1467: /*---------------------------+
1468: | Initialize build record |

Line 1527: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.reverse_single_dist_line()-');

1523: +---------------------------*/
1524: Assign_Ael_Elements( p_ae_line_rec => l_ael_line_rec );
1525:
1526: IF PG_DEBUG in ('Y', 'C') THEN
1527: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.reverse_single_dist_line()-');
1528: END IF;
1529:
1530: EXCEPTION
1531: WHEN OTHERS THEN

Line 1533: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.reverse_single_dist_line');

1529:
1530: EXCEPTION
1531: WHEN OTHERS THEN
1532: IF PG_DEBUG in ('Y', 'C') THEN
1533: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.reverse_single_dist_line');
1534: END IF;
1535: RAISE;
1536:
1537: END reverse_single_dist_line;

Line 1581: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.reverse_old_acct()+');

1577: l_ps_rec ps_cur%ROWTYPE;
1578:
1579: BEGIN
1580: IF PG_DEBUG in ('Y', 'C') THEN
1581: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.reverse_old_acct()+');
1582: END IF;
1583:
1584: /*--------------------------------------+
1585: | Find previous posted history record |

Line 1637: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.reverse_old_acct()-');

1633: +---------------------------------------------------------------------*/
1634: reverse_single_dist_line(l_ard_rec);
1635:
1636: IF PG_DEBUG in ('Y', 'C') THEN
1637: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.reverse_old_acct()-');
1638: END IF;
1639:
1640: EXCEPTION
1641: WHEN OTHERS THEN

Line 1643: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.reverse_old_acct');

1639:
1640: EXCEPTION
1641: WHEN OTHERS THEN
1642: IF PG_DEBUG in ('Y', 'C') THEN
1643: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.reverse_old_acct');
1644: END IF;
1645: RAISE;
1646:
1647: END reverse_old_acct;

Line 1691: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.find_prev_posted_hist_record()');

1687: history_rec history_cur%ROWTYPE;
1688:
1689: BEGIN
1690: IF PG_DEBUG in ('Y', 'C') THEN
1691: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.find_prev_posted_hist_record()');
1692: END IF;
1693:
1694: /*--------------------------+
1695: | Fetch the current record |

Line 1742: arp_standard.debug('find_prev_posted_hist_record: ' || 'Previous posted history record cannot be found.');

1738: CLOSE history_cur;
1739:
1740: IF history_rec.transaction_history_id IS NULL THEN
1741: IF PG_DEBUG in ('Y', 'C') THEN
1742: arp_standard.debug('find_prev_posted_hist_record: ' || 'Previous posted history record cannot be found.');
1743: END IF;
1744: RAISE NO_DATA_FOUND;
1745: END IF;
1746:

Line 1752: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.find_prev_posted_hist_record');

1748:
1749: EXCEPTION
1750: WHEN OTHERS THEN
1751: IF PG_DEBUG in ('Y', 'C') THEN
1752: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.find_prev_posted_hist_record');
1753: END IF;
1754: RAISE;
1755:
1756: END find_prev_posted_hist_record;

Line 1907: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.find_rec_dist_record()+');

1903: distribution_rec ar_distributions%ROWTYPE;
1904:
1905: BEGIN
1906: IF PG_DEBUG in ('Y', 'C') THEN
1907: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.find_rec_dist_record()+');
1908: END IF;
1909:
1910: /*-----------------------------------+
1911: | Fetch the accounting record |

Line 1962: arp_standard.debug('find_rec_dist_record: ' || 'Receivable accounting record cannot be found.');

1958: IF distribution_cur%NOTFOUND THEN
1959:
1960: CLOSE distribution_cur;
1961: IF PG_DEBUG in ('Y', 'C') THEN
1962: arp_standard.debug('find_rec_dist_record: ' || 'Receivable accounting record cannot be found.');
1963: END IF;
1964: APP_EXCEPTION.raise_exception;
1965:
1966: END IF;

Line 1979: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.find_rec_dist_record()-');

1975: +------------------------------*/
1976: p_dist_rec := distribution_rec;
1977:
1978: IF PG_DEBUG in ('Y', 'C') THEN
1979: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.find_rec_dist_record()-');
1980: END IF;
1981:
1982: EXCEPTION
1983: WHEN OTHERS THEN

Line 1985: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.find_rec_dist_record');

1981:
1982: EXCEPTION
1983: WHEN OTHERS THEN
1984: IF PG_DEBUG in ('Y', 'C') THEN
1985: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.find_rec_dist_record');
1986: END IF;
1987: RAISE;
1988:
1989: END find_rec_dist_record;

Line 2009: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.find_exchanged_trx_acct()');

2005: l_prev_posted_trh_rec ar_transaction_history%ROWTYPE;
2006:
2007: BEGIN
2008: IF PG_DEBUG in ('Y', 'C') THEN
2009: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.find_exchanged_trx_acct()');
2010: END IF;
2011:
2012: /*-------------------------------------------------------------------+
2013: | Store the current transaction history record id in local variable |

Line 2047: arp_standard.debug('find_exchanged_trx_acct: ' || 'Previous transaction history record with exchange accountin cannot be found.');

2043:
2044: IF l_prev_posted_trh_rec.transaction_history_id IS NULL THEN
2045:
2046: IF PG_DEBUG in ('Y', 'C') THEN
2047: arp_standard.debug('find_exchanged_trx_acct: ' || 'Previous transaction history record with exchange accountin cannot be found.');
2048: END IF;
2049: APP_EXCEPTION.raise_exception;
2050:
2051: END IF;

Line 2058: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.find_exchanged_trx_acct');

2054:
2055: EXCEPTION
2056: WHEN OTHERS THEN
2057: IF PG_DEBUG in ('Y', 'C') THEN
2058: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.find_exchanged_trx_acct');
2059: END IF;
2060: RAISE;
2061:
2062: END find_exchanged_trx_acct;

Line 2197: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.reverse_exchanged_trx_acct()+');

2193: l_last_exchanged_history_id ar_transaction_history.transaction_history_id%TYPE;
2194:
2195: BEGIN
2196: IF PG_DEBUG in ('Y', 'C') THEN
2197: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.reverse_exchanged_trx_acct()+');
2198: END IF;
2199:
2200: /*-------------------------------------------------------+
2201: | Find the original posted transaction history record |

Line 2266: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.reverse_exchanged_trx_acct()-');

2262: END LOOP;
2263: CLOSE last_exchange_accounting_cur;
2264:
2265: IF PG_DEBUG in ('Y', 'C') THEN
2266: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.reverse_exchanged_trx_acct()-');
2267: END IF;
2268:
2269: EXCEPTION
2270: WHEN OTHERS THEN

Line 2272: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.reverse_exchanged_trx_acct');

2268:
2269: EXCEPTION
2270: WHEN OTHERS THEN
2271: IF PG_DEBUG in ('Y', 'C') THEN
2272: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.reverse_exchanged_trx_acct');
2273: END IF;
2274: RAISE;
2275: END reverse_exchanged_trx_acct;
2276:

Line 2410: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.create_exchanged_trx_acct()+');

2406: --}
2407:
2408: BEGIN
2409: IF PG_DEBUG in ('Y', 'C') THEN
2410: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.create_exchanged_trx_acct()+');
2411: END IF;
2412:
2413:
2414: /*--------------------------------------------------+

Line 2507: arp_standard.debug('source id = ' || to_char(l_ael_line_rec.source_id));

2503: l_ael_line_rec.source_table_secondary := C_CTL;
2504:
2505:
2506: IF PG_DEBUG in ('Y', 'C') THEN
2507: arp_standard.debug('source id = ' || to_char(l_ael_line_rec.source_id));
2508: arp_standard.debug('currency code = ' || l_ael_line_rec.currency_code);
2509: END IF;
2510:
2511:

Line 2508: arp_standard.debug('currency code = ' || l_ael_line_rec.currency_code);

2504:
2505:
2506: IF PG_DEBUG in ('Y', 'C') THEN
2507: arp_standard.debug('source id = ' || to_char(l_ael_line_rec.source_id));
2508: arp_standard.debug('currency code = ' || l_ael_line_rec.currency_code);
2509: END IF;
2510:
2511:
2512: IF NVL(all_exchanges_rec.class,'INV') <> 'BR' THEN

Line 2568: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.create_exchanged_trx_acct()-');

2564:
2565: END LOOP;
2566:
2567: IF PG_DEBUG in ('Y', 'C') THEN
2568: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.create_exchanged_trx_acct()-');
2569: END IF;
2570:
2571: EXCEPTION
2572: WHEN OTHERS THEN

Line 2574: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.create_exchanged_trx_acct');

2570:
2571: EXCEPTION
2572: WHEN OTHERS THEN
2573: IF PG_DEBUG in ('Y', 'C') THEN
2574: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.create_exchanged_trx_acct');
2575: END IF;
2576: RAISE;
2577:
2578: END create_exchanged_trx_acct;

Line 2705: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.reverse_deferred_tax()+');

2701: l_prev_posted_trh_rec ar_transaction_history%ROWTYPE;
2702:
2703: BEGIN
2704: IF PG_DEBUG in ('Y', 'C') THEN
2705: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.reverse_deferred_tax()+');
2706: END IF;
2707:
2708: BEGIN
2709: /*-------------------------------------------------------+

Line 2721: arp_standard.debug('reverse_deferred_tax: ' || 'No Deferred tax exist, so none is reversed ');

2717: /*---------------------------------------------+
2718: | No deferred tax exists, so none is reversed |
2719: +---------------------------------------------*/
2720: IF PG_DEBUG in ('Y', 'C') THEN
2721: arp_standard.debug('reverse_deferred_tax: ' || 'No Deferred tax exist, so none is reversed ');
2722: END IF;
2723: NULL;
2724:
2725: END;

Line 2795: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.reverse_deferred_tax()-');

2791: --}
2792: END IF;
2793:
2794: IF PG_DEBUG in ('Y', 'C') THEN
2795: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.reverse_deferred_tax()-');
2796: END IF;
2797:
2798: EXCEPTION
2799: WHEN OTHERS THEN

Line 2801: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.reverse_deferred_tax');

2797:
2798: EXCEPTION
2799: WHEN OTHERS THEN
2800: IF PG_DEBUG in ('Y', 'C') THEN
2801: arp_standard.debug('EXCEPTION: ARP_BILLS_RECEIVABLE_MAIN.reverse_deferred_tax');
2802: END IF;
2803: RAISE;
2804: END reverse_deferred_tax;
2805: