DBA Data[Home] [Help]

APPS.WMS_CROSSDOCK_GRP dependencies on FND_API

Line 54: x_return_status := fnd_api.g_ret_sts_success;

50:
51: BEGIN
52: l_api_name := 'validate_planxdock_crt_id';
53: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
54: x_return_status := fnd_api.g_ret_sts_success;
55:
56: print_version_info;
57:
58: IF l_debug = 1 THEN

Line 76: RAISE fnd_api.g_exc_error;

72: print_debug('Criterion ID not found', l_api_name);
73: END IF;
74: fnd_message.set_name('WMS', 'WMS_XDCRT_INVLD_PLAN_CRT');
75: fnd_msg_pub.ADD;
76: RAISE fnd_api.g_exc_error;
77: END IF;
78:
79: CLOSE c_check_if_planned_criterion;
80:

Line 82: WHEN fnd_api.g_exc_error THEN

78:
79: CLOSE c_check_if_planned_criterion;
80:
81: EXCEPTION
82: WHEN fnd_api.g_exc_error THEN
83: x_return_status := fnd_api.g_ret_sts_error;
84:
85: IF c_check_if_planned_criterion%ISOPEN THEN
86: CLOSE c_check_if_planned_criterion;

Line 83: x_return_status := fnd_api.g_ret_sts_error;

79: CLOSE c_check_if_planned_criterion;
80:
81: EXCEPTION
82: WHEN fnd_api.g_exc_error THEN
83: x_return_status := fnd_api.g_ret_sts_error;
84:
85: IF c_check_if_planned_criterion%ISOPEN THEN
86: CLOSE c_check_if_planned_criterion;
87: END IF;

Line 92: , p_encoded => fnd_api.g_false

88:
89: fnd_msg_pub.count_and_get
90: ( p_count => l_msg_count
91: , p_data => l_msg_data
92: , p_encoded => fnd_api.g_false
93: );
94:
95: IF l_debug = 1 THEN
96: print_debug (l_msg_data, l_api_name);

Line 100: x_return_status := fnd_api.g_ret_sts_unexp_error;

96: print_debug (l_msg_data, l_api_name);
97: END IF;
98:
99: WHEN OTHERS THEN
100: x_return_status := fnd_api.g_ret_sts_unexp_error;
101:
102: IF c_check_if_planned_criterion%ISOPEN THEN
103: CLOSE c_check_if_planned_criterion;
104: END IF;

Line 147: x_return_status := fnd_api.g_ret_sts_success;

143:
144: BEGIN
145: l_api_name := 'chk_planxd_crt_id_name';
146: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
147: x_return_status := fnd_api.g_ret_sts_success;
148:
149: print_version_info;
150:
151: IF l_debug = 1 THEN

Line 171: RAISE fnd_api.g_exc_error;

167: print_debug('Criterion ID not found', l_api_name);
168: END IF;
169: fnd_message.set_name('WMS', 'WMS_XDCRT_INVLD_PLAN_CRT');
170: fnd_msg_pub.ADD;
171: RAISE fnd_api.g_exc_error;
172: END IF;
173: CLOSE c_get_plan_crt_name;
174: p_criterion_name := l_crt_name;
175: ELSIF p_criterion_name IS NOT NULL

Line 186: RAISE fnd_api.g_exc_error;

182: print_debug('Criterion name not found', l_api_name);
183: END IF;
184: fnd_message.set_name('WMS', 'WMS_XDCRT_INVLD_PLAN_CRT');
185: fnd_msg_pub.ADD;
186: RAISE fnd_api.g_exc_error;
187: END IF;
188: CLOSE c_get_plan_crt_id;
189: p_criterion_id := l_crt_id;
190: END IF;

Line 193: WHEN fnd_api.g_exc_error THEN

189: p_criterion_id := l_crt_id;
190: END IF;
191:
192: EXCEPTION
193: WHEN fnd_api.g_exc_error THEN
194: x_return_status := fnd_api.g_ret_sts_error;
195:
196: IF c_get_plan_crt_name%ISOPEN THEN
197: CLOSE c_get_plan_crt_name;

Line 194: x_return_status := fnd_api.g_ret_sts_error;

190: END IF;
191:
192: EXCEPTION
193: WHEN fnd_api.g_exc_error THEN
194: x_return_status := fnd_api.g_ret_sts_error;
195:
196: IF c_get_plan_crt_name%ISOPEN THEN
197: CLOSE c_get_plan_crt_name;
198: END IF;

Line 207: , p_encoded => fnd_api.g_false

203:
204: fnd_msg_pub.count_and_get
205: ( p_count => l_msg_count
206: , p_data => l_msg_data
207: , p_encoded => fnd_api.g_false
208: );
209:
210: IF l_debug = 1 THEN
211: print_debug (l_msg_data, l_api_name);

Line 215: x_return_status := fnd_api.g_ret_sts_unexp_error;

211: print_debug (l_msg_data, l_api_name);
212: END IF;
213:
214: WHEN OTHERS THEN
215: x_return_status := fnd_api.g_ret_sts_unexp_error;
216:
217: IF c_get_plan_crt_name%ISOPEN THEN
218: CLOSE c_get_plan_crt_name;
219: END IF;

Line 262: x_return_status := fnd_api.g_ret_sts_success;

258:
259: BEGIN
260: l_api_name := 'chk_mo_type';
261: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
262: x_return_status := fnd_api.g_ret_sts_success;
263:
264: print_version_info;
265:
266: IF l_debug = 1 THEN

Line 277: RAISE fnd_api.g_exc_unexpected_error;

273:
274: IF p_mo_line_id IS NULL
275: THEN
276: print_debug('MO line ID is null!', l_api_name);
277: RAISE fnd_api.g_exc_unexpected_error;
278: END IF;
279:
280: OPEN c_get_mo_header_info(p_mo_line_id);
281: FETCH c_get_mo_header_info INTO l_mo_header_id,l_mo_type;

Line 289: RAISE fnd_api.g_exc_error;

285: print_debug('MO line ID not found', l_api_name);
286: END IF;
287: fnd_message.set_name('WMS', 'WMS_MOL_NOT_FOUND');
288: fnd_msg_pub.ADD;
289: RAISE fnd_api.g_exc_error;
290: END IF;
291: CLOSE c_get_mo_header_info;
292:
293: x_mo_header_id := l_mo_header_id;

Line 303: WHEN fnd_api.g_exc_error THEN

299: x_is_putaway_mo := 'N';
300: END IF;
301:
302: EXCEPTION
303: WHEN fnd_api.g_exc_error THEN
304: x_return_status := fnd_api.g_ret_sts_error;
305:
306: IF c_get_mo_header_info%ISOPEN THEN
307: CLOSE c_get_mo_header_info;

Line 304: x_return_status := fnd_api.g_ret_sts_error;

300: END IF;
301:
302: EXCEPTION
303: WHEN fnd_api.g_exc_error THEN
304: x_return_status := fnd_api.g_ret_sts_error;
305:
306: IF c_get_mo_header_info%ISOPEN THEN
307: CLOSE c_get_mo_header_info;
308: END IF;

Line 313: , p_encoded => fnd_api.g_false

309:
310: fnd_msg_pub.count_and_get
311: ( p_count => l_msg_count
312: , p_data => l_msg_data
313: , p_encoded => fnd_api.g_false
314: );
315:
316: IF l_debug = 1 THEN
317: print_debug (l_msg_data, l_api_name);

Line 321: x_return_status := fnd_api.g_ret_sts_unexp_error;

317: print_debug (l_msg_data, l_api_name);
318: END IF;
319:
320: WHEN OTHERS THEN
321: x_return_status := fnd_api.g_ret_sts_unexp_error;
322:
323: IF c_get_mo_header_info%ISOPEN THEN
324: CLOSE c_get_mo_header_info;
325: END IF;