[Home] [Help]
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:
29: ELSIF l_col_length.column_type ='N' AND p_param_length > (l_col_length.precision - l_col_length.scale) 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;
40:
41:
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;
131: CLOSE c_group_id;
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;
141:
143: IF p_group_id IS NULL THEN
144:
145: IF p_person_id IS NOT NULL THEN --When p_group_id is not null and p_person_id is null
146:
147: l_msg_index := igs_ge_msg_stack.count_msg;
148: BEGIN
149: SAVEPOINT REDERIVE_PERSON_STATS_PUB;
150:
151: IGS_AD_UPD_INITIALISE.update_per_stats(p_person_id,NULL);
194:
195: FOR c_person_group_rec in c_person_group
196: LOOP
197: l_ctr := l_ctr + 1;
198: l_msg_index := igs_ge_msg_stack.count_msg;
199: BEGIN
200: SAVEPOINT REDERIVE_PERSON_STATS_PUB;
201: x_return_status_tbl(l_ctr).Person_id := c_person_group_rec.person_id;
202: IGS_AD_UPD_INITIALISE.update_per_stats(c_person_group_rec.person_id,NULL);