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.WMA_INV_WRAPPERS dependencies on FND_API

Line 27: if(x_return_status = FND_API.G_RET_STS_SUCCESS) then --lot exists in mtl_lot_numbers

23: if(l_msg_count > 1) then
24: inv_mobile_helper_functions.get_stacked_messages(x_err_msg);
25: end if;
26:
27: if(x_return_status = FND_API.G_RET_STS_SUCCESS) then --lot exists in mtl_lot_numbers
28: select expiration_date
29: into x_lot_exp
30: from mtl_lot_numbers
31: where lot_number = p_lot_number

Line 37: x_return_status := fnd_api.g_ret_sts_unexp_error;

33: and organization_id = p_organization_id;
34: end if;
35: EXCEPTION
36: when others then
37: x_return_status := fnd_api.g_ret_sts_unexp_error;
38: END validateLot;
39:
40: PROCEDURE insertLot(p_header_id IN NUMBER,
41: p_lot_number IN VARCHAR2,

Line 57: x_return_status := fnd_api.g_ret_sts_unexp_error;

53: inv_mobile_helper_functions.get_stacked_messages(x_err_msg);
54: end if;
55: EXCEPTION
56: when others then
57: x_return_status := fnd_api.g_ret_sts_unexp_error;
58: end insertLot;
59:
60: PROCEDURE createLots(p_header_id IN NUMBER,
61: x_err_msg OUT NOCOPY VARCHAR2,

Line 71: x_return_status := fnd_api.G_RET_STS_SUCCESS;

67:
68: l_msg_count NUMBER;
69:
70: BEGIN
71: x_return_status := fnd_api.G_RET_STS_SUCCESS;
72: SAVEPOINT preProc;
73: FOR lots_rec in lots(p_header_id) LOOP
74: wms_wip_integration.insert_lot(p_header_id, lots_rec.lot_number, x_return_status, l_msg_count, x_err_msg);
75: if(x_return_status = fnd_api.g_ret_sts_unexp_error) then

Line 75: if(x_return_status = fnd_api.g_ret_sts_unexp_error) then

71: x_return_status := fnd_api.G_RET_STS_SUCCESS;
72: SAVEPOINT preProc;
73: FOR lots_rec in lots(p_header_id) LOOP
74: wms_wip_integration.insert_lot(p_header_id, lots_rec.lot_number, x_return_status, l_msg_count, x_err_msg);
75: if(x_return_status = fnd_api.g_ret_sts_unexp_error) then
76: ROLLBACK TO SAVEPOINT preProc;
77: exit;
78: end if;
79: end LOOP;

Line 85: x_return_status := fnd_api.g_ret_sts_unexp_error;

81: inv_mobile_helper_functions.get_stacked_messages(x_err_msg);
82: end if;
83: EXCEPTION
84: when others then
85: x_return_status := fnd_api.g_ret_sts_unexp_error;
86: END createLots;
87:
88: PROCEDURE updateSerials(p_header_id IN NUMBER,
89: x_err_msg OUT NOCOPY VARCHAR2,

Line 99: x_return_status := fnd_api.G_RET_STS_SUCCESS;

95:
96: l_msg_count NUMBER;
97:
98: BEGIN
99: x_return_status := fnd_api.G_RET_STS_SUCCESS;
100: SAVEPOINT preProc;
101: FOR serials_rec in serials(p_header_id) LOOP
102: wms_wip_integration.update_serial(p_header_id => p_header_id,
103: p_serial_number => serials_rec.fm_serial_number,

Line 107: if(x_return_status <> fnd_api.g_ret_sts_success) then

103: p_serial_number => serials_rec.fm_serial_number,
104: x_return_status => x_return_status,
105: x_msg_count => l_msg_count,
106: x_msg_data => x_err_msg);
107: if(x_return_status <> fnd_api.g_ret_sts_success) then
108: ROLLBACK TO SAVEPOINT preProc;
109: if(l_msg_count > 1) then
110: inv_mobile_helper_functions.get_stacked_messages(x_err_msg);
111: end if;

Line 117: x_return_status := fnd_api.g_ret_sts_unexp_error;

113: end if;
114: end loop;
115: EXCEPTION
116: when others then
117: x_return_status := fnd_api.g_ret_sts_unexp_error;
118: END updateSerials;
119:
120: PROCEDURE updateLSAttributes(p_header_id IN NUMBER,
121: x_return_status OUT NOCOPY VARCHAR2,

Line 123: x_return_status := fnd_api.G_RET_STS_SUCCESS;

119:
120: PROCEDURE updateLSAttributes(p_header_id IN NUMBER,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_err_msg OUT NOCOPY VARCHAR2) IS BEGIN
123: x_return_status := fnd_api.G_RET_STS_SUCCESS;
124: createLots(p_header_id, x_err_msg, x_return_status);
125: if(x_return_status = fnd_api.G_RET_STS_SUCCESS) then
126: updateSerials(p_header_id, x_err_msg, x_return_status);
127: end if;

Line 125: if(x_return_status = fnd_api.G_RET_STS_SUCCESS) then

121: x_return_status OUT NOCOPY VARCHAR2,
122: x_err_msg OUT NOCOPY VARCHAR2) IS BEGIN
123: x_return_status := fnd_api.G_RET_STS_SUCCESS;
124: createLots(p_header_id, x_err_msg, x_return_status);
125: if(x_return_status = fnd_api.G_RET_STS_SUCCESS) then
126: updateSerials(p_header_id, x_err_msg, x_return_status);
127: end if;
128: EXCEPTION
129: when others then

Line 130: x_return_status := fnd_api.g_ret_sts_unexp_error;

126: updateSerials(p_header_id, x_err_msg, x_return_status);
127: end if;
128: EXCEPTION
129: when others then
130: x_return_status := fnd_api.g_ret_sts_unexp_error;
131: end updateLSAttributes;
132:
133: PROCEDURE backflush(p_header_id IN NUMBER,
134: x_return_status OUT NOCOPY VARCHAR2,

Line 149: x_return_status := fnd_api.g_ret_sts_unexp_error;

145: inv_mobile_helper_functions.get_stacked_messages(x_err_msg);
146: end if;
147: EXCEPTION
148: when others then
149: x_return_status := fnd_api.g_ret_sts_unexp_error;
150: END backflush;
151:
152: PROCEDURE createLpn(p_api_version IN NUMBER,
153: p_commit IN VARCHAR2,

Line 181: x_return_status := fnd_api.g_ret_sts_unexp_error;

177: inv_mobile_helper_functions.get_stacked_messages(x_err_msg);
178: end if;
179: EXCEPTION
180: when others then
181: x_return_status := fnd_api.g_ret_sts_unexp_error;
182: END createLpn;
183:
184: PROCEDURE packLpnContainer(p_api_version IN NUMBER,
185: p_commit IN VARCHAR2,

Line 224: x_return_status := fnd_api.g_ret_sts_unexp_error;

220: inv_mobile_helper_functions.get_stacked_messages(x_err_msg);
221: end if;
222: EXCEPTION
223: when others then
224: x_return_status := fnd_api.g_ret_sts_unexp_error;
225: END packLpnContainer;
226:
227: PROCEDURE packSerials(p_api_version IN NUMBER,
228: p_commit IN VARCHAR2,

Line 267: x_return_status := fnd_api.g_ret_sts_unexp_error;

263: inv_mobile_helper_functions.get_stacked_messages(x_err_msg);
264: end if;
265: EXCEPTION
266: when others then
267: x_return_status := fnd_api.g_ret_sts_unexp_error;
268: END packSerials;
269:
270: PROCEDURE createMO(p_organization_id IN NUMBER,
271: p_inventory_item_id IN NUMBER,

Line 316: x_return_status := fnd_api.g_ret_sts_unexp_error;

312: inv_mobile_helper_functions.get_stacked_messages(x_err_msg);
313: end if;
314: EXCEPTION
315: when others then
316: x_return_status := fnd_api.g_ret_sts_unexp_error;
317: END createMO;
318:
319: PROCEDURE OkMOLines(p_lpn_id IN NUMBER,
320: x_return_status OUT NOCOPY VARCHAR2,

Line 336: x_return_status := fnd_api.g_ret_sts_unexp_error;

332: inv_mobile_helper_functions.get_stacked_messages(x_err_msg);
333: end if;
334: EXCEPTION
335: when others then
336: x_return_status := fnd_api.g_ret_sts_unexp_error;
337: END OkMOLines;
338:
339: PROCEDURE updateLpnContext(p_api_version IN NUMBER,
340: p_init_msg_list IN VARCHAR2,

Line 365: x_return_status := fnd_api.g_ret_sts_unexp_error;

361: inv_mobile_helper_functions.get_stacked_messages(x_err_msg);
362: end if;
363: EXCEPTION
364: when others then
365: x_return_status := fnd_api.g_ret_sts_unexp_error;
366: END updateLpnContext;
367:
368: PROCEDURE transferReservation(p_header_id IN NUMBER, --the header_id to the wlc table
369: p_subinventory_code IN VARCHAR2,

Line 477: x_return_status := FND_API.G_RET_STS_ERROR;

473: p_procReturnStatus => x_return_status,
474: p_msg => 'error:' || x_err_msg,
475: x_returnStatus => l_dummy);
476: end if;
477: x_return_status := FND_API.G_RET_STS_ERROR;
478: wip_logger.log('unhandled exception ' || SQLERRM, l_dummy);
479: fnd_message.set_name('WIP', 'GENERIC_ERROR');
480: fnd_message.set_token('FUNCTION', 'wmainvwb.transferReservation');
481: fnd_message.set_token('ERROR', SQLERRM);

Line 490: x_return_status := fnd_api.g_ret_sts_success;

486:
487: PROCEDURE clearQtyTrees(x_return_status OUT NOCOPY VARCHAR2,
488: x_err_msg OUT NOCOPY VARCHAR2) is
489: begin
490: x_return_status := fnd_api.g_ret_sts_success;
491: inv_quantity_tree_pub.clear_quantity_cache;
492: exception
493: when others then
494: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 494: x_return_status := fnd_api.g_ret_sts_unexp_error;

490: x_return_status := fnd_api.g_ret_sts_success;
491: inv_quantity_tree_pub.clear_quantity_cache;
492: exception
493: when others then
494: x_return_status := fnd_api.g_ret_sts_unexp_error;
495: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wma_inv_wrappers',
496: p_procedure_name => 'clearQtyTrees',
497: p_error_text => SQLERRM);
498: end clearQtyTrees;