DBA Data[Home] [Help]

APPS.OKL_PERD_STATUS_PUB dependencies on FND_API

Line 33: x_return_status := FND_API.G_RET_STS_SUCCESS;

29: BEGIN
30:
31: SAVEPOINT SEARCH_PERIOD_STATUS;
32:
33: x_return_status := FND_API.G_RET_STS_SUCCESS;
34:
35: -- customer pre-processing
36:
37:

Line 70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

66:
67:
68:
69: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
72: RAISE FND_API.G_EXC_ERROR;
73: END IF;
74:

Line 72: RAISE FND_API.G_EXC_ERROR;

68:
69: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
72: RAISE FND_API.G_EXC_ERROR;
73: END IF;
74:
75: l_period_tbl := x_period_tbl;
76:

Line 83: WHEN FND_API.G_EXC_ERROR THEN

79:
80:
81: EXCEPTION
82:
83: WHEN FND_API.G_EXC_ERROR THEN
84: ROLLBACK TO SEARCH_PERIOD_STATUS;
85: x_return_status := FND_API.G_RET_STS_ERROR;
86:
87: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

Line 85: x_return_status := FND_API.G_RET_STS_ERROR;

81: EXCEPTION
82:
83: WHEN FND_API.G_EXC_ERROR THEN
84: ROLLBACK TO SEARCH_PERIOD_STATUS;
85: x_return_status := FND_API.G_RET_STS_ERROR;
86:
87: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
88: ,p_count => x_msg_count
89: ,p_data => x_msg_data);

Line 91: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

87: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
88: ,p_count => x_msg_count
89: ,p_data => x_msg_data);
90:
91: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
92: ROLLBACK TO SEARCH_PERIOD_STATUS;
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
95: ,p_count => x_msg_count

Line 93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

89: ,p_data => x_msg_data);
90:
91: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
92: ROLLBACK TO SEARCH_PERIOD_STATUS;
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
95: ,p_count => x_msg_count
96: ,p_data => x_msg_data);
97:

Line 104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

100: FND_MSG_PUB.ADD_EXC_MSG('OKL_PERD_STATUS_PUB','SEARCH_PERIOD_STATUS');
101: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
102: ,p_count => x_msg_count
103: ,p_data => x_msg_data);
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105:
106:
107:
108: END SEARCH_PERIOD_STATUS;

Line 134: x_return_status := FND_API.G_RET_STS_SUCCESS;

130: BEGIN
131:
132: SAVEPOINT UPDATE_PERIOD_STATUS;
133:
134: x_return_status := FND_API.G_RET_STS_SUCCESS;
135:
136: -- customer pre-processing
137:
138:

Line 168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

164: -- End of wraper code generated automatically by Debug code generator for OKL_PERD_STATUS_PVT.UPDATE_PERIOD_STATUS
165:
166:
167: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
170: RAISE FND_API.G_EXC_ERROR;
171: END IF;
172:

Line 170: RAISE FND_API.G_EXC_ERROR;

166:
167: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
170: RAISE FND_API.G_EXC_ERROR;
171: END IF;
172:
173:
174:

Line 179: WHEN FND_API.G_EXC_ERROR THEN

175:
176:
177: EXCEPTION
178:
179: WHEN FND_API.G_EXC_ERROR THEN
180: ROLLBACK TO UPDATE_PERIOD_STATUS;
181: x_return_status := FND_API.G_RET_STS_ERROR;
182:
183: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

Line 181: x_return_status := FND_API.G_RET_STS_ERROR;

177: EXCEPTION
178:
179: WHEN FND_API.G_EXC_ERROR THEN
180: ROLLBACK TO UPDATE_PERIOD_STATUS;
181: x_return_status := FND_API.G_RET_STS_ERROR;
182:
183: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
184: ,p_count => x_msg_count
185: ,p_data => x_msg_data);

Line 187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

183: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
184: ,p_count => x_msg_count
185: ,p_data => x_msg_data);
186:
187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
188: ROLLBACK TO UPDATE_PERIOD_STATUS;
189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
191: ,p_count => x_msg_count

Line 189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

185: ,p_data => x_msg_data);
186:
187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
188: ROLLBACK TO UPDATE_PERIOD_STATUS;
189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
191: ,p_count => x_msg_count
192: ,p_data => x_msg_data);
193:

Line 200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

196: FND_MSG_PUB.ADD_EXC_MSG('OKL_PERD_STATUS_PUB','UPDATE_PERIOD_STATUS');
197: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
198: ,p_count => x_msg_count
199: ,p_data => x_msg_data);
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201:
202:
203:
204: