DBA Data[Home] [Help]

APPS.ICX_CAT_POPULATE_BPA_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_BPA_GRP';
6:
7: PROCEDURE populateOnlineBlankets
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 populateOnlineBlankets
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 populateOnlineBlankets
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 populateOnlineBlankets_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_PODOCS_PVT.populateOnlineBlankets(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 100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

96: || SQLERRM);
97: END IF;
98: NULL;
99: END;
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
101: END populateOnlineBlankets;
102:
103: PROCEDURE populateOnlineOrgAssgnmnts
104: ( p_api_version IN NUMBER ,

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

101: END populateOnlineBlankets;
102:
103: PROCEDURE populateOnlineOrgAssgnmnts
104: ( p_api_version IN NUMBER ,
105: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
107: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
108: x_return_status OUT NOCOPY VARCHAR2 ,
109: p_key IN NUMBER

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

102:
103: PROCEDURE populateOnlineOrgAssgnmnts
104: ( p_api_version IN NUMBER ,
105: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
107: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
108: x_return_status OUT NOCOPY VARCHAR2 ,
109: p_key IN NUMBER
110: )

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

103: PROCEDURE populateOnlineOrgAssgnmnts
104: ( p_api_version IN NUMBER ,
105: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
107: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
108: x_return_status OUT NOCOPY VARCHAR2 ,
109: p_key IN NUMBER
110: )
111: IS

Line 121: x_return_status := FND_API.G_RET_STS_SUCCESS;

117: l_log_string VARCHAR2(2000);
118:
119: BEGIN
120: l_err_loc := 100;
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122:
123: l_err_loc := 200;
124: -- Standard Start of API savepoint
125: SAVEPOINT populateOnlineOrgAssgnmnts_sp;

Line 140: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

136: END IF;
137:
138: l_err_loc := 400;
139: -- Standard call to check for call compatibility.
140: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
141: p_api_version ,
142: l_api_name ,
143: G_PKG_NAME )
144: THEN

Line 145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

141: p_api_version ,
142: l_api_name ,
143: G_PKG_NAME )
144: THEN
145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
146: END IF;
147:
148: l_err_loc := 500;
149: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);

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

152: ICX_CAT_POPULATE_PODOCS_PVT.populateOnlineOrgAssgnmnts(p_key);
153:
154: l_err_loc := 700;
155: -- Standard check of P_COMMIT
156: IF (FND_API.To_Boolean(P_COMMIT)) THEN
157: l_err_loc := 800;
158: COMMIT;
159: l_err_loc := 900;
160: -- Call the rebuild index

Line 196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

192: || SQLERRM);
193: END IF;
194: NULL;
195: END;
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
197: END populateOnlineOrgAssgnmnts;
198:
199: END ICX_CAT_POPULATE_BPA_GRP;