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.4.12020000.4 2013/01/03 09:30:43 arunjk ship $ */
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 69: fnd_log.string(fnd_log.level_procedure,'Get_Msg_Data','In Get_msg_data');

65: --
66:
67: BEGIN
68: IF (l_log_procedure >= l_log_current_level) THEN
69: fnd_log.string(fnd_log.level_procedure,'Get_Msg_Data','In Get_msg_data');
70: END IF;
71: l_msg_count := p_msg_count;
72: IF (l_msg_count IS NULL)THEN
73: RETURN NULL;

Line 89: fnd_log.string(fnd_log.level_procedure,'Get_Msg_Data','msg ' || l_temp_msg_data);

85: p_encoded => FND_API.G_FALSE,
86: p_data => l_temp_msg_data,
87: p_msg_index_out => l_msg_index_out);
88: IF (l_log_procedure >= l_log_current_level) THEN
89: fnd_log.string(fnd_log.level_procedure,'Get_Msg_Data','msg ' || l_temp_msg_data);
90: END IF;
91: IF (i = 1) THEN
92: l_msg_data := l_temp_msg_data;
93: ELSE

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

211: --fnd_global.APPS_INITIALIZE (1003259,62211, 867);
212:
213: -- Log API entry point
214: IF (l_log_procedure >= l_log_current_level) THEN
215: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');
216: END IF;
217:
218: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
219: fnd_log.string(fnd_log.level_procedure,l_debug_module ||'.begin','Inside Process_Route_Operations');

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

214: IF (l_log_procedure >= l_log_current_level) THEN
215: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');
216: END IF;
217:
218: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
219: fnd_log.string(fnd_log.level_procedure,l_debug_module ||'.begin','Inside Process_Route_Operations');
220: END IF;
221:
222: -- Check if the route is found in the staging table

Line 219: fnd_log.string(fnd_log.level_procedure,l_debug_module ||'.begin','Inside Process_Route_Operations');

215: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');
216: END IF;
217:
218: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
219: fnd_log.string(fnd_log.level_procedure,l_debug_module ||'.begin','Inside Process_Route_Operations');
220: END IF;
221:
222: -- Check if the route is found in the staging table
223: -- Then , query and get all the routes from the staging table which are in status pending.

Line 224: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

220: END IF;
221:
222: -- Check if the route is found in the staging table
223: -- Then , query and get all the routes from the staging table which are in status pending.
224: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
225: fnd_log.string(fnd_log.level_statement,l_debug_module,'Polling for pending routes');
226: END IF;
227:
228: --snarkhed::ENigma Phase II change in the interface logic

Line 225: fnd_log.string(fnd_log.level_statement,l_debug_module,'Polling for pending routes');

221:
222: -- Check if the route is found in the staging table
223: -- Then , query and get all the routes from the staging table which are in status pending.
224: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
225: fnd_log.string(fnd_log.level_statement,l_debug_module,'Polling for pending routes');
226: END IF;
227:
228: --snarkhed::ENigma Phase II change in the interface logic
229: SELECT sysdate INTO timebefore from dual;

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

319: --Phase II changes end
320:
321: EXIT WHEN get_route_data%NOTFOUND;
322:
323: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
324: THEN
325: fnd_log.string
326: (
327: fnd_log.level_statement,

Line 325: fnd_log.string

321: EXIT WHEN get_route_data%NOTFOUND;
322:
323: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
324: THEN
325: fnd_log.string
326: (
327: fnd_log.level_statement,
328: l_debug_module,
329: 'Pending Routes found in staging table'

Line 327: fnd_log.level_statement,

323: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
324: THEN
325: fnd_log.string
326: (
327: fnd_log.level_statement,
328: l_debug_module,
329: 'Pending Routes found in staging table'
330: );
331: END IF;

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

346: CLOSE get_oper_data;
347: -- Enigma Phase II changes end
348:
349: IF (l_log_statement >= l_log_current_level) THEN
350: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling PROCESS_ROUTE_DETAILS');
351: END IF;
352:
353: -- Delete all the routes in pending status from the stagin table
354: -- as they have already been queried by the cursor

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

359:
360: DELETE FROM AHL_RT_OPER_INTERFACE
361: WHERE PARENT_ENIGMA_ROUTE_ID = l_enigma_route_id AND STATUS = 'PENDING';
362:
363: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
364: THEN
365: fnd_log.string
366: (
367: fnd_log.level_statement,

Line 365: fnd_log.string

361: WHERE PARENT_ENIGMA_ROUTE_ID = l_enigma_route_id AND STATUS = 'PENDING';
362:
363: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
364: THEN
365: fnd_log.string
366: (
367: fnd_log.level_statement,
368: l_debug_module,
369: 'before calling process_route_details'

Line 367: fnd_log.level_statement,

363: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
364: THEN
365: fnd_log.string
366: (
367: fnd_log.level_statement,
368: l_debug_module,
369: 'before calling process_route_details'
370: );
371: fnd_log.string

Line 371: fnd_log.string

367: fnd_log.level_statement,
368: l_debug_module,
369: 'before calling process_route_details'
370: );
371: fnd_log.string
372: (
373: fnd_log.level_statement,
374: l_debug_module,
375: 'l_route_data_rec.enigma_route_id -> '|| l_route_data_rec.enigma_route_id

Line 373: fnd_log.level_statement,

369: 'before calling process_route_details'
370: );
371: fnd_log.string
372: (
373: fnd_log.level_statement,
374: l_debug_module,
375: 'l_route_data_rec.enigma_route_id -> '|| l_route_data_rec.enigma_route_id
376: );
377: END IF;

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

393: p_context,
394: p_pub_date
395: );
396:
397: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
398: THEN
399: fnd_log.string
400: (
401: fnd_log.level_statement,

Line 399: fnd_log.string

395: );
396:
397: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
398: THEN
399: fnd_log.string
400: (
401: fnd_log.level_statement,
402: l_debug_module,
403: 'after calling process_route_details'

Line 401: fnd_log.level_statement,

397: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
398: THEN
399: fnd_log.string
400: (
401: fnd_log.level_statement,
402: l_debug_module,
403: 'after calling process_route_details'
404: );
405: END IF;

Line 414: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

410: DELETE FROM AHL_RT_OPER_INTERFACE
411: WHERE STATUS = 'PENDING' AND PARENT_enigma_route_id IS NULL;*/
412:
413:
414: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
415: fnd_log.string(fnd_log.level_statement,l_debug_module,'Dumping all the paramters...');
416: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_api_version -> '||p_api_version);
417: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_init_msg_list -> '||p_init_msg_list);
418: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_commit -> '||p_commit);

Line 415: fnd_log.string(fnd_log.level_statement,l_debug_module,'Dumping all the paramters...');

411: WHERE STATUS = 'PENDING' AND PARENT_enigma_route_id IS NULL;*/
412:
413:
414: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
415: fnd_log.string(fnd_log.level_statement,l_debug_module,'Dumping all the paramters...');
416: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_api_version -> '||p_api_version);
417: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_init_msg_list -> '||p_init_msg_list);
418: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_commit -> '||p_commit);
419: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_validation_level -> '||p_validation_level);

Line 416: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_api_version -> '||p_api_version);

412:
413:
414: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
415: fnd_log.string(fnd_log.level_statement,l_debug_module,'Dumping all the paramters...');
416: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_api_version -> '||p_api_version);
417: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_init_msg_list -> '||p_init_msg_list);
418: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_commit -> '||p_commit);
419: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_validation_level -> '||p_validation_level);
420: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_module_type -> '||p_module_type);

Line 417: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_init_msg_list -> '||p_init_msg_list);

413:
414: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
415: fnd_log.string(fnd_log.level_statement,l_debug_module,'Dumping all the paramters...');
416: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_api_version -> '||p_api_version);
417: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_init_msg_list -> '||p_init_msg_list);
418: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_commit -> '||p_commit);
419: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_validation_level -> '||p_validation_level);
420: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_module_type -> '||p_module_type);
421: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_context -> '||p_context);

Line 418: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_commit -> '||p_commit);

414: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
415: fnd_log.string(fnd_log.level_statement,l_debug_module,'Dumping all the paramters...');
416: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_api_version -> '||p_api_version);
417: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_init_msg_list -> '||p_init_msg_list);
418: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_commit -> '||p_commit);
419: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_validation_level -> '||p_validation_level);
420: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_module_type -> '||p_module_type);
421: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_context -> '||p_context);
422: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_pub_date -> '||p_pub_date);

Line 419: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_validation_level -> '||p_validation_level);

415: fnd_log.string(fnd_log.level_statement,l_debug_module,'Dumping all the paramters...');
416: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_api_version -> '||p_api_version);
417: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_init_msg_list -> '||p_init_msg_list);
418: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_commit -> '||p_commit);
419: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_validation_level -> '||p_validation_level);
420: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_module_type -> '||p_module_type);
421: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_context -> '||p_context);
422: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_pub_date -> '||p_pub_date);
423: END IF;

Line 420: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_module_type -> '||p_module_type);

416: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_api_version -> '||p_api_version);
417: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_init_msg_list -> '||p_init_msg_list);
418: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_commit -> '||p_commit);
419: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_validation_level -> '||p_validation_level);
420: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_module_type -> '||p_module_type);
421: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_context -> '||p_context);
422: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_pub_date -> '||p_pub_date);
423: END IF;
424:

Line 421: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_context -> '||p_context);

417: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_init_msg_list -> '||p_init_msg_list);
418: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_commit -> '||p_commit);
419: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_validation_level -> '||p_validation_level);
420: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_module_type -> '||p_module_type);
421: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_context -> '||p_context);
422: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_pub_date -> '||p_pub_date);
423: END IF;
424:
425: -- Process the incoming enigma record.

Line 422: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_pub_date -> '||p_pub_date);

418: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_commit -> '||p_commit);
419: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_validation_level -> '||p_validation_level);
420: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_module_type -> '||p_module_type);
421: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_context -> '||p_context);
422: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_pub_date -> '||p_pub_date);
423: END IF;
424:
425: -- Process the incoming enigma record.
426: -- Validate if the Enigma Route Id is null throw an error if the id is null.

Line 468: -- fnd_log.string(fnd_log.level_statement,l_debug_module,'Error in Process_OP_Details');

464: END IF;
465: -- x_msg_count := FND_MSG_PUB.count_msg;
466: -- IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS OR x_msg_count > 0) THEN
467: -- IF (l_log_statement >= l_log_current_level) THEN
468: -- fnd_log.string(fnd_log.level_statement,l_debug_module,'Error in Process_OP_Details');
469: -- END IF;
470: -- RAISE FND_API.G_EXC_ERROR;
471: -- END IF;
472: -- END IF;

Line 503: -- fnd_log.string(fnd_log.level_statement,l_debug_module,'Error in PROCESS_ROUTE_DETAILS');

499: END IF;
500: -- x_msg_count := FND_MSG_PUB.count_msg;
501: -- IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
502: -- IF (l_log_statement >= l_log_current_level OR x_msg_count > 0) THEN
503: -- fnd_log.string(fnd_log.level_statement,l_debug_module,'Error in PROCESS_ROUTE_DETAILS');
504: -- END IF;
505: -- RAISE FND_API.G_EXC_ERROR;
506: -- END IF;
507: END LOOP;

Line 509: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

505: -- RAISE FND_API.G_EXC_ERROR;
506: -- END IF;
507: END LOOP;
508:
509: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
510: fnd_log.string(fnd_log.level_statement,l_debug_module,'After process calls...');
511: END IF;
512:
513:

Line 510: fnd_log.string(fnd_log.level_statement,l_debug_module,'After process calls...');

506: -- END IF;
507: END LOOP;
508:
509: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
510: fnd_log.string(fnd_log.level_statement,l_debug_module,'After process calls...');
511: END IF;
512:
513:
514: -- Check Error Message stack.

Line 517: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

513:
514: -- Check Error Message stack.
515: -- x_msg_count := FND_MSG_PUB.count_msg;
516:
517: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
518: fnd_log.string(fnd_log.level_statement,l_debug_module,'After get_message_data... ' || x_msg_data);
519: END IF;
520:
521: IF (no_records > 0) THEN

Line 518: fnd_log.string(fnd_log.level_statement,l_debug_module,'After get_message_data... ' || x_msg_data);

514: -- Check Error Message stack.
515: -- x_msg_count := FND_MSG_PUB.count_msg;
516:
517: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
518: fnd_log.string(fnd_log.level_statement,l_debug_module,'After get_message_data... ' || x_msg_data);
519: END IF;
520:
521: IF (no_records > 0) THEN
522: x_return_status := FND_API.G_RET_STS_ERROR;

Line 583: fnd_log.string(fnd_log.level_statement,l_debug_module,'In Map_Enigma_To_CMRO_Route_Rec');

579: l_debug_module CONSTANT VARCHAR2(100) := 'AHL.PLSQL.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||'MAP_ENIGMA_TO_CMRO_ROUTE_REC';
580:
581: BEGIN
582: IF (l_log_statement >= l_log_current_level) THEN
583: fnd_log.string(fnd_log.level_statement,l_debug_module,'In Map_Enigma_To_CMRO_Route_Rec');
584: END IF;
585: IF (p_enigma_route_rec.dml_operation <> 'C' AND p_route_id <> FND_API.G_MISS_NUM AND p_route_id IS NOT NULL) THEN
586: x_process_route_input_rec.route_id := p_route_id;
587: END IF;

Line 601: fnd_log.string(fnd_log.level_statement,l_debug_module,'After UPLOAD_REVISION_REPORT Call File Id -> = ' || x_file_id);

597: x_return_status
598: );
599: END IF;
600: IF (l_log_statement >= l_log_current_level) THEN
601: fnd_log.string(fnd_log.level_statement,l_debug_module,'After UPLOAD_REVISION_REPORT Call File Id -> = ' || x_file_id);
602: END IF;
603: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
604: IF (l_log_statement >= l_log_current_level) THEN
605: fnd_log.string(fnd_log.level_statement,l_debug_module,'UPLOAD_REVISION_REPORT Error');

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

601: fnd_log.string(fnd_log.level_statement,l_debug_module,'After UPLOAD_REVISION_REPORT Call File Id -> = ' || x_file_id);
602: END IF;
603: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
604: IF (l_log_statement >= l_log_current_level) THEN
605: fnd_log.string(fnd_log.level_statement,l_debug_module,'UPLOAD_REVISION_REPORT Error');
606: END IF;
607: RAISE FND_API.G_EXC_ERROR;
608: END IF;
609: -- If the return status is success, populate the input rec for process_route for updation

Line 640: fnd_log.string(fnd_log.level_statement,l_debug_module,'End of Map_Enigma_To_CMRO_Route_Rec');

636: x_process_route_input_rec.route_no := p_enigma_route_rec.ata_code;
637: END IF;
638: x_process_route_input_rec.dml_operation := p_enigma_route_rec.dml_operation;
639: IF (l_log_statement >= l_log_current_level) THEN
640: fnd_log.string(fnd_log.level_statement,l_debug_module,'End of Map_Enigma_To_CMRO_Route_Rec');
641: END IF;
642: END Map_Enigma_To_CMRO_Route_Rec;
643:
644: PROCEDURE Update_Route_Interface_table

Line 657: fnd_log.string(fnd_log.level_statement,l_debug_module,'Before Inserting into interface table');

653: l_debug_module CONSTANT VARCHAR2(100) := 'AHL.PLSQL.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||'Update_Route_Interface_table';
654:
655: BEGIN
656: IF (l_log_statement >= l_log_current_level) THEN
657: fnd_log.string(fnd_log.level_statement,l_debug_module,'Before Inserting into interface table');
658: fnd_log.string(fnd_log.level_statement,l_debug_module,' reason: ' || p_reason);
659: END IF;
660:
661: INSERT INTO AHL_ENIGMA_RT_INTERFACE

Line 658: fnd_log.string(fnd_log.level_statement,l_debug_module,' reason: ' || p_reason);

654:
655: BEGIN
656: IF (l_log_statement >= l_log_current_level) THEN
657: fnd_log.string(fnd_log.level_statement,l_debug_module,'Before Inserting into interface table');
658: fnd_log.string(fnd_log.level_statement,l_debug_module,' reason: ' || p_reason);
659: END IF;
660:
661: INSERT INTO AHL_ENIGMA_RT_INTERFACE
662: (

Line 692: fnd_log.string(fnd_log.level_statement,l_debug_module,'After Inserting into interface table');

688: sysdate,
689: p_isrecoverable
690: );
691: IF (l_log_statement >= l_log_current_level) THEN
692: fnd_log.string(fnd_log.level_statement,l_debug_module,'After Inserting into interface table');
693: END IF;
694: END Update_Route_Interface_table;
695:
696: PROCEDURE process_rt_op_assoc

Line 762: fnd_log.string(fnd_log.level_statement,l_debug_module,'In process_rt_op_assoc Route Id ' || p_route_id);

758:
759: BEGIN
760: x_return_status:= FND_API.G_RET_STS_SUCCESS;
761: IF (l_log_statement >= l_log_current_level) THEN
762: fnd_log.string(fnd_log.level_statement,l_debug_module,'In process_rt_op_assoc Route Id ' || p_route_id);
763: END IF;
764: -- change = 0 : Delete
765: -- change = 1 : Retained
766: -- change = 2 : New Addition

Line 799: fnd_log.string(fnd_log.level_statement,l_debug_module,'Associated Operation Not Found:: ' || p_enigma_op_asso_tbl(l_new_ctr));

795: CLOSE get_op_id;
796: -- If no operation found with the passed enigma_op_id then throw an error.
797: IF l_last_ctr = l_ctr THEN
798: IF (l_log_statement >= l_log_current_level) THEN
799: fnd_log.string(fnd_log.level_statement,l_debug_module,'Associated Operation Not Found:: ' || p_enigma_op_asso_tbl(l_new_ctr));
800: END IF;
801: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_OP_DONOT_EXIST');
802: FND_MESSAGE.SET_TOKEN('FIELD', p_enigma_op_asso_tbl(l_new_ctr));
803: FND_MSG_PUB.ADD;

Line 858: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling private API. Count:: ' || l_route_op_asso_table.COUNT);

854: END IF;
855: END LOOP;
856:
857: IF (l_log_statement >= l_log_current_level) THEN
858: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling private API. Count:: ' || l_route_op_asso_table.COUNT);
859: END IF;
860:
861: IF (l_route_op_asso_table.COUNT > 0) THEN
862: AHL_RM_OP_ROUTE_AS_PVT.process_route_operation_as

Line 880: fnd_log.string(fnd_log.level_statement,l_debug_module,'Error in Process Association');

876: END IF;
877:
878: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
879: IF (l_log_statement >= l_log_current_level) THEN
880: fnd_log.string(fnd_log.level_statement,l_debug_module,'Error in Process Association');
881: END IF;
882: RAISE FND_API.G_EXC_ERROR;
883: END IF;
884:

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

970: END IF;
971:
972: -- Log API entry point
973: IF (l_log_procedure >= l_log_current_level) THEN
974: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');
975: END IF;
976: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
977: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.enigma_route_id -> '||p_enigma_route_rec.enigma_route_id);
978: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.DML_OPERATION -> '||p_enigma_route_rec.DML_OPERATION);

Line 976: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

972: -- Log API entry point
973: IF (l_log_procedure >= l_log_current_level) THEN
974: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');
975: END IF;
976: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
977: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.enigma_route_id -> '||p_enigma_route_rec.enigma_route_id);
978: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.DML_OPERATION -> '||p_enigma_route_rec.DML_OPERATION);
979: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.ATA_CODE-> '||p_enigma_route_rec.ATA_CODE);
980: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.DESCRIPTION-> '||p_enigma_route_rec.DESCRIPTION);

Line 977: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.enigma_route_id -> '||p_enigma_route_rec.enigma_route_id);

973: IF (l_log_procedure >= l_log_current_level) THEN
974: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');
975: END IF;
976: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
977: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.enigma_route_id -> '||p_enigma_route_rec.enigma_route_id);
978: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.DML_OPERATION -> '||p_enigma_route_rec.DML_OPERATION);
979: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.ATA_CODE-> '||p_enigma_route_rec.ATA_CODE);
980: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.DESCRIPTION-> '||p_enigma_route_rec.DESCRIPTION);
981: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.REVISION_DATE-> '||p_enigma_route_rec.REVISION_DATE);

Line 978: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.DML_OPERATION -> '||p_enigma_route_rec.DML_OPERATION);

974: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');
975: END IF;
976: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
977: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.enigma_route_id -> '||p_enigma_route_rec.enigma_route_id);
978: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.DML_OPERATION -> '||p_enigma_route_rec.DML_OPERATION);
979: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.ATA_CODE-> '||p_enigma_route_rec.ATA_CODE);
980: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.DESCRIPTION-> '||p_enigma_route_rec.DESCRIPTION);
981: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.REVISION_DATE-> '||p_enigma_route_rec.REVISION_DATE);
982: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.PDF_FILE_NAME-> '||p_enigma_route_rec.PDF_FILE_NAME);

Line 979: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.ATA_CODE-> '||p_enigma_route_rec.ATA_CODE);

975: END IF;
976: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
977: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.enigma_route_id -> '||p_enigma_route_rec.enigma_route_id);
978: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.DML_OPERATION -> '||p_enigma_route_rec.DML_OPERATION);
979: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.ATA_CODE-> '||p_enigma_route_rec.ATA_CODE);
980: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.DESCRIPTION-> '||p_enigma_route_rec.DESCRIPTION);
981: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.REVISION_DATE-> '||p_enigma_route_rec.REVISION_DATE);
982: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.PDF_FILE_NAME-> '||p_enigma_route_rec.PDF_FILE_NAME);
983: END IF;

Line 980: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.DESCRIPTION-> '||p_enigma_route_rec.DESCRIPTION);

976: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
977: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.enigma_route_id -> '||p_enigma_route_rec.enigma_route_id);
978: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.DML_OPERATION -> '||p_enigma_route_rec.DML_OPERATION);
979: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.ATA_CODE-> '||p_enigma_route_rec.ATA_CODE);
980: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.DESCRIPTION-> '||p_enigma_route_rec.DESCRIPTION);
981: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.REVISION_DATE-> '||p_enigma_route_rec.REVISION_DATE);
982: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.PDF_FILE_NAME-> '||p_enigma_route_rec.PDF_FILE_NAME);
983: END IF;
984:

Line 981: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.REVISION_DATE-> '||p_enigma_route_rec.REVISION_DATE);

977: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.enigma_route_id -> '||p_enigma_route_rec.enigma_route_id);
978: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.DML_OPERATION -> '||p_enigma_route_rec.DML_OPERATION);
979: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.ATA_CODE-> '||p_enigma_route_rec.ATA_CODE);
980: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.DESCRIPTION-> '||p_enigma_route_rec.DESCRIPTION);
981: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.REVISION_DATE-> '||p_enigma_route_rec.REVISION_DATE);
982: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.PDF_FILE_NAME-> '||p_enigma_route_rec.PDF_FILE_NAME);
983: END IF;
984:
985: -- validations::Verify if the Change flag is right

Line 982: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.PDF_FILE_NAME-> '||p_enigma_route_rec.PDF_FILE_NAME);

978: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.DML_OPERATION -> '||p_enigma_route_rec.DML_OPERATION);
979: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.ATA_CODE-> '||p_enigma_route_rec.ATA_CODE);
980: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.DESCRIPTION-> '||p_enigma_route_rec.DESCRIPTION);
981: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.REVISION_DATE-> '||p_enigma_route_rec.REVISION_DATE);
982: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling from BPEL service Parameters p_enigma_route_rec.PDF_FILE_NAME-> '||p_enigma_route_rec.PDF_FILE_NAME);
983: END IF;
984:
985: -- validations::Verify if the Change flag is right
986: IF (p_enigma_route_rec.DML_OPERATION NOT IN ( 'C', 'D', 'U','NC'))

Line 1018: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1014: END IF;
1015: CLOSE get_latest_route_rev;
1016: END IF;
1017:
1018: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1019: fnd_log.string(fnd_log.level_statement,l_debug_module,'Route Latest Revision Details..');
1020: fnd_log.string(fnd_log.level_statement,l_debug_module,'Route Latest Revision Details..Route Id: ' || l_get_latest_route_rev.route_id ||
1021: ' Revision Status ' || l_get_latest_route_rev.revision_status ||
1022: ' DML_FLAG ' || p_enigma_route_rec.DML_OPERATION ||

Line 1019: fnd_log.string(fnd_log.level_statement,l_debug_module,'Route Latest Revision Details..');

1015: CLOSE get_latest_route_rev;
1016: END IF;
1017:
1018: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1019: fnd_log.string(fnd_log.level_statement,l_debug_module,'Route Latest Revision Details..');
1020: fnd_log.string(fnd_log.level_statement,l_debug_module,'Route Latest Revision Details..Route Id: ' || l_get_latest_route_rev.route_id ||
1021: ' Revision Status ' || l_get_latest_route_rev.revision_status ||
1022: ' DML_FLAG ' || p_enigma_route_rec.DML_OPERATION ||
1023: ' OVN ' || l_get_latest_route_rev.object_version_number

Line 1020: fnd_log.string(fnd_log.level_statement,l_debug_module,'Route Latest Revision Details..Route Id: ' || l_get_latest_route_rev.route_id ||

1016: END IF;
1017:
1018: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1019: fnd_log.string(fnd_log.level_statement,l_debug_module,'Route Latest Revision Details..');
1020: fnd_log.string(fnd_log.level_statement,l_debug_module,'Route Latest Revision Details..Route Id: ' || l_get_latest_route_rev.route_id ||
1021: ' Revision Status ' || l_get_latest_route_rev.revision_status ||
1022: ' DML_FLAG ' || p_enigma_route_rec.DML_OPERATION ||
1023: ' OVN ' || l_get_latest_route_rev.object_version_number
1024: );

Line 1059: fnd_log.string(fnd_log.level_statement,l_debug_module,'After UPLOAD_REVISION_REPORT Call File Id -> = ' || x_file_id);

1055: x_return_status
1056: );
1057: END IF;
1058: IF (l_log_statement >= l_log_current_level) THEN
1059: fnd_log.string(fnd_log.level_statement,l_debug_module,'After UPLOAD_REVISION_REPORT Call File Id -> = ' || x_file_id);
1060: END IF;
1061: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1062: IF (l_log_statement >= l_log_current_level) THEN
1063: fnd_log.string(fnd_log.level_statement,l_debug_module,'UPLOAD_REVISION_REPORT Error');

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

1059: fnd_log.string(fnd_log.level_statement,l_debug_module,'After UPLOAD_REVISION_REPORT Call File Id -> = ' || x_file_id);
1060: END IF;
1061: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1062: IF (l_log_statement >= l_log_current_level) THEN
1063: fnd_log.string(fnd_log.level_statement,l_debug_module,'UPLOAD_REVISION_REPORT Error');
1064: END IF;
1065: RAISE FND_API.G_EXC_ERROR;
1066: END IF;
1067: -- If the return status is success, populate the input rec for process_route for updation

Line 1086: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1082: x_msg_count,
1083: x_msg_data,
1084: p_process_route_input_rec
1085: );
1086: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1087: fnd_log.string(fnd_log.level_statement,l_debug_module,'After calling process_route in update mode x_return_status -> ' || x_return_status);
1088: END IF;
1089:
1090: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN

Line 1087: fnd_log.string(fnd_log.level_statement,l_debug_module,'After calling process_route in update mode x_return_status -> ' || x_return_status);

1083: x_msg_data,
1084: p_process_route_input_rec
1085: );
1086: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1087: fnd_log.string(fnd_log.level_statement,l_debug_module,'After calling process_route in update mode x_return_status -> ' || x_return_status);
1088: END IF;
1089:
1090: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1091: IF (l_log_statement >= l_log_current_level) THEN

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

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

Line 1148: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1144: l_get_latest_route_rev.route_id,
1145: l_get_latest_route_rev.object_version_number
1146: );
1147:
1148: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1149: fnd_log.string(fnd_log.level_statement,l_debug_module,'After calling delete_routes..Return Status: ' || x_return_status);
1150: END IF;
1151:
1152: -- Check the return status , and if the status is not success , then raise an error

Line 1149: fnd_log.string(fnd_log.level_statement,l_debug_module,'After calling delete_routes..Return Status: ' || x_return_status);

1145: l_get_latest_route_rev.object_version_number
1146: );
1147:
1148: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1149: fnd_log.string(fnd_log.level_statement,l_debug_module,'After calling delete_routes..Return Status: ' || x_return_status);
1150: END IF;
1151:
1152: -- Check the return status , and if the status is not success , then raise an error
1153: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN

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

1151:
1152: -- Check the return status , and if the status is not success , then raise an error
1153: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1154: IF (l_log_statement >= l_log_current_level) THEN
1155: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.delete_route Error');
1156: END IF;
1157: /*Update_Route_Interface_table
1158: (
1159: p_enigma_route_rec,

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

1183: );*/
1184:
1185: -- If the route has any assocaited operations, add them also to the stating table marking the status as pending.
1186: /*IF ( p_enigma_route_rec.op_asso_tbl.COUNT > 0) THEN
1187: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1188: fnd_log.string(fnd_log.level_statement,l_debug_module,'Operations Attached No: ' || p_enigma_route_rec.op_asso_tbl.COUNT);
1189: END IF;
1190: FOR i IN p_enigma_route_rec.op_asso_tbl.FIRST..p_enigma_route_rec.op_asso_tbl.LAST
1191: LOOP

Line 1188: fnd_log.string(fnd_log.level_statement,l_debug_module,'Operations Attached No: ' || p_enigma_route_rec.op_asso_tbl.COUNT);

1184:
1185: -- If the route has any assocaited operations, add them also to the stating table marking the status as pending.
1186: /*IF ( p_enigma_route_rec.op_asso_tbl.COUNT > 0) THEN
1187: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1188: fnd_log.string(fnd_log.level_statement,l_debug_module,'Operations Attached No: ' || p_enigma_route_rec.op_asso_tbl.COUNT);
1189: END IF;
1190: FOR i IN p_enigma_route_rec.op_asso_tbl.FIRST..p_enigma_route_rec.op_asso_tbl.LAST
1191: LOOP
1192: INSERT INTO AHL_RT_OPER_INTERFACE

Line 1238: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1234: l_get_latest_route_rev.object_version_number,
1235: x_route_id
1236: );
1237:
1238: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1239: fnd_log.string(fnd_log.level_statement,l_debug_module,'After calling create_route_revision..Return Status: ' || x_return_status || ' New Route Id: ' || x_route_id);
1240: END IF;
1241:
1242: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN

Line 1239: fnd_log.string(fnd_log.level_statement,l_debug_module,'After calling create_route_revision..Return Status: ' || x_return_status || ' New Route Id: ' || x_route_id);

1235: x_route_id
1236: );
1237:
1238: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1239: fnd_log.string(fnd_log.level_statement,l_debug_module,'After calling create_route_revision..Return Status: ' || x_return_status || ' New Route Id: ' || x_route_id);
1240: END IF;
1241:
1242: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1243: IF (l_log_statement >= l_log_current_level) THEN

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

1240: END IF;
1241:
1242: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1243: IF (l_log_statement >= l_log_current_level) THEN
1244: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.create_route_revision Error');
1245: END IF;
1246: /*Update_Route_Interface_table
1247: (
1248: p_enigma_route_rec,

Line 1272: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1268: p_pub_date
1269:
1270: );
1271:
1272: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1273: fnd_log.string(fnd_log.level_statement,l_debug_module,'Before calling process_route in update mode');
1274: END IF;
1275:
1276: -- Call the API for update

Line 1273: fnd_log.string(fnd_log.level_statement,l_debug_module,'Before calling process_route in update mode');

1269:
1270: );
1271:
1272: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1273: fnd_log.string(fnd_log.level_statement,l_debug_module,'Before calling process_route in update mode');
1274: END IF;
1275:
1276: -- Call the API for update
1277: AHL_RM_ROUTE_PVT.process_route

Line 1291: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1287: x_msg_data,
1288: p_process_route_input_rec
1289: );
1290:
1291: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1292: fnd_log.string(fnd_log.level_statement,l_debug_module,'After calling process_route in update mode x_return_status -> ' || x_return_status);
1293: END IF;
1294:
1295: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN

Line 1292: fnd_log.string(fnd_log.level_statement,l_debug_module,'After calling process_route in update mode x_return_status -> ' || x_return_status);

1288: p_process_route_input_rec
1289: );
1290:
1291: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1292: fnd_log.string(fnd_log.level_statement,l_debug_module,'After calling process_route in update mode x_return_status -> ' || x_return_status);
1293: END IF;
1294:
1295: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1296: IF (l_log_statement >= l_log_current_level) THEN

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

1293: END IF;
1294:
1295: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1296: IF (l_log_statement >= l_log_current_level) THEN
1297: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route Error');
1298: END IF;
1299: /*Update_Route_Interface_table
1300: (
1301: p_enigma_route_rec,

Line 1332: fnd_log.string(fnd_log.level_statement,l_debug_module,'process_route_operation_association Error');

1328: );
1329:
1330: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1331: IF (l_log_statement >= l_log_current_level) THEN
1332: fnd_log.string(fnd_log.level_statement,l_debug_module,'process_route_operation_association Error');
1333: END IF;
1334: /*Update_Route_Interface_table
1335: (
1336: p_enigma_route_rec,

Line 1373: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1369: x_msg_data,
1370: p_process_route_input_rec
1371: );
1372:
1373: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1374: fnd_log.string(fnd_log.level_statement,l_debug_module,'after calling process_route');
1375: END IF;
1376:
1377: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN

Line 1374: fnd_log.string(fnd_log.level_statement,l_debug_module,'after calling process_route');

1370: p_process_route_input_rec
1371: );
1372:
1373: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1374: fnd_log.string(fnd_log.level_statement,l_debug_module,'after calling process_route');
1375: END IF;
1376:
1377: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1378: IF (l_log_statement >= l_log_current_level) THEN

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

1375: END IF;
1376:
1377: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1378: IF (l_log_statement >= l_log_current_level) THEN
1379: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route Error');
1380: END IF;
1381: /*Update_Route_Interface_table
1382: (
1383: p_enigma_route_rec,

Line 1411: fnd_log.string(fnd_log.level_statement,l_debug_module,'process_route_operation_association Error');

1407: );
1408:
1409: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1410: IF (l_log_statement >= l_log_current_level) THEN
1411: fnd_log.string(fnd_log.level_statement,l_debug_module,'process_route_operation_association Error');
1412: END IF;
1413: /*Update_Route_Interface_table
1414: (
1415: p_enigma_route_rec,

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

1491: x_msg_count,
1492: x_msg_data,
1493: p_process_route_input_rec
1494: );
1495: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1496: fnd_log.string
1497: (fnd_log.level_statement,l_debug_module,'After Calling process_route in Create mode Route Id ' || p_process_route_input_rec.enigma_route_id);
1498: END IF;
1499:

Line 1496: fnd_log.string

1492: x_msg_data,
1493: p_process_route_input_rec
1494: );
1495: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1496: fnd_log.string
1497: (fnd_log.level_statement,l_debug_module,'After Calling process_route in Create mode Route Id ' || p_process_route_input_rec.enigma_route_id);
1498: END IF;
1499:
1500: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN

Line 1497: (fnd_log.level_statement,l_debug_module,'After Calling process_route in Create mode Route Id ' || p_process_route_input_rec.enigma_route_id);

1493: p_process_route_input_rec
1494: );
1495: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1496: fnd_log.string
1497: (fnd_log.level_statement,l_debug_module,'After Calling process_route in Create mode Route Id ' || p_process_route_input_rec.enigma_route_id);
1498: END IF;
1499:
1500: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1501: IF (l_log_statement >= l_log_current_level) THEN

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

1498: END IF;
1499:
1500: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1501: IF (l_log_statement >= l_log_current_level) THEN
1502: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route Error');
1503: END IF;
1504: /*Update_Route_Interface_table
1505: (
1506: p_enigma_route_rec,

Line 1536: fnd_log.string(fnd_log.level_statement,l_debug_module,'process_route_operation_association Error');

1532: p_process_route_input_rec.route_id
1533: );
1534: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1535: IF (l_log_statement >= l_log_current_level) THEN
1536: fnd_log.string(fnd_log.level_statement,l_debug_module,'process_route_operation_association Error');
1537: END IF;
1538: /*Update_Route_Interface_table
1539: (
1540: p_enigma_route_rec,

Line 1639: -- fnd_log.string(fnd_log.level_statement,l_debug_module,'Before Inserting into op interface table');

1635: l_debug_module CONSTANT VARCHAR2(100) := 'AHL.PLSQL.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||'Update_Op_Interface_table';
1636:
1637: BEGIN
1638: --IF (l_log_statement >= l_log_current_level) THEN
1639: -- fnd_log.string(fnd_log.level_statement,l_debug_module,'Before Inserting into op interface table');
1640: -- fnd_log.string(fnd_log.level_statement,l_debug_module,' reason: ' || p_reason);
1641: -- END IF;
1642:
1643: INSERT INTO AHL_ENIGMA_OP_INTERFACE

Line 1640: -- fnd_log.string(fnd_log.level_statement,l_debug_module,' reason: ' || p_reason);

1636:
1637: BEGIN
1638: --IF (l_log_statement >= l_log_current_level) THEN
1639: -- fnd_log.string(fnd_log.level_statement,l_debug_module,'Before Inserting into op interface table');
1640: -- fnd_log.string(fnd_log.level_statement,l_debug_module,' reason: ' || p_reason);
1641: -- END IF;
1642:
1643: INSERT INTO AHL_ENIGMA_OP_INTERFACE
1644: (

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

1763: --fnd_global.APPS_INITIALIZE (1003259,62211, 867);
1764:
1765: -- Log API entry point
1766: IF (l_log_procedure >= l_log_current_level) THEN
1767: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');
1768: END IF;
1769:
1770: -- Check for operations,If so process them depending on their change flag .
1771:

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

1769:
1770: -- Check for operations,If so process them depending on their change flag .
1771:
1772:
1773: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1774: THEN
1775: fnd_log.string(fnd_log.level_statement,l_debug_module,'Inside Process_OP_Details -> Operations Found');
1776: END IF;
1777:

Line 1775: fnd_log.string(fnd_log.level_statement,l_debug_module,'Inside Process_OP_Details -> Operations Found');

1771:
1772:
1773: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1774: THEN
1775: fnd_log.string(fnd_log.level_statement,l_debug_module,'Inside Process_OP_Details -> Operations Found');
1776: END IF;
1777:
1778: -- Verify if the Change flag is right...
1779: IF (p_enigma_op_rec.DML_OPERATION NOT IN ( 'C', 'D', 'U'))

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

1784: FND_MSG_PUB.ADD;
1785: RAISE FND_API.G_EXC_ERROR;
1786: END IF;
1787:
1788: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1789: THEN
1790: fnd_log.string(fnd_log.level_statement,l_debug_module,'Change Flag set right');
1791: END IF;
1792:

Line 1790: fnd_log.string(fnd_log.level_statement,l_debug_module,'Change Flag set right');

1786: END IF;
1787:
1788: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1789: THEN
1790: fnd_log.string(fnd_log.level_statement,l_debug_module,'Change Flag set right');
1791: END IF;
1792:
1793: -- If the change flag is C then create a new operation.
1794: IF (p_enigma_op_rec.DML_OPERATION = 'C') THEN

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

1792:
1793: -- If the change flag is C then create a new operation.
1794: IF (p_enigma_op_rec.DML_OPERATION = 'C') THEN
1795:
1796: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1797: THEN
1798: fnd_log.string(fnd_log.level_statement,l_debug_module,'Inside Process_OP_Details -> Inside Create Operation ');
1799: END IF;
1800:

Line 1798: fnd_log.string(fnd_log.level_statement,l_debug_module,'Inside Process_OP_Details -> Inside Create Operation ');

1794: IF (p_enigma_op_rec.DML_OPERATION = 'C') THEN
1795:
1796: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1797: THEN
1798: fnd_log.string(fnd_log.level_statement,l_debug_module,'Inside Process_OP_Details -> Inside Create Operation ');
1799: END IF;
1800:
1801: -- Validating ALL Mandatory Fields.
1802:

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

1912:
1913: p_process_oper_input_rec.DML_OPERATION := 'C';
1914: p_process_oper_input_rec.STANDARD_OPERATION_FLAG := 'Y';
1915:
1916: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1917: THEN
1918: fnd_log.string(fnd_log.level_statement,l_debug_module,'Inside Process_OP_Details calling process_operations');
1919: END IF;
1920:

Line 1918: fnd_log.string(fnd_log.level_statement,l_debug_module,'Inside Process_OP_Details calling process_operations');

1914: p_process_oper_input_rec.STANDARD_OPERATION_FLAG := 'Y';
1915:
1916: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1917: THEN
1918: fnd_log.string(fnd_log.level_statement,l_debug_module,'Inside Process_OP_Details calling process_operations');
1919: END IF;
1920:
1921: -- Call the API for update
1922: AHL_RM_OPERATION_PVT.process_operation

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

1935:
1936: x_operation_id := p_process_oper_input_rec.operation_id;
1937: x_revision_number := p_process_oper_input_rec.REVISION_NUMBER;
1938:
1939: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1940: THEN
1941: fnd_log.string(fnd_log.level_statement,l_debug_module,'Operation Created ->' || x_operation_id);
1942: fnd_log.string(fnd_log.level_statement,l_debug_module,'Operation Created Revision->' || x_revision_number);
1943: fnd_log.string(fnd_log.level_statement,l_debug_module,'Process_OP_Details after calling process_operations');

Line 1941: fnd_log.string(fnd_log.level_statement,l_debug_module,'Operation Created ->' || x_operation_id);

1937: x_revision_number := p_process_oper_input_rec.REVISION_NUMBER;
1938:
1939: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1940: THEN
1941: fnd_log.string(fnd_log.level_statement,l_debug_module,'Operation Created ->' || x_operation_id);
1942: fnd_log.string(fnd_log.level_statement,l_debug_module,'Operation Created Revision->' || x_revision_number);
1943: fnd_log.string(fnd_log.level_statement,l_debug_module,'Process_OP_Details after calling process_operations');
1944: END IF;
1945:

Line 1942: fnd_log.string(fnd_log.level_statement,l_debug_module,'Operation Created Revision->' || x_revision_number);

1938:
1939: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1940: THEN
1941: fnd_log.string(fnd_log.level_statement,l_debug_module,'Operation Created ->' || x_operation_id);
1942: fnd_log.string(fnd_log.level_statement,l_debug_module,'Operation Created Revision->' || x_revision_number);
1943: fnd_log.string(fnd_log.level_statement,l_debug_module,'Process_OP_Details after calling process_operations');
1944: END IF;
1945:
1946: IF (l_log_statement >= l_log_current_level) THEN

Line 1943: fnd_log.string(fnd_log.level_statement,l_debug_module,'Process_OP_Details after calling process_operations');

1939: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1940: THEN
1941: fnd_log.string(fnd_log.level_statement,l_debug_module,'Operation Created ->' || x_operation_id);
1942: fnd_log.string(fnd_log.level_statement,l_debug_module,'Operation Created Revision->' || x_revision_number);
1943: fnd_log.string(fnd_log.level_statement,l_debug_module,'Process_OP_Details after calling process_operations');
1944: END IF;
1945:
1946: IF (l_log_statement >= l_log_current_level) THEN
1947: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_OPERATION_PVT.process_operation');

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

1943: fnd_log.string(fnd_log.level_statement,l_debug_module,'Process_OP_Details after calling process_operations');
1944: END IF;
1945:
1946: IF (l_log_statement >= l_log_current_level) THEN
1947: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_OPERATION_PVT.process_operation');
1948: END IF;
1949:
1950: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1951: IF (l_log_statement >= l_log_current_level) THEN

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

1948: END IF;
1949:
1950: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1951: IF (l_log_statement >= l_log_current_level) THEN
1952: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation Error');
1953: END IF;
1954: RAISE FND_API.G_EXC_ERROR;
1955: END IF;
1956:

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

1954: RAISE FND_API.G_EXC_ERROR;
1955: END IF;
1956:
1957: IF (l_log_statement >= l_log_current_level) THEN
1958: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation -> creation Successful');
1959: END IF;
1960:
1961: /*IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1962: THEN

Line 1961: /*IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1957: IF (l_log_statement >= l_log_current_level) THEN
1958: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation -> creation Successful');
1959: END IF;
1960:
1961: /*IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1962: THEN
1963: fnd_log.string(fnd_log.level_statement,l_debug_module,'before inserting the operations into staging table ');
1964: END IF;
1965:

Line 1963: fnd_log.string(fnd_log.level_statement,l_debug_module,'before inserting the operations into staging table ');

1959: END IF;
1960:
1961: /*IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1962: THEN
1963: fnd_log.string(fnd_log.level_statement,l_debug_module,'before inserting the operations into staging table ');
1964: END IF;
1965:
1966: -- Insert the transaction record into the staging table, with status as success
1967: OP_interface_insert_row(

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

1976: );*/
1977: -- If the operation change flag is "U" then process the operation accordingly .
1978: ELSIF (p_enigma_op_rec.DML_OPERATION = 'U') THEN
1979:
1980: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1981: THEN
1982: fnd_log.string(fnd_log.level_statement,l_debug_module,'Operation Flag is U');
1983: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_enigma_op_rec.operation_id -> ' || p_enigma_op_rec.ENIGMA_OP_ID);
1984: END IF;

Line 1982: fnd_log.string(fnd_log.level_statement,l_debug_module,'Operation Flag is U');

1978: ELSIF (p_enigma_op_rec.DML_OPERATION = 'U') THEN
1979:
1980: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1981: THEN
1982: fnd_log.string(fnd_log.level_statement,l_debug_module,'Operation Flag is U');
1983: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_enigma_op_rec.operation_id -> ' || p_enigma_op_rec.ENIGMA_OP_ID);
1984: END IF;
1985:
1986: l_get_latest_oper_rev := NULL;

Line 1983: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_enigma_op_rec.operation_id -> ' || p_enigma_op_rec.ENIGMA_OP_ID);

1979:
1980: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1981: THEN
1982: fnd_log.string(fnd_log.level_statement,l_debug_module,'Operation Flag is U');
1983: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_enigma_op_rec.operation_id -> ' || p_enigma_op_rec.ENIGMA_OP_ID);
1984: END IF;
1985:
1986: l_get_latest_oper_rev := NULL;
1987:

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

2019: l_get_latest_oper_rev.object_version_number,
2020: l_get_latest_oper_rev.revision_status;
2021: CLOSE get_latest_oper_rev;
2022:
2023: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2024: THEN
2025: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.operation_id ->' || l_get_latest_oper_rev.operation_id);
2026: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.object_version_number ->' || l_get_latest_oper_rev.object_version_number);
2027: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.revision_status ->' || l_get_latest_oper_rev.revision_status);

Line 2025: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.operation_id ->' || l_get_latest_oper_rev.operation_id);

2021: CLOSE get_latest_oper_rev;
2022:
2023: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2024: THEN
2025: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.operation_id ->' || l_get_latest_oper_rev.operation_id);
2026: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.object_version_number ->' || l_get_latest_oper_rev.object_version_number);
2027: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.revision_status ->' || l_get_latest_oper_rev.revision_status);
2028: END IF;
2029:

Line 2026: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.object_version_number ->' || l_get_latest_oper_rev.object_version_number);

2022:
2023: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2024: THEN
2025: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.operation_id ->' || l_get_latest_oper_rev.operation_id);
2026: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.object_version_number ->' || l_get_latest_oper_rev.object_version_number);
2027: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.revision_status ->' || l_get_latest_oper_rev.revision_status);
2028: END IF;
2029:
2030: IF l_get_latest_oper_rev.operation_id IS NOT NULL THEN

Line 2027: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.revision_status ->' || l_get_latest_oper_rev.revision_status);

2023: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2024: THEN
2025: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.operation_id ->' || l_get_latest_oper_rev.operation_id);
2026: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.object_version_number ->' || l_get_latest_oper_rev.object_version_number);
2027: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.revision_status ->' || l_get_latest_oper_rev.revision_status);
2028: END IF;
2029:
2030: IF l_get_latest_oper_rev.operation_id IS NOT NULL THEN
2031:

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

2028: END IF;
2029:
2030: IF l_get_latest_oper_rev.operation_id IS NOT NULL THEN
2031:
2032: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2033: THEN
2034: fnd_log.string(fnd_log.level_statement,l_debug_module,'Latest Operation Found');
2035: END IF;
2036:

Line 2034: fnd_log.string(fnd_log.level_statement,l_debug_module,'Latest Operation Found');

2030: IF l_get_latest_oper_rev.operation_id IS NOT NULL THEN
2031:
2032: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2033: THEN
2034: fnd_log.string(fnd_log.level_statement,l_debug_module,'Latest Operation Found');
2035: END IF;
2036:
2037: -- If the operation is in Approval Pending status , then insert the operation record into the
2038: -- staging table with status as pending.

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

2070: x_operation_id
2071: );
2072:
2073: IF (l_log_statement >= l_log_current_level) THEN
2074: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_OPERATION_PVT.create_oper_revision');
2075: END IF;
2076:
2077: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
2078: IF (l_log_statement >= l_log_current_level) THEN

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

2075: END IF;
2076:
2077: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
2078: IF (l_log_statement >= l_log_current_level) THEN
2079: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.create_oper_revision Error');
2080: END IF;
2081: RAISE FND_API.G_EXC_ERROR;
2082: END IF;
2083:

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

2081: RAISE FND_API.G_EXC_ERROR;
2082: END IF;
2083:
2084: IF (l_log_statement >= l_log_current_level) THEN
2085: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.create_oper_revision -> revision Created');
2086: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.create_oper_revision -> x_operation_id= ' || x_operation_id);
2087: END IF;
2088:
2089: -- If the return status is success, populate the input rec for process_operation for updation

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

2082: END IF;
2083:
2084: IF (l_log_statement >= l_log_current_level) THEN
2085: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.create_oper_revision -> revision Created');
2086: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.create_oper_revision -> x_operation_id= ' || x_operation_id);
2087: END IF;
2088:
2089: -- If the return status is success, populate the input rec for process_operation for updation
2090:

Line 2116: fnd_log.string(fnd_log.level_statement,l_debug_module,' After revision operation_id -> '||p_process_oper_input_rec.OPERATION_ID

2112:
2113: p_process_oper_input_rec.DML_OPERATION := 'U';
2114:
2115: IF (l_log_statement >= l_log_current_level) THEN
2116: fnd_log.string(fnd_log.level_statement,l_debug_module,' After revision operation_id -> '||p_process_oper_input_rec.OPERATION_ID
2117: );
2118: fnd_log.string(fnd_log.level_statement,l_debug_module,'After revision object ver no -> ' || p_process_oper_input_rec.OBJECT_VERSION_NUMBER);
2119: END IF;
2120: -- Call the API for update

Line 2118: fnd_log.string(fnd_log.level_statement,l_debug_module,'After revision object ver no -> ' || p_process_oper_input_rec.OBJECT_VERSION_NUMBER);

2114:
2115: IF (l_log_statement >= l_log_current_level) THEN
2116: fnd_log.string(fnd_log.level_statement,l_debug_module,' After revision operation_id -> '||p_process_oper_input_rec.OPERATION_ID
2117: );
2118: fnd_log.string(fnd_log.level_statement,l_debug_module,'After revision object ver no -> ' || p_process_oper_input_rec.OBJECT_VERSION_NUMBER);
2119: END IF;
2120: -- Call the API for update
2121: AHL_RM_OPERATION_PVT.process_operation
2122: (

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

2132: p_process_oper_input_rec
2133: );
2134:
2135: IF (l_log_statement >= l_log_current_level) THEN
2136: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_OPERATION_PVT.process_operation');
2137: END IF;
2138:
2139: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
2140: IF (l_log_statement >= l_log_current_level) THEN

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

2137: END IF;
2138:
2139: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
2140: IF (l_log_statement >= l_log_current_level) THEN
2141: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation Error');
2142: END IF;
2143: RAISE FND_API.G_EXC_ERROR;
2144: END IF;
2145:

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

2143: RAISE FND_API.G_EXC_ERROR;
2144: END IF;
2145:
2146: IF (l_log_statement >= l_log_current_level) THEN
2147: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation:COMPLETE -> updation Successful');
2148: END IF;
2149:
2150: -- If the status is Draft or Approval Rejected , do the following.
2151: ELSIF ( UPPER(l_get_latest_oper_rev.revision_status) = 'DRAFT'

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

2150: -- If the status is Draft or Approval Rejected , do the following.
2151: ELSIF ( UPPER(l_get_latest_oper_rev.revision_status) = 'DRAFT'
2152: OR UPPER(l_get_latest_oper_rev.revision_status) = 'APPROVAL_REJECTED' ) THEN
2153:
2154: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2155: THEN
2156: fnd_log.string(fnd_log.level_statement,l_debug_module,'Update Operation-> Draft');
2157: fnd_log.string(fnd_log.level_statement,l_debug_module,'populate the input rec');
2158: END IF;

Line 2156: fnd_log.string(fnd_log.level_statement,l_debug_module,'Update Operation-> Draft');

2152: OR UPPER(l_get_latest_oper_rev.revision_status) = 'APPROVAL_REJECTED' ) THEN
2153:
2154: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2155: THEN
2156: fnd_log.string(fnd_log.level_statement,l_debug_module,'Update Operation-> Draft');
2157: fnd_log.string(fnd_log.level_statement,l_debug_module,'populate the input rec');
2158: END IF;
2159:
2160: -- If the return status is success, populate the input rec for process_operation for updation

Line 2157: fnd_log.string(fnd_log.level_statement,l_debug_module,'populate the input rec');

2153:
2154: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2155: THEN
2156: fnd_log.string(fnd_log.level_statement,l_debug_module,'Update Operation-> Draft');
2157: fnd_log.string(fnd_log.level_statement,l_debug_module,'populate the input rec');
2158: END IF;
2159:
2160: -- If the return status is success, populate the input rec for process_operation for updation
2161: IF ( l_get_latest_oper_rev.operation_id <> FND_API.G_MISS_NUM AND l_get_latest_oper_rev.operation_id IS NOT NULL) THEN

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

2180: END IF;
2181:
2182: p_process_oper_input_rec.DML_OPERATION := 'U';
2183:
2184: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2185: THEN
2186: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_process_oper_input_rec.OPERATION_ID-> ' || p_process_oper_input_rec.OPERATION_ID);
2187: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.object_version_number -> ' || l_get_latest_oper_rev.object_version_number);
2188: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_enigma_op_rec.description -> ' || p_enigma_op_rec.description);

Line 2186: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_process_oper_input_rec.OPERATION_ID-> ' || p_process_oper_input_rec.OPERATION_ID);

2182: p_process_oper_input_rec.DML_OPERATION := 'U';
2183:
2184: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2185: THEN
2186: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_process_oper_input_rec.OPERATION_ID-> ' || p_process_oper_input_rec.OPERATION_ID);
2187: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.object_version_number -> ' || l_get_latest_oper_rev.object_version_number);
2188: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_enigma_op_rec.description -> ' || p_enigma_op_rec.description);
2189: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_process_oper_input_rec.ENIGMA_OP_ID -> ' || p_process_oper_input_rec.ENIGMA_OP_ID);
2190: END IF;

Line 2187: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.object_version_number -> ' || l_get_latest_oper_rev.object_version_number);

2183:
2184: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2185: THEN
2186: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_process_oper_input_rec.OPERATION_ID-> ' || p_process_oper_input_rec.OPERATION_ID);
2187: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.object_version_number -> ' || l_get_latest_oper_rev.object_version_number);
2188: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_enigma_op_rec.description -> ' || p_enigma_op_rec.description);
2189: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_process_oper_input_rec.ENIGMA_OP_ID -> ' || p_process_oper_input_rec.ENIGMA_OP_ID);
2190: END IF;
2191:

Line 2188: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_enigma_op_rec.description -> ' || p_enigma_op_rec.description);

2184: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2185: THEN
2186: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_process_oper_input_rec.OPERATION_ID-> ' || p_process_oper_input_rec.OPERATION_ID);
2187: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.object_version_number -> ' || l_get_latest_oper_rev.object_version_number);
2188: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_enigma_op_rec.description -> ' || p_enigma_op_rec.description);
2189: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_process_oper_input_rec.ENIGMA_OP_ID -> ' || p_process_oper_input_rec.ENIGMA_OP_ID);
2190: END IF;
2191:
2192: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 2189: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_process_oper_input_rec.ENIGMA_OP_ID -> ' || p_process_oper_input_rec.ENIGMA_OP_ID);

2185: THEN
2186: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_process_oper_input_rec.OPERATION_ID-> ' || p_process_oper_input_rec.OPERATION_ID);
2187: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.object_version_number -> ' || l_get_latest_oper_rev.object_version_number);
2188: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_enigma_op_rec.description -> ' || p_enigma_op_rec.description);
2189: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_process_oper_input_rec.ENIGMA_OP_ID -> ' || p_process_oper_input_rec.ENIGMA_OP_ID);
2190: END IF;
2191:
2192: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2193: THEN

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

2188: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_enigma_op_rec.description -> ' || p_enigma_op_rec.description);
2189: fnd_log.string(fnd_log.level_statement,l_debug_module,'p_process_oper_input_rec.ENIGMA_OP_ID -> ' || p_process_oper_input_rec.ENIGMA_OP_ID);
2190: END IF;
2191:
2192: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2193: THEN
2194: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling AHL_RM_OPERATION_PVT.process_operation ');
2195: END IF;
2196:

Line 2194: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling AHL_RM_OPERATION_PVT.process_operation ');

2190: END IF;
2191:
2192: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2193: THEN
2194: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling AHL_RM_OPERATION_PVT.process_operation ');
2195: END IF;
2196:
2197: -- Call the API for update
2198: AHL_RM_OPERATION_PVT.process_operation

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

2209: p_process_oper_input_rec
2210: );
2211:
2212: IF (l_log_statement >= l_log_current_level) THEN
2213: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_OPERATION_PVT.process_operation');
2214: END IF;
2215:
2216: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
2217: IF (l_log_statement >= l_log_current_level) THEN

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

2214: END IF;
2215:
2216: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
2217: IF (l_log_statement >= l_log_current_level) THEN
2218: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation Error');
2219: END IF;
2220: RAISE FND_API.G_EXC_ERROR;
2221: END IF;
2222:

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

2220: RAISE FND_API.G_EXC_ERROR;
2221: END IF;
2222:
2223: IF (l_log_statement >= l_log_current_level) THEN
2224: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation:DRAFT -> updation Successful');
2225: END IF;
2226:
2227: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2228: THEN

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

