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

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

20: select oracle_username
21: from fnd_oracle_userid
22: where oracle_id = 800;
23: begin
24: hr_utility.set_location('Entering:'|| l_proc, 10);
25: open csr_user;
26: fetch csr_user into l_hr_username;
27: close csr_user;
28: If l_hr_username is not null

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

28: If l_hr_username is not null
29: then
30: If p_mode = g_full_mode
31: then
32: hr_utility.set_location(l_proc, 20);
33: ad_ctx_ddl.optimize_index
34: (idx_name=>l_hr_username||'.IRC_POSTING_CON_TL_CTX'
35: ,optlevel=>'FULL'
36: ,maxtime=>null

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

36: ,maxtime=>null
37: ,token=>null);
38: elsif p_mode = g_online_mode
39: then
40: hr_utility.set_location(l_proc, 30);
41: ad_ctx_ddl.sync_index
42: (idx_name=>l_hr_username||'.IRC_POSTING_CON_TL_CTX');
43: elsif p_mode = g_none_mode
44: then

Line 45: hr_utility.set_location(l_proc, 35);

41: ad_ctx_ddl.sync_index
42: (idx_name=>l_hr_username||'.IRC_POSTING_CON_TL_CTX');
43: elsif p_mode = g_none_mode
44: then
45: hr_utility.set_location(l_proc, 35);
46: end if;
47: end if;
48: hr_utility.set_location('Leaving:'|| l_proc, 40);
49: exception

Line 48: hr_utility.set_location('Leaving:'|| l_proc, 40);

44: then
45: hr_utility.set_location(l_proc, 35);
46: end if;
47: end if;
48: hr_utility.set_location('Leaving:'|| l_proc, 40);
49: exception
50: when others then
51: If csr_user%isopen
52: then

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

150: l_language_code varchar2(30);
151: l_object_version_number number;
152: l_date_approved date := trunc(P_DATE_APPROVED);
153: begin
154: hr_utility.set_location('Entering:'|| l_proc, 10);
155: --
156: -- Issue a savepoint
157: --
158: savepoint create_posting_content;

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

448: --
449: P_POSTING_CONTENT_ID := l_posting_content_id;
450: P_OBJECT_VERSION_NUMBER := l_object_version_number;
451: --
452: hr_utility.set_location(' Leaving:'||l_proc, 70);
453: exception
454: when hr_api.validate_enabled then
455: --
456: -- As the Validate_Enabled exception has been raised

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

463: -- when validation only mode is being used.)
464: --
465: P_POSTING_CONTENT_ID := null;
466: P_OBJECT_VERSION_NUMBER := null;
467: hr_utility.set_location(' Leaving:'||l_proc, 80);
468: when others then
469: --
470: -- A validation or unexpected error has occured
471: --

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

473: -- Reset IN OUT parameters and set OUT parameters
474: --
475: P_POSTING_CONTENT_ID := null;
476: P_OBJECT_VERSION_NUMBER := null;
477: hr_utility.set_location(' Leaving:'||l_proc, 90);
478: raise;
479: end create_posting_content;
480: --
481: -- ----------------------------------------------------------------------------

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

574: l_object_version_number number := P_OBJECT_VERSION_NUMBER;
575: l_date_approved date := trunc(P_DATE_APPROVED);
576: l_language_code varchar2(30);
577: begin
578: hr_utility.set_location('Entering:'|| l_proc, 10);
579: --
580: -- Issue a savepoint
581: --
582: savepoint update_posting_content;

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

873: -- Set all output arguments
874: --
875: P_OBJECT_VERSION_NUMBER := l_object_version_number;
876: --
877: hr_utility.set_location(' Leaving:'||l_proc, 70);
878: exception
879: when hr_api.validate_enabled then
880: --
881: -- As the Validate_Enabled exception has been raised

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

887: -- Only set output warning arguments
888: -- (Any key or derived arguments must be set to null
889: -- when validation only mode is being used.)
890: --
891: hr_utility.set_location(' Leaving:'||l_proc, 80);
892: when others then
893: --
894: -- A validation or unexpected error has occured
895: --

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

895: --
896: rollback to update_posting_content;
897: -- Reset IN OUT parameters and set OUT parameters
898: P_OBJECT_VERSION_NUMBER := l_object_version_number;
899: hr_utility.set_location(' Leaving:'||l_proc, 90);
900: raise;
901: end update_posting_content;
902:
903: -- ----------------------------------------------------------------------------

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

915: -- Declare cursors and local variables
916: --
917: l_proc varchar2(72) := g_package||'delete_posting_content';
918: begin
919: hr_utility.set_location('Entering:'|| l_proc, 10);
920: --
921: -- Issue a savepoint
922: --
923: savepoint delete_posting_content;

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

980: --
981: -- Set all output arguments
982: --
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 998: hr_utility.set_location(' Leaving:'||l_proc, 80);

994: -- (Any key or derived arguments must be set to null
995: -- when validation only mode is being used.)
996: --
997:
998: hr_utility.set_location(' Leaving:'||l_proc, 80);
999:
1000: when others then
1001: --
1002: -- A validation or unexpected error has occured

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

1001: --
1002: -- A validation or unexpected error has occured
1003: --
1004: rollback to delete_posting_content;
1005: hr_utility.set_location(' Leaving:'||l_proc, 90);
1006: raise;
1007: end delete_posting_content;
1008:
1009: -- ----------------------------------------------------------------------------