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 FND_API

Line 18: -- 11-25-2002 bhroy FND_API defaults removed, added WHENEVER OSERROR EXIT FAILURE ROLLBACK;

14: -- 01-31-2000 dejoseph 'Arcs'ed in for fourth code freeze. (07-FEB-2000)
15: -- 02-13-2000 dejoseph 'Arcs'ed on for fifth code freeze. (21-FEB-2000)
16: -- 02-28-2000 dejoseph 'Arcs'ed on for sixth code freeze. (06-MAR-2000)
17: -- 11-11-2002 bhroy NOCOPY changes made
18: -- 11-25-2002 bhroy FND_API defaults removed, added WHENEVER OSERROR EXIT FAILURE ROLLBACK;
19:
20: -- NOTE :
21: -- End of Comments
22:

Line 194: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

190: -- Standard Start of API savepoint
191: SAVEPOINT CREATE_PLAN_LINES_PVT;
192:
193: -- Standard call to check for call compatibility.
194: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
195: p_api_version_number,
196: l_api_name,
197: G_PKG_NAME)
198: THEN

Line 199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

195: p_api_version_number,
196: l_api_name,
197: G_PKG_NAME)
198: THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: END IF;
201:
202:
203: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 204: IF FND_API.to_Boolean( p_init_msg_list )

200: END IF;
201:
202:
203: -- Initialize message list if p_init_msg_list is set to TRUE.
204: IF FND_API.to_Boolean( p_init_msg_list )
205: THEN
206: FND_MSG_PUB.initialize;
207: END IF;
208:

Line 210: x_return_status := FND_API.G_RET_STS_SUCCESS;

206: FND_MSG_PUB.initialize;
207: END IF;
208:
209: -- Initialize API return status to SUCCESS
210: x_return_status := FND_API.G_RET_STS_SUCCESS;
211:
212: -- ******************************************************************
213: -- Validate Environment
214: -- ******************************************************************

Line 223: RAISE FND_API.G_EXC_ERROR;

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;
224: END IF;
225:
226: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL )
227: THEN

Line 226: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL )

222: END IF;
223: RAISE FND_API.G_EXC_ERROR;
224: END IF;
225:
226: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL )
227: THEN
228: -- Invoke validation procedures
229: Validate_csc_plan_lines(
230: p_init_msg_list => FND_API.G_FALSE,

Line 230: p_init_msg_list => FND_API.G_FALSE,

226: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL )
227: THEN
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,

Line 237: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

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);
237: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
238: RAISE FND_API.G_EXC_ERROR;
239: END IF;
240: END IF;
241:

Line 238: RAISE FND_API.G_EXC_ERROR;

234: x_return_status => x_return_status,
235: x_msg_count => x_msg_count,
236: x_msg_data => x_msg_data);
237: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
238: RAISE FND_API.G_EXC_ERROR;
239: END IF;
240: END IF;
241:
242: -- Invoke table handler(CSC_PLAN_LINES_PKG.Insert_Row)

Line 271: IF FND_API.to_Boolean( p_commit )

267: p_ATTRIBUTE_CATEGORY => p_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
268: x_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
269:
270: -- Standard check for p_commit
271: IF FND_API.to_Boolean( p_commit )
272: THEN
273: COMMIT WORK;
274: END IF;
275:

Line 282: WHEN FND_API.G_EXC_ERROR THEN

278: ( p_count => x_msg_count,
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,

Line 293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

289: X_MSG_DATA => X_MSG_DATA,
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,

Line 439: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

435: -- Standard Start of API savepoint
436: SAVEPOINT UPDATE_PLAN_LINES_PVT;
437:
438: -- Standard call to check for call compatibility.
439: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
440: p_api_version_number,
441: l_api_name,
442: G_PKG_NAME)
443: THEN

Line 444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

440: p_api_version_number,
441: l_api_name,
442: G_PKG_NAME)
443: THEN
444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
445: END IF;
446:
447: -- Initialize message list if p_init_msg_list is set to TRUE.
448: IF FND_API.to_Boolean( p_init_msg_list )

Line 448: IF FND_API.to_Boolean( p_init_msg_list )

444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
445: END IF;
446:
447: -- Initialize message list if p_init_msg_list is set to TRUE.
448: IF FND_API.to_Boolean( p_init_msg_list )
449: THEN
450: FND_MSG_PUB.initialize;
451: END IF;
452:

Line 454: x_return_status := FND_API.G_RET_STS_SUCCESS;

450: FND_MSG_PUB.initialize;
451: END IF;
452:
453: -- Initialize API return status to SUCCESS
454: x_return_status := FND_API.G_RET_STS_SUCCESS;
455:
456: Open C_Get_plan_lines( l_tar_CSC_PLAN_LINES_rec.LINE_ID);
457:
458: Fetch C_Get_plan_lines into

Line 494: raise FND_API.G_EXC_ERROR;

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;
495: END IF;
496:
497: Close C_Get_plan_lines;
498:

Line 499: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

495: END IF;
496:
497: Close C_Get_plan_lines;
498:
499: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
500: THEN
501: -- Invoke validation procedures
502: Validate_csc_plan_lines(
503: p_init_msg_list => FND_API.G_FALSE,

Line 503: p_init_msg_list => FND_API.G_FALSE,

499: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
500: THEN
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,

Line 512: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

508: x_msg_count => x_msg_count,
509: x_msg_data => x_msg_data);
510: END IF;
511:
512: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515:
516: -- Invoke table handler(CSC_PLAN_LINES_PKG.Update_Row)

Line 513: RAISE FND_API.G_EXC_ERROR;

509: x_msg_data => x_msg_data);
510: END IF;
511:
512: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515:
516: -- Invoke table handler(CSC_PLAN_LINES_PKG.Update_Row)
517: CSC_PLAN_LINES_PKG.Update_Row(

Line 545: IF FND_API.to_Boolean( p_commit )

541: p_ATTRIBUTE_CATEGORY => p_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
542: x_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
543:
544: -- Standard check for p_commit
545: IF FND_API.to_Boolean( p_commit )
546: THEN
547: COMMIT WORK;
548: END IF;
549:

Line 557: WHEN FND_API.G_EXC_ERROR THEN

553: p_data => x_msg_data
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,

Line 568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

564: X_MSG_DATA => X_MSG_DATA,
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,

Line 611: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

607: -- Standard Start of API savepoint
608: SAVEPOINT DELETE_PLAN_LINES_PVT;
609:
610: -- Standard call to check for call compatibility.
611: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
612: p_api_version_number,
613: l_api_name,
614: G_PKG_NAME)
615: THEN

Line 616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

612: p_api_version_number,
613: l_api_name,
614: G_PKG_NAME)
615: THEN
616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
617: END IF;
618:
619: -- Initialize message list if p_init_msg_list is set to TRUE.
620: IF FND_API.to_Boolean( p_init_msg_list )

Line 620: IF FND_API.to_Boolean( p_init_msg_list )

616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
617: END IF;
618:
619: -- Initialize message list if p_init_msg_list is set to TRUE.
620: IF FND_API.to_Boolean( p_init_msg_list )
621: THEN
622: FND_MSG_PUB.initialize;
623: END IF;
624:

Line 626: x_return_status := FND_API.G_RET_STS_SUCCESS;

622: FND_MSG_PUB.initialize;
623: END IF;
624:
625: -- Initialize API return status to SUCCESS
626: x_return_status := FND_API.G_RET_STS_SUCCESS;
627:
628: -- Invoke table handler(CSC_PLAN_LINES_PKG.Delete_Row)
629: CSC_PLAN_LINES_PKG.Delete_Row(
630: p_PLAN_ID => P_PLAN_ID,

Line 634: IF FND_API.to_Boolean( p_commit )

630: p_PLAN_ID => P_PLAN_ID,
631: p_LINE_ID => P_LINE_ID);
632:
633: -- Standard check for p_commit
634: IF FND_API.to_Boolean( p_commit )
635: THEN
636: COMMIT WORK;
637: END IF;
638:

Line 645: WHEN FND_API.G_EXC_ERROR THEN

641: ( p_count => x_msg_count,
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,

Line 656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

652: X_MSG_DATA => X_MSG_DATA,
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,

Line 701: IF FND_API.to_Boolean( p_init_msg_list )

697: l_line_id number;
698: l_api_name varchar2(30) := 'Validate_Line_Id';
699: BEGIN
700: -- Initialize message list if p_init_msg_list is set to TRUE.
701: IF FND_API.to_Boolean( p_init_msg_list )
702: THEN
703: FND_MSG_PUB.initialize;
704: END IF;
705:

Line 707: x_return_status := FND_API.G_RET_STS_SUCCESS;

703: FND_MSG_PUB.initialize;
704: END IF;
705:
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

Line 711: if ( p_line_id is NULL or p_line_id = FND_API.G_MISS_NUM ) then

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');
715: x_return_status := FND_API.G_RET_STS_ERROR;

Line 715: x_return_status := FND_API.G_RET_STS_ERROR;

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;
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.

Line 718: p_line_id is not NULL and p_line_id <> FND_API.G_MISS_NUM ) THEN

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;
722: if check_dup_line_id%FOUND then

Line 727: x_return_status := FND_API.G_RET_STS_ERROR;

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;
728: end if;
729: close check_dup_line_id;
730: END IF;
731:

Line 732: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) then

728: end if;
729: close check_dup_line_id;
730: END IF;
731:
732: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
733: APP_EXCEPTION.RAISE_EXCEPTION;
734: END IF;
735:
736: -- Standard call to get message count and if count is 1, get message info.

Line 762: IF FND_API.to_Boolean( p_init_msg_list )

758: l_plan_id number;
759: l_api_name varchar2(30) := 'Validate_Plan_Id';
760: BEGIN
761: -- Initialize message list if p_init_msg_list is set to TRUE.
762: IF FND_API.to_Boolean( p_init_msg_list )
763: THEN
764: FND_MSG_PUB.initialize;
765: END IF;
766:

Line 768: x_return_status := FND_API.G_RET_STS_SUCCESS;

764: FND_MSG_PUB.initialize;
765: END IF;
766:
767: -- Initialize API return status to SUCCESS
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');

Line 771: IF( p_PLAN_ID is NULL or p_plan_id = FND_API.G_MISS_NUM ) then

767: -- Initialize API return status to SUCCESS
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;

Line 775: x_return_status := FND_API.G_RET_STS_ERROR;

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;
777:
778: -- validate for valid plan_ids.
779: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then

Line 779: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then

775: x_return_status := FND_API.G_RET_STS_ERROR;
776: END IF;
777:
778: -- validate for valid plan_ids.
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');

Line 787: x_return_status := FND_API.G_RET_STS_ERROR;

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;
788: end if;
789: close c1;
790: END IF;
791:

Line 792: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) then

788: end if;
789: close c1;
790: END IF;
791:
792: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
793: APP_EXCEPTION.RAISE_EXCEPTION;
794: END IF;
795:
796: -- Standard call to get message count and if count is 1, get message info.

Line 830: IF FND_API.to_Boolean( p_init_msg_list )

826: l_api_name VARCHAR2(30) := 'Validate_Condition_Id';
827:
828: BEGIN
829: -- Initialize message list if p_init_msg_list is set to TRUE.
830: IF FND_API.to_Boolean( p_init_msg_list )
831: THEN
832: FND_MSG_PUB.initialize;
833: END IF;
834:

Line 836: x_return_status := FND_API.G_RET_STS_SUCCESS;

832: FND_MSG_PUB.initialize;
833: END IF;
834:
835: -- Initialize API return status to SUCCESS
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');

Line 839: IF( p_CONDITION_ID is NULL or p_condition_id = FND_API.G_MISS_NUM ) THEN

835: -- Initialize API return status to SUCCESS
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;

Line 844: x_return_status := FND_API.G_RET_STS_ERROR;

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;
845: END IF;
846:
847: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
848: -- validate for valid condition_id.

Line 847: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then

843: -- fnd_msg_pub.add;
844: x_return_status := FND_API.G_RET_STS_ERROR;
845: END IF;
846:
847: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
848: -- validate for valid condition_id.
849: open c1;
850: fetch c1 into l_id;
851: if c1%NOTFOUND then

Line 856: x_return_status := FND_API.G_RET_STS_ERROR;

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;
857: end if;
858: close c1;
859: END IF;
860:

Line 861: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then

857: end if;
858: close c1;
859: END IF;
860:
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

Line 869: x_return_status := FND_API.G_RET_STS_ERROR;

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;
871: close c2;
872: END IF;
873:

Line 874: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) then

870: end if;
871: close c2;
872: END IF;
873:
874: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
875: APP_EXCEPTION.RAISE_EXCEPTION;
876: END IF;
877:
878: END Validate_CONDITION_ID;

Line 892: IF FND_API.to_Boolean( p_init_msg_list )

888: )
889: IS
890: BEGIN
891: -- Initialize message list if p_init_msg_list is set to TRUE.
892: IF FND_API.to_Boolean( p_init_msg_list )
893: THEN
894: FND_MSG_PUB.initialize;
895: END IF;
896:

Line 899: x_return_status := FND_API.G_RET_STS_SUCCESS;

895: END IF;
896:
897:
898: -- Initialize API return status to SUCCESS
899: x_return_status := FND_API.G_RET_STS_SUCCESS;
900:
901: -- validate NOT NULL column
902: IF(p_OBJECT_VERSION_NUMBER is NULL)
903: THEN

Line 904: x_return_status := FND_API.G_RET_STS_ERROR;

900:
901: -- validate NOT NULL column
902: IF(p_OBJECT_VERSION_NUMBER is NULL)
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

Line 912: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 919: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

915: THEN
916: -- Hint: Validate data
917: -- IF p_OBJECT_VERSION_NUMBER <> G_MISS_CHAR
918: -- verify if data is valid
919: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
920: NULL;
921: END IF;
922:
923: -- Standard call to get message count and if count is 1, get message info.

Line 945: x_return_status := FND_API.G_RET_STS_SUCCESS;

941: IS
942: l_api_name CONSTANT VARCHAR2(30) := 'Validate_csc_plan_lines';
943: BEGIN
944: -- Initialize API return status to SUCCESS
945: x_return_status := FND_API.G_RET_STS_SUCCESS;
946:
947: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
948: Validate_LINE_ID(
949: p_init_msg_list => FND_API.G_FALSE,

Line 947: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

943: BEGIN
944: -- Initialize API return status to SUCCESS
945: x_return_status := FND_API.G_RET_STS_SUCCESS;
946:
947: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
948: Validate_LINE_ID(
949: p_init_msg_list => FND_API.G_FALSE,
950: p_validation_mode => p_validation_mode,
951: p_LINE_ID => P_CSC_PLAN_LINES_Rec.LINE_ID,

Line 949: p_init_msg_list => FND_API.G_FALSE,

945: x_return_status := FND_API.G_RET_STS_SUCCESS;
946:
947: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
948: Validate_LINE_ID(
949: p_init_msg_list => FND_API.G_FALSE,
950: p_validation_mode => p_validation_mode,
951: p_LINE_ID => P_CSC_PLAN_LINES_Rec.LINE_ID,
952: x_return_status => x_return_status,
953: x_msg_count => x_msg_count,

Line 955: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

951: p_LINE_ID => P_CSC_PLAN_LINES_Rec.LINE_ID,
952: x_return_status => x_return_status,
953: x_msg_count => x_msg_count,
954: x_msg_data => x_msg_data);
955: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
956: raise FND_API.G_EXC_ERROR;
957: END IF;
958:
959: Validate_PLAN_ID(

Line 956: raise FND_API.G_EXC_ERROR;

952: x_return_status => x_return_status,
953: x_msg_count => x_msg_count,
954: x_msg_data => x_msg_data);
955: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
956: raise FND_API.G_EXC_ERROR;
957: END IF;
958:
959: Validate_PLAN_ID(
960: p_init_msg_list => FND_API.G_FALSE,

Line 960: p_init_msg_list => FND_API.G_FALSE,

956: raise FND_API.G_EXC_ERROR;
957: END IF;
958:
959: Validate_PLAN_ID(
960: p_init_msg_list => FND_API.G_FALSE,
961: p_validation_mode => p_validation_mode,
962: p_PLAN_ID => P_CSC_PLAN_LINES_Rec.PLAN_ID,
963: x_return_status => x_return_status,
964: x_msg_count => x_msg_count,

Line 966: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

962: p_PLAN_ID => P_CSC_PLAN_LINES_Rec.PLAN_ID,
963: x_return_status => x_return_status,
964: x_msg_count => x_msg_count,
965: x_msg_data => x_msg_data);
966: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
967: raise FND_API.G_EXC_ERROR;
968: END IF;
969:
970: Validate_CONDITION_ID(

Line 967: raise FND_API.G_EXC_ERROR;

963: x_return_status => x_return_status,
964: x_msg_count => x_msg_count,
965: x_msg_data => x_msg_data);
966: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
967: raise FND_API.G_EXC_ERROR;
968: END IF;
969:
970: Validate_CONDITION_ID(
971: p_init_msg_list => FND_API.G_FALSE,

Line 971: p_init_msg_list => FND_API.G_FALSE,

967: raise FND_API.G_EXC_ERROR;
968: END IF;
969:
970: Validate_CONDITION_ID(
971: p_init_msg_list => FND_API.G_FALSE,
972: p_validation_mode => p_validation_mode,
973: P_PLAN_ID => P_CSC_PLAN_LINES_REC.PLAN_ID,
974: p_CONDITION_ID => P_CSC_PLAN_LINES_Rec.CONDITION_ID,
975: x_return_status => x_return_status,

Line 979: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

975: x_return_status => x_return_status,
976: x_msg_count => x_msg_count,
977: x_msg_data => x_msg_data);
978:
979: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
980: raise FND_API.G_EXC_ERROR;
981: END IF;
982: END IF;
983:

Line 980: raise FND_API.G_EXC_ERROR;

976: x_msg_count => x_msg_count,
977: x_msg_data => x_msg_data);
978:
979: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
980: raise FND_API.G_EXC_ERROR;
981: END IF;
982: END IF;
983:
984: