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

Line 50: WHERE b_o_flag = OKC_API.G_TRUE

46: ,'Y' config_valid_yn
47: ,'Y' config_complete_yn
48: ,nvl(to_number(sort_order),0) seq -- Bug 2087912
49: FROM OKX_ORDER_LINES_V
50: WHERE b_o_flag = OKC_API.G_TRUE
51: AND link_to_line_id = b_line_id
52: AND item_type_code in ('OPTION','CLASS')
53: UNION ALL
54: SELECT a.id1 line_id

Line 72: WHERE b_q_flag = OKC_API.G_TRUE

68: ,c.complete_configuration_flag config_complete_yn
69: ,a.line_number seq -- for sorting Bug 2087912
70: -- Changed refrence to ASO tables to OKX views
71: FROM OKX_QUOTE_LINES_V a,OKX_QTE_LINE_RLSHPS_V b,OKX_QUOTE_LINE_DETAIL_V c
72: WHERE b_q_flag = OKC_API.G_TRUE
73: AND a.id1 = b.related_quote_line_id
74: AND a.id1 = c.quote_line_id
75: AND b.quote_line_id= b_line_id
76: AND b.relationship_type_code ='CONFIG'

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

78: order by 16;
79:
80: l_msg_count NUMBER;
81: l_msg_data VARCHAR2(2000);
82: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
83: child_line_rec c_child_line_info%ROWTYPE;
84: l_child_cimv_rec OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE;
85: l_child_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
86: lx_child_cimv_rec OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE;

Line 105: x_return_status := OKC_API.G_RET_STS_SUCCESS;

101: okc_util.print_trace(1, ' ');
102: okc_util.print_trace(1, '>START - OKO_OC_INT_CONFGI_PVT.create_config_sublines - create Sublines');
103: okc_util.print_trace(1, ' ');
104: END IF;
105: x_return_status := OKC_API.G_RET_STS_SUCCESS;
106: l_child_cimv_rec := temp_child_cimv_rec;
107: l_child_clev_rec := temp_child_clev_rec;
108: l_subline_num := 0;
109: OPEN c_child_line_info(p_source_inf_rec.o_flag,p_source_inf_rec.q_flag,p_source_inf_rec.line_id);

Line 188: ,p_init_msg_list => OKC_API.G_FALSE

184: okc_util.print_trace(1, '>START - ******* OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE -');
185: END IF;
186:
187: okc_contract_pub.create_contract_line(p_api_version => 1
188: ,p_init_msg_list => OKC_API.G_FALSE
189: ,x_return_status => l_return_status
190: ,x_msg_count => l_msg_count
191: ,x_msg_data => l_msg_data
192: ,p_clev_rec => l_child_clev_rec

Line 204: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN

200: okc_util.print_trace(1, 'Context organization_id = '|| SYS_CONTEXT('OKC_CONTEXT', 'ORGANIZATION_ID'));
201: okc_util.print_trace(1, '----------------------------');
202: END IF;
203:
204: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN
205:
206: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,
207: p_msg_name => 'OKC_CONFIGLINE',
208: p_token1 => 'ONUMBER',

Line 206: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,

202: END IF;
203:
204: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN
205:
206: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,
207: p_msg_name => 'OKC_CONFIGLINE',
208: p_token1 => 'ONUMBER',
209: p_token1_value => p_source_inf_rec.object_number,
210: p_token2 => 'OLNUMBER',

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

215: p_token4_value => l_child_clev_rec.config_item_type
216: );
217: END IF;
218:
219: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
220: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
221: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
222: RAISE OKC_API.G_EXCEPTION_ERROR;
223: END IF;

Line 220: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

216: );
217: END IF;
218:
219: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
220: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
221: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
222: RAISE OKC_API.G_EXCEPTION_ERROR;
223: END IF;
224:

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

217: END IF;
218:
219: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
220: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
221: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
222: RAISE OKC_API.G_EXCEPTION_ERROR;
223: END IF;
224:
225: IF (l_debug = 'Y') THEN

Line 222: RAISE OKC_API.G_EXCEPTION_ERROR;

218:
219: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
220: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
221: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
222: RAISE OKC_API.G_EXCEPTION_ERROR;
223: END IF;
224:
225: IF (l_debug = 'Y') THEN
226: okc_util.print_trace(3, 'OUTPUT RECORD - Contract Line Record:');

Line 295: ,p_init_msg_list => OKC_API.G_FALSE

291: okc_util.print_trace(1, '>START - ******* OKC_CONTRACT_ITEM_PUB.CREATE_CONTRACT_ITEM -');
292: END IF;
293:
294: okc_contract_item_pub.create_contract_item(p_api_version => 1
295: ,p_init_msg_list => OKC_API.G_FALSE
296: ,x_return_status => l_return_status
297: ,x_msg_count => l_msg_count
298: ,x_msg_data => l_msg_data
299: ,p_cimv_rec => l_child_cimv_rec

Line 308: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN

304: okc_util.print_trace(1, ' 305: okc_util.print_trace(1, '--------------------------------------------------------');
306: END IF;
307:
308: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN
309:
310: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,
311: p_msg_name => 'OKC_CONFIGITEM',
312: p_token1 => 'ONUMBER',

Line 310: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,

306: END IF;
307:
308: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN
309:
310: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,
311: p_msg_name => 'OKC_CONFIGITEM',
312: p_token1 => 'ONUMBER',
313: p_token1_value => p_source_inf_rec.object_number,
314: p_token2 => 'OLNUMBER',

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

320: p_token5 => 'LINETYPE',
321: p_token5_value => l_child_clev_rec.config_item_type
322: );
323: END IF;
324: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
325: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
326: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
327: RAISE OKC_API.G_EXCEPTION_ERROR;
328: END IF;

Line 325: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

321: p_token5_value => l_child_clev_rec.config_item_type
322: );
323: END IF;
324: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
325: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
326: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
327: RAISE OKC_API.G_EXCEPTION_ERROR;
328: END IF;
329:

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

322: );
323: END IF;
324: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
325: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
326: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
327: RAISE OKC_API.G_EXCEPTION_ERROR;
328: END IF;
329:
330: IF (l_debug = 'Y') THEN

Line 327: RAISE OKC_API.G_EXCEPTION_ERROR;

323: END IF;
324: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
325: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
326: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
327: RAISE OKC_API.G_EXCEPTION_ERROR;
328: END IF;
329:
330: IF (l_debug = 'Y') THEN
331: okc_util.print_trace(3, 'OUTPUT RECORD - Contract Top Line Item Record:');

Line 360: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN

356: p_parent_cimv_rec => lx_child_cimv_rec,
357: p_line_inf_tab => p_line_inf_tab,
358: x_return_status => l_return_status);
359:
360: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN
361: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,
362: p_msg_name => 'OKC_CONFIGCREATE',
363: p_token1 => 'ONUMBER',
364: p_token1_value => p_source_inf_rec.object_number,

Line 361: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,

357: p_line_inf_tab => p_line_inf_tab,
358: x_return_status => l_return_status);
359:
360: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN
361: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,
362: p_msg_name => 'OKC_CONFIGCREATE',
363: p_token1 => 'ONUMBER',
364: p_token1_value => p_source_inf_rec.object_number,
365: p_token2 => 'LINENUMBER',

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

370: p_token4_value => G_NORMAL_LINE
371: );
372: END IF;
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: );
372: END IF;
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:

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

372: END IF;
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:
380: END LOOP;

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:
380: END LOOP;
381:

Line 387: OKC_API.set_message(OKC_API.G_APP_NAME,

383: WHEN no_child_left THEN
384: NULL;
385: WHEN OTHERS THEN
386: -- store SQL error message on message stack for caller
387: OKC_API.set_message(OKC_API.G_APP_NAME,
388: 'OKC_CONTRACTS_UNEXP_ERROR',
389: 'SQLCODE',
390: SQLCODE,
391: 'SQLERRM',

Line 393: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

389: 'SQLCODE',
390: SQLCODE,
391: 'SQLERRM',
392: SQLERRM);
393: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
394: END create_config_sublines;
395:
396:
397: ------------------------------------------------------------------------------

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

428: l_cimv_rec OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE;
429: model_cimv_rec OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE;
430: lx_cimv_rec OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE;
431: line_inf_tab_counter NUMBER := 0;
432: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
433: l_msg_count NUMBER;
434: l_msg_data VARCHAR2(2000);
435:
436: BEGIN

Line 438: x_return_status := OKC_API.G_RET_STS_SUCCESS;

434: l_msg_data VARCHAR2(2000);
435:
436: BEGIN
437:
438: x_return_status := OKC_API.G_RET_STS_SUCCESS;
439:
440: IF (l_debug = 'Y') THEN
441: okc_util.print_trace(0, 'Starting Configurator API');
442: okc_util.print_trace(0, ' ');

Line 490: ,p_init_msg_list => OKC_API.G_FALSE

486: okc_util.print_trace(1, '>START - ******* OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE -');
487: END IF;
488:
489: okc_contract_pub.create_contract_line(p_api_version => 1
490: ,p_init_msg_list => OKC_API.G_FALSE
491: ,x_return_status => l_return_status
492: ,x_msg_count => l_msg_count
493: ,x_msg_data => l_msg_data
494: ,p_clev_rec => model_clev_rec

Line 506: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN

502: okc_util.print_trace(1, 'Context organization_id = '|| SYS_CONTEXT('OKC_CONTEXT', 'ORGANIZATION_ID'));
503: okc_util.print_trace(1, '----------------------------');
504: END IF;
505:
506: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN
507:
508: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,
509: p_msg_name => 'OKC_CONFIGLINE',
510: p_token1 => 'ONUMBER',

Line 508: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,

504: END IF;
505:
506: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN
507:
508: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,
509: p_msg_name => 'OKC_CONFIGLINE',
510: p_token1 => 'ONUMBER',
511: p_token1_value => p_source_inf_rec.object_number,
512: p_token2 => 'OLNUMBER',

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

516: p_token4 => 'LINETYPE',
517: p_token4_value => model_clev_rec.config_item_type
518: );
519: END IF;
520: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
521: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
522: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
523: RAISE OKC_API.G_EXCEPTION_ERROR;
524: END IF;

Line 521: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

517: p_token4_value => model_clev_rec.config_item_type
518: );
519: END IF;
520: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
521: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
522: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
523: RAISE OKC_API.G_EXCEPTION_ERROR;
524: END IF;
525:

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

518: );
519: END IF;
520: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
521: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
522: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
523: RAISE OKC_API.G_EXCEPTION_ERROR;
524: END IF;
525:
526: line_inf_tab_counter := p_line_inf_tab.count+1;

Line 523: RAISE OKC_API.G_EXCEPTION_ERROR;

519: END IF;
520: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
521: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
522: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
523: RAISE OKC_API.G_EXCEPTION_ERROR;
524: END IF;
525:
526: line_inf_tab_counter := p_line_inf_tab.count+1;
527: p_line_inf_tab(line_inf_tab_counter).object1_id1 := lx_clev_rec.orig_system_id1;

Line 587: ,p_init_msg_list => OKC_API.G_FALSE

583: okc_util.print_trace(1, '>START - ******* OKC_CONTRACT_ITEM_PUB.CREATE_CONTRACT_ITEM -');
584: END IF;
585:
586: okc_contract_item_pub.create_contract_item(p_api_version => 1
587: ,p_init_msg_list => OKC_API.G_FALSE
588: ,x_return_status => l_return_status
589: ,x_msg_count => l_msg_count
590: ,x_msg_data => l_msg_data
591: ,p_cimv_rec => model_cimv_rec

Line 604: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN

600: okc_util.print_trace(1, 'Context organization_id = '|| SYS_CONTEXT('OKC_CONTEXT', 'ORGANIZATION_ID'));
601: okc_util.print_trace(1, '----------------------------');
602: END IF;
603:
604: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN
605: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,
606: p_msg_name => 'OKC_CONFIGLINE',
607: p_token1 => 'ONUMBER',
608: p_token1_value => p_source_inf_rec.object_number,

Line 605: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,

601: okc_util.print_trace(1, '----------------------------');
602: END IF;
603:
604: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN
605: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,
606: p_msg_name => 'OKC_CONFIGLINE',
607: p_token1 => 'ONUMBER',
608: p_token1_value => p_source_inf_rec.object_number,
609: p_token2 => 'OLNUMBER',

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

615: p_token5 => 'LINETYPE',
616: p_token5_value => model_clev_rec.config_item_type
617: );
618: END IF;
619: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
620: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
621: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
622: RAISE OKC_API.G_EXCEPTION_ERROR;
623: END IF;

Line 620: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

616: p_token5_value => model_clev_rec.config_item_type
617: );
618: END IF;
619: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
620: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
621: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
622: RAISE OKC_API.G_EXCEPTION_ERROR;
623: END IF;
624:

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

617: );
618: END IF;
619: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
620: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
621: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
622: RAISE OKC_API.G_EXCEPTION_ERROR;
623: END IF;
624:
625: IF (l_debug = 'Y') THEN

Line 622: RAISE OKC_API.G_EXCEPTION_ERROR;

618: END IF;
619: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
620: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
621: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
622: RAISE OKC_API.G_EXCEPTION_ERROR;
623: END IF;
624:
625: IF (l_debug = 'Y') THEN
626: okc_util.print_trace(1, 'OUTPUT RECORD - Contract Top Line Item Record:');

Line 699: ,p_init_msg_list => OKC_API.G_FALSE

695: okc_util.print_trace(1, '>START - ******* OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE -');
696: END IF;
697:
698: okc_contract_pub.create_contract_line(p_api_version => 1
699: ,p_init_msg_list => OKC_API.G_FALSE
700: ,x_return_status => l_return_status
701: ,x_msg_count => l_msg_count
702: ,x_msg_data => l_msg_data
703: ,p_clev_rec => l_clev_rec

Line 715: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN

711: okc_util.print_trace(1, 'Context organization_id = '|| SYS_CONTEXT('OKC_CONTEXT', 'ORGANIZATION_ID'));
712: okc_util.print_trace(1, '----------------------------');
713: END IF;
714:
715: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN
716:
717: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,
718: p_msg_name => 'OKC_CONFIGLINE',
719: p_token1 => 'ONUMBER',

Line 717: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,

713: END IF;
714:
715: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN
716:
717: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,
718: p_msg_name => 'OKC_CONFIGLINE',
719: p_token1 => 'ONUMBER',
720: p_token1_value => p_source_inf_rec.object_number,
721: p_token2 => 'OLNUMBER',

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

725: p_token4 => 'LINETYPE',
726: p_token4_value => l_clev_rec.config_item_type
727: );
728: END IF;
729: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
730: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
731: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
732: RAISE OKC_API.G_EXCEPTION_ERROR;
733: END IF;

Line 730: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

726: p_token4_value => l_clev_rec.config_item_type
727: );
728: END IF;
729: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
730: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
731: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
732: RAISE OKC_API.G_EXCEPTION_ERROR;
733: END IF;
734:

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

727: );
728: END IF;
729: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
730: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
731: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
732: RAISE OKC_API.G_EXCEPTION_ERROR;
733: END IF;
734:
735: line_inf_tab_counter := p_line_inf_tab.count+1;

Line 732: RAISE OKC_API.G_EXCEPTION_ERROR;

728: END IF;
729: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
730: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
731: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
732: RAISE OKC_API.G_EXCEPTION_ERROR;
733: END IF;
734:
735: line_inf_tab_counter := p_line_inf_tab.count+1;
736: p_line_inf_tab(line_inf_tab_counter).object1_id1 := lx_clev_rec.orig_system_id1;

Line 791: ,p_init_msg_list => OKC_API.G_FALSE

787: okc_util.print_trace(1, '>START - ******* OKC_CONTRACT_ITEM_PUB.CREATE_CONTRACT_ITEM -');
788: END IF;
789:
790: okc_contract_item_pub.create_contract_item(p_api_version => 1
791: ,p_init_msg_list => OKC_API.G_FALSE
792: ,x_return_status => l_return_status
793: ,x_msg_count => l_msg_count
794: ,x_msg_data => l_msg_data
795: ,p_cimv_rec => l_cimv_rec

Line 808: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN

804: okc_util.print_trace(1, 'Context organization_id = '|| SYS_CONTEXT('OKC_CONTEXT', 'ORGANIZATION_ID'));
805: okc_util.print_trace(1, '----------------------------');
806: END IF;
807:
808: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN
809: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,
810: p_msg_name => 'OKC_CONFIGLINE',
811: p_token1 => 'ONUMBER',
812: p_token1_value => p_source_inf_rec.object_number,

Line 809: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,

805: okc_util.print_trace(1, '----------------------------');
806: END IF;
807:
808: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN
809: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,
810: p_msg_name => 'OKC_CONFIGLINE',
811: p_token1 => 'ONUMBER',
812: p_token1_value => p_source_inf_rec.object_number,
813: p_token2 => 'OLNUMBER',

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

819: p_token5 => 'LINETYPE',
820: p_token5_value => l_clev_rec.config_item_type
821: );
822: END IF;
823: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
824: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
825: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
826: RAISE OKC_API.G_EXCEPTION_ERROR;
827: END IF;

Line 824: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

820: p_token5_value => l_clev_rec.config_item_type
821: );
822: END IF;
823: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
824: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
825: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
826: RAISE OKC_API.G_EXCEPTION_ERROR;
827: END IF;
828:

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

821: );
822: END IF;
823: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
824: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
825: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
826: RAISE OKC_API.G_EXCEPTION_ERROR;
827: END IF;
828:
829: IF (l_debug = 'Y') THEN

Line 826: RAISE OKC_API.G_EXCEPTION_ERROR;

822: END IF;
823: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
824: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
825: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
826: RAISE OKC_API.G_EXCEPTION_ERROR;
827: END IF;
828:
829: IF (l_debug = 'Y') THEN
830: okc_util.print_trace(1, 'OUTPUT RECORD - Contract Top Line Item Record:');

Line 865: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN

861: p_parent_cimv_rec => lx_cimv_rec,
862: p_line_inf_tab => p_line_inf_tab,
863: x_return_status => l_return_status
864: ) ;
865: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN
866: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,
867: p_msg_name => 'OKC_CONFIGCREATE',
868: p_token1 => 'ONUMBER',
869: p_token1_value => p_source_inf_rec.object_number,

Line 866: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,

862: p_line_inf_tab => p_line_inf_tab,
863: x_return_status => l_return_status
864: ) ;
865: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN
866: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,
867: p_msg_name => 'OKC_CONFIGCREATE',
868: p_token1 => 'ONUMBER',
869: p_token1_value => p_source_inf_rec.object_number,
870: p_token2 => 'LINENUMBER',

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

881: okc_util.print_trace(1, ' ');
882: okc_util.print_trace(1, ' ');
883: END IF;
884:
885: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
886: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
887: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
888: RAISE OKC_API.G_EXCEPTION_ERROR;
889: END IF;

Line 886: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

882: okc_util.print_trace(1, ' ');
883: END IF;
884:
885: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
886: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
887: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
888: RAISE OKC_API.G_EXCEPTION_ERROR;
889: END IF;
890:

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

883: END IF;
884:
885: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
886: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
887: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
888: RAISE OKC_API.G_EXCEPTION_ERROR;
889: END IF;
890:
891: -- Call to Update Rolledup List Price and Rolled up negotiated Price

Line 888: RAISE OKC_API.G_EXCEPTION_ERROR;

884:
885: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
886: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
887: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
888: RAISE OKC_API.G_EXCEPTION_ERROR;
889: END IF;
890:
891: -- Call to Update Rolledup List Price and Rolled up negotiated Price
892: xmodel_clev_rec.line_list_price := rolledup_line_list_price;

Line 912: ,p_init_msg_list => OKC_API.G_FALSE

908: okc_util.print_trace(1, '>START - ******* OKC_CONTRACT_PUB.UPDATE_CONTRACT_LINE -');
909: END IF;
910:
911: okc_contract_pub.update_contract_line(p_api_version => 1
912: ,p_init_msg_list => OKC_API.G_FALSE
913: ,x_return_status => l_return_status
914: ,x_msg_count => l_msg_count
915: ,x_msg_data => l_msg_data
916: ,p_clev_rec => xmodel_clev_rec

Line 921: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN

917: ,x_clev_rec => x_clev_rec
918: );
919:
920:
921: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN
922:
923: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,
924: p_msg_name => 'OKC_UPD_PRICE',
925: p_token1 => 'ONUMBER',

Line 923: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,

919:
920:
921: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR l_return_status = OKC_API.G_RET_STS_ERROR THEN
922:
923: okc_api.set_message(p_app_name => OKC_API.G_APP_NAME,
924: p_msg_name => 'OKC_UPD_PRICE',
925: p_token1 => 'ONUMBER',
926: p_token1_value => p_source_inf_rec.object_number,
927: p_token2 => 'OLNUMBER',

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

934: okc_util.print_trace(1, 'Context org_id = '|| SYS_CONTEXT('OKC_CONTEXT', 'ORG_ID'));
935: okc_util.print_trace(1, 'Context organization_id = '|| SYS_CONTEXT('OKC_CONTEXT', 'ORGANIZATION_ID'));
936: okc_util.print_trace(1, '----------------------------');
937: END IF;
938: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
939: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
940: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
941: RAISE OKC_API.G_EXCEPTION_ERROR;
942: END IF;

Line 939: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

935: okc_util.print_trace(1, 'Context organization_id = '|| SYS_CONTEXT('OKC_CONTEXT', 'ORGANIZATION_ID'));
936: okc_util.print_trace(1, '----------------------------');
937: END IF;
938: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
939: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
940: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
941: RAISE OKC_API.G_EXCEPTION_ERROR;
942: END IF;
943:

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

936: okc_util.print_trace(1, '----------------------------');
937: END IF;
938: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
939: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
940: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
941: RAISE OKC_API.G_EXCEPTION_ERROR;
942: END IF;
943:
944: IF (l_debug = 'Y') THEN

Line 941: RAISE OKC_API.G_EXCEPTION_ERROR;

937: END IF;
938: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
939: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
940: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
941: RAISE OKC_API.G_EXCEPTION_ERROR;
942: END IF;
943:
944: IF (l_debug = 'Y') THEN
945: okc_util.print_trace(0, 'Normal Exit From Configurator API');

Line 950: OKC_API.set_message(OKC_API.G_APP_NAME,

946: END IF;
947: EXCEPTION
948: WHEN OTHERS THEN
949: -- store SQL error message on message stack for caller
950: OKC_API.set_message(OKC_API.G_APP_NAME,
951: 'OKC_CONTRACTS_UNEXP_ERROR',
952: 'SQLCODE',
953: SQLCODE,
954: 'SQLERRM',

Line 959: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

955: SQLERRM);
956: IF (l_debug = 'Y') THEN
957: okc_util.print_trace(0, 'Abnormal Exit From Configurator API');
958: END IF;
959: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
960: END create_k_config_lines;
961:
962:
963:

Line 1182: OKC_API.set_message(p_app_name => OKC_API.G_APP_NAME,

1178: IF (l_debug = 'Y') THEN
1179: okc_util.print_trace(2,'Rltn exists for a diff quote id, raising an exception');
1180: END IF;
1181:
1182: OKC_API.set_message(p_app_name => OKC_API.G_APP_NAME,
1183: p_msg_name => 'OKC_UPD_LINERLTN',
1184: p_token1 => 'QUOTELINEID',
1185: p_token1_value => l_qte_line_rlt.quote_line_id,
1186: p_token2 => 'RLTDQTELINEID',

Line 1191: x_return_status := OKC_API.G_RET_STS_ERROR;

1187: p_token2_value => l_line_rltship_tab(p).related_quote_line_id,
1188: p_token3 => 'RLTSHPTYPECODE',
1189: p_token3_value => l_config_rltship_code
1190: );
1191: x_return_status := OKC_API.G_RET_STS_ERROR;
1192: RAISE e_exit;
1193: END IF;
1194: ELSE -- IF c_qte_line_rlt%FOUND
1195: --

Line 1202: OKC_API.set_message(p_app_name => OKC_API.G_APP_NAME,

1198: --
1199: IF (l_debug = 'Y') THEN
1200: okc_util.print_trace(2,'No rec found while trying to validate the rltnshp, raising an exception');
1201: END IF;
1202: OKC_API.set_message(p_app_name => OKC_API.G_APP_NAME,
1203: p_msg_name => 'OKC_UPD_LINERLTNOTFOUND',
1204: p_token1 => 'RLTDQTELINEID',
1205: p_token1_value => l_line_rltship_tab(p).related_quote_line_id,
1206: p_token2 => 'RLTSHPTYPECODE',

Line 1209: x_return_status := OKC_API.G_RET_STS_ERROR;

1205: p_token1_value => l_line_rltship_tab(p).related_quote_line_id,
1206: p_token2 => 'RLTSHPTYPECODE',
1207: p_token2_value => l_config_rltship_code
1208: );
1209: x_return_status := OKC_API.G_RET_STS_ERROR;
1210: RAISE e_exit;
1211: END IF; -- IF c_qte_line_rlt%FOUND
1212:
1213: CLOSE c_qte_line_rlt;

Line 1246: IF NVL(px_qte_line_dtl_tbl(k).service_ref_qte_line_index,OKC_API.G_MISS_NUM) <>

1242: IF px_qte_line_dtl_tbl(k).service_ref_type_code = okc_oc_int_ktq_pvt.g_qte_ref_quote THEN
1243: -- Now this is a covered line and hence the relationship needs to be created
1244: -- Need to use the index of the related quote line (service line).
1245:
1246: IF NVL(px_qte_line_dtl_tbl(k).service_ref_qte_line_index,OKC_API.G_MISS_NUM) <>
1247: OKC_API.G_MISS_NUM THEN
1248: IF (l_debug = 'Y') THEN
1249: okc_util.print_trace(2,'Create the relationship for the cov line using index');
1250: END IF;

Line 1247: OKC_API.G_MISS_NUM THEN

1243: -- Now this is a covered line and hence the relationship needs to be created
1244: -- Need to use the index of the related quote line (service line).
1245:
1246: IF NVL(px_qte_line_dtl_tbl(k).service_ref_qte_line_index,OKC_API.G_MISS_NUM) <>
1247: OKC_API.G_MISS_NUM THEN
1248: IF (l_debug = 'Y') THEN
1249: okc_util.print_trace(2,'Create the relationship for the cov line using index');
1250: END IF;
1251: p := p+1;

Line 1313: IF NVL(px_qte_line_dtl_tbl(k).service_ref_qte_line_index,OKC_API.G_MISS_NUM) <>

1309: IF px_qte_line_dtl_tbl(k).service_ref_type_code = okc_oc_int_ktq_pvt.g_qte_ref_quote THEN
1310:
1311: -- Need to use the id of the related quote line (service line).
1312:
1313: IF NVL(px_qte_line_dtl_tbl(k).service_ref_qte_line_index,OKC_API.G_MISS_NUM) <>
1314: OKC_API.G_MISS_NUM THEN
1315: p := p + 1;
1316: l_line_rltship_tab(p).qte_line_index := px_qte_line_dtl_tbl(k).service_ref_qte_line_index;
1317: IF (l_debug = 'Y') THEN

Line 1314: OKC_API.G_MISS_NUM THEN

1310:
1311: -- Need to use the id of the related quote line (service line).
1312:
1313: IF NVL(px_qte_line_dtl_tbl(k).service_ref_qte_line_index,OKC_API.G_MISS_NUM) <>
1314: OKC_API.G_MISS_NUM THEN
1315: p := p + 1;
1316: l_line_rltship_tab(p).qte_line_index := px_qte_line_dtl_tbl(k).service_ref_qte_line_index;
1317: IF (l_debug = 'Y') THEN
1318: okc_util.print_trace(2,'Update the relationship for the cov line using index');

Line 1395: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1391:
1392: x_line_rltship_tab := l_line_rltship_tab;
1393:
1394:
1395: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1396:
1397: EXCEPTION
1398:
1399: WHEN e_exit THEN

Line 1410: OKC_API.set_message(G_APP_NAME,

1406: IF c_qte_line_rlt%ISOPEN THEN
1407: CLOSE c_qte_line_rlt;
1408: END IF;
1409:
1410: OKC_API.set_message(G_APP_NAME,
1411: G_UNEXPECTED_ERROR,
1412: G_SQLCODE_TOKEN,
1413: SQLCODE,
1414: G_SQLERRM_TOKEN,

Line 1418: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1414: G_SQLERRM_TOKEN,
1415: SQLERRM);
1416: -- notify caller of an UNEXPECTED error
1417:
1418: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1419:
1420: END quote_line_relationship;
1421:
1422: END OKC_OC_INT_CONFIG_PVT;