DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_MATCH dependencies on CE_AUTO_BANK_CLEAR

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

3338: from dual;
3339:
3340: cep_standard.debug('current_org_id =' ||current_org_id );
3341:
3342: cep_standard.debug('create_misc_trx: >> CE_AUTO_BANK_CLEAR.misc_receipt');
3343:
3344: CE_AUTO_BANK_CLEAR.misc_receipt(
3345: X_passin_mode => 'AUTO_TRX',
3346: X_trx_number => l_trx_number,

Line 3344: CE_AUTO_BANK_CLEAR.misc_receipt(

3340: cep_standard.debug('current_org_id =' ||current_org_id );
3341:
3342: cep_standard.debug('create_misc_trx: >> CE_AUTO_BANK_CLEAR.misc_receipt');
3343:
3344: CE_AUTO_BANK_CLEAR.misc_receipt(
3345: X_passin_mode => 'AUTO_TRX',
3346: X_trx_number => l_trx_number,
3347: X_doc_sequence_value => to_number(NULL),
3348: X_doc_sequence_id => to_number(NULL),

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

3390: CE_AUTO_BANK_MATCH.csl_effective_date,
3391: X_org_id =>
3392: nvl(CE_AUTO_BANK_MATCH.trx_org_id, CE_AUTO_BANK_REC.G_org_id));
3393: --CE_AUTO_BANK_MATCH.bau_org_id);
3394: cep_standard.debug('end create_misc_trx: >> CE_AUTO_BANK_CLEAR.misc_receipt');
3395:
3396: CE_AUTO_BANK_MATCH.csl_match_found := 'FULL';
3397: END IF;--validate payment method
3398: END IF; -- if not creating foreign misc receipts with null exchange info

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

6571:
6572: cep_standard.debug('current_org_id =' ||current_org_id );
6573:
6574:
6575: cep_standard.debug('match_engine: >> CE_AUTO_BANK_CLEAR.misc_receipt');
6576:
6577: CE_AUTO_BANK_CLEAR.misc_receipt(
6578: X_passin_mode => 'AUTO_TRX',
6579: X_trx_number =>

Line 6577: CE_AUTO_BANK_CLEAR.misc_receipt(

6573:
6574:
6575: cep_standard.debug('match_engine: >> CE_AUTO_BANK_CLEAR.misc_receipt');
6576:
6577: CE_AUTO_BANK_CLEAR.misc_receipt(
6578: X_passin_mode => 'AUTO_TRX',
6579: X_trx_number =>
6580: CE_AUTO_BANK_MATCH.csl_bank_trx_number || '/NSF',
6581: X_doc_sequence_value => NULL,

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

6623: X_org_id =>
6624: nvl(CE_AUTO_BANK_MATCH.trx_org_id,CE_AUTO_BANK_REC.G_org_id));
6625: --CE_AUTO_BANK_MATCH.bau_org_id);
6626:
6627: cep_standard.debug('end match_engine: >> CE_AUTO_BANK_CLEAR.misc_receipt');
6628: cep_standard.debug('p_cr_id = '|| p_cr_id);
6629:
6630: cep_standard.debug('Create a misc receipt with cash_receipt_id='|| to_char(p_cr_id));
6631: END IF; --validate payment method

Line 6636: cep_standard.debug('Error in CE_AUTO_BANK_CLEAR.misc_receipt');

6632: END IF; -- if not creating foreign misc receipts with null exchange info
6633:
6634: exception
6635: when others then
6636: cep_standard.debug('Error in CE_AUTO_BANK_CLEAR.misc_receipt');
6637: raise;
6638: end;
6639: end if;
6640:

Line 7669: CE_AUTO_BANK_CLEAR.reconcile_trx(

7665: --CE_AUTO_BANK_MATCH.csl_reconcile_flag := CE_AUTO_BANK_MATCH.csl_match_type; --'JE';
7666: --CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CE';
7667: --CE_AUTO_BANK_MATCH.trx_id := CE_AUTO_BANK_MATCH.csl_cashflow_id; --l_je_line_num;
7668:
7669: CE_AUTO_BANK_CLEAR.reconcile_trx(
7670: passin_mode => 'AUTO',
7671: tx_type => CE_AUTO_BANK_MATCH.csl_match_type, -- CASHFLOW --'JE_LINE',
7672: trx_id => CE_AUTO_BANK_MATCH.TRX_id, --l_je_line_num,
7673: trx_status => CE_AUTO_BANK_MATCH.trx_status, --'P',

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

7694: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
7695: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
7696: X_reversed_receipt_flag => CE_AUTO_BANK_MATCH.reversed_receipt_flag);
7697:
7698: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
7699:
7700: -- update the reconciled_status_flag of the GT table, ce_available_transactions_tmp,
7701: -- to 'Y'
7702: update_gt_reconciled_status (CE_AUTO_BANK_MATCH.gt_seq_id, 'Y');

Line 9655: | CE_AUTO_BANK_CLEAR1.reconcile_pbatch |

9651: | |
9652: | CALLED BY |
9653: | match_process |
9654: | match_stmt_line_JE |
9655: | CE_AUTO_BANK_CLEAR1.reconcile_pbatch |
9656: | CE_AUTO_BANK_CLEAR1.reconcile_rbatch |
9657: | CE_AUTO_BANK_CLEAR1.reconcile_pay_eft |
9658: | |
9659: | HISTORY |

Line 9656: | CE_AUTO_BANK_CLEAR1.reconcile_rbatch |

9652: | CALLED BY |
9653: | match_process |
9654: | match_stmt_line_JE |
9655: | CE_AUTO_BANK_CLEAR1.reconcile_pbatch |
9656: | CE_AUTO_BANK_CLEAR1.reconcile_rbatch |
9657: | CE_AUTO_BANK_CLEAR1.reconcile_pay_eft |
9658: | |
9659: | HISTORY |
9660: | 11-MAY-2006 Xin Wang Created |

Line 9657: | CE_AUTO_BANK_CLEAR1.reconcile_pay_eft |

9653: | match_process |
9654: | match_stmt_line_JE |
9655: | CE_AUTO_BANK_CLEAR1.reconcile_pbatch |
9656: | CE_AUTO_BANK_CLEAR1.reconcile_rbatch |
9657: | CE_AUTO_BANK_CLEAR1.reconcile_pay_eft |
9658: | |
9659: | HISTORY |
9660: | 11-MAY-2006 Xin Wang Created |
9661: --------------------------------------------------------------------- */

Line 9685: | CE_AUTO_BANK_CLEAR1.unclear_process |

9681: | ce_available_transactions_tmp |
9682: | mainly used to update the status to 'N' during unreconciliation |
9683: | |
9684: | CALLED BY |
9685: | CE_AUTO_BANK_CLEAR1.unclear_process |
9686: | |
9687: | HISTORY |
9688: | 11-MAY-2006 Xin Wang Created |
9689: --------------------------------------------------------------------- */

Line 9715: | CE_AUTO_BANK_CLEAR1.unclear_process |

9711: | mainly used to update the status to 'N' during |
9712: | auto unreconciliation |
9713: | |
9714: | CALLED BY |
9715: | CE_AUTO_BANK_CLEAR1.unclear_process |
9716: | |
9717: | HISTORY |
9718: | 11-MAY-2006 Xin Wang Created |
9719: --------------------------------------------------------------------- */

Line 9761: | CE_AUTO_BANK_CLEAR.reconcile_process |

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 |
9763: | Get_Min_Statement_Line_Id |
9764: | |
9765: | CALLED BY |

Line 10247: CE_AUTO_BANK_CLEAR.reconcile_process;

10243: -- bug 4914608 set the org after a match for AR/AP
10244: cep_standard.debug('CE_AUTO_BANK_MATCH.trx_org_id =' ||CE_AUTO_BANK_MATCH.trx_org_id);
10245: set_single_org(CE_AUTO_BANK_MATCH.trx_org_id);
10246:
10247: CE_AUTO_BANK_CLEAR.reconcile_process;
10248:
10249: -- after a match and reconcilation,
10250: -- update the ce_available_transactions_tmp.reconciled_status_flag
10251: IF (CE_AUTO_BANK_MATCH.gt_seq_id is not null) AND