1079: IF (l_Debug_Level <= 1) THEN
1080: cln_debug_pub.Add('l_app_ref_id:' || l_app_ref_id, 1);
1081: END IF;
1082:
1083: CLN_UTILS.GET_TRADING_PARTNER(l_trp_id, l_tp_id);
1084: IF (l_Debug_Level <= 1) THEN
1085: cln_debug_pub.Add('Trading Partner ID:' || l_tp_id, 1);
1086: END IF;
1087:
1561:
1562: l_tp_hdr_id :=to_number(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE));
1563: IF (l_Debug_Level <= 1) THEN
1564: cln_debug_pub.Add('l_tp_hdr_id:' || l_tp_hdr_id, 1);
1565: cln_debug_pub.Add('About to call CLN_UTILS.GET_TRADING_PARTNER', 1);
1566: END IF;
1567:
1568: CLN_UTILS.GET_TRADING_PARTNER(l_tp_hdr_id, l_vendor_id);
1569:
1564: cln_debug_pub.Add('l_tp_hdr_id:' || l_tp_hdr_id, 1);
1565: cln_debug_pub.Add('About to call CLN_UTILS.GET_TRADING_PARTNER', 1);
1566: END IF;
1567:
1568: CLN_UTILS.GET_TRADING_PARTNER(l_tp_hdr_id, l_vendor_id);
1569:
1570: IF (l_Debug_Level <= 1) THEN
1571: cln_debug_pub.Add('Out of CLN_UTILS.GET_TRADING_PARTNER', 1);
1572: cln_debug_pub.Add('Vendor ID:' || l_vendor_id, 1);
1567:
1568: CLN_UTILS.GET_TRADING_PARTNER(l_tp_hdr_id, l_vendor_id);
1569:
1570: IF (l_Debug_Level <= 1) THEN
1571: cln_debug_pub.Add('Out of CLN_UTILS.GET_TRADING_PARTNER', 1);
1572: cln_debug_pub.Add('Vendor ID:' || l_vendor_id, 1);
1573: END IF;
1574:
1575: SET_ACTION_INTERNAL( x_resultout => x_resultout,
1766:
1767: l_tp_hdr_id :=to_number(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE));
1768: IF (l_Debug_Level <= 1) THEN
1769: cln_debug_pub.Add('l_tp_hdr_id:' || l_tp_hdr_id, 1);
1770: cln_debug_pub.Add('About to call CLN_UTILS.GET_TRADING_PARTNER', 1);
1771: END IF;
1772:
1773: CLN_UTILS.GET_TRADING_PARTNER(l_tp_hdr_id, l_vendor_id);
1774:
1769: cln_debug_pub.Add('l_tp_hdr_id:' || l_tp_hdr_id, 1);
1770: cln_debug_pub.Add('About to call CLN_UTILS.GET_TRADING_PARTNER', 1);
1771: END IF;
1772:
1773: CLN_UTILS.GET_TRADING_PARTNER(l_tp_hdr_id, l_vendor_id);
1774:
1775: IF (l_Debug_Level <= 1) THEN
1776: cln_debug_pub.Add('Out of CLN_UTILS.GET_TRADING_PARTNER', 1);
1777: cln_debug_pub.Add('Vendor ID:' || l_vendor_id, 1);
1772:
1773: CLN_UTILS.GET_TRADING_PARTNER(l_tp_hdr_id, l_vendor_id);
1774:
1775: IF (l_Debug_Level <= 1) THEN
1776: cln_debug_pub.Add('Out of CLN_UTILS.GET_TRADING_PARTNER', 1);
1777: cln_debug_pub.Add('Vendor ID:' || l_vendor_id, 1);
1778: END IF;
1779:
1780: -- Query for BPO number based on Catalog name