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

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

50: l_proc varchar2(72) := g_package||'DEFINE_COMM_PROPERTIES';
51: l_communication_property_id number;
52: l_object_version_number number(9);
53: begin
54: hr_utility.set_location('Entering:'|| l_proc, 10);
55: --
56: -- Issue a savepoint
57: --
58: savepoint DEFINE_COMM_PROPERTIES;

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

194: -- Set all output arguments
195: --
196: p_communication_property_id := l_communication_property_id;
197: p_object_version_number := l_object_version_number;
198: hr_utility.set_location(' Leaving:'||l_proc, 70);
199: exception
200: when hr_api.validate_enabled then
201: --
202: -- As the Validate_Enabled exception has been raised

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

209: -- when validation only mode is being used.)
210: --
211: p_communication_property_id := null;
212: p_object_version_number := null;
213: hr_utility.set_location(' Leaving:'||l_proc, 80);
214: when others then
215: --
216: -- A validation or unexpected error has occured
217: --

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

220: --
221: p_communication_property_id := null;
222: p_object_version_number := null;
223: --
224: hr_utility.set_location(' Leaving:'||l_proc, 90);
225: raise;
226: end DEFINE_COMM_PROPERTIES;
227: --
228: --

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

274: -- Define cursors
275: --
276:
277: begin
278: hr_utility.set_location('Entering:'|| l_proc, 10);
279: --
280: -- Issue a savepoint
281: --
282: savepoint UPDATE_COMM_PROPERTIES;

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

422: --
423: -- Set all output arguments
424: --
425: p_object_version_number := l_object_version_number;
426: hr_utility.set_location(' Leaving:'||l_proc, 70);
427: exception
428: when hr_api.validate_enabled then
429: --
430: -- As the Validate_Enabled exception has been raised

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

435: -- Only set output warning arguments
436: -- (Any key or derived arguments must be set to null
437: -- when validation only mode is being used.)
438: --
439: hr_utility.set_location(' Leaving:'||l_proc, 80);
440: when others then
441: --
442: -- A validation or unexpected error has occured
443: --

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

442: -- A validation or unexpected error has occured
443: --
444: rollback to UPDATE_COMM_PROPERTIES;
445: --
446: hr_utility.set_location(' Leaving:'||l_proc, 90);
447: raise;
448: end UPDATE_COMM_PROPERTIES;
449: --
450: --

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

471: l_communication_id number;
472: l_start_date date;
473:
474: begin
475: hr_utility.set_location('Entering:'|| l_proc, 10);
476: --
477: -- Issue a savepoint
478: --
479: savepoint CREATE_COMMUNICATION;

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

547: -- Set all output arguments
548: --
549: p_object_version_number := l_object_version_number;
550: p_communication_id := l_communication_id;
551: hr_utility.set_location(' Leaving:'||l_proc, 70);
552: --
553: exception
554: when hr_api.validate_enabled then
555: --

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

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

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

572: rollback to CREATE_COMMUNICATION;
573: --
574: p_object_version_number := l_object_version_number;
575: p_communication_id := l_communication_id;
576: hr_utility.set_location(' Leaving:'||l_proc, 90);
577: raise;
578: --
579: end CREATE_COMMUNICATION;
580: --

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

600: l_object_version_number number;
601: l_communication_id number;
602:
603: begin
604: hr_utility.set_location('Entering:'|| l_proc, 10);
605: --
606: -- Issue a savepoint
607: --
608: savepoint START_COMMUNICATION;

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

631: -- Set all output arguments
632: --
633: p_object_version_number := l_object_version_number;
634: p_communication_id := l_communication_id;
635: hr_utility.set_location(' Leaving:'||l_proc, 70);
636: --
637: exception
638: when hr_api.validate_enabled then
639: --

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

647: -- when validation only mode is being used.)
648: --
649: p_object_version_number := l_object_version_number;
650: p_communication_id := l_communication_id;
651: hr_utility.set_location(' Leaving:'||l_proc, 80);
652: when others then
653: --
654: -- A validation or unexpected error has occured
655: --

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

656: rollback to START_COMMUNICATION;
657: --
658: p_object_version_number := l_object_version_number;
659: p_communication_id := l_communication_id;
660: hr_utility.set_location(' Leaving:'||l_proc, 90);
661: raise;
662: --
663: end START_COMMUNICATION;
664: --

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

685: l_object_version_number number;
686: l_end_date date;
687:
688: begin
689: hr_utility.set_location('Entering:'|| l_proc, 10);
690: --
691: -- Issue a savepoint
692: --
693: savepoint UPDATE_COMMUNICATION;

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

765: --
766: -- Set all output arguments
767: --
768: p_object_version_number := l_object_version_number;
769: hr_utility.set_location(' Leaving:'||l_proc, 70);
770: --
771: exception
772: when hr_api.validate_enabled then
773: --

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

779: -- Only set output warning arguments
780: -- (Any key or derived arguments must be set to null
781: -- when validation only mode is being used.)
782: --
783: hr_utility.set_location(' Leaving:'||l_proc, 80);
784: when others then
785: --
786: -- A validation or unexpected error has occured
787: --

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

786: -- A validation or unexpected error has occured
787: --
788: rollback to UPDATE_COMMUNICATION;
789: --
790: hr_utility.set_location(' Leaving:'||l_proc, 90);
791: raise;
792: --
793: end UPDATE_COMMUNICATION;
794: --

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

815: l_object_version_number number;
816: l_end_date date;
817:
818: begin
819: hr_utility.set_location('Entering:'|| l_proc, 10);
820: --
821: -- Issue a savepoint
822: --
823: savepoint CLOSE_COMMUNICATION;

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

849: --
850: -- Set all output arguments
851: --
852: p_object_version_number := l_object_version_number;
853: hr_utility.set_location(' Leaving:'||l_proc, 70);
854: --
855: exception
856: when hr_api.validate_enabled then
857: --

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

864: -- (Any key or derived arguments must be set to null
865: -- when validation only mode is being used.)
866: --
867: p_object_version_number := l_object_version_number;
868: hr_utility.set_location(' Leaving:'||l_proc, 80);
869: when others then
870: --
871: -- A validation or unexpected error has occured
872: --

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

872: --
873: rollback to CLOSE_COMMUNICATION;
874: --
875: p_object_version_number := l_object_version_number;
876: hr_utility.set_location(' Leaving:'||l_proc, 90);
877: raise;
878: --
879: end CLOSE_COMMUNICATION;
880: --

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

895: --
896: l_proc varchar2(72) := g_package||'delete_comm_properties';
897: --
898: begin
899: hr_utility.set_location('Entering:'|| l_proc, 10);
900: --
901: -- Issue a savepoint
902: --
903: savepoint DELETE_COMM_PROPERTIES;

Line 927: hr_utility.set_location(' Leaving:'||l_proc, 50);

923: --
924: -- Set all output arguments
925: --
926: --
927: hr_utility.set_location(' Leaving:'||l_proc, 50);
928: exception
929: when hr_api.validate_enabled then
930: --
931: -- As the Validate_Enabled exception has been raised

Line 940: hr_utility.set_location(' Leaving:'||l_proc, 60);

936: -- Only set output warning arguments
937: -- (Any key or derived arguments must be set to null
938: -- when validation only mode is being used.)
939: --
940: hr_utility.set_location(' Leaving:'||l_proc, 60);
941: when others then
942: --
943: -- A validation or unexpected error has occured
944: --

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

942: --
943: -- A validation or unexpected error has occured
944: --
945: rollback to delete_comm_properties;
946: hr_utility.set_location(' Leaving:'||l_proc, 70);
947: raise;
948: end delete_comm_properties;
949: --
950: -- ----------------------------------------------------------------------------

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

968: l_communication_topic_id number;
969: l_start_date date;
970:
971: begin
972: hr_utility.set_location('Entering:'|| l_proc, 10);
973: --
974: -- Issue a savepoint
975: --
976: savepoint CREATE_COMM_TOPIC;

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

1035: -- Set all output arguments
1036: --
1037: p_object_version_number := l_object_version_number;
1038: p_communication_topic_id := l_communication_topic_id;
1039: hr_utility.set_location(' Leaving:'||l_proc, 70);
1040: --
1041: exception
1042: when hr_api.validate_enabled then
1043: --

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

1051: -- when validation only mode is being used.)
1052: --
1053: p_object_version_number := l_object_version_number;
1054: p_communication_topic_id := l_communication_topic_id;
1055: hr_utility.set_location(' Leaving:'||l_proc, 80);
1056: when others then
1057: --
1058: -- A validation or unexpected error has occured
1059: --

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

1060: rollback to CREATE_COMM_TOPIC;
1061: --
1062: p_object_version_number := l_object_version_number;
1063: p_communication_topic_id := l_communication_topic_id;
1064: hr_utility.set_location(' Leaving:'||l_proc, 90);
1065: raise;
1066: --
1067: end create_comm_topic;
1068: --

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

1095: l_communication_message_id number;
1096: l_message_post_date date;
1097:
1098: begin
1099: hr_utility.set_location('Entering:'|| l_proc, 10);
1100: --
1101: -- Issue a savepoint
1102: --
1103: savepoint CREATE_MESSAGE;

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

1186: -- Set all output arguments
1187: --
1188: p_object_version_number := l_object_version_number;
1189: p_communication_message_id := l_communication_message_id;
1190: hr_utility.set_location(' Leaving:'||l_proc, 70);
1191: --
1192: exception
1193: when hr_api.validate_enabled then
1194: --

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

1202: -- when validation only mode is being used.)
1203: --
1204: p_object_version_number := l_object_version_number;
1205: p_communication_message_id := l_communication_message_id;
1206: hr_utility.set_location(' Leaving:'||l_proc, 80);
1207: when others then
1208: --
1209: -- A validation or unexpected error has occured
1210: --

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

1211: rollback to CREATE_MESSAGE;
1212: --
1213: p_object_version_number := l_object_version_number;
1214: p_communication_message_id := l_communication_message_id;
1215: hr_utility.set_location(' Leaving:'||l_proc, 90);
1216: raise;
1217: --
1218: end create_message;
1219: --

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

1234: l_proc varchar2(72) := g_package||'UPDATE_MESSAGE';
1235: l_object_version_number number;
1236:
1237: begin
1238: hr_utility.set_location('Entering:'|| l_proc, 10);
1239: --
1240: -- Issue a savepoint
1241: --
1242: savepoint UPDATE_MESSAGE;

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

1296: --
1297: -- Set all output arguments
1298: --
1299: p_object_version_number := l_object_version_number;
1300: hr_utility.set_location(' Leaving:'||l_proc, 70);
1301: --
1302: exception
1303: when hr_api.validate_enabled then
1304: --

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

1311: -- (Any key or derived arguments must be set to null
1312: -- when validation only mode is being used.)
1313: --
1314: p_object_version_number := l_object_version_number;
1315: hr_utility.set_location(' Leaving:'||l_proc, 80);
1316: when others then
1317: --
1318: -- A validation or unexpected error has occured
1319: --

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

1319: --
1320: rollback to UPDATE_MESSAGE;
1321: --
1322: p_object_version_number := l_object_version_number;
1323: hr_utility.set_location(' Leaving:'||l_proc, 90);
1324: raise;
1325: --
1326: end update_message;
1327: --

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

1351: l_communication_recipient_id number;
1352: l_start_date_active date;
1353:
1354: begin
1355: hr_utility.set_location('Entering:'|| l_proc, 10);
1356: --
1357: -- Issue a savepoint
1358: --
1359: savepoint ADD_RECIPIENT;

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

1433: -- Set all output arguments
1434: --
1435: p_object_version_number := l_object_version_number;
1436: p_communication_recipient_id := l_communication_recipient_id;
1437: hr_utility.set_location(' Leaving:'||l_proc, 70);
1438: --
1439: exception
1440: when hr_api.validate_enabled then
1441: --

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

1449: -- when validation only mode is being used.)
1450: --
1451: p_object_version_number := l_object_version_number;
1452: p_communication_recipient_id := l_communication_recipient_id;
1453: hr_utility.set_location(' Leaving:'||l_proc, 80);
1454: when others then
1455: --
1456: -- A validation or unexpected error has occured
1457: --

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

1458: rollback to ADD_RECIPIENT;
1459: --
1460: p_object_version_number := l_object_version_number;
1461: p_communication_recipient_id := l_communication_recipient_id;
1462: hr_utility.set_location(' Leaving:'||l_proc, 90);
1463: raise;
1464: --
1465: end add_recipient;
1466: --

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

2209: l_messageIdArray assoc_arr;
2210: l_listLength number;
2211: l_messageId number;
2212: begin
2213: hr_utility.set_location(' Entering:' || l_proc,10);
2214:
2215: --
2216: --Get assignmentId array
2217: --

Line 2236: hr_utility.set_location(' Exiting:' || l_proc,20);

2232: );
2233: end loop;
2234:
2235: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'commDummyMsgMap',X_pk1_value=>p_dummy_attachment_id,X_delete_document_flag=>'Y');
2236: hr_utility.set_location(' Exiting:' || l_proc,20);
2237: commit;
2238: end;
2239: --
2240: --

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

2277: where communication_topic_id = topic_id;
2278:
2279: begin
2280: --
2281: hr_utility.set_location(' Entering:' || l_proc,10);
2282: --
2283: select person_id into l_src_person_id from per_all_assignments_f paf
2284: where assignment_id = l_src_asgn_id and l_eff_date between paf.effective_start_date and paf.effective_end_date;
2285: --

Line 2299: hr_utility.set_location(' Create Communication: ' || l_proc,20);

2295: end if;
2296: --
2297: close csrGetCommForAsg;
2298: --
2299: hr_utility.set_location(' Create Communication: ' || l_proc,20);
2300: --
2301: irc_communications_api.create_communication
2302: (p_effective_date => l_eff_date
2303: ,p_communication_property_id => l_comm_rec.communication_property_id

Line 2315: hr_utility.set_location(' Create topic : ' || l_proc,30);

2311: --
2312: FOR commTopicRec IN csrGetCommTopics(l_comm_rec.communication_id)
2313: LOOP
2314: --
2315: hr_utility.set_location(' Create topic : ' || l_proc,30);
2316: --
2317: irc_communications_api.create_comm_topic
2318: (p_effective_date => l_eff_date
2319: ,p_communication_id => l_comm_id

Line 2329: hr_utility.set_location(' Create message : ' || l_proc,40);

2325: --
2326: For commMessageRec in csrGetCommMessage(commTopicRec.communication_topic_id)
2327: Loop
2328: --
2329: hr_utility.set_location(' Create message : ' || l_proc,40);
2330: --
2331: irc_communications_api.create_message
2332: (p_effective_date => l_eff_date
2333: ,p_communication_topic_id => l_comm_topic_id

Line 2358: hr_utility.set_location(' Create recipient : ' || l_proc,30);

2354: then
2355: l_dummy_person_id := l_trg_person_id;
2356: end if;
2357: --
2358: hr_utility.set_location(' Create recipient : ' || l_proc,30);
2359: --
2360: irc_communications_api.add_recipient
2361: (p_effective_date => l_eff_date
2362: ,p_communication_object_type => commRecpRec.communication_object_type

Line 2379: hr_utility.set_location(' Error : '||sqlErrm || l_proc,30);

2375: END LOOP;
2376: --
2377: exception
2378: when others then
2379: hr_utility.set_location(' Error : '||sqlErrm || l_proc,30);
2380: end copy_comm_to_apl_asg;
2381: end IRC_COMMUNICATIONS_API;