DBA Data[Home] [Help]

APPS.HR_CANVAS_PROPERTIES_BSI dependencies on HR_UTILITY

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

60: l_canvas_property_id number;
61: l_object_version_number number;
62: l_proc varchar2(72) := g_package||'create_canvas_property';
63: begin
64: hr_utility.set_location('Entering:'|| l_proc, 10);
65: --
66: -- Issue a savepoint
67: --
68: savepoint create_canvas_property;

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

124: --
125: p_canvas_property_id := l_canvas_property_id;
126: p_object_version_number := l_object_version_number;
127: --
128: hr_utility.set_location(' Leaving:'||l_proc, 70);
129: exception
130: when hr_api.validate_enabled then
131: --
132: -- As the Validate_Enabled exception has been raised

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

138: -- (Any key or derived arguments must be set to null
139: -- when validation only mode is being used.)
140: --
141: p_canvas_property_id := null;
142: hr_utility.set_location(' Leaving:'||l_proc, 80);
143: when others then
144: --
145: -- A validation or unexpected error has occured
146: --

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

144: --
145: -- A validation or unexpected error has occured
146: --
147: rollback to create_canvas_property;
148: hr_utility.set_location(' Leaving:'||l_proc, 90);
149: raise;
150: end create_canvas_property;
151: --
152: --

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

216:
217: l_canvas_property_id number;
218: l_proc varchar2(72) := g_package||'update_canvas_property';
219: begin
220: hr_utility.set_location('Entering:'|| l_proc, 10);
221: --
222: -- Issue a savepoint
223: --
224: savepoint update_canvas_property;

Line 228: hr_utility.set_location('At:'|| l_proc, 15);

224: savepoint update_canvas_property;
225: --
226: -- Validation in addition to Row Handlers
227: --
228: hr_utility.set_location('At:'|| l_proc, 15);
229:
230: IF ( p_canvas_property_id is not null) THEN
231: IF ( p_form_canvas_id is not null OR p_template_canvas_id is not null) THEN
232: -- error message

Line 260: hr_utility.set_location('At:'|| l_proc, 20);

256: --
257: -- Process Logic
258: --
259:
260: hr_utility.set_location('At:'|| l_proc, 20);
261:
262: l_canvas_property_id := p_canvas_property_id;
263:
264: IF p_form_canvas_id is not null THEN

Line 270: hr_utility.set_location('At:'|| l_proc, 30);

266: FETCH cur_can_prop_1 INTO l_canvas_property_id;
267: CLOSE cur_can_prop_1;
268: END IF;
269:
270: hr_utility.set_location('At:'|| l_proc, 30);
271:
272: IF p_template_canvas_id is not null THEN
273: OPEN cur_can_prop_2;
274: FETCH cur_can_prop_2 INTO l_canvas_property_id;

Line 278: hr_utility.set_location('At:'|| l_proc, 40);

274: FETCH cur_can_prop_2 INTO l_canvas_property_id;
275: CLOSE cur_can_prop_2;
276: END IF;
277:
278: hr_utility.set_location('At:'|| l_proc, 40);
279:
280: hr_cnp_upd.upd(p_effective_date => TRUNC(p_effective_date)
281: ,p_canvas_property_id => l_canvas_property_id
282: ,p_object_version_number => p_object_version_number

Line 323: hr_utility.set_location('At:'|| l_proc, 50);

319: --
320: --
321: -- When in validation only mode raise the Validate_Enabled exception
322: --
323: hr_utility.set_location('At:'|| l_proc, 50);
324:
325: if p_validate then
326: raise hr_api.validate_enabled;
327: end if;

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

325: if p_validate then
326: raise hr_api.validate_enabled;
327: end if;
328: --
329: hr_utility.set_location(' Leaving:'||l_proc, 70);
330: exception
331: when hr_api.validate_enabled then
332: --
333: -- As the Validate_Enabled exception has been raised

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

338: -- Only set output warning arguments
339: -- (Any key or derived arguments must be set to null
340: -- when validation only mode is being used.)
341: --
342: hr_utility.set_location(' Leaving:'||l_proc, 80);
343: when others then
344: --
345: -- A validation or unexpected error has occured
346: --

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

344: --
345: -- A validation or unexpected error has occured
346: --
347: rollback to update_canvas_property;
348: hr_utility.set_location(' Leaving:'||l_proc, 90);
349: raise;
350: end update_canvas_property;
351: --
352: --

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

378:
379: l_proc varchar2(72) := g_package||'delete_canvas_property';
380: l_canvas_property_id number;
381: begin
382: hr_utility.set_location('Entering:'|| l_proc, 10);
383: --
384: -- Issue a savepoint
385: --
386: savepoint delete_canvas_property;

Line 391: hr_utility.set_location('At:'|| l_proc, 15);

387:
388: --
389: -- Validation in addition to Row Handlers
390: --
391: hr_utility.set_location('At:'|| l_proc, 15);
392:
393: IF ( p_canvas_property_id is not null) THEN
394: IF (p_form_canvas_id is not null OR p_template_canvas_id is not null) THEN
395: -- error message

Line 423: hr_utility.set_location('At:'|| l_proc, 20);

419: --
420: -- Process Logic
421: --
422:
423: hr_utility.set_location('At:'|| l_proc, 20);
424:
425: l_canvas_property_id := p_canvas_property_id;
426:
427: IF p_form_canvas_id is not null THEN

Line 433: hr_utility.set_location('At:'|| l_proc, 30);

429: FETCH cur_can_prop_1 INTO l_canvas_property_id;
430: CLOSE cur_can_prop_1;
431: END IF;
432:
433: hr_utility.set_location('At:'|| l_proc, 30);
434:
435: IF p_template_canvas_id is not null THEN
436: OPEN cur_can_prop_2;
437: FETCH cur_can_prop_2 INTO l_canvas_property_id;

Line 441: hr_utility.set_location('At:'|| l_proc, 40);

437: FETCH cur_can_prop_2 INTO l_canvas_property_id;
438: CLOSE cur_can_prop_2;
439: END IF;
440:
441: hr_utility.set_location('At:'|| l_proc, 40);
442:
443: if l_canvas_property_id is not null then --Added if condition for Bug 4072087
444: hr_cnp_del.del( p_canvas_property_id => l_canvas_property_id
445: ,p_object_version_number => p_object_version_number );

Line 450: hr_utility.set_location('At:'|| l_proc, 50);

446: end if;
447: --
448: -- When in validation only mode raise the Validate_Enabled exception
449: --
450: hr_utility.set_location('At:'|| l_proc, 50);
451:
452: if p_validate then
453: raise hr_api.validate_enabled;
454: end if;

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

452: if p_validate then
453: raise hr_api.validate_enabled;
454: end if;
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 70);
457: exception
458: when hr_api.validate_enabled then
459: --
460: -- As the Validate_Enabled exception has been raised

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

465: -- Only set output warning arguments
466: -- (Any key or derived arguments must be set to null
467: -- when validation only mode is being used.)
468: --
469: hr_utility.set_location(' Leaving:'||l_proc, 80);
470: when others then
471: --
472: -- A validation or unexpected error has occured
473: --

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

471: --
472: -- A validation or unexpected error has occured
473: --
474: rollback to delete_canvas_property;
475: hr_utility.set_location(' Leaving:'||l_proc, 90);
476: raise;
477: end delete_canvas_property;
478: --
479: --

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

624: l_canvas_property_id number;
625: l_object_version_number number;
626: l_proc varchar2(72) := g_package||'copy_canvas_property';
627: begin
628: hr_utility.set_location('Entering:'|| l_proc, 10);
629: --
630: -- Issue a savepoint
631: --
632: savepoint copy_canvas_property;

Line 651: hr_utility.set_location('At:'|| l_proc, 20);

647:
648: --
649: -- Process Logic
650: --
651: hr_utility.set_location('At:'|| l_proc, 20);
652:
653: OPEN cur_can_prop;
654: FETCH cur_can_prop INTO l_rec;
655: CLOSE cur_can_prop;

Line 657: hr_utility.set_location('At:'|| l_proc, 30);

653: OPEN cur_can_prop;
654: FETCH cur_can_prop INTO l_rec;
655: CLOSE cur_can_prop;
656:
657: hr_utility.set_location('At:'|| l_proc, 30);
658:
659: hr_cnp_ins.ins(p_effective_date => p_effective_date
660: ,p_template_canvas_id => p_template_canvas_id
661: ,p_height => l_rec.height

Line 702: hr_utility.set_location('At:'|| l_proc, 40);

698: ,p_object_version_number => l_object_version_number);
699: --
700: -- When in validation only mode raise the Validate_Enabled exception
701: --
702: hr_utility.set_location('At:'|| l_proc, 40);
703:
704: if p_validate then
705: raise hr_api.validate_enabled;
706: end if;

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

709: --
710: p_canvas_property_id := l_canvas_property_id;
711: p_object_version_number := l_object_version_number;
712: --
713: hr_utility.set_location(' Leaving:'||l_proc, 70);
714: exception
715: when hr_api.validate_enabled then
716: --
717: -- As the Validate_Enabled exception has been raised

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

723: -- (Any key or derived arguments must be set to null
724: -- when validation only mode is being used.)
725: --
726: p_canvas_property_id := null;
727: hr_utility.set_location(' Leaving:'||l_proc, 80);
728: when others then
729: --
730: -- A validation or unexpected error has occured
731: --

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

729: --
730: -- A validation or unexpected error has occured
731: --
732: rollback to copy_canvas_property;
733: hr_utility.set_location(' Leaving:'||l_proc, 90);
734: raise;
735: end copy_canvas_property;
736: --
737: --

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

885: l_canvas_property_id number;
886: l_object_version_number number;
887: l_proc varchar2(72) := g_package||'copy_canvas_property';
888: begin
889: hr_utility.set_location('Entering:'|| l_proc, 10);
890: --
891: -- Issue a savepoint
892: --
893: savepoint copy_canvas_property;

Line 913: hr_utility.set_location('At:'|| l_proc, 20);

909:
910: --
911: -- Process Logic
912: --
913: hr_utility.set_location('At:'|| l_proc, 20);
914:
915: OPEN cur_can_prop;
916: FETCH cur_can_prop INTO l_rec;
917: CLOSE cur_can_prop;

Line 919: hr_utility.set_location('At:'|| l_proc, 30);

915: OPEN cur_can_prop;
916: FETCH cur_can_prop INTO l_rec;
917: CLOSE cur_can_prop;
918:
919: hr_utility.set_location('At:'|| l_proc, 30);
920:
921: hr_cnp_ins.ins(p_effective_date => p_effective_date
922: ,p_template_canvas_id => p_template_canvas_id_to
923: ,p_height => l_rec.height

Line 964: hr_utility.set_location('At:'|| l_proc, 50);

960: ,p_object_version_number => l_object_version_number );
961: --
962: -- When in validation only mode raise the Validate_Enabled exception
963: --
964: hr_utility.set_location('At:'|| l_proc, 50);
965:
966: if p_validate then
967: raise hr_api.validate_enabled;
968: end if;

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

971: --
972: p_canvas_property_id := l_canvas_property_id;
973: p_object_version_number := l_object_Version_number;
974: --
975: hr_utility.set_location(' Leaving:'||l_proc, 70);
976: exception
977: when hr_api.validate_enabled then
978: --
979: -- As the Validate_Enabled exception has been raised

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

985: -- (Any key or derived arguments must be set to null
986: -- when validation only mode is being used.)
987: --
988: p_canvas_property_id := null;
989: hr_utility.set_location(' Leaving:'||l_proc, 80);
990: when others then
991: --
992: -- A validation or unexpected error has occured
993: --

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

991: --
992: -- A validation or unexpected error has occured
993: --
994: rollback to copy_canvas_property;
995: hr_utility.set_location(' Leaving:'||l_proc, 90);
996: raise;
997: end copy_canvas_property;
998: --
999: end hr_canvas_properties_bsi;