DBA Data[Home] [Help]

APPS.GHR_PDI_BUS dependencies on HR_API

Line 63: hr_api.mandatory_arg_error

59: hr_utility.set_location('Entering: '|| l_proc, 10);
60:
61: -- Check Mandatory Parameters are set
62:
63: hr_api.mandatory_arg_error
64: (p_api_name => l_proc,
65: p_argument => 'effective date',
66: p_argument_value => p_effective_date
67: );

Line 83: ((nvl(ghr_pdi_shd.g_old_rec.category,hr_api.g_varchar2)

79: p_object_version_number => p_object_version_number);
80:
81: IF (l_api_updating
82: AND
83: ((nvl(ghr_pdi_shd.g_old_rec.category,hr_api.g_varchar2)
84: <> nvl(p_category,hr_api.g_varchar2))))
85: OR
86: NOT l_api_updating THEN
87:

Line 84: <> nvl(p_category,hr_api.g_varchar2))))

80:
81: IF (l_api_updating
82: AND
83: ((nvl(ghr_pdi_shd.g_old_rec.category,hr_api.g_varchar2)
84: <> nvl(p_category,hr_api.g_varchar2))))
85: OR
86: NOT l_api_updating THEN
87:
88: --

Line 133: hr_api.mandatory_arg_error

129: hr_utility.set_location('Entering: '|| l_proc, 10);
130:
131: -- Check Mandatory Parameters are set
132:
133: hr_api.mandatory_arg_error
134: (p_api_name => l_proc,
135: p_argument => 'effective date',
136: p_argument_value => p_effective_date
137: );

Line 153: ((nvl(ghr_pdi_shd.g_old_rec.flsa,hr_api.g_varchar2)

149: p_object_version_number => p_object_version_number);
150:
151: IF (l_api_updating
152: AND
153: ((nvl(ghr_pdi_shd.g_old_rec.flsa,hr_api.g_varchar2)
154: <> nvl(p_flsa,hr_api.g_varchar2))))
155: OR
156: NOT l_api_updating THEN
157:

Line 154: <> nvl(p_flsa,hr_api.g_varchar2))))

150:
151: IF (l_api_updating
152: AND
153: ((nvl(ghr_pdi_shd.g_old_rec.flsa,hr_api.g_varchar2)
154: <> nvl(p_flsa,hr_api.g_varchar2))))
155: OR
156: NOT l_api_updating THEN
157:
158: --

Line 168: IF hr_api.not_exists_in_hr_lookups

164: --
165:
166: IF p_flsa is NOT NULL THEN
167:
168: IF hr_api.not_exists_in_hr_lookups
169: (p_effective_date => p_effective_date,
170: p_lookup_type => 'GHR_US_FLSA_CATEGORY',
171: p_lookup_code => p_flsa
172: ) THEN

Line 209: hr_api.mandatory_arg_error

205: hr_utility.set_location('Entering: '|| l_proc, 10);
206:
207: -- Check Mandatory Parameters are set
208:
209: hr_api.mandatory_arg_error
210:
211: (p_api_name => l_proc,
212: p_argument => 'effective date',
213: p_argument_value => p_effective_date

Line 230: ((nvl(ghr_pdi_shd.g_old_rec.financial_statement,hr_api.g_varchar2)

226: p_object_version_number => p_object_version_number);
227:
228: IF (l_api_updating
229: AND
230: ((nvl(ghr_pdi_shd.g_old_rec.financial_statement,hr_api.g_varchar2)
231: <> nvl(p_financial_statement,hr_api.g_varchar2))))
232: OR
233: NOT l_api_updating THEN
234: --

Line 231: <> nvl(p_financial_statement,hr_api.g_varchar2))))

227:
228: IF (l_api_updating
229: AND
230: ((nvl(ghr_pdi_shd.g_old_rec.financial_statement,hr_api.g_varchar2)
231: <> nvl(p_financial_statement,hr_api.g_varchar2))))
232: OR
233: NOT l_api_updating THEN
234: --
235: hr_utility.set_location(l_proc,20);

Line 244: IF hr_api.not_exists_in_hr_lookups

240: --
241:
242: IF p_financial_statement is NOT NULL THEN
243:
244: IF hr_api.not_exists_in_hr_lookups
245: (p_effective_date => p_effective_date,
246: p_lookup_type => 'GHR_US_FINANCIAL_STATEMENT',
247: p_lookup_code => p_financial_statement
248: ) THEN

Line 288: hr_api.mandatory_arg_error

284: hr_utility.set_location('Entering: '|| l_proc, 10);
285:
286: -- Check Mandatory Parameters are set
287:
288: hr_api.mandatory_arg_error
289: (p_api_name => l_proc,
290: p_argument => 'effective date',
291: p_argument_value => p_effective_date
292: );

Line 308: ((nvl(ghr_pdi_shd.g_old_rec.subject_to_ia_action,hr_api.g_varchar2)

304: p_object_version_number => p_object_version_number);
305:
306: IF (l_api_updating
307: AND
308: ((nvl(ghr_pdi_shd.g_old_rec.subject_to_ia_action,hr_api.g_varchar2)
309: <> nvl(p_sub_to_ia_action,hr_api.g_varchar2))))
310: OR
311: NOT l_api_updating THEN
312: --

Line 309: <> nvl(p_sub_to_ia_action,hr_api.g_varchar2))))

305:
306: IF (l_api_updating
307: AND
308: ((nvl(ghr_pdi_shd.g_old_rec.subject_to_ia_action,hr_api.g_varchar2)
309: <> nvl(p_sub_to_ia_action,hr_api.g_varchar2))))
310: OR
311: NOT l_api_updating THEN
312: --
313: hr_utility.set_location(l_proc,20);

Line 322: IF hr_api.not_exists_in_hr_lookups

318: --
319:
320: IF p_sub_to_ia_action is NOT NULL THEN
321:
322: IF hr_api.not_exists_in_hr_lookups
323: (p_effective_date => p_effective_date,
324: p_lookup_type => 'YES_NO',
325: p_lookup_code => p_sub_to_ia_action
326: ) THEN

Line 366: hr_api.mandatory_arg_error

362: hr_utility.set_location('Entering: '|| l_proc, 10);
363:
364: -- Check Mandatory Parameters are set
365:
366: hr_api.mandatory_arg_error
367: (p_api_name => l_proc,
368: p_argument => 'effective date',
369: p_argument_value => p_effective_date
370: );

Line 386: ((nvl(ghr_pdi_shd.g_old_rec.position_status,hr_api.g_number)

382: p_object_version_number => p_object_version_number);
383:
384: IF (l_api_updating
385: AND
386: ((nvl(ghr_pdi_shd.g_old_rec.position_status,hr_api.g_number)
387: <> nvl(p_position_status,hr_api.g_number))))
388: OR
389: NOT l_api_updating THEN
390:

Line 387: <> nvl(p_position_status,hr_api.g_number))))

383:
384: IF (l_api_updating
385: AND
386: ((nvl(ghr_pdi_shd.g_old_rec.position_status,hr_api.g_number)
387: <> nvl(p_position_status,hr_api.g_number))))
388: OR
389: NOT l_api_updating THEN
390:
391: --

Line 401: IF hr_api.not_exists_in_hr_lookups

397: --
398:
399: IF p_position_status is NOT NULL THEN
400:
401: IF hr_api.not_exists_in_hr_lookups
402: (p_effective_date => p_effective_date,
403: p_lookup_type => 'GHR_US_POSITION_OCCUPIED',
404: p_lookup_code => p_position_status
405: ) THEN

Line 445: hr_api.mandatory_arg_error

441: hr_utility.set_location('Entering: '|| l_proc, 10);
442:
443: -- Check Mandatory Parameters are set
444:
445: hr_api.mandatory_arg_error
446: (p_api_name => l_proc,
447: p_argument => 'effective date',
448: p_argument_value => p_effective_date
449: );

