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

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

1: package body PSA_RECEIVABLES_TRX_ALL_PKG AS
2: /* $Header: PSAMFRXB.pls 120.5 2006/09/13 13:48:30 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_RECEIVABLES_TRX_ALL_PKG AS
2: /* $Header: PSAMFRXB.pls 120.5 2006/09/13 13:48:30 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: PSAMFRXB.pls 120.5 2006/09/13 13:48:30 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.PSAMFRXB.PSA_RECEIVABLES_TRX_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.PSAMFRXB.PSA_RECEIVABLES_TRX_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.PSAMFRXB.PSA_RECEIVABLES_TRX_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.PSAMFRXB.PSA_RECEIVABLES_TRX_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.PSAMFRXB.PSA_RECEIVABLES_TRX_ALL_PKG.';
12: --===========================FND_LOG.END=======================================
13:
14: procedure INSERT_ROW (
15: X_ROWID in out NOCOPY VARCHAR2,
16: X_PSA_RECEIVABLES_TRX_ID in NUMBER,

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

36: where PSA_RECEIVABLES_TRX_ID = X_PSA_RECEIVABLES_TRX_ID;
37: X_LAST_UPDATE_DATE DATE;
38: X_LAST_UPDATED_BY NUMBER;
39: X_LAST_UPDATE_LOGIN NUMBER;
40: -- ========================= FND LOG ===========================
41: l_full_path VARCHAR2(100) := g_path || 'INSERT_ROW';
42: -- ========================= FND LOG ===========================
43: begin
44: X_LAST_UPDATE_DATE := SYSDATE;

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

38: X_LAST_UPDATED_BY NUMBER;
39: X_LAST_UPDATE_LOGIN NUMBER;
40: -- ========================= FND LOG ===========================
41: l_full_path VARCHAR2(100) := g_path || 'INSERT_ROW';
42: -- ========================= FND LOG ===========================
43: begin
44: X_LAST_UPDATE_DATE := SYSDATE;
45: if(X_MODE = 'I') then
46: X_LAST_UPDATED_BY := 1;

Line 59: -- ========================= FND LOG ===========================

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

Line 61: -- ========================= FND LOG ===========================

57: else
58: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
59: -- ========================= FND LOG ===========================
60: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
61: -- ========================= FND LOG ===========================
62: app_exception.raise_exception;
63: end if;
64: insert into PSA_RECEIVABLES_TRX_ALL (
65: PSA_RECEIVABLES_TRX_ID,

Line 162: -- ========================= FND LOG ===========================

158: from PSA_RECEIVABLES_TRX_ALL
159: where PSA_RECEIVABLES_TRX_ID = X_PSA_RECEIVABLES_TRX_ID
160: for update of PSA_RECEIVABLES_TRX_ID nowait;
161: tlinfo c1%rowtype;
162: -- ========================= FND LOG ===========================
163: l_full_path VARCHAR2(100) := g_path || 'LOCK_ROW';
164: -- ========================= FND LOG ===========================
165: begin
166: open c1;

Line 164: -- ========================= FND LOG ===========================

160: for update of PSA_RECEIVABLES_TRX_ID nowait;
161: tlinfo c1%rowtype;
162: -- ========================= FND LOG ===========================
163: l_full_path VARCHAR2(100) := g_path || 'LOCK_ROW';
164: -- ========================= FND LOG ===========================
165: begin
166: open c1;
167: fetch c1 into tlinfo;
168: if (c1%notfound) then

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

166: open c1;
167: fetch c1 into tlinfo;
168: if (c1%notfound) then
169: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
170: -- ========================= FND LOG ===========================
171: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
172: -- ========================= FND LOG ===========================
173: app_exception.raise_exception;
174: close c1;

Line 172: -- ========================= FND LOG ===========================

168: if (c1%notfound) then
169: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
170: -- ========================= FND LOG ===========================
171: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
172: -- ========================= FND LOG ===========================
173: app_exception.raise_exception;
174: close c1;
175: return;
176: end if;

Line 231: -- ========================= FND LOG ===========================

227: ) then
228: null;
229: else
230: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
231: -- ========================= FND LOG ===========================
232: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
233: -- ========================= FND LOG ===========================
234: app_exception.raise_exception;
235: end if;

Line 233: -- ========================= FND LOG ===========================

229: else
230: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
231: -- ========================= FND LOG ===========================
232: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
233: -- ========================= FND LOG ===========================
234: app_exception.raise_exception;
235: end if;
236: return;
237: end LOCK_ROW;

Line 262: -- ========================= FND LOG ===========================

258: ) is
259: X_LAST_UPDATE_DATE DATE;
260: X_LAST_UPDATED_BY NUMBER;
261: X_LAST_UPDATE_LOGIN NUMBER;
262: -- ========================= FND LOG ===========================
263: l_full_path VARCHAR2(100) := g_path || 'UPDATE_ROW';
264: -- ========================= FND LOG ===========================
265: begin
266: X_LAST_UPDATE_DATE := SYSDATE;

Line 264: -- ========================= FND LOG ===========================

260: X_LAST_UPDATED_BY NUMBER;
261: X_LAST_UPDATE_LOGIN NUMBER;
262: -- ========================= FND LOG ===========================
263: l_full_path VARCHAR2(100) := g_path || 'UPDATE_ROW';
264: -- ========================= FND LOG ===========================
265: begin
266: X_LAST_UPDATE_DATE := SYSDATE;
267: if(X_MODE = 'I') then
268: X_LAST_UPDATED_BY := 1;

Line 281: -- ========================= FND LOG ===========================

277: X_LAST_UPDATE_LOGIN := -1;
278: end if;
279: else
280: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
281: -- ========================= FND LOG ===========================
282: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
283: -- ========================= FND LOG ===========================
284: app_exception.raise_exception;
285: end if;

Line 283: -- ========================= FND LOG ===========================

279: else
280: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
281: -- ========================= FND LOG ===========================
282: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
283: -- ========================= FND LOG ===========================
284: app_exception.raise_exception;
285: end if;
286: update PSA_RECEIVABLES_TRX_ALL set
287: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,