eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PL_ASSIGNMENT dependencies on HR_API

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

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

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

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

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

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

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

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

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

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

Line 147: hr_api.mandatory_arg_error

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

Line 156: hr_api.mandatory_arg_error

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

Line 169: hr_api.mandatory_arg_error

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

Line 174: hr_api.mandatory_arg_error

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

Line 179: hr_api.mandatory_arg_error

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

Line 459: to hr_api.g_varchar2. Added a check that when the mandatory arguments are not specified,

455: l_segment3,l_segment4,l_segment5,l_segment11,l_segment12,l_segment13,l_segment14,l_segment15,l_segment16;
456: close csr_get_segment_details;
457:
458: /*If the mandatory arguments are not specified in the call, then it will be defaulted
459: to hr_api.g_varchar2. Added a check that when the mandatory arguments are not specified,
460: check whether these details are already present for the assignment. If not, raise
461: error --Added for Bug 7554037*/
462:
463: IF (p_segment3 is null OR p_segment3 <> hr_api.g_varchar2) then

Line 463: IF (p_segment3 is null OR p_segment3 <> hr_api.g_varchar2) then

459: to hr_api.g_varchar2. Added a check that when the mandatory arguments are not specified,
460: check whether these details are already present for the assignment. If not, raise
461: error --Added for Bug 7554037*/
462:
463: IF (p_segment3 is null OR p_segment3 <> hr_api.g_varchar2) then
464: l_segment3:=p_segment3;
465: END if;
466: IF (p_segment4 is null OR p_segment4 <> hr_api.g_varchar2) then
467: l_segment4:=p_segment4;

Line 466: IF (p_segment4 is null OR p_segment4 <> hr_api.g_varchar2) then

462:
463: IF (p_segment3 is null OR p_segment3 <> hr_api.g_varchar2) then
464: l_segment3:=p_segment3;
465: END if;
466: IF (p_segment4 is null OR p_segment4 <> hr_api.g_varchar2) then
467: l_segment4:=p_segment4;
468: END if;
469: IF (p_segment5 is null OR p_segment5 <> hr_api.g_varchar2) then
470: l_segment5:=p_segment5;

Line 469: IF (p_segment5 is null OR p_segment5 <> hr_api.g_varchar2) then

465: END if;
466: IF (p_segment4 is null OR p_segment4 <> hr_api.g_varchar2) then
467: l_segment4:=p_segment4;
468: END if;
469: IF (p_segment5 is null OR p_segment5 <> hr_api.g_varchar2) then
470: l_segment5:=p_segment5;
471: END if;
472: IF (p_segment11 is null OR p_segment11 <> hr_api.g_varchar2) then
473: l_segment11:=p_segment11;

Line 472: IF (p_segment11 is null OR p_segment11 <> hr_api.g_varchar2) then

468: END if;
469: IF (p_segment5 is null OR p_segment5 <> hr_api.g_varchar2) then
470: l_segment5:=p_segment5;
471: END if;
472: IF (p_segment11 is null OR p_segment11 <> hr_api.g_varchar2) then
473: l_segment11:=p_segment11;
474: END if;
475: if (p_segment12 is null OR p_segment12 <> hr_api.g_varchar2) then
476: l_segment12:=p_segment12;

Line 475: if (p_segment12 is null OR p_segment12 <> hr_api.g_varchar2) then

471: END if;
472: IF (p_segment11 is null OR p_segment11 <> hr_api.g_varchar2) then
473: l_segment11:=p_segment11;
474: END if;
475: if (p_segment12 is null OR p_segment12 <> hr_api.g_varchar2) then
476: l_segment12:=p_segment12;
477: END if;
478: if (p_segment13 is null OR p_segment13 <> hr_api.g_varchar2) then
479: l_segment13:=p_segment13;

Line 478: if (p_segment13 is null OR p_segment13 <> hr_api.g_varchar2) then

474: END if;
475: if (p_segment12 is null OR p_segment12 <> hr_api.g_varchar2) then
476: l_segment12:=p_segment12;
477: END if;
478: if (p_segment13 is null OR p_segment13 <> hr_api.g_varchar2) then
479: l_segment13:=p_segment13;
480: END if;
481: IF (p_segment14 is null OR p_segment14 <> hr_api.g_varchar2) then
482: l_segment14:=p_segment14;

Line 481: IF (p_segment14 is null OR p_segment14 <> hr_api.g_varchar2) then

477: END if;
478: if (p_segment13 is null OR p_segment13 <> hr_api.g_varchar2) then
479: l_segment13:=p_segment13;
480: END if;
481: IF (p_segment14 is null OR p_segment14 <> hr_api.g_varchar2) then
482: l_segment14:=p_segment14;
483: END if;
484: IF (p_segment15 is null OR p_segment15 <> hr_api.g_varchar2) then
485: l_segment15:=p_segment15;

Line 484: IF (p_segment15 is null OR p_segment15 <> hr_api.g_varchar2) then

480: END if;
481: IF (p_segment14 is null OR p_segment14 <> hr_api.g_varchar2) then
482: l_segment14:=p_segment14;
483: END if;
484: IF (p_segment15 is null OR p_segment15 <> hr_api.g_varchar2) then
485: l_segment15:=p_segment15;
486: END if;
487: IF (p_segment16 is null OR p_segment16 <> hr_api.g_varchar2) then
488: l_segment16:=p_segment16;

Line 487: IF (p_segment16 is null OR p_segment16 <> hr_api.g_varchar2) then

483: END if;
484: IF (p_segment15 is null OR p_segment15 <> hr_api.g_varchar2) then
485: l_segment15:=p_segment15;
486: END if;
487: IF (p_segment16 is null OR p_segment16 <> hr_api.g_varchar2) then
488: l_segment16:=p_segment16;
489: END if;
490:
491:

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

500:
501: -- Bug#11888146
502:
503:
504: hr_api.mandatory_arg_error --Contract Category is mandatory
505: (p_api_name => l_proc,
506: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_CATEGORY'),
507: p_argument_value => l_segment3
508: );

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

506: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_CATEGORY'),
507: p_argument_value => l_segment3
508: );
509:
510: hr_api.mandatory_arg_error --Contract Type is Mandatory
511: (p_api_name => l_proc,
512: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE'),
513: p_argument_value => l_segment4
514: );

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

512: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE'),
513: p_argument_value => l_segment4
514: );
515:
516: hr_api.mandatory_arg_error --Contract Number is Mandatory
517: (p_api_name => l_proc,
518: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_NUMBER'),
519: p_argument_value => l_segment5
520: );

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

518: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_NUMBER'),
519: p_argument_value => l_segment5
520: );
521:
522: hr_api.mandatory_arg_error --Contract Start Date is mandatory
523: (p_api_name => l_proc,
524: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'),
525: p_argument_value => l_segment11
526: );

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

524: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'),
525: p_argument_value => l_segment11
526: );
527:
528: hr_api.mandatory_arg_error --Date Contract Signed is mandatory
529: (p_api_name => l_proc,
530: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'),
531: p_argument_value => l_segment14
532: );

Line 548: hr_api.mandatory_arg_error

544: l_employment_category:=null;
545: open csr_get_payroll_emp_cat;
546: fetch csr_get_payroll_emp_cat into l_payroll_id,l_employment_category;
547: close csr_get_payroll_emp_cat;
548: hr_api.mandatory_arg_error
549: (p_api_name => l_proc,
550: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_CATEGORY'),
551: p_argument_value => l_employment_category
552: );

Line 556: hr_api.mandatory_arg_error

552: );
553: end if;
554:
555: if l_segment3='NORMAL' and l_segment4<>'N01' then
556: hr_api.mandatory_arg_error
557: (p_api_name => l_proc,
558: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'),
559: p_argument_value => l_SEGMENT12
560: );

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

557: (p_api_name => l_proc,
558: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'),
559: p_argument_value => l_SEGMENT12
560: );
561: elsif p_segment12<>hr_api.g_varchar2 then --replaced in 115.11
562: --Bug 5386451
563: hr_utility.set_message(800,'HR_375869_PLANNED_DATE_INVALID');
564: hr_utility.raise_error;
565: end if;

Line 572: SELECT decode(p_segment16,hr_api.g_varchar2,l_segment16,p_segment16)||

568: OPEN csr_get_notice_details;
569: FETCH csr_get_notice_details INTO l_notice_period,l_notice_uom;
570: CLOSE csr_get_notice_details;
571:
572: SELECT decode(p_segment16,hr_api.g_varchar2,l_segment16,p_segment16)||
573: decode(p_segment15,hr_api.g_varchar2,l_segment15,p_segment15)||
574: decode(p_notice_period,hr_api.g_number,l_notice_period,p_notice_period)
575: INTO l_notice_concat FROM dual;
576:

Line 573: decode(p_segment15,hr_api.g_varchar2,l_segment15,p_segment15)||

569: FETCH csr_get_notice_details INTO l_notice_period,l_notice_uom;
570: CLOSE csr_get_notice_details;
571:
572: SELECT decode(p_segment16,hr_api.g_varchar2,l_segment16,p_segment16)||
573: decode(p_segment15,hr_api.g_varchar2,l_segment15,p_segment15)||
574: decode(p_notice_period,hr_api.g_number,l_notice_period,p_notice_period)
575: INTO l_notice_concat FROM dual;
576:
577: IF (p_notice_period is null OR p_notice_period <> hr_api.g_number) then

Line 574: decode(p_notice_period,hr_api.g_number,l_notice_period,p_notice_period)

570: CLOSE csr_get_notice_details;
571:
572: SELECT decode(p_segment16,hr_api.g_varchar2,l_segment16,p_segment16)||
573: decode(p_segment15,hr_api.g_varchar2,l_segment15,p_segment15)||
574: decode(p_notice_period,hr_api.g_number,l_notice_period,p_notice_period)
575: INTO l_notice_concat FROM dual;
576:
577: IF (p_notice_period is null OR p_notice_period <> hr_api.g_number) then
578: l_notice_period:=p_notice_period;

Line 577: IF (p_notice_period is null OR p_notice_period <> hr_api.g_number) then

573: decode(p_segment15,hr_api.g_varchar2,l_segment15,p_segment15)||
574: decode(p_notice_period,hr_api.g_number,l_notice_period,p_notice_period)
575: INTO l_notice_concat FROM dual;
576:
577: IF (p_notice_period is null OR p_notice_period <> hr_api.g_number) then
578: l_notice_period:=p_notice_period;
579: END if;
580: IF (p_NOTICE_PERIOD_UOM is null OR p_NOTICE_PERIOD_UOM <> hr_api.g_varchar2) then
581: l_notice_uom :=p_NOTICE_PERIOD_UOM;

Line 580: IF (p_NOTICE_PERIOD_UOM is null OR p_NOTICE_PERIOD_UOM <> hr_api.g_varchar2) then

576:
577: IF (p_notice_period is null OR p_notice_period <> hr_api.g_number) then
578: l_notice_period:=p_notice_period;
579: END if;
580: IF (p_NOTICE_PERIOD_UOM is null OR p_NOTICE_PERIOD_UOM <> hr_api.g_varchar2) then
581: l_notice_uom :=p_NOTICE_PERIOD_UOM;
582: END if;
583:
584: -----if any of the following 3 has been entered then ..other two become mandatory

Line 587: hr_api.mandatory_arg_error

583:
584: -----if any of the following 3 has been entered then ..other two become mandatory
585: -----Notice Period Date(p_scl_segment15),Notice Period End Date(p_scl_segment16),Notice Period(p_notice_period)
586: if l_notice_concat is not null THEN --Modified for Bug 7554037
587: hr_api.mandatory_arg_error
588: (p_api_name => l_proc,
589: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'),
590: p_argument_value => l_segment16
591: );

Line 593: hr_api.mandatory_arg_error

589: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'),
590: p_argument_value => l_segment16
591: );
592:
593: hr_api.mandatory_arg_error
594: (p_api_name => l_proc,
595: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'),
596: p_argument_value => l_segment15
597: );

Line 599: hr_api.mandatory_arg_error

595: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'),
596: p_argument_value => l_segment15
597: );
598:
599: hr_api.mandatory_arg_error
600: (p_api_name => l_proc,
601: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD'),
602: p_argument_value => l_notice_period
603: );

Line 606: hr_api.mandatory_arg_error

602: p_argument_value => l_notice_period
603: );
604:
605: --If notice_period is passed, p_NOTICE_PERIOD_UOM is mandatory
606: hr_api.mandatory_arg_error
607: (p_api_name => l_proc,
608: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_UNIT'),
609: p_argument_value => l_notice_uom
610: );

Line 656: if (l_contract_category <> p_segment3) AND (p_segment3 <> hr_api.g_varchar2) then --changed for Bug 7510498

652: close csr_get_contract_details;
653: --no need to check for null ...
654:
655: --contract category cannot be changed once created
656: if (l_contract_category <> p_segment3) AND (p_segment3 <> hr_api.g_varchar2) then --changed for Bug 7510498
657: hr_utility.set_message(800,'HR_375868_DONT_CHANGE_CATEGORY');
658: hr_utility.raise_error;
659: end if;
660:

Line 663: if (l_contract_type <> p_segment4) AND (p_segment4 <> hr_api.g_varchar2) THEN --changed for Bug 7510498

659: end if;
660:
661: --contract type change allowed only after reason and change date are provided
662: --p_contract_type cannot be null...no check if user is updating it from null to some contract type
663: if (l_contract_type <> p_segment4) AND (p_segment4 <> hr_api.g_varchar2) THEN --changed for Bug 7510498
664: if(l_contract_change_reason is null or (p_effective_date-1)<>nvl(l_contract_type_change_date,p_effective_date)) then
665: hr_utility.set_message(800,'HR_375867_DISALLOW_TYPE_CHANGE');
666: hr_utility.raise_error;
667: end if;

Line 672: if length(p_segment5)>30 AND (p_segment5 <> hr_api.g_varchar2) THEN --changed for Bug 7510498

668: end if;
669:
670:
671: --contract length to be within 30 characters
672: if length(p_segment5)>30 AND (p_segment5 <> hr_api.g_varchar2) THEN --changed for Bug 7510498
673: hr_utility.set_message(800,'HR_375863_CONTRACT_NUM_LENGTH');
674: hr_utility.set_message_token(l_token_name=>'TYPE',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_NUMBER'));
675: hr_utility.set_message_token(l_token_name=>'LENGTH',l_token_value=>'30');
676: hr_utility.raise_error;

Line 1035: IF (p_employment_category IS NULL OR p_employment_category <> hr_api.g_varchar2)

1031: CLOSE csr_get_payroll_emp_cat;
1032:
1033: if l_contract_category='NORMAL' then
1034: hr_utility.set_location(l_proc,20);
1035: IF (p_employment_category IS NULL OR p_employment_category <> hr_api.g_varchar2)
1036: then
1037: hr_api.mandatory_arg_error
1038: (p_api_name => l_proc,
1039: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_CATEGORY'),

Line 1037: hr_api.mandatory_arg_error

1033: if l_contract_category='NORMAL' then
1034: hr_utility.set_location(l_proc,20);
1035: IF (p_employment_category IS NULL OR p_employment_category <> hr_api.g_varchar2)
1036: then
1037: hr_api.mandatory_arg_error
1038: (p_api_name => l_proc,
1039: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_CATEGORY'),
1040: p_argument_value => p_employment_category
1041: );

Line 1043: hr_api.mandatory_arg_error

1039: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_CATEGORY'),
1040: p_argument_value => p_employment_category
1041: );
1042: else
1043: hr_api.mandatory_arg_error
1044: (p_api_name => l_proc,
1045: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_CATEGORY'),
1046: p_argument_value => l_employment_category
1047: );

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

1048: END if;
1049: end if;
1050:
1051:
1052: --if p_payroll_id is not null then Replace null with hr_api.g_number in 115.10
1053: --Bug 5386451
1054: if p_payroll_id <> hr_api.g_number then
1055: hr_utility.set_location(l_proc,30);
1056: open csr_oldage_taxoffice_check(l_person_id,p_effective_date);

Line 1054: if p_payroll_id <> hr_api.g_number then

1050:
1051:
1052: --if p_payroll_id is not null then Replace null with hr_api.g_number in 115.10
1053: --Bug 5386451
1054: if p_payroll_id <> hr_api.g_number then
1055: hr_utility.set_location(l_proc,30);
1056: open csr_oldage_taxoffice_check(l_person_id,p_effective_date);
1057: fetch csr_oldage_taxoffice_check into l_oldage_pension_rights,l_tax_office ;
1058: close csr_oldage_taxoffice_check;

Line 1234: if p_segment3 = hr_api.g_varchar2 then

1230:
1231: l_record_exists := '0';
1232: l_segment3 := p_segment3;
1233:
1234: if p_segment3 = hr_api.g_varchar2 then
1235: open csr_segment3;
1236: fetch csr_segment3 into l_segment3;
1237: close csr_segment3;
1238: end if;