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

Line 29: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

25:
26: -- Hint: Primary key needs to be returned.
27: PROCEDURE Create_camp_result(
28: P_Api_Version_Number IN NUMBER,
29: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
30: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: P_camp_result_Rec IN camp_result_Rec_Type := G_MISS_camp_result_REC,
33: --Hint: Add detail tables as parameter lists if it's master-detail relationship.

Line 30: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

26: -- Hint: Primary key needs to be returned.
27: PROCEDURE Create_camp_result(
28: P_Api_Version_Number IN NUMBER,
29: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
30: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: P_camp_result_Rec IN camp_result_Rec_Type := G_MISS_camp_result_REC,
33: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
34: X_Return_Status OUT VARCHAR2,

Line 31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

27: PROCEDURE Create_camp_result(
28: P_Api_Version_Number IN NUMBER,
29: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
30: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: P_camp_result_Rec IN camp_result_Rec_Type := G_MISS_camp_result_REC,
33: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
34: X_Return_Status OUT VARCHAR2,
35: X_Msg_Count OUT NUMBER,

Line 59: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

55: -- Standard Start of API savepoint
56: SAVEPOINT CREATE_camp_result_PVT;
57:
58: -- Standard call to check for call compatibility.
59: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
60: p_api_version_number,
61: l_api_name,
62: G_PKG_NAME)
63: THEN

Line 64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

60: p_api_version_number,
61: l_api_name,
62: G_PKG_NAME)
63: THEN
64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
65: END IF;
66:
67: -- Initialize message list if p_init_msg_list is set to TRUE.
68: IF FND_API.to_Boolean( p_init_msg_list )

Line 68: IF FND_API.to_Boolean( p_init_msg_list )

64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
65: END IF;
66:
67: -- Initialize message list if p_init_msg_list is set to TRUE.
68: IF FND_API.to_Boolean( p_init_msg_list )
69: THEN
70: FND_MSG_PUB.initialize;
71: END IF;
72:

Line 79: x_return_status := FND_API.G_RET_STS_SUCCESS;

75: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
76:
77:
78: -- Initialize API return status to SUCCESS
79: x_return_status := FND_API.G_RET_STS_SUCCESS;
80:
81: --
82: -- API body
83: --

Line 96: RAISE FND_API.G_EXC_ERROR;

92: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
93: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
94: FND_MSG_PUB.ADD;
95: END IF;
96: RAISE FND_API.G_EXC_ERROR;
97: END IF;
98:
99:
100: OPEN cur_source;

Line 138: IF FND_API.to_Boolean( p_commit )

134: -- End of API body
135: --
136:
137: -- Standard check for p_commit
138: IF FND_API.to_Boolean( p_commit )
139: THEN
140: COMMIT WORK;
141: END IF;
142:

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: JTF_PLSQL_API.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: JTF_PLSQL_API.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

Line 190: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

186: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
187: -- The Master delete procedure may not be needed depends on different business requirements.
188: PROCEDURE Delete_camp_result(
189: P_Api_Version_Number IN NUMBER,
190: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
191: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193: P_camp_result_Rec IN camp_result_Rec_Type,
194: X_Return_Status OUT VARCHAR2,

Line 191: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

187: -- The Master delete procedure may not be needed depends on different business requirements.
188: PROCEDURE Delete_camp_result(
189: P_Api_Version_Number IN NUMBER,
190: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
191: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193: P_camp_result_Rec IN camp_result_Rec_Type,
194: X_Return_Status OUT VARCHAR2,
195: X_Msg_Count OUT NUMBER,

Line 192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

188: PROCEDURE Delete_camp_result(
189: P_Api_Version_Number IN NUMBER,
190: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
191: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193: P_camp_result_Rec IN camp_result_Rec_Type,
194: X_Return_Status OUT VARCHAR2,
195: X_Msg_Count OUT NUMBER,
196: X_Msg_Data OUT VARCHAR2

Line 208: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

204: -- Standard Start of API savepoint
205: SAVEPOINT DELETE_camp_result_PVT;
206:
207: -- Standard call to check for call compatibility.
208: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
209: p_api_version_number,
210: l_api_name,
211: G_PKG_NAME)
212: THEN

Line 213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

209: p_api_version_number,
210: l_api_name,
211: G_PKG_NAME)
212: THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215:
216:
217: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 218: IF FND_API.to_Boolean( p_init_msg_list )

214: END IF;
215:
216:
217: -- Initialize message list if p_init_msg_list is set to TRUE.
218: IF FND_API.to_Boolean( p_init_msg_list )
219: THEN
220: FND_MSG_PUB.initialize;
221: END IF;
222:

Line 230: x_return_status := FND_API.G_RET_STS_SUCCESS;

226:
227:
228:
229: -- Initialize API return status to SUCCESS
230: x_return_status := FND_API.G_RET_STS_SUCCESS;
231:
232: --
233: -- Api body
234: --

Line 242: IF FND_API.to_Boolean( p_commit )

238: AND source_code = l_camp_result_Rec.source_code
239: AND object_id = l_camp_result_Rec.object_id;
240:
241: -- Standard check for p_commit
242: IF FND_API.to_Boolean( p_commit )
243: THEN
244: COMMIT WORK;
245: END IF;
246:

Line 260: WHEN FND_API.G_EXC_ERROR THEN

256: p_data => x_msg_data
257: );
258:
259: EXCEPTION
260: WHEN FND_API.G_EXC_ERROR THEN
261: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
262: P_API_NAME => L_API_NAME
263: ,P_PKG_NAME => G_PKG_NAME
264: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

266: ,X_MSG_COUNT => X_MSG_COUNT
267: ,X_MSG_DATA => X_MSG_DATA
268: ,X_RETURN_STATUS => X_RETURN_STATUS);
269:
270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
271: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
272: P_API_NAME => L_API_NAME
273: ,P_PKG_NAME => G_PKG_NAME
274: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR