2348: when OTHERS THEN
2349: hr_utility.set_location('Delete failed for: '|| p_table_alias || ' primary key: '||p_pk_id ,30);
2350: --NOTIFY
2351: p_delete_failed := 'Y';
2352: l_encoded_message := fnd_message.get;
2353: if(p_parent_entity_name is null or p_parent_entity_name = p_entity_name) then
2354: fnd_message.set_name('BEN', 'BEN_94154_PDW_DELETE_FAILED');
2355: fnd_message.set_token('NAME', p_entity_name );
2356: fnd_message.set_token('MESSAGE', l_encoded_message);
2350: --NOTIFY
2351: p_delete_failed := 'Y';
2352: l_encoded_message := fnd_message.get;
2353: if(p_parent_entity_name is null or p_parent_entity_name = p_entity_name) then
2354: fnd_message.set_name('BEN', 'BEN_94154_PDW_DELETE_FAILED');
2355: fnd_message.set_token('NAME', p_entity_name );
2356: fnd_message.set_token('MESSAGE', l_encoded_message);
2357: fnd_message.raise_error;
2358: else
2351: p_delete_failed := 'Y';
2352: l_encoded_message := fnd_message.get;
2353: if(p_parent_entity_name is null or p_parent_entity_name = p_entity_name) then
2354: fnd_message.set_name('BEN', 'BEN_94154_PDW_DELETE_FAILED');
2355: fnd_message.set_token('NAME', p_entity_name );
2356: fnd_message.set_token('MESSAGE', l_encoded_message);
2357: fnd_message.raise_error;
2358: else
2359: fnd_message.set_name('BEN', 'BEN_94160_PDW_DELETE_FAILED');
2352: l_encoded_message := fnd_message.get;
2353: if(p_parent_entity_name is null or p_parent_entity_name = p_entity_name) then
2354: fnd_message.set_name('BEN', 'BEN_94154_PDW_DELETE_FAILED');
2355: fnd_message.set_token('NAME', p_entity_name );
2356: fnd_message.set_token('MESSAGE', l_encoded_message);
2357: fnd_message.raise_error;
2358: else
2359: fnd_message.set_name('BEN', 'BEN_94160_PDW_DELETE_FAILED');
2360: fnd_message.set_token('NAME', p_parent_entity_name );
2353: if(p_parent_entity_name is null or p_parent_entity_name = p_entity_name) then
2354: fnd_message.set_name('BEN', 'BEN_94154_PDW_DELETE_FAILED');
2355: fnd_message.set_token('NAME', p_entity_name );
2356: fnd_message.set_token('MESSAGE', l_encoded_message);
2357: fnd_message.raise_error;
2358: else
2359: fnd_message.set_name('BEN', 'BEN_94160_PDW_DELETE_FAILED');
2360: fnd_message.set_token('NAME', p_parent_entity_name );
2361: fnd_message.set_token('CHILD', p_entity_name );
2355: fnd_message.set_token('NAME', p_entity_name );
2356: fnd_message.set_token('MESSAGE', l_encoded_message);
2357: fnd_message.raise_error;
2358: else
2359: fnd_message.set_name('BEN', 'BEN_94160_PDW_DELETE_FAILED');
2360: fnd_message.set_token('NAME', p_parent_entity_name );
2361: fnd_message.set_token('CHILD', p_entity_name );
2362: fnd_message.set_token('MESSAGE',l_encoded_message);
2363: fnd_message.raise_error;
2356: fnd_message.set_token('MESSAGE', l_encoded_message);
2357: fnd_message.raise_error;
2358: else
2359: fnd_message.set_name('BEN', 'BEN_94160_PDW_DELETE_FAILED');
2360: fnd_message.set_token('NAME', p_parent_entity_name );
2361: fnd_message.set_token('CHILD', p_entity_name );
2362: fnd_message.set_token('MESSAGE',l_encoded_message);
2363: fnd_message.raise_error;
2364: end if;
2357: fnd_message.raise_error;
2358: else
2359: fnd_message.set_name('BEN', 'BEN_94160_PDW_DELETE_FAILED');
2360: fnd_message.set_token('NAME', p_parent_entity_name );
2361: fnd_message.set_token('CHILD', p_entity_name );
2362: fnd_message.set_token('MESSAGE',l_encoded_message);
2363: fnd_message.raise_error;
2364: end if;
2365: end call_delete_api;
2358: else
2359: fnd_message.set_name('BEN', 'BEN_94160_PDW_DELETE_FAILED');
2360: fnd_message.set_token('NAME', p_parent_entity_name );
2361: fnd_message.set_token('CHILD', p_entity_name );
2362: fnd_message.set_token('MESSAGE',l_encoded_message);
2363: fnd_message.raise_error;
2364: end if;
2365: end call_delete_api;
2366:
2359: fnd_message.set_name('BEN', 'BEN_94160_PDW_DELETE_FAILED');
2360: fnd_message.set_token('NAME', p_parent_entity_name );
2361: fnd_message.set_token('CHILD', p_entity_name );
2362: fnd_message.set_token('MESSAGE',l_encoded_message);
2363: fnd_message.raise_error;
2364: end if;
2365: end call_delete_api;
2366:
2367: -- p_validate 0 means false