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: --below if condition added for bug11841209
1835: IF TO_CHAR(p_x_header_rec.end_date_active,'HH24MISS') = '000000' THEN
1836:

Line 1837: oe_debug_pub.add('nilegupt p_x_header_rec.end_date_active'||TO_CHAR(p_x_header_rec.end_date_active,'DD/MON/YYYY::HH24:MI:SS'));

1833:
1834: --below if condition added for bug11841209
1835: IF TO_CHAR(p_x_header_rec.end_date_active,'HH24MISS') = '000000' THEN
1836:
1837: oe_debug_pub.add('nilegupt p_x_header_rec.end_date_active'||TO_CHAR(p_x_header_rec.end_date_active,'DD/MON/YYYY::HH24:MI:SS'));
1838: p_x_header_rec.end_date_active :=
1839: trunc(p_x_header_rec.end_date_active,'DD') +
1840: ((24*60*60)-1)/(24*60*60);
1841:

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

1845: found_flag := 'N';
1846: ctr := 1;
1847:
1848: if G_Header_Cache_Rec.count = 0 then
1849: oe_debug_pub.add('Update_Header_Cache is Zero ', 1);
1850: if delete_flag <> 'Y' THEN
1851: G_Header_Cache_Rec(ctr) := p_x_header_rec;
1852: end if;
1853: else

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

1850: if delete_flag <> 'Y' THEN
1851: G_Header_Cache_Rec(ctr) := p_x_header_rec;
1852: end if;
1853: else
1854: oe_debug_pub.add('Update_Header_Cache is greater then Zero ', 2);
1855: while ctr <= G_Header_Cache_Rec.count and found_flag = 'N' loop
1856: if G_Header_Cache_Rec(ctr).header_id = p_x_header_rec.header_id then
1857: found_flag := 'Y';
1858: else

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

1872: , p_delete_against => FALSE
1873: ,x_return_status => l_return_status);
1874: End if;
1875: Else
1876: oe_debug_pub.add('Update_Header_Cache is OE_Blanket_Form_Control.Update_Header_Cache ', 3);
1877: oe_debug_pub.add('Header Operation Code :'||p_x_header_rec.operation);
1878: G_Header_Cache_Rec(ctr) := p_x_header_rec;
1879: End if;
1880: oe_debug_pub.add('Exiting Update_Header_Cache OE_Blanket_Form_Control.Update_Header_Cache ', 4);

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

1873: ,x_return_status => l_return_status);
1874: End if;
1875: Else
1876: oe_debug_pub.add('Update_Header_Cache is OE_Blanket_Form_Control.Update_Header_Cache ', 3);
1877: oe_debug_pub.add('Header Operation Code :'||p_x_header_rec.operation);
1878: G_Header_Cache_Rec(ctr) := p_x_header_rec;
1879: End if;
1880: oe_debug_pub.add('Exiting Update_Header_Cache OE_Blanket_Form_Control.Update_Header_Cache ', 4);
1881:

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

1876: oe_debug_pub.add('Update_Header_Cache is OE_Blanket_Form_Control.Update_Header_Cache ', 3);
1877: oe_debug_pub.add('Header Operation Code :'||p_x_header_rec.operation);
1878: G_Header_Cache_Rec(ctr) := p_x_header_rec;
1879: End if;
1880: oe_debug_pub.add('Exiting Update_Header_Cache OE_Blanket_Form_Control.Update_Header_Cache ', 4);
1881:
1882: END Update_Header_Cache;
1883:
1884:

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

1892: found_flag varchar2(1);
1893: l_return_status varchar2(80);
1894: BEGIN
1895:
1896: oe_debug_pub.add('Entering Update_line_Cache OE_Blanket_Form_Control.Update_line_Cache ', 0);
1897:
1898: found_flag := 'N';
1899: ctr := 1;
1900:

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

1898: found_flag := 'N';
1899: ctr := 1;
1900:
1901: if G_Line_Cache_Rec.count = 0 then
1902: oe_debug_pub.add('Update_line_Cache is Zero ', 1);
1903: if delete_flag <> 'Y' then
1904: G_Line_Cache_Rec(ctr) := p_x_Line_rec;
1905: end if;
1906: else

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

1903: if delete_flag <> 'Y' then
1904: G_Line_Cache_Rec(ctr) := p_x_Line_rec;
1905: end if;
1906: else
1907: oe_debug_pub.add('Update_line_Cache is greater then Zero ', 2);
1908: while ctr <= G_Line_Cache_Rec.count and found_flag = 'N' loop
1909: if G_Line_Cache_Rec(ctr).Line_id = p_x_Line_rec.Line_id then
1910: found_flag := 'Y';
1911: else

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

1928:
1929: G_Line_Cache_Rec(ctr) := NULL;
1930: End if;
1931: Else
1932: oe_debug_pub.add('Line Operation Code :'||p_x_Line_rec.operation);
1933: G_Line_Cache_Rec(ctr) := p_x_Line_rec;
1934: End if;
1935: oe_debug_pub.add('Exiting Update_line_Cache OE_Blanket_Form_Control.Update_line_Cache ', 4);
1936: END Update_Line_Cache;

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

1931: Else
1932: oe_debug_pub.add('Line Operation Code :'||p_x_Line_rec.operation);
1933: G_Line_Cache_Rec(ctr) := p_x_Line_rec;
1934: End if;
1935: oe_debug_pub.add('Exiting Update_line_Cache OE_Blanket_Form_Control.Update_line_Cache ', 4);
1936: END Update_Line_Cache;
1937:
1938:
1939: ----------------------------------------------------------

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

2287: (p_order_type_id IN NUMBER)
2288: RETURN varchar2
2289: IS
2290: l_order_type varchar2(240);
2291: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2292: Begin
2293: IF l_debug_level > 0 THEN
2294: oe_debug_pub.add('Entering OE_Blanket_Form_Control.Sales_Order_Type order Type Id : '||p_order_type_id);
2295: END IF;

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

2290: l_order_type varchar2(240);
2291: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2292: Begin
2293: IF l_debug_level > 0 THEN
2294: oe_debug_pub.add('Entering OE_Blanket_Form_Control.Sales_Order_Type order Type Id : '||p_order_type_id);
2295: END IF;
2296: select
2297: name into l_order_type
2298: from oe_transaction_types_vl

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

2300: AND transaction_type_id = p_order_type_id;
2301:
2302: return l_order_type;
2303: IF l_debug_level > 0 THEN
2304: oe_debug_pub.add('Exiting OE_Blanket_Form_Control.Sales_Order_Type order type: '||l_order_type);
2305: END IF;
2306:
2307: EXCEPTION
2308:

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

2307: EXCEPTION
2308:
2309: WHEN NO_DATA_FOUND THEN
2310: IF l_debug_level > 0 THEN
2311: oe_debug_pub.add('IN NO_DATA_FOUND OE_Blanket_Form_Control.Sales_Order_Type for order type ID: '||p_order_type_id);
2312: END IF;
2313:
2314: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2315: THEN

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

2322: RETURN NULL;
2323:
2324: WHEN OTHERS THEN
2325: IF l_debug_level > 0 THEN
2326: oe_debug_pub.add('IN OTEHRS OE_Blanket_Form_Control.Sales_Order_Type for order type ID: '||p_order_type_id);
2327: END IF;
2328:
2329: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2330: THEN

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

2422: (p_blanket_number IN number)
2423: RETURN varchar2
2424: IS
2425: l_return varchar2(10):= 'FALSE';
2426: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2427: Begin
2428:
2429: IF l_debug_level > 0 THEN
2430: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_header_release '||p_blanket_number);

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

2426: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2427: Begin
2428:
2429: IF l_debug_level > 0 THEN
2430: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_header_release '||p_blanket_number);
2431: END IF;
2432:
2433: if p_blanket_number is not null then
2434:

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

2453:
2454: end if;
2455:
2456: IF l_debug_level > 0 THEN
2457: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_header_release ');
2458: END IF;
2459:
2460: return l_return;
2461:

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

2462: EXCEPTION
2463:
2464: WHEN NO_DATA_FOUND THEN
2465:
2466: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_header_release WHEN no_data_found');
2467: RETURN l_return;
2468:
2469: WHEN OTHERS THEN
2470:

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

2467: RETURN l_return;
2468:
2469: WHEN OTHERS THEN
2470:
2471: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_header_release WHEN OTEHRS');
2472: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2473: THEN
2474: OE_MSG_PUB.Add_Exc_Msg
2475: ( G_PKG_NAME

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

2487: p_blanket_line_number in number)
2488: RETURN varchar2
2489: IS
2490: l_return varchar2(10):= 'FLASE';
2491: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2492: Begin
2493:
2494: IF l_debug_level > 0 THEN
2495: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_for_line_release '||p_blanket_number);

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

2491: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2492: Begin
2493:
2494: IF l_debug_level > 0 THEN
2495: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_for_line_release '||p_blanket_number);
2496: END IF;
2497:
2498: if p_blanket_number is not null then
2499:

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

2506:
2507: end if;
2508:
2509: IF l_debug_level > 0 THEN
2510: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_for_line_release ');
2511: END IF;
2512:
2513: return l_return;
2514:

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

2515: EXCEPTION
2516:
2517: WHEN NO_DATA_FOUND THEN
2518:
2519: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_for_line_release WHEN no_data_found');
2520: RETURN l_return;
2521:
2522: WHEN OTHERS THEN
2523:

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

2520: RETURN l_return;
2521:
2522: WHEN OTHERS THEN
2523:
2524: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_for_line_release WHEN OTEHRS');
2525: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2526: THEN
2527: OE_MSG_PUB.Add_Exc_Msg
2528: ( G_PKG_NAME

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

2561: p_version_number IN number)
2562: RETURN varchar2
2563: IS
2564: l_return varchar2(10):= 'FLASE';
2565: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2566: Begin
2567:
2568: IF l_debug_level > 0 THEN
2569: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_active_revision '||p_blanket_number);

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

2565: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2566: Begin
2567:
2568: IF l_debug_level > 0 THEN
2569: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_active_revision '||p_blanket_number);
2570: END IF;
2571:
2572: if p_blanket_number is not null then
2573:

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

2580:
2581: end if;
2582:
2583: IF l_debug_level > 0 THEN
2584: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_active_revision ');
2585: END IF;
2586:
2587: return l_return;
2588:

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

2589: EXCEPTION
2590:
2591: WHEN NO_DATA_FOUND THEN
2592:
2593: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_active_revision WHEN no_data_found');
2594: RETURN l_return;
2595:
2596: WHEN OTHERS THEN
2597:

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

2594: RETURN l_return;
2595:
2596: WHEN OTHERS THEN
2597:
2598: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_active_revision WHEN OTEHRS');
2599: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2600: THEN
2601: OE_MSG_PUB.Add_Exc_Msg
2602: ( G_PKG_NAME

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

2658: (p_order_type_id IN number)
2659: RETURN varchar2
2660: IS
2661: l_return varchar2(10);
2662: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2663: Begin
2664:
2665: IF l_debug_level > 0 THEN
2666: oe_debug_pub.add('IN OE_Blanket_Form_Control.get_trxt_phase_from_order_type '||p_order_type_id);

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

2662: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2663: Begin
2664:
2665: IF l_debug_level > 0 THEN
2666: oe_debug_pub.add('IN OE_Blanket_Form_Control.get_trxt_phase_from_order_type '||p_order_type_id);
2667: END IF;
2668:
2669: if p_order_type_id is not null then
2670:

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

2676: WHERE TRANSACTION_TYPE_ID = p_order_type_id;
2677: EXCEPTION
2678:
2679: WHEN NO_DATA_FOUND THEN
2680: oe_debug_pub.add('IN OE_Blanket_Form_Control.get_trxt_phas WHEN no_data_found');
2681: RETURN l_return;
2682: end;
2683:
2684: end if;

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

2683:
2684: end if;
2685:
2686: IF l_debug_level > 0 THEN
2687: oe_debug_pub.add('IN OE_Blanket_Form_Control.get_trxt_phase_from_order_type ');
2688: END IF;
2689:
2690: return l_return;
2691:

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

2692: EXCEPTION
2693:
2694: WHEN NO_DATA_FOUND THEN
2695:
2696: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_Submit_Draft_flag WHEN no_data_found');
2697: RETURN l_return;
2698:
2699: WHEN OTHERS THEN
2700:

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

2697: RETURN l_return;
2698:
2699: WHEN OTHERS THEN
2700:
2701: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_header_release WHEN OTEHRS');
2702: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2703: THEN
2704: OE_MSG_PUB.Add_Exc_Msg
2705: ( G_PKG_NAME