DBA Data[Home] [Help]

APPS.IGS_SS_TST_RSLT_DTLS_PKG dependencies on FND_MSG_PUB

Line 53: FND_MSG_PUB.ADD;

49: --Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
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;

Line 105: FND_MSG_PUB.ADD;

101: IF Upper(Column_Name) = 'TEST_SCORE' OR
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:

Line 131: FND_MSG_PUB.ADD;

127: new_references.ss_test_results_id
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

Line 156: FND_MSG_PUB.ADD;

152: ELSIF NOT Igs_Ad_Test_Results_Pkg.Get_PK_For_Validation (
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

Line 168: FND_MSG_PUB.ADD;

164: new_references.test_segment_id,
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;

Line 277: FND_MSG_PUB.ADD;

273: Fetch cur_rowid INTO lv_rowid;
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;

Line 314: FND_MSG_PUB.ADD;

310: Fetch cur_rowid INTO lv_rowid;
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;

Line 368: FND_MSG_PUB.ADD;

364: Null;
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;

Line 388: FND_MSG_PUB.ADD;

384: -- Call all the procedures related to Before Insert.
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;

Line 466: FND_MSG_PUB.ADD;

462: X_LAST_UPDATED_BY := 1;
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(

Line 545: FND_MSG_PUB.ADD;

541: open c1;
542: fetch c1 into tlinfo;
543: if (c1%notfound) then
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;

Line 561: FND_MSG_PUB.ADD;

557: ) then
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;

Line 595: FND_MSG_PUB.ADD;

591: X_LAST_UPDATED_BY := 1;
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',

Line 665: -- FND_MSG_PUB.initialize;

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.
669: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 694: FND_MSG_PUB.Count_And_Get(

690: X_TEST_SCORE,
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:

Line 703: FND_MSG_PUB.Count_And_Get(

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);
707:

Line 711: FND_MSG_PUB.Count_And_Get(

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);
715: WHEN OTHERS THEN

Line 721: FND_MSG_PUB.ADD;

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;
722:
723: FND_MSG_PUB.Count_And_Get(
724: p_encoded => FND_API.G_FALSE,
725: p_count => x_msg_count,

Line 723: FND_MSG_PUB.Count_And_Get(

719: FND_MESSAGE.SET_NAME('IGS', 'HZ_API_OTHERS_EXCEP');
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;