49: open c1 ;
50: fetch c1 into l_target_id ;
51: if c1%notfound then
52: close c1 ;
53: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
54: fnd_message.raise_error;
55: end if ;
56: close c1 ;
57: return l_target_id ;
50: fetch c1 into l_target_id ;
51: if c1%notfound then
52: close c1 ;
53: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
54: fnd_message.raise_error;
55: end if ;
56: close c1 ;
57: return l_target_id ;
58: hr_utility.set_location(' Leaving:'||l_proc, 10);
114: hr_utility.set_location('Target Id not found for : ' ||p_table_name||'.'||p_source_column||
115: '.'||p_source_id , 5);
116: ben_dm_utility.message('INFO',' Target ID Error ' ||p_table_name||'.'||p_source_column||
117: '.'||p_source_id ,5) ;
118: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
119: fnd_message.raise_error;
120:
121: end if ;
122:
115: '.'||p_source_id , 5);
116: ben_dm_utility.message('INFO',' Target ID Error ' ||p_table_name||'.'||p_source_column||
117: '.'||p_source_id ,5) ;
118: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
119: fnd_message.raise_error;
120:
121: end if ;
122:
123:
330: open c1 ;
331: fetch c1 into l_target_id ;
332: if c1%notfound then
333: close c1 ;
334: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
335: fnd_message.raise_error;
336: end if ;
337: close c1 ;
338:
331: fetch c1 into l_target_id ;
332: if c1%notfound then
333: close c1 ;
334: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
335: fnd_message.raise_error;
336: end if ;
337: close c1 ;
338:
339: if l_target_id is not null then
451: hr_utility.set_location('Entering:'||l_proc, 5);
452:
453: -- error if table_id and table name is null
454: if p_table_name is null and p_table_id is null then
455: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
456: fnd_message.raise_error;
457: end if ;
458:
459: l_table_name := p_table_name ;
452:
453: -- error if table_id and table name is null
454: if p_table_name is null and p_table_id is null then
455: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
456: fnd_message.raise_error;
457: end if ;
458:
459: l_table_name := p_table_name ;
460: hr_utility.set_location('table_name:'||l_table_name, 5);
464: fetch c1 into l_table_name ;
465: if c1%notfound then
466: close c1 ;
467: hr_utility.set_location('error on table_id :'|| p_table_id , 10);
468: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
469: fnd_message.raise_error;
470: end if ;
471: close c1 ;
472: end if ;
465: if c1%notfound then
466: close c1 ;
467: hr_utility.set_location('error on table_id :'|| p_table_id , 10);
468: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
469: fnd_message.raise_error;
470: end if ;
471: close c1 ;
472: end if ;
473: