APPS.OE_ADV_ITEM_SEARCH_PVT dependencies on FND_API

Line 67: ( p_validation_level => fnd_api.g_valid_level_none

63:
64: IF l_index > 1 THEN
65:
66: oe_order_pvt.lines
67: ( p_validation_level => fnd_api.g_valid_level_none
68: , p_control_rec => l_control_rec
69: , p_x_line_tbl => l_line_tbl
70: , p_x_old_line_tbl => l_old_line_tbl
71: , x_return_status => l_return_status );

Line 76: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

72:
73:
74: oe_debug_pub.add('After call to Lines Procedure : ' || l_return_status, 1 );
75:
76: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
78: END IF;
79:
80: OE_ORDER_PVT.Process_Requests_And_notify

Line 77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

73:
74: oe_debug_pub.add('After call to Lines Procedure : ' || l_return_status, 1 );
75:
76: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
78: END IF;
79:
80: OE_ORDER_PVT.Process_Requests_And_notify
81: ( p_process_requests => TRUE

Line 90: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

86:
87:
88: oe_debug_pub.add('After call to Process Request Notify : ' || l_return_status, 1 );
89:
90: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
93: RAISE FND_API.G_EXC_ERROR;
94: END IF;

Line 91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

87:
88: oe_debug_pub.add('After call to Process Request Notify : ' || l_return_status, 1 );
89:
90: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
93: RAISE FND_API.G_EXC_ERROR;
94: END IF;
95:

Line 92: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

88: oe_debug_pub.add('After call to Process Request Notify : ' || l_return_status, 1 );
89:
90: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
93: RAISE FND_API.G_EXC_ERROR;
94: END IF;
95:
96: --Now the call goes back to the pld and needs to be handled.

Line 93: RAISE FND_API.G_EXC_ERROR;

89:
90: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
93: RAISE FND_API.G_EXC_ERROR;
94: END IF;
95:
96: --Now the call goes back to the pld and needs to be handled.
97:

Line 124: WHEN FND_API.G_EXC_ERROR THEN

120: oe_debug_pub.add('Leaving Create_Items_Selected : ' || l_return_status, 1 );
121:
122: EXCEPTION
123:
124: WHEN FND_API.G_EXC_ERROR THEN
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: oe_msg_pub.count_and_get
127: ( p_count => x_msg_count
128: , p_data => x_msg_data);

Line 125: x_return_status := FND_API.G_RET_STS_ERROR;

121:
122: EXCEPTION
123:
124: WHEN FND_API.G_EXC_ERROR THEN
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: oe_msg_pub.count_and_get
127: ( p_count => x_msg_count
128: , p_data => x_msg_data);
129:

Line 130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

126: oe_msg_pub.count_and_get
127: ( p_count => x_msg_count
128: , p_data => x_msg_data);
129:
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
132: oe_msg_pub.count_and_get
133: ( p_count => x_msg_count
134: , p_data => x_msg_data);

Line 131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

127: ( p_count => x_msg_count
128: , p_data => x_msg_data);
129:
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
132: oe_msg_pub.count_and_get
133: ( p_count => x_msg_count
134: , p_data => x_msg_data);
135:

Line 137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

133: ( p_count => x_msg_count
134: , p_data => x_msg_data);
135:
136: WHEN OTHERS THEN
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
138: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
139: oe_msg_pub.Add_Exc_Msg
140: ( G_PKG_NAME
141: , 'Create_Items_Selected' );