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

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

58: if(fnd_api.to_boolean(p_initMsgList)) then
59: fnd_msg_pub.initialize;
60: end if;
61:
62: if (l_logLevel <= wip_constants.trace_logging) then
63: l_params(1).paramName := 'p_txnTmpID';
64: l_params(1).paramValue := p_txnTmpID;
65: wip_logger.entryPoint(p_procName => 'wip_cplProc_priv.processTemp',
66: p_params => l_params,

Line 149: if(l_cplRec.txnMode <> wip_constants.online) then

145: end if;
146:
147: --if the txn mode is online, the form does the over-cpl move as it must do one move for all the
148: --cpl records in the multi-row block. In all other cases, the move is done here.
149: if(l_cplRec.txnMode <> wip_constants.online) then
150: processOverCpl(p_cplRec => l_cplRec,
151: x_returnStatus => x_returnStatus);
152: end if;
153:

Line 160: if(l_cplRec.wipEntityType = wip_constants.repetitive) then

156: raise fnd_api.g_exc_unexpected_error;
157: end if;
158: end if;
159:
160: if(l_cplRec.wipEntityType = wip_constants.repetitive) then
161: processRepetitive(p_cplRec => l_cplRec,
162: p_txnTmpID => p_txnTmpID,
163: x_returnStatus => x_returnStatus);
164:

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

198: raise fnd_api.g_exc_unexpected_error;
199: end if;
200: end if;
201:
202: if(l_logLevel <= wip_constants.trace_logging) then
203: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processTemp',
204: p_procReturnStatus => x_returnStatus,
205: p_msg => 'procedure success.',
206: x_returnStatus => l_returnStatus); --discard logging return status

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

211: exception
212: when no_data_found then
213: rollback to wipcplpb20;
214: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
215: if (l_logLevel <= wip_constants.trace_logging) then
216: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processTemp',
217: p_procReturnStatus => x_returnStatus,
218: p_msg => 'no data found',
219: x_returnStatus => l_returnStatus); --discard logging return status

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

222: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
223: end if;
224: fnd_message.set_name('WIP', 'INVALID_MMTT_TEMP_ID');
225: fnd_msg_pub.add;
226: if (l_logLevel <= wip_constants.full_logging) then
227: wip_logger.log(SQLERRM, l_returnStatus);
228: end if;
229: when fnd_api.g_exc_error then --could not derive all lot/serial info for components
230: --do *not* rollback. leave the component records in mmtt/mtlt for the caller to query/complete

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

228: end if;
229: when fnd_api.g_exc_error then --could not derive all lot/serial info for components
230: --do *not* rollback. leave the component records in mmtt/mtlt for the caller to query/complete
231: --when the record is processed again, only the material processing and inv txn will occur
232: if (l_logLevel <= wip_constants.trace_logging) then
233: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processTemp',
234: p_procReturnStatus => x_returnStatus,
235: p_msg => 'need to collect l/s info',
236: x_returnStatus => l_returnStatus); --discard logging return status

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

239: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
240: end if;
241: when fnd_api.g_exc_unexpected_error then
242: rollback to wipcplpb20;
243: if (l_logLevel <= wip_constants.trace_logging) then
244: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processTemp',
245: p_procReturnStatus => x_returnStatus,
246: p_msg => l_errMsg,
247: x_returnStatus => l_returnStatus); --discard logging return status

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

254: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
255: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
256: p_procedure_name => 'processTemp',
257: p_error_text => SQLERRM);
258: if (l_logLevel <= wip_constants.trace_logging) then
259: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processTemp',
260: p_procReturnStatus => x_returnStatus,
261: p_msg => 'unexpected error: ' || SQLERRM,
262: x_returnStatus => l_returnStatus); --discard logging return status

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

291: l_jobType NUMBER;
292: l_remain_qty NUMBER := 0; -- Fix bug 13826369
293: l_job_name VARCHAR2(240);
294: begin
295: if (l_logLevel <= wip_constants.trace_logging) then
296: fillCplParamTbl(p_cplRec => p_cplRec,
297: x_params => l_params);
298: l_paramCount := l_params.count;
299: l_params(l_paramCount + 1).paramName := 'p_txnTmpID';

Line 346: if(p_cplRec.txnActionID = wip_constants.cplassy_action) then

342: from wip_discrete_jobs
343: where wip_entity_id = p_cplRec.wipEntityID
344: for update of quantity_completed nowait;
345:
346: if(p_cplRec.txnActionID = wip_constants.cplassy_action) then
347: -- Fix bug 13826369, update to complete status only if remaining qty is less than qty that user tries to complete
348: if(p_cplRec.priQty >= l_qtyAvailToComplete AND p_cplRec.priQty >= l_remain_qty) then
349: l_jobStatus := wip_constants.comp_chrg;
350: l_cplDate := nvl(l_cplDate, p_cplRec.txnDate); --Bug 4864403 Only change date_completed if it is null

Line 349: l_jobStatus := wip_constants.comp_chrg;

345:
346: if(p_cplRec.txnActionID = wip_constants.cplassy_action) then
347: -- Fix bug 13826369, update to complete status only if remaining qty is less than qty that user tries to complete
348: if(p_cplRec.priQty >= l_qtyAvailToComplete AND p_cplRec.priQty >= l_remain_qty) then
349: l_jobStatus := wip_constants.comp_chrg;
350: l_cplDate := nvl(l_cplDate, p_cplRec.txnDate); --Bug 4864403 Only change date_completed if it is null
351: end if;
352: --allocate completions to sales orders
353: l_errMsg := 'SO allocation failed.'; --set message in case it fails

Line 371: if(p_cplRec.wipEntityType = wip_constants.lotbased) then

367: --if so allocation went ok, then update the kanban card if it exists
368: if(x_returnStatus = fnd_api.g_ret_sts_success and
369: p_cplRec.kanbanCardID is not null) then
370: l_errMsg := 'Kanban update failed.'; --set message in case it fails
371: if(p_cplRec.wipEntityType = wip_constants.lotbased) then
372: l_docType := 8;
373: else
374: l_docType := inv_kanban_pvt.g_doc_type_discrete_job;
375: end if;

Line 389: l_jobStatus := wip_constants.released; --make sure the job status gets flipped back to released

385: end if;
386: else --a return
387: /* Bug 4864403 Change Status and date_completed when quantity_completed is less than start_quantity*/
388: if(l_qtyAvailToComplete > p_cplRec.priQty) then
389: l_jobStatus := wip_constants.released; --make sure the job status gets flipped back to released
390: l_cplDate := NULL;
391: end if;
392: -- Fixed bug 3678776. We should allow user to overreturn assembly back
393: -- to non-standard job.

Line 395: l_jobType = WIP_CONSTANTS.STANDARD) then

391: end if;
392: -- Fixed bug 3678776. We should allow user to overreturn assembly back
393: -- to non-standard job.
394: if(abs(p_cplRec.priQty) > l_qtyCompleted AND
395: l_jobType = WIP_CONSTANTS.STANDARD) then
396: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
397: fnd_message.set_token('ENTITY1', 'total txn qty-cap', true);
398: fnd_message.set_token('ENTITY2', 'job complete quantity', true);
399: fnd_msg_pub.add;

Line 450: date_last_moved = decode(p_cplRec.txnActionID, wip_constants.cplassy_action, p_cplRec.txnDate, date_last_moved),

446: raise fnd_api.g_exc_unexpected_error;
447: end if;
448: update wip_operations --lower the quantity available to complete
449: set quantity_waiting_to_move = quantity_waiting_to_move - p_cplRec.priQty,
450: date_last_moved = decode(p_cplRec.txnActionID, wip_constants.cplassy_action, p_cplRec.txnDate, date_last_moved),
451: last_updated_by = fnd_global.user_id,
452: last_update_date = sysdate,
453: request_id = fnd_global.conc_request_id,
454: program_application_id = fnd_global.prog_appl_id,

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

