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.AR_BPA_SHUTTLE_PKG dependencies on AR_BPA_UTILS_PKG

Line 98: ar_bpa_utils_pkg.debug ('ar_bpa_shuttle_pkg.update_item_map_array(+)' );

94: l_translate_flag varchar2(1) := 'N';
95: found boolean := false;
96: begin
97:
98: ar_bpa_utils_pkg.debug ('ar_bpa_shuttle_pkg.update_item_map_array(+)' );
99: ar_bpa_utils_pkg.debug ('----Program Input-----');
100: ar_bpa_utils_pkg.debug ('---- p_dml_operation : '||p_dml_operation);
101: ar_bpa_utils_pkg.debug ('---- p_template_id : '||to_char(p_template_id));
102: ar_bpa_utils_pkg.debug ('---- p_area_code : '||p_area_code);

Line 99: ar_bpa_utils_pkg.debug ('----Program Input-----');

95: found boolean := false;
96: begin
97:
98: ar_bpa_utils_pkg.debug ('ar_bpa_shuttle_pkg.update_item_map_array(+)' );
99: ar_bpa_utils_pkg.debug ('----Program Input-----');
100: ar_bpa_utils_pkg.debug ('---- p_dml_operation : '||p_dml_operation);
101: ar_bpa_utils_pkg.debug ('---- p_template_id : '||to_char(p_template_id));
102: ar_bpa_utils_pkg.debug ('---- p_area_code : '||p_area_code);
103: ar_bpa_utils_pkg.debug ('---- p_new_parent_code : '||p_new_parent_area_code);

Line 100: ar_bpa_utils_pkg.debug ('---- p_dml_operation : '||p_dml_operation);

96: begin
97:
98: ar_bpa_utils_pkg.debug ('ar_bpa_shuttle_pkg.update_item_map_array(+)' );
99: ar_bpa_utils_pkg.debug ('----Program Input-----');
100: ar_bpa_utils_pkg.debug ('---- p_dml_operation : '||p_dml_operation);
101: ar_bpa_utils_pkg.debug ('---- p_template_id : '||to_char(p_template_id));
102: ar_bpa_utils_pkg.debug ('---- p_area_code : '||p_area_code);
103: ar_bpa_utils_pkg.debug ('---- p_new_parent_code : '||p_new_parent_area_code);
104: ar_bpa_utils_pkg.debug ('---- p_secondary_app_id (not used): '||to_char(p_secondary_app_id));

Line 101: ar_bpa_utils_pkg.debug ('---- p_template_id : '||to_char(p_template_id));

97:
98: ar_bpa_utils_pkg.debug ('ar_bpa_shuttle_pkg.update_item_map_array(+)' );
99: ar_bpa_utils_pkg.debug ('----Program Input-----');
100: ar_bpa_utils_pkg.debug ('---- p_dml_operation : '||p_dml_operation);
101: ar_bpa_utils_pkg.debug ('---- p_template_id : '||to_char(p_template_id));
102: ar_bpa_utils_pkg.debug ('---- p_area_code : '||p_area_code);
103: ar_bpa_utils_pkg.debug ('---- p_new_parent_code : '||p_new_parent_area_code);
104: ar_bpa_utils_pkg.debug ('---- p_secondary_app_id (not used): '||to_char(p_secondary_app_id));
105: ar_bpa_utils_pkg.debug ('---- p_display_level : '||p_display_level);

Line 102: ar_bpa_utils_pkg.debug ('---- p_area_code : '||p_area_code);

98: ar_bpa_utils_pkg.debug ('ar_bpa_shuttle_pkg.update_item_map_array(+)' );
99: ar_bpa_utils_pkg.debug ('----Program Input-----');
100: ar_bpa_utils_pkg.debug ('---- p_dml_operation : '||p_dml_operation);
101: ar_bpa_utils_pkg.debug ('---- p_template_id : '||to_char(p_template_id));
102: ar_bpa_utils_pkg.debug ('---- p_area_code : '||p_area_code);
103: ar_bpa_utils_pkg.debug ('---- p_new_parent_code : '||p_new_parent_area_code);
104: ar_bpa_utils_pkg.debug ('---- p_secondary_app_id (not used): '||to_char(p_secondary_app_id));
105: ar_bpa_utils_pkg.debug ('---- p_display_level : '||p_display_level);
106: ar_bpa_utils_pkg.debug ('---- p_display_sequence: '||to_char(p_display_sequence));

