DBA Data[Home] [Help]

APPS.HXC_TIME_APPROVAL_INFO dependencies on FND_MESSAGE

Line 133: fnd_message.set_name('HXC','HXC_NO_TIME_CATEGORY');

129: open c_tc_id(p_time_category_name);
130: fetch c_tc_id into l_tc_id;
131: if(c_tc_id%notfound) then
132: close c_tc_id;
133: fnd_message.set_name('HXC','HXC_NO_TIME_CATEGORY');
134: fnd_message.set_token('NAME',p_time_category_name);
135: fnd_message.raise_error;
136: else
137: close c_tc_id;

Line 134: fnd_message.set_token('NAME',p_time_category_name);

130: fetch c_tc_id into l_tc_id;
131: if(c_tc_id%notfound) then
132: close c_tc_id;
133: fnd_message.set_name('HXC','HXC_NO_TIME_CATEGORY');
134: fnd_message.set_token('NAME',p_time_category_name);
135: fnd_message.raise_error;
136: else
137: close c_tc_id;
138: end if;

Line 135: fnd_message.raise_error;

131: if(c_tc_id%notfound) then
132: close c_tc_id;
133: fnd_message.set_name('HXC','HXC_NO_TIME_CATEGORY');
134: fnd_message.set_token('NAME',p_time_category_name);
135: fnd_message.raise_error;
136: else
137: close c_tc_id;
138: end if;
139: else

Line 165: fnd_message.set_name('HXC','HXC_NO_TIME_RECIPIENT');

161: open c_find_tr_id(p_time_recipient_name);
162: fetch c_find_tr_id into l_tr_id;
163: if(c_find_tr_id%notfound) then
164: close c_find_tr_id;
165: fnd_message.set_name('HXC','HXC_NO_TIME_RECIPIENT');
166: fnd_message.set_token('NAME',p_time_recipient_name);
167: fnd_message.raise_error;
168: else
169: close c_find_tr_id;

Line 166: fnd_message.set_token('NAME',p_time_recipient_name);

162: fetch c_find_tr_id into l_tr_id;
163: if(c_find_tr_id%notfound) then
164: close c_find_tr_id;
165: fnd_message.set_name('HXC','HXC_NO_TIME_RECIPIENT');
166: fnd_message.set_token('NAME',p_time_recipient_name);
167: fnd_message.raise_error;
168: else
169: close c_find_tr_id;
170: end if;

Line 167: fnd_message.raise_error;

163: if(c_find_tr_id%notfound) then
164: close c_find_tr_id;
165: fnd_message.set_name('HXC','HXC_NO_TIME_RECIPIENT');
166: fnd_message.set_token('NAME',p_time_recipient_name);
167: fnd_message.raise_error;
168: else
169: close c_find_tr_id;
170: end if;
171: return l_tr_id;

Line 215: fnd_message.set_name('HXC','HXC_NO_APP_PERIOD');

211: l_time_category_id);
212: fetch c_find_app_period into l_application_period_id;
213: if(c_find_app_period%notfound) then
214: close c_find_app_period;
215: fnd_message.set_name('HXC','HXC_NO_APP_PERIOD');
216: fnd_message.raise_error;
217: else
218: close c_find_app_period;
219: end if;

Line 216: fnd_message.raise_error;

212: fetch c_find_app_period into l_application_period_id;
213: if(c_find_app_period%notfound) then
214: close c_find_app_period;
215: fnd_message.set_name('HXC','HXC_NO_APP_PERIOD');
216: fnd_message.raise_error;
217: else
218: close c_find_app_period;
219: end if;
220: return l_application_period_id;

Line 242: fnd_message.set_name('HXC','HXC_NO_TIMECARD_ID');

238: open c_find_timecard_id(p_application_period_id);
239: fetch c_find_timecard_id into l_timecard_id;
240: if(c_find_timecard_id%notfound) then
241: close c_find_timecard_id;
242: fnd_message.set_name('HXC','HXC_NO_TIMECARD_ID');
243: fnd_message.raise_error;
244: else
245: close c_find_timecard_id;
246: end if;

Line 243: fnd_message.raise_error;

239: fetch c_find_timecard_id into l_timecard_id;
240: if(c_find_timecard_id%notfound) then
241: close c_find_timecard_id;
242: fnd_message.set_name('HXC','HXC_NO_TIMECARD_ID');
243: fnd_message.raise_error;
244: else
245: close c_find_timecard_id;
246: end if;
247: return l_timecard_id;

Line 275: fnd_message.set_name('HXC','HXC_NO_TIMECARD_ID');

271: open c_find_timecard_id(p_resource_id,p_start_time,p_stop_time);
272: fetch c_find_timecard_id into l_timecard_id;
273: if(c_find_timecard_id%notfound) then
274: close c_find_timecard_id;
275: fnd_message.set_name('HXC','HXC_NO_TIMECARD_ID');
276: fnd_message.raise_error;
277: else
278: close c_find_timecard_id;
279: end if;

Line 276: fnd_message.raise_error;

272: fetch c_find_timecard_id into l_timecard_id;
273: if(c_find_timecard_id%notfound) then
274: close c_find_timecard_id;
275: fnd_message.set_name('HXC','HXC_NO_TIMECARD_ID');
276: fnd_message.raise_error;
277: else
278: close c_find_timecard_id;
279: end if;
280: return l_timecard_id;