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_TRX_PKG dependencies on PNP_DEBUG_PKG

Line 1161: pnp_debug_pkg.log('');

1157: l_context VARCHAR2(255);
1158:
1159: BEGIN
1160:
1161: pnp_debug_pkg.log('');
1162: pnp_debug_pkg.log('--- pn_var_trx_pkg.populate_blended_grp_vol START ---');
1163: pnp_debug_pkg.log('');
1164:
1165: /* get proration RULE */

Line 1162: pnp_debug_pkg.log('--- pn_var_trx_pkg.populate_blended_grp_vol START ---');

1158:
1159: BEGIN
1160:
1161: pnp_debug_pkg.log('');
1162: pnp_debug_pkg.log('--- pn_var_trx_pkg.populate_blended_grp_vol START ---');
1163: pnp_debug_pkg.log('');
1164:
1165: /* get proration RULE */
1166: IF p_proration_rule IS NULL THEN

Line 1163: pnp_debug_pkg.log('');

1159: BEGIN
1160:
1161: pnp_debug_pkg.log('');
1162: pnp_debug_pkg.log('--- pn_var_trx_pkg.populate_blended_grp_vol START ---');
1163: pnp_debug_pkg.log('');
1164:
1165: /* get proration RULE */
1166: IF p_proration_rule IS NULL THEN
1167:

Line 1178: pnp_debug_pkg.log('VR ID: '||p_var_rent_id||

1174: l_vr_proration_rule := p_proration_rule;
1175:
1176: END IF;
1177:
1178: pnp_debug_pkg.log('VR ID: '||p_var_rent_id||
1179: ' Proration Rule: '||l_vr_proration_rule);
1180: pnp_debug_pkg.log('');
1181:
1182: l_counter1 := 1;

Line 1180: pnp_debug_pkg.log('');

1176: END IF;
1177:
1178: pnp_debug_pkg.log('VR ID: '||p_var_rent_id||
1179: ' Proration Rule: '||l_vr_proration_rule);
1180: pnp_debug_pkg.log('');
1181:
1182: l_counter1 := 1;
1183:
1184: /* fetch partial and full period details */

Line 1218: pnp_debug_pkg.log(l_context||' COMPLETE');

1214: l_counter1 := l_counter1 + 1;
1215:
1216: END LOOP;
1217:
1218: pnp_debug_pkg.log(l_context||' COMPLETE');
1219: pnp_debug_pkg.log('Part period Start Date: '||l_part_prd_start_dt);
1220: pnp_debug_pkg.log('Part period Length: '||l_part_prd_length);
1221: pnp_debug_pkg.log('Full period Start Date: '||l_full_prd_start_dt);
1222: pnp_debug_pkg.log('Full period Length: '||l_part_prd_start_dt);

Line 1219: pnp_debug_pkg.log('Part period Start Date: '||l_part_prd_start_dt);

1215:
1216: END LOOP;
1217:
1218: pnp_debug_pkg.log(l_context||' COMPLETE');
1219: pnp_debug_pkg.log('Part period Start Date: '||l_part_prd_start_dt);
1220: pnp_debug_pkg.log('Part period Length: '||l_part_prd_length);
1221: pnp_debug_pkg.log('Full period Start Date: '||l_full_prd_start_dt);
1222: pnp_debug_pkg.log('Full period Length: '||l_part_prd_start_dt);
1223: pnp_debug_pkg.log('');

Line 1220: pnp_debug_pkg.log('Part period Length: '||l_part_prd_length);

1216: END LOOP;
1217:
1218: pnp_debug_pkg.log(l_context||' COMPLETE');
1219: pnp_debug_pkg.log('Part period Start Date: '||l_part_prd_start_dt);
1220: pnp_debug_pkg.log('Part period Length: '||l_part_prd_length);
1221: pnp_debug_pkg.log('Full period Start Date: '||l_full_prd_start_dt);
1222: pnp_debug_pkg.log('Full period Length: '||l_part_prd_start_dt);
1223: pnp_debug_pkg.log('');
1224:

Line 1221: pnp_debug_pkg.log('Full period Start Date: '||l_full_prd_start_dt);

1217:
1218: pnp_debug_pkg.log(l_context||' COMPLETE');
1219: pnp_debug_pkg.log('Part period Start Date: '||l_part_prd_start_dt);
1220: pnp_debug_pkg.log('Part period Length: '||l_part_prd_length);
1221: pnp_debug_pkg.log('Full period Start Date: '||l_full_prd_start_dt);
1222: pnp_debug_pkg.log('Full period Length: '||l_part_prd_start_dt);
1223: pnp_debug_pkg.log('');
1224:
1225: IF l_vr_proration_rule = pn_var_trx_pkg.G_PRORUL_CYP THEN

Line 1222: pnp_debug_pkg.log('Full period Length: '||l_part_prd_start_dt);

1218: pnp_debug_pkg.log(l_context||' COMPLETE');
1219: pnp_debug_pkg.log('Part period Start Date: '||l_part_prd_start_dt);
1220: pnp_debug_pkg.log('Part period Length: '||l_part_prd_length);
1221: pnp_debug_pkg.log('Full period Start Date: '||l_full_prd_start_dt);
1222: pnp_debug_pkg.log('Full period Length: '||l_part_prd_start_dt);
1223: pnp_debug_pkg.log('');
1224:
1225: IF l_vr_proration_rule = pn_var_trx_pkg.G_PRORUL_CYP THEN
1226:

Line 1223: pnp_debug_pkg.log('');

1219: pnp_debug_pkg.log('Part period Start Date: '||l_part_prd_start_dt);
1220: pnp_debug_pkg.log('Part period Length: '||l_part_prd_length);
1221: pnp_debug_pkg.log('Full period Start Date: '||l_full_prd_start_dt);
1222: pnp_debug_pkg.log('Full period Length: '||l_part_prd_start_dt);
1223: pnp_debug_pkg.log('');
1224:
1225: IF l_vr_proration_rule = pn_var_trx_pkg.G_PRORUL_CYP THEN
1226:
1227: l_context := 'CYP - update invoice_flag';

Line 1252: pnp_debug_pkg.log(l_context||' COMPLETE');

1248: var_rent_id = p_var_rent_id AND
1249: period_id IN (l_part_prd_id, l_full_prd_id)
1250: );
1251:
1252: pnp_debug_pkg.log(l_context||' COMPLETE');
1253: pnp_debug_pkg.log('');
1254:
1255:
1256: l_context := 'CYP - update pr_grp_blended_vol_start - end';

Line 1253: pnp_debug_pkg.log('');

1249: period_id IN (l_part_prd_id, l_full_prd_id)
1250: );
1251:
1252: pnp_debug_pkg.log(l_context||' COMPLETE');
1253: pnp_debug_pkg.log('');
1254:
1255:
1256: l_context := 'CYP - update pr_grp_blended_vol_start - end';
1257: /* reset pr_grp_blended_vol_start - pr_grp_blended_vol_end */

Line 1287: pnp_debug_pkg.log(l_context||' COMPLETE');

1283: var_rent_id = p_var_rent_id AND
1284: period_id IN (l_part_prd_id, l_full_prd_id)
1285: );
1286:
1287: pnp_debug_pkg.log(l_context||' COMPLETE');
1288: pnp_debug_pkg.log('');
1289:
1290: /* populate blended_period_vol_start - blended_period_vol_end */
1291: l_context := 'CYP - update blended_period_vol_start - end';

Line 1288: pnp_debug_pkg.log('');

1284: period_id IN (l_part_prd_id, l_full_prd_id)
1285: );
1286:
1287: pnp_debug_pkg.log(l_context||' COMPLETE');
1288: pnp_debug_pkg.log('');
1289:
1290: /* populate blended_period_vol_start - blended_period_vol_end */
1291: l_context := 'CYP - update blended_period_vol_start - end';
1292:

Line 1317: pnp_debug_pkg.log(l_context||' COMPLETE');

1313: bkpt_rate = cyp_rec.bkpt_rate;
1314:
1315: END LOOP;
1316:
1317: pnp_debug_pkg.log(l_context||' COMPLETE');
1318: pnp_debug_pkg.log('');
1319:
1320: ELSIF l_vr_proration_rule = pn_var_trx_pkg.G_PRORUL_CYNP THEN
1321:

Line 1318: pnp_debug_pkg.log('');

1314:
1315: END LOOP;
1316:
1317: pnp_debug_pkg.log(l_context||' COMPLETE');
1318: pnp_debug_pkg.log('');
1319:
1320: ELSIF l_vr_proration_rule = pn_var_trx_pkg.G_PRORUL_CYNP THEN
1321:
1322: l_context := 'CYNP - update invoice_flag';

Line 1348: pnp_debug_pkg.log(l_context||' COMPLETE');

1344: var_rent_id = p_var_rent_id AND
1345: period_id IN (l_part_prd_id, l_full_prd_id)
1346: );
1347:
1348: pnp_debug_pkg.log(l_context||' COMPLETE');
1349: pnp_debug_pkg.log('');
1350:
1351: l_context
1352: := 'CYNP - update pr_grp_blended_vol_start - end, blended_period_vol_start - end';

Line 1349: pnp_debug_pkg.log('');

1345: period_id IN (l_part_prd_id, l_full_prd_id)
1346: );
1347:
1348: pnp_debug_pkg.log(l_context||' COMPLETE');
1349: pnp_debug_pkg.log('');
1350:
1351: l_context
1352: := 'CYNP - update pr_grp_blended_vol_start - end, blended_period_vol_start - end';
1353: /* reset pr_grp_blended_vol_start - pr_grp_blended_vol_end */

Line 1401: pnp_debug_pkg.log(l_context||' COMPLETE');

1397: bkpt_rate = cynp_rec.bkpt_rate;
1398:
1399: END LOOP;
1400:
1401: pnp_debug_pkg.log(l_context||' COMPLETE');
1402: pnp_debug_pkg.log('');
1403:
1404: l_context
1405: := 'CYNP - update pr_grp_blended_vol_start - end for first/last partial';

Line 1402: pnp_debug_pkg.log('');

1398:
1399: END LOOP;
1400:
1401: pnp_debug_pkg.log(l_context||' COMPLETE');
1402: pnp_debug_pkg.log('');
1403:
1404: l_context
1405: := 'CYNP - update pr_grp_blended_vol_start - end for first/last partial';
1406:

Line 1451: pnp_debug_pkg.log(l_context||' COMPLETE');

1447: trx_header_id = last_part_rec.trx_header_id;
1448:
1449: END LOOP;
1450:
1451: pnp_debug_pkg.log(l_context||' COMPLETE');
1452: pnp_debug_pkg.log('');
1453:
1454: END IF;
1455:

Line 1452: pnp_debug_pkg.log('');

1448:
1449: END LOOP;
1450:
1451: pnp_debug_pkg.log(l_context||' COMPLETE');
1452: pnp_debug_pkg.log('');
1453:
1454: END IF;
1455:
1456: pnp_debug_pkg.log('');

Line 1456: pnp_debug_pkg.log('');

1452: pnp_debug_pkg.log('');
1453:
1454: END IF;
1455:
1456: pnp_debug_pkg.log('');
1457: pnp_debug_pkg.log('--- pn_var_trx_pkg.populate_blended_grp_vol START ---');
1458: pnp_debug_pkg.log('');
1459:
1460: EXCEPTION

Line 1457: pnp_debug_pkg.log('--- pn_var_trx_pkg.populate_blended_grp_vol START ---');

1453:
1454: END IF;
1455:
1456: pnp_debug_pkg.log('');
1457: pnp_debug_pkg.log('--- pn_var_trx_pkg.populate_blended_grp_vol START ---');
1458: pnp_debug_pkg.log('');
1459:
1460: EXCEPTION
1461: WHEN OTHERS THEN

Line 1458: pnp_debug_pkg.log('');

1454: END IF;
1455:
1456: pnp_debug_pkg.log('');
1457: pnp_debug_pkg.log('--- pn_var_trx_pkg.populate_blended_grp_vol START ---');
1458: pnp_debug_pkg.log('');
1459:
1460: EXCEPTION
1461: WHEN OTHERS THEN
1462: pnp_debug_pkg.log

Line 1462: pnp_debug_pkg.log

1458: pnp_debug_pkg.log('');
1459:
1460: EXCEPTION
1461: WHEN OTHERS THEN
1462: pnp_debug_pkg.log
1463: ('**********************************************************************');
1464: pnp_debug_pkg.log('*** ERROR IN calculate_rent ***');
1465: pnp_debug_pkg.log('*** ERROR WHEN: '||l_context||' ***');
1466: pnp_debug_pkg.log

Line 1464: pnp_debug_pkg.log('* ERROR IN calculate_rent *');

1460: EXCEPTION
1461: WHEN OTHERS THEN
1462: pnp_debug_pkg.log
1463: ('**********************************************************************');
1464: pnp_debug_pkg.log('*** ERROR IN calculate_rent ***');
1465: pnp_debug_pkg.log('*** ERROR WHEN: '||l_context||' ***');
1466: pnp_debug_pkg.log
1467: ('**********************************************************************');
1468: RAISE;

Line 1465: pnp_debug_pkg.log('* ERROR WHEN: '||l_context||' *');

1461: WHEN OTHERS THEN
1462: pnp_debug_pkg.log
1463: ('**********************************************************************');
1464: pnp_debug_pkg.log('*** ERROR IN calculate_rent ***');
1465: pnp_debug_pkg.log('*** ERROR WHEN: '||l_context||' ***');
1466: pnp_debug_pkg.log
1467: ('**********************************************************************');
1468: RAISE;
1469:

Line 1466: pnp_debug_pkg.log

1462: pnp_debug_pkg.log
1463: ('**********************************************************************');
1464: pnp_debug_pkg.log('*** ERROR IN calculate_rent ***');
1465: pnp_debug_pkg.log('*** ERROR WHEN: '||l_context||' ***');
1466: pnp_debug_pkg.log
1467: ('**********************************************************************');
1468: RAISE;
1469:
1470: END populate_blended_grp_vol;

Line 1754: pnp_debug_pkg.log('line_rec.period_id - '||line_rec.period_id);

1750: ,ytd_grp_vol_end_t;
1751:
1752: CLOSE ytd_group_vol1_c;
1753: END IF;
1754: pnp_debug_pkg.log('line_rec.period_id - '||line_rec.period_id);
1755: pnp_debug_pkg.log('line_rec.line_item_id- '||line_rec.line_item_id);
1756:
1757:
1758: FORALL i IN 1..trx_detail_t.COUNT

Line 1755: pnp_debug_pkg.log('line_rec.line_item_id- '||line_rec.line_item_id);

1751:
1752: CLOSE ytd_group_vol1_c;
1753: END IF;
1754: pnp_debug_pkg.log('line_rec.period_id - '||line_rec.period_id);
1755: pnp_debug_pkg.log('line_rec.line_item_id- '||line_rec.line_item_id);
1756:
1757:
1758: FORALL i IN 1..trx_detail_t.COUNT
1759: UPDATE

Line 2089: pnp_debug_pkg.log('Deleting for lines');

2085: IF p_line_item_id IS NOT NULL AND
2086: p_period_id IS NOT NULL AND
2087: p_var_rent_id IS NOT NULL
2088: THEN
2089: pnp_debug_pkg.log('Deleting for lines');
2090: DELETE
2091: pn_var_trx_details_all
2092: WHERE
2093: trx_header_id IN

Line 2114: pnp_debug_pkg.log('Deleting for periods');

2110: ELSIF p_line_item_id IS NULL AND
2111: p_period_id IS NOT NULL AND
2112: p_var_rent_id IS NOT NULL
2113: THEN
2114: pnp_debug_pkg.log('Deleting for periods');
2115: DELETE
2116: pn_var_trx_details_all
2117: WHERE
2118: trx_header_id IN

Line 2137: pnp_debug_pkg.log('Deleting for VR');

2133: ELSIF p_line_item_id IS NULL AND
2134: p_period_id IS NULL AND
2135: p_var_rent_id IS NOT NULL
2136: THEN
2137: pnp_debug_pkg.log('Deleting for VR');
2138: DELETE
2139: pn_var_trx_details_all
2140: WHERE
2141: trx_header_id IN

Line 2426: pnp_debug_pkg.log

2422: l_max_end_date DATE;
2423:
2424: BEGIN
2425:
2426: pnp_debug_pkg.log
2427: ('+++++++++++++ pn_var_trx_pkg.populate_transactions START +++++++++++++');
2428:
2429: /* lock the line items */
2430: l_line_items_lock4bkpt_t.DELETE;

Line 2826: pnp_debug_pkg.log('Trx updated');

2822: END LOOP; /* loop for all periods */
2823:
2824: /* get the grp IDs right if any trx was updated */
2825: IF l_trx_create_upd_flag THEN
2826: pnp_debug_pkg.log('Trx updated');
2827: /* groups the lines across the periods */
2828: pn_var_trx_pkg.populate_line_grp_id(p_var_rent_id => p_var_rent_id);
2829:
2830: /* populate the reset group IDs */

Line 2837: pnp_debug_pkg.log('line_item_id:'||for_data_t(i).line_item_id);

2833: ly_pr_grp_vol_start - end,
2834: invoice_flag
2835: for FY, LY, FLY */
2836: FOR i in 1..for_data_t.COUNT LOOP
2837: pnp_debug_pkg.log('line_item_id:'||for_data_t(i).line_item_id);
2838: pnp_debug_pkg.log('grp_date_id:'||for_data_t(i).grp_date_id);
2839: pnp_debug_pkg.log('reset_group_id:'||for_data_t(i).reset_group_id);
2840: pnp_debug_pkg.log('var_rent_id:'||for_data_t(i).var_rent_id);
2841: pnp_debug_pkg.log('REPORTING_GROUP_SALES_FOR:'||for_data_t(i).REPORTING_GROUP_SALES_FOR);

Line 2838: pnp_debug_pkg.log('grp_date_id:'||for_data_t(i).grp_date_id);

2834: invoice_flag
2835: for FY, LY, FLY */
2836: FOR i in 1..for_data_t.COUNT LOOP
2837: pnp_debug_pkg.log('line_item_id:'||for_data_t(i).line_item_id);
2838: pnp_debug_pkg.log('grp_date_id:'||for_data_t(i).grp_date_id);
2839: pnp_debug_pkg.log('reset_group_id:'||for_data_t(i).reset_group_id);
2840: pnp_debug_pkg.log('var_rent_id:'||for_data_t(i).var_rent_id);
2841: pnp_debug_pkg.log('REPORTING_GROUP_SALES_FOR:'||for_data_t(i).REPORTING_GROUP_SALES_FOR);
2842: pnp_debug_pkg.log('CALCULATED_RENT_FOR:'||for_data_t(i).CALCULATED_RENT_FOR);

Line 2839: pnp_debug_pkg.log('reset_group_id:'||for_data_t(i).reset_group_id);

2835: for FY, LY, FLY */
2836: FOR i in 1..for_data_t.COUNT LOOP
2837: pnp_debug_pkg.log('line_item_id:'||for_data_t(i).line_item_id);
2838: pnp_debug_pkg.log('grp_date_id:'||for_data_t(i).grp_date_id);
2839: pnp_debug_pkg.log('reset_group_id:'||for_data_t(i).reset_group_id);
2840: pnp_debug_pkg.log('var_rent_id:'||for_data_t(i).var_rent_id);
2841: pnp_debug_pkg.log('REPORTING_GROUP_SALES_FOR:'||for_data_t(i).REPORTING_GROUP_SALES_FOR);
2842: pnp_debug_pkg.log('CALCULATED_RENT_FOR:'||for_data_t(i).CALCULATED_RENT_FOR);
2843:

Line 2840: pnp_debug_pkg.log('var_rent_id:'||for_data_t(i).var_rent_id);

2836: FOR i in 1..for_data_t.COUNT LOOP
2837: pnp_debug_pkg.log('line_item_id:'||for_data_t(i).line_item_id);
2838: pnp_debug_pkg.log('grp_date_id:'||for_data_t(i).grp_date_id);
2839: pnp_debug_pkg.log('reset_group_id:'||for_data_t(i).reset_group_id);
2840: pnp_debug_pkg.log('var_rent_id:'||for_data_t(i).var_rent_id);
2841: pnp_debug_pkg.log('REPORTING_GROUP_SALES_FOR:'||for_data_t(i).REPORTING_GROUP_SALES_FOR);
2842: pnp_debug_pkg.log('CALCULATED_RENT_FOR:'||for_data_t(i).CALCULATED_RENT_FOR);
2843:
2844: UPDATE

Line 2841: pnp_debug_pkg.log('REPORTING_GROUP_SALES_FOR:'||for_data_t(i).REPORTING_GROUP_SALES_FOR);

2837: pnp_debug_pkg.log('line_item_id:'||for_data_t(i).line_item_id);
2838: pnp_debug_pkg.log('grp_date_id:'||for_data_t(i).grp_date_id);
2839: pnp_debug_pkg.log('reset_group_id:'||for_data_t(i).reset_group_id);
2840: pnp_debug_pkg.log('var_rent_id:'||for_data_t(i).var_rent_id);
2841: pnp_debug_pkg.log('REPORTING_GROUP_SALES_FOR:'||for_data_t(i).REPORTING_GROUP_SALES_FOR);
2842: pnp_debug_pkg.log('CALCULATED_RENT_FOR:'||for_data_t(i).CALCULATED_RENT_FOR);
2843:
2844: UPDATE
2845: pn_var_trx_headers_all

Line 2842: pnp_debug_pkg.log('CALCULATED_RENT_FOR:'||for_data_t(i).CALCULATED_RENT_FOR);

2838: pnp_debug_pkg.log('grp_date_id:'||for_data_t(i).grp_date_id);
2839: pnp_debug_pkg.log('reset_group_id:'||for_data_t(i).reset_group_id);
2840: pnp_debug_pkg.log('var_rent_id:'||for_data_t(i).var_rent_id);
2841: pnp_debug_pkg.log('REPORTING_GROUP_SALES_FOR:'||for_data_t(i).REPORTING_GROUP_SALES_FOR);
2842: pnp_debug_pkg.log('CALCULATED_RENT_FOR:'||for_data_t(i).CALCULATED_RENT_FOR);
2843:
2844: UPDATE
2845: pn_var_trx_headers_all
2846: SET

Line 2903: pnp_debug_pkg.log(' call pn_var_trx_pkg.populate_ytd_pro_vol'); /* 8616530 */

2899: ,p_proration_rule => l_proration_rule);
2900:
2901: END IF;
2902:
2903: pnp_debug_pkg.log(' call pn_var_trx_pkg.populate_ytd_pro_vol'); /* 8616530 */
2904: /* ALWAYS populate the ytd_group_vol_start - end - useful */
2905: pn_var_trx_pkg.populate_ytd_pro_vol
2906: ( p_var_rent_id => p_var_rent_id
2907: ,p_proration_rule => l_proration_rule);

Line 3628: pnp_debug_pkg.log('++++ pn_var_trx_pkg.populate_ytd_sales START ++++');

3624: ytd_sales_t NUM_T;
3625:
3626: BEGIN
3627:
3628: pnp_debug_pkg.log('++++ pn_var_trx_pkg.populate_ytd_sales START ++++');
3629:
3630: /* get VR details */
3631: IF p_proration_rule IS NULL THEN
3632:

Line 3645: pnp_debug_pkg.log('Called with: ');

3641: l_proration_rule := p_proration_rule;
3642:
3643: END IF;
3644:
3645: pnp_debug_pkg.log('Called with: ');
3646: pnp_debug_pkg.log(' p_var_rent_id: '||p_var_rent_id);
3647: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);
3648:
3649: /* l_proration_rule based decisions */

Line 3646: pnp_debug_pkg.log(' p_var_rent_id: '||p_var_rent_id);

3642:
3643: END IF;
3644:
3645: pnp_debug_pkg.log('Called with: ');
3646: pnp_debug_pkg.log(' p_var_rent_id: '||p_var_rent_id);
3647: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);
3648:
3649: /* l_proration_rule based decisions */
3650: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY

Line 3647: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);

3643: END IF;
3644:
3645: pnp_debug_pkg.log('Called with: ');
3646: pnp_debug_pkg.log(' p_var_rent_id: '||p_var_rent_id);
3647: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);
3648:
3649: /* l_proration_rule based decisions */
3650: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
3651: ,pn_var_trx_pkg.G_PRORUL_LY

Line 5159: pnp_debug_pkg.log('++++ pn_var_trx_pkg.populate_ytd_deductions START ++++');

5155: ytd_deductions_t NUM_T;
5156:
5157: BEGIN
5158:
5159: pnp_debug_pkg.log('++++ pn_var_trx_pkg.populate_ytd_deductions START ++++');
5160:
5161: /* get VR details */
5162: IF p_proration_rule IS NULL THEN
5163:

Line 5176: pnp_debug_pkg.log('Called with: ');

5172: l_proration_rule := p_proration_rule;
5173:
5174: END IF;
5175:
5176: pnp_debug_pkg.log('Called with: ');
5177: pnp_debug_pkg.log(' p_var_rent_id: '||p_var_rent_id);
5178: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);
5179:
5180: /* l_proration_rule based decisions */

Line 5177: pnp_debug_pkg.log(' p_var_rent_id: '||p_var_rent_id);

5173:
5174: END IF;
5175:
5176: pnp_debug_pkg.log('Called with: ');
5177: pnp_debug_pkg.log(' p_var_rent_id: '||p_var_rent_id);
5178: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);
5179:
5180: /* l_proration_rule based decisions */
5181: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY

Line 5178: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);

5174: END IF;
5175:
5176: pnp_debug_pkg.log('Called with: ');
5177: pnp_debug_pkg.log(' p_var_rent_id: '||p_var_rent_id);
5178: pnp_debug_pkg.log(' l_proration_rule: '||l_proration_rule);
5179:
5180: /* l_proration_rule based decisions */
5181: IF l_proration_rule IN ( pn_var_trx_pkg.G_PRORUL_FY
5182: ,pn_var_trx_pkg.G_PRORUL_LY