DBA Data[Home] [Help]

APPS.QP_QP_FORM_MODIFIERS dependencies on OE_DEBUG_PUB

Line 161: oe_debug_pub.add('BEGIN Default_Attributes in QPXFMLLB');

157: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
158: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
159: BEGIN
160:
161: oe_debug_pub.add('BEGIN Default_Attributes in QPXFMLLB');
162:
163: -- Set control flags.
164:
165: l_control_rec.controlled_operation := TRUE;

Line 372: oe_debug_pub.add('END Default_Attributes in QPXFMLLB');

368: ( p_count => x_msg_count
369: , p_data => x_msg_data
370: );
371:
372: oe_debug_pub.add('END Default_Attributes in QPXFMLLB');
373:
374: EXCEPTION
375:
376: WHEN FND_API.G_EXC_ERROR THEN

Line 569: oe_debug_pub.add('BEGIN Change_attribute in QPXFMLLB');

565: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
566: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
567: BEGIN
568:
569: oe_debug_pub.add('BEGIN Change_attribute in QPXFMLLB');
570:
571: -- Set control flags.
572:
573: l_control_rec.controlled_operation := TRUE;

Line 652: OE_Debug_Pub.add(to_char(QP_Modifiers_Util.G_PRINT_ON_INVOICE)||to_char(p_attr_id));

648: l_MODIFIERS_rec.price_by_formula_id := TO_NUMBER(p_attr_value);
649: ELSIF p_attr_id = QP_Modifiers_Util.G_PRIMARY_UOM THEN
650: l_MODIFIERS_rec.primary_uom_flag := p_attr_value;
651: ELSIF p_attr_id = QP_Modifiers_Util.G_PRINT_ON_INVOICE THEN
652: OE_Debug_Pub.add(to_char(QP_Modifiers_Util.G_PRINT_ON_INVOICE)||to_char(p_attr_id));
653: l_MODIFIERS_rec.print_on_invoice_flag := p_attr_value;
654: -- ELSIF p_attr_id = QP_Modifiers_Util.G_REBATE_SUBTYPE THEN
655: -- l_MODIFIERS_rec.rebate_subtype_code := p_attr_value;
656: ELSIF p_attr_id = QP_Modifiers_Util.G_REBATE_TRANSACTION_TYPE THEN

Line 1489: oe_debug_pub.add('END Change_attribute in QPXFMLLB');

1485: ( p_count => x_msg_count
1486: , p_data => x_msg_data
1487: );
1488:
1489: oe_debug_pub.add('END Change_attribute in QPXFMLLB');
1490:
1491: EXCEPTION
1492:
1493: WHEN FND_API.G_EXC_ERROR THEN

Line 1567: oe_debug_pub.add('BEGIN Validate_And_Write in QPXFMLLB');

1563: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1564: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1565: BEGIN
1566:
1567: oe_debug_pub.add('BEGIN Validate_And_Write in QPXFMLLB');
1568:
1569: -- Set control flags.
1570:
1571: l_control_rec.controlled_operation := TRUE;

Line 1663: oe_debug_pub.add('END Validate_And_Write in QPXFMLLB');

1659: ( p_count => x_msg_count
1660: , p_data => x_msg_data
1661: );
1662:
1663: oe_debug_pub.add('END Validate_And_Write in QPXFMLLB');
1664:
1665: EXCEPTION
1666:
1667: WHEN FND_API.G_EXC_ERROR THEN

Line 1734: oe_debug_pub.add('BEGIN Delete_Row in QPXFMLLB');

1730: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1731: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1732: BEGIN
1733:
1734: oe_debug_pub.add('BEGIN Delete_Row in QPXFMLLB');
1735:
1736: -- Set control flags.
1737:
1738:

Line 1805: oe_debug_pub.add('END Delete_Row in QPXFMLLB');

1801: ( p_count => x_msg_count
1802: , p_data => x_msg_data
1803: );
1804:
1805: oe_debug_pub.add('END Delete_Row in QPXFMLLB');
1806:
1807: EXCEPTION
1808:
1809: WHEN FND_API.G_EXC_ERROR THEN

Line 1872: oe_debug_pub.add('BEGIN Process_Entity in QPXFMLLB');

1868: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1869: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1870: BEGIN
1871:
1872: oe_debug_pub.add('BEGIN Process_Entity in QPXFMLLB');
1873:
1874: -- Set control flags.
1875:
1876: l_control_rec.controlled_operation := TRUE;

Line 1923: oe_debug_pub.add('END Process_Entity in QPXFMLLB');

1919: ( p_count => x_msg_count
1920: , p_data => x_msg_data
1921: );
1922:
1923: oe_debug_pub.add('END Process_Entity in QPXFMLLB');
1924:
1925: EXCEPTION
1926:
1927: WHEN FND_API.G_EXC_ERROR THEN

Line 2084: oe_debug_pub.add('BEGIN Lock_Row in QPXFMLLB');

2080: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2081: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2082: BEGIN
2083:
2084: oe_debug_pub.add('BEGIN Lock_Row in QPXFMLLB');
2085:
2086: -- Load MODIFIERS record
2087:
2088: l_MODIFIERS_rec.arithmetic_operator := p_arithmetic_operator;

Line 2227: oe_debug_pub.add('END Lock_Row in QPXFMLLB');

2223: ( p_count => x_msg_count
2224: , p_data => x_msg_data
2225: );
2226:
2227: oe_debug_pub.add('END Lock_Row in QPXFMLLB');
2228:
2229: EXCEPTION
2230:
2231: WHEN OTHERS THEN

Line 2262: oe_debug_pub.add('BEGIN Write_Modifiers in QPXFMLLB');

2258: )
2259: IS
2260: BEGIN
2261:
2262: oe_debug_pub.add('BEGIN Write_Modifiers in QPXFMLLB');
2263:
2264: g_MODIFIERS_rec := p_MODIFIERS_rec;
2265:
2266: IF p_db_record THEN

Line 2272: oe_debug_pub.add('END Write_Modifiers in QPXFMLLB');

2268: g_db_MODIFIERS_rec := p_MODIFIERS_rec;
2269:
2270: END IF;
2271:
2272: oe_debug_pub.add('END Write_Modifiers in QPXFMLLB');
2273:
2274: END Write_Modifiers;
2275:
2276: FUNCTION Get_MODIFIERS

Line 2284: oe_debug_pub.add('BEGIN Get_Modifiers in QPXFMLLB');

2280: RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
2281: IS
2282: BEGIN
2283:
2284: oe_debug_pub.add('BEGIN Get_Modifiers in QPXFMLLB');
2285:
2286: IF p_list_line_id <> g_MODIFIERS_rec.list_line_id
2287: THEN
2288:

Line 2305: oe_debug_pub.add('END Get_Modifiers in QPXFMLLB');

2301: END IF;
2302:
2303: IF p_db_record THEN
2304:
2305: oe_debug_pub.add('END Get_Modifiers in QPXFMLLB');
2306: RETURN g_db_MODIFIERS_rec;
2307:
2308: ELSE
2309:

Line 2310: oe_debug_pub.add('else END Get_Modifiers in QPXFMLLB');

2306: RETURN g_db_MODIFIERS_rec;
2307:
2308: ELSE
2309:
2310: oe_debug_pub.add('else END Get_Modifiers in QPXFMLLB');
2311: RETURN g_MODIFIERS_rec;
2312:
2313: END IF;
2314:

Line 2323: oe_debug_pub.add('BEGIN Clear_Modifiers in QPXFMLLB');

2319: PROCEDURE Clear_Modifiers
2320: IS
2321: BEGIN
2322:
2323: oe_debug_pub.add('BEGIN Clear_Modifiers in QPXFMLLB');
2324:
2325: g_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;
2326: g_db_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;
2327:

Line 2328: oe_debug_pub.add('END Clear_Modifiers in QPXFMLLB');

2324:
2325: g_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;
2326: g_db_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;
2327:
2328: oe_debug_pub.add('END Clear_Modifiers in QPXFMLLB');
2329: END Clear_Modifiers;
2330:
2331:
2332: --added by svdeshmu

Line 2673: oe_debug_pub.add('Inside Duplicate Record');

2669:
2670: BEGIN
2671:
2672:
2673: oe_debug_pub.add('Inside Duplicate Record');
2674: oe_debug_pub.add('List Line Type' || p_list_line_type_code,3);
2675: /******************************************************************************************/
2676: /* Duplicate line Pricing Attributes */
2677: /******************************************************************************************/

Line 2674: oe_debug_pub.add('List Line Type' || p_list_line_type_code,3);

2670: BEGIN
2671:
2672:
2673: oe_debug_pub.add('Inside Duplicate Record');
2674: oe_debug_pub.add('List Line Type' || p_list_line_type_code,3);
2675: /******************************************************************************************/
2676: /* Duplicate line Pricing Attributes */
2677: /******************************************************************************************/
2678: FOR l_implicit_rec IN l_PRICING_ATTR_csr(p_old_list_line_id) LOOP

Line 2680: oe_debug_pub.add('Inside pricing attribute cursor of line : '||p_new_list_line_id, 3);

2676: /* Duplicate line Pricing Attributes */
2677: /******************************************************************************************/
2678: FOR l_implicit_rec IN l_PRICING_ATTR_csr(p_old_list_line_id) LOOP
2679:
2680: oe_debug_pub.add('Inside pricing attribute cursor of line : '||p_new_list_line_id, 3);
2681:
2682: SELECT qp_pricing_attributes_s.nextval INTO l_new_pricing_attribute_id
2683: FROM dual;
2684:

Line 2752: oe_debug_pub.add('Inside related modifier cursor for line : '||p_new_list_line_id, 3);

2748: WHERE list_line_id=p_old_list_line_id;
2749:
2750: FOR l_implicit_rec IN l_LIST_LINE_csr(p_old_list_line_id) LOOP
2751:
2752: oe_debug_pub.add('Inside related modifier cursor for line : '||p_new_list_line_id, 3);
2753:
2754: SELECT qp_List_lines_s.nextval INTO l_new_list_line_id
2755: FROM dual;
2756:

Line 2757: oe_debug_pub.add('From Modifier : '||p_new_list_line_id, 3);

2753:
2754: SELECT qp_List_lines_s.nextval INTO l_new_list_line_id
2755: FROM dual;
2756:
2757: oe_debug_pub.add('From Modifier : '||p_new_list_line_id, 3);
2758: oe_debug_pub.add('To Modifier : '||l_new_list_line_id, 3);
2759:
2760: l_MODIFIERS_rec.ACCRUAL_CONVERSION_RATE := l_implicit_rec.ACCRUAL_CONVERSION_RATE;
2761: l_MODIFIERS_rec.ACCRUAL_FLAG := l_implicit_rec.ACCRUAL_FLAG;

Line 2758: oe_debug_pub.add('To Modifier : '||l_new_list_line_id, 3);

2754: SELECT qp_List_lines_s.nextval INTO l_new_list_line_id
2755: FROM dual;
2756:
2757: oe_debug_pub.add('From Modifier : '||p_new_list_line_id, 3);
2758: oe_debug_pub.add('To Modifier : '||l_new_list_line_id, 3);
2759:
2760: l_MODIFIERS_rec.ACCRUAL_CONVERSION_RATE := l_implicit_rec.ACCRUAL_CONVERSION_RATE;
2761: l_MODIFIERS_rec.ACCRUAL_FLAG := l_implicit_rec.ACCRUAL_FLAG;
2762: l_MODIFIERS_rec.ARITHMETIC_OPERATOR := l_implicit_rec.ARITHMETIC_OPERATOR;

Line 2856: oe_debug_pub.add('Inside pricing attribute cursor of related modifier line : '||l_new_list_line_id, 3);

2852: /*************************************************************************************/
2853:
2854: FOR l_implicit_attr_rec IN l_PRICING_ATTR_rltd_csr(l_implicit_rec.list_line_id) LOOP
2855:
2856: oe_debug_pub.add('Inside pricing attribute cursor of related modifier line : '||l_new_list_line_id, 3);
2857:
2858: SELECT qp_pricing_attributes_s.nextval INTO l_new_pricing_attribute_id
2859: FROM dual;
2860:

Line 2920: oe_debug_pub.add('Inside qualifier cursor of line : '||p_new_list_line_id, 3);

2916: /* Qualifiers Duplication */
2917: /******************************************************************************************/
2918: FOR l_implicit_rec IN l_QUALIFIER_csr(p_old_list_line_id) LOOP
2919:
2920: oe_debug_pub.add('Inside qualifier cursor of line : '||p_new_list_line_id, 3);
2921:
2922: SELECT qp_qualifiers_s.nextval INTO l_new_qualifier_id
2923: FROM dual;
2924:

Line 3006: oe_debug_pub.add('Before calling Process Modifier');

3002: /*************************************************************************************/
3003: /* Process the Dulplicated Modifier */
3004: /*************************************************************************************/
3005:
3006: oe_debug_pub.add('Before calling Process Modifier');
3007:
3008: QP_Modifiers_PVT.Process_MODIFIERS
3009: ( p_api_version_number => 1.0
3010: , p_init_msg_list => FND_API.G_TRUE

Line 3053: oe_debug_pub.add('After calling Process Modifier');

3049: );
3050:
3051: END IF;
3052:
3053: oe_debug_pub.add('After calling Process Modifier');
3054: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3056: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3057: RAISE FND_API.G_EXC_ERROR;

Line 3059: oe_debug_pub.add('Outside Duplicate Record');

3055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3056: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3057: RAISE FND_API.G_EXC_ERROR;
3058: END IF;
3059: oe_debug_pub.add('Outside Duplicate Record');
3060: END IF;
3061: EXCEPTION
3062:
3063: WHEN FND_API.G_EXC_ERROR THEN