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

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

225: l_language_code fnd_languages.language_code%TYPE;
226: l_form_template_id_from number;
227:
228: begin
229: hr_utility.set_location('Entering:'|| l_proc, 10);
230: --
231: -- Issue a savepoint
232: --
233: savepoint copy_template;

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

242: --
243: l_language_code := p_language_code;
244: hr_api.validate_language_code(p_language_code => l_language_code);
245: --
246: hr_utility.set_location(l_proc, 20);
247: --
248: --
249: -- Call Before Process User Hook
250: --

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

299:
300: --
301: -- Process Logic
302: --
303: hr_utility.set_location('At:'|| l_proc, 20);
304:
305: OPEN cur_tmplt_rec;
306: FETCH cur_tmplt_rec INTO l_rec;
307: -- ask john not in lld

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

314: fnd_message.raise_error;
315: END IF;
316: CLOSE cur_tmplt_rec;
317:
318: hr_utility.set_location('At:'|| l_proc, 30);
319:
320: hr_tmp_ins.ins(p_effective_date => TRUNC(p_effective_date)
321: ,p_application_id => l_rec.application_id
322: ,p_form_id => l_rec.form_id

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

356: ,p_attribute30 => l_rec.attribute30
357: ,p_form_template_id => l_form_template_id_to
358: ,p_object_version_number => l_object_version_number);
359:
360: hr_utility.set_location('At:'|| l_proc, 40);
361:
362: IF (p_user_template_name <> hr_api.g_varchar2
363: AND p_description <> hr_api.g_varchar2) THEN
364:

Line 365: hr_utility.set_location('At:'|| l_proc, 41);

361:
362: IF (p_user_template_name <> hr_api.g_varchar2
363: AND p_description <> hr_api.g_varchar2) THEN
364:
365: hr_utility.set_location('At:'|| l_proc, 41);
366:
367: hr_tmt_ins.ins_tl( p_language_code => l_language_code
368: ,p_form_template_id => l_form_template_id_to
369: ,p_user_template_name => p_user_template_name

Line 373: hr_utility.set_location('At:'|| l_proc, 42);

369: ,p_user_template_name => p_user_template_name
370: ,p_description => p_description);
371: ELSE
372:
373: hr_utility.set_location('At:'|| l_proc, 42);
374:
375: FOR cur_rec IN cur_tmplt_tl LOOP
376: hr_utility.set_location('At:'|| l_proc, 43);
377:

Line 376: hr_utility.set_location('At:'|| l_proc, 43);

372:
373: hr_utility.set_location('At:'|| l_proc, 42);
374:
375: FOR cur_rec IN cur_tmplt_tl LOOP
376: hr_utility.set_location('At:'|| l_proc, 43);
377:
378: IF cur_tmplt_tl%ROWCOUNT = 1 THEN
379: hr_utility.set_location('At:'|| l_proc, 44);
380: hr_tmt_ins.ins_tl(

Line 379: hr_utility.set_location('At:'|| l_proc, 44);

375: FOR cur_rec IN cur_tmplt_tl LOOP
376: hr_utility.set_location('At:'|| l_proc, 43);
377:
378: IF cur_tmplt_tl%ROWCOUNT = 1 THEN
379: hr_utility.set_location('At:'|| l_proc, 44);
380: hr_tmt_ins.ins_tl(
381: p_language_code => cur_rec.source_lang
382: ,p_form_template_id => l_form_template_id_to
383: ,p_user_template_name => cur_rec.user_template_name

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

382: ,p_form_template_id => l_form_template_id_to
383: ,p_user_template_name => cur_rec.user_template_name
384: ,p_description => cur_rec.description);
385: ELSE
386: hr_utility.set_location('At:'|| l_proc, 45);
387: hr_tmt_upd.upd_tl(
388: p_language_code => cur_rec.source_lang
389: ,p_form_template_id => l_form_template_id_to
390: ,p_user_template_name => cur_rec.user_template_name

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

392: END IF;
393: END LOOP;
394: END IF;
395:
396: hr_utility.set_location('At:'|| l_proc, 50);
397:
398: l_object_version_number := p_object_version_number; -- Bug 3211362
399:
400: hr_form_properties_bsi.copy_form_property(

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

403: ,p_form_template_id_to => l_form_template_id_to
404: ,p_form_property_id => l_form_property_id
405: ,p_object_version_number => l_object_version_number);
406:
407: hr_utility.set_location('At:'|| l_proc, 55);
408:
409: /* commented for bug 1692567 and replaced by text immediately below
410:
411: l_form_template_id_from := p_form_template_id_from;

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

446: ,p_form_template_id_from => l_form_template_id_from
447: ,p_source_form_template_id => l_source_form_template_id
448: ,p_object_version_number => l_object_version_number);
449:
450: hr_utility.set_location('At:'|| l_proc, 60);
451:
452: FOR cur_rec in cur_tmplt_win LOOP
453: hr_template_windows_api.copy_template_window(
454: p_effective_date => TRUNC(p_effective_date)

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

458: ,p_template_window_id_to => l_template_window_id_to
459: ,p_object_version_number => l_ovn_tmplt_win);
460: END LOOP;
461:
462: hr_utility.set_location('At:'|| l_proc, 65);
463:
464: FOR cur_rec in cur_tmplt_item LOOP
465: hr_template_items_api.copy_template_item(
466: p_effective_date => TRUNC(p_effective_date)

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

470: ,p_template_item_id_to => l_template_item_id_to
471: ,p_object_version_number => l_ovn_tmplt_item);
472: END LOOP;
473:
474: hr_utility.set_location('At:'|| l_proc, 70);
475:
476: FOR cur_rec in cur_tmplt_data_group LOOP
477: hr_template_data_groups_api.copy_template_data_group(
478: p_effective_date => TRUNC(p_effective_date)

Line 486: hr_utility.set_location('At:'|| l_proc, 75);

482: ,p_template_data_group_id_to => l_template_data_group_id_to
483: ,p_object_version_number => l_ovn_tmplt_data_group);
484: END LOOP;
485:
486: hr_utility.set_location('At:'|| l_proc, 75);
487: --
488: -- Call After Process User Hook
489: --
490: begin

Line 543: hr_utility.set_location('At:'|| l_proc, 80);

539: end;
540: --
541: -- When in validation only mode raise the Validate_Enabled exception
542: --
543: hr_utility.set_location('At:'|| l_proc, 80);
544:
545: if p_validate then
546: raise hr_api.validate_enabled;
547: end if;

Line 554: hr_utility.set_location(' Leaving:'||l_proc, 85);

550: --
551: p_form_template_id_to := l_form_template_id_to;
552: p_object_version_number := l_object_version_number;
553: --
554: hr_utility.set_location(' Leaving:'||l_proc, 85);
555: exception
556: when hr_api.validate_enabled then
557: --
558: -- As the Validate_Enabled exception has been raised

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

565: -- when validation only mode is being used.)
566: --
567: p_form_template_id_to := null;
568: p_object_version_number := null;
569: hr_utility.set_location(' Leaving:'||l_proc, 80);
570: when others then
571: --
572: -- A validation or unexpected error has occured
573: --

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

574: p_form_template_id_to := null;
575: p_object_version_number := null;
576:
577: rollback to copy_template;
578: hr_utility.set_location(' Leaving:'||l_proc, 90);
579: raise;
580: end copy_template;
581: --
582: -- ----------------------------------------------------------------------------

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

672: l_source_form_template_id number;
673: l_language_code fnd_languages.language_code%TYPE;
674:
675: begin
676: hr_utility.set_location('Entering:'|| l_proc, 10);
677: --
678: -- Issue a savepoint
679: --
680: savepoint create_template;

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

689: --
690: l_language_code := p_language_code;
691: hr_api.validate_language_code(p_language_code => l_language_code);
692: --
693: hr_utility.set_location(l_proc, 20);
694: --
695: --
696: -- Call Before Process User Hook
697: --

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

778: end;
779: --
780: -- Process Logic
781: --
782: hr_utility.set_location(' At:'||l_proc, 20);
783:
784: hr_tmp_ins.ins( p_effective_date => TRUNC(p_effective_date)
785: ,p_application_id => p_application_id
786: ,p_form_id => p_form_id

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

820: ,p_attribute30 => p_attribute30
821: ,p_form_template_id => l_form_template_id
822: ,p_object_version_number => l_object_version_number);
823:
824: hr_utility.set_location(' At:'||l_proc, 25);
825:
826: hr_tmt_ins.ins_tl( p_language_code => l_language_code
827: ,p_form_template_id => l_form_template_id
828: ,p_user_template_name => p_user_template_name

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

827: ,p_form_template_id => l_form_template_id
828: ,p_user_template_name => p_user_template_name
829: ,p_description => p_description);
830:
831: hr_utility.set_location(' At:'||l_proc, 30);
832:
833: hr_form_properties_bsi.copy_form_property(
834: p_effective_date => TRUNC(p_effective_date)
835: ,p_application_id => p_application_id

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

869: ,p_information30 => p_information30
870: ,p_form_property_id => l_form_property_id
871: ,p_object_version_number => l_object_version_number);
872:
873: hr_utility.set_location(' At:'||l_proc, 30);
874:
875: IF g_session_mode <> 'SEED_DATA' THEN
876:
877: hr_source_form_templates_bsi.create_source_form_template(

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

980: --
981: p_form_template_id := l_form_template_id;
982: p_object_version_number := l_object_version_number;
983: --
984: hr_utility.set_location(' Leaving:'||l_proc, 70);
985: exception
986: when hr_api.validate_enabled then
987: --
988: -- As the Validate_Enabled exception has been raised

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

995: -- when validation only mode is being used.)
996: --
997: p_form_template_id := null;
998: p_object_version_number := null;
999: hr_utility.set_location(' Leaving:'||l_proc, 80);
1000: when others then
1001: --
1002: -- A validation or unexpected error has occured
1003: --

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

1004: p_form_template_id := null;
1005: p_object_version_number := null;
1006:
1007: rollback to create_template;
1008: hr_utility.set_location(' Leaving:'||l_proc, 90);
1009: raise;
1010: end create_template;
1011: --
1012: -- ----------------------------------------------------------------------------

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

1059: WHERE hsf.form_template_id_to = p_form_template_id;
1060:
1061: l_proc varchar2(72) := g_package||'delete_template';
1062: begin
1063: hr_utility.set_location('Entering:'|| l_proc, 10);
1064: --
1065: -- Issue a savepoint
1066: --
1067: savepoint delete_template;

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

1082: );
1083: end;
1084: --
1085: -- extra validation
1086: hr_utility.set_location('At:'|| l_proc, 20);
1087: OPEN cur_api_val;
1088: FETCH cur_api_val INTO l_temp;
1089: IF (cur_api_val%NOTFOUND AND
1090: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN

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

1099: --
1100: --
1101: -- Process Logic
1102: --
1103: hr_utility.set_location('At:'|| l_proc, 30);
1104:
1105: hr_tmp_shd.lck( p_form_template_id => p_form_template_id
1106: ,p_object_version_number => p_object_version_number);
1107:

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

1104:
1105: hr_tmp_shd.lck( p_form_template_id => p_form_template_id
1106: ,p_object_version_number => p_object_version_number);
1107:
1108: hr_utility.set_location('At:'|| l_proc, 40);
1109: IF p_delete_children_flag = 'Y' THEN
1110: hr_utility.set_location('At:'|| l_proc, 50);
1111:
1112: FOR cur_rec in cur_del_item LOOP

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

1106: ,p_object_version_number => p_object_version_number);
1107:
1108: hr_utility.set_location('At:'|| l_proc, 40);
1109: IF p_delete_children_flag = 'Y' THEN
1110: hr_utility.set_location('At:'|| l_proc, 50);
1111:
1112: FOR cur_rec in cur_del_item LOOP
1113: hr_template_items_api.delete_template_item(
1114: p_template_item_id => cur_rec.template_item_id

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

1115: ,p_object_version_number => cur_rec.object_version_number
1116: ,p_delete_children_flag => p_delete_children_flag);
1117: END LOOP;
1118:
1119: hr_utility.set_location('At:'|| l_proc, 60);
1120:
1121: FOR cur_rec in cur_del_win LOOP
1122: hr_template_windows_api.delete_template_window(
1123: p_template_window_id => cur_rec.template_window_id

Line 1128: hr_utility.set_location('At:'|| l_proc, 70);

1124: ,p_object_version_number => cur_rec.object_version_number
1125: ,p_delete_children_flag => p_delete_children_flag);
1126: END LOOP;
1127:
1128: hr_utility.set_location('At:'|| l_proc, 70);
1129:
1130: FOR cur_rec in cur_del_data_group LOOP
1131: hr_template_data_groups_api.delete_template_data_group(
1132: p_template_data_group_id => cur_rec.template_data_group_id

Line 1137: hr_utility.set_location('At:'|| l_proc, 80);

1133: ,p_object_version_number => cur_rec.object_version_number);
1134: END LOOP;
1135: END IF;
1136:
1137: hr_utility.set_location('At:'|| l_proc, 80);
1138:
1139: FOR cur_rec in cur_del_form_tmplt LOOP
1140: hr_source_form_templates_bsi.delete_source_form_template
1141: (p_source_form_template_id => cur_rec.source_form_template_id

Line 1145: hr_utility.set_location('At:'|| l_proc, 81);

1141: (p_source_form_template_id => cur_rec.source_form_template_id
1142: ,p_object_version_number => p_object_version_number);
1143: END LOOP;
1144:
1145: hr_utility.set_location('At:'|| l_proc, 81);
1146:
1147: hr_form_properties_bsi.delete_form_property
1148: (p_form_template_id => p_form_template_id
1149: ,p_object_version_number => p_object_version_number);

Line 1151: hr_utility.set_location('At:'|| l_proc, 82);

1147: hr_form_properties_bsi.delete_form_property
1148: (p_form_template_id => p_form_template_id
1149: ,p_object_version_number => p_object_version_number);
1150:
1151: hr_utility.set_location('At:'|| l_proc, 82);
1152:
1153: hr_tmt_del.del_tl(p_form_template_id => p_form_template_id);
1154:
1155: hr_utility.set_location('At:'|| l_proc, 83);

Line 1155: hr_utility.set_location('At:'|| l_proc, 83);

1151: hr_utility.set_location('At:'|| l_proc, 82);
1152:
1153: hr_tmt_del.del_tl(p_form_template_id => p_form_template_id);
1154:
1155: hr_utility.set_location('At:'|| l_proc, 83);
1156:
1157: hr_tmp_del.del( p_form_template_id => p_form_template_id
1158: ,p_object_version_number => p_object_version_number);
1159:

Line 1160: hr_utility.set_location('At:'|| l_proc, 84);

1156:
1157: hr_tmp_del.del( p_form_template_id => p_form_template_id
1158: ,p_object_version_number => p_object_version_number);
1159:
1160: hr_utility.set_location('At:'|| l_proc, 84);
1161:
1162: --
1163: -- Call After Process User Hook
1164: --

Line 1181: hr_utility.set_location('At:'|| l_proc, 85);

1177: end;
1178: --
1179: -- When in validation only mode raise the Validate_Enabled exception
1180: --
1181: hr_utility.set_location('At:'|| l_proc, 85);
1182:
1183: if p_validate then
1184: raise hr_api.validate_enabled;
1185: end if;

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

1183: if p_validate then
1184: raise hr_api.validate_enabled;
1185: end if;
1186: --
1187: hr_utility.set_location(' Leaving:'||l_proc, 90);
1188: exception
1189: when hr_api.validate_enabled then
1190: --
1191: -- As the Validate_Enabled exception has been raised

Line 1200: hr_utility.set_location(' Leaving:'||l_proc, 91);

1196: -- Only set output warning arguments
1197: -- (Any key or derived arguments must be set to null
1198: -- when validation only mode is being used.)
1199: --
1200: hr_utility.set_location(' Leaving:'||l_proc, 91);
1201: when others then
1202: --
1203: -- A validation or unexpected error has occured
1204: --

Line 1206: hr_utility.set_location(' Leaving:'||l_proc, 92);

1202: --
1203: -- A validation or unexpected error has occured
1204: --
1205: rollback to delete_template;
1206: hr_utility.set_location(' Leaving:'||l_proc, 92);
1207: raise;
1208: end delete_template;
1209: --
1210: -- ----------------------------------------------------------------------------

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

1302:
1303: l_proc varchar2(72) := g_package||'update_template';
1304: l_object_version_number number;
1305: begin
1306: hr_utility.set_location('Entering:'|| l_proc, 10);
1307: --
1308: -- Issue a savepoint
1309: --
1310: savepoint update_template;

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

1320: --
1321: l_language_code := p_language_code;
1322: hr_api.validate_language_code(p_language_code => l_language_code);
1323: --
1324: hr_utility.set_location(l_proc, 20);
1325: --
1326: --
1327: -- Call Before Process User Hook
1328: --

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

1407: ,p_hook_type => 'BP'
1408: );
1409: end;
1410: -- Extra Validation
1411: hr_utility.set_location('At:'|| l_proc, 20);
1412:
1413: OPEN cur_api_val;
1414: FETCH cur_api_val INTO l_temp;
1415: IF (cur_api_val%NOTFOUND AND

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

1425: --
1426: -- Process Logic
1427: --
1428:
1429: hr_utility.set_location('At:'|| l_proc, 30);
1430:
1431: hr_tmp_upd.upd( p_effective_date => TRUNC(p_effective_date)
1432: ,p_form_template_id => p_form_template_id
1433: ,p_template_name => p_template_name

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

1465: ,p_attribute29 => p_attribute29
1466: ,p_attribute30 => p_attribute30
1467: ,p_object_version_number => l_object_version_number);
1468:
1469: hr_utility.set_location('At:'|| l_proc, 35);
1470:
1471: hr_tmt_upd.upd_tl( p_language_code => l_language_code
1472: ,p_form_template_id => p_form_template_id
1473: ,p_user_template_name => p_user_template_name

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

1472: ,p_form_template_id => p_form_template_id
1473: ,p_user_template_name => p_user_template_name
1474: ,p_description => p_description);
1475:
1476: hr_utility.set_location('At:'|| l_proc, 40);
1477:
1478: l_object_version_number := p_object_version_number; --3211362
1479:
1480: hr_form_properties_bsi.update_form_property(

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

1608: -- Set all output arguments
1609: --
1610: p_object_version_number := l_object_version_number;
1611: --
1612: hr_utility.set_location(' Leaving:'||l_proc, 70);
1613: exception
1614: when hr_api.validate_enabled then
1615: --
1616: -- As the Validate_Enabled exception has been raised

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

1621: -- Only set output warning arguments
1622: -- (Any key or derived arguments must be set to null
1623: -- when validation only mode is being used.)
1624: --
1625: hr_utility.set_location(' Leaving:'||l_proc, 80);
1626: when others then
1627: --
1628: -- A validation or unexpected error has occured
1629: --

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

1627: --
1628: -- A validation or unexpected error has occured
1629: --
1630: rollback to update_template;
1631: hr_utility.set_location(' Leaving:'||l_proc, 90);
1632: raise;
1633: end update_template;
1634: --
1635: end hr_form_templates_api;