eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PP_MATERIALS_PVT dependencies on FND_API

Line 120: p_organization_id <> FND_API.G_MISS_NUM)

116: )
117: IS
118: BEGIN
119: IF (p_organization_id IS NOT NULL AND
120: p_organization_id <> FND_API.G_MISS_NUM)
121: THEN
122: SELECT organization_id
123: INTO x_organization_id
124: FROM HR_ALL_ORGANIZATION_UNITS

Line 132: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

128: INTO x_organization_id
129: FROM HR_ALL_ORGANIZATION_UNITS
130: WHERE NAME = p_org_name;
131: END IF;
132: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
133: EXCEPTION
134: WHEN NO_DATA_FOUND THEN
135: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
136: x_error_msg_code:= 'AHL_PP_ORG_ID_NOT_EXISTS';

Line 135: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

131: END IF;
132: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
133: EXCEPTION
134: WHEN NO_DATA_FOUND THEN
135: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
136: x_error_msg_code:= 'AHL_PP_ORG_ID_NOT_EXISTS';
137: WHEN TOO_MANY_ROWS THEN
138: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
139: x_error_msg_code:= 'AHL_PP_ORG_ID_NOT_EXISTS';

Line 138: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

134: WHEN NO_DATA_FOUND THEN
135: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
136: x_error_msg_code:= 'AHL_PP_ORG_ID_NOT_EXISTS';
137: WHEN TOO_MANY_ROWS THEN
138: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
139: x_error_msg_code:= 'AHL_PP_ORG_ID_NOT_EXISTS';
140: WHEN OTHERS THEN
141: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
142: RAISE;

Line 141: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;

137: WHEN TOO_MANY_ROWS THEN
138: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
139: x_error_msg_code:= 'AHL_PP_ORG_ID_NOT_EXISTS';
140: WHEN OTHERS THEN
141: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
142: RAISE;
143: END Check_org_name_Or_Id;
144: --
145: PROCEDURE Check_dept_desc_Or_Id

Line 158: p_department_id <> FND_API.G_MISS_NUM)

154: IS
155: BEGIN
156:
157: IF (p_department_id IS NOT NULL AND
158: p_department_id <> FND_API.G_MISS_NUM)
159: THEN
160: SELECT department_id
161: INTO x_department_id
162: FROM BOM_DEPARTMENTS

Line 173: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

169: FROM BOM_DEPARTMENTS
170: WHERE organization_id = p_organization_id
171: AND description = p_dept_description;
172: END IF;
173: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
174: EXCEPTION
175: WHEN NO_DATA_FOUND THEN
176: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
177: x_error_msg_code:= 'AHL_PP_DEPT_ID_NOT_EXIST';

Line 176: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

172: END IF;
173: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
174: EXCEPTION
175: WHEN NO_DATA_FOUND THEN
176: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
177: x_error_msg_code:= 'AHL_PP_DEPT_ID_NOT_EXIST';
178: WHEN TOO_MANY_ROWS THEN
179: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
180: x_error_msg_code:= 'AHL_PP_DEPT_ID_NOT_EXIST';

Line 179: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

175: WHEN NO_DATA_FOUND THEN
176: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
177: x_error_msg_code:= 'AHL_PP_DEPT_ID_NOT_EXIST';
178: WHEN TOO_MANY_ROWS THEN
179: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
180: x_error_msg_code:= 'AHL_PP_DEPT_ID_NOT_EXIST';
181: WHEN OTHERS THEN
182: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
183: RAISE;

Line 182: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;

178: WHEN TOO_MANY_ROWS THEN
179: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
180: x_error_msg_code:= 'AHL_PP_DEPT_ID_NOT_EXIST';
181: WHEN OTHERS THEN
182: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
183: RAISE;
184: END Check_dept_desc_Or_Id;
185: --
186: PROCEDURE Get_visit_task_Id

Line 195: p_workorder_id <> FND_API.G_MISS_NUM) THEN

191: ) IS
192:
193: BEGIN
194: IF (p_workorder_id IS NOT NULL AND
195: p_workorder_id <> FND_API.G_MISS_NUM) THEN
196:
197: SELECT visit_task_id INTO x_visit_task_id
198: FROM AHL_WORKORDERS
199: WHERE workorder_id = p_workorder_id;

Line 201: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

197: SELECT visit_task_id INTO x_visit_task_id
198: FROM AHL_WORKORDERS
199: WHERE workorder_id = p_workorder_id;
200: END IF;
201: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
202: IF G_DEBUG='Y' THEN
203: AHL_DEBUG_PUB.debug( 'XVISITTASK:'|| x_visit_task_id);
204: END IF;
205:

Line 208: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

204: END IF;
205:
206: EXCEPTION
207: WHEN NO_DATA_FOUND THEN
208: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
209: x_error_msg_code:= 'AHL_PP_TASK_ID_NOT_EXIST';
210: WHEN TOO_MANY_ROWS THEN
211: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
212: x_error_msg_code:= 'AHL_PP_TASK_ID_NOT_EXIST';

Line 211: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

207: WHEN NO_DATA_FOUND THEN
208: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
209: x_error_msg_code:= 'AHL_PP_TASK_ID_NOT_EXIST';
210: WHEN TOO_MANY_ROWS THEN
211: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
212: x_error_msg_code:= 'AHL_PP_TASK_ID_NOT_EXIST';
213: WHEN OTHERS THEN
214: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
215: RAISE;

Line 214: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;

210: WHEN TOO_MANY_ROWS THEN
211: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
212: x_error_msg_code:= 'AHL_PP_TASK_ID_NOT_EXIST';
213: WHEN OTHERS THEN
214: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
215: RAISE;
216: END Get_visit_task_Id;
217: --
218: PROCEDURE Get_workorder_Id

Line 240: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

236: FROM AHL_WORKORDERS
237: WHERE workorder_name = p_job_number;
238: END IF;
239:
240: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
241: IF G_DEBUG='Y' THEN
242: AHL_DEBUG_PUB.debug( 'XWOID:'|| x_workorder_id);
243: END IF;
244:

Line 247: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

243: END IF;
244:
245: EXCEPTION
246: WHEN NO_DATA_FOUND THEN
247: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
248: x_error_msg_code:= 'AHL_PP_WO_ID_NOT_EXIST';
249: WHEN TOO_MANY_ROWS THEN
250: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
251: x_error_msg_code:= 'AHL_PP_WO_ID_NOT_EXIST';

Line 250: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

246: WHEN NO_DATA_FOUND THEN
247: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
248: x_error_msg_code:= 'AHL_PP_WO_ID_NOT_EXIST';
249: WHEN TOO_MANY_ROWS THEN
250: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
251: x_error_msg_code:= 'AHL_PP_WO_ID_NOT_EXIST';
252: WHEN OTHERS THEN
253: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
254: RAISE;

Line 253: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;

249: WHEN TOO_MANY_ROWS THEN
250: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
251: x_error_msg_code:= 'AHL_PP_WO_ID_NOT_EXIST';
252: WHEN OTHERS THEN
253: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
254: RAISE;
255: END Get_workorder_Id;
256: --
257: PROCEDURE Get_workorder_operation_Id

Line 275: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

271: WHERE workorder_id = p_workorder_id
272: AND operation_sequence_num = p_operation_sequence;
273: --
274: END IF;
275: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
276:
277: EXCEPTION
278: WHEN NO_DATA_FOUND THEN
279: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

Line 279: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

275: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
276:
277: EXCEPTION
278: WHEN NO_DATA_FOUND THEN
279: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
280: x_error_msg_code:= 'AHL_PP_WO_OP_ID_NOT_EXIST';
281: WHEN TOO_MANY_ROWS THEN
282: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
283: x_error_msg_code:= 'AHL_PP_WO_OP_ID_NOT_EXIST';

Line 282: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

278: WHEN NO_DATA_FOUND THEN
279: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
280: x_error_msg_code:= 'AHL_PP_WO_OP_ID_NOT_EXIST';
281: WHEN TOO_MANY_ROWS THEN
282: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
283: x_error_msg_code:= 'AHL_PP_WO_OP_ID_NOT_EXIST';
284: WHEN OTHERS THEN
285: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
286: RAISE;

Line 285: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;

281: WHEN TOO_MANY_ROWS THEN
282: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
283: x_error_msg_code:= 'AHL_PP_WO_OP_ID_NOT_EXIST';
284: WHEN OTHERS THEN
285: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
286: RAISE;
287: END Get_workorder_operation_Id;
288: --
289: PROCEDURE Get_inventory_item_Id

Line 300: p_inventory_item_id <> FND_API.G_MISS_NUM) THEN

296: ) IS
297:
298: BEGIN
299: IF (p_inventory_item_id IS NOT NULL AND
300: p_inventory_item_id <> FND_API.G_MISS_NUM) THEN
301: --
302: SELECT inventory_item_id INTO x_inventory_item_id
303: FROM MTL_SYSTEM_ITEMS_KFV
304: WHERE inventory_item_id = p_inventory_item_id

Line 313: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

309: FROM MTL_SYSTEM_ITEMS_KFV
310: WHERE concatenated_segments = p_concatenated_segments
311: AND organization_id = p_organization_id;
312: END IF;
313: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
314:
315: EXCEPTION
316: WHEN NO_DATA_FOUND THEN
317: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

Line 317: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

313: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
314:
315: EXCEPTION
316: WHEN NO_DATA_FOUND THEN
317: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
318: x_error_msg_code:= 'AHL_PP_INV_ID_NOT_EXIST';
319: WHEN OTHERS THEN
320: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
321: RAISE;

Line 320: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;

316: WHEN NO_DATA_FOUND THEN
317: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
318: x_error_msg_code:= 'AHL_PP_INV_ID_NOT_EXIST';
319: WHEN OTHERS THEN
320: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
321: RAISE;
322: END Get_inventory_item_Id;
323: --
324: PROCEDURE Get_visit_task_details

Line 646: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

642: -- Parameters :
643: --
644: -- Standard IN Parameters :
645: -- p_api_version IN NUMBER Required
646: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
647: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
648: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
649: -- p_interface_flag IN VARCHAR2,
650: --

Line 647: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

643: --
644: -- Standard IN Parameters :
645: -- p_api_version IN NUMBER Required
646: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
647: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
648: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
649: -- p_interface_flag IN VARCHAR2,
650: --
651: -- Standard OUT Parameters :

Line 648: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

644: -- Standard IN Parameters :
645: -- p_api_version IN NUMBER Required
646: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
647: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
648: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
649: -- p_interface_flag IN VARCHAR2,
650: --
651: -- Standard OUT Parameters :
652: -- x_return_status OUT VARCHAR2 Required

Line 667: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

663: -- End of Comments.
664:
665: PROCEDURE Create_Material_Reqst (
666: p_api_version IN NUMBER,
667: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
668: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
669: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
670: p_interface_flag IN VARCHAR2 ,
671: p_x_req_material_tbl IN OUT NOCOPY Req_Material_Tbl_Type,

Line 668: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

664:
665: PROCEDURE Create_Material_Reqst (
666: p_api_version IN NUMBER,
667: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
668: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
669: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
670: p_interface_flag IN VARCHAR2 ,
671: p_x_req_material_tbl IN OUT NOCOPY Req_Material_Tbl_Type,
672: x_job_return_status OUT NOCOPY VARCHAR2,

Line 669: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,

665: PROCEDURE Create_Material_Reqst (
666: p_api_version IN NUMBER,
667: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
668: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
669: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
670: p_interface_flag IN VARCHAR2 ,
671: p_x_req_material_tbl IN OUT NOCOPY Req_Material_Tbl_Type,
672: x_job_return_status OUT NOCOPY VARCHAR2,
673: x_return_status OUT NOCOPY VARCHAR2,

Line 785: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

781: l_wip_entity_id NUMBER;
782: l_workorder_operation_id NUMBER;
783: l_wo_organization_id NUMBER;
784: l_object_version_number NUMBER;
785: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
786: l_Req_Material_Tbl Req_Material_Tbl_Type;
787: l_default VARCHAR2(30);
788: l_wo_operation_txn_id NUMBER;
789: l_schedule_start_date DATE;

Line 816: IF FND_API.to_boolean(l_init_msg_list)

812: AHL_DEBUG_PUB.debug( 'INTERAFCE FALG'||p_interface_flag);
813: AHL_DEBUG_PUB.debug( 'Total Number Records:'||p_x_req_material_tbl.COUNT);
814: END IF;
815: -- Standard call to check for call compatibility.
816: IF FND_API.to_boolean(l_init_msg_list)
817: THEN
818: FND_MSG_PUB.initialize;
819: END IF;
820: -- Initialize API return status to success

Line 821: x_return_status := FND_API.G_RET_STS_SUCCESS;

817: THEN
818: FND_MSG_PUB.initialize;
819: END IF;
820: -- Initialize API return status to success
821: x_return_status := FND_API.G_RET_STS_SUCCESS;
822: -- Initialize message list if p_init_msg_list is set to TRUE.
823: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
824: p_api_version,
825: l_api_name,G_PKG_NAME)

Line 823: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

819: END IF;
820: -- Initialize API return status to success
821: x_return_status := FND_API.G_RET_STS_SUCCESS;
822: -- Initialize message list if p_init_msg_list is set to TRUE.
823: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
824: p_api_version,
825: l_api_name,G_PKG_NAME)
826: THEN
827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

823: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
824: p_api_version,
825: l_api_name,G_PKG_NAME)
826: THEN
827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
828: END IF;
829:
830: --------------------Start of API Body-----------------------------------
831: IF p_x_req_material_tbl.COUNT > 0 THEN

Line 843: p_x_req_material_tbl(i).workorder_id <> FND_API.G_MISS_NUM ) OR

839:
840: END IF;
841:
842: IF ( ( p_x_req_material_tbl(i).workorder_id IS NOT NULL AND
843: p_x_req_material_tbl(i).workorder_id <> FND_API.G_MISS_NUM ) OR
844: ( p_x_req_material_tbl(i).job_number IS NOT NULL AND
845: p_x_req_material_tbl(i).job_number <> FND_API.G_MISS_CHAR ) )
846: THEN
847: --

Line 845: p_x_req_material_tbl(i).job_number <> FND_API.G_MISS_CHAR ) )

841:
842: IF ( ( p_x_req_material_tbl(i).workorder_id IS NOT NULL AND
843: p_x_req_material_tbl(i).workorder_id <> FND_API.G_MISS_NUM ) OR
844: ( p_x_req_material_tbl(i).job_number IS NOT NULL AND
845: p_x_req_material_tbl(i).job_number <> FND_API.G_MISS_CHAR ) )
846: THEN
847: --
848: IF G_DEBUG='Y' THEN
849: AHL_DEBUG_PUB.debug( 'WOID 2:'||p_x_req_material_tbl(i).workorder_id);

Line 881: IF l_return_status = FND_API.G_TRUE THEN

877: p_ue_id => NULL,
878: p_visit_id => NULL,
879: p_item_instance_id => NULL
880: );
881: IF l_return_status = FND_API.G_TRUE THEN
882: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_CRT_MTL_UNTLCKD');
883: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);
884: FND_MSG_PUB.ADD;
885: RAISE FND_API.G_EXC_ERROR;

Line 885: RAISE FND_API.G_EXC_ERROR;

881: IF l_return_status = FND_API.G_TRUE THEN
882: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_CRT_MTL_UNTLCKD');
883: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);
884: FND_MSG_PUB.ADD;
885: RAISE FND_API.G_EXC_ERROR;
886: END IF;
887:
888: -- rroy
889: -- ACL Changes

Line 894: p_x_req_material_tbl(i).workorder_id <> Fnd_Api.G_MISS_NUM )

890: --
891: p_x_req_material_tbl(i).workorder_id := nvl(p_x_req_material_tbl(i).workorder_id,l_workorder_id);
892: --Get visit task id
893: IF (p_x_req_material_tbl(i).workorder_id IS NOT NULL AND
894: p_x_req_material_tbl(i).workorder_id <> Fnd_Api.G_MISS_NUM )
895: THEN
896:
897: Get_visit_task_Id
898: (p_workorder_id => p_x_req_material_tbl(i).workorder_id,

Line 977: p_x_req_material_tbl(i).concatenated_segments <> Fnd_Api.G_MISS_CHAR ) OR

973: AHL_DEBUG_PUB.debug( 'CITEM:'||p_x_req_material_tbl(i).concatenated_segments);
974: END IF;
975: -- Convert concatenated segments to Item ID
976: IF (p_x_req_material_tbl(i).concatenated_segments IS NOT NULL AND
977: p_x_req_material_tbl(i).concatenated_segments <> Fnd_Api.G_MISS_CHAR ) OR
978: (p_x_req_material_tbl(i).inventory_item_id IS NOT NULL AND
979: p_x_req_material_tbl(i).inventory_item_id <> Fnd_Api.G_MISS_NUM) THEN
980:
981: Get_inventory_item_Id

Line 979: p_x_req_material_tbl(i).inventory_item_id <> Fnd_Api.G_MISS_NUM) THEN

975: -- Convert concatenated segments to Item ID
976: IF (p_x_req_material_tbl(i).concatenated_segments IS NOT NULL AND
977: p_x_req_material_tbl(i).concatenated_segments <> Fnd_Api.G_MISS_CHAR ) OR
978: (p_x_req_material_tbl(i).inventory_item_id IS NOT NULL AND
979: p_x_req_material_tbl(i).inventory_item_id <> Fnd_Api.G_MISS_NUM) THEN
980:
981: Get_inventory_item_Id
982: (p_inventory_item_id => p_x_req_material_tbl(i).inventory_item_id,
983: p_concatenated_segments => p_x_req_material_tbl(i).concatenated_segments,

Line 1008: p_x_req_material_tbl(i).requested_quantity = FND_API.G_MISS_NUM ) THEN

1004: END IF;
1005:
1006: -- Validate for Requested Quantity
1007: IF (p_x_req_material_tbl(i).requested_quantity IS NULL OR
1008: p_x_req_material_tbl(i).requested_quantity = FND_API.G_MISS_NUM ) THEN
1009: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_REQUIRED');
1010: Fnd_Msg_Pub.ADD;
1011: ELSIF (p_x_req_material_tbl(i).requested_quantity IS NOT NULL AND
1012: p_x_req_material_tbl(i).requested_quantity <> FND_API.G_MISS_NUM) THEN

Line 1012: p_x_req_material_tbl(i).requested_quantity <> FND_API.G_MISS_NUM) THEN

1008: p_x_req_material_tbl(i).requested_quantity = FND_API.G_MISS_NUM ) THEN
1009: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_REQUIRED');
1010: Fnd_Msg_Pub.ADD;
1011: ELSIF (p_x_req_material_tbl(i).requested_quantity IS NOT NULL AND
1012: p_x_req_material_tbl(i).requested_quantity <> FND_API.G_MISS_NUM) THEN
1013: -- Fix for FP bug# 6642084. -- Allow 0 quantity.
1014: IF p_x_req_material_tbl(i).requested_quantity < 0 THEN
1015: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_INVALID');
1016: Fnd_Msg_Pub.ADD;

Line 1029: p_x_req_material_tbl(i).requested_date = FND_API.G_MISS_DATE ) THEN

1025: IF (p_interface_flag = 'Y' OR p_interface_flag is null )THEN
1026:
1027: -- Validate for Requested Date
1028: IF (p_x_req_material_tbl(i).requested_date IS NULL OR
1029: p_x_req_material_tbl(i).requested_date = FND_API.G_MISS_DATE ) THEN
1030: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_REQUIRED');
1031: Fnd_Msg_Pub.ADD;
1032: ELSIF (p_x_req_material_tbl(i).requested_date IS NOT NULL AND
1033: p_x_req_material_tbl(i).requested_date <> FND_API.G_MISS_DATE) THEN

Line 1033: p_x_req_material_tbl(i).requested_date <> FND_API.G_MISS_DATE) THEN

1029: p_x_req_material_tbl(i).requested_date = FND_API.G_MISS_DATE ) THEN
1030: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_REQUIRED');
1031: Fnd_Msg_Pub.ADD;
1032: ELSIF (p_x_req_material_tbl(i).requested_date IS NOT NULL AND
1033: p_x_req_material_tbl(i).requested_date <> FND_API.G_MISS_DATE) THEN
1034: IF p_x_req_material_tbl(i).requested_date < trunc(SYSDATE) THEN
1035: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_GT_SYSD');
1036: Fnd_Msg_Pub.ADD;
1037: END IF;

Line 1047: p_x_req_material_tbl(i).operation_sequence = FND_API.G_MISS_NUM)

1043: AHL_DEBUG_PUB.debug( 'OSID'||p_x_req_material_tbl(i).operation_sequence);
1044: END IF;
1045: --Check for operation sequence
1046: IF( p_x_req_material_tbl(i).operation_sequence IS NULL OR
1047: p_x_req_material_tbl(i).operation_sequence = FND_API.G_MISS_NUM)
1048: THEN
1049: IF (p_x_req_material_tbl(i).workorder_operation_id IS NOT NULL AND
1050: p_x_req_material_tbl(i).workorder_operation_id <> FND_API.G_MISS_NUM)
1051: THEN

Line 1050: p_x_req_material_tbl(i).workorder_operation_id <> FND_API.G_MISS_NUM)

1046: IF( p_x_req_material_tbl(i).operation_sequence IS NULL OR
1047: p_x_req_material_tbl(i).operation_sequence = FND_API.G_MISS_NUM)
1048: THEN
1049: IF (p_x_req_material_tbl(i).workorder_operation_id IS NOT NULL AND
1050: p_x_req_material_tbl(i).workorder_operation_id <> FND_API.G_MISS_NUM)
1051: THEN
1052: --
1053: OPEN Get_Operation_Seq_cur(p_x_req_material_tbl(i).workorder_operation_id);
1054: FETCH Get_Operation_Seq_cur INTO p_x_req_material_tbl(i).operation_sequence;

Line 1074: p_x_req_material_tbl(i).workorder_operation_id = FND_API.G_MISS_NUM)

1070: END IF;
1071:
1072: --
1073: IF (p_x_req_material_tbl(i).workorder_operation_id IS NULL OR
1074: p_x_req_material_tbl(i).workorder_operation_id = FND_API.G_MISS_NUM)
1075: THEN
1076: -- Validate for workorder operation
1077: IF (p_x_req_material_tbl(i).operation_sequence IS NOT NULL AND
1078: p_x_req_material_tbl(i).operation_sequence <> FND_API.G_MISS_NUM) THEN

Line 1078: p_x_req_material_tbl(i).operation_sequence <> FND_API.G_MISS_NUM) THEN

1074: p_x_req_material_tbl(i).workorder_operation_id = FND_API.G_MISS_NUM)
1075: THEN
1076: -- Validate for workorder operation
1077: IF (p_x_req_material_tbl(i).operation_sequence IS NOT NULL AND
1078: p_x_req_material_tbl(i).operation_sequence <> FND_API.G_MISS_NUM) THEN
1079: --
1080: Get_workorder_operation_Id
1081: (p_workorder_id => p_x_req_material_tbl(i).workorder_id,
1082: p_operation_sequence => p_x_req_material_tbl(i).operation_sequence,

Line 1096: IF (p_x_req_material_tbl(i).workorder_operation_id <> FND_API.G_MISS_NUM OR

1092: END IF;
1093: END IF;
1094: END IF;
1095: -- Assigns operation id when called from UI
1096: IF (p_x_req_material_tbl(i).workorder_operation_id <> FND_API.G_MISS_NUM OR
1097: p_x_req_material_tbl(i).workorder_operation_id IS NULL )
1098: THEN
1099: --
1100: p_x_req_material_tbl(i).workorder_operation_id := NVL(p_x_req_material_tbl(i).workorder_operation_id,l_workorder_operation_id);

Line 1121: p_x_req_material_tbl(i).workorder_operation_id <> FND_API.G_MISS_NUM

1117: -- Check added by balaji for bug # 4093650
1118: -- When workorder_operation_id is null or g_miss then date check should not
1119: -- be performed.
1120: p_x_req_material_tbl(i).workorder_operation_id IS NOT NULL AND
1121: p_x_req_material_tbl(i).workorder_operation_id <> FND_API.G_MISS_NUM
1122: )
1123: )
1124: THEN
1125: --Check for requested date should be in schedule start date schedule end date

Line 1172: IF (p_x_req_material_tbl(i).UOM_MEANING IS NOT NULL AND p_x_req_material_tbl(i).UOM_MEANING <> FND_API.G_MISS_CHAR)

1168: -- dbms_output.put_line( 'before uom conversion:'||p_x_req_material_tbl(i).organization_id);
1169: -- dbms_output.put_line( 'before uom WO:'||p_x_req_material_tbl(i).workorder_id);
1170:
1171: -- Convert Uom code
1172: IF (p_x_req_material_tbl(i).UOM_MEANING IS NOT NULL AND p_x_req_material_tbl(i).UOM_MEANING <> FND_API.G_MISS_CHAR)
1173: THEN
1174: --
1175: OPEN Uom_cur(p_x_req_material_tbl(i).UOM_MEANING);
1176: FETCH Uom_cur INTO p_x_req_material_tbl(i).UOM_CODE;

Line 1203: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1199: -- Standard call to get message count and if count is get message info.
1200: l_msg_count := FND_MSG_PUB.count_msg;
1201: IF l_msg_count > 0 THEN
1202: X_msg_count := l_msg_count;
1203: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1204: RAISE FND_API.G_EXC_ERROR;
1205: END IF;
1206: END LOOP;
1207: END IF;

Line 1204: RAISE FND_API.G_EXC_ERROR;

1200: l_msg_count := FND_MSG_PUB.count_msg;
1201: IF l_msg_count > 0 THEN
1202: X_msg_count := l_msg_count;
1203: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1204: RAISE FND_API.G_EXC_ERROR;
1205: END IF;
1206: END LOOP;
1207: END IF;
1208:

Line 1320: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1316: --
1317: IF l_msg_count > 0 THEN
1318: X_msg_count := l_msg_count;
1319: X_msg_data := l_msg_data;
1320: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1321: RAISE FND_API.G_EXC_ERROR;
1322: END IF;
1323:
1324: END IF;

Line 1321: RAISE FND_API.G_EXC_ERROR;

1317: IF l_msg_count > 0 THEN
1318: X_msg_count := l_msg_count;
1319: X_msg_data := l_msg_data;
1320: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1321: RAISE FND_API.G_EXC_ERROR;
1322: END IF;
1323:
1324: END IF;
1325: --

Line 1344: IF (p_x_req_material_tbl(i).schedule_material_id = FND_API.G_MISS_NUM OR

1340: --
1341: FOR i IN p_x_req_material_tbl.FIRST..p_x_req_material_tbl.LAST
1342: LOOP
1343: --
1344: IF (p_x_req_material_tbl(i).schedule_material_id = FND_API.G_MISS_NUM OR
1345: p_x_req_material_tbl(i).schedule_material_id IS NULL )
1346: THEN
1347: -- Thease conditions are required for optional fields
1348: IF p_x_req_material_tbl(i).visit_start_date = FND_API.G_MISS_DATE

Line 1348: IF p_x_req_material_tbl(i).visit_start_date = FND_API.G_MISS_DATE

1344: IF (p_x_req_material_tbl(i).schedule_material_id = FND_API.G_MISS_NUM OR
1345: p_x_req_material_tbl(i).schedule_material_id IS NULL )
1346: THEN
1347: -- Thease conditions are required for optional fields
1348: IF p_x_req_material_tbl(i).visit_start_date = FND_API.G_MISS_DATE
1349: THEN
1350: l_Req_Material_Tbl(i).visit_start_date := NULL;
1351: ELSE
1352: l_Req_Material_Tbl(i).visit_start_date := p_x_req_material_tbl(i).visit_start_date;

Line 1355: IF p_x_req_material_tbl(i).scheduled_date = FND_API.G_MISS_DATE

1351: ELSE
1352: l_Req_Material_Tbl(i).visit_start_date := p_x_req_material_tbl(i).visit_start_date;
1353: END IF;
1354: -- Scheduled Date
1355: IF p_x_req_material_tbl(i).scheduled_date = FND_API.G_MISS_DATE
1356: THEN
1357: l_Req_Material_Tbl(i).scheduled_date := NULL;
1358: ELSE
1359: l_Req_Material_Tbl(i).scheduled_date := p_x_req_material_tbl(i).scheduled_date;

Line 1362: IF p_x_req_material_tbl(i).request_id = FND_API.G_MISS_NUM

1358: ELSE
1359: l_Req_Material_Tbl(i).scheduled_date := p_x_req_material_tbl(i).scheduled_date;
1360: END IF;
1361: -- Request ID
1362: IF p_x_req_material_tbl(i).request_id = FND_API.G_MISS_NUM
1363: THEN
1364: l_Req_Material_Tbl(i).request_id := NULL;
1365: ELSE
1366: l_Req_Material_Tbl(i).request_id := p_x_req_material_tbl(i).request_id;

Line 1369: IF p_x_req_material_tbl(i).scheduled_quantity = FND_API.G_MISS_NUM

1365: ELSE
1366: l_Req_Material_Tbl(i).request_id := p_x_req_material_tbl(i).request_id;
1367: END IF;
1368: --Scheduled quantity
1369: IF p_x_req_material_tbl(i).scheduled_quantity = FND_API.G_MISS_NUM
1370: THEN
1371: l_Req_Material_Tbl(i).scheduled_quantity := NULL;
1372: ELSE
1373: l_Req_Material_Tbl(i).scheduled_quantity := p_x_req_material_tbl(i).scheduled_quantity;

Line 1376: IF p_x_req_material_tbl(i).operation_sequence = FND_API.G_MISS_NUM

1372: ELSE
1373: l_Req_Material_Tbl(i).scheduled_quantity := p_x_req_material_tbl(i).scheduled_quantity;
1374: END IF;
1375: -- Operation Sequence
1376: IF p_x_req_material_tbl(i).operation_sequence = FND_API.G_MISS_NUM
1377: THEN
1378: l_Req_Material_Tbl(i).operation_sequence := NULL;
1379: ELSE
1380: l_Req_Material_Tbl(i).operation_sequence := p_x_req_material_tbl(i).operation_sequence;

Line 1383: IF p_x_req_material_tbl(i).uom_code = FND_API.G_MISS_CHAR

1379: ELSE
1380: l_Req_Material_Tbl(i).operation_sequence := p_x_req_material_tbl(i).operation_sequence;
1381: END IF;
1382: -- UOM
1383: IF p_x_req_material_tbl(i).uom_code = FND_API.G_MISS_CHAR
1384: THEN
1385: l_Req_Material_Tbl(i).uom_code := NULL;
1386: ELSE
1387: l_Req_Material_Tbl(i).uom_code := p_x_req_material_tbl(i).uom_code;

Line 1390: IF p_x_req_material_tbl(i).status = FND_API.G_MISS_CHAR

1386: ELSE
1387: l_Req_Material_Tbl(i).uom_code := p_x_req_material_tbl(i).uom_code;
1388: END IF;
1389: -- Status
1390: IF p_x_req_material_tbl(i).status = FND_API.G_MISS_CHAR
1391: THEN
1392: l_Req_Material_Tbl(i).status := NULL;
1393: ELSE
1394: l_Req_Material_Tbl(i).status := p_x_req_material_tbl(i).status;

Line 1397: IF p_x_req_material_tbl(i).operation_code = FND_API.G_MISS_CHAR

1393: ELSE
1394: l_Req_Material_Tbl(i).status := p_x_req_material_tbl(i).status;
1395: END IF;
1396: -- Operation code
1397: IF p_x_req_material_tbl(i).operation_code = FND_API.G_MISS_CHAR
1398: THEN
1399: l_Req_Material_Tbl(i).operation_code := NULL;
1400: ELSE
1401: l_Req_Material_Tbl(i).operation_code := p_x_req_material_tbl(i).operation_code;

Line 1404: IF p_x_req_material_tbl(i).transaction_id = FND_API.G_MISS_NUM

1400: ELSE
1401: l_Req_Material_Tbl(i).operation_code := p_x_req_material_tbl(i).operation_code;
1402: END IF;
1403: -- Transaction ID
1404: IF p_x_req_material_tbl(i).transaction_id = FND_API.G_MISS_NUM
1405: THEN
1406: l_Req_Material_Tbl(i).transaction_id := NULL;
1407: ELSE
1408: l_Req_Material_Tbl(i).transaction_id := p_x_req_material_tbl(i).transaction_id;

Line 1411: IF p_x_req_material_tbl(i).rt_oper_material_id = FND_API.G_MISS_NUM

1407: ELSE
1408: l_Req_Material_Tbl(i).transaction_id := p_x_req_material_tbl(i).transaction_id;
1409: END IF;
1410: -- Rt Oper Material ID
1411: IF p_x_req_material_tbl(i).rt_oper_material_id = FND_API.G_MISS_NUM
1412: THEN
1413: l_Req_Material_Tbl(i).rt_oper_material_id := NULL;
1414: ELSE
1415: l_Req_Material_Tbl(i).rt_oper_material_id := p_x_req_material_tbl(i).rt_oper_material_id;

Line 1418: IF p_x_req_material_tbl(i).program_id = FND_API.G_MISS_NUM

1414: ELSE
1415: l_Req_Material_Tbl(i).rt_oper_material_id := p_x_req_material_tbl(i).rt_oper_material_id;
1416: END IF;
1417: -- Program ID
1418: IF p_x_req_material_tbl(i).program_id = FND_API.G_MISS_NUM
1419: THEN
1420: l_Req_Material_Tbl(i).program_id := NULL;
1421: ELSE
1422: l_Req_Material_Tbl(i).program_id := p_x_req_material_tbl(i).program_id;

Line 1425: IF p_x_req_material_tbl(i).item_group_id = FND_API.G_MISS_NUM

1421: ELSE
1422: l_Req_Material_Tbl(i).program_id := p_x_req_material_tbl(i).program_id;
1423: END IF;
1424: -- Item group ID
1425: IF p_x_req_material_tbl(i).item_group_id = FND_API.G_MISS_NUM
1426: THEN
1427: l_Req_Material_Tbl(i).item_group_id := NULL;
1428: ELSE
1429: l_Req_Material_Tbl(i).item_group_id := p_x_req_material_tbl(i).item_group_id;

Line 1432: IF p_x_req_material_tbl(i).program_update_date = FND_API.G_MISS_DATE

1428: ELSE
1429: l_Req_Material_Tbl(i).item_group_id := p_x_req_material_tbl(i).item_group_id;
1430: END IF;
1431: -- Program Update Date
1432: IF p_x_req_material_tbl(i).program_update_date = FND_API.G_MISS_DATE
1433: THEN
1434: l_Req_Material_Tbl(i).program_update_date := NULL;
1435: ELSE
1436: l_Req_Material_Tbl(i).program_update_date := p_x_req_material_tbl(i).program_update_date;

Line 1439: IF p_x_req_material_tbl(i).last_updated_date = FND_API.G_MISS_DATE

1435: ELSE
1436: l_Req_Material_Tbl(i).program_update_date := p_x_req_material_tbl(i).program_update_date;
1437: END IF;
1438: -- Last Updated Date
1439: IF p_x_req_material_tbl(i).last_updated_date = FND_API.G_MISS_DATE
1440: THEN
1441: l_Req_Material_Tbl(i).last_updated_date := NULL;
1442: ELSE
1443: l_Req_Material_Tbl(i).last_updated_date := p_x_req_material_tbl(i).last_updated_date;

Line 1459: IF p_x_req_material_tbl(i).attribute_category = FND_API.G_MISS_CHAR

1455: IF G_DEBUG='Y' THEN
1456: AHL_DEBUG_PUB.debug('dff_default_values have been fetched');
1457: END IF;
1458: -- Attribte Category
1459: IF p_x_req_material_tbl(i).attribute_category = FND_API.G_MISS_CHAR
1460: THEN
1461: l_Req_Material_Tbl(i).attribute_category := NULL;
1462: ELSIF p_x_req_material_tbl(i).attribute_category IS NULL THEN
1463: l_Req_Material_Tbl(i).attribute_category := dff_default_values.attribute_category;

Line 1468: IF p_x_req_material_tbl(i).attribute1 = FND_API.G_MISS_CHAR

1464: ELSE
1465: l_Req_Material_Tbl(i).attribute_category := p_x_req_material_tbl(i).attribute_category;
1466: END IF;
1467: -- Attribte1
1468: IF p_x_req_material_tbl(i).attribute1 = FND_API.G_MISS_CHAR
1469: THEN
1470: l_Req_Material_Tbl(i).attribute1 := NULL;
1471: ELSIF p_x_req_material_tbl(i).attribute1 IS NULL THEN
1472: l_Req_Material_Tbl(i).attribute1 := dff_default_values.attribute1;

Line 1477: IF p_x_req_material_tbl(i).attribute2 = FND_API.G_MISS_CHAR

1473: ELSE
1474: l_Req_Material_Tbl(i).attribute1 := p_x_req_material_tbl(i).attribute1;
1475: END IF;
1476: -- Attribte2
1477: IF p_x_req_material_tbl(i).attribute2 = FND_API.G_MISS_CHAR
1478: THEN
1479: l_Req_Material_Tbl(i).attribute2 := NULL;
1480: ELSIF p_x_req_material_tbl(i).attribute2 IS NULL THEN
1481: l_Req_Material_Tbl(i).attribute1 := dff_default_values.attribute2;

Line 1486: IF p_x_req_material_tbl(i).attribute3 = FND_API.G_MISS_CHAR

1482: ELSE
1483: l_Req_Material_Tbl(i).attribute2 := p_x_req_material_tbl(i).attribute2;
1484: END IF;
1485: -- Attribte3
1486: IF p_x_req_material_tbl(i).attribute3 = FND_API.G_MISS_CHAR
1487: THEN
1488: l_Req_Material_Tbl(i).attribute3 := NULL;
1489: ELSIF p_x_req_material_tbl(i).attribute3 IS NULL THEN
1490: l_Req_Material_Tbl(i).attribute1 := dff_default_values.attribute3;

Line 1495: IF p_x_req_material_tbl(i).attribute4 = FND_API.G_MISS_CHAR

1491: ELSE
1492: l_Req_Material_Tbl(i).attribute3 := p_x_req_material_tbl(i).attribute3;
1493: END IF;
1494: -- Attribte4
1495: IF p_x_req_material_tbl(i).attribute4 = FND_API.G_MISS_CHAR
1496: THEN
1497: l_Req_Material_Tbl(i).attribute4 := NULL;
1498: ELSIF p_x_req_material_tbl(i).attribute4 IS NULL THEN
1499: l_Req_Material_Tbl(i).attribute1 := dff_default_values.attribute4;

Line 1504: IF p_x_req_material_tbl(i).attribute5 = FND_API.G_MISS_CHAR

1500: ELSE
1501: l_Req_Material_Tbl(i).attribute4 := p_x_req_material_tbl(i).attribute4;
1502: END IF;
1503: -- Attribte5
1504: IF p_x_req_material_tbl(i).attribute5 = FND_API.G_MISS_CHAR
1505: THEN
1506: l_Req_Material_Tbl(i).attribute5 := NULL;
1507: ELSIF p_x_req_material_tbl(i).attribute5 IS NULL THEN
1508: l_Req_Material_Tbl(i).attribute1 := dff_default_values.attribute5;

Line 1513: IF p_x_req_material_tbl(i).attribute6 = FND_API.G_MISS_CHAR

1509: ELSE
1510: l_Req_Material_Tbl(i).attribute5 := p_x_req_material_tbl(i).attribute5;
1511: END IF;
1512: -- Attribte6
1513: IF p_x_req_material_tbl(i).attribute6 = FND_API.G_MISS_CHAR
1514: THEN
1515: l_Req_Material_Tbl(i).attribute6 := NULL;
1516: ELSIF p_x_req_material_tbl(i).attribute6 IS NULL THEN
1517: l_Req_Material_Tbl(i).attribute1 := dff_default_values.attribute6;

Line 1522: IF p_x_req_material_tbl(i).attribute7 = FND_API.G_MISS_CHAR

1518: ELSE
1519: l_Req_Material_Tbl(i).attribute6 := p_x_req_material_tbl(i).attribute6;
1520: END IF;
1521: -- Attribte7
1522: IF p_x_req_material_tbl(i).attribute7 = FND_API.G_MISS_CHAR
1523: THEN
1524: l_Req_Material_Tbl(i).attribute7 := NULL;
1525: ELSIF p_x_req_material_tbl(i).attribute7 IS NULL THEN
1526: l_Req_Material_Tbl(i).attribute1 := dff_default_values.attribute7;

Line 1531: IF p_x_req_material_tbl(i).attribute8 = FND_API.G_MISS_CHAR

1527: ELSE
1528: l_Req_Material_Tbl(i).attribute7 := p_x_req_material_tbl(i).attribute7;
1529: END IF;
1530: -- Attribte8
1531: IF p_x_req_material_tbl(i).attribute8 = FND_API.G_MISS_CHAR
1532: THEN
1533: l_Req_Material_Tbl(i).attribute8 := NULL;
1534: ELSIF p_x_req_material_tbl(i).attribute8 IS NULL THEN
1535: l_Req_Material_Tbl(i).attribute1 := dff_default_values.attribute8;

Line 1540: IF p_x_req_material_tbl(i).attribute9 = FND_API.G_MISS_CHAR

1536: ELSE
1537: l_Req_Material_Tbl(i).attribute8 := p_x_req_material_tbl(i).attribute8;
1538: END IF;
1539: -- Attribte9
1540: IF p_x_req_material_tbl(i).attribute9 = FND_API.G_MISS_CHAR
1541: THEN
1542: l_Req_Material_Tbl(i).attribute9 := NULL;
1543: ELSIF p_x_req_material_tbl(i).attribute9 IS NULL THEN
1544: l_Req_Material_Tbl(i).attribute1 := dff_default_values.attribute9;

Line 1549: IF p_x_req_material_tbl(i).attribute10 = FND_API.G_MISS_CHAR

1545: ELSE
1546: l_Req_Material_Tbl(i).attribute9 := p_x_req_material_tbl(i).attribute9;
1547: END IF;
1548: -- Attribte10
1549: IF p_x_req_material_tbl(i).attribute10 = FND_API.G_MISS_CHAR
1550: THEN
1551: l_Req_Material_Tbl(i).attribute10 := NULL;
1552: ELSIF p_x_req_material_tbl(i).attribute10 IS NULL THEN
1553: l_Req_Material_Tbl(i).attribute1 := dff_default_values.attribute10;

Line 1558: IF p_x_req_material_tbl(i).attribute11 = FND_API.G_MISS_CHAR

1554: ELSE
1555: l_Req_Material_Tbl(i).attribute10 := p_x_req_material_tbl(i).attribute10;
1556: END IF;
1557: -- Attribte11
1558: IF p_x_req_material_tbl(i).attribute11 = FND_API.G_MISS_CHAR
1559: THEN
1560: l_Req_Material_Tbl(i).attribute11 := NULL;
1561: ELSIF p_x_req_material_tbl(i).attribute11 IS NULL THEN
1562: l_Req_Material_Tbl(i).attribute1 := dff_default_values.attribute11;

Line 1567: IF p_x_req_material_tbl(i).attribute12 = FND_API.G_MISS_CHAR

1563: ELSE
1564: l_Req_Material_Tbl(i).attribute11 := p_x_req_material_tbl(i).attribute11;
1565: END IF;
1566: -- Attribte12
1567: IF p_x_req_material_tbl(i).attribute12 = FND_API.G_MISS_CHAR
1568: THEN
1569: l_Req_Material_Tbl(i).attribute12 := NULL;
1570: ELSIF p_x_req_material_tbl(i).attribute12 IS NULL THEN
1571: l_Req_Material_Tbl(i).attribute1 := dff_default_values.attribute12;

Line 1576: IF p_x_req_material_tbl(i).attribute13 = FND_API.G_MISS_CHAR

1572: ELSE
1573: l_Req_Material_Tbl(i).attribute12 := p_x_req_material_tbl(i).attribute12;
1574: END IF;
1575: -- Attribte13
1576: IF p_x_req_material_tbl(i).attribute13 = FND_API.G_MISS_CHAR
1577: THEN
1578: l_Req_Material_Tbl(i).attribute13 := NULL;
1579: ELSIF p_x_req_material_tbl(i).attribute13 IS NULL THEN
1580: l_Req_Material_Tbl(i).attribute1 := dff_default_values.attribute13;

Line 1585: IF p_x_req_material_tbl(i).attribute14 = FND_API.G_MISS_CHAR

1581: ELSE
1582: l_Req_Material_Tbl(i).attribute13 := p_x_req_material_tbl(i).attribute13;
1583: END IF;
1584: -- Attribte14
1585: IF p_x_req_material_tbl(i).attribute14 = FND_API.G_MISS_CHAR
1586: THEN
1587: l_Req_Material_Tbl(i).attribute14 := NULL;
1588: ELSIF p_x_req_material_tbl(i).attribute14 IS NULL THEN
1589: l_Req_Material_Tbl(i).attribute1 := dff_default_values.attribute14;

Line 1594: IF p_x_req_material_tbl(i).attribute15 = FND_API.G_MISS_CHAR

1590: ELSE
1591: l_Req_Material_Tbl(i).attribute14 := p_x_req_material_tbl(i).attribute14;
1592: END IF;
1593: -- Attribte15
1594: IF p_x_req_material_tbl(i).attribute15 = FND_API.G_MISS_CHAR
1595: THEN
1596: l_Req_Material_Tbl(i).attribute15 := NULL;
1597: ELSIF p_x_req_material_tbl(i).attribute15 IS NULL THEN
1598: l_Req_Material_Tbl(i).attribute1 := dff_default_values.attribute15;

Line 1623: p_x_req_material_tbl(i).rt_oper_material_id <> FND_API.G_MISS_NUM)

1619: AHL_DEBUG_PUB.debug( 'FLAG=N VTID:'||p_x_req_material_tbl(i).visit_task_id);
1620: AHL_DEBUG_PUB.debug( 'FLAG=N ITID:'||p_x_req_material_tbl(i).inventory_item_id);
1621: END IF;
1622: IF (p_x_req_material_tbl(i).rt_oper_material_id IS NOT NULL AND
1623: p_x_req_material_tbl(i).rt_oper_material_id <> FND_API.G_MISS_NUM)
1624: THEN
1625: --
1626: OPEN Get_rt_mat_cur (p_x_req_material_tbl(i).visit_task_id,
1627: p_x_req_material_tbl(i).rt_oper_material_id);

Line 1904: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1900: X_return_status := 'S';
1901: x_job_return_status := 'S';
1902: ELSE
1903: x_job_return_status := 'E';
1904: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1905: RAISE Fnd_Api.G_EXC_ERROR;
1906: END IF; --status condition
1907: --Call notification API
1908: --Send Material Notification

Line 1905: RAISE Fnd_Api.G_EXC_ERROR;

1901: x_job_return_status := 'S';
1902: ELSE
1903: x_job_return_status := 'E';
1904: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1905: RAISE Fnd_Api.G_EXC_ERROR;
1906: END IF; --status condition
1907: --Call notification API
1908: --Send Material Notification
1909: IF X_return_status = 'S' THEN

Line 1933: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1929: l_msg_count := Fnd_Msg_Pub.count_msg;
1930:
1931: IF l_msg_count > 0 THEN
1932: X_msg_count := l_msg_count;
1933: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1934: RAISE Fnd_Api.G_EXC_ERROR;
1935: END IF;
1936:
1937: --Standard check for commit

Line 1934: RAISE Fnd_Api.G_EXC_ERROR;

1930:
1931: IF l_msg_count > 0 THEN
1932: X_msg_count := l_msg_count;
1933: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1934: RAISE Fnd_Api.G_EXC_ERROR;
1935: END IF;
1936:
1937: --Standard check for commit
1938: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

Line 1938: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

1934: RAISE Fnd_Api.G_EXC_ERROR;
1935: END IF;
1936:
1937: --Standard check for commit
1938: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1939: COMMIT;
1940: END IF;
1941: -- Debug info
1942: IF G_DEBUG='Y' THEN

Line 1949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1945: Ahl_Debug_Pub.disable_debug;
1946: END IF;
1947:
1948: EXCEPTION
1949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1950: ROLLBACK TO create_material_reqst;
1951: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1952: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1953: p_count => x_msg_count,

Line 1951: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1947:
1948: EXCEPTION
1949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1950: ROLLBACK TO create_material_reqst;
1951: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1952: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1953: p_count => x_msg_count,
1954: p_data => x_msg_data);
1955: IF G_DEBUG='Y' THEN

Line 1952: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1948: EXCEPTION
1949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1950: ROLLBACK TO create_material_reqst;
1951: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1952: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1953: p_count => x_msg_count,
1954: p_data => x_msg_data);
1955: IF G_DEBUG='Y' THEN
1956: AHL_DEBUG_PUB.log_app_messages (

Line 1963: WHEN FND_API.G_EXC_ERROR THEN

1959: -- Check if API is called in debug mode. If yes, disable debug.
1960: AHL_DEBUG_PUB.disable_debug;
1961: END IF;
1962:
1963: WHEN FND_API.G_EXC_ERROR THEN
1964: ROLLBACK TO create_material_reqst;
1965: X_return_status := FND_API.G_RET_STS_ERROR;
1966: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1967: p_count => x_msg_count,

Line 1965: X_return_status := FND_API.G_RET_STS_ERROR;

1961: END IF;
1962:
1963: WHEN FND_API.G_EXC_ERROR THEN
1964: ROLLBACK TO create_material_reqst;
1965: X_return_status := FND_API.G_RET_STS_ERROR;
1966: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1967: p_count => x_msg_count,
1968: p_data => X_msg_data);
1969: IF G_DEBUG='Y' THEN

Line 1966: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1962:
1963: WHEN FND_API.G_EXC_ERROR THEN
1964: ROLLBACK TO create_material_reqst;
1965: X_return_status := FND_API.G_RET_STS_ERROR;
1966: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1967: p_count => x_msg_count,
1968: p_data => X_msg_data);
1969: IF G_DEBUG='Y' THEN
1970: -- Debug info.

Line 1979: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1975: AHL_DEBUG_PUB.disable_debug;
1976: END IF;
1977: WHEN OTHERS THEN
1978: ROLLBACK TO create_material_reqst;
1979: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1980: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1981: THEN
1982: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',
1983: p_procedure_name => 'CREATE_MATERIAL_REQST',

Line 1986: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1982: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',
1983: p_procedure_name => 'CREATE_MATERIAL_REQST',
1984: p_error_text => SUBSTR(SQLERRM,1,240));
1985: END IF;
1986: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1987: p_count => x_msg_count,
1988: p_data => X_msg_data);
1989: IF G_DEBUG='Y' THEN
1990: -- Debug info.

Line 2009: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

2005: -- Parameters :
2006: --
2007: -- Standard IN Parameters :
2008: -- p_api_version IN NUMBER Required
2009: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2010: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2011: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2012: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
2013: -- p_module_type IN VARCHAR2 Default NULL.

Line 2010: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

2006: --
2007: -- Standard IN Parameters :
2008: -- p_api_version IN NUMBER Required
2009: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2010: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2011: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2012: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
2013: -- p_module_type IN VARCHAR2 Default NULL.
2014: --

Line 2011: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

2007: -- Standard IN Parameters :
2008: -- p_api_version IN NUMBER Required
2009: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2010: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2011: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2012: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
2013: -- p_module_type IN VARCHAR2 Default NULL.
2014: --
2015: -- Standard OUT Parameters :

Line 2012: -- p_default IN VARCHAR2 Default FND_API.G_TRUE

2008: -- p_api_version IN NUMBER Required
2009: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2010: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2011: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2012: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
2013: -- p_module_type IN VARCHAR2 Default NULL.
2014: --
2015: -- Standard OUT Parameters :
2016: -- x_return_status OUT VARCHAR2 Required

Line 2031: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

2027: -- End of Comments.
2028:
2029: PROCEDURE Update_Material_Reqst (
2030: p_api_version IN NUMBER,
2031: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
2032: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
2033: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
2034: p_module_type IN VARCHAR2 := NULL,
2035: p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,

Line 2032: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

2028:
2029: PROCEDURE Update_Material_Reqst (
2030: p_api_version IN NUMBER,
2031: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
2032: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
2033: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
2034: p_module_type IN VARCHAR2 := NULL,
2035: p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,
2036: x_return_status OUT NOCOPY VARCHAR2,

Line 2033: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,

2029: PROCEDURE Update_Material_Reqst (
2030: p_api_version IN NUMBER,
2031: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
2032: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
2033: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
2034: p_module_type IN VARCHAR2 := NULL,
2035: p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,
2036: x_return_status OUT NOCOPY VARCHAR2,
2037: x_msg_count OUT NOCOPY NUMBER,

Line 2179: IF FND_API.to_boolean(p_init_msg_list)

2175: -- Debug info.
2176: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. update material reqst','+PPMRP+');
2177: END IF;
2178: -- Standard call to check for call compatibility.
2179: IF FND_API.to_boolean(p_init_msg_list)
2180: THEN
2181: FND_MSG_PUB.initialize;
2182: END IF;
2183: -- Initialize API return status to success

Line 2184: x_return_status := FND_API.G_RET_STS_SUCCESS;

2180: THEN
2181: FND_MSG_PUB.initialize;
2182: END IF;
2183: -- Initialize API return status to success
2184: x_return_status := FND_API.G_RET_STS_SUCCESS;
2185: -- Initialize message list if p_init_msg_list is set to TRUE.
2186: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
2187: p_api_version,
2188: l_api_name,G_PKG_NAME)

Line 2186: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

2182: END IF;
2183: -- Initialize API return status to success
2184: x_return_status := FND_API.G_RET_STS_SUCCESS;
2185: -- Initialize message list if p_init_msg_list is set to TRUE.
2186: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
2187: p_api_version,
2188: l_api_name,G_PKG_NAME)
2189: THEN
2190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2186: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
2187: p_api_version,
2188: l_api_name,G_PKG_NAME)
2189: THEN
2190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2191: END IF;
2192: --------------------Start of API Body-----------------------------------
2193: IF p_x_req_material_tbl.COUNT > 0 THEN
2194: FOR i IN p_x_req_material_tbl.FIRST..p_x_req_material_tbl.LAST

Line 2199: p_x_req_material_tbl(i).workorder_id <> FND_API.G_MISS_NUM ) OR

2195: LOOP
2196: IF p_module_type <> 'API' THEN
2197: -- Value to ID Conversion
2198: IF ( ( p_x_req_material_tbl(i).workorder_id IS NOT NULL AND
2199: p_x_req_material_tbl(i).workorder_id <> FND_API.G_MISS_NUM ) OR
2200: ( p_x_req_material_tbl(i).job_number IS NOT NULL AND
2201: p_x_req_material_tbl(i).job_number <> FND_API.G_MISS_CHAR ) )
2202: THEN
2203: --

Line 2201: p_x_req_material_tbl(i).job_number <> FND_API.G_MISS_CHAR ) )

2197: -- Value to ID Conversion
2198: IF ( ( p_x_req_material_tbl(i).workorder_id IS NOT NULL AND
2199: p_x_req_material_tbl(i).workorder_id <> FND_API.G_MISS_NUM ) OR
2200: ( p_x_req_material_tbl(i).job_number IS NOT NULL AND
2201: p_x_req_material_tbl(i).job_number <> FND_API.G_MISS_CHAR ) )
2202: THEN
2203: --
2204: IF G_DEBUG='Y' THEN
2205: AHL_DEBUG_PUB.debug( 'WOID :'||p_x_req_material_tbl(i).workorder_id);

Line 2235: IF l_return_status = FND_API.G_TRUE THEN

2231: p_workorder_id => p_x_req_material_tbl(i).workorder_id,
2232: p_ue_id => NULL,
2233: p_visit_id => NULL,
2234: p_item_instance_id => NULL);
2235: IF l_return_status = FND_API.G_TRUE THEN
2236: OPEN get_job_number(p_x_req_material_tbl(i).workorder_id);
2237: FETCH get_job_number INTO l_workorder_name;
2238: CLOSE get_job_number;
2239: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_UPD_MTL_UNTLCKD');

Line 2242: RAISE FND_API.G_EXC_ERROR;

2238: CLOSE get_job_number;
2239: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_UPD_MTL_UNTLCKD');
2240: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);
2241: FND_MSG_PUB.ADD;
2242: RAISE FND_API.G_EXC_ERROR;
2243: END IF;
2244: -- rroy
2245: -- ACL Changes
2246:

Line 2274: p_x_req_material_tbl(i).requested_quantity = FND_API.G_MISS_NUM) THEN

2270: END IF;
2271:
2272: -- Validate for Requested Quantity
2273: IF (p_x_req_material_tbl(i).requested_quantity IS NULL OR
2274: p_x_req_material_tbl(i).requested_quantity = FND_API.G_MISS_NUM) THEN
2275: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_REQUIRED');
2276: Fnd_Msg_Pub.ADD;
2277: ELSIF (p_x_req_material_tbl(i).requested_quantity IS NOT NULL AND
2278: p_x_req_material_tbl(i).requested_quantity <> FND_API.G_MISS_NUM) THEN

Line 2278: p_x_req_material_tbl(i).requested_quantity <> FND_API.G_MISS_NUM) THEN

2274: p_x_req_material_tbl(i).requested_quantity = FND_API.G_MISS_NUM) THEN
2275: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_REQUIRED');
2276: Fnd_Msg_Pub.ADD;
2277: ELSIF (p_x_req_material_tbl(i).requested_quantity IS NOT NULL AND
2278: p_x_req_material_tbl(i).requested_quantity <> FND_API.G_MISS_NUM) THEN
2279: IF p_x_req_material_tbl(i).requested_quantity < 0 THEN
2280: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_INVALID');
2281: Fnd_Msg_Pub.ADD;
2282: END IF;

Line 2311: p_x_req_material_tbl(i).requested_date = FND_API.G_MISS_DATE) THEN

2307: END IF;
2308: IF p_module_type <> 'API' THEN
2309: -- Validate for Requested Date
2310: IF (p_x_req_material_tbl(i).requested_date IS NULL OR
2311: p_x_req_material_tbl(i).requested_date = FND_API.G_MISS_DATE) THEN
2312: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_REQUIRED');
2313: Fnd_Msg_Pub.ADD;
2314: ELSIF (p_x_req_material_tbl(i).requested_date IS NOT NULL AND
2315: p_x_req_material_tbl(i).requested_date <> FND_API.G_MISS_DATE) THEN

Line 2315: p_x_req_material_tbl(i).requested_date <> FND_API.G_MISS_DATE) THEN

2311: p_x_req_material_tbl(i).requested_date = FND_API.G_MISS_DATE) THEN
2312: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_REQUIRED');
2313: Fnd_Msg_Pub.ADD;
2314: ELSIF (p_x_req_material_tbl(i).requested_date IS NOT NULL AND
2315: p_x_req_material_tbl(i).requested_date <> FND_API.G_MISS_DATE) THEN
2316: IF p_x_req_material_tbl(i).requested_date < trunc(SYSDATE) THEN
2317: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_GT_EQ_SYSD');
2318: Fnd_Msg_Pub.ADD;
2319: END IF;

Line 2327: p_x_req_material_tbl(i).schedule_material_id = FND_API.G_MISS_NUM) THEN

2323: END IF;
2324:
2325: -- Validate for Schedule Material ID
2326: IF (p_x_req_material_tbl(i).schedule_material_id IS NULL AND
2327: p_x_req_material_tbl(i).schedule_material_id = FND_API.G_MISS_NUM) THEN
2328: Fnd_Message.SET_NAME('AHL','AHL_PP_SCH_MATRL_REQUIRED');
2329: Fnd_Msg_Pub.ADD;
2330: END IF;
2331: IF G_DEBUG='Y' THEN

Line 2356: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

2352: l_msg_count := Fnd_Msg_Pub.count_msg;
2353:
2354: IF l_msg_count > 0 THEN
2355: X_msg_count := l_msg_count;
2356: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2357: RAISE Fnd_Api.G_EXC_ERROR;
2358: END IF;
2359:
2360: END LOOP; --for loop

Line 2357: RAISE Fnd_Api.G_EXC_ERROR;

2353:
2354: IF l_msg_count > 0 THEN
2355: X_msg_count := l_msg_count;
2356: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2357: RAISE Fnd_Api.G_EXC_ERROR;
2358: END IF;
2359:
2360: END LOOP; --for loop
2361: END IF;

Line 2517: p_init_msg_list => FND_API.G_FALSE,

2513:
2514: -- call update reservations api.
2515: AHL_RSV_RESERVATIONS_PVT.Update_Reservation(
2516: p_api_version => 1.0,
2517: p_init_msg_list => FND_API.G_FALSE,
2518: p_commit => FND_API.G_FALSE,
2519: p_module_type => NULL,
2520: x_return_status => x_return_status,
2521: x_msg_count => x_msg_count,

Line 2518: p_commit => FND_API.G_FALSE,

2514: -- call update reservations api.
2515: AHL_RSV_RESERVATIONS_PVT.Update_Reservation(
2516: p_api_version => 1.0,
2517: p_init_msg_list => FND_API.G_FALSE,
2518: p_commit => FND_API.G_FALSE,
2519: p_module_type => NULL,
2520: x_return_status => x_return_status,
2521: x_msg_count => x_msg_count,
2522: x_msg_data => x_msg_data,

Line 2531: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2527: AHL_DEBUG_PUB.debug('After Call to Upd RSV- Return Status:' || x_return_status);
2528: END IF;
2529:
2530: -- Raise error if exceptions occur
2531: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2532: RAISE FND_API.G_EXC_ERROR;
2533: END IF;
2534:
2535: END IF; -- p_x_req_material_tbl(i).requested_date <>

Line 2532: RAISE FND_API.G_EXC_ERROR;

2528: END IF;
2529:
2530: -- Raise error if exceptions occur
2531: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2532: RAISE FND_API.G_EXC_ERROR;
2533: END IF;
2534:
2535: END IF; -- p_x_req_material_tbl(i).requested_date <>
2536: --

Line 2542: IF NVL(p_x_req_material_tbl(i).inventory_item_id, 0) <> FND_API.G_MISS_NUM

2538: --
2539: -- The following conditions compare the new record value with old record
2540: -- value, if its different then assign the new value else continue
2541:
2542: IF NVL(p_x_req_material_tbl(i).inventory_item_id, 0) <> FND_API.G_MISS_NUM
2543: THEN
2544: l_req_material_rec.inventory_item_id := p_x_req_material_tbl(i).inventory_item_id;
2545: END IF;
2546: --

Line 2547: IF NVL(p_x_req_material_tbl(i).requested_date,sysdate) <> FND_API.G_MISS_DATE

2543: THEN
2544: l_req_material_rec.inventory_item_id := p_x_req_material_tbl(i).inventory_item_id;
2545: END IF;
2546: --
2547: IF NVL(p_x_req_material_tbl(i).requested_date,sysdate) <> FND_API.G_MISS_DATE
2548: THEN
2549: l_req_material_rec.requested_date := p_x_req_material_tbl(i).requested_date;
2550: END IF;
2551: --

Line 2552: IF NVL(p_x_req_material_tbl(i).requested_quantity, 0) <> FND_API.G_MISS_NUM

2548: THEN
2549: l_req_material_rec.requested_date := p_x_req_material_tbl(i).requested_date;
2550: END IF;
2551: --
2552: IF NVL(p_x_req_material_tbl(i).requested_quantity, 0) <> FND_API.G_MISS_NUM
2553: THEN
2554: l_req_material_rec.requested_quantity := p_x_req_material_tbl(i).requested_quantity;
2555: END IF;
2556: --

Line 2557: IF NVL(p_x_req_material_tbl(i).organization_id, 0) <> FND_API.G_MISS_NUM

2553: THEN
2554: l_req_material_rec.requested_quantity := p_x_req_material_tbl(i).requested_quantity;
2555: END IF;
2556: --
2557: IF NVL(p_x_req_material_tbl(i).organization_id, 0) <> FND_API.G_MISS_NUM
2558: THEN
2559: l_req_material_rec.organization_id := p_x_req_material_tbl(i).organization_id;
2560: END IF;
2561: --

Line 2562: IF NVL(p_x_req_material_tbl(i).visit_id, 0) <> FND_API.G_MISS_NUM

2558: THEN
2559: l_req_material_rec.organization_id := p_x_req_material_tbl(i).organization_id;
2560: END IF;
2561: --
2562: IF NVL(p_x_req_material_tbl(i).visit_id, 0) <> FND_API.G_MISS_NUM
2563: THEN
2564: l_req_material_rec.visit_id := p_x_req_material_tbl(i).visit_id;
2565: END IF;
2566: --

Line 2567: IF NVL(p_x_req_material_tbl(i).visit_task_id, 0) <> FND_API.G_MISS_NUM

2563: THEN
2564: l_req_material_rec.visit_id := p_x_req_material_tbl(i).visit_id;
2565: END IF;
2566: --
2567: IF NVL(p_x_req_material_tbl(i).visit_task_id, 0) <> FND_API.G_MISS_NUM
2568: THEN
2569: l_req_material_rec.visit_task_id := p_x_req_material_tbl(i).visit_task_id;
2570: END IF;
2571: --

Line 2572: IF NVL(p_x_req_material_tbl(i).item_group_id, 0) <> FND_API.G_MISS_NUM

2568: THEN
2569: l_req_material_rec.visit_task_id := p_x_req_material_tbl(i).visit_task_id;
2570: END IF;
2571: --
2572: IF NVL(p_x_req_material_tbl(i).item_group_id, 0) <> FND_API.G_MISS_NUM
2573: THEN
2574: l_req_material_rec.item_group_id := p_x_req_material_tbl(i).item_group_id;
2575: END IF;
2576: --

Line 2577: IF NVL(p_x_req_material_tbl(i).rt_oper_material_id, 0) <> FND_API.G_MISS_NUM

2573: THEN
2574: l_req_material_rec.item_group_id := p_x_req_material_tbl(i).item_group_id;
2575: END IF;
2576: --
2577: IF NVL(p_x_req_material_tbl(i).rt_oper_material_id, 0) <> FND_API.G_MISS_NUM
2578: THEN
2579: l_req_material_rec.rt_oper_material_id := p_x_req_material_tbl(i).rt_oper_material_id;
2580: END IF;
2581:

Line 2584: p_x_req_material_tbl(i).attribute_category <> FND_API.G_MISS_CHAR

2580: END IF;
2581:
2582: --
2583: IF p_x_req_material_tbl(i).attribute_category IS NOT NULL AND
2584: p_x_req_material_tbl(i).attribute_category <> FND_API.G_MISS_CHAR
2585: THEN
2586: l_req_material_rec.attribute_category := p_x_req_material_tbl(i).attribute_category;
2587: ELSIF p_x_req_material_tbl(i).attribute_category = FND_API.G_MISS_CHAR THEN
2588: l_req_material_rec.attribute_category := NULL;

Line 2587: ELSIF p_x_req_material_tbl(i).attribute_category = FND_API.G_MISS_CHAR THEN

2583: IF p_x_req_material_tbl(i).attribute_category IS NOT NULL AND
2584: p_x_req_material_tbl(i).attribute_category <> FND_API.G_MISS_CHAR
2585: THEN
2586: l_req_material_rec.attribute_category := p_x_req_material_tbl(i).attribute_category;
2587: ELSIF p_x_req_material_tbl(i).attribute_category = FND_API.G_MISS_CHAR THEN
2588: l_req_material_rec.attribute_category := NULL;
2589: END IF;
2590: --
2591: IF p_x_req_material_tbl(i).attribute1 IS NOT NULL AND

Line 2592: p_x_req_material_tbl(i).attribute1 <> FND_API.G_MISS_CHAR

2588: l_req_material_rec.attribute_category := NULL;
2589: END IF;
2590: --
2591: IF p_x_req_material_tbl(i).attribute1 IS NOT NULL AND
2592: p_x_req_material_tbl(i).attribute1 <> FND_API.G_MISS_CHAR
2593: THEN
2594: l_req_material_rec.attribute1 := p_x_req_material_tbl(i).attribute1;
2595: ELSIF p_x_req_material_tbl(i).attribute1 = FND_API.G_MISS_CHAR THEN
2596: l_req_material_rec.attribute1 := NULL;

Line 2595: ELSIF p_x_req_material_tbl(i).attribute1 = FND_API.G_MISS_CHAR THEN

2591: IF p_x_req_material_tbl(i).attribute1 IS NOT NULL AND
2592: p_x_req_material_tbl(i).attribute1 <> FND_API.G_MISS_CHAR
2593: THEN
2594: l_req_material_rec.attribute1 := p_x_req_material_tbl(i).attribute1;
2595: ELSIF p_x_req_material_tbl(i).attribute1 = FND_API.G_MISS_CHAR THEN
2596: l_req_material_rec.attribute1 := NULL;
2597: END IF;
2598:
2599: --

Line 2601: p_x_req_material_tbl(i).attribute2 <> FND_API.G_MISS_CHAR

2597: END IF;
2598:
2599: --
2600: IF p_x_req_material_tbl(i).attribute2 IS NOT NULL AND
2601: p_x_req_material_tbl(i).attribute2 <> FND_API.G_MISS_CHAR
2602: THEN
2603: l_req_material_rec.attribute2 := p_x_req_material_tbl(i).attribute2;
2604: ELSIF p_x_req_material_tbl(i).attribute2 = FND_API.G_MISS_CHAR THEN
2605: l_req_material_rec.attribute2 := NULL;

Line 2604: ELSIF p_x_req_material_tbl(i).attribute2 = FND_API.G_MISS_CHAR THEN

2600: IF p_x_req_material_tbl(i).attribute2 IS NOT NULL AND
2601: p_x_req_material_tbl(i).attribute2 <> FND_API.G_MISS_CHAR
2602: THEN
2603: l_req_material_rec.attribute2 := p_x_req_material_tbl(i).attribute2;
2604: ELSIF p_x_req_material_tbl(i).attribute2 = FND_API.G_MISS_CHAR THEN
2605: l_req_material_rec.attribute2 := NULL;
2606: END IF;
2607: --
2608: IF p_x_req_material_tbl(i).attribute3 IS NOT NULL AND

Line 2609: p_x_req_material_tbl(i).attribute3 <> FND_API.G_MISS_CHAR

2605: l_req_material_rec.attribute2 := NULL;
2606: END IF;
2607: --
2608: IF p_x_req_material_tbl(i).attribute3 IS NOT NULL AND
2609: p_x_req_material_tbl(i).attribute3 <> FND_API.G_MISS_CHAR
2610: THEN
2611: l_req_material_rec.attribute3 := p_x_req_material_tbl(i).attribute3;
2612: ELSIF p_x_req_material_tbl(i).attribute3 = FND_API.G_MISS_CHAR THEN
2613: l_req_material_rec.attribute3 := NULL;

Line 2612: ELSIF p_x_req_material_tbl(i).attribute3 = FND_API.G_MISS_CHAR THEN

2608: IF p_x_req_material_tbl(i).attribute3 IS NOT NULL AND
2609: p_x_req_material_tbl(i).attribute3 <> FND_API.G_MISS_CHAR
2610: THEN
2611: l_req_material_rec.attribute3 := p_x_req_material_tbl(i).attribute3;
2612: ELSIF p_x_req_material_tbl(i).attribute3 = FND_API.G_MISS_CHAR THEN
2613: l_req_material_rec.attribute3 := NULL;
2614: END IF;
2615:
2616: --

Line 2618: p_x_req_material_tbl(i).attribute4 <> FND_API.G_MISS_CHAR

2614: END IF;
2615:
2616: --
2617: IF p_x_req_material_tbl(i).attribute4 IS NOT NULL AND
2618: p_x_req_material_tbl(i).attribute4 <> FND_API.G_MISS_CHAR
2619: THEN
2620: l_req_material_rec.attribute4 := p_x_req_material_tbl(i).attribute4;
2621: ELSIF p_x_req_material_tbl(i).attribute4 = FND_API.G_MISS_CHAR THEN
2622: l_req_material_rec.attribute4 := NULL;

Line 2621: ELSIF p_x_req_material_tbl(i).attribute4 = FND_API.G_MISS_CHAR THEN

2617: IF p_x_req_material_tbl(i).attribute4 IS NOT NULL AND
2618: p_x_req_material_tbl(i).attribute4 <> FND_API.G_MISS_CHAR
2619: THEN
2620: l_req_material_rec.attribute4 := p_x_req_material_tbl(i).attribute4;
2621: ELSIF p_x_req_material_tbl(i).attribute4 = FND_API.G_MISS_CHAR THEN
2622: l_req_material_rec.attribute4 := NULL;
2623: END IF;
2624:
2625: --

Line 2627: p_x_req_material_tbl(i).attribute5 <> FND_API.G_MISS_CHAR

2623: END IF;
2624:
2625: --
2626: IF p_x_req_material_tbl(i).attribute5 IS NOT NULL AND
2627: p_x_req_material_tbl(i).attribute5 <> FND_API.G_MISS_CHAR
2628: THEN
2629: l_req_material_rec.attribute5 := p_x_req_material_tbl(i).attribute5;
2630: ELSIF p_x_req_material_tbl(i).attribute5 = FND_API.G_MISS_CHAR THEN
2631: l_req_material_rec.attribute5 := NULL;

Line 2630: ELSIF p_x_req_material_tbl(i).attribute5 = FND_API.G_MISS_CHAR THEN

2626: IF p_x_req_material_tbl(i).attribute5 IS NOT NULL AND
2627: p_x_req_material_tbl(i).attribute5 <> FND_API.G_MISS_CHAR
2628: THEN
2629: l_req_material_rec.attribute5 := p_x_req_material_tbl(i).attribute5;
2630: ELSIF p_x_req_material_tbl(i).attribute5 = FND_API.G_MISS_CHAR THEN
2631: l_req_material_rec.attribute5 := NULL;
2632: END IF;
2633:
2634: --

Line 2636: p_x_req_material_tbl(i).attribute6 <> FND_API.G_MISS_CHAR

2632: END IF;
2633:
2634: --
2635: IF p_x_req_material_tbl(i).attribute6 IS NOT NULL AND
2636: p_x_req_material_tbl(i).attribute6 <> FND_API.G_MISS_CHAR
2637: THEN
2638: l_req_material_rec.attribute6 := p_x_req_material_tbl(i).attribute6;
2639: ELSIF p_x_req_material_tbl(i).attribute6 = FND_API.G_MISS_CHAR THEN
2640: l_req_material_rec.attribute6 := NULL;

Line 2639: ELSIF p_x_req_material_tbl(i).attribute6 = FND_API.G_MISS_CHAR THEN

2635: IF p_x_req_material_tbl(i).attribute6 IS NOT NULL AND
2636: p_x_req_material_tbl(i).attribute6 <> FND_API.G_MISS_CHAR
2637: THEN
2638: l_req_material_rec.attribute6 := p_x_req_material_tbl(i).attribute6;
2639: ELSIF p_x_req_material_tbl(i).attribute6 = FND_API.G_MISS_CHAR THEN
2640: l_req_material_rec.attribute6 := NULL;
2641: END IF;
2642:
2643: --

Line 2645: p_x_req_material_tbl(i).attribute7 <> FND_API.G_MISS_CHAR

2641: END IF;
2642:
2643: --
2644: IF p_x_req_material_tbl(i).attribute7 IS NOT NULL AND
2645: p_x_req_material_tbl(i).attribute7 <> FND_API.G_MISS_CHAR
2646: THEN
2647: l_req_material_rec.attribute7 := p_x_req_material_tbl(i).attribute7;
2648: ELSIF p_x_req_material_tbl(i).attribute7 = FND_API.G_MISS_CHAR THEN
2649: l_req_material_rec.attribute7 := NULL;

Line 2648: ELSIF p_x_req_material_tbl(i).attribute7 = FND_API.G_MISS_CHAR THEN

2644: IF p_x_req_material_tbl(i).attribute7 IS NOT NULL AND
2645: p_x_req_material_tbl(i).attribute7 <> FND_API.G_MISS_CHAR
2646: THEN
2647: l_req_material_rec.attribute7 := p_x_req_material_tbl(i).attribute7;
2648: ELSIF p_x_req_material_tbl(i).attribute7 = FND_API.G_MISS_CHAR THEN
2649: l_req_material_rec.attribute7 := NULL;
2650: END IF;
2651:
2652: --

Line 2654: p_x_req_material_tbl(i).attribute8 <> FND_API.G_MISS_CHAR

2650: END IF;
2651:
2652: --
2653: IF p_x_req_material_tbl(i).attribute8 IS NOT NULL AND
2654: p_x_req_material_tbl(i).attribute8 <> FND_API.G_MISS_CHAR
2655: THEN
2656: l_req_material_rec.attribute8 := p_x_req_material_tbl(i).attribute8;
2657: ELSIF p_x_req_material_tbl(i).attribute8 = FND_API.G_MISS_CHAR THEN
2658: l_req_material_rec.attribute8 := NULL;

Line 2657: ELSIF p_x_req_material_tbl(i).attribute8 = FND_API.G_MISS_CHAR THEN

2653: IF p_x_req_material_tbl(i).attribute8 IS NOT NULL AND
2654: p_x_req_material_tbl(i).attribute8 <> FND_API.G_MISS_CHAR
2655: THEN
2656: l_req_material_rec.attribute8 := p_x_req_material_tbl(i).attribute8;
2657: ELSIF p_x_req_material_tbl(i).attribute8 = FND_API.G_MISS_CHAR THEN
2658: l_req_material_rec.attribute8 := NULL;
2659: END IF;
2660:
2661: --

Line 2663: p_x_req_material_tbl(i).attribute9 <> FND_API.G_MISS_CHAR

2659: END IF;
2660:
2661: --
2662: IF p_x_req_material_tbl(i).attribute9 IS NOT NULL AND
2663: p_x_req_material_tbl(i).attribute9 <> FND_API.G_MISS_CHAR
2664: THEN
2665: l_req_material_rec.attribute9 := p_x_req_material_tbl(i).attribute9;
2666: ELSIF p_x_req_material_tbl(i).attribute9 = FND_API.G_MISS_CHAR THEN
2667: l_req_material_rec.attribute9 := NULL;

Line 2666: ELSIF p_x_req_material_tbl(i).attribute9 = FND_API.G_MISS_CHAR THEN

2662: IF p_x_req_material_tbl(i).attribute9 IS NOT NULL AND
2663: p_x_req_material_tbl(i).attribute9 <> FND_API.G_MISS_CHAR
2664: THEN
2665: l_req_material_rec.attribute9 := p_x_req_material_tbl(i).attribute9;
2666: ELSIF p_x_req_material_tbl(i).attribute9 = FND_API.G_MISS_CHAR THEN
2667: l_req_material_rec.attribute9 := NULL;
2668: END IF;
2669:
2670: --

Line 2672: p_x_req_material_tbl(i).attribute10 <> FND_API.G_MISS_CHAR

2668: END IF;
2669:
2670: --
2671: IF p_x_req_material_tbl(i).attribute10 IS NOT NULL AND
2672: p_x_req_material_tbl(i).attribute10 <> FND_API.G_MISS_CHAR
2673: THEN
2674: l_req_material_rec.attribute10 := p_x_req_material_tbl(i).attribute10;
2675: ELSIF p_x_req_material_tbl(i).attribute10 = FND_API.G_MISS_CHAR THEN
2676: l_req_material_rec.attribute10 := NULL;

Line 2675: ELSIF p_x_req_material_tbl(i).attribute10 = FND_API.G_MISS_CHAR THEN

2671: IF p_x_req_material_tbl(i).attribute10 IS NOT NULL AND
2672: p_x_req_material_tbl(i).attribute10 <> FND_API.G_MISS_CHAR
2673: THEN
2674: l_req_material_rec.attribute10 := p_x_req_material_tbl(i).attribute10;
2675: ELSIF p_x_req_material_tbl(i).attribute10 = FND_API.G_MISS_CHAR THEN
2676: l_req_material_rec.attribute10 := NULL;
2677: END IF;
2678:
2679: --

Line 2681: p_x_req_material_tbl(i).attribute11 <> FND_API.G_MISS_CHAR

2677: END IF;
2678:
2679: --
2680: IF p_x_req_material_tbl(i).attribute11 IS NOT NULL AND
2681: p_x_req_material_tbl(i).attribute11 <> FND_API.G_MISS_CHAR
2682: THEN
2683: l_req_material_rec.attribute11 := p_x_req_material_tbl(i).attribute11;
2684: ELSIF p_x_req_material_tbl(i).attribute11 = FND_API.G_MISS_CHAR THEN
2685: l_req_material_rec.attribute11 := NULL;

Line 2684: ELSIF p_x_req_material_tbl(i).attribute11 = FND_API.G_MISS_CHAR THEN

2680: IF p_x_req_material_tbl(i).attribute11 IS NOT NULL AND
2681: p_x_req_material_tbl(i).attribute11 <> FND_API.G_MISS_CHAR
2682: THEN
2683: l_req_material_rec.attribute11 := p_x_req_material_tbl(i).attribute11;
2684: ELSIF p_x_req_material_tbl(i).attribute11 = FND_API.G_MISS_CHAR THEN
2685: l_req_material_rec.attribute11 := NULL;
2686: END IF;
2687:
2688: --

Line 2690: p_x_req_material_tbl(i).attribute12 <> FND_API.G_MISS_CHAR

2686: END IF;
2687:
2688: --
2689: IF p_x_req_material_tbl(i).attribute12 IS NOT NULL AND
2690: p_x_req_material_tbl(i).attribute12 <> FND_API.G_MISS_CHAR
2691: THEN
2692: l_req_material_rec.attribute12 := p_x_req_material_tbl(i).attribute12;
2693: ELSIF p_x_req_material_tbl(i).attribute12 = FND_API.G_MISS_CHAR THEN
2694: l_req_material_rec.attribute12 := NULL;

Line 2693: ELSIF p_x_req_material_tbl(i).attribute12 = FND_API.G_MISS_CHAR THEN

2689: IF p_x_req_material_tbl(i).attribute12 IS NOT NULL AND
2690: p_x_req_material_tbl(i).attribute12 <> FND_API.G_MISS_CHAR
2691: THEN
2692: l_req_material_rec.attribute12 := p_x_req_material_tbl(i).attribute12;
2693: ELSIF p_x_req_material_tbl(i).attribute12 = FND_API.G_MISS_CHAR THEN
2694: l_req_material_rec.attribute12 := NULL;
2695: END IF;
2696:
2697: --

Line 2699: p_x_req_material_tbl(i).attribute13 <> FND_API.G_MISS_CHAR

2695: END IF;
2696:
2697: --
2698: IF p_x_req_material_tbl(i).attribute13 IS NOT NULL AND
2699: p_x_req_material_tbl(i).attribute13 <> FND_API.G_MISS_CHAR
2700: THEN
2701: l_req_material_rec.attribute13 := p_x_req_material_tbl(i).attribute13;
2702: ELSIF p_x_req_material_tbl(i).attribute13 = FND_API.G_MISS_CHAR THEN
2703: l_req_material_rec.attribute13 := NULL;

Line 2702: ELSIF p_x_req_material_tbl(i).attribute13 = FND_API.G_MISS_CHAR THEN

2698: IF p_x_req_material_tbl(i).attribute13 IS NOT NULL AND
2699: p_x_req_material_tbl(i).attribute13 <> FND_API.G_MISS_CHAR
2700: THEN
2701: l_req_material_rec.attribute13 := p_x_req_material_tbl(i).attribute13;
2702: ELSIF p_x_req_material_tbl(i).attribute13 = FND_API.G_MISS_CHAR THEN
2703: l_req_material_rec.attribute13 := NULL;
2704: END IF;
2705:
2706: --

Line 2708: p_x_req_material_tbl(i).attribute14 <> FND_API.G_MISS_CHAR

2704: END IF;
2705:
2706: --
2707: IF p_x_req_material_tbl(i).attribute14 IS NOT NULL AND
2708: p_x_req_material_tbl(i).attribute14 <> FND_API.G_MISS_CHAR
2709: THEN
2710: l_req_material_rec.attribute14 := p_x_req_material_tbl(i).attribute14;
2711: ELSIF p_x_req_material_tbl(i).attribute14 = FND_API.G_MISS_CHAR THEN
2712: l_req_material_rec.attribute14 := NULL;

Line 2711: ELSIF p_x_req_material_tbl(i).attribute14 = FND_API.G_MISS_CHAR THEN

2707: IF p_x_req_material_tbl(i).attribute14 IS NOT NULL AND
2708: p_x_req_material_tbl(i).attribute14 <> FND_API.G_MISS_CHAR
2709: THEN
2710: l_req_material_rec.attribute14 := p_x_req_material_tbl(i).attribute14;
2711: ELSIF p_x_req_material_tbl(i).attribute14 = FND_API.G_MISS_CHAR THEN
2712: l_req_material_rec.attribute14 := NULL;
2713: END IF;
2714:
2715: --

Line 2717: p_x_req_material_tbl(i).attribute15 <> FND_API.G_MISS_CHAR

2713: END IF;
2714:
2715: --
2716: IF p_x_req_material_tbl(i).attribute15 IS NOT NULL AND
2717: p_x_req_material_tbl(i).attribute15 <> FND_API.G_MISS_CHAR
2718: THEN
2719: l_req_material_rec.attribute15 := p_x_req_material_tbl(i).attribute15;
2720: ELSIF p_x_req_material_tbl(i).attribute15 = FND_API.G_MISS_CHAR THEN
2721: l_req_material_rec.attribute15 := NULL;

Line 2720: ELSIF p_x_req_material_tbl(i).attribute15 = FND_API.G_MISS_CHAR THEN

2716: IF p_x_req_material_tbl(i).attribute15 IS NOT NULL AND
2717: p_x_req_material_tbl(i).attribute15 <> FND_API.G_MISS_CHAR
2718: THEN
2719: l_req_material_rec.attribute15 := p_x_req_material_tbl(i).attribute15;
2720: ELSIF p_x_req_material_tbl(i).attribute15 = FND_API.G_MISS_CHAR THEN
2721: l_req_material_rec.attribute15 := NULL;
2722: END IF;
2723: --
2724: --Update schedule material table

Line 2764: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

2760: END LOOP;
2761: END IF; -- p_x_req_material_tbl.COUNT
2762: --
2763: ELSE
2764: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2765: RAISE Fnd_Api.G_EXC_ERROR;
2766: END IF;-- Return status
2767:
2768: IF X_return_status = 'S' THEN

Line 2765: RAISE Fnd_Api.G_EXC_ERROR;

2761: END IF; -- p_x_req_material_tbl.COUNT
2762: --
2763: ELSE
2764: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2765: RAISE Fnd_Api.G_EXC_ERROR;
2766: END IF;-- Return status
2767:
2768: IF X_return_status = 'S' THEN
2769: --Check for Profile Option value If 'Y' Call

Line 2799: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

2795: --Ignore messages in stack if return status is S after calls to EAM APIs.
2796: /*
2797: IF l_msg_count > 0 THEN
2798: X_msg_count := l_msg_count;
2799: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2800: RAISE Fnd_Api.G_EXC_ERROR;
2801: END IF;
2802: */
2803:

Line 2800: RAISE Fnd_Api.G_EXC_ERROR;

2796: /*
2797: IF l_msg_count > 0 THEN
2798: X_msg_count := l_msg_count;
2799: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2800: RAISE Fnd_Api.G_EXC_ERROR;
2801: END IF;
2802: */
2803:
2804: --Standard check for commit

Line 2805: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

2801: END IF;
2802: */
2803:
2804: --Standard check for commit
2805: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
2806: COMMIT;
2807: END IF;
2808: -- Debug info
2809: IF G_DEBUG='Y' THEN

Line 2816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2812: Ahl_Debug_Pub.disable_debug;
2813: END IF;
2814:
2815: EXCEPTION
2816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2817: ROLLBACK TO update_material_reqst;
2818: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2819: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2820: p_count => x_msg_count,

Line 2818: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2814:
2815: EXCEPTION
2816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2817: ROLLBACK TO update_material_reqst;
2818: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2819: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2820: p_count => x_msg_count,
2821: p_data => x_msg_data);
2822: IF G_DEBUG='Y' THEN

Line 2819: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2815: EXCEPTION
2816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2817: ROLLBACK TO update_material_reqst;
2818: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2819: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2820: p_count => x_msg_count,
2821: p_data => x_msg_data);
2822: IF G_DEBUG='Y' THEN
2823: AHL_DEBUG_PUB.log_app_messages (

Line 2829: WHEN FND_API.G_EXC_ERROR THEN

2825: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');
2826: -- Check if API is called in debug mode. If yes, disable debug.
2827: AHL_DEBUG_PUB.disable_debug;
2828: END IF;
2829: WHEN FND_API.G_EXC_ERROR THEN
2830: ROLLBACK TO update_material_reqst;
2831: X_return_status := FND_API.G_RET_STS_ERROR;
2832: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2833: p_count => x_msg_count,

Line 2831: X_return_status := FND_API.G_RET_STS_ERROR;

2827: AHL_DEBUG_PUB.disable_debug;
2828: END IF;
2829: WHEN FND_API.G_EXC_ERROR THEN
2830: ROLLBACK TO update_material_reqst;
2831: X_return_status := FND_API.G_RET_STS_ERROR;
2832: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2833: p_count => x_msg_count,
2834: p_data => X_msg_data);
2835: IF G_DEBUG='Y' THEN

Line 2832: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2828: END IF;
2829: WHEN FND_API.G_EXC_ERROR THEN
2830: ROLLBACK TO update_material_reqst;
2831: X_return_status := FND_API.G_RET_STS_ERROR;
2832: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2833: p_count => x_msg_count,
2834: p_data => X_msg_data);
2835: IF G_DEBUG='Y' THEN
2836: -- Debug info.

Line 2845: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2841: AHL_DEBUG_PUB.disable_debug;
2842: END IF;
2843: WHEN OTHERS THEN
2844: ROLLBACK TO update_material_reqst;
2845: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2846: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2847: THEN
2848: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',
2849: p_procedure_name => 'UPDATE_MATERIAL_REQST',

Line 2852: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2848: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',
2849: p_procedure_name => 'UPDATE_MATERIAL_REQST',
2850: p_error_text => SUBSTR(SQLERRM,1,240));
2851: END IF;
2852: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2853: p_count => x_msg_count,
2854: p_data => X_msg_data);
2855: IF G_DEBUG='Y' THEN
2856: -- Debug info.

Line 2874: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

2870: -- Parameters :
2871: --
2872: -- Standard IN Parameters :
2873: -- p_api_version IN NUMBER Required
2874: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2875: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2876: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2877: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
2878: -- p_module_type IN VARCHAR2 Default NULL.

Line 2875: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

2871: --
2872: -- Standard IN Parameters :
2873: -- p_api_version IN NUMBER Required
2874: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2875: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2876: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2877: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
2878: -- p_module_type IN VARCHAR2 Default NULL.
2879: --

Line 2876: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

2872: -- Standard IN Parameters :
2873: -- p_api_version IN NUMBER Required
2874: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2875: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2876: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2877: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
2878: -- p_module_type IN VARCHAR2 Default NULL.
2879: --
2880: -- Standard OUT Parameters :

Line 2877: -- p_default IN VARCHAR2 Default FND_API.G_TRUE

2873: -- p_api_version IN NUMBER Required
2874: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2875: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2876: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2877: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
2878: -- p_module_type IN VARCHAR2 Default NULL.
2879: --
2880: -- Standard OUT Parameters :
2881: -- x_return_status OUT VARCHAR2 Required

Line 2895: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

2891: --
2892: -- End of Comments.
2893: PROCEDURE Remove_Material_Request (
2894: p_api_version IN NUMBER,
2895: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
2896: p_commit IN VARCHAR2 := Fnd_Api.g_false,
2897: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
2898: p_module_type IN VARCHAR2 := 'JSP',
2899: p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,

Line 2896: p_commit IN VARCHAR2 := Fnd_Api.g_false,

2892: -- End of Comments.
2893: PROCEDURE Remove_Material_Request (
2894: p_api_version IN NUMBER,
2895: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
2896: p_commit IN VARCHAR2 := Fnd_Api.g_false,
2897: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
2898: p_module_type IN VARCHAR2 := 'JSP',
2899: p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,
2900: x_return_status OUT NOCOPY VARCHAR2,

Line 2897: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

2893: PROCEDURE Remove_Material_Request (
2894: p_api_version IN NUMBER,
2895: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
2896: p_commit IN VARCHAR2 := Fnd_Api.g_false,
2897: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
2898: p_module_type IN VARCHAR2 := 'JSP',
2899: p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,
2900: x_return_status OUT NOCOPY VARCHAR2,
2901: x_msg_count OUT NOCOPY NUMBER,

Line 3043: IF Fnd_Api.to_boolean(p_init_msg_list)

3039: Ahl_Debug_Pub.debug( 'enter ahl_pp_materials_pvt Remove Material Request ','+MAATP+');
3040: --
3041: END IF;
3042: -- Standard call to check for call compatibility.
3043: IF Fnd_Api.to_boolean(p_init_msg_list)
3044: THEN
3045: Fnd_Msg_Pub.initialize;
3046: END IF;
3047: -- Initialize API return status to success

Line 3048: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3044: THEN
3045: Fnd_Msg_Pub.initialize;
3046: END IF;
3047: -- Initialize API return status to success
3048: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3049: -- Initialize message list if p_init_msg_list is set to TRUE.
3050: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
3051: p_api_version,
3052: l_api_name,G_PKG_NAME)

Line 3050: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,

3046: END IF;
3047: -- Initialize API return status to success
3048: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3049: -- Initialize message list if p_init_msg_list is set to TRUE.
3050: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
3051: p_api_version,
3052: l_api_name,G_PKG_NAME)
3053: THEN
3054: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 3054: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

3050: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
3051: p_api_version,
3052: l_api_name,G_PKG_NAME)
3053: THEN
3054: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3055: END IF;
3056:
3057: ------------------------Start API Body ---------------------------------
3058: IF p_x_req_material_tbl.COUNT > 0 THEN

Line 3064: p_x_req_material_tbl(i).workorder_id <> Fnd_Api.G_MISS_NUM )

3060: LOOP
3061: -- Value to ID Conversion
3062: --Get visit task id
3063: IF (p_x_req_material_tbl(i).workorder_id IS NOT NULL AND
3064: p_x_req_material_tbl(i).workorder_id <> Fnd_Api.G_MISS_NUM )
3065: THEN
3066: --
3067: -- Bug # 6680137 - start
3068: OPEN Get_job_details(p_x_req_material_tbl(i).workorder_id);

Line 3074: RAISE FND_API.G_EXC_ERROR;

3070: IF Get_job_details%NOTFOUND THEN
3071: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_ORD_NOT_EXISTS');
3072: Fnd_Msg_Pub.ADD;
3073: CLOSE Get_job_details;
3074: RAISE FND_API.G_EXC_ERROR;
3075: END IF;
3076: CLOSE Get_job_details;
3077: -- Bug # 6680137 - end
3078: -- Balaji added this validation for Bug # 6680137 - begin.

Line 3089: RAISE FND_API.G_EXC_ERROR;

3085: IF l_wo_status IN ('7', '5', '12')
3086: THEN
3087: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_STATUS_INVALID');
3088: Fnd_Msg_Pub.ADD;
3089: RAISE FND_API.G_EXC_ERROR;
3090: END IF;
3091: -- Bug # 6680137 - end
3092: END IF;
3093:

Line 3102: IF l_return_status = FND_API.G_TRUE THEN

3098: p_workorder_id => p_x_req_material_tbl(i).workorder_id,
3099: p_ue_id => NULL,
3100: p_visit_id => NULL,
3101: p_item_instance_id => NULL);
3102: IF l_return_status = FND_API.G_TRUE THEN
3103: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_DEL_MTL_UNTLCKD');
3104: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);
3105: FND_MSG_PUB.ADD;
3106: RAISE FND_API.G_EXC_ERROR;

Line 3106: RAISE FND_API.G_EXC_ERROR;

3102: IF l_return_status = FND_API.G_TRUE THEN
3103: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_DEL_MTL_UNTLCKD');
3104: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);
3105: FND_MSG_PUB.ADD;
3106: RAISE FND_API.G_EXC_ERROR;
3107: END IF;
3108: -- rroy
3109: -- ACL Changes
3110:

Line 3113: p_x_req_material_tbl(i).schedule_material_id = FND_API.G_MISS_NUM) THEN

3109: -- ACL Changes
3110:
3111: -- Check for Schedule Material ID
3112: IF (p_x_req_material_tbl(i).schedule_material_id IS NULL OR
3113: p_x_req_material_tbl(i).schedule_material_id = FND_API.G_MISS_NUM) THEN
3114: Fnd_Message.SET_NAME('AHL','AHL_PP_SCH_MATRL_REQUIRED');
3115: Fnd_Msg_Pub.ADD;
3116: END IF;
3117: --

Line 3124: p_x_req_material_tbl(i).object_version_number <> FND_API.G_MISS_NUM) THEN

3120: Ahl_Debug_Pub.debug( 'Sch mat Id:'||p_x_req_material_tbl(i).schedule_material_id);
3121: END IF;
3122: -- Check for object version number
3123: IF (p_x_req_material_tbl(i).object_version_number IS NOT NULL AND
3124: p_x_req_material_tbl(i).object_version_number <> FND_API.G_MISS_NUM) THEN
3125: --
3126: SELECT object_version_number,requested_quantity INTO l_object_version_number,
3127: p_x_req_material_tbl(i).requested_quantity
3128: FROM ahl_schedule_materials

Line 3135: RAISE Fnd_Api.G_EXC_ERROR;

3131: --
3132: IF p_x_req_material_tbl(i).object_version_number <> l_object_version_number THEN
3133: Fnd_Message.SET_NAME('AHL','AHL_PP_RECORD_CHANGED');
3134: Fnd_Msg_Pub.ADD;
3135: RAISE Fnd_Api.G_EXC_ERROR;
3136: END IF;
3137: --
3138: END IF;
3139:

Line 3145: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

3141: l_msg_count := Fnd_Msg_Pub.count_msg;
3142:
3143: IF l_msg_count > 0 THEN
3144: X_msg_count := l_msg_count;
3145: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3146: RAISE Fnd_Api.G_EXC_ERROR;
3147: END IF;
3148:
3149: END LOOP;

Line 3146: RAISE Fnd_Api.G_EXC_ERROR;

3142:
3143: IF l_msg_count > 0 THEN
3144: X_msg_count := l_msg_count;
3145: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3146: RAISE Fnd_Api.G_EXC_ERROR;
3147: END IF;
3148:
3149: END LOOP;
3150: END IF;

Line 3205: p_init_msg_list => FND_API.G_FALSE,

3201:
3202: -- delete reservations.
3203: AHL_RSV_RESERVATIONS_PVT.DELETE_RESERVATION(
3204: p_api_version => 1.0,
3205: p_init_msg_list => FND_API.G_FALSE,
3206: p_commit => FND_API.G_FALSE,
3207: p_module_type => NULL,
3208: x_return_status => x_return_status,
3209: x_msg_count => x_msg_count,

Line 3206: p_commit => FND_API.G_FALSE,

3202: -- delete reservations.
3203: AHL_RSV_RESERVATIONS_PVT.DELETE_RESERVATION(
3204: p_api_version => 1.0,
3205: p_init_msg_list => FND_API.G_FALSE,
3206: p_commit => FND_API.G_FALSE,
3207: p_module_type => NULL,
3208: x_return_status => x_return_status,
3209: x_msg_count => x_msg_count,
3210: x_msg_data => x_msg_data,

Line 3218: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3214: AHL_DEBUG_PUB.debug('After calling delete reservation api. Return status:' || x_return_status);
3215: END IF;
3216:
3217: -- check return status.
3218: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3220: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3221: RAISE FND_API.G_EXC_ERROR;
3222: END IF;

Line 3219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3215: END IF;
3216:
3217: -- check return status.
3218: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3220: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3221: RAISE FND_API.G_EXC_ERROR;
3222: END IF;
3223:

Line 3220: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

3216:
3217: -- check return status.
3218: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3220: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3221: RAISE FND_API.G_EXC_ERROR;
3222: END IF;
3223:
3224: END IF;

Line 3221: RAISE FND_API.G_EXC_ERROR;

3217: -- check return status.
3218: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3220: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3221: RAISE FND_API.G_EXC_ERROR;
3222: END IF;
3223:
3224: END IF;
3225:

Line 3274: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

3270: END LOOP;
3271: END IF;
3272: --
3273: ELSE
3274: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3275: RAISE Fnd_Api.G_EXC_ERROR;
3276: --
3277: END IF; --Status
3278: ---------------------------End of Body---------------------------------------

Line 3275: RAISE Fnd_Api.G_EXC_ERROR;

3271: END IF;
3272: --
3273: ELSE
3274: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3275: RAISE Fnd_Api.G_EXC_ERROR;
3276: --
3277: END IF; --Status
3278: ---------------------------End of Body---------------------------------------
3279: --Standard check to count messages

Line 3287: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

3283: --Ignore messages in stack if return status is S after calls to EAM APIs.
3284: /*
3285: IF l_msg_count > 0 THEN
3286: X_msg_count := l_msg_count;
3287: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3288: RAISE Fnd_Api.G_EXC_ERROR;
3289: END IF;
3290: */
3291: --Standard check for commit

Line 3288: RAISE Fnd_Api.G_EXC_ERROR;

3284: /*
3285: IF l_msg_count > 0 THEN
3286: X_msg_count := l_msg_count;
3287: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3288: RAISE Fnd_Api.G_EXC_ERROR;
3289: END IF;
3290: */
3291: --Standard check for commit
3292: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

Line 3292: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

3288: RAISE Fnd_Api.G_EXC_ERROR;
3289: END IF;
3290: */
3291: --Standard check for commit
3292: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
3293: COMMIT;
3294: END IF;
3295: -- Debug info
3296: IF G_DEBUG='Y' THEN

Line 3303: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

3299: Ahl_Debug_Pub.disable_debug;
3300: END IF;
3301:
3302: EXCEPTION
3303: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3304: ROLLBACK TO remove_material_request;
3305: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3306: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
3307: p_count => x_msg_count,

Line 3305: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

3301:
3302: EXCEPTION
3303: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3304: ROLLBACK TO remove_material_request;
3305: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3306: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
3307: p_count => x_msg_count,
3308: p_data => x_msg_data);
3309:

Line 3306: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

3302: EXCEPTION
3303: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3304: ROLLBACK TO remove_material_request;
3305: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3306: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
3307: p_count => x_msg_count,
3308: p_data => x_msg_data);
3309:
3310: IF G_DEBUG='Y' THEN

Line 3317: WHEN Fnd_Api.G_EXC_ERROR THEN

3313: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MAMRP+');
3314: -- Check if API is called in debug mode. If yes, disable debug.
3315: Ahl_Debug_Pub.disable_debug;
3316: END IF;
3317: WHEN Fnd_Api.G_EXC_ERROR THEN
3318: ROLLBACK TO remove_material_request;
3319: X_return_status := Fnd_Api.G_RET_STS_ERROR;
3320: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
3321: p_count => x_msg_count,

Line 3319: X_return_status := Fnd_Api.G_RET_STS_ERROR;

3315: Ahl_Debug_Pub.disable_debug;
3316: END IF;
3317: WHEN Fnd_Api.G_EXC_ERROR THEN
3318: ROLLBACK TO remove_material_request;
3319: X_return_status := Fnd_Api.G_RET_STS_ERROR;
3320: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
3321: p_count => x_msg_count,
3322: p_data => X_msg_data);
3323: IF G_DEBUG='Y' THEN

Line 3320: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

3316: END IF;
3317: WHEN Fnd_Api.G_EXC_ERROR THEN
3318: ROLLBACK TO remove_material_request;
3319: X_return_status := Fnd_Api.G_RET_STS_ERROR;
3320: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
3321: p_count => x_msg_count,
3322: p_data => X_msg_data);
3323: IF G_DEBUG='Y' THEN
3324: -- Debug info.

Line 3333: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

3329: Ahl_Debug_Pub.disable_debug;
3330: END IF;
3331: WHEN OTHERS THEN
3332: ROLLBACK TO remove_material_request;
3333: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3334: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3335: THEN
3336: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',
3337: p_procedure_name => 'REMOVE_MATERIAL_REQUEST',

Line 3340: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

3336: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',
3337: p_procedure_name => 'REMOVE_MATERIAL_REQUEST',
3338: p_error_text => SUBSTR(SQLERRM,1,240));
3339: END IF;
3340: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
3341: p_count => x_msg_count,
3342: p_data => X_msg_data);
3343:
3344: IF G_DEBUG='Y' THEN

Line 3367: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

3363: -- Parameters :
3364: --
3365: -- Standard IN Parameters :
3366: -- p_api_version IN NUMBER Required
3367: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3368: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3369: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3370: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
3371: -- p_module_type IN VARCHAR2 Default NULL.

Line 3368: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

3364: --
3365: -- Standard IN Parameters :
3366: -- p_api_version IN NUMBER Required
3367: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3368: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3369: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3370: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
3371: -- p_module_type IN VARCHAR2 Default NULL.
3372: --

Line 3369: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

3365: -- Standard IN Parameters :
3366: -- p_api_version IN NUMBER Required
3367: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3368: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3369: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3370: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
3371: -- p_module_type IN VARCHAR2 Default NULL.
3372: --
3373: -- Standard OUT Parameters :

Line 3370: -- p_default IN VARCHAR2 Default FND_API.G_TRUE

3366: -- p_api_version IN NUMBER Required
3367: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3368: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3369: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3370: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
3371: -- p_module_type IN VARCHAR2 Default NULL.
3372: --
3373: -- Standard OUT Parameters :
3374: -- x_return_status OUT VARCHAR2 Required

Line 3390: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

3386: -- End of Comments.
3387:
3388: PROCEDURE Process_Material_Request (
3389: p_api_version IN NUMBER,
3390: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
3391: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
3392: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
3393: p_module_type IN VARCHAR2 := NULL,
3394: p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,

Line 3391: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

3387:
3388: PROCEDURE Process_Material_Request (
3389: p_api_version IN NUMBER,
3390: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
3391: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
3392: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
3393: p_module_type IN VARCHAR2 := NULL,
3394: p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,
3395: x_return_status OUT NOCOPY VARCHAR2,

Line 3392: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,

3388: PROCEDURE Process_Material_Request (
3389: p_api_version IN NUMBER,
3390: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
3391: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
3392: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
3393: p_module_type IN VARCHAR2 := NULL,
3394: p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,
3395: x_return_status OUT NOCOPY VARCHAR2,
3396: x_msg_count OUT NOCOPY NUMBER,

Line 3412: l_commit VARCHAR2(30) := Fnd_Api.G_FALSE;

3408: l_req_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
3409: l_req_cr_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
3410: l_req_up_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
3411: l_req_re_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
3412: l_commit VARCHAR2(30) := Fnd_Api.G_FALSE;
3413:
3414: BEGIN
3415: --------------------Initialize ----------------------------------
3416: -- Standard Start of API savepoint

Line 3426: IF FND_API.to_boolean(p_init_msg_list)

3422: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. process material request','+PPMRP+');
3423: --
3424: END IF;
3425: -- Standard call to check for call compatibility.
3426: IF FND_API.to_boolean(p_init_msg_list)
3427: THEN
3428: FND_MSG_PUB.initialize;
3429: END IF;
3430: -- Initialize API return status to success

Line 3431: x_return_status := FND_API.G_RET_STS_SUCCESS;

3427: THEN
3428: FND_MSG_PUB.initialize;
3429: END IF;
3430: -- Initialize API return status to success
3431: x_return_status := FND_API.G_RET_STS_SUCCESS;
3432: -- Initialize message list if p_init_msg_list is set to TRUE.
3433: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
3434: p_api_version,
3435: l_api_name,G_PKG_NAME)

Line 3433: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

3429: END IF;
3430: -- Initialize API return status to success
3431: x_return_status := FND_API.G_RET_STS_SUCCESS;
3432: -- Initialize message list if p_init_msg_list is set to TRUE.
3433: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
3434: p_api_version,
3435: l_api_name,G_PKG_NAME)
3436: THEN
3437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3433: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
3434: p_api_version,
3435: l_api_name,G_PKG_NAME)
3436: THEN
3437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3438: END IF;
3439: --------------------Start of API Body-----------------------------------
3440: IF p_x_req_material_tbl.COUNT > 0 THEN
3441: FOR i IN p_x_req_material_tbl.FIRST..p_x_req_material_tbl.LAST

Line 3476: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

3472: x_return_status => l_return_status,
3473: x_msg_count => l_msg_count,
3474: x_msg_data => l_msg_data
3475: ) ;
3476: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
3477: l_msg_count := FND_MSG_PUB.count_msg;
3478: IF l_msg_count > 0 THEN
3479: RAISE FND_API.G_EXC_ERROR;
3480: END IF;

Line 3479: RAISE FND_API.G_EXC_ERROR;

3475: ) ;
3476: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
3477: l_msg_count := FND_MSG_PUB.count_msg;
3478: IF l_msg_count > 0 THEN
3479: RAISE FND_API.G_EXC_ERROR;
3480: END IF;
3481: END IF;
3482: FOR i IN l_req_cr_material_tbl.First..l_req_cr_material_tbl.LAST LOOP
3483: p_x_req_material_tbl(i).SCHEDULE_MATERIAL_ID := l_req_cr_material_tbl(i).SCHEDULE_MATERIAL_ID;

Line 3501: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

3497: x_msg_count => l_msg_count,
3498: x_msg_data => l_msg_data
3499: );
3500:
3501: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
3502: l_msg_count := FND_MSG_PUB.count_msg;
3503: IF l_msg_count > 0 THEN
3504: RAISE FND_API.G_EXC_ERROR;
3505: END IF;

Line 3504: RAISE FND_API.G_EXC_ERROR;

3500:
3501: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
3502: l_msg_count := FND_MSG_PUB.count_msg;
3503: IF l_msg_count > 0 THEN
3504: RAISE FND_API.G_EXC_ERROR;
3505: END IF;
3506: END IF;
3507: END IF;
3508: IF l_req_re_material_tbl.COUNT > 0 THEN

Line 3523: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

3519: x_msg_count => l_msg_count,
3520: x_msg_data => l_msg_data
3521: );
3522:
3523: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
3524: l_msg_count := FND_MSG_PUB.count_msg;
3525: IF l_msg_count > 0 THEN
3526: RAISE FND_API.G_EXC_ERROR;
3527: END IF;

Line 3526: RAISE FND_API.G_EXC_ERROR;

3522:
3523: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
3524: l_msg_count := FND_MSG_PUB.count_msg;
3525: IF l_msg_count > 0 THEN
3526: RAISE FND_API.G_EXC_ERROR;
3527: END IF;
3528: END IF;
3529:
3530: END IF;

Line 3537: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

3533: l_msg_count := Fnd_Msg_Pub.count_msg;
3534:
3535: IF l_msg_count > 0 THEN
3536: X_msg_count := l_msg_count;
3537: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3538: RAISE Fnd_Api.G_EXC_ERROR;
3539: END IF;
3540:
3541: --Standard check for commit

Line 3538: RAISE Fnd_Api.G_EXC_ERROR;

3534:
3535: IF l_msg_count > 0 THEN
3536: X_msg_count := l_msg_count;
3537: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3538: RAISE Fnd_Api.G_EXC_ERROR;
3539: END IF;
3540:
3541: --Standard check for commit
3542: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

Line 3542: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

3538: RAISE Fnd_Api.G_EXC_ERROR;
3539: END IF;
3540:
3541: --Standard check for commit
3542: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
3543: COMMIT;
3544: END IF;
3545: -- Debug info
3546: IF G_DEBUG='Y' THEN

Line 3553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3549: Ahl_Debug_Pub.disable_debug;
3550: --
3551: END IF;
3552: EXCEPTION
3553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3554: ROLLBACK TO process_material_request;
3555: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3556: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3557: p_count => x_msg_count,

Line 3555: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3551: END IF;
3552: EXCEPTION
3553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3554: ROLLBACK TO process_material_request;
3555: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3556: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3557: p_count => x_msg_count,
3558: p_data => x_msg_data);
3559: IF G_DEBUG='Y' THEN

Line 3556: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3552: EXCEPTION
3553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3554: ROLLBACK TO process_material_request;
3555: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3556: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3557: p_count => x_msg_count,
3558: p_data => x_msg_data);
3559: IF G_DEBUG='Y' THEN
3560: AHL_DEBUG_PUB.log_app_messages (

Line 3566: WHEN FND_API.G_EXC_ERROR THEN

3562: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');
3563: -- Check if API is called in debug mode. If yes, disable debug.
3564: AHL_DEBUG_PUB.disable_debug;
3565: END IF;
3566: WHEN FND_API.G_EXC_ERROR THEN
3567: ROLLBACK TO process_material_request;
3568: X_return_status := FND_API.G_RET_STS_ERROR;
3569: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3570: p_count => x_msg_count,

Line 3568: X_return_status := FND_API.G_RET_STS_ERROR;

3564: AHL_DEBUG_PUB.disable_debug;
3565: END IF;
3566: WHEN FND_API.G_EXC_ERROR THEN
3567: ROLLBACK TO process_material_request;
3568: X_return_status := FND_API.G_RET_STS_ERROR;
3569: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3570: p_count => x_msg_count,
3571: p_data => X_msg_data);
3572: IF G_DEBUG='Y' THEN

Line 3569: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3565: END IF;
3566: WHEN FND_API.G_EXC_ERROR THEN
3567: ROLLBACK TO process_material_request;
3568: X_return_status := FND_API.G_RET_STS_ERROR;
3569: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3570: p_count => x_msg_count,
3571: p_data => X_msg_data);
3572: IF G_DEBUG='Y' THEN
3573: -- Debug info.

Line 3583: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3579: --
3580: END IF;
3581: WHEN OTHERS THEN
3582: ROLLBACK TO process_material_request;
3583: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3584: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3585: THEN
3586: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',
3587: p_procedure_name => 'PROCESS_MATERIAL_REQUEST',

Line 3590: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3586: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',
3587: p_procedure_name => 'PROCESS_MATERIAL_REQUEST',
3588: p_error_text => SUBSTR(SQLERRM,1,240));
3589: END IF;
3590: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3591: p_count => x_msg_count,
3592: p_data => X_msg_data);
3593: IF G_DEBUG='Y' THEN
3594: -- Debug info.

Line 4036: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

4032: -- Parameters :
4033: --
4034: -- Standard IN Parameters :
4035: -- p_api_version IN NUMBER Required
4036: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
4037: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
4038: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
4039: -- Based on this flag, the API will set the default attributes.
4040: -- Standard OUT Parameters :

Line 4037: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

4033: --
4034: -- Standard IN Parameters :
4035: -- p_api_version IN NUMBER Required
4036: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
4037: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
4038: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
4039: -- Based on this flag, the API will set the default attributes.
4040: -- Standard OUT Parameters :
4041: -- x_return_status OUT VARCHAR2 Required

Line 4038: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

4034: -- Standard IN Parameters :
4035: -- p_api_version IN NUMBER Required
4036: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
4037: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
4038: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
4039: -- Based on this flag, the API will set the default attributes.
4040: -- Standard OUT Parameters :
4041: -- x_return_status OUT VARCHAR2 Required
4042: -- x_msg_count OUT NUMBER Required

Line 4053: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

4049: --
4050:
4051: PROCEDURE Process_Wo_Op_Materials (
4052: p_api_version IN NUMBER,
4053: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
4054: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
4055: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
4056: p_operation_flag IN VARCHAR2,
4057: p_prd_wooperation_tbl IN AHL_PRD_OPERATIONS_PVT.Prd_Operation_Tbl,

Line 4054: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

4050:
4051: PROCEDURE Process_Wo_Op_Materials (
4052: p_api_version IN NUMBER,
4053: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
4054: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
4055: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
4056: p_operation_flag IN VARCHAR2,
4057: p_prd_wooperation_tbl IN AHL_PRD_OPERATIONS_PVT.Prd_Operation_Tbl,
4058: x_req_material_tbl OUT NOCOPY Req_Material_Tbl_Type,

Line 4055: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,

4051: PROCEDURE Process_Wo_Op_Materials (
4052: p_api_version IN NUMBER,
4053: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
4054: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
4055: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
4056: p_operation_flag IN VARCHAR2,
4057: p_prd_wooperation_tbl IN AHL_PRD_OPERATIONS_PVT.Prd_Operation_Tbl,
4058: x_req_material_tbl OUT NOCOPY Req_Material_Tbl_Type,
4059: x_return_status OUT NOCOPY VARCHAR2,

Line 4135: IF FND_API.to_boolean(p_init_msg_list)

4131: --------------------Initialize ----------------------------------
4132: -- Standard Start of API savepoint
4133: SAVEPOINT Process_Wo_Op_Materials;
4134: -- Standard call to check for call compatibility.
4135: IF FND_API.to_boolean(p_init_msg_list)
4136: THEN
4137: FND_MSG_PUB.initialize;
4138: END IF;
4139: -- Initialize API return status to success

Line 4140: x_return_status := FND_API.G_RET_STS_SUCCESS;

4136: THEN
4137: FND_MSG_PUB.initialize;
4138: END IF;
4139: -- Initialize API return status to success
4140: x_return_status := FND_API.G_RET_STS_SUCCESS;
4141: -- Initialize message list if p_init_msg_list is set to TRUE.
4142: IF NOT FND_API.COMPATIBLE_API_CALL(p_api_version,
4143: p_api_version,
4144: l_api_name,G_PKG_NAME)

Line 4142: IF NOT FND_API.COMPATIBLE_API_CALL(p_api_version,

4138: END IF;
4139: -- Initialize API return status to success
4140: x_return_status := FND_API.G_RET_STS_SUCCESS;
4141: -- Initialize message list if p_init_msg_list is set to TRUE.
4142: IF NOT FND_API.COMPATIBLE_API_CALL(p_api_version,
4143: p_api_version,
4144: l_api_name,G_PKG_NAME)
4145: THEN
4146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4142: IF NOT FND_API.COMPATIBLE_API_CALL(p_api_version,
4143: p_api_version,
4144: l_api_name,G_PKG_NAME)
4145: THEN
4146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4147: END IF;
4148:
4149: --
4150: IF l_prd_wooperation_tbl.COUNT > 0 THEN

Line 4157: l_prd_wooperation_tbl(i).workorder_operation_id <> FND_API.G_MISS_NUM )

4153: --
4154:
4155: IF (p_operation_flag = 'C' AND
4156: l_prd_wooperation_tbl(i).workorder_operation_id IS NOT NULL AND
4157: l_prd_wooperation_tbl(i).workorder_operation_id <> FND_API.G_MISS_NUM )
4158: THEN
4159:
4160: --Get visit id, visit task id
4161: OPEN Visit_Task_Cur(l_prd_wooperation_tbl(i).workorder_id);

Line 4189: l_prd_wooperation_tbl(i).operation_sequence_num <> FND_API.G_MISS_NUM)

4185:
4186: END IF;
4187: --Check for one operation sequence exists means materials exist at route only
4188: IF (l_prd_wooperation_tbl(i).operation_sequence_num IS NOT NULL AND
4189: l_prd_wooperation_tbl(i).operation_sequence_num <> FND_API.G_MISS_NUM)
4190: THEN
4191: --
4192: l_idx := 0;
4193: FOR l_Sche_Mat_Rec IN Sche_Mat_Cur(l_Visit_Task_Rec.visit_task_id)

Line 4385: l_prd_wooperation_tbl(i).workorder_operation_id <> FND_API.G_MISS_NUM AND

4381: LOOP
4382: --
4383: IF (p_operation_flag = 'S' AND
4384: l_prd_wooperation_tbl(i).workorder_operation_id IS NOT NULL AND
4385: l_prd_wooperation_tbl(i).workorder_operation_id <> FND_API.G_MISS_NUM AND
4386: l_prd_wooperation_tbl(i).operation_sequence_num IS NOT NULL AND
4387: l_prd_wooperation_tbl(i).operation_sequence_num <> FND_API.G_MISS_NUM)
4388: THEN
4389: --

Line 4387: l_prd_wooperation_tbl(i).operation_sequence_num <> FND_API.G_MISS_NUM)

4383: IF (p_operation_flag = 'S' AND
4384: l_prd_wooperation_tbl(i).workorder_operation_id IS NOT NULL AND
4385: l_prd_wooperation_tbl(i).workorder_operation_id <> FND_API.G_MISS_NUM AND
4386: l_prd_wooperation_tbl(i).operation_sequence_num IS NOT NULL AND
4387: l_prd_wooperation_tbl(i).operation_sequence_num <> FND_API.G_MISS_NUM)
4388: THEN
4389: --
4390: OPEN Material_Detail_Cur(l_prd_wooperation_tbl(i).workorder_operation_id,
4391: l_prd_wooperation_tbl(i).operation_sequence_num);

Line 4439: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

4435: l_msg_count := Fnd_Msg_Pub.count_msg;
4436:
4437: IF l_msg_count > 0 THEN
4438: X_msg_count := l_msg_count;
4439: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4440: RAISE Fnd_Api.G_EXC_ERROR;
4441: END IF;
4442:
4443: --Standard check for commit

Line 4440: RAISE Fnd_Api.G_EXC_ERROR;

4436:
4437: IF l_msg_count > 0 THEN
4438: X_msg_count := l_msg_count;
4439: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4440: RAISE Fnd_Api.G_EXC_ERROR;
4441: END IF;
4442:
4443: --Standard check for commit
4444: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

Line 4444: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

4440: RAISE Fnd_Api.G_EXC_ERROR;
4441: END IF;
4442:
4443: --Standard check for commit
4444: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
4445: COMMIT;
4446: END IF;
4447: -- Debug info
4448: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 4458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4454: );
4455: END IF;
4456:
4457: EXCEPTION
4458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4459: ROLLBACK TO Process_Wo_Op_Materials;
4460: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4461: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4462: p_count => x_msg_count,

Line 4460: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4456:
4457: EXCEPTION
4458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4459: ROLLBACK TO Process_Wo_Op_Materials;
4460: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4461: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4462: p_count => x_msg_count,
4463: p_data => x_msg_data);
4464:

Line 4461: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4457: EXCEPTION
4458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4459: ROLLBACK TO Process_Wo_Op_Materials;
4460: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4461: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4462: p_count => x_msg_count,
4463: p_data => x_msg_data);
4464:
4465: WHEN FND_API.G_EXC_ERROR THEN

Line 4465: WHEN FND_API.G_EXC_ERROR THEN

4461: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4462: p_count => x_msg_count,
4463: p_data => x_msg_data);
4464:
4465: WHEN FND_API.G_EXC_ERROR THEN
4466: ROLLBACK TO Process_Wo_Op_Materials;
4467: X_return_status := FND_API.G_RET_STS_ERROR;
4468: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4469: p_count => x_msg_count,

Line 4467: X_return_status := FND_API.G_RET_STS_ERROR;

4463: p_data => x_msg_data);
4464:
4465: WHEN FND_API.G_EXC_ERROR THEN
4466: ROLLBACK TO Process_Wo_Op_Materials;
4467: X_return_status := FND_API.G_RET_STS_ERROR;
4468: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4469: p_count => x_msg_count,
4470: p_data => X_msg_data);
4471: WHEN OTHERS THEN

Line 4468: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4464:
4465: WHEN FND_API.G_EXC_ERROR THEN
4466: ROLLBACK TO Process_Wo_Op_Materials;
4467: X_return_status := FND_API.G_RET_STS_ERROR;
4468: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4469: p_count => x_msg_count,
4470: p_data => X_msg_data);
4471: WHEN OTHERS THEN
4472: ROLLBACK TO Process_Wo_Op_Materials;

Line 4473: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4469: p_count => x_msg_count,
4470: p_data => X_msg_data);
4471: WHEN OTHERS THEN
4472: ROLLBACK TO Process_Wo_Op_Materials;
4473: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4474: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4475: THEN
4476: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',
4477: p_procedure_name => 'PROCESS_WO_OP_MATERIALS',

Line 4480: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4476: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_MATERIALS_PVT',
4477: p_procedure_name => 'PROCESS_WO_OP_MATERIALS',
4478: p_error_text => SUBSTR(SQLERRM,1,240));
4479: END IF;
4480: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4481: p_count => x_msg_count,
4482: p_data => X_msg_data);
4483:
4484: END Process_Wo_Op_Materials;

Line 4498: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

4494: -- Parameters :
4495: --
4496: -- Standard IN Parameters :
4497: -- p_api_version IN NUMBER Required
4498: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
4499: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
4500: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
4501: -- Based on this flag, the API will set the default attributes.
4502: -- Standard OUT Parameters :

Line 4499: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

4495: --
4496: -- Standard IN Parameters :
4497: -- p_api_version IN NUMBER Required
4498: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
4499: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
4500: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
4501: -- Based on this flag, the API will set the default attributes.
4502: -- Standard OUT Parameters :
4503: -- x_return_status OUT VARCHAR2 Required

Line 4500: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

4496: -- Standard IN Parameters :
4497: -- p_api_version IN NUMBER Required
4498: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
4499: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
4500: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
4501: -- Based on this flag, the API will set the default attributes.
4502: -- Standard OUT Parameters :
4503: -- x_return_status OUT VARCHAR2 Required
4504: -- x_msg_count OUT NUMBER Required

Line 4629: IF FND_API.to_boolean(p_init_msg_list)

4625:
4626: -- Standard Start of API savepoint
4627: SAVEPOINT Material_Notification;
4628: -- Initialize message list if p_init_msg_list is set to TRUE.
4629: IF FND_API.to_boolean(p_init_msg_list)
4630: THEN
4631: FND_MSG_PUB.initialize;
4632: END IF;
4633: -- Initialize API return status to success

Line 4634: x_return_status := FND_API.G_RET_STS_SUCCESS;

4630: THEN
4631: FND_MSG_PUB.initialize;
4632: END IF;
4633: -- Initialize API return status to success
4634: x_return_status := FND_API.G_RET_STS_SUCCESS;
4635: -- Standard call to check for call compatibility.
4636: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
4637: l_api_version,
4638: l_api_name,G_PKG_NAME)

Line 4636: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

4632: END IF;
4633: -- Initialize API return status to success
4634: x_return_status := FND_API.G_RET_STS_SUCCESS;
4635: -- Standard call to check for call compatibility.
4636: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
4637: l_api_version,
4638: l_api_name,G_PKG_NAME)
4639: THEN
4640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4636: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
4637: l_api_version,
4638: l_api_name,G_PKG_NAME)
4639: THEN
4640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4641: END IF;
4642:
4643: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4644: fnd_log.string

Line 4686: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

4682: );
4683: END IF;
4684:
4685: -- Check Error Message stack.
4686: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
4687: RAISE FND_API.G_EXC_ERROR;
4688: END IF;
4689:
4690: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 4687: RAISE FND_API.G_EXC_ERROR;

4683: END IF;
4684:
4685: -- Check Error Message stack.
4686: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
4687: RAISE FND_API.G_EXC_ERROR;
4688: END IF;
4689:
4690: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4691: fnd_log.string

Line 4764: l_return_status := FND_API.G_RET_STS_SUCCESS;

4760: l_subject := fnd_message.get;
4761:
4762: l_role_name:=l_rec.approver_name;
4763:
4764: l_return_status := FND_API.G_RET_STS_SUCCESS;
4765:
4766: l_notif_id := WF_NOTIFICATION.Send
4767: ( role => l_role_name
4768: , msg_type => l_item_type

Line 4798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4794: END IF;
4795:
4796:
4797: EXCEPTION
4798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4799: ROLLBACK TO Material_Notification;
4800: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4801: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
4802: p_count => x_msg_count,

Line 4800: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4796:
4797: EXCEPTION
4798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4799: ROLLBACK TO Material_Notification;
4800: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4801: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
4802: p_count => x_msg_count,
4803: p_data => x_msg_data);
4804:

Line 4801: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

4797: EXCEPTION
4798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4799: ROLLBACK TO Material_Notification;
4800: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4801: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
4802: p_count => x_msg_count,
4803: p_data => x_msg_data);
4804:
4805: WHEN FND_API.G_EXC_ERROR THEN

Line 4805: WHEN FND_API.G_EXC_ERROR THEN

4801: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
4802: p_count => x_msg_count,
4803: p_data => x_msg_data);
4804:
4805: WHEN FND_API.G_EXC_ERROR THEN
4806: ROLLBACK TO MATERIAL_NOTIFICATION;
4807: X_return_status := FND_API.G_RET_STS_ERROR;
4808: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
4809: p_count => x_msg_count,

Line 4807: X_return_status := FND_API.G_RET_STS_ERROR;

4803: p_data => x_msg_data);
4804:
4805: WHEN FND_API.G_EXC_ERROR THEN
4806: ROLLBACK TO MATERIAL_NOTIFICATION;
4807: X_return_status := FND_API.G_RET_STS_ERROR;
4808: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
4809: p_count => x_msg_count,
4810: p_data => X_msg_data);
4811: WHEN OTHERS THEN

Line 4808: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

4804:
4805: WHEN FND_API.G_EXC_ERROR THEN
4806: ROLLBACK TO MATERIAL_NOTIFICATION;
4807: X_return_status := FND_API.G_RET_STS_ERROR;
4808: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
4809: p_count => x_msg_count,
4810: p_data => X_msg_data);
4811: WHEN OTHERS THEN
4812: ROLLBACK TO Material_Notification;

Line 4813: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4809: p_count => x_msg_count,
4810: p_data => X_msg_data);
4811: WHEN OTHERS THEN
4812: ROLLBACK TO Material_Notification;
4813: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4814: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4815: THEN
4816: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
4817: p_procedure_name => 'MATERIAL_NOTIFICATION',

Line 4820: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

4816: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
4817: p_procedure_name => 'MATERIAL_NOTIFICATION',
4818: p_error_text => SUBSTR(SQLERRM,1,240));
4819: END IF;
4820: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
4821: p_count => x_msg_count,
4822: p_data => X_msg_data);
4823:
4824: END Material_Notification;

Line 4844: ELSIF (p_req_material_rec.ATTRIBUTE_CATEGORY = FND_API.G_MISS_CHAR)THEN

4840: BEGIN
4841: fnd_dflex.get_flexfield('AHL', 'Material Reqmt Flex Field', flexfield, flexinfo);
4842: IF(p_req_material_rec.ATTRIBUTE_CATEGORY IS NULL)THEN
4843: flex_fields_defaults.ATTRIBUTE_CATEGORY := flexinfo.default_context_value;
4844: ELSIF (p_req_material_rec.ATTRIBUTE_CATEGORY = FND_API.G_MISS_CHAR)THEN
4845: flex_fields_defaults.ATTRIBUTE_CATEGORY := NULL;
4846: ELSE
4847: flex_fields_defaults.ATTRIBUTE_CATEGORY := p_req_material_rec.ATTRIBUTE_CATEGORY;
4848: END IF;