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_ITEM_PROPERTIES_BSI dependencies on HR_UTILITY

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

247: l_object_version_number number;
248: l_override_value_warning boolean;
249: l_proc varchar2(72) := g_package||'create_item_property';
250: begin
251: hr_utility.set_location('Entering:'|| l_proc, 10);
252: --
253: -- Issue a savepoint
254: --
255: savepoint create_item_property;

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

264: --
265: l_language_code := p_language_code;
266: hr_api.validate_language_code(p_language_code => l_language_code);
267: --
268: hr_utility.set_location(l_proc, 20);
269: --
270: --
271: -- Process Logic
272: --

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

393: p_item_property_id := l_item_property_id;
394: p_object_version_number := l_object_version_number;
395: --p_override_value_warning := l_override_value_warning;
396: --
397: hr_utility.set_location(' Leaving:'||l_proc, 70);
398: exception
399: when hr_api.validate_enabled then
400: --
401: -- As the Validate_Enabled exception has been raised

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

408: -- when validation only mode is being used.)
409: --
410: p_item_property_id := null;
411: --p_override_value_warning := null;
412: hr_utility.set_location(' Leaving:'||l_proc, 80);
413: when others then
414: --
415: -- A validation or unexpected error has occured
416: --

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

414: --
415: -- A validation or unexpected error has occured
416: --
417: rollback to create_item_property;
418: hr_utility.set_location(' Leaving:'||l_proc, 90);
419: raise;
420: end create_item_property;
421: --
422: --

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

532: l_item_property_id number;
533: l_proc varchar2(72) := g_package||'update_item_property';
534: l_override_value_warning boolean;
535: begin
536: hr_utility.set_location('Entering:'|| l_proc, 10);
537: --
538: -- Issue a savepoint
539: --
540: savepoint update_item_property;

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

549: --
550: l_language_code := p_language_code;
551: hr_api.validate_language_code(p_language_code => l_language_code);
552: --
553: hr_utility.set_location(l_proc, 20);
554: --
555: --
556: -- Validation in addition to Row Handlers
557: --

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

554: --
555: --
556: -- Validation in addition to Row Handlers
557: --
558: hr_utility.set_location('At:'|| l_proc, 15);
559:
560: IF ( p_item_property_id is not null ) AND
561: (p_template_item_context_id is not null OR p_form_item_id is not null OR
562: p_template_item_id is not null) THEN

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

595:
596: --
597: -- Process Logic
598: --
599: hr_utility.set_location('At:'|| l_proc, 20);
600:
601: l_item_property_id := p_item_property_id;
602:
603: IF p_form_item_id is not null THEN

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

615: FETCH cur_item_prop_3 INTO l_item_property_id;
616: CLOSE cur_item_prop_3;
617: END IF;
618:
619: hr_utility.set_location('At:'|| l_proc, 25);
620:
621: hr_itp_upd.upd(p_effective_date => TRUNC(p_effective_date)
622: ,p_item_property_id => l_item_property_id
623: ,p_object_version_number => p_object_version_number

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

687: ,p_next_navigation_item_id => p_next_navigation_item_id
688: ,p_previous_navigation_item_id => p_previous_navigation_item_id);
689: -- ,p_override_value_warning => l_override_value_warning);
690:
691: hr_utility.set_location('At:'|| l_proc, 30);
692:
693: hr_ipt_upd.upd_tl(p_language_code => l_language_code
694: ,p_item_property_id => l_item_property_id
695: ,p_default_value => p_default_value

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

731: );
732: --
733: -- When in validation only mode raise the Validate_Enabled exception
734: --
735: hr_utility.set_location('At:'|| l_proc, 35);
736:
737: if p_validate then
738: raise hr_api.validate_enabled;
739: end if;

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

741: -- Set all output arguments
742: --
743: --p_override_value_warning := l_override_value_warning;
744: --
745: hr_utility.set_location(' Leaving:'||l_proc, 70);
746: exception
747: when hr_api.validate_enabled then
748: --
749: -- As the Validate_Enabled exception has been raised

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

755: -- (Any key or derived arguments must be set to null
756: -- when validation only mode is being used.)
757: --
758: --p_override_value_warning := null;
759: hr_utility.set_location(' Leaving:'||l_proc, 80);
760: when others then
761: --
762: -- A validation or unexpected error has occured
763: --

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

761: --
762: -- A validation or unexpected error has occured
763: --
764: rollback to update_item_property;
765: hr_utility.set_location(' Leaving:'||l_proc, 90);
766: raise;
767: end update_item_property;
768: --
769: --

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

803:
804: l_item_property_id number;
805: l_proc varchar2(72) := g_package||'delete_item_property';
806: begin
807: hr_utility.set_location('Entering:'|| l_proc, 10);
808: --
809: -- Issue a savepoint
810: --
811: savepoint delete_item_property;

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

812: --
813: -- Validation in addition to Row Handlers
814: --
815:
816: hr_utility.set_location('At:'|| l_proc, 15);
817:
818: IF ( p_item_property_id is not null ) AND
819: (p_template_item_context_id is not null OR p_form_item_id is not null OR
820: p_template_item_id is not null) THEN

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

853:
854: --
855: -- Process Logic
856: --
857: hr_utility.set_location('At:'|| l_proc, 20);
858:
859: l_item_property_id := p_item_property_id;
860:
861: IF p_form_item_id is not null THEN

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

863: FETCH cur_item_prop_1 INTO l_item_property_id;
864: CLOSE cur_item_prop_1;
865: END IF;
866:
867: hr_utility.set_location('At:'|| l_proc, 25);
868:
869: IF p_template_item_id is not null THEN
870: OPEN cur_item_prop_2;
871: FETCH cur_item_prop_2 INTO l_item_property_id;

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

871: FETCH cur_item_prop_2 INTO l_item_property_id;
872: CLOSE cur_item_prop_2;
873: END IF;
874:
875: hr_utility.set_location('At:'|| l_proc, 30);
876:
877: IF p_template_item_context_id is not null THEN
878: OPEN cur_item_prop_3;
879: FETCH cur_item_prop_3 INTO l_item_property_id;

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

879: FETCH cur_item_prop_3 INTO l_item_property_id;
880: CLOSE cur_item_prop_3;
881: END IF;
882:
883: hr_utility.set_location('At:'|| l_proc, 35);
884: -- Bug 4018745 Starts Here
885: -- Desc: Added if condition to avoid the below calls if item_property_id is null.
886: if l_item_property_id is not null then
887: hr_itp_shd.lck( p_item_property_id => l_item_property_id

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

886: if l_item_property_id is not null then
887: hr_itp_shd.lck( p_item_property_id => l_item_property_id
888: , p_object_version_number => p_object_version_number);
889:
890: hr_utility.set_location('At:'|| l_proc, 40);
891:
892: hr_ipt_del.del_tl( p_item_property_id => l_item_property_id);
893:
894: hr_utility.set_location('At:'|| l_proc, 45);

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

890: hr_utility.set_location('At:'|| l_proc, 40);
891:
892: hr_ipt_del.del_tl( p_item_property_id => l_item_property_id);
893:
894: hr_utility.set_location('At:'|| l_proc, 45);
895:
896: hr_itp_del.del( p_item_property_id => l_item_property_id
897: , p_object_version_number => p_object_version_number);
898:

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

898:
899: --
900: -- When in validation only mode raise the Validate_Enabled exception
901: --
902: hr_utility.set_location('At:'|| l_proc, 50);
903: end if;
904: -- Bug 4018745 Ends Here
905: if p_validate then
906: raise hr_api.validate_enabled;

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

905: if p_validate then
906: raise hr_api.validate_enabled;
907: end if;
908: --
909: hr_utility.set_location(' Leaving:'||l_proc, 70);
910: exception
911: when hr_api.validate_enabled then
912: --
913: -- As the Validate_Enabled exception has been raised

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

918: -- Only set output warning arguments
919: -- (Any key or derived arguments must be set to null
920: -- when validation only mode is being used.)
921: --
922: hr_utility.set_location(' Leaving:'||l_proc, 80);
923: when others then
924: --
925: -- A validation or unexpected error has occured
926: --

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

924: --
925: -- A validation or unexpected error has occured
926: --
927: rollback to delete_item_property;
928: hr_utility.set_location(' Leaving:'||l_proc, 90);
929: raise;
930: end delete_item_property;
931: --
932: -- ----------------------------------------------------------------------------

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

1196: l_object_version_number number;
1197: l_override_value_warning boolean;
1198: l_proc varchar2(72) := g_package||'copy_item_property';
1199: begin
1200: hr_utility.set_location('Entering:'|| l_proc, 10);
1201: --
1202: -- Issue a savepoint
1203: --
1204: savepoint copy_item_property;

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

1213: --
1214: l_language_code := p_language_code;
1215: hr_api.validate_language_code(p_language_code => l_language_code);
1216: --
1217: hr_utility.set_location(l_proc, 20);
1218: --
1219: --
1220: -- Validation in addition to Row Handlers
1221: --

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

1218: --
1219: --
1220: -- Validation in addition to Row Handlers
1221: --
1222: hr_utility.set_location('At:'|| l_proc, 15);
1223:
1224: OPEN cur_check;
1225: FETCH cur_check INTO l_check;
1226: IF cur_check%NOTFOUND THEN

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

1234: CLOSE cur_check;
1235: --
1236: -- Process Logic
1237: --
1238: hr_utility.set_location('At:'|| l_proc, 20);
1239:
1240: OPEN cur_item_prop;
1241: FETCH cur_item_prop INTO l_rec;
1242: CLOSE cur_item_prop;

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

1240: OPEN cur_item_prop;
1241: FETCH cur_item_prop INTO l_rec;
1242: CLOSE cur_item_prop;
1243:
1244: hr_utility.set_location('At:'|| l_proc, 25);
1245:
1246: hr_itp_ins.ins(p_effective_date => TRUNC(p_effective_date)
1247: ,p_template_item_id => p_template_item_id
1248: ,p_alignment => l_rec.alignment

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

1313: ,p_item_property_id => l_item_property_id
1314: ,p_object_version_number => l_object_version_number);
1315: --,p_override_value_warning => l_override_value_warning);
1316:
1317: hr_utility.set_location('At:'|| l_proc, 30);
1318:
1319: IF ( p_default_value <> hr_api.g_varchar2)
1320: AND ( p_information_prompt <> hr_api.g_varchar2)
1321: AND ( p_label <> hr_api.g_varchar2 )

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

1321: AND ( p_label <> hr_api.g_varchar2 )
1322: AND ( p_prompt_text <> hr_api.g_varchar2 )
1323: AND ( p_tooltip_text <> hr_api.g_varchar2 ) THEN
1324:
1325: hr_utility.set_location('At:'|| l_proc, 35);
1326:
1327: hr_ipt_ins.ins_tl(p_language_code => l_language_code
1328: ,p_item_property_id => l_item_property_id
1329: ,p_default_value => p_default_value

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

1332: ,p_prompt_text => p_prompt_text
1333: ,p_tooltip_text => p_tooltip_text);
1334:
1335: ELSE
1336: hr_utility.set_location('At:'|| l_proc, 40);
1337:
1338: FOR cur_rec in cur_item_tl LOOP
1339: IF cur_item_tl%ROWCOUNT = 1 THEN
1340: hr_utility.set_location('At:'|| l_proc, 45);

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

1336: hr_utility.set_location('At:'|| l_proc, 40);
1337:
1338: FOR cur_rec in cur_item_tl LOOP
1339: IF cur_item_tl%ROWCOUNT = 1 THEN
1340: hr_utility.set_location('At:'|| l_proc, 45);
1341:
1342: hr_ipt_ins.ins_tl(p_language_code => cur_rec.source_lang
1343: ,p_item_property_id => l_item_property_id
1344: ,p_default_value => cur_rec.default_value

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

1346: ,p_label => cur_rec.label
1347: ,p_prompt_text => cur_rec.prompt_text
1348: ,p_tooltip_text => cur_rec.tooltip_text);
1349: ELSE
1350: hr_utility.set_location('At:'|| l_proc, 50);
1351:
1352: hr_ipt_upd.upd_tl(p_language_code => cur_rec.source_lang
1353: ,p_item_property_id => l_item_property_id
1354: ,p_default_value => cur_rec.default_value

Line 1396: hr_utility.set_location('At:'|| l_proc, 60);

1392: );
1393: --
1394: -- When in validation only mode raise the Validate_Enabled exception
1395: --
1396: hr_utility.set_location('At:'|| l_proc, 60);
1397:
1398: if p_validate then
1399: raise hr_api.validate_enabled;
1400: end if;

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

1404: p_item_property_id := l_item_property_id;
1405: p_object_version_number := l_object_version_number;
1406: --p_override_value_warning := l_override_value_warning;
1407: --
1408: hr_utility.set_location(' Leaving:'||l_proc, 70);
1409: exception
1410: when hr_api.validate_enabled then
1411: --
1412: -- As the Validate_Enabled exception has been raised

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

1419: -- when validation only mode is being used.)
1420: --
1421: p_item_property_id := null;
1422: --p_override_value_warning := null;
1423: hr_utility.set_location(' Leaving:'||l_proc, 80);
1424: when others then
1425: --
1426: -- A validation or unexpected error has occured
1427: --

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

1425: --
1426: -- A validation or unexpected error has occured
1427: --
1428: rollback to copy_item_property;
1429: hr_utility.set_location(' Leaving:'||l_proc, 90);
1430: raise;
1431: end copy_item_property;
1432: --
1433: --

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

1698: l_object_version_number number;
1699: l_override_value_warning boolean;
1700: l_proc varchar2(72) := g_package||'copy_item_property';
1701: begin
1702: hr_utility.set_location('Entering:'|| l_proc, 10);
1703: --
1704: -- Issue a savepoint
1705: --
1706: savepoint copy_item_property;

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

1715: --
1716: l_language_code := p_language_code;
1717: hr_api.validate_language_code(p_language_code => l_language_code);
1718: --
1719: hr_utility.set_location(l_proc, 20);
1720: --
1721: --
1722: -- Validation in addition to Row Handlers
1723: --

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

1720: --
1721: --
1722: -- Validation in addition to Row Handlers
1723: --
1724: hr_utility.set_location('At:'|| l_proc, 15);
1725:
1726: OPEN cur_check;
1727: FETCH cur_check INTO l_check;
1728: IF cur_check%NOTFOUND THEN

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

1736: CLOSE cur_check;
1737: --
1738: -- Process Logic
1739: --
1740: hr_utility.set_location('At:'|| l_proc, 20);
1741:
1742: OPEN cur_item_prop;
1743: FETCH cur_item_prop INTO l_rec;
1744: CLOSE cur_item_prop;

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

1742: OPEN cur_item_prop;
1743: FETCH cur_item_prop INTO l_rec;
1744: CLOSE cur_item_prop;
1745:
1746: hr_utility.set_location('At:'|| l_proc, 25);
1747:
1748: hr_itp_ins.ins(p_effective_date => TRUNC(p_effective_date)
1749: ,p_template_item_context_id => p_template_item_context_id
1750: ,p_alignment => l_rec.alignment

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

1815: ,p_item_property_id => l_item_property_id
1816: ,p_object_version_number => l_object_version_number);
1817: --,p_override_value_warning => l_override_value_warning);
1818:
1819: hr_utility.set_location('At:'|| l_proc, 30);
1820:
1821: IF (p_default_value <> hr_api.g_varchar2)
1822: AND ( p_information_prompt <> hr_api.g_varchar2)
1823: AND ( p_label <> hr_api.g_varchar2 )

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

1823: AND ( p_label <> hr_api.g_varchar2 )
1824: AND ( p_prompt_text <> hr_api.g_varchar2 )
1825: AND ( p_tooltip_text <> hr_api.g_varchar2 ) THEN
1826:
1827: hr_utility.set_location('At:'|| l_proc, 35);
1828:
1829: hr_ipt_ins.ins_tl(p_language_code => l_language_code
1830: ,p_item_property_id => l_item_property_id
1831: ,p_default_value => p_default_value

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

1834: ,p_prompt_text => p_prompt_text
1835: ,p_tooltip_text => p_tooltip_text);
1836:
1837: ELSE
1838: hr_utility.set_location('At:'|| l_proc, 40);
1839:
1840: FOR cur_rec in cur_item_tl LOOP
1841: IF cur_item_tl%ROWCOUNT = 1 THEN
1842: hr_utility.set_location('At:'|| l_proc, 45);

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

1838: hr_utility.set_location('At:'|| l_proc, 40);
1839:
1840: FOR cur_rec in cur_item_tl LOOP
1841: IF cur_item_tl%ROWCOUNT = 1 THEN
1842: hr_utility.set_location('At:'|| l_proc, 45);
1843:
1844: hr_ipt_ins.ins_tl(p_language_code => cur_rec.source_lang
1845: ,p_item_property_id => l_item_property_id
1846: ,p_default_value => cur_rec.default_value

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

1848: ,p_label => cur_rec.label
1849: ,p_prompt_text => cur_rec.prompt_text
1850: ,p_tooltip_text => cur_rec.tooltip_text);
1851: ELSE
1852: hr_utility.set_location('At:'|| l_proc, 50);
1853:
1854: hr_ipt_upd.upd_tl(p_language_code => cur_rec.source_lang
1855: ,p_item_property_id => l_item_property_id
1856: ,p_default_value => cur_rec.default_value

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

1894: );
1895: --
1896: -- When in validation only mode raise the Validate_Enabled exception
1897: --
1898: hr_utility.set_location('At:'|| l_proc, 55);
1899:
1900: if p_validate then
1901: raise hr_api.validate_enabled;
1902: end if;

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

1906: p_item_property_id := l_item_property_id;
1907: p_object_version_number := l_object_version_number;
1908: --p_override_value_warning := l_override_value_warning;
1909: --
1910: hr_utility.set_location(' Leaving:'||l_proc, 70);
1911: exception
1912: when hr_api.validate_enabled then
1913: --
1914: -- As the Validate_Enabled exception has been raised

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

1921: -- when validation only mode is being used.)
1922: --
1923: p_item_property_id := null;
1924: --p_override_value_warning := null;
1925: hr_utility.set_location(' Leaving:'||l_proc, 80);
1926: when others then
1927: --
1928: -- A validation or unexpected error has occured
1929: --

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

1927: --
1928: -- A validation or unexpected error has occured
1929: --
1930: rollback to copy_item_property;
1931: hr_utility.set_location(' Leaving:'||l_proc, 90);
1932: raise;
1933: end copy_item_property;
1934: --
1935: --

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

2201: l_proc varchar2(72) := g_package||'copy_item_property';
2202: l_language_code fnd_languages.language_code%TYPE;
2203:
2204: begin
2205: hr_utility.set_location('Entering:'|| l_proc, 10);
2206: --
2207: -- Issue a savepoint
2208: --
2209: savepoint copy_item_property;

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

2218: --
2219: l_language_code := p_language_code;
2220: hr_api.validate_language_code(p_language_code => l_language_code);
2221: --
2222: hr_utility.set_location(l_proc, 20);
2223: --
2224: --
2225: -- Validation in addition to Row Handlers
2226: --

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

2223: --
2224: --
2225: -- Validation in addition to Row Handlers
2226: --
2227: hr_utility.set_location('At:'|| l_proc, 15);
2228:
2229: OPEN cur_check;
2230: FETCH cur_check INTO l_check;
2231: IF cur_check%NOTFOUND THEN

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

2239: CLOSE cur_check;
2240: --
2241: -- Process Logic
2242: --
2243: hr_utility.set_location('At:'|| l_proc, 20);
2244:
2245: OPEN cur_item_prop;
2246: FETCH cur_item_prop INTO l_rec;
2247: CLOSE cur_item_prop;

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

2245: OPEN cur_item_prop;
2246: FETCH cur_item_prop INTO l_rec;
2247: CLOSE cur_item_prop;
2248:
2249: hr_utility.set_location('At:'|| l_proc, 25);
2250:
2251: hr_itp_ins.ins(p_effective_date => TRUNC(p_effective_date)
2252: ,p_template_item_id => p_template_item_id_to
2253: ,p_alignment => l_rec.alignment

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

2318: ,p_item_property_id => l_item_property_id
2319: ,p_object_version_number => l_object_version_number);
2320: --,p_override_value_warning => l_override_value_warning);
2321:
2322: hr_utility.set_location('At:'|| l_proc, 30);
2323:
2324: IF ( p_default_value <> hr_api.g_varchar2)
2325: AND ( p_information_prompt <> hr_api.g_varchar2)
2326: AND ( p_label <> hr_api.g_varchar2 )

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

2326: AND ( p_label <> hr_api.g_varchar2 )
2327: AND ( p_prompt_text <> hr_api.g_varchar2 )
2328: AND ( p_tooltip_text <> hr_api.g_varchar2 ) THEN
2329:
2330: hr_utility.set_location('At:'|| l_proc, 35);
2331:
2332: hr_ipt_ins.ins_tl(p_language_code => l_language_code
2333: ,p_item_property_id => l_item_property_id
2334: ,p_default_value => p_default_value

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

2337: ,p_prompt_text => p_prompt_text
2338: ,p_tooltip_text => p_tooltip_text);
2339:
2340: ELSE
2341: hr_utility.set_location('At:'|| l_proc, 40);
2342:
2343: FOR cur_rec in cur_item_tl LOOP
2344: IF cur_item_tl%ROWCOUNT = 1 THEN
2345: hr_utility.set_location('At:'|| l_proc, 45);

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

2341: hr_utility.set_location('At:'|| l_proc, 40);
2342:
2343: FOR cur_rec in cur_item_tl LOOP
2344: IF cur_item_tl%ROWCOUNT = 1 THEN
2345: hr_utility.set_location('At:'|| l_proc, 45);
2346:
2347: hr_ipt_ins.ins_tl(p_language_code => cur_rec.source_lang
2348: ,p_item_property_id => l_item_property_id
2349: ,p_default_value => cur_rec.default_value

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

2351: ,p_label => cur_rec.label
2352: ,p_prompt_text => cur_rec.prompt_text
2353: ,p_tooltip_text => cur_rec.tooltip_text);
2354: ELSE
2355: hr_utility.set_location('At:'|| l_proc, 50);
2356:
2357: hr_ipt_upd.upd_tl(p_language_code => cur_rec.source_lang
2358: ,p_item_property_id => l_item_property_id
2359: ,p_default_value => cur_rec.default_value

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

2397: );
2398: --
2399: -- When in validation only mode raise the Validate_Enabled exception
2400: --
2401: hr_utility.set_location('At:'|| l_proc, 55);
2402:
2403: if p_validate then
2404: raise hr_api.validate_enabled;
2405: end if;

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

2409: p_item_property_id := l_item_property_id;
2410: p_object_version_number := l_object_version_number;
2411: --p_override_value_warning := l_override_value_warning;
2412: --
2413: hr_utility.set_location(' Leaving:'||l_proc, 70);
2414: exception
2415: when hr_api.validate_enabled then
2416: --
2417: -- As the Validate_Enabled exception has been raised

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

2424: -- when validation only mode is being used.)
2425: --
2426: p_item_property_id := null;
2427: --p_override_value_warning := null;
2428: hr_utility.set_location(' Leaving:'||l_proc, 80);
2429: when others then
2430: --
2431: -- A validation or unexpected error has occured
2432: --

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

2430: --
2431: -- A validation or unexpected error has occured
2432: --
2433: rollback to copy_item_property;
2434: hr_utility.set_location(' Leaving:'||l_proc, 90);
2435: raise;
2436: end copy_item_property;
2437: --
2438: --

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

2709: l_object_version_number number;
2710: l_override_value_warning boolean;
2711: l_proc varchar2(72) := g_package||'copy_item_property';
2712: begin
2713: hr_utility.set_location('Entering:'|| l_proc, 10);
2714: --
2715: -- Issue a savepoint
2716: --
2717: savepoint copy_item_property;

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

2726: --
2727: l_language_code := p_language_code;
2728: hr_api.validate_language_code(p_language_code => l_language_code);
2729: --
2730: hr_utility.set_location(l_proc, 20);
2731: --
2732: --
2733: -- Validation in addition to Row Handlers
2734: --

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

2731: --
2732: --
2733: -- Validation in addition to Row Handlers
2734: --
2735: hr_utility.set_location('At:'|| l_proc, 15);
2736:
2737: OPEN cur_check;
2738: FETCH cur_check INTO l_check;
2739: IF cur_check%NOTFOUND THEN

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

2747: CLOSE cur_check;
2748: --
2749: -- Process Logic
2750: --
2751: hr_utility.set_location('At:'|| l_proc, 20);
2752:
2753: OPEN cur_item_prop;
2754: FETCH cur_item_prop INTO l_rec;
2755: CLOSE cur_item_prop;

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

2753: OPEN cur_item_prop;
2754: FETCH cur_item_prop INTO l_rec;
2755: CLOSE cur_item_prop;
2756:
2757: hr_utility.set_location('At:'|| l_proc, 30);
2758:
2759: hr_itp_ins.ins(p_effective_date => TRUNC(p_effective_date)
2760: ,p_template_item_context_id => p_template_item_context_id_to
2761: ,p_alignment => l_rec.alignment

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

2826: ,p_item_property_id => l_item_property_id
2827: ,p_object_version_number => l_object_version_number);
2828: --,p_override_value_warning => l_override_value_warning);
2829:
2830: hr_utility.set_location('At:'|| l_proc, 35);
2831:
2832: IF ( p_default_value <> hr_api.g_varchar2)
2833: AND ( p_information_prompt <> hr_api.g_varchar2)
2834: AND ( p_label <> hr_api.g_varchar2 )

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

2834: AND ( p_label <> hr_api.g_varchar2 )
2835: AND ( p_prompt_text <> hr_api.g_varchar2 )
2836: AND ( p_tooltip_text <> hr_api.g_varchar2 ) THEN
2837:
2838: hr_utility.set_location('At:'|| l_proc, 40);
2839:
2840: hr_ipt_ins.ins_tl(p_language_code => l_language_code
2841: ,p_item_property_id => l_item_property_id
2842: ,p_default_value => p_default_value

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

2845: ,p_prompt_text => p_prompt_text
2846: ,p_tooltip_text => p_tooltip_text);
2847:
2848: ELSE
2849: hr_utility.set_location('At:'|| l_proc, 45);
2850:
2851: FOR cur_rec in cur_item_tl LOOP
2852: IF cur_item_tl%ROWCOUNT = 1 THEN
2853: hr_utility.set_location('At:'|| l_proc, 50);

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

2849: hr_utility.set_location('At:'|| l_proc, 45);
2850:
2851: FOR cur_rec in cur_item_tl LOOP
2852: IF cur_item_tl%ROWCOUNT = 1 THEN
2853: hr_utility.set_location('At:'|| l_proc, 50);
2854:
2855: hr_ipt_ins.ins_tl(p_language_code => cur_rec.source_lang
2856: ,p_item_property_id => l_item_property_id
2857: ,p_default_value => cur_rec.default_value

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

2859: ,p_label => cur_rec.label
2860: ,p_prompt_text => cur_rec.prompt_text
2861: ,p_tooltip_text => cur_rec.tooltip_text);
2862: ELSE
2863: hr_utility.set_location('At:'|| l_proc, 55);
2864:
2865: hr_ipt_upd.upd_tl(p_language_code => cur_rec.source_lang
2866: ,p_item_property_id => l_item_property_id
2867: ,p_default_value => cur_rec.default_value

Line 2909: hr_utility.set_location('At:'|| l_proc, 60);

2905: );
2906: --
2907: -- When in validation only mode raise the Validate_Enabled exception
2908: --
2909: hr_utility.set_location('At:'|| l_proc, 60);
2910:
2911: if p_validate then
2912: raise hr_api.validate_enabled;
2913: end if;

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

2917: p_item_property_id := l_item_property_id;
2918: p_object_version_number := l_object_version_number;
2919: --p_override_value_warning := l_override_value_warning;
2920: --
2921: hr_utility.set_location(' Leaving:'||l_proc, 70);
2922: exception
2923: when hr_api.validate_enabled then
2924: --
2925: -- As the Validate_Enabled exception has been raised

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

2932: -- when validation only mode is being used.)
2933: --
2934: p_item_property_id := null;
2935: --p_override_value_warning := null;
2936: hr_utility.set_location(' Leaving:'||l_proc, 80);
2937: when others then
2938: --
2939: -- A validation or unexpected error has occured
2940: --

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

2938: --
2939: -- A validation or unexpected error has occured
2940: --
2941: rollback to copy_item_property;
2942: hr_utility.set_location(' Leaving:'||l_proc, 90);
2943: raise;
2944: end copy_item_property;
2945: --
2946: end hr_item_properties_bsi;