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_COPY_PVT dependencies on FND_API

Line 21: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

17:
18: ------------------------------------------------------------------------------
19: -- GLOBAL CONSTANTS
20: ------------------------------------------------------------------------------
21: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
22: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
23:
24: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
25: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 22: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

18: ------------------------------------------------------------------------------
19: -- GLOBAL CONSTANTS
20: ------------------------------------------------------------------------------
21: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
22: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
23:
24: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
25: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
26: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 24: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

20: ------------------------------------------------------------------------------
21: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
22: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
23:
24: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
25: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
26: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
27:
28: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

Line 25: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

21: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
22: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
23:
24: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
25: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
26: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
27:
28: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
29: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';

Line 26: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

22: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
23:
24: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
25: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
26: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
27:
28: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
29: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
30: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';

Line 556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

552: x_msg_count => x_msg_count,
553: x_msg_data => x_msg_data
554: );
555: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
557: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
558: RAISE FND_API.G_EXC_ERROR ;
559: END IF;
560: END IF; -- mrvariablexml_tbl(i) is not null

Line 558: RAISE FND_API.G_EXC_ERROR ;

554: );
555: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
557: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
558: RAISE FND_API.G_EXC_ERROR ;
559: END IF;
560: END IF; -- mrvariablexml_tbl(i) is not null
561: END LOOP;
562: END IF; -- dochasmrv

Line 575: WHEN FND_API.G_EXC_ERROR THEN

571: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'900: Leaving copy_article_variables '||x_return_status);
572: END IF;
573:
574: EXCEPTION
575: WHEN FND_API.G_EXC_ERROR THEN
576:
577: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
578: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_article_variables:FND_API.G_EXC_ERROR Exception');
579: END IF;

Line 578: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_article_variables:FND_API.G_EXC_ERROR Exception');

574: EXCEPTION
575: WHEN FND_API.G_EXC_ERROR THEN
576:
577: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
578: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_article_variables:FND_API.G_EXC_ERROR Exception');
579: END IF;
580:
581: IF l_get_variables_csr%ISOPEN THEN
582: CLOSE l_get_variables_csr;

Line 587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

583: END IF;
584: x_return_status := G_RET_STS_ERROR;
585: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
586:
587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
588:
589: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
590: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving copy_article_variables:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
591: END IF;

Line 590: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving copy_article_variables:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

586:
587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
588:
589: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
590: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving copy_article_variables:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
591: END IF;
592:
593: IF l_get_variables_csr%ISOPEN THEN
594: CLOSE l_get_variables_csr;

Line 1305: p_init_msg_list => FND_API.G_FALSE,

1301:
1302: -- Copying Non-Standard Article
1303:
1304: OKC_ARTICLES_GRP.copy_article( p_api_version => 1,
1305: p_init_msg_list => FND_API.G_FALSE,
1306: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1307: p_commit => FND_API.G_FALSE,
1308: p_article_version_id => article_version_tbl(i),
1309: p_new_article_title => NULL,

Line 1306: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1302: -- Copying Non-Standard Article
1303:
1304: OKC_ARTICLES_GRP.copy_article( p_api_version => 1,
1305: p_init_msg_list => FND_API.G_FALSE,
1306: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1307: p_commit => FND_API.G_FALSE,
1308: p_article_version_id => article_version_tbl(i),
1309: p_new_article_title => NULL,
1310: p_create_standard_yn => 'N',

Line 1307: p_commit => FND_API.G_FALSE,

1303:
1304: OKC_ARTICLES_GRP.copy_article( p_api_version => 1,
1305: p_init_msg_list => FND_API.G_FALSE,
1306: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1307: p_commit => FND_API.G_FALSE,
1308: p_article_version_id => article_version_tbl(i),
1309: p_new_article_title => NULL,
1310: p_create_standard_yn => 'N',
1311: x_article_version_id => article_version_tbl(i),

Line 1319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1315: x_msg_count => x_msg_count,
1316: x_msg_data => x_msg_data);
1317:
1318: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1320: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1321: RAISE FND_API.G_EXC_ERROR ;
1322: END IF;
1323: /*

Line 1321: RAISE FND_API.G_EXC_ERROR ;

1317:
1318: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1320: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1321: RAISE FND_API.G_EXC_ERROR ;
1322: END IF;
1323: /*
1324: OPEN l_get_no_std_ref_csr(article_version_tbl(i));
1325: FETCH l_get_no_std_ref_csr INTO ref_article_id_tbl(i),ref_article_version_id_tbl(i);

Line 1621: WHEN FND_API.G_EXC_ERROR THEN

1617: END IF;
1618:
1619: EXCEPTION
1620:
1621: WHEN FND_API.G_EXC_ERROR THEN
1622:
1623: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1624: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_articles:FND_API.G_EXC_ERROR Exception');
1625: END IF;

Line 1624: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_articles:FND_API.G_EXC_ERROR Exception');

1620:
1621: WHEN FND_API.G_EXC_ERROR THEN
1622:
1623: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1624: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_articles:FND_API.G_EXC_ERROR Exception');
1625: END IF;
1626: IF l_get_prov_csr%ISOPEN THEN
1627: CLOSE l_get_prov_csr;
1628: END IF;

Line 1658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1654:
1655: x_return_status := G_RET_STS_ERROR;
1656: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1657:
1658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1659:
1660: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1661: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving copy_articles:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1662: END IF;

Line 1661: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving copy_articles:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

1657:
1658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1659:
1660: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1661: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving copy_articles:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1662: END IF;
1663: IF l_get_article_csr%ISOPEN THEN
1664: CLOSE l_get_article_csr;
1665: END IF;

Line 1822: OKC_CODE_HOOK.IS_NOT_PROVISIONAL_SECTION(heading) = FND_API.G_TRUE

1818: heading <> Nvl(fnd_profile.Value('OKC_AMENDMENT_SPECIFIC_SECTION'),'~!@#$%')
1819: ) OR
1820: (
1821: l_scn_drp_action = 'DROP_PROV_SEC' AND
1822: OKC_CODE_HOOK.IS_NOT_PROVISIONAL_SECTION(heading) = FND_API.G_TRUE
1823: ) OR
1824: l_scn_drp_action = 'DROP_NOTHING')
1825: AND ( p_retain_lock_terms_yn = 'N'
1826: OR

Line 1887: OKC_CODE_HOOK.IS_NOT_PROVISIONAL_SECTION(heading) = FND_API.G_TRUE

1883: heading <> Nvl(fnd_profile.Value('OKC_AMENDMENT_SPECIFIC_SECTION'),'~!@#$%')
1884: ) OR
1885: (
1886: l_scn_drp_action = 'DROP_PROV_SEC' AND
1887: OKC_CODE_HOOK.IS_NOT_PROVISIONAL_SECTION(heading) = FND_API.G_TRUE
1888: ) OR
1889: l_scn_drp_action = 'DROP_NOTHING');
1890:
1891: --kkolukul: CLM changes

Line 2168: WHEN FND_API.G_EXC_ERROR THEN

2164: END IF;
2165:
2166: EXCEPTION
2167:
2168: WHEN FND_API.G_EXC_ERROR THEN
2169:
2170: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2171: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_sections:FND_API.G_EXC_ERROR Exception');
2172: END IF;

Line 2171: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_sections:FND_API.G_EXC_ERROR Exception');

2167:
2168: WHEN FND_API.G_EXC_ERROR THEN
2169:
2170: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2171: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_sections:FND_API.G_EXC_ERROR Exception');
2172: END IF;
2173:
2174: IF l_get_scn_csr %ISOPEN THEN
2175: CLOSE l_get_scn_csr ;

Line 2181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2177:
2178: x_return_status := G_RET_STS_ERROR;
2179: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2180:
2181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2182:
2183: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2184: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving copy_sections:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2185: END IF;

Line 2184: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving copy_sections:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

2180:
2181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2182:
2183: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2184: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving copy_sections:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2185: END IF;
2186:
2187: IF l_get_scn_csr %ISOPEN THEN
2188: CLOSE l_get_scn_csr ;

Line 2315: p_commit => FND_API.G_FALSE,

2311: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'120: Creating Unassgined Section ');
2312: END IF;
2313:
2314: OKC_TERMS_UTIL_PVT.create_unassigned_section(p_api_version => 1,
2315: p_commit => FND_API.G_FALSE,
2316: p_doc_type => p_doc_type,
2317: p_doc_id => p_doc_id,
2318: x_scn_id =>l_unassigned_scn_id,
2319: x_return_status => x_return_status,

Line 2329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2325: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'130: Cannot Create Unassgined Section : '||x_msg_data||' Status '||x_return_status);
2326: END IF;
2327:
2328: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2330: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2331: RAISE FND_API.G_EXC_ERROR ;
2332: END IF;
2333:

Line 2331: RAISE FND_API.G_EXC_ERROR ;

2327:
2328: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2330: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2331: RAISE FND_API.G_EXC_ERROR ;
2332: END IF;
2333:
2334:
2335: END IF;

Line 2407: p_init_msg_list => FND_API.G_FALSE,

2403: END IF;
2404:
2405: OKC_DELIVERABLE_PROCESS_PVT.delete_template_deliverables (
2406: p_api_version => 1,
2407: p_init_msg_list => FND_API.G_FALSE,
2408: p_doc_id => p_doc_id,
2409: p_doc_type => p_doc_type,
2410: x_msg_data => x_msg_data,
2411: x_msg_count => x_msg_count,

Line 2421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2417: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'180: x_msg_count : '||x_msg_count);
2418: END IF;
2419:
2420: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2422: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2423: RAISE FND_API.G_EXC_ERROR ;
2424: END IF;
2425:

Line 2423: RAISE FND_API.G_EXC_ERROR ;

2419:
2420: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2422: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2423: RAISE FND_API.G_EXC_ERROR ;
2424: END IF;
2425:
2426: /*kkolukul: clm changes- Delete entries from multiple templates table*/
2427:

Line 2446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2442: p_object_version_number => l_objnum
2443: );
2444: --------------------------------------------
2445: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2447: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2448: RAISE FND_API.G_EXC_ERROR ;
2449: END IF;
2450: --------------------------------------------

Line 2448: RAISE FND_API.G_EXC_ERROR ;

2444: --------------------------------------------
2445: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2447: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2448: RAISE FND_API.G_EXC_ERROR ;
2449: END IF;
2450: --------------------------------------------
2451: END IF;
2452:

Line 2495: WHEN FND_API.G_EXC_ERROR THEN

2491: END IF;
2492:
2493: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
2494: x_return_status := G_RET_STS_ERROR ;
2495: WHEN FND_API.G_EXC_ERROR THEN
2496:
2497: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2498: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving remove_template_based_articles:FND_API.G_EXC_ERROR Exception');
2499: END IF;

Line 2498: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving remove_template_based_articles:FND_API.G_EXC_ERROR Exception');

2494: x_return_status := G_RET_STS_ERROR ;
2495: WHEN FND_API.G_EXC_ERROR THEN
2496:
2497: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2498: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving remove_template_based_articles:FND_API.G_EXC_ERROR Exception');
2499: END IF;
2500:
2501: IF lock_kart_for_upd_csr%ISOPEN THEN
2502: CLOSE lock_kart_for_upd_csr;

Line 2528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2524:
2525: x_return_status := G_RET_STS_ERROR;
2526: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2527:
2528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2529:
2530: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2531: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving remove_template_based_articles:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2532: END IF;

Line 2531: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving remove_template_based_articles:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

2527:
2528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2529:
2530: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2531: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving remove_template_based_articles:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2532: END IF;
2533:
2534: IF lock_kart_for_upd_csr%ISOPEN THEN
2535: CLOSE lock_kart_for_upd_csr;

Line 2724: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

2720: -- Standard Start of API savepoint
2721: SAVEPOINT g_copy_tc_pvt;
2722:
2723: -- Standard call to check for call compatibility.
2724: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2726: END IF;
2727:
2728: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2721: SAVEPOINT g_copy_tc_pvt;
2722:
2723: -- Standard call to check for call compatibility.
2724: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2726: END IF;
2727:
2728: -- Initialize message list if p_init_msg_list is set to TRUE.
2729: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2729: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2726: END IF;
2727:
2728: -- Initialize message list if p_init_msg_list is set to TRUE.
2729: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2730: FND_MSG_PUB.initialize;
2731: END IF;
2732:
2733: -- Initialize API return status to success

Line 2734: x_return_status := FND_API.G_RET_STS_SUCCESS;

2730: FND_MSG_PUB.initialize;
2731: END IF;
2732:
2733: -- Initialize API return status to success
2734: x_return_status := FND_API.G_RET_STS_SUCCESS;
2735:
2736: -- Checking If doc types are valid
2737:
2738: IF (p_source_doc_type IS NOT NULL

Line 2739: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_PVT.is_doc_type_valid ( p_doc_type => p_source_doc_type , x_return_status => x_return_status))) THEN

2735:
2736: -- Checking If doc types are valid
2737:
2738: IF (p_source_doc_type IS NOT NULL
2739: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_PVT.is_doc_type_valid ( p_doc_type => p_source_doc_type , x_return_status => x_return_status))) THEN
2740:
2741: okc_Api.Set_Message(p_app_name => G_APP_NAME,
2742: p_msg_name => 'OKC_INVALID_DOC_TYPE',
2743: p_token1 => 'DOCUMENT_TYPE',

Line 2745: RAISE FND_API.G_EXC_ERROR ;

2741: okc_Api.Set_Message(p_app_name => G_APP_NAME,
2742: p_msg_name => 'OKC_INVALID_DOC_TYPE',
2743: p_token1 => 'DOCUMENT_TYPE',
2744: p_token2_value => p_source_doc_type);
2745: RAISE FND_API.G_EXC_ERROR ;
2746:
2747:
2748: END IF;
2749:

Line 2751: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_PVT.is_doc_type_valid ( p_doc_type => p_target_doc_type , x_return_status => x_return_status))) THEN

2747:
2748: END IF;
2749:
2750: IF (p_target_doc_type IS NOT NULL
2751: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_PVT.is_doc_type_valid ( p_doc_type => p_target_doc_type , x_return_status => x_return_status))) THEN
2752:
2753: okc_Api.Set_Message(p_app_name => G_APP_NAME,
2754: p_msg_name => 'OKC_INVALID_DOC_TYPE',
2755: p_token1 => 'DOCUMENT_TYPE',

Line 2757: RAISE FND_API.G_EXC_ERROR ;

2753: okc_Api.Set_Message(p_app_name => G_APP_NAME,
2754: p_msg_name => 'OKC_INVALID_DOC_TYPE',
2755: p_token1 => 'DOCUMENT_TYPE',
2756: p_token2_value => p_target_doc_type);
2757: RAISE FND_API.G_EXC_ERROR ;
2758:
2759: END IF;
2760:
2761: IF p_target_doc_type=OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE

Line 2775: p_init_msg_list => FND_API.G_FALSE,

2771: END IF;
2772:
2773: OKC_TERMS_TEMPLATES_GRP.create_template(
2774: p_api_version => 1,
2775: p_init_msg_list => FND_API.G_FALSE,
2776: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2777: p_commit => FND_API.G_FALSE,
2778: x_return_status => x_return_status,
2779: x_msg_count => x_msg_count,

Line 2776: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2772:
2773: OKC_TERMS_TEMPLATES_GRP.create_template(
2774: p_api_version => 1,
2775: p_init_msg_list => FND_API.G_FALSE,
2776: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2777: p_commit => FND_API.G_FALSE,
2778: x_return_status => x_return_status,
2779: x_msg_count => x_msg_count,
2780: x_msg_data => x_msg_data,

Line 2777: p_commit => FND_API.G_FALSE,

2773: OKC_TERMS_TEMPLATES_GRP.create_template(
2774: p_api_version => 1,
2775: p_init_msg_list => FND_API.G_FALSE,
2776: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2777: p_commit => FND_API.G_FALSE,
2778: x_return_status => x_return_status,
2779: x_msg_count => x_msg_count,
2780: x_msg_data => x_msg_data,
2781: p_template_name => p_target_template_rec.template_name,

Line 2831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2827: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'150:Finished template Creation. Return Status '||x_return_status||' new template_id '||l_template_id);
2828: END IF;
2829:
2830: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2832: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2833: RAISE FND_API.G_EXC_ERROR ;
2834: END IF;
2835:

Line 2833: RAISE FND_API.G_EXC_ERROR ;

2829:
2830: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2832: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2833: RAISE FND_API.G_EXC_ERROR ;
2834: END IF;
2835:
2836: p_target_doc_id := l_template_id;
2837:

Line 2849: p_init_msg_list =>FND_API.G_FALSE,

2845: FOR cr in l_get_allwd_usage_csr(p_target_template_rec.parent_template_id) LOOP
2846: select OKC_ALLOWED_TMPL_USAGES_S.NEXTVAL into l_tmpl_usage_id from dual;
2847: OKC_ALLOWED_TMPL_USAGES_GRP.Create_Allowed_Tmpl_Usages(
2848: p_api_version =>1,
2849: p_init_msg_list =>FND_API.G_FALSE,
2850: p_commit => FND_API.G_FALSE,
2851: x_return_status => x_return_status,
2852: x_msg_count => x_msg_count,
2853: x_msg_data => x_msg_data,

Line 2850: p_commit => FND_API.G_FALSE,

2846: select OKC_ALLOWED_TMPL_USAGES_S.NEXTVAL into l_tmpl_usage_id from dual;
2847: OKC_ALLOWED_TMPL_USAGES_GRP.Create_Allowed_Tmpl_Usages(
2848: p_api_version =>1,
2849: p_init_msg_list =>FND_API.G_FALSE,
2850: p_commit => FND_API.G_FALSE,
2851: x_return_status => x_return_status,
2852: x_msg_count => x_msg_count,
2853: x_msg_data => x_msg_data,
2854: p_template_id => l_template_id,

Line 2877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2873: p_attribute15 =>cr.attribute15,
2874: x_allowed_tmpl_usages_id =>lx_tmpl_usage_id
2875: );
2876: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2878: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2879: RAISE FND_API.G_EXC_ERROR ;
2880: END IF;
2881: END LOOP;

Line 2879: RAISE FND_API.G_EXC_ERROR ;

2875: );
2876: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2878: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2879: RAISE FND_API.G_EXC_ERROR ;
2880: END IF;
2881: END LOOP;
2882:
2883: END IF;

Line 2905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2901: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300:Finished copy_section. Return Status '||x_return_status);
2902: END IF;
2903:
2904: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2906: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2907: RAISE FND_API.G_EXC_ERROR ;
2908: END IF;
2909:

Line 2907: RAISE FND_API.G_EXC_ERROR ;

2903:
2904: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2906: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2907: RAISE FND_API.G_EXC_ERROR ;
2908: END IF;
2909:
2910: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2911: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400:Entering copy_articles. ');

Line 2932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2928: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700:Finished copy_articles. Return Status '||x_return_status);
2929: END IF;
2930:
2931: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2933: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2934: RAISE FND_API.G_EXC_ERROR ;
2935: END IF;
2936:

Line 2934: RAISE FND_API.G_EXC_ERROR ;

2930:
2931: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2933: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2934: RAISE FND_API.G_EXC_ERROR ;
2935: END IF;
2936:
2937: OKC_XPRT_TMPL_RULE_ASSNS_PVT.copy_template_rule_assns(
2938: p_api_version => 1,

Line 2939: p_init_msg_list => FND_API.G_FALSE,

2935: END IF;
2936:
2937: OKC_XPRT_TMPL_RULE_ASSNS_PVT.copy_template_rule_assns(
2938: p_api_version => 1,
2939: p_init_msg_list => FND_API.G_FALSE,
2940: p_commit => FND_API.G_FALSE,
2941: p_source_template_id => p_source_doc_id,
2942: p_target_template_id => l_template_id,
2943: x_return_status => x_return_status,

Line 2940: p_commit => FND_API.G_FALSE,

2936:
2937: OKC_XPRT_TMPL_RULE_ASSNS_PVT.copy_template_rule_assns(
2938: p_api_version => 1,
2939: p_init_msg_list => FND_API.G_FALSE,
2940: p_commit => FND_API.G_FALSE,
2941: p_source_template_id => p_source_doc_id,
2942: p_target_template_id => l_template_id,
2943: x_return_status => x_return_status,
2944: x_msg_data => x_msg_data,

Line 2953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2949: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'800:Finished copy_template_rule_assns. Return Status '||x_return_status);
2950: END IF;
2951:
2952: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2954: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2955: RAISE FND_API.G_EXC_ERROR ;
2956: END IF;
2957:

Line 2955: RAISE FND_API.G_EXC_ERROR ;

2951:
2952: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2954: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2955: RAISE FND_API.G_EXC_ERROR ;
2956: END IF;
2957:
2958: ELSIF p_source_doc_type<>OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE
2959: AND p_target_doc_type<>OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE THEN -- Doc to Doc Copy

Line 3035: p_new_config_flag => FND_API.G_TRUE,

3031: p_api_version => 1,
3032: p_init_msg_list => OKC_API.G_FALSE,
3033: p_config_header_id =>l_usage_rec.config_header_id,
3034: p_config_rev_nbr =>l_usage_rec.config_revision_number,
3035: p_new_config_flag => FND_API.G_TRUE,
3036: x_new_config_header_id => l_header_id,
3037: x_new_config_rev_nbr => l_rev_nbr,
3038: x_return_status => x_return_status,
3039: x_msg_data => x_msg_data,

Line 3052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3048: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'500: x_msg_count '||x_msg_count);
3049: END IF;
3050:
3051: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3053: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3054: RAISE FND_API.G_EXC_ERROR ;
3055: END IF;
3056:

Line 3054: RAISE FND_API.G_EXC_ERROR ;

3050:
3051: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3053: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3054: RAISE FND_API.G_EXC_ERROR ;
3055: END IF;
3056:
3057: -- Bug 8246502 Change
3058: END IF;

Line 3134: p_init_msg_list => FND_API.G_FALSE,

3130: end if;
3131: IF l_copy_xprt_data = 'Y' THEN --
3132: OKC_TEMPLATE_USAGES_GRP.create_template_usages(
3133: p_api_version => 1,
3134: p_init_msg_list => FND_API.G_FALSE,
3135: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3136: p_commit => FND_API.G_FALSE,
3137: x_return_status => x_return_status,
3138: x_msg_data => x_msg_data,

Line 3135: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3131: IF l_copy_xprt_data = 'Y' THEN --
3132: OKC_TEMPLATE_USAGES_GRP.create_template_usages(
3133: p_api_version => 1,
3134: p_init_msg_list => FND_API.G_FALSE,
3135: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3136: p_commit => FND_API.G_FALSE,
3137: x_return_status => x_return_status,
3138: x_msg_data => x_msg_data,
3139: x_msg_count => x_msg_count,

Line 3136: p_commit => FND_API.G_FALSE,

3132: OKC_TEMPLATE_USAGES_GRP.create_template_usages(
3133: p_api_version => 1,
3134: p_init_msg_list => FND_API.G_FALSE,
3135: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3136: p_commit => FND_API.G_FALSE,
3137: x_return_status => x_return_status,
3138: x_msg_data => x_msg_data,
3139: x_msg_count => x_msg_count,
3140: p_document_type => p_target_doc_type,

Line 3175: p_init_msg_list => FND_API.G_FALSE,

3171: END IF;
3172: ELSIF Nvl(l_copy_xprt_data,'N') = 'N' THEN
3173: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
3174: p_api_version => 1,
3175: p_init_msg_list => FND_API.G_FALSE,
3176: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3177: p_commit => FND_API.G_FALSE,
3178: x_return_status => x_return_status,
3179: x_msg_data => x_msg_data,

Line 3176: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3172: ELSIF Nvl(l_copy_xprt_data,'N') = 'N' THEN
3173: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
3174: p_api_version => 1,
3175: p_init_msg_list => FND_API.G_FALSE,
3176: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3177: p_commit => FND_API.G_FALSE,
3178: x_return_status => x_return_status,
3179: x_msg_data => x_msg_data,
3180: x_msg_count => x_msg_count,

Line 3177: p_commit => FND_API.G_FALSE,

3173: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
3174: p_api_version => 1,
3175: p_init_msg_list => FND_API.G_FALSE,
3176: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3177: p_commit => FND_API.G_FALSE,
3178: x_return_status => x_return_status,
3179: x_msg_data => x_msg_data,
3180: x_msg_count => x_msg_count,
3181: p_document_type => p_target_doc_type,

Line 3215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3211:
3212: END IF; -- IF p_allow_duplicates <> Y' THEN
3213:
3214: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3216: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3217: RAISE FND_API.G_EXC_ERROR ;
3218: END IF;
3219:

Line 3217: RAISE FND_API.G_EXC_ERROR ;

3213:
3214: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3216: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3217: RAISE FND_API.G_EXC_ERROR ;
3218: END IF;
3219:
3220: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3221: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'650:Calling copy_section');

Line 3241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3237: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'650:Finished copy_section. Return Status '||x_return_status);
3238: END IF;
3239:
3240: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3242: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3243: RAISE FND_API.G_EXC_ERROR ;
3244: END IF;
3245:

Line 3243: RAISE FND_API.G_EXC_ERROR ;

3239:
3240: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3242: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3243: RAISE FND_API.G_EXC_ERROR ;
3244: END IF;
3245:
3246: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3247: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700:Entering copy_articles');

Line 3270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3266: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700:Finished copy_articles. Return Status '||x_return_status);
3267: END IF;
3268:
3269: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3271: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3272: RAISE FND_API.G_EXC_ERROR ;
3273: END IF;
3274:

Line 3272: RAISE FND_API.G_EXC_ERROR ;

3268:
3269: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3271: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3272: RAISE FND_API.G_EXC_ERROR ;
3273: END IF;
3274:
3275: SELECT decode(p_keep_version,'Y','N','Y') INTO l_get_from_library FROM DUAL;
3276:

Line 3317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3313: END IF;
3314: --end CLM Changes
3315:
3316: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3318: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3319: RAISE FND_API.G_EXC_ERROR ;
3320: END IF;
3321: END IF;

Line 3319: RAISE FND_API.G_EXC_ERROR ;

3315:
3316: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3318: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3319: RAISE FND_API.G_EXC_ERROR ;
3320: END IF;
3321: END IF;
3322:
3323: ELSIF p_source_doc_type=OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE

Line 3356: RAISE FND_API.G_EXC_ERROR ;

3352: p_token1 => 'TEMPLATE_NAME',
3353: p_token1_value => l_tmpl_rec.template_name,
3354: p_token2 => 'DOCUMENT_TYPE',
3355: p_token2_value => l_doc_type_name);
3356: RAISE FND_API.G_EXC_ERROR ;
3357:
3358: END IF;
3359:
3360: l_dummy_var := '?';

Line 3389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3385: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3386: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400:After Call to remove_template_based_articles x_return_status : '||x_return_status);
3387: END IF;
3388: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3390: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3391: RAISE FND_API.G_EXC_ERROR ;
3392: END IF;
3393:

Line 3391: RAISE FND_API.G_EXC_ERROR ;

3387: END IF;
3388: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3390: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3391: RAISE FND_API.G_EXC_ERROR ;
3392: END IF;
3393:
3394: OPEN l_lock_usg_csr;
3395: CLOSE l_lock_usg_csr;

Line 3500: p_init_msg_list => FND_API.G_FALSE,

3496: END IF;
3497:
3498: OKC_TEMPLATE_USAGES_GRP.create_template_usages(
3499: p_api_version => 1,
3500: p_init_msg_list => FND_API.G_FALSE,
3501: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3502: p_commit => FND_API.G_FALSE,
3503: x_return_status => x_return_status,
3504: x_msg_count => x_msg_count,

Line 3501: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3497:
3498: OKC_TEMPLATE_USAGES_GRP.create_template_usages(
3499: p_api_version => 1,
3500: p_init_msg_list => FND_API.G_FALSE,
3501: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3502: p_commit => FND_API.G_FALSE,
3503: x_return_status => x_return_status,
3504: x_msg_count => x_msg_count,
3505: x_msg_data => x_msg_data,

Line 3502: p_commit => FND_API.G_FALSE,

3498: OKC_TEMPLATE_USAGES_GRP.create_template_usages(
3499: p_api_version => 1,
3500: p_init_msg_list => FND_API.G_FALSE,
3501: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3502: p_commit => FND_API.G_FALSE,
3503: x_return_status => x_return_status,
3504: x_msg_count => x_msg_count,
3505: x_msg_data => x_msg_data,
3506: p_document_type => p_target_doc_type,

Line 3526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3522: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'500:After call to OKC_TEMPLATE_USAGES_GRP.create_template_usages x_return_status: '||x_return_status);
3523: END IF;
3524:
3525: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3527: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3528: RAISE FND_API.G_EXC_ERROR ;
3529: END IF;
3530:

Line 3528: RAISE FND_API.G_EXC_ERROR ;

3524:
3525: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3527: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3528: RAISE FND_API.G_EXC_ERROR ;
3529: END IF;
3530:
3531: END IF;
3532:

Line 3555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3551: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'600:Finished copy_section. Return Status '||x_return_status);
3552: END IF;
3553:
3554: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3556: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3557: RAISE FND_API.G_EXC_ERROR ;
3558: END IF;
3559:

Line 3557: RAISE FND_API.G_EXC_ERROR ;

3553:
3554: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3556: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3557: RAISE FND_API.G_EXC_ERROR ;
3558: END IF;
3559:
3560: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3561: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700:Entering copy_articles ');

Line 3582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3578: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700:Finished copy_articles. Return Status '||x_return_status);
3579: END IF;
3580:
3581: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3583: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3584: RAISE FND_API.G_EXC_ERROR ;
3585: END IF;
3586:

Line 3584: RAISE FND_API.G_EXC_ERROR ;

3580:
3581: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3583: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3584: RAISE FND_API.G_EXC_ERROR ;
3585: END IF;
3586:
3587:
3588: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3603: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'900:Exited copy_article_variables.Return Status '||x_return_status);
3604: END IF;
3605:
3606: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3608: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3609: RAISE FND_API.G_EXC_ERROR ;
3610: END IF;
3611:

Line 3609: RAISE FND_API.G_EXC_ERROR ;

3605:
3606: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3608: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3609: RAISE FND_API.G_EXC_ERROR ;
3610: END IF;
3611:
3612: /*kkolukul: clm changes*/
3613: IF (p_retain_clauses = 'Y') then

Line 3622: IF FND_API.To_Boolean( p_commit ) THEN

3618: x_msg_count => x_msg_count);
3619: END IF;
3620: END IF;
3621:
3622: IF FND_API.To_Boolean( p_commit ) THEN
3623: COMMIT WORK;
3624: END IF;
3625:
3626: -- Standard call to get message count and if count is 1, get message info.

Line 3672: WHEN FND_API.G_EXC_ERROR THEN

3668: ROLLBACK TO g_copy_tc_pvt;
3669: x_return_status := G_RET_STS_ERROR ;
3670: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
3671:
3672: WHEN FND_API.G_EXC_ERROR THEN
3673:
3674: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3675: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving copy_tc: OKC_API.G_EXCEPTION_ERROR Exception');
3676: END IF;

Line 3710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3706: ROLLBACK TO g_copy_tc_pvt;
3707: x_return_status := G_RET_STS_ERROR ;
3708: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3709:
3710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3711: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3712: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_tc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3713: END IF;
3714:

Line 3884: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

3880: -- Standard Start of API savepoint
3881: SAVEPOINT g_copy_archived_doc_pvt;
3882:
3883: -- Standard call to check for call compatibility.
3884: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3886: END IF;
3887:
3888: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3881: SAVEPOINT g_copy_archived_doc_pvt;
3882:
3883: -- Standard call to check for call compatibility.
3884: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3886: END IF;
3887:
3888: -- Initialize message list if p_init_msg_list is set to TRUE.
3889: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3889: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3886: END IF;
3887:
3888: -- Initialize message list if p_init_msg_list is set to TRUE.
3889: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3890: FND_MSG_PUB.initialize;
3891: END IF;
3892:
3893: -- Initialize API return status to success

Line 3894: x_return_status := FND_API.G_RET_STS_SUCCESS;

3890: FND_MSG_PUB.initialize;
3891: END IF;
3892:
3893: -- Initialize API return status to success
3894: x_return_status := FND_API.G_RET_STS_SUCCESS;
3895:
3896: /* Create Template Usage Record */
3897:
3898: OPEN l_get_usage_csr;

Line 3927: p_init_msg_list => FND_API.G_FALSE,

3923: END IF;
3924:
3925: OKC_TEMPLATE_USAGES_GRP.create_template_usages(
3926: p_api_version => 1,
3927: p_init_msg_list => FND_API.G_FALSE,
3928: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3929: p_commit => FND_API.G_FALSE,
3930: x_return_status => x_return_status,
3931: x_msg_data => x_msg_data,

Line 3928: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3924:
3925: OKC_TEMPLATE_USAGES_GRP.create_template_usages(
3926: p_api_version => 1,
3927: p_init_msg_list => FND_API.G_FALSE,
3928: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3929: p_commit => FND_API.G_FALSE,
3930: x_return_status => x_return_status,
3931: x_msg_data => x_msg_data,
3932: x_msg_count => x_msg_count,

Line 3929: p_commit => FND_API.G_FALSE,

3925: OKC_TEMPLATE_USAGES_GRP.create_template_usages(
3926: p_api_version => 1,
3927: p_init_msg_list => FND_API.G_FALSE,
3928: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3929: p_commit => FND_API.G_FALSE,
3930: x_return_status => x_return_status,
3931: x_msg_data => x_msg_data,
3932: x_msg_count => x_msg_count,
3933: p_document_type => p_target_doc_type,

Line 3956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3952: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300:Finished usage record creation.Return Status'||x_return_status);
3953: END IF;
3954:
3955: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3957: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3958: RAISE FND_API.G_EXC_ERROR ;
3959: END IF;
3960: END IF; -- IF ( p_allow_duplicates <>'Y' and l_term_found='Y') OR l_term_found is NULL THEN

Line 3958: RAISE FND_API.G_EXC_ERROR ;

3954:
3955: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3957: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3958: RAISE FND_API.G_EXC_ERROR ;
3959: END IF;
3960: END IF; -- IF ( p_allow_duplicates <>'Y' and l_term_found='Y') OR l_term_found is NULL THEN
3961:
3962: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3978: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300:Finished copy_section. Return Status '||x_return_status);
3979: END IF;
3980:
3981: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3983: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3984: RAISE FND_API.G_EXC_ERROR ;
3985: END IF;
3986:

Line 3984: RAISE FND_API.G_EXC_ERROR ;

3980:
3981: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3983: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3984: RAISE FND_API.G_EXC_ERROR ;
3985: END IF;
3986:
3987: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3988: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400:Entering copy_articles. ');

Line 4009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4005: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700:Finished copy_articles. Return Status '||x_return_status);
4006: END IF;
4007:
4008: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4010: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4011: RAISE FND_API.G_EXC_ERROR ;
4012: END IF;
4013:

Line 4011: RAISE FND_API.G_EXC_ERROR ;

4007:
4008: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4010: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4011: RAISE FND_API.G_EXC_ERROR ;
4012: END IF;
4013:
4014: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4015: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'800: Copying article variables');

Line 4078: IF FND_API.To_Boolean( p_commit ) THEN

4074: END IF;
4075: END LOOP;
4076: END IF;
4077:
4078: IF FND_API.To_Boolean( p_commit ) THEN
4079: COMMIT WORK;
4080: END IF;
4081:
4082: -- Standard call to get message count and if count is 1, get message info.

Line 4097: WHEN FND_API.G_EXC_ERROR THEN

4093: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1100: Leaving copy_archived_doc No Terms Data in Source');
4094: END IF;
4095: null;
4096:
4097: WHEN FND_API.G_EXC_ERROR THEN
4098:
4099: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4100: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving copy_archived_doc: OKC_API.G_EXCEPTION_ERROR Exception');
4101: END IF;

Line 4115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4111: ROLLBACK TO g_copy_archived_doc_pvt;
4112: x_return_status := G_RET_STS_ERROR ;
4113: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4114:
4115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4116:
4117: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4118: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_archived_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4119: END IF;