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_ACCT_EVENT_PUB dependencies on OKC_API

Line 10: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

6: PROCEDURE create_acct_event(
7:
8: p_api_version IN NUMBER
9:
10: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
11:
12: ,x_return_status OUT NOCOPY VARCHAR2
13:
14: ,x_msg_count OUT NOCOPY NUMBER

Line 40: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

36: l_api_name CONSTANT VARCHAR2(30) := 'create_acct_event';
37:
38: l_aetv_rec aetv_rec_type := p_aetv_rec;
39:
40: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
41:
42: l_aehv_tbl aehv_tbl_type := p_aehv_tbl;
43:
44: l_aelv_tbl aelv_tbl_type := p_aelv_tbl;

Line 97: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

93: ,x_aehv_tbl => x_aehv_tbl
94:
95: ,x_aelv_tbl => x_aelv_tbl);
96:
97: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
98:
99: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
100:
101: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

Line 99: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

95: ,x_aelv_tbl => x_aelv_tbl);
96:
97: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
98:
99: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
100:
101: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
102:
103: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 101: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

97: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
98:
99: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
100:
101: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
102:
103: RAISE OKC_API.G_EXCEPTION_ERROR;
104:
105: END IF;

Line 103: RAISE OKC_API.G_EXCEPTION_ERROR;

99: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
100:
101: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
102:
103: RAISE OKC_API.G_EXCEPTION_ERROR;
104:
105: END IF;
106:
107: l_aetv_rec := x_aetv_rec;

Line 128: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

124: WHEN FND_API.G_EXC_ERROR THEN
125: ROLLBACK TO create_acct_event;
126: x_return_status := FND_API.G_RET_STS_ERROR;
127:
128: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
129: ,p_count => x_msg_count
130: ,p_data => x_msg_data);
131:
132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 135: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

131:
132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
133: ROLLBACK TO create_acct_event;
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
136: ,p_count => x_msg_count
137: ,p_data => x_msg_data);
138:
139: WHEN OTHERS THEN

Line 142: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

138:
139: WHEN OTHERS THEN
140: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_event');
141: -- store SQL error message on message stack for caller
142: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
143: ,p_count => x_msg_count
144: ,p_data => x_msg_data);
145: -- notify caller of an UNEXPECTED error
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 157: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

153: PROCEDURE create_acct_event(
154:
155: p_api_version IN NUMBER
156:
157: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
158:
159: ,x_return_status OUT NOCOPY VARCHAR2
160:
161: ,x_msg_count OUT NOCOPY NUMBER

Line 169: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

165: ,p_aetv_rec IN aetv_rec_type
166:
167: ,x_aetv_rec OUT NOCOPY aetv_rec_type) IS
168:
169: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
170:
171: l_api_name CONSTANT VARCHAR2(30) := 'create_acct_event';
172:
173: l_aetv_rec aetv_rec_type := p_aetv_rec;

Line 248: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

244: WHEN FND_API.G_EXC_ERROR THEN
245: ROLLBACK TO create_acct_event;
246: x_return_status := FND_API.G_RET_STS_ERROR;
247:
248: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
249: ,p_count => x_msg_count
250: ,p_data => x_msg_data);
251:
252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 255: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

251:
252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
253: ROLLBACK TO create_acct_event;
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
256: ,p_count => x_msg_count
257: ,p_data => x_msg_data);
258:
259: WHEN OTHERS THEN

Line 262: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

258:
259: WHEN OTHERS THEN
260: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_event');
261: -- store SQL error message on message stack for caller
262: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
263: ,p_count => x_msg_count
264: ,p_data => x_msg_data);
265: -- notify caller of an UNEXPECTED error
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 276: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

272: PROCEDURE create_acct_event(
273:
274: p_api_version IN NUMBER
275:
276: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
277:
278: ,x_return_status OUT NOCOPY VARCHAR2
279:
280: ,x_msg_count OUT NOCOPY NUMBER

Line 288: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

284: ,p_aetv_tbl IN aetv_tbl_type
285:
286: ,x_aetv_tbl OUT NOCOPY aetv_tbl_type) IS
287:
288: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
289:
290: l_api_name CONSTANT VARCHAR2(30) := 'create_acct_event';
291:
292: i NUMBER;

Line 296: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

292: i NUMBER;
293:
294: l_aetv_tbl aetv_tbl_type := p_aetv_tbl;
295:
296: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
297:
298:
299:
300: BEGIN

Line 348: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

344: ,x_aetv_rec => x_aetv_tbl(i)
345:
346: );
347:
348: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
349: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
350: l_overall_status := x_return_status;
351: END IF;
352: END IF;

Line 349: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

345:
346: );
347:
348: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
349: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
350: l_overall_status := x_return_status;
351: END IF;
352: END IF;
353:

Line 392: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

388: WHEN FND_API.G_EXC_ERROR THEN
389: ROLLBACK TO create_acct_event;
390: x_return_status := FND_API.G_RET_STS_ERROR;
391:
392: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
393: ,p_count => x_msg_count
394: ,p_data => x_msg_data);
395:
396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 399: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

395:
396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
397: ROLLBACK TO create_acct_event;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
400: ,p_count => x_msg_count
401: ,p_data => x_msg_data);
402:
403: WHEN OTHERS THEN

Line 406: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

402:
403: WHEN OTHERS THEN
404: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_event');
405: -- store SQL error message on message stack for caller
406: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
407: ,p_count => x_msg_count
408: ,p_data => x_msg_data);
409: -- notify caller of an UNEXPECTED error
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 422: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

418: PROCEDURE update_acct_event(
419:
420: p_api_version IN NUMBER,
421:
422: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
423:
424: x_return_status OUT NOCOPY VARCHAR2,
425:
426: x_msg_count OUT NOCOPY NUMBER,

Line 442: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

438: x_aehv_tbl OUT NOCOPY aehv_tbl_type,
439:
440: x_aelv_tbl OUT NOCOPY aelv_tbl_type) IS
441:
442: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
443:
444: l_api_name CONSTANT VARCHAR2(30) := 'update_acct_event';
445:
446: l_aetv_rec aetv_rec_type := p_aetv_rec;

Line 534: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

530: WHEN FND_API.G_EXC_ERROR THEN
531: ROLLBACK TO update_acct_event;
532: x_return_status := FND_API.G_RET_STS_ERROR;
533:
534: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
535: ,p_count => x_msg_count
536: ,p_data => x_msg_data);
537:
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 541: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

537:
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: ROLLBACK TO update_acct_event;
540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
541: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
542: ,p_count => x_msg_count
543: ,p_data => x_msg_data);
544:
545: WHEN OTHERS THEN

Line 548: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

544:
545: WHEN OTHERS THEN
546: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_event');
547: -- store SQL error message on message stack for caller
548: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
549: ,p_count => x_msg_count
550: ,p_data => x_msg_data);
551: -- notify caller of an UNEXPECTED error
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 562: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

558: PROCEDURE validate_acct_event(
559:
560: p_api_version IN NUMBER
561:
562: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
563:
564: ,x_return_status OUT NOCOPY VARCHAR2
565:
566: ,x_msg_count OUT NOCOPY NUMBER

Line 578: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

574: ,p_aelv_tbl IN aelv_tbl_type) IS
575:
576:
577:
578: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
579:
580: l_api_name CONSTANT VARCHAR2(30) := 'validate_acct_event';
581:
582: l_aetv_rec aetv_rec_type := p_aetv_rec;

Line 663: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

659: WHEN FND_API.G_EXC_ERROR THEN
660: ROLLBACK TO validate_acct_event;
661: x_return_status := FND_API.G_RET_STS_ERROR;
662:
663: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
664: ,p_count => x_msg_count
665: ,p_data => x_msg_data);
666:
667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 670: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

666:
667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
668: ROLLBACK TO validate_acct_event;
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
671: ,p_count => x_msg_count
672: ,p_data => x_msg_data);
673:
674: WHEN OTHERS THEN

Line 677: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

673:
674: WHEN OTHERS THEN
675: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_event');
676: -- store SQL error message on message stack for caller
677: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
678: ,p_count => x_msg_count
679: ,p_data => x_msg_data);
680: -- notify caller of an UNEXPECTED error
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 691: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

687: PROCEDURE lock_acct_event(
688:
689: p_api_version IN NUMBER
690:
691: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
692:
693: ,x_return_status OUT NOCOPY VARCHAR2
694:
695: ,x_msg_count OUT NOCOPY NUMBER

Line 701: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

697: ,x_msg_data OUT NOCOPY VARCHAR2
698:
699: ,p_aetv_rec IN aetv_rec_type) IS
700:
701: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
702:
703: l_api_name CONSTANT VARCHAR2(30) := 'lock_acct_event';
704:
705:

Line 738: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

734: WHEN FND_API.G_EXC_ERROR THEN
735: ROLLBACK TO lock_acct_event;
736: x_return_status := FND_API.G_RET_STS_ERROR;
737:
738: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
739: ,p_count => x_msg_count
740: ,p_data => x_msg_data);
741:
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 745: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

741:
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: ROLLBACK TO lock_acct_event;
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
745: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
746: ,p_count => x_msg_count
747: ,p_data => x_msg_data);
748:
749: WHEN OTHERS THEN

Line 752: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

748:
749: WHEN OTHERS THEN
750: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_acct_event');
751: -- store SQL error message on message stack for caller
752: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
753: ,p_count => x_msg_count
754: ,p_data => x_msg_data);
755: -- notify caller of an UNEXPECTED error
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 766: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

762: PROCEDURE lock_acct_event(
763:
764: p_api_version IN NUMBER
765:
766: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
767:
768: ,x_return_status OUT NOCOPY VARCHAR2
769:
770: ,x_msg_count OUT NOCOPY NUMBER

Line 776: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

772: ,x_msg_data OUT NOCOPY VARCHAR2
773:
774: ,p_aetv_tbl IN aetv_tbl_type) IS
775:
776: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
777:
778: l_api_name CONSTANT VARCHAR2(30) := 'lock_acct_event';
779:
780: i NUMBER;

Line 782: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

778: l_api_name CONSTANT VARCHAR2(30) := 'lock_acct_event';
779:
780: i NUMBER;
781:
782: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
783:
784: BEGIN
785:
786: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 838: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

834: WHEN FND_API.G_EXC_ERROR THEN
835: ROLLBACK TO lock_acct_event;
836: x_return_status := FND_API.G_RET_STS_ERROR;
837:
838: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
839: ,p_count => x_msg_count
840: ,p_data => x_msg_data);
841:
842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 845: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

841:
842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
843: ROLLBACK TO lock_acct_event;
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
846: ,p_count => x_msg_count
847: ,p_data => x_msg_data);
848:
849: WHEN OTHERS THEN

Line 852: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

848:
849: WHEN OTHERS THEN
850: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_acct_event');
851: -- store SQL error message on message stack for caller
852: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
853: ,p_count => x_msg_count
854: ,p_data => x_msg_data);
855: -- notify caller of an UNEXPECTED error
856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 866: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

862: PROCEDURE update_acct_event(
863:
864: p_api_version IN NUMBER
865:
866: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
867:
868: ,x_return_status OUT NOCOPY VARCHAR2
869:
870: ,x_msg_count OUT NOCOPY NUMBER

Line 878: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

874: ,p_aetv_rec IN aetv_rec_type
875:
876: ,x_aetv_rec OUT NOCOPY aetv_rec_type) IS
877:
878: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
879:
880: l_api_name CONSTANT VARCHAR2(30) := 'update_acct_event';
881:
882: l_aetv_rec aetv_rec_type := p_aetv_rec;

Line 955: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

951: WHEN FND_API.G_EXC_ERROR THEN
952: ROLLBACK TO update_acct_event;
953: x_return_status := FND_API.G_RET_STS_ERROR;
954:
955: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
956: ,p_count => x_msg_count
957: ,p_data => x_msg_data);
958:
959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 962: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

958:
959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
960: ROLLBACK TO update_acct_event;
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
962: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
963: ,p_count => x_msg_count
964: ,p_data => x_msg_data);
965:
966: WHEN OTHERS THEN

Line 969: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

965:
966: WHEN OTHERS THEN
967: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_event');
968: -- store SQL error message on message stack for caller
969: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
970: ,p_count => x_msg_count
971: ,p_data => x_msg_data);
972: -- notify caller of an UNEXPECTED error
973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 983: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

979: PROCEDURE update_acct_event(
980:
981: p_api_version IN NUMBER
982:
983: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
984:
985: ,x_return_status OUT NOCOPY VARCHAR2
986:
987: ,x_msg_count OUT NOCOPY NUMBER

Line 995: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

991: ,p_aetv_tbl IN aetv_tbl_type
992:
993: ,x_aetv_tbl OUT NOCOPY aetv_tbl_type) IS
994:
995: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
996:
997: l_api_name CONSTANT VARCHAR2(30) := 'update_acct_event';
998:
999: i NUMBER;

Line 1002: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

998:
999: i NUMBER;
1000:
1001: l_aetv_tbl aetv_tbl_type := p_aetv_tbl;
1002: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1003:
1004: BEGIN
1005:
1006: --Initialize the return status

Line 1051: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

1047:
1048: );
1049:
1050:
1051: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1052: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1053: l_overall_status := x_return_status;
1054: END IF;
1055: END IF;

Line 1052: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

1048: );
1049:
1050:
1051: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1052: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1053: l_overall_status := x_return_status;
1054: END IF;
1055: END IF;
1056:

Line 1093: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1089: WHEN FND_API.G_EXC_ERROR THEN
1090: ROLLBACK TO update_acct_event;
1091: x_return_status := FND_API.G_RET_STS_ERROR;
1092:
1093: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1094: ,p_count => x_msg_count
1095: ,p_data => x_msg_data);
1096:
1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1100: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1096:
1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1098: ROLLBACK TO update_acct_event;
1099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1100: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1101: ,p_count => x_msg_count
1102: ,p_data => x_msg_data);
1103:
1104: WHEN OTHERS THEN

Line 1107: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1103:
1104: WHEN OTHERS THEN
1105: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_event');
1106: -- store SQL error message on message stack for caller
1107: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1108: ,p_count => x_msg_count
1109: ,p_data => x_msg_data);
1110: -- notify caller of an UNEXPECTED error
1111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1123: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1119: PROCEDURE delete_acct_event(
1120:
1121: p_api_version IN NUMBER
1122:
1123: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1124:
1125: ,x_return_status OUT NOCOPY VARCHAR2
1126:
1127: ,x_msg_count OUT NOCOPY NUMBER

Line 1135: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1131: ,p_aetv_rec IN aetv_rec_type) IS
1132:
1133: i NUMBER :=0;
1134:
1135: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1136:
1137: l_api_name CONSTANT VARCHAR2(30) := 'delete_acct_event';
1138:
1139:

Line 1212: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1208: WHEN FND_API.G_EXC_ERROR THEN
1209: ROLLBACK TO delete_acct_event;
1210: x_return_status := FND_API.G_RET_STS_ERROR;
1211:
1212: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1213: ,p_count => x_msg_count
1214: ,p_data => x_msg_data);
1215:
1216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1219: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1215:
1216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1217: ROLLBACK TO delete_acct_event;
1218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1219: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1220: ,p_count => x_msg_count
1221: ,p_data => x_msg_data);
1222:
1223: WHEN OTHERS THEN

Line 1226: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1222:
1223: WHEN OTHERS THEN
1224: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_event');
1225: -- store SQL error message on message stack for caller
1226: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1227: ,p_count => x_msg_count
1228: ,p_data => x_msg_data);
1229: -- notify caller of an UNEXPECTED error
1230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1240: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1236: PROCEDURE delete_acct_event(
1237:
1238: p_api_version IN NUMBER
1239:
1240: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1241:
1242: ,x_return_status OUT NOCOPY VARCHAR2
1243:
1244: ,x_msg_count OUT NOCOPY NUMBER

Line 1252: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1248: ,p_aetv_tbl IN aetv_tbl_type) IS
1249:
1250: i NUMBER :=0;
1251:
1252: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1253:
1254: l_api_name CONSTANT VARCHAR2(30) := 'delete_acct_event';
1255:
1256: l_aetv_tbl aetv_tbl_type := p_aetv_tbl;

Line 1257: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1253:
1254: l_api_name CONSTANT VARCHAR2(30) := 'delete_acct_event';
1255:
1256: l_aetv_tbl aetv_tbl_type := p_aetv_tbl;
1257: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1258:
1259: BEGIN
1260:
1261: --Initialize the return status

Line 1302: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

1298: ,p_aetv_rec => l_aetv_tbl(i)
1299:
1300: );
1301:
1302: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1303: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1304: l_overall_status := x_return_status;
1305: END IF;
1306: END IF;

Line 1303: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

1299:
1300: );
1301:
1302: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1303: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1304: l_overall_status := x_return_status;
1305: END IF;
1306: END IF;
1307:

Line 1345: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1341: WHEN FND_API.G_EXC_ERROR THEN
1342: ROLLBACK TO delete_acct_event;
1343: x_return_status := FND_API.G_RET_STS_ERROR;
1344:
1345: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1346: ,p_count => x_msg_count
1347: ,p_data => x_msg_data);
1348:
1349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1352: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1348:
1349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1350: ROLLBACK TO delete_acct_event;
1351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1352: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1353: ,p_count => x_msg_count
1354: ,p_data => x_msg_data);
1355:
1356: WHEN OTHERS THEN

Line 1359: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1355:
1356: WHEN OTHERS THEN
1357: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_event');
1358: -- store SQL error message on message stack for caller
1359: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1360: ,p_count => x_msg_count
1361: ,p_data => x_msg_data);
1362: -- notify caller of an UNEXPECTED error
1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1374: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1370: PROCEDURE validate_acct_event(
1371:
1372: p_api_version IN NUMBER
1373:
1374: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1375:
1376: ,x_return_status OUT NOCOPY VARCHAR2
1377:
1378: ,x_msg_count OUT NOCOPY NUMBER

Line 1384: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1380: ,x_msg_data OUT NOCOPY VARCHAR2
1381:
1382: ,p_aetv_rec IN aetv_rec_type) IS
1383:
1384: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1385:
1386: l_api_name CONSTANT VARCHAR2(30) := 'validate_acct_event';
1387:
1388: l_aetv_rec aetv_rec_type := p_aetv_rec;

Line 1461: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1457: WHEN FND_API.G_EXC_ERROR THEN
1458: ROLLBACK TO validate_acct_event;
1459: x_return_status := FND_API.G_RET_STS_ERROR;
1460:
1461: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1462: ,p_count => x_msg_count
1463: ,p_data => x_msg_data);
1464:
1465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1468: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1464:
1465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1466: ROLLBACK TO validate_acct_event;
1467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1468: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1469: ,p_count => x_msg_count
1470: ,p_data => x_msg_data);
1471:
1472: WHEN OTHERS THEN

Line 1475: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1471:
1472: WHEN OTHERS THEN
1473: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_event');
1474: -- store SQL error message on message stack for caller
1475: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1476: ,p_count => x_msg_count
1477: ,p_data => x_msg_data);
1478: -- notify caller of an UNEXPECTED error
1479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1489: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1485: PROCEDURE validate_acct_event(
1486:
1487: p_api_version IN NUMBER,
1488:
1489: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1490:
1491: x_return_status OUT NOCOPY VARCHAR2,
1492:
1493: x_msg_count OUT NOCOPY NUMBER,

Line 1499: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1495: x_msg_data OUT NOCOPY VARCHAR2,
1496:
1497: p_aetv_tbl IN aetv_tbl_type) IS
1498:
1499: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1500:
1501: l_api_name CONSTANT VARCHAR2(30) := 'validate_acct_event';
1502:
1503: i NUMBER;

Line 1506: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1502:
1503: i NUMBER;
1504:
1505: l_aetv_tbl aetv_tbl_type := p_aetv_tbl;
1506: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1507:
1508: BEGIN
1509:
1510: --Initialize the return status

Line 1553: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

1549: ,p_aetv_rec => l_aetv_tbl(i)
1550:
1551: );
1552:
1553: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1554: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1555: l_overall_status := x_return_status;
1556: END IF;
1557: END IF;

Line 1554: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

1550:
1551: );
1552:
1553: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1554: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1555: l_overall_status := x_return_status;
1556: END IF;
1557: END IF;
1558:

Line 1595: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1591: WHEN FND_API.G_EXC_ERROR THEN
1592: ROLLBACK TO validate_acct_event;
1593: x_return_status := FND_API.G_RET_STS_ERROR;
1594:
1595: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1596: ,p_count => x_msg_count
1597: ,p_data => x_msg_data);
1598:
1599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1602: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1598:
1599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1600: ROLLBACK TO validate_acct_event;
1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1603: ,p_count => x_msg_count
1604: ,p_data => x_msg_data);
1605:
1606: WHEN OTHERS THEN

Line 1609: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1605:
1606: WHEN OTHERS THEN
1607: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_event');
1608: -- store SQL error message on message stack for caller
1609: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1610: ,p_count => x_msg_count
1611: ,p_data => x_msg_data);
1612: -- notify caller of an UNEXPECTED error
1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1623: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1619: PROCEDURE create_acct_header(
1620:
1621: p_api_version IN NUMBER
1622:
1623: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1624:
1625: ,x_return_status OUT NOCOPY VARCHAR2
1626:
1627: ,x_msg_count OUT NOCOPY NUMBER

Line 1635: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1631: ,p_aehv_rec IN aehv_rec_type
1632:
1633: ,x_aehv_rec OUT NOCOPY aehv_rec_type) IS
1634:
1635: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1636:
1637: l_api_name CONSTANT VARCHAR2(30) := 'create_acct_header';
1638:
1639: l_aehv_rec aehv_rec_type := p_aehv_rec;

Line 1718: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1714: WHEN FND_API.G_EXC_ERROR THEN
1715: ROLLBACK TO create_acct_header;
1716: x_return_status := FND_API.G_RET_STS_ERROR;
1717:
1718: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1719: ,p_count => x_msg_count
1720: ,p_data => x_msg_data);
1721:
1722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1725: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1721:
1722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1723: ROLLBACK TO create_acct_header;
1724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1725: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1726: ,p_count => x_msg_count
1727: ,p_data => x_msg_data);
1728:
1729: WHEN OTHERS THEN

Line 1732: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1728:
1729: WHEN OTHERS THEN
1730: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_header');
1731: -- store SQL error message on message stack for caller
1732: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1733: ,p_count => x_msg_count
1734: ,p_data => x_msg_data);
1735: -- notify caller of an UNEXPECTED error
1736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1746: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1742: PROCEDURE create_acct_header(
1743:
1744: p_api_version IN NUMBER
1745:
1746: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1747:
1748: ,x_return_status OUT NOCOPY VARCHAR2
1749:
1750: ,x_msg_count OUT NOCOPY NUMBER

Line 1758: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1754: ,p_aehv_tbl IN aehv_tbl_type
1755:
1756: ,x_aehv_tbl OUT NOCOPY aehv_tbl_type) IS
1757:
1758: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1759:
1760: l_api_name CONSTANT VARCHAR2(30) := 'create_acct_header';
1761:
1762: i NUMBER;

Line 1765: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1761:
1762: i NUMBER;
1763:
1764: l_aehv_tbl aehv_tbl_type := p_aehv_tbl;
1765: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1766:
1767: BEGIN
1768:
1769: --Initialize the return status

Line 1814: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

1810: ,x_aehv_rec => x_aehv_tbl(i)
1811:
1812: );
1813:
1814: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1815: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1816: l_overall_status := x_return_status;
1817: END IF;
1818: END IF;

Line 1815: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

1811:
1812: );
1813:
1814: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1815: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1816: l_overall_status := x_return_status;
1817: END IF;
1818: END IF;
1819:

Line 1856: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1852: WHEN FND_API.G_EXC_ERROR THEN
1853: ROLLBACK TO create_acct_header;
1854: x_return_status := FND_API.G_RET_STS_ERROR;
1855:
1856: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1857: ,p_count => x_msg_count
1858: ,p_data => x_msg_data);
1859:
1860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1863: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1859:
1860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1861: ROLLBACK TO create_acct_header;
1862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1863: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1864: ,p_count => x_msg_count
1865: ,p_data => x_msg_data);
1866:
1867: WHEN OTHERS THEN

Line 1870: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1866:
1867: WHEN OTHERS THEN
1868: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_header');
1869: -- store SQL error message on message stack for caller
1870: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1871: ,p_count => x_msg_count
1872: ,p_data => x_msg_data);
1873: -- notify caller of an UNEXPECTED error
1874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1884: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1880: PROCEDURE lock_acct_header(
1881:
1882: p_api_version IN NUMBER
1883:
1884: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1885:
1886: ,x_return_status OUT NOCOPY VARCHAR2
1887:
1888: ,x_msg_count OUT NOCOPY NUMBER

Line 1894: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1890: ,x_msg_data OUT NOCOPY VARCHAR2
1891:
1892: ,p_aehv_rec IN aehv_rec_type) IS
1893:
1894: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1895:
1896: l_api_name CONSTANT VARCHAR2(30) := 'lock_acct_header';
1897:
1898: BEGIN

Line 1931: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1927: WHEN FND_API.G_EXC_ERROR THEN
1928: ROLLBACK TO lock_acct_header;
1929: x_return_status := FND_API.G_RET_STS_ERROR;
1930:
1931: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1932: ,p_count => x_msg_count
1933: ,p_data => x_msg_data);
1934:
1935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1938: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1934:
1935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1936: ROLLBACK TO lock_acct_header;
1937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1938: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1939: ,p_count => x_msg_count
1940: ,p_data => x_msg_data);
1941:
1942: WHEN OTHERS THEN

Line 1945: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1941:
1942: WHEN OTHERS THEN
1943: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_acct_header');
1944: -- store SQL error message on message stack for caller
1945: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1946: ,p_count => x_msg_count
1947: ,p_data => x_msg_data);
1948: -- notify caller of an UNEXPECTED error
1949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1959: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1955: PROCEDURE lock_acct_header(
1956:
1957: p_api_version IN NUMBER
1958:
1959: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1960:
1961: ,x_return_status OUT NOCOPY VARCHAR2
1962:
1963: ,x_msg_count OUT NOCOPY NUMBER

Line 1969: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1965: ,x_msg_data OUT NOCOPY VARCHAR2
1966:
1967: ,p_aehv_tbl IN aehv_tbl_type) IS
1968:
1969: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1970:
1971: l_api_name CONSTANT VARCHAR2(30) := 'lock_acct_header';
1972:
1973: i NUMBER;

Line 1975: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1971: l_api_name CONSTANT VARCHAR2(30) := 'lock_acct_header';
1972:
1973: i NUMBER;
1974:
1975: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1976:
1977: BEGIN
1978:
1979: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2031: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2027: WHEN FND_API.G_EXC_ERROR THEN
2028: ROLLBACK TO lock_acct_header;
2029: x_return_status := FND_API.G_RET_STS_ERROR;
2030:
2031: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2032: ,p_count => x_msg_count
2033: ,p_data => x_msg_data);
2034:
2035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2038: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2034:
2035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2036: ROLLBACK TO lock_acct_header;
2037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2038: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2039: ,p_count => x_msg_count
2040: ,p_data => x_msg_data);
2041:
2042: WHEN OTHERS THEN

Line 2045: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2041:
2042: WHEN OTHERS THEN
2043: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_acct_header');
2044: -- store SQL error message on message stack for caller
2045: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2046: ,p_count => x_msg_count
2047: ,p_data => x_msg_data);
2048: -- notify caller of an UNEXPECTED error
2049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2059: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2055: PROCEDURE update_acct_header(
2056:
2057: p_api_version IN NUMBER
2058:
2059: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2060:
2061: ,x_return_status OUT NOCOPY VARCHAR2
2062:
2063: ,x_msg_count OUT NOCOPY NUMBER

Line 2071: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2067: ,p_aehv_rec IN aehv_rec_type
2068:
2069: ,x_aehv_rec OUT NOCOPY aehv_rec_type) IS
2070:
2071: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2072:
2073: l_api_name CONSTANT VARCHAR2(30) := 'update_acct_header';
2074:
2075: l_aehv_rec aehv_rec_type := p_aehv_rec;

Line 2147: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2143: WHEN FND_API.G_EXC_ERROR THEN
2144: ROLLBACK TO update_acct_header;
2145: x_return_status := FND_API.G_RET_STS_ERROR;
2146:
2147: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2148: ,p_count => x_msg_count
2149: ,p_data => x_msg_data);
2150:
2151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2154: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2150:
2151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2152: ROLLBACK TO update_acct_header;
2153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2154: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2155: ,p_count => x_msg_count
2156: ,p_data => x_msg_data);
2157:
2158: WHEN OTHERS THEN

Line 2161: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2157:
2158: WHEN OTHERS THEN
2159: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_header');
2160: -- store SQL error message on message stack for caller
2161: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2162: ,p_count => x_msg_count
2163: ,p_data => x_msg_data);
2164: -- notify caller of an UNEXPECTED error
2165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2175: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2171: PROCEDURE update_acct_header(
2172:
2173: p_api_version IN NUMBER
2174:
2175: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2176:
2177: ,x_return_status OUT NOCOPY VARCHAR2
2178:
2179: ,x_msg_count OUT NOCOPY NUMBER

Line 2187: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2183: ,p_aehv_tbl IN aehv_tbl_type
2184:
2185: ,x_aehv_tbl OUT NOCOPY aehv_tbl_type) IS
2186:
2187: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2188:
2189: l_api_name CONSTANT VARCHAR2(30) := 'update_acct_header';
2190:
2191: i NUMBER;

Line 2194: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2190:
2191: i NUMBER;
2192:
2193: l_aehv_tbl aehv_tbl_type := p_aehv_tbl;
2194: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2195:
2196:
2197:
2198: BEGIN

Line 2243: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

2239: ,x_aehv_rec => x_aehv_tbl(i)
2240:
2241: );
2242:
2243: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2244: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2245: l_overall_status := x_return_status;
2246: END IF;
2247: END IF;

Line 2244: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

2240:
2241: );
2242:
2243: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2244: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2245: l_overall_status := x_return_status;
2246: END IF;
2247: END IF;
2248:

Line 2287: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2283: WHEN FND_API.G_EXC_ERROR THEN
2284: ROLLBACK TO update_acct_header;
2285: x_return_status := FND_API.G_RET_STS_ERROR;
2286:
2287: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2288: ,p_count => x_msg_count
2289: ,p_data => x_msg_data);
2290:
2291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2294: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2290:
2291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2292: ROLLBACK TO update_acct_header;
2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2294: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2295: ,p_count => x_msg_count
2296: ,p_data => x_msg_data);
2297:
2298: WHEN OTHERS THEN

Line 2301: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2297:
2298: WHEN OTHERS THEN
2299: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_header');
2300: -- store SQL error message on message stack for caller
2301: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2302: ,p_count => x_msg_count
2303: ,p_data => x_msg_data);
2304: -- notify caller of an UNEXPECTED error
2305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2317: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2313: PROCEDURE delete_acct_header(
2314:
2315: p_api_version IN NUMBER
2316:
2317: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2318:
2319: ,x_return_status OUT NOCOPY VARCHAR2
2320:
2321: ,x_msg_count OUT NOCOPY NUMBER

Line 2329: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2325: ,p_aehv_rec IN aehv_rec_type) IS
2326:
2327: i NUMBER :=0;
2328:
2329: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2330:
2331: l_api_name CONSTANT VARCHAR2(30) := 'delete_acct_header';
2332:
2333: l_aehv_rec aehv_rec_type := p_aehv_rec;

Line 2402: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2398: WHEN FND_API.G_EXC_ERROR THEN
2399: ROLLBACK TO delete_acct_header;
2400: x_return_status := FND_API.G_RET_STS_ERROR;
2401:
2402: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2403: ,p_count => x_msg_count
2404: ,p_data => x_msg_data);
2405:
2406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2409: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2405:
2406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2407: ROLLBACK TO delete_acct_header;
2408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2409: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2410: ,p_count => x_msg_count
2411: ,p_data => x_msg_data);
2412:
2413: WHEN OTHERS THEN

Line 2416: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2412:
2413: WHEN OTHERS THEN
2414: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_header');
2415: -- store SQL error message on message stack for caller
2416: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2417: ,p_count => x_msg_count
2418: ,p_data => x_msg_data);
2419: -- notify caller of an UNEXPECTED error
2420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2430: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2426: PROCEDURE delete_acct_header(
2427:
2428: p_api_version IN NUMBER
2429:
2430: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2431:
2432: ,x_return_status OUT NOCOPY VARCHAR2
2433:
2434: ,x_msg_count OUT NOCOPY NUMBER

Line 2444: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2440:
2441:
2442: i NUMBER :=0;
2443:
2444: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2445:
2446: l_api_name CONSTANT VARCHAR2(30) := 'delete_acct_header';
2447:
2448: l_aehv_tbl aehv_tbl_type := p_aehv_tbl;

Line 2449: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2445:
2446: l_api_name CONSTANT VARCHAR2(30) := 'delete_acct_header';
2447:
2448: l_aehv_tbl aehv_tbl_type := p_aehv_tbl;
2449: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2450:
2451:
2452: BEGIN
2453:

Line 2496: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

2492: ,x_msg_data => x_msg_data
2493:
2494: ,p_aehv_rec => l_aehv_tbl(i));
2495:
2496: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2497: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2498: l_overall_status := x_return_status;
2499: END IF;
2500: END IF;

Line 2497: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

2493:
2494: ,p_aehv_rec => l_aehv_tbl(i));
2495:
2496: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2497: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2498: l_overall_status := x_return_status;
2499: END IF;
2500: END IF;
2501:

Line 2539: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2535: WHEN FND_API.G_EXC_ERROR THEN
2536: ROLLBACK TO delete_acct_header;
2537: x_return_status := FND_API.G_RET_STS_ERROR;
2538:
2539: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2540: ,p_count => x_msg_count
2541: ,p_data => x_msg_data);
2542:
2543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2546: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2542:
2543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2544: ROLLBACK TO delete_acct_header;
2545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2546: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2547: ,p_count => x_msg_count
2548: ,p_data => x_msg_data);
2549:
2550: WHEN OTHERS THEN

