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.RRS_ATTR_PANE dependencies on DBMS_UTILITY

Line 57: Record_Error('Get_Primary_Attributes: ' || dbms_utility.format_error_backtrace, x_error_messages);

53: EXCEPTION
54: WHEN NO_DATA_FOUND THEN
55: Record_Error('No primary attributes were found for ' || p_object_type || ' ' || p_object_id || '.', x_error_messages);
56: WHEN OTHERS THEN
57: Record_Error('Get_Primary_Attributes: ' || dbms_utility.format_error_backtrace, x_error_messages);
58:
59: END;
60:
61: ELSIF UPPER(p_object_type) = 'LOCATION' THEN

Line 85: Record_Error('Get_Primary_Attributes: ' || dbms_utility.format_error_backtrace, x_error_messages);

81: EXCEPTION
82: WHEN NO_DATA_FOUND THEN
83: Record_Error('No primary attributes were found for ' || p_object_type || ' ' || p_object_id || '.', x_error_messages);
84: WHEN OTHERS THEN
85: Record_Error('Get_Primary_Attributes: ' || dbms_utility.format_error_backtrace, x_error_messages);
86:
87: END;
88:
89: ELSIF UPPER(p_object_type) = 'NODE' THEN

Line 117: Record_Error('Get_Primary_Attributes: ' || dbms_utility.format_error_backtrace, x_error_messages);

113: EXCEPTION
114: WHEN NO_DATA_FOUND THEN
115: Record_Error('No primary attributes were found for ' || p_object_type || ' ' || p_object_id || '.', x_error_messages);
116: WHEN OTHERS THEN
117: Record_Error('Get_Primary_Attributes: ' || dbms_utility.format_error_backtrace, x_error_messages);
118: END;
119:
120: /*ELSIF UPPER(p_object_type) = 'TRADE AREA' THEN
121: SELECT RRS_PRIMARY_ATTRIBUTE_REC(

Line 175: Record_Error('Get_Primary_Attributes: ' || dbms_utility.format_error_backtrace, x_error_messages);

171: EXCEPTION
172: WHEN NO_DATA_FOUND THEN
173: Record_Error('No primary attributes were found for ' || p_object_type || ' ' || p_object_id || '.', x_error_messages);
174: WHEN OTHERS THEN
175: Record_Error('Get_Primary_Attributes: ' || dbms_utility.format_error_backtrace, x_error_messages);
176:
177: END;
178: END IF;
179:

Line 184: Record_Error('Get_Primary_Attributes: ' || dbms_utility.format_error_backtrace, x_error_messages);

180: EXCEPTION
181: WHEN NO_DATA_FOUND THEN
182: Record_Error('No primary attributes were found for ' || p_object_type || ' ' || p_object_id || '.', x_error_messages);
183: WHEN OTHERS THEN
184: Record_Error('Get_Primary_Attributes: ' || dbms_utility.format_error_backtrace, x_error_messages);
185: END;
186:
187:
188: PROCEDURE Get_Attribute_Page

Line 582: Record_Error('Get_Attribute_Group_Page: ' || dbms_utility.format_error_backtrace, x_error_messages);

578: Record_Error('e_no_ext_row_found', x_error_messages);
579: WHEN e_no_attribute_found THEN
580: Record_Error('e_no_attribute_found', x_error_messages);
581: WHEN OTHERS THEN
582: Record_Error('Get_Attribute_Group_Page: ' || dbms_utility.format_error_backtrace, x_error_messages);
583: --DBMS_OUTPUT.PUT_LINE('Other exceptions in Get_Attribute_Page');
584: --dbms_output.put_line(dbms_utility.format_error_backtrace);
585: END;
586:

Line 584: --dbms_output.put_line(dbms_utility.format_error_backtrace);

580: Record_Error('e_no_attribute_found', x_error_messages);
581: WHEN OTHERS THEN
582: Record_Error('Get_Attribute_Group_Page: ' || dbms_utility.format_error_backtrace, x_error_messages);
583: --DBMS_OUTPUT.PUT_LINE('Other exceptions in Get_Attribute_Page');
584: --dbms_output.put_line(dbms_utility.format_error_backtrace);
585: END;
586:
587:
588: PROCEDURE Get_Display_Value

Line 900: Record_Error('Get_Display_Value: ' || dbms_utility.format_error_backtrace, x_error_messages);

896: EXCEPTION
897: WHEN NO_DATA_FOUND THEN
898: RAISE e_no_value_set_value_found;
899: WHEN OTHERS THEN
900: Record_Error('Get_Display_Value: ' || dbms_utility.format_error_backtrace, x_error_messages);
901: END;
902: /*For the table value set, we assemble the query to get the value from the target table*/
903: ELSIF l_attr_info.validation_code = 'F' THEN
904: SELECT APPLICATION_TABLE_NAME, VALUE_COLUMN_NAME,

Line 1093: Record_Error('Get_Display_Value: ' || dbms_utility.format_error_backtrace, x_error_messages);

1089: EXCEPTION
1090: WHEN e_invalid_where_clause THEN
1091: Record_Error('Invalid WHERE Clause defined in Dependent Value Set.', x_error_messages);
1092: WHEN OTHERS THEN
1093: Record_Error('Get_Display_Value: ' || dbms_utility.format_error_backtrace, x_error_messages);
1094: END;
1095:
1096: /*For the DATE or DATETIME data types, the value stored in EXT table is the same as the value in value set meaning column*/
1097: /*What we need to do is to format the date value into the right format for the environment the user is in*/

Line 1144: Record_Error('Get_Display_Value: ' || dbms_utility.format_error_backtrace, x_error_messages);

1140: Record_Error('e_no_uom_found', x_error_messages);
1141: WHEN e_no_value_set_value_found THEN
1142: Record_Error('e_no_value_set_value_found', x_error_messages);
1143: WHEN OTHERS THEN
1144: Record_Error('Get_Display_Value: ' || dbms_utility.format_error_backtrace, x_error_messages);
1145: END;
1146:
1147:
1148: Procedure Get_Display_Value

Line 1219: x_msg_data := 'Get_Display_Value: Unexcepted Error - ' || dbms_utility.format_error_backtrace;

1215: x_msg_data := 'Get_Display_Value: No data found with ' ||
1216: p_object_type || ', ' || p_object_id || ', ' || p_attr_group_id || ', ' ||
1217: p_ext_id || ', ' || p_column_name || '.';
1218: WHEN OTHERS THEN
1219: x_msg_data := 'Get_Display_Value: Unexcepted Error - ' || dbms_utility.format_error_backtrace;
1220: END Get_Display_Value;
1221:
1222:
1223: --Added for Bug Fix 6969229

Line 1300: x_msg_data := 'Get_Disp_Value_Without_UOM: Unexcepted Error - ' || dbms_utility.format_error_backtrace;

1296: x_msg_data := 'Get_Disp_Value_Without_UOM: No data found with ' ||
1297: p_object_type || ', ' || p_object_id || ', ' || p_attr_group_id || ', ' ||
1298: p_ext_id || ', ' || p_column_name || '.';
1299: WHEN OTHERS THEN
1300: x_msg_data := 'Get_Disp_Value_Without_UOM: Unexcepted Error - ' || dbms_utility.format_error_backtrace;
1301: END Get_Disp_Value_Without_UOM;
1302:
1303:
1304: -- Bug Fix 9709269: Convert Server Timezone to Client Timezone. Oracle only does Timezone conversion for DateTime type