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.OE_CONTRACTS_UTIL dependencies on OE_CONTRACTS_UTIL

Line 1: PACKAGE BODY OE_Contracts_util AS

1: PACKAGE BODY OE_Contracts_util AS
2: /* $Header: OEXUOKCB.pls 120.4.12010000.2 2008/11/12 12:36:53 smanian ship $ */
3:
4: --ETR
5: ------------------------------------------------------------------------------

Line 15: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Contracts_Util';

11: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
12: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
13: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
14:
15: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Contracts_Util';
16: --ETR
17:
18: G_CURRENT_VERSION_NUMBER CONSTANT NUMBER := -99; /* Note: the contract document attachment creation java API always creates the current
19: version of the attachment as -99 during the workflow approval process.

Line 30: RETURN (OE_Contracts_util.G_BSA_DOC_TYPE);

26: the PL/SQL version used in forms does not allow direct reference to G_BSA_DOC_TYPE */
27: FUNCTION get_G_BSA_DOC_TYPE
28: RETURN VARCHAR2 IS
29: BEGIN
30: RETURN (OE_Contracts_util.G_BSA_DOC_TYPE);
31: END;
32:
33:
34: /* this function is used to simply return the value of G_SO_DOC_TYPE

Line 40: RETURN (OE_Contracts_util.G_SO_DOC_TYPE);

36: the PL/SQL version used in forms does not allow direct reference to G_SO_DOC_TYPE */
37: FUNCTION get_G_SO_DOC_TYPE
38: RETURN VARCHAR2 IS
39: BEGIN
40: RETURN (OE_Contracts_util.G_SO_DOC_TYPE);
41: END;
42:
43:
44: FUNCTION check_license

Line 57: oe_debug_pub.add('In OE_Contracts_util.check_license', 1);

53: lx_oracle_schema VARCHAR2(30);
54:
55: BEGIN
56: IF l_debug_level > 0 THEN
57: oe_debug_pub.add('In OE_Contracts_util.check_license', 1);
58: END IF;
59:
60: IF OE_CONTRACTS_UTIL.G_CNTR_LICENSED IS NULL OR
61: OE_CONTRACTS_UTIL.G_CNTR_LICENSED NOT IN ('Y','N') THEN

Line 60: IF OE_CONTRACTS_UTIL.G_CNTR_LICENSED IS NULL OR

56: IF l_debug_level > 0 THEN
57: oe_debug_pub.add('In OE_Contracts_util.check_license', 1);
58: END IF;
59:
60: IF OE_CONTRACTS_UTIL.G_CNTR_LICENSED IS NULL OR
61: OE_CONTRACTS_UTIL.G_CNTR_LICENSED NOT IN ('Y','N') THEN
62: --this is the first time this check is being performed
63:
64: --first verify if contracts is installed

Line 61: OE_CONTRACTS_UTIL.G_CNTR_LICENSED NOT IN ('Y','N') THEN

57: oe_debug_pub.add('In OE_Contracts_util.check_license', 1);
58: END IF;
59:
60: IF OE_CONTRACTS_UTIL.G_CNTR_LICENSED IS NULL OR
61: OE_CONTRACTS_UTIL.G_CNTR_LICENSED NOT IN ('Y','N') THEN
62: --this is the first time this check is being performed
63:
64: --first verify if contracts is installed
65: l_dummy := FND_INSTALLATION.get_app_info (

Line 87: OE_CONTRACTS_UTIL.G_CNTR_LICENSED := 'Y';

83: oe_debug_pub.add('l_sales_contracts_enabled: ' || l_sales_contracts_enabled, 3);
84: END IF;
85:
86: IF l_sales_contracts_enabled = 'Y' THEN
87: OE_CONTRACTS_UTIL.G_CNTR_LICENSED := 'Y';
88: RETURN 'Y';
89: ELSIF l_sales_contracts_enabled = 'N' THEN
90: OE_CONTRACTS_UTIL.G_CNTR_LICENSED := 'N';
91: RETURN 'N';

Line 90: OE_CONTRACTS_UTIL.G_CNTR_LICENSED := 'N';

86: IF l_sales_contracts_enabled = 'Y' THEN
87: OE_CONTRACTS_UTIL.G_CNTR_LICENSED := 'Y';
88: RETURN 'Y';
89: ELSIF l_sales_contracts_enabled = 'N' THEN
90: OE_CONTRACTS_UTIL.G_CNTR_LICENSED := 'N';
91: RETURN 'N';
92: ELSE
93: OE_CONTRACTS_UTIL.G_CNTR_LICENSED := 'N';
94: RETURN 'N';

Line 93: OE_CONTRACTS_UTIL.G_CNTR_LICENSED := 'N';

89: ELSIF l_sales_contracts_enabled = 'N' THEN
90: OE_CONTRACTS_UTIL.G_CNTR_LICENSED := 'N';
91: RETURN 'N';
92: ELSE
93: OE_CONTRACTS_UTIL.G_CNTR_LICENSED := 'N';
94: RETURN 'N';
95: END IF;
96:
97: ELSE

Line 99: OE_CONTRACTS_UTIL.G_CNTR_LICENSED := 'N';

95: END IF;
96:
97: ELSE
98: --contracts is not installed at all
99: OE_CONTRACTS_UTIL.G_CNTR_LICENSED := 'N';
100: IF l_debug_level > 0 THEN
101: oe_debug_pub.add('Contracts is not installed at all, returning ''N''', 3);
102: END IF;
103: RETURN 'N';

Line 110: oe_debug_pub.add('cache already has value, OE_CONTRACTS_UTIL.G_BSA_CNTR_LICENSE: ' ||OE_CONTRACTS_UTIL.G_CNTR_LICENSED, 3);

106:
107: -- we have already performed the license check earlier so reuse the cache
108: ELSE
109: IF l_debug_level > 0 THEN
110: oe_debug_pub.add('cache already has value, OE_CONTRACTS_UTIL.G_BSA_CNTR_LICENSE: ' ||OE_CONTRACTS_UTIL.G_CNTR_LICENSED, 3);
111: END IF;
112:
113: RETURN OE_CONTRACTS_UTIL.G_CNTR_LICENSED;
114: END IF;

Line 113: RETURN OE_CONTRACTS_UTIL.G_CNTR_LICENSED;

109: IF l_debug_level > 0 THEN
110: oe_debug_pub.add('cache already has value, OE_CONTRACTS_UTIL.G_BSA_CNTR_LICENSE: ' ||OE_CONTRACTS_UTIL.G_CNTR_LICENSED, 3);
111: END IF;
112:
113: RETURN OE_CONTRACTS_UTIL.G_CNTR_LICENSED;
114: END IF;
115:
116:
117: IF l_debug_level > 0 THEN

Line 118: oe_debug_pub.add('End of OE_Contracts_util.check_license', 1);

114: END IF;
115:
116:
117: IF l_debug_level > 0 THEN
118: oe_debug_pub.add('End of OE_Contracts_util.check_license', 1);
119: END IF;
120:
121: EXCEPTION
122: WHEN OTHERS THEN

Line 171: oe_debug_pub.add('In OE_Contracts_util.copy_articles ', 1);

167:
168: BEGIN
169:
170: IF l_debug_level > 0 THEN
171: oe_debug_pub.add('In OE_Contracts_util.copy_articles ', 1);
172: END IF;
173:
174:
175: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 183: IF OE_Contracts_util.check_license() <> 'Y' THEN

179: END IF;
180:
181:
182: --Check for licensing
183: IF OE_Contracts_util.check_license() <> 'Y' THEN
184: IF l_debug_level > 0 THEN
185: oe_debug_pub.add('Contractual option not licensed, hence not performing copy ', 3);
186: END IF;
187: RETURN;

Line 196: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

192: IF p_version_number IS NOT NULL THEN
193: oe_debug_pub.add('Checking for latest version number for for p_doc_type: '|| p_doc_type
194: || ' and p_copy_from_doc_id: ' || p_copy_from_doc_id, 3);
195:
196: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
197: SELECT version_number
198: INTO l_latest_version_number
199: FROM oe_blanket_headers_all
200: WHERE header_id = p_copy_from_doc_id;

Line 202: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

198: INTO l_latest_version_number
199: FROM oe_blanket_headers_all
200: WHERE header_id = p_copy_from_doc_id;
201:
202: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
203: SELECT version_number
204: INTO l_latest_version_number
205: FROM oe_order_headers_all
206: WHERE header_id = p_copy_from_doc_id;

Line 312: oe_debug_pub.add('End of OE_Contracts_util.copy_articles, x_return_status ' || x_return_status, 1);

308: END IF;
309:
310:
311: IF l_debug_level > 0 THEN
312: oe_debug_pub.add('End of OE_Contracts_util.copy_articles, x_return_status ' || x_return_status, 1);
313: END IF;
314:
315: EXCEPTION
316: WHEN FND_API.G_EXC_ERROR THEN

Line 416: oe_debug_pub.add('In OE_Contracts_util.version_articles ', 1);

412:
413: BEGIN
414:
415: IF l_debug_level > 0 THEN
416: oe_debug_pub.add('In OE_Contracts_util.version_articles ', 1);
417: END IF;
418:
419: x_return_status := FND_API.G_RET_STS_SUCCESS;
420:

Line 427: IF OE_Contracts_util.check_license() <> 'Y' THEN

423: END IF;
424:
425:
426: --Check for licensing
427: IF OE_Contracts_util.check_license() <> 'Y' THEN
428: IF l_debug_level > 0 THEN
429: oe_debug_pub.add('Contractual option not licensed, hence not performing versioning ', 3);
430: END IF;
431: RETURN;

Line 471: oe_debug_pub.add('End of OE_Contracts_util.version_articles , x_return_status ' || x_return_status, 1);

467: END IF;
468: --ETR
469:
470: IF l_debug_level > 0 THEN
471: oe_debug_pub.add('End of OE_Contracts_util.version_articles , x_return_status ' || x_return_status, 1);
472: END IF;
473:
474: EXCEPTION
475: WHEN FND_API.G_EXC_ERROR THEN

Line 590: oe_debug_pub.add('In OE_Contracts_util.qa_articles ', 1);

586:
587: BEGIN
588:
589: IF l_debug_level > 0 THEN
590: oe_debug_pub.add('In OE_Contracts_util.qa_articles ', 1);
591: END IF;
592:
593: x_return_status := FND_API.G_RET_STS_SUCCESS;
594:

Line 601: IF OE_Contracts_util.check_license() <> 'Y' THEN

597: END IF;
598:
599:
600: --Check for licensing
601: IF OE_Contracts_util.check_license() <> 'Y' THEN
602: IF l_debug_level > 0 THEN
603: oe_debug_pub.add('Contractual option not licensed, hence not performing article QA ', 3);
604: END IF;
605: RETURN;

Line 609: IF p_doc_type = OE_CONTRACTS_UTIL.get_G_SO_DOC_TYPE() THEN

605: RETURN;
606: END IF;
607:
608: --ETR
609: IF p_doc_type = OE_CONTRACTS_UTIL.get_G_SO_DOC_TYPE() THEN
610: IF l_debug_level > 0 THEN
611: oe_debug_pub.add('Calling OE_CONTRACTS_UTIL_GRP.is_order_signed ', 3);
612: oe_debug_pub.add('p_api_version: ' || p_api_version,3);
613: oe_debug_pub.add('p_init_msg_list: ' || p_init_msg_list,3);

Line 611: oe_debug_pub.add('Calling OE_CONTRACTS_UTIL_GRP.is_order_signed ', 3);

607:
608: --ETR
609: IF p_doc_type = OE_CONTRACTS_UTIL.get_G_SO_DOC_TYPE() THEN
610: IF l_debug_level > 0 THEN
611: oe_debug_pub.add('Calling OE_CONTRACTS_UTIL_GRP.is_order_signed ', 3);
612: oe_debug_pub.add('p_api_version: ' || p_api_version,3);
613: oe_debug_pub.add('p_init_msg_list: ' || p_init_msg_list,3);
614: oe_debug_pub.add('p_doc_type: ' || p_doc_type,3);
615: oe_debug_pub.add('p_doc_id: ' || p_doc_id,3);

Line 619: l_order_signed := oe_contracts_util.is_order_signed (

615: oe_debug_pub.add('p_doc_id: ' || p_doc_id,3);
616: END IF;
617:
618: --Check whether Order already signed ; if signed, QA already performed
619: l_order_signed := oe_contracts_util.is_order_signed (
620: p_api_version => p_api_version,
621: p_init_msg_list => p_init_msg_list,
622: p_doc_id => p_doc_id,
623: x_return_status => x_return_status,

Line 681: OE_CONTRACTS_UTIL.get_contract_details_all (

677: --ETR
678:
679: IF l_article_exist <> OKC_TERMS_UTIL_GRP.G_NO_ARTICLE_EXIST THEN --i.e. 'NONE'
680: --i.e. proceed with articles QA process only if articles exist for the BSA
681: OE_CONTRACTS_UTIL.get_contract_details_all (
682: p_api_version => 1.0,
683: p_init_msg_list => 'F',
684: p_doc_type => p_doc_type,
685: p_doc_id => p_doc_id,

Line 715: IF p_doc_type = OE_CONTRACTS_UTIL.get_G_SO_DOC_TYPE() then

711: END IF;
712: --p_run_expert_flag added for fix 5186582 to skip expert validations in Quote to order
713:
714: --bug6318133
715: IF p_doc_type = OE_CONTRACTS_UTIL.get_G_SO_DOC_TYPE() then
716: l_run_expert_flag := 'N';
717: ELSE
718: l_run_expert_flag := 'Y';
719: END IF;

Line 795: oe_debug_pub.add('End of OE_Contracts_util.qa_articles , x_return_status ' || x_return_status, 1);

791: END IF;
792:
793:
794: IF l_debug_level > 0 THEN
795: oe_debug_pub.add('End of OE_Contracts_util.qa_articles , x_return_status ' || x_return_status, 1);
796: END IF;
797:
798: EXCEPTION
799: WHEN FND_API.G_EXC_ERROR THEN

Line 899: oe_debug_pub.add('In OE_Contracts_util.non_standard_article_exists ', 1);

895: l_article_type VARCHAR2(50);
896: BEGIN
897:
898: IF l_debug_level > 0 THEN
899: oe_debug_pub.add('In OE_Contracts_util.non_standard_article_exists ', 1);
900: oe_debug_pub.add('p_api_version: ' || p_api_version,3);
901: oe_debug_pub.add('p_init_msg_list: ' || p_init_msg_list,3);
902: oe_debug_pub.add('Calling OKC_TERMS_UTIL_GRP.is_article_exist',3);
903: oe_debug_pub.add('p_doc_type: ' || p_doc_type,3);

Line 910: IF OE_Contracts_util.check_license() <> 'Y' THEN

906:
907: x_return_status := FND_API.G_RET_STS_SUCCESS;
908:
909: --Check for licensing
910: IF OE_Contracts_util.check_license() <> 'Y' THEN
911: IF l_debug_level > 0 THEN
912: oe_debug_pub.add('Contractual option not licensed, hence not performing non_standard_article_exists check ', 3);
913: END IF;
914: ---RETURN NULL;

Line 944: oe_debug_pub.add('End of OE_Contracts_util.non_standard_article_exists , returning Y');

940: --ETR
941:
942: IF l_article_type = OKC_TERMS_UTIL_GRP.G_NON_STANDARD_ART_EXIST THEN --i.e. 'NON_STANDARD_EXIST'
943: IF l_debug_level > 0 THEN
944: oe_debug_pub.add('End of OE_Contracts_util.non_standard_article_exists , returning Y');
945: END IF;
946: RETURN 'Y';
947: ELSE
948: IF l_debug_level > 0 THEN

Line 949: oe_debug_pub.add('End of OE_Contracts_util.non_standard_article_exists , returning N');

945: END IF;
946: RETURN 'Y';
947: ELSE
948: IF l_debug_level > 0 THEN
949: oe_debug_pub.add('End of OE_Contracts_util.non_standard_article_exists , returning N');
950: END IF;
951: RETURN 'N';
952: END IF;
953:

Line 1108: wf_core.context('OE_CONTRACTS_UTIL',

1104: IF l_debug_level > 0 THEN
1105: oe_debug_pub.add('In WHEN OTHERS: ', 3);
1106: END IF;
1107:
1108: wf_core.context('OE_CONTRACTS_UTIL',
1109: 'WF_non_standard_article_exists',
1110: itemtype,
1111: itemkey,
1112: to_char(actid),

Line 1191: oe_debug_pub.add('In OE_Contracts_util.attachment_location ', 1);

1187:
1188: BEGIN
1189:
1190: IF l_debug_level > 0 THEN
1191: oe_debug_pub.add('In OE_Contracts_util.attachment_location ', 1);
1192: oe_debug_pub.add('p_api_version: ' || p_api_version,3);
1193: oe_debug_pub.add('p_init_msg_list: ' || p_init_msg_list,3);
1194: oe_debug_pub.add('p_doc_type: '|| p_doc_type, 3);
1195: oe_debug_pub.add('p_doc_id: '|| p_doc_id, 3);

Line 1205: IF OE_Contracts_util.check_license() <> 'Y' THEN

1201: oe_msg_pub.initialize;
1202: END IF;
1203:
1204: --Check for licensing, proceed with procesing only if licensed
1205: IF OE_Contracts_util.check_license() <> 'Y' THEN
1206: IF l_debug_level > 0 THEN
1207: oe_debug_pub.add('Contractual option not licensed, hence exiting attachment_location ', 3);
1208: END IF;
1209: RETURN;

Line 1231: oe_debug_pub.add('Calling OE_Contracts_util.get_terms_template ', 3);

1227: END IF;
1228:
1229:
1230: IF l_debug_level > 0 THEN
1231: oe_debug_pub.add('Calling OE_Contracts_util.get_terms_template ', 3);
1232: oe_debug_pub.add('p_api_version: ' || p_api_version,3);
1233: oe_debug_pub.add('p_init_msg_list: ' || p_init_msg_list,3);
1234: oe_debug_pub.add('p_doc_type: '|| p_doc_type, 3);
1235: oe_debug_pub.add('p_doc_id: '|| p_doc_id, 3);

Line 1239: oe_contracts_util.get_terms_template (

1235: oe_debug_pub.add('p_doc_id: '|| p_doc_id, 3);
1236: END IF;
1237:
1238: --first determine whether any terms and conditions have been instantiated for the BSA or Sales Order
1239: oe_contracts_util.get_terms_template (
1240: p_api_version => 1.0,
1241: p_init_msg_list => p_init_msg_list,
1242:
1243: p_doc_type => p_doc_type,

Line 1264: IF OE_CONTRACTS_UTIL.Terms_Exists

1260: /*
1261: IF l_template_id IS NOT NULL THEN
1262: --terms and conditions do exist for the BSA or Sales Order so return contract attachment string to workflow request
1263: */
1264: IF OE_CONTRACTS_UTIL.Terms_Exists
1265: ( p_doc_type => p_doc_type
1266: , p_doc_id => p_doc_id) = 'Y' THEN
1267:
1268: /************

Line 1270: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

1266: , p_doc_id => p_doc_id) = 'Y' THEN
1267:
1268: /************
1269: --get the version number for pk3 of contract attachment entity OKC_CONTRACT_DOCS
1270: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
1271: IF c_get_bsa_version%ISOPEN THEN
1272: CLOSE c_get_bsa_version;
1273: END IF;
1274:

Line 1283: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

1279: IF l_debug_level > 0 THEN
1280: oe_debug_pub.add('l_doc_version_number of blanket: '|| l_doc_version_number, 3);
1281: END IF;
1282:
1283: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
1284: IF c_get_so_version%ISOPEN THEN
1285: CLOSE c_get_so_version;
1286: END IF;
1287:

Line 1321: oe_debug_pub.add('End of OE_Contracts_util.attachment_location, x_return_status ' || x_return_status, 1);

1317: END IF;
1318:
1319: IF l_debug_level > 0 THEN
1320: oe_debug_pub.add('l_workflow_string: '|| l_workflow_string, 3);
1321: oe_debug_pub.add('End of OE_Contracts_util.attachment_location, x_return_status ' || x_return_status, 1);
1322: END IF;
1323:
1324: x_workflow_string := l_workflow_string;
1325:

Line 1473: oe_debug_pub.add('In OE_Contracts_util.terms_exists ', 1);

1469: */
1470: BEGIN
1471:
1472: IF l_debug_level > 0 THEN
1473: oe_debug_pub.add('In OE_Contracts_util.terms_exists ', 1);
1474: END IF;
1475:
1476: --Check for licensing
1477: IF OE_Contracts_util.check_license() <> 'Y' THEN

Line 1477: IF OE_Contracts_util.check_license() <> 'Y' THEN

1473: oe_debug_pub.add('In OE_Contracts_util.terms_exists ', 1);
1474: END IF;
1475:
1476: --Check for licensing
1477: IF OE_Contracts_util.check_license() <> 'Y' THEN
1478: IF l_debug_level > 0 THEN
1479: oe_debug_pub.add('Contracts not licensed, exiting terms_exists', 3);
1480: END IF;
1481: --RETURN NULL;

Line 1487: oe_debug_pub.add('Calling OE_Contracts_util.has_terms ', 3);

1483: END IF;
1484:
1485:
1486: IF l_debug_level > 0 THEN
1487: oe_debug_pub.add('Calling OE_Contracts_util.has_terms ', 3);
1488: oe_debug_pub.add('p_doc_type: ' || p_doc_type,3);
1489: oe_debug_pub.add('p_doc_id: ' || p_doc_id,3);
1490: END IF;
1491:

Line 1493: /* oe_contracts_util.get_terms_template (

1489: oe_debug_pub.add('p_doc_id: ' || p_doc_id,3);
1490: END IF;
1491:
1492: --first determine whether any terms and conditions have been instantiated for the BSA or sales order
1493: /* oe_contracts_util.get_terms_template (
1494: p_api_version => 1.0,
1495:
1496: p_doc_type => p_doc_type,
1497: p_doc_id => p_doc_id,

Line 1516: oe_debug_pub.add('End of OE_Contracts_util.terms_exists , returning Y');

1512:
1513:
1514: IF l_template_id IS NOT NULL THEN
1515: IF l_debug_level > 0 THEN
1516: oe_debug_pub.add('End of OE_Contracts_util.terms_exists , returning Y');
1517: END IF;
1518: RETURN ('Y');
1519: ELSE
1520: IF l_debug_level > 0 THEN

Line 1521: oe_debug_pub.add('End of OE_Contracts_util.terms_exists , returning Y');

1517: END IF;
1518: RETURN ('Y');
1519: ELSE
1520: IF l_debug_level > 0 THEN
1521: oe_debug_pub.add('End of OE_Contracts_util.terms_exists , returning Y');
1522: END IF;
1523: RETURN ('N');
1524: END IF;*/
1525:

Line 1534: oe_debug_pub.add('End of OE_Contracts_util.terms_exists result is:'||l_result );

1530: p_document_id => p_doc_id
1531: );
1532:
1533: IF l_debug_level > 0 THEN
1534: oe_debug_pub.add('End of OE_Contracts_util.terms_exists result is:'||l_result );
1535: END IF;
1536:
1537: RETURN l_result;
1538:

Line 1580: oe_debug_pub.add('In OE_Contracts_util.delete_articles ', 1);

1576:
1577: BEGIN
1578:
1579: IF l_debug_level > 0 THEN
1580: oe_debug_pub.add('In OE_Contracts_util.delete_articles ', 1);
1581: END IF;
1582:
1583: x_return_status := FND_API.G_RET_STS_SUCCESS;
1584:

Line 1590: IF OE_Contracts_util.check_license() <> 'Y' THEN

1586: oe_msg_pub.initialize;
1587: END IF;
1588:
1589: --Check for licensing
1590: IF OE_Contracts_util.check_license() <> 'Y' THEN
1591: IF l_debug_level > 0 THEN
1592: oe_debug_pub.add('Contractual option not licensed, hence exiting delete_articles ', 3);
1593: END IF;
1594: RETURN;

Line 1632: oe_debug_pub.add('End of OE_Contracts_util.delete_articles, x_return_status ' || x_return_status, 1);

1628: END IF;
1629: --ETR
1630:
1631: IF l_debug_level > 0 THEN
1632: oe_debug_pub.add('End of OE_Contracts_util.delete_articles, x_return_status ' || x_return_status, 1);
1633: END IF;
1634:
1635: EXCEPTION
1636: WHEN FND_API.G_EXC_ERROR THEN

Line 1732: oe_debug_pub.add('In OE_Contracts_util.purge_articles ', 1);

1728:
1729: BEGIN
1730:
1731: IF l_debug_level > 0 THEN
1732: oe_debug_pub.add('In OE_Contracts_util.purge_articles ', 1);
1733: END IF;
1734:
1735: x_return_status := FND_API.G_RET_STS_SUCCESS;
1736:

Line 1742: IF OE_Contracts_util.check_license() <> 'Y' THEN

1738: oe_msg_pub.initialize;
1739: END IF;
1740:
1741: --Check for licensing
1742: IF OE_Contracts_util.check_license() <> 'Y' THEN
1743: IF l_debug_level > 0 THEN
1744: oe_debug_pub.add('Contractual option not licensed, hence exiting purge_articles ', 3);
1745: END IF;
1746: RETURN;

Line 1781: oe_debug_pub.add('End of OE_Contracts_util.purge_articles, x_return_status ' || x_return_status, 1);

1777: END IF;
1778: --ETR
1779:
1780: IF l_debug_level > 0 THEN
1781: oe_debug_pub.add('End of OE_Contracts_util.purge_articles, x_return_status ' || x_return_status, 1);
1782: END IF;
1783:
1784: EXCEPTION
1785: WHEN FND_API.G_EXC_ERROR THEN

Line 1942: oe_debug_pub.add('In OE_Contracts_util.get_article_variable_values for header level variables', 1);

1938:
1939: BEGIN
1940:
1941: IF l_debug_level > 0 THEN
1942: oe_debug_pub.add('In OE_Contracts_util.get_article_variable_values for header level variables', 1);
1943: oe_debug_pub.add('p_doc_type: ' || p_doc_type,3);
1944: oe_debug_pub.add('p_doc_id: ' || p_doc_id,3);
1945: END IF;
1946:

Line 1961: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

1957:
1958: ----IF p_sys_var_value_tbl.COUNT > 0 THEN
1959: IF p_sys_var_value_tbl.FIRST IS NOT NULL THEN
1960:
1961: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
1962:
1963: IF c_get_bsa_header_variables%ISOPEN THEN
1964: CLOSE c_get_bsa_header_variables;
1965: END IF;

Line 1974: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

1970: oe_debug_pub.add('c_get_bsa_header_variables%ROWCOUNT: ' || c_get_bsa_header_variables%ROWCOUNT, 3);
1971: END IF;
1972: CLOSE c_get_bsa_header_variables;
1973:
1974: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
1975:
1976: IF c_get_bsa_header_variables%ISOPEN THEN
1977: CLOSE c_get_so_header_variables;
1978: END IF;

Line 2002: IF p_doc_type = OE_CONTRACTS_UTIL.get_G_BSA_DOC_TYPE() THEN

1998: END;
1999:
2000: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_BLANKET_NUMBER' THEN
2001: BEGIN
2002: IF p_doc_type = OE_CONTRACTS_UTIL.get_G_BSA_DOC_TYPE() THEN
2003: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.order_number;
2004: ELSIF p_doc_type = OE_CONTRACTS_UTIL.get_G_SO_DOC_TYPE() THEN
2005: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.blanket_number;
2006: END IF;

Line 2004: ELSIF p_doc_type = OE_CONTRACTS_UTIL.get_G_SO_DOC_TYPE() THEN

2000: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_BLANKET_NUMBER' THEN
2001: BEGIN
2002: IF p_doc_type = OE_CONTRACTS_UTIL.get_G_BSA_DOC_TYPE() THEN
2003: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.order_number;
2004: ELSIF p_doc_type = OE_CONTRACTS_UTIL.get_G_SO_DOC_TYPE() THEN
2005: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.blanket_number;
2006: END IF;
2007: END;
2008:

Line 2011: IF p_doc_type = OE_CONTRACTS_UTIL.get_G_BSA_DOC_TYPE() THEN

2007: END;
2008:
2009: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_PA_NUMBER' THEN
2010: BEGIN
2011: IF p_doc_type = OE_CONTRACTS_UTIL.get_G_BSA_DOC_TYPE() THEN
2012: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.agreement_id;
2013: ELSIF p_doc_type = OE_CONTRACTS_UTIL.get_G_SO_DOC_TYPE() THEN
2014: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.agreement_id;
2015: END IF;

Line 2013: ELSIF p_doc_type = OE_CONTRACTS_UTIL.get_G_SO_DOC_TYPE() THEN

2009: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_PA_NUMBER' THEN
2010: BEGIN
2011: IF p_doc_type = OE_CONTRACTS_UTIL.get_G_BSA_DOC_TYPE() THEN
2012: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.agreement_id;
2013: ELSIF p_doc_type = OE_CONTRACTS_UTIL.get_G_SO_DOC_TYPE() THEN
2014: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.agreement_id;
2015: END IF;
2016: END;
2017:

Line 2020: IF p_doc_type = OE_CONTRACTS_UTIL.get_G_BSA_DOC_TYPE() THEN

2016: END;
2017:
2018: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_PA_NAME' THEN
2019: BEGIN
2020: IF p_doc_type = OE_CONTRACTS_UTIL.get_G_BSA_DOC_TYPE() THEN
2021: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.agreement_id;
2022: ELSIF p_doc_type = OE_CONTRACTS_UTIL.get_G_SO_DOC_TYPE() THEN
2023: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.agreement_id;
2024: END IF;

Line 2022: ELSIF p_doc_type = OE_CONTRACTS_UTIL.get_G_SO_DOC_TYPE() THEN

2018: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_PA_NAME' THEN
2019: BEGIN
2020: IF p_doc_type = OE_CONTRACTS_UTIL.get_G_BSA_DOC_TYPE() THEN
2021: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.agreement_id;
2022: ELSIF p_doc_type = OE_CONTRACTS_UTIL.get_G_SO_DOC_TYPE() THEN
2023: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.agreement_id;
2024: END IF;
2025: END;
2026:

Line 2034: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

2030: END;
2031:
2032: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_CUSTOMER_NAME' THEN
2033: BEGIN
2034: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2035: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.sold_to_org_id;
2036: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2037: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.sold_to_org_id;
2038: END IF;

Line 2036: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

2032: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_CUSTOMER_NAME' THEN
2033: BEGIN
2034: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2035: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.sold_to_org_id;
2036: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2037: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.sold_to_org_id;
2038: END IF;
2039: END;
2040:

Line 2043: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

2039: END;
2040:
2041: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_CUSTOMER_NUMBER' THEN
2042: BEGIN
2043: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2044: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.sold_to_org_id;
2045: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2046: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.sold_to_org_id;
2047: END IF;

Line 2045: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

2041: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_CUSTOMER_NUMBER' THEN
2042: BEGIN
2043: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2044: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.sold_to_org_id;
2045: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2046: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.sold_to_org_id;
2047: END IF;
2048: END;
2049:

Line 2057: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

2053: END;
2054:
2055: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_CUST_PO_NUMBER' THEN
2056: BEGIN
2057: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2058: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.cust_po_number;
2059: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2060: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.cust_po_number;
2061: END IF;

Line 2059: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

2055: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_CUST_PO_NUMBER' THEN
2056: BEGIN
2057: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2058: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.cust_po_number;
2059: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2060: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.cust_po_number;
2061: END IF;
2062: END;
2063:

Line 2066: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

2062: END;
2063:
2064: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_VERSION_NUMBER' THEN
2065: BEGIN
2066: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2067: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.version_number;
2068: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2069: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.version_number;
2070: END IF;

Line 2068: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

2064: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_VERSION_NUMBER' THEN
2065: BEGIN
2066: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2067: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.version_number;
2068: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2069: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.version_number;
2070: END IF;
2071: END;
2072:

Line 2075: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

2071: END;
2072:
2073: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_CUST_CONTACT_NAME' THEN
2074: BEGIN
2075: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2076: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.sold_to_contact_id;
2077: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2078: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.sold_to_contact_id;
2079: END IF;

Line 2077: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

2073: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_CUST_CONTACT_NAME' THEN
2074: BEGIN
2075: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2076: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.sold_to_contact_id;
2077: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2078: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.sold_to_contact_id;
2079: END IF;
2080: END;
2081:

Line 2084: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

2080: END;
2081:
2082: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_SALESREP_NAME' THEN
2083: BEGIN
2084: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2085: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.salesrep_id;
2086: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2087: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.salesrep_id;
2088: END IF;

Line 2086: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

2082: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_SALESREP_NAME' THEN
2083: BEGIN
2084: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2085: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.salesrep_id;
2086: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2087: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.salesrep_id;
2088: END IF;
2089: END;
2090:

Line 2093: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

2089: END;
2090:
2091: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_CURRENCY_CODE' THEN
2092: BEGIN
2093: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2094: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.transactional_curr_code;
2095: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2096: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.transactional_curr_code;
2097: END IF;

Line 2095: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

2091: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_CURRENCY_CODE' THEN
2092: BEGIN
2093: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2094: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.transactional_curr_code;
2095: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2096: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.transactional_curr_code;
2097: END IF;
2098: END;
2099:

Line 2102: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

2098: END;
2099:
2100: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_CURRENCY_NAME' THEN
2101: BEGIN
2102: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2103: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.transactional_curr_code;
2104: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2105: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.transactional_curr_code;
2106: END IF;

Line 2104: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

2100: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_CURRENCY_NAME' THEN
2101: BEGIN
2102: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2103: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.transactional_curr_code;
2104: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2105: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.transactional_curr_code;
2106: END IF;
2107: END;
2108:

Line 2111: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

2107: END;
2108:
2109: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_CURRENCY_SYMBOL' THEN
2110: BEGIN
2111: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2112: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.transactional_curr_code;
2113: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2114: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.transactional_curr_code;
2115: END IF;

Line 2113: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

2109: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_CURRENCY_SYMBOL' THEN
2110: BEGIN
2111: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2112: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.transactional_curr_code;
2113: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2114: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.transactional_curr_code;
2115: END IF;
2116: END;
2117:

Line 2130: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

2126: END;
2127:
2128: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_FREIGHT_TERMS' THEN
2129: BEGIN
2130: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2131: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.freight_terms_code;
2132: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2133: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.freight_terms_code;
2134: END IF;

Line 2132: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

2128: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_FREIGHT_TERMS' THEN
2129: BEGIN
2130: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2131: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.freight_terms_code;
2132: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2133: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.freight_terms_code;
2134: END IF;
2135: END;
2136:

Line 2139: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

2135: END;
2136:
2137: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_SHIPPING_METHOD' THEN
2138: BEGIN
2139: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2140: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.shipping_method_code;
2141: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2142: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.shipping_method_code;
2143: END IF;

Line 2141: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

2137: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_SHIPPING_METHOD' THEN
2138: BEGIN
2139: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2140: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.shipping_method_code;
2141: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2142: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.shipping_method_code;
2143: END IF;
2144: END;
2145:

Line 2148: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

2144: END;
2145:
2146: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_PAYMENT_TERM' THEN
2147: BEGIN
2148: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2149: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.payment_term_id;
2150: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2151: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.payment_term_id;
2152: END IF;

Line 2150: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

2146: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_PAYMENT_TERM' THEN
2147: BEGIN
2148: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2149: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.payment_term_id;
2150: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2151: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.payment_term_id;
2152: END IF;
2153: END;
2154:

Line 2157: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

2153: END;
2154:
2155: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_INVOICING_RULE' THEN
2156: BEGIN
2157: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2158: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.invoicing_rule_id;
2159: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2160: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.invoicing_rule_id;
2161: END IF;

Line 2159: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

2155: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_INVOICING_RULE' THEN
2156: BEGIN
2157: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2158: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.invoicing_rule_id;
2159: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2160: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.invoicing_rule_id;
2161: END IF;
2162: END;
2163:

Line 2176: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

2172: END;
2173:
2174: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_SUPPLIER_NAME' THEN
2175: BEGIN
2176: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2177: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.org_id;
2178: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2179: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.org_id;
2180: END IF;

Line 2178: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

2174: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_SUPPLIER_NAME' THEN
2175: BEGIN
2176: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2177: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.org_id;
2178: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2179: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.org_id;
2180: END IF;
2181: END;
2182:

Line 2197: oe_debug_pub.add('End of OE_Contracts_util.get_article_variable_values for header level variables, x_return_status ' || x_return_status, 1);

2193:
2194: END IF;
2195:
2196: IF l_debug_level > 0 THEN
2197: oe_debug_pub.add('End of OE_Contracts_util.get_article_variable_values for header level variables, x_return_status ' || x_return_status, 1);
2198: END IF;
2199:
2200:
2201: EXCEPTION

Line 2319: AND p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE

2315: inventory_item_id,
2316: sold_to_org_id
2317: FROM oe_blanket_lines_all
2318: WHERE header_id = p_doc_id
2319: AND p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE
2320: AND item_identifier_type <> 'CAT'
2321:
2322: UNION ALL
2323:

Line 2334: AND p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE

2330: inventory_item_id,
2331: sold_to_org_id
2332: FROM oe_order_lines_all
2333: WHERE header_id = p_doc_id
2334: AND p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE
2335: AND item_identifier_type <> 'CAT'
2336: ORDER BY ordered_item;
2337:
2338:

Line 2347: AND p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE

2343: CURSOR c_get_item_categories IS
2344: SELECT ordered_item
2345: FROM oe_blanket_lines_all
2346: WHERE header_id = p_doc_id
2347: AND p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE
2348: AND item_identifier_type = 'CAT'
2349:
2350: UNION ALL
2351:

Line 2357: AND p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE

2353: --returns non-translatable code eg. 208.05
2354: SELECT ordered_item
2355: FROM oe_order_lines_all
2356: WHERE header_id = p_doc_id
2357: AND p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE
2358: AND item_identifier_type = 'CAT'
2359: ORDER BY ordered_item;
2360:
2361:

Line 2388: oe_debug_pub.add('In OE_Contracts_util.get_article_variable_values for line level variables ', 1);

2384:
2385: BEGIN
2386:
2387: IF l_debug_level > 0 THEN
2388: oe_debug_pub.add('In OE_Contracts_util.get_article_variable_values for line level variables ', 1);
2389: oe_debug_pub.add('p_doc_type: ' || p_doc_type, 1);
2390: oe_debug_pub.add('p_doc_id: ' || p_doc_id, 1);
2391: oe_debug_pub.add('p_line_var_tbl.COUNT: ' || p_line_var_tbl.COUNT, 1);
2392: END IF;

Line 2538: oe_debug_pub.add('End of OE_Contracts_util.get_article_variable_values for line level variables, x_return_status: '|| x_return_status, 1);

2534: END IF; ----IF p_line_var_tbl.FIRST IS NOT NULL THEN
2535:
2536:
2537: IF l_debug_level > 0 THEN
2538: oe_debug_pub.add('End of OE_Contracts_util.get_article_variable_values for line level variables, x_return_status: '|| x_return_status, 1);
2539: END IF;
2540:
2541: EXCEPTION
2542: WHEN FND_API.G_EXC_ERROR THEN

Line 2660: oe_debug_pub.add('In OE_Contracts_util.get_terms_template ', 1);

2656:
2657: BEGIN
2658:
2659: IF l_debug_level > 0 THEN
2660: oe_debug_pub.add('In OE_Contracts_util.get_terms_template ', 1);
2661: END IF;
2662:
2663: x_return_status := FND_API.G_RET_STS_SUCCESS;
2664:

Line 2670: IF OE_Contracts_util.check_license() <> 'Y' THEN

2666: oe_msg_pub.initialize;
2667: END IF;
2668:
2669: --Check for licensing
2670: IF OE_Contracts_util.check_license() <> 'Y' THEN
2671: IF l_debug_level > 0 THEN
2672: oe_debug_pub.add('Contractual option not licensed, hence exiting get_terms_template ', 3);
2673: END IF;
2674: x_template_id := NULL;

Line 2716: oe_debug_pub.add('End of OE_Contracts_util.get_terms_template , x_return_status ' || x_return_status, 1);

2712: END IF;
2713: --ETR
2714:
2715: IF l_debug_level > 0 THEN
2716: oe_debug_pub.add('End of OE_Contracts_util.get_terms_template , x_return_status ' || x_return_status, 1);
2717: END IF;
2718:
2719: EXCEPTION
2720: WHEN FND_API.G_EXC_ERROR THEN

Line 2816: oe_debug_pub.add('In OE_Contracts_util.Get_Template_Name ', 1);

2812:
2813: BEGIN
2814:
2815: IF l_debug_level > 0 THEN
2816: oe_debug_pub.add('In OE_Contracts_util.Get_Template_Name ', 1);
2817: oe_debug_pub.add('p_api_version: ' || p_api_version, 3);
2818: oe_debug_pub.add('p_init_msg_list: ' || p_init_msg_list,3);
2819: oe_debug_pub.add('Calling OKC_TERMS_UTIL_GRP.Get_Template_Name',3);
2820: oe_debug_pub.add('p_tempate_id: ' || p_template_id,3);

Line 2826: IF OE_Contracts_util.check_license() <> 'Y' THEN

2822:
2823: x_return_status := FND_API.G_RET_STS_SUCCESS;
2824:
2825: --Check for licensing
2826: IF OE_Contracts_util.check_license() <> 'Y' THEN
2827: IF l_debug_level > 0 THEN
2828: oe_debug_pub.add('Contractual option not licensed, hence exiting Get_Template_Name ', 3);
2829: END IF;
2830: RETURN TO_CHAR(NULL); --returning null is OK here as null will be displayed

Line 2858: oe_debug_pub.add('End of OE_Contracts_util.Get_Template_Name, returning l_template_name: ' || l_template_name);

2854: END IF;
2855: --ETR
2856:
2857: IF l_debug_level > 0 THEN
2858: oe_debug_pub.add('End of OE_Contracts_util.Get_Template_Name, returning l_template_name: ' || l_template_name);
2859: END IF;
2860:
2861: RETURN l_template_name;
2862:

Line 2958: oe_debug_pub.add('In OE_Contracts_util.instantiate_terms ', 1);

2954: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2955: BEGIN
2956:
2957: IF l_debug_level > 0 THEN
2958: oe_debug_pub.add('In OE_Contracts_util.instantiate_terms ', 1);
2959: END IF;
2960:
2961: x_return_status := FND_API.G_RET_STS_SUCCESS;
2962:

Line 2968: IF OE_Contracts_util.check_license() <> 'Y' THEN

2964: oe_msg_pub.initialize;
2965: END IF;
2966:
2967: --Check for licensing
2968: IF OE_Contracts_util.check_license() <> 'Y' THEN
2969: IF l_debug_level > 0 THEN
2970: oe_debug_pub.add('Contractual option not licensed, hence exiting instantiate_terms ', 3);
2971: END IF;
2972: RETURN;

Line 3018: oe_debug_pub.add('End of OE_Contracts_util.instantiate_terms , x_return_status ' || x_return_status, 1);

3014: END IF;
3015: --ETR
3016:
3017: IF l_debug_level > 0 THEN
3018: oe_debug_pub.add('End of OE_Contracts_util.instantiate_terms , x_return_status ' || x_return_status, 1);
3019: END IF;
3020:
3021: EXCEPTION
3022: WHEN FND_API.G_EXC_ERROR THEN

Line 3127: oe_debug_pub.add('In OE_Contracts_util.instantiate_doc_terms ', 1);

3123:
3124: BEGIN
3125:
3126: IF l_debug_level > 0 THEN
3127: oe_debug_pub.add('In OE_Contracts_util.instantiate_doc_terms ', 1);
3128: END IF;
3129:
3130: x_return_status := FND_API.G_RET_STS_SUCCESS;
3131:

Line 3137: IF OE_Contracts_util.check_license() <> 'Y' THEN

3133: oe_msg_pub.initialize;
3134: END IF;
3135:
3136: --Check for licensing
3137: IF OE_Contracts_util.check_license() <> 'Y' THEN
3138: IF l_debug_level > 0 THEN
3139: oe_debug_pub.add('Contractual option not licensed, hence exiting instantiate_doc_terms ', 3);
3140: END IF;
3141: RETURN;

Line 3164: oe_debug_pub.add('Calling oe_contracts_util.get_terms_template', 3);

3160: IF p_template_id IS NOT NULL THEN
3161:
3162:
3163: IF l_debug_level > 0 THEN
3164: oe_debug_pub.add('Calling oe_contracts_util.get_terms_template', 3);
3165: END IF;
3166:
3167:
3168: --first determine whether any terms and conditions have been instantiated for the BSA or Sales Order

Line 3169: oe_contracts_util.get_terms_template (

3165: END IF;
3166:
3167:
3168: --first determine whether any terms and conditions have been instantiated for the BSA or Sales Order
3169: oe_contracts_util.get_terms_template (
3170: p_api_version => 1.0,
3171: p_init_msg_list => FND_API.G_FALSE,
3172: p_commit => FND_API.G_FALSE,
3173:

Line 3195: oe_debug_pub.add('Calling oe_contracts_util.instantiate_terms', 3);

3191: /** i.e. the contract template freshly defaulted in the form has not yet been
3192: instantiated so go ahead and instantiate it against the BSA or SO **/
3193:
3194: IF l_debug_level > 0 THEN
3195: oe_debug_pub.add('Calling oe_contracts_util.instantiate_terms', 3);
3196: END IF;
3197:
3198: oe_contracts_util.instantiate_terms (
3199: p_api_version => 1.0,

Line 3198: oe_contracts_util.instantiate_terms (

3194: IF l_debug_level > 0 THEN
3195: oe_debug_pub.add('Calling oe_contracts_util.instantiate_terms', 3);
3196: END IF;
3197:
3198: oe_contracts_util.instantiate_terms (
3199: p_api_version => 1.0,
3200: p_init_msg_list => FND_API.G_FALSE,
3201: p_commit => FND_API.G_TRUE, --important: need to save before invoking articles UI
3202:

Line 3229: oe_debug_pub.add('End of OE_Contracts_util.instantiate_doc_terms , x_return_status ' || x_return_status, 1);

3225:
3226:
3227:
3228: IF l_debug_level > 0 THEN
3229: oe_debug_pub.add('End of OE_Contracts_util.instantiate_doc_terms , x_return_status ' || x_return_status, 1);
3230: END IF;
3231:
3232: EXCEPTION
3233: WHEN FND_API.G_EXC_ERROR THEN

Line 3342: oe_debug_pub.add('In OE_Contracts_util.is_order_signed', 2);

3338: WHERE a.header_id = p_doc_id;
3339:
3340: BEGIN
3341: IF (l_debug_level > 0) THEN
3342: oe_debug_pub.add('In OE_Contracts_util.is_order_signed', 2);
3343: END IF;
3344: -- Initialize message list if p_init_msg_list is set to TRUE.
3345: IF p_init_msg_list = FND_API.G_TRUE THEN
3346: oe_msg_pub.initialize;

Line 3381: oe_debug_pub.add('End of OE_Contracts_util.is_order_signed', 2);

3377: oe_debug_pub.add('Order signed ?: return value = ' || l_return_value, 3);
3378: END IF;
3379:
3380: IF (l_debug_level > 0) THEN
3381: oe_debug_pub.add('End of OE_Contracts_util.is_order_signed', 2);
3382: END IF;
3383: RETURN l_return_value;
3384:
3385: EXCEPTION

Line 3439: oe_debug_pub.add('In OE_Contracts_util.copy_doc ', 1);

3435:
3436: BEGIN
3437:
3438: IF l_debug_level > 0 THEN
3439: oe_debug_pub.add('In OE_Contracts_util.copy_doc ', 1);
3440: END IF;
3441:
3442: x_return_status := FND_API.G_RET_STS_SUCCESS;
3443:

Line 3449: IF OE_Contracts_util.check_license() <> 'Y' THEN

3445: oe_msg_pub.initialize;
3446: END IF;
3447:
3448: --Check contract Licence
3449: IF OE_Contracts_util.check_license() <> 'Y' THEN
3450: IF l_debug_level > 0 THEN
3451: oe_debug_pub.add('Contractual option not licensed. Exiting copy_doc', 3);
3452: END IF;
3453: RETURN;

Line 3709: oe_debug_pub.add('In oe_contracts_util.get_item_info:g_exc_error section') ;

3705:
3706: EXCEPTION
3707: WHEN FND_API.G_EXC_ERROR THEN
3708: IF l_debug_level > 0 THEN
3709: oe_debug_pub.add('In oe_contracts_util.get_item_info:g_exc_error section') ;
3710: END IF;
3711: RAISE FND_API.G_EXC_ERROR;
3712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3713: IF l_debug_level > 0 THEN

Line 3714: oe_debug_pub.add('In oe_contracts_util.get_item_info:g_exc_unexpected_error section') ;

3710: END IF;
3711: RAISE FND_API.G_EXC_ERROR;
3712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3713: IF l_debug_level > 0 THEN
3714: oe_debug_pub.add('In oe_contracts_util.get_item_info:g_exc_unexpected_error section') ;
3715: END IF;
3716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3717: WHEN OTHERS THEN
3718: IF l_debug_level > 0 THEN

Line 3719: oe_debug_pub.add('In oe_contracts_util.get_item_info: when others section') ;

3715: END IF;
3716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3717: WHEN OTHERS THEN
3718: IF l_debug_level > 0 THEN
3719: oe_debug_pub.add('In oe_contracts_util.get_item_info: when others section') ;
3720: END IF;
3721: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3722: THEN
3723: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'GET_ITEM_INFO');

Line 3750: oe_debug_pub.add('In OE_Contracts_util.get_contract_defaults ', 1);

3746:
3747: BEGIN
3748:
3749: IF l_debug_level > 0 THEN
3750: oe_debug_pub.add('In OE_Contracts_util.get_contract_defaults ', 1);
3751: END IF;
3752:
3753: x_return_status := FND_API.G_RET_STS_SUCCESS;
3754:

Line 3760: IF OE_Contracts_util.check_license() <> 'Y' THEN

3756: oe_msg_pub.initialize;
3757: END IF;
3758:
3759: --Check for licensing
3760: IF OE_Contracts_util.check_license() <> 'Y' THEN
3761: IF l_debug_level > 0 THEN
3762: oe_debug_pub.add('Contractual option not licensed, hence exiting get_terms_template ', 3);
3763: END IF;
3764: x_contract_source := NULL;

Line 3808: oe_debug_pub.add('End of OE_Contracts_util.get_contract_defaults , x_return_status ' || x_return_status, 1);

3804: RAISE FND_API.G_EXC_ERROR ;
3805: END IF;
3806:
3807: IF l_debug_level > 0 THEN
3808: oe_debug_pub.add('End of OE_Contracts_util.get_contract_defaults , x_return_status ' || x_return_status, 1);
3809: END IF;
3810:
3811: EXCEPTION
3812: WHEN FND_API.G_EXC_ERROR THEN

Line 3902: oe_debug_pub.add('In OE_Contracts_util.get_contract_details_all ', 1);

3898:
3899: BEGIN
3900:
3901: IF l_debug_level > 0 THEN
3902: oe_debug_pub.add('In OE_Contracts_util.get_contract_details_all ', 1);
3903: END IF;
3904:
3905: x_return_status := FND_API.G_RET_STS_SUCCESS;
3906:

Line 3912: IF OE_Contracts_util.check_license() <> 'Y' THEN

3908: oe_msg_pub.initialize;
3909: END IF;
3910:
3911: --Check for licensing
3912: IF OE_Contracts_util.check_license() <> 'Y' THEN
3913: IF l_debug_level > 0 THEN
3914: oe_debug_pub.add('Contractual option not licensed, hence exiting get_contract_details_all ', 3);
3915: END IF;
3916: x_contract_source := NULL;

Line 3973: oe_debug_pub.add('End of OE_Contracts_util.get_contract_details_all , x_return_status ' || x_return_status, 1);

3969: RAISE FND_API.G_EXC_ERROR ;
3970: END IF;
3971:
3972: IF l_debug_level > 0 THEN
3973: oe_debug_pub.add('End of OE_Contracts_util.get_contract_details_all , x_return_status ' || x_return_status, 1);
3974: END IF;
3975:
3976: EXCEPTION
3977: WHEN FND_API.G_EXC_ERROR THEN

Line 4055: oe_debug_pub.add('In OE_Contracts_util.Is_Terms_Template_Valid ', 1);

4051:
4052: BEGIN
4053:
4054: IF l_debug_level > 0 THEN
4055: oe_debug_pub.add('In OE_Contracts_util.Is_Terms_Template_Valid ', 1);
4056: END IF;
4057:
4058: x_return_status := FND_API.G_RET_STS_SUCCESS;
4059:

Line 4065: IF OE_Contracts_util.check_license() <> 'Y' THEN

4061: oe_msg_pub.initialize;
4062: END IF;
4063:
4064: --Check for licensing
4065: IF OE_Contracts_util.check_license() <> 'Y' THEN
4066: IF l_debug_level > 0 THEN
4067: oe_debug_pub.add('Contractual option not licensed, hence exiting Is_Terms_Template_Valid ', 3);
4068: END IF;
4069: RETURN NULL;

Line 4107: oe_debug_pub.add('End of OE_Contracts_util.Is_Terms_Template_Valid , x_return_status ' || x_return_status, 1);

4103: RAISE FND_API.G_EXC_ERROR ;
4104: END IF;
4105:
4106: IF l_debug_level > 0 THEN
4107: oe_debug_pub.add('End of OE_Contracts_util.Is_Terms_Template_Valid , x_return_status ' || x_return_status, 1);
4108: END IF;
4109:
4110: RETURN l_result;
4111:

Line 4182: oe_debug_pub.add('In OE_Contracts_util.Is_Auth_Party_Internal ', 1);

4178: l_authoring_party_code VARCHAR2(100);
4179: BEGIN
4180:
4181: IF l_debug_level > 0 THEN
4182: oe_debug_pub.add('In OE_Contracts_util.Is_Auth_Party_Internal ', 1);
4183: END IF;
4184:
4185: --Check for licensing
4186: IF OE_Contracts_util.check_license() <> 'Y' THEN

Line 4186: IF OE_Contracts_util.check_license() <> 'Y' THEN

4182: oe_debug_pub.add('In OE_Contracts_util.Is_Auth_Party_Internal ', 1);
4183: END IF;
4184:
4185: --Check for licensing
4186: IF OE_Contracts_util.check_license() <> 'Y' THEN
4187: IF l_debug_level > 0 THEN
4188: oe_debug_pub.add('Contractual option not licensed, hence exiting Is_Auth_Party_Internal ', 3);
4189: END IF;
4190:

Line 4245: oe_debug_pub.add('In OE_Contracts_util.Is_RChg_Enabled ', 1);

4241:
4242: BEGIN
4243:
4244: IF l_debug_level > 0 THEN
4245: oe_debug_pub.add('In OE_Contracts_util.Is_RChg_Enabled ', 1);
4246: END IF;
4247: --Get the org_id
4248: BEGIN
4249: SELECT org_id into l_org_id

Line 4292: END OE_Contracts_util;

4288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4289:
4290: END Is_RChg_Enabled;
4291:
4292: END OE_Contracts_util;