[Home] [Help]
3:
4: ---------------------------------------------------------------------------
5: -- GLOBAL MESSAGE CONSTANTS
6: ---------------------------------------------------------------------------
7: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
8: ---------------------------------------------------------------------------
9: -- GLOBAL VARIABLES
10: ---------------------------------------------------------------------------
11: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TERMS_COPY_GRP';
8: ---------------------------------------------------------------------------
9: -- GLOBAL VARIABLES
10: ---------------------------------------------------------------------------
11: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TERMS_COPY_GRP';
12: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
13:
14: ------------------------------------------------------------------------------
15: -- GLOBAL CONSTANTS
16: ------------------------------------------------------------------------------
24:
25: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
26: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
27: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
28: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
29: G_CURRENT_ORG_ID NUMBER := -99;
30: G_ORG_ID NUMBER ;
31: G_PO_STATUS_CODE PO_HEADERS_ALL.STATUS_LOOKUP_CODE%TYPE;
32: G_DIR_NAME VARCHAR2(2000);
175: OPEN l_doc_type_csr;
176: FETCH l_doc_type_csr INTO G_DOC_TYPE_REC;
177: IF l_doc_type_csr%NOTFOUND THEN
178: --Invalid document type
179: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
180: p_msg_name => 'OKC_TERMS_INVALID_DOC_TYPE',
181: p_token1 => 'P_DOCUMENT_TYPE',
182: p_token1_value => p_document_type);
183:
190: OPEN l_po_doc_csr;
191: FETCH l_po_doc_csr INTO l_po_type_code,l_po_status_code,g_org_id,g_document_number;
192: IF l_po_doc_csr%NOTFOUND THEN
193: --Invalid document ID
194: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
195: p_msg_name => 'OKC_TERMS_INVALID_DOC_ID',
196: p_token1 => 'P_DOCUMENT_ID',
197: p_token1_value => p_document_id);
198: x_return_status := G_RET_STS_ERROR;
200: CLOSE l_po_doc_csr;
201:
202: IF substr(p_document_type,4,length(p_document_type)-3) <> l_po_type_code THEN
203: --Invalid document
204: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
205: p_msg_name => 'OKC_TERMS_INVALID_DOC_TYPE',
206: p_token1 => 'P_DOCUMENT_TYPE',
207: p_token1_value => p_document_type);
208: x_return_status := G_RET_STS_ERROR;
221: OPEN l_sa_doc_csr;
222: FETCH l_sa_doc_csr INTO g_org_id,g_document_number;
223: IF l_sa_doc_csr%NOTFOUND THEN
224: --Invalid document ID
225: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
226: p_msg_name => 'OKC_TERMS_INVALID_DOC_ID',
227: p_token1 => 'P_DOCUMENT_ID',
228: p_token1_value => p_document_id);
229: x_return_status := G_RET_STS_ERROR;
234: OPEN l_so_doc_csr;
235: FETCH l_so_doc_csr INTO g_org_id,g_document_number;
236: IF l_so_doc_csr%NOTFOUND THEN
237: --Invalid document ID
238: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
239: p_msg_name => 'OKC_TERMS_INVALID_DOC_ID',
240: p_token1 => 'P_DOCUMENT_ID',
241: p_token1_value => p_document_id);
242: x_return_status := G_RET_STS_ERROR;
247: OPEN l_rep_doc_csr;
248: FETCH l_rep_doc_csr INTO g_org_id, g_document_number;
249: IF l_rep_doc_csr%NOTFOUND THEN
250: --Invalid document ID
251: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
252: p_msg_name => 'OKC_TERMS_INVALID_DOC_ID',
253: p_token1 => 'P_DOCUMENT_ID',
254: p_token1_value => p_document_id);
255: x_return_status := G_RET_STS_ERROR;
261: THEN
262: OPEN l_sourcing_doc_csr;
263: FETCH l_sourcing_doc_csr INTO g_org_id, G_TARGET_DOC_TYPE;
264: IF l_sourcing_doc_csr%NOTFOUND THEN
265: okc_Api.Set_Message(p_app_name => G_APP_NAME,
266: p_msg_name => 'OKC_TERMS_INVALID_DOC_ID',
267: p_token1 => 'P_DOCUMENT_ID',
268: p_token1_value => p_document_id);
269: x_return_status := G_RET_STS_ERROR;
298:
299: BEGIN
300: l_file_exists := dbms_lob.fileexists(l_from_file);
301: IF l_file_exists = 0 THEN
302: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
303: p_msg_name => 'OKC_TERMS_INV_FILE');
304: x_return_status := G_RET_STS_ERROR;
305: ELSIF l_file_exists = 1 THEN
306: x_return_status := G_RET_STS_SUCCESS;
305: ELSIF l_file_exists = 1 THEN
306: x_return_status := G_RET_STS_SUCCESS;
307: ELSE
308: l_file_exists := 0;
309: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
310: p_msg_name => 'OKC_TERMS_INV_FILE');
311: x_return_status := G_RET_STS_ERROR;
312: END IF;
313: EXCEPTION
311: x_return_status := G_RET_STS_ERROR;
312: END IF;
313: EXCEPTION
314: WHEN DBMS_LOB.NOEXIST_DIRECTORY THEN
315: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
316: p_msg_name => 'OKC_TERMS_INV_DIR');
317: l_file_exists := 0;
318: x_return_status := G_RET_STS_ERROR;
319: WHEN DBMS_LOB.NOPRIV_DIRECTORY THEN
316: p_msg_name => 'OKC_TERMS_INV_DIR');
317: l_file_exists := 0;
318: x_return_status := G_RET_STS_ERROR;
319: WHEN DBMS_LOB.NOPRIV_DIRECTORY THEN
320: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
321: p_msg_name => 'OKC_TERMS_INV_DIR');
322: l_file_exists := 0;
323: x_return_status := G_RET_STS_ERROR;
324: WHEN DBMS_LOB.INVALID_DIRECTORY THEN
321: p_msg_name => 'OKC_TERMS_INV_DIR');
322: l_file_exists := 0;
323: x_return_status := G_RET_STS_ERROR;
324: WHEN DBMS_LOB.INVALID_DIRECTORY THEN
325: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
326: p_msg_name => 'OKC_TERMS_INV_DIR');
327: l_file_exists := 0;
328: x_return_status := G_RET_STS_ERROR;
329: END ;
634:
635: -- Check that Contract source is Structured or Attached
636: IF p_contract_source not in ('STRUCTURED','ATTACHED') THEN
637: -- invalid contract source
638: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
639: p_msg_name => 'OKC_TERMS_INVALID_SOURCE',
640: p_token1 => 'P_CONTRACT_SOURCE',
641: p_token1_value => p_contract_source);
642: x_return_status := G_RET_STS_ERROR;
653:
654: IF p_contract_source ='STRUCTURED' THEN
655: IF p_contract_tmpl_name is NULL AND p_contract_tmpl_id is NULL THEN
656: -- no template is provided
657: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
658: p_msg_name => 'OKC_TERMS_NO_TMPL_PROVIDED');
659: x_return_status := G_RET_STS_ERROR;
660: RAISE FND_API.G_EXC_ERROR ;
661: END IF;
662:
663: ELSIF p_contract_source='ATTACHED' THEN
664: IF l_attachment_file_loc is NULL OR l_attachment_file_name is NULL THEN
665: -- either attachment file location is not provided or file name is not provided
666: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
667: p_msg_name => 'OKC_TERMS_NO_ATTACH_PROVIDED');
668: x_return_status := G_RET_STS_ERROR;
669: RAISE FND_API.G_EXC_ERROR ;
670: END IF;
676: OPEN l_tmpl_id_validate_csr;
677: FETCH l_tmpl_id_validate_csr INTO l_tmpl_type_rec ;
678: IF l_tmpl_id_validate_csr%NOTFOUND THEN
679: --Invalid Template ID
680: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
681: p_msg_name => 'OKC_TERMS_INVALID_TMPL_ID',
682: p_token1 => 'P_TMPL_ID',
683: p_token1_value => p_contract_tmpl_id);
684: x_return_status := G_RET_STS_ERROR;
690: OPEN l_tmpl_name_validate_csr(G_CURRENT_ORG_ID);
691: FETCH l_tmpl_name_validate_csr INTO l_tmpl_type_rec ;
692: IF l_tmpl_name_validate_csr%NOTFOUND THEN
693: --Invalid Template Name
694: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
695: p_msg_name => 'OKC_TERMS_INVALID_TMPL_NAME',
696: p_token1 => 'P_TMPL_NAME',
697: p_token1_value => p_contract_tmpl_name);
698: x_return_status := G_RET_STS_ERROR;
704:
705: /*IF p_document_type IN ('PA_BLANKET', 'PA_CONTRACT','PO_STANDARD') AND
706: l_tmpl_type_rec.intent = 'S' THEN
707: --Template is of Sell Intent
708: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
709: p_msg_name => 'OKC_TERMS_INV_TMPL_INTENT',
710: p_token1 => 'P_TEMPLATE_NAME',
711: p_token1_value => l_tmpl_type_rec.template_name,
712: p_token2 => 'P_TEMPLATE_INTENT',
719:
720: IF p_document_type IN ('B', 'O') AND
721: l_tmpl_type_rec.intent = 'B' THEN
722: --Template is of Buy Intent
723: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
724: p_msg_name => 'OKC_TERMS_INV_TMPL_INTENT',
725: p_token1 => 'P_TEMPLATE_NAME',
726: p_token1_value => l_tmpl_type_rec.template_name,
727: p_token2 => 'P_TEMPLATE_INTENT',
737: CLOSE c_get_intent_csr;
738:
739: IF l_doc_intent <> l_tmpl_type_rec.intent THEN
740:
741: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
742: p_msg_name => 'OKC_TERMS_INV_TMPL_INTENT',
743: p_token1 => 'P_TEMPLATE_NAME',
744: p_token1_value => l_tmpl_type_rec.template_name,
745: p_token2 => 'P_TEMPLATE_INTENT',
755:
756:
757: IF l_tmpl_type_rec.status_code <> 'APPROVED' THEN
758: --Invalid Template Status
759: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
760: p_msg_name => 'OKC_TERMS_INV_TMPL_STS',
761: p_token1 => 'P_TEMPLATE_NAME',
762: p_token1_value => l_tmpl_type_rec.template_name);
763: x_return_status := G_RET_STS_ERROR;
765: END IF;
766:
767: IF SYSDATE NOT BETWEEN l_tmpl_type_rec.start_date AND nvl(l_tmpl_type_rec.end_date,SYSDATE) THEN
768: --Template is not Active
769: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
770: p_msg_name => 'OKC_TERMS_INACTIVE_TMPL',
771: p_token1 => 'P_TEMPLATE_NAME',
772: p_token1_value => l_tmpl_type_rec.template_name);
773: x_return_status := G_RET_STS_ERROR;
777: OPEN l_alwd_usgs_csr(l_tmpl_type_rec.template_id);
778: FETCH l_alwd_usgs_csr INTO l_dummy ;
779: IF l_alwd_usgs_csr%NOTFOUND THEN
780: --Template is not assigned to Document
781: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
782: p_msg_name => 'OKC_TERMS_TMPL_USG_ASSOC',
783: p_token1 => 'P_CONTRACT_TEMPLATE',
784: p_token1_value => l_tmpl_type_rec.template_id,
785: p_token2 => 'P_DOCUMENT_TYPE',
794: OPEN l_tmpl_doc_exist_csr;
795: FETCH l_tmpl_doc_exist_csr INTO l_dummy ;
796: IF l_tmpl_doc_exist_csr%FOUND THEN
797: --Document already has Template
798: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
799: p_msg_name => 'OKC_TERMS_EXIST');
800: x_return_status := G_RET_STS_ERROR;
801: RAISE FND_API.G_EXC_ERROR ;
802: END IF;
1171:
1172: WHEN FND_API.G_EXC_ERROR THEN
1173:
1174: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1175: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving create_contract_terms: OKC_API.G_EXCEPTION_ERROR Exception');
1176: END IF;
1177: IF l_tmpl_id_validate_csr%ISOPEN THEN
1178: CLOSE l_tmpl_id_validate_csr;
1179: END IF;
1192: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1193:
1194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1195: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1196: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving create_contract_terms: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1197: END IF;
1198:
1199: ROLLBACK TO g_create_contract_terms_grp;
1200: x_return_status := G_RET_STS_UNEXP_ERROR ;
1349:
1350:
1351: IF G_DOC_TYPE_REC.enable_attachments_yn = 'N' THEN
1352: --Attachment functionality is not supported
1353: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1354: p_msg_name => 'OKC_TERMS_NO_ATTACH',
1355: p_token1 => 'P_DOC_NAME',
1356: p_token1_value => G_DOC_TYPE_REC.name);
1357: x_return_status := G_RET_STS_ERROR;
1361: OPEN l_tmpl_doc_exist_csr;
1362: FETCH l_tmpl_doc_exist_csr INTO l_dummy ;
1363: IF l_tmpl_doc_exist_csr%NOTFOUND THEN
1364: --Document does not have Template
1365: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1366: p_msg_name => 'OKC_TERMS_NOT_EXIST',
1367: p_token1 => 'P_DOC_NAME',
1368: p_token1_value => G_DOC_TYPE_REC.name);
1369: x_return_status := G_RET_STS_ERROR;
1372: CLOSE l_tmpl_doc_exist_csr;
1373:
1374: IF p_contract_category NOT IN ('C','S') THEN
1375: -- Contract Category is not correct
1376: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1377: p_msg_name => 'OKC_INVALID_CON_CAT');
1378: x_return_status := G_RET_STS_ERROR;
1379: RAISE FND_API.G_EXC_ERROR ;
1380: ELSE
1386: END IF;
1387:
1388: IF p_contract_doc_type NOT IN ('U','F') THEN
1389: -- Contract Doc Type is not correct
1390: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1391: p_msg_name => 'OKC_INVALID_CON_DOC_TYPE');
1392: x_return_status := G_RET_STS_ERROR;
1393: RAISE FND_API.G_EXC_ERROR ;
1394: ELSE
1400: END IF;
1401:
1402: IF l_datatype_id = 5 AND p_url IS NULL THEN
1403: -- URL is not provided
1404: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1405: p_msg_name => 'OKC_INVALID_URL');
1406: x_return_status := G_RET_STS_ERROR;
1407: RAISE FND_API.G_EXC_ERROR ;
1408: END IF;
1409:
1410: IF l_datatype_id = 6 AND
1411: (p_attachment_file_name IS NULL OR p_attachment_file_loc IS NULL) THEN
1412: -- file info is not provided
1413: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1414: p_msg_name => 'OKC_INVALID_FILE_INFO');
1415: x_return_status := G_RET_STS_ERROR;
1416: RAISE FND_API.G_EXC_ERROR ;
1417: END IF;
1640:
1641: WHEN FND_API.G_EXC_ERROR THEN
1642:
1643: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1644: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving add_contract_doc: OKC_API.G_EXCEPTION_ERROR Exception');
1645: END IF;
1646: IF l_tmpl_doc_exist_csr%ISOPEN THEN
1647: CLOSE l_tmpl_doc_exist_csr;
1648: END IF;
1652: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1653:
1654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1655: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1656: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving add_contract_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1657: END IF;
1658:
1659: ROLLBACK TO g_add_contract_doc_grp;
1660: x_return_status := G_RET_STS_UNEXP_ERROR ;
1854: END IF;
1855:
1856: IF p_section_id is NULL and p_section_name is NULL THEN
1857: -- no section is provided
1858: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1859: p_msg_name => 'OKC_TERMS_NO_SCN');
1860: x_return_status := G_RET_STS_ERROR;
1861: RAISE FND_API.G_EXC_ERROR ;
1862: END IF;
1865: OPEN l_sec_id_validate_csr;
1866: FETCH l_sec_id_validate_csr INTO l_scn_id;
1867: IF l_sec_id_validate_csr%NOTFOUND THEN
1868: --Invalid Section
1869: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1870: p_msg_name => 'OKC_TERMS_NO_SCN_ID',
1871: p_token1 => 'P_SCN_ID',
1872: p_token1_value => p_section_id);
1873: x_return_status := G_RET_STS_ERROR;
1878: OPEN l_sec_name_validate_csr;
1879: FETCH l_sec_name_validate_csr INTO l_scn_id;
1880: IF l_sec_name_validate_csr%NOTFOUND THEN
1881: --Invalid Section
1882: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1883: p_msg_name => 'OKC_TERMS_NO_SCN_NAME',
1884: p_token1 => 'P_SCN_NAME',
1885: p_token1_value => p_section_name);
1886: x_return_status := G_RET_STS_ERROR;
1911:
1912: -- Check that Clause info is provided
1913: IF p_clause_version_id is NULL and p_clause_title is NULL THEN
1914: -- no clause is provided
1915: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1916: p_msg_name => 'OKC_TERMS_INV_CLS');
1917: x_return_status := G_RET_STS_ERROR;
1918: RAISE FND_API.G_EXC_ERROR ;
1919: END IF;
1922: OPEN l_cls_id_validate_csr;
1923: FETCH l_cls_id_validate_csr INTO l_cls_type_rec ;
1924: IF l_cls_id_validate_csr%NOTFOUND THEN
1925: --Invalid Clause
1926: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1927: p_msg_name => 'OKC_TERMS_INV_CLS_ID',
1928: p_token1 => 'P_CLS_VER_ID',
1929: p_token1_value => p_clause_version_id);
1930: x_return_status := G_RET_STS_ERROR;
1936: OPEN l_cls_name_validate_csr(G_CURRENT_ORG_ID);
1937: FETCH l_cls_name_validate_csr INTO l_cls_type_rec ;
1938: IF l_cls_name_validate_csr%NOTFOUND THEN
1939: --Invalid Clause Name
1940: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1941: p_msg_name => 'OKC_TERMS_INV_CLS_NAME',
1942: p_token1 => 'P_CLS_TITLE',
1943: p_token1_value => p_clause_title);
1944: x_return_status := G_RET_STS_ERROR;
1949: END IF;
1950:
1951: IF l_cls_type_rec.article_status <> 'APPROVED' THEN
1952: --Invalid Clause Status
1953: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1954: p_msg_name => 'OKC_TERMS_INV_CLS_STS',
1955: p_token1 => 'P_CLAUSE_TITLE',
1956: p_token1_value => l_cls_type_rec.article_title);
1957: x_return_status := G_RET_STS_ERROR;
1960:
1961: /*IF p_document_type IN ('PA_BLANKET', 'PA_CONTRACT','PO_STANDARD', 'AUCTION', 'RFI', 'RFQ') AND
1962: l_cls_type_rec.article_intent = 'S' THEN
1963: --Clause is of Sell Intent
1964: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1965: p_msg_name => 'OKC_TERMS_INV_CLS_INTENT',
1966: p_token1 => 'P_CLAUSE_TITLE',
1967: p_token1_value => l_cls_type_rec.article_title,
1968: p_token2 => 'P_CLAUSE_INTENT',
1975:
1976: IF p_document_type IN ('B', 'O', 'QUOTE', 'OKS') AND
1977: l_cls_type_rec.article_intent = 'B' THEN
1978: --Clause is of Buy Intent
1979: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1980: p_msg_name => 'OKC_TERMS_INV_CLS_INTENT',
1981: p_token1 => 'P_CLAUSE_TITLE',
1982: p_token1_value => l_cls_type_rec.article_title,
1983: p_token2 => 'P_CLAUSE_INTENT',
1993: CLOSE c_get_intent_csr;
1994:
1995: IF l_doc_intent <> l_cls_type_rec.article_intent THEN
1996:
1997: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1998: p_msg_name => 'OKC_TERMS_INV_CLS_INTENT',
1999: p_token1 => 'P_CLAUSE_TITLE',
2000: p_token1_value => l_cls_type_rec.article_title,
2001: p_token2 => 'P_CLAUSE_INTENT',
2011: -- otherwise check clause is of not provision = 'y'
2012: IF G_DOC_TYPE_REC.provision_allowed_yn = 'N' AND
2013: l_cls_type_rec.provision_yn = 'Y' THEN
2014: --Clause is of Provision Type 'Y' not allowed
2015: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2016: p_msg_name => 'OKC_TERMS_INV_CLS_PROV',
2017: p_token1 => 'P_CLAUSE_TITLE',
2018: p_token1_value => l_cls_type_rec.article_title,
2019: p_token2 => 'P_DOCUMENT_TYPE',
2095:
2096: WHEN FND_API.G_EXC_ERROR THEN
2097:
2098: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2099: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving add_standard_clause: OKC_API.G_EXCEPTION_ERROR Exception');
2100: END IF;
2101:
2102: IF l_sec_id_validate_csr%ISOPEN THEN
2103: CLOSE l_sec_id_validate_csr;
2117: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2118:
2119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2120: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2121: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving add_standard_clause: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2122: END IF;
2123:
2124: ROLLBACK TO g_add_standard_clause_grp;
2125: x_return_status := G_RET_STS_UNEXP_ERROR ;
2240: END IF;
2241:
2242: IF p_section_id is NULL and p_section_name is NULL THEN
2243: -- no section is provided
2244: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2245: p_msg_name => 'OKC_TERMS_NO_SCN');
2246: x_return_status := G_RET_STS_ERROR;
2247: RAISE FND_API.G_EXC_ERROR ;
2248: END IF;
2251: OPEN l_sec_id_validate_csr;
2252: FETCH l_sec_id_validate_csr INTO l_scn_id;
2253: IF l_sec_id_validate_csr%NOTFOUND THEN
2254: --Invalid Section
2255: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2256: p_msg_name => 'OKC_TERMS_NO_SCN_ID',
2257: p_token1 => 'P_SCN_ID',
2258: p_token1_value => p_section_id);
2259: x_return_status := G_RET_STS_ERROR;
2264: OPEN l_sec_name_validate_csr;
2265: FETCH l_sec_name_validate_csr INTO l_scn_id;
2266: IF l_sec_name_validate_csr%NOTFOUND THEN
2267: --Invalid Section
2268: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2269: p_msg_name => 'OKC_TERMS_NO_SCN_NAME',
2270: p_token1 => 'P_SCN_NAME',
2271: p_token1_value => p_section_name);
2272: x_return_status := G_RET_STS_ERROR;
2278: /*If article_text is null and article_text in word is also null throw error*/
2279:
2280: IF p_clause_text is NULL and p_clause_text_in_word is NULL THEN
2281: -- no clause text is provided
2282: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2283: p_msg_name => 'OKC_TERMS_NO_CLS_TEXT');
2284: x_return_status := G_RET_STS_ERROR;
2285: RAISE FND_API.G_EXC_ERROR ;
2286: END IF;
2287:
2288: /*If edited in word is 'Y' then clause text is word is mandatory*/
2289: IF p_edited_in_word = 'Y' AND p_clause_text_in_word IS NULL THEN
2290: -- no wml clause text is provided
2291: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2292: p_msg_name => 'OKC_TERMS_INV_CLS_text');
2293: x_return_status := G_RET_STS_ERROR;
2294: RAISE FND_API.G_EXC_ERROR ;
2295: END IF;
2374:
2375: WHEN FND_API.G_EXC_ERROR THEN
2376:
2377: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2378: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving add_non_standard_clause: OKC_API.G_EXCEPTION_ERROR Exception');
2379: END IF;
2380: IF l_sec_id_validate_csr%ISOPEN THEN
2381: CLOSE l_sec_id_validate_csr;
2382: END IF;
2389: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2390:
2391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2392: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2393: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving add_non_standard_clause: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2394: END IF;
2395:
2396: ROLLBACK TO g_add_non_standrad_clause_grp;
2397: x_return_status := G_RET_STS_UNEXP_ERROR ;
2517: OPEN l_tmpl_doc_exist_csr;
2518: FETCH l_tmpl_doc_exist_csr INTO l_dummy ;
2519: IF l_tmpl_doc_exist_csr%NOTFOUND THEN
2520: --Document already has Template
2521: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2522: p_msg_name => 'OKC_TERMS_DOES_NOT_EXIST');
2523: x_return_status := G_RET_STS_ERROR;
2524: RAISE FND_API.G_EXC_ERROR ;
2525: END IF;
2527:
2528:
2529: IF p_section_source NOT IN ('LIBRARY','NEW') THEN
2530: --Invalid Source
2531: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2532: p_msg_name => 'OKC_TERMS_INV_SEC_SRC',
2533: p_token1 => 'P_SECTION_SOURCE',
2534: p_token1_value => p_section_source);
2535: x_return_status := G_RET_STS_ERROR;
2540: OPEN l_sec_validate_csr;
2541: FETCH l_sec_validate_csr INTO l_scn_code,l_scn_heading,l_scn_desc ;
2542: IF l_sec_validate_csr%NOTFOUND THEN
2543: -- Section does not exist in Contract Library
2544: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2545: p_msg_name => 'OKC_TERMS_INV_LIB_SCN',
2546: p_token1 => 'P_SECTION_NAME',
2547: p_token1_value => p_section_name);
2548: x_return_status := G_RET_STS_ERROR;
2636:
2637: WHEN FND_API.G_EXC_ERROR THEN
2638:
2639: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2640: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving add_section: OKC_API.G_EXCEPTION_ERROR Exception');
2641: END IF;
2642: IF l_sec_validate_csr%ISOPEN THEN
2643: CLOSE l_sec_validate_csr;
2644: END IF;
2648: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2649:
2650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2651: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2652: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving add_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2653: END IF;
2654:
2655: ROLLBACK TO g_add_section_grp;
2656: x_return_status := G_RET_STS_UNEXP_ERROR ;
2963: OPEN c_get_variable_code(l_var_intent);
2964: FETCH c_get_variable_code INTO l_variable_code, l_variable_type, l_external_yn, l_attr_value_set_id;
2965: IF c_get_variable_code%NOTFOUND THEN
2966: -- Variable does not exist in Contract Library
2967: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2968: p_msg_name => 'OKC_TERMS_INV_LIB_VAR',
2969: p_token1 => 'P_VARIABLE_NAME',
2970: p_token1_value => p_variable_name);
2971: x_return_status := G_RET_STS_ERROR;
3007: AND kb.sav_sae_id = a.article_id AND kb.article_version_id = v.article_version_id;
3008:
3009: ELSE
3010: -- Clause ID/clause name, version combination is null
3011: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3012: p_msg_name => 'OKC_TERMS_NO_CLS_VALUE',
3013: p_token1 => 'P_VARIABLE_NAME',
3014: p_token1_value => p_variable_name,
3015: p_token2 => 'P_VAR_VALUE_SET_ID',
3044: x_cat_id => l_x_cat_id,
3045: x_variable_code => l_x_variable_code);
3046:
3047: ELSE
3048: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3049: p_msg_name => 'OKC_ARTID_VAR_ALREADY_EXISTS',
3050: p_token1 => 'P_VARIABLE_NAME',
3051: p_token1_value => p_variable_name,
3052: p_token2 => 'P_K_ART_ID',
3075:
3076: WHEN FND_API.G_EXC_ERROR THEN
3077:
3078: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3079: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving update_variable_values: OKC_API.G_EXCEPTION_ERROR Exception');
3080: END IF;
3081: -- IF l_sec_validate_csr%ISOPEN THEN
3082: -- CLOSE l_sec_validate_csr;
3083: --END IF;
3087: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3088:
3089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3090: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3091: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving update_variable_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3092: END IF;
3093:
3094: ROLLBACK TO g_update_variable_values_GRP;
3095: x_return_status := G_RET_STS_UNEXP_ERROR ;
3282:
3283: -- Check that Contract source is Structured or Attached
3284: IF p_contract_source not in ('STRUCTURED','ATTACHED') THEN
3285: -- invalid contract source
3286: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3287: p_msg_name => 'OKC_TERMS_INVALID_SOURCE',
3288: p_token1 => 'P_CONTRACT_SOURCE',
3289: p_token1_value => p_contract_source);
3290: x_return_status := G_RET_STS_ERROR;
3293:
3294: IF p_contract_source ='STRUCTURED' THEN
3295: IF p_contract_tmpl_name is NULL AND p_contract_tmpl_id is NULL THEN
3296: -- no template is provided
3297: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3298: p_msg_name => 'OKC_TERMS_NO_TMPL_PROVIDED');
3299: x_return_status := G_RET_STS_ERROR;
3300: RAISE FND_API.G_EXC_ERROR ;
3301: END IF;
3307: OPEN l_tmpl_id_validate_csr;
3308: FETCH l_tmpl_id_validate_csr INTO l_tmpl_type_rec ;
3309: IF l_tmpl_id_validate_csr%NOTFOUND THEN
3310: --Invalid Template ID
3311: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3312: p_msg_name => 'OKC_TERMS_INVALID_TMPL_ID',
3313: p_token1 => 'P_TMPL_ID',
3314: p_token1_value => p_contract_tmpl_id);
3315: x_return_status := G_RET_STS_ERROR;
3321: OPEN l_tmpl_name_validate_csr(G_CURRENT_ORG_ID);
3322: FETCH l_tmpl_name_validate_csr INTO l_tmpl_type_rec ;
3323: IF l_tmpl_name_validate_csr%NOTFOUND THEN
3324: --Invalid Template Name
3325: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3326: p_msg_name => 'OKC_TERMS_INVALID_TMPL_NAME',
3327: p_token1 => 'P_TMPL_NAME',
3328: p_token1_value => p_contract_tmpl_name);
3329: x_return_status := G_RET_STS_ERROR;
3339: CLOSE c_get_intent_csr;
3340:
3341: IF l_doc_intent <> l_tmpl_type_rec.intent THEN
3342:
3343: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3344: p_msg_name => 'OKC_TERMS_INV_TMPL_INTENT',
3345: p_token1 => 'P_TEMPLATE_NAME',
3346: p_token1_value => l_tmpl_type_rec.template_name,
3347: p_token2 => 'P_TEMPLATE_INTENT',
3354: END IF;
3355:
3356: IF l_tmpl_type_rec.status_code <> 'APPROVED' THEN
3357: --Invalid Template Status
3358: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3359: p_msg_name => 'OKC_TERMS_INV_TMPL_STS',
3360: p_token1 => 'P_TEMPLATE_NAME',
3361: p_token1_value => l_tmpl_type_rec.template_name);
3362: x_return_status := G_RET_STS_ERROR;
3364: END IF;
3365:
3366: IF SYSDATE NOT BETWEEN l_tmpl_type_rec.start_date AND nvl(l_tmpl_type_rec.end_date,SYSDATE) THEN
3367: --Template is not Active
3368: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3369: p_msg_name => 'OKC_TERMS_INACTIVE_TMPL',
3370: p_token1 => 'P_TEMPLATE_NAME',
3371: p_token1_value => l_tmpl_type_rec.template_name);
3372: x_return_status := G_RET_STS_ERROR;
3376: OPEN l_alwd_usgs_csr(l_tmpl_type_rec.template_id);
3377: FETCH l_alwd_usgs_csr INTO l_dummy ;
3378: IF l_alwd_usgs_csr%NOTFOUND THEN
3379: --Template is not assigned to Document
3380: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3381: p_msg_name => 'OKC_TERMS_TMPL_USG_ASSOC',
3382: p_token1 => 'P_CONTRACT_TEMPLATE',
3383: p_token1_value => l_tmpl_type_rec.template_id,
3384: p_token2 => 'P_DOCUMENT_TYPE',
3393: OPEN l_tmpl_doc_exist_csr;
3394: FETCH l_tmpl_doc_exist_csr INTO l_dummy ;
3395: IF l_tmpl_doc_exist_csr%FOUND AND p_primary_template = 'Y' THEN
3396: --Document already has a primary Template
3397: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3398: p_msg_name => 'OKC_TERMS_EXIST');
3399: x_return_status := G_RET_STS_ERROR;
3400: RAISE FND_API.G_EXC_ERROR ;
3401: END IF;
3404: OPEN l_mlp_tmpl_doc_exist_csr;
3405: FETCH l_mlp_tmpl_doc_exist_csr INTO l_dummy_n;
3406: IF l_mlp_tmpl_doc_exist_csr%FOUND AND l_dummy = l_tmpl_type_rec.template_id THEN
3407: --Document already has this Template applied
3408: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3409: p_msg_name => 'OKC_TERMS_EXIST');
3410: x_return_status := G_RET_STS_ERROR;
3411: RAISE FND_API.G_EXC_ERROR ;
3412: END IF;
3489:
3490: WHEN FND_API.G_EXC_ERROR THEN
3491:
3492: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3493: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving create_template_usages: OKC_API.G_EXCEPTION_ERROR Exception');
3494: END IF;
3495: IF l_tmpl_id_validate_csr%ISOPEN THEN
3496: CLOSE l_tmpl_id_validate_csr;
3497: END IF;
3510: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3511:
3512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3513: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3514: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving create_template_usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3515: END IF;
3516:
3517: ROLLBACK TO g_create_contract_terms_grp;
3518: x_return_status := G_RET_STS_UNEXP_ERROR ;
4096: OPEN cur_val_bus_doc (p_deliverable_rec.BUSINESS_DOCUMENT_TYPE);
4097: FETCH cur_val_bus_doc INTO l_bus_doc_class,l_intent;
4098: IF cur_val_bus_doc%NOTFOUND THEN
4099: CLOSE cur_val_bus_doc;
4100: okc_api.set_message (p_app_name => g_app_name,
4101: p_msg_name => 'OKC_I_INVALID_VALUE',
4102: p_token1 => 'FIELD',
4103: p_token1_value => 'BUSINESS_DOCUMENT_TYPE'
4104: );
4113: OPEN cur_val_del_type (p_deliverable_rec.DELIVERABLE_TYPE);
4114: FETCH cur_val_del_type INTO l_val_flag;
4115: IF cur_val_del_type%NOTFOUND THEN
4116: CLOSE cur_val_del_type;
4117: okc_api.set_message (p_app_name => g_app_name,
4118: p_msg_name => 'OKC_I_INVALID_VALUE',
4119: p_token1 => 'FIELD',
4120: p_token1_value => 'DELIVERABLE_TYPE'
4121: );
4127: OPEN cur_val_resp_party(l_intent,l_bus_doc_class);
4128: FETCH cur_val_resp_party INTO l_val_flag;
4129: IF cur_val_resp_party%NOTFOUND THEN
4130: CLOSE cur_val_resp_party;
4131: okc_api.set_message (p_app_name => g_app_name,
4132: p_msg_name => 'OKC_I_INVALID_VALUE',
4133: p_token1 => 'FIELD',
4134: p_token1_value => 'RESPONSIBLE_PARTY'
4135: );
4151: )
4152:
4153: )
4154: THEN
4155: okc_api.set_message (p_app_name => g_app_name,
4156: p_msg_name => 'OKC_I_INVALID_VALUE',
4157: p_token1 => 'FIELD',
4158: p_token1_value => 'RESPONSIBLE_PARTY'
4159: );
4161: END IF; */
4162:
4163: -- Validate Internal Party ID
4164: IF p_deliverable_rec.internal_party_id IS NULL THEN
4165: okc_api.set_message (p_app_name => g_app_name,
4166: p_msg_name => 'OKC_I_NOT_NULL',
4167: p_token1 => 'FIELD',
4168: p_token1_value => 'INTERNAL_PARTY_ID'
4169: );
4174: OPEN cur_val_internal_party(p_deliverable_rec.internal_party_id);
4175: FETCH cur_val_internal_party INTO l_val_flag;
4176: IF cur_val_internal_party%NOTFOUND THEN
4177: CLOSE cur_val_internal_party;
4178: okc_api.set_message (p_app_name => g_app_name,
4179: p_msg_name => 'OKC_I_INVALID_VALUE',
4180: p_token1 => 'FIELD',
4181: p_token1_value => 'INTERNAL_PARTY_ID'
4182: );
4185: CLOSE cur_val_internal_party;
4186:
4187:
4188: IF p_deliverable_rec.INTERNAL_PARTY_CONTACT_ID IS NULL THEN
4189: okc_api.set_message (p_app_name => g_app_name,
4190: p_msg_name => 'OKC_I_NOT_NULL',
4191: p_token1 => 'FIELD',
4192: p_token1_value => 'INTERNAL_PARTY_CONTACT_ID'
4193: );
4198: IF p_deliverable_rec.internal_party_contact_id IS NOT NULL
4199: AND isvalidcontact (p_deliverable_rec.internal_party_contact_id) <>
4200: 'Y'
4201: THEN
4202: okc_api.set_message (p_app_name => g_app_name,
4203: p_msg_name => 'OKC_I_INVALID_VALUE',
4204: p_token1 => 'FIELD',
4205: p_token1_value => 'INTERNAL_PARTY_CONTACT_ID'
4206: );
4215: FETCH cur_val_ext_party_contact_id INTO l_val_flag;
4216:
4217: IF cur_val_ext_party_contact_id%NOTFOUND THEN
4218: CLOSE cur_val_ext_party_contact_id;
4219: okc_api.set_message (p_app_name => g_app_name,
4220: p_msg_name => 'OKC_I_INVALID_VALUE',
4221: p_token1 => 'FIELD',
4222: p_token1_value => 'EXTERNAL_PARTY_CONTACT_ID'
4223: );
4229:
4230: IF p_deliverable_rec.requester_id IS NOT NULL
4231: AND isvalidcontact (p_deliverable_rec.requester_id) <> 'Y'
4232: THEN
4233: okc_api.set_message (p_app_name => g_app_name,
4234: p_msg_name => 'OKC_I_INVALID_VALUE',
4235: p_token1 => 'FIELD',
4236: p_token1_value => 'REQUESTER_ID'
4237: );
4239: END IF;
4240:
4241: IF p_deliverable_rec.deliverable_name IS NULL
4242: THEN
4243: okc_api.set_message (p_app_name => g_app_name,
4244: p_msg_name => 'OKC_I_NOT_NULL',
4245: p_token1 => 'FIELD',
4246: p_token1_value => 'DELIVERABLE_NAME'
4247: );
4263: AND p_deliverable_rec.external_party_role IS NOT NULL
4264: AND okc_deliverable_process_pvt.get_party_name(p_deliverable_rec.external_party_id,p_deliverable_rec.external_party_role) IS NULL
4265: THEN
4266:
4267: okc_api.set_message (p_app_name => g_app_name,
4268: p_msg_name => 'OKC_I_INVALID_VALUE',
4269: p_token1 => 'FIELD',
4270: p_token1_value => 'EXTERNAL_PARTY_ID'
4271: );
4281: UNION
4282: SELECT 'NOTIFY_ESCALATION_UOM' col_name FROM dual WHERE p_deliverable_rec.NOTIFY_ESCALATION_UOM IS NULL
4283: UNION
4284: SELECT 'ESCALATION_ASSIGNEE' col_name FROM dual WHERE p_deliverable_rec.ESCALATION_ASSIGNEE IS NULL);
4285: okc_api.set_message (p_app_name => g_app_name,
4286: p_msg_name => 'OKC_I_NOT_NULL',
4287: p_token1 => 'FIELD',
4288: p_token1_value => l_column_name
4289: );
4302: (SELECT 'NOTIFY_PRIOR_DUE_DATE_UOM' col_name FROM dual WHERE p_deliverable_rec.NOTIFY_PRIOR_DUE_DATE_UOM IS NULL
4303: UNION
4304: SELECT 'NOTIFY_PRIOR_DUE_DATE_VALUE' col_name FROM dual WHERE p_deliverable_rec.NOTIFY_PRIOR_DUE_DATE_VALUE IS NULL
4305: );
4306: okc_api.set_message (p_app_name => g_app_name,
4307: p_msg_name => 'OKC_I_NOT_NULL',
4308: p_token1 => 'FIELD',
4309: p_token1_value => l_column_name
4310: );
4320: IF p_deliverable_rec.escalation_assignee IS NOT NULL
4321: THEN
4322: IF isvalidcontact (p_deliverable_rec.escalation_assignee) <> 'Y'
4323: THEN
4324: okc_api.set_message (p_app_name => g_app_name,
4325: p_msg_name => 'OKC_I_INVALID_VALUE',
4326: p_token1 => 'FIELD',
4327: p_token1_value => 'ESCALATION_ASSIGNEE'
4328: );
4336: IF p_deliverable_rec.notify_prior_due_date_uom IS NOT NULL
4337: AND p_deliverable_rec.notify_prior_due_date_uom NOT IN
4338: ('MTH', 'DAY', 'WK')
4339: THEN
4340: okc_api.set_message
4341: (p_app_name => g_app_name,
4342: p_msg_name => 'OKC_I_INVALID_VALUE',
4343: p_token1 => 'FIELD',
4344: p_token1_value => 'NOTIFY_PRIOR_DUE_DATE_UOM'
4348: IF p_deliverable_rec.notify_escalation_uom IS NOT NULL
4349: AND p_deliverable_rec.notify_escalation_uom NOT IN
4350: ('MTH', 'DAY', 'WK')
4351: THEN
4352: okc_api.set_message (p_app_name => g_app_name,
4353: p_msg_name => 'OKC_I_INVALID_VALUE',
4354: p_token1 => 'FIELD',
4355: p_token1_value => 'NOTIFY_ESCALATION_UOM'
4356: );
4359: IF p_deliverable_rec.relative_st_date_uom IS NOT NULL
4360: AND p_deliverable_rec.relative_st_date_uom NOT IN
4361: ('MTH', 'DAY', 'WK')
4362: THEN
4363: okc_api.set_message (p_app_name => g_app_name,
4364: p_msg_name => 'OKC_I_INVALID_VALUE',
4365: p_token1 => 'FIELD',
4366: p_token1_value => 'RELATIVE_ST_DATE_UOM'
4367: );
4370: IF p_deliverable_rec.relative_end_date_uom IS NOT NULL
4371: AND p_deliverable_rec.relative_end_date_uom NOT IN
4372: ('MTH', 'DAY', 'WK')
4373: THEN
4374: okc_api.set_message (p_app_name => g_app_name,
4375: p_msg_name => 'OKC_I_INVALID_VALUE',
4376: p_token1 => 'FIELD',
4377: p_token1_value => 'RELATIVE_END_DATE_UOM'
4378: );
4382: AND isvalidlookup ('OKC_DEL_REPEAT_FREQ',
4383: p_deliverable_rec.repeating_frequency_uom
4384: ) <> 'Y'
4385: THEN
4386: okc_api.set_message (p_app_name => g_app_name,
4387: p_msg_name => 'OKC_I_INVALID_VALUE',
4388: p_token1 => 'FIELD',
4389: p_token1_value => 'REPEATING_FREQUENCY_UOM'
4390: );
4393: IF p_deliverable_rec.pay_hold_prior_due_date_uom IS NOT NULL
4394: AND p_deliverable_rec.pay_hold_prior_due_date_uom NOT IN
4395: ('MTH', 'DAY', 'WK')
4396: THEN
4397: okc_api.set_message
4398: (p_app_name => g_app_name,
4399: p_msg_name => 'OKC_I_INVALID_VALUE',
4400: p_token1 => 'FIELD',
4401: p_token1_value => 'PAY_HOLD_PRIOR_DUE_DATE_UOM'
4408: p_deliverable_rec.PRINT_DUE_DATE_MSG_NAME := NULL;
4409:
4410: -- Fixed start date is required for this kind of deliverable.
4411: IF p_deliverable_rec.fixed_start_date IS NULL THEN
4412: okc_api.set_message
4413: (p_app_name => g_app_name,
4414: p_msg_name => 'OKC_I_NOT_NULL',
4415: p_token1 => 'FIELD',
4416: p_token1_value => 'FIXED_START_DATE'
4472: FROM DUAL
4473: WHERE p_deliverable_rec.fixed_end_date IS NOT NULL)
4474: WHERE ROWNUM = 1;
4475:
4476: okc_api.set_message
4477: (p_app_name => g_app_name,
4478: p_msg_name => 'OKC_I_INVALID_VALUE',
4479: p_token1 => 'FIELD',
4480: p_token1_value => l_column_name
4479: p_token1 => 'FIELD',
4480: p_token1_value => l_column_name
4481: );
4482:
4483: okc_api.set_message
4484: (p_app_name => g_app_name,
4485: p_msg_name => 'OKC_DEL_INCONSISTENT_DUE_DATES'
4486: );
4487:
4502: AND p_deliverable_rec.RECURRING_YN = 'N'
4503: THEN
4504: IF p_deliverable_rec.relative_st_date_event_id IS NULL
4505: THEN
4506: okc_api.set_message
4507: (p_app_name => g_app_name,
4508: p_msg_name => 'OKC_I_NOT_NULL',
4509: p_token1 => 'FIELD',
4510: p_token1_value => 'RELATIVE_ST_DATE_EVENT_ID'
4513: END IF;
4514:
4515: IF p_deliverable_rec.relative_st_date_duration IS NULL
4516: THEN
4517: okc_api.set_message
4518: (p_app_name => g_app_name,
4519: p_msg_name => 'OKC_I_NOT_NULL',
4520: p_token1 => 'FIELD',
4521: p_token1_value => 'RELATIVE_ST_DATE_DURATION'
4524: END IF;
4525:
4526: IF p_deliverable_rec.relative_st_date_uom IS NULL
4527: THEN
4528: okc_api.set_message (p_app_name => g_app_name,
4529: p_msg_name => 'OKC_I_NOT_NULL',
4530: p_token1 => 'FIELD',
4531: p_token1_value => 'RELATIVE_ST_DATE_UOM'
4532: );
4540: p_deliverable_type => p_deliverable_rec.deliverable_type,
4541: p_bus_doc_event_id => p_deliverable_rec.relative_st_date_event_id
4542: ) <> 'Y'
4543: THEN
4544: okc_api.set_message
4545: (p_app_name => g_app_name,
4546: p_msg_name => 'OKC_I_INVALID_VALUE',
4547: p_token1 => 'FIELD',
4548: p_token1_value => 'RELATIVE_ST_DATE_EVENT_ID'
4590: FROM DUAL
4591: WHERE p_deliverable_rec.fixed_start_date IS NOT NULL)
4592: WHERE ROWNUM = 1;
4593:
4594: okc_api.set_message
4595: (p_app_name => g_app_name,
4596: p_msg_name => 'OKC_DEL_INCONSISTENT_DUE_DATES'
4597: );
4598:
4595: (p_app_name => g_app_name,
4596: p_msg_name => 'OKC_DEL_INCONSISTENT_DUE_DATES'
4597: );
4598:
4599: okc_api.set_message
4600: (p_app_name => g_app_name,
4601: p_msg_name => 'OKC_I_INVALID_VALUE',
4602: p_token1 => 'FIELD',
4603: p_token1_value => l_column_name
4633: select 'REPEATING_DAY_OF_MONTH' column_name from dual where p_deliverable_rec.REPEATING_FREQUENCY_UOM = 'MTH' and p_deliverable_rec.REPEATING_DAY_OF_MONTH is null
4634: )
4635: where rownum =1;
4636:
4637: okc_api.set_message
4638: (p_app_name => g_app_name,
4639: p_msg_name => 'OKC_I_NOT_NULL',
4640: p_token1 => 'FIELD',
4641: p_token1_value => l_column_name
4639: p_msg_name => 'OKC_I_NOT_NULL',
4640: p_token1 => 'FIELD',
4641: p_token1_value => l_column_name
4642: );
4643: okc_api.set_message
4644: (p_app_name => g_app_name,
4645: p_msg_name => 'OKC_DEL_INCONSISTENT_DUE_DATES'
4646: );
4647:
4657: -- Either Fixed end date must exist or End Event info must exist.
4658: IF p_deliverable_rec.fixed_start_date IS NULL
4659: AND p_deliverable_rec.relative_st_date_event_id IS NULL
4660: THEN
4661: okc_api.set_message
4662: (p_app_name => g_app_name,
4663: p_msg_name => 'OKC_DEL_INCONSISTENT_DUE_DATES'
4664: );
4665: okc_api.set_message
4661: okc_api.set_message
4662: (p_app_name => g_app_name,
4663: p_msg_name => 'OKC_DEL_INCONSISTENT_DUE_DATES'
4664: );
4665: okc_api.set_message
4666: (p_app_name => g_app_name,
4667: p_msg_name => 'OKC_I_NOT_NULL',
4668: p_token1 => 'FIELD',
4669: p_token1_value => 'FIXED_START_DATE'
4673:
4674: IF p_deliverable_rec.fixed_end_date IS NULL
4675: AND p_deliverable_rec.relative_end_date_event_id IS NULL
4676: THEN
4677: okc_api.set_message
4678: (p_app_name => g_app_name,
4679: p_msg_name => 'OKC_DEL_INCONSISTENT_DUE_DATES'
4680: );
4681: okc_api.set_message
4677: okc_api.set_message
4678: (p_app_name => g_app_name,
4679: p_msg_name => 'OKC_DEL_INCONSISTENT_DUE_DATES'
4680: );
4681: okc_api.set_message
4682: (p_app_name => g_app_name,
4683: p_msg_name => 'OKC_I_NOT_NULL',
4684: p_token1 => 'FIELD',
4685: p_token1_value => 'FIXED_END_DATE'
4701: where rownum =1;
4702:
4703:
4704:
4705: okc_api.set_message
4706: (p_app_name => g_app_name,
4707: p_msg_name => 'OKC_DEL_INCONSISTENT_DUE_DATES'
4708: );
4709:
4706: (p_app_name => g_app_name,
4707: p_msg_name => 'OKC_DEL_INCONSISTENT_DUE_DATES'
4708: );
4709:
4710: okc_api.set_message
4711: (p_app_name => g_app_name,
4712: p_msg_name => 'OKC_I_INVALID_VALUE',
4713: p_token1 => 'FIELD',
4714: p_token1_value => l_column_name
4733: where rownum =1;
4734:
4735:
4736:
4737: okc_api.set_message
4738: (p_app_name => g_app_name,
4739: p_msg_name => 'OKC_DEL_INCONSISTENT_DUE_DATES'
4740: );
4741:
4738: (p_app_name => g_app_name,
4739: p_msg_name => 'OKC_DEL_INCONSISTENT_DUE_DATES'
4740: );
4741:
4742: okc_api.set_message
4743: (p_app_name => g_app_name,
4744: p_msg_name => 'OKC_I_NOT_NULL',
4745: p_token1 => 'FIELD',
4746: p_token1_value => l_column_name
4768: where rownum =1;
4769:
4770:
4771:
4772: okc_api.set_message
4773: (p_app_name => g_app_name,
4774: p_msg_name => 'OKC_DEL_INCONSISTENT_DUE_DATES'
4775: );
4776:
4773: (p_app_name => g_app_name,
4774: p_msg_name => 'OKC_DEL_INCONSISTENT_DUE_DATES'
4775: );
4776:
4777: okc_api.set_message
4778: (p_app_name => g_app_name,
4779: p_msg_name => 'OKC_I_INVALID_VALUE',
4780: p_token1 => 'FIELD',
4781: p_token1_value => l_column_name
4800: where rownum =1;
4801:
4802:
4803:
4804: okc_api.set_message
4805: (p_app_name => g_app_name,
4806: p_msg_name => 'OKC_DEL_INCONSISTENT_DUE_DATES'
4807: );
4808:
4805: (p_app_name => g_app_name,
4806: p_msg_name => 'OKC_DEL_INCONSISTENT_DUE_DATES'
4807: );
4808:
4809: okc_api.set_message
4810: (p_app_name => g_app_name,
4811: p_msg_name => 'OKC_I_NOT_NULL',
4812: p_token1 => 'FIELD',
4813: p_token1_value => l_column_name
4831: )
4832: )
4833: THEN
4834: --Acq Plan Message Cleanup
4835: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NEG_REL_ST_DUR_UI',p_deliverable_rec.business_document_type);
4836: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4837:
4838: okc_api.set_message (p_app_name => g_app_name,
4839: p_msg_name => l_resolved_msg_name,
4832: )
4833: THEN
4834: --Acq Plan Message Cleanup
4835: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NEG_REL_ST_DUR_UI',p_deliverable_rec.business_document_type);
4836: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4837:
4838: okc_api.set_message (p_app_name => g_app_name,
4839: p_msg_name => l_resolved_msg_name,
4840: p_token1 => 'DEL_TOKEN',
4834: --Acq Plan Message Cleanup
4835: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NEG_REL_ST_DUR_UI',p_deliverable_rec.business_document_type);
4836: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4837:
4838: okc_api.set_message (p_app_name => g_app_name,
4839: p_msg_name => l_resolved_msg_name,
4840: p_token1 => 'DEL_TOKEN',
4841: p_token1_value => l_resolved_token
4842: );
4852: p_deliverable_type => p_deliverable_rec.deliverable_type,
4853: p_bus_doc_event_id => p_deliverable_rec.relative_st_date_event_id
4854: ) <> 'Y'
4855: THEN
4856: okc_api.set_message
4857: (p_app_name => g_app_name,
4858: p_msg_name => 'OKC_I_INVALID_VALUE',
4859: p_token1 => 'FIELD',
4860: p_token1_value => 'RELATIVE_ST_DATE_EVENT_ID'
4870: p_deliverable_type => p_deliverable_rec.deliverable_type,
4871: p_bus_doc_event_id => p_deliverable_rec.relative_end_date_event_id
4872: ) <> 'Y'
4873: THEN
4874: okc_api.set_message
4875: (p_app_name => g_app_name,
4876: p_msg_name => 'OKC_I_INVALID_VALUE',
4877: p_token1 => 'FIELD',
4878: p_token1_value => 'RELATIVE_END_DATE_EVENT_ID'
4887: (p_deliverable_rec.relative_st_date_event_id,
4888: p_deliverable_rec.relative_end_date_event_id
4889: ) <> 'Y'
4890: THEN
4891: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_INVLD_EVENT_DOCTYPE_UI',p_deliverable_rec.business_document_type);
4892: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4893: /* okc_api.set_message
4894: (p_app_name => g_app_name,
4895: p_msg_name => 'OKC_DEL_INVLD_EVENT_DOCTYPE_UI'
4888: p_deliverable_rec.relative_end_date_event_id
4889: ) <> 'Y'
4890: THEN
4891: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_INVLD_EVENT_DOCTYPE_UI',p_deliverable_rec.business_document_type);
4892: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4893: /* okc_api.set_message
4894: (p_app_name => g_app_name,
4895: p_msg_name => 'OKC_DEL_INVLD_EVENT_DOCTYPE_UI'
4896: );*/
4889: ) <> 'Y'
4890: THEN
4891: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_INVLD_EVENT_DOCTYPE_UI',p_deliverable_rec.business_document_type);
4892: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4893: /* okc_api.set_message
4894: (p_app_name => g_app_name,
4895: p_msg_name => 'OKC_DEL_INVLD_EVENT_DOCTYPE_UI'
4896: );*/
4897: okc_api.set_message (p_app_name => g_app_name,
4893: /* okc_api.set_message
4894: (p_app_name => g_app_name,
4895: p_msg_name => 'OKC_DEL_INVLD_EVENT_DOCTYPE_UI'
4896: );*/
4897: okc_api.set_message (p_app_name => g_app_name,
4898: p_msg_name => l_resolved_msg_name,
4899: p_token1 => 'DEL_TOKEN',
4900: p_token1_value => l_resolved_token
4901: );
4908: (p_deliverable_rec.fixed_start_date >
4909: p_deliverable_rec.fixed_end_date))
4910: THEN
4911: --Acq Plan Message Cleanup
4912: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_END_BEFORE_START_UI',p_deliverable_rec.business_document_type);
4913:
4914: /* okc_api.set_message
4915: (p_app_name => g_app_name,
4916: p_msg_name => 'OKC_I_INVALID_VALUE',
4910: THEN
4911: --Acq Plan Message Cleanup
4912: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_END_BEFORE_START_UI',p_deliverable_rec.business_document_type);
4913:
4914: /* okc_api.set_message
4915: (p_app_name => g_app_name,
4916: p_msg_name => 'OKC_I_INVALID_VALUE',
4917: p_token1 => 'FIELD',
4918: p_token1_value => 'OKC_DEL_END_BEFORE_START_UI'
4916: p_msg_name => 'OKC_I_INVALID_VALUE',
4917: p_token1 => 'FIELD',
4918: p_token1_value => 'OKC_DEL_END_BEFORE_START_UI'
4919: );*/
4920: okc_api.set_message
4921: (p_app_name => g_app_name,
4922: p_msg_name => l_resolved_msg_name
4923: );
4924:
4928: IF ( p_deliverable_rec.repeating_duration < 0
4929: OR (InStr(To_Char(p_deliverable_rec.repeating_duration),'.')<>0)
4930: )
4931: THEN
4932: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NEG_REPEAT_WEEK_UI',p_deliverable_rec.business_document_type);
4933: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4934:
4935: okc_api.set_message (p_app_name => g_app_name,
4936: p_msg_name => l_resolved_msg_name,
4929: OR (InStr(To_Char(p_deliverable_rec.repeating_duration),'.')<>0)
4930: )
4931: THEN
4932: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NEG_REPEAT_WEEK_UI',p_deliverable_rec.business_document_type);
4933: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4934:
4935: okc_api.set_message (p_app_name => g_app_name,
4936: p_msg_name => l_resolved_msg_name,
4937: p_token1 => 'DEL_TOKEN',
4931: THEN
4932: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NEG_REPEAT_WEEK_UI',p_deliverable_rec.business_document_type);
4933: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4934:
4935: okc_api.set_message (p_app_name => g_app_name,
4936: p_msg_name => l_resolved_msg_name,
4937: p_token1 => 'DEL_TOKEN',
4938: p_token1_value => l_resolved_token
4939: );
4952: (p_deliverable_rec.repeating_day_of_week
4953: )
4954: ) <> 'Y'
4955: THEN
4956: okc_api.set_message
4957: (p_app_name => g_app_name,
4958: p_msg_name => 'OKC_DEL_INVALID_DAY_OF_WEEK'
4959: );
4960: RAISE fnd_api.g_exc_error;
4970: (p_deliverable_rec.repeating_day_of_month
4971: )
4972: ) <> 'Y'
4973: THEN
4974: okc_api.set_message
4975: (p_app_name => g_app_name,
4976: p_msg_name => 'OKC_DEL_INVALID_DAY_OF_MONTH'
4977: );
4978: RAISE fnd_api.g_exc_error;
5079: AND (l_startduration < l_endduration)
5080: )
5081: THEN
5082: --Acq Plan Message Cleanup
5083: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_END_BEFORE_START_UI',p_deliverable_rec.business_document_type);
5084: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
5085:
5086: /* okc_api.set_message
5087: (p_app_name => g_app_name,
5080: )
5081: THEN
5082: --Acq Plan Message Cleanup
5083: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_END_BEFORE_START_UI',p_deliverable_rec.business_document_type);
5084: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
5085:
5086: /* okc_api.set_message
5087: (p_app_name => g_app_name,
5088: p_msg_name => 'OKC_DEL_END_BEFORE_START_UI'
5082: --Acq Plan Message Cleanup
5083: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_END_BEFORE_START_UI',p_deliverable_rec.business_document_type);
5084: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
5085:
5086: /* okc_api.set_message
5087: (p_app_name => g_app_name,
5088: p_msg_name => 'OKC_DEL_END_BEFORE_START_UI'
5089: );*/
5090: okc_api.set_message
5086: /* okc_api.set_message
5087: (p_app_name => g_app_name,
5088: p_msg_name => 'OKC_DEL_END_BEFORE_START_UI'
5089: );*/
5090: okc_api.set_message
5091: (p_app_name => g_app_name,
5092: p_msg_name => l_resolved_msg_name,
5093: p_token1 => 'DEL_TOKEN',
5094: p_token1_value => l_resolved_token
5102: -- Scenario 3
5103: IF ('A' = l_startba AND 'B' = l_endba)
5104: THEN
5105: --Acq Plan Message Cleanup
5106: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_END_BEFORE_START_UI',p_deliverable_rec.business_document_type);
5107: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
5108:
5109: /* okc_api.set_message
5110: (p_app_name => g_app_name,
5103: IF ('A' = l_startba AND 'B' = l_endba)
5104: THEN
5105: --Acq Plan Message Cleanup
5106: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_END_BEFORE_START_UI',p_deliverable_rec.business_document_type);
5107: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
5108:
5109: /* okc_api.set_message
5110: (p_app_name => g_app_name,
5111: p_msg_name => 'OKC_DEL_END_BEFORE_START_UI'
5105: --Acq Plan Message Cleanup
5106: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_END_BEFORE_START_UI',p_deliverable_rec.business_document_type);
5107: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
5108:
5109: /* okc_api.set_message
5110: (p_app_name => g_app_name,
5111: p_msg_name => 'OKC_DEL_END_BEFORE_START_UI'
5112: );*/
5113: okc_api.set_message
5109: /* okc_api.set_message
5110: (p_app_name => g_app_name,
5111: p_msg_name => 'OKC_DEL_END_BEFORE_START_UI'
5112: );*/
5113: okc_api.set_message
5114: (p_app_name => g_app_name,
5115: p_msg_name => l_resolved_msg_name,
5116: p_token1 => 'DEL_TOKEN',
5117: p_token1_value => l_resolved_token
5126: AND l_startduration > l_endduration
5127: )
5128: THEN
5129: --Acq Plan Message Cleanup
5130: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_END_BEFORE_START_UI',p_deliverable_rec.business_document_type);
5131: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
5132:
5133: /* okc_api.set_message
5134: (p_app_name => g_app_name,
5127: )
5128: THEN
5129: --Acq Plan Message Cleanup
5130: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_END_BEFORE_START_UI',p_deliverable_rec.business_document_type);
5131: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
5132:
5133: /* okc_api.set_message
5134: (p_app_name => g_app_name,
5135: p_msg_name => 'OKC_DEL_END_BEFORE_START_UI'
5129: --Acq Plan Message Cleanup
5130: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_END_BEFORE_START_UI',p_deliverable_rec.business_document_type);
5131: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
5132:
5133: /* okc_api.set_message
5134: (p_app_name => g_app_name,
5135: p_msg_name => 'OKC_DEL_END_BEFORE_START_UI'
5136: );*/
5137: okc_api.set_message
5133: /* okc_api.set_message
5134: (p_app_name => g_app_name,
5135: p_msg_name => 'OKC_DEL_END_BEFORE_START_UI'
5136: );*/
5137: okc_api.set_message
5138: (p_app_name => g_app_name,
5139: p_msg_name => l_resolved_msg_name,
5140: p_token1 => 'DEL_TOKEN',
5141: p_token1_value => l_resolved_token
5201: p_deliverable_rec IN OUT NOCOPY deliverable_rec_type
5202: )
5203: IS
5204: BEGIN
5205: IF p_deliverable_rec.deliverable_id = okc_api.g_miss_num
5206: THEN
5207: SELECT okc_deliverable_id_s.NEXTVAL
5208: INTO p_deliverable_rec.deliverable_id
5209: FROM DUAL;
5208: INTO p_deliverable_rec.deliverable_id
5209: FROM DUAL;
5210: END IF;
5211:
5212: IF p_deliverable_rec.business_document_type = okc_api.g_miss_char
5213: THEN
5214: p_deliverable_rec.business_document_type := 'TEMPLATE';
5215: END IF;
5216:
5213: THEN
5214: p_deliverable_rec.business_document_type := 'TEMPLATE';
5215: END IF;
5216:
5217: IF p_deliverable_rec.business_document_id = okc_api.g_miss_num
5218: THEN
5219: p_deliverable_rec.business_document_id := NULL;
5220: END IF;
5221:
5218: THEN
5219: p_deliverable_rec.business_document_id := NULL;
5220: END IF;
5221:
5222: IF p_deliverable_rec.business_document_number = okc_api.g_miss_char
5223: THEN
5224: p_deliverable_rec.business_document_number := NULL;
5225: END IF;
5226:
5223: THEN
5224: p_deliverable_rec.business_document_number := NULL;
5225: END IF;
5226:
5227: IF p_deliverable_rec.deliverable_type = okc_api.g_miss_char
5228: THEN
5229: p_deliverable_rec.deliverable_type := NULL;
5230: END IF;
5231:
5228: THEN
5229: p_deliverable_rec.deliverable_type := NULL;
5230: END IF;
5231:
5232: IF p_deliverable_rec.responsible_party = okc_api.g_miss_char
5233: THEN
5234: p_deliverable_rec.responsible_party := NULL;
5235: END IF;
5236:
5238: IF p_deliverable_rec.responsible_party = 'BUYER_ORG' THEN
5239: p_deliverable_rec.responsible_party := 'INTERNAL_ORG';
5240: END IF;
5241:
5242: IF p_deliverable_rec.internal_party_contact_id = okc_api.g_miss_num
5243: THEN
5244: p_deliverable_rec.internal_party_contact_id := NULL;
5245: END IF;
5246:
5243: THEN
5244: p_deliverable_rec.internal_party_contact_id := NULL;
5245: END IF;
5246:
5247: IF p_deliverable_rec.external_party_contact_id = okc_api.g_miss_num
5248: THEN
5249: p_deliverable_rec.external_party_contact_id := NULL;
5250: END IF;
5251:
5248: THEN
5249: p_deliverable_rec.external_party_contact_id := NULL;
5250: END IF;
5251:
5252: IF p_deliverable_rec.deliverable_name = okc_api.g_miss_char
5253: THEN
5254: p_deliverable_rec.deliverable_name := NULL;
5255: END IF;
5256:
5253: THEN
5254: p_deliverable_rec.deliverable_name := NULL;
5255: END IF;
5256:
5257: IF p_deliverable_rec.description = okc_api.g_miss_char
5258: THEN
5259: p_deliverable_rec.description := NULL;
5260: END IF;
5261:
5258: THEN
5259: p_deliverable_rec.description := NULL;
5260: END IF;
5261:
5262: IF p_deliverable_rec.comments = okc_api.g_miss_char
5263: THEN
5264: p_deliverable_rec.comments := NULL;
5265: END IF;
5266:
5263: THEN
5264: p_deliverable_rec.comments := NULL;
5265: END IF;
5266:
5267: IF p_deliverable_rec.display_sequence = okc_api.g_miss_num
5268: THEN
5269: p_deliverable_rec.display_sequence :=
5270: getdeldisplaysequence (p_deliverable_rec.deliverable_id);
5271: END IF;
5269: p_deliverable_rec.display_sequence :=
5270: getdeldisplaysequence (p_deliverable_rec.deliverable_id);
5271: END IF;
5272:
5273: IF p_deliverable_rec.fixed_due_date_yn = okc_api.g_miss_char
5274: THEN
5275: p_deliverable_rec.fixed_due_date_yn := 'Y';
5276: END IF;
5277:
5274: THEN
5275: p_deliverable_rec.fixed_due_date_yn := 'Y';
5276: END IF;
5277:
5278: IF p_deliverable_rec.actual_due_date = okc_api.g_miss_date
5279: THEN
5280: p_deliverable_rec.actual_due_date := NULL;
5281: END IF;
5282:
5279: THEN
5280: p_deliverable_rec.actual_due_date := NULL;
5281: END IF;
5282:
5283: IF p_deliverable_rec.print_due_date_msg_name = okc_api.g_miss_char
5284: THEN
5285: p_deliverable_rec.print_due_date_msg_name := NULL;
5286: END IF;
5287:
5284: THEN
5285: p_deliverable_rec.print_due_date_msg_name := NULL;
5286: END IF;
5287:
5288: IF p_deliverable_rec.recurring_yn = okc_api.g_miss_char
5289: THEN
5290: p_deliverable_rec.recurring_yn := 'N';
5291: END IF;
5292:
5289: THEN
5290: p_deliverable_rec.recurring_yn := 'N';
5291: END IF;
5292:
5293: IF p_deliverable_rec.notify_prior_due_date_value = okc_api.g_miss_num
5294: THEN
5295: p_deliverable_rec.notify_prior_due_date_value := NULL;
5296: END IF;
5297:
5294: THEN
5295: p_deliverable_rec.notify_prior_due_date_value := NULL;
5296: END IF;
5297:
5298: IF p_deliverable_rec.notify_prior_due_date_uom = okc_api.g_miss_char
5299: THEN
5300: p_deliverable_rec.notify_prior_due_date_uom := NULL;
5301: END IF;
5302:
5299: THEN
5300: p_deliverable_rec.notify_prior_due_date_uom := NULL;
5301: END IF;
5302:
5303: IF p_deliverable_rec.notify_prior_due_date_yn = okc_api.g_miss_char
5304: THEN
5305: p_deliverable_rec.notify_prior_due_date_yn := 'N';
5306: END IF;
5307:
5304: THEN
5305: p_deliverable_rec.notify_prior_due_date_yn := 'N';
5306: END IF;
5307:
5308: IF p_deliverable_rec.notify_completed_yn = okc_api.g_miss_char
5309: THEN
5310: p_deliverable_rec.notify_completed_yn := 'N';
5311: END IF;
5312:
5309: THEN
5310: p_deliverable_rec.notify_completed_yn := 'N';
5311: END IF;
5312:
5313: IF p_deliverable_rec.notify_overdue_yn = okc_api.g_miss_char
5314: THEN
5315: p_deliverable_rec.notify_overdue_yn := 'N';
5316: END IF;
5317:
5314: THEN
5315: p_deliverable_rec.notify_overdue_yn := 'N';
5316: END IF;
5317:
5318: IF p_deliverable_rec.notify_escalation_yn = okc_api.g_miss_char
5319: THEN
5320: p_deliverable_rec.notify_escalation_yn := 'N';
5321: END IF;
5322:
5319: THEN
5320: p_deliverable_rec.notify_escalation_yn := 'N';
5321: END IF;
5322:
5323: IF p_deliverable_rec.notify_escalation_value = okc_api.g_miss_num
5324: THEN
5325: p_deliverable_rec.notify_escalation_value := NULL;
5326: END IF;
5327:
5324: THEN
5325: p_deliverable_rec.notify_escalation_value := NULL;
5326: END IF;
5327:
5328: IF p_deliverable_rec.notify_escalation_uom = okc_api.g_miss_char
5329: THEN
5330: p_deliverable_rec.notify_escalation_uom := NULL;
5331: END IF;
5332:
5329: THEN
5330: p_deliverable_rec.notify_escalation_uom := NULL;
5331: END IF;
5332:
5333: IF p_deliverable_rec.escalation_assignee = okc_api.g_miss_num
5334: THEN
5335: p_deliverable_rec.escalation_assignee := NULL;
5336: END IF;
5337:
5334: THEN
5335: p_deliverable_rec.escalation_assignee := NULL;
5336: END IF;
5337:
5338: IF p_deliverable_rec.amendment_operation = okc_api.g_miss_char
5339: THEN
5340: p_deliverable_rec.amendment_operation := NULL;
5341: END IF;
5342:
5339: THEN
5340: p_deliverable_rec.amendment_operation := NULL;
5341: END IF;
5342:
5343: IF p_deliverable_rec.prior_notification_id = okc_api.g_miss_num
5344: THEN
5345: p_deliverable_rec.prior_notification_id := NULL;
5346: END IF;
5347:
5344: THEN
5345: p_deliverable_rec.prior_notification_id := NULL;
5346: END IF;
5347:
5348: IF p_deliverable_rec.amendment_notes = okc_api.g_miss_char
5349: THEN
5350: p_deliverable_rec.amendment_notes := NULL;
5351: END IF;
5352:
5349: THEN
5350: p_deliverable_rec.amendment_notes := NULL;
5351: END IF;
5352:
5353: IF p_deliverable_rec.completed_notification_id = okc_api.g_miss_num
5354: THEN
5355: p_deliverable_rec.completed_notification_id := NULL;
5356: END IF;
5357:
5354: THEN
5355: p_deliverable_rec.completed_notification_id := NULL;
5356: END IF;
5357:
5358: IF p_deliverable_rec.overdue_notification_id = okc_api.g_miss_num
5359: THEN
5360: p_deliverable_rec.overdue_notification_id := NULL;
5361: END IF;
5362:
5359: THEN
5360: p_deliverable_rec.overdue_notification_id := NULL;
5361: END IF;
5362:
5363: IF p_deliverable_rec.escalation_notification_id = okc_api.g_miss_num
5364: THEN
5365: p_deliverable_rec.escalation_notification_id := NULL;
5366: END IF;
5367:
5364: THEN
5365: p_deliverable_rec.escalation_notification_id := NULL;
5366: END IF;
5367:
5368: IF p_deliverable_rec.LANGUAGE = okc_api.g_miss_char
5369: THEN
5370: p_deliverable_rec.LANGUAGE := USERENV ('Lang');
5371: END IF;
5372:
5369: THEN
5370: p_deliverable_rec.LANGUAGE := USERENV ('Lang');
5371: END IF;
5372:
5373: IF p_deliverable_rec.original_deliverable_id = okc_api.g_miss_num
5374: THEN
5375: p_deliverable_rec.original_deliverable_id :=
5376: p_deliverable_rec.deliverable_id;
5377: END IF;
5375: p_deliverable_rec.original_deliverable_id :=
5376: p_deliverable_rec.deliverable_id;
5377: END IF;
5378:
5379: IF p_deliverable_rec.requester_id = okc_api.g_miss_num
5380: THEN
5381: p_deliverable_rec.requester_id := NULL;
5382: END IF;
5383:
5380: THEN
5381: p_deliverable_rec.requester_id := NULL;
5382: END IF;
5383:
5384: IF p_deliverable_rec.external_party_id = okc_api.g_miss_num
5385: THEN
5386: p_deliverable_rec.external_party_id := NULL;
5387: END IF;
5388:
5385: THEN
5386: p_deliverable_rec.external_party_id := NULL;
5387: END IF;
5388:
5389: IF p_deliverable_rec.recurring_del_parent_id = okc_api.g_miss_num
5390: THEN
5391: p_deliverable_rec.recurring_del_parent_id := NULL;
5392: END IF;
5393:
5390: THEN
5391: p_deliverable_rec.recurring_del_parent_id := NULL;
5392: END IF;
5393:
5394: --IF p_deliverable_rec.business_document_version = okc_api.g_miss_num
5395: --THEN
5396: p_deliverable_rec.business_document_version := -99;
5397: --END IF;
5398:
5395: --THEN
5396: p_deliverable_rec.business_document_version := -99;
5397: --END IF;
5398:
5399: IF p_deliverable_rec.relative_st_date_duration = okc_api.g_miss_num
5400: THEN
5401: p_deliverable_rec.relative_st_date_duration := NULL;
5402: END IF;
5403:
5400: THEN
5401: p_deliverable_rec.relative_st_date_duration := NULL;
5402: END IF;
5403:
5404: IF p_deliverable_rec.relative_st_date_uom = okc_api.g_miss_char
5405: THEN
5406: p_deliverable_rec.relative_st_date_uom := NULL;
5407: END IF;
5408:
5405: THEN
5406: p_deliverable_rec.relative_st_date_uom := NULL;
5407: END IF;
5408:
5409: IF p_deliverable_rec.relative_st_date_event_id = okc_api.g_miss_num
5410: THEN
5411: p_deliverable_rec.relative_st_date_event_id := NULL;
5412: END IF;
5413:
5410: THEN
5411: p_deliverable_rec.relative_st_date_event_id := NULL;
5412: END IF;
5413:
5414: IF p_deliverable_rec.relative_end_date_duration = okc_api.g_miss_num
5415: THEN
5416: p_deliverable_rec.relative_end_date_duration := NULL;
5417: END IF;
5418:
5415: THEN
5416: p_deliverable_rec.relative_end_date_duration := NULL;
5417: END IF;
5418:
5419: IF p_deliverable_rec.relative_end_date_uom = okc_api.g_miss_char
5420: THEN
5421: p_deliverable_rec.relative_end_date_uom := NULL;
5422: END IF;
5423:
5420: THEN
5421: p_deliverable_rec.relative_end_date_uom := NULL;
5422: END IF;
5423:
5424: IF p_deliverable_rec.relative_end_date_event_id = okc_api.g_miss_num
5425: THEN
5426: p_deliverable_rec.relative_end_date_event_id := NULL;
5427: END IF;
5428:
5425: THEN
5426: p_deliverable_rec.relative_end_date_event_id := NULL;
5427: END IF;
5428:
5429: IF p_deliverable_rec.repeating_day_of_month = okc_api.g_miss_char
5430: THEN
5431: p_deliverable_rec.repeating_day_of_month := NULL;
5432: END IF;
5433:
5430: THEN
5431: p_deliverable_rec.repeating_day_of_month := NULL;
5432: END IF;
5433:
5434: IF p_deliverable_rec.repeating_day_of_week = okc_api.g_miss_char
5435: THEN
5436: p_deliverable_rec.repeating_day_of_week := NULL;
5437: END IF;
5438:
5435: THEN
5436: p_deliverable_rec.repeating_day_of_week := NULL;
5437: END IF;
5438:
5439: IF p_deliverable_rec.repeating_frequency_uom = okc_api.g_miss_char
5440: THEN
5441: p_deliverable_rec.repeating_frequency_uom := NULL;
5442: END IF;
5443:
5440: THEN
5441: p_deliverable_rec.repeating_frequency_uom := NULL;
5442: END IF;
5443:
5444: IF p_deliverable_rec.repeating_duration = okc_api.g_miss_num
5445: THEN
5446: p_deliverable_rec.repeating_duration := NULL;
5447: END IF;
5448:
5445: THEN
5446: p_deliverable_rec.repeating_duration := NULL;
5447: END IF;
5448:
5449: IF p_deliverable_rec.fixed_start_date = okc_api.g_miss_date
5450: THEN
5451: p_deliverable_rec.fixed_start_date := NULL;
5452: END IF;
5453:
5450: THEN
5451: p_deliverable_rec.fixed_start_date := NULL;
5452: END IF;
5453:
5454: IF p_deliverable_rec.fixed_end_date = okc_api.g_miss_date
5455: THEN
5456: p_deliverable_rec.fixed_end_date := NULL;
5457: END IF;
5458:
5455: THEN
5456: p_deliverable_rec.fixed_end_date := NULL;
5457: END IF;
5458:
5459: IF p_deliverable_rec.manage_yn = okc_api.g_miss_char
5460: THEN
5461: p_deliverable_rec.manage_yn := 'N';
5462: END IF;
5463:
5460: THEN
5461: p_deliverable_rec.manage_yn := 'N';
5462: END IF;
5463:
5464: IF p_deliverable_rec.internal_party_id = okc_api.g_miss_num
5465: THEN
5466: p_deliverable_rec.internal_party_id := NULL;
5467: END IF;
5468:
5465: THEN
5466: p_deliverable_rec.internal_party_id := NULL;
5467: END IF;
5468:
5469: --IF p_deliverable_rec.deliverable_status = okc_api.g_miss_char
5470: --THEN
5471: p_deliverable_rec.deliverable_status := 'INACTIVE';
5472: --END IF;
5473:
5470: --THEN
5471: p_deliverable_rec.deliverable_status := 'INACTIVE';
5472: --END IF;
5473:
5474: IF p_deliverable_rec.status_change_notes = okc_api.g_miss_char
5475: THEN
5476: p_deliverable_rec.status_change_notes := NULL;
5477: END IF;
5478:
5475: THEN
5476: p_deliverable_rec.status_change_notes := NULL;
5477: END IF;
5478:
5479: --IF p_deliverable_rec.created_by = okc_api.g_miss_num
5480: --THEN
5481: p_deliverable_rec.created_by := fnd_global.user_id;
5482: -- END IF;
5483:
5480: --THEN
5481: p_deliverable_rec.created_by := fnd_global.user_id;
5482: -- END IF;
5483:
5484: --IF p_deliverable_rec.creation_date = okc_api.g_miss_date
5485: --THEN
5486: p_deliverable_rec.creation_date := SYSDATE;
5487: --END IF;
5488:
5485: --THEN
5486: p_deliverable_rec.creation_date := SYSDATE;
5487: --END IF;
5488:
5489: --IF p_deliverable_rec.last_updated_by = okc_api.g_miss_num
5490: --THEN
5491: p_deliverable_rec.last_updated_by := fnd_global.user_id;
5492: --END IF;
5493:
5490: --THEN
5491: p_deliverable_rec.last_updated_by := fnd_global.user_id;
5492: --END IF;
5493:
5494: --IF p_deliverable_rec.last_update_date = okc_api.g_miss_date
5495: --THEN
5496: p_deliverable_rec.last_update_date := SYSDATE;
5497: --END IF;
5498:
5495: --THEN
5496: p_deliverable_rec.last_update_date := SYSDATE;
5497: --END IF;
5498:
5499: --IF p_deliverable_rec.last_update_login = okc_api.g_miss_num
5500: --THEN
5501: p_deliverable_rec.last_update_login := fnd_global.login_id;
5502: --END IF;
5503:
5500: --THEN
5501: p_deliverable_rec.last_update_login := fnd_global.login_id;
5502: --END IF;
5503:
5504: --IF p_deliverable_rec.object_version_number = okc_api.g_miss_num
5505: --THEN
5506: p_deliverable_rec.object_version_number := 1;
5507: --END IF;
5508:
5505: --THEN
5506: p_deliverable_rec.object_version_number := 1;
5507: --END IF;
5508:
5509: IF p_deliverable_rec.attribute_category = okc_api.g_miss_char
5510: THEN
5511: p_deliverable_rec.attribute_category := NULL;
5512: END IF;
5513:
5510: THEN
5511: p_deliverable_rec.attribute_category := NULL;
5512: END IF;
5513:
5514: IF p_deliverable_rec.attribute1 = okc_api.g_miss_char
5515: THEN
5516: p_deliverable_rec.attribute1 := NULL;
5517: END IF;
5518:
5515: THEN
5516: p_deliverable_rec.attribute1 := NULL;
5517: END IF;
5518:
5519: IF p_deliverable_rec.attribute2 = okc_api.g_miss_char
5520: THEN
5521: p_deliverable_rec.attribute2 := NULL;
5522: END IF;
5523:
5520: THEN
5521: p_deliverable_rec.attribute2 := NULL;
5522: END IF;
5523:
5524: IF p_deliverable_rec.attribute3 = okc_api.g_miss_char
5525: THEN
5526: p_deliverable_rec.attribute3 := NULL;
5527: END IF;
5528:
5525: THEN
5526: p_deliverable_rec.attribute3 := NULL;
5527: END IF;
5528:
5529: IF p_deliverable_rec.attribute4 = okc_api.g_miss_char
5530: THEN
5531: p_deliverable_rec.attribute4 := NULL;
5532: END IF;
5533:
5530: THEN
5531: p_deliverable_rec.attribute4 := NULL;
5532: END IF;
5533:
5534: IF p_deliverable_rec.attribute5 = okc_api.g_miss_char
5535: THEN
5536: p_deliverable_rec.attribute5 := NULL;
5537: END IF;
5538:
5535: THEN
5536: p_deliverable_rec.attribute5 := NULL;
5537: END IF;
5538:
5539: IF p_deliverable_rec.attribute6 = okc_api.g_miss_char
5540: THEN
5541: p_deliverable_rec.attribute6 := NULL;
5542: END IF;
5543:
5540: THEN
5541: p_deliverable_rec.attribute6 := NULL;
5542: END IF;
5543:
5544: IF p_deliverable_rec.attribute7 = okc_api.g_miss_char
5545: THEN
5546: p_deliverable_rec.attribute7 := NULL;
5547: END IF;
5548:
5545: THEN
5546: p_deliverable_rec.attribute7 := NULL;
5547: END IF;
5548:
5549: IF p_deliverable_rec.attribute8 = okc_api.g_miss_char
5550: THEN
5551: p_deliverable_rec.attribute8 := NULL;
5552: END IF;
5553:
5550: THEN
5551: p_deliverable_rec.attribute8 := NULL;
5552: END IF;
5553:
5554: IF p_deliverable_rec.attribute9 = okc_api.g_miss_char
5555: THEN
5556: p_deliverable_rec.attribute9 := NULL;
5557: END IF;
5558:
5555: THEN
5556: p_deliverable_rec.attribute9 := NULL;
5557: END IF;
5558:
5559: IF p_deliverable_rec.attribute10 = okc_api.g_miss_char
5560: THEN
5561: p_deliverable_rec.attribute10 := NULL;
5562: END IF;
5563:
5560: THEN
5561: p_deliverable_rec.attribute10 := NULL;
5562: END IF;
5563:
5564: IF p_deliverable_rec.attribute11 = okc_api.g_miss_char
5565: THEN
5566: p_deliverable_rec.attribute11 := NULL;
5567: END IF;
5568:
5565: THEN
5566: p_deliverable_rec.attribute11 := NULL;
5567: END IF;
5568:
5569: IF p_deliverable_rec.attribute12 = okc_api.g_miss_char
5570: THEN
5571: p_deliverable_rec.attribute12 := NULL;
5572: END IF;
5573:
5570: THEN
5571: p_deliverable_rec.attribute12 := NULL;
5572: END IF;
5573:
5574: IF p_deliverable_rec.attribute13 = okc_api.g_miss_char
5575: THEN
5576: p_deliverable_rec.attribute13 := NULL;
5577: END IF;
5578:
5575: THEN
5576: p_deliverable_rec.attribute13 := NULL;
5577: END IF;
5578:
5579: IF p_deliverable_rec.attribute14 = okc_api.g_miss_char
5580: THEN
5581: p_deliverable_rec.attribute14 := NULL;
5582: END IF;
5583:
5580: THEN
5581: p_deliverable_rec.attribute14 := NULL;
5582: END IF;
5583:
5584: IF p_deliverable_rec.attribute15 = okc_api.g_miss_char
5585: THEN
5586: p_deliverable_rec.attribute15 := NULL;
5587: END IF;
5588:
5585: THEN
5586: p_deliverable_rec.attribute15 := NULL;
5587: END IF;
5588:
5589: IF p_deliverable_rec.disable_notifications_yn = okc_api.g_miss_char
5590: THEN
5591: p_deliverable_rec.disable_notifications_yn := 'N';
5592: END IF;
5593:
5590: THEN
5591: p_deliverable_rec.disable_notifications_yn := 'N';
5592: END IF;
5593:
5594: IF p_deliverable_rec.last_amendment_date = okc_api.g_miss_date
5595: THEN
5596: p_deliverable_rec.last_amendment_date := NULL;
5597: END IF;
5598:
5595: THEN
5596: p_deliverable_rec.last_amendment_date := NULL;
5597: END IF;
5598:
5599: IF p_deliverable_rec.business_document_line_id = okc_api.g_miss_num
5600: THEN
5601: p_deliverable_rec.business_document_line_id := NULL;
5602: END IF;
5603:
5600: THEN
5601: p_deliverable_rec.business_document_line_id := NULL;
5602: END IF;
5603:
5604: IF p_deliverable_rec.external_party_site_id = okc_api.g_miss_num
5605: THEN
5606: p_deliverable_rec.external_party_site_id := NULL;
5607: END IF;
5608:
5605: THEN
5606: p_deliverable_rec.external_party_site_id := NULL;
5607: END IF;
5608:
5609: IF p_deliverable_rec.start_event_date = okc_api.g_miss_date
5610: THEN
5611: p_deliverable_rec.start_event_date := NULL;
5612: END IF;
5613:
5610: THEN
5611: p_deliverable_rec.start_event_date := NULL;
5612: END IF;
5613:
5614: IF p_deliverable_rec.end_event_date = okc_api.g_miss_date
5615: THEN
5616: p_deliverable_rec.end_event_date := NULL;
5617: END IF;
5618:
5616: p_deliverable_rec.end_event_date := NULL;
5617: END IF;
5618:
5619: IF p_deliverable_rec.summary_amend_operation_code =
5620: okc_api.g_miss_char
5621: THEN
5622: p_deliverable_rec.summary_amend_operation_code := NULL;
5623: END IF;
5624:
5621: THEN
5622: p_deliverable_rec.summary_amend_operation_code := NULL;
5623: END IF;
5624:
5625: IF p_deliverable_rec.external_party_role = okc_api.g_miss_char
5626: THEN
5627: p_deliverable_rec.external_party_role := NULL;
5628: END IF;
5629:
5626: THEN
5627: p_deliverable_rec.external_party_role := NULL;
5628: END IF;
5629:
5630: IF p_deliverable_rec.pay_hold_prior_due_date_yn = okc_api.g_miss_char
5631: THEN
5632: p_deliverable_rec.pay_hold_prior_due_date_yn := NULL;
5633: END IF;
5634:
5632: p_deliverable_rec.pay_hold_prior_due_date_yn := NULL;
5633: END IF;
5634:
5635: IF p_deliverable_rec.pay_hold_prior_due_date_value =
5636: okc_api.g_miss_num
5637: THEN
5638: p_deliverable_rec.pay_hold_prior_due_date_value := NULL;
5639: END IF;
5640:
5638: p_deliverable_rec.pay_hold_prior_due_date_value := NULL;
5639: END IF;
5640:
5641: IF p_deliverable_rec.pay_hold_prior_due_date_uom =
5642: okc_api.g_miss_char
5643: THEN
5644: p_deliverable_rec.pay_hold_prior_due_date_uom := NULL;
5645: END IF;
5646:
5643: THEN
5644: p_deliverable_rec.pay_hold_prior_due_date_uom := NULL;
5645: END IF;
5646:
5647: IF p_deliverable_rec.pay_hold_overdue_yn = okc_api.g_miss_char
5648: THEN
5649: p_deliverable_rec.pay_hold_overdue_yn := NULL;
5650: END IF;
5651:
5649: p_deliverable_rec.pay_hold_overdue_yn := NULL;
5650: END IF;
5651:
5652: -- serukull changes
5653: IF p_deliverable_rec.orig_system_reference_code = okc_api.g_miss_char
5654: THEN
5655: p_deliverable_rec.orig_system_reference_code := NULL;
5656: END IF;
5657:
5654: THEN
5655: p_deliverable_rec.orig_system_reference_code := NULL;
5656: END IF;
5657:
5658: IF p_deliverable_rec.orig_system_reference_id1 = okc_api.g_miss_num
5659: THEN
5660: p_deliverable_rec.orig_system_reference_id1 := NULL;
5661: END IF;
5662:
5660: p_deliverable_rec.orig_system_reference_id1 := NULL;
5661: END IF;
5662:
5663:
5664: IF p_deliverable_rec.orig_system_reference_id2 = okc_api.g_miss_num
5665: THEN
5666: p_deliverable_rec.orig_system_reference_id2 := NULL;
5667: END IF;
5668:
5665: THEN
5666: p_deliverable_rec.orig_system_reference_id2 := NULL;
5667: END IF;
5668:
5669: IF p_deliverable_rec.raise_completion_event_yn = okc_api.g_miss_char
5670: THEN
5671: p_deliverable_rec.raise_completion_event_yn := NULL;
5672: END IF;
5673:
5720: FETCH C_delTypeExists into C_delTypeExists_rec;
5721:
5722: IF C_delTypeExists%NOTFOUND THEN
5723: --Incorrect Deliverable type for the DOcument
5724: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
5725: p_msg_name => 'OKC_DEL_TYPE_MISMATCH',
5726: p_token1 => 'p_deliverable_type',
5727: p_token1_value => delRecTab.deliverable_type,
5728: p_token2 => 'P_DOCUMENT_TYPE',
5736: /*Other validations for Deliverable*/
5737: validate_deliverables(p_deliverable_rec => delRecTab);
5738:
5739: -- Get the print msg info
5740: IF delRecTab.print_due_date_msg_name IS NULL OR delRecTab.print_due_date_msg_name = OKC_API.G_MISS_CHAR
5741: THEN
5742:
5743: IF delRecTab.relative_st_date_event_id IS NOT NULL
5744: THEN
5816: );
5817:
5818: END IF;
5819:
5820: IF delRecTab.deliverable_id IS NULL OR delRecTab.deliverable_id = OKC_API.g_MISS_NUM THEN
5821: select okc_deliverable_id_s.nextval INTO delRecTab.deliverable_id from dual;
5822: delRecTab.original_deliverable_id := delRecTab.deliverable_id;
5823: END IF;
5824:
6038:
6039: WHEN FND_API.G_EXC_ERROR THEN
6040:
6041: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6042: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving create_deliverables: OKC_API.G_EXCEPTION_ERROR Exception');
6043: END IF;
6044: IF C_delTypeExists%ISOPEN THEN
6045: CLOSE C_delTypeExists;
6046: END IF;
6050: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6051:
6052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6053: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6054: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving create_deliverables: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
6055: END IF;
6056:
6057: IF C_delTypeExists%ISOPEN THEN
6058: CLOSE C_delTypeExists;
6225:
6226: -- Check that Clause info is provided
6227: IF p_clause_version_id is NULL and p_clause_title is NULL THEN
6228: -- no clause is provided
6229: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6230: p_msg_name => 'OKC_TERMS_INV_CLS');
6231: x_return_status := G_RET_STS_ERROR;
6232: RAISE FND_API.G_EXC_ERROR ;
6233: END IF;
6236: OPEN l_cls_id_validate_csr;
6237: FETCH l_cls_id_validate_csr INTO l_cls_type_rec ;
6238: IF l_cls_id_validate_csr%NOTFOUND THEN
6239: --Invalid Clause
6240: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6241: p_msg_name => 'OKC_TERMS_INV_CLS_ID',
6242: p_token1 => 'P_CLS_VER_ID',
6243: p_token1_value => p_clause_version_id);
6244: x_return_status := G_RET_STS_ERROR;
6250: OPEN l_cls_name_validate_csr(G_CURRENT_ORG_ID);
6251: FETCH l_cls_name_validate_csr INTO l_cls_type_rec ;
6252: IF l_cls_name_validate_csr%NOTFOUND THEN
6253: --Invalid Clause Name
6254: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6255: p_msg_name => 'OKC_TERMS_INV_CLS_NAME',
6256: p_token1 => 'P_CLS_TITLE',
6257: p_token1_value => p_clause_title);
6258: x_return_status := G_RET_STS_ERROR;
6327:
6328: WHEN FND_API.G_EXC_ERROR THEN
6329:
6330: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6331: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving add_standard_clause: OKC_API.G_EXCEPTION_ERROR Exception');
6332: END IF;
6333:
6334: IF c_get_doc_art_id_csr%ISOPEN THEN
6335: CLOSE c_get_doc_art_id_csr;
6346: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6347:
6348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6349: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6350: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving add_standard_clause: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
6351: END IF;
6352:
6353: ROLLBACK TO g_remove_std_clause_grp;
6354: x_return_status := G_RET_STS_UNEXP_ERROR ;
6449:
6450: -- Check that Clause info is provided
6451: IF p_clause_id is NULL THEN
6452: -- no clause is provided
6453: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6454: p_msg_name => 'OKC_TERMS_INV_CLS');
6455: x_return_status := G_RET_STS_ERROR;
6456: RAISE FND_API.G_EXC_ERROR ;
6457: END IF;
6460: OPEN c_get_doc_art_id_csr;
6461: FETCH c_get_doc_art_id_csr INTO l_object_version_number;
6462: IF c_get_doc_art_id_csr%NOTFOUND THEN
6463: --Invalid Clause
6464: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6465: p_msg_name => 'OKC_TERMS_INV_CLS_ID',
6466: p_token1 => 'P_CLS_ID',
6467: p_token1_value => p_clause_id);
6468: x_return_status := G_RET_STS_ERROR;
6536:
6537: WHEN FND_API.G_EXC_ERROR THEN
6538:
6539: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6540: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving add_standard_clause: OKC_API.G_EXCEPTION_ERROR Exception');
6541: END IF;
6542:
6543: IF c_get_doc_art_id_csr%ISOPEN THEN
6544: CLOSE c_get_doc_art_id_csr;
6549: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6550:
6551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6552: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6553: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving add_standard_clause: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
6554: END IF;
6555:
6556: ROLLBACK TO g_remove_clause_from_doc_GRP;
6557: x_return_status := G_RET_STS_UNEXP_ERROR ;