DBA Data[Home] [Help]

APPS.AMW_RISK_TYPE_PVT dependencies on AMW_RISK_TYPE_PVT

Line 1: PACKAGE BODY AMW_risk_type_PVT AS

1: PACKAGE BODY AMW_risk_type_PVT AS
2: /* $Header: amwvmrtb.pls 120.0 2005/05/31 21:25:10 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMW_RISK_TYPE_PVT

2: /* $Header: amwvmrtb.pls 120.0 2005/05/31 21:25:10 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMW_RISK_TYPE_PVT
7: -- End of Comments
8: -- ===============================================================
9: g_pkg_name CONSTANT VARCHAR2 (30) := 'AMW_RISK_TYPE_PVT';
10: g_file_name CONSTANT VARCHAR2 (12) := 'amwvrtpb.pls';

Line 9: g_pkg_name CONSTANT VARCHAR2 (30) := 'AMW_RISK_TYPE_PVT';

5: -- Package name
6: -- AMW_RISK_TYPE_PVT
7: -- End of Comments
8: -- ===============================================================
9: g_pkg_name CONSTANT VARCHAR2 (30) := 'AMW_RISK_TYPE_PVT';
10: g_file_name CONSTANT VARCHAR2 (12) := 'amwvrtpb.pls';
11: g_user_id NUMBER := fnd_global.user_id;
12: g_login_id NUMBER := fnd_global.conc_login_id;
13: --------------------- BEGIN: Declaring internal Procedures ----------------------

Line 76: SAVEPOINT amw_risk_type_pvt;

72: and risk_type_code = p_risk_type_code);
73:
74: BEGIN
75:
76: SAVEPOINT amw_risk_type_pvt;
77: x_return_status := fnd_api.g_ret_sts_success;
78: -- Standard call to check for call compatibility.
79: IF NOT fnd_api.compatible_api_call (l_api_version_number,
80: p_api_version_number,

Line 169: ROLLBACK TO amw_risk_type_pvt;

165: -- Standard call to get message count and if count is 1, get message info.
166: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
167: EXCEPTION
168: WHEN fnd_api.g_exc_error THEN
169: ROLLBACK TO amw_risk_type_pvt;
170: x_return_status := fnd_api.g_ret_sts_error;
171: -- Standard call to get message count and if count=1, get the message
172: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
173: p_count => x_msg_count,

Line 177: ROLLBACK TO amw_risk_type_pvt;

173: p_count => x_msg_count,
174: p_data => x_msg_data
175: );
176: WHEN fnd_api.g_exc_unexpected_error THEN
177: ROLLBACK TO amw_risk_type_pvt;
178: x_return_status := fnd_api.g_ret_sts_unexp_error;
179: -- Standard call to get message count and if count=1, get the message
180: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
181: p_count => x_msg_count,

Line 185: ROLLBACK TO amw_risk_type_pvt;

181: p_count => x_msg_count,
182: p_data => x_msg_data
183: );
184: WHEN OTHERS THEN
185: ROLLBACK TO amw_risk_type_pvt;
186: x_return_status := fnd_api.g_ret_sts_unexp_error;
187: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
188: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
189: END IF;

Line 311: END amw_risk_type_pvt;

307:
308: END Revise_Risk_Type;
309:
310:
311: END amw_risk_type_pvt;