DBA Data[Home] [Help]

APPS.ARI_DEF_HOOKS_PVT dependencies on FND_LOG

Line 45: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

41: ,message in varchar2)
42: is
43:
44: begin
45: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
46: FND_LOG.STRING(log_level, module, message);
47: END IF;
48:
49: EXCEPTION

Line 46: FND_LOG.STRING(log_level, module, message);

42: is
43:
44: begin
45: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
46: FND_LOG.STRING(log_level, module, message);
47: END IF;
48:
49: EXCEPTION
50: WHEN OTHERS THEN

Line 51: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'ERROR: ' || sqlerrm);

47: END IF;
48:
49: EXCEPTION
50: WHEN OTHERS THEN
51: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'ERROR: ' || sqlerrm);
52: end;
53:
54:
55: /*========================================================================

Line 106: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' +');

102: +-----------------------------------------------------------------------*/
103:
104: BEGIN
105:
106: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' +');
107:
108: -- first figure out if fee applies to the current installment
109: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
110: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_account_id = ' || p_cust_account_id);

Line 109: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

105:
106: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' +');
107:
108: -- first figure out if fee applies to the current installment
109: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
110: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_account_id = ' || p_cust_account_id);
111: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_site_use_id = ' || p_cust_site_use_id);
112: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_Payment_schedule_id ' || p_Payment_schedule_id);
113:

Line 110: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_account_id = ' || p_cust_account_id);

106: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' +');
107:
108: -- first figure out if fee applies to the current installment
109: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
110: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_account_id = ' || p_cust_account_id);
111: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_site_use_id = ' || p_cust_site_use_id);
112: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_Payment_schedule_id ' || p_Payment_schedule_id);
113:
114: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_session_id = ' || p_session_id);

Line 111: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_site_use_id = ' || p_cust_site_use_id);

107:
108: -- first figure out if fee applies to the current installment
109: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
110: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_account_id = ' || p_cust_account_id);
111: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_site_use_id = ' || p_cust_site_use_id);
112: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_Payment_schedule_id ' || p_Payment_schedule_id);
113:
114: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_session_id = ' || p_session_id);
115:

Line 112: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_Payment_schedule_id ' || p_Payment_schedule_id);

108: -- first figure out if fee applies to the current installment
109: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
110: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_account_id = ' || p_cust_account_id);
111: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_site_use_id = ' || p_cust_site_use_id);
112: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_Payment_schedule_id ' || p_Payment_schedule_id);
113:
114: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_session_id = ' || p_session_id);
115:
116:

Line 114: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_session_id = ' || p_session_id);

110: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_account_id = ' || p_cust_account_id);
111: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_site_use_id = ' || p_cust_site_use_id);
112: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_Payment_schedule_id ' || p_Payment_schedule_id);
113:
114: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_session_id = ' || p_session_id);
115:
116:
117: X_RETURN_STATUS := 'S';
118: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'X_RETURN_STATUS: ' || X_RETURN_STATUS);

Line 118: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'X_RETURN_STATUS: ' || X_RETURN_STATUS);

114: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_session_id = ' || p_session_id);
115:
116:
117: X_RETURN_STATUS := 'S';
118: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'X_RETURN_STATUS: ' || X_RETURN_STATUS);
119:
120: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' -');
121:
122: EXCEPTION

Line 120: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' -');

116:
117: X_RETURN_STATUS := 'S';
118: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'X_RETURN_STATUS: ' || X_RETURN_STATUS);
119:
120: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' -');
121:
122: EXCEPTION
123: WHEN OTHERS THEN
124: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - In exception');

Line 124: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - In exception');

120: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' -');
121:
122: EXCEPTION
123: WHEN OTHERS THEN
124: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - In exception');
125: END;
126:
127: /*========================================================================
128: | PUBLIC PROCEDURE VALIDATE_PAYMENT

Line 178: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' +');

174: +-----------------------------------------------------------------------*/
175:
176: BEGIN
177:
178: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' +');
179:
180: -- first figure out if fee applies to the current installment
181: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
182: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_account_id = ' || p_cust_account_id);

Line 181: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

177:
178: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' +');
179:
180: -- first figure out if fee applies to the current installment
181: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
182: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_account_id = ' || p_cust_account_id);
183: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_site_use_id = ' || p_cust_site_use_id);
184: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_Payment_schedule_id ' || p_Payment_schedule_id);
185:

Line 182: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_account_id = ' || p_cust_account_id);

178: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' +');
179:
180: -- first figure out if fee applies to the current installment
181: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
182: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_account_id = ' || p_cust_account_id);
183: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_site_use_id = ' || p_cust_site_use_id);
184: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_Payment_schedule_id ' || p_Payment_schedule_id);
185:
186: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_session_id = ' || p_session_id);

Line 183: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_site_use_id = ' || p_cust_site_use_id);

179:
180: -- first figure out if fee applies to the current installment
181: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
182: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_account_id = ' || p_cust_account_id);
183: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_site_use_id = ' || p_cust_site_use_id);
184: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_Payment_schedule_id ' || p_Payment_schedule_id);
185:
186: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_session_id = ' || p_session_id);
187:

Line 184: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_Payment_schedule_id ' || p_Payment_schedule_id);

180: -- first figure out if fee applies to the current installment
181: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
182: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_account_id = ' || p_cust_account_id);
183: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_site_use_id = ' || p_cust_site_use_id);
184: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_Payment_schedule_id ' || p_Payment_schedule_id);
185:
186: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_session_id = ' || p_session_id);
187:
188:

Line 186: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_session_id = ' || p_session_id);

182: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_account_id = ' || p_cust_account_id);
183: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_site_use_id = ' || p_cust_site_use_id);
184: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_Payment_schedule_id ' || p_Payment_schedule_id);
185:
186: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_session_id = ' || p_session_id);
187:
188:
189: X_RETURN_STATUS := 'S';
190: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'X_RETURN_STATUS: ' || X_RETURN_STATUS);

Line 190: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'X_RETURN_STATUS: ' || X_RETURN_STATUS);

186: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_session_id = ' || p_session_id);
187:
188:
189: X_RETURN_STATUS := 'S';
190: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'X_RETURN_STATUS: ' || X_RETURN_STATUS);
191:
192: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' -');
193:
194: EXCEPTION

Line 192: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' -');

188:
189: X_RETURN_STATUS := 'S';
190: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'X_RETURN_STATUS: ' || X_RETURN_STATUS);
191:
192: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' -');
193:
194: EXCEPTION
195: WHEN OTHERS THEN
196: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - In exception');

Line 196: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - In exception');

192: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' -');
193:
194: EXCEPTION
195: WHEN OTHERS THEN
196: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - In exception');
197: END;
198:
199: /*========================================================================
200: | PUBLIC PROCEDURE VALIDATE_PRINT

Line 250: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' +');

246: +-----------------------------------------------------------------------*/
247:
248: BEGIN
249:
250: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' +');
251:
252: -- first figure out if fee applies to the current installment
253: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
254: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_account_id = ' || p_cust_account_id);

Line 253: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

249:
250: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' +');
251:
252: -- first figure out if fee applies to the current installment
253: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
254: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_account_id = ' || p_cust_account_id);
255: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_site_use_id = ' || p_cust_site_use_id);
256: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_Payment_schedule_id ' || p_Payment_schedule_id);
257:

Line 254: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_account_id = ' || p_cust_account_id);

250: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' +');
251:
252: -- first figure out if fee applies to the current installment
253: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
254: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_account_id = ' || p_cust_account_id);
255: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_site_use_id = ' || p_cust_site_use_id);
256: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_Payment_schedule_id ' || p_Payment_schedule_id);
257:
258: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_session_id = ' || p_session_id);

Line 255: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_site_use_id = ' || p_cust_site_use_id);

251:
252: -- first figure out if fee applies to the current installment
253: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
254: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_account_id = ' || p_cust_account_id);
255: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_site_use_id = ' || p_cust_site_use_id);
256: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_Payment_schedule_id ' || p_Payment_schedule_id);
257:
258: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_session_id = ' || p_session_id);
259:

Line 256: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_Payment_schedule_id ' || p_Payment_schedule_id);

252: -- first figure out if fee applies to the current installment
253: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
254: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_account_id = ' || p_cust_account_id);
255: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_site_use_id = ' || p_cust_site_use_id);
256: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_Payment_schedule_id ' || p_Payment_schedule_id);
257:
258: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_session_id = ' || p_session_id);
259:
260:

Line 258: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_session_id = ' || p_session_id);

254: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_account_id = ' || p_cust_account_id);
255: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_cust_site_use_id = ' || p_cust_site_use_id);
256: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_Payment_schedule_id ' || p_Payment_schedule_id);
257:
258: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_session_id = ' || p_session_id);
259:
260:
261: X_RETURN_STATUS := 'S';
262: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'X_RETURN_STATUS: ' || X_RETURN_STATUS);

Line 262: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'X_RETURN_STATUS: ' || X_RETURN_STATUS);

258: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_session_id = ' || p_session_id);
259:
260:
261: X_RETURN_STATUS := 'S';
262: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'X_RETURN_STATUS: ' || X_RETURN_STATUS);
263:
264: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' -');
265:
266: EXCEPTION

Line 264: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' -');

260:
261: X_RETURN_STATUS := 'S';
262: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'X_RETURN_STATUS: ' || X_RETURN_STATUS);
263:
264: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' -');
265:
266: EXCEPTION
267: WHEN OTHERS THEN
268: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - In exception');

Line 268: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - In exception');

264: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' -');
265:
266: EXCEPTION
267: WHEN OTHERS THEN
268: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - In exception');
269: END;
270:
271: BEGIN
272: G_LOG_ENABLED := 'N';

Line 273: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

269: END;
270:
271: BEGIN
272: G_LOG_ENABLED := 'N';
273: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
274:
275: /* getting msg logging info */
276: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
277: if (G_LOG_ENABLED = 'N') then

Line 278: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

274:
275: /* getting msg logging info */
276: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
277: if (G_LOG_ENABLED = 'N') then
278: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
279: else
280: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
281: end if;
282:

Line 280: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);

276: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
277: if (G_LOG_ENABLED = 'N') then
278: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
279: else
280: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
281: end if;
282:
283: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
284: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'G_MSG_LEVEL: ' || G_MSG_LEVEL);

Line 283: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);

279: else
280: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
281: end if;
282:
283: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
284: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'G_MSG_LEVEL: ' || G_MSG_LEVEL);
285:
286: END;

Line 284: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'G_MSG_LEVEL: ' || G_MSG_LEVEL);

280: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
281: end if;
282:
283: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
284: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'G_MSG_LEVEL: ' || G_MSG_LEVEL);
285:
286: END;