DBA Data[Home] [Help]

APPS.PSA_MFAR_RECEIPTS_COVER_PKG dependencies on FND_LOG

Line 3: --===========================FND_LOG.START=====================================

1: package body psa_mfar_receipts_cover_pkg as
2: /* $Header: PSAMFRHB.pls 120.7 2006/09/13 13:42:25 agovil ship $ */
3: --===========================FND_LOG.START=====================================
4: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
5: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
6: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
7: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 4: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1: package body psa_mfar_receipts_cover_pkg as
2: /* $Header: PSAMFRHB.pls 120.7 2006/09/13 13:42:25 agovil ship $ */
3: --===========================FND_LOG.START=====================================
4: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
5: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
6: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
7: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;

Line 5: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1: package body psa_mfar_receipts_cover_pkg as
2: /* $Header: PSAMFRHB.pls 120.7 2006/09/13 13:42:25 agovil ship $ */
3: --===========================FND_LOG.START=====================================
4: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
5: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
6: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
7: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
9: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 6: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;

2: /* $Header: PSAMFRHB.pls 120.7 2006/09/13 13:42:25 agovil ship $ */
3: --===========================FND_LOG.START=====================================
4: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
5: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
6: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
7: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
9: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFRHB.psa_mfar_receipts_cover_pkg.';

Line 7: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

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

Line 8: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;

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

Line 9: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;

5: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
6: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
7: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
9: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFRHB.psa_mfar_receipts_cover_pkg.';
11: --===========================FND_LOG.END=======================================
12:
13: procedure INSERT_ROW (

Line 11: --===========================FND_LOG.END=======================================

7: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
9: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFRHB.psa_mfar_receipts_cover_pkg.';
11: --===========================FND_LOG.END=======================================
12:
13: procedure INSERT_ROW (
14: X_ROWID in out NOCOPY VARCHAR2,
15: X_RECEIVABLE_APPLICATION_ID in NUMBER,

Line 56: -- ========================= FND LOG ===========================

52: and CUST_TRX_LINE_GL_DIST_ID = X_CUST_TRX_LINE_GL_DIST_ID;
53: X_LAST_UPDATE_DATE DATE;
54: X_LAST_UPDATED_BY NUMBER;
55: X_LAST_UPDATE_LOGIN NUMBER;
56: -- ========================= FND LOG ===========================
57: l_full_path VARCHAR2(100) := g_path || 'INSERT_ROW';
58: -- ========================= FND LOG ===========================
59: begin
60: X_LAST_UPDATE_DATE := SYSDATE;

Line 58: -- ========================= FND LOG ===========================

54: X_LAST_UPDATED_BY NUMBER;
55: X_LAST_UPDATE_LOGIN NUMBER;
56: -- ========================= FND LOG ===========================
57: l_full_path VARCHAR2(100) := g_path || 'INSERT_ROW';
58: -- ========================= FND LOG ===========================
59: begin
60: X_LAST_UPDATE_DATE := SYSDATE;
61: if(X_MODE = 'I') then
62: X_LAST_UPDATED_BY := 1;

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

71: X_LAST_UPDATE_LOGIN := -1;
72: end if;
73: else
74: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
75: -- ========================= FND LOG ===========================
76: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
77: -- ========================= FND LOG ===========================
78: app_exception.raise_exception;
79: end if;

Line 77: -- ========================= FND LOG ===========================

73: else
74: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
75: -- ========================= FND LOG ===========================
76: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
77: -- ========================= FND LOG ===========================
78: app_exception.raise_exception;
79: end if;
80: insert into PSA_MF_RCT_DIST_ALL (
81: ATTRIBUTE2,

Line 244: -- ========================= FND LOG ===========================

240: and CUST_TRX_LINE_GL_DIST_ID = X_CUST_TRX_LINE_GL_DIST_ID
241: and reference1 = x_reference1
242: for update of RECEIVABLE_APPLICATION_ID nowait;
243: tlinfo c1%rowtype;
244: -- ========================= FND LOG ===========================
245: l_full_path VARCHAR2(100) := g_path || 'LOCK_ROW';
246: -- ========================= FND LOG ===========================
247: begin
248: open c1;

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

242: for update of RECEIVABLE_APPLICATION_ID nowait;
243: tlinfo c1%rowtype;
244: -- ========================= FND LOG ===========================
245: l_full_path VARCHAR2(100) := g_path || 'LOCK_ROW';
246: -- ========================= FND LOG ===========================
247: begin
248: open c1;
249: fetch c1 into tlinfo;
250: if (c1%notfound) then

Line 252: -- ========================= FND LOG ===========================

248: open c1;
249: fetch c1 into tlinfo;
250: if (c1%notfound) then
251: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
252: -- ========================= FND LOG ===========================
253: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
254: -- ========================= FND LOG ===========================
255: app_exception.raise_exception;
256: close c1;

Line 254: -- ========================= FND LOG ===========================

250: if (c1%notfound) then
251: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
252: -- ========================= FND LOG ===========================
253: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
254: -- ========================= FND LOG ===========================
255: app_exception.raise_exception;
256: close c1;
257: return;
258: end if;

Line 340: -- ========================= FND LOG ===========================

336: ) then
337: null;
338: else
339: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
340: -- ========================= FND LOG ===========================
341: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
342: -- ========================= FND LOG ===========================
343: app_exception.raise_exception;
344: end if;

Line 342: -- ========================= FND LOG ===========================

338: else
339: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
340: -- ========================= FND LOG ===========================
341: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
342: -- ========================= FND LOG ===========================
343: app_exception.raise_exception;
344: end if;
345: return;
346: end LOCK_ROW;

Line 386: -- ========================= FND LOG ===========================

382: X_MODE in VARCHAR2
383: ) is
384: X_LAST_UPDATE_DATE DATE;
385: X_LAST_UPDATED_BY NUMBER;
386: -- ========================= FND LOG ===========================
387: l_full_path VARCHAR2(100) := g_path || 'UPDATE_ROW';
388: -- ========================= FND LOG ===========================
389: X_LAST_UPDATE_LOGIN NUMBER;
390: begin

Line 388: -- ========================= FND LOG ===========================

384: X_LAST_UPDATE_DATE DATE;
385: X_LAST_UPDATED_BY NUMBER;
386: -- ========================= FND LOG ===========================
387: l_full_path VARCHAR2(100) := g_path || 'UPDATE_ROW';
388: -- ========================= FND LOG ===========================
389: X_LAST_UPDATE_LOGIN NUMBER;
390: begin
391: X_LAST_UPDATE_DATE := SYSDATE;
392: if(X_MODE = 'I') then

Line 406: -- ========================= FND LOG ===========================

402: X_LAST_UPDATE_LOGIN := -1;
403: end if;
404: else
405: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
406: -- ========================= FND LOG ===========================
407: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
408: -- ========================= FND LOG ===========================
409: app_exception.raise_exception;
410: end if;

Line 408: -- ========================= FND LOG ===========================

404: else
405: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
406: -- ========================= FND LOG ===========================
407: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
408: -- ========================= FND LOG ===========================
409: app_exception.raise_exception;
410: end if;
411: update PSA_MF_RCT_DIST_ALL set
412: ATTRIBUTE2 = X_ATTRIBUTE2,