70: --
71: p_calculated_val := (p_val/10000) * p_val_2;
72: --
73: else
74: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
75: fnd_message.set_token('PROC',l_package);
76: fnd_message.set_token('CODE1',p_rt_typ_cd);
77: fnd_message.raise_error;
78: end if;
71: p_calculated_val := (p_val/10000) * p_val_2;
72: --
73: else
74: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
75: fnd_message.set_token('PROC',l_package);
76: fnd_message.set_token('CODE1',p_rt_typ_cd);
77: fnd_message.raise_error;
78: end if;
79: --
72: --
73: else
74: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
75: fnd_message.set_token('PROC',l_package);
76: fnd_message.set_token('CODE1',p_rt_typ_cd);
77: fnd_message.raise_error;
78: end if;
79: --
80: -- hr_utility.set_location ('Leaving '||l_package,10);
73: else
74: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
75: fnd_message.set_token('PROC',l_package);
76: fnd_message.set_token('CODE1',p_rt_typ_cd);
77: fnd_message.raise_error;
78: end if;
79: --
80: -- hr_utility.set_location ('Leaving '||l_package,10);
81: --
1919: hr_utility.set_location('Leaving:'||l_proc, 5);
1920: --
1921: exception
1922: when table_full then
1923: fnd_message.set_name('BEN','BEN_92651_LOG_TABLE_FULL');
1924: fnd_message.set_token('TABLE_NAME',l_table_name);
1925: raise;
1926: when index_full then
1927: fnd_message.set_name('BEN','BEN_92652_LOG_INDEX_FULL');
1920: --
1921: exception
1922: when table_full then
1923: fnd_message.set_name('BEN','BEN_92651_LOG_TABLE_FULL');
1924: fnd_message.set_token('TABLE_NAME',l_table_name);
1925: raise;
1926: when index_full then
1927: fnd_message.set_name('BEN','BEN_92652_LOG_INDEX_FULL');
1928: fnd_message.set_token('INDEX_NAME',l_table_name);
1923: fnd_message.set_name('BEN','BEN_92651_LOG_TABLE_FULL');
1924: fnd_message.set_token('TABLE_NAME',l_table_name);
1925: raise;
1926: when index_full then
1927: fnd_message.set_name('BEN','BEN_92652_LOG_INDEX_FULL');
1928: fnd_message.set_token('INDEX_NAME',l_table_name);
1929: raise;
1930: when others then
1931: raise;
1924: fnd_message.set_token('TABLE_NAME',l_table_name);
1925: raise;
1926: when index_full then
1927: fnd_message.set_name('BEN','BEN_92652_LOG_INDEX_FULL');
1928: fnd_message.set_token('INDEX_NAME',l_table_name);
1929: raise;
1930: when others then
1931: raise;
1932: end write_table_and_file;
3469: else
3470: --
3471: -- Defensive programming
3472: --
3473: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
3474: fnd_message.set_token('PROC',l_proc);
3475: fnd_message.set_token('CODE1',p_rounding_cd);
3476: raise ben_manage_life_events.g_record_error;
3477: --
3470: --
3471: -- Defensive programming
3472: --
3473: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
3474: fnd_message.set_token('PROC',l_proc);
3475: fnd_message.set_token('CODE1',p_rounding_cd);
3476: raise ben_manage_life_events.g_record_error;
3477: --
3478: end if;
3471: -- Defensive programming
3472: --
3473: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
3474: fnd_message.set_token('PROC',l_proc);
3475: fnd_message.set_token('CODE1',p_rounding_cd);
3476: raise ben_manage_life_events.g_record_error;
3477: --
3478: end if;
3479: --
3638: else
3639: --
3640: -- Defensive programming
3641: --
3642: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
3643: fnd_message.set_token('PROC',l_proc);
3644: fnd_message.set_token('CODE1',p_uom);
3645: raise ben_manage_life_events.g_record_error;
3646: --
3639: --
3640: -- Defensive programming
3641: --
3642: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
3643: fnd_message.set_token('PROC',l_proc);
3644: fnd_message.set_token('CODE1',p_uom);
3645: raise ben_manage_life_events.g_record_error;
3646: --
3647: end if;
3640: -- Defensive programming
3641: --
3642: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
3643: fnd_message.set_token('PROC',l_proc);
3644: fnd_message.set_token('CODE1',p_uom);
3645: raise ben_manage_life_events.g_record_error;
3646: --
3647: end if;
3648: --
3708: --
3709: -- Defensive programming
3710: --
3711: hr_utility.set_location('BEN_91342_UNKNOWN_CODE_1', 99);
3712: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
3713: fnd_message.set_token('PROC',l_proc);
3714: fnd_message.set_token('CODE1',p_uom);
3715: raise ben_manage_life_events.g_record_error;
3716: --
3709: -- Defensive programming
3710: --
3711: hr_utility.set_location('BEN_91342_UNKNOWN_CODE_1', 99);
3712: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
3713: fnd_message.set_token('PROC',l_proc);
3714: fnd_message.set_token('CODE1',p_uom);
3715: raise ben_manage_life_events.g_record_error;
3716: --
3717: end if;
3710: --
3711: hr_utility.set_location('BEN_91342_UNKNOWN_CODE_1', 99);
3712: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
3713: fnd_message.set_token('PROC',l_proc);
3714: fnd_message.set_token('CODE1',p_uom);
3715: raise ben_manage_life_events.g_record_error;
3716: --
3717: end if;
3718: --
3982: l_app_name varchar2(240);
3983: --
3984: begin
3985: --
3986: l_message := fnd_message.get_encoded;
3987: fnd_message.set_encoded(l_message);
3988: --
3989: fnd_message.parse_encoded(encoded_message => l_message,
3990: app_short_name => l_app_name,
3983: --
3984: begin
3985: --
3986: l_message := fnd_message.get_encoded;
3987: fnd_message.set_encoded(l_message);
3988: --
3989: fnd_message.parse_encoded(encoded_message => l_message,
3990: app_short_name => l_app_name,
3991: message_name => l_message_name);
3985: --
3986: l_message := fnd_message.get_encoded;
3987: fnd_message.set_encoded(l_message);
3988: --
3989: fnd_message.parse_encoded(encoded_message => l_message,
3990: app_short_name => l_app_name,
3991: message_name => l_message_name);
3992: --
3993: return(l_message_name);