eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_PAYMENT_FORMAT_VAL_PVT dependencies on IBY_VALIDATIONSETS_PUB

Line 25: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

21: PROCEDURE SCHEDULE_NUMBER
22: (
23: p_format_name IN VARCHAR2,
24: p_pinstr_id IN NUMBER,
25: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
26: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
27: x_error_code OUT NOCOPY NUMBER,
28: x_error_mesg OUT NOCOPY VARCHAR2
29: ) IS

Line 78: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec,p_docErrorTab);

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

Line 97: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec,p_docErrorTab);

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

Line 111: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec,p_docErrorTab);

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

Line 130: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

126: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
127: p_docErrorRec.transaction_error_id := null;
128: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
129: p_docErrorRec.error_message := x_error_mesg;
130: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
131: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
132:
133: END SCHEDULE_NUMBER;
134:

Line 131: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

127: p_docErrorRec.transaction_error_id := null;
128: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
129: p_docErrorRec.error_message := x_error_mesg;
130: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
131: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
132:
133: END SCHEDULE_NUMBER;
134:
135: -------------------------------------------------------------------------------------------------------------------

Line 153: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

149: PROCEDURE SUPPLIER_TYPE
150: (
151: p_format_name IN VARCHAR2,
152: p_instruction_id IN NUMBER,
153: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
154: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
155: x_error_code OUT NOCOPY NUMBER,
156: x_error_mesg OUT NOCOPY VARCHAR2
157: )IS

Line 234: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

230: p_docErrorRec.transaction_error_id := null;
231: p_docErrorRec.error_code := 'INV_IS_EMPLOYEE';
232: p_docErrorRec.error_message := x_error_mesg;
233: x_error_code := g_ERROR;
234: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
235: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
236: END IF;
237:
238:

Line 270: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

266: p_docErrorRec.transaction_error_id := null;
267: p_docErrorRec.error_code := 'INV_IS_NOT_EMPLOYEE';
268: p_docErrorRec.error_message := x_error_mesg;
269: x_error_code := g_ERROR;
270: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
271: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
272: END IF;
273:
274:

Line 313: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 334: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

330: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
331: p_docErrorRec.transaction_error_id := null;
332: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
333: p_docErrorRec.error_message := x_error_mesg;
334: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
335: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
336:
337: END SUPPLIER_TYPE;
338:

Line 335: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

331: p_docErrorRec.transaction_error_id := null;
332: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
333: p_docErrorRec.error_message := x_error_mesg;
334: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
335: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
336:
337: END SUPPLIER_TYPE;
338:
339: -------------------------------------------------------------------------------------------------------------------

Line 356: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

352: p_format_name IN VARCHAR2,
353: p_instruction_id IN NUMBER,
354: p_payment_id IN NUMBER,
355: p_invoice_id IN NUMBER,
356: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
357: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
358: x_error_code OUT NOCOPY NUMBER,
359: x_error_mesg OUT NOCOPY VARCHAR2
360: )IS

Line 463: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

459: p_docErrorRec.transaction_error_id := null;
460: p_docErrorRec.error_code := 'NO_TREASURY_SYMBOL';
461: p_docErrorRec.error_message := x_error_mesg;
462: x_error_code := g_ERROR;
463: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
464: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
465:
466: ELSE
467: l_valid := g_SUCCESS; -- initialize l_valid

Line 558: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

554: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
555: p_docErrorRec.transaction_error_id := null;
556: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
557: p_docErrorRec.error_message := x_error_mesg;
558: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
559: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
560:
561: END TREASURY_SYMBOLS_PROCESS;
562:

Line 559: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

555: p_docErrorRec.transaction_error_id := null;
556: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
557: p_docErrorRec.error_message := x_error_mesg;
558: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
559: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
560:
561: END TREASURY_SYMBOLS_PROCESS;
562:
563: -------------------------------------------------------------------------------------------------------------------

Line 577: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

573: PROCEDURE MAX_TREASURY_SYMBOLS
574: (
575: p_format_name IN VARCHAR2,
576: p_instruction_id IN NUMBER,
577: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
578: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
579: x_error_code OUT NOCOPY NUMBER,
580: x_error_mesg OUT NOCOPY VARCHAR2
581: )IS

Line 611: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 629: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 643: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

639: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
640: p_docErrorRec.transaction_error_id := null;
641: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
642: p_docErrorRec.error_message := x_error_mesg;
643: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
644: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
645:
646: END MAX_TREASURY_SYMBOLS;
647:

Line 644: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

640: p_docErrorRec.transaction_error_id := null;
641: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
642: p_docErrorRec.error_message := x_error_mesg;
643: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
644: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
645:
646: END MAX_TREASURY_SYMBOLS;
647:
648: -------------------------------------------------------------------------------------------------------------------

Line 664: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

660: PROCEDURE AGENCY_ADDRESS
661: (
662: p_format_name IN VARCHAR2,
663: p_org_id IN NUMBER,
664: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
665: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
666: x_error_code OUT NOCOPY NUMBER,
667: x_error_mesg OUT NOCOPY VARCHAR2
668: )IS

Line 703: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 716: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

712: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
713: p_docErrorRec.transaction_error_id := null;
714: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
715: p_docErrorRec.error_message := x_error_mesg;
716: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
717: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
718:
719: END AGENCY_ADDRESS;
720:

Line 717: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

713: p_docErrorRec.transaction_error_id := null;
714: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
715: p_docErrorRec.error_message := x_error_mesg;
716: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
717: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
718:
719: END AGENCY_ADDRESS;
720:
721: -------------------------------------------------------------------------------------------------------------------

Line 737: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

733: PROCEDURE PAYEE_ADDRESS
734: (
735: p_format_name IN VARCHAR2,
736: p_payment_id IN NUMBER,
737: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
738: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
739: x_error_code OUT NOCOPY NUMBER,
740: x_error_mesg OUT NOCOPY VARCHAR2
741: )IS

Line 778: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 791: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

787: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
788: p_docErrorRec.transaction_error_id := null;
789: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
790: p_docErrorRec.error_message := x_error_mesg;
791: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
792: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
793:
794: END PAYEE_ADDRESS;
795:

Line 792: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

788: p_docErrorRec.transaction_error_id := null;
789: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
790: p_docErrorRec.error_message := x_error_mesg;
791: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
792: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
793:
794: END PAYEE_ADDRESS;
795:
796: -------------------------------------------------------------------------------------------------------------------

Line 811: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

807: (
808: p_format_name IN VARCHAR2,
809: p_instruction_id IN NUMBER,
810: p_payment_amount IN NUMBER,
811: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
812: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
813: x_error_code OUT NOCOPY NUMBER,
814: x_error_mesg OUT NOCOPY VARCHAR2
815: )IS

Line 832: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 844: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

840: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
841: p_docErrorRec.transaction_error_id := null;
842: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
843: p_docErrorRec.error_message := x_error_mesg;
844: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
845: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
846:
847: END MAX_PAYMENT_AMT;
848:

Line 845: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

841: p_docErrorRec.transaction_error_id := null;
842: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
843: p_docErrorRec.error_message := x_error_mesg;
844: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
845: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
846:
847: END MAX_PAYMENT_AMT;
848:
849: -------------------------------------------------------------------------------------------------------------------

Line 864: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

860: (
861: p_format_name IN VARCHAR2,
862: p_instruction_id IN NUMBER,
863: p_payment_amount IN NUMBER,
864: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
865: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
866: x_error_code OUT NOCOPY NUMBER,
867: x_error_mesg OUT NOCOPY VARCHAR2
868: )IS

Line 886: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 899: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

895: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
896: p_docErrorRec.transaction_error_id := null;
897: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
898: p_docErrorRec.error_message := x_error_mesg;
899: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
900: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
901:
902: END MAX_PAYMENT_AMT_2;
903:

Line 900: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

896: p_docErrorRec.transaction_error_id := null;
897: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
898: p_docErrorRec.error_message := x_error_mesg;
899: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
900: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
901:
902: END MAX_PAYMENT_AMT_2;
903:
904: -------------------------------------------------------------------------------------------------------------------

Line 919: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

915: (
916: p_format_name IN VARCHAR2,
917: p_payment_id IN NUMBER,
918: p_invoice_id IN NUMBER,
919: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
920: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
921: x_error_code OUT NOCOPY NUMBER,
922: x_error_mesg OUT NOCOPY VARCHAR2
923: )IS

Line 961: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

957: p_docErrorRec.transaction_error_id := null;
958: p_docErrorRec.error_code := 'INVALID_PAY_TAX_BENEFIT';
959: p_docErrorRec.error_message := x_error_mesg;
960: x_error_code := g_ERROR;
961: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
962: l_message := 'Invalid reason code for type of vendor, reason_code = ' || l_payment_reason_code || ', vendor_type_code = ' || l_vendor_type_lookup_code;
963: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
964: END IF;
965: ELSE -- vendor is of type organization

Line 972: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 986: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

982: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
983: p_docErrorRec.transaction_error_id := null;
984: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
985: p_docErrorRec.error_message := x_error_mesg;
986: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
987: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
988:
989:
990: END PAY_TAX_BENEFIT;

Line 987: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

983: p_docErrorRec.transaction_error_id := null;
984: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
985: p_docErrorRec.error_message := x_error_mesg;
986: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
987: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
988:
989:
990: END PAY_TAX_BENEFIT;
991:

Line 1006: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1002: PROCEDURE PAY_SALARY_TRAVEL
1003: (
1004: p_format_name IN VARCHAR2,
1005: p_reason_code IN VARCHAR2,
1006: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1007: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1008: x_error_code OUT NOCOPY NUMBER,
1009: x_error_mesg OUT NOCOPY VARCHAR2
1010: )IS

Line 1027: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 1039: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

1035: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1036: p_docErrorRec.transaction_error_id := null;
1037: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1038: p_docErrorRec.error_message := x_error_mesg;
1039: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1040: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1041:
1042:
1043: END PAY_SALARY_TRAVEL;

Line 1040: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

1036: p_docErrorRec.transaction_error_id := null;
1037: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1038: p_docErrorRec.error_message := x_error_mesg;
1039: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1040: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1041:
1042:
1043: END PAY_SALARY_TRAVEL;
1044:

Line 1062: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1058: (
1059: p_format_name IN VARCHAR2,
1060: p_ssn_tin IN VARCHAR2,
1061: p_payee_party_id IN VARCHAR2,
1062: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1063: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1064: x_error_code OUT NOCOPY NUMBER,
1065: x_error_mesg OUT NOCOPY VARCHAR2
1066: ) AS

Line 1096: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 1109: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

1105: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1106: p_docErrorRec.transaction_error_id := null;
1107: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1108: p_docErrorRec.error_message := x_error_mesg;
1109: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1110: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1111:
1112: END PAYEE_SSN;
1113:

Line 1110: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

1106: p_docErrorRec.transaction_error_id := null;
1107: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1108: p_docErrorRec.error_message := x_error_mesg;
1109: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1110: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1111:
1112: END PAYEE_SSN;
1113:
1114: -------------------------------------------------------------------------------------------------------------------

Line 1130: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1126: PROCEDURE TAS_VALIDATION
1127: (
1128: p_format_name IN VARCHAR2,
1129: p_treasury_symbol IN VARCHAR2,
1130: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1131: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1132: x_error_code OUT NOCOPY NUMBER,
1133: x_error_mesg OUT NOCOPY VARCHAR2
1134: )IS

Line 1159: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

1155: p_docErrorRec.transaction_error_id := null;
1156: p_docErrorRec.error_code := 'TREASURY_SYMBOL_LENGTH';
1157: p_docErrorRec.error_message := x_error_mesg;
1158: x_error_code := g_ERROR;
1159: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1160: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1161: ELSE
1162: l_char_string := 'ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890/.()';
1163:

Line 1176: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 1191: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

1187: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1188: p_docErrorRec.transaction_error_id := null;
1189: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1190: p_docErrorRec.error_message := x_error_mesg;
1191: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1192: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1193:
1194: END TAS_VALIDATION;
1195:

Line 1192: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

1188: p_docErrorRec.transaction_error_id := null;
1189: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1190: p_docErrorRec.error_message := x_error_mesg;
1191: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1192: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1193:
1194: END TAS_VALIDATION;
1195:
1196: -------------------------------------------------------------------------------------------------------------------

Line 1213: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1209: (
1210: p_format_name IN VARCHAR2,
1211: p_agency_location_code IN ce_bank_accounts.agency_location_code%TYPE,
1212: p_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,
1213: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1214: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1215: x_error_code OUT NOCOPY NUMBER,
1216: x_error_mesg OUT NOCOPY VARCHAR2
1217: )IS

Line 1235: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 1248: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

1244: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1245: p_docErrorRec.transaction_error_id := null;
1246: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1247: p_docErrorRec.error_message := x_error_mesg;
1248: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1249: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1250:
1251: END AGENCY_LOCATION_CODE;
1252:

Line 1249: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

1245: p_docErrorRec.transaction_error_id := null;
1246: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1247: p_docErrorRec.error_message := x_error_mesg;
1248: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1249: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1250:
1251: END AGENCY_LOCATION_CODE;
1252:
1253: -------------------------------------------------------------------------------------------------------------------

Line 1270: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1266: PROCEDURE RTN_NUMBER
1267: (
1268: p_format_name IN VARCHAR2,
1269: p_rtn_number IN VARCHAR2,
1270: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1271: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1272: x_error_code OUT NOCOPY NUMBER,
1273: x_error_mesg OUT NOCOPY VARCHAR2
1274: )IS

Line 1304: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 1376: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

1372: p_docErrorRec.transaction_error_id := null;
1373: p_docErrorRec.error_code := 'INVALID_RTN';
1374: p_docErrorRec.error_message := x_error_mesg;
1375: x_error_code := g_ERROR;
1376: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1377: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1378: END IF;
1379:
1380: ELSE

Line 1387: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 1400: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

1396: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1397: p_docErrorRec.transaction_error_id := null;
1398: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1399: p_docErrorRec.error_message := x_error_mesg;
1400: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1401: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1402:
1403: END RTN_NUMBER;
1404:

Line 1401: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

1397: p_docErrorRec.transaction_error_id := null;
1398: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1399: p_docErrorRec.error_message := x_error_mesg;
1400: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1401: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1402:
1403: END RTN_NUMBER;
1404:
1405: -------------------------------------------------------------------------------------------------------------------

Line 1422: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1418: PROCEDURE PAY_ALONE_OPTION
1419: (
1420: p_format_name IN VARCHAR2,
1421: p_invoice_id IN NUMBER,
1422: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1423: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1424: x_error_code OUT NOCOPY NUMBER,
1425: x_error_mesg OUT NOCOPY VARCHAR2
1426: )IS

Line 1458: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 1470: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

1466: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1467: p_docErrorRec.transaction_error_id := null;
1468: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1469: p_docErrorRec.error_message := x_error_mesg;
1470: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1471: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1472:
1473: END PAY_ALONE_OPTION;
1474:

Line 1471: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

1467: p_docErrorRec.transaction_error_id := null;
1468: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1469: p_docErrorRec.error_message := x_error_mesg;
1470: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1471: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1472:
1473: END PAY_ALONE_OPTION;
1474:
1475: -------------------------------------------------------------------------------------------------------------------

Line 1490: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1486: PROCEDURE DEPOSITER_ACC_NUM
1487: (
1488: p_format_name IN VARCHAR2,
1489: p_dep_account_no IN iby_ext_bank_accounts.bank_account_num%TYPE,
1490: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1491: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1492: x_error_code OUT NOCOPY NUMBER,
1493: x_error_mesg OUT NOCOPY VARCHAR2
1494: )IS

Line 1516: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 1535: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 1549: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

1545: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1546: p_docErrorRec.transaction_error_id := null;
1547: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1548: p_docErrorRec.error_message := x_error_mesg;
1549: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1550: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1551:
1552:
1553: END DEPOSITER_ACC_NUM;

Line 1550: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

1546: p_docErrorRec.transaction_error_id := null;
1547: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1548: p_docErrorRec.error_message := x_error_mesg;
1549: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1550: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1551:
1552:
1553: END DEPOSITER_ACC_NUM;
1554:

Line 1573: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1569: p_format_name IN VARCHAR2,
1570: p_bank_account_type IN iby_ext_bank_accounts.bank_account_type%TYPE,
1571: p_bank_account_name IN iby_ext_bank_accounts.bank_account_name%TYPE,
1572: p_invoice_id IN NUMBER,
1573: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1574: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1575: x_error_code OUT NOCOPY NUMBER,
1576: x_error_mesg OUT NOCOPY VARCHAR2
1577: )IS

Line 1604: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 1617: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

1613: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1614: p_docErrorRec.transaction_error_id := null;
1615: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1616: p_docErrorRec.error_message := x_error_mesg;
1617: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1618: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1619:
1620: END ACCOUNT_TYPE;
1621:

Line 1618: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

1614: p_docErrorRec.transaction_error_id := null;
1615: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1616: p_docErrorRec.error_message := x_error_mesg;
1617: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1618: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1619:
1620: END ACCOUNT_TYPE;
1621:
1622: -------------------------------------------------------------------------------------------------------------------

Line 1637: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1633: PROCEDURE RFC_ID
1634: (
1635: p_format_name IN VARCHAR2,
1636: p_payment_id IN NUMBER,
1637: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1638: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1639: x_error_code OUT NOCOPY NUMBER,
1640: x_error_mesg OUT NOCOPY VARCHAR2
1641: )IS

Line 1684: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 1698: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

1694: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1695: p_docErrorRec.transaction_error_id := null;
1696: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1697: p_docErrorRec.error_message := x_error_mesg;
1698: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1699: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1700:
1701: END RFC_ID;
1702:

Line 1699: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

1695: p_docErrorRec.transaction_error_id := null;
1696: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1697: p_docErrorRec.error_message := x_error_mesg;
1698: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1699: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1700:
1701: END RFC_ID;
1702:
1703:

Line 1730: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1726: PROCEDURE MANDATORY_PPD_PPDP_REASON_CODE
1727: (
1728: p_format_name IN VARCHAR2,
1729: p_reason_code IN VARCHAR2,
1730: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1731: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1732: x_error_code OUT NOCOPY NUMBER,
1733: x_error_mesg OUT NOCOPY VARCHAR2
1734: )IS

Line 1755: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 1768: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

1764: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1765: p_docErrorRec.transaction_error_id := null;
1766: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1767: p_docErrorRec.error_message := x_error_mesg;
1768: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1769: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1770:
1771: END MANDATORY_PPD_PPDP_REASON_CODE;
1772: -----------------------------------------------------------------------------------------------------------------

Line 1769: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

1765: p_docErrorRec.transaction_error_id := null;
1766: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1767: p_docErrorRec.error_message := x_error_mesg;
1768: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1769: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1770:
1771: END MANDATORY_PPD_PPDP_REASON_CODE;
1772: -----------------------------------------------------------------------------------------------------------------
1773: /*

Line 1788: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1784: PROCEDURE EXTERNAL_BANK_ACCOUNT_ID
1785: (
1786: p_format_name IN VARCHAR2,
1787: p_external_bank_account_id IN NUMBER,
1788: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1789: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1790: x_error_code OUT NOCOPY NUMBER,
1791: x_error_mesg OUT NOCOPY VARCHAR2
1792: )IS

Line 1813: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 1826: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

1822: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1823: p_docErrorRec.transaction_error_id := null;
1824: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1825: p_docErrorRec.error_message := x_error_mesg;
1826: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1827: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1828:
1829: END EXTERNAL_BANK_ACCOUNT_ID;
1830: -----------------------------------------------------------------------------------------------------------------

Line 1827: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

1823: p_docErrorRec.transaction_error_id := null;
1824: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1825: p_docErrorRec.error_message := x_error_mesg;
1826: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1827: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1828:
1829: END EXTERNAL_BANK_ACCOUNT_ID;
1830: -----------------------------------------------------------------------------------------------------------------
1831: PROCEDURE FEDERAL_ID_NUMBER

Line 1835: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1831: PROCEDURE FEDERAL_ID_NUMBER
1832: (
1833: p_format_name IN VARCHAR2,
1834: p_pay_instruction_id IN NUMBER,
1835: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1836: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1837: x_error_code OUT NOCOPY NUMBER,
1838: x_error_mesg OUT NOCOPY VARCHAR2
1839: )IS

Line 1874: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 1887: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 1897: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

1893: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1894: p_docErrorRec.transaction_error_id := null;
1895: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1896: p_docErrorRec.error_message := x_error_mesg;
1897: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1898: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1899:
1900: END FEDERAL_ID_NUMBER;
1901:

Line 1898: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

1894: p_docErrorRec.transaction_error_id := null;
1895: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1896: p_docErrorRec.error_message := x_error_mesg;
1897: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1898: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1899:
1900: END FEDERAL_ID_NUMBER;
1901:
1902: ------------------------------------------------------------------------------------------------------------------

Line 1907: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1903: PROCEDURE AGENCY_ID_ABBREVIATION
1904: (
1905: p_format_name IN VARCHAR2,
1906: p_instruction_id IN NUMBER,
1907: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1908: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1909: x_error_code OUT NOCOPY NUMBER,
1910: x_error_mesg OUT NOCOPY VARCHAR2
1911: )IS

Line 1932: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

Line 1948: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

1944: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1945: p_docErrorRec.transaction_error_id := null;
1946: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1947: p_docErrorRec.error_message := x_error_mesg;
1948: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1949: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1950:
1951: END AGENCY_ID_ABBREVIATION;
1952:

Line 1949: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

1945: p_docErrorRec.transaction_error_id := null;
1946: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1947: p_docErrorRec.error_message := x_error_mesg;
1948: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1949: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1950:
1951: END AGENCY_ID_ABBREVIATION;
1952:
1953: