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

Line 5: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

1: package body OKC_CONTRACT_PARTY_PUB as
2: /* $Header: OKCPCPLB.pls 120.0 2005/05/26 09:35:19 appldev noship $ */
3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
4:
5: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_PARTY_PUB';
7:
8: procedure reset(p_ctcv_rec IN ctcv_rec_type) is
9: begin

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

43: p_ctcv_rec IN ctcv_rec_type,
44: x_ctcv_rec OUT NOCOPY ctcv_rec_type) is
45: l_api_name CONSTANT VARCHAR2(30) := 'create_contact';
46: l_api_version CONSTANT NUMBER := 1;
47: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
48: begin
49: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
50: G_PKG_NAME,
51: p_init_msg_list,

Line 49: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

45: l_api_name CONSTANT VARCHAR2(30) := 'create_contact';
46: l_api_version CONSTANT NUMBER := 1;
47: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
48: begin
49: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
50: G_PKG_NAME,
51: p_init_msg_list,
52: l_api_version,
53: p_api_version,

Line 56: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

52: l_api_version,
53: p_api_version,
54: '_PUB',
55: x_return_status);
56: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
57: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
58: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
59: RAISE OKC_API.G_EXCEPTION_ERROR;
60: END IF;

Line 57: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

53: p_api_version,
54: '_PUB',
55: x_return_status);
56: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
57: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
58: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
59: RAISE OKC_API.G_EXCEPTION_ERROR;
60: END IF;
61: --

Line 58: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

54: '_PUB',
55: x_return_status);
56: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
57: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
58: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
59: RAISE OKC_API.G_EXCEPTION_ERROR;
60: END IF;
61: --
62: -- Call Before Logic Hook

Line 59: RAISE OKC_API.G_EXCEPTION_ERROR;

55: x_return_status);
56: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
57: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
58: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
59: RAISE OKC_API.G_EXCEPTION_ERROR;
60: END IF;
61: --
62: -- Call Before Logic Hook
63: --

Line 66: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

62: -- Call Before Logic Hook
63: --
64: g_ctcv_rec := p_ctcv_rec;
65: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
66: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
67: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
68: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
69: raise OKC_API.G_EXCEPTION_ERROR;
70: END IF;

Line 67: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

63: --
64: g_ctcv_rec := p_ctcv_rec;
65: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
66: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
67: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
68: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
69: raise OKC_API.G_EXCEPTION_ERROR;
70: END IF;
71: reset(p_ctcv_rec);

Line 68: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

64: g_ctcv_rec := p_ctcv_rec;
65: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
66: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
67: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
68: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
69: raise OKC_API.G_EXCEPTION_ERROR;
70: END IF;
71: reset(p_ctcv_rec);
72: OKC_CONTRACT_PARTY_PVT.create_contact(p_api_version,

Line 69: raise OKC_API.G_EXCEPTION_ERROR;

65: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
66: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
67: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
68: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
69: raise OKC_API.G_EXCEPTION_ERROR;
70: END IF;
71: reset(p_ctcv_rec);
72: OKC_CONTRACT_PARTY_PVT.create_contact(p_api_version,
73: p_init_msg_list,

Line 79: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

75: x_msg_count,
76: x_msg_data,
77: g_ctcv_rec,
78: x_ctcv_rec);
79: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
80: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
81: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
82: RAISE OKC_API.G_EXCEPTION_ERROR;
83: END IF;

Line 80: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

76: x_msg_data,
77: g_ctcv_rec,
78: x_ctcv_rec);
79: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
80: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
81: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
82: RAISE OKC_API.G_EXCEPTION_ERROR;
83: END IF;
84: --

Line 81: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

77: g_ctcv_rec,
78: x_ctcv_rec);
79: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
80: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
81: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
82: RAISE OKC_API.G_EXCEPTION_ERROR;
83: END IF;
84: --
85: -- Call After Logic Hook

Line 82: RAISE OKC_API.G_EXCEPTION_ERROR;

78: x_ctcv_rec);
79: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
80: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
81: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
82: RAISE OKC_API.G_EXCEPTION_ERROR;
83: END IF;
84: --
85: -- Call After Logic Hook
86: --

Line 89: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

85: -- Call After Logic Hook
86: --
87: g_ctcv_rec := x_ctcv_rec;
88: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
89: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
90: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
91: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
92: raise OKC_API.G_EXCEPTION_ERROR;
93: END IF;

Line 90: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

86: --
87: g_ctcv_rec := x_ctcv_rec;
88: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
89: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
90: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
91: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
92: raise OKC_API.G_EXCEPTION_ERROR;
93: END IF;
94: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 91: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

87: g_ctcv_rec := x_ctcv_rec;
88: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
89: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
90: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
91: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
92: raise OKC_API.G_EXCEPTION_ERROR;
93: END IF;
94: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
95: EXCEPTION

Line 92: raise OKC_API.G_EXCEPTION_ERROR;

88: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
89: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
90: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
91: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
92: raise OKC_API.G_EXCEPTION_ERROR;
93: END IF;
94: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
95: EXCEPTION
96: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 94: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

90: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
91: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
92: raise OKC_API.G_EXCEPTION_ERROR;
93: END IF;
94: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
95: EXCEPTION
96: WHEN OKC_API.G_EXCEPTION_ERROR THEN
97: x_return_status := OKC_API.HANDLE_EXCEPTIONS
98: (substr(l_api_name,1,26),

Line 96: WHEN OKC_API.G_EXCEPTION_ERROR THEN

92: raise OKC_API.G_EXCEPTION_ERROR;
93: END IF;
94: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
95: EXCEPTION
96: WHEN OKC_API.G_EXCEPTION_ERROR THEN
97: x_return_status := OKC_API.HANDLE_EXCEPTIONS
98: (substr(l_api_name,1,26),
99: G_PKG_NAME,
100: 'OKC_API.G_RET_STS_ERROR',

Line 97: x_return_status := OKC_API.HANDLE_EXCEPTIONS

93: END IF;
94: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
95: EXCEPTION
96: WHEN OKC_API.G_EXCEPTION_ERROR THEN
97: x_return_status := OKC_API.HANDLE_EXCEPTIONS
98: (substr(l_api_name,1,26),
99: G_PKG_NAME,
100: 'OKC_API.G_RET_STS_ERROR',
101: x_msg_count,

Line 100: 'OKC_API.G_RET_STS_ERROR',

96: WHEN OKC_API.G_EXCEPTION_ERROR THEN
97: x_return_status := OKC_API.HANDLE_EXCEPTIONS
98: (substr(l_api_name,1,26),
99: G_PKG_NAME,
100: 'OKC_API.G_RET_STS_ERROR',
101: x_msg_count,
102: x_msg_data,
103: '_PUB');
104: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 104: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

100: 'OKC_API.G_RET_STS_ERROR',
101: x_msg_count,
102: x_msg_data,
103: '_PUB');
104: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
105: x_return_status := OKC_API.HANDLE_EXCEPTIONS
106: (substr(l_api_name,1,26),
107: G_PKG_NAME,
108: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 105: x_return_status := OKC_API.HANDLE_EXCEPTIONS

101: x_msg_count,
102: x_msg_data,
103: '_PUB');
104: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
105: x_return_status := OKC_API.HANDLE_EXCEPTIONS
106: (substr(l_api_name,1,26),
107: G_PKG_NAME,
108: 'OKC_API.G_RET_STS_UNEXP_ERROR',
109: x_msg_count,

Line 108: 'OKC_API.G_RET_STS_UNEXP_ERROR',

104: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
105: x_return_status := OKC_API.HANDLE_EXCEPTIONS
106: (substr(l_api_name,1,26),
107: G_PKG_NAME,
108: 'OKC_API.G_RET_STS_UNEXP_ERROR',
109: x_msg_count,
110: x_msg_data,
111: '_PUB');
112: WHEN OTHERS THEN

Line 113: x_return_status := OKC_API.HANDLE_EXCEPTIONS

109: x_msg_count,
110: x_msg_data,
111: '_PUB');
112: WHEN OTHERS THEN
113: x_return_status := OKC_API.HANDLE_EXCEPTIONS
114: (substr(l_api_name,1,26),
115: G_PKG_NAME,
116: 'OTHERS',
117: x_msg_count,

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

134: x_msg_data OUT NOCOPY VARCHAR2,
135: p_ctcv_tbl IN ctcv_tbl_type,
136: x_ctcv_tbl OUT NOCOPY ctcv_tbl_type) is
137: i NUMBER;
138: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
139: begin
140: OKC_API.init_msg_list(p_init_msg_list);
141: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
142: if (p_ctcv_tbl.COUNT>0) then

Line 140: OKC_API.init_msg_list(p_init_msg_list);

136: x_ctcv_tbl OUT NOCOPY ctcv_tbl_type) is
137: i NUMBER;
138: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
139: begin
140: OKC_API.init_msg_list(p_init_msg_list);
141: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
142: if (p_ctcv_tbl.COUNT>0) then
143: i := p_ctcv_tbl.FIRST;
144: LOOP

Line 141: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

137: i NUMBER;
138: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
139: begin
140: OKC_API.init_msg_list(p_init_msg_list);
141: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
142: if (p_ctcv_tbl.COUNT>0) then
143: i := p_ctcv_tbl.FIRST;
144: LOOP
145: create_contact(p_api_version=>p_api_version,

Line 146: p_init_msg_list=>OKC_API.G_FALSE,

142: if (p_ctcv_tbl.COUNT>0) then
143: i := p_ctcv_tbl.FIRST;
144: LOOP
145: create_contact(p_api_version=>p_api_version,
146: p_init_msg_list=>OKC_API.G_FALSE,
147: x_return_status=>l_return_status,
148: x_msg_count=>x_msg_count,
149: x_msg_data=>x_msg_data,
150: p_ctcv_rec=>p_ctcv_tbl(i),

Line 152: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

148: x_msg_count=>x_msg_count,
149: x_msg_data=>x_msg_data,
150: p_ctcv_rec=>p_ctcv_tbl(i),
151: x_ctcv_rec=>x_ctcv_tbl(i));
152: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
153: x_return_status := l_return_status;
154: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
155: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
156: x_return_status := l_return_status;

Line 154: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

150: p_ctcv_rec=>p_ctcv_tbl(i),
151: x_ctcv_rec=>x_ctcv_tbl(i));
152: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
153: x_return_status := l_return_status;
154: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
155: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
156: x_return_status := l_return_status;
157: end if;
158: EXIT WHEN (i=p_ctcv_tbl.LAST);

Line 155: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

151: x_ctcv_rec=>x_ctcv_tbl(i));
152: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
153: x_return_status := l_return_status;
154: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
155: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
156: x_return_status := l_return_status;
157: end if;
158: EXIT WHEN (i=p_ctcv_tbl.LAST);
159: i := p_ctcv_tbl.NEXT(i);

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

179: p_ctcv_rec IN ctcv_rec_type,
180: x_ctcv_rec OUT NOCOPY ctcv_rec_type) is
181: l_api_name CONSTANT VARCHAR2(30) := 'update_contact';
182: l_api_version CONSTANT NUMBER := 1;
183: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
184: begin
185: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
186: G_PKG_NAME,
187: p_init_msg_list,

Line 185: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

181: l_api_name CONSTANT VARCHAR2(30) := 'update_contact';
182: l_api_version CONSTANT NUMBER := 1;
183: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
184: begin
185: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
186: G_PKG_NAME,
187: p_init_msg_list,
188: l_api_version,
189: p_api_version,

Line 192: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

188: l_api_version,
189: p_api_version,
190: '_PUB',
191: x_return_status);
192: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
193: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
194: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
195: RAISE OKC_API.G_EXCEPTION_ERROR;
196: END IF;

Line 193: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

189: p_api_version,
190: '_PUB',
191: x_return_status);
192: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
193: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
194: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
195: RAISE OKC_API.G_EXCEPTION_ERROR;
196: END IF;
197: --

Line 194: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

190: '_PUB',
191: x_return_status);
192: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
193: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
194: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
195: RAISE OKC_API.G_EXCEPTION_ERROR;
196: END IF;
197: --
198: -- Call Before Logic Hook

Line 195: RAISE OKC_API.G_EXCEPTION_ERROR;

191: x_return_status);
192: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
193: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
194: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
195: RAISE OKC_API.G_EXCEPTION_ERROR;
196: END IF;
197: --
198: -- Call Before Logic Hook
199: --

Line 202: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

198: -- Call Before Logic Hook
199: --
200: g_ctcv_rec := p_ctcv_rec;
201: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
202: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
203: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
204: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
205: raise OKC_API.G_EXCEPTION_ERROR;
206: END IF;

Line 203: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

199: --
200: g_ctcv_rec := p_ctcv_rec;
201: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
202: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
203: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
204: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
205: raise OKC_API.G_EXCEPTION_ERROR;
206: END IF;
207: reset(p_ctcv_rec);

Line 204: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

200: g_ctcv_rec := p_ctcv_rec;
201: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
202: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
203: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
204: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
205: raise OKC_API.G_EXCEPTION_ERROR;
206: END IF;
207: reset(p_ctcv_rec);
208: OKC_CONTRACT_PARTY_PVT.update_contact(p_api_version,

Line 205: raise OKC_API.G_EXCEPTION_ERROR;

201: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
202: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
203: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
204: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
205: raise OKC_API.G_EXCEPTION_ERROR;
206: END IF;
207: reset(p_ctcv_rec);
208: OKC_CONTRACT_PARTY_PVT.update_contact(p_api_version,
209: p_init_msg_list,

Line 215: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

211: x_msg_count,
212: x_msg_data,
213: g_ctcv_rec,
214: x_ctcv_rec);
215: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
216: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
217: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
218: RAISE OKC_API.G_EXCEPTION_ERROR;
219: END IF;

Line 216: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

212: x_msg_data,
213: g_ctcv_rec,
214: x_ctcv_rec);
215: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
216: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
217: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
218: RAISE OKC_API.G_EXCEPTION_ERROR;
219: END IF;
220: --

Line 217: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

213: g_ctcv_rec,
214: x_ctcv_rec);
215: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
216: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
217: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
218: RAISE OKC_API.G_EXCEPTION_ERROR;
219: END IF;
220: --
221: -- Call After Logic Hook

Line 218: RAISE OKC_API.G_EXCEPTION_ERROR;

214: x_ctcv_rec);
215: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
216: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
217: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
218: RAISE OKC_API.G_EXCEPTION_ERROR;
219: END IF;
220: --
221: -- Call After Logic Hook
222: --

Line 225: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

221: -- Call After Logic Hook
222: --
223: g_ctcv_rec := x_ctcv_rec;
224: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
225: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
226: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
227: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
228: raise OKC_API.G_EXCEPTION_ERROR;
229: END IF;

Line 226: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

222: --
223: g_ctcv_rec := x_ctcv_rec;
224: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
225: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
226: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
227: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
228: raise OKC_API.G_EXCEPTION_ERROR;
229: END IF;
230: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 227: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

223: g_ctcv_rec := x_ctcv_rec;
224: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
225: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
226: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
227: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
228: raise OKC_API.G_EXCEPTION_ERROR;
229: END IF;
230: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
231: EXCEPTION

Line 228: raise OKC_API.G_EXCEPTION_ERROR;

224: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
225: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
226: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
227: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
228: raise OKC_API.G_EXCEPTION_ERROR;
229: END IF;
230: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
231: EXCEPTION
232: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 230: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

226: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
227: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
228: raise OKC_API.G_EXCEPTION_ERROR;
229: END IF;
230: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
231: EXCEPTION
232: WHEN OKC_API.G_EXCEPTION_ERROR THEN
233: x_return_status := OKC_API.HANDLE_EXCEPTIONS
234: (substr(l_api_name,1,26),

Line 232: WHEN OKC_API.G_EXCEPTION_ERROR THEN

228: raise OKC_API.G_EXCEPTION_ERROR;
229: END IF;
230: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
231: EXCEPTION
232: WHEN OKC_API.G_EXCEPTION_ERROR THEN
233: x_return_status := OKC_API.HANDLE_EXCEPTIONS
234: (substr(l_api_name,1,26),
235: G_PKG_NAME,
236: 'OKC_API.G_RET_STS_ERROR',

Line 233: x_return_status := OKC_API.HANDLE_EXCEPTIONS

229: END IF;
230: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
231: EXCEPTION
232: WHEN OKC_API.G_EXCEPTION_ERROR THEN
233: x_return_status := OKC_API.HANDLE_EXCEPTIONS
234: (substr(l_api_name,1,26),
235: G_PKG_NAME,
236: 'OKC_API.G_RET_STS_ERROR',
237: x_msg_count,

Line 236: 'OKC_API.G_RET_STS_ERROR',

232: WHEN OKC_API.G_EXCEPTION_ERROR THEN
233: x_return_status := OKC_API.HANDLE_EXCEPTIONS
234: (substr(l_api_name,1,26),
235: G_PKG_NAME,
236: 'OKC_API.G_RET_STS_ERROR',
237: x_msg_count,
238: x_msg_data,
239: '_PUB');
240: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 240: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

236: 'OKC_API.G_RET_STS_ERROR',
237: x_msg_count,
238: x_msg_data,
239: '_PUB');
240: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
241: x_return_status := OKC_API.HANDLE_EXCEPTIONS
242: (substr(l_api_name,1,26),
243: G_PKG_NAME,
244: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 241: x_return_status := OKC_API.HANDLE_EXCEPTIONS

237: x_msg_count,
238: x_msg_data,
239: '_PUB');
240: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
241: x_return_status := OKC_API.HANDLE_EXCEPTIONS
242: (substr(l_api_name,1,26),
243: G_PKG_NAME,
244: 'OKC_API.G_RET_STS_UNEXP_ERROR',
245: x_msg_count,

Line 244: 'OKC_API.G_RET_STS_UNEXP_ERROR',

240: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
241: x_return_status := OKC_API.HANDLE_EXCEPTIONS
242: (substr(l_api_name,1,26),
243: G_PKG_NAME,
244: 'OKC_API.G_RET_STS_UNEXP_ERROR',
245: x_msg_count,
246: x_msg_data,
247: '_PUB');
248: WHEN OTHERS THEN

Line 249: x_return_status := OKC_API.HANDLE_EXCEPTIONS

245: x_msg_count,
246: x_msg_data,
247: '_PUB');
248: WHEN OTHERS THEN
249: x_return_status := OKC_API.HANDLE_EXCEPTIONS
250: (substr(l_api_name,1,26),
251: G_PKG_NAME,
252: 'OTHERS',
253: x_msg_count,

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

270: x_msg_data OUT NOCOPY VARCHAR2,
271: p_ctcv_tbl IN ctcv_tbl_type,
272: x_ctcv_tbl OUT NOCOPY ctcv_tbl_type) is
273: i NUMBER;
274: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
275: begin
276: OKC_API.init_msg_list(p_init_msg_list);
277: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
278: if (p_ctcv_tbl.COUNT>0) then

Line 276: OKC_API.init_msg_list(p_init_msg_list);

272: x_ctcv_tbl OUT NOCOPY ctcv_tbl_type) is
273: i NUMBER;
274: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
275: begin
276: OKC_API.init_msg_list(p_init_msg_list);
277: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
278: if (p_ctcv_tbl.COUNT>0) then
279: i := p_ctcv_tbl.FIRST;
280: LOOP

Line 277: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

273: i NUMBER;
274: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
275: begin
276: OKC_API.init_msg_list(p_init_msg_list);
277: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
278: if (p_ctcv_tbl.COUNT>0) then
279: i := p_ctcv_tbl.FIRST;
280: LOOP
281: update_contact(p_api_version=>p_api_version,

Line 282: p_init_msg_list=>OKC_API.G_FALSE,

278: if (p_ctcv_tbl.COUNT>0) then
279: i := p_ctcv_tbl.FIRST;
280: LOOP
281: update_contact(p_api_version=>p_api_version,
282: p_init_msg_list=>OKC_API.G_FALSE,
283: x_return_status=>l_return_status,
284: x_msg_count=>x_msg_count,
285: x_msg_data=>x_msg_data,
286: p_ctcv_rec=>p_ctcv_tbl(i),

Line 288: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

284: x_msg_count=>x_msg_count,
285: x_msg_data=>x_msg_data,
286: p_ctcv_rec=>p_ctcv_tbl(i),
287: x_ctcv_rec=>x_ctcv_tbl(i));
288: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
289: x_return_status := l_return_status;
290: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
291: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
292: x_return_status := l_return_status;

Line 290: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

286: p_ctcv_rec=>p_ctcv_tbl(i),
287: x_ctcv_rec=>x_ctcv_tbl(i));
288: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
289: x_return_status := l_return_status;
290: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
291: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
292: x_return_status := l_return_status;
293: end if;
294: EXIT WHEN (i=p_ctcv_tbl.LAST);

Line 291: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

287: x_ctcv_rec=>x_ctcv_tbl(i));
288: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
289: x_return_status := l_return_status;
290: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
291: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
292: x_return_status := l_return_status;
293: end if;
294: EXIT WHEN (i=p_ctcv_tbl.LAST);
295: i := p_ctcv_tbl.NEXT(i);

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

314: x_msg_data OUT NOCOPY VARCHAR2,
315: p_ctcv_rec IN ctcv_rec_type) is
316: l_api_name CONSTANT VARCHAR2(30) := 'delete_contact';
317: l_api_version CONSTANT NUMBER := 1;
318: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
319: begin
320: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
321: G_PKG_NAME,
322: p_init_msg_list,

Line 320: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

316: l_api_name CONSTANT VARCHAR2(30) := 'delete_contact';
317: l_api_version CONSTANT NUMBER := 1;
318: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
319: begin
320: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
321: G_PKG_NAME,
322: p_init_msg_list,
323: l_api_version,
324: p_api_version,

Line 327: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

323: l_api_version,
324: p_api_version,
325: '_PUB',
326: x_return_status);
327: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
328: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
329: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
330: RAISE OKC_API.G_EXCEPTION_ERROR;
331: END IF;

Line 328: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

324: p_api_version,
325: '_PUB',
326: x_return_status);
327: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
328: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
329: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
330: RAISE OKC_API.G_EXCEPTION_ERROR;
331: END IF;
332: --

Line 329: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

325: '_PUB',
326: x_return_status);
327: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
328: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
329: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
330: RAISE OKC_API.G_EXCEPTION_ERROR;
331: END IF;
332: --
333: -- Call Before Logic Hook

Line 330: RAISE OKC_API.G_EXCEPTION_ERROR;

326: x_return_status);
327: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
328: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
329: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
330: RAISE OKC_API.G_EXCEPTION_ERROR;
331: END IF;
332: --
333: -- Call Before Logic Hook
334: --

Line 337: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

333: -- Call Before Logic Hook
334: --
335: g_ctcv_rec := p_ctcv_rec;
336: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
337: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
338: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
339: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
340: raise OKC_API.G_EXCEPTION_ERROR;
341: END IF;

Line 338: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

334: --
335: g_ctcv_rec := p_ctcv_rec;
336: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
337: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
338: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
339: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
340: raise OKC_API.G_EXCEPTION_ERROR;
341: END IF;
342: reset(p_ctcv_rec);

Line 339: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

335: g_ctcv_rec := p_ctcv_rec;
336: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
337: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
338: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
339: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
340: raise OKC_API.G_EXCEPTION_ERROR;
341: END IF;
342: reset(p_ctcv_rec);
343: OKC_CONTRACT_PARTY_PVT.delete_contact(p_api_version,

Line 340: raise OKC_API.G_EXCEPTION_ERROR;

336: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
337: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
338: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
339: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
340: raise OKC_API.G_EXCEPTION_ERROR;
341: END IF;
342: reset(p_ctcv_rec);
343: OKC_CONTRACT_PARTY_PVT.delete_contact(p_api_version,
344: p_init_msg_list,

Line 349: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

345: x_return_status,
346: x_msg_count,
347: x_msg_data,
348: g_ctcv_rec);
349: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
350: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
351: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
352: RAISE OKC_API.G_EXCEPTION_ERROR;
353: END IF;

Line 350: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

346: x_msg_count,
347: x_msg_data,
348: g_ctcv_rec);
349: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
350: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
351: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
352: RAISE OKC_API.G_EXCEPTION_ERROR;
353: END IF;
354: --

Line 351: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

347: x_msg_data,
348: g_ctcv_rec);
349: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
350: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
351: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
352: RAISE OKC_API.G_EXCEPTION_ERROR;
353: END IF;
354: --
355: -- Call After Logic Hook

Line 352: RAISE OKC_API.G_EXCEPTION_ERROR;

348: g_ctcv_rec);
349: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
350: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
351: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
352: RAISE OKC_API.G_EXCEPTION_ERROR;
353: END IF;
354: --
355: -- Call After Logic Hook
356: --

Line 358: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

354: --
355: -- Call After Logic Hook
356: --
357: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
358: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
359: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
360: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
361: raise OKC_API.G_EXCEPTION_ERROR;
362: END IF;

Line 359: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

355: -- Call After Logic Hook
356: --
357: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
358: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
359: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
360: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
361: raise OKC_API.G_EXCEPTION_ERROR;
362: END IF;
363: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 360: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

356: --
357: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
358: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
359: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
360: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
361: raise OKC_API.G_EXCEPTION_ERROR;
362: END IF;
363: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
364: EXCEPTION

Line 361: raise OKC_API.G_EXCEPTION_ERROR;

357: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
358: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
359: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
360: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
361: raise OKC_API.G_EXCEPTION_ERROR;
362: END IF;
363: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
364: EXCEPTION
365: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 363: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

359: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
360: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
361: raise OKC_API.G_EXCEPTION_ERROR;
362: END IF;
363: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
364: EXCEPTION
365: WHEN OKC_API.G_EXCEPTION_ERROR THEN
366: x_return_status := OKC_API.HANDLE_EXCEPTIONS
367: (substr(l_api_name,1,26),

Line 365: WHEN OKC_API.G_EXCEPTION_ERROR THEN

361: raise OKC_API.G_EXCEPTION_ERROR;
362: END IF;
363: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
364: EXCEPTION
365: WHEN OKC_API.G_EXCEPTION_ERROR THEN
366: x_return_status := OKC_API.HANDLE_EXCEPTIONS
367: (substr(l_api_name,1,26),
368: G_PKG_NAME,
369: 'OKC_API.G_RET_STS_ERROR',

Line 366: x_return_status := OKC_API.HANDLE_EXCEPTIONS

362: END IF;
363: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
364: EXCEPTION
365: WHEN OKC_API.G_EXCEPTION_ERROR THEN
366: x_return_status := OKC_API.HANDLE_EXCEPTIONS
367: (substr(l_api_name,1,26),
368: G_PKG_NAME,
369: 'OKC_API.G_RET_STS_ERROR',
370: x_msg_count,

Line 369: 'OKC_API.G_RET_STS_ERROR',

365: WHEN OKC_API.G_EXCEPTION_ERROR THEN
366: x_return_status := OKC_API.HANDLE_EXCEPTIONS
367: (substr(l_api_name,1,26),
368: G_PKG_NAME,
369: 'OKC_API.G_RET_STS_ERROR',
370: x_msg_count,
371: x_msg_data,
372: '_PUB');
373: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 373: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

369: 'OKC_API.G_RET_STS_ERROR',
370: x_msg_count,
371: x_msg_data,
372: '_PUB');
373: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
374: x_return_status := OKC_API.HANDLE_EXCEPTIONS
375: (substr(l_api_name,1,26),
376: G_PKG_NAME,
377: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 374: x_return_status := OKC_API.HANDLE_EXCEPTIONS

370: x_msg_count,
371: x_msg_data,
372: '_PUB');
373: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
374: x_return_status := OKC_API.HANDLE_EXCEPTIONS
375: (substr(l_api_name,1,26),
376: G_PKG_NAME,
377: 'OKC_API.G_RET_STS_UNEXP_ERROR',
378: x_msg_count,

Line 377: 'OKC_API.G_RET_STS_UNEXP_ERROR',

373: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
374: x_return_status := OKC_API.HANDLE_EXCEPTIONS
375: (substr(l_api_name,1,26),
376: G_PKG_NAME,
377: 'OKC_API.G_RET_STS_UNEXP_ERROR',
378: x_msg_count,
379: x_msg_data,
380: '_PUB');
381: WHEN OTHERS THEN

Line 382: x_return_status := OKC_API.HANDLE_EXCEPTIONS

378: x_msg_count,
379: x_msg_data,
380: '_PUB');
381: WHEN OTHERS THEN
382: x_return_status := OKC_API.HANDLE_EXCEPTIONS
383: (substr(l_api_name,1,26),
384: G_PKG_NAME,
385: 'OTHERS',
386: x_msg_count,

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

402: x_msg_count OUT NOCOPY NUMBER,
403: x_msg_data OUT NOCOPY VARCHAR2,
404: p_ctcv_tbl IN ctcv_tbl_type) is
405: i NUMBER;
406: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
407: begin
408: OKC_API.init_msg_list(p_init_msg_list);
409: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
410: if (p_ctcv_tbl.COUNT>0) then

Line 408: OKC_API.init_msg_list(p_init_msg_list);

404: p_ctcv_tbl IN ctcv_tbl_type) is
405: i NUMBER;
406: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
407: begin
408: OKC_API.init_msg_list(p_init_msg_list);
409: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
410: if (p_ctcv_tbl.COUNT>0) then
411: i := p_ctcv_tbl.FIRST;
412: LOOP

Line 409: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

405: i NUMBER;
406: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
407: begin
408: OKC_API.init_msg_list(p_init_msg_list);
409: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
410: if (p_ctcv_tbl.COUNT>0) then
411: i := p_ctcv_tbl.FIRST;
412: LOOP
413: delete_contact(p_api_version=>p_api_version,

Line 414: p_init_msg_list=>OKC_API.G_FALSE,

410: if (p_ctcv_tbl.COUNT>0) then
411: i := p_ctcv_tbl.FIRST;
412: LOOP
413: delete_contact(p_api_version=>p_api_version,
414: p_init_msg_list=>OKC_API.G_FALSE,
415: x_return_status=>l_return_status,
416: x_msg_count=>x_msg_count,
417: x_msg_data=>x_msg_data,
418: p_ctcv_rec=>p_ctcv_tbl(i));

Line 419: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

415: x_return_status=>l_return_status,
416: x_msg_count=>x_msg_count,
417: x_msg_data=>x_msg_data,
418: p_ctcv_rec=>p_ctcv_tbl(i));
419: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
420: x_return_status := l_return_status;
421: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
422: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
423: x_return_status := l_return_status;

Line 421: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

417: x_msg_data=>x_msg_data,
418: p_ctcv_rec=>p_ctcv_tbl(i));
419: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
420: x_return_status := l_return_status;
421: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
422: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
423: x_return_status := l_return_status;
424: end if;
425: EXIT WHEN (i=p_ctcv_tbl.LAST);

Line 422: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

418: p_ctcv_rec=>p_ctcv_tbl(i));
419: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
420: x_return_status := l_return_status;
421: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
422: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
423: x_return_status := l_return_status;
424: end if;
425: EXIT WHEN (i=p_ctcv_tbl.LAST);
426: i := p_ctcv_tbl.NEXT(i);

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

445: x_msg_data OUT NOCOPY VARCHAR2,
446: p_ctcv_rec IN ctcv_rec_type) is
447: l_api_name CONSTANT VARCHAR2(30) := 'lock_contact';
448: l_api_version CONSTANT NUMBER := 1;
449: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
450: begin
451: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
452: G_PKG_NAME,
453: p_init_msg_list,

Line 451: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

447: l_api_name CONSTANT VARCHAR2(30) := 'lock_contact';
448: l_api_version CONSTANT NUMBER := 1;
449: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
450: begin
451: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
452: G_PKG_NAME,
453: p_init_msg_list,
454: l_api_version,
455: p_api_version,

Line 458: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

454: l_api_version,
455: p_api_version,
456: '_PUB',
457: x_return_status);
458: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
459: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
460: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
461: RAISE OKC_API.G_EXCEPTION_ERROR;
462: END IF;

Line 459: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

455: p_api_version,
456: '_PUB',
457: x_return_status);
458: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
459: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
460: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
461: RAISE OKC_API.G_EXCEPTION_ERROR;
462: END IF;
463: --

Line 460: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

456: '_PUB',
457: x_return_status);
458: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
459: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
460: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
461: RAISE OKC_API.G_EXCEPTION_ERROR;
462: END IF;
463: --
464: -- Call Before Logic Hook

Line 461: RAISE OKC_API.G_EXCEPTION_ERROR;

457: x_return_status);
458: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
459: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
460: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
461: RAISE OKC_API.G_EXCEPTION_ERROR;
462: END IF;
463: --
464: -- Call Before Logic Hook
465: --

Line 468: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

464: -- Call Before Logic Hook
465: --
466: g_ctcv_rec := p_ctcv_rec;
467: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
468: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
469: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
470: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
471: raise OKC_API.G_EXCEPTION_ERROR;
472: END IF;

Line 469: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

465: --
466: g_ctcv_rec := p_ctcv_rec;
467: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
468: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
469: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
470: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
471: raise OKC_API.G_EXCEPTION_ERROR;
472: END IF;
473: reset(p_ctcv_rec);

Line 470: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

466: g_ctcv_rec := p_ctcv_rec;
467: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
468: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
469: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
470: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
471: raise OKC_API.G_EXCEPTION_ERROR;
472: END IF;
473: reset(p_ctcv_rec);
474: OKC_CONTRACT_PARTY_PVT.lock_contact(p_api_version,

Line 471: raise OKC_API.G_EXCEPTION_ERROR;

467: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
468: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
469: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
470: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
471: raise OKC_API.G_EXCEPTION_ERROR;
472: END IF;
473: reset(p_ctcv_rec);
474: OKC_CONTRACT_PARTY_PVT.lock_contact(p_api_version,
475: p_init_msg_list,

Line 480: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

476: x_return_status,
477: x_msg_count,
478: x_msg_data,
479: g_ctcv_rec);
480: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
481: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
482: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
483: RAISE OKC_API.G_EXCEPTION_ERROR;
484: END IF;

Line 481: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

477: x_msg_count,
478: x_msg_data,
479: g_ctcv_rec);
480: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
481: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
482: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
483: RAISE OKC_API.G_EXCEPTION_ERROR;
484: END IF;
485: --

Line 482: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

478: x_msg_data,
479: g_ctcv_rec);
480: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
481: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
482: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
483: RAISE OKC_API.G_EXCEPTION_ERROR;
484: END IF;
485: --
486: -- Call After Logic Hook

Line 483: RAISE OKC_API.G_EXCEPTION_ERROR;

479: g_ctcv_rec);
480: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
481: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
482: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
483: RAISE OKC_API.G_EXCEPTION_ERROR;
484: END IF;
485: --
486: -- Call After Logic Hook
487: --

Line 489: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

485: --
486: -- Call After Logic Hook
487: --
488: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
489: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
490: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
491: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
492: raise OKC_API.G_EXCEPTION_ERROR;
493: END IF;

Line 490: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

486: -- Call After Logic Hook
487: --
488: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
489: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
490: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
491: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
492: raise OKC_API.G_EXCEPTION_ERROR;
493: END IF;
494: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 491: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

487: --
488: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
489: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
490: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
491: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
492: raise OKC_API.G_EXCEPTION_ERROR;
493: END IF;
494: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
495: EXCEPTION

Line 492: raise OKC_API.G_EXCEPTION_ERROR;

488: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
489: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
490: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
491: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
492: raise OKC_API.G_EXCEPTION_ERROR;
493: END IF;
494: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
495: EXCEPTION
496: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 494: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

490: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
491: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
492: raise OKC_API.G_EXCEPTION_ERROR;
493: END IF;
494: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
495: EXCEPTION
496: WHEN OKC_API.G_EXCEPTION_ERROR THEN
497: x_return_status := OKC_API.HANDLE_EXCEPTIONS
498: (substr(l_api_name,1,26),

Line 496: WHEN OKC_API.G_EXCEPTION_ERROR THEN

492: raise OKC_API.G_EXCEPTION_ERROR;
493: END IF;
494: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
495: EXCEPTION
496: WHEN OKC_API.G_EXCEPTION_ERROR THEN
497: x_return_status := OKC_API.HANDLE_EXCEPTIONS
498: (substr(l_api_name,1,26),
499: G_PKG_NAME,
500: 'OKC_API.G_RET_STS_ERROR',

Line 497: x_return_status := OKC_API.HANDLE_EXCEPTIONS

493: END IF;
494: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
495: EXCEPTION
496: WHEN OKC_API.G_EXCEPTION_ERROR THEN
497: x_return_status := OKC_API.HANDLE_EXCEPTIONS
498: (substr(l_api_name,1,26),
499: G_PKG_NAME,
500: 'OKC_API.G_RET_STS_ERROR',
501: x_msg_count,

Line 500: 'OKC_API.G_RET_STS_ERROR',

496: WHEN OKC_API.G_EXCEPTION_ERROR THEN
497: x_return_status := OKC_API.HANDLE_EXCEPTIONS
498: (substr(l_api_name,1,26),
499: G_PKG_NAME,
500: 'OKC_API.G_RET_STS_ERROR',
501: x_msg_count,
502: x_msg_data,
503: '_PUB');
504: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 504: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

500: 'OKC_API.G_RET_STS_ERROR',
501: x_msg_count,
502: x_msg_data,
503: '_PUB');
504: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
505: x_return_status := OKC_API.HANDLE_EXCEPTIONS
506: (substr(l_api_name,1,26),
507: G_PKG_NAME,
508: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 505: x_return_status := OKC_API.HANDLE_EXCEPTIONS

501: x_msg_count,
502: x_msg_data,
503: '_PUB');
504: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
505: x_return_status := OKC_API.HANDLE_EXCEPTIONS
506: (substr(l_api_name,1,26),
507: G_PKG_NAME,
508: 'OKC_API.G_RET_STS_UNEXP_ERROR',
509: x_msg_count,

Line 508: 'OKC_API.G_RET_STS_UNEXP_ERROR',

504: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
505: x_return_status := OKC_API.HANDLE_EXCEPTIONS
506: (substr(l_api_name,1,26),
507: G_PKG_NAME,
508: 'OKC_API.G_RET_STS_UNEXP_ERROR',
509: x_msg_count,
510: x_msg_data,
511: '_PUB');
512: WHEN OTHERS THEN

Line 513: x_return_status := OKC_API.HANDLE_EXCEPTIONS

509: x_msg_count,
510: x_msg_data,
511: '_PUB');
512: WHEN OTHERS THEN
513: x_return_status := OKC_API.HANDLE_EXCEPTIONS
514: (substr(l_api_name,1,26),
515: G_PKG_NAME,
516: 'OTHERS',
517: x_msg_count,

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

533: x_msg_count OUT NOCOPY NUMBER,
534: x_msg_data OUT NOCOPY VARCHAR2,
535: p_ctcv_tbl IN ctcv_tbl_type) is
536: i NUMBER;
537: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
538: begin
539: OKC_API.init_msg_list(p_init_msg_list);
540: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
541: if (p_ctcv_tbl.COUNT>0) then

Line 539: OKC_API.init_msg_list(p_init_msg_list);

535: p_ctcv_tbl IN ctcv_tbl_type) is
536: i NUMBER;
537: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
538: begin
539: OKC_API.init_msg_list(p_init_msg_list);
540: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
541: if (p_ctcv_tbl.COUNT>0) then
542: i := p_ctcv_tbl.FIRST;
543: LOOP

Line 540: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

536: i NUMBER;
537: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
538: begin
539: OKC_API.init_msg_list(p_init_msg_list);
540: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
541: if (p_ctcv_tbl.COUNT>0) then
542: i := p_ctcv_tbl.FIRST;
543: LOOP
544: lock_contact(p_api_version=>p_api_version,

Line 545: p_init_msg_list=>OKC_API.G_FALSE,

541: if (p_ctcv_tbl.COUNT>0) then
542: i := p_ctcv_tbl.FIRST;
543: LOOP
544: lock_contact(p_api_version=>p_api_version,
545: p_init_msg_list=>OKC_API.G_FALSE,
546: x_return_status=>l_return_status,
547: x_msg_count=>x_msg_count,
548: x_msg_data=>x_msg_data,
549: p_ctcv_rec=>p_ctcv_tbl(i));

Line 550: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

546: x_return_status=>l_return_status,
547: x_msg_count=>x_msg_count,
548: x_msg_data=>x_msg_data,
549: p_ctcv_rec=>p_ctcv_tbl(i));
550: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
551: x_return_status := l_return_status;
552: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
553: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
554: x_return_status := l_return_status;

Line 552: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

548: x_msg_data=>x_msg_data,
549: p_ctcv_rec=>p_ctcv_tbl(i));
550: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
551: x_return_status := l_return_status;
552: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
553: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
554: x_return_status := l_return_status;
555: end if;
556: EXIT WHEN (i=p_ctcv_tbl.LAST);

Line 553: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

549: p_ctcv_rec=>p_ctcv_tbl(i));
550: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
551: x_return_status := l_return_status;
552: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
553: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
554: x_return_status := l_return_status;
555: end if;
556: EXIT WHEN (i=p_ctcv_tbl.LAST);
557: i := p_ctcv_tbl.NEXT(i);

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

576: x_msg_data OUT NOCOPY VARCHAR2,
577: p_ctcv_rec IN ctcv_rec_type) is
578: l_api_name CONSTANT VARCHAR2(30) := 'validate_contact';
579: l_api_version CONSTANT NUMBER := 1;
580: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
581: begin
582: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
583: G_PKG_NAME,
584: p_init_msg_list,

Line 582: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

578: l_api_name CONSTANT VARCHAR2(30) := 'validate_contact';
579: l_api_version CONSTANT NUMBER := 1;
580: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
581: begin
582: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
583: G_PKG_NAME,
584: p_init_msg_list,
585: l_api_version,
586: p_api_version,

Line 589: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

585: l_api_version,
586: p_api_version,
587: '_PUB',
588: x_return_status);
589: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
590: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
591: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
592: RAISE OKC_API.G_EXCEPTION_ERROR;
593: END IF;

Line 590: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

586: p_api_version,
587: '_PUB',
588: x_return_status);
589: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
590: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
591: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
592: RAISE OKC_API.G_EXCEPTION_ERROR;
593: END IF;
594: --

Line 591: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

587: '_PUB',
588: x_return_status);
589: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
590: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
591: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
592: RAISE OKC_API.G_EXCEPTION_ERROR;
593: END IF;
594: --
595: -- Call Before Logic Hook

Line 592: RAISE OKC_API.G_EXCEPTION_ERROR;

588: x_return_status);
589: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
590: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
591: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
592: RAISE OKC_API.G_EXCEPTION_ERROR;
593: END IF;
594: --
595: -- Call Before Logic Hook
596: --

Line 599: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

595: -- Call Before Logic Hook
596: --
597: g_ctcv_rec := p_ctcv_rec;
598: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
599: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
600: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
601: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
602: raise OKC_API.G_EXCEPTION_ERROR;
603: END IF;

Line 600: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

596: --
597: g_ctcv_rec := p_ctcv_rec;
598: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
599: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
600: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
601: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
602: raise OKC_API.G_EXCEPTION_ERROR;
603: END IF;
604: reset(p_ctcv_rec);

Line 601: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

597: g_ctcv_rec := p_ctcv_rec;
598: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
599: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
600: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
601: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
602: raise OKC_API.G_EXCEPTION_ERROR;
603: END IF;
604: reset(p_ctcv_rec);
605: OKC_CONTRACT_PARTY_PVT.validate_contact(p_api_version,

Line 602: raise OKC_API.G_EXCEPTION_ERROR;

598: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
599: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
600: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
601: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
602: raise OKC_API.G_EXCEPTION_ERROR;
603: END IF;
604: reset(p_ctcv_rec);
605: OKC_CONTRACT_PARTY_PVT.validate_contact(p_api_version,
606: p_init_msg_list,

Line 611: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

607: x_return_status,
608: x_msg_count,
609: x_msg_data,
610: g_ctcv_rec);
611: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
612: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
613: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
614: RAISE OKC_API.G_EXCEPTION_ERROR;
615: END IF;

Line 612: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

608: x_msg_count,
609: x_msg_data,
610: g_ctcv_rec);
611: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
612: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
613: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
614: RAISE OKC_API.G_EXCEPTION_ERROR;
615: END IF;
616: --

Line 613: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

609: x_msg_data,
610: g_ctcv_rec);
611: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
612: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
613: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
614: RAISE OKC_API.G_EXCEPTION_ERROR;
615: END IF;
616: --
617: -- Call After Logic Hook

Line 614: RAISE OKC_API.G_EXCEPTION_ERROR;

610: g_ctcv_rec);
611: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
612: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
613: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
614: RAISE OKC_API.G_EXCEPTION_ERROR;
615: END IF;
616: --
617: -- Call After Logic Hook
618: --

Line 620: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

616: --
617: -- Call After Logic Hook
618: --
619: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
620: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
621: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
622: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
623: raise OKC_API.G_EXCEPTION_ERROR;
624: END IF;

Line 621: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

617: -- Call After Logic Hook
618: --
619: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
620: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
621: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
622: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
623: raise OKC_API.G_EXCEPTION_ERROR;
624: END IF;
625: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 622: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

618: --
619: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
620: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
621: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
622: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
623: raise OKC_API.G_EXCEPTION_ERROR;
624: END IF;
625: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
626: EXCEPTION

Line 623: raise OKC_API.G_EXCEPTION_ERROR;

619: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
620: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
621: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
622: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
623: raise OKC_API.G_EXCEPTION_ERROR;
624: END IF;
625: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
626: EXCEPTION
627: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 625: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

621: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
622: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
623: raise OKC_API.G_EXCEPTION_ERROR;
624: END IF;
625: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
626: EXCEPTION
627: WHEN OKC_API.G_EXCEPTION_ERROR THEN
628: x_return_status := OKC_API.HANDLE_EXCEPTIONS
629: (substr(l_api_name,1,26),

Line 627: WHEN OKC_API.G_EXCEPTION_ERROR THEN

623: raise OKC_API.G_EXCEPTION_ERROR;
624: END IF;
625: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
626: EXCEPTION
627: WHEN OKC_API.G_EXCEPTION_ERROR THEN
628: x_return_status := OKC_API.HANDLE_EXCEPTIONS
629: (substr(l_api_name,1,26),
630: G_PKG_NAME,
631: 'OKC_API.G_RET_STS_ERROR',

Line 628: x_return_status := OKC_API.HANDLE_EXCEPTIONS

624: END IF;
625: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
626: EXCEPTION
627: WHEN OKC_API.G_EXCEPTION_ERROR THEN
628: x_return_status := OKC_API.HANDLE_EXCEPTIONS
629: (substr(l_api_name,1,26),
630: G_PKG_NAME,
631: 'OKC_API.G_RET_STS_ERROR',
632: x_msg_count,

Line 631: 'OKC_API.G_RET_STS_ERROR',

627: WHEN OKC_API.G_EXCEPTION_ERROR THEN
628: x_return_status := OKC_API.HANDLE_EXCEPTIONS
629: (substr(l_api_name,1,26),
630: G_PKG_NAME,
631: 'OKC_API.G_RET_STS_ERROR',
632: x_msg_count,
633: x_msg_data,
634: '_PUB');
635: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 635: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

631: 'OKC_API.G_RET_STS_ERROR',
632: x_msg_count,
633: x_msg_data,
634: '_PUB');
635: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
636: x_return_status := OKC_API.HANDLE_EXCEPTIONS
637: (substr(l_api_name,1,26),
638: G_PKG_NAME,
639: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 636: x_return_status := OKC_API.HANDLE_EXCEPTIONS

632: x_msg_count,
633: x_msg_data,
634: '_PUB');
635: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
636: x_return_status := OKC_API.HANDLE_EXCEPTIONS
637: (substr(l_api_name,1,26),
638: G_PKG_NAME,
639: 'OKC_API.G_RET_STS_UNEXP_ERROR',
640: x_msg_count,

Line 639: 'OKC_API.G_RET_STS_UNEXP_ERROR',

635: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
636: x_return_status := OKC_API.HANDLE_EXCEPTIONS
637: (substr(l_api_name,1,26),
638: G_PKG_NAME,
639: 'OKC_API.G_RET_STS_UNEXP_ERROR',
640: x_msg_count,
641: x_msg_data,
642: '_PUB');
643: WHEN OTHERS THEN

Line 644: x_return_status := OKC_API.HANDLE_EXCEPTIONS

640: x_msg_count,
641: x_msg_data,
642: '_PUB');
643: WHEN OTHERS THEN
644: x_return_status := OKC_API.HANDLE_EXCEPTIONS
645: (substr(l_api_name,1,26),
646: G_PKG_NAME,
647: 'OTHERS',
648: x_msg_count,

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

664: x_msg_count OUT NOCOPY NUMBER,
665: x_msg_data OUT NOCOPY VARCHAR2,
666: p_ctcv_tbl IN ctcv_tbl_type) is
667: i NUMBER;
668: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
669: begin
670: OKC_API.init_msg_list(p_init_msg_list);
671: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
672: if (p_ctcv_tbl.COUNT>0) then

Line 670: OKC_API.init_msg_list(p_init_msg_list);

666: p_ctcv_tbl IN ctcv_tbl_type) is
667: i NUMBER;
668: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
669: begin
670: OKC_API.init_msg_list(p_init_msg_list);
671: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
672: if (p_ctcv_tbl.COUNT>0) then
673: i := p_ctcv_tbl.FIRST;
674: LOOP

Line 671: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

667: i NUMBER;
668: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
669: begin
670: OKC_API.init_msg_list(p_init_msg_list);
671: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
672: if (p_ctcv_tbl.COUNT>0) then
673: i := p_ctcv_tbl.FIRST;
674: LOOP
675: validate_contact(p_api_version=>p_api_version,

Line 676: p_init_msg_list=>OKC_API.G_FALSE,

672: if (p_ctcv_tbl.COUNT>0) then
673: i := p_ctcv_tbl.FIRST;
674: LOOP
675: validate_contact(p_api_version=>p_api_version,
676: p_init_msg_list=>OKC_API.G_FALSE,
677: x_return_status=>l_return_status,
678: x_msg_count=>x_msg_count,
679: x_msg_data=>x_msg_data,
680: p_ctcv_rec=>p_ctcv_tbl(i));

Line 681: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

677: x_return_status=>l_return_status,
678: x_msg_count=>x_msg_count,
679: x_msg_data=>x_msg_data,
680: p_ctcv_rec=>p_ctcv_tbl(i));
681: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
682: x_return_status := l_return_status;
683: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
684: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
685: x_return_status := l_return_status;

Line 683: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

679: x_msg_data=>x_msg_data,
680: p_ctcv_rec=>p_ctcv_tbl(i));
681: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
682: x_return_status := l_return_status;
683: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
684: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
685: x_return_status := l_return_status;
686: end if;
687: EXIT WHEN (i=p_ctcv_tbl.LAST);

Line 684: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

680: p_ctcv_rec=>p_ctcv_tbl(i));
681: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
682: x_return_status := l_return_status;
683: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
684: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
685: x_return_status := l_return_status;
686: end if;
687: EXIT WHEN (i=p_ctcv_tbl.LAST);
688: i := p_ctcv_tbl.NEXT(i);

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

708: p_cplv_rec IN cplv_rec_type,
709: x_cplv_rec OUT NOCOPY cplv_rec_type) is
710: l_api_name CONSTANT VARCHAR2(30) := 'create_k_party_role';
711: l_api_version CONSTANT NUMBER := 1;
712: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
713: begin
714: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
715: G_PKG_NAME,
716: p_init_msg_list,

Line 714: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

710: l_api_name CONSTANT VARCHAR2(30) := 'create_k_party_role';
711: l_api_version CONSTANT NUMBER := 1;
712: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
713: begin
714: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
715: G_PKG_NAME,
716: p_init_msg_list,
717: l_api_version,
718: p_api_version,

Line 721: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

717: l_api_version,
718: p_api_version,
719: '_PUB',
720: x_return_status);
721: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
722: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
723: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
724: RAISE OKC_API.G_EXCEPTION_ERROR;
725: END IF;

Line 722: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

718: p_api_version,
719: '_PUB',
720: x_return_status);
721: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
722: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
723: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
724: RAISE OKC_API.G_EXCEPTION_ERROR;
725: END IF;
726: --

Line 723: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

719: '_PUB',
720: x_return_status);
721: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
722: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
723: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
724: RAISE OKC_API.G_EXCEPTION_ERROR;
725: END IF;
726: --
727: -- Call Before Logic Hook

Line 724: RAISE OKC_API.G_EXCEPTION_ERROR;

720: x_return_status);
721: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
722: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
723: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
724: RAISE OKC_API.G_EXCEPTION_ERROR;
725: END IF;
726: --
727: -- Call Before Logic Hook
728: --

Line 731: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

727: -- Call Before Logic Hook
728: --
729: g_cplv_rec := p_cplv_rec;
730: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
731: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
732: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
733: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
734: raise OKC_API.G_EXCEPTION_ERROR;
735: END IF;

Line 732: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

728: --
729: g_cplv_rec := p_cplv_rec;
730: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
731: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
732: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
733: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
734: raise OKC_API.G_EXCEPTION_ERROR;
735: END IF;
736: reset(p_cplv_rec);

Line 733: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

729: g_cplv_rec := p_cplv_rec;
730: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
731: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
732: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
733: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
734: raise OKC_API.G_EXCEPTION_ERROR;
735: END IF;
736: reset(p_cplv_rec);
737: OKC_CONTRACT_PARTY_PVT.create_k_party_role(p_api_version,

Line 734: raise OKC_API.G_EXCEPTION_ERROR;

730: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
731: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
732: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
733: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
734: raise OKC_API.G_EXCEPTION_ERROR;
735: END IF;
736: reset(p_cplv_rec);
737: OKC_CONTRACT_PARTY_PVT.create_k_party_role(p_api_version,
738: p_init_msg_list,

Line 744: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

740: x_msg_count,
741: x_msg_data,
742: g_cplv_rec,
743: x_cplv_rec);
744: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
745: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
746: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
747: RAISE OKC_API.G_EXCEPTION_ERROR;
748: END IF;

Line 745: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

741: x_msg_data,
742: g_cplv_rec,
743: x_cplv_rec);
744: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
745: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
746: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
747: RAISE OKC_API.G_EXCEPTION_ERROR;
748: END IF;
749: --

Line 746: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

742: g_cplv_rec,
743: x_cplv_rec);
744: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
745: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
746: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
747: RAISE OKC_API.G_EXCEPTION_ERROR;
748: END IF;
749: --
750: -- Call After Logic Hook

Line 747: RAISE OKC_API.G_EXCEPTION_ERROR;

743: x_cplv_rec);
744: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
745: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
746: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
747: RAISE OKC_API.G_EXCEPTION_ERROR;
748: END IF;
749: --
750: -- Call After Logic Hook
751: --

Line 754: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

750: -- Call After Logic Hook
751: --
752: g_cplv_rec := x_cplv_rec;
753: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
754: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
755: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
756: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
757: raise OKC_API.G_EXCEPTION_ERROR;
758: END IF;

Line 755: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

751: --
752: g_cplv_rec := x_cplv_rec;
753: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
754: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
755: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
756: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
757: raise OKC_API.G_EXCEPTION_ERROR;
758: END IF;
759: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 756: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

752: g_cplv_rec := x_cplv_rec;
753: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
754: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
755: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
756: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
757: raise OKC_API.G_EXCEPTION_ERROR;
758: END IF;
759: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
760: EXCEPTION

Line 757: raise OKC_API.G_EXCEPTION_ERROR;

753: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
754: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
755: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
756: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
757: raise OKC_API.G_EXCEPTION_ERROR;
758: END IF;
759: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
760: EXCEPTION
761: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 759: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

755: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
756: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
757: raise OKC_API.G_EXCEPTION_ERROR;
758: END IF;
759: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
760: EXCEPTION
761: WHEN OKC_API.G_EXCEPTION_ERROR THEN
762: x_return_status := OKC_API.HANDLE_EXCEPTIONS
763: (substr(l_api_name,1,26),

Line 761: WHEN OKC_API.G_EXCEPTION_ERROR THEN

757: raise OKC_API.G_EXCEPTION_ERROR;
758: END IF;
759: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
760: EXCEPTION
761: WHEN OKC_API.G_EXCEPTION_ERROR THEN
762: x_return_status := OKC_API.HANDLE_EXCEPTIONS
763: (substr(l_api_name,1,26),
764: G_PKG_NAME,
765: 'OKC_API.G_RET_STS_ERROR',

Line 762: x_return_status := OKC_API.HANDLE_EXCEPTIONS

758: END IF;
759: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
760: EXCEPTION
761: WHEN OKC_API.G_EXCEPTION_ERROR THEN
762: x_return_status := OKC_API.HANDLE_EXCEPTIONS
763: (substr(l_api_name,1,26),
764: G_PKG_NAME,
765: 'OKC_API.G_RET_STS_ERROR',
766: x_msg_count,

Line 765: 'OKC_API.G_RET_STS_ERROR',

761: WHEN OKC_API.G_EXCEPTION_ERROR THEN
762: x_return_status := OKC_API.HANDLE_EXCEPTIONS
763: (substr(l_api_name,1,26),
764: G_PKG_NAME,
765: 'OKC_API.G_RET_STS_ERROR',
766: x_msg_count,
767: x_msg_data,
768: '_PUB');
769: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 769: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

765: 'OKC_API.G_RET_STS_ERROR',
766: x_msg_count,
767: x_msg_data,
768: '_PUB');
769: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
770: x_return_status := OKC_API.HANDLE_EXCEPTIONS
771: (substr(l_api_name,1,26),
772: G_PKG_NAME,
773: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 770: x_return_status := OKC_API.HANDLE_EXCEPTIONS

766: x_msg_count,
767: x_msg_data,
768: '_PUB');
769: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
770: x_return_status := OKC_API.HANDLE_EXCEPTIONS
771: (substr(l_api_name,1,26),
772: G_PKG_NAME,
773: 'OKC_API.G_RET_STS_UNEXP_ERROR',
774: x_msg_count,

Line 773: 'OKC_API.G_RET_STS_UNEXP_ERROR',

769: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
770: x_return_status := OKC_API.HANDLE_EXCEPTIONS
771: (substr(l_api_name,1,26),
772: G_PKG_NAME,
773: 'OKC_API.G_RET_STS_UNEXP_ERROR',
774: x_msg_count,
775: x_msg_data,
776: '_PUB');
777: WHEN OTHERS THEN

Line 778: x_return_status := OKC_API.HANDLE_EXCEPTIONS

774: x_msg_count,
775: x_msg_data,
776: '_PUB');
777: WHEN OTHERS THEN
778: x_return_status := OKC_API.HANDLE_EXCEPTIONS
779: (substr(l_api_name,1,26),
780: G_PKG_NAME,
781: 'OTHERS',
782: x_msg_count,

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

799: x_msg_data OUT NOCOPY VARCHAR2,
800: p_cplv_tbl IN cplv_tbl_type,
801: x_cplv_tbl OUT NOCOPY cplv_tbl_type) is
802: i NUMBER;
803: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
804: begin
805: OKC_API.init_msg_list(p_init_msg_list);
806: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
807: if (p_cplv_tbl.COUNT>0) then

Line 805: OKC_API.init_msg_list(p_init_msg_list);

801: x_cplv_tbl OUT NOCOPY cplv_tbl_type) is
802: i NUMBER;
803: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
804: begin
805: OKC_API.init_msg_list(p_init_msg_list);
806: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
807: if (p_cplv_tbl.COUNT>0) then
808: i := p_cplv_tbl.FIRST;
809: LOOP

Line 806: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

802: i NUMBER;
803: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
804: begin
805: OKC_API.init_msg_list(p_init_msg_list);
806: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
807: if (p_cplv_tbl.COUNT>0) then
808: i := p_cplv_tbl.FIRST;
809: LOOP
810: create_k_party_role(p_api_version=>p_api_version,

Line 811: p_init_msg_list=>OKC_API.G_FALSE,

807: if (p_cplv_tbl.COUNT>0) then
808: i := p_cplv_tbl.FIRST;
809: LOOP
810: create_k_party_role(p_api_version=>p_api_version,
811: p_init_msg_list=>OKC_API.G_FALSE,
812: x_return_status=>l_return_status,
813: x_msg_count=>x_msg_count,
814: x_msg_data=>x_msg_data,
815: p_cplv_rec=>p_cplv_tbl(i),

Line 817: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

813: x_msg_count=>x_msg_count,
814: x_msg_data=>x_msg_data,
815: p_cplv_rec=>p_cplv_tbl(i),
816: x_cplv_rec=>x_cplv_tbl(i));
817: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
818: x_return_status := l_return_status;
819: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
820: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
821: x_return_status := l_return_status;

Line 819: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

815: p_cplv_rec=>p_cplv_tbl(i),
816: x_cplv_rec=>x_cplv_tbl(i));
817: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
818: x_return_status := l_return_status;
819: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
820: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
821: x_return_status := l_return_status;
822: end if;
823: EXIT WHEN (i=p_cplv_tbl.LAST);

Line 820: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

816: x_cplv_rec=>x_cplv_tbl(i));
817: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
818: x_return_status := l_return_status;
819: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
820: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
821: x_return_status := l_return_status;
822: end if;
823: EXIT WHEN (i=p_cplv_tbl.LAST);
824: i := p_cplv_tbl.NEXT(i);

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

844: p_cplv_rec IN cplv_rec_type,
845: x_cplv_rec OUT NOCOPY cplv_rec_type) is
846: l_api_name CONSTANT VARCHAR2(30) := 'update_k_party_role';
847: l_api_version CONSTANT NUMBER := 1;
848: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
849: begin
850: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
851: G_PKG_NAME,
852: p_init_msg_list,

Line 850: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

846: l_api_name CONSTANT VARCHAR2(30) := 'update_k_party_role';
847: l_api_version CONSTANT NUMBER := 1;
848: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
849: begin
850: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
851: G_PKG_NAME,
852: p_init_msg_list,
853: l_api_version,
854: p_api_version,

Line 857: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

853: l_api_version,
854: p_api_version,
855: '_PUB',
856: x_return_status);
857: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
858: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
859: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
860: RAISE OKC_API.G_EXCEPTION_ERROR;
861: END IF;

Line 858: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

854: p_api_version,
855: '_PUB',
856: x_return_status);
857: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
858: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
859: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
860: RAISE OKC_API.G_EXCEPTION_ERROR;
861: END IF;
862: --

Line 859: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

855: '_PUB',
856: x_return_status);
857: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
858: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
859: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
860: RAISE OKC_API.G_EXCEPTION_ERROR;
861: END IF;
862: --
863: -- Call Before Logic Hook

Line 860: RAISE OKC_API.G_EXCEPTION_ERROR;

856: x_return_status);
857: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
858: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
859: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
860: RAISE OKC_API.G_EXCEPTION_ERROR;
861: END IF;
862: --
863: -- Call Before Logic Hook
864: --

Line 867: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

863: -- Call Before Logic Hook
864: --
865: g_cplv_rec := p_cplv_rec;
866: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
867: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
868: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
869: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
870: raise OKC_API.G_EXCEPTION_ERROR;
871: END IF;

Line 868: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

864: --
865: g_cplv_rec := p_cplv_rec;
866: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
867: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
868: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
869: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
870: raise OKC_API.G_EXCEPTION_ERROR;
871: END IF;
872: reset(p_cplv_rec);

Line 869: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

865: g_cplv_rec := p_cplv_rec;
866: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
867: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
868: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
869: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
870: raise OKC_API.G_EXCEPTION_ERROR;
871: END IF;
872: reset(p_cplv_rec);
873: OKC_CONTRACT_PARTY_PVT.update_k_party_role(p_api_version,

Line 870: raise OKC_API.G_EXCEPTION_ERROR;

866: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
867: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
868: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
869: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
870: raise OKC_API.G_EXCEPTION_ERROR;
871: END IF;
872: reset(p_cplv_rec);
873: OKC_CONTRACT_PARTY_PVT.update_k_party_role(p_api_version,
874: p_init_msg_list,

Line 880: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

876: x_msg_count,
877: x_msg_data,
878: g_cplv_rec,
879: x_cplv_rec);
880: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
881: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
882: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
883: RAISE OKC_API.G_EXCEPTION_ERROR;
884: END IF;

Line 881: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

877: x_msg_data,
878: g_cplv_rec,
879: x_cplv_rec);
880: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
881: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
882: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
883: RAISE OKC_API.G_EXCEPTION_ERROR;
884: END IF;
885: --

Line 882: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

878: g_cplv_rec,
879: x_cplv_rec);
880: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
881: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
882: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
883: RAISE OKC_API.G_EXCEPTION_ERROR;
884: END IF;
885: --
886: -- Call After Logic Hook

Line 883: RAISE OKC_API.G_EXCEPTION_ERROR;

879: x_cplv_rec);
880: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
881: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
882: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
883: RAISE OKC_API.G_EXCEPTION_ERROR;
884: END IF;
885: --
886: -- Call After Logic Hook
887: --

Line 890: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

886: -- Call After Logic Hook
887: --
888: g_cplv_rec := x_cplv_rec;
889: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
890: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
891: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
892: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
893: raise OKC_API.G_EXCEPTION_ERROR;
894: END IF;

Line 891: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

887: --
888: g_cplv_rec := x_cplv_rec;
889: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
890: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
891: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
892: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
893: raise OKC_API.G_EXCEPTION_ERROR;
894: END IF;
895: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 892: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

888: g_cplv_rec := x_cplv_rec;
889: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
890: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
891: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
892: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
893: raise OKC_API.G_EXCEPTION_ERROR;
894: END IF;
895: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
896: EXCEPTION

Line 893: raise OKC_API.G_EXCEPTION_ERROR;

889: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
890: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
891: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
892: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
893: raise OKC_API.G_EXCEPTION_ERROR;
894: END IF;
895: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
896: EXCEPTION
897: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 895: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

891: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
892: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
893: raise OKC_API.G_EXCEPTION_ERROR;
894: END IF;
895: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
896: EXCEPTION
897: WHEN OKC_API.G_EXCEPTION_ERROR THEN
898: x_return_status := OKC_API.HANDLE_EXCEPTIONS
899: (substr(l_api_name,1,26),

Line 897: WHEN OKC_API.G_EXCEPTION_ERROR THEN

893: raise OKC_API.G_EXCEPTION_ERROR;
894: END IF;
895: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
896: EXCEPTION
897: WHEN OKC_API.G_EXCEPTION_ERROR THEN
898: x_return_status := OKC_API.HANDLE_EXCEPTIONS
899: (substr(l_api_name,1,26),
900: G_PKG_NAME,
901: 'OKC_API.G_RET_STS_ERROR',

Line 898: x_return_status := OKC_API.HANDLE_EXCEPTIONS

894: END IF;
895: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
896: EXCEPTION
897: WHEN OKC_API.G_EXCEPTION_ERROR THEN
898: x_return_status := OKC_API.HANDLE_EXCEPTIONS
899: (substr(l_api_name,1,26),
900: G_PKG_NAME,
901: 'OKC_API.G_RET_STS_ERROR',
902: x_msg_count,

Line 901: 'OKC_API.G_RET_STS_ERROR',

897: WHEN OKC_API.G_EXCEPTION_ERROR THEN
898: x_return_status := OKC_API.HANDLE_EXCEPTIONS
899: (substr(l_api_name,1,26),
900: G_PKG_NAME,
901: 'OKC_API.G_RET_STS_ERROR',
902: x_msg_count,
903: x_msg_data,
904: '_PUB');
905: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 905: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

901: 'OKC_API.G_RET_STS_ERROR',
902: x_msg_count,
903: x_msg_data,
904: '_PUB');
905: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
906: x_return_status := OKC_API.HANDLE_EXCEPTIONS
907: (substr(l_api_name,1,26),
908: G_PKG_NAME,
909: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 906: x_return_status := OKC_API.HANDLE_EXCEPTIONS

902: x_msg_count,
903: x_msg_data,
904: '_PUB');
905: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
906: x_return_status := OKC_API.HANDLE_EXCEPTIONS
907: (substr(l_api_name,1,26),
908: G_PKG_NAME,
909: 'OKC_API.G_RET_STS_UNEXP_ERROR',
910: x_msg_count,

Line 909: 'OKC_API.G_RET_STS_UNEXP_ERROR',

905: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
906: x_return_status := OKC_API.HANDLE_EXCEPTIONS
907: (substr(l_api_name,1,26),
908: G_PKG_NAME,
909: 'OKC_API.G_RET_STS_UNEXP_ERROR',
910: x_msg_count,
911: x_msg_data,
912: '_PUB');
913: WHEN OTHERS THEN

Line 914: x_return_status := OKC_API.HANDLE_EXCEPTIONS

910: x_msg_count,
911: x_msg_data,
912: '_PUB');
913: WHEN OTHERS THEN
914: x_return_status := OKC_API.HANDLE_EXCEPTIONS
915: (substr(l_api_name,1,26),
916: G_PKG_NAME,
917: 'OTHERS',
918: x_msg_count,

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

935: x_msg_data OUT NOCOPY VARCHAR2,
936: p_cplv_tbl IN cplv_tbl_type,
937: x_cplv_tbl OUT NOCOPY cplv_tbl_type) is
938: i NUMBER;
939: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
940: begin
941: OKC_API.init_msg_list(p_init_msg_list);
942: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
943: if (p_cplv_tbl.COUNT>0) then

Line 941: OKC_API.init_msg_list(p_init_msg_list);

937: x_cplv_tbl OUT NOCOPY cplv_tbl_type) is
938: i NUMBER;
939: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
940: begin
941: OKC_API.init_msg_list(p_init_msg_list);
942: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
943: if (p_cplv_tbl.COUNT>0) then
944: i := p_cplv_tbl.FIRST;
945: LOOP

Line 942: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

938: i NUMBER;
939: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
940: begin
941: OKC_API.init_msg_list(p_init_msg_list);
942: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
943: if (p_cplv_tbl.COUNT>0) then
944: i := p_cplv_tbl.FIRST;
945: LOOP
946: update_k_party_role(p_api_version=>p_api_version,

Line 947: p_init_msg_list=>OKC_API.G_FALSE,

943: if (p_cplv_tbl.COUNT>0) then
944: i := p_cplv_tbl.FIRST;
945: LOOP
946: update_k_party_role(p_api_version=>p_api_version,
947: p_init_msg_list=>OKC_API.G_FALSE,
948: x_return_status=>l_return_status,
949: x_msg_count=>x_msg_count,
950: x_msg_data=>x_msg_data,
951: p_cplv_rec=>p_cplv_tbl(i),

Line 953: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

949: x_msg_count=>x_msg_count,
950: x_msg_data=>x_msg_data,
951: p_cplv_rec=>p_cplv_tbl(i),
952: x_cplv_rec=>x_cplv_tbl(i));
953: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
954: x_return_status := l_return_status;
955: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
956: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
957: x_return_status := l_return_status;

Line 955: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

951: p_cplv_rec=>p_cplv_tbl(i),
952: x_cplv_rec=>x_cplv_tbl(i));
953: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
954: x_return_status := l_return_status;
955: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
956: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
957: x_return_status := l_return_status;
958: end if;
959: EXIT WHEN (i=p_cplv_tbl.LAST);

Line 956: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

952: x_cplv_rec=>x_cplv_tbl(i));
953: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
954: x_return_status := l_return_status;
955: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
956: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
957: x_return_status := l_return_status;
958: end if;
959: EXIT WHEN (i=p_cplv_tbl.LAST);
960: i := p_cplv_tbl.NEXT(i);

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

979: x_msg_data OUT NOCOPY VARCHAR2,
980: p_cplv_rec IN cplv_rec_type) is
981: l_api_name CONSTANT VARCHAR2(30) := 'delete_k_party_role';
982: l_api_version CONSTANT NUMBER := 1;
983: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
984: begin
985: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
986: G_PKG_NAME,
987: p_init_msg_list,

Line 985: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

981: l_api_name CONSTANT VARCHAR2(30) := 'delete_k_party_role';
982: l_api_version CONSTANT NUMBER := 1;
983: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
984: begin
985: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
986: G_PKG_NAME,
987: p_init_msg_list,
988: l_api_version,
989: p_api_version,

Line 992: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

988: l_api_version,
989: p_api_version,
990: '_PUB',
991: x_return_status);
992: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
993: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
994: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
995: RAISE OKC_API.G_EXCEPTION_ERROR;
996: END IF;

Line 993: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

989: p_api_version,
990: '_PUB',
991: x_return_status);
992: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
993: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
994: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
995: RAISE OKC_API.G_EXCEPTION_ERROR;
996: END IF;
997: --

Line 994: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

990: '_PUB',
991: x_return_status);
992: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
993: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
994: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
995: RAISE OKC_API.G_EXCEPTION_ERROR;
996: END IF;
997: --
998: -- Call Before Logic Hook

Line 995: RAISE OKC_API.G_EXCEPTION_ERROR;

991: x_return_status);
992: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
993: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
994: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
995: RAISE OKC_API.G_EXCEPTION_ERROR;
996: END IF;
997: --
998: -- Call Before Logic Hook
999: --

Line 1002: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

998: -- Call Before Logic Hook
999: --
1000: g_cplv_rec := p_cplv_rec;
1001: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
1002: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1003: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1004: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1005: raise OKC_API.G_EXCEPTION_ERROR;
1006: END IF;

Line 1003: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

999: --
1000: g_cplv_rec := p_cplv_rec;
1001: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
1002: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1003: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1004: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1005: raise OKC_API.G_EXCEPTION_ERROR;
1006: END IF;
1007: reset(p_cplv_rec);

Line 1004: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1000: g_cplv_rec := p_cplv_rec;
1001: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
1002: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1003: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1004: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1005: raise OKC_API.G_EXCEPTION_ERROR;
1006: END IF;
1007: reset(p_cplv_rec);
1008: OKC_CONTRACT_PARTY_PVT.delete_k_party_role(p_api_version,

Line 1005: raise OKC_API.G_EXCEPTION_ERROR;

1001: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
1002: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1003: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1004: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1005: raise OKC_API.G_EXCEPTION_ERROR;
1006: END IF;
1007: reset(p_cplv_rec);
1008: OKC_CONTRACT_PARTY_PVT.delete_k_party_role(p_api_version,
1009: p_init_msg_list,

Line 1014: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1010: x_return_status,
1011: x_msg_count,
1012: x_msg_data,
1013: g_cplv_rec);
1014: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1015: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1016: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1017: RAISE OKC_API.G_EXCEPTION_ERROR;
1018: END IF;

Line 1015: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1011: x_msg_count,
1012: x_msg_data,
1013: g_cplv_rec);
1014: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1015: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1016: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1017: RAISE OKC_API.G_EXCEPTION_ERROR;
1018: END IF;
1019: --

Line 1016: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1012: x_msg_data,
1013: g_cplv_rec);
1014: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1015: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1016: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1017: RAISE OKC_API.G_EXCEPTION_ERROR;
1018: END IF;
1019: --
1020: -- Call After Logic Hook

Line 1017: RAISE OKC_API.G_EXCEPTION_ERROR;

1013: g_cplv_rec);
1014: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1015: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1016: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1017: RAISE OKC_API.G_EXCEPTION_ERROR;
1018: END IF;
1019: --
1020: -- Call After Logic Hook
1021: --

Line 1023: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1019: --
1020: -- Call After Logic Hook
1021: --
1022: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
1023: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1024: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1026: raise OKC_API.G_EXCEPTION_ERROR;
1027: END IF;

Line 1024: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1020: -- Call After Logic Hook
1021: --
1022: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
1023: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1024: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1026: raise OKC_API.G_EXCEPTION_ERROR;
1027: END IF;
1028: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1025: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1021: --
1022: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
1023: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1024: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1026: raise OKC_API.G_EXCEPTION_ERROR;
1027: END IF;
1028: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1029: EXCEPTION

Line 1026: raise OKC_API.G_EXCEPTION_ERROR;

1022: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
1023: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1024: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1026: raise OKC_API.G_EXCEPTION_ERROR;
1027: END IF;
1028: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1029: EXCEPTION
1030: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1028: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1024: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1026: raise OKC_API.G_EXCEPTION_ERROR;
1027: END IF;
1028: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1029: EXCEPTION
1030: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1031: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1032: (substr(l_api_name,1,26),

Line 1030: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1026: raise OKC_API.G_EXCEPTION_ERROR;
1027: END IF;
1028: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1029: EXCEPTION
1030: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1031: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1032: (substr(l_api_name,1,26),
1033: G_PKG_NAME,
1034: 'OKC_API.G_RET_STS_ERROR',

Line 1031: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1027: END IF;
1028: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1029: EXCEPTION
1030: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1031: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1032: (substr(l_api_name,1,26),
1033: G_PKG_NAME,
1034: 'OKC_API.G_RET_STS_ERROR',
1035: x_msg_count,

Line 1034: 'OKC_API.G_RET_STS_ERROR',

1030: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1031: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1032: (substr(l_api_name,1,26),
1033: G_PKG_NAME,
1034: 'OKC_API.G_RET_STS_ERROR',
1035: x_msg_count,
1036: x_msg_data,
1037: '_PUB');
1038: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1038: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1034: 'OKC_API.G_RET_STS_ERROR',
1035: x_msg_count,
1036: x_msg_data,
1037: '_PUB');
1038: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1039: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1040: (substr(l_api_name,1,26),
1041: G_PKG_NAME,
1042: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1039: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1035: x_msg_count,
1036: x_msg_data,
1037: '_PUB');
1038: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1039: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1040: (substr(l_api_name,1,26),
1041: G_PKG_NAME,
1042: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1043: x_msg_count,

Line 1042: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1038: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1039: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1040: (substr(l_api_name,1,26),
1041: G_PKG_NAME,
1042: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1043: x_msg_count,
1044: x_msg_data,
1045: '_PUB');
1046: WHEN OTHERS THEN

Line 1047: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1043: x_msg_count,
1044: x_msg_data,
1045: '_PUB');
1046: WHEN OTHERS THEN
1047: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1048: (substr(l_api_name,1,26),
1049: G_PKG_NAME,
1050: 'OTHERS',
1051: x_msg_count,

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

1067: x_msg_count OUT NOCOPY NUMBER,
1068: x_msg_data OUT NOCOPY VARCHAR2,
1069: p_cplv_tbl IN cplv_tbl_type) is
1070: i NUMBER;
1071: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1072: begin
1073: OKC_API.init_msg_list(p_init_msg_list);
1074: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
1075: if (p_cplv_tbl.COUNT>0) then

Line 1073: OKC_API.init_msg_list(p_init_msg_list);

1069: p_cplv_tbl IN cplv_tbl_type) is
1070: i NUMBER;
1071: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1072: begin
1073: OKC_API.init_msg_list(p_init_msg_list);
1074: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
1075: if (p_cplv_tbl.COUNT>0) then
1076: i := p_cplv_tbl.FIRST;
1077: LOOP

Line 1074: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

1070: i NUMBER;
1071: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1072: begin
1073: OKC_API.init_msg_list(p_init_msg_list);
1074: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
1075: if (p_cplv_tbl.COUNT>0) then
1076: i := p_cplv_tbl.FIRST;
1077: LOOP
1078: delete_k_party_role(p_api_version=>p_api_version,

Line 1079: p_init_msg_list=>OKC_API.G_FALSE,

1075: if (p_cplv_tbl.COUNT>0) then
1076: i := p_cplv_tbl.FIRST;
1077: LOOP
1078: delete_k_party_role(p_api_version=>p_api_version,
1079: p_init_msg_list=>OKC_API.G_FALSE,
1080: x_return_status=>l_return_status,
1081: x_msg_count=>x_msg_count,
1082: x_msg_data=>x_msg_data,
1083: p_cplv_rec=>p_cplv_tbl(i));

Line 1084: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1080: x_return_status=>l_return_status,
1081: x_msg_count=>x_msg_count,
1082: x_msg_data=>x_msg_data,
1083: p_cplv_rec=>p_cplv_tbl(i));
1084: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1085: x_return_status := l_return_status;
1086: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1087: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1088: x_return_status := l_return_status;

Line 1086: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1082: x_msg_data=>x_msg_data,
1083: p_cplv_rec=>p_cplv_tbl(i));
1084: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1085: x_return_status := l_return_status;
1086: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1087: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1088: x_return_status := l_return_status;
1089: end if;
1090: EXIT WHEN (i=p_cplv_tbl.LAST);

Line 1087: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

1083: p_cplv_rec=>p_cplv_tbl(i));
1084: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1085: x_return_status := l_return_status;
1086: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1087: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1088: x_return_status := l_return_status;
1089: end if;
1090: EXIT WHEN (i=p_cplv_tbl.LAST);
1091: i := p_cplv_tbl.NEXT(i);

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

1110: x_msg_data OUT NOCOPY VARCHAR2,
1111: p_cplv_rec IN cplv_rec_type) is
1112: l_api_name CONSTANT VARCHAR2(30) := 'lock_k_party_role';
1113: l_api_version CONSTANT NUMBER := 1;
1114: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1115: begin
1116: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
1117: G_PKG_NAME,
1118: p_init_msg_list,

Line 1116: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

1112: l_api_name CONSTANT VARCHAR2(30) := 'lock_k_party_role';
1113: l_api_version CONSTANT NUMBER := 1;
1114: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1115: begin
1116: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
1117: G_PKG_NAME,
1118: p_init_msg_list,
1119: l_api_version,
1120: p_api_version,

Line 1123: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1119: l_api_version,
1120: p_api_version,
1121: '_PUB',
1122: x_return_status);
1123: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1124: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1125: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1126: RAISE OKC_API.G_EXCEPTION_ERROR;
1127: END IF;

Line 1124: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1120: p_api_version,
1121: '_PUB',
1122: x_return_status);
1123: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1124: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1125: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1126: RAISE OKC_API.G_EXCEPTION_ERROR;
1127: END IF;
1128: --

Line 1125: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1121: '_PUB',
1122: x_return_status);
1123: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1124: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1125: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1126: RAISE OKC_API.G_EXCEPTION_ERROR;
1127: END IF;
1128: --
1129: -- Call Before Logic Hook

Line 1126: RAISE OKC_API.G_EXCEPTION_ERROR;

1122: x_return_status);
1123: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1124: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1125: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1126: RAISE OKC_API.G_EXCEPTION_ERROR;
1127: END IF;
1128: --
1129: -- Call Before Logic Hook
1130: --

Line 1133: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1129: -- Call Before Logic Hook
1130: --
1131: g_cplv_rec := p_cplv_rec;
1132: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
1133: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1134: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1135: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1136: raise OKC_API.G_EXCEPTION_ERROR;
1137: END IF;

Line 1134: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1130: --
1131: g_cplv_rec := p_cplv_rec;
1132: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
1133: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1134: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1135: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1136: raise OKC_API.G_EXCEPTION_ERROR;
1137: END IF;
1138: reset(p_cplv_rec);

Line 1135: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1131: g_cplv_rec := p_cplv_rec;
1132: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
1133: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1134: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1135: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1136: raise OKC_API.G_EXCEPTION_ERROR;
1137: END IF;
1138: reset(p_cplv_rec);
1139: OKC_CONTRACT_PARTY_PVT.lock_k_party_role(p_api_version,

Line 1136: raise OKC_API.G_EXCEPTION_ERROR;

1132: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
1133: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1134: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1135: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1136: raise OKC_API.G_EXCEPTION_ERROR;
1137: END IF;
1138: reset(p_cplv_rec);
1139: OKC_CONTRACT_PARTY_PVT.lock_k_party_role(p_api_version,
1140: p_init_msg_list,

Line 1145: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1141: x_return_status,
1142: x_msg_count,
1143: x_msg_data,
1144: g_cplv_rec);
1145: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1146: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1147: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1148: RAISE OKC_API.G_EXCEPTION_ERROR;
1149: END IF;

Line 1146: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1142: x_msg_count,
1143: x_msg_data,
1144: g_cplv_rec);
1145: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1146: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1147: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1148: RAISE OKC_API.G_EXCEPTION_ERROR;
1149: END IF;
1150: --

Line 1147: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1143: x_msg_data,
1144: g_cplv_rec);
1145: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1146: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1147: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1148: RAISE OKC_API.G_EXCEPTION_ERROR;
1149: END IF;
1150: --
1151: -- Call After Logic Hook

Line 1148: RAISE OKC_API.G_EXCEPTION_ERROR;

1144: g_cplv_rec);
1145: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1146: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1147: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1148: RAISE OKC_API.G_EXCEPTION_ERROR;
1149: END IF;
1150: --
1151: -- Call After Logic Hook
1152: --

Line 1154: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1150: --
1151: -- Call After Logic Hook
1152: --
1153: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
1154: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1155: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1156: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1157: raise OKC_API.G_EXCEPTION_ERROR;
1158: END IF;

Line 1155: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1151: -- Call After Logic Hook
1152: --
1153: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
1154: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1155: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1156: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1157: raise OKC_API.G_EXCEPTION_ERROR;
1158: END IF;
1159: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1156: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1152: --
1153: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
1154: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1155: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1156: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1157: raise OKC_API.G_EXCEPTION_ERROR;
1158: END IF;
1159: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1160: EXCEPTION

Line 1157: raise OKC_API.G_EXCEPTION_ERROR;

1153: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
1154: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1155: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1156: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1157: raise OKC_API.G_EXCEPTION_ERROR;
1158: END IF;
1159: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1160: EXCEPTION
1161: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1159: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1155: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1156: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1157: raise OKC_API.G_EXCEPTION_ERROR;
1158: END IF;
1159: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1160: EXCEPTION
1161: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1162: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1163: (substr(l_api_name,1,26),

Line 1161: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1157: raise OKC_API.G_EXCEPTION_ERROR;
1158: END IF;
1159: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1160: EXCEPTION
1161: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1162: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1163: (substr(l_api_name,1,26),
1164: G_PKG_NAME,
1165: 'OKC_API.G_RET_STS_ERROR',

Line 1162: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1158: END IF;
1159: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1160: EXCEPTION
1161: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1162: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1163: (substr(l_api_name,1,26),
1164: G_PKG_NAME,
1165: 'OKC_API.G_RET_STS_ERROR',
1166: x_msg_count,

Line 1165: 'OKC_API.G_RET_STS_ERROR',

1161: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1162: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1163: (substr(l_api_name,1,26),
1164: G_PKG_NAME,
1165: 'OKC_API.G_RET_STS_ERROR',
1166: x_msg_count,
1167: x_msg_data,
1168: '_PUB');
1169: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1169: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1165: 'OKC_API.G_RET_STS_ERROR',
1166: x_msg_count,
1167: x_msg_data,
1168: '_PUB');
1169: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1170: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1171: (substr(l_api_name,1,26),
1172: G_PKG_NAME,
1173: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1170: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1166: x_msg_count,
1167: x_msg_data,
1168: '_PUB');
1169: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1170: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1171: (substr(l_api_name,1,26),
1172: G_PKG_NAME,
1173: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1174: x_msg_count,

Line 1173: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1169: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1170: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1171: (substr(l_api_name,1,26),
1172: G_PKG_NAME,
1173: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1174: x_msg_count,
1175: x_msg_data,
1176: '_PUB');
1177: WHEN OTHERS THEN

Line 1178: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1174: x_msg_count,
1175: x_msg_data,
1176: '_PUB');
1177: WHEN OTHERS THEN
1178: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1179: (substr(l_api_name,1,26),
1180: G_PKG_NAME,
1181: 'OTHERS',
1182: x_msg_count,

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

1198: x_msg_count OUT NOCOPY NUMBER,
1199: x_msg_data OUT NOCOPY VARCHAR2,
1200: p_cplv_tbl IN cplv_tbl_type) is
1201: i NUMBER;
1202: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1203: begin
1204: OKC_API.init_msg_list(p_init_msg_list);
1205: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
1206: if (p_cplv_tbl.COUNT>0) then

Line 1204: OKC_API.init_msg_list(p_init_msg_list);

1200: p_cplv_tbl IN cplv_tbl_type) is
1201: i NUMBER;
1202: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1203: begin
1204: OKC_API.init_msg_list(p_init_msg_list);
1205: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
1206: if (p_cplv_tbl.COUNT>0) then
1207: i := p_cplv_tbl.FIRST;
1208: LOOP

Line 1205: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

1201: i NUMBER;
1202: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1203: begin
1204: OKC_API.init_msg_list(p_init_msg_list);
1205: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
1206: if (p_cplv_tbl.COUNT>0) then
1207: i := p_cplv_tbl.FIRST;
1208: LOOP
1209: lock_k_party_role(p_api_version=>p_api_version,

Line 1210: p_init_msg_list=>OKC_API.G_FALSE,

1206: if (p_cplv_tbl.COUNT>0) then
1207: i := p_cplv_tbl.FIRST;
1208: LOOP
1209: lock_k_party_role(p_api_version=>p_api_version,
1210: p_init_msg_list=>OKC_API.G_FALSE,
1211: x_return_status=>l_return_status,
1212: x_msg_count=>x_msg_count,
1213: x_msg_data=>x_msg_data,
1214: p_cplv_rec=>p_cplv_tbl(i));

Line 1215: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1211: x_return_status=>l_return_status,
1212: x_msg_count=>x_msg_count,
1213: x_msg_data=>x_msg_data,
1214: p_cplv_rec=>p_cplv_tbl(i));
1215: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1216: x_return_status := l_return_status;
1217: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1218: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1219: x_return_status := l_return_status;

Line 1217: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1213: x_msg_data=>x_msg_data,
1214: p_cplv_rec=>p_cplv_tbl(i));
1215: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1216: x_return_status := l_return_status;
1217: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1218: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1219: x_return_status := l_return_status;
1220: end if;
1221: EXIT WHEN (i=p_cplv_tbl.LAST);

Line 1218: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

1214: p_cplv_rec=>p_cplv_tbl(i));
1215: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1216: x_return_status := l_return_status;
1217: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1218: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1219: x_return_status := l_return_status;
1220: end if;
1221: EXIT WHEN (i=p_cplv_tbl.LAST);
1222: i := p_cplv_tbl.NEXT(i);

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

1241: x_msg_data OUT NOCOPY VARCHAR2,
1242: p_cplv_rec IN cplv_rec_type) is
1243: l_api_name CONSTANT VARCHAR2(30) := 'validate_k_party_role';
1244: l_api_version CONSTANT NUMBER := 1;
1245: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1246: begin
1247: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
1248: G_PKG_NAME,
1249: p_init_msg_list,

Line 1247: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

1243: l_api_name CONSTANT VARCHAR2(30) := 'validate_k_party_role';
1244: l_api_version CONSTANT NUMBER := 1;
1245: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1246: begin
1247: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
1248: G_PKG_NAME,
1249: p_init_msg_list,
1250: l_api_version,
1251: p_api_version,

Line 1254: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1250: l_api_version,
1251: p_api_version,
1252: '_PUB',
1253: x_return_status);
1254: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1255: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1256: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1257: RAISE OKC_API.G_EXCEPTION_ERROR;
1258: END IF;

Line 1255: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1251: p_api_version,
1252: '_PUB',
1253: x_return_status);
1254: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1255: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1256: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1257: RAISE OKC_API.G_EXCEPTION_ERROR;
1258: END IF;
1259: --

Line 1256: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1252: '_PUB',
1253: x_return_status);
1254: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1255: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1256: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1257: RAISE OKC_API.G_EXCEPTION_ERROR;
1258: END IF;
1259: --
1260: -- Call Before Logic Hook

Line 1257: RAISE OKC_API.G_EXCEPTION_ERROR;

1253: x_return_status);
1254: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1255: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1256: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1257: RAISE OKC_API.G_EXCEPTION_ERROR;
1258: END IF;
1259: --
1260: -- Call Before Logic Hook
1261: --

Line 1264: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1260: -- Call Before Logic Hook
1261: --
1262: g_cplv_rec := p_cplv_rec;
1263: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
1264: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1265: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1266: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1267: raise OKC_API.G_EXCEPTION_ERROR;
1268: END IF;

Line 1265: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1261: --
1262: g_cplv_rec := p_cplv_rec;
1263: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
1264: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1265: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1266: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1267: raise OKC_API.G_EXCEPTION_ERROR;
1268: END IF;
1269: reset(p_cplv_rec);

Line 1266: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1262: g_cplv_rec := p_cplv_rec;
1263: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
1264: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1265: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1266: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1267: raise OKC_API.G_EXCEPTION_ERROR;
1268: END IF;
1269: reset(p_cplv_rec);
1270: OKC_CONTRACT_PARTY_PVT.validate_k_party_role(p_api_version,

Line 1267: raise OKC_API.G_EXCEPTION_ERROR;

1263: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
1264: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1265: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1266: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1267: raise OKC_API.G_EXCEPTION_ERROR;
1268: END IF;
1269: reset(p_cplv_rec);
1270: OKC_CONTRACT_PARTY_PVT.validate_k_party_role(p_api_version,
1271: p_init_msg_list,

Line 1276: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1272: x_return_status,
1273: x_msg_count,
1274: x_msg_data,
1275: g_cplv_rec);
1276: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1277: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1278: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1279: RAISE OKC_API.G_EXCEPTION_ERROR;
1280: END IF;

Line 1277: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1273: x_msg_count,
1274: x_msg_data,
1275: g_cplv_rec);
1276: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1277: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1278: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1279: RAISE OKC_API.G_EXCEPTION_ERROR;
1280: END IF;
1281: --

Line 1278: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1274: x_msg_data,
1275: g_cplv_rec);
1276: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1277: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1278: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1279: RAISE OKC_API.G_EXCEPTION_ERROR;
1280: END IF;
1281: --
1282: -- Call After Logic Hook

Line 1279: RAISE OKC_API.G_EXCEPTION_ERROR;

1275: g_cplv_rec);
1276: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1277: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1278: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1279: RAISE OKC_API.G_EXCEPTION_ERROR;
1280: END IF;
1281: --
1282: -- Call After Logic Hook
1283: --

Line 1285: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1281: --
1282: -- Call After Logic Hook
1283: --
1284: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
1285: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1286: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1287: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1288: raise OKC_API.G_EXCEPTION_ERROR;
1289: END IF;

Line 1286: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1282: -- Call After Logic Hook
1283: --
1284: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
1285: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1286: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1287: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1288: raise OKC_API.G_EXCEPTION_ERROR;
1289: END IF;
1290: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1287: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1283: --
1284: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
1285: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1286: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1287: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1288: raise OKC_API.G_EXCEPTION_ERROR;
1289: END IF;
1290: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1291: EXCEPTION

Line 1288: raise OKC_API.G_EXCEPTION_ERROR;

1284: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
1285: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1286: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1287: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1288: raise OKC_API.G_EXCEPTION_ERROR;
1289: END IF;
1290: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1291: EXCEPTION
1292: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1290: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1286: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1287: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1288: raise OKC_API.G_EXCEPTION_ERROR;
1289: END IF;
1290: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1291: EXCEPTION
1292: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1293: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1294: (substr(l_api_name,1,26),

Line 1292: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1288: raise OKC_API.G_EXCEPTION_ERROR;
1289: END IF;
1290: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1291: EXCEPTION
1292: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1293: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1294: (substr(l_api_name,1,26),
1295: G_PKG_NAME,
1296: 'OKC_API.G_RET_STS_ERROR',

Line 1293: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1289: END IF;
1290: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1291: EXCEPTION
1292: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1293: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1294: (substr(l_api_name,1,26),
1295: G_PKG_NAME,
1296: 'OKC_API.G_RET_STS_ERROR',
1297: x_msg_count,

Line 1296: 'OKC_API.G_RET_STS_ERROR',

1292: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1293: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1294: (substr(l_api_name,1,26),
1295: G_PKG_NAME,
1296: 'OKC_API.G_RET_STS_ERROR',
1297: x_msg_count,
1298: x_msg_data,
1299: '_PUB');
1300: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1300: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1296: 'OKC_API.G_RET_STS_ERROR',
1297: x_msg_count,
1298: x_msg_data,
1299: '_PUB');
1300: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1301: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1302: (substr(l_api_name,1,26),
1303: G_PKG_NAME,
1304: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1301: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1297: x_msg_count,
1298: x_msg_data,
1299: '_PUB');
1300: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1301: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1302: (substr(l_api_name,1,26),
1303: G_PKG_NAME,
1304: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1305: x_msg_count,

Line 1304: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1300: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1301: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1302: (substr(l_api_name,1,26),
1303: G_PKG_NAME,
1304: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1305: x_msg_count,
1306: x_msg_data,
1307: '_PUB');
1308: WHEN OTHERS THEN

Line 1309: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1305: x_msg_count,
1306: x_msg_data,
1307: '_PUB');
1308: WHEN OTHERS THEN
1309: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1310: (substr(l_api_name,1,26),
1311: G_PKG_NAME,
1312: 'OTHERS',
1313: x_msg_count,

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

1329: x_msg_count OUT NOCOPY NUMBER,
1330: x_msg_data OUT NOCOPY VARCHAR2,
1331: p_cplv_tbl IN cplv_tbl_type) is
1332: i NUMBER;
1333: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1334: begin
1335: OKC_API.init_msg_list(p_init_msg_list);
1336: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
1337: if (p_cplv_tbl.COUNT>0) then

Line 1335: OKC_API.init_msg_list(p_init_msg_list);

1331: p_cplv_tbl IN cplv_tbl_type) is
1332: i NUMBER;
1333: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1334: begin
1335: OKC_API.init_msg_list(p_init_msg_list);
1336: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
1337: if (p_cplv_tbl.COUNT>0) then
1338: i := p_cplv_tbl.FIRST;
1339: LOOP

Line 1336: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

1332: i NUMBER;
1333: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1334: begin
1335: OKC_API.init_msg_list(p_init_msg_list);
1336: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
1337: if (p_cplv_tbl.COUNT>0) then
1338: i := p_cplv_tbl.FIRST;
1339: LOOP
1340: validate_k_party_role(p_api_version=>p_api_version,

Line 1341: p_init_msg_list=>OKC_API.G_FALSE,

1337: if (p_cplv_tbl.COUNT>0) then
1338: i := p_cplv_tbl.FIRST;
1339: LOOP
1340: validate_k_party_role(p_api_version=>p_api_version,
1341: p_init_msg_list=>OKC_API.G_FALSE,
1342: x_return_status=>l_return_status,
1343: x_msg_count=>x_msg_count,
1344: x_msg_data=>x_msg_data,
1345: p_cplv_rec=>p_cplv_tbl(i));

Line 1346: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1342: x_return_status=>l_return_status,
1343: x_msg_count=>x_msg_count,
1344: x_msg_data=>x_msg_data,
1345: p_cplv_rec=>p_cplv_tbl(i));
1346: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1347: x_return_status := l_return_status;
1348: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1349: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1350: x_return_status := l_return_status;

Line 1348: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1344: x_msg_data=>x_msg_data,
1345: p_cplv_rec=>p_cplv_tbl(i));
1346: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1347: x_return_status := l_return_status;
1348: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1349: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1350: x_return_status := l_return_status;
1351: end if;
1352: EXIT WHEN (i=p_cplv_tbl.LAST);

Line 1349: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

1345: p_cplv_rec=>p_cplv_tbl(i));
1346: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1347: x_return_status := l_return_status;
1348: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1349: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1350: x_return_status := l_return_status;
1351: end if;
1352: EXIT WHEN (i=p_cplv_tbl.LAST);
1353: i := p_cplv_tbl.NEXT(i);