[Home] [Help]
1: PACKAGE BODY AHL_EAM_JOB_PVT AS
2: /* $Header: AHLVEAMB.pls 120.8.12020000.2 2012/12/14 09:36:02 shnatu ship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_EAM_JOB_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6:
7: --Modified By Srini July 01, 2004
8: PROCEDURE log_path(
9: x_output_dir OUT NOCOPY VARCHAR2
108: x_debug_file_name := 'EAMDEBUG.log';
109: x_debug_file_mode := 'a';
110:
111: IF ( G_DEBUG = 'Y' ) THEN
112: AHL_DEBUG_PUB.debug( 'Debug Log Directory Path:'||x_output_dir );
113: AHL_DEBUG_PUB.debug( 'Debug Log File Name:'||x_debug_file_name );
114: END IF;
115:
116: END set_eam_debug_params;
109: x_debug_file_mode := 'a';
110:
111: IF ( G_DEBUG = 'Y' ) THEN
112: AHL_DEBUG_PUB.debug( 'Debug Log Directory Path:'||x_output_dir );
113: AHL_DEBUG_PUB.debug( 'Debug Log File Name:'||x_debug_file_name );
114: END IF;
115:
116: END set_eam_debug_params;
117: -- End of Modification
182: x_workorder_prefix := NULL;
183:
184: -- Log Input Values
185: IF ( G_DEBUG = 'Y' ) THEN
186: AHL_DEBUG_PUB.debug('Default Workorder Type profile: ' || l_DEFAULT_WORKORDER_TYPE);
187: AHL_DEBUG_PUB.debug('Planned Workorder Type profile: ' || l_PLANNED_WORKORDER_TYPE);
188: AHL_DEBUG_PUB.debug('Unplanned Workorder Type profile: ' || l_UNPLANNED_WORKORDER_TYPE);
189: AHL_DEBUG_PUB.debug('NonRoutine Workorder Type profile: ' || l_NONROUTINE_WORKORDER_TYPE);
190:
183:
184: -- Log Input Values
185: IF ( G_DEBUG = 'Y' ) THEN
186: AHL_DEBUG_PUB.debug('Default Workorder Type profile: ' || l_DEFAULT_WORKORDER_TYPE);
187: AHL_DEBUG_PUB.debug('Planned Workorder Type profile: ' || l_PLANNED_WORKORDER_TYPE);
188: AHL_DEBUG_PUB.debug('Unplanned Workorder Type profile: ' || l_UNPLANNED_WORKORDER_TYPE);
189: AHL_DEBUG_PUB.debug('NonRoutine Workorder Type profile: ' || l_NONROUTINE_WORKORDER_TYPE);
190:
191: AHL_DEBUG_PUB.debug('NonRoutine Workorder Prefix profile: ' || l_MR_prefix);
184: -- Log Input Values
185: IF ( G_DEBUG = 'Y' ) THEN
186: AHL_DEBUG_PUB.debug('Default Workorder Type profile: ' || l_DEFAULT_WORKORDER_TYPE);
187: AHL_DEBUG_PUB.debug('Planned Workorder Type profile: ' || l_PLANNED_WORKORDER_TYPE);
188: AHL_DEBUG_PUB.debug('Unplanned Workorder Type profile: ' || l_UNPLANNED_WORKORDER_TYPE);
189: AHL_DEBUG_PUB.debug('NonRoutine Workorder Type profile: ' || l_NONROUTINE_WORKORDER_TYPE);
190:
191: AHL_DEBUG_PUB.debug('NonRoutine Workorder Prefix profile: ' || l_MR_prefix);
192: AHL_DEBUG_PUB.debug('MR workorder prefix profile: ' || l_NR_prefix);
185: IF ( G_DEBUG = 'Y' ) THEN
186: AHL_DEBUG_PUB.debug('Default Workorder Type profile: ' || l_DEFAULT_WORKORDER_TYPE);
187: AHL_DEBUG_PUB.debug('Planned Workorder Type profile: ' || l_PLANNED_WORKORDER_TYPE);
188: AHL_DEBUG_PUB.debug('Unplanned Workorder Type profile: ' || l_UNPLANNED_WORKORDER_TYPE);
189: AHL_DEBUG_PUB.debug('NonRoutine Workorder Type profile: ' || l_NONROUTINE_WORKORDER_TYPE);
190:
191: AHL_DEBUG_PUB.debug('NonRoutine Workorder Prefix profile: ' || l_MR_prefix);
192: AHL_DEBUG_PUB.debug('MR workorder prefix profile: ' || l_NR_prefix);
193:
187: AHL_DEBUG_PUB.debug('Planned Workorder Type profile: ' || l_PLANNED_WORKORDER_TYPE);
188: AHL_DEBUG_PUB.debug('Unplanned Workorder Type profile: ' || l_UNPLANNED_WORKORDER_TYPE);
189: AHL_DEBUG_PUB.debug('NonRoutine Workorder Type profile: ' || l_NONROUTINE_WORKORDER_TYPE);
190:
191: AHL_DEBUG_PUB.debug('NonRoutine Workorder Prefix profile: ' || l_MR_prefix);
192: AHL_DEBUG_PUB.debug('MR workorder prefix profile: ' || l_NR_prefix);
193:
194:
195: AHL_DEBUG_PUB.debug('Input Visit Task: ' || p_visit_task_id);
188: AHL_DEBUG_PUB.debug('Unplanned Workorder Type profile: ' || l_UNPLANNED_WORKORDER_TYPE);
189: AHL_DEBUG_PUB.debug('NonRoutine Workorder Type profile: ' || l_NONROUTINE_WORKORDER_TYPE);
190:
191: AHL_DEBUG_PUB.debug('NonRoutine Workorder Prefix profile: ' || l_MR_prefix);
192: AHL_DEBUG_PUB.debug('MR workorder prefix profile: ' || l_NR_prefix);
193:
194:
195: AHL_DEBUG_PUB.debug('Input Visit Task: ' || p_visit_task_id);
196: AHL_DEBUG_PUB.debug('Input Master_workorder_flag: ' || p_master_workorder_flag);
191: AHL_DEBUG_PUB.debug('NonRoutine Workorder Prefix profile: ' || l_MR_prefix);
192: AHL_DEBUG_PUB.debug('MR workorder prefix profile: ' || l_NR_prefix);
193:
194:
195: AHL_DEBUG_PUB.debug('Input Visit Task: ' || p_visit_task_id);
196: AHL_DEBUG_PUB.debug('Input Master_workorder_flag: ' || p_master_workorder_flag);
197:
198: END IF;
199:
192: AHL_DEBUG_PUB.debug('MR workorder prefix profile: ' || l_NR_prefix);
193:
194:
195: AHL_DEBUG_PUB.debug('Input Visit Task: ' || p_visit_task_id);
196: AHL_DEBUG_PUB.debug('Input Master_workorder_flag: ' || p_master_workorder_flag);
197:
198: END IF;
199:
200: -- Check whether default profile has been set up or not
268: x_workorder_type := l_DEFAULT_WORKORDER_TYPE;
269: END IF;
270:
271: IF ( G_DEBUG = 'Y' ) THEN
272: AHL_DEBUG_PUB.debug('Workorder Type : ' || x_workorder_type);
273: AHL_DEBUG_PUB.debug('Workorder Prefix : ' || x_workorder_prefix);
274: END IF;
275:
276: END get_workorder_details;
269: END IF;
270:
271: IF ( G_DEBUG = 'Y' ) THEN
272: AHL_DEBUG_PUB.debug('Workorder Type : ' || x_workorder_type);
273: AHL_DEBUG_PUB.debug('Workorder Prefix : ' || x_workorder_prefix);
274: END IF;
275:
276: END get_workorder_details;
277:
296: BEGIN
297:
298: -- Log Input Values
299: IF ( G_DEBUG = 'Y' ) THEN
300: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_workorder_rec.dml_operation );
301: AHL_DEBUG_PUB.debug( 'batch_id: ' || TO_CHAR( p_workorder_rec.batch_id ) );
302: AHL_DEBUG_PUB.debug( 'header_id: ' || TO_CHAR( p_workorder_rec.header_id ) );
303: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_workorder_rec.workorder_id ) );
304: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_workorder_rec.organization_id ) );
297:
298: -- Log Input Values
299: IF ( G_DEBUG = 'Y' ) THEN
300: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_workorder_rec.dml_operation );
301: AHL_DEBUG_PUB.debug( 'batch_id: ' || TO_CHAR( p_workorder_rec.batch_id ) );
302: AHL_DEBUG_PUB.debug( 'header_id: ' || TO_CHAR( p_workorder_rec.header_id ) );
303: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_workorder_rec.workorder_id ) );
304: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_workorder_rec.organization_id ) );
305: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_workorder_rec.wip_entity_id ) );
298: -- Log Input Values
299: IF ( G_DEBUG = 'Y' ) THEN
300: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_workorder_rec.dml_operation );
301: AHL_DEBUG_PUB.debug( 'batch_id: ' || TO_CHAR( p_workorder_rec.batch_id ) );
302: AHL_DEBUG_PUB.debug( 'header_id: ' || TO_CHAR( p_workorder_rec.header_id ) );
303: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_workorder_rec.workorder_id ) );
304: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_workorder_rec.organization_id ) );
305: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_workorder_rec.wip_entity_id ) );
306: AHL_DEBUG_PUB.debug( 'job_number: ' || p_workorder_rec.job_number );
299: IF ( G_DEBUG = 'Y' ) THEN
300: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_workorder_rec.dml_operation );
301: AHL_DEBUG_PUB.debug( 'batch_id: ' || TO_CHAR( p_workorder_rec.batch_id ) );
302: AHL_DEBUG_PUB.debug( 'header_id: ' || TO_CHAR( p_workorder_rec.header_id ) );
303: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_workorder_rec.workorder_id ) );
304: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_workorder_rec.organization_id ) );
305: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_workorder_rec.wip_entity_id ) );
306: AHL_DEBUG_PUB.debug( 'job_number: ' || p_workorder_rec.job_number );
307: AHL_DEBUG_PUB.debug( 'job_description: ' || p_workorder_rec.job_description );
300: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_workorder_rec.dml_operation );
301: AHL_DEBUG_PUB.debug( 'batch_id: ' || TO_CHAR( p_workorder_rec.batch_id ) );
302: AHL_DEBUG_PUB.debug( 'header_id: ' || TO_CHAR( p_workorder_rec.header_id ) );
303: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_workorder_rec.workorder_id ) );
304: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_workorder_rec.organization_id ) );
305: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_workorder_rec.wip_entity_id ) );
306: AHL_DEBUG_PUB.debug( 'job_number: ' || p_workorder_rec.job_number );
307: AHL_DEBUG_PUB.debug( 'job_description: ' || p_workorder_rec.job_description );
308: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_workorder_rec.inventory_item_id ) );
301: AHL_DEBUG_PUB.debug( 'batch_id: ' || TO_CHAR( p_workorder_rec.batch_id ) );
302: AHL_DEBUG_PUB.debug( 'header_id: ' || TO_CHAR( p_workorder_rec.header_id ) );
303: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_workorder_rec.workorder_id ) );
304: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_workorder_rec.organization_id ) );
305: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_workorder_rec.wip_entity_id ) );
306: AHL_DEBUG_PUB.debug( 'job_number: ' || p_workorder_rec.job_number );
307: AHL_DEBUG_PUB.debug( 'job_description: ' || p_workorder_rec.job_description );
308: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_workorder_rec.inventory_item_id ) );
309: AHL_DEBUG_PUB.debug( 'item_instance_id: ' || TO_CHAR( p_workorder_rec.item_instance_id ) );
302: AHL_DEBUG_PUB.debug( 'header_id: ' || TO_CHAR( p_workorder_rec.header_id ) );
303: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_workorder_rec.workorder_id ) );
304: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_workorder_rec.organization_id ) );
305: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_workorder_rec.wip_entity_id ) );
306: AHL_DEBUG_PUB.debug( 'job_number: ' || p_workorder_rec.job_number );
307: AHL_DEBUG_PUB.debug( 'job_description: ' || p_workorder_rec.job_description );
308: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_workorder_rec.inventory_item_id ) );
309: AHL_DEBUG_PUB.debug( 'item_instance_id: ' || TO_CHAR( p_workorder_rec.item_instance_id ) );
310: AHL_DEBUG_PUB.debug( 'class_code: ' || p_workorder_rec.class_code );
303: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_workorder_rec.workorder_id ) );
304: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_workorder_rec.organization_id ) );
305: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_workorder_rec.wip_entity_id ) );
306: AHL_DEBUG_PUB.debug( 'job_number: ' || p_workorder_rec.job_number );
307: AHL_DEBUG_PUB.debug( 'job_description: ' || p_workorder_rec.job_description );
308: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_workorder_rec.inventory_item_id ) );
309: AHL_DEBUG_PUB.debug( 'item_instance_id: ' || TO_CHAR( p_workorder_rec.item_instance_id ) );
310: AHL_DEBUG_PUB.debug( 'class_code: ' || p_workorder_rec.class_code );
311: AHL_DEBUG_PUB.debug( 'status_code: ' || p_workorder_rec.status_code );
304: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_workorder_rec.organization_id ) );
305: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_workorder_rec.wip_entity_id ) );
306: AHL_DEBUG_PUB.debug( 'job_number: ' || p_workorder_rec.job_number );
307: AHL_DEBUG_PUB.debug( 'job_description: ' || p_workorder_rec.job_description );
308: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_workorder_rec.inventory_item_id ) );
309: AHL_DEBUG_PUB.debug( 'item_instance_id: ' || TO_CHAR( p_workorder_rec.item_instance_id ) );
310: AHL_DEBUG_PUB.debug( 'class_code: ' || p_workorder_rec.class_code );
311: AHL_DEBUG_PUB.debug( 'status_code: ' || p_workorder_rec.status_code );
312: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_workorder_rec.department_id ) );
305: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_workorder_rec.wip_entity_id ) );
306: AHL_DEBUG_PUB.debug( 'job_number: ' || p_workorder_rec.job_number );
307: AHL_DEBUG_PUB.debug( 'job_description: ' || p_workorder_rec.job_description );
308: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_workorder_rec.inventory_item_id ) );
309: AHL_DEBUG_PUB.debug( 'item_instance_id: ' || TO_CHAR( p_workorder_rec.item_instance_id ) );
310: AHL_DEBUG_PUB.debug( 'class_code: ' || p_workorder_rec.class_code );
311: AHL_DEBUG_PUB.debug( 'status_code: ' || p_workorder_rec.status_code );
312: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_workorder_rec.department_id ) );
313: AHL_DEBUG_PUB.debug( 'job_priority: ' || TO_CHAR( p_workorder_rec.job_priority ) );
306: AHL_DEBUG_PUB.debug( 'job_number: ' || p_workorder_rec.job_number );
307: AHL_DEBUG_PUB.debug( 'job_description: ' || p_workorder_rec.job_description );
308: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_workorder_rec.inventory_item_id ) );
309: AHL_DEBUG_PUB.debug( 'item_instance_id: ' || TO_CHAR( p_workorder_rec.item_instance_id ) );
310: AHL_DEBUG_PUB.debug( 'class_code: ' || p_workorder_rec.class_code );
311: AHL_DEBUG_PUB.debug( 'status_code: ' || p_workorder_rec.status_code );
312: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_workorder_rec.department_id ) );
313: AHL_DEBUG_PUB.debug( 'job_priority: ' || TO_CHAR( p_workorder_rec.job_priority ) );
314: AHL_DEBUG_PUB.debug( 'firm_planned_flag: ' || TO_CHAR( p_workorder_rec.firm_planned_flag ) );
307: AHL_DEBUG_PUB.debug( 'job_description: ' || p_workorder_rec.job_description );
308: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_workorder_rec.inventory_item_id ) );
309: AHL_DEBUG_PUB.debug( 'item_instance_id: ' || TO_CHAR( p_workorder_rec.item_instance_id ) );
310: AHL_DEBUG_PUB.debug( 'class_code: ' || p_workorder_rec.class_code );
311: AHL_DEBUG_PUB.debug( 'status_code: ' || p_workorder_rec.status_code );
312: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_workorder_rec.department_id ) );
313: AHL_DEBUG_PUB.debug( 'job_priority: ' || TO_CHAR( p_workorder_rec.job_priority ) );
314: AHL_DEBUG_PUB.debug( 'firm_planned_flag: ' || TO_CHAR( p_workorder_rec.firm_planned_flag ) );
315: AHL_DEBUG_PUB.debug( 'project_id: ' || TO_CHAR( p_workorder_rec.project_id ) );
308: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_workorder_rec.inventory_item_id ) );
309: AHL_DEBUG_PUB.debug( 'item_instance_id: ' || TO_CHAR( p_workorder_rec.item_instance_id ) );
310: AHL_DEBUG_PUB.debug( 'class_code: ' || p_workorder_rec.class_code );
311: AHL_DEBUG_PUB.debug( 'status_code: ' || p_workorder_rec.status_code );
312: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_workorder_rec.department_id ) );
313: AHL_DEBUG_PUB.debug( 'job_priority: ' || TO_CHAR( p_workorder_rec.job_priority ) );
314: AHL_DEBUG_PUB.debug( 'firm_planned_flag: ' || TO_CHAR( p_workorder_rec.firm_planned_flag ) );
315: AHL_DEBUG_PUB.debug( 'project_id: ' || TO_CHAR( p_workorder_rec.project_id ) );
316: AHL_DEBUG_PUB.debug( 'project_task_id: ' || TO_CHAR( p_workorder_rec.project_task_id ) );
309: AHL_DEBUG_PUB.debug( 'item_instance_id: ' || TO_CHAR( p_workorder_rec.item_instance_id ) );
310: AHL_DEBUG_PUB.debug( 'class_code: ' || p_workorder_rec.class_code );
311: AHL_DEBUG_PUB.debug( 'status_code: ' || p_workorder_rec.status_code );
312: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_workorder_rec.department_id ) );
313: AHL_DEBUG_PUB.debug( 'job_priority: ' || TO_CHAR( p_workorder_rec.job_priority ) );
314: AHL_DEBUG_PUB.debug( 'firm_planned_flag: ' || TO_CHAR( p_workorder_rec.firm_planned_flag ) );
315: AHL_DEBUG_PUB.debug( 'project_id: ' || TO_CHAR( p_workorder_rec.project_id ) );
316: AHL_DEBUG_PUB.debug( 'project_task_id: ' || TO_CHAR( p_workorder_rec.project_task_id ) );
317: AHL_DEBUG_PUB.debug( 'wip_supply_type: ' || TO_CHAR( p_workorder_rec.wip_supply_type ) );
310: AHL_DEBUG_PUB.debug( 'class_code: ' || p_workorder_rec.class_code );
311: AHL_DEBUG_PUB.debug( 'status_code: ' || p_workorder_rec.status_code );
312: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_workorder_rec.department_id ) );
313: AHL_DEBUG_PUB.debug( 'job_priority: ' || TO_CHAR( p_workorder_rec.job_priority ) );
314: AHL_DEBUG_PUB.debug( 'firm_planned_flag: ' || TO_CHAR( p_workorder_rec.firm_planned_flag ) );
315: AHL_DEBUG_PUB.debug( 'project_id: ' || TO_CHAR( p_workorder_rec.project_id ) );
316: AHL_DEBUG_PUB.debug( 'project_task_id: ' || TO_CHAR( p_workorder_rec.project_task_id ) );
317: AHL_DEBUG_PUB.debug( 'wip_supply_type: ' || TO_CHAR( p_workorder_rec.wip_supply_type ) );
318: AHL_DEBUG_PUB.debug( 'scheduled_start_date: ' || TO_CHAR( p_workorder_rec.scheduled_start_date, 'DD-MON-YYYY hh24:mi') );
311: AHL_DEBUG_PUB.debug( 'status_code: ' || p_workorder_rec.status_code );
312: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_workorder_rec.department_id ) );
313: AHL_DEBUG_PUB.debug( 'job_priority: ' || TO_CHAR( p_workorder_rec.job_priority ) );
314: AHL_DEBUG_PUB.debug( 'firm_planned_flag: ' || TO_CHAR( p_workorder_rec.firm_planned_flag ) );
315: AHL_DEBUG_PUB.debug( 'project_id: ' || TO_CHAR( p_workorder_rec.project_id ) );
316: AHL_DEBUG_PUB.debug( 'project_task_id: ' || TO_CHAR( p_workorder_rec.project_task_id ) );
317: AHL_DEBUG_PUB.debug( 'wip_supply_type: ' || TO_CHAR( p_workorder_rec.wip_supply_type ) );
318: AHL_DEBUG_PUB.debug( 'scheduled_start_date: ' || TO_CHAR( p_workorder_rec.scheduled_start_date, 'DD-MON-YYYY hh24:mi') );
319: AHL_DEBUG_PUB.debug( 'scheduled_end_date: ' || TO_CHAR( p_workorder_rec.scheduled_end_date, 'DD-MON-YYYY hh24:mi') );
312: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_workorder_rec.department_id ) );
313: AHL_DEBUG_PUB.debug( 'job_priority: ' || TO_CHAR( p_workorder_rec.job_priority ) );
314: AHL_DEBUG_PUB.debug( 'firm_planned_flag: ' || TO_CHAR( p_workorder_rec.firm_planned_flag ) );
315: AHL_DEBUG_PUB.debug( 'project_id: ' || TO_CHAR( p_workorder_rec.project_id ) );
316: AHL_DEBUG_PUB.debug( 'project_task_id: ' || TO_CHAR( p_workorder_rec.project_task_id ) );
317: AHL_DEBUG_PUB.debug( 'wip_supply_type: ' || TO_CHAR( p_workorder_rec.wip_supply_type ) );
318: AHL_DEBUG_PUB.debug( 'scheduled_start_date: ' || TO_CHAR( p_workorder_rec.scheduled_start_date, 'DD-MON-YYYY hh24:mi') );
319: AHL_DEBUG_PUB.debug( 'scheduled_end_date: ' || TO_CHAR( p_workorder_rec.scheduled_end_date, 'DD-MON-YYYY hh24:mi') );
320: END IF;
313: AHL_DEBUG_PUB.debug( 'job_priority: ' || TO_CHAR( p_workorder_rec.job_priority ) );
314: AHL_DEBUG_PUB.debug( 'firm_planned_flag: ' || TO_CHAR( p_workorder_rec.firm_planned_flag ) );
315: AHL_DEBUG_PUB.debug( 'project_id: ' || TO_CHAR( p_workorder_rec.project_id ) );
316: AHL_DEBUG_PUB.debug( 'project_task_id: ' || TO_CHAR( p_workorder_rec.project_task_id ) );
317: AHL_DEBUG_PUB.debug( 'wip_supply_type: ' || TO_CHAR( p_workorder_rec.wip_supply_type ) );
318: AHL_DEBUG_PUB.debug( 'scheduled_start_date: ' || TO_CHAR( p_workorder_rec.scheduled_start_date, 'DD-MON-YYYY hh24:mi') );
319: AHL_DEBUG_PUB.debug( 'scheduled_end_date: ' || TO_CHAR( p_workorder_rec.scheduled_end_date, 'DD-MON-YYYY hh24:mi') );
320: END IF;
321:
314: AHL_DEBUG_PUB.debug( 'firm_planned_flag: ' || TO_CHAR( p_workorder_rec.firm_planned_flag ) );
315: AHL_DEBUG_PUB.debug( 'project_id: ' || TO_CHAR( p_workorder_rec.project_id ) );
316: AHL_DEBUG_PUB.debug( 'project_task_id: ' || TO_CHAR( p_workorder_rec.project_task_id ) );
317: AHL_DEBUG_PUB.debug( 'wip_supply_type: ' || TO_CHAR( p_workorder_rec.wip_supply_type ) );
318: AHL_DEBUG_PUB.debug( 'scheduled_start_date: ' || TO_CHAR( p_workorder_rec.scheduled_start_date, 'DD-MON-YYYY hh24:mi') );
319: AHL_DEBUG_PUB.debug( 'scheduled_end_date: ' || TO_CHAR( p_workorder_rec.scheduled_end_date, 'DD-MON-YYYY hh24:mi') );
320: END IF;
321:
322: get_workorder_details (p_visit_task_id => p_workorder_rec.visit_task_id,
315: AHL_DEBUG_PUB.debug( 'project_id: ' || TO_CHAR( p_workorder_rec.project_id ) );
316: AHL_DEBUG_PUB.debug( 'project_task_id: ' || TO_CHAR( p_workorder_rec.project_task_id ) );
317: AHL_DEBUG_PUB.debug( 'wip_supply_type: ' || TO_CHAR( p_workorder_rec.wip_supply_type ) );
318: AHL_DEBUG_PUB.debug( 'scheduled_start_date: ' || TO_CHAR( p_workorder_rec.scheduled_start_date, 'DD-MON-YYYY hh24:mi') );
319: AHL_DEBUG_PUB.debug( 'scheduled_end_date: ' || TO_CHAR( p_workorder_rec.scheduled_end_date, 'DD-MON-YYYY hh24:mi') );
320: END IF;
321:
322: get_workorder_details (p_visit_task_id => p_workorder_rec.visit_task_id,
323: p_master_workorder_flag => p_workorder_rec.master_workorder_flag,
471:
472:
473: IF ( G_DEBUG = 'Y' ) THEN
474:
475: AHL_DEBUG_PUB.debug( 'Requested Start Date: ' || TO_CHAR( x_eam_wo_rec.requested_start_date, 'DD-MON-YYYY hh24:mi') );
476: AHL_DEBUG_PUB.debug( 'Due Date: ' || TO_CHAR( x_eam_wo_rec.due_date, 'DD-MON-YYYY hh24:mi') );
477: END IF;
478:
479: x_eam_wo_rec.return_status := NULL;
472:
473: IF ( G_DEBUG = 'Y' ) THEN
474:
475: AHL_DEBUG_PUB.debug( 'Requested Start Date: ' || TO_CHAR( x_eam_wo_rec.requested_start_date, 'DD-MON-YYYY hh24:mi') );
476: AHL_DEBUG_PUB.debug( 'Due Date: ' || TO_CHAR( x_eam_wo_rec.due_date, 'DD-MON-YYYY hh24:mi') );
477: END IF;
478:
479: x_eam_wo_rec.return_status := NULL;
480:
491: BEGIN
492:
493: -- Log Input Values
494: IF ( G_DEBUG = 'Y' ) THEN
495: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_workorder_rel_rec.dml_operation );
496: AHL_DEBUG_PUB.debug( 'batch_id: ' || TO_CHAR( p_workorder_rel_rec.batch_id ) );
497: AHL_DEBUG_PUB.debug( 'wo_relationship_id: ' || TO_CHAR( p_workorder_rel_rec.wo_relationship_id ) );
498: AHL_DEBUG_PUB.debug( 'parent_header_id: ' || TO_CHAR( p_workorder_rel_rec.parent_header_id ) );
499: AHL_DEBUG_PUB.debug( 'parent_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.parent_wip_entity_id ) );
492:
493: -- Log Input Values
494: IF ( G_DEBUG = 'Y' ) THEN
495: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_workorder_rel_rec.dml_operation );
496: AHL_DEBUG_PUB.debug( 'batch_id: ' || TO_CHAR( p_workorder_rel_rec.batch_id ) );
497: AHL_DEBUG_PUB.debug( 'wo_relationship_id: ' || TO_CHAR( p_workorder_rel_rec.wo_relationship_id ) );
498: AHL_DEBUG_PUB.debug( 'parent_header_id: ' || TO_CHAR( p_workorder_rel_rec.parent_header_id ) );
499: AHL_DEBUG_PUB.debug( 'parent_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.parent_wip_entity_id ) );
500: AHL_DEBUG_PUB.debug( 'child_header_id: ' || TO_CHAR( p_workorder_rel_rec.child_header_id ) );
493: -- Log Input Values
494: IF ( G_DEBUG = 'Y' ) THEN
495: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_workorder_rel_rec.dml_operation );
496: AHL_DEBUG_PUB.debug( 'batch_id: ' || TO_CHAR( p_workorder_rel_rec.batch_id ) );
497: AHL_DEBUG_PUB.debug( 'wo_relationship_id: ' || TO_CHAR( p_workorder_rel_rec.wo_relationship_id ) );
498: AHL_DEBUG_PUB.debug( 'parent_header_id: ' || TO_CHAR( p_workorder_rel_rec.parent_header_id ) );
499: AHL_DEBUG_PUB.debug( 'parent_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.parent_wip_entity_id ) );
500: AHL_DEBUG_PUB.debug( 'child_header_id: ' || TO_CHAR( p_workorder_rel_rec.child_header_id ) );
501: AHL_DEBUG_PUB.debug( 'child_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.child_wip_entity_id ) );
494: IF ( G_DEBUG = 'Y' ) THEN
495: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_workorder_rel_rec.dml_operation );
496: AHL_DEBUG_PUB.debug( 'batch_id: ' || TO_CHAR( p_workorder_rel_rec.batch_id ) );
497: AHL_DEBUG_PUB.debug( 'wo_relationship_id: ' || TO_CHAR( p_workorder_rel_rec.wo_relationship_id ) );
498: AHL_DEBUG_PUB.debug( 'parent_header_id: ' || TO_CHAR( p_workorder_rel_rec.parent_header_id ) );
499: AHL_DEBUG_PUB.debug( 'parent_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.parent_wip_entity_id ) );
500: AHL_DEBUG_PUB.debug( 'child_header_id: ' || TO_CHAR( p_workorder_rel_rec.child_header_id ) );
501: AHL_DEBUG_PUB.debug( 'child_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.child_wip_entity_id ) );
502: AHL_DEBUG_PUB.debug( 'relationship_type: ' || TO_CHAR( p_workorder_rel_rec.relationship_type ) );
495: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_workorder_rel_rec.dml_operation );
496: AHL_DEBUG_PUB.debug( 'batch_id: ' || TO_CHAR( p_workorder_rel_rec.batch_id ) );
497: AHL_DEBUG_PUB.debug( 'wo_relationship_id: ' || TO_CHAR( p_workorder_rel_rec.wo_relationship_id ) );
498: AHL_DEBUG_PUB.debug( 'parent_header_id: ' || TO_CHAR( p_workorder_rel_rec.parent_header_id ) );
499: AHL_DEBUG_PUB.debug( 'parent_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.parent_wip_entity_id ) );
500: AHL_DEBUG_PUB.debug( 'child_header_id: ' || TO_CHAR( p_workorder_rel_rec.child_header_id ) );
501: AHL_DEBUG_PUB.debug( 'child_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.child_wip_entity_id ) );
502: AHL_DEBUG_PUB.debug( 'relationship_type: ' || TO_CHAR( p_workorder_rel_rec.relationship_type ) );
503: END IF;
496: AHL_DEBUG_PUB.debug( 'batch_id: ' || TO_CHAR( p_workorder_rel_rec.batch_id ) );
497: AHL_DEBUG_PUB.debug( 'wo_relationship_id: ' || TO_CHAR( p_workorder_rel_rec.wo_relationship_id ) );
498: AHL_DEBUG_PUB.debug( 'parent_header_id: ' || TO_CHAR( p_workorder_rel_rec.parent_header_id ) );
499: AHL_DEBUG_PUB.debug( 'parent_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.parent_wip_entity_id ) );
500: AHL_DEBUG_PUB.debug( 'child_header_id: ' || TO_CHAR( p_workorder_rel_rec.child_header_id ) );
501: AHL_DEBUG_PUB.debug( 'child_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.child_wip_entity_id ) );
502: AHL_DEBUG_PUB.debug( 'relationship_type: ' || TO_CHAR( p_workorder_rel_rec.relationship_type ) );
503: END IF;
504:
497: AHL_DEBUG_PUB.debug( 'wo_relationship_id: ' || TO_CHAR( p_workorder_rel_rec.wo_relationship_id ) );
498: AHL_DEBUG_PUB.debug( 'parent_header_id: ' || TO_CHAR( p_workorder_rel_rec.parent_header_id ) );
499: AHL_DEBUG_PUB.debug( 'parent_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.parent_wip_entity_id ) );
500: AHL_DEBUG_PUB.debug( 'child_header_id: ' || TO_CHAR( p_workorder_rel_rec.child_header_id ) );
501: AHL_DEBUG_PUB.debug( 'child_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.child_wip_entity_id ) );
502: AHL_DEBUG_PUB.debug( 'relationship_type: ' || TO_CHAR( p_workorder_rel_rec.relationship_type ) );
503: END IF;
504:
505: -- Populate EAM Record attributes from input record
498: AHL_DEBUG_PUB.debug( 'parent_header_id: ' || TO_CHAR( p_workorder_rel_rec.parent_header_id ) );
499: AHL_DEBUG_PUB.debug( 'parent_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.parent_wip_entity_id ) );
500: AHL_DEBUG_PUB.debug( 'child_header_id: ' || TO_CHAR( p_workorder_rel_rec.child_header_id ) );
501: AHL_DEBUG_PUB.debug( 'child_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.child_wip_entity_id ) );
502: AHL_DEBUG_PUB.debug( 'relationship_type: ' || TO_CHAR( p_workorder_rel_rec.relationship_type ) );
503: END IF;
504:
505: -- Populate EAM Record attributes from input record
506: x_eam_wo_relations_rec.batch_id := p_workorder_rel_rec.batch_id;
535: BEGIN
536:
537: -- Log Input Values
538: IF ( G_DEBUG = 'Y' ) THEN
539: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_operation_rec.dml_operation );
540: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_operation_rec.workorder_id ) );
541: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_operation_rec.wip_entity_id ) );
542: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_operation_rec.organization_id ) );
543: AHL_DEBUG_PUB.debug( 'operation_sequence_num: ' || TO_CHAR( p_operation_rec.operation_sequence_num) );
536:
537: -- Log Input Values
538: IF ( G_DEBUG = 'Y' ) THEN
539: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_operation_rec.dml_operation );
540: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_operation_rec.workorder_id ) );
541: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_operation_rec.wip_entity_id ) );
542: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_operation_rec.organization_id ) );
543: AHL_DEBUG_PUB.debug( 'operation_sequence_num: ' || TO_CHAR( p_operation_rec.operation_sequence_num) );
544: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_operation_rec.department_id) );
537: -- Log Input Values
538: IF ( G_DEBUG = 'Y' ) THEN
539: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_operation_rec.dml_operation );
540: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_operation_rec.workorder_id ) );
541: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_operation_rec.wip_entity_id ) );
542: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_operation_rec.organization_id ) );
543: AHL_DEBUG_PUB.debug( 'operation_sequence_num: ' || TO_CHAR( p_operation_rec.operation_sequence_num) );
544: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_operation_rec.department_id) );
545: AHL_DEBUG_PUB.debug( 'operation_description: ' || p_operation_rec.operation_description );
538: IF ( G_DEBUG = 'Y' ) THEN
539: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_operation_rec.dml_operation );
540: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_operation_rec.workorder_id ) );
541: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_operation_rec.wip_entity_id ) );
542: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_operation_rec.organization_id ) );
543: AHL_DEBUG_PUB.debug( 'operation_sequence_num: ' || TO_CHAR( p_operation_rec.operation_sequence_num) );
544: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_operation_rec.department_id) );
545: AHL_DEBUG_PUB.debug( 'operation_description: ' || p_operation_rec.operation_description );
546: AHL_DEBUG_PUB.debug( 'minimum_transfer_quantity: ' || TO_CHAR( p_operation_rec.minimum_transfer_quantity) );
539: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_operation_rec.dml_operation );
540: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_operation_rec.workorder_id ) );
541: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_operation_rec.wip_entity_id ) );
542: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_operation_rec.organization_id ) );
543: AHL_DEBUG_PUB.debug( 'operation_sequence_num: ' || TO_CHAR( p_operation_rec.operation_sequence_num) );
544: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_operation_rec.department_id) );
545: AHL_DEBUG_PUB.debug( 'operation_description: ' || p_operation_rec.operation_description );
546: AHL_DEBUG_PUB.debug( 'minimum_transfer_quantity: ' || TO_CHAR( p_operation_rec.minimum_transfer_quantity) );
547: AHL_DEBUG_PUB.debug( 'count_point_type: ' || TO_CHAR( p_operation_rec.count_point_type) );
540: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_operation_rec.workorder_id ) );
541: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_operation_rec.wip_entity_id ) );
542: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_operation_rec.organization_id ) );
543: AHL_DEBUG_PUB.debug( 'operation_sequence_num: ' || TO_CHAR( p_operation_rec.operation_sequence_num) );
544: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_operation_rec.department_id) );
545: AHL_DEBUG_PUB.debug( 'operation_description: ' || p_operation_rec.operation_description );
546: AHL_DEBUG_PUB.debug( 'minimum_transfer_quantity: ' || TO_CHAR( p_operation_rec.minimum_transfer_quantity) );
547: AHL_DEBUG_PUB.debug( 'count_point_type: ' || TO_CHAR( p_operation_rec.count_point_type) );
548: AHL_DEBUG_PUB.debug( 'scheduled_start_date: ' || TO_CHAR( p_operation_rec.scheduled_start_date, 'DD-MON-YYYY hh24:mi') );
541: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_operation_rec.wip_entity_id ) );
542: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_operation_rec.organization_id ) );
543: AHL_DEBUG_PUB.debug( 'operation_sequence_num: ' || TO_CHAR( p_operation_rec.operation_sequence_num) );
544: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_operation_rec.department_id) );
545: AHL_DEBUG_PUB.debug( 'operation_description: ' || p_operation_rec.operation_description );
546: AHL_DEBUG_PUB.debug( 'minimum_transfer_quantity: ' || TO_CHAR( p_operation_rec.minimum_transfer_quantity) );
547: AHL_DEBUG_PUB.debug( 'count_point_type: ' || TO_CHAR( p_operation_rec.count_point_type) );
548: AHL_DEBUG_PUB.debug( 'scheduled_start_date: ' || TO_CHAR( p_operation_rec.scheduled_start_date, 'DD-MON-YYYY hh24:mi') );
549: AHL_DEBUG_PUB.debug( 'scheduled_end_date: ' || TO_CHAR( p_operation_rec.scheduled_end_date, 'DD-MON-YYYY hh24:mi') );
542: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_operation_rec.organization_id ) );
543: AHL_DEBUG_PUB.debug( 'operation_sequence_num: ' || TO_CHAR( p_operation_rec.operation_sequence_num) );
544: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_operation_rec.department_id) );
545: AHL_DEBUG_PUB.debug( 'operation_description: ' || p_operation_rec.operation_description );
546: AHL_DEBUG_PUB.debug( 'minimum_transfer_quantity: ' || TO_CHAR( p_operation_rec.minimum_transfer_quantity) );
547: AHL_DEBUG_PUB.debug( 'count_point_type: ' || TO_CHAR( p_operation_rec.count_point_type) );
548: AHL_DEBUG_PUB.debug( 'scheduled_start_date: ' || TO_CHAR( p_operation_rec.scheduled_start_date, 'DD-MON-YYYY hh24:mi') );
549: AHL_DEBUG_PUB.debug( 'scheduled_end_date: ' || TO_CHAR( p_operation_rec.scheduled_end_date, 'DD-MON-YYYY hh24:mi') );
550: END IF;
543: AHL_DEBUG_PUB.debug( 'operation_sequence_num: ' || TO_CHAR( p_operation_rec.operation_sequence_num) );
544: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_operation_rec.department_id) );
545: AHL_DEBUG_PUB.debug( 'operation_description: ' || p_operation_rec.operation_description );
546: AHL_DEBUG_PUB.debug( 'minimum_transfer_quantity: ' || TO_CHAR( p_operation_rec.minimum_transfer_quantity) );
547: AHL_DEBUG_PUB.debug( 'count_point_type: ' || TO_CHAR( p_operation_rec.count_point_type) );
548: AHL_DEBUG_PUB.debug( 'scheduled_start_date: ' || TO_CHAR( p_operation_rec.scheduled_start_date, 'DD-MON-YYYY hh24:mi') );
549: AHL_DEBUG_PUB.debug( 'scheduled_end_date: ' || TO_CHAR( p_operation_rec.scheduled_end_date, 'DD-MON-YYYY hh24:mi') );
550: END IF;
551:
544: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_operation_rec.department_id) );
545: AHL_DEBUG_PUB.debug( 'operation_description: ' || p_operation_rec.operation_description );
546: AHL_DEBUG_PUB.debug( 'minimum_transfer_quantity: ' || TO_CHAR( p_operation_rec.minimum_transfer_quantity) );
547: AHL_DEBUG_PUB.debug( 'count_point_type: ' || TO_CHAR( p_operation_rec.count_point_type) );
548: AHL_DEBUG_PUB.debug( 'scheduled_start_date: ' || TO_CHAR( p_operation_rec.scheduled_start_date, 'DD-MON-YYYY hh24:mi') );
549: AHL_DEBUG_PUB.debug( 'scheduled_end_date: ' || TO_CHAR( p_operation_rec.scheduled_end_date, 'DD-MON-YYYY hh24:mi') );
550: END IF;
551:
552: -- Populate EAM Record attributes from input table
545: AHL_DEBUG_PUB.debug( 'operation_description: ' || p_operation_rec.operation_description );
546: AHL_DEBUG_PUB.debug( 'minimum_transfer_quantity: ' || TO_CHAR( p_operation_rec.minimum_transfer_quantity) );
547: AHL_DEBUG_PUB.debug( 'count_point_type: ' || TO_CHAR( p_operation_rec.count_point_type) );
548: AHL_DEBUG_PUB.debug( 'scheduled_start_date: ' || TO_CHAR( p_operation_rec.scheduled_start_date, 'DD-MON-YYYY hh24:mi') );
549: AHL_DEBUG_PUB.debug( 'scheduled_end_date: ' || TO_CHAR( p_operation_rec.scheduled_end_date, 'DD-MON-YYYY hh24:mi') );
550: END IF;
551:
552: -- Populate EAM Record attributes from input table
553: x_eam_op_rec.wip_entity_id := p_operation_rec.wip_entity_id;
607: BEGIN
608:
609: -- Log Input Values
610: IF ( G_DEBUG = 'Y' ) THEN
611: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_material_req_rec.operation_flag );
612: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_material_req_rec.workorder_id ) );
613: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_material_req_rec.wip_entity_id ) );
614: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_material_req_rec.organization_id ) );
615: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_material_req_rec.operation_sequence) );
608:
609: -- Log Input Values
610: IF ( G_DEBUG = 'Y' ) THEN
611: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_material_req_rec.operation_flag );
612: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_material_req_rec.workorder_id ) );
613: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_material_req_rec.wip_entity_id ) );
614: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_material_req_rec.organization_id ) );
615: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_material_req_rec.operation_sequence) );
616: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_material_req_rec.inventory_item_id) );
609: -- Log Input Values
610: IF ( G_DEBUG = 'Y' ) THEN
611: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_material_req_rec.operation_flag );
612: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_material_req_rec.workorder_id ) );
613: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_material_req_rec.wip_entity_id ) );
614: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_material_req_rec.organization_id ) );
615: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_material_req_rec.operation_sequence) );
616: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_material_req_rec.inventory_item_id) );
617: AHL_DEBUG_PUB.debug( 'requested_quantity: ' || TO_CHAR( p_material_req_rec.requested_quantity) );
610: IF ( G_DEBUG = 'Y' ) THEN
611: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_material_req_rec.operation_flag );
612: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_material_req_rec.workorder_id ) );
613: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_material_req_rec.wip_entity_id ) );
614: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_material_req_rec.organization_id ) );
615: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_material_req_rec.operation_sequence) );
616: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_material_req_rec.inventory_item_id) );
617: AHL_DEBUG_PUB.debug( 'requested_quantity: ' || TO_CHAR( p_material_req_rec.requested_quantity) );
618: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_material_req_rec.department_id) );
611: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_material_req_rec.operation_flag );
612: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_material_req_rec.workorder_id ) );
613: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_material_req_rec.wip_entity_id ) );
614: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_material_req_rec.organization_id ) );
615: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_material_req_rec.operation_sequence) );
616: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_material_req_rec.inventory_item_id) );
617: AHL_DEBUG_PUB.debug( 'requested_quantity: ' || TO_CHAR( p_material_req_rec.requested_quantity) );
618: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_material_req_rec.department_id) );
619: AHL_DEBUG_PUB.debug( 'requested_date: ' || TO_CHAR( p_material_req_rec.requested_date, 'DD-MON-YYYY hh24:mi') );
612: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_material_req_rec.workorder_id ) );
613: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_material_req_rec.wip_entity_id ) );
614: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_material_req_rec.organization_id ) );
615: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_material_req_rec.operation_sequence) );
616: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_material_req_rec.inventory_item_id) );
617: AHL_DEBUG_PUB.debug( 'requested_quantity: ' || TO_CHAR( p_material_req_rec.requested_quantity) );
618: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_material_req_rec.department_id) );
619: AHL_DEBUG_PUB.debug( 'requested_date: ' || TO_CHAR( p_material_req_rec.requested_date, 'DD-MON-YYYY hh24:mi') );
620: END IF;
613: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_material_req_rec.wip_entity_id ) );
614: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_material_req_rec.organization_id ) );
615: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_material_req_rec.operation_sequence) );
616: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_material_req_rec.inventory_item_id) );
617: AHL_DEBUG_PUB.debug( 'requested_quantity: ' || TO_CHAR( p_material_req_rec.requested_quantity) );
618: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_material_req_rec.department_id) );
619: AHL_DEBUG_PUB.debug( 'requested_date: ' || TO_CHAR( p_material_req_rec.requested_date, 'DD-MON-YYYY hh24:mi') );
620: END IF;
621:
614: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_material_req_rec.organization_id ) );
615: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_material_req_rec.operation_sequence) );
616: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_material_req_rec.inventory_item_id) );
617: AHL_DEBUG_PUB.debug( 'requested_quantity: ' || TO_CHAR( p_material_req_rec.requested_quantity) );
618: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_material_req_rec.department_id) );
619: AHL_DEBUG_PUB.debug( 'requested_date: ' || TO_CHAR( p_material_req_rec.requested_date, 'DD-MON-YYYY hh24:mi') );
620: END IF;
621:
622: -- Populate EAM Record attributes from input table
615: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_material_req_rec.operation_sequence) );
616: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_material_req_rec.inventory_item_id) );
617: AHL_DEBUG_PUB.debug( 'requested_quantity: ' || TO_CHAR( p_material_req_rec.requested_quantity) );
618: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_material_req_rec.department_id) );
619: AHL_DEBUG_PUB.debug( 'requested_date: ' || TO_CHAR( p_material_req_rec.requested_date, 'DD-MON-YYYY hh24:mi') );
620: END IF;
621:
622: -- Populate EAM Record attributes from input table
623: x_eam_mat_req_rec.wip_entity_id := p_material_req_rec.wip_entity_id;
670:
671: BEGIN
672: -- Log Input Values
673: IF ( G_DEBUG = 'Y' ) THEN
674: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_resource_req_rec.operation_flag );
675: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_req_rec.workorder_id ) );
676: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_req_rec.wip_entity_id ) );
677: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_req_rec.organization_id ) );
678: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_resource_req_rec.operation_seq_number) );
671: BEGIN
672: -- Log Input Values
673: IF ( G_DEBUG = 'Y' ) THEN
674: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_resource_req_rec.operation_flag );
675: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_req_rec.workorder_id ) );
676: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_req_rec.wip_entity_id ) );
677: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_req_rec.organization_id ) );
678: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_resource_req_rec.operation_seq_number) );
679: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_req_rec.resource_seq_number) );
672: -- Log Input Values
673: IF ( G_DEBUG = 'Y' ) THEN
674: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_resource_req_rec.operation_flag );
675: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_req_rec.workorder_id ) );
676: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_req_rec.wip_entity_id ) );
677: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_req_rec.organization_id ) );
678: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_resource_req_rec.operation_seq_number) );
679: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_req_rec.resource_seq_number) );
680: AHL_DEBUG_PUB.debug( 'resource_id: ' || TO_CHAR( p_resource_req_rec.resource_id) );
673: IF ( G_DEBUG = 'Y' ) THEN
674: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_resource_req_rec.operation_flag );
675: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_req_rec.workorder_id ) );
676: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_req_rec.wip_entity_id ) );
677: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_req_rec.organization_id ) );
678: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_resource_req_rec.operation_seq_number) );
679: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_req_rec.resource_seq_number) );
680: AHL_DEBUG_PUB.debug( 'resource_id: ' || TO_CHAR( p_resource_req_rec.resource_id) );
681: AHL_DEBUG_PUB.debug( 'uom_code: ' || p_resource_req_rec.uom_code );
674: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_resource_req_rec.operation_flag );
675: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_req_rec.workorder_id ) );
676: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_req_rec.wip_entity_id ) );
677: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_req_rec.organization_id ) );
678: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_resource_req_rec.operation_seq_number) );
679: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_req_rec.resource_seq_number) );
680: AHL_DEBUG_PUB.debug( 'resource_id: ' || TO_CHAR( p_resource_req_rec.resource_id) );
681: AHL_DEBUG_PUB.debug( 'uom_code: ' || p_resource_req_rec.uom_code );
682: AHL_DEBUG_PUB.debug( 'cost_basis_code: ' || TO_CHAR( p_resource_req_rec.cost_basis_code ) );
675: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_req_rec.workorder_id ) );
676: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_req_rec.wip_entity_id ) );
677: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_req_rec.organization_id ) );
678: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_resource_req_rec.operation_seq_number) );
679: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_req_rec.resource_seq_number) );
680: AHL_DEBUG_PUB.debug( 'resource_id: ' || TO_CHAR( p_resource_req_rec.resource_id) );
681: AHL_DEBUG_PUB.debug( 'uom_code: ' || p_resource_req_rec.uom_code );
682: AHL_DEBUG_PUB.debug( 'cost_basis_code: ' || TO_CHAR( p_resource_req_rec.cost_basis_code ) );
683: AHL_DEBUG_PUB.debug( 'charge_type_code: ' || TO_CHAR( p_resource_req_rec.charge_type_code) );
676: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_req_rec.wip_entity_id ) );
677: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_req_rec.organization_id ) );
678: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_resource_req_rec.operation_seq_number) );
679: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_req_rec.resource_seq_number) );
680: AHL_DEBUG_PUB.debug( 'resource_id: ' || TO_CHAR( p_resource_req_rec.resource_id) );
681: AHL_DEBUG_PUB.debug( 'uom_code: ' || p_resource_req_rec.uom_code );
682: AHL_DEBUG_PUB.debug( 'cost_basis_code: ' || TO_CHAR( p_resource_req_rec.cost_basis_code ) );
683: AHL_DEBUG_PUB.debug( 'charge_type_code: ' || TO_CHAR( p_resource_req_rec.charge_type_code) );
684: AHL_DEBUG_PUB.debug( 'std_rate_flag_code: ' || TO_CHAR( p_resource_req_rec.std_rate_flag_code) );
677: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_req_rec.organization_id ) );
678: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_resource_req_rec.operation_seq_number) );
679: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_req_rec.resource_seq_number) );
680: AHL_DEBUG_PUB.debug( 'resource_id: ' || TO_CHAR( p_resource_req_rec.resource_id) );
681: AHL_DEBUG_PUB.debug( 'uom_code: ' || p_resource_req_rec.uom_code );
682: AHL_DEBUG_PUB.debug( 'cost_basis_code: ' || TO_CHAR( p_resource_req_rec.cost_basis_code ) );
683: AHL_DEBUG_PUB.debug( 'charge_type_code: ' || TO_CHAR( p_resource_req_rec.charge_type_code) );
684: AHL_DEBUG_PUB.debug( 'std_rate_flag_code: ' || TO_CHAR( p_resource_req_rec.std_rate_flag_code) );
685: AHL_DEBUG_PUB.debug( 'scheduled_type_code: ' || TO_CHAR( p_resource_req_rec.scheduled_type_code) );
678: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_resource_req_rec.operation_seq_number) );
679: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_req_rec.resource_seq_number) );
680: AHL_DEBUG_PUB.debug( 'resource_id: ' || TO_CHAR( p_resource_req_rec.resource_id) );
681: AHL_DEBUG_PUB.debug( 'uom_code: ' || p_resource_req_rec.uom_code );
682: AHL_DEBUG_PUB.debug( 'cost_basis_code: ' || TO_CHAR( p_resource_req_rec.cost_basis_code ) );
683: AHL_DEBUG_PUB.debug( 'charge_type_code: ' || TO_CHAR( p_resource_req_rec.charge_type_code) );
684: AHL_DEBUG_PUB.debug( 'std_rate_flag_code: ' || TO_CHAR( p_resource_req_rec.std_rate_flag_code) );
685: AHL_DEBUG_PUB.debug( 'scheduled_type_code: ' || TO_CHAR( p_resource_req_rec.scheduled_type_code) );
686: AHL_DEBUG_PUB.debug( 'applied_num: ' || TO_CHAR( p_resource_req_rec.applied_num) );
679: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_req_rec.resource_seq_number) );
680: AHL_DEBUG_PUB.debug( 'resource_id: ' || TO_CHAR( p_resource_req_rec.resource_id) );
681: AHL_DEBUG_PUB.debug( 'uom_code: ' || p_resource_req_rec.uom_code );
682: AHL_DEBUG_PUB.debug( 'cost_basis_code: ' || TO_CHAR( p_resource_req_rec.cost_basis_code ) );
683: AHL_DEBUG_PUB.debug( 'charge_type_code: ' || TO_CHAR( p_resource_req_rec.charge_type_code) );
684: AHL_DEBUG_PUB.debug( 'std_rate_flag_code: ' || TO_CHAR( p_resource_req_rec.std_rate_flag_code) );
685: AHL_DEBUG_PUB.debug( 'scheduled_type_code: ' || TO_CHAR( p_resource_req_rec.scheduled_type_code) );
686: AHL_DEBUG_PUB.debug( 'applied_num: ' || TO_CHAR( p_resource_req_rec.applied_num) );
687: AHL_DEBUG_PUB.debug( 'open_num: ' || TO_CHAR( p_resource_req_rec.open_num) );
680: AHL_DEBUG_PUB.debug( 'resource_id: ' || TO_CHAR( p_resource_req_rec.resource_id) );
681: AHL_DEBUG_PUB.debug( 'uom_code: ' || p_resource_req_rec.uom_code );
682: AHL_DEBUG_PUB.debug( 'cost_basis_code: ' || TO_CHAR( p_resource_req_rec.cost_basis_code ) );
683: AHL_DEBUG_PUB.debug( 'charge_type_code: ' || TO_CHAR( p_resource_req_rec.charge_type_code) );
684: AHL_DEBUG_PUB.debug( 'std_rate_flag_code: ' || TO_CHAR( p_resource_req_rec.std_rate_flag_code) );
685: AHL_DEBUG_PUB.debug( 'scheduled_type_code: ' || TO_CHAR( p_resource_req_rec.scheduled_type_code) );
686: AHL_DEBUG_PUB.debug( 'applied_num: ' || TO_CHAR( p_resource_req_rec.applied_num) );
687: AHL_DEBUG_PUB.debug( 'open_num: ' || TO_CHAR( p_resource_req_rec.open_num) );
688: AHL_DEBUG_PUB.debug( 'req_start_date: ' || TO_CHAR( p_resource_req_rec.req_start_date, 'DD-MON-YYYY hh24:mi') );
681: AHL_DEBUG_PUB.debug( 'uom_code: ' || p_resource_req_rec.uom_code );
682: AHL_DEBUG_PUB.debug( 'cost_basis_code: ' || TO_CHAR( p_resource_req_rec.cost_basis_code ) );
683: AHL_DEBUG_PUB.debug( 'charge_type_code: ' || TO_CHAR( p_resource_req_rec.charge_type_code) );
684: AHL_DEBUG_PUB.debug( 'std_rate_flag_code: ' || TO_CHAR( p_resource_req_rec.std_rate_flag_code) );
685: AHL_DEBUG_PUB.debug( 'scheduled_type_code: ' || TO_CHAR( p_resource_req_rec.scheduled_type_code) );
686: AHL_DEBUG_PUB.debug( 'applied_num: ' || TO_CHAR( p_resource_req_rec.applied_num) );
687: AHL_DEBUG_PUB.debug( 'open_num: ' || TO_CHAR( p_resource_req_rec.open_num) );
688: AHL_DEBUG_PUB.debug( 'req_start_date: ' || TO_CHAR( p_resource_req_rec.req_start_date, 'DD-MON-YYYY hh24:mi') );
689: AHL_DEBUG_PUB.debug( 'req_end_date: ' || TO_CHAR( p_resource_req_rec.req_end_date, 'DD-MON-YYYY hh24:mi') );
682: AHL_DEBUG_PUB.debug( 'cost_basis_code: ' || TO_CHAR( p_resource_req_rec.cost_basis_code ) );
683: AHL_DEBUG_PUB.debug( 'charge_type_code: ' || TO_CHAR( p_resource_req_rec.charge_type_code) );
684: AHL_DEBUG_PUB.debug( 'std_rate_flag_code: ' || TO_CHAR( p_resource_req_rec.std_rate_flag_code) );
685: AHL_DEBUG_PUB.debug( 'scheduled_type_code: ' || TO_CHAR( p_resource_req_rec.scheduled_type_code) );
686: AHL_DEBUG_PUB.debug( 'applied_num: ' || TO_CHAR( p_resource_req_rec.applied_num) );
687: AHL_DEBUG_PUB.debug( 'open_num: ' || TO_CHAR( p_resource_req_rec.open_num) );
688: AHL_DEBUG_PUB.debug( 'req_start_date: ' || TO_CHAR( p_resource_req_rec.req_start_date, 'DD-MON-YYYY hh24:mi') );
689: AHL_DEBUG_PUB.debug( 'req_end_date: ' || TO_CHAR( p_resource_req_rec.req_end_date, 'DD-MON-YYYY hh24:mi') );
690: AHL_DEBUG_PUB.debug( 'quantity: ' || TO_CHAR( p_resource_req_rec.quantity) );
683: AHL_DEBUG_PUB.debug( 'charge_type_code: ' || TO_CHAR( p_resource_req_rec.charge_type_code) );
684: AHL_DEBUG_PUB.debug( 'std_rate_flag_code: ' || TO_CHAR( p_resource_req_rec.std_rate_flag_code) );
685: AHL_DEBUG_PUB.debug( 'scheduled_type_code: ' || TO_CHAR( p_resource_req_rec.scheduled_type_code) );
686: AHL_DEBUG_PUB.debug( 'applied_num: ' || TO_CHAR( p_resource_req_rec.applied_num) );
687: AHL_DEBUG_PUB.debug( 'open_num: ' || TO_CHAR( p_resource_req_rec.open_num) );
688: AHL_DEBUG_PUB.debug( 'req_start_date: ' || TO_CHAR( p_resource_req_rec.req_start_date, 'DD-MON-YYYY hh24:mi') );
689: AHL_DEBUG_PUB.debug( 'req_end_date: ' || TO_CHAR( p_resource_req_rec.req_end_date, 'DD-MON-YYYY hh24:mi') );
690: AHL_DEBUG_PUB.debug( 'quantity: ' || TO_CHAR( p_resource_req_rec.quantity) );
691: AHL_DEBUG_PUB.debug( 'duration: ' || TO_CHAR( p_resource_req_rec.duration) );
684: AHL_DEBUG_PUB.debug( 'std_rate_flag_code: ' || TO_CHAR( p_resource_req_rec.std_rate_flag_code) );
685: AHL_DEBUG_PUB.debug( 'scheduled_type_code: ' || TO_CHAR( p_resource_req_rec.scheduled_type_code) );
686: AHL_DEBUG_PUB.debug( 'applied_num: ' || TO_CHAR( p_resource_req_rec.applied_num) );
687: AHL_DEBUG_PUB.debug( 'open_num: ' || TO_CHAR( p_resource_req_rec.open_num) );
688: AHL_DEBUG_PUB.debug( 'req_start_date: ' || TO_CHAR( p_resource_req_rec.req_start_date, 'DD-MON-YYYY hh24:mi') );
689: AHL_DEBUG_PUB.debug( 'req_end_date: ' || TO_CHAR( p_resource_req_rec.req_end_date, 'DD-MON-YYYY hh24:mi') );
690: AHL_DEBUG_PUB.debug( 'quantity: ' || TO_CHAR( p_resource_req_rec.quantity) );
691: AHL_DEBUG_PUB.debug( 'duration: ' || TO_CHAR( p_resource_req_rec.duration) );
692: END IF;
685: AHL_DEBUG_PUB.debug( 'scheduled_type_code: ' || TO_CHAR( p_resource_req_rec.scheduled_type_code) );
686: AHL_DEBUG_PUB.debug( 'applied_num: ' || TO_CHAR( p_resource_req_rec.applied_num) );
687: AHL_DEBUG_PUB.debug( 'open_num: ' || TO_CHAR( p_resource_req_rec.open_num) );
688: AHL_DEBUG_PUB.debug( 'req_start_date: ' || TO_CHAR( p_resource_req_rec.req_start_date, 'DD-MON-YYYY hh24:mi') );
689: AHL_DEBUG_PUB.debug( 'req_end_date: ' || TO_CHAR( p_resource_req_rec.req_end_date, 'DD-MON-YYYY hh24:mi') );
690: AHL_DEBUG_PUB.debug( 'quantity: ' || TO_CHAR( p_resource_req_rec.quantity) );
691: AHL_DEBUG_PUB.debug( 'duration: ' || TO_CHAR( p_resource_req_rec.duration) );
692: END IF;
693:
686: AHL_DEBUG_PUB.debug( 'applied_num: ' || TO_CHAR( p_resource_req_rec.applied_num) );
687: AHL_DEBUG_PUB.debug( 'open_num: ' || TO_CHAR( p_resource_req_rec.open_num) );
688: AHL_DEBUG_PUB.debug( 'req_start_date: ' || TO_CHAR( p_resource_req_rec.req_start_date, 'DD-MON-YYYY hh24:mi') );
689: AHL_DEBUG_PUB.debug( 'req_end_date: ' || TO_CHAR( p_resource_req_rec.req_end_date, 'DD-MON-YYYY hh24:mi') );
690: AHL_DEBUG_PUB.debug( 'quantity: ' || TO_CHAR( p_resource_req_rec.quantity) );
691: AHL_DEBUG_PUB.debug( 'duration: ' || TO_CHAR( p_resource_req_rec.duration) );
692: END IF;
693:
694: -- Populate EAM Record attributes from input table
687: AHL_DEBUG_PUB.debug( 'open_num: ' || TO_CHAR( p_resource_req_rec.open_num) );
688: AHL_DEBUG_PUB.debug( 'req_start_date: ' || TO_CHAR( p_resource_req_rec.req_start_date, 'DD-MON-YYYY hh24:mi') );
689: AHL_DEBUG_PUB.debug( 'req_end_date: ' || TO_CHAR( p_resource_req_rec.req_end_date, 'DD-MON-YYYY hh24:mi') );
690: AHL_DEBUG_PUB.debug( 'quantity: ' || TO_CHAR( p_resource_req_rec.quantity) );
691: AHL_DEBUG_PUB.debug( 'duration: ' || TO_CHAR( p_resource_req_rec.duration) );
692: END IF;
693:
694: -- Populate EAM Record attributes from input table
695: x_eam_res_rec.wip_entity_id := p_resource_req_rec.wip_entity_id;
742:
743: BEGIN
744: -- Log Input Values
745: IF ( G_DEBUG = 'Y' ) THEN
746: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_resource_assign_rec.operation_flag );
747: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_assign_rec.workorder_id ) );
748: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_assign_rec.wip_entity_id ) );
749: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_assign_rec.organization_id ) );
750: AHL_DEBUG_PUB.debug( 'operation_seq_number: ' || TO_CHAR( p_resource_assign_rec.operation_seq_number) );
743: BEGIN
744: -- Log Input Values
745: IF ( G_DEBUG = 'Y' ) THEN
746: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_resource_assign_rec.operation_flag );
747: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_assign_rec.workorder_id ) );
748: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_assign_rec.wip_entity_id ) );
749: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_assign_rec.organization_id ) );
750: AHL_DEBUG_PUB.debug( 'operation_seq_number: ' || TO_CHAR( p_resource_assign_rec.operation_seq_number) );
751: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_assign_rec.resource_seq_number) );
744: -- Log Input Values
745: IF ( G_DEBUG = 'Y' ) THEN
746: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_resource_assign_rec.operation_flag );
747: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_assign_rec.workorder_id ) );
748: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_assign_rec.wip_entity_id ) );
749: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_assign_rec.organization_id ) );
750: AHL_DEBUG_PUB.debug( 'operation_seq_number: ' || TO_CHAR( p_resource_assign_rec.operation_seq_number) );
751: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_assign_rec.resource_seq_number) );
752: AHL_DEBUG_PUB.debug( 'instance_id: ' || TO_CHAR( p_resource_assign_rec.instance_id) );
745: IF ( G_DEBUG = 'Y' ) THEN
746: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_resource_assign_rec.operation_flag );
747: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_assign_rec.workorder_id ) );
748: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_assign_rec.wip_entity_id ) );
749: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_assign_rec.organization_id ) );
750: AHL_DEBUG_PUB.debug( 'operation_seq_number: ' || TO_CHAR( p_resource_assign_rec.operation_seq_number) );
751: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_assign_rec.resource_seq_number) );
752: AHL_DEBUG_PUB.debug( 'instance_id: ' || TO_CHAR( p_resource_assign_rec.instance_id) );
753: AHL_DEBUG_PUB.debug( 'serial_number: ' || p_resource_assign_rec.serial_number );
746: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_resource_assign_rec.operation_flag );
747: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_assign_rec.workorder_id ) );
748: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_assign_rec.wip_entity_id ) );
749: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_assign_rec.organization_id ) );
750: AHL_DEBUG_PUB.debug( 'operation_seq_number: ' || TO_CHAR( p_resource_assign_rec.operation_seq_number) );
751: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_assign_rec.resource_seq_number) );
752: AHL_DEBUG_PUB.debug( 'instance_id: ' || TO_CHAR( p_resource_assign_rec.instance_id) );
753: AHL_DEBUG_PUB.debug( 'serial_number: ' || p_resource_assign_rec.serial_number );
754: AHL_DEBUG_PUB.debug( 'assign_start_date: ' || TO_CHAR( p_resource_assign_rec.assign_start_date, 'DD-MON-YYYY hh24:mi') );
747: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_assign_rec.workorder_id ) );
748: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_assign_rec.wip_entity_id ) );
749: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_assign_rec.organization_id ) );
750: AHL_DEBUG_PUB.debug( 'operation_seq_number: ' || TO_CHAR( p_resource_assign_rec.operation_seq_number) );
751: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_assign_rec.resource_seq_number) );
752: AHL_DEBUG_PUB.debug( 'instance_id: ' || TO_CHAR( p_resource_assign_rec.instance_id) );
753: AHL_DEBUG_PUB.debug( 'serial_number: ' || p_resource_assign_rec.serial_number );
754: AHL_DEBUG_PUB.debug( 'assign_start_date: ' || TO_CHAR( p_resource_assign_rec.assign_start_date, 'DD-MON-YYYY hh24:mi') );
755: AHL_DEBUG_PUB.debug( 'assign_end_date: ' || TO_CHAR( p_resource_assign_rec.assign_end_date, 'DD-MON-YYYY hh24:mi') );
748: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_assign_rec.wip_entity_id ) );
749: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_assign_rec.organization_id ) );
750: AHL_DEBUG_PUB.debug( 'operation_seq_number: ' || TO_CHAR( p_resource_assign_rec.operation_seq_number) );
751: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_assign_rec.resource_seq_number) );
752: AHL_DEBUG_PUB.debug( 'instance_id: ' || TO_CHAR( p_resource_assign_rec.instance_id) );
753: AHL_DEBUG_PUB.debug( 'serial_number: ' || p_resource_assign_rec.serial_number );
754: AHL_DEBUG_PUB.debug( 'assign_start_date: ' || TO_CHAR( p_resource_assign_rec.assign_start_date, 'DD-MON-YYYY hh24:mi') );
755: AHL_DEBUG_PUB.debug( 'assign_end_date: ' || TO_CHAR( p_resource_assign_rec.assign_end_date, 'DD-MON-YYYY hh24:mi') );
756: END IF;
749: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_assign_rec.organization_id ) );
750: AHL_DEBUG_PUB.debug( 'operation_seq_number: ' || TO_CHAR( p_resource_assign_rec.operation_seq_number) );
751: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_assign_rec.resource_seq_number) );
752: AHL_DEBUG_PUB.debug( 'instance_id: ' || TO_CHAR( p_resource_assign_rec.instance_id) );
753: AHL_DEBUG_PUB.debug( 'serial_number: ' || p_resource_assign_rec.serial_number );
754: AHL_DEBUG_PUB.debug( 'assign_start_date: ' || TO_CHAR( p_resource_assign_rec.assign_start_date, 'DD-MON-YYYY hh24:mi') );
755: AHL_DEBUG_PUB.debug( 'assign_end_date: ' || TO_CHAR( p_resource_assign_rec.assign_end_date, 'DD-MON-YYYY hh24:mi') );
756: END IF;
757:
750: AHL_DEBUG_PUB.debug( 'operation_seq_number: ' || TO_CHAR( p_resource_assign_rec.operation_seq_number) );
751: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_assign_rec.resource_seq_number) );
752: AHL_DEBUG_PUB.debug( 'instance_id: ' || TO_CHAR( p_resource_assign_rec.instance_id) );
753: AHL_DEBUG_PUB.debug( 'serial_number: ' || p_resource_assign_rec.serial_number );
754: AHL_DEBUG_PUB.debug( 'assign_start_date: ' || TO_CHAR( p_resource_assign_rec.assign_start_date, 'DD-MON-YYYY hh24:mi') );
755: AHL_DEBUG_PUB.debug( 'assign_end_date: ' || TO_CHAR( p_resource_assign_rec.assign_end_date, 'DD-MON-YYYY hh24:mi') );
756: END IF;
757:
758: -- Populate EAM Record attributes from input table
751: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_assign_rec.resource_seq_number) );
752: AHL_DEBUG_PUB.debug( 'instance_id: ' || TO_CHAR( p_resource_assign_rec.instance_id) );
753: AHL_DEBUG_PUB.debug( 'serial_number: ' || p_resource_assign_rec.serial_number );
754: AHL_DEBUG_PUB.debug( 'assign_start_date: ' || TO_CHAR( p_resource_assign_rec.assign_start_date, 'DD-MON-YYYY hh24:mi') );
755: AHL_DEBUG_PUB.debug( 'assign_end_date: ' || TO_CHAR( p_resource_assign_rec.assign_end_date, 'DD-MON-YYYY hh24:mi') );
756: END IF;
757:
758: -- Populate EAM Record attributes from input table
759: x_eam_res_inst_rec.wip_entity_id := p_resource_assign_rec.wip_entity_id;
834: BEGIN
835:
836: -- Enable Debug
837: IF ( G_DEBUG = 'Y' ) THEN
838: AHL_DEBUG_PUB.enable_debug;
839: END IF;
840:
841: -- Initialize API return status to success
842: x_return_status := FND_API.G_RET_STS_SUCCESS;
844: -- Standard Start of API savepoint
845: SAVEPOINT create_eam_workorder_PVT;
846:
847: IF ( G_DEBUG = 'Y' ) THEN
848: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
849: AHL_DEBUG_PUB.debug( 'Job Header Record: ' );
850: END IF;
851:
852: -- Map all input AHL Job Header record attributes to the
845: SAVEPOINT create_eam_workorder_PVT;
846:
847: IF ( G_DEBUG = 'Y' ) THEN
848: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
849: AHL_DEBUG_PUB.debug( 'Job Header Record: ' );
850: END IF;
851:
852: -- Map all input AHL Job Header record attributes to the
853: -- corresponding EAM Job Header record attributes.
857: x_eam_wo_rec => l_eam_wo_rec
858: );
859:
860: IF ( G_DEBUG = 'Y' ) THEN
861: AHL_DEBUG_PUB.debug( 'Job Header Record Mapping Complete' );
862: END IF;
863:
864: -- Map all input AHL Operation record attributes to the
865: -- corresponding EAM Operation record attributes.
865: -- corresponding EAM Operation record attributes.
866: FOR i IN p_operation_tbl.FIRST..p_operation_tbl.LAST LOOP
867:
868: IF ( G_DEBUG = 'Y' ) THEN
869: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
870: AHL_DEBUG_PUB.debug( 'Operation Record Number : ' || i );
871: END IF;
872:
873: map_ahl_eam_op_rec
866: FOR i IN p_operation_tbl.FIRST..p_operation_tbl.LAST LOOP
867:
868: IF ( G_DEBUG = 'Y' ) THEN
869: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
870: AHL_DEBUG_PUB.debug( 'Operation Record Number : ' || i );
871: END IF;
872:
873: map_ahl_eam_op_rec
874: (
878:
879: END LOOP;
880:
881: IF ( G_DEBUG = 'Y' ) THEN
882: AHL_DEBUG_PUB.debug( 'Operations Record Mapping Complete' );
883: END IF;
884:
885: -- Map all input AHL Material Requirement record attributes to the
886: -- corresponding EAM Material Requirement record attributes.
886: -- corresponding EAM Material Requirement record attributes.
887: IF ( p_material_req_tbl.COUNT > 0 ) THEN
888: FOR i IN p_material_req_tbl.FIRST..p_material_req_tbl.LAST LOOP
889: IF ( G_DEBUG = 'Y' ) THEN
890: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
891: AHL_DEBUG_PUB.debug( 'Material Requirement Record Number : ' || i );
892: END IF;
893:
894: map_ahl_eam_mat_rec
887: IF ( p_material_req_tbl.COUNT > 0 ) THEN
888: FOR i IN p_material_req_tbl.FIRST..p_material_req_tbl.LAST LOOP
889: IF ( G_DEBUG = 'Y' ) THEN
890: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
891: AHL_DEBUG_PUB.debug( 'Material Requirement Record Number : ' || i );
892: END IF;
893:
894: map_ahl_eam_mat_rec
895: (
899:
900: END LOOP;
901:
902: IF ( G_DEBUG = 'Y' ) THEN
903: AHL_DEBUG_PUB.debug( 'Material Requirements Record Mapping Complete' );
904: END IF;
905:
906: END IF;
907:
910: IF ( p_resource_req_tbl.COUNT > 0 ) THEN
911: FOR i IN p_resource_req_tbl.FIRST..p_resource_req_tbl.LAST LOOP
912:
913: IF ( G_DEBUG = 'Y' ) THEN
914: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
915: AHL_DEBUG_PUB.debug( 'Resource Requirement Record Number : ' || i );
916: END IF;
917:
918: map_ahl_eam_res_rec
911: FOR i IN p_resource_req_tbl.FIRST..p_resource_req_tbl.LAST LOOP
912:
913: IF ( G_DEBUG = 'Y' ) THEN
914: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
915: AHL_DEBUG_PUB.debug( 'Resource Requirement Record Number : ' || i );
916: END IF;
917:
918: map_ahl_eam_res_rec
919: (
923:
924: END LOOP;
925:
926: IF ( G_DEBUG = 'Y' ) THEN
927: AHL_DEBUG_PUB.debug( 'Resource Requirement Record Mapping Complete' );
928: END IF;
929:
930: END IF;
931:
940: );
941: END IF;
942:
943: IF ( G_DEBUG = 'Y' ) THEN
944: AHL_DEBUG_PUB.debug( 'Invoking EAM process_wo API' );
945: END IF;
946:
947: -- Invoke EAM BO API for Updating the Job
948: EAM_PROCESS_WO_PUB.process_wo
978: );
979:
980: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
981: IF ( G_DEBUG = 'Y' ) THEN
982: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
983: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
984: END IF;
985:
986: RAISE FND_API.G_EXC_ERROR;
979:
980: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
981: IF ( G_DEBUG = 'Y' ) THEN
982: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
983: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
984: END IF;
985:
986: RAISE FND_API.G_EXC_ERROR;
987: ELSE
985:
986: RAISE FND_API.G_EXC_ERROR;
987: ELSE
988: IF ( G_DEBUG = 'Y' ) THEN
989: AHL_DEBUG_PUB.debug( 'EAM process_wo API Successful' );
990: END IF;
991:
992: p_x_workorder_rec.wip_entity_id := l_out_eam_wo_rec.wip_entity_id;
993:
991:
992: p_x_workorder_rec.wip_entity_id := l_out_eam_wo_rec.wip_entity_id;
993:
994: IF ( G_DEBUG = 'Y' ) THEN
995: AHL_DEBUG_PUB.debug( 'New wip_entity_id:' || TO_CHAR( p_x_workorder_rec.wip_entity_id ) );
996: END IF;
997:
998: -- Perform the Commit (if requested)
999: IF FND_API.to_boolean( p_commit ) THEN
1002: END IF;
1003:
1004: -- Disable debug (if enabled)
1005: IF ( G_DEBUG = 'Y' ) THEN
1006: AHL_DEBUG_PUB.disable_debug;
1007: END IF;
1008:
1009: EXCEPTION
1010:
1018: p_data => x_msg_data
1019: );
1020:
1021: IF ( G_DEBUG = 'Y' ) THEN
1022: AHL_DEBUG_PUB.disable_debug;
1023: END IF;
1024:
1025: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1026: ROLLBACK TO create_eam_workorder_PVT;
1032: p_data => x_msg_data
1033: );
1034:
1035: IF ( G_DEBUG = 'Y' ) THEN
1036: AHL_DEBUG_PUB.disable_debug;
1037: END IF;
1038:
1039: WHEN OTHERS THEN
1040: ROLLBACK TO create_eam_workorder_PVT;
1055: p_data => x_msg_data
1056: );
1057:
1058: IF ( G_DEBUG = 'Y' ) THEN
1059: AHL_DEBUG_PUB.disable_debug;
1060: END IF;
1061: END create_eam_workorder;
1062:
1063: PROCEDURE update_job_operations
1111: BEGIN
1112:
1113: -- Enable Debug
1114: IF ( G_DEBUG = 'Y' ) THEN
1115: AHL_DEBUG_PUB.enable_debug;
1116: END IF;
1117:
1118: -- Initialize API return status to success
1119: x_return_status := FND_API.G_RET_STS_SUCCESS;
1125: -- corresponding EAM Job Header record attributes.
1126: IF ( p_workorder_rec.workorder_id IS NOT NULL ) THEN
1127:
1128: IF ( G_DEBUG = 'Y' ) THEN
1129: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1130: AHL_DEBUG_PUB.debug( 'Job Header Record: ' );
1131: END IF;
1132:
1133: map_ahl_eam_wo_rec
1126: IF ( p_workorder_rec.workorder_id IS NOT NULL ) THEN
1127:
1128: IF ( G_DEBUG = 'Y' ) THEN
1129: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1130: AHL_DEBUG_PUB.debug( 'Job Header Record: ' );
1131: END IF;
1132:
1133: map_ahl_eam_wo_rec
1134: (
1143: IF ( p_operation_tbl.COUNT > 0 ) THEN
1144: FOR i IN p_operation_tbl.FIRST..p_operation_tbl.LAST LOOP
1145:
1146: IF ( G_DEBUG = 'Y' ) THEN
1147: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1148: AHL_DEBUG_PUB.debug( 'Operation Record Number : ' || i );
1149: END IF;
1150:
1151: map_ahl_eam_op_rec
1144: FOR i IN p_operation_tbl.FIRST..p_operation_tbl.LAST LOOP
1145:
1146: IF ( G_DEBUG = 'Y' ) THEN
1147: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1148: AHL_DEBUG_PUB.debug( 'Operation Record Number : ' || i );
1149: END IF;
1150:
1151: map_ahl_eam_op_rec
1152: (
1162: IF ( p_material_req_tbl.COUNT > 0 ) THEN
1163: FOR i IN p_material_req_tbl.FIRST..p_material_req_tbl.LAST LOOP
1164:
1165: IF ( G_DEBUG = 'Y' ) THEN
1166: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1167: AHL_DEBUG_PUB.debug( 'Material Requirement Record Number : ' || i );
1168: END IF;
1169:
1170: map_ahl_eam_mat_rec
1163: FOR i IN p_material_req_tbl.FIRST..p_material_req_tbl.LAST LOOP
1164:
1165: IF ( G_DEBUG = 'Y' ) THEN
1166: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1167: AHL_DEBUG_PUB.debug( 'Material Requirement Record Number : ' || i );
1168: END IF;
1169:
1170: map_ahl_eam_mat_rec
1171: (
1181: IF ( p_resource_req_tbl.COUNT > 0 ) THEN
1182: FOR i IN p_resource_req_tbl.FIRST..p_resource_req_tbl.LAST LOOP
1183:
1184: IF ( G_DEBUG = 'Y' ) THEN
1185: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1186: AHL_DEBUG_PUB.debug( 'Resource Requirement Record Number : ' || i );
1187: END IF;
1188:
1189: map_ahl_eam_res_rec
1182: FOR i IN p_resource_req_tbl.FIRST..p_resource_req_tbl.LAST LOOP
1183:
1184: IF ( G_DEBUG = 'Y' ) THEN
1185: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1186: AHL_DEBUG_PUB.debug( 'Resource Requirement Record Number : ' || i );
1187: END IF;
1188:
1189: map_ahl_eam_res_rec
1190: (
1206: );
1207: END IF;
1208:
1209: IF ( G_DEBUG = 'Y' ) THEN
1210: AHL_DEBUG_PUB.debug( 'Invoking EAM process_wo API' );
1211: END IF;
1212:
1213: -- Invoke EAM BO API for Updating the Job
1214: EAM_PROCESS_WO_PUB.process_wo
1244: );
1245:
1246: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1247: IF ( G_DEBUG = 'Y' ) THEN
1248: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1249: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1250: END IF;
1251:
1252: RAISE FND_API.G_EXC_ERROR;
1245:
1246: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1247: IF ( G_DEBUG = 'Y' ) THEN
1248: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1249: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1250: END IF;
1251:
1252: RAISE FND_API.G_EXC_ERROR;
1253:
1259: END IF;
1260:
1261: -- Disable debug (if enabled)
1262: IF ( G_DEBUG = 'Y' ) THEN
1263: AHL_DEBUG_PUB.disable_debug;
1264: END IF;
1265:
1266: EXCEPTION
1267:
1275: p_data => x_msg_data
1276: );
1277:
1278: IF ( G_DEBUG = 'Y' ) THEN
1279: AHL_DEBUG_PUB.disable_debug;
1280: END IF;
1281:
1282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1283: ROLLBACK TO update_job_operations_PVT;
1289: p_data => x_msg_data
1290: );
1291:
1292: IF ( G_DEBUG = 'Y' ) THEN
1293: AHL_DEBUG_PUB.disable_debug;
1294: END IF;
1295:
1296: WHEN OTHERS THEN
1297: ROLLBACK TO update_job_operations_PVT;
1312: p_data => x_msg_data
1313: );
1314:
1315: IF ( G_DEBUG = 'Y' ) THEN
1316: AHL_DEBUG_PUB.disable_debug;
1317: END IF;
1318:
1319: END update_job_operations;
1320:
1366: BEGIN
1367:
1368: -- Enable Debug
1369: IF ( G_DEBUG = 'Y' ) THEN
1370: AHL_DEBUG_PUB.enable_debug;
1371: END IF;
1372:
1373: -- Initialize API return status to success
1374: x_return_status := FND_API.G_RET_STS_SUCCESS;
1380: -- corresponding EAM Material Requirement record attributes.
1381: FOR i IN p_material_req_tbl.FIRST..p_material_req_tbl.LAST LOOP
1382:
1383: IF ( G_DEBUG = 'Y' ) THEN
1384: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1385: AHL_DEBUG_PUB.debug( 'Material Requirement Record Number : ' || i );
1386: END IF;
1387:
1388: map_ahl_eam_mat_rec
1381: FOR i IN p_material_req_tbl.FIRST..p_material_req_tbl.LAST LOOP
1382:
1383: IF ( G_DEBUG = 'Y' ) THEN
1384: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1385: AHL_DEBUG_PUB.debug( 'Material Requirement Record Number : ' || i );
1386: END IF;
1387:
1388: map_ahl_eam_mat_rec
1389: (
1404: );
1405: END IF;
1406:
1407: IF ( G_DEBUG = 'Y' ) THEN
1408: AHL_DEBUG_PUB.debug( 'Invoking EAM process_wo API' );
1409: END IF;
1410:
1411: -- Invoke EAM BO API for Updating the Job
1412: EAM_PROCESS_WO_PUB.process_wo
1442: );
1443:
1444: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1445: IF ( G_DEBUG = 'Y' ) THEN
1446: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1447: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1448: END IF;
1449:
1450: RAISE FND_API.G_EXC_ERROR;
1443:
1444: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1445: IF ( G_DEBUG = 'Y' ) THEN
1446: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1447: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1448: END IF;
1449:
1450: RAISE FND_API.G_EXC_ERROR;
1451: END IF;
1456: END IF;
1457:
1458: -- Disable debug (if enabled)
1459: IF ( G_DEBUG = 'Y' ) THEN
1460: AHL_DEBUG_PUB.disable_debug;
1461: END IF;
1462:
1463: EXCEPTION
1464:
1472: p_data => x_msg_data
1473: );
1474:
1475: IF ( G_DEBUG = 'Y' ) THEN
1476: AHL_DEBUG_PUB.disable_debug;
1477: END IF;
1478:
1479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1480: ROLLBACK TO process_material_req_PVT;
1486: p_data => x_msg_data
1487: );
1488:
1489: IF ( G_DEBUG = 'Y' ) THEN
1490: AHL_DEBUG_PUB.disable_debug;
1491: END IF;
1492:
1493: WHEN OTHERS THEN
1494: ROLLBACK TO process_material_req_PVT;
1509: p_data => x_msg_data
1510: );
1511:
1512: IF ( G_DEBUG = 'Y' ) THEN
1513: AHL_DEBUG_PUB.disable_debug;
1514: END IF;
1515:
1516: END process_material_req;
1517:
1572: BEGIN
1573:
1574: -- Enable Debug
1575: IF ( G_DEBUG = 'Y' ) THEN
1576: AHL_DEBUG_PUB.enable_debug;
1577: END IF;
1578:
1579: -- Initialize API return status to success
1580: x_return_status := FND_API.G_RET_STS_SUCCESS;
1586: -- corresponding EAM Resource Requirement record attributes.
1587: FOR i IN p_resource_req_tbl.FIRST..p_resource_req_tbl.LAST LOOP
1588:
1589: IF ( G_DEBUG = 'Y' ) THEN
1590: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1591: AHL_DEBUG_PUB.debug( 'Resource Requirement Record Number : ' || i );
1592: END IF;
1593:
1594: map_ahl_eam_res_rec
1587: FOR i IN p_resource_req_tbl.FIRST..p_resource_req_tbl.LAST LOOP
1588:
1589: IF ( G_DEBUG = 'Y' ) THEN
1590: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1591: AHL_DEBUG_PUB.debug( 'Resource Requirement Record Number : ' || i );
1592: END IF;
1593:
1594: map_ahl_eam_res_rec
1595: (
1610: );
1611: END IF;
1612:
1613: IF ( G_DEBUG = 'Y' ) THEN
1614: AHL_DEBUG_PUB.debug( 'Invoking EAM process_wo API' );
1615: END IF;
1616: --Changes for #9388148 --start
1617: --As per EAM Update, if requested start date is null then for adding the resource requirement, work order start date is changed to
1618: --Visit Master Work order start date.So we get an 'scheduling hierarchy...' error.Because the child work order expands beyond the parent
1666: );
1667:
1668: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1669: IF ( G_DEBUG = 'Y' ) THEN
1670: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1671: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1672: END IF;
1673:
1674: RAISE FND_API.G_EXC_ERROR;
1667:
1668: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1669: IF ( G_DEBUG = 'Y' ) THEN
1670: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1671: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1672: END IF;
1673:
1674: RAISE FND_API.G_EXC_ERROR;
1675: END IF;
1680: END IF;
1681:
1682: -- Disable debug (if enabled)
1683: IF ( G_DEBUG = 'Y' ) THEN
1684: AHL_DEBUG_PUB.disable_debug;
1685: END IF;
1686:
1687: EXCEPTION
1688:
1696: p_data => x_msg_data
1697: );
1698:
1699: IF ( G_DEBUG = 'Y' ) THEN
1700: AHL_DEBUG_PUB.disable_debug;
1701: END IF;
1702:
1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1704: ROLLBACK TO process_resource_req_PVT;
1710: p_data => x_msg_data
1711: );
1712:
1713: IF ( G_DEBUG = 'Y' ) THEN
1714: AHL_DEBUG_PUB.disable_debug;
1715: END IF;
1716:
1717: WHEN OTHERS THEN
1718: ROLLBACK TO process_resource_req_PVT;
1733: p_data => x_msg_data
1734: );
1735:
1736: IF ( G_DEBUG = 'Y' ) THEN
1737: AHL_DEBUG_PUB.disable_debug;
1738: END IF;
1739:
1740: END process_resource_req;
1741:
1787: BEGIN
1788:
1789: -- Enable Debug
1790: IF ( G_DEBUG = 'Y' ) THEN
1791: AHL_DEBUG_PUB.enable_debug;
1792: END IF;
1793:
1794: -- Initialize API return status to success
1795: x_return_status := FND_API.G_RET_STS_SUCCESS;
1801: -- corresponding EAM Material Requirement record attributes.
1802: FOR i IN p_resource_assign_tbl.FIRST..p_resource_assign_tbl.LAST LOOP
1803:
1804: IF ( G_DEBUG = 'Y' ) THEN
1805: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1806: AHL_DEBUG_PUB.debug( 'Resource Assignment Record Number : ' || i );
1807: END IF;
1808:
1809: map_ahl_eam_res_inst_rec
1802: FOR i IN p_resource_assign_tbl.FIRST..p_resource_assign_tbl.LAST LOOP
1803:
1804: IF ( G_DEBUG = 'Y' ) THEN
1805: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1806: AHL_DEBUG_PUB.debug( 'Resource Assignment Record Number : ' || i );
1807: END IF;
1808:
1809: map_ahl_eam_res_inst_rec
1810: (
1825: );
1826: END IF;
1827:
1828: IF ( G_DEBUG = 'Y' ) THEN
1829: AHL_DEBUG_PUB.debug( 'Invoking EAM process_wo API' );
1830: END IF;
1831:
1832: -- Invoke EAM BO API for Updating the Job
1833: EAM_PROCESS_WO_PUB.process_wo
1863: );
1864:
1865: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1866: IF ( G_DEBUG = 'Y' ) THEN
1867: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1868: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1869: END IF;
1870:
1871: RAISE FND_API.G_EXC_ERROR;
1864:
1865: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1866: IF ( G_DEBUG = 'Y' ) THEN
1867: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1868: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1869: END IF;
1870:
1871: RAISE FND_API.G_EXC_ERROR;
1872: END IF;
1877: END IF;
1878:
1879: -- Disable debug (if enabled)
1880: IF ( G_DEBUG = 'Y' ) THEN
1881: AHL_DEBUG_PUB.disable_debug;
1882: END IF;
1883:
1884: EXCEPTION
1885:
1893: p_data => x_msg_data
1894: );
1895:
1896: IF ( G_DEBUG = 'Y' ) THEN
1897: AHL_DEBUG_PUB.disable_debug;
1898: END IF;
1899:
1900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1901: ROLLBACK TO process_resource_assign_PVT;
1907: p_data => x_msg_data
1908: );
1909:
1910: IF ( G_DEBUG = 'Y' ) THEN
1911: AHL_DEBUG_PUB.disable_debug;
1912: END IF;
1913:
1914: WHEN OTHERS THEN
1915: ROLLBACK TO process_resource_assign_PVT;
1930: p_data => x_msg_data
1931: );
1932:
1933: IF ( G_DEBUG = 'Y' ) THEN
1934: AHL_DEBUG_PUB.disable_debug;
1935: END IF;
1936:
1937: END process_resource_assign;
1938:
1983: BEGIN
1984:
1985: -- Enable Debug
1986: IF ( G_DEBUG = 'Y' ) THEN
1987: AHL_DEBUG_PUB.enable_debug;
1988: END IF;
1989:
1990: -- Initialize API return status to success
1991: x_return_status := FND_API.G_RET_STS_SUCCESS;
2004: );
2005: END IF;
2006:
2007: IF ( G_DEBUG = 'Y' ) THEN
2008: AHL_DEBUG_PUB.debug( 'Invoking EAM process_master_child_wo API' );
2009:
2010: IF(p_x_eam_wo_tbl.COUNT > 0) THEN
2011: FOR i IN p_x_eam_wo_tbl.FIRST..p_x_eam_wo_tbl.LAST LOOP
2012: AHL_DEBUG_PUB.debug( 'Workorder('||i||') batch_id : '||p_x_eam_wo_tbl(i).batch_id );
2008: AHL_DEBUG_PUB.debug( 'Invoking EAM process_master_child_wo API' );
2009:
2010: IF(p_x_eam_wo_tbl.COUNT > 0) THEN
2011: FOR i IN p_x_eam_wo_tbl.FIRST..p_x_eam_wo_tbl.LAST LOOP
2012: AHL_DEBUG_PUB.debug( 'Workorder('||i||') batch_id : '||p_x_eam_wo_tbl(i).batch_id );
2013: AHL_DEBUG_PUB.debug( 'Workorder('||i||') header_id : '||p_x_eam_wo_tbl(i).header_id );
2014: END LOOP;
2015: END IF;
2016:
2009:
2010: IF(p_x_eam_wo_tbl.COUNT > 0) THEN
2011: FOR i IN p_x_eam_wo_tbl.FIRST..p_x_eam_wo_tbl.LAST LOOP
2012: AHL_DEBUG_PUB.debug( 'Workorder('||i||') batch_id : '||p_x_eam_wo_tbl(i).batch_id );
2013: AHL_DEBUG_PUB.debug( 'Workorder('||i||') header_id : '||p_x_eam_wo_tbl(i).header_id );
2014: END LOOP;
2015: END IF;
2016:
2017: IF ( p_eam_op_tbl.COUNT > 0 ) THEN
2015: END IF;
2016:
2017: IF ( p_eam_op_tbl.COUNT > 0 ) THEN
2018: FOR i IN p_eam_op_tbl.FIRST..p_eam_op_tbl.LAST LOOP
2019: AHL_DEBUG_PUB.debug( 'Operation('||i||') batch_id : '||p_eam_op_tbl(i).batch_id );
2020: AHL_DEBUG_PUB.debug( 'Operation('||i||') header_id : '||p_eam_op_tbl(i).header_id );
2021: END LOOP;
2022: END IF;
2023:
2016:
2017: IF ( p_eam_op_tbl.COUNT > 0 ) THEN
2018: FOR i IN p_eam_op_tbl.FIRST..p_eam_op_tbl.LAST LOOP
2019: AHL_DEBUG_PUB.debug( 'Operation('||i||') batch_id : '||p_eam_op_tbl(i).batch_id );
2020: AHL_DEBUG_PUB.debug( 'Operation('||i||') header_id : '||p_eam_op_tbl(i).header_id );
2021: END LOOP;
2022: END IF;
2023:
2024: IF ( p_eam_res_req_tbl.COUNT > 0 ) THEN
2022: END IF;
2023:
2024: IF ( p_eam_res_req_tbl.COUNT > 0 ) THEN
2025: FOR i IN p_eam_res_req_tbl.FIRST..p_eam_res_req_tbl.LAST LOOP
2026: AHL_DEBUG_PUB.debug( 'Resource('||i||') batch_id : '||p_eam_res_req_tbl(i).batch_id );
2027: AHL_DEBUG_PUB.debug( 'Resource('||i||') header_id : '||p_eam_res_req_tbl(i).header_id );
2028: END LOOP;
2029: END IF;
2030:
2023:
2024: IF ( p_eam_res_req_tbl.COUNT > 0 ) THEN
2025: FOR i IN p_eam_res_req_tbl.FIRST..p_eam_res_req_tbl.LAST LOOP
2026: AHL_DEBUG_PUB.debug( 'Resource('||i||') batch_id : '||p_eam_res_req_tbl(i).batch_id );
2027: AHL_DEBUG_PUB.debug( 'Resource('||i||') header_id : '||p_eam_res_req_tbl(i).header_id );
2028: END LOOP;
2029: END IF;
2030:
2031: IF ( p_eam_mat_req_tbl.COUNT > 0 ) THEN
2029: END IF;
2030:
2031: IF ( p_eam_mat_req_tbl.COUNT > 0 ) THEN
2032: FOR i IN p_eam_mat_req_tbl.FIRST..p_eam_mat_req_tbl.LAST LOOP
2033: AHL_DEBUG_PUB.debug( 'Material('||i||') batch_id : '||p_eam_mat_req_tbl(i).batch_id );
2034: AHL_DEBUG_PUB.debug( 'Material('||i||') header_id : '||p_eam_mat_req_tbl(i).header_id );
2035: END LOOP;
2036: END IF;
2037:
2030:
2031: IF ( p_eam_mat_req_tbl.COUNT > 0 ) THEN
2032: FOR i IN p_eam_mat_req_tbl.FIRST..p_eam_mat_req_tbl.LAST LOOP
2033: AHL_DEBUG_PUB.debug( 'Material('||i||') batch_id : '||p_eam_mat_req_tbl(i).batch_id );
2034: AHL_DEBUG_PUB.debug( 'Material('||i||') header_id : '||p_eam_mat_req_tbl(i).header_id );
2035: END LOOP;
2036: END IF;
2037:
2038: END IF;
2070: );
2071:
2072: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2073: IF ( G_DEBUG = 'Y' ) THEN
2074: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
2075: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
2076: END IF;
2077:
2078: RAISE FND_API.G_EXC_ERROR;
2071:
2072: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2073: IF ( G_DEBUG = 'Y' ) THEN
2074: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
2075: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
2076: END IF;
2077:
2078: RAISE FND_API.G_EXC_ERROR;
2079:
2082: --Ignore messages in stack if return status is S after calls to EAM APIs.
2083: FND_MSG_PUB.initialize;
2084:
2085: IF ( G_DEBUG = 'Y' ) THEN
2086: AHL_DEBUG_PUB.debug( 'EAM process_master_child_wo API Successful' );
2087: AHL_DEBUG_PUB.debug( 'Input Workorder Table count : ' || p_x_eam_wo_tbl.COUNT );
2088: AHL_DEBUG_PUB.debug( 'Output Workorder Table count : ' || l_out_eam_wo_tbl.COUNT );
2089: END IF;
2090:
2083: FND_MSG_PUB.initialize;
2084:
2085: IF ( G_DEBUG = 'Y' ) THEN
2086: AHL_DEBUG_PUB.debug( 'EAM process_master_child_wo API Successful' );
2087: AHL_DEBUG_PUB.debug( 'Input Workorder Table count : ' || p_x_eam_wo_tbl.COUNT );
2088: AHL_DEBUG_PUB.debug( 'Output Workorder Table count : ' || l_out_eam_wo_tbl.COUNT );
2089: END IF;
2090:
2091: FOR i IN 1..l_out_eam_wo_tbl.COUNT LOOP
2084:
2085: IF ( G_DEBUG = 'Y' ) THEN
2086: AHL_DEBUG_PUB.debug( 'EAM process_master_child_wo API Successful' );
2087: AHL_DEBUG_PUB.debug( 'Input Workorder Table count : ' || p_x_eam_wo_tbl.COUNT );
2088: AHL_DEBUG_PUB.debug( 'Output Workorder Table count : ' || l_out_eam_wo_tbl.COUNT );
2089: END IF;
2090:
2091: FOR i IN 1..l_out_eam_wo_tbl.COUNT LOOP
2092: IF ( l_out_eam_wo_tbl(i).wip_entity_id IS NULL ) THEN
2094: FND_MESSAGE.set_token('HEADER', l_out_eam_wo_tbl(i).header_id );
2095: FND_MSG_PUB.add;
2096:
2097: IF ( G_DEBUG = 'Y' ) THEN
2098: AHL_DEBUG_PUB.debug( 'No wip_entity_id generated for header_id:' || l_out_eam_wo_tbl(i).header_id );
2099: END IF;
2100: ELSE
2101:
2102: IF ( G_DEBUG = 'Y' ) THEN
2099: END IF;
2100: ELSE
2101:
2102: IF ( G_DEBUG = 'Y' ) THEN
2103: AHL_DEBUG_PUB.debug( 'wip_entity_id(' || i || '):' || TO_CHAR( l_out_eam_wo_tbl(i).wip_entity_id ) );
2104: END IF;
2105:
2106: p_x_eam_wo_tbl(i).wip_entity_id := l_out_eam_wo_tbl(i).wip_entity_id;
2107:
2120: END IF;
2121:
2122: -- Disable debug (if enabled)
2123: IF ( G_DEBUG = 'Y' ) THEN
2124: AHL_DEBUG_PUB.disable_debug;
2125: END IF;
2126:
2127: EXCEPTION
2128:
2136: p_data => x_msg_data
2137: );
2138:
2139: IF ( G_DEBUG = 'Y' ) THEN
2140: AHL_DEBUG_PUB.disable_debug;
2141: END IF;
2142:
2143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2144: ROLLBACK TO process_eam_workorders_PVT;
2150: p_data => x_msg_data
2151: );
2152:
2153: IF ( G_DEBUG = 'Y' ) THEN
2154: AHL_DEBUG_PUB.disable_debug;
2155: END IF;
2156:
2157: WHEN OTHERS THEN
2158: ROLLBACK TO process_eam_workorders_PVT;
2173: p_data => x_msg_data
2174: );
2175:
2176: IF ( G_DEBUG = 'Y' ) THEN
2177: AHL_DEBUG_PUB.disable_debug;
2178: END IF;
2179: END process_eam_workorders;
2180:
2181: --pekambar added new procedure for ER # 9410221 -- start
2217: BEGIN
2218:
2219: -- Enable Debug
2220: IF ( G_DEBUG = 'Y' ) THEN
2221: AHL_DEBUG_PUB.enable_debug;
2222: END IF;
2223:
2224: -- Initialize API return status to success
2225: x_return_status := FND_API.G_RET_STS_SUCCESS;
2228: SAVEPOINT move_workorder_PVT;
2229:
2230:
2231: IF ( G_DEBUG = 'Y' ) THEN
2232: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
2233: AHL_DEBUG_PUB.debug('Before call to EAM_WO_NETWORK_UTIL_PVT.Move_WO: ');
2234: AHL_DEBUG_PUB.debug('WIP Enitity ID : p_work_object_id' || p_wip_entity_id);
2235: AHL_DEBUG_PUB.debug('p_scheduled_start_date ' || p_scheduled_start_date);
2236: AHL_DEBUG_PUB.debug('p_scheduled_end_date ' || p_scheduled_end_date);
2229:
2230:
2231: IF ( G_DEBUG = 'Y' ) THEN
2232: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
2233: AHL_DEBUG_PUB.debug('Before call to EAM_WO_NETWORK_UTIL_PVT.Move_WO: ');
2234: AHL_DEBUG_PUB.debug('WIP Enitity ID : p_work_object_id' || p_wip_entity_id);
2235: AHL_DEBUG_PUB.debug('p_scheduled_start_date ' || p_scheduled_start_date);
2236: AHL_DEBUG_PUB.debug('p_scheduled_end_date ' || p_scheduled_end_date);
2237: END IF;
2230:
2231: IF ( G_DEBUG = 'Y' ) THEN
2232: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
2233: AHL_DEBUG_PUB.debug('Before call to EAM_WO_NETWORK_UTIL_PVT.Move_WO: ');
2234: AHL_DEBUG_PUB.debug('WIP Enitity ID : p_work_object_id' || p_wip_entity_id);
2235: AHL_DEBUG_PUB.debug('p_scheduled_start_date ' || p_scheduled_start_date);
2236: AHL_DEBUG_PUB.debug('p_scheduled_end_date ' || p_scheduled_end_date);
2237: END IF;
2238:
2231: IF ( G_DEBUG = 'Y' ) THEN
2232: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
2233: AHL_DEBUG_PUB.debug('Before call to EAM_WO_NETWORK_UTIL_PVT.Move_WO: ');
2234: AHL_DEBUG_PUB.debug('WIP Enitity ID : p_work_object_id' || p_wip_entity_id);
2235: AHL_DEBUG_PUB.debug('p_scheduled_start_date ' || p_scheduled_start_date);
2236: AHL_DEBUG_PUB.debug('p_scheduled_end_date ' || p_scheduled_end_date);
2237: END IF;
2238:
2239: -- Mapping attriburtes for EAM
2232: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
2233: AHL_DEBUG_PUB.debug('Before call to EAM_WO_NETWORK_UTIL_PVT.Move_WO: ');
2234: AHL_DEBUG_PUB.debug('WIP Enitity ID : p_work_object_id' || p_wip_entity_id);
2235: AHL_DEBUG_PUB.debug('p_scheduled_start_date ' || p_scheduled_start_date);
2236: AHL_DEBUG_PUB.debug('p_scheduled_end_date ' || p_scheduled_end_date);
2237: END IF;
2238:
2239: -- Mapping attriburtes for EAM
2240:
2266: x_msg_data => l_msg_data
2267: );
2268:
2269: IF ( G_DEBUG = 'Y' ) THEN
2270: AHL_DEBUG_PUB.debug('After call to EAM_WO_NETWORK_UTIL_PVT.Move_WO: ');
2271: END IF;
2272:
2273: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2274: IF ( G_DEBUG = 'Y' ) THEN
2271: END IF;
2272:
2273: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2274: IF ( G_DEBUG = 'Y' ) THEN
2275: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
2276: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
2277: END IF;
2278:
2279: RAISE FND_API.G_EXC_ERROR;
2272:
2273: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2274: IF ( G_DEBUG = 'Y' ) THEN
2275: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
2276: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
2277: END IF;
2278:
2279: RAISE FND_API.G_EXC_ERROR;
2280:
2286: END IF;
2287:
2288: -- Disable debug (if enabled)
2289: IF ( G_DEBUG = 'Y' ) THEN
2290: AHL_DEBUG_PUB.disable_debug;
2291: END IF;
2292:
2293: EXCEPTION
2294:
2302: p_data => x_msg_data
2303: );
2304:
2305: IF ( G_DEBUG = 'Y' ) THEN
2306: AHL_DEBUG_PUB.disable_debug;
2307: END IF;
2308:
2309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2310: ROLLBACK TO move_workorder_PVT;
2316: p_data => x_msg_data
2317: );
2318:
2319: IF ( G_DEBUG = 'Y' ) THEN
2320: AHL_DEBUG_PUB.disable_debug;
2321: END IF;
2322:
2323: WHEN OTHERS THEN
2324: ROLLBACK TO move_workorder_PVT;
2339: p_data => x_msg_data
2340: );
2341:
2342: IF ( G_DEBUG = 'Y' ) THEN
2343: AHL_DEBUG_PUB.disable_debug;
2344: END IF;
2345:
2346: END move_workorder;
2347: