eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_REVERSAL_PUB dependencies on OKL_API

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

22: l_api_version NUMBER := 1.0;
23: l_api_name VARCHAR2(30) := 'SUBMIT_PERIOD_REVERSAL';
24:
25: l_period VARCHAR2(30) := p_period;
26: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
27: l_request_id NUMBER := 0;
28:
29: BEGIN
30:

Line 68: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

64: END IF;
65: -- End of wraper code generated automatically by Debug code generator for OKL_REVERSAL_PVT.SUBMIT_PERIOD_REVERSAL
66:
67:
68: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
71: RAISE FND_API.G_EXC_ERROR;
72: END IF;

Line 70: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

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

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

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

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

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

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

96:
97: WHEN OTHERS THEN
98:
99: FND_MSG_PUB.ADD_EXC_MSG('OKL_REVERSAL_PUB','SUBMIT_PERIOD_REVERSAL');
100: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
101: ,p_count => x_msg_count
102: ,p_data => x_msg_data);
103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
104:

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

119:
120: l_api_version NUMBER := 1.0;
121: l_api_name VARCHAR2(30) := 'REVERSE_ENTRIES';
122:
123: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
124: l_source_id NUMBER := p_source_id;
125: l_source_table VARCHAR2(30) := p_source_table;
126: l_acct_date DATE := p_acct_date;
127:

Line 168: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 170: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

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

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

180: WHEN FND_API.G_EXC_ERROR THEN
181: ROLLBACK TO REVERSE_ENTRIES;
182: x_return_status := FND_API.G_RET_STS_ERROR;
183:
184: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
185: ,p_count => x_msg_count
186: ,p_data => x_msg_data);
187:
188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

194:
195: WHEN OTHERS THEN
196:
197: FND_MSG_PUB.ADD_EXC_MSG('OKL_REVERSAL_PUB','REVERSE_ENTRIES');
198: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
199: ,p_count => x_msg_count
200: ,p_data => x_msg_data);
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
202:

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

218:
219: l_api_version NUMBER := 1.0;
220: l_api_name VARCHAR2(30) := 'REVERSE_ENTRIES';
221:
222: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
223:
224:
225: l_source_table VARCHAR2(30) := p_source_table;
226: l_acct_date DATE := p_acct_date;

Line 269: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

265: END IF;
266: -- End of wraper code generated automatically by Debug code generator for OKL_REVERSAL_PVT.REVERSE_ENTRIES
267:
268:
269: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
271: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
272: RAISE FND_API.G_EXC_ERROR;
273: END IF;

Line 271: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

267:
268:
269: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
271: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
272: RAISE FND_API.G_EXC_ERROR;
273: END IF;
274:
275:

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

281: WHEN FND_API.G_EXC_ERROR THEN
282: ROLLBACK TO REVERSE_ENTRIES;
283: x_return_status := FND_API.G_RET_STS_ERROR;
284:
285: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
286: ,p_count => x_msg_count
287: ,p_data => x_msg_data);
288:
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

288:
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
290: ROLLBACK TO REVERSE_ENTRIES;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
293: ,p_count => x_msg_count
294: ,p_data => x_msg_data);
295:
296: WHEN OTHERS THEN

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

295:
296: WHEN OTHERS THEN
297:
298: FND_MSG_PUB.ADD_EXC_MSG('OKL_REVERSAL_PUB','REVERSE_ENTRIES');
299: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
300: ,p_count => x_msg_count
301: ,p_data => x_msg_data);
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: