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_ASG_BUS3 dependencies on HR_MULTI_MESSAGE

Line 54: if hr_multi_message.no_exclusive_error

50: --
51: begin
52: hr_utility.set_location('Entering:'|| l_proc, 10);
53: --
54: if hr_multi_message.no_exclusive_error
55: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.CAGR_ID_FLEX_NUM'
56: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID'
57: ) then
58: --

Line 179: if hr_multi_message.no_exclusive_error

175: --
176: begin
177: hr_utility.set_location('Entering:'|| l_proc, 10);
178: --
179: if hr_multi_message.no_exclusive_error
180: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID'
181: ) then
182: --
183: -- Check mandatory parameters have been set

Line 233: hr_multi_message.add;

229: Close csr_in_fnd_id_flex;
230: hr_utility.set_location(l_proc, 60);
231: -- msg This grade structure does not exist
232: hr_utility.set_message(800, 'PER_52810_INVALID_STRUCTURE');
233: hr_multi_message.add;
234: Else
235: Close csr_in_fnd_id_flex;
236: --
237: -- If there is a collective_agreement_id it must be on per_cagr_grade_structures

Line 349: if hr_multi_message.no_exclusive_error

345: Close csr_in_per_contracts;
346: --
347: -- It has been found but is it for the same person ?
348: --
349: if hr_multi_message.no_exclusive_error
350: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
351: ) then
352: If l_person_id <> p_person_id THEN
353: -- msg This contract does not belong to this person

Line 361: hr_multi_message.add

357: elsif l_business_group_id <> p_business_group_id THEN
358: -- It has been found but is it in the same business group ?
359: -- msg This contract is not in the same business group as the assignment
360: hr_utility.set_message(800, 'PER_52814_CONTRACT_IN_BG');
361: hr_multi_message.add
362: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.CONTRACT_ID'
363: );
364: --
365: elsif l_effective_start_date > p_validation_start_date THEN

Line 465: hr_multi_message.add

461: --
462: Close csr_in_per_coll_agrs;
463: -- msg This collective agreement does not exist
464: hr_utility.set_message(800, 'PER_52816_COLLECTIVE_AGREEMENT');
465: hr_multi_message.add
466: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID'
467: );
468: Else
469: Close csr_in_per_coll_agrs;

Line 475: hr_multi_message.add

471: -- It must also be in the same business group
472: If l_business_group_id <> p_business_group_id THEN
473: -- msg This collective agreement is not in your business group
474: hr_utility.set_message(800, 'PER_52817_COLLECTIVE_NOT_IN_BG');
475: hr_multi_message.add
476: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID'
477: );
478: End If;
479: End if;

Line 487: hr_multi_message.add

483: hr_utility.set_location(l_proc, 60);
484: --
485: -- msg You must supply a establishment with a collective agreement if french.
486: hr_utility.set_message(800, 'PER_52827_NEED_ESTAB');
487: hr_multi_message.add
488: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID'
489: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID'
490: );
491: --

Line 496: if hr_multi_message.no_exclusive_error

492: elsif l_legislation_code = 'FR' and p_collective_agreement_id is not null THEN
493: -- If French, the given collective_agreement_id must be valid
494: hr_utility.set_location(l_proc, 70);
495: --
496: if hr_multi_message.no_exclusive_error
497: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID'
498: ) then
499: --
500: Open csr_in_establishment_ca_v;

Line 509: hr_multi_message.add

505: --
506: Close csr_in_establishment_ca_v;
507: -- msg French legislations must supply a collective agreement in your establishment
508: hr_utility.set_message(800, 'PER_52828_CAGR_NOT_IN_ESTAB');
509: hr_multi_message.add
510: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID'
511: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID'
512: );
513: Elsif l_business_group_id <> p_business_group_id THEN

Line 517: hr_multi_message.add

513: Elsif l_business_group_id <> p_business_group_id THEN
514: Close csr_in_establishment_ca_v;
515: -- msg This collective agreement is not in your business group
516: hr_utility.set_message(800, 'PER_52829_CAGR_NOT_IN_BG');
517: hr_multi_message.add
518: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID'
519: );
520: End If;
521: End If; -- no exclusive error

Line 625: hr_multi_message.add

621: -- The establishment_id must be there, so error
622: --
623: Close csr_estab_in_org_units;
624: hr_utility.set_message(800, 'PER_52818_INVALID_ESTAB');
625: hr_multi_message.add
626: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID'
627: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
628: );
629: Else

Line 654: hr_multi_message.add

650: -- The establishment_id must be there, so error
651: --
652: Close csr_estab_in_fr_estab_v;
653: hr_utility.set_message(800, 'PER_52818_INVALID_ESTAB');
654: hr_multi_message.add
655: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID'
656: );
657: Else
658: Close csr_estab_in_fr_estab_v;

Line 716: if hr_multi_message.exception_add

712: --
713: hr_utility.set_location(' Leaving:'|| l_proc, 40);
714: exception
715: when app_exception.application_exception then
716: if hr_multi_message.exception_add
717: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD'
718: ) then
719: hr_utility.set_location(' Leaving:'|| l_proc, 50);
720: raise;

Line 749: if hr_multi_message.no_exclusive_error

745: BEGIN
746:
747: hr_utility.set_location('Entering: '||l_proc,10);
748: --
749: if hr_multi_message.no_exclusive_error
750: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD'
751: ) then
752: --
753: -- Only proceed with validation if :

Line 767: hr_multi_message.add

763: IF (p_notice_period IS NOT NULL AND p_notice_period_uom IS NULL ) then
764:
765: hr_utility.set_location(l_proc, 30);
766: hr_utility.set_message(800, 'HR_289365_NOTICE_UOM_INV');
767: hr_multi_message.add
768: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD'
769: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD_UOM'
770: );
771: END IF;

