DBA Data[Home] [Help]

APPS.IGS_SS_TST_RSLT_DTLS_PKG dependencies on FND_API

Line 54: RAISE FND_API.G_EXC_ERROR;

50: -- bug#2413811 - Nishikant - 13jun2002
51: -- The below message was being set with FND application, which got modified to IGS.
52: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SCORE_NOT_LT_ZERO');
53: FND_MSG_PUB.ADD;
54: RAISE FND_API.G_EXC_ERROR;
55: Return;
56: END IF;
57: Close cur_old_ref_values;
58:

Line 106: RAISE FND_API.G_EXC_ERROR;

102: Column_Name IS NULL THEN
103: IF NOT (new_references.test_score>=0) THEN
104: Fnd_Message.Set_Name('IGS','IGS_AD_SCORE_NOT_LT_ZERO');
105: FND_MSG_PUB.ADD;
106: RAISE FND_API.G_EXC_ERROR;
107: END IF;
108: END IF;
109:
110:

Line 132: RAISE FND_API.G_EXC_ERROR;

128: ,new_references.test_segment_id
129: ) THEN
130: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
131: FND_MSG_PUB.ADD;
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134: END Check_Uniqueness ;
135: PROCEDURE Check_Parent_Existance AS
136: /*************************************************************

Line 157: RAISE FND_API.G_EXC_ERROR;

153: new_references.SS_test_results_id
154: ) THEN
155: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
156: FND_MSG_PUB.ADD;
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160: IF (((old_references.test_segment_id = new_references.test_segment_id)) OR
161: ((new_references.test_segment_id IS NULL))) THEN

Line 169: RAISE FND_API.G_EXC_ERROR;

165: 'N'
166: ) THEN
167: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
168: FND_MSG_PUB.ADD;
169: RAISE FND_API.G_EXC_ERROR;
170: END IF;
171:
172: END Check_Parent_Existance;
173:

Line 278: RAISE FND_API.G_EXC_ERROR;

274: IF (cur_rowid%FOUND) THEN
275: Close cur_rowid;
276: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRD_ATR_FK');
277: FND_MSG_PUB.ADD;
278: RAISE FND_API.G_EXC_ERROR;
279: Return;
280: END IF;
281: Close cur_rowid;
282:

Line 315: RAISE FND_API.G_EXC_ERROR;

311: IF (cur_rowid%FOUND) THEN
312: Close cur_rowid;
313: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRD_ATS_FK');
314: FND_MSG_PUB.ADD;
315: RAISE FND_API.G_EXC_ERROR;
316: Return;
317: END IF;
318: Close cur_rowid;
319:

Line 369: RAISE FND_API.G_EXC_ERROR;

365: IF Get_Pk_For_Validation(
366: new_references.ss_tst_rslt_dtls_id) THEN
367: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
368: FND_MSG_PUB.ADD;
369: RAISE FND_API.G_EXC_ERROR;
370: END IF;
371: Check_Uniqueness;
372: Check_Constraints;
373: --Check_Parent_Existance;

Line 389: RAISE FND_API.G_EXC_ERROR;

385: IF Get_PK_For_Validation (
386: new_references.ss_tst_rslt_dtls_id) THEN
387: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
388: FND_MSG_PUB.ADD;
389: RAISE FND_API.G_EXC_ERROR;
390: END IF;
391: Check_Uniqueness;
392: Check_Constraints;
393: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 467: RAISE FND_API.G_EXC_ERROR;

463: X_LAST_UPDATE_LOGIN := 0;
464: else
465: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
466: FND_MSG_PUB.ADD;
467: RAISE FND_API.G_EXC_ERROR;
468: end if;
469: SELECT IGS_SS_TST_RSLT_DTLS_S.NEXTVAL INTO X_TST_RSLT_DTLS_ID FROM DUAL;
470: Before_DML(
471: p_action=>'INSERT',

Line 548: RAISE FND_API.G_EXC_ERROR;

544: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
545: FND_MSG_PUB.ADD;
546:
547: close c1;
548: RAISE FND_API.G_EXC_ERROR;
549: return;
550: end if;
551: close c1;
552: if ( ( tlinfo.SS_TEST_RESULTS_ID = X_TEST_RESULTS_ID)

Line 562: RAISE FND_API.G_EXC_ERROR;

558: null;
559: else
560: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
561: FND_MSG_PUB.ADD;
562: RAISE FND_API.G_EXC_ERROR;
563: end if;
564: return;
565: end LOCK_ROW;
566: Procedure UPDATE_ROW (

Line 596: RAISE FND_API.G_EXC_ERROR;

592: X_LAST_UPDATE_LOGIN := 0;
593: else
594: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
595: FND_MSG_PUB.ADD;
596: RAISE FND_API.G_EXC_ERROR;
597: end if;
598: Before_DML(
599: p_action=>'UPDATE',
600: x_rowid=>X_ROWID,

Line 664: -- IF FND_API.to_Boolean(p_init_msg_list) THEN

660: --Standard start of API savepoint
661: SAVEPOINT update_test_result_details;
662:
663: --Initialize message list if p_init_msg_list is set to TRUE.
664: -- IF FND_API.to_Boolean(p_init_msg_list) THEN
665: -- FND_MSG_PUB.initialize;
666: -- END IF;
667:
668: --Initialize API return status to success.

Line 669: x_return_status := FND_API.G_RET_STS_SUCCESS;

665: -- FND_MSG_PUB.initialize;
666: -- END IF;
667:
668: --Initialize API return status to success.
669: x_return_status := FND_API.G_RET_STS_SUCCESS;
670:
671: open c1;
672: fetch c1 into X_ROWID;
673: if (c1%notfound) then

Line 695: p_encoded => FND_API.G_FALSE,

691: X_MODE );
692:
693: --Standard call to get message count and if count is 1, get message info.
694: FND_MSG_PUB.Count_And_Get(
695: p_encoded => FND_API.G_FALSE,
696: p_count => x_msg_count,
697: p_data => x_msg_data);
698:
699: EXCEPTION

Line 700: WHEN FND_API.G_EXC_ERROR THEN

696: p_count => x_msg_count,
697: p_data => x_msg_data);
698:
699: EXCEPTION
700: WHEN FND_API.G_EXC_ERROR THEN
701: ROLLBACK TO update_test_result_details;
702: x_return_status := FND_API.G_RET_STS_ERROR;
703: FND_MSG_PUB.Count_And_Get(
704: p_encoded => FND_API.G_FALSE,

Line 702: x_return_status := FND_API.G_RET_STS_ERROR;

698:
699: EXCEPTION
700: WHEN FND_API.G_EXC_ERROR THEN
701: ROLLBACK TO update_test_result_details;
702: x_return_status := FND_API.G_RET_STS_ERROR;
703: FND_MSG_PUB.Count_And_Get(
704: p_encoded => FND_API.G_FALSE,
705: p_count => x_msg_count,
706: p_data => x_msg_data);

Line 704: p_encoded => FND_API.G_FALSE,

700: WHEN FND_API.G_EXC_ERROR THEN
701: ROLLBACK TO update_test_result_details;
702: x_return_status := FND_API.G_RET_STS_ERROR;
703: FND_MSG_PUB.Count_And_Get(
704: p_encoded => FND_API.G_FALSE,
705: p_count => x_msg_count,
706: p_data => x_msg_data);
707:
708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

704: p_encoded => FND_API.G_FALSE,
705: p_count => x_msg_count,
706: p_data => x_msg_data);
707:
708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
709: ROLLBACK TO update_test_result_details;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: FND_MSG_PUB.Count_And_Get(
712: p_encoded => FND_API.G_FALSE,

Line 710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

706: p_data => x_msg_data);
707:
708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
709: ROLLBACK TO update_test_result_details;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: FND_MSG_PUB.Count_And_Get(
712: p_encoded => FND_API.G_FALSE,
713: p_count => x_msg_count,
714: p_data => x_msg_data);

Line 712: p_encoded => FND_API.G_FALSE,

708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
709: ROLLBACK TO update_test_result_details;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: FND_MSG_PUB.Count_And_Get(
712: p_encoded => FND_API.G_FALSE,
713: p_count => x_msg_count,
714: p_data => x_msg_data);
715: WHEN OTHERS THEN
716: ROLLBACK TO update_test_result_details;

Line 717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

713: p_count => x_msg_count,
714: p_data => x_msg_data);
715: WHEN OTHERS THEN
716: ROLLBACK TO update_test_result_details;
717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
718:
719: FND_MESSAGE.SET_NAME('IGS', 'HZ_API_OTHERS_EXCEP');
720: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
721: FND_MSG_PUB.ADD;

Line 724: p_encoded => FND_API.G_FALSE,

720: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
721: FND_MSG_PUB.ADD;
722:
723: FND_MSG_PUB.Count_And_Get(
724: p_encoded => FND_API.G_FALSE,
725: p_count => x_msg_count,
726: p_data => x_msg_data);
727: end ADD_ROW;
728: END IGS_SS_TST_RSLT_DTLS_PKG;