DBA Data[Home] [Help]

APPS.INV_PO_THIRD_PARTY_STOCK_MDTR dependencies on INV_LOG_UTIL

Line 129: INV_LOG_UTIL.trace('No data in FSP :','INV_THIRD_PARTY_STOCK_PVT',9);

125: l_fp_org_id;
126:
127: IF c_fp%NOTFOUND
128: THEN
129: INV_LOG_UTIL.trace('No data in FSP :','INV_THIRD_PARTY_STOCK_PVT',9);
130: l_fp_org_id := NULL;
131: ELSE
132: INV_LOG_UTIL.trace('Org id set is :'||l_fp_org_id,'INV_THIRD_PARTY_STOCK_PVT',9);
133: END IF;

Line 132: INV_LOG_UTIL.trace('Org id set is :'||l_fp_org_id,'INV_THIRD_PARTY_STOCK_PVT',9);

128: THEN
129: INV_LOG_UTIL.trace('No data in FSP :','INV_THIRD_PARTY_STOCK_PVT',9);
130: l_fp_org_id := NULL;
131: ELSE
132: INV_LOG_UTIL.trace('Org id set is :'||l_fp_org_id,'INV_THIRD_PARTY_STOCK_PVT',9);
133: END IF;
134: CLOSE c_fp;
135:
136: IF (l_debug = 1)

Line 138: INV_LOG_UTIL.trace('Values passed to Document Sourcing :','INV_THIRD_PARTY_STOCK_PVT',9);

134: CLOSE c_fp;
135:
136: IF (l_debug = 1)
137: THEN
138: INV_LOG_UTIL.trace('Values passed to Document Sourcing :','INV_THIRD_PARTY_STOCK_PVT',9);
139: INV_LOG_UTIL.trace('Item is : '||p_inventory_item_id,'INV_THIRD_PARTY_STOCK_PVT',9);
140: INV_LOG_UTIL.trace('Vendor is : '||l_vendor_id,'INV_THIRD_PARTY_STOCK_PVT',9);
141: INV_LOG_UTIL.trace('Organization is : '||p_organization_id,'INV_THIRD_PARTY_STOCK_PVT',9);
142: INV_LOG_UTIL.trace('Currency is : '||x_currency_code,'INV_THIRD_PARTY_STOCK_PVT',9);

Line 139: INV_LOG_UTIL.trace('Item is : '||p_inventory_item_id,'INV_THIRD_PARTY_STOCK_PVT',9);

135:
136: IF (l_debug = 1)
137: THEN
138: INV_LOG_UTIL.trace('Values passed to Document Sourcing :','INV_THIRD_PARTY_STOCK_PVT',9);
139: INV_LOG_UTIL.trace('Item is : '||p_inventory_item_id,'INV_THIRD_PARTY_STOCK_PVT',9);
140: INV_LOG_UTIL.trace('Vendor is : '||l_vendor_id,'INV_THIRD_PARTY_STOCK_PVT',9);
141: INV_LOG_UTIL.trace('Organization is : '||p_organization_id,'INV_THIRD_PARTY_STOCK_PVT',9);
142: INV_LOG_UTIL.trace('Currency is : '||x_currency_code,'INV_THIRD_PARTY_STOCK_PVT',9);
143: INV_LOG_UTIL.trace('Rev is : '||p_item_revision,'INV_THIRD_PARTY_STOCK_PVT',9);

Line 140: INV_LOG_UTIL.trace('Vendor is : '||l_vendor_id,'INV_THIRD_PARTY_STOCK_PVT',9);

136: IF (l_debug = 1)
137: THEN
138: INV_LOG_UTIL.trace('Values passed to Document Sourcing :','INV_THIRD_PARTY_STOCK_PVT',9);
139: INV_LOG_UTIL.trace('Item is : '||p_inventory_item_id,'INV_THIRD_PARTY_STOCK_PVT',9);
140: INV_LOG_UTIL.trace('Vendor is : '||l_vendor_id,'INV_THIRD_PARTY_STOCK_PVT',9);
141: INV_LOG_UTIL.trace('Organization is : '||p_organization_id,'INV_THIRD_PARTY_STOCK_PVT',9);
142: INV_LOG_UTIL.trace('Currency is : '||x_currency_code,'INV_THIRD_PARTY_STOCK_PVT',9);
143: INV_LOG_UTIL.trace('Rev is : '||p_item_revision,'INV_THIRD_PARTY_STOCK_PVT',9);
144: INV_LOG_UTIL.trace('Site is : '||l_vendor_site_id,'INV_THIRD_PARTY_STOCK_PVT',9);

Line 141: INV_LOG_UTIL.trace('Organization is : '||p_organization_id,'INV_THIRD_PARTY_STOCK_PVT',9);

137: THEN
138: INV_LOG_UTIL.trace('Values passed to Document Sourcing :','INV_THIRD_PARTY_STOCK_PVT',9);
139: INV_LOG_UTIL.trace('Item is : '||p_inventory_item_id,'INV_THIRD_PARTY_STOCK_PVT',9);
140: INV_LOG_UTIL.trace('Vendor is : '||l_vendor_id,'INV_THIRD_PARTY_STOCK_PVT',9);
141: INV_LOG_UTIL.trace('Organization is : '||p_organization_id,'INV_THIRD_PARTY_STOCK_PVT',9);
142: INV_LOG_UTIL.trace('Currency is : '||x_currency_code,'INV_THIRD_PARTY_STOCK_PVT',9);
143: INV_LOG_UTIL.trace('Rev is : '||p_item_revision,'INV_THIRD_PARTY_STOCK_PVT',9);
144: INV_LOG_UTIL.trace('Site is : '||l_vendor_site_id,'INV_THIRD_PARTY_STOCK_PVT',9);
145: INV_LOG_UTIL.trace('Multiorg is :N','INV_THIRD_PARTY_STOCK_PVT',9);

Line 142: INV_LOG_UTIL.trace('Currency is : '||x_currency_code,'INV_THIRD_PARTY_STOCK_PVT',9);

138: INV_LOG_UTIL.trace('Values passed to Document Sourcing :','INV_THIRD_PARTY_STOCK_PVT',9);
139: INV_LOG_UTIL.trace('Item is : '||p_inventory_item_id,'INV_THIRD_PARTY_STOCK_PVT',9);
140: INV_LOG_UTIL.trace('Vendor is : '||l_vendor_id,'INV_THIRD_PARTY_STOCK_PVT',9);
141: INV_LOG_UTIL.trace('Organization is : '||p_organization_id,'INV_THIRD_PARTY_STOCK_PVT',9);
142: INV_LOG_UTIL.trace('Currency is : '||x_currency_code,'INV_THIRD_PARTY_STOCK_PVT',9);
143: INV_LOG_UTIL.trace('Rev is : '||p_item_revision,'INV_THIRD_PARTY_STOCK_PVT',9);
144: INV_LOG_UTIL.trace('Site is : '||l_vendor_site_id,'INV_THIRD_PARTY_STOCK_PVT',9);
145: INV_LOG_UTIL.trace('Multiorg is :N','INV_THIRD_PARTY_STOCK_PVT',9);
146: INV_LOG_UTIL.trace('Destination doc type is :REQ','INV_THIRD_PARTY_STOCK_PVT',9);

Line 143: INV_LOG_UTIL.trace('Rev is : '||p_item_revision,'INV_THIRD_PARTY_STOCK_PVT',9);

139: INV_LOG_UTIL.trace('Item is : '||p_inventory_item_id,'INV_THIRD_PARTY_STOCK_PVT',9);
140: INV_LOG_UTIL.trace('Vendor is : '||l_vendor_id,'INV_THIRD_PARTY_STOCK_PVT',9);
141: INV_LOG_UTIL.trace('Organization is : '||p_organization_id,'INV_THIRD_PARTY_STOCK_PVT',9);
142: INV_LOG_UTIL.trace('Currency is : '||x_currency_code,'INV_THIRD_PARTY_STOCK_PVT',9);
143: INV_LOG_UTIL.trace('Rev is : '||p_item_revision,'INV_THIRD_PARTY_STOCK_PVT',9);
144: INV_LOG_UTIL.trace('Site is : '||l_vendor_site_id,'INV_THIRD_PARTY_STOCK_PVT',9);
145: INV_LOG_UTIL.trace('Multiorg is :N','INV_THIRD_PARTY_STOCK_PVT',9);
146: INV_LOG_UTIL.trace('Destination doc type is :REQ','INV_THIRD_PARTY_STOCK_PVT',9);
147: END IF;

Line 144: INV_LOG_UTIL.trace('Site is : '||l_vendor_site_id,'INV_THIRD_PARTY_STOCK_PVT',9);

140: INV_LOG_UTIL.trace('Vendor is : '||l_vendor_id,'INV_THIRD_PARTY_STOCK_PVT',9);
141: INV_LOG_UTIL.trace('Organization is : '||p_organization_id,'INV_THIRD_PARTY_STOCK_PVT',9);
142: INV_LOG_UTIL.trace('Currency is : '||x_currency_code,'INV_THIRD_PARTY_STOCK_PVT',9);
143: INV_LOG_UTIL.trace('Rev is : '||p_item_revision,'INV_THIRD_PARTY_STOCK_PVT',9);
144: INV_LOG_UTIL.trace('Site is : '||l_vendor_site_id,'INV_THIRD_PARTY_STOCK_PVT',9);
145: INV_LOG_UTIL.trace('Multiorg is :N','INV_THIRD_PARTY_STOCK_PVT',9);
146: INV_LOG_UTIL.trace('Destination doc type is :REQ','INV_THIRD_PARTY_STOCK_PVT',9);
147: END IF;
148:

Line 145: INV_LOG_UTIL.trace('Multiorg is :N','INV_THIRD_PARTY_STOCK_PVT',9);

141: INV_LOG_UTIL.trace('Organization is : '||p_organization_id,'INV_THIRD_PARTY_STOCK_PVT',9);
142: INV_LOG_UTIL.trace('Currency is : '||x_currency_code,'INV_THIRD_PARTY_STOCK_PVT',9);
143: INV_LOG_UTIL.trace('Rev is : '||p_item_revision,'INV_THIRD_PARTY_STOCK_PVT',9);
144: INV_LOG_UTIL.trace('Site is : '||l_vendor_site_id,'INV_THIRD_PARTY_STOCK_PVT',9);
145: INV_LOG_UTIL.trace('Multiorg is :N','INV_THIRD_PARTY_STOCK_PVT',9);
146: INV_LOG_UTIL.trace('Destination doc type is :REQ','INV_THIRD_PARTY_STOCK_PVT',9);
147: END IF;
148:
149:

Line 146: INV_LOG_UTIL.trace('Destination doc type is :REQ','INV_THIRD_PARTY_STOCK_PVT',9);

142: INV_LOG_UTIL.trace('Currency is : '||x_currency_code,'INV_THIRD_PARTY_STOCK_PVT',9);
143: INV_LOG_UTIL.trace('Rev is : '||p_item_revision,'INV_THIRD_PARTY_STOCK_PVT',9);
144: INV_LOG_UTIL.trace('Site is : '||l_vendor_site_id,'INV_THIRD_PARTY_STOCK_PVT',9);
145: INV_LOG_UTIL.trace('Multiorg is :N','INV_THIRD_PARTY_STOCK_PVT',9);
146: INV_LOG_UTIL.trace('Destination doc type is :REQ','INV_THIRD_PARTY_STOCK_PVT',9);
147: END IF;
148:
149:
150: IF NVL(l_vs_org_id,-99) <> NVL(l_fp_org_id,-99)

Line 152: INV_LOG_UTIL.trace('Different operating unit :','INV_THIRD_PARTY_STOCK_PVT',9);

148:
149:
150: IF NVL(l_vs_org_id,-99) <> NVL(l_fp_org_id,-99)
151: THEN
152: INV_LOG_UTIL.trace('Different operating unit :','INV_THIRD_PARTY_STOCK_PVT',9);
153: DBMS_APPLICATION_INFO.SET_CLIENT_INFO(l_vs_org_id);
154: --MO_GLOBAL.Init('PO');
155: MO_GLOBAL.set_policy_context('S',l_vs_org_id);
156:

Line 157: INV_LOG_UTIL.trace('Now setting OU to :'||l_vs_org_id,'INV_THIRD_PARTY_STOCK_PVT',9);

153: DBMS_APPLICATION_INFO.SET_CLIENT_INFO(l_vs_org_id);
154: --MO_GLOBAL.Init('PO');
155: MO_GLOBAL.set_policy_context('S',l_vs_org_id);
156:
157: INV_LOG_UTIL.trace('Now setting OU to :'||l_vs_org_id,'INV_THIRD_PARTY_STOCK_PVT',9);
158: END IF;
159:
160: MO_GLOBAL.set_policy_context('S',l_vs_org_id);
161: