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_PLAN_LINES_PVT dependencies on CSC_CORE_UTILS_PVT

Line 219: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'UT_CANNOT_GET_PROFILE_VALUE');

215: IF FND_GLOBAL.User_Id IS NULL
216: THEN
217: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
218: THEN
219: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'UT_CANNOT_GET_PROFILE_VALUE');
220: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
221: -- FND_MSG_PUB.ADD;
222: END IF;
223: RAISE FND_API.G_EXC_ERROR;

Line 232: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,

228: -- Invoke validation procedures
229: Validate_csc_plan_lines(
230: p_init_msg_list => FND_API.G_FALSE,
231: p_validation_level => p_validation_level,
232: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
233: P_CSC_PLAN_LINES_Rec => P_CSC_PLAN_LINES_Rec,
234: x_return_status => x_return_status,
235: x_msg_count => x_msg_count,
236: x_msg_data => x_msg_data);

Line 283: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(

279: p_data => x_msg_data );
280:
281: EXCEPTION
282: WHEN FND_API.G_EXC_ERROR THEN
283: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
284: P_API_NAME => L_API_NAME,
285: P_PKG_NAME => G_PKG_NAME,
286: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
287: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

Line 287: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

283: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
284: P_API_NAME => L_API_NAME,
285: P_PKG_NAME => G_PKG_NAME,
286: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
287: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
288: X_MSG_COUNT => X_MSG_COUNT,
289: X_MSG_DATA => X_MSG_DATA,
290: X_RETURN_STATUS => X_RETURN_STATUS);
291: APP_EXCEPTION.RAISE_EXCEPTION;

Line 294: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(

290: X_RETURN_STATUS => X_RETURN_STATUS);
291: APP_EXCEPTION.RAISE_EXCEPTION;
292:
293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
295: P_API_NAME => L_API_NAME,
296: P_PKG_NAME => G_PKG_NAME,
297: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
298: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

Line 298: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

294: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
295: P_API_NAME => L_API_NAME,
296: P_PKG_NAME => G_PKG_NAME,
297: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
298: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
299: X_MSG_COUNT => X_MSG_COUNT,
300: X_MSG_DATA => X_MSG_DATA,
301: X_RETURN_STATUS => X_RETURN_STATUS);
302: APP_EXCEPTION.RAISE_EXCEPTION;

Line 305: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(

301: X_RETURN_STATUS => X_RETURN_STATUS);
302: APP_EXCEPTION.RAISE_EXCEPTION;
303:
304: WHEN OTHERS THEN
305: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
306: P_API_NAME => L_API_NAME,
307: P_PKG_NAME => G_PKG_NAME,
308: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
309: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

Line 308: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,

304: WHEN OTHERS THEN
305: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
306: P_API_NAME => L_API_NAME,
307: P_PKG_NAME => G_PKG_NAME,
308: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
309: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
310: X_MSG_COUNT => X_MSG_COUNT,
311: X_MSG_DATA => X_MSG_DATA,
312: X_RETURN_STATUS => X_RETURN_STATUS);

Line 309: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

305: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
306: P_API_NAME => L_API_NAME,
307: P_PKG_NAME => G_PKG_NAME,
308: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
309: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
310: X_MSG_COUNT => X_MSG_COUNT,
311: X_MSG_DATA => X_MSG_DATA,
312: X_RETURN_STATUS => X_RETURN_STATUS);
313: APP_EXCEPTION.RAISE_EXCEPTION;

Line 490: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');

486: If ( C_Get_plan_lines%NOTFOUND) Then
487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
488: THEN
489: Close C_Get_plan_lines;
490: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');
491: FND_MESSAGE.Set_Token ('INFO', 'plan_lines', FALSE);
492: -- FND_MSG_PUB.Add;
493: END IF;
494: raise FND_API.G_EXC_ERROR;

Line 505: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,

501: -- Invoke validation procedures
502: Validate_csc_plan_lines(
503: p_init_msg_list => FND_API.G_FALSE,
504: p_validation_level => p_validation_level,
505: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
506: P_CSC_PLAN_LINES_Rec => P_CSC_PLAN_LINES_Rec,
507: x_return_status => x_return_status,
508: x_msg_count => x_msg_count,
509: x_msg_data => x_msg_data);

Line 558: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(

554: );
555:
556: EXCEPTION
557: WHEN FND_API.G_EXC_ERROR THEN
558: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
559: P_API_NAME => L_API_NAME,
560: P_PKG_NAME => G_PKG_NAME,
561: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
562: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

Line 562: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

558: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
559: P_API_NAME => L_API_NAME,
560: P_PKG_NAME => G_PKG_NAME,
561: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
562: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
563: X_MSG_COUNT => X_MSG_COUNT,
564: X_MSG_DATA => X_MSG_DATA,
565: X_RETURN_STATUS => X_RETURN_STATUS);
566: APP_EXCEPTION.RAISE_EXCEPTION;

Line 569: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(

565: X_RETURN_STATUS => X_RETURN_STATUS);
566: APP_EXCEPTION.RAISE_EXCEPTION;
567:
568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
569: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
570: P_API_NAME => L_API_NAME,
571: P_PKG_NAME => G_PKG_NAME,
572: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
573: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

Line 573: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

569: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
570: P_API_NAME => L_API_NAME,
571: P_PKG_NAME => G_PKG_NAME,
572: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
573: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
574: X_MSG_COUNT => X_MSG_COUNT,
575: X_MSG_DATA => X_MSG_DATA,
576: X_RETURN_STATUS => X_RETURN_STATUS);
577: APP_EXCEPTION.RAISE_EXCEPTION;

Line 580: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(

576: X_RETURN_STATUS => X_RETURN_STATUS);
577: APP_EXCEPTION.RAISE_EXCEPTION;
578:
579: WHEN OTHERS THEN
580: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
581: P_API_NAME => L_API_NAME,
582: P_PKG_NAME => G_PKG_NAME,
583: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
584: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

Line 583: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,

579: WHEN OTHERS THEN
580: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
581: P_API_NAME => L_API_NAME,
582: P_PKG_NAME => G_PKG_NAME,
583: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
584: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
585: X_MSG_COUNT => X_MSG_COUNT,
586: X_MSG_DATA => X_MSG_DATA,
587: X_RETURN_STATUS => X_RETURN_STATUS);

Line 584: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

580: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
581: P_API_NAME => L_API_NAME,
582: P_PKG_NAME => G_PKG_NAME,
583: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
584: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
585: X_MSG_COUNT => X_MSG_COUNT,
586: X_MSG_DATA => X_MSG_DATA,
587: X_RETURN_STATUS => X_RETURN_STATUS);
588: APP_EXCEPTION.RAISE_EXCEPTION;

Line 646: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(

642: p_data => x_msg_data);
643:
644: EXCEPTION
645: WHEN FND_API.G_EXC_ERROR THEN
646: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
647: P_API_NAME => L_API_NAME,
648: P_PKG_NAME => G_PKG_NAME,
649: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
650: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

Line 650: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

646: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
647: P_API_NAME => L_API_NAME,
648: P_PKG_NAME => G_PKG_NAME,
649: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
650: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
651: X_MSG_COUNT => X_MSG_COUNT,
652: X_MSG_DATA => X_MSG_DATA,
653: X_RETURN_STATUS => X_RETURN_STATUS);
654: APP_EXCEPTION.RAISE_EXCEPTION;

Line 657: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(

653: X_RETURN_STATUS => X_RETURN_STATUS);
654: APP_EXCEPTION.RAISE_EXCEPTION;
655:
656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
657: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
658: P_API_NAME => L_API_NAME,
659: P_PKG_NAME => G_PKG_NAME,
660: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
661: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

Line 661: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

657: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
658: P_API_NAME => L_API_NAME,
659: P_PKG_NAME => G_PKG_NAME,
660: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
661: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
662: X_MSG_COUNT => X_MSG_COUNT,
663: X_MSG_DATA => X_MSG_DATA,
664: X_RETURN_STATUS => X_RETURN_STATUS);
665: APP_EXCEPTION.RAISE_EXCEPTION;

Line 668: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(

664: X_RETURN_STATUS => X_RETURN_STATUS);
665: APP_EXCEPTION.RAISE_EXCEPTION;
666:
667: WHEN OTHERS THEN
668: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
669: P_API_NAME => L_API_NAME,
670: P_PKG_NAME => G_PKG_NAME,
671: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
672: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

Line 671: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,

667: WHEN OTHERS THEN
668: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
669: P_API_NAME => L_API_NAME,
670: P_PKG_NAME => G_PKG_NAME,
671: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
672: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
673: X_MSG_COUNT => X_MSG_COUNT,
674: X_MSG_DATA => X_MSG_DATA,
675: X_RETURN_STATUS => X_RETURN_STATUS);

Line 672: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

668: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
669: P_API_NAME => L_API_NAME,
670: P_PKG_NAME => G_PKG_NAME,
671: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
672: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
673: X_MSG_COUNT => X_MSG_COUNT,
674: X_MSG_DATA => X_MSG_DATA,
675: X_RETURN_STATUS => X_RETURN_STATUS);
676: APP_EXCEPTION.RAISE_EXCEPTION;

Line 710: IF( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE ) THEN

706: -- Initialize API return status to SUCCESS
707: x_return_status := FND_API.G_RET_STS_SUCCESS;
708:
709: -- validate NOT NULL column for updates
710: IF( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE ) THEN
711: if ( p_line_id is NULL or p_line_id = FND_API.G_MISS_NUM ) then
712: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
713: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
714: fnd_message.set_token('NULL_PARAM', 'LINE_ID');

Line 712: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

708:
709: -- validate NOT NULL column for updates
710: IF( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE ) THEN
711: if ( p_line_id is NULL or p_line_id = FND_API.G_MISS_NUM ) then
712: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
713: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
714: fnd_message.set_token('NULL_PARAM', 'LINE_ID');
715: x_return_status := FND_API.G_RET_STS_ERROR;
716: end if;

Line 717: ELSIF( p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE AND

713: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
714: fnd_message.set_token('NULL_PARAM', 'LINE_ID');
715: x_return_status := FND_API.G_RET_STS_ERROR;
716: end if;
717: ELSIF( p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE AND
718: p_line_id is not NULL and p_line_id <> FND_API.G_MISS_NUM ) THEN
719: -- check for duplicate line_ids.
720: open check_dup_line_id;
721: fetch check_dup_line_id into l_line_id;

Line 723: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');

719: -- check for duplicate line_ids.
720: open check_dup_line_id;
721: fetch check_dup_line_id into l_line_id;
722: if check_dup_line_id%FOUND then
723: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
724: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
725: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'LINE_ID');
726: -- fnd_msg_pub.add;
727: x_return_status := FND_API.G_RET_STS_ERROR;

Line 772: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

768: x_return_status := FND_API.G_RET_STS_SUCCESS;
769:
770: -- validate NOT NULL column
771: IF( p_PLAN_ID is NULL or p_plan_id = FND_API.G_MISS_NUM ) then
772: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
773: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
774: fnd_message.set_token('NULL_PARAM', 'PLAN_ID');
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: END IF;

Line 783: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');

779: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
780: open c1;
781: fetch c1 into l_plan_id;
782: if c1%NOTFOUND then
783: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
784: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
785: fnd_message.set_token('VALUE', p_plan_id);
786: fnd_message.set_token('PARAMETER', 'PLAN_ID');
787: x_return_status := FND_API.G_RET_STS_ERROR;

Line 840: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

836: x_return_status := FND_API.G_RET_STS_SUCCESS;
837:
838: -- validate NOT NULL column
839: IF( p_CONDITION_ID is NULL or p_condition_id = FND_API.G_MISS_NUM ) THEN
840: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
841: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
842: fnd_message.set_token('NULL_PARAM', 'CONDITION_ID');
843: -- fnd_msg_pub.add;
844: x_return_status := FND_API.G_RET_STS_ERROR;

Line 852: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');

848: -- validate for valid condition_id.
849: open c1;
850: fetch c1 into l_id;
851: if c1%NOTFOUND then
852: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
853: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
854: fnd_message.set_token('VALUE', p_condition_id);
855: fnd_message.set_token('PARAMETER', 'CONDITION_ID');
856: x_return_status := FND_API.G_RET_STS_ERROR;

Line 865: if ( (p_validation_mode <> CSC_CORE_UTILS_PVT.G_UPDATE) AND (c2%FOUND) ) then

861: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
862: -- validate for duplicate plan_id and condition_id
863: open c2;
864: fetch c2 into l_id;
865: if ( (p_validation_mode <> CSC_CORE_UTILS_PVT.G_UPDATE) AND (c2%FOUND) ) then
866: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
867: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
868: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'CONDITION_ID');
869: x_return_status := FND_API.G_RET_STS_ERROR;

Line 866: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');

862: -- validate for duplicate plan_id and condition_id
863: open c2;
864: fetch c2 into l_id;
865: if ( (p_validation_mode <> CSC_CORE_UTILS_PVT.G_UPDATE) AND (c2%FOUND) ) then
866: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
867: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
868: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'CONDITION_ID');
869: x_return_status := FND_API.G_RET_STS_ERROR;
870: end if;

Line 907: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

903: THEN
904: x_return_status := FND_API.G_RET_STS_ERROR;
905: END IF;
906:
907: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
908: THEN
909: -- Hint: Validate data
910: -- IF p_OBJECT_VERSION_NUMBER is not NULL and p_OBJECT_VERSION_NUMBER <> G_MISS_CHAR
911: -- verify if data is valid

Line 914: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

910: -- IF p_OBJECT_VERSION_NUMBER is not NULL and p_OBJECT_VERSION_NUMBER <> G_MISS_CHAR
911: -- verify if data is valid
912: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
913: NULL;
914: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
915: THEN
916: -- Hint: Validate data
917: -- IF p_OBJECT_VERSION_NUMBER <> G_MISS_CHAR
918: -- verify if data is valid