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

Line 69: x_return_status := fnd_api.g_ret_sts_success ;

65: --
66: l_rule_id NUMBER;
67: BEGIN
68:
69: x_return_status := fnd_api.g_ret_sts_success ;
70: -- find rule from mtl_system_items
71: IF ((nvl(g_inventory_item_id,-9999) <> p_inventory_item_id) OR
72: (nvl(g_organization_id,-9999) <> p_organization_id)) THEN
73: IF inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) THEN

Line 92: WHEN fnd_api.g_exc_error THEN

88: END IF;
89: x_rule_id := g_rule_id;
90:
91: EXCEPTION
92: WHEN fnd_api.g_exc_error THEN
93: x_return_status := fnd_api.g_ret_sts_error ;
94: --
95: WHEN fnd_api.g_exc_unexpected_error THEN
96: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 93: x_return_status := fnd_api.g_ret_sts_error ;

89: x_rule_id := g_rule_id;
90:
91: EXCEPTION
92: WHEN fnd_api.g_exc_error THEN
93: x_return_status := fnd_api.g_ret_sts_error ;
94: --
95: WHEN fnd_api.g_exc_unexpected_error THEN
96: x_return_status := fnd_api.g_ret_sts_unexp_error ;
97: --

Line 95: WHEN fnd_api.g_exc_unexpected_error THEN

91: EXCEPTION
92: WHEN fnd_api.g_exc_error THEN
93: x_return_status := fnd_api.g_ret_sts_error ;
94: --
95: WHEN fnd_api.g_exc_unexpected_error THEN
96: x_return_status := fnd_api.g_ret_sts_unexp_error ;
97: --
98: WHEN OTHERS THEN
99: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 96: x_return_status := fnd_api.g_ret_sts_unexp_error ;

92: WHEN fnd_api.g_exc_error THEN
93: x_return_status := fnd_api.g_ret_sts_error ;
94: --
95: WHEN fnd_api.g_exc_unexpected_error THEN
96: x_return_status := fnd_api.g_ret_sts_unexp_error ;
97: --
98: WHEN OTHERS THEN
99: x_return_status := fnd_api.g_ret_sts_unexp_error ;
100: --

Line 99: x_return_status := fnd_api.g_ret_sts_unexp_error ;

95: WHEN fnd_api.g_exc_unexpected_error THEN
96: x_return_status := fnd_api.g_ret_sts_unexp_error ;
97: --
98: WHEN OTHERS THEN
99: x_return_status := fnd_api.g_ret_sts_unexp_error ;
100: --
101: IF (fnd_msg_pub.check_msg_level
102: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
103: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 167: x_return_status := fnd_api.g_ret_sts_success;

163: ELSE
164: RAISE invalid_loc_control_exception;
165: END IF;
166: --
167: x_return_status := fnd_api.g_ret_sts_success;
168: RETURN l_locator_control;
169: EXCEPTION
170: WHEN invalid_loc_control_exception THEN
171: fnd_message.set_name('INV','INV_INVALID_LOC_CONTROL');

Line 174: x_return_status := fnd_api.g_ret_sts_error ;

170: WHEN invalid_loc_control_exception THEN
171: fnd_message.set_name('INV','INV_INVALID_LOC_CONTROL');
172: fnd_msg_pub.ADD;
173: --
174: x_return_status := fnd_api.g_ret_sts_error ;
175: l_locator_control := -1 ;
176: RETURN l_locator_control ;
177: --
178: WHEN fnd_api.g_exc_error THEN

Line 178: WHEN fnd_api.g_exc_error THEN

174: x_return_status := fnd_api.g_ret_sts_error ;
175: l_locator_control := -1 ;
176: RETURN l_locator_control ;
177: --
178: WHEN fnd_api.g_exc_error THEN
179: x_return_status := fnd_api.g_ret_sts_error ;
180: l_locator_control := -1 ;
181: RETURN l_locator_control ;
182: --

Line 179: x_return_status := fnd_api.g_ret_sts_error ;

175: l_locator_control := -1 ;
176: RETURN l_locator_control ;
177: --
178: WHEN fnd_api.g_exc_error THEN
179: x_return_status := fnd_api.g_ret_sts_error ;
180: l_locator_control := -1 ;
181: RETURN l_locator_control ;
182: --
183: WHEN fnd_api.g_exc_unexpected_error THEN

Line 183: WHEN fnd_api.g_exc_unexpected_error THEN

179: x_return_status := fnd_api.g_ret_sts_error ;
180: l_locator_control := -1 ;
181: RETURN l_locator_control ;
182: --
183: WHEN fnd_api.g_exc_unexpected_error THEN
184: x_return_status := fnd_api.g_ret_sts_unexp_error ;
185: l_locator_control := -1 ;
186: RETURN l_locator_control ;
187: --

Line 184: x_return_status := fnd_api.g_ret_sts_unexp_error ;

180: l_locator_control := -1 ;
181: RETURN l_locator_control ;
182: --
183: WHEN fnd_api.g_exc_unexpected_error THEN
184: x_return_status := fnd_api.g_ret_sts_unexp_error ;
185: l_locator_control := -1 ;
186: RETURN l_locator_control ;
187: --
188: WHEN OTHERS THEN

Line 189: x_return_status := fnd_api.g_ret_sts_unexp_error ;

185: l_locator_control := -1 ;
186: RETURN l_locator_control ;
187: --
188: WHEN OTHERS THEN
189: x_return_status := fnd_api.g_ret_sts_unexp_error ;
190: --
191: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
192: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
193: END IF;

Line 226: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

222: )
223: IS
224: -- constants
225: l_api_name CONSTANT VARCHAR(30) := 'get_putaway_defaults';
226: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
227: --
228: -- variable
229: l_sub_loc_control NUMBER;
230: l_loc_control NUMBER;

Line 305: RAISE fnd_api.g_exc_error;

301: l_putaway_sub IS NULL THEN
302: CLOSE l_subinventory_code_csr;
303: fnd_message.set_name('INV','INV_NO_DEFAULT_SUB');
304: fnd_msg_pub.ADD;
305: RAISE fnd_api.g_exc_error;
306: END IF;
307: CLOSE l_subinventory_code_csr;
308:
309: ELSE

Line 331: IF l_return_status = fnd_api.g_ret_sts_error THEN

327: ,p_transaction_type_id => p_transaction_type_id
328: ,x_return_status => l_return_status
329: ,x_msg_count => x_msg_count
330: ,x_msg_data => x_msg_data);
331: IF l_return_status = fnd_api.g_ret_sts_error THEN
332: RAISE fnd_api.g_exc_error ;
333: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
334: RAISE fnd_api.g_exc_unexpected_error;
335: END IF;

Line 332: RAISE fnd_api.g_exc_error ;

328: ,x_return_status => l_return_status
329: ,x_msg_count => x_msg_count
330: ,x_msg_data => x_msg_data);
331: IF l_return_status = fnd_api.g_ret_sts_error THEN
332: RAISE fnd_api.g_exc_error ;
333: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
334: RAISE fnd_api.g_exc_unexpected_error;
335: END IF;
336:

Line 333: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

329: ,x_msg_count => x_msg_count
330: ,x_msg_data => x_msg_data);
331: IF l_return_status = fnd_api.g_ret_sts_error THEN
332: RAISE fnd_api.g_exc_error ;
333: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
334: RAISE fnd_api.g_exc_unexpected_error;
335: END IF;
336:
337: IF l_allowed <> 'Y' THEN

Line 334: RAISE fnd_api.g_exc_unexpected_error;

330: ,x_msg_data => x_msg_data);
331: IF l_return_status = fnd_api.g_ret_sts_error THEN
332: RAISE fnd_api.g_exc_error ;
333: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
334: RAISE fnd_api.g_exc_unexpected_error;
335: END IF;
336:
337: IF l_allowed <> 'Y' THEN
338: fnd_message.set_name('INV', 'INV_DETAIL_SUB_STATUS');

Line 340: raise fnd_api.g_exc_error;

336:
337: IF l_allowed <> 'Y' THEN
338: fnd_message.set_name('INV', 'INV_DETAIL_SUB_STATUS');
339: fnd_msg_pub.add;
340: raise fnd_api.g_exc_error;
341: END IF;
342: END IF;
343: END IF;
344: --

Line 351: RAISE fnd_api.g_exc_error;

347: --
348: IF NOT l_sub_found THEN
349: fnd_message.set_name('INV','INV_NO_SUB_LOC_CONTROL');
350: fnd_msg_pub.ADD;
351: RAISE fnd_api.g_exc_error;
352: END if;
353:
354: l_sub_loc_control := INV_CACHE.tosub_rec.locator_type;
355:

Line 364: IF l_return_status = fnd_api.g_ret_sts_error THEN

360: ,p_item_locator_control_code
361: ,l_return_status
362: ,x_msg_count
363: ,x_msg_data);
364: IF l_return_status = fnd_api.g_ret_sts_error THEN
365: RAISE fnd_api.g_exc_error ;
366: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
367: RAISE fnd_api.g_exc_unexpected_error;
368: END IF;

Line 365: RAISE fnd_api.g_exc_error ;

361: ,l_return_status
362: ,x_msg_count
363: ,x_msg_data);
364: IF l_return_status = fnd_api.g_ret_sts_error THEN
365: RAISE fnd_api.g_exc_error ;
366: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
367: RAISE fnd_api.g_exc_unexpected_error;
368: END IF;
369: --

Line 366: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

362: ,x_msg_count
363: ,x_msg_data);
364: IF l_return_status = fnd_api.g_ret_sts_error THEN
365: RAISE fnd_api.g_exc_error ;
366: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
367: RAISE fnd_api.g_exc_unexpected_error;
368: END IF;
369: --
370: IF l_loc_control = 2 THEN -- has locator control

Line 367: RAISE fnd_api.g_exc_unexpected_error;

363: ,x_msg_data);
364: IF l_return_status = fnd_api.g_ret_sts_error THEN
365: RAISE fnd_api.g_exc_error ;
366: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
367: RAISE fnd_api.g_exc_unexpected_error;
368: END IF;
369: --
370: IF l_loc_control = 2 THEN -- has locator control
371: -- if no to_loc was supplied then get from defaults

Line 379: RAISE fnd_api.g_exc_error;

375: IF l_locator_csr%notfound OR l_putaway_loc IS NULL THEN
376: CLOSE l_locator_csr;
377: fnd_message.set_name('INV','INV_NO_DEFAULT_LOC');
378: fnd_msg_pub.ADD;
379: RAISE fnd_api.g_exc_error;
380: END IF;
381: ELSE
382: l_putaway_loc := p_to_locator_id ;
383: END IF;

Line 404: IF l_return_status = fnd_api.g_ret_sts_error THEN

400: ,x_return_status => l_return_status
401: ,x_msg_count => x_msg_count
402: ,x_msg_data => x_msg_data);
403:
404: IF l_return_status = fnd_api.g_ret_sts_error THEN
405: RAISE fnd_api.g_exc_error ;
406: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
407: RAISE fnd_api.g_exc_unexpected_error;
408: END IF;

Line 405: RAISE fnd_api.g_exc_error ;

401: ,x_msg_count => x_msg_count
402: ,x_msg_data => x_msg_data);
403:
404: IF l_return_status = fnd_api.g_ret_sts_error THEN
405: RAISE fnd_api.g_exc_error ;
406: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
407: RAISE fnd_api.g_exc_unexpected_error;
408: END IF;
409:

Line 406: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

402: ,x_msg_data => x_msg_data);
403:
404: IF l_return_status = fnd_api.g_ret_sts_error THEN
405: RAISE fnd_api.g_exc_error ;
406: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
407: RAISE fnd_api.g_exc_unexpected_error;
408: END IF;
409:
410: IF l_allowed <> 'Y' THEN

Line 407: RAISE fnd_api.g_exc_unexpected_error;

403:
404: IF l_return_status = fnd_api.g_ret_sts_error THEN
405: RAISE fnd_api.g_exc_error ;
406: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
407: RAISE fnd_api.g_exc_unexpected_error;
408: END IF;
409:
410: IF l_allowed <> 'Y' THEN
411: fnd_message.set_name('INV', 'INV_DETAIL_LOC_STATUS');

Line 413: raise fnd_api.g_exc_error;

409:
410: IF l_allowed <> 'Y' THEN
411: fnd_message.set_name('INV', 'INV_DETAIL_LOC_STATUS');
412: fnd_msg_pub.add;
413: raise fnd_api.g_exc_error;
414: END IF;
415: END IF;
416:
417: END IF;

Line 447: RAISE fnd_api.g_exc_error;

443: l_putaway_cg := l_putaway_cg_org;
444: if l_putaway_cg IS NULL then
445: fnd_message.set_name('INV','INV_NO_DEFAULT_COST_GROUP');
446: fnd_msg_pub.ADD;
447: RAISE fnd_api.g_exc_error;
448: end if;
449: End If;
450: ELSE
451: l_putaway_cg := p_to_cost_group_id;

Line 462: WHEN fnd_api.g_exc_error THEN

458: x_putaway_cost_group_id := l_putaway_cg;
459: x_return_status := l_return_status;
460: --
461: EXCEPTION
462: WHEN fnd_api.g_exc_error THEN
463: x_return_status := fnd_api.g_ret_sts_error ;
464: x_putaway_loc := NULL;
465: x_putaway_sub := NULL;
466: x_putaway_cost_group_id := NULL;

Line 463: x_return_status := fnd_api.g_ret_sts_error ;

459: x_return_status := l_return_status;
460: --
461: EXCEPTION
462: WHEN fnd_api.g_exc_error THEN
463: x_return_status := fnd_api.g_ret_sts_error ;
464: x_putaway_loc := NULL;
465: x_putaway_sub := NULL;
466: x_putaway_cost_group_id := NULL;
467: --

Line 468: WHEN fnd_api.g_exc_unexpected_error THEN

464: x_putaway_loc := NULL;
465: x_putaway_sub := NULL;
466: x_putaway_cost_group_id := NULL;
467: --
468: WHEN fnd_api.g_exc_unexpected_error THEN
469: x_return_status := fnd_api.g_ret_sts_unexp_error ;
470: x_putaway_loc := NULL;
471: x_putaway_sub := NULL;
472: x_putaway_cost_group_id := NULL;

Line 469: x_return_status := fnd_api.g_ret_sts_unexp_error ;

465: x_putaway_sub := NULL;
466: x_putaway_cost_group_id := NULL;
467: --
468: WHEN fnd_api.g_exc_unexpected_error THEN
469: x_return_status := fnd_api.g_ret_sts_unexp_error ;
470: x_putaway_loc := NULL;
471: x_putaway_sub := NULL;
472: x_putaway_cost_group_id := NULL;
473: --

Line 475: x_return_status := fnd_api.g_ret_sts_unexp_error ;

471: x_putaway_sub := NULL;
472: x_putaway_cost_group_id := NULL;
473: --
474: WHEN OTHERS THEN
475: x_return_status := fnd_api.g_ret_sts_unexp_error ;
476: x_putaway_loc := NULL;
477: x_putaway_sub := NULL;
478: x_putaway_cost_group_id := NULL;
479: --

Line 508: x_return_status := fnd_api.g_ret_sts_success ;

504: --
505: l_identifier VARCHAR2(80);
506: l_id2 VARCHAR2(80);
507: BEGIN
508: x_return_status := fnd_api.g_ret_sts_success ;
509: --
510: --soft pegged always allocates common; hard pegged items allocate
511: -- project/task
512: IF p_project_id IS NULL AND p_task_id IS NULL

Line 598: WHEN fnd_api.g_exc_error THEN

594:
595: END IF;
596: --
597: EXCEPTION
598: WHEN fnd_api.g_exc_error THEN
599: x_return_status := fnd_api.g_ret_sts_error ;
600: x_where_clause := NULL;
601: --
602: WHEN fnd_api.g_exc_unexpected_error THEN

Line 599: x_return_status := fnd_api.g_ret_sts_error ;

595: END IF;
596: --
597: EXCEPTION
598: WHEN fnd_api.g_exc_error THEN
599: x_return_status := fnd_api.g_ret_sts_error ;
600: x_where_clause := NULL;
601: --
602: WHEN fnd_api.g_exc_unexpected_error THEN
603: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 602: WHEN fnd_api.g_exc_unexpected_error THEN

598: WHEN fnd_api.g_exc_error THEN
599: x_return_status := fnd_api.g_ret_sts_error ;
600: x_where_clause := NULL;
601: --
602: WHEN fnd_api.g_exc_unexpected_error THEN
603: x_return_status := fnd_api.g_ret_sts_unexp_error ;
604: x_where_clause := NULL;
605: --
606: WHEN OTHERS THEN

Line 603: x_return_status := fnd_api.g_ret_sts_unexp_error ;

599: x_return_status := fnd_api.g_ret_sts_error ;
600: x_where_clause := NULL;
601: --
602: WHEN fnd_api.g_exc_unexpected_error THEN
603: x_return_status := fnd_api.g_ret_sts_unexp_error ;
604: x_where_clause := NULL;
605: --
606: WHEN OTHERS THEN
607: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 607: x_return_status := fnd_api.g_ret_sts_unexp_error ;

603: x_return_status := fnd_api.g_ret_sts_unexp_error ;
604: x_where_clause := NULL;
605: --
606: WHEN OTHERS THEN
607: x_return_status := fnd_api.g_ret_sts_unexp_error ;
608: x_where_clause := NULL;
609: --
610: IF (fnd_msg_pub.check_msg_level
611: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN

Line 645: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

641: l_sub_rule NUMBER ;
642: l_loc_rule NUMBER ;
643: l_is_lot_control BOOLEAN;
644: --
645: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
646: --
647: l_sub_select VARCHAR2(3000);
648: l_loc_select VARCHAR2(3000);
649: l_rev_where VARCHAR2(3000);

Line 684: x_return_status := fnd_api.g_ret_sts_success ;

680: --
681: l_temp1 long;
682: l_temp2 long;
683: BEGIN
684: x_return_status := fnd_api.g_ret_sts_success ;
685: l_rev_where := ' ';
686: l_lot_where := ' ';
687: l_sub_where := ' ';
688: l_loc_where := ' ';

Line 701: RAISE fnd_api.g_exc_error;

697: IF l_rule_csr%notfound THEN
698: CLOSE l_rule_csr;
699: fnd_message.set_name('INV','INV_INVALID_PICKING_RULE');
700: fnd_msg_pub.ADD;
701: RAISE fnd_api.g_exc_error;
702: END IF;
703: CLOSE l_rule_csr;
704: --
705: IF l_rev_rule IS NULL OR l_lot_rule IS NULL OR

Line 709: RAISE fnd_api.g_exc_error;

705: IF l_rev_rule IS NULL OR l_lot_rule IS NULL OR
706: l_sub_rule IS NULL OR l_loc_rule IS NULL THEN
707: fnd_message.set_name('INV','INV_RULE_DEFINITION_ERROR');
708: fnd_msg_pub.ADD;
709: RAISE fnd_api.g_exc_error;
710: END IF;
711: ELSE
712: l_rev_rule := 0;
713: l_lot_rule := 0;

Line 740: IF l_return_status = fnd_api.g_ret_sts_error THEN

736: (
737: x_return_status => l_return_status
738: ,x_sql_statement => g_stmt);
739: --
740: IF l_return_status = fnd_api.g_ret_sts_error THEN
741: RAISE fnd_api.g_exc_error ;
742: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
743: RAISE fnd_api.g_exc_unexpected_error;
744: END IF;

Line 741: RAISE fnd_api.g_exc_error ;

737: x_return_status => l_return_status
738: ,x_sql_statement => g_stmt);
739: --
740: IF l_return_status = fnd_api.g_ret_sts_error THEN
741: RAISE fnd_api.g_exc_error ;
742: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
743: RAISE fnd_api.g_exc_unexpected_error;
744: END IF;
745: --

Line 742: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

738: ,x_sql_statement => g_stmt);
739: --
740: IF l_return_status = fnd_api.g_ret_sts_error THEN
741: RAISE fnd_api.g_exc_error ;
742: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
743: RAISE fnd_api.g_exc_unexpected_error;
744: END IF;
745: --
746: -- replace some hardcoded bind variables

Line 743: RAISE fnd_api.g_exc_unexpected_error;

739: --
740: IF l_return_status = fnd_api.g_ret_sts_error THEN
741: RAISE fnd_api.g_exc_error ;
742: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
743: RAISE fnd_api.g_exc_unexpected_error;
744: END IF;
745: --
746: -- replace some hardcoded bind variables
747: -- Bug 1384720 - performance improvements

Line 874: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

870: ,p_request_context.end_assembly_pegging_code
871: );
872: end if;
873: --
874: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
875: RAISE fnd_api.g_exc_unexpected_error ;
876: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
877: RAISE fnd_api.g_exc_error ;
878: END IF;

Line 875: RAISE fnd_api.g_exc_unexpected_error ;

871: );
872: end if;
873: --
874: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
875: RAISE fnd_api.g_exc_unexpected_error ;
876: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
877: RAISE fnd_api.g_exc_error ;
878: END IF;
879: --

Line 876: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

872: end if;
873: --
874: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
875: RAISE fnd_api.g_exc_unexpected_error ;
876: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
877: RAISE fnd_api.g_exc_error ;
878: END IF;
879: --
880:

Line 877: RAISE fnd_api.g_exc_error ;

873: --
874: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
875: RAISE fnd_api.g_exc_unexpected_error ;
876: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
877: RAISE fnd_api.g_exc_error ;
878: END IF;
879: --
880:
881: --check status of lot, locator, subinventory if Advanced Inventory

Line 1037: WHEN fnd_api.g_exc_error THEN

1033: --inv_pp_debug.send_long_to_pipe(g_stmt);
1034: --
1035: x_return_status := l_return_status;
1036: EXCEPTION
1037: WHEN fnd_api.g_exc_error THEN
1038: x_return_status := fnd_api.g_ret_sts_error ;
1039: --
1040: WHEN fnd_api.g_exc_unexpected_error THEN
1041: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1038: x_return_status := fnd_api.g_ret_sts_error ;

1034: --
1035: x_return_status := l_return_status;
1036: EXCEPTION
1037: WHEN fnd_api.g_exc_error THEN
1038: x_return_status := fnd_api.g_ret_sts_error ;
1039: --
1040: WHEN fnd_api.g_exc_unexpected_error THEN
1041: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1042: --

Line 1040: WHEN fnd_api.g_exc_unexpected_error THEN

1036: EXCEPTION
1037: WHEN fnd_api.g_exc_error THEN
1038: x_return_status := fnd_api.g_ret_sts_error ;
1039: --
1040: WHEN fnd_api.g_exc_unexpected_error THEN
1041: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1042: --
1043: WHEN OTHERS THEN
1044: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1041: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1037: WHEN fnd_api.g_exc_error THEN
1038: x_return_status := fnd_api.g_ret_sts_error ;
1039: --
1040: WHEN fnd_api.g_exc_unexpected_error THEN
1041: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1042: --
1043: WHEN OTHERS THEN
1044: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1045: --

Line 1044: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1040: WHEN fnd_api.g_exc_unexpected_error THEN
1041: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1042: --
1043: WHEN OTHERS THEN
1044: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1045: --
1046: IF (fnd_msg_pub.check_msg_level
1047: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1048: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 1063: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

1059: x_msg_count OUT NOCOPY NUMBER,
1060: x_msg_data OUT NOCOPY VARCHAR2
1061: )
1062: IS
1063: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1064: l_api_name VARCHAR2(30) := 'init_qty_tree';
1065: l_rev_flag BOOLEAN;
1066: l_lot_flag BOOLEAN;
1067: l_tree_id NUMBER;

Line 1089: ,p_init_msg_lst => fnd_api.g_false

1085:
1086: inv_quantity_tree_pvt.create_tree
1087: (
1088: p_api_version_number => 1.0
1089: ,p_init_msg_lst => fnd_api.g_false
1090: ,x_return_status => l_return_status
1091: ,x_msg_count => x_msg_count
1092: ,x_msg_data => x_msg_data
1093: ,p_organization_id => p_request_line_rec.organization_id

Line 1112: IF l_return_status = fnd_api.g_ret_sts_error THEN

1108: ,p_exclusive => inv_quantity_tree_pvt.g_exclusive
1109: ,p_pick_release => inv_quantity_tree_pvt.g_pick_release_yes
1110: );
1111: --
1112: IF l_return_status = fnd_api.g_ret_sts_error THEN
1113: RAISE fnd_api.g_exc_error ;
1114: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1115: RAISE fnd_api.g_exc_unexpected_error;
1116: END IF;

Line 1113: RAISE fnd_api.g_exc_error ;

1109: ,p_pick_release => inv_quantity_tree_pvt.g_pick_release_yes
1110: );
1111: --
1112: IF l_return_status = fnd_api.g_ret_sts_error THEN
1113: RAISE fnd_api.g_exc_error ;
1114: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1115: RAISE fnd_api.g_exc_unexpected_error;
1116: END IF;
1117: --

Line 1114: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1110: );
1111: --
1112: IF l_return_status = fnd_api.g_ret_sts_error THEN
1113: RAISE fnd_api.g_exc_error ;
1114: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1115: RAISE fnd_api.g_exc_unexpected_error;
1116: END IF;
1117: --
1118: x_tree_id := l_tree_id;

Line 1115: RAISE fnd_api.g_exc_unexpected_error;

1111: --
1112: IF l_return_status = fnd_api.g_ret_sts_error THEN
1113: RAISE fnd_api.g_exc_error ;
1114: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1115: RAISE fnd_api.g_exc_unexpected_error;
1116: END IF;
1117: --
1118: x_tree_id := l_tree_id;
1119: x_return_status := l_return_status;

Line 1124: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

1120: END init_qty_tree;
1121: --
1122: PROCEDURE free_qty_tree (p_tree_id IN NUMBER,x_return_status OUT NOCOPY VARCHAR2)
1123: IS
1124: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1125: l_msg_count NUMBER;
1126: l_msg_data VARCHAR2(240);
1127: BEGIN
1128: -- If tree already exists, free it. This may occur if procedure is

Line 1134: ,p_init_msg_lst => fnd_api.g_false

1130: IF 0 > 0 THEN
1131: inv_quantity_tree_pvt.free_tree
1132: (
1133: p_api_version_number => 1.0
1134: ,p_init_msg_lst => fnd_api.g_false
1135: ,x_return_status => l_return_status
1136: ,x_msg_count => l_msg_count
1137: ,x_msg_data => l_msg_data
1138: ,p_tree_id => 0

Line 1140: IF l_return_status = fnd_api.g_ret_sts_error THEN

1136: ,x_msg_count => l_msg_count
1137: ,x_msg_data => l_msg_data
1138: ,p_tree_id => 0
1139: );
1140: IF l_return_status = fnd_api.g_ret_sts_error THEN
1141: RAISE fnd_api.g_exc_error ;
1142: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1143: RAISE fnd_api.g_exc_unexpected_error;
1144: END IF;

Line 1141: RAISE fnd_api.g_exc_error ;

1137: ,x_msg_data => l_msg_data
1138: ,p_tree_id => 0
1139: );
1140: IF l_return_status = fnd_api.g_ret_sts_error THEN
1141: RAISE fnd_api.g_exc_error ;
1142: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1143: RAISE fnd_api.g_exc_unexpected_error;
1144: END IF;
1145: END IF;

Line 1142: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1138: ,p_tree_id => 0
1139: );
1140: IF l_return_status = fnd_api.g_ret_sts_error THEN
1141: RAISE fnd_api.g_exc_error ;
1142: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1143: RAISE fnd_api.g_exc_unexpected_error;
1144: END IF;
1145: END IF;
1146: --

Line 1143: RAISE fnd_api.g_exc_unexpected_error;

1139: );
1140: IF l_return_status = fnd_api.g_ret_sts_error THEN
1141: RAISE fnd_api.g_exc_error ;
1142: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1143: RAISE fnd_api.g_exc_unexpected_error;
1144: END IF;
1145: END IF;
1146: --
1147: x_return_status := l_return_status;

Line 1255: x_return_status := fnd_api.g_ret_sts_success ;

1251: WHERE header_id = p_request_line_rec.header_id;
1252: */
1253:
1254: BEGIN
1255: x_return_status := fnd_api.g_ret_sts_success ;
1256: --
1257: --inv_sql_binding_pvt.showsql(g_stmt);
1258: l_cursor := dbms_sql.open_cursor ;
1259: dbms_sql.parse(l_cursor, g_stmt, dbms_sql.v7);

Line 1292: IF x_return_status = fnd_api.g_ret_sts_error THEN

1288: x_msg_count,
1289: x_msg_data
1290: );
1291: --
1292: IF x_return_status = fnd_api.g_ret_sts_error THEN
1293: RAISE fnd_api.g_exc_error ;
1294: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1295: RAISE fnd_api.g_exc_unexpected_error;
1296: END IF;

Line 1293: RAISE fnd_api.g_exc_error ;

1289: x_msg_data
1290: );
1291: --
1292: IF x_return_status = fnd_api.g_ret_sts_error THEN
1293: RAISE fnd_api.g_exc_error ;
1294: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1295: RAISE fnd_api.g_exc_unexpected_error;
1296: END IF;
1297: END IF;

Line 1294: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1290: );
1291: --
1292: IF x_return_status = fnd_api.g_ret_sts_error THEN
1293: RAISE fnd_api.g_exc_error ;
1294: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1295: RAISE fnd_api.g_exc_unexpected_error;
1296: END IF;
1297: END IF;
1298: --

Line 1295: RAISE fnd_api.g_exc_unexpected_error;

1291: --
1292: IF x_return_status = fnd_api.g_ret_sts_error THEN
1293: RAISE fnd_api.g_exc_error ;
1294: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1295: RAISE fnd_api.g_exc_unexpected_error;
1296: END IF;
1297: END IF;
1298: --
1299: l_to_subinventory := l_putaway_sub;

Line 1370: RAISE fnd_api.g_exc_unexpected_error;

1366: -- First, get the line for from sub and to sub
1367: IF NOT (inv_cache.set_fromsub_rec(p_request_line_rec.organization_id, l_from_subinventory)) THEN
1368: fnd_message.set_name('INV', 'INV_VALIDATE_SUB_FAILED');
1369: fnd_msg_pub.add;
1370: RAISE fnd_api.g_exc_unexpected_error;
1371: END IF;
1372:
1373: IF NOT (inv_cache.set_tosub_rec(p_request_line_rec.organization_id, l_to_subinventory)) THEN
1374: fnd_message.set_name('INV', 'INV_VALIDATE_SUB_FAILED');

Line 1376: RAISE fnd_api.g_exc_unexpected_error;

1372:
1373: IF NOT (inv_cache.set_tosub_rec(p_request_line_rec.organization_id, l_to_subinventory)) THEN
1374: fnd_message.set_name('INV', 'INV_VALIDATE_SUB_FAILED');
1375: fnd_msg_pub.add;
1376: RAISE fnd_api.g_exc_unexpected_error;
1377: END IF;
1378:
1379: IF NOT (inv_cache.set_org_rec(p_request_line_rec.organization_id)) THEN
1380: fnd_message.set_name('INV', 'INV_VALIDATE_SUB_FAILED');

Line 1382: RAISE fnd_api.g_exc_unexpected_error;

1378:
1379: IF NOT (inv_cache.set_org_rec(p_request_line_rec.organization_id)) THEN
1380: fnd_message.set_name('INV', 'INV_VALIDATE_SUB_FAILED');
1381: fnd_msg_pub.add;
1382: RAISE fnd_api.g_exc_unexpected_error;
1383: END IF;
1384: IF NOT (inv_cache.set_item_rec(p_request_line_rec.organization_id, p_request_line_rec.inventory_item_id)) THEN
1385: fnd_message.set_name('INV', 'INV_VALIDATE_SUB_FAILED');
1386: fnd_msg_pub.add;

Line 1387: RAISE fnd_api.g_exc_unexpected_error;

1383: END IF;
1384: IF NOT (inv_cache.set_item_rec(p_request_line_rec.organization_id, p_request_line_rec.inventory_item_id)) THEN
1385: fnd_message.set_name('INV', 'INV_VALIDATE_SUB_FAILED');
1386: fnd_msg_pub.add;
1387: RAISE fnd_api.g_exc_unexpected_error;
1388: END IF;
1389:
1390: -- then, call api
1391: l_ret_value := INV_VALIDATE.To_Subinventory(

Line 1433: IF x_return_status = fnd_api.g_ret_sts_error THEN

1429: ,x_atr => l_atr
1430: ,p_transfer_subinventory_code => NULL
1431: ,p_cost_group_id => NULL
1432: );
1433: IF x_return_status = fnd_api.g_ret_sts_error THEN
1434: RAISE fnd_api.g_exc_error ;
1435: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1436: RAISE fnd_api.g_exc_unexpected_error;
1437: END IF;

Line 1434: RAISE fnd_api.g_exc_error ;

1430: ,p_transfer_subinventory_code => NULL
1431: ,p_cost_group_id => NULL
1432: );
1433: IF x_return_status = fnd_api.g_ret_sts_error THEN
1434: RAISE fnd_api.g_exc_error ;
1435: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1436: RAISE fnd_api.g_exc_unexpected_error;
1437: END IF;
1438: --

Line 1435: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1431: ,p_cost_group_id => NULL
1432: );
1433: IF x_return_status = fnd_api.g_ret_sts_error THEN
1434: RAISE fnd_api.g_exc_error ;
1435: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1436: RAISE fnd_api.g_exc_unexpected_error;
1437: END IF;
1438: --
1439: --

Line 1436: RAISE fnd_api.g_exc_unexpected_error;

1432: );
1433: IF x_return_status = fnd_api.g_ret_sts_error THEN
1434: RAISE fnd_api.g_exc_error ;
1435: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1436: RAISE fnd_api.g_exc_unexpected_error;
1437: END IF;
1438: --
1439: --
1440: -- now compare the available qty against the needed qty and

Line 1489: IF x_return_status = fnd_api.g_ret_sts_error THEN

1485: , p_demand_source_type_id => p_request_line_rec.transaction_source_type_id
1486: , p_demand_source_header_id => p_request_line_rec.transaction_header_id
1487: , p_demand_source_line_id => p_request_line_rec.txn_source_line_id );
1488:
1489: IF x_return_status = fnd_api.g_ret_sts_error THEN
1490: RAISE fnd_api.g_exc_error ;
1491: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1492: RAISE fnd_api.g_exc_unexpected_error;
1493: END IF;

Line 1490: RAISE fnd_api.g_exc_error ;

1486: , p_demand_source_header_id => p_request_line_rec.transaction_header_id
1487: , p_demand_source_line_id => p_request_line_rec.txn_source_line_id );
1488:
1489: IF x_return_status = fnd_api.g_ret_sts_error THEN
1490: RAISE fnd_api.g_exc_error ;
1491: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1492: RAISE fnd_api.g_exc_unexpected_error;
1493: END IF;
1494:

Line 1491: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1487: , p_demand_source_line_id => p_request_line_rec.txn_source_line_id );
1488:
1489: IF x_return_status = fnd_api.g_ret_sts_error THEN
1490: RAISE fnd_api.g_exc_error ;
1491: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1492: RAISE fnd_api.g_exc_unexpected_error;
1493: END IF;
1494:
1495: END IF;

Line 1492: RAISE fnd_api.g_exc_unexpected_error;

1488:
1489: IF x_return_status = fnd_api.g_ret_sts_error THEN
1490: RAISE fnd_api.g_exc_error ;
1491: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1492: RAISE fnd_api.g_exc_unexpected_error;
1493: END IF;
1494:
1495: END IF;
1496: IF l_qty_to_update > 0 THEN

Line 1500: ,p_init_msg_lst => fnd_api.g_false

1496: IF l_qty_to_update > 0 THEN
1497: inv_quantity_tree_pvt.update_quantities
1498: (
1499: p_api_version_number => 1
1500: ,p_init_msg_lst => fnd_api.g_false
1501: ,x_return_status => x_return_status
1502: ,x_msg_count => x_msg_count
1503: ,x_msg_data => x_msg_data
1504: ,p_tree_id => p_tree_id

Line 1520: IF x_return_status = fnd_api.g_ret_sts_error THEN

1516: ,x_atr => l_atr
1517: ,p_cost_group_id => l_from_cost_group_id
1518: ) ;
1519: --
1520: IF x_return_status = fnd_api.g_ret_sts_error THEN
1521: RAISE fnd_api.g_exc_error ;
1522: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1523: RAISE fnd_api.g_exc_unexpected_error;
1524: END IF;

Line 1521: RAISE fnd_api.g_exc_error ;

1517: ,p_cost_group_id => l_from_cost_group_id
1518: ) ;
1519: --
1520: IF x_return_status = fnd_api.g_ret_sts_error THEN
1521: RAISE fnd_api.g_exc_error ;
1522: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1523: RAISE fnd_api.g_exc_unexpected_error;
1524: END IF;
1525: -- ok, lets add to the output process table for output

Line 1522: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1518: ) ;
1519: --
1520: IF x_return_status = fnd_api.g_ret_sts_error THEN
1521: RAISE fnd_api.g_exc_error ;
1522: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1523: RAISE fnd_api.g_exc_unexpected_error;
1524: END IF;
1525: -- ok, lets add to the output process table for output
1526: -- generation later

Line 1523: RAISE fnd_api.g_exc_unexpected_error;

1519: --
1520: IF x_return_status = fnd_api.g_ret_sts_error THEN
1521: RAISE fnd_api.g_exc_error ;
1522: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1523: RAISE fnd_api.g_exc_unexpected_error;
1524: END IF;
1525: -- ok, lets add to the output process table for output
1526: -- generation later
1527: l_output_process_rec.revision := l_revision;

Line 1590: WHEN fnd_api.g_exc_error THEN

1586: dbms_sql.close_cursor(l_cursor);
1587: --
1588: --
1589: EXCEPTION
1590: WHEN fnd_api.g_exc_error THEN
1591: x_return_status := fnd_api.g_ret_sts_error ;
1592: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1593: --
1594: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1591: x_return_status := fnd_api.g_ret_sts_error ;

1587: --
1588: --
1589: EXCEPTION
1590: WHEN fnd_api.g_exc_error THEN
1591: x_return_status := fnd_api.g_ret_sts_error ;
1592: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1593: --
1594: WHEN fnd_api.g_exc_unexpected_error THEN
1595: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1594: WHEN fnd_api.g_exc_unexpected_error THEN

1590: WHEN fnd_api.g_exc_error THEN
1591: x_return_status := fnd_api.g_ret_sts_error ;
1592: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1593: --
1594: WHEN fnd_api.g_exc_unexpected_error THEN
1595: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1596: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1597: --
1598: WHEN OTHERS THEN

Line 1595: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1591: x_return_status := fnd_api.g_ret_sts_error ;
1592: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1593: --
1594: WHEN fnd_api.g_exc_unexpected_error THEN
1595: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1596: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1597: --
1598: WHEN OTHERS THEN
1599: DBMS_SQL.CLOSE_CURSOR(l_cursor);

Line 1601: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1597: --
1598: WHEN OTHERS THEN
1599: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1600: --
1601: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1602: --
1603: IF (fnd_msg_pub.check_msg_level
1604: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1605: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 1619: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

1615: x_msg_data OUT NOCOPY VARCHAR2
1616: )
1617: IS
1618: l_api_name CONSTANT VARCHAR(30) := 'detail_subtransfer';
1619: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1620: l_putaway_sub VARCHAR2(30);
1621: l_putaway_loc NUMBER;
1622: l_putaway_cg NUMBER;
1623: l_output_process_rec inv_detail_util_pvt.g_output_process_rec_type;

Line 1641: IF l_return_status = fnd_api.g_ret_sts_error THEN

1637: x_msg_count,
1638: x_msg_data
1639: );
1640: --
1641: IF l_return_status = fnd_api.g_ret_sts_error THEN
1642: RAISE fnd_api.g_exc_error ;
1643: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1644: RAISE fnd_api.g_exc_unexpected_error;
1645: END IF;

Line 1642: RAISE fnd_api.g_exc_error ;

1638: x_msg_data
1639: );
1640: --
1641: IF l_return_status = fnd_api.g_ret_sts_error THEN
1642: RAISE fnd_api.g_exc_error ;
1643: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1644: RAISE fnd_api.g_exc_unexpected_error;
1645: END IF;
1646: --

Line 1643: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1639: );
1640: --
1641: IF l_return_status = fnd_api.g_ret_sts_error THEN
1642: RAISE fnd_api.g_exc_error ;
1643: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1644: RAISE fnd_api.g_exc_unexpected_error;
1645: END IF;
1646: --
1647: l_output_process_rec.revision := p_request_line_rec.revision;

Line 1644: RAISE fnd_api.g_exc_unexpected_error;

1640: --
1641: IF l_return_status = fnd_api.g_ret_sts_error THEN
1642: RAISE fnd_api.g_exc_error ;
1643: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1644: RAISE fnd_api.g_exc_unexpected_error;
1645: END IF;
1646: --
1647: l_output_process_rec.revision := p_request_line_rec.revision;
1648: l_output_process_rec.to_subinventory_code := l_putaway_sub;

Line 1670: WHEN fnd_api.g_exc_error THEN

1666: inv_detail_util_pvt.add_output(l_output_process_rec);
1667: --
1668: x_return_status := l_return_status;
1669: EXCEPTION
1670: WHEN fnd_api.g_exc_error THEN
1671: x_return_status := fnd_api.g_ret_sts_error ;
1672: --
1673: WHEN fnd_api.g_exc_unexpected_error THEN
1674: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1671: x_return_status := fnd_api.g_ret_sts_error ;

1667: --
1668: x_return_status := l_return_status;
1669: EXCEPTION
1670: WHEN fnd_api.g_exc_error THEN
1671: x_return_status := fnd_api.g_ret_sts_error ;
1672: --
1673: WHEN fnd_api.g_exc_unexpected_error THEN
1674: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1675: --

Line 1673: WHEN fnd_api.g_exc_unexpected_error THEN

1669: EXCEPTION
1670: WHEN fnd_api.g_exc_error THEN
1671: x_return_status := fnd_api.g_ret_sts_error ;
1672: --
1673: WHEN fnd_api.g_exc_unexpected_error THEN
1674: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1675: --
1676: WHEN OTHERS THEN
1677: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1674: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1670: WHEN fnd_api.g_exc_error THEN
1671: x_return_status := fnd_api.g_ret_sts_error ;
1672: --
1673: WHEN fnd_api.g_exc_unexpected_error THEN
1674: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1675: --
1676: WHEN OTHERS THEN
1677: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1678: --

Line 1677: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1673: WHEN fnd_api.g_exc_unexpected_error THEN
1674: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1675: --
1676: WHEN OTHERS THEN
1677: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1678: --
1679: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1680: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1681: END IF;

Line 1702: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

1698: x_msg_data OUT NOCOPY VARCHAR2
1699: ) IS
1700: l_api_name CONSTANT VARCHAR(30) := 'detail_subtransfer';
1701: l_rule_id NUMBER;
1702: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1703: l_pp_temp_tbl g_pp_temp_tbl_type;
1704: l_pp_temp_tbl_size NUMBER;
1705: l_detail_level_tbl inv_detail_util_pvt.g_detail_level_tbl_type;
1706: l_detail_level_tbl_size NUMBER;

Line 1760: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1756: l_return_status ,
1757: x_msg_count ,
1758: x_msg_data
1759: );
1760: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1761: RAISE fnd_api.g_exc_unexpected_error ;
1762: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1763: RAISE fnd_api.g_exc_error ;
1764: END IF;

Line 1761: RAISE fnd_api.g_exc_unexpected_error ;

1757: x_msg_count ,
1758: x_msg_data
1759: );
1760: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1761: RAISE fnd_api.g_exc_unexpected_error ;
1762: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1763: RAISE fnd_api.g_exc_error ;
1764: END IF;
1765: init_qty_tree(l_return_status,

Line 1762: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1758: x_msg_data
1759: );
1760: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1761: RAISE fnd_api.g_exc_unexpected_error ;
1762: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1763: RAISE fnd_api.g_exc_error ;
1764: END IF;
1765: init_qty_tree(l_return_status,
1766: p_request_context,

Line 1763: RAISE fnd_api.g_exc_error ;

1759: );
1760: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1761: RAISE fnd_api.g_exc_unexpected_error ;
1762: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1763: RAISE fnd_api.g_exc_error ;
1764: END IF;
1765: init_qty_tree(l_return_status,
1766: p_request_context,
1767: p_request_line_rec,

Line 1772: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1768: l_tree_id,
1769: x_msg_count,
1770: x_msg_data
1771: );
1772: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1773: RAISE fnd_api.g_exc_unexpected_error ;
1774: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1775: RAISE fnd_api.g_exc_error ;
1776: END IF;

Line 1773: RAISE fnd_api.g_exc_unexpected_error ;

1769: x_msg_count,
1770: x_msg_data
1771: );
1772: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1773: RAISE fnd_api.g_exc_unexpected_error ;
1774: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1775: RAISE fnd_api.g_exc_error ;
1776: END IF;
1777: -- detail individual records

Line 1774: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1770: x_msg_data
1771: );
1772: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1773: RAISE fnd_api.g_exc_unexpected_error ;
1774: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1775: RAISE fnd_api.g_exc_error ;
1776: END IF;
1777: -- detail individual records
1778: FOR l_index IN 1..l_pp_temp_tbl_size LOOP

Line 1775: RAISE fnd_api.g_exc_error ;

1771: );
1772: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1773: RAISE fnd_api.g_exc_unexpected_error ;
1774: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1775: RAISE fnd_api.g_exc_error ;
1776: END IF;
1777: -- detail individual records
1778: FOR l_index IN 1..l_pp_temp_tbl_size LOOP
1779: --

Line 1791: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1787: x_msg_count,
1788: x_msg_data
1789: );
1790: --
1791: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1792: RAISE fnd_api.g_exc_unexpected_error ;
1793: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1794: RAISE fnd_api.g_exc_error ;
1795: END IF;

Line 1792: RAISE fnd_api.g_exc_unexpected_error ;

1788: x_msg_data
1789: );
1790: --
1791: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1792: RAISE fnd_api.g_exc_unexpected_error ;
1793: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1794: RAISE fnd_api.g_exc_error ;
1795: END IF;
1796: --

Line 1793: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1789: );
1790: --
1791: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1792: RAISE fnd_api.g_exc_unexpected_error ;
1793: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1794: RAISE fnd_api.g_exc_error ;
1795: END IF;
1796: --
1797: -- detailing by execute the picking sql to find pick location

Line 1794: RAISE fnd_api.g_exc_error ;

1790: --
1791: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1792: RAISE fnd_api.g_exc_unexpected_error ;
1793: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1794: RAISE fnd_api.g_exc_error ;
1795: END IF;
1796: --
1797: -- detailing by execute the picking sql to find pick location
1798: -- and find out put away locations for transfer

Line 1809: IF l_return_status = fnd_api.g_ret_sts_error THEN

1805: l_return_status,
1806: x_msg_count,
1807: x_msg_data
1808: );
1809: IF l_return_status = fnd_api.g_ret_sts_error THEN
1810: RAISE fnd_api.g_exc_error ;
1811: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1812: RAISE fnd_api.g_exc_unexpected_error;
1813: END IF;

Line 1810: RAISE fnd_api.g_exc_error ;

1806: x_msg_count,
1807: x_msg_data
1808: );
1809: IF l_return_status = fnd_api.g_ret_sts_error THEN
1810: RAISE fnd_api.g_exc_error ;
1811: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1812: RAISE fnd_api.g_exc_unexpected_error;
1813: END IF;
1814: END LOOP;

Line 1811: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1807: x_msg_data
1808: );
1809: IF l_return_status = fnd_api.g_ret_sts_error THEN
1810: RAISE fnd_api.g_exc_error ;
1811: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1812: RAISE fnd_api.g_exc_unexpected_error;
1813: END IF;
1814: END LOOP;
1815: -- free the quantity tree after inserting output records

Line 1812: RAISE fnd_api.g_exc_unexpected_error;

1808: );
1809: IF l_return_status = fnd_api.g_ret_sts_error THEN
1810: RAISE fnd_api.g_exc_error ;
1811: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1812: RAISE fnd_api.g_exc_unexpected_error;
1813: END IF;
1814: END LOOP;
1815: -- free the quantity tree after inserting output records
1816: -- Bug 1384720 - performance improvements

Line 1822: ,p_init_msg_lst => fnd_api.g_false

1818: /*
1819: inv_quantity_tree_pvt.free_tree
1820: (
1821: p_api_version_number => 1.0
1822: ,p_init_msg_lst => fnd_api.g_false
1823: ,x_return_status => l_return_status
1824: ,x_msg_count => x_msg_count
1825: ,x_msg_data => x_msg_data
1826: ,p_tree_id => l_tree_id

Line 1828: IF l_return_status = fnd_api.g_ret_sts_error THEN

1824: ,x_msg_count => x_msg_count
1825: ,x_msg_data => x_msg_data
1826: ,p_tree_id => l_tree_id
1827: );
1828: IF l_return_status = fnd_api.g_ret_sts_error THEN
1829: RAISE fnd_api.g_exc_error ;
1830: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1831: RAISE fnd_api.g_exc_unexpected_error;
1832: END IF;

Line 1829: RAISE fnd_api.g_exc_error ;

1825: ,x_msg_data => x_msg_data
1826: ,p_tree_id => l_tree_id
1827: );
1828: IF l_return_status = fnd_api.g_ret_sts_error THEN
1829: RAISE fnd_api.g_exc_error ;
1830: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1831: RAISE fnd_api.g_exc_unexpected_error;
1832: END IF;
1833: */

Line 1830: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1826: ,p_tree_id => l_tree_id
1827: );
1828: IF l_return_status = fnd_api.g_ret_sts_error THEN
1829: RAISE fnd_api.g_exc_error ;
1830: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1831: RAISE fnd_api.g_exc_unexpected_error;
1832: END IF;
1833: */
1834: ELSE

Line 1831: RAISE fnd_api.g_exc_unexpected_error;

1827: );
1828: IF l_return_status = fnd_api.g_ret_sts_error THEN
1829: RAISE fnd_api.g_exc_error ;
1830: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1831: RAISE fnd_api.g_exc_unexpected_error;
1832: END IF;
1833: */
1834: ELSE
1835: detail_putaway_only (p_request_line_rec ,

Line 1842: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1838: x_msg_count ,
1839: x_msg_data
1840: );
1841: END IF;
1842: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1843: RAISE fnd_api.g_exc_unexpected_error ;
1844: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1845: raise fnd_api.g_exc_error ;
1846: END IF;

Line 1843: RAISE fnd_api.g_exc_unexpected_error ;

1839: x_msg_data
1840: );
1841: END IF;
1842: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1843: RAISE fnd_api.g_exc_unexpected_error ;
1844: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1845: raise fnd_api.g_exc_error ;
1846: END IF;
1847: -- if no locations has been found, lets report error

Line 1844: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1840: );
1841: END IF;
1842: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1843: RAISE fnd_api.g_exc_unexpected_error ;
1844: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1845: raise fnd_api.g_exc_error ;
1846: END IF;
1847: -- if no locations has been found, lets report error
1848: IF inv_detail_util_pvt.g_output_process_tbl.COUNT = 0 THEN

Line 1845: raise fnd_api.g_exc_error ;

1841: END IF;
1842: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1843: RAISE fnd_api.g_exc_unexpected_error ;
1844: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1845: raise fnd_api.g_exc_error ;
1846: END IF;
1847: -- if no locations has been found, lets report error
1848: IF inv_detail_util_pvt.g_output_process_tbl.COUNT = 0 THEN
1849: --edited out called to fnd_message by jcearley, 12/2/99

Line 1853: --RAISE fnd_api.g_exc_error;

1849: --edited out called to fnd_message by jcearley, 12/2/99
1850: --fnd_message.set_name('INV','INV_SUGGESTION_FAILED');
1851: -- Suggestions not or only partially created through applying strategy
1852: --fnd_msg_pub.add;
1853: --RAISE fnd_api.g_exc_error;
1854: RETURN; -- do not raise exeception since it is not an error if can't find qty
1855: END IF;
1856: -- now we can generate records into transactions temp tables
1857: inv_detail_util_pvt.process_output(l_return_status,

Line 1861: IF l_return_status = fnd_api.g_ret_sts_error THEN

1857: inv_detail_util_pvt.process_output(l_return_status,
1858: p_request_line_rec,
1859: p_request_context
1860: );
1861: IF l_return_status = fnd_api.g_ret_sts_error THEN
1862: RAISE fnd_api.g_exc_error ;
1863: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1864: RAISE fnd_api.g_exc_unexpected_error;
1865: END IF;

Line 1862: RAISE fnd_api.g_exc_error ;

1858: p_request_line_rec,
1859: p_request_context
1860: );
1861: IF l_return_status = fnd_api.g_ret_sts_error THEN
1862: RAISE fnd_api.g_exc_error ;
1863: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1864: RAISE fnd_api.g_exc_unexpected_error;
1865: END IF;
1866: x_return_status := l_return_status;

Line 1863: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1859: p_request_context
1860: );
1861: IF l_return_status = fnd_api.g_ret_sts_error THEN
1862: RAISE fnd_api.g_exc_error ;
1863: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1864: RAISE fnd_api.g_exc_unexpected_error;
1865: END IF;
1866: x_return_status := l_return_status;
1867: EXCEPTION

Line 1864: RAISE fnd_api.g_exc_unexpected_error;

1860: );
1861: IF l_return_status = fnd_api.g_ret_sts_error THEN
1862: RAISE fnd_api.g_exc_error ;
1863: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1864: RAISE fnd_api.g_exc_unexpected_error;
1865: END IF;
1866: x_return_status := l_return_status;
1867: EXCEPTION
1868: WHEN fnd_api.g_exc_error THEN

Line 1868: WHEN fnd_api.g_exc_error THEN

1864: RAISE fnd_api.g_exc_unexpected_error;
1865: END IF;
1866: x_return_status := l_return_status;
1867: EXCEPTION
1868: WHEN fnd_api.g_exc_error THEN
1869: x_return_status := fnd_api.g_ret_sts_error ;
1870: --
1871: WHEN fnd_api.g_exc_unexpected_error THEN
1872: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1869: x_return_status := fnd_api.g_ret_sts_error ;

1865: END IF;
1866: x_return_status := l_return_status;
1867: EXCEPTION
1868: WHEN fnd_api.g_exc_error THEN
1869: x_return_status := fnd_api.g_ret_sts_error ;
1870: --
1871: WHEN fnd_api.g_exc_unexpected_error THEN
1872: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1873: --

Line 1871: WHEN fnd_api.g_exc_unexpected_error THEN

1867: EXCEPTION
1868: WHEN fnd_api.g_exc_error THEN
1869: x_return_status := fnd_api.g_ret_sts_error ;
1870: --
1871: WHEN fnd_api.g_exc_unexpected_error THEN
1872: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1873: --
1874: WHEN OTHERS THEN
1875: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1872: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1868: WHEN fnd_api.g_exc_error THEN
1869: x_return_status := fnd_api.g_ret_sts_error ;
1870: --
1871: WHEN fnd_api.g_exc_unexpected_error THEN
1872: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1873: --
1874: WHEN OTHERS THEN
1875: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1876: --

Line 1875: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1871: WHEN fnd_api.g_exc_unexpected_error THEN
1872: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1873: --
1874: WHEN OTHERS THEN
1875: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1876: --
1877: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1878: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1879: END IF;

Line 1909: -- and pass p_suggest_serial as fnd_api.true, the engine will filter

1905: --
1906: -- 2. Serial Number Detailing in Picking
1907: -- Currently the serial number detailing is quite simple. If the caller
1908: -- gives a range (start, and end) serial numbers in the move order line
1909: -- and pass p_suggest_serial as fnd_api.true, the engine will filter
1910: -- the locations found from a rule, and suggest unused serial numbers
1911: -- in the locator. If p_suggest_serial is passed as fnd_api.g_false
1912: -- (default), the engine will not give serial numbers in the output.
1913: --

Line 1911: -- in the locator. If p_suggest_serial is passed as fnd_api.g_false

1907: -- Currently the serial number detailing is quite simple. If the caller
1908: -- gives a range (start, and end) serial numbers in the move order line
1909: -- and pass p_suggest_serial as fnd_api.true, the engine will filter
1910: -- the locations found from a rule, and suggest unused serial numbers
1911: -- in the locator. If p_suggest_serial is passed as fnd_api.g_false
1912: -- (default), the engine will not give serial numbers in the output.
1913: --
1914: -- Input Parameters
1915: -- p_api_version_number standard input parameter

Line 1934: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