473: -- end of BUG 4869979 (FP 5107900)
474:
475: end if;
476:
477: if (l_logLevel <= wip_constants.trace_logging) then
478: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processDiscrete',
479: p_procReturnStatus => x_returnStatus,
480: p_msg => 'procedure success.',
481: x_returnStatus => l_returnStatus); --discard logging return status

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

482: end if;
483: exception
484: when fnd_api.g_exc_unexpected_error then
485: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
486: if (l_logLevel <= wip_constants.trace_logging) then
487: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processDiscrete',
488: p_procReturnStatus => x_returnStatus,
489: p_msg => l_errMsg,
490: x_returnStatus => l_returnStatus); --discard logging return status

Line 492: when wip_constants.records_locked then

488: p_procReturnStatus => x_returnStatus,
489: p_msg => l_errMsg,
490: x_returnStatus => l_returnStatus); --discard logging return status
491: end if;
492: when wip_constants.records_locked then
493: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
494: if (l_logLevel <= wip_constants.trace_logging) then
495: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processDiscrete',
496: p_procReturnStatus => x_returnStatus,

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

490: x_returnStatus => l_returnStatus); --discard logging return status
491: end if;
492: when wip_constants.records_locked then
493: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
494: if (l_logLevel <= wip_constants.trace_logging) then
495: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processDiscrete',
496: p_procReturnStatus => x_returnStatus,
497: p_msg => 'records were locked',
498: x_returnStatus => l_returnStatus); --discard logging return status

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

505: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
506: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
507: p_procedure_name => 'processDiscrete',
508: p_error_text => SQLERRM);
509: if (l_logLevel <= wip_constants.trace_logging) then
510: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processDiscrete',
511: p_procReturnStatus => x_returnStatus,
512: p_msg => 'unexpected error: ' || SQLERRM,
513: x_returnStatus => l_returnStatus); --discard logging return status

Line 563: and wrs.status_type in (wip_constants.released, wip_constants.comp_chrg)

559: wip_repetitive_schedules wrs,
560: wip_mtl_allocations_temp wmat
561: where wrs.wip_entity_id = p_cplRec.wipEntityID
562: and wrs.line_id = p_cplRec.repLineID
563: and wrs.status_type in (wip_constants.released, wip_constants.comp_chrg)
564: and wrs.repetitive_schedule_id = wo.repetitive_schedule_id (+)
565: and wrs.wip_entity_id = wo.wip_entity_id (+)
566: and v_lastOpSeq = wo.operation_seq_num (+)
567: and wrs.repetitive_schedule_id = wmat.repetitive_schedule_id

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

574: l_cplStatus NUMBER;
575: l_rollFwdSuccess NUMBER;
576: begin
577: x_returnStatus := fnd_api.g_ret_sts_success;
578: if (l_logLevel <= wip_constants.trace_logging) then
579: fillCplParamTbl(p_cplRec => p_cplRec,
580: x_params => l_params);
581: l_paramCount := l_params.count;
582: l_params(l_paramCount + 1).paramName := 'p_txnTmpID';

Line 595: if(p_cplRec.txnActionID = wip_constants.cplassy_action AND

591: end if;
592: end if;
593:
594:
595: if(p_cplRec.txnActionID = wip_constants.cplassy_action AND
596: p_cplRec.kanbanCardID is not null) then
597: inv_kanban_pvt.update_card_supply_status
598: (p_kanban_card_id => p_cplRec.kanbanCardID,
599: p_supply_status => inv_kanban_pvt.g_supply_status_full,

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

653: l_errMsg := 'not enough qty in to move of last op';
654: raise fnd_api.g_exc_unexpected_error;
655: end if;
656: end if;
657: if (l_logLevel <= wip_constants.full_logging) then
658: wip_logger.log('schedID' || l_schedRecTbl.schedID(i), l_returnStatus);
659: wip_logger.log('startQty ' || l_schedRecTbl.startQty(i), l_returnStatus);
660: wip_logger.log('cpldQty ' || l_schedRecTbl.cpldQty(i), l_returnStatus);
661: wip_logger.log('scrapQty ' || l_scrapQty, l_returnStatus);

Line 666: p_cplRec.txnActionID = wip_constants.cplassy_action) then

662: wip_logger.log('preAlcQty ' || l_schedRecTbl.preAlcQty(i), l_returnStatus);
663: end if;
664:
665: if(l_schedRecTbl.startQty(i) - l_schedRecTbl.cpldQty(i) - l_scrapQty <= l_schedRecTbl.preAlcQty(i) AND
666: p_cplRec.txnActionID = wip_constants.cplassy_action) then
667: l_status := wip_constants.comp_chrg;
668: else
669: l_status := wip_constants.released;
670: end if;

Line 667: l_status := wip_constants.comp_chrg;

663: end if;
664:
665: if(l_schedRecTbl.startQty(i) - l_schedRecTbl.cpldQty(i) - l_scrapQty <= l_schedRecTbl.preAlcQty(i) AND
666: p_cplRec.txnActionID = wip_constants.cplassy_action) then
667: l_status := wip_constants.comp_chrg;
668: else
669: l_status := wip_constants.released;
670: end if;
671:

Line 669: l_status := wip_constants.released;

665: if(l_schedRecTbl.startQty(i) - l_schedRecTbl.cpldQty(i) - l_scrapQty <= l_schedRecTbl.preAlcQty(i) AND
666: p_cplRec.txnActionID = wip_constants.cplassy_action) then
667: l_status := wip_constants.comp_chrg;
668: else
669: l_status := wip_constants.released;
670: end if;
671:
672: update wip_repetitive_schedules
673: set quantity_completed = quantity_completed + l_schedRecTbl.preAlcQty(i),

Line 683: if(l_status = wip_constants.comp_chrg) then

679: program_id = fnd_global.conc_program_id,
680: program_update_date = sysdate
681: where rowid = chartorowid(l_schedRecTbl.wrsRowID(i));
682:
683: if(l_status = wip_constants.comp_chrg) then
684: wip_repetitive_utilities.roll_forward_cover(p_closed_sched_id => l_schedRecTbl.schedID(i),
685: p_rollfwd_sched_id => null, --doesn't seem to be in use
686: p_rollfwd_type => wip_constants.roll_complete,
687: p_org_id => p_cplRec.orgID,

Line 686: p_rollfwd_type => wip_constants.roll_complete,

682:
683: if(l_status = wip_constants.comp_chrg) then
684: wip_repetitive_utilities.roll_forward_cover(p_closed_sched_id => l_schedRecTbl.schedID(i),
685: p_rollfwd_sched_id => null, --doesn't seem to be in use
686: p_rollfwd_type => wip_constants.roll_complete,
687: p_org_id => p_cplRec.orgID,
688: p_update_status => wip_constants.yes,
689: p_success_flag => l_rollFwdSuccess,
690: p_error_msg => l_errMsg);

Line 688: p_update_status => wip_constants.yes,

684: wip_repetitive_utilities.roll_forward_cover(p_closed_sched_id => l_schedRecTbl.schedID(i),
685: p_rollfwd_sched_id => null, --doesn't seem to be in use
686: p_rollfwd_type => wip_constants.roll_complete,
687: p_org_id => p_cplRec.orgID,
688: p_update_status => wip_constants.yes,
689: p_success_flag => l_rollFwdSuccess,
690: p_error_msg => l_errMsg);
691: if(l_rollFwdSuccess <> wip_constants.yes) then
692: -- fnd_msg_pub.add; --assume error message is still current

Line 691: if(l_rollFwdSuccess <> wip_constants.yes) then

687: p_org_id => p_cplRec.orgID,
688: p_update_status => wip_constants.yes,
689: p_success_flag => l_rollFwdSuccess,
690: p_error_msg => l_errMsg);
691: if(l_rollFwdSuccess <> wip_constants.yes) then
692: -- fnd_msg_pub.add; --assume error message is still current
693: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
694: l_errMsg := 'roll forward failed for schedule ' || l_schedRec.repSchedID;
695: end if;

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

725: wmat.transaction_date
726: from wip_mtl_allocations_temp wmat
727: where wmat.transaction_temp_id = p_txnTmpID;
728:
729: if (l_logLevel <= wip_constants.full_logging) then
730: wip_logger.log('inserted ' || SQL%ROWCOUNT || ' rows into MMTA', l_returnStatus);
731: end if;
732: delete wip_mtl_allocations_temp
733: where transaction_temp_id = p_txnTmpID;

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

731: end if;
732: delete wip_mtl_allocations_temp
733: where transaction_temp_id = p_txnTmpID;
734:
735: if (l_logLevel <= wip_constants.full_logging) then
736: wip_logger.log('deleted ' || SQL%ROWCOUNT || ' rows from WMAT', l_returnStatus);
737: end if;
738:
739: if (l_logLevel <= wip_constants.trace_logging) then

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

735: if (l_logLevel <= wip_constants.full_logging) then
736: wip_logger.log('deleted ' || SQL%ROWCOUNT || ' rows from WMAT', l_returnStatus);
737: end if;
738:
739: if (l_logLevel <= wip_constants.trace_logging) then
740: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processRepetitive',
741: p_procReturnStatus => x_returnStatus,
742: p_msg => 'procedure success.',
743: x_returnStatus => l_returnStatus); --discard logging return status

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

745:
746: exception
747: when fnd_api.g_exc_unexpected_error then
748: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
749: if (l_logLevel <= wip_constants.trace_logging) then
750: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processRepetitive',
751: p_procReturnStatus => x_returnStatus,
752: p_msg => l_errMsg,
753: x_returnStatus => l_returnStatus); --discard logging return status

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

756: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
757: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
758: p_procedure_name => 'processRepetitive',
759: p_error_text => SQLERRM);
760: if (l_logLevel <= wip_constants.trace_logging) then
761: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processRepetitive',
762: p_procReturnStatus => x_returnStatus,
763: p_msg => 'unexpected error: ' || SQLERRM,
764: x_returnStatus => l_returnStatus); --discard logging return status

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

797: where wip_entity_id = v_wipEntityID
798: for update of required_quantity nowait;
799:
800: begin
801: if (l_logLevel <= wip_constants.trace_logging) then
802: fillCplParamTbl(p_cplRec => p_cplRec,
803: x_params => l_params);
804: wip_logger.entryPoint(p_procName => 'wip_cplProc_priv.processOverCpl',
805: p_params => l_params,

Line 814: if(p_cplRec.wipEntityType = wip_constants.repetitive) then

810: raise fnd_api.g_exc_unexpected_error;
811: end if;
812: end if;
813:
814: if(p_cplRec.wipEntityType = wip_constants.repetitive) then
815: wip_repetitive_utilities.get_first_last_sched(p_wip_entity_id => p_cplRec.wipEntityID,
816: p_org_id => p_cplRec.orgID,
817: p_line_id => p_cplRec.repLineID,
818: x_first_sched_id => l_firstSchedID,

Line 836: if(x_returnStatus = wip_constants.no) then

832: p_primary_quantity => p_cplRec.overCplPriQty,
833: p_result => x_returnStatus);
834:
835:
836: if(x_returnStatus = wip_constants.no) then
837: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
838: fnd_message.set_name('WIP', 'WIP_OC_TOLERANCE_FAIL');
839: fnd_msg_pub.add;
840: l_errMsg := 'cpl exceeded tolerances';

Line 851: p_cpl_profile => wip_constants.online,

847: --if a routing exists, insert a move record and perform the move
848: if(p_cplRec.lastOpSeq > 0) then
849:
850: wip_overcompletion.insert_oc_move_txn( p_primary_quantity => p_cplRec.overCplPriQty,
851: p_cpl_profile => wip_constants.online,
852: p_oc_txn_id => p_cplRec.overCplTxnID,
853: p_parent_cpl_txn_id => p_cplRec.cplTxnID,
854: p_first_schedule_id => l_firstSchedID,
855: p_user_id => p_cplRec.lastUpdBy, --fnd_global.user_id,

Line 879: p_proc_phase => wip_constants.move_proc,

875:
876: wip_movProc_priv.processIntf(p_group_id => p_cplRec.movTxnID,
877: p_child_txn_id => -1,
878: p_mtl_header_id => p_cplRec.txnHdrID,
879: p_proc_phase => wip_constants.move_proc,
880: p_time_out => 0,
881: p_move_mode => wip_constants.online,
882: p_bf_mode => wip_constants.online, --ignored
883: p_mtl_mode => wip_constants.no_processing,--do not call inv TM at all

Line 881: p_move_mode => wip_constants.online,

877: p_child_txn_id => -1,
878: p_mtl_header_id => p_cplRec.txnHdrID,
879: p_proc_phase => wip_constants.move_proc,
880: p_time_out => 0,
881: p_move_mode => wip_constants.online,
882: p_bf_mode => wip_constants.online, --ignored
883: p_mtl_mode => wip_constants.no_processing,--do not call inv TM at all
884: p_endDebug => fnd_api.g_false,
885: p_initMsgList => fnd_api.g_false,

Line 882: p_bf_mode => wip_constants.online, --ignored

878: p_mtl_header_id => p_cplRec.txnHdrID,
879: p_proc_phase => wip_constants.move_proc,
880: p_time_out => 0,
881: p_move_mode => wip_constants.online,
882: p_bf_mode => wip_constants.online, --ignored
883: p_mtl_mode => wip_constants.no_processing,--do not call inv TM at all
884: p_endDebug => fnd_api.g_false,
885: p_initMsgList => fnd_api.g_false,
886: p_insertAssy => fnd_api.g_true,

Line 883: p_mtl_mode => wip_constants.no_processing,--do not call inv TM at all

879: p_proc_phase => wip_constants.move_proc,
880: p_time_out => 0,
881: p_move_mode => wip_constants.online,
882: p_bf_mode => wip_constants.online, --ignored
883: p_mtl_mode => wip_constants.no_processing,--do not call inv TM at all
884: p_endDebug => fnd_api.g_false,
885: p_initMsgList => fnd_api.g_false,
886: p_insertAssy => fnd_api.g_true,
887: p_do_backflush => fnd_api.g_false,--backflush was already done

Line 897: if(p_cplRec.wipEntityType = wip_constants.repetitive) then

893: raise fnd_api.g_exc_unexpected_error;
894: end if;
895: --otherwise we just have to increase the component requirements in wro
896: else
897: if(p_cplRec.wipEntityType = wip_constants.repetitive) then
898: open c_repRows(v_schedID => l_lastSchedID);
899: update wip_requirement_operations
900: set required_quantity = round(required_quantity + p_cplRec.overCplPriQty * quantity_per_assembly, wip_constants.inv_max_precision)
901: where repetitive_schedule_id = l_lastSchedID;

Line 900: set required_quantity = round(required_quantity + p_cplRec.overCplPriQty * quantity_per_assembly, wip_constants.inv_max_precision)

896: else
897: if(p_cplRec.wipEntityType = wip_constants.repetitive) then
898: open c_repRows(v_schedID => l_lastSchedID);
899: update wip_requirement_operations
900: set required_quantity = round(required_quantity + p_cplRec.overCplPriQty * quantity_per_assembly, wip_constants.inv_max_precision)
901: where repetitive_schedule_id = l_lastSchedID;
902: close c_repRows;
903: else
904: open c_discRows(v_wipEntityID => p_cplRec.wipEntityID);

Line 906: set required_quantity = round(required_quantity + p_cplRec.overCplPriQty * quantity_per_assembly, wip_constants.inv_max_precision)

902: close c_repRows;
903: else
904: open c_discRows(v_wipEntityID => p_cplRec.wipEntityID);
905: update wip_requirement_operations
906: set required_quantity = round(required_quantity + p_cplRec.overCplPriQty * quantity_per_assembly, wip_constants.inv_max_precision)
907: where wip_entity_id = p_cplRec.wipEntityID
908: AND nvl(basis_type,1) <> WIP_CONSTANTS.LOT_BASED_MTL; /* LBM Project */
909: close c_discRows;
910: end if;

Line 908: AND nvl(basis_type,1) <> WIP_CONSTANTS.LOT_BASED_MTL; /* LBM Project */

904: open c_discRows(v_wipEntityID => p_cplRec.wipEntityID);
905: update wip_requirement_operations
906: set required_quantity = round(required_quantity + p_cplRec.overCplPriQty * quantity_per_assembly, wip_constants.inv_max_precision)
907: where wip_entity_id = p_cplRec.wipEntityID
908: AND nvl(basis_type,1) <> WIP_CONSTANTS.LOT_BASED_MTL; /* LBM Project */
909: close c_discRows;
910: end if;
911: end if;
912:

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

909: close c_discRows;
910: end if;
911: end if;
912:
913: if (l_logLevel <= wip_constants.trace_logging) then
914: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processOverCpl',
915: p_procReturnStatus => x_returnStatus,
916: p_msg => 'procedure success.',
917: x_returnStatus => l_returnStatus); --discard logging return status

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

917: x_returnStatus => l_returnStatus); --discard logging return status
918: end if;
919: exception
920: when fnd_api.g_exc_unexpected_error then
921: if (l_logLevel <= wip_constants.trace_logging) then
922: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processOverCpl',
923: p_procReturnStatus => x_returnStatus,
924: p_msg => l_errMsg,
925: x_returnStatus => l_returnStatus); --discard logging return status

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

928: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
929: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
930: p_procedure_name => 'processOverCpl',
931: p_error_text => SQLERRM);
932: if (l_logLevel <= wip_constants.trace_logging) then
933: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processOverCpl',
934: p_procReturnStatus => x_returnStatus,
935: p_msg => 'unexpected error: ' || SQLERRM,
936: x_returnStatus => l_returnStatus); --discard logging return status

Line 962: and wrs.status_type in (wip_constants.released, wip_constants.comp_chrg)

958: wip_mtl_allocations_temp wmat
959: where wrs.wip_entity_id = v_wipEntityID
960: and wrs.line_id = v_repLineID
961: and wrs.date_released < v_txnDate
962: and wrs.status_type in (wip_constants.released, wip_constants.comp_chrg)
963: and wrs.repetitive_schedule_id = wo.repetitive_schedule_id (+)
964: and wrs.wip_entity_id = wo.wip_entity_id (+)
965: and v_lastOpSeq = wo.operation_seq_num (+)
966: and wrs.repetitive_schedule_id = wmat.repetitive_schedule_id (+)

Line 987: and wrs.status_type in (wip_constants.released, wip_constants.comp_chrg)

983: wip_mtl_allocations_temp wmat
984: where wrs.wip_entity_id = v_wipEntityID
985: and wrs.line_id = v_repLineID
986: and wrs.date_released < v_txnDate
987: and wrs.status_type in (wip_constants.released, wip_constants.comp_chrg)
988: and wrs.repetitive_schedule_id = wmat.repetitive_schedule_id (+)
989: group by wrs.repetitive_schedule_id,
990: wrs.bom_revision,
991: wrs.daily_production_rate,

Line 1011: and transaction_action_id in (wip_constants.cplassy_action, wip_constants.retassy_action);

1007: where completion_transaction_id = p_cplTxnID
1008: and transaction_header_id = p_txnHdrID
1009: and transaction_source_id = p_wipEntityID
1010: and transaction_source_type_id = 5
1011: and transaction_action_id in (wip_constants.cplassy_action, wip_constants.retassy_action);
1012:
1013: cursor c_mtiTxns is
1014: select transaction_interface_id,
1015: operation_seq_num lastOpSeq,

Line 1027: and transaction_action_id in (wip_constants.cplassy_action, wip_constants.retassy_action);

1023: where completion_transaction_id = p_cplTxnID
1024: and transaction_header_id = p_txnHdrID
1025: and transaction_source_id = p_wipEntityID
1026: and transaction_source_type_id = 5
1027: and transaction_action_id in (wip_constants.cplassy_action, wip_constants.retassy_action);
1028:
1029: type schedule_recTbl_t is record(repSchedID num_tbl_t,
1030: bomRev char_tbl_t,
1031: availQty num_tbl_t,

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

1054: x_returnStatus := fnd_api.g_ret_sts_success;
1055:
1056: savepoint wipcplpb40;
1057:
1058: if (l_logLevel <= wip_constants.trace_logging) then
1059: l_params(1).paramName := 'p_txnHdrID';
1060: l_params(1).paramValue := p_txnHdrID;
1061: l_params(2).paramName := 'p_cplTxnID';
1062: l_params(2).paramValue := p_cplTxnID;

Line 1081: if(p_tblName = wip_constants.MTI_TBL) then

1077: raise fnd_api.g_exc_unexpected_error;
1078: end if;
1079: end if;
1080:
1081: if(p_tblName = wip_constants.MTI_TBL) then
1082: if (l_logLevel <= wip_constants.full_logging) then
1083: wip_logger.log('.25', l_returnStatus);
1084: end if;
1085: open c_mtiTxns;

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

1078: end if;
1079: end if;
1080:
1081: if(p_tblName = wip_constants.MTI_TBL) then
1082: if (l_logLevel <= wip_constants.full_logging) then
1083: wip_logger.log('.25', l_returnStatus);
1084: end if;
1085: open c_mtiTxns;
1086: fetch c_mtiTxns

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

1092: l_txnRecTbl.txnQty,
1093: l_txnRecTbl.overCplQty,
1094: l_txnRecTbl.orgID;
1095: close c_mtiTxns;
1096: if (l_logLevel <= wip_constants.full_logging) then
1097: wip_logger.log('mti row count is ' || l_txnRecTbl.txnID.count, l_returnStatus);
1098: end if;
1099: else
1100: if (l_logLevel <= wip_constants.full_logging) then

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

1096: if (l_logLevel <= wip_constants.full_logging) then
1097: wip_logger.log('mti row count is ' || l_txnRecTbl.txnID.count, l_returnStatus);
1098: end if;
1099: else
1100: if (l_logLevel <= wip_constants.full_logging) then
1101: wip_logger.log('1', l_returnStatus);
1102: end if;
1103: open c_mmttTxns;
1104: fetch c_mmttTxns

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

1110: l_txnRecTbl.txnQty,
1111: l_txnRecTbl.overCplQty,
1112: l_txnRecTbl.orgID;
1113: close c_mmttTxns;
1114: if (l_logLevel <= wip_constants.full_logging) then
1115: wip_logger.log('2', l_returnStatus);
1116: end if;
1117: end if;
1118:

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

1116: end if;
1117: end if;
1118:
1119: for i in 1..l_txnRecTbl.txnID.count loop
1120: if (l_logLevel <= wip_constants.full_logging) then
1121: wip_logger.log('processing cpl tmpID:' || l_txnRecTbl.txnID(i) || '; qty:' || l_txnRecTbl.priQty(i), l_returnStatus);
1122: end if;
1123:
1124: if(l_txnRecTbl.lastOpSeq(i) is null or l_txnRecTbl.lastOpSeq(i) < 0) then

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

1126: else
1127: l_lastOpSeq := l_txnRecTbl.lastOpSeq(i);
1128: end if;
1129:
1130: if (l_logLevel <= wip_constants.full_logging) then
1131: wip_logger.log('last op seq is ' || l_lastOpSeq, l_returnStatus);
1132: wip_logger.log('action is ' || l_lastOpSeq, l_returnStatus);
1133: end if;
1134: l_remainingQty := l_txnRecTbl.priQty(i);

Line 1136: if(p_txnActionID = wip_constants.cplassy_action) then

1132: wip_logger.log('action is ' || l_lastOpSeq, l_returnStatus);
1133: end if;
1134: l_remainingQty := l_txnRecTbl.priQty(i);
1135:
1136: if(p_txnActionID = wip_constants.cplassy_action) then
1137: /* Fix for bug 5373061: Pass txnDate to cursor to fetch
1138: only valid schedules as on transaction date */
1139: open c_repCplScheds(v_lastOpSeq => l_txnRecTbl.lastOpSeq(i),
1140: v_wipEntityID => p_wipEntityID,

Line 1167: if(p_txnActionID = wip_constants.cplassy_action) then

1163: close c_repRetScheds;
1164: end if;
1165: for j in 1..l_schedRecTbl.repSchedID.count loop
1166:
1167: if(p_txnActionID = wip_constants.cplassy_action) then
1168: if(l_schedRecTbl.availQty(j) is null) then
1169: select ((wrs.daily_production_rate * wrs.processing_work_days) - wrs.quantity_completed) - nvl(sum(wo.quantity_scrapped), 0)
1170: into l_schedRecTbl.availQty(j)
1171: from wip_repetitive_schedules wrs,

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

1185:
1186:
1187: l_lastSchedID := l_schedRecTbl.repSchedID(j);--the last schedule fetched is the last one open for completions
1188:
1189: if(l_logLevel <= wip_constants.full_logging) then
1190: wip_logger.log('processing sched ' || l_schedRecTbl.repSchedID(j) || ' w/open qty of ' || l_schedQty, l_returnStatus);
1191: wip_logger.log('availQty: ' || l_schedRecTbl.availQty(j), l_returnStatus);
1192: wip_logger.log('startQty: ' || l_startQty, l_returnStatus);
1193: wip_logger.log('tempQty: ' || l_schedRecTbl.tempQty(j), l_returnStatus);

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

1205:
1206: --complete the lesser of the open quantity and the remaining transaction qty
1207:
1208: if(l_schedQty <> 0) then
1209: if (l_logLevel <= wip_constants.full_logging) then
1210: wip_logger.log('inserting into temp table; sched:' || l_schedRecTbl.repSchedID(j) || '; qty:' || l_schedQty, l_returnStatus);
1211: end if;
1212: insert into wip_mtl_allocations_temp
1213: (transaction_temp_id,

Line 1243: round(l_txnRecTbl.txnQty(i) * l_schedQty/l_txnRecTbl.priQty(i), wip_constants.inv_max_precision), --% of qty completed * txn Qty

1239: fnd_global.conc_request_id,
1240: fnd_global.prog_appl_id,
1241: fnd_global.conc_program_id,
1242: sysdate,
1243: round(l_txnRecTbl.txnQty(i) * l_schedQty/l_txnRecTbl.priQty(i), wip_constants.inv_max_precision), --% of qty completed * txn Qty
1244: l_schedQty,
1245: l_txnRecTbl.txnDate(i));
1246:
1247: l_remainingQty := l_remainingQty - l_schedQty;

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

1259: l_errMsg := 'did not find any schedules.';
1260: raise fnd_api.g_exc_unexpected_error; -- couldn't find any open schedules
1261: end if;
1262:
1263: if (l_logLevel <= wip_constants.full_logging) then
1264: wip_logger.log('txnID' || l_txnRecTbl.txnID(i), l_returnStatus);
1265: wip_logger.log('rmnQty' || l_remainingQty, l_returnStatus);
1266: wip_logger.log('schedID' || l_lastSchedID, l_returnStatus);
1267: end if;

Line 1285: if(p_txnActionID <> wip_constants.retassy_action) then

1281: transactions can pick up older schedules which do not have open quantity. Do not allocate
1282: to the older schedule. Throw error */
1283:
1284: /* Fix for Bug#6018877 - FP of bug#6004763. Added the if condition check not to consider Return txn */
1285: if(p_txnActionID <> wip_constants.retassy_action) then
1286: if(l_txnRecTbl.overCplQty(i) IS NULL) then
1287: fnd_message.set_name('WIP', 'WIP_INT_ERROR_NO_SCHED');
1288: fnd_message.set_token('ROUTINE', 'wip_cplProc_priv.preAllocateSchedules');
1289: fnd_msg_pub.add;

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

1291: raise fnd_api.g_exc_unexpected_error; -- couldn't find any open schedules
1292: end if;
1293: end if; /*Fix for Bug#6018877 - FP of bug#6004763*/
1294:
1295: if (l_logLevel <= wip_constants.full_logging) then
1296: wip_logger.log('update failed. inserting new row', l_returnStatus);
1297: end if;
1298: /* Fixed bug 3698513. Completion_transaction_id is a not null column
1299: * , so we have to insert a value into this column. This bug only

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

1337: end if;
1338: end loop;
1339:
1340:
1341: if (l_logLevel <= wip_constants.trace_logging) then
1342: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.preAllocateSchedules',
1343: p_procReturnStatus => x_returnStatus,
1344: p_msg => 'procedure success.',
1345: x_returnStatus => l_returnStatus); --discard logging return status

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

1347: exception
1348: when fnd_api.g_exc_unexpected_error then
1349: rollback to wipcplpb40;
1350: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1351: if (l_logLevel <= wip_constants.trace_logging) then
1352: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.preAllocateSchedules',
1353: p_procReturnStatus => x_returnStatus,
1354: p_msg => l_errMsg,
1355: x_returnStatus => l_returnStatus); --discard logging return status

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

1358: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1359: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
1360: p_procedure_name => 'preAllocateSchedules',
1361: p_error_text => SQLERRM);
1362: if (l_logLevel <= wip_constants.trace_logging) then
1363: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.preAllocateSchedules',
1364: p_procReturnStatus => x_returnStatus,
1365: p_msg => 'unexpected error: ' || SQLERRM,
1366: x_returnStatus => l_returnStatus); --discard logging return status

Line 1386: and wrs.status_type in (wip_constants.released, wip_constants.comp_chrg)

1382: from wip_repetitive_schedules wrs,
1383: wip_mtl_allocations_temp wmat
1384: where wrs.wip_entity_id = p_wipEntityID
1385: and wrs.line_id = p_repLineID
1386: and wrs.status_type in (wip_constants.released, wip_constants.comp_chrg)
1387: and wrs.repetitive_schedule_id = wmat.repetitive_schedule_id (+)
1388: group by wrs.repetitive_schedule_id,
1389: wrs.bom_revision,
1390: wrs.daily_production_rate,

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

1400: l_params wip_logger.param_tbl_t;
1401: begin
1402: --need to find the first open schedule. if we have pre-allocated completions, we have to see
1403: --which ones will be completed by the time this return is processed.
1404: if (l_logLevel <= wip_constants.trace_logging) then
1405: l_params(1).paramName := 'p_txnHdrID';
1406: l_params(1).paramValue := p_txnHdrID;
1407: l_params(2).paramName := 'p_cplTxnID';
1408: l_params(2).paramValue := p_cplTxnID;

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

1424:
1425: for l_schedRec in c_openScheds loop
1426: l_schedID := l_schedRec.repetitive_schedule_id;
1427:
1428: if(l_logLevel <= wip_constants.full_logging) then
1429: wip_logger.log('l_schedRec.cplQty' || l_schedRec.cplQty, l_returnStatus);
1430: wip_logger.log('l_schedRec.tempQty' || l_schedRec.tempQty, l_returnStatus);
1431: wip_logger.log('l_schedRec.startQty' || l_schedRec.startQty, l_returnStatus);
1432: end if;

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

1431: wip_logger.log('l_schedRec.startQty' || l_schedRec.startQty, l_returnStatus);
1432: end if;
1433:
1434: if(greatest(l_schedRec.cplQty, 0) + nvl(l_schedRec.tempQty, 0) < l_schedRec.startQty) then
1435: if (l_logLevel <= wip_constants.full_logging) then
1436: wip_logger.log('found open schedule' || l_schedID, l_returnStatus);
1437: end if;
1438: exit;
1439: end if;

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

1437: end if;
1438: exit;
1439: end if;
1440: end loop;
1441: if (l_logLevel <= wip_constants.full_logging) then
1442: wip_logger.log('returning to schedule' || l_schedID, l_returnStatus);
1443: end if;
1444:
1445: if(p_tblName = wip_constants.MMTT_TBL) then

Line 1445: if(p_tblName = wip_constants.MMTT_TBL) then

1441: if (l_logLevel <= wip_constants.full_logging) then
1442: wip_logger.log('returning to schedule' || l_schedID, l_returnStatus);
1443: end if;
1444:
1445: if(p_tblName = wip_constants.MMTT_TBL) then
1446: insert into wip_mtl_allocations_temp
1447: (transaction_temp_id,
1448: repetitive_schedule_id,
1449: organization_id,

Line 1480: and mmtt.transaction_action_id = wip_constants.retassy_action;

1476: mmtt.transaction_date
1477: from mtl_material_transactions_temp mmtt
1478: where mmtt.transaction_header_id = p_txnHdrID
1479: and mmtt.completion_transaction_id = p_cplTxnID
1480: and mmtt.transaction_action_id = wip_constants.retassy_action;
1481: elsif(p_tblName = wip_constants.MTI_TBL) then
1482: insert into wip_mtl_allocations_temp
1483: (transaction_temp_id,
1484: repetitive_schedule_id,

Line 1481: elsif(p_tblName = wip_constants.MTI_TBL) then

1477: from mtl_material_transactions_temp mmtt
1478: where mmtt.transaction_header_id = p_txnHdrID
1479: and mmtt.completion_transaction_id = p_cplTxnID
1480: and mmtt.transaction_action_id = wip_constants.retassy_action;
1481: elsif(p_tblName = wip_constants.MTI_TBL) then
1482: insert into wip_mtl_allocations_temp
1483: (transaction_temp_id,
1484: repetitive_schedule_id,
1485: organization_id,

Line 1516: and mti.transaction_action_id = wip_constants.retassy_action;

1512: mti.transaction_date
1513: from mtl_transactions_interface mti
1514: where mti.transaction_header_id = p_txnHdrID
1515: and mti.completion_transaction_id = p_cplTxnID
1516: and mti.transaction_action_id = wip_constants.retassy_action;
1517: end if;
1518:
1519: if (l_logLevel <= wip_constants.full_logging) then
1520: wip_logger.log('inserted ' || SQL%ROWCOUNT || ' rows', l_returnStatus);

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

1515: and mti.completion_transaction_id = p_cplTxnID
1516: and mti.transaction_action_id = wip_constants.retassy_action;
1517: end if;
1518:
1519: if (l_logLevel <= wip_constants.full_logging) then
1520: wip_logger.log('inserted ' || SQL%ROWCOUNT || ' rows', l_returnStatus);
1521: end if;
1522:
1523: x_returnStatus := fnd_api.g_ret_sts_success;

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

1521: end if;
1522:
1523: x_returnStatus := fnd_api.g_ret_sts_success;
1524:
1525: if (l_logLevel <= wip_constants.trace_logging) then
1526: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.preAllocateRets',
1527: p_procReturnStatus => x_returnStatus,
1528: p_msg => 'success',
1529: x_returnStatus => l_returnStatus); --discard logging return status

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

1531:
1532: exception
1533: when others then
1534: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1535: if (l_logLevel <= wip_constants.trace_logging) then
1536: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.preAllocateRets',
1537: p_procReturnStatus => x_returnStatus,
1538: p_msg => 'unexpected error: ' || SQLERRM,
1539: x_returnStatus => l_returnStatus); --discard logging return status

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

1555: l_errMsg VARCHAR2(2000);
1556: begin
1557: savepoint wipcplpb40;
1558:
1559: if (l_logLevel <= wip_constants.trace_logging) then
1560: l_params(1).paramName := 'p_cplTxnID';
1561: l_params(1).paramValue := p_cplTxnID;
1562:
1563: wip_logger.entryPoint(p_procName => 'wip_cplProc_priv.preAllocateSchedules',

Line 1572: if(p_txnActionID = wip_constants.cplassy_action) then

1568: raise fnd_api.g_exc_unexpected_error;
1569: end if;
1570: end if;
1571:
1572: if(p_txnActionID = wip_constants.cplassy_action) then
1573: preAllocateCpls(p_txnHdrID => p_txnHdrID,
1574: p_cplTxnID => p_cplTxnID,
1575: p_wipEntityID => p_wipEntityID,
1576: p_repLineID => p_repLineID,

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

1588: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1589: raise fnd_api.g_exc_unexpected_error;
1590: end if;
1591:
1592: if (l_logLevel <= wip_constants.trace_logging) then
1593: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.preAllocateSchedules',
1594: p_procReturnStatus => x_returnStatus,
1595: p_msg => 'procedure success.',
1596: x_returnStatus => l_returnStatus); --discard logging return status

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

1601:
1602: exception
1603: when fnd_api.g_exc_unexpected_error then
1604: rollback to wipcplpb40;
1605: if (l_logLevel <= wip_constants.trace_logging) then
1606: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.preAllocateSchedules',
1607: p_procReturnStatus => x_returnStatus,
1608: p_msg => l_errMsg,
1609: x_returnStatus => l_returnStatus); --discard logging return status

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

1616: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1617: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
1618: p_procedure_name => 'preAllocateSchedules',
1619: p_error_text => SQLERRM);
1620: if (l_logLevel <= wip_constants.trace_logging) then
1621: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.preAllocateSchedules',
1622: p_procReturnStatus => x_returnStatus,
1623: p_msg => 'unexpected error: ' || SQLERRM,
1624: x_returnStatus => l_returnStatus); --discard logging return status

Line 1731: IF (l_log_level <= wip_constants.trace_logging) THEN

1727: l_msg VARCHAR2(2000);
1728: TPS_INV_JOB_OR_SCHED CONSTANT NUMBER := 5;
1729: BEGIN
1730: l_process_phase := '1';
1731: IF (l_log_level <= wip_constants.trace_logging) THEN
1732: l_params(1).paramName := 'p_org_id';
1733: l_params(1).paramValue := p_org_id;
1734: l_params(2).paramName := 'p_interface_id';
1735: l_params(2).paramValue := p_interface_id;

Line 1756: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)

1752: FROM mtl_transaction_lots_interface mtli,
1753: mtl_transactions_interface mti
1754: WHERE mtli.transaction_interface_id = mti.transaction_interface_id
1755: AND mti.transaction_header_id = p_mtl_header_id
1756: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)
1757: and MTI.TRANSACTION_TYPE_ID in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)
1758: AND mti.transaction_source_type_id = TPS_INV_JOB_OR_SCHED ;
1759:
1760: IF l_mti_lot_rec>0 THEN

Line 1757: and MTI.TRANSACTION_TYPE_ID in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)

1753: mtl_transactions_interface mti
1754: WHERE mtli.transaction_interface_id = mti.transaction_interface_id
1755: AND mti.transaction_header_id = p_mtl_header_id
1756: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)
1757: and MTI.TRANSACTION_TYPE_ID in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)
1758: AND mti.transaction_source_type_id = TPS_INV_JOB_OR_SCHED ;
1759:
1760: IF l_mti_lot_rec>0 THEN
1761:

Line 1772: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)

1768: mtl_lot_numbers mln
1769: WHERE mti.organization_id = msi.organization_id
1770: AND mti.inventory_item_id = msi.inventory_item_id
1771: AND mti.transaction_header_id = p_mtl_header_id
1772: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)
1773: AND mti.transaction_type_id in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)
1774: AND mti.transaction_source_type_id = TPS_INV_JOB_OR_SCHED
1775: AND mti.wip_entity_type =WIP_CONSTANTS.DISCRETE
1776: AND msi.lot_control_code = WIP_CONSTANTS.LOT

Line 1773: AND mti.transaction_type_id in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)

1769: WHERE mti.organization_id = msi.organization_id
1770: AND mti.inventory_item_id = msi.inventory_item_id
1771: AND mti.transaction_header_id = p_mtl_header_id
1772: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)
1773: AND mti.transaction_type_id in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)
1774: AND mti.transaction_source_type_id = TPS_INV_JOB_OR_SCHED
1775: AND mti.wip_entity_type =WIP_CONSTANTS.DISCRETE
1776: AND msi.lot_control_code = WIP_CONSTANTS.LOT
1777: AND mln.lot_number = mtli.lot_number

Line 1775: AND mti.wip_entity_type =WIP_CONSTANTS.DISCRETE

1771: AND mti.transaction_header_id = p_mtl_header_id
1772: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)
1773: AND mti.transaction_type_id in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)
1774: AND mti.transaction_source_type_id = TPS_INV_JOB_OR_SCHED
1775: AND mti.wip_entity_type =WIP_CONSTANTS.DISCRETE
1776: AND msi.lot_control_code = WIP_CONSTANTS.LOT
1777: AND mln.lot_number = mtli.lot_number
1778: AND mln.inventory_item_id = mti.inventory_item_id
1779: AND mln.organization_id = mti.organization_id)

Line 1776: AND msi.lot_control_code = WIP_CONSTANTS.LOT

1772: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)
1773: AND mti.transaction_type_id in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)
1774: AND mti.transaction_source_type_id = TPS_INV_JOB_OR_SCHED
1775: AND mti.wip_entity_type =WIP_CONSTANTS.DISCRETE
1776: AND msi.lot_control_code = WIP_CONSTANTS.LOT
1777: AND mln.lot_number = mtli.lot_number
1778: AND mln.inventory_item_id = mti.inventory_item_id
1779: AND mln.organization_id = mti.organization_id)
1780: WHERE mtli.transaction_interface_id IN

Line 1787: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)

1783: mtl_system_items msi
1784: WHERE mti.organization_id = msi.organization_id
1785: AND mti.inventory_item_id = msi.inventory_item_id
1786: AND mti.transaction_header_id = p_mtl_header_id
1787: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)
1788: AND mti.transaction_type_id in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)
1789: AND mti.transaction_source_type_id = TPS_INV_JOB_OR_SCHED
1790: AND msi.lot_control_code = WIP_CONSTANTS.LOT
1791: AND mti.wip_entity_type = WIP_CONSTANTS.DISCRETE

Line 1788: AND mti.transaction_type_id in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)

1784: WHERE mti.organization_id = msi.organization_id
1785: AND mti.inventory_item_id = msi.inventory_item_id
1786: AND mti.transaction_header_id = p_mtl_header_id
1787: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)
1788: AND mti.transaction_type_id in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)
1789: AND mti.transaction_source_type_id = TPS_INV_JOB_OR_SCHED
1790: AND msi.lot_control_code = WIP_CONSTANTS.LOT
1791: AND mti.wip_entity_type = WIP_CONSTANTS.DISCRETE
1792: )

Line 1790: AND msi.lot_control_code = WIP_CONSTANTS.LOT

1786: AND mti.transaction_header_id = p_mtl_header_id
1787: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)
1788: AND mti.transaction_type_id in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)
1789: AND mti.transaction_source_type_id = TPS_INV_JOB_OR_SCHED
1790: AND msi.lot_control_code = WIP_CONSTANTS.LOT
1791: AND mti.wip_entity_type = WIP_CONSTANTS.DISCRETE
1792: )
1793: AND mtli.lot_expiration_date is null;
1794:

Line 1791: AND mti.wip_entity_type = WIP_CONSTANTS.DISCRETE

1787: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)
1788: AND mti.transaction_type_id in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)
1789: AND mti.transaction_source_type_id = TPS_INV_JOB_OR_SCHED
1790: AND msi.lot_control_code = WIP_CONSTANTS.LOT
1791: AND mti.wip_entity_type = WIP_CONSTANTS.DISCRETE
1792: )
1793: AND mtli.lot_expiration_date is null;
1794:
1795: -- IF debug message level = 2, write statement below to log file

Line 1796: IF (l_log_level <= wip_constants.full_logging) THEN

1792: )
1793: AND mtli.lot_expiration_date is null;
1794:
1795: -- IF debug message level = 2, write statement below to log file
1796: IF (l_log_level <= wip_constants.full_logging) THEN
1797: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
1798: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
1799: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
1800: l_msg := fnd_message.get;

Line 1815: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)

1811: (SELECT mti.transaction_date + NVL(msi.shelf_life_days,0)
1812: FROM mtl_transactions_interface mti,
1813: mtl_system_items msi
1814: WHERE mti.transaction_header_id =p_mtl_header_id
1815: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)
1816: AND mti.transaction_type_id in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)
1817: AND mti.transaction_source_type_id = TPS_INV_JOB_OR_SCHED
1818: AND mti.wip_entity_type =WIP_CONSTANTS.DISCRETE
1819: AND msi.lot_control_code = WIP_CONSTANTS.LOT

Line 1816: AND mti.transaction_type_id in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)

1812: FROM mtl_transactions_interface mti,
1813: mtl_system_items msi
1814: WHERE mti.transaction_header_id =p_mtl_header_id
1815: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)
1816: AND mti.transaction_type_id in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)
1817: AND mti.transaction_source_type_id = TPS_INV_JOB_OR_SCHED
1818: AND mti.wip_entity_type =WIP_CONSTANTS.DISCRETE
1819: AND msi.lot_control_code = WIP_CONSTANTS.LOT
1820: AND msi.organization_id = mti.organization_id

Line 1818: AND mti.wip_entity_type =WIP_CONSTANTS.DISCRETE

1814: WHERE mti.transaction_header_id =p_mtl_header_id
1815: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)
1816: AND mti.transaction_type_id in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)
1817: AND mti.transaction_source_type_id = TPS_INV_JOB_OR_SCHED
1818: AND mti.wip_entity_type =WIP_CONSTANTS.DISCRETE
1819: AND msi.lot_control_code = WIP_CONSTANTS.LOT
1820: AND msi.organization_id = mti.organization_id
1821: AND msi.inventory_item_id = mti.inventory_item_id
1822: AND msi.shelf_life_code = WIP_CONSTANTS.SHELF_LIFE

Line 1819: AND msi.lot_control_code = WIP_CONSTANTS.LOT

1815: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)
1816: AND mti.transaction_type_id in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)
1817: AND mti.transaction_source_type_id = TPS_INV_JOB_OR_SCHED
1818: AND mti.wip_entity_type =WIP_CONSTANTS.DISCRETE
1819: AND msi.lot_control_code = WIP_CONSTANTS.LOT
1820: AND msi.organization_id = mti.organization_id
1821: AND msi.inventory_item_id = mti.inventory_item_id
1822: AND msi.shelf_life_code = WIP_CONSTANTS.SHELF_LIFE
1823: AND mtli.transaction_interface_id =

Line 1822: AND msi.shelf_life_code = WIP_CONSTANTS.SHELF_LIFE

1818: AND mti.wip_entity_type =WIP_CONSTANTS.DISCRETE
1819: AND msi.lot_control_code = WIP_CONSTANTS.LOT
1820: AND msi.organization_id = mti.organization_id
1821: AND msi.inventory_item_id = mti.inventory_item_id
1822: AND msi.shelf_life_code = WIP_CONSTANTS.SHELF_LIFE
1823: AND mtli.transaction_interface_id =
1824: mti.transaction_interface_id)
1825: WHERE mtli.lot_expiration_date IS NULL
1826: AND mtli.transaction_interface_id IN

Line 1833: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)

1829: mtl_system_items msi
1830: WHERE mti.organization_id = msi.organization_id
1831: AND mti.inventory_item_id = msi.inventory_item_id
1832: AND mti.transaction_header_id = p_mtl_header_id
1833: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)
1834: AND mti.transaction_type_id in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)
1835: AND mti.transaction_source_type_id = TPS_INV_JOB_OR_SCHED
1836: AND mti.wip_entity_type =WIP_CONSTANTS.DISCRETE
1837: AND msi.lot_control_code = WIP_CONSTANTS.LOT);

Line 1834: AND mti.transaction_type_id in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)

1830: WHERE mti.organization_id = msi.organization_id
1831: AND mti.inventory_item_id = msi.inventory_item_id
1832: AND mti.transaction_header_id = p_mtl_header_id
1833: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)
1834: AND mti.transaction_type_id in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)
1835: AND mti.transaction_source_type_id = TPS_INV_JOB_OR_SCHED
1836: AND mti.wip_entity_type =WIP_CONSTANTS.DISCRETE
1837: AND msi.lot_control_code = WIP_CONSTANTS.LOT);
1838:

Line 1836: AND mti.wip_entity_type =WIP_CONSTANTS.DISCRETE

1832: AND mti.transaction_header_id = p_mtl_header_id
1833: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)
1834: AND mti.transaction_type_id in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)
1835: AND mti.transaction_source_type_id = TPS_INV_JOB_OR_SCHED
1836: AND mti.wip_entity_type =WIP_CONSTANTS.DISCRETE
1837: AND msi.lot_control_code = WIP_CONSTANTS.LOT);
1838:
1839: -- IF debug message level = 2, write statement below to log file
1840: IF (l_log_level <= wip_constants.full_logging) THEN

Line 1837: AND msi.lot_control_code = WIP_CONSTANTS.LOT);

1833: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)
1834: AND mti.transaction_type_id in (WIP_CONSTANTS.RETASSY_TYPE,WIP_CONSTANTS.CPLASSY_TYPE)
1835: AND mti.transaction_source_type_id = TPS_INV_JOB_OR_SCHED
1836: AND mti.wip_entity_type =WIP_CONSTANTS.DISCRETE
1837: AND msi.lot_control_code = WIP_CONSTANTS.LOT);
1838:
1839: -- IF debug message level = 2, write statement below to log file
1840: IF (l_log_level <= wip_constants.full_logging) THEN
1841: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');

Line 1840: IF (l_log_level <= wip_constants.full_logging) THEN

1836: AND mti.wip_entity_type =WIP_CONSTANTS.DISCRETE
1837: AND msi.lot_control_code = WIP_CONSTANTS.LOT);
1838:
1839: -- IF debug message level = 2, write statement below to log file
1840: IF (l_log_level <= wip_constants.full_logging) THEN
1841: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
1842: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
1843: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
1844: l_msg := fnd_message.get;

Line 1870: IF(l_cost_method IN (wip_constants.cost_avg,wip_constants.cost_fifo,

1866: WHERE organization_id = p_org_id;
1867:
1868: l_process_phase := '4';
1869: --insert a row into cst_comp_snap_temp
1870: IF(l_cost_method IN (wip_constants.cost_avg,wip_constants.cost_fifo,
1871: wip_constants.cost_lifo)) THEN
1872: l_ret_value := CSTACOSN.op_snapshot(i_txn_temp_id => p_interface_id,
1873: err_num => l_err_num,
1874: err_code => l_error_msg,

Line 1871: wip_constants.cost_lifo)) THEN

1867:
1868: l_process_phase := '4';
1869: --insert a row into cst_comp_snap_temp
1870: IF(l_cost_method IN (wip_constants.cost_avg,wip_constants.cost_fifo,
1871: wip_constants.cost_lifo)) THEN
1872: l_ret_value := CSTACOSN.op_snapshot(i_txn_temp_id => p_interface_id,
1873: err_num => l_err_num,
1874: err_code => l_error_msg,
1875: err_msg => l_error_msg);

Line 1896: IF (l_log_level <= wip_constants.full_logging) then

1892: p_business_flow_code => 26); -- discrete business flow code
1893: -- do not error out if label printing, only put warning message in log
1894: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1895: wip_utilities.get_message_stack(p_msg => l_msg_stack);
1896: IF (l_log_level <= wip_constants.full_logging) then
1897: wip_logger.log(p_msg => 'An error has occurred with label printing.\n' ||
1898: 'The following error has occurred during ' ||
1899: 'printing: ' || l_msg_stack || '\n' ||
1900: 'Please check the Inventory log file for more ' ||

Line 1915: l_oc_rec.wipEntityType := WIP_CONSTANTS.DISCRETE;

1911: FETCH c_cmp_txn INTO l_cmp_txn;
1912:
1913: IF(p_oc_primary_qty IS NOT NULL AND p_oc_primary_qty > 0) THEN
1914: -- Initialize l_oc_rec
1915: l_oc_rec.wipEntityType := WIP_CONSTANTS.DISCRETE;
1916: l_oc_rec.wipEntityID := l_cmp_txn.wip_entity_id;
1917: l_oc_rec.orgID := l_cmp_txn.org_id;
1918: l_oc_rec.repLineID := null; -- only used for repetitive
1919: l_oc_rec.itemID := l_cmp_txn.item_id;

Line 1937: l_oc_rec.txnMode := WIP_CONSTANTS.ONLINE;

1933: l_oc_rec.overCplPriQty := p_oc_primary_qty;
1934: l_oc_rec.lastUpdBy := l_cmp_txn.last_updated_by;
1935: l_oc_rec.createdBy := l_cmp_txn.created_by;
1936: l_oc_rec.lpnID := null; -- only used for LPN
1937: l_oc_rec.txnMode := WIP_CONSTANTS.ONLINE;
1938: l_oc_rec.overCplTxnID := l_cmp_txn.oc_txn_id;
1939:
1940: wip_cplProc_priv.processOverCpl(p_cplRec => l_oc_rec,
1941: x_returnStatus => x_returnStatus);

Line 1952: p_txnMode => WIP_CONSTANTS.ONLINE,

1948: l_process_phase := '7';
1949: wip_mtlTempProc_priv.processTemp
1950: (p_initMsgList => fnd_api.g_true,
1951: p_txnHdrID => p_mtl_header_id,
1952: p_txnMode => WIP_CONSTANTS.ONLINE,
1953: x_returnStatus => x_returnStatus,
1954: x_errorMsg => l_error_msg);
1955:
1956: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

Line 1969: l_cmp_txn.action_id = WIP_CONSTANTS.RETASSY_ACTION) THEN

1965: -- clear the group mark id when processing a serial. Here we have to
1966: -- repopulate the group_mark_id, wip_entity_id, op_seq, and
1967: -- intra_op columns.
1968: IF (p_assySerial IS NOT NULL AND
1969: l_cmp_txn.action_id = WIP_CONSTANTS.RETASSY_ACTION) THEN
1970: -- Check whether the job has routing or not.
1971: IF(l_cmp_txn.op_seq_num = -1) THEN
1972: -- No routing
1973: l_op_seq := null;

Line 1977: l_step := WIP_CONSTANTS.TOMOVE;

1973: l_op_seq := null;
1974: l_step := null;
1975: ELSE
1976: l_op_seq := l_cmp_txn.op_seq_num;
1977: l_step := WIP_CONSTANTS.TOMOVE;
1978: END IF;
1979:
1980: wip_utilities.update_serial(p_serial_number => p_assySerial,
1981: p_inventory_item_id => l_cmp_txn.item_id,

Line 2000: IF (l_log_level <= wip_constants.trace_logging) THEN

1996: END IF;
1997:
1998: x_returnStatus := fnd_api.g_ret_sts_success;
1999: -- write to the log file
2000: IF (l_log_level <= wip_constants.trace_logging) THEN
2001: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processOATxn',
2002: p_procReturnStatus => x_returnStatus,
2003: p_msg => 'procedure complete',
2004: x_returnStatus => l_return_status);

Line 2017: IF (l_log_level <= wip_constants.trace_logging) THEN

2013: END IF;
2014: ROLLBACK TO SAVEPOINT s_oa_txn_proc;
2015: x_returnStatus := fnd_api.g_ret_sts_error;
2016:
2017: IF (l_log_level <= wip_constants.trace_logging) THEN
2018: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processOATxn',
2019: p_procReturnStatus => x_returnStatus,
2020: p_msg => 'wip_cplProc_priv.processOATxn failed : '
2021: || l_process_phase,

Line 2039: IF (l_log_level <= wip_constants.trace_logging) THEN

2035: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2036: fnd_message.set_token('MESSAGE', l_error_msg);
2037: fnd_msg_pub.add;
2038:
2039: IF (l_log_level <= wip_constants.trace_logging) THEN
2040: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processOATxn',
2041: p_procReturnStatus => x_returnStatus,
2042: p_msg => l_error_msg || ' : ' || l_process_phase,
2043: x_returnStatus => l_return_status);