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

Line 51: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

47:
48: BEGIN
49: x_error_code := g_SUCCESS;
50: l_message := 'Validating schedule number, Parameters: p_format_name = ' || p_format_name || ', p_instruction_id = ' || p_pinstr_id ;
51: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
52:
53:
54: OPEN sch_num_csr(p_pinstr_id);
55: FETCH sch_num_csr into l_sch_num_rec;

Line 72: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

68: END LOOP;
69:
70: IF l_position=0 THEN
71: l_message := 'pay_admin_assigned_ref_code = ' || l_sch_num_rec.pay_admin_assigned_ref_code;
72: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
73: x_error_mesg := 'The Reference Assigned by Administrator number must contain only valid characters of "0-9" or "A-Z" ';
74: p_docErrorRec.transaction_error_id := null;
75: p_docErrorRec.error_code := 'INVALID_SCHEDULE_NUMBER';
76: p_docErrorRec.error_message := x_error_mesg;

Line 79: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

75: p_docErrorRec.error_code := 'INVALID_SCHEDULE_NUMBER';
76: p_docErrorRec.error_message := x_error_mesg;
77: x_error_code := g_ERROR;
78: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec,p_docErrorTab);
79: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
80: RETURN;
81: END IF;
82:
83: ELSE

Line 91: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

87: l_char := substr(l_sch_num_rec.pay_admin_assigned_ref_code,l_incre,l_constant);
88:
89: IF (l_position = 1) AND (l_char = '0') THEN
90: l_message := 'pay_admin_assigned_ref_code = ' || l_sch_num_rec.pay_admin_assigned_ref_code;
91: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
92: x_error_mesg := 'The Reference Assigned by Administrator number must contain only valid characters of "0-9", "A-Z" or "-" and the first character must not be a zero.';
93: p_docErrorRec.transaction_error_id := null;
94: p_docErrorRec.error_code := 'INVALID_SCHEDULE_NUMBER';
95: p_docErrorRec.error_message := x_error_mesg;

Line 98: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

94: p_docErrorRec.error_code := 'INVALID_SCHEDULE_NUMBER';
95: p_docErrorRec.error_message := x_error_mesg;
96: x_error_code := g_ERROR;
97: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec,p_docErrorTab);
98: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
99: RETURN;
100:
101: END IF; -- if first position of schedulenum is zero
102:

Line 105: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

101: END IF; -- if first position of schedulenum is zero
102:
103: IF NOT ((UPPER(l_char) BETWEEN 'A' and 'Z') OR (l_char between '0' and '9') OR (l_char = '-')) THEN
104: l_message := 'pay_admin_assigned_ref_code = ' || l_sch_num_rec.pay_admin_assigned_ref_code;
105: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
106: x_error_mesg := 'The Reference Assigned by Administrator number must contain only valid characters of "0-9", "A-Z" or "-" and the first character must not be a zero.';
107: p_docErrorRec.transaction_error_id := null;
108: p_docErrorRec.error_code := 'INVALID_SCHEDULE_NUMBER';
109: p_docErrorRec.error_message := x_error_mesg;

Line 112: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

108: p_docErrorRec.error_code := 'INVALID_SCHEDULE_NUMBER';
109: p_docErrorRec.error_message := x_error_mesg;
110: x_error_code := g_ERROR;
111: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec,p_docErrorTab);
112: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
113: RETURN;
114: END IF; -- schedulenum has characters other than A-Z 1-0 -
115:
116: END LOOP;

Line 126: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

122: EXCEPTION
123: WHEN OTHERS THEN
124: x_error_code := g_FAILURE;
125: x_error_mesg := SQLERRM;
126: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
127: p_docErrorRec.transaction_error_id := null;
128: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
129: p_docErrorRec.error_message := x_error_mesg;
130: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line 203: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

199:
200: BEGIN
201: x_error_code := g_SUCCESS;
202: l_message := 'Validating Supplier Type, Parameters: p_format_name = ' || p_format_name || ', p_payment_instruction_id = ' || p_instruction_id ;
203: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
204:
205: IF p_format_name IN ('FVTPCCD','FVTIACHP','FVSPCCD','FVSPCCDP', 'FVTICTX' ,'FVBLCCDP') THEN
206:
207:

Line 228: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

224: CLOSE vendor_type_csr;
225: -- All Vendors Should Be Non-Employee
226: IF UPPER(l_vendor_type) = 'EMPLOYEE' THEN
227: l_message := 'invoice_id = ' || l_inv_str || ' vendor_id = ' || l_vendor_id || ' vendor_type = ' || l_vendor_type;
228: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
229: x_error_mesg := 'The vendor for invoice '|| l_invoice_num || ' cannot be of type EMPLOYEE.';
230: p_docErrorRec.transaction_error_id := null;
231: p_docErrorRec.error_code := 'INV_IS_EMPLOYEE';
232: p_docErrorRec.error_message := x_error_mesg;

Line 235: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

231: p_docErrorRec.error_code := 'INV_IS_EMPLOYEE';
232: p_docErrorRec.error_message := x_error_mesg;
233: x_error_code := g_ERROR;
234: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
235: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
236: END IF;
237:
238:
239: END LOOP; -- End of For Each Invoice Loop

Line 264: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

260:
261: -- All Vendors Should Be Employee
262: IF UPPER(l_vendor_type) <> 'EMPLOYEE' THEN
263: l_message := 'invoice_id = ' || l_inv_str || ' vendor_id = ' || l_vendor_id || 'vendor_type = ' || l_vendor_type;
264: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
265: x_error_mesg := 'The vendor for invoice '|| l_invoice_num || ' must be of type EMPLOYEE.';
266: p_docErrorRec.transaction_error_id := null;
267: p_docErrorRec.error_code := 'INV_IS_NOT_EMPLOYEE';
268: p_docErrorRec.error_message := x_error_mesg;

Line 271: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

267: p_docErrorRec.error_code := 'INV_IS_NOT_EMPLOYEE';
268: p_docErrorRec.error_message := x_error_mesg;
269: x_error_code := g_ERROR;
270: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
271: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
272: END IF;
273:
274:
275: END LOOP; -- Ending For Each Invoice Loop

Line 307: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

303: END IF;
304: -- Vendor Type Cannot Be a Mix Of Employee And Non Employee. Either All Employees Or All Non-Employees.
305: IF (l_emp=true AND l_non_emp=TRUE) THEN
306: l_message := 'invoice_id = ' || l_inv_str || ' vendor_id = ' || l_vendor_id || ' vendor_type = ' || l_vendor_type;
307: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
308: x_error_mesg := 'All selected invoices must have one vendor type, either EMPLOYEE or NON-EMPLOYEE.';
309: p_docErrorRec.transaction_error_id := null;
310: p_docErrorRec.error_code := 'INV_IS_MIXED_VENDOR_TYPE';
311: p_docErrorRec.error_message := x_error_mesg;

Line 314: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

310: p_docErrorRec.error_code := 'INV_IS_MIXED_VENDOR_TYPE';
311: p_docErrorRec.error_message := x_error_mesg;
312: x_error_code := g_ERROR;
313: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
314: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
315: CLOSE all_invoices_csr;
316: RETURN;
317: END IF;
318:

Line 330: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

326: EXCEPTION
327: WHEN OTHERS THEN
328: x_error_code := g_FAILURE;
329: x_error_mesg := SQLERRM;
330: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
331: p_docErrorRec.transaction_error_id := null;
332: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
333: p_docErrorRec.error_message := x_error_mesg;
334: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line 430: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

426: BEGIN
427: x_error_code := g_SUCCESS;
428:
429: l_message := 'Running Treasury Symbols Process, Parameters: p_format_name = ' || p_format_name || ', p_invoice_id = ' || p_invoice_id || ' p_payment_id = ' || p_payment_id;
430: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
431:
432:
433: -- Get Distribution Code Combination Id For The Invoice Id
434:

Line 464: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

460: p_docErrorRec.error_code := 'NO_TREASURY_SYMBOL';
461: p_docErrorRec.error_message := x_error_mesg;
462: x_error_code := g_ERROR;
463: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
464: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
465:
466: ELSE
467: l_valid := g_SUCCESS; -- initialize l_valid
468: IF p_format_name IN ('FVSPCCD','FVSPCCDP','FVSPNCR','FVSPPPD','FVSPPPDP', 'FVBLCCDP', 'FVBLPPDP') THEN

Line 554: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

550: EXCEPTION
551: WHEN OTHERS THEN
552: x_error_code := g_FAILURE;
553: x_error_mesg := SQLERRM;
554: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
555: p_docErrorRec.transaction_error_id := null;
556: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
557: p_docErrorRec.error_message := x_error_mesg;
558: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line 592: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

588: BEGIN
589: x_error_code := g_SUCCESS;
590:
591: l_message := 'Validating Max Treasury Symbols, Parameters: p_format_name = ' || p_format_name || ', p_instruction_id = ' || p_instruction_id ;
592: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
593:
594:
595: IF p_format_name IN ('FVBLNCR','FVBLSLTR','FVBLCCDP','FVBLPPDP','FVCOCCDP','FVCOPPDP') THEN
596:

Line 612: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

608: p_docErrorRec.error_code := 'TREASURY_SYMBOL_LIMIT';
609: p_docErrorRec.error_message := x_error_mesg;
610: x_error_code := g_ERROR;
611: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
612: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
613: END IF;
614:
615: END IF;
616:

Line 630: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

626: p_docErrorRec.error_code := 'TREASURY_SYMBOLS_LIMIT';
627: p_docErrorRec.error_message := x_error_mesg;
628: x_error_code := g_ERROR;
629: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
630: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
631: END IF;
632: END IF;
633:
634:

Line 639: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

635: EXCEPTION
636: WHEN OTHERS THEN
637: x_error_code := g_FAILURE;
638: x_error_mesg := SQLERRM;
639: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
640: p_docErrorRec.transaction_error_id := null;
641: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
642: p_docErrorRec.error_message := x_error_mesg;
643: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line 685: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

681: BEGIN
682: x_error_code := g_SUCCESS;
683:
684: l_message := 'Validating Agency Address, Parameters: p_format_name = ' || p_format_name || ', p_org_id = ' || p_org_id ;
685: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
686:
687: OPEN get_agency_address_csr(p_org_id);
688: FETCH get_agency_address_csr INTO l_agencyadd_rec;
689: CLOSE get_agency_address_csr;

Line 704: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

700: p_docErrorRec.error_code := 'INVALID_AGENCY_ADDRESS';
701: p_docErrorRec.error_message := x_error_mesg;
702: x_error_code := g_ERROR;
703: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
704: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
705: END IF;
706:
707:
708: EXCEPTION

Line 712: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

708: EXCEPTION
709: WHEN OTHERS THEN
710: x_error_code := g_FAILURE;
711: x_error_mesg := SQLERRM;
712: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
713: p_docErrorRec.transaction_error_id := null;
714: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
715: p_docErrorRec.error_message := x_error_mesg;
716: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line 758: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

754: BEGIN
755: x_error_code := g_SUCCESS;
756:
757: l_message := 'Validating Payee Address, Parameters: p_format_name = ' || p_format_name || ', p_payment_id = ' || p_payment_id ;
758: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
759:
760: OPEN get_payee_address_csr(p_payment_id);
761: FETCH get_payee_address_csr INTO l_payeeadd_rec;
762: CLOSE get_payee_address_csr;

Line 779: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

775: p_docErrorRec.error_code := 'INVALID_PAYEE_ADDRESS';
776: p_docErrorRec.error_message := x_error_mesg;
777: x_error_code := g_ERROR;
778: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
779: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
780: END IF;
781:
782:
783: EXCEPTION

Line 787: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

783: EXCEPTION
784: WHEN OTHERS THEN
785: x_error_code := g_FAILURE;
786: x_error_mesg := SQLERRM;
787: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
788: p_docErrorRec.transaction_error_id := null;
789: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
790: p_docErrorRec.error_message := x_error_mesg;
791: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line 824: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

820: BEGIN
821: x_error_code := g_SUCCESS;
822:
823: l_message := 'Validating Max Payment Amount, Parameters: p_format_name = ' || p_format_name || ', p_instruction_id = ' || p_instruction_id ;
824: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
825:
826: IF p_payment_amount > 9999999.99 THEN
827: x_error_mesg := 'Payment Amount Exceeds the limit of $9,999,999.99';
828: p_docErrorRec.transaction_error_id := null;

Line 833: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

829: p_docErrorRec.error_code := 'INVALID_BULK_NCR_CHK_PAY';
830: p_docErrorRec.error_message := x_error_mesg;
831: x_error_code := g_ERROR;
832: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
833: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
834: END IF;
835:
836: EXCEPTION
837: WHEN OTHERS THEN

Line 840: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

836: EXCEPTION
837: WHEN OTHERS THEN
838: x_error_code := g_FAILURE;
839: x_error_mesg := SQLERRM;
840: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
841: p_docErrorRec.transaction_error_id := null;
842: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
843: p_docErrorRec.error_message := x_error_mesg;
844: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line 878: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

874:
875: x_error_code := g_SUCCESS;
876:
877: l_message := 'Validating Max Payment Amount 2, Parameters: p_format_name = ' || p_format_name || ', p_instruction_id = ' || p_instruction_id ;
878: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
879:
880: IF p_payment_amount > 999999.99 THEN
881: x_error_mesg := 'Payment Amount Exceeds the limit of $999,999.99';
882: p_docErrorRec.transaction_error_id := null;

Line 887: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

883: p_docErrorRec.error_code := 'INVALID_INVOICE_AMOUNT';
884: p_docErrorRec.error_message := x_error_mesg;
885: x_error_code := g_ERROR;
886: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
887: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
888: END IF;
889:
890:
891: EXCEPTION

Line 895: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

891: EXCEPTION
892: WHEN OTHERS THEN
893: x_error_code := g_FAILURE;
894: x_error_mesg := SQLERRM;
895: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
896: p_docErrorRec.transaction_error_id := null;
897: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
898: p_docErrorRec.error_message := x_error_mesg;
899: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line 934: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

930: BEGIN
931: x_error_code := g_SUCCESS;
932:
933: l_message := 'Validating Pay Tax Benefit, Parameters: p_format_name = ' || p_format_name || ', p_invoice_id = ' || p_invoice_id ;
934: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
935:
936: SELECT idpa.payment_reason_code,
937: asup.vendor_type_lookup_code
938: INTO l_payment_reason_code,

Line 963: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

959: p_docErrorRec.error_message := x_error_mesg;
960: x_error_code := g_ERROR;
961: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
962: l_message := 'Invalid reason code for type of vendor, reason_code = ' || l_payment_reason_code || ', vendor_type_code = ' || l_vendor_type_lookup_code;
963: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
964: END IF;
965: ELSE -- vendor is of type organization
966: IF (l_payment_reason_code <> 'US_FV_V') THEN
967: x_error_mesg := 'Payments to a Standard Supplier can only have a payment reason code of ''Vendor Payment Sub-Type'' ';

Line 974: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

970: p_docErrorRec.error_message := x_error_mesg;
971: x_error_code := g_ERROR;
972: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
973: l_message := 'Invalid reason code for type of vendor, reason_code = ' || l_payment_reason_code || ', vendor_type_code = ' || l_vendor_type_lookup_code;
974: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
975: END IF;
976: END IF;
977:
978: EXCEPTION

Line 982: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

978: EXCEPTION
979: WHEN OTHERS THEN
980: x_error_code := g_FAILURE;
981: x_error_mesg := SQLERRM;
982: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
983: p_docErrorRec.transaction_error_id := null;
984: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
985: p_docErrorRec.error_message := x_error_mesg;
986: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line 1019: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

1015: BEGIN
1016: x_error_code := g_SUCCESS;
1017:
1018: l_message := 'Validating Pay Salary Travel, Parameters: p_format_name = ' || p_format_name || ', p_reason_code = ' || p_reason_code ;
1019: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1020:
1021: IF p_reason_code IS NULL OR p_reason_code NOT IN ('US_FV_S','US_FV_T') THEN
1022: x_error_mesg := 'The Check Salary / Travel NCR payments can only be generated for Salary or Travel payments. The Reason Code must be related to Salary or Travel';
1023: p_docErrorRec.transaction_error_id := null;

Line 1028: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1024: p_docErrorRec.error_code := 'INVALID_PAY_SALARY_TRAVEL';
1025: p_docErrorRec.error_message := x_error_mesg;
1026: x_error_code := g_ERROR;
1027: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1028: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1029: END IF;
1030:
1031: EXCEPTION
1032: WHEN OTHERS THEN

Line 1035: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1031: EXCEPTION
1032: WHEN OTHERS THEN
1033: x_error_code := g_FAILURE;
1034: x_error_mesg := SQLERRM;
1035: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1036: p_docErrorRec.transaction_error_id := null;
1037: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1038: p_docErrorRec.error_message := x_error_mesg;
1039: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line 1077: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

1073:
1074: x_error_code := g_SUCCESS;
1075:
1076: l_message := 'Validating Payee SSN, Parameters: p_format_name = ' || p_format_name || ', p_ssn_tin = ' || p_ssn_tin ;
1077: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1078:
1079: begin
1080: select party_name
1081: into l_party_name

Line 1097: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1093: p_docErrorRec.error_code := 'NO_SSN_TIN';
1094: p_docErrorRec.error_message := x_error_mesg;
1095: x_error_code := g_ERROR;
1096: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1097: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1098: END IF;
1099:
1100:
1101: EXCEPTION

Line 1105: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1101: EXCEPTION
1102: WHEN OTHERS THEN
1103: x_error_code := g_FAILURE;
1104: x_error_mesg := SQLERRM;
1105: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1106: p_docErrorRec.transaction_error_id := null;
1107: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1108: p_docErrorRec.error_message := x_error_mesg;
1109: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line 1150: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

1146: l_string := UPPER(p_treasury_symbol);
1147: l_length := LENGTH(l_string);
1148:
1149: l_message := 'TAS Validation, Parameters: p_format_name = ' || p_format_name || ', p_treasury_symbol = ' || p_treasury_symbol ;
1150: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1151:
1152:
1153: IF l_length < 7 THEN
1154: x_error_mesg := 'The Treasury Symbol ' || p_treasury_symbol || ' must contain a minimum of 7 characters';

Line 1160: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1156: p_docErrorRec.error_code := 'TREASURY_SYMBOL_LENGTH';
1157: p_docErrorRec.error_message := x_error_mesg;
1158: x_error_code := g_ERROR;
1159: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1160: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1161: ELSE
1162: l_char_string := 'ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890/.()';
1163:
1164: FOR i in 1..l_length

Line 1177: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1173: p_docErrorRec.error_code := 'INVALID_TREASURY_SYMBOL';
1174: p_docErrorRec.error_message := x_error_mesg;
1175: x_error_code := g_ERROR;
1176: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1177: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1178: END IF;
1179:
1180:
1181: END IF;

Line 1187: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1183: EXCEPTION
1184: WHEN OTHERS THEN
1185: x_error_code := g_FAILURE;
1186: x_error_mesg := SQLERRM;
1187: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1188: p_docErrorRec.transaction_error_id := null;
1189: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1190: p_docErrorRec.error_message := x_error_mesg;
1191: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line 1226: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

1222: BEGIN
1223: x_error_code := g_SUCCESS;
1224:
1225: l_message := 'Validating Agency Location Code, Parameters: p_format_name = ' || p_format_name || ', p_agency_location_code = ' || p_agency_location_code ;
1226: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1227:
1228: IF p_agency_location_code IS NULL THEN -- Agency Location Code Should Not Be Empty.
1229: x_error_mesg := 'Agency Location Code captured in Bank Account Details window, is not defined for Bank Account ' || p_bank_account_name;
1230: x_error_mesg := x_error_mesg || '. Please correct the error, terminate this request and submit a new request';

Line 1236: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1232: p_docErrorRec.error_code := 'NO_AGENCY_LOCATION_CODE';
1233: p_docErrorRec.error_message := x_error_mesg;
1234: x_error_code := g_ERROR;
1235: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1236: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1237: END IF;
1238:
1239:
1240: EXCEPTION

