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.FF_ARCHIVE_API dependencies on HR_UTILITY

Line 87: hr_utility.set_location('Entering:'||l_proc, 5);

83: l_proc varchar2(70) := g_package||'convert_params';
84: --
85: BEGIN
86: --
87: hr_utility.set_location('Entering:'||l_proc, 5);
88: --
89: g_context_names(1) := p_context_name1;
90: g_context_values(1) := p_context1;
91: g_context_names(2) := p_context_name2;

Line 152: hr_utility.set_location('Leaving:'||l_proc, 10);

148: g_context_values(30) := p_context30;
149: g_context_names(31) := p_context_name31;
150: g_context_values(31) := p_context31;
151: --
152: hr_utility.set_location('Leaving:'||l_proc, 10);
153: --
154: end convert_params;
155: -- ----------------------------------------------------------------------------
156: -- |------------------------< get_context_id (private)>-----------------------|

Line 184: hr_utility.trace('Using Cached Context ID for '||p_context_name);

180: LOOP
181: l_count := l_count + 1;
182: IF g_context_stored_names(l_count) = p_context_name THEN
183: l_context_id := g_context_ids(l_count);
184: hr_utility.trace('Using Cached Context ID for '||p_context_name);
185: exit;
186: END IF;
187: END LOOP;
188: EXCEPTION WHEN NO_DATA_FOUND THEN

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

300: l_proc varchar2(72) := g_package||'create_archive_item';
301: invalid_archive_type exception;
302: invalid_context exception;
303: begin
304: hr_utility.set_location('Entering:'|| l_proc, 10);
305: --
306: -- Issue a savepoint
307: --
308: savepoint create_archive_item;

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

305: --
306: -- Issue a savepoint
307: --
308: savepoint create_archive_item;
309: hr_utility.set_location(l_proc, 20);
310: --
311: -- Validation in addition to Row Handlers
312: --
313: --1)Is the parameterised or defaulted archive type in the set

Line 338: hr_utility.set_location(l_proc, 40);

334: end if;
335: --
336: END IF;
337: --
338: hr_utility.set_location(l_proc, 40);
339: --
340: --2)Is the parameter p_action_id either a valid assignment action
341: -- or a valid payroll_action. If not, error.
342: -- (This validation removed, with fix for 1162102).

Line 357: hr_utility.set_location(l_proc, 60);

353: p_context1 => p_action_id,
354: p_value => p_archive_value,
355: p_object_version_number => l_object_version_number); -- an out param.
356: --
357: hr_utility.set_location(l_proc, 60);
358: --
359: -- Child table validation. Convert the parameters into a table structure.
360: convert_params(
361: p_context_name1 ,p_context1

Line 412: hr_utility.trace('Child Context ID:'||to_char(l_context_id));

408: -- Validate the Context by selecting its ID
409: --
410: l_context_id := get_context_id(g_context_names(l_count),p_legislation_code);
411: --
412: hr_utility.trace('Child Context ID:'||to_char(l_context_id));
413: --
414: IF l_context_id is null then
415: raise invalid_context;
416: END IF;

Line 428: hr_utility.trace('Child Context Count:'||to_char(l_count));

424: p_context_id => l_context_id);
425: --
426: END IF;
427: --
428: hr_utility.trace('Child Context Count:'||to_char(l_count));
429: hr_utility.trace('Child Context Name:'||g_context_names(l_count));
430: hr_utility.trace('Child Context Value:'||g_context_values(l_count));
431: --
432: EXIT WHEN g_context_names(l_count) IS NULL;

Line 429: hr_utility.trace('Child Context Name:'||g_context_names(l_count));

425: --
426: END IF;
427: --
428: hr_utility.trace('Child Context Count:'||to_char(l_count));
429: hr_utility.trace('Child Context Name:'||g_context_names(l_count));
430: hr_utility.trace('Child Context Value:'||g_context_values(l_count));
431: --
432: EXIT WHEN g_context_names(l_count) IS NULL;
433: --

Line 430: hr_utility.trace('Child Context Value:'||g_context_values(l_count));

426: END IF;
427: --
428: hr_utility.trace('Child Context Count:'||to_char(l_count));
429: hr_utility.trace('Child Context Name:'||g_context_names(l_count));
430: hr_utility.trace('Child Context Value:'||g_context_values(l_count));
431: --
432: EXIT WHEN g_context_names(l_count) IS NULL;
433: --
434: END LOOP;

Line 439: hr_utility.trace('No Data Found raised');

435: --
436: EXCEPTION
437: WHEN NO_DATA_FOUND THEN
438: -- Finished looping through rows. Handle with null.
439: hr_utility.trace('No Data Found raised');
440: null;
441: END;
442: --
443: -- When in validation only mode raise the Validate_Enabled exception

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

451: p_archive_item_id := l_archive_item_id;
452: p_object_version_number := l_object_version_number;
453: p_some_warning := FALSE;
454: --
455: hr_utility.set_location(' Leaving:'||l_proc, 70);
456: --
457: exception
458: --
459: when invalid_context then

Line 469: hr_utility.set_message(800, 'FF_34957_INVALID_CONTEXT_NAME');

