DBA Data[Home] [Help]

APPS.IGS_RATINGS_PUB dependencies on FND_MESSAGE

Line 23: FND_MESSAGE.SET_NAME('IGS','IGS_AD_EXCEED_MAX_LENGTH');

19: FETCH c_col_length INTO l_col_length;
20: CLOSE c_col_length;
21: IF l_col_length.column_type = 'V' AND p_param_length > l_col_length.width THEN
22: --- DBMS_OUTPUT.PUT_LINE('failure ' || l_col_length.width);
23: FND_MESSAGE.SET_NAME('IGS','IGS_AD_EXCEED_MAX_LENGTH');
24: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
25: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.width);
26: IGS_GE_MSG_STACK.ADD;
27: RAISE FND_API.G_EXC_ERROR;

Line 24: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);

20: CLOSE c_col_length;
21: IF l_col_length.column_type = 'V' AND p_param_length > l_col_length.width THEN
22: --- DBMS_OUTPUT.PUT_LINE('failure ' || l_col_length.width);
23: FND_MESSAGE.SET_NAME('IGS','IGS_AD_EXCEED_MAX_LENGTH');
24: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
25: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.width);
26: IGS_GE_MSG_STACK.ADD;
27: RAISE FND_API.G_EXC_ERROR;
28:

Line 25: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.width);

21: IF l_col_length.column_type = 'V' AND p_param_length > l_col_length.width THEN
22: --- DBMS_OUTPUT.PUT_LINE('failure ' || l_col_length.width);
23: FND_MESSAGE.SET_NAME('IGS','IGS_AD_EXCEED_MAX_LENGTH');
24: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
25: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.width);
26: IGS_GE_MSG_STACK.ADD;
27: RAISE FND_API.G_EXC_ERROR;
28:
29:

Line 32: FND_MESSAGE.SET_NAME('IGS','IGS_AD_EXCEED_MAX_LENGTH');

28:
29:
30: ELSIF l_col_length.column_type ='N' AND p_param_length > l_col_length.precision THEN
31: -- DBMS_OUTPUT.PUT_LINE('failure ' || l_col_length.precision);
32: FND_MESSAGE.SET_NAME('IGS','IGS_AD_EXCEED_MAX_LENGTH');
33: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
34: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.precision);
35: IGS_GE_MSG_STACK.ADD;
36: RAISE FND_API.G_EXC_ERROR;

Line 33: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);

29:
30: ELSIF l_col_length.column_type ='N' AND p_param_length > l_col_length.precision THEN
31: -- DBMS_OUTPUT.PUT_LINE('failure ' || l_col_length.precision);
32: FND_MESSAGE.SET_NAME('IGS','IGS_AD_EXCEED_MAX_LENGTH');
33: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
34: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.precision);
35: IGS_GE_MSG_STACK.ADD;
36: RAISE FND_API.G_EXC_ERROR;
37: END IF;

Line 34: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.precision);

30: ELSIF l_col_length.column_type ='N' AND p_param_length > l_col_length.precision THEN
31: -- DBMS_OUTPUT.PUT_LINE('failure ' || l_col_length.precision);
32: FND_MESSAGE.SET_NAME('IGS','IGS_AD_EXCEED_MAX_LENGTH');
33: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
34: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.precision);
35: IGS_GE_MSG_STACK.ADD;
36: RAISE FND_API.G_EXC_ERROR;
37: END IF;
38:

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

388: FETCH c_aplinst_cur
389: INTO l_c_aplinst_cur;
390: CLOSE c_aplinst_cur;
391: IF l_c_aplinst_cur.person_id IS NULL THEN
392: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
393: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM_APPL'));
394: IGS_GE_MSG_STACK.ADD;
395: RAISE FND_API.G_EXC_ERROR;
396: END IF;

Line 393: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM_APPL'));

389: INTO l_c_aplinst_cur;
390: CLOSE c_aplinst_cur;
391: IF l_c_aplinst_cur.person_id IS NULL THEN
392: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
393: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM_APPL'));
394: IGS_GE_MSG_STACK.ADD;
395: RAISE FND_API.G_EXC_ERROR;
396: END IF;
397: --Get the Evaluation Type associated with the entered Application Review Profile Name

Line 413: FND_MESSAGE.SET_NAME('IGS','IGS_AD_REV_PRF_EXISTS');

409: FETCH c_get_appl_rev_profile_id INTO l_exist_arp;
410: CLOSE c_get_appl_rev_profile_id;
411:
412: IF l_exist_arp.appl_rev_profile_id IS NOT NULL THEN
413: FND_MESSAGE.SET_NAME('IGS','IGS_AD_REV_PRF_EXISTS');
414: IGS_GE_MSG_STACK.ADD;
415: RAISE FND_API.G_EXC_ERROR;
416: END IF;
417:

Line 426: fnd_message.set_name('IGS', 'IGS_AD_DIFF_EVAL_TYPE');

422:
423:
424: -- Review Group and Review Profile is already attached and evaluation type is
425: IF l_exist_eval_type IS NOT NULL AND l_exist_eval_type <> l_modif_eval_type THEN
426: fnd_message.set_name('IGS', 'IGS_AD_DIFF_EVAL_TYPE');
427: IGS_GE_MSG_STACK.ADD;
428: RAISE FND_API.G_EXC_ERROR;
429: ELSIF l_exist_eval_type IS NOT NULL THEN
430: OPEN get_rating_cur(

Line 439: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CANT_UPD_RAT_PRSNT');

435: );
436: FETCH get_rating_cur INTO l_rating;
437: -- If rating is defined for atleast one of the evaluator records then update is not allowed
438: IF (get_rating_cur%FOUND) THEN
439: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CANT_UPD_RAT_PRSNT');
440: IGS_GE_MSG_STACK.ADD;
441: CLOSE get_rating_cur;
442: RAISE FND_API.G_EXC_ERROR;
443: END IF;

Line 460: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DIFF_EVAL_TYPE');

456: CLOSE c_get_current_eval;
457:
458: IF l_get_current_eval IS NOT NULL THEN
459: IF (l_modif_eval_type = 'S') THEN
460: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DIFF_EVAL_TYPE');
461: IGS_GE_MSG_STACK.ADD;
462: RAISE FND_API.G_EXC_ERROR;
463: END IF;
464: END IF;

Line 478: FND_MESSAGE.SET_NAME('IGS','IGS_AD_OTCM_DOC_STAT');

474: CLOSE doc_cur;
475: --Validtion to check Outcome Status = PENDING is already present in TBH.
476: -- The following to check the documentation status is satisfied or NOT.
477: IF l_adm_doc <> 'SATISFIED' THEN
478: FND_MESSAGE.SET_NAME('IGS','IGS_AD_OTCM_DOC_STAT');
479: IGS_GE_MSG_STACK.ADD;
480: RAISE FND_API.G_EXC_ERROR;
481: END IF;
482: