eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_SALES_METHODOLOGY_PVT dependencies on FND_API

Line 8: P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,

4:
5: Procedure CREATE_SALES_METHODOLOGY
6: (
7: P_API_VERSION IN NUMBER,
8: P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
9: P_COMMIT IN VARCHAR2 default fnd_api.g_false,
10: P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
11: P_SALES_METHODOLOGY_NAME IN VARCHAR2,
12: P_START_DATE_ACTIVE IN DATE,

Line 9: P_COMMIT IN VARCHAR2 default fnd_api.g_false,

5: Procedure CREATE_SALES_METHODOLOGY
6: (
7: P_API_VERSION IN NUMBER,
8: P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
9: P_COMMIT IN VARCHAR2 default fnd_api.g_false,
10: P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
11: P_SALES_METHODOLOGY_NAME IN VARCHAR2,
12: P_START_DATE_ACTIVE IN DATE,
13: P_END_DATE_ACTIVE IN DATE DEFAULT NULL,

Line 10: P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,

6: (
7: P_API_VERSION IN NUMBER,
8: P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
9: P_COMMIT IN VARCHAR2 default fnd_api.g_false,
10: P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
11: P_SALES_METHODOLOGY_NAME IN VARCHAR2,
12: P_START_DATE_ACTIVE IN DATE,
13: P_END_DATE_ACTIVE IN DATE DEFAULT NULL,
14: P_AUTOCREATETASK_FLAG IN VARCHAR2 DEFAULT NULL,

Line 41: x_return_status := fnd_api.g_ret_sts_success;

37: l_api_name VARCHAR2(30) := 'CREATE_SALES_METHODOLOGY';
38: v_rowid VARCHAR2(24);
39: v_sales_methodology_id as_sales_methodology_b.sales_methodology_id%TYPE;
40: BEGIN
41: x_return_status := fnd_api.g_ret_sts_success;
42: SAVEPOINT create_sales_methodology_pvt;
43: SELECT as_sales_methodology_s.nextval
44: INTO v_sales_methodology_id
45: FROM dual;

Line 79: IF (fnd_api.to_boolean (p_commit))

75: fnd_global.login_id
76: );
77:
78: -- standard check of p_commit
79: IF (fnd_api.to_boolean (p_commit))
80: THEN
81: COMMIT WORK;
82: END IF;
83:

Line 86: WHEN fnd_api.g_exc_error

82: END IF;
83:
84: x_sales_methodology_id := v_sales_methodology_id;
85: EXCEPTION
86: WHEN fnd_api.g_exc_error
87: THEN
88: ROLLBACK TO create_sales_methodology_pvt;
89: x_return_status := fnd_api.g_ret_sts_error;
90: fnd_msg_pub.count_and_get (

Line 89: x_return_status := fnd_api.g_ret_sts_error;

85: EXCEPTION
86: WHEN fnd_api.g_exc_error
87: THEN
88: ROLLBACK TO create_sales_methodology_pvt;
89: x_return_status := fnd_api.g_ret_sts_error;
90: fnd_msg_pub.count_and_get (
91: p_count => x_msg_count,
92: p_data => x_msg_data
93: );

Line 94: WHEN fnd_api.g_exc_unexpected_error

90: fnd_msg_pub.count_and_get (
91: p_count => x_msg_count,
92: p_data => x_msg_data
93: );
94: WHEN fnd_api.g_exc_unexpected_error
95: THEN
96: ROLLBACK TO create_sales_methodology_pvt;
97: x_return_status := fnd_api.g_ret_sts_unexp_error;
98: fnd_msg_pub.count_and_get (

Line 97: x_return_status := fnd_api.g_ret_sts_unexp_error;

93: );
94: WHEN fnd_api.g_exc_unexpected_error
95: THEN
96: ROLLBACK TO create_sales_methodology_pvt;
97: x_return_status := fnd_api.g_ret_sts_unexp_error;
98: fnd_msg_pub.count_and_get (
99: p_count => x_msg_count,
100: p_data => x_msg_data
101: );

Line 105: x_return_status := fnd_api.g_ret_sts_unexp_error;

101: );
102: WHEN OTHERS
103: THEN
104: ROLLBACK TO create_sales_methodology_pvt;
105: x_return_status := fnd_api.g_ret_sts_unexp_error;
106:
107: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
108: THEN
109: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 124: P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,

120:
121: Procedure UPDATE_SALES_METHODOLOGY
122: (
123: P_API_VERSION IN NUMBER,
124: P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
125: P_COMMIT IN VARCHAR2 default fnd_api.g_false,
126: P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
127: P_SALES_METHODOLOGY_ID IN NUMBER,
128: P_SALES_METHODOLOGY_NAME IN VARCHAR2,

Line 125: P_COMMIT IN VARCHAR2 default fnd_api.g_false,

121: Procedure UPDATE_SALES_METHODOLOGY
122: (
123: P_API_VERSION IN NUMBER,
124: P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
125: P_COMMIT IN VARCHAR2 default fnd_api.g_false,
126: P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
127: P_SALES_METHODOLOGY_ID IN NUMBER,
128: P_SALES_METHODOLOGY_NAME IN VARCHAR2,
129: P_START_DATE_ACTIVE IN DATE,

Line 126: P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,

122: (
123: P_API_VERSION IN NUMBER,
124: P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
125: P_COMMIT IN VARCHAR2 default fnd_api.g_false,
126: P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
127: P_SALES_METHODOLOGY_ID IN NUMBER,
128: P_SALES_METHODOLOGY_NAME IN VARCHAR2,
129: P_START_DATE_ACTIVE IN DATE,
130: P_END_DATE_ACTIVE IN DATE DEFAULT NULL,

Line 157: x_return_status := fnd_api.g_ret_sts_success;

153: )
154: IS
155: l_api_name VARCHAR2(30) := 'UPDATE_SALES_METHODOLOGY';
156: BEGIN
157: x_return_status := fnd_api.g_ret_sts_success;
158: SAVEPOINT update_sales_methodology_pvt;
159: -- call locking table handler
160: as_sales_methodology_pkg.lock_row (
161: p_sales_methodology_id,

Line 196: IF (fnd_api.to_boolean (p_commit))

192: );
193: x_object_version_number := x_object_version_number + 1;
194:
195: -- standard check of p_commit
196: IF (fnd_api.to_boolean (p_commit))
197: THEN
198: COMMIT WORK;
199: END IF;
200: EXCEPTION

Line 201: WHEN fnd_api.g_exc_error

197: THEN
198: COMMIT WORK;
199: END IF;
200: EXCEPTION
201: WHEN fnd_api.g_exc_error
202: THEN
203: ROLLBACK TO update_sales_methodology_pvt;
204: x_return_status := fnd_api.g_ret_sts_error;
205: fnd_msg_pub.count_and_get (

Line 204: x_return_status := fnd_api.g_ret_sts_error;

200: EXCEPTION
201: WHEN fnd_api.g_exc_error
202: THEN
203: ROLLBACK TO update_sales_methodology_pvt;
204: x_return_status := fnd_api.g_ret_sts_error;
205: fnd_msg_pub.count_and_get (
206: p_count => x_msg_count,
207: p_data => x_msg_data
208: );

Line 209: WHEN fnd_api.g_exc_unexpected_error

205: fnd_msg_pub.count_and_get (
206: p_count => x_msg_count,
207: p_data => x_msg_data
208: );
209: WHEN fnd_api.g_exc_unexpected_error
210: THEN
211: ROLLBACK TO update_sales_methodology_pvt;
212: x_return_status := fnd_api.g_ret_sts_unexp_error;
213: fnd_msg_pub.count_and_get (

Line 212: x_return_status := fnd_api.g_ret_sts_unexp_error;

208: );
209: WHEN fnd_api.g_exc_unexpected_error
210: THEN
211: ROLLBACK TO update_sales_methodology_pvt;
212: x_return_status := fnd_api.g_ret_sts_unexp_error;
213: fnd_msg_pub.count_and_get (
214: p_count => x_msg_count,
215: p_data => x_msg_data
216: );

Line 220: x_return_status := fnd_api.g_ret_sts_unexp_error;

216: );
217: WHEN OTHERS
218: THEN
219: ROLLBACK TO update_sales_methodology_pvt;
220: x_return_status := fnd_api.g_ret_sts_unexp_error;
221:
222: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
223: THEN
224: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 239: P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,

235:
236: Procedure DELETE_SALES_METHODOLOGY
237: (
238: P_API_VERSION IN NUMBER,
239: P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
240: P_COMMIT IN VARCHAR2 default fnd_api.g_false,
241: P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
242: P_SALES_METHODOLOGY_ID IN NUMBER,
243: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 240: P_COMMIT IN VARCHAR2 default fnd_api.g_false,

236: Procedure DELETE_SALES_METHODOLOGY
237: (
238: P_API_VERSION IN NUMBER,
239: P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
240: P_COMMIT IN VARCHAR2 default fnd_api.g_false,
241: P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
242: P_SALES_METHODOLOGY_ID IN NUMBER,
243: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
244: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 241: P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,

237: (
238: P_API_VERSION IN NUMBER,
239: P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
240: P_COMMIT IN VARCHAR2 default fnd_api.g_false,
241: P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
242: P_SALES_METHODOLOGY_ID IN NUMBER,
243: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
244: X_MSG_COUNT OUT NOCOPY NUMBER,
245: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 251: x_return_status := fnd_api.g_ret_sts_success;

247: )
248: IS
249: l_api_name VARCHAR2(30) := 'DELETE_SALES_METHODOLOGY';
250: BEGIN
251: x_return_status := fnd_api.g_ret_sts_success;
252: SAVEPOINT delete_sales_methodology_pvt;
253:
254: -- Delete the sales stage mapping for the sales methdology first
255: DELETE FROM AS_SALES_METH_STAGE_MAP

Line 262: IF (fnd_api.to_boolean (p_commit))

258: -- call table handler to insert into jtf_tasks_temp_groups
259: as_sales_methodology_pkg.delete_row (p_sales_methodology_id);
260:
261: -- standard check of p_commit
262: IF (fnd_api.to_boolean (p_commit))
263: THEN
264: COMMIT WORK;
265: END IF;
266: EXCEPTION

Line 267: WHEN fnd_api.g_exc_error

263: THEN
264: COMMIT WORK;
265: END IF;
266: EXCEPTION
267: WHEN fnd_api.g_exc_error
268: THEN
269: ROLLBACK TO delete_sales_methodology_pvt;
270: x_return_status := fnd_api.g_ret_sts_error;
271: fnd_msg_pub.count_and_get (

Line 270: x_return_status := fnd_api.g_ret_sts_error;

266: EXCEPTION
267: WHEN fnd_api.g_exc_error
268: THEN
269: ROLLBACK TO delete_sales_methodology_pvt;
270: x_return_status := fnd_api.g_ret_sts_error;
271: fnd_msg_pub.count_and_get (
272: p_count => x_msg_count,
273: p_data => x_msg_data
274: );

Line 275: WHEN fnd_api.g_exc_unexpected_error

271: fnd_msg_pub.count_and_get (
272: p_count => x_msg_count,
273: p_data => x_msg_data
274: );
275: WHEN fnd_api.g_exc_unexpected_error
276: THEN
277: ROLLBACK TO delete_sales_methodology_pvt;
278: x_return_status := fnd_api.g_ret_sts_unexp_error;
279: fnd_msg_pub.count_and_get (

Line 278: x_return_status := fnd_api.g_ret_sts_unexp_error;

274: );
275: WHEN fnd_api.g_exc_unexpected_error
276: THEN
277: ROLLBACK TO delete_sales_methodology_pvt;
278: x_return_status := fnd_api.g_ret_sts_unexp_error;
279: fnd_msg_pub.count_and_get (
280: p_count => x_msg_count,
281: p_data => x_msg_data
282: );

Line 286: x_return_status := fnd_api.g_ret_sts_unexp_error;

282: );
283: WHEN OTHERS
284: THEN
285: ROLLBACK TO delete_sales_methodology_pvt;
286: x_return_status := fnd_api.g_ret_sts_unexp_error;
287:
288: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
289: THEN
290: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 303: P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,

299: --Procedure to Add a Sales Stage - Template Group Map
300: Procedure ADD_SALES_METH_STAGE_MAP
301: (
302: P_API_VERSION IN NUMBER,
303: P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
304: P_COMMIT IN VARCHAR2 default fnd_api.g_false,
305: P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
306: P_SALES_METHODOLOGY_ID IN NUMBER,
307: P_SALES_STAGE_ID IN NUMBER,

Line 304: P_COMMIT IN VARCHAR2 default fnd_api.g_false,

300: Procedure ADD_SALES_METH_STAGE_MAP
301: (
302: P_API_VERSION IN NUMBER,
303: P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
304: P_COMMIT IN VARCHAR2 default fnd_api.g_false,
305: P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
306: P_SALES_METHODOLOGY_ID IN NUMBER,
307: P_SALES_STAGE_ID IN NUMBER,
308: P_TASK_TEMPLATE_GROUP_ID IN NUMBER default fnd_api.g_miss_num,

Line 305: P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,

301: (
302: P_API_VERSION IN NUMBER,
303: P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
304: P_COMMIT IN VARCHAR2 default fnd_api.g_false,
305: P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
306: P_SALES_METHODOLOGY_ID IN NUMBER,
307: P_SALES_STAGE_ID IN NUMBER,
308: P_TASK_TEMPLATE_GROUP_ID IN NUMBER default fnd_api.g_miss_num,
309: P_MAX_WIN_PROBABILITY IN NUMBER,

Line 308: P_TASK_TEMPLATE_GROUP_ID IN NUMBER default fnd_api.g_miss_num,

304: P_COMMIT IN VARCHAR2 default fnd_api.g_false,
305: P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
306: P_SALES_METHODOLOGY_ID IN NUMBER,
307: P_SALES_STAGE_ID IN NUMBER,
308: P_TASK_TEMPLATE_GROUP_ID IN NUMBER default fnd_api.g_miss_num,
309: P_MAX_WIN_PROBABILITY IN NUMBER,
310: P_MIN_WIN_PROBABILITY IN NUMBER,
311: P_SALES_SUPPLEMENT_TEMPLATE IN NUMBER,
312: P_STAGE_SEQUENCE IN NUMBER,

Line 325: x_return_status := fnd_api.g_ret_sts_success;

321:
322: l_api_name VARCHAR2(30) := 'ADD_SALES_STAGE_MAP';
323: l_rowid VARCHAR2(30) := NULL;
324: BEGIN
325: x_return_status := fnd_api.g_ret_sts_success;
326: SAVEPOINT add_sales_stage_map_pvt;
327:
328: -- Try updating the AS_SALES_METH_MAP table.
329: UPDATE as_sales_meth_stage_map SET

Line 381: IF (fnd_api.to_boolean (p_commit))

377:
378: END IF;
379:
380: -- standard check of p_commit
381: IF (fnd_api.to_boolean (p_commit))
382: THEN
383: COMMIT WORK;
384: END IF;
385: EXCEPTION

Line 386: WHEN fnd_api.g_exc_error

382: THEN
383: COMMIT WORK;
384: END IF;
385: EXCEPTION
386: WHEN fnd_api.g_exc_error
387: THEN
388: ROLLBACK TO add_sales_stage_map_pvt;
389: x_return_status := fnd_api.g_ret_sts_error;
390: fnd_msg_pub.count_and_get (

Line 389: x_return_status := fnd_api.g_ret_sts_error;

385: EXCEPTION
386: WHEN fnd_api.g_exc_error
387: THEN
388: ROLLBACK TO add_sales_stage_map_pvt;
389: x_return_status := fnd_api.g_ret_sts_error;
390: fnd_msg_pub.count_and_get (
391: p_count => x_msg_count,
392: p_data => x_msg_data
393: );

Line 394: WHEN fnd_api.g_exc_unexpected_error

390: fnd_msg_pub.count_and_get (
391: p_count => x_msg_count,
392: p_data => x_msg_data
393: );
394: WHEN fnd_api.g_exc_unexpected_error
395: THEN
396: ROLLBACK TO add_sales_stage_map_pvt;
397: x_return_status := fnd_api.g_ret_sts_unexp_error;
398: fnd_msg_pub.count_and_get (

Line 397: x_return_status := fnd_api.g_ret_sts_unexp_error;

393: );
394: WHEN fnd_api.g_exc_unexpected_error
395: THEN
396: ROLLBACK TO add_sales_stage_map_pvt;
397: x_return_status := fnd_api.g_ret_sts_unexp_error;
398: fnd_msg_pub.count_and_get (
399: p_count => x_msg_count,
400: p_data => x_msg_data
401: );

Line 405: x_return_status := fnd_api.g_ret_sts_unexp_error;

401: );
402: WHEN OTHERS
403: THEN
404: ROLLBACK TO add_sales_stage_map_pvt;
405: x_return_status := fnd_api.g_ret_sts_unexp_error;
406:
407: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
408: THEN
409: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 422: P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,

418: --Procedure to Delete a Sales Stage - Template Group Map
419: Procedure DELETE_SALES_METH_STAGE_MAP
420: (
421: P_API_VERSION IN NUMBER,
422: P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
423: P_COMMIT IN VARCHAR2 default fnd_api.g_false,
424: P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
425: P_SALES_METHODOLOGY_ID IN NUMBER,
426: P_SALES_STAGE_ID IN NUMBER,

Line 423: P_COMMIT IN VARCHAR2 default fnd_api.g_false,

419: Procedure DELETE_SALES_METH_STAGE_MAP
420: (
421: P_API_VERSION IN NUMBER,
422: P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
423: P_COMMIT IN VARCHAR2 default fnd_api.g_false,
424: P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
425: P_SALES_METHODOLOGY_ID IN NUMBER,
426: P_SALES_STAGE_ID IN NUMBER,
427: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 424: P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,

420: (
421: P_API_VERSION IN NUMBER,
422: P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
423: P_COMMIT IN VARCHAR2 default fnd_api.g_false,
424: P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
425: P_SALES_METHODOLOGY_ID IN NUMBER,
426: P_SALES_STAGE_ID IN NUMBER,
427: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
428: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 434: x_return_status := fnd_api.g_ret_sts_success;

430: )
431: IS
432: l_api_name VARCHAR2(30) := 'DELETE_SALES_METH_STAGE_MAP';
433: BEGIN
434: x_return_status := fnd_api.g_ret_sts_success;
435: SAVEPOINT delete_sm_stage_map_pvt;
436:
437: -- Try updating the AS_SALES_METH_MAP table.
438: DELETE FROM as_sales_meth_stage_map

Line 450: IF (fnd_api.to_boolean (p_commit))

446: RAISE no_data_found;
447: END IF;
448:
449: -- standard check of p_commit
450: IF (fnd_api.to_boolean (p_commit))
451: THEN
452: COMMIT WORK;
453: END IF;
454: EXCEPTION

Line 455: WHEN fnd_api.g_exc_error

451: THEN
452: COMMIT WORK;
453: END IF;
454: EXCEPTION
455: WHEN fnd_api.g_exc_error
456: THEN
457: ROLLBACK TO delete_sm_stage_map_pvt;
458: x_return_status := fnd_api.g_ret_sts_error;
459: fnd_msg_pub.count_and_get (

Line 458: x_return_status := fnd_api.g_ret_sts_error;

454: EXCEPTION
455: WHEN fnd_api.g_exc_error
456: THEN
457: ROLLBACK TO delete_sm_stage_map_pvt;
458: x_return_status := fnd_api.g_ret_sts_error;
459: fnd_msg_pub.count_and_get (
460: p_count => x_msg_count,
461: p_data => x_msg_data
462: );

Line 463: WHEN fnd_api.g_exc_unexpected_error

459: fnd_msg_pub.count_and_get (
460: p_count => x_msg_count,
461: p_data => x_msg_data
462: );
463: WHEN fnd_api.g_exc_unexpected_error
464: THEN
465: ROLLBACK TO delete_sm_stage_map_pvt;
466: x_return_status := fnd_api.g_ret_sts_unexp_error;
467: fnd_msg_pub.count_and_get (

Line 466: x_return_status := fnd_api.g_ret_sts_unexp_error;

462: );
463: WHEN fnd_api.g_exc_unexpected_error
464: THEN
465: ROLLBACK TO delete_sm_stage_map_pvt;
466: x_return_status := fnd_api.g_ret_sts_unexp_error;
467: fnd_msg_pub.count_and_get (
468: p_count => x_msg_count,
469: p_data => x_msg_data
470: );

Line 474: x_return_status := fnd_api.g_ret_sts_unexp_error;

470: );
471: WHEN OTHERS
472: THEN
473: ROLLBACK TO delete_sm_stage_map_pvt;
474: x_return_status := fnd_api.g_ret_sts_unexp_error;
475:
476: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
477: THEN
478: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);