APPS.OKL_PERD_STATUS_PUB dependencies on OKL_API

Line 27: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

23:
24: l_period_rec period_rec_type := p_period_rec;
25: l_period_tbl period_tbl_type;
26:
27: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
28:
29: BEGIN
30:
31: SAVEPOINT SEARCH_PERIOD_STATUS;

Line 69: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

65: -- End of wraper code generated automatically by Debug code generator for OKL_PERD_STATUS_PVT.SEARCH_PERIOD_STATUS
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;

Line 71: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

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:
75: l_period_tbl := x_period_tbl;

Line 87: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

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);
90:
91: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 94: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

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:
98: WHEN OTHERS THEN

Line 101: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

97:
98: WHEN OTHERS THEN
99:
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:

Line 127: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

123: l_api_name VARCHAR2(30) := 'UPDATE_PERIOD_STATUS';
124:
125: l_period_tbl period_tbl_type := p_period_tbl;
126:
127: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
128:
129:
130: BEGIN
131:

Line 167: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

163: END IF;
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;

Line 169: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

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:
173:

Line 183: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

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);
186:
187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 190: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

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:
194: WHEN OTHERS THEN

Line 197: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

193:
194: WHEN OTHERS THEN
195:
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: