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 2008/07/01 01:33:59 sikumar 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 172: AHL_DEBUG_PUB.enable_debug;

168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169:
170: -- Enable Debug.
171: IF G_DEBUG = 'Y' THEN
172: AHL_DEBUG_PUB.enable_debug;
173: END IF;
174:
175: -- Add debug mesg.
176: IF G_DEBUG = 'Y' THEN

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

173: END IF;
174:
175: -- Add debug mesg.
176: IF G_DEBUG = 'Y' THEN
177: AHL_DEBUG_PUB.debug('Begin private API:' || G_PKG_NAME || '.' || l_api_name);
178: END IF;
179:
180: --Loop through the table record
181: IF ( p_x_parts_rec_tbl.COUNT > 0) THEN

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

180: --Loop through the table record
181: IF ( p_x_parts_rec_tbl.COUNT > 0) THEN
182: FOR i IN p_x_parts_rec_tbl.FIRST..p_x_parts_rec_tbl.LAST LOOP
183: IF G_DEBUG = 'Y' THEN
184: AHL_DEBUG_PUB.debug('Input parameter dump for record:'|| i);
185: AHL_DEBUG_PUB.debug('Input Workorder_Id:' || p_x_parts_rec_tbl(i).Workorder_Id);
186: AHL_DEBUG_PUB.debug('Input Operation_Sequence_Num:'|| p_x_parts_rec_tbl(i).Operation_Sequence_Num );
187: AHL_DEBUG_PUB.debug('Input workorder_operation_id:'|| p_x_parts_rec_tbl(i).workorder_operation_id);
188: AHL_DEBUG_PUB.debug('Input Unit_Config_Header_Id:'|| p_x_parts_rec_tbl(i).Unit_Config_Header_Id);

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

181: IF ( p_x_parts_rec_tbl.COUNT > 0) THEN
182: FOR i IN p_x_parts_rec_tbl.FIRST..p_x_parts_rec_tbl.LAST LOOP
183: IF G_DEBUG = 'Y' THEN
184: AHL_DEBUG_PUB.debug('Input parameter dump for record:'|| i);
185: AHL_DEBUG_PUB.debug('Input Workorder_Id:' || p_x_parts_rec_tbl(i).Workorder_Id);
186: AHL_DEBUG_PUB.debug('Input Operation_Sequence_Num:'|| p_x_parts_rec_tbl(i).Operation_Sequence_Num );
187: AHL_DEBUG_PUB.debug('Input workorder_operation_id:'|| p_x_parts_rec_tbl(i).workorder_operation_id);
188: AHL_DEBUG_PUB.debug('Input Unit_Config_Header_Id:'|| p_x_parts_rec_tbl(i).Unit_Config_Header_Id);
189: AHL_DEBUG_PUB.debug('Input Unit_Config_Name:'|| p_x_parts_rec_tbl(i).Unit_Config_Name);

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

182: FOR i IN p_x_parts_rec_tbl.FIRST..p_x_parts_rec_tbl.LAST LOOP
183: IF G_DEBUG = 'Y' THEN
184: AHL_DEBUG_PUB.debug('Input parameter dump for record:'|| i);
185: AHL_DEBUG_PUB.debug('Input Workorder_Id:' || p_x_parts_rec_tbl(i).Workorder_Id);
186: AHL_DEBUG_PUB.debug('Input Operation_Sequence_Num:'|| p_x_parts_rec_tbl(i).Operation_Sequence_Num );
187: AHL_DEBUG_PUB.debug('Input workorder_operation_id:'|| p_x_parts_rec_tbl(i).workorder_operation_id);
188: AHL_DEBUG_PUB.debug('Input Unit_Config_Header_Id:'|| p_x_parts_rec_tbl(i).Unit_Config_Header_Id);
189: AHL_DEBUG_PUB.debug('Input Unit_Config_Name:'|| p_x_parts_rec_tbl(i).Unit_Config_Name);
190: AHL_DEBUG_PUB.debug('Input Unit_config_obj_ver_num:' || p_x_parts_rec_tbl(i).Unit_config_obj_ver_num);

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

183: IF G_DEBUG = 'Y' THEN
184: AHL_DEBUG_PUB.debug('Input parameter dump for record:'|| i);
185: AHL_DEBUG_PUB.debug('Input Workorder_Id:' || p_x_parts_rec_tbl(i).Workorder_Id);
186: AHL_DEBUG_PUB.debug('Input Operation_Sequence_Num:'|| p_x_parts_rec_tbl(i).Operation_Sequence_Num );
187: AHL_DEBUG_PUB.debug('Input workorder_operation_id:'|| p_x_parts_rec_tbl(i).workorder_operation_id);
188: AHL_DEBUG_PUB.debug('Input Unit_Config_Header_Id:'|| p_x_parts_rec_tbl(i).Unit_Config_Header_Id);
189: AHL_DEBUG_PUB.debug('Input Unit_Config_Name:'|| p_x_parts_rec_tbl(i).Unit_Config_Name);
190: AHL_DEBUG_PUB.debug('Input Unit_config_obj_ver_num:' || p_x_parts_rec_tbl(i).Unit_config_obj_ver_num);
191: AHL_DEBUG_PUB.debug('Input Mc_Relationship_Id:' || p_x_parts_rec_tbl(i).Mc_Relationship_Id);

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

184: AHL_DEBUG_PUB.debug('Input parameter dump for record:'|| i);
185: AHL_DEBUG_PUB.debug('Input Workorder_Id:' || p_x_parts_rec_tbl(i).Workorder_Id);
186: AHL_DEBUG_PUB.debug('Input Operation_Sequence_Num:'|| p_x_parts_rec_tbl(i).Operation_Sequence_Num );
187: AHL_DEBUG_PUB.debug('Input workorder_operation_id:'|| p_x_parts_rec_tbl(i).workorder_operation_id);
188: AHL_DEBUG_PUB.debug('Input Unit_Config_Header_Id:'|| p_x_parts_rec_tbl(i).Unit_Config_Header_Id);
189: AHL_DEBUG_PUB.debug('Input Unit_Config_Name:'|| p_x_parts_rec_tbl(i).Unit_Config_Name);
190: AHL_DEBUG_PUB.debug('Input Unit_config_obj_ver_num:' || p_x_parts_rec_tbl(i).Unit_config_obj_ver_num);
191: AHL_DEBUG_PUB.debug('Input Mc_Relationship_Id:' || p_x_parts_rec_tbl(i).Mc_Relationship_Id);
192: AHL_DEBUG_PUB.debug('Input Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Installed_Instance_Id);

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

185: AHL_DEBUG_PUB.debug('Input Workorder_Id:' || p_x_parts_rec_tbl(i).Workorder_Id);
186: AHL_DEBUG_PUB.debug('Input Operation_Sequence_Num:'|| p_x_parts_rec_tbl(i).Operation_Sequence_Num );
187: AHL_DEBUG_PUB.debug('Input workorder_operation_id:'|| p_x_parts_rec_tbl(i).workorder_operation_id);
188: AHL_DEBUG_PUB.debug('Input Unit_Config_Header_Id:'|| p_x_parts_rec_tbl(i).Unit_Config_Header_Id);
189: AHL_DEBUG_PUB.debug('Input Unit_Config_Name:'|| p_x_parts_rec_tbl(i).Unit_Config_Name);
190: AHL_DEBUG_PUB.debug('Input Unit_config_obj_ver_num:' || p_x_parts_rec_tbl(i).Unit_config_obj_ver_num);
191: AHL_DEBUG_PUB.debug('Input Mc_Relationship_Id:' || p_x_parts_rec_tbl(i).Mc_Relationship_Id);
192: AHL_DEBUG_PUB.debug('Input Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Installed_Instance_Id);
193: AHL_DEBUG_PUB.debug('Input Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Installed_Instance_Num);

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

186: AHL_DEBUG_PUB.debug('Input Operation_Sequence_Num:'|| p_x_parts_rec_tbl(i).Operation_Sequence_Num );
187: AHL_DEBUG_PUB.debug('Input workorder_operation_id:'|| p_x_parts_rec_tbl(i).workorder_operation_id);
188: AHL_DEBUG_PUB.debug('Input Unit_Config_Header_Id:'|| p_x_parts_rec_tbl(i).Unit_Config_Header_Id);
189: AHL_DEBUG_PUB.debug('Input Unit_Config_Name:'|| p_x_parts_rec_tbl(i).Unit_Config_Name);
190: AHL_DEBUG_PUB.debug('Input Unit_config_obj_ver_num:' || p_x_parts_rec_tbl(i).Unit_config_obj_ver_num);
191: AHL_DEBUG_PUB.debug('Input Mc_Relationship_Id:' || p_x_parts_rec_tbl(i).Mc_Relationship_Id);
192: AHL_DEBUG_PUB.debug('Input Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Installed_Instance_Id);
193: AHL_DEBUG_PUB.debug('Input Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Installed_Instance_Num);
194: AHL_DEBUG_PUB.debug('Input Installation_date:' || p_x_parts_rec_tbl(i).Installation_date);

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

187: AHL_DEBUG_PUB.debug('Input workorder_operation_id:'|| p_x_parts_rec_tbl(i).workorder_operation_id);
188: AHL_DEBUG_PUB.debug('Input Unit_Config_Header_Id:'|| p_x_parts_rec_tbl(i).Unit_Config_Header_Id);
189: AHL_DEBUG_PUB.debug('Input Unit_Config_Name:'|| p_x_parts_rec_tbl(i).Unit_Config_Name);
190: AHL_DEBUG_PUB.debug('Input Unit_config_obj_ver_num:' || p_x_parts_rec_tbl(i).Unit_config_obj_ver_num);
191: AHL_DEBUG_PUB.debug('Input Mc_Relationship_Id:' || p_x_parts_rec_tbl(i).Mc_Relationship_Id);
192: AHL_DEBUG_PUB.debug('Input Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Installed_Instance_Id);
193: AHL_DEBUG_PUB.debug('Input Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Installed_Instance_Num);
194: AHL_DEBUG_PUB.debug('Input Installation_date:' || p_x_parts_rec_tbl(i).Installation_date);
195: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Id);

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

188: AHL_DEBUG_PUB.debug('Input Unit_Config_Header_Id:'|| p_x_parts_rec_tbl(i).Unit_Config_Header_Id);
189: AHL_DEBUG_PUB.debug('Input Unit_Config_Name:'|| p_x_parts_rec_tbl(i).Unit_Config_Name);
190: AHL_DEBUG_PUB.debug('Input Unit_config_obj_ver_num:' || p_x_parts_rec_tbl(i).Unit_config_obj_ver_num);
191: AHL_DEBUG_PUB.debug('Input Mc_Relationship_Id:' || p_x_parts_rec_tbl(i).Mc_Relationship_Id);
192: AHL_DEBUG_PUB.debug('Input Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Installed_Instance_Id);
193: AHL_DEBUG_PUB.debug('Input Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Installed_Instance_Num);
194: AHL_DEBUG_PUB.debug('Input Installation_date:' || p_x_parts_rec_tbl(i).Installation_date);
195: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Id);
196: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Num);

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

189: AHL_DEBUG_PUB.debug('Input Unit_Config_Name:'|| p_x_parts_rec_tbl(i).Unit_Config_Name);
190: AHL_DEBUG_PUB.debug('Input Unit_config_obj_ver_num:' || p_x_parts_rec_tbl(i).Unit_config_obj_ver_num);
191: AHL_DEBUG_PUB.debug('Input Mc_Relationship_Id:' || p_x_parts_rec_tbl(i).Mc_Relationship_Id);
192: AHL_DEBUG_PUB.debug('Input Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Installed_Instance_Id);
193: AHL_DEBUG_PUB.debug('Input Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Installed_Instance_Num);
194: AHL_DEBUG_PUB.debug('Input Installation_date:' || p_x_parts_rec_tbl(i).Installation_date);
195: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Id);
196: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Num);
197: AHL_DEBUG_PUB.debug('Input Removed_Instance_Id:' || p_x_parts_rec_tbl(i).Removed_Instance_Id);

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

190: AHL_DEBUG_PUB.debug('Input Unit_config_obj_ver_num:' || p_x_parts_rec_tbl(i).Unit_config_obj_ver_num);
191: AHL_DEBUG_PUB.debug('Input Mc_Relationship_Id:' || p_x_parts_rec_tbl(i).Mc_Relationship_Id);
192: AHL_DEBUG_PUB.debug('Input Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Installed_Instance_Id);
193: AHL_DEBUG_PUB.debug('Input Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Installed_Instance_Num);
194: AHL_DEBUG_PUB.debug('Input Installation_date:' || p_x_parts_rec_tbl(i).Installation_date);
195: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Id);
196: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Num);
197: AHL_DEBUG_PUB.debug('Input Removed_Instance_Id:' || p_x_parts_rec_tbl(i).Removed_Instance_Id);
198: AHL_DEBUG_PUB.debug('Input Removed_Instance_Num:' || p_x_parts_rec_tbl(i).Removed_Instance_Num);

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

191: AHL_DEBUG_PUB.debug('Input Mc_Relationship_Id:' || p_x_parts_rec_tbl(i).Mc_Relationship_Id);
192: AHL_DEBUG_PUB.debug('Input Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Installed_Instance_Id);
193: AHL_DEBUG_PUB.debug('Input Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Installed_Instance_Num);
194: AHL_DEBUG_PUB.debug('Input Installation_date:' || p_x_parts_rec_tbl(i).Installation_date);
195: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Id);
196: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Num);
197: AHL_DEBUG_PUB.debug('Input Removed_Instance_Id:' || p_x_parts_rec_tbl(i).Removed_Instance_Id);
198: AHL_DEBUG_PUB.debug('Input Removed_Instance_Num:' || p_x_parts_rec_tbl(i).Removed_Instance_Num);
199: AHL_DEBUG_PUB.debug('Input Removal_Code:' || p_x_parts_rec_tbl(i).Removal_Code);

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

192: AHL_DEBUG_PUB.debug('Input Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Installed_Instance_Id);
193: AHL_DEBUG_PUB.debug('Input Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Installed_Instance_Num);
194: AHL_DEBUG_PUB.debug('Input Installation_date:' || p_x_parts_rec_tbl(i).Installation_date);
195: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Id);
196: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Num);
197: AHL_DEBUG_PUB.debug('Input Removed_Instance_Id:' || p_x_parts_rec_tbl(i).Removed_Instance_Id);
198: AHL_DEBUG_PUB.debug('Input Removed_Instance_Num:' || p_x_parts_rec_tbl(i).Removed_Instance_Num);
199: AHL_DEBUG_PUB.debug('Input Removal_Code:' || p_x_parts_rec_tbl(i).Removal_Code);
200: AHL_DEBUG_PUB.debug('Input Removal_Meaning:'|| p_x_parts_rec_tbl(i).Removal_Meaning);

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

193: AHL_DEBUG_PUB.debug('Input Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Installed_Instance_Num);
194: AHL_DEBUG_PUB.debug('Input Installation_date:' || p_x_parts_rec_tbl(i).Installation_date);
195: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Id);
196: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Num);
197: AHL_DEBUG_PUB.debug('Input Removed_Instance_Id:' || p_x_parts_rec_tbl(i).Removed_Instance_Id);
198: AHL_DEBUG_PUB.debug('Input Removed_Instance_Num:' || p_x_parts_rec_tbl(i).Removed_Instance_Num);
199: AHL_DEBUG_PUB.debug('Input Removal_Code:' || p_x_parts_rec_tbl(i).Removal_Code);
200: AHL_DEBUG_PUB.debug('Input Removal_Meaning:'|| p_x_parts_rec_tbl(i).Removal_Meaning);
201: AHL_DEBUG_PUB.debug('Input Removal_Reason_Id:'|| p_x_parts_rec_tbl(i).Removal_Reason_Id);

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

194: AHL_DEBUG_PUB.debug('Input Installation_date:' || p_x_parts_rec_tbl(i).Installation_date);
195: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Id);
196: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Num);
197: AHL_DEBUG_PUB.debug('Input Removed_Instance_Id:' || p_x_parts_rec_tbl(i).Removed_Instance_Id);
198: AHL_DEBUG_PUB.debug('Input Removed_Instance_Num:' || p_x_parts_rec_tbl(i).Removed_Instance_Num);
199: AHL_DEBUG_PUB.debug('Input Removal_Code:' || p_x_parts_rec_tbl(i).Removal_Code);
200: AHL_DEBUG_PUB.debug('Input Removal_Meaning:'|| p_x_parts_rec_tbl(i).Removal_Meaning);
201: AHL_DEBUG_PUB.debug('Input Removal_Reason_Id:'|| p_x_parts_rec_tbl(i).Removal_Reason_Id);
202: AHL_DEBUG_PUB.debug('Input Removal_Reason_Name:' || p_x_parts_rec_tbl(i).Removal_Reason_Name);

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

195: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Id:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Id);
196: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Num);
197: AHL_DEBUG_PUB.debug('Input Removed_Instance_Id:' || p_x_parts_rec_tbl(i).Removed_Instance_Id);
198: AHL_DEBUG_PUB.debug('Input Removed_Instance_Num:' || p_x_parts_rec_tbl(i).Removed_Instance_Num);
199: AHL_DEBUG_PUB.debug('Input Removal_Code:' || p_x_parts_rec_tbl(i).Removal_Code);
200: AHL_DEBUG_PUB.debug('Input Removal_Meaning:'|| p_x_parts_rec_tbl(i).Removal_Meaning);
201: AHL_DEBUG_PUB.debug('Input Removal_Reason_Id:'|| p_x_parts_rec_tbl(i).Removal_Reason_Id);
202: AHL_DEBUG_PUB.debug('Input Removal_Reason_Name:' || p_x_parts_rec_tbl(i).Removal_Reason_Name);
203: AHL_DEBUG_PUB.debug('Input Removal_Date:' || p_x_parts_rec_tbl(i).Removal_Date);

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

196: AHL_DEBUG_PUB.debug('Input Parent_Installed_Instance_Num:' || p_x_parts_rec_tbl(i).Parent_Installed_Instance_Num);
197: AHL_DEBUG_PUB.debug('Input Removed_Instance_Id:' || p_x_parts_rec_tbl(i).Removed_Instance_Id);
198: AHL_DEBUG_PUB.debug('Input Removed_Instance_Num:' || p_x_parts_rec_tbl(i).Removed_Instance_Num);
199: AHL_DEBUG_PUB.debug('Input Removal_Code:' || p_x_parts_rec_tbl(i).Removal_Code);
200: AHL_DEBUG_PUB.debug('Input Removal_Meaning:'|| p_x_parts_rec_tbl(i).Removal_Meaning);
201: AHL_DEBUG_PUB.debug('Input Removal_Reason_Id:'|| p_x_parts_rec_tbl(i).Removal_Reason_Id);
202: AHL_DEBUG_PUB.debug('Input Removal_Reason_Name:' || p_x_parts_rec_tbl(i).Removal_Reason_Name);
203: AHL_DEBUG_PUB.debug('Input Removal_Date:' || p_x_parts_rec_tbl(i).Removal_Date);
204: --AHL_DEBUG_PUB.debug('Input Condition_Id:' || p_x_parts_rec_tbl(i).Condition_Id);

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

197: AHL_DEBUG_PUB.debug('Input Removed_Instance_Id:' || p_x_parts_rec_tbl(i).Removed_Instance_Id);
198: AHL_DEBUG_PUB.debug('Input Removed_Instance_Num:' || p_x_parts_rec_tbl(i).Removed_Instance_Num);
199: AHL_DEBUG_PUB.debug('Input Removal_Code:' || p_x_parts_rec_tbl(i).Removal_Code);
200: AHL_DEBUG_PUB.debug('Input Removal_Meaning:'|| p_x_parts_rec_tbl(i).Removal_Meaning);
201: AHL_DEBUG_PUB.debug('Input Removal_Reason_Id:'|| p_x_parts_rec_tbl(i).Removal_Reason_Id);
202: AHL_DEBUG_PUB.debug('Input Removal_Reason_Name:' || p_x_parts_rec_tbl(i).Removal_Reason_Name);
203: AHL_DEBUG_PUB.debug('Input Removal_Date:' || p_x_parts_rec_tbl(i).Removal_Date);
204: --AHL_DEBUG_PUB.debug('Input Condition_Id:' || p_x_parts_rec_tbl(i).Condition_Id);
205: --AHL_DEBUG_PUB.debug('Input Locator_id:'|| p_x_parts_rec_tbl(i).Locator_id);

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

198: AHL_DEBUG_PUB.debug('Input Removed_Instance_Num:' || p_x_parts_rec_tbl(i).Removed_Instance_Num);
199: AHL_DEBUG_PUB.debug('Input Removal_Code:' || p_x_parts_rec_tbl(i).Removal_Code);
200: AHL_DEBUG_PUB.debug('Input Removal_Meaning:'|| p_x_parts_rec_tbl(i).Removal_Meaning);
201: AHL_DEBUG_PUB.debug('Input Removal_Reason_Id:'|| p_x_parts_rec_tbl(i).Removal_Reason_Id);
202: AHL_DEBUG_PUB.debug('Input Removal_Reason_Name:' || p_x_parts_rec_tbl(i).Removal_Reason_Name);
203: AHL_DEBUG_PUB.debug('Input Removal_Date:' || p_x_parts_rec_tbl(i).Removal_Date);
204: --AHL_DEBUG_PUB.debug('Input Condition_Id:' || p_x_parts_rec_tbl(i).Condition_Id);
205: --AHL_DEBUG_PUB.debug('Input Locator_id:'|| p_x_parts_rec_tbl(i).Locator_id);
206: --AHL_DEBUG_PUB.debug('Input Locator_code:'|| p_x_parts_rec_tbl(i).Locator_code);

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

199: AHL_DEBUG_PUB.debug('Input Removal_Code:' || p_x_parts_rec_tbl(i).Removal_Code);
200: AHL_DEBUG_PUB.debug('Input Removal_Meaning:'|| p_x_parts_rec_tbl(i).Removal_Meaning);
201: AHL_DEBUG_PUB.debug('Input Removal_Reason_Id:'|| p_x_parts_rec_tbl(i).Removal_Reason_Id);
202: AHL_DEBUG_PUB.debug('Input Removal_Reason_Name:' || p_x_parts_rec_tbl(i).Removal_Reason_Name);
203: AHL_DEBUG_PUB.debug('Input Removal_Date:' || p_x_parts_rec_tbl(i).Removal_Date);
204: --AHL_DEBUG_PUB.debug('Input Condition_Id:' || p_x_parts_rec_tbl(i).Condition_Id);
205: --AHL_DEBUG_PUB.debug('Input Locator_id:'|| p_x_parts_rec_tbl(i).Locator_id);
206: --AHL_DEBUG_PUB.debug('Input Locator_code:'|| p_x_parts_rec_tbl(i).Locator_code);
207: --AHL_DEBUG_PUB.debug('Input Subinventory_code:'|| p_x_parts_rec_tbl(i).Subinventory_code);

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

200: AHL_DEBUG_PUB.debug('Input Removal_Meaning:'|| p_x_parts_rec_tbl(i).Removal_Meaning);
201: AHL_DEBUG_PUB.debug('Input Removal_Reason_Id:'|| p_x_parts_rec_tbl(i).Removal_Reason_Id);
202: AHL_DEBUG_PUB.debug('Input Removal_Reason_Name:' || p_x_parts_rec_tbl(i).Removal_Reason_Name);
203: AHL_DEBUG_PUB.debug('Input Removal_Date:' || p_x_parts_rec_tbl(i).Removal_Date);
204: --AHL_DEBUG_PUB.debug('Input Condition_Id:' || p_x_parts_rec_tbl(i).Condition_Id);
205: --AHL_DEBUG_PUB.debug('Input Locator_id:'|| p_x_parts_rec_tbl(i).Locator_id);
206: --AHL_DEBUG_PUB.debug('Input Locator_code:'|| p_x_parts_rec_tbl(i).Locator_code);
207: --AHL_DEBUG_PUB.debug('Input Subinventory_code:'|| p_x_parts_rec_tbl(i).Subinventory_code);
208: --AHL_DEBUG_PUB.debug('Input Severity_id:' || p_x_parts_rec_tbl(i).Severity_id);

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

201: AHL_DEBUG_PUB.debug('Input Removal_Reason_Id:'|| p_x_parts_rec_tbl(i).Removal_Reason_Id);
202: AHL_DEBUG_PUB.debug('Input Removal_Reason_Name:' || p_x_parts_rec_tbl(i).Removal_Reason_Name);
203: AHL_DEBUG_PUB.debug('Input Removal_Date:' || p_x_parts_rec_tbl(i).Removal_Date);
204: --AHL_DEBUG_PUB.debug('Input Condition_Id:' || p_x_parts_rec_tbl(i).Condition_Id);
205: --AHL_DEBUG_PUB.debug('Input Locator_id:'|| p_x_parts_rec_tbl(i).Locator_id);
206: --AHL_DEBUG_PUB.debug('Input Locator_code:'|| p_x_parts_rec_tbl(i).Locator_code);
207: --AHL_DEBUG_PUB.debug('Input Subinventory_code:'|| p_x_parts_rec_tbl(i).Subinventory_code);
208: --AHL_DEBUG_PUB.debug('Input Severity_id:' || p_x_parts_rec_tbl(i).Severity_id);
209: AHL_DEBUG_PUB.debug('Input Csi_II_Relationship_Id:' || p_x_parts_rec_tbl(i).Csi_II_Relationship_Id);

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

202: AHL_DEBUG_PUB.debug('Input Removal_Reason_Name:' || p_x_parts_rec_tbl(i).Removal_Reason_Name);
203: AHL_DEBUG_PUB.debug('Input Removal_Date:' || p_x_parts_rec_tbl(i).Removal_Date);
204: --AHL_DEBUG_PUB.debug('Input Condition_Id:' || p_x_parts_rec_tbl(i).Condition_Id);
205: --AHL_DEBUG_PUB.debug('Input Locator_id:'|| p_x_parts_rec_tbl(i).Locator_id);
206: --AHL_DEBUG_PUB.debug('Input Locator_code:'|| p_x_parts_rec_tbl(i).Locator_code);
207: --AHL_DEBUG_PUB.debug('Input Subinventory_code:'|| p_x_parts_rec_tbl(i).Subinventory_code);
208: --AHL_DEBUG_PUB.debug('Input Severity_id:' || p_x_parts_rec_tbl(i).Severity_id);
209: AHL_DEBUG_PUB.debug('Input Csi_II_Relationship_Id:' || p_x_parts_rec_tbl(i).Csi_II_Relationship_Id);
210: AHL_DEBUG_PUB.debug('Input CSI_II_OBJECT_VERSION_NUM:' || p_x_parts_rec_tbl(i).CSI_II_OBJECT_VERSION_NUM);

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

203: AHL_DEBUG_PUB.debug('Input Removal_Date:' || p_x_parts_rec_tbl(i).Removal_Date);
204: --AHL_DEBUG_PUB.debug('Input Condition_Id:' || p_x_parts_rec_tbl(i).Condition_Id);
205: --AHL_DEBUG_PUB.debug('Input Locator_id:'|| p_x_parts_rec_tbl(i).Locator_id);
206: --AHL_DEBUG_PUB.debug('Input Locator_code:'|| p_x_parts_rec_tbl(i).Locator_code);
207: --AHL_DEBUG_PUB.debug('Input Subinventory_code:'|| p_x_parts_rec_tbl(i).Subinventory_code);
208: --AHL_DEBUG_PUB.debug('Input Severity_id:' || p_x_parts_rec_tbl(i).Severity_id);
209: AHL_DEBUG_PUB.debug('Input Csi_II_Relationship_Id:' || p_x_parts_rec_tbl(i).Csi_II_Relationship_Id);
210: AHL_DEBUG_PUB.debug('Input CSI_II_OBJECT_VERSION_NUM:' || p_x_parts_rec_tbl(i).CSI_II_OBJECT_VERSION_NUM);
211: --AHL_DEBUG_PUB.debug('Input Target_Visit_Num:'|| p_x_parts_rec_tbl(i).Target_Visit_Num);

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

204: --AHL_DEBUG_PUB.debug('Input Condition_Id:' || p_x_parts_rec_tbl(i).Condition_Id);
205: --AHL_DEBUG_PUB.debug('Input Locator_id:'|| p_x_parts_rec_tbl(i).Locator_id);
206: --AHL_DEBUG_PUB.debug('Input Locator_code:'|| p_x_parts_rec_tbl(i).Locator_code);
207: --AHL_DEBUG_PUB.debug('Input Subinventory_code:'|| p_x_parts_rec_tbl(i).Subinventory_code);
208: --AHL_DEBUG_PUB.debug('Input Severity_id:' || p_x_parts_rec_tbl(i).Severity_id);
209: AHL_DEBUG_PUB.debug('Input Csi_II_Relationship_Id:' || p_x_parts_rec_tbl(i).Csi_II_Relationship_Id);
210: AHL_DEBUG_PUB.debug('Input CSI_II_OBJECT_VERSION_NUM:' || p_x_parts_rec_tbl(i).CSI_II_OBJECT_VERSION_NUM);
211: --AHL_DEBUG_PUB.debug('Input Target_Visit_Num:'|| p_x_parts_rec_tbl(i).Target_Visit_Num);
212: --AHL_DEBUG_PUB.debug('Input Target_Visit_Id:' || p_x_parts_rec_tbl(i).Target_Visit_Id);

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

205: --AHL_DEBUG_PUB.debug('Input Locator_id:'|| p_x_parts_rec_tbl(i).Locator_id);
206: --AHL_DEBUG_PUB.debug('Input Locator_code:'|| p_x_parts_rec_tbl(i).Locator_code);
207: --AHL_DEBUG_PUB.debug('Input Subinventory_code:'|| p_x_parts_rec_tbl(i).Subinventory_code);
208: --AHL_DEBUG_PUB.debug('Input Severity_id:' || p_x_parts_rec_tbl(i).Severity_id);
209: AHL_DEBUG_PUB.debug('Input Csi_II_Relationship_Id:' || p_x_parts_rec_tbl(i).Csi_II_Relationship_Id);
210: AHL_DEBUG_PUB.debug('Input CSI_II_OBJECT_VERSION_NUM:' || p_x_parts_rec_tbl(i).CSI_II_OBJECT_VERSION_NUM);
211: --AHL_DEBUG_PUB.debug('Input Target_Visit_Num:'|| p_x_parts_rec_tbl(i).Target_Visit_Num);
212: --AHL_DEBUG_PUB.debug('Input Target_Visit_Id:' || p_x_parts_rec_tbl(i).Target_Visit_Id);
213: --AHL_DEBUG_PUB.debug('Input Problem_Code:' || p_x_parts_rec_tbl(i).Problem_Code);

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

206: --AHL_DEBUG_PUB.debug('Input Locator_code:'|| p_x_parts_rec_tbl(i).Locator_code);
207: --AHL_DEBUG_PUB.debug('Input Subinventory_code:'|| p_x_parts_rec_tbl(i).Subinventory_code);
208: --AHL_DEBUG_PUB.debug('Input Severity_id:' || p_x_parts_rec_tbl(i).Severity_id);
209: AHL_DEBUG_PUB.debug('Input Csi_II_Relationship_Id:' || p_x_parts_rec_tbl(i).Csi_II_Relationship_Id);
210: AHL_DEBUG_PUB.debug('Input CSI_II_OBJECT_VERSION_NUM:' || p_x_parts_rec_tbl(i).CSI_II_OBJECT_VERSION_NUM);
211: --AHL_DEBUG_PUB.debug('Input Target_Visit_Num:'|| p_x_parts_rec_tbl(i).Target_Visit_Num);
212: --AHL_DEBUG_PUB.debug('Input Target_Visit_Id:' || p_x_parts_rec_tbl(i).Target_Visit_Id);
213: --AHL_DEBUG_PUB.debug('Input Problem_Code:' || p_x_parts_rec_tbl(i).Problem_Code);
214: --AHL_DEBUG_PUB.debug('Input Problem_Meaning:'|| p_x_parts_rec_tbl(i).Problem_Meaning);

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

207: --AHL_DEBUG_PUB.debug('Input Subinventory_code:'|| p_x_parts_rec_tbl(i).Subinventory_code);
208: --AHL_DEBUG_PUB.debug('Input Severity_id:' || p_x_parts_rec_tbl(i).Severity_id);
209: AHL_DEBUG_PUB.debug('Input Csi_II_Relationship_Id:' || p_x_parts_rec_tbl(i).Csi_II_Relationship_Id);
210: AHL_DEBUG_PUB.debug('Input CSI_II_OBJECT_VERSION_NUM:' || p_x_parts_rec_tbl(i).CSI_II_OBJECT_VERSION_NUM);
211: --AHL_DEBUG_PUB.debug('Input Target_Visit_Num:'|| p_x_parts_rec_tbl(i).Target_Visit_Num);
212: --AHL_DEBUG_PUB.debug('Input Target_Visit_Id:' || p_x_parts_rec_tbl(i).Target_Visit_Id);
213: --AHL_DEBUG_PUB.debug('Input Problem_Code:' || p_x_parts_rec_tbl(i).Problem_Code);
214: --AHL_DEBUG_PUB.debug('Input Problem_Meaning:'|| p_x_parts_rec_tbl(i).Problem_Meaning);
215: AHL_DEBUG_PUB.debug('Input Operation_Type:' || p_x_parts_rec_tbl(i).Operation_Type);

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

208: --AHL_DEBUG_PUB.debug('Input Severity_id:' || p_x_parts_rec_tbl(i).Severity_id);
209: AHL_DEBUG_PUB.debug('Input Csi_II_Relationship_Id:' || p_x_parts_rec_tbl(i).Csi_II_Relationship_Id);
210: AHL_DEBUG_PUB.debug('Input CSI_II_OBJECT_VERSION_NUM:' || p_x_parts_rec_tbl(i).CSI_II_OBJECT_VERSION_NUM);
211: --AHL_DEBUG_PUB.debug('Input Target_Visit_Num:'|| p_x_parts_rec_tbl(i).Target_Visit_Num);
212: --AHL_DEBUG_PUB.debug('Input Target_Visit_Id:' || p_x_parts_rec_tbl(i).Target_Visit_Id);
213: --AHL_DEBUG_PUB.debug('Input Problem_Code:' || p_x_parts_rec_tbl(i).Problem_Code);
214: --AHL_DEBUG_PUB.debug('Input Problem_Meaning:'|| p_x_parts_rec_tbl(i).Problem_Meaning);
215: AHL_DEBUG_PUB.debug('Input Operation_Type:' || p_x_parts_rec_tbl(i).Operation_Type);
216: --AHL_DEBUG_PUB.debug('Input Summary:'|| p_x_parts_rec_tbl(i).Summary);

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

209: AHL_DEBUG_PUB.debug('Input Csi_II_Relationship_Id:' || p_x_parts_rec_tbl(i).Csi_II_Relationship_Id);
210: AHL_DEBUG_PUB.debug('Input CSI_II_OBJECT_VERSION_NUM:' || p_x_parts_rec_tbl(i).CSI_II_OBJECT_VERSION_NUM);
211: --AHL_DEBUG_PUB.debug('Input Target_Visit_Num:'|| p_x_parts_rec_tbl(i).Target_Visit_Num);
212: --AHL_DEBUG_PUB.debug('Input Target_Visit_Id:' || p_x_parts_rec_tbl(i).Target_Visit_Id);
213: --AHL_DEBUG_PUB.debug('Input Problem_Code:' || p_x_parts_rec_tbl(i).Problem_Code);
214: --AHL_DEBUG_PUB.debug('Input Problem_Meaning:'|| p_x_parts_rec_tbl(i).Problem_Meaning);
215: AHL_DEBUG_PUB.debug('Input Operation_Type:' || p_x_parts_rec_tbl(i).Operation_Type);
216: --AHL_DEBUG_PUB.debug('Input Summary:'|| p_x_parts_rec_tbl(i).Summary);
217: --AHL_DEBUG_PUB.debug('Input estimated_duration:'|| p_x_parts_rec_tbl(i).estimated_duration);

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

210: AHL_DEBUG_PUB.debug('Input CSI_II_OBJECT_VERSION_NUM:' || p_x_parts_rec_tbl(i).CSI_II_OBJECT_VERSION_NUM);
211: --AHL_DEBUG_PUB.debug('Input Target_Visit_Num:'|| p_x_parts_rec_tbl(i).Target_Visit_Num);
212: --AHL_DEBUG_PUB.debug('Input Target_Visit_Id:' || p_x_parts_rec_tbl(i).Target_Visit_Id);
213: --AHL_DEBUG_PUB.debug('Input Problem_Code:' || p_x_parts_rec_tbl(i).Problem_Code);
214: --AHL_DEBUG_PUB.debug('Input Problem_Meaning:'|| p_x_parts_rec_tbl(i).Problem_Meaning);
215: AHL_DEBUG_PUB.debug('Input Operation_Type:' || p_x_parts_rec_tbl(i).Operation_Type);
216: --AHL_DEBUG_PUB.debug('Input Summary:'|| p_x_parts_rec_tbl(i).Summary);
217: --AHL_DEBUG_PUB.debug('Input estimated_duration:'|| p_x_parts_rec_tbl(i).estimated_duration);
218: AHL_DEBUG_PUB.debug('Input Installed_Instance_Obj_Ver_Num:'|| p_x_parts_rec_tbl(i).Installed_Instance_Obj_Ver_Num);

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

211: --AHL_DEBUG_PUB.debug('Input Target_Visit_Num:'|| p_x_parts_rec_tbl(i).Target_Visit_Num);
212: --AHL_DEBUG_PUB.debug('Input Target_Visit_Id:' || p_x_parts_rec_tbl(i).Target_Visit_Id);
213: --AHL_DEBUG_PUB.debug('Input Problem_Code:' || p_x_parts_rec_tbl(i).Problem_Code);
214: --AHL_DEBUG_PUB.debug('Input Problem_Meaning:'|| p_x_parts_rec_tbl(i).Problem_Meaning);
215: AHL_DEBUG_PUB.debug('Input Operation_Type:' || p_x_parts_rec_tbl(i).Operation_Type);
216: --AHL_DEBUG_PUB.debug('Input Summary:'|| p_x_parts_rec_tbl(i).Summary);
217: --AHL_DEBUG_PUB.debug('Input estimated_duration:'|| p_x_parts_rec_tbl(i).estimated_duration);
218: AHL_DEBUG_PUB.debug('Input Installed_Instance_Obj_Ver_Num:'|| p_x_parts_rec_tbl(i).Installed_Instance_Obj_Ver_Num);
219: AHL_DEBUG_PUB.debug('Input Removed_INSTANCE_OBJ_VER_NUM:'|| p_x_parts_rec_tbl(i).Removed_INSTANCE_OBJ_VER_NUM);

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

212: --AHL_DEBUG_PUB.debug('Input Target_Visit_Id:' || p_x_parts_rec_tbl(i).Target_Visit_Id);
213: --AHL_DEBUG_PUB.debug('Input Problem_Code:' || p_x_parts_rec_tbl(i).Problem_Code);
214: --AHL_DEBUG_PUB.debug('Input Problem_Meaning:'|| p_x_parts_rec_tbl(i).Problem_Meaning);
215: AHL_DEBUG_PUB.debug('Input Operation_Type:' || p_x_parts_rec_tbl(i).Operation_Type);
216: --AHL_DEBUG_PUB.debug('Input Summary:'|| p_x_parts_rec_tbl(i).Summary);
217: --AHL_DEBUG_PUB.debug('Input estimated_duration:'|| p_x_parts_rec_tbl(i).estimated_duration);
218: AHL_DEBUG_PUB.debug('Input Installed_Instance_Obj_Ver_Num:'|| p_x_parts_rec_tbl(i).Installed_Instance_Obj_Ver_Num);
219: AHL_DEBUG_PUB.debug('Input Removed_INSTANCE_OBJ_VER_NUM:'|| p_x_parts_rec_tbl(i).Removed_INSTANCE_OBJ_VER_NUM);
220:

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

213: --AHL_DEBUG_PUB.debug('Input Problem_Code:' || p_x_parts_rec_tbl(i).Problem_Code);
214: --AHL_DEBUG_PUB.debug('Input Problem_Meaning:'|| p_x_parts_rec_tbl(i).Problem_Meaning);
215: AHL_DEBUG_PUB.debug('Input Operation_Type:' || p_x_parts_rec_tbl(i).Operation_Type);
216: --AHL_DEBUG_PUB.debug('Input Summary:'|| p_x_parts_rec_tbl(i).Summary);
217: --AHL_DEBUG_PUB.debug('Input estimated_duration:'|| p_x_parts_rec_tbl(i).estimated_duration);
218: AHL_DEBUG_PUB.debug('Input Installed_Instance_Obj_Ver_Num:'|| p_x_parts_rec_tbl(i).Installed_Instance_Obj_Ver_Num);
219: AHL_DEBUG_PUB.debug('Input Removed_INSTANCE_OBJ_VER_NUM:'|| p_x_parts_rec_tbl(i).Removed_INSTANCE_OBJ_VER_NUM);
220:
221: END IF;

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

214: --AHL_DEBUG_PUB.debug('Input Problem_Meaning:'|| p_x_parts_rec_tbl(i).Problem_Meaning);
215: AHL_DEBUG_PUB.debug('Input Operation_Type:' || p_x_parts_rec_tbl(i).Operation_Type);
216: --AHL_DEBUG_PUB.debug('Input Summary:'|| p_x_parts_rec_tbl(i).Summary);
217: --AHL_DEBUG_PUB.debug('Input estimated_duration:'|| p_x_parts_rec_tbl(i).estimated_duration);
218: AHL_DEBUG_PUB.debug('Input Installed_Instance_Obj_Ver_Num:'|| p_x_parts_rec_tbl(i).Installed_Instance_Obj_Ver_Num);
219: AHL_DEBUG_PUB.debug('Input Removed_INSTANCE_OBJ_VER_NUM:'|| p_x_parts_rec_tbl(i).Removed_INSTANCE_OBJ_VER_NUM);
220:
221: END IF;
222:

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

215: AHL_DEBUG_PUB.debug('Input Operation_Type:' || p_x_parts_rec_tbl(i).Operation_Type);
216: --AHL_DEBUG_PUB.debug('Input Summary:'|| p_x_parts_rec_tbl(i).Summary);
217: --AHL_DEBUG_PUB.debug('Input estimated_duration:'|| p_x_parts_rec_tbl(i).estimated_duration);
218: AHL_DEBUG_PUB.debug('Input Installed_Instance_Obj_Ver_Num:'|| p_x_parts_rec_tbl(i).Installed_Instance_Obj_Ver_Num);
219: AHL_DEBUG_PUB.debug('Input Removed_INSTANCE_OBJ_VER_NUM:'|| p_x_parts_rec_tbl(i).Removed_INSTANCE_OBJ_VER_NUM);
220:
221: END IF;
222:
223: -- Set ids to null if the caller is jsp else go the id way

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

233: END IF;
234:
235: -- convert value to ids first
236: IF G_DEBUG = 'Y' THEN
237: AHL_DEBUG_PUB.debug('Calling convert_value_to_id');
238: END IF;
239: Convert_value_to_id(p_x_parts_rec => p_x_parts_rec_tbl(i),
240: X_Return_Status => x_return_status);
241:

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

246: END IF;
247:
248: -- dbms_output.put_line('After convert_value_to_id');
249: IF G_DEBUG = 'Y' THEN
250: AHL_DEBUG_PUB.debug('After convert_value_to_id');
251: -- Perform Validation Checks
252: AHL_DEBUG_PUB.debug('Calling perform validations ');
253: END IF;
254:

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

248: -- dbms_output.put_line('After convert_value_to_id');
249: IF G_DEBUG = 'Y' THEN
250: AHL_DEBUG_PUB.debug('After convert_value_to_id');
251: -- Perform Validation Checks
252: AHL_DEBUG_PUB.debug('Calling perform validations ');
253: END IF;
254:
255: Validate_part_record(
256: p_x_parts_rec => p_x_parts_rec_tbl(i),

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

276: -- *********************** UC Processing ********************************
277: IF (p_x_parts_rec_tbl(i).Unit_Config_Header_Id is not null) then
278: -- dbms_output.put_line('Callung UC config');
279: IF G_DEBUG = 'Y' THEN
280: AHL_DEBUG_PUB.debug('Callung UC config');
281: END IF;
282:
283: Process_UC(
284: p_x_parts_rec => p_x_parts_rec_tbl(i),

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

287: x_return_status => x_return_status,
288: x_path_position_id => l_path_position_id,
289: x_warning_msg_tbl => x_warning_msg_tbl);
290: IF G_DEBUG = 'Y' THEN
291: AHL_DEBUG_PUB.debug('x_return_status after uc config '|| x_return_status);
292:
293: END IF;
294:
295:

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

295:
296: -- *********************** IB Processing ********************************
297: ELSE
298: IF G_DEBUG = 'Y' THEN
299: AHL_DEBUG_PUB.debug('IB Processing');
300: END IF;
301: -- dbms_output.put_line('IB processing');
302:
303: Process_IB(

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

341: IF ( (p_x_parts_rec_tbl(i).operation_type='D' or p_x_parts_rec_tbl(i).operation_type='M')
342: AND ( p_x_parts_rec_tbl(i).SubInventory_code is not null)) THEN
343:
344: IF G_DEBUG = 'Y' THEN
345: AHL_DEBUG_PUB.debug('inside material txn call');
346: END IF;
347: --Call material transaction api
348: Process_material_txn(
349: p_x_parts_rec => p_x_parts_rec_tbl(i),

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

447: /* ER#
448: -- Create Service Request for the Parts records if operation type = D or M andbased on condition.
449:
450: IF G_DEBUG = 'Y' THEN
451: AHL_DEBUG_PUB.debug('Calling SR');
452: END IF;
453: --Call sr api
454: Process_SR(
455: p_x_parts_rec_tbl => p_x_parts_rec_tbl,

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

472: -- Initialize API return status to success
473: x_return_status := FND_API.G_RET_STS_SUCCESS;
474:
475: IF G_DEBUG = 'Y' THEN
476: AHL_DEBUG_PUB.debug('Completed Processing. Checking for errors', '');
477: END IF;
478:
479: -- Standard call to get message count and if count is 1, get message
480: FND_MSG_PUB.Count_And_Get

Line 487: AHL_DEBUG_PUB.disable_debug;

483: p_encoded => fnd_api.g_false);
484:
485: -- Disable debug (if enabled)
486: IF G_DEBUG = 'Y' THEN
487: AHL_DEBUG_PUB.disable_debug;
488: END IF;
489:
490: EXCEPTION
491: WHEN FND_API.G_EXC_ERROR THEN

Line 499: AHL_DEBUG_PUB.disable_debug;

495: p_data => x_msg_data,
496: p_encoded => fnd_api.g_false);
497: -- Disable debug
498: IF G_DEBUG = 'Y' THEN
499: AHL_DEBUG_PUB.disable_debug;
500: END IF;
501:
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 511: AHL_DEBUG_PUB.disable_debug;

507: p_data => x_msg_data,
508: p_encoded => fnd_api.g_false);
509: -- Disable debug
510: IF G_DEBUG = 'Y' THEN
511: AHL_DEBUG_PUB.disable_debug;
512: END IF;
513: WHEN OTHERS THEN
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: Rollback to perform_part_changes_pvt;

Line 527: AHL_DEBUG_PUB.disable_debug;

523: p_encoded => fnd_api.g_false);
524:
525: -- Disable debug
526: IF G_DEBUG = 'Y' THEN
527: AHL_DEBUG_PUB.disable_debug;
528: END IF;
529:
530: End Process_Part;
531: ---------------------------------

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

1507: CLOSE get_wip_job_csr;
1508:
1509: IF ( p_x_parts_rec.operation_type ='D') then
1510: IF G_DEBUG = 'Y' THEN
1511: AHL_DEBUG_PUB.debug('Before making a call to AHL_UC_INSTANCE_PVT.remove_instance.');
1512: END IF;
1513:
1514: -- find the path_position_id for the removed instance.
1515:

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

1597: END IF;
1598: CLOSE removal_instance_id;
1599: END IF;
1600: IF G_DEBUG = 'Y' THEN
1601: AHL_DEBUG_PUB.debug('1 final p_x_parts_rec.Removed_Instance_Id ' || p_x_parts_rec.Removed_Instance_Id);
1602: AHL_DEBUG_PUB.debug('l_final_removed_inst_id ' || l_final_removed_inst_id);
1603: END IF;
1604:
1605: ELSE -- non-serialized incomplete removal

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

1598: CLOSE removal_instance_id;
1599: END IF;
1600: IF G_DEBUG = 'Y' THEN
1601: AHL_DEBUG_PUB.debug('1 final p_x_parts_rec.Removed_Instance_Id ' || p_x_parts_rec.Removed_Instance_Id);
1602: AHL_DEBUG_PUB.debug('l_final_removed_inst_id ' || l_final_removed_inst_id);
1603: END IF;
1604:
1605: ELSE -- non-serialized incomplete removal
1606:

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

1682: p_prod_user_flag => 'Y',
1683: x_warning_msg_tbl => x_warning_msg_tbl);
1684:
1685: IF G_DEBUG = 'Y' THEN
1686: AHL_DEBUG_PUB.debug('After making a call to AHL_UC_INSTANCE_PVT.install_existing_instance.');
1687: END IF;
1688:
1689: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1690: RAISE FND_API.G_EXC_ERROR;

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

1693: END IF;
1694:
1695: p_x_parts_rec.Removed_Instance_Id := l_dest_instance_id;
1696: IF G_DEBUG = 'Y' THEN
1697: AHL_DEBUG_PUB.debug('update_item_location :: ' ||l_dest_instance_id);
1698: END IF;
1699: /*update_item_location(
1700: p_x_parts_rec => p_x_parts_rec,
1701: p_x_csi_transaction_rec => p_x_csi_transaction_rec,

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

1707: l_move_item_instance_tbl(1).instance_id := p_x_parts_rec.Removed_Instance_Id;
1708: l_move_item_instance_tbl(1).quantity := p_x_parts_rec.Removed_Quantity;
1709: l_move_item_instance_tbl(1).to_workorder_id := p_x_parts_rec.workorder_id;
1710: IF G_DEBUG = 'Y' THEN
1711: AHL_DEBUG_PUB.debug('moving it');
1712: END IF;
1713: move_instance_location(
1714: P_API_Version => 1.0,
1715: P_Init_Msg_List => Fnd_API.G_False,

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

1734: END IF;
1735: CLOSE removal_instance_id;
1736: --p_x_parts_rec.Removed_Instance_Id := 274689;
1737: IF G_DEBUG = 'Y' THEN
1738: AHL_DEBUG_PUB.debug('2 final p_x_parts_rec.Removed_Instance_Id ' || p_x_parts_rec.Removed_Instance_Id);
1739: AHL_DEBUG_PUB.debug('l_final_removed_inst_id ' || l_final_removed_inst_id);
1740: END IF;
1741:
1742: END IF;

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

1735: CLOSE removal_instance_id;
1736: --p_x_parts_rec.Removed_Instance_Id := 274689;
1737: IF G_DEBUG = 'Y' THEN
1738: AHL_DEBUG_PUB.debug('2 final p_x_parts_rec.Removed_Instance_Id ' || p_x_parts_rec.Removed_Instance_Id);
1739: AHL_DEBUG_PUB.debug('l_final_removed_inst_id ' || l_final_removed_inst_id);
1740: END IF;
1741:
1742: END IF;
1743:

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

1743:
1744: ELSIF ( p_x_parts_rec.operation_type ='C') then
1745:
1746: IF G_DEBUG = 'Y' THEN
1747: AHL_DEBUG_PUB.debug('Before making a call to AHL_UC_INSTANCE_PVT.install_existing_instance.');
1748: END IF;
1749:
1750: l_serialized := FND_API.G_FALSE;
1751: OPEN check_inst_nonserial(p_x_parts_rec.Installed_Instance_Id);

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

1831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1832: END IF;
1833:
1834: IF G_DEBUG = 'Y' THEN
1835: AHL_DEBUG_PUB.debug('After making a call to AHL_UC_INSTANCE_PVT.install_existing_instance.');
1836: END IF;
1837: ELSIF( l_serialized = FND_API.G_FALSE AND l_curr_config_qty <> 0) THEN
1838: AHL_UC_INSTANCE_PVT.remove_instance(
1839: p_api_version => 1.0,

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

1863: l_move_item_instance_tbl(1).instance_id := p_x_parts_rec.Removed_Instance_Id;
1864: l_move_item_instance_tbl(1).quantity := l_curr_config_qty;
1865: l_move_item_instance_tbl(1).to_workorder_id := p_x_parts_rec.workorder_id;
1866: IF G_DEBUG = 'Y' THEN
1867: AHL_DEBUG_PUB.debug('moving it');
1868: END IF;
1869: move_instance_location(
1870: P_API_Version => 1.0,
1871: P_Init_Msg_List => Fnd_API.G_False,

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

1952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1953: END IF;
1954:
1955: IF G_DEBUG = 'Y' THEN
1956: AHL_DEBUG_PUB.debug('After making a call to AHL_UC_INSTANCE_PVT.install_existing_instance.');
1957: END IF;
1958: END IF;
1959:
1960: ELSIF (p_x_parts_rec.operation_type ='M') then

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

1959:
1960: ELSIF (p_x_parts_rec.operation_type ='M') then
1961:
1962: IF G_DEBUG = 'Y' THEN
1963: AHL_DEBUG_PUB.debug('Before making a call to AHL_UC_INSTANCE_PVT.swap_instance.');
1964: END IF;
1965: --Call swap_instance
1966: AHL_UC_INSTANCE_PVT.swap_instance(
1967: p_api_version => 1.0,

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

1981: p_prod_user_flag => 'Y',
1982: x_warning_msg_tbl => x_warning_msg_tbl);
1983:
1984: IF G_DEBUG = 'Y' THEN
1985: AHL_DEBUG_PUB.debug('After making a call to AHL_UC_INSTANCE_PVT.swap_instance.');
1986: END IF;
1987:
1988: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1989: RAISE FND_API.G_EXC_ERROR;

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

2037: p_csi_item_instance_id => p_x_parts_rec.Installed_instance_id,
2038: x_path_position_id => x_path_position_id);
2039:
2040: IF G_DEBUG = 'Y' THEN
2041: AHL_DEBUG_PUB.debug('p_x_parts_rec.Installed_Instance_Id ' ||p_x_parts_rec.Installed_Instance_Id);
2042: AHL_DEBUG_PUB.debug('After Install/swap AHL_UC_INSTANCE_PVT' || x_path_position_id);
2043: END IF;
2044:
2045: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

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

2038: x_path_position_id => x_path_position_id);
2039:
2040: IF G_DEBUG = 'Y' THEN
2041: AHL_DEBUG_PUB.debug('p_x_parts_rec.Installed_Instance_Id ' ||p_x_parts_rec.Installed_Instance_Id);
2042: AHL_DEBUG_PUB.debug('After Install/swap AHL_UC_INSTANCE_PVT' || x_path_position_id);
2043: END IF;
2044:
2045: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2046: RAISE FND_API.G_EXC_ERROR;

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

2174: --Installing
2175: IF (p_x_parts_rec.operation_type = 'C' ) then
2176:
2177: IF G_DEBUG = 'Y' THEN
2178: AHL_DEBUG_PUB.debug('IB Processing- Create');
2179: END IF;
2180:
2181: l_serialized := FND_API.G_FALSE;
2182: OPEN check_inst_nonserial(p_x_parts_rec.Installed_Instance_Id);

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

2209: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2211: END IF;
2212: IF G_DEBUG = 'Y' THEN
2213: AHL_DEBUG_PUB.debug('Sunil 1 p_x_parts_rec.Installed_Instance_Id : ' || p_x_parts_rec.Installed_Instance_Id);
2214: AHL_DEBUG_PUB.debug('Sunil p_x_parts_rec.Installed_Quantity ' || p_x_parts_rec.Installed_Quantity);
2215: END IF;
2216: -- update installed instance qty to equal to installed qty
2217: l_instance_rec.instance_id := p_x_parts_rec.Installed_Instance_Id;

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

2210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2211: END IF;
2212: IF G_DEBUG = 'Y' THEN
2213: AHL_DEBUG_PUB.debug('Sunil 1 p_x_parts_rec.Installed_Instance_Id : ' || p_x_parts_rec.Installed_Instance_Id);
2214: AHL_DEBUG_PUB.debug('Sunil p_x_parts_rec.Installed_Quantity ' || p_x_parts_rec.Installed_Quantity);
2215: END IF;
2216: -- update installed instance qty to equal to installed qty
2217: l_instance_rec.instance_id := p_x_parts_rec.Installed_Instance_Id;
2218: l_instance_rec.quantity := p_x_parts_rec.Installed_Quantity;

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

2238: l_instance_rec.Install_Date := NULL;
2239: l_instance_rec.object_version_number := NULL;
2240:
2241: IF G_DEBUG = 'Y' THEN
2242: AHL_DEBUG_PUB.debug('Sunil : Updated installed instance qty to : ' || p_x_parts_rec.Installed_Quantity);
2243:
2244: END IF;
2245: END IF;
2246:

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

2282: l_instance_rec.object_version_number := NULL;
2283:
2284:
2285: IF G_DEBUG = 'Y' THEN
2286: AHL_DEBUG_PUB.debug('Sunil : Updated fake installed instance qty to : 0 ');
2287: END IF;
2288:
2289: OPEN get_curr_quantity_csr(p_x_parts_rec.Removed_Instance_Id);
2290: FETCH get_curr_quantity_csr INTO l_curr_config_qty;

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

2296: l_instance_rec.Install_Date := p_x_parts_rec.Installation_Date;
2297:
2298:
2299: IF G_DEBUG = 'Y' THEN
2300: AHL_DEBUG_PUB.debug('Sunil2 : p_x_parts_rec.Removed_Instance_Id : ' || p_x_parts_rec.Removed_Instance_Id);
2301: AHL_DEBUG_PUB.debug('Sunil2 : net config qty : ' || l_instance_rec.quantity);
2302: END IF;
2303:
2304: OPEN csi_item_instance_csr(p_x_parts_rec.Installed_Instance_Id);

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

2297:
2298:
2299: IF G_DEBUG = 'Y' THEN
2300: AHL_DEBUG_PUB.debug('Sunil2 : p_x_parts_rec.Removed_Instance_Id : ' || p_x_parts_rec.Removed_Instance_Id);
2301: AHL_DEBUG_PUB.debug('Sunil2 : net config qty : ' || l_instance_rec.quantity);
2302: END IF;
2303:
2304: OPEN csi_item_instance_csr(p_x_parts_rec.Installed_Instance_Id);
2305: FETCH csi_item_instance_csr INTO p_x_parts_rec.Installed_Instance_Num

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

2311: x_return_status => x_return_status
2312: );
2313:
2314: IF G_DEBUG = 'Y' THEN
2315: AHL_DEBUG_PUB.debug('Sunil : Updated qty on config to : ' || l_instance_rec.quantity);
2316: END IF;
2317:
2318: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2319: RAISE FND_API.G_EXC_ERROR;

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

2326: l_instance_rec.Install_Date := NULL;
2327: l_instance_rec.object_version_number := NULL;
2328:
2329: IF G_DEBUG = 'Y' THEN
2330: AHL_DEBUG_PUB.debug('Sunil : completed partial install : ');
2331: END IF;
2332:
2333:
2334: END IF;

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

2336: -- Removing a part
2337: ELSIF (p_x_parts_rec.operation_type = 'D' ) then
2338: -- dbms_output.put_line('IB processing- remove');
2339: IF G_DEBUG = 'Y' THEN
2340: AHL_DEBUG_PUB.debug('IB Processing- Remove');
2341: END IF;
2342: --Test that the part removed is ib config indeed
2343: l_unit_config_header_name:= AHL_UMP_UTIL_PKG.get_UnitName(p_x_parts_rec.removed_instance_id);
2344:

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

2414: END IF;
2415: CLOSE removal_instance_id;
2416: END IF;
2417: IF G_DEBUG = 'Y' THEN
2418: AHL_DEBUG_PUB.debug('1 final p_x_parts_rec.Removed_Instance_Id ' || p_x_parts_rec.Removed_Instance_Id);
2419: AHL_DEBUG_PUB.debug('l_final_removed_inst_id ' || l_final_removed_inst_id);
2420: END IF;
2421: ELSE -- non-serialized incomplete removal
2422:

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

2415: CLOSE removal_instance_id;
2416: END IF;
2417: IF G_DEBUG = 'Y' THEN
2418: AHL_DEBUG_PUB.debug('1 final p_x_parts_rec.Removed_Instance_Id ' || p_x_parts_rec.Removed_Instance_Id);
2419: AHL_DEBUG_PUB.debug('l_final_removed_inst_id ' || l_final_removed_inst_id);
2420: END IF;
2421: ELSE -- non-serialized incomplete removal
2422:
2423: csi_ii_relationships_pub.expire_relationship(

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

2494: ,x_msg_count => l_msg_count
2495: ,x_msg_data => l_msg_data);
2496:
2497: IF G_DEBUG = 'Y' THEN
2498: AHL_DEBUG_PUB.debug('After making a call to csi_ii_relationships_pub.create_relationship.');
2499: END IF;
2500:
2501: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2502: RAISE FND_API.G_EXC_ERROR;

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

2505: END IF;
2506:
2507: p_x_parts_rec.Removed_Instance_Id := l_dest_instance_id;
2508: IF G_DEBUG = 'Y' THEN
2509: AHL_DEBUG_PUB.debug('update_item_location :: ' ||l_dest_instance_id);
2510: END IF;
2511: /*update_item_location(
2512: p_x_parts_rec => p_x_parts_rec,
2513: p_x_csi_transaction_rec => p_x_csi_transaction_rec,

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

2519: l_move_item_instance_tbl(1).instance_id := p_x_parts_rec.Removed_Instance_Id;
2520: l_move_item_instance_tbl(1).quantity := p_x_parts_rec.Removed_Quantity;
2521: l_move_item_instance_tbl(1).to_workorder_id := p_x_parts_rec.workorder_id;
2522: IF G_DEBUG = 'Y' THEN
2523: AHL_DEBUG_PUB.debug('moving it');
2524: END IF;
2525: move_instance_location(
2526: P_API_Version => 1.0,
2527: P_Init_Msg_List => Fnd_API.G_False,

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

2546: END IF;
2547: CLOSE removal_instance_id;
2548: --p_x_parts_rec.Removed_Instance_Id := 274689;
2549: IF G_DEBUG = 'Y' THEN
2550: AHL_DEBUG_PUB.debug('2 final p_x_parts_rec.Removed_Instance_Id ' || p_x_parts_rec.Removed_Instance_Id);
2551: AHL_DEBUG_PUB.debug('l_final_removed_inst_id ' || l_final_removed_inst_id);
2552: END IF;
2553:
2554: END IF;

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

2547: CLOSE removal_instance_id;
2548: --p_x_parts_rec.Removed_Instance_Id := 274689;
2549: IF G_DEBUG = 'Y' THEN
2550: AHL_DEBUG_PUB.debug('2 final p_x_parts_rec.Removed_Instance_Id ' || p_x_parts_rec.Removed_Instance_Id);
2551: AHL_DEBUG_PUB.debug('l_final_removed_inst_id ' || l_final_removed_inst_id);
2552: END IF;
2553:
2554: END IF;
2555:

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

2563: FND_MSG_PUB.ADD;
2564: --RAISE FND_API.G_EXC_ERROR;
2565: end if;
2566: IF G_DEBUG = 'Y' THEN
2567: AHL_DEBUG_PUB.debug('IB Processing- Swap');
2568: END IF;
2569: csi_ii_relationships_pub.update_relationship(
2570: p_api_version => 1.0
2571: ,p_relationship_tbl => l_csi_relationship_tbl

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

2579: l_move_item_instance_tbl(1).instance_id := p_x_parts_rec.Removed_Instance_Id;
2580: l_move_item_instance_tbl(1).quantity := p_x_parts_rec.Removed_Quantity;
2581: l_move_item_instance_tbl(1).to_workorder_id := p_x_parts_rec.workorder_id;
2582: IF G_DEBUG = 'Y' THEN
2583: AHL_DEBUG_PUB.debug('moving it');
2584: END IF;
2585:
2586: update_item_location(
2587: p_x_parts_rec => p_x_parts_rec,

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

2922: -- dbms_output.put_line('Sangita-x_return_status after SR'|| x_return_status);
2923:
2924:
2925: IF G_DEBUG = 'Y' THEN
2926: AHL_DEBUG_PUB.debug('Sangita-x_return_status after SR'|| x_return_status);
2927: END IF;
2928:
2929:
2930: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) then

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

2939:
2940: IF ( p_x_parts_rec_tbl(i).nonroutine_wo_id is not null ) then
2941: -- dbms_output.put_line('inside update part changes call');
2942: IF G_DEBUG = 'Y' THEN
2943: AHL_DEBUG_PUB.debug('inside update part changes call');
2944: END IF;
2945:
2946: AHL_PART_CHANGES_PKG.update_row(
2947: X_PART_CHANGE_ID => p_x_parts_rec_tbl(i).part_change_txn_id,

Line 3318: AHL_DEBUG_PUB.disable_debug;

3314: p_data => x_msg_data,
3315: p_encoded => fnd_api.g_false);
3316: -- Disable debug
3317: IF G_DEBUG = 'Y' THEN
3318: AHL_DEBUG_PUB.disable_debug;
3319: END IF;
3320:
3321:
3322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3330: AHL_DEBUG_PUB.disable_debug;

3326: p_data => x_msg_data,
3327: p_encoded => fnd_api.g_false);
3328: -- Disable debug
3329: IF G_DEBUG = 'Y' THEN
3330: AHL_DEBUG_PUB.disable_debug;
3331: END IF;
3332:
3333: WHEN OTHERS THEN
3334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3347: AHL_DEBUG_PUB.disable_debug;

3343: p_encoded => fnd_api.g_false);
3344:
3345: -- Disable debug
3346: IF G_DEBUG = 'Y' THEN
3347: AHL_DEBUG_PUB.disable_debug;
3348: END IF;
3349:
3350: END ReturnTo_Workorder_Locator;
3351: