APPS.IGS_PERSONSTATS_PUB dependencies on FND_MESSAGE

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

18: OPEN c_col_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: FND_MESSAGE.SET_NAME('IGS','IGS_AD_EXCEED_MAX_LENGTH');
23: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
24: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.width);
25: IGS_GE_MSG_STACK.ADD;
26: RAISE FND_API.G_EXC_ERROR;

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

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: FND_MESSAGE.SET_NAME('IGS','IGS_AD_EXCEED_MAX_LENGTH');
23: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
24: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.width);
25: IGS_GE_MSG_STACK.ADD;
26: RAISE FND_API.G_EXC_ERROR;
27:

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

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

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

26: RAISE FND_API.G_EXC_ERROR;
27:
28:
29: ELSIF l_col_length.column_type ='N' AND p_param_length > (l_col_length.precision - l_col_length.scale) THEN
30: FND_MESSAGE.SET_NAME('IGS','IGS_AD_EXCEED_MAX_LENGTH');
31: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
32: IF l_col_length.scale > 0 THEN
33: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.precision || ',' || l_col_length.scale);
34: ELSE

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

27:
28:
29: ELSIF l_col_length.column_type ='N' AND p_param_length > (l_col_length.precision - l_col_length.scale) THEN
30: FND_MESSAGE.SET_NAME('IGS','IGS_AD_EXCEED_MAX_LENGTH');
31: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
32: IF l_col_length.scale > 0 THEN
33: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.precision || ',' || l_col_length.scale);
34: ELSE
35: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.precision );

Line 33: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.precision || ',' || l_col_length.scale);

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

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

31: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
32: IF l_col_length.scale > 0 THEN
33: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.precision || ',' || l_col_length.scale);
34: ELSE
35: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.precision );
36: END IF;
37: IGS_GE_MSG_STACK.ADD;
38: RAISE FND_API.G_EXC_ERROR;
39: END IF;

Line 126: FND_MESSAGE.SET_NAME('IGS','IGS_AD_INVALID_PER_ID_GRP');

122: THEN
123: OPEN c_group_id(p_person_id,p_group_id);
124: FETCH c_group_id INTO l_exists;
125: IF c_group_id%NOTFOUND THEN
126: FND_MESSAGE.SET_NAME('IGS','IGS_AD_INVALID_PER_ID_GRP');
127: IGS_GE_MSG_STACK.ADD;
128: RAISE FND_API.G_EXC_ERROR;
129:
130: END IF;

Line 136: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRS_PRSIDGRP_NULL');

132: END IF;
133:
134: IF p_group_id IS NULL and p_person_id IS NULL
135: THEN
136: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRS_PRSIDGRP_NULL');
137: IGS_GE_MSG_STACK.ADD;
138: RAISE FND_API.G_EXC_ERROR;
139:
140: END IF;