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.ZX_TEST_API dependencies on HR_LOCATIONS

Line 1028: -- the LOV used is HR_LOCATIONS for P2P

1024:
1025:
1026: ------------------------------------------------------
1027: -- Gets user key for SHIP_TO_LOCATION_ID
1028: -- the LOV used is HR_LOCATIONS for P2P
1029: -- the LOV used is HZ_LOCATIONS for O2C
1030: -- and the segments in user key string are:
1031: -- Segment 1 is LOCATION_CODE
1032: -- Segment 2 is BUSINESS_GROUP_ID

Line 1042: write_message('~ Table to get Ship to Location is HR_LOCATIONS');

1038: -- Retrieves the SHIP_TO_LOCATION_ID
1039: -----------------------------------------
1040: write_message('~ The flow to Calculate Ship to Location is:'||l_flow);
1041: IF l_flow = 'P2P' THEN
1042: write_message('~ Table to get Ship to Location is HR_LOCATIONS');
1043: break_user_key_into_segments(p_user_key_string,
1044: l_separator,
1045: l_number_of_segments,
1046: l_user_key_segments_tbl);

Line 1052: -- P2P Retrieve SHIP_TO_LOCATION_ID from HR_LOCATIONS

1048: If nvl(l_number_of_segments,1) > 1 then
1049: l_num_id := to_number(l_user_key_segments_tbl(2));
1050: End If;
1051: -------------------------------------------------------
1052: -- P2P Retrieve SHIP_TO_LOCATION_ID from HR_LOCATIONS
1053: -------------------------------------------------------
1054: BEGIN
1055: IF l_num_id is not null THEN
1056: select ship_to_location_id

Line 1058: from hr_locations

1054: BEGIN
1055: IF l_num_id is not null THEN
1056: select ship_to_location_id
1057: into x_user_key_id
1058: from hr_locations
1059: where location_code = l_varchar2_id
1060: and business_group_id = l_num_id;
1061: ELSE
1062: select ship_to_location_id

Line 1064: from hr_locations

1060: and business_group_id = l_num_id;
1061: ELSE
1062: select ship_to_location_id
1063: into x_user_key_id
1064: from hr_locations
1065: where location_code = l_varchar2_id
1066: and business_group_id is null;
1067: END IF;
1068: EXCEPTION

Line 1184: -- the LOV used is HR_LOCATIONS_LOV

1180: -- BILL_TO_LOCATION_ID
1181: -- BILL_FROM__LOCATION_ID
1182: -- PAYING_LOCATION_ID
1183: -- POI_LOCATION_ID
1184: -- the LOV used is HR_LOCATIONS_LOV
1185: -- and the segments in user key string are:
1186: -- Segment 1 is LOCATION_CODE
1187: -- Segment 2 is BUSINESS_GROUP_ID
1188: ------------------------------------------------------

Line 1211: from hr_locations

1207: BEGIN
1208: IF l_num_id is not null THEN
1209: select location_id
1210: into x_user_key_id
1211: from hr_locations
1212: where location_code = l_varchar2_id
1213: and business_group_id = l_num_id;
1214: ELSE
1215: select location_id

Line 1217: from hr_locations

1213: and business_group_id = l_num_id;
1214: ELSE
1215: select location_id
1216: into x_user_key_id
1217: from hr_locations
1218: where location_code = l_varchar2_id
1219: and business_group_id is null;
1220: END IF;
1221:

Line 1226: NO_DATA_FOUND Error: To derive '||p_user_key_type||' the Location Code or Location Code and Business Group from HR_LOCATIONS is required.

1222: EXCEPTION
1223: WHEN NO_DATA_FOUND THEN
1224:
1225: RAISE_APPLICATION_ERROR (-20000,'
1226: NO_DATA_FOUND Error: To derive '||p_user_key_type||' the Location Code or Location Code and Business Group from HR_LOCATIONS is required.
1227: The user Key that has been passed is:'||p_user_key_string||'
1228: Please review that value passed is the format LOCATION_CODE or LOCATION_CODE:BUSINESS_GROUP_ID and
1229: this value exists in table HR_LOCATIONS.
1230: Review your datafile *.dat, your Spreadsheet and MASTER_SETUP.xls files. The sqlerrm found is

Line 1229: this value exists in table HR_LOCATIONS.

1225: RAISE_APPLICATION_ERROR (-20000,'
1226: NO_DATA_FOUND Error: To derive '||p_user_key_type||' the Location Code or Location Code and Business Group from HR_LOCATIONS is required.
1227: The user Key that has been passed is:'||p_user_key_string||'
1228: Please review that value passed is the format LOCATION_CODE or LOCATION_CODE:BUSINESS_GROUP_ID and
1229: this value exists in table HR_LOCATIONS.
1230: Review your datafile *.dat, your Spreadsheet and MASTER_SETUP.xls files. The sqlerrm found is
1231: '||sqlerrm);
1232:
1233:

Line 1237: OTHERS Error: To derive '||p_user_key_type||' the Location Code or Location Code and Business Group from HR_LOCATIONS is required.

1233:
1234:
1235: WHEN OTHERS THEN
1236: RAISE_APPLICATION_ERROR (-20000,'
1237: OTHERS Error: To derive '||p_user_key_type||' the Location Code or Location Code and Business Group from HR_LOCATIONS is required.
1238: The user Key that has been passed is:'||p_user_key_string||'
1239: Please review that value passed is the format LOCATION_CODE or LOCATION_CODE:BUSINESS_GROUP_ID and
1240: this value exists in table HR_LOCATIONS.
1241: Review your datafile *.dat, your Spreadsheet and MASTER_SETUP.xls files. The sqlerrm found is

Line 1240: this value exists in table HR_LOCATIONS.

1236: RAISE_APPLICATION_ERROR (-20000,'
1237: OTHERS Error: To derive '||p_user_key_type||' the Location Code or Location Code and Business Group from HR_LOCATIONS is required.
1238: The user Key that has been passed is:'||p_user_key_string||'
1239: Please review that value passed is the format LOCATION_CODE or LOCATION_CODE:BUSINESS_GROUP_ID and
1240: this value exists in table HR_LOCATIONS.
1241: Review your datafile *.dat, your Spreadsheet and MASTER_SETUP.xls files. The sqlerrm found is
1242: '||sqlerrm);
1243:
1244: