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.CSC_CORE_UTILS_PVT dependencies on FND_API

Line 22: -- 12-03-2002 jamose Added function for Fnd_Api_G_Miss* Changes

18: -- 05-04-2000 dejoseph Included procedure to gather CBO statistics on a given
19: -- table.
20: -- 02-22-2001 dejoseph Added two more plan status functions, MERGE_PLAN and
21: -- TRANSFER_PLAN for the purpose of Party Merge.
22: -- 12-03-2002 jamose Added function for Fnd_Api_G_Miss* Changes
23: -- End of Comments
24: --
25:
26: FUNCTION G_CREATE RETURN VARCHAR2 IS

Line 39: RETURN FND_API.G_MISS_NUM ;

35:
36:
37: FUNCTION G_MISS_NUM RETURN NUMBER IS
38: BEGIN
39: RETURN FND_API.G_MISS_NUM ;
40: END G_MISS_NUM ;
41:
42:
43: FUNCTION G_MISS_CHAR RETURN VARCHAR2 IS

Line 45: RETURN FND_API.G_MISS_CHAR ;

41:
42:
43: FUNCTION G_MISS_CHAR RETURN VARCHAR2 IS
44: BEGIN
45: RETURN FND_API.G_MISS_CHAR ;
46: END G_MISS_CHAR ;
47:
48:
49: FUNCTION G_MISS_DATE RETURN DATE IS

Line 51: RETURN FND_API.G_MISS_DATE ;

47:
48:
49: FUNCTION G_MISS_DATE RETURN DATE IS
50: BEGIN
51: RETURN FND_API.G_MISS_DATE ;
52: END G_MISS_DATE ;
53:
54:
55: FUNCTION G_RET_STS_SUCCESS RETURN VARCHAR2 IS

Line 57: RETURN FND_API.G_RET_STS_SUCCESS ;

53:
54:
55: FUNCTION G_RET_STS_SUCCESS RETURN VARCHAR2 IS
56: BEGIN
57: RETURN FND_API.G_RET_STS_SUCCESS ;
58: END G_RET_STS_SUCCESS ;
59:
60:
61: FUNCTION G_RET_STS_ERROR RETURN VARCHAR2 IS

Line 63: RETURN FND_API.G_RET_STS_ERROR ;

59:
60:
61: FUNCTION G_RET_STS_ERROR RETURN VARCHAR2 IS
62: BEGIN
63: RETURN FND_API.G_RET_STS_ERROR ;
64: END G_RET_STS_ERROR ;
65:
66:
67: FUNCTION G_RET_STS_UNEXP_ERROR RETURN VARCHAR2 IS

Line 69: RETURN FND_API.G_RET_STS_UNEXP_ERROR ;

65:
66:
67: FUNCTION G_RET_STS_UNEXP_ERROR RETURN VARCHAR2 IS
68: BEGIN
69: RETURN FND_API.G_RET_STS_UNEXP_ERROR ;
70: END G_RET_STS_UNEXP_ERROR ;
71:
72:
73: FUNCTION G_VALID_LEVEL_NONE RETURN NUMBER IS

Line 75: RETURN FND_API.G_VALID_LEVEL_NONE ;

71:
72:
73: FUNCTION G_VALID_LEVEL_NONE RETURN NUMBER IS
74: BEGIN
75: RETURN FND_API.G_VALID_LEVEL_NONE ;
76: END;
77:
78:
79: FUNCTION G_VALID_LEVEL_FULL RETURN NUMBER IS

Line 81: RETURN FND_API.G_VALID_LEVEL_FULL ;

77:
78:
79: FUNCTION G_VALID_LEVEL_FULL RETURN NUMBER IS
80: BEGIN
81: RETURN FND_API.G_VALID_LEVEL_FULL ;
82: END;
83:
84:
85: FUNCTION G_VALID_LEVEL_INT RETURN NUMBER IS

Line 93: return FND_API.G_TRUE ;

89:
90:
91: FUNCTION G_TRUE RETURN VARCHAR2 IS
92: BEGIN
93: return FND_API.G_TRUE ;
94: END;
95:
96:
97: FUNCTION G_FALSE RETURN VARCHAR2 IS

Line 99: return FND_API.G_FALSE ;

95:
96:
97: FUNCTION G_FALSE RETURN VARCHAR2 IS
98: BEGIN
99: return FND_API.G_FALSE ;
100: END;
101:
102: FUNCTION ENABLE_PLAN RETURN VARCHAR2 IS
103: BEGIN

Line 183: x_return_status := FND_API.G_RET_STS_ERROR;

179:
180: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || p_package_type);
181: IF p_exception_level = FND_MSG_PUB.G_MSG_LVL_ERROR
182: THEN
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: FND_MSG_PUB.Count_And_Get(
185: p_encoded => FND_API.G_FALSE,
186: p_count => x_msg_count,
187: p_data => x_msg_data);

Line 185: p_encoded => FND_API.G_FALSE,

181: IF p_exception_level = FND_MSG_PUB.G_MSG_LVL_ERROR
182: THEN
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: FND_MSG_PUB.Count_And_Get(
185: p_encoded => FND_API.G_FALSE,
186: p_count => x_msg_count,
187: p_data => x_msg_data);
188: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
189: THEN

Line 190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

186: p_count => x_msg_count,
187: p_data => x_msg_data);
188: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
189: THEN
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191: FND_MSG_PUB.Count_And_Get(
192: p_encoded => FND_API.G_FALSE,
193: p_count => x_msg_count,
194: p_data => x_msg_data);

Line 192: p_encoded => FND_API.G_FALSE,

188: ELSIF p_exception_level = FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
189: THEN
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191: FND_MSG_PUB.Count_And_Get(
192: p_encoded => FND_API.G_FALSE,
193: p_count => x_msg_count,
194: p_data => x_msg_data);
195: ELSIF p_exception_level = CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS
196: THEN

Line 197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

193: p_count => x_msg_count,
194: p_data => x_msg_data);
195: ELSIF p_exception_level = CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS
196: THEN
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: -- Insert the 'sqlerrm' into the message stack.
199: FND_MSG_PUB.BUILD_EXC_MSG (
200: p_pkg_name => p_pkg_name,
201: p_procedure_name => p_api_name );

Line 204: p_encoded => FND_API.G_FALSE,

200: p_pkg_name => p_pkg_name,
201: p_procedure_name => p_api_name );
202:
203: FND_MSG_PUB.Count_And_Get(
204: p_encoded => FND_API.G_FALSE,
205: p_count => x_msg_count,
206: p_data => x_msg_data);
207: END IF;
208: END Handle_exceptions;

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

207: END IF;
208: END Handle_exceptions;
209:
210: PROCEDURE Validate_Dates (
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_validation_mode IN VARCHAR2,
213: P_START_DATE IN DATE,
214: P_END_DATE IN DATE,
215: x_return_status OUT NOCOPY VARCHAR2,

Line 222: IF FND_API.to_Boolean( p_init_msg_list )

218:
219: IS
220: BEGIN
221: -- Initialize message list if p_init_msg_list is set to TRUE.
222: IF FND_API.to_Boolean( p_init_msg_list )
223: THEN
224: FND_MSG_PUB.initialize;
225: END IF;
226:

Line 228: x_return_status := FND_API.G_RET_STS_SUCCESS;

224: FND_MSG_PUB.initialize;
225: END IF;
226:
227: -- Initialize API return status to SUCCESS
228: x_return_status := FND_API.G_RET_STS_SUCCESS;
229:
230:
231: IF ( p_start_date > p_end_date ) then
232: fnd_message.set_name (G_APP_SHORTNAME, 'CS_ALL_START_DATE_AFTER_END');

Line 234: x_return_status := FND_API.G_RET_STS_ERROR;

230:
231: IF ( p_start_date > p_end_date ) then
232: fnd_message.set_name (G_APP_SHORTNAME, 'CS_ALL_START_DATE_AFTER_END');
233: --fnd_msg_pub.add;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: IF (p_end_date = G_MISS_DATE) THEN
236: x_return_status := FND_API.G_RET_STS_SUCCESS;
237: END IF;
238:

Line 236: x_return_status := FND_API.G_RET_STS_SUCCESS;

232: fnd_message.set_name (G_APP_SHORTNAME, 'CS_ALL_START_DATE_AFTER_END');
233: --fnd_msg_pub.add;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: IF (p_end_date = G_MISS_DATE) THEN
236: x_return_status := FND_API.G_RET_STS_SUCCESS;
237: END IF;
238:
239: END IF;
240:

Line 262: p_encoded => FND_API.G_FALSE,

258: */
259:
260: -- Standard call to get message count and if count is 1, get message info.
261: FND_MSG_PUB.Count_And_Get (
262: p_encoded => FND_API.G_FALSE,
263: p_count => x_msg_count,
264: p_data => x_msg_data);
265:
266: END Validate_dates;

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

266: END Validate_dates;
267:
268:
269: PROCEDURE Validate_Not_Nulls (
270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
271: p_validation_mode IN VARCHAR2,
272: P_COLUMN_NAME IN VARCHAR2,
273: P_COLUMN_VALUE IN VARCHAR2,
274: x_return_status OUT NOCOPY VARCHAR2,

Line 281: IF FND_API.to_Boolean( p_init_msg_list )

277: IS
278: l_api_name varchar2(30) := 'VALIDATE_NOT_NULLS';
279: BEGIN
280: -- Initialize message list if p_init_msg_list is set to TRUE.
281: IF FND_API.to_Boolean( p_init_msg_list )
282: THEN
283: FND_MSG_PUB.initialize;
284: END IF;
285:

Line 287: x_return_status := FND_API.G_RET_STS_SUCCESS;

283: FND_MSG_PUB.initialize;
284: END IF;
285:
286: -- Initialize API return status to SUCCESS
287: x_return_status := FND_API.G_RET_STS_SUCCESS;
288:
289: if (p_column_value is NULL or p_column_value = FND_API.G_MISS_CHAR ) then
290: fnd_message.set_name (G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
291: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

Line 289: if (p_column_value is NULL or p_column_value = FND_API.G_MISS_CHAR ) then

285:
286: -- Initialize API return status to SUCCESS
287: x_return_status := FND_API.G_RET_STS_SUCCESS;
288:
289: if (p_column_value is NULL or p_column_value = FND_API.G_MISS_CHAR ) then
290: fnd_message.set_name (G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
291: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
292: fnd_message.set_token('NULL_PARAM', p_column_name);
293: --fnd_msg_pub.add;

Line 294: x_return_status := FND_API.G_RET_STS_ERROR;

290: fnd_message.set_name (G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
291: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
292: fnd_message.set_token('NULL_PARAM', p_column_name);
293: --fnd_msg_pub.add;
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: end if;
296:
297: -- Standard call to get message count and if count is 1, get message info.
298: FND_MSG_PUB.Count_And_Get (

Line 299: p_encoded => FND_API.G_FALSE,

295: end if;
296:
297: -- Standard call to get message count and if count is 1, get message info.
298: FND_MSG_PUB.Count_And_Get (
299: p_encoded => FND_API.G_FALSE,
300: p_count => x_msg_count,
301: p_data => x_msg_data);
302:
303: END Validate_Not_Nulls;

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

302:
303: END Validate_Not_Nulls;
304:
305: PROCEDURE Validate_Not_Nulls (
306: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
307: p_validation_mode IN VARCHAR2,
308: P_COLUMN_NAME IN VARCHAR2,
309: P_COLUMN_VALUE IN NUMBER,
310: x_return_status OUT NOCOPY VARCHAR2,

Line 317: IF FND_API.to_Boolean( p_init_msg_list )

313: IS
314: l_api_name varchar2(30) := 'VALIDATE_NOT_NULLS';
315: BEGIN
316: -- Initialize message list if p_init_msg_list is set to TRUE.
317: IF FND_API.to_Boolean( p_init_msg_list )
318: THEN
319: FND_MSG_PUB.initialize;
320: END IF;
321:

Line 323: x_return_status := FND_API.G_RET_STS_SUCCESS;

319: FND_MSG_PUB.initialize;
320: END IF;
321:
322: -- Initialize API return status to SUCCESS
323: x_return_status := FND_API.G_RET_STS_SUCCESS;
324:
325: if (p_column_value is NULL or p_column_value = FND_API.G_MISS_NUM ) then
326: fnd_message.set_name (G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
327: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

Line 325: if (p_column_value is NULL or p_column_value = FND_API.G_MISS_NUM ) then

321:
322: -- Initialize API return status to SUCCESS
323: x_return_status := FND_API.G_RET_STS_SUCCESS;
324:
325: if (p_column_value is NULL or p_column_value = FND_API.G_MISS_NUM ) then
326: fnd_message.set_name (G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
327: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
328: fnd_message.set_token('NULL_PARAM', p_column_name);
329: --fnd_msg_pub.add;

Line 330: x_return_status := FND_API.G_RET_STS_ERROR;

326: fnd_message.set_name (G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
327: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
328: fnd_message.set_token('NULL_PARAM', p_column_name);
329: --fnd_msg_pub.add;
330: x_return_status := FND_API.G_RET_STS_ERROR;
331: end if;
332:
333: -- Standard call to get message count and if count is 1, get message info.
334: FND_MSG_PUB.Count_And_Get(

Line 335: p_encoded => FND_API.G_FALSE,

331: end if;
332:
333: -- Standard call to get message count and if count is 1, get message info.
334: FND_MSG_PUB.Count_And_Get(
335: p_encoded => FND_API.G_FALSE,
336: p_count => x_msg_count,
337: p_data => x_msg_data);
338:
339: END Validate_Not_Nulls;

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

339: END Validate_Not_Nulls;
340:
341:
342: PROCEDURE Validate_Not_Nulls (
343: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
344: p_validation_mode IN VARCHAR2,
345: P_COLUMN_NAME IN VARCHAR2,
346: P_COLUMN_VALUE IN DATE,
347: x_return_status OUT NOCOPY VARCHAR2,

Line 354: IF FND_API.to_Boolean( p_init_msg_list )

350: IS
351: l_api_name varchar2(30) := 'VALIDATE_NOT_NULLS';
352: BEGIN
353: -- Initialize message list if p_init_msg_list is set to TRUE.
354: IF FND_API.to_Boolean( p_init_msg_list )
355: THEN
356: FND_MSG_PUB.initialize;
357: END IF;
358:

Line 360: x_return_status := FND_API.G_RET_STS_SUCCESS;

356: FND_MSG_PUB.initialize;
357: END IF;
358:
359: -- Initialize API return status to SUCCESS
360: x_return_status := FND_API.G_RET_STS_SUCCESS;
361:
362: if (p_column_value is NULL or p_column_value = FND_API.G_MISS_DATE ) then
363: fnd_message.set_name (G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
364: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);

Line 362: if (p_column_value is NULL or p_column_value = FND_API.G_MISS_DATE ) then

358:
359: -- Initialize API return status to SUCCESS
360: x_return_status := FND_API.G_RET_STS_SUCCESS;
361:
362: if (p_column_value is NULL or p_column_value = FND_API.G_MISS_DATE ) then
363: fnd_message.set_name (G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
364: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
365: fnd_message.set_token('NULL_PARAM', p_column_name);
366: --fnd_msg_pub.add;

Line 367: x_return_status := FND_API.G_RET_STS_ERROR;

363: fnd_message.set_name (G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
364: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
365: fnd_message.set_token('NULL_PARAM', p_column_name);
366: --fnd_msg_pub.add;
367: x_return_status := FND_API.G_RET_STS_ERROR;
368: end if;
369:
370: -- Standard call to get message count and if count is 1, get message info.
371: FND_MSG_PUB.Count_And_Get (

Line 372: p_encoded => FND_API.G_FALSE,

368: end if;
369:
370: -- Standard call to get message count and if count is 1, get message info.
371: FND_MSG_PUB.Count_And_Get (
372: p_encoded => FND_API.G_FALSE,
373: p_count => x_msg_count,
374: p_data => x_msg_data);
375:
376: END Validate_Not_Nulls;

Line 386: x_return_status := FND_API.G_RET_STS_SUCCESS;

382: ) IS
383: --
384: BEGIN
385: --
386: x_return_status := FND_API.G_RET_STS_SUCCESS;
387:
388: -- check if the seeded flag is passed in and is not
389: -- null, if passed in check if the lookup code
390: -- exists in fnd lookups for this date, if not

Line 398: p_lookup_code => p_seeded_flag ) <> FND_API.G_RET_STS_SUCCESS

394: IF CSC_CORE_UTILS_PVT.lookup_code_not_exists(
395: p_effective_date => trunc(sysdate),
396:
397: p_lookup_type => 'YES_NO',
398: p_lookup_code => p_seeded_flag ) <> FND_API.G_RET_STS_SUCCESS
399:
400: THEN
401: x_return_status := FND_API.G_RET_STS_ERROR;
402: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(p_api_name => p_api_name,

Line 401: x_return_status := FND_API.G_RET_STS_ERROR;

397: p_lookup_type => 'YES_NO',
398: p_lookup_code => p_seeded_flag ) <> FND_API.G_RET_STS_SUCCESS
399:
400: THEN
401: x_return_status := FND_API.G_RET_STS_ERROR;
402: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(p_api_name => p_api_name,
403: p_argument_value => p_seeded_flag,
404: p_argument => 'p_Seeded_flag');
405: END IF;

Line 425: IF FND_API.to_Boolean( p_init_msg_list )

421: l_temp_id number:=0;
422:
423: BEGIN
424: -- Initialize message list if p_init_msg_list is set to TRUE.
425: IF FND_API.to_Boolean( p_init_msg_list )
426: THEN
427: FND_MSG_PUB.initialize;
428: END IF;
429:

Line 431: x_return_status := FND_API.G_RET_STS_SUCCESS;

427: FND_MSG_PUB.initialize;
428: END IF;
429:
430: -- Initialize API return status to SUCCESS
431: x_return_status := FND_API.G_RET_STS_SUCCESS;
432:
433: IF (( p_application_id <> CSC_CORE_UTILS_PVT.G_MISS_NUM ) AND
434: ( p_application_id IS NOT NULL )) THEN
435:

Line 448: x_return_status := FND_API.G_RET_STS_ERROR;

444:
445: When no_data_found then
446: fnd_message.set_name ('FND', 'CONC-INVALID APPLICATION ID');
447: fnd_message.set_token('ID', p_application_id);
448: x_return_status := FND_API.G_RET_STS_ERROR;
449:
450: When others Then
451: fnd_message.set_name ('FND', 'CONC-INVALID APPLICATION ID');
452: fnd_message.set_token('ID', p_application_id);

Line 453: x_return_status := FND_API.G_RET_STS_ERROR;

449:
450: When others Then
451: fnd_message.set_name ('FND', 'CONC-INVALID APPLICATION ID');
452: fnd_message.set_token('ID', p_application_id);
453: x_return_status := FND_API.G_RET_STS_ERROR;
454:
455: END Validate_APPLICATION_ID;
456:
457:

Line 497: -- FND_API.G_RET_STS_SUCCESS else G_RET_STS_ERROR.

493: --
494: -- Returns the status depending on the outcome
495: -- If p_currency_code is valid for the specified
496: -- (p_effective_date) period then returns
497: -- FND_API.G_RET_STS_SUCCESS else G_RET_STS_ERROR.
498: --
499: -- The calling program should write the error message
500: -- depending on the return status from the function
501: --

Line 524: l_return_status := FND_API.G_RET_STS_SUCCESS;

520: and trunc(p_effective_date) between trunc(nvl(start_date_active, p_effective_date))
521: and trunc(nvl(end_date_active, p_effective_date));
522: BEGIN
523: -- Initialize the return status to success.
524: l_return_status := FND_API.G_RET_STS_SUCCESS;
525: open csr_currency_look;
526: fetch csr_currency_look into l_dummy;
527: if csr_currency_look%notfound then
528: close csr_currency_look;

Line 529: l_return_status := FND_API.G_RET_STS_ERROR;

525: open csr_currency_look;
526: fetch csr_currency_look into l_dummy;
527: if csr_currency_look%notfound then
528: close csr_currency_look;
529: l_return_status := FND_API.G_RET_STS_ERROR;
530: --** invalid arg;
531: end if;
532: if csr_currency_look%ISOPEN then
533: close csr_currency_look;

Line 555: -- FND_API.G_RET_STS_SUCCESS else G_RET_STS_ERROR.

551: --
552: -- Returns the status depending on the outcome.
553: -- If p_currency_code is enabled for the specified
554: -- (p_effective_date) period then returns
555: -- FND_API.G_RET_STS_SUCCESS else G_RET_STS_ERROR.
556: --
557: --
558: -- For CSC Development.
559:

Line 584: l_return_status := FND_API.G_RET_STS_SUCCESS;

580: trunc(nvl(start_date_active, p_effective_date))
581: and trunc(nvl(end_date_active, p_effective_date));
582: BEGIN
583: -- Initialize the return status to success.
584: l_return_status := FND_API.G_RET_STS_SUCCESS;
585: open csr_lookup_code;
586: fetch csr_lookup_code into l_dummy;
587: if csr_lookup_code%notfound then
588: close csr_lookup_code;

Line 589: l_return_status := FND_API.G_RET_STS_ERROR;

585: open csr_lookup_code;
586: fetch csr_lookup_code into l_dummy;
587: if csr_lookup_code%notfound then
588: close csr_lookup_code;
589: l_return_status := FND_API.G_RET_STS_ERROR;
590: end if;
591: if csr_lookup_code%ISOPEN then
592: close csr_lookup_code;
593: end if;

Line 624: l_return_status := FND_API.G_RET_STS_SUCCESS;

620: and trunc(nvl(end_date_active, p_effective_date));
621: BEGIN
622:
623: -- Initialize the return status to success.
624: l_return_status := FND_API.G_RET_STS_SUCCESS;
625:
626: open csr_lookup_code;
627: fetch csr_lookup_code into l_dummy;
628: if csr_lookup_code%notfound then

Line 630: l_return_status := FND_API.G_RET_STS_ERROR;

626: open csr_lookup_code;
627: fetch csr_lookup_code into l_dummy;
628: if csr_lookup_code%notfound then
629: close csr_lookup_code;
630: l_return_status := FND_API.G_RET_STS_ERROR;
631: end if;
632: if csr_lookup_code%ISOPEN then
633: close csr_lookup_code;
634: end if;

Line 691: x_return_status := FND_API.G_RET_STS_SUCCESS;

687: x_msg_data varchar2(500);
688:
689: BEGIN
690: --
691: x_return_status := FND_API.G_RET_STS_SUCCESS;
692: --
693:
694: --** need to check out
695:

Line 698: p_init_msg_list => FND_API.G_FALSE,

694: --** need to check out
695:
696:
697: Validate_Dates (
698: p_init_msg_list => FND_API.G_FALSE,
699: p_validation_mode => NULL,
700: P_START_DATE => p_start_date,
701: P_END_DATE => p_end_date,
702: x_return_status => x_return_status,

Line 714: x_return_status := FND_API.G_RET_STS_ERROR;

710: FND_MESSAGE.Set_Name('CS', 'CS_ALL_START_DATE');
711: FND_MESSAGE.Set_Token('START_DATE' ,p_start_date);
712: FND_MESSAGE.Set_Token('END_DATE' ,p_end_date);
713: END IF;
714: x_return_status := FND_API.G_RET_STS_ERROR;
715:
716: END IF;
717: --
718: IF( p_end_date < p_start_date ) THEN

Line 724: x_return_status := FND_API.G_RET_STS_ERROR;

720: FND_MESSAGE.Set_Name('CS', 'CS_ALL_END_DATE');
721: FND_MESSAGE.Set_Token('START_DATE' ,p_start_date);
722: FND_MESSAGE.Set_Token('END_DATE' ,p_end_date);
723: END IF;
724: x_return_status := FND_API.G_RET_STS_ERROR;
725: END IF;
726: END IF;
727: */
728: END;

Line 909: x_return_status := FND_API.G_RET_STS_SUCCESS;

905: l_sql_cur_hdl INT;
906: BEGIN
907:
908: -- initialize the return status to SUCCESS
909: x_return_status := FND_API.G_RET_STS_SUCCESS;
910:
911: -- if the sql_statement is passed in and if its NOT NULL then
912: -- validate the sql_statement by parsing it using the dbms_sql
913: -- package.

Line 915: ( p_sql_stmnt <> FND_API.G_MISS_CHAR )) THEN

911: -- if the sql_statement is passed in and if its NOT NULL then
912: -- validate the sql_statement by parsing it using the dbms_sql
913: -- package.
914: IF (( p_sql_stmnt IS NOT NULL ) and
915: ( p_sql_stmnt <> FND_API.G_MISS_CHAR )) THEN
916: l_sql_cur_hdl := DBMS_SQL.OPEN_CURSOR;
917: DBMS_SQL.PARSE( l_sql_cur_hdl, p_sql_stmnt, DBMS_SQL.NATIVE );
918: DBMS_SQL.CLOSE_CURSOR( l_sql_cur_hdl );
919: END IF;

Line 925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

921: WHEN OTHERS THEN
922: IF DBMS_SQL.IS_OPEN( l_Sql_cur_hdl ) THEN
923: DBMS_SQL.CLOSE_CURSOR(l_Sql_cur_hdl );
924: END IF;
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
926: END Validate_Sql_Stmnt;
927:
928: -- ---------------------------------------------------------------------------
929: -- -------------------------< Build_Sql_Stmnt>--------------------------

Line 945: x_return_status := FND_API.G_RET_STS_SUCCESS;

941: l_sql_stmnt VARCHAR2(2000);
942: BEGIN
943:
944: -- initialize the return status
945: x_return_status := FND_API.G_RET_STS_SUCCESS;
946:
947: -- check if the select_clause and the from_Clause
948: -- is NULL or missing, if so we cannot form an
949: -- sql_statement.

Line 952: ( p_Select_Clause = FND_API.G_MISS_CHAR ))

948: -- is NULL or missing, if so we cannot form an
949: -- sql_statement.
950:
951: IF ((( p_Select_Clause IS NULL ) and
952: ( p_Select_Clause = FND_API.G_MISS_CHAR ))
953: and (( p_from_Clause IS NULL ) and
954: ( p_from_Clause = FND_API.G_MISS_CHAR )))
955: THEN
956: -- invalid arguments exception

Line 954: ( p_from_Clause = FND_API.G_MISS_CHAR )))

950:
951: IF ((( p_Select_Clause IS NULL ) and
952: ( p_Select_Clause = FND_API.G_MISS_CHAR ))
953: and (( p_from_Clause IS NULL ) and
954: ( p_from_Clause = FND_API.G_MISS_CHAR )))
955: THEN
956: -- invalid arguments exception
957: x_return_status := FND_API.G_RET_STS_ERROR;
958: ELSE

Line 957: x_return_status := FND_API.G_RET_STS_ERROR;

953: and (( p_from_Clause IS NULL ) and
954: ( p_from_Clause = FND_API.G_MISS_CHAR )))
955: THEN
956: -- invalid arguments exception
957: x_return_status := FND_API.G_RET_STS_ERROR;
958: ELSE
959: -- if present concatenate both the clauses.
960: l_sql_stmnt := 'SELECT '||p_select_clause||' FROM '||p_from_clause;
961: END IF;

Line 965: and ( p_where_clause <> FND_API.G_MISS_CHAR )) THEN

961: END IF;
962:
963: -- if where_clause is passsed in contenate to the select and from clauses
964: IF (( p_where_clause IS NOT NULL )
965: and ( p_where_clause <> FND_API.G_MISS_CHAR )) THEN
966: l_sql_stmnt := l_sql_stmnt||' WHERE '||p_where_clause;
967: END IF;
968:
969: -- if other_clause is not null then concatenate

Line 971: and ( p_other_clause <> FND_API.G_MISS_CHAR )) THEN

967: END IF;
968:
969: -- if other_clause is not null then concatenate
970: IF (( p_other_clause IS NOT NULL )
971: and ( p_other_clause <> FND_API.G_MISS_CHAR )) THEN
972: l_sql_stmnt := l_sql_stmnt||' '||p_other_clause;
973: END IF;
974: x_sql_stmnt := l_sql_stmnt;
975: EXCEPTION

Line 977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

973: END IF;
974: x_sql_stmnt := l_sql_stmnt;
975: EXCEPTION
976: WHEN OTHERS THEN
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: END Build_Sql_Stmnt;
979:
980:
981: FUNCTION Get_G_Miss_Char(p_value IN Varchar2, p_old_value IN Varchar2)