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

APPS.CE_AUTO_BANK_MATCH dependencies on CE_RECONCILIATION_ERRORS_PKG

Line 725: CE_RECONCILIATION_ERRORS_PKG.insert_row(

721: cep_standard.debug( 'x_ORG_ID= '|| X_ORG_ID);
722:
723: ELSE
724: cep_standard.debug('receivables_trx_id is missing');
725: CE_RECONCILIATION_ERRORS_PKG.insert_row(
726: CE_AUTO_BANK_MATCH.csh_statement_header_id,
727: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_MISSING_REC_ACT_ID');
728:
729: END IF;

Line 735: CE_RECONCILIATION_ERRORS_PKG.insert_row(

731: cep_standard.debug( '< 732: EXCEPTION
733: WHEN NO_DATA_FOUND THEN
734: cep_standard.debug('receivables_trx_id does not exists');
735: CE_RECONCILIATION_ERRORS_PKG.insert_row(
736: CE_AUTO_BANK_MATCH.csh_statement_header_id,
737: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_NO_REC_ACT_ID');
738: WHEN OTHERS THEN
739: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_MATCH.get_receivables_org_id' );

Line 934: CE_RECONCILIATION_ERRORS_PKG.insert_row(

930:
931: IF (CE_AUTO_BANK_MATCH.trx_currency_code <> NVL(CE_AUTO_BANK_MATCH.csl_currency_code,CE_AUTO_BANK_MATCH.trx_currency_code))
932: THEN
933: cep_standard.debug('Inconsistent currencies');
934: CE_RECONCILIATION_ERRORS_PKG.insert_row(
935: CE_AUTO_BANK_MATCH.csh_statement_header_id,
936: CE_AUTO_BANK_MATCH.csl_statement_line_id,
937: 'CE_DIFFERENT_CURRENCY');
938: RETURN(FALSE);

Line 1113: CE_RECONCILIATION_ERRORS_PKG.insert_row(

1109: cep_standard.debug('xdate: '||CE_AUTO_BANK_MATCH.csl_exchange_rate_date);
1110: ELSE
1111: IF (CE_AUTO_BANK_MATCH.csl_exchange_rate_type IS NULL)
1112: THEN
1113: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1114: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1115: CE_AUTO_BANK_MATCH.csl_statement_line_id,
1116: 'CE_NO_RATE_TYPE');
1117: ELSIF (CE_AUTO_BANK_MATCH.csl_exchange_rate_date IS NULL)

Line 1119: CE_RECONCILIATION_ERRORS_PKG.insert_row(

1115: CE_AUTO_BANK_MATCH.csl_statement_line_id,
1116: 'CE_NO_RATE_TYPE');
1117: ELSIF (CE_AUTO_BANK_MATCH.csl_exchange_rate_date IS NULL)
1118: THEN
1119: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1120: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1121: CE_AUTO_BANK_MATCH.csl_statement_line_id,
1122: 'CE_NO_RATE_DATE');
1123: END IF;

Line 1142: CE_RECONCILIATION_ERRORS_PKG.insert_row(

1138: IF (CE_AUTO_BANK_MATCH.csl_exchange_rate IS NULL)
1139: THEN
1140: IF (CE_AUTO_BANK_MATCH.trx_currency_type = 'BANK')
1141: THEN
1142: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1143: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1144: CE_AUTO_BANK_MATCH.csl_statement_line_id,
1145: 'CE_INCOMPLETE_USER_RATE');
1146: return(FALSE);

Line 1177: CE_RECONCILIATION_ERRORS_PKG.insert_row(

1173: IF (round(x_exchange_rate,9) = round(CE_AUTO_BANK_MATCH.csl_exchange_rate,9))
1174: THEN
1175: RETURN(TRUE);
1176: ELSE
1177: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1178: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1179: CE_AUTO_BANK_MATCH.csl_statement_line_id,
1180: 'CE_OTHER_ERROR_RATE');
1181: RETURN(FALSE);

Line 1194: CE_RECONCILIATION_ERRORS_PKG.insert_row(

1190: CE_AUTO_BANK_MATCH.csl_exchange_rate := null;
1191: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := null;
1192: CE_AUTO_BANK_MATCH.csl_original_amount := null;
1193: --for bug 6786355 end
1194: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1195: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1196: CE_AUTO_BANK_MATCH.csl_statement_line_id,
1197: 'CE_OTHER_NO_RATE');
1198: RETURN(FALSE);

Line 1940: CE_RECONCILIATION_ERRORS_PKG.insert_row(

1936: EXCEPTION
1937: WHEN NO_DATA_FOUND THEN
1938: cep_standard.debug('EXCEPTION - NO_DATA_FOUND: No data found in CE_AUTO_BANK_MATCH.ce_match');
1939: if (curr = 6) then
1940: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1941: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1942: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_FOREIGN_RECON');
1943: else
1944: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 1944: CE_RECONCILIATION_ERRORS_PKG.insert_row(

1940: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1941: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1942: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_FOREIGN_RECON');
1943: else
1944: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1945: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1946: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_CE_TRX_MATCH');
1947: end if;
1948: no_of_matches := 0;

Line 1952: CE_RECONCILIATION_ERRORS_PKG.insert_row(

1948: no_of_matches := 0;
1949: WHEN OTHERS THEN
1950: IF (SQL%NOTFOUND) THEN
1951: cep_standard.debug('EXCEPTION - OTHERS: NO data found in CE_AUTO_BANK_MATCH.ce_match');
1952: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1953: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1954: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_TRX_MATCH');
1955: no_of_matches:=0;
1956: ELSIF (SQL%ROWCOUNT >0) THEN

Line 1959: CE_RECONCILIATION_ERRORS_PKG.insert_row(

1955: no_of_matches:=0;
1956: ELSIF (SQL%ROWCOUNT >0) THEN
1957: cep_standard.debug('EXCEPTION: More than one CE trx match this statement line' );
1958:
1959: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1960: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1961: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_DUP_CE_TRX_MATCH');
1962: no_of_matches:=999;
1963: ELSE

Line 2074: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2070: EXCEPTION
2071: WHEN NO_DATA_FOUND THEN
2072: cep_standard.debug('EXCEPTION - NO_DATA_FOUND: No data found in CE_AUTO_BANK_MATCH.pay_eft_match');
2073: if (curr = 6) then
2074: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2075: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2076: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_FOREIGN_RECON');
2077: elsif (curr = 1) then
2078: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 2078: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2074: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2075: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2076: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_FOREIGN_RECON');
2077: elsif (curr = 1) then
2078: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2079: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2080: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_BATCH_BACS');
2081: elsif (curr = 2) then
2082: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 2082: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2078: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2079: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2080: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_BATCH_BACS');
2081: elsif (curr = 2) then
2082: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2083: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2084: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_BATCH_NACHA');
2085: end if;
2086: no_of_matches := 0;

Line 2091: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2087: WHEN OTHERS THEN
2088: IF (SQL%NOTFOUND) THEN
2089: cep_standard.debug('EXCEPTION - OTHERS: NO data found in CE_AUTO_BANK_MATCH.pay_eft_match');
2090: if (curr = 1) then
2091: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2092: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2093: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_BATCH_BACS');
2094: elsif (curr = 2) then
2095: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 2095: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2091: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2092: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2093: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_BATCH_BACS');
2094: elsif (curr = 2) then
2095: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2096: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2097: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_BATCH_NACHA');
2098: end if;
2099: no_of_matches:=0;

Line 2104: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2100: ELSIF (SQL%ROWCOUNT >0) THEN
2101: cep_standard.debug('EXCEPTION: More than one EFT batch match this payment' );
2102: -- if (CE_AUTO_BANK_MATCH.csl_trx_type IN ('DEBIT','STOP')) then
2103: if (curr = 1) then
2104: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2105: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2106: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_DUP_BATCH_BACS');
2107: elsif (curr = 2) then
2108: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 2108: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2104: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2105: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2106: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_DUP_BATCH_BACS');
2107: elsif (curr = 2) then
2108: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2109: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2110: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_DUP_BATCH_NACHA');
2111: end if;
2112: no_of_matches:=999;

Line 2359: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2355: EXCEPTION
2356: WHEN NO_DATA_FOUND THEN
2357: cep_standard.debug('EXCEPTION: No data found');
2358: if (curr = 1) then
2359: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2360: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2361: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_FOREIGN_RECON');
2362: end if;
2363: cep_standard.debug('EXCEPTION: NO bank account match this receipt');

Line 2365: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2361: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_FOREIGN_RECON');
2362: end if;
2363: cep_standard.debug('EXCEPTION: NO bank account match this receipt');
2364: if (CE_AUTO_BANK_MATCH.csl_trx_type IN ('DEBIT','STOP')) then
2365: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2366: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2367: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_BAP');
2368: else
2369: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 2369: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2365: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2366: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2367: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_BAP');
2368: else
2369: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2370: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2371: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_BAR');
2372: end if;
2373: no_of_matches := 0;

Line 2378: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2374: WHEN OTHERS THEN
2375: IF (SQL%ROWCOUNT > 0) THEN
2376: cep_standard.debug('EXCEPTION: More than one bank account match this transaction');
2377: if (CE_AUTO_BANK_MATCH.csl_trx_type IN ('DEBIT','STOP')) then
2378: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2379: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2380: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_APT_PARTIAL');
2381: else
2382: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 2382: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2378: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2379: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2380: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_APT_PARTIAL');
2381: else
2382: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2383: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2384: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_ART_PARTIAL');
2385: end if;
2386: no_of_matches:=999;

Line 2655: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2651: EXCEPTION
2652: WHEN NO_DATA_FOUND THEN
2653: cep_standard.debug('EXCEPTION: No data found');
2654: if (curr = 1) then
2655: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2656: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2657: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_FOREIGN_RECON');
2658: end if;
2659: cep_standard.debug('EXCEPTION: NO invoices match this receipt');

Line 2661: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2657: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_FOREIGN_RECON');
2658: end if;
2659: cep_standard.debug('EXCEPTION: NO invoices match this receipt');
2660: if (CE_AUTO_BANK_MATCH.csl_trx_type IN ('DEBIT','STOP')) then
2661: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2662: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2663: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_INP');
2664: else
2665: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 2665: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2661: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2662: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2663: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_INP');
2664: else
2665: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2666: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2667: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_INR');
2668: end if;
2669: no_of_matches := 0;

Line 2674: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2670: WHEN OTHERS THEN
2671: IF (SQL%ROWCOUNT >0) THEN
2672: cep_standard.debug('EXCEPTION: More than one invoice match this transaction');
2673: if (CE_AUTO_BANK_MATCH.csl_trx_type IN ('DEBIT','STOP')) then
2674: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2675: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2676: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_APT_PARTIAL');
2677: else
2678: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 2678: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2674: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2675: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2676: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_APT_PARTIAL');
2677: else
2678: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2679: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2680: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_ART_PARTIAL');
2681: end if;
2682: no_of_matches:=999;

Line 2958: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2954: THEN
2955: cep_standard.debug('EXCEPTION: No data found, curr='||curr);
2956: IF (curr = 6)
2957: THEN
2958: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2959: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2960: CE_AUTO_BANK_MATCH.csl_statement_line_id,
2961: 'CE_NO_FOREIGN_RECON');
2962: ELSIF (curr = 1)

Line 2964: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2960: CE_AUTO_BANK_MATCH.csl_statement_line_id,
2961: 'CE_NO_FOREIGN_RECON');
2962: ELSIF (curr = 1)
2963: THEN
2964: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2965: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2966: CE_AUTO_BANK_MATCH.csl_statement_line_id,
2967: 'CE_ABR_NO_BATCH_P');
2968: ELSIF (curr = 3)

Line 2970: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2966: CE_AUTO_BANK_MATCH.csl_statement_line_id,
2967: 'CE_ABR_NO_BATCH_P');
2968: ELSIF (curr = 3)
2969: THEN
2970: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2971: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2972: CE_AUTO_BANK_MATCH.csl_statement_line_id,
2973: 'CE_ABR_NO_BATCH_R');
2974: END IF;

Line 2982: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2978: THEN
2979: cep_standard.debug('EXCEPTION: NO data found in batch_match, curr='||curr);
2980: IF (curr = 1)
2981: THEN
2982: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2983: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2984: CE_AUTO_BANK_MATCH.csl_statement_line_id,
2985: 'CE_ABR_NO_BATCH_P');
2986: ELSIF (curr = 3)

Line 2988: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2984: CE_AUTO_BANK_MATCH.csl_statement_line_id,
2985: 'CE_ABR_NO_BATCH_P');
2986: ELSIF (curr = 3)
2987: THEN
2988: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2989: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2990: CE_AUTO_BANK_MATCH.csl_statement_line_id,
2991: 'CE_ABR_NO_BATCH_R');
2992: END IF;

Line 2999: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2995: THEN
2996: cep_standard.debug('EXCEPTION: More than one batch match this line, curr='||curr );
2997: IF (CE_AUTO_BANK_MATCH.csl_trx_type IN ('DEBIT','STOP'))
2998: THEN
2999: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3000: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3001: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3002: 'CE_ABR_APB_PARTIAL');
3003: ELSE

Line 3004: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3000: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3001: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3002: 'CE_ABR_APB_PARTIAL');
3003: ELSE
3004: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3005: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3006: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3007: 'CE_ABR_ARB_PARTIAL');
3008: END IF;

Line 3159: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3155: WHEN NO_DATA_FOUND THEN
3156: cep_standard.debug('EXCEPTION: #1 No data found in group_match');
3157: cep_standard.debug('curr = '||curr);
3158: if (curr = 6) then
3159: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3160: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3161: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_FOREIGN_RECON');
3162: elsif (curr = 1) then
3163: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 3163: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3159: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3160: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3161: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_FOREIGN_RECON');
3162: elsif (curr = 1) then
3163: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3164: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3165: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_GROUP_P');
3166: end if;
3167: no_of_matches := 0;

Line 3172: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3168: WHEN OTHERS THEN
3169: IF (SQL%NOTFOUND) THEN
3170: cep_standard.debug('EXCEPTION: NO data found in group_match');
3171: cep_standard.debug('curr = '||curr);
3172: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3173: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3174: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_GROUP_P');
3175: no_of_matches:=0;
3176: ELSIF (SQL%ROWCOUNT >0) THEN

Line 3179: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3175: no_of_matches:=0;
3176: ELSIF (SQL%ROWCOUNT >0) THEN
3177: cep_standard.debug('EXCEPTION: More than one batch match this group' );
3178: cep_standard.debug('curr = '||curr);
3179: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3180: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3181: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_APG_PARTIAL');
3182: no_of_matches:=999;
3183: ELSE

Line 3281: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3277: CE_AUTO_BANK_MATCH.aba_bank_currency <> CE_AUTO_BANK_REC.G_functional_currency)
3278: OR(trx_currency_type = 'FUNCTIONAL' AND
3279: CE_AUTO_BANK_MATCH.aba_bank_currency <> CE_AUTO_BANK_REC.G_functional_currency)
3280: THEN
3281: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3282: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3283: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_NO_FOREIGN_MISC');
3284: ELSE
3285: CE_AUTO_BANK_MATCH.csl_match_type := 'CMISC';

Line 3325: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3321: ( CE_AUTO_BANK_MATCH.csl_exchange_rate_date IS NULL
3322: OR CE_AUTO_BANK_MATCH.csl_exchange_rate_type IS NULL
3323: OR CE_AUTO_BANK_MATCH.csl_exchange_rate IS NULL))
3324: THEN
3325: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3326: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3327: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3328: 'CE_REQUIRED_EXCHANGE_FIELD');
3329: ELSE

Line 3386: CE_RECONCILIATION_ERRORS_PKG.insert_row(CE_AUTO_BANK_MATCH.csh_statement_header_id,

3382: l_trx_number := substrb(l_trx_number, LENGTH(l_trx_number)-25, LENGTH(l_trx_number));
3383: END IF;
3384: /* Bug 3385023 - End code fix */
3385: IF NOT(VALIDATE_PAYMENT_METHOD) THEN
3386: CE_RECONCILIATION_ERRORS_PKG.insert_row(CE_AUTO_BANK_MATCH.csh_statement_header_id,
3387: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3388: 'CE_PAYMENT_METHOD');
3389: ELSE
3390:

Line 3401: CE_RECONCILIATION_ERRORS_PKG.insert_row(CE_AUTO_BANK_MATCH.csh_statement_header_id,

3397: cep_standard.debug('9021558: creation_status='||l_creation_status);
3398:
3399: -- 9021558: Don't create receipt if status is CONFIRMED
3400: IF (l_creation_status = 'CONFIRMED') THEN
3401: CE_RECONCILIATION_ERRORS_PKG.insert_row(CE_AUTO_BANK_MATCH.csh_statement_header_id,
3402: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3403: 'CE_ABR_BAD_RM');
3404: cep_standard.debug('9021558: CE_AUTO_BANK_MATCH.trx_status='||
3405: NVL(CE_AUTO_BANK_MATCH.trx_status,'X'));

Line 3485: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3481: WHEN NO_DATA_FOUND THEN
3482: cep_standard.debug('CE_AUTO_BANK_MATCH.create_misc_trx no_data_found');
3483: -- Bug 14227991 Added Rollback to Savepoint And Error Message
3484: rollback to savepoint ce_crt_misc_rec_sp;
3485: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3486: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3487: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_ABR_ERR_CRT_MISC_RCT');
3488: RAISE NO_DATA_FOUND;
3489: WHEN OTHERS THEN

Line 3540: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3536: THEN
3537: cep_standard.debug('no_of_currencies='||no_of_currencies);
3538: cep_standard.debug('ERROR#01: CE_PBATCH_CURRENCY');
3539: valid_trx := FALSE;
3540: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3541: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3542: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3543: 'CE_PBATCH_CURRENCY');
3544: END IF;

Line 3592: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3588: AND (comp_csl_amount + CE_AUTO_BANK_MATCH.tolerance_amount)
3589: THEN
3590: cep_standard.debug('ERROR#02: CE_PMT_AMOUNT');
3591: valid_trx := FALSE;
3592: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3593: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3594: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3595: 'CE_PMT_AMOUNT');
3596: END IF;

Line 3612: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3608: AND (CE_AUTO_BANK_MATCH.calc_csl_amount+CE_AUTO_BANK_MATCH.tolerance_amount))
3609: THEN
3610: cep_standard.debug('ERROR#03: CE_PMT_AMOUNT');
3611: valid_trx := FALSE;
3612: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3613: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3614: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3615: 'CE_PMT_AMOUNT');
3616:

Line 3622: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3618: ELSIF (abs(CE_AUTO_BANK_MATCH.csl_charges_amount) > CE_AUTO_BANK_MATCH.tolerance_amount)
3619: THEN
3620: cep_standard.debug('ERROR#04: CE_CHARGES_AMOUNT');
3621: valid_trx:= FALSE;
3622: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3623: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3624: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3625: 'CE_CHARGES_AMOUNT');
3626: END IF;

Line 3651: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3647: AND (base_csl_amount + base_tolerance_amount))
3648: THEN
3649: cep_standard.debug('ERROR#05: CE_XCH_AMOUNT');
3650: valid_trx := FALSE;
3651: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3652: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3653: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3654: 'CE_XCH_AMOUNT');
3655: END IF;

Line 3673: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3669: IF NOT (validate_payment_method)
3670: THEN
3671: cep_standard.debug('ERROR#06: CE_PAYMENT_METHOD');
3672: valid_trx := FALSE;
3673: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3674: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3675: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3676: 'CE_PAYMENT_METHOD');
3677: END IF;

Line 3687: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3683: IF (CE_AUTO_BANK_MATCH.trx_status = 'ISSUED')
3684: THEN
3685: cep_standard.debug('ERROR#07: CE_CANNOT_RECONCILE_FD_PAYMENT');
3686: valid_trx := FALSE;
3687: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3688: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3689: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3690: 'CE_CANNOT_RECONCILE_FD_PAYMENT');
3691: END IF;

Line 3703: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3699: IF (CE_AUTO_BANK_MATCH.trx_amount <> CE_AUTO_BANK_MATCH.calc_csl_amount)
3700: THEN
3701: valid_trx := FALSE;
3702: cep_standard.debug('ERROR#08: CE_PMT_AMOUNT');
3703: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3704: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3705: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3706: 'CE_PMT_AMOUNT');
3707: END IF;

Line 3728: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3724: IF(NOT(CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 101)))
3725: THEN
3726: cep_standard.debug('ERROR#09: CE_INVALID_GL_PERIOD');
3727: valid_trx:=FALSE;
3728: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3729: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3730: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3731: 'CE_INVALID_GL_PERIOD');
3732: END IF;

Line 3741: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3737: IF(NOT(CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 200)))
3738: THEN
3739: cep_standard.debug('ERROR#10: CE_INVALID_AP_PERIOD');
3740: valid_trx:=FALSE;
3741: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3742: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3743: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3744: 'CE_INVALID_AP_PERIOD');
3745: END IF;

Line 3759: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3755: ELSIF (NOT(CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 222)))
3756: THEN
3757: cep_standard.debug('ERROR#11: CE_INVALID_AR_PERIOD');
3758: valid_trx:= FALSE;
3759: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3760: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3761: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3762: 'CE_INVALID_AR_PERIOD');
3763: END IF;

Line 3831: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3827: cep_standard.debug('ERROR#12: GL Date earlier than unrec/trx date');
3828: valid_trx:= FALSE;
3829: if l_unclearing_gl_date is null
3830: then
3831: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3832: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3833: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3834: 'CE_ABR_RECON_DATE_CREATE');
3835: else

Line 3836: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3832: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3833: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3834: 'CE_ABR_RECON_DATE_CREATE');
3835: else
3836: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3837: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3838: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3839: 'CE_ABR_RECON_DATE_UNCLEAR');
3840: end if;

Line 3862: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3858: X_BATCH_BA_AMOUNT => CE_AUTO_BANK_MATCH.trx_amount);
3859: EXCEPTION
3860: WHEN NO_DATA_FOUND THEN
3861: cep_standard.debug('ERROR#12: CE_TRX_RECONCILED');
3862: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3863: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3864: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3865: 'CE_TRX_RECONCILED');
3866: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

Line 3868: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3864: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3865: 'CE_TRX_RECONCILED');
3866: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3867: cep_standard.debug('ERROR#13: CE_TRX_BUSY');
3868: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3869: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3870: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3871: 'CE_TRX_BUSY');
3872: WHEN OTHERS THEN

Line 4224: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4220: no_of_matches := 0;
4221: IF (CE_AUTO_BANK_MATCH.csl_currency_code <> CE_AUTO_BANK_MATCH.aba_bank_currency AND
4222: CE_AUTO_BANK_MATCH.csl_exchange_rate IS NULL)
4223: THEN
4224: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4225: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4226: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4227: 'CE_REQUIRED_EXCHANGE_FIELD');
4228: END IF;

Line 4259: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4255: no_of_matches := 0;
4256: IF (CE_AUTO_BANK_MATCH.csl_currency_code <> CE_AUTO_BANK_MATCH.aba_bank_currency AND
4257: CE_AUTO_BANK_MATCH.csl_exchange_rate IS NULL)
4258: THEN
4259: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4260: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4261: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4262: 'CE_REQUIRED_EXCHANGE_FIELD');
4263: END IF;

Line 4657: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4653: WHEN NO_DATA_FOUND THEN
4654: cep_standard.debug('EXCEPTION: No data found in trx_match');
4655: IF (curr = 7)
4656: THEN
4657: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4658: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4659: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4660: 'CE_ABR_BAD_ARL');
4661: ELSIF (curr = 8)

Line 4663: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4659: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4660: 'CE_ABR_BAD_ARL');
4661: ELSIF (curr = 8)
4662: THEN
4663: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4664: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4665: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4666: 'CE_ABR_BAD_NSF');
4667: ELSIF (curr = 9)

Line 4669: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4665: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4666: 'CE_ABR_BAD_NSF');
4667: ELSIF (curr = 9)
4668: THEN
4669: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4670: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4671: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4672: 'CE_NO_FOREIGN_RECON');
4673: ELSIF (curr = 4 or curr = 5)

Line 4680: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4676: THEN
4677: IF (CE_AUTO_BANK_MATCH.trx_status = 'REVERSED')
4678: THEN -- 9092830 removed NVL
4679: cep_standard.debug('CE_ABR_NO_ARL: receipt with reversed status');
4680: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4681: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4682: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4683: 'CE_STATEMENT_REVERSAL_NSF');
4684: ELSIF (CE_AUTO_BANK_MATCH.trx_status) NOT IN ('REMITTED', 'CLEARED', 'RISK_ELIMINATED')

Line 4687: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4683: 'CE_STATEMENT_REVERSAL_NSF');
4684: ELSIF (CE_AUTO_BANK_MATCH.trx_status) NOT IN ('REMITTED', 'CLEARED', 'RISK_ELIMINATED')
4685: THEN -- 9092830 removed NVL
4686: cep_standard.debug('CE_ABR_NO_ARL: receipt with wrong status');
4687: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4688: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4689: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4690: 'CE_ABR_BAD_ARL');
4691: ELSE

Line 4692: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4688: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4689: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4690: 'CE_ABR_BAD_ARL');
4691: ELSE
4692: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4693: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4694: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4695: 'CE_ABR_NO_ARL');
4696: END IF;

Line 4701: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4697: ELSE -- NSF, REJECTED
4698: IF (NVL(CE_AUTO_BANK_MATCH.trx_status,'X') NOT IN ('REMITTED', 'CLEARED', 'RISK_ELIMINATED','REVERSED'))
4699: THEN -- Bug 8310127 Added NVL
4700: cep_standard.debug('>>NSF/REJECTED with wrong status');
4701: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4702: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4703: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4704: 'CE_ABR_BAD_NSF');
4705: END IF;

Line 4709: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4705: END IF;
4706: END IF;
4707: ELSIF (curr = 1)
4708: THEN
4709: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4710: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4711: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4712: 'CE_ABR_NO_PAYL');
4713: ELSIF (curr = 2)

Line 4715: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4711: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4712: 'CE_ABR_NO_PAYL');
4713: ELSIF (curr = 2)
4714: THEN
4715: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4716: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4717: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4718: 'CE_ABR_NO_JEL');
4719: ELSIF (curr = 3) THEN

Line 4720: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4716: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4717: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4718: 'CE_ABR_NO_JEL');
4719: ELSIF (curr = 3) THEN
4720: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4721: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4722: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4723: 'CE_ABR_NO_OIL');
4724: ELSIF (curr = 6) THEN

Line 4725: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4721: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4722: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4723: 'CE_ABR_NO_OIL');
4724: ELSIF (curr = 6) THEN
4725: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4726: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4727: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4728: 'CE_ABR_NO_APL');
4729: END IF;

Line 4738: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4734: cep_standard.debug('EXCEPTION: More than one transaction match this line' );
4735: cep_standard.debug('SQL%ROWCOUNT='||SQL%ROWCOUNT);
4736: IF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'JE')
4737: THEN
4738: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4739: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4740: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_JEL_PARTIAL');
4741: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI')
4742: THEN

Line 4743: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4739: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4740: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_JEL_PARTIAL');
4741: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI')
4742: THEN
4743: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4744: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4745: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4746: 'CE_ABR_OIL_PARTIAL');
4747: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'PAY')

Line 4749: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4745: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4746: 'CE_ABR_OIL_PARTIAL');
4747: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'PAY')
4748: THEN
4749: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4750: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4751: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4752: 'CE_ABR_PAYL_PARTIAL');
4753: ELSIF (CE_AUTO_BANK_MATCH.csl_trx_type IN ('DEBIT','STOP'))

Line 4755: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4751: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4752: 'CE_ABR_PAYL_PARTIAL');
4753: ELSIF (CE_AUTO_BANK_MATCH.csl_trx_type IN ('DEBIT','STOP'))
4754: THEN
4755: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4756: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4757: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4758: 'CE_ABR_APT_PARTIAL');
4759: ELSE

Line 4760: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4756: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4757: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4758: 'CE_ABR_APT_PARTIAL');
4759: ELSE
4760: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4761: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4762: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4763: 'CE_ABR_ART_PARTIAL');
4764: END IF;

Line 6320: CE_RECONCILIATION_ERRORS_PKG.insert_row(

6316: cep_standard.debug('< 6317:
6318: EXCEPTION
6319: WHEN NO_DATA_FOUND THEN
6320: CE_RECONCILIATION_ERRORS_PKG.insert_row(
6321: CE_AUTO_BANK_MATCH.csh_statement_header_id,
6322: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_STMTL');
6323: no_of_matches:=0;
6324: WHEN TOO_MANY_ROWS THEN

Line 6326: CE_RECONCILIATION_ERRORS_PKG.insert_row(

6322: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_STMTL');
6323: no_of_matches:=0;
6324: WHEN TOO_MANY_ROWS THEN
6325: cep_standard.debug('EXCEPTION: More than one statement line match this receipt' );
6326: CE_RECONCILIATION_ERRORS_PKG.insert_row(
6327: CE_AUTO_BANK_MATCH.csh_statement_header_id,
6328: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_STMT_PARTIAL');
6329: no_of_matches:=999;
6330: WHEN OTHERS THEN

Line 6493: CE_RECONCILIATION_ERRORS_PKG.insert_row(

6489: OR( trx_currency_type = 'FUNCTIONAL'
6490: AND CE_AUTO_BANK_MATCH.aba_bank_currency <> CE_AUTO_BANK_REC.G_functional_currency)
6491: THEN
6492: cep_standard.debug('Currency mismatch: CE_NO_FOREIGN_RECON');
6493: CE_RECONCILIATION_ERRORS_PKG.insert_row(
6494: CE_AUTO_BANK_MATCH.csh_statement_header_id,
6495: CE_AUTO_BANK_MATCH.csl_statement_line_id,
6496: 'CE_NO_FOREIGN_RECON');
6497: ELSE

Line 6505: CE_RECONCILIATION_ERRORS_PKG.insert_row(

6501: --
6502: IF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI'
6503: AND NVL(CE_AUTO_BANK_REC.G_open_interface_flag,'N') = 'N' )
6504: THEN
6505: CE_RECONCILIATION_ERRORS_PKG.insert_row(
6506: CE_AUTO_BANK_MATCH.csh_statement_header_id,
6507: CE_AUTO_BANK_MATCH.csl_statement_line_id,
6508: 'CE_OPEN_INTERFACE_DISABLED');
6509: CE_AUTO_BANK_MATCH.csl_match_found := 'NONE';

Line 6726: CE_RECONCILIATION_ERRORS_PKG.insert_row(

6722: (CE_AUTO_BANK_MATCH.csl_exchange_rate_date IS NULL
6723: OR CE_AUTO_BANK_MATCH.csl_exchange_rate_type IS NULL
6724: OR CE_AUTO_BANK_MATCH.csl_exchange_rate IS NULL))
6725: THEN
6726: CE_RECONCILIATION_ERRORS_PKG.insert_row(
6727: CE_AUTO_BANK_MATCH.csh_statement_header_id,
6728: CE_AUTO_BANK_MATCH.csl_statement_line_id,
6729: 'CE_REQUIRED_EXCHANGE_FIELD');
6730: ELSE

Line 6782: CE_RECONCILIATION_ERRORS_PKG.insert_row(

6778:
6779: -- Bug 4260337 Validate payment method for end date
6780: IF NOT(VALIDATE_PAYMENT_METHOD)
6781: THEN
6782: CE_RECONCILIATION_ERRORS_PKG.insert_row(
6783: CE_AUTO_BANK_MATCH.csh_statement_header_id,
6784: CE_AUTO_BANK_MATCH.csl_statement_line_id,
6785: 'CE_PAYMENT_METHOD');
6786: ELSE

Line 6940: --CE_RECONCILIATION_ERRORS_PKG.insert_row(CE_AUTO_BANK_MATCH.csh_statement_header_id,

6936: THEN
6937: CE_AUTO_BANK_MATCH.csl_match_type := 'MISC';
6938: ELSE
6939: CE_AUTO_BANK_MATCH.csl_match_type := 'NONE';
6940: --CE_RECONCILIATION_ERRORS_PKG.insert_row(CE_AUTO_BANK_MATCH.csh_statement_header_id,
6941: --CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_DR_NOT_FOUND');
6942: END IF;
6943: END IF; -- End main IF statement -- CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI'
6944: END IF; -- Forex

Line 6951: CE_RECONCILIATION_ERRORS_PKG.insert_row(

6947:
6948: EXCEPTION
6949: WHEN NO_DATA_FOUND THEN
6950: cep_standard.debug('EXCEPTION:CE_AUTO_BANK_MATCH.match_engine-no_data_found');
6951: CE_RECONCILIATION_ERRORS_PKG.insert_row(
6952: CE_AUTO_BANK_MATCH.csh_statement_header_id,
6953: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_ABR_INFO_MISSING');
6954: WHEN app_exception.application_exception THEN
6955: cep_standard.debug('EXCEPTION:CE_AUTO_BANK_MATCH.match_engine-application_exception');

Line 6965: CE_RECONCILIATION_ERRORS_PKG.insert_row(

6961: ELSE
6962: cep_standard.debug('No messages on stack');
6963: l_message_name := 'OTHER_APP_ERROR';
6964: END IF;
6965: CE_RECONCILIATION_ERRORS_PKG.insert_row(
6966: CE_AUTO_BANK_MATCH.csh_statement_header_id,
6967: CE_AUTO_BANK_MATCH.csl_statement_line_id,
6968: l_message_name,
6969: l_app_short_name);

Line 7864: CE_RECONCILIATION_ERRORS_PKG.delete_row(

7860: cep_standard.debug('l_clearing_gl_date='||to_Char(l_clearing_gl_date));
7861: IF(NOT(CE_AUTO_BANK_REC.find_gl_period(l_clearing_gl_date, 101)))
7862: THEN
7863: cep_standard.debug('GL period is closed');
7864: CE_RECONCILIATION_ERRORS_PKG.delete_row(
7865: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7866: CE_AUTO_BANK_MATCH.csl_statement_line_id);
7867: CE_RECONCILIATION_ERRORS_PKG.insert_row(
7868: CE_AUTO_BANK_MATCH.csh_statement_header_id,

Line 7867: CE_RECONCILIATION_ERRORS_PKG.insert_row(

7863: cep_standard.debug('GL period is closed');
7864: CE_RECONCILIATION_ERRORS_PKG.delete_row(
7865: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7866: CE_AUTO_BANK_MATCH.csl_statement_line_id);
7867: CE_RECONCILIATION_ERRORS_PKG.insert_row(
7868: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7869: CE_AUTO_BANK_MATCH.csl_statement_line_id,
7870: 'CE_INVALID_GL_PERIOD');
7871: RETURN;

Line 7893: CE_RECONCILIATION_ERRORS_PKG.delete_row(

7889: if l_clearing_gl_date < trunc(nvl(l_unclearing_gl_date,CE_AUTO_BANK_MATCH.trx_date))
7890: then
7891: cep_standard.debug('GL Date earlier than unrec/trx date');
7892:
7893: CE_RECONCILIATION_ERRORS_PKG.delete_row(
7894: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7895: CE_AUTO_BANK_MATCH.csl_statement_line_id);
7896: if l_unclearing_gl_date is null
7897: then

Line 7898: CE_RECONCILIATION_ERRORS_PKG.insert_row(

7894: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7895: CE_AUTO_BANK_MATCH.csl_statement_line_id);
7896: if l_unclearing_gl_date is null
7897: then
7898: CE_RECONCILIATION_ERRORS_PKG.insert_row(
7899: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7900: CE_AUTO_BANK_MATCH.csl_statement_line_id,
7901: 'CE_ABR_RECON_DATE_CREATE');
7902: else

Line 7903: CE_RECONCILIATION_ERRORS_PKG.insert_row(

7899: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7900: CE_AUTO_BANK_MATCH.csl_statement_line_id,
7901: 'CE_ABR_RECON_DATE_CREATE');
7902: else
7903: CE_RECONCILIATION_ERRORS_PKG.insert_row(
7904: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7905: CE_AUTO_BANK_MATCH.csl_statement_line_id,
7906: 'CE_ABR_RECON_DATE_UNCLEAR');
7907: end if;

Line 7951: CE_RECONCILIATION_ERRORS_PKG.delete_row(

7947: update_gt_reconciled_status (CE_AUTO_BANK_MATCH.gt_seq_id, 'Y');
7948:
7949: ELSE
7950: cep_standard.debug( 'currency or amount does not match' );
7951: CE_RECONCILIATION_ERRORS_PKG.delete_row(
7952: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7953: CE_AUTO_BANK_MATCH.csl_statement_line_id);
7954:
7955: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 7955: CE_RECONCILIATION_ERRORS_PKG.insert_row(

7951: CE_RECONCILIATION_ERRORS_PKG.delete_row(
7952: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7953: CE_AUTO_BANK_MATCH.csl_statement_line_id);
7954:
7955: CE_RECONCILIATION_ERRORS_PKG.insert_row(
7956: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7957: CE_AUTO_BANK_MATCH.csl_statement_line_id,
7958: 'CE_CE_TRX_AMT_OR_CUR_NOT_MATCH');
7959:

Line 7966: CE_RECONCILIATION_ERRORS_PKG.delete_row(

7962:
7963: EXCEPTION
7964: WHEN NO_DATA_FOUND THEN
7965: cep_standard.debug('NO_DATA_FOUND EXCEPTION in CE_AUTO_BANK_MATCH.match_stmt_line_JE');
7966: CE_RECONCILIATION_ERRORS_PKG.delete_row(
7967: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7968: CE_AUTO_BANK_MATCH.csl_statement_line_id);
7969: CE_RECONCILIATION_ERRORS_PKG.insert_row(
7970: CE_AUTO_BANK_MATCH.csh_statement_header_id,

Line 7969: CE_RECONCILIATION_ERRORS_PKG.insert_row(

7965: cep_standard.debug('NO_DATA_FOUND EXCEPTION in CE_AUTO_BANK_MATCH.match_stmt_line_JE');
7966: CE_RECONCILIATION_ERRORS_PKG.delete_row(
7967: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7968: CE_AUTO_BANK_MATCH.csl_statement_line_id);
7969: CE_RECONCILIATION_ERRORS_PKG.insert_row(
7970: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7971: CE_AUTO_BANK_MATCH.csl_statement_line_id,
7972: 'CE_NO_CE_TRX_MATCH');
7973:

Line 7976: CE_RECONCILIATION_ERRORS_PKG.delete_row(

7972: 'CE_NO_CE_TRX_MATCH');
7973:
7974: WHEN TOO_MANY_ROWS THEN
7975: cep_standard.debug('TOO_MANY_ROWS EXCEPTION in CE_AUTO_BANK_MATCH.match_stmt_line_JE');
7976: CE_RECONCILIATION_ERRORS_PKG.delete_row(
7977: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7978: CE_AUTO_BANK_MATCH.csl_statement_line_id);
7979: CE_RECONCILIATION_ERRORS_PKG.insert_row(
7980: CE_AUTO_BANK_MATCH.csh_statement_header_id,

Line 7979: CE_RECONCILIATION_ERRORS_PKG.insert_row(

7975: cep_standard.debug('TOO_MANY_ROWS EXCEPTION in CE_AUTO_BANK_MATCH.match_stmt_line_JE');
7976: CE_RECONCILIATION_ERRORS_PKG.delete_row(
7977: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7978: CE_AUTO_BANK_MATCH.csl_statement_line_id);
7979: CE_RECONCILIATION_ERRORS_PKG.insert_row(
7980: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7981: CE_AUTO_BANK_MATCH.csl_statement_line_id,
7982: 'CE_ABR_JEL_PARTIAL');
7983: END;

Line 10006: | CE_RECONCILIATION_ERRORS_PKG.delete_row |

10002: | |
10003: | CALLS |
10004: | Lock_Statement |
10005: | Update_GL_Date |
10006: | CE_RECONCILIATION_ERRORS_PKG.delete_row |
10007: | Lock_Statement_Line |
10008: | Match_Statement_Line |
10009: | CE_AUTO_BANK_CLEAR.reconcile_process |
10010: | CE_RECONCILIATION_ERRORS_PKG.insert_row |

Line 10010: | CE_RECONCILIATION_ERRORS_PKG.insert_row |

10006: | CE_RECONCILIATION_ERRORS_PKG.delete_row |
10007: | Lock_Statement_Line |
10008: | Match_Statement_Line |
10009: | CE_AUTO_BANK_CLEAR.reconcile_process |
10010: | CE_RECONCILIATION_ERRORS_PKG.insert_row |
10011: | Get_Min_Statement_Line_Id |
10012: | |
10013: | CALLED BY |
10014: | statement |

Line 10210: CE_RECONCILIATION_ERRORS_PKG.delete_row(

10206: where statement_header_id = CE_AUTO_BANK_MATCH.csh_statement_header_id;
10207:
10208: cep_standard.debug('--> # of statement lines: '||row_count);
10209: if (row_count = 0 ) then
10210: CE_RECONCILIATION_ERRORS_PKG.delete_row(
10211: CE_AUTO_BANK_MATCH.csh_statement_header_id,
10212: to_number(NULL));
10213: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10214: CE_AUTO_BANK_MATCH.csh_statement_header_id,

Line 10213: CE_RECONCILIATION_ERRORS_PKG.insert_row(

10209: if (row_count = 0 ) then
10210: CE_RECONCILIATION_ERRORS_PKG.delete_row(
10211: CE_AUTO_BANK_MATCH.csh_statement_header_id,
10212: to_number(NULL));
10213: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10214: CE_AUTO_BANK_MATCH.csh_statement_header_id,
10215: to_number(NULL), 'CE_NO_STMT_LINE');
10216: end if;
10217:

Line 10305: CE_RECONCILIATION_ERRORS_PKG.delete_row(

10301: /* for bug 6786355 end */
10302:
10303: statement_line_count := statement_line_count + 1;
10304: -- Clear recon_errors table
10305: CE_RECONCILIATION_ERRORS_PKG.delete_row(
10306: CE_AUTO_BANK_MATCH.csh_statement_header_id,
10307: CE_AUTO_BANK_MATCH.csl_statement_line_id);
10308: IF (lock_statement_line)
10309: THEN

Line 10384: CE_RECONCILIATION_ERRORS_PKG.insert_row(

10380: CLOSE trx_code_cursor;
10381: END IF; -- cashflow_id is not null
10382: ELSE -- statement line is locked
10383: cep_standard.debug('---> error: CE_LINE_LOCKED');
10384: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10385: CE_AUTO_BANK_MATCH.csh_statement_header_id,
10386: CE_AUTO_BANK_MATCH.csl_statement_line_id,
10387: 'CE_LINE_LOCKED');
10388: END IF;

Line 10400: CE_RECONCILIATION_ERRORS_PKG.delete_row(CE_AUTO_BANK_MATCH.csh_statement_header_id,error_statement_line_id);

10396: CLOSE line_cursor;
10397: ELSE -- statement_complete_flag = 'Y'
10398: cep_standard.debug('--> error: CE_STATEMENT_COMPLETED');
10399: error_statement_line_id := get_min_statement_line_id;
10400: CE_RECONCILIATION_ERRORS_PKG.delete_row(CE_AUTO_BANK_MATCH.csh_statement_header_id,error_statement_line_id);
10401: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10402: CE_AUTO_BANK_MATCH.csh_statement_header_id,
10403: error_statement_line_id,
10404: 'CE_STATEMENT_COMPLETED');

Line 10401: CE_RECONCILIATION_ERRORS_PKG.insert_row(

10397: ELSE -- statement_complete_flag = 'Y'
10398: cep_standard.debug('--> error: CE_STATEMENT_COMPLETED');
10399: error_statement_line_id := get_min_statement_line_id;
10400: CE_RECONCILIATION_ERRORS_PKG.delete_row(CE_AUTO_BANK_MATCH.csh_statement_header_id,error_statement_line_id);
10401: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10402: CE_AUTO_BANK_MATCH.csh_statement_header_id,
10403: error_statement_line_id,
10404: 'CE_STATEMENT_COMPLETED');
10405: END IF; -- check for statement completed

Line 10408: CE_RECONCILIATION_ERRORS_PKG.delete_row(CE_AUTO_BANK_MATCH.csh_statement_header_id, to_number(NULL));

10404: 'CE_STATEMENT_COMPLETED');
10405: END IF; -- check for statement completed
10406: ELSE -- statement is locked
10407: cep_standard.debug('--> error: CE_LOCK_STATEMENT_HEADER_ERR');
10408: CE_RECONCILIATION_ERRORS_PKG.delete_row(CE_AUTO_BANK_MATCH.csh_statement_header_id, to_number(NULL));
10409: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10410: CE_AUTO_BANK_MATCH.csh_statement_header_id,
10411: to_number(NULL),
10412: 'CE_LOCK_STATEMENT_HEADER_ERR');

Line 10409: CE_RECONCILIATION_ERRORS_PKG.insert_row(

10405: END IF; -- check for statement completed
10406: ELSE -- statement is locked
10407: cep_standard.debug('--> error: CE_LOCK_STATEMENT_HEADER_ERR');
10408: CE_RECONCILIATION_ERRORS_PKG.delete_row(CE_AUTO_BANK_MATCH.csh_statement_header_id, to_number(NULL));
10409: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10410: CE_AUTO_BANK_MATCH.csh_statement_header_id,
10411: to_number(NULL),
10412: 'CE_LOCK_STATEMENT_HEADER_ERR');
10413: END IF; -- check for statement lock

Line 10416: CE_RECONCILIATION_ERRORS_PKG.delete_row(

10412: 'CE_LOCK_STATEMENT_HEADER_ERR');
10413: END IF; -- check for statement lock
10414: ELSE -- check digits failed
10415: cep_standard.debug('--> error: CE_CHECK_DIGITS');
10416: CE_RECONCILIATION_ERRORS_PKG.delete_row(
10417: CE_AUTO_BANK_MATCH.csh_statement_header_id, to_number(NULL));
10418: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10419: CE_AUTO_BANK_MATCH.csh_statement_header_id,
10420: to_number(NULL),

Line 10418: CE_RECONCILIATION_ERRORS_PKG.insert_row(

10414: ELSE -- check digits failed
10415: cep_standard.debug('--> error: CE_CHECK_DIGITS');
10416: CE_RECONCILIATION_ERRORS_PKG.delete_row(
10417: CE_AUTO_BANK_MATCH.csh_statement_header_id, to_number(NULL));
10418: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10419: CE_AUTO_BANK_MATCH.csh_statement_header_id,
10420: to_number(NULL),
10421: 'CE_CHECK_DIGITS');
10422: END IF; -- check_digits