[Home] [Help]
7:
8:
9: --
10: -- List of possible transaction types
11: -- These are used to insert into the IBY_TRANSACTION_ERRORS table.
12: --
13: TRANS_TYPE_DOC CONSTANT VARCHAR2(100) := 'DOCUMENT_PAYABLE';
14: TRANS_TYPE_PAY CONSTANT VARCHAR2(100) := 'PAYMENT';
15: TRANS_TYPE_INS CONSTANT VARCHAR2(100) := 'PAYMENT_INSTRUCTION';
15: TRANS_TYPE_INS CONSTANT VARCHAR2(100) := 'PAYMENT_INSTRUCTION';
16:
17: --
18: -- List of possible error types
19: -- These are used to insert into the IBY_TRANSACTION_ERRORS table.
20: --
21: ERROR_TYPE_VALIDATION CONSTANT VARCHAR2(100) := 'VALIDATION';
22: ERROR_TYPE_BANK CONSTANT VARCHAR2(100) := 'BANK';
23:
23:
24:
25: PROCEDURE validate_uri_using_modulus10(s IN VARCHAR2,
26: x_valResult OUT NOCOPY BOOLEAN,
27: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE);
28:
29: PROCEDURE xxno_chk_mod_10_11
30: (p_kid_nr IN varchar2,
31: x_valResult OUT NOCOPY BOOLEAN,
28:
29: PROCEDURE xxno_chk_mod_10_11
30: (p_kid_nr IN varchar2,
31: x_valResult OUT NOCOPY BOOLEAN,
32: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE);
33:
34: /*--------------------------------------------------------------------
35: | NAME:
36: | CITI_AT_EFT_DOM_PAYEE
61: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
62: l_valResult BOOLEAN;
63: l_valid NUMBER := 0;
64: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
65: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
66:
67: BEGIN
68:
69: -- Initializing the document record
123: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
124: l_valid := 1;
125: END IF;
126:
127: -- Insert errors into IBY_TRANSACTION_ERRORS
128: IF (l_valid = 1) THEN
129: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
130: END IF;
131:
164: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
165: l_valResult BOOLEAN;
166: l_valid NUMBER := 0;
167: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
168: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
169:
170: BEGIN
171:
172: -- Initializing the document record
193: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
194: l_valid := 1;
195: END IF;
196:
197: -- Inserting errors into IBY_TRANSACTION_ERRORS
198: IF (l_valid = 1) THEN
199: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
200: END IF;
201:
234: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
235: l_valResult BOOLEAN;
236: l_valid NUMBER := 0;
237: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
238: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
239:
240: BEGIN
241:
242: -- Initializing the document record
268: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
269: l_valid := 1;
270: END IF;
271:
272: -- Insert errors into IBY_TRANSACTION_ERRORS
273: IF (l_valid = 1) THEN
274: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
275: END IF;
276:
309: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
310: l_valResult BOOLEAN;
311: l_valid NUMBER := 0;
312: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
313: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
314:
315: BEGIN
316:
317: -- Initializing the document record
353: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
354: l_valid := 1;
355: END IF;
356:
357: -- Insert errors into IBY_TRANSACTION_ERRORS
358: IF (l_valid = 1) THEN
359: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
360: END IF;
361:
394: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
395: l_valResult BOOLEAN;
396: l_valid NUMBER := 0;
397: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
398: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
399:
400: BEGIN
401:
402: -- Initializing the document record
438: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
439: l_valid := 1;
440: END IF;
441:
442: -- Insert errors into IBY_TRANSACTION_ERRORS
443: IF (l_valid = 1) THEN
444: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
445: END IF;
446:
479: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
480: l_valResult BOOLEAN;
481: l_valid NUMBER := 0;
482: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
483: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
484:
485: BEGIN
486:
487: -- Initializing the document record
555: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
556: l_valid := 1;
557: END IF;
558:
559: -- Inserting errors into IBY_TRANSACTION_ERRORS
560: IF (l_valid = 1) THEN
561: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
562: END IF;
563:
596: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
597: l_valResult BOOLEAN;
598: l_valid NUMBER := 0;
599: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
600: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
601:
602: l_max_ach_amt NUMBER;
603:
604: BEGIN
646: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
647: l_valid := 1;
648: END IF;
649:
650: -- Inserting errors into IBY_TRANSACTION_ERRORS
651: -- The first parameter p_is_online_val takes hardcoded value 'N'.
652: IF (l_valid = 1) THEN
653: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
654: END IF;
688: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
689: l_valResult BOOLEAN;
690: l_valid NUMBER := 0;
691: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
692: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
693:
694: BEGIN
695:
696: -- Initializing the document record
717: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
718: l_valid := 1;
719: END IF;
720:
721: -- Inserting errors into IBY_TRANSACTION_ERRORS
722: IF (l_valid = 1) THEN
723: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
724: END IF;
725:
758: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
759: l_valResult BOOLEAN;
760: l_valid NUMBER := 0;
761: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
762: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
763:
764: BEGIN
765:
766: -- Initializing the document record
816:
817: -- Validate EFT cost code
818: -- Not necessary. Combined into Validate Supplier cost code.
819:
820: -- Inserting errors into IBY_TRANSACTION_ERRORS
821: IF (l_valid = 1) THEN
822: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
823: END IF;
824:
857: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
858: l_valResult BOOLEAN;
859: l_valid NUMBER := 0;
860: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
861: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
862:
863: BEGIN
864:
865: -- Initializing the document record
892:
893: -- Validate number of detail records
894: -- Not coded. This has been moved to the instruction level.
895:
896: -- Inserting errors into IBY_TRANSACTION_ERRORS
897: IF (l_valid = 1) THEN
898: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
899: END IF;
900:
933: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
934: l_valResult BOOLEAN;
935: l_valid NUMBER := 0;
936: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
937: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
938:
939: l_max_check_amt NUMBER;
940: l_max_pay_reason_cnt NUMBER;
941:
997: ---------------------------------------------------------------------------*/
998:
999: -- Bug 5411492 changes end here
1000:
1001: -- Inserting errors into IBY_TRANSACTION_ERRORS
1002: -- The first parameter p_is_online_val takes hardcoded value 'N'.
1003: IF (l_valid = 1) THEN
1004: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1005: END IF;
1039: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
1040: l_valResult BOOLEAN;
1041: l_valid NUMBER := 0;
1042: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1043: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1044:
1045: l_max_num_of_docs NUMBER;
1046:
1047: BEGIN
1074: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1075: l_valid := 1;
1076: END IF;
1077:
1078: -- Inserting errors into IBY_TRANSACTION_ERRORS
1079: -- The first parameter p_is_online_val takes hardcoded value 'N'.
1080: IF (l_valid = 1) THEN
1081: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1082: END IF;
1116: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
1117: l_valResult BOOLEAN;
1118: l_valid NUMBER := 0;
1119: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1120: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1121:
1122: BEGIN
1123:
1124: -- Initializing the document record
1321: else
1322: null;
1323: end if;
1324:
1325: -- Insert errors into IBY_TRANSACTION_ERRORS
1326: IF (l_valid = 1) THEN
1327: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
1328: END IF;
1329:
1362: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
1363: l_valResult BOOLEAN;
1364: l_valid NUMBER := 0;
1365: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1366: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1367:
1368: BEGIN
1369:
1370: -- Initializing the document record
1406: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1407: l_valid := 1;
1408: END IF;
1409:
1410: -- Inserting errors into IBY_TRANSACTION_ERRORS
1411: IF (l_valid = 1) THEN
1412: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
1413: END IF;
1414:
1447: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
1448: l_valResult BOOLEAN;
1449: l_valid NUMBER := 0;
1450: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1451: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1452:
1453: BEGIN
1454:
1455: -- Initializing the payment record
1474: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1475: l_valid := 1;
1476: END IF;
1477:
1478: -- Inserting errors into IBY_TRANSACTION_ERRORS
1479: -- The first parameter p_is_online_val takes hardcoded value 'N'.
1480: IF (l_valid = 1) THEN
1481: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1482: END IF;
1516: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
1517: l_valResult BOOLEAN;
1518: l_valid NUMBER := 0;
1519: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1520: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1521:
1522: BEGIN
1523:
1524: -- Initializing the payment record
1569:
1570: -- Validate supplier name and address
1571: -- Note coded. This will be handled in a separate validation set for char set.
1572:
1573: -- Insert errors into IBY_TRANSACTION_ERRORS
1574: IF (l_valid = 1) THEN
1575: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
1576: END IF;
1577:
1610: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
1611: l_valResult BOOLEAN;
1612: l_valid NUMBER := 0;
1613: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1614: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1615:
1616: BEGIN
1617:
1618: -- Initializing the payment record
1762:
1763: -- Validate bank account type for SAD payments
1764: -- Ignore: SAD format is obsolete.
1765:
1766: -- Insert errors into IBY_TRANSACTION_ERRORS
1767: IF (l_valid = 1) THEN
1768: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
1769: END IF;
1770:
1803: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
1804: l_valResult BOOLEAN;
1805: l_valid NUMBER := 0;
1806: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1807: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1808:
1809: BEGIN
1810:
1811: -- Initializing the document record
1865: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1866: l_valid := 1;
1867: END IF;
1868:
1869: -- Inserting errors into IBY_TRANSACTION_ERRORS
1870: IF (l_valid = 1) THEN
1871: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
1872: END IF;
1873:
1906: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
1907: l_valResult BOOLEAN;
1908: l_valid NUMBER := 0;
1909: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1910: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1911:
1912: BEGIN
1913:
1914: -- Initializing the document record
1935: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1936: l_valid := 1;
1937: END IF;
1938:
1939: -- Inserting errors into IBY_TRANSACTION_ERRORS
1940: IF (l_valid = 1) THEN
1941: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
1942: END IF;
1943:
1976: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
1977: l_valResult BOOLEAN;
1978: l_valid NUMBER := 0;
1979: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1980: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1981:
1982: BEGIN
1983:
1984: -- Initializing the document record
2037: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2038: l_valid := 1;
2039: END IF;
2040:
2041: -- Inserting errors into IBY_TRANSACTION_ERRORS
2042: IF (l_valid = 1) THEN
2043: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
2044: END IF;
2045:
2078: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
2079: l_valResult BOOLEAN;
2080: l_valid NUMBER := 0;
2081: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2082: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2083:
2084: BEGIN
2085:
2086: -- Initializing the document record
2107: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2108: l_valid := 1;
2109: END IF;
2110:
2111: -- Inserting errors into IBY_TRANSACTION_ERRORS
2112: IF (l_valid = 1) THEN
2113: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
2114: END IF;
2115:
2148: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
2149: l_valResult BOOLEAN;
2150: l_valid NUMBER := 0;
2151: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2152: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2153:
2154: BEGIN
2155:
2156: -- Initializing the document record
2209: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2210: l_valid := 1;
2211: END IF;
2212:
2213: -- Inserting errors into IBY_TRANSACTION_ERRORS
2214: IF (l_valid = 1) THEN
2215: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
2216: END IF;
2217:
2250: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
2251: l_valResult BOOLEAN;
2252: l_valid NUMBER := 0;
2253: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2254: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2255:
2256: BEGIN
2257:
2258: -- Initializing the payment record
2277: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2278: l_valid := 1;
2279: END IF;
2280:
2281: -- Inserting errors into IBY_TRANSACTION_ERRORS
2282: IF (l_valid = 1) THEN
2283: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2284: END IF;
2285:
2318: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
2319: l_valResult BOOLEAN;
2320: l_valid NUMBER := 0;
2321: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2322: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2323:
2324: BEGIN
2325:
2326: -- Initializing the document record
2379: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2380: l_valid := 1;
2381: END IF;
2382:
2383: -- Inserting errors into IBY_TRANSACTION_ERRORS
2384: IF (l_valid = 1) THEN
2385: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
2386: END IF;
2387:
2420: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
2421: l_valResult BOOLEAN;
2422: l_valid NUMBER := 0;
2423: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2424: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2425:
2426: BEGIN
2427:
2428: -- Initializing the document record
2467: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2468: l_valid := 1;
2469: END IF;
2470:
2471: -- Inserting errors into IBY_TRANSACTION_ERRORS
2472: IF (l_valid = 1) THEN
2473: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
2474: END IF;
2475:
2508: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
2509: l_valResult BOOLEAN;
2510: l_valid NUMBER := 0;
2511: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2512: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2513:
2514: BEGIN
2515:
2516: -- Initializing the document record
2601: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2602: l_valid := 1;
2603: END IF;
2604:
2605: -- Inserting errors into IBY_TRANSACTION_ERRORS
2606: IF (l_valid = 1) THEN
2607: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
2608: END IF;
2609: */
2644: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
2645: l_valResult BOOLEAN;
2646: l_valid NUMBER := 0;
2647: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2648: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2649:
2650: BEGIN
2651:
2652: -- Initializing the payment record
2674:
2675: -- Validate document country
2676: -- Not coded. The validation has been moved to the document level at payee validation.
2677:
2678: -- Inserting errors into IBY_TRANSACTION_ERRORS
2679: -- The first parameter p_is_online_val takes hardcoded value 'N'.
2680: IF (l_valid = 1) THEN
2681: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2682: END IF;
2717: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
2718: l_valResult BOOLEAN;
2719: l_valid NUMBER := 0;
2720: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2721: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2722:
2723: BEGIN
2724:
2725: -- Initializing the payment record
2742: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2743: l_valid := 1;
2744: END IF;
2745:
2746: -- Inserting errors into IBY_TRANSACTION_ERRORS
2747: IF (l_valid = 1) THEN
2748: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
2749: END IF;
2750:
2783: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
2784: l_valResult BOOLEAN;
2785: l_valid NUMBER := 0;
2786: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2787: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2788:
2789: BEGIN
2790:
2791: -- Initializing the payment record
2826: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2827: l_valid := 1;
2828: END IF;
2829:
2830: -- Inserting errors into IBY_TRANSACTION_ERRORS
2831: IF (l_valid = 1) THEN
2832: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
2833: END IF;
2834:
2867: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
2868: l_valResult BOOLEAN;
2869: l_valid NUMBER := 0;
2870: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2871: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2872:
2873: BEGIN
2874:
2875: -- Initializing the payment record
2896: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2897: l_valid := 1;
2898: END IF;
2899:
2900: -- Inserting errors into IBY_TRANSACTION_ERRORS
2901: IF (l_valid = 1) THEN
2902: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
2903: END IF;
2904:
2937: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
2938: l_valResult BOOLEAN;
2939: l_valid NUMBER := 0;
2940: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2941: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2942:
2943: BEGIN
2944:
2945: -- Initializing the payment record
3036: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
3037: l_valResult BOOLEAN;
3038: l_valid NUMBER := 0;
3039: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3040: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3041:
3042: BEGIN
3043:
3044: -- Initializing the document record
3095: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3096: l_valid := 1;
3097: END IF;
3098:
3099: -- Inserting errors into IBY_TRANSACTION_ERRORS
3100: IF (l_valid = 1) THEN
3101: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
3102: END IF;
3103:
3136: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
3137: l_valResult BOOLEAN;
3138: l_valid NUMBER := 0;
3139: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3140: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3141:
3142: BEGIN
3143:
3144: -- Initializing the payment record
3163: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3164: l_valid := 1;
3165: END IF;
3166:
3167: -- Inserting errors into IBY_TRANSACTION_ERRORS
3168: -- The first parameter p_is_online_val takes hardcoded value 'N'.
3169: IF (l_valid = 1) THEN
3170: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3171: END IF;
3205: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
3206: l_valResult BOOLEAN;
3207: l_valid NUMBER := 0;
3208: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3209: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3210:
3211: BEGIN
3212:
3213: -- Initializing the document record
3288: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3289: l_valid := 1;
3290: END IF;
3291:
3292: -- Insert errors into IBY_TRANSACTION_ERRORS
3293: IF (l_valid = 1) THEN
3294: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
3295: END IF;
3296:
3329: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
3330: l_valResult BOOLEAN;
3331: l_valid NUMBER := 0;
3332: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3333: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3334:
3335: BEGIN
3336:
3337: -- Initializing the document record
3358: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3359: l_valid := 1;
3360: END IF;
3361:
3362: -- Inserting errors into IBY_TRANSACTION_ERRORS
3363: IF (l_valid = 1) THEN
3364: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
3365: END IF;
3366:
3399: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
3400: l_valResult BOOLEAN;
3401: l_valid NUMBER := 0;
3402: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3403: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3404:
3405: BEGIN
3406:
3407: -- Initializing the payment record
3426: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3427: l_valid := 1;
3428: END IF;
3429:
3430: -- Inserting errors into IBY_TRANSACTION_ERRORS
3431: -- The first parameter p_is_online_val takes hardcoded value 'N'.
3432: IF (l_valid = 1) THEN
3433: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3434: END IF;
3468: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
3469: l_valResult BOOLEAN;
3470: l_valid NUMBER := 0;
3471: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3472: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3473:
3474: BEGIN
3475:
3476: -- Initializing the document record
3515: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3516: l_valid := 1;
3517: END IF;
3518:
3519: -- Insert errors into IBY_TRANSACTION_ERRORS
3520: IF (l_valid = 1) THEN
3521: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
3522: END IF;
3523:
3556: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
3557: l_valResult BOOLEAN;
3558: l_valid NUMBER := 0;
3559: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3560: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3561:
3562: BEGIN
3563:
3564: -- Initializing the document record
3585: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3586: l_valid := 1;
3587: END IF;
3588:
3589: -- Insert errors into IBY_TRANSACTION_ERRORS
3590: IF (l_valid = 1) THEN
3591: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
3592: END IF;
3593:
3626: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
3627: l_valResult BOOLEAN;
3628: l_valid NUMBER := 0;
3629: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3630: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3631:
3632: BEGIN
3633:
3634: -- Initializing the payment record
3653: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3654: l_valid := 1;
3655: END IF;
3656:
3657: -- Inserting errors into IBY_TRANSACTION_ERRORS
3658: -- The first parameter p_is_online_val takes hardcoded value 'N'.
3659: IF (l_valid = 1) THEN
3660: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3661: END IF;
3695: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
3696: l_valResult BOOLEAN;
3697: l_valid NUMBER := 0;
3698: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3699: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3700:
3701: BEGIN
3702:
3703: -- Initializing the document record
3751: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3752: l_valid := 1;
3753: END IF;
3754:
3755: -- Inserting errors into IBY_TRANSACTION_ERRORS
3756: IF (l_valid = 1) THEN
3757: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
3758: END IF;
3759:
3792: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
3793: l_valResult BOOLEAN;
3794: l_valid NUMBER := 0;
3795: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3796: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3797:
3798: BEGIN
3799:
3800: -- Initializing the document record
3821: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3822: l_valid := 1;
3823: END IF;
3824:
3825: -- Inserting errors into IBY_TRANSACTION_ERRORS
3826: IF (l_valid = 1) THEN
3827: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
3828: END IF;
3829:
3862: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
3863: l_valResult BOOLEAN;
3864: l_valid NUMBER := 0;
3865: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3866: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3867:
3868: l_max_ach_amt NUMBER;
3869:
3870: BEGIN
3897: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3898: l_valid := 1;
3899: END IF;
3900:
3901: -- Inserting errors into IBY_TRANSACTION_ERRORS
3902: -- The first parameter p_is_online_val takes hardcoded value 'N'.
3903: IF (l_valid = 1) THEN
3904: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3905: END IF;
3939: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
3940: l_valResult BOOLEAN;
3941: l_valid NUMBER := 0;
3942: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3943: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3944:
3945: BEGIN
3946:
3947: -- Initializing the document record
3992:
3993: -- Validate target bank account number
3994: -- by CE
3995:
3996: -- Insert errors into IBY_TRANSACTION_ERRORS
3997: IF (l_valid = 1) THEN
3998: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
3999: END IF;
4000:
4033: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
4034: l_valResult BOOLEAN;
4035: l_valid NUMBER := 0;
4036: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4037: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4038:
4039: BEGIN
4040:
4041: -- Initializing the document record
4062: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4063: l_valid := 1;
4064: END IF;
4065:
4066: -- Insert errors into IBY_TRANSACTION_ERRORS
4067: IF (l_valid = 1) THEN
4068: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
4069: END IF;
4070:
4103: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
4104: l_valResult BOOLEAN;
4105: l_valid NUMBER := 0;
4106: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4107: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4108:
4109: BEGIN
4110:
4111: -- Initializing the payment record
4130: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4131: l_valid := 1;
4132: END IF;
4133:
4134: -- Inserting errors into IBY_TRANSACTION_ERRORS
4135: -- The first parameter p_is_online_val takes hardcoded value 'N'.
4136: IF (l_valid = 1) THEN
4137: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4138: END IF;
4172: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
4173: l_valResult BOOLEAN;
4174: l_valid NUMBER := 0;
4175: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4176: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4177:
4178: BEGIN
4179:
4180: -- Initializing the document record
4210:
4211: -- Validate target bank account number
4212: -- by CE
4213:
4214: -- Insert errors into IBY_TRANSACTION_ERRORS
4215: IF (l_valid = 1) THEN
4216: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
4217: END IF;
4218:
4251: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
4252: l_valResult BOOLEAN;
4253: l_valid NUMBER := 0;
4254: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4255: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4256: l_validTrxnCodes VARCHAR2(100) := '0001, 0003, 0004';
4257:
4258: BEGIN
4259:
4281: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4282: l_valid := 1;
4283: END IF;
4284:
4285: -- Insert errors into IBY_TRANSACTION_ERRORS
4286: IF (l_valid = 1) THEN
4287: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
4288: END IF;
4289:
4322: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
4323: l_valResult BOOLEAN;
4324: l_valid NUMBER := 0;
4325: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4326: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4327:
4328: BEGIN
4329:
4330: -- Initializing the payment record
4349: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4350: l_valid := 1;
4351: END IF;
4352:
4353: -- Inserting errors into IBY_TRANSACTION_ERRORS
4354: -- The first parameter p_is_online_val takes hardcoded value 'N'.
4355: IF (l_valid = 1) THEN
4356: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4357: END IF;
4391: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
4392: l_valResult BOOLEAN;
4393: l_valid NUMBER := 0;
4394: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4395: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4396:
4397: BEGIN
4398:
4399: -- Initializing the document record
4470: END IF;
4471:
4472: -- by CE, validation on digits only.
4473:
4474: -- Inserting errors into IBY_TRANSACTION_ERRORS
4475: IF (l_valid = 1) THEN
4476: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
4477: END IF;
4478:
4511: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
4512: l_valResult BOOLEAN;
4513: l_valid NUMBER := 0;
4514: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4515: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4516:
4517: BEGIN
4518:
4519: -- Initializing the payment record
4568: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4569: l_valid := 1;
4570: END IF;
4571:
4572: -- Inserting errors into IBY_TRANSACTION_ERRORS
4573: -- The first parameter p_is_online_val takes hardcoded value 'N'.
4574: IF (l_valid = 1) THEN
4575: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4576: END IF;
4610: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
4611: l_valResult BOOLEAN;
4612: l_valid NUMBER := 0;
4613: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4614: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4615:
4616: BEGIN
4617:
4618: -- Initializing the document record
4639: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4640: l_valid := 1;
4641: END IF;
4642:
4643: -- Inserting errors into IBY_TRANSACTION_ERRORS
4644: IF (l_valid = 1) THEN
4645: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
4646: END IF;
4647:
4680: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
4681: l_valResult BOOLEAN;
4682: l_valid NUMBER := 0;
4683: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4684: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4685:
4686: BEGIN
4687:
4688: -- Initializing the document record
4766: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4767: l_valid := 1;
4768: END IF;
4769:
4770: -- Insert errors into IBY_TRANSACTION_ERRORS
4771: IF (l_valid = 1) THEN
4772: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
4773: END IF;
4774:
4807: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
4808: l_valResult BOOLEAN;
4809: l_valid NUMBER := 0;
4810: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4811: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4812:
4813: BEGIN
4814:
4815: -- Initializing the payment record
4849: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4850: l_valid := 1;
4851: END IF;
4852:
4853: -- Insert errors into IBY_TRANSACTION_ERRORS
4854: -- The first parameter p_is_online_val takes hardcoded value 'N'.
4855: IF (l_valid = 1) THEN
4856: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4857: END IF;
4891: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
4892: l_valResult BOOLEAN;
4893: l_valid NUMBER := 0;
4894: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4895: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4896:
4897: BEGIN
4898:
4899: -- Initializing the document record
4953: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4954: l_valid := 1;
4955: END IF;
4956:
4957: -- Insert errors into IBY_TRANSACTION_ERRORS
4958: IF (l_valid = 1) THEN
4959: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
4960: END IF;
4961:
4994: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
4995: l_valResult BOOLEAN;
4996: l_valid NUMBER := 0;
4997: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4998: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4999:
5000: BEGIN
5001:
5002: -- Initializing the document record
5044:
5045: -- Validate supplier bank account name alternate
5046: -- by CE
5047:
5048: -- Insert errors into IBY_TRANSACTION_ERRORS
5049: IF (l_valid = 1) THEN
5050: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
5051: END IF;
5052:
5087: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
5088: l_valResult BOOLEAN;
5089: l_valid NUMBER := 0;
5090: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
5091: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
5092:
5093: BEGIN
5094:
5095: -- Initializing the document record
5114: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec,l_docErrorTab);
5115: l_valid := 1;
5116: END IF;
5117:
5118: -- Inserting errors into IBY_TRANSACTION_ERRORS
5119: IF (l_valid = 1) THEN
5120: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
5121: END IF;
5122:
5155: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
5156: l_valResult BOOLEAN;
5157: l_valid NUMBER := 0;
5158: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
5159: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
5160:
5161: BEGIN
5162:
5163: -- Initializing the document record
5199: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
5200: l_valid := 1;
5201: END IF;
5202:
5203: -- Inserting errors into IBY_TRANSACTION_ERRORS
5204: IF (l_valid = 1) THEN
5205: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
5206: END IF;
5207:
5240: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
5241: l_valResult BOOLEAN;
5242: l_valid NUMBER := 0;
5243: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
5244: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
5245:
5246: BEGIN
5247:
5248: -- Initializing the document record
5284: l_valid := 1;
5285: END IF;
5286: */
5287:
5288: -- Inserting errors into IBY_TRANSACTION_ERRORS
5289: IF (l_valid = 1) THEN
5290: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
5291: END IF;
5292:
5325: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
5326: l_valResult BOOLEAN;
5327: l_valid NUMBER := 0;
5328: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
5329: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
5330:
5331: BEGIN
5332:
5333: -- Initializing the payment record
5352: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
5353: l_valid := 1;
5354: END IF;
5355:
5356: -- Inserting errors into IBY_TRANSACTION_ERRORS
5357: -- The first parameter p_is_online_val takes hardcoded value 'N'.
5358: IF (l_valid = 1) THEN
5359: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
5360: END IF;
5394: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
5395: l_valResult BOOLEAN;
5396: l_valid NUMBER := 0;
5397: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
5398: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
5399:
5400: BEGIN
5401:
5402: -- Initializing the document record with the Document Payables information
5434: l_valid := 1;
5435: END IF;
5436: END IF;
5437:
5438: -- Inserting errors into IBY_TRANSACTION_ERRORS
5439: IF (l_valid = 1) THEN
5440: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
5441: END IF;
5442:
5475: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
5476: l_valResult BOOLEAN;
5477: l_valid NUMBER := 0;
5478: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
5479: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
5480:
5481: BEGIN
5482:
5483: -- Initializing the document record
5576: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
5577: l_valid := 1;
5578: END IF;
5579:
5580: -- Inserting errors into IBY_TRANSACTION_ERRORS
5581: IF (l_valid = 1) THEN
5582: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
5583: END IF;
5584:
5617: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
5618: l_valResult BOOLEAN;
5619: l_valid NUMBER := 0;
5620: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
5621: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
5622:
5623: l_max_payment_amt number;
5624:
5625: BEGIN
5668: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
5669: l_valid := 1;
5670: END IF;
5671:
5672: -- Inserting errors into IBY_TRANSACTION_ERRORS
5673: -- The first parameter p_is_online_val takes hardcoded value 'N'.
5674: IF (l_valid = 1) THEN
5675: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
5676: END IF;
5710: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
5711: l_valResult BOOLEAN;
5712: l_valid NUMBER := 0;
5713: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
5714: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
5715:
5716: BEGIN
5717:
5718: -- Initializing the document record with the Document Payables information
5750: l_valid := 1;
5751: END IF;
5752: END IF;
5753:
5754: -- Inserting errors into IBY_TRANSACTION_ERRORS
5755: IF (l_valid = 1) THEN
5756: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
5757: END IF;
5758:
5791: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
5792: l_valResult BOOLEAN;
5793: l_valid NUMBER := 0;
5794: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
5795: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
5796:
5797: BEGIN
5798:
5799: -- Initializing the document record
5856: l_valid := 1;
5857: END IF;
5858: END IF;
5859:
5860: -- Inserting errors into IBY_TRANSACTION_ERRORS
5861: IF (l_valid = 1) THEN
5862: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
5863: END IF;
5864:
5897: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
5898: l_valResult BOOLEAN;
5899: l_valid NUMBER := 0;
5900: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
5901: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
5902:
5903: BEGIN
5904:
5905: -- Initializing the document record with the Document Payables information
5913: l_docErrorRec.calling_app_doc_unique_ref1 := l_document_rec.calling_app_doc_id1;
5914:
5915: -- Validate invoice reference ...
5916:
5917: -- Inserting errors into IBY_TRANSACTION_ERRORS
5918: IF (l_valid = 1) THEN
5919: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
5920: END IF;
5921:
5954: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
5955: l_valResult BOOLEAN;
5956: l_valid NUMBER := 0;
5957: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
5958: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
5959:
5960: l_max_payment_amt number;
5961:
5962: BEGIN
6005: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
6006: l_valid := 1;
6007: END IF;
6008:
6009: -- Inserting errors into IBY_TRANSACTION_ERRORS
6010: -- The first parameter p_is_online_val takes hardcoded value 'N'.
6011: IF (l_valid = 1) THEN
6012: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
6013: END IF;
6047: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
6048: l_valResult BOOLEAN;
6049: l_valid NUMBER := 0;
6050: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
6051: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
6052:
6053: BEGIN
6054:
6055: -- Initializing the document record with the Document Payables information
6087: l_valid := 1;
6088: END IF;
6089: END IF;
6090:
6091: -- Inserting errors into IBY_TRANSACTION_ERRORS
6092: IF (l_valid = 1) THEN
6093: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
6094: END IF;
6095:
6128: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
6129: l_valResult BOOLEAN;
6130: l_valid NUMBER := 0;
6131: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
6132: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
6133:
6134: BEGIN
6135:
6136: -- Initializing the document record
6193: l_valid := 1;
6194: END IF;
6195: END IF;
6196:
6197: -- Inserting errors into IBY_TRANSACTION_ERRORS
6198: IF (l_valid = 1) THEN
6199: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
6200: END IF;
6201:
6234: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
6235: l_valResult BOOLEAN;
6236: l_valid NUMBER := 0;
6237: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
6238: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
6239:
6240: BEGIN
6241:
6242: -- Initializing the document record with the Document Payables information
6250: l_docErrorRec.calling_app_doc_unique_ref1 := l_document_rec.calling_app_doc_id1;
6251:
6252: -- Validate invoice document sequence numbers
6253:
6254: -- Inserting errors into IBY_TRANSACTION_ERRORS
6255: IF (l_valid = 1) THEN
6256: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
6257: END IF;
6258:
6291: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
6292: l_valResult BOOLEAN;
6293: l_valid NUMBER := 0;
6294: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
6295: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
6296:
6297: BEGIN
6298:
6299: -- Initializing the document record
6351: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
6352: l_valid := 1;
6353: END IF;
6354:
6355: -- Inserting errors into IBY_TRANSACTION_ERRORS
6356: IF (l_valid = 1) THEN
6357: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
6358: END IF;
6359:
6392: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
6393: l_valResult BOOLEAN;
6394: l_valid NUMBER := 0;
6395: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
6396: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
6397:
6398: BEGIN
6399:
6400: -- Initializing the document record
6421: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
6422: l_valid := 1;
6423: END IF;
6424:
6425: -- Inserting errors into IBY_TRANSACTION_ERRORS
6426: IF (l_valid = 1) THEN
6427: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
6428: END IF;
6429:
6462: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
6463: l_valResult BOOLEAN;
6464: l_valid NUMBER := 0;
6465: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
6466: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
6467:
6468: BEGIN
6469:
6470: -- Initializing the payment record
6505: l_valid := 1;
6506: END IF;
6507: end if;
6508:
6509: -- Inserting errors into IBY_TRANSACTION_ERRORS
6510: -- The first parameter p_is_online_val takes hardcoded value 'N'.
6511: IF (l_valid = 1) THEN
6512: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
6513: END IF;
6547: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
6548: l_valResult BOOLEAN;
6549: l_valid NUMBER := 0;
6550: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
6551: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
6552:
6553: BEGIN
6554:
6555: -- Initializing the document record
6576: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
6577: l_valid := 1;
6578: END IF;
6579:
6580: -- Insert errors into IBY_TRANSACTION_ERRORS
6581: IF (l_valid = 1) THEN
6582: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
6583: END IF;
6584:
6617: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
6618: l_valResult BOOLEAN;
6619: l_valid NUMBER := 0;
6620: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
6621: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
6622:
6623: BEGIN
6624:
6625: -- Initializing the document record
6719: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
6720: l_valid := 1;
6721: END IF;
6722:
6723: -- Inserting errors into IBY_TRANSACTION_ERRORS
6724: IF (l_valid = 1) THEN
6725: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
6726: END IF;
6727:
6760: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
6761: l_valResult BOOLEAN;
6762: l_valid NUMBER := 0;
6763: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
6764: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
6765:
6766: BEGIN
6767:
6768: -- Initializing the document record
6789: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
6790: l_valid := 1;
6791: END IF;
6792:
6793: -- Inserting errors into IBY_TRANSACTION_ERRORS
6794: IF (l_valid = 1) THEN
6795: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
6796: END IF;
6797:
6830: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
6831: l_valResult BOOLEAN;
6832: l_valid NUMBER := 0;
6833: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
6834: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
6835:
6836: BEGIN
6837:
6838: -- Initializing the payment record
6872: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
6873: l_valid := 1;
6874: END IF;
6875:
6876: -- Inserting errors into IBY_TRANSACTION_ERRORS
6877: -- The first parameter p_is_online_val takes hardcoded value 'N'.
6878: IF (l_valid = 1) THEN
6879: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
6880: END IF;
6914: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
6915: l_valResult BOOLEAN;
6916: l_valid NUMBER := 0;
6917: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
6918: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
6919:
6920: BEGIN
6921:
6922: -- Initializing the document record
6969: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
6970: l_valid := 1;
6971: END IF;
6972:
6973: -- Insert errors into IBY_TRANSACTION_ERRORS
6974: IF (l_valid = 1) THEN
6975: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
6976: END IF;
6977:
7010: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
7011: l_valResult BOOLEAN;
7012: l_valid NUMBER := 0;
7013: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7014: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7015:
7016: BEGIN
7017:
7018: -- Initializing the document record
7039: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
7040: l_valid := 1;
7041: END IF;
7042:
7043: -- Insert errors into IBY_TRANSACTION_ERRORS
7044: IF (l_valid = 1) THEN
7045: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
7046: END IF;
7047:
7080: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
7081: l_valResult BOOLEAN;
7082: l_valid NUMBER := 0;
7083: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7084: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7085:
7086: BEGIN
7087:
7088: -- Initializing the document record
7109: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
7110: l_valid := 1;
7111: END IF;
7112:
7113: -- Insert errors into IBY_TRANSACTION_ERRORS
7114: IF (l_valid = 1) THEN
7115: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
7116: END IF;
7117:
7150: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
7151: l_valResult BOOLEAN;
7152: l_valid NUMBER := 0;
7153: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7154: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7155:
7156: BEGIN
7157:
7158: -- Initializing the document record with the Document Payables information
7179: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
7180: l_valid := 1;
7181: END IF;
7182:
7183: -- Insert errors into IBY_TRANSACTION_ERRORS
7184: IF (l_valid = 1) THEN
7185: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
7186: END IF;
7187:
7220: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
7221: l_valResult BOOLEAN;
7222: l_valid NUMBER := 0;
7223: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7224: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7225:
7226: BEGIN
7227:
7228: -- Initializing the document record with the Document Payables information
7249: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
7250: l_valid := 1;
7251: END IF;
7252:
7253: -- Insert errors into IBY_TRANSACTION_ERRORS
7254: IF (l_valid = 1) THEN
7255: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
7256: END IF;
7257:
7290: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
7291: l_valResult BOOLEAN;
7292: l_valid NUMBER := 0;
7293: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7294: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7295:
7296: BEGIN
7297:
7298: -- Initializing the document record
7351:
7352: -- Validate target bank branch code
7353: -- by CE
7354:
7355: -- Inserting errors into IBY_TRANSACTION_ERRORS
7356: IF (l_valid = 1) THEN
7357: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
7358: END IF;
7359:
7392: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
7393: l_valResult BOOLEAN;
7394: l_valid NUMBER := 0;
7395: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7396: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7397:
7398: BEGIN
7399:
7400: -- Initializing the document record
7421: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
7422: l_valid := 1;
7423: END IF;
7424:
7425: -- Inserting errors into IBY_TRANSACTION_ERRORS
7426: IF (l_valid = 1) THEN
7427: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
7428: END IF;
7429:
7462: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
7463: l_valResult BOOLEAN;
7464: l_valid NUMBER := 0;
7465: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7466: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7467:
7468: BEGIN
7469:
7470: -- Initializing the payment record
7504: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
7505: l_valid := 1;
7506: END IF;
7507:
7508: -- Inserting errors into IBY_TRANSACTION_ERRORS
7509: -- The first parameter p_is_online_val takes hardcoded value 'N'.
7510: IF (l_valid = 1) THEN
7511: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
7512: END IF;
7546: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
7547: l_valResult BOOLEAN;
7548: l_valid NUMBER := 0;
7549: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7550: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7551:
7552: BEGIN
7553:
7554: -- Initializing the document record
7575: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
7576: l_valid := 1;
7577: END IF;
7578:
7579: -- Insert errors into IBY_TRANSACTION_ERRORS
7580: IF (l_valid = 1) THEN
7581: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
7582: END IF;
7583:
7616: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
7617: l_valResult BOOLEAN;
7618: l_valid NUMBER := 0;
7619: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7620: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7621:
7622: BEGIN
7623:
7624: -- Initializing the document record
7645: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
7646: l_valid := 1;
7647: END IF;
7648:
7649: -- Insert errors into IBY_TRANSACTION_ERRORS
7650: IF (l_valid = 1) THEN
7651: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
7652: END IF;
7653:
7686: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
7687: l_valResult BOOLEAN;
7688: l_valid NUMBER := 0;
7689: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7690: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7691:
7692: BEGIN
7693:
7694: -- Initializing the document record
7715: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
7716: l_valid := 1;
7717: END IF;
7718:
7719: -- Insert errors into IBY_TRANSACTION_ERRORS
7720: IF (l_valid = 1) THEN
7721: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
7722: END IF;
7723:
7756: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
7757: l_valResult BOOLEAN;
7758: l_valid NUMBER := 0;
7759: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7760: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7761:
7762: l_max_nacha_amt NUMBER;
7763:
7764: BEGIN
7791: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
7792: l_valid := 1;
7793: END IF;
7794:
7795: -- Inserting errors into IBY_TRANSACTION_ERRORS
7796: -- The first parameter p_is_online_val takes hardcoded value 'N'.
7797: IF (l_valid = 1) THEN
7798: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
7799: END IF;
7840: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
7841: l_valResult BOOLEAN;
7842: l_valid NUMBER := 0;
7843: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7844: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7845:
7846: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.ECE_DOC';
7847: BEGIN
7848:
7892:
7893: END IF;
7894:
7895: /*
7896: * Insert errors into IBY_TRANSACTION_ERRORS
7897: */
7898: IF (l_valid = 1) THEN
7899: IBY_VALIDATIONSETS_PUB.
7900: insert_transaction_errors(p_is_online_val,l_docErrorTab);
7943: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
7944: l_valResult BOOLEAN;
7945: l_valid NUMBER := 0;
7946: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
7947: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
7948:
7949: l_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE;
7950: l_bank_edi_id_number HZ_CONTACT_POINTS.edi_id_number%TYPE;
7951: l_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE;
8047:
8048: END IF;
8049:
8050: /*
8051: * Insert errors into IBY_TRANSACTION_ERRORS
8052: */
8053: IF (l_valid = 1) THEN
8054: IBY_VALIDATIONSETS_PUB.
8055: insert_transaction_errors(p_is_online_val,l_docErrorTab);
8098: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
8099: l_valResult BOOLEAN;
8100: l_valid NUMBER := 0;
8101: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
8102: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
8103:
8104: l_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE;
8105: l_trxn_handling IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE;
8106: l_edi_pmt_format IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE;
8336:
8337: END IF; -- if pmt method = 'ACH'
8338:
8339: /*
8340: * Insert errors into IBY_TRANSACTION_ERRORS
8341: */
8342: IF (l_valid = 1) THEN
8343: IBY_VALIDATIONSETS_PUB.
8344: insert_transaction_errors(p_is_online_val,l_docErrorTab);
8388: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
8389: l_valResult BOOLEAN;
8390: l_valid NUMBER := 0;
8391: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
8392: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
8393:
8394: l_field_name VARCHAR2(500);
8395: l_field_value VARCHAR2(500);
8396:
8504: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
8505: l_valResult BOOLEAN;
8506: l_valid NUMBER := 0;
8507: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
8508: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
8509:
8510: l_field_name VARCHAR2(500);
8511: l_field_value VARCHAR2(500);
8512:
8620: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
8621: l_valResult BOOLEAN;
8622: l_valid NUMBER := 0;
8623: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
8624: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
8625:
8626: l_field_name VARCHAR2(500);
8627: l_field_value VARCHAR2(500);
8628: l_min_length number;
8764: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
8765: l_valResult BOOLEAN;
8766: l_valid NUMBER := 0;
8767: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
8768: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
8769:
8770: l_field_name VARCHAR2(500);
8771: l_field_value VARCHAR2(500);
8772:
8892: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
8893: l_valResult BOOLEAN;
8894: l_valid NUMBER := 0;
8895: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
8896: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
8897:
8898: l_field_name VARCHAR2(500);
8899: l_field_value VARCHAR2(500);
8900:
9016: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
9017: l_valResult BOOLEAN;
9018: l_valid NUMBER := 0;
9019: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
9020: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
9021:
9022: l_field_name VARCHAR2(500);
9023: l_field_value VARCHAR2(500);
9024:
9140: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
9141: l_valResult BOOLEAN;
9142: l_valid NUMBER := 0;
9143: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
9144: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
9145:
9146: l_field_name VARCHAR2(500);
9147: l_field_value VARCHAR2(500);
9148:
9264: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
9265: l_valResult BOOLEAN;
9266: l_valid NUMBER := 0;
9267: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
9268: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
9269:
9270: l_field_name VARCHAR2(500);
9271: l_field_value VARCHAR2(500);
9272:
9388: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
9389: l_valResult BOOLEAN;
9390: l_valid NUMBER := 0;
9391: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
9392: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
9393:
9394: l_field_name VARCHAR2(500);
9395: l_field_value VARCHAR2(500);
9396:
9512: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
9513: l_valResult BOOLEAN;
9514: l_valid NUMBER := 0;
9515: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
9516: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
9517:
9518: l_field_name VARCHAR2(500);
9519: l_field_value VARCHAR2(500);
9520:
9636: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
9637: l_valResult BOOLEAN;
9638: l_valid NUMBER := 0;
9639: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
9640: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
9641:
9642: l_field_name VARCHAR2(500);
9643: l_field_value VARCHAR2(500);
9644:
9760: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
9761: l_valResult BOOLEAN;
9762: l_valid NUMBER := 0;
9763: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
9764: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
9765:
9766: l_field_name VARCHAR2(500);
9767: l_field_value VARCHAR2(500);
9768:
9884: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
9885: l_valResult BOOLEAN;
9886: l_valid NUMBER := 0;
9887: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
9888: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
9889:
9890: l_field_name VARCHAR2(500);
9891: l_field_value VARCHAR2(500);
9892:
10008: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
10009: l_valResult BOOLEAN;
10010: l_valid NUMBER := 0;
10011: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
10012: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
10013:
10014: l_field_name VARCHAR2(500);
10015: l_field_value VARCHAR2(500);
10016:
10132: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
10133: l_valResult BOOLEAN;
10134: l_valid NUMBER := 0;
10135: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
10136: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
10137:
10138: l_field_name VARCHAR2(500);
10139: l_field_value VARCHAR2(500);
10140:
10256: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
10257: l_valResult BOOLEAN;
10258: l_valid NUMBER := 0;
10259: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
10260: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
10261:
10262: l_field_name VARCHAR2(500);
10263: l_field_value VARCHAR2(500);
10264:
10380: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
10381: l_valResult BOOLEAN;
10382: l_valid NUMBER := 0;
10383: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
10384: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
10385:
10386: l_field_name VARCHAR2(500);
10387: l_field_value VARCHAR2(500);
10388:
10507: l_charval_rec IBY_VALIDATIONSETS_PUB.charValRecType;
10508: l_valResult BOOLEAN;
10509: l_valid NUMBER := 0;
10510: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
10511: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
10512: l_invalid_chars_list VARCHAR2(3000);
10513: l_valid_chars_list VARCHAR2(3000);
10514:
10515: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
10867: l_valid_chars_list, l_invalid_chars_list,
10868: l_docErrorRec, l_docErrorTab);
10869:
10870: /*
10871: * Insert errors into IBY_TRANSACTION_ERRORS table.
10872: */
10873: IF (l_docErrorTab.COUNT > 0) THEN
10874:
10875: l_valid := 1;
10910: *---------------------------------------------------------------------*/
10911:
10912: PROCEDURE validate_uri_using_modulus10(s IN VARCHAR2,
10913: x_valResult OUT NOCOPY BOOLEAN,
10914: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE)
10915: IS
10916:
10917: weight number := 0;
10918: check_digit number := 0;
10991: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
10992: l_valResult BOOLEAN;
10993: l_valid NUMBER := 0;
10994: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
10995: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
10996:
10997: BEGIN
10998: -- Initializing the document record
10999: IBY_VALIDATIONSETS_PUB.initDocumentData(p_document_id,l_document_rec,p_is_online_val);
11018: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
11019: l_valid := 1;
11020: END IF;
11021:
11022: -- Inserting errors into IBY_TRANSACTION_ERRORS
11023: IF (l_valid = 1) THEN
11024: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
11025: END IF;
11026:
11061: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
11062: l_valResult BOOLEAN;
11063: l_valid NUMBER := 0;
11064: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
11065: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
11066:
11067: BEGIN
11068:
11069: -- Initializing the document record
11089: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
11090: l_valid := 1;
11091: END IF;
11092:
11093: -- Inserting errors into IBY_TRANSACTION_ERRORS
11094: IF (l_valid = 1) THEN
11095: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
11096: END IF;
11097:
11133: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
11134: l_valResult BOOLEAN;
11135: l_valid NUMBER := 0;
11136: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
11137: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
11138:
11139: BEGIN
11140: -- Initializing the document record
11141: IBY_VALIDATIONSETS_PUB.initDocumentData(p_document_id,l_document_rec,p_is_online_val);
11160: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
11161: l_valid := 1;
11162: END IF;
11163:
11164: -- Inserting errors into IBY_TRANSACTION_ERRORS
11165: IF (l_valid = 1) THEN
11166: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
11167: END IF;
11168:
11202: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
11203: l_valResult BOOLEAN;
11204: l_valid NUMBER := 0;
11205: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
11206: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
11207:
11208: BEGIN
11209: -- Initializing the payment record
11210: IBY_VALIDATIONSETS_PUB.initPaymentData(p_payment_id,l_payment_rec);
11228: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
11229: l_valid := 1;
11230: END IF;
11231:
11232: -- Inserting errors into IBY_TRANSACTION_ERRORS
11233: IF (l_valid = 1) THEN
11234: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
11235: END IF;
11236:
11270: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
11271: l_valResult BOOLEAN;
11272: l_valid NUMBER := 0;
11273: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
11274: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
11275:
11276: BEGIN
11277: -- Initializing the payment record
11278: IBY_VALIDATIONSETS_PUB.initPaymentData(p_payment_id,l_payment_rec);
11339: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
11340: l_valid := 1;
11341: END IF;*/
11342:
11343: -- Inserting errors into IBY_TRANSACTION_ERRORS
11344: IF (l_valid = 1) THEN
11345: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
11346: END IF;
11347:
11372: *---------------------------------------------------------------------*/
11373: PROCEDURE xxno_chk_mod_10_11 (
11374: p_kid_nr IN varchar2,
11375: x_valResult OUT NOCOPY BOOLEAN,
11376: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE)
11377: IS
11378: v_invoice_id varchar2(50);
11379: v_kid_nr varchar2(50);
11380: e_kid_feil exception;
11532: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
11533: l_valResult BOOLEAN;
11534: l_valid NUMBER := 0;
11535: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
11536: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
11537: l_int_bank_acct_curr varchar2(50);
11538:
11539: BEGIN
11540: -- Initializing the payment record
11565: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
11566: l_valid := 1;
11567: END IF;
11568:
11569: -- Inserting errors into IBY_TRANSACTION_ERRORS
11570: IF (l_valid = 1) THEN
11571: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
11572: END IF;
11573:
11611: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
11612: l_valResult BOOLEAN;
11613: l_valid NUMBER := 0;
11614: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
11615: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
11616: l_del_chn_fmt_val varchar2(100);
11617:
11618: BEGIN
11619:
11643: l_docErrorRec);
11644:
11645: IF (l_valResult = FALSE) THEN
11646: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
11647: -- Inserting errors into IBY_TRANSACTION_ERRORS
11648: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
11649: l_valid := 1;
11650: END IF;
11651:
11686: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
11687: l_valResult BOOLEAN;
11688: l_valid NUMBER := 0;
11689: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
11690: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
11691: l_payment_amount varchar2(50);
11692:
11693: BEGIN
11694: -- Initializing the payment record
11719: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
11720: l_valid := 1;
11721: END IF;
11722:
11723: -- Inserting errors into IBY_TRANSACTION_ERRORS
11724: IF (l_valid = 1) THEN
11725: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
11726: END IF;
11727:
11765: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
11766: l_valResult BOOLEAN;
11767: l_valid NUMBER := 0;
11768: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
11769: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
11770: l_doc_pmt_curr varchar2(100);
11771:
11772: BEGIN
11773:
11797: l_docErrorRec);
11798:
11799: IF (l_valResult = FALSE) THEN
11800: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
11801: -- Inserting errors into IBY_TRANSACTION_ERRORS
11802: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
11803: l_valid := 1;
11804: END IF;
11805:
11845: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
11846: l_valResult BOOLEAN;
11847: l_valid NUMBER := 0;
11848: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
11849: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
11850: l_payee_brc_country_list varchar2(500);
11851:
11852: BEGIN
11853:
11877: l_docErrorRec);
11878:
11879: IF (l_valResult = FALSE) THEN
11880: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
11881: -- Inserting errors into IBY_TRANSACTION_ERRORS
11882: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
11883: l_valid := 1;
11884: END IF;
11885:
11923: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
11924: l_valResult BOOLEAN;
11925: l_valid NUMBER := 0;
11926: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
11927: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
11928: l_del_chn_fmt_val_list varchar2(500);
11929:
11930: BEGIN
11931:
11955: l_docErrorRec);
11956:
11957: IF (l_valResult = FALSE) THEN
11958: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
11959: -- Inserting errors into IBY_TRANSACTION_ERRORS
11960: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
11961: l_valid := 1;
11962: END IF;
11963:
11996: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
11997: l_valResult BOOLEAN;
11998: l_valid NUMBER := 0;
11999: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
12000: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
12001: l_transaction_error_id IBY_TRANSACTION_ERRORS.transaction_error_id%TYPE;
12002: l_message fnd_new_messages.message_text%TYPE;
12003: l_uri_flag BOOLEAN := false;
12004: l_ck_flag BOOLEAN := false;
11997: l_valResult BOOLEAN;
11998: l_valid NUMBER := 0;
11999: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
12000: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
12001: l_transaction_error_id IBY_TRANSACTION_ERRORS.transaction_error_id%TYPE;
12002: l_message fnd_new_messages.message_text%TYPE;
12003: l_uri_flag BOOLEAN := false;
12004: l_ck_flag BOOLEAN := false;
12005: l_uri l_document_rec.unique_remit_id_code%type;
12056: l_docErrorRec.error_code := 'IBY_VALID_OBJ_INVALID';
12057:
12058:
12059: SELECT
12060: IBY_TRANSACTION_ERRORS_S.NEXTVAL
12061: INTO
12062: l_transaction_error_id
12063: FROM
12064: DUAL
12076: fnd_global.user_id, 1);
12077:
12078:
12079: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
12080: -- Inserting errors into IBY_TRANSACTION_ERRORS
12081: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
12082: l_valid :=1;
12083: END IF;
12084:
12093: l_docErrorRec.error_code := 'IBY_VALID_OBJ_INVALID';
12094:
12095:
12096: SELECT
12097: IBY_TRANSACTION_ERRORS_S.NEXTVAL
12098: INTO
12099: l_transaction_error_id
12100: FROM
12101: DUAL
12113: fnd_global.user_id, 1);
12114:
12115:
12116: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
12117: -- Inserting errors into IBY_TRANSACTION_ERRORS
12118: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
12119: l_valid :=1;
12120: END;
12121:
12133:
12134: IF (l_valResult = FALSE) THEN
12135: l_uri_flag := TRUE;
12136: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
12137: -- Inserting errors into IBY_TRANSACTION_ERRORS
12138: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
12139: l_valid := 1;
12140: END IF;
12141:
12152:
12153: IF (l_valResult = FALSE) THEN
12154: l_ck_flag := TRUE;
12155: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
12156: -- Inserting errors into IBY_TRANSACTION_ERRORS
12157: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
12158: l_valid := 1;
12159: END IF;
12160:
12170: l_docErrorRec);
12171:
12172: IF (l_valResult = FALSE) THEN
12173: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
12174: -- Inserting errors into IBY_TRANSACTION_ERRORS
12175: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
12176: l_valid := 1;
12177: END IF;
12178:
12194: l_docErrorRec.error_code := 'IBY_VALID_OBJ_INVALID';
12195:
12196:
12197: SELECT
12198: IBY_TRANSACTION_ERRORS_S.NEXTVAL
12199: INTO
12200: l_transaction_error_id
12201: FROM
12202: DUAL
12214: fnd_global.user_id, 1);
12215:
12216:
12217: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
12218: -- Inserting errors into IBY_TRANSACTION_ERRORS
12219: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
12220: l_valid :=1;
12221: END IF;
12222: end if;
12298:
12299: l_valResult BOOLEAN;
12300: l_valid NUMBER := 0;
12301: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
12302: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
12303:
12304: l_completion_id NUMBER;
12305: l_module_name CONSTANT VARCHAR2(200) := 'IBY_VALIDATIONSETS_CALLS_PUB.payment_completion_validation';
12306:
12384: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
12385: l_valid := 1;
12386: END IF;
12387:
12388: -- Inserting errors into IBY_TRANSACTION_ERRORS
12389: -- The first parameter p_is_online_val takes hardcoded value 'N'.
12390: IF (l_valid = 1) THEN
12391: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
12392: END IF;
12446: l_document_rec IBY_VALIDATIONSETS_PUB.documentRecType;
12447: l_valResult BOOLEAN;
12448: l_valid NUMBER := 0;
12449: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
12450: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
12451:
12452: BEGIN
12453:
12454: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
12507: l_payment_rec IBY_VALIDATIONSETS_PUB.paymentRecType;
12508: l_valResult BOOLEAN;
12509: l_valid NUMBER := 0;
12510: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
12511: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
12512:
12513: BEGIN
12514:
12515: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
12547: l_valid := 1;
12548: END IF;
12549: END IF;
12550:
12551: -- Inserting errors into IBY_TRANSACTION_ERRORS
12552: IF (l_valid = 1) THEN
12553: IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
12554: END IF;
12555: