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

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

26: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
27: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
28: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
29: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CREATE_PO_FROM_K_PUB';
30: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
31: G_APP_NAME1 CONSTANT VARCHAR2(3) := 'OKC';
32:
33: G_API_TYPE CONSTANT VARCHAR2(30) := '_PROCESS';
34: G_SCOPE CONSTANT VARCHAR2(4) := '_PVT';

Line 56: lx_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

52: ,p_contract_id IN okc_k_headers_b.ID%TYPE
53: ) IS
54:
55: l_api_version CONSTANT NUMBER := 1;
56: lx_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
57: lx_msg_count NUMBER := 0;
58: lx_msg_data VARCHAR2(2000);
59: lx_po_number VARCHAR2(20);
60: l_k_number VARCHAR2(120);

Line 114: ,p_init_msg_list => OKC_API.G_TRUE

110: -- concurrent program as a child-request
111:
112: -- Call the main routine (overloaded procedure with same name)
113: OKC_CREATE_PO_FROM_K_PUB.create_po_from_k(p_api_version => l_api_version
114: ,p_init_msg_list => OKC_API.G_TRUE
115: ,x_return_status => lx_return_status
116: ,x_msg_count => lx_msg_count
117: ,x_msg_data => lx_msg_data
118: ,p_contract_id => p_contract_id

Line 122: IF lx_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

118: ,p_contract_id => p_contract_id
119: );
120:
121: -- check return status
122: IF lx_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
123: RETCODE := 2;
124: ERRBUF:=lx_msg_data;
125: RETURN;
126: ELSE

Line 140: ,p_init_msg_list => OKC_API.G_TRUE

136: THEN
137:
138: OKC_CREATE_PO_FROM_K_PVT.tieback_related_objs_from_po(
139: p_api_version => l_api_version
140: ,p_init_msg_list => OKC_API.G_TRUE
141: ,x_return_status => lx_return_status
142: ,x_msg_count => lx_msg_count
143: ,x_msg_data => lx_msg_data
144: ,x_po_number => lx_po_number

Line 152: IF lx_return_status = OKC_API.G_RET_STS_SUCCESS

148: -- Tieback returns Error for any fatal errors and if the PO did not
149: -- get created by PDOI, returns a Warning if the header got created
150: -- but any lines did notget created; returns success otherwise
151:
152: IF lx_return_status = OKC_API.G_RET_STS_SUCCESS
153: THEN
154: retcode := 0;
155: errbuf := NULL;
156:

Line 160: ,p_init_msg_list => OKC_API.G_TRUE

156:
157: IF l_notify = 'T'
158: THEN
159: OKC_CREATE_PO_FROM_K_PVT.notify_buyer(p_api_version => l_api_version
160: ,p_init_msg_list => OKC_API.G_TRUE
161: ,p_application_name => G_APP_NAME1
162: ,p_message_subject => 'OKC_K2PO_NOTIF_SUBJECT'
163: ,p_message_body => 'OKC_K2PO_NOTIF_BODY'
164: ,p_message_body_token1 => 'PONUMBER'

Line 178: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

174: ,x_msg_data => lx_msg_data
175: );
176:
177: -- check return status
178: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
179: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
180: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN
181: RAISE OKC_API.G_EXCEPTION_ERROR;
182: END IF;

Line 179: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

175: );
176:
177: -- check return status
178: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
179: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
180: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN
181: RAISE OKC_API.G_EXCEPTION_ERROR;
182: END IF;
183:

Line 180: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN

176:
177: -- check return status
178: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
179: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
180: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN
181: RAISE OKC_API.G_EXCEPTION_ERROR;
182: END IF;
183:
184:

Line 181: RAISE OKC_API.G_EXCEPTION_ERROR;

177: -- check return status
178: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
179: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
180: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN
181: RAISE OKC_API.G_EXCEPTION_ERROR;
182: END IF;
183:
184:
185: END IF;

Line 187: ELSIF lx_return_status = OKC_API.G_RET_STS_WARNING

