616: to fix the bug 2124494 for MCB2 */
617: /* Changed the length of the format mask for all column from 15 to 22
618: to fix the bug 2162900 for MCB2 */
619: Event_Description := pa_billing_values.get_message('CCREV_DESCRIPTION')|| '(' ||
620: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
621: || ' ,((' ||
622: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
623: || '/' ||
624: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
618: to fix the bug 2162900 for MCB2 */
619: Event_Description := pa_billing_values.get_message('CCREV_DESCRIPTION')|| '(' ||
620: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
621: || ' ,((' ||
622: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
623: || '/' ||
624: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
625: || ' * (' ||
626: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
620: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
621: || ' ,((' ||
622: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
623: || '/' ||
624: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
625: || ' * (' ||
626: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
627: || ' - ' ||
628: to_char(nvl(event_revenue,0),fnd_currency.get_format_mask(l_currency_code,22))
622: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
623: || '/' ||
624: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
625: || ' * (' ||
626: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
627: || ' - ' ||
628: to_char(nvl(event_revenue,0),fnd_currency.get_format_mask(l_currency_code,22))
629: || ')) - '||
630: to_char(nvl(revenue_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
624: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
625: || ' * (' ||
626: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
627: || ' - ' ||
628: to_char(nvl(event_revenue,0),fnd_currency.get_format_mask(l_currency_code,22))
629: || ')) - '||
630: to_char(nvl(revenue_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
631: || ' ))';
632: IF g1_debug_mode = 'Y' THEN
626: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
627: || ' - ' ||
628: to_char(nvl(event_revenue,0),fnd_currency.get_format_mask(l_currency_code,22))
629: || ')) - '||
630: to_char(nvl(revenue_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
631: || ' ))';
632: IF g1_debug_mode = 'Y' THEN
633: PA_MCB_INVOICE_PKG.log_message('rev part Inside Revenue part pa_billing.ccrev Event desc :'||Event_Description);
634: PA_MCB_INVOICE_PKG.log_message('Rev part Before insert pa_billing.ccrev.insert_event 1 :'||to_char(Revenue));
690: to fix the bug 2124494 for MCB2 */
691: /* Changed the length of the format mask for all column from 15 to 22
692: to fix the bug 2162900 for MCB2 */
693: Event_Description := pa_billing_values.get_message('CCREV_DESCRIPTION')|| '(' ||
694: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
695: || ' ,((' ||
696: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
697: || '/' ||
698: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
692: to fix the bug 2162900 for MCB2 */
693: Event_Description := pa_billing_values.get_message('CCREV_DESCRIPTION')|| '(' ||
694: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
695: || ' ,((' ||
696: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
697: || '/' ||
698: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
699: || ' * (' ||
700: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
694: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
695: || ' ,((' ||
696: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
697: || '/' ||
698: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
699: || ' * (' ||
700: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
701: || ' - ' ||
702: to_char(nvl(event_invoice,0),fnd_currency.get_format_mask(l_currency_code,22))
696: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
697: || '/' ||
698: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
699: || ' * (' ||
700: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
701: || ' - ' ||
702: to_char(nvl(event_invoice,0),fnd_currency.get_format_mask(l_currency_code,22))
703: || ')) - '||
704: to_char(nvl(invoice_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
698: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
699: || ' * (' ||
700: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
701: || ' - ' ||
702: to_char(nvl(event_invoice,0),fnd_currency.get_format_mask(l_currency_code,22))
703: || ')) - '||
704: to_char(nvl(invoice_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
705: || ' ))';
706:
700: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
701: || ' - ' ||
702: to_char(nvl(event_invoice,0),fnd_currency.get_format_mask(l_currency_code,22))
703: || ')) - '||
704: to_char(nvl(invoice_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
705: || ' ))';
706:
707: IF g1_debug_mode = 'Y' THEN
708: PA_MCB_INVOICE_PKG.log_message('inv part Inside Revenue part pa_billing.ccrev Event desc :'||Event_Description);