DBA Data[Home] [Help]

APPS.PN_VAR_RENT_CALC_PKG dependencies on FND_MESSAGE

Line 4597: fnd_message.set_name ('PN','PN_VRAM_RENT');

4593: from pn_var_rent_inv_all
4594: where period_id = l_periods_t(p).period_id
4595: and var_rent_id = p_var_rent_id;
4596:
4597: fnd_message.set_name ('PN','PN_VRAM_RENT');
4598: fnd_message.set_token ('TYPE','ACTUAL');
4599: fnd_message.set_token ('AMT',l_actual_amount);
4600: pnp_debug_pkg.put_log_msg(fnd_message.get);
4601:

Line 4598: fnd_message.set_token ('TYPE','ACTUAL');

4594: where period_id = l_periods_t(p).period_id
4595: and var_rent_id = p_var_rent_id;
4596:
4597: fnd_message.set_name ('PN','PN_VRAM_RENT');
4598: fnd_message.set_token ('TYPE','ACTUAL');
4599: fnd_message.set_token ('AMT',l_actual_amount);
4600: pnp_debug_pkg.put_log_msg(fnd_message.get);
4601:
4602: END LOOP;

Line 4599: fnd_message.set_token ('AMT',l_actual_amount);

4595: and var_rent_id = p_var_rent_id;
4596:
4597: fnd_message.set_name ('PN','PN_VRAM_RENT');
4598: fnd_message.set_token ('TYPE','ACTUAL');
4599: fnd_message.set_token ('AMT',l_actual_amount);
4600: pnp_debug_pkg.put_log_msg(fnd_message.get);
4601:
4602: END LOOP;
4603: END IF;

Line 4600: pnp_debug_pkg.put_log_msg(fnd_message.get);

4596:
4597: fnd_message.set_name ('PN','PN_VRAM_RENT');
4598: fnd_message.set_token ('TYPE','ACTUAL');
4599: fnd_message.set_token ('AMT',l_actual_amount);
4600: pnp_debug_pkg.put_log_msg(fnd_message.get);
4601:
4602: END LOOP;
4603: END IF;
4604:

Line 6529: fnd_message.set_name ('PN','PN_VRAM_PRM');

6525:
6526: pnp_debug_pkg.log('pn_var_rent_calc_pkg.process_rent_batch (+)' );
6527:
6528:
6529: fnd_message.set_name ('PN','PN_VRAM_PRM');
6530: fnd_message.set_token ('PT_NAME', p_property_name);
6531: fnd_message.set_token ('PT_CODE', p_property_code);
6532: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6533: fnd_message.set_token ('LSNO_TO', p_lease_num_to);

Line 6530: fnd_message.set_token ('PT_NAME', p_property_name);

6526: pnp_debug_pkg.log('pn_var_rent_calc_pkg.process_rent_batch (+)' );
6527:
6528:
6529: fnd_message.set_name ('PN','PN_VRAM_PRM');
6530: fnd_message.set_token ('PT_NAME', p_property_name);
6531: fnd_message.set_token ('PT_CODE', p_property_code);
6532: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6533: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6534: fnd_message.set_token ('LOC_FRM', p_location_code_from);

Line 6531: fnd_message.set_token ('PT_CODE', p_property_code);

6527:
6528:
6529: fnd_message.set_name ('PN','PN_VRAM_PRM');
6530: fnd_message.set_token ('PT_NAME', p_property_name);
6531: fnd_message.set_token ('PT_CODE', p_property_code);
6532: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6533: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6534: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6535: fnd_message.set_token ('LOC_TO', p_location_code_to);

Line 6532: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);

6528:
6529: fnd_message.set_name ('PN','PN_VRAM_PRM');
6530: fnd_message.set_token ('PT_NAME', p_property_name);
6531: fnd_message.set_token ('PT_CODE', p_property_code);
6532: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6533: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6534: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6535: fnd_message.set_token ('LOC_TO', p_location_code_to);
6536: fnd_message.set_token ('VR_FRM', p_vrent_num_from);

Line 6533: fnd_message.set_token ('LSNO_TO', p_lease_num_to);

6529: fnd_message.set_name ('PN','PN_VRAM_PRM');
6530: fnd_message.set_token ('PT_NAME', p_property_name);
6531: fnd_message.set_token ('PT_CODE', p_property_code);
6532: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6533: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6534: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6535: fnd_message.set_token ('LOC_TO', p_location_code_to);
6536: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6537: fnd_message.set_token ('VR_TO', p_vrent_num_to);

Line 6534: fnd_message.set_token ('LOC_FRM', p_location_code_from);

6530: fnd_message.set_token ('PT_NAME', p_property_name);
6531: fnd_message.set_token ('PT_CODE', p_property_code);
6532: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6533: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6534: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6535: fnd_message.set_token ('LOC_TO', p_location_code_to);
6536: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6537: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6538: fnd_message.set_token ('PRD_FRM', p_period_num_from);

Line 6535: fnd_message.set_token ('LOC_TO', p_location_code_to);

6531: fnd_message.set_token ('PT_CODE', p_property_code);
6532: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6533: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6534: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6535: fnd_message.set_token ('LOC_TO', p_location_code_to);
6536: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6537: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6538: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6539: fnd_message.set_token ('PRD_TO', p_period_num_to);

Line 6536: fnd_message.set_token ('VR_FRM', p_vrent_num_from);

6532: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6533: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6534: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6535: fnd_message.set_token ('LOC_TO', p_location_code_to);
6536: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6537: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6538: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6539: fnd_message.set_token ('PRD_TO', p_period_num_to);
6540: fnd_message.set_token ('USR', p_responsible_user);

Line 6537: fnd_message.set_token ('VR_TO', p_vrent_num_to);

6533: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6534: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6535: fnd_message.set_token ('LOC_TO', p_location_code_to);
6536: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6537: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6538: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6539: fnd_message.set_token ('PRD_TO', p_period_num_to);
6540: fnd_message.set_token ('USR', p_responsible_user);
6541: fnd_message.set_token ('DATE', p_period_date);

Line 6538: fnd_message.set_token ('PRD_FRM', p_period_num_from);

6534: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6535: fnd_message.set_token ('LOC_TO', p_location_code_to);
6536: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6537: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6538: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6539: fnd_message.set_token ('PRD_TO', p_period_num_to);
6540: fnd_message.set_token ('USR', p_responsible_user);
6541: fnd_message.set_token ('DATE', p_period_date);
6542: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 6539: fnd_message.set_token ('PRD_TO', p_period_num_to);

6535: fnd_message.set_token ('LOC_TO', p_location_code_to);
6536: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6537: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6538: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6539: fnd_message.set_token ('PRD_TO', p_period_num_to);
6540: fnd_message.set_token ('USR', p_responsible_user);
6541: fnd_message.set_token ('DATE', p_period_date);
6542: pnp_debug_pkg.put_log_msg(fnd_message.get);
6543:

Line 6540: fnd_message.set_token ('USR', p_responsible_user);

6536: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6537: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6538: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6539: fnd_message.set_token ('PRD_TO', p_period_num_to);
6540: fnd_message.set_token ('USR', p_responsible_user);
6541: fnd_message.set_token ('DATE', p_period_date);
6542: pnp_debug_pkg.put_log_msg(fnd_message.get);
6543:
6544: pnp_debug_pkg.log ('process_rent_batch - Calculation TYPE : ' || p_calc_TYPE);

Line 6541: fnd_message.set_token ('DATE', p_period_date);

6537: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6538: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6539: fnd_message.set_token ('PRD_TO', p_period_num_to);
6540: fnd_message.set_token ('USR', p_responsible_user);
6541: fnd_message.set_token ('DATE', p_period_date);
6542: pnp_debug_pkg.put_log_msg(fnd_message.get);
6543:
6544: pnp_debug_pkg.log ('process_rent_batch - Calculation TYPE : ' || p_calc_TYPE);
6545:

Line 6542: pnp_debug_pkg.put_log_msg(fnd_message.get);

6538: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6539: fnd_message.set_token ('PRD_TO', p_period_num_to);
6540: fnd_message.set_token ('USR', p_responsible_user);
6541: fnd_message.set_token ('DATE', p_period_date);
6542: pnp_debug_pkg.put_log_msg(fnd_message.get);
6543:
6544: pnp_debug_pkg.log ('process_rent_batch - Calculation TYPE : ' || p_calc_TYPE);
6545:
6546: IF p_property_name is not null and p_property_code is null THEN /* 9765197 */

Line 6592: fnd_message.set_name ('PN','PN_VAR_MANUAL_NOCALC');

6588:
6589: END IF;
6590:
6591: IF l_cumulative = 'M' THEN
6592: fnd_message.set_name ('PN','PN_VAR_MANUAL_NOCALC');
6593: fnd_message.set_token ('VR_NUM',l_rent_num);
6594: pnp_debug_pkg.put_log_msg(fnd_message.get);
6595: ELSE
6596: g_invoice_on := NVL(p_invoice_on,l_invoice_on);

Line 6593: fnd_message.set_token ('VR_NUM',l_rent_num);

6589: END IF;
6590:
6591: IF l_cumulative = 'M' THEN
6592: fnd_message.set_name ('PN','PN_VAR_MANUAL_NOCALC');
6593: fnd_message.set_token ('VR_NUM',l_rent_num);
6594: pnp_debug_pkg.put_log_msg(fnd_message.get);
6595: ELSE
6596: g_invoice_on := NVL(p_invoice_on,l_invoice_on);
6597: g_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(g_org_id),4);

Line 6594: pnp_debug_pkg.put_log_msg(fnd_message.get);

6590:
6591: IF l_cumulative = 'M' THEN
6592: fnd_message.set_name ('PN','PN_VAR_MANUAL_NOCALC');
6593: fnd_message.set_token ('VR_NUM',l_rent_num);
6594: pnp_debug_pkg.put_log_msg(fnd_message.get);
6595: ELSE
6596: g_invoice_on := NVL(p_invoice_on,l_invoice_on);
6597: g_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(g_org_id),4);
6598:

Line 6599: fnd_message.set_name ('PN','PN_VRAM_VRN_PROC');

6595: ELSE
6596: g_invoice_on := NVL(p_invoice_on,l_invoice_on);
6597: g_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(g_org_id),4);
6598:
6599: fnd_message.set_name ('PN','PN_VRAM_VRN_PROC');
6600: fnd_message.set_token ('NUM',l_rent_num);
6601: pnp_debug_pkg.put_log_msg(fnd_message.get);
6602:
6603: pnp_debug_pkg.log ('process_rent_batch - Variable Rent id :'||l_var_rent_id);

Line 6600: fnd_message.set_token ('NUM',l_rent_num);

6596: g_invoice_on := NVL(p_invoice_on,l_invoice_on);
6597: g_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(g_org_id),4);
6598:
6599: fnd_message.set_name ('PN','PN_VRAM_VRN_PROC');
6600: fnd_message.set_token ('NUM',l_rent_num);
6601: pnp_debug_pkg.put_log_msg(fnd_message.get);
6602:
6603: pnp_debug_pkg.log ('process_rent_batch - Variable Rent id :'||l_var_rent_id);
6604: pnp_debug_pkg.log ('process_rent_batch - org_id :'||g_org_id);

Line 6601: pnp_debug_pkg.put_log_msg(fnd_message.get);

6597: g_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(g_org_id),4);
6598:
6599: fnd_message.set_name ('PN','PN_VRAM_VRN_PROC');
6600: fnd_message.set_token ('NUM',l_rent_num);
6601: pnp_debug_pkg.put_log_msg(fnd_message.get);
6602:
6603: pnp_debug_pkg.log ('process_rent_batch - Variable Rent id :'||l_var_rent_id);
6604: pnp_debug_pkg.log ('process_rent_batch - org_id :'||g_org_id);
6605:

Line 6615: fnd_message.set_name ('PN','PN_VRAM_PRD_PROC');

6611:
6612: FOR rec_get_per in csr_get_per(l_var_rent_id)
6613: LOOP
6614:
6615: fnd_message.set_name ('PN','PN_VRAM_PRD_PROC');
6616: fnd_message.set_token ('NUM',rec_get_per.period_num);
6617: pnp_debug_pkg.put_log_msg(fnd_message.get);
6618:
6619: pnp_debug_pkg.log ('process_rent_batch - period st date : '||rec_get_per.start_date);

Line 6616: fnd_message.set_token ('NUM',rec_get_per.period_num);

6612: FOR rec_get_per in csr_get_per(l_var_rent_id)
6613: LOOP
6614:
6615: fnd_message.set_name ('PN','PN_VRAM_PRD_PROC');
6616: fnd_message.set_token ('NUM',rec_get_per.period_num);
6617: pnp_debug_pkg.put_log_msg(fnd_message.get);
6618:
6619: pnp_debug_pkg.log ('process_rent_batch - period st date : '||rec_get_per.start_date);
6620: pnp_debug_pkg.log ('process_rent_batch - period end date: '||rec_get_per.end_date);

Line 6617: pnp_debug_pkg.put_log_msg(fnd_message.get);

6613: LOOP
6614:
6615: fnd_message.set_name ('PN','PN_VRAM_PRD_PROC');
6616: fnd_message.set_token ('NUM',rec_get_per.period_num);
6617: pnp_debug_pkg.put_log_msg(fnd_message.get);
6618:
6619: pnp_debug_pkg.log ('process_rent_batch - period st date : '||rec_get_per.start_date);
6620: pnp_debug_pkg.log ('process_rent_batch - period end date: '||rec_get_per.end_date);
6621: