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

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

134: l_language_code fnd_languages.language_code%TYPE;
135:
136: l_proc varchar2(72) := g_package||'copy_template_item_context';
137: begin
138: hr_utility.set_location('Entering:'|| l_proc, 10);
139: --
140: -- Issue a savepoint
141: --
142: savepoint copy_template_item_context;

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

151: --
152: l_language_code := p_language_code;
153: hr_api.validate_language_code(p_language_code => l_language_code);
154: --
155: hr_utility.set_location(l_proc, 20);
156: --
157: --
158: -- Call Before Process User Hook
159: --

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

173: end;
174: --
175: -- Validation in addition to Row Handlers
176: --
177: hr_utility.set_location('At:'|| l_proc, 15);
178:
179: OPEN cur_api_val;
180: FETCH cur_api_val INTO l_temp;
181: IF (cur_api_val%NOTFOUND AND

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

191: --
192: --
193: -- Process Logic
194: --
195: hr_utility.set_location('At:'|| l_proc, 20);
196:
197: OPEN cur_item_contexts;
198: FETCH cur_item_contexts INTO l_rec;
199: CLOSE cur_item_contexts;

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

197: OPEN cur_item_contexts;
198: FETCH cur_item_contexts INTO l_rec;
199: CLOSE cur_item_contexts;
200:
201: hr_utility.set_location('At:'|| l_proc, 25);
202:
203: hr_icx_ins.ins_or_sel(
204: p_context_type => l_rec.context_type
205: ,p_segment1 => l_rec.segment1

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

234: ,p_segment30 => l_rec.segment30
235: ,p_item_context_id => l_item_context_id
236: ,p_concatenated_segments => l_concatenated_segments);
237:
238: hr_utility.set_location('At:'|| l_proc, 30);
239:
240: hr_tic_ins.ins( p_template_item_id => p_template_item_id
241: ,p_context_type => l_rec.context_type
242: ,p_item_context_id => l_item_context_id

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

242: ,p_item_context_id => l_item_context_id
243: ,p_template_item_context_id => l_template_item_context_id_to
244: ,p_object_version_number => l_object_version_number);
245:
246: hr_utility.set_location('At:'|| l_proc, 35);
247:
248: hr_item_properties_bsi.copy_item_property(
249: p_effective_date => TRUNC(p_effective_date)
250: ,p_language_code => l_language_code

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

253: ,p_item_property_id => l_item_property_id
254: ,p_object_version_number => l_object_version_number);
255: --,p_override_value_warning => l_override_value_warning);
256:
257: hr_utility.set_location('At:'|| l_proc, 40);
258:
259: FOR cur_rec IN cur_tmplt_tab LOOP
260: hr_tcp_api.create_tcp
261: (p_effective_date => TRUNC(p_effective_date)

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

264: ,p_template_item_context_page_i => l_tic_id
265: ,p_object_version_number => l_ovn_item);
266: END LOOP;
267:
268: hr_utility.set_location('At:'|| l_proc, 45);
269:
270: --
271: -- Call After Process User Hook
272: --

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

290: end;
291: --
292: -- When in validation only mode raise the Validate_Enabled exception
293: --
294: hr_utility.set_location('At:'|| l_proc, 50);
295:
296: if p_validate then
297: raise hr_api.validate_enabled;
298: end if;

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

303: p_object_version_number := l_object_version_number;
304: p_item_context_id := l_item_context_id;
305: p_concatenated_segments := l_concatenated_segments;
306: --
307: hr_utility.set_location(' Leaving:'||l_proc, 70);
308: exception
309: when hr_api.validate_enabled then
310: --
311: -- As the Validate_Enabled exception has been raised

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

320: p_template_item_context_id_to := null;
321: p_object_version_number := null;
322: p_item_context_id := null;
323: p_concatenated_segments := null;
324: hr_utility.set_location(' Leaving:'||l_proc, 80);
325: when others then
326: --
327: -- A validation or unexpected error has occured
328: --

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

331: p_item_context_id := null;
332: p_concatenated_segments := null;
333:
334: rollback to copy_template_item_context;
335: hr_utility.set_location(' Leaving:'||l_proc, 90);
336: raise;
337: end copy_template_item_context;
338: --
339: -- ----------------------------------------------------------------------------

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

491: l_language_code fnd_languages.language_code%TYPE;
492:
493: l_proc varchar2(72) := g_package||'create_template_item_context';
494: begin
495: hr_utility.set_location('Entering:'|| l_proc, 10);
496: --
497: -- Issue a savepoint
498: --
499: savepoint create_template_item_context;

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

508: --
509: l_language_code := p_language_code;
510: hr_api.validate_language_code(p_language_code => l_language_code);
511: --
512: hr_utility.set_location(l_proc, 20);
513: --
514: --
515: -- Call Before Process User Hook
516: --

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

630: end;
631: --
632: -- Validation in addition to Row Handlers
633: --
634: hr_utility.set_location('At:'|| l_proc, 15);
635:
636: OPEN cur_override;
637: FETCH cur_override INTO l_required_override,l_visible_override;
638: CLOSE cur_override;

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

636: OPEN cur_override;
637: FETCH cur_override INTO l_required_override,l_visible_override;
638: CLOSE cur_override;
639:
640: hr_utility.set_location('At:'|| l_proc, 20);
641:
642: IF p_required <> hr_api.g_number AND
643: ( l_required_override is not null AND p_required is not null ) THEN
644: l_override_value_warning := TRUE;

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

643: ( l_required_override is not null AND p_required is not null ) THEN
644: l_override_value_warning := TRUE;
645: END IF;
646:
647: hr_utility.set_location('At:'|| l_proc, 25);
648:
649: IF p_visible <> hr_api.g_number AND
650: ( l_visible_override is not null AND p_visible is not null ) THEN
651: l_override_value_warning := TRUE;

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

650: ( l_visible_override is not null AND p_visible is not null ) THEN
651: l_override_value_warning := TRUE;
652: END IF;
653:
654: hr_utility.set_location('At:'|| l_proc, 30);
655:
656: OPEN cur_api_val;
657: FETCH cur_api_val INTO l_temp;
658: IF (cur_api_val%NOTFOUND AND

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

665: fnd_message.raise_error;
666: END IF;
667: CLOSE cur_api_val;
668:
669: hr_utility.set_location('At:'|| l_proc, 35);
670:
671: --
672: --
673: -- Process Logic

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

707: ,p_segment30 => p_segment30
708: ,p_item_context_id => l_item_context_id
709: ,p_concatenated_segments => l_concatenated_segments);
710:
711: hr_utility.set_location('At:'|| l_proc, 40);
712:
713: hr_tic_ins.ins( p_template_item_id => p_template_item_id
714: ,p_context_type => p_context_type
715: ,p_item_context_id => l_item_context_id

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

715: ,p_item_context_id => l_item_context_id
716: ,p_template_item_context_id => l_template_item_context_id
717: ,p_object_version_number => l_object_version_number);
718:
719: hr_utility.set_location('At:'|| l_proc, 45);
720:
721: hr_item_properties_bsi.copy_item_property(
722: p_effective_date => TRUNC(p_effective_date)
723: ,p_language_code => l_language_code

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

796: ,p_item_property_id => l_item_property_id
797: ,p_object_version_number => l_object_version_number);
798: --,p_override_value_warning => l_override_value_warning);
799:
800: hr_utility.set_location('At:'|| l_proc, 50);
801:
802: IF p_template_tab_page_id is not null THEN
803:
804: hr_tcp_api.create_tcp(

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

807: ,p_template_tab_page_id => p_template_tab_page_id
808: ,p_template_item_context_page_i => l_tic_id
809: ,p_object_version_number => l_ovn_item);
810: END IF;
811: hr_utility.set_location('At:'|| l_proc, 55);
812:
813: --
814: -- Call After Process User Hook
815: --

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

947: p_item_context_id := l_item_context_id;
948: p_concatenated_segments := l_concatenated_segments;
949: p_override_value_warning := l_override_value_warning;
950: --
951: hr_utility.set_location(' Leaving:'||l_proc, 70);
952: exception
953: when hr_api.validate_enabled then
954: --
955: -- As the Validate_Enabled exception has been raised

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

965: p_object_version_number := null;
966: p_item_context_id := null;
967: p_concatenated_segments := null;
968: p_override_value_warning := l_override_value_warning;
969: hr_utility.set_location(' Leaving:'||l_proc, 80);
970: when others then
971: --
972: -- A validation or unexpected error has occured
973: --

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

977: p_concatenated_segments := null;
978: p_override_value_warning := null;
979:
980: rollback to create_template_item_context;
981: hr_utility.set_location(' Leaving:'||l_proc, 90);
982: raise;
983: end create_template_item_context;
984: --
985: -- ----------------------------------------------------------------------------

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

1016: AND tic.template_item_context_id = p_template_item_context_id;
1017:
1018: l_proc varchar2(72) := g_package||'delete_template_item_context';
1019: begin
1020: hr_utility.set_location('Entering:'|| l_proc, 10);
1021: --
1022: -- Issue a savepoint
1023: --
1024: savepoint delete_template_item_context;

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

1040: end;
1041: --
1042: -- Validation in addition to Row Handlers
1043: --
1044: hr_utility.set_location('At:'|| l_proc, 15);
1045:
1046: OPEN cur_api_val;
1047: FETCH cur_api_val INTO l_temp;
1048: IF (cur_api_val%NOTFOUND AND

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

1058: --
1059: --
1060: -- Process Logic
1061: --
1062: hr_utility.set_location('At:'|| l_proc, 20);
1063:
1064: hr_utility.set_location('At:'|| l_proc, 25);
1065:
1066: FOR cur_rec IN cur_tmplt_item LOOP

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

1060: -- Process Logic
1061: --
1062: hr_utility.set_location('At:'|| l_proc, 20);
1063:
1064: hr_utility.set_location('At:'|| l_proc, 25);
1065:
1066: FOR cur_rec IN cur_tmplt_item LOOP
1067: hr_tcp_api.delete_tcp(
1068: p_template_item_context_page_i => cur_rec.template_item_context_page_id

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

1069: ,p_object_version_number => cur_rec.object_version_number);
1070: --,p_delete_all_flag => 'Y');
1071: END LOOP;
1072:
1073: hr_utility.set_location('At:'|| l_proc, 30);
1074:
1075: hr_item_properties_bsi.delete_item_property(
1076: p_template_item_context_id => p_template_item_context_id
1077: ,p_object_version_number => p_object_version_number);

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

1075: hr_item_properties_bsi.delete_item_property(
1076: p_template_item_context_id => p_template_item_context_id
1077: ,p_object_version_number => p_object_version_number);
1078:
1079: hr_utility.set_location('At:'|| l_proc, 35);
1080:
1081: hr_tic_del.del( p_template_item_context_id => p_template_item_context_id
1082: ,p_object_version_number => p_object_version_number);
1083:

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

1083:
1084: --
1085: -- Call After Process User Hook
1086: --
1087: hr_utility.set_location('At:'|| l_proc, 40);
1088:
1089: begin
1090: hr_template_item_contexts_bk3.delete_template_item_context_a
1091: (p_template_item_context_id => p_template_item_context_id

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

1101: end;
1102: --
1103: -- When in validation only mode raise the Validate_Enabled exception
1104: --
1105: hr_utility.set_location('At:'|| l_proc, 45);
1106:
1107: if p_validate then
1108: raise hr_api.validate_enabled;
1109: end if;

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

1107: if p_validate then
1108: raise hr_api.validate_enabled;
1109: end if;
1110: --
1111: hr_utility.set_location(' Leaving:'||l_proc, 70);
1112: exception
1113: when hr_api.validate_enabled then
1114: --
1115: -- As the Validate_Enabled exception has been raised

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

1120: -- Only set output warning arguments
1121: -- (Any key or derived arguments must be set to null
1122: -- when validation only mode is being used.)
1123: --
1124: hr_utility.set_location(' Leaving:'||l_proc, 80);
1125: when others then
1126: --
1127: -- A validation or unexpected error has occured
1128: --

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

1126: --
1127: -- A validation or unexpected error has occured
1128: --
1129: rollback to delete_template_item_context;
1130: hr_utility.set_location(' Leaving:'||l_proc, 90);
1131: raise;
1132: end delete_template_item_context;
1133: --
1134: -- ----------------------------------------------------------------------------

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

1294: l_language_code fnd_languages.language_code%TYPE;
1295:
1296: l_proc varchar2(72) := g_package||'update_template_item_context';
1297: begin
1298: hr_utility.set_location('Entering:'|| l_proc, 10);
1299: --
1300: -- Issue a savepoint
1301: --
1302: savepoint update_template_item_context;

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

1312: --
1313: l_language_code := p_language_code;
1314: hr_api.validate_language_code(p_language_code => l_language_code);
1315: --
1316: hr_utility.set_location(l_proc, 20);
1317: --
1318: --
1319: -- Call Before Process User Hook
1320: --

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

1435: end;
1436: --
1437: -- Validation in addition to Row Handlers
1438: --
1439: hr_utility.set_location('At:'|| l_proc, 15);
1440:
1441: OPEN cur_override;
1442: FETCH cur_override INTO l_required_override,l_visible_override;
1443: CLOSE cur_override;

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

1441: OPEN cur_override;
1442: FETCH cur_override INTO l_required_override,l_visible_override;
1443: CLOSE cur_override;
1444:
1445: hr_utility.set_location('At:'|| l_proc, 20);
1446:
1447: IF p_required <> hr_api.g_number AND
1448: ( l_required_override is not null AND p_required is not null ) THEN
1449: l_override_value_warning := TRUE;

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

1448: ( l_required_override is not null AND p_required is not null ) THEN
1449: l_override_value_warning := TRUE;
1450: END IF;
1451:
1452: hr_utility.set_location('At:'|| l_proc, 25);
1453:
1454: IF p_visible <> hr_api.g_number AND
1455: ( l_visible_override is not null AND p_visible is not null ) THEN
1456: l_override_value_warning := TRUE;

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

1455: ( l_visible_override is not null AND p_visible is not null ) THEN
1456: l_override_value_warning := TRUE;
1457: END IF;
1458:
1459: hr_utility.set_location('At:'|| l_proc, 30);
1460:
1461: OPEN cur_api_val;
1462: FETCH cur_api_val INTO l_temp;
1463: IF (cur_api_val%NOTFOUND AND

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

1469: fnd_message.set_token('STEP','10');
1470: fnd_message.raise_error;
1471: END IF;
1472: CLOSE cur_api_val;
1473: hr_utility.set_location('At:'|| l_proc, 35);
1474:
1475: --
1476: --
1477: -- Process Logic

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

1523: --,p_object_version_number => l_object_version_number
1524: --,p_context_type => l_context_type
1525: --,p_item_context_id => l_item_context_id);
1526:
1527: hr_utility.set_location('At:'|| l_proc, 40);
1528:
1529: hr_utility.set_location('At:'|| l_proc, 45);
1530:
1531: hr_item_properties_bsi.update_item_property(

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

1525: --,p_item_context_id => l_item_context_id);
1526:
1527: hr_utility.set_location('At:'|| l_proc, 40);
1528:
1529: hr_utility.set_location('At:'|| l_proc, 45);
1530:
1531: hr_item_properties_bsi.update_item_property(
1532: p_effective_date => TRUNC(p_effective_date)
1533: ,p_language_code => l_language_code

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

1604: ,p_next_navigation_item_id => p_next_navigation_item_id
1605: ,p_previous_navigation_item_id => p_previous_navigation_item_id);
1606: --,p_override_value_warning => l_override_value_warning);
1607:
1608: hr_utility.set_location('At:'|| l_proc, 50);
1609:
1610: --
1611: -- Call After Process User Hook
1612: --

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

1730: end;
1731: --
1732: -- When in validation only mode raise the Validate_Enabled exception
1733: --
1734: hr_utility.set_location('At:'|| l_proc, 55);
1735:
1736: if p_validate then
1737: raise hr_api.validate_enabled;
1738: end if;

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

1743: --p_concatenated_segments := l_concatenated_segments;
1744: p_override_value_warning := l_override_value_warning;
1745: p_object_version_number := l_object_version_number;
1746: --
1747: hr_utility.set_location(' Leaving:'||l_proc, 70);
1748: exception
1749: when hr_api.validate_enabled then
1750: --
1751: -- As the Validate_Enabled exception has been raised

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

1759: --
1760: --p_item_context_id := null;
1761: --p_concatenated_segments := null;
1762: p_override_value_warning := l_override_value_warning;
1763: hr_utility.set_location(' Leaving:'||l_proc, 80);
1764: when others then
1765: --
1766: -- A validation or unexpected error has occured
1767: --

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

1767: --
1768: p_override_value_warning := null ;
1769:
1770: rollback to update_template_item_context;
1771: hr_utility.set_location(' Leaving:'||l_proc, 90);
1772: raise;
1773: end update_template_item_context;
1774: --
1775: end hr_template_item_contexts_api;