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

Line 22: -- p_organization_id in number required default = fnd_api.g_miss_num

18: -- This function is made available to be used within put away
19: -- rule setup.
20: -- Pre-reqs : none
21: -- Parameters :
22: -- p_organization_id in number required default = fnd_api.g_miss_num
23: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
24: -- p_locator_id in number optional default = null
25: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
26: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char

Line 23: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char

19: -- rule setup.
20: -- Pre-reqs : none
21: -- Parameters :
22: -- p_organization_id in number required default = fnd_api.g_miss_num
23: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
24: -- p_locator_id in number optional default = null
25: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
26: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
27: -- return value out number

Line 25: -- p_inventory_item_id in number required default = fnd_api.g_miss_num

21: -- Parameters :
22: -- p_organization_id in number required default = fnd_api.g_miss_num
23: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
24: -- p_locator_id in number optional default = null
25: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
26: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
27: -- return value out number
28: -- Version : not tracked
29: -- Notes : capacity should be returned as measured in txn UOM

Line 26: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char

22: -- p_organization_id in number required default = fnd_api.g_miss_num
23: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
24: -- p_locator_id in number optional default = null
25: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
26: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
27: -- return value out number
28: -- Version : not tracked
29: -- Notes : capacity should be returned as measured in txn UOM
30: -- End of comments

Line 71: -- p_organization_id in number required default = fnd_api.g_miss_num

67: -- This function is made available to be used within put away
68: -- rule setup.
69: -- Pre-reqs : none
70: -- Parameters :
71: -- p_organization_id in number required default = fnd_api.g_miss_num
72: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
73: -- p_locator_id in number optional default = null
74: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
75: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char

Line 72: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char

68: -- rule setup.
69: -- Pre-reqs : none
70: -- Parameters :
71: -- p_organization_id in number required default = fnd_api.g_miss_num
72: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
73: -- p_locator_id in number optional default = null
74: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
75: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
76: -- return value out number

Line 74: -- p_inventory_item_id in number required default = fnd_api.g_miss_num

70: -- Parameters :
71: -- p_organization_id in number required default = fnd_api.g_miss_num
72: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
73: -- p_locator_id in number optional default = null
74: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
75: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
76: -- return value out number
77: -- Version : not tracked
78: -- Notes : capacity should be returned as measured in txn UOM

Line 75: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char

71: -- p_organization_id in number required default = fnd_api.g_miss_num
72: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
73: -- p_locator_id in number optional default = null
74: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
75: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
76: -- return value out number
77: -- Version : not tracked
78: -- Notes : capacity should be returned as measured in txn UOM
79: -- End of comments

Line 120: -- p_organization_id in number required default = fnd_api.g_miss_num

116: -- This function is made available to be used within put away
117: -- rule setup.
118: -- Pre-reqs : none
119: -- Parameters :
120: -- p_organization_id in number required default = fnd_api.g_miss_num
121: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
122: -- p_locator_id in number optional default = null
123: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
124: -- p_transaction_quantity in number required default = fnd_api.g_miss_num

Line 121: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char

117: -- rule setup.
118: -- Pre-reqs : none
119: -- Parameters :
120: -- p_organization_id in number required default = fnd_api.g_miss_num
121: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
122: -- p_locator_id in number optional default = null
123: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
124: -- p_transaction_quantity in number required default = fnd_api.g_miss_num
125: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char

Line 123: -- p_inventory_item_id in number required default = fnd_api.g_miss_num

119: -- Parameters :
120: -- p_organization_id in number required default = fnd_api.g_miss_num
121: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
122: -- p_locator_id in number optional default = null
123: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
124: -- p_transaction_quantity in number required default = fnd_api.g_miss_num
125: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
126: -- return value out number
127: -- Version : not tracked

Line 124: -- p_transaction_quantity in number required default = fnd_api.g_miss_num

120: -- p_organization_id in number required default = fnd_api.g_miss_num
121: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
122: -- p_locator_id in number optional default = null
123: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
124: -- p_transaction_quantity in number required default = fnd_api.g_miss_num
125: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
126: -- return value out number
127: -- Version : not tracked
128: -- Notes : capacity must be returned as measured in txn UOM

Line 125: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char

121: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
122: -- p_locator_id in number optional default = null
123: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
124: -- p_transaction_quantity in number required default = fnd_api.g_miss_num
125: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
126: -- return value out number
127: -- Version : not tracked
128: -- Notes : capacity must be returned as measured in txn UOM
129: -- End of comments

Line 173: -- p_organization_id in number required default = fnd_api.g_miss_num

169: -- This function is made available to be used within put away
170: -- rule setup.
171: -- Pre-reqs : none
172: -- Parameters :
173: -- p_organization_id in number required default = fnd_api.g_miss_num
174: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
175: -- p_locator_id in number optional default = null
176: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
177: -- p_transaction_quantity in number required default = fnd_api.g_miss_num

Line 174: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char

170: -- rule setup.
171: -- Pre-reqs : none
172: -- Parameters :
173: -- p_organization_id in number required default = fnd_api.g_miss_num
174: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
175: -- p_locator_id in number optional default = null
176: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
177: -- p_transaction_quantity in number required default = fnd_api.g_miss_num
178: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char

Line 176: -- p_inventory_item_id in number required default = fnd_api.g_miss_num

172: -- Parameters :
173: -- p_organization_id in number required default = fnd_api.g_miss_num
174: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
175: -- p_locator_id in number optional default = null
176: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
177: -- p_transaction_quantity in number required default = fnd_api.g_miss_num
178: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
179: -- return value out number
180: -- Version : not tracked

Line 177: -- p_transaction_quantity in number required default = fnd_api.g_miss_num

173: -- p_organization_id in number required default = fnd_api.g_miss_num
174: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
175: -- p_locator_id in number optional default = null
176: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
177: -- p_transaction_quantity in number required default = fnd_api.g_miss_num
178: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
179: -- return value out number
180: -- Version : not tracked
181: -- Notes : capacity should be returned as measured in txn UOM

Line 178: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char

174: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
175: -- p_locator_id in number optional default = null
176: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
177: -- p_transaction_quantity in number required default = fnd_api.g_miss_num
178: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
179: -- return value out number
180: -- Version : not tracked
181: -- Notes : capacity should be returned as measured in txn UOM
182: -- End of comments

Line 231: -- p_init_msg_list in varchar2 optional default = fnd_api.g_false

227: -- identified by parameters p_transaction_temp_id and
228: -- p_type_code ( already validated by calling procedure )
229: -- set up strategy assignment in WMS_STRATEGY_ASSIGNMENTS
230: -- Parameters :
231: -- p_init_msg_list in varchar2 optional default = fnd_api.g_false
232: -- x_return_status out varchar2(1)
233: -- x_msg_count out number
234: -- x_msg_data out varchar2(2000)
235: -- p_transaction_temp_id in number required default = fnd_api.g_miss_num

Line 235: -- p_transaction_temp_id in number required default = fnd_api.g_miss_num

231: -- p_init_msg_list in varchar2 optional default = fnd_api.g_false
232: -- x_return_status out varchar2(1)
233: -- x_msg_count out number
234: -- x_msg_data out varchar2(2000)
235: -- p_transaction_temp_id in number required default = fnd_api.g_miss_num
236: -- p_type_code in number required default = fnd_api.g_miss_num
237: -- x_strategy_id out number
238: -- Version : not tracked
239: -- Notes : type code of returned strategy has to match type code

Line 236: -- p_type_code in number required default = fnd_api.g_miss_num

232: -- x_return_status out varchar2(1)
233: -- x_msg_count out number
234: -- x_msg_data out varchar2(2000)
235: -- p_transaction_temp_id in number required default = fnd_api.g_miss_num
236: -- p_type_code in number required default = fnd_api.g_miss_num
237: -- x_strategy_id out number
238: -- Version : not tracked
239: -- Notes : type code of returned strategy has to match type code
240: -- parameter

Line 244: p_init_msg_list in varchar2 := fnd_api.g_false

240: -- parameter
241: -- End of comments
242:
243: procedure SearchForStrategy (
244: p_init_msg_list in varchar2 := fnd_api.g_false
245: ,x_return_status out NOCOPY varchar2
246: ,x_msg_count out NOCOPY number
247: ,x_msg_data out NOCOPY varchar2
248: ,p_transaction_temp_id in number := fnd_api.g_miss_num

Line 248: ,p_transaction_temp_id in number := fnd_api.g_miss_num

244: p_init_msg_list in varchar2 := fnd_api.g_false
245: ,x_return_status out NOCOPY varchar2
246: ,x_msg_count out NOCOPY number
247: ,x_msg_data out NOCOPY varchar2
248: ,p_transaction_temp_id in number := fnd_api.g_miss_num
249: ,p_type_code in number := fnd_api.g_miss_num
250: ,x_strategy_id out NOCOPY number
251: ) is
252:

Line 249: ,p_type_code in number := fnd_api.g_miss_num

245: ,x_return_status out NOCOPY varchar2
246: ,x_msg_count out NOCOPY number
247: ,x_msg_data out NOCOPY varchar2
248: ,p_transaction_temp_id in number := fnd_api.g_miss_num
249: ,p_type_code in number := fnd_api.g_miss_num
250: ,x_strategy_id out NOCOPY number
251: ) is
252:
253: -- API standard variables

Line 259: if fnd_api.to_boolean( p_init_msg_list ) then

255:
256: begin
257:
258: -- Initialize message list if p_init_msg_list is set to TRUE
259: if fnd_api.to_boolean( p_init_msg_list ) then
260: fnd_msg_pub.initialize;
261: end if;
262:
263: -- Initialize API return status to success

Line 264: x_return_status := fnd_api.g_ret_sts_success;

260: fnd_msg_pub.initialize;
261: end if;
262:
263: -- Initialize API return status to success
264: x_return_status := fnd_api.g_ret_sts_success;
265:
266: -- Search for Strategy in a custom-specific manner, using
267: -- View WMS_STRATEGY_MAT_TXN_TMP_V ( Actual transaction values )
268: -- Table WMS_STRATEGY_ASSIGNMENTS ( Setup data )

Line 277: raise fnd_api.g_exc_error;

273: x_strategy_id := null;
274:
275: if x_strategy_id is null then
276: -- Message: No strategy found using custom-specific stub procedure
277: raise fnd_api.g_exc_error;
278: end if;
279:
280: -- Standard call to get message count and if count is 1, get message info
281: fnd_msg_pub.count_and_get( p_count => x_msg_count

Line 285: when fnd_api.g_exc_error then

281: fnd_msg_pub.count_and_get( p_count => x_msg_count
282: ,p_data => x_msg_data );
283:
284: exception
285: when fnd_api.g_exc_error then
286: x_return_status := fnd_api.g_ret_sts_error;
287: fnd_msg_pub.count_and_get( p_count => x_msg_count
288: ,p_data => x_msg_data );
289:

Line 286: x_return_status := fnd_api.g_ret_sts_error;

282: ,p_data => x_msg_data );
283:
284: exception
285: when fnd_api.g_exc_error then
286: x_return_status := fnd_api.g_ret_sts_error;
287: fnd_msg_pub.count_and_get( p_count => x_msg_count
288: ,p_data => x_msg_data );
289:
290: when fnd_api.g_exc_unexpected_error then

Line 290: when fnd_api.g_exc_unexpected_error then

286: x_return_status := fnd_api.g_ret_sts_error;
287: fnd_msg_pub.count_and_get( p_count => x_msg_count
288: ,p_data => x_msg_data );
289:
290: when fnd_api.g_exc_unexpected_error then
291: x_return_status := fnd_api.g_ret_sts_unexp_error;
292: fnd_msg_pub.count_and_get( p_count => x_msg_count
293: ,p_data => x_msg_data );
294:

Line 291: x_return_status := fnd_api.g_ret_sts_unexp_error;

287: fnd_msg_pub.count_and_get( p_count => x_msg_count
288: ,p_data => x_msg_data );
289:
290: when fnd_api.g_exc_unexpected_error then
291: x_return_status := fnd_api.g_ret_sts_unexp_error;
292: fnd_msg_pub.count_and_get( p_count => x_msg_count
293: ,p_data => x_msg_data );
294:
295: when others then

Line 296: x_return_status := fnd_api.g_ret_sts_unexp_error;

292: fnd_msg_pub.count_and_get( p_count => x_msg_count
293: ,p_data => x_msg_data );
294:
295: when others then
296: x_return_status := fnd_api.g_ret_sts_unexp_error;
297: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
298: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
299: end if;
300: fnd_msg_pub.count_and_get( p_count => x_msg_count

Line 320: p_init_msg_list in varchar2 optional default = fnd_api.g_false

316: identified by parameters p_transaction_temp_id and
317: p_type_code ( already validated by calling procedure )
318: set up strategy assignment in WMS_STRATEGY_ASSIGNMENTS
319: Parameters :
320: p_init_msg_list in varchar2 optional default = fnd_api.g_false
321: x_return_status out varchar2(1)
322: x_msg_count out number
323: x_msg_data out varchar2(2000)
324: p_transaction_temp_id in number required default = fnd_api.g_miss_num

Line 324: p_transaction_temp_id in number required default = fnd_api.g_miss_num

320: p_init_msg_list in varchar2 optional default = fnd_api.g_false
321: x_return_status out varchar2(1)
322: x_msg_count out number
323: x_msg_data out varchar2(2000)
324: p_transaction_temp_id in number required default = fnd_api.g_miss_num
325: p_type_code in number required default = fnd_api.g_miss_num
326: x_return_type out varchar2 'V' for Value , 'R' for Rule , 'S' for strategy
327: ,x_return_type_id out number
328: Notes : type code of returned strategy has to match type code

Line 325: p_type_code in number required default = fnd_api.g_miss_num

321: x_return_status out varchar2(1)
322: x_msg_count out number
323: x_msg_data out varchar2(2000)
324: p_transaction_temp_id in number required default = fnd_api.g_miss_num
325: p_type_code in number required default = fnd_api.g_miss_num
326: x_return_type out varchar2 'V' for Value , 'R' for Rule , 'S' for strategy
327: ,x_return_type_id out number
328: Notes : type code of returned strategy has to match type code
329: parameter

Line 332: p_init_msg_list in varchar2 := fnd_api.g_false

328: Notes : type code of returned strategy has to match type code
329: parameter
330: */
331: procedure SearchForStrategy (
332: p_init_msg_list in varchar2 := fnd_api.g_false
333: ,x_return_status out NOCOPY varchar2
334: ,x_msg_count out NOCOPY number
335: ,x_msg_data out NOCOPY varchar2
336: ,p_transaction_temp_id in number := fnd_api.g_miss_num

Line 336: ,p_transaction_temp_id in number := fnd_api.g_miss_num

332: p_init_msg_list in varchar2 := fnd_api.g_false
333: ,x_return_status out NOCOPY varchar2
334: ,x_msg_count out NOCOPY number
335: ,x_msg_data out NOCOPY varchar2
336: ,p_transaction_temp_id in number := fnd_api.g_miss_num
337: ,p_type_code in number := fnd_api.g_miss_num
338: ,x_return_type out NOCOPY varchar2 -- 'V' for Value , 'R' for Rule , 'S' for strategy
339: ,x_return_type_id out NOCOPY number
340: ) is

Line 337: ,p_type_code in number := fnd_api.g_miss_num

333: ,x_return_status out NOCOPY varchar2
334: ,x_msg_count out NOCOPY number
335: ,x_msg_data out NOCOPY varchar2
336: ,p_transaction_temp_id in number := fnd_api.g_miss_num
337: ,p_type_code in number := fnd_api.g_miss_num
338: ,x_return_type out NOCOPY varchar2 -- 'V' for Value , 'R' for Rule , 'S' for strategy
339: ,x_return_type_id out NOCOPY number
340: ) is
341:

Line 348: if fnd_api.to_boolean( p_init_msg_list ) then

344:
345: begin
346:
347: -- Initialize message list if p_init_msg_list is set to TRUE
348: if fnd_api.to_boolean( p_init_msg_list ) then
349: fnd_msg_pub.initialize;
350: end if;
351:
352: -- Initialize API return status to success

Line 353: x_return_status := fnd_api.g_ret_sts_success;

349: fnd_msg_pub.initialize;
350: end if;
351:
352: -- Initialize API return status to success
353: x_return_status := fnd_api.g_ret_sts_success;
354:
355: -- Search for Strategy in a custom-specific manner, using
356: -- View WMS_STRATEGY_MAT_TXN_TMP_V ( Actual transaction values )
357: -- Table WMS_STRATEGY_ASSIGNMENTS ( Setup data )

Line 367: raise fnd_api.g_exc_error;

363: x_return_type_id := null;
364:
365: if x_return_type_id is null then
366: -- Message: No strategy/Rule/Value found using custom-specific stub procedure
367: raise fnd_api.g_exc_error;
368: end if;
369:
370: -- Standard call to get message count and if count is 1, get message info
371: fnd_msg_pub.count_and_get( p_count => x_msg_count

Line 375: when fnd_api.g_exc_error then

371: fnd_msg_pub.count_and_get( p_count => x_msg_count
372: ,p_data => x_msg_data );
373:
374: exception
375: when fnd_api.g_exc_error then
376: x_return_status := fnd_api.g_ret_sts_error;
377: fnd_msg_pub.count_and_get( p_count => x_msg_count
378: ,p_data => x_msg_data );
379:

Line 376: x_return_status := fnd_api.g_ret_sts_error;

372: ,p_data => x_msg_data );
373:
374: exception
375: when fnd_api.g_exc_error then
376: x_return_status := fnd_api.g_ret_sts_error;
377: fnd_msg_pub.count_and_get( p_count => x_msg_count
378: ,p_data => x_msg_data );
379:
380: when fnd_api.g_exc_unexpected_error then

Line 380: when fnd_api.g_exc_unexpected_error then

376: x_return_status := fnd_api.g_ret_sts_error;
377: fnd_msg_pub.count_and_get( p_count => x_msg_count
378: ,p_data => x_msg_data );
379:
380: when fnd_api.g_exc_unexpected_error then
381: x_return_status := fnd_api.g_ret_sts_unexp_error;
382: fnd_msg_pub.count_and_get( p_count => x_msg_count
383: ,p_data => x_msg_data );
384:

Line 381: x_return_status := fnd_api.g_ret_sts_unexp_error;

377: fnd_msg_pub.count_and_get( p_count => x_msg_count
378: ,p_data => x_msg_data );
379:
380: when fnd_api.g_exc_unexpected_error then
381: x_return_status := fnd_api.g_ret_sts_unexp_error;
382: fnd_msg_pub.count_and_get( p_count => x_msg_count
383: ,p_data => x_msg_data );
384:
385: when others then

Line 386: x_return_status := fnd_api.g_ret_sts_unexp_error;

382: fnd_msg_pub.count_and_get( p_count => x_msg_count
383: ,p_data => x_msg_data );
384:
385: when others then
386: x_return_status := fnd_api.g_ret_sts_unexp_error;
387: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
388: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
389: end if;
390: fnd_msg_pub.count_and_get( p_count => x_msg_count

Line 485: x_return_status := fnd_api.g_ret_sts_success;

481: , x_sec_qty_round_mode OUT NOCOPY VARCHAR2
482: , x_target_uom OUT NOCOPY VARCHAR2
483: ) IS
484: BEGIN
485: x_return_status := fnd_api.g_ret_sts_success;
486:
487: x_sec_qty_round_mode := NULL;
488: x_target_uom := 'P';
489:

Line 492: x_return_status := fnd_api.g_ret_sts_unexp_error;

488: x_target_uom := 'P';
489:
490: EXCEPTION
491: WHEN OTHERS THEN
492: x_return_status := fnd_api.g_ret_sts_unexp_error;
493: x_msg_data := SQLERRM;
494: END set_dualuom_alloc_prefs;
495:
496: