DBA Data[Home] [Help]

APPS.CSD_REPAIRS_PVT dependencies on CSD_REPAIRS_UTIL

Line 100: x_dff_value_rec CSD_REPAIRS_UTIL.DEF_Rec_Type;

96: l_REPLN_Rec Csd_Repairs_Pub.REPLN_Rec_Type; -- swai bug 7657379
97:
98: -- bug#7043215, subhat
99: -- new DFF value rec.
100: x_dff_value_rec CSD_REPAIRS_UTIL.DEF_Rec_Type;
101: --
102: --
103: CURSOR C1 IS
104: SELECT CSD_REPAIRS_S1.NEXTVAL

Line 167: Csd_Repairs_Util.DEFAULT_RO_ATTRS_FROM_RULE

163: -- swai: bug 7657379
164: -- Default fields in repln_rec from defauling rules before
165: -- checking required params.
166: l_REPLN_Rec := p_REPLN_Rec;
167: Csd_Repairs_Util.DEFAULT_RO_ATTRS_FROM_RULE
168: ( p_api_version => 1.0,
169: p_commit => fnd_api.g_false,
170: p_init_msg_list => fnd_api.g_false,
171: px_repln_rec => l_REPLN_Rec,

Line 180: Csd_Repairs_Util.check_reqd_param

176: -- Note: From this point on, P_REPLN_REC has been replaced with l_REPLN_Rec
177:
178: --
179: -- Check for required parameters
180: Csd_Repairs_Util.check_reqd_param
181: (p_param_value => l_REPLN_Rec.incident_id,
182: p_param_name => 'P_REPLN_REC.INCIDENT_ID',
183: p_api_name => l_api_name
184: );

Line 185: Csd_Repairs_Util.check_reqd_param

181: (p_param_value => l_REPLN_Rec.incident_id,
182: p_param_name => 'P_REPLN_REC.INCIDENT_ID',
183: p_api_name => l_api_name
184: );
185: Csd_Repairs_Util.check_reqd_param
186: (p_param_value => l_REPLN_Rec.inventory_item_id,
187: p_param_name => 'P_REPLN_REC.INVENTORY_ITEM_ID',
188: p_api_name => l_api_name
189: );

Line 191: Csd_Repairs_Util.check_reqd_param

187: p_param_name => 'P_REPLN_REC.INVENTORY_ITEM_ID',
188: p_api_name => l_api_name
189: );
190:
191: Csd_Repairs_Util.check_reqd_param
192: (p_param_value => l_REPLN_Rec.unit_of_measure,
193: p_param_name => 'P_REPLN_REC.UNIT_OF_MEASURE',
194: p_api_name => l_api_name
195: );

Line 196: Csd_Repairs_Util.check_reqd_param

192: (p_param_value => l_REPLN_Rec.unit_of_measure,
193: p_param_name => 'P_REPLN_REC.UNIT_OF_MEASURE',
194: p_api_name => l_api_name
195: );
196: Csd_Repairs_Util.check_reqd_param
197: (p_param_value => l_REPLN_Rec.quantity,
198: p_param_name => 'P_REPLN_REC.QUANTITY',
199: p_api_name => l_api_name
200: );

Line 206: CSD_REPAIRS_UTIL.check_reqd_param

202: /* R12 Flex Flow change, vkjain.
203: -- Status is no longer mandatory.
204: -- One can either pass flow_status_id
205: -- or just status.
206: CSD_REPAIRS_UTIL.check_reqd_param
207: (p_param_value => l_REPLN_Rec.status,
208: p_param_name => 'P_REPLN_REC.STATUS',
209: p_api_name => l_api_name
210: );

Line 213: Csd_Repairs_Util.check_reqd_param

209: p_api_name => l_api_name
210: );
211: */
212:
213: Csd_Repairs_Util.check_reqd_param
214: (p_param_value => l_REPLN_Rec.currency_code,
215: p_param_name => 'P_REPLN_REC.CURRENCY_CODE',
216: p_api_name => l_api_name
217: );

Line 221: Csd_Repairs_Util.check_reqd_param

217: );
218:
219: -- Need to check if the status_reason_code is to be validated.
220:
221: Csd_Repairs_Util.check_reqd_param
222: (p_param_value => l_REPLN_Rec.approval_required_flag,
223: p_param_name => 'P_REPLN_REC.APPROVAL_REQUIRED_FLAG',
224: p_api_name => l_api_name
225: );

Line 226: Csd_Repairs_Util.check_reqd_param

222: (p_param_value => l_REPLN_Rec.approval_required_flag,
223: p_param_name => 'P_REPLN_REC.APPROVAL_REQUIRED_FLAG',
224: p_api_name => l_api_name
225: );
226: Csd_Repairs_Util.check_reqd_param
227: (p_param_value => l_REPLN_Rec.repair_type_id,
228: p_param_name => 'P_REPLN_REC.REPAIR_TYPE_ID',
229: p_api_name => l_api_name
230: );

Line 266: -- added a new out parameter which is of type CSD_REPAIRS_UTIL.DEF_Rec_Type

262:
263:
264: --
265: -- Invoke validation procedures
266: -- added a new out parameter which is of type CSD_REPAIRS_UTIL.DEF_Rec_Type
267: -- this collection holds the validated/derived DFF values (only in create mode)
268: -- subhat, FP bug#7242791
269: --
270: Validate_Repairs

Line 396: csd_repairs_util.get_contract_resolve_by_date(

392: INTO l_severity_id;
393: CLOSE c_get_severity_id;
394:
395: -- get resolve by date
396: csd_repairs_util.get_contract_resolve_by_date(
397: p_contract_line_id => l_REPLN_Rec.contract_line_id,
398: p_bus_proc_id => l_business_process_id,
399: p_severity_id => l_severity_id,
400: p_request_date => sysdate,

Line 652: x_dff_value_rec csd_repairs_util.def_rec_type;

648: l_OBJECT_VERSION_NUMBER NUMBER;
649:
650: -- bug#7242791, 12.1 FP, subhat
651: -- new out parameter for validate_repairs API.
652: x_dff_value_rec csd_repairs_util.def_rec_type;
653:
654: BEGIN
655:
656: -- Standard Start of API savepoint

Line 668: Csd_Repairs_Util.check_reqd_param

664: THEN
665: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
666: END IF;
667: -- Check for required parameters
668: Csd_Repairs_Util.check_reqd_param
669: (p_param_value => p_repair_line_id,
670: p_param_name => 'P_REPAIR_LINE_ID',
671: p_api_name => l_api_name
672: );

Line 2245: -- @param: x_dff_rec OUT NOCOPY CSD_REPAIRS_UTIL.DEF_Rec_Type

2241:
2242: --
2243: -- bug#7242791,12. FP, subhat
2244: -- added a new out parameter.ds
2245: -- @param: x_dff_rec OUT NOCOPY CSD_REPAIRS_UTIL.DEF_Rec_Type
2246: --
2247: PROCEDURE Validate_Repairs
2248: (
2249: P_Api_Version_Number IN NUMBER,

Line 2260: x_dff_rec OUT NOCOPY CSD_REPAIRS_UTIL.DEF_Rec_Type

2256: x_return_status OUT NOCOPY VARCHAR2,
2257: x_msg_count OUT NOCOPY NUMBER,
2258: x_msg_data OUT NOCOPY VARCHAR2,
2259: -- bug#7242791, subhat
2260: x_dff_rec OUT NOCOPY CSD_REPAIRS_UTIL.DEF_Rec_Type
2261:
2262: )
2263: IS
2264:

Line 2267: --l_DEF_Rec Csd_Repairs_Util.DEF_Rec_Type;

2263: IS
2264:
2265: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Repairs';
2266: l_api_version_number CONSTANT NUMBER := 1.0;
2267: --l_DEF_Rec Csd_Repairs_Util.DEF_Rec_Type;
2268: l_valid_def_rec BOOLEAN;
2269: l_attribute_category VARCHAR2(30);
2270: l_attribute1 VARCHAR2(150);
2271: l_attribute2 VARCHAR2(150);

Line 2845: Csd_Repairs_Util.Convert_to_DEF_Rec_Type

2841: END IF;
2842: ELSE
2843: l_attribute30 := p_REPLN_Rec.attribute30;
2844: END IF;
2845: Csd_Repairs_Util.Convert_to_DEF_Rec_Type
2846: (p_attribute_category => l_attribute_category,
2847: p_attribute1 => l_attribute1,
2848: p_attribute2 => l_attribute2,
2849: p_attribute3 => l_attribute3,

Line 2886: l_valid_def_rec := Csd_Repairs_Util.Is_DescFlex_Valid

2882: -- create and profile CSD: Enable Flexfield Defaulting for Repair Orders Flexfield
2883: -- is set to Yes.
2884: IF p_validation_mode = Jtf_Plsql_Api.G_CREATE THEN
2885: if nvl(fnd_profile.value('CSD_RO_DFF_DEF'),'N') = 'Y' then
2886: l_valid_def_rec := Csd_Repairs_Util.Is_DescFlex_Valid
2887: (p_api_name => 'Create_Repair_Order',
2888: p_desc_flex_name => 'CSD_REPAIRS',
2889: p_attr_values => x_dff_rec,
2890: p_validate_only => FND_API.G_FALSE);

Line 2892: l_valid_def_rec := CSD_REPAIRS_UTIL.Is_DescFlex_Valid

2888: p_desc_flex_name => 'CSD_REPAIRS',
2889: p_attr_values => x_dff_rec,
2890: p_validate_only => FND_API.G_FALSE);
2891: else
2892: l_valid_def_rec := CSD_REPAIRS_UTIL.Is_DescFlex_Valid
2893: (p_api_name => 'Create_Repair_Order',
2894: p_desc_flex_name => 'CSD_REPAIRS',
2895: p_attr_values => x_dff_rec,
2896: p_validate_only => FND_API.G_TRUE

Line 2900: l_valid_def_rec := CSD_REPAIRS_UTIL.Is_DescFlex_Valid

2896: p_validate_only => FND_API.G_TRUE
2897: );
2898: end if;
2899: ELSE
2900: l_valid_def_rec := CSD_REPAIRS_UTIL.Is_DescFlex_Valid
2901: (p_api_name => 'Update_Repair_Order',
2902: p_desc_flex_name => 'CSD_REPAIRS',
2903: p_attr_values => x_dff_rec,
2904: p_validate_only => FND_API.G_TRUE

Line 3840: Csd_Repairs_Util.Convert_Status_Val_To_Id(p_repair_status_rec,

3836: Fnd_Log.STRING (Fnd_Log.level_event,
3837: 'csd.plsql.csd_repairs_pvt.update_ro_status',
3838: '-----step 1: Value to Id conversion');
3839: END IF;
3840: Csd_Repairs_Util.Convert_Status_Val_To_Id(p_repair_status_rec,
3841: l_repair_status_rec,
3842: l_return_status);
3843:
3844: ------------Default/Validate Input parameters----------------------------------------------

Line 3890: Csd_Repairs_Util.CHECK_TASK_N_WIPJOB (

3886: END IF;
3887: ------------Validate Input parameters: record level validation------------------------------
3888: IF(p_status_control_Rec.check_task_wip = 'Y') THEN
3889:
3890: Csd_Repairs_Util.CHECK_TASK_N_WIPJOB (
3891: p_repair_line_id => l_repair_status_rec.repair_line_id,
3892: p_repair_status => l_repair_status_rec.repair_state,
3893: x_return_status => l_return_status,
3894: x_msg_count => l_msg_count,

Line 5566: csd_repairs_util.Check_WebSrvc_Security(

5562:
5563: l_return_Status := Fnd_Api.G_RET_STS_SUCCESS;
5564:
5565: --debug('In plsql api to update ro status for web service['||to_char(p_repair_line_id)||']');
5566: csd_repairs_util.Check_WebSrvc_Security(
5567: p_repair_line_id => p_repair_line_id,
5568: x_return_status => l_return_status);
5569:
5570: IF(l_return_Status <> Fnd_Api.G_RET_STS_SUCCESS) THEN