[Home] [Help]
5:
6:
7: --
8: -- List of possible transaction types
9: -- These are used to insert into the IBY_TRANSACTION_ERRORS table.
10: --
11: TRANS_TYPE_DOC CONSTANT VARCHAR2(100) := 'DOCUMENT_PAYABLE';
12: TRANS_TYPE_PAY CONSTANT VARCHAR2(100) := 'PAYMENT';
13: TRANS_TYPE_INS CONSTANT VARCHAR2(100) := 'PAYMENT_INSTRUCTION';
13: TRANS_TYPE_INS CONSTANT VARCHAR2(100) := 'PAYMENT_INSTRUCTION';
14:
15: --
16: -- List of possible error types
17: -- These are used to insert into the IBY_TRANSACTION_ERRORS table.
18: --
19: ERROR_TYPE_VALIDATION CONSTANT VARCHAR2(100) := 'VALIDATION';
20: ERROR_TYPE_BANK CONSTANT VARCHAR2(100) := 'BANK';
21:
21:
22:
23: PROCEDURE validate_uri_using_modulus10(s IN VARCHAR2,
24: x_valResult OUT NOCOPY BOOLEAN,
25: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE);
26:
27: PROCEDURE xxno_chk_mod_10_11
28: (p_kid_nr IN varchar2,
29: x_valResult OUT NOCOPY BOOLEAN,
26:
27: PROCEDURE xxno_chk_mod_10_11
28: (p_kid_nr IN varchar2,
29: x_valResult OUT NOCOPY BOOLEAN,
30: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE);
31:
32: /*--------------------------------------------------------------------
33: | NAME:
34: | CITI_AT_EFT_DOM_PAYEE
59: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
60: l_valResult BOOLEAN;
61: l_valid NUMBER := 0;
62: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
63: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
64:
65: BEGIN
66:
67: -- Initializing the document record
121: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
122: l_valid := 1;
123: END IF;
124:
125: -- Insert errors into IBY_TRANSACTION_ERRORS
126: IF (l_valid = 1) THEN
127: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
128: END IF;
129:
162: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
163: l_valResult BOOLEAN;
164: l_valid NUMBER := 0;
165: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
166: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
167:
168: BEGIN
169:
170: -- Initializing the document record
191: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
192: l_valid := 1;
193: END IF;
194:
195: -- Inserting errors into IBY_TRANSACTION_ERRORS
196: IF (l_valid = 1) THEN
197: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
198: END IF;
199:
232: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
233: l_valResult BOOLEAN;
234: l_valid NUMBER := 0;
235: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
236: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
237:
238: BEGIN
239:
240: -- Initializing the document record
266: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
267: l_valid := 1;
268: END IF;
269:
270: -- Insert errors into IBY_TRANSACTION_ERRORS
271: IF (l_valid = 1) THEN
272: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
273: END IF;
274:
307: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
308: l_valResult BOOLEAN;
309: l_valid NUMBER := 0;
310: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
311: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
312:
313: BEGIN
314:
315: -- Initializing the document record
351: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
352: l_valid := 1;
353: END IF;
354:
355: -- Insert errors into IBY_TRANSACTION_ERRORS
356: IF (l_valid = 1) THEN
357: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
358: END IF;
359:
392: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
393: l_valResult BOOLEAN;
394: l_valid NUMBER := 0;
395: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
396: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
397:
398: BEGIN
399:
400: -- Initializing the document record
436: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
437: l_valid := 1;
438: END IF;
439:
440: -- Insert errors into IBY_TRANSACTION_ERRORS
441: IF (l_valid = 1) THEN
442: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
443: END IF;
444:
477: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
478: l_valResult BOOLEAN;
479: l_valid NUMBER := 0;
480: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
481: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
482:
483: BEGIN
484:
485: -- Initializing the document record
553: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
554: l_valid := 1;
555: END IF;
556:
557: -- Inserting errors into IBY_TRANSACTION_ERRORS
558: IF (l_valid = 1) THEN
559: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
560: END IF;
561:
594: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
595: l_valResult BOOLEAN;
596: l_valid NUMBER := 0;
597: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
598: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
599:
600: l_max_ach_amt NUMBER;
601:
602: BEGIN
644: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
645: l_valid := 1;
646: END IF;
647:
648: -- Inserting errors into IBY_TRANSACTION_ERRORS
649: -- The first parameter p_is_online_val takes hardcoded value 'N'.
650: IF (l_valid = 1) THEN
651: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
652: END IF;
686: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
687: l_valResult BOOLEAN;
688: l_valid NUMBER := 0;
689: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
690: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
691:
692: BEGIN
693:
694: -- Initializing the document record
715: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
716: l_valid := 1;
717: END IF;
718:
719: -- Inserting errors into IBY_TRANSACTION_ERRORS
720: IF (l_valid = 1) THEN
721: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
722: END IF;
723:
756: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
757: l_valResult BOOLEAN;
758: l_valid NUMBER := 0;
759: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
760: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
761:
762: BEGIN
763:
764: -- Initializing the document record
814:
815: -- Validate EFT cost code
816: -- Not necessary. Combined into Validate Supplier cost code.
817:
818: -- Inserting errors into IBY_TRANSACTION_ERRORS
819: IF (l_valid = 1) THEN
820: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
821: END IF;
822:
855: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
856: l_valResult BOOLEAN;
857: l_valid NUMBER := 0;
858: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
859: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
860:
861: BEGIN
862:
863: -- Initializing the document record
890:
891: -- Validate number of detail records
892: -- Not coded. This has been moved to the instruction level.
893:
894: -- Inserting errors into IBY_TRANSACTION_ERRORS
895: IF (l_valid = 1) THEN
896: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
897: END IF;
898:
931: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
932: l_valResult BOOLEAN;
933: l_valid NUMBER := 0;
934: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
935: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
936:
937: l_max_check_amt NUMBER;
938: l_max_pay_reason_cnt NUMBER;
939:
995: ---------------------------------------------------------------------------*/
996:
997: -- Bug 5411492 changes end here
998:
999: -- Inserting errors into IBY_TRANSACTION_ERRORS
1000: -- The first parameter p_is_online_val takes hardcoded value 'N'.
1001: IF (l_valid = 1) THEN
1002: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1003: END IF;
1037: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
1038: l_valResult BOOLEAN;
1039: l_valid NUMBER := 0;
1040: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1041: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1042:
1043: l_max_num_of_docs NUMBER;
1044:
1045: BEGIN
1072: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1073: l_valid := 1;
1074: END IF;
1075:
1076: -- Inserting errors into IBY_TRANSACTION_ERRORS
1077: -- The first parameter p_is_online_val takes hardcoded value 'N'.
1078: IF (l_valid = 1) THEN
1079: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1080: END IF;
1114: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
1115: l_valResult BOOLEAN;
1116: l_valid NUMBER := 0;
1117: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1118: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1119:
1120: BEGIN
1121:
1122: -- Initializing the document record
1319: else
1320: null;
1321: end if;
1322:
1323: -- Insert errors into IBY_TRANSACTION_ERRORS
1324: IF (l_valid = 1) THEN
1325: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
1326: END IF;
1327:
1360: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
1361: l_valResult BOOLEAN;
1362: l_valid NUMBER := 0;
1363: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1364: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1365:
1366: BEGIN
1367:
1368: -- Initializing the document record
1404: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1405: l_valid := 1;
1406: END IF;
1407:
1408: -- Inserting errors into IBY_TRANSACTION_ERRORS
1409: IF (l_valid = 1) THEN
1410: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
1411: END IF;
1412:
1445: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
1446: l_valResult BOOLEAN;
1447: l_valid NUMBER := 0;
1448: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1449: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1450:
1451: BEGIN
1452:
1453: -- Initializing the payment record
1472: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1473: l_valid := 1;
1474: END IF;
1475:
1476: -- Inserting errors into IBY_TRANSACTION_ERRORS
1477: -- The first parameter p_is_online_val takes hardcoded value 'N'.
1478: IF (l_valid = 1) THEN
1479: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1480: END IF;
1514: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
1515: l_valResult BOOLEAN;
1516: l_valid NUMBER := 0;
1517: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1518: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1519:
1520: BEGIN
1521:
1522: -- Initializing the payment record
1567:
1568: -- Validate supplier name and address
1569: -- Note coded. This will be handled in a separate validation set for char set.
1570:
1571: -- Insert errors into IBY_TRANSACTION_ERRORS
1572: IF (l_valid = 1) THEN
1573: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
1574: END IF;
1575:
1608: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
1609: l_valResult BOOLEAN;
1610: l_valid NUMBER := 0;
1611: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1612: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1613:
1614: BEGIN
1615:
1616: -- Initializing the payment record
1760:
1761: -- Validate bank account type for SAD payments
1762: -- Ignore: SAD format is obsolete.
1763:
1764: -- Insert errors into IBY_TRANSACTION_ERRORS
1765: IF (l_valid = 1) THEN
1766: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
1767: END IF;
1768:
1801: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
1802: l_valResult BOOLEAN;
1803: l_valid NUMBER := 0;
1804: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1805: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1806:
1807: BEGIN
1808:
1809: -- Initializing the document record
1863: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1864: l_valid := 1;
1865: END IF;
1866:
1867: -- Inserting errors into IBY_TRANSACTION_ERRORS
1868: IF (l_valid = 1) THEN
1869: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
1870: END IF;
1871:
1904: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
1905: l_valResult BOOLEAN;
1906: l_valid NUMBER := 0;
1907: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1908: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1909:
1910: BEGIN
1911:
1912: -- Initializing the document record
1933: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1934: l_valid := 1;
1935: END IF;
1936:
1937: -- Inserting errors into IBY_TRANSACTION_ERRORS
1938: IF (l_valid = 1) THEN
1939: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
1940: END IF;
1941:
1974: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
1975: l_valResult BOOLEAN;
1976: l_valid NUMBER := 0;
1977: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1978: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1979:
1980: BEGIN
1981:
1982: -- Initializing the document record
2035: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2036: l_valid := 1;
2037: END IF;
2038:
2039: -- Inserting errors into IBY_TRANSACTION_ERRORS
2040: IF (l_valid = 1) THEN
2041: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
2042: END IF;
2043:
2076: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
2077: l_valResult BOOLEAN;
2078: l_valid NUMBER := 0;
2079: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2080: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2081:
2082: BEGIN
2083:
2084: -- Initializing the document record
2105: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2106: l_valid := 1;
2107: END IF;
2108:
2109: -- Inserting errors into IBY_TRANSACTION_ERRORS
2110: IF (l_valid = 1) THEN
2111: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
2112: END IF;
2113:
2146: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
2147: l_valResult BOOLEAN;
2148: l_valid NUMBER := 0;
2149: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2150: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2151:
2152: BEGIN
2153:
2154: -- Initializing the document record
2207: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2208: l_valid := 1;
2209: END IF;
2210:
2211: -- Inserting errors into IBY_TRANSACTION_ERRORS
2212: IF (l_valid = 1) THEN
2213: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
2214: END IF;
2215:
2248: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
2249: l_valResult BOOLEAN;
2250: l_valid NUMBER := 0;
2251: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2252: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2253:
2254: BEGIN
2255:
2256: -- Initializing the payment record
2275: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2276: l_valid := 1;
2277: END IF;
2278:
2279: -- Inserting errors into IBY_TRANSACTION_ERRORS
2280: IF (l_valid = 1) THEN
2281: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2282: END IF;
2283:
2316: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
2317: l_valResult BOOLEAN;
2318: l_valid NUMBER := 0;
2319: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2320: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2321:
2322: BEGIN
2323:
2324: -- Initializing the document record
2377: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2378: l_valid := 1;
2379: END IF;
2380:
2381: -- Inserting errors into IBY_TRANSACTION_ERRORS
2382: IF (l_valid = 1) THEN
2383: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
2384: END IF;
2385:
2418: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
2419: l_valResult BOOLEAN;
2420: l_valid NUMBER := 0;
2421: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2422: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2423:
2424: BEGIN
2425:
2426: -- Initializing the document record
2465: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2466: l_valid := 1;
2467: END IF;
2468:
2469: -- Inserting errors into IBY_TRANSACTION_ERRORS
2470: IF (l_valid = 1) THEN
2471: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
2472: END IF;
2473:
2506: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
2507: l_valResult BOOLEAN;
2508: l_valid NUMBER := 0;
2509: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2510: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2511:
2512: BEGIN
2513:
2514: -- Initializing the document record
2599: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2600: l_valid := 1;
2601: END IF;
2602:
2603: -- Inserting errors into IBY_TRANSACTION_ERRORS
2604: IF (l_valid = 1) THEN
2605: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
2606: END IF;
2607: */
2642: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
2643: l_valResult BOOLEAN;
2644: l_valid NUMBER := 0;
2645: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2646: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2647:
2648: BEGIN
2649:
2650: -- Initializing the payment record
2672:
2673: -- Validate document country
2674: -- Not coded. The validation has been moved to the document level at payee validation.
2675:
2676: -- Inserting errors into IBY_TRANSACTION_ERRORS
2677: -- The first parameter p_is_online_val takes hardcoded value 'N'.
2678: IF (l_valid = 1) THEN
2679: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2680: END IF;
2715: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
2716: l_valResult BOOLEAN;
2717: l_valid NUMBER := 0;
2718: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2719: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2720:
2721: BEGIN
2722:
2723: -- Initializing the payment record
2740: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2741: l_valid := 1;
2742: END IF;
2743:
2744: -- Inserting errors into IBY_TRANSACTION_ERRORS
2745: IF (l_valid = 1) THEN
2746: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
2747: END IF;
2748:
2781: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
2782: l_valResult BOOLEAN;
2783: l_valid NUMBER := 0;
2784: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2785: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2786:
2787: BEGIN
2788:
2789: -- Initializing the payment record
2824: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2825: l_valid := 1;
2826: END IF;
2827:
2828: -- Inserting errors into IBY_TRANSACTION_ERRORS
2829: IF (l_valid = 1) THEN
2830: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
2831: END IF;
2832:
2865: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
2866: l_valResult BOOLEAN;
2867: l_valid NUMBER := 0;
2868: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2869: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2870:
2871: BEGIN
2872:
2873: -- Initializing the payment record
2894: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2895: l_valid := 1;
2896: END IF;
2897:
2898: -- Inserting errors into IBY_TRANSACTION_ERRORS
2899: IF (l_valid = 1) THEN
2900: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
2901: END IF;
2902:
2935: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
2936: l_valResult BOOLEAN;
2937: l_valid NUMBER := 0;
2938: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2939: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2940:
2941: BEGIN
2942:
2943: -- Initializing the payment record
3034: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
3035: l_valResult BOOLEAN;
3036: l_valid NUMBER := 0;
3037: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3038: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3039:
3040: BEGIN
3041:
3042: -- Initializing the document record
3093: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3094: l_valid := 1;
3095: END IF;
3096:
3097: -- Inserting errors into IBY_TRANSACTION_ERRORS
3098: IF (l_valid = 1) THEN
3099: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
3100: END IF;
3101:
3134: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
3135: l_valResult BOOLEAN;
3136: l_valid NUMBER := 0;
3137: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3138: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3139:
3140: BEGIN
3141:
3142: -- Initializing the payment record
3161: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3162: l_valid := 1;
3163: END IF;
3164:
3165: -- Inserting errors into IBY_TRANSACTION_ERRORS
3166: -- The first parameter p_is_online_val takes hardcoded value 'N'.
3167: IF (l_valid = 1) THEN
3168: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3169: END IF;
3203: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
3204: l_valResult BOOLEAN;
3205: l_valid NUMBER := 0;
3206: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3207: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3208:
3209: BEGIN
3210:
3211: -- Initializing the document record
3286: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3287: l_valid := 1;
3288: END IF;
3289:
3290: -- Insert errors into IBY_TRANSACTION_ERRORS
3291: IF (l_valid = 1) THEN
3292: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
3293: END IF;
3294:
3327: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
3328: l_valResult BOOLEAN;
3329: l_valid NUMBER := 0;
3330: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3331: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3332:
3333: BEGIN
3334:
3335: -- Initializing the document record
3356: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3357: l_valid := 1;
3358: END IF;
3359:
3360: -- Inserting errors into IBY_TRANSACTION_ERRORS
3361: IF (l_valid = 1) THEN
3362: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
3363: END IF;
3364:
3397: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
3398: l_valResult BOOLEAN;
3399: l_valid NUMBER := 0;
3400: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3401: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3402:
3403: BEGIN
3404:
3405: -- Initializing the payment record
3424: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3425: l_valid := 1;
3426: END IF;
3427:
3428: -- Inserting errors into IBY_TRANSACTION_ERRORS
3429: -- The first parameter p_is_online_val takes hardcoded value 'N'.
3430: IF (l_valid = 1) THEN
3431: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3432: END IF;
3466: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
3467: l_valResult BOOLEAN;
3468: l_valid NUMBER := 0;
3469: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3470: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3471:
3472: BEGIN
3473:
3474: -- Initializing the document record
3513: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3514: l_valid := 1;
3515: END IF;
3516:
3517: -- Insert errors into IBY_TRANSACTION_ERRORS
3518: IF (l_valid = 1) THEN
3519: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
3520: END IF;
3521:
3554: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
3555: l_valResult BOOLEAN;
3556: l_valid NUMBER := 0;
3557: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3558: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3559:
3560: BEGIN
3561:
3562: -- Initializing the document record
3583: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3584: l_valid := 1;
3585: END IF;
3586:
3587: -- Insert errors into IBY_TRANSACTION_ERRORS
3588: IF (l_valid = 1) THEN
3589: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
3590: END IF;
3591:
3624: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
3625: l_valResult BOOLEAN;
3626: l_valid NUMBER := 0;
3627: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3628: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3629:
3630: BEGIN
3631:
3632: -- Initializing the payment record
3651: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3652: l_valid := 1;
3653: END IF;
3654:
3655: -- Inserting errors into IBY_TRANSACTION_ERRORS
3656: -- The first parameter p_is_online_val takes hardcoded value 'N'.
3657: IF (l_valid = 1) THEN
3658: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3659: END IF;
3693: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
3694: l_valResult BOOLEAN;
3695: l_valid NUMBER := 0;
3696: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3697: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3698:
3699: BEGIN
3700:
3701: -- Initializing the document record
3749: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3750: l_valid := 1;
3751: END IF;
3752:
3753: -- Inserting errors into IBY_TRANSACTION_ERRORS
3754: IF (l_valid = 1) THEN
3755: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
3756: END IF;
3757:
3790: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
3791: l_valResult BOOLEAN;
3792: l_valid NUMBER := 0;
3793: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3794: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3795:
3796: BEGIN
3797:
3798: -- Initializing the document record
3819: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3820: l_valid := 1;
3821: END IF;
3822:
3823: -- Inserting errors into IBY_TRANSACTION_ERRORS
3824: IF (l_valid = 1) THEN
3825: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
3826: END IF;
3827:
3860: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
3861: l_valResult BOOLEAN;
3862: l_valid NUMBER := 0;
3863: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3864: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3865:
3866: l_max_ach_amt NUMBER;
3867:
3868: BEGIN
3895: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3896: l_valid := 1;
3897: END IF;
3898:
3899: -- Inserting errors into IBY_TRANSACTION_ERRORS
3900: -- The first parameter p_is_online_val takes hardcoded value 'N'.
3901: IF (l_valid = 1) THEN
3902: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3903: END IF;
3937: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
3938: l_valResult BOOLEAN;
3939: l_valid NUMBER := 0;
3940: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3941: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3942:
3943: BEGIN
3944:
3945: -- Initializing the document record
3990:
3991: -- Validate target bank account number
3992: -- by CE
3993:
3994: -- Insert errors into IBY_TRANSACTION_ERRORS
3995: IF (l_valid = 1) THEN
3996: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
3997: END IF;
3998:
4031: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
4032: l_valResult BOOLEAN;
4033: l_valid NUMBER := 0;
4034: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4035: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4036:
4037: BEGIN
4038:
4039: -- Initializing the document record
4060: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4061: l_valid := 1;
4062: END IF;
4063:
4064: -- Insert errors into IBY_TRANSACTION_ERRORS
4065: IF (l_valid = 1) THEN
4066: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
4067: END IF;
4068:
4101: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
4102: l_valResult BOOLEAN;
4103: l_valid NUMBER := 0;
4104: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4105: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4106:
4107: BEGIN
4108:
4109: -- Initializing the payment record
4128: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4129: l_valid := 1;
4130: END IF;
4131:
4132: -- Inserting errors into IBY_TRANSACTION_ERRORS
4133: -- The first parameter p_is_online_val takes hardcoded value 'N'.
4134: IF (l_valid = 1) THEN
4135: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4136: END IF;
4170: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
4171: l_valResult BOOLEAN;
4172: l_valid NUMBER := 0;
4173: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4174: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4175:
4176: BEGIN
4177:
4178: -- Initializing the document record
4208:
4209: -- Validate target bank account number
4210: -- by CE
4211:
4212: -- Insert errors into IBY_TRANSACTION_ERRORS
4213: IF (l_valid = 1) THEN
4214: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
4215: END IF;
4216:
4249: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
4250: l_valResult BOOLEAN;
4251: l_valid NUMBER := 0;
4252: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4253: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4254: l_validTrxnCodes VARCHAR2(100) := '0001, 0003, 0004';
4255:
4256: BEGIN
4257:
4279: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4280: l_valid := 1;
4281: END IF;
4282:
4283: -- Insert errors into IBY_TRANSACTION_ERRORS
4284: IF (l_valid = 1) THEN
4285: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
4286: END IF;
4287:
4320: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
4321: l_valResult BOOLEAN;
4322: l_valid NUMBER := 0;
4323: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4324: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4325:
4326: BEGIN
4327:
4328: -- Initializing the payment record
4347: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4348: l_valid := 1;
4349: END IF;
4350:
4351: -- Inserting errors into IBY_TRANSACTION_ERRORS
4352: -- The first parameter p_is_online_val takes hardcoded value 'N'.
4353: IF (l_valid = 1) THEN
4354: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4355: END IF;
4389: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
4390: l_valResult BOOLEAN;
4391: l_valid NUMBER := 0;
4392: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4393: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4394:
4395: BEGIN
4396:
4397: -- Initializing the document record
4468: END IF;
4469:
4470: -- by CE, validation on digits only.
4471:
4472: -- Inserting errors into IBY_TRANSACTION_ERRORS
4473: IF (l_valid = 1) THEN
4474: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
4475: END IF;
4476:
4509: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
4510: l_valResult BOOLEAN;
4511: l_valid NUMBER := 0;
4512: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4513: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4514:
4515: BEGIN
4516:
4517: -- Initializing the payment record
4566: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4567: l_valid := 1;
4568: END IF;
4569:
4570: -- Inserting errors into IBY_TRANSACTION_ERRORS
4571: -- The first parameter p_is_online_val takes hardcoded value 'N'.
4572: IF (l_valid = 1) THEN
4573: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4574: END IF;
4608: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
4609: l_valResult BOOLEAN;
4610: l_valid NUMBER := 0;
4611: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4612: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4613:
4614: BEGIN
4615:
4616: -- Initializing the document record
4637: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4638: l_valid := 1;
4639: END IF;
4640:
4641: -- Inserting errors into IBY_TRANSACTION_ERRORS
4642: IF (l_valid = 1) THEN
4643: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
4644: END IF;
4645:
4678: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
4679: l_valResult BOOLEAN;
4680: l_valid NUMBER := 0;
4681: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4682: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4683:
4684: BEGIN
4685:
4686: -- Initializing the document record
4764: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4765: l_valid := 1;
4766: END IF;
4767:
4768: -- Insert errors into IBY_TRANSACTION_ERRORS
4769: IF (l_valid = 1) THEN
4770: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
4771: END IF;
4772:
4805: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
4806: l_valResult BOOLEAN;
4807: l_valid NUMBER := 0;
4808: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4809: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4810:
4811: BEGIN
4812:
4813: -- Initializing the payment record
4847: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4848: l_valid := 1;
4849: END IF;
4850:
4851: -- Insert errors into IBY_TRANSACTION_ERRORS
4852: -- The first parameter p_is_online_val takes hardcoded value 'N'.
4853: IF (l_valid = 1) THEN
4854: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4855: END IF;
4889: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
4890: l_valResult BOOLEAN;
4891: l_valid NUMBER := 0;
4892: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4893: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4894:
4895: BEGIN
4896:
4897: -- Initializing the document record
4951: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4952: l_valid := 1;
4953: END IF;
4954:
4955: -- Insert errors into IBY_TRANSACTION_ERRORS
4956: IF (l_valid = 1) THEN
4957: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
4958: END IF;
4959:
4992: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
4993: l_valResult BOOLEAN;
4994: l_valid NUMBER := 0;
4995: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4996: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4997:
4998: BEGIN
4999:
5000: -- Initializing the document record
5042:
5043: -- Validate supplier bank account name alternate
5044: -- by CE
5045:
5046: -- Insert errors into IBY_TRANSACTION_ERRORS
5047: IF (l_valid = 1) THEN
5048: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
5049: END IF;
5050:
5085: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
5086: l_valResult BOOLEAN;
5087: l_valid NUMBER := 0;
5088: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
5089: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
5090:
5091: BEGIN
5092:
5093: -- Initializing the document record
5112: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec,l_docErrorTab);
5113: l_valid := 1;
5114: END IF;
5115:
5116: -- Inserting errors into IBY_TRANSACTION_ERRORS
5117: IF (l_valid = 1) THEN
5118: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
5119: END IF;
5120:
5153: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
5154: l_valResult BOOLEAN;
5155: l_valid NUMBER := 0;
5156: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
5157: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
5158:
5159: BEGIN
5160:
5161: -- Initializing the document record
5197: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
5198: l_valid := 1;
5199: END IF;
5200:
5201: -- Inserting errors into IBY_TRANSACTION_ERRORS
5202: IF (l_valid = 1) THEN
5203: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
5204: END IF;
5205:
5238: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
5239: l_valResult BOOLEAN;
5240: l_valid NUMBER := 0;
5241: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
5242: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
5243:
5244: BEGIN
5245:
5246: -- Initializing the document record
5282: l_valid := 1;
5283: END IF;
5284: */
5285:
5286: -- Inserting errors into IBY_TRANSACTION_ERRORS
5287: IF (l_valid = 1) THEN
5288: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
5289: END IF;
5290:
5323: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
5324: l_valResult BOOLEAN;
5325: l_valid NUMBER := 0;
5326: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
5327: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
5328:
5329: BEGIN
5330:
5331: -- Initializing the payment record
5350: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
5351: l_valid := 1;
5352: END IF;
5353:
5354: -- Inserting errors into IBY_TRANSACTION_ERRORS
5355: -- The first parameter p_is_online_val takes hardcoded value 'N'.
5356: IF (l_valid = 1) THEN
5357: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
5358: END IF;
5392: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
5393: l_valResult BOOLEAN;
5394: l_valid NUMBER := 0;
5395: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
5396: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
5397:
5398: BEGIN
5399:
5400: -- Initializing the document record with the Document Payables information
5432: l_valid := 1;
5433: END IF;
5434: END IF;
5435:
5436: -- Inserting errors into IBY_TRANSACTION_ERRORS
5437: IF (l_valid = 1) THEN
5438: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
5439: END IF;
5440:
5473: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
5474: l_valResult BOOLEAN;
5475: l_valid NUMBER := 0;
5476: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
5477: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
5478:
5479: BEGIN
5480:
5481: -- Initializing the document record
5574: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
5575: l_valid := 1;
5576: END IF;
5577:
5578: -- Inserting errors into IBY_TRANSACTION_ERRORS
5579: IF (l_valid = 1) THEN
5580: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
5581: END IF;
5582:
5615: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
5616: l_valResult BOOLEAN;
5617: l_valid NUMBER := 0;
5618: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
5619: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
5620:
5621: l_max_payment_amt number;
5622:
5623: BEGIN
5666: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
5667: l_valid := 1;
5668: END IF;
5669:
5670: -- Inserting errors into IBY_TRANSACTION_ERRORS
5671: -- The first parameter p_is_online_val takes hardcoded value 'N'.
5672: IF (l_valid = 1) THEN
5673: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
5674: END IF;
5708: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
5709: l_valResult BOOLEAN;
5710: l_valid NUMBER := 0;
5711: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
5712: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
5713:
5714: BEGIN
5715:
5716: -- Initializing the document record with the Document Payables information
5748: l_valid := 1;
5749: END IF;
5750: END IF;
5751:
5752: -- Inserting errors into IBY_TRANSACTION_ERRORS
5753: IF (l_valid = 1) THEN
5754: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
5755: END IF;
5756:
5789: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
5790: l_valResult BOOLEAN;
5791: l_valid NUMBER := 0;
5792: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
5793: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
5794:
5795: BEGIN
5796:
5797: -- Initializing the document record
5854: l_valid := 1;
5855: END IF;
5856: END IF;
5857:
5858: -- Inserting errors into IBY_TRANSACTION_ERRORS
5859: IF (l_valid = 1) THEN
5860: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
5861: END IF;
5862:
5895: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
5896: l_valResult BOOLEAN;
5897: l_valid NUMBER := 0;
5898: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
5899: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
5900:
5901: BEGIN
5902:
5903: -- Initializing the document record with the Document Payables information
5911: l_docErrorRec.calling_app_doc_unique_ref1 := l_document_rec.calling_app_doc_id1;
5912:
5913: -- Validate invoice reference ...
5914:
5915: -- Inserting errors into IBY_TRANSACTION_ERRORS
5916: IF (l_valid = 1) THEN
5917: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
5918: END IF;
5919:
5952: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
5953: l_valResult BOOLEAN;
5954: l_valid NUMBER := 0;
5955: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
5956: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
5957:
5958: l_max_payment_amt number;
5959:
5960: BEGIN
6003: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
6004: l_valid := 1;
6005: END IF;
6006:
6007: -- Inserting errors into IBY_TRANSACTION_ERRORS
6008: -- The first parameter p_is_online_val takes hardcoded value 'N'.
6009: IF (l_valid = 1) THEN
6010: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
6011: END IF;
6045: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
6046: l_valResult BOOLEAN;
6047: l_valid NUMBER := 0;
6048: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
6049: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
6050:
6051: BEGIN
6052:
6053: -- Initializing the document record with the Document Payables information
6085: l_valid := 1;
6086: END IF;
6087: END IF;
6088:
6089: -- Inserting errors into IBY_TRANSACTION_ERRORS
6090: IF (l_valid = 1) THEN
6091: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
6092: END IF;
6093:
6126: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
6127: l_valResult BOOLEAN;
6128: l_valid NUMBER := 0;
6129: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
6130: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
6131:
6132: BEGIN
6133:
6134: -- Initializing the document record
6191: l_valid := 1;
6192: END IF;
6193: END IF;
6194:
6195: -- Inserting errors into IBY_TRANSACTION_ERRORS
6196: IF (l_valid = 1) THEN
6197: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
6198: END IF;
6199:
6232: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
6233: l_valResult BOOLEAN;
6234: l_valid NUMBER := 0;
6235: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
6236: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
6237:
6238: BEGIN
6239:
6240: -- Initializing the document record with the Document Payables information
6248: l_docErrorRec.calling_app_doc_unique_ref1 := l_document_rec.calling_app_doc_id1;
6249:
6250: -- Validate invoice document sequence numbers
6251:
6252: -- Inserting errors into IBY_TRANSACTION_ERRORS
6253: IF (l_valid = 1) THEN
6254: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
6255: END IF;
6256:
6289: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
6290: l_valResult BOOLEAN;
6291: l_valid NUMBER := 0;
6292: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
6293: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
6294:
6295: BEGIN
6296:
6297: -- Initializing the document record
6349: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
6350: l_valid := 1;
6351: END IF;
6352:
6353: -- Inserting errors into IBY_TRANSACTION_ERRORS
6354: IF (l_valid = 1) THEN
6355: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
6356: END IF;
6357:
6390: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
6391: l_valResult BOOLEAN;
6392: l_valid NUMBER := 0;
6393: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
6394: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
6395:
6396: BEGIN
6397:
6398: -- Initializing the document record
6419: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
6420: l_valid := 1;
6421: END IF;
6422:
6423: -- Inserting errors into IBY_TRANSACTION_ERRORS
6424: IF (l_valid = 1) THEN
6425: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
6426: END IF;
6427:
6460: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
6461: l_valResult BOOLEAN;
6462: l_valid NUMBER := 0;
6463: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
6464: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
6465:
6466: BEGIN
6467:
6468: -- Initializing the payment record
6503: l_valid := 1;
6504: END IF;
6505: end if;
6506:
6507: -- Inserting errors into IBY_TRANSACTION_ERRORS
6508: -- The first parameter p_is_online_val takes hardcoded value 'N'.
6509: IF (l_valid = 1) THEN
6510: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
6511: END IF;
6545: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
6546: l_valResult BOOLEAN;
6547: l_valid NUMBER := 0;
6548: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
6549: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
6550:
6551: BEGIN
6552:
6553: -- Initializing the document record
6574: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
6575: l_valid := 1;
6576: END IF;
6577:
6578: -- Insert errors into IBY_TRANSACTION_ERRORS
6579: IF (l_valid = 1) THEN
6580: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
6581: END IF;
6582:
6615: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
6616: l_valResult BOOLEAN;
6617: l_valid NUMBER := 0;
6618: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
6619: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
6620:
6621: BEGIN
6622:
6623: -- Initializing the document record
6717: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
6718: l_valid := 1;
6719: END IF;
6720:
6721: -- Inserting errors into IBY_TRANSACTION_ERRORS
6722: IF (l_valid = 1) THEN
6723: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
6724: END IF;
6725:
6758: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
6759: l_valResult BOOLEAN;
6760: l_valid NUMBER := 0;
6761: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
6762: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
6763:
6764: BEGIN
6765:
6766: -- Initializing the document record
6787: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
6788: l_valid := 1;
6789: END IF;
6790:
6791: -- Inserting errors into IBY_TRANSACTION_ERRORS
6792: IF (l_valid = 1) THEN
6793: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
6794: END IF;
6795:
6828: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
6829: l_valResult BOOLEAN;
6830: l_valid NUMBER := 0;
6831: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
6832: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
6833:
6834: BEGIN
6835:
6836: -- Initializing the payment record
6870: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
6871: l_valid := 1;
6872: END IF;
6873:
6874: -- Inserting errors into IBY_TRANSACTION_ERRORS
6875: -- The first parameter p_is_online_val takes hardcoded value 'N'.
6876: IF (l_valid = 1) THEN
6877: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
6878: END IF;
6912: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
6913: l_valResult BOOLEAN;
6914: l_valid NUMBER := 0;
6915: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
6916: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
6917:
6918: BEGIN
6919:
6920: -- Initializing the document record
6967: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
6968: l_valid := 1;
6969: END IF;
6970:
6971: -- Insert errors into IBY_TRANSACTION_ERRORS
6972: IF (l_valid = 1) THEN
6973: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
6974: END IF;
6975:
7008: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
7009: l_valResult BOOLEAN;
7010: l_valid NUMBER := 0;
7011: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7012: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7013:
7014: BEGIN
7015:
7016: -- Initializing the document record
7037: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
7038: l_valid := 1;
7039: END IF;
7040:
7041: -- Insert errors into IBY_TRANSACTION_ERRORS
7042: IF (l_valid = 1) THEN
7043: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
7044: END IF;
7045:
7078: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
7079: l_valResult BOOLEAN;
7080: l_valid NUMBER := 0;
7081: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7082: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7083:
7084: BEGIN
7085:
7086: -- Initializing the document record
7107: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
7108: l_valid := 1;
7109: END IF;
7110:
7111: -- Insert errors into IBY_TRANSACTION_ERRORS
7112: IF (l_valid = 1) THEN
7113: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
7114: END IF;
7115:
7148: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
7149: l_valResult BOOLEAN;
7150: l_valid NUMBER := 0;
7151: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7152: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7153:
7154: BEGIN
7155:
7156: -- Initializing the document record with the Document Payables information
7177: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
7178: l_valid := 1;
7179: END IF;
7180:
7181: -- Insert errors into IBY_TRANSACTION_ERRORS
7182: IF (l_valid = 1) THEN
7183: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
7184: END IF;
7185:
7218: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
7219: l_valResult BOOLEAN;
7220: l_valid NUMBER := 0;
7221: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7222: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7223:
7224: BEGIN
7225:
7226: -- Initializing the document record with the Document Payables information
7247: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
7248: l_valid := 1;
7249: END IF;
7250:
7251: -- Insert errors into IBY_TRANSACTION_ERRORS
7252: IF (l_valid = 1) THEN
7253: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
7254: END IF;
7255:
7288: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
7289: l_valResult BOOLEAN;
7290: l_valid NUMBER := 0;
7291: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7292: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7293:
7294: BEGIN
7295:
7296: -- Initializing the document record
7349:
7350: -- Validate target bank branch code
7351: -- by CE
7352:
7353: -- Inserting errors into IBY_TRANSACTION_ERRORS
7354: IF (l_valid = 1) THEN
7355: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
7356: END IF;
7357:
7390: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
7391: l_valResult BOOLEAN;
7392: l_valid NUMBER := 0;
7393: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7394: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7395:
7396: BEGIN
7397:
7398: -- Initializing the document record
7419: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
7420: l_valid := 1;
7421: END IF;
7422:
7423: -- Inserting errors into IBY_TRANSACTION_ERRORS
7424: IF (l_valid = 1) THEN
7425: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
7426: END IF;
7427:
7460: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
7461: l_valResult BOOLEAN;
7462: l_valid NUMBER := 0;
7463: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7464: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7465:
7466: BEGIN
7467:
7468: -- Initializing the payment record
7502: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
7503: l_valid := 1;
7504: END IF;
7505:
7506: -- Inserting errors into IBY_TRANSACTION_ERRORS
7507: -- The first parameter p_is_online_val takes hardcoded value 'N'.
7508: IF (l_valid = 1) THEN
7509: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
7510: END IF;
7544: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
7545: l_valResult BOOLEAN;
7546: l_valid NUMBER := 0;
7547: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7548: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7549:
7550: BEGIN
7551:
7552: -- Initializing the document record
7573: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
7574: l_valid := 1;
7575: END IF;
7576:
7577: -- Insert errors into IBY_TRANSACTION_ERRORS
7578: IF (l_valid = 1) THEN
7579: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
7580: END IF;
7581:
7614: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
7615: l_valResult BOOLEAN;
7616: l_valid NUMBER := 0;
7617: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7618: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7619:
7620: BEGIN
7621:
7622: -- Initializing the document record
7643: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
7644: l_valid := 1;
7645: END IF;
7646:
7647: -- Insert errors into IBY_TRANSACTION_ERRORS
7648: IF (l_valid = 1) THEN
7649: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
7650: END IF;
7651:
7684: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
7685: l_valResult BOOLEAN;
7686: l_valid NUMBER := 0;
7687: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7688: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7689:
7690: l_max_nacha_amt NUMBER;
7691:
7692: BEGIN
7719: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
7720: l_valid := 1;
7721: END IF;
7722:
7723: -- Inserting errors into IBY_TRANSACTION_ERRORS
7724: -- The first parameter p_is_online_val takes hardcoded value 'N'.
7725: IF (l_valid = 1) THEN
7726: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
7727: END IF;
7768: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
7769: l_valResult BOOLEAN;
7770: l_valid NUMBER := 0;
7771: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7772: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7773:
7774: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.ECE_DOC';
7775: BEGIN
7776:
7818:
7819: END IF;
7820:
7821: /*
7822: * Insert errors into IBY_TRANSACTION_ERRORS
7823: */
7824: IF (l_valid = 1) THEN
7825: IBY_VALIDATIONSETS_PUB.
7826: insert_transaction_errors(p_is_online_val,l_docErrorTab);
7869: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
7870: l_valResult BOOLEAN;
7871: l_valid NUMBER := 0;
7872: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7873: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7874:
7875: l_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE;
7876: l_bank_edi_id_number HZ_CONTACT_POINTS.edi_id_number%TYPE;
7877: l_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE;
7969:
7970: END IF;
7971:
7972: /*
7973: * Insert errors into IBY_TRANSACTION_ERRORS
7974: */
7975: IF (l_valid = 1) THEN
7976: IBY_VALIDATIONSETS_PUB.
7977: insert_transaction_errors(p_is_online_val,l_docErrorTab);
8020: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
8021: l_valResult BOOLEAN;
8022: l_valid NUMBER := 0;
8023: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
8024: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
8025:
8026: l_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE;
8027: l_trxn_handling IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE;
8028: l_edi_pmt_format IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE;
8246:
8247: END IF; -- if pmt method = 'ACH'
8248:
8249: /*
8250: * Insert errors into IBY_TRANSACTION_ERRORS
8251: */
8252: IF (l_valid = 1) THEN
8253: IBY_VALIDATIONSETS_PUB.
8254: insert_transaction_errors(p_is_online_val,l_docErrorTab);
8298: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
8299: l_valResult BOOLEAN;
8300: l_valid NUMBER := 0;
8301: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
8302: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
8303:
8304: l_field_name VARCHAR2(500);
8305: l_field_value VARCHAR2(500);
8306:
8414: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
8415: l_valResult BOOLEAN;
8416: l_valid NUMBER := 0;
8417: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
8418: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
8419:
8420: l_field_name VARCHAR2(500);
8421: l_field_value VARCHAR2(500);
8422:
8530: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
8531: l_valResult BOOLEAN;
8532: l_valid NUMBER := 0;
8533: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
8534: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
8535:
8536: l_field_name VARCHAR2(500);
8537: l_field_value VARCHAR2(500);
8538: l_min_length number;
8674: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
8675: l_valResult BOOLEAN;
8676: l_valid NUMBER := 0;
8677: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
8678: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
8679:
8680: l_field_name VARCHAR2(500);
8681: l_field_value VARCHAR2(500);
8682:
8802: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
8803: l_valResult BOOLEAN;
8804: l_valid NUMBER := 0;
8805: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
8806: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
8807:
8808: l_field_name VARCHAR2(500);
8809: l_field_value VARCHAR2(500);
8810:
8926: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
8927: l_valResult BOOLEAN;
8928: l_valid NUMBER := 0;
8929: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
8930: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
8931:
8932: l_field_name VARCHAR2(500);
8933: l_field_value VARCHAR2(500);
8934:
9050: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
9051: l_valResult BOOLEAN;
9052: l_valid NUMBER := 0;
9053: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
9054: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
9055:
9056: l_field_name VARCHAR2(500);
9057: l_field_value VARCHAR2(500);
9058:
9174: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
9175: l_valResult BOOLEAN;
9176: l_valid NUMBER := 0;
9177: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
9178: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
9179:
9180: l_field_name VARCHAR2(500);
9181: l_field_value VARCHAR2(500);
9182:
9298: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
9299: l_valResult BOOLEAN;
9300: l_valid NUMBER := 0;
9301: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
9302: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
9303:
9304: l_field_name VARCHAR2(500);
9305: l_field_value VARCHAR2(500);
9306:
9422: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
9423: l_valResult BOOLEAN;
9424: l_valid NUMBER := 0;
9425: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
9426: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
9427:
9428: l_field_name VARCHAR2(500);
9429: l_field_value VARCHAR2(500);
9430:
9546: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
9547: l_valResult BOOLEAN;
9548: l_valid NUMBER := 0;
9549: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
9550: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
9551:
9552: l_field_name VARCHAR2(500);
9553: l_field_value VARCHAR2(500);
9554:
9670: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
9671: l_valResult BOOLEAN;
9672: l_valid NUMBER := 0;
9673: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
9674: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
9675:
9676: l_field_name VARCHAR2(500);
9677: l_field_value VARCHAR2(500);
9678:
9794: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
9795: l_valResult BOOLEAN;
9796: l_valid NUMBER := 0;
9797: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
9798: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
9799:
9800: l_field_name VARCHAR2(500);
9801: l_field_value VARCHAR2(500);
9802:
9918: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
9919: l_valResult BOOLEAN;
9920: l_valid NUMBER := 0;
9921: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
9922: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
9923:
9924: l_field_name VARCHAR2(500);
9925: l_field_value VARCHAR2(500);
9926:
10042: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
10043: l_valResult BOOLEAN;
10044: l_valid NUMBER := 0;
10045: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
10046: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
10047:
10048: l_field_name VARCHAR2(500);
10049: l_field_value VARCHAR2(500);
10050:
10166: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
10167: l_valResult BOOLEAN;
10168: l_valid NUMBER := 0;
10169: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
10170: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
10171:
10172: l_field_name VARCHAR2(500);
10173: l_field_value VARCHAR2(500);
10174:
10290: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
10291: l_valResult BOOLEAN;
10292: l_valid NUMBER := 0;
10293: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
10294: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
10295:
10296: l_field_name VARCHAR2(500);
10297: l_field_value VARCHAR2(500);
10298:
10417: l_charval_rec IBY_VALIDATIONSETS_PUB.charValRecType;
10418: l_valResult BOOLEAN;
10419: l_valid NUMBER := 0;
10420: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
10421: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
10422: l_invalid_chars_list VARCHAR2(3000);
10423: l_valid_chars_list VARCHAR2(3000);
10424:
10425: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
10763: l_valid_chars_list, l_invalid_chars_list,
10764: l_docErrorRec, l_docErrorTab);
10765:
10766: /*
10767: * Insert errors into IBY_TRANSACTION_ERRORS table.
10768: */
10769: IF (l_docErrorTab.COUNT > 0) THEN
10770:
10771: l_valid := 1;
10804: *---------------------------------------------------------------------*/
10805:
10806: PROCEDURE validate_uri_using_modulus10(s IN VARCHAR2,
10807: x_valResult OUT NOCOPY BOOLEAN,
10808: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE)
10809: IS
10810:
10811: weight number := 0;
10812: check_digit number := 0;
10885: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
10886: l_valResult BOOLEAN;
10887: l_valid NUMBER := 0;
10888: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
10889: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
10890:
10891: BEGIN
10892: -- Initializing the document record
10893: IBY_VALIDATIONSETS_PUB.initDocumentData(p_document_id,l_document_rec,p_is_online_val);
10912: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
10913: l_valid := 1;
10914: END IF;
10915:
10916: -- Inserting errors into IBY_TRANSACTION_ERRORS
10917: IF (l_valid = 1) THEN
10918: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
10919: END IF;
10920:
10955: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
10956: l_valResult BOOLEAN;
10957: l_valid NUMBER := 0;
10958: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
10959: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
10960:
10961: BEGIN
10962:
10963: -- Initializing the document record
10983: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
10984: l_valid := 1;
10985: END IF;
10986:
10987: -- Inserting errors into IBY_TRANSACTION_ERRORS
10988: IF (l_valid = 1) THEN
10989: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
10990: END IF;
10991:
11027: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
11028: l_valResult BOOLEAN;
11029: l_valid NUMBER := 0;
11030: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
11031: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
11032:
11033: BEGIN
11034: -- Initializing the document record
11035: IBY_VALIDATIONSETS_PUB.initDocumentData(p_document_id,l_document_rec,p_is_online_val);
11054: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
11055: l_valid := 1;
11056: END IF;
11057:
11058: -- Inserting errors into IBY_TRANSACTION_ERRORS
11059: IF (l_valid = 1) THEN
11060: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
11061: END IF;
11062:
11096: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
11097: l_valResult BOOLEAN;
11098: l_valid NUMBER := 0;
11099: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
11100: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
11101:
11102: BEGIN
11103: -- Initializing the payment record
11104: IBY_VALIDATIONSETS_PUB.initPaymentData(p_payment_id,l_payment_rec);
11122: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
11123: l_valid := 1;
11124: END IF;
11125:
11126: -- Inserting errors into IBY_TRANSACTION_ERRORS
11127: IF (l_valid = 1) THEN
11128: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
11129: END IF;
11130:
11164: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
11165: l_valResult BOOLEAN;
11166: l_valid NUMBER := 0;
11167: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
11168: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
11169:
11170: BEGIN
11171: -- Initializing the payment record
11172: IBY_VALIDATIONSETS_PUB.initPaymentData(p_payment_id,l_payment_rec);
11232: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
11233: l_valid := 1;
11234: END IF;
11235:
11236: -- Inserting errors into IBY_TRANSACTION_ERRORS
11237: IF (l_valid = 1) THEN
11238: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
11239: END IF;
11240:
11265: *---------------------------------------------------------------------*/
11266: PROCEDURE xxno_chk_mod_10_11 (
11267: p_kid_nr IN varchar2,
11268: x_valResult OUT NOCOPY BOOLEAN,
11269: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE)
11270: IS
11271: v_invoice_id varchar2(50);
11272: v_kid_nr varchar2(50);
11273: e_kid_feil exception;