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.OKE_CONTRACT_PUB dependencies on OKC_API

Line 114: Elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

110:
111: -- check if activity started successfully
112: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
113: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
114: Elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
115: raise OKE_API.G_EXCEPTION_ERROR;
116:
117: End If;
118:

Line 170: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

166: p_chrv_rec => l_chrv_rec,
167: x_chrv_rec => x_chrv_rec);
168:
169: -- check return status
170: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
171: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
172: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
173: raise OKC_API.G_EXCEPTION_ERROR;
174: End If;

Line 171: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

167: x_chrv_rec => x_chrv_rec);
168:
169: -- check return status
170: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
171: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
172: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
173: raise OKC_API.G_EXCEPTION_ERROR;
174: End If;
175:

Line 172: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

168:
169: -- check return status
170: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
171: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
172: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
173: raise OKC_API.G_EXCEPTION_ERROR;
174: End If;
175:
176:

Line 173: raise OKC_API.G_EXCEPTION_ERROR;

169: -- check return status
170: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
171: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
172: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
173: raise OKC_API.G_EXCEPTION_ERROR;
174: End If;
175:
176:
177: -- get id from OKC record

Line 223: when OKC_API.G_EXCEPTION_ERROR then

219: x_msg_count => x_msg_count,
220: x_msg_data => x_msg_data,
221: p_api_type => g_api_type);
222:
223: when OKC_API.G_EXCEPTION_ERROR then
224: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
225: p_api_name => l_api_name,
226: p_pkg_name => g_pkg_name,
227: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 232: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

228: x_msg_count => x_msg_count,
229: x_msg_data => x_msg_data,
230: p_api_type => g_api_type);
231:
232: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
233: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
234: p_api_name => l_api_name,
235: p_pkg_name => g_pkg_name,
236: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 284: Elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

280:
281: -- check if activity started successfully
282: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
283: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
284: Elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
285: raise OKE_API.G_EXCEPTION_ERROR;
286:
287: End If;
288:

Line 404: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

400: p_chrv_rec => p_chrv_rec,
401: x_chrv_rec => x_chrv_rec);
402:
403: -- check return status
404: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
405: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
406: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
407: raise OKC_API.G_EXCEPTION_ERROR;
408: End If;

Line 405: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

401: x_chrv_rec => x_chrv_rec);
402:
403: -- check return status
404: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
405: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
406: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
407: raise OKC_API.G_EXCEPTION_ERROR;
408: End If;
409:

Line 406: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

402:
403: -- check return status
404: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
405: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
406: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
407: raise OKC_API.G_EXCEPTION_ERROR;
408: End If;
409:
410: -- call complex api

Line 407: raise OKC_API.G_EXCEPTION_ERROR;

403: -- check return status
404: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
405: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
406: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
407: raise OKC_API.G_EXCEPTION_ERROR;
408: End If;
409:
410: -- call complex api
411:

Line 448: when OKC_API.G_EXCEPTION_ERROR then

444: x_msg_count => x_msg_count,
445: x_msg_data => x_msg_data,
446: p_api_type => g_api_type);
447:
448: when OKC_API.G_EXCEPTION_ERROR then
449: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
450: p_api_name => l_api_name,
451: p_pkg_name => g_pkg_name,
452: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 457: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

453: x_msg_count => x_msg_count,
454: x_msg_data => x_msg_data,
455: p_api_type => g_api_type);
456:
457: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
458: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
459: p_api_name => l_api_name,
460: p_pkg_name => g_pkg_name,
461: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 510: Elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

506:
507: -- check if activity started successfully
508: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
509: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
510: Elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
511: raise OKE_API.G_EXCEPTION_ERROR;
512:
513: End If;
514:

Line 646: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

642: x_msg_data => x_msg_data,
643: p_chrv_rec => l_chrv_rec);
644:
645: -- check return status
646: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
647: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
648: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
649: raise OKC_API.G_EXCEPTION_ERROR;
650: End If;

Line 647: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

643: p_chrv_rec => l_chrv_rec);
644:
645: -- check return status
646: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
647: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
648: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
649: raise OKC_API.G_EXCEPTION_ERROR;
650: End If;
651:

Line 648: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

644:
645: -- check return status
646: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
647: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
648: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
649: raise OKC_API.G_EXCEPTION_ERROR;
650: End If;
651:
652: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

Line 649: raise OKC_API.G_EXCEPTION_ERROR;

645: -- check return status
646: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
647: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
648: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
649: raise OKC_API.G_EXCEPTION_ERROR;
650: End If;
651:
652: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
653: x_msg_data => x_msg_data);

Line 673: when OKC_API.G_EXCEPTION_ERROR then

669: x_msg_count => x_msg_count,
670: x_msg_data => x_msg_data,
671: p_api_type => g_api_type);
672:
673: when OKC_API.G_EXCEPTION_ERROR then
674: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
675: p_api_name => l_api_name,
676: p_pkg_name => g_pkg_name,
677: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 682: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

678: x_msg_count => x_msg_count,
679: x_msg_data => x_msg_data,
680: p_api_type => g_api_type);
681:
682: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
683: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
684: p_api_name => l_api_name,
685: p_pkg_name => g_pkg_name,
686: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 731: Elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

727:
728: -- check if activity started successfully
729: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
730: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
731: Elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
732: raise OKE_API.G_EXCEPTION_ERROR;
733:
734: End If;
735:

Line 767: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

763: x_msg_data => x_msg_data,
764: p_chrv_rec => p_chrv_tbl(i));
765:
766: -- store the highest degree of error
767: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
768: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
769: l_overall_status := x_return_status;
770: End If;
771: End If;

Line 768: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

764: p_chrv_rec => p_chrv_tbl(i));
765:
766: -- store the highest degree of error
767: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
768: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
769: l_overall_status := x_return_status;
770: End If;
771: End If;
772:

Line 808: when OKC_API.G_EXCEPTION_ERROR then

804: x_msg_count => x_msg_count,
805: x_msg_data => x_msg_data,
806: p_api_type => g_api_type);
807:
808: when OKC_API.G_EXCEPTION_ERROR then
809: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
810: p_api_name => l_api_name,
811: p_pkg_name => g_pkg_name,
812: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 817: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

813: x_msg_count => x_msg_count,
814: x_msg_data => x_msg_data,
815: p_api_type => g_api_type);
816:
817: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
818: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
819: p_api_name => l_api_name,
820: p_pkg_name => g_pkg_name,
821: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 885: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

881: x_msg_data => x_msg_data,
882: p_chrv_rec => l_chrv_rec);
883:
884: -- check return status
885: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
886: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
887: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
888: raise OKC_API.G_EXCEPTION_ERROR;
889: End If;

Line 886: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

882: p_chrv_rec => l_chrv_rec);
883:
884: -- check return status
885: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
886: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
887: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
888: raise OKC_API.G_EXCEPTION_ERROR;
889: End If;
890:

Line 887: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

883:
884: -- check return status
885: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
886: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
887: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
888: raise OKC_API.G_EXCEPTION_ERROR;
889: End If;
890:
891: -- get id for OKE record

Line 888: raise OKC_API.G_EXCEPTION_ERROR;

884: -- check return status
885: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
886: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
887: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
888: raise OKC_API.G_EXCEPTION_ERROR;
889: End If;
890:
891: -- get id for OKE record
892:

Line 904: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

900: x_msg_count => x_msg_count,
901: x_msg_data => x_msg_data,
902: p_chr_rec => l_chr_rec);
903:
904: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
905: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
906: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
907: raise OKC_API.G_EXCEPTION_ERROR;
908: End If;

Line 905: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

901: x_msg_data => x_msg_data,
902: p_chr_rec => l_chr_rec);
903:
904: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
905: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
906: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
907: raise OKC_API.G_EXCEPTION_ERROR;
908: End If;
909:

Line 906: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

902: p_chr_rec => l_chr_rec);
903:
904: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
905: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
906: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
907: raise OKC_API.G_EXCEPTION_ERROR;
908: End If;
909:
910: -- end activity

Line 907: raise OKC_API.G_EXCEPTION_ERROR;

903:
904: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
905: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
906: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
907: raise OKC_API.G_EXCEPTION_ERROR;
908: End If;
909:
910: -- end activity
911: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

Line 932: when OKC_API.G_EXCEPTION_ERROR then

928: x_msg_count => x_msg_count,
929: x_msg_data => x_msg_data,
930: p_api_type => g_api_type);
931:
932: when OKC_API.G_EXCEPTION_ERROR then
933: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
934: p_api_name => l_api_name,
935: p_pkg_name => g_pkg_name,
936: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 941: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

937: x_msg_count => x_msg_count,
938: x_msg_data => x_msg_data,
939: p_api_type => g_api_type);
940:
941: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
942: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
943: p_api_name => l_api_name,
944: p_pkg_name => g_pkg_name,
945: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 1009: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

1005: x_msg_data => x_msg_data,
1006: p_chrv_rec => p_chrv_tbl(i));
1007:
1008: -- store the highest degree of error
1009: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
1010: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
1011: l_overall_status := x_return_status;
1012: End If;
1013: End If;

Line 1010: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

1006: p_chrv_rec => p_chrv_tbl(i));
1007:
1008: -- store the highest degree of error
1009: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
1010: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
1011: l_overall_status := x_return_status;
1012: End If;
1013: End If;
1014:

Line 1068: when OKC_API.G_EXCEPTION_ERROR then

1064: x_msg_count => x_msg_count,
1065: x_msg_data => x_msg_data,
1066: p_api_type => g_api_type);
1067:
1068: when OKC_API.G_EXCEPTION_ERROR then
1069: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1070: p_api_name => l_api_name,
1071: p_pkg_name => g_pkg_name,
1072: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 1077: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

1073: x_msg_count => x_msg_count,
1074: x_msg_data => x_msg_data,
1075: p_api_type => g_api_type);
1076:
1077: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1078: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1079: p_api_name => l_api_name,
1080: p_pkg_name => g_pkg_name,
1081: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 1148: Elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

1144:
1145: -- check if activity started successfully
1146: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1147: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1148: Elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1149: raise OKE_API.G_EXCEPTION_ERROR;
1150:
1151: End If;
1152:

Line 1203: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

1199: End If;
1200:
1201:
1202: -- check return status
1203: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
1204: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1205: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1206: raise OKC_API.G_EXCEPTION_ERROR;
1207: End If;

Line 1204: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1200:
1201:
1202: -- check return status
1203: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
1204: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1205: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1206: raise OKC_API.G_EXCEPTION_ERROR;
1207: End If;
1208:

Line 1205: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

1201:
1202: -- check return status
1203: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
1204: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1205: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1206: raise OKC_API.G_EXCEPTION_ERROR;
1207: End If;
1208:
1209: -- get id from OKC record

Line 1206: raise OKC_API.G_EXCEPTION_ERROR;

1202: -- check return status
1203: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
1204: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1205: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1206: raise OKC_API.G_EXCEPTION_ERROR;
1207: End If;
1208:
1209: -- get id from OKC record
1210:

Line 1261: when OKC_API.G_EXCEPTION_ERROR then

1257: x_msg_count => x_msg_count,
1258: x_msg_data => x_msg_data,
1259: p_api_type => g_api_type);
1260:
1261: when OKC_API.G_EXCEPTION_ERROR then
1262: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1263: p_api_name => l_api_name,
1264: p_pkg_name => g_pkg_name,
1265: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 1270: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

1266: x_msg_count => x_msg_count,
1267: x_msg_data => x_msg_data,
1268: p_api_type => g_api_type);
1269:
1270: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1271: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1272: p_api_name => l_api_name,
1273: p_pkg_name => g_pkg_name,
1274: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 1446: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

1442: p_clev_rec => p_clev_rec,
1443: x_clev_rec => x_clev_rec);
1444:
1445: -- check return status
1446: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
1447: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1448: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1449: raise OKC_API.G_EXCEPTION_ERROR;
1450: End If;

Line 1447: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1443: x_clev_rec => x_clev_rec);
1444:
1445: -- check return status
1446: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
1447: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1448: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1449: raise OKC_API.G_EXCEPTION_ERROR;
1450: End If;
1451:

Line 1448: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

1444:
1445: -- check return status
1446: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
1447: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1448: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1449: raise OKC_API.G_EXCEPTION_ERROR;
1450: End If;
1451:
1452: -- call complex api

Line 1449: raise OKC_API.G_EXCEPTION_ERROR;

1445: -- check return status
1446: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
1447: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1448: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1449: raise OKC_API.G_EXCEPTION_ERROR;
1450: End If;
1451:
1452: -- call complex api
1453:

Line 1490: when OKC_API.G_EXCEPTION_ERROR then

1486: x_msg_count => x_msg_count,
1487: x_msg_data => x_msg_data,
1488: p_api_type => g_api_type);
1489:
1490: when OKC_API.G_EXCEPTION_ERROR then
1491: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1492: p_api_name => l_api_name,
1493: p_pkg_name => g_pkg_name,
1494: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 1499: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

1495: x_msg_count => x_msg_count,
1496: x_msg_data => x_msg_data,
1497: p_api_type => g_api_type);
1498:
1499: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1500: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1501: p_api_name => l_api_name,
1502: p_pkg_name => g_pkg_name,
1503: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 1552: Elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

1548:
1549: -- check if activity started successfully
1550: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1551: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1552: Elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1553: raise OKE_API.G_EXCEPTION_ERROR;
1554:
1555: End If;
1556:

Line 1689: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

1685: x_msg_data => x_msg_data,
1686: p_clev_rec => l_clev_rec);
1687:
1688: -- check return status
1689: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
1690: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1691: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1692: raise OKC_API.G_EXCEPTION_ERROR;
1693: End If;

Line 1690: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1686: p_clev_rec => l_clev_rec);
1687:
1688: -- check return status
1689: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
1690: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1691: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1692: raise OKC_API.G_EXCEPTION_ERROR;
1693: End If;
1694:

Line 1691: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

1687:
1688: -- check return status
1689: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
1690: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1691: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1692: raise OKC_API.G_EXCEPTION_ERROR;
1693: End If;
1694:
1695: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

Line 1692: raise OKC_API.G_EXCEPTION_ERROR;

1688: -- check return status
1689: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
1690: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1691: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1692: raise OKC_API.G_EXCEPTION_ERROR;
1693: End If;
1694:
1695: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1696: x_msg_data => x_msg_data);

Line 1716: when OKC_API.G_EXCEPTION_ERROR then

1712: x_msg_count => x_msg_count,
1713: x_msg_data => x_msg_data,
1714: p_api_type => g_api_type);
1715:
1716: when OKC_API.G_EXCEPTION_ERROR then
1717: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1718: p_api_name => l_api_name,
1719: p_pkg_name => g_pkg_name,
1720: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 1725: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

1721: x_msg_count => x_msg_count,
1722: x_msg_data => x_msg_data,
1723: p_api_type => g_api_type);
1724:
1725: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1726: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1727: p_api_name => l_api_name,
1728: p_pkg_name => g_pkg_name,
1729: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 1774: Elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

1770:
1771: -- check if activity started successfully
1772: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1773: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1774: Elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1775: raise OKE_API.G_EXCEPTION_ERROR;
1776:
1777: End If;
1778:

Line 1810: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

1806: x_msg_data => x_msg_data,
1807: p_clev_rec => p_clev_tbl(i));
1808:
1809: -- store the highest degree of error
1810: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
1811: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
1812: l_overall_status := x_return_status;
1813: End If;
1814: End If;

Line 1811: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

1807: p_clev_rec => p_clev_tbl(i));
1808:
1809: -- store the highest degree of error
1810: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
1811: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
1812: l_overall_status := x_return_status;
1813: End If;
1814: End If;
1815:

Line 1851: when OKC_API.G_EXCEPTION_ERROR then

1847: x_msg_count => x_msg_count,
1848: x_msg_data => x_msg_data,
1849: p_api_type => g_api_type);
1850:
1851: when OKC_API.G_EXCEPTION_ERROR then
1852: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1853: p_api_name => l_api_name,
1854: p_pkg_name => g_pkg_name,
1855: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 1860: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

1856: x_msg_count => x_msg_count,
1857: x_msg_data => x_msg_data,
1858: p_api_type => g_api_type);
1859:
1860: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1861: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1862: p_api_name => l_api_name,
1863: p_pkg_name => g_pkg_name,
1864: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 1926: when OKC_API.G_EXCEPTION_ERROR then

1922: x_msg_count => x_msg_count,
1923: x_msg_data => x_msg_data,
1924: p_api_type => g_api_type);
1925:
1926: when OKC_API.G_EXCEPTION_ERROR then
1927: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1928: p_api_name => l_api_name,
1929: p_pkg_name => g_pkg_name,
1930: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 1935: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

1931: x_msg_count => x_msg_count,
1932: x_msg_data => x_msg_data,
1933: p_api_type => g_api_type);
1934:
1935: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1936: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1937: p_api_name => l_api_name,
1938: p_pkg_name => g_pkg_name,
1939: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 2004: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

2000: x_msg_data => x_msg_data,
2001: p_clev_rec => l_clev_rec);
2002:
2003: -- check return status
2004: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
2005: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2006: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
2007: raise OKC_API.G_EXCEPTION_ERROR;
2008: End If;

Line 2005: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2001: p_clev_rec => l_clev_rec);
2002:
2003: -- check return status
2004: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
2005: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2006: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
2007: raise OKC_API.G_EXCEPTION_ERROR;
2008: End If;
2009:

Line 2006: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

2002:
2003: -- check return status
2004: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
2005: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2006: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
2007: raise OKC_API.G_EXCEPTION_ERROR;
2008: End If;
2009:
2010: -- get id for OKE record

Line 2007: raise OKC_API.G_EXCEPTION_ERROR;

2003: -- check return status
2004: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
2005: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2006: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
2007: raise OKC_API.G_EXCEPTION_ERROR;
2008: End If;
2009:
2010: -- get id for OKE record
2011:

Line 2051: when OKC_API.G_EXCEPTION_ERROR then

2047: x_msg_count => x_msg_count,
2048: x_msg_data => x_msg_data,
2049: p_api_type => g_api_type);
2050:
2051: when OKC_API.G_EXCEPTION_ERROR then
2052: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
2053: p_api_name => l_api_name,
2054: p_pkg_name => g_pkg_name,
2055: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 2060: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

2056: x_msg_count => x_msg_count,
2057: x_msg_data => x_msg_data,
2058: p_api_type => g_api_type);
2059:
2060: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
2061: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
2062: p_api_name => l_api_name,
2063: p_pkg_name => g_pkg_name,
2064: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 2128: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

2124: x_msg_data => x_msg_data,
2125: p_clev_rec => p_clev_tbl(i));
2126:
2127: -- store the highest degree of error
2128: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
2129: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
2130: l_overall_status := x_return_status;
2131: End If;
2132: End If;

Line 2129: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

2125: p_clev_rec => p_clev_tbl(i));
2126:
2127: -- store the highest degree of error
2128: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
2129: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
2130: l_overall_status := x_return_status;
2131: End If;
2132: End If;
2133:

Line 2187: when OKC_API.G_EXCEPTION_ERROR then

2183: x_msg_count => x_msg_count,
2184: x_msg_data => x_msg_data,
2185: p_api_type => g_api_type);
2186:
2187: when OKC_API.G_EXCEPTION_ERROR then
2188: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
2189: p_api_name => l_api_name,
2190: p_pkg_name => g_pkg_name,
2191: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 2196: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

2192: x_msg_count => x_msg_count,
2193: x_msg_data => x_msg_data,
2194: p_api_type => g_api_type);
2195:
2196: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
2197: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
2198: p_api_name => l_api_name,
2199: p_pkg_name => g_pkg_name,
2200: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 2719: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

2715: x_msg_data => x_msg_data,
2716: p_del_rec => p_del_tbl(i));
2717:
2718: -- store the highest degree of error
2719: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
2720: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
2721: l_overall_status := x_return_status;
2722: End If;
2723: End If;

Line 2720: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

2716: p_del_rec => p_del_tbl(i));
2717:
2718: -- store the highest degree of error
2719: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
2720: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
2721: l_overall_status := x_return_status;
2722: End If;
2723: End If;
2724:

Line 4376: p_init_msg_list => OKC_API.G_FALSE,

4372: end loop;
4373:
4374: OKC_CONTRACT_PARTY_PUB.delete_contact(
4375: p_api_version => l_api_version,
4376: p_init_msg_list => OKC_API.G_FALSE,
4377: x_return_status => l_status,
4378: x_msg_count => x_msg_count,
4379: x_msg_data => x_msg_data,
4380: p_ctcv_tbl => l_contact_tbl);

Line 4400: p_init_msg_list => OKC_API.G_FALSE,

4396: end loop;
4397:
4398: OKC_CONTRACT_PARTY_PUB.delete_k_party_role(
4399: p_api_version => l_api_version,
4400: p_init_msg_list => OKC_API.G_FALSE,
4401: x_return_status => l_status,
4402: x_msg_count => x_msg_count,
4403: x_msg_data => x_msg_data,
4404: p_cplv_tbl => l_party_tbl);

Line 4507: p_init_msg_list => OKC_API.G_FALSE,

4503: end loop;
4504:
4505: OKC_CONTRACT_ITEM_PUB.delete_contract_item(
4506: p_api_version => l_api_version,
4507: p_init_msg_list => OKC_API.G_FALSE,
4508: x_return_status => l_status,
4509: x_msg_count => x_msg_count,
4510: x_msg_data => x_msg_data,
4511: p_cimv_tbl => l_item_tbl);

Line 4551: p_init_msg_list => OKC_API.G_FALSE,

4547:
4548:
4549: OKC_CONTRACT_PVT.delete_contract_line(
4550: p_api_version => l_api_version,
4551: p_init_msg_list => OKC_API.G_FALSE,
4552: x_return_status => l_status,
4553: x_msg_count => x_msg_count,
4554: x_msg_data => x_msg_data,
4555: p_clev_tbl => l_clev_tbl);

Line 4603: p_init_msg_list => OKC_API.G_FALSE,

4599:
4600:
4601: OKC_CONTRACT_PVT.delete_contract_header(
4602: p_api_version => l_api_version,
4603: p_init_msg_list => OKC_API.G_FALSE,
4604: x_return_status => l_status,
4605: x_msg_count => x_msg_count,
4606: x_msg_data => x_msg_data,
4607: p_chrv_rec => l_chrv_rec);