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.IGS_SS_ENROLL_PKG dependencies on FND_API

Line 79: p_return_status := fnd_api.g_ret_sts_error;

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
82: when others
83: then

Line 87: p_return_status := fnd_api.g_ret_sts_error;

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
90: fnd_message.set_name('IGS','IGS_SS_SU_SELECTION_PK');
91: fnd_msg_pub.add;

Line 92: 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:
95: fnd_msg_pub.count_and_get
96: (

Line 131: p_return_status := fnd_api.g_ret_sts_error;

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
134: then
135: begin

Line 190: p_return_status := fnd_api.g_ret_sts_error;

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
193: when dup_val_on_index
194: then

Line 197: p_return_status := fnd_api.g_ret_sts_error;

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
200: p_insert_flag := 'N' ;
201: end if ;

Line 206: p_return_status := fnd_api.g_ret_sts_error;

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
209: (
210: p_count => p_msg_count,

Line 285: p_return_status := fnd_api.g_ret_sts_error;

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
288: fnd_message.set_name('IGS','IGS_SS_WHEN_OTHERS');
289: fnd_msg_pub.add;

Line 290: 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
293: fnd_message.set_name('IGS','IGS_SS_SU_SELECTION_PK');
294: fnd_msg_pub.add;

Line 295: 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
298: (
299: p_count => p_msg_count,

Line 306: p_return_status := fnd_api.g_ret_sts_error;

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: (
309: p_count => p_msg_count,
310: p_data => p_msg_data

Line 333: p_return_status := fnd_api.g_ret_sts_error;

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
336: when too_many_rows
337: then

Line 340: p_return_status := fnd_api.g_ret_sts_error;

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
343: fnd_message.set_name('IGS','IGS_SS_WHEN_OTHERS');
344: fnd_msg_pub.Add;

Line 345: 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
348: (
349: p_count => p_msg_count,

Line 383: p_return_status := fnd_api.g_ret_sts_error;

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
386: l_course_cd := p_course_cd ;
387: end if ;

Line 439: p_return_status := fnd_api.g_ret_sts_error;

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
442: when dup_val_on_index
443: then

Line 446: p_return_status := fnd_api.g_ret_sts_error;

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
449: fnd_message.set_name('IGS','IGS_SS_WHEN_OTHERS');
450: fnd_msg_pub.add;

Line 451: 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:
454: begin
455: delete from igs_ss_su_selection

Line 462: p_return_status := fnd_api.g_ret_sts_error;

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 ;
465:
466: fnd_msg_pub.count_and_get

Line 496: p_return_status := fnd_api.g_ret_sts_error;

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
499: when others
500: then

Line 503: p_return_status := fnd_api.g_ret_sts_error;

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;
506:
507: