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.PAY_PL_SII_API dependencies on HR_UTILITY

Line 91: hr_utility.set_location('Entering:'|| l_proc, 10);

87: and past.per_system_status in (l_active_assign,l_susp_assign);
88:
89: begin
90:
91: hr_utility.set_location('Entering:'|| l_proc, 10);
92: --
93:
94: l_emp := 'EMP';
95: l_emp_apl := 'EMP_APL';

Line 277: hr_utility.set_location(' Leaving:'||l_proc, 70);

273: p_effective_start_date := l_effective_start_date;
274: p_effective_end_date := l_effective_end_date;
275:
276: --
277: hr_utility.set_location(' Leaving:'||l_proc, 70);
278: exception
279: when hr_api.validate_enabled then
280: --
281: -- As the Validate_Enabled exception has been raised

Line 296: hr_utility.set_location(' Leaving:'||l_proc, 80);

292: p_effective_start_date := NULL;
293: p_effective_end_date := NULL;
294: p_effective_date_warning := NULL;
295:
296: hr_utility.set_location(' Leaving:'||l_proc, 80);
297: when others then
298: --
299: -- A validation or unexpected error has occured
300: --

Line 311: hr_utility.set_location(' Leaving:'||l_proc, 90);

307: p_object_version_number := NULL;
308: p_effective_start_date := NULL;
309: p_effective_end_date := NULL;
310: p_effective_date_warning := NULL;
311: hr_utility.set_location(' Leaving:'||l_proc, 90);
312: raise;
313: end create_pl_sii_details;
314: --
315: --

Line 364: hr_utility.set_location('Entering:'|| l_proc, 10);

360: and paf.effective_end_date
361: and bus.business_group_id = paf.business_group_id;
362:
363: begin
364: hr_utility.set_location('Entering:'|| l_proc, 10);
365:
366: l_effective_date := trunc(p_effective_date);
367: l_contract_category := 'CIVIL';
368:

Line 376: hr_utility.set_message(801,'PAY_375857_PL_INVALID_ASG');

372: if csr_get_derived_details%NOTFOUND then
373: --
374: close csr_get_derived_details;
375: --
376: hr_utility.set_message(801,'PAY_375857_PL_INVALID_ASG');
377: hr_utility.set_message_token('ENTITY',hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT'));
378: hr_utility.raise_error;
379: end if;
380: --

Line 377: hr_utility.set_message_token('ENTITY',hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT'));

373: --
374: close csr_get_derived_details;
375: --
376: hr_utility.set_message(801,'PAY_375857_PL_INVALID_ASG');
377: hr_utility.set_message_token('ENTITY',hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT'));
378: hr_utility.raise_error;
379: end if;
380: --
381: close csr_get_derived_details;

Line 378: hr_utility.raise_error;

374: close csr_get_derived_details;
375: --
376: hr_utility.set_message(801,'PAY_375857_PL_INVALID_ASG');
377: hr_utility.set_message_token('ENTITY',hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT'));
378: hr_utility.raise_error;
379: end if;
380: --
381: close csr_get_derived_details;
382:

Line 465: hr_utility.set_location('Entering:'|| l_proc, 10);

461: and paf.effective_end_date
462: and bus.business_group_id = paf.business_group_id;
463:
464: begin
465: hr_utility.set_location('Entering:'|| l_proc, 10);
466:
467: l_effective_date := trunc(p_effective_date);
468: l_contract_category := 'LUMP';
469:

Line 477: hr_utility.set_message(801,'PAY_375857_PL_INVALID_ASG');

473: if csr_get_derived_details%NOTFOUND then
474: --
475: close csr_get_derived_details;
476: --
477: hr_utility.set_message(801,'PAY_375857_PL_INVALID_ASG');
478: hr_utility.set_message_token('ENTITY',hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT'));
479: hr_utility.raise_error;
480: end if;
481: --

Line 478: hr_utility.set_message_token('ENTITY',hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT'));

474: --
475: close csr_get_derived_details;
476: --
477: hr_utility.set_message(801,'PAY_375857_PL_INVALID_ASG');
478: hr_utility.set_message_token('ENTITY',hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT'));
479: hr_utility.raise_error;
480: end if;
481: --
482: close csr_get_derived_details;

Line 479: hr_utility.raise_error;

475: close csr_get_derived_details;
476: --
477: hr_utility.set_message(801,'PAY_375857_PL_INVALID_ASG');
478: hr_utility.set_message_token('ENTITY',hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT'));
479: hr_utility.raise_error;
480: end if;
481: --
482: close csr_get_derived_details;
483:

Line 566: hr_utility.set_location('Entering:'|| l_proc, 10);

562: and paf.effective_end_date
563: and bus.business_group_id = paf.business_group_id;
564:
565: begin
566: hr_utility.set_location('Entering:'|| l_proc, 10);
567:
568: l_effective_date := trunc(p_effective_date);
569: l_contract_category := 'F_LUMP';
570:

Line 578: hr_utility.set_message(801,'PAY_375857_PL_INVALID_ASG');

574: if csr_get_derived_details%NOTFOUND then
575: --
576: close csr_get_derived_details;
577: --
578: hr_utility.set_message(801,'PAY_375857_PL_INVALID_ASG');
579: hr_utility.set_message_token('ENTITY',hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT'));
580: hr_utility.raise_error;
581: end if;
582: --

Line 579: hr_utility.set_message_token('ENTITY',hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT'));

575: --
576: close csr_get_derived_details;
577: --
578: hr_utility.set_message(801,'PAY_375857_PL_INVALID_ASG');
579: hr_utility.set_message_token('ENTITY',hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT'));
580: hr_utility.raise_error;
581: end if;
582: --
583: close csr_get_derived_details;

Line 580: hr_utility.raise_error;

576: close csr_get_derived_details;
577: --
578: hr_utility.set_message(801,'PAY_375857_PL_INVALID_ASG');
579: hr_utility.set_message_token('ENTITY',hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT'));
580: hr_utility.raise_error;
581: end if;
582: --
583: close csr_get_derived_details;
584:

Line 668: hr_utility.set_location('Entering:'|| l_proc, 10);

664: and papf.effective_end_date
665: and bus.business_group_id = papf.business_group_id;
666:
667: begin
668: hr_utility.set_location('Entering:'|| l_proc, 10);
669:
670: l_effective_date := trunc(p_effective_date);
671: l_contract_category := 'NORMAL';
672:

Line 680: hr_utility.set_message(801,'PAY_375857_PL_INVALID_ASG');

676: if csr_get_derived_details%NOTFOUND then
677: --
678: close csr_get_derived_details;
679: --
680: hr_utility.set_message(801,'PAY_375857_PL_INVALID_ASG');
681: hr_utility.set_message_token('ENTITY',hr_general.decode_lookup('PL_FORM_LABELS','PERSON'));
682: hr_utility.raise_error;
683: end if;
684: --

Line 681: hr_utility.set_message_token('ENTITY',hr_general.decode_lookup('PL_FORM_LABELS','PERSON'));

677: --
678: close csr_get_derived_details;
679: --
680: hr_utility.set_message(801,'PAY_375857_PL_INVALID_ASG');
681: hr_utility.set_message_token('ENTITY',hr_general.decode_lookup('PL_FORM_LABELS','PERSON'));
682: hr_utility.raise_error;
683: end if;
684: --
685: close csr_get_derived_details;

Line 682: hr_utility.raise_error;

678: close csr_get_derived_details;
679: --
680: hr_utility.set_message(801,'PAY_375857_PL_INVALID_ASG');
681: hr_utility.set_message_token('ENTITY',hr_general.decode_lookup('PL_FORM_LABELS','PERSON'));
682: hr_utility.raise_error;
683: end if;
684: --
685: close csr_get_derived_details;
686:

Line 807: hr_utility.set_location('Entering:'|| l_proc, 10);

803: -- This join ensures that the Contract types are for the same assignment
804: and paf2.assignment_id = paf1.assignment_id;
805:
806: begin
807: hr_utility.set_location('Entering:'|| l_proc, 10);
808:
809: l_norm_term := 'TERM_NORMAL';
810: l_norm_active := 'NORMAL';
811: l_assg_type1 := 'ACTIVE_ASSIGN';

Line 836: hr_utility.set_message(801,'PAY_375859_INVALID_TERM_MODE');

832: fetch csr_term_catg into l_exists;
833: if csr_term_catg%FOUND and p_datetrack_update_mode <> 'CORRECTION' then
834: -- Raise an error message as the record can only be Corrected for a Normal Terminated
835: -- Assignment
836: hr_utility.set_message(801,'PAY_375859_INVALID_TERM_MODE');
837: hr_utility.raise_error;
838: end if;
839: close csr_term_catg;
840:

Line 837: hr_utility.raise_error;

833: if csr_term_catg%FOUND and p_datetrack_update_mode <> 'CORRECTION' then
834: -- Raise an error message as the record can only be Corrected for a Normal Terminated
835: -- Assignment
836: hr_utility.set_message(801,'PAY_375859_INVALID_TERM_MODE');
837: hr_utility.raise_error;
838: end if;
839: close csr_term_catg;
840:
841: open csr_term_catg(l_norm_active);

Line 860: hr_utility.set_message(801,'PAY_375860_INVALID_NORMAL_MODE');

856:
857: if l_flag = 'Y' then
858: -- If this flag is Yes then an UPDATE is being done on a date when the Contract type has not
859: -- changed. So we raise an error message
860: hr_utility.set_message(801,'PAY_375860_INVALID_NORMAL_MODE');
861: hr_utility.raise_error;
862: end if;
863:
864: end if;

Line 861: hr_utility.raise_error;

857: if l_flag = 'Y' then
858: -- If this flag is Yes then an UPDATE is being done on a date when the Contract type has not
859: -- changed. So we raise an error message
860: hr_utility.set_message(801,'PAY_375860_INVALID_NORMAL_MODE');
861: hr_utility.raise_error;
862: end if;
863:
864: end if;
865:

Line 979: hr_utility.set_location(' Leaving:'||l_proc, 70);

975: p_effective_start_date := l_effective_start_date;
976: p_effective_end_date := l_effective_end_date;
977:
978: --
979: hr_utility.set_location(' Leaving:'||l_proc, 70);
980: exception
981: when hr_api.validate_enabled then
982: --
983: -- As the Validate_Enabled exception has been raised

Line 996: hr_utility.set_location(' Leaving:'||l_proc, 80);

992: p_object_version_number := l_in_out_parameter1;
993: p_effective_start_date := NULL;
994: p_effective_end_date := NULL;
995:
996: hr_utility.set_location(' Leaving:'||l_proc, 80);
997: when others then
998: --
999: -- A validation or unexpected error has occured
1000: --

Line 1009: hr_utility.set_location(' Leaving:'||l_proc, 90);

1005: --
1006: p_object_version_number := l_in_out_parameter1;
1007: p_effective_start_date := NULL;
1008: p_effective_end_date := NULL;
1009: hr_utility.set_location(' Leaving:'||l_proc, 90);
1010: raise;
1011: end update_pl_sii_details;
1012: --
1013: -- ----------------------------------------------------------------------------

Line 1044: hr_utility.set_location('Entering:'|| l_proc, 10);

1040: l_in_out_parameter1 number;
1041:
1042: begin
1043:
1044: hr_utility.set_location('Entering:'|| l_proc, 10);
1045: --
1046: -- Issue a savepoint
1047: --
1048: savepoint delete_pl_sii_details;

Line 1131: hr_utility.set_location(' Leaving:'||l_proc, 70);

1127: p_effective_end_date := l_effective_end_date;
1128:
1129:
1130: --
1131: hr_utility.set_location(' Leaving:'||l_proc, 70);
1132: exception
1133: when hr_api.validate_enabled then
1134: --
1135: -- As the Validate_Enabled exception has been raised

Line 1148: hr_utility.set_location(' Leaving:'||l_proc, 80);

1144: p_object_version_number := l_in_out_parameter1;
1145: p_effective_start_date := NULL;
1146: p_effective_end_date := NULL;
1147:
1148: hr_utility.set_location(' Leaving:'||l_proc, 80);
1149: when others then
1150: --
1151: -- A validation or unexpected error has occured
1152: --

Line 1161: hr_utility.set_location(' Leaving:'||l_proc, 90);

1157: --
1158: p_object_version_number := l_in_out_parameter1;
1159: p_effective_start_date := NULL;
1160: p_effective_end_date := NULL;
1161: hr_utility.set_location(' Leaving:'||l_proc, 90);
1162: raise;
1163: end delete_pl_sii_details;
1164: --
1165: end pay_pl_sii_api;