73: --If there is only one manager put the mnager's name
74: --
75:
76: IF NO_OF_MANAGERS = 0 THEN
77: fnd_message.set_name('PER', 'HR_NO_CURRENT_MANAGERS');
78: P_MANAGER := fnd_message.get; --'** No Current Managers **';
79: ELSIF NO_OF_MANAGERS = 1 THEN
80: P_MANAGER := MANAGER_NAME;
81: ELSE
74: --
75:
76: IF NO_OF_MANAGERS = 0 THEN
77: fnd_message.set_name('PER', 'HR_NO_CURRENT_MANAGERS');
78: P_MANAGER := fnd_message.get; --'** No Current Managers **';
79: ELSIF NO_OF_MANAGERS = 1 THEN
80: P_MANAGER := MANAGER_NAME;
81: ELSE
82: fnd_message.set_name('PER', 'HR_NUM_CURRENT_MANAGERS');
78: P_MANAGER := fnd_message.get; --'** No Current Managers **';
79: ELSIF NO_OF_MANAGERS = 1 THEN
80: P_MANAGER := MANAGER_NAME;
81: ELSE
82: fnd_message.set_name('PER', 'HR_NUM_CURRENT_MANAGERS');
83: fnd_message.set_token('number', to_char(NO_OF_MANAGERS)); --'** num Current Managers **';
84: P_MANAGER := fnd_message.get;
85: END IF;
86: END;
79: ELSIF NO_OF_MANAGERS = 1 THEN
80: P_MANAGER := MANAGER_NAME;
81: ELSE
82: fnd_message.set_name('PER', 'HR_NUM_CURRENT_MANAGERS');
83: fnd_message.set_token('number', to_char(NO_OF_MANAGERS)); --'** num Current Managers **';
84: P_MANAGER := fnd_message.get;
85: END IF;
86: END;
87: --
80: P_MANAGER := MANAGER_NAME;
81: ELSE
82: fnd_message.set_name('PER', 'HR_NUM_CURRENT_MANAGERS');
83: fnd_message.set_token('number', to_char(NO_OF_MANAGERS)); --'** num Current Managers **';
84: P_MANAGER := fnd_message.get;
85: END IF;
86: END;
87: --
88: --Count the number of organizations that the employee is in
141: --If there is only one organization then put the organization name
142: --
143:
144: IF NO_OF_ORGS = 0 THEN
145: fnd_message.set_name('PER', 'HR_NO_ORGANIZATIONS');
146: P_ORGANIZATION := fnd_message.get; --'** No Organizations **'
147: P_MANAGER_FLAG_DESC := NULL;
148: P_MANAGER_FLAG := NULL;
149: ELSIF NO_OF_ORGS = 1 THEN
142: --
143:
144: IF NO_OF_ORGS = 0 THEN
145: fnd_message.set_name('PER', 'HR_NO_ORGANIZATIONS');
146: P_ORGANIZATION := fnd_message.get; --'** No Organizations **'
147: P_MANAGER_FLAG_DESC := NULL;
148: P_MANAGER_FLAG := NULL;
149: ELSIF NO_OF_ORGS = 1 THEN
150: --
156: (p_effective_date => p_session_date
157: ,p_person_id => p_person_id);
158: --
159: ELSE
160: fnd_message.set_name('PER', 'HR_NUM_ORGANIZATIONS');
161: fnd_message.set_token('number', to_char(NO_OF_ORGS));
162: P_ORGANIZATION := fnd_message.get; --'** num Organizations **'
163: P_MANAGER_FLAG_DESC := NULL;
164: P_MANAGER_FLAG := NULL;
157: ,p_person_id => p_person_id);
158: --
159: ELSE
160: fnd_message.set_name('PER', 'HR_NUM_ORGANIZATIONS');
161: fnd_message.set_token('number', to_char(NO_OF_ORGS));
162: P_ORGANIZATION := fnd_message.get; --'** num Organizations **'
163: P_MANAGER_FLAG_DESC := NULL;
164: P_MANAGER_FLAG := NULL;
165: END IF;
158: --
159: ELSE
160: fnd_message.set_name('PER', 'HR_NUM_ORGANIZATIONS');
161: fnd_message.set_token('number', to_char(NO_OF_ORGS));
162: P_ORGANIZATION := fnd_message.get; --'** num Organizations **'
163: P_MANAGER_FLAG_DESC := NULL;
164: P_MANAGER_FLAG := NULL;
165: END IF;
166: END;