[Home] [Help]
14: p_endDate in date,
15: x_serStartOp out nocopy number,
16: x_returnStatus out nocopy varchar2,
17: x_errorMsg out nocopy varchar2) is
18: l_params wip_logger.param_tbl_t;
19: l_procName varchar2(30) := 'explodeRouting';
20: l_logLevel number := to_number(fnd_log.g_current_runtime_level);
21: l_retStatus varchar2(1);
22: l_msg varchar2(240);
55: l_params(8).paramName := 'p_startDate';
56: l_params(8).paramValue := p_startDate;
57: l_params(9).paramName := 'p_endDate';
58: l_params(9).paramValue := p_endDate;
59: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
60: p_params => l_params,
61: x_returnStatus => x_returnStatus);
62: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
63: raise fnd_api.g_exc_unexpected_error;
76: and nvl(cfm_routing_flag, 2) = 2;
77: exception
78: when NO_DATA_FOUND then
79: if(l_logLevel <= wip_constants.trace_logging) then
80: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
81: p_procReturnStatus => 'true',
82: p_msg => 'this item does not have a routing',
83: x_returnStatus => l_retStatus);
84: wip_logger.cleanup(l_retStatus);
80: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
81: p_procReturnStatus => 'true',
82: p_msg => 'this item does not have a routing',
83: x_returnStatus => l_retStatus);
84: wip_logger.cleanup(l_retStatus);
85: end if;
86: return;
87: end;
88: -- Added For Bug 12861546. This was moved from wipbmrtb.pls to here.
112:
113: l_excludeECO := fnd_profile.value('WIP_RELEASED_REVS');
114:
115: if ( l_logLevel <= wip_constants.full_logging ) then
116: wip_logger.log('exclude ECO is: ' || l_excludeECO, l_retStatus);
117: wip_logger.log('RoutingSeqID is: ' || l_routingSeqID, l_retStatus);
118: end if;
119:
120: insert into wip_operations
113: l_excludeECO := fnd_profile.value('WIP_RELEASED_REVS');
114:
115: if ( l_logLevel <= wip_constants.full_logging ) then
116: wip_logger.log('exclude ECO is: ' || l_excludeECO, l_retStatus);
117: wip_logger.log('RoutingSeqID is: ' || l_routingSeqID, l_retStatus);
118: end if;
119:
120: insert into wip_operations
121: (wip_entity_id,
262: where wo.wip_entity_id = p_wipEntityID
263: and wo.organization_id = p_orgID;
264:
265: if ( l_logLevel <= wip_constants.full_logging ) then
266: wip_logger.log('begin to load resources', l_retStatus);
267: end if;
268:
269:
270: insert into wip_operation_resources
391: and ((eng.status_type in (4, 7) and l_excludeECO = 1) or
392: (eng.status_type in (1, 4, 7) and l_excludeECO = 2)))));
393:
394: if ( l_logLevel <= wip_constants.full_logging ) then
395: wip_logger.log('begin to load substitute resources', l_retStatus);
396: end if;
397:
398: select max(resource_seq_num)
399: into l_maxSeq
507: and bsor.resource_id = br.resource_id
508: and nvl(bsor.acd_type, 0) <> 3;
509:
510: if ( l_logLevel <= wip_constants.full_logging ) then
511: wip_logger.log('begin to load attachment', l_retStatus);
512: end if;
513:
514:
515: FOR op_attach IN op_attachments(p_orgID, p_wipEntityID) LOOP
528: END LOOP;
529:
530: /* Added for 12.1.1 Skills Validation project.*/
531: if ( l_logLevel <= wip_constants.full_logging ) then
532: wip_logger.log('begin to load competence', l_retStatus);
533: end if;
534:
535: DELETE FROM WIP_OPERATION_COMPETENCIES
536: WHERE WIP_ENTITY_ID = p_wipEntityID
562: AND BOS.OPERATION_SEQUENCE_ID = WO.OPERATION_SEQUENCE_ID
563: AND BOS.LEVEL_ID = 2;
564:
565: if (l_logLevel <= wip_constants.trace_logging) then
566: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
567: p_procReturnStatus => x_returnStatus,
568: p_msg => 'success',
569: x_returnStatus => l_retStatus);
570: end if;
570: end if;
571: exception
572: when others then
573: if(l_logLevel <= wip_constants.trace_logging) then
574: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
575: p_procReturnStatus => x_returnStatus,
576: p_msg => 'unexp error:' || SQLERRM,
577: x_returnStatus => l_retStatus);
578: end if;
601: p_unitNumber in varchar2 DEFAULT '', /* added for bug 5332615 */
602: x_returnStatus out nocopy varchar2,
603: x_errorMsg out nocopy varchar2) is
604: l_procName varchar2(30) := 'explodeBOM';
605: l_params wip_logger.param_tbl_t;
606: l_logLevel number := to_number(fnd_log.g_current_runtime_level);
607: l_retStatus varchar2(1);
608: l_msg varchar2(240);
609:
662: l_params(12).paramName := 'p_projectID';
663: l_params(12).paramValue := p_projectID;
664: l_params(13).paramName := 'p_taskID';
665: l_params(13).paramValue := p_taskID;
666: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
667: p_params => l_params,
668: x_returnStatus => x_returnStatus);
669: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
670: raise fnd_api.g_exc_unexpected_error;
824: x_returnStatus := fnd_api.g_ret_sts_error;
825: fnd_message.set_name('WIP', 'WIP_COMP_DUP_OP_ONE');
826: fnd_msg_pub.add;
827: if (l_logLevel <= wip_constants.full_logging) then
828: wip_logger.log(p_msg => 'Item ' || l_compTbl(l_count).inventory_item_id ||
829: ' has duplicates in op 1, failed explosion!',
830: x_returnStatus => x_returnStatus);
831:
832:
922: x_msg_data => x_errorMsg );
923:
924: if (x_returnStatus <> fnd_api.g_ret_sts_success) then
925: if (l_logLevel <= wip_constants.full_logging) then
926: wip_logger.log(p_msg => 'Post_Explosion_Cleanup failed for wip_entity_id '||p_wipEntityID,
927: x_returnStatus => x_returnStatus);
928: end if;
929: return;
930: end if;
1030: and nvl(wro.repetitive_schedule_id, -1) = nvl(p_repSchedID, -1)
1031: and wro.organization_id = p_orgID;
1032:
1033: if (l_logLevel <= wip_constants.trace_logging) then
1034: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
1035: p_procReturnStatus => x_returnStatus,
1036: p_msg => 'success',
1037: x_returnStatus => l_retStatus);
1038: end if;
1038: end if;
1039: exception
1040: when fnd_api.g_exc_unexpected_error then
1041: if (l_logLevel <= wip_constants.trace_logging) then
1042: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
1043: p_procReturnStatus => x_returnStatus,
1044: p_msg => 'failed at exploding requirements',
1045: x_returnStatus => l_retStatus); --discard logging return status
1046: end if;
1045: x_returnStatus => l_retStatus); --discard logging return status
1046: end if;
1047: when others then
1048: if(l_logLevel <= wip_constants.trace_logging) then
1049: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
1050: p_procReturnStatus => x_returnStatus,
1051: p_msg => 'unexp error:' || SQLERRM,
1052: x_returnStatus => l_retStatus);
1053: end if;
1064: p_wipEntityID in number,
1065: p_qty in number,
1066: x_returnStatus out nocopy varchar2,
1067: x_errorMsg out nocopy varchar2) is
1068: l_params wip_logger.param_tbl_t;
1069: l_procName varchar2(30) := 'adjustQtyChange';
1070: l_logLevel number := to_number(fnd_log.g_current_runtime_level);
1071: l_msg varchar2(240);
1072: l_retStatus varchar2(1);
1084: l_params(2).paramName := 'p_wipEntityID';
1085: l_params(2).paramValue := p_wipEntityID;
1086: l_params(3).paramName := 'p_qty';
1087: l_params(3).paramValue := p_qty;
1088: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
1089: p_params => l_params,
1090: x_returnStatus => x_returnStatus);
1091: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1092: raise fnd_api.g_exc_unexpected_error;
1107: wip_constants.released,
1108: wip_constants.comp_chrg,
1109: wip_constants.hold) ) then
1110: if(l_logLevel <= wip_constants.trace_logging) then
1111: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
1112: p_procReturnStatus => x_returnStatus,
1113: p_msg => 'no qty change or job status is not right',
1114: x_returnStatus => l_retStatus);
1115: end if;
1134: where organization_id = p_orgID
1135: and wip_entity_id = p_wipEntityID;
1136: /* End of Fix bug 9540544 */
1137: if(l_logLevel <= wip_constants.trace_logging) then
1138: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
1139: p_procReturnStatus => x_returnStatus,
1140: p_msg => 'no operation exist',
1141: x_returnStatus => l_retStatus);
1142: end if;
1214: where organization_id = p_orgID
1215: and wip_entity_id = p_wipEntityID;
1216:
1217: if (l_logLevel <= wip_constants.trace_logging) then
1218: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
1219: p_procReturnStatus => x_returnStatus,
1220: p_msg => 'success',
1221: x_returnStatus => l_retStatus);
1222: end if;
1223:
1224: exception
1225: when others then
1226: if(l_logLevel <= wip_constants.trace_logging) then
1227: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
1228: p_procReturnStatus => x_returnStatus,
1229: p_msg => 'unexp error:' || SQLERRM,
1230: x_returnStatus => l_retStatus);
1231: end if;