Line 103: ar_bpa_utils_pkg.debug ('---- p_new_parent_code : '||p_new_parent_area_code);

99: ar_bpa_utils_pkg.debug ('----Program Input-----');
100: ar_bpa_utils_pkg.debug ('---- p_dml_operation : '||p_dml_operation);
101: ar_bpa_utils_pkg.debug ('---- p_template_id : '||to_char(p_template_id));
102: ar_bpa_utils_pkg.debug ('---- p_area_code : '||p_area_code);
103: ar_bpa_utils_pkg.debug ('---- p_new_parent_code : '||p_new_parent_area_code);
104: ar_bpa_utils_pkg.debug ('---- p_secondary_app_id (not used): '||to_char(p_secondary_app_id));
105: ar_bpa_utils_pkg.debug ('---- p_display_level : '||p_display_level);
106: ar_bpa_utils_pkg.debug ('---- p_display_sequence: '||to_char(p_display_sequence));
107: ar_bpa_utils_pkg.debug ('----------------------------------------------------------------');

Line 104: ar_bpa_utils_pkg.debug ('---- p_secondary_app_id (not used): '||to_char(p_secondary_app_id));

100: ar_bpa_utils_pkg.debug ('---- p_dml_operation : '||p_dml_operation);
101: ar_bpa_utils_pkg.debug ('---- p_template_id : '||to_char(p_template_id));
102: ar_bpa_utils_pkg.debug ('---- p_area_code : '||p_area_code);
103: ar_bpa_utils_pkg.debug ('---- p_new_parent_code : '||p_new_parent_area_code);
104: ar_bpa_utils_pkg.debug ('---- p_secondary_app_id (not used): '||to_char(p_secondary_app_id));
105: ar_bpa_utils_pkg.debug ('---- p_display_level : '||p_display_level);
106: ar_bpa_utils_pkg.debug ('---- p_display_sequence: '||to_char(p_display_sequence));
107: ar_bpa_utils_pkg.debug ('----------------------------------------------------------------');
108:

Line 105: ar_bpa_utils_pkg.debug ('---- p_display_level : '||p_display_level);

101: ar_bpa_utils_pkg.debug ('---- p_template_id : '||to_char(p_template_id));
102: ar_bpa_utils_pkg.debug ('---- p_area_code : '||p_area_code);
103: ar_bpa_utils_pkg.debug ('---- p_new_parent_code : '||p_new_parent_area_code);
104: ar_bpa_utils_pkg.debug ('---- p_secondary_app_id (not used): '||to_char(p_secondary_app_id));
105: ar_bpa_utils_pkg.debug ('---- p_display_level : '||p_display_level);
106: ar_bpa_utils_pkg.debug ('---- p_display_sequence: '||to_char(p_display_sequence));
107: ar_bpa_utils_pkg.debug ('----------------------------------------------------------------');
108:
109: FOR i IN 1..p_item_id_list.count

Line 106: ar_bpa_utils_pkg.debug ('---- p_display_sequence: '||to_char(p_display_sequence));

102: ar_bpa_utils_pkg.debug ('---- p_area_code : '||p_area_code);
103: ar_bpa_utils_pkg.debug ('---- p_new_parent_code : '||p_new_parent_area_code);
104: ar_bpa_utils_pkg.debug ('---- p_secondary_app_id (not used): '||to_char(p_secondary_app_id));
105: ar_bpa_utils_pkg.debug ('---- p_display_level : '||p_display_level);
106: ar_bpa_utils_pkg.debug ('---- p_display_sequence: '||to_char(p_display_sequence));
107: ar_bpa_utils_pkg.debug ('----------------------------------------------------------------');
108:
109: FOR i IN 1..p_item_id_list.count
110: LOOP

Line 107: ar_bpa_utils_pkg.debug ('----------------------------------------------------------------');

103: ar_bpa_utils_pkg.debug ('---- p_new_parent_code : '||p_new_parent_area_code);
104: ar_bpa_utils_pkg.debug ('---- p_secondary_app_id (not used): '||to_char(p_secondary_app_id));
105: ar_bpa_utils_pkg.debug ('---- p_display_level : '||p_display_level);
106: ar_bpa_utils_pkg.debug ('---- p_display_sequence: '||to_char(p_display_sequence));
107: ar_bpa_utils_pkg.debug ('----------------------------------------------------------------');
108:
109: FOR i IN 1..p_item_id_list.count
110: LOOP
111: ar_bpa_utils_pkg.debug ('Input item list: i= '||to_char(i)||', item id = '||p_item_id_list(i));

Line 111: ar_bpa_utils_pkg.debug ('Input item list: i= '||to_char(i)||', item id = '||p_item_id_list(i));

107: ar_bpa_utils_pkg.debug ('----------------------------------------------------------------');
108:
109: FOR i IN 1..p_item_id_list.count
110: LOOP
111: ar_bpa_utils_pkg.debug ('Input item list: i= '||to_char(i)||', item id = '||p_item_id_list(i));
112: end loop;
113:
114:
115: IF (p_dml_operation = 'UPDATE') THEN

Line 183: ar_bpa_utils_pkg.debug ('i= '||to_char(i)||', item id = '||p_item_id_list(i)||' Inserted.');

179: sysdate,
180: l_user_id
181: from ar_bpa_items_b item
182: where item.item_id = to_number(p_item_id_list(i));
183: ar_bpa_utils_pkg.debug ('i= '||to_char(i)||', item id = '||p_item_id_list(i)||' Inserted.');
184: else
185: ar_bpa_utils_pkg.debug ('i= '||to_char(i)||', item id = '||p_item_id_list(i)||' Updated.');
186: end if;
187: END LOOP; -- p_item_id_list

Line 185: ar_bpa_utils_pkg.debug ('i= '||to_char(i)||', item id = '||p_item_id_list(i)||' Updated.');

181: from ar_bpa_items_b item
182: where item.item_id = to_number(p_item_id_list(i));
183: ar_bpa_utils_pkg.debug ('i= '||to_char(i)||', item id = '||p_item_id_list(i)||' Inserted.');
184: else
185: ar_bpa_utils_pkg.debug ('i= '||to_char(i)||', item id = '||p_item_id_list(i)||' Updated.');
186: end if;
187: END LOOP; -- p_item_id_list
188: END IF;
189:

Line 197: ar_bpa_utils_pkg.debug ('i= '||to_char(i)||', item id = '||p_item_id_list(i)||' Deleted.');

193: DELETE FROM AR_BPA_AREA_ITEMS
194: where TEMPLATE_ID = P_TEMPLATE_ID
195: and PARENT_AREA_CODE = P_AREA_CODE
196: AND ITEM_ID = to_number(p_item_id_list(i));
197: ar_bpa_utils_pkg.debug ('i= '||to_char(i)||', item id = '||p_item_id_list(i)||' Deleted.');
198: END LOOP;
199: END IF; -- delete
200:
201: x_status := 0;

Line 205: ar_bpa_utils_pkg.debug ('update_item_map_array EXCEPTION: sqlerrm=['||sqlerrm||']');

201: x_status := 0;
202: EXCEPTION
203: WHEN OTHERS THEN
204: x_status := -1;
205: ar_bpa_utils_pkg.debug ('update_item_map_array EXCEPTION: sqlerrm=['||sqlerrm||']');
206: end UPDATE_ITEM_MAP_ARRAY;
207:
208: end AR_BPA_SHUTTLE_PKG;