APPS.CSP_PP_UTIL dependencies on FND_API

Line 31: x_return_status := fnd_api.g_ret_sts_success;

27: l_rowid VARCHAR2(20);
28: BEGIN
29:
30: -- Initialisize API return status to access
31: x_return_status := fnd_api.g_ret_sts_success;
32: IF p_mtlt_tbl_size IS NULL OR p_mtlt_tbl_size < 1 THEN
33: RETURN;
34: END IF;
35: --

Line 87: when fnd_api.g_exc_error then

83: );
84: END LOOP;
85: --
86: EXCEPTION
87: when fnd_api.g_exc_error then
88: x_return_status := fnd_api.g_ret_sts_error;
89: --
90: when fnd_api.g_exc_unexpected_error then
91: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 88: x_return_status := fnd_api.g_ret_sts_error;

84: END LOOP;
85: --
86: EXCEPTION
87: when fnd_api.g_exc_error then
88: x_return_status := fnd_api.g_ret_sts_error;
89: --
90: when fnd_api.g_exc_unexpected_error then
91: x_return_status := fnd_api.g_ret_sts_unexp_error;
92: --

Line 90: when fnd_api.g_exc_unexpected_error then

86: EXCEPTION
87: when fnd_api.g_exc_error then
88: x_return_status := fnd_api.g_ret_sts_error;
89: --
90: when fnd_api.g_exc_unexpected_error then
91: x_return_status := fnd_api.g_ret_sts_unexp_error;
92: --
93: when others then
94: --

Line 91: x_return_status := fnd_api.g_ret_sts_unexp_error;

87: when fnd_api.g_exc_error then
88: x_return_status := fnd_api.g_ret_sts_error;
89: --
90: when fnd_api.g_exc_unexpected_error then
91: x_return_status := fnd_api.g_ret_sts_unexp_error;
92: --
93: when others then
94: --
95: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 95: x_return_status := fnd_api.g_ret_sts_unexp_error;

91: x_return_status := fnd_api.g_ret_sts_unexp_error;
92: --
93: when others then
94: --
95: x_return_status := fnd_api.g_ret_sts_unexp_error;
96: /*if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) then
97: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
98: end if;*/
99: --

Line 118: x_return_status := fnd_api.g_ret_sts_success;

114: l_rowid VARCHAR2(20);
115: BEGIN
116: --
117: -- Initialisize API return status to access
118: x_return_status := fnd_api.g_ret_sts_success;
119: IF p_msnt_tbl_size IS NULL OR p_msnt_tbl_size < 1 THEN
120: RETURN;
121: END IF;
122: --

Line 175: when fnd_api.g_exc_error then

171:
172: END LOOP;
173:
174: EXCEPTION
175: when fnd_api.g_exc_error then
176: x_return_status := fnd_api.g_ret_sts_error;
177: --
178: when fnd_api.g_exc_unexpected_error then
179: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 176: x_return_status := fnd_api.g_ret_sts_error;

172: END LOOP;
173:
174: EXCEPTION
175: when fnd_api.g_exc_error then
176: x_return_status := fnd_api.g_ret_sts_error;
177: --
178: when fnd_api.g_exc_unexpected_error then
179: x_return_status := fnd_api.g_ret_sts_unexp_error;
180: --

Line 178: when fnd_api.g_exc_unexpected_error then

174: EXCEPTION
175: when fnd_api.g_exc_error then
176: x_return_status := fnd_api.g_ret_sts_error;
177: --
178: when fnd_api.g_exc_unexpected_error then
179: x_return_status := fnd_api.g_ret_sts_unexp_error;
180: --
181: when others then
182: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 179: x_return_status := fnd_api.g_ret_sts_unexp_error;

175: when fnd_api.g_exc_error then
176: x_return_status := fnd_api.g_ret_sts_error;
177: --
178: when fnd_api.g_exc_unexpected_error then
179: x_return_status := fnd_api.g_ret_sts_unexp_error;
180: --
181: when others then
182: x_return_status := fnd_api.g_ret_sts_unexp_error;
183:

Line 182: x_return_status := fnd_api.g_ret_sts_unexp_error;

178: when fnd_api.g_exc_unexpected_error then
179: x_return_status := fnd_api.g_ret_sts_unexp_error;
180: --
181: when others then
182: x_return_status := fnd_api.g_ret_sts_unexp_error;
183:
184: END insert_msnt;
185: --
186: -- Start of comments