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_JOB_DETAILS dependencies on WIP_CONSTANTS

Line 18: and process_phase = WIP_CONSTANTS.ML_VALIDATION

14: organization_id
15: from wip_job_dtls_interface
16: where group_id = p_group_id
17: and parent_header_id = p_parent_header_id
18: and process_phase = WIP_CONSTANTS.ML_VALIDATION
19: and process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING) ;
20:
21: Cursor wdj_cur IS
22: select distinct wip_entity_id,

Line 19: and process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING) ;

15: from wip_job_dtls_interface
16: where group_id = p_group_id
17: and parent_header_id = p_parent_header_id
18: and process_phase = WIP_CONSTANTS.ML_VALIDATION
19: and process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING) ;
20:
21: Cursor wdj_cur IS
22: select distinct wip_entity_id,
23: organization_id

Line 26: and process_phase = WIP_CONSTANTS.ML_VALIDATION

22: select distinct wip_entity_id,
23: organization_id
24: from wip_job_dtls_interface
25: where group_id = p_group_id
26: and process_phase = WIP_CONSTANTS.ML_VALIDATION
27: and process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING) ;
28:
29: Cursor Oper_Cur (p_wip_entity_id number, p_organization_id number) IS
30: select distinct wip_entity_id,

Line 27: and process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING) ;

23: organization_id
24: from wip_job_dtls_interface
25: where group_id = p_group_id
26: and process_phase = WIP_CONSTANTS.ML_VALIDATION
27: and process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING) ;
28:
29: Cursor Oper_Cur (p_wip_entity_id number, p_organization_id number) IS
30: select distinct wip_entity_id,
31: organization_id,

Line 41: and process_phase = WIP_CONSTANTS.ML_VALIDATION

37: OR p_std_alone = 1)
38: and wip_entity_id = p_wip_entity_id
39: and organization_id = p_organization_id
40: and load_type = WIP_JOB_DETAILS.WIP_OPERATION
41: and process_phase = WIP_CONSTANTS.ML_VALIDATION
42: and process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING) ;
43:
44: Cursor Res_Cur (p_wip_entity_id number, p_organization_id number) IS
45: select distinct wip_entity_id,

Line 42: and process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING) ;

38: and wip_entity_id = p_wip_entity_id
39: and organization_id = p_organization_id
40: and load_type = WIP_JOB_DETAILS.WIP_OPERATION
41: and process_phase = WIP_CONSTANTS.ML_VALIDATION
42: and process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING) ;
43:
44: Cursor Res_Cur (p_wip_entity_id number, p_organization_id number) IS
45: select distinct wip_entity_id,
46: organization_id,

Line 56: and process_phase = WIP_CONSTANTS.ML_VALIDATION

52: OR p_std_alone = 1)
53: and wip_entity_id = p_wip_entity_id
54: and organization_id = p_organization_id
55: and load_type = WIP_JOB_DETAILS.WIP_RESOURCE
56: and process_phase = WIP_CONSTANTS.ML_VALIDATION
57: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);
58:
59: Cursor ResInst_Cur (p_wip_entity_id number, p_organization_id number) IS
60: select distinct wip_entity_id,

Line 57: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);

53: and wip_entity_id = p_wip_entity_id
54: and organization_id = p_organization_id
55: and load_type = WIP_JOB_DETAILS.WIP_RESOURCE
56: and process_phase = WIP_CONSTANTS.ML_VALIDATION
57: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);
58:
59: Cursor ResInst_Cur (p_wip_entity_id number, p_organization_id number) IS
60: select distinct wip_entity_id,
61: organization_id,

Line 71: and process_phase = WIP_CONSTANTS.ML_VALIDATION

67: OR p_std_alone = 1)
68: and wip_entity_id = p_wip_entity_id
69: and organization_id = p_organization_id
70: and load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE
71: and process_phase = WIP_CONSTANTS.ML_VALIDATION
72: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);
73:
74: Cursor Req_Cur (p_wip_entity_id number, p_organization_id number) IS
75: select distinct wip_entity_id,

Line 72: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);

68: and wip_entity_id = p_wip_entity_id
69: and organization_id = p_organization_id
70: and load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE
71: and process_phase = WIP_CONSTANTS.ML_VALIDATION
72: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);
73:
74: Cursor Req_Cur (p_wip_entity_id number, p_organization_id number) IS
75: select distinct wip_entity_id,
76: organization_id,

Line 86: and process_phase = WIP_CONSTANTS.ML_VALIDATION

82: OR p_std_alone = 1 )
83: and wip_entity_id = p_wip_entity_id
84: and organization_id = p_organization_id
85: and load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
86: and process_phase = WIP_CONSTANTS.ML_VALIDATION
87: and process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING);
88:
89: Cursor Res_Usage_Cur (p_wip_entity_id number, p_organization_id number) IS
90: select distinct wip_entity_id,

Line 87: and process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING);

83: and wip_entity_id = p_wip_entity_id
84: and organization_id = p_organization_id
85: and load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
86: and process_phase = WIP_CONSTANTS.ML_VALIDATION
87: and process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING);
88:
89: Cursor Res_Usage_Cur (p_wip_entity_id number, p_organization_id number) IS
90: select distinct wip_entity_id,
91: organization_id,

Line 102: and process_phase = WIP_CONSTANTS.ML_VALIDATION

98: and wip_entity_id = p_wip_entity_id
99: and organization_id = p_organization_id
100: and load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,
101: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)
102: and process_phase = WIP_CONSTANTS.ML_VALIDATION
103: and process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING);
104:
105: Cursor SubRes_Cur (p_wip_entity_id number, p_organization_id number) IS
106: select distinct wip_entity_id,

Line 103: and process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING);

99: and organization_id = p_organization_id
100: and load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,
101: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)
102: and process_phase = WIP_CONSTANTS.ML_VALIDATION
103: and process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING);
104:
105: Cursor SubRes_Cur (p_wip_entity_id number, p_organization_id number) IS
106: select distinct wip_entity_id,
107: organization_id,

Line 117: and process_phase = WIP_CONSTANTS.ML_VALIDATION

113: OR p_std_alone = 1)
114: and wip_entity_id = p_wip_entity_id
115: and organization_id = p_organization_id
116: and load_type = WIP_JOB_DETAILS.WIP_SUB_RES
117: and process_phase = WIP_CONSTANTS.ML_VALIDATION
118: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);
119:
120: Cursor Op_Link_Cur (p_wip_entity_id number, p_organization_id number) IS
121: select distinct wip_entity_id,

Line 118: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);

114: and wip_entity_id = p_wip_entity_id
115: and organization_id = p_organization_id
116: and load_type = WIP_JOB_DETAILS.WIP_SUB_RES
117: and process_phase = WIP_CONSTANTS.ML_VALIDATION
118: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);
119:
120: Cursor Op_Link_Cur (p_wip_entity_id number, p_organization_id number) IS
121: select distinct wip_entity_id,
122: organization_id,

Line 132: and process_phase = WIP_CONSTANTS.ML_VALIDATION

128: OR p_std_alone = 1)
129: and wip_entity_id = p_wip_entity_id
130: and organization_id = p_organization_id
131: and load_type = WIP_JOB_DETAILS.WIP_OP_LINK
132: and process_phase = WIP_CONSTANTS.ML_VALIDATION
133: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);
134:
135: Cursor Serials_Cur (p_wip_entity_id number, p_organization_id number) IS
136: select distinct wip_entity_id,

Line 133: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);

129: and wip_entity_id = p_wip_entity_id
130: and organization_id = p_organization_id
131: and load_type = WIP_JOB_DETAILS.WIP_OP_LINK
132: and process_phase = WIP_CONSTANTS.ML_VALIDATION
133: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);
134:
135: Cursor Serials_Cur (p_wip_entity_id number, p_organization_id number) IS
136: select distinct wip_entity_id,
137: organization_id,

Line 147: and process_phase = WIP_CONSTANTS.ML_VALIDATION

143: OR p_std_alone = 1)
144: and wip_entity_id = p_wip_entity_id
145: and organization_id = p_organization_id
146: and load_type = WIP_JOB_DETAILS.WIP_SERIAL
147: and process_phase = WIP_CONSTANTS.ML_VALIDATION
148: and process_status IN (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING);
149:
150: x_count number;
151:

Line 148: and process_status IN (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING);

144: and wip_entity_id = p_wip_entity_id
145: and organization_id = p_organization_id
146: and load_type = WIP_JOB_DETAILS.WIP_SERIAL
147: and process_phase = WIP_CONSTANTS.ML_VALIDATION
148: and process_status IN (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING);
149:
150: x_count number;
151:
152: cur_job job_cur%ROWTYPE ;

Line 386: if (l_logLevel <= wip_constants.trace_logging) then

382: l_cur.organization_id,
383: l_cur.substitution_type,
384: x_err_code,
385: x_err_msg);
386: if (l_logLevel <= wip_constants.trace_logging) then
387: IF x_err_code IS NOT NULL THEN
388: wip_logger.log(x_err_code, l_dummy2);
389: wip_logger.log(x_err_msg, l_dummy2);
390: end if;

Line 401: if (l_logLevel <= wip_constants.trace_logging) then

397: l_cur.organization_id,
398: l_cur.substitution_type,
399: x_err_code,
400: x_err_msg);
401: if (l_logLevel <= wip_constants.trace_logging) then
402: IF x_err_code IS NOT NULL THEN
403: wip_logger.log(x_err_code, l_dummy2);
404: wip_logger.log(x_err_msg, l_dummy2);
405: end if;

Line 416: if (l_logLevel <= wip_constants.trace_logging) then

412: l_cur.organization_id,
413: l_cur.substitution_type,
414: x_err_code,
415: x_err_msg);
416: if (l_logLevel <= wip_constants.trace_logging) then
417: IF x_err_code IS NOT NULL THEN
418: wip_logger.log(x_err_code, l_dummy2);
419: wip_logger.log(x_err_msg, l_dummy2);
420: end if;

Line 753: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

749: WHERE group_id = p_group_id
750: AND parent_header_id = p_parent_header_id
751: AND wip_entity_id = cur_job.wip_entity_id
752: AND organization_id = cur_job.organization_id
753: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
754: AND process_status = WIP_CONSTANTS.ERROR ;
755:
756: IF x_count <> 0 THEN
757: x_err_code := -20239;

Line 754: AND process_status = WIP_CONSTANTS.ERROR ;

750: AND parent_header_id = p_parent_header_id
751: AND wip_entity_id = cur_job.wip_entity_id
752: AND organization_id = cur_job.organization_id
753: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
754: AND process_status = WIP_CONSTANTS.ERROR ;
755:
756: IF x_count <> 0 THEN
757: x_err_code := -20239;
758: x_err_msg := 'VALIDATION ERROR HAPPENED!';

Line 769: SET process_status = WIP_CONSTANTS.COMPLETED

765: IF x_err_code IS NULL THEN
766:
767: /* set process_status = COMPLETED */
768: UPDATE wip_job_dtls_interface
769: SET process_status = WIP_CONSTANTS.COMPLETED
770: WHERE group_id = p_group_id
771: AND wip_entity_id = cur_job.wip_entity_id
772: AND (p_parent_header_id IS NULL OR
773: (p_parent_header_id IS NOT NULL AND

Line 776: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

772: AND (p_parent_header_id IS NULL OR
773: (p_parent_header_id IS NOT NULL AND
774: parent_header_id = p_parent_header_id))
775: AND organization_id = cur_job.organization_id
776: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
777: AND process_status = WIP_CONSTANTS.RUNNING ;
778:
779: /* DELETE THE COMPLETED ROWS FROM INTERFACE TABLE */
780: DELETE from wip_job_dtls_interface

Line 777: AND process_status = WIP_CONSTANTS.RUNNING ;

773: (p_parent_header_id IS NOT NULL AND
774: parent_header_id = p_parent_header_id))
775: AND organization_id = cur_job.organization_id
776: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
777: AND process_status = WIP_CONSTANTS.RUNNING ;
778:
779: /* DELETE THE COMPLETED ROWS FROM INTERFACE TABLE */
780: DELETE from wip_job_dtls_interface
781: WHERE group_id = p_group_id

Line 785: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

781: WHERE group_id = p_group_id
782: AND parent_header_id = p_parent_header_id
783: AND wip_entity_id = cur_job.wip_entity_id
784: AND organization_id = cur_job.organization_id
785: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
786: AND process_status = WIP_CONSTANTS.COMPLETED;
787:
788: END IF;
789:

Line 786: AND process_status = WIP_CONSTANTS.COMPLETED;

782: AND parent_header_id = p_parent_header_id
783: AND wip_entity_id = cur_job.wip_entity_id
784: AND organization_id = cur_job.organization_id
785: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
786: AND process_status = WIP_CONSTANTS.COMPLETED;
787:
788: END IF;
789:
790: WIP_JDI_Utils.end_processing_request(cur_job.wip_entity_id,

Line 824: and wjdi.process_phase = wip_constants.ml_validation

820: select interface_id
821: from wip_job_dtls_interface wjdi
822: where wjdi.group_id = p_group_id
823: and wjdi.parent_header_id = p_parent_header_id
824: and wjdi.process_phase = wip_constants.ml_validation
825: and wjdi.process_status = wip_constants.running
826: and wjdi.parent_header_id is not null
827: and ( wjdi.wip_entity_id is not null
828: or wjdi.organization_id is not null);

Line 825: and wjdi.process_status = wip_constants.running

821: from wip_job_dtls_interface wjdi
822: where wjdi.group_id = p_group_id
823: and wjdi.parent_header_id = p_parent_header_id
824: and wjdi.process_phase = wip_constants.ml_validation
825: and wjdi.process_status = wip_constants.running
826: and wjdi.parent_header_id is not null
827: and ( wjdi.wip_entity_id is not null
828: or wjdi.organization_id is not null);
829:

Line 850: set process_status = wip_constants.warning

846: p_error_type => wip_jdi_utils.msg_error);
847: end loop;
848: if(l_error_exists) then
849: update wip_job_dtls_interface wjdi
850: set process_status = wip_constants.warning
851: where group_id = p_group_id
852: and parent_header_id = p_parent_header_id
853: and process_phase = wip_constants.ml_validation
854: and process_status = wip_constants.running

Line 853: and process_phase = wip_constants.ml_validation

849: update wip_job_dtls_interface wjdi
850: set process_status = wip_constants.warning
851: where group_id = p_group_id
852: and parent_header_id = p_parent_header_id
853: and process_phase = wip_constants.ml_validation
854: and process_status = wip_constants.running
855: and wjdi.parent_header_id is not null
856: and ( wjdi.wip_entity_id is not null
857: or wjdi.organization_id is not null);

Line 854: and process_status = wip_constants.running

850: set process_status = wip_constants.warning
851: where group_id = p_group_id
852: and parent_header_id = p_parent_header_id
853: and process_phase = wip_constants.ml_validation
854: and process_status = wip_constants.running
855: and wjdi.parent_header_id is not null
856: and ( wjdi.wip_entity_id is not null
857: or wjdi.organization_id is not null);
858:

Line 869: and process_status IN (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING);

865: into l_wip_entity_id, l_organization_id
866: from wip_job_schedule_interface
867: where header_id = p_parent_header_id
868: and group_id = p_group_id
869: and process_status IN (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING);
870:
871: Update wip_job_dtls_interface
872: Set wip_entity_id = l_wip_entity_id,
873: organization_id = l_organization_id