[Home] [Help]
179:
180:
181: BEGIN
182: d_progress := 10;
183: PO_UDA_DEFAULTING_PKG.DEBUG('Starting PO_UDA_IMPORT_PKG.POPULATE_STRUCTURES with parameters' , d_progress);
184: PO_UDA_DEFAULTING_PKG.DEBUG('p_attr_grp_type : ' || p_attr_grp_type, d_progress);
185: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk1_value : ' || p_pk1_value, d_progress);
186: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk2_value : ' || p_pk2_value, d_progress);
187: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk3_value : ' || p_pk2_value, d_progress);
180:
181: BEGIN
182: d_progress := 10;
183: PO_UDA_DEFAULTING_PKG.DEBUG('Starting PO_UDA_IMPORT_PKG.POPULATE_STRUCTURES with parameters' , d_progress);
184: PO_UDA_DEFAULTING_PKG.DEBUG('p_attr_grp_type : ' || p_attr_grp_type, d_progress);
185: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk1_value : ' || p_pk1_value, d_progress);
186: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk2_value : ' || p_pk2_value, d_progress);
187: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk3_value : ' || p_pk2_value, d_progress);
188: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk4_value : ' || p_pk4_value, d_progress);
181: BEGIN
182: d_progress := 10;
183: PO_UDA_DEFAULTING_PKG.DEBUG('Starting PO_UDA_IMPORT_PKG.POPULATE_STRUCTURES with parameters' , d_progress);
184: PO_UDA_DEFAULTING_PKG.DEBUG('p_attr_grp_type : ' || p_attr_grp_type, d_progress);
185: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk1_value : ' || p_pk1_value, d_progress);
186: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk2_value : ' || p_pk2_value, d_progress);
187: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk3_value : ' || p_pk2_value, d_progress);
188: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk4_value : ' || p_pk4_value, d_progress);
189: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk5_value : ' || p_pk5_value, d_progress);
182: d_progress := 10;
183: PO_UDA_DEFAULTING_PKG.DEBUG('Starting PO_UDA_IMPORT_PKG.POPULATE_STRUCTURES with parameters' , d_progress);
184: PO_UDA_DEFAULTING_PKG.DEBUG('p_attr_grp_type : ' || p_attr_grp_type, d_progress);
185: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk1_value : ' || p_pk1_value, d_progress);
186: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk2_value : ' || p_pk2_value, d_progress);
187: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk3_value : ' || p_pk2_value, d_progress);
188: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk4_value : ' || p_pk4_value, d_progress);
189: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk5_value : ' || p_pk5_value, d_progress);
190: PO_UDA_DEFAULTING_PKG.DEBUG('x_base_object_name : ' || x_base_object_name, d_progress);
183: PO_UDA_DEFAULTING_PKG.DEBUG('Starting PO_UDA_IMPORT_PKG.POPULATE_STRUCTURES with parameters' , d_progress);
184: PO_UDA_DEFAULTING_PKG.DEBUG('p_attr_grp_type : ' || p_attr_grp_type, d_progress);
185: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk1_value : ' || p_pk1_value, d_progress);
186: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk2_value : ' || p_pk2_value, d_progress);
187: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk3_value : ' || p_pk2_value, d_progress);
188: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk4_value : ' || p_pk4_value, d_progress);
189: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk5_value : ' || p_pk5_value, d_progress);
190: PO_UDA_DEFAULTING_PKG.DEBUG('x_base_object_name : ' || x_base_object_name, d_progress);
191: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows :', d_progress);
184: PO_UDA_DEFAULTING_PKG.DEBUG('p_attr_grp_type : ' || p_attr_grp_type, d_progress);
185: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk1_value : ' || p_pk1_value, d_progress);
186: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk2_value : ' || p_pk2_value, d_progress);
187: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk3_value : ' || p_pk2_value, d_progress);
188: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk4_value : ' || p_pk4_value, d_progress);
189: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk5_value : ' || p_pk5_value, d_progress);
190: PO_UDA_DEFAULTING_PKG.DEBUG('x_base_object_name : ' || x_base_object_name, d_progress);
191: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows :', d_progress);
192: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
185: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk1_value : ' || p_pk1_value, d_progress);
186: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk2_value : ' || p_pk2_value, d_progress);
187: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk3_value : ' || p_pk2_value, d_progress);
188: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk4_value : ' || p_pk4_value, d_progress);
189: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk5_value : ' || p_pk5_value, d_progress);
190: PO_UDA_DEFAULTING_PKG.DEBUG('x_base_object_name : ' || x_base_object_name, d_progress);
191: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows :', d_progress);
192: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
193: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows :', d_progress);
186: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk2_value : ' || p_pk2_value, d_progress);
187: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk3_value : ' || p_pk2_value, d_progress);
188: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk4_value : ' || p_pk4_value, d_progress);
189: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk5_value : ' || p_pk5_value, d_progress);
190: PO_UDA_DEFAULTING_PKG.DEBUG('x_base_object_name : ' || x_base_object_name, d_progress);
191: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows :', d_progress);
192: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
193: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows :', d_progress);
194: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
187: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk3_value : ' || p_pk2_value, d_progress);
188: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk4_value : ' || p_pk4_value, d_progress);
189: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk5_value : ' || p_pk5_value, d_progress);
190: PO_UDA_DEFAULTING_PKG.DEBUG('x_base_object_name : ' || x_base_object_name, d_progress);
191: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows :', d_progress);
192: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
193: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows :', d_progress);
194: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
195: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows :', d_progress);
188: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk4_value : ' || p_pk4_value, d_progress);
189: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk5_value : ' || p_pk5_value, d_progress);
190: PO_UDA_DEFAULTING_PKG.DEBUG('x_base_object_name : ' || x_base_object_name, d_progress);
191: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows :', d_progress);
192: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
193: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows :', d_progress);
194: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
195: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows :', d_progress);
196: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
189: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk5_value : ' || p_pk5_value, d_progress);
190: PO_UDA_DEFAULTING_PKG.DEBUG('x_base_object_name : ' || x_base_object_name, d_progress);
191: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows :', d_progress);
192: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
193: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows :', d_progress);
194: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
195: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows :', d_progress);
196: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
197: PO_UDA_DEFAULTING_PKG.DEBUG('x_class_code_name_value_pairs is as follows :', d_progress);
190: PO_UDA_DEFAULTING_PKG.DEBUG('x_base_object_name : ' || x_base_object_name, d_progress);
191: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows :', d_progress);
192: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
193: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows :', d_progress);
194: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
195: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows :', d_progress);
196: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
197: PO_UDA_DEFAULTING_PKG.DEBUG('x_class_code_name_value_pairs is as follows :', d_progress);
198: PO_UDA_DEFAULTING_PKG.DEBUG(x_class_code_name_value_pairs, d_progress);
191: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows :', d_progress);
192: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
193: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows :', d_progress);
194: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
195: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows :', d_progress);
196: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
197: PO_UDA_DEFAULTING_PKG.DEBUG('x_class_code_name_value_pairs is as follows :', d_progress);
198: PO_UDA_DEFAULTING_PKG.DEBUG(x_class_code_name_value_pairs, d_progress);
199: d_progress := 20;
192: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
193: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows :', d_progress);
194: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
195: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows :', d_progress);
196: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
197: PO_UDA_DEFAULTING_PKG.DEBUG('x_class_code_name_value_pairs is as follows :', d_progress);
198: PO_UDA_DEFAULTING_PKG.DEBUG(x_class_code_name_value_pairs, d_progress);
199: d_progress := 20;
200:
193: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows :', d_progress);
194: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
195: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows :', d_progress);
196: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
197: PO_UDA_DEFAULTING_PKG.DEBUG('x_class_code_name_value_pairs is as follows :', d_progress);
198: PO_UDA_DEFAULTING_PKG.DEBUG(x_class_code_name_value_pairs, d_progress);
199: d_progress := 20;
200:
201: BEGIN
194: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
195: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows :', d_progress);
196: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
197: PO_UDA_DEFAULTING_PKG.DEBUG('x_class_code_name_value_pairs is as follows :', d_progress);
198: PO_UDA_DEFAULTING_PKG.DEBUG(x_class_code_name_value_pairs, d_progress);
199: d_progress := 20;
200:
201: BEGIN
202: d_progress := 30;
209: AND NVL(PK4_VALUE, -999) = NVL(p_pk4_value, -999)
210: AND NVL(PK5_VALUE, -999) = NVL(p_pk5_value, -999)
211: AND ROWNUM < 2;
212: d_progress := 40;
213: PO_UDA_DEFAULTING_PKG.DEBUG('INTERFACE_REFERENCE_ID : ' || g_interface_reference_id, d_progress);
214: EXCEPTION
215: WHEN OTHERS THEN
216: d_progress := 50;
217: PO_UDA_DEFAULTING_PKG.DEBUG('Exception while trying to get the INTERFACE_REFERENCE_ID', d_progress);
213: PO_UDA_DEFAULTING_PKG.DEBUG('INTERFACE_REFERENCE_ID : ' || g_interface_reference_id, d_progress);
214: EXCEPTION
215: WHEN OTHERS THEN
216: d_progress := 50;
217: PO_UDA_DEFAULTING_PKG.DEBUG('Exception while trying to get the INTERFACE_REFERENCE_ID', d_progress);
218: RAISE;
219: END;
220:
221: d_progress := 60;
219: END;
220:
221: d_progress := 60;
222: x_base_object_name := PO_UDA_DATA_UTIL.g_object_dff_tl(p_attr_grp_type).l_object_name;
223: PO_UDA_DEFAULTING_PKG.DEBUG('The Base object is ' || x_base_object_name, d_progress);
224: d_progress := 70;
225:
226: PO_UDA_DEFAULTING_PKG.DEBUG('Before PO_UDA_DEFAULTING_PKG.CONSTRUCT_PK_OBJECT' , d_progress);
227: PO_UDA_DEFAULTING_PKG.CONSTRUCT_PK_OBJECT(
222: x_base_object_name := PO_UDA_DATA_UTIL.g_object_dff_tl(p_attr_grp_type).l_object_name;
223: PO_UDA_DEFAULTING_PKG.DEBUG('The Base object is ' || x_base_object_name, d_progress);
224: d_progress := 70;
225:
226: PO_UDA_DEFAULTING_PKG.DEBUG('Before PO_UDA_DEFAULTING_PKG.CONSTRUCT_PK_OBJECT' , d_progress);
227: PO_UDA_DEFAULTING_PKG.CONSTRUCT_PK_OBJECT(
228: x_base_object_name
229: ,p_pk1_value
230: ,p_pk2_value
223: PO_UDA_DEFAULTING_PKG.DEBUG('The Base object is ' || x_base_object_name, d_progress);
224: d_progress := 70;
225:
226: PO_UDA_DEFAULTING_PKG.DEBUG('Before PO_UDA_DEFAULTING_PKG.CONSTRUCT_PK_OBJECT' , d_progress);
227: PO_UDA_DEFAULTING_PKG.CONSTRUCT_PK_OBJECT(
228: x_base_object_name
229: ,p_pk1_value
230: ,p_pk2_value
231: ,p_pk3_value
233: ,p_pk5_value
234: ,x_pk_column_name_value_pairs
235: );
236: d_progress := 80;
237: PO_UDA_DEFAULTING_PKG.DEBUG('Before PO_UDA_DEFAULTING_PKG.CONSTRUCT_PK_OBJECT' , d_progress);
238: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows :', d_progress);
239: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
240:
241: OPEN cur_uda_interface_recs (p_pk1_value, p_pk2_value, p_pk3_value, p_pk4_value, p_pk5_value, p_attr_grp_type);
234: ,x_pk_column_name_value_pairs
235: );
236: d_progress := 80;
237: PO_UDA_DEFAULTING_PKG.DEBUG('Before PO_UDA_DEFAULTING_PKG.CONSTRUCT_PK_OBJECT' , d_progress);
238: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows :', d_progress);
239: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
240:
241: OPEN cur_uda_interface_recs (p_pk1_value, p_pk2_value, p_pk3_value, p_pk4_value, p_pk5_value, p_attr_grp_type);
242: d_progress := 90;
235: );
236: d_progress := 80;
237: PO_UDA_DEFAULTING_PKG.DEBUG('Before PO_UDA_DEFAULTING_PKG.CONSTRUCT_PK_OBJECT' , d_progress);
238: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows :', d_progress);
239: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
240:
241: OPEN cur_uda_interface_recs (p_pk1_value, p_pk2_value, p_pk3_value, p_pk4_value, p_pk5_value, p_attr_grp_type);
242: d_progress := 90;
243: LOOP
278: ,l_interface_source_line_id;
279: EXIT WHEN cur_uda_interface_recs%NOTFOUND;
280:
281: d_progress := 110;
282: PO_UDA_DEFAULTING_PKG.DEBUG('Details read from the interface table are as follows :', d_progress);
283: PO_UDA_DEFAULTING_PKG.DEBUG('l_interface_reference_id : ' || l_interface_reference_id, d_progress);
284: PO_UDA_DEFAULTING_PKG.DEBUG('l_transaction_id : ' || l_transaction_id, d_progress);
285: PO_UDA_DEFAULTING_PKG.DEBUG('l_row_identifier : ' || l_row_identifier, d_progress);
286: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_id : ' || l_attr_group_id, d_progress);
279: EXIT WHEN cur_uda_interface_recs%NOTFOUND;
280:
281: d_progress := 110;
282: PO_UDA_DEFAULTING_PKG.DEBUG('Details read from the interface table are as follows :', d_progress);
283: PO_UDA_DEFAULTING_PKG.DEBUG('l_interface_reference_id : ' || l_interface_reference_id, d_progress);
284: PO_UDA_DEFAULTING_PKG.DEBUG('l_transaction_id : ' || l_transaction_id, d_progress);
285: PO_UDA_DEFAULTING_PKG.DEBUG('l_row_identifier : ' || l_row_identifier, d_progress);
286: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_id : ' || l_attr_group_id, d_progress);
287: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_app_id : ' || l_attr_group_app_id, d_progress);
280:
281: d_progress := 110;
282: PO_UDA_DEFAULTING_PKG.DEBUG('Details read from the interface table are as follows :', d_progress);
283: PO_UDA_DEFAULTING_PKG.DEBUG('l_interface_reference_id : ' || l_interface_reference_id, d_progress);
284: PO_UDA_DEFAULTING_PKG.DEBUG('l_transaction_id : ' || l_transaction_id, d_progress);
285: PO_UDA_DEFAULTING_PKG.DEBUG('l_row_identifier : ' || l_row_identifier, d_progress);
286: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_id : ' || l_attr_group_id, d_progress);
287: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_app_id : ' || l_attr_group_app_id, d_progress);
288: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_name : ' || l_attr_group_name, d_progress);
281: d_progress := 110;
282: PO_UDA_DEFAULTING_PKG.DEBUG('Details read from the interface table are as follows :', d_progress);
283: PO_UDA_DEFAULTING_PKG.DEBUG('l_interface_reference_id : ' || l_interface_reference_id, d_progress);
284: PO_UDA_DEFAULTING_PKG.DEBUG('l_transaction_id : ' || l_transaction_id, d_progress);
285: PO_UDA_DEFAULTING_PKG.DEBUG('l_row_identifier : ' || l_row_identifier, d_progress);
286: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_id : ' || l_attr_group_id, d_progress);
287: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_app_id : ' || l_attr_group_app_id, d_progress);
288: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_name : ' || l_attr_group_name, d_progress);
289: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_1 : ' || l_data_level_1, d_progress);
282: PO_UDA_DEFAULTING_PKG.DEBUG('Details read from the interface table are as follows :', d_progress);
283: PO_UDA_DEFAULTING_PKG.DEBUG('l_interface_reference_id : ' || l_interface_reference_id, d_progress);
284: PO_UDA_DEFAULTING_PKG.DEBUG('l_transaction_id : ' || l_transaction_id, d_progress);
285: PO_UDA_DEFAULTING_PKG.DEBUG('l_row_identifier : ' || l_row_identifier, d_progress);
286: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_id : ' || l_attr_group_id, d_progress);
287: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_app_id : ' || l_attr_group_app_id, d_progress);
288: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_name : ' || l_attr_group_name, d_progress);
289: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_1 : ' || l_data_level_1, d_progress);
290: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_2 : ' || l_data_level_2, d_progress);
283: PO_UDA_DEFAULTING_PKG.DEBUG('l_interface_reference_id : ' || l_interface_reference_id, d_progress);
284: PO_UDA_DEFAULTING_PKG.DEBUG('l_transaction_id : ' || l_transaction_id, d_progress);
285: PO_UDA_DEFAULTING_PKG.DEBUG('l_row_identifier : ' || l_row_identifier, d_progress);
286: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_id : ' || l_attr_group_id, d_progress);
287: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_app_id : ' || l_attr_group_app_id, d_progress);
288: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_name : ' || l_attr_group_name, d_progress);
289: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_1 : ' || l_data_level_1, d_progress);
290: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_2 : ' || l_data_level_2, d_progress);
291: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_3 : ' || l_data_level_3, d_progress);
284: PO_UDA_DEFAULTING_PKG.DEBUG('l_transaction_id : ' || l_transaction_id, d_progress);
285: PO_UDA_DEFAULTING_PKG.DEBUG('l_row_identifier : ' || l_row_identifier, d_progress);
286: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_id : ' || l_attr_group_id, d_progress);
287: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_app_id : ' || l_attr_group_app_id, d_progress);
288: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_name : ' || l_attr_group_name, d_progress);
289: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_1 : ' || l_data_level_1, d_progress);
290: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_2 : ' || l_data_level_2, d_progress);
291: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_3 : ' || l_data_level_3, d_progress);
292: PO_UDA_DEFAULTING_PKG.DEBUG('l_transaction_type : ' || l_transaction_type, d_progress);
285: PO_UDA_DEFAULTING_PKG.DEBUG('l_row_identifier : ' || l_row_identifier, d_progress);
286: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_id : ' || l_attr_group_id, d_progress);
287: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_app_id : ' || l_attr_group_app_id, d_progress);
288: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_name : ' || l_attr_group_name, d_progress);
289: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_1 : ' || l_data_level_1, d_progress);
290: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_2 : ' || l_data_level_2, d_progress);
291: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_3 : ' || l_data_level_3, d_progress);
292: PO_UDA_DEFAULTING_PKG.DEBUG('l_transaction_type : ' || l_transaction_type, d_progress);
293: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name : ' || l_attr_name, d_progress);
286: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_id : ' || l_attr_group_id, d_progress);
287: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_app_id : ' || l_attr_group_app_id, d_progress);
288: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_name : ' || l_attr_group_name, d_progress);
289: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_1 : ' || l_data_level_1, d_progress);
290: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_2 : ' || l_data_level_2, d_progress);
291: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_3 : ' || l_data_level_3, d_progress);
292: PO_UDA_DEFAULTING_PKG.DEBUG('l_transaction_type : ' || l_transaction_type, d_progress);
293: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name : ' || l_attr_name, d_progress);
294: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_str : ' || l_attr_value_str, d_progress);
287: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_app_id : ' || l_attr_group_app_id, d_progress);
288: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_name : ' || l_attr_group_name, d_progress);
289: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_1 : ' || l_data_level_1, d_progress);
290: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_2 : ' || l_data_level_2, d_progress);
291: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_3 : ' || l_data_level_3, d_progress);
292: PO_UDA_DEFAULTING_PKG.DEBUG('l_transaction_type : ' || l_transaction_type, d_progress);
293: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name : ' || l_attr_name, d_progress);
294: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_str : ' || l_attr_value_str, d_progress);
295: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_num : ' || l_attr_value_num, d_progress);
288: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_name : ' || l_attr_group_name, d_progress);
289: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_1 : ' || l_data_level_1, d_progress);
290: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_2 : ' || l_data_level_2, d_progress);
291: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_3 : ' || l_data_level_3, d_progress);
292: PO_UDA_DEFAULTING_PKG.DEBUG('l_transaction_type : ' || l_transaction_type, d_progress);
293: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name : ' || l_attr_name, d_progress);
294: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_str : ' || l_attr_value_str, d_progress);
295: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_num : ' || l_attr_value_num, d_progress);
296: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_date : ' || l_attr_value_date, d_progress);
289: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_1 : ' || l_data_level_1, d_progress);
290: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_2 : ' || l_data_level_2, d_progress);
291: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_3 : ' || l_data_level_3, d_progress);
292: PO_UDA_DEFAULTING_PKG.DEBUG('l_transaction_type : ' || l_transaction_type, d_progress);
293: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name : ' || l_attr_name, d_progress);
294: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_str : ' || l_attr_value_str, d_progress);
295: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_num : ' || l_attr_value_num, d_progress);
296: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_date : ' || l_attr_value_date, d_progress);
297: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_disp_value : ' || l_attr_disp_value, d_progress);
290: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_2 : ' || l_data_level_2, d_progress);
291: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_3 : ' || l_data_level_3, d_progress);
292: PO_UDA_DEFAULTING_PKG.DEBUG('l_transaction_type : ' || l_transaction_type, d_progress);
293: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name : ' || l_attr_name, d_progress);
294: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_str : ' || l_attr_value_str, d_progress);
295: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_num : ' || l_attr_value_num, d_progress);
296: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_date : ' || l_attr_value_date, d_progress);
297: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_disp_value : ' || l_attr_disp_value, d_progress);
298: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_unit_of_measure : ' || l_attr_unit_of_measure, d_progress);
291: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_3 : ' || l_data_level_3, d_progress);
292: PO_UDA_DEFAULTING_PKG.DEBUG('l_transaction_type : ' || l_transaction_type, d_progress);
293: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name : ' || l_attr_name, d_progress);
294: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_str : ' || l_attr_value_str, d_progress);
295: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_num : ' || l_attr_value_num, d_progress);
296: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_date : ' || l_attr_value_date, d_progress);
297: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_disp_value : ' || l_attr_disp_value, d_progress);
298: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_unit_of_measure : ' || l_attr_unit_of_measure, d_progress);
299: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);
292: PO_UDA_DEFAULTING_PKG.DEBUG('l_transaction_type : ' || l_transaction_type, d_progress);
293: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name : ' || l_attr_name, d_progress);
294: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_str : ' || l_attr_value_str, d_progress);
295: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_num : ' || l_attr_value_num, d_progress);
296: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_date : ' || l_attr_value_date, d_progress);
297: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_disp_value : ' || l_attr_disp_value, d_progress);
298: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_unit_of_measure : ' || l_attr_unit_of_measure, d_progress);
299: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);
300: PO_UDA_DEFAULTING_PKG.DEBUG('l_uda_template_id : ' || l_uda_template_id, d_progress);
293: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name : ' || l_attr_name, d_progress);
294: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_str : ' || l_attr_value_str, d_progress);
295: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_num : ' || l_attr_value_num, d_progress);
296: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_date : ' || l_attr_value_date, d_progress);
297: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_disp_value : ' || l_attr_disp_value, d_progress);
298: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_unit_of_measure : ' || l_attr_unit_of_measure, d_progress);
299: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);
300: PO_UDA_DEFAULTING_PKG.DEBUG('l_uda_template_id : ' || l_uda_template_id, d_progress);
301: PO_UDA_DEFAULTING_PKG.DEBUG('l_process_status : ' || l_process_status, d_progress);
294: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_str : ' || l_attr_value_str, d_progress);
295: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_num : ' || l_attr_value_num, d_progress);
296: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_date : ' || l_attr_value_date, d_progress);
297: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_disp_value : ' || l_attr_disp_value, d_progress);
298: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_unit_of_measure : ' || l_attr_unit_of_measure, d_progress);
299: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);
300: PO_UDA_DEFAULTING_PKG.DEBUG('l_uda_template_id : ' || l_uda_template_id, d_progress);
301: PO_UDA_DEFAULTING_PKG.DEBUG('l_process_status : ' || l_process_status, d_progress);
302: PO_UDA_DEFAULTING_PKG.DEBUG('l_process_phase : ' || l_process_phase, d_progress);
295: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_num : ' || l_attr_value_num, d_progress);
296: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_date : ' || l_attr_value_date, d_progress);
297: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_disp_value : ' || l_attr_disp_value, d_progress);
298: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_unit_of_measure : ' || l_attr_unit_of_measure, d_progress);
299: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);
300: PO_UDA_DEFAULTING_PKG.DEBUG('l_uda_template_id : ' || l_uda_template_id, d_progress);
301: PO_UDA_DEFAULTING_PKG.DEBUG('l_process_status : ' || l_process_status, d_progress);
302: PO_UDA_DEFAULTING_PKG.DEBUG('l_process_phase : ' || l_process_phase, d_progress);
303: PO_UDA_DEFAULTING_PKG.DEBUG('l_request_id : ' || l_request_id, d_progress);
296: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_date : ' || l_attr_value_date, d_progress);
297: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_disp_value : ' || l_attr_disp_value, d_progress);
298: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_unit_of_measure : ' || l_attr_unit_of_measure, d_progress);
299: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);
300: PO_UDA_DEFAULTING_PKG.DEBUG('l_uda_template_id : ' || l_uda_template_id, d_progress);
301: PO_UDA_DEFAULTING_PKG.DEBUG('l_process_status : ' || l_process_status, d_progress);
302: PO_UDA_DEFAULTING_PKG.DEBUG('l_process_phase : ' || l_process_phase, d_progress);
303: PO_UDA_DEFAULTING_PKG.DEBUG('l_request_id : ' || l_request_id, d_progress);
304: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_id : ' || l_program_id, d_progress);
297: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_disp_value : ' || l_attr_disp_value, d_progress);
298: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_unit_of_measure : ' || l_attr_unit_of_measure, d_progress);
299: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);
300: PO_UDA_DEFAULTING_PKG.DEBUG('l_uda_template_id : ' || l_uda_template_id, d_progress);
301: PO_UDA_DEFAULTING_PKG.DEBUG('l_process_status : ' || l_process_status, d_progress);
302: PO_UDA_DEFAULTING_PKG.DEBUG('l_process_phase : ' || l_process_phase, d_progress);
303: PO_UDA_DEFAULTING_PKG.DEBUG('l_request_id : ' || l_request_id, d_progress);
304: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_id : ' || l_program_id, d_progress);
305: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_application_id : ' || l_program_application_id, d_progress);
298: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_unit_of_measure : ' || l_attr_unit_of_measure, d_progress);
299: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);
300: PO_UDA_DEFAULTING_PKG.DEBUG('l_uda_template_id : ' || l_uda_template_id, d_progress);
301: PO_UDA_DEFAULTING_PKG.DEBUG('l_process_status : ' || l_process_status, d_progress);
302: PO_UDA_DEFAULTING_PKG.DEBUG('l_process_phase : ' || l_process_phase, d_progress);
303: PO_UDA_DEFAULTING_PKG.DEBUG('l_request_id : ' || l_request_id, d_progress);
304: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_id : ' || l_program_id, d_progress);
305: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_application_id : ' || l_program_application_id, d_progress);
306: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_update_date : ' || l_program_update_date, d_progress);
299: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);
300: PO_UDA_DEFAULTING_PKG.DEBUG('l_uda_template_id : ' || l_uda_template_id, d_progress);
301: PO_UDA_DEFAULTING_PKG.DEBUG('l_process_status : ' || l_process_status, d_progress);
302: PO_UDA_DEFAULTING_PKG.DEBUG('l_process_phase : ' || l_process_phase, d_progress);
303: PO_UDA_DEFAULTING_PKG.DEBUG('l_request_id : ' || l_request_id, d_progress);
304: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_id : ' || l_program_id, d_progress);
305: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_application_id : ' || l_program_application_id, d_progress);
306: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_update_date : ' || l_program_update_date, d_progress);
307: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_update_date : ' || l_last_update_date, d_progress);
300: PO_UDA_DEFAULTING_PKG.DEBUG('l_uda_template_id : ' || l_uda_template_id, d_progress);
301: PO_UDA_DEFAULTING_PKG.DEBUG('l_process_status : ' || l_process_status, d_progress);
302: PO_UDA_DEFAULTING_PKG.DEBUG('l_process_phase : ' || l_process_phase, d_progress);
303: PO_UDA_DEFAULTING_PKG.DEBUG('l_request_id : ' || l_request_id, d_progress);
304: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_id : ' || l_program_id, d_progress);
305: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_application_id : ' || l_program_application_id, d_progress);
306: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_update_date : ' || l_program_update_date, d_progress);
307: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_update_date : ' || l_last_update_date, d_progress);
308: PO_UDA_DEFAULTING_PKG.DEBUG('l_creation_date : ' || l_creation_date, d_progress);
301: PO_UDA_DEFAULTING_PKG.DEBUG('l_process_status : ' || l_process_status, d_progress);
302: PO_UDA_DEFAULTING_PKG.DEBUG('l_process_phase : ' || l_process_phase, d_progress);
303: PO_UDA_DEFAULTING_PKG.DEBUG('l_request_id : ' || l_request_id, d_progress);
304: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_id : ' || l_program_id, d_progress);
305: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_application_id : ' || l_program_application_id, d_progress);
306: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_update_date : ' || l_program_update_date, d_progress);
307: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_update_date : ' || l_last_update_date, d_progress);
308: PO_UDA_DEFAULTING_PKG.DEBUG('l_creation_date : ' || l_creation_date, d_progress);
309: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_updated_by : ' || l_last_updated_by, d_progress);
302: PO_UDA_DEFAULTING_PKG.DEBUG('l_process_phase : ' || l_process_phase, d_progress);
303: PO_UDA_DEFAULTING_PKG.DEBUG('l_request_id : ' || l_request_id, d_progress);
304: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_id : ' || l_program_id, d_progress);
305: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_application_id : ' || l_program_application_id, d_progress);
306: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_update_date : ' || l_program_update_date, d_progress);
307: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_update_date : ' || l_last_update_date, d_progress);
308: PO_UDA_DEFAULTING_PKG.DEBUG('l_creation_date : ' || l_creation_date, d_progress);
309: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_updated_by : ' || l_last_updated_by, d_progress);
310: PO_UDA_DEFAULTING_PKG.DEBUG('l_created_by_name : ' || l_created_by_name, d_progress);
303: PO_UDA_DEFAULTING_PKG.DEBUG('l_request_id : ' || l_request_id, d_progress);
304: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_id : ' || l_program_id, d_progress);
305: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_application_id : ' || l_program_application_id, d_progress);
306: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_update_date : ' || l_program_update_date, d_progress);
307: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_update_date : ' || l_last_update_date, d_progress);
308: PO_UDA_DEFAULTING_PKG.DEBUG('l_creation_date : ' || l_creation_date, d_progress);
309: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_updated_by : ' || l_last_updated_by, d_progress);
310: PO_UDA_DEFAULTING_PKG.DEBUG('l_created_by_name : ' || l_created_by_name, d_progress);
311: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_updated_by_name : ' || l_last_updated_by_name, d_progress);
304: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_id : ' || l_program_id, d_progress);
305: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_application_id : ' || l_program_application_id, d_progress);
306: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_update_date : ' || l_program_update_date, d_progress);
307: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_update_date : ' || l_last_update_date, d_progress);
308: PO_UDA_DEFAULTING_PKG.DEBUG('l_creation_date : ' || l_creation_date, d_progress);
309: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_updated_by : ' || l_last_updated_by, d_progress);
310: PO_UDA_DEFAULTING_PKG.DEBUG('l_created_by_name : ' || l_created_by_name, d_progress);
311: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_updated_by_name : ' || l_last_updated_by_name, d_progress);
312: PO_UDA_DEFAULTING_PKG.DEBUG('l_interface_source_code : ' || l_interface_source_code, d_progress);
305: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_application_id : ' || l_program_application_id, d_progress);
306: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_update_date : ' || l_program_update_date, d_progress);
307: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_update_date : ' || l_last_update_date, d_progress);
308: PO_UDA_DEFAULTING_PKG.DEBUG('l_creation_date : ' || l_creation_date, d_progress);
309: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_updated_by : ' || l_last_updated_by, d_progress);
310: PO_UDA_DEFAULTING_PKG.DEBUG('l_created_by_name : ' || l_created_by_name, d_progress);
311: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_updated_by_name : ' || l_last_updated_by_name, d_progress);
312: PO_UDA_DEFAULTING_PKG.DEBUG('l_interface_source_code : ' || l_interface_source_code, d_progress);
313: PO_UDA_DEFAULTING_PKG.DEBUG('l_interface_source_line_id : ' || l_interface_source_line_id, d_progress);
306: PO_UDA_DEFAULTING_PKG.DEBUG('l_program_update_date : ' || l_program_update_date, d_progress);
307: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_update_date : ' || l_last_update_date, d_progress);
308: PO_UDA_DEFAULTING_PKG.DEBUG('l_creation_date : ' || l_creation_date, d_progress);
309: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_updated_by : ' || l_last_updated_by, d_progress);
310: PO_UDA_DEFAULTING_PKG.DEBUG('l_created_by_name : ' || l_created_by_name, d_progress);
311: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_updated_by_name : ' || l_last_updated_by_name, d_progress);
312: PO_UDA_DEFAULTING_PKG.DEBUG('l_interface_source_code : ' || l_interface_source_code, d_progress);
313: PO_UDA_DEFAULTING_PKG.DEBUG('l_interface_source_line_id : ' || l_interface_source_line_id, d_progress);
314: d_progress := 120;
307: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_update_date : ' || l_last_update_date, d_progress);
308: PO_UDA_DEFAULTING_PKG.DEBUG('l_creation_date : ' || l_creation_date, d_progress);
309: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_updated_by : ' || l_last_updated_by, d_progress);
310: PO_UDA_DEFAULTING_PKG.DEBUG('l_created_by_name : ' || l_created_by_name, d_progress);
311: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_updated_by_name : ' || l_last_updated_by_name, d_progress);
312: PO_UDA_DEFAULTING_PKG.DEBUG('l_interface_source_code : ' || l_interface_source_code, d_progress);
313: PO_UDA_DEFAULTING_PKG.DEBUG('l_interface_source_line_id : ' || l_interface_source_line_id, d_progress);
314: d_progress := 120;
315:
308: PO_UDA_DEFAULTING_PKG.DEBUG('l_creation_date : ' || l_creation_date, d_progress);
309: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_updated_by : ' || l_last_updated_by, d_progress);
310: PO_UDA_DEFAULTING_PKG.DEBUG('l_created_by_name : ' || l_created_by_name, d_progress);
311: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_updated_by_name : ' || l_last_updated_by_name, d_progress);
312: PO_UDA_DEFAULTING_PKG.DEBUG('l_interface_source_code : ' || l_interface_source_code, d_progress);
313: PO_UDA_DEFAULTING_PKG.DEBUG('l_interface_source_line_id : ' || l_interface_source_line_id, d_progress);
314: d_progress := 120;
315:
316: PO_UDA_DEFAULTING_PKG.DEBUG('Before constructing Attribute row Array', d_progress);
309: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_updated_by : ' || l_last_updated_by, d_progress);
310: PO_UDA_DEFAULTING_PKG.DEBUG('l_created_by_name : ' || l_created_by_name, d_progress);
311: PO_UDA_DEFAULTING_PKG.DEBUG('l_last_updated_by_name : ' || l_last_updated_by_name, d_progress);
312: PO_UDA_DEFAULTING_PKG.DEBUG('l_interface_source_code : ' || l_interface_source_code, d_progress);
313: PO_UDA_DEFAULTING_PKG.DEBUG('l_interface_source_line_id : ' || l_interface_source_line_id, d_progress);
314: d_progress := 120;
315:
316: PO_UDA_DEFAULTING_PKG.DEBUG('Before constructing Attribute row Array', d_progress);
317: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_row_identifier ' || l_row_identifier, d_progress);
312: PO_UDA_DEFAULTING_PKG.DEBUG('l_interface_source_code : ' || l_interface_source_code, d_progress);
313: PO_UDA_DEFAULTING_PKG.DEBUG('l_interface_source_line_id : ' || l_interface_source_line_id, d_progress);
314: d_progress := 120;
315:
316: PO_UDA_DEFAULTING_PKG.DEBUG('Before constructing Attribute row Array', d_progress);
317: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_row_identifier ' || l_row_identifier, d_progress);
318: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_id ' || l_attr_group_id, d_progress);
319: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_app_id ' || l_attr_group_app_id, d_progress);
320: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: p_attr_grp_type ' || p_attr_grp_type, d_progress);
313: PO_UDA_DEFAULTING_PKG.DEBUG('l_interface_source_line_id : ' || l_interface_source_line_id, d_progress);
314: d_progress := 120;
315:
316: PO_UDA_DEFAULTING_PKG.DEBUG('Before constructing Attribute row Array', d_progress);
317: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_row_identifier ' || l_row_identifier, d_progress);
318: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_id ' || l_attr_group_id, d_progress);
319: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_app_id ' || l_attr_group_app_id, d_progress);
320: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: p_attr_grp_type ' || p_attr_grp_type, d_progress);
321: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_name ' || l_attr_group_name, d_progress);
314: d_progress := 120;
315:
316: PO_UDA_DEFAULTING_PKG.DEBUG('Before constructing Attribute row Array', d_progress);
317: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_row_identifier ' || l_row_identifier, d_progress);
318: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_id ' || l_attr_group_id, d_progress);
319: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_app_id ' || l_attr_group_app_id, d_progress);
320: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: p_attr_grp_type ' || p_attr_grp_type, d_progress);
321: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_name ' || l_attr_group_name, d_progress);
322: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_data_level_1 ' || l_data_level_1, d_progress);
315:
316: PO_UDA_DEFAULTING_PKG.DEBUG('Before constructing Attribute row Array', d_progress);
317: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_row_identifier ' || l_row_identifier, d_progress);
318: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_id ' || l_attr_group_id, d_progress);
319: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_app_id ' || l_attr_group_app_id, d_progress);
320: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: p_attr_grp_type ' || p_attr_grp_type, d_progress);
321: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_name ' || l_attr_group_name, d_progress);
322: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_data_level_1 ' || l_data_level_1, d_progress);
323: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_data_level_2 ' || l_data_level_2, d_progress);
316: PO_UDA_DEFAULTING_PKG.DEBUG('Before constructing Attribute row Array', d_progress);
317: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_row_identifier ' || l_row_identifier, d_progress);
318: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_id ' || l_attr_group_id, d_progress);
319: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_app_id ' || l_attr_group_app_id, d_progress);
320: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: p_attr_grp_type ' || p_attr_grp_type, d_progress);
321: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_name ' || l_attr_group_name, d_progress);
322: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_data_level_1 ' || l_data_level_1, d_progress);
323: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_data_level_2 ' || l_data_level_2, d_progress);
324: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_data_level_3 ' || l_data_level_3, d_progress);
317: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_row_identifier ' || l_row_identifier, d_progress);
318: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_id ' || l_attr_group_id, d_progress);
319: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_app_id ' || l_attr_group_app_id, d_progress);
320: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: p_attr_grp_type ' || p_attr_grp_type, d_progress);
321: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_name ' || l_attr_group_name, d_progress);
322: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_data_level_1 ' || l_data_level_1, d_progress);
323: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_data_level_2 ' || l_data_level_2, d_progress);
324: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_data_level_3 ' || l_data_level_3, d_progress);
325: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_transaction_type ' || l_transaction_type, d_progress);
318: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_id ' || l_attr_group_id, d_progress);
319: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_app_id ' || l_attr_group_app_id, d_progress);
320: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: p_attr_grp_type ' || p_attr_grp_type, d_progress);
321: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_name ' || l_attr_group_name, d_progress);
322: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_data_level_1 ' || l_data_level_1, d_progress);
323: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_data_level_2 ' || l_data_level_2, d_progress);
324: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_data_level_3 ' || l_data_level_3, d_progress);
325: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_transaction_type ' || l_transaction_type, d_progress);
326: d_progress := 130;
319: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_app_id ' || l_attr_group_app_id, d_progress);
320: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: p_attr_grp_type ' || p_attr_grp_type, d_progress);
321: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_name ' || l_attr_group_name, d_progress);
322: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_data_level_1 ' || l_data_level_1, d_progress);
323: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_data_level_2 ' || l_data_level_2, d_progress);
324: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_data_level_3 ' || l_data_level_3, d_progress);
325: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_transaction_type ' || l_transaction_type, d_progress);
326: d_progress := 130;
327: x_attributes_row_table.EXTEND(1);
320: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: p_attr_grp_type ' || p_attr_grp_type, d_progress);
321: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_name ' || l_attr_group_name, d_progress);
322: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_data_level_1 ' || l_data_level_1, d_progress);
323: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_data_level_2 ' || l_data_level_2, d_progress);
324: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_data_level_3 ' || l_data_level_3, d_progress);
325: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_transaction_type ' || l_transaction_type, d_progress);
326: d_progress := 130;
327: x_attributes_row_table.EXTEND(1);
328: x_attributes_row_table(l_count + 1) := ego_user_attr_row_obj
321: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_attr_group_name ' || l_attr_group_name, d_progress);
322: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_data_level_1 ' || l_data_level_1, d_progress);
323: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_data_level_2 ' || l_data_level_2, d_progress);
324: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_data_level_3 ' || l_data_level_3, d_progress);
325: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute row Array: l_transaction_type ' || l_transaction_type, d_progress);
326: d_progress := 130;
327: x_attributes_row_table.EXTEND(1);
328: x_attributes_row_table(l_count + 1) := ego_user_attr_row_obj
329: (
340: ,NULL
341: ,l_transaction_type
342: );
343: d_progress := 140;
344: PO_UDA_DEFAULTING_PKG.DEBUG('After constructing Attribute row Array', d_progress);
345: PO_UDA_DEFAULTING_PKG.DEBUG('Before constructing Attribute Name Values Array', d_progress);
346: PO_UDA_DEFAULTING_PKG.DEBUG('l_row_identifier ' || l_row_identifier, d_progress);
347: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name ' || l_attr_name, d_progress);
348: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_str ' || l_attr_value_str, d_progress);
341: ,l_transaction_type
342: );
343: d_progress := 140;
344: PO_UDA_DEFAULTING_PKG.DEBUG('After constructing Attribute row Array', d_progress);
345: PO_UDA_DEFAULTING_PKG.DEBUG('Before constructing Attribute Name Values Array', d_progress);
346: PO_UDA_DEFAULTING_PKG.DEBUG('l_row_identifier ' || l_row_identifier, d_progress);
347: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name ' || l_attr_name, d_progress);
348: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_str ' || l_attr_value_str, d_progress);
349: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_num ' || l_attr_value_num, d_progress);
342: );
343: d_progress := 140;
344: PO_UDA_DEFAULTING_PKG.DEBUG('After constructing Attribute row Array', d_progress);
345: PO_UDA_DEFAULTING_PKG.DEBUG('Before constructing Attribute Name Values Array', d_progress);
346: PO_UDA_DEFAULTING_PKG.DEBUG('l_row_identifier ' || l_row_identifier, d_progress);
347: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name ' || l_attr_name, d_progress);
348: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_str ' || l_attr_value_str, d_progress);
349: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_num ' || l_attr_value_num, d_progress);
350: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_date ' || l_attr_value_date, d_progress);
343: d_progress := 140;
344: PO_UDA_DEFAULTING_PKG.DEBUG('After constructing Attribute row Array', d_progress);
345: PO_UDA_DEFAULTING_PKG.DEBUG('Before constructing Attribute Name Values Array', d_progress);
346: PO_UDA_DEFAULTING_PKG.DEBUG('l_row_identifier ' || l_row_identifier, d_progress);
347: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name ' || l_attr_name, d_progress);
348: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_str ' || l_attr_value_str, d_progress);
349: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_num ' || l_attr_value_num, d_progress);
350: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_date ' || l_attr_value_date, d_progress);
351: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_disp_value ' || l_attr_disp_value, d_progress);
344: PO_UDA_DEFAULTING_PKG.DEBUG('After constructing Attribute row Array', d_progress);
345: PO_UDA_DEFAULTING_PKG.DEBUG('Before constructing Attribute Name Values Array', d_progress);
346: PO_UDA_DEFAULTING_PKG.DEBUG('l_row_identifier ' || l_row_identifier, d_progress);
347: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name ' || l_attr_name, d_progress);
348: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_str ' || l_attr_value_str, d_progress);
349: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_num ' || l_attr_value_num, d_progress);
350: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_date ' || l_attr_value_date, d_progress);
351: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_disp_value ' || l_attr_disp_value, d_progress);
352: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_unit_of_measure ' || l_attr_unit_of_measure, d_progress);
345: PO_UDA_DEFAULTING_PKG.DEBUG('Before constructing Attribute Name Values Array', d_progress);
346: PO_UDA_DEFAULTING_PKG.DEBUG('l_row_identifier ' || l_row_identifier, d_progress);
347: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name ' || l_attr_name, d_progress);
348: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_str ' || l_attr_value_str, d_progress);
349: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_num ' || l_attr_value_num, d_progress);
350: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_date ' || l_attr_value_date, d_progress);
351: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_disp_value ' || l_attr_disp_value, d_progress);
352: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_unit_of_measure ' || l_attr_unit_of_measure, d_progress);
353: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier ' || l_user_row_identifier, d_progress);
346: PO_UDA_DEFAULTING_PKG.DEBUG('l_row_identifier ' || l_row_identifier, d_progress);
347: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name ' || l_attr_name, d_progress);
348: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_str ' || l_attr_value_str, d_progress);
349: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_num ' || l_attr_value_num, d_progress);
350: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_date ' || l_attr_value_date, d_progress);
351: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_disp_value ' || l_attr_disp_value, d_progress);
352: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_unit_of_measure ' || l_attr_unit_of_measure, d_progress);
353: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier ' || l_user_row_identifier, d_progress);
354: d_progress := 150;
347: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name ' || l_attr_name, d_progress);
348: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_str ' || l_attr_value_str, d_progress);
349: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_num ' || l_attr_value_num, d_progress);
350: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_date ' || l_attr_value_date, d_progress);
351: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_disp_value ' || l_attr_disp_value, d_progress);
352: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_unit_of_measure ' || l_attr_unit_of_measure, d_progress);
353: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier ' || l_user_row_identifier, d_progress);
354: d_progress := 150;
355: x_attr_name_value_pairs.EXTEND(1);
348: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_str ' || l_attr_value_str, d_progress);
349: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_num ' || l_attr_value_num, d_progress);
350: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_date ' || l_attr_value_date, d_progress);
351: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_disp_value ' || l_attr_disp_value, d_progress);
352: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_unit_of_measure ' || l_attr_unit_of_measure, d_progress);
353: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier ' || l_user_row_identifier, d_progress);
354: d_progress := 150;
355: x_attr_name_value_pairs.EXTEND(1);
356: x_attr_name_value_pairs(l_count + 1) := ego_user_attr_data_obj
349: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_num ' || l_attr_value_num, d_progress);
350: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_value_date ' || l_attr_value_date, d_progress);
351: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_disp_value ' || l_attr_disp_value, d_progress);
352: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_unit_of_measure ' || l_attr_unit_of_measure, d_progress);
353: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier ' || l_user_row_identifier, d_progress);
354: d_progress := 150;
355: x_attr_name_value_pairs.EXTEND(1);
356: x_attr_name_value_pairs(l_count + 1) := ego_user_attr_data_obj
357: (
364: ,l_attr_unit_of_measure
365: ,l_user_row_identifier
366: );
367: d_progress := 160;
368: PO_UDA_DEFAULTING_PKG.DEBUG('After constructing Attribute Name Values Array', d_progress);
369: l_count := l_count + 1;
370: d_progress := 170;
371: END LOOP;
372: d_progress := 180;
372: d_progress := 180;
373: CLOSE cur_uda_interface_recs;
374: d_progress := 190;
375:
376: PO_UDA_DEFAULTING_PKG.DEBUG('Before constructing Class codes Array', d_progress);
377: x_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
378: (
379: EGO_COL_NAME_VALUE_PAIR_OBJ
380: (
382: ,l_uda_template_id || ''
383: )
384: );
385: d_progress := 200;
386: PO_UDA_DEFAULTING_PKG.DEBUG('After constructing Class codes Array with template id : ' || l_uda_template_id, d_progress);
387: x_return_status := FND_API.G_RET_STS_SUCCESS;
388: EXCEPTION
389: WHEN OTHERS THEN
390: l_err_txt := 'Exception in POPULATE_STRUCTURES with ERROR : ' || SQLERRM;
458: l_err_txt VARCHAR2(2000);
459:
460: BEGIN
461: d_progress := 10;
462: PO_UDA_DEFAULTING_PKG.DEBUG('Starting POPULATE_REMAINING_ATTRIBUTES', d_progress);
463: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows :', d_progress);
464: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
465: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows :', d_progress);
466: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
459:
460: BEGIN
461: d_progress := 10;
462: PO_UDA_DEFAULTING_PKG.DEBUG('Starting POPULATE_REMAINING_ATTRIBUTES', d_progress);
463: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows :', d_progress);
464: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
465: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows :', d_progress);
466: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
467: d_progress := 20;
460: BEGIN
461: d_progress := 10;
462: PO_UDA_DEFAULTING_PKG.DEBUG('Starting POPULATE_REMAINING_ATTRIBUTES', d_progress);
463: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows :', d_progress);
464: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
465: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows :', d_progress);
466: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
467: d_progress := 20;
468:
461: d_progress := 10;
462: PO_UDA_DEFAULTING_PKG.DEBUG('Starting POPULATE_REMAINING_ATTRIBUTES', d_progress);
463: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows :', d_progress);
464: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
465: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows :', d_progress);
466: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
467: d_progress := 20;
468:
469: PO_UDA_DEFAULTING_PKG.DEBUG('Looping for all the Attribute Groups', d_progress);
462: PO_UDA_DEFAULTING_PKG.DEBUG('Starting POPULATE_REMAINING_ATTRIBUTES', d_progress);
463: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows :', d_progress);
464: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
465: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows :', d_progress);
466: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
467: d_progress := 20;
468:
469: PO_UDA_DEFAULTING_PKG.DEBUG('Looping for all the Attribute Groups', d_progress);
470: IF (x_attributes_row_table IS NOT NULL AND x_attributes_row_table.COUNT > 0) THEN
465: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows :', d_progress);
466: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
467: d_progress := 20;
468:
469: PO_UDA_DEFAULTING_PKG.DEBUG('Looping for all the Attribute Groups', d_progress);
470: IF (x_attributes_row_table IS NOT NULL AND x_attributes_row_table.COUNT > 0) THEN
471: d_progress := 30;
472: l_attr_row_table_index := x_attributes_row_table.FIRST;
473: d_progress := 40;
482: l_attr_group_type := l_attr_row_obj.ATTR_GROUP_TYPE;
483: l_attr_group_name := l_attr_row_obj.ATTR_GROUP_NAME;
484:
485: d_progress := 80;
486: PO_UDA_DEFAULTING_PKG.DEBUG('AG ROW_IDENTIFIER : ' || l_row_identifier, d_progress);
487: PO_UDA_DEFAULTING_PKG.DEBUG('AG ATTR_GROUP_TYPE : ' || l_attr_group_type, d_progress);
488: PO_UDA_DEFAULTING_PKG.DEBUG('AG ATTR_GROUP_NAME : ' || l_attr_group_name, d_progress);
489: d_progress := 90;
490: OPEN cur_uda_attributes (l_attr_group_type, l_attr_group_name);
483: l_attr_group_name := l_attr_row_obj.ATTR_GROUP_NAME;
484:
485: d_progress := 80;
486: PO_UDA_DEFAULTING_PKG.DEBUG('AG ROW_IDENTIFIER : ' || l_row_identifier, d_progress);
487: PO_UDA_DEFAULTING_PKG.DEBUG('AG ATTR_GROUP_TYPE : ' || l_attr_group_type, d_progress);
488: PO_UDA_DEFAULTING_PKG.DEBUG('AG ATTR_GROUP_NAME : ' || l_attr_group_name, d_progress);
489: d_progress := 90;
490: OPEN cur_uda_attributes (l_attr_group_type, l_attr_group_name);
491: LOOP
484:
485: d_progress := 80;
486: PO_UDA_DEFAULTING_PKG.DEBUG('AG ROW_IDENTIFIER : ' || l_row_identifier, d_progress);
487: PO_UDA_DEFAULTING_PKG.DEBUG('AG ATTR_GROUP_TYPE : ' || l_attr_group_type, d_progress);
488: PO_UDA_DEFAULTING_PKG.DEBUG('AG ATTR_GROUP_NAME : ' || l_attr_group_name, d_progress);
489: d_progress := 90;
490: OPEN cur_uda_attributes (l_attr_group_type, l_attr_group_name);
491: LOOP
492: d_progress := 100;
499: SELECT PO_UDA_INTERFACE_USER_ROW_ID_S.NEXTVAL
500: INTO l_user_row_identifier
501: FROM DUAL;
502: d_progress := 110;
503: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);
504: EXCEPTION
505: WHEN OTHERS THEN
506: d_progress := 120;
507: PO_UDA_DEFAULTING_PKG.DEBUG('Exception while trying to get the l_user_row_identifier', d_progress);
503: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);
504: EXCEPTION
505: WHEN OTHERS THEN
506: d_progress := 120;
507: PO_UDA_DEFAULTING_PKG.DEBUG('Exception while trying to get the l_user_row_identifier', d_progress);
508: RAISE;
509: END;
510: d_progress := 130;
511: l_attr_name_value_index := x_attr_name_value_pairs.FIRST;
508: RAISE;
509: END;
510: d_progress := 130;
511: l_attr_name_value_index := x_attr_name_value_pairs.FIRST;
512: PO_UDA_DEFAULTING_PKG.DEBUG('Looping for all the Attributes for the attribute Group :' || l_attr_group_name, d_progress);
513: d_progress := 140;
514: IF x_attr_name_value_pairs(l_attr_name_value_index) IS NOT NULL THEN
515: d_progress := 150;
516: WHILE (l_attr_name_value_index IS NOT NULL AND l_attr_name_value_index <= x_attr_name_value_pairs.LAST)
520: l_attr_row_identifier := l_attr_name_val.ROW_IDENTIFIER;
521: l_attr_name_tab := l_attr_name_val.ATTR_NAME;
522:
523: d_progress := 160;
524: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute ROW_IDENTIFIER : ' || l_attr_row_identifier, d_progress);
525: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute ATTR_NAME : ' || l_attr_name_tab, d_progress);
526: d_progress := 170;
527: IF l_row_identifier = l_attr_row_identifier AND l_attr_name = l_attr_name_tab THEN
528: l_found := TRUE;
521: l_attr_name_tab := l_attr_name_val.ATTR_NAME;
522:
523: d_progress := 160;
524: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute ROW_IDENTIFIER : ' || l_attr_row_identifier, d_progress);
525: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute ATTR_NAME : ' || l_attr_name_tab, d_progress);
526: d_progress := 170;
527: IF l_row_identifier = l_attr_row_identifier AND l_attr_name = l_attr_name_tab THEN
528: l_found := TRUE;
529: d_progress := 180;
526: d_progress := 170;
527: IF l_row_identifier = l_attr_row_identifier AND l_attr_name = l_attr_name_tab THEN
528: l_found := TRUE;
529: d_progress := 180;
530: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute ATTR_NAME : ' || l_attr_name_tab || ' is found ', d_progress);
531: EXIT;
532: END IF;
533: d_progress := 190;
534: l_attr_name_value_index := x_attr_name_value_pairs.NEXT(l_attr_name_value_index);
535: END LOOP;
536: d_progress := 200;
537: IF l_found = FALSE THEN
538: d_progress := 210;
539: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute not found, creating the attribute', d_progress);
540: x_attr_name_value_pairs.EXTEND(1);
541: x_attr_name_value_pairs(x_attr_name_value_pairs.COUNT) := ego_user_attr_data_obj
542: (
543: l_row_identifier
556: END IF;
557: d_progress := 240;
558: ELSE
559: d_progress := 250;
560: PO_UDA_DEFAULTING_PKG.DEBUG('Attribute not found, creating the attribute', d_progress);
561: x_attr_name_value_pairs.EXTEND(1);
562: x_attr_name_value_pairs(x_attr_name_value_pairs.COUNT) := ego_user_attr_data_obj
563: (
564: l_row_identifier
696:
697:
698: BEGIN
699: d_progress := 10;
700: PO_UDA_DEFAULTING_PKG.DEBUG('Starting POPULATE_EMPTY_AGS', d_progress);
701: PO_UDA_DEFAULTING_PKG.DEBUG('p_template_id : ' || p_template_id, d_progress);
702: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk_column_name_value_pairs is as follows', d_progress);
703: PO_UDA_DEFAULTING_PKG.DEBUG(p_pk_column_name_value_pairs, d_progress);
704: PO_UDA_DEFAULTING_PKG.DEBUG('p_external_attr_value_pairs is as follows', d_progress);
697:
698: BEGIN
699: d_progress := 10;
700: PO_UDA_DEFAULTING_PKG.DEBUG('Starting POPULATE_EMPTY_AGS', d_progress);
701: PO_UDA_DEFAULTING_PKG.DEBUG('p_template_id : ' || p_template_id, d_progress);
702: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk_column_name_value_pairs is as follows', d_progress);
703: PO_UDA_DEFAULTING_PKG.DEBUG(p_pk_column_name_value_pairs, d_progress);
704: PO_UDA_DEFAULTING_PKG.DEBUG('p_external_attr_value_pairs is as follows', d_progress);
705: PO_UDA_DEFAULTING_PKG.DEBUG(p_external_attr_value_pairs, d_progress);
698: BEGIN
699: d_progress := 10;
700: PO_UDA_DEFAULTING_PKG.DEBUG('Starting POPULATE_EMPTY_AGS', d_progress);
701: PO_UDA_DEFAULTING_PKG.DEBUG('p_template_id : ' || p_template_id, d_progress);
702: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk_column_name_value_pairs is as follows', d_progress);
703: PO_UDA_DEFAULTING_PKG.DEBUG(p_pk_column_name_value_pairs, d_progress);
704: PO_UDA_DEFAULTING_PKG.DEBUG('p_external_attr_value_pairs is as follows', d_progress);
705: PO_UDA_DEFAULTING_PKG.DEBUG(p_external_attr_value_pairs, d_progress);
706: PO_UDA_DEFAULTING_PKG.DEBUG('p_address_lookup_type : ' || p_address_lookup_type, d_progress);
699: d_progress := 10;
700: PO_UDA_DEFAULTING_PKG.DEBUG('Starting POPULATE_EMPTY_AGS', d_progress);
701: PO_UDA_DEFAULTING_PKG.DEBUG('p_template_id : ' || p_template_id, d_progress);
702: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk_column_name_value_pairs is as follows', d_progress);
703: PO_UDA_DEFAULTING_PKG.DEBUG(p_pk_column_name_value_pairs, d_progress);
704: PO_UDA_DEFAULTING_PKG.DEBUG('p_external_attr_value_pairs is as follows', d_progress);
705: PO_UDA_DEFAULTING_PKG.DEBUG(p_external_attr_value_pairs, d_progress);
706: PO_UDA_DEFAULTING_PKG.DEBUG('p_address_lookup_type : ' || p_address_lookup_type, d_progress);
707: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows', d_progress);
700: PO_UDA_DEFAULTING_PKG.DEBUG('Starting POPULATE_EMPTY_AGS', d_progress);
701: PO_UDA_DEFAULTING_PKG.DEBUG('p_template_id : ' || p_template_id, d_progress);
702: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk_column_name_value_pairs is as follows', d_progress);
703: PO_UDA_DEFAULTING_PKG.DEBUG(p_pk_column_name_value_pairs, d_progress);
704: PO_UDA_DEFAULTING_PKG.DEBUG('p_external_attr_value_pairs is as follows', d_progress);
705: PO_UDA_DEFAULTING_PKG.DEBUG(p_external_attr_value_pairs, d_progress);
706: PO_UDA_DEFAULTING_PKG.DEBUG('p_address_lookup_type : ' || p_address_lookup_type, d_progress);
707: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows', d_progress);
708: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
701: PO_UDA_DEFAULTING_PKG.DEBUG('p_template_id : ' || p_template_id, d_progress);
702: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk_column_name_value_pairs is as follows', d_progress);
703: PO_UDA_DEFAULTING_PKG.DEBUG(p_pk_column_name_value_pairs, d_progress);
704: PO_UDA_DEFAULTING_PKG.DEBUG('p_external_attr_value_pairs is as follows', d_progress);
705: PO_UDA_DEFAULTING_PKG.DEBUG(p_external_attr_value_pairs, d_progress);
706: PO_UDA_DEFAULTING_PKG.DEBUG('p_address_lookup_type : ' || p_address_lookup_type, d_progress);
707: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows', d_progress);
708: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
709: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows', d_progress);
702: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk_column_name_value_pairs is as follows', d_progress);
703: PO_UDA_DEFAULTING_PKG.DEBUG(p_pk_column_name_value_pairs, d_progress);
704: PO_UDA_DEFAULTING_PKG.DEBUG('p_external_attr_value_pairs is as follows', d_progress);
705: PO_UDA_DEFAULTING_PKG.DEBUG(p_external_attr_value_pairs, d_progress);
706: PO_UDA_DEFAULTING_PKG.DEBUG('p_address_lookup_type : ' || p_address_lookup_type, d_progress);
707: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows', d_progress);
708: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
709: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows', d_progress);
710: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
703: PO_UDA_DEFAULTING_PKG.DEBUG(p_pk_column_name_value_pairs, d_progress);
704: PO_UDA_DEFAULTING_PKG.DEBUG('p_external_attr_value_pairs is as follows', d_progress);
705: PO_UDA_DEFAULTING_PKG.DEBUG(p_external_attr_value_pairs, d_progress);
706: PO_UDA_DEFAULTING_PKG.DEBUG('p_address_lookup_type : ' || p_address_lookup_type, d_progress);
707: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows', d_progress);
708: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
709: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows', d_progress);
710: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
711: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows', d_progress);
704: PO_UDA_DEFAULTING_PKG.DEBUG('p_external_attr_value_pairs is as follows', d_progress);
705: PO_UDA_DEFAULTING_PKG.DEBUG(p_external_attr_value_pairs, d_progress);
706: PO_UDA_DEFAULTING_PKG.DEBUG('p_address_lookup_type : ' || p_address_lookup_type, d_progress);
707: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows', d_progress);
708: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
709: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows', d_progress);
710: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
711: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows', d_progress);
712: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
705: PO_UDA_DEFAULTING_PKG.DEBUG(p_external_attr_value_pairs, d_progress);
706: PO_UDA_DEFAULTING_PKG.DEBUG('p_address_lookup_type : ' || p_address_lookup_type, d_progress);
707: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows', d_progress);
708: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
709: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows', d_progress);
710: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
711: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows', d_progress);
712: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
713: d_progress := 20;
706: PO_UDA_DEFAULTING_PKG.DEBUG('p_address_lookup_type : ' || p_address_lookup_type, d_progress);
707: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows', d_progress);
708: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
709: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows', d_progress);
710: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
711: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows', d_progress);
712: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
713: d_progress := 20;
714:
707: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows', d_progress);
708: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
709: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows', d_progress);
710: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
711: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows', d_progress);
712: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
713: d_progress := 20;
714:
715: l_attr_group_table := PO_TBL_NUMBER();
708: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
709: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows', d_progress);
710: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
711: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows', d_progress);
712: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
713: d_progress := 20;
714:
715: l_attr_group_table := PO_TBL_NUMBER();
716: d_progress := 30;
715: l_attr_group_table := PO_TBL_NUMBER();
716: d_progress := 30;
717: IF (x_po_uda_usage_object_array IS NOT NULL AND x_po_uda_usage_object_array.COUNT > 0) THEN
718: d_progress := 40;
719: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array.COUNT :' || x_po_uda_usage_object_array.COUNT, d_progress);
720: l_context_object_index := x_po_uda_usage_object_array.FIRST;
721: d_progress := 50;
722:
723: WHILE (l_context_object_index IS NOT NULL AND l_context_object_index <= x_po_uda_usage_object_array.LAST)
738: d_progress := 120;
739:
740: IF l_attr_group_table(l_attr_group_id_index) IS NOT NULL THEN
741: l_attr_group_id := l_attr_group_table(l_attr_group_id_index);
742: PO_UDA_DEFAULTING_PKG.DEBUG(' l_attr_group_id : ' || l_attr_group_id, d_progress);
743: d_progress := 130;
744: BEGIN
745: d_progress := 140;
746: SELECT DESCRIPTIVE_FLEXFIELD_NAME, DESCRIPTIVE_FLEX_CONTEXT_CODE
748: FROM EGO_FND_DSC_FLX_CTX_EXT
749: WHERE ATTR_GROUP_ID = l_attr_group_id;
750:
751: d_progress := 150;
752: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_type : ' || l_attr_group_type, d_progress);
753: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_name : ' || l_attr_group_name, d_progress);
754: EXCEPTION
755: WHEN OTHERS THEN
756: d_progress := 150;
749: WHERE ATTR_GROUP_ID = l_attr_group_id;
750:
751: d_progress := 150;
752: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_type : ' || l_attr_group_type, d_progress);
753: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_name : ' || l_attr_group_name, d_progress);
754: EXCEPTION
755: WHEN OTHERS THEN
756: d_progress := 150;
757: PO_UDA_DEFAULTING_PKG.DEBUG('Exception while trying to get the l_attr_group_type, l_attr_group_name', d_progress);
753: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_group_name : ' || l_attr_group_name, d_progress);
754: EXCEPTION
755: WHEN OTHERS THEN
756: d_progress := 150;
757: PO_UDA_DEFAULTING_PKG.DEBUG('Exception while trying to get the l_attr_group_type, l_attr_group_name', d_progress);
758: RAISE;
759: END;
760:
761: d_progress := 160;
795: d_progress := 240;
796:
797: -- Not using binds as it would be complicated to put all the checks
798: d_progress := 250;
799: PO_UDA_DEFAULTING_PKG.DEBUG('l_sql_query : ' || l_sql_query, d_progress);
800: PO_UDA_DEFAULTING_PKG.DEBUG('Before executing', d_progress);
801: v_query_hdl := DBMS_SQL.open_cursor;
802: DBMS_SQL.parse(v_query_hdl, l_sql_query, DBMS_SQL.native);
803: DBMS_SQL.define_column(v_query_hdl, 1, l_check);
796:
797: -- Not using binds as it would be complicated to put all the checks
798: d_progress := 250;
799: PO_UDA_DEFAULTING_PKG.DEBUG('l_sql_query : ' || l_sql_query, d_progress);
800: PO_UDA_DEFAULTING_PKG.DEBUG('Before executing', d_progress);
801: v_query_hdl := DBMS_SQL.open_cursor;
802: DBMS_SQL.parse(v_query_hdl, l_sql_query, DBMS_SQL.native);
803: DBMS_SQL.define_column(v_query_hdl, 1, l_check);
804: l_rows_processed := DBMS_SQL.EXECUTE(v_query_hdl);
801: v_query_hdl := DBMS_SQL.open_cursor;
802: DBMS_SQL.parse(v_query_hdl, l_sql_query, DBMS_SQL.native);
803: DBMS_SQL.define_column(v_query_hdl, 1, l_check);
804: l_rows_processed := DBMS_SQL.EXECUTE(v_query_hdl);
805: PO_UDA_DEFAULTING_PKG.DEBUG('After executing l_rows_processed :' || l_rows_processed, d_progress);
806:
807: d_progress := 260;
808: IF DBMS_SQL.fetch_rows(v_query_hdl) <= 0 THEN
809: l_attr_grp_loc_index := x_attributes_row_table.FIRST;
827: d_progress := 310;
828:
829: IF l_present = 0 THEN
830: d_progress := 320;
831: PO_UDA_DEFAULTING_PKG.DEBUG('AG is found :' || l_attr_group_id, d_progress);
832: BEGIN
833: d_progress := 330;
834: SELECT DATA_LEVEL_NAME
835: INTO l_data_level
839: AND DATA_LEVEL_NAME NOT LIKE '%ARCHIVE'
840: AND ATTR_GROUP_TYPE NOT LIKE '%DUMMY%';
841:
842: d_progress := 340;
843: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level : ' || l_data_level, d_progress);
844: EXCEPTION
845: WHEN OTHERS THEN
846: d_progress := 350;
847: PO_UDA_DEFAULTING_PKG.DEBUG('Exception while trying to get the l_data_level', d_progress);
843: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level : ' || l_data_level, d_progress);
844: EXCEPTION
845: WHEN OTHERS THEN
846: d_progress := 350;
847: PO_UDA_DEFAULTING_PKG.DEBUG('Exception while trying to get the l_data_level', d_progress);
848: RAISE;
849: END;
850:
851: d_progress := 360;
860: d_progress := 370;
861: IF l_xd_present <= 0 THEN
862: -- XD Function is not present and the ag need not be added
863: d_progress := 380;
864: PO_UDA_DEFAULTING_PKG.DEBUG('XD function is not found so skipping the AG', d_progress);
865: NULL;
866: ELSIF l_po_uda_usage_object.USAGE_TYPE = 'ADDRESS' THEN -- FOR ADDRESS AGS
867: d_progress := 390;
868: PO_UDA_DEFAULTING_PKG.DEBUG('Usage type is ADDRESS', d_progress);
864: PO_UDA_DEFAULTING_PKG.DEBUG('XD function is not found so skipping the AG', d_progress);
865: NULL;
866: ELSIF l_po_uda_usage_object.USAGE_TYPE = 'ADDRESS' THEN -- FOR ADDRESS AGS
867: d_progress := 390;
868: PO_UDA_DEFAULTING_PKG.DEBUG('Usage type is ADDRESS', d_progress);
869: FOR cur_address_rec IN cur_address(p_address_lookup_type, l_use_mod_addr_type) LOOP
870: BEGIN
871: d_progress := 400;
872: SELECT PO_UDA_INTERFACE_ROW_ID_S.NEXTVAL
873: INTO l_row_identifier
874: FROM DUAL;
875:
876: d_progress := 410;
877: PO_UDA_DEFAULTING_PKG.DEBUG('l_row_identifier : ' || l_row_identifier, d_progress);
878: EXCEPTION
879: WHEN OTHERS THEN
880: d_progress := 420;
881: PO_UDA_DEFAULTING_PKG.DEBUG('Exception while trying to get the l_row_identifier', d_progress);
877: PO_UDA_DEFAULTING_PKG.DEBUG('l_row_identifier : ' || l_row_identifier, d_progress);
878: EXCEPTION
879: WHEN OTHERS THEN
880: d_progress := 420;
881: PO_UDA_DEFAULTING_PKG.DEBUG('Exception while trying to get the l_row_identifier', d_progress);
882: RAISE;
883: END;
884:
885: d_progress := 430;
882: RAISE;
883: END;
884:
885: d_progress := 430;
886: PO_UDA_DEFAULTING_PKG.DEBUG('Before adding AG to attribute row table', d_progress);
887: x_attributes_row_table.EXTEND(1);
888: x_attributes_row_table(x_attributes_row_table.COUNT) := ego_user_attr_row_obj
889: (
890: l_row_identifier
900: ,NULL
901: ,'SYNC'
902: );
903: d_progress := 440;
904: PO_UDA_DEFAULTING_PKG.DEBUG('After adding AG to attribute row table', d_progress);
905:
906: OPEN cur_uda_attributes (l_attr_group_type, l_attr_group_name);
907: LOOP
908: d_progress := 450;
916: INTO l_user_row_identifier
917: FROM DUAL;
918:
919: d_progress := 470;
920: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);
921: EXCEPTION
922: WHEN OTHERS THEN
923: d_progress := 480;
924: PO_UDA_DEFAULTING_PKG.DEBUG('Exception while trying to get the l_user_row_identifier', d_progress);
920: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);
921: EXCEPTION
922: WHEN OTHERS THEN
923: d_progress := 480;
924: PO_UDA_DEFAULTING_PKG.DEBUG('Exception while trying to get the l_user_row_identifier', d_progress);
925: RAISE;
926: END;
927: d_progress := 490;
928: PO_UDA_DEFAULTING_PKG.DEBUG('Before adding attribute', d_progress);
924: PO_UDA_DEFAULTING_PKG.DEBUG('Exception while trying to get the l_user_row_identifier', d_progress);
925: RAISE;
926: END;
927: d_progress := 490;
928: PO_UDA_DEFAULTING_PKG.DEBUG('Before adding attribute', d_progress);
929: x_attr_name_value_pairs.EXTEND(1);
930: d_progress := 500;
931: IF l_attr_col = 'C_EXT_ATTR39' THEN
932: d_progress := 510;
950: ,NULL
951: ,l_user_row_identifier
952: );
953: d_progress := 550;
954: PO_UDA_DEFAULTING_PKG.DEBUG('After adding attribute', d_progress);
955:
956: END LOOP;
957: CLOSE cur_uda_attributes;
958: d_progress := 560;
964: SELECT PO_UDA_INTERFACE_ROW_ID_S.NEXTVAL
965: INTO l_row_identifier
966: FROM DUAL;
967: d_progress := 590;
968: PO_UDA_DEFAULTING_PKG.DEBUG('l_row_identifier : ' || l_row_identifier, d_progress);
969: EXCEPTION
970: WHEN OTHERS THEN
971: d_progress := 600;
972: PO_UDA_DEFAULTING_PKG.DEBUG('Exception while trying to get the l_row_identifier', d_progress);
968: PO_UDA_DEFAULTING_PKG.DEBUG('l_row_identifier : ' || l_row_identifier, d_progress);
969: EXCEPTION
970: WHEN OTHERS THEN
971: d_progress := 600;
972: PO_UDA_DEFAULTING_PKG.DEBUG('Exception while trying to get the l_row_identifier', d_progress);
973: RAISE;
974: END;
975:
976: d_progress := 610;
973: RAISE;
974: END;
975:
976: d_progress := 610;
977: PO_UDA_DEFAULTING_PKG.DEBUG('Before adding AG to attribute row table', d_progress);
978: x_attributes_row_table.EXTEND(1);
979: x_attributes_row_table(x_attributes_row_table.COUNT) := ego_user_attr_row_obj
980: (
981: l_row_identifier
991: ,NULL
992: ,'SYNC'
993: );
994: d_progress := 620;
995: PO_UDA_DEFAULTING_PKG.DEBUG('After adding AG to attribute row table', d_progress);
996:
997: OPEN cur_uda_attributes (l_attr_group_type, l_attr_group_name);
998: LOOP
999: d_progress := 630;
1007: SELECT PO_UDA_INTERFACE_USER_ROW_ID_S.NEXTVAL
1008: INTO l_user_row_identifier
1009: FROM DUAL;
1010: d_progress := 660;
1011: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);
1012: EXCEPTION
1013: WHEN OTHERS THEN
1014: d_progress := 670;
1015: PO_UDA_DEFAULTING_PKG.DEBUG('Exception while trying to get the l_user_row_identifier', d_progress);
1011: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);
1012: EXCEPTION
1013: WHEN OTHERS THEN
1014: d_progress := 670;
1015: PO_UDA_DEFAULTING_PKG.DEBUG('Exception while trying to get the l_user_row_identifier', d_progress);
1016: RAISE;
1017: END;
1018: d_progress := 680;
1019:
1016: RAISE;
1017: END;
1018: d_progress := 680;
1019:
1020: PO_UDA_DEFAULTING_PKG.DEBUG('Before adding AG to attribute row table', d_progress);
1021: x_attr_name_value_pairs.EXTEND(1);
1022: x_attr_name_value_pairs(x_attr_name_value_pairs.COUNT) := ego_user_attr_data_obj
1023: (
1024: l_row_identifier
1030: ,NULL
1031: ,l_user_row_identifier
1032: );
1033: d_progress := 690;
1034: PO_UDA_DEFAULTING_PKG.DEBUG('After adding AG to attribute row table', d_progress);
1035: d_progress := 700;
1036:
1037: END LOOP;
1038: CLOSE cur_uda_attributes;
1058: l_context_object_index := x_po_uda_usage_object_array.NEXT(l_context_object_index);
1059: END LOOP;
1060: ELSE
1061: d_progress := 760;
1062: PO_UDA_DEFAULTING_PKG.DEBUG('USAGE object array does not have any objects', d_progress);
1063: END IF;
1064: d_progress := 770;
1065: x_return_status := FND_API.G_RET_STS_SUCCESS;
1066: EXCEPTION
1093: l_attr_count NUMBER;
1094: l_all_are_null BOOLEAN := TRUE;
1095:
1096: BEGIN
1097: PO_UDA_DEFAULTING_PKG.DEBUG('Starting All_Attr_Values_Are_Null ', 0);
1098: PO_UDA_DEFAULTING_PKG.DEBUG('p_attr_name_value_pairs is as follows ', 0);
1099: PO_UDA_DEFAULTING_PKG.DEBUG(p_attr_name_value_pairs, 0);
1100:
1101: IF (p_attr_name_value_pairs IS NOT NULL AND p_attr_name_value_pairs.COUNT > 0) THEN
1094: l_all_are_null BOOLEAN := TRUE;
1095:
1096: BEGIN
1097: PO_UDA_DEFAULTING_PKG.DEBUG('Starting All_Attr_Values_Are_Null ', 0);
1098: PO_UDA_DEFAULTING_PKG.DEBUG('p_attr_name_value_pairs is as follows ', 0);
1099: PO_UDA_DEFAULTING_PKG.DEBUG(p_attr_name_value_pairs, 0);
1100:
1101: IF (p_attr_name_value_pairs IS NOT NULL AND p_attr_name_value_pairs.COUNT > 0) THEN
1102: l_attr_count := p_attr_name_value_pairs.FIRST;
1095:
1096: BEGIN
1097: PO_UDA_DEFAULTING_PKG.DEBUG('Starting All_Attr_Values_Are_Null ', 0);
1098: PO_UDA_DEFAULTING_PKG.DEBUG('p_attr_name_value_pairs is as follows ', 0);
1099: PO_UDA_DEFAULTING_PKG.DEBUG(p_attr_name_value_pairs, 0);
1100:
1101: IF (p_attr_name_value_pairs IS NOT NULL AND p_attr_name_value_pairs.COUNT > 0) THEN
1102: l_attr_count := p_attr_name_value_pairs.FIRST;
1103: WHILE (l_attr_count <= p_attr_name_value_pairs.LAST)
1210: l_err_txt VARCHAR2(2000);
1211:
1212: BEGIN
1213: d_progress := 10;
1214: PO_UDA_DEFAULTING_PKG.DEBUG('Starting EXECUTE_IMPORT_UDA_FUNCTION', d_progress);
1215: PO_UDA_DEFAULTING_PKG.DEBUG('p_template_id : ' || p_template_id, d_progress);
1216: PO_UDA_DEFAULTING_PKG.DEBUG('p_event : ' || p_event, d_progress);
1217: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows', d_progress);
1218: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1211:
1212: BEGIN
1213: d_progress := 10;
1214: PO_UDA_DEFAULTING_PKG.DEBUG('Starting EXECUTE_IMPORT_UDA_FUNCTION', d_progress);
1215: PO_UDA_DEFAULTING_PKG.DEBUG('p_template_id : ' || p_template_id, d_progress);
1216: PO_UDA_DEFAULTING_PKG.DEBUG('p_event : ' || p_event, d_progress);
1217: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows', d_progress);
1218: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1219: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows', d_progress);
1212: BEGIN
1213: d_progress := 10;
1214: PO_UDA_DEFAULTING_PKG.DEBUG('Starting EXECUTE_IMPORT_UDA_FUNCTION', d_progress);
1215: PO_UDA_DEFAULTING_PKG.DEBUG('p_template_id : ' || p_template_id, d_progress);
1216: PO_UDA_DEFAULTING_PKG.DEBUG('p_event : ' || p_event, d_progress);
1217: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows', d_progress);
1218: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1219: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows', d_progress);
1220: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
1213: d_progress := 10;
1214: PO_UDA_DEFAULTING_PKG.DEBUG('Starting EXECUTE_IMPORT_UDA_FUNCTION', d_progress);
1215: PO_UDA_DEFAULTING_PKG.DEBUG('p_template_id : ' || p_template_id, d_progress);
1216: PO_UDA_DEFAULTING_PKG.DEBUG('p_event : ' || p_event, d_progress);
1217: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows', d_progress);
1218: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1219: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows', d_progress);
1220: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
1221: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows', d_progress);
1214: PO_UDA_DEFAULTING_PKG.DEBUG('Starting EXECUTE_IMPORT_UDA_FUNCTION', d_progress);
1215: PO_UDA_DEFAULTING_PKG.DEBUG('p_template_id : ' || p_template_id, d_progress);
1216: PO_UDA_DEFAULTING_PKG.DEBUG('p_event : ' || p_event, d_progress);
1217: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows', d_progress);
1218: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1219: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows', d_progress);
1220: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
1221: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows', d_progress);
1222: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
1215: PO_UDA_DEFAULTING_PKG.DEBUG('p_template_id : ' || p_template_id, d_progress);
1216: PO_UDA_DEFAULTING_PKG.DEBUG('p_event : ' || p_event, d_progress);
1217: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows', d_progress);
1218: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1219: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows', d_progress);
1220: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
1221: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows', d_progress);
1222: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
1223: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows', d_progress);
1216: PO_UDA_DEFAULTING_PKG.DEBUG('p_event : ' || p_event, d_progress);
1217: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows', d_progress);
1218: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1219: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows', d_progress);
1220: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
1221: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows', d_progress);
1222: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
1223: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows', d_progress);
1224: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
1217: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows', d_progress);
1218: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1219: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows', d_progress);
1220: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
1221: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows', d_progress);
1222: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
1223: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows', d_progress);
1224: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
1225:
1218: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1219: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows', d_progress);
1220: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
1221: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows', d_progress);
1222: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
1223: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows', d_progress);
1224: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
1225:
1226: x_return_status := FND_API.G_RET_STS_SUCCESS;
1219: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows', d_progress);
1220: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
1221: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows', d_progress);
1222: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
1223: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows', d_progress);
1224: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
1225:
1226: x_return_status := FND_API.G_RET_STS_SUCCESS;
1227: g_uda_return_status := FND_API.G_RET_STS_SUCCESS;
1220: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
1221: PO_UDA_DEFAULTING_PKG.DEBUG('x_attr_name_value_pairs is as follows', d_progress);
1222: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
1223: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows', d_progress);
1224: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
1225:
1226: x_return_status := FND_API.G_RET_STS_SUCCESS;
1227: g_uda_return_status := FND_API.G_RET_STS_SUCCESS;
1228: IF (x_attributes_row_table IS NOT NULL AND x_attributes_row_table.COUNT > 0) THEN
1246: WHERE ATTR_GROUP_TYPE = l_attr_row_obj.ATTR_GROUP_TYPE
1247: AND DATA_LEVEL_NAME NOT LIKE '%ARCHIVE';
1248:
1249: d_progress := 80;
1250: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_name : ' || l_data_level_name, d_progress);
1251: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_id : ' || l_data_level_id, d_progress);
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: d_progress := 90;
1247: AND DATA_LEVEL_NAME NOT LIKE '%ARCHIVE';
1248:
1249: d_progress := 80;
1250: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_name : ' || l_data_level_name, d_progress);
1251: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_id : ' || l_data_level_id, d_progress);
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: d_progress := 90;
1255: PO_UDA_DEFAULTING_PKG.DEBUG('Exception while trying to fetch l_data_level_name, l_data_level_id', d_progress);
1251: PO_UDA_DEFAULTING_PKG.DEBUG('l_data_level_id : ' || l_data_level_id, d_progress);
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: d_progress := 90;
1255: PO_UDA_DEFAULTING_PKG.DEBUG('Exception while trying to fetch l_data_level_name, l_data_level_id', d_progress);
1256: END;
1257:
1258: d_progress := 100;
1259: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
1258: d_progress := 100;
1259: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
1260: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
1261: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE(l_attr_row_obj);
1262: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized l_attr_name_value_pairs, l_attributes_row_table', d_progress);
1263:
1264: d_progress := 110;
1265: PO_UDA_DEFAULTING_PKG.DEBUG('Putting all attributes with the ROW_IDENTIFIER (' || l_attr_obj.ROW_IDENTIFIER || ') into another object array', d_progress);
1266: IF (x_attr_name_value_pairs IS NOT NULL AND x_attr_name_value_pairs.COUNT > 0) THEN
1261: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE(l_attr_row_obj);
1262: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized l_attr_name_value_pairs, l_attributes_row_table', d_progress);
1263:
1264: d_progress := 110;
1265: PO_UDA_DEFAULTING_PKG.DEBUG('Putting all attributes with the ROW_IDENTIFIER (' || l_attr_obj.ROW_IDENTIFIER || ') into another object array', d_progress);
1266: IF (x_attr_name_value_pairs IS NOT NULL AND x_attr_name_value_pairs.COUNT > 0) THEN
1267: d_progress := 120;
1268: l_attr_id_index := x_attr_name_value_pairs.FIRST;
1269: d_progress := 130;
1285: l_attr_id_index := x_attr_name_value_pairs.NEXT(l_attr_id_index);
1286: END LOOP;
1287: END IF;
1288: d_progress := 200;
1289: PO_UDA_DEFAULTING_PKG.DEBUG('Object array is constructed', d_progress);
1290:
1291: OPEN c_get_action_id(p_template_id, l_attr_row_obj.ATTR_GROUP_ID, p_event);
1292: LOOP
1293: d_progress := 210;
1295: INTO l_action_id;
1296: EXIT WHEN c_get_action_id%NOTFOUND;
1297: d_progress := 220;
1298:
1299: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION l_action_id : ' || l_action_id, d_progress);
1300: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION l_data_level_name : ' || l_data_level_name, d_progress);
1301: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION l_data_level_id : ' || l_data_level_id, d_progress);
1302: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows :', d_progress);
1303: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
1296: EXIT WHEN c_get_action_id%NOTFOUND;
1297: d_progress := 220;
1298:
1299: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION l_action_id : ' || l_action_id, d_progress);
1300: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION l_data_level_name : ' || l_data_level_name, d_progress);
1301: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION l_data_level_id : ' || l_data_level_id, d_progress);
1302: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows :', d_progress);
1303: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
1304: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows :', d_progress);
1297: d_progress := 220;
1298:
1299: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION l_action_id : ' || l_action_id, d_progress);
1300: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION l_data_level_name : ' || l_data_level_name, d_progress);
1301: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION l_data_level_id : ' || l_data_level_id, d_progress);
1302: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows :', d_progress);
1303: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
1304: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows :', d_progress);
1305: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1298:
1299: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION l_action_id : ' || l_action_id, d_progress);
1300: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION l_data_level_name : ' || l_data_level_name, d_progress);
1301: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION l_data_level_id : ' || l_data_level_id, d_progress);
1302: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows :', d_progress);
1303: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
1304: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows :', d_progress);
1305: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1306: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name_value_pairs is as follows :', d_progress);
1299: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION l_action_id : ' || l_action_id, d_progress);
1300: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION l_data_level_name : ' || l_data_level_name, d_progress);
1301: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION l_data_level_id : ' || l_data_level_id, d_progress);
1302: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows :', d_progress);
1303: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
1304: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows :', d_progress);
1305: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1306: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name_value_pairs is as follows :', d_progress);
1307: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1300: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION l_data_level_name : ' || l_data_level_name, d_progress);
1301: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION l_data_level_id : ' || l_data_level_id, d_progress);
1302: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows :', d_progress);
1303: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
1304: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows :', d_progress);
1305: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1306: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name_value_pairs is as follows :', d_progress);
1307: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1308: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows :', d_progress);
1301: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION l_data_level_id : ' || l_data_level_id, d_progress);
1302: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows :', d_progress);
1303: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
1304: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows :', d_progress);
1305: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1306: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name_value_pairs is as follows :', d_progress);
1307: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1308: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows :', d_progress);
1309: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1302: PO_UDA_DEFAULTING_PKG.DEBUG('x_pk_column_name_value_pairs is as follows :', d_progress);
1303: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
1304: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows :', d_progress);
1305: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1306: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name_value_pairs is as follows :', d_progress);
1307: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1308: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows :', d_progress);
1309: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1310: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION x_return_status :' || x_return_status, d_progress);
1303: PO_UDA_DEFAULTING_PKG.DEBUG(x_pk_column_name_value_pairs, d_progress);
1304: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows :', d_progress);
1305: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1306: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name_value_pairs is as follows :', d_progress);
1307: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1308: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows :', d_progress);
1309: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1310: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION x_return_status :' || x_return_status, d_progress);
1311:
1304: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows :', d_progress);
1305: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1306: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name_value_pairs is as follows :', d_progress);
1307: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1308: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows :', d_progress);
1309: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1310: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION x_return_status :' || x_return_status, d_progress);
1311:
1312: d_progress := 230;
1305: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1306: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name_value_pairs is as follows :', d_progress);
1307: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1308: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows :', d_progress);
1309: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1310: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION x_return_status :' || x_return_status, d_progress);
1311:
1312: d_progress := 230;
1313: EGO_EXT_FWK_PUB.EXECUTE_FUNCTION
1306: PO_UDA_DEFAULTING_PKG.DEBUG('l_attr_name_value_pairs is as follows :', d_progress);
1307: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1308: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows :', d_progress);
1309: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1310: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_EXT_FWK_PUB.EXECUTE_FUNCTION x_return_status :' || x_return_status, d_progress);
1311:
1312: d_progress := 230;
1313: EGO_EXT_FWK_PUB.EXECUTE_FUNCTION
1314: (
1323: ,x_msg_count => x_msg_count
1324: ,x_msg_data => x_msg_data
1325: );
1326: d_progress := 240;
1327: PO_UDA_DEFAULTING_PKG.DEBUG('After EGO_EXT_FWK_PUB.EXECUTE_FUNCTION x_return_status : ' || x_return_status, d_progress);
1328: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode : ' || x_errorcode, d_progress);
1329: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count : ' || x_msg_count, d_progress);
1330: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data : ' || x_msg_data, d_progress);
1331:
1324: ,x_msg_data => x_msg_data
1325: );
1326: d_progress := 240;
1327: PO_UDA_DEFAULTING_PKG.DEBUG('After EGO_EXT_FWK_PUB.EXECUTE_FUNCTION x_return_status : ' || x_return_status, d_progress);
1328: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode : ' || x_errorcode, d_progress);
1329: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count : ' || x_msg_count, d_progress);
1330: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data : ' || x_msg_data, d_progress);
1331:
1332: d_progress := 250;
1325: );
1326: d_progress := 240;
1327: PO_UDA_DEFAULTING_PKG.DEBUG('After EGO_EXT_FWK_PUB.EXECUTE_FUNCTION x_return_status : ' || x_return_status, d_progress);
1328: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode : ' || x_errorcode, d_progress);
1329: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count : ' || x_msg_count, d_progress);
1330: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data : ' || x_msg_data, d_progress);
1331:
1332: d_progress := 250;
1333: PO_UDA_DEFAULTING_PKG.GET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', x_external_attr_value_pairs, ext_name_val_obj);
1326: d_progress := 240;
1327: PO_UDA_DEFAULTING_PKG.DEBUG('After EGO_EXT_FWK_PUB.EXECUTE_FUNCTION x_return_status : ' || x_return_status, d_progress);
1328: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode : ' || x_errorcode, d_progress);
1329: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count : ' || x_msg_count, d_progress);
1330: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data : ' || x_msg_data, d_progress);
1331:
1332: d_progress := 250;
1333: PO_UDA_DEFAULTING_PKG.GET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', x_external_attr_value_pairs, ext_name_val_obj);
1334: uda_return_status := ext_name_val_obj.VALUE ;
1329: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count : ' || x_msg_count, d_progress);
1330: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data : ' || x_msg_data, d_progress);
1331:
1332: d_progress := 250;
1333: PO_UDA_DEFAULTING_PKG.GET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', x_external_attr_value_pairs, ext_name_val_obj);
1334: uda_return_status := ext_name_val_obj.VALUE ;
1335: PO_UDA_DEFAULTING_PKG.GET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_data', x_external_attr_value_pairs, ext_name_val_obj);
1336: uda_msg_data := ext_name_val_obj.VALUE ;
1337:
1331:
1332: d_progress := 250;
1333: PO_UDA_DEFAULTING_PKG.GET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', x_external_attr_value_pairs, ext_name_val_obj);
1334: uda_return_status := ext_name_val_obj.VALUE ;
1335: PO_UDA_DEFAULTING_PKG.GET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_data', x_external_attr_value_pairs, ext_name_val_obj);
1336: uda_msg_data := ext_name_val_obj.VALUE ;
1337:
1338: d_progress := 260;
1339: IF uda_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1346: EXIT;
1347: END IF;
1348:
1349: d_progress := 290;
1350: PO_UDA_DEFAULTING_PKG.DEBUG('Starting Putting back the new object to the old one', d_progress);
1351: IF (l_attr_name_value_pairs IS NOT NULL AND l_attr_name_value_pairs.COUNT > 0) THEN
1352: d_progress := 300;
1353: l_attr_id_index1 := l_attr_name_value_pairs.FIRST;
1354: d_progress := 310;
1387: l_attr_id_index1 := l_attr_name_value_pairs.NEXT(l_attr_id_index1);
1388: END LOOP;
1389: END IF;
1390: d_progress := 400;
1391: PO_UDA_DEFAULTING_PKG.DEBUG('Done Putting back the new object to the old one', d_progress);
1392:
1393: IF (p_event = 'XV') AND (x_external_attr_value_pairs IS NOT NULL AND x_external_attr_value_pairs.COUNT > 0) THEN
1394: d_progress := 410;
1395: PO_UDA_DEFAULTING_PKG.DEBUG('Checking if XV has failed', d_progress);
1391: PO_UDA_DEFAULTING_PKG.DEBUG('Done Putting back the new object to the old one', d_progress);
1392:
1393: IF (p_event = 'XV') AND (x_external_attr_value_pairs IS NOT NULL AND x_external_attr_value_pairs.COUNT > 0) THEN
1394: d_progress := 410;
1395: PO_UDA_DEFAULTING_PKG.DEBUG('Checking if XV has failed', d_progress);
1396: PO_UDA_DEFAULTING_PKG.GET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', x_external_attr_value_pairs, ext_name_val_obj);
1397: x_return_status := ext_name_val_obj.VALUE ;
1398: PO_UDA_DEFAULTING_PKG.DEBUG('Return status for action is ' || x_return_status, d_progress);
1399:
1392:
1393: IF (p_event = 'XV') AND (x_external_attr_value_pairs IS NOT NULL AND x_external_attr_value_pairs.COUNT > 0) THEN
1394: d_progress := 410;
1395: PO_UDA_DEFAULTING_PKG.DEBUG('Checking if XV has failed', d_progress);
1396: PO_UDA_DEFAULTING_PKG.GET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', x_external_attr_value_pairs, ext_name_val_obj);
1397: x_return_status := ext_name_val_obj.VALUE ;
1398: PO_UDA_DEFAULTING_PKG.DEBUG('Return status for action is ' || x_return_status, d_progress);
1399:
1400: d_progress := 420;
1394: d_progress := 410;
1395: PO_UDA_DEFAULTING_PKG.DEBUG('Checking if XV has failed', d_progress);
1396: PO_UDA_DEFAULTING_PKG.GET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', x_external_attr_value_pairs, ext_name_val_obj);
1397: x_return_status := ext_name_val_obj.VALUE ;
1398: PO_UDA_DEFAULTING_PKG.DEBUG('Return status for action is ' || x_return_status, d_progress);
1399:
1400: d_progress := 420;
1401: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1402: d_progress := 43;
1411: END IF;
1412: d_progress := 450;
1413: ELSIF (p_event = 'XD') AND All_Attr_Values_Are_Null (l_attr_name_value_pairs) THEN
1414: d_progress := 460;
1415: PO_UDA_DEFAULTING_PKG.DEBUG('Removing the attributes with value is null', d_progress);
1416: IF (x_attr_name_value_pairs IS NOT NULL AND x_attr_name_value_pairs.COUNT > 0) THEN
1417: l_attr_id_index := x_attr_name_value_pairs.FIRST;
1418: d_progress := 470;
1419: WHILE (l_attr_id_index IS NOT NULL AND l_attr_id_index <= x_attr_name_value_pairs.LAST)
1440: CLOSE c_get_action_id;
1441:
1442: IF g_uda_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1443: d_progress := 540;
1444: PO_UDA_DEFAULTING_PKG.DEBUG('g_uda_return_status is a failure', d_progress);
1445: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', g_uda_return_status, x_external_attr_value_pairs);
1446: END IF;
1447: d_progress := 550;
1448: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1441:
1442: IF g_uda_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1443: d_progress := 540;
1444: PO_UDA_DEFAULTING_PKG.DEBUG('g_uda_return_status is a failure', d_progress);
1445: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', g_uda_return_status, x_external_attr_value_pairs);
1446: END IF;
1447: d_progress := 550;
1448: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1449: PO_UDA_DEFAULTING_PKG.DEBUG('x_return_status is a failure', d_progress);
1445: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', g_uda_return_status, x_external_attr_value_pairs);
1446: END IF;
1447: d_progress := 550;
1448: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1449: PO_UDA_DEFAULTING_PKG.DEBUG('x_return_status is a failure', d_progress);
1450: d_progress := 560;
1451: EXIT;
1452: END IF;
1453: d_progress := 570;
1535: l_err_txt VARCHAR2(2000);
1536:
1537: BEGIN
1538: d_progress := 10;
1539: PO_UDA_DEFAULTING_PKG.DEBUG('Starting IMPORT_UDA_ATTRS', d_progress);
1540: PO_UDA_DEFAULTING_PKG.DEBUG('p_transaction_id '|| p_transaction_id, d_progress);
1541: PO_UDA_DEFAULTING_PKG.DEBUG('p_attr_grp_type : ' || p_attr_grp_type, d_progress);
1542: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk1_value : ' || p_pk1_value, d_progress);
1543: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk2_value : ' || p_pk2_value, d_progress);
1536:
1537: BEGIN
1538: d_progress := 10;
1539: PO_UDA_DEFAULTING_PKG.DEBUG('Starting IMPORT_UDA_ATTRS', d_progress);
1540: PO_UDA_DEFAULTING_PKG.DEBUG('p_transaction_id '|| p_transaction_id, d_progress);
1541: PO_UDA_DEFAULTING_PKG.DEBUG('p_attr_grp_type : ' || p_attr_grp_type, d_progress);
1542: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk1_value : ' || p_pk1_value, d_progress);
1543: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk2_value : ' || p_pk2_value, d_progress);
1544: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk3_value : ' || p_pk3_value, d_progress);
1537: BEGIN
1538: d_progress := 10;
1539: PO_UDA_DEFAULTING_PKG.DEBUG('Starting IMPORT_UDA_ATTRS', d_progress);
1540: PO_UDA_DEFAULTING_PKG.DEBUG('p_transaction_id '|| p_transaction_id, d_progress);
1541: PO_UDA_DEFAULTING_PKG.DEBUG('p_attr_grp_type : ' || p_attr_grp_type, d_progress);
1542: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk1_value : ' || p_pk1_value, d_progress);
1543: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk2_value : ' || p_pk2_value, d_progress);
1544: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk3_value : ' || p_pk3_value, d_progress);
1545: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk4_value : ' || p_pk4_value, d_progress);
1538: d_progress := 10;
1539: PO_UDA_DEFAULTING_PKG.DEBUG('Starting IMPORT_UDA_ATTRS', d_progress);
1540: PO_UDA_DEFAULTING_PKG.DEBUG('p_transaction_id '|| p_transaction_id, d_progress);
1541: PO_UDA_DEFAULTING_PKG.DEBUG('p_attr_grp_type : ' || p_attr_grp_type, d_progress);
1542: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk1_value : ' || p_pk1_value, d_progress);
1543: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk2_value : ' || p_pk2_value, d_progress);
1544: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk3_value : ' || p_pk3_value, d_progress);
1545: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk4_value : ' || p_pk4_value, d_progress);
1546: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk5_value : ' || p_pk5_value, d_progress);
1539: PO_UDA_DEFAULTING_PKG.DEBUG('Starting IMPORT_UDA_ATTRS', d_progress);
1540: PO_UDA_DEFAULTING_PKG.DEBUG('p_transaction_id '|| p_transaction_id, d_progress);
1541: PO_UDA_DEFAULTING_PKG.DEBUG('p_attr_grp_type : ' || p_attr_grp_type, d_progress);
1542: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk1_value : ' || p_pk1_value, d_progress);
1543: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk2_value : ' || p_pk2_value, d_progress);
1544: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk3_value : ' || p_pk3_value, d_progress);
1545: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk4_value : ' || p_pk4_value, d_progress);
1546: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk5_value : ' || p_pk5_value, d_progress);
1547: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows : ', d_progress);
1540: PO_UDA_DEFAULTING_PKG.DEBUG('p_transaction_id '|| p_transaction_id, d_progress);
1541: PO_UDA_DEFAULTING_PKG.DEBUG('p_attr_grp_type : ' || p_attr_grp_type, d_progress);
1542: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk1_value : ' || p_pk1_value, d_progress);
1543: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk2_value : ' || p_pk2_value, d_progress);
1544: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk3_value : ' || p_pk3_value, d_progress);
1545: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk4_value : ' || p_pk4_value, d_progress);
1546: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk5_value : ' || p_pk5_value, d_progress);
1547: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows : ', d_progress);
1548: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
1541: PO_UDA_DEFAULTING_PKG.DEBUG('p_attr_grp_type : ' || p_attr_grp_type, d_progress);
1542: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk1_value : ' || p_pk1_value, d_progress);
1543: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk2_value : ' || p_pk2_value, d_progress);
1544: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk3_value : ' || p_pk3_value, d_progress);
1545: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk4_value : ' || p_pk4_value, d_progress);
1546: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk5_value : ' || p_pk5_value, d_progress);
1547: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows : ', d_progress);
1548: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
1549: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows : ', d_progress);
1542: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk1_value : ' || p_pk1_value, d_progress);
1543: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk2_value : ' || p_pk2_value, d_progress);
1544: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk3_value : ' || p_pk3_value, d_progress);
1545: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk4_value : ' || p_pk4_value, d_progress);
1546: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk5_value : ' || p_pk5_value, d_progress);
1547: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows : ', d_progress);
1548: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
1549: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows : ', d_progress);
1550: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1543: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk2_value : ' || p_pk2_value, d_progress);
1544: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk3_value : ' || p_pk3_value, d_progress);
1545: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk4_value : ' || p_pk4_value, d_progress);
1546: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk5_value : ' || p_pk5_value, d_progress);
1547: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows : ', d_progress);
1548: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
1549: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows : ', d_progress);
1550: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1551: PO_UDA_DEFAULTING_PKG.DEBUG('p_commit_flag : ' || p_commit_flag, d_progress);
1544: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk3_value : ' || p_pk3_value, d_progress);
1545: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk4_value : ' || p_pk4_value, d_progress);
1546: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk5_value : ' || p_pk5_value, d_progress);
1547: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows : ', d_progress);
1548: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
1549: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows : ', d_progress);
1550: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1551: PO_UDA_DEFAULTING_PKG.DEBUG('p_commit_flag : ' || p_commit_flag, d_progress);
1552: d_progress := 20;
1545: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk4_value : ' || p_pk4_value, d_progress);
1546: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk5_value : ' || p_pk5_value, d_progress);
1547: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows : ', d_progress);
1548: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
1549: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows : ', d_progress);
1550: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1551: PO_UDA_DEFAULTING_PKG.DEBUG('p_commit_flag : ' || p_commit_flag, d_progress);
1552: d_progress := 20;
1553:
1546: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk5_value : ' || p_pk5_value, d_progress);
1547: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows : ', d_progress);
1548: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
1549: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows : ', d_progress);
1550: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1551: PO_UDA_DEFAULTING_PKG.DEBUG('p_commit_flag : ' || p_commit_flag, d_progress);
1552: d_progress := 20;
1553:
1554: PO_UDA_DEFAULTING_PKG.DEBUG('Before PO_UDA_IMPORT_PKG.UPDATE_STATUS to change to IN_PROGRESS from PENDING', d_progress);
1547: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows : ', d_progress);
1548: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
1549: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows : ', d_progress);
1550: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1551: PO_UDA_DEFAULTING_PKG.DEBUG('p_commit_flag : ' || p_commit_flag, d_progress);
1552: d_progress := 20;
1553:
1554: PO_UDA_DEFAULTING_PKG.DEBUG('Before PO_UDA_IMPORT_PKG.UPDATE_STATUS to change to IN_PROGRESS from PENDING', d_progress);
1555: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1550: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1551: PO_UDA_DEFAULTING_PKG.DEBUG('p_commit_flag : ' || p_commit_flag, d_progress);
1552: d_progress := 20;
1553:
1554: PO_UDA_DEFAULTING_PKG.DEBUG('Before PO_UDA_IMPORT_PKG.UPDATE_STATUS to change to IN_PROGRESS from PENDING', d_progress);
1555: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1556: (
1557: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1558: ,p_pre_process_status => PO_UDA_IMPORT_PKG.PENDING
1562: ,p_pk3_value => p_pk3_value
1563: ,p_pk4_value => p_pk4_value
1564: ,p_pk5_value => p_pk5_value
1565: );
1566: PO_UDA_DEFAULTING_PKG.DEBUG('After PO_UDA_IMPORT_PKG.UPDATE_STATUS to change to PENDING from IN_PROGRESS', d_progress);
1567:
1568: d_progress := 30;
1569: g_attr_grp_type := p_attr_grp_type;
1570: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
1569: g_attr_grp_type := p_attr_grp_type;
1570: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
1571: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
1572: d_progress := 40;
1573: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized teh objects l_attributes_row_table, l_attr_name_value_pairs', d_progress);
1574:
1575: d_progress := 50;
1576: PO_UDA_DEFAULTING_PKG.DEBUG('Before POPULATE_STRUCTURES ' || x_return_status, d_progress);
1577: PO_UDA_IMPORT_PKG.POPULATE_STRUCTURES
1572: d_progress := 40;
1573: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized teh objects l_attributes_row_table, l_attr_name_value_pairs', d_progress);
1574:
1575: d_progress := 50;
1576: PO_UDA_DEFAULTING_PKG.DEBUG('Before POPULATE_STRUCTURES ' || x_return_status, d_progress);
1577: PO_UDA_IMPORT_PKG.POPULATE_STRUCTURES
1578: (
1579: p_transaction_id => p_transaction_id
1580: ,p_attr_grp_type => p_attr_grp_type
1593: ,x_msg_count => x_msg_count
1594: ,x_msg_data => x_msg_data
1595: );
1596: d_progress := 60;
1597: PO_UDA_DEFAULTING_PKG.DEBUG('After POPULATE_STRUCTURES ' || x_return_status, d_progress);
1598: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1599: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1600: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1601:
1594: ,x_msg_data => x_msg_data
1595: );
1596: d_progress := 60;
1597: PO_UDA_DEFAULTING_PKG.DEBUG('After POPULATE_STRUCTURES ' || x_return_status, d_progress);
1598: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1599: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1600: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1601:
1602: PO_UDA_DEFAULTING_PKG.DEBUG('Template ID is :: ' || l_class_code_name_value_pairs(l_class_code_name_value_pairs.FIRST).VALUE, d_progress);
1595: );
1596: d_progress := 60;
1597: PO_UDA_DEFAULTING_PKG.DEBUG('After POPULATE_STRUCTURES ' || x_return_status, d_progress);
1598: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1599: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1600: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1601:
1602: PO_UDA_DEFAULTING_PKG.DEBUG('Template ID is :: ' || l_class_code_name_value_pairs(l_class_code_name_value_pairs.FIRST).VALUE, d_progress);
1603: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1596: d_progress := 60;
1597: PO_UDA_DEFAULTING_PKG.DEBUG('After POPULATE_STRUCTURES ' || x_return_status, d_progress);
1598: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1599: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1600: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1601:
1602: PO_UDA_DEFAULTING_PKG.DEBUG('Template ID is :: ' || l_class_code_name_value_pairs(l_class_code_name_value_pairs.FIRST).VALUE, d_progress);
1603: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1604: d_progress := 70;
1598: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1599: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1600: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1601:
1602: PO_UDA_DEFAULTING_PKG.DEBUG('Template ID is :: ' || l_class_code_name_value_pairs(l_class_code_name_value_pairs.FIRST).VALUE, d_progress);
1603: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1604: d_progress := 70;
1605: PO_UDA_DEFAULTING_PKG.DEBUG('Before POPULATE_REMAINING_ATTRIBUTES ' || x_return_status, d_progress);
1606: PO_UDA_IMPORT_PKG.POPULATE_REMAINING_ATTRIBUTES
1601:
1602: PO_UDA_DEFAULTING_PKG.DEBUG('Template ID is :: ' || l_class_code_name_value_pairs(l_class_code_name_value_pairs.FIRST).VALUE, d_progress);
1603: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1604: d_progress := 70;
1605: PO_UDA_DEFAULTING_PKG.DEBUG('Before POPULATE_REMAINING_ATTRIBUTES ' || x_return_status, d_progress);
1606: PO_UDA_IMPORT_PKG.POPULATE_REMAINING_ATTRIBUTES
1607: (
1608: x_attr_name_value_pairs => l_attr_name_value_pairs
1609: ,x_attributes_row_table => l_attributes_row_table
1612: ,x_msg_count => x_msg_count
1613: ,x_msg_data => x_msg_data
1614: );
1615: d_progress := 80;
1616: PO_UDA_DEFAULTING_PKG.DEBUG('After POPULATE_REMAINING_ATTRIBUTES ' || x_return_status, d_progress);
1617: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1618: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1619: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1620: ELSE
1613: ,x_msg_data => x_msg_data
1614: );
1615: d_progress := 80;
1616: PO_UDA_DEFAULTING_PKG.DEBUG('After POPULATE_REMAINING_ATTRIBUTES ' || x_return_status, d_progress);
1617: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1618: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1619: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1620: ELSE
1621: d_progress := 90;
1614: );
1615: d_progress := 80;
1616: PO_UDA_DEFAULTING_PKG.DEBUG('After POPULATE_REMAINING_ATTRIBUTES ' || x_return_status, d_progress);
1617: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1618: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1619: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1620: ELSE
1621: d_progress := 90;
1622: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1615: d_progress := 80;
1616: PO_UDA_DEFAULTING_PKG.DEBUG('After POPULATE_REMAINING_ATTRIBUTES ' || x_return_status, d_progress);
1617: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1618: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1619: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1620: ELSE
1621: d_progress := 90;
1622: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1623: (
1642: END IF;
1643: d_progress := 120;
1644: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1645: d_progress := 130;
1646: PO_UDA_DEFAULTING_PKG.DEBUG('Before POPULATE_EMPTY_AGS ' || x_return_status, d_progress);
1647: PO_UDA_IMPORT_PKG.POPULATE_EMPTY_AGS
1648: (
1649: p_template_id => l_class_code_name_value_pairs(l_class_code_name_value_pairs.FIRST).VALUE
1650: ,p_pk_column_name_value_pairs => l_pk_column_name_value_pairs
1657: ,x_msg_count => x_msg_count
1658: ,x_msg_data => x_msg_data
1659: );
1660: d_progress := 140;
1661: PO_UDA_DEFAULTING_PKG.DEBUG('After POPULATE_EMPTY_AGS ' || x_return_status, d_progress);
1662: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1663: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1664: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1665: ELSE
1658: ,x_msg_data => x_msg_data
1659: );
1660: d_progress := 140;
1661: PO_UDA_DEFAULTING_PKG.DEBUG('After POPULATE_EMPTY_AGS ' || x_return_status, d_progress);
1662: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1663: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1664: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1665: ELSE
1666: d_progress := 150;
1659: );
1660: d_progress := 140;
1661: PO_UDA_DEFAULTING_PKG.DEBUG('After POPULATE_EMPTY_AGS ' || x_return_status, d_progress);
1662: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1663: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1664: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1665: ELSE
1666: d_progress := 150;
1667: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1660: d_progress := 140;
1661: PO_UDA_DEFAULTING_PKG.DEBUG('After POPULATE_EMPTY_AGS ' || x_return_status, d_progress);
1662: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1663: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1664: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1665: ELSE
1666: d_progress := 150;
1667: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1668: (
1699: ,p_pk5_value => p_pk5_value
1700: );
1701: d_progress := 190;
1702:
1703: PO_UDA_DEFAULTING_PKG.DEBUG('Before EXECUTE_IMPORT_UDA_FUNCTION (XD) ' || x_return_status, d_progress);
1704: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION
1705: (
1706: p_template_id => l_class_code_name_value_pairs(l_class_code_name_value_pairs.FIRST).VALUE
1707: ,p_event => 'XD'
1714: ,x_msg_count => x_msg_count
1715: ,x_msg_data => x_msg_data
1716: );
1717: d_progress := 200;
1718: PO_UDA_DEFAULTING_PKG.DEBUG('After EXECUTE_IMPORT_UDA_FUNCTION (XD) ' || x_return_status, d_progress);
1719: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1720: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1721: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1722: ELSE
1715: ,x_msg_data => x_msg_data
1716: );
1717: d_progress := 200;
1718: PO_UDA_DEFAULTING_PKG.DEBUG('After EXECUTE_IMPORT_UDA_FUNCTION (XD) ' || x_return_status, d_progress);
1719: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1720: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1721: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1722: ELSE
1723: d_progress := 210;
1716: );
1717: d_progress := 200;
1718: PO_UDA_DEFAULTING_PKG.DEBUG('After EXECUTE_IMPORT_UDA_FUNCTION (XD) ' || x_return_status, d_progress);
1719: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1720: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1721: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1722: ELSE
1723: d_progress := 210;
1724: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1717: d_progress := 200;
1718: PO_UDA_DEFAULTING_PKG.DEBUG('After EXECUTE_IMPORT_UDA_FUNCTION (XD) ' || x_return_status, d_progress);
1719: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1720: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1721: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1722: ELSE
1723: d_progress := 210;
1724: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1725: (
1743: END IF;
1744:
1745: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1746: d_progress := 240;
1747: PO_UDA_DEFAULTING_PKG.DEBUG('Before EXECUTE_IMPORT_UDA_FUNCTION (XLE) ' || x_return_status, d_progress);
1748: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION
1749: (
1750: p_template_id => l_class_code_name_value_pairs(l_class_code_name_value_pairs.FIRST).VALUE
1751: ,p_event => 'XLE'
1758: ,x_msg_count => x_msg_count
1759: ,x_msg_data => x_msg_data
1760: );
1761: d_progress := 250;
1762: PO_UDA_DEFAULTING_PKG.DEBUG('After EXECUTE_IMPORT_UDA_FUNCTION (XLE) ' || x_return_status, d_progress);
1763: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1764: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1765: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1766: ELSE
1759: ,x_msg_data => x_msg_data
1760: );
1761: d_progress := 250;
1762: PO_UDA_DEFAULTING_PKG.DEBUG('After EXECUTE_IMPORT_UDA_FUNCTION (XLE) ' || x_return_status, d_progress);
1763: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1764: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1765: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1766: ELSE
1767: d_progress := 260;
1760: );
1761: d_progress := 250;
1762: PO_UDA_DEFAULTING_PKG.DEBUG('After EXECUTE_IMPORT_UDA_FUNCTION (XLE) ' || x_return_status, d_progress);
1763: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1764: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1765: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1766: ELSE
1767: d_progress := 260;
1768: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1761: d_progress := 250;
1762: PO_UDA_DEFAULTING_PKG.DEBUG('After EXECUTE_IMPORT_UDA_FUNCTION (XLE) ' || x_return_status, d_progress);
1763: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1764: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1765: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1766: ELSE
1767: d_progress := 260;
1768: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1769: (
1805: ,x_msg_data => x_msg_data
1806: );
1807:
1808: d_progress := 285;
1809: PO_UDA_DEFAULTING_PKG.DEBUG('After EXECUTE_IMPORT_UDA_FUNCTION (XPC) ' || x_return_status, d_progress);
1810: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1811: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1812: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1813:
1806: );
1807:
1808: d_progress := 285;
1809: PO_UDA_DEFAULTING_PKG.DEBUG('After EXECUTE_IMPORT_UDA_FUNCTION (XPC) ' || x_return_status, d_progress);
1810: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1811: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1812: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1813:
1814: END IF;
1807:
1808: d_progress := 285;
1809: PO_UDA_DEFAULTING_PKG.DEBUG('After EXECUTE_IMPORT_UDA_FUNCTION (XPC) ' || x_return_status, d_progress);
1810: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1811: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1812: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1813:
1814: END IF;
1815:
1808: d_progress := 285;
1809: PO_UDA_DEFAULTING_PKG.DEBUG('After EXECUTE_IMPORT_UDA_FUNCTION (XPC) ' || x_return_status, d_progress);
1810: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1811: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1812: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1813:
1814: END IF;
1815:
1816: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1827: ,p_pk5_value => p_pk5_value
1828: );
1829: d_progress := 300;
1830:
1831: PO_UDA_DEFAULTING_PKG.DEBUG('Before VALIDATE_ROW ' || x_return_status, d_progress);
1832: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table.COUNT ' || l_attributes_row_table.COUNT, d_progress);
1833: IF l_attributes_row_table.COUNT > 0 THEN
1834: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_USER_ATTRS_DATA_PVT.Process_User_Attrs_Data with parameters ' || x_return_status, d_progress);
1835: PO_UDA_DEFAULTING_PKG.DEBUG('l_base_object_name : ' || l_base_object_name, d_progress);
1828: );
1829: d_progress := 300;
1830:
1831: PO_UDA_DEFAULTING_PKG.DEBUG('Before VALIDATE_ROW ' || x_return_status, d_progress);
1832: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table.COUNT ' || l_attributes_row_table.COUNT, d_progress);
1833: IF l_attributes_row_table.COUNT > 0 THEN
1834: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_USER_ATTRS_DATA_PVT.Process_User_Attrs_Data with parameters ' || x_return_status, d_progress);
1835: PO_UDA_DEFAULTING_PKG.DEBUG('l_base_object_name : ' || l_base_object_name, d_progress);
1836: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows : ', d_progress);
1830:
1831: PO_UDA_DEFAULTING_PKG.DEBUG('Before VALIDATE_ROW ' || x_return_status, d_progress);
1832: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table.COUNT ' || l_attributes_row_table.COUNT, d_progress);
1833: IF l_attributes_row_table.COUNT > 0 THEN
1834: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_USER_ATTRS_DATA_PVT.Process_User_Attrs_Data with parameters ' || x_return_status, d_progress);
1835: PO_UDA_DEFAULTING_PKG.DEBUG('l_base_object_name : ' || l_base_object_name, d_progress);
1836: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows : ', d_progress);
1837: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1838: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_data_table is as follows : ', d_progress);
1831: PO_UDA_DEFAULTING_PKG.DEBUG('Before VALIDATE_ROW ' || x_return_status, d_progress);
1832: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table.COUNT ' || l_attributes_row_table.COUNT, d_progress);
1833: IF l_attributes_row_table.COUNT > 0 THEN
1834: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_USER_ATTRS_DATA_PVT.Process_User_Attrs_Data with parameters ' || x_return_status, d_progress);
1835: PO_UDA_DEFAULTING_PKG.DEBUG('l_base_object_name : ' || l_base_object_name, d_progress);
1836: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows : ', d_progress);
1837: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1838: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_data_table is as follows : ', d_progress);
1839: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1832: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table.COUNT ' || l_attributes_row_table.COUNT, d_progress);
1833: IF l_attributes_row_table.COUNT > 0 THEN
1834: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_USER_ATTRS_DATA_PVT.Process_User_Attrs_Data with parameters ' || x_return_status, d_progress);
1835: PO_UDA_DEFAULTING_PKG.DEBUG('l_base_object_name : ' || l_base_object_name, d_progress);
1836: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows : ', d_progress);
1837: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1838: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_data_table is as follows : ', d_progress);
1839: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1840: PO_UDA_DEFAULTING_PKG.DEBUG('l_pk_column_name_value_pairs is as follows : ', d_progress);
1833: IF l_attributes_row_table.COUNT > 0 THEN
1834: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_USER_ATTRS_DATA_PVT.Process_User_Attrs_Data with parameters ' || x_return_status, d_progress);
1835: PO_UDA_DEFAULTING_PKG.DEBUG('l_base_object_name : ' || l_base_object_name, d_progress);
1836: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows : ', d_progress);
1837: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1838: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_data_table is as follows : ', d_progress);
1839: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1840: PO_UDA_DEFAULTING_PKG.DEBUG('l_pk_column_name_value_pairs is as follows : ', d_progress);
1841: PO_UDA_DEFAULTING_PKG.DEBUG(l_pk_column_name_value_pairs, d_progress);
1834: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_USER_ATTRS_DATA_PVT.Process_User_Attrs_Data with parameters ' || x_return_status, d_progress);
1835: PO_UDA_DEFAULTING_PKG.DEBUG('l_base_object_name : ' || l_base_object_name, d_progress);
1836: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows : ', d_progress);
1837: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1838: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_data_table is as follows : ', d_progress);
1839: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1840: PO_UDA_DEFAULTING_PKG.DEBUG('l_pk_column_name_value_pairs is as follows : ', d_progress);
1841: PO_UDA_DEFAULTING_PKG.DEBUG(l_pk_column_name_value_pairs, d_progress);
1842: PO_UDA_DEFAULTING_PKG.DEBUG('l_class_code_name_value_pairs is as follows : ', d_progress);
1835: PO_UDA_DEFAULTING_PKG.DEBUG('l_base_object_name : ' || l_base_object_name, d_progress);
1836: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows : ', d_progress);
1837: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1838: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_data_table is as follows : ', d_progress);
1839: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1840: PO_UDA_DEFAULTING_PKG.DEBUG('l_pk_column_name_value_pairs is as follows : ', d_progress);
1841: PO_UDA_DEFAULTING_PKG.DEBUG(l_pk_column_name_value_pairs, d_progress);
1842: PO_UDA_DEFAULTING_PKG.DEBUG('l_class_code_name_value_pairs is as follows : ', d_progress);
1843: PO_UDA_DEFAULTING_PKG.DEBUG(l_class_code_name_value_pairs, d_progress);
1836: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows : ', d_progress);
1837: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1838: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_data_table is as follows : ', d_progress);
1839: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1840: PO_UDA_DEFAULTING_PKG.DEBUG('l_pk_column_name_value_pairs is as follows : ', d_progress);
1841: PO_UDA_DEFAULTING_PKG.DEBUG(l_pk_column_name_value_pairs, d_progress);
1842: PO_UDA_DEFAULTING_PKG.DEBUG('l_class_code_name_value_pairs is as follows : ', d_progress);
1843: PO_UDA_DEFAULTING_PKG.DEBUG(l_class_code_name_value_pairs, d_progress);
1844: d_progress := 310;
1837: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1838: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_data_table is as follows : ', d_progress);
1839: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1840: PO_UDA_DEFAULTING_PKG.DEBUG('l_pk_column_name_value_pairs is as follows : ', d_progress);
1841: PO_UDA_DEFAULTING_PKG.DEBUG(l_pk_column_name_value_pairs, d_progress);
1842: PO_UDA_DEFAULTING_PKG.DEBUG('l_class_code_name_value_pairs is as follows : ', d_progress);
1843: PO_UDA_DEFAULTING_PKG.DEBUG(l_class_code_name_value_pairs, d_progress);
1844: d_progress := 310;
1845:
1838: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_data_table is as follows : ', d_progress);
1839: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1840: PO_UDA_DEFAULTING_PKG.DEBUG('l_pk_column_name_value_pairs is as follows : ', d_progress);
1841: PO_UDA_DEFAULTING_PKG.DEBUG(l_pk_column_name_value_pairs, d_progress);
1842: PO_UDA_DEFAULTING_PKG.DEBUG('l_class_code_name_value_pairs is as follows : ', d_progress);
1843: PO_UDA_DEFAULTING_PKG.DEBUG(l_class_code_name_value_pairs, d_progress);
1844: d_progress := 310;
1845:
1846: EGO_USER_ATTRS_DATA_PVT.Process_User_Attrs_Data
1839: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1840: PO_UDA_DEFAULTING_PKG.DEBUG('l_pk_column_name_value_pairs is as follows : ', d_progress);
1841: PO_UDA_DEFAULTING_PKG.DEBUG(l_pk_column_name_value_pairs, d_progress);
1842: PO_UDA_DEFAULTING_PKG.DEBUG('l_class_code_name_value_pairs is as follows : ', d_progress);
1843: PO_UDA_DEFAULTING_PKG.DEBUG(l_class_code_name_value_pairs, d_progress);
1844: d_progress := 310;
1845:
1846: EGO_USER_ATTRS_DATA_PVT.Process_User_Attrs_Data
1847: (
1859: ,x_msg_data => x_msg_data
1860: );
1861: d_progress := 320;
1862: END IF;
1863: PO_UDA_DEFAULTING_PKG.DEBUG('After VALIDATE_ROW ' || x_return_status, d_progress);
1864: PO_UDA_DEFAULTING_PKG.DEBUG('l_failed_row_id_list is : ' || l_failed_row_id_list, d_progress);
1865: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1866: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1867: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1860: );
1861: d_progress := 320;
1862: END IF;
1863: PO_UDA_DEFAULTING_PKG.DEBUG('After VALIDATE_ROW ' || x_return_status, d_progress);
1864: PO_UDA_DEFAULTING_PKG.DEBUG('l_failed_row_id_list is : ' || l_failed_row_id_list, d_progress);
1865: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1866: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1867: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1868: d_progress := 330;
1861: d_progress := 320;
1862: END IF;
1863: PO_UDA_DEFAULTING_PKG.DEBUG('After VALIDATE_ROW ' || x_return_status, d_progress);
1864: PO_UDA_DEFAULTING_PKG.DEBUG('l_failed_row_id_list is : ' || l_failed_row_id_list, d_progress);
1865: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1866: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1867: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1868: d_progress := 330;
1869: ELSE
1862: END IF;
1863: PO_UDA_DEFAULTING_PKG.DEBUG('After VALIDATE_ROW ' || x_return_status, d_progress);
1864: PO_UDA_DEFAULTING_PKG.DEBUG('l_failed_row_id_list is : ' || l_failed_row_id_list, d_progress);
1865: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1866: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1867: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1868: d_progress := 330;
1869: ELSE
1870: d_progress := 340;
1863: PO_UDA_DEFAULTING_PKG.DEBUG('After VALIDATE_ROW ' || x_return_status, d_progress);
1864: PO_UDA_DEFAULTING_PKG.DEBUG('l_failed_row_id_list is : ' || l_failed_row_id_list, d_progress);
1865: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1866: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1867: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1868: d_progress := 330;
1869: ELSE
1870: d_progress := 340;
1871: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1910: x_external_attr_value_pairs := EGO_COL_NAME_VALUE_PAIR_TABLE();
1911: END IF;
1912: d_progress := 410;
1913:
1914: PO_UDA_DEFAULTING_PKG.DEBUG('Before EXECUTE_IMPORT_UDA_FUNCTION (XV) ' || x_return_status, d_progress);
1915: IF l_attributes_row_table.COUNT > 0 THEN
1916: d_progress := 420;
1917: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION
1918: (
1929: );
1930: d_progress := 430;
1931: END IF;
1932:
1933: PO_UDA_DEFAULTING_PKG.DEBUG('After EXECUTE_IMPORT_UDA_FUNCTION (XV) ' || x_return_status, d_progress);
1934: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1935: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1936: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1937: d_progress := 440;
1930: d_progress := 430;
1931: END IF;
1932:
1933: PO_UDA_DEFAULTING_PKG.DEBUG('After EXECUTE_IMPORT_UDA_FUNCTION (XV) ' || x_return_status, d_progress);
1934: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1935: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1936: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1937: d_progress := 440;
1938:
1931: END IF;
1932:
1933: PO_UDA_DEFAULTING_PKG.DEBUG('After EXECUTE_IMPORT_UDA_FUNCTION (XV) ' || x_return_status, d_progress);
1934: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1935: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1936: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1937: d_progress := 440;
1938:
1939: ELSE
1932:
1933: PO_UDA_DEFAULTING_PKG.DEBUG('After EXECUTE_IMPORT_UDA_FUNCTION (XV) ' || x_return_status, d_progress);
1934: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
1935: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1936: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1937: d_progress := 440;
1938:
1939: ELSE
1940: d_progress := 450;
1974: ,p_pk5_value => p_pk5_value
1975: );
1976: d_progress := 490;
1977:
1978: PO_UDA_DEFAULTING_PKG.DEBUG('Before Process_User_Attrs_Data ' || x_return_status, d_progress);
1979: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table.COUNT ' || l_attributes_row_table.COUNT, d_progress);
1980: IF l_attributes_row_table.COUNT > 0 THEN
1981: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data with parameters ' || x_return_status, d_progress);
1982: PO_UDA_DEFAULTING_PKG.DEBUG('l_base_object_name : ' || l_base_object_name, d_progress);
1975: );
1976: d_progress := 490;
1977:
1978: PO_UDA_DEFAULTING_PKG.DEBUG('Before Process_User_Attrs_Data ' || x_return_status, d_progress);
1979: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table.COUNT ' || l_attributes_row_table.COUNT, d_progress);
1980: IF l_attributes_row_table.COUNT > 0 THEN
1981: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data with parameters ' || x_return_status, d_progress);
1982: PO_UDA_DEFAULTING_PKG.DEBUG('l_base_object_name : ' || l_base_object_name, d_progress);
1983: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows : ', d_progress);
1977:
1978: PO_UDA_DEFAULTING_PKG.DEBUG('Before Process_User_Attrs_Data ' || x_return_status, d_progress);
1979: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table.COUNT ' || l_attributes_row_table.COUNT, d_progress);
1980: IF l_attributes_row_table.COUNT > 0 THEN
1981: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data with parameters ' || x_return_status, d_progress);
1982: PO_UDA_DEFAULTING_PKG.DEBUG('l_base_object_name : ' || l_base_object_name, d_progress);
1983: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows : ', d_progress);
1984: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1985: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_data_table is as follows : ', d_progress);
1978: PO_UDA_DEFAULTING_PKG.DEBUG('Before Process_User_Attrs_Data ' || x_return_status, d_progress);
1979: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table.COUNT ' || l_attributes_row_table.COUNT, d_progress);
1980: IF l_attributes_row_table.COUNT > 0 THEN
1981: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data with parameters ' || x_return_status, d_progress);
1982: PO_UDA_DEFAULTING_PKG.DEBUG('l_base_object_name : ' || l_base_object_name, d_progress);
1983: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows : ', d_progress);
1984: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1985: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_data_table is as follows : ', d_progress);
1986: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1979: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table.COUNT ' || l_attributes_row_table.COUNT, d_progress);
1980: IF l_attributes_row_table.COUNT > 0 THEN
1981: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data with parameters ' || x_return_status, d_progress);
1982: PO_UDA_DEFAULTING_PKG.DEBUG('l_base_object_name : ' || l_base_object_name, d_progress);
1983: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows : ', d_progress);
1984: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1985: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_data_table is as follows : ', d_progress);
1986: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1987: PO_UDA_DEFAULTING_PKG.DEBUG('l_pk_column_name_value_pairs is as follows : ', d_progress);
1980: IF l_attributes_row_table.COUNT > 0 THEN
1981: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data with parameters ' || x_return_status, d_progress);
1982: PO_UDA_DEFAULTING_PKG.DEBUG('l_base_object_name : ' || l_base_object_name, d_progress);
1983: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows : ', d_progress);
1984: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1985: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_data_table is as follows : ', d_progress);
1986: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1987: PO_UDA_DEFAULTING_PKG.DEBUG('l_pk_column_name_value_pairs is as follows : ', d_progress);
1988: PO_UDA_DEFAULTING_PKG.DEBUG(l_pk_column_name_value_pairs, d_progress);
1981: PO_UDA_DEFAULTING_PKG.DEBUG('Before EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data with parameters ' || x_return_status, d_progress);
1982: PO_UDA_DEFAULTING_PKG.DEBUG('l_base_object_name : ' || l_base_object_name, d_progress);
1983: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows : ', d_progress);
1984: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1985: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_data_table is as follows : ', d_progress);
1986: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1987: PO_UDA_DEFAULTING_PKG.DEBUG('l_pk_column_name_value_pairs is as follows : ', d_progress);
1988: PO_UDA_DEFAULTING_PKG.DEBUG(l_pk_column_name_value_pairs, d_progress);
1989: PO_UDA_DEFAULTING_PKG.DEBUG('l_class_code_name_value_pairs is as follows : ', d_progress);
1982: PO_UDA_DEFAULTING_PKG.DEBUG('l_base_object_name : ' || l_base_object_name, d_progress);
1983: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows : ', d_progress);
1984: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1985: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_data_table is as follows : ', d_progress);
1986: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1987: PO_UDA_DEFAULTING_PKG.DEBUG('l_pk_column_name_value_pairs is as follows : ', d_progress);
1988: PO_UDA_DEFAULTING_PKG.DEBUG(l_pk_column_name_value_pairs, d_progress);
1989: PO_UDA_DEFAULTING_PKG.DEBUG('l_class_code_name_value_pairs is as follows : ', d_progress);
1990: PO_UDA_DEFAULTING_PKG.DEBUG(l_class_code_name_value_pairs, d_progress);
1983: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table is as follows : ', d_progress);
1984: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1985: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_data_table is as follows : ', d_progress);
1986: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1987: PO_UDA_DEFAULTING_PKG.DEBUG('l_pk_column_name_value_pairs is as follows : ', d_progress);
1988: PO_UDA_DEFAULTING_PKG.DEBUG(l_pk_column_name_value_pairs, d_progress);
1989: PO_UDA_DEFAULTING_PKG.DEBUG('l_class_code_name_value_pairs is as follows : ', d_progress);
1990: PO_UDA_DEFAULTING_PKG.DEBUG(l_class_code_name_value_pairs, d_progress);
1991: d_progress := 500;
1984: PO_UDA_DEFAULTING_PKG.DEBUG(l_attributes_row_table, d_progress);
1985: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_data_table is as follows : ', d_progress);
1986: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1987: PO_UDA_DEFAULTING_PKG.DEBUG('l_pk_column_name_value_pairs is as follows : ', d_progress);
1988: PO_UDA_DEFAULTING_PKG.DEBUG(l_pk_column_name_value_pairs, d_progress);
1989: PO_UDA_DEFAULTING_PKG.DEBUG('l_class_code_name_value_pairs is as follows : ', d_progress);
1990: PO_UDA_DEFAULTING_PKG.DEBUG(l_class_code_name_value_pairs, d_progress);
1991: d_progress := 500;
1992: EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data
1985: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_data_table is as follows : ', d_progress);
1986: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1987: PO_UDA_DEFAULTING_PKG.DEBUG('l_pk_column_name_value_pairs is as follows : ', d_progress);
1988: PO_UDA_DEFAULTING_PKG.DEBUG(l_pk_column_name_value_pairs, d_progress);
1989: PO_UDA_DEFAULTING_PKG.DEBUG('l_class_code_name_value_pairs is as follows : ', d_progress);
1990: PO_UDA_DEFAULTING_PKG.DEBUG(l_class_code_name_value_pairs, d_progress);
1991: d_progress := 500;
1992: EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data
1993: (
1986: PO_UDA_DEFAULTING_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1987: PO_UDA_DEFAULTING_PKG.DEBUG('l_pk_column_name_value_pairs is as follows : ', d_progress);
1988: PO_UDA_DEFAULTING_PKG.DEBUG(l_pk_column_name_value_pairs, d_progress);
1989: PO_UDA_DEFAULTING_PKG.DEBUG('l_class_code_name_value_pairs is as follows : ', d_progress);
1990: PO_UDA_DEFAULTING_PKG.DEBUG(l_class_code_name_value_pairs, d_progress);
1991: d_progress := 500;
1992: EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data
1993: (
1994: p_api_version => 1.0
2005: );
2006: d_progress := 510;
2007: END IF;
2008:
2009: PO_UDA_DEFAULTING_PKG.DEBUG('After Process_User_Attrs_Data ' || x_return_status, d_progress);
2010: PO_UDA_DEFAULTING_PKG.DEBUG('l_failed_row_id_list is : ' || l_failed_row_id_list, d_progress);
2011: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
2012: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
2013: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
2006: d_progress := 510;
2007: END IF;
2008:
2009: PO_UDA_DEFAULTING_PKG.DEBUG('After Process_User_Attrs_Data ' || x_return_status, d_progress);
2010: PO_UDA_DEFAULTING_PKG.DEBUG('l_failed_row_id_list is : ' || l_failed_row_id_list, d_progress);
2011: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
2012: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
2013: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
2014: d_progress := 520;
2007: END IF;
2008:
2009: PO_UDA_DEFAULTING_PKG.DEBUG('After Process_User_Attrs_Data ' || x_return_status, d_progress);
2010: PO_UDA_DEFAULTING_PKG.DEBUG('l_failed_row_id_list is : ' || l_failed_row_id_list, d_progress);
2011: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
2012: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
2013: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
2014: d_progress := 520;
2015: ELSE
2008:
2009: PO_UDA_DEFAULTING_PKG.DEBUG('After Process_User_Attrs_Data ' || x_return_status, d_progress);
2010: PO_UDA_DEFAULTING_PKG.DEBUG('l_failed_row_id_list is : ' || l_failed_row_id_list, d_progress);
2011: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
2012: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
2013: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
2014: d_progress := 520;
2015: ELSE
2016: d_progress := 530;
2009: PO_UDA_DEFAULTING_PKG.DEBUG('After Process_User_Attrs_Data ' || x_return_status, d_progress);
2010: PO_UDA_DEFAULTING_PKG.DEBUG('l_failed_row_id_list is : ' || l_failed_row_id_list, d_progress);
2011: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
2012: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
2013: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
2014: d_progress := 520;
2015: ELSE
2016: d_progress := 530;
2017: PO_UDA_IMPORT_PKG.UPDATE_STATUS
2036: END IF;
2037:
2038: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2039: d_progress := 560;
2040: PO_UDA_DEFAULTING_PKG.DEBUG('Before EXECUTE_IMPORT_UDA_FUNCTION (XPD) ' || x_return_status, d_progress);
2041: IF l_attributes_row_table.COUNT > 0 THEN
2042: d_progress := 570;
2043: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION
2044: (
2055: );
2056: d_progress := 580;
2057: END IF;
2058:
2059: PO_UDA_DEFAULTING_PKG.DEBUG('After EXECUTE_IMPORT_UDA_FUNCTION (XPD) ' || x_return_status, d_progress);
2060: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
2061: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
2062: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
2063: d_progress := 590;
2056: d_progress := 580;
2057: END IF;
2058:
2059: PO_UDA_DEFAULTING_PKG.DEBUG('After EXECUTE_IMPORT_UDA_FUNCTION (XPD) ' || x_return_status, d_progress);
2060: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
2061: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
2062: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
2063: d_progress := 590;
2064: ELSE
2057: END IF;
2058:
2059: PO_UDA_DEFAULTING_PKG.DEBUG('After EXECUTE_IMPORT_UDA_FUNCTION (XPD) ' || x_return_status, d_progress);
2060: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
2061: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
2062: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
2063: d_progress := 590;
2064: ELSE
2065: d_progress := 600;
2058:
2059: PO_UDA_DEFAULTING_PKG.DEBUG('After EXECUTE_IMPORT_UDA_FUNCTION (XPD) ' || x_return_status, d_progress);
2060: PO_UDA_DEFAULTING_PKG.DEBUG('x_errorcode ' || x_errorcode, d_progress);
2061: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
2062: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
2063: d_progress := 590;
2064: ELSE
2065: d_progress := 600;
2066: PO_UDA_IMPORT_PKG.UPDATE_STATUS
2142: X_table_name => NULL,
2143: X_batch_id => p_attr_grp_id
2144: );
2145: else
2146: PO_UDA_DEFAULTING_PKG.DEBUG ('IN HANDLE ERROR : '||p_msg ||' code ' ||p_msg_code ||' for attr grp id '||p_attr_grp_id, 0);
2147: end if;
2148:
2149: END HANDLE_ERROR;
2150:
2251: FROM po_headers_draft_all
2252: WHERE po_header_id = p_header_id
2253: AND draft_id = p_draft_id;
2254:
2255: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR( p_ext_attr_name => 'ORG_ID',
2256: p_ext_attr_value => l_org_id,
2257: x_external_attr_value_pairs => x_external_attr_value_pairs
2258: );
2259: