DBA Data[Home] [Help]

APPS.QP_QP_FORM_PRICING_ATTR dependencies on OE_DEBUG_PUB

Line 92: oe_debug_pub.add('BEGIN Default_Attributes in QPXFPRAB');

88: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
89: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
90: BEGIN
91:
92: oe_debug_pub.add('BEGIN Default_Attributes in QPXFPRAB');
93:
94: -- Set control flags.
95:
96: l_control_rec.controlled_operation := TRUE;

Line 140: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp_no QPXFPRAB');

136: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_CREATE;
137:
138: -- Populate PRICING_ATTR table
139:
140: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp_no QPXFPRAB');
141: l_PRICING_ATTR_tbl(1) := l_PRICING_ATTR_rec;
142:
143: -- Call QP_Modifiers_PVT.Process_MODIFIERS
144:

Line 236: oe_debug_pub.add('END Default_Attributes in QPXFPRAB');

232: , p_data => x_msg_data
233: );
234:
235:
236: oe_debug_pub.add('END Default_Attributes in QPXFPRAB');
237:
238: EXCEPTION
239:
240: WHEN FND_API.G_EXC_ERROR THEN

Line 363: oe_debug_pub.add('BEGIN Change_Attribute in QPXFPRAB');

359: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
360: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
361: BEGIN
362:
363: oe_debug_pub.add('BEGIN Change_Attribute in QPXFPRAB');
364:
365: -- Set control flags.
366:
367: l_control_rec.controlled_operation := TRUE;

Line 381: OE_Debug_PUB.add('here');

