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.GMS_AWARDS_DIST_PKG dependencies on GMS_AWARDS_DIST_PKG

Line 1: package BODY GMS_AWARDS_DIST_PKG as

1: package BODY GMS_AWARDS_DIST_PKG as
2: -- $Header: gmsadlsb.pls 120.5.12020000.2 2012/10/16 13:41:46 navemish ship $
3:
4: -- -----------------------------------------
5: -- get_award_set_id returns the next

Line 21: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG : get_award_set_id ',

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

Line 336: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG :COPY ADLS',

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

Line 346: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG :Create_adls',

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

Line 489: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG :CREATE ADLS',

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

Line 570: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG :UPDATE ADLS',

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

Line 593: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG :DELETE ADLS',

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

Line 677: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG : clean_dangling_adls',

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

Line 1051: l_new_award_set_id(l_count) := gms_awards_dist_pkg.get_award_set_id ;

1047: l_creation_date(l_count) := req_rec.creation_date;
1048: l_last_updated_by(l_count) := req_rec.last_updated_by;
1049: l_created_by(l_count) := NVL(req_rec.created_by,0);
1050: l_last_update_login(l_count) := req_rec.last_update_login;
1051: l_new_award_set_id(l_count) := gms_awards_dist_pkg.get_award_set_id ;
1052:
1053: END IF ;
1054:
1055: END LOOP ;

Line 1245: l_new_award_set_id(l_count) := gms_awards_dist_pkg.get_award_set_id ;

1241: l_creation_date(l_count) := po_rec.creation_date;
1242: l_last_updated_by(l_count) := po_rec.last_updated_by;
1243: l_created_by(l_count) := NVL(po_rec.created_by,0);
1244: l_last_update_login(l_count) := po_rec.last_update_login;
1245: l_new_award_set_id(l_count) := gms_awards_dist_pkg.get_award_set_id ;
1246:
1247: END IF ;
1248:
1249: END LOOP ;

Line 1367: fnd_message.set_token('PROGRAM_NAME','gms_awards_dist_pkg.verify_create_adls');

1363: END IF;
1364: app_exception.raise_exception;
1365: WHEN OTHERS THEN
1366: fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
1367: fnd_message.set_token('PROGRAM_NAME','gms_awards_dist_pkg.verify_create_adls');
1368: fnd_message.set_token('OERRNO',to_char(sqlcode));
1369: fnd_message.set_token('OERRM',sqlerrm);
1370: app_exception.raise_exception;
1371: END VERIFY_CREATE_ADLS;

Line 1509: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG :copy_exp_adls :Exp Item Id :'||p_backout_item_id,

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 ) ;
1513: x_status := SQLCODE ;

Line 1516: end GMS_AWARDS_DIST_PKG; -- ================== END OF GMS_AWARDS_DIST_PKG ======================

1512: x_err_code => l_err_code, x_err_buff => l_err_buf ) ;
1513: x_status := SQLCODE ;
1514: END copy_exp_adls ;
1515:
1516: end GMS_AWARDS_DIST_PKG; -- ================== END OF GMS_AWARDS_DIST_PKG ======================