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_ENTYRLS_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_entyrls(
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_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type

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

17:
18: PROCEDURE Create_entyrls(
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_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type
25: := PV_RULE_RECTYPE_PUB.G_MISS_ENTYRLS_REC,

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

18: PROCEDURE Create_entyrls(
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_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type
25: := PV_RULE_RECTYPE_PUB.G_MISS_ENTYRLS_REC,
26: X_ENTITY_RULE_APPLIED_ID OUT NOCOPY NUMBER,

Line 40: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 50: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 71: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 80: P_Init_Msg_List => FND_API.G_FALSE,

76:
77: -- Calling Private package: Create_ENTYRLS
78: PV_entyrls_PVT.Create_entyrls(
79: P_Api_Version_Number => 2.0,
80: P_Init_Msg_List => FND_API.G_FALSE,
81: P_Commit => FND_API.G_FALSE,
82: P_Validation_Level => P_Validation_Level,
83: P_Identity_Resource_Id => P_Identity_Resource_Id,
84: P_ENTYRLS_Rec => p_ENTYRLS_Rec ,

Line 81: P_Commit => FND_API.G_FALSE,

77: -- Calling Private package: Create_ENTYRLS
78: PV_entyrls_PVT.Create_entyrls(
79: P_Api_Version_Number => 2.0,
80: P_Init_Msg_List => FND_API.G_FALSE,
81: P_Commit => FND_API.G_FALSE,
82: P_Validation_Level => P_Validation_Level,
83: P_Identity_Resource_Id => P_Identity_Resource_Id,
84: P_ENTYRLS_Rec => p_ENTYRLS_Rec ,
85: X_ENTITY_RULE_APPLIED_ID => x_ENTITY_RULE_APPLIED_ID,

Line 92: IF x_return_status = FND_API.G_RET_STS_ERROR then

88: X_Msg_Data => x_msg_data);
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_entyrls(
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_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_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_entyrls(
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_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_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_entyrls(
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_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_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_ENTYRLS_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_entyrls_PVT.Update_entyrls(
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_ENTYRLS_Rec => p_ENTYRLS_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:
308: PROCEDURE Delete_entyrls(
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_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type,

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

307:
308: PROCEDURE Delete_entyrls(
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_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_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_entyrls(
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_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type,
315: X_Return_Status OUT NOCOPY VARCHAR2,
316: X_Msg_Count OUT NOCOPY NUMBER,

Line 329: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 339: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 360: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 368: P_Init_Msg_List => FND_API.G_FALSE,

364: --
365:
366: PV_entyrls_PVT.Delete_entyrls(
367: P_Api_Version_Number => 2.0,
368: P_Init_Msg_List => FND_API.G_FALSE,
369: P_Commit => p_commit,
370: P_Validation_Level => p_Validation_Level,
371: P_Identity_Resource_Id => P_Identity_Resource_Id,
372: P_ENTYRLS_Rec => p_ENTYRLS_Rec,

Line 378: IF x_return_status = FND_API.G_RET_STS_ERROR then

374: X_Msg_Count => x_msg_count,
375: X_Msg_Data => x_msg_data);
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: X_Msg_Data => x_msg_data);
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