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.OE_OE_FORM_PRICE_LLINE dependencies on OE_DEBUG_PUB

Line 119: oe_debug_pub.add('Entering OE_OE_Form_Price_Lline.Default_Attributes');

115: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
116: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
117: BEGIN
118:
119: oe_debug_pub.add('Entering OE_OE_Form_Price_Lline.Default_Attributes');
120:
121: -- Set control flags.
122:
123: l_control_rec.controlled_operation := TRUE;

Line 169: oe_debug_pub.add('before process_pricing_cont in list lines ');

165: l_Price_LLine_tbl(1) := l_Price_LLine_rec;
166:
167: -- Call OE_Pricing_Cont_PVT.Process_Pricing_Cont
168:
169: oe_debug_pub.add('before process_pricing_cont in list lines ');
170:
171: OE_Pricing_Cont_PVT.Process_Pricing_Cont
172: ( p_api_version_number => 1.0
173: , p_init_msg_list => FND_API.G_TRUE

Line 195: oe_debug_pub.add('after calling process_pricing_cont for lines ');

191: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
192: RAISE FND_API.G_EXC_ERROR;
193: END IF;
194:
195: oe_debug_pub.add('after calling process_pricing_cont for lines ');
196:
197:
198: -- Unload out tbl
199:

Line 257: oe_debug_pub.add('get display values');

253:
254: -- Added By Geresh
255: x_creation_date := l_x_Price_LLine_rec.creation_date;
256:
257: oe_debug_pub.add('get display values');
258:
259: -- Load display out parameters if any
260:
261: l_Price_LLine_val_rec := OE_Price_List_Line_Util.Get_Values

Line 279: oe_debug_pub.add('after display values');

275: -- Set db_flag to False before writing to cache
276:
277: l_x_Price_LLine_rec.db_flag := FND_API.G_FALSE;
278:
279: oe_debug_pub.add('after display values');
280:
281: Write_Price_LLine
282: ( p_Price_LLine_rec => l_x_Price_LLine_rec
283: );

Line 285: oe_debug_pub.add('after writing to cache ');

281: Write_Price_LLine
282: ( p_Price_LLine_rec => l_x_Price_LLine_rec
283: );
284:
285: oe_debug_pub.add('after writing to cache ');
286:
287: -- Set return status.
288:
289: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 298: oe_debug_pub.add('Exiting OE_OE_Form_Price_Lline.Default_Attributes');

294: ( p_count => x_msg_count
295: , p_data => x_msg_data
296: );
297:
298: oe_debug_pub.add('Exiting OE_OE_Form_Price_Lline.Default_Attributes');
299:
300: EXCEPTION
301:
302: WHEN FND_API.G_EXC_ERROR THEN

Line 453: oe_debug_pub.add('Entering OE_OE_Form_Price_Lline.Change_Attribute');

449: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
450: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
451: BEGIN
452:
453: oe_debug_pub.add('Entering OE_OE_Form_Price_Lline.Change_Attribute');
454:
455: -- Set control flags.
456:
457: l_control_rec.controlled_operation := TRUE;

Line 472: oe_debug_pub.add('price list line id to query is : ' || to_char(p_price_list_line_id));

468: l_control_rec.clear_api_requests := FALSE;
469:
470: -- Read Price_LLine from cache
471:
472: oe_debug_pub.add('price list line id to query is : ' || to_char(p_price_list_line_id));
473:
474:
475: l_Price_LLine_rec := Get_Price_LLine
476: ( p_db_record => FALSE

Line 480: oe_debug_pub.add('price list line id after query 1 is : ' || to_char(p_price_list_line_id));

476: ( p_db_record => FALSE
477: , p_price_list_line_id => p_price_list_line_id
478: );
479:
480: oe_debug_pub.add('price list line id after query 1 is : ' || to_char(p_price_list_line_id));
481:
482:
483:
484:

Line 487: oe_debug_pub.add('price list line id before **** is : ');

483:
484:
485: l_old_Price_LLine_rec := l_Price_LLine_rec;
486:
487: oe_debug_pub.add('price list line id before **** is : ');
488: IF p_attr_id = OE_Price_List_Line_Util.G_COMMENTS THEN
489: oe_debug_pub.add('price list line id 1111 is : ');
490: l_Price_LLine_rec.comments := p_attr_value;
491: ELSIF p_attr_id = OE_Price_List_Line_Util.G_CUSTOMER_ITEM THEN

Line 489: oe_debug_pub.add('price list line id 1111 is : ');

485: l_old_Price_LLine_rec := l_Price_LLine_rec;
486:
487: oe_debug_pub.add('price list line id before **** is : ');
488: IF p_attr_id = OE_Price_List_Line_Util.G_COMMENTS THEN
489: oe_debug_pub.add('price list line id 1111 is : ');
490: l_Price_LLine_rec.comments := p_attr_value;
491: ELSIF p_attr_id = OE_Price_List_Line_Util.G_CUSTOMER_ITEM THEN
492: oe_debug_pub.add('price list line id 2222 is : ');
493: l_Price_LLine_rec.customer_item_id := TO_NUMBER(p_attr_value);

Line 492: oe_debug_pub.add('price list line id 2222 is : ');

488: IF p_attr_id = OE_Price_List_Line_Util.G_COMMENTS THEN
489: oe_debug_pub.add('price list line id 1111 is : ');
490: l_Price_LLine_rec.comments := p_attr_value;
491: ELSIF p_attr_id = OE_Price_List_Line_Util.G_CUSTOMER_ITEM THEN
492: oe_debug_pub.add('price list line id 2222 is : ');
493: l_Price_LLine_rec.customer_item_id := TO_NUMBER(p_attr_value);
494: ELSIF p_attr_id = OE_Price_List_Line_Util.G_END_DATE_ACTIVE THEN
495: oe_debug_pub.add('price list line id 3333 is : ');
496: l_Price_LLine_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');

Line 495: oe_debug_pub.add('price list line id 3333 is : ');

491: ELSIF p_attr_id = OE_Price_List_Line_Util.G_CUSTOMER_ITEM THEN
492: oe_debug_pub.add('price list line id 2222 is : ');
493: l_Price_LLine_rec.customer_item_id := TO_NUMBER(p_attr_value);
494: ELSIF p_attr_id = OE_Price_List_Line_Util.G_END_DATE_ACTIVE THEN
495: oe_debug_pub.add('price list line id 3333 is : ');
496: l_Price_LLine_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
497: ELSIF p_attr_id = OE_Price_List_Line_Util.G_INVENTORY_ITEM THEN
498: oe_debug_pub.add('price list line id 4444 is : ');
499: l_Price_LLine_rec.inventory_item_id := TO_NUMBER(p_attr_value);

Line 498: oe_debug_pub.add('price list line id 4444 is : ');

494: ELSIF p_attr_id = OE_Price_List_Line_Util.G_END_DATE_ACTIVE THEN
495: oe_debug_pub.add('price list line id 3333 is : ');
496: l_Price_LLine_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
497: ELSIF p_attr_id = OE_Price_List_Line_Util.G_INVENTORY_ITEM THEN
498: oe_debug_pub.add('price list line id 4444 is : ');
499: l_Price_LLine_rec.inventory_item_id := TO_NUMBER(p_attr_value);
500: ELSIF p_attr_id = OE_Price_List_Line_Util.G_LIST_PRICE THEN
501: oe_debug_pub.add('price list line id 5555 is : ');
502: l_Price_LLine_rec.list_price := TO_NUMBER(p_attr_value);

Line 501: oe_debug_pub.add('price list line id 5555 is : ');

497: ELSIF p_attr_id = OE_Price_List_Line_Util.G_INVENTORY_ITEM THEN
498: oe_debug_pub.add('price list line id 4444 is : ');
499: l_Price_LLine_rec.inventory_item_id := TO_NUMBER(p_attr_value);
500: ELSIF p_attr_id = OE_Price_List_Line_Util.G_LIST_PRICE THEN
501: oe_debug_pub.add('price list line id 5555 is : ');
502: l_Price_LLine_rec.list_price := TO_NUMBER(p_attr_value);
503: ELSIF p_attr_id = OE_Price_List_Line_Util.G_METHOD THEN
504: oe_debug_pub.add('price list line id 6666 is : ');
505: l_Price_LLine_rec.method_code := p_attr_value;

Line 504: oe_debug_pub.add('price list line id 6666 is : ');

500: ELSIF p_attr_id = OE_Price_List_Line_Util.G_LIST_PRICE THEN
501: oe_debug_pub.add('price list line id 5555 is : ');
502: l_Price_LLine_rec.list_price := TO_NUMBER(p_attr_value);
503: ELSIF p_attr_id = OE_Price_List_Line_Util.G_METHOD THEN
504: oe_debug_pub.add('price list line id 6666 is : ');
505: l_Price_LLine_rec.method_code := p_attr_value;
506: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICE_LIST THEN
507: oe_debug_pub.add('price list line id 7777 is : ');
508: l_Price_LLine_rec.price_list_id := TO_NUMBER(p_attr_value);

Line 507: oe_debug_pub.add('price list line id 7777 is : ');

503: ELSIF p_attr_id = OE_Price_List_Line_Util.G_METHOD THEN
504: oe_debug_pub.add('price list line id 6666 is : ');
505: l_Price_LLine_rec.method_code := p_attr_value;
506: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICE_LIST THEN
507: oe_debug_pub.add('price list line id 7777 is : ');
508: l_Price_LLine_rec.price_list_id := TO_NUMBER(p_attr_value);
509: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICE_LIST_LINE THEN
510: oe_debug_pub.add('price list line id 8888 is : ');
511: l_Price_LLine_rec.price_list_line_id := TO_NUMBER(p_attr_value);

Line 510: oe_debug_pub.add('price list line id 8888 is : ');

506: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICE_LIST THEN
507: oe_debug_pub.add('price list line id 7777 is : ');
508: l_Price_LLine_rec.price_list_id := TO_NUMBER(p_attr_value);
509: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICE_LIST_LINE THEN
510: oe_debug_pub.add('price list line id 8888 is : ');
511: l_Price_LLine_rec.price_list_line_id := TO_NUMBER(p_attr_value);
512: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE1 THEN
513: oe_debug_pub.add('price list line id 9999 is : ');
514: l_Price_LLine_rec.pricing_attribute1 := p_attr_value;

Line 513: oe_debug_pub.add('price list line id 9999 is : ');

509: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICE_LIST_LINE THEN
510: oe_debug_pub.add('price list line id 8888 is : ');
511: l_Price_LLine_rec.price_list_line_id := TO_NUMBER(p_attr_value);
512: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE1 THEN
513: oe_debug_pub.add('price list line id 9999 is : ');
514: l_Price_LLine_rec.pricing_attribute1 := p_attr_value;
515: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE10 THEN
516: oe_debug_pub.add('price list line id 1010 is : ');
517: l_Price_LLine_rec.pricing_attribute10 := p_attr_value;

Line 516: oe_debug_pub.add('price list line id 1010 is : ');

512: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE1 THEN
513: oe_debug_pub.add('price list line id 9999 is : ');
514: l_Price_LLine_rec.pricing_attribute1 := p_attr_value;
515: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE10 THEN
516: oe_debug_pub.add('price list line id 1010 is : ');
517: l_Price_LLine_rec.pricing_attribute10 := p_attr_value;
518: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE11 THEN
519: oe_debug_pub.add('price list line id 1212 is : ');
520: l_Price_LLine_rec.pricing_attribute11 := p_attr_value;

Line 519: oe_debug_pub.add('price list line id 1212 is : ');

515: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE10 THEN
516: oe_debug_pub.add('price list line id 1010 is : ');
517: l_Price_LLine_rec.pricing_attribute10 := p_attr_value;
518: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE11 THEN
519: oe_debug_pub.add('price list line id 1212 is : ');
520: l_Price_LLine_rec.pricing_attribute11 := p_attr_value;
521: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE12 THEN
522: oe_debug_pub.add('price list line id 1313 is : ');
523: l_Price_LLine_rec.pricing_attribute12 := p_attr_value;

Line 522: oe_debug_pub.add('price list line id 1313 is : ');

518: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE11 THEN
519: oe_debug_pub.add('price list line id 1212 is : ');
520: l_Price_LLine_rec.pricing_attribute11 := p_attr_value;
521: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE12 THEN
522: oe_debug_pub.add('price list line id 1313 is : ');
523: l_Price_LLine_rec.pricing_attribute12 := p_attr_value;
524: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE13 THEN
525: oe_debug_pub.add('price list line id 1414 is : ');
526: l_Price_LLine_rec.pricing_attribute13 := p_attr_value;

Line 525: oe_debug_pub.add('price list line id 1414 is : ');

521: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE12 THEN
522: oe_debug_pub.add('price list line id 1313 is : ');
523: l_Price_LLine_rec.pricing_attribute12 := p_attr_value;
524: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE13 THEN
525: oe_debug_pub.add('price list line id 1414 is : ');
526: l_Price_LLine_rec.pricing_attribute13 := p_attr_value;
527: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE14 THEN
528: oe_debug_pub.add('price list line id 1515 is : ');
529: l_Price_LLine_rec.pricing_attribute14 := p_attr_value;

Line 528: oe_debug_pub.add('price list line id 1515 is : ');

524: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE13 THEN
525: oe_debug_pub.add('price list line id 1414 is : ');
526: l_Price_LLine_rec.pricing_attribute13 := p_attr_value;
527: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE14 THEN
528: oe_debug_pub.add('price list line id 1515 is : ');
529: l_Price_LLine_rec.pricing_attribute14 := p_attr_value;
530: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE15 THEN
531: oe_debug_pub.add('price list line id 1616 is : ');
532: l_Price_LLine_rec.pricing_attribute15 := p_attr_value;

Line 531: oe_debug_pub.add('price list line id 1616 is : ');

527: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE14 THEN
528: oe_debug_pub.add('price list line id 1515 is : ');
529: l_Price_LLine_rec.pricing_attribute14 := p_attr_value;
530: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE15 THEN
531: oe_debug_pub.add('price list line id 1616 is : ');
532: l_Price_LLine_rec.pricing_attribute15 := p_attr_value;
533: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE2 THEN
534: oe_debug_pub.add('price list line id 1818 is : ');
535: l_Price_LLine_rec.pricing_attribute2 := p_attr_value;

Line 534: oe_debug_pub.add('price list line id 1818 is : ');

530: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE15 THEN
531: oe_debug_pub.add('price list line id 1616 is : ');
532: l_Price_LLine_rec.pricing_attribute15 := p_attr_value;
533: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE2 THEN
534: oe_debug_pub.add('price list line id 1818 is : ');
535: l_Price_LLine_rec.pricing_attribute2 := p_attr_value;
536: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE3 THEN
537: oe_debug_pub.add('price list line id 1919 is : ');
538: l_Price_LLine_rec.pricing_attribute3 := p_attr_value;

Line 537: oe_debug_pub.add('price list line id 1919 is : ');

533: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE2 THEN
534: oe_debug_pub.add('price list line id 1818 is : ');
535: l_Price_LLine_rec.pricing_attribute2 := p_attr_value;
536: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE3 THEN
537: oe_debug_pub.add('price list line id 1919 is : ');
538: l_Price_LLine_rec.pricing_attribute3 := p_attr_value;
539: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE4 THEN
540: oe_debug_pub.add('price list line id 2020 is : ');
541: l_Price_LLine_rec.pricing_attribute4 := p_attr_value;

Line 540: oe_debug_pub.add('price list line id 2020 is : ');

536: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE3 THEN
537: oe_debug_pub.add('price list line id 1919 is : ');
538: l_Price_LLine_rec.pricing_attribute3 := p_attr_value;
539: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE4 THEN
540: oe_debug_pub.add('price list line id 2020 is : ');
541: l_Price_LLine_rec.pricing_attribute4 := p_attr_value;
542: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE5 THEN
543: oe_debug_pub.add('price list line id 2121 is : ');
544: l_Price_LLine_rec.pricing_attribute5 := p_attr_value;

Line 543: oe_debug_pub.add('price list line id 2121 is : ');

539: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE4 THEN
540: oe_debug_pub.add('price list line id 2020 is : ');
541: l_Price_LLine_rec.pricing_attribute4 := p_attr_value;
542: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE5 THEN
543: oe_debug_pub.add('price list line id 2121 is : ');
544: l_Price_LLine_rec.pricing_attribute5 := p_attr_value;
545:
546: ELSIF p_attr_id = OE_Price_List_line_Util.G_CREATION_DATE THEN
547: oe_debug_pub.add('price list line id 2323 is : ');

Line 547: oe_debug_pub.add('price list line id 2323 is : ');

543: oe_debug_pub.add('price list line id 2121 is : ');
544: l_Price_LLine_rec.pricing_attribute5 := p_attr_value;
545:
546: ELSIF p_attr_id = OE_Price_List_line_Util.G_CREATION_DATE THEN
547: oe_debug_pub.add('price list line id 2323 is : ');
548: l_Price_LLine_rec.creation_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
549:
550: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE6 THEN
551: oe_debug_pub.add('price list line id 2424 is : ');

Line 551: oe_debug_pub.add('price list line id 2424 is : ');

547: oe_debug_pub.add('price list line id 2323 is : ');
548: l_Price_LLine_rec.creation_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
549:
550: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE6 THEN
551: oe_debug_pub.add('price list line id 2424 is : ');
552: l_Price_LLine_rec.pricing_attribute6 := p_attr_value;
553: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE7 THEN
554: oe_debug_pub.add('price list line id 2525 is : ');
555: l_Price_LLine_rec.pricing_attribute7 := p_attr_value;

Line 554: oe_debug_pub.add('price list line id 2525 is : ');

550: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE6 THEN
551: oe_debug_pub.add('price list line id 2424 is : ');
552: l_Price_LLine_rec.pricing_attribute6 := p_attr_value;
553: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE7 THEN
554: oe_debug_pub.add('price list line id 2525 is : ');
555: l_Price_LLine_rec.pricing_attribute7 := p_attr_value;
556: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE8 THEN
557: oe_debug_pub.add('price list line id 2626 is : ');
558: l_Price_LLine_rec.pricing_attribute8 := p_attr_value;

Line 557: oe_debug_pub.add('price list line id 2626 is : ');

553: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE7 THEN
554: oe_debug_pub.add('price list line id 2525 is : ');
555: l_Price_LLine_rec.pricing_attribute7 := p_attr_value;
556: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE8 THEN
557: oe_debug_pub.add('price list line id 2626 is : ');
558: l_Price_LLine_rec.pricing_attribute8 := p_attr_value;
559: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE9 THEN
560: oe_debug_pub.add('price list line id 2727 is : ');
561: l_Price_LLine_rec.pricing_attribute9 := p_attr_value;

Line 560: oe_debug_pub.add('price list line id 2727 is : ');

556: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE8 THEN
557: oe_debug_pub.add('price list line id 2626 is : ');
558: l_Price_LLine_rec.pricing_attribute8 := p_attr_value;
559: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE9 THEN
560: oe_debug_pub.add('price list line id 2727 is : ');
561: l_Price_LLine_rec.pricing_attribute9 := p_attr_value;
562: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_CONTEXT THEN
563: oe_debug_pub.add('price list line id 2828 is : ');
564: l_Price_LLine_rec.pricing_context := p_attr_value;

Line 563: oe_debug_pub.add('price list line id 2828 is : ');

559: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE9 THEN
560: oe_debug_pub.add('price list line id 2727 is : ');
561: l_Price_LLine_rec.pricing_attribute9 := p_attr_value;
562: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_CONTEXT THEN
563: oe_debug_pub.add('price list line id 2828 is : ');
564: l_Price_LLine_rec.pricing_context := p_attr_value;
565: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_RULE THEN
566: oe_debug_pub.add('price list line id 2929 is : ');
567: l_Price_LLine_rec.pricing_rule_id := TO_NUMBER(p_attr_value);

Line 566: oe_debug_pub.add('price list line id 2929 is : ');

562: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_CONTEXT THEN
563: oe_debug_pub.add('price list line id 2828 is : ');
564: l_Price_LLine_rec.pricing_context := p_attr_value;
565: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_RULE THEN
566: oe_debug_pub.add('price list line id 2929 is : ');
567: l_Price_LLine_rec.pricing_rule_id := TO_NUMBER(p_attr_value);
568: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REPRICE THEN
569: oe_debug_pub.add('price list line id 3030 is : ');
570: l_Price_LLine_rec.reprice_flag := p_attr_value;

Line 569: oe_debug_pub.add('price list line id 3030 is : ');

565: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_RULE THEN
566: oe_debug_pub.add('price list line id 2929 is : ');
567: l_Price_LLine_rec.pricing_rule_id := TO_NUMBER(p_attr_value);
568: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REPRICE THEN
569: oe_debug_pub.add('price list line id 3030 is : ');
570: l_Price_LLine_rec.reprice_flag := p_attr_value;
571: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REVISION THEN
572: oe_debug_pub.add('price list line id 3131 is : ');
573: l_Price_LLine_rec.revision := p_attr_value;

Line 572: oe_debug_pub.add('price list line id 3131 is : ');

568: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REPRICE THEN
569: oe_debug_pub.add('price list line id 3030 is : ');
570: l_Price_LLine_rec.reprice_flag := p_attr_value;
571: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REVISION THEN
572: oe_debug_pub.add('price list line id 3131 is : ');
573: l_Price_LLine_rec.revision := p_attr_value;
574: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REVISION_DATE THEN
575: oe_debug_pub.add('price list line id 3232 is : ');
576: l_Price_LLine_rec.revision_date := TO_DATE(p_attr_value,'DD/MM/YYYY');

Line 575: oe_debug_pub.add('price list line id 3232 is : ');

571: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REVISION THEN
572: oe_debug_pub.add('price list line id 3131 is : ');
573: l_Price_LLine_rec.revision := p_attr_value;
574: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REVISION_DATE THEN
575: oe_debug_pub.add('price list line id 3232 is : ');
576: l_Price_LLine_rec.revision_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
577: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REVISION_REASON THEN
578: oe_debug_pub.add('price list line id 3434 is : ');
579: l_Price_LLine_rec.revision_reason_code := p_attr_value;

Line 578: oe_debug_pub.add('price list line id 3434 is : ');

574: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REVISION_DATE THEN
575: oe_debug_pub.add('price list line id 3232 is : ');
576: l_Price_LLine_rec.revision_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
577: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REVISION_REASON THEN
578: oe_debug_pub.add('price list line id 3434 is : ');
579: l_Price_LLine_rec.revision_reason_code := p_attr_value;
580: ELSIF p_attr_id = OE_Price_List_Line_Util.G_START_DATE_ACTIVE THEN
581: oe_debug_pub.add('price list line id 3535 is : ');
582: l_Price_LLine_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');

Line 581: oe_debug_pub.add('price list line id 3535 is : ');

577: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REVISION_REASON THEN
578: oe_debug_pub.add('price list line id 3434 is : ');
579: l_Price_LLine_rec.revision_reason_code := p_attr_value;
580: ELSIF p_attr_id = OE_Price_List_Line_Util.G_START_DATE_ACTIVE THEN
581: oe_debug_pub.add('price list line id 3535 is : ');
582: l_Price_LLine_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
583: ELSIF p_attr_id = OE_Price_List_Line_Util.G_UNIT THEN
584: oe_debug_pub.add('price list line id 3636 is : ');
585: l_Price_LLine_rec.unit_code := p_attr_value;

Line 584: oe_debug_pub.add('price list line id 3636 is : ');

580: ELSIF p_attr_id = OE_Price_List_Line_Util.G_START_DATE_ACTIVE THEN
581: oe_debug_pub.add('price list line id 3535 is : ');
582: l_Price_LLine_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
583: ELSIF p_attr_id = OE_Price_List_Line_Util.G_UNIT THEN
584: oe_debug_pub.add('price list line id 3636 is : ');
585: l_Price_LLine_rec.unit_code := p_attr_value;
586: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRIMARY THEN
587: oe_debug_pub.add('price list line id 3737 is : ');
588: l_Price_Lline_rec.primary := p_attr_value;

Line 587: oe_debug_pub.add('price list line id 3737 is : ');

583: ELSIF p_attr_id = OE_Price_List_Line_Util.G_UNIT THEN
584: oe_debug_pub.add('price list line id 3636 is : ');
585: l_Price_LLine_rec.unit_code := p_attr_value;
586: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRIMARY THEN
587: oe_debug_pub.add('price list line id 3737 is : ');
588: l_Price_Lline_rec.primary := p_attr_value;
589: ELSIF p_attr_id = OE_Price_List_Line_Util.G_LIST_LINE_TYPE_CODE THEN
590: oe_debug_pub.add('price list line id 3737 is : ');
591: l_Price_Lline_rec.list_line_type_code := p_attr_value;

Line 590: oe_debug_pub.add('price list line id 3737 is : ');

586: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRIMARY THEN
587: oe_debug_pub.add('price list line id 3737 is : ');
588: l_Price_Lline_rec.primary := p_attr_value;
589: ELSIF p_attr_id = OE_Price_List_Line_Util.G_LIST_LINE_TYPE_CODE THEN
590: oe_debug_pub.add('price list line id 3737 is : ');
591: l_Price_Lline_rec.list_line_type_code := p_attr_value;
592:
593: ELSIF p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE1
594: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE10

Line 627: oe_debug_pub.add('price list line id 4444 is : ');

623: l_Price_LLine_rec.attribute7 := p_attribute7;
624: l_Price_LLine_rec.attribute8 := p_attribute8;
625: l_Price_LLine_rec.attribute9 := p_attribute9;
626: l_Price_LLine_rec.context := p_context;
627: oe_debug_pub.add('price list line id 4444 is : ');
628:
629: ELSE
630:
631: -- Unexpected error, unrecognized attribute

Line 654: oe_debug_pub.add('price list line id 5555 is : ');

650:
651: l_Price_LLine_rec.db_flag := NULL;
652:
653: END IF;
654: oe_debug_pub.add('price list line id 5555 is : ');
655:
656: IF FND_API.To_Boolean(l_Price_LLine_rec.db_flag) THEN
657: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
658: ELSE

Line 664: oe_debug_pub.add('price list line id 6666 is : ');

660: END IF;
661:
662: -- Populate Price_LLine table
663:
664: oe_debug_pub.add('price list line id 6666 is : ');
665: l_Price_LLine_tbl(1) := l_Price_LLine_rec;
666: l_old_Price_LLine_tbl(1) := l_old_Price_LLine_rec;
667:
668: -- Call OE_Pricing_Cont_PVT.Process_Pricing_Cont

Line 670: oe_debug_pub.add('price list line id 7777 is : ');

666: l_old_Price_LLine_tbl(1) := l_old_Price_LLine_rec;
667:
668: -- Call OE_Pricing_Cont_PVT.Process_Pricing_Cont
669:
670: oe_debug_pub.add('price list line id 7777 is : ');
671: OE_Pricing_Cont_PVT.Process_Pricing_Cont
672: ( p_api_version_number => 1.0
673: , p_init_msg_list => FND_API.G_TRUE
674: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

Line 1108: oe_debug_pub.add('Price_List_Id: ' || g_Price_LLine_rec.price_list_id ||

1104: ( p_count => x_msg_count
1105: , p_data => x_msg_data
1106: );
1107:
1108: oe_debug_pub.add('Price_List_Id: ' || g_Price_LLine_rec.price_list_id ||
1109: 'Price_List_Line_Id: ' || g_Price_LLine_rec.price_list_line_id);
1110: oe_debug_pub.add('Exiting OE_OE_Form_Price_Lline.Change_Attribute');
1111:
1112: EXCEPTION

Line 1110: oe_debug_pub.add('Exiting OE_OE_Form_Price_Lline.Change_Attribute');

1106: );
1107:
1108: oe_debug_pub.add('Price_List_Id: ' || g_Price_LLine_rec.price_list_id ||
1109: 'Price_List_Line_Id: ' || g_Price_LLine_rec.price_list_line_id);
1110: oe_debug_pub.add('Exiting OE_OE_Form_Price_Lline.Change_Attribute');
1111:
1112: EXCEPTION
1113:
1114: WHEN FND_API.G_EXC_ERROR THEN

Line 1192: oe_debug_pub.add('Entering OE_OE_Form_Price_Lline.Validate_And_Write');

1188: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1189: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1190: BEGIN
1191:
1192: oe_debug_pub.add('Entering OE_OE_Form_Price_Lline.Validate_And_Write');
1193:
1194: -- Set control flags.
1195:
1196: l_control_rec.controlled_operation := TRUE;

Line 1221: oe_debug_pub.add('Price_List_Id: ' || g_Price_LLine_rec.price_list_id ||

1217: ( p_db_record => FALSE
1218: , p_price_list_line_id => p_price_list_line_id
1219: );
1220:
1221: oe_debug_pub.add('Price_List_Id: ' || g_Price_LLine_rec.price_list_id ||
1222: 'Price_List_Line_Id: ' || g_Price_LLine_rec.price_list_line_id);
1223: oe_debug_pub.add('Price_List_Id: ' || l_Price_LLine_rec.price_list_id ||
1224: 'Price_List_Line_Id: ' || l_Price_LLine_rec.price_list_line_id);
1225: -- Set Operation.

Line 1223: oe_debug_pub.add('Price_List_Id: ' || l_Price_LLine_rec.price_list_id ||

1219: );
1220:
1221: oe_debug_pub.add('Price_List_Id: ' || g_Price_LLine_rec.price_list_id ||
1222: 'Price_List_Line_Id: ' || g_Price_LLine_rec.price_list_line_id);
1223: oe_debug_pub.add('Price_List_Id: ' || l_Price_LLine_rec.price_list_id ||
1224: 'Price_List_Line_Id: ' || l_Price_LLine_rec.price_list_line_id);
1225: -- Set Operation.
1226:
1227: IF FND_API.To_Boolean(l_Price_LLine_rec.db_flag) THEN

Line 1230: oe_debug_pub.add('create price list line');

1226:
1227: IF FND_API.To_Boolean(l_Price_LLine_rec.db_flag) THEN
1228: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1229: ELSE
1230: oe_debug_pub.add('create price list line');
1231: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1232: END IF;
1233:
1234: --Revision Control S

Line 1238: oe_debug_pub.add('incrementing price list line id');

1234: --Revision Control S
1235: IF ( ( l_old_Price_LLine_rec.revision <> FND_API.G_MISS_CHAR )
1236: AND (l_old_Price_LLine_rec.revision <> l_Price_LLine_rec.revision) )
1237: THEN
1238: oe_debug_pub.add('incrementing price list line id');
1239: oe_debug_pub.add('old rev is: ' || l_old_Price_LLine_rec.revision);
1240: oe_debug_pub.add('new rev is: ' || l_Price_LLine_rec.revision);
1241:
1242: IF (l_old_Price_LLine_rec.revision is NULL) THEN

Line 1239: oe_debug_pub.add('old rev is: ' || l_old_Price_LLine_rec.revision);

1235: IF ( ( l_old_Price_LLine_rec.revision <> FND_API.G_MISS_CHAR )
1236: AND (l_old_Price_LLine_rec.revision <> l_Price_LLine_rec.revision) )
1237: THEN
1238: oe_debug_pub.add('incrementing price list line id');
1239: oe_debug_pub.add('old rev is: ' || l_old_Price_LLine_rec.revision);
1240: oe_debug_pub.add('new rev is: ' || l_Price_LLine_rec.revision);
1241:
1242: IF (l_old_Price_LLine_rec.revision is NULL) THEN
1243: oe_debug_pub.add('old revision is null');

Line 1240: oe_debug_pub.add('new rev is: ' || l_Price_LLine_rec.revision);

1236: AND (l_old_Price_LLine_rec.revision <> l_Price_LLine_rec.revision) )
1237: THEN
1238: oe_debug_pub.add('incrementing price list line id');
1239: oe_debug_pub.add('old rev is: ' || l_old_Price_LLine_rec.revision);
1240: oe_debug_pub.add('new rev is: ' || l_Price_LLine_rec.revision);
1241:
1242: IF (l_old_Price_LLine_rec.revision is NULL) THEN
1243: oe_debug_pub.add('old revision is null');
1244: END IF;

Line 1243: oe_debug_pub.add('old revision is null');

1239: oe_debug_pub.add('old rev is: ' || l_old_Price_LLine_rec.revision);
1240: oe_debug_pub.add('new rev is: ' || l_Price_LLine_rec.revision);
1241:
1242: IF (l_old_Price_LLine_rec.revision is NULL) THEN
1243: oe_debug_pub.add('old revision is null');
1244: END IF;
1245:
1246: IF (l_Price_LLine_rec.revision is NULL) THEN
1247: oe_debug_pub.add('new revision is also null');

Line 1247: oe_debug_pub.add('new revision is also null');

1243: oe_debug_pub.add('old revision is null');
1244: END IF;
1245:
1246: IF (l_Price_LLine_rec.revision is NULL) THEN
1247: oe_debug_pub.add('new revision is also null');
1248: END IF;
1249:
1250: select qp_list_lines_s.nextval into l_Price_LLine_rec.price_list_line_id from dual;
1251: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_CREATE;

Line 1319: oe_debug_pub.add('Exiting OE_OE_Form_Price_Lline.Validate_And_Write');

1315: ( p_count => x_msg_count
1316: , p_data => x_msg_data
1317: );
1318:
1319: oe_debug_pub.add('Exiting OE_OE_Form_Price_Lline.Validate_And_Write');
1320:
1321: EXCEPTION
1322:
1323: WHEN FND_API.G_EXC_ERROR THEN

Line 1537: oe_debug_pub.add('Entering OE_OE_Form_Price_Lline.Process_Entity');

1533: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1534: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1535: BEGIN
1536:
1537: oe_debug_pub.add('Entering OE_OE_Form_Price_Lline.Process_Entity');
1538:
1539: -- Set control flags.
1540:
1541: l_control_rec.controlled_operation := TRUE;

Line 1592: oe_debug_pub.add('Exiting OE_OE_Form_Price_Lline.Process_Entity');

1588: ( p_count => x_msg_count
1589: , p_data => x_msg_data
1590: );
1591:
1592: oe_debug_pub.add('Exiting OE_OE_Form_Price_Lline.Process_Entity');
1593:
1594: EXCEPTION
1595:
1596: WHEN FND_API.G_EXC_ERROR THEN

Line 1725: oe_debug_pub.add('price list id 1 is : ' || to_char(p_price_list_id));

1721: BEGIN
1722:
1723: -- Load Price_LLine record
1724:
1725: oe_debug_pub.add('price list id 1 is : ' || to_char(p_price_list_id));
1726:
1727:
1728: l_Price_LLine_rec.attribute1 := p_attribute1;
1729: l_Price_LLine_rec.attribute10 := p_attribute10;

Line 1792: oe_debug_pub.add('price list id 2 is : ' || to_char(l_Price_LLine_tbl(1).price_list_id));

1788: -- Populate Price_LLine table
1789:
1790: l_Price_LLine_tbl(1) := l_Price_LLine_rec;
1791:
1792: oe_debug_pub.add('price list id 2 is : ' || to_char(l_Price_LLine_tbl(1).price_list_id));
1793:
1794: -- Call OE_Pricing_Cont_PVT.Lock_Pricing_Cont
1795:
1796: OE_Pricing_Cont_PVT.Lock_Pricing_Cont

Line 1813: oe_debug_pub.add('price list id 3 is : ' || to_char(p_price_list_id));

1809: , x_Discount_Line_tbl => l_x_Discount_Line_tbl
1810: , x_Price_Break_tbl => l_x_Price_Break_tbl
1811: );
1812:
1813: oe_debug_pub.add('price list id 3 is : ' || to_char(p_price_list_id));
1814:
1815: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1816:
1817: -- Set DB flag and write record to cache.

Line 1892: oe_debug_pub.add('global pline id is : ' || to_char(g_Price_LLine_rec.price_list_id));

1888: RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type
1889: IS
1890: BEGIN
1891:
1892: oe_debug_pub.add('global pline id is : ' || to_char(g_Price_LLine_rec.price_list_id));
1893:
1894: oe_debug_pub.add('plineid 2 is : ' || to_char(p_price_list_line_id));
1895:
1896: IF p_price_list_line_id <> g_Price_LLine_rec.price_list_line_id

Line 1894: oe_debug_pub.add('plineid 2 is : ' || to_char(p_price_list_line_id));

1890: BEGIN
1891:
1892: oe_debug_pub.add('global pline id is : ' || to_char(g_Price_LLine_rec.price_list_id));
1893:
1894: oe_debug_pub.add('plineid 2 is : ' || to_char(p_price_list_line_id));
1895:
1896: IF p_price_list_line_id <> g_Price_LLine_rec.price_list_line_id
1897: THEN
1898: