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_PUB dependencies on IBY_PAYMENT_FORMAT_VAL_PVT

Line 120: IBY_PAYMENT_FORMAT_VAL_PVT.FEDERAL_ID_NUMBER(

116: -- delete from FV_TP_TS_AMT_DATA to refresh data
117: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
118:
119: -- Do validation of the Federal Identification Number
120: IBY_PAYMENT_FORMAT_VAL_PVT.FEDERAL_ID_NUMBER(
121: l_format_name,
122: p_instruction_id,
123: l_docErrorTab,
124: l_docErrorRec,

Line 136: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ID_ABBREVIATION(

132: RETURN;
133: END IF;
134:
135: -- Do validation of Agency Id Abbreviation
136: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ID_ABBREVIATION(
137: l_format_name,
138: p_instruction_id,
139: l_docErrorTab,
140: l_docErrorRec,

Line 151: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

147: x_result:=1;
148: RETURN;
149: END IF;
150:
151: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
152: -- Moved this to instruction level (Bug 5526640)
153: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
154: p_instruction_id,
155: l_docErrorTab,

Line 153: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

149: END IF;
150:
151: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
152: -- Moved this to instruction level (Bug 5526640)
153: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
154: p_instruction_id,
155: l_docErrorTab,
156: l_docErrorRec,
157: l_valid,

Line 173: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

169:
170: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
171: EXIT WHEN iby_pmt_csr%NOTFOUND;
172:
173: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
174: l_iby_pmt_rec.payment_id,
175: l_docErrorTab,
176: l_docErrorRec,
177: l_valid,

Line 196: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

192: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
193: EXIT WHEN iby_docs_csr%NOTFOUND;
194:
195: -- validate internal bank account parameters
196: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
197: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
198: l_iby_pmt_rec.int_bank_account_name,
199: l_docErrorTab,
200: l_docErrorRec,

Line 213: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,

209:
210:
211: -- validate external bank account parameters
212: -- validate external bank account id
213: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,
214: l_iby_pmt_rec.external_bank_account_id,
215: l_docErrorTab,
216: l_docErrorRec,
217: l_valid,

Line 227: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,

223: RETURN;
224: END IF;
225:
226:
227: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,
228: l_iby_pmt_rec.ext_bank_account_type,
229: l_iby_pmt_rec.ext_bank_account_name,
230: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
231: l_iby_pmt_rec.payment_id,

Line 244: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,

240: RETURN;
241: END IF;
242:
243:
244: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,
245: l_iby_pmt_rec.ext_bank_account_number,
246: l_docErrorTab,
247: l_docErrorRec,
248: l_valid,

Line 258: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,

254: RETURN;
255: END IF;
256:
257:
258: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,
259: l_iby_pmt_rec.ext_branch_number,
260: l_docErrorTab,
261: l_docErrorRec,
262: l_valid,

Line 273: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,

269: END IF;
270:
271:
272:
273: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,
274: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
275: l_iby_pmt_rec.payment_id,
276: l_docErrorTab,
277: l_docErrorRec,

Line 288: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

284: RETURN;
285: END IF;
286:
287:
288: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
289: p_instruction_id,
290: l_iby_pmt_rec.payment_id,
291: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
292: l_docErrorTab,

Line 306: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

302: END IF;
303:
304:
305:
306: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
307: l_iby_pmt_rec.payee_le_registration_num,
308: l_iby_pmt_rec.payee_party_id,
309: l_docErrorTab,
310: l_docErrorRec,

Line 330: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,

326:
327: END LOOP;-- End Of Payments Cursor Loop
328: CLOSE iby_pmt_csr; -- Closing Payments Cursor
329:
330: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,
331: p_instruction_id,
332: l_docErrorTab,
333: l_docErrorRec,
334: l_valid,

Line 344: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

340: x_result:=1;
341: RETURN;
342: END IF;
343:
344: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
345: p_instruction_id,
346: l_docErrorTab,
347: l_docErrorRec,
348: l_valid,

Line 372: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);

368: l_docErrorRec.transaction_error_id := null;
369: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
370: l_docErrorRec.error_message := SQLERRM;
371: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
372: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
373: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
374:
375: END FVBLCCDP; -- End of Procedure FVBLCCDP
376:

Line 468: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ID_ABBREVIATION(

464:
465: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_Id
466:
467: -- Do validation of Agency Id Abbreviation
468: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ID_ABBREVIATION(
469: l_format_name,
470: p_instruction_id,
471: l_docErrorTab,
472: l_docErrorRec,

Line 484: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

480: RETURN;
481: END IF;
482:
483:
484: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
485: -- Moved this to instruction level (Bug 5526640)
486: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
487: p_instruction_id,
488: l_docErrorTab,

Line 486: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

482:
483:
484: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
485: -- Moved this to instruction level (Bug 5526640)
486: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
487: p_instruction_id,
488: l_docErrorTab,
489: l_docErrorRec,
490: l_valid,

Line 506: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

502: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
503: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
504: EXIT WHEN iby_pmt_csr%NOTFOUND;
505:
506: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
507: l_iby_pmt_rec.payment_id,
508: l_docErrorTab,
509: l_docErrorRec,
510: l_valid,

Line 520: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT at Payment Level

516: x_result:=1;
517: RETURN;
518: END IF;
519:
520: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT at Payment Level
521: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT(l_format_name,
522: l_iby_pmt_rec.payment_instruction_id,
523: l_iby_pmt_rec.payment_amount,
524: l_docErrorTab,

Line 521: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT(l_format_name,

517: RETURN;
518: END IF;
519:
520: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT at Payment Level
521: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT(l_format_name,
522: l_iby_pmt_rec.payment_instruction_id,
523: l_iby_pmt_rec.payment_amount,
524: l_docErrorTab,
525: l_docErrorRec,

Line 538: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,

534: END IF;
535:
536:
537:
538: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
539: l_org_id,
540: l_docErrorTab,
541: l_docErrorRec,
542: l_valid,

Line 552: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS(l_format_name,

548: RETURN;
549: END IF;
550:
551:
552: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS(l_format_name,
553: l_iby_pmt_rec.payment_id,
554: l_docErrorTab,
555: l_docErrorRec,
556: l_valid,

Line 574: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

570: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
571: EXIT WHEN iby_docs_csr%NOTFOUND;
572:
573: -- validate internal bank account parameters
574: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
575: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
576: l_iby_pmt_rec.int_bank_account_name,
577: l_docErrorTab,
578: l_docErrorRec,

Line 595: -- Do Validation by IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT at Instruction Level

591: AND payment_id = l_iby_pmt_rec.payment_id
592: AND calling_app_id=200
593: AND UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
594:
595: -- Do Validation by IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT at Instruction Level
596: IF(l_invoice_type <> 'INTEREST') THEN
597: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT(l_format_name,
598: l_iby_pmt_rec.payment_id,
599: to_number(l_iby_docs_rec.calling_app_doc_unique_ref2),

Line 597: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT(l_format_name,

593: AND UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
594:
595: -- Do Validation by IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT at Instruction Level
596: IF(l_invoice_type <> 'INTEREST') THEN
597: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT(l_format_name,
598: l_iby_pmt_rec.payment_id,
599: to_number(l_iby_docs_rec.calling_app_doc_unique_ref2),
600: l_docErrorTab,
601: l_docErrorRec,

Line 613: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

609: RETURN;
610: END IF;
611:
612:
613: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
614: p_instruction_id,
615: l_iby_pmt_rec.payment_id,
616: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
617: l_docErrorTab,

Line 630: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

626: END IF;
627:
628:
629:
630: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
631: l_iby_pmt_rec.payee_le_registration_num,
632: l_iby_pmt_rec.payee_party_id,
633: l_docErrorTab,
634: l_docErrorRec,

Line 652: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,

648:
649: END LOOP;-- End Of Payments Cursor Loop
650: CLOSE iby_pmt_csr; -- Closing Payments Cursor
651:
652: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,
653: p_instruction_id,
654: l_docErrorTab,
655: l_docErrorRec,
656: l_valid,

Line 666: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

662: x_result:=1;
663: RETURN;
664: END IF;
665:
666: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
667: p_instruction_id,
668: l_docErrorTab,
669: l_docErrorRec,
670: l_valid,

Line 693: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);

689: l_docErrorRec.transaction_error_id := null;
690: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
691: l_docErrorRec.error_message := SQLERRM;
692: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
693: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
694: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
695:
696:
697:

Line 804: IBY_PAYMENT_FORMAT_VAL_PVT.FEDERAL_ID_NUMBER(

800: -- delete from FV_TP_TS_AMT_DATA to refresh data
801: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
802:
803: -- Do validation of the Federal Identification Number
804: IBY_PAYMENT_FORMAT_VAL_PVT.FEDERAL_ID_NUMBER(
805: l_format_name,
806: p_instruction_id,
807: l_docErrorTab,
808: l_docErrorRec,

Line 820: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ID_ABBREVIATION(

816: RETURN;
817: END IF;
818:
819: -- Do validation of Agency Id Abbreviation
820: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ID_ABBREVIATION(
821: l_format_name,
822: p_instruction_id,
823: l_docErrorTab,
824: l_docErrorRec,

Line 836: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

832: RETURN;
833: END IF;
834:
835:
836: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
837: -- Moved this to instruction level (Bug 5526640)
838: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
839: p_instruction_id,
840: l_docErrorTab,

Line 838: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

834:
835:
836: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
837: -- Moved this to instruction level (Bug 5526640)
838: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
839: p_instruction_id,
840: l_docErrorTab,
841: l_docErrorRec,
842: l_valid,

Line 859: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

855: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
856: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
857: EXIT WHEN iby_pmt_csr%NOTFOUND;
858:
859: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
860: l_iby_pmt_rec.payment_id,
861: l_docErrorTab,
862: l_docErrorRec,
863: l_valid,

Line 873: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level

869: x_result:=1;
870: RETURN;
871: END IF;
872:
873: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
874: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
875: l_iby_pmt_rec.payment_instruction_id,
876: l_iby_pmt_rec.payment_amount,
877: l_docErrorTab,

Line 874: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,

870: RETURN;
871: END IF;
872:
873: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
874: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
875: l_iby_pmt_rec.payment_instruction_id,
876: l_iby_pmt_rec.payment_amount,
877: l_docErrorTab,
878: l_docErrorRec,

Line 896: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

892: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
893: EXIT WHEN iby_docs_csr%NOTFOUND;
894:
895: -- validate internal bank account parameters
896: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
897: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
898: l_iby_pmt_rec.int_bank_account_name,
899: l_docErrorTab,
900: l_docErrorRec,

Line 913: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,

909: END IF;
910:
911: -- validate external bank account parameters
912: -- validate external bank account id
913: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,
914: l_iby_pmt_rec.external_bank_account_id,
915: l_docErrorTab,
916: l_docErrorRec,
917: l_valid,

Line 927: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,

923: RETURN;
924: END IF;
925:
926:
927: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,
928: l_iby_pmt_rec.ext_bank_account_type,
929: l_iby_pmt_rec.ext_bank_account_name,
930: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
931: l_iby_pmt_rec.payment_id,

Line 944: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,

940: RETURN;
941: END IF;
942:
943:
944: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,
945: l_iby_pmt_rec.ext_bank_account_number,
946: l_docErrorTab,
947: l_docErrorRec,
948: l_valid,

Line 958: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,

954: RETURN;
955: END IF;
956:
957:
958: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,
959: l_iby_pmt_rec.ext_branch_number,
960: l_docErrorTab,
961: l_docErrorRec,
962: l_valid,

Line 974: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,

970:
971:
972:
973:
974: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,
975: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
976: l_iby_pmt_rec.payment_id,
977: l_docErrorTab,
978: l_docErrorRec,

Line 989: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

985: RETURN;
986: END IF;
987:
988:
989: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
990: p_instruction_id,
991: l_iby_pmt_rec.payment_id,
992: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
993: l_docErrorTab,

Line 1005: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

1001: RETURN;
1002: END IF;
1003:
1004:
1005: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
1006: l_iby_pmt_rec.payee_le_registration_num,
1007: l_iby_pmt_rec.payee_party_id,
1008: l_docErrorTab,
1009: l_docErrorRec,

Line 1026: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,

1022:
1023: END LOOP;-- End Of Payments Cursor Loop
1024: CLOSE iby_pmt_csr; -- Closing Payments Cursor
1025:
1026: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,
1027: p_instruction_id,
1028: l_docErrorTab,
1029: l_docErrorRec,
1030: l_valid,

Line 1040: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

1036: x_result:=1;
1037: RETURN;
1038: END IF;
1039:
1040: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
1041: p_instruction_id,
1042: l_docErrorTab,
1043: l_docErrorRec,
1044: l_valid,

Line 1054: IBY_PAYMENT_FORMAT_VAL_PVT.MANDATORY_PPD_PPDP_REASON_CODE(l_format_name,

1050: x_result:=1;
1051: RETURN;
1052: END IF;
1053:
1054: IBY_PAYMENT_FORMAT_VAL_PVT.MANDATORY_PPD_PPDP_REASON_CODE(l_format_name,
1055: l_pay_instr_rec.payment_reason_code,
1056: l_docErrorTab,
1057: l_docErrorRec,
1058: l_valid,

Line 1080: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);

1076: l_docErrorRec.transaction_error_id := null;
1077: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1078: l_docErrorRec.error_message := SQLERRM;
1079: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1080: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
1081: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1082:
1083:
1084: END FVBLPPDP;-- End of Procedure FVBLPPDP

Line 1175: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ID_ABBREVIATION(

1171:
1172: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
1173:
1174: -- Do validation of Agency Id Abbreviation
1175: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ID_ABBREVIATION(
1176: l_format_name,
1177: p_instruction_id,
1178: l_docErrorTab,
1179: l_docErrorRec,

Line 1190: -- Do Validation by IBY_PAYMENT_FORMAT_VAL_PVT.PAY_SALARY_TRAVEL at Instruction Level

1186: x_result:=1;
1187: RETURN;
1188: END IF;
1189:
1190: -- Do Validation by IBY_PAYMENT_FORMAT_VAL_PVT.PAY_SALARY_TRAVEL at Instruction Level
1191: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_SALARY_TRAVEL(l_format_name,
1192: l_pay_instr_rec.payment_reason_code,
1193: l_docErrorTab,
1194: l_docErrorRec,

Line 1191: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_SALARY_TRAVEL(l_format_name,

1187: RETURN;
1188: END IF;
1189:
1190: -- Do Validation by IBY_PAYMENT_FORMAT_VAL_PVT.PAY_SALARY_TRAVEL at Instruction Level
1191: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_SALARY_TRAVEL(l_format_name,
1192: l_pay_instr_rec.payment_reason_code,
1193: l_docErrorTab,
1194: l_docErrorRec,
1195: l_valid,

Line 1205: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

1201: RETURN;
1202: END IF;
1203:
1204:
1205: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
1206: -- Moved this to instruction level (Bug 5526640)
1207: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
1208: p_instruction_id,
1209: l_docErrorTab,

Line 1207: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

1203:
1204:
1205: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
1206: -- Moved this to instruction level (Bug 5526640)
1207: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
1208: p_instruction_id,
1209: l_docErrorTab,
1210: l_docErrorRec,
1211: l_valid,

Line 1226: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

1222: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
1223: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
1224: EXIT WHEN iby_pmt_csr%NOTFOUND;
1225:
1226: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
1227: l_iby_pmt_rec.payment_id,
1228: l_docErrorTab,
1229: l_docErrorRec,
1230: l_valid,

Line 1240: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,

1236: x_result:=1;
1237: RETURN;
1238: END IF;
1239:
1240: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
1241: l_org_id,
1242: l_docErrorTab,
1243: l_docErrorRec,
1244: l_valid,

Line 1254: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level

1250: x_result:=1;
1251: RETURN;
1252: END IF;
1253:
1254: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
1255: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
1256: l_iby_pmt_rec.payment_instruction_id,
1257: l_iby_pmt_rec.payment_amount,
1258: l_docErrorTab,

Line 1255: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,

1251: RETURN;
1252: END IF;
1253:
1254: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
1255: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
1256: l_iby_pmt_rec.payment_instruction_id,
1257: l_iby_pmt_rec.payment_amount,
1258: l_docErrorTab,
1259: l_docErrorRec,

Line 1278: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

1274: EXIT WHEN iby_docs_csr%NOTFOUND;
1275:
1276:
1277: -- validate internal bank account parameters
1278: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
1279: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
1280: l_iby_pmt_rec.int_bank_account_name,
1281: l_docErrorTab,
1282: l_docErrorRec,

Line 1293: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

1289: RETURN;
1290: END IF;
1291:
1292:
1293: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
1294: p_instruction_id,
1295: l_iby_pmt_rec.payment_id,
1296: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
1297: l_docErrorTab,

Line 1309: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

1305: RETURN;
1306: END IF;
1307:
1308:
1309: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
1310: l_iby_pmt_rec.payee_le_registration_num,
1311: l_iby_pmt_rec.payee_party_id,
1312: l_docErrorTab,
1313: l_docErrorRec,

Line 1331: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,

1327:
1328: END LOOP;-- End Of Payments Cursor Loop
1329: CLOSE iby_pmt_csr; -- Closing Payments Cursor
1330:
1331: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,
1332: p_instruction_id,
1333: l_docErrorTab,
1334: l_docErrorRec,
1335: l_valid,

Line 1345: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

1341: x_result:=1;
1342: RETURN;
1343: END IF;
1344:
1345: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
1346: p_instruction_id,
1347: l_docErrorTab,
1348: l_docErrorRec,
1349: l_valid,

Line 1373: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);

1369: l_docErrorRec.transaction_error_id := null;
1370: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1371: l_docErrorRec.error_message := SQLERRM;
1372: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1373: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
1374: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1375:
1376:
1377: END FVBLSLTR;-- End of Procedure FVBLSLTR

Line 1487: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ID_ABBREVIATION(

1483:
1484: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
1485:
1486: -- Do validation of Agency Id Abbreviation
1487: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ID_ABBREVIATION(
1488: l_format_name,
1489: p_instruction_id,
1490: l_docErrorTab,
1491: l_docErrorRec,

Line 1503: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

1499: RETURN;
1500: END IF;
1501:
1502:
1503: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
1504: -- Moved this to instruction level (Bug 5526640)
1505: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
1506: p_instruction_id,
1507: l_docErrorTab,

Line 1505: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

1501:
1502:
1503: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
1504: -- Moved this to instruction level (Bug 5526640)
1505: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
1506: p_instruction_id,
1507: l_docErrorTab,
1508: l_docErrorRec,
1509: l_valid,

Line 1524: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

1520: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
1521: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
1522: EXIT WHEN iby_pmt_csr%NOTFOUND;
1523:
1524: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
1525: l_iby_pmt_rec.payment_id,
1526: l_docErrorTab,
1527: l_docErrorRec,
1528: l_valid,

Line 1538: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT at Payment Level

1534: x_result:=1;
1535: RETURN;
1536: END IF;
1537:
1538: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT at Payment Level
1539: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT(l_format_name,
1540: l_iby_pmt_rec.payment_instruction_id,
1541: l_iby_pmt_rec.payment_amount,
1542: l_docErrorTab,

Line 1539: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT(l_format_name,

1535: RETURN;
1536: END IF;
1537:
1538: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT at Payment Level
1539: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT(l_format_name,
1540: l_iby_pmt_rec.payment_instruction_id,
1541: l_iby_pmt_rec.payment_amount,
1542: l_docErrorTab,
1543: l_docErrorRec,

Line 1554: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS

1550: RETURN;
1551: END IF;
1552:
1553:
1554: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
1555: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
1556: l_org_id,
1557: l_docErrorTab,
1558: l_docErrorRec,

Line 1555: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,

1551: END IF;
1552:
1553:
1554: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
1555: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
1556: l_org_id,
1557: l_docErrorTab,
1558: l_docErrorRec,
1559: l_valid,

Line 1576: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

1572: EXIT WHEN iby_docs_csr%NOTFOUND;
1573:
1574:
1575: -- validate internal bank account parameters
1576: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
1577: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
1578: l_iby_pmt_rec.int_bank_account_name,
1579: l_docErrorTab,
1580: l_docErrorRec,

Line 1592: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,

1588: END IF;
1589:
1590: -- validate external bank account parameters
1591: -- validate external bank account id
1592: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,
1593: l_iby_pmt_rec.external_bank_account_id,
1594: l_docErrorTab,
1595: l_docErrorRec,
1596: l_valid,

Line 1605: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,

1601: x_result:=1;
1602: RETURN;
1603: END IF;
1604:
1605: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,
1606: l_iby_pmt_rec.ext_bank_account_type,
1607: l_iby_pmt_rec.ext_bank_account_name,
1608: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
1609: l_iby_pmt_rec.payment_id,

Line 1622: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,

1618: RETURN;
1619: END IF;
1620:
1621:
1622: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,
1623: l_iby_pmt_rec.ext_bank_account_number,
1624: l_docErrorTab,
1625: l_docErrorRec,
1626: l_valid,

Line 1636: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,

1632: RETURN;
1633: END IF;
1634:
1635:
1636: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,
1637: l_iby_pmt_rec.ext_branch_number,
1638: l_docErrorTab,
1639: l_docErrorRec,
1640: l_valid,

Line 1651: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,

1647: END IF;
1648:
1649: -- bug 8577262
1650: /*
1651: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,
1652: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
1653: l_iby_pmt_rec.payment_id,
1654: l_docErrorTab,
1655: l_docErrorRec,

Line 1666: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

1662: RETURN;
1663: END IF;
1664: */
1665:
1666: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
1667: p_instruction_id,
1668: l_iby_pmt_rec.payment_id,
1669: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
1670: l_docErrorTab,

Line 1682: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

1678: RETURN;
1679: END IF;
1680:
1681:
1682: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
1683: l_iby_pmt_rec.payee_le_registration_num,
1684: l_iby_pmt_rec.payee_party_id,
1685: l_docErrorTab,
1686: l_docErrorRec,

Line 1705: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

1701:
1702: END LOOP;-- End Of Payments Cursor Loop
1703: CLOSE iby_pmt_csr; -- Closing Payments Cursor
1704:
1705: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
1706: p_instruction_id,
1707: l_docErrorTab,
1708: l_docErrorRec,
1709: l_valid,

Line 1732: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);

1728: l_docErrorRec.transaction_error_id := null;
1729: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1730: l_docErrorRec.error_message := SQLERRM;
1731: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1732: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
1733: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1734:
1735:
1736: END FVTICTX;-- End of Procedure FVTICTX

Line 1845: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

1841: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
1842:
1843: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
1844:
1845: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
1846: -- Moved this to instruction level (Bug 5526640)
1847: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
1848: p_instruction_id,
1849: l_docErrorTab,

Line 1847: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

1843: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
1844:
1845: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
1846: -- Moved this to instruction level (Bug 5526640)
1847: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
1848: p_instruction_id,
1849: l_docErrorTab,
1850: l_docErrorRec,
1851: l_valid,

Line 1868: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

1864: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
1865: EXIT WHEN iby_pmt_csr%NOTFOUND;
1866:
1867:
1868: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
1869: l_iby_pmt_rec.payment_id,
1870: l_docErrorTab,
1871: l_docErrorRec,
1872: l_valid,

Line 1882: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS

1878: x_result:=1;
1879: RETURN;
1880: END IF;
1881:
1882: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
1883: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
1884: l_org_id,
1885: l_docErrorTab,
1886: l_docErrorRec,

Line 1883: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,

1879: RETURN;
1880: END IF;
1881:
1882: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
1883: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
1884: l_org_id,
1885: l_docErrorTab,
1886: l_docErrorRec,
1887: l_valid,

Line 1904: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

1900: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
1901: EXIT WHEN iby_docs_csr%NOTFOUND;
1902:
1903: -- validate internal bank account parameters
1904: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
1905: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
1906: l_iby_pmt_rec.int_bank_account_name,
1907: l_docErrorTab,
1908: l_docErrorRec,

Line 1920: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,

1916: END IF;
1917:
1918: -- validate external bank account parameters
1919: -- validate external bank account id
1920: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,
1921: l_iby_pmt_rec.external_bank_account_id,
1922: l_docErrorTab,
1923: l_docErrorRec,
1924: l_valid,

Line 1934: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,

1930: RETURN;
1931: END IF;
1932:
1933:
1934: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,
1935: l_iby_pmt_rec.ext_bank_account_type,
1936: l_iby_pmt_rec.ext_bank_account_name,
1937: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
1938: l_iby_pmt_rec.payment_id,

Line 1951: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,

1947: RETURN;
1948: END IF;
1949:
1950:
1951: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,
1952: l_iby_pmt_rec.ext_bank_account_number,
1953: l_docErrorTab,
1954: l_docErrorRec,
1955: l_valid,

Line 1965: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,

1961: x_result:=1;
1962: RETURN;
1963: END IF;
1964:
1965: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,
1966: l_iby_pmt_rec.ext_branch_number,
1967: l_docErrorTab,
1968: l_docErrorRec,
1969: l_valid,

Line 1980: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,

1976: RETURN;
1977: END IF;
1978:
1979:
1980: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,
1981: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
1982: l_iby_pmt_rec.payment_id,
1983: l_docErrorTab,
1984: l_docErrorRec,

Line 1995: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

1991: RETURN;
1992: END IF;
1993:
1994:
1995: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
1996: p_instruction_id,
1997: l_iby_pmt_rec.payment_id,
1998: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
1999: l_docErrorTab,

Line 2012: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

2008: END IF;
2009:
2010:
2011:
2012: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
2013: l_iby_pmt_rec.payee_le_registration_num,
2014: l_iby_pmt_rec.payee_party_id,
2015: l_docErrorTab,
2016: l_docErrorRec,

Line 2035: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

2031:
2032: END LOOP;-- End Of Payments Cursor Loop
2033: CLOSE iby_pmt_csr; -- Closing Payments Cursor
2034:
2035: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
2036: p_instruction_id,
2037: l_docErrorTab,
2038: l_docErrorRec,
2039: l_valid,

Line 2063: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);

2059: l_docErrorRec.transaction_error_id := null;
2060: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
2061: l_docErrorRec.error_message := SQLERRM;
2062: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2063: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
2064: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2065:
2066:
2067: END FVTPCCD;-- End of Procedure FVTPCCD

Line 2176: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

2172:
2173: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
2174:
2175:
2176: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
2177: -- Moved this to instruction level (Bug 5526640)
2178: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
2179: p_instruction_id,
2180: l_docErrorTab,

Line 2178: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

2174:
2175:
2176: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
2177: -- Moved this to instruction level (Bug 5526640)
2178: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
2179: p_instruction_id,
2180: l_docErrorTab,
2181: l_docErrorRec,
2182: l_valid,

Line 2198: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

2194: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
2195: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
2196: EXIT WHEN iby_pmt_csr%NOTFOUND;
2197:
2198: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
2199: l_iby_pmt_rec.payment_id,
2200: l_docErrorTab,
2201: l_docErrorRec,
2202: l_valid,

Line 2212: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS

2208: x_result:=1;
2209: RETURN;
2210: END IF;
2211:
2212: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
2213: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
2214: l_org_id,
2215: l_docErrorTab,
2216: l_docErrorRec,

Line 2213: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,

2209: RETURN;
2210: END IF;
2211:
2212: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
2213: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
2214: l_org_id,
2215: l_docErrorTab,
2216: l_docErrorRec,
2217: l_valid,

Line 2234: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

2230: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
2231: EXIT WHEN iby_docs_csr%NOTFOUND;
2232:
2233: -- validate internal bank account parameters
2234: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
2235: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
2236: l_iby_pmt_rec.int_bank_account_name,
2237: l_docErrorTab,
2238: l_docErrorRec,

Line 2250: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,

2246: END IF;
2247:
2248: -- validate external bank account parameters
2249: -- validate external bank account id
2250: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,
2251: l_iby_pmt_rec.external_bank_account_id,
2252: l_docErrorTab,
2253: l_docErrorRec,
2254: l_valid,

Line 2264: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,

2260: RETURN;
2261: END IF;
2262:
2263:
2264: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,
2265: l_iby_pmt_rec.ext_bank_account_type,
2266: l_iby_pmt_rec.ext_bank_account_name,
2267: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
2268: l_iby_pmt_rec.payment_id,

Line 2280: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,

2276: x_result:=1;
2277: RETURN;
2278: END IF;
2279:
2280: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,
2281: l_iby_pmt_rec.ext_bank_account_number,
2282: l_docErrorTab,
2283: l_docErrorRec,
2284: l_valid,

Line 2294: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,

2290: RETURN;
2291: END IF;
2292:
2293:
2294: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,
2295: l_iby_pmt_rec.ext_branch_number,
2296: l_docErrorTab,
2297: l_docErrorRec,
2298: l_valid,

Line 2309: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,

2305: RETURN;
2306: END IF;
2307:
2308:
2309: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,
2310: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
2311: l_iby_pmt_rec.payment_id,
2312: l_docErrorTab,
2313: l_docErrorRec,

Line 2324: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

2320: RETURN;
2321: END IF;
2322:
2323:
2324: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
2325: p_instruction_id,
2326: l_iby_pmt_rec.payment_id,
2327: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
2328: l_docErrorTab,

Line 2341: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

2337: END IF;
2338:
2339:
2340:
2341: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
2342: l_iby_pmt_rec.payee_le_registration_num,
2343: l_iby_pmt_rec.payee_party_id,
2344: l_docErrorTab,
2345: l_docErrorRec,

Line 2364: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

2360:
2361: END LOOP;-- End Of Payments Cursor Loop
2362: CLOSE iby_pmt_csr; -- Closing Payments Cursor
2363:
2364: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
2365: p_instruction_id,
2366: l_docErrorTab,
2367: l_docErrorRec,
2368: l_valid,

Line 2391: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);

2387: l_docErrorRec.transaction_error_id := null;
2388: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
2389: l_docErrorRec.error_message := SQLERRM;
2390: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2391: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
2392: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2393:
2394:
2395: END FVTIACHP;-- End of Procedure FVTIACHP

Line 2485: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

2481:
2482: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
2483:
2484:
2485: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
2486: -- Moved this to instruction level (Bug 5526640)
2487: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
2488: p_instruction_id,
2489: l_docErrorTab,

Line 2487: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

2483:
2484:
2485: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
2486: -- Moved this to instruction level (Bug 5526640)
2487: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
2488: p_instruction_id,
2489: l_docErrorTab,
2490: l_docErrorRec,
2491: l_valid,

Line 2506: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

2502: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
2503: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
2504: EXIT WHEN iby_pmt_csr%NOTFOUND;
2505:
2506: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
2507: l_iby_pmt_rec.payment_id,
2508: l_docErrorTab,
2509: l_docErrorRec,
2510: l_valid,

Line 2520: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT(l_format_name,

2516: x_result:=1;
2517: RETURN;
2518: END IF;
2519:
2520: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT(l_format_name,
2521: l_iby_pmt_rec.payment_instruction_id,
2522: l_iby_pmt_rec.payment_amount,
2523: l_docErrorTab,
2524: l_docErrorRec,

Line 2535: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS

2531: RETURN;
2532: END IF;
2533:
2534:
2535: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
2536: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
2537: l_org_id,
2538: l_docErrorTab,
2539: l_docErrorRec,

Line 2536: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,

2532: END IF;
2533:
2534:
2535: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
2536: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
2537: l_org_id,
2538: l_docErrorTab,
2539: l_docErrorRec,
2540: l_valid,

Line 2550: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS

2546: RETURN;
2547: END IF;
2548:
2549:
2550: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS
2551: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS(l_format_name,
2552: l_iby_pmt_rec.payment_id,
2553: l_docErrorTab,
2554: l_docErrorRec,

Line 2551: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS(l_format_name,

2547: END IF;
2548:
2549:
2550: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS
2551: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS(l_format_name,
2552: l_iby_pmt_rec.payment_id,
2553: l_docErrorTab,
2554: l_docErrorRec,
2555: l_valid,

Line 2573: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

2569: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
2570: EXIT WHEN iby_docs_csr%NOTFOUND;
2571:
2572: -- validate internal bank account parameters
2573: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
2574: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
2575: l_iby_pmt_rec.int_bank_account_name,
2576: l_docErrorTab,
2577: l_docErrorRec,

Line 2596: -- Do Validation by IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT at Instruction Level

2592: AND payment_id = l_iby_pmt_rec.payment_id
2593: AND calling_app_id=200
2594: AND UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
2595:
2596: -- Do Validation by IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT at Instruction Level
2597: IF(l_invoice_type <> 'INTEREST') THEN
2598: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT(l_format_name,
2599: l_iby_pmt_rec.payment_id,
2600: to_number(l_iby_docs_rec.calling_app_doc_unique_ref2),

Line 2598: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT(l_format_name,

2594: AND UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
2595:
2596: -- Do Validation by IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT at Instruction Level
2597: IF(l_invoice_type <> 'INTEREST') THEN
2598: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT(l_format_name,
2599: l_iby_pmt_rec.payment_id,
2600: to_number(l_iby_docs_rec.calling_app_doc_unique_ref2),
2601: l_docErrorTab,
2602: l_docErrorRec,

Line 2613: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

2609: x_result:=1;
2610: RETURN;
2611: END IF;
2612:
2613: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
2614: p_instruction_id,
2615: l_iby_pmt_rec.payment_id,
2616: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
2617: l_docErrorTab,

Line 2635: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

2631:
2632: END LOOP;-- End Of Payments Cursor Loop
2633: CLOSE iby_pmt_csr; -- Closing Payments Cursor
2634:
2635: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
2636: p_instruction_id,
2637: l_docErrorTab,
2638: l_docErrorRec,
2639: l_valid,

Line 2662: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);

2658: l_docErrorRec.transaction_error_id := null;
2659: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
2660: l_docErrorRec.error_message := SQLERRM;
2661: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2662: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
2663: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2664:
2665:
2666: END FVTIACHB;-- End of Procedure FVTIACHB

Line 2776: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

2772: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
2773:
2774: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
2775:
2776: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
2777: -- Moved this to instruction level (Bug 5526640)
2778: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
2779: p_instruction_id,
2780: l_docErrorTab,

Line 2778: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

2774: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
2775:
2776: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
2777: -- Moved this to instruction level (Bug 5526640)
2778: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
2779: p_instruction_id,
2780: l_docErrorTab,
2781: l_docErrorRec,
2782: l_valid,

Line 2797: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

2793: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
2794: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
2795: EXIT WHEN iby_pmt_csr%NOTFOUND;
2796:
2797: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
2798: l_iby_pmt_rec.payment_id,
2799: l_docErrorTab,
2800: l_docErrorRec,
2801: l_valid,

Line 2811: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS

2807: x_result:=1;
2808: RETURN;
2809: END IF;
2810:
2811: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
2812: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
2813: l_org_id,
2814: l_docErrorTab,
2815: l_docErrorRec,

Line 2812: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,

2808: RETURN;
2809: END IF;
2810:
2811: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
2812: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
2813: l_org_id,
2814: l_docErrorTab,
2815: l_docErrorRec,
2816: l_valid,

Line 2826: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level

2822: RETURN;
2823: END IF;
2824:
2825:
2826: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
2827: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
2828: l_iby_pmt_rec.payment_instruction_id,
2829: l_iby_pmt_rec.payment_amount,
2830: l_docErrorTab,

Line 2827: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,

2823: END IF;
2824:
2825:
2826: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
2827: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
2828: l_iby_pmt_rec.payment_instruction_id,
2829: l_iby_pmt_rec.payment_amount,
2830: l_docErrorTab,
2831: l_docErrorRec,

Line 2849: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

2845: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
2846: EXIT WHEN iby_docs_csr%NOTFOUND;
2847:
2848: -- validate internal bank account parameters
2849: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
2850: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
2851: l_iby_pmt_rec.int_bank_account_name,
2852: l_docErrorTab,
2853: l_docErrorRec,

Line 2866: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,

2862: END IF;
2863:
2864: -- validate external bank account parameters
2865: -- validate external bank account id
2866: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,
2867: l_iby_pmt_rec.external_bank_account_id,
2868: l_docErrorTab,
2869: l_docErrorRec,
2870: l_valid,

Line 2880: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,

2876: RETURN;
2877: END IF;
2878:
2879:
2880: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,
2881: l_iby_pmt_rec.ext_bank_account_type,
2882: l_iby_pmt_rec.ext_bank_account_name,
2883: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
2884: l_iby_pmt_rec.payment_id,

Line 2898: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,

2894: RETURN;
2895: END IF;
2896:
2897:
2898: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,
2899: l_iby_pmt_rec.ext_bank_account_number,
2900: l_docErrorTab,
2901: l_docErrorRec,
2902: l_valid,

Line 2914: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,

2910: END IF;
2911:
2912:
2913:
2914: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,
2915: l_iby_pmt_rec.ext_branch_number,
2916: l_docErrorTab,
2917: l_docErrorRec,
2918: l_valid,

Line 2929: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,

2925: RETURN;
2926: END IF;
2927:
2928:
2929: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,
2930: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
2931: l_iby_pmt_rec.payment_id,
2932: l_docErrorTab,
2933: l_docErrorRec,

Line 2944: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

2940: RETURN;
2941: END IF;
2942:
2943:
2944: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
2945: p_instruction_id,
2946: l_iby_pmt_rec.payment_id,
2947: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
2948: l_docErrorTab,

Line 2961: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

2957: END IF;
2958:
2959:
2960:
2961: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
2962: l_iby_pmt_rec.payee_le_registration_num,
2963: l_iby_pmt_rec.payee_party_id,
2964: l_docErrorTab,
2965: l_docErrorRec,

Line 2984: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

2980:
2981: END LOOP;-- End Of Payments Cursor Loop
2982: CLOSE iby_pmt_csr; -- Closing Payments Cursor
2983:
2984: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
2985: p_instruction_id,
2986: l_docErrorTab,
2987: l_docErrorRec,
2988: l_valid,

Line 2998: IBY_PAYMENT_FORMAT_VAL_PVT.MANDATORY_PPD_PPDP_REASON_CODE(l_format_name,

2994: x_result:=1;
2995: RETURN;
2996: END IF;
2997:
2998: IBY_PAYMENT_FORMAT_VAL_PVT.MANDATORY_PPD_PPDP_REASON_CODE(l_format_name,
2999: l_pay_instr_rec.payment_reason_code,
3000: l_docErrorTab,
3001: l_docErrorRec,
3002: l_valid,

Line 3026: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);

3022: l_docErrorRec.transaction_error_id := null;
3023: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
3024: l_docErrorRec.error_message := SQLERRM;
3025: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3026: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
3027: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3028:
3029:
3030: END FVTPPPD;-- End of Procedure FVTPPPD

Line 3141: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

3137:
3138: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3139:
3140:
3141: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
3142: -- Moved this to instruction level (Bug 5526640)
3143: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
3144: p_instruction_id,
3145: l_docErrorTab,

Line 3143: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

3139:
3140:
3141: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
3142: -- Moved this to instruction level (Bug 5526640)
3143: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
3144: p_instruction_id,
3145: l_docErrorTab,
3146: l_docErrorRec,
3147: l_valid,

Line 3164: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

3160: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
3161: EXIT WHEN iby_pmt_csr%NOTFOUND;
3162:
3163:
3164: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
3165: l_iby_pmt_rec.payment_id,
3166: l_docErrorTab,
3167: l_docErrorRec,
3168: l_valid,

Line 3178: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS

3174: x_result:=1;
3175: RETURN;
3176: END IF;
3177:
3178: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
3179: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
3180: l_org_id,
3181: l_docErrorTab,
3182: l_docErrorRec,

Line 3179: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,

3175: RETURN;
3176: END IF;
3177:
3178: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
3179: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
3180: l_org_id,
3181: l_docErrorTab,
3182: l_docErrorRec,
3183: l_valid,

Line 3192: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level

3188: x_result:=1;
3189: RETURN;
3190: END IF;
3191:
3192: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
3193: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
3194: l_iby_pmt_rec.payment_instruction_id,
3195: l_iby_pmt_rec.payment_amount,
3196: l_docErrorTab,

Line 3193: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,

3189: RETURN;
3190: END IF;
3191:
3192: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
3193: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
3194: l_iby_pmt_rec.payment_instruction_id,
3195: l_iby_pmt_rec.payment_amount,
3196: l_docErrorTab,
3197: l_docErrorRec,

Line 3214: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

3210: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
3211: EXIT WHEN iby_docs_csr%NOTFOUND;
3212:
3213: -- validate internal bank account parameters
3214: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
3215: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
3216: l_iby_pmt_rec.int_bank_account_name,
3217: l_docErrorTab,
3218: l_docErrorRec,

Line 3231: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,

3227: END IF;
3228:
3229: -- validate external bank account parameters
3230: -- validate external bank account id
3231: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,
3232: l_iby_pmt_rec.external_bank_account_id,
3233: l_docErrorTab,
3234: l_docErrorRec,
3235: l_valid,

Line 3245: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,

3241: RETURN;
3242: END IF;
3243:
3244:
3245: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,
3246: l_iby_pmt_rec.ext_bank_account_type,
3247: l_iby_pmt_rec.ext_bank_account_name,
3248: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
3249: l_iby_pmt_rec.payment_id,

Line 3261: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,

3257: x_result:=1;
3258: RETURN;
3259: END IF;
3260:
3261: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,
3262: l_iby_pmt_rec.ext_bank_account_number,
3263: l_docErrorTab,
3264: l_docErrorRec,
3265: l_valid,

Line 3275: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,

3271: x_result:=1;
3272: RETURN;
3273: END IF;
3274:
3275: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,
3276: l_iby_pmt_rec.ext_branch_number,
3277: l_docErrorTab,
3278: l_docErrorRec,
3279: l_valid,

Line 3291: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,

3287: END IF;
3288:
3289:
3290:
3291: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,
3292: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
3293: l_iby_pmt_rec.payment_id,
3294: l_docErrorTab,
3295: l_docErrorRec,

Line 3306: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

3302: RETURN;
3303: END IF;
3304:
3305:
3306: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
3307: p_instruction_id,
3308: l_iby_pmt_rec.payment_id,
3309: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
3310: l_docErrorTab,

Line 3323: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

3319: END IF;
3320:
3321:
3322:
3323: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
3324: l_iby_pmt_rec.payee_le_registration_num,
3325: l_iby_pmt_rec.payee_party_id,
3326: l_docErrorTab,
3327: l_docErrorRec,

Line 3346: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

3342:
3343: END LOOP;-- End Of Payments Cursor Loop
3344: CLOSE iby_pmt_csr; -- Closing Payments Cursor
3345:
3346: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
3347: p_instruction_id,
3348: l_docErrorTab,
3349: l_docErrorRec,
3350: l_valid,

Line 3360: IBY_PAYMENT_FORMAT_VAL_PVT.MANDATORY_PPD_PPDP_REASON_CODE(l_format_name,

3356: x_result:=1;
3357: RETURN;
3358: END IF;
3359:
3360: IBY_PAYMENT_FORMAT_VAL_PVT.MANDATORY_PPD_PPDP_REASON_CODE(l_format_name,
3361: l_pay_instr_rec.payment_reason_code,
3362: l_docErrorTab,
3363: l_docErrorRec,
3364: l_valid,

Line 3386: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);

3382: l_docErrorRec.transaction_error_id := null;
3383: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
3384: l_docErrorRec.error_message := SQLERRM;
3385: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3386: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
3387: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3388:
3389:
3390: END FVTPPPDP;-- End of Procedure FVTPPPDP

Line 3499: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

3495: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
3496:
3497: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3498:
3499: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
3500: -- Moved this to instruction level (Bug 5526640)
3501: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
3502: p_instruction_id,
3503: l_docErrorTab,

Line 3501: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

3497: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3498:
3499: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
3500: -- Moved this to instruction level (Bug 5526640)
3501: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
3502: p_instruction_id,
3503: l_docErrorTab,
3504: l_docErrorRec,
3505: l_valid,

Line 3527: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

3523: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
3524: EXIT WHEN iby_docs_csr%NOTFOUND;
3525:
3526: -- validate internal bank account parameters
3527: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
3528: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
3529: l_iby_pmt_rec.int_bank_account_name,
3530: l_docErrorTab,
3531: l_docErrorRec,

Line 3543: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,

3539: END IF;
3540:
3541: -- validate external bank account parameters
3542: -- validate external bank account id
3543: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,
3544: l_iby_pmt_rec.external_bank_account_id,
3545: l_docErrorTab,
3546: l_docErrorRec,
3547: l_valid,

Line 3557: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,

3553: RETURN;
3554: END IF;
3555:
3556:
3557: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,
3558: l_iby_pmt_rec.ext_bank_account_type,
3559: l_iby_pmt_rec.ext_bank_account_name,
3560: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
3561: l_iby_pmt_rec.payment_id,

Line 3573: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,

3569: x_result:=1;
3570: RETURN;
3571: END IF;
3572:
3573: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,
3574: l_iby_pmt_rec.ext_bank_account_number,
3575: l_docErrorTab,
3576: l_docErrorRec,
3577: l_valid,

Line 3587: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,

3583: x_result:=1;
3584: RETURN;
3585: END IF;
3586:
3587: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,
3588: l_iby_pmt_rec.ext_branch_number,
3589: l_docErrorTab,
3590: l_docErrorRec,
3591: l_valid,

Line 3601: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,

3597: x_result:=1;
3598: RETURN;
3599: END IF;
3600:
3601: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,
3602: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
3603: l_iby_pmt_rec.payment_id,
3604: l_docErrorTab,
3605: l_docErrorRec,

Line 3616: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

3612: RETURN;
3613: END IF;
3614:
3615:
3616: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
3617: p_instruction_id,
3618: l_iby_pmt_rec.payment_id,
3619: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
3620: l_docErrorTab,

Line 3631: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS

3627: x_result:=1;
3628: RETURN;
3629: END IF;
3630:
3631: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS
3632:
3633:
3634:
3635: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

Line 3635: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

3631: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS
3632:
3633:
3634:
3635: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
3636: l_iby_pmt_rec.payee_le_registration_num,
3637: l_iby_pmt_rec.payee_party_id,
3638: l_docErrorTab,
3639: l_docErrorRec,

Line 3658: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,

3654:
3655: END LOOP;-- End Of Payments Cursor Loop
3656: CLOSE iby_pmt_csr; -- Closing Payments Cursor
3657:
3658: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,
3659: p_instruction_id,
3660: l_docErrorTab,
3661: l_docErrorRec,
3662: l_valid,

Line 3672: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

3668: x_result:=1;
3669: RETURN;
3670: END IF;
3671:
3672: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
3673: p_instruction_id,
3674: l_docErrorTab,
3675: l_docErrorRec,
3676: l_valid,

Line 3700: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);

3696: l_docErrorRec.transaction_error_id := null;
3697: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
3698: l_docErrorRec.error_message := SQLERRM;
3699: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3700: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
3701: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3702:
3703:
3704: END FVSPCCD;-- End of Procedure FVSPCCD

Line 3813: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

3809: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
3810:
3811: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3812:
3813: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
3814: -- Moved this to instruction level (Bug 5526640)
3815: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
3816: p_instruction_id,
3817: l_docErrorTab,

Line 3815: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

3811: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3812:
3813: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
3814: -- Moved this to instruction level (Bug 5526640)
3815: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
3816: p_instruction_id,
3817: l_docErrorTab,
3818: l_docErrorRec,
3819: l_valid,

Line 3840: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

3836: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
3837: EXIT WHEN iby_docs_csr%NOTFOUND;
3838:
3839: -- validate internal bank account parameters
3840: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
3841: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
3842: l_iby_pmt_rec.int_bank_account_name,
3843: l_docErrorTab,
3844: l_docErrorRec,

Line 3857: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,

3853:
3854:
3855: -- validate external bank account parameters
3856: -- validate external bank account id
3857: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,
3858: l_iby_pmt_rec.external_bank_account_id,
3859: l_docErrorTab,
3860: l_docErrorRec,
3861: l_valid,

Line 3871: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,

3867: RETURN;
3868: END IF;
3869:
3870:
3871: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,
3872: l_iby_pmt_rec.ext_bank_account_type,
3873: l_iby_pmt_rec.ext_bank_account_name,
3874: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
3875: l_iby_pmt_rec.payment_id,

Line 3887: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,

3883: x_result:=1;
3884: RETURN;
3885: END IF;
3886:
3887: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,
3888: l_iby_pmt_rec.ext_bank_account_number,
3889: l_docErrorTab,
3890: l_docErrorRec,
3891: l_valid,

Line 3901: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,

3897: x_result:=1;
3898: RETURN;
3899: END IF;
3900:
3901: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,
3902: l_iby_pmt_rec.ext_branch_number,
3903: l_docErrorTab,
3904: l_docErrorRec,
3905: l_valid,

Line 3916: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,

3912: RETURN;
3913: END IF;
3914:
3915:
3916: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,
3917: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
3918: l_iby_pmt_rec.payment_id,
3919: l_docErrorTab,
3920: l_docErrorRec,

Line 3930: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

3926: x_result:=1;
3927: RETURN;
3928: END IF;
3929:
3930: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
3931: p_instruction_id,
3932: l_iby_pmt_rec.payment_id,
3933: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
3934: l_docErrorTab,

Line 3945: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS

3941: x_result:=1;
3942: RETURN;
3943: END IF;
3944:
3945: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS
3946:
3947:
3948:
3949: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

Line 3949: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

3945: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS
3946:
3947:
3948:
3949: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
3950: l_iby_pmt_rec.payee_le_registration_num,
3951: l_iby_pmt_rec.payee_party_id,
3952: l_docErrorTab,
3953: l_docErrorRec,

Line 3973: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,

3969:
3970: END LOOP;-- End Of Payments Cursor Loop
3971: CLOSE iby_pmt_csr; -- Closing Payments Cursor
3972:
3973: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,
3974: p_instruction_id,
3975: l_docErrorTab,
3976: l_docErrorRec,
3977: l_valid,

Line 3988: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

3984: RETURN;
3985: END IF;
3986:
3987:
3988: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
3989: p_instruction_id,
3990: l_docErrorTab,
3991: l_docErrorRec,
3992: l_valid,

Line 4017: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);

4013: l_docErrorRec.transaction_error_id := null;
4014: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
4015: l_docErrorRec.error_message := SQLERRM;
4016: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4017: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
4018: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4019:
4020:
4021: END FVSPCCDP;-- End of Procedure FVSPCCDP

Line 4113: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

4109: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
4110:
4111: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
4112:
4113: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
4114: -- Moved this to instruction level (Bug 5526640)
4115: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
4116: p_instruction_id,
4117: l_docErrorTab,

Line 4115: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

4111: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
4112:
4113: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
4114: -- Moved this to instruction level (Bug 5526640)
4115: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
4116: p_instruction_id,
4117: l_docErrorTab,
4118: l_docErrorRec,
4119: l_valid,

Line 4134: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT at Payment Level

4130: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
4131: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
4132: EXIT WHEN iby_pmt_csr%NOTFOUND;
4133:
4134: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT at Payment Level
4135: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT(l_format_name,
4136: l_iby_pmt_rec.payment_instruction_id,
4137: l_iby_pmt_rec.payment_amount,
4138: l_docErrorTab,

Line 4135: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT(l_format_name,

4131: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
4132: EXIT WHEN iby_pmt_csr%NOTFOUND;
4133:
4134: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT at Payment Level
4135: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT(l_format_name,
4136: l_iby_pmt_rec.payment_instruction_id,
4137: l_iby_pmt_rec.payment_amount,
4138: l_docErrorTab,
4139: l_docErrorRec,

Line 4150: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS

4146: RETURN;
4147: END IF;
4148:
4149:
4150: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS
4151: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS(l_format_name,
4152: l_iby_pmt_rec.payment_id,
4153: l_docErrorTab,
4154: l_docErrorRec,

Line 4151: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS(l_format_name,

4147: END IF;
4148:
4149:
4150: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS
4151: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS(l_format_name,
4152: l_iby_pmt_rec.payment_id,
4153: l_docErrorTab,
4154: l_docErrorRec,
4155: l_valid,

Line 4174: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

4170: EXIT WHEN iby_docs_csr%NOTFOUND;
4171:
4172:
4173: -- validate internal bank account parameters
4174: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
4175: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
4176: l_iby_pmt_rec.int_bank_account_name,
4177: l_docErrorTab,
4178: l_docErrorRec,

Line 4198: -- Do Validation by IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT at Instruction Level

4194: AND payment_id = l_iby_pmt_rec.payment_id
4195: AND calling_app_id=200
4196: AND UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
4197:
4198: -- Do Validation by IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT at Instruction Level
4199: IF(l_invoice_type <> 'INTEREST') THEN
4200: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT(l_format_name,
4201: l_iby_pmt_rec.payment_id,
4202: to_number(l_iby_docs_rec.calling_app_doc_unique_ref2),

Line 4200: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT(l_format_name,

4196: AND UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
4197:
4198: -- Do Validation by IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT at Instruction Level
4199: IF(l_invoice_type <> 'INTEREST') THEN
4200: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT(l_format_name,
4201: l_iby_pmt_rec.payment_id,
4202: to_number(l_iby_docs_rec.calling_app_doc_unique_ref2),
4203: l_docErrorTab,
4204: l_docErrorRec,

Line 4215: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

4211: x_result:=1;
4212: RETURN;
4213: END IF;
4214:
4215: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
4216: p_instruction_id,
4217: l_iby_pmt_rec.payment_id,
4218: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
4219: l_docErrorTab,

Line 4230: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS

4226: x_result:=1;
4227: RETURN;
4228: END IF;
4229:
4230: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS
4231:
4232:
4233: END LOOP;-- End Of Documents Cursor Loop
4234: CLOSE iby_docs_csr;-- Closing Payable Documents Cursor

Line 4241: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,

4237: CLOSE iby_pmt_csr; -- Closing Payments Cursor
4238:
4239:
4240:
4241: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,
4242: p_instruction_id,
4243: l_docErrorTab,
4244: l_docErrorRec,
4245: l_valid,

Line 4255: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

4251: x_result:=1;
4252: RETURN;
4253: END IF;
4254:
4255: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
4256: p_instruction_id,
4257: l_docErrorTab,
4258: l_docErrorRec,
4259: l_valid,

Line 4281: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);

4277: l_docErrorRec.transaction_error_id := null;
4278: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
4279: l_docErrorRec.error_message := SQLERRM;
4280: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4281: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
4282: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4283:
4284:
4285: END FVSPNCR;-- End of Procedure FVSPNCR

Line 4394: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

4390: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
4391:
4392: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
4393:
4394: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
4395: -- Moved this to instruction level (Bug 5526640)
4396: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
4397: p_instruction_id,
4398: l_docErrorTab,

Line 4396: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

4392: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
4393:
4394: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
4395: -- Moved this to instruction level (Bug 5526640)
4396: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
4397: p_instruction_id,
4398: l_docErrorTab,
4399: l_docErrorRec,
4400: l_valid,

Line 4415: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level

4411: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
4412: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
4413: EXIT WHEN iby_pmt_csr%NOTFOUND;
4414:
4415: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
4416: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
4417: l_iby_pmt_rec.payment_instruction_id,
4418: l_iby_pmt_rec.payment_amount,
4419: l_docErrorTab,

Line 4416: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,

4412: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
4413: EXIT WHEN iby_pmt_csr%NOTFOUND;
4414:
4415: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
4416: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
4417: l_iby_pmt_rec.payment_instruction_id,
4418: l_iby_pmt_rec.payment_amount,
4419: l_docErrorTab,
4420: l_docErrorRec,

Line 4437: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

4433: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
4434: EXIT WHEN iby_docs_csr%NOTFOUND;
4435:
4436: -- validate internal bank account parameters
4437: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
4438: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
4439: l_iby_pmt_rec.int_bank_account_name,
4440: l_docErrorTab,
4441: l_docErrorRec,

Line 4453: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,

4449: END IF;
4450:
4451: -- validate external bank account parameters
4452: -- validate external bank account id
4453: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,
4454: l_iby_pmt_rec.external_bank_account_id,
4455: l_docErrorTab,
4456: l_docErrorRec,
4457: l_valid,

Line 4467: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,

4463: RETURN;
4464: END IF;
4465:
4466:
4467: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,
4468: l_iby_pmt_rec.ext_bank_account_type,
4469: l_iby_pmt_rec.ext_bank_account_name,
4470: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
4471: l_iby_pmt_rec.payment_id,

Line 4483: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,

4479: x_result:=1;
4480: RETURN;
4481: END IF;
4482:
4483: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,
4484: l_iby_pmt_rec.ext_bank_account_number,
4485: l_docErrorTab,
4486: l_docErrorRec,
4487: l_valid,

Line 4497: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,

4493: x_result:=1;
4494: RETURN;
4495: END IF;
4496:
4497: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,
4498: l_iby_pmt_rec.ext_branch_number,
4499: l_docErrorTab,
4500: l_docErrorRec,
4501: l_valid,

Line 4512: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,

4508: RETURN;
4509: END IF;
4510:
4511:
4512: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,
4513: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
4514: l_iby_pmt_rec.payment_id,
4515: l_docErrorTab,
4516: l_docErrorRec,

Line 4526: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

4522: x_result:=1;
4523: RETURN;
4524: END IF;
4525:
4526: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
4527: p_instruction_id,
4528: l_iby_pmt_rec.payment_id,
4529: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
4530: l_docErrorTab,

Line 4541: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS

4537: x_result:=1;
4538: RETURN;
4539: END IF;
4540:
4541: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS
4542:
4543:
4544:
4545: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

Line 4545: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

4541: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS
4542:
4543:
4544:
4545: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
4546: l_iby_pmt_rec.payee_le_registration_num,
4547: l_iby_pmt_rec.payee_party_id,
4548: l_docErrorTab,
4549: l_docErrorRec,

Line 4566: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,

4562:
4563: END LOOP;-- End Of Payments Cursor Loop
4564: CLOSE iby_pmt_csr; -- Closing Payments Cursor
4565:
4566: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,
4567: p_instruction_id,
4568: l_docErrorTab,
4569: l_docErrorRec,
4570: l_valid,

Line 4580: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

4576: x_result:=1;
4577: RETURN;
4578: END IF;
4579:
4580: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
4581: p_instruction_id,
4582: l_docErrorTab,
4583: l_docErrorRec,
4584: l_valid,

Line 4594: IBY_PAYMENT_FORMAT_VAL_PVT.MANDATORY_PPD_PPDP_REASON_CODE(l_format_name,

4590: x_result:=1;
4591: RETURN;
4592: END IF;
4593:
4594: IBY_PAYMENT_FORMAT_VAL_PVT.MANDATORY_PPD_PPDP_REASON_CODE(l_format_name,
4595: l_pay_instr_rec.payment_reason_code,
4596: l_docErrorTab,
4597: l_docErrorRec,
4598: l_valid,

Line 4621: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);

4617: l_docErrorRec.transaction_error_id := null;
4618: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
4619: l_docErrorRec.error_message := SQLERRM;
4620: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4621: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
4622: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4623:
4624:
4625: END FVSPPPD;-- End of Procedure FVSPPPD

Line 4734: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

4730: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
4731:
4732: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
4733:
4734: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
4735: -- Moved this to instruction level (Bug 5526640)
4736: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
4737: p_instruction_id,
4738: l_docErrorTab,

Line 4736: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

4732: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
4733:
4734: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
4735: -- Moved this to instruction level (Bug 5526640)
4736: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
4737: p_instruction_id,
4738: l_docErrorTab,
4739: l_docErrorRec,
4740: l_valid,

Line 4755: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level

4751: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
4752: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
4753: EXIT WHEN iby_pmt_csr%NOTFOUND;
4754:
4755: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
4756: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
4757: l_iby_pmt_rec.payment_instruction_id,
4758: l_iby_pmt_rec.payment_amount,
4759: l_docErrorTab,

Line 4756: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,

4752: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
4753: EXIT WHEN iby_pmt_csr%NOTFOUND;
4754:
4755: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
4756: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
4757: l_iby_pmt_rec.payment_instruction_id,
4758: l_iby_pmt_rec.payment_amount,
4759: l_docErrorTab,
4760: l_docErrorRec,

Line 4777: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

4773: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
4774: EXIT WHEN iby_docs_csr%NOTFOUND;
4775:
4776: -- validate internal bank account parameters
4777: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
4778: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
4779: l_iby_pmt_rec.int_bank_account_name,
4780: l_docErrorTab,
4781: l_docErrorRec,

Line 4794: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,

4790: END IF;
4791:
4792: -- validate external bank account parameters
4793: -- validate external bank account id
4794: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,
4795: l_iby_pmt_rec.external_bank_account_id,
4796: l_docErrorTab,
4797: l_docErrorRec,
4798: l_valid,

Line 4808: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,

4804: RETURN;
4805: END IF;
4806:
4807:
4808: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,
4809: l_iby_pmt_rec.ext_bank_account_type,
4810: l_iby_pmt_rec.ext_bank_account_name,
4811: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
4812: l_iby_pmt_rec.payment_id,

Line 4824: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,

4820: x_result:=1;
4821: RETURN;
4822: END IF;
4823:
4824: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,
4825: l_iby_pmt_rec.ext_bank_account_number,
4826: l_docErrorTab,
4827: l_docErrorRec,
4828: l_valid,

Line 4838: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,

4834: x_result:=1;
4835: RETURN;
4836: END IF;
4837:
4838: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,
4839: l_iby_pmt_rec.ext_branch_number,
4840: l_docErrorTab,
4841: l_docErrorRec,
4842: l_valid,

Line 4853: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,

4849: RETURN;
4850: END IF;
4851:
4852:
4853: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,
4854: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
4855: l_iby_pmt_rec.payment_id,
4856: l_docErrorTab,
4857: l_docErrorRec,

Line 4868: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

4864: RETURN;
4865: END IF;
4866:
4867:
4868: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
4869: p_instruction_id,
4870: l_iby_pmt_rec.payment_id,
4871: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
4872: l_docErrorTab,

Line 4883: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS

4879: x_result:=1;
4880: RETURN;
4881: END IF;
4882:
4883: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS
4884:
4885:
4886:
4887: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

Line 4887: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

4883: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS
4884:
4885:
4886:
4887: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
4888: l_iby_pmt_rec.payee_le_registration_num,
4889: l_iby_pmt_rec.payee_party_id,
4890: l_docErrorTab,
4891: l_docErrorRec,

Line 4909: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,

4905:
4906: END LOOP;-- End Of Payments Cursor Loop
4907: CLOSE iby_pmt_csr; -- Closing Payments Cursor
4908:
4909: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,
4910: p_instruction_id,
4911: l_docErrorTab,
4912: l_docErrorRec,
4913: l_valid,

Line 4923: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

4919: x_result:=1;
4920: RETURN;
4921: END IF;
4922:
4923: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
4924: p_instruction_id,
4925: l_docErrorTab,
4926: l_docErrorRec,
4927: l_valid,

Line 4937: IBY_PAYMENT_FORMAT_VAL_PVT.MANDATORY_PPD_PPDP_REASON_CODE(l_format_name,

4933: x_result:=1;
4934: RETURN;
4935: END IF;
4936:
4937: IBY_PAYMENT_FORMAT_VAL_PVT.MANDATORY_PPD_PPDP_REASON_CODE(l_format_name,
4938: l_pay_instr_rec.payment_reason_code,
4939: l_docErrorTab,
4940: l_docErrorRec,
4941: l_valid,

Line 4964: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);

4960: l_docErrorRec.transaction_error_id := null;
4961: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
4962: l_docErrorRec.error_message := SQLERRM;
4963: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4964: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
4965: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4966:
4967:
4968: END FVSPPPDP;-- End of Procedure FVSPPPDP

Line 4978: g_FAILURE := -1; -- Corresponds To g_ERROR OF IBY_PAYMENT_FORMAT_VAL_PVT Package.

4974: ----------------------------------------------------------------------------------------------------------
4975:
4976: -- Initialising Global Variables
4977: BEGIN
4978: g_FAILURE := -1; -- Corresponds To g_ERROR OF IBY_PAYMENT_FORMAT_VAL_PVT Package.
4979: g_EXCEPTION := -2; -- Corresponds To g_FAILURE OF IBY_PAYMENT_FORMAT_VAL_PVT Package.
4980: g_SUCCESS := 0;
4981:
4982: ----------------------------------------------------------------------------------------------------------

Line 4979: g_EXCEPTION := -2; -- Corresponds To g_FAILURE OF IBY_PAYMENT_FORMAT_VAL_PVT Package.

4975:
4976: -- Initialising Global Variables
4977: BEGIN
4978: g_FAILURE := -1; -- Corresponds To g_ERROR OF IBY_PAYMENT_FORMAT_VAL_PVT Package.
4979: g_EXCEPTION := -2; -- Corresponds To g_FAILURE OF IBY_PAYMENT_FORMAT_VAL_PVT Package.
4980: g_SUCCESS := 0;
4981:
4982: ----------------------------------------------------------------------------------------------------------
4983: