408: OPEN c_source_total;
409: FETCH c_source_total INTO l_total_amount;
410: CLOSE c_source_total;
411: -- Bug 5138221 .. Start
412: l_formatted_total_amount := TO_CHAR(l_total_amount, FND_CURRENCY.Get_Format_Mask(g_currency_code,22));
413: -- Bug 5138221 .. End
414: Wf_Engine.SetItemAttrText ( itemtype => ItemType,
415: itemkey => ItemKey,
416: aname => 'TOTAL',
2606: /* =============== END DEBUG LOG ================== */
2607:
2608: -- Source details
2609: l_new_source := 'N';
2610: l_source_formatted_amount := TO_CHAR(source_rec.amount, FND_CURRENCY.Get_Format_Mask(g_currency_code,22));
2611: --bug 10205367
2612: l_trx_detail := l_trx_detail || '
2637: /* =============== END DEBUG LOG ================== */
2638:
2639: -- Destination details
2640: --bug 10205367
2641: l_dest_formatted_amount := TO_CHAR(dest_rec.amount, FND_CURRENCY.Get_Format_Mask(g_currency_code,22));
2642: l_trx_detail := l_trx_detail || '
2681: ' Calling AddTotalToTable to set the destination total ');
2682: /* =============== END DEBUG LOG ================== */
2683:
2684: -- Adding total for every destination.
2685: l_dest_formatted_total := TO_CHAR(l_dest_total, FND_CURRENCY.Get_Format_Mask(g_currency_code,22));
2686: AddTotalToTable (Document, l_dest_formatted_total);
2687:
2688: l_source_total := l_source_total + source_rec.amount;
2689:
2698: ' Calling AddTotalToTable to set the grand total ');
2699: /* =============== END DEBUG LOG ================== */
2700:
2701: -- Adding the grand total.
2702: l_source_formatted_total := TO_CHAR(l_source_total, FND_CURRENCY.Get_Format_Mask(g_currency_code,22));
2703: AddTotalToTable (Document, l_source_formatted_total);
2704:
2705: /* =============== START DEBUG LOG ================ */
2706: DEBUG_LOG_STRING (l_proc_level, 'dossier_transaction_detail.Msg25',