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

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

19: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
20:
21: PROCEDURE Create_timeframe(
22: P_Api_Version_Number IN NUMBER,
23: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
24: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
26: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
27: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

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

20:
21: PROCEDURE Create_timeframe(
22: P_Api_Version_Number IN NUMBER,
23: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
24: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
26: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
27: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
28: P_Admin_Group_Id IN NUMBER,

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

21: PROCEDURE Create_timeframe(
22: P_Api_Version_Number IN NUMBER,
23: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
24: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
26: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
27: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
28: P_Admin_Group_Id IN NUMBER,
29: P_Identity_Salesforce_Id IN NUMBER,

Line 26: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,

22: P_Api_Version_Number IN NUMBER,
23: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
24: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
26: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
27: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
28: P_Admin_Group_Id IN NUMBER,
29: P_Identity_Salesforce_Id IN NUMBER,
30: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

Line 27: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

23: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
24: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
26: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
27: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
28: P_Admin_Group_Id IN NUMBER,
29: P_Identity_Salesforce_Id IN NUMBER,
30: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
31: P_timeframe_Rec IN AML_TIMEFRAME_PUB.timeframe_Rec_Type ,

Line 59: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

55: -- Standard Start of API savepoint
56: SAVEPOINT CREATE_TIMEFRAME_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:
68: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 69: IF FND_API.to_Boolean( p_init_msg_list )

65: END IF;
66:
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 83: x_return_status := FND_API.G_RET_STS_SUCCESS;

79: END IF;
80:
81:
82: -- Initialize API return status to SUCCESS
83: x_return_status := FND_API.G_RET_STS_SUCCESS;
84:
85: l_timeframe_rec := p_timeframe_rec;
86:
87: --

Line 104: RAISE FND_API.G_EXC_ERROR;

100: --dbms_output.put_line('duplicate found ');
101: FND_MESSAGE.SET_NAME('AS', 'AS_DUPE_TIMEFRAME');
102: -- Add message to API message list
103: FND_MSG_PUB.Add;
104: RAISE FND_API.G_EXC_ERROR;
105: END IF;
106: CLOSE c1;
107:
108: END IF;

Line 123: p_init_msg_list => FND_API.G_FALSE,

119:
120:
121:
122: Validate_DECN_TIMEFRAME_CODE(
123: p_init_msg_list => FND_API.G_FALSE,
124: p_validation_mode => AS_UTILITY_PVT.G_CREATE,
125: p_decision_timeframe_code => l_timeframe_rec.DECISION_TIMEFRAME_CODE,
126: x_return_status => x_return_status,
127: x_msg_count => x_msg_count,

Line 129: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

125: p_decision_timeframe_code => l_timeframe_rec.DECISION_TIMEFRAME_CODE,
126: x_return_status => x_return_status,
127: x_msg_count => x_msg_count,
128: x_msg_data => x_msg_data);
129: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
130: raise FND_API.G_EXC_ERROR;
131: END IF;
132:
133:

Line 130: raise FND_API.G_EXC_ERROR;

126: x_return_status => x_return_status,
127: x_msg_count => x_msg_count,
128: x_msg_data => x_msg_data);
129: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
130: raise FND_API.G_EXC_ERROR;
131: END IF;
132:
133:
134:

Line 137: P_Init_Msg_List => FND_API.G_FALSE,

133:
134:
135: -- Check the timeframe days
136: Validate_TIMEFRAME_DAYS(
137: P_Init_Msg_List => FND_API.G_FALSE,
138: P_Validation_mode => AS_UTILITY_PVT.G_CREATE,
139: p_timeframe_days => l_timeframe_rec.timeframe_days,
140: X_Return_Status => x_return_status,
141: X_Msg_Count => x_msg_count,

Line 145: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

141: X_Msg_Count => x_msg_count,
142: X_Msg_Data => x_msg_data
143: );
144:
145: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
146: RAISE FND_API.G_EXC_ERROR;
147: END IF;
148:
149:

Line 146: RAISE FND_API.G_EXC_ERROR;

142: X_Msg_Data => x_msg_data
143: );
144:
145: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
146: RAISE FND_API.G_EXC_ERROR;
147: END IF;
148:
149:
150: -- Debug Message

Line 175: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

171: );
172: -- Hint: Primary key should be returned.
173: -- x_TIMEFRAME_ID := px_TIMEFRAME_ID;
174:
175: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
176: RAISE FND_API.G_EXC_ERROR;
177: END IF;
178:
179: --

Line 176: RAISE FND_API.G_EXC_ERROR;

172: -- Hint: Primary key should be returned.
173: -- x_TIMEFRAME_ID := px_TIMEFRAME_ID;
174:
175: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
176: RAISE FND_API.G_EXC_ERROR;
177: END IF;
178:
179: --
180: -- End of API body

Line 184: IF FND_API.to_Boolean( p_commit )

180: -- End of API body
181: --
182:
183: -- Standard check for p_commit
184: IF FND_API.to_Boolean( p_commit )
185: THEN
186: COMMIT WORK;
187: END IF;
188:

Line 204: WHEN FND_API.G_EXC_ERROR THEN

200: p_data => x_msg_data
201: );
202:
203: EXCEPTION
204: WHEN FND_API.G_EXC_ERROR THEN
205: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
206: P_API_NAME => L_API_NAME
207: ,P_PKG_NAME => G_PKG_NAME
208: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

210: ,X_MSG_COUNT => X_MSG_COUNT
211: ,X_MSG_DATA => X_MSG_DATA
212: ,X_RETURN_STATUS => X_RETURN_STATUS);
213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
216: P_API_NAME => L_API_NAME
217: ,P_PKG_NAME => G_PKG_NAME
218: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

237:
238: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
239: PROCEDURE Update_timeframe(
240: P_Api_Version_Number IN NUMBER,
241: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
242: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
245: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

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

238: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
239: PROCEDURE Update_timeframe(
240: P_Api_Version_Number IN NUMBER,
241: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
242: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
245: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
246: P_Admin_Group_Id IN NUMBER,

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

239: PROCEDURE Update_timeframe(
240: P_Api_Version_Number IN NUMBER,
241: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
242: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
245: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
246: P_Admin_Group_Id IN NUMBER,
247: P_Identity_Salesforce_Id IN NUMBER,

Line 244: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,

240: P_Api_Version_Number IN NUMBER,
241: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
242: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
245: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
246: P_Admin_Group_Id IN NUMBER,
247: P_Identity_Salesforce_Id IN NUMBER,
248: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

Line 245: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

241: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
242: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
245: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
246: P_Admin_Group_Id IN NUMBER,
247: P_Identity_Salesforce_Id IN NUMBER,
248: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
249: P_timeframe_Rec IN AML_TIMEFRAME_PUB.timeframe_Rec_Type,

Line 287: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

283: -- Standard Start of API savepoint
284: SAVEPOINT UPDATE_TIMEFRAME_PVT;
285:
286: -- Standard call to check for call compatibility.
287: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
288: p_api_version_number,
289: l_api_name,
290: G_PKG_NAME)
291: THEN

Line 292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

288: p_api_version_number,
289: l_api_name,
290: G_PKG_NAME)
291: THEN
292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
293: END IF;
294:
295:
296: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 297: IF FND_API.to_Boolean( p_init_msg_list )

293: END IF;
294:
295:
296: -- Initialize message list if p_init_msg_list is set to TRUE.
297: IF FND_API.to_Boolean( p_init_msg_list )
298: THEN
299: FND_MSG_PUB.initialize;
300: END IF;
301:

Line 312: x_return_status := FND_API.G_RET_STS_SUCCESS;

308:
309:
310:
311: -- Initialize API return status to SUCCESS
312: x_return_status := FND_API.G_RET_STS_SUCCESS;
313:
314: --
315: -- Api body
316: --

Line 328: l_tar_timeframe_rec.last_update_date = FND_API.G_MISS_Date ) Then

324: END IF;
325:
326:
327: If (l_tar_timeframe_rec.last_update_date is NULL or
328: l_tar_timeframe_rec.last_update_date = FND_API.G_MISS_Date ) Then
329: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
330: THEN
331: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
332: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

Line 335: raise FND_API.G_EXC_ERROR;

331: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
332: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
333: FND_MSG_PUB.ADD;
334: END IF;
335: raise FND_API.G_EXC_ERROR;
336: End if;
337: -- Check Whether record has been changed by someone else
338: If (l_tar_timeframe_rec.last_update_date <> l_ref_timeframe_rec.last_update_date) Then
339: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 345: raise FND_API.G_EXC_ERROR;

341: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
342: FND_MESSAGE.Set_Token('INFO', 'timeframe', FALSE);
343: FND_MSG_PUB.ADD;
344: END IF;
345: raise FND_API.G_EXC_ERROR;
346: End if;
347:
348: -- Debug message
349: IF (AS_DEBUG_LOW_ON) THEN

Line 376: p_init_msg_list => FND_API.G_FALSE,

372:
373:
374:
375: Validate_DECN_TIMEFRAME_CODE(
376: p_init_msg_list => FND_API.G_FALSE,
377: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
378: p_decision_timeframe_code => l_tar_timeframe_rec.DECISION_TIMEFRAME_CODE,
379: x_return_status => x_return_status,
380: x_msg_count => x_msg_count,

Line 382: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

378: p_decision_timeframe_code => l_tar_timeframe_rec.DECISION_TIMEFRAME_CODE,
379: x_return_status => x_return_status,
380: x_msg_count => x_msg_count,
381: x_msg_data => x_msg_data);
382: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
383: raise FND_API.G_EXC_ERROR;
384: END IF;
385:
386:

Line 383: raise FND_API.G_EXC_ERROR;

379: x_return_status => x_return_status,
380: x_msg_count => x_msg_count,
381: x_msg_data => x_msg_data);
382: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
383: raise FND_API.G_EXC_ERROR;
384: END IF;
385:
386:
387:

Line 390: P_Init_Msg_List => FND_API.G_FALSE,

386:
387:
388: -- Check the timeframe days
389: Validate_TIMEFRAME_DAYS(
390: P_Init_Msg_List => FND_API.G_FALSE,
391: P_Validation_mode => AS_UTILITY_PVT.G_UPDATE,
392: p_timeframe_days => l_tar_timeframe_rec.timeframe_days,
393: X_Return_Status => x_return_status,
394: X_Msg_Count => x_msg_count,

Line 398: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

394: X_Msg_Count => x_msg_count,
395: X_Msg_Data => x_msg_data
396: );
397:
398: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
399: RAISE FND_API.G_EXC_ERROR;
400: END IF;
401:
402:

Line 399: RAISE FND_API.G_EXC_ERROR;

395: X_Msg_Data => x_msg_data
396: );
397:
398: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
399: RAISE FND_API.G_EXC_ERROR;
400: END IF;
401:
402:
403:

Line 414: RAISE FND_API.G_EXC_ERROR;

410: --dbms_output.put_line('duplicate found ');
411: FND_MESSAGE.SET_NAME('AS', 'AS_DUPE_TIMEFRAME');
412: -- Add message to API message list
413: FND_MSG_PUB.Add;
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;
416: CLOSE c1;
417:
418: END IF;

Line 449: IF FND_API.to_Boolean( p_commit )

445: -- End of API body.
446: --
447:
448: -- Standard check for p_commit
449: IF FND_API.to_Boolean( p_commit )
450: THEN
451: COMMIT WORK;
452: END IF;
453:

Line 469: WHEN FND_API.G_EXC_ERROR THEN

465: p_data => x_msg_data
466: );
467:
468: EXCEPTION
469: WHEN FND_API.G_EXC_ERROR THEN
470: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
471: P_API_NAME => L_API_NAME
472: ,P_PKG_NAME => G_PKG_NAME
473: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

475: ,X_MSG_COUNT => X_MSG_COUNT
476: ,X_MSG_DATA => X_MSG_DATA
477: ,X_RETURN_STATUS => X_RETURN_STATUS);
478:
479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
480: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
481: P_API_NAME => L_API_NAME
482: ,P_PKG_NAME => G_PKG_NAME
483: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

503: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
504: -- The Master delete procedure may not be needed depends on different business requirements.
505: PROCEDURE Delete_timeframe(
506: P_Api_Version_Number IN NUMBER,
507: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
508: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
509: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
510: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
511: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

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

504: -- The Master delete procedure may not be needed depends on different business requirements.
505: PROCEDURE Delete_timeframe(
506: P_Api_Version_Number IN NUMBER,
507: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
508: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
509: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
510: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
511: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
512: P_Admin_Group_Id IN NUMBER,

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

505: PROCEDURE Delete_timeframe(
506: P_Api_Version_Number IN NUMBER,
507: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
508: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
509: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
510: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
511: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
512: P_Admin_Group_Id IN NUMBER,
513: P_Identity_Salesforce_Id IN NUMBER,

Line 510: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,

506: P_Api_Version_Number IN NUMBER,
507: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
508: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
509: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
510: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
511: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
512: P_Admin_Group_Id IN NUMBER,
513: P_Identity_Salesforce_Id IN NUMBER,
514: P_Profile_Tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

Line 511: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

507: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
508: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
509: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
510: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
511: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
512: P_Admin_Group_Id IN NUMBER,
513: P_Identity_Salesforce_Id IN NUMBER,
514: P_Profile_Tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
515: P_timeframe_Rec IN AML_TIMEFRAME_PUB.timeframe_Rec_Type,

Line 530: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

526: -- Standard Start of API savepoint
527: SAVEPOINT DELETE_TIMEFRAME_PVT;
528:
529: -- Standard call to check for call compatibility.
530: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
531: p_api_version_number,
532: l_api_name,
533: G_PKG_NAME)
534: THEN

Line 535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

531: p_api_version_number,
532: l_api_name,
533: G_PKG_NAME)
534: THEN
535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
536: END IF;
537:
538:
539: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 540: IF FND_API.to_Boolean( p_init_msg_list )

536: END IF;
537:
538:
539: -- Initialize message list if p_init_msg_list is set to TRUE.
540: IF FND_API.to_Boolean( p_init_msg_list )
541: THEN
542: FND_MSG_PUB.initialize;
543: END IF;
544:

Line 554: x_return_status := FND_API.G_RET_STS_SUCCESS;

550: END IF;
551:
552:
553: -- Initialize API return status to SUCCESS
554: x_return_status := FND_API.G_RET_STS_SUCCESS;
555:
556: --
557: -- Api body
558: --

Line 566: RAISE FND_API.G_EXC_ERROR;

562: if (p_timeframe_rec.TIMEFRAME_ID < 10000) then
563: FND_MESSAGE.SET_NAME('AS', 'AS_SEEDED_TIMEFRAME_NO_DELETE');
564: -- Add message to API message list
565: FND_MSG_PUB.Add;
566: RAISE FND_API.G_EXC_ERROR;
567:
568: end if;
569:
570: -- Do not allow deletion of enabled timeframes. Disabling them is fine

Line 576: RAISE FND_API.G_EXC_ERROR;

572: if (p_timeframe_rec.ENABLED_FLAG = 'Y') then
573: FND_MESSAGE.SET_NAME('AS', 'AS_ENABLED_TIMEFRAME_NO_DELETE');
574: -- Add message to API message list
575: FND_MSG_PUB.Add;
576: RAISE FND_API.G_EXC_ERROR;
577:
578: end if;
579:
580:

Line 596: IF FND_API.to_Boolean( p_commit )

592: -- End of API body
593: --
594:
595: -- Standard check for p_commit
596: IF FND_API.to_Boolean( p_commit )
597: THEN
598: COMMIT WORK;
599: END IF;
600:

Line 616: WHEN FND_API.G_EXC_ERROR THEN

612: p_data => x_msg_data
613: );
614:
615: EXCEPTION
616: WHEN FND_API.G_EXC_ERROR THEN
617: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
618: P_API_NAME => L_API_NAME
619: ,P_PKG_NAME => G_PKG_NAME
620: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

622: ,X_MSG_COUNT => X_MSG_COUNT
623: ,X_MSG_DATA => X_MSG_DATA
624: ,X_RETURN_STATUS => X_RETURN_STATUS);
625:
626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
627: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
628: P_API_NAME => L_API_NAME
629: ,P_PKG_NAME => G_PKG_NAME
630: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

648:
649:
650: -- Item-level validation procedures
651: PROCEDURE Validate_TIMEFRAME_ID (
652: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
653: P_Validation_mode IN VARCHAR2,
654: P_TIMEFRAME_ID IN NUMBER,
655: -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
656: X_Return_Status OUT NOCOPY VARCHAR2,

Line 664: IF FND_API.to_Boolean( p_init_msg_list )

660: IS
661: BEGIN
662:
663: -- Initialize message list if p_init_msg_list is set to TRUE.
664: IF FND_API.to_Boolean( p_init_msg_list )
665: THEN
666: FND_MSG_PUB.initialize;
667: END IF;
668:

Line 671: x_return_status := FND_API.G_RET_STS_SUCCESS;

667: END IF;
668:
669:
670: -- Initialize API return status to SUCCESS
671: x_return_status := FND_API.G_RET_STS_SUCCESS;
672:
673: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
674: THEN
675: -- Hint: Validate data

Line 678: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

674: THEN
675: -- Hint: Validate data
676: -- IF p_TIMEFRAME_ID is not NULL and p_TIMEFRAME_ID <> G_MISS_CHAR
677: -- verify if data is valid
678: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
679: NULL;
680: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
681: THEN
682: -- Hint: Validate data

Line 685: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

681: THEN
682: -- Hint: Validate data
683: -- IF p_TIMEFRAME_ID <> G_MISS_CHAR
684: -- verify if data is valid
685: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
686: NULL;
687: END IF;
688:
689: -- Standard call to get message count and if count is 1, get message info.

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

696:
697:
698:
699: PROCEDURE Validate_DECN_TIMEFRAME_CODE (
700: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
701: P_Validation_mode IN VARCHAR2,
702: P_DECISION_TIMEFRAME_CODE IN VARCHAR2,
703: -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
704: X_Return_Status OUT NOCOPY VARCHAR2,

Line 721: IF FND_API.to_Boolean( p_init_msg_list )

717: l_val VARCHAR2(1);
718: BEGIN
719:
720: -- Initialize message list if p_init_msg_list is set to TRUE.
721: IF FND_API.to_Boolean( p_init_msg_list )
722: THEN
723: FND_MSG_PUB.initialize;
724: END IF;
725:

Line 728: x_return_status := FND_API.G_RET_STS_SUCCESS;

724: END IF;
725:
726:
727: -- Initialize API return status to SUCCESS
728: x_return_status := FND_API.G_RET_STS_SUCCESS;
729:
730:
731: IF (p_decision_timeframe_code is NOT NULL
732: AND p_decision_timeframe_code <> FND_API.G_MISS_CHAR) THEN

Line 732: AND p_decision_timeframe_code <> FND_API.G_MISS_CHAR) THEN

728: x_return_status := FND_API.G_RET_STS_SUCCESS;
729:
730:
731: IF (p_decision_timeframe_code is NOT NULL
732: AND p_decision_timeframe_code <> FND_API.G_MISS_CHAR) THEN
733: OPEN C_Lookup_Exists ( p_decision_timeframe_code, 'DECISION_TIMEFRAME');
734: FETCH C_Lookup_Exists into l_val;
735:
736: IF C_Lookup_Exists%NOTFOUND

Line 746: x_return_status := FND_API.G_RET_STS_ERROR;

742: p_token1_value => 'DECISION TIMEFRAME_CODE',
743: p_token2 => 'VALUE',
744: p_token2_value => p_DECISION_TIMEFRAME_CODE );
745:
746: x_return_status := FND_API.G_RET_STS_ERROR;
747: END IF;
748: CLOSE C_Lookup_Exists;
749: END IF;
750:

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

760: END Validate_DECN_TIMEFRAME_CODE;
761:
762:
763: PROCEDURE Validate_TIMEFRAME_DAYS (
764: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
765: P_Validation_mode IN VARCHAR2,
766: P_TIMEFRAME_DAYS IN NUMBER,
767: -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
768: X_Return_Status OUT NOCOPY VARCHAR2,

Line 776: IF FND_API.to_Boolean( p_init_msg_list )

772: IS
773: BEGIN
774:
775: -- Initialize message list if p_init_msg_list is set to TRUE.
776: IF FND_API.to_Boolean( p_init_msg_list )
777: THEN
778: FND_MSG_PUB.initialize;
779: END IF;
780:

Line 783: x_return_status := FND_API.G_RET_STS_SUCCESS;

779: END IF;
780:
781:
782: -- Initialize API return status to SUCCESS
783: x_return_status := FND_API.G_RET_STS_SUCCESS;
784:
785: IF (p_timeframe_days is NOT NULL
786: AND p_timeframe_days < 0 ) THEN
787:

Line 796: x_return_status := FND_API.G_RET_STS_ERROR;

792: p_token1_value => 'TIMEFRAME_DAYS',
793: p_token2 => 'VALUE',
794: p_token2_value => p_TIMEFRAME_DAYS );
795:
796: x_return_status := FND_API.G_RET_STS_ERROR;
797: END IF;
798:
799: -- Standard call to get message count and if count is 1, get message info.
800: FND_MSG_PUB.Count_And_Get