eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_ADD_ITEM_PRCLIST_PVT dependencies on FND_FILE

Line 167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_price_list_id-'||p_price_list_id);

163: l_item_tbl);
164:
165:
166:
167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_price_list_id-'||p_price_list_id);
168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_set_price_flag-'||p_set_price_flag);
169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id-'||p_organization_id);
170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_category_id-'||p_category_id);
171: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_status_code-'||p_status_code);

Line 168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_set_price_flag-'||p_set_price_flag);

164:
165:
166:
167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_price_list_id-'||p_price_list_id);
168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_set_price_flag-'||p_set_price_flag);
169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id-'||p_organization_id);
170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_category_id-'||p_category_id);
171: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_status_code-'||p_status_code);
172: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_category_set_id-'||p_category_set_id);

Line 169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id-'||p_organization_id);

165:
166:
167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_price_list_id-'||p_price_list_id);
168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_set_price_flag-'||p_set_price_flag);
169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id-'||p_organization_id);
170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_category_id-'||p_category_id);
171: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_status_code-'||p_status_code);
172: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_category_set_id-'||p_category_set_id);
173: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_costorg_id-'||p_costorg_id);

Line 170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_category_id-'||p_category_id);

166:
167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_price_list_id-'||p_price_list_id);
168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_set_price_flag-'||p_set_price_flag);
169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id-'||p_organization_id);
170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_category_id-'||p_category_id);
171: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_status_code-'||p_status_code);
172: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_category_set_id-'||p_category_set_id);
173: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_costorg_id-'||p_costorg_id);
174:

Line 171: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_status_code-'||p_status_code);

167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_price_list_id-'||p_price_list_id);
168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_set_price_flag-'||p_set_price_flag);
169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id-'||p_organization_id);
170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_category_id-'||p_category_id);
171: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_status_code-'||p_status_code);
172: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_category_set_id-'||p_category_set_id);
173: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_costorg_id-'||p_costorg_id);
174:
175: IF QP_UTIL.Attrmgr_Installed = 'Y' THEN

Line 172: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_category_set_id-'||p_category_set_id);

168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_set_price_flag-'||p_set_price_flag);
169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id-'||p_organization_id);
170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_category_id-'||p_category_id);
171: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_status_code-'||p_status_code);
172: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_category_set_id-'||p_category_set_id);
173: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_costorg_id-'||p_costorg_id);
174:
175: IF QP_UTIL.Attrmgr_Installed = 'Y' THEN
176: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY', l_pte_code);

Line 173: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_costorg_id-'||p_costorg_id);

169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id-'||p_organization_id);
170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_category_id-'||p_category_id);
171: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_status_code-'||p_status_code);
172: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_category_set_id-'||p_category_set_id);
173: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_costorg_id-'||p_costorg_id);
174:
175: IF QP_UTIL.Attrmgr_Installed = 'Y' THEN
176: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY', l_pte_code);
177:

Line 181: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_pte_code'||l_pte_code);

177:
178: IF l_pte_code IS NULL THEN
179: l_pte_code := 'ORDFUL';
180: END IF;
181: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_pte_code'||l_pte_code);
182: OPEN precedence_cur(l_pte_code);
183: FETCH precedence_cur INTO l_sequence_num;
184: CLOSE precedence_cur;
185:

Line 213: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_price_rounding-'||l_price_rounding);

209: and PL.CURRENCY_CODE = FC.CURRENCY_CODE;
210:
211:
212: l_price_rounding := fnd_profile.value('QP_PRICE_ROUNDING'); --Added for Enhancement 1732601
213: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_price_rounding-'||l_price_rounding);
214: OPEN qual_cur;
215: FETCH qual_cur INTO l_qual_id;
216:
217: IF qual_cur%FOUND THEN -- Qualifiers present in target Price List

Line 226: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entered p_set_price_flag');

222:
223: CLOSE qual_cur;
224:
225: IF ( p_set_price_flag = 'Y' ) THEN
226: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entered p_set_price_flag');
227: l_index := l_item_tbl.FIRST;
228: WHILE l_index <= l_item_tbl.LAST LOOP
229: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entered p_set_price_flag while');
230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'inventory item id-'||l_index||'-'||l_item_tbl(l_index));

Line 229: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entered p_set_price_flag while');

225: IF ( p_set_price_flag = 'Y' ) THEN
226: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entered p_set_price_flag');
227: l_index := l_item_tbl.FIRST;
228: WHILE l_index <= l_item_tbl.LAST LOOP
229: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entered p_set_price_flag while');
230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'inventory item id-'||l_index||'-'||l_item_tbl(l_index));
231: begin
232: /*
233: select count(*)

Line 230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'inventory item id-'||l_index||'-'||l_item_tbl(l_index));

226: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entered p_set_price_flag');
227: l_index := l_item_tbl.FIRST;
228: WHILE l_index <= l_item_tbl.LAST LOOP
229: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entered p_set_price_flag while');
230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'inventory item id-'||l_index||'-'||l_item_tbl(l_index));
231: begin
232: /*
233: select count(*)
234: into l_already_exists

Line 260: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR-'||sqlerrm);

256: exception
257: WHEN NO_DATA_FOUND THEN
258: l_already_exists := 0;
259: WHEN OTHERS THEN
260: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR-'||sqlerrm);
261: RAISE;
262: end;
263: IF l_already_exists > 0 THEN
264: -- write rec log of values that cannot be added

Line 265: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Number '|| l_item_tbl(l_index) || ' already exists');

261: RAISE;
262: end;
263: IF l_already_exists > 0 THEN
264: -- write rec log of values that cannot be added
265: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Number '|| l_item_tbl(l_index) || ' already exists');
266: ELSE
267: /*
268: select decode(l_min_acct_unit,
269: -1,

Line 284: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-1-1');

280: Begin
281:
282: IF l_price_rounding IS NOT NULL THEN --Added for Enhancement 1732601
283: If (p_costorg_id Is Null) Then
284: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-1-1');
285: select decode(l_min_acct_unit,
286: -1,
287: round(nvl(cst.item_cost,0), l_rounding_factor),
288: round(nvl(cst.item_cost,0)/l_min_acct_unit)*l_min_acct_unit)

Line 295: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-1');

291: where mtl.inventory_item_id = l_item_tbl(l_index)
292: and cst.inventory_item_id =mtl.inventory_item_id
293: and cst.organization_id = mtl.organization_id
294: and mtl.organization_id = p_organization_id;
295: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-1');
296: ELSE /* 7388596*/
297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-API-1');
298: IF GMF_validations_PVT.Validate_organization_id(p_costorg_id) THEN
299: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory Item Id: '|| l_item_tbl(l_index));

Line 297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-API-1');

293: and cst.organization_id = mtl.organization_id
294: and mtl.organization_id = p_organization_id;
295: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-1');
296: ELSE /* 7388596*/
297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-API-1');
298: IF GMF_validations_PVT.Validate_organization_id(p_costorg_id) THEN
299: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory Item Id: '|| l_item_tbl(l_index));
300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id: '|| p_costorg_id);
301: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_date: '|| sysdate);

Line 299: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory Item Id: '|| l_item_tbl(l_index));

295: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-1');
296: ELSE /* 7388596*/
297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-API-1');
298: IF GMF_validations_PVT.Validate_organization_id(p_costorg_id) THEN
299: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory Item Id: '|| l_item_tbl(l_index));
300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id: '|| p_costorg_id);
301: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_date: '|| sysdate);
302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));
303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));

Line 300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id: '|| p_costorg_id);

296: ELSE /* 7388596*/
297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-API-1');
298: IF GMF_validations_PVT.Validate_organization_id(p_costorg_id) THEN
299: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory Item Id: '|| l_item_tbl(l_index));
300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id: '|| p_costorg_id);
301: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_date: '|| sysdate);
302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));
303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));
304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));

Line 301: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_date: '|| sysdate);

297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-API-1');
298: IF GMF_validations_PVT.Validate_organization_id(p_costorg_id) THEN
299: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory Item Id: '|| l_item_tbl(l_index));
300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id: '|| p_costorg_id);
301: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_date: '|| sysdate);
302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));
303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));
304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));
305: v_result_code := GMF_CMCOMMON.Get_Process_Item_Cost

Line 302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));

298: IF GMF_validations_PVT.Validate_organization_id(p_costorg_id) THEN
299: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory Item Id: '|| l_item_tbl(l_index));
300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id: '|| p_costorg_id);
301: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_date: '|| sysdate);
302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));
303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));
304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));
305: v_result_code := GMF_CMCOMMON.Get_Process_Item_Cost
306: ( p_api_version => 1

Line 303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));

299: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory Item Id: '|| l_item_tbl(l_index));
300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id: '|| p_costorg_id);
301: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_date: '|| sysdate);
302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));
303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));
304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));
305: v_result_code := GMF_CMCOMMON.Get_Process_Item_Cost
306: ( p_api_version => 1
307: , p_init_msg_list => 'F'

Line 304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));

300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id: '|| p_costorg_id);
301: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_date: '|| sysdate);
302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));
303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));
304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));
305: v_result_code := GMF_CMCOMMON.Get_Process_Item_Cost
306: ( p_api_version => 1
307: , p_init_msg_list => 'F'
308: , x_return_status => v_return_status

Line 321: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));

317: , p_cost_analysis_code => v_analysis_code
318: , x_total_cost => v_item_cost /* total cost */
319: , x_no_of_rows => v_no_of_rows /* number of detail rows retrieved */
320: );
321: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));
322: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));
323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));
324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_result_code: '|| NVL(v_result_code,0));
325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_total_cost: '|| NVL(v_item_cost,0));

Line 322: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));

318: , x_total_cost => v_item_cost /* total cost */
319: , x_no_of_rows => v_no_of_rows /* number of detail rows retrieved */
320: );
321: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));
322: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));
323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));
324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_result_code: '|| NVL(v_result_code,0));
325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_total_cost: '|| NVL(v_item_cost,0));
326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_no_of_rows: '|| NVL(v_no_of_rows,0));

Line 323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));

319: , x_no_of_rows => v_no_of_rows /* number of detail rows retrieved */
320: );
321: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));
322: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));
323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));
324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_result_code: '|| NVL(v_result_code,0));
325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_total_cost: '|| NVL(v_item_cost,0));
326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_no_of_rows: '|| NVL(v_no_of_rows,0));
327: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_return_status: '|| NVL(v_return_status,'N'));

Line 324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_result_code: '|| NVL(v_result_code,0));

320: );
321: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));
322: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));
323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));
324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_result_code: '|| NVL(v_result_code,0));
325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_total_cost: '|| NVL(v_item_cost,0));
326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_no_of_rows: '|| NVL(v_no_of_rows,0));
327: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_return_status: '|| NVL(v_return_status,'N'));
328: IF v_result_code = 1 THEN

Line 325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_total_cost: '|| NVL(v_item_cost,0));

321: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));
322: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));
323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));
324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_result_code: '|| NVL(v_result_code,0));
325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_total_cost: '|| NVL(v_item_cost,0));
326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_no_of_rows: '|| NVL(v_no_of_rows,0));
327: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_return_status: '|| NVL(v_return_status,'N'));
328: IF v_result_code = 1 THEN
329: SELECT decode(l_min_acct_unit,-1,round(nvl(v_item_cost,0), l_rounding_factor),

Line 326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_no_of_rows: '|| NVL(v_no_of_rows,0));

322: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));
323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));
324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_result_code: '|| NVL(v_result_code,0));
325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_total_cost: '|| NVL(v_item_cost,0));
326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_no_of_rows: '|| NVL(v_no_of_rows,0));
327: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_return_status: '|| NVL(v_return_status,'N'));
328: IF v_result_code = 1 THEN
329: SELECT decode(l_min_acct_unit,-1,round(nvl(v_item_cost,0), l_rounding_factor),
330: round(nvl(v_item_cost,0)/l_min_acct_unit)*l_min_acct_unit)

Line 327: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_return_status: '|| NVL(v_return_status,'N'));

323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));
324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_result_code: '|| NVL(v_result_code,0));
325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_total_cost: '|| NVL(v_item_cost,0));
326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_no_of_rows: '|| NVL(v_no_of_rows,0));
327: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_return_status: '|| NVL(v_return_status,'N'));
328: IF v_result_code = 1 THEN
329: SELECT decode(l_min_acct_unit,-1,round(nvl(v_item_cost,0), l_rounding_factor),
330: round(nvl(v_item_cost,0)/l_min_acct_unit)*l_min_acct_unit)
331: INTO l_price

Line 337: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-2-1');

333: ELSE
334: l_price := 0;
335: END IF;
336: ELSE
337: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-2-1');
338: select decode(l_min_acct_unit,
339: -1,
340: round(nvl(cst.item_cost,0), l_rounding_factor),
341: round(nvl(cst.item_cost,0)/l_min_acct_unit)*l_min_acct_unit)

Line 348: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-2');

344: where mtl.inventory_item_id = l_item_tbl(l_index)
345: and cst.inventory_item_id =mtl.inventory_item_id
346: and cst.organization_id = p_costorg_id
347: and mtl.organization_id = p_organization_id;
348: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-2');
349: END IF;
350: End If;
351: ELSE
352: /* Added for Enhancement 1732601 */

Line 356: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-3-1');

352: /* Added for Enhancement 1732601 */
353:
354: If (p_costorg_id Is Null) Then
355:
356: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-3-1');
357: select decode(l_min_acct_unit,
358: -1,
359: nvl(cst.item_cost,0),
360: round(nvl(cst.item_cost,0)/l_min_acct_unit)*l_min_acct_unit)

Line 367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-3');

363: where mtl.inventory_item_id = l_item_tbl(l_index)
364: and cst.inventory_item_id =mtl.inventory_item_id
365: and cst.organization_id = mtl.organization_id
366: and mtl.organization_id = p_organization_id;
367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-3');
368: ELSE /* 7388596*/
369: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-API-2');
370: IF GMF_validations_PVT.Validate_organization_id(p_costorg_id) THEN
371: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory Item Id: '|| l_item_tbl(l_index));

Line 369: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-API-2');

365: and cst.organization_id = mtl.organization_id
366: and mtl.organization_id = p_organization_id;
367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-3');
368: ELSE /* 7388596*/
369: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-API-2');
370: IF GMF_validations_PVT.Validate_organization_id(p_costorg_id) THEN
371: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory Item Id: '|| l_item_tbl(l_index));
372: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id: '|| p_costorg_id);
373: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_date: '|| sysdate);

Line 371: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory Item Id: '|| l_item_tbl(l_index));

367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-3');
368: ELSE /* 7388596*/
369: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-API-2');
370: IF GMF_validations_PVT.Validate_organization_id(p_costorg_id) THEN
371: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory Item Id: '|| l_item_tbl(l_index));
372: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id: '|| p_costorg_id);
373: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_date: '|| sysdate);
374: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));
375: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));

Line 372: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id: '|| p_costorg_id);

368: ELSE /* 7388596*/
369: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-API-2');
370: IF GMF_validations_PVT.Validate_organization_id(p_costorg_id) THEN
371: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory Item Id: '|| l_item_tbl(l_index));
372: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id: '|| p_costorg_id);
373: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_date: '|| sysdate);
374: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));
375: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));
376: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));

Line 373: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_date: '|| sysdate);

369: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-API-2');
370: IF GMF_validations_PVT.Validate_organization_id(p_costorg_id) THEN
371: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory Item Id: '|| l_item_tbl(l_index));
372: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id: '|| p_costorg_id);
373: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_date: '|| sysdate);
374: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));
375: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));
376: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));
377: v_result_code := GMF_CMCOMMON.Get_Process_Item_Cost

Line 374: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));

370: IF GMF_validations_PVT.Validate_organization_id(p_costorg_id) THEN
371: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory Item Id: '|| l_item_tbl(l_index));
372: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id: '|| p_costorg_id);
373: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_date: '|| sysdate);
374: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));
375: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));
376: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));
377: v_result_code := GMF_CMCOMMON.Get_Process_Item_Cost
378: ( p_api_version => 1

Line 375: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));

371: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory Item Id: '|| l_item_tbl(l_index));
372: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id: '|| p_costorg_id);
373: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_date: '|| sysdate);
374: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));
375: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));
376: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));
377: v_result_code := GMF_CMCOMMON.Get_Process_Item_Cost
378: ( p_api_version => 1
379: , p_init_msg_list => 'F'

Line 376: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));

372: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id: '|| p_costorg_id);
373: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_date: '|| sysdate);
374: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));
375: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));
376: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));
377: v_result_code := GMF_CMCOMMON.Get_Process_Item_Cost
378: ( p_api_version => 1
379: , p_init_msg_list => 'F'
380: , x_return_status => v_return_status

Line 393: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));

389: , p_cost_analysis_code => v_analysis_code
390: , x_total_cost => v_item_cost /* total cost */
391: , x_no_of_rows => v_no_of_rows /* number of detail rows retrieved */
392: );
393: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));
394: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));
395: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));
396: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_result_code: '|| NVL(v_result_code,0));
397: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_total_cost: '|| NVL(v_item_cost,0));

Line 394: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));

390: , x_total_cost => v_item_cost /* total cost */
391: , x_no_of_rows => v_no_of_rows /* number of detail rows retrieved */
392: );
393: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));
394: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));
395: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));
396: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_result_code: '|| NVL(v_result_code,0));
397: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_total_cost: '|| NVL(v_item_cost,0));
398: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_no_of_rows: '|| NVL(v_no_of_rows,0));

Line 395: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));

391: , x_no_of_rows => v_no_of_rows /* number of detail rows retrieved */
392: );
393: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));
394: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));
395: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));
396: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_result_code: '|| NVL(v_result_code,0));
397: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_total_cost: '|| NVL(v_item_cost,0));
398: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_no_of_rows: '|| NVL(v_no_of_rows,0));
399: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_return_status: '|| NVL(v_return_status,'N'));

Line 396: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_result_code: '|| NVL(v_result_code,0));

392: );
393: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));
394: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));
395: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));
396: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_result_code: '|| NVL(v_result_code,0));
397: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_total_cost: '|| NVL(v_item_cost,0));
398: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_no_of_rows: '|| NVL(v_no_of_rows,0));
399: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_return_status: '|| NVL(v_return_status,'N'));
400: IF v_result_code = 1 THEN

Line 397: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_total_cost: '|| NVL(v_item_cost,0));

393: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cost_method: '|| NVL(v_cost_mthd,'NULL'));
394: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));
395: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));
396: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_result_code: '|| NVL(v_result_code,0));
397: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_total_cost: '|| NVL(v_item_cost,0));
398: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_no_of_rows: '|| NVL(v_no_of_rows,0));
399: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_return_status: '|| NVL(v_return_status,'N'));
400: IF v_result_code = 1 THEN
401: SELECT decode(l_min_acct_unit,-1,round(nvl(v_item_cost,0), l_rounding_factor),

Line 398: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_no_of_rows: '|| NVL(v_no_of_rows,0));

394: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_cmpntcls_id: '|| NVL(v_cmpntcls_id,0));
395: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));
396: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_result_code: '|| NVL(v_result_code,0));
397: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_total_cost: '|| NVL(v_item_cost,0));
398: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_no_of_rows: '|| NVL(v_no_of_rows,0));
399: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_return_status: '|| NVL(v_return_status,'N'));
400: IF v_result_code = 1 THEN
401: SELECT decode(l_min_acct_unit,-1,round(nvl(v_item_cost,0), l_rounding_factor),
402: round(nvl(v_item_cost,0)/l_min_acct_unit)*l_min_acct_unit)

Line 399: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_return_status: '|| NVL(v_return_status,'N'));

395: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_analysis_code: '|| NVL(v_analysis_code,'NULL'));
396: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_result_code: '|| NVL(v_result_code,0));
397: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_total_cost: '|| NVL(v_item_cost,0));
398: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_no_of_rows: '|| NVL(v_no_of_rows,0));
399: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_return_status: '|| NVL(v_return_status,'N'));
400: IF v_result_code = 1 THEN
401: SELECT decode(l_min_acct_unit,-1,round(nvl(v_item_cost,0), l_rounding_factor),
402: round(nvl(v_item_cost,0)/l_min_acct_unit)*l_min_acct_unit)
403: INTO l_price

Line 410: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-4-1');

406: l_price := 0;
407: END IF;
408: ELSE
409:
410: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-4-1');
411: select decode(l_min_acct_unit,
412: -1,
413: nvl(cst.item_cost,0),
414: round(nvl(cst.item_cost,0)/l_min_acct_unit)*l_min_acct_unit)

Line 421: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-4');

417: where mtl.inventory_item_id = l_item_tbl(l_index)
418: and cst.inventory_item_id =mtl.inventory_item_id
419: and cst.organization_id = p_costorg_id
420: and mtl.organization_id = p_organization_id;
421: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query-4');
422: END IF;
423: End If;
424:
425: END IF;

Line 429: FND_FILE.PUT_LINE(FND_FILE.LOG, '1ERROR-'||sqlerrm);

425: END IF;
426: Exception
427: When No_Data_Found Then
428: l_price := 0;
429: FND_FILE.PUT_LINE(FND_FILE.LOG, '1ERROR-'||sqlerrm);
430: End;
431:
432:
433: select mtl.primary_uom_code

Line 575: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DO NOT Set list_price = cost');

571: | Create price list line for inventory items not on price list |
572: | DO NOT Set list_price = cost |
573: + --------------------------------------------------------------------------*/
574: ELSE
575: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DO NOT Set list_price = cost');
576: l_index := l_item_tbl.FIRST;
577: WHILE l_index <= l_item_tbl.LAST LOOP
578: begin
579: /*

Line 609: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Number '|| l_item_tbl(l_index) || ' already exists');

605: RAISE;
606: end;
607: IF l_already_exists > 0 THEN
608: -- write rec log of values that cannot be added
609: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Number '|| l_item_tbl(l_index) || ' already exists');
610: ELSE
611:
612: select mtl.primary_uom_code
613: into l_uom

Line 785: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLCODE||' -DK- '||SQLERRM);

781: errbuf:='';
782: EXCEPTION
783: WHEN others THEN
784: ROLLBACK;
785: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLCODE||' -DK- '||SQLERRM);
786: retcode:=2;
787: END Add_Items_To_Price_List;
788:
789: END QP_ADD_ITEM_PRCLIST_PVT;