DBA Data[Home] [Help]

APPS.AHL_FMP_MR_VISIT_TYPES_PVT dependencies on FND_LOG

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

594: l_api_name CONSTANT VARCHAR2(30):= 'PROCESS_MR_VISIT_TYPES';
595: l_api_version NUMBER:=1.0;
596: l_mr_visit_type_ID NUMBER:=0;
597: BEGIN
598: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
599: fnd_log.string(fnd_log.level_procedure,
600: 'ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.process_mr_visit_types',
601: 'At the start of PLSQL procedure process_mr_visit_types');
602: END IF;

Line 599: fnd_log.string(fnd_log.level_procedure,

595: l_api_version NUMBER:=1.0;
596: l_mr_visit_type_ID NUMBER:=0;
597: BEGIN
598: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
599: fnd_log.string(fnd_log.level_procedure,
600: 'ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.process_mr_visit_types',
601: 'At the start of PLSQL procedure process_mr_visit_types');
602: END IF;
603:

Line 626: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

622: x_return_status:=FND_API.G_RET_STS_SUCCESS;
623:
624: IF p_x_mr_visit_type_tbl.COUNT <1
625: THEN
626: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
627: THEN
628: fnd_log.string(fnd_log.level_statement,
629: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.process_mr_visit_types',
630: 'Nothing to process as p_x_mr_visit_type_tbl.COUNT is :'||p_x_mr_visit_type_tbl.COUNT);

Line 628: fnd_log.string(fnd_log.level_statement,

624: IF p_x_mr_visit_type_tbl.COUNT <1
625: THEN
626: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
627: THEN
628: fnd_log.string(fnd_log.level_statement,
629: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.process_mr_visit_types',
630: 'Nothing to process as p_x_mr_visit_type_tbl.COUNT is :'||p_x_mr_visit_type_tbl.COUNT);
631: END IF;
632: --RETURN; -- NOTHING TO PROCESS

Line 635: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

631: END IF;
632: --RETURN; -- NOTHING TO PROCESS
633: END IF;
634:
635: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
636: THEN
637: fnd_log.string(fnd_log.level_statement,
638: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.sort_records',
639: 'IF P_MODULE_TYPE IS JSP SET LOV IDS TO NULLIFY ');

Line 637: fnd_log.string(fnd_log.level_statement,

633: END IF;
634:
635: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
636: THEN
637: fnd_log.string(fnd_log.level_statement,
638: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.sort_records',
639: 'IF P_MODULE_TYPE IS JSP SET LOV IDS TO NULLIFY ');
640: END IF;
641:

Line 655: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

651: --p_x_mr_visit_type_tbl(i).mr_visit_type_code:=FND_API.G_MISS_CHAR;
652: END LOOP;
653: END IF;
654:
655: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
656: THEN
657: fnd_log.string(fnd_log.level_statement,
658: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.DEFAULT_MISSING_ATTRIBS',
659: 'Start of DEFAULT_MISSING_ATTRIBS');

Line 657: fnd_log.string(fnd_log.level_statement,

653: END IF;
654:
655: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
656: THEN
657: fnd_log.string(fnd_log.level_statement,
658: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.DEFAULT_MISSING_ATTRIBS',
659: 'Start of DEFAULT_MISSING_ATTRIBS');
660: END IF;
661:

Line 668: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

664: p_x_mr_visit_type_tbl =>p_x_mr_visit_type_tbl
665: );
666:
667:
668: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
669: THEN
670: fnd_log.string(fnd_log.level_statement,
671: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.DEFAULT_MISSING_ATTRIBS',
672: 'End of DEFAULT_MISSING_ATTRIBS');

Line 670: fnd_log.string(fnd_log.level_statement,

666:
667:
668: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
669: THEN
670: fnd_log.string(fnd_log.level_statement,
671: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.DEFAULT_MISSING_ATTRIBS',
672: 'End of DEFAULT_MISSING_ATTRIBS');
673: END IF;
674:

Line 675: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

671: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.DEFAULT_MISSING_ATTRIBS',
672: 'End of DEFAULT_MISSING_ATTRIBS');
673: END IF;
674:
675: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
676: THEN
677: fnd_log.string(fnd_log.level_statement,
678: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.sort_records',
679: 'Start of SORT_RECORDS');

Line 677: fnd_log.string(fnd_log.level_statement,

673: END IF;
674:
675: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
676: THEN
677: fnd_log.string(fnd_log.level_statement,
678: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.sort_records',
679: 'Start of SORT_RECORDS');
680: END IF;
681:

Line 684: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

680: END IF;
681:
682: SORT_RECORDS(p_x_mr_visit_type_tbl);
683:
684: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
685: THEN
686: fnd_log.string(fnd_log.level_statement,
687: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.sort_records',
688: 'End of SORT_RECORDS');

Line 686: fnd_log.string(fnd_log.level_statement,

682: SORT_RECORDS(p_x_mr_visit_type_tbl);
683:
684: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
685: THEN
686: fnd_log.string(fnd_log.level_statement,
687: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.sort_records',
688: 'End of SORT_RECORDS');
689: END IF;
690:

Line 697: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

693: LOOP
694:
695: IF p_x_mr_visit_type_tbl(i).DML_OPERATION<>'D'
696: THEN
697: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
698: THEN
699: fnd_log.string(fnd_log.level_statement,
700: 'Local procedure TRANS_VALUE_ID',
701: 'Start of TRANS_VALUE_ID');

Line 699: fnd_log.string(fnd_log.level_statement,

695: IF p_x_mr_visit_type_tbl(i).DML_OPERATION<>'D'
696: THEN
697: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
698: THEN
699: fnd_log.string(fnd_log.level_statement,
700: 'Local procedure TRANS_VALUE_ID',
701: 'Start of TRANS_VALUE_ID');
702: END IF;
703:

Line 709: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

705: (
706: p_x_mr_visit_type_rec =>p_x_mr_visit_type_tbl(i)
707: );
708:
709: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
710: THEN
711: fnd_log.string(fnd_log.level_statement,
712: 'Local procedure TRANS_VALUE_ID',
713: 'End of TRANS_VALUE_ID');

Line 711: fnd_log.string(fnd_log.level_statement,

707: );
708:
709: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
710: THEN
711: fnd_log.string(fnd_log.level_statement,
712: 'Local procedure TRANS_VALUE_ID',
713: 'End of TRANS_VALUE_ID');
714: END IF;
715:

Line 723: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

719:
720: x_msg_count := FND_MSG_PUB.count_msg;
721: IF x_msg_count > 0 THEN
722:
723: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
724: THEN
725: fnd_log.string(fnd_log.level_statement,
726: 'Local procedure TRANS_VALUE_ID',
727: 'End of TRANS_VALUE_ID');

Line 725: fnd_log.string(fnd_log.level_statement,

721: IF x_msg_count > 0 THEN
722:
723: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
724: THEN
725: fnd_log.string(fnd_log.level_statement,
726: 'Local procedure TRANS_VALUE_ID',
727: 'End of TRANS_VALUE_ID');
728: END IF;
729: