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_MSG_PUB

Line 78: fnd_msg_pub.add;

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

Line 86: fnd_msg_pub.add;

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

Line 91: 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:
95: fnd_msg_pub.count_and_get

Line 95: fnd_msg_pub.count_and_get

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: (
97: p_count => p_msg_count,
98: p_data => p_msg_data
99: );

Line 130: fnd_msg_pub.add;

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

Line 189: fnd_msg_pub.add;

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

Line 196: fnd_msg_pub.add;

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

Line 205: fnd_msg_pub.add;

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
209: (

Line 208: fnd_msg_pub.count_and_get

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,
211: p_data => p_msg_data
212: );

Line 284: fnd_msg_pub.add;

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

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

Line 294: 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
298: (

Line 297: fnd_msg_pub.count_and_get

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,
300: p_data => p_msg_data
301: );

Line 305: fnd_msg_pub.Add;

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

Line 307: fnd_msg_pub.count_and_get

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
311: );

Line 332: fnd_msg_pub.add;

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

Line 339: fnd_msg_pub.Add;

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

Line 344: 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
348: (

Line 347: fnd_msg_pub.count_and_get

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,
350: p_data => p_msg_data
351: );

Line 382: fnd_msg_pub.add;

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

Line 438: fnd_msg_pub.add;

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

Line 445: fnd_msg_pub.add;

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

Line 450: 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:
454: begin

Line 461: fnd_msg_pub.add;

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 ;
465:

Line 466: fnd_msg_pub.count_and_get

462: p_return_status := fnd_api.g_ret_sts_error;
463: end if ;
464: end ;
465:
466: fnd_msg_pub.count_and_get
467: (
468: p_count => p_msg_count,
469: p_data => p_msg_data
470: );

Line 495: fnd_msg_pub.add;

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

Line 502: fnd_msg_pub.add;

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