[Home] [Help]
376: AND rlk_adj.lookup_type(+) = 'ADJUST_REASON';
377:
378: BEGIN
379: IF OZF_DEBUG_HIGH_ON THEN
380: ozf_utility_pvt.debug_message(l_api_name || 'Entering' || 'document id ' || document_id);
381: END IF;
382: document_type := 'text/plain';
383: -- parse document_id for the ':' dividing item type name from item key value
384: -- document_id value will take the form
643: AND rlk_adj.lookup_type(+) = 'ADJUST_REASON';
644:
645: BEGIN
646: IF OZF_DEBUG_HIGH_ON THEN
647: ozf_utility_pvt.debug_message(l_api_name || 'Entering' || 'document id ' || document_id);
648: END IF;
649: document_type := 'text/plain';
650: -- parse document_id for the ':' dividing item type name from item key value
651: -- document_id value will take the form
946: AND rlk_adj.lookup_type(+) = 'ADJUST_REASON';
947:
948: BEGIN
949: IF OZF_DEBUG_HIGH_ON THEN
950: ozf_utility_pvt.debug_message(l_api_name || 'Entering' || 'document id ' || document_id);
951: END IF;
952: document_type := 'text/plain';
953: -- parse document_id for the ':' dividing item type name from item key value
954: -- document_id value will take the form
1199: AND rlk_adj.lookup_type(+) = 'ADJUST_REASON';
1200:
1201: BEGIN
1202: IF OZF_DEBUG_HIGH_ON THEN
1203: ozf_utility_pvt.debug_message(l_api_name || 'Entering' || 'document id ' || document_id);
1204: END IF;
1205: document_type := 'text/plain';
1206: -- parse document_id for the ':' dividing item type name from item key value
1207: -- document_id value will take the form
1454: AND rlk_adj.lookup_type(+) = 'ADJUST_REASON';
1455:
1456: BEGIN
1457: IF OZF_DEBUG_HIGH_ON THEN
1458: ozf_utility_pvt.debug_message(l_api_name || 'Entering' || 'document id ' || document_id);
1459: END IF;
1460: document_type := 'text/plain';
1461: -- parse document_id for the ':' dividing item type name from item key value
1462: -- document_id value will take the form
1841: ,aname => 'AMS_APPROVAL_OBJECT_NAME'
1842: ,avalue => l_object_details.name
1843: );
1844:
1845: l_object_meaning := OZF_UTILITY_PVT.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER', 'CLAM');
1846:
1847: WF_ENGINE.setitemattrtext(
1848: itemtype => itemtype
1849: ,itemkey => itemkey
2542: l_claim_rec.approved_date := SYSDATE;
2543: -- l_claim_rec.object_version_number := l_object_version_number ;
2544:
2545: IF OZF_DEBUG_HIGH_ON THEN
2546: ozf_utility_pvt.debug_message(l_full_name ||': update_status = ' || l_update_status);
2547: END IF;
2548:
2549: ELSIF l_update_status = 'REJECTED' THEN
2550: l_next_status_id := l_reject_status_id;
2551:
2552: --l_claim_rec.object_version_number := l_object_version_number ;
2553:
2554: ELSE
2555: l_next_status_id := OZF_UTILITY_PVT.get_default_user_status(
2556: 'OZF_CLAIM_STATUS'
2557: ,'OPEN'
2558: );
2559:
2559:
2560:
2561: END IF;
2562:
2563: l_status_code := ozf_utility_pvt.get_system_status_code(l_next_status_id);
2564: l_claim_rec.claim_id := l_claim_id;
2565: l_claim_rec.user_status_id := l_next_status_id;
2566:
2567: IF OZF_DEBUG_HIGH_ON THEN
2564: l_claim_rec.claim_id := l_claim_id;
2565: l_claim_rec.user_status_id := l_next_status_id;
2566:
2567: IF OZF_DEBUG_HIGH_ON THEN
2568: ozf_utility_pvt.debug_message(l_full_name || l_status_code || l_approved_amount || l_update_status);
2569: END IF;
2570:
2571: IF l_payment_method = 'MASS_SETTLEMENT' THEN
2572: IF l_update_status = 'APPROVED' THEN
2684: ,p_data => l_msg_data
2685: );
2686:
2687: IF OZF_DEBUG_HIGH_ON THEN
2688: ozf_utility_pvt.debug_message(l_full_name || ': l_return_status' || l_return_status);
2689: END IF;
2690:
2691: EXCEPTION
2692: WHEN APPROVAL_RAISE_ERROR THEN