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

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

67: AND business_group_id = p_business_group_id; --Bug fix:3648527
68: --
69: BEGIN
70: --
71: hr_utility.set_location('Entering : '||l_proc, 10);
72: --
73: l_effective_date := TRUNC(p_effective_Date);
74: l_start_of_year := p_start_of_year;
75: l_end_of_year := p_end_of_year;

Line 79: hr_utility.set_location(l_proc,20);

75: l_end_of_year := p_end_of_year;
76: --
77: WHILE l_end_of_year <= p_ten_year_date LOOP
78: --
79: hr_utility.set_location(l_proc,20);
80: --
81: OPEN csr_get_plan_years;
82: FETCH csr_get_plan_years INTO l_pln_yr_start_date,l_pln_yr_end_date;
83: --

Line 88: hr_utility.set_location(l_proc,30);

84: IF csr_get_plan_years%NOTFOUND THEN
85: --
86: CLOSE csr_get_plan_years;
87: --
88: hr_utility.set_location(l_proc,30);
89: --
90: BEN_pgm_or_pl_yr_perd_API.create_pgm_or_pl_yr_perd
91: (p_validate => FALSE
92: ,p_yr_perd_id => l_yr_perd_id

Line 113: hr_utility.set_location('Leaving :'|| l_proc, 999);

109: l_end_of_year := ADD_MONTHS(l_end_of_year,12);
110: --
111: END LOOP;
112: --
113: hr_utility.set_location('Leaving :'|| l_proc, 999);
114: --
115: END check_plan_years;
116: --
117: -- ----------------------------------------------------------------------------

Line 178: hr_utility.set_location(l_proc, 40);

174: ORDER BY start_date ASC;
175: --
176: BEGIN
177: --
178: hr_utility.set_location(l_proc, 40);
179: --
180: l_order_number := 10;
181: --
182: l_effective_date := TRUNC(p_effective_date);

Line 197: hr_utility.set_location(l_proc||'/'||l_start_of_year,50);

193: ,p_start_of_year => l_start_of_year
194: ,p_end_of_year => l_end_of_year
195: ,p_ten_year_date => l_ten_year_date);
196: --
197: hr_utility.set_location(l_proc||'/'||l_start_of_year,50);
198: hr_utility.set_location(l_proc||'/'||l_end_of_year,51);
199: hr_utility.set_location(l_proc||'/'||l_ten_year_date,52);
200: --
201: -- Loop round all the plan years for the next 100 years

Line 198: hr_utility.set_location(l_proc||'/'||l_end_of_year,51);

194: ,p_end_of_year => l_end_of_year
195: ,p_ten_year_date => l_ten_year_date);
196: --
197: hr_utility.set_location(l_proc||'/'||l_start_of_year,50);
198: hr_utility.set_location(l_proc||'/'||l_end_of_year,51);
199: hr_utility.set_location(l_proc||'/'||l_ten_year_date,52);
200: --
201: -- Loop round all the plan years for the next 100 years
202: --

Line 199: hr_utility.set_location(l_proc||'/'||l_ten_year_date,52);

195: ,p_ten_year_date => l_ten_year_date);
196: --
197: hr_utility.set_location(l_proc||'/'||l_start_of_year,50);
198: hr_utility.set_location(l_proc||'/'||l_end_of_year,51);
199: hr_utility.set_location(l_proc||'/'||l_ten_year_date,52);
200: --
201: -- Loop round all the plan years for the next 100 years
202: --
203: FOR csr_rec IN csr_get_plan_years LOOP

Line 205: hr_utility.set_location(l_proc||'/'||csr_rec.yr_perd_id, 60);

201: -- Loop round all the plan years for the next 100 years
202: --
203: FOR csr_rec IN csr_get_plan_years LOOP
204: --
205: hr_utility.set_location(l_proc||'/'||csr_rec.yr_perd_id, 60);
206: hr_utility.set_location(l_proc||'/'||csr_rec.start_date,61);
207: hr_utility.set_location(l_proc||'/'||csr_rec.end_date,62);
208: --
209: -- If the plan year start and end dates match

Line 206: hr_utility.set_location(l_proc||'/'||csr_rec.start_date,61);

202: --
203: FOR csr_rec IN csr_get_plan_years LOOP
204: --
205: hr_utility.set_location(l_proc||'/'||csr_rec.yr_perd_id, 60);
206: hr_utility.set_location(l_proc||'/'||csr_rec.start_date,61);
207: hr_utility.set_location(l_proc||'/'||csr_rec.end_date,62);
208: --
209: -- If the plan year start and end dates match
210: -- the beginning and end of the year then attach them

Line 207: hr_utility.set_location(l_proc||'/'||csr_rec.end_date,62);

203: FOR csr_rec IN csr_get_plan_years LOOP
204: --
205: hr_utility.set_location(l_proc||'/'||csr_rec.yr_perd_id, 60);
206: hr_utility.set_location(l_proc||'/'||csr_rec.start_date,61);
207: hr_utility.set_location(l_proc||'/'||csr_rec.end_date,62);
208: --
209: -- If the plan year start and end dates match
210: -- the beginning and end of the year then attach them
211: -- to the plan.

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

325: AND effective_end_date;
326: --
327: BEGIN
328: --
329: hr_utility.set_location('Entering:'|| l_proc, 10);
330: --
331: -- Issue a savepoint if operating in validation only mode
332: --
333: savepoint create_collective_agreement;

Line 335: hr_utility.set_location(l_proc, 20);

331: -- Issue a savepoint if operating in validation only mode
332: --
333: savepoint create_collective_agreement;
334: --
335: hr_utility.set_location(l_proc, 20);
336: --
337: --Truncate Date Parameters
338: --
339: l_effective_date := TRUNC(p_effective_date);

Line 422: hr_utility.set_location(l_proc, 30);

418: -- Create a Plan for the Collective Agreement.
419: --
420: BEGIN
421: --
422: hr_utility.set_location(l_proc, 30);
423: --
424: OPEN csr_get_plan_type;
425: FETCH csr_get_plan_type INTO l_pl_typ_id;
426: --

Line 455: hr_utility.set_message(800,'HR_289379_CAGR_PLAN_TYPE_INV');

451: ,p_object_version_number => l_pl_typ_ovn
452: ,p_effective_date => TO_DATE('01-01-1951','DD-MM-YYYY'));
453: --
454: /*
455: hr_utility.set_message(800,'HR_289379_CAGR_PLAN_TYPE_INV');
456: hr_utility.raise_error; */
457: --
458: -- If a plan type already exists then just close the cursor
459: --

Line 456: hr_utility.raise_error; */

452: ,p_effective_date => TO_DATE('01-01-1951','DD-MM-YYYY'));
453: --
454: /*
455: hr_utility.set_message(800,'HR_289379_CAGR_PLAN_TYPE_INV');
456: hr_utility.raise_error; */
457: --
458: -- If a plan type already exists then just close the cursor
459: --
460: ELSE

Line 464: hr_utility.set_location(l_proc, 35);

460: ELSE
461: --
462: CLOSE csr_get_plan_type;
463: --
464: hr_utility.set_location(l_proc, 35);
465: --
466: END IF;
467: --
468: -- Create a Plan for the Collective Agreement

Line 483: hr_utility.set_location(l_proc||'/'||l_pl_id, 40);

479: ,p_pl_typ_id => l_pl_typ_id
480: ,p_pl_cd => 'MYNTBPGM' -- May not be in a program,
481: ,p_pl_stat_cd => 'A'); -- Active);
482: --
483: hr_utility.set_location(l_proc||'/'||l_pl_id, 40);
484: --
485: -- Once the plan has been created we need to attach the plan
486: -- years to the plan. This procedure will firstly check that
487: -- there are plan years available for the next 10 years. If

Line 635: hr_utility.set_location(l_proc, 60);

631: -- End of API User Hook for the after hook of create_collective_agreement
632: --
633: end;
634: --
635: hr_utility.set_location(l_proc, 60);
636: --
637: -- When in validation only mode raise the Validate_Enabled exception
638: --
639: if p_validate then

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

644: --
645: p_collective_agreement_id := l_collective_agreement_id;
646: p_object_version_number := l_object_version_number;
647: --
648: hr_utility.set_location(' Leaving:'||l_proc, 70);
649: --
650: exception
651: --
652: when hr_api.validate_enabled then

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

661: -- when validation only mode is being used.)
662: --
663: p_collective_agreement_id := null;
664: p_object_version_number := null;
665: hr_utility.set_location(' Leaving:'||l_proc, 80);
666: --
667: when others then
668: --
669: -- A validation or unexpected error has occured

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

748: l_temp_ovn number;
749: --
750: begin
751: --
752: hr_utility.set_location('Entering:'|| l_proc, 10);
753: --
754: -- Issue a savepoint if operating in validation only mode
755: --
756: savepoint update_collective_agreement;

Line 758: hr_utility.set_location(l_proc, 20);

754: -- Issue a savepoint if operating in validation only mode
755: --
756: savepoint update_collective_agreement;
757: --
758: hr_utility.set_location(l_proc, 20);
759: --
760: -- Process Logic
761: --
762: l_object_version_number := p_object_version_number;

Line 981: hr_utility.set_location(l_proc, 60);

977: -- End of API User Hook for the after hook of update_collective_agreement
978: --
979: end;
980: --
981: hr_utility.set_location(l_proc, 60);
982: --
983: -- When in validation only mode raise the Validate_Enabled exception
984: --
985: if p_validate then

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

989: -- Set all output arguments
990: --
991: p_object_version_number := l_object_version_number;
992: --
993: hr_utility.set_location(' Leaving:'||l_proc, 70);
994: --
995: exception
996: --
997: when hr_api.validate_enabled then

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

1004: -- Only set output warning arguments
1005: -- (Any key or derived arguments must be set to null
1006: -- when validation only mode is being used.)
1007: --
1008: hr_utility.set_location(' Leaving:'||l_proc, 80);
1009: --
1010: when others then
1011: --
1012: -- A validation or unexpected error has occured

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

1060: WHERE pop.pl_id = l_pl_id;
1061: --
1062: begin
1063: --
1064: hr_utility.set_location('Entering:'|| l_proc, 10);
1065: --
1066: -- Issue a savepoint if operating in validation only mode
1067: --
1068: savepoint delete_collective_agreement;

Line 1070: hr_utility.set_location(l_proc, 20);

1066: -- Issue a savepoint if operating in validation only mode
1067: --
1068: savepoint delete_collective_agreement;
1069: --
1070: hr_utility.set_location(l_proc, 20);
1071: --
1072: -- Process Logic
1073: --
1074: l_object_version_number := p_object_version_number;

Line 1096: hr_utility.set_location(l_proc, 30);

1092: -- End of API User Hook for the before hook of delete_collective_agreement
1093: --
1094: end;
1095: --
1096: hr_utility.set_location(l_proc, 30);
1097: --
1098: -- Check that no entitlements exist before trying to
1099: -- delete the collective agreement.
1100: -- This check has been added in order to display a

Line 1113: hr_utility.set_message(800, 'HR_289398_ENTITLEMENTS_EXIST');

1109: IF csr_chk_for_entitlements%FOUND THEN
1110: --
1111: CLOSE csr_chk_for_entitlements;
1112: --
1113: hr_utility.set_message(800, 'HR_289398_ENTITLEMENTS_EXIST');
1114: hr_utility.raise_error;
1115: --
1116: ELSE
1117: --

Line 1114: hr_utility.raise_error;

1110: --
1111: CLOSE csr_chk_for_entitlements;
1112: --
1113: hr_utility.set_message(800, 'HR_289398_ENTITLEMENTS_EXIST');
1114: hr_utility.raise_error;
1115: --
1116: ELSE
1117: --
1118: CLOSE csr_chk_for_entitlements;

Line 1134: hr_utility.set_location(l_proc, 40);

1130: -- the link between plan years
1131: --
1132: IF csr_pln%FOUND THEN
1133: --
1134: hr_utility.set_location(l_proc, 40);
1135: savepoint validate_popl_yr; -- Bug # 5405435
1136: --
1137: -- Loop Through all the plan years associated
1138: -- to the the plan and delete them

Line 1142: hr_utility.set_location(l_proc||'/'||c1.popl_yr_perd_id, 50);

1138: -- to the the plan and delete them
1139: --
1140: FOR c1 IN csr_popl_yr LOOP
1141: --
1142: hr_utility.set_location(l_proc||'/'||c1.popl_yr_perd_id, 50);
1143: --
1144: l_popl_ovn := c1.object_version_number;
1145: --
1146: -- Delete plan years link

Line 1204: hr_utility.set_location(l_proc, 60);

1200: -- End of API User Hook for the after hook of delete_collective_agreement
1201: --
1202: end;
1203: --
1204: hr_utility.set_location(l_proc, 60);
1205: --
1206: -- When in validation only mode raise the Validate_Enabled exception
1207: --
1208: if p_validate then

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

1208: if p_validate then
1209: raise hr_api.validate_enabled;
1210: end if;
1211: --
1212: hr_utility.set_location(' Leaving:'||l_proc, 70);
1213: --
1214: exception
1215: --
1216: when hr_api.validate_enabled then

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

1254: l_proc varchar2(72) := g_package||'lck';
1255: --
1256: begin
1257: --
1258: hr_utility.set_location('Entering:'|| l_proc, 10);
1259: --
1260: per_cag_shd.lck
1261: (
1262: p_collective_agreement_id => p_collective_agreement_id

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

1262: p_collective_agreement_id => p_collective_agreement_id
1263: ,p_object_version_number => p_object_version_number
1264: );
1265: --
1266: hr_utility.set_location(' Leaving:'||l_proc, 70);
1267: --
1268: end lck;
1269: --
1270: end hr_collective_agreement_api;