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

Line 18: l_commit VARCHAR2(5) := FND_API.G_TRUE;

14: X_MSG_DATA out NOCOPY varchar2) IS
15:
16: l_api_version NUMBER := 1.0;
17: l_api_name CONSTANT VARCHAR2(30) := 'SR_SINGLE_REQUEST';
18: l_commit VARCHAR2(5) := FND_API.G_TRUE;
19: --
20:
21: l_content_id VARCHAR2(30);
22: fulfillment_user_note VARCHAR2(2000);

Line 650: x_return_status := FND_API.G_RET_STS_SUCCESS;

646: end if;
647: CLOSE cs_platform_csr ;
648:
649: --initialize return status to success before call to
650: x_return_status := FND_API.G_RET_STS_SUCCESS;
651:
652:
653: -- Start the fulfillment request. The output request_id must be passed
654: -- to all subsequent calls made for this request.

Line 666: --if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

662: );
663:
664: -- test for failure
665:
666: --if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
667: -- 11/10/03. rmanabat . Should check for l_return_status, not x_return_status.
668: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
669: --DBMS_OUTPUT.PUT_LINE('fail');
670: raise FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 668: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

664: -- test for failure
665:
666: --if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
667: -- 11/10/03. rmanabat . Should check for l_return_status, not x_return_status.
668: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
669: --DBMS_OUTPUT.PUT_LINE('fail');
670: raise FND_API.G_EXC_UNEXPECTED_ERROR ;
671: end if;
672:

Line 670: raise FND_API.G_EXC_UNEXPECTED_ERROR ;

666: --if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
667: -- 11/10/03. rmanabat . Should check for l_return_status, not x_return_status.
668: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
669: --DBMS_OUTPUT.PUT_LINE('fail');
670: raise FND_API.G_EXC_UNEXPECTED_ERROR ;
671: end if;
672:
673: --DBMS_OUTPUT.PUT_LINE('Request_ID: '||to_char(l_request_id));
674:

Line 860: x_return_status := FND_API.G_RET_STS_SUCCESS;

856: --l_subject := 'Service Request Details'; --commented this for bug 4527968 prayadur.
857: l_subject := P_SUBJECT ; --Added this for bug 4527968 prayadur.
858:
859: --initialize return status to success before call to
860: x_return_status := FND_API.G_RET_STS_SUCCESS;
861:
862:
863: -- Start of Fix for bug 3251623 . prayadur . 02/25/04
864: -- Removed the XML getting created and instead calling GET_CONTENT_XML

Line 876: p_content_nm => FND_API.G_MISS_CHAR, -- using default value.

872: x_msg_count => l_msg_count,
873: x_msg_data => l_msg_data,
874: p_content_id => 1000,
875: --p_content_nm => l_content_nm,
876: p_content_nm => FND_API.G_MISS_CHAR, -- using default value.
877: p_document_type => l_document_type,
878: /**** source code says this is deprecated, but using html as stated in bug.
879: p_document_type => FND_API.G_MISS_CHAR,
880: *****/

Line 879: p_document_type => FND_API.G_MISS_CHAR,

875: --p_content_nm => l_content_nm,
876: p_content_nm => FND_API.G_MISS_CHAR, -- using default value.
877: p_document_type => l_document_type,
878: /**** source code says this is deprecated, but using html as stated in bug.
879: p_document_type => FND_API.G_MISS_CHAR,
880: *****/
881: p_media_type => l_media_type,
882: p_printer => null,
883: p_email => l_email,

Line 894: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

890: p_bind_var_type => l_bind_var_type,
891: p_request_id => l_request_id,
892: x_content_xml => l_content_xml);
893:
894: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
895: --DBMS_OUTPUT.PUT_LINE('fail');
896: raise FND_API.G_EXC_UNEXPECTED_ERROR ;
897: end if;
898:

Line 896: raise FND_API.G_EXC_UNEXPECTED_ERROR ;

892: x_content_xml => l_content_xml);
893:
894: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
895: --DBMS_OUTPUT.PUT_LINE('fail');
896: raise FND_API.G_EXC_UNEXPECTED_ERROR ;
897: end if;
898:
899: -- End of fix for bug 3251623.
900:

Line 926: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

922:
923: -- this is for testing failure
924: -- x_return_status := 'F';
925:
926: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
927: raise FND_API.G_EXC_UNEXPECTED_ERROR ;
928: else
929: -- if successful then display request id to user
930: FND_MESSAGE.Set_Name('CS','CS_SR_FULFIL_REQUEST');

Line 927: raise FND_API.G_EXC_UNEXPECTED_ERROR ;

923: -- this is for testing failure
924: -- x_return_status := 'F';
925:
926: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
927: raise FND_API.G_EXC_UNEXPECTED_ERROR ;
928: else
929: -- if successful then display request id to user
930: FND_MESSAGE.Set_Name('CS','CS_SR_FULFIL_REQUEST');
931: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);

Line 942: WHEN FND_API.G_EXC_ERROR THEN

938: );
939:
940: EXCEPTION
941:
942: WHEN FND_API.G_EXC_ERROR THEN
943: x_return_status := FND_API.G_RET_STS_ERROR;
944: FND_MSG_PUB.Count_And_Get
945: ( p_count => x_msg_count,
946: p_data => x_msg_data

Line 943: x_return_status := FND_API.G_RET_STS_ERROR;

939:
940: EXCEPTION
941:
942: WHEN FND_API.G_EXC_ERROR THEN
943: x_return_status := FND_API.G_RET_STS_ERROR;
944: FND_MSG_PUB.Count_And_Get
945: ( p_count => x_msg_count,
946: p_data => x_msg_data
947: );

Line 948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

944: FND_MSG_PUB.Count_And_Get
945: ( p_count => x_msg_count,
946: p_data => x_msg_data
947: );
948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
950: FND_MSG_PUB.Count_And_Get
951: ( p_count => x_msg_count,
952: p_data => x_msg_data

Line 949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

945: ( p_count => x_msg_count,
946: p_data => x_msg_data
947: );
948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
950: FND_MSG_PUB.Count_And_Get
951: ( p_count => x_msg_count,
952: p_data => x_msg_data
953: );

Line 955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

951: ( p_count => x_msg_count,
952: p_data => x_msg_data
953: );
954: WHEN OTHERS THEN
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
956: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
957: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
958: END IF;
959: FND_MSG_PUB.Count_And_Get

Line 984: l_commit VARCHAR2(5) := FND_API.G_TRUE;

980: --
981:
982: l_api_version NUMBER := 1.0;
983: l_api_name CONSTANT VARCHAR2(30) := 'SR_RESUBMIT_REQUEST';
984: l_commit VARCHAR2(5) := FND_API.G_TRUE;
985: l_msg_count NUMBER;
986: l_msg_data VARCHAR2(5000);
987: l_return_status VARCHAR2(1000);
988: l_request_id NUMBER;

Line 992: x_return_status := FND_API.G_RET_STS_SUCCESS;

988: l_request_id NUMBER;
989:
990: --initialize return status to success before call
991: BEGIN
992: x_return_status := FND_API.G_RET_STS_SUCCESS;
993:
994: -- Resubmit the fulfillment request
995:
996: JTF_FM_REQUEST_GRP.Resubmit_Request( p_api_version => l_api_version,

Line 1004: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

1000: x_msg_data => l_msg_data,
1001: p_request_id => l_request_id
1002: );
1003:
1004: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1005: raise FND_API.G_EXC_UNEXPECTED_ERROR ;
1006: else
1007: --if successful then display request id to user
1008: FND_MESSAGE.Set_Name('CS','CS_SR_FULFIL_REQUEST');

Line 1005: raise FND_API.G_EXC_UNEXPECTED_ERROR ;

1001: p_request_id => l_request_id
1002: );
1003:
1004: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1005: raise FND_API.G_EXC_UNEXPECTED_ERROR ;
1006: else
1007: --if successful then display request id to user
1008: FND_MESSAGE.Set_Name('CS','CS_SR_FULFIL_REQUEST');
1009: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);

Line 1019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1015: p_data => x_msg_data
1016: );
1017:
1018: EXCEPTION
1019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1021: FND_MSG_PUB.Count_And_Get
1022: ( p_count => x_msg_count,
1023: p_data => x_msg_data

Line 1020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1016: );
1017:
1018: EXCEPTION
1019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1021: FND_MSG_PUB.Count_And_Get
1022: ( p_count => x_msg_count,
1023: p_data => x_msg_data
1024: );

Line 1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1022: ( p_count => x_msg_count,
1023: p_data => x_msg_data
1024: );
1025: WHEN OTHERS THEN
1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1027: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1028: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1029: END IF;
1030: FND_MSG_PUB.Count_And_Get