94: WHERE rowid = p_row_id;
95: END IF;
96: EXCEPTION
97: WHEN NO_DATA_FOUND THEN
98: arp_standard.debug('No data found in RA_CUSTOMERS_INTERFACE View');
99: WHEN OTHERS THEN
100: arp_standard.debug('Exception in JG_GLOBE_FLEX_VAL1.UPDATE_RA_CUSTOMERS_INTERFACE()');
101: arp_standard.debug(SQLERRM);
102: END update_ra_customers_interface;
96: EXCEPTION
97: WHEN NO_DATA_FOUND THEN
98: arp_standard.debug('No data found in RA_CUSTOMERS_INTERFACE View');
99: WHEN OTHERS THEN
100: arp_standard.debug('Exception in JG_GLOBE_FLEX_VAL1.UPDATE_RA_CUSTOMERS_INTERFACE()');
101: arp_standard.debug(SQLERRM);
102: END update_ra_customers_interface;
103:
104: ---------------------------------------------------------------------------
97: WHEN NO_DATA_FOUND THEN
98: arp_standard.debug('No data found in RA_CUSTOMERS_INTERFACE View');
99: WHEN OTHERS THEN
100: arp_standard.debug('Exception in JG_GLOBE_FLEX_VAL1.UPDATE_RA_CUSTOMERS_INTERFACE()');
101: arp_standard.debug(SQLERRM);
102: END update_ra_customers_interface;
103:
104: ---------------------------------------------------------------------------
105: -- UPDATE_INTERFACE_STATUS():
219: END IF;
220: END IF;
221: EXCEPTION
222: WHEN Invalid_Table THEN
223: arp_standard.debug(SQLERRM);
224: arp_standard.debug('Invalid Table Name: ' || l_table_name);
225: RAISE;
226: WHEN OTHERS THEN
227: arp_standard.debug(SQLERRM);
220: END IF;
221: EXCEPTION
222: WHEN Invalid_Table THEN
223: arp_standard.debug(SQLERRM);
224: arp_standard.debug('Invalid Table Name: ' || l_table_name);
225: RAISE;
226: WHEN OTHERS THEN
227: arp_standard.debug(SQLERRM);
228: arp_standard.debug(l_sql_stmt);
223: arp_standard.debug(SQLERRM);
224: arp_standard.debug('Invalid Table Name: ' || l_table_name);
225: RAISE;
226: WHEN OTHERS THEN
227: arp_standard.debug(SQLERRM);
228: arp_standard.debug(l_sql_stmt);
229: RAISE;
230: END;
231:
224: arp_standard.debug('Invalid Table Name: ' || l_table_name);
225: RAISE;
226: WHEN OTHERS THEN
227: arp_standard.debug(SQLERRM);
228: arp_standard.debug(l_sql_stmt);
229: RAISE;
230: END;
231:
232: ---------------------------------------------------------------------------