APPS.CSC_CORE_UTILS_PVT dependencies on CSC_CORE_UTILS_PVT

Line 1: PACKAGE BODY CSC_CORE_UTILS_PVT as

1: PACKAGE BODY CSC_CORE_UTILS_PVT as
2: /* $Header: cscvcorb.pls 115.18 2002/12/04 19:13:32 jamose ship $ */
3: -- Start of Comments
4: -- Package name : CSC_CORE_UTILS_PVT
5: -- Purpose : This package contains all the common procedure, functions and global

Line 4: -- Package name : CSC_CORE_UTILS_PVT

1: PACKAGE BODY CSC_CORE_UTILS_PVT as
2: /* $Header: cscvcorb.pls 115.18 2002/12/04 19:13:32 jamose ship $ */
3: -- Start of Comments
4: -- Package name : CSC_CORE_UTILS_PVT
5: -- Purpose : This package contains all the common procedure, functions and global
6: -- variables that will be used by the CUSTOMER CARE-MODULE.
7: --
8: -- History

Line 137: P_OWNNAME IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_APP_SHORTNAME,

133: -- commenting out the procedure as this is not used in any appl.
134: -- parmateres for fnd_stats.gather_tabel_stats have been changed
135: /*
136: PROCEDURE GATHER_TABLE_STATS (
137: P_OWNNAME IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_APP_SHORTNAME,
138: P_TABNAME IN VARCHAR2,
139: P_PERCENT IN NUMBER := NULL,
140: P_DEGREE IN NUMBER := NULL,
141: P_PARTNAME IN VARCHAR2 := NULL,

Line 195: ELSIF p_exception_level = CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS

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
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 (

Line 242: if ( P_Validation_Mode = CSC_CORE_UTILS_PVT.G_UPDATE ) then

238:
239: END IF;
240:
241: /*
242: if ( P_Validation_Mode = CSC_CORE_UTILS_PVT.G_UPDATE ) then
243: if ( p_start_date < sysdate ) then
244: FND_MESSAGE.SET_NAME (G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
245: FND_MESSAGE.SET_TOKEN('API_NAME', 'VALIDATE_DATES');
246: FND_MESSAGE.SET_TOKEN('VALUE', p_start_date); -- parameter here is start_date.

Line 392: IF (( p_seeded_flag <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND

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
391: -- its an invalid argument.
392: IF (( p_seeded_flag <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
393: ( p_seeded_flag IS NOT NULL )) THEN
394: IF CSC_CORE_UTILS_PVT.lookup_code_not_exists(
395: p_effective_date => trunc(sysdate),
396:

Line 394: IF CSC_CORE_UTILS_PVT.lookup_code_not_exists(

390: -- exists in fnd lookups for this date, if not
391: -- its an invalid argument.
392: IF (( p_seeded_flag <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
393: ( p_seeded_flag IS NOT NULL )) THEN
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

Line 402: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(p_api_name => p_api_name,

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;
406: END IF;

Line 413: P_Init_Msg_List IN VARCHAR2 :=CSC_CORE_UTILS_PVT.G_FALSE,

409:
410: /* Added this Procedure for validation of Application_id for Enhancement 1784578*/
411:
412: PROCEDURE Validate_APPLICATION_ID (
413: P_Init_Msg_List IN VARCHAR2 :=CSC_CORE_UTILS_PVT.G_FALSE,
414: P_Application_ID IN NUMBER DEFAULT NULL,
415: X_Return_Status OUT NOCOPY VARCHAR2,
416: X_Msg_Count OUT NOCOPY NUMBER,
417: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 433: IF (( p_application_id <> CSC_CORE_UTILS_PVT.G_MISS_NUM ) AND

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:
436: select 1 into l_temp_id from fnd_application
437: where application_id=p_application_id;

Line 1017: END CSC_CORE_UTILS_PVT;

1013: END IF;
1014: END;
1015:
1016:
1017: END CSC_CORE_UTILS_PVT;