1930: -- x_msg_data standard output parameters
1931: --
1932: PROCEDURE create_suggestions
1933: (p_api_version IN NUMBER,
1934: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1935: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1936: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_none,
1937: x_return_status OUT NOCOPY VARCHAR2,
1938: x_msg_count OUT NOCOPY NUMBER,

Line 1935: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

1931: --
1932: PROCEDURE create_suggestions
1933: (p_api_version IN NUMBER,
1934: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1935: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1936: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_none,
1937: x_return_status OUT NOCOPY VARCHAR2,
1938: x_msg_count OUT NOCOPY NUMBER,
1939: x_msg_data OUT NOCOPY VARCHAR2,

Line 1936: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_none,

1932: PROCEDURE create_suggestions
1933: (p_api_version IN NUMBER,
1934: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1935: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1936: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_none,
1937: x_return_status OUT NOCOPY VARCHAR2,
1938: x_msg_count OUT NOCOPY NUMBER,
1939: x_msg_data OUT NOCOPY VARCHAR2,
1940: p_transaction_temp_id IN NUMBER,

Line 1942: p_suggest_serial IN VARCHAR2 DEFAULT fnd_api.g_false

1938: x_msg_count OUT NOCOPY NUMBER,
1939: x_msg_data OUT NOCOPY VARCHAR2,
1940: p_transaction_temp_id IN NUMBER,
1941: p_reservations IN inv_reservation_global.mtl_reservation_tbl_type,
1942: p_suggest_serial IN VARCHAR2 DEFAULT fnd_api.g_false
1943: ) IS
1944: --
1945: -- constants
1946: l_api_name CONSTANT VARCHAR(30) := 'create_suggestions';

Line 1948: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success ;

1944: --
1945: -- constants
1946: l_api_name CONSTANT VARCHAR(30) := 'create_suggestions';
1947: c_api_version_number CONSTANT NUMBER := 1.0;
1948: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success ;
1949: l_request_context inv_detail_util_pvt.g_request_context_rec_type;
1950: l_request_line_rec inv_detail_util_pvt.g_request_line_rec_type;
1951: BEGIN
1952: -- Standard start of API savepoint

Line 1956: IF NOT fnd_api.compatible_api_call(

1952: -- Standard start of API savepoint
1953: SAVEPOINT create_suggestions_sa;
1954: --
1955: --Standard compatibility check
1956: IF NOT fnd_api.compatible_api_call(
1957: c_api_version_number
1958: , p_api_version
1959: , l_api_name
1960: , g_pkg_name) THEN

Line 1961: RAISE fnd_api.g_exc_unexpected_error;

1957: c_api_version_number
1958: , p_api_version
1959: , l_api_name
1960: , g_pkg_name) THEN
1961: RAISE fnd_api.g_exc_unexpected_error;
1962: END IF;
1963: --
1964: -- Initialize message list
1965: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1965: IF fnd_api.to_boolean(p_init_msg_list) THEN

1961: RAISE fnd_api.g_exc_unexpected_error;
1962: END IF;
1963: --
1964: -- Initialize message list
1965: IF fnd_api.to_boolean(p_init_msg_list) THEN
1966: fnd_msg_pub.initialize;
1967: END IF;
1968: --
1969: x_return_status := fnd_api.g_ret_sts_success ;

Line 1969: x_return_status := fnd_api.g_ret_sts_success ;

1965: IF fnd_api.to_boolean(p_init_msg_list) THEN
1966: fnd_msg_pub.initialize;
1967: END IF;
1968: --
1969: x_return_status := fnd_api.g_ret_sts_success ;
1970: --
1971: -- validate input and initialize
1972: inv_detail_util_pvt.validate_and_init
1973: (l_return_status ,

Line 1979: IF l_return_status = fnd_api.g_ret_sts_error THEN

1975: p_suggest_serial ,
1976: l_request_line_rec ,
1977: l_request_context
1978: );
1979: IF l_return_status = fnd_api.g_ret_sts_error THEN
1980: RAISE fnd_api.g_exc_error;
1981: END IF;
1982: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1983: RAISE fnd_api.g_exc_unexpected_error;

Line 1980: RAISE fnd_api.g_exc_error;

1976: l_request_line_rec ,
1977: l_request_context
1978: );
1979: IF l_return_status = fnd_api.g_ret_sts_error THEN
1980: RAISE fnd_api.g_exc_error;
1981: END IF;
1982: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1983: RAISE fnd_api.g_exc_unexpected_error;
1984: END IF;

Line 1982: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1978: );
1979: IF l_return_status = fnd_api.g_ret_sts_error THEN
1980: RAISE fnd_api.g_exc_error;
1981: END IF;
1982: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1983: RAISE fnd_api.g_exc_unexpected_error;
1984: END IF;
1985:
1986: --don't detail serial numbers for items that are serial controlled only

Line 1983: RAISE fnd_api.g_exc_unexpected_error;

1979: IF l_return_status = fnd_api.g_ret_sts_error THEN
1980: RAISE fnd_api.g_exc_error;
1981: END IF;
1982: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1983: RAISE fnd_api.g_exc_unexpected_error;
1984: END IF;
1985:
1986: --don't detail serial numbers for items that are serial controlled only
1987: -- at sales order issue

Line 1999: IF (l_return_status = fnd_api.g_ret_sts_unexp_error ) THEN

1995: l_return_status ,
1996: x_msg_count ,
1997: x_msg_data
1998: );
1999: IF (l_return_status = fnd_api.g_ret_sts_unexp_error ) THEN
2000: RAISE fnd_api.g_exc_unexpected_error ;
2001: ELSIF ( l_return_status = fnd_api.g_ret_sts_error ) THEN
2002: RAISE fnd_api.g_exc_error ;
2003: END IF;

Line 2000: RAISE fnd_api.g_exc_unexpected_error ;

1996: x_msg_count ,
1997: x_msg_data
1998: );
1999: IF (l_return_status = fnd_api.g_ret_sts_unexp_error ) THEN
2000: RAISE fnd_api.g_exc_unexpected_error ;
2001: ELSIF ( l_return_status = fnd_api.g_ret_sts_error ) THEN
2002: RAISE fnd_api.g_exc_error ;
2003: END IF;
2004: --

Line 2001: ELSIF ( l_return_status = fnd_api.g_ret_sts_error ) THEN

1997: x_msg_data
1998: );
1999: IF (l_return_status = fnd_api.g_ret_sts_unexp_error ) THEN
2000: RAISE fnd_api.g_exc_unexpected_error ;
2001: ELSIF ( l_return_status = fnd_api.g_ret_sts_error ) THEN
2002: RAISE fnd_api.g_exc_error ;
2003: END IF;
2004: --
2005: -- Standard check of p_commit

Line 2002: RAISE fnd_api.g_exc_error ;

1998: );
1999: IF (l_return_status = fnd_api.g_ret_sts_unexp_error ) THEN
2000: RAISE fnd_api.g_exc_unexpected_error ;
2001: ELSIF ( l_return_status = fnd_api.g_ret_sts_error ) THEN
2002: RAISE fnd_api.g_exc_error ;
2003: END IF;
2004: --
2005: -- Standard check of p_commit
2006: IF fnd_api.to_boolean(p_commit) THEN

Line 2006: IF fnd_api.to_boolean(p_commit) THEN

2002: RAISE fnd_api.g_exc_error ;
2003: END IF;
2004: --
2005: -- Standard check of p_commit
2006: IF fnd_api.to_boolean(p_commit) THEN
2007: COMMIT;
2008: END IF;
2009: --
2010: --

Line 2014: WHEN fnd_api.g_exc_error THEN

2010: --
2011: x_return_status := l_return_status;
2012: --
2013: EXCEPTION
2014: WHEN fnd_api.g_exc_error THEN
2015: --
2016: -- debugging section
2017: -- can be commented ut for final code
2018: IF inv_pp_debug.is_debug_mode THEN

Line 2028: x_return_status := fnd_api.g_ret_sts_error;

2024: END IF;
2025: -- end of debugging section
2026: --
2027: ROLLBACK TO create_suggestions_sa;
2028: x_return_status := fnd_api.g_ret_sts_error;
2029: fnd_msg_pub.Count_And_Get
2030: ( p_count => x_msg_count
2031: ,p_data => x_msg_data);
2032: --

Line 2033: WHEN fnd_api.g_exc_unexpected_error THEN

2029: fnd_msg_pub.Count_And_Get
2030: ( p_count => x_msg_count
2031: ,p_data => x_msg_data);
2032: --
2033: WHEN fnd_api.g_exc_unexpected_error THEN
2034: --
2035: -- debugging section
2036: -- can be commented ut for final code
2037: IF inv_pp_debug.is_debug_mode THEN

Line 2047: x_return_status := fnd_api.g_ret_sts_unexp_error;

2043: END IF;
2044: -- end of debugging section
2045: --
2046: ROLLBACK TO create_suggestions_sa;
2047: x_return_status := fnd_api.g_ret_sts_unexp_error;
2048: fnd_msg_pub.Count_And_Get
2049: ( p_count => x_msg_count
2050: ,p_data => x_msg_data);
2051: --

Line 2066: x_return_status := fnd_api.g_ret_sts_unexp_error;

2062: END IF;
2063: -- end of debugging section
2064: --
2065: ROLLBACK TO create_suggestions_sa;
2066: x_return_status := fnd_api.g_ret_sts_unexp_error;
2067: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2068: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
2069: END IF;
2070: fnd_msg_pub.count_and_get