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

Line 16: p_source_type IN NUMBER := FND_API.G_MISS_NUM,

12: p_subinventory_name IN VARCHAR2,
13: p_locator_id IN NUMBER,
14: p_kanban_size IN NUMBER,
15: p_number_of_cards IN NUMBER,
16: p_source_type IN NUMBER := FND_API.G_MISS_NUM,
17: p_source_organization_id IN NUMBER := FND_API.G_MISS_NUM,
18: p_source_subinventory IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_source_locator_id IN NUMBER := FND_API.G_MISS_NUM,
20: p_line_id IN NUMBER := FND_API.G_MISS_NUM,

Line 17: p_source_organization_id IN NUMBER := FND_API.G_MISS_NUM,

13: p_locator_id IN NUMBER,
14: p_kanban_size IN NUMBER,
15: p_number_of_cards IN NUMBER,
16: p_source_type IN NUMBER := FND_API.G_MISS_NUM,
17: p_source_organization_id IN NUMBER := FND_API.G_MISS_NUM,
18: p_source_subinventory IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_source_locator_id IN NUMBER := FND_API.G_MISS_NUM,
20: p_line_id IN NUMBER := FND_API.G_MISS_NUM,
21: p_supplier_id IN NUMBER := FND_API.G_MISS_NUM,

Line 18: p_source_subinventory IN VARCHAR2 := FND_API.G_MISS_CHAR,

14: p_kanban_size IN NUMBER,
15: p_number_of_cards IN NUMBER,
16: p_source_type IN NUMBER := FND_API.G_MISS_NUM,
17: p_source_organization_id IN NUMBER := FND_API.G_MISS_NUM,
18: p_source_subinventory IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_source_locator_id IN NUMBER := FND_API.G_MISS_NUM,
20: p_line_id IN NUMBER := FND_API.G_MISS_NUM,
21: p_supplier_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_supplier_site_id IN NUMBER := FND_API.G_MISS_NUM,

Line 19: p_source_locator_id IN NUMBER := FND_API.G_MISS_NUM,

15: p_number_of_cards IN NUMBER,
16: p_source_type IN NUMBER := FND_API.G_MISS_NUM,
17: p_source_organization_id IN NUMBER := FND_API.G_MISS_NUM,
18: p_source_subinventory IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_source_locator_id IN NUMBER := FND_API.G_MISS_NUM,
20: p_line_id IN NUMBER := FND_API.G_MISS_NUM,
21: p_supplier_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_supplier_site_id IN NUMBER := FND_API.G_MISS_NUM,
23: p_calculate_kanban_flag IN NUMBER := FND_API.G_MISS_NUM,

Line 20: p_line_id IN NUMBER := FND_API.G_MISS_NUM,

16: p_source_type IN NUMBER := FND_API.G_MISS_NUM,
17: p_source_organization_id IN NUMBER := FND_API.G_MISS_NUM,
18: p_source_subinventory IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_source_locator_id IN NUMBER := FND_API.G_MISS_NUM,
20: p_line_id IN NUMBER := FND_API.G_MISS_NUM,
21: p_supplier_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_supplier_site_id IN NUMBER := FND_API.G_MISS_NUM,
23: p_calculate_kanban_flag IN NUMBER := FND_API.G_MISS_NUM,
24: p_replenishment_lead_time IN NUMBER := FND_API.G_MISS_NUM,

Line 21: p_supplier_id IN NUMBER := FND_API.G_MISS_NUM,

17: p_source_organization_id IN NUMBER := FND_API.G_MISS_NUM,
18: p_source_subinventory IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_source_locator_id IN NUMBER := FND_API.G_MISS_NUM,
20: p_line_id IN NUMBER := FND_API.G_MISS_NUM,
21: p_supplier_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_supplier_site_id IN NUMBER := FND_API.G_MISS_NUM,
23: p_calculate_kanban_flag IN NUMBER := FND_API.G_MISS_NUM,
24: p_replenishment_lead_time IN NUMBER := FND_API.G_MISS_NUM,
25: p_release_kanban_flag IN NUMBER := FND_API.G_MISS_NUM,

