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_AUTO_BANK_CLEAR

Line 3420: cep_standard.debug('create_misc_trx: >> CE_AUTO_BANK_CLEAR.misc_receipt');

3416: INTO current_org_id
3417: FROM dual;
3418:
3419: cep_standard.debug('current_org_id =' ||current_org_id );
3420: cep_standard.debug('create_misc_trx: >> CE_AUTO_BANK_CLEAR.misc_receipt');
3421: -- Bug 14227991 Added Savepoint
3422: savepoint ce_crt_misc_rec_sp;
3423:
3424: CE_AUTO_BANK_CLEAR.misc_receipt(

Line 3424: CE_AUTO_BANK_CLEAR.misc_receipt(

3420: cep_standard.debug('create_misc_trx: >> CE_AUTO_BANK_CLEAR.misc_receipt');
3421: -- Bug 14227991 Added Savepoint
3422: savepoint ce_crt_misc_rec_sp;
3423:
3424: CE_AUTO_BANK_CLEAR.misc_receipt(
3425: X_passin_mode => 'AUTO_TRX',
3426: X_trx_number => l_trx_number,
3427: X_doc_sequence_value => to_number(NULL),
3428: X_doc_sequence_id => to_number(NULL),

Line 3461: cep_standard.debug('end create_misc_trx: >> CE_AUTO_BANK_CLEAR.misc_receipt');

3457: X_cr_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,
3458: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
3459: X_org_id => NVL(CE_AUTO_BANK_MATCH.trx_org_id, CE_AUTO_BANK_REC.G_org_id)
3460: );
3461: cep_standard.debug('end create_misc_trx: >> CE_AUTO_BANK_CLEAR.misc_receipt');
3462: CE_AUTO_BANK_MATCH.csl_match_found := 'FULL';
3463: END IF; --9021558: check creation_status
3464: END IF; -- validate payment method
3465: END IF; -- if not creating foreign misc receipts with null exchange info

Line 6802: cep_standard.debug('match_engine: calling CE_AUTO_BANK_CLEAR.misc_receipt');

6798: into current_org_id
6799: from dual;
6800:
6801: cep_standard.debug('current_org_id =' ||current_org_id );
6802: cep_standard.debug('match_engine: calling CE_AUTO_BANK_CLEAR.misc_receipt');
6803:
6804: CE_AUTO_BANK_CLEAR.misc_receipt(
6805: X_passin_mode => 'AUTO_TRX',
6806: X_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number || '/NSF',

Line 6804: CE_AUTO_BANK_CLEAR.misc_receipt(

6800:
6801: cep_standard.debug('current_org_id =' ||current_org_id );
6802: cep_standard.debug('match_engine: calling CE_AUTO_BANK_CLEAR.misc_receipt');
6803:
6804: CE_AUTO_BANK_CLEAR.misc_receipt(
6805: X_passin_mode => 'AUTO_TRX',
6806: X_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number || '/NSF',
6807: X_doc_sequence_value => NULL,
6808: X_doc_sequence_id => to_number(NULL),

Line 6839: cep_standard.debug('end match_engine: >> CE_AUTO_BANK_CLEAR.misc_receipt');

6835: X_cr_id => p_cr_id,
6836: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
6837: X_org_id => nvl(CE_AUTO_BANK_MATCH.trx_org_id,CE_AUTO_BANK_REC.G_org_id));
6838:
6839: cep_standard.debug('end match_engine: >> CE_AUTO_BANK_CLEAR.misc_receipt');
6840: cep_standard.debug('p_cr_id = '|| p_cr_id);
6841: cep_standard.debug('Create a misc receipt with cash_receipt_id='|| to_char(p_cr_id));
6842: END IF; --validate payment method
6843: END IF; -- if not creating foreign misc receipts with null exchange info

Line 6846: CEP_STANDARD.DEBUG('ERROR IN CE_AUTO_BANK_CLEAR.MISC_RECEIPT');

6842: END IF; --validate payment method
6843: END IF; -- if not creating foreign misc receipts with null exchange info
6844: EXCEPTION
6845: WHEN OTHERS THEN
6846: CEP_STANDARD.DEBUG('ERROR IN CE_AUTO_BANK_CLEAR.MISC_RECEIPT');
6847: RAISE;
6848: END;
6849: END IF;
6850: ELSE /* misc_exists = 'Y' */

Line 7915: CE_AUTO_BANK_CLEAR.reconcile_trx(

7911:
7912: IF( CE_AUTO_BANK_MATCH.trx_currency_code = l_sl_currency_code AND
7913: CE_AUTO_BANK_MATCH.trx_amount = l_sl_amount)
7914: THEN
7915: CE_AUTO_BANK_CLEAR.reconcile_trx(
7916: passin_mode => 'AUTO',
7917: tx_type => CE_AUTO_BANK_MATCH.csl_match_type,
7918: trx_id => CE_AUTO_BANK_MATCH.TRX_id,
7919: trx_status => CE_AUTO_BANK_MATCH.trx_status,

Line 7943: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');

7939: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
7940: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
7941: X_reversed_receipt_flag => CE_AUTO_BANK_MATCH.reversed_receipt_flag);
7942:
7943: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
7944:
7945: -- update the reconciled_status_flag of the GT table, ce_available_transactions_tmp,
7946: -- to 'Y'
7947: update_gt_reconciled_status (CE_AUTO_BANK_MATCH.gt_seq_id, 'Y');

Line 9903: | CE_AUTO_BANK_CLEAR1.reconcile_pbatch |

9899: | |
9900: | CALLED BY |
9901: | match_process |
9902: | match_stmt_line_JE |
9903: | CE_AUTO_BANK_CLEAR1.reconcile_pbatch |
9904: | CE_AUTO_BANK_CLEAR1.reconcile_rbatch |
9905: | CE_AUTO_BANK_CLEAR1.reconcile_pay_eft |
9906: | |
9907: | HISTORY |

Line 9904: | CE_AUTO_BANK_CLEAR1.reconcile_rbatch |

9900: | CALLED BY |
9901: | match_process |
9902: | match_stmt_line_JE |
9903: | CE_AUTO_BANK_CLEAR1.reconcile_pbatch |
9904: | CE_AUTO_BANK_CLEAR1.reconcile_rbatch |
9905: | CE_AUTO_BANK_CLEAR1.reconcile_pay_eft |
9906: | |
9907: | HISTORY |
9908: | 11-MAY-2006 Xin Wang Created |

Line 9905: | CE_AUTO_BANK_CLEAR1.reconcile_pay_eft |

9901: | match_process |
9902: | match_stmt_line_JE |
9903: | CE_AUTO_BANK_CLEAR1.reconcile_pbatch |
9904: | CE_AUTO_BANK_CLEAR1.reconcile_rbatch |
9905: | CE_AUTO_BANK_CLEAR1.reconcile_pay_eft |
9906: | |
9907: | HISTORY |
9908: | 11-MAY-2006 Xin Wang Created |
9909: --------------------------------------------------------------------- */

Line 9933: | CE_AUTO_BANK_CLEAR1.unclear_process |

9929: | ce_available_transactions_tmp |
9930: | mainly used to update the status to 'N' during unreconciliation |
9931: | |
9932: | CALLED BY |
9933: | CE_AUTO_BANK_CLEAR1.unclear_process |
9934: | |
9935: | HISTORY |
9936: | 11-MAY-2006 Xin Wang Created |
9937: --------------------------------------------------------------------- */

Line 9963: | CE_AUTO_BANK_CLEAR1.unclear_process |

9959: | mainly used to update the status to 'N' during |
9960: | auto unreconciliation |
9961: | |
9962: | CALLED BY |
9963: | CE_AUTO_BANK_CLEAR1.unclear_process |
9964: | |
9965: | HISTORY |
9966: | 11-MAY-2006 Xin Wang Created |
9967: --------------------------------------------------------------------- */

Line 10009: | CE_AUTO_BANK_CLEAR.reconcile_process |

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 |
10011: | Get_Min_Statement_Line_Id |
10012: | |
10013: | CALLED BY |

Line 10041: IF CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG THEN

10037: cep_standard.init_security;
10038:
10039: -- Bug 16298972 Start
10040: -- Reset the G_RECEIPT_PROCESSED_FLAG flag for a new run of autorecon.
10041: IF CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG THEN
10042: CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG := FALSE;
10043: END IF;
10044: -- Bug 16298972 End
10045:

Line 10042: CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG := FALSE;

10038:
10039: -- Bug 16298972 Start
10040: -- Reset the G_RECEIPT_PROCESSED_FLAG flag for a new run of autorecon.
10041: IF CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG THEN
10042: CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG := FALSE;
10043: END IF;
10044: -- Bug 16298972 End
10045:
10046: cep_standard.debug('-> Opening r_branch_cursor');

Line 10362: CE_AUTO_BANK_CLEAR.reconcile_process;

10358: -- bug 4914608 set the org after a match for AR/AP
10359: cep_standard.debug('CE_AUTO_BANK_MATCH.trx_org_id =' ||CE_AUTO_BANK_MATCH.trx_org_id);
10360: set_single_org(CE_AUTO_BANK_MATCH.trx_org_id);
10361:
10362: CE_AUTO_BANK_CLEAR.reconcile_process;
10363:
10364: -- after a match and reconcilation,
10365: -- update the ce_available_transactions_tmp.reconciled_status_flag
10366: IF (CE_AUTO_BANK_MATCH.gt_seq_id is not null) AND (CE_AUTO_BANK_MATCH.gt_seq_id <> -1)

Line 10430: cep_standard.debug('CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG = ' || CASE WHEN CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG THEN 'TRUE' ELSE 'FALSE' END);

10426: CLOSE r_branch_cursor;
10427:
10428: -- Bug 16298972 Start
10429: -- If Atleast one receipt was cleared during the autoreconciliation process, call the AR API ARP_CASHBOOK.refresh_risk_value
10430: cep_standard.debug('CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG = ' || CASE WHEN CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG THEN 'TRUE' ELSE 'FALSE' END);
10431:
10432: IF CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG THEN
10433: cep_standard.debug('Calling AR API ARP_CASHBOOK.refresh_risk_value for Autorecon.');
10434: ARP_CASHBOOK.refresh_risk_value;

Line 10432: IF CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG THEN

10428: -- Bug 16298972 Start
10429: -- If Atleast one receipt was cleared during the autoreconciliation process, call the AR API ARP_CASHBOOK.refresh_risk_value
10430: cep_standard.debug('CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG = ' || CASE WHEN CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG THEN 'TRUE' ELSE 'FALSE' END);
10431:
10432: IF CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG THEN
10433: cep_standard.debug('Calling AR API ARP_CASHBOOK.refresh_risk_value for Autorecon.');
10434: ARP_CASHBOOK.refresh_risk_value;
10435: cep_standard.debug('Call to AR API ARP_CASHBOOK.refresh_risk_value ended successfully.');
10436: END IF;