DBA Data[Home] [Help]

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 2006/07/01 07:26:31 cmishra noship $
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 316: x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG :COPY ADLS',

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

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

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

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

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

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

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

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

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

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

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

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

1027: l_creation_date(l_count) := req_rec.creation_date;
1028: l_last_updated_by(l_count) := req_rec.last_updated_by;
1029: l_created_by(l_count) := NVL(req_rec.created_by,0);
1030: l_last_update_login(l_count) := req_rec.last_update_login;
1031: l_new_award_set_id(l_count) := gms_awards_dist_pkg.get_award_set_id ;
1032:
1033: END IF ;
1034:
1035: END LOOP ;

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

1221: l_creation_date(l_count) := po_rec.creation_date;
1222: l_last_updated_by(l_count) := po_rec.last_updated_by;
1223: l_created_by(l_count) := NVL(po_rec.created_by,0);
1224: l_last_update_login(l_count) := po_rec.last_update_login;
1225: l_new_award_set_id(l_count) := gms_awards_dist_pkg.get_award_set_id ;
1226:
1227: END IF ;
1228:
1229: END LOOP ;

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

1343: END IF;
1344: app_exception.raise_exception;
1345: WHEN OTHERS THEN
1346: fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
1347: fnd_message.set_token('PROGRAM_NAME','gms_awards_dist_pkg.verify_create_adls');
1348: fnd_message.set_token('OERRNO',to_char(sqlcode));
1349: fnd_message.set_token('OERRM',sqlerrm);
1350: app_exception.raise_exception;
1351: END VERIFY_CREATE_ADLS;

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

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

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

1492: x_err_code => l_err_code, x_err_buff => l_err_buf ) ;
1493: x_status := SQLCODE ;
1494: END copy_exp_adls ;
1495:
1496: end GMS_AWARDS_DIST_PKG; -- ================== END OF GMS_AWARDS_DIST_PKG ======================