DBA Data[Home] [Help]

APPS.PN_NORM_RENORM_PKG dependencies on PN_NORM_RENORM_PKG

Line 1: PACKAGE BODY PN_NORM_RENORM_PKG AS

1: PACKAGE BODY PN_NORM_RENORM_PKG AS
2: -- $Header: PNRENRMB.pls 120.13.12020000.2 2012/07/18 10:00:12 admarath ship $
3:
4: /* procedure spec for the private procedures */
5: PROCEDURE RENORMALIZE_ACROSS_ALL_DRAFT

Line 208: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT (+) ');

204: AND pps.payment_schedule_id = ppi.payment_schedule_id
205: AND pps.payment_status_lookup_code <> 'DRAFT'
206: AND to_char(schedule_date,'MON-YY') = to_char(l_amd_comn_date,'MON-YY'); /* 8491119 */
207:
208: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT (+) ');
209: pnp_debug_pkg.log(' Procedure called with Parameters... ');
210: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
211: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
212: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );

Line 495: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> create $ 0 cash items(+)');

491: l_cash_item:=1;
492: END LOOP;
493:
494: IF l_cash_item = 0 THEN
495: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> create $ 0 cash items(+)');
496: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> for schedule id : '||g_norm_item_tbl(i).schedule_id);
497: pn_schedules_items.create_cash_items
498: (p_est_amt => 0,
499: p_act_amt => 0,

Line 496: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> for schedule id : '||g_norm_item_tbl(i).schedule_id);

492: END LOOP;
493:
494: IF l_cash_item = 0 THEN
495: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> create $ 0 cash items(+)');
496: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> for schedule id : '||g_norm_item_tbl(i).schedule_id);
497: pn_schedules_items.create_cash_items
498: (p_est_amt => 0,
499: p_act_amt => 0,
500: p_sch_dt => g_norm_item_tbl(i).schedule_date,

Line 511: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> $ 0 cash item created(-) ');

507: p_cust_ship_site_id => p_cust_ship_site_id,
508: p_sob_id => p_sob_id,
509: p_curr_code => p_curr_code,
510: p_rate => p_rate);
511: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> $ 0 cash item created(-) ');
512: END IF;
513:
514: /*E.N. Bug 4956314 */
515:

Line 526: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT (-) ');

522: norm_end_date = p_norm_end_dt
523: WHERE normalize ='Y'
524: AND payment_term_id = p_term_id;
525:
526: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT (-) ');
527: EXCEPTION
528: WHEN OTHERS THEN
529: pnp_debug_pkg.log(' RENORMALIZE_ACROSS_ALL_DRAFT - OTHERS ERROR ... ' || sqlerrm);
530:

Line 667: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_IN_FIRST_DRAFT (+) ');

663:
664: l_org_id NUMBER;
665:
666: BEGIN
667: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_IN_FIRST_DRAFT (+) ');
668: pnp_debug_pkg.log(' Procedure called with Parameters... ');
669: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
670: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
671: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );

Line 952: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> create $ 0 cash items(+)');

948: l_cash_item:=1;
949: END LOOP;
950:
951: IF l_cash_item = 0 THEN
952: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> create $ 0 cash items(+)');
953: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> for schedule id : '||g_norm_item_tbl(i).schedule_id);
954: pn_schedules_items.create_cash_items
955: (p_est_amt => 0,
956: p_act_amt => 0,

Line 953: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> for schedule id : '||g_norm_item_tbl(i).schedule_id);

949: END LOOP;
950:
951: IF l_cash_item = 0 THEN
952: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> create $ 0 cash items(+)');
953: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> for schedule id : '||g_norm_item_tbl(i).schedule_id);
954: pn_schedules_items.create_cash_items
955: (p_est_amt => 0,
956: p_act_amt => 0,
957: p_sch_dt => g_norm_item_tbl(i).schedule_date,

Line 968: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> $ 0 cash item created(-) ');

964: p_cust_ship_site_id => p_cust_ship_site_id,
965: p_sob_id => p_sob_id,
966: p_curr_code => p_curr_code,
967: p_rate => p_rate);
968: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> $ 0 cash item created(-) ');
969: END IF;
970:
971: /*E.N. Bug 4956314 */
972:

Line 983: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_IN_FIRST_DRAFT (-) ');

979: norm_end_date = p_norm_end_dt
980: WHERE normalize ='Y'
981: AND payment_term_id = p_term_id;
982:
983: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_IN_FIRST_DRAFT (-) ');
984: EXCEPTION
985: WHEN OTHERS THEN
986: pnp_debug_pkg.log(' RENORMALIZE_IN_FIRST_DRAFT - OTHERS ERROR ... ' || sqlerrm);
987:

Line 1075: pnp_debug_pkg.log('PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE (+) ');

1071: lp_norm_str_dt pn_payment_terms_all.norm_start_date%TYPE := NULL;
1072:
1073:
1074: BEGIN
1075: pnp_debug_pkg.log('PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE (+) ');
1076:
1077: SELECT change_commencement_date
1078: INTO l_amd_comn_date
1079: FROM

Line 1188: pnp_debug_pkg.log('PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE (-) ');

1184: END IF;
1185:
1186: END IF;
1187:
1188: pnp_debug_pkg.log('PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE (-) ');
1189: EXCEPTION
1190: WHEN OTHERS THEN
1191: pnp_debug_pkg.log(' NORMALIZE_RENORMALIZE - OTHERS ERROR ... ' || sqlerrm);
1192:

Line 1196: END PN_NORM_RENORM_PKG;

1192:
1193: END NORMALIZE_RENORMALIZE;
1194:
1195:
1196: END PN_NORM_RENORM_PKG;