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

Line 45: IF (l_logLevel <= wip_constants.trace_logging) THEN

41: BEGIN
42: x_returnStatus := fnd_api.g_ret_sts_success;
43: fnd_file.put_line(FND_FILE.LOG,'Populate Close Temp');
44:
45: IF (l_logLevel <= wip_constants.trace_logging) THEN
46: l_params(1).paramName := 'p_organization_id';
47: l_params(1).paramValue := p_organization_id ;
48: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.populate_close_temp',
49: p_params => l_params,

Line 95: (WIP_CONSTANTS.UNRELEASED,

91: FROM WIP_DJ_CLOSE_TEMP WDCT
92: WHERE WDCT.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
93: AND DJ.STATUS_TYPE IN
94: -- (1,3,4,5,6,7,9,11,15)
95: (WIP_CONSTANTS.UNRELEASED,
96: WIP_CONSTANTS.RELEASED,
97: WIP_CONSTANTS.COMP_CHRG,
98: WIP_CONSTANTS.COMP_NOCHRG ,
99: WIP_CONSTANTS.HOLD ,

Line 96: WIP_CONSTANTS.RELEASED,

92: WHERE WDCT.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
93: AND DJ.STATUS_TYPE IN
94: -- (1,3,4,5,6,7,9,11,15)
95: (WIP_CONSTANTS.UNRELEASED,
96: WIP_CONSTANTS.RELEASED,
97: WIP_CONSTANTS.COMP_CHRG,
98: WIP_CONSTANTS.COMP_NOCHRG ,
99: WIP_CONSTANTS.HOLD ,
100: WIP_CONSTANTS.CANCELLED ,

Line 97: WIP_CONSTANTS.COMP_CHRG,

93: AND DJ.STATUS_TYPE IN
94: -- (1,3,4,5,6,7,9,11,15)
95: (WIP_CONSTANTS.UNRELEASED,
96: WIP_CONSTANTS.RELEASED,
97: WIP_CONSTANTS.COMP_CHRG,
98: WIP_CONSTANTS.COMP_NOCHRG ,
99: WIP_CONSTANTS.HOLD ,
100: WIP_CONSTANTS.CANCELLED ,
101: WIP_CONSTANTS.FAIL_BOM,

Line 98: WIP_CONSTANTS.COMP_NOCHRG ,

94: -- (1,3,4,5,6,7,9,11,15)
95: (WIP_CONSTANTS.UNRELEASED,
96: WIP_CONSTANTS.RELEASED,
97: WIP_CONSTANTS.COMP_CHRG,
98: WIP_CONSTANTS.COMP_NOCHRG ,
99: WIP_CONSTANTS.HOLD ,
100: WIP_CONSTANTS.CANCELLED ,
101: WIP_CONSTANTS.FAIL_BOM,
102: WIP_CONSTANTS.FAIL_ROUT,

Line 99: WIP_CONSTANTS.HOLD ,

95: (WIP_CONSTANTS.UNRELEASED,
96: WIP_CONSTANTS.RELEASED,
97: WIP_CONSTANTS.COMP_CHRG,
98: WIP_CONSTANTS.COMP_NOCHRG ,
99: WIP_CONSTANTS.HOLD ,
100: WIP_CONSTANTS.CANCELLED ,
101: WIP_CONSTANTS.FAIL_BOM,
102: WIP_CONSTANTS.FAIL_ROUT,
103: WIP_CONSTANTS.FAIL_CLOSE

Line 100: WIP_CONSTANTS.CANCELLED ,

96: WIP_CONSTANTS.RELEASED,
97: WIP_CONSTANTS.COMP_CHRG,
98: WIP_CONSTANTS.COMP_NOCHRG ,
99: WIP_CONSTANTS.HOLD ,
100: WIP_CONSTANTS.CANCELLED ,
101: WIP_CONSTANTS.FAIL_BOM,
102: WIP_CONSTANTS.FAIL_ROUT,
103: WIP_CONSTANTS.FAIL_CLOSE
104: )

Line 101: WIP_CONSTANTS.FAIL_BOM,

97: WIP_CONSTANTS.COMP_CHRG,
98: WIP_CONSTANTS.COMP_NOCHRG ,
99: WIP_CONSTANTS.HOLD ,
100: WIP_CONSTANTS.CANCELLED ,
101: WIP_CONSTANTS.FAIL_BOM,
102: WIP_CONSTANTS.FAIL_ROUT,
103: WIP_CONSTANTS.FAIL_CLOSE
104: )
105: AND ( p_class_type IS NULL OR

Line 102: WIP_CONSTANTS.FAIL_ROUT,

98: WIP_CONSTANTS.COMP_NOCHRG ,
99: WIP_CONSTANTS.HOLD ,
100: WIP_CONSTANTS.CANCELLED ,
101: WIP_CONSTANTS.FAIL_BOM,
102: WIP_CONSTANTS.FAIL_ROUT,
103: WIP_CONSTANTS.FAIL_CLOSE
104: )
105: AND ( p_class_type IS NULL OR
106: DJ.CLASS_CODE IN ( SELECT CLASS_CODE

Line 103: WIP_CONSTANTS.FAIL_CLOSE

99: WIP_CONSTANTS.HOLD ,
100: WIP_CONSTANTS.CANCELLED ,
101: WIP_CONSTANTS.FAIL_BOM,
102: WIP_CONSTANTS.FAIL_ROUT,
103: WIP_CONSTANTS.FAIL_CLOSE
104: )
105: AND ( p_class_type IS NULL OR
106: DJ.CLASS_CODE IN ( SELECT CLASS_CODE
107: FROM WIP_ACCOUNTING_CLASSES

Line 212: (WIP_CONSTANTS.UNRELEASED,

208: FROM WIP_DJ_CLOSE_TEMP WDCT
209: WHERE WDCT.WIP_ENTITY_ID = WE.WIP_ENTITY_ID )
210: AND DJ.STATUS_TYPE IN
211: -- (1,3,4,5,6,7,9,11,15)
212: (WIP_CONSTANTS.UNRELEASED,
213: WIP_CONSTANTS.RELEASED,
214: WIP_CONSTANTS.COMP_CHRG,
215: WIP_CONSTANTS.COMP_NOCHRG ,
216: WIP_CONSTANTS.HOLD ,

Line 213: WIP_CONSTANTS.RELEASED,

209: WHERE WDCT.WIP_ENTITY_ID = WE.WIP_ENTITY_ID )
210: AND DJ.STATUS_TYPE IN
211: -- (1,3,4,5,6,7,9,11,15)
212: (WIP_CONSTANTS.UNRELEASED,
213: WIP_CONSTANTS.RELEASED,
214: WIP_CONSTANTS.COMP_CHRG,
215: WIP_CONSTANTS.COMP_NOCHRG ,
216: WIP_CONSTANTS.HOLD ,
217: WIP_CONSTANTS.CANCELLED ,

Line 214: WIP_CONSTANTS.COMP_CHRG,

210: AND DJ.STATUS_TYPE IN
211: -- (1,3,4,5,6,7,9,11,15)
212: (WIP_CONSTANTS.UNRELEASED,
213: WIP_CONSTANTS.RELEASED,
214: WIP_CONSTANTS.COMP_CHRG,
215: WIP_CONSTANTS.COMP_NOCHRG ,
216: WIP_CONSTANTS.HOLD ,
217: WIP_CONSTANTS.CANCELLED ,
218: WIP_CONSTANTS.FAIL_BOM,

Line 215: WIP_CONSTANTS.COMP_NOCHRG ,

211: -- (1,3,4,5,6,7,9,11,15)
212: (WIP_CONSTANTS.UNRELEASED,
213: WIP_CONSTANTS.RELEASED,
214: WIP_CONSTANTS.COMP_CHRG,
215: WIP_CONSTANTS.COMP_NOCHRG ,
216: WIP_CONSTANTS.HOLD ,
217: WIP_CONSTANTS.CANCELLED ,
218: WIP_CONSTANTS.FAIL_BOM,
219: WIP_CONSTANTS.FAIL_ROUT,

Line 216: WIP_CONSTANTS.HOLD ,

212: (WIP_CONSTANTS.UNRELEASED,
213: WIP_CONSTANTS.RELEASED,
214: WIP_CONSTANTS.COMP_CHRG,
215: WIP_CONSTANTS.COMP_NOCHRG ,
216: WIP_CONSTANTS.HOLD ,
217: WIP_CONSTANTS.CANCELLED ,
218: WIP_CONSTANTS.FAIL_BOM,
219: WIP_CONSTANTS.FAIL_ROUT,
220: WIP_CONSTANTS.FAIL_CLOSE

Line 217: WIP_CONSTANTS.CANCELLED ,

213: WIP_CONSTANTS.RELEASED,
214: WIP_CONSTANTS.COMP_CHRG,
215: WIP_CONSTANTS.COMP_NOCHRG ,
216: WIP_CONSTANTS.HOLD ,
217: WIP_CONSTANTS.CANCELLED ,
218: WIP_CONSTANTS.FAIL_BOM,
219: WIP_CONSTANTS.FAIL_ROUT,
220: WIP_CONSTANTS.FAIL_CLOSE
221: )

Line 218: WIP_CONSTANTS.FAIL_BOM,

214: WIP_CONSTANTS.COMP_CHRG,
215: WIP_CONSTANTS.COMP_NOCHRG ,
216: WIP_CONSTANTS.HOLD ,
217: WIP_CONSTANTS.CANCELLED ,
218: WIP_CONSTANTS.FAIL_BOM,
219: WIP_CONSTANTS.FAIL_ROUT,
220: WIP_CONSTANTS.FAIL_CLOSE
221: )
222: AND ( p_class_type IS NULL OR DJ.CLASS_CODE IN ( SELECT CLASS_CODE

Line 219: WIP_CONSTANTS.FAIL_ROUT,

215: WIP_CONSTANTS.COMP_NOCHRG ,
216: WIP_CONSTANTS.HOLD ,
217: WIP_CONSTANTS.CANCELLED ,
218: WIP_CONSTANTS.FAIL_BOM,
219: WIP_CONSTANTS.FAIL_ROUT,
220: WIP_CONSTANTS.FAIL_CLOSE
221: )
222: AND ( p_class_type IS NULL OR DJ.CLASS_CODE IN ( SELECT CLASS_CODE
223: FROM WIP_ACCOUNTING_CLASSES

Line 220: WIP_CONSTANTS.FAIL_CLOSE

216: WIP_CONSTANTS.HOLD ,
217: WIP_CONSTANTS.CANCELLED ,
218: WIP_CONSTANTS.FAIL_BOM,
219: WIP_CONSTANTS.FAIL_ROUT,
220: WIP_CONSTANTS.FAIL_CLOSE
221: )
222: AND ( p_class_type IS NULL OR DJ.CLASS_CODE IN ( SELECT CLASS_CODE
223: FROM WIP_ACCOUNTING_CLASSES
224: WHERE CLASS_TYPE = p_class_type

Line 310: (WIP_CONSTANTS.UNRELEASED,

306: FROM WIP_DJ_CLOSE_TEMP WDCT
307: WHERE WDCT.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
308: AND DJ.STATUS_TYPE IN
309: -- (1,3,4,5,6,7,9,11,15)
310: (WIP_CONSTANTS.UNRELEASED,
311: WIP_CONSTANTS.RELEASED,
312: WIP_CONSTANTS.COMP_CHRG,
313: WIP_CONSTANTS.COMP_NOCHRG ,
314: WIP_CONSTANTS.HOLD ,

Line 311: WIP_CONSTANTS.RELEASED,

307: WHERE WDCT.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
308: AND DJ.STATUS_TYPE IN
309: -- (1,3,4,5,6,7,9,11,15)
310: (WIP_CONSTANTS.UNRELEASED,
311: WIP_CONSTANTS.RELEASED,
312: WIP_CONSTANTS.COMP_CHRG,
313: WIP_CONSTANTS.COMP_NOCHRG ,
314: WIP_CONSTANTS.HOLD ,
315: WIP_CONSTANTS.CANCELLED ,

Line 312: WIP_CONSTANTS.COMP_CHRG,

308: AND DJ.STATUS_TYPE IN
309: -- (1,3,4,5,6,7,9,11,15)
310: (WIP_CONSTANTS.UNRELEASED,
311: WIP_CONSTANTS.RELEASED,
312: WIP_CONSTANTS.COMP_CHRG,
313: WIP_CONSTANTS.COMP_NOCHRG ,
314: WIP_CONSTANTS.HOLD ,
315: WIP_CONSTANTS.CANCELLED ,
316: WIP_CONSTANTS.FAIL_BOM,

Line 313: WIP_CONSTANTS.COMP_NOCHRG ,

309: -- (1,3,4,5,6,7,9,11,15)
310: (WIP_CONSTANTS.UNRELEASED,
311: WIP_CONSTANTS.RELEASED,
312: WIP_CONSTANTS.COMP_CHRG,
313: WIP_CONSTANTS.COMP_NOCHRG ,
314: WIP_CONSTANTS.HOLD ,
315: WIP_CONSTANTS.CANCELLED ,
316: WIP_CONSTANTS.FAIL_BOM,
317: WIP_CONSTANTS.FAIL_ROUT,

Line 314: WIP_CONSTANTS.HOLD ,

310: (WIP_CONSTANTS.UNRELEASED,
311: WIP_CONSTANTS.RELEASED,
312: WIP_CONSTANTS.COMP_CHRG,
313: WIP_CONSTANTS.COMP_NOCHRG ,
314: WIP_CONSTANTS.HOLD ,
315: WIP_CONSTANTS.CANCELLED ,
316: WIP_CONSTANTS.FAIL_BOM,
317: WIP_CONSTANTS.FAIL_ROUT,
318: WIP_CONSTANTS.FAIL_CLOSE

Line 315: WIP_CONSTANTS.CANCELLED ,

311: WIP_CONSTANTS.RELEASED,
312: WIP_CONSTANTS.COMP_CHRG,
313: WIP_CONSTANTS.COMP_NOCHRG ,
314: WIP_CONSTANTS.HOLD ,
315: WIP_CONSTANTS.CANCELLED ,
316: WIP_CONSTANTS.FAIL_BOM,
317: WIP_CONSTANTS.FAIL_ROUT,
318: WIP_CONSTANTS.FAIL_CLOSE
319: )

Line 316: WIP_CONSTANTS.FAIL_BOM,

312: WIP_CONSTANTS.COMP_CHRG,
313: WIP_CONSTANTS.COMP_NOCHRG ,
314: WIP_CONSTANTS.HOLD ,
315: WIP_CONSTANTS.CANCELLED ,
316: WIP_CONSTANTS.FAIL_BOM,
317: WIP_CONSTANTS.FAIL_ROUT,
318: WIP_CONSTANTS.FAIL_CLOSE
319: )
320: AND ( p_class_type IS NULL OR

Line 317: WIP_CONSTANTS.FAIL_ROUT,

313: WIP_CONSTANTS.COMP_NOCHRG ,
314: WIP_CONSTANTS.HOLD ,
315: WIP_CONSTANTS.CANCELLED ,
316: WIP_CONSTANTS.FAIL_BOM,
317: WIP_CONSTANTS.FAIL_ROUT,
318: WIP_CONSTANTS.FAIL_CLOSE
319: )
320: AND ( p_class_type IS NULL OR
321: DJ.CLASS_CODE IN ( SELECT CLASS_CODE

Line 318: WIP_CONSTANTS.FAIL_CLOSE

314: WIP_CONSTANTS.HOLD ,
315: WIP_CONSTANTS.CANCELLED ,
316: WIP_CONSTANTS.FAIL_BOM,
317: WIP_CONSTANTS.FAIL_ROUT,
318: WIP_CONSTANTS.FAIL_CLOSE
319: )
320: AND ( p_class_type IS NULL OR
321: DJ.CLASS_CODE IN ( SELECT CLASS_CODE
322: FROM WIP_ACCOUNTING_CLASSES

Line 435: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

431:
432: --
433: -- Bug 5345660 exitPoint for normal exit.
434: --
435: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
436: wip_logger.exitPoint(
437: p_procName => 'wip_close_priv.populate_close_temp',
438: p_procReturnStatus => x_returnStatus,
439: p_msg => 'procedure normal exit',

Line 450: IF (l_logLevel <= wip_constants.trace_logging) THEN

446: WHEN others THEN
447: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
448: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
449:
450: IF (l_logLevel <= wip_constants.trace_logging) THEN
451: wip_logger.exitPoint(p_procName=>'wip_close_priv.populate_close_temp',
452: p_procReturnStatus => x_returnStatus,
453: p_msg => l_msg,
454: x_returnStatus => l_return_Status);

Line 487: IF (l_logLevel <= wip_constants.trace_logging) THEN

483: l_msg_count NUMBER ;
484: l_msg_data VARCHAR2(200);
485: l_msg VARCHAR(240);
486: BEGIN
487: IF (l_logLevel <= wip_constants.trace_logging) THEN
488: l_params(1).paramName := 'p_from_release_date';
489: l_params(1).paramValue := p_from_release_date ;
490: l_params(2).paramName := 'p_to_release_date';
491: l_params(2).paramValue := p_to_release_date ;

Line 611: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

607: fnd_file.put_line(FND_FILE.LOG,'x_from_completion_date : '||to_char(x_from_completion_date));
608: fnd_file.put_line(FND_FILE.LOG,'x_to_completion_date : '||to_char(x_to_completion_date));
609: fnd_file.put_line(FND_FILE.LOG,'x_act_close_date : '||to_char(x_act_close_date));
610:
611: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
612: wip_logger.exitPoint(
613: p_procName => 'wip_close_priv.time_zone_conversions',
614: p_procReturnStatus => x_returnStatus,
615: p_msg => 'procedure normal exit',

Line 623: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

619: WHEN others THEN
620: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
621: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
622:
623: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
624: wip_logger.exitPoint(
625: p_procName=>'wip_close_priv.time_zone_conversions',
626: p_procReturnStatus => x_returnStatus,
627: p_msg => l_msg,

Line 655: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

651: l_failed_ids dbms_sql.number_table;
652:
653: BEGIN
654:
655: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
656: l_params(1).paramName := 'p_organization_id';
657: l_params(1).paramValue := p_organization_id;
658: l_params(2).paramName := 'p_group_id';
659: l_params(2).paramValue := p_group_id;

Line 700: SET status_type = WIP_CONSTANTS.FAIL_CLOSE

696: x_returnstatus := FND_API.G_RET_STS_ERROR;
697:
698: FORALL i IN l_failed_ids.FIRST .. l_failed_ids.LAST
699: UPDATE wip_discrete_jobs
700: SET status_type = WIP_CONSTANTS.FAIL_CLOSE
701: WHERE organization_id = p_organization_id AND
702: wip_entity_id = l_failed_ids(i);
703:
704: l_failed_ids.DELETE;

Line 710: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

706:
707: --
708: -- Bug 5345660 exitPoint for normal exit.
709: --
710: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
711: wip_logger.exitPoint(
712: p_procName => 'wip_close_priv.prior_date_release',
713: p_procReturnStatus => x_returnStatus,
714: p_msg => 'procedure normal exit',

Line 723: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

719: WHEN others THEN
720: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
721: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
722:
723: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
724: wip_logger.exitPoint(
725: p_procName=>'wip_close_priv.prior_date_release',
726: p_procReturnStatus => x_returnStatus,
727: p_msg => l_msg,

Line 800: IF (l_logLevel <= wip_constants.trace_logging) THEN

796: l_failed_jobs WIP_DJ_CLOSE_TEMP.WIP_ENTITY_NAME%TYPE ;
797: l_failed_counter NUMBER ;
798: BEGIN
799:
800: IF (l_logLevel <= wip_constants.trace_logging) THEN
801: l_params(1).paramName := 'p_organization_id';
802: l_params(1).paramValue := p_organization_id ;
803: l_params(1).paramName := 'p_group_id';
804: l_params(1).paramValue := p_group_id ;

Line 830: SET STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE

826: EXIT WHEN c_pending_txns%NOTFOUND ;
827: END LOOP ;
828:
829: UPDATE WIP_DISCRETE_JOBS
830: SET STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
831: WHERE WIP_ENTITY_ID IN
832: (SELECT WIP_ENTITY_ID
833: FROM WIP_DJ_CLOSE_TEMP
834: WHERE GROUP_ID = p_group_id

Line 852: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

848:
849: --
850: -- Bug 5345660 exitPoint for normal exit.
851: --
852: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
853: wip_logger.exitPoint(
854: p_procName => 'wip_close_priv.pending_txns',
855: p_procReturnStatus => x_returnStatus,
856: p_msg => 'procedure normal exit',

Line 868: IF (l_logLevel <= wip_constants.trace_logging) THEN

864: END IF;
865: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
866: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
867:
868: IF (l_logLevel <= wip_constants.trace_logging) THEN
869: wip_logger.exitPoint(p_procName=>'wip_close_priv.pending_txns',
870: p_procReturnStatus => x_returnStatus,
871: p_msg => l_msg,
872: x_returnStatus => l_return_Status);

Line 947: IF (l_logLevel <= wip_constants.trace_logging) THEN

943: l_msg VARCHAR(240);
944: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
945: l_failed_counter NUMBER ;
946: BEGIN
947: IF (l_logLevel <= wip_constants.trace_logging) THEN
948: l_params(1).paramName := 'p_organization_id';
949: l_params(1).paramValue := p_organization_id ;
950: l_params(1).paramName := 'p_group_id';
951: l_params(1).paramValue := p_group_id ;

Line 976: SET STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE

972: END IF;
973: end loop;
974:
975: UPDATE WIP_DISCRETE_JOBS
976: SET STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
977: WHERE WIP_ENTITY_ID IN
978: (SELECT WIP_ENTITY_ID
979: FROM WIP_DJ_CLOSE_TEMP
980: WHERE GROUP_ID = p_group_id

Line 994: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

990:
991: --
992: -- Bug 5345660 exitPoint for normal exit.
993: --
994: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
995: wip_logger.exitPoint(
996: p_procName => 'wip_close_priv.pending_clocks',
997: p_procReturnStatus => x_returnStatus,
998: p_msg => 'procedure normal exit',

Line 1010: IF (l_logLevel <= wip_constants.trace_logging) THEN

1006: END IF;
1007: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1008: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1009:
1010: IF (l_logLevel <= wip_constants.trace_logging) THEN
1011: wip_logger.exitPoint(p_procName=>'wip_close_priv.pending_clocks',
1012: p_procReturnStatus => x_returnStatus,
1013: p_msg => l_msg,
1014: x_returnStatus => l_return_Status);

Line 1064: SET STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE

1060: END IF;
1061: end loop;
1062:
1063: UPDATE WIP_DISCRETE_JOBS
1064: SET STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
1065: WHERE WIP_ENTITY_ID IN
1066: (SELECT WIP_ENTITY_ID
1067: FROM WIP_DJ_CLOSE_TEMP
1068: WHERE GROUP_ID = p_group_id

Line 1111: l_propagate_job_change_to_po = WIP_CONSTANTS.YES) THEN

1107: for l_jobRec in c_jobs loop
1108: -- add code to cancel PO/requisitions if exists and applicable
1109: IF(po_code_release_grp.Current_Release >=
1110: po_code_release_grp.PRC_11i_Family_Pack_J AND
1111: l_propagate_job_change_to_po = WIP_CONSTANTS.YES) THEN
1112: -- try to cancel all PO/requisitions associated to the jobs.
1113: wip_osp.cancelPOReq(p_job_id => l_jobRec.wip_entity_id,
1114: p_org_id => p_organization_id,
1115: p_clr_fnd_mes_flag => 'Y',

Line 1169: IF (l_logLevel <= wip_constants.trace_logging) THEN

1165: fnd_file.put_line(FND_FILE.LOG,'Inside Procedure Close Date ');
1166: x_returnStatus := fnd_api.g_ret_sts_success;
1167: l_failed_counter := 0 ;
1168:
1169: IF (l_logLevel <= wip_constants.trace_logging) THEN
1170: l_params(1).paramName := 'p_organization_id';
1171: l_params(1).paramValue := p_organization_id ;
1172: l_params(1).paramName := 'p_group_id';
1173: l_params(1).paramValue := p_group_id ;

Line 1198: SET STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE

1194: END LOOP ;
1195: fnd_file.put_line(FND_FILE.LOG,'Number of failed jobs because of past close date : '||l_failed_counter);
1196:
1197: UPDATE WIP_DISCRETE_JOBS
1198: SET STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
1199: WHERE WIP_ENTITY_ID IN
1200: (SELECT WIP_ENTITY_ID
1201: FROM WIP_DJ_CLOSE_TEMP
1202: WHERE GROUP_ID = p_group_id

Line 1219: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

1215:
1216: --
1217: -- Bug 5345660 exitPoint for normal exit.
1218: --
1219: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1220: wip_logger.exitPoint(
1221: p_procName => 'wip_close_priv.past_close_date',
1222: p_procReturnStatus => x_returnStatus,
1223: p_msg => 'procedure normal exit',

Line 1234: IF (l_logLevel <= wip_constants.trace_logging) THEN

1230: CLOSE c_pending_txns ;
1231: END IF;
1232: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1233: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1234: IF (l_logLevel <= wip_constants.trace_logging) THEN
1235: wip_logger.exitPoint(p_procName=>'wip_close_priv.past_close_date',
1236: p_procReturnStatus => x_returnStatus,
1237: p_msg => l_msg,
1238: x_returnStatus => l_return_Status);

Line 1305: IF (l_logLevel <= wip_constants.trace_logging) THEN

1301:
1302: BEGIN
1303: fnd_file.put_line(FND_FILE.LOG,'Open PO Check');
1304:
1305: IF (l_logLevel <= wip_constants.trace_logging) THEN
1306: l_params(1).paramName := 'p_organization_id';
1307: l_params(1).paramValue := p_organization_id ;
1308: l_params(1).paramName := 'p_group_id';
1309: l_params(1).paramValue := p_group_id ;

Line 1343: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

1339:
1340: --
1341: -- Bug 5345660 exitPoint for normal exit.
1342: --
1343: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1344: wip_logger.exitPoint(
1345: p_procName => 'wip_close_priv.check_open_po',
1346: p_procReturnStatus => x_returnStatus,
1347: p_msg => 'procedure normal exit',

Line 1359: IF (l_logLevel <= wip_constants.trace_logging) THEN

1355: END IF;
1356: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1357: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1358:
1359: IF (l_logLevel <= wip_constants.trace_logging) THEN
1360: wip_logger.exitPoint(p_procName=>'wip_close_priv.check_open_po',
1361: p_procReturnStatus => x_returnStatus,
1362: p_msg => l_msg,
1363: x_returnStatus => l_return_Status);

Line 1412: IF (l_logLevel <= wip_constants.trace_logging) THEN

1408:
1409: BEGIN
1410: fnd_file.put_line(FND_FILE.LOG,'Delivery Quantity Check');
1411:
1412: IF (l_logLevel <= wip_constants.trace_logging) THEN
1413: l_params(1).paramName := 'p_organization_id';
1414: l_params(1).paramValue := p_organization_id ;
1415: l_params(1).paramName := 'p_group_id';
1416: l_params(1).paramValue := p_group_id ;

Line 1448: SET STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE

1444:
1445: fnd_file.put_line(FND_FILE.LOG,'Number of jobs failed in Delivered Quantity : '||to_char( l_failed_counter));
1446: /*Bug 13625290*/
1447: UPDATE WIP_DISCRETE_JOBS
1448: SET STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
1449: WHERE WIP_ENTITY_ID IN
1450: (SELECT WIP_ENTITY_ID
1451: FROM WIP_DJ_CLOSE_TEMP
1452: WHERE GROUP_ID = p_group_id

Line 1465: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

1461: IF (c_delivered_qty%ISOPEN) THEN
1462: CLOSE c_delivered_qty ;
1463: END IF;
1464:
1465: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1466: wip_logger.exitPoint(
1467: p_procName => 'wip_close_priv.check_delivery_qty',
1468: p_procReturnStatus => x_returnStatus,
1469: p_msg => 'procedure normal exit',

Line 1481: IF (l_logLevel <= wip_constants.trace_logging) THEN

1477: END IF;
1478: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1479: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1480:
1481: IF (l_logLevel <= wip_constants.trace_logging) THEN
1482: wip_logger.exitPoint(p_procName=>'wip_close_priv.check_delivery_qty',
1483: p_procReturnStatus => x_returnStatus,
1484: p_msg => l_msg,
1485: x_returnStatus => l_return_Status);

Line 1512: IF (l_logLevel <= wip_constants.trace_logging) THEN

1508:
1509: BEGIN
1510: x_returnStatus := fnd_api.g_ret_sts_success;
1511: fnd_file.put_line(FND_FILE.LOG,'lot validate');
1512: IF (l_logLevel <= wip_constants.trace_logging) THEN
1513: l_params(1).paramName := 'p_organization_id';
1514: l_params(1).paramValue := p_organization_id ;
1515: l_params(1).paramName := 'p_group_id';
1516: l_params(1).paramValue := p_group_id ;

Line 1536: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

1532:
1533: --
1534: -- Bug 5345660 exitPoint for normal exit.
1535: --
1536: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1537: wip_logger.exitPoint(
1538: p_procName => 'wip_close_priv.lot_validate',
1539: p_procReturnStatus => x_returnStatus,
1540: p_msg => 'procedure normal exit',

Line 1548: IF (l_logLevel <= wip_constants.trace_logging) THEN

1544: EXCEPTION
1545: WHEN others THEN
1546: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1547: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1548: IF (l_logLevel <= wip_constants.trace_logging) THEN
1549: wip_logger.exitPoint(p_procName=>'wip_jobclose_priv.lot_validate',
1550: p_procReturnStatus => x_returnStatus,
1551: p_msg => l_msg,
1552: x_returnStatus => l_return_Status);

Line 1607: IF (l_logLevel <= wip_constants.trace_logging) THEN

1603: BEGIN
1604: x_returnStatus := fnd_api.g_ret_sts_success;
1605: fnd_file.put_line(FND_FILE.LOG,'delete Existing reservations');
1606:
1607: IF (l_logLevel <= wip_constants.trace_logging) THEN
1608: l_params(1).paramName := 'p_organization_id';
1609: l_params(1).paramValue := p_organization_id ;
1610: l_params(1).paramName := 'p_group_id';
1611: l_params(1).paramValue := p_group_id ;

Line 1642: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

1638:
1639: --
1640: -- Bug 5345660 exitPoint for normal exit.
1641: --
1642: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1643: wip_logger.exitPoint(
1644: p_procName => 'wip_close_priv.delete_reservation',
1645: p_procReturnStatus => x_returnStatus,
1646: p_msg => 'procedure normal exit',

Line 1658: IF (l_logLevel <= wip_constants.trace_logging) THEN

1654: END IF;
1655: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1656: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1657:
1658: IF (l_logLevel <= wip_constants.trace_logging) THEN
1659: wip_logger.exitPoint(p_procName=>'wip_jobclose_priv.delete_reservation',
1660: p_procReturnStatus => x_returnStatus,
1661: p_msg => l_msg,
1662: x_returnStatus => l_return_Status);

Line 1781: (WIP_CONSTANTS.DISC_CLASS,

1777: AND WDJ.CLASS_CODE = WAC.CLASS_CODE
1778: AND TEMP.GROUP_ID = p_group_id
1779: AND WAC.CLASS_TYPE IN
1780: --(1,3,5,6)
1781: (WIP_CONSTANTS.DISC_CLASS,
1782: WIP_CONSTANTS.NS_ASSET_CLASS,
1783: WIP_CONSTANTS.LOT_CLASS,
1784: WIP_CONSTANTS.EAM_CLASS ) ;
1785:

Line 1782: WIP_CONSTANTS.NS_ASSET_CLASS,

1778: AND TEMP.GROUP_ID = p_group_id
1779: AND WAC.CLASS_TYPE IN
1780: --(1,3,5,6)
1781: (WIP_CONSTANTS.DISC_CLASS,
1782: WIP_CONSTANTS.NS_ASSET_CLASS,
1783: WIP_CONSTANTS.LOT_CLASS,
1784: WIP_CONSTANTS.EAM_CLASS ) ;
1785:
1786: SELECT COUNT(*)

Line 1783: WIP_CONSTANTS.LOT_CLASS,

1779: AND WAC.CLASS_TYPE IN
1780: --(1,3,5,6)
1781: (WIP_CONSTANTS.DISC_CLASS,
1782: WIP_CONSTANTS.NS_ASSET_CLASS,
1783: WIP_CONSTANTS.LOT_CLASS,
1784: WIP_CONSTANTS.EAM_CLASS ) ;
1785:
1786: SELECT COUNT(*)
1787: INTO l_expense_jobs

Line 1784: WIP_CONSTANTS.EAM_CLASS ) ;

1780: --(1,3,5,6)
1781: (WIP_CONSTANTS.DISC_CLASS,
1782: WIP_CONSTANTS.NS_ASSET_CLASS,
1783: WIP_CONSTANTS.LOT_CLASS,
1784: WIP_CONSTANTS.EAM_CLASS ) ;
1785:
1786: SELECT COUNT(*)
1787: INTO l_expense_jobs
1788: FROM WIP_DJ_CLOSE_TEMP TEMP,

Line 1797: AND WAC.CLASS_TYPE = WIP_CONSTANTS.NS_EXPENSE_CLASS ;

1793: AND WDJ.ORGANIZATION_ID = p_organization_id
1794: AND WAC.ORGANIZATION_ID = p_organization_id
1795: AND WDJ.CLASS_CODE = WAC.CLASS_CODE
1796: AND TEMP.GROUP_ID = p_group_id
1797: AND WAC.CLASS_TYPE = WIP_CONSTANTS.NS_EXPENSE_CLASS ;
1798:
1799: -- Bug 4890159. Performance Fix
1800: -- saugupta 1-Jun-06
1801: /*

Line 2066: IF (l_logLevel <= wip_constants.trace_logging) THEN

2062: fnd_file.put_line(FND_FILE.OUTPUT,'WIP DISCRETE JOB CLOSE OUTPUT');
2063: fnd_file.put_line(FND_FILE.OUTPUT,'*****************************');
2064: -- write parameter value to log file
2065:
2066: IF (l_logLevel <= wip_constants.trace_logging) THEN
2067: l_params(1).paramName := 'p_organization_id';
2068: l_params(1).paramValue := p_organization_id ;
2069: l_params(2).paramName := 'p_class_type';
2070: l_params(2).paramValue := p_class_type;

Line 2136: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2132: x_act_close_date => l_act_close_date ,
2133: x_returnstatus => l_return_status
2134: );
2135: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2136: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2137: wip_logger.log(p_msg => 'time zone conversion failed',
2138: x_returnStatus => l_return_Status);
2139: END IF;
2140: RAISE FND_API.G_EXC_ERROR ;

Line 2214: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2210: x_group_id => l_group_id ,
2211: x_ReturnStatus => l_return_status
2212: );
2213: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2214: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2215: wip_logger.log(p_msg => 'populate_close_temp',
2216: x_returnStatus => l_return_Status);
2217: END IF;
2218: RAISE FND_API.G_EXC_ERROR ;

Line 2224: p_new_status => WIP_CONSTANTS.PEND_CLOSE ,

2220:
2221: /*Bug 6908428: Raise workflow notifications for eam workorders for status change to Pending close */
2222: EAM_WorkOrderTransactions_PUB.RAISE_WORKFLOW_STATUS_PEND_CLS(
2223: p_group_id => l_group_id ,
2224: p_new_status => WIP_CONSTANTS.PEND_CLOSE ,
2225: ERRBUF => l_errMsg ,
2226: RETCODE => l_return_status
2227: );
2228:

Line 2230: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2226: RETCODE => l_return_status
2227: );
2228:
2229: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2230: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2231: wip_logger.log(p_msg => 'error during eam update workflow to pending close' || l_errMsg,
2232: x_returnStatus => l_return_Status);
2233: END IF;
2234: RAISE FND_API.G_EXC_ERROR ;

Line 2239: SET status_type = WIP_CONSTANTS.PEND_CLOSE ,

2235: END IF;
2236: /*Bug 6908428*/
2237:
2238: UPDATE wip_discrete_jobs
2239: SET status_type = WIP_CONSTANTS.PEND_CLOSE ,
2240: request_id = fnd_global.conc_request_id ,
2241: last_update_date = sysdate,
2242: last_updated_by = fnd_global.user_id,
2243: last_update_login = fnd_global.login_id,

Line 2256: p_new_status => WIP_CONSTANTS.PEND_CLOSE,

2252: /*Bug 6908428: Updating the status in eam_work_order_details pending close for eam workorders */
2253: EAM_WorkOrderTransactions_PUB.Update_EWOD(
2254: p_group_id => l_group_id,
2255: p_organization_id => p_organization_id,
2256: p_new_status => WIP_CONSTANTS.PEND_CLOSE,
2257: ERRBUF => l_errMsg,
2258: RETCODE => l_return_status
2259: );
2260:

Line 2262: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2258: RETCODE => l_return_status
2259: );
2260:
2261: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2262: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2263: wip_logger.log(p_msg => 'eam update workoder error during pending close ' || l_errMsg,
2264: x_returnStatus => l_return_Status);
2265: END IF;
2266: RAISE FND_API.G_EXC_ERROR ;

Line 2317: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2313: x_warning := 1 ;
2314: --
2315: -- Bug 5345660 Added profile check before invoking wip_logger
2316: --
2317: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2318: wip_logger.log(p_msg => l_msg,
2319: x_returnStatus => l_return_Status);
2320: END IF;
2321: END IF;

Line 2359: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2355: x_warning := 1 ;
2356: --
2357: -- Bug 5345660 Added profile check before invoking wip_logger
2358: --
2359: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2360: wip_logger.log(p_msg => l_msg,
2361: x_returnStatus => l_return_Status);
2362: END IF;
2363: END IF;

Line 2385: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2381: x_warning := 1 ;
2382: --
2383: -- Bug 5345660 Added profile check before invoking wip_logger
2384: --
2385: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2386: wip_logger.log(p_msg => l_msg,
2387: x_returnStatus => l_return_Status);
2388: END IF;
2389: END IF;

Line 2412: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2408: x_warning := 1 ;
2409: --
2410: -- Bug 5345660 Added profile check before invoking wip_logger
2411: --
2412: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2413: wip_logger.log(p_msg => l_msg,
2414: x_returnStatus => l_return_Status);
2415: END IF;
2416: END IF;

Line 2438: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2434: x_warning := 1 ;
2435: --
2436: -- Bug 5345660 Added profile check before invoking wip_logger
2437: --
2438: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2439: wip_logger.log(p_msg => l_msg,
2440: x_returnStatus => l_return_Status);
2441: END IF;
2442: END IF;

Line 2465: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2461: l_msg := fnd_message.get;
2462: --
2463: -- Bug 5345660 Added profile check before invoking wip_logger
2464: --
2465: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2466: wip_logger.log(p_msg => l_msg,
2467: x_returnStatus => l_return_Status);
2468: END IF;
2469: END IF;

Line 2488: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2484: /*Bug 13625290*/
2485: x_warning := 1 ;
2486: fnd_message.set_name('WIP', 'WIP_PO_NOT_DELIVERED');
2487: l_msg := fnd_message.get;
2488: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2489: wip_logger.log(p_msg => 'CHECK_DELIVERY_QTY procedure failed',
2490: x_returnStatus => l_return_Status);
2491: END IF;
2492: END IF;

Line 2505: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2501: x_returnstatus => l_return_status,
2502: p_organization_id => p_organization_id,
2503: p_group_id => l_group_id );
2504: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2505: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2506: wip_logger.log(p_msg => 'LOT_VALIDATE procedure failed',
2507: x_returnStatus => l_return_Status);
2508: END IF;
2509: RAISE FND_API.G_EXC_ERROR ;

Line 2525: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2521: p_organization_id => p_organization_id,
2522: p_group_id => l_group_id );
2523:
2524: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2525: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2526: wip_logger.log(p_msg => 'DELETE_RESERVATIONS procedure failed',
2527: x_returnStatus => l_return_Status);
2528: END IF;
2529: END IF;

Line 2675: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2671: p_org_id => p_organization_id
2672: );
2673: -- Bug 5370550
2674: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2675: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2676: wip_logger.log(p_msg => 'costing function error',
2677: x_returnStatus => l_return_Status);
2678: END IF;
2679: RAISE FND_API.G_EXC_ERROR ;

Line 2688: p_new_status => WIP_CONSTANTS.CLOSED,

2684:
2685: /*Bug 6908428: updating the status of eam workorders in eam_work_order_details to closed and workflow update*/
2686: EAM_WorkOrderTransactions_PUB.RAISE_WORKFLOW_STATUS_PEND_CLS(
2687: p_group_id => l_group_id,
2688: p_new_status => WIP_CONSTANTS.CLOSED,
2689: ERRBUF => l_errMsg,
2690: RETCODE => l_return_Status
2691: );
2692:

Line 2694: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2690: RETCODE => l_return_Status
2691: );
2692:
2693: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2694: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2695: wip_logger.log(p_msg => 'error during eam update workflow to closed' || l_errMsg,
2696: x_returnStatus => l_return_Status);
2697: END IF;
2698: RAISE FND_API.G_EXC_ERROR ;

Line 2704: p_new_status => WIP_CONSTANTS.CLOSED,

2700:
2701: EAM_WorkOrderTransactions_PUB.Update_EWOD(
2702: p_group_id => l_group_id,
2703: p_organization_id => p_organization_id,
2704: p_new_status => WIP_CONSTANTS.CLOSED,
2705: ERRBUF => l_errMsg,
2706: RETCODE => l_return_status
2707: );
2708:

Line 2710: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2706: RETCODE => l_return_status
2707: );
2708:
2709: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2710: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2711: wip_logger.log(p_msg => 'eam update workoder error while job close' || l_errMsg,
2712: x_returnStatus => l_return_Status);
2713: END IF;
2714: RAISE FND_API.G_EXC_ERROR ;

Line 2733: STATUS_TYPE = WIP_CONSTANTS.CLOSED

2729: AND wdct.GROUP_ID = l_group_id),
2730: LAST_UPDATE_DATE = SYSDATE,
2731: last_updated_by = fnd_global.user_id,
2732: last_update_login = fnd_global.login_id,
2733: STATUS_TYPE = WIP_CONSTANTS.CLOSED
2734: WHERE ORGANIZATION_ID = p_organization_id
2735: AND WIP_ENTITY_ID IN (SELECT WIP_ENTITY_ID
2736: FROM WIP_DJ_CLOSE_TEMP
2737: WHERE ORGANIZATION_ID = p_organization_id

Line 2751: WIP_CONSTANTS.EAM,

2747:
2748: UPDATE WIP_ENTITIES
2749: SET ENTITY_TYPE = --DECODE(entity_type,6,7,5,8,3),
2750: DECODE(entity_type,
2751: WIP_CONSTANTS.EAM,
2752: WIP_CONSTANTS.CLOSED_EAM,
2753: WIP_CONSTANTS.LOTBASED ,
2754: WIP_CONSTANTS.CLOSED_OSFM ,
2755: WIP_CONSTANTS.CLOSED_DISC),

Line 2752: WIP_CONSTANTS.CLOSED_EAM,

2748: UPDATE WIP_ENTITIES
2749: SET ENTITY_TYPE = --DECODE(entity_type,6,7,5,8,3),
2750: DECODE(entity_type,
2751: WIP_CONSTANTS.EAM,
2752: WIP_CONSTANTS.CLOSED_EAM,
2753: WIP_CONSTANTS.LOTBASED ,
2754: WIP_CONSTANTS.CLOSED_OSFM ,
2755: WIP_CONSTANTS.CLOSED_DISC),
2756: LAST_UPDATE_DATE = SYSDATE,

Line 2753: WIP_CONSTANTS.LOTBASED ,

2749: SET ENTITY_TYPE = --DECODE(entity_type,6,7,5,8,3),
2750: DECODE(entity_type,
2751: WIP_CONSTANTS.EAM,
2752: WIP_CONSTANTS.CLOSED_EAM,
2753: WIP_CONSTANTS.LOTBASED ,
2754: WIP_CONSTANTS.CLOSED_OSFM ,
2755: WIP_CONSTANTS.CLOSED_DISC),
2756: LAST_UPDATE_DATE = SYSDATE,
2757: last_updated_by = fnd_global.user_id,

Line 2754: WIP_CONSTANTS.CLOSED_OSFM ,

2750: DECODE(entity_type,
2751: WIP_CONSTANTS.EAM,
2752: WIP_CONSTANTS.CLOSED_EAM,
2753: WIP_CONSTANTS.LOTBASED ,
2754: WIP_CONSTANTS.CLOSED_OSFM ,
2755: WIP_CONSTANTS.CLOSED_DISC),
2756: LAST_UPDATE_DATE = SYSDATE,
2757: last_updated_by = fnd_global.user_id,
2758: last_update_login = fnd_global.login_id

Line 2755: WIP_CONSTANTS.CLOSED_DISC),

2751: WIP_CONSTANTS.EAM,
2752: WIP_CONSTANTS.CLOSED_EAM,
2753: WIP_CONSTANTS.LOTBASED ,
2754: WIP_CONSTANTS.CLOSED_OSFM ,
2755: WIP_CONSTANTS.CLOSED_DISC),
2756: LAST_UPDATE_DATE = SYSDATE,
2757: last_updated_by = fnd_global.user_id,
2758: last_update_login = fnd_global.login_id
2759: WHERE ORGANIZATION_ID = p_organization_id

Line 2821: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2817: <>
2818: --
2819: -- Bug 5345660 exitPoint for normal exit.
2820: --
2821: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2822: wip_logger.exitPoint(
2823: p_procName => 'wip_close_priv.wip_close',
2824: p_procReturnStatus => x_returnStatus,
2825: p_msg => 'procedure normal exit',

Line 2842: p_new_status => WIP_CONSTANTS.FAIL_CLOSE,

2838:
2839: /*Bug 6908428: Update the status of eam_work_order_details to failed close and proceed workflow notification*/
2840: EAM_WorkOrderTransactions_PUB.RAISE_WORKFLOW_STATUS_PEND_CLS(
2841: p_group_id => l_group_id,
2842: p_new_status => WIP_CONSTANTS.FAIL_CLOSE,
2843: ERRBUF => l_errMsg,
2844: RETCODE => l_return_Status
2845: );
2846:

Line 2848: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2844: RETCODE => l_return_Status
2845: );
2846:
2847: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2848: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2849: wip_logger.log(p_msg => 'error during eam update workflow to fail closed' || l_errMsg,
2850: x_returnStatus => l_return_Status);
2851: END IF;
2852: RAISE FND_API.G_EXC_ERROR ;

Line 2858: p_new_status => WIP_CONSTANTS.FAIL_CLOSE,

2854:
2855: EAM_WorkOrderTransactions_PUB.Update_EWOD(
2856: p_group_id => l_group_id,
2857: p_organization_id => p_organization_id,
2858: p_new_status => WIP_CONSTANTS.FAIL_CLOSE,
2859: ERRBUF => l_errMsg,
2860: RETCODE => l_return_status
2861: );
2862:

Line 2864: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2860: RETCODE => l_return_status
2861: );
2862:
2863: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2864: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2865: wip_logger.log(p_msg => 'eam update workoder error during fail close' || l_errMsg,
2866: x_returnStatus => l_return_Status);
2867: END IF;
2868: RAISE FND_API.G_EXC_ERROR ;

Line 2878: STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE

2874: UPDATE WIP_DISCRETE_JOBS wdj
2875: SET LAST_UPDATE_DATE = SYSDATE,
2876: last_updated_by = fnd_global.user_id,
2877: last_update_login = fnd_global.login_id,
2878: STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
2879: WHERE ORGANIZATION_ID = p_organization_id
2880: AND WIP_ENTITY_ID IN (SELECT WIP_ENTITY_ID
2881: FROM WIP_DJ_CLOSE_TEMP
2882: WHERE ORGANIZATION_ID = p_organization_id

Line 2895: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

2891: --
2892: -- Bug 5345660 exitPoint for exception exit.
2893: --
2894: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
2895: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2896: wip_logger.exitPoint(
2897: p_procName => 'wip_close_priv.wip_close',
2898: p_procReturnStatus => x_returnStatus,
2899: p_msg => l_msg,