DBA Data[Home] [Help]

APPS.IGS_SS_ENROLL_PKG dependencies on FND_MESSAGE

Line 77: fnd_message.set_name('IGS','IGS_SS_SU_NO_UNITS_FOUND');

73: and ci_sequence_number = p_ci_sequence_number
74: and call_number = p_call_number ;
75: if sql%rowcount = 0
76: then
77: fnd_message.set_name('IGS','IGS_SS_SU_NO_UNITS_FOUND');
78: fnd_msg_pub.add;
79: p_return_status := fnd_api.g_ret_sts_error;
80: end if ;
81: exception

Line 84: -- fnd_message.set_name('IGS','IGS_SS_WHEN_OTHERS');

80: end if ;
81: exception
82: when others
83: then
84: -- fnd_message.set_name('IGS','IGS_SS_WHEN_OTHERS');
85: fnd_message.set_name('IGS',sqlerrm);
86: fnd_msg_pub.add;
87: p_return_status := fnd_api.g_ret_sts_error;
88: end ;

Line 85: fnd_message.set_name('IGS',sqlerrm);

81: exception
82: when others
83: then
84: -- fnd_message.set_name('IGS','IGS_SS_WHEN_OTHERS');
85: fnd_message.set_name('IGS',sqlerrm);
86: fnd_msg_pub.add;
87: p_return_status := fnd_api.g_ret_sts_error;
88: end ;
89: else

Line 90: fnd_message.set_name('IGS','IGS_SS_SU_SELECTION_PK');

86: fnd_msg_pub.add;
87: p_return_status := fnd_api.g_ret_sts_error;
88: end ;
89: else
90: fnd_message.set_name('IGS','IGS_SS_SU_SELECTION_PK');
91: fnd_msg_pub.add;
92: p_return_status := fnd_api.g_ret_sts_error;
93: end if ;
94:

Line 129: fnd_message.set_name('IGS','IGS_SS_SU_NO_UNITS_FOUND');

125: and lower(unit_cd) = lower(p_unit_cd)
126: and lower(unit_class) = lower(p_unit_class);
127: if lv_count = 0
128: then
129: fnd_message.set_name('IGS','IGS_SS_SU_NO_UNITS_FOUND');
130: fnd_msg_pub.add;
131: p_return_status := fnd_api.g_ret_sts_error;
132: p_insert_flag := 'NA' ;
133: elsif lv_count = 1

Line 188: fnd_message.set_name('IGS','IGS_SS_SU_NO_UNITS_FOUND');

184: and upper(unit_class) = upper(p_unit_class) ;
185: p_insert_flag := 'Y' ;
186: if sql%rowcount = 0
187: then
188: fnd_message.set_name('IGS','IGS_SS_SU_NO_UNITS_FOUND');
189: fnd_msg_pub.add;
190: p_return_status := fnd_api.g_ret_sts_error;
191: end if ;
192: exception

Line 195: fnd_message.set_name('IGS','IGS_SS_SU_SELECTION_PK');

191: end if ;
192: exception
193: when dup_val_on_index
194: then
195: fnd_message.set_name('IGS','IGS_SS_SU_SELECTION_PK');
196: fnd_msg_pub.add;
197: p_return_status := fnd_api.g_ret_sts_error;
198: end ;
199: else

Line 204: fnd_message.set_name('IGS','IGS_SS_WHEN_OTHERS');

200: p_insert_flag := 'N' ;
201: end if ;
202: exception when others
203: then
204: fnd_message.set_name('IGS','IGS_SS_WHEN_OTHERS');
205: fnd_msg_pub.add;
206: p_return_status := fnd_api.g_ret_sts_error;
207: end ;
208: fnd_msg_pub.count_and_get

Line 283: fnd_message.set_name('IGS','IGS_SS_SU_SELECTION_PK');

279: where uoo_id = p_uoo_id ;
280: exception
281: when dup_val_on_index
282: then
283: fnd_message.set_name('IGS','IGS_SS_SU_SELECTION_PK');
284: fnd_msg_pub.add;
285: p_return_status := fnd_api.g_ret_sts_error;
286: when others
287: then

Line 288: fnd_message.set_name('IGS','IGS_SS_WHEN_OTHERS');

284: fnd_msg_pub.add;
285: p_return_status := fnd_api.g_ret_sts_error;
286: when others
287: then
288: fnd_message.set_name('IGS','IGS_SS_WHEN_OTHERS');
289: fnd_msg_pub.add;
290: p_return_status := fnd_api.g_ret_sts_error;
291: end ;
292: else

Line 293: fnd_message.set_name('IGS','IGS_SS_SU_SELECTION_PK');

289: fnd_msg_pub.add;
290: p_return_status := fnd_api.g_ret_sts_error;
291: end ;
292: else
293: fnd_message.set_name('IGS','IGS_SS_SU_SELECTION_PK');
294: fnd_msg_pub.add;
295: p_return_status := fnd_api.g_ret_sts_error;
296: end if ;
297: fnd_msg_pub.count_and_get

Line 304: fnd_message.set_name('IGS','IGS_SS_WHEN_OTHERS');

