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

Line 12: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

8: g_view_name CONSTANT VARCHAR2(48) := 'jtf_amv_attachments a';
9:
10: PROCEDURE list_attachment (
11: p_api_version IN NUMBER,
12: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
13: x_return_status OUT NOCOPY VARCHAR2,
14: x_msg_count OUT NOCOPY NUMBER,
15: x_msg_data OUT NOCOPY VARCHAR2,
16:

Line 66: IF NOT FND_API.compatible_api_call(

62:
63: l_version_tbl JTF_NUMBER_TABLE;
64: BEGIN
65: -- Standard call to check for call compatibility
66: IF NOT FND_API.compatible_api_call(
67: g_api_version,
68: p_api_version,
69: l_api_name,
70: g_pkg_name ) THEN

Line 71: RAISE FND_API.g_exc_unexpected_error;

67: g_api_version,
68: p_api_version,
69: l_api_name,
70: g_pkg_name ) THEN
71: RAISE FND_API.g_exc_unexpected_error;
72: END IF;
73:
74: -- Initialize message list if p_init_msg_list is set to TRUE
75: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 75: IF FND_API.to_boolean(p_init_msg_list) THEN

71: RAISE FND_API.g_exc_unexpected_error;
72: END IF;
73:
74: -- Initialize message list if p_init_msg_list is set to TRUE
75: IF FND_API.to_boolean(p_init_msg_list) THEN
76: FND_MSG_PUB.initialize;
77: END IF;
78:
79: -- Initialize API rturn status to success

Line 80: x_return_status := FND_API.g_ret_sts_success;

76: FND_MSG_PUB.initialize;
77: END IF;
78:
79: -- Initialize API rturn status to success
80: x_return_status := FND_API.g_ret_sts_success;
81: sql_cond := ' FROM ' || g_view_name ||
82: ' WHERE a.application_id = :appl_id ' ||
83: ' AND EXISTS (SELECT NULL FROM ' ||
84: ' ibe_dsp_lgl_phys_map m WHERE ' ||

Line 95: RAISE FND_API.g_exc_unexpected_error;

91: FND_MESSAGE.set_name('IBE', 'IBE_DSP_QUERY_INVLD');
92: FND_MESSAGE.set_token('0', p_start_id);
93: FND_MESSAGE.set_token('1', p_batch_size);
94: FND_MSG_PUB.add;
95: RAISE FND_API.g_exc_unexpected_error;
96: END IF;
97:
98: IF p_deliverable_id IS NOT NULL THEN
99: l_flag := 1;

Line 122: p_encoded => FND_API.g_false,

118: CLOSE l_ath_cv;
119:
120: IF x_row_count = 0 THEN
121: FND_MSG_PUB.count_and_get(
122: p_encoded => FND_API.g_false,
123: p_count => x_msg_count,
124: p_data => x_msg_data
125: );
126: RETURN;

Line 145: p_encoded => FND_API.g_false,

141: -- Get matchined rows
142: IF p_start_id > -1 THEN
143: IF p_start_id >= x_row_count THEN
144: FND_MSG_PUB.count_and_get(
145: p_encoded => FND_API.g_false,
146: p_count => x_msg_count,
147: p_data => x_msg_data
148: );
149: RETURN;

Line 255: p_encoded => FND_API.g_false,

251: END IF;
252:
253: -- Standard call to get message count and if count is 1, get message info
254: FND_MSG_PUB.count_and_get(
255: p_encoded => FND_API.g_false,
256: p_count => x_msg_count,
257: p_data => x_msg_data
258: );
259:

Line 264: WHEN FND_API.g_exc_unexpected_error THEN

260: -- dbms_output.put_line('reached where');
261:
262: EXCEPTION
263:
264: WHEN FND_API.g_exc_unexpected_error THEN
265: x_return_status := FND_API.g_ret_sts_unexp_error ;
266: FND_MSG_PUB.count_and_get(
267: p_encoded => FND_API.g_false,
268: p_count => x_msg_count,

Line 265: x_return_status := FND_API.g_ret_sts_unexp_error ;

261:
262: EXCEPTION
263:
264: WHEN FND_API.g_exc_unexpected_error THEN
265: x_return_status := FND_API.g_ret_sts_unexp_error ;
266: FND_MSG_PUB.count_and_get(
267: p_encoded => FND_API.g_false,
268: p_count => x_msg_count,
269: p_data => x_msg_data

Line 267: p_encoded => FND_API.g_false,

263:
264: WHEN FND_API.g_exc_unexpected_error THEN
265: x_return_status := FND_API.g_ret_sts_unexp_error ;
266: FND_MSG_PUB.count_and_get(
267: p_encoded => FND_API.g_false,
268: p_count => x_msg_count,
269: p_data => x_msg_data
270: );
271:

Line 273: x_return_status := FND_API.g_ret_sts_unexp_error ;

269: p_data => x_msg_data
270: );
271:
272: WHEN OTHERS THEN
273: x_return_status := FND_API.g_ret_sts_unexp_error ;
274:
275: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
276: END IF;
277:

Line 279: p_encoded => FND_API.g_false,

275: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
276: END IF;
277:
278: FND_MSG_PUB.count_and_get(
279: p_encoded => FND_API.g_false,
280: p_count => x_msg_count,
281: p_data => x_msg_data
282: );
283:

Line 307: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

303: -- 5. Raise an exception for any other errors
304: ---------------------------------------------------------------------+
305: PROCEDURE save_attachment (
306: p_api_version IN NUMBER,
307: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
308: p_commit IN VARCHAR2 := FND_API.g_false,
309: x_return_status OUT NOCOPY VARCHAR2,
310: x_msg_count OUT NOCOPY NUMBER,
311: x_msg_data OUT NOCOPY VARCHAR2,

Line 308: p_commit IN VARCHAR2 := FND_API.g_false,

304: ---------------------------------------------------------------------+
305: PROCEDURE save_attachment (
306: p_api_version IN NUMBER,
307: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
308: p_commit IN VARCHAR2 := FND_API.g_false,
309: x_return_status OUT NOCOPY VARCHAR2,
310: x_msg_count OUT NOCOPY NUMBER,
311: x_msg_data OUT NOCOPY VARCHAR2,
312: p_attachment_rec IN OUT NOCOPY ATTACHMENT_REC_TYPE ) IS

Line 328: IF NOT FND_API.compatible_api_call(

324: -- Standard start of API savepoint
325: SAVEPOINT save_attachment_grp;
326:
327: -- Standard call to check for call compatibility
328: IF NOT FND_API.compatible_api_call(
329: g_api_version,
330: p_api_version,
331: l_api_name,
332: g_pkg_name ) THEN

Line 333: RAISE FND_API.g_exc_unexpected_error;

329: g_api_version,
330: p_api_version,
331: l_api_name,
332: g_pkg_name ) THEN
333: RAISE FND_API.g_exc_unexpected_error;
334: END IF;
335:
336: -- Initialize message list if p_init_msg_list is set to TRUE
337: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 337: IF FND_API.to_boolean(p_init_msg_list) THEN

333: RAISE FND_API.g_exc_unexpected_error;
334: END IF;
335:
336: -- Initialize message list if p_init_msg_list is set to TRUE
337: IF FND_API.to_boolean(p_init_msg_list) THEN
338: FND_MSG_PUB.initialize;
339: END IF;
340:
341: -- Initialize API rturn status to success

Line 342: x_return_status := FND_API.g_ret_sts_success;

338: FND_MSG_PUB.initialize;
339: END IF;
340:
341: -- Initialize API rturn status to success
342: x_return_status := FND_API.g_ret_sts_success;
343:
344: -- API body
345:
346: l_act_attachment_rec.LAST_UPDATE_DATE := NULL;

Line 457: -- RAISE FND_API.g_exc_error;

453: -- being used by mutiple items.
454: --IF NOT IBE_DSPMGRVALIDATION_GRP.check_attachment_filename(
455: -- l_act_attachment_rec.attachment_id,
456: -- l_act_attachment_rec.file_name) THEN
457: -- RAISE FND_API.g_exc_error;
458: --END IF;
459:
460: --added by G. Zhang 04/30/2001 11:18AM
461: IF l_act_attachment_rec.APPLICATION_ID IS NULL THEN

Line 462: RAISE FND_API.g_exc_error;

458: --END IF;
459:
460: --added by G. Zhang 04/30/2001 11:18AM
461: IF l_act_attachment_rec.APPLICATION_ID IS NULL THEN
462: RAISE FND_API.g_exc_error;
463: END IF;
464: IF l_act_attachment_rec.ATTACHMENT_USED_BY IS NULL THEN
465: RAISE FND_API.g_exc_error;
466: END IF;

Line 465: RAISE FND_API.g_exc_error;

461: IF l_act_attachment_rec.APPLICATION_ID IS NULL THEN
462: RAISE FND_API.g_exc_error;
463: END IF;
464: IF l_act_attachment_rec.ATTACHMENT_USED_BY IS NULL THEN
465: RAISE FND_API.g_exc_error;
466: END IF;
467:
468: IF l_act_attachment_rec.attachment_id IS NOT NULL THEN
469: -- Update an existing attachment

Line 474: RAISE FND_API.g_exc_error;

470: l_operation_type := 'UPDATE';
471: ELSE
472: IF NOT IBE_DSPMGRVALIDATION_GRP.check_deliverable_exists(
473: p_attachment_rec.deliverable_id) THEN
474: RAISE FND_API.g_exc_error;
475: END IF;
476: END IF;
477:
478: IF (l_operation_type = 'INSERT') THEN

Line 490: IF l_return_status = FND_API.g_ret_sts_error THEN

486: p_act_attachment_rec => l_act_attachment_rec,
487: x_act_attachment_id => l_attachment_id
488: );
489:
490: IF l_return_status = FND_API.g_ret_sts_error THEN
491: RAISE FND_API.g_exc_error;
492: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
493: RAISE FND_API.g_exc_unexpected_error;
494: END IF;

Line 491: RAISE FND_API.g_exc_error;

487: x_act_attachment_id => l_attachment_id
488: );
489:
490: IF l_return_status = FND_API.g_ret_sts_error THEN
491: RAISE FND_API.g_exc_error;
492: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
493: RAISE FND_API.g_exc_unexpected_error;
494: END IF;
495:

Line 492: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

488: );
489:
490: IF l_return_status = FND_API.g_ret_sts_error THEN
491: RAISE FND_API.g_exc_error;
492: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
493: RAISE FND_API.g_exc_unexpected_error;
494: END IF;
495:
496: -- update the attachment_id and object_version_number

Line 493: RAISE FND_API.g_exc_unexpected_error;

489:
490: IF l_return_status = FND_API.g_ret_sts_error THEN
491: RAISE FND_API.g_exc_error;
492: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
493: RAISE FND_API.g_exc_unexpected_error;
494: END IF;
495:
496: -- update the attachment_id and object_version_number
497: p_attachment_rec.attachment_id := l_attachment_id;

Line 503: := FND_API.G_MISS_NUM;

499:
500: ELSE
501:
502: l_act_attachment_rec.attachment_used_by_id
503: := FND_API.G_MISS_NUM;
504:
505: JTF_AMV_ATTACHMENT_PUB.update_act_attachment(
506: p_api_version => g_amv_api_version,
507: x_return_status => l_return_status,

Line 513: IF l_return_status = FND_API.g_ret_sts_error THEN

509: x_msg_data => x_msg_data,
510: p_act_attachment_rec => l_act_attachment_rec
511: );
512:
513: IF l_return_status = FND_API.g_ret_sts_error THEN
514: RAISE FND_API.g_exc_error;
515: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
516: RAISE FND_API.g_exc_unexpected_error;
517: END IF;

Line 514: RAISE FND_API.g_exc_error;

510: p_act_attachment_rec => l_act_attachment_rec
511: );
512:
513: IF l_return_status = FND_API.g_ret_sts_error THEN
514: RAISE FND_API.g_exc_error;
515: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
516: RAISE FND_API.g_exc_unexpected_error;
517: END IF;
518:

