DBA Data[Home] [Help]

APPS.WIP_MASSLOAD_PVT dependencies on WIP_OSP

Line 305: wip_osp.create_additional_req(wjsi_row.wip_entity_id,

301: -- changed to released, already existing stored procedures will create a po req.
302: if ( wjsi_row.start_quantity > l_qty and
303: wjsi_row.status_type = wip_constants.released and
304: l_statusType = wip_constants.unreleased ) then
305: wip_osp.create_additional_req(wjsi_row.wip_entity_id,
306: wjsi_row.organization_id,
307: null,
308: wjsi_row.start_quantity - l_qty);
309: end if;

Line 319: if(WIP_OSP.PO_REQ_EXISTS (

315:
316: if (l_addl_quantity > 0) then
317: /*job quantity increase*/
318:
319: if(WIP_OSP.PO_REQ_EXISTS (
320: p_wip_entity_id => wjsi_row.wip_entity_id,
321: p_rep_sched_id => null,
322: p_organization_id => wjsi_row.organization_id,
323: p_entity_type => 1) = TRUE) then

Line 333: wip_osp.updatePOReqQuantity(

329: from wip_parameters
330: where organization_id = wjsi_row.organization_id;
331:
332: if(l_propagate_job_change_to_po =WIP_CONSTANTS.YES)then
333: wip_osp.updatePOReqQuantity(
334: p_job_id => wjsi_row.wip_entity_id,
335: p_repetitive_id => null,
336: p_org_id => wjsi_row.organization_id,
337: p_changed_qty => l_addl_quantity,

Line 344: wip_osp.create_additional_req(

340:
341: if( l_retStatus <> 'S')then
342: -- If for somehow we cannot update PO quantity,
343: -- cut new requisition
344: wip_osp.create_additional_req(
345: p_wip_entity_id => wjsi_row.wip_entity_id,
346: p_organization_id => wjsi_row.organization_id,
347: p_repetitive_schedule_id =>null,
348: p_added_quantity =>l_addl_quantity);

Line 355: fnd_message.set_name('WIP','WIP_OSP_CHANGE_JOB_QTY');

351: wip_utilities.get_message_stack( p_msg => l_msg);
352:
353: end if; -- check return status
354: else -- not auto update PO quantity
355: fnd_message.set_name('WIP','WIP_OSP_CHANGE_JOB_QTY');
356: l_msg := fnd_message.get;
357: if (l_logLevel <= wip_constants.trace_logging) then
358: wip_logger.log(l_msg, l_retStatus);
359: end if;

Line 363: wip_osp.create_additional_req(

359: end if;
360: end if; -- check auto update PO quantity parameter
361: else -- customer does not have PO FPJ
362: --behave the old way by cutting new requisition
363: wip_osp.create_additional_req(
364: p_wip_entity_id => wjsi_row.wip_entity_id,
365: p_organization_id => wjsi_row.organization_id,
366: p_repetitive_schedule_id =>null,
367: p_added_quantity => l_addl_quantity);

Line 373: if(WIP_OSP.PO_REQ_EXISTS (

369: end if; -- PO/requisition exist
370: /*quantity increase*/
371: else
372: /*quantity decrease*/
373: if(WIP_OSP.PO_REQ_EXISTS (
374: p_wip_entity_id => wjsi_row.wip_entity_id,
375: p_rep_sched_id => null,
376: p_organization_id => wjsi_row.organization_id,
377: p_entity_type => 1) = TRUE) then

Line 388: wip_osp.updatePOReqQuantity(

384: where organization_id = wjsi_row.organization_id;
385: -- job quantity decrease
386: if(l_propagate_job_change_to_po =
387: WIP_CONSTANTS.YES) then
388: wip_osp.updatePOReqQuantity(
389: p_job_id => wjsi_row.wip_entity_id,
390: p_repetitive_id => null,
391: p_org_id => wjsi_row.organization_id,
392: p_changed_qty => l_addl_quantity,

Line 403: fnd_message.set_name('WIP','WIP_OSP_CHANGE_JOB_QTY');

399: -- the user continue their change.
400: wip_utilities.get_message_stack(p_msg => l_msg);
401: end if; -- check return status
402: else -- not auto update PO quantity
403: fnd_message.set_name('WIP','WIP_OSP_CHANGE_JOB_QTY');
404: l_msg := fnd_message.get;
405: if (l_logLevel <= wip_constants.trace_logging) then
406: wip_logger.log(l_msg, l_retStatus);
407: end if;

Line 410: fnd_message.set_name('WIP','WIP_OSP_CHANGE_JOB_QTY');

406: wip_logger.log(l_msg, l_retStatus);
407: end if;
408: end if; -- check auto update PO quantity parameter
409: else -- customer does not have PO FPJ
410: fnd_message.set_name('WIP','WIP_OSP_CHANGE_JOB_QTY');
411: l_msg := fnd_message.get;
412: if (l_logLevel <= wip_constants.trace_logging) then
413: wip_logger.log(l_msg, l_retStatus);
414: end if;