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

Line 136: l_init_msg_list CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;

132: l_order_id Oks_K_Order_Details.order_line_id1%type;
133:
134:
135: l_api_version CONSTANT NUMBER := 1.0;
136: l_init_msg_list CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
137: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
138: l_index VARCHAR2(2000);
139:
140: l_id1 Number;

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

133:
134:
135: l_api_version CONSTANT NUMBER := 1.0;
136: l_init_msg_list CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
137: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
138: l_index VARCHAR2(2000);
139:
140: l_id1 Number;
141: l_id2 VARCHAR2(40);

Line 153: x_return_status := OKC_API.G_RET_STS_SUCCESS;

149:
150: l_covd_tbl_in.delete;
151: l_covd_tbl_out.delete;
152:
153: x_return_status := OKC_API.G_RET_STS_SUCCESS;
154:
155: Fetch Order_Dtl_cur into l_id1, l_id2, l_ser_end_date;
156:
157: EXIT WHEN Order_Dtl_cur%NOTFOUND;

Line 293: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'HEADER (HEADER)');

289:
290: End if; --- for cod type 'LTO'
291: /*
292: If l_return_status <> 'S' then
293: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'HEADER (HEADER)');
294: Raise G_EXCEPTION_HALT_VALIDATION;
295: end if;
296: */
297: End If;

Line 306: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

302: When G_EXCEPTION_HALT_VALIDATION Then
303: x_return_status := l_return_status;
304: Null;
305: When Others Then
306: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
307: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
308:
309: END Create_K_Order_Details;
310:

Line 307: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

303: x_return_status := l_return_status;
304: Null;
305: When Others Then
306: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
307: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
308:
309: END Create_K_Order_Details;
310:
311:

Line 334: x_return_status := OKC_API.G_RET_STS_SUCCESS;

330: l_year VARCHAR2(30);
331: l_time VARCHAR2(30) := '00:00:00';
332: l_date VARCHAR2(30);
333: Begin
334: x_return_status := OKC_API.G_RET_STS_SUCCESS;
335: l_day := to_char(to_date(p_date, p_format), 'DD');
336: l_month := to_char(to_date(p_date, p_format), 'MM');
337: l_year := to_char(to_date(p_date, p_format), 'YYYY');
338: l_date := l_year || '/' || l_month || '/' || l_day || ' ' || l_time;

Line 360: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

356: commit;
357:
358: Exception
359: when others then
360: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
361: Debug_Log(p_error_msg => SQLERRM,
362: x_msg_data => x_msg_data,
363: x_msg_count => x_msg_count,
364: x_return_status => x_return_status);

Line 414: x_return_status := OKC_API.G_RET_STS_SUCCESS;

410: -----and length(rule_information3) = length(format) or length(rule_information4) = length(format);
411:
412:
413: Begin
414: x_return_status := OKC_API.G_RET_STS_SUCCESS;
415: l_count_code := 1;
416: While(l_count_code <= l_category_code1.COUNT) Loop
417: l_count_format := 1;
418: While(l_count_format <= l_format.COUNT) Loop

Line 488: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

484: End Loop;
485: commit;
486: Exception
487: When others then
488: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
489: Debug_Log(p_error_msg => SQLERRM,
490: x_msg_data => x_msg_data,
491: x_msg_count => x_msg_count,
492: x_return_status => x_return_status);

Line 515: x_return_status := OKC_API.G_RET_STS_SUCCESS;

511: from v$parameter
512: where name = 'utl_file_dir';
513:
514: Begin
515: x_return_status := OKC_API.G_RET_STS_SUCCESS;
516:
517: --If FND_PROFILE.VALUE('OKS_DEBUG') = 'Y' Then
518:
519: l_file_name := 'ERM_' || to_char(sysdate, 'MM/DD/YYYY_HH24:MI:SS') || '_'

Line 546: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

542: -- End If;
543:
544: Exception
545: when utl_file.INVALID_PATH then
546: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
547: x_msg_data := l_error_msg || ' Invalid Path';
548: x_msg_count:= 1;
549: OKC_API.set_message
550: (

Line 549: OKC_API.set_message

545: when utl_file.INVALID_PATH then
546: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
547: x_msg_data := l_error_msg || ' Invalid Path';
548: x_msg_count:= 1;
549: OKC_API.set_message
550: (
551: G_APP_NAME,
552: G_UNEXPECTED_ERROR,
553: G_SQLCODE_TOKEN,

Line 559: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

555: G_SQLERRM_TOKEN,
556: 'Invalid path'
557: );
558: when utl_file.INVALID_OPERATION then
559: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
560: x_msg_data := l_error_msg || ' Invalid operation';
561: x_msg_count:= 1;
562: OKC_API.set_message
563: (

Line 562: OKC_API.set_message

558: when utl_file.INVALID_OPERATION then
559: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
560: x_msg_data := l_error_msg || ' Invalid operation';
561: x_msg_count:= 1;
562: OKC_API.set_message
563: (
564: G_APP_NAME,
565: G_UNEXPECTED_ERROR,
566: G_SQLCODE_TOKEN,

Line 573: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

569: 'Invalid operation'
570: );
571:
572: when others then
573: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
574: x_msg_data := l_error_msg || ' ' || SQLERRM;
575: x_msg_count:= 1;
576: OKC_API.set_message
577: (

Line 576: OKC_API.set_message

572: when others then
573: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
574: x_msg_data := l_error_msg || ' ' || SQLERRM;
575: x_msg_count:= 1;
576: OKC_API.set_message
577: (
578: G_APP_NAME,
579: G_UNEXPECTED_ERROR,
580: G_SQLCODE_TOKEN,