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_ART_VARIABLES_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:

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

64:
65: -- Standard Start of API savepoint
66: SAVEPOINT g_upd_article_var_values_GRP;
67: -- Standard call to check for call compatibility.
68: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71: -- Initialize message list if p_init_msg_list is set to TRUE.
72: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

65: -- Standard Start of API savepoint
66: SAVEPOINT g_upd_article_var_values_GRP;
67: -- Standard call to check for call compatibility.
68: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71: -- Initialize message list if p_init_msg_list is set to TRUE.
72: IF FND_API.to_Boolean( p_init_msg_list ) THEN
73: FND_MSG_PUB.initialize;

Line 72: IF FND_API.to_Boolean( p_init_msg_list ) THEN

68: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71: -- Initialize message list if p_init_msg_list is set to TRUE.
72: IF FND_API.to_Boolean( p_init_msg_list ) THEN
73: FND_MSG_PUB.initialize;
74: END IF;
75:
76: IF FND_API.To_Boolean( p_validate_commit ) THEN

Line 76: IF FND_API.To_Boolean( p_validate_commit ) THEN

72: IF FND_API.to_Boolean( p_init_msg_list ) THEN
73: FND_MSG_PUB.initialize;
74: END IF;
75:
76: IF FND_API.To_Boolean( p_validate_commit ) THEN
77:
78: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
79: p_api_version => l_api_version,
80: p_init_msg_list => FND_API.G_FALSE,

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

74: END IF;
75:
76: IF FND_API.To_Boolean( p_validate_commit ) THEN
77:
78: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
79: p_api_version => l_api_version,
80: p_init_msg_list => FND_API.G_FALSE,
81: p_doc_type => p_doc_type,
82: p_doc_id => p_doc_id,

Line 80: p_init_msg_list => FND_API.G_FALSE,

76: IF FND_API.To_Boolean( p_validate_commit ) THEN
77:
78: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
79: p_api_version => l_api_version,
80: p_init_msg_list => FND_API.G_FALSE,
81: p_doc_type => p_doc_type,
82: p_doc_id => p_doc_id,
83: p_validation_string => p_validation_string,
84: x_return_status => x_return_status,

Line 91: RAISE FND_API.G_EXC_ERROR ;

87:
88: IF (l_debug = 'Y') THEN
89: okc_debug.log('110: Issue with document header Record.Cannot commit', 2);
90: END IF;
91: RAISE FND_API.G_EXC_ERROR ;
92: END IF;
93: END IF;
94:
95: -- Initialize API return status to success

Line 96: x_return_status := FND_API.G_RET_STS_SUCCESS;

92: END IF;
93: END IF;
94:
95: -- Initialize API return status to success
96: x_return_status := FND_API.G_RET_STS_SUCCESS;
97:
98: IF (l_debug = 'Y') THEN
99: okc_debug.log('400: Updating k article record', 2);
100: END IF;

Line 106: p_init_msg_list => FND_API.G_FALSE,

102: IF p_mode='AMEND' THEN
103:
104: OKC_K_ARTICLES_GRP.update_article(
105: p_api_version =>1,
106: p_init_msg_list => FND_API.G_FALSE,
107: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
108: p_validate_commit => FND_API.G_FALSE,
109: p_validation_string => NULL,
110: p_commit => FND_API.G_FALSE,

Line 107: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

103:
104: OKC_K_ARTICLES_GRP.update_article(
105: p_api_version =>1,
106: p_init_msg_list => FND_API.G_FALSE,
107: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
108: p_validate_commit => FND_API.G_FALSE,
109: p_validation_string => NULL,
110: p_commit => FND_API.G_FALSE,
111: p_mode => p_mode,

Line 108: p_validate_commit => FND_API.G_FALSE,

104: OKC_K_ARTICLES_GRP.update_article(
105: p_api_version =>1,
106: p_init_msg_list => FND_API.G_FALSE,
107: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
108: p_validate_commit => FND_API.G_FALSE,
109: p_validation_string => NULL,
110: p_commit => FND_API.G_FALSE,
111: p_mode => p_mode,
112: x_return_status => x_return_status,

Line 110: p_commit => FND_API.G_FALSE,

106: p_init_msg_list => FND_API.G_FALSE,
107: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
108: p_validate_commit => FND_API.G_FALSE,
109: p_validation_string => NULL,
110: p_commit => FND_API.G_FALSE,
111: p_mode => p_mode,
112: x_return_status => x_return_status,
113: x_msg_count => x_msg_count,
114: x_msg_data => x_msg_data,

Line 122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

118: p_object_version_number => NULL
119: );
120: --------------------------------------------
121: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
123: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
124: RAISE FND_API.G_EXC_ERROR ;
125: END IF;
126: --------------------------------------------

Line 124: RAISE FND_API.G_EXC_ERROR ;

120: --------------------------------------------
121: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
123: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
124: RAISE FND_API.G_EXC_ERROR ;
125: END IF;
126: --------------------------------------------
127:
128: END IF;

Line 141: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

137: okc_debug.log('700: updating article variable record ',2);
138: END IF;
139:
140: OKC_K_ART_VARIABLES_PVT.update_row(
141: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
142: x_return_status => x_return_status,
143: p_cat_id => p_cat_id,
144: p_variable_code => p_variable_code,
145: p_variable_value_id => p_variable_value_id,

Line 151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

147: p_object_version_number=>l_ovn
148: );
149: --------------------------------------------
150: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
152: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
153: RAISE FND_API.G_EXC_ERROR ;
154: END IF;
155: --------------------------------------------

Line 153: RAISE FND_API.G_EXC_ERROR ;

149: --------------------------------------------
150: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
152: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
153: RAISE FND_API.G_EXC_ERROR ;
154: END IF;
155: --------------------------------------------
156: IF (l_debug = 'Y') THEN
157: okc_debug.log('800: updated article variable record ', 2);

Line 163: IF FND_API.To_Boolean( p_commit ) THEN

159: END IF;
160: CLOSE l_get_art_var_csr;
161:
162: -- Standard check of p_commit
163: IF FND_API.To_Boolean( p_commit ) THEN
164: COMMIT WORK;
165: END IF;
166:
167: -- Standard call to get message count and if count is 1, get message info.

Line 176: WHEN FND_API.G_EXC_ERROR THEN

172: END IF;
173:
174:
175: EXCEPTION
176: WHEN FND_API.G_EXC_ERROR THEN
177: IF (l_debug = 'Y') THEN
178: okc_debug.log('300: Leaving update_article_var_values: OKC_API.G_EXCEPTION_ERROR Exception', 2);
179: END IF;
180:

Line 189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

185: ROLLBACK TO g_upd_article_var_values_GRP;
186: x_return_status := G_RET_STS_ERROR ;
187: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
188:
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: IF (l_debug = 'Y') THEN
191: okc_debug.log('400: Leavingupdate_article_var_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
192: END IF;
193:

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

222:
223: Procedure update_global_var_values(
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 ,
226: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
227: p_validation_string IN VARCHAR2,
228: p_commit IN VARCHAR2 := FND_API.G_FALSE,
229: p_mode IN VARCHAR2 :='NORMAL', -- Other value 'AMEND'
230: x_return_status OUT NOCOPY VARCHAR2,

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

224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 ,
226: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
227: p_validation_string IN VARCHAR2,
228: p_commit IN VARCHAR2 := FND_API.G_FALSE,
229: p_mode IN VARCHAR2 :='NORMAL', -- Other value 'AMEND'
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,

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

258:
259: -- Standard Start of API savepoint
260: SAVEPOINT g_update_global_var_values_GRP;
261: -- Standard call to check for call compatibility.
262: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
264: END IF;
265: -- Initialize message list if p_init_msg_list is set to TRUE.
266: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

259: -- Standard Start of API savepoint
260: SAVEPOINT g_update_global_var_values_GRP;
261: -- Standard call to check for call compatibility.
262: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
264: END IF;
265: -- Initialize message list if p_init_msg_list is set to TRUE.
266: IF FND_API.to_Boolean( p_init_msg_list ) THEN
267: FND_MSG_PUB.initialize;

Line 266: IF FND_API.to_Boolean( p_init_msg_list ) THEN

262: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
264: END IF;
265: -- Initialize message list if p_init_msg_list is set to TRUE.
266: IF FND_API.to_Boolean( p_init_msg_list ) THEN
267: FND_MSG_PUB.initialize;
268: END IF;
269:
270: IF FND_API.To_Boolean( p_validate_commit ) THEN

Line 270: IF FND_API.To_Boolean( p_validate_commit ) THEN

266: IF FND_API.to_Boolean( p_init_msg_list ) THEN
267: FND_MSG_PUB.initialize;
268: END IF;
269:
270: IF FND_API.To_Boolean( p_validate_commit ) THEN
271:
272: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
273: p_api_version => l_api_version,
274: p_init_msg_list => FND_API.G_FALSE,

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

268: END IF;
269:
270: IF FND_API.To_Boolean( p_validate_commit ) THEN
271:
272: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
273: p_api_version => l_api_version,
274: p_init_msg_list => FND_API.G_FALSE,
275: p_doc_type => p_doc_type,
276: p_doc_id => p_doc_id,

Line 274: p_init_msg_list => FND_API.G_FALSE,

270: IF FND_API.To_Boolean( p_validate_commit ) THEN
271:
272: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
273: p_api_version => l_api_version,
274: p_init_msg_list => FND_API.G_FALSE,
275: p_doc_type => p_doc_type,
276: p_doc_id => p_doc_id,
277: p_validation_string => p_validation_string,
278: x_return_status => x_return_status,

Line 285: RAISE FND_API.G_EXC_ERROR ;

281:
282: IF (l_debug = 'Y') THEN
283: okc_debug.log('110: Issue with document header Record.Cannot commit', 2);
284: END IF;
285: RAISE FND_API.G_EXC_ERROR ;
286: END IF;
287: END IF;
288:
289:

Line 291: x_return_status := FND_API.G_RET_STS_SUCCESS;

287: END IF;
288:
289:
290: -- Initialize API return status to success
291: x_return_status := FND_API.G_RET_STS_SUCCESS;
292:
293: -- Updating variable values
294:
295: UPDATE okc_k_art_variables

Line 329: p_init_msg_list => FND_API.G_FALSE,

325: FOR l_cat_rec IN l_get_cat_id_csr LOOP
326:
327: OKC_K_ARTICLES_GRP.update_article(
328: p_api_version =>1,
329: p_init_msg_list => FND_API.G_FALSE,
330: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
331: p_validate_commit => FND_API.G_FALSE,
332: p_validation_string => NULL,
333: p_commit => FND_API.G_FALSE,

Line 330: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

326:
327: OKC_K_ARTICLES_GRP.update_article(
328: p_api_version =>1,
329: p_init_msg_list => FND_API.G_FALSE,
330: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
331: p_validate_commit => FND_API.G_FALSE,
332: p_validation_string => NULL,
333: p_commit => FND_API.G_FALSE,
334: p_mode => p_mode,

Line 331: p_validate_commit => FND_API.G_FALSE,

327: OKC_K_ARTICLES_GRP.update_article(
328: p_api_version =>1,
329: p_init_msg_list => FND_API.G_FALSE,
330: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
331: p_validate_commit => FND_API.G_FALSE,
332: p_validation_string => NULL,
333: p_commit => FND_API.G_FALSE,
334: p_mode => p_mode,
335: x_return_status => x_return_status,

Line 333: p_commit => FND_API.G_FALSE,

329: p_init_msg_list => FND_API.G_FALSE,
330: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
331: p_validate_commit => FND_API.G_FALSE,
332: p_validation_string => NULL,
333: p_commit => FND_API.G_FALSE,
334: p_mode => p_mode,
335: x_return_status => x_return_status,
336: x_msg_count => x_msg_count,
337: x_msg_data => x_msg_data,

Line 346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

342: );
343:
344: --------------------------------------------
345: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
347: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
348: RAISE FND_API.G_EXC_ERROR ;
349: END IF;
350: --------------------------------------------

Line 348: RAISE FND_API.G_EXC_ERROR ;

344: --------------------------------------------
345: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
347: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
348: RAISE FND_API.G_EXC_ERROR ;
349: END IF;
350: --------------------------------------------
351:
352: END LOOP;

Line 356: IF FND_API.To_Boolean( p_commit ) THEN

352: END LOOP;
353: END IF; -- mode = AMEND
354:
355: -- Standard check of p_commit
356: IF FND_API.To_Boolean( p_commit ) THEN
357: COMMIT WORK;
358: END IF;
359:
360: -- Standard call to get message count and if count is 1, get message info.

Line 368: WHEN FND_API.G_EXC_ERROR THEN

364: okc_debug.log('900: Leaving update_global_var_values', 2);
365: END IF;
366:
367: EXCEPTION
368: WHEN FND_API.G_EXC_ERROR THEN
369: IF (l_debug = 'Y') THEN
370: okc_debug.log('300: Leaving update_article_var_values: OKC_API.G_EXCEPTION_ERROR Exception', 2);
371: END IF;
372:

Line 381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

377: ROLLBACK TO g_upd_article_var_values_GRP;
378: x_return_status := G_RET_STS_ERROR ;
379: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382: IF (l_debug = 'Y') THEN
383: okc_debug.log('400: Leaving update_article_var_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2
384: );
385: END IF;

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

415:
416: Procedure update_local_var_values(
417: p_api_version IN NUMBER,
418: p_init_msg_list IN VARCHAR2 ,
419: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
420: p_validation_string IN VARCHAR2,
421: p_commit IN VARCHAR2 := FND_API.G_FALSE,
422: p_mode IN VARCHAR2 :='NORMAL', -- Other value 'AMEND'
423: x_return_status OUT NOCOPY VARCHAR2,

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

417: p_api_version IN NUMBER,
418: p_init_msg_list IN VARCHAR2 ,
419: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
420: p_validation_string IN VARCHAR2,
421: p_commit IN VARCHAR2 := FND_API.G_FALSE,
422: p_mode IN VARCHAR2 :='NORMAL', -- Other value 'AMEND'
423: x_return_status OUT NOCOPY VARCHAR2,
424: x_msg_count OUT NOCOPY NUMBER,
425: x_msg_data OUT NOCOPY VARCHAR2,

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

444:
445: -- Standard Start of API savepoint
446: SAVEPOINT g_update_local_var_values_GRP;
447: -- Standard call to check for call compatibility.
448: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451: -- Initialize message list if p_init_msg_list is set to TRUE.
452: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

445: -- Standard Start of API savepoint
446: SAVEPOINT g_update_local_var_values_GRP;
447: -- Standard call to check for call compatibility.
448: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451: -- Initialize message list if p_init_msg_list is set to TRUE.
452: IF FND_API.to_Boolean( p_init_msg_list ) THEN
453: FND_MSG_PUB.initialize;

Line 452: IF FND_API.to_Boolean( p_init_msg_list ) THEN

448: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451: -- Initialize message list if p_init_msg_list is set to TRUE.
452: IF FND_API.to_Boolean( p_init_msg_list ) THEN
453: FND_MSG_PUB.initialize;
454: END IF;
455:
456: IF FND_API.To_Boolean( p_validate_commit ) THEN

Line 456: IF FND_API.To_Boolean( p_validate_commit ) THEN

452: IF FND_API.to_Boolean( p_init_msg_list ) THEN
453: FND_MSG_PUB.initialize;
454: END IF;
455:
456: IF FND_API.To_Boolean( p_validate_commit ) THEN
457:
458: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
459: p_api_version => l_api_version,
460: p_init_msg_list => FND_API.G_FALSE,

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

454: END IF;
455:
456: IF FND_API.To_Boolean( p_validate_commit ) THEN
457:
458: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
459: p_api_version => l_api_version,
460: p_init_msg_list => FND_API.G_FALSE,
461: p_doc_type => p_doc_type,
462: p_doc_id => p_doc_id,

Line 460: p_init_msg_list => FND_API.G_FALSE,

456: IF FND_API.To_Boolean( p_validate_commit ) THEN
457:
458: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
459: p_api_version => l_api_version,
460: p_init_msg_list => FND_API.G_FALSE,
461: p_doc_type => p_doc_type,
462: p_doc_id => p_doc_id,
463: p_validation_string => p_validation_string,
464: x_return_status => x_return_status,

Line 471: RAISE FND_API.G_EXC_ERROR ;

467:
468: IF (l_debug = 'Y') THEN
469: okc_debug.log('110: Issue with document header Record.Cannot commit', 2);
470: END IF;
471: RAISE FND_API.G_EXC_ERROR ;
472: END IF;
473: END IF;
474:
475:

Line 477: x_return_status := FND_API.G_RET_STS_SUCCESS;

473: END IF;
474:
475:
476: -- Initialize API return status to success
477: x_return_status := FND_API.G_RET_STS_SUCCESS;
478:
479: IF (l_debug = 'Y') THEN
480: okc_debug.log('400: Updating k article record', 2);
481: END IF;

Line 488: p_init_msg_list => FND_API.G_FALSE,

484: IF p_mode='AMEND' THEN
485:
486: OKC_K_ARTICLES_GRP.update_article(
487: p_api_version =>1,
488: p_init_msg_list => FND_API.G_FALSE,
489: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
490: p_validate_commit => FND_API.G_FALSE,
491: p_validation_string => NULL,
492: p_commit => FND_API.G_FALSE,

Line 489: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

485:
486: OKC_K_ARTICLES_GRP.update_article(
487: p_api_version =>1,
488: p_init_msg_list => FND_API.G_FALSE,
489: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
490: p_validate_commit => FND_API.G_FALSE,
491: p_validation_string => NULL,
492: p_commit => FND_API.G_FALSE,
493: p_mode => p_mode,

Line 490: p_validate_commit => FND_API.G_FALSE,

486: OKC_K_ARTICLES_GRP.update_article(
487: p_api_version =>1,
488: p_init_msg_list => FND_API.G_FALSE,
489: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
490: p_validate_commit => FND_API.G_FALSE,
491: p_validation_string => NULL,
492: p_commit => FND_API.G_FALSE,
493: p_mode => p_mode,
494: x_return_status => x_return_status,

Line 492: p_commit => FND_API.G_FALSE,

488: p_init_msg_list => FND_API.G_FALSE,
489: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
490: p_validate_commit => FND_API.G_FALSE,
491: p_validation_string => NULL,
492: p_commit => FND_API.G_FALSE,
493: p_mode => p_mode,
494: x_return_status => x_return_status,
495: x_msg_count => x_msg_count,
496: x_msg_data => x_msg_data,

Line 504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

500: p_object_version_number => NULL
501: );
502: --------------------------------------------
503: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
505: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
506: RAISE FND_API.G_EXC_ERROR ;
507: END IF;
508: --------------------------------------------

Line 506: RAISE FND_API.G_EXC_ERROR ;

502: --------------------------------------------
503: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
505: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
506: RAISE FND_API.G_EXC_ERROR ;
507: END IF;
508: --------------------------------------------
509:
510: END IF; -- mode = AMEND

Line 539: IF FND_API.To_Boolean( p_commit ) THEN

535: END IF;
536:
537:
538: -- Standard check of p_commit
539: IF FND_API.To_Boolean( p_commit ) THEN
540: COMMIT WORK;
541: END IF;
542:
543: -- Standard call to get message count and if count is 1, get message info.

Line 551: WHEN FND_API.G_EXC_ERROR THEN

547: okc_debug.log('900: Leaving update_local_var_values', 2);
548: END IF;
549:
550: EXCEPTION
551: WHEN FND_API.G_EXC_ERROR THEN
552: IF (l_debug = 'Y') THEN
553: okc_debug.log('300: Leaving update_article_var_values: OKC_API.G_EXCEPTION_ERROR Exception', 2);
554: END IF;
555:

Line 560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

556: ROLLBACK TO g_upd_article_var_values_GRP;
557: x_return_status := G_RET_STS_ERROR ;
558: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
559:
560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
561: IF (l_debug = 'Y') THEN
562: okc_debug.log('400: Leaving update_article_var_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2
563: );
564: END IF;

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

585:
586: Procedure update_response_var_values(
587: p_api_version IN NUMBER,
588: p_init_msg_list IN VARCHAR2 ,
589: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
590: p_validation_string IN VARCHAR2,
591: p_commit IN VARCHAR2 := FND_API.G_FALSE,
592: p_mode IN VARCHAR2 :='NORMAL', -- Other value 'AMEND'
593: x_return_status OUT NOCOPY VARCHAR2,

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

587: p_api_version IN NUMBER,
588: p_init_msg_list IN VARCHAR2 ,
589: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
590: p_validation_string IN VARCHAR2,
591: p_commit IN VARCHAR2 := FND_API.G_FALSE,
592: p_mode IN VARCHAR2 :='NORMAL', -- Other value 'AMEND'
593: x_return_status OUT NOCOPY VARCHAR2,
594: x_msg_count OUT NOCOPY NUMBER,
595: x_msg_data OUT NOCOPY VARCHAR2,