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.5.12010000.6 2008/12/15 06:32:08 acprakas ship $
3:
4: /* procedure spec for the private procedures */
5: PROCEDURE RENORMALIZE_ACROSS_ALL_DRAFT

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

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 );

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

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,

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

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,

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

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:

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

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:

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

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 );

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

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,

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

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,

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

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:

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

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:

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

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;

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

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:

Line 1033: END PN_NORM_RENORM_PKG;

1029:
1030: END NORMALIZE_RENORMALIZE;
1031:
1032:
1033: END PN_NORM_RENORM_PKG;