APPS.ASO_FFM_INT dependencies on FND_API

Line 16: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asoiffmb.pls';
13:
14: PROCEDURE Submit_FFM_Request(
15: P_Api_Version_Number IN NUMBER,
16: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
17: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
18: p_validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: p_ffm_request_rec IN FFM_REQUEST_REC_TYPE,
20: p_ffm_content_tbl IN FFM_CONTENT_TBL_TYPE,

Line 17: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

13:
14: PROCEDURE Submit_FFM_Request(
15: P_Api_Version_Number IN NUMBER,
16: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
17: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
18: p_validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: p_ffm_request_rec IN FFM_REQUEST_REC_TYPE,
20: p_ffm_content_tbl IN FFM_CONTENT_TBL_TYPE,
21: p_bind_tbl IN FFM_Bind_Tbl_Type,

Line 18: p_validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

14: PROCEDURE Submit_FFM_Request(
15: P_Api_Version_Number IN NUMBER,
16: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
17: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
18: p_validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: p_ffm_request_rec IN FFM_REQUEST_REC_TYPE,
20: p_ffm_content_tbl IN FFM_CONTENT_TBL_TYPE,
21: p_bind_tbl IN FFM_Bind_Tbl_Type,
22: X_Request_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 40: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

36: BEGIN
37: SAVEPOINT Submit_FFM_Request_INT;
38:
39: -- Standard call to check for call compatibility.
40: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
41: p_api_version_number,
42: l_api_name,
43: G_PKG_NAME) THEN
44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

40: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
41: p_api_version_number,
42: l_api_name,
43: G_PKG_NAME) THEN
44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
45: END IF;
46:
47: -- Initialize API return status to SUCCESS
48: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 48: x_return_status := FND_API.G_RET_STS_SUCCESS;

44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
45: END IF;
46:
47: -- Initialize API return status to SUCCESS
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49:
50: JTF_FM_REQUEST_GRP.Start_Request(
51: p_api_version => 1.0,
52: p_init_msg_list => FND_API.G_FALSE,

Line 52: p_init_msg_list => FND_API.G_FALSE,

48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49:
50: JTF_FM_REQUEST_GRP.Start_Request(
51: p_api_version => 1.0,
52: p_init_msg_list => FND_API.G_FALSE,
53: p_commit => FND_API.G_FALSE,
54: X_Return_Status => x_Return_Status,
55: X_Msg_Count => x_Msg_Count,
56: X_Msg_Data => x_Msg_Data,

Line 53: p_commit => FND_API.G_FALSE,

49:
50: JTF_FM_REQUEST_GRP.Start_Request(
51: p_api_version => 1.0,
52: p_init_msg_list => FND_API.G_FALSE,
53: p_commit => FND_API.G_FALSE,
54: X_Return_Status => x_Return_Status,
55: X_Msg_Count => x_Msg_Count,
56: X_Msg_Data => x_Msg_Data,
57: X_request_id => x_request_id);

Line 59: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

55: X_Msg_Count => x_Msg_Count,
56: X_Msg_Data => x_Msg_Data,
57: X_request_id => x_request_id);
58:
59: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
60: RAISE FND_API.G_EXC_ERROR;
61: END IF;
62:
63: FOR i IN 1..p_ffm_content_tbl.count LOOP

Line 60: RAISE FND_API.G_EXC_ERROR;

56: X_Msg_Data => x_Msg_Data,
57: X_request_id => x_request_id);
58:
59: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
60: RAISE FND_API.G_EXC_ERROR;
61: END IF;
62:
63: FOR i IN 1..p_ffm_content_tbl.count LOOP
64: l_bind_var_tbl := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;

Line 78: p_init_msg_list => FND_API.G_FALSE,

74: END IF;
75: END LOOP;
76: JTF_FM_REQUEST_GRP.Get_Content_XML(
77: p_api_version => 1.0,
78: p_init_msg_list => FND_API.G_FALSE,
79: p_commit => FND_API.G_FALSE,
80: p_validation_level => p_validation_level,
81: p_content_id => p_ffm_content_tbl(i).content_id,
82: p_content_nm => p_ffm_content_tbl(i).content_name,

Line 79: p_commit => FND_API.G_FALSE,

75: END LOOP;
76: JTF_FM_REQUEST_GRP.Get_Content_XML(
77: p_api_version => 1.0,
78: p_init_msg_list => FND_API.G_FALSE,
79: p_commit => FND_API.G_FALSE,
80: p_validation_level => p_validation_level,
81: p_content_id => p_ffm_content_tbl(i).content_id,
82: p_content_nm => p_ffm_content_tbl(i).content_name,
83: p_document_type => p_ffm_content_tbl(i).document_type,

Line 100: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

96: x_content_xml => l_tmp_content_xml,
97: X_Return_Status => x_Return_Status,
98: X_Msg_Count => x_Msg_Count,
99: X_Msg_Data => x_Msg_Data);
100: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
101: RAISE FND_API.G_EXC_ERROR;
102: END IF;
103: IF (length(l_content_xml)+length(l_tmp_content_xml)) > 2000 THEN
104: x_return_status := FND_API.G_RET_STS_ERROR;

Line 101: RAISE FND_API.G_EXC_ERROR;

97: X_Return_Status => x_Return_Status,
98: X_Msg_Count => x_Msg_Count,
99: X_Msg_Data => x_Msg_Data);
100: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
101: RAISE FND_API.G_EXC_ERROR;
102: END IF;
103: IF (length(l_content_xml)+length(l_tmp_content_xml)) > 2000 THEN
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 104: x_return_status := FND_API.G_RET_STS_ERROR;

100: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
101: RAISE FND_API.G_EXC_ERROR;
102: END IF;
103: IF (length(l_content_xml)+length(l_tmp_content_xml)) > 2000 THEN
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
106: FND_MESSAGE.Set_Name('ASO', 'ASO_API_CONTENT_XML_TOO_LONG');
107: FND_MSG_PUB.ADD;
108: END IF;

Line 109: RAISE FND_API.G_EXC_ERROR;

105: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
106: FND_MESSAGE.Set_Name('ASO', 'ASO_API_CONTENT_XML_TOO_LONG');
107: FND_MSG_PUB.ADD;
108: END IF;
109: RAISE FND_API.G_EXC_ERROR;
110: END IF;
111: l_content_xml := l_content_xml||l_tmp_content_xml;
112: END LOOP;
113: JTF_FM_REQUEST_GRP.Submit_Request(

Line 115: p_init_msg_list => FND_API.G_FALSE,

111: l_content_xml := l_content_xml||l_tmp_content_xml;
112: END LOOP;
113: JTF_FM_REQUEST_GRP.Submit_Request(
114: p_api_version => 1.0,
115: p_init_msg_list => FND_API.G_FALSE,
116: p_commit => FND_API.G_FALSE,
117: p_validation_level => p_validation_level,
118: p_template_id => p_ffm_request_rec.template_id,
119: p_subject => p_ffm_request_rec.subject,

Line 116: p_commit => FND_API.G_FALSE,

112: END LOOP;
113: JTF_FM_REQUEST_GRP.Submit_Request(
114: p_api_version => 1.0,
115: p_init_msg_list => FND_API.G_FALSE,
116: p_commit => FND_API.G_FALSE,
117: p_validation_level => p_validation_level,
118: p_template_id => p_ffm_request_rec.template_id,
119: p_subject => p_ffm_request_rec.subject,
120: p_party_id => p_ffm_request_rec.party_id,

Line 135: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

131: p_request_id => x_request_id,
132: X_Return_Status => x_Return_Status,
133: X_Msg_Count => x_Msg_Count,
134: X_Msg_Data => x_Msg_Data);
135: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
136: RAISE FND_API.G_EXC_ERROR;
137: END IF;
138:
139: -- Standard check for p_commit

Line 136: RAISE FND_API.G_EXC_ERROR;

132: X_Return_Status => x_Return_Status,
133: X_Msg_Count => x_Msg_Count,
134: X_Msg_Data => x_Msg_Data);
135: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
136: RAISE FND_API.G_EXC_ERROR;
137: END IF;
138:
139: -- Standard check for p_commit
140: IF FND_API.to_Boolean( p_commit ) THEN

Line 140: IF FND_API.to_Boolean( p_commit ) THEN

136: RAISE FND_API.G_EXC_ERROR;
137: END IF;
138:
139: -- Standard check for p_commit
140: IF FND_API.to_Boolean( p_commit ) THEN
141: COMMIT WORK;
142: END IF;
143:
144:

Line 154: WHEN FND_API.G_EXC_ERROR THEN

150: p_data => x_msg_data
151: );
152:
153: EXCEPTION
154: WHEN FND_API.G_EXC_ERROR THEN
155: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
156: P_API_NAME => L_API_NAME
157: ,P_PKG_NAME => G_PKG_NAME
158: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

160: ,X_MSG_COUNT => X_MSG_COUNT
161: ,X_MSG_DATA => X_MSG_DATA
162: ,X_RETURN_STATUS => X_RETURN_STATUS);
163:
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
166: P_API_NAME => L_API_NAME
167: ,P_PKG_NAME => G_PKG_NAME
168: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR