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.6 2011/07/14 13:32:33 snimmaga 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 1213: IF OE_Contracts_util.check_license() <> 'Y' THEN

1209:
1210: That is the fix implemented during the solution of bug 11769204.
1211: ----------
1212: --Check for licensing, proceed with procesing only if licensed
1213: IF OE_Contracts_util.check_license() <> 'Y' THEN
1214: IF l_debug_level > 0 THEN
1215: oe_debug_pub.add('Contractual option not licensed, hence exiting attachment_location ', 3);
1216: END IF;
1217: RETURN;

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

1236: END IF;
1237:
1238:
1239: IF l_debug_level > 0 THEN
1240: oe_debug_pub.add('Calling OE_Contracts_util.get_terms_template ', 3);
1241: oe_debug_pub.add('p_api_version: ' || p_api_version,3);
1242: oe_debug_pub.add('p_init_msg_list: ' || p_init_msg_list,3);
1243: oe_debug_pub.add('p_doc_type: '|| p_doc_type, 3);
1244: oe_debug_pub.add('p_doc_id: '|| p_doc_id, 3);

Line 1248: oe_contracts_util.get_terms_template (

1244: oe_debug_pub.add('p_doc_id: '|| p_doc_id, 3);
1245: END IF;
1246:
1247: --first determine whether any terms and conditions have been instantiated for the BSA or Sales Order
1248: oe_contracts_util.get_terms_template (
1249: p_api_version => 1.0,
1250: p_init_msg_list => p_init_msg_list,
1251:
1252: p_doc_type => p_doc_type,

Line 1273: IF OE_CONTRACTS_UTIL.Terms_Exists

1269: /*
1270: IF l_template_id IS NOT NULL THEN
1271: --terms and conditions do exist for the BSA or Sales Order so return contract attachment string to workflow request
1272: */
1273: IF OE_CONTRACTS_UTIL.Terms_Exists
1274: ( p_doc_type => p_doc_type
1275: , p_doc_id => p_doc_id) = 'Y' THEN
1276:
1277: /************

Line 1279: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

1275: , p_doc_id => p_doc_id) = 'Y' THEN
1276:
1277: /************
1278: --get the version number for pk3 of contract attachment entity OKC_CONTRACT_DOCS
1279: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
1280: IF c_get_bsa_version%ISOPEN THEN
1281: CLOSE c_get_bsa_version;
1282: END IF;
1283:

Line 1292: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

1288: IF l_debug_level > 0 THEN
1289: oe_debug_pub.add('l_doc_version_number of blanket: '|| l_doc_version_number, 3);
1290: END IF;
1291:
1292: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
1293: IF c_get_so_version%ISOPEN THEN
1294: CLOSE c_get_so_version;
1295: END IF;
1296:

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

1326: END IF;
1327:
1328: IF l_debug_level > 0 THEN
1329: oe_debug_pub.add('l_workflow_string: '|| l_workflow_string, 3);
1330: oe_debug_pub.add('End of OE_Contracts_util.attachment_location, x_return_status ' || x_return_status, 1);
1331: END IF;
1332:
1333: x_workflow_string := l_workflow_string;
1334:

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

1478: */
1479: BEGIN
1480:
1481: IF l_debug_level > 0 THEN
1482: oe_debug_pub.add('In OE_Contracts_util.terms_exists ', 1);
1483: END IF;
1484:
1485: --Check for licensing
1486: IF OE_Contracts_util.check_license() <> 'Y' THEN

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

1482: oe_debug_pub.add('In OE_Contracts_util.terms_exists ', 1);
1483: END IF;
1484:
1485: --Check for licensing
1486: IF OE_Contracts_util.check_license() <> 'Y' THEN
1487: IF l_debug_level > 0 THEN
1488: oe_debug_pub.add('Contracts not licensed, exiting terms_exists', 3);
1489: END IF;
1490: --RETURN NULL;

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

1492: END IF;
1493:
1494:
1495: IF l_debug_level > 0 THEN
1496: oe_debug_pub.add('Calling OE_Contracts_util.has_terms ', 3);
1497: oe_debug_pub.add('p_doc_type: ' || p_doc_type,3);
1498: oe_debug_pub.add('p_doc_id: ' || p_doc_id,3);
1499: END IF;
1500:

Line 1502: /* oe_contracts_util.get_terms_template (

1498: oe_debug_pub.add('p_doc_id: ' || p_doc_id,3);
1499: END IF;
1500:
1501: --first determine whether any terms and conditions have been instantiated for the BSA or sales order
1502: /* oe_contracts_util.get_terms_template (
1503: p_api_version => 1.0,
1504:
1505: p_doc_type => p_doc_type,
1506: p_doc_id => p_doc_id,

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

1521:
1522:
1523: IF l_template_id IS NOT NULL THEN
1524: IF l_debug_level > 0 THEN
1525: oe_debug_pub.add('End of OE_Contracts_util.terms_exists , returning Y');
1526: END IF;
1527: RETURN ('Y');
1528: ELSE
1529: IF l_debug_level > 0 THEN

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

1526: END IF;
1527: RETURN ('Y');
1528: ELSE
1529: IF l_debug_level > 0 THEN
1530: oe_debug_pub.add('End of OE_Contracts_util.terms_exists , returning Y');
1531: END IF;
1532: RETURN ('N');
1533: END IF;*/
1534:

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

1539: p_document_id => p_doc_id
1540: );
1541:
1542: IF l_debug_level > 0 THEN
1543: oe_debug_pub.add('End of OE_Contracts_util.terms_exists result is:'||l_result );
1544: END IF;
1545:
1546: RETURN l_result;
1547:

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

1585:
1586: BEGIN
1587:
1588: IF l_debug_level > 0 THEN
1589: oe_debug_pub.add('In OE_Contracts_util.delete_articles ', 1);
1590: END IF;
1591:
1592: x_return_status := FND_API.G_RET_STS_SUCCESS;
1593:

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

1595: oe_msg_pub.initialize;
1596: END IF;
1597:
1598: --Check for licensing
1599: IF OE_Contracts_util.check_license() <> 'Y' THEN
1600: IF l_debug_level > 0 THEN
1601: oe_debug_pub.add('Contractual option not licensed, hence exiting delete_articles ', 3);
1602: END IF;
1603: RETURN;

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

1637: END IF;
1638: --ETR
1639:
1640: IF l_debug_level > 0 THEN
1641: oe_debug_pub.add('End of OE_Contracts_util.delete_articles, x_return_status ' || x_return_status, 1);
1642: END IF;
1643:
1644: EXCEPTION
1645: WHEN FND_API.G_EXC_ERROR THEN

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

1737:
1738: BEGIN
1739:
1740: IF l_debug_level > 0 THEN
1741: oe_debug_pub.add('In OE_Contracts_util.purge_articles ', 1);
1742: END IF;
1743:
1744: x_return_status := FND_API.G_RET_STS_SUCCESS;
1745:

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

1747: oe_msg_pub.initialize;
1748: END IF;
1749:
1750: --Check for licensing
1751: IF OE_Contracts_util.check_license() <> 'Y' THEN
1752: IF l_debug_level > 0 THEN
1753: oe_debug_pub.add('Contractual option not licensed, hence exiting purge_articles ', 3);
1754: END IF;
1755: RETURN;

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

1786: END IF;
1787: --ETR
1788:
1789: IF l_debug_level > 0 THEN
1790: oe_debug_pub.add('End of OE_Contracts_util.purge_articles, x_return_status ' || x_return_status, 1);
1791: END IF;
1792:
1793: EXCEPTION
1794: WHEN FND_API.G_EXC_ERROR THEN

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

1947:
1948: BEGIN
1949:
1950: IF l_debug_level > 0 THEN
1951: oe_debug_pub.add('In OE_Contracts_util.get_article_variable_values for header level variables', 1);
1952: oe_debug_pub.add('p_doc_type: ' || p_doc_type,3);
1953: oe_debug_pub.add('p_doc_id: ' || p_doc_id,3);
1954: END IF;
1955:

Line 1970: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

1966:
1967: ----IF p_sys_var_value_tbl.COUNT > 0 THEN
1968: IF p_sys_var_value_tbl.FIRST IS NOT NULL THEN
1969:
1970: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
1971:
1972: IF c_get_bsa_header_variables%ISOPEN THEN
1973: CLOSE c_get_bsa_header_variables;
1974: END IF;

Line 1983: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

1979: oe_debug_pub.add('c_get_bsa_header_variables%ROWCOUNT: ' || c_get_bsa_header_variables%ROWCOUNT, 3);
1980: END IF;
1981: CLOSE c_get_bsa_header_variables;
1982:
1983: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
1984:
1985: IF c_get_bsa_header_variables%ISOPEN THEN
1986: CLOSE c_get_so_header_variables;
1987: END IF;

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_BLANKET_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.order_number;
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.blanket_number;
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_BLANKET_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.order_number;
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.blanket_number;
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_NUMBER' 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_NUMBER' 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 2029: IF p_doc_type = OE_CONTRACTS_UTIL.get_G_BSA_DOC_TYPE() THEN

2025: END;
2026:
2027: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_PA_NAME' THEN
2028: BEGIN
2029: IF p_doc_type = OE_CONTRACTS_UTIL.get_G_BSA_DOC_TYPE() THEN
2030: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.agreement_id;
2031: ELSIF p_doc_type = OE_CONTRACTS_UTIL.get_G_SO_DOC_TYPE() THEN
2032: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.agreement_id;
2033: END IF;

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

2027: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_PA_NAME' THEN
2028: BEGIN
2029: IF p_doc_type = OE_CONTRACTS_UTIL.get_G_BSA_DOC_TYPE() THEN
2030: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.agreement_id;
2031: ELSIF p_doc_type = OE_CONTRACTS_UTIL.get_G_SO_DOC_TYPE() THEN
2032: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.agreement_id;
2033: END IF;
2034: END;
2035:

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_NAME' 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_NAME' 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 2052: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

2048: END;
2049:
2050: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_CUSTOMER_NUMBER' THEN
2051: BEGIN
2052: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2053: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.sold_to_org_id;
2054: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2055: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.sold_to_org_id;
2056: END IF;

Line 2054: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

2050: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_CUSTOMER_NUMBER' THEN
2051: BEGIN
2052: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2053: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.sold_to_org_id;
2054: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2055: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.sold_to_org_id;
2056: END IF;
2057: END;
2058:

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_CUST_PO_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.cust_po_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.cust_po_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_CUST_PO_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.cust_po_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.cust_po_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_VERSION_NUMBER' 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.version_number;
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.version_number;
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_VERSION_NUMBER' 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.version_number;
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.version_number;
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_CUST_CONTACT_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.sold_to_contact_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.sold_to_contact_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_CUST_CONTACT_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.sold_to_contact_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.sold_to_contact_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_SALESREP_NAME' 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.salesrep_id;
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.salesrep_id;
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_SALESREP_NAME' 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.salesrep_id;
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.salesrep_id;
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_CODE' 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_CODE' 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_NAME' 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_NAME' 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 2120: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

2116: END;
2117:
2118: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_CURRENCY_SYMBOL' THEN
2119: BEGIN
2120: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2121: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.transactional_curr_code;
2122: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2123: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.transactional_curr_code;
2124: END IF;

Line 2122: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

2118: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_CURRENCY_SYMBOL' THEN
2119: BEGIN
2120: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2121: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.transactional_curr_code;
2122: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2123: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.transactional_curr_code;
2124: END IF;
2125: END;
2126:

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_FREIGHT_TERMS' 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.freight_terms_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.freight_terms_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_FREIGHT_TERMS' 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.freight_terms_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.freight_terms_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_SHIPPING_METHOD' 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.shipping_method_code;
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.shipping_method_code;
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_SHIPPING_METHOD' 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.shipping_method_code;
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.shipping_method_code;
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_PAYMENT_TERM' 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.payment_term_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.payment_term_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_PAYMENT_TERM' 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.payment_term_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.payment_term_id;
2161: END IF;
2162: END;
2163:

Line 2166: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

2162: END;
2163:
2164: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_INVOICING_RULE' THEN
2165: BEGIN
2166: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2167: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.invoicing_rule_id;
2168: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2169: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.invoicing_rule_id;
2170: END IF;

Line 2168: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

2164: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_INVOICING_RULE' THEN
2165: BEGIN
2166: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2167: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.invoicing_rule_id;
2168: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2169: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.invoicing_rule_id;
2170: END IF;
2171: END;
2172:

Line 2185: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN

2181: END;
2182:
2183: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_SUPPLIER_NAME' THEN
2184: BEGIN
2185: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2186: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.org_id;
2187: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2188: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.org_id;
2189: END IF;

Line 2187: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN

2183: ELSIF p_sys_var_value_tbl(i).variable_code = 'OKC$S_SUPPLIER_NAME' THEN
2184: BEGIN
2185: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
2186: p_sys_var_value_tbl(i).variable_value_id := l_bsa_header_variables.org_id;
2187: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
2188: p_sys_var_value_tbl(i).variable_value_id := l_so_header_variables.org_id;
2189: END IF;
2190: END;
2191:

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

2202:
2203: END IF;
2204:
2205: IF l_debug_level > 0 THEN
2206: oe_debug_pub.add('End of OE_Contracts_util.get_article_variable_values for header level variables, x_return_status ' || x_return_status, 1);
2207: END IF;
2208:
2209:
2210: EXCEPTION

Line 2328: AND p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE

2324: inventory_item_id,
2325: sold_to_org_id
2326: FROM oe_blanket_lines_all
2327: WHERE header_id = p_doc_id
2328: AND p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE
2329: AND item_identifier_type <> 'CAT'
2330:
2331: UNION ALL
2332:

Line 2343: AND p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE

2339: inventory_item_id,
2340: sold_to_org_id
2341: FROM oe_order_lines_all
2342: WHERE header_id = p_doc_id
2343: AND p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE
2344: AND item_identifier_type <> 'CAT'
2345: ORDER BY ordered_item;
2346:
2347:

Line 2356: AND p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE

2352: CURSOR c_get_item_categories IS
2353: SELECT ordered_item
2354: FROM oe_blanket_lines_all
2355: WHERE header_id = p_doc_id
2356: AND p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE
2357: AND item_identifier_type = 'CAT'
2358:
2359: UNION ALL
2360:

Line 2366: AND p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE

2362: --returns non-translatable code eg. 208.05
2363: SELECT ordered_item
2364: FROM oe_order_lines_all
2365: WHERE header_id = p_doc_id
2366: AND p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE
2367: AND item_identifier_type = 'CAT'
2368: ORDER BY ordered_item;
2369:
2370:

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

2393:
2394: BEGIN
2395:
2396: IF l_debug_level > 0 THEN
2397: oe_debug_pub.add('In OE_Contracts_util.get_article_variable_values for line level variables ', 1);
2398: oe_debug_pub.add('p_doc_type: ' || p_doc_type, 1);
2399: oe_debug_pub.add('p_doc_id: ' || p_doc_id, 1);
2400: oe_debug_pub.add('p_line_var_tbl.COUNT: ' || p_line_var_tbl.COUNT, 1);
2401: END IF;

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

2543: END IF; ----IF p_line_var_tbl.FIRST IS NOT NULL THEN
2544:
2545:
2546: IF l_debug_level > 0 THEN
2547: oe_debug_pub.add('End of OE_Contracts_util.get_article_variable_values for line level variables, x_return_status: '|| x_return_status, 1);
2548: END IF;
2549:
2550: EXCEPTION
2551: WHEN FND_API.G_EXC_ERROR THEN

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

2665:
2666: BEGIN
2667:
2668: IF l_debug_level > 0 THEN
2669: oe_debug_pub.add('In OE_Contracts_util.get_terms_template ', 1);
2670: END IF;
2671:
2672: x_return_status := FND_API.G_RET_STS_SUCCESS;
2673:

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

2675: oe_msg_pub.initialize;
2676: END IF;
2677:
2678: --Check for licensing
2679: IF OE_Contracts_util.check_license() <> 'Y' THEN
2680: IF l_debug_level > 0 THEN
2681: oe_debug_pub.add('Contractual option not licensed, hence exiting get_terms_template ', 3);
2682: END IF;
2683: x_template_id := NULL;

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

2721: END IF;
2722: --ETR
2723:
2724: IF l_debug_level > 0 THEN
2725: oe_debug_pub.add('End of OE_Contracts_util.get_terms_template , x_return_status ' || x_return_status, 1);
2726: END IF;
2727:
2728: EXCEPTION
2729: WHEN FND_API.G_EXC_ERROR THEN

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

2821:
2822: BEGIN
2823:
2824: IF l_debug_level > 0 THEN
2825: oe_debug_pub.add('In OE_Contracts_util.Get_Template_Name ', 1);
2826: oe_debug_pub.add('p_api_version: ' || p_api_version, 3);
2827: oe_debug_pub.add('p_init_msg_list: ' || p_init_msg_list,3);
2828: oe_debug_pub.add('Calling OKC_TERMS_UTIL_GRP.Get_Template_Name',3);
2829: oe_debug_pub.add('p_tempate_id: ' || p_template_id,3);

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

2831:
2832: x_return_status := FND_API.G_RET_STS_SUCCESS;
2833:
2834: --Check for licensing
2835: IF OE_Contracts_util.check_license() <> 'Y' THEN
2836: IF l_debug_level > 0 THEN
2837: oe_debug_pub.add('Contractual option not licensed, hence exiting Get_Template_Name ', 3);
2838: END IF;
2839: RETURN TO_CHAR(NULL); --returning null is OK here as null will be displayed

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

2863: END IF;
2864: --ETR
2865:
2866: IF l_debug_level > 0 THEN
2867: oe_debug_pub.add('End of OE_Contracts_util.Get_Template_Name, returning l_template_name: ' || l_template_name);
2868: END IF;
2869:
2870: RETURN l_template_name;
2871:

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

2963: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2964: BEGIN
2965:
2966: IF l_debug_level > 0 THEN
2967: oe_debug_pub.add('In OE_Contracts_util.instantiate_terms ', 1);
2968: END IF;
2969:
2970: x_return_status := FND_API.G_RET_STS_SUCCESS;
2971:

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

2973: oe_msg_pub.initialize;
2974: END IF;
2975:
2976: --Check for licensing
2977: IF OE_Contracts_util.check_license() <> 'Y' THEN
2978: IF l_debug_level > 0 THEN
2979: oe_debug_pub.add('Contractual option not licensed, hence exiting instantiate_terms ', 3);
2980: END IF;
2981: RETURN;

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

3023: END IF;
3024: --ETR
3025:
3026: IF l_debug_level > 0 THEN
3027: oe_debug_pub.add('End of OE_Contracts_util.instantiate_terms , x_return_status ' || x_return_status, 1);
3028: END IF;
3029:
3030: EXCEPTION
3031: WHEN FND_API.G_EXC_ERROR THEN

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

3132:
3133: BEGIN
3134:
3135: IF l_debug_level > 0 THEN
3136: oe_debug_pub.add('In OE_Contracts_util.instantiate_doc_terms ', 1);
3137: END IF;
3138:
3139: x_return_status := FND_API.G_RET_STS_SUCCESS;
3140:

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

3142: oe_msg_pub.initialize;
3143: END IF;
3144:
3145: --Check for licensing
3146: IF OE_Contracts_util.check_license() <> 'Y' THEN
3147: IF l_debug_level > 0 THEN
3148: oe_debug_pub.add('Contractual option not licensed, hence exiting instantiate_doc_terms ', 3);
3149: END IF;
3150: RETURN;

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

3169: IF p_template_id IS NOT NULL THEN
3170:
3171:
3172: IF l_debug_level > 0 THEN
3173: oe_debug_pub.add('Calling oe_contracts_util.get_terms_template', 3);
3174: END IF;
3175:
3176:
3177: --first determine whether any terms and conditions have been instantiated for the BSA or Sales Order

Line 3178: oe_contracts_util.get_terms_template (

3174: END IF;
3175:
3176:
3177: --first determine whether any terms and conditions have been instantiated for the BSA or Sales Order
3178: oe_contracts_util.get_terms_template (
3179: p_api_version => 1.0,
3180: p_init_msg_list => FND_API.G_FALSE,
3181: p_commit => FND_API.G_FALSE,
3182:

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

3200: /** i.e. the contract template freshly defaulted in the form has not yet been
3201: instantiated so go ahead and instantiate it against the BSA or SO **/
3202:
3203: IF l_debug_level > 0 THEN
3204: oe_debug_pub.add('Calling oe_contracts_util.instantiate_terms', 3);
3205: END IF;
3206:
3207: oe_contracts_util.instantiate_terms (
3208: p_api_version => 1.0,

Line 3207: oe_contracts_util.instantiate_terms (

3203: IF l_debug_level > 0 THEN
3204: oe_debug_pub.add('Calling oe_contracts_util.instantiate_terms', 3);
3205: END IF;
3206:
3207: oe_contracts_util.instantiate_terms (
3208: p_api_version => 1.0,
3209: p_init_msg_list => FND_API.G_FALSE,
3210: p_commit => FND_API.G_TRUE, --important: need to save before invoking articles UI
3211:

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

3234:
3235:
3236:
3237: IF l_debug_level > 0 THEN
3238: oe_debug_pub.add('End of OE_Contracts_util.instantiate_doc_terms , x_return_status ' || x_return_status, 1);
3239: END IF;
3240:
3241: EXCEPTION
3242: WHEN FND_API.G_EXC_ERROR THEN

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

3347: WHERE a.header_id = p_doc_id;
3348:
3349: BEGIN
3350: IF (l_debug_level > 0) THEN
3351: oe_debug_pub.add('In OE_Contracts_util.is_order_signed', 2);
3352: END IF;
3353: -- Initialize message list if p_init_msg_list is set to TRUE.
3354: IF p_init_msg_list = FND_API.G_TRUE THEN
3355: oe_msg_pub.initialize;

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

3386: oe_debug_pub.add('Order signed ?: return value = ' || l_return_value, 3);
3387: END IF;
3388:
3389: IF (l_debug_level > 0) THEN
3390: oe_debug_pub.add('End of OE_Contracts_util.is_order_signed', 2);
3391: END IF;
3392: RETURN l_return_value;
3393:
3394: EXCEPTION

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

3444:
3445: BEGIN
3446:
3447: IF l_debug_level > 0 THEN
3448: oe_debug_pub.add('In OE_Contracts_util.copy_doc ', 1);
3449: END IF;
3450:
3451: x_return_status := FND_API.G_RET_STS_SUCCESS;
3452:

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

3454: oe_msg_pub.initialize;
3455: END IF;
3456:
3457: --Check contract Licence
3458: IF OE_Contracts_util.check_license() <> 'Y' THEN
3459: IF l_debug_level > 0 THEN
3460: oe_debug_pub.add('Contractual option not licensed. Exiting copy_doc', 3);
3461: END IF;
3462: RETURN;

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

3714:
3715: EXCEPTION
3716: WHEN FND_API.G_EXC_ERROR THEN
3717: IF l_debug_level > 0 THEN
3718: oe_debug_pub.add('In oe_contracts_util.get_item_info:g_exc_error section') ;
3719: END IF;
3720: RAISE FND_API.G_EXC_ERROR;
3721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3722: IF l_debug_level > 0 THEN

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

3719: END IF;
3720: RAISE FND_API.G_EXC_ERROR;
3721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3722: IF l_debug_level > 0 THEN
3723: oe_debug_pub.add('In oe_contracts_util.get_item_info:g_exc_unexpected_error section') ;
3724: END IF;
3725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3726: WHEN OTHERS THEN
3727: IF l_debug_level > 0 THEN

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

3724: END IF;
3725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3726: WHEN OTHERS THEN
3727: IF l_debug_level > 0 THEN
3728: oe_debug_pub.add('In oe_contracts_util.get_item_info: when others section') ;
3729: END IF;
3730: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3731: THEN
3732: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'GET_ITEM_INFO');

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

3755:
3756: BEGIN
3757:
3758: IF l_debug_level > 0 THEN
3759: oe_debug_pub.add('In OE_Contracts_util.get_contract_defaults ', 1);
3760: END IF;
3761:
3762: x_return_status := FND_API.G_RET_STS_SUCCESS;
3763:

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

3765: oe_msg_pub.initialize;
3766: END IF;
3767:
3768: --Check for licensing
3769: IF OE_Contracts_util.check_license() <> 'Y' THEN
3770: IF l_debug_level > 0 THEN
3771: oe_debug_pub.add('Contractual option not licensed, hence exiting get_terms_template ', 3);
3772: END IF;
3773: x_contract_source := NULL;

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

3813: RAISE FND_API.G_EXC_ERROR ;
3814: END IF;
3815:
3816: IF l_debug_level > 0 THEN
3817: oe_debug_pub.add('End of OE_Contracts_util.get_contract_defaults , x_return_status ' || x_return_status, 1);
3818: END IF;
3819:
3820: EXCEPTION
3821: WHEN FND_API.G_EXC_ERROR THEN

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

3907:
3908: BEGIN
3909:
3910: IF l_debug_level > 0 THEN
3911: oe_debug_pub.add('In OE_Contracts_util.get_contract_details_all ', 1);
3912: END IF;
3913:
3914: x_return_status := FND_API.G_RET_STS_SUCCESS;
3915:

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

3917: oe_msg_pub.initialize;
3918: END IF;
3919:
3920: --Check for licensing
3921: IF OE_Contracts_util.check_license() <> 'Y' THEN
3922: IF l_debug_level > 0 THEN
3923: oe_debug_pub.add('Contractual option not licensed, hence exiting get_contract_details_all ', 3);
3924: END IF;
3925: x_contract_source := NULL;

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

3978: RAISE FND_API.G_EXC_ERROR ;
3979: END IF;
3980:
3981: IF l_debug_level > 0 THEN
3982: oe_debug_pub.add('End of OE_Contracts_util.get_contract_details_all , x_return_status ' || x_return_status, 1);
3983: END IF;
3984:
3985: EXCEPTION
3986: WHEN FND_API.G_EXC_ERROR THEN

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

4060:
4061: BEGIN
4062:
4063: IF l_debug_level > 0 THEN
4064: oe_debug_pub.add('In OE_Contracts_util.Is_Terms_Template_Valid ', 1);
4065: END IF;
4066:
4067: x_return_status := FND_API.G_RET_STS_SUCCESS;
4068:

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

4070: oe_msg_pub.initialize;
4071: END IF;
4072:
4073: --Check for licensing
4074: IF OE_Contracts_util.check_license() <> 'Y' THEN
4075: IF l_debug_level > 0 THEN
4076: oe_debug_pub.add('Contractual option not licensed, hence exiting Is_Terms_Template_Valid ', 3);
4077: END IF;
4078: RETURN NULL;

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

4112: RAISE FND_API.G_EXC_ERROR ;
4113: END IF;
4114:
4115: IF l_debug_level > 0 THEN
4116: oe_debug_pub.add('End of OE_Contracts_util.Is_Terms_Template_Valid , x_return_status ' || x_return_status, 1);
4117: END IF;
4118:
4119: RETURN l_result;
4120:

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

4187: l_authoring_party_code VARCHAR2(100);
4188: BEGIN
4189:
4190: IF l_debug_level > 0 THEN
4191: oe_debug_pub.add('In OE_Contracts_util.Is_Auth_Party_Internal ', 1);
4192: END IF;
4193:
4194: --Check for licensing
4195: IF OE_Contracts_util.check_license() <> 'Y' THEN

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

4191: oe_debug_pub.add('In OE_Contracts_util.Is_Auth_Party_Internal ', 1);
4192: END IF;
4193:
4194: --Check for licensing
4195: IF OE_Contracts_util.check_license() <> 'Y' THEN
4196: IF l_debug_level > 0 THEN
4197: oe_debug_pub.add('Contractual option not licensed, hence exiting Is_Auth_Party_Internal ', 3);
4198: END IF;
4199:

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

4250:
4251: BEGIN
4252:
4253: IF l_debug_level > 0 THEN
4254: oe_debug_pub.add('In OE_Contracts_util.Is_RChg_Enabled ', 1);
4255: END IF;
4256: --Get the org_id
4257: BEGIN
4258: SELECT org_id into l_org_id

Line 4301: END OE_Contracts_util;

4297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4298:
4299: END Is_RChg_Enabled;
4300:
4301: END OE_Contracts_util;