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 107: IBY_PAYMENT_FORMAT_VAL_PVT.FEDERAL_ID_NUMBER(

103: -- delete from FV_TP_TS_AMT_DATA to refresh data
104: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
105:
106: -- Do validation of the Federal Identification Number
107: IBY_PAYMENT_FORMAT_VAL_PVT.FEDERAL_ID_NUMBER(
108: l_format_name,
109: p_instruction_id,
110: l_docErrorTab,
111: l_docErrorRec,

Line 123: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ID_ABBREVIATION(

119: RETURN;
120: END IF;
121:
122: -- Do validation of Agency Id Abbreviation
123: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ID_ABBREVIATION(
124: l_format_name,
125: p_instruction_id,
126: l_docErrorTab,
127: l_docErrorRec,

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

134: x_result:=1;
135: RETURN;
136: END IF;
137:
138: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
139: -- Moved this to instruction level (Bug 5526640)
140: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
141: p_instruction_id,
142: l_docErrorTab,

Line 140: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

136: END IF;
137:
138: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
139: -- Moved this to instruction level (Bug 5526640)
140: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
141: p_instruction_id,
142: l_docErrorTab,
143: l_docErrorRec,
144: l_valid,

Line 160: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

156:
157: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
158: EXIT WHEN iby_pmt_csr%NOTFOUND;
159:
160: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
161: l_iby_pmt_rec.payment_id,
162: l_docErrorTab,
163: l_docErrorRec,
164: l_valid,

Line 183: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

179: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
180: EXIT WHEN iby_docs_csr%NOTFOUND;
181:
182: -- validate internal bank account parameters
183: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
184: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
185: l_iby_pmt_rec.int_bank_account_name,
186: l_docErrorTab,
187: l_docErrorRec,

Line 200: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,

196:
197:
198: -- validate external bank account parameters
199: -- validate external bank account id
200: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,
201: l_iby_pmt_rec.external_bank_account_id,
202: l_docErrorTab,
203: l_docErrorRec,
204: l_valid,

Line 214: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,

210: RETURN;
211: END IF;
212:
213:
214: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,
215: l_iby_pmt_rec.ext_bank_account_type,
216: l_iby_pmt_rec.ext_bank_account_name,
217: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
218: l_docErrorTab,

Line 230: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,

226: RETURN;
227: END IF;
228:
229:
230: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,
231: l_iby_pmt_rec.ext_bank_account_number,
232: l_docErrorTab,
233: l_docErrorRec,
234: l_valid,

Line 244: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,

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

Line 259: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,

255: END IF;
256:
257:
258:
259: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,
260: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
261: l_docErrorTab,
262: l_docErrorRec,
263: l_valid,

Line 273: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

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

Line 291: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

287: END IF;
288:
289:
290:
291: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
292: l_iby_pmt_rec.payee_le_registration_num,
293: l_iby_pmt_rec.payee_party_id,
294: l_docErrorTab,
295: l_docErrorRec,

Line 315: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,

311:
312: END LOOP;-- End Of Payments Cursor Loop
313: CLOSE iby_pmt_csr; -- Closing Payments Cursor
314:
315: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,
316: p_instruction_id,
317: l_docErrorTab,
318: l_docErrorRec,
319: l_valid,

Line 329: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

325: x_result:=1;
326: RETURN;
327: END IF;
328:
329: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
330: p_instruction_id,
331: l_docErrorTab,
332: l_docErrorRec,
333: l_valid,

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

353: l_docErrorRec.transaction_error_id := null;
354: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
355: l_docErrorRec.error_message := SQLERRM;
356: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
357: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
358: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
359:
360: END FVBLCCDP; -- End of Procedure FVBLCCDP
361:

Line 452: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ID_ABBREVIATION(

448:
449: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_Id
450:
451: -- Do validation of Agency Id Abbreviation
452: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ID_ABBREVIATION(
453: l_format_name,
454: p_instruction_id,
455: l_docErrorTab,
456: l_docErrorRec,

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

464: RETURN;
465: END IF;
466:
467:
468: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
469: -- Moved this to instruction level (Bug 5526640)
470: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
471: p_instruction_id,
472: l_docErrorTab,

Line 470: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

466:
467:
468: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
469: -- Moved this to instruction level (Bug 5526640)
470: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
471: p_instruction_id,
472: l_docErrorTab,
473: l_docErrorRec,
474: l_valid,

Line 490: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

486: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
487: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
488: EXIT WHEN iby_pmt_csr%NOTFOUND;
489:
490: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
491: l_iby_pmt_rec.payment_id,
492: l_docErrorTab,
493: l_docErrorRec,
494: l_valid,

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

500: x_result:=1;
501: RETURN;
502: END IF;
503:
504: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT at Payment Level
505: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT(l_format_name,
506: l_iby_pmt_rec.payment_instruction_id,
507: l_iby_pmt_rec.payment_amount,
508: l_docErrorTab,

Line 505: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT(l_format_name,

501: RETURN;
502: END IF;
503:
504: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT at Payment Level
505: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT(l_format_name,
506: l_iby_pmt_rec.payment_instruction_id,
507: l_iby_pmt_rec.payment_amount,
508: l_docErrorTab,
509: l_docErrorRec,

Line 522: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,

518: END IF;
519:
520:
521:
522: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
523: l_org_id,
524: l_docErrorTab,
525: l_docErrorRec,
526: l_valid,

Line 536: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS(l_format_name,

532: RETURN;
533: END IF;
534:
535:
536: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS(l_format_name,
537: l_iby_pmt_rec.payment_id,
538: l_docErrorTab,
539: l_docErrorRec,
540: l_valid,

Line 558: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

554: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
555: EXIT WHEN iby_docs_csr%NOTFOUND;
556:
557: -- validate internal bank account parameters
558: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
559: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
560: l_iby_pmt_rec.int_bank_account_name,
561: l_docErrorTab,
562: l_docErrorRec,

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

569: RETURN;
570: END IF;
571:
572:
573: -- Do Validation by IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT at Instruction Level
574: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT(l_format_name,
575: l_iby_pmt_rec.payment_id,
576: to_number(l_iby_docs_rec.calling_app_doc_unique_ref2),
577: l_docErrorTab,

Line 574: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT(l_format_name,

570: END IF;
571:
572:
573: -- Do Validation by IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT at Instruction Level
574: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT(l_format_name,
575: l_iby_pmt_rec.payment_id,
576: to_number(l_iby_docs_rec.calling_app_doc_unique_ref2),
577: l_docErrorTab,
578: l_docErrorRec,

Line 589: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

585: RETURN;
586: END IF;
587:
588:
589: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
590: p_instruction_id,
591: l_iby_pmt_rec.payment_id,
592: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
593: l_docErrorTab,

Line 606: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

602: END IF;
603:
604:
605:
606: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
607: l_iby_pmt_rec.payee_le_registration_num,
608: l_iby_pmt_rec.payee_party_id,
609: l_docErrorTab,
610: l_docErrorRec,

Line 628: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,

624:
625: END LOOP;-- End Of Payments Cursor Loop
626: CLOSE iby_pmt_csr; -- Closing Payments Cursor
627:
628: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,
629: p_instruction_id,
630: l_docErrorTab,
631: l_docErrorRec,
632: l_valid,

Line 642: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

638: x_result:=1;
639: RETURN;
640: END IF;
641:
642: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
643: p_instruction_id,
644: l_docErrorTab,
645: l_docErrorRec,
646: l_valid,

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

665: l_docErrorRec.transaction_error_id := null;
666: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
667: l_docErrorRec.error_message := SQLERRM;
668: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
669: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
670: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
671:
672:
673:

Line 767: IBY_PAYMENT_FORMAT_VAL_PVT.FEDERAL_ID_NUMBER(

763: -- delete from FV_TP_TS_AMT_DATA to refresh data
764: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
765:
766: -- Do validation of the Federal Identification Number
767: IBY_PAYMENT_FORMAT_VAL_PVT.FEDERAL_ID_NUMBER(
768: l_format_name,
769: p_instruction_id,
770: l_docErrorTab,
771: l_docErrorRec,

Line 783: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ID_ABBREVIATION(

779: RETURN;
780: END IF;
781:
782: -- Do validation of Agency Id Abbreviation
783: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ID_ABBREVIATION(
784: l_format_name,
785: p_instruction_id,
786: l_docErrorTab,
787: l_docErrorRec,

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

795: RETURN;
796: END IF;
797:
798:
799: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
800: -- Moved this to instruction level (Bug 5526640)
801: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
802: p_instruction_id,
803: l_docErrorTab,

Line 801: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

797:
798:
799: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
800: -- Moved this to instruction level (Bug 5526640)
801: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
802: p_instruction_id,
803: l_docErrorTab,
804: l_docErrorRec,
805: l_valid,

Line 822: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

818: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
819: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
820: EXIT WHEN iby_pmt_csr%NOTFOUND;
821:
822: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
823: l_iby_pmt_rec.payment_id,
824: l_docErrorTab,
825: l_docErrorRec,
826: l_valid,

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

832: x_result:=1;
833: RETURN;
834: END IF;
835:
836: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
837: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
838: l_iby_pmt_rec.payment_instruction_id,
839: l_iby_pmt_rec.payment_amount,
840: l_docErrorTab,

Line 837: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,

833: RETURN;
834: END IF;
835:
836: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
837: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
838: l_iby_pmt_rec.payment_instruction_id,
839: l_iby_pmt_rec.payment_amount,
840: l_docErrorTab,
841: l_docErrorRec,

Line 859: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

855: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
856: EXIT WHEN iby_docs_csr%NOTFOUND;
857:
858: -- validate internal bank account parameters
859: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
860: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
861: l_iby_pmt_rec.int_bank_account_name,
862: l_docErrorTab,
863: l_docErrorRec,

Line 876: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,

872: END IF;
873:
874: -- validate external bank account parameters
875: -- validate external bank account id
876: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,
877: l_iby_pmt_rec.external_bank_account_id,
878: l_docErrorTab,
879: l_docErrorRec,
880: l_valid,

Line 890: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,

886: RETURN;
887: END IF;
888:
889:
890: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,
891: l_iby_pmt_rec.ext_bank_account_type,
892: l_iby_pmt_rec.ext_bank_account_name,
893: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
894: l_docErrorTab,

Line 906: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,

902: RETURN;
903: END IF;
904:
905:
906: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,
907: l_iby_pmt_rec.ext_bank_account_number,
908: l_docErrorTab,
909: l_docErrorRec,
910: l_valid,

Line 920: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,

916: RETURN;
917: END IF;
918:
919:
920: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,
921: l_iby_pmt_rec.ext_branch_number,
922: l_docErrorTab,
923: l_docErrorRec,
924: l_valid,

Line 936: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,

932:
933:
934:
935:
936: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,
937: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
938: l_docErrorTab,
939: l_docErrorRec,
940: l_valid,

Line 950: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

946: RETURN;
947: END IF;
948:
949:
950: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
951: p_instruction_id,
952: l_iby_pmt_rec.payment_id,
953: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
954: l_docErrorTab,

Line 966: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

962: RETURN;
963: END IF;
964:
965:
966: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
967: l_iby_pmt_rec.payee_le_registration_num,
968: l_iby_pmt_rec.payee_party_id,
969: l_docErrorTab,
970: l_docErrorRec,

Line 987: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,

983:
984: END LOOP;-- End Of Payments Cursor Loop
985: CLOSE iby_pmt_csr; -- Closing Payments Cursor
986:
987: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,
988: p_instruction_id,
989: l_docErrorTab,
990: l_docErrorRec,
991: l_valid,

Line 1001: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

997: x_result:=1;
998: RETURN;
999: END IF;
1000:
1001: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
1002: p_instruction_id,
1003: l_docErrorTab,
1004: l_docErrorRec,
1005: l_valid,

Line 1015: IBY_PAYMENT_FORMAT_VAL_PVT.MANDATORY_PPD_PPDP_REASON_CODE(l_format_name,

1011: x_result:=1;
1012: RETURN;
1013: END IF;
1014:
1015: IBY_PAYMENT_FORMAT_VAL_PVT.MANDATORY_PPD_PPDP_REASON_CODE(l_format_name,
1016: l_pay_instr_rec.payment_reason_code,
1017: l_docErrorTab,
1018: l_docErrorRec,
1019: l_valid,

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

1037: l_docErrorRec.transaction_error_id := null;
1038: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1039: l_docErrorRec.error_message := SQLERRM;
1040: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1041: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
1042: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1043:
1044:
1045: END FVBLPPDP;-- End of Procedure FVBLPPDP

Line 1136: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ID_ABBREVIATION(

1132:
1133: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
1134:
1135: -- Do validation of Agency Id Abbreviation
1136: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ID_ABBREVIATION(
1137: l_format_name,
1138: p_instruction_id,
1139: l_docErrorTab,
1140: l_docErrorRec,

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

1147: x_result:=1;
1148: RETURN;
1149: END IF;
1150:
1151: -- Do Validation by IBY_PAYMENT_FORMAT_VAL_PVT.PAY_SALARY_TRAVEL at Instruction Level
1152: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_SALARY_TRAVEL(l_format_name,
1153: l_pay_instr_rec.payment_reason_code,
1154: l_docErrorTab,
1155: l_docErrorRec,

Line 1152: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_SALARY_TRAVEL(l_format_name,

1148: RETURN;
1149: END IF;
1150:
1151: -- Do Validation by IBY_PAYMENT_FORMAT_VAL_PVT.PAY_SALARY_TRAVEL at Instruction Level
1152: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_SALARY_TRAVEL(l_format_name,
1153: l_pay_instr_rec.payment_reason_code,
1154: l_docErrorTab,
1155: l_docErrorRec,
1156: l_valid,

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

1162: RETURN;
1163: END IF;
1164:
1165:
1166: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
1167: -- Moved this to instruction level (Bug 5526640)
1168: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
1169: p_instruction_id,
1170: l_docErrorTab,

Line 1168: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

1164:
1165:
1166: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
1167: -- Moved this to instruction level (Bug 5526640)
1168: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
1169: p_instruction_id,
1170: l_docErrorTab,
1171: l_docErrorRec,
1172: l_valid,

Line 1187: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

1183: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
1184: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
1185: EXIT WHEN iby_pmt_csr%NOTFOUND;
1186:
1187: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
1188: l_iby_pmt_rec.payment_id,
1189: l_docErrorTab,
1190: l_docErrorRec,
1191: l_valid,

Line 1201: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,

1197: x_result:=1;
1198: RETURN;
1199: END IF;
1200:
1201: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
1202: l_org_id,
1203: l_docErrorTab,
1204: l_docErrorRec,
1205: l_valid,

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

1211: x_result:=1;
1212: RETURN;
1213: END IF;
1214:
1215: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
1216: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
1217: l_iby_pmt_rec.payment_instruction_id,
1218: l_iby_pmt_rec.payment_amount,
1219: l_docErrorTab,

Line 1216: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,

1212: RETURN;
1213: END IF;
1214:
1215: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
1216: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
1217: l_iby_pmt_rec.payment_instruction_id,
1218: l_iby_pmt_rec.payment_amount,
1219: l_docErrorTab,
1220: l_docErrorRec,

Line 1239: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

1235: EXIT WHEN iby_docs_csr%NOTFOUND;
1236:
1237:
1238: -- validate internal bank account parameters
1239: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
1240: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
1241: l_iby_pmt_rec.int_bank_account_name,
1242: l_docErrorTab,
1243: l_docErrorRec,

Line 1254: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

1250: RETURN;
1251: END IF;
1252:
1253:
1254: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
1255: p_instruction_id,
1256: l_iby_pmt_rec.payment_id,
1257: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
1258: l_docErrorTab,

Line 1270: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

1266: RETURN;
1267: END IF;
1268:
1269:
1270: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
1271: l_iby_pmt_rec.payee_le_registration_num,
1272: l_iby_pmt_rec.payee_party_id,
1273: l_docErrorTab,
1274: l_docErrorRec,

Line 1292: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,

1288:
1289: END LOOP;-- End Of Payments Cursor Loop
1290: CLOSE iby_pmt_csr; -- Closing Payments Cursor
1291:
1292: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,
1293: p_instruction_id,
1294: l_docErrorTab,
1295: l_docErrorRec,
1296: l_valid,

Line 1306: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

1302: x_result:=1;
1303: RETURN;
1304: END IF;
1305:
1306: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
1307: p_instruction_id,
1308: l_docErrorTab,
1309: l_docErrorRec,
1310: l_valid,

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

1330: l_docErrorRec.transaction_error_id := null;
1331: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1332: l_docErrorRec.error_message := SQLERRM;
1333: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1334: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
1335: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1336:
1337:
1338: END FVBLSLTR;-- End of Procedure FVBLSLTR

Line 1435: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ID_ABBREVIATION(

1431:
1432: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
1433:
1434: -- Do validation of Agency Id Abbreviation
1435: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ID_ABBREVIATION(
1436: l_format_name,
1437: p_instruction_id,
1438: l_docErrorTab,
1439: l_docErrorRec,

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

1447: RETURN;
1448: END IF;
1449:
1450:
1451: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
1452: -- Moved this to instruction level (Bug 5526640)
1453: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
1454: p_instruction_id,
1455: l_docErrorTab,

Line 1453: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

1449:
1450:
1451: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
1452: -- Moved this to instruction level (Bug 5526640)
1453: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
1454: p_instruction_id,
1455: l_docErrorTab,
1456: l_docErrorRec,
1457: l_valid,

Line 1472: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

1468: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
1469: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
1470: EXIT WHEN iby_pmt_csr%NOTFOUND;
1471:
1472: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
1473: l_iby_pmt_rec.payment_id,
1474: l_docErrorTab,
1475: l_docErrorRec,
1476: l_valid,

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

1482: x_result:=1;
1483: RETURN;
1484: END IF;
1485:
1486: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT at Payment Level
1487: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT(l_format_name,
1488: l_iby_pmt_rec.payment_instruction_id,
1489: l_iby_pmt_rec.payment_amount,
1490: l_docErrorTab,

Line 1487: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT(l_format_name,

1483: RETURN;
1484: END IF;
1485:
1486: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT at Payment Level
1487: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT(l_format_name,
1488: l_iby_pmt_rec.payment_instruction_id,
1489: l_iby_pmt_rec.payment_amount,
1490: l_docErrorTab,
1491: l_docErrorRec,

Line 1502: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS

1498: RETURN;
1499: END IF;
1500:
1501:
1502: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
1503: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
1504: l_org_id,
1505: l_docErrorTab,
1506: l_docErrorRec,

Line 1503: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,

1499: END IF;
1500:
1501:
1502: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
1503: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
1504: l_org_id,
1505: l_docErrorTab,
1506: l_docErrorRec,
1507: l_valid,

Line 1524: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

1520: EXIT WHEN iby_docs_csr%NOTFOUND;
1521:
1522:
1523: -- validate internal bank account parameters
1524: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
1525: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
1526: l_iby_pmt_rec.int_bank_account_name,
1527: l_docErrorTab,
1528: l_docErrorRec,

Line 1540: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,

1536: END IF;
1537:
1538: -- validate external bank account parameters
1539: -- validate external bank account id
1540: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,
1541: l_iby_pmt_rec.external_bank_account_id,
1542: l_docErrorTab,
1543: l_docErrorRec,
1544: l_valid,

Line 1553: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,

1549: x_result:=1;
1550: RETURN;
1551: END IF;
1552:
1553: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,
1554: l_iby_pmt_rec.ext_bank_account_type,
1555: l_iby_pmt_rec.ext_bank_account_name,
1556: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
1557: l_docErrorTab,

Line 1569: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,

1565: RETURN;
1566: END IF;
1567:
1568:
1569: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,
1570: l_iby_pmt_rec.ext_bank_account_number,
1571: l_docErrorTab,
1572: l_docErrorRec,
1573: l_valid,

Line 1583: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,

1579: RETURN;
1580: END IF;
1581:
1582:
1583: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,
1584: l_iby_pmt_rec.ext_branch_number,
1585: l_docErrorTab,
1586: l_docErrorRec,
1587: l_valid,

Line 1597: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,

1593: RETURN;
1594: END IF;
1595:
1596:
1597: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,
1598: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
1599: l_docErrorTab,
1600: l_docErrorRec,
1601: l_valid,

Line 1611: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

1607: RETURN;
1608: END IF;
1609:
1610:
1611: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
1612: p_instruction_id,
1613: l_iby_pmt_rec.payment_id,
1614: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
1615: l_docErrorTab,

Line 1627: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

1623: RETURN;
1624: END IF;
1625:
1626:
1627: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
1628: l_iby_pmt_rec.payee_le_registration_num,
1629: l_iby_pmt_rec.payee_party_id,
1630: l_docErrorTab,
1631: l_docErrorRec,

Line 1650: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

1646:
1647: END LOOP;-- End Of Payments Cursor Loop
1648: CLOSE iby_pmt_csr; -- Closing Payments Cursor
1649:
1650: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
1651: p_instruction_id,
1652: l_docErrorTab,
1653: l_docErrorRec,
1654: l_valid,

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

1673: l_docErrorRec.transaction_error_id := null;
1674: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1675: l_docErrorRec.error_message := SQLERRM;
1676: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1677: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
1678: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1679:
1680:
1681: END FVTICTX;-- End of Procedure FVTICTX

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

1773: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
1774:
1775: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
1776:
1777: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
1778: -- Moved this to instruction level (Bug 5526640)
1779: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
1780: p_instruction_id,
1781: l_docErrorTab,

Line 1779: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

1775: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
1776:
1777: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
1778: -- Moved this to instruction level (Bug 5526640)
1779: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
1780: p_instruction_id,
1781: l_docErrorTab,
1782: l_docErrorRec,
1783: l_valid,

Line 1800: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

1796: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
1797: EXIT WHEN iby_pmt_csr%NOTFOUND;
1798:
1799:
1800: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
1801: l_iby_pmt_rec.payment_id,
1802: l_docErrorTab,
1803: l_docErrorRec,
1804: l_valid,

Line 1814: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS

1810: x_result:=1;
1811: RETURN;
1812: END IF;
1813:
1814: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
1815: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
1816: l_org_id,
1817: l_docErrorTab,
1818: l_docErrorRec,

Line 1815: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,

1811: RETURN;
1812: END IF;
1813:
1814: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
1815: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
1816: l_org_id,
1817: l_docErrorTab,
1818: l_docErrorRec,
1819: l_valid,

Line 1836: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

1832: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
1833: EXIT WHEN iby_docs_csr%NOTFOUND;
1834:
1835: -- validate internal bank account parameters
1836: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
1837: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
1838: l_iby_pmt_rec.int_bank_account_name,
1839: l_docErrorTab,
1840: l_docErrorRec,

Line 1852: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,

1848: END IF;
1849:
1850: -- validate external bank account parameters
1851: -- validate external bank account id
1852: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,
1853: l_iby_pmt_rec.external_bank_account_id,
1854: l_docErrorTab,
1855: l_docErrorRec,
1856: l_valid,

Line 1866: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,

1862: RETURN;
1863: END IF;
1864:
1865:
1866: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,
1867: l_iby_pmt_rec.ext_bank_account_type,
1868: l_iby_pmt_rec.ext_bank_account_name,
1869: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
1870: l_docErrorTab,

Line 1882: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,

1878: RETURN;
1879: END IF;
1880:
1881:
1882: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,
1883: l_iby_pmt_rec.ext_bank_account_number,
1884: l_docErrorTab,
1885: l_docErrorRec,
1886: l_valid,

Line 1896: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,

1892: x_result:=1;
1893: RETURN;
1894: END IF;
1895:
1896: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,
1897: l_iby_pmt_rec.ext_branch_number,
1898: l_docErrorTab,
1899: l_docErrorRec,
1900: l_valid,

Line 1911: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,

1907: RETURN;
1908: END IF;
1909:
1910:
1911: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,
1912: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
1913: l_docErrorTab,
1914: l_docErrorRec,
1915: l_valid,

Line 1925: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

1921: RETURN;
1922: END IF;
1923:
1924:
1925: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
1926: p_instruction_id,
1927: l_iby_pmt_rec.payment_id,
1928: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
1929: l_docErrorTab,

Line 1942: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

1938: END IF;
1939:
1940:
1941:
1942: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
1943: l_iby_pmt_rec.payee_le_registration_num,
1944: l_iby_pmt_rec.payee_party_id,
1945: l_docErrorTab,
1946: l_docErrorRec,

Line 1965: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

1961:
1962: END LOOP;-- End Of Payments Cursor Loop
1963: CLOSE iby_pmt_csr; -- Closing Payments Cursor
1964:
1965: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
1966: p_instruction_id,
1967: l_docErrorTab,
1968: l_docErrorRec,
1969: l_valid,

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

1989: l_docErrorRec.transaction_error_id := null;
1990: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1991: l_docErrorRec.error_message := SQLERRM;
1992: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1993: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
1994: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1995:
1996:
1997: END FVTPCCD;-- End of Procedure FVTPCCD

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

2089:
2090: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
2091:
2092:
2093: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
2094: -- Moved this to instruction level (Bug 5526640)
2095: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
2096: p_instruction_id,
2097: l_docErrorTab,

Line 2095: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

2091:
2092:
2093: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
2094: -- Moved this to instruction level (Bug 5526640)
2095: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
2096: p_instruction_id,
2097: l_docErrorTab,
2098: l_docErrorRec,
2099: l_valid,

Line 2115: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

2111: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
2112: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
2113: EXIT WHEN iby_pmt_csr%NOTFOUND;
2114:
2115: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
2116: l_iby_pmt_rec.payment_id,
2117: l_docErrorTab,
2118: l_docErrorRec,
2119: l_valid,

Line 2129: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS

2125: x_result:=1;
2126: RETURN;
2127: END IF;
2128:
2129: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
2130: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
2131: l_org_id,
2132: l_docErrorTab,
2133: l_docErrorRec,

Line 2130: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,

2126: RETURN;
2127: END IF;
2128:
2129: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
2130: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
2131: l_org_id,
2132: l_docErrorTab,
2133: l_docErrorRec,
2134: l_valid,

Line 2151: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

2147: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
2148: EXIT WHEN iby_docs_csr%NOTFOUND;
2149:
2150: -- validate internal bank account parameters
2151: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
2152: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
2153: l_iby_pmt_rec.int_bank_account_name,
2154: l_docErrorTab,
2155: l_docErrorRec,

Line 2167: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,

2163: END IF;
2164:
2165: -- validate external bank account parameters
2166: -- validate external bank account id
2167: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,
2168: l_iby_pmt_rec.external_bank_account_id,
2169: l_docErrorTab,
2170: l_docErrorRec,
2171: l_valid,

Line 2181: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,

2177: RETURN;
2178: END IF;
2179:
2180:
2181: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,
2182: l_iby_pmt_rec.ext_bank_account_type,
2183: l_iby_pmt_rec.ext_bank_account_name,
2184: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
2185: l_docErrorTab,

Line 2196: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,

2192: x_result:=1;
2193: RETURN;
2194: END IF;
2195:
2196: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,
2197: l_iby_pmt_rec.ext_bank_account_number,
2198: l_docErrorTab,
2199: l_docErrorRec,
2200: l_valid,

Line 2210: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,

2206: RETURN;
2207: END IF;
2208:
2209:
2210: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,
2211: l_iby_pmt_rec.ext_branch_number,
2212: l_docErrorTab,
2213: l_docErrorRec,
2214: l_valid,

Line 2225: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,

2221: RETURN;
2222: END IF;
2223:
2224:
2225: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,
2226: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
2227: l_docErrorTab,
2228: l_docErrorRec,
2229: l_valid,

Line 2239: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

2235: RETURN;
2236: END IF;
2237:
2238:
2239: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
2240: p_instruction_id,
2241: l_iby_pmt_rec.payment_id,
2242: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
2243: l_docErrorTab,

Line 2256: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

2252: END IF;
2253:
2254:
2255:
2256: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
2257: l_iby_pmt_rec.payee_le_registration_num,
2258: l_iby_pmt_rec.payee_party_id,
2259: l_docErrorTab,
2260: l_docErrorRec,

Line 2279: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

2275:
2276: END LOOP;-- End Of Payments Cursor Loop
2277: CLOSE iby_pmt_csr; -- Closing Payments Cursor
2278:
2279: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
2280: p_instruction_id,
2281: l_docErrorTab,
2282: l_docErrorRec,
2283: l_valid,

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

2302: l_docErrorRec.transaction_error_id := null;
2303: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
2304: l_docErrorRec.error_message := SQLERRM;
2305: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2306: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
2307: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2308:
2309:
2310: END FVTIACHP;-- End of Procedure FVTIACHP

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

2395:
2396: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
2397:
2398:
2399: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
2400: -- Moved this to instruction level (Bug 5526640)
2401: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
2402: p_instruction_id,
2403: l_docErrorTab,

Line 2401: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

2397:
2398:
2399: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
2400: -- Moved this to instruction level (Bug 5526640)
2401: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
2402: p_instruction_id,
2403: l_docErrorTab,
2404: l_docErrorRec,
2405: l_valid,

Line 2420: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

2416: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
2417: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
2418: EXIT WHEN iby_pmt_csr%NOTFOUND;
2419:
2420: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
2421: l_iby_pmt_rec.payment_id,
2422: l_docErrorTab,
2423: l_docErrorRec,
2424: l_valid,

Line 2434: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT(l_format_name,

2430: x_result:=1;
2431: RETURN;
2432: END IF;
2433:
2434: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT(l_format_name,
2435: l_iby_pmt_rec.payment_instruction_id,
2436: l_iby_pmt_rec.payment_amount,
2437: l_docErrorTab,
2438: l_docErrorRec,

Line 2449: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS

2445: RETURN;
2446: END IF;
2447:
2448:
2449: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
2450: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
2451: l_org_id,
2452: l_docErrorTab,
2453: l_docErrorRec,

Line 2450: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,

2446: END IF;
2447:
2448:
2449: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
2450: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
2451: l_org_id,
2452: l_docErrorTab,
2453: l_docErrorRec,
2454: l_valid,

Line 2464: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS

2460: RETURN;
2461: END IF;
2462:
2463:
2464: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS
2465: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS(l_format_name,
2466: l_iby_pmt_rec.payment_id,
2467: l_docErrorTab,
2468: l_docErrorRec,

Line 2465: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS(l_format_name,

2461: END IF;
2462:
2463:
2464: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS
2465: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS(l_format_name,
2466: l_iby_pmt_rec.payment_id,
2467: l_docErrorTab,
2468: l_docErrorRec,
2469: l_valid,

Line 2487: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

2483: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
2484: EXIT WHEN iby_docs_csr%NOTFOUND;
2485:
2486: -- validate internal bank account parameters
2487: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
2488: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
2489: l_iby_pmt_rec.int_bank_account_name,
2490: l_docErrorTab,
2491: l_docErrorRec,

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

2499: RETURN;
2500: END IF;
2501:
2502:
2503: -- Do Validation by IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT at Instruction Level
2504: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT(l_format_name,
2505: l_iby_pmt_rec.payment_id,
2506: to_number(l_iby_docs_rec.calling_app_doc_unique_ref2),
2507: l_docErrorTab,

Line 2504: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT(l_format_name,

2500: END IF;
2501:
2502:
2503: -- Do Validation by IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT at Instruction Level
2504: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT(l_format_name,
2505: l_iby_pmt_rec.payment_id,
2506: to_number(l_iby_docs_rec.calling_app_doc_unique_ref2),
2507: l_docErrorTab,
2508: l_docErrorRec,

Line 2518: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

2514: x_result:=1;
2515: RETURN;
2516: END IF;
2517:
2518: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
2519: p_instruction_id,
2520: l_iby_pmt_rec.payment_id,
2521: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
2522: l_docErrorTab,

Line 2540: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

2536:
2537: END LOOP;-- End Of Payments Cursor Loop
2538: CLOSE iby_pmt_csr; -- Closing Payments Cursor
2539:
2540: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
2541: p_instruction_id,
2542: l_docErrorTab,
2543: l_docErrorRec,
2544: l_valid,

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

2563: l_docErrorRec.transaction_error_id := null;
2564: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
2565: l_docErrorRec.error_message := SQLERRM;
2566: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2567: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
2568: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2569:
2570:
2571: END FVTIACHB;-- End of Procedure FVTIACHB

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

2664: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
2665:
2666: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
2667:
2668: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
2669: -- Moved this to instruction level (Bug 5526640)
2670: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
2671: p_instruction_id,
2672: l_docErrorTab,

Line 2670: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

2666: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
2667:
2668: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
2669: -- Moved this to instruction level (Bug 5526640)
2670: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
2671: p_instruction_id,
2672: l_docErrorTab,
2673: l_docErrorRec,
2674: l_valid,

Line 2689: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

2685: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
2686: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
2687: EXIT WHEN iby_pmt_csr%NOTFOUND;
2688:
2689: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
2690: l_iby_pmt_rec.payment_id,
2691: l_docErrorTab,
2692: l_docErrorRec,
2693: l_valid,

Line 2703: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS

2699: x_result:=1;
2700: RETURN;
2701: END IF;
2702:
2703: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
2704: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
2705: l_org_id,
2706: l_docErrorTab,
2707: l_docErrorRec,

Line 2704: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,

2700: RETURN;
2701: END IF;
2702:
2703: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
2704: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
2705: l_org_id,
2706: l_docErrorTab,
2707: l_docErrorRec,
2708: l_valid,

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

2714: RETURN;
2715: END IF;
2716:
2717:
2718: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
2719: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
2720: l_iby_pmt_rec.payment_instruction_id,
2721: l_iby_pmt_rec.payment_amount,
2722: l_docErrorTab,

Line 2719: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,

2715: END IF;
2716:
2717:
2718: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
2719: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
2720: l_iby_pmt_rec.payment_instruction_id,
2721: l_iby_pmt_rec.payment_amount,
2722: l_docErrorTab,
2723: l_docErrorRec,

Line 2741: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

2737: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
2738: EXIT WHEN iby_docs_csr%NOTFOUND;
2739:
2740: -- validate internal bank account parameters
2741: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
2742: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
2743: l_iby_pmt_rec.int_bank_account_name,
2744: l_docErrorTab,
2745: l_docErrorRec,

Line 2758: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,

2754: END IF;
2755:
2756: -- validate external bank account parameters
2757: -- validate external bank account id
2758: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,
2759: l_iby_pmt_rec.external_bank_account_id,
2760: l_docErrorTab,
2761: l_docErrorRec,
2762: l_valid,

Line 2772: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,

2768: RETURN;
2769: END IF;
2770:
2771:
2772: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,
2773: l_iby_pmt_rec.ext_bank_account_type,
2774: l_iby_pmt_rec.ext_bank_account_name,
2775: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
2776: l_docErrorTab,

Line 2789: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,

2785: RETURN;
2786: END IF;
2787:
2788:
2789: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,
2790: l_iby_pmt_rec.ext_bank_account_number,
2791: l_docErrorTab,
2792: l_docErrorRec,
2793: l_valid,

Line 2805: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,

2801: END IF;
2802:
2803:
2804:
2805: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,
2806: l_iby_pmt_rec.ext_branch_number,
2807: l_docErrorTab,
2808: l_docErrorRec,
2809: l_valid,

Line 2820: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,

2816: RETURN;
2817: END IF;
2818:
2819:
2820: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,
2821: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
2822: l_docErrorTab,
2823: l_docErrorRec,
2824: l_valid,

Line 2834: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

2830: RETURN;
2831: END IF;
2832:
2833:
2834: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
2835: p_instruction_id,
2836: l_iby_pmt_rec.payment_id,
2837: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
2838: l_docErrorTab,

Line 2851: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

2847: END IF;
2848:
2849:
2850:
2851: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
2852: l_iby_pmt_rec.payee_le_registration_num,
2853: l_iby_pmt_rec.payee_party_id,
2854: l_docErrorTab,
2855: l_docErrorRec,

Line 2874: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

2870:
2871: END LOOP;-- End Of Payments Cursor Loop
2872: CLOSE iby_pmt_csr; -- Closing Payments Cursor
2873:
2874: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
2875: p_instruction_id,
2876: l_docErrorTab,
2877: l_docErrorRec,
2878: l_valid,

Line 2888: IBY_PAYMENT_FORMAT_VAL_PVT.MANDATORY_PPD_PPDP_REASON_CODE(l_format_name,

2884: x_result:=1;
2885: RETURN;
2886: END IF;
2887:
2888: IBY_PAYMENT_FORMAT_VAL_PVT.MANDATORY_PPD_PPDP_REASON_CODE(l_format_name,
2889: l_pay_instr_rec.payment_reason_code,
2890: l_docErrorTab,
2891: l_docErrorRec,
2892: l_valid,

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

2912: l_docErrorRec.transaction_error_id := null;
2913: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
2914: l_docErrorRec.error_message := SQLERRM;
2915: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2916: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
2917: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2918:
2919:
2920: END FVTPPPD;-- End of Procedure FVTPPPD

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

3014:
3015: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3016:
3017:
3018: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
3019: -- Moved this to instruction level (Bug 5526640)
3020: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
3021: p_instruction_id,
3022: l_docErrorTab,

Line 3020: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

3016:
3017:
3018: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
3019: -- Moved this to instruction level (Bug 5526640)
3020: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
3021: p_instruction_id,
3022: l_docErrorTab,
3023: l_docErrorRec,
3024: l_valid,

Line 3041: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

3037: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
3038: EXIT WHEN iby_pmt_csr%NOTFOUND;
3039:
3040:
3041: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
3042: l_iby_pmt_rec.payment_id,
3043: l_docErrorTab,
3044: l_docErrorRec,
3045: l_valid,

Line 3055: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS

3051: x_result:=1;
3052: RETURN;
3053: END IF;
3054:
3055: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
3056: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
3057: l_org_id,
3058: l_docErrorTab,
3059: l_docErrorRec,

Line 3056: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,

3052: RETURN;
3053: END IF;
3054:
3055: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS
3056: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_ADDRESS(l_format_name,
3057: l_org_id,
3058: l_docErrorTab,
3059: l_docErrorRec,
3060: l_valid,

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

3065: x_result:=1;
3066: RETURN;
3067: END IF;
3068:
3069: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
3070: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
3071: l_iby_pmt_rec.payment_instruction_id,
3072: l_iby_pmt_rec.payment_amount,
3073: l_docErrorTab,

Line 3070: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,

3066: RETURN;
3067: END IF;
3068:
3069: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
3070: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
3071: l_iby_pmt_rec.payment_instruction_id,
3072: l_iby_pmt_rec.payment_amount,
3073: l_docErrorTab,
3074: l_docErrorRec,

Line 3091: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

3087: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
3088: EXIT WHEN iby_docs_csr%NOTFOUND;
3089:
3090: -- validate internal bank account parameters
3091: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
3092: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
3093: l_iby_pmt_rec.int_bank_account_name,
3094: l_docErrorTab,
3095: l_docErrorRec,

Line 3108: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,

3104: END IF;
3105:
3106: -- validate external bank account parameters
3107: -- validate external bank account id
3108: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,
3109: l_iby_pmt_rec.external_bank_account_id,
3110: l_docErrorTab,
3111: l_docErrorRec,
3112: l_valid,

Line 3122: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,

3118: RETURN;
3119: END IF;
3120:
3121:
3122: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,
3123: l_iby_pmt_rec.ext_bank_account_type,
3124: l_iby_pmt_rec.ext_bank_account_name,
3125: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
3126: l_docErrorTab,

Line 3137: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,

3133: x_result:=1;
3134: RETURN;
3135: END IF;
3136:
3137: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,
3138: l_iby_pmt_rec.ext_bank_account_number,
3139: l_docErrorTab,
3140: l_docErrorRec,
3141: l_valid,

Line 3151: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,

3147: x_result:=1;
3148: RETURN;
3149: END IF;
3150:
3151: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,
3152: l_iby_pmt_rec.ext_branch_number,
3153: l_docErrorTab,
3154: l_docErrorRec,
3155: l_valid,

Line 3167: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,

3163: END IF;
3164:
3165:
3166:
3167: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,
3168: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
3169: l_docErrorTab,
3170: l_docErrorRec,
3171: l_valid,

Line 3181: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

3177: RETURN;
3178: END IF;
3179:
3180:
3181: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
3182: p_instruction_id,
3183: l_iby_pmt_rec.payment_id,
3184: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
3185: l_docErrorTab,

Line 3198: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

3194: END IF;
3195:
3196:
3197:
3198: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
3199: l_iby_pmt_rec.payee_le_registration_num,
3200: l_iby_pmt_rec.payee_party_id,
3201: l_docErrorTab,
3202: l_docErrorRec,

Line 3221: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

3217:
3218: END LOOP;-- End Of Payments Cursor Loop
3219: CLOSE iby_pmt_csr; -- Closing Payments Cursor
3220:
3221: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
3222: p_instruction_id,
3223: l_docErrorTab,
3224: l_docErrorRec,
3225: l_valid,

Line 3235: IBY_PAYMENT_FORMAT_VAL_PVT.MANDATORY_PPD_PPDP_REASON_CODE(l_format_name,

3231: x_result:=1;
3232: RETURN;
3233: END IF;
3234:
3235: IBY_PAYMENT_FORMAT_VAL_PVT.MANDATORY_PPD_PPDP_REASON_CODE(l_format_name,
3236: l_pay_instr_rec.payment_reason_code,
3237: l_docErrorTab,
3238: l_docErrorRec,
3239: l_valid,

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

3257: l_docErrorRec.transaction_error_id := null;
3258: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
3259: l_docErrorRec.error_message := SQLERRM;
3260: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3261: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
3262: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3263:
3264:
3265: END FVTPPPDP;-- End of Procedure FVTPPPDP

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

3357: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
3358:
3359: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3360:
3361: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
3362: -- Moved this to instruction level (Bug 5526640)
3363: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
3364: p_instruction_id,
3365: l_docErrorTab,

Line 3363: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

3359: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3360:
3361: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
3362: -- Moved this to instruction level (Bug 5526640)
3363: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
3364: p_instruction_id,
3365: l_docErrorTab,
3366: l_docErrorRec,
3367: l_valid,

Line 3389: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

3385: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
3386: EXIT WHEN iby_docs_csr%NOTFOUND;
3387:
3388: -- validate internal bank account parameters
3389: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
3390: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
3391: l_iby_pmt_rec.int_bank_account_name,
3392: l_docErrorTab,
3393: l_docErrorRec,

Line 3405: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,

3401: END IF;
3402:
3403: -- validate external bank account parameters
3404: -- validate external bank account id
3405: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,
3406: l_iby_pmt_rec.external_bank_account_id,
3407: l_docErrorTab,
3408: l_docErrorRec,
3409: l_valid,

Line 3419: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,

3415: RETURN;
3416: END IF;
3417:
3418:
3419: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,
3420: l_iby_pmt_rec.ext_bank_account_type,
3421: l_iby_pmt_rec.ext_bank_account_name,
3422: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
3423: l_docErrorTab,

Line 3434: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,

3430: x_result:=1;
3431: RETURN;
3432: END IF;
3433:
3434: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,
3435: l_iby_pmt_rec.ext_bank_account_number,
3436: l_docErrorTab,
3437: l_docErrorRec,
3438: l_valid,

Line 3448: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,

3444: x_result:=1;
3445: RETURN;
3446: END IF;
3447:
3448: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,
3449: l_iby_pmt_rec.ext_branch_number,
3450: l_docErrorTab,
3451: l_docErrorRec,
3452: l_valid,

Line 3462: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,

3458: x_result:=1;
3459: RETURN;
3460: END IF;
3461:
3462: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,
3463: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
3464: l_docErrorTab,
3465: l_docErrorRec,
3466: l_valid,

Line 3476: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

3472: RETURN;
3473: END IF;
3474:
3475:
3476: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
3477: p_instruction_id,
3478: l_iby_pmt_rec.payment_id,
3479: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
3480: l_docErrorTab,

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

3487: x_result:=1;
3488: RETURN;
3489: END IF;
3490:
3491: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS
3492:
3493:
3494:
3495: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

Line 3495: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

3491: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS
3492:
3493:
3494:
3495: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
3496: l_iby_pmt_rec.payee_le_registration_num,
3497: l_iby_pmt_rec.payee_party_id,
3498: l_docErrorTab,
3499: l_docErrorRec,

Line 3518: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,

3514:
3515: END LOOP;-- End Of Payments Cursor Loop
3516: CLOSE iby_pmt_csr; -- Closing Payments Cursor
3517:
3518: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,
3519: p_instruction_id,
3520: l_docErrorTab,
3521: l_docErrorRec,
3522: l_valid,

Line 3532: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

3528: x_result:=1;
3529: RETURN;
3530: END IF;
3531:
3532: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
3533: p_instruction_id,
3534: l_docErrorTab,
3535: l_docErrorRec,
3536: l_valid,

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

3556: l_docErrorRec.transaction_error_id := null;
3557: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
3558: l_docErrorRec.error_message := SQLERRM;
3559: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3560: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
3561: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3562:
3563:
3564: END FVSPCCD;-- End of Procedure FVSPCCD

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

3656: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
3657:
3658: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3659:
3660: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
3661: -- Moved this to instruction level (Bug 5526640)
3662: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
3663: p_instruction_id,
3664: l_docErrorTab,

Line 3662: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

3658: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3659:
3660: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
3661: -- Moved this to instruction level (Bug 5526640)
3662: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
3663: p_instruction_id,
3664: l_docErrorTab,
3665: l_docErrorRec,
3666: l_valid,

Line 3687: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

3683: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
3684: EXIT WHEN iby_docs_csr%NOTFOUND;
3685:
3686: -- validate internal bank account parameters
3687: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
3688: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
3689: l_iby_pmt_rec.int_bank_account_name,
3690: l_docErrorTab,
3691: l_docErrorRec,

Line 3704: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,

3700:
3701:
3702: -- validate external bank account parameters
3703: -- validate external bank account id
3704: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,
3705: l_iby_pmt_rec.external_bank_account_id,
3706: l_docErrorTab,
3707: l_docErrorRec,
3708: l_valid,

Line 3718: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,

3714: RETURN;
3715: END IF;
3716:
3717:
3718: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,
3719: l_iby_pmt_rec.ext_bank_account_type,
3720: l_iby_pmt_rec.ext_bank_account_name,
3721: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
3722: l_docErrorTab,

Line 3733: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,

3729: x_result:=1;
3730: RETURN;
3731: END IF;
3732:
3733: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,
3734: l_iby_pmt_rec.ext_bank_account_number,
3735: l_docErrorTab,
3736: l_docErrorRec,
3737: l_valid,

Line 3747: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,

3743: x_result:=1;
3744: RETURN;
3745: END IF;
3746:
3747: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,
3748: l_iby_pmt_rec.ext_branch_number,
3749: l_docErrorTab,
3750: l_docErrorRec,
3751: l_valid,

Line 3762: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,

3758: RETURN;
3759: END IF;
3760:
3761:
3762: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,
3763: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
3764: l_docErrorTab,
3765: l_docErrorRec,
3766: l_valid,

Line 3775: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

3771: x_result:=1;
3772: RETURN;
3773: END IF;
3774:
3775: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
3776: p_instruction_id,
3777: l_iby_pmt_rec.payment_id,
3778: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
3779: l_docErrorTab,

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

3786: x_result:=1;
3787: RETURN;
3788: END IF;
3789:
3790: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS
3791:
3792:
3793:
3794: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

Line 3794: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

3790: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS
3791:
3792:
3793:
3794: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
3795: l_iby_pmt_rec.payee_le_registration_num,
3796: l_iby_pmt_rec.payee_party_id,
3797: l_docErrorTab,
3798: l_docErrorRec,

Line 3818: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,

3814:
3815: END LOOP;-- End Of Payments Cursor Loop
3816: CLOSE iby_pmt_csr; -- Closing Payments Cursor
3817:
3818: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,
3819: p_instruction_id,
3820: l_docErrorTab,
3821: l_docErrorRec,
3822: l_valid,

Line 3833: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

3829: RETURN;
3830: END IF;
3831:
3832:
3833: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
3834: p_instruction_id,
3835: l_docErrorTab,
3836: l_docErrorRec,
3837: l_valid,

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

3858: l_docErrorRec.transaction_error_id := null;
3859: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
3860: l_docErrorRec.error_message := SQLERRM;
3861: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3862: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
3863: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3864:
3865:
3866: END FVSPCCDP;-- End of Procedure FVSPCCDP

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

3953: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
3954:
3955: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3956:
3957: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
3958: -- Moved this to instruction level (Bug 5526640)
3959: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
3960: p_instruction_id,
3961: l_docErrorTab,

Line 3959: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

3955: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3956:
3957: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
3958: -- Moved this to instruction level (Bug 5526640)
3959: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
3960: p_instruction_id,
3961: l_docErrorTab,
3962: l_docErrorRec,
3963: l_valid,

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

3974: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
3975: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
3976: EXIT WHEN iby_pmt_csr%NOTFOUND;
3977:
3978: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT at Payment Level
3979: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT(l_format_name,
3980: l_iby_pmt_rec.payment_instruction_id,
3981: l_iby_pmt_rec.payment_amount,
3982: l_docErrorTab,

Line 3979: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT(l_format_name,

3975: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
3976: EXIT WHEN iby_pmt_csr%NOTFOUND;
3977:
3978: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT at Payment Level
3979: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT(l_format_name,
3980: l_iby_pmt_rec.payment_instruction_id,
3981: l_iby_pmt_rec.payment_amount,
3982: l_docErrorTab,
3983: l_docErrorRec,

Line 3994: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS

3990: RETURN;
3991: END IF;
3992:
3993:
3994: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS
3995: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS(l_format_name,
3996: l_iby_pmt_rec.payment_id,
3997: l_docErrorTab,
3998: l_docErrorRec,

Line 3995: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS(l_format_name,

3991: END IF;
3992:
3993:
3994: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS
3995: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_ADDRESS(l_format_name,
3996: l_iby_pmt_rec.payment_id,
3997: l_docErrorTab,
3998: l_docErrorRec,
3999: l_valid,

Line 4018: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

4014: EXIT WHEN iby_docs_csr%NOTFOUND;
4015:
4016:
4017: -- validate internal bank account parameters
4018: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
4019: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
4020: l_iby_pmt_rec.int_bank_account_name,
4021: l_docErrorTab,
4022: l_docErrorRec,

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

4030: END IF;
4031:
4032:
4033:
4034: -- Do Validation by IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT at Instruction Level
4035: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT(l_format_name,
4036: l_iby_pmt_rec.payment_id,
4037: to_number(l_iby_docs_rec.calling_app_doc_unique_ref2),
4038: l_docErrorTab,

Line 4035: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT(l_format_name,

4031:
4032:
4033:
4034: -- Do Validation by IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT at Instruction Level
4035: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_TAX_BENEFIT(l_format_name,
4036: l_iby_pmt_rec.payment_id,
4037: to_number(l_iby_docs_rec.calling_app_doc_unique_ref2),
4038: l_docErrorTab,
4039: l_docErrorRec,

Line 4049: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

4045: x_result:=1;
4046: RETURN;
4047: END IF;
4048:
4049: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
4050: p_instruction_id,
4051: l_iby_pmt_rec.payment_id,
4052: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
4053: l_docErrorTab,

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

4060: x_result:=1;
4061: RETURN;
4062: END IF;
4063:
4064: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS
4065:
4066:
4067: END LOOP;-- End Of Documents Cursor Loop
4068: CLOSE iby_docs_csr;-- Closing Payable Documents Cursor

Line 4075: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,

4071: CLOSE iby_pmt_csr; -- Closing Payments Cursor
4072:
4073:
4074:
4075: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,
4076: p_instruction_id,
4077: l_docErrorTab,
4078: l_docErrorRec,
4079: l_valid,

Line 4089: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

4085: x_result:=1;
4086: RETURN;
4087: END IF;
4088:
4089: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
4090: p_instruction_id,
4091: l_docErrorTab,
4092: l_docErrorRec,
4093: l_valid,

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

4111: l_docErrorRec.transaction_error_id := null;
4112: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
4113: l_docErrorRec.error_message := SQLERRM;
4114: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4115: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
4116: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4117:
4118:
4119: END FVSPNCR;-- End of Procedure FVSPNCR

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

4211: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
4212:
4213: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
4214:
4215: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
4216: -- Moved this to instruction level (Bug 5526640)
4217: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
4218: p_instruction_id,
4219: l_docErrorTab,

Line 4217: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

4213: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
4214:
4215: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
4216: -- Moved this to instruction level (Bug 5526640)
4217: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
4218: p_instruction_id,
4219: l_docErrorTab,
4220: l_docErrorRec,
4221: l_valid,

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

4232: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
4233: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
4234: EXIT WHEN iby_pmt_csr%NOTFOUND;
4235:
4236: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
4237: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
4238: l_iby_pmt_rec.payment_instruction_id,
4239: l_iby_pmt_rec.payment_amount,
4240: l_docErrorTab,

Line 4237: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,

4233: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
4234: EXIT WHEN iby_pmt_csr%NOTFOUND;
4235:
4236: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
4237: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
4238: l_iby_pmt_rec.payment_instruction_id,
4239: l_iby_pmt_rec.payment_amount,
4240: l_docErrorTab,
4241: l_docErrorRec,

Line 4258: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

4254: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
4255: EXIT WHEN iby_docs_csr%NOTFOUND;
4256:
4257: -- validate internal bank account parameters
4258: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
4259: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
4260: l_iby_pmt_rec.int_bank_account_name,
4261: l_docErrorTab,
4262: l_docErrorRec,

Line 4274: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,

4270: END IF;
4271:
4272: -- validate external bank account parameters
4273: -- validate external bank account id
4274: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,
4275: l_iby_pmt_rec.external_bank_account_id,
4276: l_docErrorTab,
4277: l_docErrorRec,
4278: l_valid,

Line 4288: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,

4284: RETURN;
4285: END IF;
4286:
4287:
4288: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,
4289: l_iby_pmt_rec.ext_bank_account_type,
4290: l_iby_pmt_rec.ext_bank_account_name,
4291: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
4292: l_docErrorTab,

Line 4303: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,

4299: x_result:=1;
4300: RETURN;
4301: END IF;
4302:
4303: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,
4304: l_iby_pmt_rec.ext_bank_account_number,
4305: l_docErrorTab,
4306: l_docErrorRec,
4307: l_valid,

Line 4317: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,

4313: x_result:=1;
4314: RETURN;
4315: END IF;
4316:
4317: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,
4318: l_iby_pmt_rec.ext_branch_number,
4319: l_docErrorTab,
4320: l_docErrorRec,
4321: l_valid,

Line 4332: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,

4328: RETURN;
4329: END IF;
4330:
4331:
4332: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,
4333: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
4334: l_docErrorTab,
4335: l_docErrorRec,
4336: l_valid,

Line 4345: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

4341: x_result:=1;
4342: RETURN;
4343: END IF;
4344:
4345: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
4346: p_instruction_id,
4347: l_iby_pmt_rec.payment_id,
4348: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
4349: l_docErrorTab,

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

4356: x_result:=1;
4357: RETURN;
4358: END IF;
4359:
4360: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS
4361:
4362:
4363:
4364: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

Line 4364: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

4360: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS
4361:
4362:
4363:
4364: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
4365: l_iby_pmt_rec.payee_le_registration_num,
4366: l_iby_pmt_rec.payee_party_id,
4367: l_docErrorTab,
4368: l_docErrorRec,

Line 4385: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,

4381:
4382: END LOOP;-- End Of Payments Cursor Loop
4383: CLOSE iby_pmt_csr; -- Closing Payments Cursor
4384:
4385: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,
4386: p_instruction_id,
4387: l_docErrorTab,
4388: l_docErrorRec,
4389: l_valid,

Line 4399: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

4395: x_result:=1;
4396: RETURN;
4397: END IF;
4398:
4399: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
4400: p_instruction_id,
4401: l_docErrorTab,
4402: l_docErrorRec,
4403: l_valid,

Line 4413: IBY_PAYMENT_FORMAT_VAL_PVT.MANDATORY_PPD_PPDP_REASON_CODE(l_format_name,

4409: x_result:=1;
4410: RETURN;
4411: END IF;
4412:
4413: IBY_PAYMENT_FORMAT_VAL_PVT.MANDATORY_PPD_PPDP_REASON_CODE(l_format_name,
4414: l_pay_instr_rec.payment_reason_code,
4415: l_docErrorTab,
4416: l_docErrorRec,
4417: l_valid,

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

4436: l_docErrorRec.transaction_error_id := null;
4437: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
4438: l_docErrorRec.error_message := SQLERRM;
4439: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4440: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
4441: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4442:
4443:
4444: END FVSPPPD;-- End of Procedure FVSPPPD

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

4536: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
4537:
4538: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
4539:
4540: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
4541: -- Moved this to instruction level (Bug 5526640)
4542: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
4543: p_instruction_id,
4544: l_docErrorTab,

Line 4542: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,

4538: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
4539:
4540: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level
4541: -- Moved this to instruction level (Bug 5526640)
4542: IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE(l_format_name,
4543: p_instruction_id,
4544: l_docErrorTab,
4545: l_docErrorRec,
4546: l_valid,

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

4557: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
4558: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
4559: EXIT WHEN iby_pmt_csr%NOTFOUND;
4560:
4561: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
4562: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
4563: l_iby_pmt_rec.payment_instruction_id,
4564: l_iby_pmt_rec.payment_amount,
4565: l_docErrorTab,

Line 4562: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,

4558: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
4559: EXIT WHEN iby_pmt_csr%NOTFOUND;
4560:
4561: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
4562: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2(l_format_name,
4563: l_iby_pmt_rec.payment_instruction_id,
4564: l_iby_pmt_rec.payment_amount,
4565: l_docErrorTab,
4566: l_docErrorRec,

Line 4583: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,

4579: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
4580: EXIT WHEN iby_docs_csr%NOTFOUND;
4581:
4582: -- validate internal bank account parameters
4583: IBY_PAYMENT_FORMAT_VAL_PVT.AGENCY_LOCATION_CODE(l_format_name,
4584: l_iby_pmt_rec.int_bank_acct_agency_loc_code,
4585: l_iby_pmt_rec.int_bank_account_name,
4586: l_docErrorTab,
4587: l_docErrorRec,

Line 4600: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,

4596: END IF;
4597:
4598: -- validate external bank account parameters
4599: -- validate external bank account id
4600: IBY_PAYMENT_FORMAT_VAL_PVT.EXTERNAL_BANK_ACCOUNT_ID(l_format_name,
4601: l_iby_pmt_rec.external_bank_account_id,
4602: l_docErrorTab,
4603: l_docErrorRec,
4604: l_valid,

Line 4614: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,

4610: RETURN;
4611: END IF;
4612:
4613:
4614: IBY_PAYMENT_FORMAT_VAL_PVT.ACCOUNT_TYPE(l_format_name,
4615: l_iby_pmt_rec.ext_bank_account_type,
4616: l_iby_pmt_rec.ext_bank_account_name,
4617: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
4618: l_docErrorTab,

Line 4629: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,

4625: x_result:=1;
4626: RETURN;
4627: END IF;
4628:
4629: IBY_PAYMENT_FORMAT_VAL_PVT.DEPOSITER_ACC_NUM(l_format_name,
4630: l_iby_pmt_rec.ext_bank_account_number,
4631: l_docErrorTab,
4632: l_docErrorRec,
4633: l_valid,

Line 4643: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,

4639: x_result:=1;
4640: RETURN;
4641: END IF;
4642:
4643: IBY_PAYMENT_FORMAT_VAL_PVT.RTN_NUMBER(l_format_name,
4644: l_iby_pmt_rec.ext_branch_number,
4645: l_docErrorTab,
4646: l_docErrorRec,
4647: l_valid,

Line 4658: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,

4654: RETURN;
4655: END IF;
4656:
4657:
4658: IBY_PAYMENT_FORMAT_VAL_PVT.PAY_ALONE_OPTION(l_format_name,
4659: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
4660: l_docErrorTab,
4661: l_docErrorRec,
4662: l_valid,

Line 4672: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,

4668: RETURN;
4669: END IF;
4670:
4671:
4672: IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS(l_format_name,
4673: p_instruction_id,
4674: l_iby_pmt_rec.payment_id,
4675: TO_NUMBER(l_iby_docs_rec.calling_app_doc_unique_ref2),
4676: l_docErrorTab,

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

4683: x_result:=1;
4684: RETURN;
4685: END IF;
4686:
4687: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS
4688:
4689:
4690:
4691: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

Line 4691: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,

4687: --IBY_PAYMENT_FORMAT_VAL_PVT.TAS_VALIDATION Is Directly Called From IBY_PAYMENT_FORMAT_VAL_PVT.TREASURY_SYMBOLS_PROCESS
4688:
4689:
4690:
4691: IBY_PAYMENT_FORMAT_VAL_PVT.PAYEE_SSN(l_format_name,
4692: l_iby_pmt_rec.payee_le_registration_num,
4693: l_iby_pmt_rec.payee_party_id,
4694: l_docErrorTab,
4695: l_docErrorRec,

Line 4713: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,

4709:
4710: END LOOP;-- End Of Payments Cursor Loop
4711: CLOSE iby_pmt_csr; -- Closing Payments Cursor
4712:
4713: IBY_PAYMENT_FORMAT_VAL_PVT.MAX_TREASURY_SYMBOLS(l_format_name,
4714: p_instruction_id,
4715: l_docErrorTab,
4716: l_docErrorRec,
4717: l_valid,

Line 4727: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,

4723: x_result:=1;
4724: RETURN;
4725: END IF;
4726:
4727: IBY_PAYMENT_FORMAT_VAL_PVT.SCHEDULE_NUMBER(l_format_name,
4728: p_instruction_id,
4729: l_docErrorTab,
4730: l_docErrorRec,
4731: l_valid,

Line 4741: IBY_PAYMENT_FORMAT_VAL_PVT.MANDATORY_PPD_PPDP_REASON_CODE(l_format_name,

4737: x_result:=1;
4738: RETURN;
4739: END IF;
4740:
4741: IBY_PAYMENT_FORMAT_VAL_PVT.MANDATORY_PPD_PPDP_REASON_CODE(l_format_name,
4742: l_pay_instr_rec.payment_reason_code,
4743: l_docErrorTab,
4744: l_docErrorRec,
4745: l_valid,

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

4764: l_docErrorRec.transaction_error_id := null;
4765: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
4766: l_docErrorRec.error_message := SQLERRM;
4767: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4768: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
4769: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4770:
4771:
4772: END FVSPPPDP;-- End of Procedure FVSPPPDP

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

4778: ----------------------------------------------------------------------------------------------------------
4779:
4780: -- Initialising Global Variables
4781: BEGIN
4782: g_FAILURE := -1; -- Corresponds To g_ERROR OF IBY_PAYMENT_FORMAT_VAL_PVT Package.
4783: g_EXCEPTION := -2; -- Corresponds To g_FAILURE OF IBY_PAYMENT_FORMAT_VAL_PVT Package.
4784: g_SUCCESS := 0;
4785:
4786: ----------------------------------------------------------------------------------------------------------

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

4779:
4780: -- Initialising Global Variables
4781: BEGIN
4782: g_FAILURE := -1; -- Corresponds To g_ERROR OF IBY_PAYMENT_FORMAT_VAL_PVT Package.
4783: g_EXCEPTION := -2; -- Corresponds To g_FAILURE OF IBY_PAYMENT_FORMAT_VAL_PVT Package.
4784: g_SUCCESS := 0;
4785:
4786: ----------------------------------------------------------------------------------------------------------
4787: