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

Line 15: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;

11: ------------------------------------------------------------------------------
12: -- GLOBAL CONSTANTS
13: ------------------------------------------------------------------------------
14:
15: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
16: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
17: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
18:
19: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';

Line 16: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;

12: -- GLOBAL CONSTANTS
13: ------------------------------------------------------------------------------
14:
15: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
16: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
17: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
18:
19: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
20: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';

Line 17: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

13: ------------------------------------------------------------------------------
14:
15: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
16: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
17: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
18:
19: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
20: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
21: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';

Line 142: RAISE FND_API.G_EXC_ERROR ;

138: END IF;
139:
140: If p_number > 3999 then
141: OKC_API.SET_MESSAGE('OKC','OKC_CANT_CONVERT_ROMAN');
142: RAISE FND_API.G_EXC_ERROR ;
143:
144: end if;
145:
146: thousand := floor(p_number/1000);

Line 236: WHEN FND_API.G_EXC_ERROR THEN

232:
233: return out_roman;
234:
235: EXCEPTION
236: WHEN FND_API.G_EXC_ERROR THEN
237: /*IF (l_debug = 'Y') THEN
238: okc_debug.log('300: Leaving convert_to_roman: OKC_API.G_EXCEPTION_ERROR Exception', 2);
239: END IF;*/
240:

Line 249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

245:
246: raise;
247:
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: /*IF (l_debug = 'Y') THEN
251: okc_debug.log('400: Leaving convert_to_roman: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
252: END IF;*/
253:

Line 367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

363: return l_number;
364:
365: EXCEPTION
366:
367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
368: /*IF (l_debug = 'Y') THEN
369: okc_debug.log('400: Leaving get_numbering_seq: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
370: END IF;*/
371:

Line 527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

523: END IF;
524:
525: EXCEPTION
526:
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: /*IF (l_debug = 'Y') THEN
529: okc_debug.log('400: Leaving section_numbering: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
530: END IF;*/
531:

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

594: -- Standard Start of API savepoint
595: SAVEPOINT g_generate_preview;
596:
597: -- Standard call to check for call compatibility.
598: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
600: END IF;
601: -- Initialize message list if p_init_msg_list is set to TRUE.
602: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

595: SAVEPOINT g_generate_preview;
596:
597: -- Standard call to check for call compatibility.
598: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
600: END IF;
601: -- Initialize message list if p_init_msg_list is set to TRUE.
602: IF FND_API.to_Boolean( p_init_msg_list ) THEN
603: FND_MSG_PUB.initialize;

Line 602: IF FND_API.to_Boolean( p_init_msg_list ) THEN

598: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
600: END IF;
601: -- Initialize message list if p_init_msg_list is set to TRUE.
602: IF FND_API.to_Boolean( p_init_msg_list ) THEN
603: FND_MSG_PUB.initialize;
604: END IF;
605: -- Initialize API return status to success
606: x_return_status := G_RET_STS_SUCCESS;

Line 633: IF p_update_db=FND_API.G_TRUE THEN

629: END LOOP;
630: END LOOP;
631: x_out_string := l_out;
632:
633: IF p_update_db=FND_API.G_TRUE THEN
634:
635: Update OKC_NUMBER_SCHEMES_B SET
636: num_scheme_preview = x_out_string,
637: object_version_number = object_version_number+1,

Line 658: WHEN FND_API.G_EXC_ERROR THEN

654: G_PKG_NAME, '300: Leaving generate_preview' );
655: END IF;
656:
657: EXCEPTION
658: WHEN FND_API.G_EXC_ERROR THEN
659: /*IF (l_debug = 'Y') THEN
660: okc_debug.log('2400: Leaving generate_preview: OKC_API.G_EXCEPTION_ERROR Exception', 2);
661: END IF;*/
662:

Line 672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

668: Rollback to g_generate_preview;
669: x_return_status := G_RET_STS_ERROR ;
670: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
671:
672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
673: /*IF (l_debug = 'Y') THEN
674: okc_debug.log('2400: Leaving generate_preview: OKC_API.G_EXCEPTION_ERROR Exception', 2);
675: END IF;*/
676:

Line 713: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,

709:
710: x_return_status OUT NOCOPY VARCHAR2,
711: x_msg_count OUT NOCOPY NUMBER,
712: x_msg_data OUT NOCOPY VARCHAR2,
713: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
714: p_validation_string IN VARCHAR2,
715: p_commit IN VARCHAR2 := FND_API.G_FALSE,
716: p_doc_type IN VARCHAR2,
717: p_doc_id IN NUMBER,

Line 715: p_commit IN VARCHAR2 := FND_API.G_FALSE,

711: x_msg_count OUT NOCOPY NUMBER,
712: x_msg_data OUT NOCOPY VARCHAR2,
713: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
714: p_validation_string IN VARCHAR2,
715: p_commit IN VARCHAR2 := FND_API.G_FALSE,
716: p_doc_type IN VARCHAR2,
717: p_doc_id IN NUMBER,
718: p_num_scheme_id IN NUMBER
719: ) IS

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

806:
807: -- Standard Start of API savepoint
808: SAVEPOINT g_apply_numbering_scheme;
809: -- Standard call to check for call compatibility.
810: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
812: END IF;
813: -- Initialize message list if p_init_msg_list is set to TRUE.
814: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

807: -- Standard Start of API savepoint
808: SAVEPOINT g_apply_numbering_scheme;
809: -- Standard call to check for call compatibility.
810: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
812: END IF;
813: -- Initialize message list if p_init_msg_list is set to TRUE.
814: IF FND_API.to_Boolean( p_init_msg_list ) THEN
815: FND_MSG_PUB.initialize;

Line 814: IF FND_API.to_Boolean( p_init_msg_list ) THEN

810: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
812: END IF;
813: -- Initialize message list if p_init_msg_list is set to TRUE.
814: IF FND_API.to_Boolean( p_init_msg_list ) THEN
815: FND_MSG_PUB.initialize;
816: END IF;
817:
818: IF FND_API.To_Boolean( p_validate_commit ) THEN

Line 818: IF FND_API.To_Boolean( p_validate_commit ) THEN

814: IF FND_API.to_Boolean( p_init_msg_list ) THEN
815: FND_MSG_PUB.initialize;
816: END IF;
817:
818: IF FND_API.To_Boolean( p_validate_commit ) THEN
819:
820: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
821: p_api_version => l_api_version,
822: p_init_msg_list => FND_API.G_FALSE,

Line 820: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (

816: END IF;
817:
818: IF FND_API.To_Boolean( p_validate_commit ) THEN
819:
820: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
821: p_api_version => l_api_version,
822: p_init_msg_list => FND_API.G_FALSE,
823: p_doc_type => p_doc_type,
824: p_doc_id => p_doc_id,

Line 822: p_init_msg_list => FND_API.G_FALSE,

818: IF FND_API.To_Boolean( p_validate_commit ) THEN
819:
820: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
821: p_api_version => l_api_version,
822: p_init_msg_list => FND_API.G_FALSE,
823: p_doc_type => p_doc_type,
824: p_doc_id => p_doc_id,
825: p_validation_string => p_validation_string,
826: x_return_status => x_return_status,

Line 838: RAISE FND_API.G_EXC_ERROR ;

834: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
835: FND_LOG.STRING(G_PROC_LEVEL,
836: G_PKG_NAME, '110: Issue with document header Record.Cannot commit' );
837: END IF;
838: RAISE FND_API.G_EXC_ERROR ;
839: END IF;
840: END IF;
841:
842: -- Initialize API return status to success

Line 843: x_return_status := FND_API.G_RET_STS_SUCCESS;

839: END IF;
840: END IF;
841:
842: -- Initialize API return status to success
843: x_return_status := FND_API.G_RET_STS_SUCCESS;
844:
845: -- if Count of Numbering Scheme Detail is 0 , then this is the no numbering scheme
846: -- in this case we need to remove the label from sections and articles table
847: OPEN l_get_dtl_count;

Line 883: raise FND_API.G_EXC_UNEXPECTED_ERROR;

879:
880: OPEN l_get_num_scheme ;
881: FETCH l_get_num_scheme INTO l_number_article_yn ;
882: IF l_get_num_scheme%NOTFOUND THEN
883: raise FND_API.G_EXC_UNEXPECTED_ERROR;
884: END IF;
885: CLOSE l_get_num_scheme ;
886:
887: /*IF (l_debug = 'Y') THEN

Line 1061: p_init_msg_list => FND_API.G_FALSE,

1057: END IF;
1058:
1059: OKC_TERMS_SECTIONS_GRP.update_section(
1060: p_api_version => 1,
1061: p_init_msg_list => FND_API.G_FALSE,
1062: p_mode => 'NORMAL',
1063: x_return_status => x_return_status,
1064: x_msg_count => x_msg_count,
1065: x_msg_data => x_msg_data,

Line 1081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1077: G_PKG_NAME, '170: After Calling OKC_TERMS_SECTIONS_GRP.update_section x_return_status : '||x_return_status );
1078: END IF;
1079:
1080: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1082: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1083: RAISE FND_API.G_EXC_ERROR ;
1084: END IF;
1085: ELSIF l_structure_tbl(k).type ='ARTICLE' THEN

Line 1083: RAISE FND_API.G_EXC_ERROR ;

1079:
1080: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1082: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1083: RAISE FND_API.G_EXC_ERROR ;
1084: END IF;
1085: ELSIF l_structure_tbl(k).type ='ARTICLE' THEN
1086:
1087: /*IF (l_debug = 'Y') THEN

Line 1104: p_init_msg_list => FND_API.G_FALSE,

1100: END IF;
1101:
1102: OKC_K_ARTICLES_GRP.update_article(
1103: p_api_version => 1,
1104: p_init_msg_list => FND_API.G_FALSE,
1105: p_mode => 'NORMAL',
1106: x_return_status => x_return_status,
1107: x_msg_count => x_msg_count,
1108: x_msg_data => x_msg_data,

Line 1123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1119: G_PKG_NAME, '180: After Calling OKC_TERMS_SECTIONS_GRP.update_section x_return_status : '||x_return_status );
1120: END IF;
1121:
1122: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1124: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1125: RAISE FND_API.G_EXC_ERROR ;
1126: END IF;
1127: END IF;

Line 1125: RAISE FND_API.G_EXC_ERROR ;

1121:
1122: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1124: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1125: RAISE FND_API.G_EXC_ERROR ;
1126: END IF;
1127: END IF;
1128: END LOOP;
1129: END IF; -- l_structure_tbl.count > 0

Line 1137: p_init_msg_list => FND_API.G_FALSE,

1133: -- if any articles are already numbered, make label to null
1134: FOR cr in l_get_art_csr LOOP
1135: OKC_K_ARTICLES_GRP.update_article(
1136: p_api_version => 1,
1137: p_init_msg_list => FND_API.G_FALSE,
1138: p_mode => 'NORMAL',
1139: x_return_status => x_return_status,
1140: x_msg_count => x_msg_count,
1141: x_msg_data => x_msg_data,

Line 1148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1144: p_object_version_number => cr.object_version_number
1145: );
1146:
1147: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1149: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1150: RAISE FND_API.G_EXC_ERROR ;
1151: END IF;
1152:

Line 1150: RAISE FND_API.G_EXC_ERROR ;

1146:
1147: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1149: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1150: RAISE FND_API.G_EXC_ERROR ;
1151: END IF;
1152:
1153: END LOOP;
1154: END IF; -- l_number_article_yn <>'Y'

Line 1179: p_init_msg_list => FND_API.G_FALSE,

1175: END IF;
1176:
1177: OKC_TERMS_TEMPLATES_GRP.update_template(
1178: p_api_version => 1,
1179: p_init_msg_list => FND_API.G_FALSE,
1180: x_return_status => x_return_status,
1181: x_msg_count => x_msg_count,
1182: x_msg_data => x_msg_data,
1183: p_template_name => NULL,

Line 1212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1208: G_PKG_NAME, '300: After Call to OKC_TERMS_TEMPLATES_GRP.update_template x_return_status : '||x_return_status );
1209: END IF;
1210:
1211: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1213: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1214: RAISE FND_API.G_EXC_ERROR ;
1215: END IF;
1216:

Line 1214: RAISE FND_API.G_EXC_ERROR ;

1210:
1211: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1213: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1214: RAISE FND_API.G_EXC_ERROR ;
1215: END IF;
1216:
1217:
1218: ELSE

Line 1233: p_init_msg_list => FND_API.G_FALSE,

1229: END IF;
1230:
1231: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
1232: p_api_version =>1,
1233: p_init_msg_list => FND_API.G_FALSE,
1234: x_return_status => x_return_status,
1235: x_msg_count => x_msg_count,
1236: x_msg_data => x_msg_data,
1237: p_document_type => p_doc_type,

Line 1259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1255: G_PKG_NAME, '400: After Call to OKC_TEMPLATE_USAGES_GRP.update_template_usages x_return_status : '||x_return_status );
1256: END IF;
1257:
1258: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1260: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1261: RAISE FND_API.G_EXC_ERROR ;
1262: END IF;
1263: EXIT;

Line 1261: RAISE FND_API.G_EXC_ERROR ;

1257:
1258: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1260: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1261: RAISE FND_API.G_EXC_ERROR ;
1262: END IF;
1263: EXIT;
1264: END LOOP;
1265: END IF;

Line 1268: IF FND_API.To_Boolean( p_commit ) THEN

1264: END LOOP;
1265: END IF;
1266:
1267: -- Standard check of p_commit
1268: IF FND_API.To_Boolean( p_commit ) THEN
1269: COMMIT WORK;
1270: END IF;
1271: -- Standard call to get message count and if count is 1, get message info.
1272: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 1283: WHEN FND_API.G_EXC_ERROR THEN

1279: FND_LOG.STRING(G_PROC_LEVEL,
1280: G_PKG_NAME, '2000: Leaving apply_numbering_scheme' );
1281: END IF;
1282: EXCEPTION
1283: WHEN FND_API.G_EXC_ERROR THEN
1284: /*IF (l_debug = 'Y') THEN
1285: okc_debug.log('2400: Leaving apply_numbering_scheme: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1286: END IF;*/
1287:

Line 1297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1293: ROLLBACK TO g_apply_numbering_scheme;
1294: x_return_status := G_RET_STS_ERROR ;
1295: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1296:
1297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1298: /*IF (l_debug = 'Y') THEN
1299: okc_debug.log('2400: Leaving apply_numbering_scheme: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1300: END IF;*/
1301:

Line 1483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1479: END IF;
1480:
1481: EXCEPTION
1482:
1483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1484:
1485: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1486: FND_LOG.STRING(G_EXCP_LEVEL,
1487: G_PKG_NAME, '400: Leaving review_section_numbering: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

Line 1510: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,

1506:
1507: x_return_status OUT NOCOPY VARCHAR2,
1508: x_msg_count OUT NOCOPY NUMBER,
1509: x_msg_data OUT NOCOPY VARCHAR2,
1510: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
1511: p_validation_string IN VARCHAR2,
1512: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1513: p_doc_type IN VARCHAR2,
1514: p_doc_id IN NUMBER,

Line 1512: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1508: x_msg_count OUT NOCOPY NUMBER,
1509: x_msg_data OUT NOCOPY VARCHAR2,
1510: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
1511: p_validation_string IN VARCHAR2,
1512: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1513: p_doc_type IN VARCHAR2,
1514: p_doc_id IN NUMBER,
1515: p_num_scheme_id IN NUMBER
1516: ) IS

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

1593:
1594: -- Standard Start of API savepoint
1595: SAVEPOINT g_apply_num_scheme_4_Review;
1596: -- Standard call to check for call compatibility.
1597: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1599: END IF;
1600: -- Initialize message list if p_init_msg_list is set to TRUE.
1601: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1594: -- Standard Start of API savepoint
1595: SAVEPOINT g_apply_num_scheme_4_Review;
1596: -- Standard call to check for call compatibility.
1597: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1599: END IF;
1600: -- Initialize message list if p_init_msg_list is set to TRUE.
1601: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1602: FND_MSG_PUB.initialize;

Line 1601: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1597: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1599: END IF;
1600: -- Initialize message list if p_init_msg_list is set to TRUE.
1601: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1602: FND_MSG_PUB.initialize;
1603: END IF;
1604:
1605: IF FND_API.To_Boolean( p_validate_commit ) THEN

Line 1605: IF FND_API.To_Boolean( p_validate_commit ) THEN

1601: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1602: FND_MSG_PUB.initialize;
1603: END IF;
1604:
1605: IF FND_API.To_Boolean( p_validate_commit ) THEN
1606:
1607: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
1608: p_api_version => l_api_version,
1609: p_init_msg_list => FND_API.G_FALSE,

Line 1607: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (

1603: END IF;
1604:
1605: IF FND_API.To_Boolean( p_validate_commit ) THEN
1606:
1607: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
1608: p_api_version => l_api_version,
1609: p_init_msg_list => FND_API.G_FALSE,
1610: p_doc_type => p_doc_type,
1611: p_doc_id => p_doc_id,

Line 1609: p_init_msg_list => FND_API.G_FALSE,

1605: IF FND_API.To_Boolean( p_validate_commit ) THEN
1606:
1607: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
1608: p_api_version => l_api_version,
1609: p_init_msg_list => FND_API.G_FALSE,
1610: p_doc_type => p_doc_type,
1611: p_doc_id => p_doc_id,
1612: p_validation_string => p_validation_string,
1613: x_return_status => x_return_status,

Line 1621: RAISE FND_API.G_EXC_ERROR ;

1617: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1618: FND_LOG.STRING(G_PROC_LEVEL,
1619: G_PKG_NAME, '110: Issue with document header Record.Cannot commit' );
1620: END IF;
1621: RAISE FND_API.G_EXC_ERROR ;
1622: END IF;
1623: END IF;
1624:
1625: -- Initialize API return status to success

Line 1626: x_return_status := FND_API.G_RET_STS_SUCCESS;

1622: END IF;
1623: END IF;
1624:
1625: -- Initialize API return status to success
1626: x_return_status := FND_API.G_RET_STS_SUCCESS;
1627:
1628: -- if Count of Numbering Scheme Detail is 0 , then this is the no numbering scheme
1629: -- in this case we need to remove the label from sections and articles table
1630: OPEN l_get_dtl_count;

Line 1652: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1648:
1649: OPEN l_get_num_scheme ;
1650: FETCH l_get_num_scheme INTO l_number_article_yn ;
1651: IF l_get_num_scheme%NOTFOUND THEN
1652: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1653: END IF;
1654: CLOSE l_get_num_scheme ;
1655:
1656:

Line 1802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1798: G_PKG_NAME, '170: After Calling OKC_REVIEW_UPLD_TERMS_PVT.update_row x_return_status : '||x_return_status );
1799: END IF;
1800:
1801: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1803: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1804: RAISE FND_API.G_EXC_ERROR ;
1805: END IF;
1806: END LOOP;

Line 1804: RAISE FND_API.G_EXC_ERROR ;

1800:
1801: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1803: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1804: RAISE FND_API.G_EXC_ERROR ;
1805: END IF;
1806: END LOOP;
1807: END IF; -- l_review_tbl.count > 0
1808: END IF; -- detail count is 0 i.e no numbering scheme

Line 1811: IF FND_API.To_Boolean( p_commit ) THEN

1807: END IF; -- l_review_tbl.count > 0
1808: END IF; -- detail count is 0 i.e no numbering scheme
1809:
1810: -- Standard check of p_commit
1811: IF FND_API.To_Boolean( p_commit ) THEN
1812: COMMIT WORK;
1813: END IF;
1814: -- Standard call to get message count and if count is 1, get message info.
1815: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 1824: WHEN FND_API.G_EXC_ERROR THEN

1820: G_PKG_NAME, '2000: Leaving apply_num_scheme_4_Review' );
1821: END IF;
1822:
1823: EXCEPTION
1824: WHEN FND_API.G_EXC_ERROR THEN
1825:
1826: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1827: FND_LOG.STRING(G_EXCP_LEVEL,
1828: G_PKG_NAME, '2400: Leaving apply_num_scheme_4_Review: OKC_API.G_EXCEPTION_ERROR Exception' );

Line 1835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1831: ROLLBACK TO g_apply_num_scheme_4_Review;
1832: x_return_status := G_RET_STS_ERROR ;
1833: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1834:
1835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1836:
1837: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1838: FND_LOG.STRING(G_EXCP_LEVEL,
1839: G_PKG_NAME, '2400: Leaving apply_num_scheme_4_Review: OKC_API.G_EXCEPTION_ERROR Exception' );