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_PRD_PARTS_CHANGE_PVT dependencies on AHL_DEBUG_PUB

Line 5: G_DEBUG varchar2(1) := AHL_DEBUG_PUB.is_log_enabled;

1: PACKAGE BODY AHL_PRD_PARTS_CHANGE_PVT AS
2: /* $Header: AHLVPPCB.pls 120.12.12020000.2 2012/12/07 08:09:13 sareepar ship $ */
3:
4:
5: G_DEBUG varchar2(1) := AHL_DEBUG_PUB.is_log_enabled;
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PRD_PARTS_CHANGE_PVT';
7: G_CSI_LOCATION_TYPE_CODE CONSTANT VARCHAR2(30) := 'CSI_INST_LOCATION_SOURCE_CODE';
8:
9: -----------------------------------

Line 187: AHL_DEBUG_PUB.enable_debug;

183: x_return_status := FND_API.G_RET_STS_SUCCESS;
184:
185: -- Enable Debug.
186: IF G_DEBUG = 'Y' THEN
187: AHL_DEBUG_PUB.enable_debug;
188: END IF;
189:
190: -- Add debug mesg.
191: IF G_DEBUG = 'Y' THEN

Line 192: AHL_DEBUG_PUB.debug('Begin private API:' || G_PKG_NAME || '.' || l_api_name);

188: END IF;
189:
190: -- Add debug mesg.
191: IF G_DEBUG = 'Y' THEN
192: AHL_DEBUG_PUB.debug('Begin private API:' || G_PKG_NAME || '.' || l_api_name);
193: END IF;
194:
195: --Loop through the table record
196: IF ( p_x_parts_rec_tbl.COUNT > 0) THEN

Line 199: AHL_DEBUG_PUB.debug('Input parameter dump for record:'|| i);

195: --Loop through the table record
196: IF ( p_x_parts_rec_tbl.COUNT > 0) THEN
197: FOR i IN p_x_parts_rec_tbl.FIRST..p_x_parts_rec_tbl.LAST LOOP
198: IF G_DEBUG = 'Y' THEN
199: AHL_DEBUG_PUB.debug('Input parameter dump for record:'|| i);
200: AHL_DEBUG_PUB.debug('Input Workorder_Id:' || p_x_parts_rec_tbl(i).Workorder_Id);
201: AHL_DEBUG_PUB.debug('Input Operation_Sequence_Num:'|| p_x_parts_rec_tbl(i).Operation_Sequence_Num );
202: AHL_DEBUG_PUB.debug('Input workorder_operation_id:'|| p_x_parts_rec_tbl(i).workorder_operation_id);
203: AHL_DEBUG_PUB.debug('Input Unit_Config_Header_Id:'|| p_x_parts_rec_tbl(i).Unit_Config_Header_Id);

Line 200: AHL_DEBUG_PUB.debug('Input Workorder_Id:' || p_x_parts_rec_tbl(i).Workorder_Id);

196: IF ( p_x_parts_rec_tbl.COUNT > 0) THEN
197: FOR i IN p_x_parts_rec_tbl.FIRST..p_x_parts_rec_tbl.LAST LOOP
198: IF G_DEBUG = 'Y' THEN
199: AHL_DEBUG_PUB.debug('Input parameter dump for record:'|| i);
200: AHL_DEBUG_PUB.debug('Input Workorder_Id:' || p_x_parts_rec_tbl(i).Workorder_Id);
201: AHL_DEBUG_PUB.debug('Input Operation_Sequence_Num:'|| p_x_parts_rec_tbl(i).Operation_Sequence_Num );
202: AHL_DEBUG_PUB.debug('Input workorder_operation_id:'|| p_x_parts_rec_tbl(i).workorder_operation_id);
203: AHL_DEBUG_PUB.debug('Input Unit_Config_Header_Id:'|| p_x_parts_rec_tbl(i).Unit_Config_Header_Id);
204: AHL_DEBUG_PUB.debug('Input Unit_Config_Name:'|| p_x_parts_rec_tbl(i).Unit_Config_Name);

Line 201: AHL_DEBUG_PUB.debug('Input Operation_Sequence_Num:'|| p_x_parts_rec_tbl(i).Operation_Sequence_Num );

197: FOR i IN p_x_parts_rec_tbl.FIRST..p_x_parts_rec_tbl.LAST LOOP
198: IF G_DEBUG = 'Y' THEN
199: AHL_DEBUG_PUB.debug('Input parameter dump for record:'|| i);
200: AHL_DEBUG_PUB.debug('Input Workorder_Id:' || p_x_parts_rec_tbl(i).Workorder_Id);
201: AHL_DEBUG_PUB.debug('Input Operation_Sequence_Num:'|| p_x_parts_rec_tbl(i).Operation_Sequence_Num );
202: AHL_DEBUG_PUB.debug('Input workorder_operation_id:'|| p_x_parts_rec_tbl(i).workorder_operation_id);
203: AHL_DEBUG_PUB.debug('Input Unit_Config_Header_Id:'|| p_x_parts_rec_tbl(i).Unit_Config_Header_Id);
204: AHL_DEBUG_PUB.debug('Input Unit_Config_Name:'|| p_x_parts_rec_tbl(i).Unit_Config_Name);
205: AHL_DEBUG_PUB.debug('Input Unit_config_obj_ver_num:' || p_x_parts_rec_tbl(i).Unit_config_obj_ver_num);

Line 202: AHL_DEBUG_PUB.debug('Input workorder_operation_id:'|| p_x_parts_rec_tbl(i).workorder_operation_id);

198: IF G_DEBUG = 'Y' THEN
199: AHL_DEBUG_PUB.debug('Input parameter dump for record:'|| i);
200: AHL_DEBUG_PUB.debug('Input Workorder_Id:' || p_x_parts_rec_tbl(i).Workorder_Id);
201: AHL_DEBUG_PUB.debug('Input Operation_Sequence_Num:'|| p_x_parts_rec_tbl(i).Operation_Sequence_Num );
202: AHL_DEBUG_PUB.debug('Input workorder_operation_id:'|| p_x_parts_rec_tbl(i).workorder_operation_id);
203: AHL_DEBUG_PUB.debug('Input Unit_Config_Header_Id:'|| p_x_parts_rec_tbl(i).Unit_Config_Header_Id);
204: AHL_DEBUG_PUB.debug('Input Unit_Config_Name:'|| p_x_parts_rec_tbl(i).Unit_Config_Name);
205: AHL_DEBUG_PUB.debug('Input Unit_config_obj_ver_num:' || p_x_parts_rec_tbl(i).Unit_config_obj_ver_num);
206: AHL_DEBUG_PUB.debug('Input Mc_Relationship_Id:' || p_x_parts_rec_tbl(i).Mc_Relationship_Id);

Line 203: AHL_DEBUG_PUB.debug('Input Unit_Config_Header_Id:'|| p_x_parts_rec_tbl(i).Unit_Config_Header_Id);

199: AHL_DEBUG_PUB.debug('Input parameter dump for record:'|| i);
200: AHL_DEBUG_PUB.debug('Input Workorder_Id:' || p_x_parts_rec_tbl(i).Workorder_Id);
201: AHL_DEBUG_PUB.debug('Input Operation_Sequence_Num:'|| p_x_parts_rec_tbl(i).Operation_Sequence_Num );
202: AHL_DEBUG_PUB.debug('Input workorder_operation_id:'|| p_x_parts_rec_tbl(i).workorder_operation_id);
203: AHL_DEBUG_PUB.debug('Input Unit_Config_Header_Id:'|| p_x_parts_rec_tbl(i).Unit_Config_Header_Id);
204: AHL_DEBUG_PUB.debug('Input Unit_Config_Name:'|| p_x_parts_rec_tbl(i).Unit_Config_Name);
205: AHL_DEBUG_PUB.debug('Input Unit_config_obj_ver_num:' || p_x_parts_rec_tbl(i).Unit_config_obj_ver_num);
206: AHL_DEBUG_PUB.debug('Input Mc_Relationship_Id:' || p_x_parts_rec_tbl(i).Mc_Relationship_Id);
207: AHL_DEBUG_PUB.debug('Input Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Installed_Instance_Id);

Line 204: AHL_DEBUG_PUB.debug('Input Unit_Config_Name:'|| p_x_parts_rec_tbl(i).Unit_Config_Name);

200: AHL_DEBUG_PUB.debug('Input Workorder_Id:' || p_x_parts_rec_tbl(i).Workorder_Id);
201: AHL_DEBUG_PUB.debug('Input Operation_Sequence_Num:'|| p_x_parts_rec_tbl(i).Operation_Sequence_Num );
202: AHL_DEBUG_PUB.debug('Input workorder_operation_id:'|| p_x_parts_rec_tbl(i).workorder_operation_id);
203: AHL_DEBUG_PUB.debug('Input Unit_Config_Header_Id:'|| p_x_parts_rec_tbl(i).Unit_Config_Header_Id);
204: AHL_DEBUG_PUB.debug('Input Unit_Config_Name:'|| p_x_parts_rec_tbl(i).Unit_Config_Name);
205: AHL_DEBUG_PUB.debug('Input Unit_config_obj_ver_num:' || p_x_parts_rec_tbl(i).Unit_config_obj_ver_num);
206: AHL_DEBUG_PUB.debug('Input Mc_Relationship_Id:' || p_x_parts_rec_tbl(i).Mc_Relationship_Id);
207: AHL_DEBUG_PUB.debug('Input Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Installed_Instance_Id);
208: AHL_DEBUG_PUB.debug('Input Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Installed_Instance_Num);

Line 205: AHL_DEBUG_PUB.debug('Input Unit_config_obj_ver_num:' || p_x_parts_rec_tbl(i).Unit_config_obj_ver_num);

201: AHL_DEBUG_PUB.debug('Input Operation_Sequence_Num:'|| p_x_parts_rec_tbl(i).Operation_Sequence_Num );
202: AHL_DEBUG_PUB.debug('Input workorder_operation_id:'|| p_x_parts_rec_tbl(i).workorder_operation_id);
203: AHL_DEBUG_PUB.debug('Input Unit_Config_Header_Id:'|| p_x_parts_rec_tbl(i).Unit_Config_Header_Id);
204: AHL_DEBUG_PUB.debug('Input Unit_Config_Name:'|| p_x_parts_rec_tbl(i).Unit_Config_Name);
205: AHL_DEBUG_PUB.debug('Input Unit_config_obj_ver_num:' || p_x_parts_rec_tbl(i).Unit_config_obj_ver_num);
206: AHL_DEBUG_PUB.debug('Input Mc_Relationship_Id:' || p_x_parts_rec_tbl(i).Mc_Relationship_Id);
207: AHL_DEBUG_PUB.debug('Input Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Installed_Instance_Id);
208: AHL_DEBUG_PUB.debug('Input Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Installed_Instance_Num);
209: AHL_DEBUG_PUB.debug('Input Installation_date:' || p_x_parts_rec_tbl(i).Installation_date);

Line 206: AHL_DEBUG_PUB.debug('Input Mc_Relationship_Id:' || p_x_parts_rec_tbl(i).Mc_Relationship_Id);

202: AHL_DEBUG_PUB.debug('Input workorder_operation_id:'|| p_x_parts_rec_tbl(i).workorder_operation_id);
203: AHL_DEBUG_PUB.debug('Input Unit_Config_Header_Id:'|| p_x_parts_rec_tbl(i).Unit_Config_Header_Id);
204: AHL_DEBUG_PUB.debug('Input Unit_Config_Name:'|| p_x_parts_rec_tbl(i).Unit_Config_Name);
205: AHL_DEBUG_PUB.debug('Input Unit_config_obj_ver_num:' || p_x_parts_rec_tbl(i).Unit_config_obj_ver_num);
206: AHL_DEBUG_PUB.debug('Input Mc_Relationship_Id:' || p_x_parts_rec_tbl(i).Mc_Relationship_Id);
207: AHL_DEBUG_PUB.debug('Input Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Installed_Instance_Id);
208: AHL_DEBUG_PUB.debug('Input Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Installed_Instance_Num);
209: AHL_DEBUG_PUB.debug('Input Installation_date:' || p_x_parts_rec_tbl(i).Installation_date);
210: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Id);

Line 207: AHL_DEBUG_PUB.debug('Input Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Installed_Instance_Id);

203: AHL_DEBUG_PUB.debug('Input Unit_Config_Header_Id:'|| p_x_parts_rec_tbl(i).Unit_Config_Header_Id);
204: AHL_DEBUG_PUB.debug('Input Unit_Config_Name:'|| p_x_parts_rec_tbl(i).Unit_Config_Name);
205: AHL_DEBUG_PUB.debug('Input Unit_config_obj_ver_num:' || p_x_parts_rec_tbl(i).Unit_config_obj_ver_num);
206: AHL_DEBUG_PUB.debug('Input Mc_Relationship_Id:' || p_x_parts_rec_tbl(i).Mc_Relationship_Id);
207: AHL_DEBUG_PUB.debug('Input Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Installed_Instance_Id);
208: AHL_DEBUG_PUB.debug('Input Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Installed_Instance_Num);
209: AHL_DEBUG_PUB.debug('Input Installation_date:' || p_x_parts_rec_tbl(i).Installation_date);
210: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Id);
211: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Num);

Line 208: AHL_DEBUG_PUB.debug('Input Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Installed_Instance_Num);

204: AHL_DEBUG_PUB.debug('Input Unit_Config_Name:'|| p_x_parts_rec_tbl(i).Unit_Config_Name);
205: AHL_DEBUG_PUB.debug('Input Unit_config_obj_ver_num:' || p_x_parts_rec_tbl(i).Unit_config_obj_ver_num);
206: AHL_DEBUG_PUB.debug('Input Mc_Relationship_Id:' || p_x_parts_rec_tbl(i).Mc_Relationship_Id);
207: AHL_DEBUG_PUB.debug('Input Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Installed_Instance_Id);
208: AHL_DEBUG_PUB.debug('Input Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Installed_Instance_Num);
209: AHL_DEBUG_PUB.debug('Input Installation_date:' || p_x_parts_rec_tbl(i).Installation_date);
210: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Id);
211: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Num);
212: AHL_DEBUG_PUB.debug('Input Removed_Instance_Id:' || p_x_parts_rec_tbl(i).Removed_Instance_Id);

Line 209: AHL_DEBUG_PUB.debug('Input Installation_date:' || p_x_parts_rec_tbl(i).Installation_date);

205: AHL_DEBUG_PUB.debug('Input Unit_config_obj_ver_num:' || p_x_parts_rec_tbl(i).Unit_config_obj_ver_num);
206: AHL_DEBUG_PUB.debug('Input Mc_Relationship_Id:' || p_x_parts_rec_tbl(i).Mc_Relationship_Id);
207: AHL_DEBUG_PUB.debug('Input Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Installed_Instance_Id);
208: AHL_DEBUG_PUB.debug('Input Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Installed_Instance_Num);
209: AHL_DEBUG_PUB.debug('Input Installation_date:' || p_x_parts_rec_tbl(i).Installation_date);
210: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Id);
211: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Num);
212: AHL_DEBUG_PUB.debug('Input Removed_Instance_Id:' || p_x_parts_rec_tbl(i).Removed_Instance_Id);
213: AHL_DEBUG_PUB.debug('Input Removed_Instance_Num:' || p_x_parts_rec_tbl(i).Removed_Instance_Num);

Line 210: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Id);

206: AHL_DEBUG_PUB.debug('Input Mc_Relationship_Id:' || p_x_parts_rec_tbl(i).Mc_Relationship_Id);
207: AHL_DEBUG_PUB.debug('Input Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Installed_Instance_Id);
208: AHL_DEBUG_PUB.debug('Input Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Installed_Instance_Num);
209: AHL_DEBUG_PUB.debug('Input Installation_date:' || p_x_parts_rec_tbl(i).Installation_date);
210: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Id);
211: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Num);
212: AHL_DEBUG_PUB.debug('Input Removed_Instance_Id:' || p_x_parts_rec_tbl(i).Removed_Instance_Id);
213: AHL_DEBUG_PUB.debug('Input Removed_Instance_Num:' || p_x_parts_rec_tbl(i).Removed_Instance_Num);
214: AHL_DEBUG_PUB.debug('Input Removal_Code:' || p_x_parts_rec_tbl(i).Removal_Code);

Line 211: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Num);

207: AHL_DEBUG_PUB.debug('Input Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Installed_Instance_Id);
208: AHL_DEBUG_PUB.debug('Input Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Installed_Instance_Num);
209: AHL_DEBUG_PUB.debug('Input Installation_date:' || p_x_parts_rec_tbl(i).Installation_date);
210: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Id);
211: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Num);
212: AHL_DEBUG_PUB.debug('Input Removed_Instance_Id:' || p_x_parts_rec_tbl(i).Removed_Instance_Id);
213: AHL_DEBUG_PUB.debug('Input Removed_Instance_Num:' || p_x_parts_rec_tbl(i).Removed_Instance_Num);
214: AHL_DEBUG_PUB.debug('Input Removal_Code:' || p_x_parts_rec_tbl(i).Removal_Code);
215: AHL_DEBUG_PUB.debug('Input Removal_Meaning:'|| p_x_parts_rec_tbl(i).Removal_Meaning);

Line 212: AHL_DEBUG_PUB.debug('Input Removed_Instance_Id:' || p_x_parts_rec_tbl(i).Removed_Instance_Id);

208: AHL_DEBUG_PUB.debug('Input Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Installed_Instance_Num);
209: AHL_DEBUG_PUB.debug('Input Installation_date:' || p_x_parts_rec_tbl(i).Installation_date);
210: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Id);
211: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Num);
212: AHL_DEBUG_PUB.debug('Input Removed_Instance_Id:' || p_x_parts_rec_tbl(i).Removed_Instance_Id);
213: AHL_DEBUG_PUB.debug('Input Removed_Instance_Num:' || p_x_parts_rec_tbl(i).Removed_Instance_Num);
214: AHL_DEBUG_PUB.debug('Input Removal_Code:' || p_x_parts_rec_tbl(i).Removal_Code);
215: AHL_DEBUG_PUB.debug('Input Removal_Meaning:'|| p_x_parts_rec_tbl(i).Removal_Meaning);
216: AHL_DEBUG_PUB.debug('Input Removal_Reason_Id:'|| p_x_parts_rec_tbl(i).Removal_Reason_Id);

Line 213: AHL_DEBUG_PUB.debug('Input Removed_Instance_Num:' || p_x_parts_rec_tbl(i).Removed_Instance_Num);

209: AHL_DEBUG_PUB.debug('Input Installation_date:' || p_x_parts_rec_tbl(i).Installation_date);
210: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Id);
211: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Num);
212: AHL_DEBUG_PUB.debug('Input Removed_Instance_Id:' || p_x_parts_rec_tbl(i).Removed_Instance_Id);
213: AHL_DEBUG_PUB.debug('Input Removed_Instance_Num:' || p_x_parts_rec_tbl(i).Removed_Instance_Num);
214: AHL_DEBUG_PUB.debug('Input Removal_Code:' || p_x_parts_rec_tbl(i).Removal_Code);
215: AHL_DEBUG_PUB.debug('Input Removal_Meaning:'|| p_x_parts_rec_tbl(i).Removal_Meaning);
216: AHL_DEBUG_PUB.debug('Input Removal_Reason_Id:'|| p_x_parts_rec_tbl(i).Removal_Reason_Id);
217: AHL_DEBUG_PUB.debug('Input Removal_Reason_Name:' || p_x_parts_rec_tbl(i).Removal_Reason_Name);

Line 214: AHL_DEBUG_PUB.debug('Input Removal_Code:' || p_x_parts_rec_tbl(i).Removal_Code);

210: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Id);
211: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Num);
212: AHL_DEBUG_PUB.debug('Input Removed_Instance_Id:' || p_x_parts_rec_tbl(i).Removed_Instance_Id);
213: AHL_DEBUG_PUB.debug('Input Removed_Instance_Num:' || p_x_parts_rec_tbl(i).Removed_Instance_Num);
214: AHL_DEBUG_PUB.debug('Input Removal_Code:' || p_x_parts_rec_tbl(i).Removal_Code);
215: AHL_DEBUG_PUB.debug('Input Removal_Meaning:'|| p_x_parts_rec_tbl(i).Removal_Meaning);
216: AHL_DEBUG_PUB.debug('Input Removal_Reason_Id:'|| p_x_parts_rec_tbl(i).Removal_Reason_Id);
217: AHL_DEBUG_PUB.debug('Input Removal_Reason_Name:' || p_x_parts_rec_tbl(i).Removal_Reason_Name);
218: AHL_DEBUG_PUB.debug('Input Removal_Date:' || p_x_parts_rec_tbl(i).Removal_Date);

Line 215: AHL_DEBUG_PUB.debug('Input Removal_Meaning:'|| p_x_parts_rec_tbl(i).Removal_Meaning);

211: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Num);
212: AHL_DEBUG_PUB.debug('Input Removed_Instance_Id:' || p_x_parts_rec_tbl(i).Removed_Instance_Id);
213: AHL_DEBUG_PUB.debug('Input Removed_Instance_Num:' || p_x_parts_rec_tbl(i).Removed_Instance_Num);
214: AHL_DEBUG_PUB.debug('Input Removal_Code:' || p_x_parts_rec_tbl(i).Removal_Code);
215: AHL_DEBUG_PUB.debug('Input Removal_Meaning:'|| p_x_parts_rec_tbl(i).Removal_Meaning);
216: AHL_DEBUG_PUB.debug('Input Removal_Reason_Id:'|| p_x_parts_rec_tbl(i).Removal_Reason_Id);
217: AHL_DEBUG_PUB.debug('Input Removal_Reason_Name:' || p_x_parts_rec_tbl(i).Removal_Reason_Name);
218: AHL_DEBUG_PUB.debug('Input Removal_Date:' || p_x_parts_rec_tbl(i).Removal_Date);
219: --AHL_DEBUG_PUB.debug('Input Condition_Id:' || p_x_parts_rec_tbl(i).Condition_Id);

Line 216: AHL_DEBUG_PUB.debug('Input Removal_Reason_Id:'|| p_x_parts_rec_tbl(i).Removal_Reason_Id);

212: AHL_DEBUG_PUB.debug('Input Removed_Instance_Id:' || p_x_parts_rec_tbl(i).Removed_Instance_Id);
213: AHL_DEBUG_PUB.debug('Input Removed_Instance_Num:' || p_x_parts_rec_tbl(i).Removed_Instance_Num);
214: AHL_DEBUG_PUB.debug('Input Removal_Code:' || p_x_parts_rec_tbl(i).Removal_Code);
215: AHL_DEBUG_PUB.debug('Input Removal_Meaning:'|| p_x_parts_rec_tbl(i).Removal_Meaning);
216: AHL_DEBUG_PUB.debug('Input Removal_Reason_Id:'|| p_x_parts_rec_tbl(i).Removal_Reason_Id);
217: AHL_DEBUG_PUB.debug('Input Removal_Reason_Name:' || p_x_parts_rec_tbl(i).Removal_Reason_Name);
218: AHL_DEBUG_PUB.debug('Input Removal_Date:' || p_x_parts_rec_tbl(i).Removal_Date);
219: --AHL_DEBUG_PUB.debug('Input Condition_Id:' || p_x_parts_rec_tbl(i).Condition_Id);
220: --AHL_DEBUG_PUB.debug('Input Locator_id:'|| p_x_parts_rec_tbl(i).Locator_id);

Line 217: AHL_DEBUG_PUB.debug('Input Removal_Reason_Name:' || p_x_parts_rec_tbl(i).Removal_Reason_Name);

213: AHL_DEBUG_PUB.debug('Input Removed_Instance_Num:' || p_x_parts_rec_tbl(i).Removed_Instance_Num);
214: AHL_DEBUG_PUB.debug('Input Removal_Code:' || p_x_parts_rec_tbl(i).Removal_Code);
215: AHL_DEBUG_PUB.debug('Input Removal_Meaning:'|| p_x_parts_rec_tbl(i).Removal_Meaning);
216: AHL_DEBUG_PUB.debug('Input Removal_Reason_Id:'|| p_x_parts_rec_tbl(i).Removal_Reason_Id);
217: AHL_DEBUG_PUB.debug('Input Removal_Reason_Name:' || p_x_parts_rec_tbl(i).Removal_Reason_Name);
218: AHL_DEBUG_PUB.debug('Input Removal_Date:' || p_x_parts_rec_tbl(i).Removal_Date);
219: --AHL_DEBUG_PUB.debug('Input Condition_Id:' || p_x_parts_rec_tbl(i).Condition_Id);
220: --AHL_DEBUG_PUB.debug('Input Locator_id:'|| p_x_parts_rec_tbl(i).Locator_id);
221: --AHL_DEBUG_PUB.debug('Input Locator_code:'|| p_x_parts_rec_tbl(i).Locator_code);

Line 218: AHL_DEBUG_PUB.debug('Input Removal_Date:' || p_x_parts_rec_tbl(i).Removal_Date);

214: AHL_DEBUG_PUB.debug('Input Removal_Code:' || p_x_parts_rec_tbl(i).Removal_Code);
215: AHL_DEBUG_PUB.debug('Input Removal_Meaning:'|| p_x_parts_rec_tbl(i).Removal_Meaning);
216: AHL_DEBUG_PUB.debug('Input Removal_Reason_Id:'|| p_x_parts_rec_tbl(i).Removal_Reason_Id);
217: AHL_DEBUG_PUB.debug('Input Removal_Reason_Name:' || p_x_parts_rec_tbl(i).Removal_Reason_Name);
218: AHL_DEBUG_PUB.debug('Input Removal_Date:' || p_x_parts_rec_tbl(i).Removal_Date);
219: --AHL_DEBUG_PUB.debug('Input Condition_Id:' || p_x_parts_rec_tbl(i).Condition_Id);
220: --AHL_DEBUG_PUB.debug('Input Locator_id:'|| p_x_parts_rec_tbl(i).Locator_id);
221: --AHL_DEBUG_PUB.debug('Input Locator_code:'|| p_x_parts_rec_tbl(i).Locator_code);
222: --AHL_DEBUG_PUB.debug('Input Subinventory_code:'|| p_x_parts_rec_tbl(i).Subinventory_code);

Line 219: --AHL_DEBUG_PUB.debug('Input Condition_Id:' || p_x_parts_rec_tbl(i).Condition_Id);

215: AHL_DEBUG_PUB.debug('Input Removal_Meaning:'|| p_x_parts_rec_tbl(i).Removal_Meaning);
216: AHL_DEBUG_PUB.debug('Input Removal_Reason_Id:'|| p_x_parts_rec_tbl(i).Removal_Reason_Id);
217: AHL_DEBUG_PUB.debug('Input Removal_Reason_Name:' || p_x_parts_rec_tbl(i).Removal_Reason_Name);
218: AHL_DEBUG_PUB.debug('Input Removal_Date:' || p_x_parts_rec_tbl(i).Removal_Date);
219: --AHL_DEBUG_PUB.debug('Input Condition_Id:' || p_x_parts_rec_tbl(i).Condition_Id);
220: --AHL_DEBUG_PUB.debug('Input Locator_id:'|| p_x_parts_rec_tbl(i).Locator_id);
221: --AHL_DEBUG_PUB.debug('Input Locator_code:'|| p_x_parts_rec_tbl(i).Locator_code);
222: --AHL_DEBUG_PUB.debug('Input Subinventory_code:'|| p_x_parts_rec_tbl(i).Subinventory_code);
223: --AHL_DEBUG_PUB.debug('Input Severity_id:' || p_x_parts_rec_tbl(i).Severity_id);

Line 220: --AHL_DEBUG_PUB.debug('Input Locator_id:'|| p_x_parts_rec_tbl(i).Locator_id);

216: AHL_DEBUG_PUB.debug('Input Removal_Reason_Id:'|| p_x_parts_rec_tbl(i).Removal_Reason_Id);
217: AHL_DEBUG_PUB.debug('Input Removal_Reason_Name:' || p_x_parts_rec_tbl(i).Removal_Reason_Name);
218: AHL_DEBUG_PUB.debug('Input Removal_Date:' || p_x_parts_rec_tbl(i).Removal_Date);
219: --AHL_DEBUG_PUB.debug('Input Condition_Id:' || p_x_parts_rec_tbl(i).Condition_Id);
220: --AHL_DEBUG_PUB.debug('Input Locator_id:'|| p_x_parts_rec_tbl(i).Locator_id);
221: --AHL_DEBUG_PUB.debug('Input Locator_code:'|| p_x_parts_rec_tbl(i).Locator_code);
222: --AHL_DEBUG_PUB.debug('Input Subinventory_code:'|| p_x_parts_rec_tbl(i).Subinventory_code);
223: --AHL_DEBUG_PUB.debug('Input Severity_id:' || p_x_parts_rec_tbl(i).Severity_id);
224: AHL_DEBUG_PUB.debug('Input Csi_II_Relationship_Id:' || p_x_parts_rec_tbl(i).Csi_II_Relationship_Id);

Line 221: --AHL_DEBUG_PUB.debug('Input Locator_code:'|| p_x_parts_rec_tbl(i).Locator_code);

217: AHL_DEBUG_PUB.debug('Input Removal_Reason_Name:' || p_x_parts_rec_tbl(i).Removal_Reason_Name);
218: AHL_DEBUG_PUB.debug('Input Removal_Date:' || p_x_parts_rec_tbl(i).Removal_Date);
219: --AHL_DEBUG_PUB.debug('Input Condition_Id:' || p_x_parts_rec_tbl(i).Condition_Id);
220: --AHL_DEBUG_PUB.debug('Input Locator_id:'|| p_x_parts_rec_tbl(i).Locator_id);
221: --AHL_DEBUG_PUB.debug('Input Locator_code:'|| p_x_parts_rec_tbl(i).Locator_code);
222: --AHL_DEBUG_PUB.debug('Input Subinventory_code:'|| p_x_parts_rec_tbl(i).Subinventory_code);
223: --AHL_DEBUG_PUB.debug('Input Severity_id:' || p_x_parts_rec_tbl(i).Severity_id);
224: AHL_DEBUG_PUB.debug('Input Csi_II_Relationship_Id:' || p_x_parts_rec_tbl(i).Csi_II_Relationship_Id);
225: AHL_DEBUG_PUB.debug('Input CSI_II_OBJECT_VERSION_NUM:' || p_x_parts_rec_tbl(i).CSI_II_OBJECT_VERSION_NUM);

Line 222: --AHL_DEBUG_PUB.debug('Input Subinventory_code:'|| p_x_parts_rec_tbl(i).Subinventory_code);

218: AHL_DEBUG_PUB.debug('Input Removal_Date:' || p_x_parts_rec_tbl(i).Removal_Date);
219: --AHL_DEBUG_PUB.debug('Input Condition_Id:' || p_x_parts_rec_tbl(i).Condition_Id);
220: --AHL_DEBUG_PUB.debug('Input Locator_id:'|| p_x_parts_rec_tbl(i).Locator_id);
221: --AHL_DEBUG_PUB.debug('Input Locator_code:'|| p_x_parts_rec_tbl(i).Locator_code);
222: --AHL_DEBUG_PUB.debug('Input Subinventory_code:'|| p_x_parts_rec_tbl(i).Subinventory_code);
223: --AHL_DEBUG_PUB.debug('Input Severity_id:' || p_x_parts_rec_tbl(i).Severity_id);
224: AHL_DEBUG_PUB.debug('Input Csi_II_Relationship_Id:' || p_x_parts_rec_tbl(i).Csi_II_Relationship_Id);
225: AHL_DEBUG_PUB.debug('Input CSI_II_OBJECT_VERSION_NUM:' || p_x_parts_rec_tbl(i).CSI_II_OBJECT_VERSION_NUM);
226: --AHL_DEBUG_PUB.debug('Input Target_Visit_Num:'|| p_x_parts_rec_tbl(i).Target_Visit_Num);

Line 223: --AHL_DEBUG_PUB.debug('Input Severity_id:' || p_x_parts_rec_tbl(i).Severity_id);

219: --AHL_DEBUG_PUB.debug('Input Condition_Id:' || p_x_parts_rec_tbl(i).Condition_Id);
220: --AHL_DEBUG_PUB.debug('Input Locator_id:'|| p_x_parts_rec_tbl(i).Locator_id);
221: --AHL_DEBUG_PUB.debug('Input Locator_code:'|| p_x_parts_rec_tbl(i).Locator_code);
222: --AHL_DEBUG_PUB.debug('Input Subinventory_code:'|| p_x_parts_rec_tbl(i).Subinventory_code);
223: --AHL_DEBUG_PUB.debug('Input Severity_id:' || p_x_parts_rec_tbl(i).Severity_id);
224: AHL_DEBUG_PUB.debug('Input Csi_II_Relationship_Id:' || p_x_parts_rec_tbl(i).Csi_II_Relationship_Id);
225: AHL_DEBUG_PUB.debug('Input CSI_II_OBJECT_VERSION_NUM:' || p_x_parts_rec_tbl(i).CSI_II_OBJECT_VERSION_NUM);
226: --AHL_DEBUG_PUB.debug('Input Target_Visit_Num:'|| p_x_parts_rec_tbl(i).Target_Visit_Num);
227: --AHL_DEBUG_PUB.debug('Input Target_Visit_Id:' || p_x_parts_rec_tbl(i).Target_Visit_Id);

Line 224: AHL_DEBUG_PUB.debug('Input Csi_II_Relationship_Id:' || p_x_parts_rec_tbl(i).Csi_II_Relationship_Id);

220: --AHL_DEBUG_PUB.debug('Input Locator_id:'|| p_x_parts_rec_tbl(i).Locator_id);
221: --AHL_DEBUG_PUB.debug('Input Locator_code:'|| p_x_parts_rec_tbl(i).Locator_code);
222: --AHL_DEBUG_PUB.debug('Input Subinventory_code:'|| p_x_parts_rec_tbl(i).Subinventory_code);
223: --AHL_DEBUG_PUB.debug('Input Severity_id:' || p_x_parts_rec_tbl(i).Severity_id);
224: AHL_DEBUG_PUB.debug('Input Csi_II_Relationship_Id:' || p_x_parts_rec_tbl(i).Csi_II_Relationship_Id);
225: AHL_DEBUG_PUB.debug('Input CSI_II_OBJECT_VERSION_NUM:' || p_x_parts_rec_tbl(i).CSI_II_OBJECT_VERSION_NUM);
226: --AHL_DEBUG_PUB.debug('Input Target_Visit_Num:'|| p_x_parts_rec_tbl(i).Target_Visit_Num);
227: --AHL_DEBUG_PUB.debug('Input Target_Visit_Id:' || p_x_parts_rec_tbl(i).Target_Visit_Id);
228: --AHL_DEBUG_PUB.debug('Input Problem_Code:' || p_x_parts_rec_tbl(i).Problem_Code);

Line 225: AHL_DEBUG_PUB.debug('Input CSI_II_OBJECT_VERSION_NUM:' || p_x_parts_rec_tbl(i).CSI_II_OBJECT_VERSION_NUM);

221: --AHL_DEBUG_PUB.debug('Input Locator_code:'|| p_x_parts_rec_tbl(i).Locator_code);
222: --AHL_DEBUG_PUB.debug('Input Subinventory_code:'|| p_x_parts_rec_tbl(i).Subinventory_code);
223: --AHL_DEBUG_PUB.debug('Input Severity_id:' || p_x_parts_rec_tbl(i).Severity_id);
224: AHL_DEBUG_PUB.debug('Input Csi_II_Relationship_Id:' || p_x_parts_rec_tbl(i).Csi_II_Relationship_Id);
225: AHL_DEBUG_PUB.debug('Input CSI_II_OBJECT_VERSION_NUM:' || p_x_parts_rec_tbl(i).CSI_II_OBJECT_VERSION_NUM);
226: --AHL_DEBUG_PUB.debug('Input Target_Visit_Num:'|| p_x_parts_rec_tbl(i).Target_Visit_Num);
227: --AHL_DEBUG_PUB.debug('Input Target_Visit_Id:' || p_x_parts_rec_tbl(i).Target_Visit_Id);
228: --AHL_DEBUG_PUB.debug('Input Problem_Code:' || p_x_parts_rec_tbl(i).Problem_Code);
229: --AHL_DEBUG_PUB.debug('Input Problem_Meaning:'|| p_x_parts_rec_tbl(i).Problem_Meaning);

Line 226: --AHL_DEBUG_PUB.debug('Input Target_Visit_Num:'|| p_x_parts_rec_tbl(i).Target_Visit_Num);

222: --AHL_DEBUG_PUB.debug('Input Subinventory_code:'|| p_x_parts_rec_tbl(i).Subinventory_code);
223: --AHL_DEBUG_PUB.debug('Input Severity_id:' || p_x_parts_rec_tbl(i).Severity_id);
224: AHL_DEBUG_PUB.debug('Input Csi_II_Relationship_Id:' || p_x_parts_rec_tbl(i).Csi_II_Relationship_Id);
225: AHL_DEBUG_PUB.debug('Input CSI_II_OBJECT_VERSION_NUM:' || p_x_parts_rec_tbl(i).CSI_II_OBJECT_VERSION_NUM);
226: --AHL_DEBUG_PUB.debug('Input Target_Visit_Num:'|| p_x_parts_rec_tbl(i).Target_Visit_Num);
227: --AHL_DEBUG_PUB.debug('Input Target_Visit_Id:' || p_x_parts_rec_tbl(i).Target_Visit_Id);
228: --AHL_DEBUG_PUB.debug('Input Problem_Code:' || p_x_parts_rec_tbl(i).Problem_Code);
229: --AHL_DEBUG_PUB.debug('Input Problem_Meaning:'|| p_x_parts_rec_tbl(i).Problem_Meaning);
230: AHL_DEBUG_PUB.debug('Input Operation_Type:' || p_x_parts_rec_tbl(i).Operation_Type);

Line 227: --AHL_DEBUG_PUB.debug('Input Target_Visit_Id:' || p_x_parts_rec_tbl(i).Target_Visit_Id);

223: --AHL_DEBUG_PUB.debug('Input Severity_id:' || p_x_parts_rec_tbl(i).Severity_id);
224: AHL_DEBUG_PUB.debug('Input Csi_II_Relationship_Id:' || p_x_parts_rec_tbl(i).Csi_II_Relationship_Id);
225: AHL_DEBUG_PUB.debug('Input CSI_II_OBJECT_VERSION_NUM:' || p_x_parts_rec_tbl(i).CSI_II_OBJECT_VERSION_NUM);
226: --AHL_DEBUG_PUB.debug('Input Target_Visit_Num:'|| p_x_parts_rec_tbl(i).Target_Visit_Num);
227: --AHL_DEBUG_PUB.debug('Input Target_Visit_Id:' || p_x_parts_rec_tbl(i).Target_Visit_Id);
228: --AHL_DEBUG_PUB.debug('Input Problem_Code:' || p_x_parts_rec_tbl(i).Problem_Code);
229: --AHL_DEBUG_PUB.debug('Input Problem_Meaning:'|| p_x_parts_rec_tbl(i).Problem_Meaning);
230: AHL_DEBUG_PUB.debug('Input Operation_Type:' || p_x_parts_rec_tbl(i).Operation_Type);
231: --AHL_DEBUG_PUB.debug('Input Summary:'|| p_x_parts_rec_tbl(i).Summary);

Line 228: --AHL_DEBUG_PUB.debug('Input Problem_Code:' || p_x_parts_rec_tbl(i).Problem_Code);

224: AHL_DEBUG_PUB.debug('Input Csi_II_Relationship_Id:' || p_x_parts_rec_tbl(i).Csi_II_Relationship_Id);
225: AHL_DEBUG_PUB.debug('Input CSI_II_OBJECT_VERSION_NUM:' || p_x_parts_rec_tbl(i).CSI_II_OBJECT_VERSION_NUM);
226: --AHL_DEBUG_PUB.debug('Input Target_Visit_Num:'|| p_x_parts_rec_tbl(i).Target_Visit_Num);
227: --AHL_DEBUG_PUB.debug('Input Target_Visit_Id:' || p_x_parts_rec_tbl(i).Target_Visit_Id);
228: --AHL_DEBUG_PUB.debug('Input Problem_Code:' || p_x_parts_rec_tbl(i).Problem_Code);
229: --AHL_DEBUG_PUB.debug('Input Problem_Meaning:'|| p_x_parts_rec_tbl(i).Problem_Meaning);
230: AHL_DEBUG_PUB.debug('Input Operation_Type:' || p_x_parts_rec_tbl(i).Operation_Type);
231: --AHL_DEBUG_PUB.debug('Input Summary:'|| p_x_parts_rec_tbl(i).Summary);
232: --AHL_DEBUG_PUB.debug('Input estimated_duration:'|| p_x_parts_rec_tbl(i).estimated_duration);

Line 229: --AHL_DEBUG_PUB.debug('Input Problem_Meaning:'|| p_x_parts_rec_tbl(i).Problem_Meaning);

225: AHL_DEBUG_PUB.debug('Input CSI_II_OBJECT_VERSION_NUM:' || p_x_parts_rec_tbl(i).CSI_II_OBJECT_VERSION_NUM);
226: --AHL_DEBUG_PUB.debug('Input Target_Visit_Num:'|| p_x_parts_rec_tbl(i).Target_Visit_Num);
227: --AHL_DEBUG_PUB.debug('Input Target_Visit_Id:' || p_x_parts_rec_tbl(i).Target_Visit_Id);
228: --AHL_DEBUG_PUB.debug('Input Problem_Code:' || p_x_parts_rec_tbl(i).Problem_Code);
229: --AHL_DEBUG_PUB.debug('Input Problem_Meaning:'|| p_x_parts_rec_tbl(i).Problem_Meaning);
230: AHL_DEBUG_PUB.debug('Input Operation_Type:' || p_x_parts_rec_tbl(i).Operation_Type);
231: --AHL_DEBUG_PUB.debug('Input Summary:'|| p_x_parts_rec_tbl(i).Summary);
232: --AHL_DEBUG_PUB.debug('Input estimated_duration:'|| p_x_parts_rec_tbl(i).estimated_duration);
233: AHL_DEBUG_PUB.debug('Input Installed_Instance_Obj_Ver_Num:'|| p_x_parts_rec_tbl(i).Installed_Instance_Obj_Ver_Num);

Line 230: AHL_DEBUG_PUB.debug('Input Operation_Type:' || p_x_parts_rec_tbl(i).Operation_Type);

226: --AHL_DEBUG_PUB.debug('Input Target_Visit_Num:'|| p_x_parts_rec_tbl(i).Target_Visit_Num);
227: --AHL_DEBUG_PUB.debug('Input Target_Visit_Id:' || p_x_parts_rec_tbl(i).Target_Visit_Id);
228: --AHL_DEBUG_PUB.debug('Input Problem_Code:' || p_x_parts_rec_tbl(i).Problem_Code);
229: --AHL_DEBUG_PUB.debug('Input Problem_Meaning:'|| p_x_parts_rec_tbl(i).Problem_Meaning);
230: AHL_DEBUG_PUB.debug('Input Operation_Type:' || p_x_parts_rec_tbl(i).Operation_Type);
231: --AHL_DEBUG_PUB.debug('Input Summary:'|| p_x_parts_rec_tbl(i).Summary);
232: --AHL_DEBUG_PUB.debug('Input estimated_duration:'|| p_x_parts_rec_tbl(i).estimated_duration);
233: AHL_DEBUG_PUB.debug('Input Installed_Instance_Obj_Ver_Num:'|| p_x_parts_rec_tbl(i).Installed_Instance_Obj_Ver_Num);
234: AHL_DEBUG_PUB.debug('Input Removed_INSTANCE_OBJ_VER_NUM:'|| p_x_parts_rec_tbl(i).Removed_INSTANCE_OBJ_VER_NUM);

Line 231: --AHL_DEBUG_PUB.debug('Input Summary:'|| p_x_parts_rec_tbl(i).Summary);

227: --AHL_DEBUG_PUB.debug('Input Target_Visit_Id:' || p_x_parts_rec_tbl(i).Target_Visit_Id);
228: --AHL_DEBUG_PUB.debug('Input Problem_Code:' || p_x_parts_rec_tbl(i).Problem_Code);
229: --AHL_DEBUG_PUB.debug('Input Problem_Meaning:'|| p_x_parts_rec_tbl(i).Problem_Meaning);
230: AHL_DEBUG_PUB.debug('Input Operation_Type:' || p_x_parts_rec_tbl(i).Operation_Type);
231: --AHL_DEBUG_PUB.debug('Input Summary:'|| p_x_parts_rec_tbl(i).Summary);
232: --AHL_DEBUG_PUB.debug('Input estimated_duration:'|| p_x_parts_rec_tbl(i).estimated_duration);
233: AHL_DEBUG_PUB.debug('Input Installed_Instance_Obj_Ver_Num:'|| p_x_parts_rec_tbl(i).Installed_Instance_Obj_Ver_Num);
234: AHL_DEBUG_PUB.debug('Input Removed_INSTANCE_OBJ_VER_NUM:'|| p_x_parts_rec_tbl(i).Removed_INSTANCE_OBJ_VER_NUM);
235:

Line 232: --AHL_DEBUG_PUB.debug('Input estimated_duration:'|| p_x_parts_rec_tbl(i).estimated_duration);

228: --AHL_DEBUG_PUB.debug('Input Problem_Code:' || p_x_parts_rec_tbl(i).Problem_Code);
229: --AHL_DEBUG_PUB.debug('Input Problem_Meaning:'|| p_x_parts_rec_tbl(i).Problem_Meaning);
230: AHL_DEBUG_PUB.debug('Input Operation_Type:' || p_x_parts_rec_tbl(i).Operation_Type);
231: --AHL_DEBUG_PUB.debug('Input Summary:'|| p_x_parts_rec_tbl(i).Summary);
232: --AHL_DEBUG_PUB.debug('Input estimated_duration:'|| p_x_parts_rec_tbl(i).estimated_duration);
233: AHL_DEBUG_PUB.debug('Input Installed_Instance_Obj_Ver_Num:'|| p_x_parts_rec_tbl(i).Installed_Instance_Obj_Ver_Num);
234: AHL_DEBUG_PUB.debug('Input Removed_INSTANCE_OBJ_VER_NUM:'|| p_x_parts_rec_tbl(i).Removed_INSTANCE_OBJ_VER_NUM);
235:
236: END IF;

Line 233: AHL_DEBUG_PUB.debug('Input Installed_Instance_Obj_Ver_Num:'|| p_x_parts_rec_tbl(i).Installed_Instance_Obj_Ver_Num);

229: --AHL_DEBUG_PUB.debug('Input Problem_Meaning:'|| p_x_parts_rec_tbl(i).Problem_Meaning);
230: AHL_DEBUG_PUB.debug('Input Operation_Type:' || p_x_parts_rec_tbl(i).Operation_Type);
231: --AHL_DEBUG_PUB.debug('Input Summary:'|| p_x_parts_rec_tbl(i).Summary);
232: --AHL_DEBUG_PUB.debug('Input estimated_duration:'|| p_x_parts_rec_tbl(i).estimated_duration);
233: AHL_DEBUG_PUB.debug('Input Installed_Instance_Obj_Ver_Num:'|| p_x_parts_rec_tbl(i).Installed_Instance_Obj_Ver_Num);
234: AHL_DEBUG_PUB.debug('Input Removed_INSTANCE_OBJ_VER_NUM:'|| p_x_parts_rec_tbl(i).Removed_INSTANCE_OBJ_VER_NUM);
235:
236: END IF;
237:

Line 234: AHL_DEBUG_PUB.debug('Input Removed_INSTANCE_OBJ_VER_NUM:'|| p_x_parts_rec_tbl(i).Removed_INSTANCE_OBJ_VER_NUM);

230: AHL_DEBUG_PUB.debug('Input Operation_Type:' || p_x_parts_rec_tbl(i).Operation_Type);
231: --AHL_DEBUG_PUB.debug('Input Summary:'|| p_x_parts_rec_tbl(i).Summary);
232: --AHL_DEBUG_PUB.debug('Input estimated_duration:'|| p_x_parts_rec_tbl(i).estimated_duration);
233: AHL_DEBUG_PUB.debug('Input Installed_Instance_Obj_Ver_Num:'|| p_x_parts_rec_tbl(i).Installed_Instance_Obj_Ver_Num);
234: AHL_DEBUG_PUB.debug('Input Removed_INSTANCE_OBJ_VER_NUM:'|| p_x_parts_rec_tbl(i).Removed_INSTANCE_OBJ_VER_NUM);
235:
236: END IF;
237:
238: -- SATHAPLI::Component Maintenance Planning Project, 14-Nov-2011, start

Line 246: AHL_DEBUG_PUB.debug('component visit, so dont allow part chage');

242: IF (chk_comp_visit_csr%FOUND) THEN
243: -- component visit, so don't allow part chage
244: CLOSE chk_comp_visit_csr;
245: IF G_DEBUG = 'Y' THEN
246: AHL_DEBUG_PUB.debug('component visit, so dont allow part chage');
247: END IF;
248: -- Part change operations are not allowed for a Component Visit.
249: FND_MESSAGE.Set_Name('AHL', 'AHL_CMP_PART_CNG_INVLD');
250: FND_MSG_PUB.ADD;

Line 270: AHL_DEBUG_PUB.debug('Calling convert_value_to_id');

266: END IF;
267:
268: -- convert value to ids first
269: IF G_DEBUG = 'Y' THEN
270: AHL_DEBUG_PUB.debug('Calling convert_value_to_id');
271: END IF;
272: Convert_value_to_id(p_x_parts_rec => p_x_parts_rec_tbl(i),
273: X_Return_Status => x_return_status);
274:

Line 283: AHL_DEBUG_PUB.debug('After convert_value_to_id');

279: END IF;
280:
281: -- dbms_output.put_line('After convert_value_to_id');
282: IF G_DEBUG = 'Y' THEN
283: AHL_DEBUG_PUB.debug('After convert_value_to_id');
284: -- Perform Validation Checks
285: AHL_DEBUG_PUB.debug('Calling perform validations ');
286: END IF;
287:

Line 285: AHL_DEBUG_PUB.debug('Calling perform validations ');

281: -- dbms_output.put_line('After convert_value_to_id');
282: IF G_DEBUG = 'Y' THEN
283: AHL_DEBUG_PUB.debug('After convert_value_to_id');
284: -- Perform Validation Checks
285: AHL_DEBUG_PUB.debug('Calling perform validations ');
286: END IF;
287:
288: Validate_part_record(
289: p_x_parts_rec => p_x_parts_rec_tbl(i),

Line 313: AHL_DEBUG_PUB.debug('Callung UC config');

309: -- *********************** UC Processing ********************************
310: IF (p_x_parts_rec_tbl(i).Unit_Config_Header_Id is not null) then
311: -- dbms_output.put_line('Callung UC config');
312: IF G_DEBUG = 'Y' THEN
313: AHL_DEBUG_PUB.debug('Callung UC config');
314: END IF;
315:
316: Process_UC(
317: p_x_parts_rec => p_x_parts_rec_tbl(i),

Line 324: AHL_DEBUG_PUB.debug('x_return_status after uc config '|| x_return_status);

320: x_return_status => x_return_status,
321: x_path_position_id => l_path_position_id,
322: x_warning_msg_tbl => x_warning_msg_tbl);
323: IF G_DEBUG = 'Y' THEN
324: AHL_DEBUG_PUB.debug('x_return_status after uc config '|| x_return_status);
325:
326: END IF;
327:
328:

Line 332: AHL_DEBUG_PUB.debug('IB Processing');

328:
329: -- *********************** IB Processing ********************************
330: ELSE
331: IF G_DEBUG = 'Y' THEN
332: AHL_DEBUG_PUB.debug('IB Processing');
333: END IF;
334: -- dbms_output.put_line('IB processing');
335:
336: Process_IB(

Line 378: AHL_DEBUG_PUB.debug('inside material txn call');

374: IF ( (p_x_parts_rec_tbl(i).operation_type='D' or p_x_parts_rec_tbl(i).operation_type='M')
375: AND ( p_x_parts_rec_tbl(i).SubInventory_code is not null)) THEN
376:
377: IF G_DEBUG = 'Y' THEN
378: AHL_DEBUG_PUB.debug('inside material txn call');
379: END IF;
380: --Call material transaction api
381: Process_material_txn(
382: p_x_parts_rec => p_x_parts_rec_tbl(i),

Line 484: AHL_DEBUG_PUB.debug('Calling SR');

480: /* ER#
481: -- Create Service Request for the Parts records if operation type = D or M andbased on condition.
482:
483: IF G_DEBUG = 'Y' THEN
484: AHL_DEBUG_PUB.debug('Calling SR');
485: END IF;
486: --Call sr api
487: Process_SR(
488: p_x_parts_rec_tbl => p_x_parts_rec_tbl,

Line 509: AHL_DEBUG_PUB.debug('Completed Processing. Checking for errors', '');

505: -- Initialize API return status to success
506: x_return_status := FND_API.G_RET_STS_SUCCESS;
507:
508: IF G_DEBUG = 'Y' THEN
509: AHL_DEBUG_PUB.debug('Completed Processing. Checking for errors', '');
510: END IF;
511:
512: -- Standard call to get message count and if count is 1, get message
513: FND_MSG_PUB.Count_And_Get

Line 520: AHL_DEBUG_PUB.disable_debug;

516: p_encoded => fnd_api.g_false);
517:
518: -- Disable debug (if enabled)
519: IF G_DEBUG = 'Y' THEN
520: AHL_DEBUG_PUB.disable_debug;
521: END IF;
522:
523: EXCEPTION
524: WHEN FND_API.G_EXC_ERROR THEN

Line 532: AHL_DEBUG_PUB.disable_debug;

528: p_data => x_msg_data,
529: p_encoded => fnd_api.g_false);
530: -- Disable debug
531: IF G_DEBUG = 'Y' THEN
532: AHL_DEBUG_PUB.disable_debug;
533: END IF;
534:
535:
536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 544: AHL_DEBUG_PUB.disable_debug;

540: p_data => x_msg_data,
541: p_encoded => fnd_api.g_false);
542: -- Disable debug
543: IF G_DEBUG = 'Y' THEN
544: AHL_DEBUG_PUB.disable_debug;
545: END IF;
546: WHEN OTHERS THEN
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
548: Rollback to perform_part_changes_pvt;

Line 560: AHL_DEBUG_PUB.disable_debug;

556: p_encoded => fnd_api.g_false);
557:
558: -- Disable debug
559: IF G_DEBUG = 'Y' THEN
560: AHL_DEBUG_PUB.disable_debug;
561: END IF;
562:
563: End Process_Part;
564: ---------------------------------

Line 1550: AHL_DEBUG_PUB.debug('Before making a call to AHL_UC_INSTANCE_PVT.remove_instance.');

1546: CLOSE get_wip_job_csr;
1547:
1548: IF ( p_x_parts_rec.operation_type ='D') then
1549: IF G_DEBUG = 'Y' THEN
1550: AHL_DEBUG_PUB.debug('Before making a call to AHL_UC_INSTANCE_PVT.remove_instance.');
1551: END IF;
1552:
1553: -- find the path_position_id for the removed instance.
1554:

Line 1640: AHL_DEBUG_PUB.debug('1 final p_x_parts_rec.Removed_Instance_Id ' || p_x_parts_rec.Removed_Instance_Id);

1636: END IF;
1637: CLOSE removal_instance_id;
1638: END IF;
1639: IF G_DEBUG = 'Y' THEN
1640: AHL_DEBUG_PUB.debug('1 final p_x_parts_rec.Removed_Instance_Id ' || p_x_parts_rec.Removed_Instance_Id);
1641: AHL_DEBUG_PUB.debug('l_final_removed_inst_id ' || l_final_removed_inst_id);
1642: END IF;
1643:
1644: ELSE -- non-serialized incomplete removal

Line 1641: AHL_DEBUG_PUB.debug('l_final_removed_inst_id ' || l_final_removed_inst_id);

1637: CLOSE removal_instance_id;
1638: END IF;
1639: IF G_DEBUG = 'Y' THEN
1640: AHL_DEBUG_PUB.debug('1 final p_x_parts_rec.Removed_Instance_Id ' || p_x_parts_rec.Removed_Instance_Id);
1641: AHL_DEBUG_PUB.debug('l_final_removed_inst_id ' || l_final_removed_inst_id);
1642: END IF;
1643:
1644: ELSE -- non-serialized incomplete removal
1645:

Line 1725: AHL_DEBUG_PUB.debug('After making a call to AHL_UC_INSTANCE_PVT.install_existing_instance.');

1721: p_validate_rule_flag => l_validate_rule_flag,
1722: x_warning_msg_tbl => x_warning_msg_tbl);
1723:
1724: IF G_DEBUG = 'Y' THEN
1725: AHL_DEBUG_PUB.debug('After making a call to AHL_UC_INSTANCE_PVT.install_existing_instance.');
1726: END IF;
1727:
1728: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1729: RAISE FND_API.G_EXC_ERROR;

Line 1736: AHL_DEBUG_PUB.debug('update_item_location :: ' ||l_dest_instance_id);

1732: END IF;
1733:
1734: p_x_parts_rec.Removed_Instance_Id := l_dest_instance_id;
1735: IF G_DEBUG = 'Y' THEN
1736: AHL_DEBUG_PUB.debug('update_item_location :: ' ||l_dest_instance_id);
1737: END IF;
1738: /*update_item_location(
1739: p_x_parts_rec => p_x_parts_rec,
1740: p_x_csi_transaction_rec => p_x_csi_transaction_rec,

Line 1750: AHL_DEBUG_PUB.debug('moving it');

1746: l_move_item_instance_tbl(1).instance_id := p_x_parts_rec.Removed_Instance_Id;
1747: l_move_item_instance_tbl(1).quantity := p_x_parts_rec.Removed_Quantity;
1748: l_move_item_instance_tbl(1).to_workorder_id := p_x_parts_rec.workorder_id;
1749: IF G_DEBUG = 'Y' THEN
1750: AHL_DEBUG_PUB.debug('moving it');
1751: END IF;
1752: move_instance_location(
1753: P_API_Version => 1.0,
1754: P_Init_Msg_List => Fnd_API.G_False,

Line 1777: AHL_DEBUG_PUB.debug('2 final p_x_parts_rec.Removed_Instance_Id ' || p_x_parts_rec.Removed_Instance_Id);

1773: END IF;
1774: CLOSE removal_instance_id;
1775: --p_x_parts_rec.Removed_Instance_Id := 274689;
1776: IF G_DEBUG = 'Y' THEN
1777: AHL_DEBUG_PUB.debug('2 final p_x_parts_rec.Removed_Instance_Id ' || p_x_parts_rec.Removed_Instance_Id);
1778: AHL_DEBUG_PUB.debug('l_final_removed_inst_id ' || l_final_removed_inst_id);
1779: END IF;
1780:
1781: END IF;

Line 1778: AHL_DEBUG_PUB.debug('l_final_removed_inst_id ' || l_final_removed_inst_id);

1774: CLOSE removal_instance_id;
1775: --p_x_parts_rec.Removed_Instance_Id := 274689;
1776: IF G_DEBUG = 'Y' THEN
1777: AHL_DEBUG_PUB.debug('2 final p_x_parts_rec.Removed_Instance_Id ' || p_x_parts_rec.Removed_Instance_Id);
1778: AHL_DEBUG_PUB.debug('l_final_removed_inst_id ' || l_final_removed_inst_id);
1779: END IF;
1780:
1781: END IF;
1782:

Line 1786: AHL_DEBUG_PUB.debug('Before making a call to AHL_UC_INSTANCE_PVT.install_existing_instance.');

1782:
1783: ELSIF ( p_x_parts_rec.operation_type ='C') then
1784:
1785: IF G_DEBUG = 'Y' THEN
1786: AHL_DEBUG_PUB.debug('Before making a call to AHL_UC_INSTANCE_PVT.install_existing_instance.');
1787: END IF;
1788:
1789: l_serialized := FND_API.G_FALSE;
1790: OPEN check_inst_nonserial(p_x_parts_rec.Installed_Instance_Id);

Line 1875: AHL_DEBUG_PUB.debug('After making a call to AHL_UC_INSTANCE_PVT.install_existing_instance.');

1871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1872: END IF;
1873:
1874: IF G_DEBUG = 'Y' THEN
1875: AHL_DEBUG_PUB.debug('After making a call to AHL_UC_INSTANCE_PVT.install_existing_instance.');
1876: END IF;
1877:
1878: -- Arunjk added for WO - WO cancellation for given instance
1879: CANCEL_WO_RESERVATION(P_X_PARTS_REC.INSTALLED_INSTANCE_ID);

Line 1912: AHL_DEBUG_PUB.debug('moving it');

1908: l_move_item_instance_tbl(1).instance_id := p_x_parts_rec.Removed_Instance_Id;
1909: l_move_item_instance_tbl(1).quantity := l_curr_config_qty;
1910: l_move_item_instance_tbl(1).to_workorder_id := p_x_parts_rec.workorder_id;
1911: IF G_DEBUG = 'Y' THEN
1912: AHL_DEBUG_PUB.debug('moving it');
1913: END IF;
1914: move_instance_location(
1915: P_API_Version => 1.0,
1916: P_Init_Msg_List => Fnd_API.G_False,

Line 2002: AHL_DEBUG_PUB.debug('After making a call to AHL_UC_INSTANCE_PVT.install_existing_instance.');

1998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1999: END IF;
2000:
2001: IF G_DEBUG = 'Y' THEN
2002: AHL_DEBUG_PUB.debug('After making a call to AHL_UC_INSTANCE_PVT.install_existing_instance.');
2003: END IF;
2004: END IF;
2005:
2006: ELSIF (p_x_parts_rec.operation_type ='M') then

Line 2009: AHL_DEBUG_PUB.debug('Before making a call to AHL_UC_INSTANCE_PVT.swap_instance.');

2005:
2006: ELSIF (p_x_parts_rec.operation_type ='M') then
2007:
2008: IF G_DEBUG = 'Y' THEN
2009: AHL_DEBUG_PUB.debug('Before making a call to AHL_UC_INSTANCE_PVT.swap_instance.');
2010: END IF;
2011: --Call swap_instance
2012: AHL_UC_INSTANCE_PVT.swap_instance(
2013: p_api_version => 1.0,

Line 2031: AHL_DEBUG_PUB.debug('After making a call to AHL_UC_INSTANCE_PVT.swap_instance.');

2027: p_prod_user_flag => 'Y',
2028: x_warning_msg_tbl => x_warning_msg_tbl);
2029:
2030: IF G_DEBUG = 'Y' THEN
2031: AHL_DEBUG_PUB.debug('After making a call to AHL_UC_INSTANCE_PVT.swap_instance.');
2032: END IF;
2033:
2034: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2035: RAISE FND_API.G_EXC_ERROR;

Line 2091: AHL_DEBUG_PUB.debug('p_x_parts_rec.Installed_Instance_Id ' ||p_x_parts_rec.Installed_Instance_Id);

2087: p_csi_item_instance_id => p_x_parts_rec.Installed_instance_id,
2088: x_path_position_id => x_path_position_id);
2089:
2090: IF G_DEBUG = 'Y' THEN
2091: AHL_DEBUG_PUB.debug('p_x_parts_rec.Installed_Instance_Id ' ||p_x_parts_rec.Installed_Instance_Id);
2092: AHL_DEBUG_PUB.debug('After Install/swap AHL_UC_INSTANCE_PVT' || x_path_position_id);
2093: END IF;
2094:
2095: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

Line 2092: AHL_DEBUG_PUB.debug('After Install/swap AHL_UC_INSTANCE_PVT' || x_path_position_id);

2088: x_path_position_id => x_path_position_id);
2089:
2090: IF G_DEBUG = 'Y' THEN
2091: AHL_DEBUG_PUB.debug('p_x_parts_rec.Installed_Instance_Id ' ||p_x_parts_rec.Installed_Instance_Id);
2092: AHL_DEBUG_PUB.debug('After Install/swap AHL_UC_INSTANCE_PVT' || x_path_position_id);
2093: END IF;
2094:
2095: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2096: RAISE FND_API.G_EXC_ERROR;

Line 2231: AHL_DEBUG_PUB.debug('IB Processing- Create');

2227: --Installing
2228: IF (p_x_parts_rec.operation_type = 'C' ) then
2229:
2230: IF G_DEBUG = 'Y' THEN
2231: AHL_DEBUG_PUB.debug('IB Processing- Create');
2232: END IF;
2233:
2234: l_serialized := FND_API.G_FALSE;
2235: OPEN check_inst_nonserial(p_x_parts_rec.Installed_Instance_Id);

Line 2266: AHL_DEBUG_PUB.debug('Sunil 1 p_x_parts_rec.Installed_Instance_Id : ' || p_x_parts_rec.Installed_Instance_Id);

2262: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2264: END IF;
2265: IF G_DEBUG = 'Y' THEN
2266: AHL_DEBUG_PUB.debug('Sunil 1 p_x_parts_rec.Installed_Instance_Id : ' || p_x_parts_rec.Installed_Instance_Id);
2267: AHL_DEBUG_PUB.debug('Sunil p_x_parts_rec.Installed_Quantity ' || p_x_parts_rec.Installed_Quantity);
2268: END IF;
2269: -- update installed instance qty to equal to installed qty
2270: l_instance_rec.instance_id := p_x_parts_rec.Installed_Instance_Id;

Line 2267: AHL_DEBUG_PUB.debug('Sunil p_x_parts_rec.Installed_Quantity ' || p_x_parts_rec.Installed_Quantity);

2263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2264: END IF;
2265: IF G_DEBUG = 'Y' THEN
2266: AHL_DEBUG_PUB.debug('Sunil 1 p_x_parts_rec.Installed_Instance_Id : ' || p_x_parts_rec.Installed_Instance_Id);
2267: AHL_DEBUG_PUB.debug('Sunil p_x_parts_rec.Installed_Quantity ' || p_x_parts_rec.Installed_Quantity);
2268: END IF;
2269: -- update installed instance qty to equal to installed qty
2270: l_instance_rec.instance_id := p_x_parts_rec.Installed_Instance_Id;
2271: l_instance_rec.quantity := p_x_parts_rec.Installed_Quantity;

Line 2295: AHL_DEBUG_PUB.debug('Sunil : Updated installed instance qty to : ' || p_x_parts_rec.Installed_Quantity);

2291: l_instance_rec.Install_Date := NULL;
2292: l_instance_rec.object_version_number := NULL;
2293:
2294: IF G_DEBUG = 'Y' THEN
2295: AHL_DEBUG_PUB.debug('Sunil : Updated installed instance qty to : ' || p_x_parts_rec.Installed_Quantity);
2296:
2297: END IF;
2298: END IF;
2299:

Line 2343: AHL_DEBUG_PUB.debug('Sunil : Updated fake installed instance qty to : 0 ');

2339: l_instance_rec.object_version_number := NULL;
2340:
2341:
2342: IF G_DEBUG = 'Y' THEN
2343: AHL_DEBUG_PUB.debug('Sunil : Updated fake installed instance qty to : 0 ');
2344: END IF;
2345:
2346: OPEN get_curr_quantity_csr(p_x_parts_rec.Removed_Instance_Id);
2347: FETCH get_curr_quantity_csr INTO l_curr_config_qty;

Line 2357: AHL_DEBUG_PUB.debug('Sunil2 : p_x_parts_rec.Removed_Instance_Id : ' || p_x_parts_rec.Removed_Instance_Id);

2353: l_instance_rec.Install_Date := p_x_parts_rec.Installation_Date;
2354:
2355:
2356: IF G_DEBUG = 'Y' THEN
2357: AHL_DEBUG_PUB.debug('Sunil2 : p_x_parts_rec.Removed_Instance_Id : ' || p_x_parts_rec.Removed_Instance_Id);
2358: AHL_DEBUG_PUB.debug('Sunil2 : net config qty : ' || l_instance_rec.quantity);
2359: END IF;
2360:
2361: OPEN csi_item_instance_csr(p_x_parts_rec.Installed_Instance_Id);

Line 2358: AHL_DEBUG_PUB.debug('Sunil2 : net config qty : ' || l_instance_rec.quantity);

2354:
2355:
2356: IF G_DEBUG = 'Y' THEN
2357: AHL_DEBUG_PUB.debug('Sunil2 : p_x_parts_rec.Removed_Instance_Id : ' || p_x_parts_rec.Removed_Instance_Id);
2358: AHL_DEBUG_PUB.debug('Sunil2 : net config qty : ' || l_instance_rec.quantity);
2359: END IF;
2360:
2361: OPEN csi_item_instance_csr(p_x_parts_rec.Installed_Instance_Id);
2362: FETCH csi_item_instance_csr INTO p_x_parts_rec.Installed_Instance_Num

Line 2372: AHL_DEBUG_PUB.debug('Sunil : Updated qty on config to : ' || l_instance_rec.quantity);

2368: x_return_status => x_return_status
2369: );
2370:
2371: IF G_DEBUG = 'Y' THEN
2372: AHL_DEBUG_PUB.debug('Sunil : Updated qty on config to : ' || l_instance_rec.quantity);
2373: END IF;
2374:
2375: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2376: RAISE FND_API.G_EXC_ERROR;

Line 2387: AHL_DEBUG_PUB.debug('Sunil : completed partial install : ');

2383: l_instance_rec.Install_Date := NULL;
2384: l_instance_rec.object_version_number := NULL;
2385:
2386: IF G_DEBUG = 'Y' THEN
2387: AHL_DEBUG_PUB.debug('Sunil : completed partial install : ');
2388: END IF;
2389:
2390:
2391: END IF;

Line 2397: AHL_DEBUG_PUB.debug('IB Processing- Remove');

2393: -- Removing a part
2394: ELSIF (p_x_parts_rec.operation_type = 'D' ) then
2395: -- dbms_output.put_line('IB processing- remove');
2396: IF G_DEBUG = 'Y' THEN
2397: AHL_DEBUG_PUB.debug('IB Processing- Remove');
2398: END IF;
2399: --Test that the part removed is ib config indeed
2400: l_unit_config_header_name:= AHL_UMP_UTIL_PKG.get_UnitName(p_x_parts_rec.removed_instance_id);
2401:

Line 2475: AHL_DEBUG_PUB.debug('1 final p_x_parts_rec.Removed_Instance_Id ' || p_x_parts_rec.Removed_Instance_Id);

2471: END IF;
2472: CLOSE removal_instance_id;
2473: END IF;
2474: IF G_DEBUG = 'Y' THEN
2475: AHL_DEBUG_PUB.debug('1 final p_x_parts_rec.Removed_Instance_Id ' || p_x_parts_rec.Removed_Instance_Id);
2476: AHL_DEBUG_PUB.debug('l_final_removed_inst_id ' || l_final_removed_inst_id);
2477: END IF;
2478: ELSE -- non-serialized incomplete removal
2479:

Line 2476: AHL_DEBUG_PUB.debug('l_final_removed_inst_id ' || l_final_removed_inst_id);

2472: CLOSE removal_instance_id;
2473: END IF;
2474: IF G_DEBUG = 'Y' THEN
2475: AHL_DEBUG_PUB.debug('1 final p_x_parts_rec.Removed_Instance_Id ' || p_x_parts_rec.Removed_Instance_Id);
2476: AHL_DEBUG_PUB.debug('l_final_removed_inst_id ' || l_final_removed_inst_id);
2477: END IF;
2478: ELSE -- non-serialized incomplete removal
2479:
2480: csi_ii_relationships_pub.expire_relationship(

Line 2555: AHL_DEBUG_PUB.debug('After making a call to csi_ii_relationships_pub.create_relationship.');

2551: ,x_msg_count => l_msg_count
2552: ,x_msg_data => l_msg_data);
2553:
2554: IF G_DEBUG = 'Y' THEN
2555: AHL_DEBUG_PUB.debug('After making a call to csi_ii_relationships_pub.create_relationship.');
2556: END IF;
2557:
2558: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2559: RAISE FND_API.G_EXC_ERROR;

Line 2566: AHL_DEBUG_PUB.debug('update_item_location :: ' ||l_dest_instance_id);

2562: END IF;
2563:
2564: p_x_parts_rec.Removed_Instance_Id := l_dest_instance_id;
2565: IF G_DEBUG = 'Y' THEN
2566: AHL_DEBUG_PUB.debug('update_item_location :: ' ||l_dest_instance_id);
2567: END IF;
2568: /*update_item_location(
2569: p_x_parts_rec => p_x_parts_rec,
2570: p_x_csi_transaction_rec => p_x_csi_transaction_rec,

Line 2580: AHL_DEBUG_PUB.debug('moving it');

2576: l_move_item_instance_tbl(1).instance_id := p_x_parts_rec.Removed_Instance_Id;
2577: l_move_item_instance_tbl(1).quantity := p_x_parts_rec.Removed_Quantity;
2578: l_move_item_instance_tbl(1).to_workorder_id := p_x_parts_rec.workorder_id;
2579: IF G_DEBUG = 'Y' THEN
2580: AHL_DEBUG_PUB.debug('moving it');
2581: END IF;
2582: move_instance_location(
2583: P_API_Version => 1.0,
2584: P_Init_Msg_List => Fnd_API.G_False,

Line 2607: AHL_DEBUG_PUB.debug('2 final p_x_parts_rec.Removed_Instance_Id ' || p_x_parts_rec.Removed_Instance_Id);

2603: END IF;
2604: CLOSE removal_instance_id;
2605: --p_x_parts_rec.Removed_Instance_Id := 274689;
2606: IF G_DEBUG = 'Y' THEN
2607: AHL_DEBUG_PUB.debug('2 final p_x_parts_rec.Removed_Instance_Id ' || p_x_parts_rec.Removed_Instance_Id);
2608: AHL_DEBUG_PUB.debug('l_final_removed_inst_id ' || l_final_removed_inst_id);
2609: END IF;
2610:
2611: END IF;

Line 2608: AHL_DEBUG_PUB.debug('l_final_removed_inst_id ' || l_final_removed_inst_id);

2604: CLOSE removal_instance_id;
2605: --p_x_parts_rec.Removed_Instance_Id := 274689;
2606: IF G_DEBUG = 'Y' THEN
2607: AHL_DEBUG_PUB.debug('2 final p_x_parts_rec.Removed_Instance_Id ' || p_x_parts_rec.Removed_Instance_Id);
2608: AHL_DEBUG_PUB.debug('l_final_removed_inst_id ' || l_final_removed_inst_id);
2609: END IF;
2610:
2611: END IF;
2612:

Line 2624: AHL_DEBUG_PUB.debug('IB Processing- Swap');

2620: FND_MSG_PUB.ADD;
2621: --RAISE FND_API.G_EXC_ERROR;
2622: end if;
2623: IF G_DEBUG = 'Y' THEN
2624: AHL_DEBUG_PUB.debug('IB Processing- Swap');
2625: END IF;
2626: csi_ii_relationships_pub.update_relationship(
2627: p_api_version => 1.0
2628: ,p_relationship_tbl => l_csi_relationship_tbl

Line 2640: AHL_DEBUG_PUB.debug('moving it');

2636: l_move_item_instance_tbl(1).instance_id := p_x_parts_rec.Removed_Instance_Id;
2637: l_move_item_instance_tbl(1).quantity := p_x_parts_rec.Removed_Quantity;
2638: l_move_item_instance_tbl(1).to_workorder_id := p_x_parts_rec.workorder_id;
2639: IF G_DEBUG = 'Y' THEN
2640: AHL_DEBUG_PUB.debug('moving it');
2641: END IF;
2642:
2643: update_item_location(
2644: p_x_parts_rec => p_x_parts_rec,

Line 2983: AHL_DEBUG_PUB.debug('Sangita-x_return_status after SR'|| x_return_status);

2979: -- dbms_output.put_line('Sangita-x_return_status after SR'|| x_return_status);
2980:
2981:
2982: IF G_DEBUG = 'Y' THEN
2983: AHL_DEBUG_PUB.debug('Sangita-x_return_status after SR'|| x_return_status);
2984: END IF;
2985:
2986:
2987: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) then

Line 3000: AHL_DEBUG_PUB.debug('inside update part changes call');

2996:
2997: IF ( p_x_parts_rec_tbl(i).nonroutine_wo_id is not null ) then
2998: -- dbms_output.put_line('inside update part changes call');
2999: IF G_DEBUG = 'Y' THEN
3000: AHL_DEBUG_PUB.debug('inside update part changes call');
3001: END IF;
3002:
3003: AHL_PART_CHANGES_PKG.update_row(
3004: X_PART_CHANGE_ID => p_x_parts_rec_tbl(i).part_change_txn_id,

Line 3375: AHL_DEBUG_PUB.disable_debug;

3371: p_data => x_msg_data,
3372: p_encoded => fnd_api.g_false);
3373: -- Disable debug
3374: IF G_DEBUG = 'Y' THEN
3375: AHL_DEBUG_PUB.disable_debug;
3376: END IF;
3377:
3378:
3379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3387: AHL_DEBUG_PUB.disable_debug;

3383: p_data => x_msg_data,
3384: p_encoded => fnd_api.g_false);
3385: -- Disable debug
3386: IF G_DEBUG = 'Y' THEN
3387: AHL_DEBUG_PUB.disable_debug;
3388: END IF;
3389:
3390: WHEN OTHERS THEN
3391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3404: AHL_DEBUG_PUB.disable_debug;

3400: p_encoded => fnd_api.g_false);
3401:
3402: -- Disable debug
3403: IF G_DEBUG = 'Y' THEN
3404: AHL_DEBUG_PUB.disable_debug;
3405: END IF;
3406:
3407: END ReturnTo_Workorder_Locator;
3408:

Line 5070: AHL_DEBUG_PUB.DEBUG('Delete_Reservation failed for Reservation ID: ' || GET_SRC_RES_ID_REC.RESERVATION_ID);

5066: P_RESERVATION_ID => GET_SRC_RES_ID_REC.RESERVATION_ID);
5067: -- Check return status.
5068: IF (L_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS ) THEN
5069: IF ( G_DEBUG = 'Y' ) THEN
5070: AHL_DEBUG_PUB.DEBUG('Delete_Reservation failed for Reservation ID: ' || GET_SRC_RES_ID_REC.RESERVATION_ID);
5071: END IF; -- G_DEBUG.
5072: EXIT;
5073: END IF; -- l_return_status
5074: END LOOP;