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

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

11: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
12: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
13:
14:
15: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
17:
18: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
19: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

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

12: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
13:
14:
15: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
17:
18: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
19: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
20: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

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

14:
15: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
17:
18: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
19: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
20: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
21:
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

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

15: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
17:
18: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
19: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
20: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
21:
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';

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

16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
17:
18: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
19: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
20: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
21:
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
24: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';

Line 42: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

38: -- Procedure: get_user_defined_variables
39: ---------------------------------------------------
40: PROCEDURE get_user_defined_variables (
41: p_api_version IN NUMBER,
42: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
43: p_doc_type IN VARCHAR2,
44: p_doc_id IN NUMBER,
45: p_org_id IN NUMBER,
46: p_intent IN VARCHAR2,

Line 81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

77: x_udf_var_value_tbl => x_udf_var_value_tbl
78: );
79: --- If any errors happen abort API
80: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
82: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
83: RAISE FND_API.G_EXC_ERROR;
84: END IF;
85:

Line 83: RAISE FND_API.G_EXC_ERROR;

79: --- If any errors happen abort API
80: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
82: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
83: RAISE FND_API.G_EXC_ERROR;
84: END IF;
85:
86: END get_user_defined_variables;
87: ---------------------------------------------------

Line 92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

88: -- Procedure: get_udv_with_procedures
89: ---------------------------------------------------
90: PROCEDURE get_udv_with_procedures (
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
93: p_doc_type IN VARCHAR2,
94: p_doc_id IN NUMBER,
95: p_org_id IN NUMBER,
96: p_intent IN VARCHAR2,

Line 133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

129: );
130:
131: --- If any errors happen abort API
132: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
135: RAISE FND_API.G_EXC_ERROR;
136: END IF;
137:

Line 135: RAISE FND_API.G_EXC_ERROR;

131: --- If any errors happen abort API
132: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
135: RAISE FND_API.G_EXC_ERROR;
136: END IF;
137:
138: END get_udv_with_procedures;
139:

Line 415: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

411:
412:
413: PROCEDURE get_clm_udv (
414: p_api_version IN NUMBER,
415: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
416: p_doc_type IN VARCHAR2,
417: p_doc_id IN NUMBER,
418: p_org_id IN NUMBER,
419: p_intent IN VARCHAR2,

Line 593: WHEN FND_API.G_EXC_ERROR THEN

589:
590: EXCEPTION
591:
592:
593: WHEN FND_API.G_EXC_ERROR THEN
594: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
595: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
596: G_MODULE||l_api_name,
597: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

599:
600: x_return_status := G_RET_STS_ERROR ;
601: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
602:
603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
604: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
605: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
606: G_MODULE||l_api_name,
607: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 631: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

627:
628:
629: PROCEDURE set_clm_udv (
630: p_api_version IN NUMBER,
631: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
632: p_document_type IN VARCHAR2,
633: p_document_id IN NUMBER,
634: p_output_error IN VARCHAR2 := FND_API.G_TRUE,
635: x_return_status OUT NOCOPY VARCHAR2,

Line 634: p_output_error IN VARCHAR2 := FND_API.G_TRUE,

630: p_api_version IN NUMBER,
631: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
632: p_document_type IN VARCHAR2,
633: p_document_id IN NUMBER,
634: p_output_error IN VARCHAR2 := FND_API.G_TRUE,
635: x_return_status OUT NOCOPY VARCHAR2,
636: x_msg_data OUT NOCOPY VARCHAR2,
637: x_msg_count OUT NOCOPY NUMBER
638: )

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

675: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: p_document_id:'||p_document_id);
676: END IF;
677:
678: /* Standard call to check for call compatibility */
679: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
681: END IF;
682:
683: /* Initialize message list if p_init_msg_list is set to TRUE */

Line 680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

676: END IF;
677:
678: /* Standard call to check for call compatibility */
679: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
681: END IF;
682:
683: /* Initialize message list if p_init_msg_list is set to TRUE */
684: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 684: IF FND_API.to_Boolean( p_init_msg_list ) THEN

680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
681: END IF;
682:
683: /* Initialize message list if p_init_msg_list is set to TRUE */
684: IF FND_API.to_Boolean( p_init_msg_list ) THEN
685: FND_MSG_PUB.initialize;
686: END IF;
687:
688: /* Initialize API return status to success */

Line 744: IF p_output_error = FND_API.G_TRUE AND FND_MSG_PUB.Count_Msg > 0 THEN

740: l_previous_var_code := csr_get_clm_udv_rec.variable_code;
741:
742: END LOOP;
743:
744: IF p_output_error = FND_API.G_TRUE AND FND_MSG_PUB.Count_Msg > 0 THEN
745:
746: x_return_status := G_RET_STS_ERROR;
747: RAISE FND_API.G_EXC_ERROR;
748: END IF;

Line 747: RAISE FND_API.G_EXC_ERROR;

743:
744: IF p_output_error = FND_API.G_TRUE AND FND_MSG_PUB.Count_Msg > 0 THEN
745:
746: x_return_status := G_RET_STS_ERROR;
747: RAISE FND_API.G_EXC_ERROR;
748: END IF;
749:
750: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
751: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Leaving set_clm_udv');

Line 755: WHEN FND_API.G_EXC_ERROR THEN

751: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Leaving set_clm_udv');
752: END IF;
753:
754: EXCEPTION
755: WHEN FND_API.G_EXC_ERROR THEN
756:
757: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
758: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving set_clm_udv : OKC_API.G_EXCEPTION_ERROR Exception');
759: END IF;

Line 768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

764:
765: x_return_status := G_RET_STS_ERROR ;
766: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
767:
768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
769:
770: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
771: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2000: Leaving set_clm_udv : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
772: END IF;

Line 810: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

806: ---------------------------------------------------
807:
808: PROCEDURE GET_DEFAULT_SCN_CODE (
809: p_api_version IN NUMBER,
810: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
811: p_article_id IN NUMBER,
812: p_article_version_id IN NUMBER,
813: p_doc_id IN NUMBER,
814: p_doc_type IN VARCHAR2,

Line 991: p_only_doc_variables => FND_API.G_FALSE,

987: x_msg_data => l_msg_data,
988: x_msg_count => l_msg_count,
989: p_doc_type => l_doc_type,
990: p_doc_id => p_doc_id,
991: p_only_doc_variables => FND_API.G_FALSE,
992: x_sys_var_value_tbl => l_sys_var_value_tbl);
993:
994:
995: --for results table, get default_scn_code from okc_art_var_sections

Line 1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1057:
1058: END IF; --l_return if condn
1059: --- If any errors happen abort API
1060: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1062: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1063: RAISE FND_API.G_EXC_ERROR;
1064: END IF;
1065: x_default_scn_code := l_def_scn_code;

Line 1063: RAISE FND_API.G_EXC_ERROR;

1059: --- If any errors happen abort API
1060: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1062: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1063: RAISE FND_API.G_EXC_ERROR;
1064: END IF;
1065: x_default_scn_code := l_def_scn_code;
1066:
1067: END get_default_scn_code;

Line 1075: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1071: ---------------------------------------------------
1072:
1073: PROCEDURE get_system_variables (
1074: p_api_version IN NUMBER,
1075: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1076: x_return_status OUT NOCOPY VARCHAR2,
1077: x_msg_data OUT NOCOPY VARCHAR2,
1078: x_msg_count OUT NOCOPY NUMBER,
1079: p_doc_type IN VARCHAR2,

Line 1081: p_only_doc_variables IN VARCHAR2 := FND_API.G_TRUE,

1077: x_msg_data OUT NOCOPY VARCHAR2,
1078: x_msg_count OUT NOCOPY NUMBER,
1079: p_doc_type IN VARCHAR2,
1080: p_doc_id IN NUMBER,
1081: p_only_doc_variables IN VARCHAR2 := FND_API.G_TRUE,
1082: x_sys_var_value_tbl OUT NOCOPY okc_xprt_xrule_values_pvt.var_value_tbl_type
1083: )
1084: IS
1085: l_api_name VARCHAR2(30) := 'get_system_variables';

Line 1205: WHEN FND_API.G_EXC_ERROR THEN

1201: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1100: Leaving clm_remove_dup_scn_art No Data in Source');
1202: END IF;
1203: null;
1204:
1205: WHEN FND_API.G_EXC_ERROR THEN
1206:
1207: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1208: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving clm_remove_dup_scn_art: OKC_API.G_EXCEPTION_ERROR Exception');
1209: END IF;

Line 1313: WHEN FND_API.G_EXC_ERROR THEN

1309: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1100: Leaving clm_remove_dup_articles No Data in Source');
1310: END IF;
1311: null;
1312:
1313: WHEN FND_API.G_EXC_ERROR THEN
1314:
1315: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1316: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving clm_remove_dup_articles: OKC_API.G_EXCEPTION_ERROR Exception');
1317: END IF;

Line 1653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1649: p_document_id => p_document_id,
1650: p_object_version_number => p_object_version_number
1651: );
1652: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1654: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1655: RAISE FND_API.G_EXC_ERROR;
1656: END IF;
1657:

Line 1655: RAISE FND_API.G_EXC_ERROR;

1651: );
1652: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1654: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1655: RAISE FND_API.G_EXC_ERROR;
1656: END IF;
1657:
1658: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1659: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Removing rows');

Line 1665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1661:
1662: DELETE FROM OKC_MLP_TEMPLATE_USAGES WHERE DOCUMENT_TYPE = p_document_type AND DOCUMENT_ID = p_document_id;
1663:
1664: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1666: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1667: RAISE FND_API.G_EXC_ERROR;
1668: END IF;
1669:

Line 1667: RAISE FND_API.G_EXC_ERROR;

1663:
1664: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1666: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1667: RAISE FND_API.G_EXC_ERROR;
1668: END IF;
1669:
1670: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1671: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: Leaving Delete_Row');

Line 1675: WHEN FND_API.G_EXC_ERROR THEN

1671: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: Leaving Delete_Row');
1672: END IF;
1673:
1674: EXCEPTION
1675: WHEN FND_API.G_EXC_ERROR THEN
1676: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1677: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Delete_Usages_Row:FND_API.G_EXC_ERROR Exception');
1678: END IF;
1679: x_return_status := G_RET_STS_ERROR;

Line 1677: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Delete_Usages_Row:FND_API.G_EXC_ERROR Exception');

1673:
1674: EXCEPTION
1675: WHEN FND_API.G_EXC_ERROR THEN
1676: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1677: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Delete_Usages_Row:FND_API.G_EXC_ERROR Exception');
1678: END IF;
1679: x_return_status := G_RET_STS_ERROR;
1680:
1681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1677: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Delete_Usages_Row:FND_API.G_EXC_ERROR Exception');
1678: END IF;
1679: x_return_status := G_RET_STS_ERROR;
1680:
1681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1682: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1683: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Delete_Usages_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1684: END IF;
1685: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1683: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Delete_Usages_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

1679: x_return_status := G_RET_STS_ERROR;
1680:
1681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1682: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1683: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Delete_Usages_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1684: END IF;
1685: x_return_status := G_RET_STS_UNEXP_ERROR;
1686:
1687: WHEN OTHERS THEN

Line 1733: WHEN FND_API.G_EXC_ERROR THEN

1729:
1730: RETURN l_template_exists;
1731:
1732: EXCEPTION
1733: WHEN FND_API.G_EXC_ERROR THEN
1734: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1735: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving check_dup_templates:FND_API.G_EXC_ERROR Exception');
1736: END IF;
1737: --x_return_status := G_RET_STS_ERROR;

Line 1735: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving check_dup_templates:FND_API.G_EXC_ERROR Exception');

1731:
1732: EXCEPTION
1733: WHEN FND_API.G_EXC_ERROR THEN
1734: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1735: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving check_dup_templates:FND_API.G_EXC_ERROR Exception');
1736: END IF;
1737: --x_return_status := G_RET_STS_ERROR;
1738:
1739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1735: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving check_dup_templates:FND_API.G_EXC_ERROR Exception');
1736: END IF;
1737: --x_return_status := G_RET_STS_ERROR;
1738:
1739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1740: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1741: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving check_dup_templates:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1742: END IF;
1743: --x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1741: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving check_dup_templates:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

1737: --x_return_status := G_RET_STS_ERROR;
1738:
1739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1740: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1741: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving check_dup_templates:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1742: END IF;
1743: --x_return_status := G_RET_STS_UNEXP_ERROR;
1744:
1745: WHEN OTHERS THEN

Line 1895: WHEN FND_API.G_EXC_ERROR THEN

1891: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'600: Leaving copy_usages_row '||x_return_status);
1892: END IF;
1893:
1894: EXCEPTION
1895: WHEN FND_API.G_EXC_ERROR THEN
1896: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1897: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving copy_usages_row:FND_API.G_EXC_ERROR Exception');
1898: END IF;
1899: x_return_status := G_RET_STS_ERROR;

Line 1897: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving copy_usages_row:FND_API.G_EXC_ERROR Exception');

1893:
1894: EXCEPTION
1895: WHEN FND_API.G_EXC_ERROR THEN
1896: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1897: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving copy_usages_row:FND_API.G_EXC_ERROR Exception');
1898: END IF;
1899: x_return_status := G_RET_STS_ERROR;
1900:
1901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1897: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving copy_usages_row:FND_API.G_EXC_ERROR Exception');
1898: END IF;
1899: x_return_status := G_RET_STS_ERROR;
1900:
1901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1902: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1903: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving copy_usages_row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1904: END IF;
1905: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1903: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving copy_usages_row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

1899: x_return_status := G_RET_STS_ERROR;
1900:
1901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1902: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1903: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving copy_usages_row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1904: END IF;
1905: x_return_status := G_RET_STS_UNEXP_ERROR;
1906:
1907: WHEN OTHERS THEN