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

Line 28: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

24: , p_header_val_rec IN OUT NOCOPY OE_Order_PUB.Header_Val_Rec_Type
25: )IS
26: l_header_rec OE_Order_PUB.Header_Rec_Type;
27: l_order_type varchar2(240);
28: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
29: BEGIN
30: OE_MSG_PUB.initialize;
31: l_header_rec.accounting_rule_id := p_header_rec.accounting_rule_id;
32: l_header_rec.agreement_id := p_header_rec.agreement_id;

Line 88: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

84: ( p_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_Rec_Type
85: , p_line_val_rec IN OUT NOCOPY OE_Order_PUB.Line_Val_Rec_Type
86: )IS
87: l_line_rec OE_Order_PUB.Line_Rec_Type;
88: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
89: BEGIN
90:
91: OE_MSG_PUB.initialize;
92: l_line_rec.invoice_to_org_id := p_line_rec.invoice_to_org_id;

Line 150: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

146: ----------------------------------------------------------
147: ( p_Header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_Type
148: , p_Header_val_rec IN OUT NOCOPY OE_Order_PUB.Header_Val_Rec_Type
149: )IS
150: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
151:
152: BEGIN
153:
154: OE_MSG_PUB.initialize;

Line 294: oe_debug_pub.add('enter Populate_Line_Values_ID');

290: ( p_Line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_Rec_Type
291: , p_line_val_rec IN OUT NOCOPY OE_Order_PUB.Line_Val_Rec_Type
292: )IS
293: BEGIN
294: oe_debug_pub.add('enter Populate_Line_Values_ID');
295:
296: OE_MSG_PUB.initialize;
297: OE_ID_TO_VALUE.Ship_From_Org(
298: p_ship_from_org_id => p_line_rec.ship_from_org_id

Line 306: oe_debug_pub.add('before Populate_Line_Values_ID ship_to_org_id '||p_line_rec.ship_to_org_id);

302: ,x_ship_from_address4 => p_line_val_rec.ship_from_address4
303: ,x_ship_from_location => p_line_val_rec.ship_from_location
304: ,x_ship_from_org => p_line_val_rec.ship_from_org
305: );
306: oe_debug_pub.add('before Populate_Line_Values_ID ship_to_org_id '||p_line_rec.ship_to_org_id);
307: if p_line_rec.ship_to_org_id is not null then
308: oe_debug_pub.add('ship to : '||p_line_rec.ship_To_org_id);
309: OE_ID_TO_VALUE.Ship_To_Org
310: ( p_ship_to_org_id => p_line_rec.ship_To_org_id

Line 308: oe_debug_pub.add('ship to : '||p_line_rec.ship_To_org_id);

304: ,x_ship_from_org => p_line_val_rec.ship_from_org
305: );
306: oe_debug_pub.add('before Populate_Line_Values_ID ship_to_org_id '||p_line_rec.ship_to_org_id);
307: if p_line_rec.ship_to_org_id is not null then
308: oe_debug_pub.add('ship to : '||p_line_rec.ship_To_org_id);
309: OE_ID_TO_VALUE.Ship_To_Org
310: ( p_ship_to_org_id => p_line_rec.ship_To_org_id
311: , x_ship_to_address1 => p_line_val_rec.ship_to_address1
312: , x_ship_to_address2 => p_line_val_rec.ship_to_address2

Line 323: oe_debug_pub.add('After Populate_Line_Values_ID ship_to_org_id '||p_line_rec.ship_to_org_id);

319: , x_ship_to_postal_code => p_line_val_rec.ship_to_zip
320: , x_ship_to_country => p_line_val_rec.ship_to_country
321: );
322: end if;
323: oe_debug_pub.add('After Populate_Line_Values_ID ship_to_org_id '||p_line_rec.ship_to_org_id);
324:
325: if p_line_rec.deliver_to_org_id is not null then
326: OE_ID_TO_VALUE.deliver_To_Org
327: ( p_deliver_to_org_id => p_line_rec.deliver_To_org_id

Line 419: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

415: )IS
416: l_old_header_rec oe_blanket_pub.header_rec_type;
417: l_old_blanket_number number;
418: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Entity';
419: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
420: BEGIN
421: OE_MSG_PUB.initialize;
422:
423:

Line 436: oe_debug_pub.add('Before sending to the API New Blanket MAX number FROM the API '

432: Load_Blanket_Header_Rec (p_header_rec,l_old_header_rec);
433:
434: END IF;
435:
436: oe_debug_pub.add('Before sending to the API New Blanket MAX number FROM the API '
437: ||p_header_rec.blanket_max_amount);
438: oe_debug_pub.add('Before sending to the API OLd Blanket MAX number FROM the API '
439: ||l_old_header_rec.blanket_max_amount);
440: oe_debug_pub.add('Before sending to the API New Blanket MIN number FROM the API '

Line 438: oe_debug_pub.add('Before sending to the API OLd Blanket MAX number FROM the API '

434: END IF;
435:
436: oe_debug_pub.add('Before sending to the API New Blanket MAX number FROM the API '
437: ||p_header_rec.blanket_max_amount);
438: oe_debug_pub.add('Before sending to the API OLd Blanket MAX number FROM the API '
439: ||l_old_header_rec.blanket_max_amount);
440: oe_debug_pub.add('Before sending to the API New Blanket MIN number FROM the API '
441: ||p_header_rec.blanket_min_amount);
442: oe_debug_pub.add('Before sending to the API OLd Blanket MIN number FROM the API '

Line 440: oe_debug_pub.add('Before sending to the API New Blanket MIN number FROM the API '

436: oe_debug_pub.add('Before sending to the API New Blanket MAX number FROM the API '
437: ||p_header_rec.blanket_max_amount);
438: oe_debug_pub.add('Before sending to the API OLd Blanket MAX number FROM the API '
439: ||l_old_header_rec.blanket_max_amount);
440: oe_debug_pub.add('Before sending to the API New Blanket MIN number FROM the API '
441: ||p_header_rec.blanket_min_amount);
442: oe_debug_pub.add('Before sending to the API OLd Blanket MIN number FROM the API '
443: ||l_old_header_rec.blanket_min_amount);
444:

Line 442: oe_debug_pub.add('Before sending to the API OLd Blanket MIN number FROM the API '

438: oe_debug_pub.add('Before sending to the API OLd Blanket MAX number FROM the API '
439: ||l_old_header_rec.blanket_max_amount);
440: oe_debug_pub.add('Before sending to the API New Blanket MIN number FROM the API '
441: ||p_header_rec.blanket_min_amount);
442: oe_debug_pub.add('Before sending to the API OLd Blanket MIN number FROM the API '
443: ||l_old_header_rec.blanket_min_amount);
444:
445: OE_Blanket_Util.Validate_Entity(p_header_rec,
446: l_old_header_rec,

Line 449: oe_debug_pub.add('After returning from the API New Blanket MAX number FROM the API '

445: OE_Blanket_Util.Validate_Entity(p_header_rec,
446: l_old_header_rec,
447: x_return_status);
448:
449: oe_debug_pub.add('After returning from the API New Blanket MAX number FROM the API '
450: ||p_header_rec.blanket_max_amount);
451: oe_debug_pub.add('After returning from the API OLd Blanket MAX number FROM the API '
452: ||l_old_header_rec.blanket_max_amount);
453: oe_debug_pub.add('After returning from the API New Blanket MIN number FROM the API '

Line 451: oe_debug_pub.add('After returning from the API OLd Blanket MAX number FROM the API '

447: x_return_status);
448:
449: oe_debug_pub.add('After returning from the API New Blanket MAX number FROM the API '
450: ||p_header_rec.blanket_max_amount);
451: oe_debug_pub.add('After returning from the API OLd Blanket MAX number FROM the API '
452: ||l_old_header_rec.blanket_max_amount);
453: oe_debug_pub.add('After returning from the API New Blanket MIN number FROM the API '
454: ||p_header_rec.blanket_min_amount);
455: oe_debug_pub.add('After returning from the API OLd Blanket MIN number FROM the API '

Line 453: oe_debug_pub.add('After returning from the API New Blanket MIN number FROM the API '

449: oe_debug_pub.add('After returning from the API New Blanket MAX number FROM the API '
450: ||p_header_rec.blanket_max_amount);
451: oe_debug_pub.add('After returning from the API OLd Blanket MAX number FROM the API '
452: ||l_old_header_rec.blanket_max_amount);
453: oe_debug_pub.add('After returning from the API New Blanket MIN number FROM the API '
454: ||p_header_rec.blanket_min_amount);
455: oe_debug_pub.add('After returning from the API OLd Blanket MIN number FROM the API '
456: ||l_old_header_rec.blanket_min_amount);
457:

Line 455: oe_debug_pub.add('After returning from the API OLd Blanket MIN number FROM the API '

451: oe_debug_pub.add('After returning from the API OLd Blanket MAX number FROM the API '
452: ||l_old_header_rec.blanket_max_amount);
453: oe_debug_pub.add('After returning from the API New Blanket MIN number FROM the API '
454: ||p_header_rec.blanket_min_amount);
455: oe_debug_pub.add('After returning from the API OLd Blanket MIN number FROM the API '
456: ||l_old_header_rec.blanket_min_amount);
457:
458: oe_debug_pub.add('Return status of validate entity API '
459: ||x_return_status);

Line 458: oe_debug_pub.add('Return status of validate entity API '

454: ||p_header_rec.blanket_min_amount);
455: oe_debug_pub.add('After returning from the API OLd Blanket MIN number FROM the API '
456: ||l_old_header_rec.blanket_min_amount);
457:
458: oe_debug_pub.add('Return status of validate entity API '
459: ||x_return_status);
460:
461: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
462:

Line 463: oe_debug_pub.add('Return status int the IF Expected error API '

459: ||x_return_status);
460:
461: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
462:
463: oe_debug_pub.add('Return status int the IF Expected error API '
464: ||x_return_status);
465: RAISE FND_API.G_EXC_ERROR;
466:
467: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 469: oe_debug_pub.add('Return status int the ELSE in the unexpected errorAPI '

465: RAISE FND_API.G_EXC_ERROR;
466:
467: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
468:
469: oe_debug_pub.add('Return status int the ELSE in the unexpected errorAPI '
470: ||x_return_status);
471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
472:
473: END IF;

Line 475: oe_debug_pub.add('Before udation of the cache New Blanket MAX number after exp FROM the API '

471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
472:
473: END IF;
474:
475: oe_debug_pub.add('Before udation of the cache New Blanket MAX number after exp FROM the API '
476: ||p_header_rec.blanket_max_amount);
477: oe_debug_pub.add('Before udation of the cache OLd Blanket MAX number after exp FROM the API '
478: ||l_old_header_rec.blanket_max_amount);
479: oe_debug_pub.add('Before udation of the cache New Blanket MIN number after exp FROM the API '

Line 477: oe_debug_pub.add('Before udation of the cache OLd Blanket MAX number after exp FROM the API '

473: END IF;
474:
475: oe_debug_pub.add('Before udation of the cache New Blanket MAX number after exp FROM the API '
476: ||p_header_rec.blanket_max_amount);
477: oe_debug_pub.add('Before udation of the cache OLd Blanket MAX number after exp FROM the API '
478: ||l_old_header_rec.blanket_max_amount);
479: oe_debug_pub.add('Before udation of the cache New Blanket MIN number after exp FROM the API '
480: ||p_header_rec.blanket_min_amount);
481: oe_debug_pub.add('Before udation of the cache OLd Blanket MIN number after exp FROM the API '

Line 479: oe_debug_pub.add('Before udation of the cache New Blanket MIN number after exp FROM the API '

475: oe_debug_pub.add('Before udation of the cache New Blanket MAX number after exp FROM the API '
476: ||p_header_rec.blanket_max_amount);
477: oe_debug_pub.add('Before udation of the cache OLd Blanket MAX number after exp FROM the API '
478: ||l_old_header_rec.blanket_max_amount);
479: oe_debug_pub.add('Before udation of the cache New Blanket MIN number after exp FROM the API '
480: ||p_header_rec.blanket_min_amount);
481: oe_debug_pub.add('Before udation of the cache OLd Blanket MIN number after exp FROM the API '
482: ||l_old_header_rec.blanket_min_amount);
483:

Line 481: oe_debug_pub.add('Before udation of the cache OLd Blanket MIN number after exp FROM the API '

477: oe_debug_pub.add('Before udation of the cache OLd Blanket MAX number after exp FROM the API '
478: ||l_old_header_rec.blanket_max_amount);
479: oe_debug_pub.add('Before udation of the cache New Blanket MIN number after exp FROM the API '
480: ||p_header_rec.blanket_min_amount);
481: oe_debug_pub.add('Before udation of the cache OLd Blanket MIN number after exp FROM the API '
482: ||l_old_header_rec.blanket_min_amount);
483:
484: Update_Header_Cache(p_header_rec);
485:

Line 486: oe_debug_pub.add('After udation of the cache New Blanket MAX number after exp FROM the API '

482: ||l_old_header_rec.blanket_min_amount);
483:
484: Update_Header_Cache(p_header_rec);
485:
486: oe_debug_pub.add('After udation of the cache New Blanket MAX number after exp FROM the API '
487: ||p_header_rec.blanket_max_amount);
488: oe_debug_pub.add('After udation of the cache OLd Blanket MAX number after exp FROM the API '
489: ||l_old_header_rec.blanket_max_amount);
490: oe_debug_pub.add('After udation of the cache New Blanket MIN number after exp FROM the API '

Line 488: oe_debug_pub.add('After udation of the cache OLd Blanket MAX number after exp FROM the API '

484: Update_Header_Cache(p_header_rec);
485:
486: oe_debug_pub.add('After udation of the cache New Blanket MAX number after exp FROM the API '
487: ||p_header_rec.blanket_max_amount);
488: oe_debug_pub.add('After udation of the cache OLd Blanket MAX number after exp FROM the API '
489: ||l_old_header_rec.blanket_max_amount);
490: oe_debug_pub.add('After udation of the cache New Blanket MIN number after exp FROM the API '
491: ||p_header_rec.blanket_min_amount);
492: oe_debug_pub.add('After udation of the cache OLd Blanket MIN number after exp FROM the API '

Line 490: oe_debug_pub.add('After udation of the cache New Blanket MIN number after exp FROM the API '

486: oe_debug_pub.add('After udation of the cache New Blanket MAX number after exp FROM the API '
487: ||p_header_rec.blanket_max_amount);
488: oe_debug_pub.add('After udation of the cache OLd Blanket MAX number after exp FROM the API '
489: ||l_old_header_rec.blanket_max_amount);
490: oe_debug_pub.add('After udation of the cache New Blanket MIN number after exp FROM the API '
491: ||p_header_rec.blanket_min_amount);
492: oe_debug_pub.add('After udation of the cache OLd Blanket MIN number after exp FROM the API '
493: ||l_old_header_rec.blanket_min_amount);
494:

Line 492: oe_debug_pub.add('After udation of the cache OLd Blanket MIN number after exp FROM the API '

488: oe_debug_pub.add('After udation of the cache OLd Blanket MAX number after exp FROM the API '
489: ||l_old_header_rec.blanket_max_amount);
490: oe_debug_pub.add('After udation of the cache New Blanket MIN number after exp FROM the API '
491: ||p_header_rec.blanket_min_amount);
492: oe_debug_pub.add('After udation of the cache OLd Blanket MIN number after exp FROM the API '
493: ||l_old_header_rec.blanket_min_amount);
494:
495: oe_msg_pub.count_and_get
496: ( p_count => x_msg_count

Line 499: oe_debug_pub.add('After Validate Entity of the cache x_msg_count Header' ||x_msg_count);

495: oe_msg_pub.count_and_get
496: ( p_count => x_msg_count
497: , p_data => x_msg_data);
498:
499: oe_debug_pub.add('After Validate Entity of the cache x_msg_count Header' ||x_msg_count);
500: oe_debug_pub.add('After Validate Entity of the cache x_msg_data Header' ||x_msg_data);
501:
502: EXCEPTION
503:

Line 500: oe_debug_pub.add('After Validate Entity of the cache x_msg_data Header' ||x_msg_data);

496: ( p_count => x_msg_count
497: , p_data => x_msg_data);
498:
499: oe_debug_pub.add('After Validate Entity of the cache x_msg_count Header' ||x_msg_count);
500: oe_debug_pub.add('After Validate Entity of the cache x_msg_data Header' ||x_msg_data);
501:
502: EXCEPTION
503:
504: WHEN FND_API.G_EXC_ERROR THEN

Line 554: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

550:
551: ) IS
552: l_old_line_rec oe_blanket_pub.line_rec_type;
553: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Entity';
554: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
555: BEGIN
556:
557: OE_MSG_PUB.initialize;
558:

Line 571: oe_debug_pub.add('Inventory item id - RAJ' || p_line_rec.inventory_item_id);

567: Load_Blanket_line_Rec (p_line_rec,l_old_line_rec);
568:
569: end if;
570:
571: oe_debug_pub.add('Inventory item id - RAJ' || p_line_rec.inventory_item_id);
572:
573: OE_Blanket_Util.Validate_Entity(p_line_rec,
574: l_old_line_rec,
575: x_return_status);

Line 593: oe_debug_pub.add('After Validate Entity of the cache x_msg_count Line' ||x_msg_count);

589: oe_msg_pub.count_and_get
590: ( p_count => x_msg_count
591: , p_data => x_msg_data);
592:
593: oe_debug_pub.add('After Validate Entity of the cache x_msg_count Line' ||x_msg_count);
594: oe_debug_pub.add('After Validate Entity of the cache x_msg_data Line' ||x_msg_data);
595:
596: EXCEPTION
597:

Line 594: oe_debug_pub.add('After Validate Entity of the cache x_msg_data Line' ||x_msg_data);

590: ( p_count => x_msg_count
591: , p_data => x_msg_data);
592:
593: oe_debug_pub.add('After Validate Entity of the cache x_msg_count Line' ||x_msg_count);
594: oe_debug_pub.add('After Validate Entity of the cache x_msg_data Line' ||x_msg_data);
595:
596: EXCEPTION
597:
598: WHEN FND_API.G_EXC_ERROR THEN

Line 599: oe_debug_pub.add('Return Status is-Exp ' || X_return_status);

595:
596: EXCEPTION
597:
598: WHEN FND_API.G_EXC_ERROR THEN
599: oe_debug_pub.add('Return Status is-Exp ' || X_return_status);
600: x_return_status := FND_API.G_RET_STS_ERROR;
601:
602: -- Get message count and data
603:

Line 650: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

646: x_msg_data OUT NOCOPY VARCHAR2
647: )
648: IS
649: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
650: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
651: BEGIN
652: OE_MSG_PUB.initialize;
653: oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.Insert_row', 1);
654:

Line 653: oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.Insert_row', 1);

649: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
650: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
651: BEGIN
652: OE_MSG_PUB.initialize;
653: oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.Insert_row', 1);
654:
655: OE_Blanket_Util.Insert_Row(p_header_rec,X_RETURN_STATUS);
656:
657: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 667: oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.Insert_row', 1);

663: oe_msg_pub.count_and_get
664: ( p_count => x_msg_count
665: , p_data => x_msg_data);
666:
667: oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.Insert_row', 1);
668:
669: EXCEPTION
670:
671: WHEN FND_API.G_EXC_ERROR THEN

Line 721: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

717: x_msg_data OUT NOCOPY VARCHAR2
718: )
719: IS
720: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
721: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
722:
723: BEGIN
724: OE_MSG_PUB.initialize;
725: oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.Update_row', 1);

Line 725: oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.Update_row', 1);

721: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
722:
723: BEGIN
724: OE_MSG_PUB.initialize;
725: oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.Update_row', 1);
726:
727: OE_Blanket_Util.Update_Row(p_header_rec,X_RETURN_STATUS);
728:
729: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 739: oe_debug_pub.add('Existing Header OE_Blanket_Form_Control.Update_row', 1);

735: oe_msg_pub.count_and_get
736: ( p_count => x_msg_count
737: , p_data => x_msg_data);
738:
739: oe_debug_pub.add('Existing Header OE_Blanket_Form_Control.Update_row', 1);
740:
741: EXCEPTION
742:
743: WHEN FND_API.G_EXC_ERROR THEN

Line 793: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

789: x_msg_data OUT NOCOPY VARCHAR2
790: )
791: IS
792: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Row';
793: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
794: BEGIN
795: -- hashraf ... start of pack J
796:
797: OE_MSG_PUB.initialize;

Line 798: oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.Delete_row', 1);

794: BEGIN
795: -- hashraf ... start of pack J
796:
797: OE_MSG_PUB.initialize;
798: oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.Delete_row', 1);
799:
800: OE_Blanket_Util.Delete_Row(p_header_id => p_header_id
801: ,X_RETURN_STATUS => x_return_status);
802:

Line 813: oe_debug_pub.add('Exiting Header OE_Blanket_Form_Control.Delete_row', 1);

809: oe_msg_pub.count_and_get
810: ( p_count => x_msg_count
811: , p_data => x_msg_data);
812:
813: oe_debug_pub.add('Exiting Header OE_Blanket_Form_Control.Delete_row', 1);
814:
815: EXCEPTION
816:
817: WHEN FND_API.G_EXC_ERROR THEN

Line 867: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

863: x_msg_data OUT NOCOPY VARCHAR2
864: )
865: IS
866: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
867: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
868: BEGIN
869: OE_MSG_PUB.initialize;
870: oe_debug_pub.add('Entering Lines OE_Blanket_Form_Control.Insert_row', 1);
871:

Line 870: oe_debug_pub.add('Entering Lines OE_Blanket_Form_Control.Insert_row', 1);

866: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
867: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
868: BEGIN
869: OE_MSG_PUB.initialize;
870: oe_debug_pub.add('Entering Lines OE_Blanket_Form_Control.Insert_row', 1);
871:
872: OE_Blanket_Util.Insert_Row(p_line_rec,X_RETURN_STATUS);
873:
874: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 884: oe_debug_pub.add('Existing Lines OE_Blanket_Form_Control.Insert_row', 1);

880: oe_msg_pub.count_and_get
881: ( p_count => x_msg_count
882: , p_data => x_msg_data);
883:
884: oe_debug_pub.add('Existing Lines OE_Blanket_Form_Control.Insert_row', 1);
885:
886: EXCEPTION
887:
888: WHEN FND_API.G_EXC_ERROR THEN

Line 938: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

934: x_msg_data OUT NOCOPY VARCHAR2
935: )
936: IS
937: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
938: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
939: BEGIN
940: OE_MSG_PUB.initialize;
941: oe_debug_pub.add('Entering Lines OE_Blanket_Form_Control.Update_row', 1);
942: OE_Blanket_Util.Update_Row(p_line_rec,X_RETURN_STATUS);

Line 941: oe_debug_pub.add('Entering Lines OE_Blanket_Form_Control.Update_row', 1);

937: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
938: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
939: BEGIN
940: OE_MSG_PUB.initialize;
941: oe_debug_pub.add('Entering Lines OE_Blanket_Form_Control.Update_row', 1);
942: OE_Blanket_Util.Update_Row(p_line_rec,X_RETURN_STATUS);
943:
944: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
945: RAISE FND_API.G_EXC_ERROR;

Line 954: oe_debug_pub.add('Existing Lines OE_Blanket_Form_Control.Update_row', 1);

950: oe_msg_pub.count_and_get
951: ( p_count => x_msg_count
952: , p_data => x_msg_data);
953:
954: oe_debug_pub.add('Existing Lines OE_Blanket_Form_Control.Update_row', 1);
955:
956: EXCEPTION
957:
958: WHEN FND_API.G_EXC_ERROR THEN

Line 1007: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1003: x_msg_data OUT NOCOPY VARCHAR2
1004: )
1005: IS
1006: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Row';
1007: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1008: BEGIN
1009: -- hashraf ... start of pack J
1010: OE_MSG_PUB.initialize;
1011: oe_debug_pub.add('Entering Lines OE_Blanket_Form_Control.Delete_row', 1);

Line 1011: oe_debug_pub.add('Entering Lines OE_Blanket_Form_Control.Delete_row', 1);

1007: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1008: BEGIN
1009: -- hashraf ... start of pack J
1010: OE_MSG_PUB.initialize;
1011: oe_debug_pub.add('Entering Lines OE_Blanket_Form_Control.Delete_row', 1);
1012:
1013: OE_Blanket_Util.Delete_Row(p_line_id => p_line_id
1014: ,x_return_status => X_RETURN_STATUS);
1015:

Line 1026: oe_debug_pub.add('Exiting Lines OE_Blanket_Form_Control.Delete_row', 1);

1022: oe_msg_pub.count_and_get
1023: ( p_count => x_msg_count
1024: , p_data => x_msg_data);
1025:
1026: oe_debug_pub.add('Exiting Lines OE_Blanket_Form_Control.Delete_row', 1);
1027:
1028: EXCEPTION
1029:
1030: WHEN FND_API.G_EXC_ERROR THEN

Line 1081: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1077: )
1078: IS
1079: l_error NUMBER := 0;
1080: l_api_name CONSTANT VARCHAR2(30) := 'Default_Attributes';
1081: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1082: BEGIN
1083: IF l_debug_level > 0 THEN
1084: oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.DEFAULT_ATTRIBUTES', 1);
1085: END IF;

Line 1084: oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.DEFAULT_ATTRIBUTES', 1);

1080: l_api_name CONSTANT VARCHAR2(30) := 'Default_Attributes';
1081: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1082: BEGIN
1083: IF l_debug_level > 0 THEN
1084: oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.DEFAULT_ATTRIBUTES', 1);
1085: END IF;
1086: OE_MSG_PUB.initialize;
1087: --Clearing the line cache Bug#4878846.
1088: g_line_cache_rec.delete;

Line 1106: oe_debug_pub.add('Exiting Header OE_Blanket_Form_Control.DEFAULT_ATTRIBUTES', 1);

1102: ( p_count => x_msg_count
1103: , p_data => x_msg_data);
1104:
1105: IF l_debug_level > 0 THEN
1106: oe_debug_pub.add('Exiting Header OE_Blanket_Form_Control.DEFAULT_ATTRIBUTES', 1);
1107: END IF;
1108:
1109: EXCEPTION
1110: WHEN FND_API.G_EXC_ERROR THEN

Line 1118: oe_debug_pub.add('Exiting Header OE_Blanket_Form_Control.DEFAULT_ATTRIBUTES expected errors', 1);

1114: ( p_count => x_msg_count
1115: , p_data => x_msg_data
1116: );
1117: IF l_debug_level > 0 THEN
1118: oe_debug_pub.add('Exiting Header OE_Blanket_Form_Control.DEFAULT_ATTRIBUTES expected errors', 1);
1119: END IF;
1120:
1121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1122:

Line 1142: oe_debug_pub.add('Exiting Header OE_Blanket_Form_Control.DEFAULT_ATTRIBUTES unexpected errors', 1);

1138: l_api_name
1139: );
1140: END IF;
1141: IF l_debug_level > 0 THEN
1142: oe_debug_pub.add('Exiting Header OE_Blanket_Form_Control.DEFAULT_ATTRIBUTES unexpected errors', 1);
1143: END IF;
1144:
1145: -- Get message count and data
1146: OE_MSG_PUB.Count_And_Get

Line 1167: oe_debug_pub.add('Entering Lines OE_Blanket_Form_Control.DEFAULT_ATTRIBUTES', 1);

1163: l_error NUMBER;
1164: p_default_from_header BOOLEAN := TRUE;
1165: BEGIN
1166: OE_MSG_PUB.initialize;
1167: oe_debug_pub.add('Entering Lines OE_Blanket_Form_Control.DEFAULT_ATTRIBUTES', 1);
1168:
1169: l_error := 1;
1170: l_old_blanket_line_number := p_x_line_rec.line_number;
1171:

Line 1195: oe_debug_pub.add('Existing Lines OE_Blanket_Form_Control.DEFAULT_ATTRIBUTES', 1);

1191: oe_msg_pub.count_and_get
1192: ( p_count => x_msg_count
1193: , p_data => x_msg_data);
1194:
1195: oe_debug_pub.add('Existing Lines OE_Blanket_Form_Control.DEFAULT_ATTRIBUTES', 1);
1196:
1197: EXCEPTION
1198: WHEN FND_API.G_EXC_ERROR THEN
1199: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1237: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1233: )
1234: IS
1235: ctr number := 1;
1236: l_api_name CONSTANT VARCHAR2(30) := 'Process_Object';
1237: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1238: --bug#4691643
1239: I number := 1;
1240: l_dummy_header_rec oe_blanket_pub.header_rec_type;
1241: l_dummy_line_rec oe_blanket_pub.line_rec_type;

Line 1250: oe_debug_pub.add('Entering OE_Blanket_Form_Control.Process_object', 0);

1246:
1247: OE_MSG_PUB.initialize;
1248:
1249:
1250: oe_debug_pub.add('Entering OE_Blanket_Form_Control.Process_object', 0);
1251: --bug#4691643
1252: --Log delayed requests again ,if delayed requests for the corresponding
1253: --entity doesn't exist because of exception
1254: While ctr <= G_header_Cache_Rec.count loop

Line 1329: oe_debug_pub.add('Entering OE_Blanket_Form_Control.Process_object', 0);

1325: ctr := ctr + 1;
1326: end loop;
1327:
1328: ctr := 1;
1329: oe_debug_pub.add('Entering OE_Blanket_Form_Control.Process_object', 0);
1330: --bug#4691643 end
1331: ----------------------------------------------------------
1332: -- Insert or Update Header Records into the Database
1333: ----------------------------------------------------------

Line 1344: oe_debug_pub.add('Operation IS: '||G_header_cache_rec(ctr).operation);

1340:
1341: SAVEPOINT Save_Blanket_Changes;
1342:
1343: While ctr <= G_header_Cache_Rec.count loop
1344: oe_debug_pub.add('Operation IS: '||G_header_cache_rec(ctr).operation);
1345: x_return_status := FND_API.G_RET_STS_SUCCESS;
1346:
1347: If G_header_cache_rec(ctr).operation = OE_GLOBALS.G_OPR_UPDATE then
1348: oe_debug_pub.add('Operation in Update Condi: '||G_header_cache_rec(ctr).operation);

Line 1348: oe_debug_pub.add('Operation in Update Condi: '||G_header_cache_rec(ctr).operation);

1344: oe_debug_pub.add('Operation IS: '||G_header_cache_rec(ctr).operation);
1345: x_return_status := FND_API.G_RET_STS_SUCCESS;
1346:
1347: If G_header_cache_rec(ctr).operation = OE_GLOBALS.G_OPR_UPDATE then
1348: oe_debug_pub.add('Operation in Update Condi: '||G_header_cache_rec(ctr).operation);
1349: OE_Blanket_Util.Update_Row(G_header_Cache_Rec(ctr),x_return_status);
1350: ElsIf G_header_cache_rec(ctr).operation = OE_GLOBALS.G_OPR_CREATE then
1351: oe_debug_pub.add('Operation IN Insert Condi: '||G_header_cache_rec(ctr).operation);
1352: OE_Blanket_Util.Insert_Row(G_header_Cache_Rec(ctr),x_return_status);

Line 1351: oe_debug_pub.add('Operation IN Insert Condi: '||G_header_cache_rec(ctr).operation);

1347: If G_header_cache_rec(ctr).operation = OE_GLOBALS.G_OPR_UPDATE then
1348: oe_debug_pub.add('Operation in Update Condi: '||G_header_cache_rec(ctr).operation);
1349: OE_Blanket_Util.Update_Row(G_header_Cache_Rec(ctr),x_return_status);
1350: ElsIf G_header_cache_rec(ctr).operation = OE_GLOBALS.G_OPR_CREATE then
1351: oe_debug_pub.add('Operation IN Insert Condi: '||G_header_cache_rec(ctr).operation);
1352: OE_Blanket_Util.Insert_Row(G_header_Cache_Rec(ctr),x_return_status);
1353:
1354: --Workflow changes for 11i10.
1355: --For the bug3230820

Line 1362: oe_debug_pub.add('Operation IS Delete Condi: '||G_header_cache_rec(ctr).operation);

1358: -- Through BSA UI.
1359:
1360: -- hashraf ... start of pack J
1361: ElsIf G_header_cache_rec(ctr).operation = OE_GLOBALS.G_OPR_DELETE then
1362: oe_debug_pub.add('Operation IS Delete Condi: '||G_header_cache_rec(ctr).operation);
1363: OE_Blanket_Util.Delete_Row(p_header_id => G_header_Cache_Rec(ctr).header_id,
1364: x_return_status => x_return_status);
1365: -- hashraf ... end of pack J
1366: End if;

Line 1399: oe_debug_pub.add('Process_object for Lines update', 4);

1395:
1396: while ctr <= G_Line_Cache_Rec.count loop
1397:
1398: If G_line_cache_rec(ctr).operation = OE_GLOBALS.G_OPR_UPDATE then
1399: oe_debug_pub.add('Process_object for Lines update', 4);
1400: OE_Blanket_Util.Update_Row(G_line_Cache_Rec(ctr),x_return_status);
1401: ElsIf G_line_cache_rec(ctr).operation = OE_GLOBALS.G_OPR_CREATE then
1402: oe_debug_pub.add('Process_object for Lines Insert', 5);
1403: OE_Blanket_Util.Insert_Row(G_line_Cache_Rec(ctr),x_return_status);

Line 1402: oe_debug_pub.add('Process_object for Lines Insert', 5);

1398: If G_line_cache_rec(ctr).operation = OE_GLOBALS.G_OPR_UPDATE then
1399: oe_debug_pub.add('Process_object for Lines update', 4);
1400: OE_Blanket_Util.Update_Row(G_line_Cache_Rec(ctr),x_return_status);
1401: ElsIf G_line_cache_rec(ctr).operation = OE_GLOBALS.G_OPR_CREATE then
1402: oe_debug_pub.add('Process_object for Lines Insert', 5);
1403: OE_Blanket_Util.Insert_Row(G_line_Cache_Rec(ctr),x_return_status);
1404: -- hashraf ... start of pack J
1405: ElsIf G_line_cache_rec(ctr).operation = OE_GLOBALS.G_OPR_DELETE then
1406: oe_debug_pub.add('Process_object for Lines Delete', 6);

Line 1406: oe_debug_pub.add('Process_object for Lines Delete', 6);

1402: oe_debug_pub.add('Process_object for Lines Insert', 5);
1403: OE_Blanket_Util.Insert_Row(G_line_Cache_Rec(ctr),x_return_status);
1404: -- hashraf ... start of pack J
1405: ElsIf G_line_cache_rec(ctr).operation = OE_GLOBALS.G_OPR_DELETE then
1406: oe_debug_pub.add('Process_object for Lines Delete', 6);
1407: OE_Blanket_Util.Delete_Row(p_line_id => G_line_Cache_Rec(ctr).line_id, x_return_status => x_return_status);
1408: -- hashraf ... end of pack J
1409: End if;
1410:

Line 1446: oe_debug_pub.add(' oe_msg_pub.count_and_get x_msg_count'||x_msg_count);

1442: oe_msg_pub.count_and_get
1443: ( p_count => x_msg_count
1444: , p_data => x_msg_data);
1445:
1446: oe_debug_pub.add(' oe_msg_pub.count_and_get x_msg_count'||x_msg_count);
1447: oe_debug_pub.add(' oe_msg_pub.count_and_get x_msg_data'||x_msg_data);
1448: oe_debug_pub.add('Leaving from the Process Object OE_Blanket_Form_Control.Process_object ', 5);
1449:
1450: EXCEPTION

Line 1447: oe_debug_pub.add(' oe_msg_pub.count_and_get x_msg_data'||x_msg_data);

1443: ( p_count => x_msg_count
1444: , p_data => x_msg_data);
1445:
1446: oe_debug_pub.add(' oe_msg_pub.count_and_get x_msg_count'||x_msg_count);
1447: oe_debug_pub.add(' oe_msg_pub.count_and_get x_msg_data'||x_msg_data);
1448: oe_debug_pub.add('Leaving from the Process Object OE_Blanket_Form_Control.Process_object ', 5);
1449:
1450: EXCEPTION
1451: WHEN FND_API.G_EXC_ERROR THEN

Line 1448: oe_debug_pub.add('Leaving from the Process Object OE_Blanket_Form_Control.Process_object ', 5);

1444: , p_data => x_msg_data);
1445:
1446: oe_debug_pub.add(' oe_msg_pub.count_and_get x_msg_count'||x_msg_count);
1447: oe_debug_pub.add(' oe_msg_pub.count_and_get x_msg_data'||x_msg_data);
1448: oe_debug_pub.add('Leaving from the Process Object OE_Blanket_Form_Control.Process_object ', 5);
1449:
1450: EXCEPTION
1451: WHEN FND_API.G_EXC_ERROR THEN
1452: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1460: oe_debug_pub.add('Leaving the Process Object with excepted errors', 5);

1456: ( p_count => x_msg_count
1457: , p_data => x_msg_data
1458: );
1459: --for bug 3217764
1460: oe_debug_pub.add('Leaving the Process Object with excepted errors', 5);
1461: ROLLBACK TO SAVEPOINT Save_Blanket_Changes;
1462:
1463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1464:

Line 1473: oe_debug_pub.add('Leaving the Process Object with unexcepted errors', 5);

1469: ( p_count => x_msg_count
1470: , p_data => x_msg_data
1471: );
1472: --for bug 3217764
1473: oe_debug_pub.add('Leaving the Process Object with unexcepted errors', 5);
1474: ROLLBACK TO SAVEPOINT Save_Blanket_Changes;
1475:
1476: WHEN OTHERS THEN
1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1493: oe_debug_pub.add('Leaving the Process Object with other errors', 5);

1489: OE_MSG_PUB.Count_And_Get
1490: ( p_count => x_msg_count,
1491: p_data => x_msg_data);
1492: --for bug 3217764
1493: oe_debug_pub.add('Leaving the Process Object with other errors', 5);
1494: ROLLBACK TO SAVEPOINT Save_Blanket_Changes;
1495: END Process_Object;
1496:
1497:

Line 1516: oe_debug_pub.add('Entering oe_blanket_form_control.check_sec_header_attr');

1512: l_action number;
1513: l_rowtype_rec oe_ak_blanket_headers_v%rowtype;
1514: l_api_name CONSTANT VARCHAR2(30) := 'Check_Sec_Header_Attr';
1515: BEGIN
1516: oe_debug_pub.add('Entering oe_blanket_form_control.check_sec_header_attr');
1517: OE_MSG_PUB.initialize;
1518:
1519:
1520: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN

Line 1567: oe_debug_pub.add('Exiting oe_blanket_form_control.check_sec_header_attr');

1563: oe_msg_pub.count_and_get
1564: ( p_count => x_msg_count
1565: , p_data => x_msg_data);
1566:
1567: oe_debug_pub.add('Exiting oe_blanket_form_control.check_sec_header_attr');
1568: EXCEPTION
1569:
1570: WHEN FND_API.G_EXC_ERROR THEN
1571:

Line 1691: oe_debug_pub.add('Entering oe_blanket_form_control.check_sec_header_Entity');

1687: l_result NUMBER;
1688: l_api_name CONSTANT VARCHAR2(30) := 'Check_Sec_Header_Entity';
1689:
1690: BEGIN
1691: oe_debug_pub.add('Entering oe_blanket_form_control.check_sec_header_Entity');
1692: OE_MSG_PUB.initialize;
1693:
1694: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1695:

Line 1710: oe_debug_pub.add('Exiting oe_blanket_form_control.check_sec_header_Entity');

1706: oe_msg_pub.count_and_get
1707: ( p_count => x_msg_count
1708: , p_data => x_msg_data);
1709:
1710: oe_debug_pub.add('Exiting oe_blanket_form_control.check_sec_header_Entity');
1711: EXCEPTION
1712:
1713: WHEN FND_API.G_EXC_ERROR THEN
1714:

Line 1832: oe_debug_pub.add('Entering Update_Header_Cache OE_Blanket_Form_Control.Update_Header_Cache ', 0);

1828: found_flag varchar2(1);
1829: l_return_status varchar2(80);
1830: BEGIN
1831:
1832: oe_debug_pub.add('Entering Update_Header_Cache OE_Blanket_Form_Control.Update_Header_Cache ', 0);
1833:
1834: found_flag := 'N';
1835: ctr := 1;
1836:

Line 1838: oe_debug_pub.add('Update_Header_Cache is Zero ', 1);

1834: found_flag := 'N';
1835: ctr := 1;
1836:
1837: if G_Header_Cache_Rec.count = 0 then
1838: oe_debug_pub.add('Update_Header_Cache is Zero ', 1);
1839: if delete_flag <> 'Y' THEN
1840: G_Header_Cache_Rec(ctr) := p_x_header_rec;
1841: end if;
1842: else

Line 1843: oe_debug_pub.add('Update_Header_Cache is greater then Zero ', 2);

1839: if delete_flag <> 'Y' THEN
1840: G_Header_Cache_Rec(ctr) := p_x_header_rec;
1841: end if;
1842: else
1843: oe_debug_pub.add('Update_Header_Cache is greater then Zero ', 2);
1844: while ctr <= G_Header_Cache_Rec.count and found_flag = 'N' loop
1845: if G_Header_Cache_Rec(ctr).header_id = p_x_header_rec.header_id then
1846: found_flag := 'Y';
1847: else

Line 1865: oe_debug_pub.add('Update_Header_Cache is OE_Blanket_Form_Control.Update_Header_Cache ', 3);

1861: , p_delete_against => FALSE
1862: ,x_return_status => l_return_status);
1863: End if;
1864: Else
1865: oe_debug_pub.add('Update_Header_Cache is OE_Blanket_Form_Control.Update_Header_Cache ', 3);
1866: oe_debug_pub.add('Header Operation Code :'||p_x_header_rec.operation);
1867: G_Header_Cache_Rec(ctr) := p_x_header_rec;
1868: End if;
1869: oe_debug_pub.add('Exiting Update_Header_Cache OE_Blanket_Form_Control.Update_Header_Cache ', 4);

Line 1866: oe_debug_pub.add('Header Operation Code :'||p_x_header_rec.operation);

1862: ,x_return_status => l_return_status);
1863: End if;
1864: Else
1865: oe_debug_pub.add('Update_Header_Cache is OE_Blanket_Form_Control.Update_Header_Cache ', 3);
1866: oe_debug_pub.add('Header Operation Code :'||p_x_header_rec.operation);
1867: G_Header_Cache_Rec(ctr) := p_x_header_rec;
1868: End if;
1869: oe_debug_pub.add('Exiting Update_Header_Cache OE_Blanket_Form_Control.Update_Header_Cache ', 4);
1870:

Line 1869: oe_debug_pub.add('Exiting Update_Header_Cache OE_Blanket_Form_Control.Update_Header_Cache ', 4);

1865: oe_debug_pub.add('Update_Header_Cache is OE_Blanket_Form_Control.Update_Header_Cache ', 3);
1866: oe_debug_pub.add('Header Operation Code :'||p_x_header_rec.operation);
1867: G_Header_Cache_Rec(ctr) := p_x_header_rec;
1868: End if;
1869: oe_debug_pub.add('Exiting Update_Header_Cache OE_Blanket_Form_Control.Update_Header_Cache ', 4);
1870:
1871: END Update_Header_Cache;
1872:
1873:

Line 1885: oe_debug_pub.add('Entering Update_line_Cache OE_Blanket_Form_Control.Update_line_Cache ', 0);

1881: found_flag varchar2(1);
1882: l_return_status varchar2(80);
1883: BEGIN
1884:
1885: oe_debug_pub.add('Entering Update_line_Cache OE_Blanket_Form_Control.Update_line_Cache ', 0);
1886:
1887: found_flag := 'N';
1888: ctr := 1;
1889:

Line 1891: oe_debug_pub.add('Update_line_Cache is Zero ', 1);

1887: found_flag := 'N';
1888: ctr := 1;
1889:
1890: if G_Line_Cache_Rec.count = 0 then
1891: oe_debug_pub.add('Update_line_Cache is Zero ', 1);
1892: if delete_flag <> 'Y' then
1893: G_Line_Cache_Rec(ctr) := p_x_Line_rec;
1894: end if;
1895: else

Line 1896: oe_debug_pub.add('Update_line_Cache is greater then Zero ', 2);

1892: if delete_flag <> 'Y' then
1893: G_Line_Cache_Rec(ctr) := p_x_Line_rec;
1894: end if;
1895: else
1896: oe_debug_pub.add('Update_line_Cache is greater then Zero ', 2);
1897: while ctr <= G_Line_Cache_Rec.count and found_flag = 'N' loop
1898: if G_Line_Cache_Rec(ctr).Line_id = p_x_Line_rec.Line_id then
1899: found_flag := 'Y';
1900: else

Line 1921: oe_debug_pub.add('Line Operation Code :'||p_x_Line_rec.operation);

1917:
1918: G_Line_Cache_Rec(ctr) := NULL;
1919: End if;
1920: Else
1921: oe_debug_pub.add('Line Operation Code :'||p_x_Line_rec.operation);
1922: G_Line_Cache_Rec(ctr) := p_x_Line_rec;
1923: End if;
1924: oe_debug_pub.add('Exiting Update_line_Cache OE_Blanket_Form_Control.Update_line_Cache ', 4);
1925: END Update_Line_Cache;

Line 1924: oe_debug_pub.add('Exiting Update_line_Cache OE_Blanket_Form_Control.Update_line_Cache ', 4);

1920: Else
1921: oe_debug_pub.add('Line Operation Code :'||p_x_Line_rec.operation);
1922: G_Line_Cache_Rec(ctr) := p_x_Line_rec;
1923: End if;
1924: oe_debug_pub.add('Exiting Update_line_Cache OE_Blanket_Form_Control.Update_line_Cache ', 4);
1925: END Update_Line_Cache;
1926:
1927:
1928: ----------------------------------------------------------

Line 2280: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2276: (p_order_type_id IN NUMBER)
2277: RETURN varchar2
2278: IS
2279: l_order_type varchar2(240);
2280: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2281: Begin
2282: IF l_debug_level > 0 THEN
2283: oe_debug_pub.add('Entering OE_Blanket_Form_Control.Sales_Order_Type order Type Id : '||p_order_type_id);
2284: END IF;

Line 2283: oe_debug_pub.add('Entering OE_Blanket_Form_Control.Sales_Order_Type order Type Id : '||p_order_type_id);

2279: l_order_type varchar2(240);
2280: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2281: Begin
2282: IF l_debug_level > 0 THEN
2283: oe_debug_pub.add('Entering OE_Blanket_Form_Control.Sales_Order_Type order Type Id : '||p_order_type_id);
2284: END IF;
2285: select
2286: name into l_order_type
2287: from oe_transaction_types_vl

Line 2293: oe_debug_pub.add('Exiting OE_Blanket_Form_Control.Sales_Order_Type order type: '||l_order_type);

2289: AND transaction_type_id = p_order_type_id;
2290:
2291: return l_order_type;
2292: IF l_debug_level > 0 THEN
2293: oe_debug_pub.add('Exiting OE_Blanket_Form_Control.Sales_Order_Type order type: '||l_order_type);
2294: END IF;
2295:
2296: EXCEPTION
2297:

Line 2300: oe_debug_pub.add('IN NO_DATA_FOUND OE_Blanket_Form_Control.Sales_Order_Type for order type ID: '||p_order_type_id);

2296: EXCEPTION
2297:
2298: WHEN NO_DATA_FOUND THEN
2299: IF l_debug_level > 0 THEN
2300: oe_debug_pub.add('IN NO_DATA_FOUND OE_Blanket_Form_Control.Sales_Order_Type for order type ID: '||p_order_type_id);
2301: END IF;
2302:
2303: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2304: THEN

Line 2315: oe_debug_pub.add('IN OTEHRS OE_Blanket_Form_Control.Sales_Order_Type for order type ID: '||p_order_type_id);

2311: RETURN NULL;
2312:
2313: WHEN OTHERS THEN
2314: IF l_debug_level > 0 THEN
2315: oe_debug_pub.add('IN OTEHRS OE_Blanket_Form_Control.Sales_Order_Type for order type ID: '||p_order_type_id);
2316: END IF;
2317:
2318: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2319: THEN

Line 2415: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2411: (p_blanket_number IN number)
2412: RETURN varchar2
2413: IS
2414: l_return varchar2(10):= 'FALSE';
2415: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2416: Begin
2417:
2418: IF l_debug_level > 0 THEN
2419: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_header_release '||p_blanket_number);

Line 2419: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_header_release '||p_blanket_number);

2415: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2416: Begin
2417:
2418: IF l_debug_level > 0 THEN
2419: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_header_release '||p_blanket_number);
2420: END IF;
2421:
2422: if p_blanket_number is not null then
2423:

Line 2446: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_header_release ');

2442:
2443: end if;
2444:
2445: IF l_debug_level > 0 THEN
2446: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_header_release ');
2447: END IF;
2448:
2449: return l_return;
2450:

Line 2455: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_header_release WHEN no_data_found');

2451: EXCEPTION
2452:
2453: WHEN NO_DATA_FOUND THEN
2454:
2455: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_header_release WHEN no_data_found');
2456: RETURN l_return;
2457:
2458: WHEN OTHERS THEN
2459:

Line 2460: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_header_release WHEN OTEHRS');

2456: RETURN l_return;
2457:
2458: WHEN OTHERS THEN
2459:
2460: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_header_release WHEN OTEHRS');
2461: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2462: THEN
2463: OE_MSG_PUB.Add_Exc_Msg
2464: ( G_PKG_NAME

Line 2480: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2476: p_blanket_line_number in number)
2477: RETURN varchar2
2478: IS
2479: l_return varchar2(10):= 'FLASE';
2480: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2481: Begin
2482:
2483: IF l_debug_level > 0 THEN
2484: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_for_line_release '||p_blanket_number);

Line 2484: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_for_line_release '||p_blanket_number);

2480: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2481: Begin
2482:
2483: IF l_debug_level > 0 THEN
2484: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_for_line_release '||p_blanket_number);
2485: END IF;
2486:
2487: if p_blanket_number is not null then
2488:

Line 2499: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_for_line_release ');

2495:
2496: end if;
2497:
2498: IF l_debug_level > 0 THEN
2499: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_for_line_release ');
2500: END IF;
2501:
2502: return l_return;
2503:

Line 2508: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_for_line_release WHEN no_data_found');

2504: EXCEPTION
2505:
2506: WHEN NO_DATA_FOUND THEN
2507:
2508: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_for_line_release WHEN no_data_found');
2509: RETURN l_return;
2510:
2511: WHEN OTHERS THEN
2512:

Line 2513: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_for_line_release WHEN OTEHRS');

2509: RETURN l_return;
2510:
2511: WHEN OTHERS THEN
2512:
2513: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_for_line_release WHEN OTEHRS');
2514: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2515: THEN
2516: OE_MSG_PUB.Add_Exc_Msg
2517: ( G_PKG_NAME

Line 2554: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2550: p_version_number IN number)
2551: RETURN varchar2
2552: IS
2553: l_return varchar2(10):= 'FLASE';
2554: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2555: Begin
2556:
2557: IF l_debug_level > 0 THEN
2558: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_active_revision '||p_blanket_number);

Line 2558: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_active_revision '||p_blanket_number);

2554: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2555: Begin
2556:
2557: IF l_debug_level > 0 THEN
2558: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_active_revision '||p_blanket_number);
2559: END IF;
2560:
2561: if p_blanket_number is not null then
2562:

Line 2573: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_active_revision ');

2569:
2570: end if;
2571:
2572: IF l_debug_level > 0 THEN
2573: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_active_revision ');
2574: END IF;
2575:
2576: return l_return;
2577:

Line 2582: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_active_revision WHEN no_data_found');

2578: EXCEPTION
2579:
2580: WHEN NO_DATA_FOUND THEN
2581:
2582: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_active_revision WHEN no_data_found');
2583: RETURN l_return;
2584:
2585: WHEN OTHERS THEN
2586:

Line 2587: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_active_revision WHEN OTEHRS');

2583: RETURN l_return;
2584:
2585: WHEN OTHERS THEN
2586:
2587: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_active_revision WHEN OTEHRS');
2588: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2589: THEN
2590: OE_MSG_PUB.Add_Exc_Msg
2591: ( G_PKG_NAME

Line 2651: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2647: (p_order_type_id IN number)
2648: RETURN varchar2
2649: IS
2650: l_return varchar2(10);
2651: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2652: Begin
2653:
2654: IF l_debug_level > 0 THEN
2655: oe_debug_pub.add('IN OE_Blanket_Form_Control.get_trxt_phase_from_order_type '||p_order_type_id);

Line 2655: oe_debug_pub.add('IN OE_Blanket_Form_Control.get_trxt_phase_from_order_type '||p_order_type_id);

2651: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2652: Begin
2653:
2654: IF l_debug_level > 0 THEN
2655: oe_debug_pub.add('IN OE_Blanket_Form_Control.get_trxt_phase_from_order_type '||p_order_type_id);
2656: END IF;
2657:
2658: if p_order_type_id is not null then
2659:

Line 2669: oe_debug_pub.add('IN OE_Blanket_Form_Control.get_trxt_phas WHEN no_data_found');

2665: WHERE TRANSACTION_TYPE_ID = p_order_type_id;
2666: EXCEPTION
2667:
2668: WHEN NO_DATA_FOUND THEN
2669: oe_debug_pub.add('IN OE_Blanket_Form_Control.get_trxt_phas WHEN no_data_found');
2670: RETURN l_return;
2671: end;
2672:
2673: end if;

Line 2676: oe_debug_pub.add('IN OE_Blanket_Form_Control.get_trxt_phase_from_order_type ');

2672:
2673: end if;
2674:
2675: IF l_debug_level > 0 THEN
2676: oe_debug_pub.add('IN OE_Blanket_Form_Control.get_trxt_phase_from_order_type ');
2677: END IF;
2678:
2679: return l_return;
2680:

Line 2685: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_Submit_Draft_flag WHEN no_data_found');

2681: EXCEPTION
2682:
2683: WHEN NO_DATA_FOUND THEN
2684:
2685: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_Submit_Draft_flag WHEN no_data_found');
2686: RETURN l_return;
2687:
2688: WHEN OTHERS THEN
2689:

Line 2690: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_header_release WHEN OTEHRS');

2686: RETURN l_return;
2687:
2688: WHEN OTHERS THEN
2689:
2690: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_header_release WHEN OTEHRS');
2691: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2692: THEN
2693: OE_MSG_PUB.Add_Exc_Msg
2694: ( G_PKG_NAME