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 CSD_REPAIRS_UTIL

Line 1: Package BODY Csd_Repairs_Util AS

1: Package BODY Csd_Repairs_Util AS
2: /* $Header: csdxutlb.pls 120.14.12010000.5 2008/12/19 02:00:27 swai ship $ */
3: --
4: -- Package name : CSD_REPAIRS_UTIL
5: -- Purpose : This package contains utility programs for the Depot

Line 4: -- Package name : CSD_REPAIRS_UTIL

1: Package BODY Csd_Repairs_Util AS
2: /* $Header: csdxutlb.pls 120.14.12010000.5 2008/12/19 02:00:27 swai ship $ */
3: --
4: -- Package name : CSD_REPAIRS_UTIL
5: -- Purpose : This package contains utility programs for the Depot
6: -- Repair module. Access is restricted to Oracle Depot
7: -- Repair Internal Development.
8: -- History :

Line 23: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_REPAIRS_UTIL';

19: -- 120.2 07/13/05 vparvath Added utility proc for webservice
20: --
21: -- NOTE :
22: --
23: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_REPAIRS_UTIL';
24: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdxutlb.pls';
25: g_debug NUMBER := Csd_Gen_Utility_Pvt.g_debug_level;
26:
27: procedure debug( l_msg in varchar2)

Line 103: p_attr_values IN OUT NOCOPY CSD_REPAIRS_UTIL.DEF_Rec_Type,

99:
100: FUNCTION Is_DescFlex_Valid
101: ( p_api_name IN VARCHAR2,
102: p_desc_flex_name IN VARCHAR2,
103: p_attr_values IN OUT NOCOPY CSD_REPAIRS_UTIL.DEF_Rec_Type,
104: -- bug#7151536, subhat.
105: p_validate_only IN VARCHAR2 := FND_API.G_TRUE
106: ) RETURN BOOLEAN IS
107: --

Line 464: x_DEF_Rec OUT NOCOPY Csd_Repairs_Util.DEF_Rec_Type

460: p_attribute27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_attribute30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: x_DEF_Rec OUT NOCOPY Csd_Repairs_Util.DEF_Rec_Type
465: ) IS
466: --
467: BEGIN
468: --

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 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 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 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 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 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 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 854: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',

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:
858: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 863: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',

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:
867: WHEN OTHERS THEN

Line 877: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',

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:
881:

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 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 1308: 'CSD.PLSQL.CSD_REPAIRS_UTIL.CHANGE_ITEM_IB_OWNER.BEGIN',

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:
1312: -- Initialize API return status to success

Line 1455: 'CSD.PLSQL.CSD_REPAIRS_UTIL.CHANGE_ITEM_IB_OWNER.END',

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:
1459: EXCEPTION

Line 1557: lc_api_name CONSTANT VARCHAR2(50) := 'csd_repairs_util.get_contract_resolve_by_date';

1553: x_msg_data OUT NOCOPY VARCHAR2,
1554: x_resolve_by_date OUT NOCOPY DATE
1555: ) IS
1556: -- define constants
1557: lc_api_name CONSTANT VARCHAR2(50) := 'csd_repairs_util.get_contract_resolve_by_date';
1558:
1559: -- define variables
1560: l_server_timezone_id NUMBER;
1561:

Line 1736: lc_mod_name varchar2(100) := 'csd.plsql.csd_repairs_util.auto_update_ro_status';

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);
1740:

Line 1968: lc_mod_name varchar2(100) := 'csd.plsql.csd_repairs_util.default_ro_attrs_from_rule';

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:
1972: BEGIN

Line 2215: END Csd_Repairs_Util;

2211: (p_count => x_msg_count,
2212: p_data => x_msg_data );
2213: END DEFAULT_RO_ATTRS_FROM_RULE;
2214:
2215: END Csd_Repairs_Util;