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_SOI_VOL_IMPORT dependencies on FND_MESSAGE

Line 213: fnd_message.set_name ('PN','PN_SOI_PBATCH');

209:
210: BEGIN
211:
212: pnp_debug_pkg.debug ('PN_SOI_VOL_IMPORT .IMPORT_VOL_HIST(+)');
213: fnd_message.set_name ('PN','PN_SOI_PBATCH');
214: fnd_message.set_token ('ID', p_batch_id);
215: pnp_debug_pkg.put_log_msg(fnd_message.get);
216:
217: l_imp_flag := 'N';

Line 214: fnd_message.set_token ('ID', p_batch_id);

210: BEGIN
211:
212: pnp_debug_pkg.debug ('PN_SOI_VOL_IMPORT .IMPORT_VOL_HIST(+)');
213: fnd_message.set_name ('PN','PN_SOI_PBATCH');
214: fnd_message.set_token ('ID', p_batch_id);
215: pnp_debug_pkg.put_log_msg(fnd_message.get);
216:
217: l_imp_flag := 'N';
218:

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

211:
212: pnp_debug_pkg.debug ('PN_SOI_VOL_IMPORT .IMPORT_VOL_HIST(+)');
213: fnd_message.set_name ('PN','PN_SOI_PBATCH');
214: fnd_message.set_token ('ID', p_batch_id);
215: pnp_debug_pkg.put_log_msg(fnd_message.get);
216:
217: l_imp_flag := 'N';
218:
219: OPEN c_all_lines_imprtd;

Line 248: fnd_message.set_name('PN', 'PN_SOI_VAR_RENT_INVALID');

244: OPEN c_var_rent(v_lines.var_rent_id);
245: FETCH c_var_rent into v_var_rent_id,v_var_rent_NUMBER,v_lease_name, l_org_id;
246:
247: IF c_var_rent%NOTFOUND THEN
248: fnd_message.set_name('PN', 'PN_SOI_VAR_RENT_INVALID');
249: l_error_message := fnd_message.get;
250: CLOSE c_var_rent;
251: RAISE INVALID_RECORD;
252: END IF;

Line 249: l_error_message := fnd_message.get;

245: FETCH c_var_rent into v_var_rent_id,v_var_rent_NUMBER,v_lease_name, l_org_id;
246:
247: IF c_var_rent%NOTFOUND THEN
248: fnd_message.set_name('PN', 'PN_SOI_VAR_RENT_INVALID');
249: l_error_message := fnd_message.get;
250: CLOSE c_var_rent;
251: RAISE INVALID_RECORD;
252: END IF;
253: CLOSE c_var_rent;

Line 256: fnd_message.set_name ('PN','PN_SOI_REP_DT_LOW');

252: END IF;
253: CLOSE c_var_rent;
254:
255: pnp_debug_pkg.put_log_msg('-------------------------------------------------------');
256: fnd_message.set_name ('PN','PN_SOI_REP_DT_LOW');
257: fnd_message.set_token ('DATE', TO_CHAR(v_Lines.rep_str_DATE,'MM/DD/YYYY'));
258: pnp_debug_pkg.put_log_msg(fnd_message.get);
259:
260: fnd_message.set_name ('PN','PN_SOI_REP_DT_HIGH');

Line 257: fnd_message.set_token ('DATE', TO_CHAR(v_Lines.rep_str_DATE,'MM/DD/YYYY'));

253: CLOSE c_var_rent;
254:
255: pnp_debug_pkg.put_log_msg('-------------------------------------------------------');
256: fnd_message.set_name ('PN','PN_SOI_REP_DT_LOW');
257: fnd_message.set_token ('DATE', TO_CHAR(v_Lines.rep_str_DATE,'MM/DD/YYYY'));
258: pnp_debug_pkg.put_log_msg(fnd_message.get);
259:
260: fnd_message.set_name ('PN','PN_SOI_REP_DT_HIGH');
261: fnd_message.set_token ('DATE', TO_CHAR(v_Lines.rep_end_DATE,'MM/DD/YYYY'));

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

254:
255: pnp_debug_pkg.put_log_msg('-------------------------------------------------------');
256: fnd_message.set_name ('PN','PN_SOI_REP_DT_LOW');
257: fnd_message.set_token ('DATE', TO_CHAR(v_Lines.rep_str_DATE,'MM/DD/YYYY'));
258: pnp_debug_pkg.put_log_msg(fnd_message.get);
259:
260: fnd_message.set_name ('PN','PN_SOI_REP_DT_HIGH');
261: fnd_message.set_token ('DATE', TO_CHAR(v_Lines.rep_end_DATE,'MM/DD/YYYY'));
262: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 260: fnd_message.set_name ('PN','PN_SOI_REP_DT_HIGH');

256: fnd_message.set_name ('PN','PN_SOI_REP_DT_LOW');
257: fnd_message.set_token ('DATE', TO_CHAR(v_Lines.rep_str_DATE,'MM/DD/YYYY'));
258: pnp_debug_pkg.put_log_msg(fnd_message.get);
259:
260: fnd_message.set_name ('PN','PN_SOI_REP_DT_HIGH');
261: fnd_message.set_token ('DATE', TO_CHAR(v_Lines.rep_end_DATE,'MM/DD/YYYY'));
262: pnp_debug_pkg.put_log_msg(fnd_message.get);
263:
264: pnp_debug_pkg.log('Variable Rent Id = '|| v_var_rent_id );

Line 261: fnd_message.set_token ('DATE', TO_CHAR(v_Lines.rep_end_DATE,'MM/DD/YYYY'));

257: fnd_message.set_token ('DATE', TO_CHAR(v_Lines.rep_str_DATE,'MM/DD/YYYY'));
258: pnp_debug_pkg.put_log_msg(fnd_message.get);
259:
260: fnd_message.set_name ('PN','PN_SOI_REP_DT_HIGH');
261: fnd_message.set_token ('DATE', TO_CHAR(v_Lines.rep_end_DATE,'MM/DD/YYYY'));
262: pnp_debug_pkg.put_log_msg(fnd_message.get);
263:
264: pnp_debug_pkg.log('Variable Rent Id = '|| v_var_rent_id );
265: pnp_debug_pkg.log('open cursor c_line_item');

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

258: pnp_debug_pkg.put_log_msg(fnd_message.get);
259:
260: fnd_message.set_name ('PN','PN_SOI_REP_DT_HIGH');
261: fnd_message.set_token ('DATE', TO_CHAR(v_Lines.rep_end_DATE,'MM/DD/YYYY'));
262: pnp_debug_pkg.put_log_msg(fnd_message.get);
263:
264: pnp_debug_pkg.log('Variable Rent Id = '|| v_var_rent_id );
265: pnp_debug_pkg.log('open cursor c_line_item');
266:

Line 272: fnd_message.set_name('PN', 'PN_SOI_LINE_ITEM_INVALID');

268: FETCH c_line_item into v_line_item_id, v_period_id,
269: v_sales_channel,v_item_category;
270:
271: IF c_line_item%NOTFOUND THEN
272: fnd_message.set_name('PN', 'PN_SOI_LINE_ITEM_INVALID');
273: l_error_message := fnd_message.get;
274: CLOSE c_line_item;
275: RAISE INVALID_RECORD;
276: END IF;

Line 273: l_error_message := fnd_message.get;

269: v_sales_channel,v_item_category;
270:
271: IF c_line_item%NOTFOUND THEN
272: fnd_message.set_name('PN', 'PN_SOI_LINE_ITEM_INVALID');
273: l_error_message := fnd_message.get;
274: CLOSE c_line_item;
275: RAISE INVALID_RECORD;
276: END IF;
277: CLOSE c_line_item;

Line 279: fnd_message.set_name ('PN','PN_SOI_SALES_CH');

275: RAISE INVALID_RECORD;
276: END IF;
277: CLOSE c_line_item;
278:
279: fnd_message.set_name ('PN','PN_SOI_SALES_CH');
280: fnd_message.set_token ('CH',v_sales_channel);
281: pnp_debug_pkg.put_log_msg(fnd_message.get);
282:
283: fnd_message.set_name ('PN','PN_SOI_ITM_CATG');

Line 280: fnd_message.set_token ('CH',v_sales_channel);

276: END IF;
277: CLOSE c_line_item;
278:
279: fnd_message.set_name ('PN','PN_SOI_SALES_CH');
280: fnd_message.set_token ('CH',v_sales_channel);
281: pnp_debug_pkg.put_log_msg(fnd_message.get);
282:
283: fnd_message.set_name ('PN','PN_SOI_ITM_CATG');
284: fnd_message.set_token ('CAT',v_item_category);

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

277: CLOSE c_line_item;
278:
279: fnd_message.set_name ('PN','PN_SOI_SALES_CH');
280: fnd_message.set_token ('CH',v_sales_channel);
281: pnp_debug_pkg.put_log_msg(fnd_message.get);
282:
283: fnd_message.set_name ('PN','PN_SOI_ITM_CATG');
284: fnd_message.set_token ('CAT',v_item_category);
285: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 283: fnd_message.set_name ('PN','PN_SOI_ITM_CATG');

279: fnd_message.set_name ('PN','PN_SOI_SALES_CH');
280: fnd_message.set_token ('CH',v_sales_channel);
281: pnp_debug_pkg.put_log_msg(fnd_message.get);
282:
283: fnd_message.set_name ('PN','PN_SOI_ITM_CATG');
284: fnd_message.set_token ('CAT',v_item_category);
285: pnp_debug_pkg.put_log_msg(fnd_message.get);
286:
287: pnp_debug_pkg.log( 'Line Item Id = '|| v_line_item_id );

Line 284: fnd_message.set_token ('CAT',v_item_category);

280: fnd_message.set_token ('CH',v_sales_channel);
281: pnp_debug_pkg.put_log_msg(fnd_message.get);
282:
283: fnd_message.set_name ('PN','PN_SOI_ITM_CATG');
284: fnd_message.set_token ('CAT',v_item_category);
285: pnp_debug_pkg.put_log_msg(fnd_message.get);
286:
287: pnp_debug_pkg.log( 'Line Item Id = '|| v_line_item_id );
288: pnp_debug_pkg.log( 'Period Id = '|| v_period_id );

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

281: pnp_debug_pkg.put_log_msg(fnd_message.get);
282:
283: fnd_message.set_name ('PN','PN_SOI_ITM_CATG');
284: fnd_message.set_token ('CAT',v_item_category);
285: pnp_debug_pkg.put_log_msg(fnd_message.get);
286:
287: pnp_debug_pkg.log( 'Line Item Id = '|| v_line_item_id );
288: pnp_debug_pkg.log( 'Period Id = '|| v_period_id );
289: pnp_debug_pkg.log('open cursor c_group_DATE');

Line 300: fnd_message.set_name('PN','PN_SOI_VAR_CHECK_DATES');

296: v_reptg_due_DATE,
297: v_invoice_DATE;
298:
299: IF c_group_DATE%NOTFOUND THEN
300: fnd_message.set_name('PN','PN_SOI_VAR_CHECK_DATES');
301: l_error_message := fnd_message.get;
302: CLOSE c_group_DATE;
303: RAISE INVALID_RECORD;
304:

Line 301: l_error_message := fnd_message.get;

297: v_invoice_DATE;
298:
299: IF c_group_DATE%NOTFOUND THEN
300: fnd_message.set_name('PN','PN_SOI_VAR_CHECK_DATES');
301: l_error_message := fnd_message.get;
302: CLOSE c_group_DATE;
303: RAISE INVALID_RECORD;
304:
305: ELSIF c_group_DATE%ROWCOUNT > 2 THEN

Line 306: fnd_message.set_name('PN','PN_VAR_MULTIPLE_GROUP_DATES');

302: CLOSE c_group_DATE;
303: RAISE INVALID_RECORD;
304:
305: ELSIF c_group_DATE%ROWCOUNT > 2 THEN
306: fnd_message.set_name('PN','PN_VAR_MULTIPLE_GROUP_DATES');
307: l_error_message := fnd_message.get;
308: CLOSE c_group_DATE;
309: RAISE INVALID_RECORD;
310: END IF;

Line 307: l_error_message := fnd_message.get;

303: RAISE INVALID_RECORD;
304:
305: ELSIF c_group_DATE%ROWCOUNT > 2 THEN
306: fnd_message.set_name('PN','PN_VAR_MULTIPLE_GROUP_DATES');
307: l_error_message := fnd_message.get;
308: CLOSE c_group_DATE;
309: RAISE INVALID_RECORD;
310: END IF;
311: CLOSE c_group_DATE;

Line 313: fnd_message.set_name ('PN','PN_SOI_GRP_DT');

309: RAISE INVALID_RECORD;
310: END IF;
311: CLOSE c_group_DATE;
312:
313: fnd_message.set_name ('PN','PN_SOI_GRP_DT');
314: fnd_message.set_token ('DATE',v_group_DATE);
315: pnp_debug_pkg.put_log_msg(fnd_message.get);
316:
317: fnd_message.set_name ('PN','PN_AMOUNT');

Line 314: fnd_message.set_token ('DATE',v_group_DATE);

310: END IF;
311: CLOSE c_group_DATE;
312:
313: fnd_message.set_name ('PN','PN_SOI_GRP_DT');
314: fnd_message.set_token ('DATE',v_group_DATE);
315: pnp_debug_pkg.put_log_msg(fnd_message.get);
316:
317: fnd_message.set_name ('PN','PN_AMOUNT');
318: fnd_message.set_token ('AMT',v_lines.amount);

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

311: CLOSE c_group_DATE;
312:
313: fnd_message.set_name ('PN','PN_SOI_GRP_DT');
314: fnd_message.set_token ('DATE',v_group_DATE);
315: pnp_debug_pkg.put_log_msg(fnd_message.get);
316:
317: fnd_message.set_name ('PN','PN_AMOUNT');
318: fnd_message.set_token ('AMT',v_lines.amount);
319: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 317: fnd_message.set_name ('PN','PN_AMOUNT');

313: fnd_message.set_name ('PN','PN_SOI_GRP_DT');
314: fnd_message.set_token ('DATE',v_group_DATE);
315: pnp_debug_pkg.put_log_msg(fnd_message.get);
316:
317: fnd_message.set_name ('PN','PN_AMOUNT');
318: fnd_message.set_token ('AMT',v_lines.amount);
319: pnp_debug_pkg.put_log_msg(fnd_message.get);
320:
321: fnd_message.set_name ('PN','PN_LEASE_NAME');

Line 318: fnd_message.set_token ('AMT',v_lines.amount);

314: fnd_message.set_token ('DATE',v_group_DATE);
315: pnp_debug_pkg.put_log_msg(fnd_message.get);
316:
317: fnd_message.set_name ('PN','PN_AMOUNT');
318: fnd_message.set_token ('AMT',v_lines.amount);
319: pnp_debug_pkg.put_log_msg(fnd_message.get);
320:
321: fnd_message.set_name ('PN','PN_LEASE_NAME');
322: fnd_message.set_token ('NAME',v_lease_name);

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

315: pnp_debug_pkg.put_log_msg(fnd_message.get);
316:
317: fnd_message.set_name ('PN','PN_AMOUNT');
318: fnd_message.set_token ('AMT',v_lines.amount);
319: pnp_debug_pkg.put_log_msg(fnd_message.get);
320:
321: fnd_message.set_name ('PN','PN_LEASE_NAME');
322: fnd_message.set_token ('NAME',v_lease_name);
323: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 321: fnd_message.set_name ('PN','PN_LEASE_NAME');

317: fnd_message.set_name ('PN','PN_AMOUNT');
318: fnd_message.set_token ('AMT',v_lines.amount);
319: pnp_debug_pkg.put_log_msg(fnd_message.get);
320:
321: fnd_message.set_name ('PN','PN_LEASE_NAME');
322: fnd_message.set_token ('NAME',v_lease_name);
323: pnp_debug_pkg.put_log_msg(fnd_message.get);
324:
325: fnd_message.set_name ('PN','PN_SOI_VRN');

Line 322: fnd_message.set_token ('NAME',v_lease_name);

318: fnd_message.set_token ('AMT',v_lines.amount);
319: pnp_debug_pkg.put_log_msg(fnd_message.get);
320:
321: fnd_message.set_name ('PN','PN_LEASE_NAME');
322: fnd_message.set_token ('NAME',v_lease_name);
323: pnp_debug_pkg.put_log_msg(fnd_message.get);
324:
325: fnd_message.set_name ('PN','PN_SOI_VRN');
326: fnd_message.set_token ('NUM',v_var_rent_NUMBER);

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

319: pnp_debug_pkg.put_log_msg(fnd_message.get);
320:
321: fnd_message.set_name ('PN','PN_LEASE_NAME');
322: fnd_message.set_token ('NAME',v_lease_name);
323: pnp_debug_pkg.put_log_msg(fnd_message.get);
324:
325: fnd_message.set_name ('PN','PN_SOI_VRN');
326: fnd_message.set_token ('NUM',v_var_rent_NUMBER);
327: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 325: fnd_message.set_name ('PN','PN_SOI_VRN');

321: fnd_message.set_name ('PN','PN_LEASE_NAME');
322: fnd_message.set_token ('NAME',v_lease_name);
323: pnp_debug_pkg.put_log_msg(fnd_message.get);
324:
325: fnd_message.set_name ('PN','PN_SOI_VRN');
326: fnd_message.set_token ('NUM',v_var_rent_NUMBER);
327: pnp_debug_pkg.put_log_msg(fnd_message.get);
328:
329: IF v_lines.volume_type = 'ACTUAL' THEN

Line 326: fnd_message.set_token ('NUM',v_var_rent_NUMBER);

322: fnd_message.set_token ('NAME',v_lease_name);
323: pnp_debug_pkg.put_log_msg(fnd_message.get);
324:
325: fnd_message.set_name ('PN','PN_SOI_VRN');
326: fnd_message.set_token ('NUM',v_var_rent_NUMBER);
327: pnp_debug_pkg.put_log_msg(fnd_message.get);
328:
329: IF v_lines.volume_type = 'ACTUAL' THEN
330: v_act_amount := v_lines.amount;

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

323: pnp_debug_pkg.put_log_msg(fnd_message.get);
324:
325: fnd_message.set_name ('PN','PN_SOI_VRN');
326: fnd_message.set_token ('NUM',v_var_rent_NUMBER);
327: pnp_debug_pkg.put_log_msg(fnd_message.get);
328:
329: IF v_lines.volume_type = 'ACTUAL' THEN
330: v_act_amount := v_lines.amount;
331:

Line 338: ELSE fnd_message.set_name('PN','PN_INVALID_VOLUME_TYPE');

334:
335: ELSIF v_lines.volume_type ='DEDUCTION' THEN
336: v_ded_amount := v_lines.amount;
337:
338: ELSE fnd_message.set_name('PN','PN_INVALID_VOLUME_TYPE');
339: l_error_message := fnd_message.get;
340: RAISE INVALID_RECORD;
341: END IF;
342:

Line 339: l_error_message := fnd_message.get;

335: ELSIF v_lines.volume_type ='DEDUCTION' THEN
336: v_ded_amount := v_lines.amount;
337:
338: ELSE fnd_message.set_name('PN','PN_INVALID_VOLUME_TYPE');
339: l_error_message := fnd_message.get;
340: RAISE INVALID_RECORD;
341: END IF;
342:
343: pnp_debug_pkg.log( 'Volume Type = '|| v_lines.volume_type );

Line 419: fnd_message.set_name('PN','PN_VAR_ACTUAL_AMT_EXIST');

415:
416: ELSIF v_lines.volume_type = 'ACTUAL' THEN
417: IF ( NVL(v_actual_amt_exist,0) = v_act_amount) THEN
418:
419: fnd_message.set_name('PN','PN_VAR_ACTUAL_AMT_EXIST');
420: l_period_token := ':'||TO_CHAR(v_period_id) ;
421: l_line_item_token := ':'||TO_CHAR(v_lines.line_item_id) ;
422: l_group_DATE_id_token := ':'||TO_CHAR(v_group_DATE_id);
423: l_start_DATE_token := ':'||TO_CHAR(v_lines.rep_str_DATE,'MM/DD/YYYY');

Line 425: fnd_message.set_token('PERIOD_ID',l_period_token);

421: l_line_item_token := ':'||TO_CHAR(v_lines.line_item_id) ;
422: l_group_DATE_id_token := ':'||TO_CHAR(v_group_DATE_id);
423: l_start_DATE_token := ':'||TO_CHAR(v_lines.rep_str_DATE,'MM/DD/YYYY');
424: l_end_DATE_token := ':'||TO_CHAR(v_lines.rep_end_DATE,'MM/DD/YYYY');
425: fnd_message.set_token('PERIOD_ID',l_period_token);
426: fnd_message.set_token('LINE_ITEM_ID',l_line_item_token);
427: fnd_message.set_token('GROUP_DATE_ID',l_group_DATE_id_token);
428: fnd_message.set_token('START_DATE',l_start_DATE_token);
429: fnd_message.set_token('END_DATE',l_end_DATE_token);

Line 426: fnd_message.set_token('LINE_ITEM_ID',l_line_item_token);

422: l_group_DATE_id_token := ':'||TO_CHAR(v_group_DATE_id);
423: l_start_DATE_token := ':'||TO_CHAR(v_lines.rep_str_DATE,'MM/DD/YYYY');
424: l_end_DATE_token := ':'||TO_CHAR(v_lines.rep_end_DATE,'MM/DD/YYYY');
425: fnd_message.set_token('PERIOD_ID',l_period_token);
426: fnd_message.set_token('LINE_ITEM_ID',l_line_item_token);
427: fnd_message.set_token('GROUP_DATE_ID',l_group_DATE_id_token);
428: fnd_message.set_token('START_DATE',l_start_DATE_token);
429: fnd_message.set_token('END_DATE',l_end_DATE_token);
430:

Line 427: fnd_message.set_token('GROUP_DATE_ID',l_group_DATE_id_token);

423: l_start_DATE_token := ':'||TO_CHAR(v_lines.rep_str_DATE,'MM/DD/YYYY');
424: l_end_DATE_token := ':'||TO_CHAR(v_lines.rep_end_DATE,'MM/DD/YYYY');
425: fnd_message.set_token('PERIOD_ID',l_period_token);
426: fnd_message.set_token('LINE_ITEM_ID',l_line_item_token);
427: fnd_message.set_token('GROUP_DATE_ID',l_group_DATE_id_token);
428: fnd_message.set_token('START_DATE',l_start_DATE_token);
429: fnd_message.set_token('END_DATE',l_end_DATE_token);
430:
431: l_error_message := fnd_message.get;

Line 428: fnd_message.set_token('START_DATE',l_start_DATE_token);

424: l_end_DATE_token := ':'||TO_CHAR(v_lines.rep_end_DATE,'MM/DD/YYYY');
425: fnd_message.set_token('PERIOD_ID',l_period_token);
426: fnd_message.set_token('LINE_ITEM_ID',l_line_item_token);
427: fnd_message.set_token('GROUP_DATE_ID',l_group_DATE_id_token);
428: fnd_message.set_token('START_DATE',l_start_DATE_token);
429: fnd_message.set_token('END_DATE',l_end_DATE_token);
430:
431: l_error_message := fnd_message.get;
432: CLOSE c_vol_line_exist;

Line 429: fnd_message.set_token('END_DATE',l_end_DATE_token);

425: fnd_message.set_token('PERIOD_ID',l_period_token);
426: fnd_message.set_token('LINE_ITEM_ID',l_line_item_token);
427: fnd_message.set_token('GROUP_DATE_ID',l_group_DATE_id_token);
428: fnd_message.set_token('START_DATE',l_start_DATE_token);
429: fnd_message.set_token('END_DATE',l_end_DATE_token);
430:
431: l_error_message := fnd_message.get;
432: CLOSE c_vol_line_exist;
433: RAISE INVALID_RECORD;

Line 431: l_error_message := fnd_message.get;

427: fnd_message.set_token('GROUP_DATE_ID',l_group_DATE_id_token);
428: fnd_message.set_token('START_DATE',l_start_DATE_token);
429: fnd_message.set_token('END_DATE',l_end_DATE_token);
430:
431: l_error_message := fnd_message.get;
432: CLOSE c_vol_line_exist;
433: RAISE INVALID_RECORD;
434:
435: ELSIF (NVL(v_actual_amt_exist,0) <> 0) THEN

Line 574: fnd_message.set_name('PN','PN_VAR_FORECASTED_AMT_EXIST');

570:
571: ELSIF v_lines.volume_type = 'FORECASTED' THEN
572: IF (NVL(v_forecasted_amt_exist,0) = v_frc_amount) THEN
573:
574: fnd_message.set_name('PN','PN_VAR_FORECASTED_AMT_EXIST');
575: l_period_token := ':'||TO_CHAR(v_period_id) ;
576: l_line_item_token := ':'||TO_CHAR(v_lines.line_item_id) ;
577: l_group_DATE_id_token := ':'||TO_CHAR(v_group_DATE_id);
578: l_start_DATE_token := ':'||TO_CHAR(v_lines.rep_str_DATE,'MM/DD/YYYY');

Line 580: fnd_message.set_token('PERIOD_ID',l_period_token);

576: l_line_item_token := ':'||TO_CHAR(v_lines.line_item_id) ;
577: l_group_DATE_id_token := ':'||TO_CHAR(v_group_DATE_id);
578: l_start_DATE_token := ':'||TO_CHAR(v_lines.rep_str_DATE,'MM/DD/YYYY');
579: l_end_DATE_token := ':'||TO_CHAR(v_lines.rep_end_DATE,'MM/DD/YYYY');
580: fnd_message.set_token('PERIOD_ID',l_period_token);
581: fnd_message.set_token('LINE_ITEM_ID',l_line_item_token);
582: fnd_message.set_token('GROUP_DATE_ID',l_group_DATE_id_token);
583: fnd_message.set_token('START_DATE',l_start_DATE_token);
584: fnd_message.set_token('END_DATE',l_end_DATE_token);

Line 581: fnd_message.set_token('LINE_ITEM_ID',l_line_item_token);

577: l_group_DATE_id_token := ':'||TO_CHAR(v_group_DATE_id);
578: l_start_DATE_token := ':'||TO_CHAR(v_lines.rep_str_DATE,'MM/DD/YYYY');
579: l_end_DATE_token := ':'||TO_CHAR(v_lines.rep_end_DATE,'MM/DD/YYYY');
580: fnd_message.set_token('PERIOD_ID',l_period_token);
581: fnd_message.set_token('LINE_ITEM_ID',l_line_item_token);
582: fnd_message.set_token('GROUP_DATE_ID',l_group_DATE_id_token);
583: fnd_message.set_token('START_DATE',l_start_DATE_token);
584: fnd_message.set_token('END_DATE',l_end_DATE_token);
585:

Line 582: fnd_message.set_token('GROUP_DATE_ID',l_group_DATE_id_token);

578: l_start_DATE_token := ':'||TO_CHAR(v_lines.rep_str_DATE,'MM/DD/YYYY');
579: l_end_DATE_token := ':'||TO_CHAR(v_lines.rep_end_DATE,'MM/DD/YYYY');
580: fnd_message.set_token('PERIOD_ID',l_period_token);
581: fnd_message.set_token('LINE_ITEM_ID',l_line_item_token);
582: fnd_message.set_token('GROUP_DATE_ID',l_group_DATE_id_token);
583: fnd_message.set_token('START_DATE',l_start_DATE_token);
584: fnd_message.set_token('END_DATE',l_end_DATE_token);
585:
586: l_error_message := fnd_message.get;

Line 583: fnd_message.set_token('START_DATE',l_start_DATE_token);

579: l_end_DATE_token := ':'||TO_CHAR(v_lines.rep_end_DATE,'MM/DD/YYYY');
580: fnd_message.set_token('PERIOD_ID',l_period_token);
581: fnd_message.set_token('LINE_ITEM_ID',l_line_item_token);
582: fnd_message.set_token('GROUP_DATE_ID',l_group_DATE_id_token);
583: fnd_message.set_token('START_DATE',l_start_DATE_token);
584: fnd_message.set_token('END_DATE',l_end_DATE_token);
585:
586: l_error_message := fnd_message.get;
587: CLOSE c_vol_line_exist;

Line 584: fnd_message.set_token('END_DATE',l_end_DATE_token);

580: fnd_message.set_token('PERIOD_ID',l_period_token);
581: fnd_message.set_token('LINE_ITEM_ID',l_line_item_token);
582: fnd_message.set_token('GROUP_DATE_ID',l_group_DATE_id_token);
583: fnd_message.set_token('START_DATE',l_start_DATE_token);
584: fnd_message.set_token('END_DATE',l_end_DATE_token);
585:
586: l_error_message := fnd_message.get;
587: CLOSE c_vol_line_exist;
588: RAISE INVALID_RECORD;

Line 586: l_error_message := fnd_message.get;

582: fnd_message.set_token('GROUP_DATE_ID',l_group_DATE_id_token);
583: fnd_message.set_token('START_DATE',l_start_DATE_token);
584: fnd_message.set_token('END_DATE',l_end_DATE_token);
585:
586: l_error_message := fnd_message.get;
587: CLOSE c_vol_line_exist;
588: RAISE INVALID_RECORD;
589:
590: ELSIF NVL(v_forecasted_amt_exist,0) <> 0 THEN

Line 1082: fnd_message.set_name ('PN','PN_SOI_PBATCH');

1078: SET error_log = SUBSTR(l_error_message, 1, 240),
1079: status ='E'
1080: WHERE rowid = v_lines.rowid;
1081:
1082: fnd_message.set_name ('PN','PN_SOI_PBATCH');
1083: fnd_message.set_token ('ID', p_batch_id);
1084: pnp_debug_pkg.put_log_msg(fnd_message.get||'-'||l_error_message);
1085:
1086: pnp_debug_pkg.log('Row Id :'||v_lines.rowid ||'-'||l_error_message);

Line 1083: fnd_message.set_token ('ID', p_batch_id);

1079: status ='E'
1080: WHERE rowid = v_lines.rowid;
1081:
1082: fnd_message.set_name ('PN','PN_SOI_PBATCH');
1083: fnd_message.set_token ('ID', p_batch_id);
1084: pnp_debug_pkg.put_log_msg(fnd_message.get||'-'||l_error_message);
1085:
1086: pnp_debug_pkg.log('Row Id :'||v_lines.rowid ||'-'||l_error_message);
1087:

Line 1084: pnp_debug_pkg.put_log_msg(fnd_message.get||'-'||l_error_message);

1080: WHERE rowid = v_lines.rowid;
1081:
1082: fnd_message.set_name ('PN','PN_SOI_PBATCH');
1083: fnd_message.set_token ('ID', p_batch_id);
1084: pnp_debug_pkg.put_log_msg(fnd_message.get||'-'||l_error_message);
1085:
1086: pnp_debug_pkg.log('Row Id :'||v_lines.rowid ||'-'||l_error_message);
1087:
1088: END;

Line 1093: fnd_message.set_name ('PN', 'PN_SOI_BATCH_REC_NOT_FOUND');

1089: END LOOP;
1090: END IF;
1091:
1092: IF (l_total = 0) THEN
1093: fnd_message.set_name ('PN', 'PN_SOI_BATCH_REC_NOT_FOUND');
1094: l_error_message := fnd_message.get;
1095: pnp_debug_pkg.put_log_msg(l_error_message);
1096: ELSE
1097: IF l_fail = 0 THEN

Line 1094: l_error_message := fnd_message.get;

1090: END IF;
1091:
1092: IF (l_total = 0) THEN
1093: fnd_message.set_name ('PN', 'PN_SOI_BATCH_REC_NOT_FOUND');
1094: l_error_message := fnd_message.get;
1095: pnp_debug_pkg.put_log_msg(l_error_message);
1096: ELSE
1097: IF l_fail = 0 THEN
1098: v_status_code := 'I';

Line 1115: fnd_message.set_name('PN', 'PN_SOI_PROC');

1111:
1112: pnp_debug_pkg.put_log_msg('------------------------------------------------');
1113:
1114: l_success := l_total- l_fail;
1115: fnd_message.set_name('PN', 'PN_SOI_PROC');
1116: fnd_message.set_token('NUM', TO_CHAR(l_success));
1117: pnp_debug_pkg.put_log_msg(fnd_message.get);
1118:
1119: fnd_message.set_name('PN', 'PN_SOI_FAILURE');

Line 1116: fnd_message.set_token('NUM', TO_CHAR(l_success));

1112: pnp_debug_pkg.put_log_msg('------------------------------------------------');
1113:
1114: l_success := l_total- l_fail;
1115: fnd_message.set_name('PN', 'PN_SOI_PROC');
1116: fnd_message.set_token('NUM', TO_CHAR(l_success));
1117: pnp_debug_pkg.put_log_msg(fnd_message.get);
1118:
1119: fnd_message.set_name('PN', 'PN_SOI_FAILURE');
1120: fnd_message.set_token('FAILURE', l_fail);

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

1113:
1114: l_success := l_total- l_fail;
1115: fnd_message.set_name('PN', 'PN_SOI_PROC');
1116: fnd_message.set_token('NUM', TO_CHAR(l_success));
1117: pnp_debug_pkg.put_log_msg(fnd_message.get);
1118:
1119: fnd_message.set_name('PN', 'PN_SOI_FAILURE');
1120: fnd_message.set_token('FAILURE', l_fail);
1121: l_error_message := fnd_message.get;

Line 1119: fnd_message.set_name('PN', 'PN_SOI_FAILURE');

1115: fnd_message.set_name('PN', 'PN_SOI_PROC');
1116: fnd_message.set_token('NUM', TO_CHAR(l_success));
1117: pnp_debug_pkg.put_log_msg(fnd_message.get);
1118:
1119: fnd_message.set_name('PN', 'PN_SOI_FAILURE');
1120: fnd_message.set_token('FAILURE', l_fail);
1121: l_error_message := fnd_message.get;
1122: pnp_debug_pkg.put_log_msg(l_error_message);
1123:

Line 1120: fnd_message.set_token('FAILURE', l_fail);

1116: fnd_message.set_token('NUM', TO_CHAR(l_success));
1117: pnp_debug_pkg.put_log_msg(fnd_message.get);
1118:
1119: fnd_message.set_name('PN', 'PN_SOI_FAILURE');
1120: fnd_message.set_token('FAILURE', l_fail);
1121: l_error_message := fnd_message.get;
1122: pnp_debug_pkg.put_log_msg(l_error_message);
1123:
1124: END IF;

Line 1121: l_error_message := fnd_message.get;

1117: pnp_debug_pkg.put_log_msg(fnd_message.get);
1118:
1119: fnd_message.set_name('PN', 'PN_SOI_FAILURE');
1120: fnd_message.set_token('FAILURE', l_fail);
1121: l_error_message := fnd_message.get;
1122: pnp_debug_pkg.put_log_msg(l_error_message);
1123:
1124: END IF;
1125:

Line 1145: fnd_message.set_name ('PN', 'PN_SOI_BATCH_REC_NOT_FOUND');

1141:
1142: EXCEPTION
1143: WHEN NO_DATA_FOUND THEN
1144: pnp_debug_pkg.log('EXCEPTION: NO_DATA_FOUND');
1145: fnd_message.set_name ('PN', 'PN_SOI_BATCH_REC_NOT_FOUND');
1146: l_error_message := fnd_message.get;
1147: errbuf := l_error_message;
1148: retcode := '2';
1149: pnp_debug_pkg.put_log_msg(errbuf);

Line 1146: l_error_message := fnd_message.get;

1142: EXCEPTION
1143: WHEN NO_DATA_FOUND THEN
1144: pnp_debug_pkg.log('EXCEPTION: NO_DATA_FOUND');
1145: fnd_message.set_name ('PN', 'PN_SOI_BATCH_REC_NOT_FOUND');
1146: l_error_message := fnd_message.get;
1147: errbuf := l_error_message;
1148: retcode := '2';
1149: pnp_debug_pkg.put_log_msg(errbuf);
1150: RAISE;

Line 1190: fnd_message.set_name ('PN','PN_SOI_PBATCH');

1186:
1187: BEGIN
1188: PNP_DEBUG_PKG.debug ('PN_SOI_VOL_IMPORT .DELETE_VOL_HIST(+)');
1189:
1190: fnd_message.set_name ('PN','PN_SOI_PBATCH');
1191: fnd_message.set_token ('ID', p_batch_id);
1192: pnp_debug_pkg.put_log_msg(fnd_message.get);
1193:
1194: fnd_message.set_name ('PN','PN_SOI_REP_DT_LOW');

Line 1191: fnd_message.set_token ('ID', p_batch_id);

1187: BEGIN
1188: PNP_DEBUG_PKG.debug ('PN_SOI_VOL_IMPORT .DELETE_VOL_HIST(+)');
1189:
1190: fnd_message.set_name ('PN','PN_SOI_PBATCH');
1191: fnd_message.set_token ('ID', p_batch_id);
1192: pnp_debug_pkg.put_log_msg(fnd_message.get);
1193:
1194: fnd_message.set_name ('PN','PN_SOI_REP_DT_LOW');
1195: fnd_message.set_token ('DATE', p_start_DATE);

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

1188: PNP_DEBUG_PKG.debug ('PN_SOI_VOL_IMPORT .DELETE_VOL_HIST(+)');
1189:
1190: fnd_message.set_name ('PN','PN_SOI_PBATCH');
1191: fnd_message.set_token ('ID', p_batch_id);
1192: pnp_debug_pkg.put_log_msg(fnd_message.get);
1193:
1194: fnd_message.set_name ('PN','PN_SOI_REP_DT_LOW');
1195: fnd_message.set_token ('DATE', p_start_DATE);
1196: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1194: fnd_message.set_name ('PN','PN_SOI_REP_DT_LOW');

1190: fnd_message.set_name ('PN','PN_SOI_PBATCH');
1191: fnd_message.set_token ('ID', p_batch_id);
1192: pnp_debug_pkg.put_log_msg(fnd_message.get);
1193:
1194: fnd_message.set_name ('PN','PN_SOI_REP_DT_LOW');
1195: fnd_message.set_token ('DATE', p_start_DATE);
1196: pnp_debug_pkg.put_log_msg(fnd_message.get);
1197:
1198: fnd_message.set_name ('PN','PN_SOI_REP_DT_HIGH');

Line 1195: fnd_message.set_token ('DATE', p_start_DATE);

1191: fnd_message.set_token ('ID', p_batch_id);
1192: pnp_debug_pkg.put_log_msg(fnd_message.get);
1193:
1194: fnd_message.set_name ('PN','PN_SOI_REP_DT_LOW');
1195: fnd_message.set_token ('DATE', p_start_DATE);
1196: pnp_debug_pkg.put_log_msg(fnd_message.get);
1197:
1198: fnd_message.set_name ('PN','PN_SOI_REP_DT_HIGH');
1199: fnd_message.set_token ('DATE',p_start_DATE);

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

1192: pnp_debug_pkg.put_log_msg(fnd_message.get);
1193:
1194: fnd_message.set_name ('PN','PN_SOI_REP_DT_LOW');
1195: fnd_message.set_token ('DATE', p_start_DATE);
1196: pnp_debug_pkg.put_log_msg(fnd_message.get);
1197:
1198: fnd_message.set_name ('PN','PN_SOI_REP_DT_HIGH');
1199: fnd_message.set_token ('DATE',p_start_DATE);
1200: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1198: fnd_message.set_name ('PN','PN_SOI_REP_DT_HIGH');

1194: fnd_message.set_name ('PN','PN_SOI_REP_DT_LOW');
1195: fnd_message.set_token ('DATE', p_start_DATE);
1196: pnp_debug_pkg.put_log_msg(fnd_message.get);
1197:
1198: fnd_message.set_name ('PN','PN_SOI_REP_DT_HIGH');
1199: fnd_message.set_token ('DATE',p_start_DATE);
1200: pnp_debug_pkg.put_log_msg(fnd_message.get);
1201:
1202:

Line 1199: fnd_message.set_token ('DATE',p_start_DATE);

1195: fnd_message.set_token ('DATE', p_start_DATE);
1196: pnp_debug_pkg.put_log_msg(fnd_message.get);
1197:
1198: fnd_message.set_name ('PN','PN_SOI_REP_DT_HIGH');
1199: fnd_message.set_token ('DATE',p_start_DATE);
1200: pnp_debug_pkg.put_log_msg(fnd_message.get);
1201:
1202:
1203: FOR v_batch IN c_batch LOOP

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

1196: pnp_debug_pkg.put_log_msg(fnd_message.get);
1197:
1198: fnd_message.set_name ('PN','PN_SOI_REP_DT_HIGH');
1199: fnd_message.set_token ('DATE',p_start_DATE);
1200: pnp_debug_pkg.put_log_msg(fnd_message.get);
1201:
1202:
1203: FOR v_batch IN c_batch LOOP
1204:

Line 1235: fnd_message.set_name ('PN', 'PN_SOI_NO_BATCH_FOUND');

1231: END IF;
1232: END LOOP;
1233:
1234: IF (l_total = 0) THEN
1235: fnd_message.set_name ('PN', 'PN_SOI_NO_BATCH_FOUND');
1236: l_error_message := fnd_message.get;
1237: pnp_debug_pkg.put_log_msg(l_error_message);
1238:
1239: ELSE

Line 1236: l_error_message := fnd_message.get;

1232: END LOOP;
1233:
1234: IF (l_total = 0) THEN
1235: fnd_message.set_name ('PN', 'PN_SOI_NO_BATCH_FOUND');
1236: l_error_message := fnd_message.get;
1237: pnp_debug_pkg.put_log_msg(l_error_message);
1238:
1239: ELSE
1240: fnd_message.set_name('PN', 'PN_SOI_BATCH_TOTAL_DELETED');

Line 1240: fnd_message.set_name('PN', 'PN_SOI_BATCH_TOTAL_DELETED');

1236: l_error_message := fnd_message.get;
1237: pnp_debug_pkg.put_log_msg(l_error_message);
1238:
1239: ELSE
1240: fnd_message.set_name('PN', 'PN_SOI_BATCH_TOTAL_DELETED');
1241: fnd_message.set_token('BATCH_TOTAL', l_total_batch_deleted);
1242: l_error_message := fnd_message.get;
1243: pnp_debug_pkg.put_log_msg(l_error_message);
1244:

Line 1241: fnd_message.set_token('BATCH_TOTAL', l_total_batch_deleted);

1237: pnp_debug_pkg.put_log_msg(l_error_message);
1238:
1239: ELSE
1240: fnd_message.set_name('PN', 'PN_SOI_BATCH_TOTAL_DELETED');
1241: fnd_message.set_token('BATCH_TOTAL', l_total_batch_deleted);
1242: l_error_message := fnd_message.get;
1243: pnp_debug_pkg.put_log_msg(l_error_message);
1244:
1245: fnd_message.set_name('PN', 'PN_SOI_LINES_TOTAL_DELETED');

Line 1242: l_error_message := fnd_message.get;

1238:
1239: ELSE
1240: fnd_message.set_name('PN', 'PN_SOI_BATCH_TOTAL_DELETED');
1241: fnd_message.set_token('BATCH_TOTAL', l_total_batch_deleted);
1242: l_error_message := fnd_message.get;
1243: pnp_debug_pkg.put_log_msg(l_error_message);
1244:
1245: fnd_message.set_name('PN', 'PN_SOI_LINES_TOTAL_DELETED');
1246: fnd_message.set_token('LINES_TOTAL', l_total_lines_deleted);

Line 1245: fnd_message.set_name('PN', 'PN_SOI_LINES_TOTAL_DELETED');

1241: fnd_message.set_token('BATCH_TOTAL', l_total_batch_deleted);
1242: l_error_message := fnd_message.get;
1243: pnp_debug_pkg.put_log_msg(l_error_message);
1244:
1245: fnd_message.set_name('PN', 'PN_SOI_LINES_TOTAL_DELETED');
1246: fnd_message.set_token('LINES_TOTAL', l_total_lines_deleted);
1247: l_error_message := fnd_message.get;
1248: pnp_debug_pkg.put_log_msg(l_error_message);
1249: END IF;

Line 1246: fnd_message.set_token('LINES_TOTAL', l_total_lines_deleted);

1242: l_error_message := fnd_message.get;
1243: pnp_debug_pkg.put_log_msg(l_error_message);
1244:
1245: fnd_message.set_name('PN', 'PN_SOI_LINES_TOTAL_DELETED');
1246: fnd_message.set_token('LINES_TOTAL', l_total_lines_deleted);
1247: l_error_message := fnd_message.get;
1248: pnp_debug_pkg.put_log_msg(l_error_message);
1249: END IF;
1250:

Line 1247: l_error_message := fnd_message.get;

1243: pnp_debug_pkg.put_log_msg(l_error_message);
1244:
1245: fnd_message.set_name('PN', 'PN_SOI_LINES_TOTAL_DELETED');
1246: fnd_message.set_token('LINES_TOTAL', l_total_lines_deleted);
1247: l_error_message := fnd_message.get;
1248: pnp_debug_pkg.put_log_msg(l_error_message);
1249: END IF;
1250:
1251: COMMIT;