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 123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 125: RAISE FND_API.G_EXC_ERROR ;

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

Line 142: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

Line 152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 154: RAISE FND_API.G_EXC_ERROR ;

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

Line 164: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 177: WHEN FND_API.G_EXC_ERROR THEN

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

Line 190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

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

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

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

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

Line 265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 268: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 272: IF FND_API.To_Boolean( p_validate_commit ) THEN

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

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

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

Line 276: p_init_msg_list => FND_API.G_FALSE,

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

Line 287: RAISE FND_API.G_EXC_ERROR ;

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

Line 293: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 331: p_init_msg_list => FND_API.G_FALSE,

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

Line 332: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

Line 333: p_validate_commit => FND_API.G_FALSE,

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

Line 335: p_commit => FND_API.G_FALSE,

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

Line 349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 351: RAISE FND_API.G_EXC_ERROR ;

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

Line 359: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 371: WHEN FND_API.G_EXC_ERROR THEN

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

Line 384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

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

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

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

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

Line 454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

450: -- Standard Start of API savepoint
451: SAVEPOINT g_update_local_var_values_GRP;
452: -- Standard call to check for call compatibility.
453: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
455: END IF;
456:
457: -- Initialize message list if p_init_msg_list is set to TRUE.
458: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 458: IF FND_API.to_Boolean( p_init_msg_list ) THEN

454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
455: END IF;
456:
457: -- Initialize message list if p_init_msg_list is set to TRUE.
458: IF FND_API.to_Boolean( p_init_msg_list ) THEN
459: FND_MSG_PUB.initialize;
460: END IF;
461:
462: IF FND_API.To_Boolean( p_validate_commit ) THEN

Line 462: IF FND_API.To_Boolean( p_validate_commit ) THEN

458: IF FND_API.to_Boolean( p_init_msg_list ) THEN
459: FND_MSG_PUB.initialize;
460: END IF;
461:
462: IF FND_API.To_Boolean( p_validate_commit ) THEN
463:
464: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
465: p_api_version => l_api_version,
466: p_init_msg_list => FND_API.G_FALSE,

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

460: END IF;
461:
462: IF FND_API.To_Boolean( p_validate_commit ) THEN
463:
464: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
465: p_api_version => l_api_version,
466: p_init_msg_list => FND_API.G_FALSE,
467: p_doc_type => p_doc_type,
468: p_doc_id => p_doc_id,

Line 466: p_init_msg_list => FND_API.G_FALSE,

462: IF FND_API.To_Boolean( p_validate_commit ) THEN
463:
464: IF NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (
465: p_api_version => l_api_version,
466: p_init_msg_list => FND_API.G_FALSE,
467: p_doc_type => p_doc_type,
468: p_doc_id => p_doc_id,
469: p_validation_string => p_validation_string,
470: x_return_status => x_return_status,

Line 477: RAISE FND_API.G_EXC_ERROR ;

473:
474: IF (l_debug = 'Y') THEN
475: okc_debug.log('110: Issue with document header Record.Cannot commit', 2);
476: END IF;
477: RAISE FND_API.G_EXC_ERROR ;
478: END IF;
479: END IF;
480:
481:

Line 483: x_return_status := FND_API.G_RET_STS_SUCCESS;

479: END IF;
480:
481:
482: -- Initialize API return status to success
483: x_return_status := FND_API.G_RET_STS_SUCCESS;
484:
485: IF (l_debug = 'Y') THEN
486: okc_debug.log('400: Updating k article record', 2);
487: END IF;

Line 494: p_init_msg_list => FND_API.G_FALSE,

490: IF p_mode='AMEND' THEN
491:
492: OKC_K_ARTICLES_GRP.update_article(
493: p_api_version =>1,
494: p_init_msg_list => FND_API.G_FALSE,
495: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
496: p_validate_commit => FND_API.G_FALSE,
497: p_validation_string => NULL,
498: p_commit => FND_API.G_FALSE,

Line 495: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

491:
492: OKC_K_ARTICLES_GRP.update_article(
493: p_api_version =>1,
494: p_init_msg_list => FND_API.G_FALSE,
495: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
496: p_validate_commit => FND_API.G_FALSE,
497: p_validation_string => NULL,
498: p_commit => FND_API.G_FALSE,
499: p_mode => p_mode,

Line 496: p_validate_commit => FND_API.G_FALSE,

492: OKC_K_ARTICLES_GRP.update_article(
493: p_api_version =>1,
494: p_init_msg_list => FND_API.G_FALSE,
495: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
496: p_validate_commit => FND_API.G_FALSE,
497: p_validation_string => NULL,
498: p_commit => FND_API.G_FALSE,
499: p_mode => p_mode,
500: x_return_status => x_return_status,

Line 498: p_commit => FND_API.G_FALSE,

494: p_init_msg_list => FND_API.G_FALSE,
495: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
496: p_validate_commit => FND_API.G_FALSE,
497: p_validation_string => NULL,
498: p_commit => FND_API.G_FALSE,
499: p_mode => p_mode,
500: x_return_status => x_return_status,
501: x_msg_count => x_msg_count,
502: x_msg_data => x_msg_data,

Line 511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

507: p_lock_terms_yn => p_lock_terms_yn
508: );
509: --------------------------------------------
510: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
512: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
513: RAISE FND_API.G_EXC_ERROR ;
514: END IF;
515: --------------------------------------------

Line 513: RAISE FND_API.G_EXC_ERROR ;

509: --------------------------------------------
510: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
512: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
513: RAISE FND_API.G_EXC_ERROR ;
514: END IF;
515: --------------------------------------------
516:
517: END IF; -- mode = AMEND

Line 546: IF FND_API.To_Boolean( p_commit ) THEN

542: END IF;
543:
544:
545: -- Standard check of p_commit
546: IF FND_API.To_Boolean( p_commit ) THEN
547: COMMIT WORK;
548: END IF;
549:
550: -- Standard call to get message count and if count is 1, get message info.

Line 558: WHEN FND_API.G_EXC_ERROR THEN

554: okc_debug.log('900: Leaving update_local_var_values', 2);
555: END IF;
556:
557: EXCEPTION
558: WHEN FND_API.G_EXC_ERROR THEN
559: IF (l_debug = 'Y') THEN
560: okc_debug.log('300: Leaving update_article_var_values: OKC_API.G_EXCEPTION_ERROR Exception', 2);
561: END IF;
562:

Line 567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

563: ROLLBACK TO g_upd_article_var_values_GRP;
564: x_return_status := G_RET_STS_ERROR ;
565: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
566:
567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
568: IF (l_debug = 'Y') THEN
569: okc_debug.log('400: Leaving update_article_var_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2
570: );
571: END IF;

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

592:
593: Procedure update_response_var_values(
594: p_api_version IN NUMBER,
595: p_init_msg_list IN VARCHAR2 ,
596: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
597: p_validation_string IN VARCHAR2,
598: p_commit IN VARCHAR2 := FND_API.G_FALSE,
599: p_mode IN VARCHAR2 :='NORMAL', -- Other value 'AMEND'
600: x_return_status OUT NOCOPY VARCHAR2,

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

594: p_api_version IN NUMBER,
595: p_init_msg_list IN VARCHAR2 ,
596: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
597: p_validation_string IN VARCHAR2,
598: p_commit IN VARCHAR2 := FND_API.G_FALSE,
599: p_mode IN VARCHAR2 :='NORMAL', -- Other value 'AMEND'
600: x_return_status OUT NOCOPY VARCHAR2,
601: x_msg_count OUT NOCOPY NUMBER,
602: x_msg_data OUT NOCOPY VARCHAR2,