465: p_archive_item_id := null;
466: p_object_version_number := null;
467: p_some_warning := null;
468: --
469: hr_utility.set_message(800, 'FF_34957_INVALID_CONTEXT_NAME');
470: hr_utility.raise_error;
471: --
472: when invalid_archive_type then
473: --

Line 470: hr_utility.raise_error;

466: p_object_version_number := null;
467: p_some_warning := null;
468: --
469: hr_utility.set_message(800, 'FF_34957_INVALID_CONTEXT_NAME');
470: hr_utility.raise_error;
471: --
472: when invalid_archive_type then
473: --
474: rollback to create_archive_item;

Line 482: hr_utility.set_message(800, 'FF_34958_INVALID_ARCHIVE_TYPE');

478: p_archive_item_id := null;
479: p_object_version_number := null;
480: p_some_warning := null;
481: --
482: hr_utility.set_message(800, 'FF_34958_INVALID_ARCHIVE_TYPE');
483: hr_utility.raise_error;
484: --
485: when hr_api.validate_enabled then
486: --

Line 483: hr_utility.raise_error;

479: p_object_version_number := null;
480: p_some_warning := null;
481: --
482: hr_utility.set_message(800, 'FF_34958_INVALID_ARCHIVE_TYPE');
483: hr_utility.raise_error;
484: --
485: when hr_api.validate_enabled then
486: --
487: -- As the Validate_Enabled exception has been raised

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

495: --
496: p_archive_item_id := null;
497: p_object_version_number := null;
498: p_some_warning := FALSE;
499: hr_utility.set_location(' Leaving:'||l_proc, 80);
500: when others then
501: --
502: -- NOCOPY change.
503: --

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

507: --
508: -- A validation or unexpected error has occured
509: --
510: rollback to create_archive_item;
511: hr_utility.set_location(' Leaving:'||l_proc, 90);
512: raise;
513: end create_archive_item;
514: --
515: -- ----------------------------------------------------------------------------

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

596: invalid_archive_type exception;
597: locked_action exception;
598: --
599: BEGIN
600: hr_utility.set_location('Entering:'|| l_proc, 10);
601: l_object_version_number := p_object_version_number;
602: --
603: -- Convert rowid into the necessary table values:
604: --

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

614:
615: -- Issue a savepoint
616: --
617: savepoint update_archive_item;
618: hr_utility.set_location(l_proc, 20);
619: --
620: -- Validation in addition to Row Handlers
621: --
622: -- 1. Check that the type passed in is updatable, ie the type

Line 653: hr_utility.set_location(l_proc, 30);

649: l_report_qualifier,
650: l_report_category;
651: close get_report_details;
652: --
653: hr_utility.set_location(l_proc, 30);
654: --
655: -- Must use the payroll actions report details,
656: -- and the user entity id from this archive item
657: --

Line 688: hr_utility.set_location(l_proc, 40);

684: raise cannot_update_item;
685: end if;
686: close get_format_mapping;
687: --
688: hr_utility.set_location(l_proc, 40);
689: --
690: IF l_mapping_updatable_flag = 'N' THEN
691: --
692: -- Cannot Update, raise error

Line 709: hr_utility.set_location(l_proc, 50);

705: end if;
706: --
707: -- Process Logic.
708: --
709: hr_utility.set_location(l_proc, 50);
710: hr_utility.trace('Archive Item ID:'||to_char(p_archive_item_id));
711: hr_utility.trace('Report Type:'||l_report_type);
712: hr_utility.trace('Report Category:'||l_report_category);
713: hr_utility.trace('Report Qualifier:'||l_report_qualifier);

Line 710: hr_utility.trace('Archive Item ID:'||to_char(p_archive_item_id));

706: --
707: -- Process Logic.
708: --
709: hr_utility.set_location(l_proc, 50);
710: hr_utility.trace('Archive Item ID:'||to_char(p_archive_item_id));
711: hr_utility.trace('Report Type:'||l_report_type);
712: hr_utility.trace('Report Category:'||l_report_category);
713: hr_utility.trace('Report Qualifier:'||l_report_qualifier);
714: --

Line 711: hr_utility.trace('Report Type:'||l_report_type);

707: -- Process Logic.
708: --
709: hr_utility.set_location(l_proc, 50);
710: hr_utility.trace('Archive Item ID:'||to_char(p_archive_item_id));
711: hr_utility.trace('Report Type:'||l_report_type);
712: hr_utility.trace('Report Category:'||l_report_category);
713: hr_utility.trace('Report Qualifier:'||l_report_qualifier);
714: --
715: -- Now update the archive item as all Business Process validation is

Line 712: hr_utility.trace('Report Category:'||l_report_category);

708: --
709: hr_utility.set_location(l_proc, 50);
710: hr_utility.trace('Archive Item ID:'||to_char(p_archive_item_id));
711: hr_utility.trace('Report Type:'||l_report_type);
712: hr_utility.trace('Report Category:'||l_report_category);
713: hr_utility.trace('Report Qualifier:'||l_report_qualifier);
714: --
715: -- Now update the archive item as all Business Process validation is
716: -- complete.

Line 713: hr_utility.trace('Report Qualifier:'||l_report_qualifier);

709: hr_utility.set_location(l_proc, 50);
710: hr_utility.trace('Archive Item ID:'||to_char(p_archive_item_id));
711: hr_utility.trace('Report Type:'||l_report_type);
712: hr_utility.trace('Report Category:'||l_report_category);
713: hr_utility.trace('Report Qualifier:'||l_report_qualifier);
714: --
715: -- Now update the archive item as all Business Process validation is
716: -- complete.
717: --

Line 723: hr_utility.set_location(l_proc, 60);

719: (p_archive_item_id => p_archive_item_id,
720: p_value => p_archive_value,
721: p_object_version_number => l_object_version_number);
722: --
723: hr_utility.set_location(l_proc, 60);
724: --
725: -- When in validation only mode raise the Validate_Enabled exception
726: --
727: if p_validate then

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

732: --
733: p_object_version_number := l_object_version_number;
734: p_some_warning := FALSE;
735: --
736: hr_utility.set_location(' Leaving:'||l_proc, 70);
737: exception
738: when cannot_update_item then
739: --
740: rollback to update_archive_item;

Line 746: hr_utility.set_message(800, 'FF_34961_ARCHIVE_SECURITY');

742: -- NOCOPY change.
743: --
744: p_some_warning := null;
745: --
746: hr_utility.set_message(800, 'FF_34961_ARCHIVE_SECURITY');
747: hr_utility.raise_error;
748: --
749: when invalid_archive_type then
750: --

Line 747: hr_utility.raise_error;

743: --
744: p_some_warning := null;
745: --
746: hr_utility.set_message(800, 'FF_34961_ARCHIVE_SECURITY');
747: hr_utility.raise_error;
748: --
749: when invalid_archive_type then
750: --
751: -- NOCOPY change.

Line 757: hr_utility.set_message(800, 'FF_34958_INVALID_ARCHIVE_TYPE');

753: p_some_warning := null;
754: --
755: rollback to update_archive_item;
756: --
757: hr_utility.set_message(800, 'FF_34958_INVALID_ARCHIVE_TYPE');
758: hr_utility.raise_error;
759: --
760: when hr_api.validate_enabled then
761: --

Line 758: hr_utility.raise_error;

754: --
755: rollback to update_archive_item;
756: --
757: hr_utility.set_message(800, 'FF_34958_INVALID_ARCHIVE_TYPE');
758: hr_utility.raise_error;
759: --
760: when hr_api.validate_enabled then
761: --
762: -- As the Validate_Enabled exception has been raised

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

769: -- when validation only mode is being used.)
770: --
771: p_object_version_number := null;
772: p_some_warning := FALSE;
773: hr_utility.set_location(' Leaving:'||l_proc, 80);
774: when no_data_found then
775: --
776: rollback to update_archive_item;
777: --

Line 782: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

778: -- NOCOPY change.
779: --
780: p_some_warning := null;
781: --
782: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
783: hr_utility.set_message_token('PROCEDURE', l_proc);
784: hr_utility.set_message_token('STEP','10');
785: hr_utility.raise_error;
786: when locked_action then

Line 783: hr_utility.set_message_token('PROCEDURE', l_proc);

779: --
780: p_some_warning := null;
781: --
782: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
783: hr_utility.set_message_token('PROCEDURE', l_proc);
784: hr_utility.set_message_token('STEP','10');
785: hr_utility.raise_error;
786: when locked_action then
787: --

Line 784: hr_utility.set_message_token('STEP','10');

780: p_some_warning := null;
781: --
782: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
783: hr_utility.set_message_token('PROCEDURE', l_proc);
784: hr_utility.set_message_token('STEP','10');
785: hr_utility.raise_error;
786: when locked_action then
787: --
788: rollback to update_archive_item;

Line 785: hr_utility.raise_error;

781: --
782: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
783: hr_utility.set_message_token('PROCEDURE', l_proc);
784: hr_utility.set_message_token('STEP','10');
785: hr_utility.raise_error;
786: when locked_action then
787: --
788: rollback to update_archive_item;
789: --

Line 794: hr_utility.set_message(800, 'FF_34962_ARCH_ACT_INTERLOCK');

790: -- NOCOPY change.
791: --
792: p_some_warning := null;
793: --
794: hr_utility.set_message(800, 'FF_34962_ARCH_ACT_INTERLOCK');
795: hr_utility.raise_error;
796: when others then
797: --
798: -- A validation or unexpected error has occured

Line 795: hr_utility.raise_error;

791: --
792: p_some_warning := null;
793: --
794: hr_utility.set_message(800, 'FF_34962_ARCH_ACT_INTERLOCK');
795: hr_utility.raise_error;
796: when others then
797: --
798: -- A validation or unexpected error has occured
799: --

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

802: -- NOCOPY change.
803: --
804: p_some_warning := null;
805: --
806: hr_utility.set_location(' Leaving:'||l_proc, 90);
807: raise;
808: --
809: end update_archive_item;
810: --