APPS.PN_VRA_CLIENT_EXTN dependencies on FND_API

Line 57: x_return_status := fnd_api.g_ret_sts_success;

53: || '.'
54: || l_api_name;
55: BEGIN
56: SAVEPOINT calculate_override;
57: x_return_status := fnd_api.g_ret_sts_success;
58:
59: IF NVL (mo_global.check_valid_org (g_org_id)
60: , 'N'
61: ) <> 'Y'

Line 67: RAISE fnd_api.g_exc_error;

63: fnd_message.set_name ('MO'
64: , 'MO_ORG_INVALID'
65: );
66: fnd_msg_pub.ADD;
67: RAISE fnd_api.g_exc_error;
68: END IF;
69:
70: --- Verifying whether the VRA from exists or not.
71: IF fnd_function.TEST (function_name => g_fun_name)

Line 82: RAISE fnd_api.g_exc_error;

78: fnd_message.set_name ('PN'
79: , 'PN_FUNCTION_SECURITY'
80: );
81: fnd_msg_pub.ADD;
82: RAISE fnd_api.g_exc_error;
83: END IF;
84: pnp_debug_pkg.LOG ( l_api_name_full
85: || ' Before Calculations ----- : ');
86: pnp_debug_pkg.LOG ( l_api_name_full

Line 136: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false

132: pnp_debug_pkg.LOG ( l_api_name_full
133: || ' p_first_yr_rent : '
134: || p_first_yr_rent);
135:
136: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
137: , p_count => x_msg_count
138: , p_data => x_msg_data
139: );
140: EXCEPTION

Line 141: WHEN fnd_api.g_exc_error

137: , p_count => x_msg_count
138: , p_data => x_msg_data
139: );
140: EXCEPTION
141: WHEN fnd_api.g_exc_error
142: THEN
143: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
144: , p_count => x_msg_count
145: , p_data => x_msg_data

Line 143: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false

139: );
140: EXCEPTION
141: WHEN fnd_api.g_exc_error
142: THEN
143: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
144: , p_count => x_msg_count
145: , p_data => x_msg_data
146: );
147: x_return_status := fnd_api.g_ret_sts_error;

Line 147: x_return_status := fnd_api.g_ret_sts_error;

143: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
144: , p_count => x_msg_count
145: , p_data => x_msg_data
146: );
147: x_return_status := fnd_api.g_ret_sts_error;
148: pnp_debug_pkg.LOG ( l_api_name_full||' : '||'Exception : '
149: || SQLERRM
150: );
151: pnp_debug_pkg.LOG ( l_api_name_full||' : '||'Return Status : '

Line 158: WHEN fnd_api.g_exc_unexpected_error

154: pnp_debug_pkg.LOG ( l_api_name_full||' : '||'No of Error Messages : '
155: || x_msg_count
156: );
157:
158: WHEN fnd_api.g_exc_unexpected_error
159: THEN
160: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
161: , p_count => x_msg_count
162: , p_data => x_msg_data

Line 160: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false

156: );
157:
158: WHEN fnd_api.g_exc_unexpected_error
159: THEN
160: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
161: , p_count => x_msg_count
162: , p_data => x_msg_data
163: );
164: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 164: x_return_status := fnd_api.g_ret_sts_unexp_error;

160: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
161: , p_count => x_msg_count
162: , p_data => x_msg_data
163: );
164: x_return_status := fnd_api.g_ret_sts_unexp_error;
165: pnp_debug_pkg.LOG ( l_api_name_full||' : '|| 'Unexpected Exception : '
166: || SQLERRM
167: );
168: pnp_debug_pkg.LOG ( l_api_name_full||' : '||'Return Status : '

Line 176: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false

172: || x_msg_count
173: );
174: WHEN OTHERS
175: THEN
176: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
177: , p_count => x_msg_count
178: , p_data => x_msg_data
179: );
180: x_return_status := fnd_api.g_ret_sts_error;

Line 180: x_return_status := fnd_api.g_ret_sts_error;

176: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
177: , p_count => x_msg_count
178: , p_data => x_msg_data
179: );
180: x_return_status := fnd_api.g_ret_sts_error;
181: pnp_debug_pkg.LOG ( l_api_name_full||' : '||'Others Exception : '
182: || SQLERRM
183: );
184: pnp_debug_pkg.LOG ( l_api_name_full||' : '||'Return Status : '