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

Line 4: --===========================FND_LOG.START=====================================

1: package body PSA_TRX_TYPES_ALL_PKG AS
2: /* $Header: PSAMFTTB.pls 120.5 2006/09/13 13:57:31 agovil ship $ */
3:
4: --===========================FND_LOG.START=====================================
5: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
8: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 5: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1: package body PSA_TRX_TYPES_ALL_PKG AS
2: /* $Header: PSAMFTTB.pls 120.5 2006/09/13 13:57:31 agovil ship $ */
3:
4: --===========================FND_LOG.START=====================================
5: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
8: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;

Line 6: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

2: /* $Header: PSAMFTTB.pls 120.5 2006/09/13 13:57:31 agovil ship $ */
3:
4: --===========================FND_LOG.START=====================================
5: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
8: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
10: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 7: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;

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

Line 8: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

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

Line 9: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;

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

Line 10: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;

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

Line 12: --===========================FND_LOG.END=======================================

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

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

42: SELECT 'Exist'
43: FROM psa_trx_types_all
44: WHERE psa_trx_type_id = l_trx_type_id;
45: l_exist VARCHAR2(60);
46: -- ========================= FND LOG ===========================
47: l_full_path VARCHAR2(100) := g_path || 'INSERT_ROW';
48: -- ========================= FND LOG ===========================
49: begin
50: X_LAST_UPDATE_DATE := SYSDATE;

Line 48: -- ========================= FND LOG ===========================

44: WHERE psa_trx_type_id = l_trx_type_id;
45: l_exist VARCHAR2(60);
46: -- ========================= FND LOG ===========================
47: l_full_path VARCHAR2(100) := g_path || 'INSERT_ROW';
48: -- ========================= FND LOG ===========================
49: begin
50: X_LAST_UPDATE_DATE := SYSDATE;
51: if(X_MODE = 'I') then
52: X_LAST_UPDATED_BY := 1;

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

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

Line 67: -- ========================= FND LOG ===========================

63: else
64: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
65: -- ========================= FND LOG ===========================
66: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
67: -- ========================= FND LOG ===========================
68: app_exception.raise_exception;
69: end if;
70:
71: OPEN c_check_dup(X_PSA_TRX_TYPE_ID);

Line 80: -- ========================= FND LOG ===========================

76: CLOSE c_check_dup;
77: END IF;
78:
79: Fnd_Message.Set_Name('PSA', 'PSA_TRX_TYPE_DUP');
80: -- ========================= FND LOG ===========================
81: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
82: -- ========================= FND LOG ===========================
83: app_exception.raise_exception;
84: END IF;

Line 82: -- ========================= FND LOG ===========================

78:
79: Fnd_Message.Set_Name('PSA', 'PSA_TRX_TYPE_DUP');
80: -- ========================= FND LOG ===========================
81: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
82: -- ========================= FND LOG ===========================
83: app_exception.raise_exception;
84: END IF;
85:
86: IF (c_check_dup%ISOPEN) THEN

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

184: from PSA_TRX_TYPES_ALL
185: where PSA_TRX_TYPE_ID = X_PSA_TRX_TYPE_ID
186: for update of PSA_TRX_TYPE_ID nowait;
187: tlinfo c1%rowtype;
188: -- ========================= FND LOG ===========================
189: l_full_path VARCHAR2(100) := g_path || 'LOCK_ROW';
190: -- ========================= FND LOG ===========================
191:
192: begin

Line 190: -- ========================= FND LOG ===========================

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

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

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

Line 199: -- ========================= FND LOG ===========================

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

Line 258: -- ========================= FND LOG ===========================

254: ) then
255: null;
256: else
257: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
258: -- ========================= FND LOG ===========================
259: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
260: -- ========================= FND LOG ===========================
261: app_exception.raise_exception;
262: end if;

Line 260: -- ========================= FND LOG ===========================

256: else
257: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
258: -- ========================= FND LOG ===========================
259: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
260: -- ========================= FND LOG ===========================
261: app_exception.raise_exception;
262: end if;
263: return;
264: end LOCK_ROW;

Line 289: -- ========================= FND LOG ===========================

285: ) is
286: X_LAST_UPDATE_DATE DATE;
287: X_LAST_UPDATED_BY NUMBER;
288: X_LAST_UPDATE_LOGIN NUMBER;
289: -- ========================= FND LOG ===========================
290: l_full_path VARCHAR2(100) := g_path || 'UPDATE_ROW';
291: -- ========================= FND LOG ===========================
292: begin
293: X_LAST_UPDATE_DATE := SYSDATE;

Line 291: -- ========================= FND LOG ===========================

287: X_LAST_UPDATED_BY NUMBER;
288: X_LAST_UPDATE_LOGIN NUMBER;
289: -- ========================= FND LOG ===========================
290: l_full_path VARCHAR2(100) := g_path || 'UPDATE_ROW';
291: -- ========================= FND LOG ===========================
292: begin
293: X_LAST_UPDATE_DATE := SYSDATE;
294: if(X_MODE = 'I') then
295: X_LAST_UPDATED_BY := 1;

Line 308: -- ========================= FND LOG ===========================

304: X_LAST_UPDATE_LOGIN := -1;
305: end if;
306: else
307: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
308: -- ========================= FND LOG ===========================
309: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
310: -- ========================= FND LOG ===========================
311: app_exception.raise_exception;
312: end if;

Line 310: -- ========================= FND LOG ===========================

306: else
307: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
308: -- ========================= FND LOG ===========================
309: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
310: -- ========================= FND LOG ===========================
311: app_exception.raise_exception;
312: end if;
313: update PSA_TRX_TYPES_ALL set
314: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,

Line 349: -- ========================= FND LOG ===========================

345: from RA_CUSTOMER_TRX_ALL a
346: where a.cust_trx_type_id = X_PSA_TRX_TYPE_ID ;
347: num number;
348: x number;
349: -- ========================= FND LOG ===========================
350: l_full_path VARCHAR2(100) := g_path || 'DELETE_ROW';
351: -- ========================= FND LOG ===========================
352:
353: begin

Line 351: -- ========================= FND LOG ===========================

347: num number;
348: x number;
349: -- ========================= FND LOG ===========================
350: l_full_path VARCHAR2(100) := g_path || 'DELETE_ROW';
351: -- ========================= FND LOG ===========================
352:
353: begin
354: open c2;
355: fetch c2 into num;

Line 363: -- ========================= FND LOG ===========================

359:
360: else
361:
362: FND_MESSAGE.SET_NAME('PSA','PSA_TRX_TYPE_DEL');
363: -- ========================= FND LOG ===========================
364: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
365: -- ========================= FND LOG ===========================
366: app_exception.raise_exception;
367: if (sql%notfound) then

Line 365: -- ========================= FND LOG ===========================

361:
362: FND_MESSAGE.SET_NAME('PSA','PSA_TRX_TYPE_DEL');
363: -- ========================= FND LOG ===========================
364: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
365: -- ========================= FND LOG ===========================
366: app_exception.raise_exception;
367: if (sql%notfound) then
368: raise no_data_found;
369: end if;