DBA Data[Home] [Help]

APPS.PORCPTWF dependencies on PO_WF_DEBUG_PKG

Line 1908: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

1904:
1905: x_progress := x_progress || '*x_group_id*' || to_char(x_group_id);
1906:
1907: IF (g_po_wf_debug = 'Y') THEN
1908: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
1909: END IF;
1910:
1911: end loop;
1912:

Line 2383: po_wf_debug_pkg.insert_debug(x_wf_itemtype,x_wf_itemkey,'purge_orders SQL error ' || sqlcode || ' error message: ' || substr(sqlerrm,1,512));

2379: EXCEPTION
2380: when others then
2381: wf_core.context ('PORCPTWF','purge_Orders','SQL error ' || sqlcode);
2382: IF (g_po_wf_debug = 'Y') THEN
2383: po_wf_debug_pkg.insert_debug(x_wf_itemtype,x_wf_itemkey,'purge_orders SQL error ' || sqlcode || ' error message: ' || substr(sqlerrm,1,512));
2384: END IF;
2385: END;
2386:
2387: -- Save the ItemKey for the next comparison

Line 2449: po_wf_debug_pkg.insert_debug(x_item_type, x_item_key, x_progress);

2445: aname => 'IS_INT_REQ');
2446: begin
2447: x_progress := '002 x_is_int_req is ' || x_is_int_req || 'x_allow_inv_dest_receipts: '|| x_allow_inv_dest_receipts;
2448: IF (g_po_wf_debug = 'Y') THEN
2449: po_wf_debug_pkg.insert_debug(x_item_type, x_item_key, x_progress);
2450: END IF;
2451: if x_is_int_req = 'Y' then
2452:
2453: x_so_header_id := wf_engine.GetItemAttrNumber( itemtype => x_item_type,

Line 2497: po_wf_debug_pkg.insert_debug(x_item_type, x_item_key, x_progress);

2493: -- calling populate_order_info function to populate the
2494: -- latest distributions list.
2495: x_progress := 'get_count 002 else x_po_header_id: ' || x_po_header_id ;
2496: IF (g_po_wf_debug = 'Y') THEN
2497: po_wf_debug_pkg.insert_debug(x_item_type, x_item_key, x_progress);
2498: END IF;
2499:
2500: x_count := populate_order_info(x_item_type, x_item_key, skip_distribution_updation);
2501: x_progress := 'get_count 003 populate_order_info count: ' || x_count ;

Line 2503: po_wf_debug_pkg.insert_debug(x_item_type, x_item_key, x_progress);

2499:
2500: x_count := populate_order_info(x_item_type, x_item_key, skip_distribution_updation);
2501: x_progress := 'get_count 003 populate_order_info count: ' || x_count ;
2502: IF (g_po_wf_debug = 'Y') THEN
2503: po_wf_debug_pkg.insert_debug(x_item_type, x_item_key, x_progress);
2504: END IF;
2505: end if; -- is internal item
2506: x_progress := 'get_count 004 final return x_count: ' || x_count ;
2507: IF (g_po_wf_debug = 'Y') THEN

Line 2508: po_wf_debug_pkg.insert_debug(x_item_type, x_item_key, x_progress);

2504: END IF;
2505: end if; -- is internal item
2506: x_progress := 'get_count 004 final return x_count: ' || x_count ;
2507: IF (g_po_wf_debug = 'Y') THEN
2508: po_wf_debug_pkg.insert_debug(x_item_type, x_item_key, x_progress);
2509: END IF;
2510: RETURN x_count;
2511:
2512: EXCEPTION

Line 2541: po_wf_debug_pkg.insert_debug(itemtype, itemkey, x_progress);

2537:
2538: x_count := get_count(itemtype,itemkey,x_skip_distribution_updation);
2539: x_progress := 'DOES_ITEM_EXIST 002 x_count: ' || x_count;
2540: IF (g_po_wf_debug = 'Y') THEN
2541: po_wf_debug_pkg.insert_debug(itemtype, itemkey, x_progress);
2542: END IF;
2543: -- ash_debug.debug('does_item_exist x_count ' , x_count);
2544:
2545: IF x_count = 0 THEN

Line 2950: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

2946:
2947: x_progress := x_progress || '*x_group_id*' || to_char(x_group_id);
2948:
2949: IF (g_po_wf_debug = 'Y') THEN
2950: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
2951: END IF;
2952: end loop;
2953:
2954: x_inserted_txn_status := POR_RCV_ORD_SV.groupInternalTransaction (t_req_line_id,

Line 3646: po_wf_debug_pkg.insert_debug(itemtype, itemkey, x_progress);

3642: x_progress := 'Populate_Order_Info 002 x_po_header_id: ' || x_po_header_id || ' x_org_id: ' || x_org_id ||
3643: ' x_requester_id: '|| x_requester_id || ' x_exp_receipt_date: ' || x_exp_receipt_date ||
3644: ' x_allow_inv_dest_receipts: ' || x_allow_inv_dest_receipts;
3645: IF (g_po_wf_debug = 'Y') THEN
3646: po_wf_debug_pkg.insert_debug(itemtype, itemkey, x_progress);
3647: END IF;
3648: if x_allow_inv_dest_receipts = 'N' then
3649:
3650: OPEN Porcpt_LineInfo for

Line 3738: po_wf_debug_pkg.insert_debug(itemtype, itemkey, x_progress);

3734:
3735: END LOOP;
3736: x_progress := 'Populate_Order_Info 003 line_count: ' || line_count ;
3737: IF (g_po_wf_debug = 'Y') THEN
3738: po_wf_debug_pkg.insert_debug(itemtype, itemkey, x_progress);
3739: END IF;
3740: CLOSE Porcpt_LineInfo;
3741:
3742: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,

Line 3755: po_wf_debug_pkg.insert_debug(itemtype, itemkey, x_progress);

3751: aname => 'NTF_TRIGGERED_DATE',
3752: avalue => (to_char(sysdate, 'DD/MM/YYYY'))); --bug 16556483
3753: x_progress := 'Populate_Order_Info 004 l_ntf_trig: ' || l_ntf_trig || ' line_count: ' || line_count;
3754: IF (g_po_wf_debug = 'Y') THEN
3755: po_wf_debug_pkg.insert_debug(itemtype, itemkey, x_progress);
3756: END IF;
3757: return line_count;
3758: END Populate_Order_Info;
3759:

Line 3898: po_wf_debug_pkg.insert_debug(itemtype, itemkey, x_progress);

3894: || '*waybillnum*' || t_waybillNum(i);
3895: x_progress := x_progress || '*x_group_id*' || to_char(x_group_id);
3896:
3897: IF (g_po_wf_debug = 'Y') THEN
3898: po_wf_debug_pkg.insert_debug(itemtype, itemkey, x_progress);
3899: END IF;
3900: end loop;
3901:
3902: x_insert_txns_status := POR_RCV_ORD_SV.groupPoTransaction(