DBA Data[Home] [Help]

APPS.GMS_AWARDS_DIST_PKG dependencies on GMS_ERROR_PKG

Line 20: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',

16: FROM dual ;
17: return nvl(x_award_set_id,0) ;
18: EXCEPTION
19: WHEN OTHERS THEN
20: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
21: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG : get_award_set_id ',
22: x_token_name2 => 'OERRNO', x_token_val2 => SQLCODE,
23: x_token_name3 => 'OERRM', x_token_val3 => SQLERRM ,
24: x_err_code => p_err_code, x_err_buff => p_err_buf

Line 335: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',

331: EXCEPTION
332: WHEN CDL_NOT_FOUND THEN
333: CLOSE C_CDL ;
334:
335: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
336: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG :COPY ADLS',
337: x_token_name2 => 'OERRNO', x_token_val2 => SQLCODE,
338: x_token_name3 => 'OERRM', x_token_val3 => SQLERRM ,
339: x_err_code => p_err_code, x_err_buff => p_err_buf

Line 345: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',

341: RAISE ;
342:
343: WHEN OTHERS THEN
344:
345: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
346: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG :Create_adls',
347: x_token_name2 => 'OERRNO', x_token_val2 => SQLCODE,
348: x_token_name3 => 'OERRM', x_token_val3 => SQLERRM ,
349: x_err_code => p_err_code, x_err_buff => p_err_buf

Line 488: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',

484: x_adls_rec.last_update_login ,
485: NVL(x_adls_rec.billable_flag, 'Y') ) ;
486: EXCEPTION
487: WHEN OTHERS THEN
488: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
489: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG :CREATE ADLS',
490: x_token_name2 => 'OERRNO', x_token_val2 => SQLCODE,
491: x_token_name3 => 'OERRM', x_token_val3 => SQLERRM ,
492: x_err_code => p_err_code, x_err_buff => p_err_buf

Line 569: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',

565: WHERE award_set_id = x_adls_rec.award_set_id and
566: adl_line_num = x_adls_rec.adl_line_num ;
567: EXCEPTION
568: WHEN OTHERS THEN
569: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
570: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG :UPDATE ADLS',
571: x_token_name2 => 'OERRNO', x_token_val2 => SQLCODE,
572: x_token_name3 => 'OERRM', x_token_val3 => SQLERRM ,
573: x_err_code => p_err_code, x_err_buff => p_err_buf

Line 592: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',

588: -- WHERE distribution_set_id = p_distribution_set_id ;
589: NULL ;
590: EXCEPTION
591: WHEN OTHERS THEN
592: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
593: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG :DELETE ADLS',
594: x_token_name2 => 'OERRNO', x_token_val2 => SQLCODE,
595: x_token_name3 => 'OERRM', x_token_val3 => SQLERRM ,
596: x_err_code => p_err_code, x_err_buff => p_err_buf

Line 676: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',

672: NULL ;
673:
674: EXCEPTION
675: WHEN OTHERS THEN
676: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
677: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG : clean_dangling_adls',
678: x_token_name2 => 'OERRNO', x_token_val2 => SQLCODE,
679: x_token_name3 => 'OERRM', x_token_val3 => SQLERRM ,
680: x_err_code => p_err_code, x_err_buff => p_err_buf

Line 1508: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',

1504: and adl_line_num = 1 ;
1505: EXCEPTION
1506: WHEN OTHERS THEN
1507: -- The following procedure call is added for Bug 4290147
1508: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
1509: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG :copy_exp_adls :Exp Item Id :'||p_backout_item_id,
1510: x_token_name2 => 'OERRNO', x_token_val2 => SQLCODE,
1511: x_token_name3 => 'OERRM', x_token_val3 => SQLERRM ,
1512: x_err_code => l_err_code, x_err_buff => l_err_buf ) ;