eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_PRINT_PVT dependencies on FND_LOG

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

379: BEGIN
380: --set the operating unit.
381: mo_global.init('AHL');
382:
383: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
384:
385: fnd_log.string
386: (
387: fnd_log.level_procedure,

Line 385: fnd_log.string

381: mo_global.init('AHL');
382:
383: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
384:
385: fnd_log.string
386: (
387: fnd_log.level_procedure,
388: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
389: 'At the start of Gen_Wo_Xml'

Line 387: fnd_log.level_procedure,

383: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
384:
385: fnd_log.string
386: (
387: fnd_log.level_procedure,
388: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
389: 'At the start of Gen_Wo_Xml'
390: );
391: END IF;

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

392:
393: --SAVEPOINT Gen_Wo_Xml;
394:
395:
396: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
397: fnd_log.string
398: (
399: fnd_log.level_statement,
400: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 397: fnd_log.string

393: --SAVEPOINT Gen_Wo_Xml;
394:
395:
396: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
397: fnd_log.string
398: (
399: fnd_log.level_statement,
400: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
401: 'API input Parameters '

Line 399: fnd_log.level_statement,

395:
396: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
397: fnd_log.string
398: (
399: fnd_log.level_statement,
400: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
401: 'API input Parameters '
402: );
403: fnd_log.string

Line 403: fnd_log.string

399: fnd_log.level_statement,
400: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
401: 'API input Parameters '
402: );
403: fnd_log.string
404: (
405: fnd_log.level_statement,
406: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
407: '************************'

Line 405: fnd_log.level_statement,

401: 'API input Parameters '
402: );
403: fnd_log.string
404: (
405: fnd_log.level_statement,
406: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
407: '************************'
408: );
409: fnd_log.string

Line 409: fnd_log.string

405: fnd_log.level_statement,
406: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
407: '************************'
408: );
409: fnd_log.string
410: (
411: fnd_log.level_statement,
412: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
413: 'p_employee_id -> '||p_employee_id

Line 411: fnd_log.level_statement,

407: '************************'
408: );
409: fnd_log.string
410: (
411: fnd_log.level_statement,
412: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
413: 'p_employee_id -> '||p_employee_id
414: );
415: fnd_log.string

Line 415: fnd_log.string

411: fnd_log.level_statement,
412: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
413: 'p_employee_id -> '||p_employee_id
414: );
415: fnd_log.string
416: (
417: fnd_log.level_statement,
418: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
419: 'p_user_role -> '||p_user_role

Line 417: fnd_log.level_statement,

413: 'p_employee_id -> '||p_employee_id
414: );
415: fnd_log.string
416: (
417: fnd_log.level_statement,
418: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
419: 'p_user_role -> '||p_user_role
420: );
421: fnd_log.string

Line 421: fnd_log.string

417: fnd_log.level_statement,
418: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
419: 'p_user_role -> '||p_user_role
420: );
421: fnd_log.string
422: (
423: fnd_log.level_statement,
424: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
425: 'p_concurrent_flag -> '||p_concurrent_flag

Line 423: fnd_log.level_statement,

419: 'p_user_role -> '||p_user_role
420: );
421: fnd_log.string
422: (
423: fnd_log.level_statement,
424: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
425: 'p_concurrent_flag -> '||p_concurrent_flag
426: );
427: fnd_log.string

Line 427: fnd_log.string

423: fnd_log.level_statement,
424: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
425: 'p_concurrent_flag -> '||p_concurrent_flag
426: );
427: fnd_log.string
428: (
429: fnd_log.level_statement,
430: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
431: 'p_workorders_tbl size -> '||p_workorders_tbl.count

Line 429: fnd_log.level_statement,

425: 'p_concurrent_flag -> '||p_concurrent_flag
426: );
427: fnd_log.string
428: (
429: fnd_log.level_statement,
430: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
431: 'p_workorders_tbl size -> '||p_workorders_tbl.count
432: );
433:

Line 434: fnd_log.string

430: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
431: 'p_workorders_tbl size -> '||p_workorders_tbl.count
432: );
433:
434: fnd_log.string
435: (
436: fnd_log.level_statement,
437: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
438: 'mo operating unit -> '||mo_global.get_current_org_id()

Line 436: fnd_log.level_statement,

432: );
433:
434: fnd_log.string
435: (
436: fnd_log.level_statement,
437: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
438: 'mo operating unit -> '||mo_global.get_current_org_id()
439: );
440: fnd_log.string

Line 440: fnd_log.string

436: fnd_log.level_statement,
437: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
438: 'mo operating unit -> '||mo_global.get_current_org_id()
439: );
440: fnd_log.string
441: (
442: fnd_log.level_statement,
443: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
444: 'AHL_PRD_PRINT_PVT.get_tz_offset -> '||AHL_PRD_PRINT_PVT.get_tz_offset

Line 442: fnd_log.level_statement,

438: 'mo operating unit -> '||mo_global.get_current_org_id()
439: );
440: fnd_log.string
441: (
442: fnd_log.level_statement,
443: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
444: 'AHL_PRD_PRINT_PVT.get_tz_offset -> '||AHL_PRD_PRINT_PVT.get_tz_offset
445: );
446: END IF;

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

484: -- Process all workorders in the input.
485: IF p_workorders_tbl.COUNT > 0 THEN
486: FOR wo_count IN p_workorders_tbl.FIRST .. p_workorders_tbl.LAST
487: LOOP
488: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
489: fnd_log.string
490: (
491: fnd_log.level_statement,
492: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 489: fnd_log.string

485: IF p_workorders_tbl.COUNT > 0 THEN
486: FOR wo_count IN p_workorders_tbl.FIRST .. p_workorders_tbl.LAST
487: LOOP
488: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
489: fnd_log.string
490: (
491: fnd_log.level_statement,
492: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
493: 'p_workorders_tbl('||wo_count||') --> '||p_workorders_tbl(wo_count)

Line 491: fnd_log.level_statement,

487: LOOP
488: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
489: fnd_log.string
490: (
491: fnd_log.level_statement,
492: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
493: 'p_workorders_tbl('||wo_count||') --> '||p_workorders_tbl(wo_count)
494: );
495: END IF;

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

512: IF l_emp_tbl.COUNT > 0 THEN
513: FOR l_count IN l_emp_tbl.FIRST..l_emp_tbl.LAST
514: LOOP
515:
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: FOR l_count IN l_emp_tbl.FIRST..l_emp_tbl.LAST
514: LOOP
515:
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: 'l_emp_tbl('||l_count||') --> '||l_emp_tbl(l_count).employee_id

Line 519: fnd_log.level_statement,

515:
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: 'l_emp_tbl('||l_count||') --> '||l_emp_tbl(l_count).employee_id
522: );
523: END IF;

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

545: ''
546: );
547: END IF;
548:
549: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
550: fnd_log.string
551: (
552: fnd_log.level_statement,
553: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 550: fnd_log.string

546: );
547: END IF;
548:
549: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
550: fnd_log.string
551: (
552: fnd_log.level_statement,
553: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
554: 'After Processing Employee info '

Line 552: fnd_log.level_statement,

548:
549: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
550: fnd_log.string
551: (
552: fnd_log.level_statement,
553: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
554: 'After Processing Employee info '
555: );
556: END IF;

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

582: ) WODE ';
583:
584: l_wo_con_query := l_wo_con_query || l_wo_details_where;
585:
586: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
587: fnd_log.string
588: (
589: fnd_log.level_statement,
590: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 587: fnd_log.string

583:
584: l_wo_con_query := l_wo_con_query || l_wo_details_where;
585:
586: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
587: fnd_log.string
588: (
589: fnd_log.level_statement,
590: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
591: 'Workorder details query string --->'||l_wo_con_query

Line 589: fnd_log.level_statement,

585:
586: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
587: fnd_log.string
588: (
589: fnd_log.level_statement,
590: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
591: 'Workorder details query string --->'||l_wo_con_query
592: );
593: END IF;

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

613: -- copy workorder details into final lob
614: 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);
615: END IF;
616:
617: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
618: fnd_log.string
619: (
620: fnd_log.level_statement,
621: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 618: fnd_log.string

614: 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);
615: END IF;
616:
617: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
618: fnd_log.string
619: (
620: fnd_log.level_statement,
621: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
622: 'After Processing Workorder Header Info '

Line 620: fnd_log.level_statement,

616:
617: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
618: fnd_log.string
619: (
620: fnd_log.level_statement,
621: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
622: 'After Processing Workorder Header Info '
623: );
624: END IF;

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

660: 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);
661: END IF;
662: END IF;
663:
664: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
665: fnd_log.string
666: (
667: fnd_log.level_statement,
668: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 665: fnd_log.string

661: END IF;
662: END IF;
663:
664: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
665: fnd_log.string
666: (
667: fnd_log.level_statement,
668: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
669: 'After Processing Workorder Quality Info '

Line 667: fnd_log.level_statement,

663:
664: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
665: fnd_log.string
666: (
667: fnd_log.level_statement,
668: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
669: 'After Processing Workorder Quality Info '
670: );
671: END IF;

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

750: length(l_merged_lob)+1,
751: ''
752: );
753:
754: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
755: fnd_log.string
756: (
757: fnd_log.level_statement,
758: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 755: fnd_log.string

751: ''
752: );
753:
754: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
755: fnd_log.string
756: (
757: fnd_log.level_statement,
758: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
759: 'After Processing Workorder Operation Quality Info '

Line 757: fnd_log.level_statement,

753:
754: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
755: fnd_log.string
756: (
757: fnd_log.level_statement,
758: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
759: 'After Processing Workorder Operation Quality Info '
760: );
761: END IF;

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

781: -- copy workorder details into final lob
782: 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);
783: END IF;
784:
785: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
786: fnd_log.string
787: (
788: fnd_log.level_statement,
789: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 786: fnd_log.string

782: 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);
783: END IF;
784:
785: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
786: fnd_log.string
787: (
788: fnd_log.level_statement,
789: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
790: 'After Processing turnover notes '

Line 788: fnd_log.level_statement,

784:
785: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
786: fnd_log.string
787: (
788: fnd_log.level_statement,
789: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
790: 'After Processing turnover notes '
791: );
792: END IF;

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

817: ||', '''||l_user_role||''' ),0) "HOURS_WORKED", ';
818:
819: l_op_con_query := l_op_con_query || l_op_details_2 || l_op_rec.workorder_operation_id;
820:
821: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
822: fnd_log.string
823: (
824: fnd_log.level_statement,
825: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 822: fnd_log.string

818:
819: l_op_con_query := l_op_con_query || l_op_details_2 || l_op_rec.workorder_operation_id;
820:
821: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
822: fnd_log.string
823: (
824: fnd_log.level_statement,
825: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
826: 'operation details query string --->'||l_op_con_query

Line 824: fnd_log.level_statement,

820:
821: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
822: fnd_log.string
823: (
824: fnd_log.level_statement,
825: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
826: 'operation details query string --->'||l_op_con_query
827: );
828: END IF;

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

895: END IF;
896: END IF;
897: END LOOP;
898:
899: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
900: fnd_log.string
901: (
902: fnd_log.level_statement,
903: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 900: fnd_log.string

896: END IF;
897: END LOOP;
898:
899: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
900: fnd_log.string
901: (
902: fnd_log.level_statement,
903: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
904: 'After Processing Workorder Operations '

Line 902: fnd_log.level_statement,

898:
899: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
900: fnd_log.string
901: (
902: fnd_log.level_statement,
903: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
904: 'After Processing Workorder Operations '
905: );
906: END IF;

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

929: 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);
930:
931: END IF;
932:
933: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
934: fnd_log.string
935: (
936: fnd_log.level_statement,
937: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 934: fnd_log.string

930:
931: END IF;
932:
933: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
934: fnd_log.string
935: (
936: fnd_log.level_statement,
937: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
938: 'After Processing Workorder Material requirements '

Line 936: fnd_log.level_statement,

932:
933: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
934: fnd_log.string
935: (
936: fnd_log.level_statement,
937: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
938: 'After Processing Workorder Material requirements '
939: );
940: END IF;

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

968: 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);
969:
970: END IF;
971:
972: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
973: fnd_log.string
974: (
975: fnd_log.level_statement,
976: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 973: fnd_log.string

969:
970: END IF;
971:
972: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
973: fnd_log.string
974: (
975: fnd_log.level_statement,
976: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
977: 'After Processing Document associations to workorders'

Line 975: fnd_log.level_statement,

971:
972: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
973: fnd_log.string
974: (
975: fnd_log.level_statement,
976: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
977: 'After Processing Document associations to workorders'
978: );
979: END IF;

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

1000: --dbms_lob.close(l_wo_details_lob);
1001: dbms_lob.freeTemporary( l_merged_lob );
1002:
1003: /*
1004: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1005: l_fnd_offset := 1;
1006: l_chunk_size := 3000;
1007: l_clob_size := LENGTH(x_xml_data);
1008:

Line 1010: fnd_log.string

1006: l_chunk_size := 3000;
1007: l_clob_size := LENGTH(x_xml_data);
1008:
1009: WHILE (l_clob_size > 0) LOOP
1010: fnd_log.string
1011: (
1012: fnd_log.level_statement,
1013: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1014: 'xml data ->'||substr(x_xml_data, l_chunk_size, l_fnd_offset)

Line 1012: fnd_log.level_statement,

1008:
1009: WHILE (l_clob_size > 0) LOOP
1010: fnd_log.string
1011: (
1012: fnd_log.level_statement,
1013: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1014: 'xml data ->'||substr(x_xml_data, l_chunk_size, l_fnd_offset)
1015: );
1016: l_clob_size := l_clob_size - l_chunk_size;

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

1019:
1020: END IF;
1021: */
1022:
1023: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1024: fnd_log.string
1025: (
1026: fnd_log.level_procedure,
1027: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',

Line 1024: fnd_log.string

1020: END IF;
1021: */
1022:
1023: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1024: fnd_log.string
1025: (
1026: fnd_log.level_procedure,
1027: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
1028: 'At the end of AHL_PRD_PRINT_PVT'

Line 1026: fnd_log.level_procedure,

1022:
1023: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1024: fnd_log.string
1025: (
1026: fnd_log.level_procedure,
1027: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
1028: 'At the end of AHL_PRD_PRINT_PVT'
1029: );
1030: END IF;

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

1033: WHEN OTHERS THEN
1034:
1035: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
1036:
1037: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1038: fnd_log.string
1039: (
1040: fnd_log.level_statement,
1041: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 1038: fnd_log.string

1034:
1035: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
1036:
1037: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1038: fnd_log.string
1039: (
1040: fnd_log.level_statement,
1041: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1042: 'xml data ->'||dbms_lob.substr(x_xml_data, dbms_lob.getlength(x_xml_data), 1)

Line 1040: fnd_log.level_statement,

1036:
1037: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1038: fnd_log.string
1039: (
1040: fnd_log.level_statement,
1041: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1042: 'xml data ->'||dbms_lob.substr(x_xml_data, dbms_lob.getlength(x_xml_data), 1)
1043: );
1044: END IF;

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

1187: --add dummy query to the original query
1188: l_query_string := l_query_string || l_dummy_query || ' FROM DUAL CONNECT BY 1 = 1 and level <= 3';
1189: x_query_string := l_query_string;
1190:
1191: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1192: fnd_log.string
1193: (
1194: fnd_log.level_statement,
1195: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 1192: fnd_log.string

1188: l_query_string := l_query_string || l_dummy_query || ' FROM DUAL CONNECT BY 1 = 1 and level <= 3';
1189: x_query_string := l_query_string;
1190:
1191: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1192: fnd_log.string
1193: (
1194: fnd_log.level_statement,
1195: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1196: 'Quality Collection query string --->'||l_query_string

Line 1194: fnd_log.level_statement,

1190:
1191: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1192: fnd_log.string
1193: (
1194: fnd_log.level_statement,
1195: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1196: 'Quality Collection query string --->'||l_query_string
1197: );
1198: END IF;