DBA Data[Home] [Help]

APPS.HR_WINDOW_PROPERTIES_BSI dependencies on HR_UTILITY

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

61: l_proc varchar2(72) := g_package||'create_window_property';
62: l_language_code fnd_languages.language_code%TYPE;
63:
64: begin
65: hr_utility.set_location('Entering:'|| l_proc, 10);
66: --
67: -- Issue a savepoint
68: --
69: savepoint create_window_property;

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

77: --
78: l_language_code := p_language_code;
79: hr_api.validate_language_code(p_language_code => l_language_code);
80: --
81: hr_utility.set_location(l_proc, 20);
82: --
83: --
84: -- Process Logic
85: --

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

121: ,p_information29 => p_information29
122: ,p_information30 => p_information30
123: ,p_window_property_id => l_window_property_id);
124:
125: hr_utility.set_location('At:'|| l_proc, 15);
126:
127: hr_wpt_ins.ins_tl(
128: p_language_code => l_language_code
129: ,p_window_property_id => l_window_property_id

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

139: -- Set all output arguments
140: --
141: p_window_property_id := l_window_property_id;
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 70);
144: exception
145: when hr_api.validate_enabled then
146: --
147: -- As the Validate_Enabled exception has been raised

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

153: -- (Any key or derived arguments must be set to null
154: -- when validation only mode is being used.)
155: --
156: p_window_property_id := null;
157: hr_utility.set_location(' Leaving:'||l_proc, 80);
158: when others then
159: --
160: -- A validation or unexpected error has occured
161: --

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

159: --
160: -- A validation or unexpected error has occured
161: --
162: rollback to create_window_property;
163: hr_utility.set_location(' Leaving:'||l_proc, 90);
164: raise;
165: end create_window_property;
166: --
167: --

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

232: l_proc varchar2(72) := g_package||'update_window_property';
233: l_language_code fnd_languages.language_code%TYPE;
234:
235: begin
236: hr_utility.set_location('Entering:'|| l_proc, 10);
237: --
238: -- Issue a savepoint
239: --
240: savepoint update_window_property;

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

249: --
250: l_language_code := p_language_code;
251: hr_api.validate_language_code(p_language_code => l_language_code);
252: --
253: hr_utility.set_location(l_proc, 20);
254: --
255: --
256: -- Validation in addition to Row Handlers
257: --

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

254: --
255: --
256: -- Validation in addition to Row Handlers
257: --
258: hr_utility.set_location('At:'|| l_proc, 15);
259:
260: IF ( p_window_property_id is not null) AND
261: (p_form_window_id is not null OR p_template_window_id is not null) THEN
262: -- error message

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

281: END IF;
282: --
283: -- Process Logic
284: --
285: hr_utility.set_location('At:'|| l_proc, 20);
286:
287: l_window_property_id := p_window_property_id;
288:
289: IF p_form_window_id is not null THEN

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

291: FETCH cur_win_prop_1 INTO l_window_property_id;
292: CLOSE cur_win_prop_1;
293: END IF;
294:
295: hr_utility.set_location('At:'|| l_proc, 25);
296:
297: IF p_template_window_id is not null THEN
298: OPEN cur_win_prop_2;
299: FETCH cur_win_prop_2 INTO l_window_property_id;

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

299: FETCH cur_win_prop_2 INTO l_window_property_id;
300: CLOSE cur_win_prop_2;
301: END IF;
302:
303: hr_utility.set_location('At:'|| l_proc, 30);
304:
305: hr_wnp_upd.upd(p_window_property_id => l_window_property_id
306: ,p_height => p_height
307: ,p_width => p_width

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

338: ,p_information28 => p_information28
339: ,p_information29 => p_information29
340: ,p_information30 => p_information30);
341:
342: hr_utility.set_location('At:'|| l_proc, 35);
343:
344: hr_wpt_upd.upd_tl(
345: p_language_code => l_language_code
346: ,p_window_property_id => l_window_property_id

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

345: p_language_code => l_language_code
346: ,p_window_property_id => l_window_property_id
347: ,p_title => p_title);
348:
349: hr_utility.set_location('At:'|| l_proc, 40);
350:
351: --
352: -- When in validation only mode raise the Validate_Enabled exception
353: --

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

354: if p_validate then
355: raise hr_api.validate_enabled;
356: end if;
357: --
358: hr_utility.set_location(' Leaving:'||l_proc, 70);
359: exception
360: when hr_api.validate_enabled then
361: --
362: -- As the Validate_Enabled exception has been raised

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

367: -- Only set output warning arguments
368: -- (Any key or derived arguments must be set to null
369: -- when validation only mode is being used.)
370: --
371: hr_utility.set_location(' Leaving:'||l_proc, 80);
372: when others then
373: --
374: -- A validation or unexpected error has occured
375: --

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

373: --
374: -- A validation or unexpected error has occured
375: --
376: rollback to update_window_property;
377: hr_utility.set_location(' Leaving:'||l_proc, 90);
378: raise;
379: end update_window_property;
380: --
381: -- ----------------------------------------------------------------------------

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

405:
406: l_window_property_id number;
407: l_proc varchar2(72) := g_package||'delete_window_property';
408: begin
409: hr_utility.set_location('Entering:'|| l_proc, 10);
410: --
411: -- Issue a savepoint
412: --
413: savepoint delete_window_property;

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

413: savepoint delete_window_property;
414: --
415: -- Validation in addition to Row Handlers
416: --
417: hr_utility.set_location('At:'|| l_proc, 15);
418:
419: IF ( p_window_property_id is not null) AND
420: (p_form_window_id is not null OR p_template_window_id is not null) THEN
421: -- error message

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

440: END IF;
441: --
442: -- Process Logic
443: --
444: hr_utility.set_location('At:'|| l_proc, 20);
445:
446: l_window_property_id := p_window_property_id;
447:
448: IF p_form_window_id is not null THEN

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

450: FETCH cur_win_prop_1 INTO l_window_property_id;
451: CLOSE cur_win_prop_1;
452: END IF;
453:
454: hr_utility.set_location('At:'|| l_proc, 25);
455:
456: IF p_template_window_id is not null THEN
457: OPEN cur_win_prop_2;
458: FETCH cur_win_prop_2 INTO l_window_property_id;

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

458: FETCH cur_win_prop_2 INTO l_window_property_id;
459: CLOSE cur_win_prop_2;
460: END IF;
461:
462: hr_utility.set_location('At:'|| l_proc, 30);
463:
464: hr_wnp_shd.lck( p_window_property_id => l_window_property_id );
465:
466: hr_utility.set_location('At:'|| l_proc, 35);

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

462: hr_utility.set_location('At:'|| l_proc, 30);
463:
464: hr_wnp_shd.lck( p_window_property_id => l_window_property_id );
465:
466: hr_utility.set_location('At:'|| l_proc, 35);
467:
468: hr_wpt_del.del_tl( p_window_property_id => l_window_property_id);
469:
470: hr_utility.set_location('At:'|| l_proc, 40);

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

466: hr_utility.set_location('At:'|| l_proc, 35);
467:
468: hr_wpt_del.del_tl( p_window_property_id => l_window_property_id);
469:
470: hr_utility.set_location('At:'|| l_proc, 40);
471:
472: hr_wnp_del.del(p_window_property_id => l_window_property_id);
473:
474: hr_utility.set_location('At:'|| l_proc, 45);

Line 474: hr_utility.set_location('At:'|| l_proc, 45);

470: hr_utility.set_location('At:'|| l_proc, 40);
471:
472: hr_wnp_del.del(p_window_property_id => l_window_property_id);
473:
474: hr_utility.set_location('At:'|| l_proc, 45);
475:
476: --
477: -- When in validation only mode raise the Validate_Enabled exception
478: --

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

479: if p_validate then
480: raise hr_api.validate_enabled;
481: end if;
482: --
483: hr_utility.set_location(' Leaving:'||l_proc, 70);
484: exception
485: when hr_api.validate_enabled then
486: --
487: -- As the Validate_Enabled exception has been raised

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

492: -- Only set output warning arguments
493: -- (Any key or derived arguments must be set to null
494: -- when validation only mode is being used.)
495: --
496: hr_utility.set_location(' Leaving:'||l_proc, 80);
497: when others then
498: --
499: -- A validation or unexpected error has occured
500: --

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

498: --
499: -- A validation or unexpected error has occured
500: --
501: rollback to delete_window_property;
502: hr_utility.set_location(' Leaving:'||l_proc, 90);
503: raise;
504: end delete_window_property;
505: --
506: --

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

661: l_proc varchar2(72) := g_package||'copy_window_property';
662: l_language_code fnd_languages.language_code%TYPE;
663:
664: begin
665: hr_utility.set_location('Entering:'|| l_proc, 10);
666: --
667: -- Issue a savepoint
668: --
669: savepoint copy_window_property;

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

675: --
676: l_language_code := p_language_code;
677: hr_api.validate_language_code(p_language_code => l_language_code);
678: --
679: hr_utility.set_location(l_proc, 20);
680: --
681: --
682: -- Validation in addition to Row Handlers
683: --

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

680: --
681: --
682: -- Validation in addition to Row Handlers
683: --
684: hr_utility.set_location('At:'|| l_proc, 15);
685:
686: OPEN cur_check;
687: FETCH cur_check INTO l_check;
688: IF cur_check%NOTFOUND THEN

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

694: fnd_message.raise_error;
695: END IF;
696: CLOSE cur_check;
697:
698: hr_utility.set_location('At:'|| l_proc, 20);
699:
700: --
701: -- Process Logic
702: --

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

703: OPEN cur_win_prop;
704: FETCH cur_win_prop INTO l_rec;
705: CLOSE cur_win_prop;
706:
707: hr_utility.set_location('At:'|| l_proc, 25);
708:
709: hr_wnp_ins.ins(p_template_window_id => p_template_window_id
710: ,p_height => l_rec.height
711: ,p_width => l_rec.width

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

743: ,p_information29 => l_rec.information29
744: ,p_information30 => l_rec.information30
745: ,p_window_property_id => l_window_property_id);
746:
747: hr_utility.set_location('At:'|| l_proc, 30);
748:
749: IF p_title <> hr_api.g_varchar2 THEN
750: hr_utility.set_location('At:'|| l_proc, 35);
751:

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

746:
747: hr_utility.set_location('At:'|| l_proc, 30);
748:
749: IF p_title <> hr_api.g_varchar2 THEN
750: hr_utility.set_location('At:'|| l_proc, 35);
751:
752: hr_wpt_ins.ins_tl(
753: p_language_code => l_language_code
754: ,p_window_property_id => l_window_property_id

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

753: p_language_code => l_language_code
754: ,p_window_property_id => l_window_property_id
755: ,p_title => p_title);
756: ELSE
757: hr_utility.set_location('At:'|| l_proc, 40);
758:
759: FOR cur_rec IN cur_win_tl LOOP
760: IF cur_win_tl%ROWCOUNT = 1 THEN
761: hr_utility.set_location('At:'|| l_proc, 45);

Line 761: hr_utility.set_location('At:'|| l_proc, 45);

757: hr_utility.set_location('At:'|| l_proc, 40);
758:
759: FOR cur_rec IN cur_win_tl LOOP
760: IF cur_win_tl%ROWCOUNT = 1 THEN
761: hr_utility.set_location('At:'|| l_proc, 45);
762:
763: hr_wpt_ins.ins_tl(
764: p_language_code => cur_rec.source_lang
765: ,p_window_property_id => l_window_property_id

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

764: p_language_code => cur_rec.source_lang
765: ,p_window_property_id => l_window_property_id
766: ,p_title => cur_rec.title);
767: ELSE
768: hr_utility.set_location('At:'|| l_proc, 50);
769:
770: hr_wpt_upd.upd_tl(
771: p_language_code => cur_rec.source_lang
772: ,p_window_property_id => l_window_property_id

Line 778: hr_utility.set_location('At:'|| l_proc, 55);

774: END IF;
775: END LOOP;
776: END IF;
777:
778: hr_utility.set_location('At:'|| l_proc, 55);
779:
780: --
781: -- When in validation only mode raise the Validate_Enabled exception
782: --

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

787: -- Set all output arguments
788: --
789: p_window_property_id := l_window_property_id;
790: --
791: hr_utility.set_location(' Leaving:'||l_proc, 70);
792: exception
793: when hr_api.validate_enabled then
794: --
795: -- As the Validate_Enabled exception has been raised

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

801: -- (Any key or derived arguments must be set to null
802: -- when validation only mode is being used.)
803: --
804: p_window_property_id := null;
805: hr_utility.set_location(' Leaving:'||l_proc, 80);
806: when others then
807: --
808: -- A validation or unexpected error has occured
809: --

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

807: --
808: -- A validation or unexpected error has occured
809: --
810: rollback to copy_window_property;
811: hr_utility.set_location(' Leaving:'||l_proc, 90);
812: raise;
813: end copy_window_property;
814: --
815: --

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

974: l_proc varchar2(72) := g_package||'copy_window_property';
975: l_language_code fnd_languages.language_code%TYPE;
976:
977: begin
978: hr_utility.set_location('Entering:'|| l_proc, 10);
979: --
980: -- Issue a savepoint
981: --
982: savepoint copy_window_property;

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

988: --
989: l_language_code := p_language_code;
990: hr_api.validate_language_code(p_language_code => l_language_code);
991: --
992: hr_utility.set_location(l_proc, 20);
993: --
994: --
995: -- Validation in addition to Row Handlers
996: --

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

993: --
994: --
995: -- Validation in addition to Row Handlers
996: --
997: hr_utility.set_location('At:'|| l_proc, 15);
998:
999: OPEN cur_check;
1000: FETCH cur_check INTO l_form_window_id;
1001: IF cur_check%NOTFOUND THEN

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

1010:
1011: --
1012: -- Process Logic
1013: --
1014: hr_utility.set_location('At:'|| l_proc, 20);
1015:
1016: OPEN cur_win_prop;
1017: FETCH cur_win_prop INTO l_rec;
1018: CLOSE cur_win_prop;

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

1016: OPEN cur_win_prop;
1017: FETCH cur_win_prop INTO l_rec;
1018: CLOSE cur_win_prop;
1019:
1020: hr_utility.set_location('At:'|| l_proc, 25);
1021:
1022: hr_wnp_ins.ins(p_template_window_id => p_template_window_id_to
1023: ,p_height => l_rec.height
1024: ,p_width => l_rec.width

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

1056: ,p_information29 => l_rec.information29
1057: ,p_information30 => l_rec.information30
1058: ,p_window_property_id => l_window_property_id);
1059:
1060: hr_utility.set_location('At:'|| l_proc, 30);
1061:
1062: IF p_title <> hr_api.g_varchar2 THEN
1063: hr_utility.set_location('At:'|| l_proc, 35);
1064:

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

1059:
1060: hr_utility.set_location('At:'|| l_proc, 30);
1061:
1062: IF p_title <> hr_api.g_varchar2 THEN
1063: hr_utility.set_location('At:'|| l_proc, 35);
1064:
1065: hr_wpt_ins.ins_tl(
1066: p_language_code => l_language_code
1067: ,p_window_property_id => l_window_property_id

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

1066: p_language_code => l_language_code
1067: ,p_window_property_id => l_window_property_id
1068: ,p_title => p_title);
1069: ELSE
1070: hr_utility.set_location('At:'|| l_proc, 40);
1071:
1072: FOR cur_rec IN cur_win_tl LOOP
1073: IF cur_win_tl%ROWCOUNT = 1 THEN
1074: hr_utility.set_location('At:'|| l_proc, 45);

Line 1074: hr_utility.set_location('At:'|| l_proc, 45);

1070: hr_utility.set_location('At:'|| l_proc, 40);
1071:
1072: FOR cur_rec IN cur_win_tl LOOP
1073: IF cur_win_tl%ROWCOUNT = 1 THEN
1074: hr_utility.set_location('At:'|| l_proc, 45);
1075:
1076: hr_wpt_ins.ins_tl(
1077: p_language_code => cur_rec.source_lang
1078: ,p_window_property_id => l_window_property_id

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

1077: p_language_code => cur_rec.source_lang
1078: ,p_window_property_id => l_window_property_id
1079: ,p_title => cur_rec.title);
1080: ELSE
1081: hr_utility.set_location('At:'|| l_proc, 50);
1082:
1083: hr_wpt_upd.upd_tl(
1084: p_language_code => cur_rec.source_lang
1085: ,p_window_property_id => l_window_property_id

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

1098: -- Set all output arguments
1099: --
1100: p_window_property_id := l_window_property_id;
1101: --
1102: hr_utility.set_location(' Leaving:'||l_proc, 70);
1103: exception
1104: when hr_api.validate_enabled then
1105: --
1106: -- As the Validate_Enabled exception has been raised

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

1112: -- (Any key or derived arguments must be set to null
1113: -- when validation only mode is being used.)
1114: --
1115: p_window_property_id := null;
1116: hr_utility.set_location(' Leaving:'||l_proc, 80);
1117: when others then
1118: --
1119: -- A validation or unexpected error has occured
1120: --

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

1118: --
1119: -- A validation or unexpected error has occured
1120: --
1121: rollback to copy_window_property;
1122: hr_utility.set_location(' Leaving:'||l_proc, 90);
1123: raise;
1124: end copy_window_property;
1125: --
1126: end hr_window_properties_bsi;