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_OUTCOME_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_outcome(
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_outcome_Rec IN camp_outcome_Rec_Type := G_MISS_camp_outcome_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_outcome(
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_outcome_Rec IN camp_outcome_Rec_Type := G_MISS_camp_outcome_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_outcome(
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_outcome_Rec IN camp_outcome_Rec_Type := G_MISS_camp_outcome_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 60: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 69: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 80: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 97: RAISE FND_API.G_EXC_ERROR;

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

Line 147: IF FND_API.to_Boolean( p_commit )

143: -- End of API body
144: --
145:
146: -- Standard check for p_commit
147: IF FND_API.to_Boolean( p_commit )
148: THEN
149: COMMIT WORK;
150: END IF;
151:

Line 163: WHEN FND_API.G_EXC_ERROR THEN

159: p_data => x_msg_data
160: );
161:
162: EXCEPTION
163: WHEN FND_API.G_EXC_ERROR THEN
164: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
165: P_API_NAME => L_API_NAME
166: ,P_PKG_NAME => G_PKG_NAME
167: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

169: ,X_MSG_COUNT => X_MSG_COUNT
170: ,X_MSG_DATA => X_MSG_DATA
171: ,X_RETURN_STATUS => X_RETURN_STATUS);
172:
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
175: P_API_NAME => L_API_NAME
176: ,P_PKG_NAME => G_PKG_NAME
177: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

195: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
196: -- The Master delete procedure may not be needed depends on different business requirements.
197: PROCEDURE Delete_camp_outcome(
198: P_Api_Version_Number IN NUMBER,
199: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
200: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: P_camp_outcome_Rec IN camp_outcome_Rec_Type,
203: X_Return_Status OUT VARCHAR2,

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

196: -- The Master delete procedure may not be needed depends on different business requirements.
197: PROCEDURE Delete_camp_outcome(
198: P_Api_Version_Number IN NUMBER,
199: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
200: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: P_camp_outcome_Rec IN camp_outcome_Rec_Type,
203: X_Return_Status OUT VARCHAR2,
204: X_Msg_Count OUT NUMBER,

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

197: PROCEDURE Delete_camp_outcome(
198: P_Api_Version_Number IN NUMBER,
199: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
200: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: P_camp_outcome_Rec IN camp_outcome_Rec_Type,
203: X_Return_Status OUT VARCHAR2,
204: X_Msg_Count OUT NUMBER,
205: X_Msg_Data OUT VARCHAR2

Line 217: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

213: -- Standard Start of API savepoint
214: SAVEPOINT DELETE_camp_outcome_PVT;
215:
216: -- Standard call to check for call compatibility.
217: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
218: p_api_version_number,
219: l_api_name,
220: G_PKG_NAME)
221: THEN

Line 222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

218: p_api_version_number,
219: l_api_name,
220: G_PKG_NAME)
221: THEN
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: END IF;
224:
225:
226: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 227: IF FND_API.to_Boolean( p_init_msg_list )

223: END IF;
224:
225:
226: -- Initialize message list if p_init_msg_list is set to TRUE.
227: IF FND_API.to_Boolean( p_init_msg_list )
228: THEN
229: FND_MSG_PUB.initialize;
230: END IF;
231:

Line 239: x_return_status := FND_API.G_RET_STS_SUCCESS;

235:
236:
237:
238: -- Initialize API return status to SUCCESS
239: x_return_status := FND_API.G_RET_STS_SUCCESS;
240:
241: --
242: -- Api body
243: --

Line 251: IF FND_API.to_Boolean( p_commit )

247: AND source_code = l_camp_outcome_Rec.source_code
248: AND object_id = l_camp_outcome_Rec.object_id;
249:
250: -- Standard check for p_commit
251: IF FND_API.to_Boolean( p_commit )
252: THEN
253: COMMIT WORK;
254: END IF;
255:

Line 269: WHEN FND_API.G_EXC_ERROR THEN

265: p_data => x_msg_data
266: );
267:
268: EXCEPTION
269: WHEN FND_API.G_EXC_ERROR THEN
270: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
271: P_API_NAME => L_API_NAME
272: ,P_PKG_NAME => G_PKG_NAME
273: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

275: ,X_MSG_COUNT => X_MSG_COUNT
276: ,X_MSG_DATA => X_MSG_DATA
277: ,X_RETURN_STATUS => X_RETURN_STATUS);
278:
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
281: P_API_NAME => L_API_NAME
282: ,P_PKG_NAME => G_PKG_NAME
283: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

298: End Delete_camp_outcome;
299:
300: PROCEDURE Save_Change(
301: P_Api_Version_Number IN NUMBER,
302: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
303: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
304: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
305: X_Return_Status OUT VARCHAR2,
306: X_Msg_Count OUT NUMBER,

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

299:
300: PROCEDURE Save_Change(
301: P_Api_Version_Number IN NUMBER,
302: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
303: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
304: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
305: X_Return_Status OUT VARCHAR2,
306: X_Msg_Count OUT NUMBER,
307: X_Msg_Data OUT VARCHAR2

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

300: PROCEDURE Save_Change(
301: P_Api_Version_Number IN NUMBER,
302: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
303: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
304: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
305: X_Return_Status OUT VARCHAR2,
306: X_Msg_Count OUT NUMBER,
307: X_Msg_Data OUT VARCHAR2
308: )

Line 318: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

314: -- Standard Start of API savepoint
315: SAVEPOINT Save_Change_PVT;
316:
317: -- Standard call to check for call compatibility.
318: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
319: p_api_version_number,
320: l_api_name,
321: G_PKG_NAME)
322: THEN

Line 323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

319: p_api_version_number,
320: l_api_name,
321: G_PKG_NAME)
322: THEN
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: END IF;
325:
326:
327: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 328: IF FND_API.to_Boolean( p_init_msg_list )

324: END IF;
325:
326:
327: -- Initialize message list if p_init_msg_list is set to TRUE.
328: IF FND_API.to_Boolean( p_init_msg_list )
329: THEN
330: FND_MSG_PUB.initialize;
331: END IF;
332:

Line 340: x_return_status := FND_API.G_RET_STS_SUCCESS;

336:
337:
338:
339: -- Initialize API return status to SUCCESS
340: x_return_status := FND_API.G_RET_STS_SUCCESS;
341:
342: --
343: -- Api body
344: --

Line 347: IF FND_API.to_Boolean( p_commit )

343: -- Api body
344: --
345:
346: -- Standard check for p_commit
347: IF FND_API.to_Boolean( p_commit )
348: THEN
349: COMMIT WORK;
350: END IF;
351:

Line 365: WHEN FND_API.G_EXC_ERROR THEN

361: p_data => x_msg_data
362: );
363:
364: EXCEPTION
365: WHEN FND_API.G_EXC_ERROR THEN
366: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
367: P_API_NAME => L_API_NAME
368: ,P_PKG_NAME => G_PKG_NAME
369: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

371: ,X_MSG_COUNT => X_MSG_COUNT
372: ,X_MSG_DATA => X_MSG_DATA
373: ,X_RETURN_STATUS => X_RETURN_STATUS);
374:
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
376: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
377: P_API_NAME => L_API_NAME
378: ,P_PKG_NAME => G_PKG_NAME
379: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

394: End Save_Change;
395:
396: PROCEDURE Save_Defaults(
397: P_Api_Version_Number IN NUMBER,
398: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
399: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
400: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
401: p_object_id IN NUMBER,
402: p_outcome_id IN NUMBER,

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

395:
396: PROCEDURE Save_Defaults(
397: P_Api_Version_Number IN NUMBER,
398: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
399: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
400: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
401: p_object_id IN NUMBER,
402: p_outcome_id IN NUMBER,
403: p_result_id IN NUMBER,

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

396: PROCEDURE Save_Defaults(
397: P_Api_Version_Number IN NUMBER,
398: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
399: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
400: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
401: p_object_id IN NUMBER,
402: p_outcome_id IN NUMBER,
403: p_result_id IN NUMBER,
404: p_reason_id IN NUMBER,

Line 428: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

424: -- Standard Start of API savepoint
425: SAVEPOINT Save_Change_PVT;
426:
427: -- Standard call to check for call compatibility.
428: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
429: p_api_version_number,
430: l_api_name,
431: G_PKG_NAME)
432: THEN

Line 433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

429: p_api_version_number,
430: l_api_name,
431: G_PKG_NAME)
432: THEN
433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
434: END IF;
435:
436:
437: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 438: IF FND_API.to_Boolean( p_init_msg_list )

434: END IF;
435:
436:
437: -- Initialize message list if p_init_msg_list is set to TRUE.
438: IF FND_API.to_Boolean( p_init_msg_list )
439: THEN
440: FND_MSG_PUB.initialize;
441: END IF;
442:

Line 449: x_return_status := FND_API.G_RET_STS_SUCCESS;

445: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
446: 'AST', 'Private API: ' || l_api_name || 'start');
447:
448: -- Initialize API return status to SUCCESS
449: x_return_status := FND_API.G_RET_STS_SUCCESS;
450:
451: --
452: -- Api body
453: --

Line 506: IF FND_API.to_Boolean( p_commit )

502: Close Wrapup_Camp;
503: end if;
504:
505: -- Standard check for p_commit
506: IF FND_API.to_Boolean( p_commit )
507: THEN
508: COMMIT WORK;
509: END IF;
510:

Line 523: WHEN FND_API.G_EXC_ERROR THEN

519: p_data => x_msg_data
520: );
521:
522: EXCEPTION
523: WHEN FND_API.G_EXC_ERROR THEN
524: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
525: P_API_NAME => L_API_NAME
526: ,P_PKG_NAME => G_PKG_NAME
527: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

529: ,X_MSG_COUNT => X_MSG_COUNT
530: ,X_MSG_DATA => X_MSG_DATA
531: ,X_RETURN_STATUS => X_RETURN_STATUS);
532:
533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
534: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
535: P_API_NAME => L_API_NAME
536: ,P_PKG_NAME => G_PKG_NAME
537: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

552: End Save_Defaults;
553:
554: PROCEDURE Reset_Change(
555: P_Api_Version_Number IN NUMBER,
556: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
557: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
558: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
559: X_Return_Status OUT VARCHAR2,
560: X_Msg_Count OUT NUMBER,

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

553:
554: PROCEDURE Reset_Change(
555: P_Api_Version_Number IN NUMBER,
556: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
557: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
558: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
559: X_Return_Status OUT VARCHAR2,
560: X_Msg_Count OUT NUMBER,
561: X_Msg_Data OUT VARCHAR2

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

554: PROCEDURE Reset_Change(
555: P_Api_Version_Number IN NUMBER,
556: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
557: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
558: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
559: X_Return_Status OUT VARCHAR2,
560: X_Msg_Count OUT NUMBER,
561: X_Msg_Data OUT VARCHAR2
562: )

Line 572: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

568: -- Standard Start of API savepoint
569: SAVEPOINT Save_Change_PVT;
570:
571: -- Standard call to check for call compatibility.
572: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
573: p_api_version_number,
574: l_api_name,
575: G_PKG_NAME)
576: THEN

Line 577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

573: p_api_version_number,
574: l_api_name,
575: G_PKG_NAME)
576: THEN
577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
578: END IF;
579:
580:
581: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 582: IF FND_API.to_Boolean( p_init_msg_list )

578: END IF;
579:
580:
581: -- Initialize message list if p_init_msg_list is set to TRUE.
582: IF FND_API.to_Boolean( p_init_msg_list )
583: THEN
584: FND_MSG_PUB.initialize;
585: END IF;
586:

Line 594: x_return_status := FND_API.G_RET_STS_SUCCESS;

590:
591:
592:
593: -- Initialize API return status to SUCCESS
594: x_return_status := FND_API.G_RET_STS_SUCCESS;
595:
596: --
597: -- Api body
598: --

Line 602: IF FND_API.to_Boolean( p_commit )

598: --
599: ROLLBACK;
600:
601: -- Standard check for p_commit
602: IF FND_API.to_Boolean( p_commit )
603: THEN
604: COMMIT WORK;
605: END IF;
606:

Line 620: WHEN FND_API.G_EXC_ERROR THEN

616: p_data => x_msg_data
617: );
618:
619: EXCEPTION
620: WHEN FND_API.G_EXC_ERROR THEN
621: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
622: P_API_NAME => L_API_NAME
623: ,P_PKG_NAME => G_PKG_NAME
624: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

626: ,X_MSG_COUNT => X_MSG_COUNT
627: ,X_MSG_DATA => X_MSG_DATA
628: ,X_RETURN_STATUS => X_RETURN_STATUS);
629:
630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
631: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
632: P_API_NAME => L_API_NAME
633: ,P_PKG_NAME => G_PKG_NAME
634: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR