DBA Data[Home] [Help]

APPS.QP_MOD_LOADER_PUB dependencies on FND_API

Line 198: gpr_modifier_list_rec.list_header_id := FND_API.G_MISS_NUM;

194:
195: END IF;
196:
197: IF (l_operation = 'C') THEN
198: gpr_modifier_list_rec.list_header_id := FND_API.G_MISS_NUM;
199: gpr_modifier_list_rec.operation := QP_GLOBALS.G_OPR_CREATE;
200: END IF;
201:
202: IF (l_operation = 'U') THEN

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

239: gpr_qualifiers_tbl(i).qualifier_datatype,
240: gpr_qualifiers_tbl(i).qualifier_grouping_no;
241: EXIT WHEN l_qualifiers%NOTFOUND;
242:
243: gpr_qualifiers_tbl(i).qualifier_attribute := FND_API.G_MISS_CHAR;
244: --gpr_qualifiers_tbl(i).qualifier_attr_value := FND_API.G_MISS_CHAR;
245:
246: IF (l_operation = 'C') THEN
247: gpr_qualifiers_tbl(i).list_header_id := FND_API.G_MISS_NUM;

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

240: gpr_qualifiers_tbl(i).qualifier_grouping_no;
241: EXIT WHEN l_qualifiers%NOTFOUND;
242:
243: gpr_qualifiers_tbl(i).qualifier_attribute := FND_API.G_MISS_CHAR;
244: --gpr_qualifiers_tbl(i).qualifier_attr_value := FND_API.G_MISS_CHAR;
245:
246: IF (l_operation = 'C') THEN
247: gpr_qualifiers_tbl(i).list_header_id := FND_API.G_MISS_NUM;
248: gpr_qualifiers_tbl(i).qualifier_id := FND_API.G_MISS_NUM;

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

243: gpr_qualifiers_tbl(i).qualifier_attribute := FND_API.G_MISS_CHAR;
244: --gpr_qualifiers_tbl(i).qualifier_attr_value := FND_API.G_MISS_CHAR;
245:
246: IF (l_operation = 'C') THEN
247: gpr_qualifiers_tbl(i).list_header_id := FND_API.G_MISS_NUM;
248: gpr_qualifiers_tbl(i).qualifier_id := FND_API.G_MISS_NUM;
249: gpr_qualifiers_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
250:
251: IF (gpr_qualifiers_tbl(i).excluder_flag IS NULL) THEN

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

244: --gpr_qualifiers_tbl(i).qualifier_attr_value := FND_API.G_MISS_CHAR;
245:
246: IF (l_operation = 'C') THEN
247: gpr_qualifiers_tbl(i).list_header_id := FND_API.G_MISS_NUM;
248: gpr_qualifiers_tbl(i).qualifier_id := FND_API.G_MISS_NUM;
249: gpr_qualifiers_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
250:
251: IF (gpr_qualifiers_tbl(i).excluder_flag IS NULL) THEN
252: gpr_qualifiers_tbl(i).excluder_flag:= FND_API.G_MISS_CHAR;

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

248: gpr_qualifiers_tbl(i).qualifier_id := FND_API.G_MISS_NUM;
249: gpr_qualifiers_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
250:
251: IF (gpr_qualifiers_tbl(i).excluder_flag IS NULL) THEN
252: gpr_qualifiers_tbl(i).excluder_flag:= FND_API.G_MISS_CHAR;
253: END IF;
254:
255: IF (gpr_qualifiers_tbl(i).qualifier_grouping_no IS NULL) THEN
256: gpr_qualifiers_tbl(i).qualifier_grouping_no:= FND_API.G_MISS_NUM;

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

252: gpr_qualifiers_tbl(i).excluder_flag:= FND_API.G_MISS_CHAR;
253: END IF;
254:
255: IF (gpr_qualifiers_tbl(i).qualifier_grouping_no IS NULL) THEN
256: gpr_qualifiers_tbl(i).qualifier_grouping_no:= FND_API.G_MISS_NUM;
257: END IF;
258:
259:
260: END IF;

Line 317: gpr_modifiers_tbl(i).list_header_id := FND_API.G_MISS_NUM;

313: EXIT WHEN l_lines%NOTFOUND;
314:
315: IF (l_operation = 'C') THEN
316: IF (gpr_modifiers_tbl(i).list_header_id IS NULL) THEN
317: gpr_modifiers_tbl(i).list_header_id := FND_API.G_MISS_NUM;
318: END IF;
319:
320: IF (gpr_modifiers_tbl(i).list_line_no IS NULL) THEN
321: gpr_modifiers_tbl(i).list_line_no := FND_API.G_MISS_CHAR;

Line 321: gpr_modifiers_tbl(i).list_line_no := FND_API.G_MISS_CHAR;

317: gpr_modifiers_tbl(i).list_header_id := FND_API.G_MISS_NUM;
318: END IF;
319:
320: IF (gpr_modifiers_tbl(i).list_line_no IS NULL) THEN
321: gpr_modifiers_tbl(i).list_line_no := FND_API.G_MISS_CHAR;
322: END IF;
323:
324: --dbms_output.put_line('Here is modifier_parent_index : ' || gpr_modifiers_tbl(i).modifier_parent_index);
325: IF (gpr_modifiers_tbl(i).modifier_parent_index IS NOT NULL) THEN

Line 329: gpr_modifiers_tbl(i).list_line_id := FND_API.G_MISS_NUM;

325: IF (gpr_modifiers_tbl(i).modifier_parent_index IS NOT NULL) THEN
326: gpr_modifiers_tbl(i).rltd_modifier_grp_type := 'PRICE BREAK';
327: END IF;
328:
329: gpr_modifiers_tbl(i).list_line_id := FND_API.G_MISS_NUM;
330: gpr_modifiers_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;
331: gpr_modifiers_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;
332: gpr_modifiers_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;
333: gpr_modifiers_tbl(i).rltd_modifier_grp_no := 10;

Line 330: gpr_modifiers_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;

326: gpr_modifiers_tbl(i).rltd_modifier_grp_type := 'PRICE BREAK';
327: END IF;
328:
329: gpr_modifiers_tbl(i).list_line_id := FND_API.G_MISS_NUM;
330: gpr_modifiers_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;
331: gpr_modifiers_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;
332: gpr_modifiers_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;
333: gpr_modifiers_tbl(i).rltd_modifier_grp_no := 10;
334: gpr_modifiers_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;

Line 331: gpr_modifiers_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;

327: END IF;
328:
329: gpr_modifiers_tbl(i).list_line_id := FND_API.G_MISS_NUM;
330: gpr_modifiers_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;
331: gpr_modifiers_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;
332: gpr_modifiers_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;
333: gpr_modifiers_tbl(i).rltd_modifier_grp_no := 10;
334: gpr_modifiers_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
335: END IF;

Line 332: gpr_modifiers_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;

328:
329: gpr_modifiers_tbl(i).list_line_id := FND_API.G_MISS_NUM;
330: gpr_modifiers_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;
331: gpr_modifiers_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;
332: gpr_modifiers_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;
333: gpr_modifiers_tbl(i).rltd_modifier_grp_no := 10;
334: gpr_modifiers_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
335: END IF;
336:

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

399:
400: IF (l_operation = 'C') THEN
401:
402: IF (gpr_pricing_attr_tbl(i).list_header_id IS NULL) THEN
403: gpr_pricing_attr_tbl(i).list_header_id := FND_API.G_MISS_NUM;
404: END IF;
405:
406: gpr_pricing_attr_tbl(i).pricing_attribute_id := FND_API.G_MISS_NUM;
407: gpr_pricing_attr_tbl(i).list_line_id := FND_API.G_MISS_NUM;

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

402: IF (gpr_pricing_attr_tbl(i).list_header_id IS NULL) THEN
403: gpr_pricing_attr_tbl(i).list_header_id := FND_API.G_MISS_NUM;
404: END IF;
405:
406: gpr_pricing_attr_tbl(i).pricing_attribute_id := FND_API.G_MISS_NUM;
407: gpr_pricing_attr_tbl(i).list_line_id := FND_API.G_MISS_NUM;
408: gpr_pricing_attr_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
409: gpr_pricing_attr_tbl(i).pricing_attribute := FND_API.G_MISS_CHAR;
410: gpr_pricing_attr_tbl(i).pricing_attr_value_from := FND_API.G_MISS_CHAR;

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

403: gpr_pricing_attr_tbl(i).list_header_id := FND_API.G_MISS_NUM;
404: END IF;
405:
406: gpr_pricing_attr_tbl(i).pricing_attribute_id := FND_API.G_MISS_NUM;
407: gpr_pricing_attr_tbl(i).list_line_id := FND_API.G_MISS_NUM;
408: gpr_pricing_attr_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
409: gpr_pricing_attr_tbl(i).pricing_attribute := FND_API.G_MISS_CHAR;
410: gpr_pricing_attr_tbl(i).pricing_attr_value_from := FND_API.G_MISS_CHAR;
411: gpr_pricing_attr_tbl(i).pricing_attr_value_to := FND_API.G_MISS_CHAR;

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

405:
406: gpr_pricing_attr_tbl(i).pricing_attribute_id := FND_API.G_MISS_NUM;
407: gpr_pricing_attr_tbl(i).list_line_id := FND_API.G_MISS_NUM;
408: gpr_pricing_attr_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
409: gpr_pricing_attr_tbl(i).pricing_attribute := FND_API.G_MISS_CHAR;
410: gpr_pricing_attr_tbl(i).pricing_attr_value_from := FND_API.G_MISS_CHAR;
411: gpr_pricing_attr_tbl(i).pricing_attr_value_to := FND_API.G_MISS_CHAR;
412:
413: END IF;

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

406: gpr_pricing_attr_tbl(i).pricing_attribute_id := FND_API.G_MISS_NUM;
407: gpr_pricing_attr_tbl(i).list_line_id := FND_API.G_MISS_NUM;
408: gpr_pricing_attr_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
409: gpr_pricing_attr_tbl(i).pricing_attribute := FND_API.G_MISS_CHAR;
410: gpr_pricing_attr_tbl(i).pricing_attr_value_from := FND_API.G_MISS_CHAR;
411: gpr_pricing_attr_tbl(i).pricing_attr_value_to := FND_API.G_MISS_CHAR;
412:
413: END IF;
414:

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

407: gpr_pricing_attr_tbl(i).list_line_id := FND_API.G_MISS_NUM;
408: gpr_pricing_attr_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
409: gpr_pricing_attr_tbl(i).pricing_attribute := FND_API.G_MISS_CHAR;
410: gpr_pricing_attr_tbl(i).pricing_attr_value_from := FND_API.G_MISS_CHAR;
411: gpr_pricing_attr_tbl(i).pricing_attr_value_to := FND_API.G_MISS_CHAR;
412:
413: END IF;
414:
415: IF (l_operation = 'U') THEN

Line 450: , p_init_msg_list => FND_API.G_FALSE

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

Line 451: , p_return_values => FND_API.G_FALSE

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

Line 452: , p_commit => FND_API.G_FALSE

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

Line 474: IF gpr_return_status = FND_API.G_RET_STS_SUCCESS THEN

470: , x_PRICING_ATTR_tbl => ppr_pricing_attr_tbl
471: , x_PRICING_ATTR_val_tbl => ppr_pricing_attr_val_tbl
472: );
473:
474: IF gpr_return_status = FND_API.G_RET_STS_SUCCESS THEN
475: x_status := 'COMPLETED';
476: END IF;
477:
478: IF gpr_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 478: IF gpr_return_status <> FND_API.G_RET_STS_SUCCESS THEN

474: IF gpr_return_status = FND_API.G_RET_STS_SUCCESS THEN
475: x_status := 'COMPLETED';
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: