88: AND nvl(a.invoice_transaction_id,0) =
89: nvl(p_invoice_transaction_id,0);
90: EXCEPTION
91: WHEN OTHERS THEN
92: fnd_message.set_name('OFA','FA_MRC_UPD_MC_RECS');
93: fnd_message.set_token('TABLE', 'fa_mc_books_rates');
94: fnd_message.set_token('TRIGGER',
95: 'fa_mc_asset_invoices_aid');
96: fnd_message.set_token('ERROR',sqlerrm);
89: nvl(p_invoice_transaction_id,0);
90: EXCEPTION
91: WHEN OTHERS THEN
92: fnd_message.set_name('OFA','FA_MRC_UPD_MC_RECS');
93: fnd_message.set_token('TABLE', 'fa_mc_books_rates');
94: fnd_message.set_token('TRIGGER',
95: 'fa_mc_asset_invoices_aid');
96: fnd_message.set_token('ERROR',sqlerrm);
97: raise_application_error(-20000,fnd_message.get);
90: EXCEPTION
91: WHEN OTHERS THEN
92: fnd_message.set_name('OFA','FA_MRC_UPD_MC_RECS');
93: fnd_message.set_token('TABLE', 'fa_mc_books_rates');
94: fnd_message.set_token('TRIGGER',
95: 'fa_mc_asset_invoices_aid');
96: fnd_message.set_token('ERROR',sqlerrm);
97: raise_application_error(-20000,fnd_message.get);
98: END;
92: fnd_message.set_name('OFA','FA_MRC_UPD_MC_RECS');
93: fnd_message.set_token('TABLE', 'fa_mc_books_rates');
94: fnd_message.set_token('TRIGGER',
95: 'fa_mc_asset_invoices_aid');
96: fnd_message.set_token('ERROR',sqlerrm);
97: raise_application_error(-20000,fnd_message.get);
98: END;
99: WHEN OTHERS THEN
100: fnd_message.set_name('OFA', 'FA_MRC_INS_MC_RECS');
93: fnd_message.set_token('TABLE', 'fa_mc_books_rates');
94: fnd_message.set_token('TRIGGER',
95: 'fa_mc_asset_invoices_aid');
96: fnd_message.set_token('ERROR',sqlerrm);
97: raise_application_error(-20000,fnd_message.get);
98: END;
99: WHEN OTHERS THEN
100: fnd_message.set_name('OFA', 'FA_MRC_INS_MC_RECS');
101: fnd_message.set_token('TABLE', 'fa_mc_books_rates');
96: fnd_message.set_token('ERROR',sqlerrm);
97: raise_application_error(-20000,fnd_message.get);
98: END;
99: WHEN OTHERS THEN
100: fnd_message.set_name('OFA', 'FA_MRC_INS_MC_RECS');
101: fnd_message.set_token('TABLE', 'fa_mc_books_rates');
102: fnd_message.set_token('TRIGGER', p_trigger);
103: fnd_message.set_token('ERROR',sqlerrm);
104: raise_application_error(-20000,fnd_message.get);
97: raise_application_error(-20000,fnd_message.get);
98: END;
99: WHEN OTHERS THEN
100: fnd_message.set_name('OFA', 'FA_MRC_INS_MC_RECS');
101: fnd_message.set_token('TABLE', 'fa_mc_books_rates');
102: fnd_message.set_token('TRIGGER', p_trigger);
103: fnd_message.set_token('ERROR',sqlerrm);
104: raise_application_error(-20000,fnd_message.get);
105: END;
98: END;
99: WHEN OTHERS THEN
100: fnd_message.set_name('OFA', 'FA_MRC_INS_MC_RECS');
101: fnd_message.set_token('TABLE', 'fa_mc_books_rates');
102: fnd_message.set_token('TRIGGER', p_trigger);
103: fnd_message.set_token('ERROR',sqlerrm);
104: raise_application_error(-20000,fnd_message.get);
105: END;
106:
99: WHEN OTHERS THEN
100: fnd_message.set_name('OFA', 'FA_MRC_INS_MC_RECS');
101: fnd_message.set_token('TABLE', 'fa_mc_books_rates');
102: fnd_message.set_token('TRIGGER', p_trigger);
103: fnd_message.set_token('ERROR',sqlerrm);
104: raise_application_error(-20000,fnd_message.get);
105: END;
106:
107: PROCEDURE get_rate
100: fnd_message.set_name('OFA', 'FA_MRC_INS_MC_RECS');
101: fnd_message.set_token('TABLE', 'fa_mc_books_rates');
102: fnd_message.set_token('TRIGGER', p_trigger);
103: fnd_message.set_token('ERROR',sqlerrm);
104: raise_application_error(-20000,fnd_message.get);
105: END;
106:
107: PROCEDURE get_rate
108: (p_set_of_books_id in number,
126: WHEN NO_DATA_FOUND THEN
127: p_complete := 'N';
128: p_result_code := 'NOT_FOUND';
129: WHEN OTHERS THEN
130: fnd_message.set_name('OFA','FA_MRC_GET_RATE');
131: fnd_message.set_token('ERROR',sqlerrm);
132: raise_application_error(-20000,fnd_message.get);
133: END;
134:
127: p_complete := 'N';
128: p_result_code := 'NOT_FOUND';
129: WHEN OTHERS THEN
130: fnd_message.set_name('OFA','FA_MRC_GET_RATE');
131: fnd_message.set_token('ERROR',sqlerrm);
132: raise_application_error(-20000,fnd_message.get);
133: END;
134:
135: END MC_FA_UTILITIES_PKG;
128: p_result_code := 'NOT_FOUND';
129: WHEN OTHERS THEN
130: fnd_message.set_name('OFA','FA_MRC_GET_RATE');
131: fnd_message.set_token('ERROR',sqlerrm);
132: raise_application_error(-20000,fnd_message.get);
133: END;
134:
135: END MC_FA_UTILITIES_PKG;