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

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

6: -- -------------------------------------------------------------------------
7: -- GLOBAL VARIABLES
8: -- -------------------------------------------------------------------------
9: --l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
10: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
12: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
14: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKC_CFG_PUB';

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

214: -- build_cle_from_cz variable declarations:
215: -- -------------------------------------------------------------------------
216: l_api_name CONSTANT VARCHAR2(30) := 'build_cle_from_cz';
217: l_api_version_number CONSTANT NUMBER := 1.0;
218: l_init_msg_list VARCHAR2(1) := OKC_API.G_FALSE;
219: l_index BINARY_INTEGER := 0;
220: l_complete_configuration_flag VARCHAR2(3);
221: l_valid_configuration_flag VARCHAR2(3);
222: l_config_exists VARCHAR2(1) := 'N';

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

242: l_price_list_id NUMBER;
243: l_hdr_pricing_date DATE; -- Added for Bug 2393302
244: l_line_pricing_date DATE; -- Added for Bug 2393302
245: l_pricing_date DATE; -- Added for Bug 2393302
246: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
247:
248: -- ---------------------------------------------------------------
249: -- build_cle_from_cz Record type declarations:
250: -- ---------------------------------------------------------------

Line 284: okc_api.init_msg_list(p_init_msg_list);

280: OKC_DEBUG.set_indentation(l_api_name);
281: OKC_DEBUG.log('10: Entered build_cle_from_cz', 2);
282: END IF;
283: --FND_MSG_PUB.initialize;
284: okc_api.init_msg_list(p_init_msg_list);
285:
286: -- ------------------------------------------------------------
287: -- Call start_activity to create savepoint, check compatibility
288: -- and initialize message list

Line 290: l_return_status := OKC_API.START_ACTIVITY(

286: -- ------------------------------------------------------------
287: -- Call start_activity to create savepoint, check compatibility
288: -- and initialize message list
289: -- ------------------------------------------------------------
290: l_return_status := OKC_API.START_ACTIVITY(
291: p_api_name => l_api_name,
292: p_pkg_name => G_PKG_NAME,
293: p_init_msg_list => p_init_msg_list,
294: l_api_version => l_api_version_number,

Line 300: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR)

296: p_api_type => G_API_TYPE,
297: x_return_status => x_return_status);
298:
299: -- Check if activity started successfully
300: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR)
301: THEN
302: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
303: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR)
304: THEN

Line 302: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

298:
299: -- Check if activity started successfully
300: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR)
301: THEN
302: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
303: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR)
304: THEN
305: RAISE OKC_API.G_EXCEPTION_ERROR;
306: END IF;

Line 303: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR)

299: -- Check if activity started successfully
300: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR)
301: THEN
302: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
303: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR)
304: THEN
305: RAISE OKC_API.G_EXCEPTION_ERROR;
306: END IF;
307:

Line 305: RAISE OKC_API.G_EXCEPTION_ERROR;

301: THEN
302: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
303: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR)
304: THEN
305: RAISE OKC_API.G_EXCEPTION_ERROR;
306: END IF;
307:
308: -- -------------------------------------------------------------------
309: -- STEP.1: DEBUG: 100 series

Line 322: RAISE OKC_API.G_EXCEPTION_ERROR;

318: THEN
319: IF (l_debug = 'Y') THEN
320: OKC_DEBUG.log('11: Config Exists already in OKC: '||p_au_line_rec.id);
321: END IF;
322: RAISE OKC_API.G_EXCEPTION_ERROR;
323: END IF;
324:
325: -- --------------------------------------------------------------------
326: -- STEP.1.1: DEBUG: 100 series

Line 330: IF ( p_au_line_rec.config_hdr_id <> OKC_API.G_MISS_NUM AND

326: -- STEP.1.1: DEBUG: 100 series
327: -- Delete the earlier configuration revision lines to be replaced
328: -- with new config revision that is under process.
329: -- --------------------------------------------------------------------
330: IF ( p_au_line_rec.config_hdr_id <> OKC_API.G_MISS_NUM AND
331: p_au_line_rec.config_rev_nbr <> OKC_API.G_MISS_NUM )
332: THEN
333: OPEN cur_old_config (p_au_line_rec.config_hdr_id,
334: p_au_line_rec.config_rev_nbr,

Line 331: p_au_line_rec.config_rev_nbr <> OKC_API.G_MISS_NUM )

327: -- Delete the earlier configuration revision lines to be replaced
328: -- with new config revision that is under process.
329: -- --------------------------------------------------------------------
330: IF ( p_au_line_rec.config_hdr_id <> OKC_API.G_MISS_NUM AND
331: p_au_line_rec.config_rev_nbr <> OKC_API.G_MISS_NUM )
332: THEN
333: OPEN cur_old_config (p_au_line_rec.config_hdr_id,
334: p_au_line_rec.config_rev_nbr,
335: p_au_line_rec.id,

Line 377: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR

373: END LOOP; -- end of message count loop
374: END IF;
375:
376: -- Check Return Status
377: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
378: THEN
379: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
380: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
381: THEN

Line 379: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

375:
376: -- Check Return Status
377: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
378: THEN
379: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
380: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
381: THEN
382: RAISE OKC_API.G_EXCEPTION_ERROR;
383: END IF;

Line 380: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR

376: -- Check Return Status
377: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
378: THEN
379: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
380: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
381: THEN
382: RAISE OKC_API.G_EXCEPTION_ERROR;
383: END IF;
384:

Line 382: RAISE OKC_API.G_EXCEPTION_ERROR;

378: THEN
379: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
380: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
381: THEN
382: RAISE OKC_API.G_EXCEPTION_ERROR;
383: END IF;
384:
385: END LOOP; -- old config
386: CLOSE cur_old_config;

Line 544: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR

540: END LOOP; -- end of message count loop
541: END IF;
542:
543: -- Check Return Status
544: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
545: THEN
546: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
547: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
548: THEN

Line 546: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

542:
543: -- Check Return Status
544: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
545: THEN
546: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
547: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
548: THEN
549: RAISE OKC_API.G_EXCEPTION_ERROR;
550: END IF;

Line 547: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR

543: -- Check Return Status
544: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
545: THEN
546: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
547: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
548: THEN
549: RAISE OKC_API.G_EXCEPTION_ERROR;
550: END IF;
551:

Line 549: RAISE OKC_API.G_EXCEPTION_ERROR;

545: THEN
546: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
547: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
548: THEN
549: RAISE OKC_API.G_EXCEPTION_ERROR;
550: END IF;
551:
552: l_top_model_line_id := x_clev_rec.id;
553:

Line 568: l_clev_rec.id := OKC_API.G_MISS_NUM; -- init

564: -- - The display sequence are l_index based for now.
565: -- - Config Item Id is populated only for base line and its
566: -- children. This is part of the unique key in CZ schema.
567: -- -----------------------------------------------------------------
568: l_clev_rec.id := OKC_API.G_MISS_NUM; -- init
569: l_clev_rec.cle_id := l_top_model_line_id;
570: l_clev_rec.chr_id := OKC_API.G_MISS_NUM; -- init
571: l_clev_rec.config_item_type := 'TOP_BASE_LINE'; -- flag
572: l_clev_rec.display_sequence := l_index + 1;

Line 570: l_clev_rec.chr_id := OKC_API.G_MISS_NUM; -- init

566: -- children. This is part of the unique key in CZ schema.
567: -- -----------------------------------------------------------------
568: l_clev_rec.id := OKC_API.G_MISS_NUM; -- init
569: l_clev_rec.cle_id := l_top_model_line_id;
570: l_clev_rec.chr_id := OKC_API.G_MISS_NUM; -- init
571: l_clev_rec.config_item_type := 'TOP_BASE_LINE'; -- flag
572: l_clev_rec.display_sequence := l_index + 1;
573: l_clev_rec.config_item_id := l_config_rec.config_item_id;
574:

Line 614: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR

610: END LOOP; -- end of message count loop
611: END IF;
612:
613: -- Check Return Status
614: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
615: THEN
616: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
617: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
618: THEN

Line 616: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

612:
613: -- Check Return Status
614: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
615: THEN
616: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
617: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
618: THEN
619: RAISE OKC_API.G_EXCEPTION_ERROR;
620: END IF;

Line 617: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR

613: -- Check Return Status
614: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
615: THEN
616: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
617: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
618: THEN
619: RAISE OKC_API.G_EXCEPTION_ERROR;
620: END IF;
621:

Line 619: RAISE OKC_API.G_EXCEPTION_ERROR;

615: THEN
616: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
617: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
618: THEN
619: RAISE OKC_API.G_EXCEPTION_ERROR;
620: END IF;
621:
622: l_top_base_line_id := x_clev_rec.id;
623:

Line 636: OKC_API.G_MISS_NUM;

632: l_config_rec.inventory_item_id;
633: cz_track_tbl(l_config_rec.config_item_id).id :=
634: l_top_base_line_id;
635: cz_track_tbl(l_config_rec.config_item_id).chr_id :=
636: OKC_API.G_MISS_NUM;
637: cz_track_tbl(l_config_rec.config_item_id).dnz_chr_id :=
638: p_au_line_rec.dnz_chr_id;
639: cz_track_tbl(l_config_rec.config_item_id).cle_id :=
640: l_top_model_line_id;

Line 669: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR

665: END LOOP; -- end of message count loop
666: END IF;
667:
668: -- Check Return Status
669: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
670: THEN
671: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
672: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
673: THEN

Line 671: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

667:
668: -- Check Return Status
669: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
670: THEN
671: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
672: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
673: THEN
674: RAISE OKC_API.G_EXCEPTION_ERROR;
675: END IF;

Line 672: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR

668: -- Check Return Status
669: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
670: THEN
671: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
672: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
673: THEN
674: RAISE OKC_API.G_EXCEPTION_ERROR;
675: END IF;
676:

Line 674: RAISE OKC_API.G_EXCEPTION_ERROR;

670: THEN
671: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
672: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
673: THEN
674: RAISE OKC_API.G_EXCEPTION_ERROR;
675: END IF;
676:
677: -- -----------------------------------------------------------------
678: -- STEP.2.3: DEBUG: 500 series

Line 699: p_init_msg_list => OKC_API.G_FALSE,

695: END IF;
696:
697: OKC_CONTRACT_ITEM_PUB.create_contract_item
698: ( p_api_version => 1,
699: p_init_msg_list => OKC_API.G_FALSE,
700: x_return_status => x_return_status,
701: x_msg_count => x_msg_count,
702: x_msg_data => x_msg_data,
703: p_cimv_rec => l_cimv_rec,

Line 727: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR

723: END LOOP; -- end of message count loop
724: END IF;
725:
726: -- Check Return Status
727: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
728: THEN
729: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
730: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
731: THEN

Line 729: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

725:
726: -- Check Return Status
727: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
728: THEN
729: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
730: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
731: THEN
732: RAISE OKC_API.G_EXCEPTION_ERROR;
733: END IF;

Line 730: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR

726: -- Check Return Status
727: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
728: THEN
729: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
730: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
731: THEN
732: RAISE OKC_API.G_EXCEPTION_ERROR;
733: END IF;
734:

Line 732: RAISE OKC_API.G_EXCEPTION_ERROR;

728: THEN
729: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
730: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
731: THEN
732: RAISE OKC_API.G_EXCEPTION_ERROR;
733: END IF;
734:
735: ELSE
736: -- -------------------------------------------------------

Line 777: OKC_API.SET_MESSAGE( p_app_name => 'OKC',

773: -- Item name cannot be found in the selected linestyle source
774: -- Stop processing further, return control to authoring form.
775: ROLLBACK TO SAVEPOINT build_cle_from_cz;
776:
777: OKC_API.SET_MESSAGE( p_app_name => 'OKC',
778: p_msg_name => 'OKC_CONFIG_ERROR',
779: p_token1 => 'PROCEDURE',
780: p_token1_value => 'validating linestyle based source item.');
781:

Line 783: x_return_status := OKC_API.G_RET_STS_ERROR;

779: p_token1 => 'PROCEDURE',
780: p_token1_value => 'validating linestyle based source item.');
781:
782: -- notify caller of an error
783: x_return_status := OKC_API.G_RET_STS_ERROR;
784:
785: RAISE OKC_API.G_EXCEPTION_ERROR;
786: END IF;
787: -- ----------------------------------------------------------------

Line 785: RAISE OKC_API.G_EXCEPTION_ERROR;

781:
782: -- notify caller of an error
783: x_return_status := OKC_API.G_RET_STS_ERROR;
784:
785: RAISE OKC_API.G_EXCEPTION_ERROR;
786: END IF;
787: -- ----------------------------------------------------------------
788:
789: -- -----------------------------------------------------------------

Line 869: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR

865: END LOOP; -- end of message count loop
866: END IF;
867:
868: -- Check Return Status
869: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
870: THEN
871: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
872: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
873: THEN

Line 871: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

867:
868: -- Check Return Status
869: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
870: THEN
871: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
872: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
873: THEN
874: RAISE OKC_API.G_EXCEPTION_ERROR;
875: END IF;

Line 872: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR

868: -- Check Return Status
869: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
870: THEN
871: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
872: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
873: THEN
874: RAISE OKC_API.G_EXCEPTION_ERROR;
875: END IF;
876:

Line 874: RAISE OKC_API.G_EXCEPTION_ERROR;

870: THEN
871: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
872: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
873: THEN
874: RAISE OKC_API.G_EXCEPTION_ERROR;
875: END IF;
876:
877: l_config_line_id := x_clev_rec.id;
878:

Line 892: OKC_API.G_MISS_NUM;

888: l_config_rec.inventory_item_id;
889: cz_track_tbl(l_config_rec.config_item_id).id :=
890: l_config_line_id;
891: cz_track_tbl(l_config_rec.config_item_id).chr_id :=
892: OKC_API.G_MISS_NUM;
893: cz_track_tbl(l_config_rec.config_item_id).cle_id :=
894: cz_track_tbl(l_config_rec.parent_config_item_id).id;
895: cz_track_tbl(l_config_rec.config_item_id).top_model_line_id :=
896: l_top_model_line_id;

Line 929: p_init_msg_list => OKC_API.G_FALSE,

925: END IF;
926:
927: OKC_CONTRACT_ITEM_PUB.create_contract_item
928: ( p_api_version => 1,
929: p_init_msg_list => OKC_API.G_FALSE,
930: x_return_status => x_return_status,
931: x_msg_count => x_msg_count,
932: x_msg_data => x_msg_data,
933: p_cimv_rec => l_cimv_rec,

Line 957: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR

953: END LOOP; -- end of message count loop
954: END IF;
955:
956: -- Check Return Status
957: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
958: THEN
959: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
960: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
961: THEN

Line 959: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

955:
956: -- Check Return Status
957: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
958: THEN
959: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
960: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
961: THEN
962: RAISE OKC_API.G_EXCEPTION_ERROR;
963: END IF;

Line 960: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR

956: -- Check Return Status
957: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
958: THEN
959: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
960: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
961: THEN
962: RAISE OKC_API.G_EXCEPTION_ERROR;
963: END IF;
964:

Line 962: RAISE OKC_API.G_EXCEPTION_ERROR;

958: THEN
959: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
960: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
961: THEN
962: RAISE OKC_API.G_EXCEPTION_ERROR;
963: END IF;
964:
965: END IF;
966: END LOOP;

Line 1057: p_init_msg_list => OKC_API.G_FALSE,

1053: END IF;
1054:
1055: OKC_PRICE_PVT.CALCULATE_PRICE(
1056: p_api_version => 1,
1057: p_init_msg_list => OKC_API.G_FALSE,
1058: p_chr_id => l_chr_id,
1059: p_Control_Rec => l_control_rec,
1060: px_req_line_tbl => l_req_line_tbl,
1061: px_Req_qual_tbl => l_req_line_qual_tbl,

Line 1090: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR

1086: END LOOP; -- end of message count loop
1087: END IF;
1088:
1089: -- Check Return Status
1090: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
1091: THEN
1092: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1093: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
1094: THEN

Line 1092: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1088:
1089: -- Check Return Status
1090: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
1091: THEN
1092: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1093: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
1094: THEN
1095: RAISE OKC_API.G_EXCEPTION_ERROR;
1096: END IF; -- end of ret status validation

Line 1093: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR

1089: -- Check Return Status
1090: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
1091: THEN
1092: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1093: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
1094: THEN
1095: RAISE OKC_API.G_EXCEPTION_ERROR;
1096: END IF; -- end of ret status validation
1097:

Line 1095: RAISE OKC_API.G_EXCEPTION_ERROR;

1091: THEN
1092: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1093: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
1094: THEN
1095: RAISE OKC_API.G_EXCEPTION_ERROR;
1096: END IF; -- end of ret status validation
1097:
1098: l_tot_negotiated := 0;
1099: l_tot_list_price := 0;

Line 1208: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR

1204: END LOOP; -- end of message count loop
1205: END IF;
1206:
1207: -- Check Return Status
1208: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
1209: THEN
1210: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1211: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
1212: THEN

Line 1210: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1206:
1207: -- Check Return Status
1208: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
1209: THEN
1210: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1211: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
1212: THEN
1213: RAISE OKC_API.G_EXCEPTION_ERROR;
1214: END IF; -- return status

Line 1211: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR

1207: -- Check Return Status
1208: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
1209: THEN
1210: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1211: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
1212: THEN
1213: RAISE OKC_API.G_EXCEPTION_ERROR;
1214: END IF; -- return status
1215:

Line 1213: RAISE OKC_API.G_EXCEPTION_ERROR;

1209: THEN
1210: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1211: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
1212: THEN
1213: RAISE OKC_API.G_EXCEPTION_ERROR;
1214: END IF; -- return status
1215:
1216: END LOOP; -- l_cle_price_table rows
1217: END IF;

Line 1313: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR

1309: END LOOP; -- end of message count loop
1310: END IF;
1311:
1312: -- Check Return Status
1313: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
1314: THEN
1315: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1316: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
1317: THEN

Line 1315: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1311:
1312: -- Check Return Status
1313: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
1314: THEN
1315: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1316: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
1317: THEN
1318: RAISE OKC_API.G_EXCEPTION_ERROR;
1319: END IF; -- return status

Line 1316: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR

1312: -- Check Return Status
1313: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
1314: THEN
1315: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1316: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
1317: THEN
1318: RAISE OKC_API.G_EXCEPTION_ERROR;
1319: END IF; -- return status
1320:

Line 1318: RAISE OKC_API.G_EXCEPTION_ERROR;

1314: THEN
1315: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1316: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
1317: THEN
1318: RAISE OKC_API.G_EXCEPTION_ERROR;
1319: END IF; -- return status
1320:
1321: -- ----------------------------------------------------------
1322: -- Populate the Configured model final rollup totals

Line 1337: OKC_API.END_ACTIVITY( x_msg_count => x_msg_count,

1333: END IF;
1334: -- -------------------------------------------------------------------
1335:
1336: -- end activity
1337: OKC_API.END_ACTIVITY( x_msg_count => x_msg_count,
1338: x_msg_data => x_msg_data);
1339:
1340: IF (l_debug = 'Y') THEN
1341: OKC_DEBUG.log('5999: Exiting build_cle_from_cz...', 2);

Line 1346: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1342: OKC_DEBUG.Reset_Indentation;
1343: END IF;
1344:
1345: EXCEPTION
1346: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1347: IF (l_debug = 'Y') THEN
1348: OKC_DEBUG.log('5999:Exception Error in Build Cle...', 2);
1349: OKC_DEBUG.Reset_Indentation;
1350: END IF;

Line 1357: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1353: THEN
1354: CLOSE cur_cle_ins;
1355: END IF;
1356:
1357: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1358: p_api_name => l_api_name,
1359: p_pkg_name => G_PKG_NAME,
1360: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1361: x_msg_count => x_msg_count,

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

1356:
1357: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1358: p_api_name => l_api_name,
1359: p_pkg_name => G_PKG_NAME,
1360: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1361: x_msg_count => x_msg_count,
1362: x_msg_data => x_msg_data,
1363: p_api_type => G_API_TYPE);
1364:

Line 1365: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1361: x_msg_count => x_msg_count,
1362: x_msg_data => x_msg_data,
1363: p_api_type => G_API_TYPE);
1364:
1365: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1366: IF (l_debug = 'Y') THEN
1367: OKC_DEBUG.log('5999:Unexpected Error in Build Cle...', 2);
1368: OKC_DEBUG.Reset_Indentation;
1369: END IF;

Line 1376: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1372: THEN
1373: CLOSE cur_cle_ins;
1374: END IF;
1375:
1376: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1377: p_api_name => l_api_name,
1378: p_pkg_name => G_PKG_NAME,
1379: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1380: x_msg_count => x_msg_count,

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

1375:
1376: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1377: p_api_name => l_api_name,
1378: p_pkg_name => G_PKG_NAME,
1379: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1380: x_msg_count => x_msg_count,
1381: x_msg_data => x_msg_data,
1382: p_api_type => G_API_TYPE);
1383: WHEN OTHERS THEN

Line 1394: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1390: THEN
1391: CLOSE cur_cle_ins;
1392: END IF;
1393:
1394: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1395: p_api_name => l_api_name,
1396: p_pkg_name => G_PKG_NAME,
1397: p_exc_name => 'OTHERS',
1398: x_msg_count => x_msg_count,

Line 1482: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1478: OKC_DEBUG.log('6000: Entering configuration_qa_check...', 2);
1479: END IF;
1480:
1481: -- initialize return status.
1482: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1483:
1484: -- ----------------------------------------------------
1485: -- Config Validation is to be done only for OKC and OKO.
1486: -- ----------------------------------------------------

Line 1537: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS

1533: l_line_index := OKC_CONTRACT_PUB.get_concat_line_no
1534: (l_line_id,
1535: l_return_status);
1536:
1537: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
1538: THEN
1539: l_line_index := 'Unknown';
1540: END IF;
1541:

Line 1566: OKC_API.set_message(

1562: -- Flag this configured model as invalid and incomplete
1563: IF (l_debug = 'Y') THEN
1564: OKC_DEBUG.log('6080: Config Invalid and Incomplete');
1565: END IF;
1566: OKC_API.set_message(
1567: p_app_name => G_APP_NAME,
1568: p_msg_name => 'OKC_CONFIG_INV_INC',
1569: p_token1 => 'CFG_INFO',
1570: p_token1_value => l_msg_token);

Line 1578: OKC_API.set_message(

1574: -- Flag this configured model as invalid
1575: IF (l_debug = 'Y') THEN
1576: OKC_DEBUG.log('6090: Config Invalid ');
1577: END IF;
1578: OKC_API.set_message(
1579: p_app_name => G_APP_NAME,
1580: p_msg_name => 'OKC_CONFIG_INVALID',
1581: p_token1 => 'CFG_INFO',
1582: p_token1_value => l_msg_token);

Line 1589: OKC_API.set_message(

1585: -- Flag this configured model as incomplete
1586: IF (l_debug = 'Y') THEN
1587: OKC_DEBUG.log('6100: Config Incomplete ');
1588: END IF;
1589: OKC_API.set_message(
1590: p_app_name => G_APP_NAME,
1591: p_msg_name => 'OKC_CONFIG_INCOMPLETE',
1592: p_token1 => 'CFG_INFO',
1593: p_token1_value => l_msg_token);

Line 1599: x_return_status := OKC_API.G_RET_STS_ERROR;

1595: END LOOP;
1596: CLOSE get_cfg_line_info;
1597:
1598: -- Set the error return status
1599: x_return_status := OKC_API.G_RET_STS_ERROR;
1600: RAISE G_EXCEPTION_HALT_VALIDATION;
1601:
1602: ELSE
1603: -- This is a normal and valid contract.

Line 1605: OKC_API.set_message(

1601:
1602: ELSE
1603: -- This is a normal and valid contract.
1604: -- notify caller of qa success
1605: OKC_API.set_message(
1606: p_app_name => G_APP_NAME,
1607: p_msg_name => G_QA_SUCCESS);
1608: END IF;
1609:

Line 1630: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1626: OKC_DEBUG.Reset_Indentation;
1627: END IF;
1628:
1629: -- notify caller of an error as UNEXPETED error
1630: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1631:
1632: OKC_API.set_message(
1633: p_app_name => G_APP_NAME,
1634: p_msg_name => G_UNEXPECTED_ERROR,

Line 1632: OKC_API.set_message(

1628:
1629: -- notify caller of an error as UNEXPETED error
1630: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1631:
1632: OKC_API.set_message(
1633: p_app_name => G_APP_NAME,
1634: p_msg_name => G_UNEXPECTED_ERROR,
1635: p_token1 => G_SQLCODE_TOKEN,
1636: p_token1_value => SQLCODE,

Line 1880: p_init_msg_list => OKC_API.G_FALSE,

1876: END IF;
1877:
1878: OKC_PRICE_PVT.CALCULATE_PRICE(
1879: p_api_version => 1,
1880: p_init_msg_list => OKC_API.G_FALSE,
1881: p_chr_id => l_chr_id,
1882: p_Control_Rec => l_control_rec,
1883: px_req_line_tbl => l_req_line_tbl,
1884: px_Req_qual_tbl => l_req_line_qual_tbl,

Line 1920: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR

1916: END LOOP; -- end of message count loop
1917: END IF;
1918:
1919: -- Check Return Status
1920: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
1921: THEN
1922: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1923: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
1924: THEN

Line 1922: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1918:
1919: -- Check Return Status
1920: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
1921: THEN
1922: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1923: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
1924: THEN
1925: RAISE OKC_API.G_EXCEPTION_ERROR;
1926: END IF; -- end of ret status validation

Line 1923: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR

1919: -- Check Return Status
1920: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR
1921: THEN
1922: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1923: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
1924: THEN
1925: RAISE OKC_API.G_EXCEPTION_ERROR;
1926: END IF; -- end of ret status validation
1927:

Line 1925: RAISE OKC_API.G_EXCEPTION_ERROR;

1921: THEN
1922: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1923: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR
1924: THEN
1925: RAISE OKC_API.G_EXCEPTION_ERROR;
1926: END IF; -- end of ret status validation
1927:
1928: l_total_price := 0;
1929: IF l_cle_price_tbl.count > 0

Line 1996: -- RAISE OKC_API.G_EXCEPTION_ERROR;

1992: -- FROM okx_config_pricing_v
1993: -- WHERE configurator_session_key = p_config_session_key ;
1994: -- EXCEPTION
1995: -- WHEN OTHERS THEN
1996: -- RAISE OKC_API.G_EXCEPTION_ERROR;
1997: -- END;
1998: -- -------------------------------------------------------------
1999:
2000: IF (l_debug = 'Y') THEN

Line 2139: IF x_ret_status <> OKC_API.G_RET_STS_SUCCESS

2135:
2136: END IF;
2137:
2138:
2139: IF x_ret_status <> OKC_API.G_RET_STS_SUCCESS
2140: THEN
2141: -- This is an error condition for copy configuration
2142: IF (l_debug = 'Y') THEN
2143: OKC_DEBUG.log('9250: Error in Copy Configuration...'||x_err_msg);

Line 2145: RAISE OKC_API.G_EXCEPTION_ERROR;

2141: -- This is an error condition for copy configuration
2142: IF (l_debug = 'Y') THEN
2143: OKC_DEBUG.log('9250: Error in Copy Configuration...'||x_err_msg);
2144: END IF;
2145: RAISE OKC_API.G_EXCEPTION_ERROR;
2146: ELSE
2147: -- --------------------------------------------------------
2148: -- CZ Copy config returned success.
2149: -- Update contract lines for this config with new pointers

Line 2230: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2226: OKC_DEBUG.Reset_Indentation;
2227: END IF;
2228:
2229: EXCEPTION
2230: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2231: IF (l_debug = 'Y') THEN
2232: OKC_DEBUG.log('5999:Exception Error in Copy Config...', 2);
2233: OKC_DEBUG.Reset_Indentation;
2234: END IF;

Line 2254: OKC_API.set_message(

2250: THEN
2251: CLOSE cur_get_top_models;
2252: END IF;
2253:
2254: OKC_API.set_message(
2255: p_app_name => G_APP_NAME,
2256: p_msg_name => G_UNEXPECTED_ERROR,
2257: p_token1 => G_SQLCODE_TOKEN,
2258: p_token1_value => SQLCODE,