APPS.ICX_RELATED_TEMPLATES_PUB dependencies on FND_API

Line 7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

3:
4:
5: PROCEDURE Insert_Relation
6: ( p_api_version_number IN NUMBER ,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
8: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
11: p_return_status OUT VARCHAR2 ,

Line 8: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,

4:
5: PROCEDURE Insert_Relation
6: ( p_api_version_number IN NUMBER ,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
8: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
11: p_return_status OUT VARCHAR2 ,
12: p_msg_count OUT NUMBER ,

Line 9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

5: PROCEDURE Insert_Relation
6: ( p_api_version_number IN NUMBER ,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
8: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
11: p_return_status OUT VARCHAR2 ,
12: p_msg_count OUT NUMBER ,
13: p_msg_data OUT VARCHAR2 ,

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

6: ( p_api_version_number IN NUMBER ,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
8: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
11: p_return_status OUT VARCHAR2 ,
12: p_msg_count OUT NUMBER ,
13: p_msg_data OUT VARCHAR2 ,
14: p_template IN VARCHAR2 DEFAULT NULL ,

Line 36: IF NOT FND_API.Compatible_API_Call(l_api_version_number,

32:
33:
34: -- Standard call to check for call compatibility
35:
36: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
37: p_api_version_number,
38: 'Insert_Relation',
39: G_PKG_NAME)
40: THEN

Line 41: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

37: p_api_version_number,
38: 'Insert_Relation',
39: G_PKG_NAME)
40: THEN
41: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
42: END IF;
43:
44:
45: -- Initialize message list if p_init_msg_list is set to TRUE

Line 47: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 53: p_return_status := FND_API.G_RET_STS_SUCCESS;

49: END IF;
50:
51:
52: -- Initialize p_return_status
53: p_return_status := FND_API.G_RET_STS_SUCCESS;
54:
55:
56: -- Get prompts table for translation of messages
57: icx_util.getPrompts(601,'ICX_RELATED_TEMPLATES_R',l_title,l_prompts);

Line 71: RAISE FND_API.G_EXC_ERROR;

67: -- add message: Required API parameters are missing
68: FND_MESSAGE.SET_NAME('ICX','ICX_API_MISS_PARAM');
69: FND_MSG_PUB.Add;
70: end if;
71: RAISE FND_API.G_EXC_ERROR;
72: end if;
73:
74:
75:

Line 78: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL THEN

74:
75:
76:
77: -- Perform validation
78: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL THEN
79:
80: -- check template
81: select count(*) into l_count
82: from po_reqexpress_headers

Line 184: RAISE FND_API.G_EXC_ERROR;

180:
181:
182: -- If any validation failed, raise error
183: IF l_validation_error THEN
184: RAISE FND_API.G_EXC_ERROR;
185: END IF;
186:
187:
188:

Line 214: IF FND_API.To_Boolean(p_simulate) THEN

210:
211:
212: -- Standard check of p_simulate and p_commit parameter
213:
214: IF FND_API.To_Boolean(p_simulate) THEN
215:
216: ROLLBACK TO Insert_Relation_PUB;
217:
218: ELSIF FND_API.To_Boolean(p_commit) THEN

Line 218: ELSIF FND_API.To_Boolean(p_commit) THEN

214: IF FND_API.To_Boolean(p_simulate) THEN
215:
216: ROLLBACK TO Insert_Relation_PUB;
217:
218: ELSIF FND_API.To_Boolean(p_commit) THEN
219:
220: COMMIT WORK;
221:
222: END IF;

Line 235: WHEN FND_API.G_EXC_ERROR THEN

231:
232:
233: EXCEPTION
234:
235: WHEN FND_API.G_EXC_ERROR THEN
236:
237: p_return_status := FND_API.G_RET_STS_ERROR;
238:
239: -- Get message count and if 1, return message data

Line 237: p_return_status := FND_API.G_RET_STS_ERROR;

233: EXCEPTION
234:
235: WHEN FND_API.G_EXC_ERROR THEN
236:
237: p_return_status := FND_API.G_RET_STS_ERROR;
238:
239: -- Get message count and if 1, return message data
240:
241: FND_MSG_PUB.Count_And_Get

Line 246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

242: (p_count => p_msg_count,
243: p_data => p_msg_data
244: );
245:
246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
247:
248: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
249:
250: -- Get message count and if 1, return message data

Line 248: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

244: );
245:
246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
247:
248: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
249:
250: -- Get message count and if 1, return message data
251:
252: FND_MSG_PUB.Count_And_Get

Line 259: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

255: );
256:
257: WHEN OTHERS THEN
258:
259: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
260:
261: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
262: FND_MSG_PUB.Build_Exc_Msg
263: ( G_PKG_NAME ,

Line 283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

279:
280:
281: PROCEDURE Delete_Relation
282: ( p_api_version_number IN NUMBER ,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
284: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
285: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
286: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
287: p_return_status OUT VARCHAR2 ,

Line 284: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,

280:
281: PROCEDURE Delete_Relation
282: ( p_api_version_number IN NUMBER ,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
284: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
285: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
286: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
287: p_return_status OUT VARCHAR2 ,
288: p_msg_count OUT NUMBER ,

Line 285: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

281: PROCEDURE Delete_Relation
282: ( p_api_version_number IN NUMBER ,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
284: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
285: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
286: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
287: p_return_status OUT VARCHAR2 ,
288: p_msg_count OUT NUMBER ,
289: p_msg_data OUT VARCHAR2 ,

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

282: ( p_api_version_number IN NUMBER ,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
284: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
285: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
286: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
287: p_return_status OUT VARCHAR2 ,
288: p_msg_count OUT NUMBER ,
289: p_msg_data OUT VARCHAR2 ,
290: p_template IN VARCHAR2 DEFAULT NULL ,

Line 311: IF NOT FND_API.Compatible_API_Call(l_api_version_number,

307:
308:
309: -- Standard call to check for call compatibility
310:
311: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
312: p_api_version_number,
313: 'Delete Relation',
314: G_PKG_NAME)
315: THEN

Line 316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

312: p_api_version_number,
313: 'Delete Relation',
314: G_PKG_NAME)
315: THEN
316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
317: END IF;
318:
319:
320: -- Initialize message list if p_init_msg_list is set to TRUE

Line 322: IF FND_API.to_Boolean(p_init_msg_list) THEN

318:
319:
320: -- Initialize message list if p_init_msg_list is set to TRUE
321:
322: IF FND_API.to_Boolean(p_init_msg_list) THEN
323: FND_MSG_PUB.initialize;
324: END IF;
325:
326:

Line 329: p_return_status := FND_API.G_RET_STS_SUCCESS;

325:
326:
327: -- Initialize p_return_status
328:
329: p_return_status := FND_API.G_RET_STS_SUCCESS;
330:
331:
332: -- Get prompts table for translation of messages
333:

Line 348: RAISE FND_API.G_EXC_ERROR;

344: -- add message: Required API parameters are missing
345: FND_MESSAGE.SET_NAME('ICX','ICX_API_MISS_PARAM');
346: FND_MSG_PUB.Add;
347: end if;
348: RAISE FND_API.G_EXC_ERROR;
349: end if;
350:
351:
352:

Line 366: IF FND_API.To_Boolean(p_simulate) THEN

362:
363:
364: -- Standard check of p_simulate and p_commit parameter
365:
366: IF FND_API.To_Boolean(p_simulate) THEN
367:
368: ROLLBACK TO Insert_Relation_PUB;
369:
370: ELSIF FND_API.To_Boolean(p_commit) THEN

Line 370: ELSIF FND_API.To_Boolean(p_commit) THEN

366: IF FND_API.To_Boolean(p_simulate) THEN
367:
368: ROLLBACK TO Insert_Relation_PUB;
369:
370: ELSIF FND_API.To_Boolean(p_commit) THEN
371:
372: COMMIT WORK;
373:
374: END IF;

Line 389: p_return_status := FND_API.G_RET_STS_ERROR;

385: EXCEPTION
386:
387: WHEN NO_DATA_FOUND THEN
388:
389: p_return_status := FND_API.G_RET_STS_ERROR;
390:
391: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
392: -- add message: Relation to delete does not exist
393: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_DELETE');

Line 404: WHEN FND_API.G_EXC_ERROR THEN

400: (p_count => p_msg_count,
401: p_data => p_msg_data
402: );
403:
404: WHEN FND_API.G_EXC_ERROR THEN
405:
406: p_return_status := FND_API.G_RET_STS_ERROR;
407:
408: -- Get message count and if 1, return message data

Line 406: p_return_status := FND_API.G_RET_STS_ERROR;

402: );
403:
404: WHEN FND_API.G_EXC_ERROR THEN
405:
406: p_return_status := FND_API.G_RET_STS_ERROR;
407:
408: -- Get message count and if 1, return message data
409:
410: FND_MSG_PUB.Count_And_Get

Line 415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

411: (p_count => p_msg_count,
412: p_data => p_msg_data
413: );
414:
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416:
417: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
418:
419: -- Get message count and if 1, return message data

Line 417: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

413: );
414:
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416:
417: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
418:
419: -- Get message count and if 1, return message data
420:
421: FND_MSG_PUB.Count_And_Get

Line 428: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

424: );
425:
426: WHEN OTHERS THEN
427:
428: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
429:
430: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
431: FND_MSG_PUB.Build_Exc_Msg
432: ( G_PKG_NAME ,