APPS.AHL_PRD_PRINT_PVT dependencies on FND_LOG

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

407: BEGIN
408: --set the operating unit.
409: mo_global.init('AHL');
410:
411: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
412:
413: fnd_log.string
414: (
415: fnd_log.level_procedure,

Line 413: fnd_log.string

409: mo_global.init('AHL');
410:
411: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
412:
413: fnd_log.string
414: (
415: fnd_log.level_procedure,
416: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
417: 'At the start of Gen_Wo_Xml'

Line 415: fnd_log.level_procedure,

411: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
412:
413: fnd_log.string
414: (
415: fnd_log.level_procedure,
416: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
417: 'At the start of Gen_Wo_Xml'
418: );
419: END IF;

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

420:
421: --SAVEPOINT Gen_Wo_Xml;
422:
423:
424: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
425: fnd_log.string
426: (
427: fnd_log.level_statement,
428: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 425: fnd_log.string

421: --SAVEPOINT Gen_Wo_Xml;
422:
423:
424: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
425: fnd_log.string
426: (
427: fnd_log.level_statement,
428: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
429: 'API input Parameters '

Line 427: fnd_log.level_statement,

423:
424: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
425: fnd_log.string
426: (
427: fnd_log.level_statement,
428: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
429: 'API input Parameters '
430: );
431: fnd_log.string

Line 431: fnd_log.string

427: fnd_log.level_statement,
428: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
429: 'API input Parameters '
430: );
431: fnd_log.string
432: (
433: fnd_log.level_statement,
434: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
435: '************************'

Line 433: fnd_log.level_statement,

429: 'API input Parameters '
430: );
431: fnd_log.string
432: (
433: fnd_log.level_statement,
434: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
435: '************************'
436: );
437: fnd_log.string

Line 437: fnd_log.string

433: fnd_log.level_statement,
434: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
435: '************************'
436: );
437: fnd_log.string
438: (
439: fnd_log.level_statement,
440: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
441: 'p_employee_id -> '||p_employee_id

Line 439: fnd_log.level_statement,

435: '************************'
436: );
437: fnd_log.string
438: (
439: fnd_log.level_statement,
440: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
441: 'p_employee_id -> '||p_employee_id
442: );
443: fnd_log.string

Line 443: fnd_log.string

439: fnd_log.level_statement,
440: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
441: 'p_employee_id -> '||p_employee_id
442: );
443: fnd_log.string
444: (
445: fnd_log.level_statement,
446: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
447: 'p_user_role -> '||p_user_role

Line 445: fnd_log.level_statement,

441: 'p_employee_id -> '||p_employee_id
442: );
443: fnd_log.string
444: (
445: fnd_log.level_statement,
446: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
447: 'p_user_role -> '||p_user_role
448: );
449: fnd_log.string

Line 449: fnd_log.string

445: fnd_log.level_statement,
446: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
447: 'p_user_role -> '||p_user_role
448: );
449: fnd_log.string
450: (
451: fnd_log.level_statement,
452: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
453: 'p_concurrent_flag -> '||p_concurrent_flag

Line 451: fnd_log.level_statement,

447: 'p_user_role -> '||p_user_role
448: );
449: fnd_log.string
450: (
451: fnd_log.level_statement,
452: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
453: 'p_concurrent_flag -> '||p_concurrent_flag
454: );
455: fnd_log.string

Line 455: fnd_log.string

451: fnd_log.level_statement,
452: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
453: 'p_concurrent_flag -> '||p_concurrent_flag
454: );
455: fnd_log.string
456: (
457: fnd_log.level_statement,
458: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
459: 'p_workorders_tbl size -> '||p_workorders_tbl.count

Line 457: fnd_log.level_statement,

453: 'p_concurrent_flag -> '||p_concurrent_flag
454: );
455: fnd_log.string
456: (
457: fnd_log.level_statement,
458: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
459: 'p_workorders_tbl size -> '||p_workorders_tbl.count
460: );
461:

Line 462: fnd_log.string

458: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
459: 'p_workorders_tbl size -> '||p_workorders_tbl.count
460: );
461:
462: fnd_log.string
463: (
464: fnd_log.level_statement,
465: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
466: 'mo operating unit -> '||mo_global.get_current_org_id()

Line 464: fnd_log.level_statement,

460: );
461:
462: fnd_log.string
463: (
464: fnd_log.level_statement,
465: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
466: 'mo operating unit -> '||mo_global.get_current_org_id()
467: );
468: fnd_log.string

Line 468: fnd_log.string

464: fnd_log.level_statement,
465: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
466: 'mo operating unit -> '||mo_global.get_current_org_id()
467: );
468: fnd_log.string
469: (
470: fnd_log.level_statement,
471: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
472: 'AHL_PRD_PRINT_PVT.get_tz_offset -> '||AHL_PRD_PRINT_PVT.get_tz_offset

Line 470: fnd_log.level_statement,

466: 'mo operating unit -> '||mo_global.get_current_org_id()
467: );
468: fnd_log.string
469: (
470: fnd_log.level_statement,
471: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
472: 'AHL_PRD_PRINT_PVT.get_tz_offset -> '||AHL_PRD_PRINT_PVT.get_tz_offset
473: );
474: END IF;

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

512: -- Process all workorders in the input.
513: IF p_workorders_tbl.COUNT > 0 THEN
514: FOR wo_count IN p_workorders_tbl.FIRST .. p_workorders_tbl.LAST
515: LOOP
516: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
517: fnd_log.string
518: (
519: fnd_log.level_statement,
520: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 517: fnd_log.string

513: IF p_workorders_tbl.COUNT > 0 THEN
514: FOR wo_count IN p_workorders_tbl.FIRST .. p_workorders_tbl.LAST
515: LOOP
516: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
517: fnd_log.string
518: (
519: fnd_log.level_statement,
520: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
521: 'p_workorders_tbl('||wo_count||') --> '||p_workorders_tbl(wo_count)

Line 519: fnd_log.level_statement,

515: LOOP
516: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
517: fnd_log.string
518: (
519: fnd_log.level_statement,
520: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
521: 'p_workorders_tbl('||wo_count||') --> '||p_workorders_tbl(wo_count)
522: );
523: END IF;

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

540: IF l_emp_tbl.COUNT > 0 THEN
541: FOR l_count IN l_emp_tbl.FIRST..l_emp_tbl.LAST
542: LOOP
543:
544: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
545: fnd_log.string
546: (
547: fnd_log.level_statement,
548: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 545: fnd_log.string

541: FOR l_count IN l_emp_tbl.FIRST..l_emp_tbl.LAST
542: LOOP
543:
544: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
545: fnd_log.string
546: (
547: fnd_log.level_statement,
548: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
549: 'l_emp_tbl('||l_count||') --> '||l_emp_tbl(l_count).employee_id

Line 547: fnd_log.level_statement,

543:
544: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
545: fnd_log.string
546: (
547: fnd_log.level_statement,
548: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
549: 'l_emp_tbl('||l_count||') --> '||l_emp_tbl(l_count).employee_id
550: );
551: END IF;

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

573: ''
574: );
575: END IF;
576:
577: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
578: fnd_log.string
579: (
580: fnd_log.level_statement,
581: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 578: fnd_log.string

574: );
575: END IF;
576:
577: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
578: fnd_log.string
579: (
580: fnd_log.level_statement,
581: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
582: 'After Processing Employee info '

Line 580: fnd_log.level_statement,

576:
577: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
578: fnd_log.string
579: (
580: fnd_log.level_statement,
581: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
582: 'After Processing Employee info '
583: );
584: END IF;

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

610: ) WODE ';
611:
612: l_wo_con_query := l_wo_con_query || l_wo_details_where;
613:
614: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
615: fnd_log.string
616: (
617: fnd_log.level_statement,
618: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 615: fnd_log.string

611:
612: l_wo_con_query := l_wo_con_query || l_wo_details_where;
613:
614: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
615: fnd_log.string
616: (
617: fnd_log.level_statement,
618: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
619: 'Workorder details query string --->'||l_wo_con_query

Line 617: fnd_log.level_statement,

613:
614: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
615: fnd_log.string
616: (
617: fnd_log.level_statement,
618: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
619: 'Workorder details query string --->'||l_wo_con_query
620: );
621: END IF;

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

641: -- copy workorder details into final lob
642: dbms_lob.copy(l_merged_lob, l_wo_details_lob, dbms_lob.getlength(l_wo_details_lob), dbms_lob.getlength(l_merged_lob)+1, l_offset+ 1);
643: END IF;
644:
645: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
646: fnd_log.string
647: (
648: fnd_log.level_statement,
649: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 646: fnd_log.string

642: dbms_lob.copy(l_merged_lob, l_wo_details_lob, dbms_lob.getlength(l_wo_details_lob), dbms_lob.getlength(l_merged_lob)+1, l_offset+ 1);
643: END IF;
644:
645: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
646: fnd_log.string
647: (
648: fnd_log.level_statement,
649: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
650: 'After Processing Workorder Header Info '

Line 648: fnd_log.level_statement,

644:
645: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
646: fnd_log.string
647: (
648: fnd_log.level_statement,
649: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
650: 'After Processing Workorder Header Info '
651: );
652: END IF;

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

688: dbms_lob.copy(l_merged_lob, l_wo_qa_lob, dbms_lob.getlength(l_wo_qa_lob), dbms_lob.getlength(l_merged_lob)+1, l_offset+ 1);
689: END IF;
690: END IF;
691:
692: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
693: fnd_log.string
694: (
695: fnd_log.level_statement,
696: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 693: fnd_log.string

689: END IF;
690: END IF;
691:
692: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
693: fnd_log.string
694: (
695: fnd_log.level_statement,
696: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
697: 'After Processing Workorder Quality Info '

Line 695: fnd_log.level_statement,

691:
692: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
693: fnd_log.string
694: (
695: fnd_log.level_statement,
696: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
697: 'After Processing Workorder Quality Info '
698: );
699: END IF;

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

778: length(l_merged_lob)+1,
779: ''
780: );
781:
782: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
783: fnd_log.string
784: (
785: fnd_log.level_statement,
786: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 783: fnd_log.string

779: ''
780: );
781:
782: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
783: fnd_log.string
784: (
785: fnd_log.level_statement,
786: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
787: 'After Processing Workorder Operation Quality Info '

Line 785: fnd_log.level_statement,

781:
782: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
783: fnd_log.string
784: (
785: fnd_log.level_statement,
786: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
787: 'After Processing Workorder Operation Quality Info '
788: );
789: END IF;

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

809: -- copy workorder details into final lob
810: dbms_lob.copy(l_merged_lob, l_ton_lob, dbms_lob.getlength(l_ton_lob), dbms_lob.getlength(l_merged_lob)+1, l_offset+ 1);
811: END IF;
812:
813: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
814: fnd_log.string
815: (
816: fnd_log.level_statement,
817: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 814: fnd_log.string

810: dbms_lob.copy(l_merged_lob, l_ton_lob, dbms_lob.getlength(l_ton_lob), dbms_lob.getlength(l_merged_lob)+1, l_offset+ 1);
811: END IF;
812:
813: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
814: fnd_log.string
815: (
816: fnd_log.level_statement,
817: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
818: 'After Processing turnover notes '

Line 816: fnd_log.level_statement,

812:
813: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
814: fnd_log.string
815: (
816: fnd_log.level_statement,
817: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
818: 'After Processing turnover notes '
819: );
820: END IF;

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

845: ||', '''||l_user_role||''' ),0) "HOURS_WORKED", ';
846:
847: l_op_con_query := l_op_con_query || l_op_details_2 || l_op_rec.workorder_operation_id;
848:
849: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
850: fnd_log.string
851: (
852: fnd_log.level_statement,
853: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 850: fnd_log.string

846:
847: l_op_con_query := l_op_con_query || l_op_details_2 || l_op_rec.workorder_operation_id;
848:
849: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
850: fnd_log.string
851: (
852: fnd_log.level_statement,
853: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
854: 'operation details query string --->'||l_op_con_query

Line 852: fnd_log.level_statement,

848:
849: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
850: fnd_log.string
851: (
852: fnd_log.level_statement,
853: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
854: 'operation details query string --->'||l_op_con_query
855: );
856: END IF;

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

923: END IF;
924: END IF;
925: END LOOP;
926:
927: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
928: fnd_log.string
929: (
930: fnd_log.level_statement,
931: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 928: fnd_log.string

924: END IF;
925: END LOOP;
926:
927: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
928: fnd_log.string
929: (
930: fnd_log.level_statement,
931: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
932: 'After Processing Workorder Operations '

Line 930: fnd_log.level_statement,

926:
927: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
928: fnd_log.string
929: (
930: fnd_log.level_statement,
931: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
932: 'After Processing Workorder Operations '
933: );
934: END IF;

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

957: dbms_lob.copy(l_merged_lob, l_wo_mat_lob, dbms_lob.getlength(l_wo_mat_lob), dbms_lob.getlength(l_merged_lob)+1, l_offset+ 1);
958:
959: END IF;
960:
961: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
962: fnd_log.string
963: (
964: fnd_log.level_statement,
965: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 962: fnd_log.string

958:
959: END IF;
960:
961: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
962: fnd_log.string
963: (
964: fnd_log.level_statement,
965: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
966: 'After Processing Workorder Material requirements '

Line 964: fnd_log.level_statement,

960:
961: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
962: fnd_log.string
963: (
964: fnd_log.level_statement,
965: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
966: 'After Processing Workorder Material requirements '
967: );
968: END IF;

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

996: dbms_lob.copy(l_merged_lob, l_wo_doc_lob, dbms_lob.getlength(l_wo_doc_lob), dbms_lob.getlength(l_merged_lob)+1, l_offset+ 1);
997:
998: END IF;
999:
1000: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1001: fnd_log.string
1002: (
1003: fnd_log.level_statement,
1004: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 1001: fnd_log.string

997:
998: END IF;
999:
1000: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1001: fnd_log.string
1002: (
1003: fnd_log.level_statement,
1004: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1005: 'After Processing Document associations to workorders'

Line 1003: fnd_log.level_statement,

999:
1000: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1001: fnd_log.string
1002: (
1003: fnd_log.level_statement,
1004: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1005: 'After Processing Document associations to workorders'
1006: );
1007: END IF;

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

1028: --dbms_lob.close(l_wo_details_lob);
1029: dbms_lob.freeTemporary( l_merged_lob );
1030:
1031: /*
1032: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1033: l_fnd_offset := 1;
1034: l_chunk_size := 3000;
1035: l_clob_size := LENGTH(x_xml_data);
1036:

Line 1038: fnd_log.string

1034: l_chunk_size := 3000;
1035: l_clob_size := LENGTH(x_xml_data);
1036:
1037: WHILE (l_clob_size > 0) LOOP
1038: fnd_log.string
1039: (
1040: fnd_log.level_statement,
1041: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1042: 'xml data ->'||substr(x_xml_data, l_chunk_size, l_fnd_offset)

Line 1040: fnd_log.level_statement,

1036:
1037: WHILE (l_clob_size > 0) LOOP
1038: fnd_log.string
1039: (
1040: fnd_log.level_statement,
1041: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1042: 'xml data ->'||substr(x_xml_data, l_chunk_size, l_fnd_offset)
1043: );
1044: l_clob_size := l_clob_size - l_chunk_size;

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

1047:
1048: END IF;
1049: */
1050:
1051: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1052: fnd_log.string
1053: (
1054: fnd_log.level_procedure,
1055: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',

Line 1052: fnd_log.string

1048: END IF;
1049: */
1050:
1051: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1052: fnd_log.string
1053: (
1054: fnd_log.level_procedure,
1055: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
1056: 'At the end of AHL_PRD_PRINT_PVT'

Line 1054: fnd_log.level_procedure,

1050:
1051: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1052: fnd_log.string
1053: (
1054: fnd_log.level_procedure,
1055: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
1056: 'At the end of AHL_PRD_PRINT_PVT'
1057: );
1058: END IF;

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

1061: WHEN OTHERS THEN
1062:
1063: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
1064:
1065: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1066: fnd_log.string
1067: (
1068: fnd_log.level_statement,
1069: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 1066: fnd_log.string

1062:
1063: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
1064:
1065: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1066: fnd_log.string
1067: (
1068: fnd_log.level_statement,
1069: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1070: 'xml data ->'||dbms_lob.substr(x_xml_data, dbms_lob.getlength(x_xml_data), 1)

Line 1068: fnd_log.level_statement,

1064:
1065: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1066: fnd_log.string
1067: (
1068: fnd_log.level_statement,
1069: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1070: 'xml data ->'||dbms_lob.substr(x_xml_data, dbms_lob.getlength(x_xml_data), 1)
1071: );
1072: END IF;

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

1215: --add dummy query to the original query
1216: l_query_string := l_query_string || l_dummy_query || ' FROM DUAL CONNECT BY 1 = 1 and level <= 3';
1217: x_query_string := l_query_string;
1218:
1219: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1220: fnd_log.string
1221: (
1222: fnd_log.level_statement,
1223: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 1220: fnd_log.string

1216: l_query_string := l_query_string || l_dummy_query || ' FROM DUAL CONNECT BY 1 = 1 and level <= 3';
1217: x_query_string := l_query_string;
1218:
1219: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1220: fnd_log.string
1221: (
1222: fnd_log.level_statement,
1223: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1224: 'Quality Collection query string --->'||l_query_string

Line 1222: fnd_log.level_statement,

1218:
1219: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1220: fnd_log.string
1221: (
1222: fnd_log.level_statement,
1223: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1224: 'Quality Collection query string --->'||l_query_string
1225: );
1226: END IF;

Line 1467: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;

1463: l_object_id NUMBER;
1464: l_object_type VARCHAR2(80);
1465:
1466:
1467: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
1468: l_api_version NUMBER := 1.0;
1469: l_log_statement NUMBER := FND_LOG.level_statement;
1470: l_log_procedure NUMBER := FND_LOG.level_procedure;
1471: l_log_error NUMBER := FND_LOG.level_error;

Line 1469: l_log_statement NUMBER := FND_LOG.level_statement;

1465:
1466:
1467: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
1468: l_api_version NUMBER := 1.0;
1469: l_log_statement NUMBER := FND_LOG.level_statement;
1470: l_log_procedure NUMBER := FND_LOG.level_procedure;
1471: l_log_error NUMBER := FND_LOG.level_error;
1472: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
1473:

Line 1470: l_log_procedure NUMBER := FND_LOG.level_procedure;

1466:
1467: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
1468: l_api_version NUMBER := 1.0;
1469: l_log_statement NUMBER := FND_LOG.level_statement;
1470: l_log_procedure NUMBER := FND_LOG.level_procedure;
1471: l_log_error NUMBER := FND_LOG.level_error;
1472: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
1473:
1474: BEGIN

Line 1471: l_log_error NUMBER := FND_LOG.level_error;

1467: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
1468: l_api_version NUMBER := 1.0;
1469: l_log_statement NUMBER := FND_LOG.level_statement;
1470: l_log_procedure NUMBER := FND_LOG.level_procedure;
1471: l_log_error NUMBER := FND_LOG.level_error;
1472: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
1473:
1474: BEGIN
1475:

Line 1472: l_log_unexpected NUMBER := FND_LOG.level_unexpected;

1468: l_api_version NUMBER := 1.0;
1469: l_log_statement NUMBER := FND_LOG.level_statement;
1470: l_log_procedure NUMBER := FND_LOG.level_procedure;
1471: l_log_error NUMBER := FND_LOG.level_error;
1472: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
1473:
1474: BEGIN
1475:
1476: IF (l_log_procedure >= l_log_current_level)THEN

Line 1477: fnd_log.string(

1473:
1474: BEGIN
1475:
1476: IF (l_log_procedure >= l_log_current_level)THEN
1477: fnd_log.string(
1478: l_log_procedure,
1479: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1480: 'At Begin of the Procedure Process_JCG_Request'
1481: );

Line 1502: fnd_log.string(

1498: FND_MSG_PUB.initialize;
1499: END IF;
1500:
1501: IF (l_log_statement >= l_log_current_level)THEN
1502: fnd_log.string(
1503: l_log_statement,
1504: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1505: 'Before Basic Validations for the procedure.'
1506: );

Line 1519: fnd_log.string(

1515:
1516: IF (p_status_code IS NULL) THEN
1517:
1518: IF (l_log_error >= l_log_current_level)THEN
1519: fnd_log.string(
1520: l_log_error,
1521: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1522: 'Mandatory input, Status_Code is NULL.'
1523: );

Line 1561: fnd_log.string(

1557:
1558: END IF;
1559:
1560: IF (l_log_statement >= l_log_current_level)THEN
1561: fnd_log.string(
1562: l_log_statement,
1563: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1564: 'After Basic Validations for the procedure.'
1565: );

Line 1575: fnd_log.string(

1571:
1572: IF (p_operation_flag = 'C' ) THEN
1573:
1574: IF (l_log_statement >= l_log_current_level)THEN
1575: fnd_log.string(
1576: l_log_statement,
1577: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1578: 'Before inserting a new row in AHL_ENIGMA_JCG_DETAILS.'
1579: );

Line 1661: fnd_log.string(

1657:
1658:
1659:
1660: IF (l_log_statement >= l_log_current_level)THEN
1661: fnd_log.string(
1662: l_log_statement,
1663: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1664: 'Before updating a new row in AHL_ENIGMA_JCG_DETAILS.'
1665: );

Line 1708: fnd_log.string(

1704:
1705: END IF;
1706:
1707: IF (l_log_procedure >= l_log_current_level)THEN
1708: fnd_log.string(
1709: l_log_procedure,
1710: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1711: 'At END of the Procedure Process_JCG_Request,p_x_jcg_id = '|| p_x_jcg_id || ' p_status_code = '||p_status_code
1712: );

Line 1725: fnd_log.string(

1721: p_encoded => fnd_api.g_false);
1722:
1723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1724: IF (l_log_statement >= l_log_current_level)THEN
1725: fnd_log.string(
1726: l_log_statement,
1727: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1728: 'unExpected Error-'
1729: );

Line 1747: fnd_log.string(

1743: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1744: p_data => x_msg_data,
1745: p_encoded => fnd_api.g_false);
1746: IF (l_log_unexpected >= l_log_current_level)THEN
1747: fnd_log.string(
1748: l_log_unexpected,
1749: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1750: 'Unexpected Error Others '
1751: );

Line 1986: l_log_unexpected NUMBER; -- := FND_LOG.level_unexpected;

1982: l_visit_det_lob CLOB;
1983: l_childmr_details_lob CLOB;
1984: l_offset NUMBER;
1985:
1986: l_log_unexpected NUMBER; -- := FND_LOG.level_unexpected;
1987: l_log_statement NUMBER; -- := FND_LOG.level_statement;
1988: l_log_current_level NUMBER; -- := FND_LOG.g_current_runtime_level;
1989:
1990:

Line 1987: l_log_statement NUMBER; -- := FND_LOG.level_statement;

1983: l_childmr_details_lob CLOB;
1984: l_offset NUMBER;
1985:
1986: l_log_unexpected NUMBER; -- := FND_LOG.level_unexpected;
1987: l_log_statement NUMBER; -- := FND_LOG.level_statement;
1988: l_log_current_level NUMBER; -- := FND_LOG.g_current_runtime_level;
1989:
1990:
1991: -- start to create file

Line 1988: l_log_current_level NUMBER; -- := FND_LOG.g_current_runtime_level;

1984: l_offset NUMBER;
1985:
1986: l_log_unexpected NUMBER; -- := FND_LOG.level_unexpected;
1987: l_log_statement NUMBER; -- := FND_LOG.level_statement;
1988: l_log_current_level NUMBER; -- := FND_LOG.g_current_runtime_level;
1989:
1990:
1991: -- start to create file
1992: -- x_file_name VARCHAR2(100) := 'Output.XML';

Line 3041: l_log_unexpected := FND_LOG.level_unexpected;

3037:
3038: SAVEPOINT Generate_JCG_XML_PVT;
3039: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3040: -- initialize log levels
3041: l_log_unexpected := FND_LOG.level_unexpected;
3042: l_log_statement := FND_LOG.level_statement;
3043: l_log_current_level := FND_LOG.g_current_runtime_level;
3044:
3045: IF (l_log_statement >= l_log_current_level)THEN

Line 3042: l_log_statement := FND_LOG.level_statement;

3038: SAVEPOINT Generate_JCG_XML_PVT;
3039: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3040: -- initialize log levels
3041: l_log_unexpected := FND_LOG.level_unexpected;
3042: l_log_statement := FND_LOG.level_statement;
3043: l_log_current_level := FND_LOG.g_current_runtime_level;
3044:
3045: IF (l_log_statement >= l_log_current_level)THEN
3046: fnd_log.string (

Line 3043: l_log_current_level := FND_LOG.g_current_runtime_level;

3039: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3040: -- initialize log levels
3041: l_log_unexpected := FND_LOG.level_unexpected;
3042: l_log_statement := FND_LOG.level_statement;
3043: l_log_current_level := FND_LOG.g_current_runtime_level;
3044:
3045: IF (l_log_statement >= l_log_current_level)THEN
3046: fnd_log.string (
3047: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'p_object_id : ' || p_object_id);

Line 3046: fnd_log.string (

3042: l_log_statement := FND_LOG.level_statement;
3043: l_log_current_level := FND_LOG.g_current_runtime_level;
3044:
3045: IF (l_log_statement >= l_log_current_level)THEN
3046: fnd_log.string (
3047: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'p_object_id : ' || p_object_id);
3048: fnd_log.string (
3049: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'p_object_type : ' || p_object_type);
3050: fnd_log.string (

Line 3048: fnd_log.string (

3044:
3045: IF (l_log_statement >= l_log_current_level)THEN
3046: fnd_log.string (
3047: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'p_object_id : ' || p_object_id);
3048: fnd_log.string (
3049: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'p_object_type : ' || p_object_type);
3050: fnd_log.string (
3051: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'p_split_flag : ' || p_split_flag);
3052: END IF;

Line 3050: fnd_log.string (

3046: fnd_log.string (
3047: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'p_object_id : ' || p_object_id);
3048: fnd_log.string (
3049: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'p_object_type : ' || p_object_type);
3050: fnd_log.string (
3051: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'p_split_flag : ' || p_split_flag);
3052: END IF;
3053:
3054: -- Call pre customer hook api call

Line 3075: fnd_log.string (

3071: p_dir := FND_PROFILE.VALUE('AHL_ENIGMA_JCG_XML_FILEPATH');
3072: x_file_name := p_object_type ||'-' || p_object_id || '-' || TO_CHAR(SYSDATE,'dd-Mon-yyyy-hh24-mi-ss') || '.xml';
3073:
3074: IF (l_log_statement >= l_log_current_level)THEN
3075: fnd_log.string (
3076: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'p_dir : ' || p_dir);
3077: fnd_log.string (
3078: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'x_file_name : ' || x_file_name);
3079: END IF;

Line 3077: fnd_log.string (

3073:
3074: IF (l_log_statement >= l_log_current_level)THEN
3075: fnd_log.string (
3076: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'p_dir : ' || p_dir);
3077: fnd_log.string (
3078: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'x_file_name : ' || x_file_name);
3079: END IF;
3080:
3081: dbms_lob.createTemporary( l_merged_lob, true );

Line 3142: fnd_log.string (

3138:
3139: END IF;
3140:
3141: IF (l_log_statement >= l_log_current_level)THEN
3142: fnd_log.string (
3143: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'Starting to create LOB');
3144: END IF;
3145:
3146: dbms_lob.write(l_merged_lob, length('

Line 3192: fnd_log.string (

3188:
3189: END IF;
3190:
3191: IF (l_log_statement >= l_log_current_level)THEN
3192: fnd_log.string (
3193: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'After visit details');
3194: END IF;
3195:
3196: IF (p_object_type = 'WO') THEN

Line 3234: fnd_log.string (

3230: IF (get_mr_details_csr%FOUND) THEN
3231: dbms_lob.write(l_merged_lob, LENGTH(''),LENGTH(l_merged_lob)+1, '');
3232: l_nr_flag := 'N';
3233: IF (l_log_statement >= l_log_current_level)THEN
3234: fnd_log.string (
3235: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'Checkpoint 0: mr_header_id:' || get_mr_details_rec.mr_header_id);
3236: END IF;
3237:
3238: ahl_ump_util_pkg.get_last_accomplishment(get_mr_details_rec.csi_item_instance_id, get_mr_details_rec.mr_header_id, l_accomplishment_date, l_unit_eff_id, l_dummy_flag, l_dummy_status, l_dummy_return);

Line 3409: fnd_log.string (

3405: CLOSE get_mr_details_csr;
3406: --END IF;
3407:
3408: IF (l_log_statement >= l_log_current_level) THEN
3409: fnd_log.string (
3410: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'Checkpoint 1');
3411: END IF;
3412:
3413: /** NrPackage ===== NRDetailsType **/

Line 3703: fnd_log.string ( l_log_statement, 'ahl.plsql.'

3699: l_uc_id := AHL_PRD_PARTS_CHANGE_PVT.Get_UnitConfig_ID(l_wo_id);
3700:
3701: END IF;
3702: IF (l_log_statement >= l_log_current_level)THEN
3703: fnd_log.string ( l_log_statement, 'ahl.plsql.'
3704: ||g_pkg_name
3705: ||'.'
3706: ||l_api_name ,'Checkpoint 2 : l_uc_id : '
3707: || l_uc_id);

Line 3829: fnd_log.string (

3825: dbms_lob.write(l_merged_lob, length(''),length(l_merged_lob)+1, '');
3826:
3827: dbms_lob.close( l_merged_lob );
3828: IF (l_log_statement >= l_log_current_level)THEN
3829: fnd_log.string (
3830: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3831: 'Checkpoint 20: Done creating LOB ');
3832: END IF;
3833:

Line 3836: fnd_log.string (

3832: END IF;
3833:
3834: -- Writing the file before transformation only if logging is enabled.
3835: IF (l_log_statement >= l_log_current_level)THEN
3836: fnd_log.string (
3837: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3838: 'Writing ORIG file ');
3839: DBMS_XSLPROCESSOR.CLOB2FILE(l_merged_lob,p_dir,'ORIG-' || x_file_name);
3840: fnd_log.string (

Line 3840: fnd_log.string (

3836: fnd_log.string (
3837: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3838: 'Writing ORIG file ');
3839: DBMS_XSLPROCESSOR.CLOB2FILE(l_merged_lob,p_dir,'ORIG-' || x_file_name);
3840: fnd_log.string (
3841: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3842: 'Done Writing ORIG file ');
3843: END IF;
3844:

Line 3855: fnd_log.string (

3851: -- DBMS_XSLPROCESSOR.CLOB2FILE(l_merged_lob,p_dir,'ORIG-' || x_file_name);
3852: -- call customer hook here
3853: -- end to create file
3854: IF (l_log_statement >= l_log_current_level)THEN
3855: fnd_log.string (
3856: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3857: 'Invoking post hook ');
3858: END IF;
3859: ahl_prd_print_CUHK.GENERATE_JCG_XML_post(

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

3866: x_msg_count => l_msg_count,
3867: x_msg_data => l_msg_data,
3868: x_return_status => l_return_status);
3869:
3870: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3871: fnd_log.string
3872: (
3873: fnd_log.level_statement,
3874: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 3871: fnd_log.string

3867: x_msg_data => l_msg_data,
3868: x_return_status => l_return_status);
3869:
3870: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3871: fnd_log.string
3872: (
3873: fnd_log.level_statement,
3874: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3875: 'after call to ahl_prd_print_CUHK.GENERATE_JCG_XML_post:l_return_status:' || l_return_status);

Line 3873: fnd_log.level_statement,

3869:
3870: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3871: fnd_log.string
3872: (
3873: fnd_log.level_statement,
3874: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3875: 'after call to ahl_prd_print_CUHK.GENERATE_JCG_XML_post:l_return_status:' || l_return_status);
3876: fnd_log.string
3877: (

Line 3876: fnd_log.string

3872: (
3873: fnd_log.level_statement,
3874: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3875: 'after call to ahl_prd_print_CUHK.GENERATE_JCG_XML_post:l_return_status:' || l_return_status);
3876: fnd_log.string
3877: (
3878: fnd_log.level_statement,
3879: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3880: 'p_jcg_wrkpkg_location:x_jcg_wrkpkg_file:' || p_dir || ':' || x_file_name);

Line 3878: fnd_log.level_statement,

3874: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3875: 'after call to ahl_prd_print_CUHK.GENERATE_JCG_XML_post:l_return_status:' || l_return_status);
3876: fnd_log.string
3877: (
3878: fnd_log.level_statement,
3879: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3880: 'p_jcg_wrkpkg_location:x_jcg_wrkpkg_file:' || p_dir || ':' || x_file_name);
3881: END IF;
3882:

Line 3896: fnd_log.string (

3892:
3893: ELSE
3894: -- user hook is not enabled .. apply transformation and write file
3895: IF (l_log_statement >= l_log_current_level)THEN
3896: fnd_log.string (
3897: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3898: 'hook not enabled - applying transformation');
3899: END IF;
3900: APPLY_TRANSFORMATION(

Line 3910: fnd_log.string (

3906: x_msg_data => l_msg_data,
3907: x_return_status => l_return_status
3908: );
3909: IF (l_log_statement >= l_log_current_level)THEN
3910: fnd_log.string (
3911: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3912: 'Applied transformation - l_return_status : ' || l_return_status);
3913: fnd_log.string (
3914: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 3913: fnd_log.string (

3909: IF (l_log_statement >= l_log_current_level)THEN
3910: fnd_log.string (
3911: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3912: 'Applied transformation - l_return_status : ' || l_return_status);
3913: fnd_log.string (
3914: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3915: 'Applied transformation - l_msg_data : ' || l_msg_data);
3916: END IF;
3917: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 3934: fnd_log.string(

3930: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3931: p_data => x_msg_data,
3932: p_encoded => fnd_api.g_false);
3933: IF (l_log_unexpected >= l_log_current_level)THEN
3934: fnd_log.string(
3935: l_log_unexpected,
3936: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3937: 'Standard Error : x_msg_count : '|| x_msg_count || ': x_msg_data : ' || x_msg_data
3938: );

Line 3947: fnd_log.string(

3943: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3944: p_data => x_msg_data,
3945: p_encoded => fnd_api.g_false);
3946: IF (l_log_unexpected >= l_log_current_level)THEN
3947: fnd_log.string(
3948: l_log_unexpected,
3949: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3950: 'Unexpected Error : x_msg_count : '|| x_msg_count || ': x_msg_data : ' || x_msg_data
3951: );

Line 3964: fnd_log.string(

3960: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3961: p_data => x_msg_data,
3962: p_encoded => fnd_api.g_false);
3963: IF (l_log_unexpected >= l_log_current_level)THEN
3964: fnd_log.string(
3965: l_log_unexpected,
3966: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3967: 'Unexpected Error Others : x_msg_count : '|| x_msg_count || ': x_msg_data : ' || x_msg_data
3968: );

Line 4273: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;

4269: p_object_type IN VARCHAR2,
4270: p_object_id IN NUMBER,
4271: p_split_flag IN VARCHAR2 := 'N') IS
4272:
4273: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
4274: l_log_statement NUMBER := FND_LOG.level_statement;
4275: l_log_procedure NUMBER := FND_LOG.level_procedure;
4276: l_log_error NUMBER := FND_LOG.level_error;
4277: l_log_unexpected NUMBER := FND_LOG.level_unexpected;

Line 4274: l_log_statement NUMBER := FND_LOG.level_statement;

4270: p_object_id IN NUMBER,
4271: p_split_flag IN VARCHAR2 := 'N') IS
4272:
4273: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
4274: l_log_statement NUMBER := FND_LOG.level_statement;
4275: l_log_procedure NUMBER := FND_LOG.level_procedure;
4276: l_log_error NUMBER := FND_LOG.level_error;
4277: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
4278:

Line 4275: l_log_procedure NUMBER := FND_LOG.level_procedure;

4271: p_split_flag IN VARCHAR2 := 'N') IS
4272:
4273: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
4274: l_log_statement NUMBER := FND_LOG.level_statement;
4275: l_log_procedure NUMBER := FND_LOG.level_procedure;
4276: l_log_error NUMBER := FND_LOG.level_error;
4277: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
4278:
4279: l_api_version CONSTANT NUMBER := 1.0;

Line 4276: l_log_error NUMBER := FND_LOG.level_error;

4272:
4273: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
4274: l_log_statement NUMBER := FND_LOG.level_statement;
4275: l_log_procedure NUMBER := FND_LOG.level_procedure;
4276: l_log_error NUMBER := FND_LOG.level_error;
4277: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
4278:
4279: l_api_version CONSTANT NUMBER := 1.0;
4280: l_api_name CONSTANT VARCHAR2(30) := 'print_workcard';

Line 4277: l_log_unexpected NUMBER := FND_LOG.level_unexpected;

4273: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
4274: l_log_statement NUMBER := FND_LOG.level_statement;
4275: l_log_procedure NUMBER := FND_LOG.level_procedure;
4276: l_log_error NUMBER := FND_LOG.level_error;
4277: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
4278:
4279: l_api_version CONSTANT NUMBER := 1.0;
4280: l_api_name CONSTANT VARCHAR2(30) := 'print_workcard';
4281:

Line 4311: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4307: l_user_id := FND_GLOBAL.USER_ID;
4308: l_resp_id := FND_GLOBAL.RESP_ID;
4309:
4310: IF (l_log_statement >= l_log_current_level)THEN
4311: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4312: 'Starting process'
4313: );
4314: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4315: 'Firing cocurrent rquest for: p_object_type : ' || p_object_type || ': p_object_id : ' || p_object_id

Line 4314: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4310: IF (l_log_statement >= l_log_current_level)THEN
4311: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4312: 'Starting process'
4313: );
4314: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4315: 'Firing cocurrent rquest for: p_object_type : ' || p_object_type || ': p_object_id : ' || p_object_id
4316: );
4317: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4318: 'Firing cocurrent rquest for: l_user_id : ' || l_user_id || ': l_resp_id : ' || l_resp_id

Line 4317: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4313: );
4314: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4315: 'Firing cocurrent rquest for: p_object_type : ' || p_object_type || ': p_object_id : ' || p_object_id
4316: );
4317: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4318: 'Firing cocurrent rquest for: l_user_id : ' || l_user_id || ': l_resp_id : ' || l_resp_id
4319: );
4320: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4321: 'Firing cocurrent rquest for: User name : ' || FND_GLOBAL.USER_NAME || ': Resp Name : ' || FND_GLOBAL.RESP_NAME

Line 4320: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4316: );
4317: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4318: 'Firing cocurrent rquest for: l_user_id : ' || l_user_id || ': l_resp_id : ' || l_resp_id
4319: );
4320: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4321: 'Firing cocurrent rquest for: User name : ' || FND_GLOBAL.USER_NAME || ': Resp Name : ' || FND_GLOBAL.RESP_NAME
4322: );
4323: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4324: 'Firing cocurrent rquest for: p_split_flag : ' || p_split_flag

Line 4323: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4319: );
4320: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4321: 'Firing cocurrent rquest for: User name : ' || FND_GLOBAL.USER_NAME || ': Resp Name : ' || FND_GLOBAL.RESP_NAME
4322: );
4323: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4324: 'Firing cocurrent rquest for: p_split_flag : ' || p_split_flag
4325: );
4326: END IF;
4327:

Line 4359: fnd_log.string( l_log_unexpected,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4355: END IF;
4356: l_req_id := fnd_request.submit_request('AHL','AHLJCGREQ',NULL,NULL,FALSE, l_jcg_id,l_user_id,l_resp_id);
4357: IF (l_req_id = 0 OR l_req_id IS NULL) THEN
4358: IF (l_log_unexpected >= l_log_current_level)THEN
4359: fnd_log.string( l_log_unexpected,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4360: 'Tried to submit concurrent request but failed'
4361: );
4362: END IF;
4363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4366: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4362: END IF;
4363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4364: ELSE
4365: IF (l_log_statement >= l_log_current_level)THEN
4366: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4367: 'Concurrent request ID:' || l_req_id
4368: );
4369: END IF;
4370: END IF; -- l_req_id = 0 OR ..

Line 4515: l_log_current_level := FND_LOG.g_current_runtime_level;

4511: -- set application context for user that initiated request
4512: fnd_global.apps_initialize(l_user_id, l_resp_id , 867);
4513: mo_global.init('AHL');
4514:
4515: l_log_current_level := FND_LOG.g_current_runtime_level;
4516: l_log_statement := FND_LOG.level_statement;
4517: l_log_procedure := FND_LOG.level_procedure;
4518: l_log_error := FND_LOG.level_error;
4519: l_log_unexpected := FND_LOG.level_unexpected;

Line 4516: l_log_statement := FND_LOG.level_statement;

4512: fnd_global.apps_initialize(l_user_id, l_resp_id , 867);
4513: mo_global.init('AHL');
4514:
4515: l_log_current_level := FND_LOG.g_current_runtime_level;
4516: l_log_statement := FND_LOG.level_statement;
4517: l_log_procedure := FND_LOG.level_procedure;
4518: l_log_error := FND_LOG.level_error;
4519: l_log_unexpected := FND_LOG.level_unexpected;
4520:

Line 4517: l_log_procedure := FND_LOG.level_procedure;

4513: mo_global.init('AHL');
4514:
4515: l_log_current_level := FND_LOG.g_current_runtime_level;
4516: l_log_statement := FND_LOG.level_statement;
4517: l_log_procedure := FND_LOG.level_procedure;
4518: l_log_error := FND_LOG.level_error;
4519: l_log_unexpected := FND_LOG.level_unexpected;
4520:
4521: IF (l_log_procedure >= l_log_current_level)THEN

Line 4518: l_log_error := FND_LOG.level_error;

4514:
4515: l_log_current_level := FND_LOG.g_current_runtime_level;
4516: l_log_statement := FND_LOG.level_statement;
4517: l_log_procedure := FND_LOG.level_procedure;
4518: l_log_error := FND_LOG.level_error;
4519: l_log_unexpected := FND_LOG.level_unexpected;
4520:
4521: IF (l_log_procedure >= l_log_current_level)THEN
4522: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 4519: l_log_unexpected := FND_LOG.level_unexpected;

4515: l_log_current_level := FND_LOG.g_current_runtime_level;
4516: l_log_statement := FND_LOG.level_statement;
4517: l_log_procedure := FND_LOG.level_procedure;
4518: l_log_error := FND_LOG.level_error;
4519: l_log_unexpected := FND_LOG.level_unexpected;
4520:
4521: IF (l_log_procedure >= l_log_current_level)THEN
4522: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4523: 'Starting processing response' );

Line 4522: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4518: l_log_error := FND_LOG.level_error;
4519: l_log_unexpected := FND_LOG.level_unexpected;
4520:
4521: IF (l_log_procedure >= l_log_current_level)THEN
4522: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4523: 'Starting processing response' );
4524: END IF;
4525: IF (l_log_statement >= l_log_current_level)THEN
4526: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 4526: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4522: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4523: 'Starting processing response' );
4524: END IF;
4525: IF (l_log_statement >= l_log_current_level)THEN
4526: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4527: 'p_request_id:' || p_request_id );
4528: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4529: 'l_user_id:' || l_user_id );
4530: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 4528: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4524: END IF;
4525: IF (l_log_statement >= l_log_current_level)THEN
4526: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4527: 'p_request_id:' || p_request_id );
4528: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4529: 'l_user_id:' || l_user_id );
4530: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4531: 'l_resp_id:' || l_resp_id );
4532: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 4530: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4526: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4527: 'p_request_id:' || p_request_id );
4528: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4529: 'l_user_id:' || l_user_id );
4530: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4531: 'l_resp_id:' || l_resp_id );
4532: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4533: 'l_jcg_id:' || l_jcg_id );
4534: l_log_segment_size := 3500;

Line 4532: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4528: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4529: 'l_user_id:' || l_user_id );
4530: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4531: 'l_resp_id:' || l_resp_id );
4532: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4533: 'l_jcg_id:' || l_jcg_id );
4534: l_log_segment_size := 3500;
4535: l_clob_chunk_count := ceil(DBMS_LOB.GETLENGTH(p_enigma_response)/l_log_segment_size);
4536: i :=1;

Line 4538: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4534: l_log_segment_size := 3500;
4535: l_clob_chunk_count := ceil(DBMS_LOB.GETLENGTH(p_enigma_response)/l_log_segment_size);
4536: i :=1;
4537: while i<=l_clob_chunk_count LOOP
4538: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4539: 'l_eventData: part : ' || i || ': ' || DBMS_LOB.substr(p_enigma_response,l_log_segment_size,1+l_log_segment_size*(i -1) ));
4540: i := i+1;
4541: END LOOP;
4542: END IF;

Line 4550: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4546: OPEN get_jcg_details(l_jcg_id);
4547: FETCH get_jcg_details INTO l_jcg_details_rec;
4548: IF get_jcg_details%NOTFOUND THEN
4549: IF (l_log_statement >= l_log_current_level)THEN
4550: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4551: 'l_jcg_id:' || l_jcg_id );
4552: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4553: 'This request was fired in past and a later request got processed. Hence ignoring this request' );
4554: END IF;

Line 4552: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4548: IF get_jcg_details%NOTFOUND THEN
4549: IF (l_log_statement >= l_log_current_level)THEN
4550: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4551: 'l_jcg_id:' || l_jcg_id );
4552: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4553: 'This request was fired in past and a later request got processed. Hence ignoring this request' );
4554: END IF;
4555: CLOSE get_jcg_details;
4556: RETURN 'SUCCESS';

Line 4561: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4557: END IF;
4558: CLOSE get_jcg_details;
4559:
4560: IF (l_log_statement >= l_log_current_level)THEN
4561: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4562: 'Parsing Enigma response' );
4563: END IF;
4564:
4565: parse_enigma_response(

Line 4572: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4568: x_pdf_table => l_pdf_table -- OUT NOCOPY PDF_TABLE_TYPE
4569: );
4570:
4571: IF (l_log_statement >= l_log_current_level)THEN
4572: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4573: 'Done Parsing: now printing response' );
4574: END IF;
4575:
4576: l_pdf_resp_count :=0;

Line 4583: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,substr(

4579: END IF;
4580: IF (l_log_statement >= l_log_current_level)THEN
4581: IF (l_pdf_resp_count > 0 )THEN
4582: FOR k IN l_pdf_table.FIRST..l_pdf_table.LAST LOOP
4583: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,substr(
4584: '[Job Card ID :' || l_pdf_table(k).job_card_id || ']' ||
4585: '[PDF PATH : ' || l_pdf_table(k).pdf_path || ']' ||
4586: '[Status : ' || l_pdf_table(k).status || ']' ||
4587: '[pdf_ErrorMessage : ' || l_pdf_table(k).pdf_ErrorMessage || ']',1,4000));

Line 4721: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4717: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4718: RAISE FND_API.G_EXC_ERROR;
4719: END IF;
4720: IF (l_log_procedure >= l_log_current_level)THEN
4721: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4722: 'Finsihed processing response' );
4723: END IF;
4724:
4725: COMMIT;

Line 4798: l_log_current_level := FND_LOG.g_current_runtime_level;

4794: -- set application context for user that initiated request
4795: fnd_global.apps_initialize(l_user_id, l_resp_id , 867);
4796: mo_global.init('AHL');
4797:
4798: l_log_current_level := FND_LOG.g_current_runtime_level;
4799: l_log_statement := FND_LOG.level_statement;
4800: l_log_procedure := FND_LOG.level_procedure;
4801: l_log_error := FND_LOG.level_error;
4802: l_log_unexpected := FND_LOG.level_unexpected;

Line 4799: l_log_statement := FND_LOG.level_statement;

4795: fnd_global.apps_initialize(l_user_id, l_resp_id , 867);
4796: mo_global.init('AHL');
4797:
4798: l_log_current_level := FND_LOG.g_current_runtime_level;
4799: l_log_statement := FND_LOG.level_statement;
4800: l_log_procedure := FND_LOG.level_procedure;
4801: l_log_error := FND_LOG.level_error;
4802: l_log_unexpected := FND_LOG.level_unexpected;
4803:

Line 4800: l_log_procedure := FND_LOG.level_procedure;

4796: mo_global.init('AHL');
4797:
4798: l_log_current_level := FND_LOG.g_current_runtime_level;
4799: l_log_statement := FND_LOG.level_statement;
4800: l_log_procedure := FND_LOG.level_procedure;
4801: l_log_error := FND_LOG.level_error;
4802: l_log_unexpected := FND_LOG.level_unexpected;
4803:
4804: IF (l_log_procedure >= l_log_current_level)THEN

Line 4801: l_log_error := FND_LOG.level_error;

4797:
4798: l_log_current_level := FND_LOG.g_current_runtime_level;
4799: l_log_statement := FND_LOG.level_statement;
4800: l_log_procedure := FND_LOG.level_procedure;
4801: l_log_error := FND_LOG.level_error;
4802: l_log_unexpected := FND_LOG.level_unexpected;
4803:
4804: IF (l_log_procedure >= l_log_current_level)THEN
4805: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 4802: l_log_unexpected := FND_LOG.level_unexpected;

4798: l_log_current_level := FND_LOG.g_current_runtime_level;
4799: l_log_statement := FND_LOG.level_statement;
4800: l_log_procedure := FND_LOG.level_procedure;
4801: l_log_error := FND_LOG.level_error;
4802: l_log_unexpected := FND_LOG.level_unexpected;
4803:
4804: IF (l_log_procedure >= l_log_current_level)THEN
4805: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4806: 'Starting processing errors' );

Line 4805: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4801: l_log_error := FND_LOG.level_error;
4802: l_log_unexpected := FND_LOG.level_unexpected;
4803:
4804: IF (l_log_procedure >= l_log_current_level)THEN
4805: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4806: 'Starting processing errors' );
4807: END IF;
4808: IF (l_log_statement >= l_log_current_level)THEN
4809: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 4809: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4805: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4806: 'Starting processing errors' );
4807: END IF;
4808: IF (l_log_statement >= l_log_current_level)THEN
4809: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4810: 'p_request_id:' || p_request_id );
4811: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4812: 'l_user_id:' || l_user_id );
4813: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 4811: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4807: END IF;
4808: IF (l_log_statement >= l_log_current_level)THEN
4809: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4810: 'p_request_id:' || p_request_id );
4811: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4812: 'l_user_id:' || l_user_id );
4813: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4814: 'l_resp_id:' || l_resp_id );
4815: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 4813: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4809: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4810: 'p_request_id:' || p_request_id );
4811: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4812: 'l_user_id:' || l_user_id );
4813: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4814: 'l_resp_id:' || l_resp_id );
4815: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4816: 'l_jcg_id:' || l_jcg_id );
4817: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 4815: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4811: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4812: 'l_user_id:' || l_user_id );
4813: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4814: 'l_resp_id:' || l_resp_id );
4815: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4816: 'l_jcg_id:' || l_jcg_id );
4817: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4818: 'l_error_message:' || p_error_msg );
4819: END IF;

Line 4817: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4813: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4814: 'l_resp_id:' || l_resp_id );
4815: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4816: 'l_jcg_id:' || l_jcg_id );
4817: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4818: 'l_error_message:' || p_error_msg );
4819: END IF;
4820: l_error_msg := substr(p_error_msg,1,4000);
4821:

Line 4833: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4829: OPEN get_jcg_details(l_jcg_id);
4830: FETCH get_jcg_details INTO l_jcg_details_rec;
4831: IF get_jcg_details%NOTFOUND THEN
4832: IF (l_log_statement >= l_log_current_level)THEN
4833: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4834: 'l_jcg_id:' || l_jcg_id );
4835: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4836: 'This request was fired in past and a later request got processed. Hence ignoring this request' );
4837: END IF;

Line 4835: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4831: IF get_jcg_details%NOTFOUND THEN
4832: IF (l_log_statement >= l_log_current_level)THEN
4833: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4834: 'l_jcg_id:' || l_jcg_id );
4835: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4836: 'This request was fired in past and a later request got processed. Hence ignoring this request' );
4837: END IF;
4838: CLOSE get_jcg_details;
4839: RETURN 'SUCCESS';

Line 4871: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4867: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4868: RAISE FND_API.G_EXC_ERROR;
4869: END IF;
4870: IF (l_log_procedure >= l_log_current_level)THEN
4871: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4872: 'Finsihed processing errors' );
4873: END IF;
4874:
4875: COMMIT;

Line 4889: fnd_log.string( l_log_error,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4885: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4886: p_data => l_msg_data,
4887: p_encoded => fnd_api.g_false);
4888: IF (l_log_error >= l_log_current_level)THEN
4889: fnd_log.string( l_log_error,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4890: 'l_eventkey:' || p_request_id );
4891: fnd_log.string( l_log_error,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4892: 'l_msg_data:' || l_msg_data );
4893: END IF;

Line 4891: fnd_log.string( l_log_error,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4887: p_encoded => fnd_api.g_false);
4888: IF (l_log_error >= l_log_current_level)THEN
4889: fnd_log.string( l_log_error,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4890: 'l_eventkey:' || p_request_id );
4891: fnd_log.string( l_log_error,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4892: 'l_msg_data:' || l_msg_data );
4893: END IF;
4894: RETURN 'ERROR';
4895:

Line 4902: fnd_log.string( l_log_unexpected,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4898: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4899: p_data => l_msg_data,
4900: p_encoded => fnd_api.g_false);
4901: IF (l_log_unexpected >= l_log_current_level)THEN
4902: fnd_log.string( l_log_unexpected,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4903: 'p_request_id:' || p_request_id );
4904: fnd_log.string( l_log_unexpected,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4905: 'l_msg_data:' || l_msg_data );
4906: END IF;

Line 4904: fnd_log.string( l_log_unexpected,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4900: p_encoded => fnd_api.g_false);
4901: IF (l_log_unexpected >= l_log_current_level)THEN
4902: fnd_log.string( l_log_unexpected,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4903: 'p_request_id:' || p_request_id );
4904: fnd_log.string( l_log_unexpected,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4905: 'l_msg_data:' || l_msg_data );
4906: END IF;
4907: RETURN 'ERROR';
4908: WHEN OTHERS THEN

Line 4917: fnd_log.string( l_log_unexpected,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4913: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4914: p_data => l_msg_data,
4915: p_encoded => fnd_api.g_false);
4916: IF (l_log_unexpected >= l_log_current_level)THEN
4917: fnd_log.string( l_log_unexpected,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4918: 'p_request_id:' || p_request_id );
4919: fnd_log.string( l_log_unexpected,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4920: 'l_msg_data:' || l_msg_data );
4921: END IF;

Line 4919: fnd_log.string( l_log_unexpected,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

4915: p_encoded => fnd_api.g_false);
4916: IF (l_log_unexpected >= l_log_current_level)THEN
4917: fnd_log.string( l_log_unexpected,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4918: 'p_request_id:' || p_request_id );
4919: fnd_log.string( l_log_unexpected,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4920: 'l_msg_data:' || l_msg_data );
4921: END IF;
4922: RETURN 'ERROR';
4923:

Line 4949: l_log_current_level := FND_LOG.g_current_runtime_level;

4945: l_index INTEGER;
4946: l_node_name VARCHAR2(2000);
4947: l_parse_jobcards BOOLEAN;
4948: BEGIN
4949: l_log_current_level := FND_LOG.g_current_runtime_level;
4950: l_log_statement := FND_LOG.level_statement;
4951: l_log_procedure := FND_LOG.level_procedure;
4952: l_log_error := FND_LOG.level_error;
4953: l_log_unexpected := FND_LOG.level_unexpected;

Line 4950: l_log_statement := FND_LOG.level_statement;

4946: l_node_name VARCHAR2(2000);
4947: l_parse_jobcards BOOLEAN;
4948: BEGIN
4949: l_log_current_level := FND_LOG.g_current_runtime_level;
4950: l_log_statement := FND_LOG.level_statement;
4951: l_log_procedure := FND_LOG.level_procedure;
4952: l_log_error := FND_LOG.level_error;
4953: l_log_unexpected := FND_LOG.level_unexpected;
4954: IF (l_log_procedure >= l_log_current_level)THEN

Line 4951: l_log_procedure := FND_LOG.level_procedure;

4947: l_parse_jobcards BOOLEAN;
4948: BEGIN
4949: l_log_current_level := FND_LOG.g_current_runtime_level;
4950: l_log_statement := FND_LOG.level_statement;
4951: l_log_procedure := FND_LOG.level_procedure;
4952: l_log_error := FND_LOG.level_error;
4953: l_log_unexpected := FND_LOG.level_unexpected;
4954: IF (l_log_procedure >= l_log_current_level)THEN
4955: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'Entering procedure');

Line 4952: l_log_error := FND_LOG.level_error;

4948: BEGIN
4949: l_log_current_level := FND_LOG.g_current_runtime_level;
4950: l_log_statement := FND_LOG.level_statement;
4951: l_log_procedure := FND_LOG.level_procedure;
4952: l_log_error := FND_LOG.level_error;
4953: l_log_unexpected := FND_LOG.level_unexpected;
4954: IF (l_log_procedure >= l_log_current_level)THEN
4955: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'Entering procedure');
4956: END IF;

Line 4953: l_log_unexpected := FND_LOG.level_unexpected;

4949: l_log_current_level := FND_LOG.g_current_runtime_level;
4950: l_log_statement := FND_LOG.level_statement;
4951: l_log_procedure := FND_LOG.level_procedure;
4952: l_log_error := FND_LOG.level_error;
4953: l_log_unexpected := FND_LOG.level_unexpected;
4954: IF (l_log_procedure >= l_log_current_level)THEN
4955: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'Entering procedure');
4956: END IF;
4957: l_parser := DBMS_XMLPARSER.newParser;

Line 4955: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'Entering procedure');

4951: l_log_procedure := FND_LOG.level_procedure;
4952: l_log_error := FND_LOG.level_error;
4953: l_log_unexpected := FND_LOG.level_unexpected;
4954: IF (l_log_procedure >= l_log_current_level)THEN
4955: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'Entering procedure');
4956: END IF;
4957: l_parser := DBMS_XMLPARSER.newParser;
4958: --DBMS_XMLPARSER.parseBuffer(l_parser,p_enigma_response);
4959: -- fix for bug 9834092

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

5040: l_vchar_header VARCHAR2(40);
5041: BEGIN
5042: -- Initialize Procedure return status to success
5043: x_return_status := FND_API.G_RET_STS_SUCCESS;
5044: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5045: fnd_log.string (
5046: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||'APPLY_TRANSFORMATION' ,'Starting transformation');
5047: END IF;
5048: l_vchar_header := '';

Line 5045: fnd_log.string (

5041: BEGIN
5042: -- Initialize Procedure return status to success
5043: x_return_status := FND_API.G_RET_STS_SUCCESS;
5044: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5045: fnd_log.string (
5046: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||'APPLY_TRANSFORMATION' ,'Starting transformation');
5047: END IF;
5048: l_vchar_header := '';
5049: l_parser := DBMS_XMLPARSER.newParser;

Line 5046: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||'APPLY_TRANSFORMATION' ,'Starting transformation');

5042: -- Initialize Procedure return status to success
5043: x_return_status := FND_API.G_RET_STS_SUCCESS;
5044: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5045: fnd_log.string (
5046: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||'APPLY_TRANSFORMATION' ,'Starting transformation');
5047: END IF;
5048: l_vchar_header := '';
5049: l_parser := DBMS_XMLPARSER.newParser;
5050: DBMS_XMLPARSER.parseClob(l_parser, p_indoc);

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

5077: DBMS_XMLDOM.freeDocument(l_indomdoc);
5078: DBMS_XMLDOM.freeDocument(l_xsltdomdoc);
5079: DBMS_XMLPARSER.freeParser(l_parser);
5080: DBMS_XSLPROCESSOR.freeProcessor(l_proc);
5081: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5082: fnd_log.string (
5083: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||'APPLY_TRANSFORMATION' ,'done transformation');
5084: END IF;
5085: EXCEPTION

Line 5082: fnd_log.string (

5078: DBMS_XMLDOM.freeDocument(l_xsltdomdoc);
5079: DBMS_XMLPARSER.freeParser(l_parser);
5080: DBMS_XSLPROCESSOR.freeProcessor(l_proc);
5081: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5082: fnd_log.string (
5083: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||'APPLY_TRANSFORMATION' ,'done transformation');
5084: END IF;
5085: EXCEPTION
5086: WHEN OTHERS THEN

Line 5083: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||'APPLY_TRANSFORMATION' ,'done transformation');

5079: DBMS_XMLPARSER.freeParser(l_parser);
5080: DBMS_XSLPROCESSOR.freeProcessor(l_proc);
5081: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5082: fnd_log.string (
5083: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||'APPLY_TRANSFORMATION' ,'done transformation');
5084: END IF;
5085: EXCEPTION
5086: WHEN OTHERS THEN
5087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5115: l_vchar_header VARCHAR2(40);
5116: BEGIN
5117: -- Initialize Procedure return status to success
5118: x_return_status := FND_API.G_RET_STS_SUCCESS;
5119: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5120: fnd_log.string (
5121: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||'APPLY_TRANSFORMATION' ,'Starting transformation');
5122: END IF;
5123: l_vchar_header := '';

Line 5120: fnd_log.string (

5116: BEGIN
5117: -- Initialize Procedure return status to success
5118: x_return_status := FND_API.G_RET_STS_SUCCESS;
5119: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5120: fnd_log.string (
5121: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||'APPLY_TRANSFORMATION' ,'Starting transformation');
5122: END IF;
5123: l_vchar_header := '';
5124: l_parser := DBMS_XMLPARSER.newParser;

Line 5121: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||'APPLY_TRANSFORMATION' ,'Starting transformation');

5117: -- Initialize Procedure return status to success
5118: x_return_status := FND_API.G_RET_STS_SUCCESS;
5119: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5120: fnd_log.string (
5121: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||'APPLY_TRANSFORMATION' ,'Starting transformation');
5122: END IF;
5123: l_vchar_header := '';
5124: l_parser := DBMS_XMLPARSER.newParser;
5125: -- following statement commented since input is a input xml full path and not a clob

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

5152: DBMS_XMLDOM.freeDocument(l_indomdoc);
5153: DBMS_XMLDOM.freeDocument(l_xsltdomdoc);
5154: DBMS_XMLPARSER.freeParser(l_parser);
5155: DBMS_XSLPROCESSOR.freeProcessor(l_proc);
5156: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5157: fnd_log.string (
5158: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||'APPLY_TRANSFORMATION' ,'Done transformation');
5159: END IF;
5160: EXCEPTION

Line 5157: fnd_log.string (

5153: DBMS_XMLDOM.freeDocument(l_xsltdomdoc);
5154: DBMS_XMLPARSER.freeParser(l_parser);
5155: DBMS_XSLPROCESSOR.freeProcessor(l_proc);
5156: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5157: fnd_log.string (
5158: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||'APPLY_TRANSFORMATION' ,'Done transformation');
5159: END IF;
5160: EXCEPTION
5161: WHEN OTHERS THEN

Line 5158: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||'APPLY_TRANSFORMATION' ,'Done transformation');

5154: DBMS_XMLPARSER.freeParser(l_parser);
5155: DBMS_XSLPROCESSOR.freeProcessor(l_proc);
5156: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5157: fnd_log.string (
5158: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||'APPLY_TRANSFORMATION' ,'Done transformation');
5159: END IF;
5160: EXCEPTION
5161: WHEN OTHERS THEN
5162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

7623: --add dummy query to the original query
7624: -- l_query_string := l_query_string || l_dummy_query || ' FROM DUAL CONNECT BY 1 = 1 and level <= 3';
7625: x_query_string := l_query_string;
7626:
7627: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
7628: fnd_log.string
7629: (
7630: fnd_log.level_statement,
7631: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 7628: fnd_log.string

7624: -- l_query_string := l_query_string || l_dummy_query || ' FROM DUAL CONNECT BY 1 = 1 and level <= 3';
7625: x_query_string := l_query_string;
7626:
7627: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
7628: fnd_log.string
7629: (
7630: fnd_log.level_statement,
7631: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
7632: 'Formed Quality Collection query string for plan id:' || p_plan_id || ' : Collection Id:' || p_collection_id

Line 7630: fnd_log.level_statement,

7626:
7627: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
7628: fnd_log.string
7629: (
7630: fnd_log.level_statement,
7631: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
7632: 'Formed Quality Collection query string for plan id:' || p_plan_id || ' : Collection Id:' || p_collection_id
7633: );
7634: END IF;

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

7701: FND_MSG_PUB.ADD;
7702: --dbms_output.put_line('ERROR:'|| fnd_flex_keyval.error_message);
7703: --dbms_output.put_line('ERROR:'|| fnd_flex_keyval.error_segment);
7704: */
7705: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
7706: fnd_log.string
7707: (
7708: fnd_log.level_statement,
7709: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 7706: fnd_log.string

7702: --dbms_output.put_line('ERROR:'|| fnd_flex_keyval.error_message);
7703: --dbms_output.put_line('ERROR:'|| fnd_flex_keyval.error_segment);
7704: */
7705: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
7706: fnd_log.string
7707: (
7708: fnd_log.level_statement,
7709: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
7710: 'FND Flex KeyVal Error:Mesg:Segment:' || fnd_flex_keyval.error_message || ':' || fnd_flex_keyval.error_segment

Line 7708: fnd_log.level_statement,

7704: */
7705: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
7706: fnd_log.string
7707: (
7708: fnd_log.level_statement,
7709: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
7710: 'FND Flex KeyVal Error:Mesg:Segment:' || fnd_flex_keyval.error_message || ':' || fnd_flex_keyval.error_segment
7711: );
7712: END IF;

Line 7811: l_log_unexpected NUMBER := FND_LOG.level_unexpected;

7807: l_visit_det_lob CLOB;
7808: l_childmr_details_lob CLOB;
7809: l_offset NUMBER;
7810:
7811: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
7812: l_log_statement NUMBER := FND_LOG.level_statement;
7813: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
7814:
7815:

Line 7812: l_log_statement NUMBER := FND_LOG.level_statement;

7808: l_childmr_details_lob CLOB;
7809: l_offset NUMBER;
7810:
7811: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
7812: l_log_statement NUMBER := FND_LOG.level_statement;
7813: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
7814:
7815:
7816: -- start to create file

Line 7813: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;

7809: l_offset NUMBER;
7810:
7811: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
7812: l_log_statement NUMBER := FND_LOG.level_statement;
7813: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
7814:
7815:
7816: -- start to create file
7817: -- x_file_name VARCHAR2(100) := 'Output.XML';

Line 8427: fnd_log.string ( l_log_statement, 'ahl.plsql.'

8423: INTO wo_details_rec;
8424:
8425: --EXIT WHEN wo_details_csr%NOTFOUND;
8426: IF (l_log_statement >= l_log_current_level)THEN
8427: fnd_log.string ( l_log_statement, 'ahl.plsql.'
8428: ||g_pkg_name
8429: ||'.'
8430: ||l_api_name ,'Checkpoint 3 : l_workorder_id : '
8431: || l_workorder_id);

Line 8613: fnd_log.string (

8609: END IF;
8610:
8611: --counter details
8612: IF (l_log_statement >= l_log_current_level)THEN
8613: fnd_log.string (
8614: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'Checkpoint 4 : l_workorder_id : ' || l_workorder_id);
8615: END IF;
8616: context := dbms_xmlgen.newContext(l_counter_det );
8617: DBMS_XMLGEN.setbindvalue (context, '1', l_workorder_id);

Line 8639: fnd_log.string (

8635: LOOP
8636: FETCH route_details_csr INTO route_details_rec;
8637: EXIT WHEN route_details_csr%NOTFOUND;
8638: IF (l_log_statement >= l_log_current_level)THEN
8639: fnd_log.string (
8640: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'Checkpoint 5 : l_route_id : ' || l_route_id);
8641: END IF;
8642:
8643: dbms_lob.write(l_merged_lob, LENGTH(''),LENGTH(l_merged_lob)+1, '');

Line 8734: fnd_log.string ( l_log_statement, 'ahl.plsql.'

8730: dbms_lob.write(l_merged_lob, LENGTH(''),LENGTH(l_merged_lob)+1, '');
8731: END IF;
8732:
8733: IF (l_log_statement >= l_log_current_level)THEN
8734: fnd_log.string ( l_log_statement, 'ahl.plsql.'
8735: ||g_pkg_name
8736: ||'.'
8737: ||l_api_name ,'Checkpoint 6 : l_route_id : '
8738: || l_route_id);

Line 8748: fnd_log.string ( l_log_statement, 'ahl.plsql.'

8744:
8745: CLOSE route_ffs_csr;
8746:
8747: IF (l_log_statement >= l_log_current_level)THEN
8748: fnd_log.string ( l_log_statement, 'ahl.plsql.'
8749: ||g_pkg_name
8750: ||'.'
8751: ||l_api_name ,'Checkpoint 7 : l_route_id : '
8752: || l_route_id);

Line 8887: fnd_log.string ( l_log_statement, 'ahl.plsql.'

8883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8884: END;
8885:
8886: IF (l_log_statement >= l_log_current_level)THEN
8887: fnd_log.string ( l_log_statement, 'ahl.plsql.'
8888: ||g_pkg_name
8889: ||'.'
8890: ||l_api_name ,'Checkpoint 7.1 : l_route_id:concatenated_segments:'
8891: || l_route_id || ':' || l_concat_segment);

Line 8897: fnd_log.string ( l_log_statement, 'ahl.plsql.'

8893:
8894: Get_Route_KFF_Desc(l_concat_segment, l_mti_seglist, kff_return_status);
8895:
8896: IF (l_log_statement >= l_log_current_level)THEN
8897: fnd_log.string ( l_log_statement, 'ahl.plsql.'
8898: ||g_pkg_name
8899: ||'.'
8900: ||l_api_name ,'Checkpoint 7.2 : l_route_id:kff_return_status:'
8901: || l_route_id || ':' || kff_return_status);

Line 9031: fnd_log.string ( l_log_statement, 'ahl.plsql.'

9027:
9028: dbms_lob.write(l_merged_lob, LENGTH(''),LENGTH(l_merged_lob)+1, '');
9029:
9030: IF (l_log_statement >= l_log_current_level)THEN
9031: fnd_log.string ( l_log_statement, 'ahl.plsql.'
9032: ||g_pkg_name
9033: ||'.'
9034: ||l_api_name ,'Checkpoint 7.3 : Route DFF: l_route_id:'
9035: || l_route_id);

Line 9254: fnd_log.string (

9250: dbms_lob.write(l_merged_lob, LENGTH(''),LENGTH(l_merged_lob)+1, '');
9251: END IF;
9252:
9253: IF (l_log_statement >= l_log_current_level)THEN
9254: fnd_log.string (
9255: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'Checkpoint 8 : wo_op_details_rec.operation_id : ' || wo_op_details_rec.operation_id);
9256: END IF;
9257: IF (wo_op_details_rec.operation_id IS NOT NULL) THEN
9258: context := dbms_xmlgen.newContext(l_op_dffs );

Line 9336: fnd_log.string ( l_log_statement, 'ahl.plsql.'

9332: INTO op_details_rec;
9333:
9334: EXIT WHEN op_details_csr%NOTFOUND;
9335: IF (l_log_statement >= l_log_current_level)THEN
9336: fnd_log.string ( l_log_statement, 'ahl.plsql.'
9337: ||g_pkg_name
9338: ||'.'
9339: ||l_api_name ,'Checkpoint 9 : l_workorder_id : '
9340: || l_workorder_id);

Line 9407: fnd_log.string ( l_log_statement, 'ahl.plsql.'

9403: l_collection_id;
9404:
9405: EXIT WHEN get_op_qa_res_csr%NOTFOUND;
9406: IF (l_log_statement >= l_log_current_level)THEN
9407: fnd_log.string ( l_log_statement, 'ahl.plsql.'
9408: ||g_pkg_name
9409: ||'.'
9410: ||l_api_name ,'Checkpoint 10 : l_qa_plan_id : '
9411: || l_qa_plan_id);

Line 9423: fnd_log.string ( l_log_statement, 'ahl.plsql.'

9419: EXIT
9420: WHEN qa_plan_csr%NOTFOUND;
9421:
9422: IF (l_log_statement >= l_log_current_level)THEN
9423: fnd_log.string ( l_log_statement, 'ahl.plsql.'
9424: ||g_pkg_name
9425: ||'.'
9426: ||l_api_name ,'Checkpoint 11 : l_qa_plan_id : '
9427: || l_qa_plan_id);

Line 9488: fnd_log.string ( l_log_statement, 'ahl.plsql.'

9484:
9485: dbms_lob.write(l_merged_lob, LENGTH(''),LENGTH(l_merged_lob)+1, '');
9486:
9487: IF (l_log_statement >= l_log_current_level)THEN
9488: fnd_log.string ( l_log_statement, 'ahl.plsql.'
9489: ||g_pkg_name
9490: ||'.'
9491: ||l_api_name ,'Checkpoint 12 : l_qa_plan_id : '
9492: || l_qa_plan_id);

Line 9502: fnd_log.string ( l_log_statement, 'ahl.plsql.'

9498: x_query_string => l_query_string );
9499:
9500:
9501: IF (l_log_statement >= l_log_current_level)THEN
9502: fnd_log.string ( l_log_statement, 'ahl.plsql.'
9503: ||g_pkg_name
9504: ||'.'
9505: ||l_api_name ,'Checkpoint 13 ');
9506: END IF;

Line 9616: fnd_log.string (

9612: CLOSE get_wo_qa_res_csr;
9613: dbms_lob.write(l_merged_lob, LENGTH(''),LENGTH(l_merged_lob)+1, '');
9614:
9615: IF (l_log_statement >= l_log_current_level)THEN
9616: fnd_log.string (
9617: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'Checkpoint 14: wo qa result' || l_workorder_id);
9618: END IF;
9619: IF l_qa_plan_id IS NOT NULL AND l_collection_id IS NOT NULL
9620: THEN

Line 9661: fnd_log.string (

9657:
9658: --documents associated with workorder
9659:
9660: IF (l_log_statement >= l_log_current_level)THEN
9661: fnd_log.string (
9662: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,'Checkpoint 15: Document : ' || l_workorder_id);
9663: END IF;
9664:
9665: dbms_lob.write(l_merged_lob, LENGTH(''),LENGTH(l_merged_lob)+1, '');

Line 9674: fnd_log.string ( l_log_statement, 'ahl.plsql.'

9670:
9671: EXIT
9672: WHEN mat_details_csr%NOTFOUND;
9673: IF (l_log_statement >= l_log_current_level)THEN
9674: fnd_log.string ( l_log_statement, 'ahl.plsql.'
9675: ||g_pkg_name
9676: ||'.'
9677: ||l_api_name ,'Checkpoint 16: Document : '
9678: || l_workorder_id);

Line 9723: fnd_log.string ( l_log_statement, 'ahl.plsql.'

9719: dbms_lob.write(l_merged_lob, LENGTH(''),LENGTH(l_merged_lob)+1, '');
9720: dbms_lob.write(l_merged_lob, LENGTH(mat_details_rec.required_date),LENGTH(l_merged_lob)+1, mat_details_rec.required_date);
9721: dbms_lob.write(l_merged_lob, LENGTH(''),LENGTH(l_merged_lob)+1, '');
9722: IF (l_log_statement >= l_log_current_level)THEN
9723: fnd_log.string ( l_log_statement, 'ahl.plsql.'
9724: ||g_pkg_name
9725: ||'.'
9726: ||l_api_name , 'Checkpoint 17: mat_details_rec.SCHEDULED_MATERIAL_ID : '
9727: || mat_details_rec.SCHEDULED_MATERIAL_ID);

Line 9775: fnd_log.string ( l_log_statement, 'ahl.plsql.'

9771: INTO res_req_details_rec;
9772:
9773: EXIT WHEN res_req_details_csr%NOTFOUND;
9774: IF (l_log_statement >= l_log_current_level)THEN
9775: fnd_log.string ( l_log_statement, 'ahl.plsql.'
9776: ||g_pkg_name
9777: ||'.'
9778: ||l_api_name , 'Checkpoint 18: resources :'
9779: || l_workorder_id);

Line 9825: fnd_log.string (

9821: dbms_lob.write(l_merged_lob, LENGTH(''),LENGTH(l_merged_lob)+1, '');
9822: END IF;
9823:
9824: IF (l_log_statement >= l_log_current_level)THEN
9825: fnd_log.string (
9826: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
9827: 'Checkpoint 19: before resource DFF' || l_workorder_id);
9828: END IF;
9829: IF(l_route_op_res_found IN('R','O'))THEN -- fix for bug 10048778