300: p_data => p_msg_data
301: );
302: exception when others
303: then
304: fnd_message.set_name('IGS','IGS_SS_WHEN_OTHERS');
305: fnd_msg_pub.Add;
306: p_return_status := fnd_api.g_ret_sts_error;
307: fnd_msg_pub.count_and_get
308: (

Line 331: fnd_message.set_name('IGS','IGS_SS_ENR_CART_NO_DELETE');

327: where person_id = p_person_id
328: and uoo_id = p_uoo_id ;
329: if sql%rowcount = 0
330: then
331: fnd_message.set_name('IGS','IGS_SS_ENR_CART_NO_DELETE');
332: fnd_msg_pub.add;
333: p_return_status := fnd_api.g_ret_sts_error;
334: end if ;
335: exception

Line 338: fnd_message.set_name('IGS','IGS_SS_ENR_CART_TOO_MANY_ROWS');

334: end if ;
335: exception
336: when too_many_rows
337: then
338: fnd_message.set_name('IGS','IGS_SS_ENR_CART_TOO_MANY_ROWS');
339: fnd_msg_pub.Add;
340: p_return_status := fnd_api.g_ret_sts_error;
341: when others
342: then

Line 343: fnd_message.set_name('IGS','IGS_SS_WHEN_OTHERS');

339: fnd_msg_pub.Add;
340: p_return_status := fnd_api.g_ret_sts_error;
341: when others
342: then
343: fnd_message.set_name('IGS','IGS_SS_WHEN_OTHERS');
344: fnd_msg_pub.Add;
345: p_return_status := fnd_api.g_ret_sts_error;
346: end ;
347: fnd_msg_pub.count_and_get

Line 380: fnd_message.set_name('IGS',sqlerrm);

376: where nvl(a.course_attempt_status,' ') not in ('INACTIVE')
377: and person_id = p_person_id ;
378: exception when others
379: then
380: fnd_message.set_name('IGS',sqlerrm);
381: --fnd_message.set_name('IGS','IGS_SS_WHEN_OTHERS');
382: fnd_msg_pub.add;
383: p_return_status := fnd_api.g_ret_sts_error;
384: end ;

Line 381: --fnd_message.set_name('IGS','IGS_SS_WHEN_OTHERS');

377: and person_id = p_person_id ;
378: exception when others
379: then
380: fnd_message.set_name('IGS',sqlerrm);
381: --fnd_message.set_name('IGS','IGS_SS_WHEN_OTHERS');
382: fnd_msg_pub.add;
383: p_return_status := fnd_api.g_ret_sts_error;
384: end ;
385: else

Line 437: fnd_message.set_name('IGS','IGS_SS_SU_NO_UNITS_FOUND');

433: and b.sequence_number = a.ci_sequence_number
434: and b.cal_type = a.cal_type ;
435: if sql%rowcount = 0
436: then
437: fnd_message.set_name('IGS','IGS_SS_SU_NO_UNITS_FOUND');
438: fnd_msg_pub.add;
439: p_return_status := fnd_api.g_ret_sts_error;
440: end if ;
441: exception

Line 444: fnd_message.set_name('IGS','IGS_SS_SU_ENROLLMENT_PK');

440: end if ;
441: exception
442: when dup_val_on_index
443: then
444: fnd_message.set_name('IGS','IGS_SS_SU_ENROLLMENT_PK');
445: fnd_msg_pub.add;
446: p_return_status := fnd_api.g_ret_sts_error;
447: when others
448: then

Line 449: fnd_message.set_name('IGS','IGS_SS_WHEN_OTHERS');

445: fnd_msg_pub.add;
446: p_return_status := fnd_api.g_ret_sts_error;
447: when others
448: then
449: fnd_message.set_name('IGS','IGS_SS_WHEN_OTHERS');
450: fnd_msg_pub.add;
451: p_return_status := fnd_api.g_ret_sts_error;
452: end ;
453:

Line 460: fnd_message.set_name('IGS','IGS_SS_ENR_CART_NO_DELETE');

456: where person_id = p_person_id
457: and uoo_id = p_uoo_id ;
458: if sql%rowcount = 0
459: then
460: fnd_message.set_name('IGS','IGS_SS_ENR_CART_NO_DELETE');
461: fnd_msg_pub.add;
462: p_return_status := fnd_api.g_ret_sts_error;
463: end if ;
464: end ;

Line 494: fnd_message.set_name('IGS','IGS_SS_ENR_CART_NO_DELETE');

490: and uoo_id = p_uoo_id
491: and org_id = p_org_id ;
492: if sql%rowcount = 0
493: then
494: fnd_message.set_name('IGS','IGS_SS_ENR_CART_NO_DELETE');
495: fnd_msg_pub.add;
496: p_return_status := fnd_api.g_ret_sts_error;
497: end if ;
498: exception

Line 501: fnd_message.set_name('IGS','IGS_SS_WHEN_OTHERS');

497: end if ;
498: exception
499: when others
500: then
501: fnd_message.set_name('IGS','IGS_SS_WHEN_OTHERS');
502: fnd_msg_pub.add;
503: p_return_status := fnd_api.g_ret_sts_error;
504: end ;
505: end delete_from_su_attempt;