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

Line 450: p_commit in varchar2 := fnd_api.G_FALSE,

446: p_pk2_value in varchar2 default null,
447: p_pk3_value in varchar2 default null,
448: p_pk4_value in varchar2 default null,
449: p_pk5_value in varchar2 default null,
450: p_commit in varchar2 := fnd_api.G_FALSE,
451: x_attachment_count out nocopy number,
452:
453: x_return_status out nocopy varchar2,
454:

Line 480: x_return_status := FND_API.G_RET_STS_SUCCESS;

476: oe_debug_pub.add( 'ENTER OE_FND_ATTACHMENTS_PVT.ADD_ATTACHMENTS_AUTOMATIC' , 1 ) ;
477: END IF;
478:
479: -- Initialize API return status to success
480: x_return_status := FND_API.G_RET_STS_SUCCESS;
481:
482: -- Standard call to check for call compatibility
483:
484: IF NOT FND_API.Compatible_API_Call

Line 484: IF NOT FND_API.Compatible_API_Call

480: x_return_status := FND_API.G_RET_STS_SUCCESS;
481:
482: -- Standard call to check for call compatibility
483:
484: IF NOT FND_API.Compatible_API_Call
485: ( l_api_version_number
486: , p_api_version
487: , l_api_name
488: , G_PKG_NAME

Line 491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

487: , l_api_name
488: , G_PKG_NAME
489: )
490: THEN
491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
492: END IF;
493:
494: x_attachment_count := 0;
495:

Line 627: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

623: x_msg_count => x_msg_count,
624: x_msg_data => x_msg_data
625: );
626:
627: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
628: RAISE FND_API.G_EXC_ERROR;
629: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
631: END IF;

Line 628: RAISE FND_API.G_EXC_ERROR;

624: x_msg_data => x_msg_data
625: );
626:
627: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
628: RAISE FND_API.G_EXC_ERROR;
629: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
631: END IF;
632:

Line 629: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

625: );
626:
627: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
628: RAISE FND_API.G_EXC_ERROR;
629: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
631: END IF;
632:
633: i := l_documentTbl.next(i);

Line 630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

626:
627: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
628: RAISE FND_API.G_EXC_ERROR;
629: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
631: END IF;
632:
633: i := l_documentTbl.next(i);
634:

Line 638: x_return_status := FND_API.G_RET_STS_SUCCESS;

634:
635: end loop;
636:
637: x_attachment_count := l_documentTbl.COUNT;
638: x_return_status := FND_API.G_RET_STS_SUCCESS;
639:
640: OE_MSG_PUB.Count_And_Get
641: ( p_count => x_msg_count
642: , p_data => x_msg_data

Line 652: WHEN FND_API.G_EXC_ERROR THEN

648: oe_debug_pub.add( 'EXIT OE_FND_ATTACHMENTS_PVT.ADD_ATTACHMENTS_AUTOMATIC' , 1 ) ;
649: END IF;
650:
651: EXCEPTION
652: WHEN FND_API.G_EXC_ERROR THEN
653: x_return_status := FND_API.G_RET_STS_ERROR;
654: OE_MSG_PUB.Count_And_Get
655: ( p_count => x_msg_count
656: , p_data => x_msg_data

Line 653: x_return_status := FND_API.G_RET_STS_ERROR;

649: END IF;
650:
651: EXCEPTION
652: WHEN FND_API.G_EXC_ERROR THEN
653: x_return_status := FND_API.G_RET_STS_ERROR;
654: OE_MSG_PUB.Count_And_Get
655: ( p_count => x_msg_count
656: , p_data => x_msg_data
657: );

Line 658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

654: OE_MSG_PUB.Count_And_Get
655: ( p_count => x_msg_count
656: , p_data => x_msg_data
657: );
658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
660: OE_MSG_PUB.Count_And_Get
661: ( p_count => x_msg_count
662: , p_data => x_msg_data

Line 659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

655: ( p_count => x_msg_count
656: , p_data => x_msg_data
657: );
658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
660: OE_MSG_PUB.Count_And_Get
661: ( p_count => x_msg_count
662: , p_data => x_msg_data
663: );

Line 671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

667: END IF;
668: IF l_debug_level > 0 THEN
669: oe_debug_pub.add( 'ERROR: '||SUBSTR ( SQLERRM , 1 , 250 ) , 1 ) ;
670: END IF;
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: IF OE_MSG_PUB.Check_Msg_Level
673: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
674: THEN
675: OE_MSG_PUB.Add_Exc_Msg

Line 749: x_return_status := FND_API.G_RET_STS_SUCCESS;

745: --
746: BEGIN
747:
748: -- Initialize API return status to success
749: x_return_status := FND_API.G_RET_STS_SUCCESS;
750:
751: -- Standard call to check for call compatibility
752:
753: IF NOT FND_API.Compatible_API_Call

Line 753: IF NOT FND_API.Compatible_API_Call

749: x_return_status := FND_API.G_RET_STS_SUCCESS;
750:
751: -- Standard call to check for call compatibility
752:
753: IF NOT FND_API.Compatible_API_Call
754: ( l_api_version_number
755: , p_api_version
756: , l_api_name
757: , G_PKG_NAME

Line 760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

756: , l_api_name
757: , G_PKG_NAME
758: )
759: THEN
760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
761: END IF;
762:
763: if ( p_validate_flag = 'Y') then
764:

Line 773: x_return_status := FND_API.G_RET_STS_ERROR;

769: -- invalid document id!
770: close C_DOC;
771: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_DOCUMENT_ID');
772: OE_MSG_PUB.ADD;
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: end if;
775: close C_DOC;
776:
777: end if;

Line 791: RAISE FND_API.G_EXC_ERROR;

787: EXCEPTION
788: WHEN no_data_found THEN
789: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_DOCUMENT_ENTITY');
790: OE_MSG_PUB.ADD;
791: RAISE FND_API.G_EXC_ERROR;
792: END;
793: */
794:
795: -- calculate the sequence number for the document and

Line 896: WHEN FND_API.G_EXC_ERROR THEN

892: , p_data => x_msg_data
893: );
894:
895: EXCEPTION
896: WHEN FND_API.G_EXC_ERROR THEN
897: x_return_status := FND_API.G_RET_STS_ERROR;
898: OE_MSG_PUB.Count_And_Get
899: ( p_count => x_msg_count
900: , p_data => x_msg_data

Line 897: x_return_status := FND_API.G_RET_STS_ERROR;

893: );
894:
895: EXCEPTION
896: WHEN FND_API.G_EXC_ERROR THEN
897: x_return_status := FND_API.G_RET_STS_ERROR;
898: OE_MSG_PUB.Count_And_Get
899: ( p_count => x_msg_count
900: , p_data => x_msg_data
901: );

Line 902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

898: OE_MSG_PUB.Count_And_Get
899: ( p_count => x_msg_count
900: , p_data => x_msg_data
901: );
902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904: OE_MSG_PUB.Count_And_Get
905: ( p_count => x_msg_count
906: , p_data => x_msg_data

Line 903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

899: ( p_count => x_msg_count
900: , p_data => x_msg_data
901: );
902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904: OE_MSG_PUB.Count_And_Get
905: ( p_count => x_msg_count
906: , p_data => x_msg_data
907: );

Line 909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

905: ( p_count => x_msg_count
906: , p_data => x_msg_data
907: );
908: WHEN OTHERS THEN
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
910: IF OE_MSG_PUB.Check_Msg_Level
911: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
912: THEN
913: OE_MSG_PUB.Add_Exc_Msg

Line 962: x_return_status := FND_API.G_RET_STS_SUCCESS;

958: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
959: --
960: BEGIN
961:
962: x_return_status := FND_API.G_RET_STS_SUCCESS;
963:
964: FND_ATTACHED_DOCUMENTS2_PKG.Delete_Attachments
965: (x_entity_name => p_entity_name
966: ,x_pk1_value => p_pk1_value

Line 975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

971: );
972:
973: EXCEPTION
974: WHEN OTHERS THEN
975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
976: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
977: THEN
978: OE_MSG_PUB.Add_Exc_Msg
979: ( G_PKG_NAME