DBA Data[Home] [Help]

APPS.HR_NL_UTILITY dependencies on HR_UTILITY

Line 92: hr_utility.set_location(' entered per_nl_full_name',10);

88: BEGIN
89:
90: /* 6891179 */
91:
92: hr_utility.set_location(' entered per_nl_full_name',10);
93: hr_utility.set_location(' session id :='||USERENV('sessionid'),10);
94: hr_utility.set_location(' hr_util_misc_ss.g_eff_date'||hr_util_misc_ss.g_eff_date,10000);
95:
96: /* 8680292 */

Line 93: hr_utility.set_location(' session id :='||USERENV('sessionid'),10);

89:
90: /* 6891179 */
91:
92: hr_utility.set_location(' entered per_nl_full_name',10);
93: hr_utility.set_location(' session id :='||USERENV('sessionid'),10);
94: hr_utility.set_location(' hr_util_misc_ss.g_eff_date'||hr_util_misc_ss.g_eff_date,10000);
95:
96: /* 8680292 */
97: --

Line 94: hr_utility.set_location(' hr_util_misc_ss.g_eff_date'||hr_util_misc_ss.g_eff_date,10000);

90: /* 6891179 */
91:
92: hr_utility.set_location(' entered per_nl_full_name',10);
93: hr_utility.set_location(' session id :='||USERENV('sessionid'),10);
94: hr_utility.set_location(' hr_util_misc_ss.g_eff_date'||hr_util_misc_ss.g_eff_date,10000);
95:
96: /* 8680292 */
97: --
98: -- hr_util_misc_ss.setEffectiveDate(hr_util_misc_ss.g_eff_date);

Line 101: hr_utility.set_location(' hr_util_misc_ss.g_eff_date'||hr_util_misc_ss.g_eff_date,10);

97: --
98: -- hr_util_misc_ss.setEffectiveDate(hr_util_misc_ss.g_eff_date);
99: --
100:
101: hr_utility.set_location(' hr_util_misc_ss.g_eff_date'||hr_util_misc_ss.g_eff_date,10);
102: hr_utility.set_location('p_per_information5 '||p_per_information5,10);
103: hr_utility.set_location(' p_per_information6 '||p_per_information6,10);
104: hr_utility.set_location(' per_per_shd.g_old_rec.person_id'||per_per_shd.g_old_rec.person_id,20);
105:

Line 102: hr_utility.set_location('p_per_information5 '||p_per_information5,10);

98: -- hr_util_misc_ss.setEffectiveDate(hr_util_misc_ss.g_eff_date);
99: --
100:
101: hr_utility.set_location(' hr_util_misc_ss.g_eff_date'||hr_util_misc_ss.g_eff_date,10);
102: hr_utility.set_location('p_per_information5 '||p_per_information5,10);
103: hr_utility.set_location(' p_per_information6 '||p_per_information6,10);
104: hr_utility.set_location(' per_per_shd.g_old_rec.person_id'||per_per_shd.g_old_rec.person_id,20);
105:
106: hr_utility.set_location('Before cur_effective_date cursor ',30);

Line 103: hr_utility.set_location(' p_per_information6 '||p_per_information6,10);

99: --
100:
101: hr_utility.set_location(' hr_util_misc_ss.g_eff_date'||hr_util_misc_ss.g_eff_date,10);
102: hr_utility.set_location('p_per_information5 '||p_per_information5,10);
103: hr_utility.set_location(' p_per_information6 '||p_per_information6,10);
104: hr_utility.set_location(' per_per_shd.g_old_rec.person_id'||per_per_shd.g_old_rec.person_id,20);
105:
106: hr_utility.set_location('Before cur_effective_date cursor ',30);
107:

Line 104: hr_utility.set_location(' per_per_shd.g_old_rec.person_id'||per_per_shd.g_old_rec.person_id,20);

100:
101: hr_utility.set_location(' hr_util_misc_ss.g_eff_date'||hr_util_misc_ss.g_eff_date,10);
102: hr_utility.set_location('p_per_information5 '||p_per_information5,10);
103: hr_utility.set_location(' p_per_information6 '||p_per_information6,10);
104: hr_utility.set_location(' per_per_shd.g_old_rec.person_id'||per_per_shd.g_old_rec.person_id,20);
105:
106: hr_utility.set_location('Before cur_effective_date cursor ',30);
107:
108: /* 8680292 */

Line 106: hr_utility.set_location('Before cur_effective_date cursor ',30);

102: hr_utility.set_location('p_per_information5 '||p_per_information5,10);
103: hr_utility.set_location(' p_per_information6 '||p_per_information6,10);
104: hr_utility.set_location(' per_per_shd.g_old_rec.person_id'||per_per_shd.g_old_rec.person_id,20);
105:
106: hr_utility.set_location('Before cur_effective_date cursor ',30);
107:
108: /* 8680292 */
109: /* Replaces l_effective_date by hr_util_misc_ss.g_eff_date
110: --

Line 114: hr_utility.set_location(' l_effective_Date '||l_effective_date,30);

110: --
111: OPEN cur_effective_date;
112: FETCH cur_effective_date INTO l_effective_date;
113: CLOSE cur_effective_date;
114: hr_utility.set_location(' l_effective_Date '||l_effective_date,30);
115: */
116: --
117: open cur_contact_person_id(hr_util_misc_ss.g_eff_date);
118: fetch cur_contact_person_id into l_person_id;

Line 122: hr_utility.set_location('l_person_id '||l_person_id,40);

118: fetch cur_contact_person_id into l_person_id;
119: close cur_contact_person_id;
120:
121: --
122: hr_utility.set_location('l_person_id '||l_person_id,40);
123: -- hr_utility.set_location('After cur_effective_date cursor ',40);
124: -- hr_utility.set_location('l_effective_date '||l_effective_date,50);
125: hr_utility.set_location('Before cur_contact_person_details ',60);
126:

Line 123: -- hr_utility.set_location('After cur_effective_date cursor ',40);

119: close cur_contact_person_id;
120:
121: --
122: hr_utility.set_location('l_person_id '||l_person_id,40);
123: -- hr_utility.set_location('After cur_effective_date cursor ',40);
124: -- hr_utility.set_location('l_effective_date '||l_effective_date,50);
125: hr_utility.set_location('Before cur_contact_person_details ',60);
126:
127: --

Line 124: -- hr_utility.set_location('l_effective_date '||l_effective_date,50);

120:
121: --
122: hr_utility.set_location('l_person_id '||l_person_id,40);
123: -- hr_utility.set_location('After cur_effective_date cursor ',40);
124: -- hr_utility.set_location('l_effective_date '||l_effective_date,50);
125: hr_utility.set_location('Before cur_contact_person_details ',60);
126:
127: --
128: OPEN cur_contact_person_details(l_person_id,hr_util_misc_ss.g_eff_date);

Line 125: hr_utility.set_location('Before cur_contact_person_details ',60);

121: --
122: hr_utility.set_location('l_person_id '||l_person_id,40);
123: -- hr_utility.set_location('After cur_effective_date cursor ',40);
124: -- hr_utility.set_location('l_effective_date '||l_effective_date,50);
125: hr_utility.set_location('Before cur_contact_person_details ',60);
126:
127: --
128: OPEN cur_contact_person_details(l_person_id,hr_util_misc_ss.g_eff_date);
129: FETCH cur_contact_person_details INTO l_contact_person_details;

Line 131: hr_utility.set_location(' contact person prename adjunct '||l_contact_person_details.prefix ,70);

127: --
128: OPEN cur_contact_person_details(l_person_id,hr_util_misc_ss.g_eff_date);
129: FETCH cur_contact_person_details INTO l_contact_person_details;
130:
131: hr_utility.set_location(' contact person prename adjunct '||l_contact_person_details.prefix ,70);
132: hr_utility.set_location('contact person last name '|| l_contact_person_details.last_name,70);
133:
134:
135: /* the l_per_information5,l_per_information6 stores either dynamically retrieved last name , prename adjucnt(if spouse exist)

Line 132: hr_utility.set_location('contact person last name '|| l_contact_person_details.last_name,70);

128: OPEN cur_contact_person_details(l_person_id,hr_util_misc_ss.g_eff_date);
129: FETCH cur_contact_person_details INTO l_contact_person_details;
130:
131: hr_utility.set_location(' contact person prename adjunct '||l_contact_person_details.prefix ,70);
132: hr_utility.set_location('contact person last name '|| l_contact_person_details.last_name,70);
133:
134:
135: /* the l_per_information5,l_per_information6 stores either dynamically retrieved last name , prename adjucnt(if spouse exist)
136: or the p_per_information5,p_per_information6 tat are passed to procedure */

Line 140: hr_utility.set_location(' entered if condtion',80);

136: or the p_per_information5,p_per_information6 tat are passed to procedure */
137: IF(cur_contact_person_details%FOUND) THEN
138: l_per_information5:=l_contact_person_details.prefix;
139: l_per_information6:=l_contact_person_details.last_name;
140: hr_utility.set_location(' entered if condtion',80);
141: ELSE
142: l_per_information5:= p_per_information5;
143: l_per_information6:= p_per_information6;
144: hr_utility.set_location(' entered else condtion',90);

Line 144: hr_utility.set_location(' entered else condtion',90);

140: hr_utility.set_location(' entered if condtion',80);
141: ELSE
142: l_per_information5:= p_per_information5;
143: l_per_information6:= p_per_information6;
144: hr_utility.set_location(' entered else condtion',90);
145: END IF;
146: CLOSE cur_contact_person_details;
147:
148: --