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_MASSLOAD_PVT dependencies on FND_API

Line 48: x_returnStatus := fnd_api.g_ret_sts_success;

44: l_addl_quantity number;
45: l_propagate_job_change_to_po number;
46: /* Bug 13792234 @End */
47: begin
48: x_returnStatus := fnd_api.g_ret_sts_success;
49: savepoint begin_process_wjsi;
50:
51: if (l_logLevel <= wip_constants.trace_logging) then
52: l_params(1).paramName := 'p_rowid';

Line 57: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

53: l_params(1).paramValue := p_rowid;
54: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
55: p_params => l_params,
56: x_returnStatus => x_returnStatus);
57: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
58: raise fnd_api.g_exc_unexpected_error;
59: end if;
60: end if;
61:

Line 58: raise fnd_api.g_exc_unexpected_error;

54: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
55: p_params => l_params,
56: x_returnStatus => x_returnStatus);
57: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
58: raise fnd_api.g_exc_unexpected_error;
59: end if;
60: end if;
61:
62: select *

Line 108: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then

104: p_unitNumber => wjsi_row.end_item_unit_number, /* added for bug 5332615 */
105: x_serStartOp => l_serStartOp,
106: x_returnStatus => x_returnStatus,
107: x_errorMsg => x_errorMsg);
108: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
109: raise fnd_api.g_exc_unexpected_error;
110: end if;
111: end if;
112:

Line 109: raise fnd_api.g_exc_unexpected_error;

105: x_serStartOp => l_serStartOp,
106: x_returnStatus => x_returnStatus,
107: x_errorMsg => x_errorMsg);
108: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
109: raise fnd_api.g_exc_unexpected_error;
110: end if;
111: end if;
112:
113: -- default the serialization start op

Line 158: raise fnd_api.g_exc_unexpected_error;

154: l_success,
155: x_errorMsg,
156: nvl(wjsi_row.date_released, sysdate));
157: if ( l_success = 0 ) then
158: raise fnd_api.g_exc_unexpected_error;
159: end if;
160: end if;
161: */
162:

Line 245: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then

241: p_bomRefID => nvl(wjsi_row.bom_reference_id, l_bomRefID),
242: p_unitNumber => wjsi_row.end_item_unit_number, /* added for bug 5332615 */
243: x_returnStatus => x_returnStatus,
244: x_errorMsg => x_errorMsg);
245: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
246: raise fnd_api.g_exc_unexpected_error;
247: end if;
248:
249: -- handle status change

Line 246: raise fnd_api.g_exc_unexpected_error;

242: p_unitNumber => wjsi_row.end_item_unit_number, /* added for bug 5332615 */
243: x_returnStatus => x_returnStatus,
244: x_errorMsg => x_errorMsg);
245: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
246: raise fnd_api.g_exc_unexpected_error;
247: end if;
248:
249: -- handle status change
250: if ( l_statusType <> wjsi_row.status_type and

Line 264: raise fnd_api.g_exc_unexpected_error;

260: l_success,
261: x_errorMsg,
262: nvl(wjsi_row.date_released, sysdate));
263: if ( l_success = 0 ) then
264: raise fnd_api.g_exc_unexpected_error;
265: end if;
266: end if;
267:
268: -- handles pick release related issues

Line 279: if ( l_retStatus <> fnd_api.g_ret_sts_success ) then

275: p_repetitive_schedule_id => wjsi_row.repetitive_schedule_id,
276: p_new_job_qty => wjsi_row.start_quantity,
277: x_return_status => l_retStatus,
278: x_msg_data => x_errorMsg);
279: if ( l_retStatus <> fnd_api.g_ret_sts_success ) then
280: raise fnd_api.g_exc_unexpected_error;
281: end if;
282: end if;
283:

Line 280: raise fnd_api.g_exc_unexpected_error;

276: p_new_job_qty => wjsi_row.start_quantity,
277: x_return_status => l_retStatus,
278: x_msg_data => x_errorMsg);
279: if ( l_retStatus <> fnd_api.g_ret_sts_success ) then
280: raise fnd_api.g_exc_unexpected_error;
281: end if;
282: end if;
283:
284: if ( wjsi_row.status_type in (wip_constants.comp_nochrg,

Line 291: if ( l_retStatus <> fnd_api.g_ret_sts_success ) then

287: wip_picking_pvt.cancel_allocations(p_wip_entity_id => wjsi_row.wip_entity_id,
288: p_wip_entity_type => wip_constants.discrete,
289: x_return_status => l_retStatus,
290: x_msg_data => x_errorMsg);
291: if ( l_retStatus <> fnd_api.g_ret_sts_success ) then
292: raise fnd_api.g_exc_unexpected_error;
293: end if;
294: end if;
295:

Line 292: raise fnd_api.g_exc_unexpected_error;

288: p_wip_entity_type => wip_constants.discrete,
289: x_return_status => l_retStatus,
290: x_msg_data => x_errorMsg);
291: if ( l_retStatus <> fnd_api.g_ret_sts_success ) then
292: raise fnd_api.g_exc_unexpected_error;
293: end if;
294: end if;
295:
296: /* Bug 13792234 @start */

Line 444: when fnd_api.g_exc_unexpected_error then

440: x_returnStatus => l_retStatus);
441: end if;
442:
443: exception
444: when fnd_api.g_exc_unexpected_error then
445: rollback to savepoint begin_process_wjsi;
446: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
447: if(l_logLevel <= wip_constants.trace_logging) then
448: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

Line 446: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

442:
443: exception
444: when fnd_api.g_exc_unexpected_error then
445: rollback to savepoint begin_process_wjsi;
446: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
447: if(l_logLevel <= wip_constants.trace_logging) then
448: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
449: p_procReturnStatus => x_returnStatus,
450: p_msg => x_errorMsg,

Line 461: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

457: p_procReturnStatus => x_returnStatus,
458: p_msg => 'unexp error:' || SQLERRM,
459: x_returnStatus => l_retStatus);
460: end if;
461: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
462: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkgName,
463: p_procedure_name => l_procName,
464: p_error_text => SQLERRM);
465: wip_utilities.get_message_stack(p_msg => l_msg);

Line 845: when fnd_api.g_miss_char and fnd_api.g_miss_num is passed for respective fields */

841: wj.completion_subinventory,
842: null, wdj.completion_locator_id,
843: wj.completion_locator_id),*/
844: /* Bug 5446216 (FP Bug 5504790) : Completion subinventory and/or locator will be nulled out
845: when fnd_api.g_miss_char and fnd_api.g_miss_num is passed for respective fields */
846: decode(wj.completion_subinventory,
847: NULL, wdj.completion_subinventory,
848: fnd_api.g_miss_char, NULL,
849: wj.completion_subinventory),

Line 848: fnd_api.g_miss_char, NULL,

844: /* Bug 5446216 (FP Bug 5504790) : Completion subinventory and/or locator will be nulled out
845: when fnd_api.g_miss_char and fnd_api.g_miss_num is passed for respective fields */
846: decode(wj.completion_subinventory,
847: NULL, wdj.completion_subinventory,
848: fnd_api.g_miss_char, NULL,
849: wj.completion_subinventory),
850: decode(wj.completion_subinventory,
851: NULL, decode(wj.completion_locator_id,
852: NULL, wdj.completion_locator_id,

Line 854: fnd_api.g_miss_char, NULL,

850: decode(wj.completion_subinventory,
851: NULL, decode(wj.completion_locator_id,
852: NULL, wdj.completion_locator_id,
853: wj.completion_locator_id),
854: fnd_api.g_miss_char, NULL,
855: decode(wj.completion_locator_id,
856: fnd_api.g_miss_num, NULL,
857: wj.completion_locator_id)),
858: NVL(WJ.DESCRIPTION,WDJ.DESCRIPTION),

Line 856: fnd_api.g_miss_num, NULL,

852: NULL, wdj.completion_locator_id,
853: wj.completion_locator_id),
854: fnd_api.g_miss_char, NULL,
855: decode(wj.completion_locator_id,
856: fnd_api.g_miss_num, NULL,
857: wj.completion_locator_id)),
858: NVL(WJ.DESCRIPTION,WDJ.DESCRIPTION),
859: NVL(WJ.SOURCE_CODE,WDJ.SOURCE_CODE),
860: NVL(WJ.SOURCE_LINE_ID,WDJ.SOURCE_LINE_ID),

Line 920: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR),

916: --No check on status type is needed becaue this is already considered during validation phase.
917: --DECODE(WDJ.JOB_TYPE, wip_constants.standard, nvl(WJ.ALTERNATE_BOM_DESIGNATOR, WDJ.ALTERNATE_BOM_DESIGNATOR), null),
918: --DECODE(WDJ.JOB_TYPE, wip_constants.standard, nvl(WJ.ALTERNATE_ROUTING_DESIGNATOR, WDJ.ALTERNATE_ROUTING_DESIGNATOR), null)
919: /*DECODE(WDJ.JOB_TYPE, wip_constants.standard,
920: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR),
921: DECODE(
922: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
923: NULL,NULL,
924: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR))),

Line 924: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR))),

920: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR),
921: DECODE(
922: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
923: NULL,NULL,
924: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR))),
925: DECODE(WDJ.JOB_TYPE, wip_constants.standard,
926: DECODE(WJ.ALTERNATE_ROUTING_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_ROUTING_DESIGNATOR,WJ.ALTERNATE_ROUTING_DESIGNATOR),
927: DECODE(
928: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.ROUTING_REFERENCE_ID,WDJ.ROUTING_REFERENCE_ID),

Line 926: DECODE(WJ.ALTERNATE_ROUTING_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_ROUTING_DESIGNATOR,WJ.ALTERNATE_ROUTING_DESIGNATOR),

922: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
923: NULL,NULL,
924: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR))),
925: DECODE(WDJ.JOB_TYPE, wip_constants.standard,
926: DECODE(WJ.ALTERNATE_ROUTING_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_ROUTING_DESIGNATOR,WJ.ALTERNATE_ROUTING_DESIGNATOR),
927: DECODE(
928: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.ROUTING_REFERENCE_ID,WDJ.ROUTING_REFERENCE_ID),
929: NULL,NULL,
930: DECODE(WJ.ALTERNATE_ROUTING_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_ROUTING_DESIGNATOR,WJ.ALTERNATE_ROUTING_DESIGNATOR))),

Line 930: DECODE(WJ.ALTERNATE_ROUTING_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_ROUTING_DESIGNATOR,WJ.ALTERNATE_ROUTING_DESIGNATOR))),

926: DECODE(WJ.ALTERNATE_ROUTING_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_ROUTING_DESIGNATOR,WJ.ALTERNATE_ROUTING_DESIGNATOR),
927: DECODE(
928: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.ROUTING_REFERENCE_ID,WDJ.ROUTING_REFERENCE_ID),
929: NULL,NULL,
930: DECODE(WJ.ALTERNATE_ROUTING_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_ROUTING_DESIGNATOR,WJ.ALTERNATE_ROUTING_DESIGNATOR))),
931: Modified update on ALTERNATE_BOM_DESIGNATOR,ALTERNATE_ROUTING_DESIGNATOR for bug 5479283.
932: This maintains old value when null is passed */
933: DECODE(WDJ.JOB_TYPE, wip_constants.standard,WJ.ALTERNATE_BOM_DESIGNATOR,
934: DECODE(DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),