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 722: CE_RECONCILIATION_ERRORS_PKG.insert_row(

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

Line 732: CE_RECONCILIATION_ERRORS_PKG.insert_row(

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

Line 924: CE_RECONCILIATION_ERRORS_PKG.insert_row(

920: NVL(CE_AUTO_BANK_MATCH.csl_currency_code,
921: CE_AUTO_BANK_MATCH.trx_currency_code)) THEN
922: cep_standard.debug('Inconsistent currencies');
923:
924: CE_RECONCILIATION_ERRORS_PKG.insert_row(
925: CE_AUTO_BANK_MATCH.csh_statement_header_id,
926: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_DIFFERENT_CURRENCY');
927: return(FALSE);
928: END IF;

Line 1099: CE_RECONCILIATION_ERRORS_PKG.insert_row(

1095:
1096: ELSE
1097:
1098: IF (CE_AUTO_BANK_MATCH.csl_exchange_rate_type IS NULL) THEN
1099: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1100: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1101: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_NO_RATE_TYPE');
1102: ELSIF (CE_AUTO_BANK_MATCH.csl_exchange_rate_date IS NULL) THEN
1103: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 1103: CE_RECONCILIATION_ERRORS_PKG.insert_row(

1099: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1100: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1101: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_NO_RATE_TYPE');
1102: ELSIF (CE_AUTO_BANK_MATCH.csl_exchange_rate_date IS NULL) THEN
1103: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1104: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1105: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_NO_RATE_DATE');
1106: END IF;
1107: return(FALSE);

Line 1126: CE_RECONCILIATION_ERRORS_PKG.insert_row(

1122: IF (CE_AUTO_BANK_MATCH.csl_exchange_rate_type = 'User') THEN
1123:
1124: IF (CE_AUTO_BANK_MATCH.csl_exchange_rate IS NULL) THEN
1125: IF (CE_AUTO_BANK_MATCH.trx_currency_type = 'BANK') THEN
1126: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1127: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1128: CE_AUTO_BANK_MATCH.csl_statement_line_id,
1129: 'CE_INCOMPLETE_USER_RATE');
1130: return(FALSE);

Line 1162: CE_RECONCILIATION_ERRORS_PKG.insert_row(

1158: IF (round(x_exchange_rate,9) =
1159: round(CE_AUTO_BANK_MATCH.csl_exchange_rate,9)) THEN
1160: RETURN(TRUE);
1161: ELSE
1162: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1163: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1164: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_OTHER_ERROR_RATE');
1165: RETURN(FALSE);
1166: END IF;

Line 1178: CE_RECONCILIATION_ERRORS_PKG.insert_row(

1174: CE_AUTO_BANK_MATCH.csl_exchange_rate := null;
1175: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := null;
1176: CE_AUTO_BANK_MATCH.csl_original_amount := null;
1177: --for bug 6786355 end
1178: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1179: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1180: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_OTHER_NO_RATE');
1181: RETURN(FALSE);
1182: ELSE

Line 1925: CE_RECONCILIATION_ERRORS_PKG.insert_row(

1921: EXCEPTION
1922: WHEN NO_DATA_FOUND THEN
1923: cep_standard.debug('EXCEPTION - NO_DATA_FOUND: No data found in CE_AUTO_BANK_MATCH.ce_match');
1924: if (curr = 6) then
1925: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1926: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1927: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_FOREIGN_RECON');
1928: else
1929: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 1929: CE_RECONCILIATION_ERRORS_PKG.insert_row(

1925: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1926: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1927: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_FOREIGN_RECON');
1928: else
1929: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1930: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1931: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_CE_TRX_MATCH');
1932: end if;
1933: no_of_matches := 0;

Line 1937: CE_RECONCILIATION_ERRORS_PKG.insert_row(

1933: no_of_matches := 0;
1934: WHEN OTHERS THEN
1935: IF (SQL%NOTFOUND) THEN
1936: cep_standard.debug('EXCEPTION - OTHERS: NO data found in CE_AUTO_BANK_MATCH.ce_match');
1937: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1938: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1939: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_TRX_MATCH');
1940: no_of_matches:=0;
1941: ELSIF (SQL%ROWCOUNT >0) THEN

Line 1944: CE_RECONCILIATION_ERRORS_PKG.insert_row(

1940: no_of_matches:=0;
1941: ELSIF (SQL%ROWCOUNT >0) THEN
1942: cep_standard.debug('EXCEPTION: More than one CE trx match this statement line' );
1943:
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_DUP_CE_TRX_MATCH');
1947: no_of_matches:=999;
1948: ELSE

Line 2057: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2053: EXCEPTION
2054: WHEN NO_DATA_FOUND THEN
2055: cep_standard.debug('EXCEPTION - NO_DATA_FOUND: No data found in CE_AUTO_BANK_MATCH.pay_eft_match');
2056: if (curr = 6) then
2057: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2058: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2059: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_FOREIGN_RECON');
2060: elsif (curr = 1) then
2061: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 2061: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2057: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2058: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2059: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_FOREIGN_RECON');
2060: elsif (curr = 1) then
2061: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2062: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2063: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_BATCH_BACS');
2064: elsif (curr = 2) then
2065: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 2065: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2061: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2062: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2063: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_BATCH_BACS');
2064: elsif (curr = 2) then
2065: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2066: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2067: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_BATCH_NACHA');
2068: end if;
2069: no_of_matches := 0;

Line 2074: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2070: WHEN OTHERS THEN
2071: IF (SQL%NOTFOUND) THEN
2072: cep_standard.debug('EXCEPTION - OTHERS: NO data found in CE_AUTO_BANK_MATCH.pay_eft_match');
2073: if (curr = 1) 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_BATCH_BACS');
2077: elsif (curr = 2) 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_BATCH_BACS');
2077: elsif (curr = 2) 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_NACHA');
2081: end if;
2082: no_of_matches:=0;

Line 2087: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2083: ELSIF (SQL%ROWCOUNT >0) THEN
2084: cep_standard.debug('EXCEPTION: More than one EFT batch match this payment' );
2085: -- if (CE_AUTO_BANK_MATCH.csl_trx_type IN ('DEBIT','STOP')) then
2086: if (curr = 1) then
2087: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2088: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2089: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_DUP_BATCH_BACS');
2090: elsif (curr = 2) then
2091: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 2091: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2087: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2088: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2089: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_DUP_BATCH_BACS');
2090: elsif (curr = 2) 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_DUP_BATCH_NACHA');
2094: end if;
2095: no_of_matches:=999;

Line 2366: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2362: EXCEPTION
2363: WHEN NO_DATA_FOUND THEN
2364: cep_standard.debug('EXCEPTION: No data found');
2365: if (curr = 1) then
2366: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2367: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2368: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_FOREIGN_RECON');
2369: end if;
2370: cep_standard.debug('EXCEPTION: NO bank account match this receipt');

Line 2372: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2368: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_FOREIGN_RECON');
2369: end if;
2370: cep_standard.debug('EXCEPTION: NO bank account match this receipt');
2371: if (CE_AUTO_BANK_MATCH.csl_trx_type IN ('DEBIT','STOP')) then
2372: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2373: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2374: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_BAP');
2375: else
2376: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 2376: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2372: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2373: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2374: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_BAP');
2375: else
2376: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2377: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2378: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_BAR');
2379: end if;
2380: no_of_matches := 0;

Line 2385: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2381: WHEN OTHERS THEN
2382: IF (SQL%ROWCOUNT > 0) THEN
2383: cep_standard.debug('EXCEPTION: More than one bank account match this transaction');
2384: if (CE_AUTO_BANK_MATCH.csl_trx_type IN ('DEBIT','STOP')) then
2385: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2386: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2387: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_APT_PARTIAL');
2388: else
2389: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 2389: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2385: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2386: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2387: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_APT_PARTIAL');
2388: else
2389: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2390: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2391: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_ART_PARTIAL');
2392: end if;
2393: no_of_matches:=999;

Line 2661: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2657: EXCEPTION
2658: WHEN NO_DATA_FOUND THEN
2659: cep_standard.debug('EXCEPTION: No data found');
2660: if (curr = 1) 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_NO_FOREIGN_RECON');
2664: end if;
2665: cep_standard.debug('EXCEPTION: NO invoices match this receipt');

Line 2667: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2663: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_FOREIGN_RECON');
2664: end if;
2665: cep_standard.debug('EXCEPTION: NO invoices match this receipt');
2666: if (CE_AUTO_BANK_MATCH.csl_trx_type IN ('DEBIT','STOP')) then
2667: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2668: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2669: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_INP');
2670: else
2671: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 2671: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2667: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2668: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2669: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_INP');
2670: else
2671: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2672: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2673: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_INR');
2674: end if;
2675: no_of_matches := 0;

Line 2680: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2676: WHEN OTHERS THEN
2677: IF (SQL%ROWCOUNT >0) THEN
2678: cep_standard.debug('EXCEPTION: More than one invoice match this transaction');
2679: if (CE_AUTO_BANK_MATCH.csl_trx_type IN ('DEBIT','STOP')) then
2680: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2681: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2682: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_APT_PARTIAL');
2683: else
2684: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 2684: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2680: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2681: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2682: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_APT_PARTIAL');
2683: else
2684: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2685: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2686: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_ART_PARTIAL');
2687: end if;
2688: no_of_matches:=999;

Line 2911: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2907: EXCEPTION
2908: WHEN NO_DATA_FOUND THEN
2909: cep_standard.debug('EXCEPTION: No data found');
2910: if (curr = 6) then
2911: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2912: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2913: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_FOREIGN_RECON');
2914: elsif (curr = 1) then
2915: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 2915: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2911: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2912: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2913: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_FOREIGN_RECON');
2914: elsif (curr = 1) then
2915: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2916: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2917: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_BATCH_P');
2918: elsif (curr = 3) then
2919: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 2919: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2915: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2916: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2917: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_BATCH_P');
2918: elsif (curr = 3) then
2919: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2920: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2921: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_BATCH_R');
2922: end if;
2923: no_of_matches := 0;

Line 2928: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2924: WHEN OTHERS THEN
2925: IF (SQL%NOTFOUND) THEN
2926: cep_standard.debug('EXCEPTION: NO data found in batch_match');
2927: if (curr = 1) then
2928: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2929: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2930: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_BATCH_P');
2931: elsif (curr = 3) then
2932: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 2932: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2928: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2929: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2930: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_BATCH_P');
2931: elsif (curr = 3) then
2932: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2933: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2934: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_BATCH_R');
2935: end if;
2936: no_of_matches:=0;

Line 2940: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2936: no_of_matches:=0;
2937: ELSIF (SQL%ROWCOUNT >0) THEN
2938: cep_standard.debug('EXCEPTION: More than one batch match this receipt' );
2939: if (CE_AUTO_BANK_MATCH.csl_trx_type IN ('DEBIT','STOP')) then
2940: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2941: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2942: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_APB_PARTIAL');
2943: else
2944: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 2944: CE_RECONCILIATION_ERRORS_PKG.insert_row(

2940: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2941: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2942: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_APB_PARTIAL');
2943: else
2944: CE_RECONCILIATION_ERRORS_PKG.insert_row(
2945: CE_AUTO_BANK_MATCH.csh_statement_header_id,
2946: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_ARB_PARTIAL');
2947: end if;
2948: no_of_matches:=999;

Line 3077: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3073: WHEN NO_DATA_FOUND THEN
3074: cep_standard.debug('EXCEPTION: #1 No data found in group_match');
3075: cep_standard.debug('curr = '||curr);
3076: if (curr = 6) then
3077: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3078: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3079: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_FOREIGN_RECON');
3080: elsif (curr = 1) then
3081: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 3081: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3077: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3078: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3079: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_FOREIGN_RECON');
3080: elsif (curr = 1) then
3081: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3082: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3083: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_GROUP_P');
3084: end if;
3085: no_of_matches := 0;

Line 3090: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3086: WHEN OTHERS THEN
3087: IF (SQL%NOTFOUND) THEN
3088: cep_standard.debug('EXCEPTION: NO data found in group_match');
3089: cep_standard.debug('curr = '||curr);
3090: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3091: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3092: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_GROUP_P');
3093: no_of_matches:=0;
3094: ELSIF (SQL%ROWCOUNT >0) THEN

Line 3097: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3093: no_of_matches:=0;
3094: ELSIF (SQL%ROWCOUNT >0) THEN
3095: cep_standard.debug('EXCEPTION: More than one batch match this group' );
3096: cep_standard.debug('curr = '||curr);
3097: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3098: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3099: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_APG_PARTIAL');
3100: no_of_matches:=999;
3101: ELSE

Line 3206: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3202: (trx_currency_type = 'FUNCTIONAL' and
3203: CE_AUTO_BANK_MATCH.aba_bank_currency
3204: <> CE_AUTO_BANK_REC.G_functional_currency) THEN
3205:
3206: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3207: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3208: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_NO_FOREIGN_MISC');
3209:
3210: ELSE

Line 3256: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3252: AND CE_AUTO_BANK_MATCH.csl_create_misc_trx_flag = 'Y'
3253: AND (CE_AUTO_BANK_MATCH.csl_exchange_rate_date IS NULL
3254: OR CE_AUTO_BANK_MATCH.csl_exchange_rate_type IS NULL
3255: OR CE_AUTO_BANK_MATCH.csl_exchange_rate IS NULL) ) THEN
3256: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3257: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3258: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3259: 'CE_REQUIRED_EXCHANGE_FIELD');
3260: ELSE

Line 3321: CE_RECONCILIATION_ERRORS_PKG.insert_row(CE_AUTO_BANK_MATCH.csh_statement_header_id,

3317: END IF;
3318: /* Bug 3385023 - End code fix */
3319:
3320: IF NOT(VALIDATE_PAYMENT_METHOD) THEN
3321: CE_RECONCILIATION_ERRORS_PKG.insert_row(CE_AUTO_BANK_MATCH.csh_statement_header_id,
3322: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_PAYMENT_METHOD');
3323: ELSE
3324:
3325: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_receivables_trx_id= '||

Line 3474: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3470: ('PAYMENT','MISC','CASH','PBATCH','RBATCH', 'NSF', 'RECEIPT','PGROUP')) THEN
3471: IF (CE_AUTO_BANK_MATCH.csl_match_type IN ('PBATCH','RBATCH','PGROUP')) THEN
3472: IF (no_of_currencies > 0) THEN
3473: valid_trx := FALSE;
3474: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3475: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3476: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_PBATCH_CURRENCY');
3477: END IF;
3478: END IF;

Line 3527: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3523: - CE_AUTO_BANK_MATCH.tolerance_amount)
3524: AND (comp_csl_amount
3525: + CE_AUTO_BANK_MATCH.tolerance_amount) then
3526: valid_trx := FALSE;
3527: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3528: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3529: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_PMT_AMOUNT');
3530: end if;
3531: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI' AND

Line 3544: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3540: AND (CE_AUTO_BANK_MATCH.calc_csl_amount+CE_AUTO_BANK_MATCH.tolerance_amount)
3541: ) THEN
3542:
3543: valid_trx := FALSE;
3544: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3545: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3546: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_PMT_AMOUNT');
3547: --
3548: -- Validate the charges_amount

Line 3551: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3547: --
3548: -- Validate the charges_amount
3549: --
3550: ELSIF (abs(CE_AUTO_BANK_MATCH.csl_charges_amount) > CE_AUTO_BANK_MATCH.tolerance_amount) THEN
3551: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3552: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3553: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_CHARGES_AMOUNT');
3554: valid_trx:= FALSE;
3555: END IF;

Line 3583: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3579:
3580: IF (CE_AUTO_BANK_MATCH.trx_base_amount
3581: NOT BETWEEN (base_csl_amount - base_tolerance_amount)
3582: AND (base_csl_amount + base_tolerance_amount)) THEN
3583: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3584: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3585: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_XCH_AMOUNT');
3586: valid_trx := FALSE;
3587: END IF;

Line 3607: CE_RECONCILIATION_ERRORS_PKG.insert_row(CE_AUTO_BANK_MATCH.csh_statement_header_id,

3603: IF (CE_AUTO_BANK_MATCH.trx_amount <> CE_AUTO_BANK_MATCH.calc_csl_amount AND
3604: CE_AUTO_BANK_MATCH.csl_match_type = 'RBATCH') THEN
3605: IF NOT (validate_payment_method) THEN
3606: valid_trx := FALSE;
3607: CE_RECONCILIATION_ERRORS_PKG.insert_row(CE_AUTO_BANK_MATCH.csh_statement_header_id,
3608: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_PAYMENT_METHOD');
3609: END IF;
3610: END IF;
3611:

Line 3619: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3615: -- with status 'NEGOTIABLE' and not 'ISSUED'
3616: --
3617: IF (CE_AUTO_BANK_MATCH.trx_status = 'ISSUED') THEN
3618: valid_trx := FALSE;
3619: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3620: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3621: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3622: 'CE_CANNOT_RECONCILE_FD_PAYMENT');
3623: END IF;

Line 3631: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3627: -- JE_LINE and PAY_LINE validation:
3628: --
3629: IF (CE_AUTO_BANK_MATCH.trx_amount <>CE_AUTO_BANK_MATCH.calc_csl_amount) THEN
3630: valid_trx := FALSE;
3631: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3632: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3633: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_PMT_AMOUNT');
3634: END IF;
3635: END IF;

Line 3655: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3651: -- 7571492 : Added PGROUP for csl_match_type
3652: IF (CE_AUTO_BANK_MATCH.csl_match_type IN ('PBATCH','PAYMENT','PGROUP')) THEN
3653: IF(NOT(CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 200))) THEN
3654: valid_trx:=FALSE;
3655: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3656: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3657: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_INVALID_AP_PERIOD');
3658: END IF;
3659: -- bug 1196994

Line 3668: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3664: CE_AUTO_BANK_MATCH.trx_clr_flag := 'Y';
3665: END IF;
3666: ELSIF (NOT(CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 222))) THEN
3667: valid_trx:= FALSE;
3668: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3669: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3670: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_INVALID_AR_PERIOD');
3671: END IF;
3672: END IF;

Line 3743: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3739: CE_AUTO_BANK_MATCH.trx_rowid,
3740: CE_AUTO_BANK_MATCH.trx_amount);
3741: EXCEPTION
3742: WHEN NO_DATA_FOUND THEN
3743: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3744: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3745: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_TRX_RECONCILED');
3746: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3747: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 3747: CE_RECONCILIATION_ERRORS_PKG.insert_row(

3743: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3744: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3745: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_TRX_RECONCILED');
3746: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3747: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3748: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3749: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_TRX_BUSY');
3750: WHEN OTHERS THEN
3751: RAISE;

Line 4071: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4067: no_of_matches := 0;
4068: IF (CE_AUTO_BANK_MATCH.csl_currency_code <>
4069: CE_AUTO_BANK_MATCH.aba_bank_currency AND
4070: CE_AUTO_BANK_MATCH.csl_exchange_rate IS NULL) THEN
4071: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4072: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4073: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4074: 'CE_REQUIRED_EXCHANGE_FIELD');
4075: END IF;

Line 4101: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4097: no_of_matches := 0;
4098: IF (CE_AUTO_BANK_MATCH.csl_currency_code <>
4099: CE_AUTO_BANK_MATCH.aba_bank_currency AND
4100: CE_AUTO_BANK_MATCH.csl_exchange_rate IS NULL) THEN
4101: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4102: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4103: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4104: 'CE_REQUIRED_EXCHANGE_FIELD');
4105: END IF;

Line 4436: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4432: EXCEPTION
4433: WHEN NO_DATA_FOUND THEN
4434: cep_standard.debug('EXCEPTION: No data found in trx_match');
4435: if (curr = 7) then
4436: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4437: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4438: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_BAD_ARL');
4439: elsif (curr = 8) then
4440: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 4440: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4436: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4437: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4438: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_BAD_ARL');
4439: elsif (curr = 8) then
4440: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4441: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4442: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_BAD_NSF');
4443: elsif (curr = 9) then
4444: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 4444: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4440: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4441: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4442: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_BAD_NSF');
4443: elsif (curr = 9) then
4444: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4445: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4446: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_NO_FOREIGN_RECON');
4447: elsif (curr = 4 or curr = 5) then
4448: IF (CE_AUTO_BANK_MATCH.csl_trx_type in

Line 4452: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4448: IF (CE_AUTO_BANK_MATCH.csl_trx_type in
4449: ('CREDIT','MISC_CREDIT','MISC_DEBIT')) THEN
4450: IF (CE_AUTO_BANK_MATCH.trx_status = 'REVERSED') then
4451: cep_standard.debug('>>receipt with reversed status');
4452: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4453: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4454: CE_AUTO_BANK_MATCH.csl_statement_line_id,
4455: 'CE_STATEMENT_REVERSAL_NSF');
4456: ELSIF (CE_AUTO_BANK_MATCH.trx_status NOT IN

Line 4459: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4455: 'CE_STATEMENT_REVERSAL_NSF');
4456: ELSIF (CE_AUTO_BANK_MATCH.trx_status NOT IN
4457: ('REMITTED', 'CLEARED', 'RISK_ELIMINATED')) THEN
4458: cep_standard.debug('>>receipt with wrong status');
4459: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4460: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4461: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_BAD_ARL');
4462: ELSE
4463: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 4463: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4459: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4460: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4461: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_BAD_ARL');
4462: ELSE
4463: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4464: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4465: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_ARL');
4466: END IF;
4467: ELSE -- NSF, REJECTED

Line 4471: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4467: ELSE -- NSF, REJECTED
4468: IF (CE_AUTO_BANK_MATCH.trx_status NOT IN
4469: ('REMITTED', 'CLEARED', 'RISK_ELIMINATED','REVERSED')) THEN
4470: cep_standard.debug('>>NSF/REJECTED with wrong status');
4471: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4472: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4473: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_BAD_NSF');
4474: END IF;
4475: END IF;

Line 4477: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4473: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_BAD_NSF');
4474: END IF;
4475: END IF;
4476: elsif (curr = 1) then
4477: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4478: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4479: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_PAYL');
4480: elsif (curr = 2) then
4481: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 4481: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4477: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4478: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4479: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_PAYL');
4480: elsif (curr = 2) then
4481: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4482: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4483: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_JEL');
4484: elsif (curr = 3) then
4485: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 4485: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4481: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4482: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4483: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_JEL');
4484: elsif (curr = 3) then
4485: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4486: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4487: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_OIL');
4488: elsif (curr = 6) then
4489: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 4489: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4485: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4486: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4487: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_OIL');
4488: elsif (curr = 6) then
4489: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4490: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4491: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_APL');
4492: end if;
4493: no_of_matches := 0;

Line 4498: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4494: WHEN OTHERS THEN
4495: IF (SQL%ROWCOUNT >0) THEN
4496: cep_standard.debug('EXCEPTION: More than one transaction match this receipt' );
4497: if (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'JE') then
4498: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4499: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4500: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_JEL_PARTIAL');
4501: elsif (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI') then
4502: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 4502: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4498: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4499: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4500: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_JEL_PARTIAL');
4501: elsif (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI') then
4502: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4503: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4504: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_OIL_PARTIAL');
4505: elsif (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'PAY') then
4506: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 4506: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4502: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4503: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4504: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_OIL_PARTIAL');
4505: elsif (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'PAY') then
4506: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4507: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4508: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_PAYL_PARTIAL');
4509: elsif (CE_AUTO_BANK_MATCH.csl_trx_type IN ('DEBIT','STOP')) then
4510: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 4510: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4506: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4507: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4508: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_PAYL_PARTIAL');
4509: elsif (CE_AUTO_BANK_MATCH.csl_trx_type IN ('DEBIT','STOP')) then
4510: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4511: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4512: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_APT_PARTIAL');
4513: else
4514: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 4514: CE_RECONCILIATION_ERRORS_PKG.insert_row(

4510: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4511: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4512: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_APT_PARTIAL');
4513: else
4514: CE_RECONCILIATION_ERRORS_PKG.insert_row(
4515: CE_AUTO_BANK_MATCH.csh_statement_header_id,
4516: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_ART_PARTIAL');
4517: end if;
4518: no_of_matches:=999;

Line 6073: CE_RECONCILIATION_ERRORS_PKG.insert_row(

6069: cep_standard.debug('< 6070:
6071: EXCEPTION
6072: WHEN NO_DATA_FOUND THEN
6073: CE_RECONCILIATION_ERRORS_PKG.insert_row(
6074: CE_AUTO_BANK_MATCH.csh_statement_header_id,
6075: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_STMTL');
6076: no_of_matches:=0;
6077: WHEN TOO_MANY_ROWS THEN

Line 6079: CE_RECONCILIATION_ERRORS_PKG.insert_row(

6075: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NO_STMTL');
6076: no_of_matches:=0;
6077: WHEN TOO_MANY_ROWS THEN
6078: cep_standard.debug('EXCEPTION: More than one statement line match this receipt' );
6079: CE_RECONCILIATION_ERRORS_PKG.insert_row(
6080: CE_AUTO_BANK_MATCH.csh_statement_header_id,
6081: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_STMT_PARTIAL');
6082: no_of_matches:=999;
6083: WHEN OTHERS THEN

Line 6173: CE_RECONCILIATION_ERRORS_PKG.insert_row(

6169: /* open count_dup_invoice;
6170: fetch count_dup_invoice into dup_invoice;
6171: close count_dup_invoice;
6172: IF (dup_invoice > 0) THEN
6173: CE_RECONCILIATION_ERRORS_PKG.insert_row(
6174: CE_AUTO_BANK_MATCH.csh_statement_header_id,
6175: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_MULTI_MATCH_INVOICE');
6176: ELSE
6177: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 6177: CE_RECONCILIATION_ERRORS_PKG.insert_row(

6173: CE_RECONCILIATION_ERRORS_PKG.insert_row(
6174: CE_AUTO_BANK_MATCH.csh_statement_header_id,
6175: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_MULTI_MATCH_INVOICE');
6176: ELSE
6177: CE_RECONCILIATION_ERRORS_PKG.insert_row(
6178: CE_AUTO_BANK_MATCH.csh_statement_header_id,
6179: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_PMT_PARTIAL');
6180: END IF;
6181: */

Line 6298: CE_RECONCILIATION_ERRORS_PKG.insert_row(

6294: (trx_currency_type = 'FUNCTIONAL' and
6295: CE_AUTO_BANK_MATCH.aba_bank_currency
6296: <> CE_AUTO_BANK_REC.G_functional_currency) THEN
6297:
6298: CE_RECONCILIATION_ERRORS_PKG.insert_row(
6299: CE_AUTO_BANK_MATCH.csh_statement_header_id,
6300: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_NO_FOREIGN_RECON');
6301:
6302: ELSE

Line 6309: CE_RECONCILIATION_ERRORS_PKG.insert_row(

6305: -- before we try to find the match
6306: --
6307: IF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI' AND
6308: NVL(CE_AUTO_BANK_REC.G_open_interface_flag,'N') = 'N' ) THEN
6309: CE_RECONCILIATION_ERRORS_PKG.insert_row(
6310: CE_AUTO_BANK_MATCH.csh_statement_header_id,
6311: CE_AUTO_BANK_MATCH.csl_statement_line_id,
6312: 'CE_OPEN_INTERFACE_DISABLED');
6313: CE_AUTO_BANK_MATCH.csl_match_found := 'NONE';

Line 6499: CE_RECONCILIATION_ERRORS_PKG.insert_row(

6495: AND CE_AUTO_BANK_MATCH.csl_create_misc_trx_flag = 'Y'
6496: AND (CE_AUTO_BANK_MATCH.csl_exchange_rate_date IS NULL
6497: OR CE_AUTO_BANK_MATCH.csl_exchange_rate_type IS NULL
6498: OR CE_AUTO_BANK_MATCH.csl_exchange_rate IS NULL) ) THEN
6499: CE_RECONCILIATION_ERRORS_PKG.insert_row(
6500: CE_AUTO_BANK_MATCH.csh_statement_header_id,
6501: CE_AUTO_BANK_MATCH.csl_statement_line_id,
6502: 'CE_REQUIRED_EXCHANGE_FIELD');
6503: ELSE

Line 6553: CE_RECONCILIATION_ERRORS_PKG.insert_row(CE_AUTO_BANK_MATCH.csh_statement_header_id,

6549: end if;
6550:
6551: --Bug 4260337 Validate payment method for end date
6552: IF NOT(VALIDATE_PAYMENT_METHOD) THEN
6553: CE_RECONCILIATION_ERRORS_PKG.insert_row(CE_AUTO_BANK_MATCH.csh_statement_header_id,
6554: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_PAYMENT_METHOD');
6555: ELSE
6556:
6557: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_receivables_trx_id= '||

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

6724: IF (CE_AUTO_BANK_MATCH.csl_match_found = 'FULL') THEN
6725: CE_AUTO_BANK_MATCH.csl_match_type := 'MISC';
6726: ELSE
6727: CE_AUTO_BANK_MATCH.csl_match_type := 'NONE';
6728: --CE_RECONCILIATION_ERRORS_PKG.insert_row(CE_AUTO_BANK_MATCH.csh_statement_header_id,
6729: --CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_DR_NOT_FOUND');
6730: END IF;
6731: END IF; -- End main IF statement -- CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI'
6732: END IF; -- Forex

Line 6739: CE_RECONCILIATION_ERRORS_PKG.insert_row(

6735:
6736: EXCEPTION
6737: WHEN NO_DATA_FOUND THEN
6738: cep_standard.debug('info missing');
6739: CE_RECONCILIATION_ERRORS_PKG.insert_row(
6740: CE_AUTO_BANK_MATCH.csh_statement_header_id,
6741: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_ABR_INFO_MISSING');
6742: WHEN app_exception.application_exception THEN
6743: cep_standard.debug('EXCEPTION:CE_AUTO_BANK_MATCH.match_engine-application_exception' );

Line 6753: CE_RECONCILIATION_ERRORS_PKG.insert_row(

6749: ELSE
6750: cep_standard.debug('No messages on stack');
6751: l_message_name := 'OTHER_APP_ERROR';
6752: END IF;
6753: CE_RECONCILIATION_ERRORS_PKG.insert_row(
6754: CE_AUTO_BANK_MATCH.csh_statement_header_id,
6755: CE_AUTO_BANK_MATCH.csl_statement_line_id, l_message_name,
6756: l_app_short_name);
6757: WHEN OTHERS THEN

Line 7706: CE_RECONCILIATION_ERRORS_PKG.delete_row(

7702: update_gt_reconciled_status (CE_AUTO_BANK_MATCH.gt_seq_id, 'Y');
7703:
7704: ELSE
7705: cep_standard.debug( 'currency or amount does not match' );
7706: CE_RECONCILIATION_ERRORS_PKG.delete_row(
7707: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7708: CE_AUTO_BANK_MATCH.csl_statement_line_id);
7709:
7710: CE_RECONCILIATION_ERRORS_PKG.insert_row(

Line 7710: CE_RECONCILIATION_ERRORS_PKG.insert_row(

7706: CE_RECONCILIATION_ERRORS_PKG.delete_row(
7707: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7708: CE_AUTO_BANK_MATCH.csl_statement_line_id);
7709:
7710: CE_RECONCILIATION_ERRORS_PKG.insert_row(
7711: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7712: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_CE_TRX_AMT_OR_CUR_NOT_MATCH');
7713:
7714: END IF;

Line 7719: CE_RECONCILIATION_ERRORS_PKG.delete_row(

7715: cep_standard.debug( '< 7716:
7717: EXCEPTION
7718: WHEN NO_DATA_FOUND THEN
7719: CE_RECONCILIATION_ERRORS_PKG.delete_row(
7720: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7721: CE_AUTO_BANK_MATCH.csl_statement_line_id);
7722: CE_RECONCILIATION_ERRORS_PKG.insert_row(
7723: CE_AUTO_BANK_MATCH.csh_statement_header_id,

Line 7722: CE_RECONCILIATION_ERRORS_PKG.insert_row(

7718: WHEN NO_DATA_FOUND THEN
7719: CE_RECONCILIATION_ERRORS_PKG.delete_row(
7720: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7721: CE_AUTO_BANK_MATCH.csl_statement_line_id);
7722: CE_RECONCILIATION_ERRORS_PKG.insert_row(
7723: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7724: CE_AUTO_BANK_MATCH.csl_statement_line_id,
7725: 'CE_NO_CE_TRX_MATCH');
7726:

Line 7728: CE_RECONCILIATION_ERRORS_PKG.delete_row(

7724: CE_AUTO_BANK_MATCH.csl_statement_line_id,
7725: 'CE_NO_CE_TRX_MATCH');
7726:
7727: WHEN TOO_MANY_ROWS THEN
7728: CE_RECONCILIATION_ERRORS_PKG.delete_row(
7729: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7730: CE_AUTO_BANK_MATCH.csl_statement_line_id);
7731: CE_RECONCILIATION_ERRORS_PKG.insert_row(
7732: CE_AUTO_BANK_MATCH.csh_statement_header_id,

Line 7731: CE_RECONCILIATION_ERRORS_PKG.insert_row(

7727: WHEN TOO_MANY_ROWS THEN
7728: CE_RECONCILIATION_ERRORS_PKG.delete_row(
7729: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7730: CE_AUTO_BANK_MATCH.csl_statement_line_id);
7731: CE_RECONCILIATION_ERRORS_PKG.insert_row(
7732: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7733: CE_AUTO_BANK_MATCH.csl_statement_line_id,
7734: 'CE_ABR_JEL_PARTIAL');
7735: END;

Line 9758: | CE_RECONCILIATION_ERRORS_PKG.delete_row |

9754: | |
9755: | CALLS |
9756: | Lock_Statement |
9757: | Update_GL_Date |
9758: | CE_RECONCILIATION_ERRORS_PKG.delete_row |
9759: | Lock_Statement_Line |
9760: | Match_Statement_Line |
9761: | CE_AUTO_BANK_CLEAR.reconcile_process |
9762: | CE_RECONCILIATION_ERRORS_PKG.insert_row |

Line 9762: | CE_RECONCILIATION_ERRORS_PKG.insert_row |

9758: | CE_RECONCILIATION_ERRORS_PKG.delete_row |
9759: | Lock_Statement_Line |
9760: | Match_Statement_Line |
9761: | CE_AUTO_BANK_CLEAR.reconcile_process |
9762: | CE_RECONCILIATION_ERRORS_PKG.insert_row |
9763: | Get_Min_Statement_Line_Id |
9764: | |
9765: | CALLED BY |
9766: | statement |

Line 10036: CE_RECONCILIATION_ERRORS_PKG.delete_row(

10032: from ce_statement_lines
10033: where statement_header_id = CE_AUTO_BANK_MATCH.csh_statement_header_id;
10034:
10035: if (row_count = 0 ) then
10036: CE_RECONCILIATION_ERRORS_PKG.delete_row(
10037: CE_AUTO_BANK_MATCH.csh_statement_header_id,
10038: to_number(NULL));
10039: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10040: CE_AUTO_BANK_MATCH.csh_statement_header_id,

Line 10039: CE_RECONCILIATION_ERRORS_PKG.insert_row(

10035: if (row_count = 0 ) then
10036: CE_RECONCILIATION_ERRORS_PKG.delete_row(
10037: CE_AUTO_BANK_MATCH.csh_statement_header_id,
10038: to_number(NULL));
10039: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10040: CE_AUTO_BANK_MATCH.csh_statement_header_id,
10041: to_number(NULL), 'CE_NO_STMT_LINE');
10042: end if;
10043:

Line 10168: CE_RECONCILIATION_ERRORS_PKG.delete_row(

10164: statement_line_count := statement_line_count + 1;
10165: --
10166: -- Clear recon_errors table
10167: --
10168: CE_RECONCILIATION_ERRORS_PKG.delete_row(
10169: CE_AUTO_BANK_MATCH.csh_statement_header_id,
10170: CE_AUTO_BANK_MATCH.csl_statement_line_id);
10171: IF (lock_statement_line) THEN
10172: --

Line 10270: -- CE_RECONCILIATION_ERRORS_PKG.insert_row(

10266:
10267: -- Bug 900251 - remove this default message.
10268: --ELSIF (CE_AUTO_BANK_MATCH.csl_match_found IN
10269: -- ('NONE','PARTIAL')) THEN
10270: -- CE_RECONCILIATION_ERRORS_PKG.insert_row(
10271: -- CE_AUTO_BANK_MATCH.csh_statement_header_id,
10272: -- CE_AUTO_BANK_MATCH.csl_statement_line_id,
10273: -- 'CE_DR_NOT_FOUND');
10274: --

Line 10285: CE_RECONCILIATION_ERRORS_PKG.insert_row(

10281:
10282: CLOSE trx_code_cursor;
10283: END IF; -- cashflow_id is not null
10284: ELSE -- statement line is locked
10285: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10286: CE_AUTO_BANK_MATCH.csh_statement_header_id,
10287: CE_AUTO_BANK_MATCH.csl_statement_line_id,
10288: 'CE_LINE_LOCKED');
10289: END IF;

Line 10302: CE_RECONCILIATION_ERRORS_PKG.delete_row(

10298: CLOSE line_cursor;
10299:
10300: ELSE
10301: error_statement_line_id := get_min_statement_line_id;
10302: CE_RECONCILIATION_ERRORS_PKG.delete_row(
10303: CE_AUTO_BANK_MATCH.csh_statement_header_id,
10304: error_statement_line_id);
10305: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10306: CE_AUTO_BANK_MATCH.csh_statement_header_id,

Line 10305: CE_RECONCILIATION_ERRORS_PKG.insert_row(

10301: error_statement_line_id := get_min_statement_line_id;
10302: CE_RECONCILIATION_ERRORS_PKG.delete_row(
10303: CE_AUTO_BANK_MATCH.csh_statement_header_id,
10304: error_statement_line_id);
10305: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10306: CE_AUTO_BANK_MATCH.csh_statement_header_id,
10307: error_statement_line_id, 'CE_STATEMENT_COMPLETED');
10308: END IF; -- statement completed
10309:

Line 10312: CE_RECONCILIATION_ERRORS_PKG.delete_row(error_statement_line_id);

10308: END IF; -- statement completed
10309:
10310: ELSE -- statement is locked
10311: /* error_statement_line_id := get_min_statement_line_id;
10312: CE_RECONCILIATION_ERRORS_PKG.delete_row(error_statement_line_id);
10313: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10314: error_statement_line_id,'CE_LOCK_STATEMENT_HEADER_ERR');
10315: */
10316: CE_RECONCILIATION_ERRORS_PKG.delete_row(

Line 10313: CE_RECONCILIATION_ERRORS_PKG.insert_row(

10309:
10310: ELSE -- statement is locked
10311: /* error_statement_line_id := get_min_statement_line_id;
10312: CE_RECONCILIATION_ERRORS_PKG.delete_row(error_statement_line_id);
10313: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10314: error_statement_line_id,'CE_LOCK_STATEMENT_HEADER_ERR');
10315: */
10316: CE_RECONCILIATION_ERRORS_PKG.delete_row(
10317: CE_AUTO_BANK_MATCH.csh_statement_header_id, to_number(NULL));

Line 10316: CE_RECONCILIATION_ERRORS_PKG.delete_row(

10312: CE_RECONCILIATION_ERRORS_PKG.delete_row(error_statement_line_id);
10313: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10314: error_statement_line_id,'CE_LOCK_STATEMENT_HEADER_ERR');
10315: */
10316: CE_RECONCILIATION_ERRORS_PKG.delete_row(
10317: CE_AUTO_BANK_MATCH.csh_statement_header_id, to_number(NULL));
10318: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10319: CE_AUTO_BANK_MATCH.csh_statement_header_id,to_number(NULL),
10320: 'CE_LOCK_STATEMENT_HEADER_ERR');

Line 10318: CE_RECONCILIATION_ERRORS_PKG.insert_row(

10314: error_statement_line_id,'CE_LOCK_STATEMENT_HEADER_ERR');
10315: */
10316: CE_RECONCILIATION_ERRORS_PKG.delete_row(
10317: CE_AUTO_BANK_MATCH.csh_statement_header_id, to_number(NULL));
10318: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10319: CE_AUTO_BANK_MATCH.csh_statement_header_id,to_number(NULL),
10320: 'CE_LOCK_STATEMENT_HEADER_ERR');
10321: END IF;
10322: lock_status := dbms_lock.release(lockhandle);

Line 10326: CE_RECONCILIATION_ERRORS_PKG.delete_row(error_statement_line_id);

10322: lock_status := dbms_lock.release(lockhandle);
10323:
10324: ELSE -- check digits failed
10325: /* error_statement_line_id := get_min_statement_line_id;
10326: CE_RECONCILIATION_ERRORS_PKG.delete_row(error_statement_line_id);
10327: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10328: error_statement_line_id,'CE_CHECK_DIGITS');
10329: */
10330: CE_RECONCILIATION_ERRORS_PKG.delete_row(

Line 10327: CE_RECONCILIATION_ERRORS_PKG.insert_row(

10323:
10324: ELSE -- check digits failed
10325: /* error_statement_line_id := get_min_statement_line_id;
10326: CE_RECONCILIATION_ERRORS_PKG.delete_row(error_statement_line_id);
10327: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10328: error_statement_line_id,'CE_CHECK_DIGITS');
10329: */
10330: CE_RECONCILIATION_ERRORS_PKG.delete_row(
10331: CE_AUTO_BANK_MATCH.csh_statement_header_id, to_number(NULL));

Line 10330: CE_RECONCILIATION_ERRORS_PKG.delete_row(

10326: CE_RECONCILIATION_ERRORS_PKG.delete_row(error_statement_line_id);
10327: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10328: error_statement_line_id,'CE_CHECK_DIGITS');
10329: */
10330: CE_RECONCILIATION_ERRORS_PKG.delete_row(
10331: CE_AUTO_BANK_MATCH.csh_statement_header_id, to_number(NULL));
10332: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10333: CE_AUTO_BANK_MATCH.csh_statement_header_id,to_number(NULL),
10334: 'CE_CHECK_DIGITS');

Line 10332: CE_RECONCILIATION_ERRORS_PKG.insert_row(

10328: error_statement_line_id,'CE_CHECK_DIGITS');
10329: */
10330: CE_RECONCILIATION_ERRORS_PKG.delete_row(
10331: CE_AUTO_BANK_MATCH.csh_statement_header_id, to_number(NULL));
10332: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10333: CE_AUTO_BANK_MATCH.csh_statement_header_id,to_number(NULL),
10334: 'CE_CHECK_DIGITS');
10335: END IF; -- check_digits
10336: