[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: p_RO_WARRANTY_STATUS_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
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: p_RO_WARRANTY_STATUS_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
342: x_Repln_Rec OUT NOCOPY Csd_Repairs_Pub.Repln_Rec_Type
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: p_RO_WARRANTY_STATUS_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
342: x_Repln_Rec OUT NOCOPY Csd_Repairs_Pub.Repln_Rec_Type
343: ) IS
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: p_RO_WARRANTY_STATUS_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
342: x_Repln_Rec OUT NOCOPY Csd_Repairs_Pub.Repln_Rec_Type
343: ) IS
344: --
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: p_RO_WARRANTY_STATUS_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
342: x_Repln_Rec OUT NOCOPY Csd_Repairs_Pub.Repln_Rec_Type
343: ) IS
344: --
345: BEGIN
431: END Convert_to_Repln_Rec_Type;
432:
433: PROCEDURE Convert_to_DEF_Rec_Type
434: (
435: p_attribute_category IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
436: p_attribute1 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
437: p_attribute2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
438: p_attribute3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
439: p_attribute4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
432:
433: PROCEDURE Convert_to_DEF_Rec_Type
434: (
435: p_attribute_category IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
436: p_attribute1 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
437: p_attribute2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
438: p_attribute3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
439: p_attribute4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
440: p_attribute5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
433: PROCEDURE Convert_to_DEF_Rec_Type
434: (
435: p_attribute_category IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
436: p_attribute1 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
437: p_attribute2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
438: p_attribute3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
439: p_attribute4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
440: p_attribute5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
441: p_attribute6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
434: (
435: p_attribute_category IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
436: p_attribute1 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
437: p_attribute2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
438: p_attribute3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
439: p_attribute4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
440: p_attribute5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
441: p_attribute6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
442: p_attribute7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
435: p_attribute_category IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
436: p_attribute1 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
437: p_attribute2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
438: p_attribute3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
439: p_attribute4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
440: p_attribute5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
441: p_attribute6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
442: p_attribute7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
443: p_attribute8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
436: p_attribute1 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
437: p_attribute2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
438: p_attribute3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
439: p_attribute4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
440: p_attribute5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
441: p_attribute6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
442: p_attribute7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
443: p_attribute8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
444: p_attribute9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
437: p_attribute2 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
438: p_attribute3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
439: p_attribute4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
440: p_attribute5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
441: p_attribute6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
442: p_attribute7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
443: p_attribute8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
444: p_attribute9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
445: p_attribute10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
438: p_attribute3 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
439: p_attribute4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
440: p_attribute5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
441: p_attribute6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
442: p_attribute7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
443: p_attribute8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
444: p_attribute9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
445: p_attribute10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
446: p_attribute11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
439: p_attribute4 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
440: p_attribute5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
441: p_attribute6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
442: p_attribute7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
443: p_attribute8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
444: p_attribute9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
445: p_attribute10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
446: p_attribute11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
447: p_attribute12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
440: p_attribute5 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
441: p_attribute6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
442: p_attribute7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
443: p_attribute8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
444: p_attribute9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
445: p_attribute10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
446: p_attribute11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
447: p_attribute12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
448: p_attribute13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
441: p_attribute6 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
442: p_attribute7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
443: p_attribute8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
444: p_attribute9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
445: p_attribute10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
446: p_attribute11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
447: p_attribute12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
448: p_attribute13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
449: p_attribute14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
442: p_attribute7 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
443: p_attribute8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
444: p_attribute9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
445: p_attribute10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
446: p_attribute11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
447: p_attribute12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
448: p_attribute13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
449: p_attribute14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
450: p_attribute15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
443: p_attribute8 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
444: p_attribute9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
445: p_attribute10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
446: p_attribute11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
447: p_attribute12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
448: p_attribute13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
449: p_attribute14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
450: p_attribute15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
451: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- subhat, dff changes(bug#7497907)
444: p_attribute9 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
445: p_attribute10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
446: p_attribute11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
447: p_attribute12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
448: p_attribute13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
449: p_attribute14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
450: p_attribute15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
451: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- subhat, dff changes(bug#7497907)
452: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_attribute10 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
446: p_attribute11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
447: p_attribute12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
448: p_attribute13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
449: p_attribute14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
450: p_attribute15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
451: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- subhat, dff changes(bug#7497907)
452: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_attribute11 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
447: p_attribute12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
448: p_attribute13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
449: p_attribute14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
450: p_attribute15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
451: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- subhat, dff changes(bug#7497907)
452: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_attribute12 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
448: p_attribute13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
449: p_attribute14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
450: p_attribute15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
451: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- subhat, dff changes(bug#7497907)
452: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_attribute13 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
449: p_attribute14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
450: p_attribute15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
451: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- subhat, dff changes(bug#7497907)
452: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
449: p_attribute14 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
450: p_attribute15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
451: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- subhat, dff changes(bug#7497907)
452: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_attribute15 IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
451: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- subhat, dff changes(bug#7497907)
452: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR, -- subhat, dff changes(bug#7497907)
452: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_attribute28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_attribute28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_attribute29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_attribute28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_attribute29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_attribute30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_attribute28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_attribute29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_attribute30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
466: x_DEF_Rec OUT NOCOPY Csd_Repairs_Util.DEF_Rec_Type
459: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_attribute28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_attribute29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_attribute30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
466: x_DEF_Rec OUT NOCOPY Csd_Repairs_Util.DEF_Rec_Type
467: ) IS
460: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_attribute28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_attribute29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_attribute30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
466: x_DEF_Rec OUT NOCOPY Csd_Repairs_Util.DEF_Rec_Type
467: ) IS
468: --
461: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_attribute28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_attribute29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_attribute30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
466: x_DEF_Rec OUT NOCOPY Csd_Repairs_Util.DEF_Rec_Type
467: ) IS
468: --
469: BEGIN
537: BEGIN
538: --
539: SAVEPOINT Get_Entitlements_Pvt;
540: -- Standard call to check for call compatibility.
541: IF NOT Fnd_Api.Compatible_API_Call
542: (l_api_version_number,
543: p_api_version_number,
544: l_api_name,
545: G_PKG_NAME)
543: p_api_version_number,
544: l_api_name,
545: G_PKG_NAME)
546: THEN
547: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
548: END IF;
549: -- Initialize message list if p_init_msg_list is set to TRUE.
550: IF Fnd_Api.to_Boolean(p_init_msg_list)
551: THEN
546: THEN
547: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
548: END IF;
549: -- Initialize message list if p_init_msg_list is set to TRUE.
550: IF Fnd_Api.to_Boolean(p_init_msg_list)
551: THEN
552: Fnd_Msg_Pub.initialize;
553: END IF;
554: -- Initialize API return status to success
551: THEN
552: Fnd_Msg_Pub.initialize;
553: END IF;
554: -- Initialize API return status to success
555: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
556: --
557: -- API body
558: --
559: l_input_param_rec.contract_number := p_contract_number;
585: x_msg_count => x_msg_count,
586: x_msg_data => x_msg_data,
587: x_ent_contracts => x_ent_contracts);
588: --
589: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
590: RAISE Fnd_Api.G_EXC_ERROR ;
591: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
592: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
593: END IF ;
586: x_msg_data => x_msg_data,
587: x_ent_contracts => x_ent_contracts);
588: --
589: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
590: RAISE Fnd_Api.G_EXC_ERROR ;
591: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
592: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
593: END IF ;
594: --
587: x_ent_contracts => x_ent_contracts);
588: --
589: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
590: RAISE Fnd_Api.G_EXC_ERROR ;
591: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
592: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
593: END IF ;
594: --
595: -- End of API body.
588: --
589: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
590: RAISE Fnd_Api.G_EXC_ERROR ;
591: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
592: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
593: END IF ;
594: --
595: -- End of API body.
596: --
594: --
595: -- End of API body.
596: --
597: -- Standard check for p_commit
598: IF Fnd_Api.to_Boolean(p_commit)
599: THEN
600: COMMIT WORK;
601: END IF;
602: -- Standard call to get message count and if count is 1, get message info.
605: p_data => x_msg_data
606: );
607: --
608: EXCEPTION
609: WHEN Fnd_Api.G_EXC_ERROR THEN
610: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
611: (P_API_NAME => L_API_NAME
612: ,P_PKG_NAME => G_PKG_NAME
613: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
616: ,X_MSG_DATA => X_MSG_DATA
617: ,X_RETURN_STATUS => X_RETURN_STATUS);
618: -- RAISE;
619: --
620: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
621: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
622: (P_API_NAME => L_API_NAME
623: ,P_PKG_NAME => G_PKG_NAME
624: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
768:
769: BEGIN
770:
771: -- Initialize local variables.
772: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
773: l_debug_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
774:
775: IF (Fnd_Log.LEVEL_PROCEDURE >= l_debug_level) THEN
776: Fnd_Log.STRING (Fnd_Log.LEVEL_PROCEDURE, 'csd.plsql.csd_repairs_util.check_task_n_wipjob.begin',
782: OPEN repair_details_cur ;
783: FETCH repair_details_cur INTO l_repair_mode;
784: IF(repair_details_cur%NOTFOUND) THEN
785: CLOSE repair_details_Cur;
786: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
787: END IF;
788: CLOSE repair_details_cur;
789:
790: /****
815: '-------------there are open jobs---------------');
816: END IF;
817: Fnd_Message.set_name('CSD', 'CSD_API_OPEN_WIP_JOBS');
818: Fnd_Msg_Pub.ADD;
819: RAISE Fnd_Api.G_EXC_ERROR ;
820: END IF;
821: CLOSE wipjob_cur;
822: ELSIF (l_repair_mode = C_TASK_MODE) THEN
823:
835: '-------------there are open tasks---------------');
836: END IF;
837: Fnd_Message.set_name('CSD', 'CSD_API_OPEN_TASKS');
838: Fnd_Msg_Pub.ADD;
839: RAISE Fnd_Api.G_EXC_ERROR ;
840: END IF;
841: CLOSE task_cur;
842: END IF;
843: END IF;
847: '-------------Leaving check_task_n_wipjob----------------');
848: END IF;
849:
850: EXCEPTION
851: WHEN Fnd_Api.G_EXC_ERROR THEN
852: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
853: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
854: IF ( Fnd_Log.LEVEL_ERROR >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
855: Fnd_Log.STRING(Fnd_Log.LEVEL_ERROR,
848: END IF;
849:
850: EXCEPTION
851: WHEN Fnd_Api.G_EXC_ERROR THEN
852: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
853: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
854: IF ( Fnd_Log.LEVEL_ERROR >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
855: Fnd_Log.STRING(Fnd_Log.LEVEL_ERROR,
856: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
856: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
857: 'EXC_ERROR ['||x_msg_data||']');
858: END IF;
859:
860: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
861: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
862: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );
863: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
864: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
857: 'EXC_ERROR ['||x_msg_data||']');
858: END IF;
859:
860: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
861: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
862: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );
863: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
864: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
865: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
866: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
867: END IF;
868:
869: WHEN OTHERS THEN
870: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
871: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
872: THEN
873: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME , l_api_name );
874: END IF;
924: BEGIN
925:
926:
927: -- Initialize local variables.
928: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
929: l_debug_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
930:
931: IF (Fnd_Log.LEVEL_PROCEDURE >= l_debug_level) THEN
932: Fnd_Log.STRING (Fnd_Log.LEVEL_PROCEDURE, 'csd.plsql.csd_repairs_util.Convert_Status_val_to_Id.begin',
942: IF (p_repair_status_rec.repair_number IS NULL) THEN
943: -- value based parameter is also NULL or MISSING
944: Fnd_Message.SET_NAME ('CSD', 'CSD_API_INV_REP_NUM');
945: Fnd_Msg_Pub.ADD;
946: x_return_status := Fnd_Api.G_RET_STS_ERROR;
947: ELSE
948: OPEN repair_id_conv_cur(p_repair_status_rec.repair_number);
949: FETCH repair_id_conv_cur INTO x_repair_status_rec.repair_line_id;
950: IF repair_id_conv_cur%NOTFOUND THEN
952: -- Conversion failed.
953: CLOSE repair_id_conv_cur;
954: Fnd_Message.SET_NAME ('CSD', 'CSD_API_INV_REP_NUM');
955: Fnd_Msg_Pub.ADD;
956: x_return_status := Fnd_Api.G_RET_STS_ERROR;
957: RAISE Fnd_Api.G_EXC_ERROR;
958: END IF;
959: CLOSE repair_id_conv_cur;
960: END IF;
953: CLOSE repair_id_conv_cur;
954: Fnd_Message.SET_NAME ('CSD', 'CSD_API_INV_REP_NUM');
955: Fnd_Msg_Pub.ADD;
956: x_return_status := Fnd_Api.G_RET_STS_ERROR;
957: RAISE Fnd_Api.G_EXC_ERROR;
958: END IF;
959: CLOSE repair_id_conv_cur;
960: END IF;
961: ELSIF p_repair_status_rec.repair_line_id IS NOT NULL THEN
975: IF (p_repair_status_rec.repair_status IS NULL) THEN
976: -- value based parameter is also NULL or MISSING
977: Fnd_Message.SET_NAME('CSD','CSD_INVALID_FLOW_STATUS');
978: Fnd_Msg_Pub.ADD;
979: x_return_status := Fnd_Api.G_RET_STS_ERROR;
980: ELSE
981: OPEN flow_stat_cur(p_repair_status_Rec.repair_status);
982: FETCH flow_stat_cur INTO x_repair_status_Rec.repair_status_id;
983: IF(flow_stat_cur%NOTFOUND) THEN
983: IF(flow_stat_cur%NOTFOUND) THEN
984: CLOSE flow_stat_cur;
985: Fnd_Message.SET_NAME('CSD','CSD_INVALID_FLOW_STATUS');
986: Fnd_Msg_Pub.ADD;
987: x_return_status := Fnd_Api.G_RET_STS_ERROR;
988: RAISE Fnd_Api.G_EXC_ERROR;
989: END IF;
990: CLOSE flow_stat_cur;
991: END IF;
984: CLOSE flow_stat_cur;
985: Fnd_Message.SET_NAME('CSD','CSD_INVALID_FLOW_STATUS');
986: Fnd_Msg_Pub.ADD;
987: x_return_status := Fnd_Api.G_RET_STS_ERROR;
988: RAISE Fnd_Api.G_EXC_ERROR;
989: END IF;
990: CLOSE flow_stat_cur;
991: END IF;
992: ELSIF p_repair_status_rec.repair_status_id IS NOT NULL THEN
1058: p_statement_type => 'EXISTS'
1059:
1060: *****************/
1061:
1062: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1063: /*!!!!!!!!!! Temporarily disabling the security
1064: return ;!!!!!*******/
1065:
1066: l_table_alias := 'ro';
1076: p_table_alias => l_table_alias );
1077:
1078:
1079: debug('getSecurity_predicate return value['||l_Return_status||']');
1080: debug('success['||FND_API.G_RET_STS_SUCCESS||']');
1081: debug('getSecurity_predicate predicate value['||l_predicate||']');
1082:
1083: IF(l_return_status <> FND_API.G_TRUE) THEN
1084: debug('returning l_return_status['||l_return_status||']');
1079: debug('getSecurity_predicate return value['||l_Return_status||']');
1080: debug('success['||FND_API.G_RET_STS_SUCCESS||']');
1081: debug('getSecurity_predicate predicate value['||l_predicate||']');
1082:
1083: IF(l_return_status <> FND_API.G_TRUE) THEN
1084: debug('returning l_return_status['||l_return_status||']');
1085: x_return_status := FND_API.G_RET_STS_ERROR;
1086: ELSE
1087: IF(l_predicate IS NOT NULL AND l_predicate <> '(1=1)') THEN
1081: debug('getSecurity_predicate predicate value['||l_predicate||']');
1082:
1083: IF(l_return_status <> FND_API.G_TRUE) THEN
1084: debug('returning l_return_status['||l_return_status||']');
1085: x_return_status := FND_API.G_RET_STS_ERROR;
1086: ELSE
1087: IF(l_predicate IS NOT NULL AND l_predicate <> '(1=1)') THEN
1088:
1089: debug('forming sql str');
1096: EXECUTE IMMEDIATE l_sql_str INTO l_tmp_Str
1097: USING p_repair_line_id ;
1098: EXCEPTION
1099: WHEN NO_DATA_FOUND THEN
1100: x_return_status := FND_API.G_RET_STS_ERROR;
1101: END;
1102: debug('l_tmp_Str after['||l_tmp_str||']');
1103: IF(l_tmp_str IS NULL ) THEN
1104: debug('returning failure because l_tmp_Str['||l_tmp_str||']');
1101: END;
1102: debug('l_tmp_Str after['||l_tmp_str||']');
1103: IF(l_tmp_str IS NULL ) THEN
1104: debug('returning failure because l_tmp_Str['||l_tmp_str||']');
1105: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1106: END IF;
1107:
1108: ELSE
1109: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1105: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1106: END IF;
1107:
1108: ELSE
1109: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1110: END IF;
1111: END IF;
1112:
1113: /************************
1146: USING TO_CHAR(p_repair_line_id),
1147: C_CUST_PROD_ACTION_CODE ,
1148: C_3RDPARTY_RMA_ACTION_TYPE ;
1149: IF(l_tmp_str IS NULL ) THEN
1150: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1151: END IF;
1152:
1153: END IF;
1154: ************************************************
1189: USING TO_CHAR(p_repair_line_id),
1190: C_CUST_PROD_ACTION_CODE ,
1191: C_3RDPARTY_SHIP_ACTION_TYPE ;
1192: IF(l_tmp_str IS NULL ) THEN
1193: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1194: END IF;
1195:
1196: END IF;
1197: ************************************************
1199:
1200: debug('returning success');
1201: EXCEPTION
1202: WHEN OTHERS THEN
1203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1204: debug('sqlca.sqlcode ['||sqlcode ||']');
1205: debug('sqlca.sqlerrm['||sqlerrm||']');
1206:
1207:
1327: 'Enter - Change Item IB Owner');
1328: end if;
1329:
1330: -- Initialize API return status to success
1331: x_return_status := FND_API.G_RET_STS_SUCCESS;
1332:
1333: -- create a TCA relationship between the current owner and
1334: -- new owner, if desired
1335: if(p_create_tca_relation = fnd_api.g_true) then
1331: x_return_status := FND_API.G_RET_STS_SUCCESS;
1332:
1333: -- create a TCA relationship between the current owner and
1334: -- new owner, if desired
1335: if(p_create_tca_relation = fnd_api.g_true) then
1336:
1337: -- get info for original owner
1338: Open c_hz_parties_info(p_current_owner_party_id);
1339: Fetch c_hz_parties_info
1353: csd_ib_chown_cuhk.get_tca_rel_info (
1354: p_in_param => l_tca_rel_in_params,
1355: x_out_param => l_tca_rel_out_params
1356: );
1357: if NOT(l_tca_rel_out_params.return_status = FND_API.G_RET_STS_SUCCESS) then
1358: RAISE FND_API.G_EXC_ERROR;
1359: end if;
1360:
1361: -- populate the relationship rec before calling API
1354: p_in_param => l_tca_rel_in_params,
1355: x_out_param => l_tca_rel_out_params
1356: );
1357: if NOT(l_tca_rel_out_params.return_status = FND_API.G_RET_STS_SUCCESS) then
1358: RAISE FND_API.G_EXC_ERROR;
1359: end if;
1360:
1361: -- populate the relationship rec before calling API
1362: -- Assumption: the owners will always be from hz_parties
1383: -- only create the TCA relationship if one does not exist already
1384: if (l_tca_rel_count = 0 ) then
1385: -- create the TCA relation
1386: hz_relationship_v2pub.create_relationship(
1387: p_init_msg_list => fnd_api.g_false,
1388: p_relationship_rec => l_relationship_rec,
1389: x_relationship_id => x_tca_relation_id,
1390: x_party_id => l_rel_party_id,
1391: x_party_number => l_rel_party_number,
1393: x_msg_count => x_msg_count,
1394: x_msg_data => x_msg_data,
1395: p_create_org_contact => 'Y'
1396: );
1397: if NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1398: RAISE FND_API.G_EXC_ERROR;
1399: end if;
1400: end if; -- l_tca_rel_count = 0
1401: End If; -- p_create_tca_relation = true
1394: x_msg_data => x_msg_data,
1395: p_create_org_contact => 'Y'
1396: );
1397: if NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1398: RAISE FND_API.G_EXC_ERROR;
1399: end if;
1400: end if; -- l_tca_rel_count = 0
1401: End If; -- p_create_tca_relation = true
1402:
1456: -- Call the Update item instance API
1457: csi_item_instance_pub.update_item_instance
1458: (
1459: p_api_version => 1.0,
1460: p_commit => fnd_api.g_false,
1461: p_init_msg_list => fnd_api.g_true,
1462: p_validation_level => fnd_api.g_valid_level_full,
1463: p_instance_rec => l_instance_rec,
1464: p_ext_attrib_values_tbl => l_ext_attrib_values_tbl,
1457: csi_item_instance_pub.update_item_instance
1458: (
1459: p_api_version => 1.0,
1460: p_commit => fnd_api.g_false,
1461: p_init_msg_list => fnd_api.g_true,
1462: p_validation_level => fnd_api.g_valid_level_full,
1463: p_instance_rec => l_instance_rec,
1464: p_ext_attrib_values_tbl => l_ext_attrib_values_tbl,
1465: p_party_tbl => l_party_tbl,
1458: (
1459: p_api_version => 1.0,
1460: p_commit => fnd_api.g_false,
1461: p_init_msg_list => fnd_api.g_true,
1462: p_validation_level => fnd_api.g_valid_level_full,
1463: p_instance_rec => l_instance_rec,
1464: p_ext_attrib_values_tbl => l_ext_attrib_values_tbl,
1465: p_party_tbl => l_party_tbl,
1466: p_account_tbl => l_account_tbl,
1473: x_msg_count => x_msg_count,
1474: x_msg_data => x_msg_data
1475: );
1476:
1477: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1478: RAISE FND_API.G_EXC_ERROR;
1479: End If;
1480:
1481: COMMIT WORK;
1474: x_msg_data => x_msg_data
1475: );
1476:
1477: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1478: RAISE FND_API.G_EXC_ERROR;
1479: End If;
1480:
1481: COMMIT WORK;
1482:
1486: 'Exit - Change Item IB Owner');
1487: End if;
1488:
1489: EXCEPTION
1490: When FND_API.G_EXC_ERROR then
1491: Rollback To change_item_ib_owner;
1492: x_return_status := FND_API.G_RET_STS_ERROR ;
1493: FND_MSG_PUB.Count_And_Get
1494: (p_count => x_msg_count,
1488:
1489: EXCEPTION
1490: When FND_API.G_EXC_ERROR then
1491: Rollback To change_item_ib_owner;
1492: x_return_status := FND_API.G_RET_STS_ERROR ;
1493: FND_MSG_PUB.Count_And_Get
1494: (p_count => x_msg_count,
1495: p_data => x_msg_data );
1496:
1493: FND_MSG_PUB.Count_And_Get
1494: (p_count => x_msg_count,
1495: p_data => x_msg_data );
1496:
1497: When FND_API.G_EXC_UNEXPECTED_ERROR then
1498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1499: ROLLBACK TO change_item_ib_owner;
1500: FND_MSG_PUB.Count_And_Get
1501: ( p_count => x_msg_count,
1494: (p_count => x_msg_count,
1495: p_data => x_msg_data );
1496:
1497: When FND_API.G_EXC_UNEXPECTED_ERROR then
1498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1499: ROLLBACK TO change_item_ib_owner;
1500: FND_MSG_PUB.Count_And_Get
1501: ( p_count => x_msg_count,
1502: p_data => x_msg_data );
1501: ( p_count => x_msg_count,
1502: p_data => x_msg_data );
1503:
1504: When OTHERS then
1505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1506: Rollback To change_item_ib_owner;
1507: If FND_MSG_PUB.Check_Msg_Level
1508: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
1509: FND_MSG_PUB.Add_Exc_Msg
1621: lc_api_name);
1622:
1623: -- profile option for server_timezone_id must be set
1624: l_server_timezone_id := fnd_profile.value('SERVER_TIMEZONE_ID');
1625: IF (NVL(l_server_timezone_id,Fnd_Api.G_MISS_NUM) = Fnd_Api.G_MISS_NUM) THEN
1626: Fnd_Message.SET_NAME('CSD','CSD_CANNOT_GET_PROFILE_VALUE');
1627: Fnd_Message.SET_TOKEN('PROFILE',get_user_profile_option_name('SERVER_TIMEZONE_ID'));
1628: Fnd_Msg_Pub.ADD;
1629: RAISE Fnd_Api.G_EXC_ERROR;
1625: IF (NVL(l_server_timezone_id,Fnd_Api.G_MISS_NUM) = Fnd_Api.G_MISS_NUM) THEN
1626: Fnd_Message.SET_NAME('CSD','CSD_CANNOT_GET_PROFILE_VALUE');
1627: Fnd_Message.SET_TOKEN('PROFILE',get_user_profile_option_name('SERVER_TIMEZONE_ID'));
1628: Fnd_Msg_Pub.ADD;
1629: RAISE Fnd_Api.G_EXC_ERROR;
1630: END IF;
1631:
1632: l_inp_rec.contract_line_id := p_contract_line_id ;
1633: l_inp_rec.business_process_id := p_bus_proc_id ;
1639: l_inp_rec.dates_in_input_tz := 'N' ;
1640:
1641: oks_entitlements_pub.get_react_resolve_by_time(
1642: p_api_version => 1.0,
1643: p_init_msg_list => FND_API.G_TRUE,
1644: p_inp_rec => l_inp_rec,
1645: x_return_status => x_return_status,
1646: x_msg_count => x_msg_count,
1647: x_msg_data => x_msg_data,
1647: x_msg_data => x_msg_data,
1648: x_react_rec => l_react_rec,
1649: x_resolve_rec => l_resolve_rec);
1650:
1651: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
1652: RAISE Fnd_Api.G_EXC_ERROR ;
1653: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
1654: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
1655: END IF;
1648: x_react_rec => l_react_rec,
1649: x_resolve_rec => l_resolve_rec);
1650:
1651: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
1652: RAISE Fnd_Api.G_EXC_ERROR ;
1653: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
1654: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
1655: END IF;
1656:
1649: x_resolve_rec => l_resolve_rec);
1650:
1651: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
1652: RAISE Fnd_Api.G_EXC_ERROR ;
1653: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
1654: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
1655: END IF;
1656:
1657: x_resolve_by_date := l_resolve_rec.by_date_end;
1650:
1651: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
1652: RAISE Fnd_Api.G_EXC_ERROR ;
1653: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
1654: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
1655: END IF;
1656:
1657: x_resolve_by_date := l_resolve_rec.by_date_end;
1658:
1656:
1657: x_resolve_by_date := l_resolve_rec.by_date_end;
1658:
1659: EXCEPTION
1660: When FND_API.G_EXC_ERROR then
1661: Rollback To get_contract_resolve_by_date;
1662: x_return_status := FND_API.G_RET_STS_ERROR ;
1663: FND_MSG_PUB.Count_And_Get
1664: (p_count => x_msg_count,
1658:
1659: EXCEPTION
1660: When FND_API.G_EXC_ERROR then
1661: Rollback To get_contract_resolve_by_date;
1662: x_return_status := FND_API.G_RET_STS_ERROR ;
1663: FND_MSG_PUB.Count_And_Get
1664: (p_count => x_msg_count,
1665: p_data => x_msg_data );
1666:
1663: FND_MSG_PUB.Count_And_Get
1664: (p_count => x_msg_count,
1665: p_data => x_msg_data );
1666:
1667: When FND_API.G_EXC_UNEXPECTED_ERROR then
1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1669: ROLLBACK TO get_contract_resolve_by_date;
1670: FND_MSG_PUB.Count_And_Get
1671: ( p_count => x_msg_count,
1664: (p_count => x_msg_count,
1665: p_data => x_msg_data );
1666:
1667: When FND_API.G_EXC_UNEXPECTED_ERROR then
1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1669: ROLLBACK TO get_contract_resolve_by_date;
1670: FND_MSG_PUB.Count_And_Get
1671: ( p_count => x_msg_count,
1672: p_data => x_msg_data );
1671: ( p_count => x_msg_count,
1672: p_data => x_msg_data );
1673:
1674: When OTHERS then
1675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1676: Rollback To get_contract_resolve_by_date;
1677: If FND_MSG_PUB.Check_Msg_Level
1678: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
1679: FND_MSG_PUB.Add_Exc_Msg
1737: -- Parameters:
1738: -- p_event : Specify the event that is calling this program. Based on the event, the program logic might change.
1739: -- p_reason_code: The reason code for the status change defaulted to null
1740: -- p_comments: The comments for the flow status, defaulted to null
1741: -- p_validation_level: validation level for the routine. Pass fnd_api.g_valid_level_full to get the messages from the API
1742: -- pass fnd_api.g_valid_level_none will ignore all error messages and return success always. The error messages
1743: -- will be logged in the fnd_log_messages if logging is enabled
1744: --*****************************************************
1745:
1738: -- p_event : Specify the event that is calling this program. Based on the event, the program logic might change.
1739: -- p_reason_code: The reason code for the status change defaulted to null
1740: -- p_comments: The comments for the flow status, defaulted to null
1741: -- p_validation_level: validation level for the routine. Pass fnd_api.g_valid_level_full to get the messages from the API
1742: -- pass fnd_api.g_valid_level_none will ignore all error messages and return success always. The error messages
1743: -- will be logged in the fnd_log_messages if logging is enabled
1744: --*****************************************************
1745:
1746: procedure auto_update_ro_status(
1770:
1771: begin
1772:
1773: -- standard API compatibility check.
1774: IF NOT Fnd_Api.Compatible_API_Call
1775: (lc_api_version_number,
1776: p_api_version,
1777: lc_api_name,
1778: G_PKG_NAME)
1776: p_api_version,
1777: lc_api_name,
1778: G_PKG_NAME)
1779: THEN
1780: RAISE Fnd_Api.G_EXC_ERROR;
1781: END IF;
1782:
1783: IF fnd_api.to_boolean(p_init_msg_list)
1784: THEN
1779: THEN
1780: RAISE Fnd_Api.G_EXC_ERROR;
1781: END IF;
1782:
1783: IF fnd_api.to_boolean(p_init_msg_list)
1784: THEN
1785: -- initialize message list
1786: fnd_msg_pub.initialize;
1787: END IF;
1790: fnd_log.string(lc_log_level,lc_mod_name,'Begin auto_update_ro_status');
1791: end if;
1792:
1793: -- set the return status
1794: x_return_status := fnd_api.g_ret_sts_success;
1795: -- check if the profile to enable the auto update of RO status is set to yes.
1796:
1797: if p_event = 'RECEIVE' then
1798: -- check if all the RMA -- CUST_PROD and RMA-EXCHANGE combination is received.
1803: if lc_log_level >= lc_procedure_level then
1804: fnd_log.string(lc_log_level,lc_mod_name,'Profile CSD: Enable Auto Update of Repair
1805: Order Status upon Receiving is not set to yes.');
1806: end if;
1807: if p_validation_level = fnd_api.g_valid_level_full then
1808: -- 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.
1809: null;
1810: else
1811: return; -- return to the caller.
1836: if lc_log_level >= lc_procedure_level then
1837: fnd_log.string(lc_log_level,lc_mod_name,'Profile CSD: Default Repair Order Status After
1838: Receving is not set');
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 for the caller API.
1842: null;
1843: else
1844: return; -- exit the procedure. With the success status.
1866: -- to and from are same. Do not update.
1867: if lc_log_level >= lc_procedure_level then
1868: fnd_log.string(lc_log_level,lc_mod_name,'the new status is same as the old status. Do not update the status');
1869: end if;
1870: if p_validation_level = fnd_api.g_valid_level_full then
1871: -- to do: set a message and raise an error.
1872: null;
1873: else
1874: return;
1879: fnd_log.string(lc_log_level,lc_mod_name,'calling csd_repairs_pvt.update_flow_status API');
1880: end if;
1881:
1882: csd_repairs_pvt.update_flow_status(p_api_version => 1,
1883: p_commit => fnd_api.g_false,
1884: p_init_msg_list => fnd_api.g_false,
1885: p_validation_level => fnd_api.g_valid_level_full,
1886: x_return_status => x_return_status,
1887: x_msg_count => x_msg_count,
1880: end if;
1881:
1882: csd_repairs_pvt.update_flow_status(p_api_version => 1,
1883: p_commit => fnd_api.g_false,
1884: p_init_msg_list => fnd_api.g_false,
1885: p_validation_level => fnd_api.g_valid_level_full,
1886: x_return_status => x_return_status,
1887: x_msg_count => x_msg_count,
1888: x_msg_data => x_msg_data,
1881:
1882: csd_repairs_pvt.update_flow_status(p_api_version => 1,
1883: p_commit => fnd_api.g_false,
1884: p_init_msg_list => fnd_api.g_false,
1885: p_validation_level => fnd_api.g_valid_level_full,
1886: x_return_status => x_return_status,
1887: x_msg_count => x_msg_count,
1888: x_msg_data => x_msg_data,
1889: p_repair_line_id => p_repair_line_id,
1894: p_comments => p_comments,
1895: p_check_access_flag => 'Y',
1896: p_object_version_number => l_object_version_number,
1897: x_object_version_number => x_object_version_number );
1898: if x_return_status <> fnd_api.g_ret_sts_success then
1899: if lc_log_level >= lc_procedure_level then
1900: fnd_log.string(lc_log_level,lc_mod_name,'Error in csd_repairs_pvt.update_flow_status
1901: ['||x_msg_data||']');
1902: end if;
1900: fnd_log.string(lc_log_level,lc_mod_name,'Error in csd_repairs_pvt.update_flow_status
1901: ['||x_msg_data||']');
1902: end if;
1903:
1904: if p_validation_level = fnd_api.g_valid_level_full then
1905: -- to do: set a message and raise an error;
1906: null;
1907: else
1908: -- set the return to status to success.
1905: -- to do: set a message and raise an error;
1906: null;
1907: else
1908: -- set the return to status to success.
1909: x_return_status := fnd_api.g_ret_sts_success;
1910: return;
1911: end if;
1912: end if;
1913:
1913:
1914: end if; -- l_all_lines_rcvd
1915: end if; -- p_event = 'RECEIVE'
1916:
1917: if p_commit = fnd_api.g_true then
1918: commit;
1919: end if;
1920:
1921: exception
1918: commit;
1919: end if;
1920:
1921: exception
1922: when fnd_api.g_exc_error then
1923: -- raising a error may not be a good idea, as it can potentially roll back
1924: -- entire transaction. For now, we can prefer to do nothing.
1925: x_return_status := fnd_api.g_ret_sts_success;
1926: null;
1921: exception
1922: when fnd_api.g_exc_error then
1923: -- raising a error may not be a good idea, as it can potentially roll back
1924: -- entire transaction. For now, we can prefer to do nothing.
1925: x_return_status := fnd_api.g_ret_sts_success;
1926: null;
1927: end auto_update_ro_status;
1928: -- end bug#7497790, 12.1 FP, subhat.
1929:
2000: lc_api_name varchar2(60) := 'default_ro_attrs_from_rule';
2001:
2002: BEGIN
2003: -- standard API compatibility check.
2004: if NOT FND_API.Compatible_API_Call
2005: (lc_api_version_number,
2006: p_api_version,
2007: lc_api_name,
2008: G_PKG_NAME)
2006: p_api_version,
2007: lc_api_name,
2008: G_PKG_NAME)
2009: then
2010: RAISE Fnd_Api.G_EXC_ERROR;
2011: end if;
2012:
2013: if FND_API.to_boolean(p_init_msg_list) then
2014: -- initialize message list
2009: then
2010: RAISE Fnd_Api.G_EXC_ERROR;
2011: end if;
2012:
2013: if FND_API.to_boolean(p_init_msg_list) then
2014: -- initialize message list
2015: fnd_msg_pub.initialize;
2016: end if;
2017:
2019: fnd_log.string(lc_log_level,lc_mod_name,'Begin default_ro_attrs_from_rule');
2020: end if;
2021:
2022: -- set the return status
2023: x_return_status := fnd_api.g_ret_sts_success;
2024:
2025: -- Assume SR Incident Id is available to get info for defaulting RO attributes
2026: open c_get_sr_info(px_repln_rec.incident_id);
2027: fetch c_get_sr_info into
2038:
2039: l_rule_input_rec.RO_ITEM_ID := px_repln_rec.INVENTORY_ITEM_ID;
2040:
2041: /****************************** DEFAULT INVENTORY ORG ******************************/
2042: if (px_repln_rec.inventory_org_id = FND_API.G_MISS_NUM) then
2043: l_attr_type := 'CSD_DEF_ENTITY_ATTR_RO';
2044: l_attr_code := 'INV_ORG';
2045: l_default_val_num := null;
2046: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2044: l_attr_code := 'INV_ORG';
2045: l_default_val_num := null;
2046: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2047: p_api_version_number => 1.0,
2048: p_init_msg_list => fnd_api.g_false,
2049: p_commit => fnd_api.g_false,
2050: p_validation_level => fnd_api.g_valid_level_full,
2051: p_entity_attribute_type => l_attr_type,
2052: p_entity_attribute_code => l_attr_code,
2045: l_default_val_num := null;
2046: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2047: p_api_version_number => 1.0,
2048: p_init_msg_list => fnd_api.g_false,
2049: p_commit => fnd_api.g_false,
2050: p_validation_level => fnd_api.g_valid_level_full,
2051: p_entity_attribute_type => l_attr_type,
2052: p_entity_attribute_code => l_attr_code,
2053: p_rule_input_rec => l_rule_input_rec,
2046: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2047: p_api_version_number => 1.0,
2048: p_init_msg_list => fnd_api.g_false,
2049: p_commit => fnd_api.g_false,
2050: p_validation_level => fnd_api.g_valid_level_full,
2051: p_entity_attribute_type => l_attr_type,
2052: p_entity_attribute_code => l_attr_code,
2053: p_rule_input_rec => l_rule_input_rec,
2054: x_default_value => l_default_val_num,
2057: x_msg_count => x_msg_count,
2058: x_msg_data => x_msg_data
2059: );
2060:
2061: if (x_return_status = fnd_api.g_ret_sts_success) then
2062: if (l_default_val_num is not null) then
2063: l_inv_org := l_default_val_num;
2064: else
2065: l_inv_org := to_number(fnd_profile.value('CSD_DEF_REP_INV_ORG'));
2064: else
2065: l_inv_org := to_number(fnd_profile.value('CSD_DEF_REP_INV_ORG'));
2066: end if;
2067: else
2068: RAISE FND_API.G_EXC_ERROR;
2069: end if;
2070:
2071: if l_inv_org is not null then
2072: px_repln_rec.inventory_org_id := l_inv_org;
2073: end if;
2074: end if;
2075:
2076: /****************************** DEFAULT REPAIR ORG ******************************/
2077: if (px_repln_rec.resource_group = FND_API.G_MISS_NUM) then
2078: l_attr_type := 'CSD_DEF_ENTITY_ATTR_RO';
2079: l_attr_code := 'REPAIR_ORG';
2080: l_default_val_num := null;
2081: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2079: l_attr_code := 'REPAIR_ORG';
2080: l_default_val_num := null;
2081: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2082: p_api_version_number => 1.0,
2083: p_init_msg_list => fnd_api.g_false,
2084: p_commit => fnd_api.g_false,
2085: p_validation_level => fnd_api.g_valid_level_full,
2086: p_entity_attribute_type => l_attr_type,
2087: p_entity_attribute_code => l_attr_code,
2080: l_default_val_num := null;
2081: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2082: p_api_version_number => 1.0,
2083: p_init_msg_list => fnd_api.g_false,
2084: p_commit => fnd_api.g_false,
2085: p_validation_level => fnd_api.g_valid_level_full,
2086: p_entity_attribute_type => l_attr_type,
2087: p_entity_attribute_code => l_attr_code,
2088: p_rule_input_rec => l_rule_input_rec,
2081: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2082: p_api_version_number => 1.0,
2083: p_init_msg_list => fnd_api.g_false,
2084: p_commit => fnd_api.g_false,
2085: p_validation_level => fnd_api.g_valid_level_full,
2086: p_entity_attribute_type => l_attr_type,
2087: p_entity_attribute_code => l_attr_code,
2088: p_rule_input_rec => l_rule_input_rec,
2089: x_default_value => l_default_val_num,
2091: x_return_status => x_return_status,
2092: x_msg_count => x_msg_count,
2093: x_msg_data => x_msg_data
2094: );
2095: if (x_return_status = fnd_api.g_ret_sts_success) then
2096: if (l_default_val_num is not null) then
2097: l_repair_org := l_default_val_num;
2098: else
2099: l_repair_org := to_number(fnd_profile.value('CSD_DEFAULT_REPAIR_ORG'));
2098: else
2099: l_repair_org := to_number(fnd_profile.value('CSD_DEFAULT_REPAIR_ORG'));
2100: end if;
2101: else
2102: RAISE FND_API.G_EXC_ERROR;
2103: end if;
2104:
2105: if l_repair_org is not null then
2106: px_repln_rec.resource_group := l_repair_org;
2107: end if;
2108: end if;
2109:
2110: /****************************** DEFAULT REPAIR OWNER ******************************/
2111: if (px_repln_rec.resource_id = FND_API.G_MISS_NUM) then
2112: l_attr_type := 'CSD_DEF_ENTITY_ATTR_RO';
2113: l_attr_code := 'REPAIR_OWNER';
2114: l_default_val_num := null;
2115: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2113: l_attr_code := 'REPAIR_OWNER';
2114: l_default_val_num := null;
2115: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2116: p_api_version_number => 1.0,
2117: p_init_msg_list => fnd_api.g_false,
2118: p_commit => fnd_api.g_false,
2119: p_validation_level => fnd_api.g_valid_level_full,
2120: p_entity_attribute_type => l_attr_type,
2121: p_entity_attribute_code => l_attr_code,
2114: l_default_val_num := null;
2115: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2116: p_api_version_number => 1.0,
2117: p_init_msg_list => fnd_api.g_false,
2118: p_commit => fnd_api.g_false,
2119: p_validation_level => fnd_api.g_valid_level_full,
2120: p_entity_attribute_type => l_attr_type,
2121: p_entity_attribute_code => l_attr_code,
2122: p_rule_input_rec => l_rule_input_rec,
2115: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2116: p_api_version_number => 1.0,
2117: p_init_msg_list => fnd_api.g_false,
2118: p_commit => fnd_api.g_false,
2119: p_validation_level => fnd_api.g_valid_level_full,
2120: p_entity_attribute_type => l_attr_type,
2121: p_entity_attribute_code => l_attr_code,
2122: p_rule_input_rec => l_rule_input_rec,
2123: x_default_value => l_default_val_num,
2125: x_return_status => x_return_status,
2126: x_msg_count => x_msg_count,
2127: x_msg_data => x_msg_data
2128: );
2129: if (x_return_status = fnd_api.g_ret_sts_success) then
2130: if (l_default_val_num is not null) then
2131: px_repln_rec.resource_id := l_default_val_num;
2132: end if;
2133: else
2130: if (l_default_val_num is not null) then
2131: px_repln_rec.resource_id := l_default_val_num;
2132: end if;
2133: else
2134: RAISE FND_API.G_EXC_ERROR;
2135: end if;
2136: end if;
2137:
2138: /****************************** DEFAULT REPAIR PRIORITY ******************************/
2135: end if;
2136: end if;
2137:
2138: /****************************** DEFAULT REPAIR PRIORITY ******************************/
2139: if (px_repln_rec.ro_priority_code = FND_API.G_MISS_CHAR) then
2140: l_attr_type := 'CSD_DEF_ENTITY_ATTR_RO';
2141: l_attr_code := 'REPAIR_PRIORITY';
2142: l_default_val_num := null;
2143: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2141: l_attr_code := 'REPAIR_PRIORITY';
2142: l_default_val_num := null;
2143: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2144: p_api_version_number => 1.0,
2145: p_init_msg_list => fnd_api.g_false,
2146: p_commit => fnd_api.g_false,
2147: p_validation_level => fnd_api.g_valid_level_full,
2148: p_entity_attribute_type => l_attr_type,
2149: p_entity_attribute_code => l_attr_code,
2142: l_default_val_num := null;
2143: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2144: p_api_version_number => 1.0,
2145: p_init_msg_list => fnd_api.g_false,
2146: p_commit => fnd_api.g_false,
2147: p_validation_level => fnd_api.g_valid_level_full,
2148: p_entity_attribute_type => l_attr_type,
2149: p_entity_attribute_code => l_attr_code,
2150: p_rule_input_rec => l_rule_input_rec,
2143: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2144: p_api_version_number => 1.0,
2145: p_init_msg_list => fnd_api.g_false,
2146: p_commit => fnd_api.g_false,
2147: p_validation_level => fnd_api.g_valid_level_full,
2148: p_entity_attribute_type => l_attr_type,
2149: p_entity_attribute_code => l_attr_code,
2150: p_rule_input_rec => l_rule_input_rec,
2151: x_default_value => l_default_val_str,
2153: x_return_status => x_return_status,
2154: x_msg_count => x_msg_count,
2155: x_msg_data => x_msg_data
2156: );
2157: if (x_return_status = fnd_api.g_ret_sts_success) then
2158: if (l_default_val_str is not null) then
2159: px_repln_rec.ro_priority_code := l_default_val_str;
2160: end if;
2161: else
2158: if (l_default_val_str is not null) then
2159: px_repln_rec.ro_priority_code := l_default_val_str;
2160: end if;
2161: else
2162: RAISE FND_API.G_EXC_ERROR;
2163: end if;
2164: end if;
2165:
2166: /****************************** DEFAULT REPAIR TYPE ******************************/
2163: end if;
2164: end if;
2165:
2166: /****************************** DEFAULT REPAIR TYPE ******************************/
2167: if (px_repln_rec.repair_type_id = FND_API.G_MISS_NUM) then
2168: l_attr_type := 'CSD_DEF_ENTITY_ATTR_RO';
2169: l_attr_code := 'REPAIR_TYPE';
2170: l_default_val_num := null;
2171: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2169: l_attr_code := 'REPAIR_TYPE';
2170: l_default_val_num := null;
2171: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2172: p_api_version_number => 1.0,
2173: p_init_msg_list => fnd_api.g_false,
2174: p_commit => fnd_api.g_false,
2175: p_validation_level => fnd_api.g_valid_level_full,
2176: p_entity_attribute_type => l_attr_type,
2177: p_entity_attribute_code => l_attr_code,
2170: l_default_val_num := null;
2171: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2172: p_api_version_number => 1.0,
2173: p_init_msg_list => fnd_api.g_false,
2174: p_commit => fnd_api.g_false,
2175: p_validation_level => fnd_api.g_valid_level_full,
2176: p_entity_attribute_type => l_attr_type,
2177: p_entity_attribute_code => l_attr_code,
2178: p_rule_input_rec => l_rule_input_rec,
2171: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2172: p_api_version_number => 1.0,
2173: p_init_msg_list => fnd_api.g_false,
2174: p_commit => fnd_api.g_false,
2175: p_validation_level => fnd_api.g_valid_level_full,
2176: p_entity_attribute_type => l_attr_type,
2177: p_entity_attribute_code => l_attr_code,
2178: p_rule_input_rec => l_rule_input_rec,
2179: x_default_value => l_default_val_num,
2182: x_msg_count => x_msg_count,
2183: x_msg_data => x_msg_data
2184: );
2185:
2186: if (x_return_status = fnd_api.g_ret_sts_success) then
2187: if (l_default_val_num is not null) then
2188: l_repair_type_id := l_default_val_num;
2189: else
2190: l_repair_type_id := to_number(fnd_profile.value('CSD_DEFAULT_REPAIR_TYPE'));
2202: px_repln_rec.repair_mode := l_repair_mode;
2203:
2204: -- allow user to override auto process default, so only default
2205: -- if no value specified.
2206: if (px_repln_rec.auto_process_rma = FND_API.G_MISS_NUM) then
2207: px_repln_rec.auto_process_rma := l_auto_process_rma;
2208: end if;
2209: end if;
2210: else
2207: px_repln_rec.auto_process_rma := l_auto_process_rma;
2208: end if;
2209: end if;
2210: else
2211: RAISE FND_API.G_EXC_ERROR;
2212: end if;
2213: end if;
2214:
2215: if p_commit = fnd_api.g_true then
2211: RAISE FND_API.G_EXC_ERROR;
2212: end if;
2213: end if;
2214:
2215: if p_commit = fnd_api.g_true then
2216: commit;
2217: end if;
2218:
2219: EXCEPTION
2216: commit;
2217: end if;
2218:
2219: EXCEPTION
2220: When FND_API.G_EXC_ERROR then
2221: x_return_status := FND_API.G_RET_STS_ERROR ;
2222: FND_MSG_PUB.Count_And_Get
2223: (p_count => x_msg_count,
2224: p_data => x_msg_data );
2217: end if;
2218:
2219: EXCEPTION
2220: When FND_API.G_EXC_ERROR then
2221: x_return_status := FND_API.G_RET_STS_ERROR ;
2222: FND_MSG_PUB.Count_And_Get
2223: (p_count => x_msg_count,
2224: p_data => x_msg_data );
2225:
2222: FND_MSG_PUB.Count_And_Get
2223: (p_count => x_msg_count,
2224: p_data => x_msg_data );
2225:
2226: When FND_API.G_EXC_UNEXPECTED_ERROR then
2227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2228: FND_MSG_PUB.Count_And_Get
2229: ( p_count => x_msg_count,
2230: p_data => x_msg_data );
2223: (p_count => x_msg_count,
2224: p_data => x_msg_data );
2225:
2226: When FND_API.G_EXC_UNEXPECTED_ERROR then
2227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2228: FND_MSG_PUB.Count_And_Get
2229: ( p_count => x_msg_count,
2230: p_data => x_msg_data );
2231:
2229: ( p_count => x_msg_count,
2230: p_data => x_msg_data );
2231:
2232: When OTHERS then
2233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2234: If FND_MSG_PUB.Check_Msg_Level
2235: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
2236: FND_MSG_PUB.Add_Exc_Msg
2237: (G_PKG_NAME,
2254:
2255: PROCEDURE create_requisition
2256: (
2257: p_api_version_number IN NUMBER,
2258: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2259: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2260: x_return_status OUT NOCOPY VARCHAR2,
2261: x_msg_count OUT NOCOPY NUMBER,
2262: x_msg_data OUT NOCOPY VARCHAR2,
2255: PROCEDURE create_requisition
2256: (
2257: p_api_version_number IN NUMBER,
2258: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2259: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2260: x_return_status OUT NOCOPY VARCHAR2,
2261: x_msg_count OUT NOCOPY NUMBER,
2262: x_msg_data OUT NOCOPY VARCHAR2,
2263: p_wip_entity_id_tbl IN JTF_NUMBER_TABLE,
2309: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2310: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Begin Create_requisition');
2311: END IF;
2312:
2313: if not fnd_api.compatible_api_call(
2314: lc_api_version,
2315: p_api_version_number,
2316: lc_api_name,
2317: g_pkg_name) then
2314: lc_api_version,
2315: p_api_version_number,
2316: lc_api_name,
2317: g_pkg_name) then
2318: raise fnd_api.g_exc_unexpected_error;
2319: end if;
2320:
2321: IF fnd_api.to_boolean(p_init_msg_list) THEN
2322: fnd_msg_pub.initialize;
2317: g_pkg_name) then
2318: raise fnd_api.g_exc_unexpected_error;
2319: end if;
2320:
2321: IF fnd_api.to_boolean(p_init_msg_list) THEN
2322: fnd_msg_pub.initialize;
2323: END IF;
2324:
2325: -- initialize return status.
2322: fnd_msg_pub.initialize;
2323: END IF;
2324:
2325: -- initialize return status.
2326: x_return_status := FND_API.g_ret_sts_success;
2327:
2328: -- get the person_id for the current user.
2329: select employee_id
2330: into l_person_id
2346:
2347: if nvl(l_dummy,-1) <= -1 then
2348: FND_MESSAGE.SET_NAME('CSD','CSD_REQ_LEAD_TIME_NOT_SET');
2349: FND_MSG_PUB.ADD;
2350: raise fnd_api.g_exc_error;
2351: end if;
2352:
2353: l_needby_date := sysdate + l_dummy;
2354: --
2384: x_msg_data => x_msg_data,
2385: x_msg_count => x_msg_count
2386: );
2387:
2388: IF x_return_status <> fnd_api.g_ret_sts_success
2389: THEN
2390: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2391: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'The custom procedure raised an error status, exiting the API.');
2392: END IF;
2389: THEN
2390: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2391: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'The custom procedure raised an error status, exiting the API.');
2392: END IF;
2393: RAISE fnd_api.g_exc_error;
2394: END IF;
2395:
2396: -- if the user hook doesn't implement sourcing, we will copy the input parameters into the l_*
2397: -- variables.
2600: END IF;
2601:
2602: IF x_request_id <= 0
2603: THEN
2604: raise fnd_api.g_exc_error;
2605: END IF;
2606:
2607: -- need to call the mat_issue_update procedure.
2608: l_previous_wip_entity := NULL;
2615: END IF;
2616:
2617: CSD_HV_WIP_JOB_PVT.update_mat_issue_quantities
2618: (p_api_version_number => 1.0,
2619: p_init_msg_list => fnd_api.g_false,
2620: p_commit => fnd_api.g_false,
2621: p_validation_level => 100,
2622: x_return_status => x_return_status,
2623: x_msg_count => x_msg_count,
2616:
2617: CSD_HV_WIP_JOB_PVT.update_mat_issue_quantities
2618: (p_api_version_number => 1.0,
2619: p_init_msg_list => fnd_api.g_false,
2620: p_commit => fnd_api.g_false,
2621: p_validation_level => 100,
2622: x_return_status => x_return_status,
2623: x_msg_count => x_msg_count,
2624: x_msg_data => x_msg_data,
2623: x_msg_count => x_msg_count,
2624: x_msg_data => x_msg_data,
2625: p_wip_entity_id => p_wip_entity_id_tbl(k)
2626: );
2627: IF x_return_status <> fnd_api.g_ret_sts_success
2628: THEN
2629: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2630: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Error in update_mat_issue_quantities API for wip_entity_id '||p_wip_entity_id_tbl(k));
2631: END IF;
2628: THEN
2629: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2630: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Error in update_mat_issue_quantities API for wip_entity_id '||p_wip_entity_id_tbl(k));
2631: END IF;
2632: RAISE fnd_api.g_exc_error;
2633: END IF;
2634: l_previous_wip_entity := p_wip_entity_id_tbl(k);
2635:
2636: END IF;
2698: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'The number of records is '||l_mtl_txn_dtls_upd.COUNT);
2699: END IF;
2700: csd_hv_wip_job_pvt.process_save_mtl_txn_dtls
2701: (p_api_version_number => 1,
2702: p_init_msg_list => fnd_api.g_false,
2703: p_commit => fnd_api.g_false,
2704: p_validation_level => 100,
2705: x_return_status => x_return_status,
2706: x_msg_count => x_msg_count,
2699: END IF;
2700: csd_hv_wip_job_pvt.process_save_mtl_txn_dtls
2701: (p_api_version_number => 1,
2702: p_init_msg_list => fnd_api.g_false,
2703: p_commit => fnd_api.g_false,
2704: p_validation_level => 100,
2705: x_return_status => x_return_status,
2706: x_msg_count => x_msg_count,
2707: x_msg_data => x_msg_data,
2708: p_mtl_txn_dtls_tbl => l_mtl_txn_dtls_upd,
2709: x_op_created => x_op_created
2710: );
2711:
2712: IF x_return_status <> fnd_api.g_ret_sts_success
2713: THEN
2714: RAISE fnd_api.g_exc_error;
2715: END IF;
2716:
2710: );
2711:
2712: IF x_return_status <> fnd_api.g_ret_sts_success
2713: THEN
2714: RAISE fnd_api.g_exc_error;
2715: END IF;
2716:
2717: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2718: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Calling process_save_mtl_txn_dtls to create new material requirements.');
2720: END IF;
2721:
2722: csd_hv_wip_job_pvt.process_save_mtl_txn_dtls
2723: (p_api_version_number => 1,
2724: p_init_msg_list => fnd_api.g_false,
2725: p_commit => fnd_api.g_false,
2726: p_validation_level => 100,
2727: x_return_status => x_return_status,
2728: x_msg_count => x_msg_count,
2721:
2722: csd_hv_wip_job_pvt.process_save_mtl_txn_dtls
2723: (p_api_version_number => 1,
2724: p_init_msg_list => fnd_api.g_false,
2725: p_commit => fnd_api.g_false,
2726: p_validation_level => 100,
2727: x_return_status => x_return_status,
2728: x_msg_count => x_msg_count,
2729: x_msg_data => x_msg_data,
2729: x_msg_data => x_msg_data,
2730: p_mtl_txn_dtls_tbl => l_mtl_txn_dtls_tab,
2731: x_op_created => x_op_created
2732: );
2733: IF x_return_status <> fnd_api.g_ret_sts_success
2734: THEN
2735: RAISE fnd_api.g_exc_error;
2736: END IF;
2737: END IF;
2731: x_op_created => x_op_created
2732: );
2733: IF x_return_status <> fnd_api.g_ret_sts_success
2734: THEN
2735: RAISE fnd_api.g_exc_error;
2736: END IF;
2737: END IF;
2738:
2739: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2752: AND inventory_item_id = l_mtl_txn_dtls_upd(k).inventory_item_id;
2753:
2754: END LOOP;
2755:
2756: if fnd_api.to_boolean(p_commit) then
2757: commit work;
2758: end if;
2759: exception
2760: when fnd_api.g_exc_error then
2756: if fnd_api.to_boolean(p_commit) then
2757: commit work;
2758: end if;
2759: exception
2760: when fnd_api.g_exc_error then
2761: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2762: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
2763: lc_mod_name,
2764: 'Execution error in the API');
2763: lc_mod_name,
2764: 'Execution error in the API');
2765: END IF;
2766: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );
2767: x_return_Status := fnd_api.g_ret_sts_error;
2768: rollback to create_requisition;
2769: when fnd_api.g_exc_unexpected_error then
2770: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2771: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
2765: END IF;
2766: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );
2767: x_return_Status := fnd_api.g_ret_sts_error;
2768: rollback to create_requisition;
2769: when fnd_api.g_exc_unexpected_error then
2770: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2771: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
2772: lc_mod_name,
2773: 'Unexpected error');
2771: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
2772: lc_mod_name,
2773: 'Unexpected error');
2774: END IF;
2775: x_return_status := fnd_api.g_ret_sts_error;
2776: rollback to create_requisition;
2777: /*when others then
2778: raise;*/
2779: END create_requisition;
2849:
2850: If l_request_id <= 0 then
2851: -- error during concurrent request submission.
2852: fnd_file.put_line(fnd_file.log,'There was an error in launching the Requisition Import program');
2853: raise fnd_api.g_exc_error;
2854: end if;
2855:
2856: -- commit.
2857: COMMIT WORK;
2921: x_msg_count => x_msg_count,
2922: x_msg_data => x_msg_data
2923: );
2924:
2925: IF x_return_status <> fnd_api.g_ret_sts_success
2926: THEN
2927: RAISE fnd_api.g_exc_error;
2928: END IF;
2929: END LOOP;
2923: );
2924:
2925: IF x_return_status <> fnd_api.g_ret_sts_success
2926: THEN
2927: RAISE fnd_api.g_exc_error;
2928: END IF;
2929: END LOOP;
2930: l_create_iso := FALSE;
2931:
2988: a.requisition_line_id,
2989: a.delivery_detail_id);
2990:
2991: EXCEPTION
2992: WHEN fnd_api.g_exc_error THEN
2993: retcode := 2;
2994: errbuf := x_message;
2995: END create_requisition_cp;
2996:
3010:
3011: PROCEDURE create_repair_warranty
3012: (
3013: p_api_version_number IN NUMBER,
3014: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3015: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3016: x_return_status OUT NOCOPY VARCHAR2,
3017: x_msg_count OUT NOCOPY NUMBER,
3018: x_msg_data OUT NOCOPY VARCHAR2,
3011: PROCEDURE create_repair_warranty
3012: (
3013: p_api_version_number IN NUMBER,
3014: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3015: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3016: x_return_status OUT NOCOPY VARCHAR2,
3017: x_msg_count OUT NOCOPY NUMBER,
3018: x_msg_data OUT NOCOPY VARCHAR2,
3019: x_contract_number OUT NOCOPY VARCHAR2,
3157: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_order_line_id => '||p_order_line_id);
3158: END IF;
3159:
3160: -- standard check.
3161: IF NOT fnd_api.compatible_api_call(
3162: lc_api_version,
3163: p_api_version_number,
3164: lc_api_name,
3165: g_pkg_name) THEN
3162: lc_api_version,
3163: p_api_version_number,
3164: lc_api_name,
3165: g_pkg_name) THEN
3166: RAISE fnd_api.g_exc_unexpected_error;
3167: END IF;
3168:
3169: IF fnd_api.to_boolean(p_init_msg_list)
3170: THEN
3165: g_pkg_name) THEN
3166: RAISE fnd_api.g_exc_unexpected_error;
3167: END IF;
3168:
3169: IF fnd_api.to_boolean(p_init_msg_list)
3170: THEN
3171: fnd_msg_pub.initialize;
3172: END IF;
3173: -- initialize return status.
3170: THEN
3171: fnd_msg_pub.initialize;
3172: END IF;
3173: -- initialize return status.
3174: x_return_status := fnd_api.g_ret_sts_success;
3175:
3176: -- validate the order line id.
3177: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3178: THEN
3253: THEN
3254: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Returned from csd_logistics_cuhk.service_item. The service item returned is '||NVL(l_service_item_id,-999));
3255: END IF;
3256:
3257: IF x_return_status <> fnd_api.g_ret_sts_success
3258: THEN
3259: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3260: THEN
3261: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The user hook procedure returns a non success code. Raising the exception.');
3259: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3260: THEN
3261: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The user hook procedure returns a non success code. Raising the exception.');
3262: END IF;
3263: raise fnd_api.g_exc_error;
3264: END IF;
3265:
3266: IF l_service_item_id IS NULL
3267: THEN
3267: THEN
3268: l_rule_input_rec.repair_line_id := l_repair_line_id;
3269: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE
3270: (p_api_version_number => 1.0,
3271: p_init_msg_list => fnd_api.g_false,
3272: p_commit => fnd_api.g_false,
3273: p_validation_level => fnd_api.g_valid_level_full,
3274: p_entity_attribute_type => 'CSD_DEF_ENTITY_ATTR_RO',
3275: p_entity_attribute_code => 'SERVICE_WARRANTY',
3268: l_rule_input_rec.repair_line_id := l_repair_line_id;
3269: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE
3270: (p_api_version_number => 1.0,
3271: p_init_msg_list => fnd_api.g_false,
3272: p_commit => fnd_api.g_false,
3273: p_validation_level => fnd_api.g_valid_level_full,
3274: p_entity_attribute_type => 'CSD_DEF_ENTITY_ATTR_RO',
3275: p_entity_attribute_code => 'SERVICE_WARRANTY',
3276: p_rule_input_rec => l_rule_input_rec,
3269: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE
3270: (p_api_version_number => 1.0,
3271: p_init_msg_list => fnd_api.g_false,
3272: p_commit => fnd_api.g_false,
3273: p_validation_level => fnd_api.g_valid_level_full,
3274: p_entity_attribute_type => 'CSD_DEF_ENTITY_ATTR_RO',
3275: p_entity_attribute_code => 'SERVICE_WARRANTY',
3276: p_rule_input_rec => l_rule_input_rec,
3277: x_default_value => l_service_item_id,
3279: x_return_status => x_return_status,
3280: x_msg_count => x_msg_count,
3281: x_msg_data => x_msg_data
3282: );
3283: IF x_return_status <> fnd_api.g_ret_sts_success
3284: THEN
3285: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3286: THEN
3287: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Error occured in calling rules engine.');
3285: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3286: THEN
3287: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Error occured in calling rules engine.');
3288: END IF;
3289: RAISE fnd_api.g_exc_error;
3290: END IF;
3291: END IF;
3292:
3293: -- need to walk through all the materials transacted and check if there exists
3314: l_rule_input_rec.repair_line_id := l_repair_line_id;
3315:
3316: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE
3317: (p_api_version_number => 1.0,
3318: p_init_msg_list => fnd_api.g_false,
3319: p_commit => fnd_api.g_false,
3320: p_validation_level => fnd_api.g_valid_level_full,
3321: p_entity_attribute_type => 'CSD_DEF_ENTITY_ATTR_RO',
3322: p_entity_attribute_code => 'SERVICE_WARRANTY',
3315:
3316: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE
3317: (p_api_version_number => 1.0,
3318: p_init_msg_list => fnd_api.g_false,
3319: p_commit => fnd_api.g_false,
3320: p_validation_level => fnd_api.g_valid_level_full,
3321: p_entity_attribute_type => 'CSD_DEF_ENTITY_ATTR_RO',
3322: p_entity_attribute_code => 'SERVICE_WARRANTY',
3323: p_rule_input_rec => l_rule_input_rec,
3316: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE
3317: (p_api_version_number => 1.0,
3318: p_init_msg_list => fnd_api.g_false,
3319: p_commit => fnd_api.g_false,
3320: p_validation_level => fnd_api.g_valid_level_full,
3321: p_entity_attribute_type => 'CSD_DEF_ENTITY_ATTR_RO',
3322: p_entity_attribute_code => 'SERVICE_WARRANTY',
3323: p_rule_input_rec => l_rule_input_rec,
3324: x_default_value => l_service_item_id,
3326: x_return_status => x_return_status,
3327: x_msg_count => x_msg_count,
3328: x_msg_data => x_msg_data
3329: );
3330: IF x_return_status <> fnd_api.g_ret_sts_success
3331: THEN
3332: RAISE fnd_api.g_exc_error;
3333: END IF;
3334:
3328: x_msg_data => x_msg_data
3329: );
3330: IF x_return_status <> fnd_api.g_ret_sts_success
3331: THEN
3332: RAISE fnd_api.g_exc_error;
3333: END IF;
3334:
3335: EXIT WHEN l_service_item_id IS NOT NULL;
3336: END LOOP;
3377: -- the service item is not null, create the line in OM.
3378: -- get the ship from org id
3379: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE
3380: (p_api_version_number => 1.0,
3381: p_init_msg_list => fnd_api.g_false,
3382: p_commit => fnd_api.g_false,
3383: p_validation_level => fnd_api.g_valid_level_full,
3384: p_entity_attribute_type => 'CSD_DEF_ENTITY_ATTR_RO',
3385: p_entity_attribute_code => 'SHIP_FROM_ORG',
3378: -- get the ship from org id
3379: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE
3380: (p_api_version_number => 1.0,
3381: p_init_msg_list => fnd_api.g_false,
3382: p_commit => fnd_api.g_false,
3383: p_validation_level => fnd_api.g_valid_level_full,
3384: p_entity_attribute_type => 'CSD_DEF_ENTITY_ATTR_RO',
3385: p_entity_attribute_code => 'SHIP_FROM_ORG',
3386: p_rule_input_rec => l_rule_input_rec,
3379: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE
3380: (p_api_version_number => 1.0,
3381: p_init_msg_list => fnd_api.g_false,
3382: p_commit => fnd_api.g_false,
3383: p_validation_level => fnd_api.g_valid_level_full,
3384: p_entity_attribute_type => 'CSD_DEF_ENTITY_ATTR_RO',
3385: p_entity_attribute_code => 'SHIP_FROM_ORG',
3386: p_rule_input_rec => l_rule_input_rec,
3387: x_default_value => l_ship_from_org_id,
3420: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Calling oks_omint_pub.get_duration to get the duration.');
3421: END IF;
3422: oks_omint_pub.get_duration
3423: (p_api_version => 11.5,
3424: p_init_msg_list => fnd_api.g_false,
3425: x_msg_count => x_msg_count,
3426: x_msg_data => x_msg_data,
3427: x_return_status => x_return_status,
3428: p_customer_id => NULL,
3435: x_service_period => x_service_duration_code,
3436: x_new_end_date => x_service_end_date
3437: );
3438:
3439: IF x_return_status <> fnd_api.g_ret_sts_success
3440: THEN
3441: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3442: THEN
3443: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Error in oks_omint_pub.get_duration. Error msg is: '||x_msg_data);
3441: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3442: THEN
3443: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Error in oks_omint_pub.get_duration. Error msg is: '||x_msg_data);
3444: END IF;
3445: RAISE fnd_api.g_exc_error;
3446:
3447: END IF;
3448:
3449: l_line_tbl(1).service_start_date := l_service_start_date;
3463: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Calling oe_order_pub.process_order');
3464: END IF;
3465: oe_order_pub.process_order
3466: (p_api_version_number => 1.0
3467: , p_init_msg_list => fnd_api.g_false
3468: , p_return_values => fnd_api.g_false
3469: , p_action_commit => fnd_api.g_false
3470: , x_return_status => x_return_status
3471: , x_msg_count => x_msg_count
3464: END IF;
3465: oe_order_pub.process_order
3466: (p_api_version_number => 1.0
3467: , p_init_msg_list => fnd_api.g_false
3468: , p_return_values => fnd_api.g_false
3469: , p_action_commit => fnd_api.g_false
3470: , x_return_status => x_return_status
3471: , x_msg_count => x_msg_count
3472: , x_msg_data => x_msg_data
3465: oe_order_pub.process_order
3466: (p_api_version_number => 1.0
3467: , p_init_msg_list => fnd_api.g_false
3468: , p_return_values => fnd_api.g_false
3469: , p_action_commit => fnd_api.g_false
3470: , x_return_status => x_return_status
3471: , x_msg_count => x_msg_count
3472: , x_msg_data => x_msg_data
3473: , p_header_rec => l_header_rec
3497: , x_lot_serial_val_tbl => x_lot_serial_val_tbl
3498: , x_action_request_tbl => x_action_request_tbl
3499: );
3500:
3501: IF x_return_status <> fnd_api.g_ret_sts_success
3502: THEN
3503:
3504: if x_msg_count > 1
3505: then
3515: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3516: p_data => x_msg_data
3517: );
3518: end if;
3519: RAISE fnd_api.g_exc_error;
3520: END IF;
3521:
3522: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3523: THEN
3559: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3560: THEN
3561: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Error occurred while submitting the concurrent request. Program name is:OKSREPROC');
3562: END IF;
3563: RAISE fnd_api.g_exc_error;
3564: END IF;
3565:
3566: -- we need to commit the work here (for the CP to be launched)
3567: COMMIT WORK ;
3581: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3582: THEN
3583: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Error occurred while waiting for the request to complete. The error message is :'||x_message);
3584: END IF;
3585: RAISE fnd_api.g_exc_error;
3586: END IF;
3587: -- add a new repair activity to mark the creation of repair warranty.
3588: -- 1. get the contract number and its short description
3589: BEGIN
3599: WHEN NO_DATA_FOUND THEN
3600: -- no contracts created. Raise the error.
3601: fnd_message.set_name('CSD','CSD_SER_WARRANTY_CR_ERR');
3602: fnd_message.set_token('ORDER_LINE_ID',x_line_tbl(1).line_id);
3603: RAISE fnd_api.g_exc_error;
3604: END;
3605:
3606: -- get the item name
3607: SELECT concatenated_segments
3636: END IF;
3637: csd_update_programs_pvt.log_activity
3638: (p_api_version => 1.0,
3639: p_commit => p_commit,
3640: p_init_msg_list => fnd_api.g_false,
3641: p_validation_level => fnd_api.g_valid_level_full,
3642: x_return_status => x_return_status,
3643: x_msg_count => x_msg_count,
3644: x_msg_data => x_msg_data,
3637: csd_update_programs_pvt.log_activity
3638: (p_api_version => 1.0,
3639: p_commit => p_commit,
3640: p_init_msg_list => fnd_api.g_false,
3641: p_validation_level => fnd_api.g_valid_level_full,
3642: x_return_status => x_return_status,
3643: x_msg_count => x_msg_count,
3644: x_msg_data => x_msg_data,
3645: p_activity_rec => l_activity_rec
3643: x_msg_count => x_msg_count,
3644: x_msg_data => x_msg_data,
3645: p_activity_rec => l_activity_rec
3646: );
3647: IF x_return_status <> fnd_api.g_ret_sts_success
3648: THEN
3649: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3650: THEN
3651: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'csd_update_programs_pvt.log_activity. Error msg is: '||x_msg_data);
3649: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3650: THEN
3651: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'csd_update_programs_pvt.log_activity. Error msg is: '||x_msg_data);
3652: END IF;
3653: RAISE fnd_api.g_exc_error;
3654: END IF;
3655:
3656: IF fnd_api.to_boolean(p_commit)
3657: THEN
3652: END IF;
3653: RAISE fnd_api.g_exc_error;
3654: END IF;
3655:
3656: IF fnd_api.to_boolean(p_commit)
3657: THEN
3658: COMMIT WORK;
3659: END IF;
3660:
3659: END IF;
3660:
3661: EXCEPTION
3662: WHEN NO_DATA_FOUND THEN
3663: x_return_status := fnd_api.g_ret_sts_error;
3664: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3665: p_data => x_msg_data
3666: );
3667:
3664: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3665: p_data => x_msg_data
3666: );
3667:
3668: WHEN fnd_api.g_exc_error THEN
3669: x_return_status := fnd_api.g_ret_sts_error;
3670: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3671: p_data => x_msg_data
3672: );
3665: p_data => x_msg_data
3666: );
3667:
3668: WHEN fnd_api.g_exc_error THEN
3669: x_return_status := fnd_api.g_ret_sts_error;
3670: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3671: p_data => x_msg_data
3672: );
3673:
3675:
3676: PROCEDURE create_inst_party_relation
3677: (
3678: p_api_version_number IN NUMBER,
3679: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3680: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3681: x_return_status OUT NOCOPY VARCHAR2,
3682: x_msg_count OUT NOCOPY NUMBER,
3683: x_msg_data OUT NOCOPY VARCHAR2,
3676: PROCEDURE create_inst_party_relation
3677: (
3678: p_api_version_number IN NUMBER,
3679: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3680: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3681: x_return_status OUT NOCOPY VARCHAR2,
3682: x_msg_count OUT NOCOPY NUMBER,
3683: x_msg_data OUT NOCOPY VARCHAR2,
3684: x_relationship_created OUT NOCOPY VARCHAR2,
3714: END IF;
3715:
3716:
3717: -- standard check.
3718: IF NOT fnd_api.compatible_api_call(
3719: lc_api_version,
3720: p_api_version_number,
3721: lc_api_name,
3722: g_pkg_name) THEN
3719: lc_api_version,
3720: p_api_version_number,
3721: lc_api_name,
3722: g_pkg_name) THEN
3723: RAISE fnd_api.g_exc_unexpected_error;
3724: END IF;
3725:
3726: IF fnd_api.to_boolean(p_init_msg_list)
3727: THEN
3722: g_pkg_name) THEN
3723: RAISE fnd_api.g_exc_unexpected_error;
3724: END IF;
3725:
3726: IF fnd_api.to_boolean(p_init_msg_list)
3727: THEN
3728: fnd_msg_pub.initialize;
3729: END IF;
3730:
3728: fnd_msg_pub.initialize;
3729: END IF;
3730:
3731: -- initialize return status.
3732: x_return_status := fnd_api.g_ret_sts_success;
3733: -- initialize the relation created flag.
3734: x_relationship_created := fnd_api.g_true;
3735:
3736: -- check if there exists a valid relationship for the customer/account and relationship type.
3730:
3731: -- initialize return status.
3732: x_return_status := fnd_api.g_ret_sts_success;
3733: -- initialize the relation created flag.
3734: x_relationship_created := fnd_api.g_true;
3735:
3736: -- check if there exists a valid relationship for the customer/account and relationship type.
3737: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3738: THEN
3748: AND relationship_type_code = p_relationship_type
3749: AND party_id = p_sr_party_id
3750: AND SYSDATE BETWEEN NVL(active_start_date,SYSDATE - 1) AND NVL(active_end_date, SYSDATE + 1);
3751:
3752: x_relationship_created := fnd_api.g_false;
3753: RETURN;
3754:
3755: EXCEPTION
3756: WHEN NO_DATA_FOUND THEN
3803:
3804: csi_party_relationships_pub.create_inst_party_relationship
3805: (p_api_version => 1.0,
3806: p_commit => p_commit,
3807: p_init_msg_list => fnd_api.g_false,
3808: p_party_tbl => l_party_tbl,
3809: p_party_account_tbl => l_party_acct_tbl,
3810: p_txn_rec => l_txn_rec,
3811: p_oks_txn_inst_tbl => l_oks_txn_inst_tbl,
3813: x_msg_count => x_msg_count,
3814: x_msg_data => x_msg_data
3815: );
3816:
3817: IF x_return_status <> fnd_api.g_ret_sts_success
3818: THEN
3819: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3820: THEN
3821: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The csi_party_relationships_pub.create_inst_party_relationship API returned a non success return status.');
3822: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The error count:'||x_msg_count);
3823: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The error msg:'||x_msg_data);
3824: END IF;
3825:
3826: RAISE fnd_api.g_exc_error;
3827: END IF;
3828:
3829: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3830: THEN
3831: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Successfully created the instance party relationship. Exiting '||lc_mod_name);
3832: END IF;
3833:
3834: EXCEPTION
3835: WHEN fnd_api.g_exc_error THEN
3836: x_relationship_created := fnd_api.g_false;
3837: ROLLBACK TO create_inst_party_relation;
3838:
3839: WHEN fnd_api.g_exc_unexpected_error THEN
3832: END IF;
3833:
3834: EXCEPTION
3835: WHEN fnd_api.g_exc_error THEN
3836: x_relationship_created := fnd_api.g_false;
3837: ROLLBACK TO create_inst_party_relation;
3838:
3839: WHEN fnd_api.g_exc_unexpected_error THEN
3840: x_relationship_created := fnd_api.g_false;
3835: WHEN fnd_api.g_exc_error THEN
3836: x_relationship_created := fnd_api.g_false;
3837: ROLLBACK TO create_inst_party_relation;
3838:
3839: WHEN fnd_api.g_exc_unexpected_error THEN
3840: x_relationship_created := fnd_api.g_false;
3841:
3842: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3843: THEN
3836: x_relationship_created := fnd_api.g_false;
3837: ROLLBACK TO create_inst_party_relation;
3838:
3839: WHEN fnd_api.g_exc_unexpected_error THEN
3840: x_relationship_created := fnd_api.g_false;
3841:
3842: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3843: THEN
3844: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The api version check failed!');