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.WSM_INFINITE_SCHEDULER_PVT dependencies on WIP_CONSTANTS

Line 91: -- - If p_scheduleMode = WIP_CONSTANTS.CURRENT_OP,

87: -- MIDPOINT_BACKWARDS CONSTANT NUMBER := 8;
88: -- CURRENT_OP CONSTANT NUMBER := 9;
89: -- CURRENT_SUB_GRP CONSTANT NUMBER := 11;
90: --
91: -- - If p_scheduleMode = WIP_CONSTANTS.CURRENT_OP,
92: -- p_opSeqNum must be given, only operation
93: -- p_opSeqNum will be scheduled
94: -- - If p_scheduleMode = WIP_CONSTANTS.MIDPOINT,
95: -- p_opSeqNum must be given, all the current and

Line 94: -- - If p_scheduleMode = WIP_CONSTANTS.MIDPOINT,

90: --
91: -- - If p_scheduleMode = WIP_CONSTANTS.CURRENT_OP,
92: -- p_opSeqNum must be given, only operation
93: -- p_opSeqNum will be scheduled
94: -- - If p_scheduleMode = WIP_CONSTANTS.MIDPOINT,
95: -- p_opSeqNum must be given, all the current and
96: -- future operations will be scheduled
97: -- - If p_scheduleMode = WIP_CONSTANTS.MIDPOINT_FORWARDS,
98: -- p_opSeqNum must be given, all operations after and

Line 97: -- - If p_scheduleMode = WIP_CONSTANTS.MIDPOINT_FORWARDS,

93: -- p_opSeqNum will be scheduled
94: -- - If p_scheduleMode = WIP_CONSTANTS.MIDPOINT,
95: -- p_opSeqNum must be given, all the current and
96: -- future operations will be scheduled
97: -- - If p_scheduleMode = WIP_CONSTANTS.MIDPOINT_FORWARDS,
98: -- p_opSeqNum must be given, all operations after and
99: -- include p_opSeqNum will be scheduled
100: -- - If p_scheduleMode = WIP_CONSTANTS.MIDPOINT_BACKWARDS,
101: -- p_opSeqNum must be given, all operations before and

Line 100: -- - If p_scheduleMode = WIP_CONSTANTS.MIDPOINT_BACKWARDS,

96: -- future operations will be scheduled
97: -- - If p_scheduleMode = WIP_CONSTANTS.MIDPOINT_FORWARDS,
98: -- p_opSeqNum must be given, all operations after and
99: -- include p_opSeqNum will be scheduled
100: -- - If p_scheduleMode = WIP_CONSTANTS.MIDPOINT_BACKWARDS,
101: -- p_opSeqNum must be given, all operations before and
102: -- include p_opSeqNum will be scheduled
103: -- - If p_scheduleMode = WIP_CONSTANTS.CURRENT_SUB_GRP,
104: -- p_opSeqNum and p_resSeqNum must be given, only

Line 103: -- - If p_scheduleMode = WIP_CONSTANTS.CURRENT_SUB_GRP,

99: -- include p_opSeqNum will be scheduled
100: -- - If p_scheduleMode = WIP_CONSTANTS.MIDPOINT_BACKWARDS,
101: -- p_opSeqNum must be given, all operations before and
102: -- include p_opSeqNum will be scheduled
103: -- - If p_scheduleMode = WIP_CONSTANTS.CURRENT_SUB_GRP,
104: -- p_opSeqNum and p_resSeqNum must be given, only
105: -- resources with the same (substitute_group_number,
106: -- replacement_group_number) as this resource will be
107: -- scheduled

Line 108: -- - If p_scheduleMode = WIP_CONSTANTS.FORWARDS, all the

104: -- p_opSeqNum and p_resSeqNum must be given, only
105: -- resources with the same (substitute_group_number,
106: -- replacement_group_number) as this resource will be
107: -- scheduled
108: -- - If p_scheduleMode = WIP_CONSTANTS.FORWARDS, all the
109: -- current and future operations will be forward
110: -- scheduled,
111: -- p_startDate must be given
112: -- - If p_scheduleMode = WIP_CONSTANTS.BACKWARDS, all the

Line 112: -- - If p_scheduleMode = WIP_CONSTANTS.BACKWARDS, all the

108: -- - If p_scheduleMode = WIP_CONSTANTS.FORWARDS, all the
109: -- current and future operations will be forward
110: -- scheduled,
111: -- p_startDate must be given
112: -- - If p_scheduleMode = WIP_CONSTANTS.BACKWARDS, all the
113: -- current and future operations will be backward
114: -- scheduled,
115: -- p_endDate must be given
116: --

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

187: begin
188:
189: l_stmt_num := 5;
190: savepoint SP_WSMIFS_0;
191: if (l_logLevel <= wip_constants.trace_logging) then
192: l_params(1).paramName := 'p_wipEntityID';
193: l_params(1).paramValue := p_wipEntityID;
194: l_params(2).paramName := 'p_orgID';
195: l_params(2).paramValue := p_orgID;

Line 221: if (l_logLevel <= wip_constants.full_logging) then

217: if(fnd_api.to_boolean(nvl(p_initMsgList, fnd_api.g_true))) then
218: fnd_msg_pub.initialize;
219: end if;
220:
221: if (l_logLevel <= wip_constants.full_logging) then
222: wip_logger.log('reading lot based job...', l_retStatus);
223: end if;
224:
225: l_copy_type := WSMPUTIL.get_internal_copy_type(p_wipEntityID);

Line 291: if(l_job_status = WIP_CONSTANTS.UNRELEASED) then

287: into l_job_status
288: from wip_discrete_jobs
289: where wip_entity_id = p_wipEntityID;
290:
291: if(l_job_status = WIP_CONSTANTS.UNRELEASED) then
292: l_stmt_num := 30.2;
293: -- get OP_SEQ_NUM_INCREMENT
294: select nvl(OP_SEQ_NUM_INCREMENT, 10)
295: into l_op_seq_incr

Line 302: else -- l_job_status <> WIP_CONSTANTS.UNRELEASED

298:
299: l_curJobOpSeqNum := l_op_seq_incr;
300: l_curJobOpSeqid := l_strRtgOpSeqId;
301:
302: else -- l_job_status <> WIP_CONSTANTS.UNRELEASED
303: if( p_opSeqNum < 0 and p_scheduleMode = WIP_CONSTANTS.CURRENT_OP) then
304: -- will trust parameter given by caller
305: l_stmt_num := 30.3;
306: -- get current operation in WO

Line 303: if( p_opSeqNum < 0 and p_scheduleMode = WIP_CONSTANTS.CURRENT_OP) then

299: l_curJobOpSeqNum := l_op_seq_incr;
300: l_curJobOpSeqid := l_strRtgOpSeqId;
301:
302: else -- l_job_status <> WIP_CONSTANTS.UNRELEASED
303: if( p_opSeqNum < 0 and p_scheduleMode = WIP_CONSTANTS.CURRENT_OP) then
304: -- will trust parameter given by caller
305: l_stmt_num := 30.3;
306: -- get current operation in WO
307: select operation_seq_num,

Line 327: end if; -- l_job_status <> WIP_CONSTANTS.UNRELEASED

323: and (quantity_in_queue <> 0 or
324: quantity_running <> 0 or
325: quantity_waiting_to_move <> 0);
326: end if;
327: end if; -- l_job_status <> WIP_CONSTANTS.UNRELEASED
328:
329: --OPTII-PERF: Check if charges exists is already known
330: -- call discrete_charges_exist
331: if p_charges_exist = 1 THEN

Line 337: if(l_job_status = WIP_CONSTANTS.UNRELEASED) then

333: elsif p_charges_exist = 2 THEN
334: g_discrete_charges_exist := false;
335: else
336: --charges exist is NULL..
337: if(l_job_status = WIP_CONSTANTS.UNRELEASED) then
338: g_discrete_charges_exist := false;
339: elsif(l_job_status IN (WIP_CONSTANTS.COMPLETED, WIP_CONSTANTS.CLOSED)) then
340: g_discrete_charges_exist := true;
341: else

Line 339: elsif(l_job_status IN (WIP_CONSTANTS.COMPLETED, WIP_CONSTANTS.CLOSED)) then

335: else
336: --charges exist is NULL..
337: if(l_job_status = WIP_CONSTANTS.UNRELEASED) then
338: g_discrete_charges_exist := false;
339: elsif(l_job_status IN (WIP_CONSTANTS.COMPLETED, WIP_CONSTANTS.CLOSED)) then
340: g_discrete_charges_exist := true;
341: else
342: g_discrete_charges_exist := WSM_LBJ_INTERFACE_PVT.discrete_charges_exist(
343: p_wipEntityID,

Line 382: if (l_logLevel <= wip_constants.full_logging) then

378: else
379: g_update_current_op := false;
380: end if;
381:
382: if (l_logLevel <= wip_constants.full_logging) then
383: if g_update_current_op then
384: wip_logger.log('schedule: g_update_current_op = true', l_retStatus);
385: else
386: wip_logger.log('schedule: g_update_current_op = false', l_retStatus);

Line 425: if (l_logLevel <= wip_constants.full_logging) then

421: raise e_skip_sche;
422: end if;
423: -- EA: BUG3195950
424:
425: if (l_logLevel <= wip_constants.full_logging) then
426: wip_logger.log('scheduling lot based job...', l_retStatus);
427: end if;
428:
429: if(l_resTbls.opSeqNum.count <> 0) then

Line 445: if (l_logLevel <= wip_constants.full_logging) then

441: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
442: raise fnd_api.g_exc_unexpected_error;
443: end if;
444:
445: if (l_logLevel <= wip_constants.full_logging) then
446: wip_logger.log('writing lot based job...', l_retStatus);
447: end if;
448: end if;
449:

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

468: raise fnd_api.g_exc_unexpected_error;
469: end if;
470:
471: l_stmt_num := 70;
472: if (l_logLevel <= wip_constants.trace_logging) then
473: wip_logger.exitPoint(
474: p_procName => 'wsm_infinite_scheduler_pvt.schedule',
475: p_procReturnStatus => x_returnStatus,
476: p_msg => 'success',

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

501: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
502: wip_utilities.get_message_stack(
503: p_msg => x_errorMsg,
504: p_delete_stack => fnd_api.g_false);
505: if (l_logLevel <= wip_constants.trace_logging) then
506: wip_logger.exitPoint(
507: p_procName => 'wsm_infinite_scheduler_pvt.schedule',
508: p_procReturnStatus => x_returnStatus,
509: p_msg => 'error: ' || x_errorMsg,

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

525: p_error_text => SQLERRM);
526: wip_utilities.get_message_stack(
527: p_msg => x_errorMsg,
528: p_delete_stack => fnd_api.g_false);
529: if (l_logLevel <= wip_constants.trace_logging) then
530: wip_logger.exitPoint(
531: p_procName => 'wsm_infinite_scheduler_pvt.schedule',
532: p_procReturnStatus => x_returnStatus,
533: p_msg => 'unexp error: ' || x_errorMsg,

Line 693: * decode(wor.basis_type, wip_constants.per_lot, 1, wdj.start_quantity)

689: bdr.available_24_hours_flag,
690: --Bug 4554494
691: --l_hrVal * nvl(muc.conversion_rate,0)
692: nvl(muc.conversion_rate,0)
693: * decode(wor.basis_type, wip_constants.per_lot, 1, wdj.start_quantity)
694: * wor.usage_rate_or_amount
695: / ( 24 * nvl(l_hrVal,1)*least(wor.assigned_units, bdr.capacity_units)
696: * nvl(bdr.utilization, 1) * nvl(bdr.efficiency, 1) ),
697: wor.basis_type,

Line 751: * decode(wcor.basis_type, wip_constants.per_lot, 1, wdj.start_quantity)

747: bdr.available_24_hours_flag,
748: --Bug 4554494
749: --l_hrVal * nvl(muc.conversion_rate,0)
750: nvl(muc.conversion_rate,0)
751: * decode(wcor.basis_type, wip_constants.per_lot, 1, wdj.start_quantity)
752: * wcor.usage_rate_or_amount
753: / ( 24 * nvl(l_hrVal,1)* least(wcor.assigned_units, bdr.capacity_units)
754: * nvl(bdr.utilization, 1) * nvl(bdr.efficiency, 1) ),
755: wcor.basis_type,

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

824:
825: BEGIN
826:
827: l_stat_num := 10;
828: if (l_logLevel <= wip_constants.trace_logging) then
829: l_params(1).paramName := 'p_wipEntityID';
830: l_params(1).paramValue := p_wipEntityID;
831: l_params(2).paramName := 'p_orgID';
832: l_params(2).paramValue := p_orgID;

Line 1027: if(p_scheduleMode = WIP_CONSTANTS.FORWARDS) then

1023: end if;
1024:
1025: l_stat_num := 70;
1026: -- set the parameters to open the cursor
1027: if(p_scheduleMode = WIP_CONSTANTS.FORWARDS) then
1028: --if(l_cur_job_op_seq IS NOT NULL) then
1029: -- p_opSeqNum := -l_cur_job_op_seq;
1030: --else
1031: -- p_opSeqNum := p_strRtgOpSeqNum;

Line 1035: elsif(p_scheduleMode = WIP_CONSTANTS.BACKWARDS) then

1031: -- p_opSeqNum := p_strRtgOpSeqNum;
1032: --end if;
1033: p_opSeqNum := null;
1034: p_resSeqNum := null;
1035: elsif(p_scheduleMode = WIP_CONSTANTS.BACKWARDS) then
1036: --p_opSeqNum := p_endRtgOpSeqNum;
1037: p_opSeqNum := null;
1038: p_resSeqNum := null;
1039: elsif(p_scheduleMode = WIP_CONSTANTS.MIDPOINT_FORWARDS) then

Line 1039: elsif(p_scheduleMode = WIP_CONSTANTS.MIDPOINT_FORWARDS) then

1035: elsif(p_scheduleMode = WIP_CONSTANTS.BACKWARDS) then
1036: --p_opSeqNum := p_endRtgOpSeqNum;
1037: p_opSeqNum := null;
1038: p_resSeqNum := null;
1039: elsif(p_scheduleMode = WIP_CONSTANTS.MIDPOINT_FORWARDS) then
1040: if( p_opSeqNum > 0) then
1041: -- should always ignore current op
1042: l_cur_job_op_seq := null;
1043: l_fst_rec_seq_num := l_the_rec_seq_num;

Line 1045: elsif(p_scheduleMode = WIP_CONSTANTS.MIDPOINT_BACKWARDS) then

1041: -- should always ignore current op
1042: l_cur_job_op_seq := null;
1043: l_fst_rec_seq_num := l_the_rec_seq_num;
1044: end if;
1045: elsif(p_scheduleMode = WIP_CONSTANTS.MIDPOINT_BACKWARDS) then
1046: if(p_opSeqNum > 0) then
1047: -- should fetch up to p_opSeqNum
1048: l_lst_rec_seq_num := l_the_rec_seq_num;
1049: else

Line 1052: elsif(p_scheduleMode in (WIP_CONSTANTS.CURRENT_OP,

1048: l_lst_rec_seq_num := l_the_rec_seq_num;
1049: else
1050: l_fst_rec_seq_num := null;
1051: end if;
1052: elsif(p_scheduleMode in (WIP_CONSTANTS.CURRENT_OP,
1053: WIP_CONSTANTS.CURRENT_SUB_GRP)) then
1054: if(p_opSeqNum > 0) then
1055: -- should always ignore current op, fetch p_opSeqNum only
1056: l_cur_job_op_seq := null;

Line 1053: WIP_CONSTANTS.CURRENT_SUB_GRP)) then

1049: else
1050: l_fst_rec_seq_num := null;
1051: end if;
1052: elsif(p_scheduleMode in (WIP_CONSTANTS.CURRENT_OP,
1053: WIP_CONSTANTS.CURRENT_SUB_GRP)) then
1054: if(p_opSeqNum > 0) then
1055: -- should always ignore current op, fetch p_opSeqNum only
1056: l_cur_job_op_seq := null;
1057: l_fst_rec_seq_num := l_the_rec_seq_num;

Line 1063: if(p_scheduleMode = WIP_CONSTANTS.CURRENT_SUB_GRP) then

1059: else
1060: l_fst_rec_seq_num := null;
1061: end if;
1062:
1063: if(p_scheduleMode = WIP_CONSTANTS.CURRENT_SUB_GRP) then
1064: l_res_seq_num := p_resSeqNum;
1065: if(p_opSeqNum > 0) then
1066: l_stat_num := 70.1;
1067: select substitute_group_num,

Line 1118: if(l_baseTypes(l_idx) <> wip_constants.per_lot) then

1114: -- update totalDaysUsg based on scheduled quantity
1115: l_idx := x_resTbls.opSeqNum.first;
1116: while (l_idx IS NOT NULL)
1117: loop
1118: if(l_baseTypes(l_idx) <> wip_constants.per_lot) then
1119: x_resTbls.totalDaysUsg(l_idx) :=
1120: x_resTbls.totalDaysUsg(l_idx)
1121: * g_opQty(x_resTbls.opSeqNum(l_idx))/l_job_start_qty;
1122: end if;

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

1200: close c_WCORI;
1201: end if;
1202: end if;
1203:
1204: if (l_logLevel <= wip_constants.trace_logging) then
1205: wip_logger.exitPoint(p_procName => 'wsm_infinite_scheduler_pvt.wsmJobReader',
1206: p_procReturnStatus => x_returnStatus,
1207: p_msg => 'success',
1208: x_returnStatus => l_retStatus);

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

1210:
1211: EXCEPTION
1212: -- BA: BUG3195950
1213: when e_skip_sche then
1214: if (l_logLevel <= wip_constants.trace_logging) then
1215: wip_logger.exitPoint(p_procName => 'wsm_infinite_scheduler_pvt.wsmJobReader',
1216: p_procReturnStatus => x_returnStatus,
1217: p_msg => 'success',
1218: x_returnStatus => l_retStatus);

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

1224: fnd_msg_pub.add_exc_msg(
1225: p_pkg_name => 'wsm_infinite_scheduler_pvt',
1226: p_procedure_name => 'wsmJobReader',
1227: p_error_text => SQLERRM || ' (reader #' || l_stat_num || ')' );
1228: if (l_logLevel <= wip_constants.trace_logging) then
1229: wip_logger.exitPoint(
1230: p_procName => 'wsm_infinite_scheduler_pvt.wsmJobReader',
1231: p_procReturnStatus => x_returnStatus,
1232: p_msg => 'unexp error: ' || SQLERRM || ' (reader #' || l_stat_num || ')',

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

1297:
1298: x_returnCode := 0;
1299:
1300: l_stat_num := 10;
1301: if (l_logLevel <= wip_constants.trace_logging) then
1302: l_params(1).paramName := 'p_wipEntityID';
1303: l_params(1).paramValue := p_wipEntityID;
1304: l_params(2).paramName := 'p_orgID';
1305: l_params(2).paramValue := p_orgID;

Line 1342: if p_scheduleMode = WIP_CONSTANTS.CURRENT_SUB_GRP then

1338:
1339: if(x_resTbls.opSeqNum.count <> 0) then
1340: l_stat_num := 30;
1341:
1342: if p_scheduleMode = WIP_CONSTANTS.CURRENT_SUB_GRP then
1343:
1344: l_OpStartDate.extend(1);
1345: l_OpEndDate.extend(1);
1346: l_OpQty.extend(1); -- bug 3585783 must initialize this

Line 1381: else -- p_scheduleMode <> WIP_CONSTANTS.CURRENT_SUB_GRP

1377: l_minDate := l_OpStartDate(1);
1378: l_maxDate := l_OpEndDate(1);
1379:
1380:
1381: else -- p_scheduleMode <> WIP_CONSTANTS.CURRENT_SUB_GRP
1382:
1383: l_minDate := null;
1384: l_maxDate := null;
1385: l_minDateYes := null;

Line 1464: end if; -- p_scheduleMode <> WIP_CONSTANTS.CURRENT_SUB_GRP

1460: l_OpEndDate(i) := l_hashOpEDate(l_curOp);
1461: l_OpQty(i) := g_opQty(l_curOp);
1462: end loop;
1463:
1464: end if; -- p_scheduleMode <> WIP_CONSTANTS.CURRENT_SUB_GRP
1465:
1466: else -- x_resTbls.opSeqNum.count = 0
1467: l_stat_num := 40;
1468: l_OpStartDate.extend(p_opTbl.count);

Line 1587: if(l_logLevel <= wip_constants.full_logging) then

1583: program_update_date = l_sysDate
1584: where wip_entity_id = p_wipEntityID
1585: and organization_id = p_orgID;
1586:
1587: if(l_logLevel <= wip_constants.full_logging) then
1588: wip_logger.log('wrote job', l_retStatus);
1589: end if;
1590: end if;
1591:

Line 1613: if(l_logLevel <= wip_constants.full_logging) then

1609: program_update_date = l_sysDate
1610: where wip_entity_id = p_wipEntityID
1611: and organization_id = p_orgID
1612: and operation_seq_num = -p_opTbl(i);
1613: if(l_logLevel <= wip_constants.full_logging) then
1614: wip_logger.log('wrote WO', l_retStatus);
1615: end if;
1616:
1617:

Line 1636: if(l_logLevel <= wip_constants.full_logging) then

1632: program_update_date = l_sysDate
1633: where wip_entity_id = p_wipEntityID
1634: and organization_id = p_orgID
1635: and operation_seq_num = p_opTbl(i);
1636: if(l_logLevel <= wip_constants.full_logging) then
1637: wip_logger.log('wrote WCO', l_retStatus);
1638: end if;
1639:
1640: --bug 6345672: begin

Line 1659: if(l_logLevel <= wip_constants.full_logging) then

1655: where wip_entity_id = p_wipEntityID
1656: and organization_id = p_orgID
1657: and operation_seq_num = -p_opTbl(l_cnt_wo);
1658:
1659: if(l_logLevel <= wip_constants.full_logging) then
1660: wip_logger.log('wrote WCO for current op', l_retStatus);
1661: end if;
1662: end if;
1663: --bug 6345672: end

Line 1682: if(l_logLevel <= wip_constants.full_logging) then

1678: program_update_date = l_sysDate
1679: where wip_entity_id = p_wipEntityID
1680: and organization_id = p_orgID
1681: and operation_seq_num = -p_opTbl(i);
1682: if(l_logLevel <= wip_constants.full_logging) then
1683: wip_logger.log('wrote WRO', l_retStatus);
1684: end if;
1685:
1686: l_stat_num := 100;

Line 1702: if(l_logLevel <= wip_constants.full_logging) then

1698: program_update_date = l_sysDate
1699: where wip_entity_id = p_wipEntityID
1700: and organization_id = p_orgID
1701: and operation_seq_num = p_opTbl(i);
1702: if(l_logLevel <= wip_constants.full_logging) then
1703: wip_logger.log('wrote WCRO', l_retStatus);
1704: end if;
1705:
1706: --bug 6345672: begin

Line 1723: if(l_logLevel <= wip_constants.full_logging) then

1719: where wip_entity_id = p_wipEntityID
1720: and organization_id = p_orgID
1721: and operation_seq_num = -p_opTbl(l_cnt_wo);
1722:
1723: if(l_logLevel <= wip_constants.full_logging) then
1724: wip_logger.log('wrote WCRO for current op', l_retStatus);
1725: end if;
1726: end if;
1727: --bug 6345672: end

Line 1758: if(l_logLevel <= wip_constants.full_logging) then

1754: where wip_entity_id = p_wipEntityID
1755: and organization_id = p_orgID
1756: and operation_seq_num = -x_resTbls.opSeqNum(i)
1757: and resource_seq_num = x_resTbls.resSeqNum(i);
1758: if(l_logLevel <= wip_constants.full_logging) then
1759: wip_logger.log('wrote WOR', l_retStatus);
1760: end if;
1761:
1762: l_stat_num := 120;

Line 1780: if(l_logLevel <= wip_constants.full_logging) then

1776: where wip_entity_id = p_wipEntityID
1777: and organization_id = p_orgID
1778: and operation_seq_num = x_resTbls.opSeqNum(i)
1779: and resource_seq_num = x_resTbls.resSeqNum(i);
1780: if(l_logLevel <= wip_constants.full_logging) then
1781: wip_logger.log('wrote WCOR', l_retStatus);
1782: end if;
1783:
1784: --bug 6345672: begin

Line 1803: if(l_logLevel <= wip_constants.full_logging) then

1799: and organization_id = p_orgID
1800: and operation_seq_num = -x_resTbls.opSeqNum(l_cnt_wor)
1801: and resource_seq_num = x_resTbls.resSeqNum(l_cnt_wor);
1802:
1803: if(l_logLevel <= wip_constants.full_logging) then
1804: wip_logger.log('wrote WCOR for current op', l_retStatus);
1805: end if;
1806: end if;
1807: --bug 6345672: end

Line 1824: if(l_logLevel <= wip_constants.full_logging) then

1820: where wip_entity_id = p_wipEntityID
1821: and organization_id = p_orgID
1822: and operation_seq_num = -x_resTbls.opSeqNum(i)
1823: and resource_seq_num = x_resTbls.resSeqNum(i);
1824: if(l_logLevel <= wip_constants.full_logging) then
1825: wip_logger.log('wrote WORI', l_retStatus);
1826: end if;
1827:
1828: l_stat_num := 140;

Line 1842: if(l_logLevel <= wip_constants.full_logging) then

1838: where wip_entity_id = p_wipEntityID
1839: and organization_id = p_orgID
1840: and operation_seq_num = x_resTbls.opSeqNum(i)
1841: and resource_seq_num = x_resTbls.resSeqNum(i);
1842: if(l_logLevel <= wip_constants.full_logging) then
1843: wip_logger.log('wrote WCORI', l_retStatus);
1844: end if;
1845:
1846: --bug 6345672: begin

Line 1860: if(l_logLevel <= wip_constants.full_logging) then

1856: where wip_entity_id = p_wipEntityID
1857: and organization_id = p_orgID
1858: and operation_seq_num = -x_resTbls.opSeqNum(l_cnt_wor)
1859: and resource_seq_num = x_resTbls.resSeqNum(l_cnt_wor);
1860: if(l_logLevel <= wip_constants.full_logging) then
1861: wip_logger.log('wrote WCORI for current op', l_retStatus);
1862: end if;
1863: end if;
1864: --bug 6345672: end

Line 1919: if(l_logLevel <= wip_constants.full_logging) then

1915: l_progID,
1916: l_sysdate);
1917: end if;
1918: end loop;
1919: if(l_logLevel <= wip_constants.full_logging) then
1920: wip_logger.log('wrote WORU', l_retStatus);
1921: end if;
1922:
1923: l_stat_num := 170;

Line 1975: if(l_logLevel <= wip_constants.full_logging) then

1971: and woru.wip_entity_id = p_wipEntityID
1972: and woru.organization_id = p_orgID
1973: and wori.operation_seq_num = -x_resTbls.opSeqNum(i)
1974: and wori.resource_seq_num = x_resTbls.resSeqNum(i);
1975: if(l_logLevel <= wip_constants.full_logging) then
1976: wip_logger.log('wrote ' || SQL%ROWCOUNT || ' WROU', l_retStatus);
1977: end if;
1978:
1979:

Line 2042: if(l_logLevel <= wip_constants.full_logging) then

2038: l_progID,
2039: l_sysdate);
2040: end if;
2041: end loop;
2042: if(l_logLevel <= wip_constants.full_logging) then
2043: wip_logger.log('wrote WCORU', l_retStatus);
2044: end if;
2045:
2046: --bug 6345672: begin

Line 2090: if(l_logLevel <= wip_constants.full_logging) then

2086: l_progID,
2087: l_sysdate);
2088: end if;
2089:
2090: if(l_logLevel <= wip_constants.full_logging) then
2091: wip_logger.log('wrote WCORU for current op', l_retStatus);
2092: end if;
2093: end if;
2094: --bug 6345672: end

Line 2148: if(l_logLevel <= wip_constants.full_logging) then

2144: and wcoru.wip_entity_id = p_wipEntityID
2145: and wcoru.organization_id = p_orgID
2146: and wcori.operation_seq_num = x_resTbls.opSeqNum(i)
2147: and wcori.resource_seq_num = x_resTbls.resSeqNum(i);
2148: if(l_logLevel <= wip_constants.full_logging) then
2149: wip_logger.log('wrote ' || SQL%ROWCOUNT || ' WCORU', l_retStatus);
2150: end if;
2151:
2152: --bug 6345672: begin

Line 2205: if(l_logLevel <= wip_constants.full_logging) then

2201: and wcoru.wip_entity_id = p_wipEntityID
2202: and wcoru.organization_id = p_orgID
2203: and wcori.operation_seq_num = -x_resTbls.opSeqNum(l_cnt_wor)
2204: and wcori.resource_seq_num = x_resTbls.resSeqNum(l_cnt_wor);
2205: if(l_logLevel <= wip_constants.full_logging) then
2206: wip_logger.log('wrote ' || SQL%ROWCOUNT || ' WCORU for current op', l_retStatus);
2207: end if;
2208:
2209: end if;

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

2210: --bug 6345672: end
2211:
2212: end if;
2213:
2214: if (l_logLevel <= wip_constants.trace_logging) then
2215: wip_logger.exitPoint(
2216: p_procName => 'wsm_infinite_scheduler_pvt.wsmJobWriter',
2217: p_procReturnStatus => x_returnStatus,
2218: p_msg => 'success',

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

2226: fnd_msg_pub.add_exc_msg(
2227: p_pkg_name => 'wsm_infinite_scheduler_pvt',
2228: p_procedure_name => 'wsmJobWriter',
2229: p_error_text => SQLERRM || ' (writer #' || l_stat_num || ')' );
2230: if (l_logLevel <= wip_constants.trace_logging) then
2231: wip_logger.exitPoint(
2232: p_procName => 'wsm_infinite_scheduler_pvt.wsmJobWriter',
2233: p_procReturnStatus => x_returnStatus,
2234: p_msg => 'unexp error: ' || SQLERRM || ' (writer #' || l_stat_num || ')',