DBA Data[Home] [Help]

APPS.ASO_IBY_FINANCE_CALLBACK dependencies on FND_API

Line 16: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

12: g_login_id NUMBER := fnd_global.conc_login_id;
13:
14: PROCEDURE update_status (
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
17: p_commit IN VARCHAR2 := fnd_api.g_false,
18: p_validation_level IN NUMBER := fnd_api.g_miss_num,
19: p_tangible_id IN NUMBER,
20: p_credit_app_id IN NUMBER,

Line 17: p_commit IN VARCHAR2 := fnd_api.g_false,

13:
14: PROCEDURE update_status (
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
17: p_commit IN VARCHAR2 := fnd_api.g_false,
18: p_validation_level IN NUMBER := fnd_api.g_miss_num,
19: p_tangible_id IN NUMBER,
20: p_credit_app_id IN NUMBER,
21: p_new_status_category IN VARCHAR2,

Line 18: p_validation_level IN NUMBER := fnd_api.g_miss_num,

14: PROCEDURE update_status (
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
17: p_commit IN VARCHAR2 := fnd_api.g_false,
18: p_validation_level IN NUMBER := fnd_api.g_miss_num,
19: p_tangible_id IN NUMBER,
20: p_credit_app_id IN NUMBER,
21: p_new_status_category IN VARCHAR2,
22: p_new_status IN VARCHAR2,

Line 23: p_last_update_date IN DATE := fnd_api.g_miss_date,

19: p_tangible_id IN NUMBER,
20: p_credit_app_id IN NUMBER,
21: p_new_status_category IN VARCHAR2,
22: p_new_status IN VARCHAR2,
23: p_last_update_date IN DATE := fnd_api.g_miss_date,
24: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
25: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
26: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
27: ) IS

Line 35: IF NOT fnd_api.compatible_api_call (

31: -- Standard Start of API savepoint
32: SAVEPOINT update_status_pub;
33:
34: -- Standard call to check for call compatibility.
35: IF NOT fnd_api.compatible_api_call (
36: l_api_version,
37: p_api_version,
38: l_api_name,
39: g_pkg_name

Line 42: RAISE fnd_api.g_exc_unexpected_error;

38: l_api_name,
39: g_pkg_name
40: )
41: THEN
42: RAISE fnd_api.g_exc_unexpected_error;
43: END IF;
44:
45: -- Initialize message list if p_init_msg_list is set to TRUE.
46: IF fnd_api.to_boolean (

Line 46: IF fnd_api.to_boolean (

42: RAISE fnd_api.g_exc_unexpected_error;
43: END IF;
44:
45: -- Initialize message list if p_init_msg_list is set to TRUE.
46: IF fnd_api.to_boolean (
47: p_init_msg_list
48: )
49: THEN
50: fnd_msg_pub.initialize;

Line 54: x_return_status := fnd_api.g_ret_sts_success;

50: fnd_msg_pub.initialize;
51: END IF;
52:
53: -- Initialize API return status to SUCCESS
54: x_return_status := fnd_api.g_ret_sts_success;
55: --
56: -- API body
57: --
58:

Line 84: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)

80: 'Y'
81: );
82: END IF;
83:
84: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
85: THEN
86: RAISE fnd_api.g_exc_unexpected_error;
87: ELSIF (x_return_status = fnd_api.g_ret_sts_error)
88: THEN

Line 86: RAISE fnd_api.g_exc_unexpected_error;

82: END IF;
83:
84: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
85: THEN
86: RAISE fnd_api.g_exc_unexpected_error;
87: ELSIF (x_return_status = fnd_api.g_ret_sts_error)
88: THEN
89: RAISE fnd_api.g_exc_error;
90: END IF;

Line 87: ELSIF (x_return_status = fnd_api.g_ret_sts_error)

83:
84: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
85: THEN
86: RAISE fnd_api.g_exc_unexpected_error;
87: ELSIF (x_return_status = fnd_api.g_ret_sts_error)
88: THEN
89: RAISE fnd_api.g_exc_error;
90: END IF;
91:

Line 89: RAISE fnd_api.g_exc_error;

85: THEN
86: RAISE fnd_api.g_exc_unexpected_error;
87: ELSIF (x_return_status = fnd_api.g_ret_sts_error)
88: THEN
89: RAISE fnd_api.g_exc_error;
90: END IF;
91:
92: --
93: -- End of API body.

Line 97: IF fnd_api.to_boolean (

93: -- End of API body.
94: --
95:
96: -- Standard check for p_commit
97: IF fnd_api.to_boolean (
98: p_commit
99: )
100: THEN
101: COMMIT WORK;

Line 115: WHEN fnd_api.g_exc_error

111: p_count => x_msg_count,
112: p_data => x_msg_data
113: );
114: EXCEPTION
115: WHEN fnd_api.g_exc_error
116: THEN
117: aso_utility_pvt.handle_exceptions (
118: p_api_name => l_api_name,
119: p_pkg_name => g_pkg_name,

Line 126: WHEN fnd_api.g_exc_unexpected_error

122: x_msg_count => x_msg_count,
123: x_msg_data => x_msg_data,
124: x_return_status => x_return_status
125: );
126: WHEN fnd_api.g_exc_unexpected_error
127: THEN
128: aso_utility_pvt.handle_exceptions (
129: p_api_name => l_api_name,
130: p_pkg_name => g_pkg_name,