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_MF_ACCOUNT_MAPPING_ALL_PKG dependencies on FND_LOG

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

1: package body PSA_MF_ACCOUNT_MAPPING_ALL_PKG AS
2: /* $Header: PSAMFAMB.pls 120.5 2006/09/13 12:26:08 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_MF_ACCOUNT_MAPPING_ALL_PKG AS
2: /* $Header: PSAMFAMB.pls 120.5 2006/09/13 12:26:08 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_MF_ACCOUNT_MAPPING_ALL_PKG AS
2: /* $Header: PSAMFAMB.pls 120.5 2006/09/13 12:26:08 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: PSAMFAMB.pls 120.5 2006/09/13 12:26:08 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.PSAMFAMB.PSA_MF_ACCOUNT_MAPPING_ALL_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.PSAMFAMB.PSA_MF_ACCOUNT_MAPPING_ALL_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.PSAMFAMB.PSA_MF_ACCOUNT_MAPPING_ALL_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.PSAMFAMB.PSA_MF_ACCOUNT_MAPPING_ALL_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.PSAMFAMB.PSA_MF_ACCOUNT_MAPPING_ALL_PKG.';
11: --===========================FND_LOG.END=======================================
12:
13: procedure INSERT_ROW (
14: X_ROWID in out NOCOPY VARCHAR2,
15: X_PSA_MF_ACCT_MAP_ID in NUMBER,

Line 44: -- ========================= FND LOG ===========================

40: where PSA_MF_ACCT_MAP_ID = X_PSA_MF_ACCT_MAP_ID;
41: X_LAST_UPDATE_DATE DATE;
42: X_LAST_UPDATED_BY NUMBER;
43: X_LAST_UPDATE_LOGIN NUMBER;
44: -- ========================= FND LOG ===========================
45: l_full_path VARCHAR2(100) := g_path || 'INSERT_ROW';
46: -- ========================= FND LOG ===========================
47: begin
48: X_LAST_UPDATE_DATE := SYSDATE;

Line 46: -- ========================= FND LOG ===========================

42: X_LAST_UPDATED_BY NUMBER;
43: X_LAST_UPDATE_LOGIN NUMBER;
44: -- ========================= FND LOG ===========================
45: l_full_path VARCHAR2(100) := g_path || 'INSERT_ROW';
46: -- ========================= FND LOG ===========================
47: begin
48: X_LAST_UPDATE_DATE := SYSDATE;
49: if(X_MODE = 'I') then
50: X_LAST_UPDATED_BY := 1;

Line 63: -- ========================= FND LOG ===========================

59: X_LAST_UPDATE_LOGIN := -1;
60: end if;
61: else
62: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
63: -- ========================= FND LOG ===========================
64: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
65: -- ========================= FND LOG ===========================
66: app_exception.raise_exception;
67: end if;

Line 65: -- ========================= FND LOG ===========================

61: else
62: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
63: -- ========================= FND LOG ===========================
64: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
65: -- ========================= FND LOG ===========================
66: app_exception.raise_exception;
67: end if;
68: insert into PSA_MF_ACCOUNT_MAPPING_ALL (
69: ATTRIBUTE7,

Line 186: -- ========================= FND LOG ===========================

182: from PSA_MF_ACCOUNT_MAPPING_ALL
183: where PSA_MF_ACCT_MAP_ID = X_PSA_MF_ACCT_MAP_ID
184: for update of PSA_MF_ACCT_MAP_ID nowait;
185: tlinfo c1%rowtype;
186: -- ========================= FND LOG ===========================
187: l_full_path VARCHAR2(100) := g_path || 'LOCK_ROW';
188: -- ========================= FND LOG ===========================
189:
190: begin

Line 188: -- ========================= FND LOG ===========================

184: for update of PSA_MF_ACCT_MAP_ID nowait;
185: tlinfo c1%rowtype;
186: -- ========================= FND LOG ===========================
187: l_full_path VARCHAR2(100) := g_path || 'LOCK_ROW';
188: -- ========================= FND LOG ===========================
189:
190: begin
191: open c1;
192: fetch c1 into tlinfo;

Line 195: -- ========================= FND LOG ===========================

191: open c1;
192: fetch c1 into tlinfo;
193: if (c1%notfound) then
194: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
195: -- ========================= FND LOG ===========================
196: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
197: -- ========================= FND LOG ===========================
198: app_exception.raise_exception;
199: close c1;

Line 197: -- ========================= FND LOG ===========================

193: if (c1%notfound) then
194: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
195: -- ========================= FND LOG ===========================
196: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
197: -- ========================= FND LOG ===========================
198: app_exception.raise_exception;
199: close c1;
200: return;
201: end if;

Line 263: -- ========================= FND LOG ===========================

259: ) then
260: null;
261: else
262: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
263: -- ========================= FND LOG ===========================
264: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
265: -- ========================= FND LOG ===========================
266: app_exception.raise_exception;
267: end if;

Line 265: -- ========================= FND LOG ===========================

261: else
262: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
263: -- ========================= FND LOG ===========================
264: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
265: -- ========================= FND LOG ===========================
266: app_exception.raise_exception;
267: end if;
268: return;
269: end LOCK_ROW;

Line 299: -- ========================= FND LOG ===========================

295: ) is
296: X_LAST_UPDATE_DATE DATE;
297: X_LAST_UPDATED_BY NUMBER;
298: X_LAST_UPDATE_LOGIN NUMBER;
299: -- ========================= FND LOG ===========================
300: l_full_path VARCHAR2(100) := g_path || 'UPDATE_ROW';
301: -- ========================= FND LOG ===========================
302: begin
303: X_LAST_UPDATE_DATE := SYSDATE;

Line 301: -- ========================= FND LOG ===========================

297: X_LAST_UPDATED_BY NUMBER;
298: X_LAST_UPDATE_LOGIN NUMBER;
299: -- ========================= FND LOG ===========================
300: l_full_path VARCHAR2(100) := g_path || 'UPDATE_ROW';
301: -- ========================= FND LOG ===========================
302: begin
303: X_LAST_UPDATE_DATE := SYSDATE;
304: if(X_MODE = 'I') then
305: X_LAST_UPDATED_BY := 1;

Line 318: -- ========================= FND LOG ===========================

314: X_LAST_UPDATE_LOGIN := -1;
315: end if;
316: else
317: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
318: -- ========================= FND LOG ===========================
319: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
320: -- ========================= FND LOG ===========================
321: app_exception.raise_exception;
322: end if;

Line 320: -- ========================= FND LOG ===========================

316: else
317: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
318: -- ========================= FND LOG ===========================
319: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
320: -- ========================= FND LOG ===========================
321: app_exception.raise_exception;
322: end if;
323: update PSA_MF_ACCOUNT_MAPPING_ALL set
324: ATTRIBUTE7 = X_ATTRIBUTE7,