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 1282: result :=OKC_TERMS_UTIL_GRP.Deviation_From_Standard(

1278: x_po_doc_subtype =>l_po_doc_subtype);
1279:
1280: --Call contracts to find out if contract terms deviated from standard template
1281:
1282: result :=OKC_TERMS_UTIL_GRP.Deviation_From_Standard(
1283: p_api_version => 1.0,
1284: p_doc_id => l_po_header_id,
1285: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1286: x_return_status => l_return_status,

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

1318: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1319: '250: End contracts_call_exception: IS_STANDARD_CONTRACT ');
1320: show_error(itemtype => itemtype,
1321: itemkey => itemkey,
1322: p_api_name =>'OKC_TERMS_UTIl_GRP.DEVIATION_FROM_STANDARD',
1323: p_return_status => l_return_status);
1324: END IF;
1325: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1326: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

Line 1431: result :=OKC_TERMS_UTIl_GRP.IS_TEMPLATE_EXPIRED(

1427: x_po_doc_type =>l_po_doc_type,
1428: x_po_doc_subtype =>l_po_doc_subtype);
1429:
1430: --Call contracts to find out if contract template expired
1431: result :=OKC_TERMS_UTIl_GRP.IS_TEMPLATE_EXPIRED(
1432: p_api_version => 1.0,
1433: p_doc_id => l_po_header_id,
1434: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1435: x_return_status => l_return_status,

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

1467: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1468: '250: End contracts_call_exception: IS_CONTRACT_TEMPLATE_EXPIRED ');
1469: show_error(itemtype => itemtype,
1470: itemkey => itemkey,
1471: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_CONTRACT_TEMPLATE_EXPIRED',
1472: p_return_status => l_return_status);
1473: END IF;
1474: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1475: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

Line 1582: result :=OKC_TERMS_UTIl_GRP.IS_ARTICLE_EXIST(

1578: x_po_doc_type =>l_po_doc_type,
1579: x_po_doc_subtype =>l_po_doc_subtype);
1580:
1581: --Call contracts to find out if contract articles attached
1582: result :=OKC_TERMS_UTIl_GRP.IS_ARTICLE_EXIST(
1583: p_api_version => 1.0,
1584: p_doc_id => l_po_header_id,
1585: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1586: x_return_status => l_return_status,

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

1618: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1619: '250: End contracts_call_exception: IS_CONTRACT_ARTICLES_EXIST ');
1620: show_error(itemtype => itemtype,
1621: itemkey => itemkey,
1622: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_ARTICLE_EXIST',
1623: p_return_status => l_return_status);
1624: END IF;
1625: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1626: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

Line 1734: result :=OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED(

1730: x_po_doc_type =>l_po_doc_type,
1731: x_po_doc_subtype =>l_po_doc_subtype);
1732:
1733: --Call contracts to find out if contract articles were amended in this revision
1734: result :=OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED(
1735: p_api_version => 1.0,
1736: p_doc_id => l_po_header_id,
1737: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1738: x_return_status => l_return_status,

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

1770: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1771: '250: End contracts_call_exception: IS_CONTRACT_ARTICLES_AMENDED ');
1772: show_error(itemtype => itemtype,
1773: itemkey => itemkey,
1774: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED',
1775: p_return_status => l_return_status);
1776: END IF;
1777: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1778: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

Line 1889: result :=OKC_TERMS_UTIL_GRP.Is_Deliverable_Exist(

1885: x_po_doc_type =>l_po_doc_type,
1886: x_po_doc_subtype =>l_po_doc_subtype);
1887:
1888: --Call contracts to find out if contract deliverables were amended in this revision
1889: result :=OKC_TERMS_UTIL_GRP.Is_Deliverable_Exist(
1890: p_api_version => 1.0,
1891: p_doc_id => l_po_header_id,
1892: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1893: x_return_status => l_return_status,

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

1927: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1928: '250: End contracts_call_exception: IS_CONTRACT_DELIVRABLS_EXIST ');
1929: show_error(itemtype => itemtype,
1930: itemkey => itemkey,
1931: p_api_name =>'OKC_TERMS_UTIl_GRP.Is_Deliverable_Exist',
1932: p_return_status => l_return_status);
1933: END IF;
1934: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1935: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

Line 2045: result :=OKC_TERMS_UTIL_GRP.Is_Deliverable_Amended(

2041: x_po_doc_type =>l_po_doc_type,
2042: x_po_doc_subtype =>l_po_doc_subtype);
2043:
2044: --Call contracts to find out if contract deliverables were amended in this revision
2045: result :=OKC_TERMS_UTIL_GRP.Is_Deliverable_Amended(
2046: p_api_version => 1.0,
2047: p_doc_id => l_po_header_id,
2048: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
2049: x_return_status => l_return_status,

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

2083: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
2084: '250: End contracts_call_exception: IS_CONTRACT_DELIVRABLS_AMENDED ');
2085: show_error(itemtype => itemtype,
2086: itemkey => itemkey,
2087: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_DELIVERABLE_AMENDED',
2088: p_return_status => l_return_status);
2089: END IF;
2090: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2091: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);