DBA Data[Home] [Help]

APPS.CE_CUSTOM_BANK_VALIDATIONS dependencies on CE_CUSTOM_BANK_VALIDATIONS

Line 1: PACKAGE BODY CE_CUSTOM_BANK_VALIDATIONS AS

1: PACKAGE BODY CE_CUSTOM_BANK_VALIDATIONS AS
2: /* $Header: cecbnkvb.pls 120.1.12010000.3 2009/12/24 07:18:41 vnetan noship $ */
3:
4: /*----------------------------------------------------------------------+
5: | PRIVATE PROCEDURE |

Line 70: debug_log('>>CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_bank');

66:
67: l_bank_num HZ_ORGANIZATION_PROFILES.bank_or_branch_number%TYPE;
68:
69: BEGIN
70: debug_log('>>CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_bank');
71: -- Initialize Return values
72: Xo_RETURN_STATUS := fnd_api.g_ret_sts_success;
73: Xo_BANK_NUM_OUT := Xi_BANK_NUMBER;
74:

Line 103: debug_log('<

99: Xo_RETURN_STATUS := fnd_api.g_ret_sts_error;
100: END IF;
101: ------------------------------------------------------------------------------*/
102:
103: debug_log('< 104: EXCEPTION
105: WHEN OTHERS THEN
106: debug_log('EXCEPTION: CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_bank');
107: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');

Line 106: debug_log('EXCEPTION: CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_bank');

102:
103: debug_log('< 104: EXCEPTION
105: WHEN OTHERS THEN
106: debug_log('EXCEPTION: CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_bank');
107: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
108: FND_MESSAGE.set_token('PROCEDURE', 'CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_bank');
109: FND_MSG_PUB.add;
110: RAISE;

Line 108: FND_MESSAGE.set_token('PROCEDURE', 'CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_bank');

104: EXCEPTION
105: WHEN OTHERS THEN
106: debug_log('EXCEPTION: CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_bank');
107: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
108: FND_MESSAGE.set_token('PROCEDURE', 'CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_bank');
109: FND_MSG_PUB.add;
110: RAISE;
111: END ce_usr_validate_bank;
112: /*----------------------------------------------------------------------+

Line 156: debug_log('>>CE_CUSTOM_BANK_VALIDATIONS.ce_usr_validate_branch');

152:
153: l_branch_num HZ_ORGANIZATION_PROFILES.bank_or_branch_number%TYPE;
154:
155: BEGIN
156: debug_log('>>CE_CUSTOM_BANK_VALIDATIONS.ce_usr_validate_branch');
157: -- Initialize return values
158: Xo_RETURN_STATUS := fnd_api.g_ret_sts_success;
159: Xo_BRANCH_NUM_OUT := Xi_BRANCH_NUMBER;
160:

Line 194: debug_log('<

190: END IF;
191: END IF;
192: ------------------------------------------------------------------------------*/
193:
194: debug_log('< 195:
196: EXCEPTION
197: WHEN OTHERS THEN
198: debug_log('EXCEPTION: CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_branch');

Line 198: debug_log('EXCEPTION: CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_branch');

194: debug_log('< 195:
196: EXCEPTION
197: WHEN OTHERS THEN
198: debug_log('EXCEPTION: CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_branch');
199: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
200: FND_MESSAGE.set_token('PROCEDURE', 'CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_branch');
201: FND_MSG_PUB.add;
202: RAISE;

Line 200: FND_MESSAGE.set_token('PROCEDURE', 'CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_branch');

196: EXCEPTION
197: WHEN OTHERS THEN
198: debug_log('EXCEPTION: CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_branch');
199: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
200: FND_MESSAGE.set_token('PROCEDURE', 'CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_branch');
201: FND_MSG_PUB.add;
202: RAISE;
203: END ce_usr_validate_branch;
204:

Line 260: debug_log('>>CE_CUSTOM_BANK_VALIDATIONS.ce_usr_validate_account');

256: /* CURSOR c_acct_details IS
257: SELECT * FROM CE_BANK_ACCOUNTS WHERE bank_account_id = Xi_Account_id;*/
258:
259: BEGIN
260: debug_log('>>CE_CUSTOM_BANK_VALIDATIONS.ce_usr_validate_account');
261: -- Initialize Return values
262: Xo_RETURN_STATUS := fnd_api.g_ret_sts_success;
263: Xo_ACCOUNT_NUM_OUT := Xi_ACCOUNT_NUMBER;
264:

Line 307: debug_log('<

303: set_error_text('CE_CUSTOM_ACCOUNT');
304: Xo_RETURN_STATUS := fnd_api.g_ret_sts_error;
305: END IF;
306: ------------------------------------------------------------------------------*/
307: debug_log('< 308:
309: EXCEPTION
310: WHEN OTHERS THEN
311: debug_log('EXCEPTION: CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_account');

Line 311: debug_log('EXCEPTION: CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_account');

307: debug_log('< 308:
309: EXCEPTION
310: WHEN OTHERS THEN
311: debug_log('EXCEPTION: CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_account');
312: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
313: FND_MESSAGE.set_token('PROCEDURE', 'CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_account');
314: FND_MSG_PUB.add;
315: RAISE;

Line 313: FND_MESSAGE.set_token('PROCEDURE', 'CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_account');

309: EXCEPTION
310: WHEN OTHERS THEN
311: debug_log('EXCEPTION: CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_account');
312: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
313: FND_MESSAGE.set_token('PROCEDURE', 'CE_CUSTOM_BANK_VALIDATIONS.ce_usr_valdiate_account');
314: FND_MSG_PUB.add;
315: RAISE;
316: END ce_usr_validate_account;
317:

Line 318: END CE_CUSTOM_BANK_VALIDATIONS;

314: FND_MSG_PUB.add;
315: RAISE;
316: END ce_usr_validate_account;
317:
318: END CE_CUSTOM_BANK_VALIDATIONS;