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.PN_VAR_DEFAULTS_PKG dependencies on PNP_DEBUG_PKG

Line 374: pnp_debug_pkg.debug(' create_default_constraints +');

370: where period_id = p_periodId;
371:
372: BEGIN
373:
374: pnp_debug_pkg.debug(' create_default_constraints +');
375: l_var_rent_id := X_VAR_RENT_ID;
376:
377: FOR c2_rec IN c2 LOOP
378: FOR c1_rec IN c1 (c2_rec.constr_start_date,

Line 444: PNp_debug_pkg.debug(' create_default_constraints +');

440: END LOOP;
441:
442: END LOOP;
443:
444: PNp_debug_pkg.debug(' create_default_constraints +');
445:
446: END create_default_constraints;
447:
448: /*===========================================================================+

Line 657: --pnp_debug_pkg.enable_file_debug(l_pathname,l_filename);

653: WHERE var_rent_id = p_var_rent_id;
654: --AND break_type = 'NATURAL';
655:
656: BEGIN
657: --pnp_debug_pkg.enable_file_debug(l_pathname,l_filename);
658: PNP_DEBUG_PKG.log('PN_VAR_DEFAULTS_PKG.CREATE_DEFAULT_LINES (+)');
659: l_var_rent_id := x_var_rent_id;
660: PNP_DEBUG_PKG.log('Parameter : x_var_rent_id = '|| l_var_rent_id);
661: FOR c_period_rec IN c_periods

Line 658: PNP_DEBUG_PKG.log('PN_VAR_DEFAULTS_PKG.CREATE_DEFAULT_LINES (+)');

654: --AND break_type = 'NATURAL';
655:
656: BEGIN
657: --pnp_debug_pkg.enable_file_debug(l_pathname,l_filename);
658: PNP_DEBUG_PKG.log('PN_VAR_DEFAULTS_PKG.CREATE_DEFAULT_LINES (+)');
659: l_var_rent_id := x_var_rent_id;
660: PNP_DEBUG_PKG.log('Parameter : x_var_rent_id = '|| l_var_rent_id);
661: FOR c_period_rec IN c_periods
662: LOOP

Line 660: PNP_DEBUG_PKG.log('Parameter : x_var_rent_id = '|| l_var_rent_id);

656: BEGIN
657: --pnp_debug_pkg.enable_file_debug(l_pathname,l_filename);
658: PNP_DEBUG_PKG.log('PN_VAR_DEFAULTS_PKG.CREATE_DEFAULT_LINES (+)');
659: l_var_rent_id := x_var_rent_id;
660: PNP_DEBUG_PKG.log('Parameter : x_var_rent_id = '|| l_var_rent_id);
661: FOR c_period_rec IN c_periods
662: LOOP
663: PNP_DEBUG_PKG.log('Processing Period => '|| c_period_rec.period_id || ' ' ||
664: c_period_rec.start_date || ' '||

Line 663: PNP_DEBUG_PKG.log('Processing Period => '|| c_period_rec.period_id || ' ' ||

659: l_var_rent_id := x_var_rent_id;
660: PNP_DEBUG_PKG.log('Parameter : x_var_rent_id = '|| l_var_rent_id);
661: FOR c_period_rec IN c_periods
662: LOOP
663: PNP_DEBUG_PKG.log('Processing Period => '|| c_period_rec.period_id || ' ' ||
664: c_period_rec.start_date || ' '||
665: c_period_rec.end_date || ' ' ||
666: c_period_rec.reptg_freq_code);
667: l_reporting_periods := NVL(pn_var_rent_pkg.find_reporting_periods(

Line 670: PNP_DEBUG_PKG.log( 'l_reporting_periods = '|| l_reporting_periods);

666: c_period_rec.reptg_freq_code);
667: l_reporting_periods := NVL(pn_var_rent_pkg.find_reporting_periods(
668: p_freq_code => c_period_rec.reptg_freq_code),1);
669:
670: PNP_DEBUG_PKG.log( 'l_reporting_periods = '|| l_reporting_periods);
671: FOR c_line_rec IN c_lines (c_period_rec.start_date, c_period_rec.end_date)
672: LOOP
673: PNP_DEBUG_PKG.log('Processing line Default ID: ' || c_line_rec.line_default_id);
674: l_rowid := NULL;

Line 673: PNP_DEBUG_PKG.log('Processing line Default ID: ' || c_line_rec.line_default_id);

669:
670: PNP_DEBUG_PKG.log( 'l_reporting_periods = '|| l_reporting_periods);
671: FOR c_line_rec IN c_lines (c_period_rec.start_date, c_period_rec.end_date)
672: LOOP
673: PNP_DEBUG_PKG.log('Processing line Default ID: ' || c_line_rec.line_default_id);
674: l_rowid := NULL;
675: l_line_item_id := NULL;
676: l_line_item_num := NULL;
677: l_dummy := NULL;

Line 756: --PNP_DEBUG_PKG.log('X_CREATE_FLAG:'|| X_CREATE_FLAG);

752: AND var_rent_id = l_var_rent_id
753: AND ROWNUM = 1;
754: END IF;
755:
756: --PNP_DEBUG_PKG.log('X_CREATE_FLAG:'|| X_CREATE_FLAG);
757: --PNP_DEBUG_PKG.log('Line Item ID:'|| l_line_item_id);
758: IF X_CREATE_FLAG = 'N' THEN
759: FOR c_head_rec IN c_bkheads (c_line_rec.line_default_id)
760: LOOP

Line 757: --PNP_DEBUG_PKG.log('Line Item ID:'|| l_line_item_id);

753: AND ROWNUM = 1;
754: END IF;
755:
756: --PNP_DEBUG_PKG.log('X_CREATE_FLAG:'|| X_CREATE_FLAG);
757: --PNP_DEBUG_PKG.log('Line Item ID:'|| l_line_item_id);
758: IF X_CREATE_FLAG = 'N' THEN
759: FOR c_head_rec IN c_bkheads (c_line_rec.line_default_id)
760: LOOP
761: PNP_DEBUG_PKG.log('Processing header for Line Default =' || c_line_rec.line_default_id);

Line 761: PNP_DEBUG_PKG.log('Processing header for Line Default =' || c_line_rec.line_default_id);

757: --PNP_DEBUG_PKG.log('Line Item ID:'|| l_line_item_id);
758: IF X_CREATE_FLAG = 'N' THEN
759: FOR c_head_rec IN c_bkheads (c_line_rec.line_default_id)
760: LOOP
761: PNP_DEBUG_PKG.log('Processing header for Line Default =' || c_line_rec.line_default_id);
762: l_rowid := NULL;
763: l_bkpt_header_id := NULL;
764: l_bkhd_start_date := NULL;
765: l_bkhd_end_Date := NULL;

Line 806: PNP_DEBUG_PKG.log('Processing detail for Header Default = '|| c_head_rec.bkhd_default_id);

802: x_bkpt_update_flag => c_head_rec.bkpt_update_flag);
803:
804: FOR c_det_rec IN c_bkdets (c_head_rec.bkhd_default_id)
805: LOOP
806: PNP_DEBUG_PKG.log('Processing detail for Header Default = '|| c_head_rec.bkhd_default_id);
807:
808: IF c_det_rec.bkdt_start_date > c_period_rec.start_date THEN
809: l_period_start := c_det_rec.bkdt_start_date;
810: ELSE

Line 923: PNP_DEBUG_PKG.log('Processing Natural header for Line Default =' || c_line_rec.line_default_id);

919:
920: ELSE
921: FOR c_head_rec IN c_bkheads_natural (c_line_rec.line_default_id)
922: LOOP
923: PNP_DEBUG_PKG.log('Processing Natural header for Line Default =' || c_line_rec.line_default_id);
924: l_rowid := NULL;
925: l_bkpt_header_id := NULL;
926: l_bkhd_start_date := NULL;
927: l_bkhd_end_Date := NULL;

Line 973: PNP_DEBUG_PKG.log('Processing Natural detail for Header Default = '|| c_head_rec.bkhd_default_id);

969: END;
970:
971: FOR c_det_rec IN c_bkdets_natural (c_head_rec.bkhd_default_id)
972: LOOP
973: PNP_DEBUG_PKG.log('Processing Natural detail for Header Default = '|| c_head_rec.bkhd_default_id);
974: IF c_det_rec.bkdt_start_date > c_period_rec.start_date THEN
975: l_period_start := c_det_rec.bkdt_start_date;
976: ELSE
977: l_period_start := c_period_rec.start_date;

Line 1137: --PNP_DEBUG_PKG.disable_file_debug;

1133: DELETE FROM pn_var_bkpts_head_all
1134: WHERE var_rent_id = l_var_rent_id
1135: AND bkhd_start_date IS NULL
1136: AND bkhd_end_date IS NULL;
1137: --PNP_DEBUG_PKG.disable_file_debug;
1138: PNP_DEBUG_PKG.log('PN_VAR_DEFAULTS_PKG.CREATE_DEFAULT_LINES (-)');
1139:
1140: end create_default_lines;
1141:

Line 1138: PNP_DEBUG_PKG.log('PN_VAR_DEFAULTS_PKG.CREATE_DEFAULT_LINES (-)');

1134: WHERE var_rent_id = l_var_rent_id
1135: AND bkhd_start_date IS NULL
1136: AND bkhd_end_date IS NULL;
1137: --PNP_DEBUG_PKG.disable_file_debug;
1138: PNP_DEBUG_PKG.log('PN_VAR_DEFAULTS_PKG.CREATE_DEFAULT_LINES (-)');
1139:
1140: end create_default_lines;
1141:
1142: /*===========================================================================+

Line 1473: PNP_DEBUG_PKG.debug ('PN_VAR_DEFAULTS_PKG.calculate_partial_first_year (+)');

1469: l_proration_days NUMBER := 0;
1470:
1471: BEGIN
1472:
1473: PNP_DEBUG_PKG.debug ('PN_VAR_DEFAULTS_PKG.calculate_partial_first_year (+)');
1474:
1475: /*open csr_check_no_days (X_VAR_RENT_ID);
1476: fetch csr_check_no_days into l_start_date, l_end_date, l_reporting_date;
1477: close csr_check_no_days;

Line 1505: PNP_DEBUG_PKG.debug ('PN_VAR_DEFAULTS_PKG.calculate_partial_first_year (-)');

1501: NULL;
1502:
1503: RETURN l_sum_sales;
1504:
1505: PNP_DEBUG_PKG.debug ('PN_VAR_DEFAULTS_PKG.calculate_partial_first_year (-)');
1506:
1507: END calculate_partial_first_year;
1508:
1509: /*===========================================================================+

Line 1544: PNP_DEBUG_PKG.debug ('PN_VAR_DEFAULTS_PKG.CALCULATE_DEFAULT_BASE_RENT (+)');

1540: l_base_rent NUMBER;
1541:
1542: BEGIN
1543:
1544: PNP_DEBUG_PKG.debug ('PN_VAR_DEFAULTS_PKG.CALCULATE_DEFAULT_BASE_RENT (+)');
1545:
1546: IF (p_base_rent_type = 'ROLLING') THEN
1547:
1548: SELECT sum(item.ACTUAL_AMOUNT)

Line 1595: PNP_DEBUG_PKG.debug ('PN_VAR_DEFAULTS_PKG.CALCULATE_DEFAULT_BASE_RENT (-)');

1591: WHEN OTHERS
1592: THEN
1593: RETURN NULL;
1594:
1595: PNP_DEBUG_PKG.debug ('PN_VAR_DEFAULTS_PKG.CALCULATE_DEFAULT_BASE_RENT (-)');
1596:
1597: END CALCULATE_DEFAULT_BASE_RENT;
1598:
1599: /*===========================================================================+

Line 1664: PNP_DEBUG_PKG.debug ('PN_VAR_DEFAULTS_PKG.calculate_partial_last_year (+)');

1660: l_proration_days NUMBER := 0;
1661:
1662: BEGIN
1663:
1664: PNP_DEBUG_PKG.debug ('PN_VAR_DEFAULTS_PKG.calculate_partial_last_year (+)');
1665:
1666: /*open csr_check_no_days (X_VAR_RENT_ID);
1667: fetch csr_check_no_days into l_reporting_date, l_start_date, l_end_date;
1668: close csr_check_no_days;

Line 1696: PNP_DEBUG_PKG.debug ('PN_VAR_DEFAULTS_PKG.calcuLate_partial_last_year (-)');

1692: NULL;
1693:
1694: RETURN l_sum_sales;
1695:
1696: PNP_DEBUG_PKG.debug ('PN_VAR_DEFAULTS_PKG.calcuLate_partial_last_year (-)');
1697:
1698: END calculate_partial_last_year;
1699:
1700: FUNCTION find_if_line_defaults_exist (p_var_rent_id NUMBER)

Line 2130: PNP_DEBUG_PKG.log('PN_VAR_DEFAULTS_PKG.CREATE_SETUP_DATA (+)');

2126: where bkhd_default_id = p_bkhd_def_id);
2127:
2128: BEGIN
2129:
2130: PNP_DEBUG_PKG.log('PN_VAR_DEFAULTS_PKG.CREATE_SETUP_DATA (+)');
2131: /* dbms_output.put_line('PN_VAR_DEFAULTS_PKG.CREATE_SETUP_DATA (+)'); */
2132:
2133: l_var_rent_id := x_var_rent_id;
2134:

Line 2367: PNP_DEBUG_PKG.log('PN_VAR_DEFAULTS_PKG.CREATE_SETUP_DATA (-)');

2363: UPDATE pn_var_lines_all
2364: SET bkpt_update_flag = 'Y'
2365: WHERE var_rent_id = l_var_rent_id;
2366:
2367: PNP_DEBUG_PKG.log('PN_VAR_DEFAULTS_PKG.CREATE_SETUP_DATA (-)');
2368:
2369: END CREATE_SETUP_DATA;
2370:
2371:

Line 2375: pnp_debug_pkg.debug(p_str);

2371:
2372: PROCEDURE put_log(p_str VARCHAR2) IS
2373:
2374: BEGIN
2375: pnp_debug_pkg.debug(p_str);
2376: END put_log;
2377:
2378: END PN_VAR_DEFAULTS_PKG;
2379: