APPS.AHL_ENIGMA_ROUTE_OP_PUB dependencies on FND_LOG

Line 6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;

2: /* $Header: AHLPEROB.pls 120.0.12010000.3 2008/12/14 09:17:20 bachandr noship $ */
3: ------------------------------------
4: -- Common constants and variables --
5: ------------------------------------
6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
7: l_log_statement NUMBER := fnd_log.level_statement;
8: l_log_procedure NUMBER := fnd_log.level_procedure;
9: l_log_error NUMBER := fnd_log.level_error;
10: l_log_unexpected NUMBER := fnd_log.level_unexpected;

Line 7: l_log_statement NUMBER := fnd_log.level_statement;

3: ------------------------------------
4: -- Common constants and variables --
5: ------------------------------------
6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
7: l_log_statement NUMBER := fnd_log.level_statement;
8: l_log_procedure NUMBER := fnd_log.level_procedure;
9: l_log_error NUMBER := fnd_log.level_error;
10: l_log_unexpected NUMBER := fnd_log.level_unexpected;
11: G_PKG_NAME VARCHAR2(30) := 'AHL_ENIGMA_ROUTE_OP_PUB';

Line 8: l_log_procedure NUMBER := fnd_log.level_procedure;

4: -- Common constants and variables --
5: ------------------------------------
6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
7: l_log_statement NUMBER := fnd_log.level_statement;
8: l_log_procedure NUMBER := fnd_log.level_procedure;
9: l_log_error NUMBER := fnd_log.level_error;
10: l_log_unexpected NUMBER := fnd_log.level_unexpected;
11: G_PKG_NAME VARCHAR2(30) := 'AHL_ENIGMA_ROUTE_OP_PUB';
12:

Line 9: l_log_error NUMBER := fnd_log.level_error;

5: ------------------------------------
6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
7: l_log_statement NUMBER := fnd_log.level_statement;
8: l_log_procedure NUMBER := fnd_log.level_procedure;
9: l_log_error NUMBER := fnd_log.level_error;
10: l_log_unexpected NUMBER := fnd_log.level_unexpected;
11: G_PKG_NAME VARCHAR2(30) := 'AHL_ENIGMA_ROUTE_OP_PUB';
12:
13: -----------------------------------

Line 10: l_log_unexpected NUMBER := fnd_log.level_unexpected;

6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
7: l_log_statement NUMBER := fnd_log.level_statement;
8: l_log_procedure NUMBER := fnd_log.level_procedure;
9: l_log_error NUMBER := fnd_log.level_error;
10: l_log_unexpected NUMBER := fnd_log.level_unexpected;
11: G_PKG_NAME VARCHAR2(30) := 'AHL_ENIGMA_ROUTE_OP_PUB';
12:
13: -----------------------------------
14: -- Process Routes Details --

Line 167: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');

163: fnd_global.APPS_INITIALIZE (1003259,62211, 867);
164:
165: -- Log API entry point
166: IF (l_log_procedure >= l_log_current_level) THEN
167: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');
168: END IF;
169:
170: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
171: THEN

Line 170: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

166: IF (l_log_procedure >= l_log_current_level) THEN
167: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');
168: END IF;
169:
170: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
171: THEN
172: fnd_log.string
173: (
174: fnd_log.level_procedure,

Line 172: fnd_log.string

168: END IF;
169:
170: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
171: THEN
172: fnd_log.string
173: (
174: fnd_log.level_procedure,
175: l_debug_module ||'.begin',
176: 'Inside Process_Route_Operations'

Line 174: fnd_log.level_procedure,

170: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
171: THEN
172: fnd_log.string
173: (
174: fnd_log.level_procedure,
175: l_debug_module ||'.begin',
176: 'Inside Process_Route_Operations'
177: );
178: END IF;

Line 182: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

178: END IF;
179:
180: -- Check if the route is found in the staging table
181: -- Then , query and get all the routes from the staging table which are in status pending.
182: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
183: THEN
184: fnd_log.string
185: (
186: fnd_log.level_statement,

Line 184: fnd_log.string

180: -- Check if the route is found in the staging table
181: -- Then , query and get all the routes from the staging table which are in status pending.
182: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
183: THEN
184: fnd_log.string
185: (
186: fnd_log.level_statement,
187: l_debug_module,
188: 'Polling for pending routes'

Line 186: fnd_log.level_statement,

182: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
183: THEN
184: fnd_log.string
185: (
186: fnd_log.level_statement,
187: l_debug_module,
188: 'Polling for pending routes'
189: );
190: END IF;

Line 197: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

193: LOOP
194: FETCH get_route_data INTO l_route_data_rec;
195: EXIT WHEN get_route_data%NOTFOUND;
196:
197: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
198: THEN
199: fnd_log.string
200: (
201: fnd_log.level_statement,

Line 199: fnd_log.string

195: EXIT WHEN get_route_data%NOTFOUND;
196:
197: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
198: THEN
199: fnd_log.string
200: (
201: fnd_log.level_statement,
202: l_debug_module,
203: 'Pending Routes foung in staging table'

Line 201: fnd_log.level_statement,

197: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
198: THEN
199: fnd_log.string
200: (
201: fnd_log.level_statement,
202: l_debug_module,
203: 'Pending Routes foung in staging table'
204: );
205: END IF;

Line 215: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling PROCESS_ROUTE_DETAILS');

211: OPEN get_oper_data (l_route_id);
212: FETCH get_oper_data INTO l_oper_data_tbl(0);
213:
214: IF (l_log_statement >= l_log_current_level) THEN
215: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling PROCESS_ROUTE_DETAILS');
216: END IF;
217:
218: -- Delete all the routes in pending status from the stagin table
219: -- as they have already been queried by the cursor

Line 229: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

225:
226: DELETE FROM AHL_RT_OPER_INTERFACE
227: WHERE PARENT_ROUTE_ID = l_route_id AND STATUS = 'PENDING';
228:
229: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
230: THEN
231: fnd_log.string
232: (
233: fnd_log.level_statement,

Line 231: fnd_log.string

227: WHERE PARENT_ROUTE_ID = l_route_id AND STATUS = 'PENDING';
228:
229: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
230: THEN
231: fnd_log.string
232: (
233: fnd_log.level_statement,
234: l_debug_module,
235: 'before calling process_route_details'

Line 233: fnd_log.level_statement,

229: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
230: THEN
231: fnd_log.string
232: (
233: fnd_log.level_statement,
234: l_debug_module,
235: 'before calling process_route_details'
236: );
237: fnd_log.string

Line 237: fnd_log.string

233: fnd_log.level_statement,
234: l_debug_module,
235: 'before calling process_route_details'
236: );
237: fnd_log.string
238: (
239: fnd_log.level_statement,
240: l_debug_module,
241: 'l_route_data_rec.route_id -> '|| l_route_data_rec.route_id

Line 239: fnd_log.level_statement,

235: 'before calling process_route_details'
236: );
237: fnd_log.string
238: (
239: fnd_log.level_statement,
240: l_debug_module,
241: 'l_route_data_rec.route_id -> '|| l_route_data_rec.route_id
242: );
243: END IF;

Line 263: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

259: p_context,
260: p_pub_date
261: );
262:
263: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
264: THEN
265: fnd_log.string
266: (
267: fnd_log.level_statement,

Line 265: fnd_log.string

261: );
262:
263: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
264: THEN
265: fnd_log.string
266: (
267: fnd_log.level_statement,
268: l_debug_module,
269: 'after calling process_route_details'

Line 267: fnd_log.level_statement,

263: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
264: THEN
265: fnd_log.string
266: (
267: fnd_log.level_statement,
268: l_debug_module,
269: 'after calling process_route_details'
270: );
271: END IF;

Line 276: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

272: CLOSE get_oper_data;
273: END LOOP;
274: CLOSE get_route_data;
275:
276: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
277: THEN
278: fnd_log.string
279: (
280: fnd_log.level_statement,

Line 278: fnd_log.string

274: CLOSE get_route_data;
275:
276: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
277: THEN
278: fnd_log.string
279: (
280: fnd_log.level_statement,
281: l_debug_module,
282: 'Dumping all the paramters...'

Line 280: fnd_log.level_statement,

276: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
277: THEN
278: fnd_log.string
279: (
280: fnd_log.level_statement,
281: l_debug_module,
282: 'Dumping all the paramters...'
283: );
284: fnd_log.string

Line 284: fnd_log.string

280: fnd_log.level_statement,
281: l_debug_module,
282: 'Dumping all the paramters...'
283: );
284: fnd_log.string
285: (
286: fnd_log.level_statement,
287: l_debug_module,
288: 'p_api_version -> '||p_api_version

Line 286: fnd_log.level_statement,

282: 'Dumping all the paramters...'
283: );
284: fnd_log.string
285: (
286: fnd_log.level_statement,
287: l_debug_module,
288: 'p_api_version -> '||p_api_version
289: );
290: fnd_log.string

Line 290: fnd_log.string

286: fnd_log.level_statement,
287: l_debug_module,
288: 'p_api_version -> '||p_api_version
289: );
290: fnd_log.string
291: (
292: fnd_log.level_statement,
293: l_debug_module,
294: 'p_init_msg_list -> '||p_init_msg_list

Line 292: fnd_log.level_statement,

288: 'p_api_version -> '||p_api_version
289: );
290: fnd_log.string
291: (
292: fnd_log.level_statement,
293: l_debug_module,
294: 'p_init_msg_list -> '||p_init_msg_list
295: );
296: fnd_log.string

Line 296: fnd_log.string

292: fnd_log.level_statement,
293: l_debug_module,
294: 'p_init_msg_list -> '||p_init_msg_list
295: );
296: fnd_log.string
297: (
298: fnd_log.level_statement,
299: l_debug_module,
300: 'p_commit -> '||p_commit

Line 298: fnd_log.level_statement,

294: 'p_init_msg_list -> '||p_init_msg_list
295: );
296: fnd_log.string
297: (
298: fnd_log.level_statement,
299: l_debug_module,
300: 'p_commit -> '||p_commit
301: );
302: fnd_log.string

Line 302: fnd_log.string

298: fnd_log.level_statement,
299: l_debug_module,
300: 'p_commit -> '||p_commit
301: );
302: fnd_log.string
303: (
304: fnd_log.level_statement,
305: l_debug_module,
306: 'p_validation_level -> '||p_validation_level

Line 304: fnd_log.level_statement,

300: 'p_commit -> '||p_commit
301: );
302: fnd_log.string
303: (
304: fnd_log.level_statement,
305: l_debug_module,
306: 'p_validation_level -> '||p_validation_level
307: );
308: fnd_log.string

Line 308: fnd_log.string

304: fnd_log.level_statement,
305: l_debug_module,
306: 'p_validation_level -> '||p_validation_level
307: );
308: fnd_log.string
309: (
310: fnd_log.level_statement,
311: l_debug_module,
312: 'p_module_type -> '||p_module_type

Line 310: fnd_log.level_statement,

306: 'p_validation_level -> '||p_validation_level
307: );
308: fnd_log.string
309: (
310: fnd_log.level_statement,
311: l_debug_module,
312: 'p_module_type -> '||p_module_type
313: );
314: fnd_log.string

Line 314: fnd_log.string

310: fnd_log.level_statement,
311: l_debug_module,
312: 'p_module_type -> '||p_module_type
313: );
314: fnd_log.string
315: (
316: fnd_log.level_statement,
317: l_debug_module,
318: 'p_context -> '||p_context

Line 316: fnd_log.level_statement,

312: 'p_module_type -> '||p_module_type
313: );
314: fnd_log.string
315: (
316: fnd_log.level_statement,
317: l_debug_module,
318: 'p_context -> '||p_context
319: );
320: fnd_log.string

Line 320: fnd_log.string

316: fnd_log.level_statement,
317: l_debug_module,
318: 'p_context -> '||p_context
319: );
320: fnd_log.string
321: (
322: fnd_log.level_statement,
323: l_debug_module,
324: 'p_pub_date -> '||p_pub_date

Line 322: fnd_log.level_statement,

318: 'p_context -> '||p_context
319: );
320: fnd_log.string
321: (
322: fnd_log.level_statement,
323: l_debug_module,
324: 'p_pub_date -> '||p_pub_date
325: );
326: END IF;

Line 475: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');

471: END IF;
472:
473: -- Log API entry point
474: IF (l_log_procedure >= l_log_current_level) THEN
475: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');
476: END IF;
477:
478: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
479:

Line 478: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

474: IF (l_log_procedure >= l_log_current_level) THEN
475: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');
476: END IF;
477:
478: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
479:
480: fnd_log.string
481: (
482: fnd_log.level_procedure,

Line 480: fnd_log.string

476: END IF;
477:
478: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
479:
480: fnd_log.string
481: (
482: fnd_log.level_procedure,
483: l_debug_module ||'.begin',
484: 'Inside process_route_details'

Line 482: fnd_log.level_procedure,

478: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
479:
480: fnd_log.string
481: (
482: fnd_log.level_procedure,
483: l_debug_module ||'.begin',
484: 'Inside process_route_details'
485: );
486: END IF;

Line 488: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

484: 'Inside process_route_details'
485: );
486: END IF;
487:
488: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
489: THEN
490: fnd_log.string
491: (
492: fnd_log.level_statement,

Line 490: fnd_log.string

486: END IF;
487:
488: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
489: THEN
490: fnd_log.string
491: (
492: fnd_log.level_statement,
493: l_debug_module,
494: 'Calling from BPEL service Parameters p_enigma_route_rec.route_id -> '||p_enigma_route_rec.route_id

Line 492: fnd_log.level_statement,

488: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
489: THEN
490: fnd_log.string
491: (
492: fnd_log.level_statement,
493: l_debug_module,
494: 'Calling from BPEL service Parameters p_enigma_route_rec.route_id -> '||p_enigma_route_rec.route_id
495: );
496: fnd_log.string

Line 496: fnd_log.string

492: fnd_log.level_statement,
493: l_debug_module,
494: 'Calling from BPEL service Parameters p_enigma_route_rec.route_id -> '||p_enigma_route_rec.route_id
495: );
496: fnd_log.string
497: (
498: fnd_log.level_statement,
499: l_debug_module,
500: 'Calling from BPEL service Parameters p_enigma_route_rec.change_flag -> '||p_enigma_route_rec.change_flag

Line 498: fnd_log.level_statement,

494: 'Calling from BPEL service Parameters p_enigma_route_rec.route_id -> '||p_enigma_route_rec.route_id
495: );
496: fnd_log.string
497: (
498: fnd_log.level_statement,
499: l_debug_module,
500: 'Calling from BPEL service Parameters p_enigma_route_rec.change_flag -> '||p_enigma_route_rec.change_flag
501: );
502: fnd_log.string

Line 502: fnd_log.string

498: fnd_log.level_statement,
499: l_debug_module,
500: 'Calling from BPEL service Parameters p_enigma_route_rec.change_flag -> '||p_enigma_route_rec.change_flag
501: );
502: fnd_log.string
503: (
504: fnd_log.level_statement,
505: l_debug_module,
506: 'Calling from BPEL service Parameters p_enigma_route_rec.ATA_CODE-> '||p_enigma_route_rec.ATA_CODE

Line 504: fnd_log.level_statement,

500: 'Calling from BPEL service Parameters p_enigma_route_rec.change_flag -> '||p_enigma_route_rec.change_flag
501: );
502: fnd_log.string
503: (
504: fnd_log.level_statement,
505: l_debug_module,
506: 'Calling from BPEL service Parameters p_enigma_route_rec.ATA_CODE-> '||p_enigma_route_rec.ATA_CODE
507: );
508: fnd_log.string

Line 508: fnd_log.string

504: fnd_log.level_statement,
505: l_debug_module,
506: 'Calling from BPEL service Parameters p_enigma_route_rec.ATA_CODE-> '||p_enigma_route_rec.ATA_CODE
507: );
508: fnd_log.string
509: (
510: fnd_log.level_statement,
511: l_debug_module,
512: 'Calling from BPEL service Parameters p_enigma_route_rec.DESCRIPTION-> '||p_enigma_route_rec.DESCRIPTION

Line 510: fnd_log.level_statement,

506: 'Calling from BPEL service Parameters p_enigma_route_rec.ATA_CODE-> '||p_enigma_route_rec.ATA_CODE
507: );
508: fnd_log.string
509: (
510: fnd_log.level_statement,
511: l_debug_module,
512: 'Calling from BPEL service Parameters p_enigma_route_rec.DESCRIPTION-> '||p_enigma_route_rec.DESCRIPTION
513: );
514: fnd_log.string

Line 514: fnd_log.string

510: fnd_log.level_statement,
511: l_debug_module,
512: 'Calling from BPEL service Parameters p_enigma_route_rec.DESCRIPTION-> '||p_enigma_route_rec.DESCRIPTION
513: );
514: fnd_log.string
515: (
516: fnd_log.level_statement,
517: l_debug_module,
518: 'Calling from BPEL service Parameters p_enigma_route_rec.REVISION_DATE-> '||p_enigma_route_rec.REVISION_DATE

Line 516: fnd_log.level_statement,

512: 'Calling from BPEL service Parameters p_enigma_route_rec.DESCRIPTION-> '||p_enigma_route_rec.DESCRIPTION
513: );
514: fnd_log.string
515: (
516: fnd_log.level_statement,
517: l_debug_module,
518: 'Calling from BPEL service Parameters p_enigma_route_rec.REVISION_DATE-> '||p_enigma_route_rec.REVISION_DATE
519: );
520: fnd_log.string

Line 520: fnd_log.string

516: fnd_log.level_statement,
517: l_debug_module,
518: 'Calling from BPEL service Parameters p_enigma_route_rec.REVISION_DATE-> '||p_enigma_route_rec.REVISION_DATE
519: );
520: fnd_log.string
521: (
522: fnd_log.level_statement,
523: l_debug_module,
524: 'Calling from BPEL service Parameters p_enigma_route_rec.PDF-> '||p_enigma_route_rec.PDF

Line 522: fnd_log.level_statement,

518: 'Calling from BPEL service Parameters p_enigma_route_rec.REVISION_DATE-> '||p_enigma_route_rec.REVISION_DATE
519: );
520: fnd_log.string
521: (
522: fnd_log.level_statement,
523: l_debug_module,
524: 'Calling from BPEL service Parameters p_enigma_route_rec.PDF-> '||p_enigma_route_rec.PDF
525: );
526: END IF;