377: l_control_rec.clear_api_cache := FALSE;
378: l_control_rec.clear_api_requests := FALSE;
379:
380: -- Read PRICING_ATTR from cache
381: OE_Debug_PUB.add('here');
382:
383: l_PRICING_ATTR_rec := Get_PRICING_ATTR
384: ( p_db_record => FALSE
385: , p_pricing_attribute_id => p_pricing_attribute_id

Line 388: OE_Debug_PUB.add('here1');

384: ( p_db_record => FALSE
385: , p_pricing_attribute_id => p_pricing_attribute_id
386: );
387:
388: OE_Debug_PUB.add('here1');
389: l_old_PRICING_ATTR_rec := l_PRICING_ATTR_rec;
390:
391: IF p_attr_id = QP_Pricing_Attr_Util.G_ACCUMULATE THEN
392: l_PRICING_ATTR_rec.accumulate_flag := p_attr_value;

Line 397: OE_Debug_PUB.add(p_attr_value||'exclude here1');

393: ELSIF p_attr_id = QP_Pricing_Attr_Util.G_ATTRIBUTE_GROUPING_NO THEN
394: l_PRICING_ATTR_rec.attribute_grouping_no := TO_NUMBER(p_attr_value);
395: ELSIF p_attr_id = QP_Pricing_Attr_Util.G_EXCLUDER THEN
396: l_PRICING_ATTR_rec.excluder_flag := p_attr_value;
397: OE_Debug_PUB.add(p_attr_value||'exclude here1');
398: ELSIF p_attr_id = QP_Pricing_Attr_Util.G_LIST_LINE THEN
399: l_PRICING_ATTR_rec.list_line_id := TO_NUMBER(p_attr_value);
400: ELSIF p_attr_id = QP_Pricing_Attr_Util.G_PRICING_ATTRIBUTE THEN
401: OE_Debug_PUB.add(p_attr_id||'attr_value'||QP_Pricing_attr_Util.G_PRICING_ATTRIBUTE);

Line 401: OE_Debug_PUB.add(p_attr_id||'attr_value'||QP_Pricing_attr_Util.G_PRICING_ATTRIBUTE);

397: OE_Debug_PUB.add(p_attr_value||'exclude here1');
398: ELSIF p_attr_id = QP_Pricing_Attr_Util.G_LIST_LINE THEN
399: l_PRICING_ATTR_rec.list_line_id := TO_NUMBER(p_attr_value);
400: ELSIF p_attr_id = QP_Pricing_Attr_Util.G_PRICING_ATTRIBUTE THEN
401: OE_Debug_PUB.add(p_attr_id||'attr_value'||QP_Pricing_attr_Util.G_PRICING_ATTRIBUTE);
402: l_PRICING_ATTR_rec.pricing_attribute := p_attr_value;
403: ELSIF p_attr_id = QP_Pricing_Attr_Util.G_PRICING_ATTRIBUTE_CONTEXT THEN
404: l_PRICING_ATTR_rec.pricing_attribute_context := p_attr_value;
405: ELSIF p_attr_id = QP_Pricing_Attr_Util.G_PRICING_ATTRIBUTE THEN

Line 477: OE_Debug_PUB.add('operation');

473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474:
475: END IF;
476:
477: OE_Debug_PUB.add('operation');
478: -- Set Operation.
479:
480: IF FND_API.To_Boolean(l_PRICING_ATTR_rec.db_flag) THEN
481: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line 493: OE_Debug_PUB.add('process mod');

489: l_old_PRICING_ATTR_tbl(1) := l_old_PRICING_ATTR_rec;
490:
491: -- Call QP_Modifiers_PVT.Process_MODIFIERS
492:
493: OE_Debug_PUB.add('process mod');
494: QP_Modifiers_PVT.Process_MODIFIERS
495: ( p_api_version_number => 1.0
496: , p_init_msg_list => FND_API.G_TRUE
497: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

Line 517: OE_Debug_PUB.add('after process mod');

513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515:
516:
517: OE_Debug_PUB.add('after process mod');
518: -- Unload out tbl
519:
520: l_x_PRICING_ATTR_rec := l_x_PRICING_ATTR_tbl(1);
521:

Line 785: oe_debug_pub.add('END Change_Attribute in QPXFPRAB');

781: ( p_count => x_msg_count
782: , p_data => x_msg_data
783: );
784:
785: oe_debug_pub.add('END Change_Attribute in QPXFPRAB');
786:
787: EXCEPTION
788:
789: WHEN FND_API.G_EXC_ERROR THEN

Line 862: oe_debug_pub.add('BEGIN Validate_And_Write in QPXFPRAB');

858: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
859: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
860: BEGIN
861:
862: oe_debug_pub.add('BEGIN Validate_And_Write in QPXFPRAB');
863:
864: -- Set control flags.
865:
866: l_control_rec.controlled_operation := TRUE;

Line 958: oe_debug_pub.add('END Validate_And_Write in QPXFPRAB');

954: ( p_count => x_msg_count
955: , p_data => x_msg_data
956: );
957:
958: oe_debug_pub.add('END Validate_And_Write in QPXFPRAB');
959:
960: EXCEPTION
961:
962: WHEN FND_API.G_EXC_ERROR THEN

Line 1028: oe_debug_pub.add('BEGIN Delete_Row in QPXFPRAB');

1024: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1025: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1026: BEGIN
1027:
1028: oe_debug_pub.add('BEGIN Delete_Row in QPXFPRAB');
1029:
1030: -- Set control flags.
1031:
1032: l_control_rec.controlled_operation := TRUE;

Line 1071: oe_debug_pub.add('failed in logging a delayed request in delete_row ');

1067: x_return_status => l_return_status);
1068:
1069: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1070:
1071: oe_debug_pub.add('failed in logging a delayed request in delete_row ');
1072:
1073: RAISE FND_API.G_EXC_ERROR;
1074:
1075: END IF;

Line 1114: oe_debug_pub.add('END Delete_Row in QPXFPRAB');

1110: ( p_count => x_msg_count
1111: , p_data => x_msg_data
1112: );
1113:
1114: oe_debug_pub.add('END Delete_Row in QPXFPRAB');
1115:
1116: EXCEPTION
1117:
1118: WHEN FND_API.G_EXC_ERROR THEN

Line 1181: oe_debug_pub.add('BEGIN Process_Entity in QPXFPRAB');

1177: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1178: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1179: BEGIN
1180:
1181: oe_debug_pub.add('BEGIN Process_Entity in QPXFPRAB');
1182:
1183: -- Set control flags.
1184:
1185: l_control_rec.controlled_operation := TRUE;

Line 1232: oe_debug_pub.add('END Process_Entity in QPXFPRAB');

1228: ( p_count => x_msg_count
1229: , p_data => x_msg_data
1230: );
1231:
1232: oe_debug_pub.add('END Process_Entity in QPXFPRAB');
1233:
1234: EXCEPTION
1235:
1236: WHEN FND_API.G_EXC_ERROR THEN

Line 1341: oe_debug_pub.add('BEGIN Lock_Row in QPXFPRAB');

1337: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1338: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1339: BEGIN
1340:
1341: oe_debug_pub.add('BEGIN Lock_Row in QPXFPRAB');
1342: oe_debug_pub.add('BEGIN Lock_Row in QPXFPRAB');
1343:
1344: -- Load PRICING_ATTR record
1345:

Line 1342: oe_debug_pub.add('BEGIN Lock_Row in QPXFPRAB');

1338: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1339: BEGIN
1340:
1341: oe_debug_pub.add('BEGIN Lock_Row in QPXFPRAB');
1342: oe_debug_pub.add('BEGIN Lock_Row in QPXFPRAB');
1343:
1344: -- Load PRICING_ATTR record
1345:
1346: l_PRICING_ATTR_rec.accumulate_flag := p_accumulate_flag;

Line 1433: oe_debug_pub.add('END Lock_Row in QPXFPRAB');

1429: , p_data => x_msg_data
1430: );
1431:
1432:
1433: oe_debug_pub.add('END Lock_Row in QPXFPRAB');
1434:
1435: EXCEPTION
1436:
1437: WHEN OTHERS THEN

Line 1469: oe_debug_pub.add('BEGIN Write_PRICING_ATTR in QPXFPRAB');

1465: )
1466: IS
1467: BEGIN
1468:
1469: oe_debug_pub.add('BEGIN Write_PRICING_ATTR in QPXFPRAB');
1470:
1471: g_PRICING_ATTR_rec := p_PRICING_ATTR_rec;
1472:
1473: IF p_db_record THEN

Line 1479: oe_debug_pub.add('END Write_PRICING_ATTR in QPXFPRAB');

1475: g_db_PRICING_ATTR_rec := p_PRICING_ATTR_rec;
1476:
1477: END IF;
1478:
1479: oe_debug_pub.add('END Write_PRICING_ATTR in QPXFPRAB');
1480:
1481: END Write_Pricing_Attr;
1482:
1483: FUNCTION Get_PRICING_ATTR

Line 1490: OE_Debug_PUB.Add('Begin Get_Pricing_Attr in QPXFPRAB');

1486: )
1487: RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
1488: IS
1489: BEGIN
1490: OE_Debug_PUB.Add('Begin Get_Pricing_Attr in QPXFPRAB');
1491:
1492: IF p_pricing_attribute_id <> g_PRICING_ATTR_rec.pricing_attribute_id
1493: THEN
1494:

Line 1511: OE_Debug_PUB.Add('ENd Get_Pricing_Attr in QPXFPRAB');

1507: END IF;
1508:
1509: IF p_db_record THEN
1510:
1511: OE_Debug_PUB.Add('ENd Get_Pricing_Attr in QPXFPRAB');
1512: RETURN g_db_PRICING_ATTR_rec;
1513:
1514: ELSE
1515:

Line 1516: OE_Debug_PUB.Add('else ENd Get_Pricing_Attr in QPXFPRAB');

1512: RETURN g_db_PRICING_ATTR_rec;
1513:
1514: ELSE
1515:
1516: OE_Debug_PUB.Add('else ENd Get_Pricing_Attr in QPXFPRAB');
1517: RETURN g_PRICING_ATTR_rec;
1518:
1519: END IF;
1520: EXCEPTION WHEN OTHERS THEN

Line 1529: oe_debug_pub.add('BEGIN Clear_Pricing_Attr in QPXFPRAB');

1525: PROCEDURE Clear_Pricing_Attr
1526: IS
1527: BEGIN
1528:
1529: oe_debug_pub.add('BEGIN Clear_Pricing_Attr in QPXFPRAB');
1530: g_PRICING_ATTR_rec := QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC;
1531: g_db_PRICING_ATTR_rec := QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC;
1532:
1533: oe_debug_pub.add('END Clear_Pricing_Attr in QPXFPRAB');

Line 1533: oe_debug_pub.add('END Clear_Pricing_Attr in QPXFPRAB');

1529: oe_debug_pub.add('BEGIN Clear_Pricing_Attr in QPXFPRAB');
1530: g_PRICING_ATTR_rec := QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC;
1531: g_db_PRICING_ATTR_rec := QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC;
1532:
1533: oe_debug_pub.add('END Clear_Pricing_Attr in QPXFPRAB');
1534: END Clear_Pricing_Attr;
1535:
1536: --for canonical datafix in tst115
1537: FUNCTION Get_DATATYPE

Line 2450: oe_debug_pub.add('invalid attr');

2446:
2447: --added to show invalid values brought in by upgrade.
2448: IF NOT VALID_ATTRIBUTE THEN
2449: --fnd_message.debug('invalid attr');
2450: oe_debug_pub.add('invalid attr');
2451: x_attribute_code := p_attribute;
2452: --Not applicable for database package; will handle in the UI
2453: set_item_instance_property(
2454: p_attribute_col_name