[Home] [Help]
43: IS
44: --
45: BEGIN
46: --
47: IF (NVL(p_param_value,Fnd_Api.G_MISS_NUM) = Fnd_Api.G_MISS_NUM) THEN
48: Fnd_Message.SET_NAME('CSD','CSD_API_MISSING_PARAM');
49: Fnd_Message.SET_TOKEN('API_NAME',p_api_name);
50: Fnd_Message.SET_TOKEN('MISSING_PARAM',p_param_name);
51: Fnd_Msg_Pub.ADD;
48: Fnd_Message.SET_NAME('CSD','CSD_API_MISSING_PARAM');
49: Fnd_Message.SET_TOKEN('API_NAME',p_api_name);
50: Fnd_Message.SET_TOKEN('MISSING_PARAM',p_param_name);
51: Fnd_Msg_Pub.ADD;
52: RAISE Fnd_Api.G_EXC_ERROR;
53: END IF;
54: END Check_Reqd_Param;
55:
56: PROCEDURE Check_Reqd_Param (
61: IS
62: --
63: BEGIN
64: --
65: IF (NVL(p_param_value,Fnd_Api.G_MISS_CHAR) = Fnd_Api.G_MISS_CHAR) THEN
66: Fnd_Message.SET_NAME('CSD','CSD_API_MISSING_PARAM');
67: Fnd_Message.SET_TOKEN('API_NAME',p_api_name);
68: Fnd_Message.SET_TOKEN('MISSING_PARAM',p_param_name);
69: Fnd_Msg_Pub.ADD;
66: Fnd_Message.SET_NAME('CSD','CSD_API_MISSING_PARAM');
67: Fnd_Message.SET_TOKEN('API_NAME',p_api_name);
68: Fnd_Message.SET_TOKEN('MISSING_PARAM',p_param_name);
69: Fnd_Msg_Pub.ADD;
70: RAISE Fnd_Api.G_EXC_ERROR;
71: END IF;
72: END Check_Reqd_Param;
73:
74: PROCEDURE Check_Reqd_Param (
79: IS
80: --
81: BEGIN
82: --
83: IF (NVL(p_param_value,Fnd_Api.G_MISS_DATE) = Fnd_Api.G_MISS_DATE) THEN
84: Fnd_Message.SET_NAME('CSD','CSD_API_MISSING_PARAM');
85: Fnd_Message.SET_TOKEN('API_NAME',p_api_name);
86: Fnd_Message.SET_TOKEN('MISSING_PARAM',p_param_name);
87: Fnd_Msg_Pub.ADD;
84: Fnd_Message.SET_NAME('CSD','CSD_API_MISSING_PARAM');
85: Fnd_Message.SET_TOKEN('API_NAME',p_api_name);
86: Fnd_Message.SET_TOKEN('MISSING_PARAM',p_param_name);
87: Fnd_Msg_Pub.ADD;
88: RAISE Fnd_Api.G_EXC_ERROR;
89: END IF;
90: END Check_Reqd_Param;
91:
92: --
93: -- bug#7151536, subhat.
94: -- changed the p_attr_values to IN OUT from IN
95: -- added a new parameter p_validate_only. This parameter would
96: -- indicate if we wish to default the required values or not.
97: -- If we need to validate and default then pass FND_API.G_FALSE
98: -- For validate only it will be default FND_API.G_TRUE.
99:
100: FUNCTION Is_DescFlex_Valid
101: ( p_api_name IN VARCHAR2,
94: -- changed the p_attr_values to IN OUT from IN
95: -- added a new parameter p_validate_only. This parameter would
96: -- indicate if we wish to default the required values or not.
97: -- If we need to validate and default then pass FND_API.G_FALSE
98: -- For validate only it will be default FND_API.G_TRUE.
99:
100: FUNCTION Is_DescFlex_Valid
101: ( p_api_name IN VARCHAR2,
102: p_desc_flex_name IN VARCHAR2,
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: --
108: l_error_message VARCHAR2(2000);
109: l_return_status BOOLEAN := TRUE;
153: -- Flex engine doesnt default the values if we pass default value for
154: -- values_or_ids.
155: -- need to pass in 'V' (refer bug#2221725)
156: -- Pass in values_or_ids = 'V' only if p_validate_only is False.
157: if p_validate_only = FND_API.G_FALSE then
158: l_values_or_ids := 'V';
159: else
160: l_values_or_ids := 'I';
161: end if;
261: END Is_DescFlex_Valid;
262:
263: PROCEDURE Convert_to_Repln_Rec_Type
264: (
265: p_REPAIR_NUMBER IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
266: p_INCIDENT_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
267: p_INVENTORY_ITEM_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
268: p_CUSTOMER_PRODUCT_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
269: p_UNIT_OF_MEASURE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
262:
263: PROCEDURE Convert_to_Repln_Rec_Type
264: (
265: p_REPAIR_NUMBER IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
266: p_INCIDENT_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
267: p_INVENTORY_ITEM_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
268: p_CUSTOMER_PRODUCT_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
269: p_UNIT_OF_MEASURE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
270: p_REPAIR_TYPE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
263: PROCEDURE Convert_to_Repln_Rec_Type
264: (
265: p_REPAIR_NUMBER IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
266: p_INCIDENT_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
267: p_INVENTORY_ITEM_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
268: p_CUSTOMER_PRODUCT_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
269: p_UNIT_OF_MEASURE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
270: p_REPAIR_TYPE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
271: -- RESOURCE_GROUP Added by Vijay 10/28/2004
264: (
265: p_REPAIR_NUMBER IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
266: p_INCIDENT_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
267: p_INVENTORY_ITEM_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
268: p_CUSTOMER_PRODUCT_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
269: p_UNIT_OF_MEASURE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
270: p_REPAIR_TYPE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
271: -- RESOURCE_GROUP Added by Vijay 10/28/2004
272: p_RESOURCE_GROUP IN NUMBER := Fnd_Api.G_MISS_NUM,
265: p_REPAIR_NUMBER IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
266: p_INCIDENT_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
267: p_INVENTORY_ITEM_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
268: p_CUSTOMER_PRODUCT_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
269: p_UNIT_OF_MEASURE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
270: p_REPAIR_TYPE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
271: -- RESOURCE_GROUP Added by Vijay 10/28/2004
272: p_RESOURCE_GROUP IN NUMBER := Fnd_Api.G_MISS_NUM,
273: p_RESOURCE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
266: p_INCIDENT_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
267: p_INVENTORY_ITEM_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
268: p_CUSTOMER_PRODUCT_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
269: p_UNIT_OF_MEASURE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
270: p_REPAIR_TYPE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
271: -- RESOURCE_GROUP Added by Vijay 10/28/2004
272: p_RESOURCE_GROUP IN NUMBER := Fnd_Api.G_MISS_NUM,
273: p_RESOURCE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
274: p_PROJECT_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
268: p_CUSTOMER_PRODUCT_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
269: p_UNIT_OF_MEASURE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
270: p_REPAIR_TYPE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
271: -- RESOURCE_GROUP Added by Vijay 10/28/2004
272: p_RESOURCE_GROUP IN NUMBER := Fnd_Api.G_MISS_NUM,
273: p_RESOURCE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
274: p_PROJECT_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
275: p_TASK_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
276: p_UNIT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR, -- rfieldma, project_integration
269: p_UNIT_OF_MEASURE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
270: p_REPAIR_TYPE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
271: -- RESOURCE_GROUP Added by Vijay 10/28/2004
272: p_RESOURCE_GROUP IN NUMBER := Fnd_Api.G_MISS_NUM,
273: p_RESOURCE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
274: p_PROJECT_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
275: p_TASK_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
276: p_UNIT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR, -- rfieldma, project_integration
277: p_CONTRACT_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
270: p_REPAIR_TYPE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
271: -- RESOURCE_GROUP Added by Vijay 10/28/2004
272: p_RESOURCE_GROUP IN NUMBER := Fnd_Api.G_MISS_NUM,
273: p_RESOURCE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
274: p_PROJECT_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
275: p_TASK_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
276: p_UNIT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR, -- rfieldma, project_integration
277: p_CONTRACT_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
278: p_AUTO_PROCESS_RMA IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
271: -- RESOURCE_GROUP Added by Vijay 10/28/2004
272: p_RESOURCE_GROUP IN NUMBER := Fnd_Api.G_MISS_NUM,
273: p_RESOURCE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
274: p_PROJECT_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
275: p_TASK_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
276: p_UNIT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR, -- rfieldma, project_integration
277: p_CONTRACT_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
278: p_AUTO_PROCESS_RMA IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
279: p_REPAIR_MODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
272: p_RESOURCE_GROUP IN NUMBER := Fnd_Api.G_MISS_NUM,
273: p_RESOURCE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
274: p_PROJECT_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
275: p_TASK_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
276: p_UNIT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR, -- rfieldma, project_integration
277: p_CONTRACT_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
278: p_AUTO_PROCESS_RMA IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
279: p_REPAIR_MODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
280: p_OBJECT_VERSION_NUMBER IN NUMBER := Fnd_Api.G_MISS_NUM,
273: p_RESOURCE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
274: p_PROJECT_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
275: p_TASK_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
276: p_UNIT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR, -- rfieldma, project_integration
277: p_CONTRACT_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
278: p_AUTO_PROCESS_RMA IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
279: p_REPAIR_MODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
280: p_OBJECT_VERSION_NUMBER IN NUMBER := Fnd_Api.G_MISS_NUM,
281: p_ITEM_REVISION IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
274: p_PROJECT_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
275: p_TASK_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
276: p_UNIT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR, -- rfieldma, project_integration
277: p_CONTRACT_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
278: p_AUTO_PROCESS_RMA IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
279: p_REPAIR_MODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
280: p_OBJECT_VERSION_NUMBER IN NUMBER := Fnd_Api.G_MISS_NUM,
281: p_ITEM_REVISION IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
282: p_INSTANCE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
275: p_TASK_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
276: p_UNIT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR, -- rfieldma, project_integration
277: p_CONTRACT_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
278: p_AUTO_PROCESS_RMA IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
279: p_REPAIR_MODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
280: p_OBJECT_VERSION_NUMBER IN NUMBER := Fnd_Api.G_MISS_NUM,
281: p_ITEM_REVISION IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
282: p_INSTANCE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
283: p_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
276: p_UNIT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR, -- rfieldma, project_integration
277: p_CONTRACT_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
278: p_AUTO_PROCESS_RMA IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
279: p_REPAIR_MODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
280: p_OBJECT_VERSION_NUMBER IN NUMBER := Fnd_Api.G_MISS_NUM,
281: p_ITEM_REVISION IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
282: p_INSTANCE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
283: p_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
284: p_STATUS_REASON_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
277: p_CONTRACT_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
278: p_AUTO_PROCESS_RMA IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
279: p_REPAIR_MODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
280: p_OBJECT_VERSION_NUMBER IN NUMBER := Fnd_Api.G_MISS_NUM,
281: p_ITEM_REVISION IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
282: p_INSTANCE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
283: p_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
284: p_STATUS_REASON_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
285: p_DATE_CLOSED IN DATE := Fnd_Api.G_MISS_DATE,
278: p_AUTO_PROCESS_RMA IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
279: p_REPAIR_MODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
280: p_OBJECT_VERSION_NUMBER IN NUMBER := Fnd_Api.G_MISS_NUM,
281: p_ITEM_REVISION IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
282: p_INSTANCE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
283: p_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
284: p_STATUS_REASON_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
285: p_DATE_CLOSED IN DATE := Fnd_Api.G_MISS_DATE,
286: p_APPROVAL_REQUIRED_FLAG IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
279: p_REPAIR_MODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
280: p_OBJECT_VERSION_NUMBER IN NUMBER := Fnd_Api.G_MISS_NUM,
281: p_ITEM_REVISION IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
282: p_INSTANCE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
283: p_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
284: p_STATUS_REASON_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
285: p_DATE_CLOSED IN DATE := Fnd_Api.G_MISS_DATE,
286: p_APPROVAL_REQUIRED_FLAG IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
287: p_APPROVAL_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
280: p_OBJECT_VERSION_NUMBER IN NUMBER := Fnd_Api.G_MISS_NUM,
281: p_ITEM_REVISION IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
282: p_INSTANCE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
283: p_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
284: p_STATUS_REASON_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
285: p_DATE_CLOSED IN DATE := Fnd_Api.G_MISS_DATE,
286: p_APPROVAL_REQUIRED_FLAG IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
287: p_APPROVAL_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
288: p_SERIAL_NUMBER IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
281: p_ITEM_REVISION IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
282: p_INSTANCE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
283: p_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
284: p_STATUS_REASON_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
285: p_DATE_CLOSED IN DATE := Fnd_Api.G_MISS_DATE,
286: p_APPROVAL_REQUIRED_FLAG IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
287: p_APPROVAL_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
288: p_SERIAL_NUMBER IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
289: p_PROMISE_DATE IN DATE := Fnd_Api.G_MISS_DATE,
282: p_INSTANCE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
283: p_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
284: p_STATUS_REASON_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
285: p_DATE_CLOSED IN DATE := Fnd_Api.G_MISS_DATE,
286: p_APPROVAL_REQUIRED_FLAG IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
287: p_APPROVAL_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
288: p_SERIAL_NUMBER IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
289: p_PROMISE_DATE IN DATE := Fnd_Api.G_MISS_DATE,
290: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
283: p_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
284: p_STATUS_REASON_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
285: p_DATE_CLOSED IN DATE := Fnd_Api.G_MISS_DATE,
286: p_APPROVAL_REQUIRED_FLAG IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
287: p_APPROVAL_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
288: p_SERIAL_NUMBER IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
289: p_PROMISE_DATE IN DATE := Fnd_Api.G_MISS_DATE,
290: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
291: p_ATTRIBUTE1 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
284: p_STATUS_REASON_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
285: p_DATE_CLOSED IN DATE := Fnd_Api.G_MISS_DATE,
286: p_APPROVAL_REQUIRED_FLAG IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
287: p_APPROVAL_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
288: p_SERIAL_NUMBER IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
289: p_PROMISE_DATE IN DATE := Fnd_Api.G_MISS_DATE,
290: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
291: p_ATTRIBUTE1 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
292: p_ATTRIBUTE2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
285: p_DATE_CLOSED IN DATE := Fnd_Api.G_MISS_DATE,
286: p_APPROVAL_REQUIRED_FLAG IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
287: p_APPROVAL_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
288: p_SERIAL_NUMBER IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
289: p_PROMISE_DATE IN DATE := Fnd_Api.G_MISS_DATE,
290: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
291: p_ATTRIBUTE1 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
292: p_ATTRIBUTE2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
293: p_ATTRIBUTE3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
286: p_APPROVAL_REQUIRED_FLAG IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
287: p_APPROVAL_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
288: p_SERIAL_NUMBER IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
289: p_PROMISE_DATE IN DATE := Fnd_Api.G_MISS_DATE,
290: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
291: p_ATTRIBUTE1 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
292: p_ATTRIBUTE2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
293: p_ATTRIBUTE3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
294: p_ATTRIBUTE4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
287: p_APPROVAL_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
288: p_SERIAL_NUMBER IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
289: p_PROMISE_DATE IN DATE := Fnd_Api.G_MISS_DATE,
290: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
291: p_ATTRIBUTE1 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
292: p_ATTRIBUTE2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
293: p_ATTRIBUTE3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
294: p_ATTRIBUTE4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
295: p_ATTRIBUTE5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
288: p_SERIAL_NUMBER IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
289: p_PROMISE_DATE IN DATE := Fnd_Api.G_MISS_DATE,
290: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
291: p_ATTRIBUTE1 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
292: p_ATTRIBUTE2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
293: p_ATTRIBUTE3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
294: p_ATTRIBUTE4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
295: p_ATTRIBUTE5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
296: p_ATTRIBUTE6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
289: p_PROMISE_DATE IN DATE := Fnd_Api.G_MISS_DATE,
290: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
291: p_ATTRIBUTE1 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
292: p_ATTRIBUTE2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
293: p_ATTRIBUTE3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
294: p_ATTRIBUTE4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
295: p_ATTRIBUTE5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
296: p_ATTRIBUTE6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
297: p_ATTRIBUTE7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
290: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
291: p_ATTRIBUTE1 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
292: p_ATTRIBUTE2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
293: p_ATTRIBUTE3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
294: p_ATTRIBUTE4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
295: p_ATTRIBUTE5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
296: p_ATTRIBUTE6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
297: p_ATTRIBUTE7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
298: p_ATTRIBUTE8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
291: p_ATTRIBUTE1 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
292: p_ATTRIBUTE2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
293: p_ATTRIBUTE3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
294: p_ATTRIBUTE4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
295: p_ATTRIBUTE5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
296: p_ATTRIBUTE6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
297: p_ATTRIBUTE7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
298: p_ATTRIBUTE8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
299: p_ATTRIBUTE9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
292: p_ATTRIBUTE2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
293: p_ATTRIBUTE3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
294: p_ATTRIBUTE4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
295: p_ATTRIBUTE5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
296: p_ATTRIBUTE6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
297: p_ATTRIBUTE7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
298: p_ATTRIBUTE8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
299: p_ATTRIBUTE9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
300: p_ATTRIBUTE10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
293: p_ATTRIBUTE3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
294: p_ATTRIBUTE4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
295: p_ATTRIBUTE5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
296: p_ATTRIBUTE6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
297: p_ATTRIBUTE7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
298: p_ATTRIBUTE8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
299: p_ATTRIBUTE9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
300: p_ATTRIBUTE10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
301: p_ATTRIBUTE11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
294: p_ATTRIBUTE4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
295: p_ATTRIBUTE5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
296: p_ATTRIBUTE6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
297: p_ATTRIBUTE7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
298: p_ATTRIBUTE8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
299: p_ATTRIBUTE9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
300: p_ATTRIBUTE10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
301: p_ATTRIBUTE11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
302: p_ATTRIBUTE12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
295: p_ATTRIBUTE5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
296: p_ATTRIBUTE6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
297: p_ATTRIBUTE7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
298: p_ATTRIBUTE8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
299: p_ATTRIBUTE9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
300: p_ATTRIBUTE10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
301: p_ATTRIBUTE11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
302: p_ATTRIBUTE12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
303: p_ATTRIBUTE13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
296: p_ATTRIBUTE6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
297: p_ATTRIBUTE7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
298: p_ATTRIBUTE8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
299: p_ATTRIBUTE9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
300: p_ATTRIBUTE10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
301: p_ATTRIBUTE11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
302: p_ATTRIBUTE12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
303: p_ATTRIBUTE13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
304: p_ATTRIBUTE14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
297: p_ATTRIBUTE7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
298: p_ATTRIBUTE8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
299: p_ATTRIBUTE9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
300: p_ATTRIBUTE10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
301: p_ATTRIBUTE11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
302: p_ATTRIBUTE12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
303: p_ATTRIBUTE13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
304: p_ATTRIBUTE14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
305: p_ATTRIBUTE15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
298: p_ATTRIBUTE8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
299: p_ATTRIBUTE9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
300: p_ATTRIBUTE10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
301: p_ATTRIBUTE11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
302: p_ATTRIBUTE12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
303: p_ATTRIBUTE13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
304: p_ATTRIBUTE14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
305: p_ATTRIBUTE15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
306: P_ATTRIBUTE16 IN VARCHAR2 := FND_API.G_MISS_CHAR,-- SUBHAT, DFF CHANGES(bug#7497907)
299: p_ATTRIBUTE9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
300: p_ATTRIBUTE10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
301: p_ATTRIBUTE11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
302: p_ATTRIBUTE12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
303: p_ATTRIBUTE13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
304: p_ATTRIBUTE14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
305: p_ATTRIBUTE15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
306: P_ATTRIBUTE16 IN VARCHAR2 := FND_API.G_MISS_CHAR,-- SUBHAT, DFF CHANGES(bug#7497907)
307: P_ATTRIBUTE17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_ATTRIBUTE10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
301: p_ATTRIBUTE11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
302: p_ATTRIBUTE12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
303: p_ATTRIBUTE13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
304: p_ATTRIBUTE14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
305: p_ATTRIBUTE15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
306: P_ATTRIBUTE16 IN VARCHAR2 := FND_API.G_MISS_CHAR,-- SUBHAT, DFF CHANGES(bug#7497907)
307: P_ATTRIBUTE17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
308: P_ATTRIBUTE18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_ATTRIBUTE11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
302: p_ATTRIBUTE12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
303: p_ATTRIBUTE13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
304: p_ATTRIBUTE14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
305: p_ATTRIBUTE15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
306: P_ATTRIBUTE16 IN VARCHAR2 := FND_API.G_MISS_CHAR,-- SUBHAT, DFF CHANGES(bug#7497907)
307: P_ATTRIBUTE17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
308: P_ATTRIBUTE18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: P_ATTRIBUTE19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
302: p_ATTRIBUTE12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
303: p_ATTRIBUTE13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
304: p_ATTRIBUTE14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
305: p_ATTRIBUTE15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
306: P_ATTRIBUTE16 IN VARCHAR2 := FND_API.G_MISS_CHAR,-- SUBHAT, DFF CHANGES(bug#7497907)
307: P_ATTRIBUTE17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
308: P_ATTRIBUTE18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: P_ATTRIBUTE19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: P_ATTRIBUTE20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_ATTRIBUTE13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
304: p_ATTRIBUTE14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
305: p_ATTRIBUTE15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
306: P_ATTRIBUTE16 IN VARCHAR2 := FND_API.G_MISS_CHAR,-- SUBHAT, DFF CHANGES(bug#7497907)
307: P_ATTRIBUTE17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
308: P_ATTRIBUTE18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: P_ATTRIBUTE19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: P_ATTRIBUTE20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: P_ATTRIBUTE21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_ATTRIBUTE14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
305: p_ATTRIBUTE15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
306: P_ATTRIBUTE16 IN VARCHAR2 := FND_API.G_MISS_CHAR,-- SUBHAT, DFF CHANGES(bug#7497907)
307: P_ATTRIBUTE17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
308: P_ATTRIBUTE18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: P_ATTRIBUTE19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: P_ATTRIBUTE20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: P_ATTRIBUTE21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: P_ATTRIBUTE22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_ATTRIBUTE15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
306: P_ATTRIBUTE16 IN VARCHAR2 := FND_API.G_MISS_CHAR,-- SUBHAT, DFF CHANGES(bug#7497907)
307: P_ATTRIBUTE17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
308: P_ATTRIBUTE18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: P_ATTRIBUTE19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: P_ATTRIBUTE20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: P_ATTRIBUTE21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: P_ATTRIBUTE22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: P_ATTRIBUTE23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
306: P_ATTRIBUTE16 IN VARCHAR2 := FND_API.G_MISS_CHAR,-- SUBHAT, DFF CHANGES(bug#7497907)
307: P_ATTRIBUTE17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
308: P_ATTRIBUTE18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: P_ATTRIBUTE19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: P_ATTRIBUTE20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: P_ATTRIBUTE21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: P_ATTRIBUTE22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: P_ATTRIBUTE23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: P_ATTRIBUTE24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
307: P_ATTRIBUTE17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
308: P_ATTRIBUTE18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: P_ATTRIBUTE19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: P_ATTRIBUTE20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: P_ATTRIBUTE21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: P_ATTRIBUTE22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: P_ATTRIBUTE23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: P_ATTRIBUTE24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: P_ATTRIBUTE25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
308: P_ATTRIBUTE18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: P_ATTRIBUTE19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: P_ATTRIBUTE20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: P_ATTRIBUTE21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: P_ATTRIBUTE22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: P_ATTRIBUTE23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: P_ATTRIBUTE24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: P_ATTRIBUTE25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: P_ATTRIBUTE26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: P_ATTRIBUTE19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: P_ATTRIBUTE20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: P_ATTRIBUTE21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: P_ATTRIBUTE22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: P_ATTRIBUTE23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: P_ATTRIBUTE24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: P_ATTRIBUTE25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: P_ATTRIBUTE26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: P_ATTRIBUTE27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: P_ATTRIBUTE20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: P_ATTRIBUTE21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: P_ATTRIBUTE22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: P_ATTRIBUTE23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: P_ATTRIBUTE24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: P_ATTRIBUTE25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: P_ATTRIBUTE26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: P_ATTRIBUTE27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: P_ATTRIBUTE28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: P_ATTRIBUTE21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: P_ATTRIBUTE22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: P_ATTRIBUTE23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: P_ATTRIBUTE24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: P_ATTRIBUTE25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: P_ATTRIBUTE26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: P_ATTRIBUTE27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: P_ATTRIBUTE28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: P_ATTRIBUTE29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: P_ATTRIBUTE22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: P_ATTRIBUTE23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: P_ATTRIBUTE24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: P_ATTRIBUTE25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: P_ATTRIBUTE26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: P_ATTRIBUTE27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: P_ATTRIBUTE28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: P_ATTRIBUTE29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: P_ATTRIBUTE30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: P_ATTRIBUTE23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: P_ATTRIBUTE24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: P_ATTRIBUTE25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: P_ATTRIBUTE26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: P_ATTRIBUTE27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: P_ATTRIBUTE28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: P_ATTRIBUTE29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: P_ATTRIBUTE30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
321: p_QUANTITY IN NUMBER := Fnd_Api.G_MISS_NUM,
314: P_ATTRIBUTE24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: P_ATTRIBUTE25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: P_ATTRIBUTE26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: P_ATTRIBUTE27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: P_ATTRIBUTE28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: P_ATTRIBUTE29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: P_ATTRIBUTE30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
321: p_QUANTITY IN NUMBER := Fnd_Api.G_MISS_NUM,
322: p_QUANTITY_IN_WIP IN NUMBER := Fnd_Api.G_MISS_NUM,
315: P_ATTRIBUTE25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: P_ATTRIBUTE26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: P_ATTRIBUTE27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: P_ATTRIBUTE28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: P_ATTRIBUTE29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: P_ATTRIBUTE30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
321: p_QUANTITY IN NUMBER := Fnd_Api.G_MISS_NUM,
322: p_QUANTITY_IN_WIP IN NUMBER := Fnd_Api.G_MISS_NUM,
323: p_QUANTITY_RCVD IN NUMBER := Fnd_Api.G_MISS_NUM,
316: P_ATTRIBUTE26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: P_ATTRIBUTE27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: P_ATTRIBUTE28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: P_ATTRIBUTE29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: P_ATTRIBUTE30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
321: p_QUANTITY IN NUMBER := Fnd_Api.G_MISS_NUM,
322: p_QUANTITY_IN_WIP IN NUMBER := Fnd_Api.G_MISS_NUM,
323: p_QUANTITY_RCVD IN NUMBER := Fnd_Api.G_MISS_NUM,
324: p_QUANTITY_SHIPPED IN NUMBER := Fnd_Api.G_MISS_NUM,
317: P_ATTRIBUTE27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: P_ATTRIBUTE28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: P_ATTRIBUTE29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: P_ATTRIBUTE30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
321: p_QUANTITY IN NUMBER := Fnd_Api.G_MISS_NUM,
322: p_QUANTITY_IN_WIP IN NUMBER := Fnd_Api.G_MISS_NUM,
323: p_QUANTITY_RCVD IN NUMBER := Fnd_Api.G_MISS_NUM,
324: p_QUANTITY_SHIPPED IN NUMBER := Fnd_Api.G_MISS_NUM,
325: p_CURRENCY_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
318: P_ATTRIBUTE28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: P_ATTRIBUTE29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: P_ATTRIBUTE30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
321: p_QUANTITY IN NUMBER := Fnd_Api.G_MISS_NUM,
322: p_QUANTITY_IN_WIP IN NUMBER := Fnd_Api.G_MISS_NUM,
323: p_QUANTITY_RCVD IN NUMBER := Fnd_Api.G_MISS_NUM,
324: p_QUANTITY_SHIPPED IN NUMBER := Fnd_Api.G_MISS_NUM,
325: p_CURRENCY_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
326: p_DEFAULT_PO_NUM IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
319: P_ATTRIBUTE29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: P_ATTRIBUTE30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
321: p_QUANTITY IN NUMBER := Fnd_Api.G_MISS_NUM,
322: p_QUANTITY_IN_WIP IN NUMBER := Fnd_Api.G_MISS_NUM,
323: p_QUANTITY_RCVD IN NUMBER := Fnd_Api.G_MISS_NUM,
324: p_QUANTITY_SHIPPED IN NUMBER := Fnd_Api.G_MISS_NUM,
325: p_CURRENCY_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
326: p_DEFAULT_PO_NUM IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
327: p_REPAIR_GROUP_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
320: P_ATTRIBUTE30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
321: p_QUANTITY IN NUMBER := Fnd_Api.G_MISS_NUM,
322: p_QUANTITY_IN_WIP IN NUMBER := Fnd_Api.G_MISS_NUM,
323: p_QUANTITY_RCVD IN NUMBER := Fnd_Api.G_MISS_NUM,
324: p_QUANTITY_SHIPPED IN NUMBER := Fnd_Api.G_MISS_NUM,
325: p_CURRENCY_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
326: p_DEFAULT_PO_NUM IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
327: p_REPAIR_GROUP_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
328: p_RO_TXN_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
321: p_QUANTITY IN NUMBER := Fnd_Api.G_MISS_NUM,
322: p_QUANTITY_IN_WIP IN NUMBER := Fnd_Api.G_MISS_NUM,
323: p_QUANTITY_RCVD IN NUMBER := Fnd_Api.G_MISS_NUM,
324: p_QUANTITY_SHIPPED IN NUMBER := Fnd_Api.G_MISS_NUM,
325: p_CURRENCY_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
326: p_DEFAULT_PO_NUM IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
327: p_REPAIR_GROUP_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
328: p_RO_TXN_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
329: p_ORDER_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
322: p_QUANTITY_IN_WIP IN NUMBER := Fnd_Api.G_MISS_NUM,
323: p_QUANTITY_RCVD IN NUMBER := Fnd_Api.G_MISS_NUM,
324: p_QUANTITY_SHIPPED IN NUMBER := Fnd_Api.G_MISS_NUM,
325: p_CURRENCY_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
326: p_DEFAULT_PO_NUM IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
327: p_REPAIR_GROUP_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
328: p_RO_TXN_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
329: p_ORDER_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
330: p_ORIGINAL_SOURCE_REFERENCE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
323: p_QUANTITY_RCVD IN NUMBER := Fnd_Api.G_MISS_NUM,
324: p_QUANTITY_SHIPPED IN NUMBER := Fnd_Api.G_MISS_NUM,
325: p_CURRENCY_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
326: p_DEFAULT_PO_NUM IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
327: p_REPAIR_GROUP_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
328: p_RO_TXN_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
329: p_ORDER_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
330: p_ORIGINAL_SOURCE_REFERENCE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
331: p_ORIGINAL_SOURCE_HEADER_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
324: p_QUANTITY_SHIPPED IN NUMBER := Fnd_Api.G_MISS_NUM,
325: p_CURRENCY_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
326: p_DEFAULT_PO_NUM IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
327: p_REPAIR_GROUP_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
328: p_RO_TXN_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
329: p_ORDER_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
330: p_ORIGINAL_SOURCE_REFERENCE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
331: p_ORIGINAL_SOURCE_HEADER_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
332: p_ORIGINAL_SOURCE_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
325: p_CURRENCY_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
326: p_DEFAULT_PO_NUM IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
327: p_REPAIR_GROUP_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
328: p_RO_TXN_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
329: p_ORDER_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
330: p_ORIGINAL_SOURCE_REFERENCE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
331: p_ORIGINAL_SOURCE_HEADER_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
332: p_ORIGINAL_SOURCE_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
333: p_PRICE_LIST_HEADER_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
326: p_DEFAULT_PO_NUM IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
327: p_REPAIR_GROUP_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
328: p_RO_TXN_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
329: p_ORDER_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
330: p_ORIGINAL_SOURCE_REFERENCE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
331: p_ORIGINAL_SOURCE_HEADER_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
332: p_ORIGINAL_SOURCE_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
333: p_PRICE_LIST_HEADER_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
334: p_INVENTORY_ORG_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
327: p_REPAIR_GROUP_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
328: p_RO_TXN_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
329: p_ORDER_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
330: p_ORIGINAL_SOURCE_REFERENCE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
331: p_ORIGINAL_SOURCE_HEADER_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
332: p_ORIGINAL_SOURCE_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
333: p_PRICE_LIST_HEADER_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
334: p_INVENTORY_ORG_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
335: -- swai: bug 4666344 added problem description
328: p_RO_TXN_STATUS IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
329: p_ORDER_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
330: p_ORIGINAL_SOURCE_REFERENCE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
331: p_ORIGINAL_SOURCE_HEADER_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
332: p_ORIGINAL_SOURCE_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
333: p_PRICE_LIST_HEADER_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
334: p_INVENTORY_ORG_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
335: -- swai: bug 4666344 added problem description
336: p_PROBLEM_DESCRIPTION IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
329: p_ORDER_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
330: p_ORIGINAL_SOURCE_REFERENCE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
331: p_ORIGINAL_SOURCE_HEADER_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
332: p_ORIGINAL_SOURCE_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
333: p_PRICE_LIST_HEADER_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
334: p_INVENTORY_ORG_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
335: -- swai: bug 4666344 added problem description
336: p_PROBLEM_DESCRIPTION IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
337: p_RO_PRIORITY_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR, -- swai: R12
330: p_ORIGINAL_SOURCE_REFERENCE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
331: p_ORIGINAL_SOURCE_HEADER_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
332: p_ORIGINAL_SOURCE_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
333: p_PRICE_LIST_HEADER_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
334: p_INVENTORY_ORG_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
335: -- swai: bug 4666344 added problem description
336: p_PROBLEM_DESCRIPTION IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
337: p_RO_PRIORITY_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR, -- swai: R12
338: p_RESOLVE_BY_DATE IN DATE := Fnd_Api.G_MISS_DATE, -- rfieldma: 5355051
332: p_ORIGINAL_SOURCE_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
333: p_PRICE_LIST_HEADER_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
334: p_INVENTORY_ORG_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
335: -- swai: bug 4666344 added problem description
336: p_PROBLEM_DESCRIPTION IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
337: p_RO_PRIORITY_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR, -- swai: R12
338: p_RESOLVE_BY_DATE IN DATE := Fnd_Api.G_MISS_DATE, -- rfieldma: 5355051
339: p_BULLETIN_CHECK_DATE IN DATE := Fnd_Api.G_MISS_DATE,
340: p_ESCALATION_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
333: p_PRICE_LIST_HEADER_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
334: p_INVENTORY_ORG_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
335: -- swai: bug 4666344 added problem description
336: p_PROBLEM_DESCRIPTION IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
337: p_RO_PRIORITY_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR, -- swai: R12
338: p_RESOLVE_BY_DATE IN DATE := Fnd_Api.G_MISS_DATE, -- rfieldma: 5355051
339: p_BULLETIN_CHECK_DATE IN DATE := Fnd_Api.G_MISS_DATE,
340: p_ESCALATION_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
341: x_Repln_Rec OUT NOCOPY Csd_Repairs_Pub.Repln_Rec_Type
334: p_INVENTORY_ORG_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
335: -- swai: bug 4666344 added problem description
336: p_PROBLEM_DESCRIPTION IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
337: p_RO_PRIORITY_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR, -- swai: R12
338: p_RESOLVE_BY_DATE IN DATE := Fnd_Api.G_MISS_DATE, -- rfieldma: 5355051
339: p_BULLETIN_CHECK_DATE IN DATE := Fnd_Api.G_MISS_DATE,
340: p_ESCALATION_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
341: x_Repln_Rec OUT NOCOPY Csd_Repairs_Pub.Repln_Rec_Type
342: ) IS
335: -- swai: bug 4666344 added problem description
336: p_PROBLEM_DESCRIPTION IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
337: p_RO_PRIORITY_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR, -- swai: R12
338: p_RESOLVE_BY_DATE IN DATE := Fnd_Api.G_MISS_DATE, -- rfieldma: 5355051
339: p_BULLETIN_CHECK_DATE IN DATE := Fnd_Api.G_MISS_DATE,
340: p_ESCALATION_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
341: x_Repln_Rec OUT NOCOPY Csd_Repairs_Pub.Repln_Rec_Type
342: ) IS
343: --
336: p_PROBLEM_DESCRIPTION IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
337: p_RO_PRIORITY_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR, -- swai: R12
338: p_RESOLVE_BY_DATE IN DATE := Fnd_Api.G_MISS_DATE, -- rfieldma: 5355051
339: p_BULLETIN_CHECK_DATE IN DATE := Fnd_Api.G_MISS_DATE,
340: p_ESCALATION_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
341: x_Repln_Rec OUT NOCOPY Csd_Repairs_Pub.Repln_Rec_Type
342: ) IS
343: --
344: BEGIN
429: END Convert_to_Repln_Rec_Type;
430:
431: PROCEDURE Convert_to_DEF_Rec_Type
432: (
433: p_attribute_category IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
434: p_attribute1 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
435: p_attribute2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
436: p_attribute3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
437: p_attribute4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
430:
431: PROCEDURE Convert_to_DEF_Rec_Type
432: (
433: p_attribute_category IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
434: p_attribute1 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
435: p_attribute2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
436: p_attribute3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
437: p_attribute4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
438: p_attribute5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
431: PROCEDURE Convert_to_DEF_Rec_Type
432: (
433: p_attribute_category IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
434: p_attribute1 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
435: p_attribute2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
436: p_attribute3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
437: p_attribute4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
438: p_attribute5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
439: p_attribute6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
432: (
433: p_attribute_category IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
434: p_attribute1 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
435: p_attribute2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
436: p_attribute3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
437: p_attribute4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
438: p_attribute5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
439: p_attribute6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
440: p_attribute7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
433: p_attribute_category IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
434: p_attribute1 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
435: p_attribute2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
436: p_attribute3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
437: p_attribute4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
438: p_attribute5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
439: p_attribute6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
440: p_attribute7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
441: p_attribute8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
434: p_attribute1 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
435: p_attribute2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
436: p_attribute3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
437: p_attribute4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
438: p_attribute5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
439: p_attribute6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
440: p_attribute7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
441: p_attribute8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
442: p_attribute9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
435: p_attribute2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
436: p_attribute3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
437: p_attribute4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
438: p_attribute5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
439: p_attribute6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
440: p_attribute7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
441: p_attribute8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
442: p_attribute9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
443: p_attribute10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
436: p_attribute3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
437: p_attribute4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
438: p_attribute5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
439: p_attribute6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
440: p_attribute7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
441: p_attribute8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
442: p_attribute9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
443: p_attribute10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
444: p_attribute11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
437: p_attribute4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
438: p_attribute5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
439: p_attribute6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
440: p_attribute7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
441: p_attribute8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
442: p_attribute9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
443: p_attribute10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
444: p_attribute11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
445: p_attribute12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
438: p_attribute5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
439: p_attribute6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
440: p_attribute7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
441: p_attribute8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
442: p_attribute9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
443: p_attribute10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
444: p_attribute11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
445: p_attribute12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
446: p_attribute13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
439: p_attribute6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
440: p_attribute7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
441: p_attribute8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
442: p_attribute9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
443: p_attribute10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
444: p_attribute11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
445: p_attribute12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
446: p_attribute13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
447: p_attribute14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
440: p_attribute7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
441: p_attribute8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
442: p_attribute9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
443: p_attribute10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
444: p_attribute11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
445: p_attribute12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
446: p_attribute13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
447: p_attribute14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
448: p_attribute15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
441: p_attribute8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
442: p_attribute9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
443: p_attribute10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
444: p_attribute11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
445: p_attribute12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
446: p_attribute13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
447: p_attribute14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
448: p_attribute15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
449: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- subhat, dff changes(bug#7497907)
442: p_attribute9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
443: p_attribute10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
444: p_attribute11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
445: p_attribute12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
446: p_attribute13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
447: p_attribute14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
448: p_attribute15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
449: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- subhat, dff changes(bug#7497907)
450: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_attribute10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
444: p_attribute11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
445: p_attribute12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
446: p_attribute13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
447: p_attribute14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
448: p_attribute15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
449: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- subhat, dff changes(bug#7497907)
450: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_attribute11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
445: p_attribute12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
446: p_attribute13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
447: p_attribute14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
448: p_attribute15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
449: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- subhat, dff changes(bug#7497907)
450: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_attribute12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
446: p_attribute13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
447: p_attribute14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
448: p_attribute15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
449: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- subhat, dff changes(bug#7497907)
450: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_attribute13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
447: p_attribute14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
448: p_attribute15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
449: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- subhat, dff changes(bug#7497907)
450: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_attribute14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
448: p_attribute15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
449: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- subhat, dff changes(bug#7497907)
450: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_attribute15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
449: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- subhat, dff changes(bug#7497907)
450: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
449: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- subhat, dff changes(bug#7497907)
450: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_attribute27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_attribute27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
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,
455: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
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,
456: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
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
457: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
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
458: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
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: --
459: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
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
535: BEGIN
536: --
537: SAVEPOINT Get_Entitlements_Pvt;
538: -- Standard call to check for call compatibility.
539: IF NOT Fnd_Api.Compatible_API_Call
540: (l_api_version_number,
541: p_api_version_number,
542: l_api_name,
543: G_PKG_NAME)
541: p_api_version_number,
542: l_api_name,
543: G_PKG_NAME)
544: THEN
545: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
546: END IF;
547: -- Initialize message list if p_init_msg_list is set to TRUE.
548: IF Fnd_Api.to_Boolean(p_init_msg_list)
549: THEN
544: THEN
545: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
546: END IF;
547: -- Initialize message list if p_init_msg_list is set to TRUE.
548: IF Fnd_Api.to_Boolean(p_init_msg_list)
549: THEN
550: Fnd_Msg_Pub.initialize;
551: END IF;
552: -- Initialize API return status to success
549: THEN
550: Fnd_Msg_Pub.initialize;
551: END IF;
552: -- Initialize API return status to success
553: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
554: --
555: -- API body
556: --
557: l_input_param_rec.contract_number := p_contract_number;
583: x_msg_count => x_msg_count,
584: x_msg_data => x_msg_data,
585: x_ent_contracts => x_ent_contracts);
586: --
587: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
588: RAISE Fnd_Api.G_EXC_ERROR ;
589: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
590: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
591: END IF ;
584: x_msg_data => x_msg_data,
585: x_ent_contracts => x_ent_contracts);
586: --
587: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
588: RAISE Fnd_Api.G_EXC_ERROR ;
589: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
590: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
591: END IF ;
592: --
585: x_ent_contracts => x_ent_contracts);
586: --
587: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
588: RAISE Fnd_Api.G_EXC_ERROR ;
589: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
590: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
591: END IF ;
592: --
593: -- End of API body.
586: --
587: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
588: RAISE Fnd_Api.G_EXC_ERROR ;
589: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
590: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
591: END IF ;
592: --
593: -- End of API body.
594: --
592: --
593: -- End of API body.
594: --
595: -- Standard check for p_commit
596: IF Fnd_Api.to_Boolean(p_commit)
597: THEN
598: COMMIT WORK;
599: END IF;
600: -- Standard call to get message count and if count is 1, get message info.
603: p_data => x_msg_data
604: );
605: --
606: EXCEPTION
607: WHEN Fnd_Api.G_EXC_ERROR THEN
608: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
609: (P_API_NAME => L_API_NAME
610: ,P_PKG_NAME => G_PKG_NAME
611: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
614: ,X_MSG_DATA => X_MSG_DATA
615: ,X_RETURN_STATUS => X_RETURN_STATUS);
616: -- RAISE;
617: --
618: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
619: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
620: (P_API_NAME => L_API_NAME
621: ,P_PKG_NAME => G_PKG_NAME
622: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
766:
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',
780: OPEN repair_details_cur ;
781: FETCH repair_details_cur INTO l_repair_mode;
782: IF(repair_details_cur%NOTFOUND) THEN
783: CLOSE repair_details_Cur;
784: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
785: END IF;
786: CLOSE repair_details_cur;
787:
788: /****
813: '-------------there are open jobs---------------');
814: END IF;
815: Fnd_Message.set_name('CSD', 'CSD_API_OPEN_WIP_JOBS');
816: Fnd_Msg_Pub.ADD;
817: RAISE Fnd_Api.G_EXC_ERROR ;
818: END IF;
819: CLOSE wipjob_cur;
820: ELSIF (l_repair_mode = C_TASK_MODE) THEN
821:
833: '-------------there are open tasks---------------');
834: END IF;
835: Fnd_Message.set_name('CSD', 'CSD_API_OPEN_TASKS');
836: Fnd_Msg_Pub.ADD;
837: RAISE Fnd_Api.G_EXC_ERROR ;
838: END IF;
839: CLOSE task_cur;
840: END IF;
841: END IF;
845: '-------------Leaving check_task_n_wipjob----------------');
846: END IF;
847:
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,
846: END IF;
847:
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',
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
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,
855: 'EXC_ERROR ['||x_msg_data||']');
856: END IF;
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;
866:
867: WHEN OTHERS THEN
868: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
869: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
870: THEN
871: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME , l_api_name );
872: END IF;
922: BEGIN
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',
940: IF (p_repair_status_rec.repair_number IS NULL) THEN
941: -- value based parameter is also NULL or MISSING
942: Fnd_Message.SET_NAME ('CSD', 'CSD_API_INV_REP_NUM');
943: Fnd_Msg_Pub.ADD;
944: x_return_status := Fnd_Api.G_RET_STS_ERROR;
945: ELSE
946: OPEN repair_id_conv_cur(p_repair_status_rec.repair_number);
947: FETCH repair_id_conv_cur INTO x_repair_status_rec.repair_line_id;
948: IF repair_id_conv_cur%NOTFOUND THEN
950: -- Conversion failed.
951: CLOSE repair_id_conv_cur;
952: Fnd_Message.SET_NAME ('CSD', 'CSD_API_INV_REP_NUM');
953: Fnd_Msg_Pub.ADD;
954: x_return_status := Fnd_Api.G_RET_STS_ERROR;
955: RAISE Fnd_Api.G_EXC_ERROR;
956: END IF;
957: CLOSE repair_id_conv_cur;
958: END IF;
951: CLOSE repair_id_conv_cur;
952: Fnd_Message.SET_NAME ('CSD', 'CSD_API_INV_REP_NUM');
953: Fnd_Msg_Pub.ADD;
954: x_return_status := Fnd_Api.G_RET_STS_ERROR;
955: RAISE Fnd_Api.G_EXC_ERROR;
956: END IF;
957: CLOSE repair_id_conv_cur;
958: END IF;
959: ELSIF p_repair_status_rec.repair_line_id IS NOT NULL THEN
973: IF (p_repair_status_rec.repair_status IS NULL) THEN
974: -- value based parameter is also NULL or MISSING
975: Fnd_Message.SET_NAME('CSD','CSD_INVALID_FLOW_STATUS');
976: Fnd_Msg_Pub.ADD;
977: x_return_status := Fnd_Api.G_RET_STS_ERROR;
978: ELSE
979: OPEN flow_stat_cur(p_repair_status_Rec.repair_status);
980: FETCH flow_stat_cur INTO x_repair_status_Rec.repair_status_id;
981: IF(flow_stat_cur%NOTFOUND) THEN
981: IF(flow_stat_cur%NOTFOUND) THEN
982: CLOSE flow_stat_cur;
983: Fnd_Message.SET_NAME('CSD','CSD_INVALID_FLOW_STATUS');
984: Fnd_Msg_Pub.ADD;
985: x_return_status := Fnd_Api.G_RET_STS_ERROR;
986: RAISE Fnd_Api.G_EXC_ERROR;
987: END IF;
988: CLOSE flow_stat_cur;
989: END IF;
982: CLOSE flow_stat_cur;
983: Fnd_Message.SET_NAME('CSD','CSD_INVALID_FLOW_STATUS');
984: Fnd_Msg_Pub.ADD;
985: x_return_status := Fnd_Api.G_RET_STS_ERROR;
986: RAISE Fnd_Api.G_EXC_ERROR;
987: END IF;
988: CLOSE flow_stat_cur;
989: END IF;
990: ELSIF p_repair_status_rec.repair_status_id IS NOT NULL THEN
1056: p_statement_type => 'EXISTS'
1057:
1058: *****************/
1059:
1060: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1061: /*!!!!!!!!!! Temporarily disabling the security
1062: return ;!!!!!*******/
1063:
1064: l_table_alias := 'ro';
1074: p_table_alias => l_table_alias );
1075:
1076:
1077: debug('getSecurity_predicate return value['||l_Return_status||']');
1078: debug('success['||FND_API.G_RET_STS_SUCCESS||']');
1079: debug('getSecurity_predicate predicate value['||l_predicate||']');
1080:
1081: IF(l_return_status <> FND_API.G_TRUE) THEN
1082: debug('returning l_return_status['||l_return_status||']');
1077: debug('getSecurity_predicate return value['||l_Return_status||']');
1078: debug('success['||FND_API.G_RET_STS_SUCCESS||']');
1079: debug('getSecurity_predicate predicate value['||l_predicate||']');
1080:
1081: IF(l_return_status <> FND_API.G_TRUE) THEN
1082: debug('returning l_return_status['||l_return_status||']');
1083: x_return_status := FND_API.G_RET_STS_ERROR;
1084: ELSE
1085: IF(l_predicate IS NOT NULL AND l_predicate <> '(1=1)') THEN
1079: debug('getSecurity_predicate predicate value['||l_predicate||']');
1080:
1081: IF(l_return_status <> FND_API.G_TRUE) THEN
1082: debug('returning l_return_status['||l_return_status||']');
1083: x_return_status := FND_API.G_RET_STS_ERROR;
1084: ELSE
1085: IF(l_predicate IS NOT NULL AND l_predicate <> '(1=1)') THEN
1086:
1087: debug('forming sql str');
1094: EXECUTE IMMEDIATE l_sql_str INTO l_tmp_Str
1095: USING p_repair_line_id ;
1096: EXCEPTION
1097: WHEN NO_DATA_FOUND THEN
1098: x_return_status := FND_API.G_RET_STS_ERROR;
1099: END;
1100: debug('l_tmp_Str after['||l_tmp_str||']');
1101: IF(l_tmp_str IS NULL ) THEN
1102: debug('returning failure because l_tmp_Str['||l_tmp_str||']');
1099: END;
1100: debug('l_tmp_Str after['||l_tmp_str||']');
1101: IF(l_tmp_str IS NULL ) THEN
1102: debug('returning failure because l_tmp_Str['||l_tmp_str||']');
1103: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1104: END IF;
1105:
1106: ELSE
1107: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1103: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1104: END IF;
1105:
1106: ELSE
1107: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1108: END IF;
1109: END IF;
1110:
1111: /************************
1144: USING TO_CHAR(p_repair_line_id),
1145: C_CUST_PROD_ACTION_CODE ,
1146: C_3RDPARTY_RMA_ACTION_TYPE ;
1147: IF(l_tmp_str IS NULL ) THEN
1148: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1149: END IF;
1150:
1151: END IF;
1152: ************************************************
1187: USING TO_CHAR(p_repair_line_id),
1188: C_CUST_PROD_ACTION_CODE ,
1189: C_3RDPARTY_SHIP_ACTION_TYPE ;
1190: IF(l_tmp_str IS NULL ) THEN
1191: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1192: END IF;
1193:
1194: END IF;
1195: ************************************************
1197:
1198: debug('returning success');
1199: EXCEPTION
1200: WHEN OTHERS THEN
1201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1202: debug('sqlca.sqlcode ['||sqlcode ||']');
1203: debug('sqlca.sqlerrm['||sqlerrm||']');
1204:
1205:
1309: 'Enter - Change Item IB Owner');
1310: end if;
1311:
1312: -- Initialize API return status to success
1313: x_return_status := FND_API.G_RET_STS_SUCCESS;
1314:
1315: -- create a TCA relationship between the current owner and
1316: -- new owner, if desired
1317: if(p_create_tca_relation = fnd_api.g_true) then
1313: x_return_status := FND_API.G_RET_STS_SUCCESS;
1314:
1315: -- create a TCA relationship between the current owner and
1316: -- new owner, if desired
1317: if(p_create_tca_relation = fnd_api.g_true) then
1318:
1319: -- get info for original owner
1320: Open c_hz_parties_info(p_current_owner_party_id);
1321: Fetch c_hz_parties_info
1335: csd_ib_chown_cuhk.get_tca_rel_info (
1336: p_in_param => l_tca_rel_in_params,
1337: x_out_param => l_tca_rel_out_params
1338: );
1339: if NOT(l_tca_rel_out_params.return_status = FND_API.G_RET_STS_SUCCESS) then
1340: RAISE FND_API.G_EXC_ERROR;
1341: end if;
1342:
1343: -- populate the relationship rec before calling API
1336: p_in_param => l_tca_rel_in_params,
1337: x_out_param => l_tca_rel_out_params
1338: );
1339: if NOT(l_tca_rel_out_params.return_status = FND_API.G_RET_STS_SUCCESS) then
1340: RAISE FND_API.G_EXC_ERROR;
1341: end if;
1342:
1343: -- populate the relationship rec before calling API
1344: -- Assumption: the owners will always be from hz_parties
1365: -- only create the TCA relationship if one does not exist already
1366: if (l_tca_rel_count = 0 ) then
1367: -- create the TCA relation
1368: hz_relationship_v2pub.create_relationship(
1369: p_init_msg_list => fnd_api.g_false,
1370: p_relationship_rec => l_relationship_rec,
1371: x_relationship_id => x_tca_relation_id,
1372: x_party_id => l_rel_party_id,
1373: x_party_number => l_rel_party_number,
1375: x_msg_count => x_msg_count,
1376: x_msg_data => x_msg_data,
1377: p_create_org_contact => 'Y'
1378: );
1379: if NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1380: RAISE FND_API.G_EXC_ERROR;
1381: end if;
1382: end if; -- l_tca_rel_count = 0
1383: End If; -- p_create_tca_relation = true
1376: x_msg_data => x_msg_data,
1377: p_create_org_contact => 'Y'
1378: );
1379: if NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1380: RAISE FND_API.G_EXC_ERROR;
1381: end if;
1382: end if; -- l_tca_rel_count = 0
1383: End If; -- p_create_tca_relation = true
1384:
1426: -- Call the Update item instance API
1427: csi_item_instance_pub.update_item_instance
1428: (
1429: p_api_version => 1.0,
1430: p_commit => fnd_api.g_false,
1431: p_init_msg_list => fnd_api.g_true,
1432: p_validation_level => fnd_api.g_valid_level_full,
1433: p_instance_rec => l_instance_rec,
1434: p_ext_attrib_values_tbl => l_ext_attrib_values_tbl,
1427: csi_item_instance_pub.update_item_instance
1428: (
1429: p_api_version => 1.0,
1430: p_commit => fnd_api.g_false,
1431: p_init_msg_list => fnd_api.g_true,
1432: p_validation_level => fnd_api.g_valid_level_full,
1433: p_instance_rec => l_instance_rec,
1434: p_ext_attrib_values_tbl => l_ext_attrib_values_tbl,
1435: p_party_tbl => l_party_tbl,
1428: (
1429: p_api_version => 1.0,
1430: p_commit => fnd_api.g_false,
1431: p_init_msg_list => fnd_api.g_true,
1432: p_validation_level => fnd_api.g_valid_level_full,
1433: p_instance_rec => l_instance_rec,
1434: p_ext_attrib_values_tbl => l_ext_attrib_values_tbl,
1435: p_party_tbl => l_party_tbl,
1436: p_account_tbl => l_account_tbl,
1443: x_msg_count => x_msg_count,
1444: x_msg_data => x_msg_data
1445: );
1446:
1447: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1448: RAISE FND_API.G_EXC_ERROR;
1449: End If;
1450:
1451: COMMIT WORK;
1444: x_msg_data => x_msg_data
1445: );
1446:
1447: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1448: RAISE FND_API.G_EXC_ERROR;
1449: End If;
1450:
1451: COMMIT WORK;
1452:
1456: 'Exit - Change Item IB Owner');
1457: End if;
1458:
1459: EXCEPTION
1460: When FND_API.G_EXC_ERROR then
1461: Rollback To change_item_ib_owner;
1462: x_return_status := FND_API.G_RET_STS_ERROR ;
1463: FND_MSG_PUB.Count_And_Get
1464: (p_count => x_msg_count,
1458:
1459: EXCEPTION
1460: When FND_API.G_EXC_ERROR then
1461: Rollback To change_item_ib_owner;
1462: x_return_status := FND_API.G_RET_STS_ERROR ;
1463: FND_MSG_PUB.Count_And_Get
1464: (p_count => x_msg_count,
1465: p_data => x_msg_data );
1466:
1463: FND_MSG_PUB.Count_And_Get
1464: (p_count => x_msg_count,
1465: p_data => x_msg_data );
1466:
1467: When FND_API.G_EXC_UNEXPECTED_ERROR then
1468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1469: ROLLBACK TO change_item_ib_owner;
1470: FND_MSG_PUB.Count_And_Get
1471: ( p_count => x_msg_count,
1464: (p_count => x_msg_count,
1465: p_data => x_msg_data );
1466:
1467: When FND_API.G_EXC_UNEXPECTED_ERROR then
1468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1469: ROLLBACK TO change_item_ib_owner;
1470: FND_MSG_PUB.Count_And_Get
1471: ( p_count => x_msg_count,
1472: p_data => x_msg_data );
1471: ( p_count => x_msg_count,
1472: p_data => x_msg_data );
1473:
1474: When OTHERS then
1475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1476: Rollback To change_item_ib_owner;
1477: If FND_MSG_PUB.Check_Msg_Level
1478: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
1479: FND_MSG_PUB.Add_Exc_Msg
1591: lc_api_name);
1592:
1593: -- profile option for server_timezone_id must be set
1594: l_server_timezone_id := fnd_profile.value('SERVER_TIMEZONE_ID');
1595: IF (NVL(l_server_timezone_id,Fnd_Api.G_MISS_NUM) = Fnd_Api.G_MISS_NUM) THEN
1596: Fnd_Message.SET_NAME('CSD','CSD_CANNOT_GET_PROFILE_VALUE');
1597: Fnd_Message.SET_TOKEN('PROFILE',get_user_profile_option_name('SERVER_TIMEZONE_ID'));
1598: Fnd_Msg_Pub.ADD;
1599: RAISE Fnd_Api.G_EXC_ERROR;
1595: IF (NVL(l_server_timezone_id,Fnd_Api.G_MISS_NUM) = Fnd_Api.G_MISS_NUM) THEN
1596: Fnd_Message.SET_NAME('CSD','CSD_CANNOT_GET_PROFILE_VALUE');
1597: Fnd_Message.SET_TOKEN('PROFILE',get_user_profile_option_name('SERVER_TIMEZONE_ID'));
1598: Fnd_Msg_Pub.ADD;
1599: RAISE Fnd_Api.G_EXC_ERROR;
1600: END IF;
1601:
1602: l_inp_rec.contract_line_id := p_contract_line_id ;
1603: l_inp_rec.business_process_id := p_bus_proc_id ;
1609: l_inp_rec.dates_in_input_tz := 'N' ;
1610:
1611: oks_entitlements_pub.get_react_resolve_by_time(
1612: p_api_version => 1.0,
1613: p_init_msg_list => FND_API.G_TRUE,
1614: p_inp_rec => l_inp_rec,
1615: x_return_status => x_return_status,
1616: x_msg_count => x_msg_count,
1617: x_msg_data => x_msg_data,
1617: x_msg_data => x_msg_data,
1618: x_react_rec => l_react_rec,
1619: x_resolve_rec => l_resolve_rec);
1620:
1621: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
1622: RAISE Fnd_Api.G_EXC_ERROR ;
1623: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
1624: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
1625: END IF;
1618: x_react_rec => l_react_rec,
1619: x_resolve_rec => l_resolve_rec);
1620:
1621: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
1622: RAISE Fnd_Api.G_EXC_ERROR ;
1623: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
1624: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
1625: END IF;
1626:
1619: x_resolve_rec => l_resolve_rec);
1620:
1621: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
1622: RAISE Fnd_Api.G_EXC_ERROR ;
1623: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
1624: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
1625: END IF;
1626:
1627: x_resolve_by_date := l_resolve_rec.by_date_end;
1620:
1621: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
1622: RAISE Fnd_Api.G_EXC_ERROR ;
1623: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
1624: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
1625: END IF;
1626:
1627: x_resolve_by_date := l_resolve_rec.by_date_end;
1628:
1626:
1627: x_resolve_by_date := l_resolve_rec.by_date_end;
1628:
1629: EXCEPTION
1630: When FND_API.G_EXC_ERROR then
1631: Rollback To get_contract_resolve_by_date;
1632: x_return_status := FND_API.G_RET_STS_ERROR ;
1633: FND_MSG_PUB.Count_And_Get
1634: (p_count => x_msg_count,
1628:
1629: EXCEPTION
1630: When FND_API.G_EXC_ERROR then
1631: Rollback To get_contract_resolve_by_date;
1632: x_return_status := FND_API.G_RET_STS_ERROR ;
1633: FND_MSG_PUB.Count_And_Get
1634: (p_count => x_msg_count,
1635: p_data => x_msg_data );
1636:
1633: FND_MSG_PUB.Count_And_Get
1634: (p_count => x_msg_count,
1635: p_data => x_msg_data );
1636:
1637: When FND_API.G_EXC_UNEXPECTED_ERROR then
1638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1639: ROLLBACK TO get_contract_resolve_by_date;
1640: FND_MSG_PUB.Count_And_Get
1641: ( p_count => x_msg_count,
1634: (p_count => x_msg_count,
1635: p_data => x_msg_data );
1636:
1637: When FND_API.G_EXC_UNEXPECTED_ERROR then
1638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1639: ROLLBACK TO get_contract_resolve_by_date;
1640: FND_MSG_PUB.Count_And_Get
1641: ( p_count => x_msg_count,
1642: p_data => x_msg_data );
1641: ( p_count => x_msg_count,
1642: p_data => x_msg_data );
1643:
1644: When OTHERS then
1645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1646: Rollback To get_contract_resolve_by_date;
1647: If FND_MSG_PUB.Check_Msg_Level
1648: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
1649: FND_MSG_PUB.Add_Exc_Msg
1707: -- Parameters:
1708: -- p_event : Specify the event that is calling this program. Based on the event, the program logic might change.
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:
1708: -- p_event : Specify the event that is calling this program. Based on the event, the program logic might change.
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(
1740:
1741: begin
1742:
1743: -- standard API compatibility check.
1744: IF NOT Fnd_Api.Compatible_API_Call
1745: (lc_api_version_number,
1746: p_api_version,
1747: lc_api_name,
1748: G_PKG_NAME)
1746: p_api_version,
1747: lc_api_name,
1748: G_PKG_NAME)
1749: THEN
1750: RAISE Fnd_Api.G_EXC_ERROR;
1751: END IF;
1752:
1753: IF fnd_api.to_boolean(p_init_msg_list)
1754: THEN
1749: THEN
1750: RAISE Fnd_Api.G_EXC_ERROR;
1751: END IF;
1752:
1753: IF fnd_api.to_boolean(p_init_msg_list)
1754: THEN
1755: -- initialize message list
1756: fnd_msg_pub.initialize;
1757: END IF;
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;
1765: -- check if the profile to enable the auto update of RO status is set to yes.
1766:
1767: if p_event = 'RECEIVE' then
1768: -- check if all the RMA -- CUST_PROD and RMA-EXCHANGE combination is received.
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.
1779: null;
1780: else
1781: return; -- return to the caller.
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.
1812: null;
1813: else
1814: return; -- exit the procedure. With the success status.
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;
1843: else
1844: return;
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,
1854: p_init_msg_list => fnd_api.g_false,
1855: p_validation_level => fnd_api.g_valid_level_full,
1856: x_return_status => x_return_status,
1857: x_msg_count => x_msg_count,
1850: end if;
1851:
1852: csd_repairs_pvt.update_flow_status(p_api_version => 1,
1853: p_commit => fnd_api.g_false,
1854: p_init_msg_list => fnd_api.g_false,
1855: p_validation_level => fnd_api.g_valid_level_full,
1856: x_return_status => x_return_status,
1857: x_msg_count => x_msg_count,
1858: x_msg_data => x_msg_data,
1851:
1852: csd_repairs_pvt.update_flow_status(p_api_version => 1,
1853: p_commit => fnd_api.g_false,
1854: p_init_msg_list => fnd_api.g_false,
1855: p_validation_level => fnd_api.g_valid_level_full,
1856: x_return_status => x_return_status,
1857: x_msg_count => x_msg_count,
1858: x_msg_data => x_msg_data,
1859: p_repair_line_id => p_repair_line_id,
1864: p_comments => p_comments,
1865: p_check_access_flag => 'Y',
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;
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
1875: -- to do: set a message and raise an error;
1876: null;
1877: else
1878: -- set the return to status to success.
1875: -- to do: set a message and raise an error;
1876: null;
1877: else
1878: -- set the return to status to success.
1879: x_return_status := fnd_api.g_ret_sts_success;
1880: return;
1881: end if;
1882: end if;
1883:
1883:
1884: end if; -- l_all_lines_rcvd
1885: end if; -- p_event = 'RECEIVE'
1886:
1887: if p_commit = fnd_api.g_true then
1888: commit;
1889: end if;
1890:
1891: exception
1888: commit;
1889: end if;
1890:
1891: exception
1892: when fnd_api.g_exc_error then
1893: -- raising a error may not be a good idea, as it can potentially roll back
1894: -- entire transaction. For now, we can prefer to do nothing.
1895: x_return_status := fnd_api.g_ret_sts_success;
1896: null;
1891: exception
1892: when fnd_api.g_exc_error then
1893: -- raising a error may not be a good idea, as it can potentially roll back
1894: -- entire transaction. For now, we can prefer to do nothing.
1895: x_return_status := fnd_api.g_ret_sts_success;
1896: null;
1897: end auto_update_ro_status;
1898: -- end bug#7497790, 12.1 FP, subhat.
1899:
1970: lc_api_name varchar2(60) := 'default_ro_attrs_from_rule';
1971:
1972: BEGIN
1973: -- standard API compatibility check.
1974: if NOT FND_API.Compatible_API_Call
1975: (lc_api_version_number,
1976: p_api_version,
1977: lc_api_name,
1978: G_PKG_NAME)
1976: p_api_version,
1977: lc_api_name,
1978: G_PKG_NAME)
1979: then
1980: RAISE Fnd_Api.G_EXC_ERROR;
1981: end if;
1982:
1983: if FND_API.to_boolean(p_init_msg_list) then
1984: -- initialize message list
1979: then
1980: RAISE Fnd_Api.G_EXC_ERROR;
1981: end if;
1982:
1983: if FND_API.to_boolean(p_init_msg_list) then
1984: -- initialize message list
1985: fnd_msg_pub.initialize;
1986: end if;
1987:
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;
1994:
1995: -- Assume SR Incident Id is available to get info for defaulting RO attributes
1996: open c_get_sr_info(px_repln_rec.incident_id);
1997: fetch c_get_sr_info into
2008:
2009: l_rule_input_rec.RO_ITEM_ID := px_repln_rec.INVENTORY_ITEM_ID;
2010:
2011: /****************************** DEFAULT INVENTORY ORG ******************************/
2012: if (px_repln_rec.inventory_org_id = FND_API.G_MISS_NUM) then
2013: l_attr_type := 'CSD_DEF_ENTITY_ATTR_RO';
2014: l_attr_code := 'INV_ORG';
2015: l_default_val_num := null;
2016: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2014: l_attr_code := 'INV_ORG';
2015: l_default_val_num := null;
2016: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2017: p_api_version_number => 1.0,
2018: p_init_msg_list => fnd_api.g_false,
2019: p_commit => fnd_api.g_false,
2020: p_validation_level => fnd_api.g_valid_level_full,
2021: p_entity_attribute_type => l_attr_type,
2022: p_entity_attribute_code => l_attr_code,
2015: l_default_val_num := null;
2016: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2017: p_api_version_number => 1.0,
2018: p_init_msg_list => fnd_api.g_false,
2019: p_commit => fnd_api.g_false,
2020: p_validation_level => fnd_api.g_valid_level_full,
2021: p_entity_attribute_type => l_attr_type,
2022: p_entity_attribute_code => l_attr_code,
2023: p_rule_input_rec => l_rule_input_rec,
2016: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2017: p_api_version_number => 1.0,
2018: p_init_msg_list => fnd_api.g_false,
2019: p_commit => fnd_api.g_false,
2020: p_validation_level => fnd_api.g_valid_level_full,
2021: p_entity_attribute_type => l_attr_type,
2022: p_entity_attribute_code => l_attr_code,
2023: p_rule_input_rec => l_rule_input_rec,
2024: x_default_value => l_default_val_num,
2027: x_msg_count => x_msg_count,
2028: x_msg_data => x_msg_data
2029: );
2030:
2031: if (x_return_status = fnd_api.g_ret_sts_success) then
2032: if (l_default_val_num is not null) then
2033: l_inv_org := l_default_val_num;
2034: else
2035: l_inv_org := to_number(fnd_profile.value('CSD_DEF_REP_INV_ORG'));
2034: else
2035: l_inv_org := to_number(fnd_profile.value('CSD_DEF_REP_INV_ORG'));
2036: end if;
2037: else
2038: RAISE FND_API.G_EXC_ERROR;
2039: end if;
2040:
2041: if l_inv_org is not null then
2042: px_repln_rec.inventory_org_id := l_inv_org;
2043: end if;
2044: end if;
2045:
2046: /****************************** DEFAULT REPAIR ORG ******************************/
2047: if (px_repln_rec.resource_group = FND_API.G_MISS_NUM) then
2048: l_attr_type := 'CSD_DEF_ENTITY_ATTR_RO';
2049: l_attr_code := 'REPAIR_ORG';
2050: l_default_val_num := null;
2051: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2049: l_attr_code := 'REPAIR_ORG';
2050: l_default_val_num := null;
2051: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2052: p_api_version_number => 1.0,
2053: p_init_msg_list => fnd_api.g_false,
2054: p_commit => fnd_api.g_false,
2055: p_validation_level => fnd_api.g_valid_level_full,
2056: p_entity_attribute_type => l_attr_type,
2057: p_entity_attribute_code => l_attr_code,
2050: l_default_val_num := null;
2051: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2052: p_api_version_number => 1.0,
2053: p_init_msg_list => fnd_api.g_false,
2054: p_commit => fnd_api.g_false,
2055: p_validation_level => fnd_api.g_valid_level_full,
2056: p_entity_attribute_type => l_attr_type,
2057: p_entity_attribute_code => l_attr_code,
2058: p_rule_input_rec => l_rule_input_rec,
2051: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2052: p_api_version_number => 1.0,
2053: p_init_msg_list => fnd_api.g_false,
2054: p_commit => fnd_api.g_false,
2055: p_validation_level => fnd_api.g_valid_level_full,
2056: p_entity_attribute_type => l_attr_type,
2057: p_entity_attribute_code => l_attr_code,
2058: p_rule_input_rec => l_rule_input_rec,
2059: x_default_value => l_default_val_num,
2061: x_return_status => x_return_status,
2062: x_msg_count => x_msg_count,
2063: x_msg_data => x_msg_data
2064: );
2065: if (x_return_status = fnd_api.g_ret_sts_success) then
2066: if (l_default_val_num is not null) then
2067: l_repair_org := l_default_val_num;
2068: else
2069: l_repair_org := to_number(fnd_profile.value('CSD_DEFAULT_REPAIR_ORG'));
2068: else
2069: l_repair_org := to_number(fnd_profile.value('CSD_DEFAULT_REPAIR_ORG'));
2070: end if;
2071: else
2072: RAISE FND_API.G_EXC_ERROR;
2073: end if;
2074:
2075: if l_repair_org is not null then
2076: px_repln_rec.resource_group := l_repair_org;
2077: end if;
2078: end if;
2079:
2080: /****************************** DEFAULT REPAIR OWNER ******************************/
2081: if (px_repln_rec.resource_id = FND_API.G_MISS_NUM) then
2082: l_attr_type := 'CSD_DEF_ENTITY_ATTR_RO';
2083: l_attr_code := 'REPAIR_OWNER';
2084: l_default_val_num := null;
2085: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2083: l_attr_code := 'REPAIR_OWNER';
2084: l_default_val_num := null;
2085: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2086: p_api_version_number => 1.0,
2087: p_init_msg_list => fnd_api.g_false,
2088: p_commit => fnd_api.g_false,
2089: p_validation_level => fnd_api.g_valid_level_full,
2090: p_entity_attribute_type => l_attr_type,
2091: p_entity_attribute_code => l_attr_code,
2084: l_default_val_num := null;
2085: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2086: p_api_version_number => 1.0,
2087: p_init_msg_list => fnd_api.g_false,
2088: p_commit => fnd_api.g_false,
2089: p_validation_level => fnd_api.g_valid_level_full,
2090: p_entity_attribute_type => l_attr_type,
2091: p_entity_attribute_code => l_attr_code,
2092: p_rule_input_rec => l_rule_input_rec,
2085: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2086: p_api_version_number => 1.0,
2087: p_init_msg_list => fnd_api.g_false,
2088: p_commit => fnd_api.g_false,
2089: p_validation_level => fnd_api.g_valid_level_full,
2090: p_entity_attribute_type => l_attr_type,
2091: p_entity_attribute_code => l_attr_code,
2092: p_rule_input_rec => l_rule_input_rec,
2093: x_default_value => l_default_val_num,
2095: x_return_status => x_return_status,
2096: x_msg_count => x_msg_count,
2097: x_msg_data => x_msg_data
2098: );
2099: if (x_return_status = fnd_api.g_ret_sts_success) then
2100: if (l_default_val_num is not null) then
2101: px_repln_rec.resource_id := l_default_val_num;
2102: end if;
2103: else
2100: if (l_default_val_num is not null) then
2101: px_repln_rec.resource_id := l_default_val_num;
2102: end if;
2103: else
2104: RAISE FND_API.G_EXC_ERROR;
2105: end if;
2106: end if;
2107:
2108: /****************************** DEFAULT REPAIR PRIORITY ******************************/
2105: end if;
2106: end if;
2107:
2108: /****************************** DEFAULT REPAIR PRIORITY ******************************/
2109: if (px_repln_rec.ro_priority_code = FND_API.G_MISS_CHAR) then
2110: l_attr_type := 'CSD_DEF_ENTITY_ATTR_RO';
2111: l_attr_code := 'REPAIR_PRIORITY';
2112: l_default_val_num := null;
2113: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2111: l_attr_code := 'REPAIR_PRIORITY';
2112: l_default_val_num := null;
2113: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2114: p_api_version_number => 1.0,
2115: p_init_msg_list => fnd_api.g_false,
2116: p_commit => fnd_api.g_false,
2117: p_validation_level => fnd_api.g_valid_level_full,
2118: p_entity_attribute_type => l_attr_type,
2119: p_entity_attribute_code => l_attr_code,
2112: l_default_val_num := null;
2113: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2114: p_api_version_number => 1.0,
2115: p_init_msg_list => fnd_api.g_false,
2116: p_commit => fnd_api.g_false,
2117: p_validation_level => fnd_api.g_valid_level_full,
2118: p_entity_attribute_type => l_attr_type,
2119: p_entity_attribute_code => l_attr_code,
2120: p_rule_input_rec => l_rule_input_rec,
2113: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2114: p_api_version_number => 1.0,
2115: p_init_msg_list => fnd_api.g_false,
2116: p_commit => fnd_api.g_false,
2117: p_validation_level => fnd_api.g_valid_level_full,
2118: p_entity_attribute_type => l_attr_type,
2119: p_entity_attribute_code => l_attr_code,
2120: p_rule_input_rec => l_rule_input_rec,
2121: x_default_value => l_default_val_str,
2123: x_return_status => x_return_status,
2124: x_msg_count => x_msg_count,
2125: x_msg_data => x_msg_data
2126: );
2127: if (x_return_status = fnd_api.g_ret_sts_success) then
2128: if (l_default_val_str is not null) then
2129: px_repln_rec.ro_priority_code := l_default_val_str;
2130: end if;
2131: else
2128: if (l_default_val_str is not null) then
2129: px_repln_rec.ro_priority_code := l_default_val_str;
2130: end if;
2131: else
2132: RAISE FND_API.G_EXC_ERROR;
2133: end if;
2134: end if;
2135:
2136: /****************************** DEFAULT REPAIR TYPE ******************************/
2133: end if;
2134: end if;
2135:
2136: /****************************** DEFAULT REPAIR TYPE ******************************/
2137: if (px_repln_rec.repair_type_id = FND_API.G_MISS_NUM) then
2138: l_attr_type := 'CSD_DEF_ENTITY_ATTR_RO';
2139: l_attr_code := 'REPAIR_TYPE';
2140: l_default_val_num := null;
2141: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2139: l_attr_code := 'REPAIR_TYPE';
2140: l_default_val_num := null;
2141: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2142: p_api_version_number => 1.0,
2143: p_init_msg_list => fnd_api.g_false,
2144: p_commit => fnd_api.g_false,
2145: p_validation_level => fnd_api.g_valid_level_full,
2146: p_entity_attribute_type => l_attr_type,
2147: p_entity_attribute_code => l_attr_code,
2140: l_default_val_num := null;
2141: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2142: p_api_version_number => 1.0,
2143: p_init_msg_list => fnd_api.g_false,
2144: p_commit => fnd_api.g_false,
2145: p_validation_level => fnd_api.g_valid_level_full,
2146: p_entity_attribute_type => l_attr_type,
2147: p_entity_attribute_code => l_attr_code,
2148: p_rule_input_rec => l_rule_input_rec,
2141: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2142: p_api_version_number => 1.0,
2143: p_init_msg_list => fnd_api.g_false,
2144: p_commit => fnd_api.g_false,
2145: p_validation_level => fnd_api.g_valid_level_full,
2146: p_entity_attribute_type => l_attr_type,
2147: p_entity_attribute_code => l_attr_code,
2148: p_rule_input_rec => l_rule_input_rec,
2149: x_default_value => l_default_val_num,
2152: x_msg_count => x_msg_count,
2153: x_msg_data => x_msg_data
2154: );
2155:
2156: if (x_return_status = fnd_api.g_ret_sts_success) then
2157: if (l_default_val_num is not null) then
2158: l_repair_type_id := l_default_val_num;
2159: else
2160: l_repair_type_id := to_number(fnd_profile.value('CSD_DEFAULT_REPAIR_TYPE'));
2172: px_repln_rec.repair_mode := l_repair_mode;
2173:
2174: -- allow user to override auto process default, so only default
2175: -- if no value specified.
2176: if (px_repln_rec.auto_process_rma = FND_API.G_MISS_NUM) then
2177: px_repln_rec.auto_process_rma := l_auto_process_rma;
2178: end if;
2179: end if;
2180: else
2177: px_repln_rec.auto_process_rma := l_auto_process_rma;
2178: end if;
2179: end if;
2180: else
2181: RAISE FND_API.G_EXC_ERROR;
2182: end if;
2183: end if;
2184:
2185: if p_commit = fnd_api.g_true then
2181: RAISE FND_API.G_EXC_ERROR;
2182: end if;
2183: end if;
2184:
2185: if p_commit = fnd_api.g_true then
2186: commit;
2187: end if;
2188:
2189: EXCEPTION
2186: commit;
2187: end if;
2188:
2189: EXCEPTION
2190: When FND_API.G_EXC_ERROR then
2191: x_return_status := FND_API.G_RET_STS_ERROR ;
2192: FND_MSG_PUB.Count_And_Get
2193: (p_count => x_msg_count,
2194: p_data => x_msg_data );
2187: end if;
2188:
2189: EXCEPTION
2190: When FND_API.G_EXC_ERROR then
2191: x_return_status := FND_API.G_RET_STS_ERROR ;
2192: FND_MSG_PUB.Count_And_Get
2193: (p_count => x_msg_count,
2194: p_data => x_msg_data );
2195:
2192: FND_MSG_PUB.Count_And_Get
2193: (p_count => x_msg_count,
2194: p_data => x_msg_data );
2195:
2196: When FND_API.G_EXC_UNEXPECTED_ERROR then
2197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2198: FND_MSG_PUB.Count_And_Get
2199: ( p_count => x_msg_count,
2200: p_data => x_msg_data );
2193: (p_count => x_msg_count,
2194: p_data => x_msg_data );
2195:
2196: When FND_API.G_EXC_UNEXPECTED_ERROR then
2197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2198: FND_MSG_PUB.Count_And_Get
2199: ( p_count => x_msg_count,
2200: p_data => x_msg_data );
2201:
2199: ( p_count => x_msg_count,
2200: p_data => x_msg_data );
2201:
2202: When OTHERS then
2203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2204: If FND_MSG_PUB.Check_Msg_Level
2205: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
2206: FND_MSG_PUB.Add_Exc_Msg
2207: (G_PKG_NAME,