APPS.ICX_CAT_POPULATE_REQTMPL_GRP dependencies on FND_API

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

5: G_PKG_NAME CONSTANT VARCHAR2(30):='ICX_CAT_POPULATE_REQTMPL_GRP';
6:
7: PROCEDURE populateOnlineReqTemplates
8: ( p_api_version IN NUMBER ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
11: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
12: x_return_status OUT NOCOPY VARCHAR2 ,
13: p_key IN NUMBER

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

6:
7: PROCEDURE populateOnlineReqTemplates
8: ( p_api_version IN NUMBER ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
11: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
12: x_return_status OUT NOCOPY VARCHAR2 ,
13: p_key IN NUMBER
14: )

Line 11: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,

7: PROCEDURE populateOnlineReqTemplates
8: ( p_api_version IN NUMBER ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
11: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
12: x_return_status OUT NOCOPY VARCHAR2 ,
13: p_key IN NUMBER
14: )
15: IS

Line 25: x_return_status := FND_API.G_RET_STS_SUCCESS;

21: l_log_string VARCHAR2(2000);
22:
23: BEGIN
24: l_err_loc := 100;
25: x_return_status := FND_API.G_RET_STS_SUCCESS;
26:
27: l_err_loc := 200;
28: -- Standard Start of API savepoint
29: SAVEPOINT populateOnlineReqTemplates_sp;

Line 44: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

40: END IF;
41:
42: l_err_loc := 400;
43: -- Standard call to check for call compatibility.
44: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
45: p_api_version ,
46: l_api_name ,
47: G_PKG_NAME )
48: THEN

Line 49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

45: p_api_version ,
46: l_api_name ,
47: G_PKG_NAME )
48: THEN
49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
50: END IF;
51:
52: l_err_loc := 500;
53: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);

Line 60: IF (FND_API.To_Boolean(P_COMMIT)) THEN

56: ICX_CAT_POPULATE_REQTMPL_PVT.populateOnlineReqTemplates(p_key);
57:
58: l_err_loc := 700;
59: -- Standard check of P_COMMIT
60: IF (FND_API.To_Boolean(P_COMMIT)) THEN
61: l_err_loc := 800;
62: COMMIT;
63: l_err_loc := 900;
64: -- Call the rebuild index

Line 101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

97: || SQLERRM);
98: END IF;
99: NULL;
100: END;
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
102: END populateOnlineReqTemplates;
103:
104: END ICX_CAT_POPULATE_REQTMPL_GRP;