DBA Data[Home] [Help]

APPS.OKL_PROCESS_ACC_GROUP_PVT dependencies on FND_API

Line 70: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

66: ,x_agcv_tbl OUT NOCOPY agcv_tbl_type) IS
67:
68:
69:
70: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
71: l_api_name CONSTANT VARCHAR2(30) := 'create_acc_ccid';
72: i NUMBER;
73:
74: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 74: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

70: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
71: l_api_name CONSTANT VARCHAR2(30) := 'create_acc_ccid';
72: i NUMBER;
73:
74: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
75: l_agcv_tbl agcv_tbl_type := p_agcv_tbl;
76:
77:
78: BEGIN

Line 96: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

92: ,p_agcv_rec => l_agcv_tbl(i)
93: ,x_agcv_rec => x_agcv_tbl(i));
94:
95: -- store the highest degree of error
96: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
97: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
98: l_overall_status := l_return_status;
99: END IF;
100: END IF;

Line 97: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

93: ,x_agcv_rec => x_agcv_tbl(i));
94:
95: -- store the highest degree of error
96: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
97: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
98: l_overall_status := l_return_status;
99: END IF;
100: END IF;
101:

Line 180: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

176: ,x_msg_data OUT NOCOPY VARCHAR2
177: ,p_agcv_tbl IN agcv_tbl_type
178: ,x_agcv_tbl OUT NOCOPY agcv_tbl_type) IS
179:
180: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
181: l_api_name CONSTANT VARCHAR2(30) := 'update_acc_ccid';
182: i NUMBER;
183:
184: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 184: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

180: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
181: l_api_name CONSTANT VARCHAR2(30) := 'update_acc_ccid';
182: i NUMBER;
183:
184: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
185: l_agcv_tbl agcv_tbl_type := p_agcv_tbl;
186:
187: BEGIN
188:

Line 204: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

200: ,p_agcv_rec => l_agcv_tbl(i)
201: ,x_agcv_rec => x_agcv_tbl(i));
202:
203: -- store the highest degree of error
204: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
205: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
206: l_overall_status := l_return_status;
207: END IF;
208: END IF;

Line 205: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

201: ,x_agcv_rec => x_agcv_tbl(i));
202:
203: -- store the highest degree of error
204: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
205: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
206: l_overall_status := l_return_status;
207: END IF;
208: END IF;
209:

Line 257: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

253: ,x_msg_data OUT NOCOPY VARCHAR2
254: ,p_agcv_tbl IN agcv_tbl_type) IS
255:
256: i NUMBER :=0;
257: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
258: l_api_name CONSTANT VARCHAR2(30) := 'delete_acc_ccid';
259: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
260: l_agcv_tbl agcv_tbl_type := p_agcv_tbl;
261:

Line 259: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

255:
256: i NUMBER :=0;
257: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
258: l_api_name CONSTANT VARCHAR2(30) := 'delete_acc_ccid';
259: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
260: l_agcv_tbl agcv_tbl_type := p_agcv_tbl;
261:
262: BEGIN
263:

Line 278: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

274: ,x_msg_data => x_msg_data
275: ,p_agcv_rec => l_agcv_tbl(i));
276:
277: -- store the highest degree of error
278: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
279: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
280: l_overall_status := l_return_status;
281: END IF;
282: END IF;

Line 279: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

275: ,p_agcv_rec => l_agcv_tbl(i));
276:
277: -- store the highest degree of error
278: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
279: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
280: l_overall_status := l_return_status;
281: END IF;
282: END IF;
283:

Line 333: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

329: ,p_agbv_tbl IN agbv_tbl_type
330: ,x_agbv_tbl OUT NOCOPY agbv_tbl_type) IS
331:
332:
333: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
334: l_api_name CONSTANT VARCHAR2(30) := 'create_acc_bal';
335: i NUMBER;
336: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
337: l_agbv_tbl agbv_tbl_type := p_agbv_tbl;

Line 336: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

332:
333: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
334: l_api_name CONSTANT VARCHAR2(30) := 'create_acc_bal';
335: i NUMBER;
336: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
337: l_agbv_tbl agbv_tbl_type := p_agbv_tbl;
338:
339: BEGIN
340:

Line 357: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

353: ,p_agbv_rec => l_agbv_tbl(i)
354: ,x_agbv_rec => x_agbv_tbl(i));
355:
356: -- store the highest degree of error
357: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
358: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
359: l_overall_status := l_return_status;
360: END IF;
361: END IF;

Line 358: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

354: ,x_agbv_rec => x_agbv_tbl(i));
355:
356: -- store the highest degree of error
357: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
358: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
359: l_overall_status := l_return_status;
360: END IF;
361: END IF;
362:

Line 409: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

405: ,x_msg_data OUT NOCOPY VARCHAR2
406: ,p_agbv_tbl IN agbv_tbl_type
407: ,x_agbv_tbl OUT NOCOPY agbv_tbl_type) IS
408:
409: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
410: l_api_name CONSTANT VARCHAR2(30) := 'update_acc_bal';
411: i NUMBER;
412: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
413: l_agbv_tbl agbv_tbl_type := p_agbv_tbl;

Line 412: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

408:
409: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
410: l_api_name CONSTANT VARCHAR2(30) := 'update_acc_bal';
411: i NUMBER;
412: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
413: l_agbv_tbl agbv_tbl_type := p_agbv_tbl;
414:
415: BEGIN
416:

Line 432: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

428: ,p_agbv_rec => l_agbv_tbl(i)
429: ,x_agbv_rec => x_agbv_tbl(i));
430:
431: -- store the highest degree of error
432: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
433: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
434: l_overall_status := l_return_status;
435: END IF;
436: END IF;

Line 433: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

429: ,x_agbv_rec => x_agbv_tbl(i));
430:
431: -- store the highest degree of error
432: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
433: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
434: l_overall_status := l_return_status;
435: END IF;
436: END IF;
437:

Line 488: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

484:
485:
486:
487: i NUMBER :=0;
488: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
489: l_api_name CONSTANT VARCHAR2(30) := 'delete_acc_bal';
490: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
491: l_agbv_tbl agbv_tbl_type := p_agbv_tbl;
492:

Line 490: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

486:
487: i NUMBER :=0;
488: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
489: l_api_name CONSTANT VARCHAR2(30) := 'delete_acc_bal';
490: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
491: l_agbv_tbl agbv_tbl_type := p_agbv_tbl;
492:
493: BEGIN
494:

Line 509: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

505: ,x_msg_data => x_msg_data
506: ,p_agbv_rec => l_agbv_tbl(i));
507:
508: -- store the highest degree of error
509: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
510: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
511: l_overall_status := l_return_status;
512: END IF;
513: END IF;

Line 510: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

506: ,p_agbv_rec => l_agbv_tbl(i));
507:
508: -- store the highest degree of error
509: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
510: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
511: l_overall_status := l_return_status;
512: END IF;
513: END IF;
514: