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_PRL_LOADER_PUB dependencies on FND_API

Line 190: gpr_price_list_rec.list_header_id := FND_API.G_MISS_NUM;

186: rownum < 2;
187: END IF;
188:
189: IF (l_operation = 'C') THEN
190: gpr_price_list_rec.list_header_id := FND_API.G_MISS_NUM;
191: gpr_price_list_rec.rounding_factor := FND_API.G_MISS_NUM;
192: gpr_price_list_rec.operation := QP_GLOBALS.G_OPR_CREATE;
193: END IF;
194:

Line 191: gpr_price_list_rec.rounding_factor := FND_API.G_MISS_NUM;

187: END IF;
188:
189: IF (l_operation = 'C') THEN
190: gpr_price_list_rec.list_header_id := FND_API.G_MISS_NUM;
191: gpr_price_list_rec.rounding_factor := FND_API.G_MISS_NUM;
192: gpr_price_list_rec.operation := QP_GLOBALS.G_OPR_CREATE;
193: END IF;
194:
195: IF (l_operation = 'U') THEN

Line 196: gpr_price_list_rec.rounding_factor := FND_API.G_MISS_NUM;

192: gpr_price_list_rec.operation := QP_GLOBALS.G_OPR_CREATE;
193: END IF;
194:
195: IF (l_operation = 'U') THEN
196: gpr_price_list_rec.rounding_factor := FND_API.G_MISS_NUM;
197: gpr_price_list_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
198: --dbms_output.put_line('Setting operation to update');
199: END IF;
200:

Line 235: gpr_qualifiers_tbl(i).qualifier_attribute := FND_API.G_MISS_CHAR;

231: gpr_qualifiers_tbl(i).qualifier_datatype,
232: gpr_qualifiers_tbl(i).qualifier_grouping_no;
233: EXIT WHEN l_qualifiers%NOTFOUND;
234:
235: gpr_qualifiers_tbl(i).qualifier_attribute := FND_API.G_MISS_CHAR;
236: --gpr_qualifiers_tbl(i).qualifier_attr_value := FND_API.G_MISS_CHAR;
237:
238: IF (l_operation = 'C') THEN
239: gpr_qualifiers_tbl(i).list_header_id := FND_API.G_MISS_NUM;

Line 236: --gpr_qualifiers_tbl(i).qualifier_attr_value := FND_API.G_MISS_CHAR;

232: gpr_qualifiers_tbl(i).qualifier_grouping_no;
233: EXIT WHEN l_qualifiers%NOTFOUND;
234:
235: gpr_qualifiers_tbl(i).qualifier_attribute := FND_API.G_MISS_CHAR;
236: --gpr_qualifiers_tbl(i).qualifier_attr_value := FND_API.G_MISS_CHAR;
237:
238: IF (l_operation = 'C') THEN
239: gpr_qualifiers_tbl(i).list_header_id := FND_API.G_MISS_NUM;
240: gpr_qualifiers_tbl(i).qualifier_id := FND_API.G_MISS_NUM;

Line 239: gpr_qualifiers_tbl(i).list_header_id := FND_API.G_MISS_NUM;

235: gpr_qualifiers_tbl(i).qualifier_attribute := FND_API.G_MISS_CHAR;
236: --gpr_qualifiers_tbl(i).qualifier_attr_value := FND_API.G_MISS_CHAR;
237:
238: IF (l_operation = 'C') THEN
239: gpr_qualifiers_tbl(i).list_header_id := FND_API.G_MISS_NUM;
240: gpr_qualifiers_tbl(i).qualifier_id := FND_API.G_MISS_NUM;
241: gpr_qualifiers_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
242:
243: IF (gpr_qualifiers_tbl(i).excluder_flag IS NULL) THEN

Line 240: gpr_qualifiers_tbl(i).qualifier_id := FND_API.G_MISS_NUM;

236: --gpr_qualifiers_tbl(i).qualifier_attr_value := FND_API.G_MISS_CHAR;
237:
238: IF (l_operation = 'C') THEN
239: gpr_qualifiers_tbl(i).list_header_id := FND_API.G_MISS_NUM;
240: gpr_qualifiers_tbl(i).qualifier_id := FND_API.G_MISS_NUM;
241: gpr_qualifiers_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
242:
243: IF (gpr_qualifiers_tbl(i).excluder_flag IS NULL) THEN
244: gpr_qualifiers_tbl(i).excluder_flag:= FND_API.G_MISS_CHAR;

Line 244: gpr_qualifiers_tbl(i).excluder_flag:= FND_API.G_MISS_CHAR;

240: gpr_qualifiers_tbl(i).qualifier_id := FND_API.G_MISS_NUM;
241: gpr_qualifiers_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
242:
243: IF (gpr_qualifiers_tbl(i).excluder_flag IS NULL) THEN
244: gpr_qualifiers_tbl(i).excluder_flag:= FND_API.G_MISS_CHAR;
245: END IF;
246:
247: IF (gpr_qualifiers_tbl(i).qualifier_grouping_no IS NULL) THEN
248: gpr_qualifiers_tbl(i).qualifier_grouping_no:= FND_API.G_MISS_NUM;

Line 248: gpr_qualifiers_tbl(i).qualifier_grouping_no:= FND_API.G_MISS_NUM;

244: gpr_qualifiers_tbl(i).excluder_flag:= FND_API.G_MISS_CHAR;
245: END IF;
246:
247: IF (gpr_qualifiers_tbl(i).qualifier_grouping_no IS NULL) THEN
248: gpr_qualifiers_tbl(i).qualifier_grouping_no:= FND_API.G_MISS_NUM;
249: END IF;
250: END IF;
251:
252: IF (l_operation = 'U') THEN

Line 303: gpr_price_list_line_tbl(i).list_header_id := FND_API.G_MISS_NUM;

299: EXIT WHEN l_lines%NOTFOUND;
300:
301: IF (l_operation = 'C') THEN
302: IF (gpr_price_list_line_tbl(i).list_header_id IS NULL) THEN
303: gpr_price_list_line_tbl(i).list_header_id := FND_API.G_MISS_NUM;
304: END IF;
305:
306: IF (gpr_price_list_line_tbl(i).list_line_no IS NULL) THEN
307: gpr_price_list_line_tbl(i).list_line_no := FND_API.G_MISS_NUM;

Line 307: gpr_price_list_line_tbl(i).list_line_no := FND_API.G_MISS_NUM;

303: gpr_price_list_line_tbl(i).list_header_id := FND_API.G_MISS_NUM;
304: END IF;
305:
306: IF (gpr_price_list_line_tbl(i).list_line_no IS NULL) THEN
307: gpr_price_list_line_tbl(i).list_line_no := FND_API.G_MISS_NUM;
308: END IF;
309:
310: gpr_price_list_line_tbl(i).list_line_id := FND_API.G_MISS_NUM;
311: gpr_price_list_line_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;

Line 310: gpr_price_list_line_tbl(i).list_line_id := FND_API.G_MISS_NUM;

306: IF (gpr_price_list_line_tbl(i).list_line_no IS NULL) THEN
307: gpr_price_list_line_tbl(i).list_line_no := FND_API.G_MISS_NUM;
308: END IF;
309:
310: gpr_price_list_line_tbl(i).list_line_id := FND_API.G_MISS_NUM;
311: gpr_price_list_line_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;
312: gpr_price_list_line_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;
313: gpr_price_list_line_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;
314: gpr_price_list_line_tbl(i).rltd_modifier_group_no := FND_API.G_MISS_NUM;

Line 311: gpr_price_list_line_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;

307: gpr_price_list_line_tbl(i).list_line_no := FND_API.G_MISS_NUM;
308: END IF;
309:
310: gpr_price_list_line_tbl(i).list_line_id := FND_API.G_MISS_NUM;
311: gpr_price_list_line_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;
312: gpr_price_list_line_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;
313: gpr_price_list_line_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;
314: gpr_price_list_line_tbl(i).rltd_modifier_group_no := FND_API.G_MISS_NUM;
315: gpr_price_list_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;

Line 312: gpr_price_list_line_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;

308: END IF;
309:
310: gpr_price_list_line_tbl(i).list_line_id := FND_API.G_MISS_NUM;
311: gpr_price_list_line_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;
312: gpr_price_list_line_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;
313: gpr_price_list_line_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;
314: gpr_price_list_line_tbl(i).rltd_modifier_group_no := FND_API.G_MISS_NUM;
315: gpr_price_list_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
316:

Line 313: gpr_price_list_line_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;

309:
310: gpr_price_list_line_tbl(i).list_line_id := FND_API.G_MISS_NUM;
311: gpr_price_list_line_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;
312: gpr_price_list_line_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;
313: gpr_price_list_line_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;
314: gpr_price_list_line_tbl(i).rltd_modifier_group_no := FND_API.G_MISS_NUM;
315: gpr_price_list_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
316:
317: IF (gpr_price_list_line_tbl(i).automatic_flag IS NULL) THEN

Line 314: gpr_price_list_line_tbl(i).rltd_modifier_group_no := FND_API.G_MISS_NUM;

310: gpr_price_list_line_tbl(i).list_line_id := FND_API.G_MISS_NUM;
311: gpr_price_list_line_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;
312: gpr_price_list_line_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;
313: gpr_price_list_line_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;
314: gpr_price_list_line_tbl(i).rltd_modifier_group_no := FND_API.G_MISS_NUM;
315: gpr_price_list_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
316:
317: IF (gpr_price_list_line_tbl(i).automatic_flag IS NULL) THEN
318: gpr_price_list_line_tbl(i).automatic_flag := FND_API.G_MISS_CHAR;

Line 318: gpr_price_list_line_tbl(i).automatic_flag := FND_API.G_MISS_CHAR;

314: gpr_price_list_line_tbl(i).rltd_modifier_group_no := FND_API.G_MISS_NUM;
315: gpr_price_list_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
316:
317: IF (gpr_price_list_line_tbl(i).automatic_flag IS NULL) THEN
318: gpr_price_list_line_tbl(i).automatic_flag := FND_API.G_MISS_CHAR;
319: END IF;
320:
321: IF (gpr_price_list_line_tbl(i).modifier_level_code IS NULL) THEN
322: gpr_price_list_line_tbl(i).modifier_level_code := FND_API.G_MISS_CHAR;

Line 322: gpr_price_list_line_tbl(i).modifier_level_code := FND_API.G_MISS_CHAR;

318: gpr_price_list_line_tbl(i).automatic_flag := FND_API.G_MISS_CHAR;
319: END IF;
320:
321: IF (gpr_price_list_line_tbl(i).modifier_level_code IS NULL) THEN
322: gpr_price_list_line_tbl(i).modifier_level_code := FND_API.G_MISS_CHAR;
323: END IF;
324: END IF;
325:
326: IF (l_operation = 'U') THEN

Line 384: gpr_pricing_attr_tbl(i).pricing_attribute_id := FND_API.G_MISS_NUM;

380: EXIT WHEN l_pricing_attribs%NOTFOUND;
381:
382:
383: IF (l_operation = 'C') THEN
384: gpr_pricing_attr_tbl(i).pricing_attribute_id := FND_API.G_MISS_NUM;
385: gpr_pricing_attr_tbl(i).list_line_id := FND_API.G_MISS_NUM;
386:
387: IF (gpr_pricing_attr_tbl(i).list_header_id IS NULL) THEN
388: gpr_pricing_attr_tbl(i).list_header_id := FND_API.G_MISS_NUM;

Line 385: gpr_pricing_attr_tbl(i).list_line_id := FND_API.G_MISS_NUM;

381:
382:
383: IF (l_operation = 'C') THEN
384: gpr_pricing_attr_tbl(i).pricing_attribute_id := FND_API.G_MISS_NUM;
385: gpr_pricing_attr_tbl(i).list_line_id := FND_API.G_MISS_NUM;
386:
387: IF (gpr_pricing_attr_tbl(i).list_header_id IS NULL) THEN
388: gpr_pricing_attr_tbl(i).list_header_id := FND_API.G_MISS_NUM;
389: END IF;

Line 388: gpr_pricing_attr_tbl(i).list_header_id := FND_API.G_MISS_NUM;

384: gpr_pricing_attr_tbl(i).pricing_attribute_id := FND_API.G_MISS_NUM;
385: gpr_pricing_attr_tbl(i).list_line_id := FND_API.G_MISS_NUM;
386:
387: IF (gpr_pricing_attr_tbl(i).list_header_id IS NULL) THEN
388: gpr_pricing_attr_tbl(i).list_header_id := FND_API.G_MISS_NUM;
389: END IF;
390:
391: gpr_pricing_attr_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
392: gpr_pricing_attr_tbl(i).pricing_attribute := FND_API.G_MISS_CHAR;

Line 392: gpr_pricing_attr_tbl(i).pricing_attribute := FND_API.G_MISS_CHAR;

388: gpr_pricing_attr_tbl(i).list_header_id := FND_API.G_MISS_NUM;
389: END IF;
390:
391: gpr_pricing_attr_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
392: gpr_pricing_attr_tbl(i).pricing_attribute := FND_API.G_MISS_CHAR;
393: gpr_pricing_attr_tbl(i).pricing_attr_value_from := FND_API.G_MISS_CHAR;
394: gpr_pricing_attr_tbl(i).pricing_attr_value_to := FND_API.G_MISS_CHAR;
395:
396: IF (gpr_pricing_attr_tbl(i).excluder_flag IS NULL) THEN

Line 393: gpr_pricing_attr_tbl(i).pricing_attr_value_from := FND_API.G_MISS_CHAR;

389: END IF;
390:
391: gpr_pricing_attr_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
392: gpr_pricing_attr_tbl(i).pricing_attribute := FND_API.G_MISS_CHAR;
393: gpr_pricing_attr_tbl(i).pricing_attr_value_from := FND_API.G_MISS_CHAR;
394: gpr_pricing_attr_tbl(i).pricing_attr_value_to := FND_API.G_MISS_CHAR;
395:
396: IF (gpr_pricing_attr_tbl(i).excluder_flag IS NULL) THEN
397: gpr_pricing_attr_tbl(i).excluder_flag := FND_API.G_MISS_CHAR;

Line 394: gpr_pricing_attr_tbl(i).pricing_attr_value_to := FND_API.G_MISS_CHAR;

390:
391: gpr_pricing_attr_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
392: gpr_pricing_attr_tbl(i).pricing_attribute := FND_API.G_MISS_CHAR;
393: gpr_pricing_attr_tbl(i).pricing_attr_value_from := FND_API.G_MISS_CHAR;
394: gpr_pricing_attr_tbl(i).pricing_attr_value_to := FND_API.G_MISS_CHAR;
395:
396: IF (gpr_pricing_attr_tbl(i).excluder_flag IS NULL) THEN
397: gpr_pricing_attr_tbl(i).excluder_flag := FND_API.G_MISS_CHAR;
398: END IF;

Line 397: gpr_pricing_attr_tbl(i).excluder_flag := FND_API.G_MISS_CHAR;

393: gpr_pricing_attr_tbl(i).pricing_attr_value_from := FND_API.G_MISS_CHAR;
394: gpr_pricing_attr_tbl(i).pricing_attr_value_to := FND_API.G_MISS_CHAR;
395:
396: IF (gpr_pricing_attr_tbl(i).excluder_flag IS NULL) THEN
397: gpr_pricing_attr_tbl(i).excluder_flag := FND_API.G_MISS_CHAR;
398: END IF;
399:
400: IF (gpr_pricing_attr_tbl(i).attribute_grouping_no IS NULL) THEN
401: gpr_pricing_attr_tbl(i).attribute_grouping_no := FND_API.G_MISS_NUM;

Line 401: gpr_pricing_attr_tbl(i).attribute_grouping_no := FND_API.G_MISS_NUM;

397: gpr_pricing_attr_tbl(i).excluder_flag := FND_API.G_MISS_CHAR;
398: END IF;
399:
400: IF (gpr_pricing_attr_tbl(i).attribute_grouping_no IS NULL) THEN
401: gpr_pricing_attr_tbl(i).attribute_grouping_no := FND_API.G_MISS_NUM;
402: END IF;
403:
404:
405: IF (gpr_pricing_attr_tbl(i).product_attribute_datatype IS NULL) THEN

Line 406: --gpr_pricing_attr_tbl(i).product_attribute_datatype := FND_API.G_MISS_CHAR;

402: END IF;
403:
404:
405: IF (gpr_pricing_attr_tbl(i).product_attribute_datatype IS NULL) THEN
406: --gpr_pricing_attr_tbl(i).product_attribute_datatype := FND_API.G_MISS_CHAR;
407: gpr_pricing_attr_tbl(i).product_attribute_datatype := 'C';
408: END IF;
409:
410: IF (gpr_pricing_attr_tbl(i).pricing_attribute_datatype IS NULL) THEN

Line 411: --gpr_pricing_attr_tbl(i).pricing_attribute_datatype := FND_API.G_MISS_CHAR;

407: gpr_pricing_attr_tbl(i).product_attribute_datatype := 'C';
408: END IF;
409:
410: IF (gpr_pricing_attr_tbl(i).pricing_attribute_datatype IS NULL) THEN
411: --gpr_pricing_attr_tbl(i).pricing_attribute_datatype := FND_API.G_MISS_CHAR;
412: gpr_pricing_attr_tbl(i).pricing_attribute_datatype := 'C';
413: END IF;
414: END IF;
415:

Line 451: , p_init_msg_list => FND_API.G_FALSE

447:
448:
449: QP_PRICE_LIST_PUB.Process_Price_List
450: ( p_api_version_number => 1
451: , p_init_msg_list => FND_API.G_FALSE
452: , p_return_values => FND_API.G_FALSE
453: , p_commit => FND_API.G_FALSE
454: , x_return_status => gpr_return_status
455: , x_msg_count => gpr_msg_count

Line 452: , p_return_values => FND_API.G_FALSE

448:
449: QP_PRICE_LIST_PUB.Process_Price_List
450: ( p_api_version_number => 1
451: , p_init_msg_list => FND_API.G_FALSE
452: , p_return_values => FND_API.G_FALSE
453: , p_commit => FND_API.G_FALSE
454: , x_return_status => gpr_return_status
455: , x_msg_count => gpr_msg_count
456: , x_msg_data => gpr_msg_data

Line 453: , p_commit => FND_API.G_FALSE

449: QP_PRICE_LIST_PUB.Process_Price_List
450: ( p_api_version_number => 1
451: , p_init_msg_list => FND_API.G_FALSE
452: , p_return_values => FND_API.G_FALSE
453: , p_commit => FND_API.G_FALSE
454: , x_return_status => gpr_return_status
455: , x_msg_count => gpr_msg_count
456: , x_msg_data => gpr_msg_data
457: , p_PRICE_LIST_rec => gpr_price_list_rec

Line 473: IF gpr_return_status = FND_API.G_RET_STS_SUCCESS THEN

469: , x_PRICING_ATTR_tbl => ppr_pricing_attr_tbl
470: , x_PRICING_ATTR_val_tbl => ppr_pricing_attr_val_tbl
471: );
472:
473: IF gpr_return_status = FND_API.G_RET_STS_SUCCESS THEN
474: x_status := 'COMPLETED';
475: --dbms_output.put_line('Successfully completed Pricelist BOI');
476: END IF;
477:

Line 478: IF gpr_return_status <> FND_API.G_RET_STS_SUCCESS THEN

474: x_status := 'COMPLETED';
475: --dbms_output.put_line('Successfully completed Pricelist BOI');
476: END IF;
477:
478: IF gpr_return_status <> FND_API.G_RET_STS_SUCCESS THEN
479:
480: x_status := 'FAILED';
481: for k in 1 .. gpr_msg_count loop
482: gpr_msg_data := oe_msg_pub.get( p_msg_index => k, p_encoded => 'F');

Line 497: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

493: --dbms_output.put_line('X_STATUS : ' || x_status);
494: --dbms_output.put_line('X_ERRORS : ' || x_errors);
495:
496: rollback;
497: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498:
499: END IF;
500:
501: --dbms_output.put_line('after process price list ');