393: OPEN c_source_total;
394: FETCH c_source_total INTO l_total_amount;
395: CLOSE c_source_total;
396: -- Bug 5138221 .. Start
397: l_formatted_total_amount := TO_CHAR(l_total_amount, FND_CURRENCY.Get_Format_Mask(g_currency_code,22));
398: -- Bug 5138221 .. End
399: Wf_Engine.SetItemAttrText ( itemtype => ItemType,
400: itemkey => ItemKey,
401: aname => 'TOTAL',
2461: /* =============== END DEBUG LOG ================== */
2462:
2463: -- Source details
2464: l_new_source := 'N';
2465: l_source_formatted_amount := TO_CHAR(source_rec.amount, FND_CURRENCY.Get_Format_Mask(g_currency_code,22));
2466: l_trx_detail := l_trx_detail || '
2500: ' Framing destination details ');
2501: /* =============== END DEBUG LOG ================== */
2502:
2503: -- Destination details
2504: l_dest_formatted_amount := TO_CHAR(dest_rec.amount, FND_CURRENCY.Get_Format_Mask(g_currency_code,22));
2505: l_trx_detail := l_trx_detail || '
2547: ' Calling AddTotalToTable to set the destination total ');
2548: /* =============== END DEBUG LOG ================== */
2549:
2550: -- Adding total for every destination.
2551: l_dest_formatted_total := TO_CHAR(l_dest_total, FND_CURRENCY.Get_Format_Mask(g_currency_code,22));
2552: AddTotalToTable (Document, l_dest_formatted_total);
2553:
2554: l_source_total := l_source_total + source_rec.amount;
2555:
2564: ' Calling AddTotalToTable to set the grand total ');
2565: /* =============== END DEBUG LOG ================== */
2566:
2567: -- Adding the grand total.
2568: l_source_formatted_total := TO_CHAR(l_source_total, FND_CURRENCY.Get_Format_Mask(g_currency_code,22));
2569: AddTotalToTable (Document, l_source_formatted_total);
2570:
2571: /* =============== START DEBUG LOG ================ */
2572: DEBUG_LOG_STRING (l_proc_level, 'dossier_transaction_detail.Msg25',