DBA Data[Home] [Help]

APPS.POS_BUSINESS_CLASS_BO_PKG dependencies on FND_API

Line 18: x_return_status := fnd_api.g_ret_sts_success;

14: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_VENDOR_BUSS_CLASS';
15: l_request_id NUMBER := fnd_global.conc_request_id;
16: BEGIN
17: -- Initialize API return status to success
18: x_return_status := fnd_api.g_ret_sts_success;
19:
20: x_buss_valid := 'Y';
21:
22: -- Validate the classifcation using the following query

Line 36: x_return_status := fnd_api.g_ret_sts_error;

32:
33: EXCEPTION
34: WHEN OTHERS THEN
35: x_buss_valid := 'N';
36: x_return_status := fnd_api.g_ret_sts_error;
37: x_msg_data := 'AP_INVALID_BUSS_CLASS';
38: RETURN;
39: END;
40:

Line 55: x_return_status := fnd_api.g_ret_sts_error;

51:
52: EXCEPTION
53: WHEN OTHERS THEN
54: x_buss_valid := 'N';
55: x_return_status := fnd_api.g_ret_sts_error;
56: x_msg_data := 'AP_INVALID_BUSS_CLASS';
57: RETURN;
58: END;
59: END IF;

Line 63: x_return_status := fnd_api.g_ret_sts_unexp_error;

59: END IF;
60: EXCEPTION
61: WHEN OTHERS THEN
62: x_buss_valid := 'N';
63: x_return_status := fnd_api.g_ret_sts_unexp_error;
64:
65: fnd_msg_pub.count_and_get(p_count => x_msg_count,
66: p_data => x_msg_data);
67: END validate_vendor_buss_class;

Line 135: WHEN fnd_api.g_exc_error THEN

131:
132: x_pos_bus_class_bo_tbl := l_pos_bus_class_bo_tbl;
133:
134: EXCEPTION
135: WHEN fnd_api.g_exc_error THEN
136: x_return_status := fnd_api.g_ret_sts_error;
137: x_msg_count := 1;
138: x_msg_data := SQLCODE || SQLERRM;
139: WHEN fnd_api.g_exc_unexpected_error THEN

Line 136: x_return_status := fnd_api.g_ret_sts_error;

132: x_pos_bus_class_bo_tbl := l_pos_bus_class_bo_tbl;
133:
134: EXCEPTION
135: WHEN fnd_api.g_exc_error THEN
136: x_return_status := fnd_api.g_ret_sts_error;
137: x_msg_count := 1;
138: x_msg_data := SQLCODE || SQLERRM;
139: WHEN fnd_api.g_exc_unexpected_error THEN
140: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 139: WHEN fnd_api.g_exc_unexpected_error THEN

135: WHEN fnd_api.g_exc_error THEN
136: x_return_status := fnd_api.g_ret_sts_error;
137: x_msg_count := 1;
138: x_msg_data := SQLCODE || SQLERRM;
139: WHEN fnd_api.g_exc_unexpected_error THEN
140: x_return_status := fnd_api.g_ret_sts_unexp_error;
141: x_msg_count := 1;
142: x_msg_data := SQLCODE || SQLERRM;
143: WHEN OTHERS THEN

Line 140: x_return_status := fnd_api.g_ret_sts_unexp_error;

136: x_return_status := fnd_api.g_ret_sts_error;
137: x_msg_count := 1;
138: x_msg_data := SQLCODE || SQLERRM;
139: WHEN fnd_api.g_exc_unexpected_error THEN
140: x_return_status := fnd_api.g_ret_sts_unexp_error;
141: x_msg_count := 1;
142: x_msg_data := SQLCODE || SQLERRM;
143: WHEN OTHERS THEN
144: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 144: x_return_status := fnd_api.g_ret_sts_unexp_error;

140: x_return_status := fnd_api.g_ret_sts_unexp_error;
141: x_msg_count := 1;
142: x_msg_data := SQLCODE || SQLERRM;
143: WHEN OTHERS THEN
144: x_return_status := fnd_api.g_ret_sts_unexp_error;
145: x_msg_count := 1;
146: x_msg_data := SQLCODE || SQLERRM;
147: END get_pos_business_class_bo_tbl;
148: /*#

Line 339: WHEN fnd_api.g_exc_error THEN

335: END LOOP;
336: --end update
337:
338: EXCEPTION
339: WHEN fnd_api.g_exc_error THEN
340:
341: x_return_status := fnd_api.g_ret_sts_error;
342: x_msg_count := 1;
343: x_msg_data := SQLCODE || SQLERRM;

Line 341: x_return_status := fnd_api.g_ret_sts_error;

337:
338: EXCEPTION
339: WHEN fnd_api.g_exc_error THEN
340:
341: x_return_status := fnd_api.g_ret_sts_error;
342: x_msg_count := 1;
343: x_msg_data := SQLCODE || SQLERRM;
344: WHEN fnd_api.g_exc_unexpected_error THEN
345:

Line 344: WHEN fnd_api.g_exc_unexpected_error THEN

340:
341: x_return_status := fnd_api.g_ret_sts_error;
342: x_msg_count := 1;
343: x_msg_data := SQLCODE || SQLERRM;
344: WHEN fnd_api.g_exc_unexpected_error THEN
345:
346: x_return_status := fnd_api.g_ret_sts_unexp_error;
347: x_msg_count := 1;
348: x_msg_data := SQLCODE || SQLERRM;

Line 346: x_return_status := fnd_api.g_ret_sts_unexp_error;

342: x_msg_count := 1;
343: x_msg_data := SQLCODE || SQLERRM;
344: WHEN fnd_api.g_exc_unexpected_error THEN
345:
346: x_return_status := fnd_api.g_ret_sts_unexp_error;
347: x_msg_count := 1;
348: x_msg_data := SQLCODE || SQLERRM;
349: WHEN OTHERS THEN
350:

Line 351: x_return_status := fnd_api.g_ret_sts_unexp_error;

347: x_msg_count := 1;
348: x_msg_data := SQLCODE || SQLERRM;
349: WHEN OTHERS THEN
350:
351: x_return_status := fnd_api.g_ret_sts_unexp_error;
352:
353: x_msg_count := 1;
354: x_msg_data := SQLCODE || SQLERRM;
355: END create_bus_class_attr;