DBA Data[Home] [Help]

APPS.QP_QP_FORM_MODIFIERS dependencies on OE_DEBUG_PUB

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

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

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

373: ( p_count => x_msg_count
374: , p_data => x_msg_data
375: );
376:
377: oe_debug_pub.add('END Default_Attributes in QPXFMLLB');
378:
379: EXCEPTION
380:
381: WHEN FND_API.G_EXC_ERROR THEN

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

572: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
573: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
574: BEGIN
575:
576: oe_debug_pub.add('BEGIN Change_attribute in QPXFMLLB');
577:
578: -- Set control flags.
579:
580: l_control_rec.controlled_operation := TRUE;

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

655: l_MODIFIERS_rec.price_by_formula_id := TO_NUMBER(p_attr_value);
656: ELSIF p_attr_id = QP_Modifiers_Util.G_PRIMARY_UOM THEN
657: l_MODIFIERS_rec.primary_uom_flag := p_attr_value;
658: ELSIF p_attr_id = QP_Modifiers_Util.G_PRINT_ON_INVOICE THEN
659: OE_Debug_Pub.add(to_char(QP_Modifiers_Util.G_PRINT_ON_INVOICE)||to_char(p_attr_id));
660: l_MODIFIERS_rec.print_on_invoice_flag := p_attr_value;
661: -- ELSIF p_attr_id = QP_Modifiers_Util.G_REBATE_SUBTYPE THEN
662: -- l_MODIFIERS_rec.rebate_subtype_code := p_attr_value;
663: ELSIF p_attr_id = QP_Modifiers_Util.G_REBATE_TRANSACTION_TYPE THEN

Line 745: oe_debug_pub.add('JP Service Project - ' || p_attr_value);

741: ELSIF p_attr_id = QP_Modifiers_Util.G_service_period THEN
742: l_MODIFIERS_rec.service_period := p_attr_value;
743: ELSIF p_attr_id = QP_Modifiers_Util.G_service_duration THEN
744: l_MODIFIERS_rec.service_duration := p_attr_value;
745: oe_debug_pub.add('JP Service Project - ' || p_attr_value);
746: -- service project
747: ELSIF p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE1
748: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE10
749: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE11

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

1516: ( p_count => x_msg_count
1517: , p_data => x_msg_data
1518: );
1519:
1520: oe_debug_pub.add('END Change_attribute in QPXFMLLB');
1521:
1522: EXCEPTION
1523:
1524: WHEN FND_API.G_EXC_ERROR THEN

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

1594: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1595: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1596: BEGIN
1597:
1598: oe_debug_pub.add('BEGIN Validate_And_Write in QPXFMLLB');
1599:
1600: -- Set control flags.
1601:
1602: l_control_rec.controlled_operation := TRUE;

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

1690: ( p_count => x_msg_count
1691: , p_data => x_msg_data
1692: );
1693:
1694: oe_debug_pub.add('END Validate_And_Write in QPXFMLLB');
1695:
1696: EXCEPTION
1697:
1698: WHEN FND_API.G_EXC_ERROR THEN

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

1761: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1762: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1763: BEGIN
1764:
1765: oe_debug_pub.add('BEGIN Delete_Row in QPXFMLLB');
1766:
1767: -- Set control flags.
1768:
1769:

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

1832: ( p_count => x_msg_count
1833: , p_data => x_msg_data
1834: );
1835:
1836: oe_debug_pub.add('END Delete_Row in QPXFMLLB');
1837:
1838: EXCEPTION
1839:
1840: WHEN FND_API.G_EXC_ERROR THEN

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

1899: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1900: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1901: BEGIN
1902:
1903: oe_debug_pub.add('BEGIN Process_Entity in QPXFMLLB');
1904:
1905: -- Set control flags.
1906:
1907: l_control_rec.controlled_operation := TRUE;

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

1950: ( p_count => x_msg_count
1951: , p_data => x_msg_data
1952: );
1953:
1954: oe_debug_pub.add('END Process_Entity in QPXFMLLB');
1955:
1956: EXCEPTION
1957:
1958: WHEN FND_API.G_EXC_ERROR THEN

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

2113: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2114: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2115: BEGIN
2116:
2117: oe_debug_pub.add('BEGIN Lock_Row in QPXFMLLB');
2118:
2119: -- Load MODIFIERS record
2120:
2121: l_MODIFIERS_rec.arithmetic_operator := p_arithmetic_operator;

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

2258: ( p_count => x_msg_count
2259: , p_data => x_msg_data
2260: );
2261:
2262: oe_debug_pub.add('END Lock_Row in QPXFMLLB');
2263:
2264: EXCEPTION
2265:
2266: WHEN OTHERS THEN

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

2293: )
2294: IS
2295: BEGIN
2296:
2297: oe_debug_pub.add('BEGIN Write_Modifiers in QPXFMLLB');
2298:
2299: g_MODIFIERS_rec := p_MODIFIERS_rec;
2300:
2301: IF p_db_record THEN

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

2303: g_db_MODIFIERS_rec := p_MODIFIERS_rec;
2304:
2305: END IF;
2306:
2307: oe_debug_pub.add('END Write_Modifiers in QPXFMLLB');
2308:
2309: END Write_Modifiers;
2310:
2311: FUNCTION Get_MODIFIERS

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

2315: RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
2316: IS
2317: BEGIN
2318:
2319: oe_debug_pub.add('BEGIN Get_Modifiers in QPXFMLLB');
2320:
2321: IF p_list_line_id <> g_MODIFIERS_rec.list_line_id
2322: THEN
2323:

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

2336: END IF;
2337:
2338: IF p_db_record THEN
2339:
2340: oe_debug_pub.add('END Get_Modifiers in QPXFMLLB');
2341: RETURN g_db_MODIFIERS_rec;
2342:
2343: ELSE
2344:

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

2341: RETURN g_db_MODIFIERS_rec;
2342:
2343: ELSE
2344:
2345: oe_debug_pub.add('else END Get_Modifiers in QPXFMLLB');
2346: RETURN g_MODIFIERS_rec;
2347:
2348: END IF;
2349:

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

2354: PROCEDURE Clear_Modifiers
2355: IS
2356: BEGIN
2357:
2358: oe_debug_pub.add('BEGIN Clear_Modifiers in QPXFMLLB');
2359:
2360: g_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;
2361: g_db_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;
2362:

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

2359:
2360: g_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;
2361: g_db_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;
2362:
2363: oe_debug_pub.add('END Clear_Modifiers in QPXFMLLB');
2364: END Clear_Modifiers;
2365:
2366:
2367: --added by svdeshmu

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

2706:
2707: BEGIN
2708:
2709:
2710: oe_debug_pub.add('Inside Duplicate Record');
2711: oe_debug_pub.add('List Line Type' || p_list_line_type_code,3);
2712: /******************************************************************************************/
2713: /* Duplicate line Pricing Attributes */
2714: /******************************************************************************************/

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

2707: BEGIN
2708:
2709:
2710: oe_debug_pub.add('Inside Duplicate Record');
2711: oe_debug_pub.add('List Line Type' || p_list_line_type_code,3);
2712: /******************************************************************************************/
2713: /* Duplicate line Pricing Attributes */
2714: /******************************************************************************************/
2715: FOR l_implicit_rec IN l_PRICING_ATTR_csr(p_old_list_line_id) LOOP

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

2713: /* Duplicate line Pricing Attributes */
2714: /******************************************************************************************/
2715: FOR l_implicit_rec IN l_PRICING_ATTR_csr(p_old_list_line_id) LOOP
2716:
2717: oe_debug_pub.add('Inside pricing attribute cursor of line : '||p_new_list_line_id, 3);
2718:
2719: SELECT qp_pricing_attributes_s.nextval INTO l_new_pricing_attribute_id
2720: FROM dual;
2721:

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

2785: WHERE list_line_id=p_old_list_line_id;
2786:
2787: FOR l_implicit_rec IN l_LIST_LINE_csr(p_old_list_line_id) LOOP
2788:
2789: oe_debug_pub.add('Inside related modifier cursor for line : '||p_new_list_line_id, 3);
2790:
2791: SELECT qp_List_lines_s.nextval INTO l_new_list_line_id
2792: FROM dual;
2793:

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

2790:
2791: SELECT qp_List_lines_s.nextval INTO l_new_list_line_id
2792: FROM dual;
2793:
2794: oe_debug_pub.add('From Modifier : '||p_new_list_line_id, 3);
2795: oe_debug_pub.add('To Modifier : '||l_new_list_line_id, 3);
2796:
2797: l_MODIFIERS_rec.ACCRUAL_CONVERSION_RATE := l_implicit_rec.ACCRUAL_CONVERSION_RATE;
2798: l_MODIFIERS_rec.ACCRUAL_FLAG := l_implicit_rec.ACCRUAL_FLAG;

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

2791: SELECT qp_List_lines_s.nextval INTO l_new_list_line_id
2792: FROM dual;
2793:
2794: oe_debug_pub.add('From Modifier : '||p_new_list_line_id, 3);
2795: oe_debug_pub.add('To Modifier : '||l_new_list_line_id, 3);
2796:
2797: l_MODIFIERS_rec.ACCRUAL_CONVERSION_RATE := l_implicit_rec.ACCRUAL_CONVERSION_RATE;
2798: l_MODIFIERS_rec.ACCRUAL_FLAG := l_implicit_rec.ACCRUAL_FLAG;
2799: l_MODIFIERS_rec.ARITHMETIC_OPERATOR := l_implicit_rec.ARITHMETIC_OPERATOR;

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

2890: /*************************************************************************************/
2891:
2892: FOR l_implicit_attr_rec IN l_PRICING_ATTR_rltd_csr(l_implicit_rec.list_line_id) LOOP
2893:
2894: oe_debug_pub.add('Inside pricing attribute cursor of related modifier line : '||l_new_list_line_id, 3);
2895:
2896: SELECT qp_pricing_attributes_s.nextval INTO l_new_pricing_attribute_id
2897: FROM dual;
2898:

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

2954: /* Qualifiers Duplication */
2955: /******************************************************************************************/
2956: FOR l_implicit_rec IN l_QUALIFIER_csr(p_old_list_line_id) LOOP
2957:
2958: oe_debug_pub.add('Inside qualifier cursor of line : '||p_new_list_line_id, 3);
2959:
2960: SELECT qp_qualifiers_s.nextval INTO l_new_qualifier_id
2961: FROM dual;
2962:

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

3040: /*************************************************************************************/
3041: /* Process the Dulplicated Modifier */
3042: /*************************************************************************************/
3043:
3044: oe_debug_pub.add('Before calling Process Modifier');
3045:
3046: QP_Modifiers_PVT.Process_MODIFIERS
3047: ( p_api_version_number => 1.0
3048: , p_init_msg_list => FND_API.G_TRUE

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

3087: );
3088:
3089: END IF;
3090:
3091: oe_debug_pub.add('After calling Process Modifier');
3092: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3094: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3095: RAISE FND_API.G_EXC_ERROR;

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

3093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3094: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3095: RAISE FND_API.G_EXC_ERROR;
3096: END IF;
3097: oe_debug_pub.add('Outside Duplicate Record');
3098: END IF;
3099: EXCEPTION
3100:
3101: WHEN FND_API.G_EXC_ERROR THEN