114: --
115:
116: hr_utility.set_location(l_proc, 10);
117:
118: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_format);
119: if l_format is not null then
120: hr_utility.trace(l_format);
121: else
122: hr_utility.trace('Couldn''t get profile value. Setting to DD-MM-YYYY');
382: END IF;
383:
384: hr_utility.set_location(l_proc, 21);
385:
386: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_format);
387: if l_format is not null then
388: hr_utility.trace(l_format);
389: else
390: hr_utility.trace('Couldn''t get profile value. Setting to DD-MM-YYYY');
483: and ppp.pre_payment_id = paa2.pre_payment_id;
484:
485: END IF;
486:
487: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_format);
488: if l_format is not null then
489: hr_utility.trace(l_format);
490: else
491: hr_utility.trace('Couldn''t get profile value. Setting to DD-MM-YYYY');
587: and action_status = 'P';
588:
589: dbms_lock.sleep(5*l_temp);
590:
591: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_format);
592: if l_format is not null then
593: hr_utility.trace(l_format);
594: else
595: hr_utility.trace('Couldn''t get profile value. Setting to DD-MM-YYYY');