eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_TERMS_MIGRATE_GRP dependencies on STANDARD

Line 162: SELECT org_id, Decode (contract_type, 'BLANKET', 'PA_BLANKET', 'CONTRACT' , 'PA_CONTRACT', 'BLANKET', 'PO_STANDARD',NULL) target_doc_type

158: WHERE contract_id = p_document_id;
159:
160: CURSOR l_sourcing_doc_csr
161: is
162: SELECT org_id, Decode (contract_type, 'BLANKET', 'PA_BLANKET', 'CONTRACT' , 'PA_CONTRACT', 'BLANKET', 'PO_STANDARD',NULL) target_doc_type
163: FROM pon_auction_headers_all
164: WHERE auction_header_id = p_document_id;
165:
166:

Line 188: IF p_document_type IN ('PA_BLANKET', 'PA_CONTRACT','PO_STANDARD') THEN

184: x_return_status := G_RET_STS_ERROR;
185: END IF;
186: CLOSE l_doc_type_csr;
187:
188: IF p_document_type IN ('PA_BLANKET', 'PA_CONTRACT','PO_STANDARD') THEN
189:
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

Line 596: -- Standard Start of API savepoint

592: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_attachment_file_loc : '||p_attachment_file_loc);
593: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_attachment_file_name : '||p_attachment_file_name);
594: END IF;
595:
596: -- Standard Start of API savepoint
597: SAVEPOINT G_CREATE_CONTRACT_TERMS_GRP;
598:
599: -- Standard call to check for call compatibility.
600: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 599: -- Standard call to check for call compatibility.

595:
596: -- Standard Start of API savepoint
597: SAVEPOINT G_CREATE_CONTRACT_TERMS_GRP;
598:
599: -- Standard call to check for call compatibility.
600: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603:

Line 705: /*IF p_document_type IN ('PA_BLANKET', 'PA_CONTRACT','PO_STANDARD') AND

701: CLOSE l_tmpl_name_validate_csr;
702:
703: END IF;
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',

Line 1019: IF p_document_type IN ('PA_BLANKET', 'PA_CONTRACT','PO_STANDARD') THEN

1015: RAISE NO_DATA_FOUND;
1016: END IF;
1017: CLOSE l_cat_id_csr;
1018:
1019: IF p_document_type IN ('PA_BLANKET', 'PA_CONTRACT','PO_STANDARD') THEN
1020: OPEN l_bus_doc_ver_csr;
1021: FETCH l_bus_doc_ver_csr INTO l_business_document_version;
1022: IF l_bus_doc_ver_csr%NOTFOUND THEN
1023: l_business_document_version := -99;

Line 1163: -- Standard call to get message count and if count is 1, get message info.

1159: IF FND_API.To_Boolean( p_commit ) THEN
1160: COMMIT WORK;
1161: END IF;
1162:
1163: -- Standard call to get message count and if count is 1, get message info.
1164: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1165:
1166: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1167: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving create_contract_terms');

Line 1316: -- Standard Start of API savepoint

1312: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_attachment_file_loc : '||p_attachment_file_loc);
1313: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_attachment_file_name : '||p_attachment_file_name);
1314: END IF;
1315:
1316: -- Standard Start of API savepoint
1317: SAVEPOINT G_ADD_CONTRACT_DOC_GRP;
1318:
1319: -- Standard call to check for call compatibility.
1320: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 1319: -- Standard call to check for call compatibility.

1315:
1316: -- Standard Start of API savepoint
1317: SAVEPOINT G_ADD_CONTRACT_DOC_GRP;
1318:
1319: -- Standard call to check for call compatibility.
1320: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1322: END IF;
1323:

Line 1509: IF p_document_type IN ('PA_BLANKET', 'PA_CONTRACT','PO_STANDARD') THEN

1505: END IF;
1506: CLOSE l_cat_id_csr;
1507:
1508:
1509: IF p_document_type IN ('PA_BLANKET', 'PA_CONTRACT','PO_STANDARD') THEN
1510: OPEN l_bus_doc_ver_csr;
1511: FETCH l_bus_doc_ver_csr INTO l_business_document_version;
1512: IF l_bus_doc_ver_csr%NOTFOUND THEN
1513: l_business_document_version := -99;

Line 1631: -- Standard call to get message count and if count is 1, get message info.

1627: IF FND_API.To_Boolean( p_commit ) THEN
1628: COMMIT WORK;
1629: END IF;
1630:
1631: -- Standard call to get message count and if count is 1, get message info.
1632: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1633:
1634: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1635: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving add_contract_doc');

Line 1677: Procedure Add_Standard_Clause

1673: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1674:
1675: END Add_Contract_Doc;
1676:
1677: Procedure Add_Standard_Clause
1678: ( p_api_version IN Number,
1679: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
1680: p_commit IN Varchar2 default FND_API.G_FALSE,
1681: x_return_status OUT NOCOPY Varchar2,

Line 1698: l_api_name CONSTANT VARCHAR2(30) := 'Add_Standard_Clause';

1694: p_mode IN VARCHAR2 := 'NORMAL' -- Other value 'AMEND'
1695: )
1696: IS
1697: l_api_version CONSTANT NUMBER := 1;
1698: l_api_name CONSTANT VARCHAR2(30) := 'Add_Standard_Clause';
1699: l_scn_id OKC_SECTIONS_B.ID%TYPE;
1700: l_id NUMBER;
1701: l_ref_sequence NUMBER := 0;
1702: la_ref_sequence NUMBER := 0;

Line 1802: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Entered OKC_TERMS_MIGRATE_GRP.Add_Standard_Clause');

1798: WHERE document_type = p_document_type;
1799:
1800: BEGIN
1801: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1802: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Entered OKC_TERMS_MIGRATE_GRP.Add_Standard_Clause');
1803: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Parameter List ');
1804: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_api_version : '||p_api_version);
1805: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_init_msg_list : '||p_init_msg_list);
1806: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_commit : '||p_commit);

Line 1817: -- Standard Start of API savepoint

1813: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_clause_version_num : '||p_clause_version_num);
1814: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_renumber_terms : '||p_renumber_terms);
1815: END IF;
1816:
1817: -- Standard Start of API savepoint
1818: SAVEPOINT g_add_standard_clause_GRP;
1819:
1820: -- Standard call to check for call compatibility.
1821: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 1818: SAVEPOINT g_add_standard_clause_GRP;

1814: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_renumber_terms : '||p_renumber_terms);
1815: END IF;
1816:
1817: -- Standard Start of API savepoint
1818: SAVEPOINT g_add_standard_clause_GRP;
1819:
1820: -- Standard call to check for call compatibility.
1821: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1820: -- Standard call to check for call compatibility.

1816:
1817: -- Standard Start of API savepoint
1818: SAVEPOINT g_add_standard_clause_GRP;
1819:
1820: -- Standard call to check for call compatibility.
1821: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1823: END IF;
1824:

Line 1961: /*IF p_document_type IN ('PA_BLANKET', 'PA_CONTRACT','PO_STANDARD', 'AUCTION', 'RFI', 'RFQ') AND

1957: x_return_status := G_RET_STS_ERROR;
1958: RAISE FND_API.G_EXC_ERROR ;
1959: END IF;
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',

Line 2087: -- Standard call to get message count and if count is 1, get message info.

2083: IF FND_API.To_Boolean( p_commit ) THEN
2084: COMMIT WORK;
2085: END IF;
2086:
2087: -- Standard call to get message count and if count is 1, get message info.
2088: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2089:
2090: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2091: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving add_standard_clause');

Line 2091: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving add_standard_clause');

2087: -- Standard call to get message count and if count is 1, get message info.
2088: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2089:
2090: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2091: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving add_standard_clause');
2092: END IF;
2093:
2094: EXCEPTION
2095:

Line 2099: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving add_standard_clause: OKC_API.G_EXCEPTION_ERROR Exception');

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;

Line 2115: ROLLBACK TO g_add_standard_clause_grp;

2111: IF l_cls_name_validate_csr%ISOPEN THEN
2112: CLOSE l_cls_name_validate_csr;
2113: END IF;
2114:
2115: ROLLBACK TO g_add_standard_clause_grp;
2116: x_return_status := G_RET_STS_ERROR ;
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

Line 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');

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 ;

Line 2124: ROLLBACK TO g_add_standard_clause_grp;

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 ;
2126: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2127:
2128: WHEN OTHERS THEN

Line 2130: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving add_standard_clause because of EXCEPTION: '||sqlerrm);

2126: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2127:
2128: WHEN OTHERS THEN
2129: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2130: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving add_standard_clause because of EXCEPTION: '||sqlerrm);
2131: END IF;
2132:
2133: ROLLBACK TO g_add_standard_clause_grp;
2134: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 2133: ROLLBACK TO g_add_standard_clause_grp;

2129: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2130: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving add_standard_clause because of EXCEPTION: '||sqlerrm);
2131: END IF;
2132:
2133: ROLLBACK TO g_add_standard_clause_grp;
2134: x_return_status := G_RET_STS_UNEXP_ERROR ;
2135: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2136: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2137: END IF;

Line 2141: END Add_Standard_Clause;

2137: END IF;
2138: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2139:
2140:
2141: END Add_Standard_Clause;
2142:
2143: Procedure Add_Non_Standard_Clause
2144: ( p_api_version IN Number,
2145: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

Line 2143: Procedure Add_Non_Standard_Clause

2139:
2140:
2141: END Add_Standard_Clause;
2142:
2143: Procedure Add_Non_Standard_Clause
2144: ( p_api_version IN Number,
2145: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
2146: p_commit IN Varchar2 default FND_API.G_FALSE,
2147: x_return_status OUT NOCOPY Varchar2,

Line 2167: l_api_name CONSTANT VARCHAR2(30) := 'Add_Non_Standard_Clause';

2163: x_clause_version_id OUT NOCOPY Number
2164: )
2165: IS
2166: l_api_version CONSTANT NUMBER := 1;
2167: l_api_name CONSTANT VARCHAR2(30) := 'Add_Non_Standard_Clause';
2168: l_cat_id NUMBER;
2169: l_article_version_id NUMBER;
2170: l_scn_id OKC_SECTIONS_B.ID%TYPE;
2171:

Line 2191: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Entered OKC_TERMS_MIGRATE_GRP.Add_Non_Standard_Clause');

2187: AND DOCUMENT_ID = p_document_id;
2188:
2189: BEGIN
2190: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2191: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Entered OKC_TERMS_MIGRATE_GRP.Add_Non_Standard_Clause');
2192: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Parameter List ');
2193: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_api_version : '||p_api_version);
2194: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_init_msg_list : '||p_init_msg_list);
2195: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_commit : '||p_commit);

Line 2208: -- Standard Start of API savepoint

2204: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_clause_description : '||p_clause_description);
2205: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_renumber_terms : '||p_renumber_terms);
2206: END IF;
2207:
2208: -- Standard Start of API savepoint
2209: SAVEPOINT g_add_non_standrad_clause_grp;
2210:
2211: -- Standard call to check for call compatibility.
2212: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 2211: -- Standard call to check for call compatibility.

2207:
2208: -- Standard Start of API savepoint
2209: SAVEPOINT g_add_non_standrad_clause_grp;
2210:
2211: -- Standard call to check for call compatibility.
2212: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2214: END IF;
2215:

Line 2366: -- Standard call to get message count and if count is 1, get message info.

2362: IF FND_API.To_Boolean( p_commit ) THEN
2363: COMMIT WORK;
2364: END IF;
2365:
2366: -- Standard call to get message count and if count is 1, get message info.
2367: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2368:
2369: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2370: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving add_non_standard_clause');

Line 2370: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving add_non_standard_clause');

2366: -- Standard call to get message count and if count is 1, get message info.
2367: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2368:
2369: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2370: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving add_non_standard_clause');
2371: END IF;
2372:
2373: EXCEPTION
2374:

Line 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');

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;

Line 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');

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 ;

Line 2402: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving add_non_standard_clause because of EXCEPTION: '||sqlerrm);

2398: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2399:
2400: WHEN OTHERS THEN
2401: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2402: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving add_non_standard_clause because of EXCEPTION: '||sqlerrm);
2403: END IF;
2404:
2405: ROLLBACK TO g_add_non_standrad_clause_grp;
2406: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 2412: END Add_Non_Standard_Clause;

2408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2409: END IF;
2410: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2411:
2412: END Add_Non_Standard_Clause;
2413:
2414: Procedure Add_Section
2415: ( p_api_version IN Number,
2416: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

Line 2483: -- Standard Start of API savepoint

2479: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_section_description : '||p_section_description);
2480: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_renumber_terms : '||p_renumber_terms);
2481: END IF;
2482:
2483: -- Standard Start of API savepoint
2484: SAVEPOINT g_add_section_GRP;
2485:
2486: -- Standard call to check for call compatibility.
2487: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 2486: -- Standard call to check for call compatibility.

2482:
2483: -- Standard Start of API savepoint
2484: SAVEPOINT g_add_section_GRP;
2485:
2486: -- Standard call to check for call compatibility.
2487: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2489: END IF;
2490:

Line 2628: -- Standard call to get message count and if count is 1, get message info.

2624: IF FND_API.To_Boolean( p_commit ) THEN
2625: COMMIT WORK;
2626: END IF;
2627:
2628: -- Standard call to get message count and if count is 1, get message info.
2629: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2630:
2631: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2632: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving add_section');

Line 2927: -- Standard Start of API savepoint

2923: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_document_type : '||p_doc_type);
2924: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_document_id : '||p_doc_id);
2925: END IF;
2926:
2927: -- Standard Start of API savepoint
2928: SAVEPOINT g_update_variable_values_GRP;
2929:
2930: -- Standard call to check for call compatibility.
2931: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 2930: -- Standard call to check for call compatibility.

2926:
2927: -- Standard Start of API savepoint
2928: SAVEPOINT g_update_variable_values_GRP;
2929:
2930: -- Standard call to check for call compatibility.
2931: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2933: END IF;
2934:

Line 3244: -- Standard Start of API savepoint

3240: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_contract_tmpl_name : '||p_contract_tmpl_name);
3241:
3242: END IF;
3243:
3244: -- Standard Start of API savepoint
3245: SAVEPOINT G_CREATE_CONTRACT_TERMS_GRP;
3246:
3247: -- Standard call to check for call compatibility.
3248: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 3247: -- Standard call to check for call compatibility.

3243:
3244: -- Standard Start of API savepoint
3245: SAVEPOINT G_CREATE_CONTRACT_TERMS_GRP;
3246:
3247: -- Standard call to check for call compatibility.
3248: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3250: END IF;
3251:

Line 5690: -- Standard Start of API savepoint

5686: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_document_type : '||p_document_type);
5687: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_document_id : '||p_document_id);
5688: END IF;
5689:
5690: -- Standard Start of API savepoint
5691: SAVEPOINT g_create_deliverables_GRP;
5692:
5693: -- Standard call to check for call compatibility.
5694: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 5693: -- Standard call to check for call compatibility.

5689:
5690: -- Standard Start of API savepoint
5691: SAVEPOINT g_create_deliverables_GRP;
5692:
5693: -- Standard call to check for call compatibility.
5694: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
5695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5696: END IF;
5697:

Line 6187: -- Standard Start of API savepoint

6183: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_clause_version_num : '||p_clause_version_num);
6184: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_renumber_terms : '||p_renumber_terms);
6185: END IF;
6186:
6187: -- Standard Start of API savepoint
6188: SAVEPOINT g_remove_std_clause_grp;
6189:
6190: -- Standard call to check for call compatibility.
6191: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 6190: -- Standard call to check for call compatibility.

6186:
6187: -- Standard Start of API savepoint
6188: SAVEPOINT g_remove_std_clause_grp;
6189:
6190: -- Standard call to check for call compatibility.
6191: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
6192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6193: END IF;
6194:

Line 6319: -- Standard call to get message count and if count is 1, get message info.

6315: IF FND_API.To_Boolean( p_commit ) THEN
6316: COMMIT WORK;
6317: END IF;
6318:
6319: -- Standard call to get message count and if count is 1, get message info.
6320: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6321:
6322: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6323: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving add_standard_clause');

Line 6323: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving add_standard_clause');

6319: -- Standard call to get message count and if count is 1, get message info.
6320: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6321:
6322: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6323: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving add_standard_clause');
6324: END IF;
6325:
6326: EXCEPTION
6327:

Line 6331: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving add_standard_clause: OKC_API.G_EXCEPTION_ERROR Exception');

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;

Line 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');

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 ;

Line 6359: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving add_standard_clause because of EXCEPTION: '||sqlerrm);

6355: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6356:
6357: WHEN OTHERS THEN
6358: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6359: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving add_standard_clause because of EXCEPTION: '||sqlerrm);
6360: END IF;
6361:
6362: ROLLBACK TO g_remove_std_clause_grp;
6363: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 6411: -- Standard Start of API savepoint

6407: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_clause_version_id : '||p_clause_id);
6408: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: p_renumber_terms : '||p_renumber_terms);
6409: END IF;
6410:
6411: -- Standard Start of API savepoint
6412: SAVEPOINT g_remove_clause_from_doc_GRP;
6413:
6414: -- Standard call to check for call compatibility.
6415: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 6414: -- Standard call to check for call compatibility.

6410:
6411: -- Standard Start of API savepoint
6412: SAVEPOINT g_remove_clause_from_doc_GRP;
6413:
6414: -- Standard call to check for call compatibility.
6415: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
6416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6417: END IF;
6418:

Line 6528: -- Standard call to get message count and if count is 1, get message info.

6524: IF FND_API.To_Boolean( p_commit ) THEN
6525: COMMIT WORK;
6526: END IF;
6527:
6528: -- Standard call to get message count and if count is 1, get message info.
6529: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6530:
6531: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6532: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving add_standard_clause');

Line 6532: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving add_standard_clause');

6528: -- Standard call to get message count and if count is 1, get message info.
6529: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6530:
6531: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6532: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving add_standard_clause');
6533: END IF;
6534:
6535: EXCEPTION
6536:

Line 6540: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving add_standard_clause: OKC_API.G_EXCEPTION_ERROR Exception');

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;

Line 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');

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 ;

Line 6562: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving add_standard_clause because of EXCEPTION: '||sqlerrm);

6558: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6559:
6560: WHEN OTHERS THEN
6561: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6562: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving add_standard_clause because of EXCEPTION: '||sqlerrm);
6563: END IF;
6564:
6565: ROLLBACK TO g_remove_clause_from_doc_GRP;
6566: x_return_status := G_RET_STS_UNEXP_ERROR ;