DBA Data[Home] [Help]

APPS.IGF_AW_CANCEL_AWD dependencies on IGF_AW_GEN

Line 371: igf_aw_gen.update_fabase_awds(lc_award.base_id,'CANCELLED');

367: FOR l_disb IN cur_awd_disb(lc_awd.award_id) LOOP
368: igf_db_disb.revert_disb(l_disb.row_id, 'A', l_fund_type);
369: END LOOP;
370:
371: igf_aw_gen.update_fabase_awds(lc_award.base_id,'CANCELLED');
372:
373: fnd_message.set_name('IGF', 'IGF_AW_AWARD_CANCELLED');
374: fnd_message.set_token('AWD', lc_award.award_id);
375: fnd_message.set_token('FUND', lc_award.fund_code);

Line 444: || tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);

440: || Known limitations, enhancements or remarks :
441: || Change History :
442: || Who When What
443: || ridas 08-Feb-2006 Bug #5021084. Added new parameter 'lv_group_type' in call to igf_ap_ss_pkg.get_pid
444: || tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
445: || bvisvana 11-Jul-2005 FA 157 and FA 140 - TBH impact for notification status code and date + Publish in ss page
446: || veramach 1-NOV-2003 # 3160856 Added adplans_id in call to igf_aw_award.update_row
447: || smadathi 03-Feb-2002 Bug 2154941. Modified cursor c_award to exclude sponsor fund
448: ||

Line 497: l_year VARCHAR2(80) DEFAULT igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');

493: -----------------------------------------------------------------------------------------------------------
494:
495: l_ci_cal_type igf_aw_award_v.ci_cal_type%TYPE;
496: l_ci_sequence_number igf_aw_award_v.ci_sequence_number%TYPE;
497: l_year VARCHAR2(80) DEFAULT igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
498: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
499: l_party_id hz_parties.party_id%TYPE;
500: l_per_exists BOOLEAN := FALSE;
501: l_list VARCHAR2(32767);

Line 510: igf_aw_gen.set_org_id(NULL);

506: l_per_cur l_per_ref_cur;
507: lv_group_type igs_pe_persid_group_v.group_type%TYPE;
508:
509: BEGIN
510: igf_aw_gen.set_org_id(NULL);
511: RETCODE:= 0;
512:
513: --------------------------------------------------------------------------------------------------------------
514: -- Display Parameters in the log file --

Line 565: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(6),80,' ')||':'||RPAD(' ',4,' ') ||igf_aw_gen.lookup_desc('IGF_AW_CNC_RUN_MODE', p_run_mode));

561: fnd_file.put_line(fnd_file.log,RPAD(l_year,80,' ')||':'||RPAD(' ',4,' ')||l_alt_code);
562: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_fund_code, ''));
563: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_pig_desc, ''));
564: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_person_no, ''));
565: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(6),80,' ')||':'||RPAD(' ',4,' ') ||igf_aw_gen.lookup_desc('IGF_AW_CNC_RUN_MODE', p_run_mode));
566:
567: -- Log paramaters
568: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
569: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', '#### Awards - Cancel Offered Awards process - STARTS ####');

Line 594: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));

590: -- Base Id and PIG
591: IF (p_base_id IS NOT NULL) AND (p_pig IS NOT NULL) THEN
592: -- Err
593: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
594: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
595: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));
596: fnd_file.put_line(fnd_file.log, fnd_message.get);
597: fnd_file.new_line(fnd_file.log, 1);
598: RAISE PARAM_ERR;

Line 595: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));

591: IF (p_base_id IS NOT NULL) AND (p_pig IS NOT NULL) THEN
592: -- Err
593: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
594: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
595: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));
596: fnd_file.put_line(fnd_file.log, fnd_message.get);
597: fnd_file.new_line(fnd_file.log, 1);
598: RAISE PARAM_ERR;
599: END IF;