125:
126: l_org_id NUMBER;
127:
128: BEGIN
129: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT (+) ');
130: pnp_debug_pkg.log(' Procedure called with Parameters... ');
131: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
132: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
133: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
126: l_org_id NUMBER;
127:
128: BEGIN
129: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT (+) ');
130: pnp_debug_pkg.log(' Procedure called with Parameters... ');
131: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
132: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
133: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
134: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
127:
128: BEGIN
129: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT (+) ');
130: pnp_debug_pkg.log(' Procedure called with Parameters... ');
131: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
132: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
133: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
134: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
135: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
128: BEGIN
129: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT (+) ');
130: pnp_debug_pkg.log(' Procedure called with Parameters... ');
131: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
132: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
133: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
134: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
135: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
136: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
129: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT (+) ');
130: pnp_debug_pkg.log(' Procedure called with Parameters... ');
131: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
132: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
133: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
134: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
135: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
136: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
137: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
130: pnp_debug_pkg.log(' Procedure called with Parameters... ');
131: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
132: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
133: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
134: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
135: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
136: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
137: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
138: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
131: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
132: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
133: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
134: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
135: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
136: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
137: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
138: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
139: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
132: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
133: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
134: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
135: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
136: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
137: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
138: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
139: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
140: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
133: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
134: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
135: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
136: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
137: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
138: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
139: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
140: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
141: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
134: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
135: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
136: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
137: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
138: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
139: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
140: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
141: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
142: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
135: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
136: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
137: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
138: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
139: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
140: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
141: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
142: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
143: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );
136: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
137: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
138: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
139: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
140: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
141: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
142: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
143: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );
144: pnp_debug_pkg.log(' p_rate : ' || p_rate );
137: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
138: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
139: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
140: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
141: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
142: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
143: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );
144: pnp_debug_pkg.log(' p_rate : ' || p_rate );
145:
138: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
139: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
140: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
141: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
142: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
143: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );
144: pnp_debug_pkg.log(' p_rate : ' || p_rate );
145:
146: /* initilizations*/
139: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
140: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
141: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
142: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
143: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );
144: pnp_debug_pkg.log(' p_rate : ' || p_rate );
145:
146: /* initilizations*/
147: l_partial_start_flag := FALSE;
140: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
141: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
142: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
143: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );
144: pnp_debug_pkg.log(' p_rate : ' || p_rate );
145:
146: /* initilizations*/
147: l_partial_start_flag := FALSE;
148: l_partial_end_flag := FALSE;
367: l_cash_item:=1;
368: END LOOP;
369:
370: IF l_cash_item = 0 THEN
371: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> create $ 0 cash items(+)');
372: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> for schedule id : '||g_norm_item_tbl(i).schedule_id);
373: pn_schedules_items.create_cash_items
374: (p_est_amt => 0,
375: p_act_amt => 0,
368: END LOOP;
369:
370: IF l_cash_item = 0 THEN
371: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> create $ 0 cash items(+)');
372: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> for schedule id : '||g_norm_item_tbl(i).schedule_id);
373: pn_schedules_items.create_cash_items
374: (p_est_amt => 0,
375: p_act_amt => 0,
376: p_sch_dt => g_norm_item_tbl(i).schedule_date,
383: p_cust_ship_site_id => p_cust_ship_site_id,
384: p_sob_id => p_sob_id,
385: p_curr_code => p_curr_code,
386: p_rate => p_rate);
387: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> $ 0 cash item created(-) ');
388: END IF;
389:
390: /*E.N. Bug 4956314 */
391:
398: norm_end_date = p_norm_end_dt
399: WHERE normalize ='Y'
400: AND payment_term_id = p_term_id;
401:
402: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT (-) ');
403: EXCEPTION
404: WHEN OTHERS THEN
405: pnp_debug_pkg.log(' RENORMALIZE_ACROSS_ALL_DRAFT - OTHERS ERROR ... ' || sqlerrm);
406:
401:
402: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT (-) ');
403: EXCEPTION
404: WHEN OTHERS THEN
405: pnp_debug_pkg.log(' RENORMALIZE_ACROSS_ALL_DRAFT - OTHERS ERROR ... ' || sqlerrm);
406:
407: END RENORMALIZE_ACROSS_ALL_DRAFT;
408:
409:
539:
540: l_org_id NUMBER;
541:
542: BEGIN
543: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_IN_FIRST_DRAFT (+) ');
544: pnp_debug_pkg.log(' Procedure called with Parameters... ');
545: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
546: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
547: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
540: l_org_id NUMBER;
541:
542: BEGIN
543: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_IN_FIRST_DRAFT (+) ');
544: pnp_debug_pkg.log(' Procedure called with Parameters... ');
545: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
546: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
547: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
548: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
541:
542: BEGIN
543: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_IN_FIRST_DRAFT (+) ');
544: pnp_debug_pkg.log(' Procedure called with Parameters... ');
545: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
546: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
547: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
548: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
549: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
542: BEGIN
543: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_IN_FIRST_DRAFT (+) ');
544: pnp_debug_pkg.log(' Procedure called with Parameters... ');
545: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
546: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
547: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
548: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
549: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
550: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
543: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_IN_FIRST_DRAFT (+) ');
544: pnp_debug_pkg.log(' Procedure called with Parameters... ');
545: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
546: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
547: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
548: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
549: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
550: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
551: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
544: pnp_debug_pkg.log(' Procedure called with Parameters... ');
545: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
546: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
547: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
548: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
549: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
550: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
551: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
552: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
545: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
546: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
547: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
548: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
549: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
550: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
551: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
552: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
553: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
546: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
547: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
548: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
549: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
550: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
551: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
552: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
553: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
554: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
547: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
548: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
549: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
550: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
551: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
552: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
553: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
554: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
555: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
548: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
549: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
550: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
551: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
552: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
553: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
554: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
555: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
556: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
549: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
550: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
551: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
552: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
553: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
554: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
555: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
556: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
557: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );
550: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
551: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
552: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
553: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
554: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
555: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
556: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
557: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );
558: pnp_debug_pkg.log(' p_rate : ' || p_rate );
551: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
552: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
553: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
554: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
555: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
556: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
557: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );
558: pnp_debug_pkg.log(' p_rate : ' || p_rate );
559:
552: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
553: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
554: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
555: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
556: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
557: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );
558: pnp_debug_pkg.log(' p_rate : ' || p_rate );
559:
560: /* initilizations*/
553: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
554: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
555: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
556: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
557: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );
558: pnp_debug_pkg.log(' p_rate : ' || p_rate );
559:
560: /* initilizations*/
561: l_partial_start_flag := FALSE;
554: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
555: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
556: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
557: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );
558: pnp_debug_pkg.log(' p_rate : ' || p_rate );
559:
560: /* initilizations*/
561: l_partial_start_flag := FALSE;
562: l_partial_end_flag := FALSE;
824: l_cash_item:=1;
825: END LOOP;
826:
827: IF l_cash_item = 0 THEN
828: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> create $ 0 cash items(+)');
829: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> for schedule id : '||g_norm_item_tbl(i).schedule_id);
830: pn_schedules_items.create_cash_items
831: (p_est_amt => 0,
832: p_act_amt => 0,
825: END LOOP;
826:
827: IF l_cash_item = 0 THEN
828: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> create $ 0 cash items(+)');
829: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> for schedule id : '||g_norm_item_tbl(i).schedule_id);
830: pn_schedules_items.create_cash_items
831: (p_est_amt => 0,
832: p_act_amt => 0,
833: p_sch_dt => g_norm_item_tbl(i).schedule_date,
840: p_cust_ship_site_id => p_cust_ship_site_id,
841: p_sob_id => p_sob_id,
842: p_curr_code => p_curr_code,
843: p_rate => p_rate);
844: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> $ 0 cash item created(-) ');
845: END IF;
846:
847: /*E.N. Bug 4956314 */
848:
855: norm_end_date = p_norm_end_dt
856: WHERE normalize ='Y'
857: AND payment_term_id = p_term_id;
858:
859: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_IN_FIRST_DRAFT (-) ');
860: EXCEPTION
861: WHEN OTHERS THEN
862: pnp_debug_pkg.log(' RENORMALIZE_IN_FIRST_DRAFT - OTHERS ERROR ... ' || sqlerrm);
863:
858:
859: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_IN_FIRST_DRAFT (-) ');
860: EXCEPTION
861: WHEN OTHERS THEN
862: pnp_debug_pkg.log(' RENORMALIZE_IN_FIRST_DRAFT - OTHERS ERROR ... ' || sqlerrm);
863:
864: END RENORMALIZE_IN_FIRST_DRAFT;
865:
866: /*------------------------------------------------------------------------------
941: l_norm_str_dt pn_payment_terms_all.norm_start_date%TYPE;
942:
943:
944: BEGIN
945: pnp_debug_pkg.log('PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE (+) ');
946:
947: FOR rec IN org_cur LOOP
948: l_org_id := rec.org_id;
949: END LOOP;
1021: END IF;
1022:
1023: END IF;
1024:
1025: pnp_debug_pkg.log('PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE (-) ');
1026: EXCEPTION
1027: WHEN OTHERS THEN
1028: pnp_debug_pkg.log(' NORMALIZE_RENORMALIZE - OTHERS ERROR ... ' || sqlerrm);
1029:
1024:
1025: pnp_debug_pkg.log('PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE (-) ');
1026: EXCEPTION
1027: WHEN OTHERS THEN
1028: pnp_debug_pkg.log(' NORMALIZE_RENORMALIZE - OTHERS ERROR ... ' || sqlerrm);
1029:
1030: END NORMALIZE_RENORMALIZE;
1031:
1032: