DBA Data[Home] [Help]

APPS.WMS_PARAMETER_EXT dependencies on FND_API

Line 100: --x_return_status := fnd_api.g_ret_sts_success;

96: and mmtt.transaction_temp_id = p_transaction_id;
97:
98: begin
99: -- ### Initialize API return status to success
100: --x_return_status := fnd_api.g_ret_sts_success;
101:
102: if (l_debug = 1) then
103: trace(' Entering procedure '|| l_proc || ':'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);
104: trace(l_proc || ' p_transaction_id => ' || nvl(p_transaction_id, -99));

Line 125: raise fnd_api.g_exc_error;

121:
122: if get_mo_line_info%NOTFOUND then
123: fnd_message.set_name('WMS', 'WMS_INVALID_TASK_ID');
124: fnd_msg_pub.ADD;
125: raise fnd_api.g_exc_error;
126: else
127: -- ### Print values derived from the cursor into the log file.
128: if (l_debug = 1) then
129: trace(l_proc || ' Printing Move Order Line and related task Information details...');

Line 168: when fnd_api.g_exc_error then

164:
165: return l_return_val_wrap;
166:
167: exception
168: when fnd_api.g_exc_error then
169: --x_return_status := fnd_api.g_ret_sts_error;
170: null;
171:
172: when others then

Line 169: --x_return_status := fnd_api.g_ret_sts_error;

165: return l_return_val_wrap;
166:
167: exception
168: when fnd_api.g_exc_error then
169: --x_return_status := fnd_api.g_ret_sts_error;
170: null;
171:
172: when others then
173: --x_return_status := fnd_api.g_ret_sts_error;

Line 173: --x_return_status := fnd_api.g_ret_sts_error;

169: --x_return_status := fnd_api.g_ret_sts_error;
170: null;
171:
172: when others then
173: --x_return_status := fnd_api.g_ret_sts_error;
174: if (l_debug = 1) then
175: trace(' Error Code, Error Message...' || sqlerrm(sqlcode), 1);
176: end if;
177: if get_mo_line_info%ISOPEN then

Line 246: --x_return_status := fnd_api.g_ret_sts_success;

242: and mmtt.transaction_temp_id = p_transaction_id;
243:
244: begin
245: -- ### Initialize API return status to success
246: --x_return_status := fnd_api.g_ret_sts_success;
247:
248: if (l_debug = 1) then
249: trace(' Entering procedure '|| l_proc || ':'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);
250: trace(l_proc || ' p_transaction_id => ' || nvl(p_transaction_id, -99));

Line 272: raise fnd_api.g_exc_error;

268:
269: if get_mo_line_info%NOTFOUND then
270: fnd_message.set_name('WMS', 'WMS_INVALID_TASK_ID');
271: fnd_msg_pub.ADD;
272: raise fnd_api.g_exc_error;
273: else
274: -- ### Print values derived from the cursor into the log file.
275: if (l_debug = 1) then
276: trace(l_proc || ' Printing Move Order Line and related task Information details...');

Line 326: when fnd_api.g_exc_error then

322:
323: return l_return_val_wrap;
324:
325: exception
326: when fnd_api.g_exc_error then
327: --x_return_status := fnd_api.g_ret_sts_error;
328: null;
329:
330: when others then

Line 327: --x_return_status := fnd_api.g_ret_sts_error;

323: return l_return_val_wrap;
324:
325: exception
326: when fnd_api.g_exc_error then
327: --x_return_status := fnd_api.g_ret_sts_error;
328: null;
329:
330: when others then
331: --x_return_status := fnd_api.g_ret_sts_error;

Line 331: --x_return_status := fnd_api.g_ret_sts_error;

327: --x_return_status := fnd_api.g_ret_sts_error;
328: null;
329:
330: when others then
331: --x_return_status := fnd_api.g_ret_sts_error;
332: if (l_debug = 1) then
333: trace(' Error Code, Error Message...' || sqlerrm(sqlcode), 1);
334: end if;
335: if get_mo_line_info%ISOPEN then

Line 430: when fnd_api.g_exc_error then

426: close get_item_primary_uom;
427:
428: return l_return_val_wrap;
429: exception
430: when fnd_api.g_exc_error then
431: --x_return_status := fnd_api.g_ret_sts_error;
432: null;
433:
434: when others then

Line 431: --x_return_status := fnd_api.g_ret_sts_error;

427:
428: return l_return_val_wrap;
429: exception
430: when fnd_api.g_exc_error then
431: --x_return_status := fnd_api.g_ret_sts_error;
432: null;
433:
434: when others then
435: --x_return_status := fnd_api.g_ret_sts_error;

Line 435: --x_return_status := fnd_api.g_ret_sts_error;

431: --x_return_status := fnd_api.g_ret_sts_error;
432: null;
433:
434: when others then
435: --x_return_status := fnd_api.g_ret_sts_error;
436: if (l_debug = 1) then
437: trace(' Error Code, Error Message...' || sqlerrm(sqlcode), 1);
438: end if;
439: if get_item_primary_uom%ISOPEN then

Line 522: when fnd_api.g_exc_error then

518: close get_lot_other_info;
519:
520: return l_return_val_wrap;
521: exception
522: when fnd_api.g_exc_error then
523: --x_return_status := fnd_api.g_ret_sts_error;
524: null;
525:
526: when others then

Line 523: --x_return_status := fnd_api.g_ret_sts_error;

519:
520: return l_return_val_wrap;
521: exception
522: when fnd_api.g_exc_error then
523: --x_return_status := fnd_api.g_ret_sts_error;
524: null;
525:
526: when others then
527: --x_return_status := fnd_api.g_ret_sts_error;

Line 527: --x_return_status := fnd_api.g_ret_sts_error;

523: --x_return_status := fnd_api.g_ret_sts_error;
524: null;
525:
526: when others then
527: --x_return_status := fnd_api.g_ret_sts_error;
528: if (l_debug = 1) then
529: trace(' Error Code, Error Message...' || sqlerrm(sqlcode), 1);
530: end if;
531: if get_lot_other_info%ISOPEN then