DBA Data[Home] [Help]

APPS.PO_CONTERMS_WF_PVT dependencies on OKC_TERMS_UTIL_GRP

Line 363: l_api_name := 'OKC_TERMS_UTIL_GRP.CONTRACT_TERMS_AMENDED';

359: -- Bug 4100563: OKC has provided a new API contract_terms_amended to check if
360: -- the primary contract document has changed. We are
361: -- calling this new API as an additional check here.
362: -- Start bug 4100563
363: l_api_name := 'OKC_TERMS_UTIL_GRP.CONTRACT_TERMS_AMENDED';
364:
365: IF (g_po_wf_debug = 'Y') THEN
366: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
367: '130: Return status before the call'||l_return_status);

Line 369: '132: Call OKC_TERMS_UTIL_GRP.contract_terms_amended');

365: IF (g_po_wf_debug = 'Y') THEN
366: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
367: '130: Return status before the call'||l_return_status);
368: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
369: '132: Call OKC_TERMS_UTIL_GRP.contract_terms_amended');
370: END IF;
371:
372: l_k_terms_changed := OKC_TERMS_UTIL_GRP.CONTRACT_TERMS_AMENDED(
373: p_api_version => 1.0,

Line 372: l_k_terms_changed := OKC_TERMS_UTIL_GRP.CONTRACT_TERMS_AMENDED(

368: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
369: '132: Call OKC_TERMS_UTIL_GRP.contract_terms_amended');
370: END IF;
371:
372: l_k_terms_changed := OKC_TERMS_UTIL_GRP.CONTRACT_TERMS_AMENDED(
373: p_api_version => 1.0,
374: p_doc_id => l_po_header_id,
375: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
376: x_return_status => l_return_status,

Line 399: l_api_name := 'OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED';

395:
396: --End Bug 4100563
397:
398: --Call contracts to find out if contract terms changed
399: l_api_name := 'OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED';
400: IF (g_po_wf_debug = 'Y') THEN
401: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
402: '140: Return status Before the call'||l_return_status);
403: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

Line 404: '142: Call OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED');

400: IF (g_po_wf_debug = 'Y') THEN
401: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
402: '140: Return status Before the call'||l_return_status);
403: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
404: '142: Call OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED');
405: END IF;
406:
407: l_k_terms_changed :=OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED(
408: p_api_version => 1.0,

Line 407: l_k_terms_changed :=OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED(

403: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
404: '142: Call OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED');
405: END IF;
406:
407: l_k_terms_changed :=OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED(
408: p_api_version => 1.0,
409: p_doc_id => l_po_header_id,
410: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
411: x_return_status => l_return_status,

Line 428: '160: Call OKC_TERMS_UTIl_GRP.Is_Deliverable_Amended');

424: IF (g_po_wf_debug = 'Y') THEN
425: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
426: '155: K Articles changed: N'||l_k_terms_changed);
427: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
428: '160: Call OKC_TERMS_UTIl_GRP.Is_Deliverable_Amended');
429: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
430: '162: Return status Before the call'||l_return_status);
431: END IF;
432:

Line 433: l_api_name := 'OKC_TERMS_UTIl_GRP.Is_Deliverable_Amended';

429: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
430: '162: Return status Before the call'||l_return_status);
431: END IF;
432:
433: l_api_name := 'OKC_TERMS_UTIl_GRP.Is_Deliverable_Amended';
434: l_k_terms_changed :=OKC_TERMS_UTIl_GRP.Is_Deliverable_Amended(
435: p_api_version => 1.0,
436: p_doc_id => l_po_header_id,
437: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),

Line 434: l_k_terms_changed :=OKC_TERMS_UTIl_GRP.Is_Deliverable_Amended(

430: '162: Return status Before the call'||l_return_status);
431: END IF;
432:
433: l_api_name := 'OKC_TERMS_UTIl_GRP.Is_Deliverable_Amended';
434: l_k_terms_changed :=OKC_TERMS_UTIl_GRP.Is_Deliverable_Amended(
435: p_api_version => 1.0,
436: p_doc_id => l_po_header_id,
437: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
438: x_return_status => l_return_status,

Line 622: l_k_api_name:='OKC_TERMS_UTIl_GRP.Get_Last_Update_Date';

618: MODULE =>g_module_prefix||l_api_name,
619: MESSAGE =>'50: It is a procurement Contract');
620: END IF;
621: End if;
622: l_k_api_name:='OKC_TERMS_UTIl_GRP.Get_Last_Update_Date';
623: IF g_fnd_debug = 'Y' then
624: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
625: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
626: MODULE =>g_module_prefix||l_api_name,

Line 627: MESSAGE =>'70: Before call to OKC_TERMS_UTIl_GRP.Get_Last_Update_Date');

623: IF g_fnd_debug = 'Y' then
624: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
625: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
626: MODULE =>g_module_prefix||l_api_name,
627: MESSAGE =>'70: Before call to OKC_TERMS_UTIl_GRP.Get_Last_Update_Date');
628: END IF;
629: End if;
630: OKC_TERMS_UTIl_GRP.Get_Last_Update_Date(
631: p_api_version => 1.0,

Line 630: OKC_TERMS_UTIl_GRP.Get_Last_Update_Date(

626: MODULE =>g_module_prefix||l_api_name,
627: MESSAGE =>'70: Before call to OKC_TERMS_UTIl_GRP.Get_Last_Update_Date');
628: END IF;
629: End if;
630: OKC_TERMS_UTIl_GRP.Get_Last_Update_Date(
631: p_api_version => 1.0,
632: p_doc_id => p_po_header_id,
633: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(p_po_doc_subtype),
634: x_deliverable_changed_date => l_deliv_upd_date,

Line 1301: result :=OKC_TERMS_UTIL_GRP.Deviation_From_Standard(

1297: x_po_doc_subtype =>l_po_doc_subtype);
1298:
1299: --Call contracts to find out if contract terms deviated from standard template
1300:
1301: result :=OKC_TERMS_UTIL_GRP.Deviation_From_Standard(
1302: p_api_version => 1.0,
1303: p_doc_id => l_po_header_id,
1304: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1305: x_return_status => l_return_status,

Line 1341: p_api_name =>'OKC_TERMS_UTIl_GRP.DEVIATION_FROM_STANDARD',

1337: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1338: '250: End contracts_call_exception: IS_STANDARD_CONTRACT ');
1339: show_error(itemtype => itemtype,
1340: itemkey => itemkey,
1341: p_api_name =>'OKC_TERMS_UTIl_GRP.DEVIATION_FROM_STANDARD',
1342: p_return_status => l_return_status);
1343: END IF;
1344: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1345: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

Line 1450: result :=OKC_TERMS_UTIl_GRP.IS_TEMPLATE_EXPIRED(

1446: x_po_doc_type =>l_po_doc_type,
1447: x_po_doc_subtype =>l_po_doc_subtype);
1448:
1449: --Call contracts to find out if contract template expired
1450: result :=OKC_TERMS_UTIl_GRP.IS_TEMPLATE_EXPIRED(
1451: p_api_version => 1.0,
1452: p_doc_id => l_po_header_id,
1453: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1454: x_return_status => l_return_status,

Line 1490: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_CONTRACT_TEMPLATE_EXPIRED',

1486: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1487: '250: End contracts_call_exception: IS_CONTRACT_TEMPLATE_EXPIRED ');
1488: show_error(itemtype => itemtype,
1489: itemkey => itemkey,
1490: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_CONTRACT_TEMPLATE_EXPIRED',
1491: p_return_status => l_return_status);
1492: END IF;
1493: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1494: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

Line 1601: result :=OKC_TERMS_UTIl_GRP.IS_ARTICLE_EXIST(

1597: x_po_doc_type =>l_po_doc_type,
1598: x_po_doc_subtype =>l_po_doc_subtype);
1599:
1600: --Call contracts to find out if contract articles attached
1601: result :=OKC_TERMS_UTIl_GRP.IS_ARTICLE_EXIST(
1602: p_api_version => 1.0,
1603: p_doc_id => l_po_header_id,
1604: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1605: x_return_status => l_return_status,

Line 1641: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_ARTICLE_EXIST',

1637: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1638: '250: End contracts_call_exception: IS_CONTRACT_ARTICLES_EXIST ');
1639: show_error(itemtype => itemtype,
1640: itemkey => itemkey,
1641: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_ARTICLE_EXIST',
1642: p_return_status => l_return_status);
1643: END IF;
1644: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1645: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

Line 1753: result :=OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED(

1749: x_po_doc_type =>l_po_doc_type,
1750: x_po_doc_subtype =>l_po_doc_subtype);
1751:
1752: --Call contracts to find out if contract articles were amended in this revision
1753: result :=OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED(
1754: p_api_version => 1.0,
1755: p_doc_id => l_po_header_id,
1756: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1757: x_return_status => l_return_status,

Line 1793: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED',

1789: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1790: '250: End contracts_call_exception: IS_CONTRACT_ARTICLES_AMENDED ');
1791: show_error(itemtype => itemtype,
1792: itemkey => itemkey,
1793: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED',
1794: p_return_status => l_return_status);
1795: END IF;
1796: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1797: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

Line 1908: result :=OKC_TERMS_UTIL_GRP.Is_Deliverable_Exist(

1904: x_po_doc_type =>l_po_doc_type,
1905: x_po_doc_subtype =>l_po_doc_subtype);
1906:
1907: --Call contracts to find out if contract deliverables were amended in this revision
1908: result :=OKC_TERMS_UTIL_GRP.Is_Deliverable_Exist(
1909: p_api_version => 1.0,
1910: p_doc_id => l_po_header_id,
1911: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1912: x_return_status => l_return_status,

Line 1950: p_api_name =>'OKC_TERMS_UTIl_GRP.Is_Deliverable_Exist',

1946: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1947: '250: End contracts_call_exception: IS_CONTRACT_DELIVRABLS_EXIST ');
1948: show_error(itemtype => itemtype,
1949: itemkey => itemkey,
1950: p_api_name =>'OKC_TERMS_UTIl_GRP.Is_Deliverable_Exist',
1951: p_return_status => l_return_status);
1952: END IF;
1953: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1954: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

Line 2064: result :=OKC_TERMS_UTIL_GRP.Is_Deliverable_Amended(

2060: x_po_doc_type =>l_po_doc_type,
2061: x_po_doc_subtype =>l_po_doc_subtype);
2062:
2063: --Call contracts to find out if contract deliverables were amended in this revision
2064: result :=OKC_TERMS_UTIL_GRP.Is_Deliverable_Amended(
2065: p_api_version => 1.0,
2066: p_doc_id => l_po_header_id,
2067: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
2068: x_return_status => l_return_status,

Line 2106: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_DELIVERABLE_AMENDED',

2102: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
2103: '250: End contracts_call_exception: IS_CONTRACT_DELIVRABLS_AMENDED ');
2104: show_error(itemtype => itemtype,
2105: itemkey => itemkey,
2106: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_DELIVERABLE_AMENDED',
2107: p_return_status => l_return_status);
2108: END IF;
2109: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2110: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);