Line 1244: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1240: EXCEPTION
1241: WHEN OTHERS THEN
1242: x_error_code := g_FAILURE;
1243: x_error_mesg := SQLERRM;
1244: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1245: p_docErrorRec.transaction_error_id := null;
1246: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1247: p_docErrorRec.error_message := x_error_mesg;
1248: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line 1294: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

1290: BEGIN
1291: x_error_code := g_SUCCESS;
1292:
1293: l_message := 'Validating RTN Number, Parameters: p_format_name = ' || p_format_name || ', p_rtn_number = ' || p_rtn_number ;
1294: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1295:
1296:
1297: if (p_rtn_number is null) then
1298: x_error_mesg := 'Invalid Routing Number';

Line 1305: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1301: p_docErrorRec.error_code := 'INVALID_RTN';
1302: p_docErrorRec.error_message := x_error_mesg;
1303: x_error_code := g_ERROR;
1304: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1305: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1306: RETURN;
1307: end if;
1308:
1309:

Line 1377: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1373: p_docErrorRec.error_code := 'INVALID_RTN';
1374: p_docErrorRec.error_message := x_error_mesg;
1375: x_error_code := g_ERROR;
1376: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1377: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1378: END IF;
1379:
1380: ELSE
1381: -- failed, not a 9 digit numeric value

Line 1388: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1384: p_docErrorRec.error_code := 'INVALID_RTN';
1385: p_docErrorRec.error_message := x_error_mesg;
1386: x_error_code := g_ERROR;
1387: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1388: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1389: END IF;
1390:
1391:
1392: EXCEPTION

Line 1396: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1392: EXCEPTION
1393: WHEN OTHERS THEN
1394: x_error_code := g_FAILURE;
1395: x_error_mesg := SQLERRM;
1396: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1397: p_docErrorRec.transaction_error_id := null;
1398: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1399: p_docErrorRec.error_message := x_error_mesg;
1400: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line 1446: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

1442: BEGIN
1443: x_error_code := g_SUCCESS;
1444:
1445: l_message := 'Validating Pay Alone Option, Parameters: p_format_name = ' || p_format_name || ', p_invoice_id = ' || p_invoice_id ;
1446: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1447:
1448: OPEN get_pay_alone_flag_csr(p_invoice_id);
1449: FETCH get_pay_alone_flag_csr into l_pay_alone_flag, l_invoice_num; -- Getting Pay ALone Flag From AP_INVOICES_ALL using invoice_id
1450: CLOSE get_pay_alone_flag_csr;

Line 1459: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1455: p_docErrorRec.error_code := 'INVALID_PAY_ALONE_FLAG';
1456: p_docErrorRec.error_message := x_error_mesg;
1457: x_error_code := g_ERROR;
1458: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1459: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1460: END IF;
1461:
1462: EXCEPTION
1463: WHEN OTHERS THEN

Line 1466: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1462: EXCEPTION
1463: WHEN OTHERS THEN
1464: x_error_code := g_FAILURE;
1465: x_error_mesg := SQLERRM;
1466: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1467: p_docErrorRec.transaction_error_id := null;
1468: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1469: p_docErrorRec.error_message := x_error_mesg;
1470: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line 1507: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

1503: BEGIN
1504: x_error_code := g_SUCCESS;
1505:
1506: l_message := 'Validating Depositor Account Number, Parameters: p_format_name = ' || p_format_name || ', p_dep_account_no = ' || p_dep_account_no ;
1507: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1508:
1509: IF p_dep_account_no IS NULL THEN --Account Number Should Not Be Empty
1510: x_error_mesg := 'Bank account number missing for vendor';
1511: x_error_mesg := x_error_mesg || '. Please correct the error, terminate this request and submit a new request';

Line 1517: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1513: p_docErrorRec.error_code := 'DEPOSITER_ACCOUNT_NO_MISSING';
1514: p_docErrorRec.error_message := x_error_mesg;
1515: x_error_code := g_ERROR;
1516: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1517: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1518: ELSE
1519: l_string := rtrim(p_dep_account_no);
1520: l_length := length(l_string);
1521: l_char_string := 'ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890-';

Line 1536: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1532: p_docErrorRec.error_code := 'INVALID_DEPOSITER_ACCOUNT_NO';
1533: p_docErrorRec.error_message := x_error_mesg;
1534: x_error_code := g_ERROR;
1535: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1536: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1537: END IF;
1538:
1539: END IF;
1540:

Line 1545: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1541: EXCEPTION
1542: WHEN OTHERS THEN
1543: x_error_code := g_FAILURE;
1544: x_error_mesg := SQLERRM;
1545: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1546: p_docErrorRec.transaction_error_id := null;
1547: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1548: p_docErrorRec.error_message := x_error_mesg;
1549: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line 1588: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

1584:
1585: x_error_code := g_SUCCESS;
1586:
1587: l_message := 'Validating Account Type, Parameters: p_format_name = ' || p_format_name || ', p_bank_account_type = ' || p_bank_account_type ;
1588: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1589:
1590: select invoice_num
1591: into l_invoice_num
1592: from ap_invoices_all

Line 1605: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1601: p_docErrorRec.error_code := 'INVALID_BANK_ACCOUNT_TYPE';
1602: p_docErrorRec.error_message := x_error_mesg;
1603: x_error_code := g_ERROR;
1604: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1605: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1606: END IF;
1607:
1608:
1609: EXCEPTION

Line 1613: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1609: EXCEPTION
1610: WHEN OTHERS THEN
1611: x_error_code := g_FAILURE;
1612: x_error_mesg := SQLERRM;
1613: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1614: p_docErrorRec.transaction_error_id := null;
1615: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1616: p_docErrorRec.error_message := x_error_mesg;
1617: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line 1657: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

1653: BEGIN
1654: x_error_code := g_SUCCESS;
1655:
1656: l_message := 'Validating RFC Id, Parameters: p_format_name = ' || p_format_name || ', p_payment_id = ' || p_payment_id;
1657: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1658:
1659: select hca.class_code,
1660: ipa.internal_bank_account_id,
1661: cba.bank_branch_id,

Line 1685: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

1681: p_docErrorRec.error_code := 'INVALID_RFC_ID';
1682: p_docErrorRec.error_message := x_error_mesg;
1683: x_error_code := g_ERROR;
1684: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1685: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1686:
1687: END IF;
1688:
1689:

Line 1694: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1690: EXCEPTION
1691: WHEN OTHERS THEN
1692: x_error_code := g_FAILURE;
1693: x_error_mesg := SQLERRM;
1694: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1695: p_docErrorRec.transaction_error_id := null;
1696: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1697: p_docErrorRec.error_message := x_error_mesg;
1698: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line 1743: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

1739: BEGIN
1740: x_error_code := g_SUCCESS;
1741:
1742: l_message := 'Validating Reason Code Id, Parameters: p_format_name = ' || p_format_name || ', p_reason_code = ' || p_reason_code ;
1743: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1744:
1745:
1746: IF (p_reason_code IS NULL) OR p_reason_code NOT IN('US_FV_A','US_FV_B','US_FV_C','US_FV_D',
1747: 'US_FV_I','US_FV_M','US_FV_O','US_FV_R',

Line 1756: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1752: p_docErrorRec.error_code := 'INVALID_PAYMENT_REASON';
1753: p_docErrorRec.error_message := x_error_mesg;
1754: x_error_code := g_ERROR;
1755: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1756: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1757:
1758: END IF;
1759:
1760: EXCEPTION

Line 1764: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1760: EXCEPTION
1761: WHEN OTHERS THEN
1762: x_error_code := g_FAILURE;
1763: x_error_mesg := SQLERRM;
1764: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1765: p_docErrorRec.transaction_error_id := null;
1766: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1767: p_docErrorRec.error_message := x_error_mesg;
1768: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line 1803: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

1799: BEGIN
1800: x_error_code := g_SUCCESS;
1801:
1802: l_message := 'Validating External Bank Account Id, Parameters: p_format_name = ' || p_format_name || ', p_external_bank_account_id = ' || p_external_bank_account_id;
1803: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1804:
1805: IF p_external_bank_account_id IS NULL THEN -- p_external_bank_account_id should not be Empty
1806:
1807: x_error_mesg := 'This is an electronic format and requires a remit-to bank account to be entered on the invoice.';

Line 1814: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1810: p_docErrorRec.error_code := 'INVALID_EXTERNAL_BANK_ACCOUNT';
1811: p_docErrorRec.error_message := x_error_mesg;
1812: x_error_code := g_ERROR;
1813: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1814: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1815:
1816: END IF;
1817:
1818: EXCEPTION

Line 1822: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1818: EXCEPTION
1819: WHEN OTHERS THEN
1820: x_error_code := g_FAILURE;
1821: x_error_mesg := SQLERRM;
1822: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1823: p_docErrorRec.transaction_error_id := null;
1824: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1825: p_docErrorRec.error_message := x_error_mesg;
1826: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line 1851: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

1847: x_error_code := g_SUCCESS;
1848:
1849: IF (p_format_name IN ('FVBLCCDP','FVBLPPDP')) THEN
1850: l_message := 'Validating Federal Id Number Id, Parameters: p_format_name = ' || p_format_name;
1851: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1852:
1853: select ipia.org_id, haou.name
1854: into l_org_id, l_org_name
1855: from iby_pay_instructions_all ipia,

Line 1875: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1871: p_docErrorRec.error_code := 'INVALID_FEDERAL_ID_NUMBER';
1872: p_docErrorRec.error_message := x_error_mesg;
1873: x_error_code := g_ERROR;
1874: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1875: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1876:
1877: END IF;
1878: END IF;
1879: EXCEPTION

Line 1888: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1884: p_docErrorRec.error_code := 'INVALID_FEDERAL_ID_NUMBER';
1885: p_docErrorRec.error_message := x_error_mesg;
1886: x_error_code := g_ERROR;
1887: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1888: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1889:
1890: WHEN OTHERS THEN
1891: x_error_code := g_FAILURE;
1892: x_error_mesg := SQLERRM;

Line 1893: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1889:
1890: WHEN OTHERS THEN
1891: x_error_code := g_FAILURE;
1892: x_error_mesg := SQLERRM;
1893: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1894: p_docErrorRec.transaction_error_id := null;
1895: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1896: p_docErrorRec.error_message := x_error_mesg;
1897: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line 1920: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

1916: BEGIN
1917: x_error_code := g_SUCCESS;
1918:
1919: l_message := 'Validating Agency Id Abbreviation, Parameters: p_format_name = ' || p_format_name || ', p_instruction_id = ' || p_instruction_id ;
1920: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1921:
1922:
1923: IF p_format_name IN ('FVBLNCR','FVBLSLTR','FVBLCCDP','FVBLPPDP','FVTICTX') THEN
1924:

Line 1933: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1929: p_docErrorRec.error_code := 'AGENCY_ABBREV_UNDEFINED';
1930: p_docErrorRec.error_message := x_error_mesg;
1931: x_error_code := g_ERROR;
1932: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1933: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1934:
1935: END IF;
1936:
1937: END IF;

Line 1944: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);

1940: EXCEPTION
1941: WHEN OTHERS THEN
1942: x_error_code := g_FAILURE;
1943: x_error_mesg := SQLERRM;
1944: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1945: p_docErrorRec.transaction_error_id := null;
1946: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1947: p_docErrorRec.error_message := x_error_mesg;
1948: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line 1977: fnd_log.string (p_level, p_module, p_message);

1973:
1974: BEGIN
1975:
1976: IF (p_level >= g_current_level) THEN
1977: fnd_log.string (p_level, p_module, p_message);
1978: END IF;
1979:
1980: -- log messages only if concurrent program
1981: IF (FND_GLOBAL.conc_request_id <> -1) THEN

Line 1994: g_current_level := fnd_log.g_current_runtime_level;

1990: g_module_name := 'fv.plsql.IBY_PAYMENT_FORMAT_VAL_PVT.';
1991: g_ERROR := -1;
1992: g_FAILURE := -2;
1993: g_SUCCESS := 0;
1994: g_current_level := fnd_log.g_current_runtime_level;
1995:
1996:
1997: END IBY_PAYMENT_FORMAT_VAL_PVT;