DBA Data[Home] [Help]

APPS.AP_AUTO_PAYMENT_PKG dependencies on FND_LOG

Line 4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY AP_AUTO_PAYMENT_PKG AS
2: /* $Header: apautopb.pls 120.19.12020000.4 2013/01/31 00:36:24 tjbhatt ship $ */
3:
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

1: PACKAGE BODY AP_AUTO_PAYMENT_PKG AS
2: /* $Header: apautopb.pls 120.19.12020000.4 2013/01/31 00:36:24 tjbhatt ship $ */
3:
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

2: /* $Header: apautopb.pls 120.19.12020000.4 2013/01/31 00:36:24 tjbhatt ship $ */
3:
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

3:
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'AP.PLSQL.AP_AUTO_PAYMENT_PKG.';

Line 8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'AP.PLSQL.AP_AUTO_PAYMENT_PKG.';
12:

Line 9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'AP.PLSQL.AP_AUTO_PAYMENT_PKG.';
12:
13: --Bugfix 2124107 - Add one more parameter p_last_update_login

Line 10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'AP.PLSQL.AP_AUTO_PAYMENT_PKG.';
12:
13: --Bugfix 2124107 - Add one more parameter p_last_update_login
14:

Line 163: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);

159: -- Added call to get new voucher number Bug #510855
160:
161: l_debug_info := 'Selecting Category Code and SOB';
162: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
163: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);
164: END IF;
165:
166:
167: -- Fix for bug 547662

Line 202: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);

198: --
199: -------------------------------------------------------------------
200: l_debug_info := 'Get replace_check_id';
201: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
202: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);
203: END IF;
204:
205:
206: SELECT ap_checks_s.nextval

Line 213: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);

209:
210: -------------------------------------------------------------------
211: l_debug_info := 'Insert into ap_checks for replace_check_id';
212: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
213: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);
214: END IF;
215:
216: /* Bug 4759178. Added Org_id */
217: INSERT INTO AP_CHECKS

Line 377: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);

373:
374: -------------------------------------------------------------------
375: l_debug_info := 'Update ap_check_stocks';
376: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
377: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);
378: END IF;
379:
380: UPDATE ap_check_stocks
381: SET last_document_num = P_Replace_Check_Num,

Line 392: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);

388:
389: -------------------------------------------------------------------
390: l_debug_info := 'Open c_new_payments cursor';
391: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
392: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);
393: END IF;
394:
395: OPEN c_new_payments;
396:

Line 401: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);

397: LOOP
398: ---------------------------------------------------------------
399: l_debug_info := 'Fetch from c_new_payments cursor';
400: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
401: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);
402: END IF;
403:
404: FETCH c_new_payments INTO rec_new_payments;
405: EXIT WHEN c_new_payments%NOTFOUND;

Line 426: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);

422: and aip.check_id= p_old_check_id;
423:
424: l_debug_info := 'l_prev_amt_paid -- '||to_char(l_prev_amt_paid);
425: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
426: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);
427: END IF;
428:
429:
430: -- BUG 4121323 : selecting base_amount

Line 444: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);

440: and aip.invoice_id=rec_new_payments.invoice_id);
441:
442: l_debug_info := 'l_prev_withheld_amt -- '||to_char(l_prev_withheld_amt);
443: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
444: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);
445: END IF;
446:
447:
448: l_awt_gross_amount:=l_prev_amt_paid-l_prev_withheld_amt;

Line 476: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);

472: --end bug14308871
473:
474: l_debug_info := 'l_awt_gross_amount -- '||to_char(l_awt_gross_amount);
475: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
476: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);
477: END IF;
478:
479:
480: /* Bug 3309344 commenting this select statement

Line 494: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);

490: -- Bugfix 2124107 - Pass p_last_update_login instead of null to procedure
491:
492: l_debug_info := 'calling AP_DO_WITHHOLDING';
493: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
494: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);
495: END IF;
496:
497:
498: AP_WITHHOLDING_PKG.AP_Do_Withholding(

Line 604: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);

600:
601: -------------------------------------------------------------------
602: l_debug_info := 'Close c_new_payments cursor';
603: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
604: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'AP_AUTO_PAYMENT_PKG',l_debug_info);
605: END IF;
606:
607: CLOSE c_new_payments;
608: