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_BR_HOUSEKEEPER_PKG dependencies on ARP_BR_HOUSEKEEPER_PKG

Line 1: PACKAGE BODY arp_br_housekeeper_pkg AS

1: PACKAGE BODY arp_br_housekeeper_pkg AS
2: /* $Header: ARRBRHKB.pls 120.6 2005/06/03 20:41:32 vcrisost ship $ */
3:
4:
5: /*----------------------------------------------------+

Line 189: write_debug_and_log( 'arp_br_housekeeper_pkg.ar_br_housekeeper()+' );

185: l_default_gl_date DATE;
186: l_deferred_tax_exists BOOLEAN := FALSE;
187:
188: BEGIN
189: write_debug_and_log( 'arp_br_housekeeper_pkg.ar_br_housekeeper()+' );
190: write_debug_and_log( 'p_effective_date = '||to_char(p_effective_date));
191: write_debug_and_log( 'p_gl_date = ' ||to_char(p_gl_date));
192: write_debug_and_log( 'p_maturity_date_low = ' ||to_char(p_maturity_date_low));
193: write_debug_and_log( 'p_maturity_date_high = ' ||to_char(p_maturity_date_high));

Line 208: l_default_gl_date := arp_br_housekeeper_pkg.validate_and_default_gl_date(p_gl_date,

204: | current date If neither the given GL_date nor SYSDATE is valid, then |
205: | the GL_DATE will be defaulted to the last date of the most recent open |
206: | period. |
207: +------------------------------------------------------------------------*/
208: l_default_gl_date := arp_br_housekeeper_pkg.validate_and_default_gl_date(p_gl_date,
209: NULL,NULL,NULL,NULL,
210: SYSDATE,
211: NULL,NULL);
212: IF l_default_gl_date is not NULL THEN

Line 306: arp_br_housekeeper_pkg.process_standard_remitted;

302:
303: IF pg_BR_rec.status = 'REMITTED' THEN
304:
305: pg_called_from := 'BR_REMITTED';
306: arp_br_housekeeper_pkg.process_standard_remitted;
307:
308: ELSIF pg_BR_rec.status = 'FACTORED' or pg_BR_rec.status = 'MATURED_PEND_RISK_ELIMINATION' THEN
309:
310: pg_called_from := 'BR_FACTORED_WITH_RECOURSE';

Line 311: arp_br_housekeeper_pkg.process_factored;

307:
308: ELSIF pg_BR_rec.status = 'FACTORED' or pg_BR_rec.status = 'MATURED_PEND_RISK_ELIMINATION' THEN
309:
310: pg_called_from := 'BR_FACTORED_WITH_RECOURSE';
311: arp_br_housekeeper_pkg.process_factored;
312:
313: ELSIF pg_BR_rec.status = 'ENDORSED' THEN
314:
315: pg_called_from := NULL;

Line 316: arp_br_housekeeper_pkg.process_endorsed;

312:
313: ELSIF pg_BR_rec.status = 'ENDORSED' THEN
314:
315: pg_called_from := NULL;
316: arp_br_housekeeper_pkg.process_endorsed;
317:
318: ELSE
319:
320: /*--------------------------------------------------+

Line 335: write_debug_and_log( 'arp_br_housekeeper_pkg.ar_br_housekeeper()-' );

331: END LOOP;
332:
333: CLOSE matured_cur;
334:
335: write_debug_and_log( 'arp_br_housekeeper_pkg.ar_br_housekeeper()-' );
336: return(TRUE);
337:
338: EXCEPTION
339: WHEN OTHERS THEN

Line 343: write_debug_and_log('Exception: arp_br_housekeeper_pkg.ar_br_housekeeper '||SQLERRM);

339: WHEN OTHERS THEN
340: IF matured_cur%ISOPEN THEN
341: CLOSE matured_cur;
342: END IF;
343: write_debug_and_log('Exception: arp_br_housekeeper_pkg.ar_br_housekeeper '||SQLERRM);
344: RAISE;
345:
346: END ar_br_housekeeper;
347:

Line 374: write_debug_and_log( 'arp_br_housekeeper_pkg.process_standard_remitted()+' );

370: l_move_deferred_tax VARCHAR2(1) := 'Y';
371: l_receipt_date DATE;
372:
373: BEGIN
374: write_debug_and_log( 'arp_br_housekeeper_pkg.process_standard_remitted()+' );
375:
376: /*-------------------------------------------------+
377: | Fetch information from the BR remittance batch |
378: | The procedure populates a package global record |

Line 381: arp_br_housekeeper_pkg.fetch_remittance_setup_data(pg_BR_rec.status,

377: | Fetch information from the BR remittance batch |
378: | The procedure populates a package global record |
379: | with the data, accessible to all sub procedures |
380: +-------------------------------------------------*/
381: arp_br_housekeeper_pkg.fetch_remittance_setup_data(pg_BR_rec.status,
382: pg_BR_rec.reserved_value);
383:
384: /*--------------------------------------------------------+
385: | Check whether we have remitted after the maturity date |

Line 439: write_debug_and_log( 'arp_br_housekeeper_pkg.process_standard_remitted()-' );

435: create_and_apply_Receipt(l_move_deferred_tax,l_receipt_date);
436:
437: END IF; /* l_remittace_past_maturity */
438:
439: write_debug_and_log( 'arp_br_housekeeper_pkg.process_standard_remitted()-' );
440:
441: EXCEPTION
442: WHEN OTHERS THEN
443: write_debug_and_log('Exception: arp_br_housekeeper_pkg.process_standard_remitted '||SQLERRM);

Line 443: write_debug_and_log('Exception: arp_br_housekeeper_pkg.process_standard_remitted '||SQLERRM);

439: write_debug_and_log( 'arp_br_housekeeper_pkg.process_standard_remitted()-' );
440:
441: EXCEPTION
442: WHEN OTHERS THEN
443: write_debug_and_log('Exception: arp_br_housekeeper_pkg.process_standard_remitted '||SQLERRM);
444: RAISE;
445: END process_standard_remitted;
446:
447: /*===========================================================================+

Line 476: write_debug_and_log( 'arp_br_housekeeper_pkg.process_factored()+' );

472: l_event_date DATE;
473:
474: BEGIN
475:
476: write_debug_and_log( 'arp_br_housekeeper_pkg.process_factored()+' );
477:
478: /*-------------------------------------------------+
479: | Fetch information from the BR remittance batch |
480: | The procedure populates a package global record |

Line 483: arp_br_housekeeper_pkg.fetch_remittance_setup_data(pg_BR_rec.status,

479: | Fetch information from the BR remittance batch |
480: | The procedure populates a package global record |
481: | with the data, accessible to all sub procedures |
482: +-------------------------------------------------*/
483: arp_br_housekeeper_pkg.fetch_remittance_setup_data(pg_BR_rec.status,
484: pg_BR_rec.reserved_value);
485:
486: /*-------------------------------------------------+
487: | Fetch information on the previous posted |

Line 492: arp_br_housekeeper_pkg.prev_posted_trh(pg_BR_rec.transaction_history_id,

488: | transaction record for this BR. This information|
489: | is used to decide what processing is needed for |
490: | the Bills Receivable. |
491: +-------------------------------------------------*/
492: arp_br_housekeeper_pkg.prev_posted_trh(pg_BR_rec.transaction_history_id,
493: prev_trh_rec);
494:
495: /*--------------------------------------------------------+
496: | Check whether we have remitted after the maturity date |

Line 599: write_debug_and_log( 'arp_br_housekeeper_pkg.process_factored()-' );

595: apply_Receipt(l_move_deferred_tax,l_event_date);
596:
597: END IF; /* cutoff past risk */
598:
599: write_debug_and_log( 'arp_br_housekeeper_pkg.process_factored()-' );
600:
601: EXCEPTION
602: WHEN OTHERS THEN
603: write_debug_and_log('Exception: arp_br_housekeeper_pkg.process_factored '||SQLERRM);

Line 603: write_debug_and_log('Exception: arp_br_housekeeper_pkg.process_factored '||SQLERRM);

599: write_debug_and_log( 'arp_br_housekeeper_pkg.process_factored()-' );
600:
601: EXCEPTION
602: WHEN OTHERS THEN
603: write_debug_and_log('Exception: arp_br_housekeeper_pkg.process_factored '||SQLERRM);
604: RAISE;
605:
606: END process_factored;
607:

Line 646: write_debug_and_log( 'arp_br_housekeeper_pkg.process_endorsed()+' );

642: prev_trh_rec ar_transaction_history%ROWTYPE;
643:
644: BEGIN
645:
646: write_debug_and_log( 'arp_br_housekeeper_pkg.process_endorsed()+' );
647:
648: /*-----------------------------------+
649: | Fetch last Endorsement adjustment |
650: +-----------------------------------*/

Line 673: arp_br_housekeeper_pkg.fetch_endorsement_setup_data(last_adjustment_rec.receivables_trx_id);

669: | Fetch information from the receivable activity |
670: | The procedure populates a package global record |
671: | with the data, accessible to all sub procedures |
672: +-------------------------------------------------*/
673: arp_br_housekeeper_pkg.fetch_endorsement_setup_data(last_adjustment_rec.receivables_trx_id);
674:
675: /*-------------------------------------------------+
676: | Fetch information on the previous posted |
677: | transaction record for this BR. This information|

Line 681: arp_br_housekeeper_pkg.prev_posted_trh(pg_BR_rec.transaction_history_id,

677: | transaction record for this BR. This information|
678: | is used to decide what processing is needed for |
679: | the Bills Receivable. |
680: +-------------------------------------------------*/
681: arp_br_housekeeper_pkg.prev_posted_trh(pg_BR_rec.transaction_history_id,
682: prev_trh_rec);
683:
684: /*--------------------------------------------------------------------+
685: | Check whether we have passed maturity date + risk_elimination_days |

Line 794: write_debug_and_log( 'arp_br_housekeeper_pkg.process_endorsed()-' );

790: END IF; /* effective date before maturity + risk */
791:
792: END IF; /* endorsed after maturity */
793:
794: write_debug_and_log( 'arp_br_housekeeper_pkg.process_endorsed()-' );
795:
796: EXCEPTION
797: WHEN OTHERS THEN
798: write_debug_and_log('Exception: arp_br_housekeeper_pkg.process_endorsed '||SQLERRM);

Line 798: write_debug_and_log('Exception: arp_br_housekeeper_pkg.process_endorsed '||SQLERRM);

794: write_debug_and_log( 'arp_br_housekeeper_pkg.process_endorsed()-' );
795:
796: EXCEPTION
797: WHEN OTHERS THEN
798: write_debug_and_log('Exception: arp_br_housekeeper_pkg.process_endorsed '||SQLERRM);
799: RAISE;
800:
801: END process_endorsed;
802:

Line 879: write_debug_and_log( 'arp_br_housekeeper_pkg.create_and_apply_Receipt()+' );

875: l_org_return_status VARCHAR2(1);
876: l_org_id NUMBER;
877:
878: BEGIN
879: write_debug_and_log( 'arp_br_housekeeper_pkg.create_and_apply_Receipt()+' );
880:
881:
882: BEGIN
883:

Line 910: write_debug_and_log('arp_br_housekeeper_pkg.create_and_apply_Receipt : l_org_return_status <> SUCCESS');

906: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
907: p_return_status =>l_org_return_status);
908:
909: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
910: write_debug_and_log('arp_br_housekeeper_pkg.create_and_apply_Receipt : l_org_return_status <> SUCCESS');
911: RAISE API_exception;
912: ELSE
913:
914: /*-------------------------------------------+

Line 928: l_default_gl_date := arp_br_housekeeper_pkg.validate_against_doc_gl_date(pg_gl_date,

924: write_debug_and_log( 'l_receipt_number = '||l_receipt_number );
925:
926: END IF;
927:
928: l_default_gl_date := arp_br_housekeeper_pkg.validate_against_doc_gl_date(pg_gl_date,
929: pg_BR_rec.gl_date);
930:
931: /*--------------------------------------------------------+
932: | Receipt date, apply date, deposit date and receipt |

Line 1015: write_debug_and_log('API Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt '||SQLERRM);

1011: | APIs propagate exception upwards |
1012: +----------------------------------*/
1013: EXCEPTION
1014: WHEN API_exception THEN
1015: write_debug_and_log('API Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt '||SQLERRM);
1016: RAISE;
1017:
1018: WHEN OTHERS THEN
1019: write_debug_and_log('Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt '||SQLERRM);

Line 1019: write_debug_and_log('Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt '||SQLERRM);

1015: write_debug_and_log('API Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt '||SQLERRM);
1016: RAISE;
1017:
1018: WHEN OTHERS THEN
1019: write_debug_and_log('Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt '||SQLERRM);
1020: RAISE;
1021:
1022: END;
1023:

Line 1058: write_debug_and_log( 'arp_br_housekeeper_pkg.create_and_apply_Receipt()-' );

1054: l_transaction_history_id);
1055:
1056: END IF; /* l_org_return_status <> FND_API.G_RET_STS_SUCCESS */
1057:
1058: write_debug_and_log( 'arp_br_housekeeper_pkg.create_and_apply_Receipt()-' );
1059:
1060: EXCEPTION
1061: WHEN OTHERS THEN
1062: write_debug_and_log('Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt'||SQLERRM);

Line 1062: write_debug_and_log('Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt'||SQLERRM);

1058: write_debug_and_log( 'arp_br_housekeeper_pkg.create_and_apply_Receipt()-' );
1059:
1060: EXCEPTION
1061: WHEN OTHERS THEN
1062: write_debug_and_log('Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt'||SQLERRM);
1063: RAISE;
1064:
1065: END create_and_apply_Receipt;
1066:

Line 1107: write_debug_and_log( 'arp_br_housekeeper_pkg.approve_Adjustment()+' );

1103:
1104: l_org_return_status VARCHAR2(1);
1105: l_org_id NUMBER;
1106: BEGIN
1107: write_debug_and_log( 'arp_br_housekeeper_pkg.approve_Adjustment()+' );
1108:
1109: /* SSA change */
1110: l_org_id := p_adjustment_rec.org_id;
1111: l_org_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1116: write_debug_and_log('arp_br_housekeeper_pkg.approve_adjustment : l_org_return_status <> SUCCESS');

1112: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
1113: p_return_status =>l_org_return_status);
1114:
1115: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1116: write_debug_and_log('arp_br_housekeeper_pkg.approve_adjustment : l_org_return_status <> SUCCESS');
1117: RAISE API_exception;
1118: ELSE
1119:
1120: /*--------------------------------------------------------+

Line 1143: l_default_gl_date := arp_br_housekeeper_pkg.validate_and_default_gl_date(p_adjustment_rec.gl_date,

1139: | the gl date given to the housekeeper by the |
1140: | user. If that is also invalid default to the |
1141: | next available open period. |
1142: +----------------------------------------------*/
1143: l_default_gl_date := arp_br_housekeeper_pkg.validate_and_default_gl_date(p_adjustment_rec.gl_date,
1144: NULL,NULL,NULL,NULL,
1145: pg_gl_date,
1146: NULL,NULL);
1147:

Line 1216: write_debug_and_log('API Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt '||SQLERRM);

1212: | APIs propagate exception upwards |
1213: +----------------------------------*/
1214: EXCEPTION
1215: WHEN API_exception THEN
1216: write_debug_and_log('API Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt '||SQLERRM);
1217: RAISE;
1218:
1219: WHEN OTHERS THEN
1220: write_debug_and_log('Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt '||SQLERRM);

Line 1220: write_debug_and_log('Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt '||SQLERRM);

1216: write_debug_and_log('API Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt '||SQLERRM);
1217: RAISE;
1218:
1219: WHEN OTHERS THEN
1220: write_debug_and_log('Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt '||SQLERRM);
1221: RAISE;
1222:
1223: END;
1224:

Line 1258: write_debug_and_log( 'arp_br_housekeeper_pkg.approve_Adjustment()-' );

1254: l_transaction_history_id);
1255:
1256: END IF; /* l_org_return_status <> FND_API.G_RET_STS_SUCCESS */
1257:
1258: write_debug_and_log( 'arp_br_housekeeper_pkg.approve_Adjustment()-' );
1259:
1260: EXCEPTION
1261: WHEN OTHERS THEN
1262: write_debug_and_log('Exception: arp_br_housekeeper_pkg.approve_Adjustment'||SQLERRM);

Line 1262: write_debug_and_log('Exception: arp_br_housekeeper_pkg.approve_Adjustment'||SQLERRM);

1258: write_debug_and_log( 'arp_br_housekeeper_pkg.approve_Adjustment()-' );
1259:
1260: EXCEPTION
1261: WHEN OTHERS THEN
1262: write_debug_and_log('Exception: arp_br_housekeeper_pkg.approve_Adjustment'||SQLERRM);
1263: RAISE;
1264:
1265: END approve_Adjustment;
1266:

Line 1321: write_debug_and_log( 'arp_br_housekeeper_pkg.apply_Receipt()+' );

1317:
1318: l_org_return_status VARCHAR2(1);
1319: l_org_id NUMBER;
1320: BEGIN
1321: write_debug_and_log( 'arp_br_housekeeper_pkg.apply_Receipt()+' );
1322:
1323: /*------------------------+
1324: | Fetch last application |
1325: +------------------------*/

Line 1349: write_debug_and_log('arp_br_housekeeper_pkg.apply_receipt : l_org_return_status <> SUCCESS');

1345: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
1346: p_return_status =>l_org_return_status);
1347:
1348: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1349: write_debug_and_log('arp_br_housekeeper_pkg.apply_receipt : l_org_return_status <> SUCCESS');
1350: RAISE API_exception;
1351: ELSE
1352:
1353: l_default_gl_date := arp_br_housekeeper_pkg.validate_against_doc_gl_date(pg_gl_date,

Line 1353: l_default_gl_date := arp_br_housekeeper_pkg.validate_against_doc_gl_date(pg_gl_date,

1349: write_debug_and_log('arp_br_housekeeper_pkg.apply_receipt : l_org_return_status <> SUCCESS');
1350: RAISE API_exception;
1351: ELSE
1352:
1353: l_default_gl_date := arp_br_housekeeper_pkg.validate_against_doc_gl_date(pg_gl_date,
1354: last_std_application_rec.gl_date);
1355: BEGIN
1356: /*------------------------------------+
1357: | Unapply from STD using Receipt API |

Line 1408: write_debug_and_log('API Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt '||SQLERRM);

1404: | APIs propagate exception upwards |
1405: +----------------------------------*/
1406: EXCEPTION
1407: WHEN API_exception THEN
1408: write_debug_and_log('API Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt '||SQLERRM);
1409: RAISE;
1410:
1411: WHEN OTHERS THEN
1412: write_debug_and_log('Exception: arp_br_housekeeper_pkg.apply_Receipt '||SQLERRM);

Line 1412: write_debug_and_log('Exception: arp_br_housekeeper_pkg.apply_Receipt '||SQLERRM);

1408: write_debug_and_log('API Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt '||SQLERRM);
1409: RAISE;
1410:
1411: WHEN OTHERS THEN
1412: write_debug_and_log('Exception: arp_br_housekeeper_pkg.apply_Receipt '||SQLERRM);
1413: RAISE;
1414: END;
1415:
1416: BEGIN

Line 1489: write_debug_and_log('API Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt '||SQLERRM);

1485: | APIs propagate exception upwards |
1486: +----------------------------------*/
1487: EXCEPTION
1488: WHEN API_exception THEN
1489: write_debug_and_log('API Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt '||SQLERRM);
1490: RAISE;
1491:
1492: WHEN OTHERS THEN
1493: write_debug_and_log('Exception: arp_br_housekeeper_pkg.apply_Receipt '||SQLERRM);

Line 1493: write_debug_and_log('Exception: arp_br_housekeeper_pkg.apply_Receipt '||SQLERRM);

1489: write_debug_and_log('API Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt '||SQLERRM);
1490: RAISE;
1491:
1492: WHEN OTHERS THEN
1493: write_debug_and_log('Exception: arp_br_housekeeper_pkg.apply_Receipt '||SQLERRM);
1494: RAISE;
1495: END;
1496:
1497: /*-----------------------------------------------------------------+

Line 1541: write_debug_and_log( 'arp_br_housekeeper_pkg.apply_Receipt()-' );

1537:
1538:
1539: END IF; /* l_org_return_status <> FND_API.G_RET_STS_SUCCESS */
1540:
1541: write_debug_and_log( 'arp_br_housekeeper_pkg.apply_Receipt()-' );
1542:
1543: EXCEPTION
1544: WHEN OTHERS THEN
1545: write_debug_and_log('Exception: arp_br_housekeeper_pkg.apply_Receipt '||SQLERRM);

Line 1545: write_debug_and_log('Exception: arp_br_housekeeper_pkg.apply_Receipt '||SQLERRM);

1541: write_debug_and_log( 'arp_br_housekeeper_pkg.apply_Receipt()-' );
1542:
1543: EXCEPTION
1544: WHEN OTHERS THEN
1545: write_debug_and_log('Exception: arp_br_housekeeper_pkg.apply_Receipt '||SQLERRM);
1546: RAISE;
1547:
1548: END apply_Receipt;
1549:

Line 1581: write_debug_and_log( 'arp_br_housekeeper_pkg.create_maturity_date_event()+' );

1577: l_trh_rec ar_transaction_history%ROWTYPE;
1578: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;
1579: l_event_date DATE;
1580: BEGIN
1581: write_debug_and_log( 'arp_br_housekeeper_pkg.create_maturity_date_event()+' );
1582:
1583: /*-----------------------+
1584: | fetch previous record |
1585: +-----------------------*/

Line 1650: write_debug_and_log( 'arp_br_housekeeper_pkg.create_maturity_date_event()-' );

1646: ARP_PROC_TRANSACTION_HISTORY.insert_transaction_history(l_trh_rec,
1647: l_transaction_history_id,
1648: p_move_deferred_tax);
1649:
1650: write_debug_and_log( 'arp_br_housekeeper_pkg.create_maturity_date_event()-' );
1651:
1652: EXCEPTION
1653: WHEN OTHERS THEN
1654: write_debug_and_log('Exception: arp_br_housekeeper_pkg.create_maturity_date_event '||SQLERRM);

Line 1654: write_debug_and_log('Exception: arp_br_housekeeper_pkg.create_maturity_date_event '||SQLERRM);

1650: write_debug_and_log( 'arp_br_housekeeper_pkg.create_maturity_date_event()-' );
1651:
1652: EXCEPTION
1653: WHEN OTHERS THEN
1654: write_debug_and_log('Exception: arp_br_housekeeper_pkg.create_maturity_date_event '||SQLERRM);
1655: RAISE;
1656:
1657: END create_maturity_date_event;
1658:

Line 1696: write_debug_and_log( 'arp_br_housekeeper_pkg.prev_posted_trh()+' );

1692: start with transaction_history_id = p_transaction_history_id
1693: order by transaction_history_id desc;
1694:
1695: BEGIN
1696: write_debug_and_log( 'arp_br_housekeeper_pkg.prev_posted_trh()+' );
1697:
1698: /*--------------------------------------------------+
1699: | Fetch previous posted transaction history record |
1700: +--------------------------------------------------*/

Line 1716: write_debug_and_log( 'arp_br_housekeeper_pkg.prev_posted_trh()-' );

1712: END IF;
1713:
1714: CLOSE prev_trh_cur;
1715:
1716: write_debug_and_log( 'arp_br_housekeeper_pkg.prev_posted_trh()-' );
1717:
1718: EXCEPTION
1719: WHEN OTHERS THEN
1720: write_debug_and_log('Exception: arp_br_housekeeper_pkg.prev_posted_trh '||SQLERRM);

Line 1720: write_debug_and_log('Exception: arp_br_housekeeper_pkg.prev_posted_trh '||SQLERRM);

1716: write_debug_and_log( 'arp_br_housekeeper_pkg.prev_posted_trh()-' );
1717:
1718: EXCEPTION
1719: WHEN OTHERS THEN
1720: write_debug_and_log('Exception: arp_br_housekeeper_pkg.prev_posted_trh '||SQLERRM);
1721: RAISE;
1722:
1723: END prev_posted_trh;
1724:

Line 1767: write_debug_and_log( 'arp_br_housekeeper_pkg.fetch_remittance_setup_data()' );

1763: remittance_setup_rec remittance_setup_cur%ROWTYPE;
1764:
1765: BEGIN
1766:
1767: write_debug_and_log( 'arp_br_housekeeper_pkg.fetch_remittance_setup_data()' );
1768:
1769: /*-----------------------------+
1770: | Fetch remittance setup data |
1771: +-----------------------------*/

Line 1823: write_debug_and_log('Exception: arp_br_housekeeper_pkg.fetch_remittance_setup_data '||SQLERRM);

1819: pg_remittance_batch_date := remittance_setup_rec.batch_date;
1820:
1821: EXCEPTION
1822: WHEN OTHERS THEN
1823: write_debug_and_log('Exception: arp_br_housekeeper_pkg.fetch_remittance_setup_data '||SQLERRM);
1824: RAISE;
1825:
1826: END fetch_remittance_setup_data;
1827:

Line 1861: write_debug_and_log( 'arp_br_housekeeper_pkg.fetch_endorsement_setup_data()' );

1857: endorsement_setup_rec endorsement_setup_cur%ROWTYPE;
1858:
1859: BEGIN
1860:
1861: write_debug_and_log( 'arp_br_housekeeper_pkg.fetch_endorsement_setup_data()' );
1862:
1863: /*----------------------------------------+
1864: | Fetch receivable activity setup_data |
1865: +----------------------------------------*/

Line 1895: write_debug_and_log('Exception: arp_br_housekeeper_pkg.fetch_endorsement_setup_data '||SQLERRM);

1891: pg_remit_bank_acct_use_id := NULL;
1892:
1893: EXCEPTION
1894: WHEN OTHERS THEN
1895: write_debug_and_log('Exception: arp_br_housekeeper_pkg.fetch_endorsement_setup_data '||SQLERRM);
1896: RAISE;
1897:
1898: END fetch_endorsement_setup_data;
1899:

Line 2054: write_debug_and_log( 'arp_br_housekeeper_pkg.validate_and_default_gl_date()' );

2050: l_default_gl_date DATE;
2051: l_error_message VARCHAR2(240);
2052:
2053: BEGIN
2054: write_debug_and_log( 'arp_br_housekeeper_pkg.validate_and_default_gl_date()' );
2055:
2056: /*---------------------------------------------+
2057: | Validate GL date. If gl_date is not passed |
2058: | try to default it |

Line 2090: write_debug_and_log('Exception: arp_br_housekeeper_pkg.validate_and_default_gl_date '||SQLERRM);

2086: END IF;
2087:
2088: EXCEPTION
2089: WHEN OTHERS THEN
2090: write_debug_and_log('Exception: arp_br_housekeeper_pkg.validate_and_default_gl_date '||SQLERRM);
2091: RAISE;
2092:
2093: END validate_and_default_gl_date;
2094:

Line 2121: write_debug_and_log( 'arp_br_housekeeper_pkg.validate_against_doc_gl_date()' );

2117:
2118: l_default_gl_date DATE;
2119: BEGIN
2120:
2121: write_debug_and_log( 'arp_br_housekeeper_pkg.validate_against_doc_gl_date()' );
2122:
2123: /*--------------------------------------------------------------+
2124: | If parameters are null return the Gl date given as parameter |
2125: | to the report as nothing was changed. |

Line 2141: l_default_gl_date := arp_br_housekeeper_pkg.validate_and_default_gl_date(p_doc_gl_date,

2137: | the most recent open period. |
2138: +------------------------------------------------------------------------*/
2139: IF trunc(p_gl_date) < trunc(p_doc_gl_date) THEN
2140:
2141: l_default_gl_date := arp_br_housekeeper_pkg.validate_and_default_gl_date(p_doc_gl_date,
2142: NULL,NULL,NULL,NULL,NULL,NULL,NULL);
2143: IF l_default_gl_date is not NULL THEN
2144:
2145: write_debug_and_log( 'gl_date defaulted = '||to_char(l_default_gl_date));

Line 2168: write_debug_and_log('Exception: arp_br_housekeeper_pkg.validate_against_doc_gl_date '||SQLERRM);

2164: END IF;
2165:
2166: EXCEPTION
2167: WHEN OTHERS THEN
2168: write_debug_and_log('Exception: arp_br_housekeeper_pkg.validate_against_doc_gl_date '||SQLERRM);
2169: RAISE;
2170:
2171: END validate_against_doc_gl_date;
2172:

Line 2173: END arp_br_housekeeper_pkg;

2169: RAISE;
2170:
2171: END validate_against_doc_gl_date;
2172:
2173: END arp_br_housekeeper_pkg;