75: --If there is only one manager put the mnager's name
76: --
77:
78: IF NO_OF_MANAGERS = 0 THEN
79: fnd_message.set_name('PER', 'HR_NO_CURRENT_MANAGERS');
80: P_MANAGER := fnd_message.get; --'** No Current Managers **';
81: ELSIF NO_OF_MANAGERS = 1 THEN
82: P_MANAGER := MANAGER_NAME;
83: ELSE
76: --
77:
78: IF NO_OF_MANAGERS = 0 THEN
79: fnd_message.set_name('PER', 'HR_NO_CURRENT_MANAGERS');
80: P_MANAGER := fnd_message.get; --'** No Current Managers **';
81: ELSIF NO_OF_MANAGERS = 1 THEN
82: P_MANAGER := MANAGER_NAME;
83: ELSE
84: fnd_message.set_name('PER', 'HR_NUM_CURRENT_MANAGERS');
80: P_MANAGER := fnd_message.get; --'** No Current Managers **';
81: ELSIF NO_OF_MANAGERS = 1 THEN
82: P_MANAGER := MANAGER_NAME;
83: ELSE
84: fnd_message.set_name('PER', 'HR_NUM_CURRENT_MANAGERS');
85: fnd_message.set_token('number', to_char(NO_OF_MANAGERS)); --'** num Current Managers **';
86: P_MANAGER := fnd_message.get;
87: END IF;
88: END;
81: ELSIF NO_OF_MANAGERS = 1 THEN
82: P_MANAGER := MANAGER_NAME;
83: ELSE
84: fnd_message.set_name('PER', 'HR_NUM_CURRENT_MANAGERS');
85: fnd_message.set_token('number', to_char(NO_OF_MANAGERS)); --'** num Current Managers **';
86: P_MANAGER := fnd_message.get;
87: END IF;
88: END;
89: --
82: P_MANAGER := MANAGER_NAME;
83: ELSE
84: fnd_message.set_name('PER', 'HR_NUM_CURRENT_MANAGERS');
85: fnd_message.set_token('number', to_char(NO_OF_MANAGERS)); --'** num Current Managers **';
86: P_MANAGER := fnd_message.get;
87: END IF;
88: END;
89: --
90: --Count the number of organizations that the employee is in
148: --If there is only one organization then put the organization name
149: --
150:
151: IF NO_OF_ORGS = 0 THEN
152: fnd_message.set_name('PER', 'HR_NO_ORGANIZATIONS');
153: P_ORGANIZATION := fnd_message.get; --'** No Organizations **'
154: P_MANAGER_FLAG_DESC := NULL;
155: P_MANAGER_FLAG := NULL;
156: ELSIF NO_OF_ORGS = 1 THEN
149: --
150:
151: IF NO_OF_ORGS = 0 THEN
152: fnd_message.set_name('PER', 'HR_NO_ORGANIZATIONS');
153: P_ORGANIZATION := fnd_message.get; --'** No Organizations **'
154: P_MANAGER_FLAG_DESC := NULL;
155: P_MANAGER_FLAG := NULL;
156: ELSIF NO_OF_ORGS = 1 THEN
157: --
163: (p_effective_date => p_session_date
164: ,p_person_id => p_person_id);
165: --
166: ELSE
167: fnd_message.set_name('PER', 'HR_NUM_ORGANIZATIONS');
168: fnd_message.set_token('number', to_char(NO_OF_ORGS));
169: P_ORGANIZATION := fnd_message.get; --'** num Organizations **'
170: P_MANAGER_FLAG_DESC := NULL;
171: P_MANAGER_FLAG := NULL;
164: ,p_person_id => p_person_id);
165: --
166: ELSE
167: fnd_message.set_name('PER', 'HR_NUM_ORGANIZATIONS');
168: fnd_message.set_token('number', to_char(NO_OF_ORGS));
169: P_ORGANIZATION := fnd_message.get; --'** num Organizations **'
170: P_MANAGER_FLAG_DESC := NULL;
171: P_MANAGER_FLAG := NULL;
172: END IF;
165: --
166: ELSE
167: fnd_message.set_name('PER', 'HR_NUM_ORGANIZATIONS');
168: fnd_message.set_token('number', to_char(NO_OF_ORGS));
169: P_ORGANIZATION := fnd_message.get; --'** num Organizations **'
170: P_MANAGER_FLAG_DESC := NULL;
171: P_MANAGER_FLAG := NULL;
172: END IF;
173: END;