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.6 2011/04/01 06:36:40 nilegupt ship $ */
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: --below if condition added for bug11841209
1835: IF TO_CHAR(p_x_header_rec.end_date_active,'HH24MISS') = '000000' THEN
1836:

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

Line 2713: END OE_Blanket_Form_Control;

2709: RETURN l_return;
2710:
2711: end get_trxt_phase_from_order_type;
2712:
2713: END OE_Blanket_Form_Control;