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 315: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',

311: EXCEPTION
312: WHEN CDL_NOT_FOUND THEN
313: CLOSE C_CDL ;
314:
315: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
316: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG :COPY ADLS',
317: x_token_name2 => 'OERRNO', x_token_val2 => SQLCODE,
318: x_token_name3 => 'OERRM', x_token_val3 => SQLERRM ,
319: x_err_code => p_err_code, x_err_buff => p_err_buf

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

321: RAISE ;
322:
323: WHEN OTHERS THEN
324:
325: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
326: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG :Create_adls',
327: x_token_name2 => 'OERRNO', x_token_val2 => SQLCODE,
328: x_token_name3 => 'OERRM', x_token_val3 => SQLERRM ,
329: x_err_code => p_err_code, x_err_buff => p_err_buf

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

464: x_adls_rec.last_update_login ,
465: NVL(x_adls_rec.billable_flag, 'Y') ) ;
466: EXCEPTION
467: WHEN OTHERS THEN
468: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
469: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG :CREATE ADLS',
470: x_token_name2 => 'OERRNO', x_token_val2 => SQLCODE,
471: x_token_name3 => 'OERRM', x_token_val3 => SQLERRM ,
472: x_err_code => p_err_code, x_err_buff => p_err_buf

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

545: WHERE award_set_id = x_adls_rec.award_set_id and
546: adl_line_num = x_adls_rec.adl_line_num ;
547: EXCEPTION
548: WHEN OTHERS THEN
549: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
550: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG :UPDATE ADLS',
551: x_token_name2 => 'OERRNO', x_token_val2 => SQLCODE,
552: x_token_name3 => 'OERRM', x_token_val3 => SQLERRM ,
553: x_err_code => p_err_code, x_err_buff => p_err_buf

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

568: -- WHERE distribution_set_id = p_distribution_set_id ;
569: NULL ;
570: EXCEPTION
571: WHEN OTHERS THEN
572: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
573: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG :DELETE ADLS',
574: x_token_name2 => 'OERRNO', x_token_val2 => SQLCODE,
575: x_token_name3 => 'OERRM', x_token_val3 => SQLERRM ,
576: x_err_code => p_err_code, x_err_buff => p_err_buf

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

652: NULL ;
653:
654: EXCEPTION
655: WHEN OTHERS THEN
656: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
657: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG : clean_dangling_adls',
658: x_token_name2 => 'OERRNO', x_token_val2 => SQLCODE,
659: x_token_name3 => 'OERRM', x_token_val3 => SQLERRM ,
660: x_err_code => p_err_code, x_err_buff => p_err_buf

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

1484: and adl_line_num = 1 ;
1485: EXCEPTION
1486: WHEN OTHERS THEN
1487: -- The following procedure call is added for Bug 4290147
1488: GMS_ERROR_PKG.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
1489: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG :copy_exp_adls :Exp Item Id :'||p_backout_item_id,
1490: x_token_name2 => 'OERRNO', x_token_val2 => SQLCODE,
1491: x_token_name3 => 'OERRM', x_token_val3 => SQLERRM ,
1492: x_err_code => l_err_code, x_err_buff => l_err_buf ) ;