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_BLANKET_FORM_CONTROL

Line 1: PACKAGE BODY OE_Blanket_Form_Control AS

1: PACKAGE BODY OE_Blanket_Form_Control AS
2: /* $Header: OEXFBSOB.pls 120.5 2006/02/16 16:36:50 spagadal noship $ */
3:
4: -----------------------------------------------------------
5: -- Package Globals

Line 46: l_order_type := OE_Blanket_Form_Control.sales_order_type(p_header_rec.order_type_id);

42: l_header_rec.freight_terms_code := p_header_rec.freight_terms_code;
43: l_header_rec.payment_term_id := p_header_rec.payment_term_id;
44: -- hashraf pack J
45: l_header_rec.sold_to_site_use_id := p_header_rec.sold_to_site_use_id;
46: l_order_type := OE_Blanket_Form_Control.sales_order_type(p_header_rec.order_type_id);
47: p_header_val_rec := OE_Header_Util.Get_Values(p_header_rec => l_header_rec);
48: p_header_val_rec.order_type := l_order_type;
49: EXCEPTION
50:

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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

Line 2702: END OE_Blanket_Form_Control;

2698: RETURN l_return;
2699:
2700: end get_trxt_phase_from_order_type;
2701:
2702: END OE_Blanket_Form_Control;