Line 2553: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2549:
2550: WHEN OTHERS THEN
2551: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_header');
2552: -- store SQL error message on message stack for caller
2553: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2554: ,p_count => x_msg_count
2555: ,p_data => x_msg_data);
2556: -- notify caller of an UNEXPECTED error
2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2567: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2563: PROCEDURE validate_acct_header(
2564:
2565: p_api_version IN NUMBER
2566:
2567: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2568:
2569: ,x_return_status OUT NOCOPY VARCHAR2
2570:
2571: ,x_msg_count OUT NOCOPY NUMBER

Line 2577: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2573: ,x_msg_data OUT NOCOPY VARCHAR2
2574:
2575: ,p_aehv_rec IN aehv_rec_type) IS
2576:
2577: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2578:
2579: l_api_name CONSTANT VARCHAR2(30) := 'validate_acct_header';
2580:
2581: l_aehv_rec aehv_rec_type := p_aehv_rec;

Line 2652: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2648: WHEN FND_API.G_EXC_ERROR THEN
2649: ROLLBACK TO validate_acct_header;
2650: x_return_status := FND_API.G_RET_STS_ERROR;
2651:
2652: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2653: ,p_count => x_msg_count
2654: ,p_data => x_msg_data);
2655:
2656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2659: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2655:
2656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2657: ROLLBACK TO validate_acct_header;
2658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2659: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2660: ,p_count => x_msg_count
2661: ,p_data => x_msg_data);
2662:
2663: WHEN OTHERS THEN

Line 2666: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2662:
2663: WHEN OTHERS THEN
2664: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_header');
2665: -- store SQL error message on message stack for caller
2666: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2667: ,p_count => x_msg_count
2668: ,p_data => x_msg_data);
2669: -- notify caller of an UNEXPECTED error
2670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2680: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2676: PROCEDURE validate_acct_header(
2677:
2678: p_api_version IN NUMBER
2679:
2680: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2681:
2682: ,x_return_status OUT NOCOPY VARCHAR2
2683:
2684: ,x_msg_count OUT NOCOPY NUMBER

Line 2690: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2686: ,x_msg_data OUT NOCOPY VARCHAR2
2687:
2688: ,p_aehv_tbl IN aehv_tbl_type) IS
2689:
2690: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2691:
2692: l_api_name CONSTANT VARCHAR2(30) := 'validate_acct_header';
2693:
2694: i NUMBER;

Line 2697: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2693:
2694: i NUMBER;
2695:
2696: l_aehv_tbl aehv_tbl_type := p_aehv_tbl;
2697: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2698:
2699:
2700: BEGIN
2701:

Line 2746: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

2742:
2743: ,p_aehv_rec => l_aehv_tbl(i)
2744:
2745: );
2746: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2747: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2748: l_overall_status := x_return_status;
2749: END IF;
2750: END IF;

Line 2747: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

2743: ,p_aehv_rec => l_aehv_tbl(i)
2744:
2745: );
2746: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2747: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2748: l_overall_status := x_return_status;
2749: END IF;
2750: END IF;
2751:

Line 2792: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2788: WHEN FND_API.G_EXC_ERROR THEN
2789: ROLLBACK TO validate_acct_header;
2790: x_return_status := FND_API.G_RET_STS_ERROR;
2791:
2792: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2793: ,p_count => x_msg_count
2794: ,p_data => x_msg_data);
2795:
2796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2799: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2795:
2796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2797: ROLLBACK TO validate_acct_header;
2798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2799: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2800: ,p_count => x_msg_count
2801: ,p_data => x_msg_data);
2802:
2803: WHEN OTHERS THEN

Line 2806: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2802:
2803: WHEN OTHERS THEN
2804: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_header');
2805: -- store SQL error message on message stack for caller
2806: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2807: ,p_count => x_msg_count
2808: ,p_data => x_msg_data);
2809: -- notify caller of an UNEXPECTED error
2810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2819: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2815: PROCEDURE create_acct_lines(
2816:
2817: p_api_version IN NUMBER
2818:
2819: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2820:
2821: ,x_return_status OUT NOCOPY VARCHAR2
2822:
2823: ,x_msg_count OUT NOCOPY NUMBER

Line 2831: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2827: ,p_aelv_rec IN aelv_rec_type
2828:
2829: ,x_aelv_rec OUT NOCOPY aelv_rec_type) IS
2830:
2831: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2832:
2833: l_api_name CONSTANT VARCHAR2(30) := 'create_acct_lines';
2834:
2835: l_aelv_rec aelv_rec_type := p_aelv_rec;

Line 2915: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2911: WHEN FND_API.G_EXC_ERROR THEN
2912: ROLLBACK TO create_acct_lines;
2913: x_return_status := FND_API.G_RET_STS_ERROR;
2914:
2915: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2916: ,p_count => x_msg_count
2917: ,p_data => x_msg_data);
2918:
2919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2922: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2918:
2919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2920: ROLLBACK TO create_acct_lines;
2921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2922: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2923: ,p_count => x_msg_count
2924: ,p_data => x_msg_data);
2925:
2926: WHEN OTHERS THEN

Line 2929: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

2925:
2926: WHEN OTHERS THEN
2927: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_lines');
2928: -- store SQL error message on message stack for caller
2929: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2930: ,p_count => x_msg_count
2931: ,p_data => x_msg_data);
2932: -- notify caller of an UNEXPECTED error
2933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2943: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2939: PROCEDURE create_acct_lines(
2940:
2941: p_api_version IN NUMBER
2942:
2943: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2944:
2945: ,x_return_status OUT NOCOPY VARCHAR2
2946:
2947: ,x_msg_count OUT NOCOPY NUMBER

Line 2955: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2951: ,p_aelv_tbl IN aelv_tbl_type
2952:
2953: ,x_aelv_tbl OUT NOCOPY aelv_tbl_type) IS
2954:
2955: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2956:
2957: l_api_name CONSTANT VARCHAR2(30) := 'create_acct_lines';
2958:
2959: i NUMBER;

Line 2962: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2958:
2959: i NUMBER;
2960:
2961: l_aelv_tbl aelv_tbl_type := p_aelv_tbl;
2962: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2963:
2964: BEGIN
2965:
2966: --Initialize the return status

Line 3012: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

3008:
3009: ,x_aelv_rec => x_aelv_tbl(i)
3010:
3011: );
3012: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
3013: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
3014: l_overall_status := x_return_status;
3015: END IF;
3016: END IF;

Line 3013: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

3009: ,x_aelv_rec => x_aelv_tbl(i)
3010:
3011: );
3012: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
3013: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
3014: l_overall_status := x_return_status;
3015: END IF;
3016: END IF;
3017:

Line 3057: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3053: WHEN FND_API.G_EXC_ERROR THEN
3054: ROLLBACK TO create_acct_lines;
3055: x_return_status := FND_API.G_RET_STS_ERROR;
3056:
3057: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3058: ,p_count => x_msg_count
3059: ,p_data => x_msg_data);
3060:
3061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3064: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3060:
3061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3062: ROLLBACK TO create_acct_lines;
3063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3064: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3065: ,p_count => x_msg_count
3066: ,p_data => x_msg_data);
3067:
3068: WHEN OTHERS THEN

Line 3071: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3067:
3068: WHEN OTHERS THEN
3069: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_lines');
3070: -- store SQL error message on message stack for caller
3071: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3072: ,p_count => x_msg_count
3073: ,p_data => x_msg_data);
3074: -- notify caller of an UNEXPECTED error
3075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3085: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

3081: PROCEDURE lock_acct_lines(
3082:
3083: p_api_version IN NUMBER
3084:
3085: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3086:
3087: ,x_return_status OUT NOCOPY VARCHAR2
3088:
3089: ,x_msg_count OUT NOCOPY NUMBER

Line 3095: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3091: ,x_msg_data OUT NOCOPY VARCHAR2
3092:
3093: ,p_aelv_rec IN aelv_rec_type) IS
3094:
3095: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3096:
3097: l_api_name CONSTANT VARCHAR2(30) := 'lock_acct_lines';
3098:
3099: BEGIN

Line 3131: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3127: WHEN FND_API.G_EXC_ERROR THEN
3128: ROLLBACK TO lock_acct_lines;
3129: x_return_status := FND_API.G_RET_STS_ERROR;
3130:
3131: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3132: ,p_count => x_msg_count
3133: ,p_data => x_msg_data);
3134:
3135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3138: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3134:
3135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3136: ROLLBACK TO lock_acct_lines;
3137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3138: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3139: ,p_count => x_msg_count
3140: ,p_data => x_msg_data);
3141:
3142: WHEN OTHERS THEN

Line 3145: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3141:
3142: WHEN OTHERS THEN
3143: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_acct_lines');
3144: -- store SQL error message on message stack for caller
3145: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3146: ,p_count => x_msg_count
3147: ,p_data => x_msg_data);
3148: -- notify caller of an UNEXPECTED error
3149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3159: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

3155: PROCEDURE lock_acct_lines(
3156:
3157: p_api_version IN NUMBER
3158:
3159: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3160:
3161: ,x_return_status OUT NOCOPY VARCHAR2
3162:
3163: ,x_msg_count OUT NOCOPY NUMBER

Line 3169: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3165: ,x_msg_data OUT NOCOPY VARCHAR2
3166:
3167: ,p_aelv_tbl IN aelv_tbl_type) IS
3168:
3169: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3170:
3171: l_api_name CONSTANT VARCHAR2(30) := 'lock_acct_lines';
3172:
3173: i NUMBER;

Line 3175: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3171: l_api_name CONSTANT VARCHAR2(30) := 'lock_acct_lines';
3172:
3173: i NUMBER;
3174:
3175: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3176:
3177: BEGIN
3178:
3179: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3231: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3227: WHEN FND_API.G_EXC_ERROR THEN
3228: ROLLBACK TO lock_acct_lines;
3229: x_return_status := FND_API.G_RET_STS_ERROR;
3230:
3231: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3232: ,p_count => x_msg_count
3233: ,p_data => x_msg_data);
3234:
3235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3238: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3234:
3235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3236: ROLLBACK TO lock_acct_lines;
3237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3238: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3239: ,p_count => x_msg_count
3240: ,p_data => x_msg_data);
3241:
3242: WHEN OTHERS THEN

Line 3245: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3241:
3242: WHEN OTHERS THEN
3243: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_acct_lines');
3244: -- store SQL error message on message stack for caller
3245: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3246: ,p_count => x_msg_count
3247: ,p_data => x_msg_data);
3248: -- notify caller of an UNEXPECTED error
3249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3259: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

3255: PROCEDURE update_acct_lines(
3256:
3257: p_api_version IN NUMBER
3258:
3259: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3260:
3261: ,x_return_status OUT NOCOPY VARCHAR2
3262:
3263: ,x_msg_count OUT NOCOPY NUMBER

Line 3271: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3267: ,p_aelv_rec IN aelv_rec_type
3268:
3269: ,x_aelv_rec OUT NOCOPY aelv_rec_type) IS
3270:
3271: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3272:
3273: l_api_name CONSTANT VARCHAR2(30) := 'update_acct_lines';
3274:
3275: l_aelv_rec aelv_rec_type := p_aelv_rec;

Line 3347: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3343: WHEN FND_API.G_EXC_ERROR THEN
3344: ROLLBACK TO update_acct_lines;
3345: x_return_status := FND_API.G_RET_STS_ERROR;
3346:
3347: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3348: ,p_count => x_msg_count
3349: ,p_data => x_msg_data);
3350:
3351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3354: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3350:
3351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3352: ROLLBACK TO update_acct_lines;
3353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3354: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3355: ,p_count => x_msg_count
3356: ,p_data => x_msg_data);
3357:
3358: WHEN OTHERS THEN

Line 3361: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3357:
3358: WHEN OTHERS THEN
3359: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_lines');
3360: -- store SQL error message on message stack for caller
3361: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3362: ,p_count => x_msg_count
3363: ,p_data => x_msg_data);
3364: -- notify caller of an UNEXPECTED error
3365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3375: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

3371: PROCEDURE update_acct_lines(
3372:
3373: p_api_version IN NUMBER
3374:
3375: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3376:
3377: ,x_return_status OUT NOCOPY VARCHAR2
3378:
3379: ,x_msg_count OUT NOCOPY NUMBER

Line 3387: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3383: ,p_aelv_tbl IN aelv_tbl_type
3384:
3385: ,x_aelv_tbl OUT NOCOPY aelv_tbl_type) IS
3386:
3387: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3388:
3389: l_api_name CONSTANT VARCHAR2(30) := 'update_acct_lines';
3390:
3391: i NUMBER;

Line 3394: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3390:
3391: i NUMBER;
3392:
3393: l_aelv_tbl aelv_tbl_type := p_aelv_tbl;
3394: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3395:
3396: BEGIN
3397:
3398: --Initialize the return status

Line 3442: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

3438: ,x_aelv_rec => x_aelv_tbl(i)
3439:
3440: );
3441:
3442: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
3443: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
3444: l_overall_status := x_return_status;
3445: END IF;
3446: END IF;

Line 3443: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

3439:
3440: );
3441:
3442: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
3443: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
3444: l_overall_status := x_return_status;
3445: END IF;
3446: END IF;
3447:

Line 3489: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3485: WHEN FND_API.G_EXC_ERROR THEN
3486: ROLLBACK TO update_acct_lines;
3487: x_return_status := FND_API.G_RET_STS_ERROR;
3488:
3489: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3490: ,p_count => x_msg_count
3491: ,p_data => x_msg_data);
3492:
3493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3496: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3492:
3493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3494: ROLLBACK TO update_acct_lines;
3495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3496: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3497: ,p_count => x_msg_count
3498: ,p_data => x_msg_data);
3499:
3500: WHEN OTHERS THEN

Line 3503: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3499:
3500: WHEN OTHERS THEN
3501: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_lines');
3502: -- store SQL error message on message stack for caller
3503: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3504: ,p_count => x_msg_count
3505: ,p_data => x_msg_data);
3506: -- notify caller of an UNEXPECTED error
3507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3519: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

3515: PROCEDURE delete_acct_lines(
3516:
3517: p_api_version IN NUMBER
3518:
3519: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3520:
3521: ,x_return_status OUT NOCOPY VARCHAR2
3522:
3523: ,x_msg_count OUT NOCOPY NUMBER

Line 3531: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3527: ,p_aelv_rec IN aelv_rec_type) IS
3528:
3529: i NUMBER :=0;
3530:
3531: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3532:
3533: l_api_name CONSTANT VARCHAR2(30) := 'delete_acct_lines';
3534:
3535: l_aelv_rec aelv_rec_type := p_aelv_rec;

Line 3604: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3600: WHEN FND_API.G_EXC_ERROR THEN
3601: ROLLBACK TO delete_acct_lines;
3602: x_return_status := FND_API.G_RET_STS_ERROR;
3603:
3604: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3605: ,p_count => x_msg_count
3606: ,p_data => x_msg_data);
3607:
3608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3611: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3607:
3608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3609: ROLLBACK TO delete_acct_lines;
3610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3611: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3612: ,p_count => x_msg_count
3613: ,p_data => x_msg_data);
3614:
3615: WHEN OTHERS THEN

Line 3618: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3614:
3615: WHEN OTHERS THEN
3616: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_lines');
3617: -- store SQL error message on message stack for caller
3618: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3619: ,p_count => x_msg_count
3620: ,p_data => x_msg_data);
3621: -- notify caller of an UNEXPECTED error
3622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3632: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

3628: PROCEDURE delete_acct_lines(
3629:
3630: p_api_version IN NUMBER
3631:
3632: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3633:
3634: ,x_return_status OUT NOCOPY VARCHAR2
3635:
3636: ,x_msg_count OUT NOCOPY NUMBER

Line 3646: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3642:
3643:
3644: i NUMBER :=0;
3645:
3646: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3647:
3648: l_api_name CONSTANT VARCHAR2(30) := 'delete_acct_lines';
3649:
3650: l_aelv_tbl aelv_tbl_type := p_aelv_tbl;

Line 3651: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3647:
3648: l_api_name CONSTANT VARCHAR2(30) := 'delete_acct_lines';
3649:
3650: l_aelv_tbl aelv_tbl_type := p_aelv_tbl;
3651: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3652:
3653: BEGIN
3654:
3655: --Initialize the return status

Line 3697: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

3693: ,x_msg_data => x_msg_data
3694:
3695: ,p_aelv_rec => l_aelv_tbl(i));
3696:
3697: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
3698: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
3699: l_overall_status := x_return_status;
3700: END IF;
3701: END IF;

Line 3698: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

3694:
3695: ,p_aelv_rec => l_aelv_tbl(i));
3696:
3697: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
3698: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
3699: l_overall_status := x_return_status;
3700: END IF;
3701: END IF;
3702:

Line 3743: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3739: WHEN FND_API.G_EXC_ERROR THEN
3740: ROLLBACK TO delete_acct_lines;
3741: x_return_status := FND_API.G_RET_STS_ERROR;
3742:
3743: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3744: ,p_count => x_msg_count
3745: ,p_data => x_msg_data);
3746:
3747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3750: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3746:
3747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3748: ROLLBACK TO delete_acct_lines;
3749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3750: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3751: ,p_count => x_msg_count
3752: ,p_data => x_msg_data);
3753:
3754: WHEN OTHERS THEN

Line 3757: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3753:
3754: WHEN OTHERS THEN
3755: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_lines');
3756: -- store SQL error message on message stack for caller
3757: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3758: ,p_count => x_msg_count
3759: ,p_data => x_msg_data);
3760: -- notify caller of an UNEXPECTED error
3761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3771: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

3767: PROCEDURE validate_acct_lines(
3768:
3769: p_api_version IN NUMBER
3770:
3771: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3772:
3773: ,x_return_status OUT NOCOPY VARCHAR2
3774:
3775: ,x_msg_count OUT NOCOPY NUMBER

Line 3781: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3777: ,x_msg_data OUT NOCOPY VARCHAR2
3778:
3779: ,p_aelv_rec IN aelv_rec_type) IS
3780:
3781: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3782:
3783: l_api_name CONSTANT VARCHAR2(30) := 'validate_acct_lines';
3784:
3785: l_aelv_rec aelv_rec_type := p_aelv_rec;

Line 3856: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3852: WHEN FND_API.G_EXC_ERROR THEN
3853: ROLLBACK TO validate_acct_lines;
3854: x_return_status := FND_API.G_RET_STS_ERROR;
3855:
3856: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3857: ,p_count => x_msg_count
3858: ,p_data => x_msg_data);
3859:
3860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3863: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3859:
3860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3861: ROLLBACK TO validate_acct_lines;
3862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3863: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3864: ,p_count => x_msg_count
3865: ,p_data => x_msg_data);
3866:
3867: WHEN OTHERS THEN

Line 3870: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3866:
3867: WHEN OTHERS THEN
3868: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_lines');
3869: -- store SQL error message on message stack for caller
3870: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3871: ,p_count => x_msg_count
3872: ,p_data => x_msg_data);
3873: -- notify caller of an UNEXPECTED error
3874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3884: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

3880: PROCEDURE validate_acct_lines(
3881:
3882: p_api_version IN NUMBER
3883:
3884: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3885:
3886: ,x_return_status OUT NOCOPY VARCHAR2
3887:
3888: ,x_msg_count OUT NOCOPY NUMBER

Line 3894: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3890: ,x_msg_data OUT NOCOPY VARCHAR2
3891:
3892: ,p_aelv_tbl IN aelv_tbl_type) IS
3893:
3894: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3895:
3896: l_api_name CONSTANT VARCHAR2(30) := 'validate_acct_lines';
3897:
3898: i NUMBER;

Line 3901: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3897:
3898: i NUMBER;
3899:
3900: l_aelv_tbl aelv_tbl_type := p_aelv_tbl;
3901: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3902:
3903:
3904: BEGIN
3905:

Line 3947: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

3943:
3944: ,p_aelv_rec => l_aelv_tbl(i)
3945:
3946: );
3947: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
3948: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
3949: l_overall_status := x_return_status;
3950: END IF;
3951: END IF;

Line 3948: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

3944: ,p_aelv_rec => l_aelv_tbl(i)
3945:
3946: );
3947: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
3948: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
3949: l_overall_status := x_return_status;
3950: END IF;
3951: END IF;
3952:

Line 3988: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3984: WHEN FND_API.G_EXC_ERROR THEN
3985: ROLLBACK TO validate_acct_lines;
3986: x_return_status := FND_API.G_RET_STS_ERROR;
3987:
3988: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3989: ,p_count => x_msg_count
3990: ,p_data => x_msg_data);
3991:
3992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3995: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3991:
3992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3993: ROLLBACK TO validate_acct_lines;
3994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3995: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3996: ,p_count => x_msg_count
3997: ,p_data => x_msg_data);
3998:
3999: WHEN OTHERS THEN

Line 4002: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

3998:
3999: WHEN OTHERS THEN
4000: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_lines');
4001: -- store SQL error message on message stack for caller
4002: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
4003: ,p_count => x_msg_count
4004: ,p_data => x_msg_data);
4005: -- notify caller of an UNEXPECTED error
4006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;