[Home] [Help]
1194: -- update_wip_job api
1195: -- Pre-reqs :
1196: -- Parameters :
1197: --
1198: -- Standard IN Parameters :
1199: -- p_api_version IN NUMBER Required
1200: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1201: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1202: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1202: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1203: -- p_module_type IN VARCHAR2 Default NULL
1204: -- p_interface_flag IN VARCHAR2,
1205: --
1206: -- Standard OUT Parameters :
1207: -- x_return_status OUT VARCHAR2 Required
1208: -- x_msg_count OUT NUMBER Required
1209: -- x_msg_data OUT VARCHAR2 Required
1210: --
1412: --sukhwsin::VCP Integration variable declaration - end
1413: l_error_flag BOOLEAN := TRUE;
1414: BEGIN
1415: --------------------Initialize ----------------------------------
1416: -- Standard Start of API savepoint
1417: SAVEPOINT create_material_reqst;
1418: -- Check if API is called in debug mode. If yes, enable debug.
1419: IF G_DEBUG='Y' THEN
1420: AHL_DEBUG_PUB.enable_debug;
1424: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. create material reqst','+PPMRP+');
1425: AHL_DEBUG_PUB.debug( 'INTERAFCE FALG'||p_interface_flag);
1426: AHL_DEBUG_PUB.debug( 'Total Number Records:'||p_x_req_material_tbl.COUNT);
1427: END IF;
1428: -- Standard call to check for call compatibility.
1429: IF FND_API.to_boolean(l_init_msg_list)
1430: THEN
1431: FND_MSG_PUB.initialize;
1432: END IF;
1965: p_x_req_material_tbl(i).STATUS := 'IN-SERVICE';
1966: END IF;
1967: -- OGMA issue # 105 - end
1968: -- dbms_output.put_line( 'after uom conversion UOM:'||p_x_req_material_tbl(i).uom_code);
1969: -- Standard call to get message count and if count is get message info.
1970: l_msg_count := FND_MSG_PUB.count_msg;
1971: IF l_msg_count > 0 THEN
1972: X_msg_count := l_msg_count;
1973: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2763: END LOOP;
2764: END IF;
2765: --sukhwsin::VCP Integration - Code Changes ends
2766: ------------------------End of Body---------------------------------------
2767: --Standard check to count messages
2768: l_msg_count := Fnd_Msg_Pub.count_msg;
2769: IF l_msg_count > 0 THEN
2770: X_msg_count := l_msg_count;
2771: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2770: X_msg_count := l_msg_count;
2771: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2772: RAISE Fnd_Api.G_EXC_ERROR;
2773: END IF;
2774: --Standard check for commit
2775: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
2776: COMMIT;
2777: END IF;
2778: -- Debug info
2838: -- it calls Eam Api
2839: -- Pre-reqs :
2840: -- Parameters :
2841: --
2842: -- Standard IN Parameters :
2843: -- p_api_version IN NUMBER Required
2844: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2845: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2846: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2846: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2847: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
2848: -- p_module_type IN VARCHAR2 Default NULL.
2849: --
2850: -- Standard OUT Parameters :
2851: -- x_return_status OUT VARCHAR2 Required
2852: -- x_msg_count OUT NUMBER Required
2853: -- x_msg_data OUT VARCHAR2 Required
2854: --
3009: j NUMBER;
3010: --
3011: BEGIN
3012: --------------------Initialize ----------------------------------
3013: -- Standard Start of API savepoint
3014: SAVEPOINT update_material_reqst;
3015: -- Check if API is called in debug mode. If yes, enable debug.
3016: IF G_DEBUG='Y' THEN
3017: AHL_DEBUG_PUB.enable_debug;
3017: AHL_DEBUG_PUB.enable_debug;
3018: -- Debug info.
3019: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. update material reqst','+PPMRP+');
3020: END IF;
3021: -- Standard call to check for call compatibility.
3022: IF FND_API.to_boolean(p_init_msg_list)
3023: THEN
3024: FND_MSG_PUB.initialize;
3025: END IF;
3240: --
3241: ELSE
3242: p_x_req_material_tbl(i).requested_date := l_req_material_rec.requested_date;
3243: END IF; --Module type
3244: --Standard check to count messages
3245: l_msg_count := Fnd_Msg_Pub.count_msg;
3246: IF l_msg_count > 0 THEN
3247: X_msg_count := l_msg_count;
3248: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3682: AHL_DEBUG_PUB.debug( 'END OF UPDATE PROCESS');
3683: END IF;
3684: --
3685: ------------------------End of Body---------------------------------------
3686: --Standard check to count messages
3687: l_msg_count := Fnd_Msg_Pub.count_msg;
3688: --Change made on Nov 17, 2005 by jeli due to bug 4742895.
3689: --Ignore messages in stack if return status is S after calls to EAM APIs.
3690: /*
3693: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3694: RAISE Fnd_Api.G_EXC_ERROR;
3695: END IF;
3696: */
3697: --Standard check for commit
3698: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
3699: COMMIT;
3700: END IF;
3701: -- Debug info
3760: -- Calls Eam APi to remove material request
3761: -- Pre-reqs :
3762: -- Parameters :
3763: --
3764: -- Standard IN Parameters :
3765: -- p_api_version IN NUMBER Required
3766: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3767: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3768: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3768: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3769: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
3770: -- p_module_type IN VARCHAR2 Default NULL.
3771: --
3772: -- Standard OUT Parameters :
3773: -- x_return_status OUT VARCHAR2 Required
3774: -- x_msg_count OUT NUMBER Required
3775: -- x_msg_data OUT VARCHAR2 Required
3776: --
3893: WHERE MRV.INVENTORY_ITEM_ID = c_item_id
3894: AND MRV.EXTERNAL_SOURCE_CODE = 'AHL'
3895: AND MRV.DEMAND_SOURCE_HEADER_ID = c_wip_entity_id
3896: AND MRV.DEMAND_SOURCE_LINE_ID = c_oper_seq_num;
3897: -- Standard local variable
3898: l_api_name CONSTANT VARCHAR2(30) := 'REMOVE_MATERIAL_REQUEST';
3899: l_api_version CONSTANT NUMBER := 1.0;
3900: l_return_status VARCHAR2(1);
3901: l_msg_data VARCHAR2(200);
3919: l_wo_status VARCHAR2(30);
3920: -- Bug # 6680137 - end
3921: BEGIN
3922: --------------------Initialize ----------------------------------
3923: -- Standard Start of API savepoint
3924: SAVEPOINT remove_material_request;
3925: -- Check if API is called in debug mode. If yes, enable debug.
3926: IF G_DEBUG='Y' THEN
3927: Ahl_Debug_Pub.enable_debug;
3928: -- Debug info.
3929: Ahl_Debug_Pub.debug( 'enter ahl_pp_materials_pvt Remove Material Request ','+MAATP+');
3930: --
3931: END IF;
3932: -- Standard call to check for call compatibility.
3933: IF Fnd_Api.to_boolean(p_init_msg_list)
3934: THEN
3935: Fnd_Msg_Pub.initialize;
3936: END IF;
4021: RAISE Fnd_Api.G_EXC_ERROR;
4022: END IF;
4023: --
4024: END IF;
4025: --Standard check to count messages
4026: l_msg_count := Fnd_Msg_Pub.count_msg;
4027: IF l_msg_count > 0 THEN
4028: X_msg_count := l_msg_count;
4029: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4148: RAISE Fnd_Api.G_EXC_ERROR;
4149: --
4150: END IF; --Status
4151: ---------------------------End of Body---------------------------------------
4152: --Standard check to count messages
4153: l_msg_count := Fnd_Msg_Pub.count_msg;
4154: --Change made on Nov 17, 2005 by jeli due to bug 4742895.
4155: --Ignore messages in stack if return status is S after calls to EAM APIs.
4156: /*
4159: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4160: RAISE Fnd_Api.G_EXC_ERROR;
4161: END IF;
4162: */
4163: --Standard check for commit
4164: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
4165: COMMIT;
4166: END IF;
4167: -- Debug info
4227: -- needs to be changed.
4228: -- Pre-reqs :
4229: -- Parameters :
4230: --
4231: -- Standard IN Parameters :
4232: -- p_api_version IN NUMBER Required
4233: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
4234: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
4235: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
4234: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
4235: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
4236: -- p_module_type IN VARCHAR2 Default NULL.
4237: --
4238: -- Standard OUT Parameters :
4239: -- x_return_status OUT VARCHAR2 Required
4240: -- x_msg_count OUT NUMBER Required
4241: -- x_msg_data OUT VARCHAR2 Required
4242: --
4330: FROM mtl_system_items_kfv
4331: WHERE inventory_item_id = c_inventory_item_id
4332: AND organization_id = c_organization_id;
4333:
4334: -- Standard local variable
4335: l_api_name CONSTANT VARCHAR2(30) := 'Change_Requirement_Item';
4336: l_api_version CONSTANT NUMBER := 1.0;
4337: l_return_status VARCHAR2(1);
4338: l_msg_data VARCHAR2(200);
4358: l_item_name VARCHAR2(80);
4359:
4360: BEGIN
4361: --------------------Initialize ----------------------------------
4362: -- Standard Start of API savepoint
4363: SAVEPOINT Change_Requirement_Item;
4364:
4365: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4366: fnd_log.string(fnd_log.level_procedure, l_debug_key || '.begin',
4366: fnd_log.string(fnd_log.level_procedure, l_debug_key || '.begin',
4367: 'At the start of PLSQL procedure.');
4368: END IF;
4369:
4370: -- Standard call to check for call compatibility.
4371: IF FND_API.to_boolean(p_init_msg_list)
4372: THEN
4373: FND_MSG_PUB.initialize;
4374: END IF;
4485: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_GT_EQ_SYSD');
4486: Fnd_Msg_Pub.ADD;
4487: END IF;
4488:
4489: --Standard check to count messages
4490: l_msg_count := Fnd_Msg_Pub.count_msg;
4491: IF l_msg_count > 0 THEN
4492: X_msg_count := l_msg_count;
4493: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4764: X_msg_count := l_msg_count;
4765: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4766: RAISE Fnd_Api.G_EXC_ERROR;
4767: END IF;
4768: --Standard check for commit
4769: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
4770: COMMIT;
4771: END IF;
4772: -- Debug info
4810: -- Routine jobs based on operation flag
4811: -- Pre-reqs :
4812: -- Parameters :
4813: --
4814: -- Standard IN Parameters :
4815: -- p_api_version IN NUMBER Required
4816: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
4817: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
4818: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
4818: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
4819: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
4820: -- p_module_type IN VARCHAR2 Default NULL.
4821: --
4822: -- Standard OUT Parameters :
4823: -- x_return_status OUT VARCHAR2 Required
4824: -- x_msg_count OUT NUMBER Required
4825: -- x_msg_data OUT VARCHAR2 Required
4826: --
4871: WHERE schedule_material_id = p_asm_id
4872: AND NVL(aog_flag, 'N') = 'N';
4873: BEGIN
4874: --------------------Initialize ----------------------------------
4875: -- Standard Start of API savepoint
4876: SAVEPOINT process_material_request;
4877: -- Check if API is called in debug mode. If yes, enable debug.
4878: IF G_DEBUG='Y' THEN
4879: AHL_DEBUG_PUB.enable_debug;
4880: -- Debug info.
4881: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt.process material request','+PPMRP+');
4882: --
4883: END IF;
4884: -- Standard call to check for call compatibility.
4885: IF FND_API.to_boolean(p_init_msg_list)
4886: THEN
4887: FND_MSG_PUB.initialize;
4888: END IF;
5099: END IF;
5100: END IF;
5101:
5102: ------------------------End of Body---------------------------------------
5103: --Standard check to count messages
5104: l_msg_count := Fnd_Msg_Pub.count_msg;
5105: IF l_msg_count > 0 THEN
5106: X_msg_count := l_msg_count;
5107: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5106: X_msg_count := l_msg_count;
5107: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5108: RAISE Fnd_Api.G_EXC_ERROR;
5109: END IF;
5110: --Standard check for commit
5111: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
5112: COMMIT;
5113: END IF;
5114: -- Debug info
5276: -- p_cost_basis_code IN NUMBER Default NULL,
5277: -- p_total_required IN NUMBER Default NULL,
5278: -- p_assigned_units IN NUMBER Default NULL,
5279: -- p_autocharge_type_code IN NUMBER Default NULL,
5280: -- p_standard_rate_flag_code IN NUMBER Default NULL,
5281: -- p_applied_resource_units IN NUMBER Default NULL,
5282: -- p_applied_resource_value IN NUMBER Default NULL,
5283: -- p_inventory_item_id IN NUMBER Default NULL,
5284: -- p_scheduled_quantity IN NUMBER Default NULL,
5335: p_cost_basis_code IN NUMBER := NULL,
5336: p_total_required IN NUMBER := NULL,
5337: p_assigned_units IN NUMBER := NULL,
5338: p_autocharge_type_code IN NUMBER := NULL,
5339: p_standard_rate_flag_code IN NUMBER := NULL,
5340: p_applied_resource_units IN NUMBER := NULL,
5341: p_applied_resource_value IN NUMBER := NULL,
5342: p_inventory_item_id IN NUMBER := NULL,
5343: p_scheduled_quantity IN NUMBER := NULL,
5391: cost_basis_code ,
5392: total_required ,
5393: assigned_units ,
5394: autocharge_type_code ,
5395: standard_rate_flag_code ,
5396: applied_resource_units ,
5397: applied_resource_value ,
5398: inventory_item_id ,
5399: scheduled_quantity ,
5446: p_cost_basis_code ,
5447: p_total_required ,
5448: p_assigned_units ,
5449: p_autocharge_type_code ,
5450: p_standard_rate_flag_code ,
5451: p_applied_resource_units ,
5452: p_applied_resource_value ,
5453: p_inventory_item_id ,
5454: p_scheduled_quantity ,
5575: --
5576: -- Pre-reqs :
5577: -- Parameters :
5578: --
5579: -- Standard IN Parameters :
5580: -- p_api_version IN NUMBER Required
5581: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
5582: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
5583: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
5581: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
5582: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
5583: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
5584: -- Based on this flag, the API will set the default attributes.
5585: -- Standard OUT Parameters :
5586: -- x_return_status OUT VARCHAR2 Required
5587: -- x_msg_count OUT NUMBER Required
5588: -- x_msg_data OUT VARCHAR2 Required
5589: --
5688: 'At the start of PLSQL procedure'
5689: );
5690: END IF;
5691: --------------------Initialize ----------------------------------
5692: -- Standard Start of API savepoint
5693: SAVEPOINT Process_Wo_Op_Materials;
5694: -- Standard call to check for call compatibility.
5695: IF FND_API.to_boolean(p_init_msg_list)
5696: THEN
5690: END IF;
5691: --------------------Initialize ----------------------------------
5692: -- Standard Start of API savepoint
5693: SAVEPOINT Process_Wo_Op_Materials;
5694: -- Standard call to check for call compatibility.
5695: IF FND_API.to_boolean(p_init_msg_list)
5696: THEN
5697: FND_MSG_PUB.initialize;
5698: END IF;
6002: IF G_DEBUG='Y' THEN
6003: AHL_DEBUG_PUB.debug( 'x_req_material_tbl.count'||x_req_material_tbl.count);
6004: END IF;
6005: ------------------------End of Body---------------------------------------
6006: --Standard check to count messages
6007: l_msg_count := Fnd_Msg_Pub.count_msg;
6008: IF l_msg_count > 0 THEN
6009: X_msg_count := l_msg_count;
6010: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6009: X_msg_count := l_msg_count;
6010: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6011: RAISE Fnd_Api.G_EXC_ERROR;
6012: END IF;
6013: --Standard check for commit
6014: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
6015: COMMIT;
6016: END IF;
6017: -- Debug info
6058: --
6059: -- Pre-reqs :
6060: -- Parameters :
6061: --
6062: -- Standard IN Parameters :
6063: -- p_api_version IN NUMBER Required
6064: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
6065: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
6066: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
6064: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
6065: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
6066: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
6067: -- Based on this flag, the API will set the default attributes.
6068: -- Standard OUT Parameters :
6069: -- x_return_status OUT VARCHAR2 Required
6070: -- x_msg_count OUT NUMBER Required
6071: -- x_msg_data OUT VARCHAR2 Required
6072: --
6178: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Material_Notification',
6179: 'At the start of PLSQL procedure'
6180: );
6181: END IF;
6182: -- Standard Start of API savepoint
6183: SAVEPOINT Material_Notification;
6184: -- Initialize message list if p_init_msg_list is set to TRUE.
6185: IF FND_API.to_boolean(p_init_msg_list)
6186: THEN
6187: FND_MSG_PUB.initialize;
6188: END IF;
6189: -- Initialize API return status to success
6190: x_return_status := FND_API.G_RET_STS_SUCCESS;
6191: -- Standard call to check for call compatibility.
6192: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
6193: l_api_version,
6194: l_api_name,G_PKG_NAME)
6195: THEN
6429: -- Type : Public
6430: -- Usage : This procedure is used to change item for item group OR position based item requirements.
6431: -- Parameters :
6432: --
6433: -- Standard IN Parameters :
6434: -- p_api_version IN NUMBER Required
6435: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
6436: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
6437: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
6434: -- p_api_version IN NUMBER Required
6435: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
6436: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
6437: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
6438: -- Standard OUT Parameters :
6439: -- x_return_status OUT VARCHAR2 Required
6440: -- x_msg_count OUT NUMBER Required
6441: -- x_msg_data OUT VARCHAR2 Required
6442: --
6507: l_current_mat_dtl_rec Get_WO_Mat_Details%ROWTYPE;
6508: l_uc_header_id NUMBER;
6509:
6510: BEGIN
6511: -- Standard Start of API savepoint
6512: SAVEPOINT Wo_Mat_Req_Item_Change;
6513: -- Check if API is called in debug mode. If yes, enable debug.
6514: IF G_DEBUG='Y' THEN
6515: AHL_DEBUG_PUB.enable_debug;
6517: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt.Wo_Mat_Req_Item_Change','+PPMRP+');
6518: --
6519: END IF;
6520:
6521: -- Standard call to check for call compatibility.
6522: IF FND_API.to_boolean(p_init_msg_list)
6523: THEN
6524: FND_MSG_PUB.initialize;
6525: END IF;
6649: END IF;
6650: END IF;
6651:
6652: ------------------------End of Body---------------------------------------
6653: --Standard check to count messages
6654: l_msg_count := Fnd_Msg_Pub.count_msg;
6655: IF l_msg_count > 0 THEN
6656: X_msg_count := l_msg_count;
6657: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6656: X_msg_count := l_msg_count;
6657: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6658: RAISE Fnd_Api.G_EXC_ERROR;
6659: END IF;
6660: --Standard check for commit
6661: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
6662: COMMIT;
6663: END IF;
6664: -- Debug info