134: -- The previous 'old' created row has not been found. We need
135: -- to error as an internal datetrack problem exists.
136: --
137: Close C_Sel1;
138: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
139: fnd_message.set_token('PROCEDURE', l_proc);
140: fnd_message.set_token('STEP','10');
141: fnd_message.raise_error;
142: End If;
135: -- to error as an internal datetrack problem exists.
136: --
137: Close C_Sel1;
138: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
139: fnd_message.set_token('PROCEDURE', l_proc);
140: fnd_message.set_token('STEP','10');
141: fnd_message.raise_error;
142: End If;
143: Close C_Sel1;
136: --
137: Close C_Sel1;
138: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
139: fnd_message.set_token('PROCEDURE', l_proc);
140: fnd_message.set_token('STEP','10');
141: fnd_message.raise_error;
142: End If;
143: Close C_Sel1;
144: --
137: Close C_Sel1;
138: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
139: fnd_message.set_token('PROCEDURE', l_proc);
140: fnd_message.set_token('STEP','10');
141: fnd_message.raise_error;
142: End If;
143: Close C_Sel1;
144: --
145: -- Set the AOL updated WHO values
373: Close C_Sel2;
374: --
375: -- The primary key values are already in use.
376: --
377: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
378: fnd_message.set_token('TABLE_NAME','per_spinal_point_steps_f');
379: fnd_message.raise_error;
380: End If;
381: Close C_Sel2;
374: --
375: -- The primary key values are already in use.
376: --
377: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
378: fnd_message.set_token('TABLE_NAME','per_spinal_point_steps_f');
379: fnd_message.raise_error;
380: End If;
381: Close C_Sel2;
382: --
375: -- The primary key values are already in use.
376: --
377: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
378: fnd_message.set_token('TABLE_NAME','per_spinal_point_steps_f');
379: fnd_message.raise_error;
380: End If;
381: Close C_Sel2;
382: --
383: -- Use registered key values and clear globals
485: hr_utility.trace('pqh_gsp_sync_compensation_obj.create_option_for_point : '
486: || l_return);
487: --
488: if l_return <> 'SUCCESS' Then
489: l_message := fnd_message.get;
490: hr_utility.trace('error message : ' || l_message);
491: fnd_message.set_name('PER','HR_289527_CRE_OPTION_FOR_POINT');
492: if l_message is not null then
493: fnd_message.set_token('ERR_CODE',l_message);
487: --
488: if l_return <> 'SUCCESS' Then
489: l_message := fnd_message.get;
490: hr_utility.trace('error message : ' || l_message);
491: fnd_message.set_name('PER','HR_289527_CRE_OPTION_FOR_POINT');
492: if l_message is not null then
493: fnd_message.set_token('ERR_CODE',l_message);
494: else
495: fnd_message.set_token('ERR_CODE','-1');
489: l_message := fnd_message.get;
490: hr_utility.trace('error message : ' || l_message);
491: fnd_message.set_name('PER','HR_289527_CRE_OPTION_FOR_POINT');
492: if l_message is not null then
493: fnd_message.set_token('ERR_CODE',l_message);
494: else
495: fnd_message.set_token('ERR_CODE','-1');
496: end if;
497: --
491: fnd_message.set_name('PER','HR_289527_CRE_OPTION_FOR_POINT');
492: if l_message is not null then
493: fnd_message.set_token('ERR_CODE',l_message);
494: else
495: fnd_message.set_token('ERR_CODE','-1');
496: end if;
497: --
498: fnd_message.raise_error;
499: End if;
494: else
495: fnd_message.set_token('ERR_CODE','-1');
496: end if;
497: --
498: fnd_message.raise_error;
499: End if;
500:
501: */ -- End of BUG3179239
502:
511: hr_utility.trace('pqh_gsp_sync_compensation_obj.oipl_for_step : '
512: || l_return);
513: --
514: if l_return <> 'SUCCESS' Then
515: l_message := fnd_message.get;
516: hr_utility.trace('error message : ' || l_message);
517: fnd_message.set_name('PER','HR_289528_CRE_OPTION_IN_PLAN');
518: if l_message is not null then
519: fnd_message.set_token('ERR_CODE',l_message);
513: --
514: if l_return <> 'SUCCESS' Then
515: l_message := fnd_message.get;
516: hr_utility.trace('error message : ' || l_message);
517: fnd_message.set_name('PER','HR_289528_CRE_OPTION_IN_PLAN');
518: if l_message is not null then
519: fnd_message.set_token('ERR_CODE',l_message);
520: else
521: fnd_message.set_token('ERR_CODE','-1');
515: l_message := fnd_message.get;
516: hr_utility.trace('error message : ' || l_message);
517: fnd_message.set_name('PER','HR_289528_CRE_OPTION_IN_PLAN');
518: if l_message is not null then
519: fnd_message.set_token('ERR_CODE',l_message);
520: else
521: fnd_message.set_token('ERR_CODE','-1');
522: end if;
523: --
517: fnd_message.set_name('PER','HR_289528_CRE_OPTION_IN_PLAN');
518: if l_message is not null then
519: fnd_message.set_token('ERR_CODE',l_message);
520: else
521: fnd_message.set_token('ERR_CODE','-1');
522: end if;
523: --
524: fnd_message.raise_error;
525: End if;
520: else
521: fnd_message.set_token('ERR_CODE','-1');
522: end if;
523: --
524: fnd_message.raise_error;
525: End if;
526: end if;
527: --
528: hr_utility.set_location(l_proc, 20);