[Home] [Help]
1: PACKAGE BODY AHL_EAM_JOB_PVT AS
2: /* $Header: AHLVEAMB.pls 120.3.12010000.3 2008/12/28 00:22:24 sracha 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,
468:
469:
470: IF ( G_DEBUG = 'Y' ) THEN
471:
472: AHL_DEBUG_PUB.debug( 'Requested Start Date: ' || TO_CHAR( x_eam_wo_rec.requested_start_date, 'DD-MON-YYYY hh24:mi') );
473: AHL_DEBUG_PUB.debug( 'Due Date: ' || TO_CHAR( x_eam_wo_rec.due_date, 'DD-MON-YYYY hh24:mi') );
474: END IF;
475:
476: x_eam_wo_rec.return_status := NULL;
469:
470: IF ( G_DEBUG = 'Y' ) THEN
471:
472: AHL_DEBUG_PUB.debug( 'Requested Start Date: ' || TO_CHAR( x_eam_wo_rec.requested_start_date, 'DD-MON-YYYY hh24:mi') );
473: AHL_DEBUG_PUB.debug( 'Due Date: ' || TO_CHAR( x_eam_wo_rec.due_date, 'DD-MON-YYYY hh24:mi') );
474: END IF;
475:
476: x_eam_wo_rec.return_status := NULL;
477:
488: BEGIN
489:
490: -- Log Input Values
491: IF ( G_DEBUG = 'Y' ) THEN
492: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_workorder_rel_rec.dml_operation );
493: AHL_DEBUG_PUB.debug( 'batch_id: ' || TO_CHAR( p_workorder_rel_rec.batch_id ) );
494: AHL_DEBUG_PUB.debug( 'wo_relationship_id: ' || TO_CHAR( p_workorder_rel_rec.wo_relationship_id ) );
495: AHL_DEBUG_PUB.debug( 'parent_header_id: ' || TO_CHAR( p_workorder_rel_rec.parent_header_id ) );
496: AHL_DEBUG_PUB.debug( 'parent_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.parent_wip_entity_id ) );
489:
490: -- Log Input Values
491: IF ( G_DEBUG = 'Y' ) THEN
492: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_workorder_rel_rec.dml_operation );
493: AHL_DEBUG_PUB.debug( 'batch_id: ' || TO_CHAR( p_workorder_rel_rec.batch_id ) );
494: AHL_DEBUG_PUB.debug( 'wo_relationship_id: ' || TO_CHAR( p_workorder_rel_rec.wo_relationship_id ) );
495: AHL_DEBUG_PUB.debug( 'parent_header_id: ' || TO_CHAR( p_workorder_rel_rec.parent_header_id ) );
496: AHL_DEBUG_PUB.debug( 'parent_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.parent_wip_entity_id ) );
497: AHL_DEBUG_PUB.debug( 'child_header_id: ' || TO_CHAR( p_workorder_rel_rec.child_header_id ) );
490: -- Log Input Values
491: IF ( G_DEBUG = 'Y' ) THEN
492: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_workorder_rel_rec.dml_operation );
493: AHL_DEBUG_PUB.debug( 'batch_id: ' || TO_CHAR( p_workorder_rel_rec.batch_id ) );
494: AHL_DEBUG_PUB.debug( 'wo_relationship_id: ' || TO_CHAR( p_workorder_rel_rec.wo_relationship_id ) );
495: AHL_DEBUG_PUB.debug( 'parent_header_id: ' || TO_CHAR( p_workorder_rel_rec.parent_header_id ) );
496: AHL_DEBUG_PUB.debug( 'parent_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.parent_wip_entity_id ) );
497: AHL_DEBUG_PUB.debug( 'child_header_id: ' || TO_CHAR( p_workorder_rel_rec.child_header_id ) );
498: AHL_DEBUG_PUB.debug( 'child_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.child_wip_entity_id ) );
491: IF ( G_DEBUG = 'Y' ) THEN
492: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_workorder_rel_rec.dml_operation );
493: AHL_DEBUG_PUB.debug( 'batch_id: ' || TO_CHAR( p_workorder_rel_rec.batch_id ) );
494: AHL_DEBUG_PUB.debug( 'wo_relationship_id: ' || TO_CHAR( p_workorder_rel_rec.wo_relationship_id ) );
495: AHL_DEBUG_PUB.debug( 'parent_header_id: ' || TO_CHAR( p_workorder_rel_rec.parent_header_id ) );
496: AHL_DEBUG_PUB.debug( 'parent_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.parent_wip_entity_id ) );
497: AHL_DEBUG_PUB.debug( 'child_header_id: ' || TO_CHAR( p_workorder_rel_rec.child_header_id ) );
498: AHL_DEBUG_PUB.debug( 'child_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.child_wip_entity_id ) );
499: AHL_DEBUG_PUB.debug( 'relationship_type: ' || TO_CHAR( p_workorder_rel_rec.relationship_type ) );
492: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_workorder_rel_rec.dml_operation );
493: AHL_DEBUG_PUB.debug( 'batch_id: ' || TO_CHAR( p_workorder_rel_rec.batch_id ) );
494: AHL_DEBUG_PUB.debug( 'wo_relationship_id: ' || TO_CHAR( p_workorder_rel_rec.wo_relationship_id ) );
495: AHL_DEBUG_PUB.debug( 'parent_header_id: ' || TO_CHAR( p_workorder_rel_rec.parent_header_id ) );
496: AHL_DEBUG_PUB.debug( 'parent_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.parent_wip_entity_id ) );
497: AHL_DEBUG_PUB.debug( 'child_header_id: ' || TO_CHAR( p_workorder_rel_rec.child_header_id ) );
498: AHL_DEBUG_PUB.debug( 'child_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.child_wip_entity_id ) );
499: AHL_DEBUG_PUB.debug( 'relationship_type: ' || TO_CHAR( p_workorder_rel_rec.relationship_type ) );
500: END IF;
493: AHL_DEBUG_PUB.debug( 'batch_id: ' || TO_CHAR( p_workorder_rel_rec.batch_id ) );
494: AHL_DEBUG_PUB.debug( 'wo_relationship_id: ' || TO_CHAR( p_workorder_rel_rec.wo_relationship_id ) );
495: AHL_DEBUG_PUB.debug( 'parent_header_id: ' || TO_CHAR( p_workorder_rel_rec.parent_header_id ) );
496: AHL_DEBUG_PUB.debug( 'parent_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.parent_wip_entity_id ) );
497: AHL_DEBUG_PUB.debug( 'child_header_id: ' || TO_CHAR( p_workorder_rel_rec.child_header_id ) );
498: AHL_DEBUG_PUB.debug( 'child_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.child_wip_entity_id ) );
499: AHL_DEBUG_PUB.debug( 'relationship_type: ' || TO_CHAR( p_workorder_rel_rec.relationship_type ) );
500: END IF;
501:
494: AHL_DEBUG_PUB.debug( 'wo_relationship_id: ' || TO_CHAR( p_workorder_rel_rec.wo_relationship_id ) );
495: AHL_DEBUG_PUB.debug( 'parent_header_id: ' || TO_CHAR( p_workorder_rel_rec.parent_header_id ) );
496: AHL_DEBUG_PUB.debug( 'parent_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.parent_wip_entity_id ) );
497: AHL_DEBUG_PUB.debug( 'child_header_id: ' || TO_CHAR( p_workorder_rel_rec.child_header_id ) );
498: AHL_DEBUG_PUB.debug( 'child_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.child_wip_entity_id ) );
499: AHL_DEBUG_PUB.debug( 'relationship_type: ' || TO_CHAR( p_workorder_rel_rec.relationship_type ) );
500: END IF;
501:
502: -- Populate EAM Record attributes from input record
495: AHL_DEBUG_PUB.debug( 'parent_header_id: ' || TO_CHAR( p_workorder_rel_rec.parent_header_id ) );
496: AHL_DEBUG_PUB.debug( 'parent_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.parent_wip_entity_id ) );
497: AHL_DEBUG_PUB.debug( 'child_header_id: ' || TO_CHAR( p_workorder_rel_rec.child_header_id ) );
498: AHL_DEBUG_PUB.debug( 'child_wip_entity_id: ' || TO_CHAR( p_workorder_rel_rec.child_wip_entity_id ) );
499: AHL_DEBUG_PUB.debug( 'relationship_type: ' || TO_CHAR( p_workorder_rel_rec.relationship_type ) );
500: END IF;
501:
502: -- Populate EAM Record attributes from input record
503: x_eam_wo_relations_rec.batch_id := p_workorder_rel_rec.batch_id;
532: BEGIN
533:
534: -- Log Input Values
535: IF ( G_DEBUG = 'Y' ) THEN
536: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_operation_rec.dml_operation );
537: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_operation_rec.workorder_id ) );
538: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_operation_rec.wip_entity_id ) );
539: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_operation_rec.organization_id ) );
540: AHL_DEBUG_PUB.debug( 'operation_sequence_num: ' || TO_CHAR( p_operation_rec.operation_sequence_num) );
533:
534: -- Log Input Values
535: IF ( G_DEBUG = 'Y' ) THEN
536: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_operation_rec.dml_operation );
537: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_operation_rec.workorder_id ) );
538: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_operation_rec.wip_entity_id ) );
539: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_operation_rec.organization_id ) );
540: AHL_DEBUG_PUB.debug( 'operation_sequence_num: ' || TO_CHAR( p_operation_rec.operation_sequence_num) );
541: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_operation_rec.department_id) );
534: -- Log Input Values
535: IF ( G_DEBUG = 'Y' ) THEN
536: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_operation_rec.dml_operation );
537: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_operation_rec.workorder_id ) );
538: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_operation_rec.wip_entity_id ) );
539: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_operation_rec.organization_id ) );
540: AHL_DEBUG_PUB.debug( 'operation_sequence_num: ' || TO_CHAR( p_operation_rec.operation_sequence_num) );
541: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_operation_rec.department_id) );
542: AHL_DEBUG_PUB.debug( 'operation_description: ' || p_operation_rec.operation_description );
535: IF ( G_DEBUG = 'Y' ) THEN
536: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_operation_rec.dml_operation );
537: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_operation_rec.workorder_id ) );
538: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_operation_rec.wip_entity_id ) );
539: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_operation_rec.organization_id ) );
540: AHL_DEBUG_PUB.debug( 'operation_sequence_num: ' || TO_CHAR( p_operation_rec.operation_sequence_num) );
541: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_operation_rec.department_id) );
542: AHL_DEBUG_PUB.debug( 'operation_description: ' || p_operation_rec.operation_description );
543: AHL_DEBUG_PUB.debug( 'minimum_transfer_quantity: ' || TO_CHAR( p_operation_rec.minimum_transfer_quantity) );
536: AHL_DEBUG_PUB.debug( 'dml_operation: ' || p_operation_rec.dml_operation );
537: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_operation_rec.workorder_id ) );
538: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_operation_rec.wip_entity_id ) );
539: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_operation_rec.organization_id ) );
540: AHL_DEBUG_PUB.debug( 'operation_sequence_num: ' || TO_CHAR( p_operation_rec.operation_sequence_num) );
541: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_operation_rec.department_id) );
542: AHL_DEBUG_PUB.debug( 'operation_description: ' || p_operation_rec.operation_description );
543: AHL_DEBUG_PUB.debug( 'minimum_transfer_quantity: ' || TO_CHAR( p_operation_rec.minimum_transfer_quantity) );
544: AHL_DEBUG_PUB.debug( 'count_point_type: ' || TO_CHAR( p_operation_rec.count_point_type) );
537: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_operation_rec.workorder_id ) );
538: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_operation_rec.wip_entity_id ) );
539: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_operation_rec.organization_id ) );
540: AHL_DEBUG_PUB.debug( 'operation_sequence_num: ' || TO_CHAR( p_operation_rec.operation_sequence_num) );
541: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_operation_rec.department_id) );
542: AHL_DEBUG_PUB.debug( 'operation_description: ' || p_operation_rec.operation_description );
543: AHL_DEBUG_PUB.debug( 'minimum_transfer_quantity: ' || TO_CHAR( p_operation_rec.minimum_transfer_quantity) );
544: AHL_DEBUG_PUB.debug( 'count_point_type: ' || TO_CHAR( p_operation_rec.count_point_type) );
545: AHL_DEBUG_PUB.debug( 'scheduled_start_date: ' || TO_CHAR( p_operation_rec.scheduled_start_date, 'DD-MON-YYYY hh24:mi') );
538: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_operation_rec.wip_entity_id ) );
539: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_operation_rec.organization_id ) );
540: AHL_DEBUG_PUB.debug( 'operation_sequence_num: ' || TO_CHAR( p_operation_rec.operation_sequence_num) );
541: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_operation_rec.department_id) );
542: AHL_DEBUG_PUB.debug( 'operation_description: ' || p_operation_rec.operation_description );
543: AHL_DEBUG_PUB.debug( 'minimum_transfer_quantity: ' || TO_CHAR( p_operation_rec.minimum_transfer_quantity) );
544: AHL_DEBUG_PUB.debug( 'count_point_type: ' || TO_CHAR( p_operation_rec.count_point_type) );
545: AHL_DEBUG_PUB.debug( 'scheduled_start_date: ' || TO_CHAR( p_operation_rec.scheduled_start_date, 'DD-MON-YYYY hh24:mi') );
546: AHL_DEBUG_PUB.debug( 'scheduled_end_date: ' || TO_CHAR( p_operation_rec.scheduled_end_date, 'DD-MON-YYYY hh24:mi') );
539: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_operation_rec.organization_id ) );
540: AHL_DEBUG_PUB.debug( 'operation_sequence_num: ' || TO_CHAR( p_operation_rec.operation_sequence_num) );
541: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_operation_rec.department_id) );
542: AHL_DEBUG_PUB.debug( 'operation_description: ' || p_operation_rec.operation_description );
543: AHL_DEBUG_PUB.debug( 'minimum_transfer_quantity: ' || TO_CHAR( p_operation_rec.minimum_transfer_quantity) );
544: AHL_DEBUG_PUB.debug( 'count_point_type: ' || TO_CHAR( p_operation_rec.count_point_type) );
545: AHL_DEBUG_PUB.debug( 'scheduled_start_date: ' || TO_CHAR( p_operation_rec.scheduled_start_date, 'DD-MON-YYYY hh24:mi') );
546: AHL_DEBUG_PUB.debug( 'scheduled_end_date: ' || TO_CHAR( p_operation_rec.scheduled_end_date, 'DD-MON-YYYY hh24:mi') );
547: END IF;
540: AHL_DEBUG_PUB.debug( 'operation_sequence_num: ' || TO_CHAR( p_operation_rec.operation_sequence_num) );
541: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_operation_rec.department_id) );
542: AHL_DEBUG_PUB.debug( 'operation_description: ' || p_operation_rec.operation_description );
543: AHL_DEBUG_PUB.debug( 'minimum_transfer_quantity: ' || TO_CHAR( p_operation_rec.minimum_transfer_quantity) );
544: AHL_DEBUG_PUB.debug( 'count_point_type: ' || TO_CHAR( p_operation_rec.count_point_type) );
545: AHL_DEBUG_PUB.debug( 'scheduled_start_date: ' || TO_CHAR( p_operation_rec.scheduled_start_date, 'DD-MON-YYYY hh24:mi') );
546: AHL_DEBUG_PUB.debug( 'scheduled_end_date: ' || TO_CHAR( p_operation_rec.scheduled_end_date, 'DD-MON-YYYY hh24:mi') );
547: END IF;
548:
541: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_operation_rec.department_id) );
542: AHL_DEBUG_PUB.debug( 'operation_description: ' || p_operation_rec.operation_description );
543: AHL_DEBUG_PUB.debug( 'minimum_transfer_quantity: ' || TO_CHAR( p_operation_rec.minimum_transfer_quantity) );
544: AHL_DEBUG_PUB.debug( 'count_point_type: ' || TO_CHAR( p_operation_rec.count_point_type) );
545: AHL_DEBUG_PUB.debug( 'scheduled_start_date: ' || TO_CHAR( p_operation_rec.scheduled_start_date, 'DD-MON-YYYY hh24:mi') );
546: AHL_DEBUG_PUB.debug( 'scheduled_end_date: ' || TO_CHAR( p_operation_rec.scheduled_end_date, 'DD-MON-YYYY hh24:mi') );
547: END IF;
548:
549: -- Populate EAM Record attributes from input table
542: AHL_DEBUG_PUB.debug( 'operation_description: ' || p_operation_rec.operation_description );
543: AHL_DEBUG_PUB.debug( 'minimum_transfer_quantity: ' || TO_CHAR( p_operation_rec.minimum_transfer_quantity) );
544: AHL_DEBUG_PUB.debug( 'count_point_type: ' || TO_CHAR( p_operation_rec.count_point_type) );
545: AHL_DEBUG_PUB.debug( 'scheduled_start_date: ' || TO_CHAR( p_operation_rec.scheduled_start_date, 'DD-MON-YYYY hh24:mi') );
546: AHL_DEBUG_PUB.debug( 'scheduled_end_date: ' || TO_CHAR( p_operation_rec.scheduled_end_date, 'DD-MON-YYYY hh24:mi') );
547: END IF;
548:
549: -- Populate EAM Record attributes from input table
550: x_eam_op_rec.wip_entity_id := p_operation_rec.wip_entity_id;
602: BEGIN
603:
604: -- Log Input Values
605: IF ( G_DEBUG = 'Y' ) THEN
606: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_material_req_rec.operation_flag );
607: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_material_req_rec.workorder_id ) );
608: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_material_req_rec.wip_entity_id ) );
609: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_material_req_rec.organization_id ) );
610: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_material_req_rec.operation_sequence) );
603:
604: -- Log Input Values
605: IF ( G_DEBUG = 'Y' ) THEN
606: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_material_req_rec.operation_flag );
607: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_material_req_rec.workorder_id ) );
608: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_material_req_rec.wip_entity_id ) );
609: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_material_req_rec.organization_id ) );
610: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_material_req_rec.operation_sequence) );
611: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_material_req_rec.inventory_item_id) );
604: -- Log Input Values
605: IF ( G_DEBUG = 'Y' ) THEN
606: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_material_req_rec.operation_flag );
607: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_material_req_rec.workorder_id ) );
608: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_material_req_rec.wip_entity_id ) );
609: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_material_req_rec.organization_id ) );
610: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_material_req_rec.operation_sequence) );
611: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_material_req_rec.inventory_item_id) );
612: AHL_DEBUG_PUB.debug( 'requested_quantity: ' || TO_CHAR( p_material_req_rec.requested_quantity) );
605: IF ( G_DEBUG = 'Y' ) THEN
606: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_material_req_rec.operation_flag );
607: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_material_req_rec.workorder_id ) );
608: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_material_req_rec.wip_entity_id ) );
609: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_material_req_rec.organization_id ) );
610: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_material_req_rec.operation_sequence) );
611: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_material_req_rec.inventory_item_id) );
612: AHL_DEBUG_PUB.debug( 'requested_quantity: ' || TO_CHAR( p_material_req_rec.requested_quantity) );
613: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_material_req_rec.department_id) );
606: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_material_req_rec.operation_flag );
607: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_material_req_rec.workorder_id ) );
608: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_material_req_rec.wip_entity_id ) );
609: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_material_req_rec.organization_id ) );
610: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_material_req_rec.operation_sequence) );
611: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_material_req_rec.inventory_item_id) );
612: AHL_DEBUG_PUB.debug( 'requested_quantity: ' || TO_CHAR( p_material_req_rec.requested_quantity) );
613: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_material_req_rec.department_id) );
614: AHL_DEBUG_PUB.debug( 'requested_date: ' || TO_CHAR( p_material_req_rec.requested_date, 'DD-MON-YYYY hh24:mi') );
607: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_material_req_rec.workorder_id ) );
608: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_material_req_rec.wip_entity_id ) );
609: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_material_req_rec.organization_id ) );
610: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_material_req_rec.operation_sequence) );
611: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_material_req_rec.inventory_item_id) );
612: AHL_DEBUG_PUB.debug( 'requested_quantity: ' || TO_CHAR( p_material_req_rec.requested_quantity) );
613: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_material_req_rec.department_id) );
614: AHL_DEBUG_PUB.debug( 'requested_date: ' || TO_CHAR( p_material_req_rec.requested_date, 'DD-MON-YYYY hh24:mi') );
615: END IF;
608: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_material_req_rec.wip_entity_id ) );
609: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_material_req_rec.organization_id ) );
610: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_material_req_rec.operation_sequence) );
611: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_material_req_rec.inventory_item_id) );
612: AHL_DEBUG_PUB.debug( 'requested_quantity: ' || TO_CHAR( p_material_req_rec.requested_quantity) );
613: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_material_req_rec.department_id) );
614: AHL_DEBUG_PUB.debug( 'requested_date: ' || TO_CHAR( p_material_req_rec.requested_date, 'DD-MON-YYYY hh24:mi') );
615: END IF;
616:
609: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_material_req_rec.organization_id ) );
610: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_material_req_rec.operation_sequence) );
611: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_material_req_rec.inventory_item_id) );
612: AHL_DEBUG_PUB.debug( 'requested_quantity: ' || TO_CHAR( p_material_req_rec.requested_quantity) );
613: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_material_req_rec.department_id) );
614: AHL_DEBUG_PUB.debug( 'requested_date: ' || TO_CHAR( p_material_req_rec.requested_date, 'DD-MON-YYYY hh24:mi') );
615: END IF;
616:
617: -- Populate EAM Record attributes from input table
610: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_material_req_rec.operation_sequence) );
611: AHL_DEBUG_PUB.debug( 'inventory_item_id: ' || TO_CHAR( p_material_req_rec.inventory_item_id) );
612: AHL_DEBUG_PUB.debug( 'requested_quantity: ' || TO_CHAR( p_material_req_rec.requested_quantity) );
613: AHL_DEBUG_PUB.debug( 'department_id: ' || TO_CHAR( p_material_req_rec.department_id) );
614: AHL_DEBUG_PUB.debug( 'requested_date: ' || TO_CHAR( p_material_req_rec.requested_date, 'DD-MON-YYYY hh24:mi') );
615: END IF;
616:
617: -- Populate EAM Record attributes from input table
618: x_eam_mat_req_rec.wip_entity_id := p_material_req_rec.wip_entity_id;
665:
666: BEGIN
667: -- Log Input Values
668: IF ( G_DEBUG = 'Y' ) THEN
669: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_resource_req_rec.operation_flag );
670: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_req_rec.workorder_id ) );
671: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_req_rec.wip_entity_id ) );
672: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_req_rec.organization_id ) );
673: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_resource_req_rec.operation_seq_number) );
666: BEGIN
667: -- Log Input Values
668: IF ( G_DEBUG = 'Y' ) THEN
669: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_resource_req_rec.operation_flag );
670: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_req_rec.workorder_id ) );
671: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_req_rec.wip_entity_id ) );
672: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_req_rec.organization_id ) );
673: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_resource_req_rec.operation_seq_number) );
674: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_req_rec.resource_seq_number) );
667: -- Log Input Values
668: IF ( G_DEBUG = 'Y' ) THEN
669: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_resource_req_rec.operation_flag );
670: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_req_rec.workorder_id ) );
671: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_req_rec.wip_entity_id ) );
672: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_req_rec.organization_id ) );
673: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_resource_req_rec.operation_seq_number) );
674: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_req_rec.resource_seq_number) );
675: AHL_DEBUG_PUB.debug( 'resource_id: ' || TO_CHAR( p_resource_req_rec.resource_id) );
668: IF ( G_DEBUG = 'Y' ) THEN
669: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_resource_req_rec.operation_flag );
670: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_req_rec.workorder_id ) );
671: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_req_rec.wip_entity_id ) );
672: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_req_rec.organization_id ) );
673: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_resource_req_rec.operation_seq_number) );
674: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_req_rec.resource_seq_number) );
675: AHL_DEBUG_PUB.debug( 'resource_id: ' || TO_CHAR( p_resource_req_rec.resource_id) );
676: AHL_DEBUG_PUB.debug( 'uom_code: ' || p_resource_req_rec.uom_code );
669: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_resource_req_rec.operation_flag );
670: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_req_rec.workorder_id ) );
671: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_req_rec.wip_entity_id ) );
672: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_req_rec.organization_id ) );
673: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_resource_req_rec.operation_seq_number) );
674: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_req_rec.resource_seq_number) );
675: AHL_DEBUG_PUB.debug( 'resource_id: ' || TO_CHAR( p_resource_req_rec.resource_id) );
676: AHL_DEBUG_PUB.debug( 'uom_code: ' || p_resource_req_rec.uom_code );
677: AHL_DEBUG_PUB.debug( 'cost_basis_code: ' || TO_CHAR( p_resource_req_rec.cost_basis_code ) );
670: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_req_rec.workorder_id ) );
671: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_req_rec.wip_entity_id ) );
672: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_req_rec.organization_id ) );
673: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_resource_req_rec.operation_seq_number) );
674: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_req_rec.resource_seq_number) );
675: AHL_DEBUG_PUB.debug( 'resource_id: ' || TO_CHAR( p_resource_req_rec.resource_id) );
676: AHL_DEBUG_PUB.debug( 'uom_code: ' || p_resource_req_rec.uom_code );
677: AHL_DEBUG_PUB.debug( 'cost_basis_code: ' || TO_CHAR( p_resource_req_rec.cost_basis_code ) );
678: AHL_DEBUG_PUB.debug( 'charge_type_code: ' || TO_CHAR( p_resource_req_rec.charge_type_code) );
671: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_req_rec.wip_entity_id ) );
672: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_req_rec.organization_id ) );
673: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_resource_req_rec.operation_seq_number) );
674: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_req_rec.resource_seq_number) );
675: AHL_DEBUG_PUB.debug( 'resource_id: ' || TO_CHAR( p_resource_req_rec.resource_id) );
676: AHL_DEBUG_PUB.debug( 'uom_code: ' || p_resource_req_rec.uom_code );
677: AHL_DEBUG_PUB.debug( 'cost_basis_code: ' || TO_CHAR( p_resource_req_rec.cost_basis_code ) );
678: AHL_DEBUG_PUB.debug( 'charge_type_code: ' || TO_CHAR( p_resource_req_rec.charge_type_code) );
679: AHL_DEBUG_PUB.debug( 'std_rate_flag_code: ' || TO_CHAR( p_resource_req_rec.std_rate_flag_code) );
672: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_req_rec.organization_id ) );
673: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_resource_req_rec.operation_seq_number) );
674: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_req_rec.resource_seq_number) );
675: AHL_DEBUG_PUB.debug( 'resource_id: ' || TO_CHAR( p_resource_req_rec.resource_id) );
676: AHL_DEBUG_PUB.debug( 'uom_code: ' || p_resource_req_rec.uom_code );
677: AHL_DEBUG_PUB.debug( 'cost_basis_code: ' || TO_CHAR( p_resource_req_rec.cost_basis_code ) );
678: AHL_DEBUG_PUB.debug( 'charge_type_code: ' || TO_CHAR( p_resource_req_rec.charge_type_code) );
679: AHL_DEBUG_PUB.debug( 'std_rate_flag_code: ' || TO_CHAR( p_resource_req_rec.std_rate_flag_code) );
680: AHL_DEBUG_PUB.debug( 'scheduled_type_code: ' || TO_CHAR( p_resource_req_rec.scheduled_type_code) );
673: AHL_DEBUG_PUB.debug( 'operation_sequence: ' || TO_CHAR( p_resource_req_rec.operation_seq_number) );
674: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_req_rec.resource_seq_number) );
675: AHL_DEBUG_PUB.debug( 'resource_id: ' || TO_CHAR( p_resource_req_rec.resource_id) );
676: AHL_DEBUG_PUB.debug( 'uom_code: ' || p_resource_req_rec.uom_code );
677: AHL_DEBUG_PUB.debug( 'cost_basis_code: ' || TO_CHAR( p_resource_req_rec.cost_basis_code ) );
678: AHL_DEBUG_PUB.debug( 'charge_type_code: ' || TO_CHAR( p_resource_req_rec.charge_type_code) );
679: AHL_DEBUG_PUB.debug( 'std_rate_flag_code: ' || TO_CHAR( p_resource_req_rec.std_rate_flag_code) );
680: AHL_DEBUG_PUB.debug( 'scheduled_type_code: ' || TO_CHAR( p_resource_req_rec.scheduled_type_code) );
681: AHL_DEBUG_PUB.debug( 'applied_num: ' || TO_CHAR( p_resource_req_rec.applied_num) );
674: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_req_rec.resource_seq_number) );
675: AHL_DEBUG_PUB.debug( 'resource_id: ' || TO_CHAR( p_resource_req_rec.resource_id) );
676: AHL_DEBUG_PUB.debug( 'uom_code: ' || p_resource_req_rec.uom_code );
677: AHL_DEBUG_PUB.debug( 'cost_basis_code: ' || TO_CHAR( p_resource_req_rec.cost_basis_code ) );
678: AHL_DEBUG_PUB.debug( 'charge_type_code: ' || TO_CHAR( p_resource_req_rec.charge_type_code) );
679: AHL_DEBUG_PUB.debug( 'std_rate_flag_code: ' || TO_CHAR( p_resource_req_rec.std_rate_flag_code) );
680: AHL_DEBUG_PUB.debug( 'scheduled_type_code: ' || TO_CHAR( p_resource_req_rec.scheduled_type_code) );
681: AHL_DEBUG_PUB.debug( 'applied_num: ' || TO_CHAR( p_resource_req_rec.applied_num) );
682: AHL_DEBUG_PUB.debug( 'open_num: ' || TO_CHAR( p_resource_req_rec.open_num) );
675: AHL_DEBUG_PUB.debug( 'resource_id: ' || TO_CHAR( p_resource_req_rec.resource_id) );
676: AHL_DEBUG_PUB.debug( 'uom_code: ' || p_resource_req_rec.uom_code );
677: AHL_DEBUG_PUB.debug( 'cost_basis_code: ' || TO_CHAR( p_resource_req_rec.cost_basis_code ) );
678: AHL_DEBUG_PUB.debug( 'charge_type_code: ' || TO_CHAR( p_resource_req_rec.charge_type_code) );
679: AHL_DEBUG_PUB.debug( 'std_rate_flag_code: ' || TO_CHAR( p_resource_req_rec.std_rate_flag_code) );
680: AHL_DEBUG_PUB.debug( 'scheduled_type_code: ' || TO_CHAR( p_resource_req_rec.scheduled_type_code) );
681: AHL_DEBUG_PUB.debug( 'applied_num: ' || TO_CHAR( p_resource_req_rec.applied_num) );
682: AHL_DEBUG_PUB.debug( 'open_num: ' || TO_CHAR( p_resource_req_rec.open_num) );
683: AHL_DEBUG_PUB.debug( 'req_start_date: ' || TO_CHAR( p_resource_req_rec.req_start_date, 'DD-MON-YYYY hh24:mi') );
676: AHL_DEBUG_PUB.debug( 'uom_code: ' || p_resource_req_rec.uom_code );
677: AHL_DEBUG_PUB.debug( 'cost_basis_code: ' || TO_CHAR( p_resource_req_rec.cost_basis_code ) );
678: AHL_DEBUG_PUB.debug( 'charge_type_code: ' || TO_CHAR( p_resource_req_rec.charge_type_code) );
679: AHL_DEBUG_PUB.debug( 'std_rate_flag_code: ' || TO_CHAR( p_resource_req_rec.std_rate_flag_code) );
680: AHL_DEBUG_PUB.debug( 'scheduled_type_code: ' || TO_CHAR( p_resource_req_rec.scheduled_type_code) );
681: AHL_DEBUG_PUB.debug( 'applied_num: ' || TO_CHAR( p_resource_req_rec.applied_num) );
682: AHL_DEBUG_PUB.debug( 'open_num: ' || TO_CHAR( p_resource_req_rec.open_num) );
683: AHL_DEBUG_PUB.debug( 'req_start_date: ' || TO_CHAR( p_resource_req_rec.req_start_date, 'DD-MON-YYYY hh24:mi') );
684: AHL_DEBUG_PUB.debug( 'req_end_date: ' || TO_CHAR( p_resource_req_rec.req_end_date, 'DD-MON-YYYY hh24:mi') );
677: AHL_DEBUG_PUB.debug( 'cost_basis_code: ' || TO_CHAR( p_resource_req_rec.cost_basis_code ) );
678: AHL_DEBUG_PUB.debug( 'charge_type_code: ' || TO_CHAR( p_resource_req_rec.charge_type_code) );
679: AHL_DEBUG_PUB.debug( 'std_rate_flag_code: ' || TO_CHAR( p_resource_req_rec.std_rate_flag_code) );
680: AHL_DEBUG_PUB.debug( 'scheduled_type_code: ' || TO_CHAR( p_resource_req_rec.scheduled_type_code) );
681: AHL_DEBUG_PUB.debug( 'applied_num: ' || TO_CHAR( p_resource_req_rec.applied_num) );
682: AHL_DEBUG_PUB.debug( 'open_num: ' || TO_CHAR( p_resource_req_rec.open_num) );
683: AHL_DEBUG_PUB.debug( 'req_start_date: ' || TO_CHAR( p_resource_req_rec.req_start_date, 'DD-MON-YYYY hh24:mi') );
684: AHL_DEBUG_PUB.debug( 'req_end_date: ' || TO_CHAR( p_resource_req_rec.req_end_date, 'DD-MON-YYYY hh24:mi') );
685: AHL_DEBUG_PUB.debug( 'quantity: ' || TO_CHAR( p_resource_req_rec.quantity) );
678: AHL_DEBUG_PUB.debug( 'charge_type_code: ' || TO_CHAR( p_resource_req_rec.charge_type_code) );
679: AHL_DEBUG_PUB.debug( 'std_rate_flag_code: ' || TO_CHAR( p_resource_req_rec.std_rate_flag_code) );
680: AHL_DEBUG_PUB.debug( 'scheduled_type_code: ' || TO_CHAR( p_resource_req_rec.scheduled_type_code) );
681: AHL_DEBUG_PUB.debug( 'applied_num: ' || TO_CHAR( p_resource_req_rec.applied_num) );
682: AHL_DEBUG_PUB.debug( 'open_num: ' || TO_CHAR( p_resource_req_rec.open_num) );
683: AHL_DEBUG_PUB.debug( 'req_start_date: ' || TO_CHAR( p_resource_req_rec.req_start_date, 'DD-MON-YYYY hh24:mi') );
684: AHL_DEBUG_PUB.debug( 'req_end_date: ' || TO_CHAR( p_resource_req_rec.req_end_date, 'DD-MON-YYYY hh24:mi') );
685: AHL_DEBUG_PUB.debug( 'quantity: ' || TO_CHAR( p_resource_req_rec.quantity) );
686: AHL_DEBUG_PUB.debug( 'duration: ' || TO_CHAR( p_resource_req_rec.duration) );
679: AHL_DEBUG_PUB.debug( 'std_rate_flag_code: ' || TO_CHAR( p_resource_req_rec.std_rate_flag_code) );
680: AHL_DEBUG_PUB.debug( 'scheduled_type_code: ' || TO_CHAR( p_resource_req_rec.scheduled_type_code) );
681: AHL_DEBUG_PUB.debug( 'applied_num: ' || TO_CHAR( p_resource_req_rec.applied_num) );
682: AHL_DEBUG_PUB.debug( 'open_num: ' || TO_CHAR( p_resource_req_rec.open_num) );
683: AHL_DEBUG_PUB.debug( 'req_start_date: ' || TO_CHAR( p_resource_req_rec.req_start_date, 'DD-MON-YYYY hh24:mi') );
684: AHL_DEBUG_PUB.debug( 'req_end_date: ' || TO_CHAR( p_resource_req_rec.req_end_date, 'DD-MON-YYYY hh24:mi') );
685: AHL_DEBUG_PUB.debug( 'quantity: ' || TO_CHAR( p_resource_req_rec.quantity) );
686: AHL_DEBUG_PUB.debug( 'duration: ' || TO_CHAR( p_resource_req_rec.duration) );
687: END IF;
680: AHL_DEBUG_PUB.debug( 'scheduled_type_code: ' || TO_CHAR( p_resource_req_rec.scheduled_type_code) );
681: AHL_DEBUG_PUB.debug( 'applied_num: ' || TO_CHAR( p_resource_req_rec.applied_num) );
682: AHL_DEBUG_PUB.debug( 'open_num: ' || TO_CHAR( p_resource_req_rec.open_num) );
683: AHL_DEBUG_PUB.debug( 'req_start_date: ' || TO_CHAR( p_resource_req_rec.req_start_date, 'DD-MON-YYYY hh24:mi') );
684: AHL_DEBUG_PUB.debug( 'req_end_date: ' || TO_CHAR( p_resource_req_rec.req_end_date, 'DD-MON-YYYY hh24:mi') );
685: AHL_DEBUG_PUB.debug( 'quantity: ' || TO_CHAR( p_resource_req_rec.quantity) );
686: AHL_DEBUG_PUB.debug( 'duration: ' || TO_CHAR( p_resource_req_rec.duration) );
687: END IF;
688:
681: AHL_DEBUG_PUB.debug( 'applied_num: ' || TO_CHAR( p_resource_req_rec.applied_num) );
682: AHL_DEBUG_PUB.debug( 'open_num: ' || TO_CHAR( p_resource_req_rec.open_num) );
683: AHL_DEBUG_PUB.debug( 'req_start_date: ' || TO_CHAR( p_resource_req_rec.req_start_date, 'DD-MON-YYYY hh24:mi') );
684: AHL_DEBUG_PUB.debug( 'req_end_date: ' || TO_CHAR( p_resource_req_rec.req_end_date, 'DD-MON-YYYY hh24:mi') );
685: AHL_DEBUG_PUB.debug( 'quantity: ' || TO_CHAR( p_resource_req_rec.quantity) );
686: AHL_DEBUG_PUB.debug( 'duration: ' || TO_CHAR( p_resource_req_rec.duration) );
687: END IF;
688:
689: -- Populate EAM Record attributes from input table
682: AHL_DEBUG_PUB.debug( 'open_num: ' || TO_CHAR( p_resource_req_rec.open_num) );
683: AHL_DEBUG_PUB.debug( 'req_start_date: ' || TO_CHAR( p_resource_req_rec.req_start_date, 'DD-MON-YYYY hh24:mi') );
684: AHL_DEBUG_PUB.debug( 'req_end_date: ' || TO_CHAR( p_resource_req_rec.req_end_date, 'DD-MON-YYYY hh24:mi') );
685: AHL_DEBUG_PUB.debug( 'quantity: ' || TO_CHAR( p_resource_req_rec.quantity) );
686: AHL_DEBUG_PUB.debug( 'duration: ' || TO_CHAR( p_resource_req_rec.duration) );
687: END IF;
688:
689: -- Populate EAM Record attributes from input table
690: x_eam_res_rec.wip_entity_id := p_resource_req_rec.wip_entity_id;
737:
738: BEGIN
739: -- Log Input Values
740: IF ( G_DEBUG = 'Y' ) THEN
741: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_resource_assign_rec.operation_flag );
742: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_assign_rec.workorder_id ) );
743: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_assign_rec.wip_entity_id ) );
744: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_assign_rec.organization_id ) );
745: AHL_DEBUG_PUB.debug( 'operation_seq_number: ' || TO_CHAR( p_resource_assign_rec.operation_seq_number) );
738: BEGIN
739: -- Log Input Values
740: IF ( G_DEBUG = 'Y' ) THEN
741: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_resource_assign_rec.operation_flag );
742: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_assign_rec.workorder_id ) );
743: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_assign_rec.wip_entity_id ) );
744: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_assign_rec.organization_id ) );
745: AHL_DEBUG_PUB.debug( 'operation_seq_number: ' || TO_CHAR( p_resource_assign_rec.operation_seq_number) );
746: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_assign_rec.resource_seq_number) );
739: -- Log Input Values
740: IF ( G_DEBUG = 'Y' ) THEN
741: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_resource_assign_rec.operation_flag );
742: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_assign_rec.workorder_id ) );
743: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_assign_rec.wip_entity_id ) );
744: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_assign_rec.organization_id ) );
745: AHL_DEBUG_PUB.debug( 'operation_seq_number: ' || TO_CHAR( p_resource_assign_rec.operation_seq_number) );
746: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_assign_rec.resource_seq_number) );
747: AHL_DEBUG_PUB.debug( 'instance_id: ' || TO_CHAR( p_resource_assign_rec.instance_id) );
740: IF ( G_DEBUG = 'Y' ) THEN
741: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_resource_assign_rec.operation_flag );
742: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_assign_rec.workorder_id ) );
743: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_assign_rec.wip_entity_id ) );
744: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_assign_rec.organization_id ) );
745: AHL_DEBUG_PUB.debug( 'operation_seq_number: ' || TO_CHAR( p_resource_assign_rec.operation_seq_number) );
746: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_assign_rec.resource_seq_number) );
747: AHL_DEBUG_PUB.debug( 'instance_id: ' || TO_CHAR( p_resource_assign_rec.instance_id) );
748: AHL_DEBUG_PUB.debug( 'serial_number: ' || p_resource_assign_rec.serial_number );
741: AHL_DEBUG_PUB.debug( 'operation_flag : ' || p_resource_assign_rec.operation_flag );
742: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_assign_rec.workorder_id ) );
743: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_assign_rec.wip_entity_id ) );
744: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_assign_rec.organization_id ) );
745: AHL_DEBUG_PUB.debug( 'operation_seq_number: ' || TO_CHAR( p_resource_assign_rec.operation_seq_number) );
746: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_assign_rec.resource_seq_number) );
747: AHL_DEBUG_PUB.debug( 'instance_id: ' || TO_CHAR( p_resource_assign_rec.instance_id) );
748: AHL_DEBUG_PUB.debug( 'serial_number: ' || p_resource_assign_rec.serial_number );
749: AHL_DEBUG_PUB.debug( 'assign_start_date: ' || TO_CHAR( p_resource_assign_rec.assign_start_date, 'DD-MON-YYYY hh24:mi') );
742: AHL_DEBUG_PUB.debug( 'workorder_id: ' || TO_CHAR( p_resource_assign_rec.workorder_id ) );
743: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_assign_rec.wip_entity_id ) );
744: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_assign_rec.organization_id ) );
745: AHL_DEBUG_PUB.debug( 'operation_seq_number: ' || TO_CHAR( p_resource_assign_rec.operation_seq_number) );
746: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_assign_rec.resource_seq_number) );
747: AHL_DEBUG_PUB.debug( 'instance_id: ' || TO_CHAR( p_resource_assign_rec.instance_id) );
748: AHL_DEBUG_PUB.debug( 'serial_number: ' || p_resource_assign_rec.serial_number );
749: AHL_DEBUG_PUB.debug( 'assign_start_date: ' || TO_CHAR( p_resource_assign_rec.assign_start_date, 'DD-MON-YYYY hh24:mi') );
750: AHL_DEBUG_PUB.debug( 'assign_end_date: ' || TO_CHAR( p_resource_assign_rec.assign_end_date, 'DD-MON-YYYY hh24:mi') );
743: AHL_DEBUG_PUB.debug( 'wip_entity_id: ' || TO_CHAR( p_resource_assign_rec.wip_entity_id ) );
744: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_assign_rec.organization_id ) );
745: AHL_DEBUG_PUB.debug( 'operation_seq_number: ' || TO_CHAR( p_resource_assign_rec.operation_seq_number) );
746: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_assign_rec.resource_seq_number) );
747: AHL_DEBUG_PUB.debug( 'instance_id: ' || TO_CHAR( p_resource_assign_rec.instance_id) );
748: AHL_DEBUG_PUB.debug( 'serial_number: ' || p_resource_assign_rec.serial_number );
749: AHL_DEBUG_PUB.debug( 'assign_start_date: ' || TO_CHAR( p_resource_assign_rec.assign_start_date, 'DD-MON-YYYY hh24:mi') );
750: AHL_DEBUG_PUB.debug( 'assign_end_date: ' || TO_CHAR( p_resource_assign_rec.assign_end_date, 'DD-MON-YYYY hh24:mi') );
751: END IF;
744: AHL_DEBUG_PUB.debug( 'organization_id: ' || TO_CHAR( p_resource_assign_rec.organization_id ) );
745: AHL_DEBUG_PUB.debug( 'operation_seq_number: ' || TO_CHAR( p_resource_assign_rec.operation_seq_number) );
746: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_assign_rec.resource_seq_number) );
747: AHL_DEBUG_PUB.debug( 'instance_id: ' || TO_CHAR( p_resource_assign_rec.instance_id) );
748: AHL_DEBUG_PUB.debug( 'serial_number: ' || p_resource_assign_rec.serial_number );
749: AHL_DEBUG_PUB.debug( 'assign_start_date: ' || TO_CHAR( p_resource_assign_rec.assign_start_date, 'DD-MON-YYYY hh24:mi') );
750: AHL_DEBUG_PUB.debug( 'assign_end_date: ' || TO_CHAR( p_resource_assign_rec.assign_end_date, 'DD-MON-YYYY hh24:mi') );
751: END IF;
752:
745: AHL_DEBUG_PUB.debug( 'operation_seq_number: ' || TO_CHAR( p_resource_assign_rec.operation_seq_number) );
746: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_assign_rec.resource_seq_number) );
747: AHL_DEBUG_PUB.debug( 'instance_id: ' || TO_CHAR( p_resource_assign_rec.instance_id) );
748: AHL_DEBUG_PUB.debug( 'serial_number: ' || p_resource_assign_rec.serial_number );
749: AHL_DEBUG_PUB.debug( 'assign_start_date: ' || TO_CHAR( p_resource_assign_rec.assign_start_date, 'DD-MON-YYYY hh24:mi') );
750: AHL_DEBUG_PUB.debug( 'assign_end_date: ' || TO_CHAR( p_resource_assign_rec.assign_end_date, 'DD-MON-YYYY hh24:mi') );
751: END IF;
752:
753: -- Populate EAM Record attributes from input table
746: AHL_DEBUG_PUB.debug( 'resource_seq_number: ' || TO_CHAR( p_resource_assign_rec.resource_seq_number) );
747: AHL_DEBUG_PUB.debug( 'instance_id: ' || TO_CHAR( p_resource_assign_rec.instance_id) );
748: AHL_DEBUG_PUB.debug( 'serial_number: ' || p_resource_assign_rec.serial_number );
749: AHL_DEBUG_PUB.debug( 'assign_start_date: ' || TO_CHAR( p_resource_assign_rec.assign_start_date, 'DD-MON-YYYY hh24:mi') );
750: AHL_DEBUG_PUB.debug( 'assign_end_date: ' || TO_CHAR( p_resource_assign_rec.assign_end_date, 'DD-MON-YYYY hh24:mi') );
751: END IF;
752:
753: -- Populate EAM Record attributes from input table
754: x_eam_res_inst_rec.wip_entity_id := p_resource_assign_rec.wip_entity_id;
829: BEGIN
830:
831: -- Enable Debug
832: IF ( G_DEBUG = 'Y' ) THEN
833: AHL_DEBUG_PUB.enable_debug;
834: END IF;
835:
836: -- Initialize API return status to success
837: x_return_status := FND_API.G_RET_STS_SUCCESS;
839: -- Standard Start of API savepoint
840: SAVEPOINT create_eam_workorder_PVT;
841:
842: IF ( G_DEBUG = 'Y' ) THEN
843: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
844: AHL_DEBUG_PUB.debug( 'Job Header Record: ' );
845: END IF;
846:
847: -- Map all input AHL Job Header record attributes to the
840: SAVEPOINT create_eam_workorder_PVT;
841:
842: IF ( G_DEBUG = 'Y' ) THEN
843: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
844: AHL_DEBUG_PUB.debug( 'Job Header Record: ' );
845: END IF;
846:
847: -- Map all input AHL Job Header record attributes to the
848: -- corresponding EAM Job Header record attributes.
852: x_eam_wo_rec => l_eam_wo_rec
853: );
854:
855: IF ( G_DEBUG = 'Y' ) THEN
856: AHL_DEBUG_PUB.debug( 'Job Header Record Mapping Complete' );
857: END IF;
858:
859: -- Map all input AHL Operation record attributes to the
860: -- corresponding EAM Operation record attributes.
860: -- corresponding EAM Operation record attributes.
861: FOR i IN p_operation_tbl.FIRST..p_operation_tbl.LAST LOOP
862:
863: IF ( G_DEBUG = 'Y' ) THEN
864: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
865: AHL_DEBUG_PUB.debug( 'Operation Record Number : ' || i );
866: END IF;
867:
868: map_ahl_eam_op_rec
861: FOR i IN p_operation_tbl.FIRST..p_operation_tbl.LAST LOOP
862:
863: IF ( G_DEBUG = 'Y' ) THEN
864: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
865: AHL_DEBUG_PUB.debug( 'Operation Record Number : ' || i );
866: END IF;
867:
868: map_ahl_eam_op_rec
869: (
873:
874: END LOOP;
875:
876: IF ( G_DEBUG = 'Y' ) THEN
877: AHL_DEBUG_PUB.debug( 'Operations Record Mapping Complete' );
878: END IF;
879:
880: -- Map all input AHL Material Requirement record attributes to the
881: -- corresponding EAM Material Requirement record attributes.
881: -- corresponding EAM Material Requirement record attributes.
882: IF ( p_material_req_tbl.COUNT > 0 ) THEN
883: FOR i IN p_material_req_tbl.FIRST..p_material_req_tbl.LAST LOOP
884: IF ( G_DEBUG = 'Y' ) THEN
885: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
886: AHL_DEBUG_PUB.debug( 'Material Requirement Record Number : ' || i );
887: END IF;
888:
889: map_ahl_eam_mat_rec
882: IF ( p_material_req_tbl.COUNT > 0 ) THEN
883: FOR i IN p_material_req_tbl.FIRST..p_material_req_tbl.LAST LOOP
884: IF ( G_DEBUG = 'Y' ) THEN
885: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
886: AHL_DEBUG_PUB.debug( 'Material Requirement Record Number : ' || i );
887: END IF;
888:
889: map_ahl_eam_mat_rec
890: (
894:
895: END LOOP;
896:
897: IF ( G_DEBUG = 'Y' ) THEN
898: AHL_DEBUG_PUB.debug( 'Material Requirements Record Mapping Complete' );
899: END IF;
900:
901: END IF;
902:
905: IF ( p_resource_req_tbl.COUNT > 0 ) THEN
906: FOR i IN p_resource_req_tbl.FIRST..p_resource_req_tbl.LAST LOOP
907:
908: IF ( G_DEBUG = 'Y' ) THEN
909: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
910: AHL_DEBUG_PUB.debug( 'Resource Requirement Record Number : ' || i );
911: END IF;
912:
913: map_ahl_eam_res_rec
906: FOR i IN p_resource_req_tbl.FIRST..p_resource_req_tbl.LAST LOOP
907:
908: IF ( G_DEBUG = 'Y' ) THEN
909: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
910: AHL_DEBUG_PUB.debug( 'Resource Requirement Record Number : ' || i );
911: END IF;
912:
913: map_ahl_eam_res_rec
914: (
918:
919: END LOOP;
920:
921: IF ( G_DEBUG = 'Y' ) THEN
922: AHL_DEBUG_PUB.debug( 'Resource Requirement Record Mapping Complete' );
923: END IF;
924:
925: END IF;
926:
935: );
936: END IF;
937:
938: IF ( G_DEBUG = 'Y' ) THEN
939: AHL_DEBUG_PUB.debug( 'Invoking EAM process_wo API' );
940: END IF;
941:
942: -- Invoke EAM BO API for Updating the Job
943: EAM_PROCESS_WO_PUB.process_wo
973: );
974:
975: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
976: IF ( G_DEBUG = 'Y' ) THEN
977: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
978: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
979: END IF;
980:
981: RAISE FND_API.G_EXC_ERROR;
974:
975: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
976: IF ( G_DEBUG = 'Y' ) THEN
977: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
978: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
979: END IF;
980:
981: RAISE FND_API.G_EXC_ERROR;
982: ELSE
980:
981: RAISE FND_API.G_EXC_ERROR;
982: ELSE
983: IF ( G_DEBUG = 'Y' ) THEN
984: AHL_DEBUG_PUB.debug( 'EAM process_wo API Successful' );
985: END IF;
986:
987: p_x_workorder_rec.wip_entity_id := l_out_eam_wo_rec.wip_entity_id;
988:
986:
987: p_x_workorder_rec.wip_entity_id := l_out_eam_wo_rec.wip_entity_id;
988:
989: IF ( G_DEBUG = 'Y' ) THEN
990: AHL_DEBUG_PUB.debug( 'New wip_entity_id:' || TO_CHAR( p_x_workorder_rec.wip_entity_id ) );
991: END IF;
992:
993: -- Perform the Commit (if requested)
994: IF FND_API.to_boolean( p_commit ) THEN
997: END IF;
998:
999: -- Disable debug (if enabled)
1000: IF ( G_DEBUG = 'Y' ) THEN
1001: AHL_DEBUG_PUB.disable_debug;
1002: END IF;
1003:
1004: EXCEPTION
1005:
1013: p_data => x_msg_data
1014: );
1015:
1016: IF ( G_DEBUG = 'Y' ) THEN
1017: AHL_DEBUG_PUB.disable_debug;
1018: END IF;
1019:
1020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1021: ROLLBACK TO create_eam_workorder_PVT;
1027: p_data => x_msg_data
1028: );
1029:
1030: IF ( G_DEBUG = 'Y' ) THEN
1031: AHL_DEBUG_PUB.disable_debug;
1032: END IF;
1033:
1034: WHEN OTHERS THEN
1035: ROLLBACK TO create_eam_workorder_PVT;
1050: p_data => x_msg_data
1051: );
1052:
1053: IF ( G_DEBUG = 'Y' ) THEN
1054: AHL_DEBUG_PUB.disable_debug;
1055: END IF;
1056: END create_eam_workorder;
1057:
1058: PROCEDURE update_job_operations
1106: BEGIN
1107:
1108: -- Enable Debug
1109: IF ( G_DEBUG = 'Y' ) THEN
1110: AHL_DEBUG_PUB.enable_debug;
1111: END IF;
1112:
1113: -- Initialize API return status to success
1114: x_return_status := FND_API.G_RET_STS_SUCCESS;
1120: -- corresponding EAM Job Header record attributes.
1121: IF ( p_workorder_rec.workorder_id IS NOT NULL ) THEN
1122:
1123: IF ( G_DEBUG = 'Y' ) THEN
1124: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1125: AHL_DEBUG_PUB.debug( 'Job Header Record: ' );
1126: END IF;
1127:
1128: map_ahl_eam_wo_rec
1121: IF ( p_workorder_rec.workorder_id IS NOT NULL ) THEN
1122:
1123: IF ( G_DEBUG = 'Y' ) THEN
1124: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1125: AHL_DEBUG_PUB.debug( 'Job Header Record: ' );
1126: END IF;
1127:
1128: map_ahl_eam_wo_rec
1129: (
1138: IF ( p_operation_tbl.COUNT > 0 ) THEN
1139: FOR i IN p_operation_tbl.FIRST..p_operation_tbl.LAST LOOP
1140:
1141: IF ( G_DEBUG = 'Y' ) THEN
1142: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1143: AHL_DEBUG_PUB.debug( 'Operation Record Number : ' || i );
1144: END IF;
1145:
1146: map_ahl_eam_op_rec
1139: FOR i IN p_operation_tbl.FIRST..p_operation_tbl.LAST LOOP
1140:
1141: IF ( G_DEBUG = 'Y' ) THEN
1142: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1143: AHL_DEBUG_PUB.debug( 'Operation Record Number : ' || i );
1144: END IF;
1145:
1146: map_ahl_eam_op_rec
1147: (
1157: IF ( p_material_req_tbl.COUNT > 0 ) THEN
1158: FOR i IN p_material_req_tbl.FIRST..p_material_req_tbl.LAST LOOP
1159:
1160: IF ( G_DEBUG = 'Y' ) THEN
1161: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1162: AHL_DEBUG_PUB.debug( 'Material Requirement Record Number : ' || i );
1163: END IF;
1164:
1165: map_ahl_eam_mat_rec
1158: FOR i IN p_material_req_tbl.FIRST..p_material_req_tbl.LAST LOOP
1159:
1160: IF ( G_DEBUG = 'Y' ) THEN
1161: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1162: AHL_DEBUG_PUB.debug( 'Material Requirement Record Number : ' || i );
1163: END IF;
1164:
1165: map_ahl_eam_mat_rec
1166: (
1176: IF ( p_resource_req_tbl.COUNT > 0 ) THEN
1177: FOR i IN p_resource_req_tbl.FIRST..p_resource_req_tbl.LAST LOOP
1178:
1179: IF ( G_DEBUG = 'Y' ) THEN
1180: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1181: AHL_DEBUG_PUB.debug( 'Resource Requirement Record Number : ' || i );
1182: END IF;
1183:
1184: map_ahl_eam_res_rec
1177: FOR i IN p_resource_req_tbl.FIRST..p_resource_req_tbl.LAST LOOP
1178:
1179: IF ( G_DEBUG = 'Y' ) THEN
1180: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1181: AHL_DEBUG_PUB.debug( 'Resource Requirement Record Number : ' || i );
1182: END IF;
1183:
1184: map_ahl_eam_res_rec
1185: (
1201: );
1202: END IF;
1203:
1204: IF ( G_DEBUG = 'Y' ) THEN
1205: AHL_DEBUG_PUB.debug( 'Invoking EAM process_wo API' );
1206: END IF;
1207:
1208: -- Invoke EAM BO API for Updating the Job
1209: EAM_PROCESS_WO_PUB.process_wo
1239: );
1240:
1241: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1242: IF ( G_DEBUG = 'Y' ) THEN
1243: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1244: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1245: END IF;
1246:
1247: RAISE FND_API.G_EXC_ERROR;
1240:
1241: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1242: IF ( G_DEBUG = 'Y' ) THEN
1243: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1244: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1245: END IF;
1246:
1247: RAISE FND_API.G_EXC_ERROR;
1248:
1254: END IF;
1255:
1256: -- Disable debug (if enabled)
1257: IF ( G_DEBUG = 'Y' ) THEN
1258: AHL_DEBUG_PUB.disable_debug;
1259: END IF;
1260:
1261: EXCEPTION
1262:
1270: p_data => x_msg_data
1271: );
1272:
1273: IF ( G_DEBUG = 'Y' ) THEN
1274: AHL_DEBUG_PUB.disable_debug;
1275: END IF;
1276:
1277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1278: ROLLBACK TO update_job_operations_PVT;
1284: p_data => x_msg_data
1285: );
1286:
1287: IF ( G_DEBUG = 'Y' ) THEN
1288: AHL_DEBUG_PUB.disable_debug;
1289: END IF;
1290:
1291: WHEN OTHERS THEN
1292: ROLLBACK TO update_job_operations_PVT;
1307: p_data => x_msg_data
1308: );
1309:
1310: IF ( G_DEBUG = 'Y' ) THEN
1311: AHL_DEBUG_PUB.disable_debug;
1312: END IF;
1313:
1314: END update_job_operations;
1315:
1361: BEGIN
1362:
1363: -- Enable Debug
1364: IF ( G_DEBUG = 'Y' ) THEN
1365: AHL_DEBUG_PUB.enable_debug;
1366: END IF;
1367:
1368: -- Initialize API return status to success
1369: x_return_status := FND_API.G_RET_STS_SUCCESS;
1375: -- corresponding EAM Material Requirement record attributes.
1376: FOR i IN p_material_req_tbl.FIRST..p_material_req_tbl.LAST LOOP
1377:
1378: IF ( G_DEBUG = 'Y' ) THEN
1379: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1380: AHL_DEBUG_PUB.debug( 'Material Requirement Record Number : ' || i );
1381: END IF;
1382:
1383: map_ahl_eam_mat_rec
1376: FOR i IN p_material_req_tbl.FIRST..p_material_req_tbl.LAST LOOP
1377:
1378: IF ( G_DEBUG = 'Y' ) THEN
1379: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1380: AHL_DEBUG_PUB.debug( 'Material Requirement Record Number : ' || i );
1381: END IF;
1382:
1383: map_ahl_eam_mat_rec
1384: (
1399: );
1400: END IF;
1401:
1402: IF ( G_DEBUG = 'Y' ) THEN
1403: AHL_DEBUG_PUB.debug( 'Invoking EAM process_wo API' );
1404: END IF;
1405:
1406: -- Invoke EAM BO API for Updating the Job
1407: EAM_PROCESS_WO_PUB.process_wo
1437: );
1438:
1439: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1440: IF ( G_DEBUG = 'Y' ) THEN
1441: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1442: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1443: END IF;
1444:
1445: RAISE FND_API.G_EXC_ERROR;
1438:
1439: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1440: IF ( G_DEBUG = 'Y' ) THEN
1441: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1442: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1443: END IF;
1444:
1445: RAISE FND_API.G_EXC_ERROR;
1446: END IF;
1451: END IF;
1452:
1453: -- Disable debug (if enabled)
1454: IF ( G_DEBUG = 'Y' ) THEN
1455: AHL_DEBUG_PUB.disable_debug;
1456: END IF;
1457:
1458: EXCEPTION
1459:
1467: p_data => x_msg_data
1468: );
1469:
1470: IF ( G_DEBUG = 'Y' ) THEN
1471: AHL_DEBUG_PUB.disable_debug;
1472: END IF;
1473:
1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1475: ROLLBACK TO process_material_req_PVT;
1481: p_data => x_msg_data
1482: );
1483:
1484: IF ( G_DEBUG = 'Y' ) THEN
1485: AHL_DEBUG_PUB.disable_debug;
1486: END IF;
1487:
1488: WHEN OTHERS THEN
1489: ROLLBACK TO process_material_req_PVT;
1504: p_data => x_msg_data
1505: );
1506:
1507: IF ( G_DEBUG = 'Y' ) THEN
1508: AHL_DEBUG_PUB.disable_debug;
1509: END IF;
1510:
1511: END process_material_req;
1512:
1558: BEGIN
1559:
1560: -- Enable Debug
1561: IF ( G_DEBUG = 'Y' ) THEN
1562: AHL_DEBUG_PUB.enable_debug;
1563: END IF;
1564:
1565: -- Initialize API return status to success
1566: x_return_status := FND_API.G_RET_STS_SUCCESS;
1572: -- corresponding EAM Resource Requirement record attributes.
1573: FOR i IN p_resource_req_tbl.FIRST..p_resource_req_tbl.LAST LOOP
1574:
1575: IF ( G_DEBUG = 'Y' ) THEN
1576: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1577: AHL_DEBUG_PUB.debug( 'Resource Requirement Record Number : ' || i );
1578: END IF;
1579:
1580: map_ahl_eam_res_rec
1573: FOR i IN p_resource_req_tbl.FIRST..p_resource_req_tbl.LAST LOOP
1574:
1575: IF ( G_DEBUG = 'Y' ) THEN
1576: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1577: AHL_DEBUG_PUB.debug( 'Resource Requirement Record Number : ' || i );
1578: END IF;
1579:
1580: map_ahl_eam_res_rec
1581: (
1596: );
1597: END IF;
1598:
1599: IF ( G_DEBUG = 'Y' ) THEN
1600: AHL_DEBUG_PUB.debug( 'Invoking EAM process_wo API' );
1601: END IF;
1602:
1603: -- Invoke EAM BO API for Updating the Job
1604: EAM_PROCESS_WO_PUB.process_wo
1634: );
1635:
1636: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1637: IF ( G_DEBUG = 'Y' ) THEN
1638: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1639: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1640: END IF;
1641:
1642: RAISE FND_API.G_EXC_ERROR;
1635:
1636: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1637: IF ( G_DEBUG = 'Y' ) THEN
1638: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1639: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1640: END IF;
1641:
1642: RAISE FND_API.G_EXC_ERROR;
1643: END IF;
1648: END IF;
1649:
1650: -- Disable debug (if enabled)
1651: IF ( G_DEBUG = 'Y' ) THEN
1652: AHL_DEBUG_PUB.disable_debug;
1653: END IF;
1654:
1655: EXCEPTION
1656:
1664: p_data => x_msg_data
1665: );
1666:
1667: IF ( G_DEBUG = 'Y' ) THEN
1668: AHL_DEBUG_PUB.disable_debug;
1669: END IF;
1670:
1671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1672: ROLLBACK TO process_resource_req_PVT;
1678: p_data => x_msg_data
1679: );
1680:
1681: IF ( G_DEBUG = 'Y' ) THEN
1682: AHL_DEBUG_PUB.disable_debug;
1683: END IF;
1684:
1685: WHEN OTHERS THEN
1686: ROLLBACK TO process_resource_req_PVT;
1701: p_data => x_msg_data
1702: );
1703:
1704: IF ( G_DEBUG = 'Y' ) THEN
1705: AHL_DEBUG_PUB.disable_debug;
1706: END IF;
1707:
1708: END process_resource_req;
1709:
1755: BEGIN
1756:
1757: -- Enable Debug
1758: IF ( G_DEBUG = 'Y' ) THEN
1759: AHL_DEBUG_PUB.enable_debug;
1760: END IF;
1761:
1762: -- Initialize API return status to success
1763: x_return_status := FND_API.G_RET_STS_SUCCESS;
1769: -- corresponding EAM Material Requirement record attributes.
1770: FOR i IN p_resource_assign_tbl.FIRST..p_resource_assign_tbl.LAST LOOP
1771:
1772: IF ( G_DEBUG = 'Y' ) THEN
1773: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1774: AHL_DEBUG_PUB.debug( 'Resource Assignment Record Number : ' || i );
1775: END IF;
1776:
1777: map_ahl_eam_res_inst_rec
1770: FOR i IN p_resource_assign_tbl.FIRST..p_resource_assign_tbl.LAST LOOP
1771:
1772: IF ( G_DEBUG = 'Y' ) THEN
1773: AHL_DEBUG_PUB.debug( 'Inputs for API: ' || G_PKG_NAME||'.'||l_api_name );
1774: AHL_DEBUG_PUB.debug( 'Resource Assignment Record Number : ' || i );
1775: END IF;
1776:
1777: map_ahl_eam_res_inst_rec
1778: (
1793: );
1794: END IF;
1795:
1796: IF ( G_DEBUG = 'Y' ) THEN
1797: AHL_DEBUG_PUB.debug( 'Invoking EAM process_wo API' );
1798: END IF;
1799:
1800: -- Invoke EAM BO API for Updating the Job
1801: EAM_PROCESS_WO_PUB.process_wo
1831: );
1832:
1833: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1834: IF ( G_DEBUG = 'Y' ) THEN
1835: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1836: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1837: END IF;
1838:
1839: RAISE FND_API.G_EXC_ERROR;
1832:
1833: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1834: IF ( G_DEBUG = 'Y' ) THEN
1835: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1836: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1837: END IF;
1838:
1839: RAISE FND_API.G_EXC_ERROR;
1840: END IF;
1845: END IF;
1846:
1847: -- Disable debug (if enabled)
1848: IF ( G_DEBUG = 'Y' ) THEN
1849: AHL_DEBUG_PUB.disable_debug;
1850: END IF;
1851:
1852: EXCEPTION
1853:
1861: p_data => x_msg_data
1862: );
1863:
1864: IF ( G_DEBUG = 'Y' ) THEN
1865: AHL_DEBUG_PUB.disable_debug;
1866: END IF;
1867:
1868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1869: ROLLBACK TO process_resource_assign_PVT;
1875: p_data => x_msg_data
1876: );
1877:
1878: IF ( G_DEBUG = 'Y' ) THEN
1879: AHL_DEBUG_PUB.disable_debug;
1880: END IF;
1881:
1882: WHEN OTHERS THEN
1883: ROLLBACK TO process_resource_assign_PVT;
1898: p_data => x_msg_data
1899: );
1900:
1901: IF ( G_DEBUG = 'Y' ) THEN
1902: AHL_DEBUG_PUB.disable_debug;
1903: END IF;
1904:
1905: END process_resource_assign;
1906:
1951: BEGIN
1952:
1953: -- Enable Debug
1954: IF ( G_DEBUG = 'Y' ) THEN
1955: AHL_DEBUG_PUB.enable_debug;
1956: END IF;
1957:
1958: -- Initialize API return status to success
1959: x_return_status := FND_API.G_RET_STS_SUCCESS;
1972: );
1973: END IF;
1974:
1975: IF ( G_DEBUG = 'Y' ) THEN
1976: AHL_DEBUG_PUB.debug( 'Invoking EAM process_master_child_wo API' );
1977:
1978: IF(p_x_eam_wo_tbl.COUNT > 0) THEN
1979: FOR i IN p_x_eam_wo_tbl.FIRST..p_x_eam_wo_tbl.LAST LOOP
1980: AHL_DEBUG_PUB.debug( 'Workorder('||i||') batch_id : '||p_x_eam_wo_tbl(i).batch_id );
1976: AHL_DEBUG_PUB.debug( 'Invoking EAM process_master_child_wo API' );
1977:
1978: IF(p_x_eam_wo_tbl.COUNT > 0) THEN
1979: FOR i IN p_x_eam_wo_tbl.FIRST..p_x_eam_wo_tbl.LAST LOOP
1980: AHL_DEBUG_PUB.debug( 'Workorder('||i||') batch_id : '||p_x_eam_wo_tbl(i).batch_id );
1981: AHL_DEBUG_PUB.debug( 'Workorder('||i||') header_id : '||p_x_eam_wo_tbl(i).header_id );
1982: END LOOP;
1983: END IF;
1984:
1977:
1978: IF(p_x_eam_wo_tbl.COUNT > 0) THEN
1979: FOR i IN p_x_eam_wo_tbl.FIRST..p_x_eam_wo_tbl.LAST LOOP
1980: AHL_DEBUG_PUB.debug( 'Workorder('||i||') batch_id : '||p_x_eam_wo_tbl(i).batch_id );
1981: AHL_DEBUG_PUB.debug( 'Workorder('||i||') header_id : '||p_x_eam_wo_tbl(i).header_id );
1982: END LOOP;
1983: END IF;
1984:
1985: IF ( p_eam_op_tbl.COUNT > 0 ) THEN
1983: END IF;
1984:
1985: IF ( p_eam_op_tbl.COUNT > 0 ) THEN
1986: FOR i IN p_eam_op_tbl.FIRST..p_eam_op_tbl.LAST LOOP
1987: AHL_DEBUG_PUB.debug( 'Operation('||i||') batch_id : '||p_eam_op_tbl(i).batch_id );
1988: AHL_DEBUG_PUB.debug( 'Operation('||i||') header_id : '||p_eam_op_tbl(i).header_id );
1989: END LOOP;
1990: END IF;
1991:
1984:
1985: IF ( p_eam_op_tbl.COUNT > 0 ) THEN
1986: FOR i IN p_eam_op_tbl.FIRST..p_eam_op_tbl.LAST LOOP
1987: AHL_DEBUG_PUB.debug( 'Operation('||i||') batch_id : '||p_eam_op_tbl(i).batch_id );
1988: AHL_DEBUG_PUB.debug( 'Operation('||i||') header_id : '||p_eam_op_tbl(i).header_id );
1989: END LOOP;
1990: END IF;
1991:
1992: IF ( p_eam_res_req_tbl.COUNT > 0 ) THEN
1990: END IF;
1991:
1992: IF ( p_eam_res_req_tbl.COUNT > 0 ) THEN
1993: FOR i IN p_eam_res_req_tbl.FIRST..p_eam_res_req_tbl.LAST LOOP
1994: AHL_DEBUG_PUB.debug( 'Resource('||i||') batch_id : '||p_eam_res_req_tbl(i).batch_id );
1995: AHL_DEBUG_PUB.debug( 'Resource('||i||') header_id : '||p_eam_res_req_tbl(i).header_id );
1996: END LOOP;
1997: END IF;
1998:
1991:
1992: IF ( p_eam_res_req_tbl.COUNT > 0 ) THEN
1993: FOR i IN p_eam_res_req_tbl.FIRST..p_eam_res_req_tbl.LAST LOOP
1994: AHL_DEBUG_PUB.debug( 'Resource('||i||') batch_id : '||p_eam_res_req_tbl(i).batch_id );
1995: AHL_DEBUG_PUB.debug( 'Resource('||i||') header_id : '||p_eam_res_req_tbl(i).header_id );
1996: END LOOP;
1997: END IF;
1998:
1999: IF ( p_eam_mat_req_tbl.COUNT > 0 ) THEN
1997: END IF;
1998:
1999: IF ( p_eam_mat_req_tbl.COUNT > 0 ) THEN
2000: FOR i IN p_eam_mat_req_tbl.FIRST..p_eam_mat_req_tbl.LAST LOOP
2001: AHL_DEBUG_PUB.debug( 'Material('||i||') batch_id : '||p_eam_mat_req_tbl(i).batch_id );
2002: AHL_DEBUG_PUB.debug( 'Material('||i||') header_id : '||p_eam_mat_req_tbl(i).header_id );
2003: END LOOP;
2004: END IF;
2005:
1998:
1999: IF ( p_eam_mat_req_tbl.COUNT > 0 ) THEN
2000: FOR i IN p_eam_mat_req_tbl.FIRST..p_eam_mat_req_tbl.LAST LOOP
2001: AHL_DEBUG_PUB.debug( 'Material('||i||') batch_id : '||p_eam_mat_req_tbl(i).batch_id );
2002: AHL_DEBUG_PUB.debug( 'Material('||i||') header_id : '||p_eam_mat_req_tbl(i).header_id );
2003: END LOOP;
2004: END IF;
2005:
2006: END IF;
2038: );
2039:
2040: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2041: IF ( G_DEBUG = 'Y' ) THEN
2042: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
2043: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
2044: END IF;
2045:
2046: RAISE FND_API.G_EXC_ERROR;
2039:
2040: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2041: IF ( G_DEBUG = 'Y' ) THEN
2042: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
2043: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
2044: END IF;
2045:
2046: RAISE FND_API.G_EXC_ERROR;
2047:
2050: --Ignore messages in stack if return status is S after calls to EAM APIs.
2051: FND_MSG_PUB.initialize;
2052:
2053: IF ( G_DEBUG = 'Y' ) THEN
2054: AHL_DEBUG_PUB.debug( 'EAM process_master_child_wo API Successful' );
2055: AHL_DEBUG_PUB.debug( 'Input Workorder Table count : ' || p_x_eam_wo_tbl.COUNT );
2056: AHL_DEBUG_PUB.debug( 'Output Workorder Table count : ' || l_out_eam_wo_tbl.COUNT );
2057: END IF;
2058:
2051: FND_MSG_PUB.initialize;
2052:
2053: IF ( G_DEBUG = 'Y' ) THEN
2054: AHL_DEBUG_PUB.debug( 'EAM process_master_child_wo API Successful' );
2055: AHL_DEBUG_PUB.debug( 'Input Workorder Table count : ' || p_x_eam_wo_tbl.COUNT );
2056: AHL_DEBUG_PUB.debug( 'Output Workorder Table count : ' || l_out_eam_wo_tbl.COUNT );
2057: END IF;
2058:
2059: FOR i IN 1..l_out_eam_wo_tbl.COUNT LOOP
2052:
2053: IF ( G_DEBUG = 'Y' ) THEN
2054: AHL_DEBUG_PUB.debug( 'EAM process_master_child_wo API Successful' );
2055: AHL_DEBUG_PUB.debug( 'Input Workorder Table count : ' || p_x_eam_wo_tbl.COUNT );
2056: AHL_DEBUG_PUB.debug( 'Output Workorder Table count : ' || l_out_eam_wo_tbl.COUNT );
2057: END IF;
2058:
2059: FOR i IN 1..l_out_eam_wo_tbl.COUNT LOOP
2060: IF ( l_out_eam_wo_tbl(i).wip_entity_id IS NULL ) THEN
2062: FND_MESSAGE.set_token('HEADER', l_out_eam_wo_tbl(i).header_id );
2063: FND_MSG_PUB.add;
2064:
2065: IF ( G_DEBUG = 'Y' ) THEN
2066: AHL_DEBUG_PUB.debug( 'No wip_entity_id generated for header_id:' || l_out_eam_wo_tbl(i).header_id );
2067: END IF;
2068: ELSE
2069:
2070: IF ( G_DEBUG = 'Y' ) THEN
2067: END IF;
2068: ELSE
2069:
2070: IF ( G_DEBUG = 'Y' ) THEN
2071: AHL_DEBUG_PUB.debug( 'wip_entity_id(' || i || '):' || TO_CHAR( l_out_eam_wo_tbl(i).wip_entity_id ) );
2072: END IF;
2073:
2074: p_x_eam_wo_tbl(i).wip_entity_id := l_out_eam_wo_tbl(i).wip_entity_id;
2075:
2088: END IF;
2089:
2090: -- Disable debug (if enabled)
2091: IF ( G_DEBUG = 'Y' ) THEN
2092: AHL_DEBUG_PUB.disable_debug;
2093: END IF;
2094:
2095: EXCEPTION
2096:
2104: p_data => x_msg_data
2105: );
2106:
2107: IF ( G_DEBUG = 'Y' ) THEN
2108: AHL_DEBUG_PUB.disable_debug;
2109: END IF;
2110:
2111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2112: ROLLBACK TO process_eam_workorders_PVT;
2118: p_data => x_msg_data
2119: );
2120:
2121: IF ( G_DEBUG = 'Y' ) THEN
2122: AHL_DEBUG_PUB.disable_debug;
2123: END IF;
2124:
2125: WHEN OTHERS THEN
2126: ROLLBACK TO process_eam_workorders_PVT;
2141: p_data => x_msg_data
2142: );
2143:
2144: IF ( G_DEBUG = 'Y' ) THEN
2145: AHL_DEBUG_PUB.disable_debug;
2146: END IF;
2147: END process_eam_workorders;
2148:
2149: END AHL_EAM_JOB_PVT;