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.FV_THIRD_PARTY_REMIT_PKG dependencies on FND_LOG

Line 76: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

72: BEGIN
73:
74: l_module_name := g_module_name || 'MAIN';
75: g_message := 'Starting Third Party Remittance process ...';
76: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
77:
78: g_message := ' Third Party Profile Option: '|| g_tpp_flag;
79: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
80:

Line 79: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

75: g_message := 'Starting Third Party Remittance process ...';
76: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
77:
78: g_message := ' Third Party Profile Option: '|| g_tpp_flag;
79: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
80:
81: g_message := ' Set Of Books Id: '|| g_sob_id;
82: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
83:

Line 82: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

78: g_message := ' Third Party Profile Option: '|| g_tpp_flag;
79: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
80:
81: g_message := ' Set Of Books Id: '|| g_sob_id;
82: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
83:
84: g_message := ' Organization Id: '|| g_org_id;
85: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
86:

Line 85: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

81: g_message := ' Set Of Books Id: '|| g_sob_id;
82: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
83:
84: g_message := ' Organization Id: '|| g_org_id;
85: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
86:
87: g_pay_date_from := FND_DATE.CANONICAL_TO_DATE(p_pay_date_from);
88: g_message := ' Payment Date From: '|| to_char(g_pay_date_from);
89: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

Line 89: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

85: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
86:
87: g_pay_date_from := FND_DATE.CANONICAL_TO_DATE(p_pay_date_from);
88: g_message := ' Payment Date From: '|| to_char(g_pay_date_from);
89: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
90:
91: g_pay_date_to := FND_DATE.CANONICAL_TO_DATE(p_pay_date_to);
92: g_message := ' Payment Date To: '|| to_char(g_pay_date_to);
93: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

Line 93: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

89: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
90:
91: g_pay_date_to := FND_DATE.CANONICAL_TO_DATE(p_pay_date_to);
92: g_message := ' Payment Date To: '|| to_char(g_pay_date_to);
93: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
94:
95: g_checkrun_name := p_checkrun_name;
96: g_message := ' Payment Batch Name: '|| g_checkrun_name;
97: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

Line 97: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

93: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
94:
95: g_checkrun_name := p_checkrun_name;
96: g_message := ' Payment Batch Name: '|| g_checkrun_name;
97: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
98:
99: g_from_supp_id := p_from_supp_id;
100: g_message := ' Original Supplier Id: '|| g_from_supp_id;
101: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

Line 101: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

97: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
98:
99: g_from_supp_id := p_from_supp_id;
100: g_message := ' Original Supplier Id: '|| g_from_supp_id;
101: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
102:
103: IF (g_from_supp_id IS NOT NULL)
104: THEN
105: IF (g_retcode = 0)

Line 109: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

105: IF (g_retcode = 0)
106: THEN
107: g_from_supp_name := Vendor_Name(g_from_supp_id);
108: g_message := ' Original Supplier Name: '|| g_from_supp_name;
109: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
110: END IF;
111: END IF;
112:
113: g_from_site_id := p_from_supp_site_id;

Line 115: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

111: END IF;
112:
113: g_from_site_id := p_from_supp_site_id;
114: g_message := ' Original Supplier Site Id: '|| g_from_site_id;
115: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
116:
117: IF (g_from_site_id IS NOT NULL)
118: THEN
119: IF (g_retcode = 0)

Line 123: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

119: IF (g_retcode = 0)
120: THEN
121: g_from_site_code := Vendor_Site(g_from_site_id);
122: g_message := ' Original Supplier Site: '|| g_from_site_code;
123: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
124: END IF;
125: END IF;
126:
127: g_to_supp_id := p_to_supp_id;

Line 129: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

125: END IF;
126:
127: g_to_supp_id := p_to_supp_id;
128: g_message := ' Third Party Agent Id: '|| g_to_supp_id;
129: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
130:
131: IF (g_to_supp_id IS NOT NULL)
132: THEN
133: IF (g_retcode = 0)

Line 137: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

133: IF (g_retcode = 0)
134: THEN
135: g_to_supp_name := Vendor_Name(g_to_supp_id);
136: g_message := ' Third Party Agent: '|| g_to_supp_name;
137: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
138: END IF;
139: END IF;
140:
141: g_to_site_id := p_to_supp_site_id;

Line 143: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

139: END IF;
140:
141: g_to_site_id := p_to_supp_site_id;
142: g_message := ' Third Party Site Id: '|| g_to_site_id;
143: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
144:
145: IF (g_to_site_id IS NOT NULL)
146: THEN
147: IF (g_retcode = 0)

Line 151: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

147: IF (g_retcode = 0)
148: THEN
149: g_to_site_code := Vendor_Site(g_to_site_id);
150: g_message := ' Third Party Site: '|| g_to_site_code;
151: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
152: END IF;
153: END IF;
154:
155: g_sort_by := p_sort_by;

Line 157: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

153: END IF;
154:
155: g_sort_by := p_sort_by;
156: g_message := ' Sort By: '|| g_sort_by;
157: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
158:
159: IF (g_tpp_flag = 'N')
160: THEN
161: g_errbuf := 'Erroring out from Third Party Remittance Process because Third Party Profile Option is set to NO !!';

Line 163: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,g_errbuf, 'N');

159: IF (g_tpp_flag = 'N')
160: THEN
161: g_errbuf := 'Erroring out from Third Party Remittance Process because Third Party Profile Option is set to NO !!';
162: g_retcode := 2;
163: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,g_errbuf, 'N');
164: ELSE
165: -- Purge fv_third_party_temp table using Initialization procedure
166: IF (g_retcode = 0)
167: THEN

Line 197: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,x_errbuf, 'N');

193:
194: IF (g_retcode = 0) AND (g_data_found = 'N')
195: THEN
196: x_errbuf := 'NO DATA FOUND for Third Party Remittance reporting ...';
197: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,x_errbuf, 'N');
198: END IF;
199:
200: g_message := 'Ending Third Party Remittance process ...';
201: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

Line 201: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

197: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,x_errbuf, 'N');
198: END IF;
199:
200: g_message := 'Ending Third Party Remittance process ...';
201: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
202: EXCEPTION
203: WHEN OTHERS THEN
204: g_retcode := SQLCODE;
205: g_errbuf := SQLERRM || ' -- Error in the Main procedure';

Line 208: Log_Message(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',g_errbuf, 'N');

204: g_retcode := SQLCODE;
205: g_errbuf := SQLERRM || ' -- Error in the Main procedure';
206: x_retcode := g_retcode;
207: x_errbuf := g_errbuf;
208: Log_Message(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',g_errbuf, 'N');
209: END MAIN;
210:
211:
212: -- -------------------------------------------------------------

Line 235: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

231: l_debug := p_debug;
232: END IF;
233: l_module_name := g_module_name || 'LOG_MESSAGE';
234: IF (l_debug = 'Y') THEN
235: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
236: FV_UTILITY.DEBUG_MESG(p_level, p_module, p_message);
237: END IF;
238: ELSE
239: FV_UTILITY.LOG_MESG(p_level, p_module, p_message);

Line 244: Log_Message(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',g_errbuf, 'N');

240: END IF;
241: EXCEPTION
242: WHEN OTHERS THEN
243: g_errbuf := SQLERRM;
244: Log_Message(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',g_errbuf, 'N');
245: END LOG_MESSAGE;
246:
247:
248: -- -------------------------------------------------------------

Line 260: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

256: l_count NUMBER := 0;
257: BEGIN
258: g_message := ' Purging Fv_Third_Party_Temp table ...';
259: l_module_name := g_module_name || 'INITIALIZATION';
260: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
261:
262: DELETE FROM fv_third_party_temp;
263: EXCEPTION
264: WHEN OTHERS THEN

Line 268: Log_Message(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',g_errbuf, 'N');

264: WHEN OTHERS THEN
265: g_retcode := SQLCODE;
266: g_errbuf := SQLERRM ||
267: ' -- Error in Initialization Procedure when purging fv_third_party_temp table';
268: Log_Message(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',g_errbuf, 'N');
269: END INITIALIZATION;
270:
271:
272: -- -------------------------------------------------------------

Line 292: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

288: l_module_name VARCHAR2(200) ;
289: BEGIN
290: g_message := ' Inserting a record in Fv_Third_Party_Temp ...';
291: l_module_name := g_module_name || 'POPULATE_THIRD_PARTY_TEMP';
292: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
293: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,'');
294:
295: INSERT INTO fv_third_party_temp
296: (original_supplier_name,

Line 293: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,'');

289: BEGIN
290: g_message := ' Inserting a record in Fv_Third_Party_Temp ...';
291: l_module_name := g_module_name || 'POPULATE_THIRD_PARTY_TEMP';
292: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
293: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,'');
294:
295: INSERT INTO fv_third_party_temp
296: (original_supplier_name,
297: original_supplier_site,

Line 326: Log_Message(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',g_errbuf, 'N');

322: WHEN OTHERS THEN
323: g_retcode := SQLCODE;
324: g_errbuf := SQLERRM ||
325: ' -- Error in Populate_Third_Party_Temp Procedure when inserting record into fv_third_party_temp table';
326: Log_Message(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',g_errbuf, 'N');
327: END POPULATE_THIRD_PARTY_TEMP;
328:
329:
330: -- -------------------------------------------------------------

Line 357: Log_Message(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',g_errbuf, 'N');

353: WHEN OTHERS THEN
354: g_retcode := SQLCODE;
355: g_errbuf := SQLERRM ||
356: ' -- Error in Vendor_Name Function finding vendor name';
357: Log_Message(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',g_errbuf, 'N');
358: END VENDOR_NAME;
359:
360:
361: -- -------------------------------------------------------------

Line 388: Log_Message(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',g_errbuf, 'N');

384: WHEN OTHERS THEN
385: g_retcode := SQLCODE;
386: g_errbuf := SQLERRM ||
387: ' -- Error in Vendor_Site Function finding vendor site code';
388: Log_Message(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',g_errbuf, 'N');
389: END VENDOR_SITE;
390:
391:
392: -- -------------------------------------------------------------

Line 454: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

450: 'NEGOTIABLE', 'RECONCILED', 'RECONCILED UNACCOUNTED');
451: BEGIN
452: l_module_name := g_module_name || 'PROCESS_TPP_CHECK_DETAIL_RECS';
453: g_message := ' Processing Fv_Tpp_Check_Detail records ...';
454: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
455:
456: BEGIN
457: l_row_cursor := DBMS_SQL.OPEN_CURSOR;
458: EXCEPTION

Line 463: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,g_errbuf, 'N');

459: WHEN OTHERS THEN
460: g_retcode := SQLCODE;
461: g_errbuf := SQLERRM ||
462: ' -- Error when opening the cursor in Process_Tpp_Check_Detail_Recs Procedure';
463: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,g_errbuf, 'N');
464: END;
465:
466: -- Build up the where clause and the from clause based on the
467: -- parameters entered in the SRS request for Third Party

Line 524: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

520: AND tpp.org_id = '|| g_org_id ||'
521: AND fvcd.assignment_id = tpp.assignment_id';
522:
523: g_message := l_row_select;
524: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
525: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,'');
526:
527: BEGIN
528: DBMS_SQL.PARSE(l_row_cursor, l_row_select, DBMS_SQL.V7);

Line 525: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,'');

521: AND fvcd.assignment_id = tpp.assignment_id';
522:
523: g_message := l_row_select;
524: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
525: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,'');
526:
527: BEGIN
528: DBMS_SQL.PARSE(l_row_cursor, l_row_select, DBMS_SQL.V7);
529: EXCEPTION

Line 534: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,g_errbuf, 'N');

530: WHEN OTHERS THEN
531: g_retcode := SQLCODE;
532: g_errbuf := SQLERRM ||
533: ' -- Error when parsing through the cursor in Process_Tpp_Check_Detail_Recs Procedure';
534: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,g_errbuf, 'N');
535: END;
536:
537: DBMS_SQL.DEFINE_COLUMN(l_row_cursor, 1, l_assignment_id);
538: DBMS_SQL.DEFINE_COLUMN(l_row_cursor, 2, l_original_supplier_id);

Line 552: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,g_errbuf, 'N');

548: WHEN OTHERS THEN
549: g_retcode := SQLCODE;
550: g_errbuf := SQLERRM ||
551: ' -- Error when executing the cursor in Process_Tpp_Check_Detail_Recs Procedure';
552: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,g_errbuf, 'N');
553: END;
554:
555: LOOP
556: l_assignment_id := NULL;

Line 586: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,g_message, 'N');

582: THEN
583: IF (k = 0)
584: THEN
585: g_message := ' NO DATA FOUND : Found no rows that satisfy the search criteria - Exiting from Process_Tpp_Check_Detail_Recs Procedure';
586: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,g_message, 'N');
587: g_data_found := 'N';
588: END IF;
589:
590: EXIT; -- Exit the loop

Line 606: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

602: DBMS_SQL.COLUMN_VALUE(l_row_cursor, 6, l_checkrun_name);
603: DBMS_SQL.COLUMN_VALUE(l_row_cursor, 7, l_check_num_fvtpp);
604:
605: g_message := ' Assignment Id: '|| l_assignment_id;
606: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
607:
608: IF (g_checkrun_name IS NULL)
609: THEN
610: g_message := ' Payment Batch Name: '|| l_checkrun_name;

Line 611: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

607:
608: IF (g_checkrun_name IS NULL)
609: THEN
610: g_message := ' Payment Batch Name: '|| l_checkrun_name;
611: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
612: END IF;
613:
614: BEGIN
615: SELECT bank_account_id

Line 621: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

617: FROM ap_invoice_selection_criteria
618: WHERE checkrun_name = l_checkrun_name;
619:
620: g_message := ' Bank Account Id: '|| l_bank_account_id;
621: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
622: EXCEPTION
623: WHEN OTHERS THEN
624: g_retcode := SQLCODE;
625: g_errbuf := SQLERRM ||

Line 627: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,g_errbuf, 'N');

623: WHEN OTHERS THEN
624: g_retcode := SQLCODE;
625: g_errbuf := SQLERRM ||
626: ' -- Error in Process_Tpp_Check_Detail_Recs Procedure when finding bank_account_id for the Payment Batch';
627: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,g_errbuf, 'N');
628: END;
629:
630: FOR l_checks_invoices_rec IN l_checks_invoices_cur
631: LOOP

Line 640: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

636: l_invoice_amount := l_checks_invoices_rec.invoice_amount;
637: l_discount_amount := l_checks_invoices_rec.discount_amount_taken;
638:
639: g_message := ' Check Number: '|| l_check_number;
640: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
641:
642: g_message := ' Check Date: '|| l_check_date;
643: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
644:

Line 643: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

639: g_message := ' Check Number: '|| l_check_number;
640: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
641:
642: g_message := ' Check Date: '|| l_check_date;
643: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
644:
645: g_message := ' Check Amount: '|| l_check_amount;
646: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
647:

Line 646: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

642: g_message := ' Check Date: '|| l_check_date;
643: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
644:
645: g_message := ' Check Amount: '|| l_check_amount;
646: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
647:
648: g_message := ' Invoice Number: '|| l_invoice_num;
649: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
650:

Line 649: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

645: g_message := ' Check Amount: '|| l_check_amount;
646: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
647:
648: g_message := ' Invoice Number: '|| l_invoice_num;
649: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
650:
651: g_message := ' Invoice Amount: '|| l_invoice_amount;
652: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
653:

Line 652: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

648: g_message := ' Invoice Number: '|| l_invoice_num;
649: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
650:
651: g_message := ' Invoice Amount: '|| l_invoice_amount;
652: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
653:
654: g_message := ' Discount Amount Taken: '|| l_discount_amount;
655: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
656:

Line 655: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

651: g_message := ' Invoice Amount: '|| l_invoice_amount;
652: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
653:
654: g_message := ' Discount Amount Taken: '|| l_discount_amount;
655: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
656:
657: -- Set the values for the FOR loop range below, depending
658: -- on the Original/Third Party Agent name and site
659: -- parameter values for Third Party Remittance SRS

Line 716: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,g_errbuf, 'N');

712: g_errbuf := SQLERRM ||
713: ' -- Error in Process_Tpp_Check_Detail_Recs Procedure when finding Third Party vendor info';
714:
715: END IF;
716: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,g_errbuf, 'N');
717: END;
718:
719: IF i = 1
720: THEN

Line 725: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

721: l_original_supplier := l_vendor_name;
722: l_original_site := l_site_code;
723:
724: g_message := ' Original Supplier: '|| l_original_supplier;
725: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
726:
727: g_message := ' Original Supplier Site: '|| l_original_site;
728: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
729:

Line 728: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

724: g_message := ' Original Supplier: '|| l_original_supplier;
725: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
726:
727: g_message := ' Original Supplier Site: '|| l_original_site;
728: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
729:
730: ELSE
731: l_third_party_agent := l_vendor_name;
732: l_third_party_site := l_site_code;

Line 735: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

731: l_third_party_agent := l_vendor_name;
732: l_third_party_site := l_site_code;
733:
734: g_message := ' Third Party Agent: '|| l_third_party_agent;
735: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
736:
737: g_message := ' Third Party Site: '|| l_third_party_site;
738: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
739: END IF;

Line 738: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

734: g_message := ' Third Party Agent: '|| l_third_party_agent;
735: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
736:
737: g_message := ' Third Party Site: '|| l_third_party_site;
738: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
739: END IF;
740: END LOOP;
741: END IF; /* l <> 0 AND j <> 0 */
742:

Line 757: Log_Message(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',g_errbuf, 'N');

753: WHEN OTHERS THEN
754: g_retcode := SQLCODE;
755: g_errbuf := SQLERRM ||
756: ' -- Error in Process_Tpp_Check_Detail_Recs Procedure';
757: Log_Message(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',g_errbuf, 'N');
758: END PROCESS_TPP_CHECK_DETAIL_RECS;
759:
760:
761: -- -------------------------------------------------------------

Line 779: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

775: l_message VARCHAR2(240);
776: BEGIN
777: g_message := '';
778: l_module_name := g_module_name || 'SUBMIT_REPORT';
779: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
780:
781: g_message := ' Submitting the Third Party Remittance report ...';
782: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
783:

Line 782: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

778: l_module_name := g_module_name || 'SUBMIT_REPORT';
779: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
780:
781: g_message := ' Submitting the Third Party Remittance report ...';
782: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
783:
784: l_req_id := FND_REQUEST.SUBMIT_REQUEST('FV', 'FVTPPREM', '', '', FALSE,
785: g_sob_id, g_org_id,
786: g_checkrun_name, g_pay_date_from,

Line 792: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

788: g_from_site_code, g_to_supp_name,
789: g_to_site_code, g_sort_by);
790:
791: g_message := ' Request Id: '|| l_req_id;
792: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
793:
794: IF (l_req_id = 0)
795: THEN
796: g_message := ' Cannot submit Third Party Remittance report';

Line 797: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,g_message, 'N');

793:
794: IF (l_req_id = 0)
795: THEN
796: g_message := ' Cannot submit Third Party Remittance report';
797: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,g_message, 'N');
798:
799: g_retcode := 2;
800: g_errbuf := g_message;
801:

Line 806: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

802: ROLLBACK;
803: RETURN;
804: ELSE
805: g_message := ' Third Party Remittance report submitted';
806: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
807:
808: COMMIT;
809: END IF;
810:

Line 817: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,g_message, 'N');

813:
814: IF (l_call_status = FALSE)
815: THEN
816: g_message := ' Cannot wait for the status of Third Party Payments report: '|| l_message;
817: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,g_message, 'N');
818:
819: g_retcode := 2;
820: g_errbuf := g_message;
821: ELSE

Line 825: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);

821: ELSE
822: IF (l_dphase = 'COMPLETE' AND l_dstatus = 'NORMAL')
823: THEN
824: g_message := ' Third Party Payments report completed normal';
825: Log_Message(FND_LOG.LEVEL_STATEMENT,l_module_name,g_message);
826:
827: COMMIT;
828: ELSE
829: g_message := ' Third Party Payments report did not complete normally: '|| l_message;

Line 830: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,g_message, 'N');

826:
827: COMMIT;
828: ELSE
829: g_message := ' Third Party Payments report did not complete normally: '|| l_message;
830: Log_Message(FND_LOG.LEVEL_ERROR,l_module_name,g_message, 'N');
831:
832: g_retcode := 2;
833: g_errbuf := g_message;
834: END IF;

Line 841: Log_Message(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',g_errbuf, 'N');

837: WHEN OTHERS THEN
838: g_retcode := SQLCODE;
839: g_errbuf := SQLERRM ||
840: ' -- Error in Submit_Report Procedure';
841: Log_Message(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',g_errbuf, 'N');
842: END SUBMIT_REPORT;
843: BEGIN
844:
845: --MOAC changes, to derive the org_id and sob_id