2223: IF (l_log_statement >= l_log_current_level) THEN
2224: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.process_operation:DRAFT -> updation Successful');
2225: END IF;
2226:
2227: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2228: THEN
2229: fnd_log.string(fnd_log.level_statement,l_debug_module,'Before inserting into the staging table');
2230: END IF;
2231: END IF ; -- Status check

Line 2229: fnd_log.string(fnd_log.level_statement,l_debug_module,'Before inserting into the staging table');

2225: END IF;
2226:
2227: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2228: THEN
2229: fnd_log.string(fnd_log.level_statement,l_debug_module,'Before inserting into the staging table');
2230: END IF;
2231: END IF ; -- Status check
2232:
2233: -- Insert the transaction record into the staging table, with status as success

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

2241: X_REASON => 'Operation updated successfully',
2242: X_ENIGMA_DOC_ID => p_enigma_op_rec.ENIGMA_DOC_ID
2243: );*/
2244:
2245: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2246: THEN
2247: fnd_log.string(fnd_log.level_statement,l_debug_module,'After inserting into the staging table');
2248: END IF;
2249: ELSE

Line 2247: fnd_log.string(fnd_log.level_statement,l_debug_module,'After inserting into the staging table');

2243: );*/
2244:
2245: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2246: THEN
2247: fnd_log.string(fnd_log.level_statement,l_debug_module,'After inserting into the staging table');
2248: END IF;
2249: ELSE
2250: FND_MESSAGE.SET_NAME('AHL', 'AHL_ENIGMA_OPER_DONOT_EXIST');
2251: FND_MSG_PUB.ADD;

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

2253: END IF; -- Enigma Operation ID is NOT NULL Cursor Found
2254: -- If the operation change flag is "D" then process the operation accordingly .
2255: ELSIF (p_enigma_op_rec.DML_OPERATION = 'D') THEN
2256:
2257: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2258: THEN
2259: fnd_log.string(fnd_log.level_statement,l_debug_module,'Operation Flag is D');
2260: END IF;
2261:

Line 2259: fnd_log.string(fnd_log.level_statement,l_debug_module,'Operation Flag is D');

2255: ELSIF (p_enigma_op_rec.DML_OPERATION = 'D') THEN
2256:
2257: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2258: THEN
2259: fnd_log.string(fnd_log.level_statement,l_debug_module,'Operation Flag is D');
2260: END IF;
2261:
2262: l_get_latest_oper_rev := NULL;
2263:

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

2267: l_get_latest_oper_rev.object_version_number,
2268: l_get_latest_oper_rev.revision_status;
2269: CLOSE get_latest_oper_rev;
2270:
2271: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2272: THEN
2273: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.operation_id ->' || l_get_latest_oper_rev.operation_id);
2274: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.object_version_number ->' || l_get_latest_oper_rev.object_version_number);
2275: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.revision_status ->' || l_get_latest_oper_rev.revision_status);

Line 2273: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.operation_id ->' || l_get_latest_oper_rev.operation_id);

2269: CLOSE get_latest_oper_rev;
2270:
2271: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2272: THEN
2273: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.operation_id ->' || l_get_latest_oper_rev.operation_id);
2274: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.object_version_number ->' || l_get_latest_oper_rev.object_version_number);
2275: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.revision_status ->' || l_get_latest_oper_rev.revision_status);
2276: END IF;
2277:

Line 2274: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.object_version_number ->' || l_get_latest_oper_rev.object_version_number);

2270:
2271: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2272: THEN
2273: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.operation_id ->' || l_get_latest_oper_rev.operation_id);
2274: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.object_version_number ->' || l_get_latest_oper_rev.object_version_number);
2275: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.revision_status ->' || l_get_latest_oper_rev.revision_status);
2276: END IF;
2277:
2278: IF l_get_latest_oper_rev.operation_id IS NOT NULL THEN

Line 2275: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.revision_status ->' || l_get_latest_oper_rev.revision_status);

2271: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2272: THEN
2273: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.operation_id ->' || l_get_latest_oper_rev.operation_id);
2274: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.object_version_number ->' || l_get_latest_oper_rev.object_version_number);
2275: fnd_log.string(fnd_log.level_statement,l_debug_module,'l_get_latest_oper_rev.revision_status ->' || l_get_latest_oper_rev.revision_status);
2276: END IF;
2277:
2278: IF l_get_latest_oper_rev.operation_id IS NOT NULL THEN
2279:

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

2276: END IF;
2277:
2278: IF l_get_latest_oper_rev.operation_id IS NOT NULL THEN
2279:
2280: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2281: THEN
2282: fnd_log.string(fnd_log.level_statement,l_debug_module,'Delete :Cursor Found :Operation Exist ');
2283: END IF;
2284:

Line 2282: fnd_log.string(fnd_log.level_statement,l_debug_module,'Delete :Cursor Found :Operation Exist ');

2278: IF l_get_latest_oper_rev.operation_id IS NOT NULL THEN
2279:
2280: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2281: THEN
2282: fnd_log.string(fnd_log.level_statement,l_debug_module,'Delete :Cursor Found :Operation Exist ');
2283: END IF;
2284:
2285: -- IF the operation is in Approval Pending status , then insert the operation record into the staging table with status as pending.
2286:

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

2299: X_REASON => 'Operation is in Pending Status',
2300: X_ENIGMA_DOC_ID => p_enigma_op_rec.ENIGMA_DOC_ID
2301: );*/
2302: ELSE
2303: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2304: THEN
2305: fnd_log.string(fnd_log.level_statement,l_debug_module,'Inside else , calling delete operation');
2306: END IF;
2307:

Line 2305: fnd_log.string(fnd_log.level_statement,l_debug_module,'Inside else , calling delete operation');

2301: );*/
2302: ELSE
2303: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2304: THEN
2305: fnd_log.string(fnd_log.level_statement,l_debug_module,'Inside else , calling delete operation');
2306: END IF;
2307:
2308: -- Call the delete operation API
2309: AHL_RM_OPERATION_PVT.delete_operation

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

2321: l_get_latest_oper_rev.object_version_number
2322: );
2323:
2324: IF (l_log_statement >= l_log_current_level) THEN
2325: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_OPERATION_PVT.delete_operation');
2326: END IF;
2327:
2328: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
2329: IF (l_log_statement >= l_log_current_level) THEN

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

2326: END IF;
2327:
2328: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
2329: IF (l_log_statement >= l_log_current_level) THEN
2330: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.delete_operation Error');
2331: END IF;
2332: RAISE FND_API.G_EXC_ERROR;
2333: END IF;
2334:

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

2332: RAISE FND_API.G_EXC_ERROR;
2333: END IF;
2334:
2335: IF (l_log_statement >= l_log_current_level) THEN
2336: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_OPERATION_PVT.delete_operation -> deletion Successful');
2337: END IF;
2338: END IF; --Status
2339: ELSE
2340: -- If the operation is not found, then raise an error

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

2441: BEGIN
2442:
2443: x_return_status := FND_API.G_RET_STS_SUCCESS;
2444:
2445: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2446: THEN
2447:
2448: fnd_log.string
2449: (

Line 2448: fnd_log.string

2444:
2445: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2446: THEN
2447:
2448: fnd_log.string
2449: (
2450: fnd_log.level_statement,
2451: l_debug_module,
2452: 'inside UPLOAD_REVISION_REPORT->p_file_name->'||p_file_name

Line 2450: fnd_log.level_statement,

2446: THEN
2447:
2448: fnd_log.string
2449: (
2450: fnd_log.level_statement,
2451: l_debug_module,
2452: 'inside UPLOAD_REVISION_REPORT->p_file_name->'||p_file_name
2453: );
2454: END IF;

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

2458: FND_MESSAGE.set_name( 'AHL','AHL_COM_REQD_PARAM_MISSING' );
2459: FND_MSG_PUB.add;
2460: x_return_status := FND_API.G_RET_STS_ERROR;
2461:
2462: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2463: fnd_log.string
2464: (
2465: fnd_log.level_error,
2466: 'ahl.plsql.'||g_pkg_name||'.'||'upload_revision_report'||':',

Line 2463: fnd_log.string

2459: FND_MSG_PUB.add;
2460: x_return_status := FND_API.G_RET_STS_ERROR;
2461:
2462: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2463: fnd_log.string
2464: (
2465: fnd_log.level_error,
2466: 'ahl.plsql.'||g_pkg_name||'.'||'upload_revision_report'||':',
2467: 'Revision report file name is null'

Line 2465: fnd_log.level_error,

2461:
2462: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2463: fnd_log.string
2464: (
2465: fnd_log.level_error,
2466: 'ahl.plsql.'||g_pkg_name||'.'||'upload_revision_report'||':',
2467: 'Revision report file name is null'
2468: );
2469: END IF;