Line 515: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

511: );
512:
513: IF l_return_status = FND_API.g_ret_sts_error THEN
514: RAISE FND_API.g_exc_error;
515: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
516: RAISE FND_API.g_exc_unexpected_error;
517: END IF;
518:
519: -- update the object_version_number

Line 516: RAISE FND_API.g_exc_unexpected_error;

512:
513: IF l_return_status = FND_API.g_ret_sts_error THEN
514: RAISE FND_API.g_exc_error;
515: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
516: RAISE FND_API.g_exc_unexpected_error;
517: END IF;
518:
519: -- update the object_version_number
520: p_attachment_rec.object_version_number :=

Line 526: := FND_API.g_ret_sts_success;

522:
523: END IF;
524:
525: p_attachment_rec.x_action_status
526: := FND_API.g_ret_sts_success;
527:
528: -- Check if the caller requested to commit ,
529: -- If p_commit set to true, commit the transaction
530: IF FND_API.to_boolean(p_commit) THEN

Line 530: IF FND_API.to_boolean(p_commit) THEN

526: := FND_API.g_ret_sts_success;
527:
528: -- Check if the caller requested to commit ,
529: -- If p_commit set to true, commit the transaction
530: IF FND_API.to_boolean(p_commit) THEN
531: COMMIT;
532: END IF;
533:
534: -- Standard call to get message count and if count is 1, get message info

Line 536: p_encoded => FND_API.g_false,

532: END IF;
533:
534: -- Standard call to get message count and if count is 1, get message info
535: FND_MSG_PUB.count_and_get(
536: p_encoded => FND_API.g_false,
537: p_count => x_msg_count,
538: p_data => x_msg_data
539: );
540:

Line 543: WHEN FND_API.g_exc_error THEN

539: );
540:
541: EXCEPTION
542:
543: WHEN FND_API.g_exc_error THEN
544: ROLLBACK TO save_attachment_grp;
545: x_return_status := FND_API.g_ret_sts_error;
546: p_attachment_rec.x_action_status := FND_API.g_ret_sts_error;
547: FND_MSG_PUB.count_and_get(

Line 545: x_return_status := FND_API.g_ret_sts_error;

541: EXCEPTION
542:
543: WHEN FND_API.g_exc_error THEN
544: ROLLBACK TO save_attachment_grp;
545: x_return_status := FND_API.g_ret_sts_error;
546: p_attachment_rec.x_action_status := FND_API.g_ret_sts_error;
547: FND_MSG_PUB.count_and_get(
548: p_encoded => FND_API.g_false,
549: p_count => x_msg_count,

Line 546: p_attachment_rec.x_action_status := FND_API.g_ret_sts_error;

542:
543: WHEN FND_API.g_exc_error THEN
544: ROLLBACK TO save_attachment_grp;
545: x_return_status := FND_API.g_ret_sts_error;
546: p_attachment_rec.x_action_status := FND_API.g_ret_sts_error;
547: FND_MSG_PUB.count_and_get(
548: p_encoded => FND_API.g_false,
549: p_count => x_msg_count,
550: p_data => x_msg_data

Line 548: p_encoded => FND_API.g_false,

544: ROLLBACK TO save_attachment_grp;
545: x_return_status := FND_API.g_ret_sts_error;
546: p_attachment_rec.x_action_status := FND_API.g_ret_sts_error;
547: FND_MSG_PUB.count_and_get(
548: p_encoded => FND_API.g_false,
549: p_count => x_msg_count,
550: p_data => x_msg_data
551: );
552:

Line 553: WHEN FND_API.g_exc_unexpected_error THEN

549: p_count => x_msg_count,
550: p_data => x_msg_data
551: );
552:
553: WHEN FND_API.g_exc_unexpected_error THEN
554: ROLLBACK TO save_attachment_grp;
555: x_return_status := FND_API.g_ret_sts_unexp_error ;
556: p_attachment_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
557: FND_MSG_PUB.count_and_get(

Line 555: x_return_status := FND_API.g_ret_sts_unexp_error ;

551: );
552:
553: WHEN FND_API.g_exc_unexpected_error THEN
554: ROLLBACK TO save_attachment_grp;
555: x_return_status := FND_API.g_ret_sts_unexp_error ;
556: p_attachment_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
557: FND_MSG_PUB.count_and_get(
558: p_encoded => FND_API.g_false,
559: p_count => x_msg_count,

Line 556: p_attachment_rec.x_action_status := FND_API.g_ret_sts_unexp_error;

552:
553: WHEN FND_API.g_exc_unexpected_error THEN
554: ROLLBACK TO save_attachment_grp;
555: x_return_status := FND_API.g_ret_sts_unexp_error ;
556: p_attachment_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
557: FND_MSG_PUB.count_and_get(
558: p_encoded => FND_API.g_false,
559: p_count => x_msg_count,
560: p_data => x_msg_data

Line 558: p_encoded => FND_API.g_false,

554: ROLLBACK TO save_attachment_grp;
555: x_return_status := FND_API.g_ret_sts_unexp_error ;
556: p_attachment_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
557: FND_MSG_PUB.count_and_get(
558: p_encoded => FND_API.g_false,
559: p_count => x_msg_count,
560: p_data => x_msg_data
561: );
562:

Line 565: x_return_status := FND_API.g_ret_sts_unexp_error ;

561: );
562:
563: WHEN OTHERS THEN
564: ROLLBACK TO save_attachment_grp;
565: x_return_status := FND_API.g_ret_sts_unexp_error ;
566: p_attachment_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
567:
568: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
569: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 566: p_attachment_rec.x_action_status := FND_API.g_ret_sts_unexp_error;

562:
563: WHEN OTHERS THEN
564: ROLLBACK TO save_attachment_grp;
565: x_return_status := FND_API.g_ret_sts_unexp_error ;
566: p_attachment_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
567:
568: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
569: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
570: END IF;

Line 573: p_encoded => FND_API.g_false,

569: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
570: END IF;
571:
572: FND_MSG_PUB.count_and_get(
573: p_encoded => FND_API.g_false,
574: p_count => x_msg_count,
575: p_data => x_msg_data
576: );
577:

Line 601: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

597: -- 5. Raise an exception for any other errors
598: ---------------------------------------------------------------------
599: PROCEDURE save_attachment (
600: p_api_version IN NUMBER,
601: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
602: p_commit IN VARCHAR2 := FND_API.g_false,
603: x_return_status OUT NOCOPY VARCHAR2,
604: x_msg_count OUT NOCOPY NUMBER,
605: x_msg_data OUT NOCOPY VARCHAR2,

Line 602: p_commit IN VARCHAR2 := FND_API.g_false,

598: ---------------------------------------------------------------------
599: PROCEDURE save_attachment (
600: p_api_version IN NUMBER,
601: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
602: p_commit IN VARCHAR2 := FND_API.g_false,
603: x_return_status OUT NOCOPY VARCHAR2,
604: x_msg_count OUT NOCOPY NUMBER,
605: x_msg_data OUT NOCOPY VARCHAR2,
606: p_attachment_tbl IN OUT NOCOPY ATTACHMENT_TBL_TYPE ) IS

Line 621: IF NOT FND_API.compatible_api_call(

617: -- Standard start of API savepoint
618: SAVEPOINT save_attachment_grp;
619:
620: -- Standard call to check for call compatibility
621: IF NOT FND_API.compatible_api_call(
622: g_api_version,
623: p_api_version,
624: l_api_name,
625: g_pkg_name

Line 627: RAISE FND_API.g_exc_unexpected_error;

623: p_api_version,
624: l_api_name,
625: g_pkg_name
626: ) THEN
627: RAISE FND_API.g_exc_unexpected_error;
628: END IF;
629:
630: -- Initialize message list if p_init_msg_list is set to TRUE
631: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 631: IF FND_API.to_boolean(p_init_msg_list) THEN

627: RAISE FND_API.g_exc_unexpected_error;
628: END IF;
629:
630: -- Initialize message list if p_init_msg_list is set to TRUE
631: IF FND_API.to_boolean(p_init_msg_list) THEN
632: FND_MSG_PUB.initialize;
633: END IF;
634:
635: -- Initialize API rturn status to success

Line 636: x_return_status := FND_API.g_ret_sts_success;

632: FND_MSG_PUB.initialize;
633: END IF;
634:
635: -- Initialize API rturn status to success
636: x_return_status := FND_API.g_ret_sts_success;
637:
638: -- API body
639:
640: IF p_attachment_tbl IS NOT NULL THEN

Line 652: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

648: p_attachment_rec => p_attachment_tbl(l_index)
649: );
650:
651:
652: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
653: x_return_status := FND_API.g_ret_sts_unexp_error;
654: ELSIF l_return_status = FND_API.g_ret_sts_error
655: AND x_return_status <> FND_API.g_ret_sts_unexp_error THEN
656: x_return_status := FND_API.g_ret_sts_error;

Line 653: x_return_status := FND_API.g_ret_sts_unexp_error;

649: );
650:
651:
652: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
653: x_return_status := FND_API.g_ret_sts_unexp_error;
654: ELSIF l_return_status = FND_API.g_ret_sts_error
655: AND x_return_status <> FND_API.g_ret_sts_unexp_error THEN
656: x_return_status := FND_API.g_ret_sts_error;
657: END IF;

Line 654: ELSIF l_return_status = FND_API.g_ret_sts_error

650:
651:
652: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
653: x_return_status := FND_API.g_ret_sts_unexp_error;
654: ELSIF l_return_status = FND_API.g_ret_sts_error
655: AND x_return_status <> FND_API.g_ret_sts_unexp_error THEN
656: x_return_status := FND_API.g_ret_sts_error;
657: END IF;
658:

Line 655: AND x_return_status <> FND_API.g_ret_sts_unexp_error THEN

651:
652: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
653: x_return_status := FND_API.g_ret_sts_unexp_error;
654: ELSIF l_return_status = FND_API.g_ret_sts_error
655: AND x_return_status <> FND_API.g_ret_sts_unexp_error THEN
656: x_return_status := FND_API.g_ret_sts_error;
657: END IF;
658:
659: END LOOP;

Line 656: x_return_status := FND_API.g_ret_sts_error;

652: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
653: x_return_status := FND_API.g_ret_sts_unexp_error;
654: ELSIF l_return_status = FND_API.g_ret_sts_error
655: AND x_return_status <> FND_API.g_ret_sts_unexp_error THEN
656: x_return_status := FND_API.g_ret_sts_error;
657: END IF;
658:
659: END LOOP;
660: END IF;

Line 664: IF FND_API.to_boolean(p_commit) THEN

660: END IF;
661:
662: -- Check if the caller requested to commit ,
663: -- If p_commit set to true, commit the transaction
664: IF FND_API.to_boolean(p_commit) THEN
665: COMMIT;
666: END IF;
667:
668: -- Standard call to get message count and if count is 1, get message info

Line 670: p_encoded => FND_API.g_false,

666: END IF;
667:
668: -- Standard call to get message count and if count is 1, get message info
669: FND_MSG_PUB.count_and_get(
670: p_encoded => FND_API.g_false,
671: p_count => x_msg_count,
672: p_data => x_msg_data
673: );
674:

Line 678: WHEN FND_API.g_exc_error THEN

674:
675:
676: EXCEPTION
677:
678: WHEN FND_API.g_exc_error THEN
679: ROLLBACK TO save_attachment_grp;
680: x_return_status := FND_API.g_ret_sts_error;
681: FND_MSG_PUB.count_and_get(
682: p_encoded => FND_API.g_false,

Line 680: x_return_status := FND_API.g_ret_sts_error;

676: EXCEPTION
677:
678: WHEN FND_API.g_exc_error THEN
679: ROLLBACK TO save_attachment_grp;
680: x_return_status := FND_API.g_ret_sts_error;
681: FND_MSG_PUB.count_and_get(
682: p_encoded => FND_API.g_false,
683: p_count => x_msg_count,
684: p_data => x_msg_data

Line 682: p_encoded => FND_API.g_false,

678: WHEN FND_API.g_exc_error THEN
679: ROLLBACK TO save_attachment_grp;
680: x_return_status := FND_API.g_ret_sts_error;
681: FND_MSG_PUB.count_and_get(
682: p_encoded => FND_API.g_false,
683: p_count => x_msg_count,
684: p_data => x_msg_data
685: );
686:

Line 687: WHEN FND_API.g_exc_unexpected_error THEN

683: p_count => x_msg_count,
684: p_data => x_msg_data
685: );
686:
687: WHEN FND_API.g_exc_unexpected_error THEN
688: ROLLBACK TO save_attachment_grp;
689: x_return_status := FND_API.g_ret_sts_unexp_error ;
690: FND_MSG_PUB.count_and_get(
691: p_encoded => FND_API.g_false,

Line 689: x_return_status := FND_API.g_ret_sts_unexp_error ;

685: );
686:
687: WHEN FND_API.g_exc_unexpected_error THEN
688: ROLLBACK TO save_attachment_grp;
689: x_return_status := FND_API.g_ret_sts_unexp_error ;
690: FND_MSG_PUB.count_and_get(
691: p_encoded => FND_API.g_false,
692: p_count => x_msg_count,
693: p_data => x_msg_data

Line 691: p_encoded => FND_API.g_false,

687: WHEN FND_API.g_exc_unexpected_error THEN
688: ROLLBACK TO save_attachment_grp;
689: x_return_status := FND_API.g_ret_sts_unexp_error ;
690: FND_MSG_PUB.count_and_get(
691: p_encoded => FND_API.g_false,
692: p_count => x_msg_count,
693: p_data => x_msg_data
694: );
695:

Line 698: x_return_status := FND_API.g_ret_sts_unexp_error ;

694: );
695:
696: WHEN OTHERS THEN
697: ROLLBACK TO save_attachment_grp;
698: x_return_status := FND_API.g_ret_sts_unexp_error ;
699: FND_MSG_PUB.count_and_get(
700: p_encoded => FND_API.g_false,
701: p_count => x_msg_count,
702: p_data => x_msg_data

Line 700: p_encoded => FND_API.g_false,

696: WHEN OTHERS THEN
697: ROLLBACK TO save_attachment_grp;
698: x_return_status := FND_API.g_ret_sts_unexp_error ;
699: FND_MSG_PUB.count_and_get(
700: p_encoded => FND_API.g_false,
701: p_count => x_msg_count,
702: p_data => x_msg_data
703: );
704:

Line 705: x_return_status := FND_API.g_ret_sts_unexp_error ;

701: p_count => x_msg_count,
702: p_data => x_msg_data
703: );
704:
705: x_return_status := FND_API.g_ret_sts_unexp_error ;
706:
707: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
708: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
709: END IF;

Line 712: p_encoded => FND_API.g_false,

708: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
709: END IF;
710:
711: FND_MSG_PUB.count_and_get(
712: p_encoded => FND_API.g_false,
713: p_count => x_msg_count,
714: p_data => x_msg_data
715: );
716:

Line 740: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

736: -- 3. Raise an exception for any other errors
737: ---------------------------------------------------------------------
738: PROCEDURE delete_attachment (
739: p_api_version IN NUMBER,
740: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
741: p_commit IN VARCHAR2 := FND_API.g_false,
742: x_return_status OUT NOCOPY VARCHAR2,
743: x_msg_count OUT NOCOPY NUMBER,
744: x_msg_data OUT NOCOPY VARCHAR2,

Line 741: p_commit IN VARCHAR2 := FND_API.g_false,

737: ---------------------------------------------------------------------
738: PROCEDURE delete_attachment (
739: p_api_version IN NUMBER,
740: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
741: p_commit IN VARCHAR2 := FND_API.g_false,
742: x_return_status OUT NOCOPY VARCHAR2,
743: x_msg_count OUT NOCOPY NUMBER,
744: x_msg_data OUT NOCOPY VARCHAR2,
745: p_ath_id_ver_tbl IN OUT NOCOPY ATH_ID_VER_TBL_TYPE ) IS

Line 762: IF NOT FND_API.compatible_api_call(

758: -- Standard start of API savepoint
759: SAVEPOINT save_attachment_grp;
760:
761: -- Standard call to check for call compatibility
762: IF NOT FND_API.compatible_api_call(
763: g_api_version,
764: p_api_version,
765: l_api_name,
766: g_pkg_name

Line 768: RAISE FND_API.g_exc_unexpected_error;

764: p_api_version,
765: l_api_name,
766: g_pkg_name
767: ) THEN
768: RAISE FND_API.g_exc_unexpected_error;
769: END IF;
770:
771: -- Initialize message list if p_init_msg_list is set to TRUE
772: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 772: IF FND_API.to_boolean(p_init_msg_list) THEN

768: RAISE FND_API.g_exc_unexpected_error;
769: END IF;
770:
771: -- Initialize message list if p_init_msg_list is set to TRUE
772: IF FND_API.to_boolean(p_init_msg_list) THEN
773: FND_MSG_PUB.initialize;
774: END IF;
775:
776: -- Initialize API rturn status to success

Line 777: x_return_status := FND_API.g_ret_sts_success;

773: FND_MSG_PUB.initialize;
774: END IF;
775:
776: -- Initialize API rturn status to success
777: x_return_status := FND_API.g_ret_sts_success;
778:
779: -- API body
780:
781: IF p_ath_id_ver_tbl IS NOT NULL THEN

Line 790: := FND_API.g_ret_sts_error;

786: SAVEPOINT delete_one_attachment_grp;
787:
788: /*
789: p_ath_id_ver_tbl(l_index).x_action_status
790: := FND_API.g_ret_sts_error;
791: */
792:
793: IF NOT IBE_DSPMGRVALIDATION_GRP.check_attachment_exists(
794: p_ath_id_ver_tbl(l_index).attachment_id,

Line 796: RAISE FND_API.g_exc_error;

792:
793: IF NOT IBE_DSPMGRVALIDATION_GRP.check_attachment_exists(
794: p_ath_id_ver_tbl(l_index).attachment_id,
795: p_ath_id_ver_tbl(l_index).object_version_number) THEN
796: RAISE FND_API.g_exc_error;
797: END IF;
798:
799: IBE_PhysicalMap_GRP.delete_attachment(
800: p_ath_id_ver_tbl(l_index).attachment_id

Line 832: IF l_return_status = FND_API.g_ret_sts_error THEN

828: END IF;
829: END IF;
830:
831:
832: IF l_return_status = FND_API.g_ret_sts_error THEN
833: RAISE FND_API.g_exc_error;
834: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
835: RAISE FND_API.g_exc_unexpected_error;
836: END IF;

Line 833: RAISE FND_API.g_exc_error;

829: END IF;
830:
831:
832: IF l_return_status = FND_API.g_ret_sts_error THEN
833: RAISE FND_API.g_exc_error;
834: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
835: RAISE FND_API.g_exc_unexpected_error;
836: END IF;
837:

Line 834: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

830:
831:
832: IF l_return_status = FND_API.g_ret_sts_error THEN
833: RAISE FND_API.g_exc_error;
834: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
835: RAISE FND_API.g_exc_unexpected_error;
836: END IF;
837:
838: p_ath_id_ver_tbl(l_index).x_action_status

Line 835: RAISE FND_API.g_exc_unexpected_error;

831:
832: IF l_return_status = FND_API.g_ret_sts_error THEN
833: RAISE FND_API.g_exc_error;
834: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
835: RAISE FND_API.g_exc_unexpected_error;
836: END IF;
837:
838: p_ath_id_ver_tbl(l_index).x_action_status
839: := FND_API.g_ret_sts_success;

Line 839: := FND_API.g_ret_sts_success;

835: RAISE FND_API.g_exc_unexpected_error;
836: END IF;
837:
838: p_ath_id_ver_tbl(l_index).x_action_status
839: := FND_API.g_ret_sts_success;
840:
841: EXCEPTION
842:
843: WHEN FND_API.g_exc_error THEN

Line 843: WHEN FND_API.g_exc_error THEN

839: := FND_API.g_ret_sts_success;
840:
841: EXCEPTION
842:
843: WHEN FND_API.g_exc_error THEN
844: ROLLBACK TO delete_one_attachment_grp;
845: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
846: x_return_status := FND_API.g_ret_sts_error;
847: END IF;

Line 845: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN

841: EXCEPTION
842:
843: WHEN FND_API.g_exc_error THEN
844: ROLLBACK TO delete_one_attachment_grp;
845: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
846: x_return_status := FND_API.g_ret_sts_error;
847: END IF;
848: p_ath_id_ver_tbl(l_index).x_action_status
849: := FND_API.g_ret_sts_error;

Line 846: x_return_status := FND_API.g_ret_sts_error;

842:
843: WHEN FND_API.g_exc_error THEN
844: ROLLBACK TO delete_one_attachment_grp;
845: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
846: x_return_status := FND_API.g_ret_sts_error;
847: END IF;
848: p_ath_id_ver_tbl(l_index).x_action_status
849: := FND_API.g_ret_sts_error;
850:

Line 849: := FND_API.g_ret_sts_error;

845: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
846: x_return_status := FND_API.g_ret_sts_error;
847: END IF;
848: p_ath_id_ver_tbl(l_index).x_action_status
849: := FND_API.g_ret_sts_error;
850:
851: WHEN FND_API.g_exc_unexpected_error THEN
852: ROLLBACK TO delete_one_attachment_grp;
853: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 851: WHEN FND_API.g_exc_unexpected_error THEN

847: END IF;
848: p_ath_id_ver_tbl(l_index).x_action_status
849: := FND_API.g_ret_sts_error;
850:
851: WHEN FND_API.g_exc_unexpected_error THEN
852: ROLLBACK TO delete_one_attachment_grp;
853: x_return_status := FND_API.g_ret_sts_unexp_error ;
854: p_ath_id_ver_tbl(l_index).x_action_status
855: := FND_API.g_ret_sts_unexp_error ;

Line 853: x_return_status := FND_API.g_ret_sts_unexp_error ;

849: := FND_API.g_ret_sts_error;
850:
851: WHEN FND_API.g_exc_unexpected_error THEN
852: ROLLBACK TO delete_one_attachment_grp;
853: x_return_status := FND_API.g_ret_sts_unexp_error ;
854: p_ath_id_ver_tbl(l_index).x_action_status
855: := FND_API.g_ret_sts_unexp_error ;
856:
857: WHEN OTHERS THEN

Line 855: := FND_API.g_ret_sts_unexp_error ;

851: WHEN FND_API.g_exc_unexpected_error THEN
852: ROLLBACK TO delete_one_attachment_grp;
853: x_return_status := FND_API.g_ret_sts_unexp_error ;
854: p_ath_id_ver_tbl(l_index).x_action_status
855: := FND_API.g_ret_sts_unexp_error ;
856:
857: WHEN OTHERS THEN
858: ROLLBACK TO delete_one_attachment_grp;
859: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 859: x_return_status := FND_API.g_ret_sts_unexp_error ;

855: := FND_API.g_ret_sts_unexp_error ;
856:
857: WHEN OTHERS THEN
858: ROLLBACK TO delete_one_attachment_grp;
859: x_return_status := FND_API.g_ret_sts_unexp_error ;
860: p_ath_id_ver_tbl(l_index).x_action_status
861: := FND_API.g_ret_sts_unexp_error ;
862: IF FND_MSG_PUB.check_msg_level(
863: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 861: := FND_API.g_ret_sts_unexp_error ;

857: WHEN OTHERS THEN
858: ROLLBACK TO delete_one_attachment_grp;
859: x_return_status := FND_API.g_ret_sts_unexp_error ;
860: p_ath_id_ver_tbl(l_index).x_action_status
861: := FND_API.g_ret_sts_unexp_error ;
862: IF FND_MSG_PUB.check_msg_level(
863: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
864: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
865: END IF;

Line 873: IF FND_API.to_boolean(p_commit) THEN

869: END IF;
870:
871: -- Check if the caller requested to commit ,
872: -- If p_commit set to true, commit the transaction
873: IF FND_API.to_boolean(p_commit) THEN
874: COMMIT;
875: END IF;
876:
877: -- Standard call to get message count and if count is 1, get message info

Line 879: p_encoded => FND_API.g_false,

875: END IF;
876:
877: -- Standard call to get message count and if count is 1, get message info
878: FND_MSG_PUB.count_and_get(
879: p_encoded => FND_API.g_false,
880: p_count => x_msg_count,
881: p_data => x_msg_data
882: );
883: -- x_msg_count := FND_MSG_PUB.count_msg();

Line 884: -- x_msg_data := FND_MSG_PUB.get(FND_MSG_PUB.g_last, FND_API.g_false);

880: p_count => x_msg_count,
881: p_data => x_msg_data
882: );
883: -- x_msg_count := FND_MSG_PUB.count_msg();
884: -- x_msg_data := FND_MSG_PUB.get(FND_MSG_PUB.g_last, FND_API.g_false);
885:
886: EXCEPTION
887:
888: WHEN FND_API.g_exc_error THEN

Line 888: WHEN FND_API.g_exc_error THEN

884: -- x_msg_data := FND_MSG_PUB.get(FND_MSG_PUB.g_last, FND_API.g_false);
885:
886: EXCEPTION
887:
888: WHEN FND_API.g_exc_error THEN
889: ROLLBACK TO delete_attachment_grp;
890: x_return_status := FND_API.g_ret_sts_error;
891: FND_MSG_PUB.count_and_get(
892: p_encoded => FND_API.g_false,

Line 890: x_return_status := FND_API.g_ret_sts_error;

886: EXCEPTION
887:
888: WHEN FND_API.g_exc_error THEN
889: ROLLBACK TO delete_attachment_grp;
890: x_return_status := FND_API.g_ret_sts_error;
891: FND_MSG_PUB.count_and_get(
892: p_encoded => FND_API.g_false,
893: p_count => x_msg_count,
894: p_data => x_msg_data

Line 892: p_encoded => FND_API.g_false,

888: WHEN FND_API.g_exc_error THEN
889: ROLLBACK TO delete_attachment_grp;
890: x_return_status := FND_API.g_ret_sts_error;
891: FND_MSG_PUB.count_and_get(
892: p_encoded => FND_API.g_false,
893: p_count => x_msg_count,
894: p_data => x_msg_data
895: );
896:

Line 897: WHEN FND_API.g_exc_unexpected_error THEN

893: p_count => x_msg_count,
894: p_data => x_msg_data
895: );
896:
897: WHEN FND_API.g_exc_unexpected_error THEN
898: ROLLBACK TO delete_attachment_grp;
899: x_return_status := FND_API.g_ret_sts_unexp_error ;
900: FND_MSG_PUB.count_and_get(
901: p_encoded => FND_API.g_false,

Line 899: x_return_status := FND_API.g_ret_sts_unexp_error ;

895: );
896:
897: WHEN FND_API.g_exc_unexpected_error THEN
898: ROLLBACK TO delete_attachment_grp;
899: x_return_status := FND_API.g_ret_sts_unexp_error ;
900: FND_MSG_PUB.count_and_get(
901: p_encoded => FND_API.g_false,
902: p_count => x_msg_count,
903: p_data => x_msg_data

Line 901: p_encoded => FND_API.g_false,

897: WHEN FND_API.g_exc_unexpected_error THEN
898: ROLLBACK TO delete_attachment_grp;
899: x_return_status := FND_API.g_ret_sts_unexp_error ;
900: FND_MSG_PUB.count_and_get(
901: p_encoded => FND_API.g_false,
902: p_count => x_msg_count,
903: p_data => x_msg_data
904: );
905:

Line 908: x_return_status := FND_API.g_ret_sts_unexp_error ;

904: );
905:
906: WHEN OTHERS THEN
907: ROLLBACK TO delete_attachment_grp;
908: x_return_status := FND_API.g_ret_sts_unexp_error ;
909:
910: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
911: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
912: END IF;

Line 915: p_encoded => FND_API.g_false,

911: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
912: END IF;
913:
914: FND_MSG_PUB.count_and_get(
915: p_encoded => FND_API.g_false,
916: p_count => x_msg_count,
917: p_data => x_msg_data
918: );
919: