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.CSD_REPAIRS_UTIL dependencies on FND_LOG

Line 771: l_debug_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;

767: BEGIN
768:
769: -- Initialize local variables.
770: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
771: l_debug_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
772:
773: IF (Fnd_Log.LEVEL_PROCEDURE >= l_debug_level) THEN
774: Fnd_Log.STRING (Fnd_Log.LEVEL_PROCEDURE, 'csd.plsql.csd_repairs_util.check_task_n_wipjob.begin',
775: '-------------Entered check_task_n_wipjob----------------');

Line 773: IF (Fnd_Log.LEVEL_PROCEDURE >= l_debug_level) THEN

769: -- Initialize local variables.
770: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
771: l_debug_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
772:
773: IF (Fnd_Log.LEVEL_PROCEDURE >= l_debug_level) THEN
774: Fnd_Log.STRING (Fnd_Log.LEVEL_PROCEDURE, 'csd.plsql.csd_repairs_util.check_task_n_wipjob.begin',
775: '-------------Entered check_task_n_wipjob----------------');
776: END IF;
777:

Line 774: Fnd_Log.STRING (Fnd_Log.LEVEL_PROCEDURE, 'csd.plsql.csd_repairs_util.check_task_n_wipjob.begin',

770: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
771: l_debug_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
772:
773: IF (Fnd_Log.LEVEL_PROCEDURE >= l_debug_level) THEN
774: Fnd_Log.STRING (Fnd_Log.LEVEL_PROCEDURE, 'csd.plsql.csd_repairs_util.check_task_n_wipjob.begin',
775: '-------------Entered check_task_n_wipjob----------------');
776: END IF;
777:
778:

Line 795: IF (Fnd_Log.LEVEL_EVENT >= l_debug_level) THEN

791: success if not.
792: ****/
793: IF( p_repair_status = C_CLOSED_STATUS) THEN
794:
795: IF (Fnd_Log.LEVEL_EVENT >= l_debug_level) THEN
796: Fnd_Log.STRING (Fnd_Log.LEVEL_EVENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
797: '-------------status is being changed to close,ro['||p_repair_line_id||']-----');
798: END IF;
799:

Line 796: Fnd_Log.STRING (Fnd_Log.LEVEL_EVENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',

792: ****/
793: IF( p_repair_status = C_CLOSED_STATUS) THEN
794:
795: IF (Fnd_Log.LEVEL_EVENT >= l_debug_level) THEN
796: Fnd_Log.STRING (Fnd_Log.LEVEL_EVENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
797: '-------------status is being changed to close,ro['||p_repair_line_id||']-----');
798: END IF;
799:
800: IF (l_repair_mode = C_WIP_MODE) THEN

Line 802: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN

798: END IF;
799:
800: IF (l_repair_mode = C_WIP_MODE) THEN
801:
802: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN
803: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
804: '-------------checking for open jobs---------------');
805: END IF;
806:

Line 803: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',

799:
800: IF (l_repair_mode = C_WIP_MODE) THEN
801:
802: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN
803: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
804: '-------------checking for open jobs---------------');
805: END IF;
806:
807: OPEN wipjob_cur;

Line 811: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN

807: OPEN wipjob_cur;
808: FETCH wipjob_cur INTO l_tmp_char;
809: IF(wipjob_cur%NOTFOUND) THEN
810: CLOSE wipjob_cur;
811: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN
812: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
813: '-------------there are open jobs---------------');
814: END IF;
815: Fnd_Message.set_name('CSD', 'CSD_API_OPEN_WIP_JOBS');

Line 812: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',

808: FETCH wipjob_cur INTO l_tmp_char;
809: IF(wipjob_cur%NOTFOUND) THEN
810: CLOSE wipjob_cur;
811: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN
812: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
813: '-------------there are open jobs---------------');
814: END IF;
815: Fnd_Message.set_name('CSD', 'CSD_API_OPEN_WIP_JOBS');
816: Fnd_Msg_Pub.ADD;

Line 822: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN

818: END IF;
819: CLOSE wipjob_cur;
820: ELSIF (l_repair_mode = C_TASK_MODE) THEN
821:
822: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN
823: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
824: '-------------checking for open tasks---------------');
825: END IF;
826:

Line 823: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',

819: CLOSE wipjob_cur;
820: ELSIF (l_repair_mode = C_TASK_MODE) THEN
821:
822: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN
823: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
824: '-------------checking for open tasks---------------');
825: END IF;
826:
827: OPEN task_cur;

Line 831: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN

827: OPEN task_cur;
828: FETCH task_cur INTO l_tmp_char;
829: IF(task_cur%NOTFOUND) THEN
830: CLOSE task_cur;
831: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN
832: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
833: '-------------there are open tasks---------------');
834: END IF;
835: Fnd_Message.set_name('CSD', 'CSD_API_OPEN_TASKS');

Line 832: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',

828: FETCH task_cur INTO l_tmp_char;
829: IF(task_cur%NOTFOUND) THEN
830: CLOSE task_cur;
831: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN
832: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
833: '-------------there are open tasks---------------');
834: END IF;
835: Fnd_Message.set_name('CSD', 'CSD_API_OPEN_TASKS');
836: Fnd_Msg_Pub.ADD;

Line 843: IF (Fnd_Log.level_procedure >= l_debug_level) THEN

839: CLOSE task_cur;
840: END IF;
841: END IF;
842:
843: IF (Fnd_Log.level_procedure >= l_debug_level) THEN
844: Fnd_Log.STRING (Fnd_Log.level_procedure, 'csd.plsql.csd_repairs_util.check_task_n_wipjob.end',
845: '-------------Leaving check_task_n_wipjob----------------');
846: END IF;
847:

Line 844: Fnd_Log.STRING (Fnd_Log.level_procedure, 'csd.plsql.csd_repairs_util.check_task_n_wipjob.end',

840: END IF;
841: END IF;
842:
843: IF (Fnd_Log.level_procedure >= l_debug_level) THEN
844: Fnd_Log.STRING (Fnd_Log.level_procedure, 'csd.plsql.csd_repairs_util.check_task_n_wipjob.end',
845: '-------------Leaving check_task_n_wipjob----------------');
846: END IF;
847:
848: EXCEPTION

Line 852: IF ( Fnd_Log.LEVEL_ERROR >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN

848: EXCEPTION
849: WHEN Fnd_Api.G_EXC_ERROR THEN
850: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
851: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
852: IF ( Fnd_Log.LEVEL_ERROR >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
853: Fnd_Log.STRING(Fnd_Log.LEVEL_ERROR,
854: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
855: 'EXC_ERROR ['||x_msg_data||']');
856: END IF;

Line 853: Fnd_Log.STRING(Fnd_Log.LEVEL_ERROR,

849: WHEN Fnd_Api.G_EXC_ERROR THEN
850: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
851: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
852: IF ( Fnd_Log.LEVEL_ERROR >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
853: Fnd_Log.STRING(Fnd_Log.LEVEL_ERROR,
854: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
855: 'EXC_ERROR ['||x_msg_data||']');
856: END IF;
857:

Line 861: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN

857:
858: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
859: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
860: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );
861: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
862: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
863: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
864: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
865: END IF;

Line 862: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,

858: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
859: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
860: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );
861: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
862: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
863: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
864: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
865: END IF;
866:

Line 875: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN

871: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME , l_api_name );
872: END IF;
873: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );
874:
875: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
876: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
877: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
878: 'SQL Message ['||SQLERRM||']');
879: END IF;

Line 876: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,

872: END IF;
873: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );
874:
875: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
876: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
877: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
878: 'SQL Message ['||SQLERRM||']');
879: END IF;
880:

Line 927: l_debug_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;

923:
924:
925: -- Initialize local variables.
926: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
927: l_debug_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
928:
929: IF (Fnd_Log.LEVEL_PROCEDURE >= l_debug_level) THEN
930: Fnd_Log.STRING (Fnd_Log.LEVEL_PROCEDURE, 'csd.plsql.csd_repairs_util.Convert_Status_val_to_Id.begin',
931: '-------------Entered Convert_Status_val_to_Id----------------');

Line 929: IF (Fnd_Log.LEVEL_PROCEDURE >= l_debug_level) THEN

925: -- Initialize local variables.
926: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
927: l_debug_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
928:
929: IF (Fnd_Log.LEVEL_PROCEDURE >= l_debug_level) THEN
930: Fnd_Log.STRING (Fnd_Log.LEVEL_PROCEDURE, 'csd.plsql.csd_repairs_util.Convert_Status_val_to_Id.begin',
931: '-------------Entered Convert_Status_val_to_Id----------------');
932: END IF;
933:

Line 930: Fnd_Log.STRING (Fnd_Log.LEVEL_PROCEDURE, 'csd.plsql.csd_repairs_util.Convert_Status_val_to_Id.begin',

926: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
927: l_debug_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
928:
929: IF (Fnd_Log.LEVEL_PROCEDURE >= l_debug_level) THEN
930: Fnd_Log.STRING (Fnd_Log.LEVEL_PROCEDURE, 'csd.plsql.csd_repairs_util.Convert_Status_val_to_Id.begin',
931: '-------------Entered Convert_Status_val_to_Id----------------');
932: END IF;
933:
934:

Line 1003: IF (Fnd_Log.level_procedure >= l_debug_level) THEN

999: END IF;
1000:
1001:
1002:
1003: IF (Fnd_Log.level_procedure >= l_debug_level) THEN
1004: Fnd_Log.STRING (Fnd_Log.level_procedure, 'csd.plsql.csd_repairs_util.Convert_Status_Val_to_Id.end',
1005: '-------------Leaving Convert_Status_Val_to_Id----------------');
1006: END IF;
1007:

Line 1004: Fnd_Log.STRING (Fnd_Log.level_procedure, 'csd.plsql.csd_repairs_util.Convert_Status_Val_to_Id.end',

1000:
1001:
1002:
1003: IF (Fnd_Log.level_procedure >= l_debug_level) THEN
1004: Fnd_Log.STRING (Fnd_Log.level_procedure, 'csd.plsql.csd_repairs_util.Convert_Status_Val_to_Id.end',
1005: '-------------Leaving Convert_Status_Val_to_Id----------------');
1006: END IF;
1007:
1008: END Convert_status_Val_to_Id;

Line 1306: if (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

1302: BEGIN
1303:
1304: savepoint CHANGE_ITEM_IB_OWNER;
1305:
1306: if (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1307: fnd_log.STRING (fnd_log.level_procedure,
1308: 'CSD.PLSQL.CSD_REPAIRS_UTIL.CHANGE_ITEM_IB_OWNER.BEGIN',
1309: 'Enter - Change Item IB Owner');
1310: end if;

Line 1307: fnd_log.STRING (fnd_log.level_procedure,

1303:
1304: savepoint CHANGE_ITEM_IB_OWNER;
1305:
1306: if (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1307: fnd_log.STRING (fnd_log.level_procedure,
1308: 'CSD.PLSQL.CSD_REPAIRS_UTIL.CHANGE_ITEM_IB_OWNER.BEGIN',
1309: 'Enter - Change Item IB Owner');
1310: end if;
1311:

Line 1453: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

1449: End If;
1450:
1451: COMMIT WORK;
1452:
1453: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1454: fnd_log.STRING (fnd_log.level_procedure,
1455: 'CSD.PLSQL.CSD_REPAIRS_UTIL.CHANGE_ITEM_IB_OWNER.END',
1456: 'Exit - Change Item IB Owner');
1457: End if;

Line 1454: fnd_log.STRING (fnd_log.level_procedure,

1450:
1451: COMMIT WORK;
1452:
1453: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1454: fnd_log.STRING (fnd_log.level_procedure,
1455: 'CSD.PLSQL.CSD_REPAIRS_UTIL.CHANGE_ITEM_IB_OWNER.END',
1456: 'Exit - Change Item IB Owner');
1457: End if;
1458:

Line 1713: -- will be logged in the fnd_log_messages if logging is enabled

1709: -- p_reason_code: The reason code for the status change defaulted to null
1710: -- p_comments: The comments for the flow status, defaulted to null
1711: -- p_validation_level: validation level for the routine. Pass fnd_api.g_valid_level_full to get the messages from the API
1712: -- pass fnd_api.g_valid_level_none will ignore all error messages and return success always. The error messages
1713: -- will be logged in the fnd_log_messages if logging is enabled
1714: --*****************************************************
1715:
1716: procedure auto_update_ro_status(
1717: p_api_version in number,

Line 1734: lc_log_level number := fnd_log.g_current_runtime_level;

1730: l_to_flow_status_id number;
1731: x_object_version_number number;
1732: l_repair_type_id number;
1733: l_object_version_number number;
1734: lc_log_level number := fnd_log.g_current_runtime_level;
1735: lc_procedure_level number := fnd_log.level_procedure;
1736: lc_mod_name varchar2(100) := 'csd.plsql.csd_repairs_util.auto_update_ro_status';
1737: lc_api_version_number number := 1.0;
1738: lc_api_name varchar2(60) := 'auto_update_ro_status';

Line 1735: lc_procedure_level number := fnd_log.level_procedure;

1731: x_object_version_number number;
1732: l_repair_type_id number;
1733: l_object_version_number number;
1734: lc_log_level number := fnd_log.g_current_runtime_level;
1735: lc_procedure_level number := fnd_log.level_procedure;
1736: lc_mod_name varchar2(100) := 'csd.plsql.csd_repairs_util.auto_update_ro_status';
1737: lc_api_version_number number := 1.0;
1738: lc_api_name varchar2(60) := 'auto_update_ro_status';
1739: l_un_rcvd_lines_exists varchar2(3);

Line 1760: fnd_log.string(lc_log_level,lc_mod_name,'Begin auto_update_ro_status');

1756: fnd_msg_pub.initialize;
1757: END IF;
1758:
1759: if lc_log_level >= lc_procedure_level then
1760: fnd_log.string(lc_log_level,lc_mod_name,'Begin auto_update_ro_status');
1761: end if;
1762:
1763: -- set the return status
1764: x_return_status := fnd_api.g_ret_sts_success;

Line 1774: fnd_log.string(lc_log_level,lc_mod_name,'Profile CSD: Enable Auto Update of Repair

1770: --
1771: if nvl(fnd_profile.value('CSD_ENABLE_AUTO_UPD_RO_STAT'),'N') = 'N'
1772: then
1773: if lc_log_level >= lc_procedure_level then
1774: fnd_log.string(lc_log_level,lc_mod_name,'Profile CSD: Enable Auto Update of Repair
1775: Order Status upon Receiving is not set to yes.');
1776: end if;
1777: if p_validation_level = fnd_api.g_valid_level_full then
1778: -- to do: If the caller API needs this API to raise the errors, set a message into message stack and raise an error to exception block.

Line 1807: fnd_log.string(lc_log_level,lc_mod_name,'Profile CSD: Default Repair Order Status After

1803:
1804: l_to_flow_status_id := fnd_profile.value('CSD_DEF_RO_STAT_FR_RCV');
1805: if l_to_flow_status_id is null then
1806: if lc_log_level >= lc_procedure_level then
1807: fnd_log.string(lc_log_level,lc_mod_name,'Profile CSD: Default Repair Order Status After
1808: Receving is not set');
1809: end if;
1810: if p_validation_level = fnd_api.g_valid_level_full then
1811: -- to do: set a message and raise an error for the caller API.

Line 1838: fnd_log.string(lc_log_level,lc_mod_name,'the new status is same as the old status. Do not update the status');

1834:
1835: if l_to_flow_status_id = l_from_flow_status_id then
1836: -- to and from are same. Do not update.
1837: if lc_log_level >= lc_procedure_level then
1838: fnd_log.string(lc_log_level,lc_mod_name,'the new status is same as the old status. Do not update the status');
1839: end if;
1840: if p_validation_level = fnd_api.g_valid_level_full then
1841: -- to do: set a message and raise an error.
1842: null;

Line 1849: fnd_log.string(lc_log_level,lc_mod_name,'calling csd_repairs_pvt.update_flow_status API');

1845: end if;
1846: end if;
1847: -- call the update flow status API to update the RO status.
1848: if lc_log_level >= lc_procedure_level then
1849: fnd_log.string(lc_log_level,lc_mod_name,'calling csd_repairs_pvt.update_flow_status API');
1850: end if;
1851:
1852: csd_repairs_pvt.update_flow_status(p_api_version => 1,
1853: p_commit => fnd_api.g_false,

Line 1870: fnd_log.string(lc_log_level,lc_mod_name,'Error in csd_repairs_pvt.update_flow_status

1866: p_object_version_number => l_object_version_number,
1867: x_object_version_number => x_object_version_number );
1868: if x_return_status <> fnd_api.g_ret_sts_success then
1869: if lc_log_level >= lc_procedure_level then
1870: fnd_log.string(lc_log_level,lc_mod_name,'Error in csd_repairs_pvt.update_flow_status
1871: ['||x_msg_data||']');
1872: end if;
1873:
1874: if p_validation_level = fnd_api.g_valid_level_full then

Line 1966: lc_log_level number := fnd_log.g_current_runtime_level;

1962: l_repair_org NUMBER; -- repair org id
1963: l_repair_type_id NUMBER; -- repair type id
1964: l_repair_mode VARCHAR2(30) := ''; -- repair mode display name
1965: l_auto_process_rma VARCHAR2(30) := '';
1966: lc_log_level number := fnd_log.g_current_runtime_level;
1967: lc_procedure_level number := fnd_log.level_procedure;
1968: lc_mod_name varchar2(100) := 'csd.plsql.csd_repairs_util.default_ro_attrs_from_rule';
1969: lc_api_version_number number := 1.0;
1970: lc_api_name varchar2(60) := 'default_ro_attrs_from_rule';

Line 1967: lc_procedure_level number := fnd_log.level_procedure;

1963: l_repair_type_id NUMBER; -- repair type id
1964: l_repair_mode VARCHAR2(30) := ''; -- repair mode display name
1965: l_auto_process_rma VARCHAR2(30) := '';
1966: lc_log_level number := fnd_log.g_current_runtime_level;
1967: lc_procedure_level number := fnd_log.level_procedure;
1968: lc_mod_name varchar2(100) := 'csd.plsql.csd_repairs_util.default_ro_attrs_from_rule';
1969: lc_api_version_number number := 1.0;
1970: lc_api_name varchar2(60) := 'default_ro_attrs_from_rule';
1971:

Line 1989: fnd_log.string(lc_log_level,lc_mod_name,'Begin default_ro_attrs_from_rule');

1985: fnd_msg_pub.initialize;
1986: end if;
1987:
1988: if lc_log_level >= lc_procedure_level then
1989: fnd_log.string(lc_log_level,lc_mod_name,'Begin default_ro_attrs_from_rule');
1990: end if;
1991:
1992: -- set the return status
1993: x_return_status := fnd_api.g_ret_sts_success;