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

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

14:
15: ------------------------------------------------------------------------------
16: -- GLOBAL CONSTANTS
17: ------------------------------------------------------------------------------
18: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
19: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
20: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
21: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
22: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

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

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

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

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

18: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
19: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
20: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
21: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
22: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
23: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
24: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
25: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
26: G_AMEND_CODE_ADDED CONSTANT VARCHAR2(30) := 'ADDED';

Line 29: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;

25: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
26: G_AMEND_CODE_ADDED CONSTANT VARCHAR2(30) := 'ADDED';
27: G_AMEND_CODE_UPDATED CONSTANT VARCHAR2(30) := 'UPDATED';
28:
29: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
30: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
31: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
32:
33: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 30: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;

26: G_AMEND_CODE_ADDED CONSTANT VARCHAR2(30) := 'ADDED';
27: G_AMEND_CODE_UPDATED CONSTANT VARCHAR2(30) := 'UPDATED';
28:
29: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
30: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
31: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
32:
33: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 31: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;

27: G_AMEND_CODE_UPDATED CONSTANT VARCHAR2(30) := 'UPDATED';
28:
29: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
30: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
31: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
32:
33: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;

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

106:
107: -- Standard Start of API savepoint
108: SAVEPOINT g_create_non_std_article_GRP;
109: -- Standard call to check for call compatibility.
110: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: END IF;
113: -- Initialize message list if p_init_msg_list is set to TRUE.
114: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

107: -- Standard Start of API savepoint
108: SAVEPOINT g_create_non_std_article_GRP;
109: -- Standard call to check for call compatibility.
110: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: END IF;
113: -- Initialize message list if p_init_msg_list is set to TRUE.
114: IF FND_API.to_Boolean( p_init_msg_list ) THEN
115: FND_MSG_PUB.initialize;

Line 114: IF FND_API.to_Boolean( p_init_msg_list ) THEN

110: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: END IF;
113: -- Initialize message list if p_init_msg_list is set to TRUE.
114: IF FND_API.to_Boolean( p_init_msg_list ) THEN
115: FND_MSG_PUB.initialize;
116: END IF;
117:
118: IF FND_API.To_Boolean( p_validate_commit ) THEN

Line 118: IF FND_API.To_Boolean( p_validate_commit ) THEN

114: IF FND_API.to_Boolean( p_init_msg_list ) THEN
115: FND_MSG_PUB.initialize;
116: END IF;
117:
118: IF FND_API.To_Boolean( p_validate_commit ) THEN
119:
120: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
121: p_api_version => l_api_version,
122: p_init_msg_list => FND_API.G_FALSE,

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

116: END IF;
117:
118: IF FND_API.To_Boolean( p_validate_commit ) THEN
119:
120: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
121: p_api_version => l_api_version,
122: p_init_msg_list => FND_API.G_FALSE,
123: p_doc_type => p_doc_type,
124: p_doc_id => p_doc_id,

Line 122: p_init_msg_list => FND_API.G_FALSE,

118: IF FND_API.To_Boolean( p_validate_commit ) THEN
119:
120: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
121: p_api_version => l_api_version,
122: p_init_msg_list => FND_API.G_FALSE,
123: p_doc_type => p_doc_type,
124: p_doc_id => p_doc_id,
125: p_validation_string => p_validation_string,
126: x_return_status => x_return_status,

Line 138: RAISE FND_API.G_EXC_ERROR ;

134: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
135: FND_LOG.STRING(G_PROC_LEVEL,
136: G_PKG_NAME, '110: Issue with document header Record.Cannot commit' );
137: END IF;
138: RAISE FND_API.G_EXC_ERROR ;
139: END IF;
140: END IF;
141:
142: -- Initialize API return status to success

Line 143: x_return_status := FND_API.G_RET_STS_SUCCESS;

139: END IF;
140: END IF;
141:
142: -- Initialize API return status to success
143: x_return_status := FND_API.G_RET_STS_SUCCESS;
144:
145: /*IF (l_debug = 'Y') THEN
146: okc_debug.log('200: Creating non-std article', 2);
147: END IF;*/

Line 165: p_init_msg_list => FND_API.G_FALSE,

161:
162:
163: OKC_ARTICLES_GRP.create_article(
164: p_api_version => 1,
165: p_init_msg_list => FND_API.G_FALSE,
166: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
167: p_commit => FND_API.G_FALSE,
168: x_return_status => x_return_status,
169: x_msg_count => x_msg_count,

Line 166: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

162:
163: OKC_ARTICLES_GRP.create_article(
164: p_api_version => 1,
165: p_init_msg_list => FND_API.G_FALSE,
166: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
167: p_commit => FND_API.G_FALSE,
168: x_return_status => x_return_status,
169: x_msg_count => x_msg_count,
170: x_msg_data => x_msg_data,

Line 167: p_commit => FND_API.G_FALSE,

163: OKC_ARTICLES_GRP.create_article(
164: p_api_version => 1,
165: p_init_msg_list => FND_API.G_FALSE,
166: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
167: p_commit => FND_API.G_FALSE,
168: x_return_status => x_return_status,
169: x_msg_count => x_msg_count,
170: x_msg_data => x_msg_data,
171: p_article_title => p_article_title,

Line 212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

208: );
209:
210: --------------------------------------------
211: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
213: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
214: RAISE FND_API.G_EXC_ERROR ;
215: END IF;
216: --------------------------------------------

Line 214: RAISE FND_API.G_EXC_ERROR ;

210: --------------------------------------------
211: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
213: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
214: RAISE FND_API.G_EXC_ERROR ;
215: END IF;
216: --------------------------------------------
217:
218:

Line 241: p_init_msg_list => FND_API.G_FALSE,

237: END IF;
238:
239: OKC_K_ARTICLES_GRP.update_article(
240: p_api_version =>1,
241: p_init_msg_list => FND_API.G_FALSE,
242: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
243: p_validate_commit => FND_API.G_FALSE,
244: p_validation_string => NULL,
245: p_commit => FND_API.G_FALSE,

Line 242: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

238:
239: OKC_K_ARTICLES_GRP.update_article(
240: p_api_version =>1,
241: p_init_msg_list => FND_API.G_FALSE,
242: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
243: p_validate_commit => FND_API.G_FALSE,
244: p_validation_string => NULL,
245: p_commit => FND_API.G_FALSE,
246: p_mode => p_mode,

Line 243: p_validate_commit => FND_API.G_FALSE,

239: OKC_K_ARTICLES_GRP.update_article(
240: p_api_version =>1,
241: p_init_msg_list => FND_API.G_FALSE,
242: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
243: p_validate_commit => FND_API.G_FALSE,
244: p_validation_string => NULL,
245: p_commit => FND_API.G_FALSE,
246: p_mode => p_mode,
247: x_return_status => x_return_status,

Line 245: p_commit => FND_API.G_FALSE,

241: p_init_msg_list => FND_API.G_FALSE,
242: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
243: p_validate_commit => FND_API.G_FALSE,
244: p_validation_string => NULL,
245: p_commit => FND_API.G_FALSE,
246: p_mode => p_mode,
247: x_return_status => x_return_status,
248: x_msg_count => x_msg_count,
249: x_msg_data => x_msg_data,

Line 262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

258: p_object_version_number => NULL
259: );
260: --------------------------------------------
261: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
263: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
264: RAISE FND_API.G_EXC_ERROR ;
265: END IF;
266: --------------------------------------------

Line 264: RAISE FND_API.G_EXC_ERROR ;

260: --------------------------------------------
261: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
263: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
264: RAISE FND_API.G_EXC_ERROR ;
265: END IF;
266: --------------------------------------------
267:
268: x_cat_id := p_cat_id;

Line 290: p_init_msg_list => FND_API.G_FALSE,

286: END IF;
287:
288: OKC_TERMS_MULTIREC_GRP.create_article(
289: p_api_version =>1,
290: p_init_msg_list => FND_API.G_FALSE,
291: p_mode => p_mode,
292: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
293: p_validate_commit => FND_API.G_FALSE,
294: p_validation_string => NULL,

Line 292: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

288: OKC_TERMS_MULTIREC_GRP.create_article(
289: p_api_version =>1,
290: p_init_msg_list => FND_API.G_FALSE,
291: p_mode => p_mode,
292: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
293: p_validate_commit => FND_API.G_FALSE,
294: p_validation_string => NULL,
295: p_commit => FND_API.G_FALSE,
296: p_ref_type => p_ref_type,

Line 293: p_validate_commit => FND_API.G_FALSE,

289: p_api_version =>1,
290: p_init_msg_list => FND_API.G_FALSE,
291: p_mode => p_mode,
292: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
293: p_validate_commit => FND_API.G_FALSE,
294: p_validation_string => NULL,
295: p_commit => FND_API.G_FALSE,
296: p_ref_type => p_ref_type,
297: p_ref_id => p_ref_id,

Line 295: p_commit => FND_API.G_FALSE,

291: p_mode => p_mode,
292: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
293: p_validate_commit => FND_API.G_FALSE,
294: p_validation_string => NULL,
295: p_commit => FND_API.G_FALSE,
296: p_ref_type => p_ref_type,
297: p_ref_id => p_ref_id,
298: p_doc_type => p_doc_type,
299: p_doc_id => p_doc_id,

Line 309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

305: );
306:
307: --------------------------------------------
308: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
310: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
311: RAISE FND_API.G_EXC_ERROR ;
312: END IF;
313: --------------------------------------------

Line 311: RAISE FND_API.G_EXC_ERROR ;

307: --------------------------------------------
308: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
310: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
311: RAISE FND_API.G_EXC_ERROR ;
312: END IF;
313: --------------------------------------------
314:
315: x_cat_id := lx_kart_tbl(0).id;

Line 321: IF FND_API.To_Boolean( p_commit ) THEN

317: END IF;
318:
319:
320: -- Standard check of p_commit
321: IF FND_API.To_Boolean( p_commit ) THEN
322: COMMIT WORK;
323: END IF;
324:
325: -- Standard call to get message count and if count is 1, get message info.

Line 338: WHEN FND_API.G_EXC_ERROR THEN

334: G_PKG_NAME, '900: Leaving create_non_std_article' );
335: END IF;
336:
337: EXCEPTION
338: WHEN FND_API.G_EXC_ERROR THEN
339: /*IF (l_debug = 'Y') THEN
340: okc_debug.log('300: Leaving create_non_std_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
341: END IF;*/
342:

Line 356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

352: ROLLBACK TO g_create_non_std_article_GRP;
353: x_return_status := G_RET_STS_ERROR ;
354: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
355:
356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
357: /*IF (l_debug = 'Y') THEN
358: okc_debug.log('400: Leaving create_non_std_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
359: END IF;*/
360:

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

458:
459: -- Standard Start of API savepoint
460: SAVEPOINT g_update_non_std_article_GRP;
461: -- Standard call to check for call compatibility.
462: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465: -- Initialize message list if p_init_msg_list is set to TRUE.
466: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

459: -- Standard Start of API savepoint
460: SAVEPOINT g_update_non_std_article_GRP;
461: -- Standard call to check for call compatibility.
462: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465: -- Initialize message list if p_init_msg_list is set to TRUE.
466: IF FND_API.to_Boolean( p_init_msg_list ) THEN
467: FND_MSG_PUB.initialize;

Line 466: IF FND_API.to_Boolean( p_init_msg_list ) THEN

462: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465: -- Initialize message list if p_init_msg_list is set to TRUE.
466: IF FND_API.to_Boolean( p_init_msg_list ) THEN
467: FND_MSG_PUB.initialize;
468: END IF;
469:
470: IF FND_API.To_Boolean( p_validate_commit ) THEN

Line 470: IF FND_API.To_Boolean( p_validate_commit ) THEN

466: IF FND_API.to_Boolean( p_init_msg_list ) THEN
467: FND_MSG_PUB.initialize;
468: END IF;
469:
470: IF FND_API.To_Boolean( p_validate_commit ) THEN
471:
472: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
473: p_api_version => l_api_version,
474: p_init_msg_list => FND_API.G_FALSE,

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

468: END IF;
469:
470: IF FND_API.To_Boolean( p_validate_commit ) THEN
471:
472: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
473: p_api_version => l_api_version,
474: p_init_msg_list => FND_API.G_FALSE,
475: p_doc_type => p_doc_type,
476: p_doc_id => p_doc_id,

Line 474: p_init_msg_list => FND_API.G_FALSE,

470: IF FND_API.To_Boolean( p_validate_commit ) THEN
471:
472: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
473: p_api_version => l_api_version,
474: p_init_msg_list => FND_API.G_FALSE,
475: p_doc_type => p_doc_type,
476: p_doc_id => p_doc_id,
477: p_validation_string => p_validation_string,
478: x_return_status => x_return_status,

Line 490: RAISE FND_API.G_EXC_ERROR ;

486: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
487: FND_LOG.STRING(G_PROC_LEVEL,
488: G_PKG_NAME, '110: Issue with document header Record.Cannot commit' );
489: END IF;
490: RAISE FND_API.G_EXC_ERROR ;
491: END IF;
492: END IF;
493:
494: -- Initialize API return status to success

Line 495: x_return_status := FND_API.G_RET_STS_SUCCESS;

491: END IF;
492: END IF;
493:
494: -- Initialize API return status to success
495: x_return_status := FND_API.G_RET_STS_SUCCESS;
496:
497: /*IF (l_debug = 'Y') THEN
498: okc_debug.log('200: Updating non-std article', 2);
499: END IF;*/

Line 526: p_init_msg_list => FND_API.G_FALSE,

522: END IF;
523:
524: create_non_std_article(
525: p_api_version =>1,
526: p_init_msg_list => FND_API.G_FALSE,
527: p_validate_commit => FND_API.G_FALSE,
528: p_validation_string => NULL,
529: p_commit => FND_API.G_FALSE,
530: p_mode => p_mode,

Line 527: p_validate_commit => FND_API.G_FALSE,

523:
524: create_non_std_article(
525: p_api_version =>1,
526: p_init_msg_list => FND_API.G_FALSE,
527: p_validate_commit => FND_API.G_FALSE,
528: p_validation_string => NULL,
529: p_commit => FND_API.G_FALSE,
530: p_mode => p_mode,
531: x_return_status => x_return_status,

Line 529: p_commit => FND_API.G_FALSE,

525: p_api_version =>1,
526: p_init_msg_list => FND_API.G_FALSE,
527: p_validate_commit => FND_API.G_FALSE,
528: p_validation_string => NULL,
529: p_commit => FND_API.G_FALSE,
530: p_mode => p_mode,
531: x_return_status => x_return_status,
532: x_msg_count => x_msg_count,
533: x_msg_data => x_msg_data,

Line 554: p_init_msg_list => FND_API.G_FALSE,

550: );
551: ELSE
552: OKC_ARTICLES_GRP.update_article(
553: p_api_version => 1,
554: p_init_msg_list => FND_API.G_FALSE,
555: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
556: p_commit => FND_API.G_FALSE,
557: x_return_status => x_return_status,
558: x_msg_count => x_msg_count,

Line 555: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

551: ELSE
552: OKC_ARTICLES_GRP.update_article(
553: p_api_version => 1,
554: p_init_msg_list => FND_API.G_FALSE,
555: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
556: p_commit => FND_API.G_FALSE,
557: x_return_status => x_return_status,
558: x_msg_count => x_msg_count,
559: x_msg_data => x_msg_data,

Line 556: p_commit => FND_API.G_FALSE,

552: OKC_ARTICLES_GRP.update_article(
553: p_api_version => 1,
554: p_init_msg_list => FND_API.G_FALSE,
555: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
556: p_commit => FND_API.G_FALSE,
557: x_return_status => x_return_status,
558: x_msg_count => x_msg_count,
559: x_msg_data => x_msg_data,
560: p_article_id => l_article_id,

Line 602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

598:
599:
600: --------------------------------------------
601: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
603: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
604: RAISE FND_API.G_EXC_ERROR ;
605: END IF;
606: --------------------------------------------

Line 604: RAISE FND_API.G_EXC_ERROR ;

600: --------------------------------------------
601: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
603: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
604: RAISE FND_API.G_EXC_ERROR ;
605: END IF;
606: --------------------------------------------
607:
608:

Line 629: p_init_msg_list => FND_API.G_FALSE,

625: END IF;
626:
627: OKC_K_ARTICLES_GRP.update_article(
628: p_api_version =>1,
629: p_init_msg_list => FND_API.G_FALSE,
630: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
631: p_validate_commit => FND_API.G_FALSE,
632: p_validation_string => NULL,
633: p_commit => FND_API.G_FALSE,

Line 630: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

626:
627: OKC_K_ARTICLES_GRP.update_article(
628: p_api_version =>1,
629: p_init_msg_list => FND_API.G_FALSE,
630: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
631: p_validate_commit => FND_API.G_FALSE,
632: p_validation_string => NULL,
633: p_commit => FND_API.G_FALSE,
634: p_mode => p_mode,

Line 631: p_validate_commit => FND_API.G_FALSE,

627: OKC_K_ARTICLES_GRP.update_article(
628: p_api_version =>1,
629: p_init_msg_list => FND_API.G_FALSE,
630: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
631: p_validate_commit => FND_API.G_FALSE,
632: p_validation_string => NULL,
633: p_commit => FND_API.G_FALSE,
634: p_mode => p_mode,
635: x_return_status => x_return_status,

Line 633: p_commit => FND_API.G_FALSE,

629: p_init_msg_list => FND_API.G_FALSE,
630: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
631: p_validate_commit => FND_API.G_FALSE,
632: p_validation_string => NULL,
633: p_commit => FND_API.G_FALSE,
634: p_mode => p_mode,
635: x_return_status => x_return_status,
636: x_msg_count => x_msg_count,
637: x_msg_data => x_msg_data,

Line 647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

643: p_object_version_number => l_ovn
644: );
645: --------------------------------------------
646: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
648: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
649: RAISE FND_API.G_EXC_ERROR ;
650: END IF;
651: --------------------------------------------

Line 649: RAISE FND_API.G_EXC_ERROR ;

645: --------------------------------------------
646: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
648: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
649: RAISE FND_API.G_EXC_ERROR ;
650: END IF;
651: --------------------------------------------
652: END IF; -- IF change_nonstd_yn='Y' THEN
653:

Line 655: IF FND_API.To_Boolean( p_commit ) THEN

651: --------------------------------------------
652: END IF; -- IF change_nonstd_yn='Y' THEN
653:
654: -- Standard check of p_commit
655: IF FND_API.To_Boolean( p_commit ) THEN
656: COMMIT WORK;
657: END IF;
658:
659: -- Standard call to get message count and if count is 1, get message info.

Line 672: WHEN FND_API.G_EXC_ERROR THEN

668: G_PKG_NAME, '900: Leavingupdate_non_std_article' );
669: END IF;
670:
671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN
673: /*IF (l_debug = 'Y') THEN
674: okc_debug.log('300: Leaving update_non_std_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
675: END IF;*/
676:

Line 691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

687: ROLLBACK TO g_update_non_std_article_GRP;
688: x_return_status := G_RET_STS_ERROR ;
689: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
690:
691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
692: /*IF (l_debug = 'Y') THEN
693: okc_debug.log('400: Leavingupdate_non_std_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
694: END IF;*/
695:

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_revert_to_standard_GRP;
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_revert_to_standard_GRP;
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 (l_debug = 'Y') THEN
846: okc_debug.log('200: revert_to_standard', 2);
847: END IF;*/

Line 878: p_init_msg_list => FND_API.G_FALSE,

874:
875: /*
876: OKC_K_ARTICLES_GRP.delete_article(
877: p_api_version =>1,
878: p_init_msg_list => FND_API.G_FALSE,
879: p_validate_commit => FND_API.G_FALSE,
880: p_validation_string => NULL,
881: p_commit => FND_API.G_FALSE,
882: p_mode => p_mode, -- Other value 'AMEND'

Line 879: p_validate_commit => FND_API.G_FALSE,

875: /*
876: OKC_K_ARTICLES_GRP.delete_article(
877: p_api_version =>1,
878: p_init_msg_list => FND_API.G_FALSE,
879: p_validate_commit => FND_API.G_FALSE,
880: p_validation_string => NULL,
881: p_commit => FND_API.G_FALSE,
882: p_mode => p_mode, -- Other value 'AMEND'
883: x_return_status => x_return_status,

Line 881: p_commit => FND_API.G_FALSE,

877: p_api_version =>1,
878: p_init_msg_list => FND_API.G_FALSE,
879: p_validate_commit => FND_API.G_FALSE,
880: p_validation_string => NULL,
881: p_commit => FND_API.G_FALSE,
882: p_mode => p_mode, -- Other value 'AMEND'
883: x_return_status => x_return_status,
884: x_msg_count => x_msg_count,
885: x_msg_data => x_msg_data,

Line 900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

896: END IF;
897:
898: --------------------------------------------
899: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
901: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
902: RAISE FND_API.G_EXC_ERROR ;
903: END IF;
904: --------------------------------------------

Line 902: RAISE FND_API.G_EXC_ERROR ;

898: --------------------------------------------
899: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
901: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
902: RAISE FND_API.G_EXC_ERROR ;
903: END IF;
904: --------------------------------------------
905:
906:

Line 918: p_init_msg_list => FND_API.G_FALSE,

914: END IF;
915: /*
916: OKC_K_ARTICLES_GRP.create_article(
917: p_api_version =>1,
918: p_init_msg_list => FND_API.G_FALSE,
919: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
920: p_mode => p_mode,
921: x_return_status => x_return_status,
922: x_msg_count => x_msg_count,

Line 919: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

915: /*
916: OKC_K_ARTICLES_GRP.create_article(
917: p_api_version =>1,
918: p_init_msg_list => FND_API.G_FALSE,
919: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
920: p_mode => p_mode,
921: x_return_status => x_return_status,
922: x_msg_count => x_msg_count,
923: x_msg_data => x_msg_data,

Line 959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

955: p_ref_article_version_id => G_MISS_NUM);
956:
957: --------------------------------------------
958: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
960: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
961: RAISE FND_API.G_EXC_ERROR ;
962: END IF;
963: --------------------------------------------

Line 961: RAISE FND_API.G_EXC_ERROR ;

957: --------------------------------------------
958: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
960: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
961: RAISE FND_API.G_EXC_ERROR ;
962: END IF;
963: --------------------------------------------
964:
965:

Line 986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

982: p_variable_code => del_var_csr.variable_code,
983: p_object_version_number => del_var_csr.object_version_number);
984: --------------------------------------------
985: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
987: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
988: RAISE FND_API.G_EXC_ERROR ;
989: END IF;
990: --------------------------------------------

Line 988: RAISE FND_API.G_EXC_ERROR ;

984: --------------------------------------------
985: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
987: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
988: RAISE FND_API.G_EXC_ERROR ;
989: END IF;
990: --------------------------------------------
991: end loop;
992:

Line 1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1010: x_cat_id => l_x_cat_id,
1011: x_variable_code => l_x_variable_code);
1012: --------------------------------------------
1013: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1015: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1016: RAISE FND_API.G_EXC_ERROR ;
1017: END IF;
1018: --------------------------------------------

Line 1016: RAISE FND_API.G_EXC_ERROR ;

1012: --------------------------------------------
1013: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1015: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1016: RAISE FND_API.G_EXC_ERROR ;
1017: END IF;
1018: --------------------------------------------
1019:
1020:

Line 1024: IF FND_API.To_Boolean( p_commit ) THEN

1020:
1021: end loop;
1022:
1023: -- Standard check of p_commit
1024: IF FND_API.To_Boolean( p_commit ) THEN
1025: COMMIT WORK;
1026: END IF;
1027:
1028: -- Standard call to get message count and if count is 1, get message info.

Line 1041: WHEN FND_API.G_EXC_ERROR THEN

1037: G_PKG_NAME, '900: Leaving revert_to_standard' );
1038: END IF;
1039:
1040: EXCEPTION
1041: WHEN FND_API.G_EXC_ERROR THEN
1042: /*IF (l_debug = 'Y') THEN
1043: okc_debug.log('300: Leaving revert_to_standard: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1044: END IF;*/
1045:

Line 1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1056: ROLLBACK TO g_revert_to_standard_GRP;
1057: x_return_status := G_RET_STS_ERROR ;
1058: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1059:
1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1061: /*IF (l_debug = 'Y') THEN
1062: okc_debug.log('400: Leaving revert_to_standard: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1063: END IF;*/
1064: