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 236: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

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

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

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

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

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

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

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

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

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

Line 358: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

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

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

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

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

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

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

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

Line 579: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

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

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

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

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

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

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

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

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

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

Line 666: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

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

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

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

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

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

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

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

Line 739: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

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

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

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

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

791: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
792: p_docErrorRec.transaction_error_id := null;
793: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
794: p_docErrorRec.error_message := x_error_mesg;
795: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
796: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
797:
798: END PAYEE_ADDRESS;
799:

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

792: p_docErrorRec.transaction_error_id := null;
793: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
794: p_docErrorRec.error_message := x_error_mesg;
795: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
796: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
797:
798: END PAYEE_ADDRESS;
799:
800: -------------------------------------------------------------------------------------------------------------------

Line 815: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

811: (
812: p_format_name IN VARCHAR2,
813: p_instruction_id IN NUMBER,
814: p_payment_amount IN NUMBER,
815: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
816: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
817: x_error_code OUT NOCOPY NUMBER,
818: x_error_mesg OUT NOCOPY VARCHAR2
819: )IS

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

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

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

844: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
845: p_docErrorRec.transaction_error_id := null;
846: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
847: p_docErrorRec.error_message := x_error_mesg;
848: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
849: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
850:
851: END MAX_PAYMENT_AMT;
852:

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

845: p_docErrorRec.transaction_error_id := null;
846: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
847: p_docErrorRec.error_message := x_error_mesg;
848: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
849: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
850:
851: END MAX_PAYMENT_AMT;
852:
853: -------------------------------------------------------------------------------------------------------------------

Line 868: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

864: (
865: p_format_name IN VARCHAR2,
866: p_instruction_id IN NUMBER,
867: p_payment_amount IN NUMBER,
868: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
869: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
870: x_error_code OUT NOCOPY NUMBER,
871: x_error_mesg OUT NOCOPY VARCHAR2
872: )IS

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

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

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

899: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
900: p_docErrorRec.transaction_error_id := null;
901: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
902: p_docErrorRec.error_message := x_error_mesg;
903: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
904: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
905:
906: END MAX_PAYMENT_AMT_2;
907:

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

900: p_docErrorRec.transaction_error_id := null;
901: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
902: p_docErrorRec.error_message := x_error_mesg;
903: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
904: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
905:
906: END MAX_PAYMENT_AMT_2;
907:
908: -------------------------------------------------------------------------------------------------------------------

Line 923: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

919: (
920: p_format_name IN VARCHAR2,
921: p_payment_id IN NUMBER,
922: p_invoice_id IN NUMBER,
923: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
924: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
925: x_error_code OUT NOCOPY NUMBER,
926: x_error_mesg OUT NOCOPY VARCHAR2
927: )IS

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

964: p_docErrorRec.transaction_error_id := null;
965: p_docErrorRec.error_code := 'INVALID_PAY_TAX_BENEFIT';
966: p_docErrorRec.error_message := x_error_mesg;
967: x_error_code := g_ERROR;
968: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
969: l_message := 'Invalid reason code for type of vendor, reason_code = ' || l_payment_reason_code || ', vendor_type_code = ' || l_vendor_type_lookup_code;
970: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
971: END IF;
972: ELSE -- vendor is of type organization

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

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

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

989: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
990: p_docErrorRec.transaction_error_id := null;
991: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
992: p_docErrorRec.error_message := x_error_mesg;
993: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
994: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
995:
996:
997: END PAY_TAX_BENEFIT;

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

990: p_docErrorRec.transaction_error_id := null;
991: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
992: p_docErrorRec.error_message := x_error_mesg;
993: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
994: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
995:
996:
997: END PAY_TAX_BENEFIT;
998:

Line 1013: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1009: PROCEDURE PAY_SALARY_TRAVEL
1010: (
1011: p_format_name IN VARCHAR2,
1012: p_reason_code IN VARCHAR2,
1013: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1014: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1015: x_error_code OUT NOCOPY NUMBER,
1016: x_error_mesg OUT NOCOPY VARCHAR2
1017: )IS

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

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

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

1042: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1043: p_docErrorRec.transaction_error_id := null;
1044: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1045: p_docErrorRec.error_message := x_error_mesg;
1046: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1047: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1048:
1049:
1050: END PAY_SALARY_TRAVEL;

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

1043: p_docErrorRec.transaction_error_id := null;
1044: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1045: p_docErrorRec.error_message := x_error_mesg;
1046: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1047: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1048:
1049:
1050: END PAY_SALARY_TRAVEL;
1051:

Line 1069: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1065: (
1066: p_format_name IN VARCHAR2,
1067: p_ssn_tin IN VARCHAR2,
1068: p_payee_party_id IN VARCHAR2,
1069: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1070: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1071: x_error_code OUT NOCOPY NUMBER,
1072: x_error_mesg OUT NOCOPY VARCHAR2
1073: ) AS

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

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

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

1112: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1113: p_docErrorRec.transaction_error_id := null;
1114: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1115: p_docErrorRec.error_message := x_error_mesg;
1116: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1117: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1118:
1119: END PAYEE_SSN;
1120:

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

1113: p_docErrorRec.transaction_error_id := null;
1114: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1115: p_docErrorRec.error_message := x_error_mesg;
1116: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1117: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1118:
1119: END PAYEE_SSN;
1120:
1121: -------------------------------------------------------------------------------------------------------------------

Line 1137: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1133: PROCEDURE TAS_VALIDATION
1134: (
1135: p_format_name IN VARCHAR2,
1136: p_treasury_symbol IN VARCHAR2,
1137: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1138: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1139: x_error_code OUT NOCOPY NUMBER,
1140: x_error_mesg OUT NOCOPY VARCHAR2
1141: )IS

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

1162: p_docErrorRec.transaction_error_id := null;
1163: p_docErrorRec.error_code := 'TREASURY_SYMBOL_LENGTH';
1164: p_docErrorRec.error_message := x_error_mesg;
1165: x_error_code := g_ERROR;
1166: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1167: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1168: ELSE
1169: l_char_string := 'ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890/.()';
1170:

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

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

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

1194: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1195: p_docErrorRec.transaction_error_id := null;
1196: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1197: p_docErrorRec.error_message := x_error_mesg;
1198: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1199: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1200:
1201: END TAS_VALIDATION;
1202:

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

1195: p_docErrorRec.transaction_error_id := null;
1196: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1197: p_docErrorRec.error_message := x_error_mesg;
1198: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1199: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1200:
1201: END TAS_VALIDATION;
1202:
1203: -------------------------------------------------------------------------------------------------------------------

Line 1220: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1216: (
1217: p_format_name IN VARCHAR2,
1218: p_agency_location_code IN ce_bank_accounts.agency_location_code%TYPE,
1219: p_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,
1220: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1221: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1222: x_error_code OUT NOCOPY NUMBER,
1223: x_error_mesg OUT NOCOPY VARCHAR2
1224: )IS

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

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

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

1251: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1252: p_docErrorRec.transaction_error_id := null;
1253: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1254: p_docErrorRec.error_message := x_error_mesg;
1255: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1256: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1257:
1258: END AGENCY_LOCATION_CODE;
1259:

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

1252: p_docErrorRec.transaction_error_id := null;
1253: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1254: p_docErrorRec.error_message := x_error_mesg;
1255: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1256: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1257:
1258: END AGENCY_LOCATION_CODE;
1259:
1260: -------------------------------------------------------------------------------------------------------------------

Line 1277: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1273: PROCEDURE RTN_NUMBER
1274: (
1275: p_format_name IN VARCHAR2,
1276: p_rtn_number IN VARCHAR2,
1277: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1278: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1279: x_error_code OUT NOCOPY NUMBER,
1280: x_error_mesg OUT NOCOPY VARCHAR2
1281: )IS

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

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

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

1379: p_docErrorRec.transaction_error_id := null;
1380: p_docErrorRec.error_code := 'INVALID_RTN';
1381: p_docErrorRec.error_message := x_error_mesg;
1382: x_error_code := g_ERROR;
1383: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1384: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1385: END IF;
1386:
1387: ELSE

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

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

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

1403: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1404: p_docErrorRec.transaction_error_id := null;
1405: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1406: p_docErrorRec.error_message := x_error_mesg;
1407: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1408: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1409:
1410: END RTN_NUMBER;
1411:

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

1404: p_docErrorRec.transaction_error_id := null;
1405: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1406: p_docErrorRec.error_message := x_error_mesg;
1407: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1408: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1409:
1410: END RTN_NUMBER;
1411:
1412: -------------------------------------------------------------------------------------------------------------------

Line 1430: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1426: (
1427: p_format_name IN VARCHAR2,
1428: p_invoice_id IN NUMBER,
1429: p_payment_id IN NUMBER,
1430: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1431: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1432: x_error_code OUT NOCOPY NUMBER,
1433: x_error_mesg OUT NOCOPY VARCHAR2
1434: )IS

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

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

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

1477: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1478: p_docErrorRec.transaction_error_id := null;
1479: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1480: p_docErrorRec.error_message := x_error_mesg;
1481: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1482: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1483:
1484: END PAY_ALONE_OPTION;
1485:

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

1478: p_docErrorRec.transaction_error_id := null;
1479: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1480: p_docErrorRec.error_message := x_error_mesg;
1481: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1482: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1483:
1484: END PAY_ALONE_OPTION;
1485:
1486: -------------------------------------------------------------------------------------------------------------------

Line 1501: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1497: PROCEDURE DEPOSITER_ACC_NUM
1498: (
1499: p_format_name IN VARCHAR2,
1500: p_dep_account_no IN iby_ext_bank_accounts.bank_account_num%TYPE,
1501: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1502: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1503: x_error_code OUT NOCOPY NUMBER,
1504: x_error_mesg OUT NOCOPY VARCHAR2
1505: )IS

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

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

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

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

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

1556: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1557: p_docErrorRec.transaction_error_id := null;
1558: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1559: p_docErrorRec.error_message := x_error_mesg;
1560: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1561: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1562:
1563:
1564: END DEPOSITER_ACC_NUM;

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

1557: p_docErrorRec.transaction_error_id := null;
1558: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1559: p_docErrorRec.error_message := x_error_mesg;
1560: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1561: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1562:
1563:
1564: END DEPOSITER_ACC_NUM;
1565:

Line 1585: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1581: p_bank_account_type IN iby_ext_bank_accounts.bank_account_type%TYPE,
1582: p_bank_account_name IN iby_ext_bank_accounts.bank_account_name%TYPE,
1583: p_invoice_id IN NUMBER,
1584: p_payment_id IN NUMBER,
1585: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1586: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1587: x_error_code OUT NOCOPY NUMBER,
1588: x_error_mesg OUT NOCOPY VARCHAR2
1589: )IS

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

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

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

1626: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1627: p_docErrorRec.transaction_error_id := null;
1628: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1629: p_docErrorRec.error_message := x_error_mesg;
1630: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1631: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1632:
1633: END ACCOUNT_TYPE;
1634:

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

1627: p_docErrorRec.transaction_error_id := null;
1628: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1629: p_docErrorRec.error_message := x_error_mesg;
1630: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1631: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1632:
1633: END ACCOUNT_TYPE;
1634:
1635: -------------------------------------------------------------------------------------------------------------------

Line 1650: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1646: PROCEDURE RFC_ID
1647: (
1648: p_format_name IN VARCHAR2,
1649: p_payment_id IN NUMBER,
1650: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1651: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1652: x_error_code OUT NOCOPY NUMBER,
1653: x_error_mesg OUT NOCOPY VARCHAR2
1654: )IS

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

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

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

1707: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1708: p_docErrorRec.transaction_error_id := null;
1709: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1710: p_docErrorRec.error_message := x_error_mesg;
1711: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1712: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1713:
1714: END RFC_ID;
1715:

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

1708: p_docErrorRec.transaction_error_id := null;
1709: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1710: p_docErrorRec.error_message := x_error_mesg;
1711: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1712: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1713:
1714: END RFC_ID;
1715:
1716:

Line 1743: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1739: PROCEDURE MANDATORY_PPD_PPDP_REASON_CODE
1740: (
1741: p_format_name IN VARCHAR2,
1742: p_reason_code IN VARCHAR2,
1743: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1744: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1745: x_error_code OUT NOCOPY NUMBER,
1746: x_error_mesg OUT NOCOPY VARCHAR2
1747: )IS

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

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

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

1777: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1778: p_docErrorRec.transaction_error_id := null;
1779: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1780: p_docErrorRec.error_message := x_error_mesg;
1781: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1782: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1783:
1784: END MANDATORY_PPD_PPDP_REASON_CODE;
1785: -----------------------------------------------------------------------------------------------------------------

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

1778: p_docErrorRec.transaction_error_id := null;
1779: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1780: p_docErrorRec.error_message := x_error_mesg;
1781: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1782: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1783:
1784: END MANDATORY_PPD_PPDP_REASON_CODE;
1785: -----------------------------------------------------------------------------------------------------------------
1786: /*

Line 1801: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1797: PROCEDURE EXTERNAL_BANK_ACCOUNT_ID
1798: (
1799: p_format_name IN VARCHAR2,
1800: p_external_bank_account_id IN NUMBER,
1801: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1802: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1803: x_error_code OUT NOCOPY NUMBER,
1804: x_error_mesg OUT NOCOPY VARCHAR2
1805: )IS

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

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

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

1835: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1836: p_docErrorRec.transaction_error_id := null;
1837: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1838: p_docErrorRec.error_message := x_error_mesg;
1839: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1840: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1841:
1842: END EXTERNAL_BANK_ACCOUNT_ID;
1843: -----------------------------------------------------------------------------------------------------------------

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

1836: p_docErrorRec.transaction_error_id := null;
1837: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1838: p_docErrorRec.error_message := x_error_mesg;
1839: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1840: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1841:
1842: END EXTERNAL_BANK_ACCOUNT_ID;
1843: -----------------------------------------------------------------------------------------------------------------
1844: PROCEDURE FEDERAL_ID_NUMBER

Line 1848: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1844: PROCEDURE FEDERAL_ID_NUMBER
1845: (
1846: p_format_name IN VARCHAR2,
1847: p_pay_instruction_id IN NUMBER,
1848: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1849: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1850: x_error_code OUT NOCOPY NUMBER,
1851: x_error_mesg OUT NOCOPY VARCHAR2
1852: )IS

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

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

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

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

1906: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1907: p_docErrorRec.transaction_error_id := null;
1908: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1909: p_docErrorRec.error_message := x_error_mesg;
1910: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1911: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1912:
1913: END FEDERAL_ID_NUMBER;
1914:

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

1907: p_docErrorRec.transaction_error_id := null;
1908: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1909: p_docErrorRec.error_message := x_error_mesg;
1910: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1911: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1912:
1913: END FEDERAL_ID_NUMBER;
1914:
1915: ------------------------------------------------------------------------------------------------------------------

Line 1920: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

1916: PROCEDURE AGENCY_ID_ABBREVIATION
1917: (
1918: p_format_name IN VARCHAR2,
1919: p_instruction_id IN NUMBER,
1920: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1921: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1922: x_error_code OUT NOCOPY NUMBER,
1923: x_error_mesg OUT NOCOPY VARCHAR2
1924: )IS

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

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

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

1957: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, x_error_mesg);
1958: p_docErrorRec.transaction_error_id := null;
1959: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1960: p_docErrorRec.error_message := x_error_mesg;
1961: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1962: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1963:
1964: END AGENCY_ID_ABBREVIATION;
1965:

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

1958: p_docErrorRec.transaction_error_id := null;
1959: p_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1960: p_docErrorRec.error_message := x_error_mesg;
1961: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);
1962: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);
1963:
1964: END AGENCY_ID_ABBREVIATION;
1965:
1966: