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.EAM_ASSET_ACTIVITIES_PVT dependencies on FND_API

Line 11: -- DEFAULT = FND_API.G_FALSE

7: -- Pre-reqs : None.
8: -- Parameters :
9: -- IN P_API_VERSION IN NUMBER REQUIRED
10: -- P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
11: -- DEFAULT = FND_API.G_FALSE
12: -- P_COMMIT IN VARCHAR2 OPTIONAL
13: -- DEFAULT = FND_API.G_FALSE
14: -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
15: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL

Line 13: -- DEFAULT = FND_API.G_FALSE

9: -- IN P_API_VERSION IN NUMBER REQUIRED
10: -- P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
11: -- DEFAULT = FND_API.G_FALSE
12: -- P_COMMIT IN VARCHAR2 OPTIONAL
13: -- DEFAULT = FND_API.G_FALSE
14: -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
15: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
16: -- P_ROWID IN OUT VARCHAR2 REQUIRED
17: -- P_ACTIVITY_ASSOCIATION_ID IN OUT NUMBER REQUIRED

Line 15: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL

11: -- DEFAULT = FND_API.G_FALSE
12: -- P_COMMIT IN VARCHAR2 OPTIONAL
13: -- DEFAULT = FND_API.G_FALSE
14: -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
15: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
16: -- P_ROWID IN OUT VARCHAR2 REQUIRED
17: -- P_ACTIVITY_ASSOCIATION_ID IN OUT NUMBER REQUIRED
18: -- P_ORGANIZATION_ID IN NUMBER REQUIRED
19: -- P_ASSET_ACTIVITY_ID IN NUMBER REQUIRED

Line 69: RETURN fnd_api.g_miss_num;

65: FUNCTION to_fnd_std_num(p_value NUMBER)
66: RETURN NUMBER IS
67: BEGIN
68: IF (p_value IS NULL) THEN
69: RETURN fnd_api.g_miss_num;
70: ELSE
71: RETURN p_value;
72: END IF;
73: END to_fnd_std_num;

Line 79: RETURN fnd_api.g_miss_char;

75: FUNCTION to_fnd_std_char(p_value VARCHAR2)
76: RETURN VARCHAR2 IS
77: BEGIN
78: IF (p_value IS NULL) THEN
79: RETURN fnd_api.g_miss_char;
80: ELSE
81: RETURN p_value;
82: END IF;
83: END to_fnd_std_char;

Line 87: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

83: END to_fnd_std_char;
84:
85: PROCEDURE INSERT_ROW(
86: P_API_VERSION IN NUMBER,
87: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
88: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
89: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
90: P_ROWID IN OUT NOCOPY VARCHAR2,
91: P_ACTIVITY_ASSOCIATION_ID IN OUT NOCOPY NUMBER,

Line 88: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

84:
85: PROCEDURE INSERT_ROW(
86: P_API_VERSION IN NUMBER,
87: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
88: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
89: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
90: P_ROWID IN OUT NOCOPY VARCHAR2,
91: P_ACTIVITY_ASSOCIATION_ID IN OUT NOCOPY NUMBER,
92: P_ORGANIZATION_ID NUMBER,

Line 89: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

85: PROCEDURE INSERT_ROW(
86: P_API_VERSION IN NUMBER,
87: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
88: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
89: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
90: P_ROWID IN OUT NOCOPY VARCHAR2,
91: P_ACTIVITY_ASSOCIATION_ID IN OUT NOCOPY NUMBER,
92: P_ORGANIZATION_ID NUMBER,
93: P_ASSET_ACTIVITY_ID NUMBER,

Line 153: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

149: -- Standard Start of API savepoint
150: SAVEPOINT insert_row;
151:
152: -- Standard call to check for call compatibility.
153: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
154: RAISE fnd_api.g_exc_unexpected_error;
155: END IF;
156:
157: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 154: RAISE fnd_api.g_exc_unexpected_error;

150: SAVEPOINT insert_row;
151:
152: -- Standard call to check for call compatibility.
153: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
154: RAISE fnd_api.g_exc_unexpected_error;
155: END IF;
156:
157: -- Initialize message list if p_init_msg_list is set to TRUE.
158: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 158: IF fnd_api.to_boolean(p_init_msg_list) THEN

154: RAISE fnd_api.g_exc_unexpected_error;
155: END IF;
156:
157: -- Initialize message list if p_init_msg_list is set to TRUE.
158: IF fnd_api.to_boolean(p_init_msg_list) THEN
159: fnd_msg_pub.initialize;
160: END IF;
161:
162: -- Initialize API return status to success

Line 163: x_return_status := fnd_api.g_ret_sts_success;

159: fnd_msg_pub.initialize;
160: END IF;
161:
162: -- Initialize API return status to success
163: x_return_status := fnd_api.g_ret_sts_success;
164:
165: -- API body
166:
167: INSERT INTO MTL_EAM_ASSET_ACTIVITIES(

Line 265: IF x_return_status <> fnd_api.g_ret_sts_success THEN

261: ,x_msg_count => x_msg_count
262: ,x_msg_data => x_msg_data
263: );
264:
265: IF x_return_status <> fnd_api.g_ret_sts_success THEN
266: RAISE fnd_api.g_exc_error;
267: END IF;
268:
269:

Line 266: RAISE fnd_api.g_exc_error;

262: ,x_msg_data => x_msg_data
263: );
264:
265: IF x_return_status <> fnd_api.g_ret_sts_success THEN
266: RAISE fnd_api.g_exc_error;
267: END IF;
268:
269:
270: OPEN C;

Line 280: IF fnd_api.to_boolean(p_commit) THEN

276: CLOSE C;
277:
278: -- End of API body.
279: -- Standard check of p_commit.
280: IF fnd_api.to_boolean(p_commit) THEN
281: COMMIT WORK;
282: END IF;
283:
284: -- Standard call to get message count and if count is 1, get message info.

Line 287: WHEN fnd_api.g_exc_error THEN

283:
284: -- Standard call to get message count and if count is 1, get message info.
285: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
286: EXCEPTION
287: WHEN fnd_api.g_exc_error THEN
288: ROLLBACK TO insert_row;
289: x_return_status := fnd_api.g_ret_sts_error;
290: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
291: WHEN fnd_api.g_exc_unexpected_error THEN

Line 289: x_return_status := fnd_api.g_ret_sts_error;

285: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
286: EXCEPTION
287: WHEN fnd_api.g_exc_error THEN
288: ROLLBACK TO insert_row;
289: x_return_status := fnd_api.g_ret_sts_error;
290: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
291: WHEN fnd_api.g_exc_unexpected_error THEN
292: ROLLBACK TO insert_row;
293: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 291: WHEN fnd_api.g_exc_unexpected_error THEN

287: WHEN fnd_api.g_exc_error THEN
288: ROLLBACK TO insert_row;
289: x_return_status := fnd_api.g_ret_sts_error;
290: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
291: WHEN fnd_api.g_exc_unexpected_error THEN
292: ROLLBACK TO insert_row;
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294: fnd_msg_pub.count_and_get(
295: p_count => x_msg_count

Line 293: x_return_status := fnd_api.g_ret_sts_unexp_error;

289: x_return_status := fnd_api.g_ret_sts_error;
290: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
291: WHEN fnd_api.g_exc_unexpected_error THEN
292: ROLLBACK TO insert_row;
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294: fnd_msg_pub.count_and_get(
295: p_count => x_msg_count
296: ,p_data => x_msg_data);
297: WHEN OTHERS THEN

Line 299: x_return_status := fnd_api.g_ret_sts_unexp_error;

295: p_count => x_msg_count
296: ,p_data => x_msg_data);
297: WHEN OTHERS THEN
298: ROLLBACK TO insert_row;
299: x_return_status := fnd_api.g_ret_sts_unexp_error;
300:
301: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
302: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
303: END IF;

Line 311: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

307: END Insert_Row;
308:
309: PROCEDURE LOCK_ROW(
310: P_API_VERSION IN NUMBER,
311: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
312: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
313: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
314: P_ROWID VARCHAR2,
315: P_ACTIVITY_ASSOCIATION_ID NUMBER,

Line 312: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

308:
309: PROCEDURE LOCK_ROW(
310: P_API_VERSION IN NUMBER,
311: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
312: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
313: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
314: P_ROWID VARCHAR2,
315: P_ACTIVITY_ASSOCIATION_ID NUMBER,
316: P_ORGANIZATION_ID NUMBER,

Line 313: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

309: PROCEDURE LOCK_ROW(
310: P_API_VERSION IN NUMBER,
311: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
312: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
313: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
314: P_ROWID VARCHAR2,
315: P_ACTIVITY_ASSOCIATION_ID NUMBER,
316: P_ORGANIZATION_ID NUMBER,
317: P_ASSET_ACTIVITY_ID NUMBER,

Line 373: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

369: -- Standard Start of API savepoint
370: SAVEPOINT lock_row;
371:
372: -- Standard call to check for call compatibility.
373: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
374: RAISE fnd_api.g_exc_unexpected_error;
375: END IF;
376:
377: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 374: RAISE fnd_api.g_exc_unexpected_error;

370: SAVEPOINT lock_row;
371:
372: -- Standard call to check for call compatibility.
373: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
374: RAISE fnd_api.g_exc_unexpected_error;
375: END IF;
376:
377: -- Initialize message list if p_init_msg_list is set to TRUE.
378: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 378: IF fnd_api.to_boolean(p_init_msg_list) THEN

374: RAISE fnd_api.g_exc_unexpected_error;
375: END IF;
376:
377: -- Initialize message list if p_init_msg_list is set to TRUE.
378: IF fnd_api.to_boolean(p_init_msg_list) THEN
379: fnd_msg_pub.initialize;
380: END IF;
381:
382: -- Initialize API return status to success

Line 383: x_return_status := fnd_api.g_ret_sts_success;

379: fnd_msg_pub.initialize;
380: END IF;
381:
382: -- Initialize API return status to success
383: x_return_status := fnd_api.g_ret_sts_success;
384:
385: -- API body
386:
387: OPEN C;

Line 482: IF fnd_api.to_boolean(p_commit) THEN

478: end if;
479:
480: -- End of API body.
481: -- Standard check of p_commit.
482: IF fnd_api.to_boolean(p_commit) THEN
483: COMMIT WORK;
484: END IF;
485:
486: -- Standard call to get message count and if count is 1, get message info.

Line 489: WHEN fnd_api.g_exc_error THEN

485:
486: -- Standard call to get message count and if count is 1, get message info.
487: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
488: EXCEPTION
489: WHEN fnd_api.g_exc_error THEN
490: ROLLBACK TO lock_row;
491: x_return_status := fnd_api.g_ret_sts_error;
492: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
493: WHEN fnd_api.g_exc_unexpected_error THEN

Line 491: x_return_status := fnd_api.g_ret_sts_error;

487: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
488: EXCEPTION
489: WHEN fnd_api.g_exc_error THEN
490: ROLLBACK TO lock_row;
491: x_return_status := fnd_api.g_ret_sts_error;
492: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
493: WHEN fnd_api.g_exc_unexpected_error THEN
494: ROLLBACK TO lock_row;
495: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 493: WHEN fnd_api.g_exc_unexpected_error THEN

489: WHEN fnd_api.g_exc_error THEN
490: ROLLBACK TO lock_row;
491: x_return_status := fnd_api.g_ret_sts_error;
492: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
493: WHEN fnd_api.g_exc_unexpected_error THEN
494: ROLLBACK TO lock_row;
495: x_return_status := fnd_api.g_ret_sts_unexp_error;
496: fnd_msg_pub.count_and_get(
497: p_count => x_msg_count

Line 495: x_return_status := fnd_api.g_ret_sts_unexp_error;

491: x_return_status := fnd_api.g_ret_sts_error;
492: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
493: WHEN fnd_api.g_exc_unexpected_error THEN
494: ROLLBACK TO lock_row;
495: x_return_status := fnd_api.g_ret_sts_unexp_error;
496: fnd_msg_pub.count_and_get(
497: p_count => x_msg_count
498: ,p_data => x_msg_data);
499: WHEN OTHERS THEN

Line 501: x_return_status := fnd_api.g_ret_sts_unexp_error;

497: p_count => x_msg_count
498: ,p_data => x_msg_data);
499: WHEN OTHERS THEN
500: ROLLBACK TO lock_row;
501: x_return_status := fnd_api.g_ret_sts_unexp_error;
502:
503: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
504: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
505: END IF;

Line 513: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

509: END Lock_Row;
510:
511: PROCEDURE UPDATE_ROW(
512: P_API_VERSION IN NUMBER,
513: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
514: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
515: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
516: P_ROWID VARCHAR2,
517: P_ACTIVITY_ASSOCIATION_ID NUMBER,

Line 514: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

510:
511: PROCEDURE UPDATE_ROW(
512: P_API_VERSION IN NUMBER,
513: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
514: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
515: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
516: P_ROWID VARCHAR2,
517: P_ACTIVITY_ASSOCIATION_ID NUMBER,
518: P_ORGANIZATION_ID NUMBER,

Line 515: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

511: PROCEDURE UPDATE_ROW(
512: P_API_VERSION IN NUMBER,
513: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
514: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
515: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
516: P_ROWID VARCHAR2,
517: P_ACTIVITY_ASSOCIATION_ID NUMBER,
518: P_ORGANIZATION_ID NUMBER,
519: P_ASSET_ACTIVITY_ID NUMBER,

Line 570: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

566: -- Standard Start of API savepoint
567: SAVEPOINT update_row;
568:
569: -- Standard call to check for call compatibility.
570: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
571: RAISE fnd_api.g_exc_unexpected_error;
572: END IF;
573:
574: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 571: RAISE fnd_api.g_exc_unexpected_error;

567: SAVEPOINT update_row;
568:
569: -- Standard call to check for call compatibility.
570: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
571: RAISE fnd_api.g_exc_unexpected_error;
572: END IF;
573:
574: -- Initialize message list if p_init_msg_list is set to TRUE.
575: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 575: IF fnd_api.to_boolean(p_init_msg_list) THEN

571: RAISE fnd_api.g_exc_unexpected_error;
572: END IF;
573:
574: -- Initialize message list if p_init_msg_list is set to TRUE.
575: IF fnd_api.to_boolean(p_init_msg_list) THEN
576: fnd_msg_pub.initialize;
577: END IF;
578:
579: -- Initialize API return status to success

Line 580: x_return_status := fnd_api.g_ret_sts_success;

576: fnd_msg_pub.initialize;
577: END IF;
578:
579: -- Initialize API return status to success
580: x_return_status := fnd_api.g_ret_sts_success;
581:
582: -- API body
583:
584: UPDATE MTL_EAM_ASSET_ACTIVITIES

Line 646: IF x_return_status <> fnd_api.g_ret_sts_success THEN

642: ,x_msg_count => x_msg_count
643: ,x_msg_data => x_msg_data
644: );
645:
646: IF x_return_status <> fnd_api.g_ret_sts_success THEN
647: RAISE fnd_api.g_exc_error;
648: END IF;
649:
650: -- End of API body.

Line 647: RAISE fnd_api.g_exc_error;

643: ,x_msg_data => x_msg_data
644: );
645:
646: IF x_return_status <> fnd_api.g_ret_sts_success THEN
647: RAISE fnd_api.g_exc_error;
648: END IF;
649:
650: -- End of API body.
651: -- Standard check of p_commit.

Line 652: IF fnd_api.to_boolean(p_commit) THEN

648: END IF;
649:
650: -- End of API body.
651: -- Standard check of p_commit.
652: IF fnd_api.to_boolean(p_commit) THEN
653: COMMIT WORK;
654: END IF;
655:
656: -- Standard call to get message count and if count is 1, get message info.

Line 659: WHEN fnd_api.g_exc_error THEN

655:
656: -- Standard call to get message count and if count is 1, get message info.
657: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
658: EXCEPTION
659: WHEN fnd_api.g_exc_error THEN
660: ROLLBACK TO update_row;
661: x_return_status := fnd_api.g_ret_sts_error;
662: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
663: WHEN fnd_api.g_exc_unexpected_error THEN

Line 661: x_return_status := fnd_api.g_ret_sts_error;

657: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
658: EXCEPTION
659: WHEN fnd_api.g_exc_error THEN
660: ROLLBACK TO update_row;
661: x_return_status := fnd_api.g_ret_sts_error;
662: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
663: WHEN fnd_api.g_exc_unexpected_error THEN
664: ROLLBACK TO update_row;
665: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 663: WHEN fnd_api.g_exc_unexpected_error THEN

659: WHEN fnd_api.g_exc_error THEN
660: ROLLBACK TO update_row;
661: x_return_status := fnd_api.g_ret_sts_error;
662: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
663: WHEN fnd_api.g_exc_unexpected_error THEN
664: ROLLBACK TO update_row;
665: x_return_status := fnd_api.g_ret_sts_unexp_error;
666: fnd_msg_pub.count_and_get(
667: p_count => x_msg_count

Line 665: x_return_status := fnd_api.g_ret_sts_unexp_error;

661: x_return_status := fnd_api.g_ret_sts_error;
662: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
663: WHEN fnd_api.g_exc_unexpected_error THEN
664: ROLLBACK TO update_row;
665: x_return_status := fnd_api.g_ret_sts_unexp_error;
666: fnd_msg_pub.count_and_get(
667: p_count => x_msg_count
668: ,p_data => x_msg_data);
669: WHEN OTHERS THEN

Line 671: x_return_status := fnd_api.g_ret_sts_unexp_error;

667: p_count => x_msg_count
668: ,p_data => x_msg_data);
669: WHEN OTHERS THEN
670: ROLLBACK TO update_row;
671: x_return_status := fnd_api.g_ret_sts_unexp_error;
672:
673: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
674: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
675: END IF;