DBA Data[Home] [Help]

APPS.HR_FORM_PROPERTIES_BSI dependencies on HR_UTILITY

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

57: l_proc varchar2(72) := g_package||'create_form_property';
58: l_form_property_id number;
59: l_object_version_number number;
60: begin
61: hr_utility.set_location('Entering:'|| l_proc, 10);
62: --
63: -- Issue a savepoint
64: --
65: savepoint create_form_property;

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

120: --
121: p_form_property_id := l_form_property_id;
122: p_object_version_number := l_object_version_number;
123: --
124: hr_utility.set_location(' Leaving:'||l_proc, 70);
125: exception
126: when hr_api.validate_enabled then
127: --
128: -- As the Validate_Enabled exception has been raised

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

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

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

140: --
141: -- A validation or unexpected error has occured
142: --
143: rollback to create_form_property;
144: hr_utility.set_location(' Leaving:'||l_proc, 90);
145: raise;
146: end create_form_property;
147: --
148: --

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

210:
211: l_form_property_id number;
212: l_proc varchar2(72) := g_package||'update_form_property';
213: begin
214: hr_utility.set_location('Entering:'|| l_proc, 10);
215: --
216: -- Issue a savepoint
217: --
218: savepoint update_form_property;

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

223: --
224: -- Validation in addition to Row Handlers
225: --
226:
227: hr_utility.set_location('At:'|| l_proc, 15);
228:
229: IF ( p_form_property_id is not null ) AND
230: (p_application_id is not null OR p_form_id is not null OR
231: p_form_template_id is not null) THEN

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

250: fnd_message.set_token('STEP','10');
251: fnd_message.raise_error;
252: END IF;
253:
254: hr_utility.set_location('At:'|| l_proc, 20);
255:
256: --
257: -- Process Logic
258: --

Line 268: hr_utility.set_location('At:'|| l_proc, 25);

264: FETCH cur_frm_prop_1 INTO l_form_property_id;
265: CLOSE cur_frm_prop_1;
266: END IF;
267:
268: hr_utility.set_location('At:'|| l_proc, 25);
269:
270: IF p_form_template_id is not null THEN
271: OPEN cur_frm_prop_2;
272: FETCH cur_frm_prop_2 INTO l_form_property_id;

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

272: FETCH cur_frm_prop_2 INTO l_form_property_id;
273: CLOSE cur_frm_prop_2;
274: END IF;
275:
276: hr_utility.set_location('At:'|| l_proc, 30);
277:
278: hr_fmp_upd.upd(p_form_property_id => l_form_property_id
279: ,p_object_version_number => p_object_version_number
280: ,p_help_target => p_help_target

Line 316: hr_utility.set_location('At:'|| l_proc, 35);

312:
313: --
314: -- When in validation only mode raise the Validate_Enabled exception
315: --
316: hr_utility.set_location('At:'|| l_proc, 35);
317:
318: if p_validate then
319: raise hr_api.validate_enabled;
320: end if;

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

318: if p_validate then
319: raise hr_api.validate_enabled;
320: end if;
321: --
322: hr_utility.set_location(' Leaving:'||l_proc, 70);
323: exception
324: when hr_api.validate_enabled then
325: --
326: -- As the Validate_Enabled exception has been raised

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

331: -- Only set output warning arguments
332: -- (Any key or derived arguments must be set to null
333: -- when validation only mode is being used.)
334: --
335: hr_utility.set_location(' Leaving:'||l_proc, 80);
336: when others then
337: --
338: -- A validation or unexpected error has occured
339: --

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

337: --
338: -- A validation or unexpected error has occured
339: --
340: rollback to update_form_property;
341: hr_utility.set_location(' Leaving:'||l_proc, 90);
342: raise;
343: end update_form_property;
344: --
345: -- ----------------------------------------------------------------------------

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

373:
374: l_form_property_id number;
375: l_proc varchar2(72) := g_package||'delete_form_property';
376: begin
377: hr_utility.set_location('Entering:'|| l_proc, 10);
378: --
379: -- Issue a savepoint
380: --
381: savepoint delete_form_property;

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

382: --
383: -- Validation in addition to Row Handlers
384: --
385:
386: hr_utility.set_location('At:'|| l_proc, 15);
387:
388: IF ( p_form_property_id is not null ) AND
389: (p_application_id is not null OR p_form_id is not null OR
390: p_form_template_id is not null) THEN

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

413: --
414: -- Process Logic
415: --
416:
417: hr_utility.set_location('At:'|| l_proc, 20);
418:
419: l_form_property_id := p_form_property_id;
420:
421: IF ( p_application_id is not null AND p_form_id is not null) THEN

Line 427: hr_utility.set_location('At:'|| l_proc, 25);

423: FETCH cur_frm_prop_1 INTO l_form_property_id;
424: CLOSE cur_frm_prop_1;
425: END IF;
426:
427: hr_utility.set_location('At:'|| l_proc, 25);
428:
429: IF p_form_template_id is not null THEN
430: OPEN cur_frm_prop_2;
431: FETCH cur_frm_prop_2 INTO l_form_property_id;

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

431: FETCH cur_frm_prop_2 INTO l_form_property_id;
432: CLOSE cur_frm_prop_2;
433: END IF;
434:
435: hr_utility.set_location('At:'|| l_proc, 30);
436:
437: hr_fmp_del.del(p_form_property_id => l_form_property_id
438: ,p_object_version_number => p_object_version_number);
439:

Line 443: hr_utility.set_location('At:'|| l_proc, 35);

439:
440: --
441: -- When in validation only mode raise the Validate_Enabled exception
442: --
443: hr_utility.set_location('At:'|| l_proc, 35);
444:
445: if p_validate then
446: raise hr_api.validate_enabled;
447: end if;

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

445: if p_validate then
446: raise hr_api.validate_enabled;
447: end if;
448: --
449: hr_utility.set_location(' Leaving:'||l_proc, 70);
450: exception
451: when hr_api.validate_enabled then
452: --
453: -- As the Validate_Enabled exception has been raised

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

458: -- Only set output warning arguments
459: -- (Any key or derived arguments must be set to null
460: -- when validation only mode is being used.)
461: --
462: hr_utility.set_location(' Leaving:'||l_proc, 80);
463: when others then
464: --
465: -- A validation or unexpected error has occured
466: --

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

464: --
465: -- A validation or unexpected error has occured
466: --
467: rollback to delete_form_property;
468: hr_utility.set_location(' Leaving:'||l_proc, 90);
469: raise;
470: end delete_form_property;
471: --
472: --

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

610: l_form_property_id number;
611: l_object_version_number number;
612: l_proc varchar2(72) := g_package||'copy_form_property';
613: begin
614: hr_utility.set_location('Entering:'|| l_proc, 10);
615: --
616: -- Issue a savepoint
617: --
618: savepoint copy_form_property;

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

622: -- p_effective_date := TRUNC(p_effective_date);
623: --
624: -- Validation in addition to Row Handlers
625: --
626: hr_utility.set_location('At:'|| l_proc, 15);
627:
628: OPEN cur_check;
629: FETCH cur_check INTO l_check;
630: IF cur_check%NOTFOUND THEN

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

638: CLOSE cur_check;
639: --
640: -- Process Logic
641: --
642: hr_utility.set_location('At:'|| l_proc, 20);
643:
644: OPEN cur_form_properties;
645: FETCH cur_form_properties INTO l_rec;
646: CLOSE cur_form_properties;

Line 648: hr_utility.set_location('At:'|| l_proc, 25);

644: OPEN cur_form_properties;
645: FETCH cur_form_properties INTO l_rec;
646: CLOSE cur_form_properties;
647:
648: hr_utility.set_location('At:'|| l_proc, 25);
649:
650: hr_fmp_ins.ins(p_form_template_id => p_form_template_id
651: ,p_help_target => l_rec.help_target
652: ,p_information_category => l_rec.information_category

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

685:
686: --
687: -- When in validation only mode raise the Validate_Enabled exception
688: --
689: hr_utility.set_location('At:'|| l_proc, 30);
690:
691: if p_validate then
692: raise hr_api.validate_enabled;
693: end if;

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

696: --
697: p_form_property_id := l_form_property_id;
698: p_object_version_number := l_object_version_number;
699: --
700: hr_utility.set_location(' Leaving:'||l_proc, 70);
701: exception
702: when hr_api.validate_enabled then
703: --
704: -- As the Validate_Enabled exception has been raised

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

710: -- (Any key or derived arguments must be set to null
711: -- when validation only mode is being used.)
712: --
713: p_form_property_id := null;
714: hr_utility.set_location(' Leaving:'||l_proc, 80);
715: when others then
716: --
717: -- A validation or unexpected error has occured
718: --

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

716: --
717: -- A validation or unexpected error has occured
718: --
719: rollback to copy_form_property;
720: hr_utility.set_location(' Leaving:'||l_proc, 90);
721: raise;
722: end copy_form_property;
723: --
724: --

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

865: l_object_version_number number;
866: l_proc varchar2(72) := g_package||'copy_form_property';
867: l_form_property_id number;
868: begin
869: hr_utility.set_location('Entering:'|| l_proc, 10);
870: --
871: -- Issue a savepoint
872: --
873: savepoint copy_form_property;

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

877: -- p_effective_date := TRUNC(p_effective_date);
878: --
879: -- Validation in addition to Row Handlers
880: --
881: hr_utility.set_location('At:'|| l_proc, 15);
882:
883: OPEN cur_check;
884: FETCH cur_check INTO l_application_id , l_form_id;
885: IF cur_check%NOTFOUND THEN

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

894:
895: --
896: -- Process Logic
897: --
898: hr_utility.set_location('At:'|| l_proc, 20);
899:
900: OPEN cur_form_properties;
901: FETCH cur_form_properties INTO l_rec;
902: CLOSE cur_form_properties;

Line 904: hr_utility.set_location('At:'|| l_proc, 25);

900: OPEN cur_form_properties;
901: FETCH cur_form_properties INTO l_rec;
902: CLOSE cur_form_properties;
903:
904: hr_utility.set_location('At:'|| l_proc, 25);
905:
906: hr_fmp_ins.ins(p_form_template_id => p_form_template_id_to
907: ,p_help_target => l_rec.help_target
908: ,p_information_category => l_rec.information_category

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

941:
942: --
943: -- When in validation only mode raise the Validate_Enabled exception
944: --
945: hr_utility.set_location('At:'|| l_proc, 30);
946:
947: if p_validate then
948: raise hr_api.validate_enabled;
949: end if;

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

952: --
953: p_form_property_id := l_form_property_id;
954: p_object_version_number := l_object_version_number;
955: --
956: hr_utility.set_location(' Leaving:'||l_proc, 70);
957: exception
958: when hr_api.validate_enabled then
959: --
960: -- As the Validate_Enabled exception has been raised

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

966: -- (Any key or derived arguments must be set to null
967: -- when validation only mode is being used.)
968: --
969: p_form_property_id := null;
970: hr_utility.set_location(' Leaving:'||l_proc, 80);
971: when others then
972: --
973: -- A validation or unexpected error has occured
974: --

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

972: --
973: -- A validation or unexpected error has occured
974: --
975: rollback to copy_form_property;
976: hr_utility.set_location(' Leaving:'||l_proc, 90);
977: raise;
978: end copy_form_property;
979: --
980: end hr_form_properties_bsi;