183:
184:
185: END IF;
186:
187: ELSIF lx_return_status = OKC_API.G_RET_STS_WARNING
188: THEN
189: retcode := 1;
190: errbuf := lx_msg_data;
191:

Line 195: ,p_init_msg_list => OKC_API.G_TRUE

191:
192: IF l_notify = 'T'
193: THEN
194: OKC_CREATE_PO_FROM_K_PVT.notify_buyer(p_api_version => l_api_version
195: ,p_init_msg_list => OKC_API.G_TRUE
196: ,p_application_name => G_APP_NAME1
197: ,p_message_subject => 'OKC_K2PO_NOTIF_SUBJECT'
198: ,p_message_body => 'OKC_K2PO_NOTIF_BODY'
199: ,p_message_body_token1 => 'PONUMBER'

Line 213: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

209: ,x_msg_data => lx_msg_data
210: );
211:
212: -- check return status
213: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
214: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
215: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN
216: RAISE OKC_API.G_EXCEPTION_ERROR;
217: END IF;

Line 214: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

210: );
211:
212: -- check return status
213: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
214: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
215: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN
216: RAISE OKC_API.G_EXCEPTION_ERROR;
217: END IF;
218:

Line 215: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN

211:
212: -- check return status
213: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
214: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
215: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN
216: RAISE OKC_API.G_EXCEPTION_ERROR;
217: END IF;
218:
219:

Line 216: RAISE OKC_API.G_EXCEPTION_ERROR;

212: -- check return status
213: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
214: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
215: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN
216: RAISE OKC_API.G_EXCEPTION_ERROR;
217: END IF;
218:
219:
220: END IF;

Line 232: ,p_init_msg_list => OKC_API.G_TRUE

228: IF retcode <> 0 then
229:
230: submit_pdoi_errors_report(
231: p_api_version => l_api_version
232: ,p_init_msg_list => OKC_API.G_TRUE
233: ,x_return_status => lx_return_status
234: ,x_msg_count => lx_msg_count
235: ,x_msg_data => lx_msg_data
236: ,p_chr_id => p_contract_id

Line 240: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

236: ,p_chr_id => p_contract_id
237: );
238:
239: -- check return status
240: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
242: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN
243: RAISE OKC_API.G_EXCEPTION_ERROR;
244: END IF;

Line 241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

237: );
238:
239: -- check return status
240: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
242: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN
243: RAISE OKC_API.G_EXCEPTION_ERROR;
244: END IF;
245:

Line 242: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN

238:
239: -- check return status
240: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
242: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN
243: RAISE OKC_API.G_EXCEPTION_ERROR;
244: END IF;
245:
246: END IF;

Line 243: RAISE OKC_API.G_EXCEPTION_ERROR;

239: -- check return status
240: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
242: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN
243: RAISE OKC_API.G_EXCEPTION_ERROR;
244: END IF;
245:
246: END IF;
247:

Line 271: lx_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

267: ,x_msg_data OUT NOCOPY VARCHAR2)IS
268:
269: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_PO_FROM_K';
270: l_api_version CONSTANT NUMBER := 1;
271: lx_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
272: lx_msg_count NUMBER := 0;
273: lx_msg_data VARCHAR2(2000);
274: BEGIN
275: -- call START_ACTIVITY to create savepoint, check compatibility

Line 277: lx_return_status := OKC_API.START_ACTIVITY(

273: lx_msg_data VARCHAR2(2000);
274: BEGIN
275: -- call START_ACTIVITY to create savepoint, check compatibility
276: -- and initialize message list
277: lx_return_status := OKC_API.START_ACTIVITY(
278: p_api_name => l_api_name,
279: p_pkg_name => g_pkg_name,
280: p_init_msg_list => p_init_msg_list,
281: l_api_version => l_api_version,

Line 287: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

283: p_api_type => g_api_type,
284: x_return_status => lx_return_status);
285:
286: -- check if activity started successfully
287: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
288: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
289: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN
290: RAISE OKC_API.G_EXCEPTION_ERROR;
291: END IF;

Line 288: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

284: x_return_status => lx_return_status);
285:
286: -- check if activity started successfully
287: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
288: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
289: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN
290: RAISE OKC_API.G_EXCEPTION_ERROR;
291: END IF;
292:

Line 289: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN

285:
286: -- check if activity started successfully
287: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
288: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
289: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN
290: RAISE OKC_API.G_EXCEPTION_ERROR;
291: END IF;
292:
293: -- call the main routine

Line 290: RAISE OKC_API.G_EXCEPTION_ERROR;

286: -- check if activity started successfully
287: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
288: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
289: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN
290: RAISE OKC_API.G_EXCEPTION_ERROR;
291: END IF;
292:
293: -- call the main routine
294: OKC_CREATE_PO_FROM_K_PVT.create_po_from_k(p_api_version => l_api_version

Line 295: ,p_init_msg_list => OKC_API.G_TRUE

291: END IF;
292:
293: -- call the main routine
294: OKC_CREATE_PO_FROM_K_PVT.create_po_from_k(p_api_version => l_api_version
295: ,p_init_msg_list => OKC_API.G_TRUE
296: ,x_return_status => lx_return_status
297: ,x_msg_count => lx_msg_count
298: ,x_msg_data => lx_msg_data
299: ,p_chr_id => p_contract_id

Line 304: IF lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

300: );
301:
302:
303: -- check return status
304: IF lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
305: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
306: ELSIF lx_return_status = OKC_API.G_RET_STS_ERROR THEN
307: RAISE OKC_API.G_EXCEPTION_ERROR;
308: END IF;

Line 305: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

301:
302:
303: -- check return status
304: IF lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
305: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
306: ELSIF lx_return_status = OKC_API.G_RET_STS_ERROR THEN
307: RAISE OKC_API.G_EXCEPTION_ERROR;
308: END IF;
309:

Line 306: ELSIF lx_return_status = OKC_API.G_RET_STS_ERROR THEN

302:
303: -- check return status
304: IF lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
305: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
306: ELSIF lx_return_status = OKC_API.G_RET_STS_ERROR THEN
307: RAISE OKC_API.G_EXCEPTION_ERROR;
308: END IF;
309:
310: IF p_commit = OKC_API.G_TRUE THEN

Line 307: RAISE OKC_API.G_EXCEPTION_ERROR;

303: -- check return status
304: IF lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
305: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
306: ELSIF lx_return_status = OKC_API.G_RET_STS_ERROR THEN
307: RAISE OKC_API.G_EXCEPTION_ERROR;
308: END IF;
309:
310: IF p_commit = OKC_API.G_TRUE THEN
311: COMMIT;

Line 310: IF p_commit = OKC_API.G_TRUE THEN

306: ELSIF lx_return_status = OKC_API.G_RET_STS_ERROR THEN
307: RAISE OKC_API.G_EXCEPTION_ERROR;
308: END IF;
309:
310: IF p_commit = OKC_API.G_TRUE THEN
311: COMMIT;
312: END IF;
313: -- end activity
314: OKC_API.END_ACTIVITY( x_msg_count => lx_msg_count,

Line 314: OKC_API.END_ACTIVITY( x_msg_count => lx_msg_count,

310: IF p_commit = OKC_API.G_TRUE THEN
311: COMMIT;
312: END IF;
313: -- end activity
314: OKC_API.END_ACTIVITY( x_msg_count => lx_msg_count,
315: x_msg_data => lx_msg_data);
316:
317: x_return_status := lx_return_status;
318: x_msg_count := lx_msg_count;

Line 322: when OKC_API.G_EXCEPTION_ERROR then

318: x_msg_count := lx_msg_count;
319: x_msg_data := lx_msg_data;
320:
321: EXCEPTION
322: when OKC_API.G_EXCEPTION_ERROR then
323: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
324: p_api_name => l_api_name,
325: p_pkg_name => g_pkg_name,
326: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 323: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

319: x_msg_data := lx_msg_data;
320:
321: EXCEPTION
322: when OKC_API.G_EXCEPTION_ERROR then
323: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
324: p_api_name => l_api_name,
325: p_pkg_name => g_pkg_name,
326: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
327: x_msg_count => x_msg_count,

Line 326: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

322: when OKC_API.G_EXCEPTION_ERROR then
323: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
324: p_api_name => l_api_name,
325: p_pkg_name => g_pkg_name,
326: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
327: x_msg_count => x_msg_count,
328: x_msg_data => x_msg_data,
329: p_api_type => g_api_type);
330:

Line 331: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

327: x_msg_count => x_msg_count,
328: x_msg_data => x_msg_data,
329: p_api_type => g_api_type);
330:
331: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
332: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
333: p_api_name => l_api_name,
334: p_pkg_name => g_pkg_name,
335: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 332: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

328: x_msg_data => x_msg_data,
329: p_api_type => g_api_type);
330:
331: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
332: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
333: p_api_name => l_api_name,
334: p_pkg_name => g_pkg_name,
335: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
336: x_msg_count => x_msg_count,

Line 335: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

331: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
332: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
333: p_api_name => l_api_name,
334: p_pkg_name => g_pkg_name,
335: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
336: x_msg_count => x_msg_count,
337: x_msg_data => x_msg_data,
338: p_api_type => g_api_type);
339:

Line 341: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

337: x_msg_data => x_msg_data,
338: p_api_type => g_api_type);
339:
340: when OTHERS then
341: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
342: p_api_name => l_api_name,
343: p_pkg_name => g_pkg_name,
344: p_exc_name => 'OTHERS',
345: x_msg_count => x_msg_count,

Line 392: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

388:
389: IF l_request_id = 0
390: THEN
391: my_debug('40: Error submitting request for OKCRKPOI',4);
392: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
393: END IF;
394:
395: -- commit to complete the request submission
396:

Line 443: OKC_API.set_message(p_app_name => 'OKC'

439:
440: l_k_number_modifier := nvl(l_k_number_modifier, ' ');
441:
442: my_debug('80: create po from contract conc program finished successfully',4);
443: OKC_API.set_message(p_app_name => 'OKC'
444: ,p_msg_name => 'OKC_K2PO_NOTIF_SUBJECT'
445: ,p_token1 => 'PONUMBER'
446: ,p_token1_value => l_po_number
447: ,p_token2 => 'KNUMBER'

Line 452: x_return_status := OKC_API.G_RET_STS_SUCCESS;

448: ,p_token2_value => p_contract_id
449: ,p_token3 => 'KNUMMODIFIER'
450: ,p_token3_value => l_k_number_modifier
451: );
452: x_return_status := OKC_API.G_RET_STS_SUCCESS;
453: x_msg_count := 0;
454: x_msg_data := '';
455: ELSE
456: my_debug('90: create po from contract conc program finished with error',4);

Line 457: OKC_API.set_message(p_app_name => 'OKC'

453: x_msg_count := 0;
454: x_msg_data := '';
455: ELSE
456: my_debug('90: create po from contract conc program finished with error',4);
457: OKC_API.set_message(p_app_name => 'OKC'
458: ,p_msg_name => 'OKC_ERROR_PO_CREATED_DETAILS'
459: ,p_token1 => 'ERROR'
460: ,p_token1_value => sqlerrm
461: ,p_token2 => 'KNUMBER'

Line 467: x_return_status := OKC_API.G_RET_STS_ERROR;

463: ,p_token3 => 'KNUMMODIFIER'
464: ,p_token3_value => l_k_number_modifier
465: );
466:
467: x_return_status := OKC_API.G_RET_STS_ERROR;
468: x_msg_data := sqlerrm;
469: x_msg_count := 1;
470: END IF;
471:

Line 478: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR

474: my_debug('110: x_dev_status equal' || x_dev_status , 4);
475:
476: EXCEPTION
477:
478: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR
479: THEN
480:
481: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
482:

Line 481: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

477:
478: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR
479: THEN
480:
481: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
482:
483: OKC_API.set_message(p_app_name => 'OKC'
484: ,p_msg_name => 'OKC_ERROR_CONC_REQUEST'
485: ,p_token1 => 'ERROR'

Line 483: OKC_API.set_message(p_app_name => 'OKC'

479: THEN
480:
481: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
482:
483: OKC_API.set_message(p_app_name => 'OKC'
484: ,p_msg_name => 'OKC_ERROR_CONC_REQUEST'
485: ,p_token1 => 'ERROR'
486: ,p_token1_value => sqlerrm || '-' || p_contract_id
487: );

Line 494: x_return_status := okc_api.g_ret_sts_unexp_error;

490: x_msg_count := 1;
491:
492: WHEN OTHERS
493: THEN
494: x_return_status := okc_api.g_ret_sts_unexp_error;
495:
496: OKC_API.set_message(p_app_name => 'OKC'
497: ,p_msg_name => 'OKC_ERROR_PO_FROM_K'
498: ,p_token1 => 'ERROR'

Line 496: OKC_API.set_message(p_app_name => 'OKC'

492: WHEN OTHERS
493: THEN
494: x_return_status := okc_api.g_ret_sts_unexp_error;
495:
496: OKC_API.set_message(p_app_name => 'OKC'
497: ,p_msg_name => 'OKC_ERROR_PO_FROM_K'
498: ,p_token1 => 'ERROR'
499: ,p_token1_value => sqlerrm || '-' || p_contract_id
500: );

Line 542: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

538:
539: IF l_request_id = 0
540: THEN
541: my_debug('40: Error submitting request for POXPIERR',4);
542: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
543: END IF;
544:
545: my_debug('60: Submitted request for PDOI Interface errors. Request id: ' || l_request_id);
546:

Line 590: lx_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

586: ,x_msg_data OUT NOCOPY VARCHAR2) IS
587:
588: l_api_name CONSTANT VARCHAR2(30) := 'notify_buyer';
589: l_api_version CONSTANT NUMBER :=1;
590: lx_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
591: lx_msg_count NUMBER ;
592: lx_msg_data FND_NEW_MESSAGES.message_text%TYPE;
593:
594: BEGIN

Line 595: lx_return_status := OKC_API.START_ACTIVITY(

591: lx_msg_count NUMBER ;
592: lx_msg_data FND_NEW_MESSAGES.message_text%TYPE;
593:
594: BEGIN
595: lx_return_status := OKC_API.START_ACTIVITY(
596: p_api_name => l_api_name,
597: p_pkg_name => g_pkg_name,
598: p_init_msg_list => p_init_msg_list,
599: l_api_version => l_api_version,

Line 604: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

600: p_api_version => p_api_version,
601: p_api_type => g_api_type,
602: x_return_status => lx_return_status);
603:
604: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
605: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
606: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN
607: RAISE OKC_API.G_EXCEPTION_ERROR;
608: END IF;

Line 605: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

601: p_api_type => g_api_type,
602: x_return_status => lx_return_status);
603:
604: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
605: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
606: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN
607: RAISE OKC_API.G_EXCEPTION_ERROR;
608: END IF;
609:

Line 606: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN

602: x_return_status => lx_return_status);
603:
604: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
605: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
606: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN
607: RAISE OKC_API.G_EXCEPTION_ERROR;
608: END IF;
609:
610:

Line 607: RAISE OKC_API.G_EXCEPTION_ERROR;

603:
604: IF (lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
605: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
606: ELSIF (lx_return_status = OKC_API.G_RET_STS_ERROR) THEN
607: RAISE OKC_API.G_EXCEPTION_ERROR;
608: END IF;
609:
610:
611:

Line 613: IF p_trace_mode = okc_api.g_true OR

609:
610:
611:
612: -- trace mode initialization turned ON
613: IF p_trace_mode = okc_api.g_true OR
614: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' -- FND: Debug Log Enabled
615: THEN
616: okc_util.init_trace;
617: END IF;

Line 623: ,p_init_msg_list => OKC_API.G_FALSE

619: -- call the main routine
620:
621: OKC_CREATE_PO_FROM_K_PVT.notify_buyer(
622: p_api_version => l_api_version
623: ,p_init_msg_list => OKC_API.G_FALSE
624: ,p_application_name => p_application_name
625: ,p_message_subject => p_message_subject
626: ,p_message_body => p_message_body
627: ,p_message_body_token1 => p_message_body_token1

Line 641: IF p_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN

637: ,x_msg_data => lx_msg_data
638: );
639:
640: -- trace mode initialization turned OFF
641: IF p_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN
642: okc_util.stop_trace;
643: END IF;
644:
645:

Line 647: IF lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

643: END IF;
644:
645:
646: -- check return status
647: IF lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
648: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
649: ELSIF lx_return_status = OKC_API.G_RET_STS_ERROR THEN
650: RAISE OKC_API.G_EXCEPTION_ERROR;
651: END IF;

Line 648: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

644:
645:
646: -- check return status
647: IF lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
648: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
649: ELSIF lx_return_status = OKC_API.G_RET_STS_ERROR THEN
650: RAISE OKC_API.G_EXCEPTION_ERROR;
651: END IF;
652:

Line 649: ELSIF lx_return_status = OKC_API.G_RET_STS_ERROR THEN

645:
646: -- check return status
647: IF lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
648: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
649: ELSIF lx_return_status = OKC_API.G_RET_STS_ERROR THEN
650: RAISE OKC_API.G_EXCEPTION_ERROR;
651: END IF;
652:
653:

Line 650: RAISE OKC_API.G_EXCEPTION_ERROR;

646: -- check return status
647: IF lx_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
648: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
649: ELSIF lx_return_status = OKC_API.G_RET_STS_ERROR THEN
650: RAISE OKC_API.G_EXCEPTION_ERROR;
651: END IF;
652:
653:
654:

Line 656: IF p_commit = OKC_API.G_TRUE THEN

652:
653:
654:
655: -- if we got this far, then we are successful
656: IF p_commit = OKC_API.G_TRUE THEN
657: COMMIT;
658: END IF;
659:
660: -- end activity

Line 661: OKC_API.END_ACTIVITY(x_msg_count => lx_msg_count,

657: COMMIT;
658: END IF;
659:
660: -- end activity
661: OKC_API.END_ACTIVITY(x_msg_count => lx_msg_count,
662: x_msg_data => lx_msg_data);
663:
664: x_return_status := lx_return_status;
665: x_msg_count := lx_msg_count;

Line 669: when OKC_API.G_EXCEPTION_ERROR then

665: x_msg_count := lx_msg_count;
666: x_msg_data := lx_msg_data;
667:
668: EXCEPTION
669: when OKC_API.G_EXCEPTION_ERROR then
670: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
671: p_api_name => l_api_name,
672: p_pkg_name => g_pkg_name,
673: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 670: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

666: x_msg_data := lx_msg_data;
667:
668: EXCEPTION
669: when OKC_API.G_EXCEPTION_ERROR then
670: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
671: p_api_name => l_api_name,
672: p_pkg_name => g_pkg_name,
673: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
674: x_msg_count => lx_msg_count,

Line 673: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

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

Line 678: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

674: x_msg_count => lx_msg_count,
675: x_msg_data => lx_msg_data,
676: p_api_type => g_api_type);
677:
678: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
679: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
680: p_api_name => l_api_name,
681: p_pkg_name => g_pkg_name,
682: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 679: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

675: x_msg_data => lx_msg_data,
676: p_api_type => g_api_type);
677:
678: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
679: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
680: p_api_name => l_api_name,
681: p_pkg_name => g_pkg_name,
682: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
683: x_msg_count => lx_msg_count,

Line 682: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 688: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

684: x_msg_data => lx_msg_data,
685: p_api_type => g_api_type);
686:
687: when OTHERS then
688: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
689: p_api_name => l_api_name,
690: p_pkg_name => g_pkg_name,
691: p_exc_name => 'OTHERS',
692: x_msg_count => lx_msg_count,