DBA Data[Home] [Help]

APPS.PSA_MFAR_TRANSACTION_COVER_PKG dependencies on FND_LOG

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

1: PACKAGE BODY PSA_MFAR_TRANSACTION_COVER_PKG AS
2: /* $Header: PSAMFTHB.pls 120.5 2006/09/13 13:54:50 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_MFAR_TRANSACTION_COVER_PKG AS
2: /* $Header: PSAMFTHB.pls 120.5 2006/09/13 13:54:50 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: PSAMFTHB.pls 120.5 2006/09/13 13:54:50 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.PSAMFTHB.PSA_MFAR_TRANSACTION_COVER_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.PSAMFTHB.PSA_MFAR_TRANSACTION_COVER_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.PSAMFTHB.PSA_MFAR_TRANSACTION_COVER_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.PSAMFTHB.PSA_MFAR_TRANSACTION_COVER_PKG.';
12: --===========================FND_LOG.END=======================================
13:
14: PROCEDURE INSERT_ROW ( X_ROWID IN OUT NOCOPY VARCHAR2,

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.PSAMFTHB.PSA_MFAR_TRANSACTION_COVER_PKG.';
12: --===========================FND_LOG.END=======================================
13:
14: PROCEDURE INSERT_ROW ( X_ROWID IN OUT NOCOPY VARCHAR2,
15: X_CUST_TRX_LINE_GL_DIST_ID IN NUMBER,
16: X_RECEIVABLES_CCID IN NUMBER,

Line 43: -- ========================= FND LOG ===========================

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

Line 45: -- ========================= FND LOG ===========================

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

Line 62: -- ========================= FND LOG ===========================

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

Line 64: -- ========================= FND LOG ===========================

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

Line 139: -- ========================= FND LOG ===========================

135: where CUST_TRX_LINE_GL_DIST_ID = X_CUST_TRX_LINE_GL_DIST_ID
136: for update of CUST_TRX_LINE_GL_DIST_ID nowait;
137:
138: tlinfo c1%rowtype;
139: -- ========================= FND LOG ===========================
140: l_full_path VARCHAR2(100) := g_path || 'LOCK_ROW';
141: -- ========================= FND LOG ===========================
142:
143: begin

Line 141: -- ========================= FND LOG ===========================

137:
138: tlinfo c1%rowtype;
139: -- ========================= FND LOG ===========================
140: l_full_path VARCHAR2(100) := g_path || 'LOCK_ROW';
141: -- ========================= FND LOG ===========================
142:
143: begin
144: open c1;
145: fetch c1 into tlinfo;

Line 148: -- ========================= FND LOG ===========================

144: open c1;
145: fetch c1 into tlinfo;
146: if (c1%notfound) then
147: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
148: -- ========================= FND LOG ===========================
149: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
150: -- ========================= FND LOG ===========================
151: app_exception.raise_exception;
152: close c1;

Line 150: -- ========================= FND LOG ===========================

146: if (c1%notfound) then
147: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
148: -- ========================= FND LOG ===========================
149: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
150: -- ========================= FND LOG ===========================
151: app_exception.raise_exception;
152: close c1;
153: return;
154: end if;

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

158: ) then
159: null;
160: else
161: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
162: -- ========================= FND LOG ===========================
163: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
164: -- ========================= FND LOG ===========================
165: app_exception.raise_exception;
166: end if;

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

160: else
161: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
162: -- ========================= FND LOG ===========================
163: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
164: -- ========================= FND LOG ===========================
165: app_exception.raise_exception;
166: end if;
167: return;
168: end LOCK_ROW;

Line 194: -- ========================= FND LOG ===========================

190:
191: X_LAST_UPDATE_DATE DATE;
192: X_LAST_UPDATED_BY NUMBER;
193: X_LAST_UPDATE_LOGIN NUMBER;
194: -- ========================= FND LOG ===========================
195: l_full_path VARCHAR2(100) := g_path || 'UPDATE_ROW';
196: -- ========================= FND LOG ===========================
197: begin
198: X_LAST_UPDATE_DATE := SYSDATE;

Line 196: -- ========================= FND LOG ===========================

192: X_LAST_UPDATED_BY NUMBER;
193: X_LAST_UPDATE_LOGIN NUMBER;
194: -- ========================= FND LOG ===========================
195: l_full_path VARCHAR2(100) := g_path || 'UPDATE_ROW';
196: -- ========================= FND LOG ===========================
197: begin
198: X_LAST_UPDATE_DATE := SYSDATE;
199: if(X_MODE = 'I') then
200: X_LAST_UPDATED_BY := 1;

Line 213: -- ========================= FND LOG ===========================

209: X_LAST_UPDATE_LOGIN := -1;
210: end if;
211: else
212: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
213: -- ========================= FND LOG ===========================
214: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
215: -- ========================= FND LOG ===========================
216: app_exception.raise_exception;
217: end if;

Line 215: -- ========================= FND LOG ===========================

211: else
212: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
213: -- ========================= FND LOG ===========================
214: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
215: -- ========================= FND LOG ===========================
216: app_exception.raise_exception;
217: end if;
218:
219: update PSA_MF_TRX_DIST_ALL set