Line 789: hr_multi_message.add

785: ,p_validation_end_date => p_validation_end_date) THEN
786:
787: hr_utility.set_location(l_proc, 50);
788: hr_utility.set_message(800, 'HR_289365_NOTICE_UOM_INV');
789: hr_multi_message.add
790: (p_associated_column1 =>
791: 'PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD_UOM'
792: );
793: END IF;

Line 858: if hr_multi_message.exception_add

854: hr_utility.set_location('Leaving: '||l_proc,100);
855: --
856: exception
857: when app_exception.application_exception then
858: if hr_multi_message.exception_add
859: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EMPLOYEE_CATEGORY'
860: ,p_associated_column2 =>
861: 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
862: ,p_associated_column3 =>

Line 1147: IF hr_multi_message.exception_add

1143: EXCEPTION
1144:
1145: WHEN app_exception.application_exception THEN
1146:
1147: IF hr_multi_message.exception_add
1148: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VENDOR_ID') THEN
1149:
1150: IF g_debug THEN
1151: hr_utility.set_location('Leaving: ' || l_proc, 998);

Line 1279: IF hr_multi_message.exception_add

1275: EXCEPTION
1276:
1277: WHEN app_exception.application_exception THEN
1278:
1279: IF hr_multi_message.exception_add
1280: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VENDOR_SITE_ID') THEN
1281:
1282: IF g_debug THEN
1283: hr_utility.set_location('Leaving: ' || l_proc, 998);

Line 1445: IF hr_multi_message.exception_add

1441: EXCEPTION
1442:
1443: WHEN app_exception.application_exception THEN
1444:
1445: IF hr_multi_message.exception_add
1446: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PO_HEADER_ID') THEN
1447:
1448: IF g_debug THEN
1449: hr_utility.set_location('Leaving: ' || l_proc, 998);

Line 1605: IF hr_multi_message.exception_add

1601: EXCEPTION
1602:
1603: WHEN app_exception.application_exception THEN
1604:
1605: IF hr_multi_message.exception_add
1606: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PO_LINE_ID') THEN
1607:
1608: IF g_debug THEN
1609: hr_utility.set_location('Leaving: '|| l_proc, 998);

Line 1716: IF hr_multi_message.exception_add

1712: EXCEPTION
1713:
1714: WHEN app_exception.application_exception THEN
1715:
1716: IF hr_multi_message.exception_add
1717: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROJECTED_ASSIGNMENT_END') THEN
1718:
1719: IF g_debug THEN
1720: hr_utility.set_location('Leaving: ' || l_proc, 998);

Line 1763: IF hr_multi_message.no_exclusive_error

1759: IF g_debug THEN
1760: hr_utility.set_location('Entering: ' || l_proc, 10);
1761: END IF;
1762:
1763: IF hr_multi_message.no_exclusive_error
1764: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.VENDOR_ID'
1765: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.VENDOR_SITE_ID'
1766: )
1767: THEN

Line 1881: IF hr_multi_message.no_exclusive_error

1877: IF g_debug THEN
1878: hr_utility.set_location('Entering: ' || l_proc, 10);
1879: END IF;
1880:
1881: IF hr_multi_message.no_exclusive_error
1882: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PO_HEADER_ID'
1883: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PO_LINE_ID'
1884: )
1885: THEN

Line 2001: IF hr_multi_message.no_exclusive_error

1997: IF g_debug THEN
1998: hr_utility.set_location('Entering: ' || l_proc, 10);
1999: END IF;
2000:
2001: IF hr_multi_message.no_exclusive_error
2002: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.VENDOR_ID'
2003: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.VENDOR_SITE_ID'
2004: ,p_check_column3 => 'PER_ALL_ASSIGNMENTS_F.PO_HEADER_ID'
2005: )

Line 2109: IF hr_multi_message.no_exclusive_error

2105: IF g_debug THEN
2106: hr_utility.set_location('Entering: ' || l_proc, 10);
2107: END IF;
2108:
2109: IF hr_multi_message.no_exclusive_error
2110: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
2111: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PO_LINE_ID'
2112: )
2113: THEN

Line 2246: IF hr_multi_message.exception_add

2242: EXCEPTION
2243: --
2244: WHEN app_exception.application_exception THEN
2245: --
2246: IF hr_multi_message.exception_add
2247: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VENDOR_ASSIGNMENT_NUMBER') THEN
2248: --
2249: hr_utility.set_location(' Leaving:'|| l_proc, 998);
2250: --

Line 2326: IF hr_multi_message.exception_add

2322: EXCEPTION
2323: --
2324: WHEN app_exception.application_exception THEN
2325: --
2326: IF hr_multi_message.exception_add
2327: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VENDOR_EMPLOYEE_NUMBER') THEN
2328: --
2329: hr_utility.set_location(' Leaving:'|| l_proc, 998);
2330: --

Line 2392: if hr_multi_message.exception_add

2388:
2389: hr_utility.set_location('Leaving: '||l_proc,100);
2390: exception
2391: when app_exception.application_exception then
2392: if hr_multi_message.exception_add
2393: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.WORK_AT_HOME'
2394: ) then
2395: hr_utility.set_location(' Leaving:'|| l_proc, 110);
2396: raise;

Line 2523: if hr_multi_message.exception_add

2519: END IF;
2520: hr_utility.set_location('Leaving: '||l_proc,100);
2521: exception
2522: when app_exception.application_exception then
2523: if hr_multi_message.exception_add
2524: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_LADDER_PGM_ID'
2525: ) then
2526: hr_utility.set_location(' Leaving:'|| l_proc, 110);
2527: raise;