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 205: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

427: BEGIN
428: x_error_code := g_SUCCESS;
429:
430: 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;
431: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
432:
433:
434: -- Get Distribution Code Combination Id For The Invoice Id
435:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

779: p_docErrorRec.error_code := 'INVALID_PAYEE_ADDRESS';
780: p_docErrorRec.error_message := x_error_mesg;
781: x_error_code := g_ERROR;
782: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
783: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
784: END IF;
785:
786:
787: EXCEPTION

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

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

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

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

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

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

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

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

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

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

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

887: p_docErrorRec.error_code := 'INVALID_INVOICE_AMOUNT';
888: p_docErrorRec.error_message := x_error_mesg;
889: x_error_code := g_ERROR;
890: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
891: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
892: END IF;
893:
894:
895: EXCEPTION

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

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

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

934: BEGIN
935: x_error_code := g_SUCCESS;
936:
937: l_message := 'Validating Pay Tax Benefit, Parameters: p_format_name = ' || p_format_name || ', p_invoice_id = ' || p_invoice_id ;
938: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
939: -- Bug : 11740157 : Validate only active documents.
940: SELECT idpa.payment_reason_code,
941: asup.vendor_type_lookup_code
942: INTO l_payment_reason_code,

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

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

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

977: p_docErrorRec.error_message := x_error_mesg;
978: x_error_code := g_ERROR;
979: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
980: l_message := 'Invalid reason code for type of vendor, reason_code = ' || l_payment_reason_code || ', vendor_type_code = ' || l_vendor_type_lookup_code;
981: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
982: END IF;
983: END IF;
984:
985: EXCEPTION

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

985: EXCEPTION
986: WHEN OTHERS THEN
987: x_error_code := g_FAILURE;
988: x_error_mesg := SQLERRM;
989: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
990: p_docErrorRec.transaction_error_id := null;
991: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
992: p_docErrorRec.error_message := x_error_mesg;
993: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

1022: BEGIN
1023: x_error_code := g_SUCCESS;
1024:
1025: l_message := 'Validating Pay Salary Travel, Parameters: p_format_name = ' || p_format_name || ', p_reason_code = ' || p_reason_code ;
1026: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1027:
1028: IF p_reason_code IS NULL OR p_reason_code NOT IN ('US_FV_S','US_FV_T') THEN
1029: 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';
1030: p_docErrorRec.transaction_error_id := null;

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

1031: p_docErrorRec.error_code := 'INVALID_PAY_SALARY_TRAVEL';
1032: p_docErrorRec.error_message := x_error_mesg;
1033: x_error_code := g_ERROR;
1034: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1035: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1036: END IF;
1037:
1038: EXCEPTION
1039: WHEN OTHERS THEN

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

1038: EXCEPTION
1039: WHEN OTHERS THEN
1040: x_error_code := g_FAILURE;
1041: x_error_mesg := SQLERRM;
1042: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1043: p_docErrorRec.transaction_error_id := null;
1044: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1045: p_docErrorRec.error_message := x_error_mesg;
1046: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

1080:
1081: x_error_code := g_SUCCESS;
1082:
1083: l_message := 'Validating Payee SSN, Parameters: p_format_name = ' || p_format_name || ', p_ssn_tin = ' || p_ssn_tin ;
1084: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1085:
1086: begin
1087: select party_name
1088: into l_party_name

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

1100: p_docErrorRec.error_code := 'NO_SSN_TIN';
1101: p_docErrorRec.error_message := x_error_mesg;
1102: x_error_code := g_ERROR;
1103: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1104: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1105: END IF;
1106:
1107:
1108: EXCEPTION

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

1108: EXCEPTION
1109: WHEN OTHERS THEN
1110: x_error_code := g_FAILURE;
1111: x_error_mesg := SQLERRM;
1112: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1113: p_docErrorRec.transaction_error_id := null;
1114: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1115: p_docErrorRec.error_message := x_error_mesg;
1116: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

1153: l_string := UPPER(p_treasury_symbol);
1154: l_length := LENGTH(l_string);
1155:
1156: l_message := 'TAS Validation, Parameters: p_format_name = ' || p_format_name || ', p_treasury_symbol = ' || p_treasury_symbol ;
1157: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1158:
1159:
1160: IF l_length < 4 THEN
1161: x_error_mesg := 'The Treasury Symbol ' || p_treasury_symbol || ' must contain a minimum of 4 characters';

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

1163: p_docErrorRec.error_code := 'TREASURY_SYMBOL_LENGTH';
1164: p_docErrorRec.error_message := x_error_mesg;
1165: x_error_code := g_ERROR;
1166: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1167: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1168: ELSE
1169: l_char_string := 'ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890/.()';
1170:
1171: FOR i in 1..l_length

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

1180: p_docErrorRec.error_code := 'INVALID_TREASURY_SYMBOL';
1181: p_docErrorRec.error_message := x_error_mesg;
1182: x_error_code := g_ERROR;
1183: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1184: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1185: END IF;
1186:
1187:
1188: END IF;

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

1190: EXCEPTION
1191: WHEN OTHERS THEN
1192: x_error_code := g_FAILURE;
1193: x_error_mesg := SQLERRM;
1194: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1195: p_docErrorRec.transaction_error_id := null;
1196: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1197: p_docErrorRec.error_message := x_error_mesg;
1198: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

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

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

1239: p_docErrorRec.error_code := 'NO_AGENCY_LOCATION_CODE';
1240: p_docErrorRec.error_message := x_error_mesg;
1241: x_error_code := g_ERROR;
1242: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1243: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1244: END IF;
1245:
1246:
1247: EXCEPTION

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

1247: EXCEPTION
1248: WHEN OTHERS THEN
1249: x_error_code := g_FAILURE;
1250: x_error_mesg := SQLERRM;
1251: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1252: p_docErrorRec.transaction_error_id := null;
1253: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1254: p_docErrorRec.error_message := x_error_mesg;
1255: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

1297: BEGIN
1298: x_error_code := g_SUCCESS;
1299:
1300: l_message := 'Validating RTN Number, Parameters: p_format_name = ' || p_format_name || ', p_rtn_number = ' || p_rtn_number ;
1301: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1302:
1303:
1304: if (p_rtn_number is null) then
1305: x_error_mesg := 'Invalid Routing Number';

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

1308: p_docErrorRec.error_code := 'INVALID_RTN';
1309: p_docErrorRec.error_message := x_error_mesg;
1310: x_error_code := g_ERROR;
1311: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1312: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1313: RETURN;
1314: end if;
1315:
1316:

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

1380: p_docErrorRec.error_code := 'INVALID_RTN';
1381: p_docErrorRec.error_message := x_error_mesg;
1382: x_error_code := g_ERROR;
1383: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1384: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1385: END IF;
1386:
1387: ELSE
1388: -- failed, not a 9 digit numeric value

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

1391: p_docErrorRec.error_code := 'INVALID_RTN';
1392: p_docErrorRec.error_message := x_error_mesg;
1393: x_error_code := g_ERROR;
1394: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1395: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1396: END IF;
1397:
1398:
1399: EXCEPTION

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

1399: EXCEPTION
1400: WHEN OTHERS THEN
1401: x_error_code := g_FAILURE;
1402: x_error_mesg := SQLERRM;
1403: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1404: p_docErrorRec.transaction_error_id := null;
1405: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1406: p_docErrorRec.error_message := x_error_mesg;
1407: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

1453: BEGIN
1454: x_error_code := g_SUCCESS;
1455:
1456: l_message := 'Validating Pay Alone Option, Parameters: p_format_name = ' || p_format_name || ', p_invoice_id = ' || p_invoice_id ;
1457: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1458:
1459: OPEN get_pay_alone_flag_csr(p_invoice_id, p_payment_id);
1460: 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
1461: CLOSE get_pay_alone_flag_csr;

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

1466: p_docErrorRec.error_code := 'INVALID_PAY_ALONE_FLAG';
1467: p_docErrorRec.error_message := x_error_mesg;
1468: x_error_code := g_ERROR;
1469: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1470: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1471: END IF;
1472:
1473: EXCEPTION
1474: WHEN OTHERS THEN

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

1473: EXCEPTION
1474: WHEN OTHERS THEN
1475: x_error_code := g_FAILURE;
1476: x_error_mesg := SQLERRM;
1477: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1478: p_docErrorRec.transaction_error_id := null;
1479: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1480: p_docErrorRec.error_message := x_error_mesg;
1481: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

1514: BEGIN
1515: x_error_code := g_SUCCESS;
1516:
1517: l_message := 'Validating Depositor Account Number, Parameters: p_format_name = ' || p_format_name || ', p_dep_account_no = ' || p_dep_account_no ;
1518: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1519:
1520: IF p_dep_account_no IS NULL THEN --Account Number Should Not Be Empty
1521: x_error_mesg := 'Bank account number missing for vendor';
1522: x_error_mesg := x_error_mesg || '. Please correct the error, terminate this request and submit a new request';

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

1524: p_docErrorRec.error_code := 'DEPOSITER_ACCOUNT_NO_MISSING';
1525: p_docErrorRec.error_message := x_error_mesg;
1526: x_error_code := g_ERROR;
1527: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1528: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1529: ELSE
1530: l_string := rtrim(p_dep_account_no);
1531: l_length := length(l_string);
1532: l_char_string := 'ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890-';

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

1543: p_docErrorRec.error_code := 'INVALID_DEPOSITER_ACCOUNT_NO';
1544: p_docErrorRec.error_message := x_error_mesg;
1545: x_error_code := g_ERROR;
1546: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1547: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1548: END IF;
1549:
1550: END IF;
1551:

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

1552: EXCEPTION
1553: WHEN OTHERS THEN
1554: x_error_code := g_FAILURE;
1555: x_error_mesg := SQLERRM;
1556: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1557: p_docErrorRec.transaction_error_id := null;
1558: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1559: p_docErrorRec.error_message := x_error_mesg;
1560: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

1596:
1597: x_error_code := g_SUCCESS;
1598:
1599: l_message := 'Validating Account Type, Parameters: p_format_name = ' || p_format_name || ', p_bank_account_type = ' || p_bank_account_type ;
1600: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1601:
1602: SELECT calling_app_doc_ref_number
1603: INTO l_invoice_num FROM IBY_DOCS_PAYABLE_ALL
1604: WHERE calling_app_doc_unique_ref2 = p_invoice_id

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

1614: p_docErrorRec.error_code := 'INVALID_BANK_ACCOUNT_TYPE';
1615: p_docErrorRec.error_message := x_error_mesg;
1616: x_error_code := g_ERROR;
1617: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1618: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1619: END IF;
1620:
1621:
1622: EXCEPTION

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

1622: EXCEPTION
1623: WHEN OTHERS THEN
1624: x_error_code := g_FAILURE;
1625: x_error_mesg := SQLERRM;
1626: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1627: p_docErrorRec.transaction_error_id := null;
1628: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1629: p_docErrorRec.error_message := x_error_mesg;
1630: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

1666: BEGIN
1667: x_error_code := g_SUCCESS;
1668:
1669: l_message := 'Validating RFC Id, Parameters: p_format_name = ' || p_format_name || ', p_payment_id = ' || p_payment_id;
1670: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1671:
1672: select hca.class_code,
1673: ipa.internal_bank_account_id,
1674: cba.bank_branch_id,

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

1694: p_docErrorRec.error_code := 'INVALID_RFC_ID';
1695: p_docErrorRec.error_message := x_error_mesg;
1696: x_error_code := g_ERROR;
1697: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1698: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1699:
1700: END IF;
1701:
1702:

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

1703: EXCEPTION
1704: WHEN OTHERS THEN
1705: x_error_code := g_FAILURE;
1706: x_error_mesg := SQLERRM;
1707: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1708: p_docErrorRec.transaction_error_id := null;
1709: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1710: p_docErrorRec.error_message := x_error_mesg;
1711: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

1752: BEGIN
1753: x_error_code := g_SUCCESS;
1754:
1755: l_message := 'Validating Reason Code Id, Parameters: p_format_name = ' || p_format_name || ', p_reason_code = ' || p_reason_code ;
1756: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1757:
1758:
1759: IF (p_reason_code IS NULL) OR p_reason_code NOT IN('US_FV_A','US_FV_B','US_FV_C','US_FV_D',
1760: 'US_FV_I','US_FV_M','US_FV_O','US_FV_R',

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

1765: p_docErrorRec.error_code := 'INVALID_PAYMENT_REASON';
1766: p_docErrorRec.error_message := x_error_mesg;
1767: x_error_code := g_ERROR;
1768: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1769: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1770:
1771: END IF;
1772:
1773: EXCEPTION

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

1773: EXCEPTION
1774: WHEN OTHERS THEN
1775: x_error_code := g_FAILURE;
1776: x_error_mesg := SQLERRM;
1777: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1778: p_docErrorRec.transaction_error_id := null;
1779: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1780: p_docErrorRec.error_message := x_error_mesg;
1781: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

1812: BEGIN
1813: x_error_code := g_SUCCESS;
1814:
1815: l_message := 'Validating External Bank Account Id, Parameters: p_format_name = ' || p_format_name || ', p_external_bank_account_id = ' || p_external_bank_account_id;
1816: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1817:
1818: IF p_external_bank_account_id IS NULL THEN -- p_external_bank_account_id should not be Empty
1819:
1820: x_error_mesg := 'This is an electronic format and requires a remit-to bank account to be entered on the invoice.';

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

1823: p_docErrorRec.error_code := 'INVALID_EXTERNAL_BANK_ACCOUNT';
1824: p_docErrorRec.error_message := x_error_mesg;
1825: x_error_code := g_ERROR;
1826: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1827: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1828:
1829: END IF;
1830:
1831: EXCEPTION

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

1831: EXCEPTION
1832: WHEN OTHERS THEN
1833: x_error_code := g_FAILURE;
1834: x_error_mesg := SQLERRM;
1835: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1836: p_docErrorRec.transaction_error_id := null;
1837: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1838: p_docErrorRec.error_message := x_error_mesg;
1839: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

1860: x_error_code := g_SUCCESS;
1861:
1862: IF (p_format_name IN ('FVBLCCDP','FVBLPPDP')) THEN
1863: l_message := 'Validating Federal Id Number Id, Parameters: p_format_name = ' || p_format_name;
1864: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1865:
1866: select ipia.org_id, haou.name
1867: into l_org_id, l_org_name
1868: from iby_pay_instructions_all ipia,

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: END IF;
1891: END IF;
1892: EXCEPTION

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

1897: p_docErrorRec.error_code := 'INVALID_FEDERAL_ID_NUMBER';
1898: p_docErrorRec.error_message := x_error_mesg;
1899: x_error_code := g_ERROR;
1900: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1901: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1902:
1903: WHEN OTHERS THEN
1904: x_error_code := g_FAILURE;
1905: x_error_mesg := SQLERRM;

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

1902:
1903: WHEN OTHERS THEN
1904: x_error_code := g_FAILURE;
1905: x_error_mesg := SQLERRM;
1906: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1907: p_docErrorRec.transaction_error_id := null;
1908: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1909: p_docErrorRec.error_message := x_error_mesg;
1910: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

1929: BEGIN
1930: x_error_code := g_SUCCESS;
1931:
1932: l_message := 'Validating Agency Id Abbreviation, Parameters: p_format_name = ' || p_format_name || ', p_instruction_id = ' || p_instruction_id ;
1933: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1934:
1935:
1936: IF p_format_name IN ('FVBLNCR','FVBLSLTR','FVBLCCDP','FVBLPPDP','FVTICTX') THEN
1937:

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

1942: p_docErrorRec.error_code := 'AGENCY_ABBREV_UNDEFINED';
1943: p_docErrorRec.error_message := x_error_mesg;
1944: x_error_code := g_ERROR;
1945: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1946: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1947:
1948: END IF;
1949:
1950: END IF;

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

1953: EXCEPTION
1954: WHEN OTHERS THEN
1955: x_error_code := g_FAILURE;
1956: x_error_mesg := SQLERRM;
1957: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1958: p_docErrorRec.transaction_error_id := null;
1959: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1960: p_docErrorRec.error_message := x_error_mesg;
1961: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

1986:
1987: BEGIN
1988:
1989: IF (p_level >= g_current_level) THEN
1990: fnd_log.string (p_level, p_module, p_message);
1991: END IF;
1992:
1993: -- log messages only if concurrent program
1994: IF (FND_GLOBAL.conc_request_id <> -1) THEN

Line 2007: g_current_level := fnd_log.g_current_runtime_level;

2003: g_module_name := 'fv.plsql.IBY_PAYMENT_FORMAT_VAL_PVT.';
2004: g_ERROR := -1;
2005: g_FAILURE := -2;
2006: g_SUCCESS := 0;
2007: g_current_level := fnd_log.g_current_runtime_level;
2008:
2009:
2010: END IBY_PAYMENT_FORMAT_VAL_PVT;