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.IGS_AD_TST_RSLT_DTLS_PKG dependencies on FND_MESSAGE

Line 75: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

71: Open cur_old_ref_values;
72: Fetch cur_old_ref_values INTO old_references;
73: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
74: Close cur_old_ref_values;
75: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
76: IGS_GE_MSG_STACK.ADD;
77: App_Exception.Raise_Exception;
78: Return;
79: END IF;

Line 167: Fnd_Message.Set_Name('IGS','IGS_AD_PCTL_NOT_GT_100_OR_LT_0');

163: -- The following code checks for check constraints on the Columns.
164: IF Upper(Column_Name) = 'STATE_PERCENTILE' OR
165: Column_Name IS NULL THEN
166: IF NOT (new_references.state_percentile>=0 and new_references.state_percentile<=100) THEN
167: Fnd_Message.Set_Name('IGS','IGS_AD_PCTL_NOT_GT_100_OR_LT_0');
168: IGS_GE_MSG_STACK.ADD;
169: App_Exception.Raise_Exception;
170: END IF;
171: END IF;

Line 177: Fnd_Message.Set_Name('IGS','IGS_AD_PCTLYR_RANK_NOT_LT_0');

173: -- The following code checks for check constraints on the Columns.
174: IF Upper(Column_Name) = 'PERCENTILE_YEAR_RANK' OR
175: Column_Name IS NULL THEN
176: IF NOT (new_references.percentile_year_rank>=0) THEN
177: Fnd_Message.Set_Name('IGS','IGS_AD_PCTLYR_RANK_NOT_LT_0');
178: IGS_GE_MSG_STACK.ADD;
179: App_Exception.Raise_Exception;
180: END IF;
181: END IF;

Line 188: Fnd_Message.Set_Name('IGS','IGS_AD_SB_NOT_LT_0');

184: IF Upper(Column_Name) = 'SCORE_BAND_LOWER' OR
185: Column_Name IS NULL THEN
186: IF NOT (new_references.score_band_lower>=0
187: OR new_references.score_band_lower IS NULL) THEN
188: Fnd_Message.Set_Name('IGS','IGS_AD_SB_NOT_LT_0');
189: IGS_GE_MSG_STACK.ADD;
190: App_Exception.Raise_Exception;
191: END IF;
192: END IF;

Line 199: Fnd_Message.Set_Name('IGS','IGS_AD_SB_NOT_LT_0');

195: IF Upper(Column_Name) = 'SCORE_BAND_UPPER' OR
196: Column_Name IS NULL THEN
197: IF NOT (new_references.score_band_upper>=0
198: OR new_references.score_band_upper IS NULL) THEN
199: Fnd_Message.Set_Name('IGS','IGS_AD_SB_NOT_LT_0');
200: IGS_GE_MSG_STACK.ADD;
201: App_Exception.Raise_Exception;
202: END IF;
203: END IF;

Line 209: Fnd_Message.Set_Name('IGS','IGS_AD_PCTL_NOT_GT_100_OR_LT_0');

205: -- The following code checks for check constraints on the Columns.
206: IF Upper(Column_Name) = 'PERCENTILE' OR
207: Column_Name IS NULL THEN
208: IF NOT (new_references.percentile>=0 and new_references.percentile<=100) THEN
209: Fnd_Message.Set_Name('IGS','IGS_AD_PCTL_NOT_GT_100_OR_LT_0');
210: IGS_GE_MSG_STACK.ADD;
211: App_Exception.Raise_Exception;
212: END IF;
213: END IF;

Line 219: Fnd_Message.Set_Name('IGS','IGS_IGS_AD_PCTL_NOT_GT_100_OR_LT_0');

215: -- The following code checks for check constraints on the Columns.
216: IF Upper(Column_Name) = 'NATIONAL_PERCENTILE' OR
217: Column_Name IS NULL THEN
218: IF NOT (new_references.national_percentile>=0 and new_references.national_percentile<=100) THEN
219: Fnd_Message.Set_Name('IGS','IGS_IGS_AD_PCTL_NOT_GT_100_OR_LT_0');
220: IGS_GE_MSG_STACK.ADD;
221: App_Exception.Raise_Exception;
222: END IF;
223: END IF;

Line 229: Fnd_Message.Set_Name('IGS','IGS_AD_SCORE_NOT_LT_ZERO');

225: -- The following code checks for check constraints on the Columns.
226: IF Upper(Column_Name) = 'TEST_SCORE' OR
227: Column_Name IS NULL THEN
228: IF NOT (new_references.test_score>=0) THEN
229: Fnd_Message.Set_Name('IGS','IGS_AD_SCORE_NOT_LT_ZERO');
230: IGS_GE_MSG_STACK.ADD;
231: App_Exception.Raise_Exception;
232: END IF;
233: END IF;

Line 255: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

251: IF Get_Uk_For_Validation (
252: new_references.test_results_id
253: ,new_references.test_segment_id
254: ) THEN
255: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
256: IGS_GE_MSG_STACK.ADD;
257: app_exception.raise_exception;
258: END IF;
259: END Check_Uniqueness ;

Line 282: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

278: new_references.irregularity_code_id,
279: 'IRREGULARITY_CODE',
280: 'N'
281: ) THEN
282: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
283: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_IRREGULARITY'));
284: IGS_GE_MSG_STACK.ADD;
285: App_Exception.Raise_Exception;
286: END IF;

Line 283: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_IRREGULARITY'));

279: 'IRREGULARITY_CODE',
280: 'N'
281: ) THEN
282: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
283: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_IRREGULARITY'));
284: IGS_GE_MSG_STACK.ADD;
285: App_Exception.Raise_Exception;
286: END IF;
287:

Line 294: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');

290: NULL;
291: ELSIF NOT Igs_Ad_Test_Results_Pkg.Get_PK_For_Validation (
292: new_references.test_results_id
293: ) THEN
294: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
295: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TEST_RESULT'));
296: IGS_GE_MSG_STACK.ADD;
297: App_Exception.Raise_Exception;
298: END IF;

Line 295: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TEST_RESULT'));

291: ELSIF NOT Igs_Ad_Test_Results_Pkg.Get_PK_For_Validation (
292: new_references.test_results_id
293: ) THEN
294: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
295: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TEST_RESULT'));
296: IGS_GE_MSG_STACK.ADD;
297: App_Exception.Raise_Exception;
298: END IF;
299:

Line 307: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

303: ELSIF NOT Igs_Ad_Test_Segments_Pkg.Get_PK_For_Validation (
304: new_references.test_segment_id,
305: 'N'
306: ) THEN
307: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
308: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TEST_SEGMNT'));
309: IGS_GE_MSG_STACK.ADD;
310: App_Exception.Raise_Exception;
311: END IF;

Line 308: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TEST_SEGMNT'));

304: new_references.test_segment_id,
305: 'N'
306: ) THEN
307: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
308: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TEST_SEGMNT'));
309: IGS_GE_MSG_STACK.ADD;
310: App_Exception.Raise_Exception;
311: END IF;
312:

Line 417: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRD_ACDC_FK');

413: Open cur_rowid;
414: Fetch cur_rowid INTO lv_rowid;
415: IF (cur_rowid%FOUND) THEN
416: Close cur_rowid;
417: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRD_ACDC_FK');
418: IGS_GE_MSG_STACK.ADD;
419: App_Exception.Raise_Exception;
420: Return;
421: END IF;

Line 454: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRD_ATR_FK');

450: Open cur_rowid;
451: Fetch cur_rowid INTO lv_rowid;
452: IF (cur_rowid%FOUND) THEN
453: Close cur_rowid;
454: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRD_ATR_FK');
455: IGS_GE_MSG_STACK.ADD;
456: App_Exception.Raise_Exception;
457: Return;
458: END IF;

Line 491: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRD_ATS_FK');

487: Open cur_rowid;
488: Fetch cur_rowid INTO lv_rowid;
489: IF (cur_rowid%FOUND) THEN
490: Close cur_rowid;
491: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATRD_ATS_FK');
492: IGS_GE_MSG_STACK.ADD;
493: App_Exception.Raise_Exception;
494: Return;
495: END IF;

Line 589: fnd_message.set_name ('IGS', 'IGS_AD_TSTRESULT');

585: );
586:
587: EXCEPTION
588: WHEN e_resource_busy_exception THEN
589: fnd_message.set_name ('IGS', 'IGS_AD_TSTRESULT');
590: testResult := fnd_message.get();
591: fnd_message.set_name ('IGS', 'IGS_PR_LOCK_DETECTED');
592: fnd_message.set_token('RECORD',testResult);
593: igs_ge_msg_stack.add;

Line 590: testResult := fnd_message.get();

586:
587: EXCEPTION
588: WHEN e_resource_busy_exception THEN
589: fnd_message.set_name ('IGS', 'IGS_AD_TSTRESULT');
590: testResult := fnd_message.get();
591: fnd_message.set_name ('IGS', 'IGS_PR_LOCK_DETECTED');
592: fnd_message.set_token('RECORD',testResult);
593: igs_ge_msg_stack.add;
594: App_Exception.Raise_Exception;

Line 591: fnd_message.set_name ('IGS', 'IGS_PR_LOCK_DETECTED');

587: EXCEPTION
588: WHEN e_resource_busy_exception THEN
589: fnd_message.set_name ('IGS', 'IGS_AD_TSTRESULT');
590: testResult := fnd_message.get();
591: fnd_message.set_name ('IGS', 'IGS_PR_LOCK_DETECTED');
592: fnd_message.set_token('RECORD',testResult);
593: igs_ge_msg_stack.add;
594: App_Exception.Raise_Exception;
595: END update_parent_composite_score;

Line 592: fnd_message.set_token('RECORD',testResult);

588: WHEN e_resource_busy_exception THEN
589: fnd_message.set_name ('IGS', 'IGS_AD_TSTRESULT');
590: testResult := fnd_message.get();
591: fnd_message.set_name ('IGS', 'IGS_PR_LOCK_DETECTED');
592: fnd_message.set_token('RECORD',testResult);
593: igs_ge_msg_stack.add;
594: App_Exception.Raise_Exception;
595: END update_parent_composite_score;
596:

Line 905: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

901: -- Call all the procedures related to Before Insert.
902: Null;
903: IF Get_Pk_For_Validation(
904: new_references.tst_rslt_dtls_id) THEN
905: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
906: IGS_GE_MSG_STACK.ADD;
907: App_Exception.Raise_Exception;
908: END IF;
909:

Line 914: FND_MESSAGE.SET_NAME('IGS','IGS_AD_NOT_APL_ATTR_TST_SEG');

910: validate_record(l_error,l_message_name,l_entity1,l_entity2,l_entity3);
911:
912: IF l_error = TRUE THEN
913: IF l_message_name = 'IGS_AD_NOT_APL_ATTR_TST_SEG' THEN
914: FND_MESSAGE.SET_NAME('IGS','IGS_AD_NOT_APL_ATTR_TST_SEG');
915: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_entity1);
916: ELSIF l_message_name = 'IGS_AD_TST_TYP_SEG_COM_NOT_EXT' THEN
917: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TST_TYP_SEG_COM_NOT_EXT');
918: ELSIF l_message_name = 'IGS_AD_OUT_OF_RANGE' THEN

Line 915: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_entity1);

911:
912: IF l_error = TRUE THEN
913: IF l_message_name = 'IGS_AD_NOT_APL_ATTR_TST_SEG' THEN
914: FND_MESSAGE.SET_NAME('IGS','IGS_AD_NOT_APL_ATTR_TST_SEG');
915: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_entity1);
916: ELSIF l_message_name = 'IGS_AD_TST_TYP_SEG_COM_NOT_EXT' THEN
917: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TST_TYP_SEG_COM_NOT_EXT');
918: ELSIF l_message_name = 'IGS_AD_OUT_OF_RANGE' THEN
919: FND_MESSAGE.SET_NAME('IGS','IGS_AD_OUT_OF_RANGE');

Line 917: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TST_TYP_SEG_COM_NOT_EXT');

913: IF l_message_name = 'IGS_AD_NOT_APL_ATTR_TST_SEG' THEN
914: FND_MESSAGE.SET_NAME('IGS','IGS_AD_NOT_APL_ATTR_TST_SEG');
915: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_entity1);
916: ELSIF l_message_name = 'IGS_AD_TST_TYP_SEG_COM_NOT_EXT' THEN
917: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TST_TYP_SEG_COM_NOT_EXT');
918: ELSIF l_message_name = 'IGS_AD_OUT_OF_RANGE' THEN
919: FND_MESSAGE.SET_NAME('IGS','IGS_AD_OUT_OF_RANGE');
920: FND_MESSAGE.SET_TOKEN('TEST_SEGMENT',l_entity3);
921: FND_MESSAGE.SET_TOKEN('MIN_SCORE',l_entity1);

Line 919: FND_MESSAGE.SET_NAME('IGS','IGS_AD_OUT_OF_RANGE');

915: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_entity1);
916: ELSIF l_message_name = 'IGS_AD_TST_TYP_SEG_COM_NOT_EXT' THEN
917: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TST_TYP_SEG_COM_NOT_EXT');
918: ELSIF l_message_name = 'IGS_AD_OUT_OF_RANGE' THEN
919: FND_MESSAGE.SET_NAME('IGS','IGS_AD_OUT_OF_RANGE');
920: FND_MESSAGE.SET_TOKEN('TEST_SEGMENT',l_entity3);
921: FND_MESSAGE.SET_TOKEN('MIN_SCORE',l_entity1);
922: FND_MESSAGE.SET_TOKEN('MAX_SCORE',l_entity2);
923: END IF;

Line 920: FND_MESSAGE.SET_TOKEN('TEST_SEGMENT',l_entity3);

916: ELSIF l_message_name = 'IGS_AD_TST_TYP_SEG_COM_NOT_EXT' THEN
917: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TST_TYP_SEG_COM_NOT_EXT');
918: ELSIF l_message_name = 'IGS_AD_OUT_OF_RANGE' THEN
919: FND_MESSAGE.SET_NAME('IGS','IGS_AD_OUT_OF_RANGE');
920: FND_MESSAGE.SET_TOKEN('TEST_SEGMENT',l_entity3);
921: FND_MESSAGE.SET_TOKEN('MIN_SCORE',l_entity1);
922: FND_MESSAGE.SET_TOKEN('MAX_SCORE',l_entity2);
923: END IF;
924: IGS_GE_MSG_STACK.ADD;

Line 921: FND_MESSAGE.SET_TOKEN('MIN_SCORE',l_entity1);

917: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TST_TYP_SEG_COM_NOT_EXT');
918: ELSIF l_message_name = 'IGS_AD_OUT_OF_RANGE' THEN
919: FND_MESSAGE.SET_NAME('IGS','IGS_AD_OUT_OF_RANGE');
920: FND_MESSAGE.SET_TOKEN('TEST_SEGMENT',l_entity3);
921: FND_MESSAGE.SET_TOKEN('MIN_SCORE',l_entity1);
922: FND_MESSAGE.SET_TOKEN('MAX_SCORE',l_entity2);
923: END IF;
924: IGS_GE_MSG_STACK.ADD;
925: App_Exception.Raise_Exception;

Line 922: FND_MESSAGE.SET_TOKEN('MAX_SCORE',l_entity2);

918: ELSIF l_message_name = 'IGS_AD_OUT_OF_RANGE' THEN
919: FND_MESSAGE.SET_NAME('IGS','IGS_AD_OUT_OF_RANGE');
920: FND_MESSAGE.SET_TOKEN('TEST_SEGMENT',l_entity3);
921: FND_MESSAGE.SET_TOKEN('MIN_SCORE',l_entity1);
922: FND_MESSAGE.SET_TOKEN('MAX_SCORE',l_entity2);
923: END IF;
924: IGS_GE_MSG_STACK.ADD;
925: App_Exception.Raise_Exception;
926: END IF;

Line 937: FND_MESSAGE.SET_NAME('IGS','IGS_AD_NOT_APL_ATTR_TST_SEG');

933:
934: validate_record(l_error,l_message_name,l_entity1,l_entity2,l_entity3);
935: IF l_error = TRUE THEN
936: IF l_message_name = 'IGS_AD_NOT_APL_ATTR_TST_SEG' THEN
937: FND_MESSAGE.SET_NAME('IGS','IGS_AD_NOT_APL_ATTR_TST_SEG');
938: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_entity1);
939: ELSIF l_message_name = 'IGS_AD_TST_TYP_SEG_COM_NOT_EXT' THEN
940: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TST_TYP_SEG_COM_NOT_EXT');
941: ELSIF l_message_name = 'IGS_AD_OUT_OF_RANGE' THEN

Line 938: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_entity1);

934: validate_record(l_error,l_message_name,l_entity1,l_entity2,l_entity3);
935: IF l_error = TRUE THEN
936: IF l_message_name = 'IGS_AD_NOT_APL_ATTR_TST_SEG' THEN
937: FND_MESSAGE.SET_NAME('IGS','IGS_AD_NOT_APL_ATTR_TST_SEG');
938: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_entity1);
939: ELSIF l_message_name = 'IGS_AD_TST_TYP_SEG_COM_NOT_EXT' THEN
940: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TST_TYP_SEG_COM_NOT_EXT');
941: ELSIF l_message_name = 'IGS_AD_OUT_OF_RANGE' THEN
942: FND_MESSAGE.SET_NAME('IGS','IGS_AD_OUT_OF_RANGE');

Line 940: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TST_TYP_SEG_COM_NOT_EXT');

936: IF l_message_name = 'IGS_AD_NOT_APL_ATTR_TST_SEG' THEN
937: FND_MESSAGE.SET_NAME('IGS','IGS_AD_NOT_APL_ATTR_TST_SEG');
938: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_entity1);
939: ELSIF l_message_name = 'IGS_AD_TST_TYP_SEG_COM_NOT_EXT' THEN
940: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TST_TYP_SEG_COM_NOT_EXT');
941: ELSIF l_message_name = 'IGS_AD_OUT_OF_RANGE' THEN
942: FND_MESSAGE.SET_NAME('IGS','IGS_AD_OUT_OF_RANGE');
943: FND_MESSAGE.SET_TOKEN('MIN_SCORE',l_entity1);
944: FND_MESSAGE.SET_TOKEN('MAX_SCORE',l_entity2);

Line 942: FND_MESSAGE.SET_NAME('IGS','IGS_AD_OUT_OF_RANGE');

938: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_entity1);
939: ELSIF l_message_name = 'IGS_AD_TST_TYP_SEG_COM_NOT_EXT' THEN
940: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TST_TYP_SEG_COM_NOT_EXT');
941: ELSIF l_message_name = 'IGS_AD_OUT_OF_RANGE' THEN
942: FND_MESSAGE.SET_NAME('IGS','IGS_AD_OUT_OF_RANGE');
943: FND_MESSAGE.SET_TOKEN('MIN_SCORE',l_entity1);
944: FND_MESSAGE.SET_TOKEN('MAX_SCORE',l_entity2);
945: FND_MESSAGE.SET_TOKEN('TEST_SEGMENT',l_entity3);
946: END IF;

Line 943: FND_MESSAGE.SET_TOKEN('MIN_SCORE',l_entity1);

939: ELSIF l_message_name = 'IGS_AD_TST_TYP_SEG_COM_NOT_EXT' THEN
940: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TST_TYP_SEG_COM_NOT_EXT');
941: ELSIF l_message_name = 'IGS_AD_OUT_OF_RANGE' THEN
942: FND_MESSAGE.SET_NAME('IGS','IGS_AD_OUT_OF_RANGE');
943: FND_MESSAGE.SET_TOKEN('MIN_SCORE',l_entity1);
944: FND_MESSAGE.SET_TOKEN('MAX_SCORE',l_entity2);
945: FND_MESSAGE.SET_TOKEN('TEST_SEGMENT',l_entity3);
946: END IF;
947: IGS_GE_MSG_STACK.ADD;

Line 944: FND_MESSAGE.SET_TOKEN('MAX_SCORE',l_entity2);

940: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TST_TYP_SEG_COM_NOT_EXT');
941: ELSIF l_message_name = 'IGS_AD_OUT_OF_RANGE' THEN
942: FND_MESSAGE.SET_NAME('IGS','IGS_AD_OUT_OF_RANGE');
943: FND_MESSAGE.SET_TOKEN('MIN_SCORE',l_entity1);
944: FND_MESSAGE.SET_TOKEN('MAX_SCORE',l_entity2);
945: FND_MESSAGE.SET_TOKEN('TEST_SEGMENT',l_entity3);
946: END IF;
947: IGS_GE_MSG_STACK.ADD;
948: App_Exception.Raise_Exception;

Line 945: FND_MESSAGE.SET_TOKEN('TEST_SEGMENT',l_entity3);

941: ELSIF l_message_name = 'IGS_AD_OUT_OF_RANGE' THEN
942: FND_MESSAGE.SET_NAME('IGS','IGS_AD_OUT_OF_RANGE');
943: FND_MESSAGE.SET_TOKEN('MIN_SCORE',l_entity1);
944: FND_MESSAGE.SET_TOKEN('MAX_SCORE',l_entity2);
945: FND_MESSAGE.SET_TOKEN('TEST_SEGMENT',l_entity3);
946: END IF;
947: IGS_GE_MSG_STACK.ADD;
948: App_Exception.Raise_Exception;
949: END IF;

Line 961: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

957: ELSIF (p_action = 'VALIDATE_INSERT') THEN
958: -- Call all the procedures related to Before Insert.
959: IF Get_PK_For_Validation (
960: new_references.tst_rslt_dtls_id) THEN
961: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
962: IGS_GE_MSG_STACK.ADD;
963: App_Exception.Raise_Exception;
964: END IF;
965:

Line 1156: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

1152: else
1153: X_PROGRAM_UPDATE_DATE := SYSDATE;
1154: end if;
1155: else
1156: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1157: IGS_GE_MSG_STACK.ADD;
1158: app_exception.raise_exception;
1159: end if;
1160:

Line 1311: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');

1307: );
1308: EXCEPTION
1309: WHEN OTHERS THEN
1310: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1311: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1312: fnd_message.set_token ('ERR_CD', SQLCODE);
1313: igs_ge_msg_stack.add;
1314: igs_sc_gen_001.unset_ctx('R');
1315: app_exception.raise_exception;

Line 1312: fnd_message.set_token ('ERR_CD', SQLCODE);

1308: EXCEPTION
1309: WHEN OTHERS THEN
1310: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1311: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1312: fnd_message.set_token ('ERR_CD', SQLCODE);
1313: igs_ge_msg_stack.add;
1314: igs_sc_gen_001.unset_ctx('R');
1315: app_exception.raise_exception;
1316: ELSE

Line 1407: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

1403: begin
1404: open c1;
1405: fetch c1 into tlinfo;
1406: if (c1%notfound) then
1407: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1408: IGS_GE_MSG_STACK.ADD;
1409: close c1;
1410: app_exception.raise_exception;
1411: return;

Line 1506: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

1502: AND (X_ATTRIBUTE20 is null)))
1503: ) then
1504: null;
1505: else
1506: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1507: IGS_GE_MSG_STACK.ADD;
1508: app_exception.raise_exception;
1509: end if;
1510: return;

Line 1587: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

1583: if X_LAST_UPDATE_LOGIN is NULL then
1584: X_LAST_UPDATE_LOGIN := -1;
1585: end if;
1586: else
1587: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1588: IGS_GE_MSG_STACK.ADD;
1589: app_exception.raise_exception;
1590: end if;
1591: Before_DML(

Line 1690: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

1686: PROGRAM_APPLICATION_ID = PROGRAM_APPLICATION_ID,
1687: PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
1688: where ROWID = X_ROWID;
1689: if (sql%notfound) then
1690: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1691: igs_ge_msg_stack.add;
1692: igs_sc_gen_001.unset_ctx('R');
1693: app_exception.raise_exception;
1694: end if;

Line 1708: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');

1704: );
1705: EXCEPTION
1706: WHEN OTHERS THEN
1707: IF (SQLCODE = (-28115)) THEN
1708: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1709: fnd_message.set_token ('ERR_CD', SQLCODE);
1710: igs_ge_msg_stack.add;
1711: igs_sc_gen_001.unset_ctx('R');
1712: app_exception.raise_exception;

Line 1709: fnd_message.set_token ('ERR_CD', SQLCODE);

1705: EXCEPTION
1706: WHEN OTHERS THEN
1707: IF (SQLCODE = (-28115)) THEN
1708: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1709: fnd_message.set_token ('ERR_CD', SQLCODE);
1710: igs_ge_msg_stack.add;
1711: igs_sc_gen_001.unset_ctx('R');
1712: app_exception.raise_exception;
1713: ELSE

Line 1880: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

1876: END IF;
1877: delete from IGS_AD_TST_RSLT_DTLS
1878: where ROWID = X_ROWID;
1879: if (sql%notfound) then
1880: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1881: igs_ge_msg_stack.add;
1882: igs_sc_gen_001.unset_ctx('R');
1883: app_exception.raise_exception;
1884: end if;