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_ENTYATTMAP_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_entyattmap(
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_ENTYATTMAP_Rec IN PV_RULE_RECTYPE_PUB.ENTYATTMAP_Rec_Type

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

17:
18: PROCEDURE Create_entyattmap(
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_ENTYATTMAP_Rec IN PV_RULE_RECTYPE_PUB.ENTYATTMAP_Rec_Type
25: := PV_RULE_RECTYPE_PUB.G_MISS_ENTYATTMAP_REC,

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

18: PROCEDURE Create_entyattmap(
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_ENTYATTMAP_Rec IN PV_RULE_RECTYPE_PUB.ENTYATTMAP_Rec_Type
25: := PV_RULE_RECTYPE_PUB.G_MISS_ENTYATTMAP_REC,
26: X_MAPPING_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_ENTYATTMAP_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 79: P_Init_Msg_List => FND_API.G_FALSE,

75: --
76: -- Calling Private package: Create_ENTYATTMAP
77: PV_entyattmap_PVT.Create_entyattmap(
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_ENTYATTMAP_Rec => p_ENTYATTMAP_Rec ,

Line 80: P_Commit => FND_API.G_FALSE,

76: -- Calling Private package: Create_ENTYATTMAP
77: PV_entyattmap_PVT.Create_entyattmap(
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_ENTYATTMAP_Rec => p_ENTYATTMAP_Rec ,
84: X_MAPPING_ID => x_MAPPING_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_entyattmap(
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_ENTYATTMAP_Rec IN PV_RULE_RECTYPE_PUB.ENTYATTMAP_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_entyattmap(
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_ENTYATTMAP_Rec IN PV_RULE_RECTYPE_PUB.ENTYATTMAP_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_entyattmap(
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_ENTYATTMAP_Rec IN PV_RULE_RECTYPE_PUB.ENTYATTMAP_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_ENTYATTMAP_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_entyattmap_PVT.Update_entyattmap(
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_ENTYATTMAP_Rec => p_ENTYATTMAP_Rec ,

Line 235: IF x_return_status = FND_API.G_RET_STS_ERROR then

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

Line 236: raise FND_API.G_EXC_ERROR;

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

Line 237: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

Line 238: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 246: IF FND_API.to_Boolean( p_commit )

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

Line 273: WHEN FND_API.G_EXC_ERROR THEN

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

Line 283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

308: -- The Master delete procedure may not be needed depends on different business requirements.
309:
310: PROCEDURE Delete_entyattmap(
311: P_Api_Version_Number IN NUMBER,
312: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
313: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
314: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
315: P_Identity_Resource_Id IN NUMBER,
316: P_ENTYATTMAP_Rec IN PV_RULE_RECTYPE_PUB.ENTYATTMAP_Rec_Type,

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

309:
310: PROCEDURE Delete_entyattmap(
311: P_Api_Version_Number IN NUMBER,
312: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
313: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
314: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
315: P_Identity_Resource_Id IN NUMBER,
316: P_ENTYATTMAP_Rec IN PV_RULE_RECTYPE_PUB.ENTYATTMAP_Rec_Type,
317: X_Return_Status OUT NOCOPY VARCHAR2,

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

310: PROCEDURE Delete_entyattmap(
311: P_Api_Version_Number IN NUMBER,
312: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
313: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
314: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
315: P_Identity_Resource_Id IN NUMBER,
316: P_ENTYATTMAP_Rec IN PV_RULE_RECTYPE_PUB.ENTYATTMAP_Rec_Type,
317: X_Return_Status OUT NOCOPY VARCHAR2,
318: X_Msg_Count OUT NOCOPY NUMBER,

Line 330: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 340: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 361: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 369: P_Init_Msg_List => FND_API.G_FALSE,

365: --
366:
367: PV_entyattmap_PVT.Delete_entyattmap(
368: P_Api_Version_Number => 2.0,
369: P_Init_Msg_List => FND_API.G_FALSE,
370: P_Commit => p_commit,
371: P_Validation_Level => p_Validation_Level,
372: P_Identity_Resource_Id => P_Identity_Resource_Id,
373: P_ENTYATTMAP_Rec => p_ENTYATTMAP_Rec,

Line 379: IF x_return_status = FND_API.G_RET_STS_ERROR then

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

Line 380: raise FND_API.G_EXC_ERROR;

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

Line 381: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

Line 382: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 390: IF FND_API.to_Boolean( p_commit )

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

Line 417: WHEN FND_API.G_EXC_ERROR THEN

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

Line 427: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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