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

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

16: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
17:
18: PROCEDURE Create_selcrit(
19: P_Api_Version_Number IN NUMBER,
20: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
21: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
22: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
23: P_Identity_Resource_Id IN NUMBER,
24: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type := PV_RULE_RECTYPE_PUB.G_MISS_SELCRIT_REC,

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

17:
18: PROCEDURE Create_selcrit(
19: P_Api_Version_Number IN NUMBER,
20: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
21: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
22: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
23: P_Identity_Resource_Id IN NUMBER,
24: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type := PV_RULE_RECTYPE_PUB.G_MISS_SELCRIT_REC,
25: X_SELECTION_CRITERIA_ID OUT NOCOPY NUMBER,

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

18: PROCEDURE Create_selcrit(
19: P_Api_Version_Number IN NUMBER,
20: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
21: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
22: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
23: P_Identity_Resource_Id IN NUMBER,
24: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type := PV_RULE_RECTYPE_PUB.G_MISS_SELCRIT_REC,
25: X_SELECTION_CRITERIA_ID OUT NOCOPY NUMBER,
26: X_Return_Status OUT NOCOPY VARCHAR2,

Line 39: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

35: -- Standard Start of API savepoint
36: SAVEPOINT CREATE_SELCRIT_PUB;
37:
38: -- Standard call to check for call compatibility.
39: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
40: p_api_version_number,
41: l_api_name,
42: G_PKG_NAME)
43: THEN

Line 44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

40: p_api_version_number,
41: l_api_name,
42: G_PKG_NAME)
43: THEN
44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
45: END IF;
46:
47:
48: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 49: IF FND_API.to_Boolean( p_init_msg_list )

45: END IF;
46:
47:
48: -- Initialize message list if p_init_msg_list is set to TRUE.
49: IF FND_API.to_Boolean( p_init_msg_list )
50: THEN
51: FND_MSG_PUB.initialize;
52: END IF;
53:

Line 70: x_return_status := FND_API.G_RET_STS_SUCCESS;

66:
67: END IF;
68:
69: -- Initialize API return status to SUCCESS
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:
72: --
73: -- API body
74: --

Line 79: P_Init_Msg_List => FND_API.G_FALSE,

75:
76: -- Calling Private package: Create_SELCRIT
77: PV_selcrit_PVT.Create_selcrit(
78: P_Api_Version_Number => 2.0,
79: P_Init_Msg_List => FND_API.G_FALSE,
80: P_Commit => FND_API.G_FALSE,
81: P_Validation_Level => P_Validation_Level,
82: P_Identity_Resource_Id => P_Identity_Resource_Id,
83: P_SELCRIT_Rec => p_SELCRIT_Rec ,

Line 80: P_Commit => FND_API.G_FALSE,

76: -- Calling Private package: Create_SELCRIT
77: PV_selcrit_PVT.Create_selcrit(
78: P_Api_Version_Number => 2.0,
79: P_Init_Msg_List => FND_API.G_FALSE,
80: P_Commit => FND_API.G_FALSE,
81: P_Validation_Level => P_Validation_Level,
82: P_Identity_Resource_Id => P_Identity_Resource_Id,
83: P_SELCRIT_Rec => p_SELCRIT_Rec ,
84: X_SELECTION_CRITERIA_ID => x_SELECTION_CRITERIA_ID,

Line 92: IF x_return_status = FND_API.G_RET_STS_ERROR then

88:
89:
90:
91: -- Check return status from the above procedure call
92: IF x_return_status = FND_API.G_RET_STS_ERROR then
93: raise FND_API.G_EXC_ERROR;
94: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
95: raise FND_API.G_EXC_UNEXPECTED_ERROR;
96: END IF;

Line 93: raise FND_API.G_EXC_ERROR;

89:
90:
91: -- Check return status from the above procedure call
92: IF x_return_status = FND_API.G_RET_STS_ERROR then
93: raise FND_API.G_EXC_ERROR;
94: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
95: raise FND_API.G_EXC_UNEXPECTED_ERROR;
96: END IF;
97:

Line 94: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

90:
91: -- Check return status from the above procedure call
92: IF x_return_status = FND_API.G_RET_STS_ERROR then
93: raise FND_API.G_EXC_ERROR;
94: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
95: raise FND_API.G_EXC_UNEXPECTED_ERROR;
96: END IF;
97:
98: --

Line 95: raise FND_API.G_EXC_UNEXPECTED_ERROR;

91: -- Check return status from the above procedure call
92: IF x_return_status = FND_API.G_RET_STS_ERROR then
93: raise FND_API.G_EXC_ERROR;
94: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
95: raise FND_API.G_EXC_UNEXPECTED_ERROR;
96: END IF;
97:
98: --
99: -- End of API body.

Line 103: IF FND_API.to_Boolean( p_commit )

99: -- End of API body.
100: --
101:
102: -- Standard check for p_commit
103: IF FND_API.to_Boolean( p_commit )
104: THEN
105: COMMIT WORK;
106: END IF;
107:

Line 130: WHEN FND_API.G_EXC_ERROR THEN

126: p_data => x_msg_data
127: );
128:
129: EXCEPTION
130: WHEN FND_API.G_EXC_ERROR THEN
131: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
132: P_API_NAME => L_API_NAME
133: ,P_PKG_NAME => G_PKG_NAME
134: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

136: ,X_MSG_COUNT => X_MSG_COUNT
137: ,X_MSG_DATA => X_MSG_DATA
138: ,X_RETURN_STATUS => X_RETURN_STATUS);
139:
140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
141: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
142: P_API_NAME => L_API_NAME
143: ,P_PKG_NAME => G_PKG_NAME
144: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

163:
164: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
165: PROCEDURE Update_selcrit(
166: P_Api_Version_Number IN NUMBER,
167: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
168: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
169: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
170: P_Identity_Resource_Id IN NUMBER,
171: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type,

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

164: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
165: PROCEDURE Update_selcrit(
166: P_Api_Version_Number IN NUMBER,
167: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
168: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
169: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
170: P_Identity_Resource_Id IN NUMBER,
171: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type,
172: X_Return_Status OUT NOCOPY VARCHAR2,

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

165: PROCEDURE Update_selcrit(
166: P_Api_Version_Number IN NUMBER,
167: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
168: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
169: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
170: P_Identity_Resource_Id IN NUMBER,
171: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type,
172: X_Return_Status OUT NOCOPY VARCHAR2,
173: X_Msg_Count OUT NOCOPY NUMBER,

Line 185: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

181: -- Standard Start of API savepoint
182: SAVEPOINT UPDATE_SELCRIT_PUB;
183:
184: -- Standard call to check for call compatibility.
185: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
186: p_api_version_number,
187: l_api_name,
188: G_PKG_NAME)
189: THEN

Line 190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

186: p_api_version_number,
187: l_api_name,
188: G_PKG_NAME)
189: THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: END IF;
192:
193:
194: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 195: IF FND_API.to_Boolean( p_init_msg_list )

191: END IF;
192:
193:
194: -- Initialize message list if p_init_msg_list is set to TRUE.
195: IF FND_API.to_Boolean( p_init_msg_list )
196: THEN
197: FND_MSG_PUB.initialize;
198: END IF;
199:

Line 216: x_return_status := FND_API.G_RET_STS_SUCCESS;

212:
213: END IF;
214:
215: -- Initialize API return status to SUCCESS
216: x_return_status := FND_API.G_RET_STS_SUCCESS;
217:
218: --
219: -- API body
220: --

Line 224: P_Init_Msg_List => FND_API.G_FALSE,

220: --
221:
222: PV_selcrit_PVT.Update_selcrit(
223: P_Api_Version_Number => 2.0,
224: P_Init_Msg_List => FND_API.G_FALSE,
225: P_Commit => p_commit,
226: P_Validation_Level => P_Validation_Level,
227: P_Identity_Resource_Id => P_Identity_Resource_Id,
228: P_SELCRIT_Rec => p_SELCRIT_Rec ,

Line 234: IF x_return_status = FND_API.G_RET_STS_ERROR then

230: X_Msg_Count => x_msg_count,
231: X_Msg_Data => x_msg_data);
232:
233: -- Check return status from the above procedure call
234: IF x_return_status = FND_API.G_RET_STS_ERROR then
235: raise FND_API.G_EXC_ERROR;
236: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
237: raise FND_API.G_EXC_UNEXPECTED_ERROR;
238: END IF;

Line 235: raise FND_API.G_EXC_ERROR;

231: X_Msg_Data => x_msg_data);
232:
233: -- Check return status from the above procedure call
234: IF x_return_status = FND_API.G_RET_STS_ERROR then
235: raise FND_API.G_EXC_ERROR;
236: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
237: raise FND_API.G_EXC_UNEXPECTED_ERROR;
238: END IF;
239:

Line 236: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

232:
233: -- Check return status from the above procedure call
234: IF x_return_status = FND_API.G_RET_STS_ERROR then
235: raise FND_API.G_EXC_ERROR;
236: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
237: raise FND_API.G_EXC_UNEXPECTED_ERROR;
238: END IF;
239:
240: --

Line 237: raise FND_API.G_EXC_UNEXPECTED_ERROR;

233: -- Check return status from the above procedure call
234: IF x_return_status = FND_API.G_RET_STS_ERROR then
235: raise FND_API.G_EXC_ERROR;
236: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
237: raise FND_API.G_EXC_UNEXPECTED_ERROR;
238: END IF;
239:
240: --
241: -- End of API body

Line 245: IF FND_API.to_Boolean( p_commit )

241: -- End of API body
242: --
243:
244: -- Standard check for p_commit
245: IF FND_API.to_Boolean( p_commit )
246: THEN
247: COMMIT WORK;
248: END IF;
249:

Line 272: WHEN FND_API.G_EXC_ERROR THEN

268: p_data => x_msg_data
269: );
270:
271: EXCEPTION
272: WHEN FND_API.G_EXC_ERROR THEN
273: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
274: P_API_NAME => L_API_NAME
275: ,P_PKG_NAME => G_PKG_NAME
276: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

278: ,X_MSG_COUNT => X_MSG_COUNT
279: ,X_MSG_DATA => X_MSG_DATA
280: ,X_RETURN_STATUS => X_RETURN_STATUS);
281:
282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
283: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
284: P_API_NAME => L_API_NAME
285: ,P_PKG_NAME => G_PKG_NAME
286: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

306: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
307: -- The Master delete procedure may not be needed depends on different business requirements.
308: PROCEDURE Delete_selcrit(
309: P_Api_Version_Number IN NUMBER,
310: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
311: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
312: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
313: P_Identity_Resource_Id IN NUMBER,
314: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type,

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

307: -- The Master delete procedure may not be needed depends on different business requirements.
308: PROCEDURE Delete_selcrit(
309: P_Api_Version_Number IN NUMBER,
310: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
311: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
312: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
313: P_Identity_Resource_Id IN NUMBER,
314: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type,
315: X_Return_Status OUT NOCOPY VARCHAR2,

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

308: PROCEDURE Delete_selcrit(
309: P_Api_Version_Number IN NUMBER,
310: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
311: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
312: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
313: P_Identity_Resource_Id IN NUMBER,
314: P_SELCRIT_Rec IN PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type,
315: X_Return_Status OUT NOCOPY VARCHAR2,
316: X_Msg_Count OUT NOCOPY NUMBER,

Line 328: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

324: -- Standard Start of API savepoint
325: SAVEPOINT DELETE_SELCRIT_PUB;
326:
327: -- Standard call to check for call compatibility.
328: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
329: p_api_version_number,
330: l_api_name,
331: G_PKG_NAME)
332: THEN

Line 333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

329: p_api_version_number,
330: l_api_name,
331: G_PKG_NAME)
332: THEN
333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
334: END IF;
335:
336:
337: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 338: IF FND_API.to_Boolean( p_init_msg_list )

334: END IF;
335:
336:
337: -- Initialize message list if p_init_msg_list is set to TRUE.
338: IF FND_API.to_Boolean( p_init_msg_list )
339: THEN
340: FND_MSG_PUB.initialize;
341: END IF;
342:

Line 359: x_return_status := FND_API.G_RET_STS_SUCCESS;

355:
356: END IF;
357:
358: -- Initialize API return status to SUCCESS
359: x_return_status := FND_API.G_RET_STS_SUCCESS;
360:
361: --
362: -- API body
363: --

Line 367: P_Init_Msg_List => FND_API.G_FALSE,

363: --
364:
365: PV_selcrit_PVT.Delete_selcrit(
366: P_Api_Version_Number => 2.0,
367: P_Init_Msg_List => FND_API.G_FALSE,
368: P_Commit => p_commit,
369: P_Validation_Level => p_Validation_Level,
370: P_Identity_Resource_Id => P_Identity_Resource_Id,
371: P_SELCRIT_Rec => p_SELCRIT_Rec,

Line 378: IF x_return_status = FND_API.G_RET_STS_ERROR then

374: X_Msg_Data => x_msg_data);
375:
376:
377: -- Check return status from the above procedure call
378: IF x_return_status = FND_API.G_RET_STS_ERROR then
379: raise FND_API.G_EXC_ERROR;
380: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
381: raise FND_API.G_EXC_UNEXPECTED_ERROR;
382: END IF;

Line 379: raise FND_API.G_EXC_ERROR;

375:
376:
377: -- Check return status from the above procedure call
378: IF x_return_status = FND_API.G_RET_STS_ERROR then
379: raise FND_API.G_EXC_ERROR;
380: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
381: raise FND_API.G_EXC_UNEXPECTED_ERROR;
382: END IF;
383:

Line 380: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

376:
377: -- Check return status from the above procedure call
378: IF x_return_status = FND_API.G_RET_STS_ERROR then
379: raise FND_API.G_EXC_ERROR;
380: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
381: raise FND_API.G_EXC_UNEXPECTED_ERROR;
382: END IF;
383:
384: --

Line 381: raise FND_API.G_EXC_UNEXPECTED_ERROR;

377: -- Check return status from the above procedure call
378: IF x_return_status = FND_API.G_RET_STS_ERROR then
379: raise FND_API.G_EXC_ERROR;
380: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
381: raise FND_API.G_EXC_UNEXPECTED_ERROR;
382: END IF;
383:
384: --
385: -- End of API body

Line 389: IF FND_API.to_Boolean( p_commit )

385: -- End of API body
386: --
387:
388: -- Standard check for p_commit
389: IF FND_API.to_Boolean( p_commit )
390: THEN
391: COMMIT WORK;
392: END IF;
393:

Line 416: WHEN FND_API.G_EXC_ERROR THEN

412: p_data => x_msg_data
413: );
414:
415: EXCEPTION
416: WHEN FND_API.G_EXC_ERROR THEN
417: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
418: P_API_NAME => L_API_NAME
419: ,P_PKG_NAME => G_PKG_NAME
420: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

422: ,X_MSG_COUNT => X_MSG_COUNT
423: ,X_MSG_DATA => X_MSG_DATA
424: ,X_RETURN_STATUS => X_RETURN_STATUS);
425:
426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
427: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
428: P_API_NAME => L_API_NAME
429: ,P_PKG_NAME => G_PKG_NAME
430: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR