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_VALIDATE_PRICING_ATTR dependencies on OE_DEBUG_PUB

Line 72: oe_debug_pub.add('BEGIN Entity in QPXLPRAB');

68: l_fna_valid BOOLEAN;
69:
70: BEGIN
71:
72: oe_debug_pub.add('BEGIN Entity in QPXLPRAB');
73:
74: -- Check whether Source System Code matches
75: -- mkarya for bug 1728764, Prevent update of Trade Management Data in QP
76: --dbms_output.put_line('Manoj - QPXLPRAB - list_header_id = ' || p_PRICING_ATTR_rec.list_header_id);

Line 211: oe_debug_pub.add('excluder flag = '||p_PRICING_ATTR_rec.excluder_flag);

207: END IF;
208:
209: /* Bug2069685 End */
210:
211: oe_debug_pub.add('excluder flag = '||p_PRICING_ATTR_rec.excluder_flag);
212:
213: IF list_line.list_line_type_code <> 'PMR' THEN
214: IF p_PRICING_ATTR_rec.excluder_flag IS NULL
215: THEN

Line 217: oe_debug_pub.add('excluder flag null');

213: IF list_line.list_line_type_code <> 'PMR' THEN
214: IF p_PRICING_ATTR_rec.excluder_flag IS NULL
215: THEN
216:
217: oe_debug_pub.add('excluder flag null');
218: l_return_status := FND_API.G_RET_STS_ERROR;
219:
220: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
221: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('EXCLUDER_FLAG')); -- Fix For Bug-1974413

Line 228: oe_debug_pub.add('excluder flag invalid');

224: ELSIF ( p_PRICING_ATTR_rec.excluder_flag <> 'Y' AND
225: p_PRICING_ATTR_rec.excluder_flag <> 'N' )
226: THEN
227:
228: oe_debug_pub.add('excluder flag invalid');
229: l_return_status := FND_API.G_RET_STS_ERROR;
230:
231: FND_MESSAGE.SET_NAME('QP','QP_EXCLD_FLAG_Y_OR_N');
232: OE_MSG_PUB.Add;

Line 237: oe_debug_pub.add(p_PRICING_ATTR_rec.Comparison_operator_code);

233:
234: END IF;
235: END IF; --list_line_type_code not 'PMR'
236:
237: oe_debug_pub.add(p_PRICING_ATTR_rec.Comparison_operator_code);
238:
239: IF list_line.list_line_type_code <> 'PBH'
240: THEN
241:

Line 564: OE_Debug_Pub.add ( ' Value Set 1' || l_start_date_active || l_end_date_active );

560: into l_start_date_active, l_end_date_active, l_list_header_id
561: from qp_list_lines
562: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
563:
564: OE_Debug_Pub.add ( ' Value Set 1' || l_start_date_active || l_end_date_active );
565:
566: oe_debug_pub.add('about to delete a request to check duplicate modifier list lines without product attribute');
567: QP_delayed_requests_pvt.Delete_Request
568: ( p_entity_code => QP_GLOBALS.G_ENTITY_ALL

Line 566: oe_debug_pub.add('about to delete a request to check duplicate modifier list lines without product attribute');

562: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
563:
564: OE_Debug_Pub.add ( ' Value Set 1' || l_start_date_active || l_end_date_active );
565:
566: oe_debug_pub.add('about to delete a request to check duplicate modifier list lines without product attribute');
567: QP_delayed_requests_pvt.Delete_Request
568: ( p_entity_code => QP_GLOBALS.G_ENTITY_ALL
569: , p_entity_id => p_PRICING_ATTR_rec.list_line_id
570: , p_request_Type => QP_GLOBALS.G_DUPLICATE_MODIFIER_LINES

Line 576: oe_debug_pub.add('failed in deleting a delayed request for duplicate Modifier');

572: );
573:
574: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
575:
576: oe_debug_pub.add('failed in deleting a delayed request for duplicate Modifier');
577:
578: RAISE FND_API.G_EXC_ERROR;
579:
580: END IF;

Line 583: oe_debug_pub.add('about to log a request to check duplicate modifier list lines with product attribute');

579:
580: END IF;
581: /* After deleting the first one for modifier lines without pricing attributes, log a new request
582: to check duplicate modifier list lines with product attribute */
583: oe_debug_pub.add('about to log a request to check duplicate modifier list lines with product attribute');
584: QP_DELAYED_REQUESTS_PVT.Log_Request
585: ( p_entity_code => QP_GLOBALS.G_ENTITY_ALL
586: , p_entity_id => p_PRICING_ATTR_rec.list_line_id
587: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL

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

597: );
598:
599: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
600:
601: oe_debug_pub.add('failed in logging a delayed request ');
602:
603: RAISE FND_API.G_EXC_ERROR;
604:
605: END IF;

Line 607: oe_debug_pub.add('after logging delayed request for duplicate modifiers');

603: RAISE FND_API.G_EXC_ERROR;
604:
605: END IF;
606:
607: oe_debug_pub.add('after logging delayed request for duplicate modifiers');
608:
609: END IF;
610:
611: --- end 2091362

Line 678: oe_debug_pub.add('error code = '|| to_char(l_error_code));

674: ,precedence =>l_precedence
675: ,error_code =>l_error_code
676: );
677:
678: oe_debug_pub.add('error code = '|| to_char(l_error_code));
679: If (l_context_flag = 'N' AND l_error_code = 7) -- invalid context
680: Then
681: l_return_status := FND_API.G_RET_STS_ERROR;
682:

Line 761: oe_debug_pub.add('end attribute ');

757:
758: END;
759: END IF;
760:
761: oe_debug_pub.add('end attribute ');
762:
763: --fix for bug 5507953
764: l_return_status := QP_UTIL.Validate_Item(p_PRICING_ATTR_rec.product_attribute_context,
765: p_PRICING_ATTR_rec.product_attribute,

Line 774: oe_debug_pub.add('IIIITTTTEEEEMMMM');

770:
771: IF p_PRICING_ATTR_rec.product_attribute_context = 'ITEM' -- Item Number
772: AND p_PRICING_ATTR_rec.product_attribute = 'PRICING_ATTRIBUTE1'
773: THEN
774: oe_debug_pub.add('IIIITTTTEEEEMMMM');
775: l_organization_id := QP_UTIL.Get_Item_Validation_Org;
776:
777: BEGIN
778:

Line 802: oe_debug_pub.add('CCCCAAAATTTT');

798: IF p_PRICING_ATTR_rec.product_attribute_context = 'ITEM' -- Item Category
799: AND p_PRICING_ATTR_rec.product_attribute = 'PRICING_ATTRIBUTE2'
800: THEN
801:
802: oe_debug_pub.add('CCCCAAAATTTT');
803:
804: -- the validation code that was here has been abstracted out to
805: -- package QP_CATEGORY_MAPPING_RULE for 11i10 Product Catalog
806:

Line 828: oe_debug_pub.add('AAAAAAALLLLLLL');

824: IF p_PRICING_ATTR_rec.product_attribute_context = 'ITEM' -- All Items
825: AND p_PRICING_ATTR_rec.product_attribute = 'PRICING_ATTRIBUTE3'
826: THEN
827:
828: oe_debug_pub.add('AAAAAAALLLLLLL');
829: BEGIN
830:
831: select distinct uom_code
832: into l_dummy_2

Line 971: oe_debug_pub.add('prod line id '|| to_char(p_PRICING_ATTR_rec.list_line_id));

967: END;
968:
969: END IF;
970:
971: oe_debug_pub.add('prod line id '|| to_char(p_PRICING_ATTR_rec.list_line_id));
972: oe_debug_pub.add('line id '|| to_char(list_line.list_line_id));
973: oe_debug_pub.add('list line type '|| list_line.list_line_type_code);
974: oe_debug_pub.add('prece '|| to_char(list_line.product_precedence));
975:

Line 972: oe_debug_pub.add('line id '|| to_char(list_line.list_line_id));

968:
969: END IF;
970:
971: oe_debug_pub.add('prod line id '|| to_char(p_PRICING_ATTR_rec.list_line_id));
972: oe_debug_pub.add('line id '|| to_char(list_line.list_line_id));
973: oe_debug_pub.add('list line type '|| list_line.list_line_type_code);
974: oe_debug_pub.add('prece '|| to_char(list_line.product_precedence));
975:
976:

Line 973: oe_debug_pub.add('list line type '|| list_line.list_line_type_code);

969: END IF;
970:
971: oe_debug_pub.add('prod line id '|| to_char(p_PRICING_ATTR_rec.list_line_id));
972: oe_debug_pub.add('line id '|| to_char(list_line.list_line_id));
973: oe_debug_pub.add('list line type '|| list_line.list_line_type_code);
974: oe_debug_pub.add('prece '|| to_char(list_line.product_precedence));
975:
976:
977: IF (((list_line.list_line_type_code = 'DIS'

Line 974: oe_debug_pub.add('prece '|| to_char(list_line.product_precedence));

970:
971: oe_debug_pub.add('prod line id '|| to_char(p_PRICING_ATTR_rec.list_line_id));
972: oe_debug_pub.add('line id '|| to_char(list_line.list_line_id));
973: oe_debug_pub.add('list line type '|| list_line.list_line_type_code);
974: oe_debug_pub.add('prece '|| to_char(list_line.product_precedence));
975:
976:
977: IF (((list_line.list_line_type_code = 'DIS'
978: OR list_line.list_line_type_code = 'SUR'

Line 986: oe_debug_pub.add('prece 22 ');

982: OR (list_line.list_line_type_code = 'TSN'))
983: AND list_line.product_precedence IS NULL
984: THEN
985:
986: oe_debug_pub.add('prece 22 ');
987: --changes by spgopal for bug 1466254
988: --precedence is mandatory for pricing attribute records to exclude product
989: if p_PRICING_ATTR_rec.excluder_flag = 'N' then
990: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1027: oe_debug_pub.add('pric context = '||p_PRICING_ATTR_rec.pricing_attribute_context);

1023: OE_MSG_PUB.Add;
1024:
1025: END IF; */
1026:
1027: oe_debug_pub.add('pric context = '||p_PRICING_ATTR_rec.pricing_attribute_context);
1028: oe_debug_pub.add('comp oper = '|| p_PRICING_ATTR_rec.comparison_operator_code);
1029: oe_debug_pub.add('list type = '|| list_line.list_line_type_code);
1030:
1031: IF list_line.list_line_type_code <> 'PMR' THEN

Line 1028: oe_debug_pub.add('comp oper = '|| p_PRICING_ATTR_rec.comparison_operator_code);

1024:
1025: END IF; */
1026:
1027: oe_debug_pub.add('pric context = '||p_PRICING_ATTR_rec.pricing_attribute_context);
1028: oe_debug_pub.add('comp oper = '|| p_PRICING_ATTR_rec.comparison_operator_code);
1029: oe_debug_pub.add('list type = '|| list_line.list_line_type_code);
1030:
1031: IF list_line.list_line_type_code <> 'PMR' THEN
1032: IF p_PRICING_ATTR_rec.pricing_attribute_context = 'VOLUME'

Line 1029: oe_debug_pub.add('list type = '|| list_line.list_line_type_code);

1025: END IF; */
1026:
1027: oe_debug_pub.add('pric context = '||p_PRICING_ATTR_rec.pricing_attribute_context);
1028: oe_debug_pub.add('comp oper = '|| p_PRICING_ATTR_rec.comparison_operator_code);
1029: oe_debug_pub.add('list type = '|| list_line.list_line_type_code);
1030:
1031: IF list_line.list_line_type_code <> 'PMR' THEN
1032: IF p_PRICING_ATTR_rec.pricing_attribute_context = 'VOLUME'
1033: AND (p_PRICING_ATTR_rec.comparison_operator_code <> 'BETWEEN'

Line 1037: oe_debug_pub.add('I am herrrrr');

1033: AND (p_PRICING_ATTR_rec.comparison_operator_code <> 'BETWEEN'
1034: OR p_PRICING_ATTR_rec.comparison_operator_code IS NULL )
1035: THEN
1036:
1037: oe_debug_pub.add('I am herrrrr');
1038: l_return_status := FND_API.G_RET_STS_ERROR;
1039:
1040: FND_MESSAGE.SET_NAME('QP','QP_BETW_MAND_FOR_VOLUME');
1041: OE_MSG_PUB.Add;

Line 1071: oe_debug_pub.add('prece 33 ');

1067: OR list_line.list_line_type_code = 'PRG')
1068: AND list_line.product_precedence IS NULL
1069: THEN
1070:
1071: oe_debug_pub.add('prece 33 ');
1072: l_return_status := FND_API.G_RET_STS_ERROR;
1073:
1074: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1075: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Precedence');

Line 1111: oe_debug_pub.add('end uom ');

1107: OE_MSG_PUB.Add;
1108:
1109: END IF;
1110:
1111: oe_debug_pub.add('end uom ');
1112: END IF; --If list_line_type_code <> 'PMR'
1113:
1114: IF p_PRICING_ATTR_rec.pricing_attribute_context IS NOT NULL
1115: THEN

Line 1221: oe_debug_pub.add('pricing attr value from = '|| p_PRICING_ATTR_rec.pricing_attr_value_from);

1217: OE_MSG_PUB.Add;
1218: END IF;
1219:
1220: End If;
1221: oe_debug_pub.add('pricing attr value from = '|| p_PRICING_ATTR_rec.pricing_attr_value_from);
1222: oe_debug_pub.add('from datatype = '||l_datatype);
1223: oe_debug_pub.add('from error = '||to_char(l_error_code));
1224:
1225: END IF;

Line 1222: oe_debug_pub.add('from datatype = '||l_datatype);

1218: END IF;
1219:
1220: End If;
1221: oe_debug_pub.add('pricing attr value from = '|| p_PRICING_ATTR_rec.pricing_attr_value_from);
1222: oe_debug_pub.add('from datatype = '||l_datatype);
1223: oe_debug_pub.add('from error = '||to_char(l_error_code));
1224:
1225: END IF;
1226:

Line 1223: oe_debug_pub.add('from error = '||to_char(l_error_code));

1219:
1220: End If;
1221: oe_debug_pub.add('pricing attr value from = '|| p_PRICING_ATTR_rec.pricing_attr_value_from);
1222: oe_debug_pub.add('from datatype = '||l_datatype);
1223: oe_debug_pub.add('from error = '||to_char(l_error_code));
1224:
1225: END IF;
1226:
1227: /* Value To cannot be given with Recurring break type */

Line 1248: oe_debug_pub.add('pricing attr value to = '|| p_PRICING_ATTR_rec.pricing_attr_value_to);

1244: IF p_PRICING_ATTR_rec.pricing_attr_value_to IS NOT NULL
1245: AND p_PRICING_ATTR_rec.comparison_operator_code = 'BETWEEN'
1246: THEN
1247:
1248: oe_debug_pub.add('pricing attr value to = '|| p_PRICING_ATTR_rec.pricing_attr_value_to);
1249: oe_debug_pub.add('pricing attr datatype = '|| p_PRICING_ATTR_rec.pricing_attribute_datatype);
1250:
1251: l_error_code := QP_UTIL.validate_num_date(p_PRICING_ATTR_rec.pricing_attribute_datatype,
1252: p_PRICING_ATTR_rec.pricing_attr_value_to);

Line 1249: oe_debug_pub.add('pricing attr datatype = '|| p_PRICING_ATTR_rec.pricing_attribute_datatype);

1245: AND p_PRICING_ATTR_rec.comparison_operator_code = 'BETWEEN'
1246: THEN
1247:
1248: oe_debug_pub.add('pricing attr value to = '|| p_PRICING_ATTR_rec.pricing_attr_value_to);
1249: oe_debug_pub.add('pricing attr datatype = '|| p_PRICING_ATTR_rec.pricing_attribute_datatype);
1250:
1251: l_error_code := QP_UTIL.validate_num_date(p_PRICING_ATTR_rec.pricing_attribute_datatype,
1252: p_PRICING_ATTR_rec.pricing_attr_value_to);
1253:

Line 1254: oe_debug_pub.add('to error = '||to_char(l_error_code));

1250:
1251: l_error_code := QP_UTIL.validate_num_date(p_PRICING_ATTR_rec.pricing_attribute_datatype,
1252: p_PRICING_ATTR_rec.pricing_attr_value_to);
1253:
1254: oe_debug_pub.add('to error = '||to_char(l_error_code));
1255: If (l_error_code = 9) -- invalid value
1256: Then
1257: l_return_status := FND_API.G_RET_STS_ERROR;
1258:

Line 1332: oe_debug_pub.add('Here 0000');

1328: --has a sourcing method of 'ATTRIBUTE MAPPING' but is not sourcing-enabled
1329: --or if its sourcing_status is not 'Y', i.e., the build sourcing conc.
1330: --program has to be run.
1331:
1332: oe_debug_pub.add('Here 0000');
1333: IF qp_util.attrmgr_installed = 'Y' THEN
1334: oe_debug_pub.add('Here 1111');
1335: IF p_Pricing_Attr_rec.product_attribute_context IS NOT NULL AND
1336: p_Pricing_Attr_rec.product_attribute IS NOT NULL

Line 1334: oe_debug_pub.add('Here 1111');

1330: --program has to be run.
1331:
1332: oe_debug_pub.add('Here 0000');
1333: IF qp_util.attrmgr_installed = 'Y' THEN
1334: oe_debug_pub.add('Here 1111');
1335: IF p_Pricing_Attr_rec.product_attribute_context IS NOT NULL AND
1336: p_Pricing_Attr_rec.product_attribute IS NOT NULL
1337: THEN
1338: oe_debug_pub.add('Here 2222');

Line 1338: oe_debug_pub.add('Here 2222');

1334: oe_debug_pub.add('Here 1111');
1335: IF p_Pricing_Attr_rec.product_attribute_context IS NOT NULL AND
1336: p_Pricing_Attr_rec.product_attribute IS NOT NULL
1337: THEN
1338: oe_debug_pub.add('Here 2222');
1339: QP_UTIL.Get_Context_Type('QP_ATTR_DEFNS_PRICING',
1340: p_Pricing_Attr_rec.product_attribute_context,
1341: l_context_type,
1342: l_error_code);

Line 1346: oe_debug_pub.add('Here 3333');

1342: l_error_code);
1343:
1344: IF l_error_code = 0 THEN --successfully returned context_type
1345:
1346: oe_debug_pub.add('Here 3333');
1347: QP_UTIL.Get_Sourcing_Info(l_context_type,
1348: p_Pricing_Attr_rec.product_attribute_context,
1349: p_Pricing_Attr_rec.product_attribute,
1350: l_sourcing_enabled,

Line 1356: oe_debug_pub.add('Here 4444');

1352: l_sourcing_method);
1353:
1354: IF l_sourcing_method = 'ATTRIBUTE MAPPING' THEN
1355:
1356: oe_debug_pub.add('Here 4444');
1357: IF l_sourcing_enabled <> 'Y' THEN
1358:
1359: oe_debug_pub.add('Here 5555');
1360: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');

Line 1359: oe_debug_pub.add('Here 5555');

1355:
1356: oe_debug_pub.add('Here 4444');
1357: IF l_sourcing_enabled <> 'Y' THEN
1358:
1359: oe_debug_pub.add('Here 5555');
1360: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
1361: FND_MESSAGE.SET_TOKEN('CONTEXT',
1362: p_Pricing_Attr_rec.product_attribute_context);
1363: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

Line 1371: oe_debug_pub.add('Here 6666');

1367: END IF;
1368:
1369: IF l_sourcing_status <> 'Y' THEN
1370:
1371: oe_debug_pub.add('Here 6666');
1372: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
1373: FND_MESSAGE.SET_TOKEN('CONTEXT',
1374: p_Pricing_Attr_rec.product_attribute_context);
1375: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

Line 1440: oe_debug_pub.add('END Entity in QPXLPRAB');

1436: -- Done validating entity
1437:
1438: x_return_status := l_return_status;
1439:
1440: oe_debug_pub.add('END Entity in QPXLPRAB');
1441:
1442: EXCEPTION
1443:
1444: WHEN FND_API.G_EXC_ERROR THEN

Line 1447: oe_debug_pub.add('EXP error');

1443:
1444: WHEN FND_API.G_EXC_ERROR THEN
1445:
1446: x_return_status := FND_API.G_RET_STS_ERROR;
1447: oe_debug_pub.add('EXP error');
1448:
1449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1450:
1451: oe_debug_pub.add('EXP unexpect error');

Line 1451: oe_debug_pub.add('EXP unexpect error');

1447: oe_debug_pub.add('EXP error');
1448:
1449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1450:
1451: oe_debug_pub.add('EXP unexpect error');
1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1453:
1454: WHEN OTHERS THEN
1455:

Line 1456: oe_debug_pub.add('EXP others');

1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1453:
1454: WHEN OTHERS THEN
1455:
1456: oe_debug_pub.add('EXP others');
1457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1458:
1459: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1460: THEN

Line 1480: oe_debug_pub.add('BEGIN Attributes in QPXLPRAB');

1476: )
1477: IS
1478: BEGIN
1479:
1480: oe_debug_pub.add('BEGIN Attributes in QPXLPRAB');
1481:
1482: x_return_status := FND_API.G_RET_STS_SUCCESS;
1483:
1484: -- Validate PRICING_ATTR attributes

Line 1881: oe_debug_pub.add('END Attributes in QPXLPRAB');

1877: END IF;
1878:
1879: -- Done validating attributes
1880:
1881: oe_debug_pub.add('END Attributes in QPXLPRAB');
1882:
1883: EXCEPTION
1884:
1885: WHEN FND_API.G_EXC_ERROR THEN

Line 1917: oe_debug_pub.add('BEGIN Entity_Delete in QPXLPRAB');

1913: IS
1914: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1915: BEGIN
1916:
1917: oe_debug_pub.add('BEGIN Entity_Delete in QPXLPRAB');
1918:
1919: -- Validate entity delete.
1920:
1921: NULL;

Line 1934: oe_debug_pub.add('END Entity_Delete in QPXLPRAB');

1930: -- Done.
1931:
1932: x_return_status := l_return_status;
1933:
1934: oe_debug_pub.add('END Entity_Delete in QPXLPRAB');
1935:
1936: EXCEPTION
1937:
1938: WHEN FND_API.G_EXC_ERROR THEN

Line 2042: oe_debug_pub.add('No attribute');

2038: BEGIN
2039:
2040:
2041: if p_product_attribute_context is null then
2042: oe_debug_pub.add('No attribute');
2043: for rec in get_rec_no_attr(p_List_Line_ID)
2044: loop
2045: oe_debug_pub.add('No attribute in for loop');
2046: oe_debug_pub.add('col2 list_line_id' || rec.col2 );

Line 2045: oe_debug_pub.add('No attribute in for loop');

2041: if p_product_attribute_context is null then
2042: oe_debug_pub.add('No attribute');
2043: for rec in get_rec_no_attr(p_List_Line_ID)
2044: loop
2045: oe_debug_pub.add('No attribute in for loop');
2046: oe_debug_pub.add('col2 list_line_id' || rec.col2 );
2047: l_min_date := to_date('01/01/1900', 'MM/DD/YYYY');
2048: l_max_date := to_date('12/31/9999', 'MM/DD/YYYY');
2049:

Line 2046: oe_debug_pub.add('col2 list_line_id' || rec.col2 );

2042: oe_debug_pub.add('No attribute');
2043: for rec in get_rec_no_attr(p_List_Line_ID)
2044: loop
2045: oe_debug_pub.add('No attribute in for loop');
2046: oe_debug_pub.add('col2 list_line_id' || rec.col2 );
2047: l_min_date := to_date('01/01/1900', 'MM/DD/YYYY');
2048: l_max_date := to_date('12/31/9999', 'MM/DD/YYYY');
2049:
2050: CT_DUPLI_QUAL := 1;

Line 2084: oe_debug_pub.add('The count of duplicate qualifiers is '||CT_DUPLI_QUAL);

2080: and nvl(q1.qualifier_attr_value,' ') = nvl(q2.qualifier_attr_value,' ')
2081: and nvl(q1.qualifier_attr_value_to,' ') = nvl(q2.qualifier_attr_value_to,' ')
2082: and nvl(q1.comparison_operator_code,' ') = nvl(q2.comparison_operator_code,' ');
2083:
2084: oe_debug_pub.add('The count of duplicate qualifiers is '||CT_DUPLI_QUAL);
2085:
2086: if (CT_DUPLI_QUAL = 0) then -- the qualifiers are not same.
2087:
2088: oe_debug_pub.add('Count equal to zero');

Line 2088: oe_debug_pub.add('Count equal to zero');

2084: oe_debug_pub.add('The count of duplicate qualifiers is '||CT_DUPLI_QUAL);
2085:
2086: if (CT_DUPLI_QUAL = 0) then -- the qualifiers are not same.
2087:
2088: oe_debug_pub.add('Count equal to zero');
2089: DUPLI_QUAL := FALSE;
2090: exit;
2091: end if;
2092: DUPLI_QUAL := TRUE;

Line 2142: oe_debug_pub.add('Found a Modifier line duplicate...' );

2138: nvl(p_End_Date_Active,l_max_date) )
2139:
2140: THEN
2141:
2142: oe_debug_pub.add('Found a Modifier line duplicate...' );
2143: p_x_effdates := FALSE;
2144: RETURN FALSE;
2145:
2146:

Line 2153: oe_debug_pub.add('Attribute present');

2149: end if; --- Qual dupli check
2150: end loop;
2151:
2152: Else
2153: oe_debug_pub.add('Attribute present');
2154: for rec in get_rec(p_List_Line_ID)
2155: loop
2156:
2157: l_min_date := to_date('01/01/1900', 'MM/DD/YYYY');

Line 2193: oe_debug_pub.add('The count of duplicate qualifiers is '||CT_DUPLI_QUAL);

2189: and nvl(q1.qualifier_attr_value,' ') = nvl(q2.qualifier_attr_value,' ')
2190: and nvl(q1.qualifier_attr_value_to,' ') = nvl(q2.qualifier_attr_value_to,' ')
2191: and nvl(q1.comparison_operator_code,' ') = nvl(q2.comparison_operator_code,' ');
2192:
2193: oe_debug_pub.add('The count of duplicate qualifiers is '||CT_DUPLI_QUAL);
2194:
2195: if (CT_DUPLI_QUAL = 0) then -- the qualifiers are not same.
2196:
2197: oe_debug_pub.add('Count equal to zero');

Line 2197: oe_debug_pub.add('Count equal to zero');

2193: oe_debug_pub.add('The count of duplicate qualifiers is '||CT_DUPLI_QUAL);
2194:
2195: if (CT_DUPLI_QUAL = 0) then -- the qualifiers are not same.
2196:
2197: oe_debug_pub.add('Count equal to zero');
2198: DUPLI_QUAL := FALSE;
2199: exit;
2200: end if;
2201: DUPLI_QUAL := TRUE;

Line 2252: oe_debug_pub.add('Found a Modifier line p attr duplicate...' );

2248: nvl(p_End_Date_Active,l_max_date) )
2249:
2250: THEN
2251:
2252: oe_debug_pub.add('Found a Modifier line p attr duplicate...' );
2253: p_x_effdates := FALSE;
2254: RETURN FALSE;
2255:
2256: