235: 121
236: );
237: END IF;
238:
239: fnd_message.set_name ('PER', 'FFU10_GENERAL_ORACLE_ERROR');
240: fnd_message.set_token ('2', SUBSTR (SQLERRM, 1, 200));
241: ben_icm_life_events.g_cache_pep_object.DELETE;
242: ben_icm_life_events.g_cache_epo_object.DELETE;
243: ben_determine_activity_base_rt.l_icd_chc_rates_tab.DELETE;
236: );
237: END IF;
238:
239: fnd_message.set_name ('PER', 'FFU10_GENERAL_ORACLE_ERROR');
240: fnd_message.set_token ('2', SUBSTR (SQLERRM, 1, 200));
241: ben_icm_life_events.g_cache_pep_object.DELETE;
242: ben_icm_life_events.g_cache_epo_object.DELETE;
243: ben_determine_activity_base_rt.l_icd_chc_rates_tab.DELETE;
244: ROLLBACK TO elig_per_cache_savepont;
638: 121
639: );
640: END IF;
641:
642: fnd_message.set_name ('PER', 'FFU10_GENERAL_ORACLE_ERROR');
643: fnd_message.set_token ('2', SUBSTR (SQLERRM, 1, 200));
644: ben_icm_life_events.g_cache_pep_object.DELETE;
645: ben_icm_life_events.g_cache_epo_object.DELETE;
646: ben_determine_activity_base_rt.l_icd_chc_rates_tab.DELETE;
639: );
640: END IF;
641:
642: fnd_message.set_name ('PER', 'FFU10_GENERAL_ORACLE_ERROR');
643: fnd_message.set_token ('2', SUBSTR (SQLERRM, 1, 200));
644: ben_icm_life_events.g_cache_pep_object.DELETE;
645: ben_icm_life_events.g_cache_epo_object.DELETE;
646: ben_determine_activity_base_rt.l_icd_chc_rates_tab.DELETE;
647: ROLLBACK TO elig_per_cache_savepont;
2146: THEN
2147: hr_utility.set_location ('Leaving ' || l_proc, 31);
2148: END IF;
2149: --
2150: l_msg := fnd_message.get;
2151: fnd_message.set_name('BEN','BEN_94875_ICD_BENMNGLE_ERROR');
2152: fnd_message.set_token('BENMNGLE_ERROR',l_msg);
2153: fnd_msg_pub.add;
2154: ben_icm_life_events.g_cache_pep_object.DELETE;
2147: hr_utility.set_location ('Leaving ' || l_proc, 31);
2148: END IF;
2149: --
2150: l_msg := fnd_message.get;
2151: fnd_message.set_name('BEN','BEN_94875_ICD_BENMNGLE_ERROR');
2152: fnd_message.set_token('BENMNGLE_ERROR',l_msg);
2153: fnd_msg_pub.add;
2154: ben_icm_life_events.g_cache_pep_object.DELETE;
2155: ben_icm_life_events.g_cache_epo_object.DELETE;
2148: END IF;
2149: --
2150: l_msg := fnd_message.get;
2151: fnd_message.set_name('BEN','BEN_94875_ICD_BENMNGLE_ERROR');
2152: fnd_message.set_token('BENMNGLE_ERROR',l_msg);
2153: fnd_msg_pub.add;
2154: ben_icm_life_events.g_cache_pep_object.DELETE;
2155: ben_icm_life_events.g_cache_epo_object.DELETE;
2156: ben_determine_activity_base_rt.l_icd_chc_rates_tab.DELETE;
2167: hr_utility.set_location ('Leaving ' || SUBSTR (SQLERRM, 51, 100),
2168: 32
2169: );
2170: END IF;
2171: l_msg := fnd_message.get;
2172: fnd_message.set_name('BEN','BEN_94875_ICD_BENMNGLE_ERROR');
2173: fnd_message.set_token('BENMNGLE_ERROR',l_msg);
2174: fnd_msg_pub.add;
2175: ben_icm_life_events.g_cache_pep_object.DELETE;
2168: 32
2169: );
2170: END IF;
2171: l_msg := fnd_message.get;
2172: fnd_message.set_name('BEN','BEN_94875_ICD_BENMNGLE_ERROR');
2173: fnd_message.set_token('BENMNGLE_ERROR',l_msg);
2174: fnd_msg_pub.add;
2175: ben_icm_life_events.g_cache_pep_object.DELETE;
2176: ben_icm_life_events.g_cache_epo_object.DELETE;
2169: );
2170: END IF;
2171: l_msg := fnd_message.get;
2172: fnd_message.set_name('BEN','BEN_94875_ICD_BENMNGLE_ERROR');
2173: fnd_message.set_token('BENMNGLE_ERROR',l_msg);
2174: fnd_msg_pub.add;
2175: ben_icm_life_events.g_cache_pep_object.DELETE;
2176: ben_icm_life_events.g_cache_epo_object.DELETE;
2177: ben_determine_activity_base_rt.l_icd_chc_rates_tab.DELETE;