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 1147: Elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

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

Line 1202: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

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

Line 1203: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 1204: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

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

Line 1205: raise OKC_API.G_EXCEPTION_ERROR;

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

Line 1260: when OKC_API.G_EXCEPTION_ERROR then

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

Line 1269: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

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

Line 1445: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

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

Line 1446: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 1447: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

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

Line 1448: raise OKC_API.G_EXCEPTION_ERROR;

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

Line 1489: when OKC_API.G_EXCEPTION_ERROR then

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

Line 1498: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

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

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

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

Line 1688: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

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

Line 1689: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 1690: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

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

Line 1691: raise OKC_API.G_EXCEPTION_ERROR;

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

Line 1715: when OKC_API.G_EXCEPTION_ERROR then

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

Line 1724: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

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

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

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

Line 1809: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

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

Line 1810: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

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

Line 1850: when OKC_API.G_EXCEPTION_ERROR then

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

Line 1859: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

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

Line 1925: when OKC_API.G_EXCEPTION_ERROR then

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

Line 1934: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

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

Line 2003: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

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

Line 2004: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 2005: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

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

Line 2006: raise OKC_API.G_EXCEPTION_ERROR;

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

Line 2050: when OKC_API.G_EXCEPTION_ERROR then

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

Line 2059: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

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

Line 2127: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

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

Line 2128: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

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

Line 2186: when OKC_API.G_EXCEPTION_ERROR then

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

Line 2195: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

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

Line 2717: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

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

Line 2718: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

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

Line 4374: p_init_msg_list => OKC_API.G_FALSE,

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

Line 4398: p_init_msg_list => OKC_API.G_FALSE,

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

Line 4505: p_init_msg_list => OKC_API.G_FALSE,

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

Line 4549: p_init_msg_list => OKC_API.G_FALSE,

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

Line 4601: p_init_msg_list => OKC_API.G_FALSE,

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