DBA Data[Home] [Help]

APPS.MC_FA_UTILITIES_PKG dependencies on FND_MESSAGE

Line 92: fnd_message.set_name('OFA','FA_MRC_UPD_MC_RECS');

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);

Line 93: fnd_message.set_token('TABLE', 'fa_mc_books_rates');

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);

Line 94: fnd_message.set_token('TRIGGER',

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;

Line 96: fnd_message.set_token('ERROR',sqlerrm);

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');

Line 97: raise_application_error(-20000,fnd_message.get);

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');

Line 100: fnd_message.set_name('OFA', 'FA_MRC_INS_MC_RECS');

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);

Line 101: fnd_message.set_token('TABLE', 'fa_mc_books_rates');

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;

Line 102: fnd_message.set_token('TRIGGER', p_trigger);

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:

Line 103: fnd_message.set_token('ERROR',sqlerrm);

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

Line 104: raise_application_error(-20000,fnd_message.get);

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,

Line 130: fnd_message.set_name('OFA','FA_MRC_GET_RATE');

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:

Line 131: fnd_message.set_token('ERROR',sqlerrm);

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;

Line 132: raise_application_error(-20000,fnd_message.get);

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;