Line 544: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

540: -- When all clear, process the route rec by checking the change_flag (DML Operation).
541: -- Check if the flag id delete and if so delete the route from the CMRO system .
542: IF (p_enigma_route_rec.change_flag = 'D') THEN
543:
544: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
545: THEN
546: fnd_log.string
547: (
548: fnd_log.level_statement,

Line 546: fnd_log.string

542: IF (p_enigma_route_rec.change_flag = 'D') THEN
543:
544: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
545: THEN
546: fnd_log.string
547: (
548: fnd_log.level_statement,
549: l_debug_module,
550: 'Inside Delete'

Line 548: fnd_log.level_statement,

544: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
545: THEN
546: fnd_log.string
547: (
548: fnd_log.level_statement,
549: l_debug_module,
550: 'Inside Delete'
551: );
552: END IF;

Line 563: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

559: l_get_latest_route_rev.revision_status;
560:
561: IF get_latest_route_rev%FOUND THEN
562:
563: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
564: THEN
565: fnd_log.string
566: (
567: fnd_log.level_statement,

Line 565: fnd_log.string

561: IF get_latest_route_rev%FOUND THEN
562:
563: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
564: THEN
565: fnd_log.string
566: (
567: fnd_log.level_statement,
568: l_debug_module,
569: 'Latest Revision of route found'

Line 567: fnd_log.level_statement,

563: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
564: THEN
565: fnd_log.string
566: (
567: fnd_log.level_statement,
568: l_debug_module,
569: 'Latest Revision of route found'
570: );
571: END IF;

Line 577: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

573: -- IF the route is in Approval Pending status , then insert the Enigma Record into the
574: -- staging table with status as pending.
575: IF ( upper(l_get_latest_route_rev.revision_status) = 'APPROVAL_PENDING' ) THEN
576:
577: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
578: THEN
579: fnd_log.string
580: (
581: fnd_log.level_statement,

Line 579: fnd_log.string

575: IF ( upper(l_get_latest_route_rev.revision_status) = 'APPROVAL_PENDING' ) THEN
576:
577: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
578: THEN
579: fnd_log.string
580: (
581: fnd_log.level_statement,
582: l_debug_module,
583: 'Route is in Approval Pending'

Line 581: fnd_log.level_statement,

577: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
578: THEN
579: fnd_log.string
580: (
581: fnd_log.level_statement,
582: l_debug_module,
583: 'Route is in Approval Pending'
584: );
585: fnd_log.string

Line 585: fnd_log.string

581: fnd_log.level_statement,
582: l_debug_module,
583: 'Route is in Approval Pending'
584: );
585: fnd_log.string
586: (
587: fnd_log.level_statement,
588: l_debug_module,
589: 'Before Inserting into the staging table'

Line 587: fnd_log.level_statement,

583: 'Route is in Approval Pending'
584: );
585: fnd_log.string
586: (
587: fnd_log.level_statement,
588: l_debug_module,
589: 'Before Inserting into the staging table'
590: );
591: END IF;

Line 622: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

618: 'Route is in approval pending status',
619: p_enigma_route_rec.enigma_id
620: );
621:
622: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
623: THEN
624: fnd_log.string
625: (
626: fnd_log.level_statement,

Line 624: fnd_log.string

620: );
621:
622: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
623: THEN
624: fnd_log.string
625: (
626: fnd_log.level_statement,
627: l_debug_module,
628: 'After Inserting into the staging table'

Line 626: fnd_log.level_statement,

622: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
623: THEN
624: fnd_log.string
625: (
626: fnd_log.level_statement,
627: l_debug_module,
628: 'After Inserting into the staging table'
629: );
630: END IF;

Line 633: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

629: );
630: END IF;
631:
632: ELSE
633: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
634: THEN
635: fnd_log.string
636: (
637: fnd_log.level_statement,

Line 635: fnd_log.string

631:
632: ELSE
633: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
634: THEN
635: fnd_log.string
636: (
637: fnd_log.level_statement,
638: l_debug_module,
639: 'Before calling delete_routes'

Line 637: fnd_log.level_statement,

633: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
634: THEN
635: fnd_log.string
636: (
637: fnd_log.level_statement,
638: l_debug_module,
639: 'Before calling delete_routes'
640: );
641: fnd_log.string

Line 641: fnd_log.string

637: fnd_log.level_statement,
638: l_debug_module,
639: 'Before calling delete_routes'
640: );
641: fnd_log.string
642: (
643: fnd_log.level_statement,
644: l_debug_module,
645: 'l_get_latest_route_rev.route_id -> ' || l_get_latest_route_rev.route_id

Line 643: fnd_log.level_statement,

639: 'Before calling delete_routes'
640: );
641: fnd_log.string
642: (
643: fnd_log.level_statement,
644: l_debug_module,
645: 'l_get_latest_route_rev.route_id -> ' || l_get_latest_route_rev.route_id
646: );
647: fnd_log.string

Line 647: fnd_log.string

643: fnd_log.level_statement,
644: l_debug_module,
645: 'l_get_latest_route_rev.route_id -> ' || l_get_latest_route_rev.route_id
646: );
647: fnd_log.string
648: (
649: fnd_log.level_statement,
650: l_debug_module,
651: 'l_get_latest_route_rev.object_version_number -> ' || l_get_latest_route_rev.object_version_number

Line 649: fnd_log.level_statement,

645: 'l_get_latest_route_rev.route_id -> ' || l_get_latest_route_rev.route_id
646: );
647: fnd_log.string
648: (
649: fnd_log.level_statement,
650: l_debug_module,
651: 'l_get_latest_route_rev.object_version_number -> ' || l_get_latest_route_rev.object_version_number
652: );
653: END IF;

Line 671: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

667: l_get_latest_route_rev.route_id,
668: l_get_latest_route_rev.object_version_number
669: );
670:
671: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
672: THEN
673: fnd_log.string
674: (
675: fnd_log.level_statement,

Line 673: fnd_log.string

669: );
670:
671: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
672: THEN
673: fnd_log.string
674: (
675: fnd_log.level_statement,
676: l_debug_module,
677: 'After calling delete_routes'

Line 675: fnd_log.level_statement,

671: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
672: THEN
673: fnd_log.string
674: (
675: fnd_log.level_statement,
676: l_debug_module,
677: 'After calling delete_routes'
678: );
679: fnd_log.string

Line 679: fnd_log.string

675: fnd_log.level_statement,
676: l_debug_module,
677: 'After calling delete_routes'
678: );
679: fnd_log.string
680: (
681: fnd_log.level_statement,
682: l_debug_module,
683: 'x_return_status -> ' || x_return_status

Line 681: fnd_log.level_statement,

677: 'After calling delete_routes'
678: );
679: fnd_log.string
680: (
681: fnd_log.level_statement,
682: l_debug_module,
683: 'x_return_status -> ' || x_return_status
684: );
685: END IF;

Line 688: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_ROUTE_PVT.create_route_revision');

684: );
685: END IF;
686:
687: IF (l_log_statement >= l_log_current_level) THEN
688: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_ROUTE_PVT.create_route_revision');
689: END IF;
690:
691: -- Check the return status , and if the status is not success , then raise an error
692: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN

Line 694: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.delete_route Error');

690:
691: -- Check the return status , and if the status is not success , then raise an error
692: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
693: IF (l_log_statement >= l_log_current_level) THEN
694: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.delete_route Error');
695: END IF;
696: RAISE FND_API.G_EXC_ERROR;
697: END IF;
698:

Line 700: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.delete_route -> Deleted');

696: RAISE FND_API.G_EXC_ERROR;
697: END IF;
698:
699: IF (l_log_statement >= l_log_current_level) THEN
700: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.delete_route -> Deleted');
701: END IF;
702:
703: END IF;
704: ELSE

Line 716: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

712: END IF; -- change Flag
713:
714: IF (p_enigma_route_rec.change_flag = 'U') THEN
715:
716: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
717: THEN
718: fnd_log.string
719: (
720: fnd_log.level_statement,

Line 718: fnd_log.string

714: IF (p_enigma_route_rec.change_flag = 'U') THEN
715:
716: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
717: THEN
718: fnd_log.string
719: (
720: fnd_log.level_statement,
721: l_debug_module,
722: 'Inside update'

Line 720: fnd_log.level_statement,

716: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
717: THEN
718: fnd_log.string
719: (
720: fnd_log.level_statement,
721: l_debug_module,
722: 'Inside update'
723: );
724: END IF;

Line 734: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

730: l_get_latest_route_rev.object_version_number,
731: l_get_latest_route_rev.revision_status;
732:
733: IF get_latest_route_rev%FOUND THEN
734: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
735: THEN
736: fnd_log.string
737: (
738: fnd_log.level_statement,

Line 736: fnd_log.string

732:
733: IF get_latest_route_rev%FOUND THEN
734: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
735: THEN
736: fnd_log.string
737: (
738: fnd_log.level_statement,
739: l_debug_module,
740: 'latest revision of route Found'

Line 738: fnd_log.level_statement,

734: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
735: THEN
736: fnd_log.string
737: (
738: fnd_log.level_statement,
739: l_debug_module,
740: 'latest revision of route Found'
741: );
742: fnd_log.string

Line 742: fnd_log.string

738: fnd_log.level_statement,
739: l_debug_module,
740: 'latest revision of route Found'
741: );
742: fnd_log.string
743: (
744: fnd_log.level_statement,
745: l_debug_module,
746: 'l_get_latest_route_rev.route_id -> ' || l_get_latest_route_rev.route_id

Line 744: fnd_log.level_statement,

740: 'latest revision of route Found'
741: );
742: fnd_log.string
743: (
744: fnd_log.level_statement,
745: l_debug_module,
746: 'l_get_latest_route_rev.route_id -> ' || l_get_latest_route_rev.route_id
747: );
748: fnd_log.string

Line 748: fnd_log.string

744: fnd_log.level_statement,
745: l_debug_module,
746: 'l_get_latest_route_rev.route_id -> ' || l_get_latest_route_rev.route_id
747: );
748: fnd_log.string
749: (
750: fnd_log.level_statement,
751: l_debug_module,
752: 'l_get_latest_route_rev.revision_status_code-> ' || l_get_latest_route_rev.revision_status

Line 750: fnd_log.level_statement,

746: 'l_get_latest_route_rev.route_id -> ' || l_get_latest_route_rev.route_id
747: );
748: fnd_log.string
749: (
750: fnd_log.level_statement,
751: l_debug_module,
752: 'l_get_latest_route_rev.revision_status_code-> ' || l_get_latest_route_rev.revision_status
753: );
754: END IF;

Line 760: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

756: -- IF the route is in Approval Pending status , then inser the Enigma Record into the
757: -- staging table with status as pending.
758: IF ( upper(l_get_latest_route_rev.revision_status) = 'APPROVAL_PENDING' ) THEN
759:
760: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
761: THEN
762: fnd_log.string
763: (
764: fnd_log.level_statement,

Line 762: fnd_log.string

758: IF ( upper(l_get_latest_route_rev.revision_status) = 'APPROVAL_PENDING' ) THEN
759:
760: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
761: THEN
762: fnd_log.string
763: (
764: fnd_log.level_statement,
765: l_debug_module,
766: 'Route is in Approval pending'

Line 764: fnd_log.level_statement,

760: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
761: THEN
762: fnd_log.string
763: (
764: fnd_log.level_statement,
765: l_debug_module,
766: 'Route is in Approval pending'
767: );
768: END IF;

Line 803: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

799: -- If the route has any assocaited operations, add them also to the stating table
800: -- marking the status as pending.
801: IF ( p_enigma_op_tbl.COUNT > 0) THEN
802:
803: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
804: THEN
805: fnd_log.string
806: (
807: fnd_log.level_statement,

Line 805: fnd_log.string

801: IF ( p_enigma_op_tbl.COUNT > 0) THEN
802:
803: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
804: THEN
805: fnd_log.string
806: (
807: fnd_log.level_statement,
808: l_debug_module,
809: 'There are operations attached'

Line 807: fnd_log.level_statement,

803: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
804: THEN
805: fnd_log.string
806: (
807: fnd_log.level_statement,
808: l_debug_module,
809: 'There are operations attached'
810: );
811: END IF;

Line 815: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

811: END IF;
812:
813: FOR i IN p_enigma_op_tbl.FIRST..p_enigma_op_tbl.LAST
814: LOOP
815: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
816: THEN
817: fnd_log.string
818: (
819: fnd_log.level_statement,

Line 817: fnd_log.string

813: FOR i IN p_enigma_op_tbl.FIRST..p_enigma_op_tbl.LAST
814: LOOP
815: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
816: THEN
817: fnd_log.string
818: (
819: fnd_log.level_statement,
820: l_debug_module,
821: 'Inserting the operations into the staging table'

Line 819: fnd_log.level_statement,

815: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
816: THEN
817: fnd_log.string
818: (
819: fnd_log.level_statement,
820: l_debug_module,
821: 'Inserting the operations into the staging table'
822: );
823: END IF;

Line 856: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

852: END IF;
853:
854: ELSIF (upper(l_get_latest_route_rev.revision_status) = 'COMPLETE') THEN
855:
856: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
857: THEN
858: fnd_log.string
859: (
860: fnd_log.level_statement,

Line 858: fnd_log.string

854: ELSIF (upper(l_get_latest_route_rev.revision_status) = 'COMPLETE') THEN
855:
856: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
857: THEN
858: fnd_log.string
859: (
860: fnd_log.level_statement,
861: l_debug_module,
862: 'Route is in complete'

Line 860: fnd_log.level_statement,

856: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
857: THEN
858: fnd_log.string
859: (
860: fnd_log.level_statement,
861: l_debug_module,
862: 'Route is in complete'
863: );
864: fnd_log.string

Line 864: fnd_log.string

860: fnd_log.level_statement,
861: l_debug_module,
862: 'Route is in complete'
863: );
864: fnd_log.string
865: (
866: fnd_log.level_statement,
867: l_debug_module,
868: 'Before calling create_route_revision'

Line 866: fnd_log.level_statement,

862: 'Route is in complete'
863: );
864: fnd_log.string
865: (
866: fnd_log.level_statement,
867: l_debug_module,
868: 'Before calling create_route_revision'
869: );
870: fnd_log.string

Line 870: fnd_log.string

866: fnd_log.level_statement,
867: l_debug_module,
868: 'Before calling create_route_revision'
869: );
870: fnd_log.string
871: (
872: fnd_log.level_statement,
873: l_debug_module,
874: 'l_get_latest_route_rev.route_id -> ' || l_get_latest_route_rev.route_id

Line 872: fnd_log.level_statement,

868: 'Before calling create_route_revision'
869: );
870: fnd_log.string
871: (
872: fnd_log.level_statement,
873: l_debug_module,
874: 'l_get_latest_route_rev.route_id -> ' || l_get_latest_route_rev.route_id
875: );
876: fnd_log.string

Line 876: fnd_log.string

872: fnd_log.level_statement,
873: l_debug_module,
874: 'l_get_latest_route_rev.route_id -> ' || l_get_latest_route_rev.route_id
875: );
876: fnd_log.string
877: (
878: fnd_log.level_statement,
879: l_debug_module,
880: 'l_get_latest_route_rev.object_version_number -> ' || l_get_latest_route_rev.object_version_number

Line 878: fnd_log.level_statement,

874: 'l_get_latest_route_rev.route_id -> ' || l_get_latest_route_rev.route_id
875: );
876: fnd_log.string
877: (
878: fnd_log.level_statement,
879: l_debug_module,
880: 'l_get_latest_route_rev.object_version_number -> ' || l_get_latest_route_rev.object_version_number
881: );
882: END IF;

Line 901: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

897: l_get_latest_route_rev.object_version_number,
898: x_route_id
899: );
900:
901: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
902: THEN
903:
904: fnd_log.string
905: (

Line 904: fnd_log.string

900:
901: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
902: THEN
903:
904: fnd_log.string
905: (
906: fnd_log.level_statement,
907: l_debug_module,
908: 'After calling create_route_revision'

Line 906: fnd_log.level_statement,

902: THEN
903:
904: fnd_log.string
905: (
906: fnd_log.level_statement,
907: l_debug_module,
908: 'After calling create_route_revision'
909: );
910: fnd_log.string

Line 910: fnd_log.string

906: fnd_log.level_statement,
907: l_debug_module,
908: 'After calling create_route_revision'
909: );
910: fnd_log.string
911: (
912: fnd_log.level_statement,
913: l_debug_module,
914: 'x_route_id -> ' || x_route_id

Line 912: fnd_log.level_statement,

908: 'After calling create_route_revision'
909: );
910: fnd_log.string
911: (
912: fnd_log.level_statement,
913: l_debug_module,
914: 'x_route_id -> ' || x_route_id
915: );
916: END IF;

Line 919: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_ROUTE_PVT.create_route_revision');

915: );
916: END IF;
917:
918: IF (l_log_statement >= l_log_current_level) THEN
919: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_ROUTE_PVT.create_route_revision');
920: END IF;
921:
922: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
923: IF (l_log_statement >= l_log_current_level) THEN

Line 924: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.create_route_revision Error');

920: END IF;
921:
922: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
923: IF (l_log_statement >= l_log_current_level) THEN
924: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.create_route_revision Error');
925: END IF;
926: RAISE FND_API.G_EXC_ERROR;
927: END IF;
928:

Line 930: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.create_route_revision -> revision Created');

926: RAISE FND_API.G_EXC_ERROR;
927: END IF;
928:
929: IF (l_log_statement >= l_log_current_level) THEN
930: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.create_route_revision -> revision Created');
931: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.create_route_revision -> x_route_id = ' || x_route_id);
932: END IF;
933:
934: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 931: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.create_route_revision -> x_route_id = ' || x_route_id);

927: END IF;
928:
929: IF (l_log_statement >= l_log_current_level) THEN
930: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.create_route_revision -> revision Created');
931: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.create_route_revision -> x_route_id = ' || x_route_id);
932: END IF;
933:
934: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
935: THEN

Line 934: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

930: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.create_route_revision -> revision Created');
931: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.create_route_revision -> x_route_id = ' || x_route_id);
932: END IF;
933:
934: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
935: THEN
936:
937: fnd_log.string
938: (

Line 937: fnd_log.string

933:
934: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
935: THEN
936:
937: fnd_log.string
938: (
939: fnd_log.level_statement,
940: l_debug_module,
941: 'Populate the input record for updation'

Line 939: fnd_log.level_statement,

935: THEN
936:
937: fnd_log.string
938: (
939: fnd_log.level_statement,
940: l_debug_module,
941: 'Populate the input record for updation'
942: );
943: END IF;

Line 962: fnd_log.string(fnd_log.level_statement,l_debug_module,'After UPLOAD_REVISION_REPORT Call ');

958: );
959: END IF;
960:
961: IF (l_log_statement >= l_log_current_level) THEN
962: fnd_log.string(fnd_log.level_statement,l_debug_module,'After UPLOAD_REVISION_REPORT Call ');
963: END IF;
964:
965: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
966: IF (l_log_statement >= l_log_current_level) THEN

Line 967: fnd_log.string(fnd_log.level_statement,l_debug_module,'UPLOAD_REVISION_REPORT Error');

963: END IF;
964:
965: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
966: IF (l_log_statement >= l_log_current_level) THEN
967: fnd_log.string(fnd_log.level_statement,l_debug_module,'UPLOAD_REVISION_REPORT Error');
968: END IF;
969: RAISE FND_API.G_EXC_ERROR;
970: END IF;
971:

Line 973: fnd_log.string(fnd_log.level_statement,l_debug_module,'UPLOAD_REVISION_REPORT-> File upload done');

969: RAISE FND_API.G_EXC_ERROR;
970: END IF;
971:
972: IF (l_log_statement >= l_log_current_level) THEN
973: fnd_log.string(fnd_log.level_statement,l_debug_module,'UPLOAD_REVISION_REPORT-> File upload done');
974: fnd_log.string(fnd_log.level_statement,l_debug_module,'File Id -> = ' || x_file_id);
975: END IF;
976:
977: -- If the return status is success, populate the input rec for process_route for updation

Line 974: fnd_log.string(fnd_log.level_statement,l_debug_module,'File Id -> = ' || x_file_id);

970: END IF;
971:
972: IF (l_log_statement >= l_log_current_level) THEN
973: fnd_log.string(fnd_log.level_statement,l_debug_module,'UPLOAD_REVISION_REPORT-> File upload done');
974: fnd_log.string(fnd_log.level_statement,l_debug_module,'File Id -> = ' || x_file_id);
975: END IF;
976:
977: -- If the return status is success, populate the input rec for process_route for updation
978: IF ( x_file_id <> FND_API.G_MISS_NUM AND x_file_id IS NOT NULL) THEN

Line 980: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

976:
977: -- If the return status is success, populate the input rec for process_route for updation
978: IF ( x_file_id <> FND_API.G_MISS_NUM AND x_file_id IS NOT NULL) THEN
979:
980: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
981: THEN
982:
983: fnd_log.string
984: (

Line 983: fnd_log.string

979:
980: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
981: THEN
982:
983: fnd_log.string
984: (
985: fnd_log.level_statement,
986: l_debug_module,
987: 'File id ->' || x_file_id

Line 985: fnd_log.level_statement,

981: THEN
982:
983: fnd_log.string
984: (
985: fnd_log.level_statement,
986: l_debug_module,
987: 'File id ->' || x_file_id
988: );
989: END IF;

Line 1044: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1040: END IF;
1041:
1042: p_process_route_input_rec.dml_operation := 'U';
1043:
1044: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1045: THEN
1046:
1047: fnd_log.string
1048: (

Line 1047: fnd_log.string

1043:
1044: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1045: THEN
1046:
1047: fnd_log.string
1048: (
1049: fnd_log.level_statement,
1050: l_debug_module,
1051: 'Before calling process_route in update mode'

Line 1049: fnd_log.level_statement,

1045: THEN
1046:
1047: fnd_log.string
1048: (
1049: fnd_log.level_statement,
1050: l_debug_module,
1051: 'Before calling process_route in update mode'
1052: );
1053: END IF;

Line 1070: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1066: x_msg_data,
1067: p_process_route_input_rec
1068: );
1069:
1070: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1071: THEN
1072:
1073: fnd_log.string
1074: (

Line 1073: fnd_log.string

1069:
1070: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1071: THEN
1072:
1073: fnd_log.string
1074: (
1075: fnd_log.level_statement,
1076: l_debug_module,
1077: 'After calling process_route in update mode'

Line 1075: fnd_log.level_statement,

1071: THEN
1072:
1073: fnd_log.string
1074: (
1075: fnd_log.level_statement,
1076: l_debug_module,
1077: 'After calling process_route in update mode'
1078: );
1079: fnd_log.string

Line 1079: fnd_log.string

1075: fnd_log.level_statement,
1076: l_debug_module,
1077: 'After calling process_route in update mode'
1078: );
1079: fnd_log.string
1080: (
1081: fnd_log.level_statement,
1082: l_debug_module,
1083: 'x_return_status -> ' || x_return_status

Line 1081: fnd_log.level_statement,

1077: 'After calling process_route in update mode'
1078: );
1079: fnd_log.string
1080: (
1081: fnd_log.level_statement,
1082: l_debug_module,
1083: 'x_return_status -> ' || x_return_status
1084: );
1085: END IF;

Line 1088: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_ROUTE_PVT.process_route');

1084: );
1085: END IF;
1086:
1087: IF (l_log_statement >= l_log_current_level) THEN
1088: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_ROUTE_PVT.process_route');
1089: END IF;
1090:
1091: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1092: IF (l_log_statement >= l_log_current_level) THEN

Line 1093: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route Error');

1089: END IF;
1090:
1091: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1092: IF (l_log_statement >= l_log_current_level) THEN
1093: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route Error');
1094: END IF;
1095: RAISE FND_API.G_EXC_ERROR;
1096: END IF;
1097:

Line 1099: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route -> updation Successful');

1095: RAISE FND_API.G_EXC_ERROR;
1096: END IF;
1097:
1098: IF (l_log_statement >= l_log_current_level) THEN
1099: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route -> updation Successful');
1100: END IF;
1101:
1102: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1103: THEN

Line 1102: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1098: IF (l_log_statement >= l_log_current_level) THEN
1099: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route -> updation Successful');
1100: END IF;
1101:
1102: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1103: THEN
1104:
1105: fnd_log.string
1106: (

Line 1105: fnd_log.string

1101:
1102: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1103: THEN
1104:
1105: fnd_log.string
1106: (
1107: fnd_log.level_statement,
1108: l_debug_module,
1109: 'before insertion into staging table'

Line 1107: fnd_log.level_statement,

1103: THEN
1104:
1105: fnd_log.string
1106: (
1107: fnd_log.level_statement,
1108: l_debug_module,
1109: 'before insertion into staging table'
1110: );
1111: END IF;

Line 1143: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1139: 'Route updated Successfully',
1140: p_enigma_route_rec.enigma_id
1141: );
1142:
1143: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1144: THEN
1145:
1146: fnd_log.string
1147: (

Line 1146: fnd_log.string

1142:
1143: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1144: THEN
1145:
1146: fnd_log.string
1147: (
1148: fnd_log.level_statement,
1149: l_debug_module,
1150: 'After insertion into staging table'

Line 1148: fnd_log.level_statement,

1144: THEN
1145:
1146: fnd_log.string
1147: (
1148: fnd_log.level_statement,
1149: l_debug_module,
1150: 'After insertion into staging table'
1151: );
1152: END IF;

Line 1159: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1155: IF ( p_enigma_op_tbl.COUNT > 0) THEN
1156: FOR i IN p_enigma_op_tbl.FIRST..p_enigma_op_tbl.LAST
1157: LOOP
1158:
1159: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1160: THEN
1161:
1162: fnd_log.string
1163: (

Line 1162: fnd_log.string

1158:
1159: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1160: THEN
1161:
1162: fnd_log.string
1163: (
1164: fnd_log.level_statement,
1165: l_debug_module,
1166: 'Process the operations , Calling Process_OP_Details '

Line 1164: fnd_log.level_statement,

1160: THEN
1161:
1162: fnd_log.string
1163: (
1164: fnd_log.level_statement,
1165: l_debug_module,
1166: 'Process the operations , Calling Process_OP_Details '
1167: );
1168: END IF;

Line 1187: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1183: p_pub_date,
1184: p_enigma_route_rec.route_id
1185: );
1186:
1187: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1188: THEN
1189:
1190: fnd_log.string
1191: (

Line 1190: fnd_log.string

1186:
1187: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1188: THEN
1189:
1190: fnd_log.string
1191: (
1192: fnd_log.level_statement,
1193: l_debug_module,
1194: 'After Calling Process_OP_Details '

Line 1192: fnd_log.level_statement,

1188: THEN
1189:
1190: fnd_log.string
1191: (
1192: fnd_log.level_statement,
1193: l_debug_module,
1194: 'After Calling Process_OP_Details '
1195: );
1196: END IF;

Line 1199: fnd_log.string(fnd_log.level_statement,l_debug_module,'After Process_OP_Details');

1195: );
1196: END IF;
1197:
1198: IF (l_log_statement >= l_log_current_level) THEN
1199: fnd_log.string(fnd_log.level_statement,l_debug_module,'After Process_OP_Details');
1200: END IF;
1201:
1202: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1203: IF (l_log_statement >= l_log_current_level) THEN

Line 1204: fnd_log.string(fnd_log.level_statement,l_debug_module,'Process_OP_Details Error');

1200: END IF;
1201:
1202: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1203: IF (l_log_statement >= l_log_current_level) THEN
1204: fnd_log.string(fnd_log.level_statement,l_debug_module,'Process_OP_Details Error');
1205: END IF;
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208: END LOOP;

Line 1216: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1212: OR l_get_latest_route_rev.revision_status = 'APPROVAL_REJECTED' ) THEN
1213: -- Start of Validations for all the mandatory common attributes.
1214: -- Validate is publish_date is Null and If so throw an error
1215:
1216: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1217: THEN
1218:
1219: fnd_log.string
1220: (

Line 1219: fnd_log.string

1215:
1216: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1217: THEN
1218:
1219: fnd_log.string
1220: (
1221: fnd_log.level_statement,
1222: l_debug_module,
1223: 'Inside Draft'

Line 1221: fnd_log.level_statement,

1217: THEN
1218:
1219: fnd_log.string
1220: (
1221: fnd_log.level_statement,
1222: l_debug_module,
1223: 'Inside Draft'
1224: );
1225: END IF;

Line 1254: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1250: THEN
1251: RAISE FND_API.G_EXC_ERROR;
1252: END IF;
1253:
1254: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1255: THEN
1256:
1257: fnd_log.string
1258: (

Line 1257: fnd_log.string

1253:
1254: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1255: THEN
1256:
1257: fnd_log.string
1258: (
1259: fnd_log.level_statement,
1260: l_debug_module,
1261: 'populate the records'

Line 1259: fnd_log.level_statement,

1255: THEN
1256:
1257: fnd_log.string
1258: (
1259: fnd_log.level_statement,
1260: l_debug_module,
1261: 'populate the records'
1262: );
1263: END IF;

Line 1278: fnd_log.string(fnd_log.level_statement,l_debug_module,'After UPLOAD_REVISION_REPORT Call ');

1274: );
1275: END IF;
1276:
1277: IF (l_log_statement >= l_log_current_level) THEN
1278: fnd_log.string(fnd_log.level_statement,l_debug_module,'After UPLOAD_REVISION_REPORT Call ');
1279: END IF;
1280:
1281: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1282: IF (l_log_statement >= l_log_current_level) THEN

Line 1283: fnd_log.string(fnd_log.level_statement,l_debug_module,'UPLOAD_REVISION_REPORT Error');

1279: END IF;
1280:
1281: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1282: IF (l_log_statement >= l_log_current_level) THEN
1283: fnd_log.string(fnd_log.level_statement,l_debug_module,'UPLOAD_REVISION_REPORT Error');
1284: END IF;
1285: RAISE FND_API.G_EXC_ERROR;
1286: END IF;
1287:

Line 1289: fnd_log.string(fnd_log.level_statement,l_debug_module,'UPLOAD_REVISION_REPORT-> File upload done');

1285: RAISE FND_API.G_EXC_ERROR;
1286: END IF;
1287:
1288: IF (l_log_statement >= l_log_current_level) THEN
1289: fnd_log.string(fnd_log.level_statement,l_debug_module,'UPLOAD_REVISION_REPORT-> File upload done');
1290: fnd_log.string(fnd_log.level_statement,l_debug_module,'File Id -> = ' || x_file_id);
1291: END IF;
1292:
1293: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 1290: fnd_log.string(fnd_log.level_statement,l_debug_module,'File Id -> = ' || x_file_id);

1286: END IF;
1287:
1288: IF (l_log_statement >= l_log_current_level) THEN
1289: fnd_log.string(fnd_log.level_statement,l_debug_module,'UPLOAD_REVISION_REPORT-> File upload done');
1290: fnd_log.string(fnd_log.level_statement,l_debug_module,'File Id -> = ' || x_file_id);
1291: END IF;
1292:
1293: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1294: THEN

Line 1293: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1289: fnd_log.string(fnd_log.level_statement,l_debug_module,'UPLOAD_REVISION_REPORT-> File upload done');
1290: fnd_log.string(fnd_log.level_statement,l_debug_module,'File Id -> = ' || x_file_id);
1291: END IF;
1292:
1293: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1294: THEN
1295:
1296: fnd_log.string
1297: (

Line 1296: fnd_log.string

1292:
1293: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1294: THEN
1295:
1296: fnd_log.string
1297: (
1298: fnd_log.level_statement,
1299: l_debug_module,
1300: 'file upload done'

Line 1298: fnd_log.level_statement,

1294: THEN
1295:
1296: fnd_log.string
1297: (
1298: fnd_log.level_statement,
1299: l_debug_module,
1300: 'file upload done'
1301: );
1302: END IF;

Line 1306: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1302: END IF;
1303:
1304: -- If the return status is success, populate the input rec for process_route for updation
1305: IF ( x_file_id <> FND_API.G_MISS_NUM AND x_file_id IS NOT NULL) THEN
1306: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1307: THEN
1308:
1309: fnd_log.string
1310: (

Line 1309: fnd_log.string

1305: IF ( x_file_id <> FND_API.G_MISS_NUM AND x_file_id IS NOT NULL) THEN
1306: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1307: THEN
1308:
1309: fnd_log.string
1310: (
1311: fnd_log.level_statement,
1312: l_debug_module,
1313: 'File id ->' || x_file_id

Line 1311: fnd_log.level_statement,

1307: THEN
1308:
1309: fnd_log.string
1310: (
1311: fnd_log.level_statement,
1312: l_debug_module,
1313: 'File id ->' || x_file_id
1314: );
1315: END IF;

Line 1358: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1354: END IF;
1355:
1356: p_process_route_input_rec.dml_operation := 'U';
1357:
1358: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1359: THEN
1360:
1361: fnd_log.string
1362: (

Line 1361: fnd_log.string

1357:
1358: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1359: THEN
1360:
1361: fnd_log.string
1362: (
1363: fnd_log.level_statement,
1364: l_debug_module,
1365: 'calling process_route'

Line 1363: fnd_log.level_statement,

1359: THEN
1360:
1361: fnd_log.string
1362: (
1363: fnd_log.level_statement,
1364: l_debug_module,
1365: 'calling process_route'
1366: );
1367: END IF;

Line 1384: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1380: x_msg_data,
1381: p_process_route_input_rec
1382: );
1383:
1384: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1385: THEN
1386:
1387: fnd_log.string
1388: (

Line 1387: fnd_log.string

1383:
1384: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1385: THEN
1386:
1387: fnd_log.string
1388: (
1389: fnd_log.level_statement,
1390: l_debug_module,
1391: 'after calling process_route'

Line 1389: fnd_log.level_statement,

1385: THEN
1386:
1387: fnd_log.string
1388: (
1389: fnd_log.level_statement,
1390: l_debug_module,
1391: 'after calling process_route'
1392: );
1393: END IF;

Line 1396: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_ROUTE_PVT.process_route');

1392: );
1393: END IF;
1394:
1395: IF (l_log_statement >= l_log_current_level) THEN
1396: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_ROUTE_PVT.process_route');
1397: END IF;
1398:
1399: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1400: IF (l_log_statement >= l_log_current_level) THEN

Line 1401: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route Error');

1397: END IF;
1398:
1399: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1400: IF (l_log_statement >= l_log_current_level) THEN
1401: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route Error');
1402: END IF;
1403: RAISE FND_API.G_EXC_ERROR;
1404: END IF;
1405:

Line 1459: fnd_log.string(fnd_log.level_statement,l_debug_module,'After Process_OP_Details');

1455: p_enigma_route_rec.route_id
1456: );
1457:
1458: IF (l_log_statement >= l_log_current_level) THEN
1459: fnd_log.string(fnd_log.level_statement,l_debug_module,'After Process_OP_Details');
1460: END IF;
1461:
1462: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1463: IF (l_log_statement >= l_log_current_level) THEN

Line 1464: fnd_log.string(fnd_log.level_statement,l_debug_module,'Process_OP_Details Error');

1460: END IF;
1461:
1462: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1463: IF (l_log_statement >= l_log_current_level) THEN
1464: fnd_log.string(fnd_log.level_statement,l_debug_module,'Process_OP_Details Error');
1465: END IF;
1466: RAISE FND_API.G_EXC_ERROR;
1467: END IF;
1468: --END LOOP;

Line 1480: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1476: FND_MSG_PUB.ADD;
1477: RAISE FND_API.G_EXC_ERROR;
1478: END IF; -- Cursor
1479: CLOSE get_latest_route_rev;
1480: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1481: THEN
1482:
1483: fnd_log.string
1484: (

Line 1483: fnd_log.string

1479: CLOSE get_latest_route_rev;
1480: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1481: THEN
1482:
1483: fnd_log.string
1484: (
1485: fnd_log.level_statement,
1486: l_debug_module,
1487: 'End if of change Flag U'

Line 1485: fnd_log.level_statement,

1481: THEN
1482:
1483: fnd_log.string
1484: (
1485: fnd_log.level_statement,
1486: l_debug_module,
1487: 'End if of change Flag U'
1488: );
1489: END IF;

Line 1495: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1491: END IF; -- Change Flag U
1492:
1493: IF (p_enigma_route_rec.change_flag = 'C') THEN
1494:
1495: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1496: THEN
1497:
1498: fnd_log.string
1499: (

Line 1498: fnd_log.string

1494:
1495: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1496: THEN
1497:
1498: fnd_log.string
1499: (
1500: fnd_log.level_statement,
1501: l_debug_module,
1502: 'Inside Create'

Line 1500: fnd_log.level_statement,

1496: THEN
1497:
1498: fnd_log.string
1499: (
1500: fnd_log.level_statement,
1501: l_debug_module,
1502: 'Inside Create'
1503: );
1504: END IF;

Line 1536: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1532: THEN
1533: RAISE FND_API.G_EXC_ERROR;
1534: END IF;
1535:
1536: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1537: THEN
1538:
1539: fnd_log.string
1540: (

Line 1539: fnd_log.string

1535:
1536: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1537: THEN
1538:
1539: fnd_log.string
1540: (
1541: fnd_log.level_statement,
1542: l_debug_module,
1543: 'Passed all validations'

Line 1541: fnd_log.level_statement,

1537: THEN
1538:
1539: fnd_log.string
1540: (
1541: fnd_log.level_statement,
1542: l_debug_module,
1543: 'Passed all validations'
1544: );
1545: fnd_log.string

Line 1545: fnd_log.string

1541: fnd_log.level_statement,
1542: l_debug_module,
1543: 'Passed all validations'
1544: );
1545: fnd_log.string
1546: (
1547: fnd_log.level_statement,
1548: l_debug_module,
1549: 'p_context -> ' || p_context

Line 1547: fnd_log.level_statement,

1543: 'Passed all validations'
1544: );
1545: fnd_log.string
1546: (
1547: fnd_log.level_statement,
1548: l_debug_module,
1549: 'p_context -> ' || p_context
1550: );
1551: fnd_log.string

Line 1551: fnd_log.string

1547: fnd_log.level_statement,
1548: l_debug_module,
1549: 'p_context -> ' || p_context
1550: );
1551: fnd_log.string
1552: (
1553: fnd_log.level_statement,
1554: l_debug_module,
1555: 'p_enigma_route_rec.revision_date -> ' || p_enigma_route_rec.revision_date

Line 1553: fnd_log.level_statement,

1549: 'p_context -> ' || p_context
1550: );
1551: fnd_log.string
1552: (
1553: fnd_log.level_statement,
1554: l_debug_module,
1555: 'p_enigma_route_rec.revision_date -> ' || p_enigma_route_rec.revision_date
1556: );
1557: fnd_log.string

Line 1557: fnd_log.string

1553: fnd_log.level_statement,
1554: l_debug_module,
1555: 'p_enigma_route_rec.revision_date -> ' || p_enigma_route_rec.revision_date
1556: );
1557: fnd_log.string
1558: (
1559: fnd_log.level_statement,
1560: l_debug_module,
1561: 'p_pub_date -> ' || p_pub_date

Line 1559: fnd_log.level_statement,

1555: 'p_enigma_route_rec.revision_date -> ' || p_enigma_route_rec.revision_date
1556: );
1557: fnd_log.string
1558: (
1559: fnd_log.level_statement,
1560: l_debug_module,
1561: 'p_pub_date -> ' || p_pub_date
1562: );
1563: fnd_log.string

Line 1563: fnd_log.string

1559: fnd_log.level_statement,
1560: l_debug_module,
1561: 'p_pub_date -> ' || p_pub_date
1562: );
1563: fnd_log.string
1564: (
1565: fnd_log.level_statement,
1566: l_debug_module,
1567: 'p_enigma_route_rec.ata_code -> ' || p_enigma_route_rec.ata_code

Line 1565: fnd_log.level_statement,

1561: 'p_pub_date -> ' || p_pub_date
1562: );
1563: fnd_log.string
1564: (
1565: fnd_log.level_statement,
1566: l_debug_module,
1567: 'p_enigma_route_rec.ata_code -> ' || p_enigma_route_rec.ata_code
1568: );
1569: fnd_log.string

Line 1569: fnd_log.string

1565: fnd_log.level_statement,
1566: l_debug_module,
1567: 'p_enigma_route_rec.ata_code -> ' || p_enigma_route_rec.ata_code
1568: );
1569: fnd_log.string
1570: (
1571: fnd_log.level_statement,
1572: l_debug_module,
1573: 'p_enigma_route_rec.description -> ' || p_enigma_route_rec.description

Line 1571: fnd_log.level_statement,

1567: 'p_enigma_route_rec.ata_code -> ' || p_enigma_route_rec.ata_code
1568: );
1569: fnd_log.string
1570: (
1571: fnd_log.level_statement,
1572: l_debug_module,
1573: 'p_enigma_route_rec.description -> ' || p_enigma_route_rec.description
1574: );
1575: fnd_log.string

Line 1575: fnd_log.string

1571: fnd_log.level_statement,
1572: l_debug_module,
1573: 'p_enigma_route_rec.description -> ' || p_enigma_route_rec.description
1574: );
1575: fnd_log.string
1576: (
1577: fnd_log.level_statement,
1578: l_debug_module,
1579: 'p_enigma_route_rec.enigma_id -> ' || p_enigma_route_rec.enigma_id

Line 1577: fnd_log.level_statement,

1573: 'p_enigma_route_rec.description -> ' || p_enigma_route_rec.description
1574: );
1575: fnd_log.string
1576: (
1577: fnd_log.level_statement,
1578: l_debug_module,
1579: 'p_enigma_route_rec.enigma_id -> ' || p_enigma_route_rec.enigma_id
1580: );
1581: fnd_log.string

Line 1581: fnd_log.string

1577: fnd_log.level_statement,
1578: l_debug_module,
1579: 'p_enigma_route_rec.enigma_id -> ' || p_enigma_route_rec.enigma_id
1580: );
1581: fnd_log.string
1582: (
1583: fnd_log.level_statement,
1584: l_debug_module,
1585: 'p_enigma_route_rec.route_id -> ' || p_enigma_route_rec.route_id

Line 1583: fnd_log.level_statement,

1579: 'p_enigma_route_rec.enigma_id -> ' || p_enigma_route_rec.enigma_id
1580: );
1581: fnd_log.string
1582: (
1583: fnd_log.level_statement,
1584: l_debug_module,
1585: 'p_enigma_route_rec.route_id -> ' || p_enigma_route_rec.route_id
1586: );
1587: fnd_log.string

Line 1587: fnd_log.string

1583: fnd_log.level_statement,
1584: l_debug_module,
1585: 'p_enigma_route_rec.route_id -> ' || p_enigma_route_rec.route_id
1586: );
1587: fnd_log.string
1588: (
1589: fnd_log.level_statement,
1590: l_debug_module,
1591: 'p_enigma_route_rec.change_flag -> ' || p_enigma_route_rec.change_flag

Line 1589: fnd_log.level_statement,

1585: 'p_enigma_route_rec.route_id -> ' || p_enigma_route_rec.route_id
1586: );
1587: fnd_log.string
1588: (
1589: fnd_log.level_statement,
1590: l_debug_module,
1591: 'p_enigma_route_rec.change_flag -> ' || p_enigma_route_rec.change_flag
1592: );
1593: END IF;

Line 1647: fnd_log.string(fnd_log.level_statement,l_debug_module,'After UPLOAD_REVISION_REPORT Call ');

1643: );
1644: END IF;
1645:
1646: IF (l_log_statement >= l_log_current_level) THEN
1647: fnd_log.string(fnd_log.level_statement,l_debug_module,'After UPLOAD_REVISION_REPORT Call ');
1648: END IF;
1649:
1650: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1651: IF (l_log_statement >= l_log_current_level) THEN

Line 1652: fnd_log.string(fnd_log.level_statement,l_debug_module,'UPLOAD_REVISION_REPORT Error');

1648: END IF;
1649:
1650: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1651: IF (l_log_statement >= l_log_current_level) THEN
1652: fnd_log.string(fnd_log.level_statement,l_debug_module,'UPLOAD_REVISION_REPORT Error');
1653: END IF;
1654: RAISE FND_API.G_EXC_ERROR;
1655: END IF;
1656:

Line 1658: fnd_log.string(fnd_log.level_statement,l_debug_module,'UPLOAD_REVISION_REPORT-> File upload done');

1654: RAISE FND_API.G_EXC_ERROR;
1655: END IF;
1656:
1657: IF (l_log_statement >= l_log_current_level) THEN
1658: fnd_log.string(fnd_log.level_statement,l_debug_module,'UPLOAD_REVISION_REPORT-> File upload done');
1659: fnd_log.string(fnd_log.level_statement,l_debug_module,'File Id -> = ' || x_file_id);
1660: END IF;
1661:
1662: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 1659: fnd_log.string(fnd_log.level_statement,l_debug_module,'File Id -> = ' || x_file_id);

1655: END IF;
1656:
1657: IF (l_log_statement >= l_log_current_level) THEN
1658: fnd_log.string(fnd_log.level_statement,l_debug_module,'UPLOAD_REVISION_REPORT-> File upload done');
1659: fnd_log.string(fnd_log.level_statement,l_debug_module,'File Id -> = ' || x_file_id);
1660: END IF;
1661:
1662: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1663: THEN

Line 1662: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1658: fnd_log.string(fnd_log.level_statement,l_debug_module,'UPLOAD_REVISION_REPORT-> File upload done');
1659: fnd_log.string(fnd_log.level_statement,l_debug_module,'File Id -> = ' || x_file_id);
1660: END IF;
1661:
1662: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1663: THEN
1664:
1665: fnd_log.string
1666: (

Line 1665: fnd_log.string

1661:
1662: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1663: THEN
1664:
1665: fnd_log.string
1666: (
1667: fnd_log.level_statement,
1668: l_debug_module,
1669: 'file upload done'

Line 1667: fnd_log.level_statement,

1663: THEN
1664:
1665: fnd_log.string
1666: (
1667: fnd_log.level_statement,
1668: l_debug_module,
1669: 'file upload done'
1670: );
1671: END IF;

Line 1675: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1671: END IF;
1672:
1673: -- If the return status is success, populate the input rec for process_route for updation
1674: IF ( x_file_id <> FND_API.G_MISS_NUM AND x_file_id IS NOT NULL) THEN
1675: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1676: THEN
1677:
1678: fnd_log.string
1679: (

Line 1678: fnd_log.string

1674: IF ( x_file_id <> FND_API.G_MISS_NUM AND x_file_id IS NOT NULL) THEN
1675: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1676: THEN
1677:
1678: fnd_log.string
1679: (
1680: fnd_log.level_statement,
1681: l_debug_module,
1682: 'File id ->' || x_file_id

Line 1680: fnd_log.level_statement,

1676: THEN
1677:
1678: fnd_log.string
1679: (
1680: fnd_log.level_statement,
1681: l_debug_module,
1682: 'File id ->' || x_file_id
1683: );
1684: END IF;

Line 1688: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1684: END IF;
1685: p_process_route_input_rec.FILE_ID := x_file_id ;
1686: END IF;
1687:
1688: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1689: THEN
1690:
1691: fnd_log.string
1692: (

Line 1691: fnd_log.string

1687:
1688: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1689: THEN
1690:
1691: fnd_log.string
1692: (
1693: fnd_log.level_statement,
1694: l_debug_module,
1695: 'Populated values '

Line 1693: fnd_log.level_statement,

1689: THEN
1690:
1691: fnd_log.string
1692: (
1693: fnd_log.level_statement,
1694: l_debug_module,
1695: 'Populated values '
1696: );
1697: fnd_log.string

Line 1697: fnd_log.string

1693: fnd_log.level_statement,
1694: l_debug_module,
1695: 'Populated values '
1696: );
1697: fnd_log.string
1698: (
1699: fnd_log.level_statement,
1700: l_debug_module,
1701: 'p_process_route_input_rec.model_code -> ' || p_process_route_input_rec.model_code

Line 1699: fnd_log.level_statement,

1695: 'Populated values '
1696: );
1697: fnd_log.string
1698: (
1699: fnd_log.level_statement,
1700: l_debug_module,
1701: 'p_process_route_input_rec.model_code -> ' || p_process_route_input_rec.model_code
1702: );
1703: fnd_log.string

Line 1703: fnd_log.string

1699: fnd_log.level_statement,
1700: l_debug_module,
1701: 'p_process_route_input_rec.model_code -> ' || p_process_route_input_rec.model_code
1702: );
1703: fnd_log.string
1704: (
1705: fnd_log.level_statement,
1706: l_debug_module,
1707: 'p_process_route_input_rec.ACTIVE_START_DATE -> ' || p_process_route_input_rec.ACTIVE_START_DATE

Line 1705: fnd_log.level_statement,

1701: 'p_process_route_input_rec.model_code -> ' || p_process_route_input_rec.model_code
1702: );
1703: fnd_log.string
1704: (
1705: fnd_log.level_statement,
1706: l_debug_module,
1707: 'p_process_route_input_rec.ACTIVE_START_DATE -> ' || p_process_route_input_rec.ACTIVE_START_DATE
1708: );
1709: fnd_log.string

Line 1709: fnd_log.string

1705: fnd_log.level_statement,
1706: l_debug_module,
1707: 'p_process_route_input_rec.ACTIVE_START_DATE -> ' || p_process_route_input_rec.ACTIVE_START_DATE
1708: );
1709: fnd_log.string
1710: (
1711: fnd_log.level_statement,
1712: l_debug_module,
1713: 'p_process_route_input_rec.enigma_publish_date -> ' || p_process_route_input_rec.enigma_publish_date

Line 1711: fnd_log.level_statement,

1707: 'p_process_route_input_rec.ACTIVE_START_DATE -> ' || p_process_route_input_rec.ACTIVE_START_DATE
1708: );
1709: fnd_log.string
1710: (
1711: fnd_log.level_statement,
1712: l_debug_module,
1713: 'p_process_route_input_rec.enigma_publish_date -> ' || p_process_route_input_rec.enigma_publish_date
1714: );
1715: fnd_log.string

Line 1715: fnd_log.string

1711: fnd_log.level_statement,
1712: l_debug_module,
1713: 'p_process_route_input_rec.enigma_publish_date -> ' || p_process_route_input_rec.enigma_publish_date
1714: );
1715: fnd_log.string
1716: (
1717: fnd_log.level_statement,
1718: l_debug_module,
1719: 'p_process_route_input_rec.route_no -> ' || p_process_route_input_rec.route_no

Line 1717: fnd_log.level_statement,

1713: 'p_process_route_input_rec.enigma_publish_date -> ' || p_process_route_input_rec.enigma_publish_date
1714: );
1715: fnd_log.string
1716: (
1717: fnd_log.level_statement,
1718: l_debug_module,
1719: 'p_process_route_input_rec.route_no -> ' || p_process_route_input_rec.route_no
1720: );
1721: fnd_log.string

Line 1721: fnd_log.string

1717: fnd_log.level_statement,
1718: l_debug_module,
1719: 'p_process_route_input_rec.route_no -> ' || p_process_route_input_rec.route_no
1720: );
1721: fnd_log.string
1722: (
1723: fnd_log.level_statement,
1724: l_debug_module,
1725: 'p_process_route_input_rec.title -> ' || p_process_route_input_rec.title

Line 1723: fnd_log.level_statement,

1719: 'p_process_route_input_rec.route_no -> ' || p_process_route_input_rec.route_no
1720: );
1721: fnd_log.string
1722: (
1723: fnd_log.level_statement,
1724: l_debug_module,
1725: 'p_process_route_input_rec.title -> ' || p_process_route_input_rec.title
1726: );
1727: fnd_log.string

Line 1727: fnd_log.string

1723: fnd_log.level_statement,
1724: l_debug_module,
1725: 'p_process_route_input_rec.title -> ' || p_process_route_input_rec.title
1726: );
1727: fnd_log.string
1728: (
1729: fnd_log.level_statement,
1730: l_debug_module,
1731: 'p_process_route_input_rec.enigma_doc_id -> ' || p_process_route_input_rec.enigma_doc_id

Line 1729: fnd_log.level_statement,

1725: 'p_process_route_input_rec.title -> ' || p_process_route_input_rec.title
1726: );
1727: fnd_log.string
1728: (
1729: fnd_log.level_statement,
1730: l_debug_module,
1731: 'p_process_route_input_rec.enigma_doc_id -> ' || p_process_route_input_rec.enigma_doc_id
1732: );
1733: fnd_log.string

Line 1733: fnd_log.string

1729: fnd_log.level_statement,
1730: l_debug_module,
1731: 'p_process_route_input_rec.enigma_doc_id -> ' || p_process_route_input_rec.enigma_doc_id
1732: );
1733: fnd_log.string
1734: (
1735: fnd_log.level_statement,
1736: l_debug_module,
1737: 'p_process_route_input_rec.enigma_route_id -> ' || p_process_route_input_rec.enigma_route_id

Line 1735: fnd_log.level_statement,

1731: 'p_process_route_input_rec.enigma_doc_id -> ' || p_process_route_input_rec.enigma_doc_id
1732: );
1733: fnd_log.string
1734: (
1735: fnd_log.level_statement,
1736: l_debug_module,
1737: 'p_process_route_input_rec.enigma_route_id -> ' || p_process_route_input_rec.enigma_route_id
1738: );
1739: fnd_log.string

Line 1739: fnd_log.string

1735: fnd_log.level_statement,
1736: l_debug_module,
1737: 'p_process_route_input_rec.enigma_route_id -> ' || p_process_route_input_rec.enigma_route_id
1738: );
1739: fnd_log.string
1740: (
1741: fnd_log.level_statement,
1742: l_debug_module,
1743: 'p_process_route_input_rec.dml_operation -> ' || p_process_route_input_rec.dml_operation

Line 1741: fnd_log.level_statement,

1737: 'p_process_route_input_rec.enigma_route_id -> ' || p_process_route_input_rec.enigma_route_id
1738: );
1739: fnd_log.string
1740: (
1741: fnd_log.level_statement,
1742: l_debug_module,
1743: 'p_process_route_input_rec.dml_operation -> ' || p_process_route_input_rec.dml_operation
1744: );
1745: fnd_log.string

Line 1745: fnd_log.string

1741: fnd_log.level_statement,
1742: l_debug_module,
1743: 'p_process_route_input_rec.dml_operation -> ' || p_process_route_input_rec.dml_operation
1744: );
1745: fnd_log.string
1746: (
1747: fnd_log.level_statement,
1748: l_debug_module,
1749: 'Calling process_route in Create mode'

Line 1747: fnd_log.level_statement,

1743: 'p_process_route_input_rec.dml_operation -> ' || p_process_route_input_rec.dml_operation
1744: );
1745: fnd_log.string
1746: (
1747: fnd_log.level_statement,
1748: l_debug_module,
1749: 'Calling process_route in Create mode'
1750: );
1751: END IF;

Line 1768: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1764: x_msg_data,
1765: p_process_route_input_rec
1766: );
1767:
1768: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1769: THEN
1770:
1771: fnd_log.string
1772: (

Line 1771: fnd_log.string

1767:
1768: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1769: THEN
1770:
1771: fnd_log.string
1772: (
1773: fnd_log.level_statement,
1774: l_debug_module,
1775: 'After Calling process_route in Create mode'

Line 1773: fnd_log.level_statement,

1769: THEN
1770:
1771: fnd_log.string
1772: (
1773: fnd_log.level_statement,
1774: l_debug_module,
1775: 'After Calling process_route in Create mode'
1776: );
1777: END IF;

Line 1781: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route Error');

1777: END IF;
1778:
1779: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1780: IF (l_log_statement >= l_log_current_level) THEN
1781: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route Error');
1782: END IF;
1783: RAISE FND_API.G_EXC_ERROR;
1784: END IF;
1785:

Line 1787: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route -> creation Successful');

1783: RAISE FND_API.G_EXC_ERROR;
1784: END IF;
1785:
1786: IF (l_log_statement >= l_log_current_level) THEN
1787: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route -> creation Successful');
1788: END IF;
1789:
1790: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1791: THEN

Line 1790: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1786: IF (l_log_statement >= l_log_current_level) THEN
1787: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route -> creation Successful');
1788: END IF;
1789:
1790: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1791: THEN
1792:
1793: fnd_log.string
1794: (

Line 1793: fnd_log.string

1789:
1790: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1791: THEN
1792:
1793: fnd_log.string
1794: (
1795: fnd_log.level_statement,
1796: l_debug_module,
1797: 'Before inserting into the staging table'

Line 1795: fnd_log.level_statement,

1791: THEN
1792:
1793: fnd_log.string
1794: (
1795: fnd_log.level_statement,
1796: l_debug_module,
1797: 'Before inserting into the staging table'
1798: );
1799: END IF;

Line 1831: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1827: 'Route created Successfully',
1828: p_enigma_route_rec.enigma_id
1829: );
1830:
1831: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1832: THEN
1833:
1834: fnd_log.string
1835: (

Line 1834: fnd_log.string

1830:
1831: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1832: THEN
1833:
1834: fnd_log.string
1835: (
1836: fnd_log.level_statement,
1837: l_debug_module,
1838: 'After inserting into the staging table'

Line 1836: fnd_log.level_statement,

1832: THEN
1833:
1834: fnd_log.string
1835: (
1836: fnd_log.level_statement,
1837: l_debug_module,
1838: 'After inserting into the staging table'
1839: );
1840: END IF;

Line 1847: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1843: IF ( p_enigma_op_tbl.COUNT > 0) THEN
1844: --FOR i IN p_enigma_op_tbl.FIRST..p_enigma_op_tbl.LAST
1845: --LOOP
1846:
1847: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1848: THEN
1849:
1850: fnd_log.string
1851: (

Line 1850: fnd_log.string

1846:
1847: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1848: THEN
1849:
1850: fnd_log.string
1851: (
1852: fnd_log.level_statement,
1853: l_debug_module,
1854: 'Operations Found Calling Process_OP_Details '

Line 1852: fnd_log.level_statement,

1848: THEN
1849:
1850: fnd_log.string
1851: (
1852: fnd_log.level_statement,
1853: l_debug_module,
1854: 'Operations Found Calling Process_OP_Details '
1855: );
1856: END IF;

Line 1876: fnd_log.string(fnd_log.level_statement,l_debug_module,'After Process_OP_Details');

1872: p_enigma_route_rec.route_id
1873: );
1874:
1875: IF (l_log_statement >= l_log_current_level) THEN
1876: fnd_log.string(fnd_log.level_statement,l_debug_module,'After Process_OP_Details');
1877: END IF;
1878:
1879: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1880: IF (l_log_statement >= l_log_current_level) THEN

Line 1881: fnd_log.string(fnd_log.level_statement,l_debug_module,'Process_OP_Details Error');

1877: END IF;
1878:
1879: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1880: IF (l_log_statement >= l_log_current_level) THEN
1881: fnd_log.string(fnd_log.level_statement,l_debug_module,'Process_OP_Details Error');
1882: END IF;
1883: RAISE FND_API.G_EXC_ERROR;
1884: END IF;
1885: --END LOOP;

Line 2020: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');

2016: fnd_global.APPS_INITIALIZE (1003259,62211, 867);
2017:
2018: -- Log API entry point
2019: IF (l_log_procedure >= l_log_current_level) THEN
2020: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');
2021: END IF;
2022:
2023: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2024: THEN

Line 2023: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2019: IF (l_log_procedure >= l_log_current_level) THEN
2020: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');
2021: END IF;
2022:
2023: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2024: THEN
2025:
2026: fnd_log.string
2027: (

Line 2026: fnd_log.string

2022:
2023: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2024: THEN
2025:
2026: fnd_log.string
2027: (
2028: fnd_log.level_statement,
2029: l_debug_module,
2030: 'Inside Process_OP_Details... p_enigma_op_tbl.COUNT ->'||p_enigma_op_tbl.COUNT

Line 2028: fnd_log.level_statement,

2024: THEN
2025:
2026: fnd_log.string
2027: (
2028: fnd_log.level_statement,
2029: l_debug_module,
2030: 'Inside Process_OP_Details... p_enigma_op_tbl.COUNT ->'||p_enigma_op_tbl.COUNT
2031: );
2032: END IF;

Line 2042: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2038: IF ( p_enigma_op_tbl.COUNT > 0) THEN
2039: FOR i IN p_enigma_op_tbl.FIRST..p_enigma_op_tbl.LAST
2040: LOOP
2041:
2042: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2043: THEN
2044:
2045: fnd_log.string
2046: (

Line 2045: fnd_log.string

2041:
2042: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2043: THEN
2044:
2045: fnd_log.string
2046: (
2047: fnd_log.level_statement,
2048: l_debug_module,
2049: 'Inside Process_OP_Details -> Operations Found i->'||i

Line 2047: fnd_log.level_statement,

2043: THEN
2044:
2045: fnd_log.string
2046: (
2047: fnd_log.level_statement,
2048: l_debug_module,
2049: 'Inside Process_OP_Details -> Operations Found i->'||i
2050: );
2051: END IF;

Line 2060: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2056: ELSE
2057: parent_route_id := p_enigma_op_tbl(i).parent_route_id;
2058: END IF;
2059:
2060: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2061: THEN
2062:
2063: fnd_log.string
2064: (

Line 2063: fnd_log.string

2059:
2060: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2061: THEN
2062:
2063: fnd_log.string
2064: (
2065: fnd_log.level_statement,
2066: l_debug_module,
2067: 'Parent RouteId ' || parent_route_id

Line 2065: fnd_log.level_statement,

2061: THEN
2062:
2063: fnd_log.string
2064: (
2065: fnd_log.level_statement,
2066: l_debug_module,
2067: 'Parent RouteId ' || parent_route_id
2068: );
2069: END IF;

Line 2081: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2077: FND_MSG_PUB.ADD;
2078: RAISE FND_API.G_EXC_ERROR;
2079: END IF;
2080:
2081: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2082: THEN
2083:
2084: fnd_log.string
2085: (

Line 2084: fnd_log.string

2080:
2081: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2082: THEN
2083:
2084: fnd_log.string
2085: (
2086: fnd_log.level_statement,
2087: l_debug_module,
2088: 'Change Flag set right'

Line 2086: fnd_log.level_statement,

2082: THEN
2083:
2084: fnd_log.string
2085: (
2086: fnd_log.level_statement,
2087: l_debug_module,
2088: 'Change Flag set right'
2089: );
2090: END IF;

Line 2100: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2096: FND_MSG_PUB.ADD;
2097: RAISE FND_API.G_EXC_ERROR;
2098: END IF;
2099:
2100: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2101: THEN
2102:
2103: fnd_log.string
2104: (

Line 2103: fnd_log.string

2099:
2100: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2101: THEN
2102:
2103: fnd_log.string
2104: (
2105: fnd_log.level_statement,
2106: l_debug_module,
2107: 'Operation Id is not null'

Line 2105: fnd_log.level_statement,

2101: THEN
2102:
2103: fnd_log.string
2104: (
2105: fnd_log.level_statement,
2106: l_debug_module,
2107: 'Operation Id is not null'
2108: );
2109: END IF;

Line 2114: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2110:
2111: -- If the operation change flag is "D" then process the operation accordingly .
2112: IF (p_enigma_op_tbl(i).change_flag = 'D') THEN
2113:
2114: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2115: THEN
2116:
2117: fnd_log.string
2118: (

Line 2117: fnd_log.string

2113:
2114: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2115: THEN
2116:
2117: fnd_log.string
2118: (
2119: fnd_log.level_statement,
2120: l_debug_module,
2121: 'Operation Flag is D'

Line 2119: fnd_log.level_statement,

2115: THEN
2116:
2117: fnd_log.string
2118: (
2119: fnd_log.level_statement,
2120: l_debug_module,
2121: 'Operation Flag is D'
2122: );
2123: END IF;

Line 2131: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2127: l_get_latest_oper_rev.operation_id,
2128: l_get_latest_oper_rev.object_version_number,
2129: l_get_latest_oper_rev.revision_status;
2130:
2131: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2132: THEN
2133:
2134: fnd_log.string
2135: (

Line 2134: fnd_log.string

2130:
2131: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2132: THEN
2133:
2134: fnd_log.string
2135: (
2136: fnd_log.level_statement,
2137: l_debug_module,
2138: 'l_get_latest_oper_rev.operation_id ->' || l_get_latest_oper_rev.operation_id

Line 2136: fnd_log.level_statement,

2132: THEN
2133:
2134: fnd_log.string
2135: (
2136: fnd_log.level_statement,
2137: l_debug_module,
2138: 'l_get_latest_oper_rev.operation_id ->' || l_get_latest_oper_rev.operation_id
2139: );
2140: fnd_log.string

Line 2140: fnd_log.string

2136: fnd_log.level_statement,
2137: l_debug_module,
2138: 'l_get_latest_oper_rev.operation_id ->' || l_get_latest_oper_rev.operation_id
2139: );
2140: fnd_log.string
2141: (
2142: fnd_log.level_statement,
2143: l_debug_module,
2144: 'l_get_latest_oper_rev.object_version_number ->' || l_get_latest_oper_rev.object_version_number

Line 2142: fnd_log.level_statement,

2138: 'l_get_latest_oper_rev.operation_id ->' || l_get_latest_oper_rev.operation_id
2139: );
2140: fnd_log.string
2141: (
2142: fnd_log.level_statement,
2143: l_debug_module,
2144: 'l_get_latest_oper_rev.object_version_number ->' || l_get_latest_oper_rev.object_version_number
2145: );
2146: fnd_log.string

Line 2146: fnd_log.string

2142: fnd_log.level_statement,
2143: l_debug_module,
2144: 'l_get_latest_oper_rev.object_version_number ->' || l_get_latest_oper_rev.object_version_number
2145: );
2146: fnd_log.string
2147: (
2148: fnd_log.level_statement,
2149: l_debug_module,
2150: 'l_get_latest_oper_rev.revision_status ->' || l_get_latest_oper_rev.revision_status

Line 2148: fnd_log.level_statement,

2144: 'l_get_latest_oper_rev.object_version_number ->' || l_get_latest_oper_rev.object_version_number
2145: );
2146: fnd_log.string
2147: (
2148: fnd_log.level_statement,
2149: l_debug_module,
2150: 'l_get_latest_oper_rev.revision_status ->' || l_get_latest_oper_rev.revision_status
2151: );
2152: END IF;

Line 2157: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2153:
2154: IF get_latest_oper_rev%FOUND THEN
2155:
2156:
2157: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2158: THEN
2159: fnd_log.string
2160: (
2161: fnd_log.level_statement,

Line 2159: fnd_log.string

2155:
2156:
2157: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2158: THEN
2159: fnd_log.string
2160: (
2161: fnd_log.level_statement,
2162: l_debug_module,
2163: 'Cursor Found '

Line 2161: fnd_log.level_statement,

2157: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2158: THEN
2159: fnd_log.string
2160: (
2161: fnd_log.level_statement,
2162: l_debug_module,
2163: 'Cursor Found '
2164: );
2165: END IF;

Line 2198: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2194: p_enigma_op_tbl(i).enigma_id
2195: );
2196:
2197: ELSE
2198: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2199: THEN
2200: fnd_log.string
2201: (
2202: fnd_log.level_statement,

Line 2200: fnd_log.string

2196:
2197: ELSE
2198: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2199: THEN
2200: fnd_log.string
2201: (
2202: fnd_log.level_statement,
2203: l_debug_module,
2204: 'Inside else , calling delete operation'

Line 2202: fnd_log.level_statement,

2198: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2199: THEN
2200: fnd_log.string
2201: (
2202: fnd_log.level_statement,
2203: l_debug_module,
2204: 'Inside else , calling delete operation'
2205: );
2206: END IF;

Line 2225: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_OPERATION_PVT.delete_operation');

2221: l_get_latest_oper_rev.object_version_number
2222: );
2223:
2224: IF (l_log_statement >= l_log_current_level) THEN
2225: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_OPERATION_PVT.delete_operation');
2226: END IF;
2227:
2228: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
2229: IF (l_log_statement >= l_log_current_level) THEN

Line 2230: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.delete_operation Error');

2226: END IF;
2227:
2228: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
2229: IF (l_log_statement >= l_log_current_level) THEN
2230: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.delete_operation Error');
2231: END IF;
2232: RAISE FND_API.G_EXC_ERROR;
2233: END IF;
2234:

Line 2236: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.delete_operation -> deletion Successful');

2232: RAISE FND_API.G_EXC_ERROR;
2233: END IF;
2234:
2235: IF (l_log_statement >= l_log_current_level) THEN
2236: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.delete_operation -> deletion Successful');
2237: END IF;
2238:
2239: CLOSE get_latest_oper_rev;
2240: END IF;

Line 2253: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2249:
2250: -- If the operation change flag is "U" then process the operation accordingly .
2251: IF (p_enigma_op_tbl(i).change_flag = 'U') THEN
2252:
2253: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2254: THEN
2255:
2256: fnd_log.string
2257: (

Line 2256: fnd_log.string

2252:
2253: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2254: THEN
2255:
2256: fnd_log.string
2257: (
2258: fnd_log.level_statement,
2259: l_debug_module,
2260: 'Operation Flag is U'

Line 2258: fnd_log.level_statement,

2254: THEN
2255:
2256: fnd_log.string
2257: (
2258: fnd_log.level_statement,
2259: l_debug_module,
2260: 'Operation Flag is U'
2261: );
2262: fnd_log.string

Line 2262: fnd_log.string

2258: fnd_log.level_statement,
2259: l_debug_module,
2260: 'Operation Flag is U'
2261: );
2262: fnd_log.string
2263: (
2264: fnd_log.level_statement,
2265: l_debug_module,
2266: 'p_enigma_op_tbl(i).operation_id -> ' || p_enigma_op_tbl(i).operation_id

Line 2264: fnd_log.level_statement,

2260: 'Operation Flag is U'
2261: );
2262: fnd_log.string
2263: (
2264: fnd_log.level_statement,
2265: l_debug_module,
2266: 'p_enigma_op_tbl(i).operation_id -> ' || p_enigma_op_tbl(i).operation_id
2267: );
2268: END IF;

Line 2276: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2272: l_get_latest_oper_rev.operation_id,
2273: l_get_latest_oper_rev.object_version_number,
2274: l_get_latest_oper_rev.revision_status;
2275:
2276: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2277: THEN
2278:
2279: fnd_log.string
2280: (

Line 2279: fnd_log.string

2275:
2276: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2277: THEN
2278:
2279: fnd_log.string
2280: (
2281: fnd_log.level_statement,
2282: l_debug_module,
2283: 'l_get_latest_oper_rev.operation_id ->' || l_get_latest_oper_rev.operation_id

Line 2281: fnd_log.level_statement,

2277: THEN
2278:
2279: fnd_log.string
2280: (
2281: fnd_log.level_statement,
2282: l_debug_module,
2283: 'l_get_latest_oper_rev.operation_id ->' || l_get_latest_oper_rev.operation_id
2284: );
2285: fnd_log.string

Line 2285: fnd_log.string

2281: fnd_log.level_statement,
2282: l_debug_module,
2283: 'l_get_latest_oper_rev.operation_id ->' || l_get_latest_oper_rev.operation_id
2284: );
2285: fnd_log.string
2286: (
2287: fnd_log.level_statement,
2288: l_debug_module,
2289: 'l_get_latest_oper_rev.object_version_number ->' || l_get_latest_oper_rev.object_version_number

Line 2287: fnd_log.level_statement,

2283: 'l_get_latest_oper_rev.operation_id ->' || l_get_latest_oper_rev.operation_id
2284: );
2285: fnd_log.string
2286: (
2287: fnd_log.level_statement,
2288: l_debug_module,
2289: 'l_get_latest_oper_rev.object_version_number ->' || l_get_latest_oper_rev.object_version_number
2290: );
2291: fnd_log.string

Line 2291: fnd_log.string

2287: fnd_log.level_statement,
2288: l_debug_module,
2289: 'l_get_latest_oper_rev.object_version_number ->' || l_get_latest_oper_rev.object_version_number
2290: );
2291: fnd_log.string
2292: (
2293: fnd_log.level_statement,
2294: l_debug_module,
2295: 'l_get_latest_oper_rev.revision_status ->' || l_get_latest_oper_rev.revision_status

Line 2293: fnd_log.level_statement,

2289: 'l_get_latest_oper_rev.object_version_number ->' || l_get_latest_oper_rev.object_version_number
2290: );
2291: fnd_log.string
2292: (
2293: fnd_log.level_statement,
2294: l_debug_module,
2295: 'l_get_latest_oper_rev.revision_status ->' || l_get_latest_oper_rev.revision_status
2296: );
2297: END IF;

Line 2300: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2296: );
2297: END IF;
2298:
2299: IF get_latest_oper_rev%FOUND THEN
2300: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2301: THEN
2302:
2303: fnd_log.string
2304: (

Line 2303: fnd_log.string

2299: IF get_latest_oper_rev%FOUND THEN
2300: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2301: THEN
2302:
2303: fnd_log.string
2304: (
2305: fnd_log.level_statement,
2306: l_debug_module,
2307: 'Latest Operation Found'

Line 2305: fnd_log.level_statement,

2301: THEN
2302:
2303: fnd_log.string
2304: (
2305: fnd_log.level_statement,
2306: l_debug_module,
2307: 'Latest Operation Found'
2308: );
2309: END IF;

Line 2361: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_OPERATION_PVT.create_oper_revision');

2357: x_operation_id
2358: );
2359:
2360: IF (l_log_statement >= l_log_current_level) THEN
2361: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_OPERATION_PVT.create_oper_revision');
2362: END IF;
2363:
2364: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
2365: IF (l_log_statement >= l_log_current_level) THEN

Line 2366: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.create_oper_revision Error');

2362: END IF;
2363:
2364: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
2365: IF (l_log_statement >= l_log_current_level) THEN
2366: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.create_oper_revision Error');
2367: END IF;
2368: RAISE FND_API.G_EXC_ERROR;
2369: END IF;
2370:

Line 2372: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.create_oper_revision -> revision Created');

2368: RAISE FND_API.G_EXC_ERROR;
2369: END IF;
2370:
2371: IF (l_log_statement >= l_log_current_level) THEN
2372: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.create_oper_revision -> revision Created');
2373: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.create_oper_revision -> x_operation_id= ' || x_operation_id);
2374: END IF;
2375:
2376: -- If the return status is success, populate the input rec for process_operation for updation

Line 2373: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.create_oper_revision -> x_operation_id= ' || x_operation_id);

2369: END IF;
2370:
2371: IF (l_log_statement >= l_log_current_level) THEN
2372: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.create_oper_revision -> revision Created');
2373: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.create_oper_revision -> x_operation_id= ' || x_operation_id);
2374: END IF;
2375:
2376: -- If the return status is success, populate the input rec for process_operation for updation
2377: -- Do the mandatory validations

Line 2442: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_OPERATION_PVT.process_operation');

2438: p_process_oper_input_rec
2439: );
2440:
2441: IF (l_log_statement >= l_log_current_level) THEN
2442: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_OPERATION_PVT.process_operation');
2443: END IF;
2444:
2445: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
2446: IF (l_log_statement >= l_log_current_level) THEN

Line 2447: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation Error');

2443: END IF;
2444:
2445: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
2446: IF (l_log_statement >= l_log_current_level) THEN
2447: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation Error');
2448: END IF;
2449: RAISE FND_API.G_EXC_ERROR;
2450: END IF;
2451:

Line 2453: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation -> updation Successful');

2449: RAISE FND_API.G_EXC_ERROR;
2450: END IF;
2451:
2452: IF (l_log_statement >= l_log_current_level) THEN
2453: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation -> updation Successful');
2454: END IF;
2455:
2456: -- Insert the transaction record into the staging table, with status as success
2457: INSERT INTO AHL_RT_OPER_INTERFACE

Line 2488: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2484: -- If the status is Draft or Approval Rejected , do the following.
2485: ELSIF ( UPPER(l_get_latest_oper_rev.revision_status) = 'DRAFT'
2486: OR UPPER(l_get_latest_oper_rev.revision_status) = 'APPROVAL_REJECTED' ) THEN
2487:
2488: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2489: THEN
2490:
2491: fnd_log.string
2492: (

Line 2491: fnd_log.string

2487:
2488: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2489: THEN
2490:
2491: fnd_log.string
2492: (
2493: fnd_log.level_statement,
2494: l_debug_module,
2495: 'Update Operation-> Draft'

Line 2493: fnd_log.level_statement,

2489: THEN
2490:
2491: fnd_log.string
2492: (
2493: fnd_log.level_statement,
2494: l_debug_module,
2495: 'Update Operation-> Draft'
2496: );
2497: END IF;

Line 2519: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2515: THEN
2516: RAISE FND_API.G_EXC_ERROR;
2517: END IF;
2518:
2519: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2520: THEN
2521:
2522: fnd_log.string
2523: (

Line 2522: fnd_log.string

2518:
2519: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2520: THEN
2521:
2522: fnd_log.string
2523: (
2524: fnd_log.level_statement,
2525: l_debug_module,
2526: 'populate the input rec'

Line 2524: fnd_log.level_statement,

2520: THEN
2521:
2522: fnd_log.string
2523: (
2524: fnd_log.level_statement,
2525: l_debug_module,
2526: 'populate the input rec'
2527: );
2528: END IF;

Line 2560: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2556:
2557: p_process_oper_input_rec.DML_OPERATION := 'U';
2558:
2559:
2560: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2561: THEN
2562:
2563: fnd_log.string
2564: (

Line 2563: fnd_log.string

2559:
2560: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2561: THEN
2562:
2563: fnd_log.string
2564: (
2565: fnd_log.level_statement,
2566: l_debug_module,
2567: 'p_process_oper_input_rec.OPERATION_ID-> ' || p_process_oper_input_rec.OPERATION_ID

Line 2565: fnd_log.level_statement,

2561: THEN
2562:
2563: fnd_log.string
2564: (
2565: fnd_log.level_statement,
2566: l_debug_module,
2567: 'p_process_oper_input_rec.OPERATION_ID-> ' || p_process_oper_input_rec.OPERATION_ID
2568: );
2569: fnd_log.string

Line 2569: fnd_log.string

2565: fnd_log.level_statement,
2566: l_debug_module,
2567: 'p_process_oper_input_rec.OPERATION_ID-> ' || p_process_oper_input_rec.OPERATION_ID
2568: );
2569: fnd_log.string
2570: (
2571: fnd_log.level_statement,
2572: l_debug_module,
2573: 'l_get_latest_oper_rev.object_version_number -> ' || l_get_latest_oper_rev.object_version_number

Line 2571: fnd_log.level_statement,

2567: 'p_process_oper_input_rec.OPERATION_ID-> ' || p_process_oper_input_rec.OPERATION_ID
2568: );
2569: fnd_log.string
2570: (
2571: fnd_log.level_statement,
2572: l_debug_module,
2573: 'l_get_latest_oper_rev.object_version_number -> ' || l_get_latest_oper_rev.object_version_number
2574: );
2575: fnd_log.string

Line 2575: fnd_log.string

2571: fnd_log.level_statement,
2572: l_debug_module,
2573: 'l_get_latest_oper_rev.object_version_number -> ' || l_get_latest_oper_rev.object_version_number
2574: );
2575: fnd_log.string
2576: (
2577: fnd_log.level_statement,
2578: l_debug_module,
2579: 'p_enigma_op_tbl(i).description -> ' || p_enigma_op_tbl(i).description

Line 2577: fnd_log.level_statement,

2573: 'l_get_latest_oper_rev.object_version_number -> ' || l_get_latest_oper_rev.object_version_number
2574: );
2575: fnd_log.string
2576: (
2577: fnd_log.level_statement,
2578: l_debug_module,
2579: 'p_enigma_op_tbl(i).description -> ' || p_enigma_op_tbl(i).description
2580: );
2581: fnd_log.string

Line 2581: fnd_log.string

2577: fnd_log.level_statement,
2578: l_debug_module,
2579: 'p_enigma_op_tbl(i).description -> ' || p_enigma_op_tbl(i).description
2580: );
2581: fnd_log.string
2582: (
2583: fnd_log.level_statement,
2584: l_debug_module,
2585: 'p_process_oper_input_rec.ENIGMA_OP_ID -> ' || p_process_oper_input_rec.ENIGMA_OP_ID

Line 2583: fnd_log.level_statement,

2579: 'p_enigma_op_tbl(i).description -> ' || p_enigma_op_tbl(i).description
2580: );
2581: fnd_log.string
2582: (
2583: fnd_log.level_statement,
2584: l_debug_module,
2585: 'p_process_oper_input_rec.ENIGMA_OP_ID -> ' || p_process_oper_input_rec.ENIGMA_OP_ID
2586: );
2587: fnd_log.string

Line 2587: fnd_log.string

2583: fnd_log.level_statement,
2584: l_debug_module,
2585: 'p_process_oper_input_rec.ENIGMA_OP_ID -> ' || p_process_oper_input_rec.ENIGMA_OP_ID
2586: );
2587: fnd_log.string
2588: (
2589: fnd_log.level_statement,
2590: l_debug_module,
2591: 'p_process_oper_input_rec.SEGMENT2 -> ' || p_process_oper_input_rec.SEGMENT2

Line 2589: fnd_log.level_statement,

2585: 'p_process_oper_input_rec.ENIGMA_OP_ID -> ' || p_process_oper_input_rec.ENIGMA_OP_ID
2586: );
2587: fnd_log.string
2588: (
2589: fnd_log.level_statement,
2590: l_debug_module,
2591: 'p_process_oper_input_rec.SEGMENT2 -> ' || p_process_oper_input_rec.SEGMENT2
2592: );
2593: END IF;

Line 2595: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2591: 'p_process_oper_input_rec.SEGMENT2 -> ' || p_process_oper_input_rec.SEGMENT2
2592: );
2593: END IF;
2594:
2595: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2596: THEN
2597:
2598: fnd_log.string
2599: (

Line 2598: fnd_log.string

2594:
2595: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2596: THEN
2597:
2598: fnd_log.string
2599: (
2600: fnd_log.level_statement,
2601: l_debug_module,
2602: 'Calling AHL_RM_OPERATION_PVT.process_operation '

Line 2600: fnd_log.level_statement,

2596: THEN
2597:
2598: fnd_log.string
2599: (
2600: fnd_log.level_statement,
2601: l_debug_module,
2602: 'Calling AHL_RM_OPERATION_PVT.process_operation '
2603: );
2604: END IF;

Line 2622: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_OPERATION_PVT.process_operation');

2618: p_process_oper_input_rec
2619: );
2620:
2621: IF (l_log_statement >= l_log_current_level) THEN
2622: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_OPERATION_PVT.process_operation');
2623: END IF;
2624:
2625: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
2626: IF (l_log_statement >= l_log_current_level) THEN

Line 2627: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation Error');

2623: END IF;
2624:
2625: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
2626: IF (l_log_statement >= l_log_current_level) THEN
2627: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation Error');
2628: END IF;
2629: RAISE FND_API.G_EXC_ERROR;
2630: END IF;
2631:

Line 2633: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation -> updation Successful');

2629: RAISE FND_API.G_EXC_ERROR;
2630: END IF;
2631:
2632: IF (l_log_statement >= l_log_current_level) THEN
2633: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation -> updation Successful');
2634: END IF;
2635:
2636: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2637: THEN

Line 2636: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2632: IF (l_log_statement >= l_log_current_level) THEN
2633: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation -> updation Successful');
2634: END IF;
2635:
2636: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2637: THEN
2638:
2639: fnd_log.string
2640: (

Line 2639: fnd_log.string

2635:
2636: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2637: THEN
2638:
2639: fnd_log.string
2640: (
2641: fnd_log.level_statement,
2642: l_debug_module,
2643: 'Before inserting into the staging table'

Line 2641: fnd_log.level_statement,

2637: THEN
2638:
2639: fnd_log.string
2640: (
2641: fnd_log.level_statement,
2642: l_debug_module,
2643: 'Before inserting into the staging table'
2644: );
2645: END IF;

Line 2678: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2674:
2675: END IF ; -- Status check
2676: CLOSE get_latest_oper_rev;
2677:
2678: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2679: THEN
2680:
2681: fnd_log.string
2682: (

Line 2681: fnd_log.string

2677:
2678: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2679: THEN
2680:
2681: fnd_log.string
2682: (
2683: fnd_log.level_statement,
2684: l_debug_module,
2685: 'After inserting into the staging table'

Line 2683: fnd_log.level_statement,

2679: THEN
2680:
2681: fnd_log.string
2682: (
2683: fnd_log.level_statement,
2684: l_debug_module,
2685: 'After inserting into the staging table'
2686: );
2687: END IF;

Line 2701: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2697: -- If the change flag is C then create a new operation.
2698: IF (p_enigma_op_tbl(i).change_flag = 'C') THEN
2699:
2700:
2701: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2702: THEN
2703:
2704: fnd_log.string
2705: (

Line 2704: fnd_log.string

2700:
2701: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2702: THEN
2703:
2704: fnd_log.string
2705: (
2706: fnd_log.level_statement,
2707: l_debug_module,
2708: 'Inside Process_OP_Details -> Inside C '

Line 2706: fnd_log.level_statement,

2702: THEN
2703:
2704: fnd_log.string
2705: (
2706: fnd_log.level_statement,
2707: l_debug_module,
2708: 'Inside Process_OP_Details -> Inside C '
2709: );
2710: END IF;

Line 2736: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2732: p_process_oper_input_rec.ACTIVE_START_DATE := sysdate;
2733: p_process_oper_input_rec.DML_OPERATION := p_enigma_op_tbl(i).change_flag;
2734: p_process_oper_input_rec.STANDARD_OPERATION_FLAG := 'N';
2735:
2736: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2737: THEN
2738:
2739: fnd_log.string
2740: (

Line 2739: fnd_log.string

2735:
2736: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2737: THEN
2738:
2739: fnd_log.string
2740: (
2741: fnd_log.level_statement,
2742: l_debug_module,
2743: 'Inside Process_OP_Details calling process_operations'

Line 2741: fnd_log.level_statement,

2737: THEN
2738:
2739: fnd_log.string
2740: (
2741: fnd_log.level_statement,
2742: l_debug_module,
2743: 'Inside Process_OP_Details calling process_operations'
2744: );
2745: END IF;

Line 2765: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2761:
2762: x_operation_id := p_process_oper_input_rec.operation_id;
2763: x_revision_number := p_process_oper_input_rec.REVISION_NUMBER;
2764:
2765: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2766: THEN
2767:
2768: fnd_log.string
2769: (

Line 2768: fnd_log.string

2764:
2765: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2766: THEN
2767:
2768: fnd_log.string
2769: (
2770: fnd_log.level_statement,
2771: l_debug_module,
2772: 'Operation Created ->' || x_operation_id

Line 2770: fnd_log.level_statement,

2766: THEN
2767:
2768: fnd_log.string
2769: (
2770: fnd_log.level_statement,
2771: l_debug_module,
2772: 'Operation Created ->' || x_operation_id
2773: );
2774: fnd_log.string

Line 2774: fnd_log.string

2770: fnd_log.level_statement,
2771: l_debug_module,
2772: 'Operation Created ->' || x_operation_id
2773: );
2774: fnd_log.string
2775: (
2776: fnd_log.level_statement,
2777: l_debug_module,
2778: 'Operation Created Revision->' || x_revision_number

Line 2776: fnd_log.level_statement,

2772: 'Operation Created ->' || x_operation_id
2773: );
2774: fnd_log.string
2775: (
2776: fnd_log.level_statement,
2777: l_debug_module,
2778: 'Operation Created Revision->' || x_revision_number
2779: );
2780: fnd_log.string

Line 2780: fnd_log.string

2776: fnd_log.level_statement,
2777: l_debug_module,
2778: 'Operation Created Revision->' || x_revision_number
2779: );
2780: fnd_log.string
2781: (
2782: fnd_log.level_statement,
2783: l_debug_module,
2784: 'Process_OP_Details after calling process_operations'

Line 2782: fnd_log.level_statement,

2778: 'Operation Created Revision->' || x_revision_number
2779: );
2780: fnd_log.string
2781: (
2782: fnd_log.level_statement,
2783: l_debug_module,
2784: 'Process_OP_Details after calling process_operations'
2785: );
2786: END IF;

Line 2789: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_OPERATION_PVT.process_operation');

2785: );
2786: END IF;
2787:
2788: IF (l_log_statement >= l_log_current_level) THEN
2789: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_OPERATION_PVT.process_operation');
2790: END IF;
2791:
2792: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
2793: IF (l_log_statement >= l_log_current_level) THEN

Line 2794: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation Error');

2790: END IF;
2791:
2792: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
2793: IF (l_log_statement >= l_log_current_level) THEN
2794: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation Error');
2795: END IF;
2796: RAISE FND_API.G_EXC_ERROR;
2797: END IF;
2798:

Line 2800: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation -> creation Successful');

2796: RAISE FND_API.G_EXC_ERROR;
2797: END IF;
2798:
2799: IF (l_log_statement >= l_log_current_level) THEN
2800: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation -> creation Successful');
2801: END IF;
2802:
2803: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2804: THEN

Line 2803: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2799: IF (l_log_statement >= l_log_current_level) THEN
2800: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation -> creation Successful');
2801: END IF;
2802:
2803: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2804: THEN
2805:
2806: fnd_log.string
2807: (

Line 2806: fnd_log.string

2802:
2803: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2804: THEN
2805:
2806: fnd_log.string
2807: (
2808: fnd_log.level_statement,
2809: l_debug_module,
2810: 'before inserting the operations into staging table '

Line 2808: fnd_log.level_statement,

2804: THEN
2805:
2806: fnd_log.string
2807: (
2808: fnd_log.level_statement,
2809: l_debug_module,
2810: 'before inserting the operations into staging table '
2811: );
2812: END IF;

Line 2847: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2843:
2844: SELECT route_id INTO p_route_id FROM AHL_ROUTES_B
2845: WHERE ENIGMA_ROUTE_ID = parent_route_id;
2846:
2847: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2848: THEN
2849:
2850: fnd_log.string
2851: (

Line 2850: fnd_log.string

2846:
2847: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2848: THEN
2849:
2850: fnd_log.string
2851: (
2852: fnd_log.level_statement,
2853: l_debug_module,
2854: 'p_route_id -> '|| p_route_id

Line 2852: fnd_log.level_statement,

2848: THEN
2849:
2850: fnd_log.string
2851: (
2852: fnd_log.level_statement,
2853: l_debug_module,
2854: 'p_route_id -> '|| p_route_id
2855: );
2856: END IF;

Line 2866: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2862: route_operation_tbl_type(1).DML_OPERATION := 'C';
2863: route_operation_tbl_type(1).REVISION_NUMBER := x_revision_number;
2864: route_operation_tbl_type(1).check_point_flag := 'N';
2865:
2866: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2867: THEN
2868:
2869: fnd_log.string
2870: (

Line 2869: fnd_log.string

2865:
2866: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2867: THEN
2868:
2869: fnd_log.string
2870: (
2871: fnd_log.level_statement,
2872: l_debug_module,
2873: 'route_operation_tbl_type(i).OPERATION_ID -> '|| route_operation_tbl_type(1).OPERATION_ID

Line 2871: fnd_log.level_statement,

2867: THEN
2868:
2869: fnd_log.string
2870: (
2871: fnd_log.level_statement,
2872: l_debug_module,
2873: 'route_operation_tbl_type(i).OPERATION_ID -> '|| route_operation_tbl_type(1).OPERATION_ID
2874: );
2875: fnd_log.string

Line 2875: fnd_log.string

2871: fnd_log.level_statement,
2872: l_debug_module,
2873: 'route_operation_tbl_type(i).OPERATION_ID -> '|| route_operation_tbl_type(1).OPERATION_ID
2874: );
2875: fnd_log.string
2876: (
2877: fnd_log.level_statement,
2878: l_debug_module,
2879: 'route_operation_tbl_type(i).STEP -> ' || route_operation_tbl_type(1).STEP

Line 2877: fnd_log.level_statement,

2873: 'route_operation_tbl_type(i).OPERATION_ID -> '|| route_operation_tbl_type(1).OPERATION_ID
2874: );
2875: fnd_log.string
2876: (
2877: fnd_log.level_statement,
2878: l_debug_module,
2879: 'route_operation_tbl_type(i).STEP -> ' || route_operation_tbl_type(1).STEP
2880: );
2881: fnd_log.string

Line 2881: fnd_log.string

2877: fnd_log.level_statement,
2878: l_debug_module,
2879: 'route_operation_tbl_type(i).STEP -> ' || route_operation_tbl_type(1).STEP
2880: );
2881: fnd_log.string
2882: (
2883: fnd_log.level_statement,
2884: l_debug_module,
2885: 'route_operation_tbl_type(i).DML_OPERATION -> ' || route_operation_tbl_type(1).DML_OPERATION

Line 2883: fnd_log.level_statement,

2879: 'route_operation_tbl_type(i).STEP -> ' || route_operation_tbl_type(1).STEP
2880: );
2881: fnd_log.string
2882: (
2883: fnd_log.level_statement,
2884: l_debug_module,
2885: 'route_operation_tbl_type(i).DML_OPERATION -> ' || route_operation_tbl_type(1).DML_OPERATION
2886: );
2887: fnd_log.string

Line 2887: fnd_log.string

2883: fnd_log.level_statement,
2884: l_debug_module,
2885: 'route_operation_tbl_type(i).DML_OPERATION -> ' || route_operation_tbl_type(1).DML_OPERATION
2886: );
2887: fnd_log.string
2888: (
2889: fnd_log.level_statement,
2890: l_debug_module,
2891: 'route_operation_tbl_type(i).REVISION_NUMBER -> '|| route_operation_tbl_type(1).REVISION_NUMBER

Line 2889: fnd_log.level_statement,

2885: 'route_operation_tbl_type(i).DML_OPERATION -> ' || route_operation_tbl_type(1).DML_OPERATION
2886: );
2887: fnd_log.string
2888: (
2889: fnd_log.level_statement,
2890: l_debug_module,
2891: 'route_operation_tbl_type(i).REVISION_NUMBER -> '|| route_operation_tbl_type(1).REVISION_NUMBER
2892: );
2893: END IF;

Line 2910: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2906: route_operation_tbl_type,
2907: p_route_id
2908: );
2909:
2910: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2911: THEN
2912:
2913: fnd_log.string
2914: (

Line 2913: fnd_log.string

2909:
2910: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2911: THEN
2912:
2913: fnd_log.string
2914: (
2915: fnd_log.level_statement,
2916: l_debug_module,
2917: 'Association ID x_return_status-> '|| x_return_status

Line 2915: fnd_log.level_statement,

2911: THEN
2912:
2913: fnd_log.string
2914: (
2915: fnd_log.level_statement,
2916: l_debug_module,
2917: 'Association ID x_return_status-> '|| x_return_status
2918: );
2919: END IF;

Line 2922: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_OP_ROUTE_AS_PVT.process_route_operation_as');

2918: );
2919: END IF;
2920:
2921: IF (l_log_statement >= l_log_current_level) THEN
2922: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_OP_ROUTE_AS_PVT.process_route_operation_as');
2923: END IF;
2924:
2925: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
2926: IF (l_log_statement >= l_log_current_level) THEN

Line 2927: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OP_ROUTE_AS_PVT.process_route_operation_as Error');

2923: END IF;
2924:
2925: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
2926: IF (l_log_statement >= l_log_current_level) THEN
2927: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OP_ROUTE_AS_PVT.process_route_operation_as Error');
2928: END IF;
2929: RAISE FND_API.G_EXC_ERROR;
2930: END IF;
2931:

Line 2935: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OP_ROUTE_AS_PVT.process_route_operation_as -> association Successful');

2931:
2932: l_step_count := l_step_count + 1;
2933:
2934: IF (l_log_statement >= l_log_current_level) THEN
2935: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OP_ROUTE_AS_PVT.process_route_operation_as -> association Successful');
2936: END IF;
2937:
2938: END IF; -- Change Flag "C"
2939: END LOOP;

Line 3009: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3005: BEGIN
3006:
3007: x_return_status := FND_API.G_RET_STS_SUCCESS;
3008:
3009: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3010: THEN
3011:
3012: fnd_log.string
3013: (

Line 3012: fnd_log.string

3008:
3009: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3010: THEN
3011:
3012: fnd_log.string
3013: (
3014: fnd_log.level_statement,
3015: l_debug_module,
3016: 'inside UPLOAD_REVISION_REPORT->p_file_name->'||p_file_name

Line 3014: fnd_log.level_statement,

3010: THEN
3011:
3012: fnd_log.string
3013: (
3014: fnd_log.level_statement,
3015: l_debug_module,
3016: 'inside UPLOAD_REVISION_REPORT->p_file_name->'||p_file_name
3017: );
3018: END IF;

Line 3026: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

3022: FND_MESSAGE.set_name( 'AHL','AHL_COM_REQD_PARAM_MISSING' );
3023: FND_MSG_PUB.add;
3024: x_return_status := FND_API.G_RET_STS_ERROR;
3025:
3026: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3027: fnd_log.string
3028: (
3029: fnd_log.level_error,
3030: 'ahl.plsql.'||g_pkg_name||'.'||'upload_revision_report'||':',

Line 3027: fnd_log.string

3023: FND_MSG_PUB.add;
3024: x_return_status := FND_API.G_RET_STS_ERROR;
3025:
3026: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3027: fnd_log.string
3028: (
3029: fnd_log.level_error,
3030: 'ahl.plsql.'||g_pkg_name||'.'||'upload_revision_report'||':',
3031: 'Revision report file name is null'

Line 3029: fnd_log.level_error,

3025:
3026: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3027: fnd_log.string
3028: (
3029: fnd_log.level_error,
3030: 'ahl.plsql.'||g_pkg_name||'.'||'upload_revision_report'||':',
3031: 'Revision report file name is null'
3032: );
3033: END IF;