DBA Data[Home] [Help]

APPS.AST_SEARCH_RESULT_PVT dependencies on FND_API

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

27: -- Hint: Primary key needs to be returned.
28:
29: PROCEDURE Create_search_result(
30: P_Api_Version_Number IN NUMBER,
31: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
32: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
33: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
34: P_search_result_Rec IN search_result_Rec_Type := G_MISS_search_result_REC,
35: X_Return_Status OUT VARCHAR2,

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

28:
29: PROCEDURE Create_search_result(
30: P_Api_Version_Number IN NUMBER,
31: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
32: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
33: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
34: P_search_result_Rec IN search_result_Rec_Type := G_MISS_search_result_REC,
35: X_Return_Status OUT VARCHAR2,
36: X_Msg_Count OUT NUMBER,

Line 33: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

29: PROCEDURE Create_search_result(
30: P_Api_Version_Number IN NUMBER,
31: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
32: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
33: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
34: P_search_result_Rec IN search_result_Rec_Type := G_MISS_search_result_REC,
35: X_Return_Status OUT VARCHAR2,
36: X_Msg_Count OUT NUMBER,
37: X_Msg_Data OUT VARCHAR2

Line 54: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

50: -- Standard Start of API savepoint
51: SAVEPOINT CREATE_search_result_PVT;
52:
53: -- Standard call to check for call compatibility.
54: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
55: p_api_version_number,
56: l_api_name,
57: G_PKG_NAME)
58: THEN

Line 59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

55: p_api_version_number,
56: l_api_name,
57: G_PKG_NAME)
58: THEN
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61:
62: -- Initialize message list if p_init_msg_list is set to TRUE.
63: IF FND_API.to_Boolean( p_init_msg_list )

Line 63: IF FND_API.to_Boolean( p_init_msg_list )

59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61:
62: -- Initialize message list if p_init_msg_list is set to TRUE.
63: IF FND_API.to_Boolean( p_init_msg_list )
64: THEN
65: FND_MSG_PUB.initialize;
66: END IF;
67:

Line 72: x_return_status := FND_API.G_RET_STS_SUCCESS;

68: -- Debug Message
69: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
70:
71: -- Initialize API return status to SUCCESS
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73:
74: --
75: -- API body
76: --

Line 97: IF FND_API.to_Boolean( p_commit )

93: -- End of API body
94: --
95:
96: -- Standard check for p_commit
97: IF FND_API.to_Boolean( p_commit )
98: THEN
99: COMMIT WORK;
100: END IF;
101:

Line 113: WHEN FND_API.G_EXC_ERROR THEN

109: p_data => x_msg_data
110: );
111:
112: EXCEPTION
113: WHEN FND_API.G_EXC_ERROR THEN
114: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
115: P_API_NAME => L_API_NAME
116: ,P_PKG_NAME => G_PKG_NAME
117: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

119: ,X_MSG_COUNT => X_MSG_COUNT
120: ,X_MSG_DATA => X_MSG_DATA
121: ,X_RETURN_STATUS => X_RETURN_STATUS);
122:
123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
124: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
125: P_API_NAME => L_API_NAME
126: ,P_PKG_NAME => G_PKG_NAME
127: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

142: End Create_search_result;
143:
144: PROCEDURE GET_SEARCH_RESULT(
145: P_Api_Version_Number IN NUMBER,
146: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
147: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER
149: := FND_API.G_VALID_LEVEL_FULL,
150: p_count IN NUMBER,

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

143:
144: PROCEDURE GET_SEARCH_RESULT(
145: P_Api_Version_Number IN NUMBER,
146: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
147: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER
149: := FND_API.G_VALID_LEVEL_FULL,
150: p_count IN NUMBER,
151: x_Search_Result_Rec OUT SEARCH_RESULT_REC_TYPE,

Line 149: := FND_API.G_VALID_LEVEL_FULL,

145: P_Api_Version_Number IN NUMBER,
146: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
147: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER
149: := FND_API.G_VALID_LEVEL_FULL,
150: p_count IN NUMBER,
151: x_Search_Result_Rec OUT SEARCH_RESULT_REC_TYPE,
152: X_Return_Status OUT VARCHAR2,
153: X_Msg_Count OUT NUMBER,

Line 170: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

166: -- Standard Start of API savepoint
167: SAVEPOINT Get_search_result_PVT;
168:
169: -- Standard call to check for call compatibility.
170: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
171: p_api_version_number,
172: l_api_name,
173: G_PKG_NAME)
174: THEN

Line 175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

171: p_api_version_number,
172: l_api_name,
173: G_PKG_NAME)
174: THEN
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END IF;
177:
178: -- Initialize message list if p_init_msg_list is set to TRUE.
179: IF FND_API.to_Boolean( p_init_msg_list )

Line 179: IF FND_API.to_Boolean( p_init_msg_list )

175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END IF;
177:
178: -- Initialize message list if p_init_msg_list is set to TRUE.
179: IF FND_API.to_Boolean( p_init_msg_list )
180: THEN
181: FND_MSG_PUB.initialize;
182: END IF;
183:

Line 188: x_return_status := FND_API.G_RET_STS_SUCCESS;

184: -- Debug Message
185: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
186:
187: -- Initialize API return status to SUCCESS
188: x_return_status := FND_API.G_RET_STS_SUCCESS;
189:
190: --
191: -- API body
192: --

Line 209: IF FND_API.to_Boolean( p_commit )

205: -- End of API body
206: --
207:
208: -- Standard check for p_commit
209: IF FND_API.to_Boolean( p_commit )
210: THEN
211: COMMIT WORK;
212: END IF;
213:

Line 225: WHEN FND_API.G_EXC_ERROR THEN

221: p_data => x_msg_data
222: );
223:
224: EXCEPTION
225: WHEN FND_API.G_EXC_ERROR THEN
226: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
227: P_API_NAME => L_API_NAME
228: ,P_PKG_NAME => G_PKG_NAME
229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

231: ,X_MSG_COUNT => X_MSG_COUNT
232: ,X_MSG_DATA => X_MSG_DATA
233: ,X_RETURN_STATUS => X_RETURN_STATUS);
234:
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
237: P_API_NAME => L_API_NAME
238: ,P_PKG_NAME => G_PKG_NAME
239: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

254: End Get_search_result;
255:
256: PROCEDURE DELETE_SEARCH_RESULT(
257: P_Api_Version_Number IN NUMBER,
258: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
259: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
260: p_validation_level IN NUMBER
261: := FND_API.G_VALID_LEVEL_FULL,
262: X_Return_Status OUT VARCHAR2,

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

255:
256: PROCEDURE DELETE_SEARCH_RESULT(
257: P_Api_Version_Number IN NUMBER,
258: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
259: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
260: p_validation_level IN NUMBER
261: := FND_API.G_VALID_LEVEL_FULL,
262: X_Return_Status OUT VARCHAR2,
263: X_Msg_Count OUT NUMBER,

Line 261: := FND_API.G_VALID_LEVEL_FULL,

257: P_Api_Version_Number IN NUMBER,
258: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
259: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
260: p_validation_level IN NUMBER
261: := FND_API.G_VALID_LEVEL_FULL,
262: X_Return_Status OUT VARCHAR2,
263: X_Msg_Count OUT NUMBER,
264: X_Msg_Data OUT VARCHAR2
265: )

Line 279: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

275: -- Standard Start of API savepoint
276: SAVEPOINT Get_search_result_PVT;
277:
278: -- Standard call to check for call compatibility.
279: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
280: p_api_version_number,
281: l_api_name,
282: G_PKG_NAME)
283: THEN

Line 284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

280: p_api_version_number,
281: l_api_name,
282: G_PKG_NAME)
283: THEN
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END IF;
286:
287: -- Initialize message list if p_init_msg_list is set to TRUE.
288: IF FND_API.to_Boolean( p_init_msg_list )

Line 288: IF FND_API.to_Boolean( p_init_msg_list )

284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END IF;
286:
287: -- Initialize message list if p_init_msg_list is set to TRUE.
288: IF FND_API.to_Boolean( p_init_msg_list )
289: THEN
290: FND_MSG_PUB.initialize;
291: END IF;
292:

Line 297: x_return_status := FND_API.G_RET_STS_SUCCESS;

293: -- Debug Message
294: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
295:
296: -- Initialize API return status to SUCCESS
297: x_return_status := FND_API.G_RET_STS_SUCCESS;
298:
299: --
300: -- API body
301: --

Line 314: IF FND_API.to_Boolean( p_commit )

310: -- End of API body
311: --
312:
313: -- Standard check for p_commit
314: IF FND_API.to_Boolean( p_commit )
315: THEN
316: COMMIT WORK;
317: END IF;
318:

Line 330: WHEN FND_API.G_EXC_ERROR THEN

326: p_data => x_msg_data
327: );
328:
329: EXCEPTION
330: WHEN FND_API.G_EXC_ERROR THEN
331: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
332: P_API_NAME => L_API_NAME
333: ,P_PKG_NAME => G_PKG_NAME
334: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

336: ,X_MSG_COUNT => X_MSG_COUNT
337: ,X_MSG_DATA => X_MSG_DATA
338: ,X_RETURN_STATUS => X_RETURN_STATUS);
339:
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
342: P_API_NAME => L_API_NAME
343: ,P_PKG_NAME => G_PKG_NAME
344: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

359: END;
360:
361: PROCEDURE add_party_id(
362: p_api_version IN NUMBER := 1.0,
363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
364: p_commit IN VARCHAR2 := FND_API.G_FALSE,
365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
366: x_return_status OUT VARCHAR2,
367: x_msg_count OUT NUMBER,

Line 364: p_commit IN VARCHAR2 := FND_API.G_FALSE,

360:
361: PROCEDURE add_party_id(
362: p_api_version IN NUMBER := 1.0,
363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
364: p_commit IN VARCHAR2 := FND_API.G_FALSE,
365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
366: x_return_status OUT VARCHAR2,
367: x_msg_count OUT NUMBER,
368: x_msg_data OUT VARCHAR2,

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

361: PROCEDURE add_party_id(
362: p_api_version IN NUMBER := 1.0,
363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
364: p_commit IN VARCHAR2 := FND_API.G_FALSE,
365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
366: x_return_status OUT VARCHAR2,
367: x_msg_count OUT NUMBER,
368: x_msg_data OUT VARCHAR2,
369: p_search_type IN VARCHAR2,

Line 392: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

388: -- Standard start of API savepoint
389: SAVEPOINT AST_Add_Party_Id;
390:
391: -- Standard call to check for call compatibility
392: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
394: END IF;
395:
396: -- Initialize message list if p_init_msg_list is set to TRUE

Line 393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

389: SAVEPOINT AST_Add_Party_Id;
390:
391: -- Standard call to check for call compatibility
392: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
394: END IF;
395:
396: -- Initialize message list if p_init_msg_list is set to TRUE
397: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 397: IF FND_API.To_Boolean(p_init_msg_list) THEN

393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
394: END IF;
395:
396: -- Initialize message list if p_init_msg_list is set to TRUE
397: IF FND_API.To_Boolean(p_init_msg_list) THEN
398: FND_MSG_PUB.initialize;
399: END IF;
400:
401: -- Initialize API return status to success

Line 402: x_return_status := FND_API.G_RET_STS_SUCCESS;

398: FND_MSG_PUB.initialize;
399: END IF;
400:
401: -- Initialize API return status to success
402: x_return_status := FND_API.G_RET_STS_SUCCESS;
403:
404: -- API body
405: /*
406: l_count := p_party_id_tbl.COUNT;

Line 428: IF FND_API.to_Boolean( p_commit )

424:
425: -- End of API body
426: */
427: -- Standard check for p_commit
428: IF FND_API.to_Boolean( p_commit )
429: THEN
430: COMMIT WORK;
431: END IF;
432:

Line 443: WHEN FND_API.G_EXC_ERROR THEN

439: p_data => x_msg_data
440: );
441:
442: EXCEPTION
443: WHEN FND_API.G_EXC_ERROR THEN
444: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
445: P_API_NAME => L_API_NAME
446: ,P_PKG_NAME => G_PKG_NAME
447: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

449: ,X_MSG_COUNT => X_MSG_COUNT
450: ,X_MSG_DATA => X_MSG_DATA
451: ,X_RETURN_STATUS => X_RETURN_STATUS);
452:
453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
454: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
455: P_API_NAME => L_API_NAME
456: ,P_PKG_NAME => G_PKG_NAME
457: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 477: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

473: END;
474:
475: PROCEDURE get_party_id(
476: p_api_version IN NUMBER := 1.0,
477: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
478: p_commit IN VARCHAR2 := FND_API.G_FALSE,
479: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
480: x_return_status OUT VARCHAR2,
481: x_msg_count OUT NUMBER,

Line 478: p_commit IN VARCHAR2 := FND_API.G_FALSE,

474:
475: PROCEDURE get_party_id(
476: p_api_version IN NUMBER := 1.0,
477: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
478: p_commit IN VARCHAR2 := FND_API.G_FALSE,
479: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
480: x_return_status OUT VARCHAR2,
481: x_msg_count OUT NUMBER,
482: x_msg_data OUT VARCHAR2,

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

475: PROCEDURE get_party_id(
476: p_api_version IN NUMBER := 1.0,
477: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
478: p_commit IN VARCHAR2 := FND_API.G_FALSE,
479: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
480: x_return_status OUT VARCHAR2,
481: x_msg_count OUT NUMBER,
482: x_msg_data OUT VARCHAR2,
483: p_search_type IN VARCHAR2,

Line 501: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

497: -- Standard start of API savepoint
498: SAVEPOINT AST_Get_Party_Id;
499:
500: -- Standard call to check for call compatibility
501: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;
504:
505: -- Initialize message list if p_init_msg_list is set to TRUE

Line 502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

498: SAVEPOINT AST_Get_Party_Id;
499:
500: -- Standard call to check for call compatibility
501: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;
504:
505: -- Initialize message list if p_init_msg_list is set to TRUE
506: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 506: IF FND_API.To_Boolean(p_init_msg_list) THEN

502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;
504:
505: -- Initialize message list if p_init_msg_list is set to TRUE
506: IF FND_API.To_Boolean(p_init_msg_list) THEN
507: FND_MSG_PUB.initialize;
508: END IF;
509:
510: -- Initialize API return status to success

Line 511: x_return_status := FND_API.G_RET_STS_SUCCESS;

507: FND_MSG_PUB.initialize;
508: END IF;
509:
510: -- Initialize API return status to success
511: x_return_status := FND_API.G_RET_STS_SUCCESS;
512:
513: -- API body
514: x := 0;
515: FOR i IN 1..glb_party_id_tbl.COUNT LOOP

Line 528: IF FND_API.to_Boolean( p_commit )

524: x_glb_count := x;
525: -- End of API body
526:
527: -- Standard check for p_commit
528: IF FND_API.to_Boolean( p_commit )
529: THEN
530: COMMIT WORK;
531: END IF;
532:

Line 543: WHEN FND_API.G_EXC_ERROR THEN

539: p_data => x_msg_data
540: );
541:
542: EXCEPTION
543: WHEN FND_API.G_EXC_ERROR THEN
544: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
545: P_API_NAME => L_API_NAME
546: ,P_PKG_NAME => G_PKG_NAME
547: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

549: ,X_MSG_COUNT => X_MSG_COUNT
550: ,X_MSG_DATA => X_MSG_DATA
551: ,X_RETURN_STATUS => X_RETURN_STATUS);
552:
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
555: P_API_NAME => L_API_NAME
556: ,P_PKG_NAME => G_PKG_NAME
557: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR