DBA Data[Home] [Help]

APPS.PA_XLA_INTF_REV_EVENTS dependencies on PA_MCB_INVOICE_PKG

Line 91: PA_MCB_INVOICE_PKG.log_message('Into PA_XLA_REVENUE_EVENTS.Create_Events');

87:
88:
89:
90: IF l_debug_mode = 'Y' THEN
91: PA_MCB_INVOICE_PKG.log_message('Into PA_XLA_REVENUE_EVENTS.Create_Events');
92: END IF;
93:
94: select meaning
95: into l_reject_reason

Line 111: PA_MCB_INVOICE_PKG.log_message('PA_XLA_REVENUE_EVENTS.Create_Events : Before Loop');

107:
108: OPEN c_revenue_cursor;
109:
110: IF l_debug_mode = 'Y' THEN
111: PA_MCB_INVOICE_PKG.log_message('PA_XLA_REVENUE_EVENTS.Create_Events : Before Loop');
112: END IF;
113:
114: LOOP
115: FETCH c_revenue_cursor BULK COLLECT INTO l_project_id_tab,

Line 131: PA_MCB_INVOICE_PKG.log_message('PA_XLA_REVENUE_EVENTS.Create_Events : Before Insert into XLA_EVENTS_INT_GT');

127: DELETE FROM XLA_EVENTS_INT_GT;
128:
129:
130: IF l_debug_mode = 'Y' THEN
131: PA_MCB_INVOICE_PKG.log_message('PA_XLA_REVENUE_EVENTS.Create_Events : Before Insert into XLA_EVENTS_INT_GT');
132: END IF;
133:
134: FORALL i IN 1..l_revenue_num_tab.count
135: INSERT INTO XLA_EVENTS_INT_GT

Line 172: PA_MCB_INVOICE_PKG.log_message('PA_XLA_REVENUE_EVENTS.Create_Events : Before call to CREATE_BULK_EVENTS');

168: decode(l_revenue_num_cr_tab(i), NULL, 'REVENUE', 'REVENUE_ADJ')
169: );
170:
171: IF l_debug_mode = 'Y' THEN
172: PA_MCB_INVOICE_PKG.log_message('PA_XLA_REVENUE_EVENTS.Create_Events : Before call to CREATE_BULK_EVENTS');
173: END IF;
174:
175: --For Bug 5488439 :Changed source_application_id
176: xla_events_pub_pkg.create_bulk_events ( p_source_application_id => l_source_appl_id,

Line 183: PA_MCB_INVOICE_PKG.log_message('PA_XLA_REVENUE_EVENTS.Create_Events : After call to CREATE_BULK_EVENTS');

179: p_ledger_id => l_ledger_id,
180: p_entity_type_code => 'REVENUE');
181:
182: IF l_debug_mode = 'Y' THEN
183: PA_MCB_INVOICE_PKG.log_message('PA_XLA_REVENUE_EVENTS.Create_Events : After call to CREATE_BULK_EVENTS');
184: END IF;
185:
186:
187: Open c_event_cursor;

Line 196: PA_MCB_INVOICE_PKG.log_message('PA_XLA_REVENUE_EVENTS.Create_Events : Before draft revenue updation ');

192: --Update event_id of pa_draft_revenues_all with the generated event_id in successful
193: --cases.
194:
195: IF l_debug_mode = 'Y' THEN
196: PA_MCB_INVOICE_PKG.log_message('PA_XLA_REVENUE_EVENTS.Create_Events : Before draft revenue updation ');
197: END IF;
198:
199: FORALL l_index IN l_revenue_num_tab_tmp.first .. l_revenue_num_tab_tmp.last
200: UPDATE pa_draft_revenues_all

Line 225: PA_MCB_INVOICE_PKG.log_message('CREATE_EVENTS: In Exception');

221:
222:
223: EXCEPTION
224: WHEN OTHERS THEN
225: PA_MCB_INVOICE_PKG.log_message('CREATE_EVENTS: In Exception');
226: PA_MCB_INVOICE_PKG.log_message(sqlerrm);
227: p_return_status := sqlerrm;
228: RAISE;
229:

Line 226: PA_MCB_INVOICE_PKG.log_message(sqlerrm);

222:
223: EXCEPTION
224: WHEN OTHERS THEN
225: PA_MCB_INVOICE_PKG.log_message('CREATE_EVENTS: In Exception');
226: PA_MCB_INVOICE_PKG.log_message(sqlerrm);
227: p_return_status := sqlerrm;
228: RAISE;
229:
230: END create_events;