Line 465: ((nvl(ghr_pdi_shd.g_old_rec.position_is,hr_api.g_varchar2)

461: p_object_version_number => p_object_version_number);
462:
463: IF (l_api_updating
464: AND
465: ((nvl(ghr_pdi_shd.g_old_rec.position_is,hr_api.g_varchar2)
466: <> nvl(p_position_is,hr_api.g_varchar2))))
467: OR
468: NOT l_api_updating THEN
469:

Line 466: <> nvl(p_position_is,hr_api.g_varchar2))))

462:
463: IF (l_api_updating
464: AND
465: ((nvl(ghr_pdi_shd.g_old_rec.position_is,hr_api.g_varchar2)
466: <> nvl(p_position_is,hr_api.g_varchar2))))
467: OR
468: NOT l_api_updating THEN
469:
470: --

Line 480: IF hr_api.not_exists_in_hr_lookups

476: --
477:
478: IF p_position_is is NOT NULL THEN
479:
480: IF hr_api.not_exists_in_hr_lookups
481: (p_effective_date => p_effective_date,
482: p_lookup_type => 'GHR_US_SUPERVISORY_STATUS',
483: p_lookup_code => p_position_is
484: ) THEN

Line 523: hr_api.mandatory_arg_error

519: hr_utility.set_location('Entering: '|| l_proc, 10);
520:
521: -- Check Mandatory Parameters are set
522:
523: hr_api.mandatory_arg_error
524: (p_api_name => l_proc,
525: p_argument => 'effective date',
526: p_argument_value => p_effective_date
527: );

Line 543: ((nvl(ghr_pdi_shd.g_old_rec.position_sensitivity,hr_api.g_varchar2)

539: p_object_version_number => p_object_version_number);
540:
541: IF (l_api_updating
542: AND
543: ((nvl(ghr_pdi_shd.g_old_rec.position_sensitivity,hr_api.g_varchar2)
544: <> nvl(p_position_sensitivity,hr_api.g_varchar2))))
545: OR
546: NOT l_api_updating THEN
547:

Line 544: <> nvl(p_position_sensitivity,hr_api.g_varchar2))))

540:
541: IF (l_api_updating
542: AND
543: ((nvl(ghr_pdi_shd.g_old_rec.position_sensitivity,hr_api.g_varchar2)
544: <> nvl(p_position_sensitivity,hr_api.g_varchar2))))
545: OR
546: NOT l_api_updating THEN
547:
548: --

Line 558: IF hr_api.not_exists_in_hr_lookups

554: --
555:
556: IF p_position_sensitivity is NOT NULL THEN
557:
558: IF hr_api.not_exists_in_hr_lookups
559: (p_effective_date => p_effective_date,
560: p_lookup_type => 'GHR_US_POSN_SENSITIVITY',
561: p_lookup_code => p_position_sensitivity
562: ) THEN

Line 601: hr_api.mandatory_arg_error

597: hr_utility.set_location('Entering: '|| l_proc, 10);
598:
599: -- Check Mandatory Parameters are set
600:
601: hr_api.mandatory_arg_error
602: (p_api_name => l_proc,
603: p_argument => 'effective date',
604: p_argument_value => p_effective_date
605: );

Line 621: ((nvl(ghr_pdi_shd.g_old_rec.competitive_level,hr_api.g_varchar2)

617: p_object_version_number => p_object_version_number);
618:
619: IF (l_api_updating
620: AND
621: ((nvl(ghr_pdi_shd.g_old_rec.competitive_level,hr_api.g_varchar2)
622: <> nvl(p_competitive_level,hr_api.g_varchar2))))
623: OR
624: NOT l_api_updating THEN
625:

Line 622: <> nvl(p_competitive_level,hr_api.g_varchar2))))

618:
619: IF (l_api_updating
620: AND
621: ((nvl(ghr_pdi_shd.g_old_rec.competitive_level,hr_api.g_varchar2)
622: <> nvl(p_competitive_level,hr_api.g_varchar2))))
623: OR
624: NOT l_api_updating THEN
625:
626:

Line 636: -- IF hr_api.not_exists_in_hr_lookups

632: --
633:
634: -- IF p_competitive_level is NOT NULL THEN
635: --
636: -- IF hr_api.not_exists_in_hr_lookups
637: -- (p_effective_date => p_effective_date,
638: -- p_lookup_type => 'GHR_US_COMP_LEVEL',
639: -- p_lookup_code => p_competitive_level
640: -- ) THEN

Line 680: hr_api.mandatory_arg_error

676: hr_utility.set_location('Entering: '|| l_proc, 10);
677:
678: -- Check Mandatory Parameters are set
679:
680: hr_api.mandatory_arg_error
681: (p_api_name => l_proc,
682: p_argument => 'effective date',
683: p_argument_value => p_effective_date
684: );

Line 700: ((nvl(ghr_pdi_shd.g_old_rec.career_ladder,hr_api.g_varchar2)

696: p_object_version_number => p_object_version_number);
697:
698: IF (l_api_updating
699: AND
700: ((nvl(ghr_pdi_shd.g_old_rec.career_ladder,hr_api.g_varchar2)
701: <> nvl(p_career_ladder,hr_api.g_varchar2))))
702: OR
703: NOT l_api_updating THEN
704:

Line 701: <> nvl(p_career_ladder,hr_api.g_varchar2))))

697:
698: IF (l_api_updating
699: AND
700: ((nvl(ghr_pdi_shd.g_old_rec.career_ladder,hr_api.g_varchar2)
701: <> nvl(p_career_ladder,hr_api.g_varchar2))))
702: OR
703: NOT l_api_updating THEN
704:
705: --

Line 715: IF hr_api.not_exists_in_hr_lookups

711: --
712:
713: IF p_career_ladder is NOT NULL THEN
714:
715: IF hr_api.not_exists_in_hr_lookups
716: (p_effective_date => p_effective_date,
717: p_lookup_type => 'YES_NO',
718: p_lookup_code => p_career_ladder
719: ) THEN

Line 806: IF NVL(p_rec.date_to, hr_api.g_date)

802: /*
803:
804: -- To be changed in the screens to base it on the user role.
805:
806: IF NVL(p_rec.date_to, hr_api.g_date)
807: <> NVL(ghr_pdi_shd.g_old_rec.date_to,hr_api.g_date)
808: THEN
809:
810: l_argument := 'date_to';

Line 807: <> NVL(ghr_pdi_shd.g_old_rec.date_to,hr_api.g_date)

803:
804: -- To be changed in the screens to base it on the user role.
805:
806: IF NVL(p_rec.date_to, hr_api.g_date)
807: <> NVL(ghr_pdi_shd.g_old_rec.date_to,hr_api.g_date)
808: THEN
809:
810: l_argument := 'date_to';
811: RAISE l_error;

Line 816: IF NVL(p_rec.opm_cert_num, hr_api.g_number)

812: END IF;
813:
814: */
815:
816: IF NVL(p_rec.opm_cert_num, hr_api.g_number)
817: <> NVL(ghr_pdi_shd.g_old_rec.opm_cert_num,hr_api.g_number)
818: THEN
819:
820: l_argument := 'opm_cert_num';

Line 817: <> NVL(ghr_pdi_shd.g_old_rec.opm_cert_num,hr_api.g_number)

813:
814: */
815:
816: IF NVL(p_rec.opm_cert_num, hr_api.g_number)
817: <> NVL(ghr_pdi_shd.g_old_rec.opm_cert_num,hr_api.g_number)
818: THEN
819:
820: l_argument := 'opm_cert_num';
821: RAISE l_error;

Line 832: hr_api.argument_changed_error

828: EXCEPTION
829:
830: WHEN l_error THEN
831:
832: hr_api.argument_changed_error
833:
834: (p_api_name => l_proc,
835: p_argument => l_argument);
836: