DBA Data[Home] [Help]

APPS.PER_PL_ASSIGNMENT dependencies on HR_API

Line 110: hr_api.mandatory_arg_error --Contract Category is mandatory

106: END IF;
107: hr_utility.set_location(l_proc,10);
108:
109:
110: hr_api.mandatory_arg_error --Contract Category is mandatory
111: (p_api_name => l_proc,
112: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_CATEGORY'),
113: p_argument_value => p_scl_segment3
114: );

Line 116: hr_api.mandatory_arg_error --Contract Type is Mandatory

112: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_CATEGORY'),
113: p_argument_value => p_scl_segment3
114: );
115:
116: hr_api.mandatory_arg_error --Contract Type is Mandatory
117: (p_api_name => l_proc,
118: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE'),
119: p_argument_value => p_scl_segment4
120: );

Line 123: hr_api.mandatory_arg_error --Contract Number is Mandatory

119: p_argument_value => p_scl_segment4
120: );
121:
122:
123: hr_api.mandatory_arg_error --Contract Number is Mandatory
124: (p_api_name => l_proc,
125: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_NUMBER'),
126: p_argument_value => p_scl_segment5
127: );

Line 129: hr_api.mandatory_arg_error --Contract Start Date is mandatory

125: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_NUMBER'),
126: p_argument_value => p_scl_segment5
127: );
128:
129: hr_api.mandatory_arg_error --Contract Start Date is mandatory
130: (p_api_name => l_proc,
131: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'),
132: p_argument_value => p_scl_segment11
133: );

Line 135: hr_api.mandatory_arg_error --Date Contract Signed is mandatory

131: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'),
132: p_argument_value => p_scl_segment11
133: );
134:
135: hr_api.mandatory_arg_error --Date Contract Signed is mandatory
136: (p_api_name => l_proc,
137: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'),
138: p_argument_value => p_scl_segment14
139: );

Line 146: hr_api.mandatory_arg_error

142: ------Conditionally mandatory---------
143: --------for a normal contract,the assignment category is mandatory...
144: -------core store this in employment_category in per_all_assignments_f table..displays it as assignment_category on UI
145: if p_scl_segment3='NORMAL' then
146: hr_api.mandatory_arg_error
147: (p_api_name => l_proc,
148: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_CATEGORY'),
149: p_argument_value => P_EMPLOYMENT_CATEGORY
150: );

Line 155: hr_api.mandatory_arg_error

151: end if;
152:
153:
154: if p_scl_segment3='NORMAL' and p_scl_segment4<>'N01' then
155: hr_api.mandatory_arg_error
156: (p_api_name => l_proc,
157: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'),
158: p_argument_value => P_SCL_SEGMENT12
159: );

Line 168: hr_api.mandatory_arg_error

164:
165: -----if any of the following 3 has been entered then ..other two become mandatory
166: -----Notice Period Date(p_scl_segment15),Notice Period End Date(p_scl_segment16),Notice Period(p_notice_period)
167: if p_scl_segment16||p_scl_segment15||p_notice_period is not null then
168: hr_api.mandatory_arg_error
169: (p_api_name => l_proc,
170: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'),
171: p_argument_value => p_scl_segment16
172: );

Line 173: hr_api.mandatory_arg_error

169: (p_api_name => l_proc,
170: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'),
171: p_argument_value => p_scl_segment16
172: );
173: hr_api.mandatory_arg_error
174: (p_api_name => l_proc,
175: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'),
176: p_argument_value => p_scl_segment15
177: );

Line 178: hr_api.mandatory_arg_error

174: (p_api_name => l_proc,
175: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'),
176: p_argument_value => p_scl_segment15
177: );
178: hr_api.mandatory_arg_error
179: (p_api_name => l_proc,
180: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD'),
181: p_argument_value => p_notice_period
182: );

Line 413: hr_api.mandatory_arg_error --Contract Category is mandatory

409: return;
410: END IF;
411: hr_utility.set_location(l_proc,10);
412: l_person_id:= get_person_id(p_assignment_id,p_effective_date);
413: hr_api.mandatory_arg_error --Contract Category is mandatory
414: (p_api_name => l_proc,
415: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_CATEGORY'),
416: p_argument_value => p_segment3
417: );

Line 419: hr_api.mandatory_arg_error --Contract Type is Mandatory

415: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_CATEGORY'),
416: p_argument_value => p_segment3
417: );
418:
419: hr_api.mandatory_arg_error --Contract Type is Mandatory
420: (p_api_name => l_proc,
421: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE'),
422: p_argument_value => p_segment4
423: );

Line 426: hr_api.mandatory_arg_error --Contract Number is Mandatory

422: p_argument_value => p_segment4
423: );
424:
425:
426: hr_api.mandatory_arg_error --Contract Number is Mandatory
427: (p_api_name => l_proc,
428: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_NUMBER'),
429: p_argument_value => p_segment5
430: );

Line 432: hr_api.mandatory_arg_error --Contract Start Date is mandatory

428: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_NUMBER'),
429: p_argument_value => p_segment5
430: );
431:
432: hr_api.mandatory_arg_error --Contract Start Date is mandatory
433: (p_api_name => l_proc,
434: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'),
435: p_argument_value => p_segment11
436: );

Line 438: hr_api.mandatory_arg_error --Date Contract Signed is mandatory

434: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'),
435: p_argument_value => p_segment11
436: );
437:
438: hr_api.mandatory_arg_error --Date Contract Signed is mandatory
439: (p_api_name => l_proc,
440: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'),
441: p_argument_value => p_segment14
442: );

Line 457: hr_api.mandatory_arg_error

453: l_employment_category:=null;
454: open csr_get_payroll_emp_cat;
455: fetch csr_get_payroll_emp_cat into l_payroll_id,l_employment_category;
456: close csr_get_payroll_emp_cat;
457: hr_api.mandatory_arg_error
458: (p_api_name => l_proc,
459: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_CATEGORY'),
460: p_argument_value => l_employment_category
461: );

Line 465: hr_api.mandatory_arg_error

461: );
462: end if;
463:
464: if p_segment3='NORMAL' and p_segment4<>'N01' then
465: hr_api.mandatory_arg_error
466: (p_api_name => l_proc,
467: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'),
468: p_argument_value => P_SEGMENT12
469: );

Line 470: elsif p_segment12<>hr_api.g_varchar2 then --replaced in 115.11

466: (p_api_name => l_proc,
467: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'),
468: p_argument_value => P_SEGMENT12
469: );
470: elsif p_segment12<>hr_api.g_varchar2 then --replaced in 115.11
471: --Bug 5386451
472: hr_utility.set_message(800,'HR_375869_PLANNED_DATE_INVALID');
473: hr_utility.raise_error;
474: end if;

Line 479: hr_api.mandatory_arg_error

475:
476: -----if any of the following 3 has been entered then ..other two become mandatory
477: -----Notice Period Date(p_scl_segment15),Notice Period End Date(p_scl_segment16),Notice Period(p_notice_period)
478: if p_segment16||p_segment15||p_notice_period is not null then
479: hr_api.mandatory_arg_error
480: (p_api_name => l_proc,
481: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'),
482: p_argument_value => p_segment16
483: );

Line 484: hr_api.mandatory_arg_error

480: (p_api_name => l_proc,
481: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'),
482: p_argument_value => p_segment16
483: );
484: hr_api.mandatory_arg_error
485: (p_api_name => l_proc,
486: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'),
487: p_argument_value => p_segment15
488: );

Line 489: hr_api.mandatory_arg_error

485: (p_api_name => l_proc,
486: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'),
487: p_argument_value => p_segment15
488: );
489: hr_api.mandatory_arg_error
490: (p_api_name => l_proc,
491: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD'),
492: p_argument_value => p_notice_period
493: );

Line 888: hr_api.mandatory_arg_error

884: fetch csr_get_contract_cat into l_contract_category;
885: close csr_get_contract_cat;
886: if l_contract_category='NORMAL' then
887: hr_utility.set_location(l_proc,20);
888: hr_api.mandatory_arg_error
889: (p_api_name => l_proc,
890: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_CATEGORY'),
891: p_argument_value => p_employment_category
892: );

Line 896: --if p_payroll_id is not null then Replace null with hr_api.g_number in 115.10

892: );
893: end if;
894:
895:
896: --if p_payroll_id is not null then Replace null with hr_api.g_number in 115.10
897: --Bug 5386451
898: if p_payroll_id <> hr_api.g_number then
899: hr_utility.set_location(l_proc,30);
900: open csr_oldage_taxoffice_check(l_person_id,p_effective_date);

Line 898: if p_payroll_id <> hr_api.g_number then

894:
895:
896: --if p_payroll_id is not null then Replace null with hr_api.g_number in 115.10
897: --Bug 5386451
898: if p_payroll_id <> hr_api.g_number then
899: hr_utility.set_location(l_proc,30);
900: open csr_oldage_taxoffice_check(l_person_id,p_effective_date);
901: fetch csr_oldage_taxoffice_check into l_oldage_pension_rights,l_tax_office ;
902: close csr_oldage_taxoffice_check;

Line 1071: if p_segment3 = hr_api.g_varchar2 then

1067:
1068: l_record_exists := '0';
1069: l_segment3 := p_segment3;
1070:
1071: if p_segment3 = hr_api.g_varchar2 then
1072: open csr_segment3;
1073: fetch csr_segment3 into l_segment3;
1074: close csr_segment3;
1075: end if;