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

Line 24: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;

20: p_extend_in_parameters_tbl IN extend_in_parameters_tbl,
21: p_do_commit IN VARCHAR2
22: )is
23:
24: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
25:
26: BEGIN
27:
28: OKC_API.init_msg_list(p_init_msg_list);

Line 28: OKC_API.init_msg_list(p_init_msg_list);

24: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
25:
26: BEGIN
27:
28: OKC_API.init_msg_list(p_init_msg_list);
29:
30: x_return_status := OKC_API.G_RET_STS_SUCCESS;
31:
32: FOR i in p_extend_in_parameters_tbl.first..p_extend_in_parameters_tbl.last LOOP

Line 30: x_return_status := OKC_API.G_RET_STS_SUCCESS;

26: BEGIN
27:
28: OKC_API.init_msg_list(p_init_msg_list);
29:
30: x_return_status := OKC_API.G_RET_STS_SUCCESS;
31:
32: FOR i in p_extend_in_parameters_tbl.first..p_extend_in_parameters_tbl.last LOOP
33:
34:

Line 38: p_init_msg_list => OKC_API.G_FALSE,

34:
35: if p_extend_in_parameters_tbl.exists(i) then
36:
37: OKC_EXTEND_PUB.extend_chr(p_api_version => 1,
38: p_init_msg_list => OKC_API.G_FALSE,
39: x_return_status => l_return_status,
40: x_msg_count => x_msg_count,
41: x_msg_data => x_msg_data,
42: p_extend_in_parameters_rec => p_extend_in_parameters_tbl(i),

Line 46: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

42: p_extend_in_parameters_rec => p_extend_in_parameters_tbl(i),
43: p_do_commit => p_do_commit);
44:
45:
46: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
47: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
48: x_return_status := l_return_status;
49: raise G_EXCEPTION_HALT_VALIDATION;
50: ELSE

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

43: p_do_commit => p_do_commit);
44:
45:
46: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
47: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
48: x_return_status := l_return_status;
49: raise G_EXCEPTION_HALT_VALIDATION;
50: ELSE
51: x_return_status := l_return_status;

Line 61: IF P_DO_COMMIT = OKC_API.G_TRUE THEN

57: -- Bug 3658108
58: OKC_CVM_PVT.clear_g_transaction_id;
59:
60: END LOOP;
61: IF P_DO_COMMIT = OKC_API.G_TRUE THEN
62: COMMIT;
63: END IF;
64: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
65:

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

60: END LOOP;
61: IF P_DO_COMMIT = OKC_API.G_TRUE THEN
62: COMMIT;
63: END IF;
64: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
65:
66: EXCEPTION
67: WHEN G_EXCEPTION_HALT_VALIDATION THEN
68: NULL;

Line 70: OKC_API.set_message(p_app_name => g_app_name,

66: EXCEPTION
67: WHEN G_EXCEPTION_HALT_VALIDATION THEN
68: NULL;
69: WHEN OTHERS THEN
70: OKC_API.set_message(p_app_name => g_app_name,
71: p_msg_name => g_unexpected_error,
72: p_token1 => g_sqlcode_token,
73: p_token1_value => sqlcode,
74: p_token2 => g_sqlerrm_token,

Line 76: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

72: p_token1 => g_sqlcode_token,
73: p_token1_value => sqlcode,
74: p_token2 => g_sqlerrm_token,
75: p_token2_value => sqlerrm);
76: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
77: END;
78:
79: PROCEDURE extend_chr( p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 ,

Line 88: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;

84: p_extend_in_parameters_rec IN extend_in_parameters_rec,
85: p_do_commit IN VARCHAR2
86: ) is
87:
88: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
89: l_extend_in_parameters_rec extend_in_parameters_rec := p_extend_in_parameters_rec;
90: l_api_name constant varchar2(30) := 'extend_chr';
91: l_chr_id number;
92: BEGIN

Line 94: x_return_status := OKC_API.G_RET_STS_SUCCESS;

90: l_api_name constant varchar2(30) := 'extend_chr';
91: l_chr_id number;
92: BEGIN
93:
94: x_return_status := OKC_API.G_RET_STS_SUCCESS;
95:
96: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
97: p_init_msg_list,
98: '_PUB',

Line 96: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

92: BEGIN
93:
94: x_return_status := OKC_API.G_RET_STS_SUCCESS;
95:
96: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
97: p_init_msg_list,
98: '_PUB',
99: x_return_status);
100:

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

97: p_init_msg_list,
98: '_PUB',
99: x_return_status);
100:
101: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
102: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
103: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
104: raise OKC_API.G_EXCEPTION_ERROR;
105: END IF;

Line 102: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

98: '_PUB',
99: x_return_status);
100:
101: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
102: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
103: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
104: raise OKC_API.G_EXCEPTION_ERROR;
105: END IF;
106:

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

99: x_return_status);
100:
101: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
102: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
103: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
104: raise OKC_API.G_EXCEPTION_ERROR;
105: END IF;
106:
107: -- Call user hook FOR BEFORE

Line 104: raise OKC_API.G_EXCEPTION_ERROR;

100:
101: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
102: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
103: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
104: raise OKC_API.G_EXCEPTION_ERROR;
105: END IF;
106:
107: -- Call user hook FOR BEFORE
108: g_extend_in_parameters_rec := l_extend_in_parameters_rec;

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

108: g_extend_in_parameters_rec := l_extend_in_parameters_rec;
109:
110: OKC_UTIL.call_user_hook(l_return_status, g_pkg_name, l_api_name, 'B');
111:
112: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
113: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
114: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
115: raise OKC_API.G_EXCEPTION_ERROR;
116: END IF;

Line 113: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

109:
110: OKC_UTIL.call_user_hook(l_return_status, g_pkg_name, l_api_name, 'B');
111:
112: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
113: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
114: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
115: raise OKC_API.G_EXCEPTION_ERROR;
116: END IF;
117:

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

110: OKC_UTIL.call_user_hook(l_return_status, g_pkg_name, l_api_name, 'B');
111:
112: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
113: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
114: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
115: raise OKC_API.G_EXCEPTION_ERROR;
116: END IF;
117:
118: l_extend_in_parameters_rec := g_extend_in_parameters_rec;

Line 115: raise OKC_API.G_EXCEPTION_ERROR;

111:
112: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
113: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
114: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
115: raise OKC_API.G_EXCEPTION_ERROR;
116: END IF;
117:
118: l_extend_in_parameters_rec := g_extend_in_parameters_rec;
119: l_extend_in_parameters_rec.p_contract_id := p_extend_in_parameters_rec.p_contract_id;

Line 123: p_init_msg_list => OKC_API.G_FALSE,

119: l_extend_in_parameters_rec.p_contract_id := p_extend_in_parameters_rec.p_contract_id;
120:
121:
122: OKC_EXTEND_PVT.extend_chr(p_api_version => 1,
123: p_init_msg_list => OKC_API.G_FALSE,
124: x_return_status => l_return_status,
125: x_msg_count => x_msg_count,
126: x_msg_data => x_msg_data,
127: p_extend_in_parameters_rec => l_extend_in_parameters_rec );

Line 130: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

126: x_msg_data => x_msg_data,
127: p_extend_in_parameters_rec => l_extend_in_parameters_rec );
128:
129:
130: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
131: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
132: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
133: RAISE OKC_API.G_EXCEPTION_ERROR;
134: END IF;

Line 131: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

127: p_extend_in_parameters_rec => l_extend_in_parameters_rec );
128:
129:
130: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
131: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
132: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
133: RAISE OKC_API.G_EXCEPTION_ERROR;
134: END IF;
135:

Line 132: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

128:
129:
130: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
131: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
132: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
133: RAISE OKC_API.G_EXCEPTION_ERROR;
134: END IF;
135:
136:

Line 133: RAISE OKC_API.G_EXCEPTION_ERROR;

129:
130: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
131: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
132: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
133: RAISE OKC_API.G_EXCEPTION_ERROR;
134: END IF;
135:
136:
137: OKC_UTIL.call_user_hook(l_return_status, g_pkg_name, l_api_name, 'A');

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

135:
136:
137: OKC_UTIL.call_user_hook(l_return_status, g_pkg_name, l_api_name, 'A');
138:
139: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
140: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
141: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
142: raise OKC_API.G_EXCEPTION_ERROR;
143: END IF;

Line 140: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

136:
137: OKC_UTIL.call_user_hook(l_return_status, g_pkg_name, l_api_name, 'A');
138:
139: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
140: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
141: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
142: raise OKC_API.G_EXCEPTION_ERROR;
143: END IF;
144:

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

137: OKC_UTIL.call_user_hook(l_return_status, g_pkg_name, l_api_name, 'A');
138:
139: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
140: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
141: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
142: raise OKC_API.G_EXCEPTION_ERROR;
143: END IF;
144:
145: IF P_DO_COMMIT = OKC_API.G_TRUE THEN

Line 142: raise OKC_API.G_EXCEPTION_ERROR;

138:
139: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
140: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
141: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
142: raise OKC_API.G_EXCEPTION_ERROR;
143: END IF;
144:
145: IF P_DO_COMMIT = OKC_API.G_TRUE THEN
146: COMMIT;

Line 145: IF P_DO_COMMIT = OKC_API.G_TRUE THEN

141: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
142: raise OKC_API.G_EXCEPTION_ERROR;
143: END IF;
144:
145: IF P_DO_COMMIT = OKC_API.G_TRUE THEN
146: COMMIT;
147: END IF;
148:
149: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

145: IF P_DO_COMMIT = OKC_API.G_TRUE THEN
146: COMMIT;
147: END IF;
148:
149: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
150:
151: EXCEPTION
152: WHEN OKC_API.G_EXCEPTION_ERROR THEN
153: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 152: WHEN OKC_API.G_EXCEPTION_ERROR THEN

148:
149: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
150:
151: EXCEPTION
152: WHEN OKC_API.G_EXCEPTION_ERROR THEN
153: x_return_status := OKC_API.HANDLE_EXCEPTIONS
154: (l_api_name,
155: G_PKG_NAME,
156: 'OKC_API.G_RET_STS_ERROR',

Line 153: x_return_status := OKC_API.HANDLE_EXCEPTIONS

149: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
150:
151: EXCEPTION
152: WHEN OKC_API.G_EXCEPTION_ERROR THEN
153: x_return_status := OKC_API.HANDLE_EXCEPTIONS
154: (l_api_name,
155: G_PKG_NAME,
156: 'OKC_API.G_RET_STS_ERROR',
157: x_msg_count,

Line 156: 'OKC_API.G_RET_STS_ERROR',

152: WHEN OKC_API.G_EXCEPTION_ERROR THEN
153: x_return_status := OKC_API.HANDLE_EXCEPTIONS
154: (l_api_name,
155: G_PKG_NAME,
156: 'OKC_API.G_RET_STS_ERROR',
157: x_msg_count,
158: x_msg_data,
159: '_PUB');
160: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 160: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

156: 'OKC_API.G_RET_STS_ERROR',
157: x_msg_count,
158: x_msg_data,
159: '_PUB');
160: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
161:
162: x_return_status := OKC_API.HANDLE_EXCEPTIONS
163: (l_api_name,
164: G_PKG_NAME,

Line 162: x_return_status := OKC_API.HANDLE_EXCEPTIONS

158: x_msg_data,
159: '_PUB');
160: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
161:
162: x_return_status := OKC_API.HANDLE_EXCEPTIONS
163: (l_api_name,
164: G_PKG_NAME,
165: 'OKC_API.G_RET_STS_UNEXP_ERROR',
166: x_msg_count,

Line 165: 'OKC_API.G_RET_STS_UNEXP_ERROR',

161:
162: x_return_status := OKC_API.HANDLE_EXCEPTIONS
163: (l_api_name,
164: G_PKG_NAME,
165: 'OKC_API.G_RET_STS_UNEXP_ERROR',
166: x_msg_count,
167: x_msg_data,
168: '_PUB');
169: WHEN OTHERS THEN

Line 170: x_return_status := OKC_API.HANDLE_EXCEPTIONS

166: x_msg_count,
167: x_msg_data,
168: '_PUB');
169: WHEN OTHERS THEN
170: x_return_status := OKC_API.HANDLE_EXCEPTIONS
171: (l_api_name,
172: G_PKG_NAME,
173: 'OTHERS',
174: x_msg_count,

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

182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_extend_in_parameters_tbl IN extend_in_parameters_tbl ) is
185:
186: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
187:
188: BEGIN
189:
190: OKC_API.init_msg_list(p_init_msg_list);

Line 190: OKC_API.init_msg_list(p_init_msg_list);

186: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
187:
188: BEGIN
189:
190: OKC_API.init_msg_list(p_init_msg_list);
191:
192: x_return_status := OKC_API.G_RET_STS_SUCCESS;
193:
194: FOR i in p_extend_in_parameters_tbl.first..p_extend_in_parameters_tbl.last

Line 192: x_return_status := OKC_API.G_RET_STS_SUCCESS;

188: BEGIN
189:
190: OKC_API.init_msg_list(p_init_msg_list);
191:
192: x_return_status := OKC_API.G_RET_STS_SUCCESS;
193:
194: FOR i in p_extend_in_parameters_tbl.first..p_extend_in_parameters_tbl.last
195: LOOP
196:

Line 200: p_init_msg_list => OKC_API.G_FALSE,

196:
197: IF p_extend_in_parameters_tbl.exists(i) THEN
198:
199: OKC_EXTEND_PVT.validate_chr(p_api_version => p_api_version,
200: p_init_msg_list => OKC_API.G_FALSE,
201: x_return_status => l_return_status,
202: x_msg_count => x_msg_count,
203: x_msg_data => x_msg_data,
204: p_extend_in_parameters_rec => p_extend_in_parameters_tbl(i) );

Line 206: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

202: x_msg_count => x_msg_count,
203: x_msg_data => x_msg_data,
204: p_extend_in_parameters_rec => p_extend_in_parameters_tbl(i) );
205:
206: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
207: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
208: x_return_status := l_return_status;
209: raise G_EXCEPTION_HALT_VALIDATION;
210: ELSE

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

203: x_msg_data => x_msg_data,
204: p_extend_in_parameters_rec => p_extend_in_parameters_tbl(i) );
205:
206: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
207: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
208: x_return_status := l_return_status;
209: raise G_EXCEPTION_HALT_VALIDATION;
210: ELSE
211: x_return_status := l_return_status;

Line 221: OKC_API.set_message(p_app_name => g_app_name,

217: EXCEPTION
218: WHEN G_EXCEPTION_HALT_VALIDATION THEN
219: NULL;
220: WHEN OTHERS THEN
221: OKC_API.set_message(p_app_name => g_app_name,
222: p_msg_name => g_unexpected_error,
223: p_token1 => g_sqlcode_token,
224: p_token1_value => sqlcode,
225: p_token2 => g_sqlerrm_token,

Line 227: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

223: p_token1 => g_sqlcode_token,
224: p_token1_value => sqlcode,
225: p_token2 => g_sqlerrm_token,
226: p_token2_value => sqlerrm);
227: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
228: end;
229:
230:
231: PROCEDURE VALIDATE_CHR( p_api_version IN NUMBER,

Line 240: p_init_msg_list => OKC_API.G_FALSE,

236: p_extend_in_parameters_rec IN extend_in_parameters_rec ) is
237: BEGIN
238:
239: OKC_EXTEND_PVT.validate_chr(p_api_version => p_api_version,
240: p_init_msg_list => OKC_API.G_FALSE,
241: x_return_status => x_return_status,
242: x_msg_count => x_msg_count,
243: x_msg_data => x_msg_data,
244: p_extend_in_parameters_rec => p_extend_in_parameters_rec );

Line 248: OKC_API.set_message(p_app_name => g_app_name,

244: p_extend_in_parameters_rec => p_extend_in_parameters_rec );
245:
246: EXCEPTION
247: WHEN OTHERS THEN
248: OKC_API.set_message(p_app_name => g_app_name,
249: p_msg_name => g_unexpected_error,
250: p_token1 => g_sqlcode_token,
251: p_token1_value => sqlcode,
252: p_token2 => g_sqlerrm_token,

Line 255: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

251: p_token1_value => sqlcode,
252: p_token2 => g_sqlerrm_token,
253: p_token2_value => sqlerrm);
254:
255: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
256: end;
257:
258: PROCEDURE extend_cle(p_api_version IN NUMBER,
259: p_init_msg_list IN VARCHAR2 ,

Line 267: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;

263: p_extend_in_parameters_tbl IN extend_in_cle_tbl,
264: p_do_commit IN VARCHAR2
265: ) IS
266:
267: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
268: rec_count number := 0;
269: p_end_date_latest date;
270: l_extend_in_parameters_rec okc_extend_pub.extend_in_parameters_rec;
271: l_api_name constant varchar2(30) := 'extend_cle_tbl';

Line 296: okc_api.init_msg_list(p_init_msg_list);

292: WHERE code = p_sts_code;
293:
294: BEGIN
295:
296: okc_api.init_msg_list(p_init_msg_list);
297:
298: x_return_status := OKC_API.G_RET_STS_SUCCESS;
299:
300: l_return_status := OKC_API.START_ACTIVITY( l_api_name,

Line 298: x_return_status := OKC_API.G_RET_STS_SUCCESS;

294: BEGIN
295:
296: okc_api.init_msg_list(p_init_msg_list);
297:
298: x_return_status := OKC_API.G_RET_STS_SUCCESS;
299:
300: l_return_status := OKC_API.START_ACTIVITY( l_api_name,
301: p_init_msg_list,
302: '_PUB',

Line 300: l_return_status := OKC_API.START_ACTIVITY( l_api_name,

296: okc_api.init_msg_list(p_init_msg_list);
297:
298: x_return_status := OKC_API.G_RET_STS_SUCCESS;
299:
300: l_return_status := OKC_API.START_ACTIVITY( l_api_name,
301: p_init_msg_list,
302: '_PUB',
303: x_return_status);
304:

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

301: p_init_msg_list,
302: '_PUB',
303: x_return_status);
304:
305: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
306: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
307: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
308: raise OKC_API.G_EXCEPTION_ERROR;
309: END IF;

Line 306: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

302: '_PUB',
303: x_return_status);
304:
305: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
306: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
307: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
308: raise OKC_API.G_EXCEPTION_ERROR;
309: END IF;
310:

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

303: x_return_status);
304:
305: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
306: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
307: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
308: raise OKC_API.G_EXCEPTION_ERROR;
309: END IF;
310:
311: OPEN cur_hdr_enddate(p_extend_in_parameters_tbl(1).p_cle_id);

Line 308: raise OKC_API.G_EXCEPTION_ERROR;

304:
305: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
306: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
307: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
308: raise OKC_API.G_EXCEPTION_ERROR;
309: END IF;
310:
311: OPEN cur_hdr_enddate(p_extend_in_parameters_tbl(1).p_cle_id);
312: FETCH cur_hdr_enddate into l_extend_in_parameters_rec.p_contract_id,p_hdr_end_date,l_extend_in_parameters_rec.p_object_version_number,l_extend_in_parameters_rec.p_contract_number,l_extend_in_parameters_rec.p_contract_modifier, l_sts_code;

Line 318: If p_extend_in_parameters_tbl(i).p_perpetual_flag = OKC_API.G_TRUE Then

314:
315: FOR i in p_extend_in_parameters_tbl.first..p_extend_in_parameters_tbl.last LOOP
316:
317: -- If the lines are perpetual, set the end date for contract to null
318: If p_extend_in_parameters_tbl(i).p_perpetual_flag = OKC_API.G_TRUE Then
319: p_end_date_latest := Null;
320: Exit;
321: End If;
322:

Line 354: l_extend_in_parameters_rec.p_perpetual_flag := OKC_API.G_TRUE;

350: l_extend_in_parameters_rec.p_end_date := p_end_date_latest;
351:
352: -- Make the contract perpetual if line is perpetual
353: If p_end_date_latest Is Null Then
354: l_extend_in_parameters_rec.p_perpetual_flag := OKC_API.G_TRUE;
355: Else
356: l_extend_in_parameters_rec.p_perpetual_flag := OKC_API.G_FALSE;
357: End If;
358:

Line 356: l_extend_in_parameters_rec.p_perpetual_flag := OKC_API.G_FALSE;

352: -- Make the contract perpetual if line is perpetual
353: If p_end_date_latest Is Null Then
354: l_extend_in_parameters_rec.p_perpetual_flag := OKC_API.G_TRUE;
355: Else
356: l_extend_in_parameters_rec.p_perpetual_flag := OKC_API.G_FALSE;
357: End If;
358:
359: l_chr_rec.id := l_extend_in_parameters_rec.p_contract_id;
360: l_chr_rec.object_version_number := l_extend_in_parameters_rec.p_object_version_number;

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

370: OKC_ASSENT_PUB.get_default_status( x_return_status => l_return_status,
371: p_status_type => 'ACTIVE',
372: x_status_code => l_status_code );
373:
374: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
375: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
376: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
377: raise OKC_API.G_EXCEPTION_ERROR;
378: END IF;

Line 375: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

371: p_status_type => 'ACTIVE',
372: x_status_code => l_status_code );
373:
374: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
375: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
376: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
377: raise OKC_API.G_EXCEPTION_ERROR;
378: END IF;
379: l_chr_rec.sts_code := l_status_code;

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

372: x_status_code => l_status_code );
373:
374: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
375: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
376: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
377: raise OKC_API.G_EXCEPTION_ERROR;
378: END IF;
379: l_chr_rec.sts_code := l_status_code;
380: l_chr_rec.old_sts_code := 'EXPIRED';

Line 377: raise OKC_API.G_EXCEPTION_ERROR;

373:
374: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
375: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
376: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
377: raise OKC_API.G_EXCEPTION_ERROR;
378: END IF;
379: l_chr_rec.sts_code := l_status_code;
380: l_chr_rec.old_sts_code := 'EXPIRED';
381: l_chr_rec.old_ste_code := 'EXPIRED';

Line 387: p_init_msg_list => OKC_API.G_FALSE,

383: l_chr_rec.new_ste_code := 'ACTIVE';
384: END IF;
385: END IF;
386: OKC_CONTRACT_PUB.update_contract_header ( p_api_version => 1,
387: p_init_msg_list => OKC_API.G_FALSE,
388: x_return_status => l_return_status,
389: x_msg_count => x_msg_count,
390: x_msg_data => x_msg_data,
391: p_restricted_update => okc_api.g_true,

Line 391: p_restricted_update => okc_api.g_true,

387: p_init_msg_list => OKC_API.G_FALSE,
388: x_return_status => l_return_status,
389: x_msg_count => x_msg_count,
390: x_msg_data => x_msg_data,
391: p_restricted_update => okc_api.g_true,
392: p_chrv_rec => l_chr_rec,
393: x_chrv_rec => i_chr_rec );
394:
395: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

Line 395: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

391: p_restricted_update => okc_api.g_true,
392: p_chrv_rec => l_chr_rec,
393: x_chrv_rec => i_chr_rec );
394:
395: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
396: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
397: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
398: RAISE OKC_API.G_EXCEPTION_ERROR;
399: END IF;

Line 396: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

392: p_chrv_rec => l_chr_rec,
393: x_chrv_rec => i_chr_rec );
394:
395: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
396: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
397: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
398: RAISE OKC_API.G_EXCEPTION_ERROR;
399: END IF;
400:

Line 397: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

393: x_chrv_rec => i_chr_rec );
394:
395: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
396: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
397: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
398: RAISE OKC_API.G_EXCEPTION_ERROR;
399: END IF;
400:
401: OKC_EXTEND_PUB.extend_chr(p_api_version => 1,

Line 398: RAISE OKC_API.G_EXCEPTION_ERROR;

394:
395: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
396: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
397: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
398: RAISE OKC_API.G_EXCEPTION_ERROR;
399: END IF;
400:
401: OKC_EXTEND_PUB.extend_chr(p_api_version => 1,
402: p_init_msg_list => OKC_API.G_FALSE,

Line 402: p_init_msg_list => OKC_API.G_FALSE,

398: RAISE OKC_API.G_EXCEPTION_ERROR;
399: END IF;
400:
401: OKC_EXTEND_PUB.extend_chr(p_api_version => 1,
402: p_init_msg_list => OKC_API.G_FALSE,
403: x_return_status => l_return_status,
404: x_msg_count => x_msg_count,
405: x_msg_data => x_msg_data,
406: p_extend_in_parameters_rec => l_extend_in_parameters_rec );

Line 410: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

406: p_extend_in_parameters_rec => l_extend_in_parameters_rec );
407:
408: OKC_EXTEND_PVT.g_called_from := 'HEADER';
409:
410: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
411: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
412: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
413: RAISE OKC_API.G_EXCEPTION_ERROR;
414: END IF;

Line 411: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

407:
408: OKC_EXTEND_PVT.g_called_from := 'HEADER';
409:
410: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
411: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
412: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
413: RAISE OKC_API.G_EXCEPTION_ERROR;
414: END IF;
415:

Line 412: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

408: OKC_EXTEND_PVT.g_called_from := 'HEADER';
409:
410: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
411: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
412: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
413: RAISE OKC_API.G_EXCEPTION_ERROR;
414: END IF;
415:
416: END IF;

Line 413: RAISE OKC_API.G_EXCEPTION_ERROR;

409:
410: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
411: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
412: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
413: RAISE OKC_API.G_EXCEPTION_ERROR;
414: END IF;
415:
416: END IF;
417:

Line 429: p_init_msg_list => OKC_API.G_FALSE,

425:
426: IF p_extend_in_parameters_tbl.exists(i) then
427:
428: OKC_EXTEND_PUB.extend_cle(p_api_version => p_api_version,
429: p_init_msg_list => OKC_API.G_FALSE,
430: x_return_status => l_return_status,
431: x_msg_count => x_msg_count,
432: x_msg_data => x_msg_data,
433: p_extend_in_parameters_rec => p_extend_in_parameters_tbl(i));

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

431: x_msg_count => x_msg_count,
432: x_msg_data => x_msg_data,
433: p_extend_in_parameters_rec => p_extend_in_parameters_tbl(i));
434:
435: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
436: RAISE OKC_API.g_exception_unexpected_error;
437: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
438: raise OKC_API.g_exception_error;
439: END IF;

Line 436: RAISE OKC_API.g_exception_unexpected_error;

432: x_msg_data => x_msg_data,
433: p_extend_in_parameters_rec => p_extend_in_parameters_tbl(i));
434:
435: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
436: RAISE OKC_API.g_exception_unexpected_error;
437: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
438: raise OKC_API.g_exception_error;
439: END IF;
440:

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

433: p_extend_in_parameters_rec => p_extend_in_parameters_tbl(i));
434:
435: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
436: RAISE OKC_API.g_exception_unexpected_error;
437: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
438: raise OKC_API.g_exception_error;
439: END IF;
440:
441: END IF; -- if exists

Line 438: raise OKC_API.g_exception_error;

434:
435: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
436: RAISE OKC_API.g_exception_unexpected_error;
437: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
438: raise OKC_API.g_exception_error;
439: END IF;
440:
441: END IF; -- if exists
442:

Line 444: IF p_do_commit = okc_api.g_true then

440:
441: END IF; -- if exists
442:
443: END LOOP;
444: IF p_do_commit = okc_api.g_true then
445: COMMIT;
446: END IF;
447: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
448: EXCEPTION

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

443: END LOOP;
444: IF p_do_commit = okc_api.g_true then
445: COMMIT;
446: END IF;
447: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
448: EXCEPTION
449: WHEN OKC_API.G_EXCEPTION_ERROR THEN
450: x_return_status := OKC_API.HANDLE_EXCEPTIONS
451: (l_api_name,

Line 449: WHEN OKC_API.G_EXCEPTION_ERROR THEN

445: COMMIT;
446: END IF;
447: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
448: EXCEPTION
449: WHEN OKC_API.G_EXCEPTION_ERROR THEN
450: x_return_status := OKC_API.HANDLE_EXCEPTIONS
451: (l_api_name,
452: G_PKG_NAME,
453: 'OKC_API.G_RET_STS_ERROR',

Line 450: x_return_status := OKC_API.HANDLE_EXCEPTIONS

446: END IF;
447: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
448: EXCEPTION
449: WHEN OKC_API.G_EXCEPTION_ERROR THEN
450: x_return_status := OKC_API.HANDLE_EXCEPTIONS
451: (l_api_name,
452: G_PKG_NAME,
453: 'OKC_API.G_RET_STS_ERROR',
454: x_msg_count,

Line 453: 'OKC_API.G_RET_STS_ERROR',

449: WHEN OKC_API.G_EXCEPTION_ERROR THEN
450: x_return_status := OKC_API.HANDLE_EXCEPTIONS
451: (l_api_name,
452: G_PKG_NAME,
453: 'OKC_API.G_RET_STS_ERROR',
454: x_msg_count,
455: x_msg_data,
456: '_PUB');
457: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 457: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

453: 'OKC_API.G_RET_STS_ERROR',
454: x_msg_count,
455: x_msg_data,
456: '_PUB');
457: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
458: x_return_status := OKC_API.HANDLE_EXCEPTIONS
459: (l_api_name,
460: G_PKG_NAME,
461: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 458: x_return_status := OKC_API.HANDLE_EXCEPTIONS

454: x_msg_count,
455: x_msg_data,
456: '_PUB');
457: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
458: x_return_status := OKC_API.HANDLE_EXCEPTIONS
459: (l_api_name,
460: G_PKG_NAME,
461: 'OKC_API.G_RET_STS_UNEXP_ERROR',
462: x_msg_count,

Line 461: 'OKC_API.G_RET_STS_UNEXP_ERROR',

457: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
458: x_return_status := OKC_API.HANDLE_EXCEPTIONS
459: (l_api_name,
460: G_PKG_NAME,
461: 'OKC_API.G_RET_STS_UNEXP_ERROR',
462: x_msg_count,
463: x_msg_data,
464: '_PUB');
465: WHEN OTHERS THEN

Line 466: x_return_status := OKC_API.HANDLE_EXCEPTIONS

462: x_msg_count,
463: x_msg_data,
464: '_PUB');
465: WHEN OTHERS THEN
466: x_return_status := OKC_API.HANDLE_EXCEPTIONS
467: (l_api_name,
468: G_PKG_NAME,
469: 'OTHERS',
470: x_msg_count,

Line 484: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;

480: p_extend_in_parameters_rec IN extend_in_cle_rec,
481: p_do_commit IN VARCHAR2
482: ) is
483:
484: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
485: l_extend_in_parameters_rec extend_in_cle_rec := p_extend_in_parameters_rec;
486: l_api_name constant varchar2(30) := 'extend_cle';
487: l_chr_id number;
488:

Line 491: x_return_status := OKC_API.G_RET_STS_SUCCESS;

487: l_chr_id number;
488:
489: BEGIN
490:
491: x_return_status := OKC_API.G_RET_STS_SUCCESS;
492:
493: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
494: p_init_msg_list,
495: '_PUB',

Line 493: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

489: BEGIN
490:
491: x_return_status := OKC_API.G_RET_STS_SUCCESS;
492:
493: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
494: p_init_msg_list,
495: '_PUB',
496: x_return_status);
497:

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

494: p_init_msg_list,
495: '_PUB',
496: x_return_status);
497:
498: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
499: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
500: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
501: raise OKC_API.G_EXCEPTION_ERROR;
502: END IF;

Line 499: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

495: '_PUB',
496: x_return_status);
497:
498: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
499: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
500: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
501: raise OKC_API.G_EXCEPTION_ERROR;
502: END IF;
503:

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

496: x_return_status);
497:
498: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
499: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
500: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
501: raise OKC_API.G_EXCEPTION_ERROR;
502: END IF;
503:
504: -- Call user hook FOR BEFORE

Line 501: raise OKC_API.G_EXCEPTION_ERROR;

497:
498: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
499: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
500: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
501: raise OKC_API.G_EXCEPTION_ERROR;
502: END IF;
503:
504: -- Call user hook FOR BEFORE
505: g_extend_in_cle_rec := l_extend_in_parameters_rec;

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

505: g_extend_in_cle_rec := l_extend_in_parameters_rec;
506:
507: OKC_UTIL.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
508:
509: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
510: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
511: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
512: raise OKC_API.G_EXCEPTION_ERROR;
513: END IF;

Line 510: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

506:
507: OKC_UTIL.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
508:
509: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
510: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
511: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
512: raise OKC_API.G_EXCEPTION_ERROR;
513: END IF;
514:

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

507: OKC_UTIL.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
508:
509: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
510: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
511: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
512: raise OKC_API.G_EXCEPTION_ERROR;
513: END IF;
514:
515: l_extend_in_parameters_rec := g_extend_in_cle_rec;

Line 512: raise OKC_API.G_EXCEPTION_ERROR;

508:
509: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
510: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
511: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
512: raise OKC_API.G_EXCEPTION_ERROR;
513: END IF;
514:
515: l_extend_in_parameters_rec := g_extend_in_cle_rec;
516: l_extend_in_parameters_rec.p_cle_id := p_extend_in_parameters_rec.p_cle_id;

Line 519: p_init_msg_list => OKC_API.G_FALSE,

515: l_extend_in_parameters_rec := g_extend_in_cle_rec;
516: l_extend_in_parameters_rec.p_cle_id := p_extend_in_parameters_rec.p_cle_id;
517:
518: OKC_EXTEND_PVT.extend_cle(p_api_version => p_api_version,
519: p_init_msg_list => OKC_API.G_FALSE,
520: x_return_status => l_return_status,
521: x_msg_count => x_msg_count,
522: x_msg_data => x_msg_data,
523: p_extend_in_parameters_rec => l_extend_in_parameters_rec );

Line 526: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

522: x_msg_data => x_msg_data,
523: p_extend_in_parameters_rec => l_extend_in_parameters_rec );
524:
525:
526: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
527: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
528: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
529: RAISE OKC_API.G_EXCEPTION_ERROR;
530: END IF;

Line 527: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

523: p_extend_in_parameters_rec => l_extend_in_parameters_rec );
524:
525:
526: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
527: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
528: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
529: RAISE OKC_API.G_EXCEPTION_ERROR;
530: END IF;
531:

Line 528: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

524:
525:
526: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
527: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
528: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
529: RAISE OKC_API.G_EXCEPTION_ERROR;
530: END IF;
531:
532:

Line 529: RAISE OKC_API.G_EXCEPTION_ERROR;

525:
526: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
527: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
528: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
529: RAISE OKC_API.G_EXCEPTION_ERROR;
530: END IF;
531:
532:
533: OKC_UTIL.call_user_hook(l_return_status, g_pkg_name, l_api_name, 'A');

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

531:
532:
533: OKC_UTIL.call_user_hook(l_return_status, g_pkg_name, l_api_name, 'A');
534:
535: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
536: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
537: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
538: raise OKC_API.G_EXCEPTION_ERROR;
539: END IF;

Line 536: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

532:
533: OKC_UTIL.call_user_hook(l_return_status, g_pkg_name, l_api_name, 'A');
534:
535: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
536: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
537: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
538: raise OKC_API.G_EXCEPTION_ERROR;
539: END IF;
540:

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

533: OKC_UTIL.call_user_hook(l_return_status, g_pkg_name, l_api_name, 'A');
534:
535: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
536: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
537: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
538: raise OKC_API.G_EXCEPTION_ERROR;
539: END IF;
540:
541: IF p_do_commit = okc_api.g_true then

Line 538: raise OKC_API.G_EXCEPTION_ERROR;

534:
535: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
536: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
537: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
538: raise OKC_API.G_EXCEPTION_ERROR;
539: END IF;
540:
541: IF p_do_commit = okc_api.g_true then
542: commit;

Line 541: IF p_do_commit = okc_api.g_true then

537: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
538: raise OKC_API.G_EXCEPTION_ERROR;
539: END IF;
540:
541: IF p_do_commit = okc_api.g_true then
542: commit;
543: END IF;
544: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
545:

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

540:
541: IF p_do_commit = okc_api.g_true then
542: commit;
543: END IF;
544: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
545:
546: EXCEPTION
547: WHEN OKC_API.G_EXCEPTION_ERROR THEN
548: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 547: WHEN OKC_API.G_EXCEPTION_ERROR THEN

543: END IF;
544: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
545:
546: EXCEPTION
547: WHEN OKC_API.G_EXCEPTION_ERROR THEN
548: x_return_status := OKC_API.HANDLE_EXCEPTIONS
549: (l_api_name,
550: G_PKG_NAME,
551: 'OKC_API.G_RET_STS_ERROR',

Line 548: x_return_status := OKC_API.HANDLE_EXCEPTIONS

544: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
545:
546: EXCEPTION
547: WHEN OKC_API.G_EXCEPTION_ERROR THEN
548: x_return_status := OKC_API.HANDLE_EXCEPTIONS
549: (l_api_name,
550: G_PKG_NAME,
551: 'OKC_API.G_RET_STS_ERROR',
552: x_msg_count,

Line 551: 'OKC_API.G_RET_STS_ERROR',

547: WHEN OKC_API.G_EXCEPTION_ERROR THEN
548: x_return_status := OKC_API.HANDLE_EXCEPTIONS
549: (l_api_name,
550: G_PKG_NAME,
551: 'OKC_API.G_RET_STS_ERROR',
552: x_msg_count,
553: x_msg_data,
554: '_PUB');
555: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 555: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

551: 'OKC_API.G_RET_STS_ERROR',
552: x_msg_count,
553: x_msg_data,
554: '_PUB');
555: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
556:
557: x_return_status := OKC_API.HANDLE_EXCEPTIONS
558: (l_api_name,
559: G_PKG_NAME,

Line 557: x_return_status := OKC_API.HANDLE_EXCEPTIONS

553: x_msg_data,
554: '_PUB');
555: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
556:
557: x_return_status := OKC_API.HANDLE_EXCEPTIONS
558: (l_api_name,
559: G_PKG_NAME,
560: 'OKC_API.G_RET_STS_UNEXP_ERROR',
561: x_msg_count,

Line 560: 'OKC_API.G_RET_STS_UNEXP_ERROR',

556:
557: x_return_status := OKC_API.HANDLE_EXCEPTIONS
558: (l_api_name,
559: G_PKG_NAME,
560: 'OKC_API.G_RET_STS_UNEXP_ERROR',
561: x_msg_count,
562: x_msg_data,
563: '_PUB');
564: WHEN OTHERS THEN

Line 565: x_return_status := OKC_API.HANDLE_EXCEPTIONS

561: x_msg_count,
562: x_msg_data,
563: '_PUB');
564: WHEN OTHERS THEN
565: x_return_status := OKC_API.HANDLE_EXCEPTIONS
566: (l_api_name,
567: G_PKG_NAME,
568: 'OTHERS',
569: x_msg_count,

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

577: x_msg_count OUT NOCOPY NUMBER,
578: x_msg_data OUT NOCOPY VARCHAR2,
579: p_extend_in_parameters_tbl IN extend_in_cle_tbl) is
580:
581: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
582:
583: BEGIN
584:
585: OKC_API.init_msg_list(p_init_msg_list);

Line 585: OKC_API.init_msg_list(p_init_msg_list);

581: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
582:
583: BEGIN
584:
585: OKC_API.init_msg_list(p_init_msg_list);
586:
587: x_return_status := OKC_API.G_RET_STS_SUCCESS;
588:
589: --san this needs to be set as g_lines_count is a global variable, so if not reset everytime

Line 587: x_return_status := OKC_API.G_RET_STS_SUCCESS;

583: BEGIN
584:
585: OKC_API.init_msg_list(p_init_msg_list);
586:
587: x_return_status := OKC_API.G_RET_STS_SUCCESS;
588:
589: --san this needs to be set as g_lines_count is a global variable, so if not reset everytime
590: -- it keeps value 1 and next time extend is called, it does not go to
591: --validation of hdr even once

Line 599: p_init_msg_list => OKC_API.G_FALSE,

595:
596: IF p_extend_in_parameters_tbl.exists(i) THEN
597:
598: OKC_EXTEND_PUB.validate_cle(p_api_version => p_api_version,
599: p_init_msg_list => OKC_API.G_FALSE,
600: x_return_status => l_return_status,
601: x_msg_count => x_msg_count,
602: x_msg_data => x_msg_data,
603: p_extend_in_parameters_rec => p_extend_in_parameters_tbl(i) );

Line 605: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

601: x_msg_count => x_msg_count,
602: x_msg_data => x_msg_data,
603: p_extend_in_parameters_rec => p_extend_in_parameters_tbl(i) );
604:
605: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
606: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
607: x_return_status := l_return_status;
608: raise G_EXCEPTION_HALT_VALIDATION;
609: ELSE

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

602: x_msg_data => x_msg_data,
603: p_extend_in_parameters_rec => p_extend_in_parameters_tbl(i) );
604:
605: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
606: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
607: x_return_status := l_return_status;
608: raise G_EXCEPTION_HALT_VALIDATION;
609: ELSE
610: x_return_status := l_return_status;

Line 619: OKC_API.set_message(p_app_name => g_app_name,

615: EXCEPTION
616: WHEN G_EXCEPTION_HALT_VALIDATION THEN
617: NULL;
618: WHEN OTHERS THEN
619: OKC_API.set_message(p_app_name => g_app_name,
620: p_msg_name => g_unexpected_error,
621: p_token1 => g_sqlcode_token,
622: p_token1_value => sqlcode,
623: p_token2 => g_sqlerrm_token,

Line 625: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

621: p_token1 => g_sqlcode_token,
622: p_token1_value => sqlcode,
623: p_token2 => g_sqlerrm_token,
624: p_token2_value => sqlerrm);
625: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
626: end;
627:
628:
629: PROCEDURE validate_cle( p_api_version IN NUMBER,

Line 638: p_init_msg_list => OKC_API.G_FALSE,

634: p_extend_in_parameters_rec IN extend_in_cle_rec ) is
635: BEGIN
636:
637: OKC_EXTEND_PVT.validate_cle(p_api_version => p_api_version,
638: p_init_msg_list => OKC_API.G_FALSE,
639: x_return_status => x_return_status,
640: x_msg_count => x_msg_count,
641: x_msg_data => x_msg_data,
642: p_extend_in_parameters_rec => p_extend_in_parameters_rec );

Line 646: OKC_API.set_message(p_app_name => g_app_name,

642: p_extend_in_parameters_rec => p_extend_in_parameters_rec );
643:
644: EXCEPTION
645: WHEN OTHERS THEN
646: OKC_API.set_message(p_app_name => g_app_name,
647: p_msg_name => g_unexpected_error,
648: p_token1 => g_sqlcode_token,
649: p_token1_value => sqlcode,
650: p_token2 => g_sqlerrm_token,

Line 653: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

649: p_token1_value => sqlcode,
650: p_token2 => g_sqlerrm_token,
651: p_token2_value => sqlerrm);
652:
653: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
654: end;
655:
656: end OKC_EXTEND_PUB;