DBA Data[Home] [Help]

APPS.PN_VARIABLE_AMOUNT_PKG dependencies on FND_MESSAGE

Line 276: fnd_message.set_name ('PN','PN_VRAM_LN_NO');

272: /* get all the line items for the period */
273:
274: FOR rec_get_lines in csr_get_lines(p_line_item_id)
275: LOOP
276: fnd_message.set_name ('PN','PN_VRAM_LN_NO');
277: fnd_message.set_token ('NUM',rec_get_lines.line_item_num);
278: pnp_debug_pkg.put_log_msg(fnd_message.get);
279:
280: pnp_debug_pkg.log('process_variable_rent - Period id :'||rec_get_lines.period_id);

Line 277: fnd_message.set_token ('NUM',rec_get_lines.line_item_num);

273:
274: FOR rec_get_lines in csr_get_lines(p_line_item_id)
275: LOOP
276: fnd_message.set_name ('PN','PN_VRAM_LN_NO');
277: fnd_message.set_token ('NUM',rec_get_lines.line_item_num);
278: pnp_debug_pkg.put_log_msg(fnd_message.get);
279:
280: pnp_debug_pkg.log('process_variable_rent - Period id :'||rec_get_lines.period_id);
281: pnp_debug_pkg.log('process_variable_rent - Line item id : '||rec_get_lines.line_item_id);

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

274: FOR rec_get_lines in csr_get_lines(p_line_item_id)
275: LOOP
276: fnd_message.set_name ('PN','PN_VRAM_LN_NO');
277: fnd_message.set_token ('NUM',rec_get_lines.line_item_num);
278: pnp_debug_pkg.put_log_msg(fnd_message.get);
279:
280: pnp_debug_pkg.log('process_variable_rent - Period id :'||rec_get_lines.period_id);
281: pnp_debug_pkg.log('process_variable_rent - Line item id : '||rec_get_lines.line_item_id);
282:

Line 557: fnd_message.set_name ('PN','PN_SOI_INV_DT');

553: END LOOP;
554:
555:
556: pnp_debug_pkg.put_log_msg('===============================================================================');
557: fnd_message.set_name ('PN','PN_SOI_INV_DT');
558: fnd_message.set_token ('DATE',g_invoice_date);
559: pnp_debug_pkg.put_log_msg(fnd_message.get);
560:
561: fnd_message.set_name ('PN','PN_VRAM_GRP_DATE');

Line 558: fnd_message.set_token ('DATE',g_invoice_date);

554:
555:
556: pnp_debug_pkg.put_log_msg('===============================================================================');
557: fnd_message.set_name ('PN','PN_SOI_INV_DT');
558: fnd_message.set_token ('DATE',g_invoice_date);
559: pnp_debug_pkg.put_log_msg(fnd_message.get);
560:
561: fnd_message.set_name ('PN','PN_VRAM_GRP_DATE');
562: fnd_message.set_token ('DATE',l_group_date);

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

555:
556: pnp_debug_pkg.put_log_msg('===============================================================================');
557: fnd_message.set_name ('PN','PN_SOI_INV_DT');
558: fnd_message.set_token ('DATE',g_invoice_date);
559: pnp_debug_pkg.put_log_msg(fnd_message.get);
560:
561: fnd_message.set_name ('PN','PN_VRAM_GRP_DATE');
562: fnd_message.set_token ('DATE',l_group_date);
563: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 561: fnd_message.set_name ('PN','PN_VRAM_GRP_DATE');

557: fnd_message.set_name ('PN','PN_SOI_INV_DT');
558: fnd_message.set_token ('DATE',g_invoice_date);
559: pnp_debug_pkg.put_log_msg(fnd_message.get);
560:
561: fnd_message.set_name ('PN','PN_VRAM_GRP_DATE');
562: fnd_message.set_token ('DATE',l_group_date);
563: pnp_debug_pkg.put_log_msg(fnd_message.get);
564: pnp_debug_pkg.put_log_msg('===============================================================================');
565:

Line 562: fnd_message.set_token ('DATE',l_group_date);

558: fnd_message.set_token ('DATE',g_invoice_date);
559: pnp_debug_pkg.put_log_msg(fnd_message.get);
560:
561: fnd_message.set_name ('PN','PN_VRAM_GRP_DATE');
562: fnd_message.set_token ('DATE',l_group_date);
563: pnp_debug_pkg.put_log_msg(fnd_message.get);
564: pnp_debug_pkg.put_log_msg('===============================================================================');
565:
566: /* Initialize variables with total volume AND deduction*/

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

559: pnp_debug_pkg.put_log_msg(fnd_message.get);
560:
561: fnd_message.set_name ('PN','PN_VRAM_GRP_DATE');
562: fnd_message.set_token ('DATE',l_group_date);
563: pnp_debug_pkg.put_log_msg(fnd_message.get);
564: pnp_debug_pkg.put_log_msg('===============================================================================');
565:
566: /* Initialize variables with total volume AND deduction*/
567:

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

890:
891: l_varrent_exists := find_varrent_exists(
892: p_line_item_id => p_line_item_id,
893: p_grp_date_id => p_grp_date_id);
894: fnd_message.set_name ('PN','PN_VRAM_RENT');
895: fnd_message.set_token ('TYPE',INITCAP(g_rent_TYPE));
896: fnd_message.set_token ('AMT',l_var_rent);
897: pnp_debug_pkg.put_log_msg(fnd_message.get);
898:

Line 895: fnd_message.set_token ('TYPE',INITCAP(g_rent_TYPE));

891: l_varrent_exists := find_varrent_exists(
892: p_line_item_id => p_line_item_id,
893: p_grp_date_id => p_grp_date_id);
894: fnd_message.set_name ('PN','PN_VRAM_RENT');
895: fnd_message.set_token ('TYPE',INITCAP(g_rent_TYPE));
896: fnd_message.set_token ('AMT',l_var_rent);
897: pnp_debug_pkg.put_log_msg(fnd_message.get);
898:
899: IF NVL(l_varrent_exists,'N') = 'N' THEN

Line 896: fnd_message.set_token ('AMT',l_var_rent);

892: p_line_item_id => p_line_item_id,
893: p_grp_date_id => p_grp_date_id);
894: fnd_message.set_name ('PN','PN_VRAM_RENT');
895: fnd_message.set_token ('TYPE',INITCAP(g_rent_TYPE));
896: fnd_message.set_token ('AMT',l_var_rent);
897: pnp_debug_pkg.put_log_msg(fnd_message.get);
898:
899: IF NVL(l_varrent_exists,'N') = 'N' THEN
900:

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

893: p_grp_date_id => p_grp_date_id);
894: fnd_message.set_name ('PN','PN_VRAM_RENT');
895: fnd_message.set_token ('TYPE',INITCAP(g_rent_TYPE));
896: fnd_message.set_token ('AMT',l_var_rent);
897: pnp_debug_pkg.put_log_msg(fnd_message.get);
898:
899: IF NVL(l_varrent_exists,'N') = 'N' THEN
900:
901: select pn_var_rent_SUMm_s.nextval

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

2391: BEGIN
2392: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent_batch (+)' );
2393: g_period_date := NVL(fnd_date.canonical_to_date(p_period_date),TO_DATE('12/31/4712','mm/dd/yyyy'));
2394:
2395: fnd_message.set_name ('PN','PN_VRAM_PRM');
2396: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
2397: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
2398: fnd_message.set_token ('LOC_FRM', p_location_code_from);
2399: fnd_message.set_token ('LOC_TO', p_location_code_to);

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

2392: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent_batch (+)' );
2393: g_period_date := NVL(fnd_date.canonical_to_date(p_period_date),TO_DATE('12/31/4712','mm/dd/yyyy'));
2394:
2395: fnd_message.set_name ('PN','PN_VRAM_PRM');
2396: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
2397: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
2398: fnd_message.set_token ('LOC_FRM', p_location_code_from);
2399: fnd_message.set_token ('LOC_TO', p_location_code_to);
2400: fnd_message.set_token ('VR_FRM', p_vrent_num_from);

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

2393: g_period_date := NVL(fnd_date.canonical_to_date(p_period_date),TO_DATE('12/31/4712','mm/dd/yyyy'));
2394:
2395: fnd_message.set_name ('PN','PN_VRAM_PRM');
2396: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
2397: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
2398: fnd_message.set_token ('LOC_FRM', p_location_code_from);
2399: fnd_message.set_token ('LOC_TO', p_location_code_to);
2400: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
2401: fnd_message.set_token ('VR_TO', p_vrent_num_to);

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

2394:
2395: fnd_message.set_name ('PN','PN_VRAM_PRM');
2396: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
2397: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
2398: fnd_message.set_token ('LOC_FRM', p_location_code_from);
2399: fnd_message.set_token ('LOC_TO', p_location_code_to);
2400: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
2401: fnd_message.set_token ('VR_TO', p_vrent_num_to);
2402: fnd_message.set_token ('PRD_FRM', p_period_num_from);

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

2395: fnd_message.set_name ('PN','PN_VRAM_PRM');
2396: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
2397: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
2398: fnd_message.set_token ('LOC_FRM', p_location_code_from);
2399: fnd_message.set_token ('LOC_TO', p_location_code_to);
2400: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
2401: fnd_message.set_token ('VR_TO', p_vrent_num_to);
2402: fnd_message.set_token ('PRD_FRM', p_period_num_from);
2403: fnd_message.set_token ('PRD_TO', p_period_num_to);

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

2396: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
2397: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
2398: fnd_message.set_token ('LOC_FRM', p_location_code_from);
2399: fnd_message.set_token ('LOC_TO', p_location_code_to);
2400: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
2401: fnd_message.set_token ('VR_TO', p_vrent_num_to);
2402: fnd_message.set_token ('PRD_FRM', p_period_num_from);
2403: fnd_message.set_token ('PRD_TO', p_period_num_to);
2404: fnd_message.set_token ('USR', p_responsible_user);

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

2397: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
2398: fnd_message.set_token ('LOC_FRM', p_location_code_from);
2399: fnd_message.set_token ('LOC_TO', p_location_code_to);
2400: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
2401: fnd_message.set_token ('VR_TO', p_vrent_num_to);
2402: fnd_message.set_token ('PRD_FRM', p_period_num_from);
2403: fnd_message.set_token ('PRD_TO', p_period_num_to);
2404: fnd_message.set_token ('USR', p_responsible_user);
2405: fnd_message.set_token ('DATE', p_period_date);

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

2398: fnd_message.set_token ('LOC_FRM', p_location_code_from);
2399: fnd_message.set_token ('LOC_TO', p_location_code_to);
2400: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
2401: fnd_message.set_token ('VR_TO', p_vrent_num_to);
2402: fnd_message.set_token ('PRD_FRM', p_period_num_from);
2403: fnd_message.set_token ('PRD_TO', p_period_num_to);
2404: fnd_message.set_token ('USR', p_responsible_user);
2405: fnd_message.set_token ('DATE', p_period_date);
2406: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

2399: fnd_message.set_token ('LOC_TO', p_location_code_to);
2400: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
2401: fnd_message.set_token ('VR_TO', p_vrent_num_to);
2402: fnd_message.set_token ('PRD_FRM', p_period_num_from);
2403: fnd_message.set_token ('PRD_TO', p_period_num_to);
2404: fnd_message.set_token ('USR', p_responsible_user);
2405: fnd_message.set_token ('DATE', p_period_date);
2406: pnp_debug_pkg.put_log_msg(fnd_message.get);
2407:

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

2400: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
2401: fnd_message.set_token ('VR_TO', p_vrent_num_to);
2402: fnd_message.set_token ('PRD_FRM', p_period_num_from);
2403: fnd_message.set_token ('PRD_TO', p_period_num_to);
2404: fnd_message.set_token ('USR', p_responsible_user);
2405: fnd_message.set_token ('DATE', p_period_date);
2406: pnp_debug_pkg.put_log_msg(fnd_message.get);
2407:
2408: pnp_debug_pkg.log ('process_rent_batch - Calculation TYPE : ' || p_calc_TYPE);

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

2401: fnd_message.set_token ('VR_TO', p_vrent_num_to);
2402: fnd_message.set_token ('PRD_FRM', p_period_num_from);
2403: fnd_message.set_token ('PRD_TO', p_period_num_to);
2404: fnd_message.set_token ('USR', p_responsible_user);
2405: fnd_message.set_token ('DATE', p_period_date);
2406: pnp_debug_pkg.put_log_msg(fnd_message.get);
2407:
2408: pnp_debug_pkg.log ('process_rent_batch - Calculation TYPE : ' || p_calc_TYPE);
2409:

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

2402: fnd_message.set_token ('PRD_FRM', p_period_num_from);
2403: fnd_message.set_token ('PRD_TO', p_period_num_to);
2404: fnd_message.set_token ('USR', p_responsible_user);
2405: fnd_message.set_token ('DATE', p_period_date);
2406: pnp_debug_pkg.put_log_msg(fnd_message.get);
2407:
2408: pnp_debug_pkg.log ('process_rent_batch - Calculation TYPE : ' || p_calc_TYPE);
2409:
2410:

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

2455: FETCH csr_get_vrent_woloc INTO l_var_rent_id,l_invoice_on,l_cumulative,l_rent_num,g_org_id;
2456: EXIT WHEN csr_get_vrent_woloc%NOTFOUND;
2457: END IF;
2458:
2459: fnd_message.set_name ('PN','PN_VRAM_VRN_PROC');
2460: fnd_message.set_token ('NUM',l_rent_num);
2461: pnp_debug_pkg.put_log_msg(fnd_message.get);
2462:
2463: pnp_debug_pkg.log ('process_rent_batch - Variable Rent id :'||l_var_rent_id);

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

2456: EXIT WHEN csr_get_vrent_woloc%NOTFOUND;
2457: END IF;
2458:
2459: fnd_message.set_name ('PN','PN_VRAM_VRN_PROC');
2460: fnd_message.set_token ('NUM',l_rent_num);
2461: pnp_debug_pkg.put_log_msg(fnd_message.get);
2462:
2463: pnp_debug_pkg.log ('process_rent_batch - Variable Rent id :'||l_var_rent_id);
2464: pnp_debug_pkg.log ('process_rent_batch - org_id :'||g_org_id);

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

2457: END IF;
2458:
2459: fnd_message.set_name ('PN','PN_VRAM_VRN_PROC');
2460: fnd_message.set_token ('NUM',l_rent_num);
2461: pnp_debug_pkg.put_log_msg(fnd_message.get);
2462:
2463: pnp_debug_pkg.log ('process_rent_batch - Variable Rent id :'||l_var_rent_id);
2464: pnp_debug_pkg.log ('process_rent_batch - org_id :'||g_org_id);
2465:

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

2490:
2491: FOR rec_get_per in csr_get_per(l_var_rent_id)
2492: LOOP
2493:
2494: fnd_message.set_name ('PN','PN_VRAM_PRD_PROC');
2495: fnd_message.set_token ('NUM',rec_get_per.period_num);
2496: pnp_debug_pkg.put_log_msg(fnd_message.get);
2497:
2498: pnp_debug_pkg.log ('process_rent_batch - period st date : '||rec_get_per.start_date);

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

2491: FOR rec_get_per in csr_get_per(l_var_rent_id)
2492: LOOP
2493:
2494: fnd_message.set_name ('PN','PN_VRAM_PRD_PROC');
2495: fnd_message.set_token ('NUM',rec_get_per.period_num);
2496: pnp_debug_pkg.put_log_msg(fnd_message.get);
2497:
2498: pnp_debug_pkg.log ('process_rent_batch - period st date : '||rec_get_per.start_date);
2499: pnp_debug_pkg.log ('process_rent_batch - period end date: '||rec_get_per.end_date);

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

2492: LOOP
2493:
2494: fnd_message.set_name ('PN','PN_VRAM_PRD_PROC');
2495: fnd_message.set_token ('NUM',rec_get_per.period_num);
2496: pnp_debug_pkg.put_log_msg(fnd_message.get);
2497:
2498: pnp_debug_pkg.log ('process_rent_batch - period st date : '||rec_get_per.start_date);
2499: pnp_debug_pkg.log ('process_rent_batch - period end date: '||rec_get_per.end_date);
2500: