DBA Data[Home] [Help]

APPS.PJM_TRANSFER_IPV_PKG dependencies on FND_MESSAGE

Line 132: fnd_message_cache.set_name('FND' , 'UTIL-CURRENT TIME');

128: PROCEDURE Timestamp IS
129: Current_Time DATE;
130: BEGIN
131: Current_Time := sysdate;
132: fnd_message_cache.set_name('FND' , 'UTIL-CURRENT TIME');
133: fnd_message_cache.set_token('DATE' , fnd_date.date_to_displaydate(Current_Time));
134: fnd_message_cache.set_token('TIME' , to_char(Current_Time , 'HH24:MI:SS'));
135: PJM_CONC.put_line(fnd_message_cache.get);
136: PJM_CONC.new_line(1);

Line 133: fnd_message_cache.set_token('DATE' , fnd_date.date_to_displaydate(Current_Time));

129: Current_Time DATE;
130: BEGIN
131: Current_Time := sysdate;
132: fnd_message_cache.set_name('FND' , 'UTIL-CURRENT TIME');
133: fnd_message_cache.set_token('DATE' , fnd_date.date_to_displaydate(Current_Time));
134: fnd_message_cache.set_token('TIME' , to_char(Current_Time , 'HH24:MI:SS'));
135: PJM_CONC.put_line(fnd_message_cache.get);
136: PJM_CONC.new_line(1);
137: EXCEPTION

Line 134: fnd_message_cache.set_token('TIME' , to_char(Current_Time , 'HH24:MI:SS'));

130: BEGIN
131: Current_Time := sysdate;
132: fnd_message_cache.set_name('FND' , 'UTIL-CURRENT TIME');
133: fnd_message_cache.set_token('DATE' , fnd_date.date_to_displaydate(Current_Time));
134: fnd_message_cache.set_token('TIME' , to_char(Current_Time , 'HH24:MI:SS'));
135: PJM_CONC.put_line(fnd_message_cache.get);
136: PJM_CONC.new_line(1);
137: EXCEPTION
138: WHEN OTHERS THEN

Line 135: PJM_CONC.put_line(fnd_message_cache.get);

131: Current_Time := sysdate;
132: fnd_message_cache.set_name('FND' , 'UTIL-CURRENT TIME');
133: fnd_message_cache.set_token('DATE' , fnd_date.date_to_displaydate(Current_Time));
134: fnd_message_cache.set_token('TIME' , to_char(Current_Time , 'HH24:MI:SS'));
135: PJM_CONC.put_line(fnd_message_cache.get);
136: PJM_CONC.new_line(1);
137: EXCEPTION
138: WHEN OTHERS THEN
139: NULL;

Line 276: fnd_message.set_name('PJM','CONC-APINV IPV Transfer');

272: then l_trx_status_code := 'P';
273: else l_trx_status_code := X_trx_status_code;
274: end if;
275:
276: fnd_message.set_name('PJM','CONC-APINV IPV Transfer');
277: PJM_CONC.put_line(fnd_message.get || ' ...');
278: PJM_CONC.new_line(1);
279:
280: PJM_CONC.put_line('[PROJECT_ID] = ' || X_Project_Id);

Line 277: PJM_CONC.put_line(fnd_message.get || ' ...');

273: else l_trx_status_code := X_trx_status_code;
274: end if;
275:
276: fnd_message.set_name('PJM','CONC-APINV IPV Transfer');
277: PJM_CONC.put_line(fnd_message.get || ' ...');
278: PJM_CONC.new_line(1);
279:
280: PJM_CONC.put_line('[PROJECT_ID] = ' || X_Project_Id);
281: PJM_CONC.put_line('[START_DATE] = ' || X_Start_Date);

Line 293: l_IPV_Exp_Comment := fnd_message.get_string('PJM','CONC-APINV IPV');

289:
290: PJM_CONC.put_line('[REQUEST_ID] = ' || l_request_id);
291: PJM_CONC.new_line(1);
292:
293: l_IPV_Exp_Comment := fnd_message.get_string('PJM','CONC-APINV IPV');
294: l_ERV_Exp_Comment := fnd_message.get_string('PJM','CONC-APINV ERV');
295:
296: l_Batch_Name := PJM_Transfer_IPV_Pkg.batch_name;
297:

Line 294: l_ERV_Exp_Comment := fnd_message.get_string('PJM','CONC-APINV ERV');

290: PJM_CONC.put_line('[REQUEST_ID] = ' || l_request_id);
291: PJM_CONC.new_line(1);
292:
293: l_IPV_Exp_Comment := fnd_message.get_string('PJM','CONC-APINV IPV');
294: l_ERV_Exp_Comment := fnd_message.get_string('PJM','CONC-APINV ERV');
295:
296: l_Batch_Name := PJM_Transfer_IPV_Pkg.batch_name;
297:
298: PJM_CONC.put_line('Batch_Name = ' || l_batch_name);

Line 329: fnd_message.set_name('PJM', 'CONC-APINV Flag Inv Dists');

325: -- Only flag ITEM invoice lines. TAX/FREIGHT/MISC may also result
326: -- in IPV, causing the processing of such lines in the IPV/ERV
327: -- cycle.
328: ----------------------------------------------------------------------
329: fnd_message.set_name('PJM', 'CONC-APINV Flag Inv Dists');
330: PJM_CONC.put_line(fnd_message.get || ' ...');
331:
332: l_progress := 20;
333:

Line 330: PJM_CONC.put_line(fnd_message.get || ' ...');

326: -- in IPV, causing the processing of such lines in the IPV/ERV
327: -- cycle.
328: ----------------------------------------------------------------------
329: fnd_message.set_name('PJM', 'CONC-APINV Flag Inv Dists');
330: PJM_CONC.put_line(fnd_message.get || ' ...');
331:
332: l_progress := 20;
333:
334: -- UPDATE /*+ index(DIST AP_INVOICE_DISTRIBUTIONS_N14) */

Line 367: -- fnd_message.set_name('PJM', 'CONC-APINV Elim NetZero');

363: ----------------------------------------------------------------------
364: -- Eliminate all pairing of reversed invoice distributions
365: ----------------------------------------------------------------------
366:
367: -- fnd_message.set_name('PJM', 'CONC-APINV Elim NetZero');
368: -- PJM_CONC.put_line(fnd_message.get || ' ...');
369:
370: l_progress := 30;
371:

Line 368: -- PJM_CONC.put_line(fnd_message.get || ' ...');

364: -- Eliminate all pairing of reversed invoice distributions
365: ----------------------------------------------------------------------
366:
367: -- fnd_message.set_name('PJM', 'CONC-APINV Elim NetZero');
368: -- PJM_CONC.put_line(fnd_message.get || ' ...');
369:
370: l_progress := 30;
371:
372: ----------------------------------------------------------------------

Line 406: fnd_message.set_name('PJM','CONC-APINV Start Loop');

402: -- Loop for transfering IPV from Invoice_Distribution to
403: -- PA_Transaction_Interfaces
404: ----------------------------------------------------------------------
405:
406: fnd_message.set_name('PJM','CONC-APINV Start Loop');
407: PJM_CONC.put_line(fnd_message.get || ' ...');
408:
409: Timestamp;
410:

Line 407: PJM_CONC.put_line(fnd_message.get || ' ...');

403: -- PA_Transaction_Interfaces
404: ----------------------------------------------------------------------
405:
406: fnd_message.set_name('PJM','CONC-APINV Start Loop');
407: PJM_CONC.put_line(fnd_message.get || ' ...');
408:
409: Timestamp;
410:
411: OPEN Inv_Curs;

Line 513: fnd_message.set_name('PJM','CONC-APINV Insert');

509: ----------------------------------------------------------------------
510: -- Insert into PA_TRANSACTION_INTERFACES table
511: ----------------------------------------------------------------------
512:
513: fnd_message.set_name('PJM','CONC-APINV Insert');
514: PJM_CONC.put_line('... ' || fnd_message.get);
515:
516: if not ( InvRec.Price_Var_Code_Combination_Id is not null AND
517: nvl(nvl(InvRec.Base_Invoice_Price_Variance,

Line 514: PJM_CONC.put_line('... ' || fnd_message.get);

510: -- Insert into PA_TRANSACTION_INTERFACES table
511: ----------------------------------------------------------------------
512:
513: fnd_message.set_name('PJM','CONC-APINV Insert');
514: PJM_CONC.put_line('... ' || fnd_message.get);
515:
516: if not ( InvRec.Price_Var_Code_Combination_Id is not null AND
517: nvl(nvl(InvRec.Base_Invoice_Price_Variance,
518: InvRec.Invoice_Price_Variance) , 0) <> 0 ) then

Line 763: fnd_message.set_name('PJM','CONC-APINV Flag Comp');

759: ----------------------------------------------------------------------
760: -- Update pa_addition_flag to 'Y' for successful invoice distributions
761: ----------------------------------------------------------------------
762:
763: fnd_message.set_name('PJM','CONC-APINV Flag Comp');
764: PJM_CONC.put_line('... ' || fnd_message.get);
765: PJM_CONC.new_line(1);
766:
767: l_progress := 130;

Line 764: PJM_CONC.put_line('... ' || fnd_message.get);

760: -- Update pa_addition_flag to 'Y' for successful invoice distributions
761: ----------------------------------------------------------------------
762:
763: fnd_message.set_name('PJM','CONC-APINV Flag Comp');
764: PJM_CONC.put_line('... ' || fnd_message.get);
765: PJM_CONC.new_line(1);
766:
767: l_progress := 130;
768:

Line 781: fnd_message.set_name('PJM','CONC-APINV Finish Loop');

777:
778: CLOSE Inv_Curs;
779:
780: COMMIT;
781: fnd_message.set_name('PJM','CONC-APINV Finish Loop');
782: PJM_CONC.put_line(fnd_message.get || ' ...');
783: PJM_CONC.new_line(1);
784:
785: Timestamp;

Line 782: PJM_CONC.put_line(fnd_message.get || ' ...');

778: CLOSE Inv_Curs;
779:
780: COMMIT;
781: fnd_message.set_name('PJM','CONC-APINV Finish Loop');
782: PJM_CONC.put_line(fnd_message.get || ' ...');
783: PJM_CONC.new_line(1);
784:
785: Timestamp;
786: