eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TSR_BUS dependencies on FND_MESSAGE

Line 88: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

84: close csr_sec_grp;
85: --
86: -- The primary key is invalid therefore we must error
87: --
88: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
89: hr_multi_message.add
90: (p_associated_column1
91: => nvl(p_associated_column1,'SUPPLIED_RESOURCE_ID')
92: );

Line 127: fnd_message.set_name('OTA','OTA_13457_GEN_MAND_START_DATE');

123: --
124: hr_utility.set_location('Entering:'||l_proc, 5);
125: --
126: if p_constraint_name = 'startdate_is_mandatory' then
127: fnd_message.set_name('OTA','OTA_13457_GEN_MAND_START_DATE');
128: elsif p_constraint_name = 'end_precedes_start' then
129: fnd_message.set_name('OTA','OTA_13312_GEN_DATE_ORDER');
130: elsif p_constraint_name = 'location_is_not_active' then
131: fnd_message.set_name('OTA','OTA_13377_GEN_LOCAT_NOT_ACTIVE');

Line 129: fnd_message.set_name('OTA','OTA_13312_GEN_DATE_ORDER');

125: --
126: if p_constraint_name = 'startdate_is_mandatory' then
127: fnd_message.set_name('OTA','OTA_13457_GEN_MAND_START_DATE');
128: elsif p_constraint_name = 'end_precedes_start' then
129: fnd_message.set_name('OTA','OTA_13312_GEN_DATE_ORDER');
130: elsif p_constraint_name = 'location_is_not_active' then
131: fnd_message.set_name('OTA','OTA_13377_GEN_LOCAT_NOT_ACTIVE');
132: --
133: elsif p_constraint_name = 'resource_type_is_mandatory' then

Line 131: fnd_message.set_name('OTA','OTA_13377_GEN_LOCAT_NOT_ACTIVE');

127: fnd_message.set_name('OTA','OTA_13457_GEN_MAND_START_DATE');
128: elsif p_constraint_name = 'end_precedes_start' then
129: fnd_message.set_name('OTA','OTA_13312_GEN_DATE_ORDER');
130: elsif p_constraint_name = 'location_is_not_active' then
131: fnd_message.set_name('OTA','OTA_13377_GEN_LOCAT_NOT_ACTIVE');
132: --
133: elsif p_constraint_name = 'resource_type_is_mandatory' then
134: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
135: fnd_message.set_token('FIELD','Supplied resource Type');

Line 134: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');

130: elsif p_constraint_name = 'location_is_not_active' then
131: fnd_message.set_name('OTA','OTA_13377_GEN_LOCAT_NOT_ACTIVE');
132: --
133: elsif p_constraint_name = 'resource_type_is_mandatory' then
134: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
135: fnd_message.set_token('FIELD','Supplied resource Type');
136: fnd_message.set_token('OPTIONAL_EXTENSION','');
137: elsif p_constraint_name = 'vendor_is_mandatory' then
138: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');

Line 135: fnd_message.set_token('FIELD','Supplied resource Type');

131: fnd_message.set_name('OTA','OTA_13377_GEN_LOCAT_NOT_ACTIVE');
132: --
133: elsif p_constraint_name = 'resource_type_is_mandatory' then
134: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
135: fnd_message.set_token('FIELD','Supplied resource Type');
136: fnd_message.set_token('OPTIONAL_EXTENSION','');
137: elsif p_constraint_name = 'vendor_is_mandatory' then
138: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
139: fnd_message.set_token('FIELD','Training Center or Supplier');

Line 136: fnd_message.set_token('OPTIONAL_EXTENSION','');

132: --
133: elsif p_constraint_name = 'resource_type_is_mandatory' then
134: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
135: fnd_message.set_token('FIELD','Supplied resource Type');
136: fnd_message.set_token('OPTIONAL_EXTENSION','');
137: elsif p_constraint_name = 'vendor_is_mandatory' then
138: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
139: fnd_message.set_token('FIELD','Training Center or Supplier');
140: fnd_message.set_token('OPTIONAL_EXTENSION','');

Line 138: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');

134: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
135: fnd_message.set_token('FIELD','Supplied resource Type');
136: fnd_message.set_token('OPTIONAL_EXTENSION','');
137: elsif p_constraint_name = 'vendor_is_mandatory' then
138: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
139: fnd_message.set_token('FIELD','Training Center or Supplier');
140: fnd_message.set_token('OPTIONAL_EXTENSION','');
141: elsif p_constraint_name = 'consumable_flag_is_mandatory' then
142: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');

Line 139: fnd_message.set_token('FIELD','Training Center or Supplier');

135: fnd_message.set_token('FIELD','Supplied resource Type');
136: fnd_message.set_token('OPTIONAL_EXTENSION','');
137: elsif p_constraint_name = 'vendor_is_mandatory' then
138: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
139: fnd_message.set_token('FIELD','Training Center or Supplier');
140: fnd_message.set_token('OPTIONAL_EXTENSION','');
141: elsif p_constraint_name = 'consumable_flag_is_mandatory' then
142: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
143: fnd_message.set_token('FIELD','Resource Consumable flag');

Line 140: fnd_message.set_token('OPTIONAL_EXTENSION','');

136: fnd_message.set_token('OPTIONAL_EXTENSION','');
137: elsif p_constraint_name = 'vendor_is_mandatory' then
138: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
139: fnd_message.set_token('FIELD','Training Center or Supplier');
140: fnd_message.set_token('OPTIONAL_EXTENSION','');
141: elsif p_constraint_name = 'consumable_flag_is_mandatory' then
142: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
143: fnd_message.set_token('FIELD','Resource Consumable flag');
144: fnd_message.set_token('OPTIONAL_EXTENSION','');

Line 142: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');

138: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
139: fnd_message.set_token('FIELD','Training Center or Supplier');
140: fnd_message.set_token('OPTIONAL_EXTENSION','');
141: elsif p_constraint_name = 'consumable_flag_is_mandatory' then
142: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
143: fnd_message.set_token('FIELD','Resource Consumable flag');
144: fnd_message.set_token('OPTIONAL_EXTENSION','');
145: --
146: elsif (p_constraint_name='cost_without_currency' or p_constraint_name='currency_without_cost') then

Line 143: fnd_message.set_token('FIELD','Resource Consumable flag');

139: fnd_message.set_token('FIELD','Training Center or Supplier');
140: fnd_message.set_token('OPTIONAL_EXTENSION','');
141: elsif p_constraint_name = 'consumable_flag_is_mandatory' then
142: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
143: fnd_message.set_token('FIELD','Resource Consumable flag');
144: fnd_message.set_token('OPTIONAL_EXTENSION','');
145: --
146: elsif (p_constraint_name='cost_without_currency' or p_constraint_name='currency_without_cost') then
147: fnd_message.set_name('OTA','OTA_13203_TSR_COST_CURRENCY');

Line 144: fnd_message.set_token('OPTIONAL_EXTENSION','');

140: fnd_message.set_token('OPTIONAL_EXTENSION','');
141: elsif p_constraint_name = 'consumable_flag_is_mandatory' then
142: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
143: fnd_message.set_token('FIELD','Resource Consumable flag');
144: fnd_message.set_token('OPTIONAL_EXTENSION','');
145: --
146: elsif (p_constraint_name='cost_without_currency' or p_constraint_name='currency_without_cost') then
147: fnd_message.set_name('OTA','OTA_13203_TSR_COST_CURRENCY');
148: fnd_message.set_token('FIELD1','CURRENCY');

Line 147: fnd_message.set_name('OTA','OTA_13203_TSR_COST_CURRENCY');

143: fnd_message.set_token('FIELD','Resource Consumable flag');
144: fnd_message.set_token('OPTIONAL_EXTENSION','');
145: --
146: elsif (p_constraint_name='cost_without_currency' or p_constraint_name='currency_without_cost') then
147: fnd_message.set_name('OTA','OTA_13203_TSR_COST_CURRENCY');
148: fnd_message.set_token('FIELD1','CURRENCY');
149: fnd_message.set_token('FIELD2','COST');
150: --
151: elsif p_constraint_name = 'wrong_consumable_flag' then

Line 148: fnd_message.set_token('FIELD1','CURRENCY');

144: fnd_message.set_token('OPTIONAL_EXTENSION','');
145: --
146: elsif (p_constraint_name='cost_without_currency' or p_constraint_name='currency_without_cost') then
147: fnd_message.set_name('OTA','OTA_13203_TSR_COST_CURRENCY');
148: fnd_message.set_token('FIELD1','CURRENCY');
149: fnd_message.set_token('FIELD2','COST');
150: --
151: elsif p_constraint_name = 'wrong_consumable_flag' then
152: fnd_message.set_name('OTA','OTA_13204_GEN_INVALID_LOOKUP');

Line 149: fnd_message.set_token('FIELD2','COST');

145: --
146: elsif (p_constraint_name='cost_without_currency' or p_constraint_name='currency_without_cost') then
147: fnd_message.set_name('OTA','OTA_13203_TSR_COST_CURRENCY');
148: fnd_message.set_token('FIELD1','CURRENCY');
149: fnd_message.set_token('FIELD2','COST');
150: --
151: elsif p_constraint_name = 'wrong_consumable_flag' then
152: fnd_message.set_name('OTA','OTA_13204_GEN_INVALID_LOOKUP');
153: fnd_message.set_token('FIELD','CONSUMABLE_FLAG');

Line 152: fnd_message.set_name('OTA','OTA_13204_GEN_INVALID_LOOKUP');

148: fnd_message.set_token('FIELD1','CURRENCY');
149: fnd_message.set_token('FIELD2','COST');
150: --
151: elsif p_constraint_name = 'wrong_consumable_flag' then
152: fnd_message.set_name('OTA','OTA_13204_GEN_INVALID_LOOKUP');
153: fnd_message.set_token('FIELD','CONSUMABLE_FLAG');
154: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
155: --
156: elsif p_constraint_name = 'address_must_be_null' then

Line 153: fnd_message.set_token('FIELD','CONSUMABLE_FLAG');

149: fnd_message.set_token('FIELD2','COST');
150: --
151: elsif p_constraint_name = 'wrong_consumable_flag' then
152: fnd_message.set_name('OTA','OTA_13204_GEN_INVALID_LOOKUP');
153: fnd_message.set_token('FIELD','CONSUMABLE_FLAG');
154: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
155: --
156: elsif p_constraint_name = 'address_must_be_null' then
157: fnd_message.set_name('OTA','OTA_13223_GEN_MANDATORY_NULL');

Line 154: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

150: --
151: elsif p_constraint_name = 'wrong_consumable_flag' then
152: fnd_message.set_name('OTA','OTA_13204_GEN_INVALID_LOOKUP');
153: fnd_message.set_token('FIELD','CONSUMABLE_FLAG');
154: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
155: --
156: elsif p_constraint_name = 'address_must_be_null' then
157: fnd_message.set_name('OTA','OTA_13223_GEN_MANDATORY_NULL');
158: fnd_message.set_token('FIELD','Address line');

Line 157: fnd_message.set_name('OTA','OTA_13223_GEN_MANDATORY_NULL');

153: fnd_message.set_token('FIELD','CONSUMABLE_FLAG');
154: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
155: --
156: elsif p_constraint_name = 'address_must_be_null' then
157: fnd_message.set_name('OTA','OTA_13223_GEN_MANDATORY_NULL');
158: fnd_message.set_token('FIELD','Address line');
159: fnd_message.set_token('OPTIONAL_EXTENSION','No location.');
160: --
161: elsif p_constraint_name = 'del_child_trb_exists' then

Line 158: fnd_message.set_token('FIELD','Address line');

154: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
155: --
156: elsif p_constraint_name = 'address_must_be_null' then
157: fnd_message.set_name('OTA','OTA_13223_GEN_MANDATORY_NULL');
158: fnd_message.set_token('FIELD','Address line');
159: fnd_message.set_token('OPTIONAL_EXTENSION','No location.');
160: --
161: elsif p_constraint_name = 'del_child_trb_exists' then
162: fnd_message.set_name('OTA','OTA_13227_TSR_TRB_EXISTS');

Line 159: fnd_message.set_token('OPTIONAL_EXTENSION','No location.');

155: --
156: elsif p_constraint_name = 'address_must_be_null' then
157: fnd_message.set_name('OTA','OTA_13223_GEN_MANDATORY_NULL');
158: fnd_message.set_token('FIELD','Address line');
159: fnd_message.set_token('OPTIONAL_EXTENSION','No location.');
160: --
161: elsif p_constraint_name = 'del_child_trb_exists' then
162: fnd_message.set_name('OTA','OTA_13227_TSR_TRB_EXISTS');
163: elsif p_constraint_name = 'del_child_rud_exists' then

Line 162: fnd_message.set_name('OTA','OTA_13227_TSR_TRB_EXISTS');

158: fnd_message.set_token('FIELD','Address line');
159: fnd_message.set_token('OPTIONAL_EXTENSION','No location.');
160: --
161: elsif p_constraint_name = 'del_child_trb_exists' then
162: fnd_message.set_name('OTA','OTA_13227_TSR_TRB_EXISTS');
163: elsif p_constraint_name = 'del_child_rud_exists' then
164: fnd_message.set_name('OTA','OTA_13229_TSR_RUD_EXISTS');
165: --
166: elsif p_constraint_name = 'resource_already_exists' then

Line 164: fnd_message.set_name('OTA','OTA_13229_TSR_RUD_EXISTS');

160: --
161: elsif p_constraint_name = 'del_child_trb_exists' then
162: fnd_message.set_name('OTA','OTA_13227_TSR_TRB_EXISTS');
163: elsif p_constraint_name = 'del_child_rud_exists' then
164: fnd_message.set_name('OTA','OTA_13229_TSR_RUD_EXISTS');
165: --
166: elsif p_constraint_name = 'resource_already_exists' then
167: fnd_message.set_name('OTA','OTA_13381_TSR_DUPLICATE');
168: elsif p_constraint_name = 'cons_flag_other_excl' then

Line 167: fnd_message.set_name('OTA','OTA_13381_TSR_DUPLICATE');

163: elsif p_constraint_name = 'del_child_rud_exists' then
164: fnd_message.set_name('OTA','OTA_13229_TSR_RUD_EXISTS');
165: --
166: elsif p_constraint_name = 'resource_already_exists' then
167: fnd_message.set_name('OTA','OTA_13381_TSR_DUPLICATE');
168: elsif p_constraint_name = 'cons_flag_other_excl' then
169: fnd_message.set_name('OTA','OTA_13382_TSR_CONS_FLAG_EXCL');
170: elsif p_constraint_name = 'resource_type_is_not_updatable' then
171: fnd_message.set_name('OTA','OTA_13378_TSR_TYPE_NOT_UPD');

Line 169: fnd_message.set_name('OTA','OTA_13382_TSR_CONS_FLAG_EXCL');

165: --
166: elsif p_constraint_name = 'resource_already_exists' then
167: fnd_message.set_name('OTA','OTA_13381_TSR_DUPLICATE');
168: elsif p_constraint_name = 'cons_flag_other_excl' then
169: fnd_message.set_name('OTA','OTA_13382_TSR_CONS_FLAG_EXCL');
170: elsif p_constraint_name = 'resource_type_is_not_updatable' then
171: fnd_message.set_name('OTA','OTA_13378_TSR_TYPE_NOT_UPD');
172: elsif p_constraint_name = 'new_date_invalids_usage_date' then
173: fnd_message.set_name('OTA','OTA_13379_TSR_DATES_RUD');

Line 171: fnd_message.set_name('OTA','OTA_13378_TSR_TYPE_NOT_UPD');

167: fnd_message.set_name('OTA','OTA_13381_TSR_DUPLICATE');
168: elsif p_constraint_name = 'cons_flag_other_excl' then
169: fnd_message.set_name('OTA','OTA_13382_TSR_CONS_FLAG_EXCL');
170: elsif p_constraint_name = 'resource_type_is_not_updatable' then
171: fnd_message.set_name('OTA','OTA_13378_TSR_TYPE_NOT_UPD');
172: elsif p_constraint_name = 'new_date_invalids_usage_date' then
173: fnd_message.set_name('OTA','OTA_13379_TSR_DATES_RUD');
174: elsif p_constraint_name = 'new_date_invalids_booking_date' then
175: fnd_message.set_name('OTA','OTA_13380_TSR_DATES_TRB');

Line 173: fnd_message.set_name('OTA','OTA_13379_TSR_DATES_RUD');

169: fnd_message.set_name('OTA','OTA_13382_TSR_CONS_FLAG_EXCL');
170: elsif p_constraint_name = 'resource_type_is_not_updatable' then
171: fnd_message.set_name('OTA','OTA_13378_TSR_TYPE_NOT_UPD');
172: elsif p_constraint_name = 'new_date_invalids_usage_date' then
173: fnd_message.set_name('OTA','OTA_13379_TSR_DATES_RUD');
174: elsif p_constraint_name = 'new_date_invalids_booking_date' then
175: fnd_message.set_name('OTA','OTA_13380_TSR_DATES_TRB');
176: --
177: elsif p_constraint_name = 'mutual_exclusive' then

Line 175: fnd_message.set_name('OTA','OTA_13380_TSR_DATES_TRB');

171: fnd_message.set_name('OTA','OTA_13378_TSR_TYPE_NOT_UPD');
172: elsif p_constraint_name = 'new_date_invalids_usage_date' then
173: fnd_message.set_name('OTA','OTA_13379_TSR_DATES_RUD');
174: elsif p_constraint_name = 'new_date_invalids_booking_date' then
175: fnd_message.set_name('OTA','OTA_13380_TSR_DATES_TRB');
176: --
177: elsif p_constraint_name = 'mutual_exclusive' then
178: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
179: fnd_message.set_token('FIELD','Either Training Center or Supplier');

Line 178: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');

174: elsif p_constraint_name = 'new_date_invalids_booking_date' then
175: fnd_message.set_name('OTA','OTA_13380_TSR_DATES_TRB');
176: --
177: elsif p_constraint_name = 'mutual_exclusive' then
178: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
179: fnd_message.set_token('FIELD','Either Training Center or Supplier');
180: fnd_message.set_token('OPTIONAL_EXTENSION','');
181:
182: else

Line 179: fnd_message.set_token('FIELD','Either Training Center or Supplier');

175: fnd_message.set_name('OTA','OTA_13380_TSR_DATES_TRB');
176: --
177: elsif p_constraint_name = 'mutual_exclusive' then
178: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
179: fnd_message.set_token('FIELD','Either Training Center or Supplier');
180: fnd_message.set_token('OPTIONAL_EXTENSION','');
181:
182: else
183: fnd_message.set_name('OTA','OTA_13259_GEN_UNKN_CONSTRAINT');

Line 180: fnd_message.set_token('OPTIONAL_EXTENSION','');

176: --
177: elsif p_constraint_name = 'mutual_exclusive' then
178: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
179: fnd_message.set_token('FIELD','Either Training Center or Supplier');
180: fnd_message.set_token('OPTIONAL_EXTENSION','');
181:
182: else
183: fnd_message.set_name('OTA','OTA_13259_GEN_UNKN_CONSTRAINT');
184: fnd_message.set_token('CONSTRAINT',p_constraint_name);

Line 183: fnd_message.set_name('OTA','OTA_13259_GEN_UNKN_CONSTRAINT');

179: fnd_message.set_token('FIELD','Either Training Center or Supplier');
180: fnd_message.set_token('OPTIONAL_EXTENSION','');
181:
182: else
183: fnd_message.set_name('OTA','OTA_13259_GEN_UNKN_CONSTRAINT');
184: fnd_message.set_token('CONSTRAINT',p_constraint_name);
185: End If;
186: --
187: fnd_message.raise_error;

Line 184: fnd_message.set_token('CONSTRAINT',p_constraint_name);

180: fnd_message.set_token('OPTIONAL_EXTENSION','');
181:
182: else
183: fnd_message.set_name('OTA','OTA_13259_GEN_UNKN_CONSTRAINT');
184: fnd_message.set_token('CONSTRAINT',p_constraint_name);
185: End If;
186: --
187: fnd_message.raise_error;
188: --

Line 187: fnd_message.raise_error;

183: fnd_message.set_name('OTA','OTA_13259_GEN_UNKN_CONSTRAINT');
184: fnd_message.set_token('CONSTRAINT',p_constraint_name);
185: End If;
186: --
187: fnd_message.raise_error;
188: --
189: hr_utility.set_location(' Leaving:'||l_proc, 10);
190:
191: End constraint_error2;

Line 655: fnd_message.set_name('OTA','OTA_13907_TSR_TRNCTR_NOT_EXIST');

651: open c_training_center;
652: fetch c_training_center into l_exists;
653: if c_training_center%notfound then
654: close c_training_center;
655: fnd_message.set_name('OTA','OTA_13907_TSR_TRNCTR_NOT_EXIST');
656: fnd_message.raise_error;
657: end if;
658: close c_training_center;
659: hr_utility.set_location('Entering:'||l_proc, 20);

Line 656: fnd_message.raise_error;

652: fetch c_training_center into l_exists;
653: if c_training_center%notfound then
654: close c_training_center;
655: fnd_message.set_name('OTA','OTA_13907_TSR_TRNCTR_NOT_EXIST');
656: fnd_message.raise_error;
657: end if;
658: close c_training_center;
659: hr_utility.set_location('Entering:'||l_proc, 20);
660: end if;

Line 705: fnd_message.set_name('OTA','OTA_13908_TSR_LOC_NOT_EXIST');

701: open c_location;
702: fetch c_location into l_exists;
703: if c_location%notfound then
704: close c_location;
705: fnd_message.set_name('OTA','OTA_13908_TSR_LOC_NOT_EXIST');
706: fnd_message.raise_error;
707: end if;
708: close c_location;
709: hr_utility.set_location('Entering:'||l_proc, 20);

Line 706: fnd_message.raise_error;

702: fetch c_location into l_exists;
703: if c_location%notfound then
704: close c_location;
705: fnd_message.set_name('OTA','OTA_13908_TSR_LOC_NOT_EXIST');
706: fnd_message.raise_error;
707: end if;
708: close c_location;
709: hr_utility.set_location('Entering:'||l_proc, 20);
710: end if;

Line 800: fnd_message.set_name('OTA','OTA_13906_TSR_TRAIN_NOT_EXIST');

796: open c_trainer_global;
797: fetch c_trainer_global into l_exists;
798: if c_trainer_global%notfound then
799: close c_trainer_global;
800: fnd_message.set_name('OTA','OTA_13906_TSR_TRAIN_NOT_EXIST');
801: fnd_message.raise_error;
802: end if;
803: close c_trainer_global;
804: hr_utility.set_location('leaving:'||l_proc, 20);

Line 801: fnd_message.raise_error;

797: fetch c_trainer_global into l_exists;
798: if c_trainer_global%notfound then
799: close c_trainer_global;
800: fnd_message.set_name('OTA','OTA_13906_TSR_TRAIN_NOT_EXIST');
801: fnd_message.raise_error;
802: end if;
803: close c_trainer_global;
804: hr_utility.set_location('leaving:'||l_proc, 20);
805: else

Line 811: fnd_message.set_name('OTA','OTA_13906_TSR_TRAIN_NOT_EXIST');

807: open c_trainer;
808: fetch c_trainer into l_exists;
809: if c_trainer%notfound then
810: close c_trainer;
811: fnd_message.set_name('OTA','OTA_13906_TSR_TRAIN_NOT_EXIST');
812: fnd_message.raise_error;
813: end if;
814: close c_trainer;
815: hr_utility.set_location('Leaving:'||l_proc, 30);

Line 812: fnd_message.raise_error;

808: fetch c_trainer into l_exists;
809: if c_trainer%notfound then
810: close c_trainer;
811: fnd_message.set_name('OTA','OTA_13906_TSR_TRAIN_NOT_EXIST');
812: fnd_message.raise_error;
813: end if;
814: close c_trainer;
815: hr_utility.set_location('Leaving:'||l_proc, 30);
816: end if;