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 37: x_returnStatus := fnd_api.g_ret_sts_success;

33: l_projectID number;
34: l_taskID number;
35:
36: begin
37: x_returnStatus := fnd_api.g_ret_sts_success;
38: savepoint begin_process_wjsi;
39:
40: if (l_logLevel <= wip_constants.trace_logging) then
41: l_params(1).paramName := 'p_rowid';

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

42: l_params(1).paramValue := p_rowid;
43: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
44: p_params => l_params,
45: x_returnStatus => x_returnStatus);
46: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
47: raise fnd_api.g_exc_unexpected_error;
48: end if;
49: end if;
50:

Line 47: raise fnd_api.g_exc_unexpected_error;

43: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
44: p_params => l_params,
45: x_returnStatus => x_returnStatus);
46: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
47: raise fnd_api.g_exc_unexpected_error;
48: end if;
49: end if;
50:
51: select *

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

89: p_unitNumber => wjsi_row.end_item_unit_number, /* added for bug 5332615 */
90: x_serStartOp => l_serStartOp,
91: x_returnStatus => x_returnStatus,
92: x_errorMsg => x_errorMsg);
93: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
94: raise fnd_api.g_exc_unexpected_error;
95: end if;
96: end if;
97:

Line 94: raise fnd_api.g_exc_unexpected_error;

90: x_serStartOp => l_serStartOp,
91: x_returnStatus => x_returnStatus,
92: x_errorMsg => x_errorMsg);
93: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
94: raise fnd_api.g_exc_unexpected_error;
95: end if;
96: end if;
97:
98: -- default the serialization start op

Line 139: raise fnd_api.g_exc_unexpected_error;

135: l_success,
136: x_errorMsg,
137: nvl(wjsi_row.date_released, sysdate));
138: if ( l_success = 0 ) then
139: raise fnd_api.g_exc_unexpected_error;
140: end if;
141: end if;
142:
143: elsif ( wjsi_row.load_type = wip_constants.resched_job ) then

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

209: p_bomRefID => nvl(wjsi_row.bom_reference_id, l_bomRefID),
210: p_unitNumber => wjsi_row.end_item_unit_number, /* added for bug 5332615 */
211: x_returnStatus => x_returnStatus,
212: x_errorMsg => x_errorMsg);
213: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
214: raise fnd_api.g_exc_unexpected_error;
215: end if;
216:
217: -- handle status change

Line 214: raise fnd_api.g_exc_unexpected_error;

210: p_unitNumber => wjsi_row.end_item_unit_number, /* added for bug 5332615 */
211: x_returnStatus => x_returnStatus,
212: x_errorMsg => x_errorMsg);
213: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
214: raise fnd_api.g_exc_unexpected_error;
215: end if;
216:
217: -- handle status change
218: if ( l_statusType <> wjsi_row.status_type and

Line 230: raise fnd_api.g_exc_unexpected_error;

226: l_success,
227: x_errorMsg,
228: nvl(wjsi_row.date_released, sysdate));
229: if ( l_success = 0 ) then
230: raise fnd_api.g_exc_unexpected_error;
231: end if;
232: end if;
233:
234: -- handles pick release related issues

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

241: p_repetitive_schedule_id => wjsi_row.repetitive_schedule_id,
242: p_new_job_qty => wjsi_row.start_quantity,
243: x_return_status => l_retStatus,
244: x_msg_data => x_errorMsg);
245: if ( l_retStatus <> fnd_api.g_ret_sts_success ) then
246: raise fnd_api.g_exc_unexpected_error;
247: end if;
248: end if;
249:

Line 246: raise fnd_api.g_exc_unexpected_error;

242: p_new_job_qty => wjsi_row.start_quantity,
243: x_return_status => l_retStatus,
244: x_msg_data => x_errorMsg);
245: if ( l_retStatus <> fnd_api.g_ret_sts_success ) then
246: raise fnd_api.g_exc_unexpected_error;
247: end if;
248: end if;
249:
250: if ( wjsi_row.status_type in (wip_constants.comp_nochrg,

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

253: wip_picking_pvt.cancel_allocations(p_wip_entity_id => wjsi_row.wip_entity_id,
254: p_wip_entity_type => wip_constants.discrete,
255: x_return_status => l_retStatus,
256: x_msg_data => x_errorMsg);
257: if ( l_retStatus <> fnd_api.g_ret_sts_success ) then
258: raise fnd_api.g_exc_unexpected_error;
259: end if;
260: end if;
261:

Line 258: raise fnd_api.g_exc_unexpected_error;

254: p_wip_entity_type => wip_constants.discrete,
255: x_return_status => l_retStatus,
256: x_msg_data => x_errorMsg);
257: if ( l_retStatus <> fnd_api.g_ret_sts_success ) then
258: raise fnd_api.g_exc_unexpected_error;
259: end if;
260: end if;
261:
262: -- Call the stored procedure to create a po req only if both old and new statuses

Line 296: when fnd_api.g_exc_unexpected_error then

292: x_returnStatus => l_retStatus);
293: end if;
294:
295: exception
296: when fnd_api.g_exc_unexpected_error then
297: rollback to savepoint begin_process_wjsi;
298: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
299: if(l_logLevel <= wip_constants.trace_logging) then
300: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

Line 298: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

294:
295: exception
296: when fnd_api.g_exc_unexpected_error then
297: rollback to savepoint begin_process_wjsi;
298: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
299: if(l_logLevel <= wip_constants.trace_logging) then
300: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
301: p_procReturnStatus => x_returnStatus,
302: p_msg => x_errorMsg,

Line 313: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

309: p_procReturnStatus => x_returnStatus,
310: p_msg => 'unexp error:' || SQLERRM,
311: x_returnStatus => l_retStatus);
312: end if;
313: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
314: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkgName,
315: p_procedure_name => l_procName,
316: p_error_text => SQLERRM);
317: wip_utilities.get_message_stack(p_msg => l_msg);

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

691: wj.completion_subinventory,
692: null, wdj.completion_locator_id,
693: wj.completion_locator_id),*/
694: /* Bug 5446216 (FP Bug 5504790) : Completion subinventory and/or locator will be nulled out
695: when fnd_api.g_miss_char and fnd_api.g_miss_num is passed for respective fields */
696: decode(wj.completion_subinventory,
697: NULL, wdj.completion_subinventory,
698: fnd_api.g_miss_char, NULL,
699: wj.completion_subinventory),

Line 698: fnd_api.g_miss_char, NULL,

694: /* Bug 5446216 (FP Bug 5504790) : Completion subinventory and/or locator will be nulled out
695: when fnd_api.g_miss_char and fnd_api.g_miss_num is passed for respective fields */
696: decode(wj.completion_subinventory,
697: NULL, wdj.completion_subinventory,
698: fnd_api.g_miss_char, NULL,
699: wj.completion_subinventory),
700: decode(wj.completion_subinventory,
701: NULL, decode(wj.completion_locator_id,
702: NULL, wdj.completion_locator_id,

Line 704: fnd_api.g_miss_char, NULL,

700: decode(wj.completion_subinventory,
701: NULL, decode(wj.completion_locator_id,
702: NULL, wdj.completion_locator_id,
703: wj.completion_locator_id),
704: fnd_api.g_miss_char, NULL,
705: decode(wj.completion_locator_id,
706: fnd_api.g_miss_num, NULL,
707: wj.completion_locator_id)),
708: NVL(WJ.DESCRIPTION,WDJ.DESCRIPTION),

Line 706: fnd_api.g_miss_num, NULL,

702: NULL, wdj.completion_locator_id,
703: wj.completion_locator_id),
704: fnd_api.g_miss_char, NULL,
705: decode(wj.completion_locator_id,
706: fnd_api.g_miss_num, NULL,
707: wj.completion_locator_id)),
708: NVL(WJ.DESCRIPTION,WDJ.DESCRIPTION),
709: NVL(WJ.SOURCE_CODE,WDJ.SOURCE_CODE),
710: NVL(WJ.SOURCE_LINE_ID,WDJ.SOURCE_LINE_ID),

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

766: --No check on status type is needed becaue this is already considered during validation phase.
767: --DECODE(WDJ.JOB_TYPE, wip_constants.standard, nvl(WJ.ALTERNATE_BOM_DESIGNATOR, WDJ.ALTERNATE_BOM_DESIGNATOR), null),
768: --DECODE(WDJ.JOB_TYPE, wip_constants.standard, nvl(WJ.ALTERNATE_ROUTING_DESIGNATOR, WDJ.ALTERNATE_ROUTING_DESIGNATOR), null)
769: /*DECODE(WDJ.JOB_TYPE, wip_constants.standard,
770: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR),
771: DECODE(
772: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
773: NULL,NULL,
774: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR))),

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

770: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR),
771: DECODE(
772: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
773: NULL,NULL,
774: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR))),
775: DECODE(WDJ.JOB_TYPE, wip_constants.standard,
776: DECODE(WJ.ALTERNATE_ROUTING_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_ROUTING_DESIGNATOR,WJ.ALTERNATE_ROUTING_DESIGNATOR),
777: DECODE(
778: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.ROUTING_REFERENCE_ID,WDJ.ROUTING_REFERENCE_ID),

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

772: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),
773: NULL,NULL,
774: DECODE(WJ.ALTERNATE_BOM_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_BOM_DESIGNATOR,WJ.ALTERNATE_BOM_DESIGNATOR))),
775: DECODE(WDJ.JOB_TYPE, wip_constants.standard,
776: DECODE(WJ.ALTERNATE_ROUTING_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_ROUTING_DESIGNATOR,WJ.ALTERNATE_ROUTING_DESIGNATOR),
777: DECODE(
778: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.ROUTING_REFERENCE_ID,WDJ.ROUTING_REFERENCE_ID),
779: NULL,NULL,
780: DECODE(WJ.ALTERNATE_ROUTING_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_ROUTING_DESIGNATOR,WJ.ALTERNATE_ROUTING_DESIGNATOR))),

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

776: DECODE(WJ.ALTERNATE_ROUTING_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_ROUTING_DESIGNATOR,WJ.ALTERNATE_ROUTING_DESIGNATOR),
777: DECODE(
778: DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.ROUTING_REFERENCE_ID,WDJ.ROUTING_REFERENCE_ID),
779: NULL,NULL,
780: DECODE(WJ.ALTERNATE_ROUTING_DESIGNATOR,fnd_api.g_miss_char,WDJ.ALTERNATE_ROUTING_DESIGNATOR,WJ.ALTERNATE_ROUTING_DESIGNATOR))),
781: Modified update on ALTERNATE_BOM_DESIGNATOR,ALTERNATE_ROUTING_DESIGNATOR for bug 5479283.
782: This maintains old value when null is passed */
783: DECODE(WDJ.JOB_TYPE, wip_constants.standard,WJ.ALTERNATE_BOM_DESIGNATOR,
784: DECODE(DECODE(NVL(WJ.STATUS_TYPE,WDJ.STATUS_TYPE),WIP_CONSTANTS.UNRELEASED,WJ.BOM_REFERENCE_ID,WDJ.BOM_REFERENCE_ID),