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

Line 23: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

19: l_proc_name CONSTANT varchar2(150):= g_package ||'Get_PK_For_Validation';
20:
21: BEGIN
22:
23: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
24:
25: SQLstmt:=' SELECT rowid
26: FROM igs_pe_visit_histry
27: WHERE port_of_entry = :1

Line 41: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);

37: CLOSE cur_rowid;
38: RETURN(FALSE);
39: END IF;
40:
41: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);
42:
43: END Get_PK_For_Validation;
44:
45: -- =============================================================================

Line 248: Hr_Utility.set_location(' Entering:' || l_proc,5);

244: -- Variables for IN/OUT parameters
245: --
246: l_proc CONSTANT Varchar2(150) := g_package ||'Create_OSS_Person';
247: BEGIN
248: Hr_Utility.set_location(' Entering:' || l_proc,5);
249: --
250: -- Issue a savepoint
251: --
252: SAVEPOINT Create_OSS_Person_swi;

Line 468: Hr_Utility.set_location(' Leaving:' || l_proc,50);

464: -- messages of any type exist in the Multiple Message List.
465: -- Also disable Multiple Message Detection.
466: --
467: p_return_status := Hr_Multi_Message.get_return_status_disable;
468: Hr_Utility.set_location(' Leaving:' || l_proc,50);
469: --
470: EXCEPTION
471: WHEN Hr_Multi_Message.error_message_exist THEN
472: --

Line 482: Hr_Utility.set_location(' Leaving:' || l_proc, 70);

478: --
479: -- Reset IN OUT parameters and set OUT parameters
480: --
481: p_return_status := Hr_Multi_Message.get_return_status_disable;
482: Hr_Utility.set_location(' Leaving:' || l_proc, 70);
483: WHEN Others THEN
484: --
485: -- When Multiple Message Detection is enabled catch
486: -- any Application specific or other unexpected

Line 493: Hr_Utility.set_location(' Leaving:' || l_proc,80);

489: -- error.
490: --
491: ROLLBACK TO Create_OSS_Person_swi;
492: IF Hr_Multi_Message.unexpected_error_add(l_proc) THEN
493: Hr_Utility.set_location(' Leaving:' || l_proc,80);
494:
495: END IF;
496: --
497: -- Reset IN OUT and set OUT parameters

Line 500: Hr_Utility.set_location(' Leaving:' || l_proc,90);

496: --
497: -- Reset IN OUT and set OUT parameters
498: --
499: p_return_status := Hr_Multi_Message.get_return_status_disable;
500: Hr_Utility.set_location(' Leaving:' || l_proc,90);
501:
502: END Create_OSS_Person;
503: -- =============================================================================
504: -- ~ Upd_OSS_Person_Asg:

Line 691: Hr_Utility.set_location(' Entering:' || l_proc,5);

687: --
688: l_proc CONSTANT Varchar2(150) := g_package ||'Upd_OSS_Person_Asg';
689: l_FICA_exempt Varchar2(15);
690: BEGIN
691: Hr_Utility.set_location(' Entering:' || l_proc,5);
692: --
693: -- Issue a savepoint
694: --
695: SAVEPOINT Upd_OSS_Person_Asg_SWI;

Line 900: Hr_Utility.set_location(' Leaving:' || l_proc,50);

896: -- messages of any type exist in the Multiple Message List.
897: -- Also disable Multiple Message Detection.
898: --
899: p_return_status := Hr_Multi_Message.get_return_status_disable;
900: Hr_Utility.set_location(' Leaving:' || l_proc,50);
901: --
902: EXCEPTION
903: WHEN Hr_Multi_Message.error_message_exist THEN
904: --

Line 914: Hr_Utility.set_location(' Leaving:' || l_proc, 70);

910: --
911: -- Reset IN OUT parameters and set OUT parameters
912: --
913: p_return_status := Hr_Multi_Message.get_return_status_disable;
914: Hr_Utility.set_location(' Leaving:' || l_proc, 70);
915: WHEN Others THEN
916: --
917: -- When Multiple Message Detection is enabled catch
918: -- any Application specific or other unexpected

Line 925: Hr_Utility.set_location(' Leaving:' || l_proc,80);

921: -- error.
922: --
923: ROLLBACK TO Upd_OSS_Person_Asg_SWI;
924: IF Hr_Multi_Message.unexpected_error_add(l_proc) THEN
925: Hr_Utility.set_location(' Leaving:' || l_proc,80);
926: END IF;
927: --
928: -- Reset IN OUT and set OUT parameters
929: --

Line 931: Hr_Utility.set_location(' Leaving:' || l_proc,90);

927: --
928: -- Reset IN OUT and set OUT parameters
929: --
930: p_return_status := Hr_Multi_Message.get_return_status_disable;
931: Hr_Utility.set_location(' Leaving:' || l_proc,90);
932:
933: END Upd_OSS_Person_Asg;
934:
935: -- =============================================================================

Line 1007: Hr_Utility.set_location(' Entering:' || l_proc,5);

1003: l_proc CONSTANT Varchar2(150) := g_package ||'InsUpd_Assig_Extra_Info';
1004: l_extra_info_rec per_assignment_extra_info%ROWTYPE;
1005: l_validate Boolean;
1006: BEGIN
1007: Hr_Utility.set_location(' Entering:' || l_proc,5);
1008: --
1009: -- Issue a savepoint
1010: --
1011: SAVEPOINT Extra_Info;

Line 1098: Hr_Utility.set_location(' Leaving:' || l_proc,50);

1094: p_assignment_extra_info_id := l_extra_info_rec.assignment_extra_info_id;
1095: p_object_version_number := l_extra_info_rec.object_version_number;
1096:
1097: p_return_status := Hr_Multi_Message.get_return_status_disable;
1098: Hr_Utility.set_location(' Leaving:' || l_proc,50);
1099: --
1100: EXCEPTION
1101: WHEN Hr_Multi_Message.error_message_exist THEN
1102: -- Catch the Multiple Message List exception which

Line 1114: Hr_Utility.set_location(' Leaving:' || l_proc, 70);

1110: p_return_status := Hr_Multi_Message.get_return_status_disable;
1111: p_assignment_extra_info_id := Null;
1112: p_object_version_number := Null;
1113:
1114: Hr_Utility.set_location(' Leaving:' || l_proc, 70);
1115: WHEN Others THEN
1116: -- When Multiple Message Detection is enabled catch
1117: -- any Application specific or other unexpected
1118: -- exceptions. Adding appropriate details to the

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

1120: -- error.
1121: --
1122: ROLLBACK TO Extra_Info;
1123: IF Hr_Multi_Message.unexpected_error_add(l_proc) THEN
1124: Hr_Utility.set_location(' Leaving:' || l_proc,80);
1125: END IF;
1126: --
1127: -- Reset IN OUT and set OUT parameters
1128: --

Line 1133: Hr_Utility.set_location(' Leaving:' || l_proc,90);

1129: p_return_status := Hr_Multi_Message.get_return_status_disable;
1130: p_assignment_extra_info_id := Null;
1131: p_object_version_number := Null;
1132:
1133: Hr_Utility.set_location(' Leaving:' || l_proc,90);
1134:
1135: END InsUpd_Assig_Extra_Info;
1136: -- =============================================================================
1137: -- ~ InsUpd_Person_Extra_Info:

Line 1220: Hr_Utility.set_location(' Entering:' || l_proc,5);

1216: l_error_msg varchar2(2000);
1217: l_msg_data varchar2(4000);
1218: l_validate Boolean;
1219: BEGIN
1220: Hr_Utility.set_location(' Entering:' || l_proc,5);
1221: --
1222: -- Issue a savepoint
1223: --
1224: SAVEPOINT Extra_Info;

Line 1229: Hr_Utility.set_location(' set the person id profile:' || p_person_id,7);

1225: l_validate := FALSE;
1226: IF NVL(p_validate,0) <> 0 THEN
1227: l_validate := TRUE;
1228: END IF;
1229: Hr_Utility.set_location(' set the person id profile:' || p_person_id,7);
1230: Fnd_Profile.put('PER_PERSON_ID',p_person_id);
1231: --
1232: -- Initialise Multiple Message Detection
1233: --

Line 1361: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

1357: END IF;
1358: -- Check if any errors are raised.
1359: IF l_msg_data Is Not Null Then
1360: l_error_msg := Substrb(l_msg_data,1,2000);
1361: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1362: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1363: Hr_Utility.raise_error;
1364: END IF;
1365:

Line 1362: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );

1358: -- Check if any errors are raised.
1359: IF l_msg_data Is Not Null Then
1360: l_error_msg := Substrb(l_msg_data,1,2000);
1361: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1362: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1363: Hr_Utility.raise_error;
1364: END IF;
1365:
1366: PQP_HRTCA_Integration.InsUpd_Per_Extra_info

Line 1363: Hr_Utility.raise_error;

1359: IF l_msg_data Is Not Null Then
1360: l_error_msg := Substrb(l_msg_data,1,2000);
1361: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1362: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1363: Hr_Utility.raise_error;
1364: END IF;
1365:
1366: PQP_HRTCA_Integration.InsUpd_Per_Extra_info
1367: (p_person_id => p_person_id

Line 1377: Hr_Utility.set_location(' Leaving:' || l_proc,50);

1373: p_person_extra_info_id := l_extra_info_rec.person_extra_info_id;
1374: p_object_version_number := l_extra_info_rec.object_version_number;
1375:
1376: p_return_status := Hr_Multi_Message.get_return_status_disable;
1377: Hr_Utility.set_location(' Leaving:' || l_proc,50);
1378: --
1379: EXCEPTION
1380: WHEN Hr_Multi_Message.error_message_exist THEN
1381: --

Line 1394: Hr_Utility.set_location(' Leaving:' || l_proc, 70);

1390: p_return_status := Hr_Multi_Message.get_return_status_disable;
1391: p_person_extra_info_id := Null;
1392: p_object_version_number := Null;
1393:
1394: Hr_Utility.set_location(' Leaving:' || l_proc, 70);
1395: WHEN Others THEN
1396: --
1397: -- When Multiple Message Detection is enabled catch
1398: -- any Application specific or other unexpected

Line 1405: Hr_Utility.set_location(' Leaving:' || l_proc,80);

1401: -- error.
1402: --
1403: ROLLBACK TO Extra_Info;
1404: IF Hr_Multi_Message.unexpected_error_add(l_proc) THEN
1405: Hr_Utility.set_location(' Leaving:' || l_proc,80);
1406: END IF;
1407: --
1408: -- Reset IN OUT and set OUT parameters
1409: --

Line 1414: Hr_Utility.set_location(' Leaving:' || l_proc,90);

1410: p_return_status := Hr_Multi_Message.get_return_status_disable;
1411: p_person_extra_info_id := Null;
1412: p_object_version_number := Null;
1413:
1414: Hr_Utility.set_location(' Leaving:' || l_proc,90);
1415:
1416: END InsUpd_Person_Extra_Info;
1417: -- =============================================================================
1418: -- ~ InsUpd_SIT_Info:

Line 1500: Hr_Utility.set_location(' Entering:' || l_proc,5);

1496: l_analysis_criteria_rec per_analysis_criteria%ROWTYPE;
1497: l_analyses_rec per_person_analyses%ROWTYPE;
1498: l_validate Boolean;
1499: BEGIN
1500: Hr_Utility.set_location(' Entering:' || l_proc,5);
1501: --
1502: -- Issue a savepoint
1503: --
1504: SAVEPOINT Extra_Info;

Line 1599: Hr_Utility.set_location(' Leaving:' || l_proc,50);

1595: p_pea_object_version_Number := l_analyses_rec.object_version_Number;
1596:
1597:
1598: p_return_status := Hr_Multi_Message.get_return_status_disable;
1599: Hr_Utility.set_location(' Leaving:' || l_proc,50);
1600: --
1601: EXCEPTION
1602: WHEN Hr_Multi_Message.error_message_exist THEN
1603: --

Line 1618: Hr_Utility.set_location(' Leaving:' || l_proc, 70);

1614: p_analysis_criteria_id := Null;
1615: p_person_analysis_id := Null;
1616: p_pea_object_version_Number := Null;
1617:
1618: Hr_Utility.set_location(' Leaving:' || l_proc, 70);
1619: WHEN Others THEN
1620: --
1621: -- When Multiple Message Detection is enabled catch
1622: -- any Application specific or other unexpected

Line 1629: Hr_Utility.set_location(' Leaving:' || l_proc,80);

1625: -- error.
1626: --
1627: ROLLBACK TO Extra_Info;
1628: IF Hr_Multi_Message.unexpected_error_add(l_proc) THEN
1629: Hr_Utility.set_location(' Leaving:' || l_proc,80);
1630: END IF;
1631: --
1632: -- Reset IN OUT and set OUT parameters
1633: --

Line 1638: Hr_Utility.set_location(' Leaving:' || l_proc,90);

1634: p_return_status := Hr_Multi_Message.get_return_status_disable;
1635: p_analysis_criteria_id := Null;
1636: p_person_analysis_id := Null;
1637: p_pea_object_version_Number := Null;
1638: Hr_Utility.set_location(' Leaving:' || l_proc,90);
1639:
1640: END InsUpd_SIT_Info;
1641:
1642: END PQP_HROSS_Integration_SWI;