Line 22: p_supplier_site_id IN NUMBER := FND_API.G_MISS_NUM,

18: p_source_subinventory IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_source_locator_id IN NUMBER := FND_API.G_MISS_NUM,
20: p_line_id IN NUMBER := FND_API.G_MISS_NUM,
21: p_supplier_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_supplier_site_id IN NUMBER := FND_API.G_MISS_NUM,
23: p_calculate_kanban_flag IN NUMBER := FND_API.G_MISS_NUM,
24: p_replenishment_lead_time IN NUMBER := FND_API.G_MISS_NUM,
25: p_release_kanban_flag IN NUMBER := FND_API.G_MISS_NUM,
26: p_minimum_order_quantity IN NUMBER := FND_API.G_MISS_NUM,

Line 23: p_calculate_kanban_flag IN NUMBER := FND_API.G_MISS_NUM,

19: p_source_locator_id IN NUMBER := FND_API.G_MISS_NUM,
20: p_line_id IN NUMBER := FND_API.G_MISS_NUM,
21: p_supplier_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_supplier_site_id IN NUMBER := FND_API.G_MISS_NUM,
23: p_calculate_kanban_flag IN NUMBER := FND_API.G_MISS_NUM,
24: p_replenishment_lead_time IN NUMBER := FND_API.G_MISS_NUM,
25: p_release_kanban_flag IN NUMBER := FND_API.G_MISS_NUM,
26: p_minimum_order_quantity IN NUMBER := FND_API.G_MISS_NUM,
27: p_fixed_lot_multiplier IN NUMBER := FND_API.G_MISS_NUM,

Line 24: p_replenishment_lead_time IN NUMBER := FND_API.G_MISS_NUM,

20: p_line_id IN NUMBER := FND_API.G_MISS_NUM,
21: p_supplier_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_supplier_site_id IN NUMBER := FND_API.G_MISS_NUM,
23: p_calculate_kanban_flag IN NUMBER := FND_API.G_MISS_NUM,
24: p_replenishment_lead_time IN NUMBER := FND_API.G_MISS_NUM,
25: p_release_kanban_flag IN NUMBER := FND_API.G_MISS_NUM,
26: p_minimum_order_quantity IN NUMBER := FND_API.G_MISS_NUM,
27: p_fixed_lot_multiplier IN NUMBER := FND_API.G_MISS_NUM,
28: p_safety_stock_days IN NUMBER := FND_API.G_MISS_NUM) IS

Line 25: p_release_kanban_flag IN NUMBER := FND_API.G_MISS_NUM,

21: p_supplier_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_supplier_site_id IN NUMBER := FND_API.G_MISS_NUM,
23: p_calculate_kanban_flag IN NUMBER := FND_API.G_MISS_NUM,
24: p_replenishment_lead_time IN NUMBER := FND_API.G_MISS_NUM,
25: p_release_kanban_flag IN NUMBER := FND_API.G_MISS_NUM,
26: p_minimum_order_quantity IN NUMBER := FND_API.G_MISS_NUM,
27: p_fixed_lot_multiplier IN NUMBER := FND_API.G_MISS_NUM,
28: p_safety_stock_days IN NUMBER := FND_API.G_MISS_NUM) IS
29:

Line 26: p_minimum_order_quantity IN NUMBER := FND_API.G_MISS_NUM,

22: p_supplier_site_id IN NUMBER := FND_API.G_MISS_NUM,
23: p_calculate_kanban_flag IN NUMBER := FND_API.G_MISS_NUM,
24: p_replenishment_lead_time IN NUMBER := FND_API.G_MISS_NUM,
25: p_release_kanban_flag IN NUMBER := FND_API.G_MISS_NUM,
26: p_minimum_order_quantity IN NUMBER := FND_API.G_MISS_NUM,
27: p_fixed_lot_multiplier IN NUMBER := FND_API.G_MISS_NUM,
28: p_safety_stock_days IN NUMBER := FND_API.G_MISS_NUM) IS
29:
30: l_pull_sequence_rec INV_Kanban_PVT.pull_sequence_rec_type;

Line 27: p_fixed_lot_multiplier IN NUMBER := FND_API.G_MISS_NUM,

23: p_calculate_kanban_flag IN NUMBER := FND_API.G_MISS_NUM,
24: p_replenishment_lead_time IN NUMBER := FND_API.G_MISS_NUM,
25: p_release_kanban_flag IN NUMBER := FND_API.G_MISS_NUM,
26: p_minimum_order_quantity IN NUMBER := FND_API.G_MISS_NUM,
27: p_fixed_lot_multiplier IN NUMBER := FND_API.G_MISS_NUM,
28: p_safety_stock_days IN NUMBER := FND_API.G_MISS_NUM) IS
29:
30: l_pull_sequence_rec INV_Kanban_PVT.pull_sequence_rec_type;
31: l_return_status VARCHAR2(1);

Line 28: p_safety_stock_days IN NUMBER := FND_API.G_MISS_NUM) IS

24: p_replenishment_lead_time IN NUMBER := FND_API.G_MISS_NUM,
25: p_release_kanban_flag IN NUMBER := FND_API.G_MISS_NUM,
26: p_minimum_order_quantity IN NUMBER := FND_API.G_MISS_NUM,
27: p_fixed_lot_multiplier IN NUMBER := FND_API.G_MISS_NUM,
28: p_safety_stock_days IN NUMBER := FND_API.G_MISS_NUM) IS
29:
30: l_pull_sequence_rec INV_Kanban_PVT.pull_sequence_rec_type;
31: l_return_status VARCHAR2(1);
32: BEGIN

Line 46: l_pull_sequence_rec.source_type := FND_API.G_MISS_NUM;

42:
43: -- If source type is passed as -1 then only update size and number
44: -- information. Set values to default.
45: IF (p_source_type = -1) THEN
46: l_pull_sequence_rec.source_type := FND_API.G_MISS_NUM;
47: l_pull_sequence_rec.source_organization_id := FND_API.G_MISS_NUM;
48: l_pull_sequence_rec.source_subinventory := FND_API.G_MISS_CHAR;
49: l_pull_sequence_rec.source_locator_id := FND_API.G_MISS_NUM;
50: l_pull_sequence_rec.wip_line_id := FND_API.G_MISS_NUM;

Line 47: l_pull_sequence_rec.source_organization_id := FND_API.G_MISS_NUM;

43: -- If source type is passed as -1 then only update size and number
44: -- information. Set values to default.
45: IF (p_source_type = -1) THEN
46: l_pull_sequence_rec.source_type := FND_API.G_MISS_NUM;
47: l_pull_sequence_rec.source_organization_id := FND_API.G_MISS_NUM;
48: l_pull_sequence_rec.source_subinventory := FND_API.G_MISS_CHAR;
49: l_pull_sequence_rec.source_locator_id := FND_API.G_MISS_NUM;
50: l_pull_sequence_rec.wip_line_id := FND_API.G_MISS_NUM;
51: l_pull_sequence_rec.supplier_id := FND_API.G_MISS_NUM;

Line 48: l_pull_sequence_rec.source_subinventory := FND_API.G_MISS_CHAR;

44: -- information. Set values to default.
45: IF (p_source_type = -1) THEN
46: l_pull_sequence_rec.source_type := FND_API.G_MISS_NUM;
47: l_pull_sequence_rec.source_organization_id := FND_API.G_MISS_NUM;
48: l_pull_sequence_rec.source_subinventory := FND_API.G_MISS_CHAR;
49: l_pull_sequence_rec.source_locator_id := FND_API.G_MISS_NUM;
50: l_pull_sequence_rec.wip_line_id := FND_API.G_MISS_NUM;
51: l_pull_sequence_rec.supplier_id := FND_API.G_MISS_NUM;
52: l_pull_sequence_rec.supplier_site_id := FND_API.G_MISS_NUM;

Line 49: l_pull_sequence_rec.source_locator_id := FND_API.G_MISS_NUM;

45: IF (p_source_type = -1) THEN
46: l_pull_sequence_rec.source_type := FND_API.G_MISS_NUM;
47: l_pull_sequence_rec.source_organization_id := FND_API.G_MISS_NUM;
48: l_pull_sequence_rec.source_subinventory := FND_API.G_MISS_CHAR;
49: l_pull_sequence_rec.source_locator_id := FND_API.G_MISS_NUM;
50: l_pull_sequence_rec.wip_line_id := FND_API.G_MISS_NUM;
51: l_pull_sequence_rec.supplier_id := FND_API.G_MISS_NUM;
52: l_pull_sequence_rec.supplier_site_id := FND_API.G_MISS_NUM;
53: l_pull_sequence_rec.calculate_kanban_flag := FND_API.G_MISS_NUM;

Line 50: l_pull_sequence_rec.wip_line_id := FND_API.G_MISS_NUM;

46: l_pull_sequence_rec.source_type := FND_API.G_MISS_NUM;
47: l_pull_sequence_rec.source_organization_id := FND_API.G_MISS_NUM;
48: l_pull_sequence_rec.source_subinventory := FND_API.G_MISS_CHAR;
49: l_pull_sequence_rec.source_locator_id := FND_API.G_MISS_NUM;
50: l_pull_sequence_rec.wip_line_id := FND_API.G_MISS_NUM;
51: l_pull_sequence_rec.supplier_id := FND_API.G_MISS_NUM;
52: l_pull_sequence_rec.supplier_site_id := FND_API.G_MISS_NUM;
53: l_pull_sequence_rec.calculate_kanban_flag := FND_API.G_MISS_NUM;
54: l_pull_sequence_rec.replenishment_lead_time := FND_API.G_MISS_NUM;

Line 51: l_pull_sequence_rec.supplier_id := FND_API.G_MISS_NUM;

47: l_pull_sequence_rec.source_organization_id := FND_API.G_MISS_NUM;
48: l_pull_sequence_rec.source_subinventory := FND_API.G_MISS_CHAR;
49: l_pull_sequence_rec.source_locator_id := FND_API.G_MISS_NUM;
50: l_pull_sequence_rec.wip_line_id := FND_API.G_MISS_NUM;
51: l_pull_sequence_rec.supplier_id := FND_API.G_MISS_NUM;
52: l_pull_sequence_rec.supplier_site_id := FND_API.G_MISS_NUM;
53: l_pull_sequence_rec.calculate_kanban_flag := FND_API.G_MISS_NUM;
54: l_pull_sequence_rec.replenishment_lead_time := FND_API.G_MISS_NUM;
55:

Line 52: l_pull_sequence_rec.supplier_site_id := FND_API.G_MISS_NUM;

48: l_pull_sequence_rec.source_subinventory := FND_API.G_MISS_CHAR;
49: l_pull_sequence_rec.source_locator_id := FND_API.G_MISS_NUM;
50: l_pull_sequence_rec.wip_line_id := FND_API.G_MISS_NUM;
51: l_pull_sequence_rec.supplier_id := FND_API.G_MISS_NUM;
52: l_pull_sequence_rec.supplier_site_id := FND_API.G_MISS_NUM;
53: l_pull_sequence_rec.calculate_kanban_flag := FND_API.G_MISS_NUM;
54: l_pull_sequence_rec.replenishment_lead_time := FND_API.G_MISS_NUM;
55:
56: l_pull_sequence_rec.release_kanban_flag := FND_API.G_MISS_NUM;

Line 53: l_pull_sequence_rec.calculate_kanban_flag := FND_API.G_MISS_NUM;

49: l_pull_sequence_rec.source_locator_id := FND_API.G_MISS_NUM;
50: l_pull_sequence_rec.wip_line_id := FND_API.G_MISS_NUM;
51: l_pull_sequence_rec.supplier_id := FND_API.G_MISS_NUM;
52: l_pull_sequence_rec.supplier_site_id := FND_API.G_MISS_NUM;
53: l_pull_sequence_rec.calculate_kanban_flag := FND_API.G_MISS_NUM;
54: l_pull_sequence_rec.replenishment_lead_time := FND_API.G_MISS_NUM;
55:
56: l_pull_sequence_rec.release_kanban_flag := FND_API.G_MISS_NUM;
57: l_pull_sequence_rec.minimum_order_quantity := FND_API.G_MISS_NUM;

Line 54: l_pull_sequence_rec.replenishment_lead_time := FND_API.G_MISS_NUM;

50: l_pull_sequence_rec.wip_line_id := FND_API.G_MISS_NUM;
51: l_pull_sequence_rec.supplier_id := FND_API.G_MISS_NUM;
52: l_pull_sequence_rec.supplier_site_id := FND_API.G_MISS_NUM;
53: l_pull_sequence_rec.calculate_kanban_flag := FND_API.G_MISS_NUM;
54: l_pull_sequence_rec.replenishment_lead_time := FND_API.G_MISS_NUM;
55:
56: l_pull_sequence_rec.release_kanban_flag := FND_API.G_MISS_NUM;
57: l_pull_sequence_rec.minimum_order_quantity := FND_API.G_MISS_NUM;
58: l_pull_sequence_rec.fixed_lot_multiplier := FND_API.G_MISS_NUM;

Line 56: l_pull_sequence_rec.release_kanban_flag := FND_API.G_MISS_NUM;

52: l_pull_sequence_rec.supplier_site_id := FND_API.G_MISS_NUM;
53: l_pull_sequence_rec.calculate_kanban_flag := FND_API.G_MISS_NUM;
54: l_pull_sequence_rec.replenishment_lead_time := FND_API.G_MISS_NUM;
55:
56: l_pull_sequence_rec.release_kanban_flag := FND_API.G_MISS_NUM;
57: l_pull_sequence_rec.minimum_order_quantity := FND_API.G_MISS_NUM;
58: l_pull_sequence_rec.fixed_lot_multiplier := FND_API.G_MISS_NUM;
59: l_pull_sequence_rec.safety_stock_days := FND_API.G_MISS_NUM;
60: ELSE

Line 57: l_pull_sequence_rec.minimum_order_quantity := FND_API.G_MISS_NUM;

53: l_pull_sequence_rec.calculate_kanban_flag := FND_API.G_MISS_NUM;
54: l_pull_sequence_rec.replenishment_lead_time := FND_API.G_MISS_NUM;
55:
56: l_pull_sequence_rec.release_kanban_flag := FND_API.G_MISS_NUM;
57: l_pull_sequence_rec.minimum_order_quantity := FND_API.G_MISS_NUM;
58: l_pull_sequence_rec.fixed_lot_multiplier := FND_API.G_MISS_NUM;
59: l_pull_sequence_rec.safety_stock_days := FND_API.G_MISS_NUM;
60: ELSE
61: l_pull_sequence_rec.source_type := p_source_type;

Line 58: l_pull_sequence_rec.fixed_lot_multiplier := FND_API.G_MISS_NUM;

54: l_pull_sequence_rec.replenishment_lead_time := FND_API.G_MISS_NUM;
55:
56: l_pull_sequence_rec.release_kanban_flag := FND_API.G_MISS_NUM;
57: l_pull_sequence_rec.minimum_order_quantity := FND_API.G_MISS_NUM;
58: l_pull_sequence_rec.fixed_lot_multiplier := FND_API.G_MISS_NUM;
59: l_pull_sequence_rec.safety_stock_days := FND_API.G_MISS_NUM;
60: ELSE
61: l_pull_sequence_rec.source_type := p_source_type;
62: l_pull_sequence_rec.source_organization_id := p_source_organization_id;

Line 59: l_pull_sequence_rec.safety_stock_days := FND_API.G_MISS_NUM;

55:
56: l_pull_sequence_rec.release_kanban_flag := FND_API.G_MISS_NUM;
57: l_pull_sequence_rec.minimum_order_quantity := FND_API.G_MISS_NUM;
58: l_pull_sequence_rec.fixed_lot_multiplier := FND_API.G_MISS_NUM;
59: l_pull_sequence_rec.safety_stock_days := FND_API.G_MISS_NUM;
60: ELSE
61: l_pull_sequence_rec.source_type := p_source_type;
62: l_pull_sequence_rec.source_organization_id := p_source_organization_id;
63: l_pull_sequence_rec.source_subinventory := p_source_subinventory;

Line 83: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

79: l_pull_sequence_rec);
80:
81: x_return_status := l_return_status;
82:
83: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
84: RAISE FND_API.G_EXC_ERROR;
85: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
86: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
87: ELSE

Line 84: RAISE FND_API.G_EXC_ERROR;

80:
81: x_return_status := l_return_status;
82:
83: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
84: RAISE FND_API.G_EXC_ERROR;
85: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
86: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
87: ELSE
88: commit work;

Line 85: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

81: x_return_status := l_return_status;
82:
83: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
84: RAISE FND_API.G_EXC_ERROR;
85: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
86: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
87: ELSE
88: commit work;
89: END IF;

Line 86: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

82:
83: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
84: RAISE FND_API.G_EXC_ERROR;
85: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
86: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
87: ELSE
88: commit work;
89: END IF;
90:

Line 92: WHEN FND_API.G_EXC_ERROR THEN

88: commit work;
89: END IF;
90:
91: EXCEPTION
92: WHEN FND_API.G_EXC_ERROR THEN
93: FND_MSG_PUB.count_and_get
94: (p_count => x_msg_count,
95: p_data => x_msg_data );
96: WHEN OTHERS THEN

Line 114: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

110: INV_Kanban_PVT.delete_pull_sequence(l_return_status,
111: p_kanban_plan_id);
112: x_return_status := l_return_status;
113:
114: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
115: RAISE FND_API.G_EXC_ERROR;
116: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;

Line 115: RAISE FND_API.G_EXC_ERROR;

111: p_kanban_plan_id);
112: x_return_status := l_return_status;
113:
114: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
115: RAISE FND_API.G_EXC_ERROR;
116: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:

Line 116: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

112: x_return_status := l_return_status;
113:
114: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
115: RAISE FND_API.G_EXC_ERROR;
116: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:
120: EXCEPTION

Line 117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

113:
114: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
115: RAISE FND_API.G_EXC_ERROR;
116: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:
120: EXCEPTION
121: WHEN FND_API.G_EXC_ERROR THEN

Line 121: WHEN FND_API.G_EXC_ERROR THEN

117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:
120: EXCEPTION
121: WHEN FND_API.G_EXC_ERROR THEN
122: FND_MSG_PUB.count_and_get
123: (p_count => x_msg_count,
124: p_data => x_msg_data );
125: WHEN OTHERS THEN

Line 150: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

146: INV_Kanban_PVT.Insert_Pull_Sequence(l_return_status,l_pull_sequence_rec);
147:
148: x_return_status := l_return_status;
149:
150: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
151: RAISE FND_API.G_EXC_ERROR;
152: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: ELSE

Line 151: RAISE FND_API.G_EXC_ERROR;

147:
148: x_return_status := l_return_status;
149:
150: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
151: RAISE FND_API.G_EXC_ERROR;
152: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: ELSE
155: commit work;

Line 152: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

148: x_return_status := l_return_status;
149:
150: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
151: RAISE FND_API.G_EXC_ERROR;
152: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: ELSE
155: commit work;
156: END IF;

Line 153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

149:
150: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
151: RAISE FND_API.G_EXC_ERROR;
152: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: ELSE
155: commit work;
156: END IF;
157:

Line 159: WHEN FND_API.G_EXC_ERROR THEN

155: commit work;
156: END IF;
157:
158: EXCEPTION
159: WHEN FND_API.G_EXC_ERROR THEN
160: FND_MSG_PUB.count_and_get
161: (p_count => x_msg_count,
162: p_data => x_msg_data );
163: WHEN OTHERS THEN

Line 224: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

220: WHERE pull_sequence_id = l_prod_pull_sequence_id;
221: end if;
222: if( (l_flag=l_delplanprodcards ) or ( l_flag = l_delplanprod) ) then -- Delete Production
223: INV_pullsequence_PKG.delete_row(l_return_status,l_prod_pull_sequence_id);
224: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
225: RAISE FND_API.G_EXC_ERROR;
226: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: END IF;

Line 225: RAISE FND_API.G_EXC_ERROR;

221: end if;
222: if( (l_flag=l_delplanprodcards ) or ( l_flag = l_delplanprod) ) then -- Delete Production
223: INV_pullsequence_PKG.delete_row(l_return_status,l_prod_pull_sequence_id);
224: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
225: RAISE FND_API.G_EXC_ERROR;
226: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: END IF;
229:

Line 226: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

222: if( (l_flag=l_delplanprodcards ) or ( l_flag = l_delplanprod) ) then -- Delete Production
223: INV_pullsequence_PKG.delete_row(l_return_status,l_prod_pull_sequence_id);
224: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
225: RAISE FND_API.G_EXC_ERROR;
226: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: END IF;
229:
230: end if;

Line 227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

223: INV_pullsequence_PKG.delete_row(l_return_status,l_prod_pull_sequence_id);
224: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
225: RAISE FND_API.G_EXC_ERROR;
226: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: END IF;
229:
230: end if;
231: -- Delete planning pull sequence

Line 234: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

230: end if;
231: -- Delete planning pull sequence
232:
233: INV_pullsequence_pkg.delete_row(l_return_status,l_pull_seq_id);
234: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
235: RAISE FND_API.G_EXC_ERROR;
236: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
238: END IF;

Line 235: RAISE FND_API.G_EXC_ERROR;

231: -- Delete planning pull sequence
232:
233: INV_pullsequence_pkg.delete_row(l_return_status,l_pull_seq_id);
234: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
235: RAISE FND_API.G_EXC_ERROR;
236: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
238: END IF;
239: commit; --The above procedure does not do a commit ,so we add it here

Line 236: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

232:
233: INV_pullsequence_pkg.delete_row(l_return_status,l_pull_seq_id);
234: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
235: RAISE FND_API.G_EXC_ERROR;
236: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
238: END IF;
239: commit; --The above procedure does not do a commit ,so we add it here
240: end if;

Line 237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

233: INV_pullsequence_pkg.delete_row(l_return_status,l_pull_seq_id);
234: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
235: RAISE FND_API.G_EXC_ERROR;
236: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
238: END IF;
239: commit; --The above procedure does not do a commit ,so we add it here
240: end if;
241:

Line 253: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

249: l_operation_tbl);
250:
251: x_return_status := l_return_status;
252:
253: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
254: RAISE FND_API.G_EXC_ERROR;
255: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: ELSE

Line 254: RAISE FND_API.G_EXC_ERROR;

250:
251: x_return_status := l_return_status;
252:
253: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
254: RAISE FND_API.G_EXC_ERROR;
255: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: ELSE
258:

Line 255: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

251: x_return_status := l_return_status;
252:
253: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
254: RAISE FND_API.G_EXC_ERROR;
255: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: ELSE
258:
259: DELETE FROM mrp_form_query

Line 256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

252:
253: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
254: RAISE FND_API.G_EXC_ERROR;
255: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: ELSE
258:
259: DELETE FROM mrp_form_query
260: WHERE query_id = p_query_id;

Line 266: WHEN FND_API.G_EXC_ERROR THEN

262: COMMIT WORK;
263: END IF;
264:
265: EXCEPTION
266: WHEN FND_API.G_EXC_ERROR THEN
267: FND_MSG_PUB.count_and_get
268: (p_count => x_msg_count,
269: p_data => x_msg_data );
270: WHEN OTHERS THEN