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.PSA_MFAR_VAL_PKG dependencies on FND_LOG

Line 5: --===========================FND_LOG.START=====================================

1: PACKAGE BODY PSA_MFAR_VAL_PKG AS
2: /* $Header: PSAMFVLB.pls 120.10 2006/09/13 14:09:08 agovil ship $ */
3:
4: /* Procedure to Validate the Transaction Header */
5: --===========================FND_LOG.START=====================================
6: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
7: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
9: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 6: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;

2: /* $Header: PSAMFVLB.pls 120.10 2006/09/13 14:09:08 agovil ship $ */
3:
4: /* Procedure to Validate the Transaction Header */
5: --===========================FND_LOG.START=====================================
6: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
7: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
9: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;

Line 7: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

3:
4: /* Procedure to Validate the Transaction Header */
5: --===========================FND_LOG.START=====================================
6: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
7: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
9: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
11: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 8: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;

4: /* Procedure to Validate the Transaction Header */
5: --===========================FND_LOG.START=====================================
6: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
7: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
9: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
11: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFVLB.PSA_MFAR_VAL_PKG.';

Line 9: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

5: --===========================FND_LOG.START=====================================
6: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
7: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
9: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
11: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFVLB.PSA_MFAR_VAL_PKG.';
13: --===========================FND_LOG.END=======================================

Line 10: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;

6: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
7: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
9: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
11: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFVLB.PSA_MFAR_VAL_PKG.';
13: --===========================FND_LOG.END=======================================
14:

Line 11: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;

7: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
9: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
11: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFVLB.PSA_MFAR_VAL_PKG.';
13: --===========================FND_LOG.END=======================================
14:
15: PROCEDURE AR_MFAR_VALIDATE_TRX_HEADER(

Line 13: --===========================FND_LOG.END=======================================

9: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
11: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFVLB.PSA_MFAR_VAL_PKG.';
13: --===========================FND_LOG.END=======================================
14:
15: PROCEDURE AR_MFAR_VALIDATE_TRX_HEADER(
16: X_TRANSACTION_TYPE_ID Number,
17: X_TRANSACTION_CLASS varchar2,

Line 40: -- ========================= FND LOG ===========================

36: -- l_api_name varchar2(30) := 'PSP_PAYTRN';
37: l_subline_message varchar2(200);
38: l_payment_method varchar2(30);
39: l_trx_type_check varchar2(1) ;
40: -- ========================= FND LOG ===========================
41: l_full_path VARCHAR2(100) := g_path || 'AR_MFAR_VALIDATE_TRX_HEADER';
42: -- ========================= FND LOG ===========================
43: BEGIN
44: FND_MSG_PUB.Initialize;

Line 42: -- ========================= FND LOG ===========================

38: l_payment_method varchar2(30);
39: l_trx_type_check varchar2(1) ;
40: -- ========================= FND LOG ===========================
41: l_full_path VARCHAR2(100) := g_path || 'AR_MFAR_VALIDATE_TRX_HEADER';
42: -- ========================= FND LOG ===========================
43: BEGIN
44: FND_MSG_PUB.Initialize;
45:
46: if (arp_global.sysparam.accounting_method <> 'ACCRUAL' ) then

Line 73: -- ========================= FND LOG ===========================

69:
70: if
71: X_TRANSACTION_CLASS = 'GUAR' then
72: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_CLASS_GUAR');
73: -- ========================= FND LOG ===========================
74: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
75: -- ========================= FND LOG ===========================
76: APP_EXCEPTION.RAISE_EXCEPTION;
77: fnd_msg_pub.add;

Line 75: -- ========================= FND LOG ===========================

71: X_TRANSACTION_CLASS = 'GUAR' then
72: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_CLASS_GUAR');
73: -- ========================= FND LOG ===========================
74: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
75: -- ========================= FND LOG ===========================
76: APP_EXCEPTION.RAISE_EXCEPTION;
77: fnd_msg_pub.add;
78: RAISE FND_API.G_EXC_ERROR;
79:

Line 83: -- ========================= FND LOG ===========================

79:
80: elsif
81: X_TRANSACTION_CLASS = 'CM' then
82: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_CLASS_CM');
83: -- ========================= FND LOG ===========================
84: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
85: -- ========================= FND LOG ===========================
86: APP_EXCEPTION.RAISE_EXCEPTION;
87: fnd_msg_pub.add;

Line 85: -- ========================= FND LOG ===========================

81: X_TRANSACTION_CLASS = 'CM' then
82: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_CLASS_CM');
83: -- ========================= FND LOG ===========================
84: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
85: -- ========================= FND LOG ===========================
86: APP_EXCEPTION.RAISE_EXCEPTION;
87: fnd_msg_pub.add;
88: RAISE FND_API.G_EXC_ERROR;
89:

Line 93: -- ========================= FND LOG ===========================

89:
90: elsif
91: X_TRANSACTION_CLASS = 'CB' then
92: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_CLASS_CB');
93: -- ========================= FND LOG ===========================
94: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
95: -- ========================= FND LOG ===========================
96: APP_EXCEPTION.RAISE_EXCEPTION;
97: fnd_msg_pub.add;

Line 95: -- ========================= FND LOG ===========================

91: X_TRANSACTION_CLASS = 'CB' then
92: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_CLASS_CB');
93: -- ========================= FND LOG ===========================
94: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
95: -- ========================= FND LOG ===========================
96: APP_EXCEPTION.RAISE_EXCEPTION;
97: fnd_msg_pub.add;
98: RAISE FND_API.G_EXC_ERROR;
99: end if;

Line 116: -- ========================= FND LOG ===========================

112: and rownum < 2 ;
113:
114: if (l_base_currency <> X_BASE_CURRENCY_CODE) then
115: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_CURRENCY_CODE');
116: -- ========================= FND LOG ===========================
117: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
118: -- ========================= FND LOG ===========================
119: APP_EXCEPTION.RAISE_EXCEPTION;
120: fnd_msg_pub.add;

Line 118: -- ========================= FND LOG ===========================

114: if (l_base_currency <> X_BASE_CURRENCY_CODE) then
115: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_CURRENCY_CODE');
116: -- ========================= FND LOG ===========================
117: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
118: -- ========================= FND LOG ===========================
119: APP_EXCEPTION.RAISE_EXCEPTION;
120: fnd_msg_pub.add;
121: RAISE FND_API.G_EXC_ERROR;
122: end if;

Line 153: -- ========================= FND LOG ===========================

149:
150:
151: if (X_INVOICE_RULE_ID is not null) then
152: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_TRX_RULES');
153: -- ========================= FND LOG ===========================
154: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
155: -- ========================= FND LOG ===========================
156: APP_EXCEPTION.RAISE_EXCEPTION;
157: fnd_msg_pub.add;

Line 155: -- ========================= FND LOG ===========================

151: if (X_INVOICE_RULE_ID is not null) then
152: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_TRX_RULES');
153: -- ========================= FND LOG ===========================
154: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
155: -- ========================= FND LOG ===========================
156: APP_EXCEPTION.RAISE_EXCEPTION;
157: fnd_msg_pub.add;
158: RAISE FND_API.G_EXC_ERROR;
159: end if;

Line 168: -- ========================= FND LOG ===========================

164: +-------------------------------------------------------------------------*/
165:
166: if X_TRX_COMMITMENT_NUMBER is not null then
167: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_COMMITMENT_NO');
168: -- ========================= FND LOG ===========================
169: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
170: -- ========================= FND LOG ===========================
171: APP_EXCEPTION.RAISE_EXCEPTION;
172: fnd_msg_pub.add;

Line 170: -- ========================= FND LOG ===========================

166: if X_TRX_COMMITMENT_NUMBER is not null then
167: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_COMMITMENT_NO');
168: -- ========================= FND LOG ===========================
169: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
170: -- ========================= FND LOG ===========================
171: APP_EXCEPTION.RAISE_EXCEPTION;
172: fnd_msg_pub.add;
173: RAISE FND_API.G_EXC_ERROR;
174: end if;

Line 183: -- ========================= FND LOG ===========================

179: EXCEPTION
180: WHEN NO_DATA_FOUND or TOO_MANY_ROWS then
181: return;
182: WHEN OTHERS then
183: -- ========================= FND LOG ===========================
184: psa_utils.debug_unexpected_msg(l_full_path);
185: -- ========================= FND LOG ===========================
186: RAISE;
187: end AR_MFAR_VALIDATE_TRX_HEADER;

Line 185: -- ========================= FND LOG ===========================

181: return;
182: WHEN OTHERS then
183: -- ========================= FND LOG ===========================
184: psa_utils.debug_unexpected_msg(l_full_path);
185: -- ========================= FND LOG ===========================
186: RAISE;
187: end AR_MFAR_VALIDATE_TRX_HEADER;
188:
189: /* Procedure to validate a Credit Memo */

Line 209: -- ========================= FND LOG ===========================

205: l_profile_val varchar2(240);
206: l_base_currency varchar2(15);
207: l_accounting_method varchar2(30);
208: l_trx_type_check varchar2(1);
209: -- ========================= FND LOG ===========================
210: l_full_path VARCHAR2(100) := g_path || 'AR_MFAR_CM_VAL_CHECK';
211: -- ========================= FND LOG ===========================
212:
213: BEGIN

Line 211: -- ========================= FND LOG ===========================

207: l_accounting_method varchar2(30);
208: l_trx_type_check varchar2(1);
209: -- ========================= FND LOG ===========================
210: l_full_path VARCHAR2(100) := g_path || 'AR_MFAR_CM_VAL_CHECK';
211: -- ========================= FND LOG ===========================
212:
213: BEGIN
214:
215: FND_MSG_PUB.Initialize;

Line 246: -- ========================= FND LOG ===========================

242: and rownum < 2 ;
243:
244: if (l_base_currency <> X_BASE_CURRENCY_CODE) then
245: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_CURRENCY_CODE');
246: -- ========================= FND LOG ===========================
247: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
248: -- ========================= FND LOG ===========================
249: fnd_msg_pub.add;
250: RAISE FND_API.G_EXC_ERROR;

Line 248: -- ========================= FND LOG ===========================

244: if (l_base_currency <> X_BASE_CURRENCY_CODE) then
245: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_CURRENCY_CODE');
246: -- ========================= FND LOG ===========================
247: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
248: -- ========================= FND LOG ===========================
249: fnd_msg_pub.add;
250: RAISE FND_API.G_EXC_ERROR;
251: end if;
252:

Line 267: -- ========================= FND LOG ===========================

263: */
264:
265: if (l_profile_val <> 'Y' ) then
266: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_PROFILE_VAL');
267: -- ========================= FND LOG ===========================
268: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
269: -- ========================= FND LOG ===========================
270: APP_EXCEPTION.RAISE_EXCEPTION;
271: fnd_msg_pub.add;

Line 269: -- ========================= FND LOG ===========================

265: if (l_profile_val <> 'Y' ) then
266: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_PROFILE_VAL');
267: -- ========================= FND LOG ===========================
268: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
269: -- ========================= FND LOG ===========================
270: APP_EXCEPTION.RAISE_EXCEPTION;
271: fnd_msg_pub.add;
272: RAISE FND_API.G_EXC_ERROR;
273: end if;

Line 282: -- ========================= FND LOG ===========================

278: EXCEPTION
279: WHEN NO_DATA_FOUND or TOO_MANY_ROWS then
280: return;
281: WHEN OTHERS then
282: -- ========================= FND LOG ===========================
283: psa_utils.debug_unexpected_msg(l_full_path);
284: -- ========================= FND LOG ===========================
285: RAISE;
286: end AR_MFAR_CM_VAL_CHECK;

Line 284: -- ========================= FND LOG ===========================

280: return;
281: WHEN OTHERS then
282: -- ========================= FND LOG ===========================
283: psa_utils.debug_unexpected_msg(l_full_path);
284: -- ========================= FND LOG ===========================
285: RAISE;
286: end AR_MFAR_CM_VAL_CHECK;
287:
288: /* Procedure to validate a Transaction ,Receipt or an Adjustment */

Line 302: -- ========================= FND LOG ===========================

298: l_return_status varchar2(1);
299: l_validate_trx varchar2(1);
300: l_validate_adj varchar2(1);
301: l_app_cust_trx_id number;
302: -- ========================= FND LOG ===========================
303: l_full_path VARCHAR2(100) := g_path || 'AR_MFAR_VALIDATE_CHECK';
304: -- ========================= FND LOG ===========================
305: Begin
306:

Line 304: -- ========================= FND LOG ===========================

300: l_validate_adj varchar2(1);
301: l_app_cust_trx_id number;
302: -- ========================= FND LOG ===========================
303: l_full_path VARCHAR2(100) := g_path || 'AR_MFAR_VALIDATE_CHECK';
304: -- ========================= FND LOG ===========================
305: Begin
306:
307: l_return_status := 'N' ;
308: FND_MSG_PUB.Initialize;

Line 364: -- ========================= FND LOG ===========================

360: WHEN NO_DATA_FOUND or TOO_MANY_ROWS then
361: l_return_status := 'N';
362: return(l_return_status);
363: WHEN OTHERS then
364: -- ========================= FND LOG ===========================
365: psa_utils.debug_unexpected_msg(l_full_path);
366: -- ========================= FND LOG ===========================
367: RAISE;
368:

Line 366: -- ========================= FND LOG ===========================

362: return(l_return_status);
363: WHEN OTHERS then
364: -- ========================= FND LOG ===========================
365: psa_utils.debug_unexpected_msg(l_full_path);
366: -- ========================= FND LOG ===========================
367: RAISE;
368:
369: end AR_MFAR_VALIDATE_CHECK;
370:

Line 390: -- ========================= FND LOG ===========================

386: l_rct_check varchar2(1);
387: l_inv_currency_code varchar2(15);
388: l_rct_currency_code varchar2(15);
389: l_org_id number(15);
390: -- ========================= FND LOG ===========================
391: l_full_path VARCHAR2(100) := g_path || 'AR_MFAR_RECEIPT_CHECK';
392: -- ========================= FND LOG ===========================
393: begin
394:

Line 392: -- ========================= FND LOG ===========================

388: l_rct_currency_code varchar2(15);
389: l_org_id number(15);
390: -- ========================= FND LOG ===========================
391: l_full_path VARCHAR2(100) := g_path || 'AR_MFAR_RECEIPT_CHECK';
392: -- ========================= FND LOG ===========================
393: begin
394:
395: l_return_status := 'N';
396:

Line 438: -- ========================= FND LOG ===========================

434: where cash_receipt_id = X_RECEIPT_ID ;
435:
436: if (l_inv_currency_code <> l_rct_currency_code ) then
437: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_CURRENCY_CODE');
438: -- ========================= FND LOG ===========================
439: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
440: -- ========================= FND LOG ===========================
441: -- FND_MESSAGE.SHOW ;
442: APP_EXCEPTION.RAISE_EXCEPTION;

Line 440: -- ========================= FND LOG ===========================

436: if (l_inv_currency_code <> l_rct_currency_code ) then
437: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_CURRENCY_CODE');
438: -- ========================= FND LOG ===========================
439: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
440: -- ========================= FND LOG ===========================
441: -- FND_MESSAGE.SHOW ;
442: APP_EXCEPTION.RAISE_EXCEPTION;
443: fnd_msg_pub.add;
444: RAISE FND_API.G_EXC_ERROR;

Line 455: -- ========================= FND LOG ===========================

451: and b.receipt_method_id = X_RECEIPT_METHOD_ID ;
452:
453: if (l_remit_flag = 'Y') then
454: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_REMIT_CODE');
455: -- ========================= FND LOG ===========================
456: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
457: -- ========================= FND LOG ===========================
458: APP_EXCEPTION.RAISE_EXCEPTION;
459: fnd_msg_pub.add;

Line 457: -- ========================= FND LOG ===========================

453: if (l_remit_flag = 'Y') then
454: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_REMIT_CODE');
455: -- ========================= FND LOG ===========================
456: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
457: -- ========================= FND LOG ===========================
458: APP_EXCEPTION.RAISE_EXCEPTION;
459: fnd_msg_pub.add;
460: RAISE FND_API.G_EXC_ERROR;
461: elsif l_remit_flag = 'N' then

Line 464: -- ========================= FND LOG ===========================

460: RAISE FND_API.G_EXC_ERROR;
461: elsif l_remit_flag = 'N' then
462: if l_confirm_flag = 'Y' then
463: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_CONFIRM_CODE');
464: -- ========================= FND LOG ===========================
465: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
466: -- ========================= FND LOG ===========================
467: APP_EXCEPTION.RAISE_EXCEPTION;
468: fnd_msg_pub.add;

Line 466: -- ========================= FND LOG ===========================

462: if l_confirm_flag = 'Y' then
463: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_CONFIRM_CODE');
464: -- ========================= FND LOG ===========================
465: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
466: -- ========================= FND LOG ===========================
467: APP_EXCEPTION.RAISE_EXCEPTION;
468: fnd_msg_pub.add;
469: RAISE FND_API.G_EXC_ERROR;
470: elsif l_confirm_flag = 'N' then

Line 486: -- ========================= FND LOG ===========================

482: WHEN NO_DATA_FOUND or TOO_MANY_ROWS then
483: l_return_status := 'N';
484: return(l_return_status);
485: WHEN OTHERS then
486: -- ========================= FND LOG ===========================
487: psa_utils.debug_unexpected_msg(l_full_path);
488: -- ========================= FND LOG ===========================
489: RAISE;
490:

Line 488: -- ========================= FND LOG ===========================

484: return(l_return_status);
485: WHEN OTHERS then
486: -- ========================= FND LOG ===========================
487: psa_utils.debug_unexpected_msg(l_full_path);
488: -- ========================= FND LOG ===========================
489: RAISE;
490:
491: end AR_MFAR_RECEIPT_CHECK ;
492:

Line 497: -- ========================= FND LOG ===========================

493: /* Procedure to check for the validation of Quick Cash */
494: PROCEDURE ar_mfar_quickcash (x_receipt_method_id number) is
495: l_confirm_flag varchar2(1);
496: l_remit_flag varchar2(1);
497: -- ========================= FND LOG ===========================
498: l_full_path VARCHAR2(100) := g_path || 'ar_mfar_quickcash';
499: -- ========================= FND LOG ===========================
500: begin
501: FND_MSG_PUB.Initialize;

Line 499: -- ========================= FND LOG ===========================

495: l_confirm_flag varchar2(1);
496: l_remit_flag varchar2(1);
497: -- ========================= FND LOG ===========================
498: l_full_path VARCHAR2(100) := g_path || 'ar_mfar_quickcash';
499: -- ========================= FND LOG ===========================
500: begin
501: FND_MSG_PUB.Initialize;
502: SELECT
503: a.REMIT_FLAG,

Line 517: -- ========================= FND LOG ===========================

513: b.receipt_method_id = X_RECEIPT_METHOD_ID ;
514:
515: if (l_remit_flag = 'Y') then
516: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_REMIT_CODE');
517: -- ========================= FND LOG ===========================
518: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
519: -- ========================= FND LOG ===========================
520: APP_EXCEPTION.RAISE_EXCEPTION;
521: fnd_msg_pub.add;

Line 519: -- ========================= FND LOG ===========================

515: if (l_remit_flag = 'Y') then
516: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_REMIT_CODE');
517: -- ========================= FND LOG ===========================
518: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
519: -- ========================= FND LOG ===========================
520: APP_EXCEPTION.RAISE_EXCEPTION;
521: fnd_msg_pub.add;
522: RAISE FND_API.G_EXC_ERROR;
523: elsif l_remit_flag = 'N' then

Line 526: -- ========================= FND LOG ===========================

522: RAISE FND_API.G_EXC_ERROR;
523: elsif l_remit_flag = 'N' then
524: if l_confirm_flag = 'Y' then
525: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_CONFIRM_CODE');
526: -- ========================= FND LOG ===========================
527: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
528: -- ========================= FND LOG ===========================
529: APP_EXCEPTION.RAISE_EXCEPTION;
530: fnd_msg_pub.add;

Line 528: -- ========================= FND LOG ===========================

524: if l_confirm_flag = 'Y' then
525: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_CONFIRM_CODE');
526: -- ========================= FND LOG ===========================
527: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
528: -- ========================= FND LOG ===========================
529: APP_EXCEPTION.RAISE_EXCEPTION;
530: fnd_msg_pub.add;
531: RAISE FND_API.G_EXC_ERROR;
532: elsif l_confirm_flag = 'N' then

Line 539: -- ========================= FND LOG ===========================

535: end if;
536: end if;
537: EXCEPTION
538: when OTHERS then
539: -- ========================= FND LOG ===========================
540: psa_utils.debug_unexpected_msg(l_full_path);
541: -- ========================= FND LOG ===========================
542: RAISE;
543:

Line 541: -- ========================= FND LOG ===========================

537: EXCEPTION
538: when OTHERS then
539: -- ========================= FND LOG ===========================
540: psa_utils.debug_unexpected_msg(l_full_path);
541: -- ========================= FND LOG ===========================
542: RAISE;
543:
544: END ar_mfar_quickcash;
545:

Line 556: -- ========================= FND LOG ===========================

552: l_base_currency varchar2(15);
553: l_payment_method_check varchar2(1) ;
554: -- it_id item ;
555: l_set_of_books_id gl_sets_of_books.set_of_books_id%type;
556: -- ========================= FND LOG ===========================
557: l_full_path VARCHAR2(100) := g_path || 'AR_LOCKBOX_VALIDATION';
558: -- ========================= FND LOG ===========================
559:
560: begin

Line 558: -- ========================= FND LOG ===========================

554: -- it_id item ;
555: l_set_of_books_id gl_sets_of_books.set_of_books_id%type;
556: -- ========================= FND LOG ===========================
557: l_full_path VARCHAR2(100) := g_path || 'AR_LOCKBOX_VALIDATION';
558: -- ========================= FND LOG ===========================
559:
560: begin
561: l_return_status := 'N' ;
562: -- FND_PROFILE.GET('GL_SET_OF_BKS_ID', l_set_of_books_id);

Line 592: -- ========================= FND LOG ===========================

588: WHEN NO_DATA_FOUND or TOO_MANY_ROWS then
589: -- return(l_return_status);
590: null;
591: WHEN OTHERS then
592: -- ========================= FND LOG ===========================
593: psa_utils.debug_unexpected_msg(l_full_path);
594: -- ========================= FND LOG ===========================
595: RAISE;
596: END ;

Line 594: -- ========================= FND LOG ===========================

590: null;
591: WHEN OTHERS then
592: -- ========================= FND LOG ===========================
593: psa_utils.debug_unexpected_msg(l_full_path);
594: -- ========================= FND LOG ===========================
595: RAISE;
596: END ;
597:
598: BEGIN

Line 616: -- ========================= FND LOG ===========================

612: EXCEPTION
613: WHEN NO_DATA_FOUND or TOO_MANY_ROWS then
614: return(l_return_status);
615: WHEN OTHERS then
616: -- ========================= FND LOG ===========================
617: psa_utils.debug_unexpected_msg(l_full_path);
618: -- ========================= FND LOG ===========================
619: RAISE;
620: return(l_return_status);

Line 618: -- ========================= FND LOG ===========================

614: return(l_return_status);
615: WHEN OTHERS then
616: -- ========================= FND LOG ===========================
617: psa_utils.debug_unexpected_msg(l_full_path);
618: -- ========================= FND LOG ===========================
619: RAISE;
620: return(l_return_status);
621: END ;
622: end AR_LOCKBOX_VALIDATION ;

Line 861: -- ========================= FND LOG ===========================

857: l_remit_flag ar_receipt_classes.remit_flag%TYPE;
858: l_mf_type VARCHAR2(1) := NULL;
859: l_return_flag VARCHAR2(1);
860: mf_rct_invalid EXCEPTION;
861: -- ========================= FND LOG ===========================
862: l_full_path VARCHAR2(100) := g_path || 'MISC_RCT_VAL';
863: -- ========================= FND LOG ===========================
864:
865: BEGIN

Line 863: -- ========================= FND LOG ===========================

859: l_return_flag VARCHAR2(1);
860: mf_rct_invalid EXCEPTION;
861: -- ========================= FND LOG ===========================
862: l_full_path VARCHAR2(100) := g_path || 'MISC_RCT_VAL';
863: -- ========================= FND LOG ===========================
864:
865: BEGIN
866:
867: FND_MSG_PUB.Initialize;

Line 893: -- ========================= FND LOG ===========================

889: WHEN mf_rct_invalid THEN
890: RETURN l_return_flag;
891:
892: FND_MESSAGE.SET_NAME('PSA','PSA_MF_MISC_INVALID');
893: -- ========================= FND LOG ===========================
894: psa_utils.debug_other_msg(g_excep_level,l_full_path,FALSE);
895: -- ========================= FND LOG ===========================
896: APP_EXCEPTION.RAISE_EXCEPTION;
897: fnd_msg_pub.add;

Line 895: -- ========================= FND LOG ===========================

891:
892: FND_MESSAGE.SET_NAME('PSA','PSA_MF_MISC_INVALID');
893: -- ========================= FND LOG ===========================
894: psa_utils.debug_other_msg(g_excep_level,l_full_path,FALSE);
895: -- ========================= FND LOG ===========================
896: APP_EXCEPTION.RAISE_EXCEPTION;
897: fnd_msg_pub.add;
898: RAISE FND_API.G_EXC_ERROR;
899:

Line 901: -- ========================= FND LOG ===========================

897: fnd_msg_pub.add;
898: RAISE FND_API.G_EXC_ERROR;
899:
900: WHEN OTHERS THEN
901: -- ========================= FND LOG ===========================
902: psa_utils.debug_other_string(g_excep_level,l_full_path, 'Other exception');
903: psa_utils.debug_other_string(g_excep_level,l_full_path, SQLCODE || SQLERRM);
904: psa_utils.debug_unexpected_msg(l_full_path);
905: -- ========================= FND LOG ===========================

Line 905: -- ========================= FND LOG ===========================

901: -- ========================= FND LOG ===========================
902: psa_utils.debug_other_string(g_excep_level,l_full_path, 'Other exception');
903: psa_utils.debug_other_string(g_excep_level,l_full_path, SQLCODE || SQLERRM);
904: psa_utils.debug_unexpected_msg(l_full_path);
905: -- ========================= FND LOG ===========================
906: RAISE;
907:
908:
909: END;