eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_JSI_PROCESSOR dependencies on WIP_JSI_UTILS

Line 55: where rowid = WIP_JSI_Utils.current_rowid ;

51: l_project_id,
52: l_task_id,
53: l_move_order_required
54: from wip_job_schedule_interface
55: where rowid = WIP_JSI_Utils.current_rowid ;
56:
57: if (x_load_type in (WIP_CONSTANTS.RESCHED_JOB, WIP_CONSTANTS.RESCHED_LOT_JOB)) then
58: begin
59: select wdj.start_quantity

Line 64: wi.rowid = WIP_JSI_Utils.current_rowid and

60: into x_old_start_quantity
61: FROM wip_discrete_jobs wdj,
62: wip_job_schedule_interface wi
63: WHERE
64: wi.rowid = WIP_JSI_Utils.current_rowid and
65: wi.wip_entity_id = wdj.wip_entity_id;
66: exception
67: when no_data_found then
68: x_old_start_quantity := null;

Line 90: wip_jsi_utils.record_error_text( l_status || ':' || x_mo_req_number || ': ' || l_msg_data, true) ;

86: x_msg_data => l_msg_data
87: );
88:
89: if(l_status in ('S', 'P')) then
90: wip_jsi_utils.record_error_text( l_status || ':' || x_mo_req_number || ': ' || l_msg_data, true) ;
91: elsif(l_status in ('N', 'E')) then
92: wip_jsi_utils.record_error_text( l_status || ': ' || l_msg_data, true) ;
93: else
94: wip_jsi_utils.record_error_text( l_status || ': ' || l_msg_data, true);

Line 92: wip_jsi_utils.record_error_text( l_status || ': ' || l_msg_data, true) ;

88:
89: if(l_status in ('S', 'P')) then
90: wip_jsi_utils.record_error_text( l_status || ':' || x_mo_req_number || ': ' || l_msg_data, true) ;
91: elsif(l_status in ('N', 'E')) then
92: wip_jsi_utils.record_error_text( l_status || ': ' || l_msg_data, true) ;
93: else
94: wip_jsi_utils.record_error_text( l_status || ': ' || l_msg_data, true);
95: end if;
96: end if;

Line 94: wip_jsi_utils.record_error_text( l_status || ': ' || l_msg_data, true);

90: wip_jsi_utils.record_error_text( l_status || ':' || x_mo_req_number || ': ' || l_msg_data, true) ;
91: elsif(l_status in ('N', 'E')) then
92: wip_jsi_utils.record_error_text( l_status || ': ' || l_msg_data, true) ;
93: else
94: wip_jsi_utils.record_error_text( l_status || ': ' || l_msg_data, true);
95: end if;
96: end if;
97:
98: if(l_pm_sched_id is not null) then

Line 341: wi.rowid = WIP_JSI_Utils.current_rowid

337: bom_bill_of_materials bom,
338: wip_parameters params,
339: wip_job_schedule_interface wi
340: WHERE
341: wi.rowid = WIP_JSI_Utils.current_rowid
342: AND nvl(rtg.cfm_routing_flag,2) = 2
343: AND wac.class_code(+)=wi.class_code
344: AND wac.organization_id(+)=wi.organization_id
345: AND rtg.organization_id(+)=wi.organization_id

Line 392: WHERE wi.rowid = WIP_JSI_Utils.current_rowid ;

388: wi.description,
389: wi.primary_item_id,
390: MTL_GEN_OBJECT_ID_S.nextval
391: FROM WIP_JOB_SCHEDULE_INTERFACE wi
392: WHERE wi.rowid = WIP_JSI_Utils.current_rowid ;
393:
394: /* Fix for Bug#3201290 */
395: if ((x_load_type = WIP_CONSTANTS.CREATE_EAM_JOB)
396: and (x_status_type = WIP_CONSTANTS.RELEASED)) then

Line 411: wi.rowid = WIP_JSI_Utils.current_rowid and

407: x_org_id, x_entity_id, x_item_id, x_cmn_bom_seq_id, x_cmn_routing_seq_id
408: FROM wip_discrete_jobs wdj,
409: wip_job_schedule_interface wi
410: WHERE
411: wi.rowid = WIP_JSI_Utils.current_rowid and
412: wi.wip_entity_id = wdj.wip_entity_id;
413:
414: WIP_EAM_UTILS.copy_attachments(
415: 'Y', /* copy_asset_attachments IN VARCHAR2, */

Line 612: WHERE WJ.ROWID = WIP_JSI_Utils.current_rowid)

608: NVL(WJ.BOM_REVISION,WDJ.BOM_REVISION),
609: DECODE(WJ.LOAD_TYPE, WIP_CONSTANTS.RESCHED_JOB,
610: NVL(WJ.SERIALIZATION_START_OP, WDJ.SERIALIZATION_START_OP), WDJ.SERIALIZATION_START_OP)
611: FROM WIP_JOB_SCHEDULE_INTERFACE WJ
612: WHERE WJ.ROWID = WIP_JSI_Utils.current_rowid)
613: WHERE WDJ.WIP_ENTITY_ID = x_entity_id ;
614:
615: UPDATE WIP_ENTITIES WE
616: SET (DESCRIPTION,

Line 633: WHERE WJ.ROWID = WIP_JSI_Utils.current_rowid)

629: PROGRAM_ID,
630: SYSDATE,
631: SYSDATE
632: FROM WIP_JOB_SCHEDULE_INTERFACE WJ
633: WHERE WJ.ROWID = WIP_JSI_Utils.current_rowid)
634: WHERE WE.WIP_ENTITY_ID = x_entity_id ;
635:
636: /* Fix for Bug#3201290 */
637: if ((x_load_type = WIP_CONSTANTS.RESCHED_EAM_JOB)

Line 648: wip_jsi_utils.record_current_error(TRUE);

644: if (x_load_type in (WIP_CONSTANTS.RESCHED_JOB, WIP_CONSTANTS.RESCHED_LOT_JOB) and
645: wip_picking_pub.is_job_pick_released(x_entity_id, x_rep_sched_id, x_org_id) and
646: x_old_start_quantity <> x_new_start_quantity) then
647: FND_MESSAGE.set_name('WIP','WIP_QTY_REQ_CHANGE_WARNING');
648: wip_jsi_utils.record_current_error(TRUE);
649:
650: wip_picking_pub.Update_Job_BackOrdQty (p_wip_entity_id => x_entity_id,
651: p_repetitive_schedule_id => x_rep_sched_id,
652: p_new_job_qty => x_new_start_quantity,

Line 660: wip_jsi_utils.record_current_error;

656: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
657: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
658: fnd_message.set_token('ERROR_TEXT', 'WIP_JSI_Processor.update_parent_table calling => ' ||
659: 'wip_picking_pub.Update_Job_BackOrdQty: ' || SQLERRM);
660: wip_jsi_utils.record_current_error;
661: end if;
662: end if;
663:
664:

Line 675: wip_jsi_utils.record_current_error;

671: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
672: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
673: fnd_message.set_token('ERROR_TEXT', 'WIP_JSI_Processor.update_parent_table calling => ' ||
674: 'wip_picking_pub.Update_Job_BackOrdQty: ' || SQLERRM);
675: wip_jsi_utils.record_current_error;
676: end if;
677: end if;
678:
679: elsif (x_load_type = WIP_CONSTANTS.CREATE_SCHED) then

Line 818: WHERE wi.rowid = WIP_JSI_Utils.current_rowid

814: wip_repetitive_items ri,
815: wip_accounting_classes ac,
816: wip_parameters params,
817: wip_job_schedule_interface wi
818: WHERE wi.rowid = WIP_JSI_Utils.current_rowid
819: AND nvl(bor.cfm_routing_flag,2) = 2
820: AND ri.organization_id = wi.organization_id
821: AND ri.primary_item_id = wi.primary_item_id
822: AND ri.line_id = wi.line_id