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.

[Home] [Help]

APPS.OE_ORDER_UTIL dependencies on OE_ORDER_UTIL

Line 1: PACKAGE BODY OE_ORDER_UTIL AS

1: PACKAGE BODY OE_ORDER_UTIL AS
2: /* $Header: OEXUORDB.pls 120.10.12020000.3 2013/01/04 04:37:50 slagiset ship $ */
3:
4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_ORDER_UTIL';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_ORDER_UTIL';

1: PACKAGE BODY OE_ORDER_UTIL AS
2: /* $Header: OEXUORDB.pls 120.10.12020000.3 2013/01/04 04:37:50 slagiset ship $ */
3:
4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_ORDER_UTIL';
6:
7: /*lchen*/
8: -- Constants added for notification framework
9: G_MAX_REQUESTS NUMBER := 10000;

Line 202: oe_debug_pub.add( 'ENTERING OE_ORDER_UTIL.UPDATE_GLOBAL_PICTURE' , 1 ) ;

198: BEGIN
199: x_return_status := FND_API.G_RET_STS_SUCCESS;
200:
201: IF l_debug_level > 0 THEN
202: oe_debug_pub.add( 'ENTERING OE_ORDER_UTIL.UPDATE_GLOBAL_PICTURE' , 1 ) ;
203: END IF;
204:
205: /* The global entities will be populated for booked orders */
206: /* coming in via Process Order or for entered orders via the GUI */

Line 789: oe_debug_pub.add( 'EXITING OE_ORDER_UTIL.UPDATE_GLOBAL_PICTURE' , 1 ) ;

785:
786: END IF; -- lot_serial_id is not null
787:
788: IF l_debug_level > 0 THEN
789: oe_debug_pub.add( 'EXITING OE_ORDER_UTIL.UPDATE_GLOBAL_PICTURE' , 1 ) ;
790: END IF;
791:
792: END IF; /* check for booked flag or g_ui_flag */
793: END IF; /* check for code set level*/

Line 841: oe_debug_pub.add( 'ENTERING OE_ORDER_UTIL.RETURN_GLB_ENT_INDEX' , 1 ) ;

837: l_ind := (mod(p_entity_id,100000) * G_MAX_REQUESTS)+1;
838: l_max_ind := l_ind + G_MAX_REQUESTS - 1;
839:
840: IF l_debug_level > 0 THEN
841: oe_debug_pub.add( 'ENTERING OE_ORDER_UTIL.RETURN_GLB_ENT_INDEX' , 1 ) ;
842: END IF;
843:
844: IF p_entity_code = OE_GLOBALS.G_ENTITY_LINE THEN
845:

Line 1006: oe_debug_pub.add( 'EXITING OE_ORDER_UTIL.RETURN_GLB_ENT_INDEX' , 1 ) ;

1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1003: END IF;
1004:
1005: IF l_debug_level > 0 THEN
1006: oe_debug_pub.add( 'EXITING OE_ORDER_UTIL.RETURN_GLB_ENT_INDEX' , 1 ) ;
1007: END IF;
1008:
1009: EXCEPTION
1010:

Line 1077: oe_debug_pub.add( 'ENTERING OE_ORDER_UTIL.INITIALIZE_ACCESS_LIST' , 1 ) ;

1073: l_is_xdo_licensed varchar2(1);
1074:
1075: BEGIN
1076: IF l_debug_level > 0 THEN
1077: oe_debug_pub.add( 'ENTERING OE_ORDER_UTIL.INITIALIZE_ACCESS_LIST' , 1 ) ;
1078: END IF;
1079: IF FND_FUNCTION.TEST('ONT_OEXOEORD_APPLY_HOLDS') THEN
1080: Add_Access('APPLY_HOLDS');
1081: END IF;

Line 1229: OE_ORDER_UTIL.G_Access_List_Initialized:='Y';

1225: Add_Access('FULFILLMENT_ACCEPTANCE');
1226: END IF;
1227:
1228:
1229: OE_ORDER_UTIL.G_Access_List_Initialized:='Y';
1230: IF l_debug_level > 0 THEN
1231: oe_debug_pub.add( 'EXITING OE_ORDER_UTIL.INITIALIZE_ACCESS_LIST' , 1 ) ;
1232: END IF;
1233:

Line 1231: oe_debug_pub.add( 'EXITING OE_ORDER_UTIL.INITIALIZE_ACCESS_LIST' , 1 ) ;

1227:
1228:
1229: OE_ORDER_UTIL.G_Access_List_Initialized:='Y';
1230: IF l_debug_level > 0 THEN
1231: oe_debug_pub.add( 'EXITING OE_ORDER_UTIL.INITIALIZE_ACCESS_LIST' , 1 ) ;
1232: END IF;
1233:
1234: END Initialize_Access_List;
1235:

Line 1244: oe_debug_pub.add( 'ENTERING OE_ORDER_UTIL.ADD_ACCESS' , 1 ) ;

1240: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1241: --
1242: BEGIN
1243: IF l_debug_level > 0 THEN
1244: oe_debug_pub.add( 'ENTERING OE_ORDER_UTIL.ADD_ACCESS' , 1 ) ;
1245: END IF;
1246: IF OE_GLOBALS.G_ACCESS_List.Count=0 THEN
1247: OE_GLOBALS.G_Access_List(1):=Function_Name;
1248: ELSIF OE_GLOBALS.G_ACCESS_List.Count>0 THEN

Line 1253: oe_debug_pub.add( 'EXITING OE_ORDER_UTIL.ADD_ACCESS' , 1 ) ;

1249: i:=OE_GLOBALS.G_ACCESS_List.Last+1;
1250: OE_GLOBALS.G_ACCESS_List(i):=Function_Name;
1251: END IF;
1252: IF l_debug_level > 0 THEN
1253: oe_debug_pub.add( 'EXITING OE_ORDER_UTIL.ADD_ACCESS' , 1 ) ;
1254: END IF;
1255: EXCEPTION
1256: When Others Then
1257: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1280: oe_debug_pub.add( 'ENTERING OE_ORDER_UTIL.IS_ACTION_IN_ACCESS_LIST' , 1 ) ;

1276: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1277: --
1278: BEGIN
1279: IF l_debug_level > 0 THEN
1280: oe_debug_pub.add( 'ENTERING OE_ORDER_UTIL.IS_ACTION_IN_ACCESS_LIST' , 1 ) ;
1281: END IF;
1282: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >='110508' THEN
1283: IF OE_ORDER_UTIL.G_Access_List_Initialized IS NULL THEN
1284: Initialize_Access_List;

Line 1283: IF OE_ORDER_UTIL.G_Access_List_Initialized IS NULL THEN

1279: IF l_debug_level > 0 THEN
1280: oe_debug_pub.add( 'ENTERING OE_ORDER_UTIL.IS_ACTION_IN_ACCESS_LIST' , 1 ) ;
1281: END IF;
1282: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >='110508' THEN
1283: IF OE_ORDER_UTIL.G_Access_List_Initialized IS NULL THEN
1284: Initialize_Access_List;
1285: END IF;
1286:
1287: rg_count:=OE_GLOBALS.G_ACCESS_List.Last;

Line 1302: oe_debug_pub.add( 'EXITING OE_ORDER_UTIL.IS_ACTION_IN_ACCESS_LIST' , 1 ) ;

1298: ELSE
1299: Return(True);
1300: END IF;
1301: IF l_debug_level > 0 THEN
1302: oe_debug_pub.add( 'EXITING OE_ORDER_UTIL.IS_ACTION_IN_ACCESS_LIST' , 1 ) ;
1303: END IF;
1304: RAISE Exit_Function;
1305: EXCEPTION
1306: When Exit_Function Then

Line 1350: IF (NVL(g_header_id,-1) = p_header_id) AND (OE_ORDER_UTIL.G_Precision IS NOT NULL) THEN

1346:
1347: IF p_currency_code IS NULL AND p_header_id IS NOT NULL THEN
1348: --Initially g_header_id is null and G_Precision is null and during next calls these values will exists and it returns TRUE
1349: --Start of bug12616480
1350: IF (NVL(g_header_id,-1) = p_header_id) AND (OE_ORDER_UTIL.G_Precision IS NOT NULL) THEN
1351: RETURN(TRUE);
1352: END IF;
1353: --End of bug12616480
1354: SELECT TRANSACTIONAL_CURR_CODE

Line 1361: IF (NVL(G_line_id,-1) = p_line_id) AND (OE_ORDER_UTIL.G_Precision IS NOT NULL) THEN

1357: WHERE HEADER_ID=p_header_id;
1358: ELSIF p_header_id IS NULL AND p_currency_code IS NULL AND p_line_id IS NOT NULL THEN
1359: --Initially g_line_id is null and G_Precision is null and during next calls these values will exists and it returns TRUE
1360: --Start of bug12616480
1361: IF (NVL(G_line_id,-1) = p_line_id) AND (OE_ORDER_UTIL.G_Precision IS NOT NULL) THEN
1362: RETURN(TRUE);
1363: END IF;
1364: --End of bug12616480
1365: SELECT /*MOAC_SQL_CHANGES*/ OH.TRANSACTIONAL_CURR_CODE

Line 1374: IF (NVL(oe_order_util.g_header_rec.transactional_curr_code,'-1') = NVL(l_currency_code,'-10')) AND (OE_ORDER_UTIL.G_Precision IS NOT NULL) THEN

1370: ELSIF p_currency_code IS NOT NULL THEN
1371: l_currency_code:=p_currency_code;
1372: END IF;
1373: --Start of bug12616480
1374: IF (NVL(oe_order_util.g_header_rec.transactional_curr_code,'-1') = NVL(l_currency_code,'-10')) AND (OE_ORDER_UTIL.G_Precision IS NOT NULL) THEN
1375: RETURN(TRUE);
1376: END IF;
1377: --End of bug12616480
1378:

Line 1390: OE_ORDER_UTIL.G_Precision := l_precision;

1386: l_ext_precision,
1387: l_min_acct_unit
1388: );
1389: -- #2713025
1390: OE_ORDER_UTIL.G_Precision := l_precision;
1391: G_Header_Id:=p_header_id;
1392: G_line_id:=p_line_id;
1393: Return(TRUE);
1394: ELSE

Line 1396: OE_ORDER_UTIL.G_Precision := l_precision;

1392: G_line_id:=p_line_id;
1393: Return(TRUE);
1394: ELSE
1395: l_precision:=2;
1396: OE_ORDER_UTIL.G_Precision := l_precision;
1397: G_Header_Id:=p_header_id;
1398: G_line_id:=p_line_id;
1399: Return(TRUE);
1400: END IF;

Line 1437: oe_debug_pub.add('Entering Oe_order_Util.Raise_Business_Event header='

1433: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1434: BEGIN
1435: l_count := p_nameVal_tbl.COUNT;
1436: IF l_debug_level > 0 THEN
1437: oe_debug_pub.add('Entering Oe_order_Util.Raise_Business_Event header='
1438: || p_header_id || ' status=' || p_status || ' line=' || p_line_id);
1439: oe_debug_pub.add('Number of rows coming in nameVal table is '||l_count);
1440:
1441: END IF;

Line 1487: oe_debug_pub.add('Exiting Oe_order_Util.Raise_Business_Event header');

1483: END IF;
1484:
1485:
1486: end if;
1487: oe_debug_pub.add('Exiting Oe_order_Util.Raise_Business_Event header');
1488: End RAISE_BUSINESS_EVENT;
1489:
1490: -- 13633317
1491: FUNCTION GET_GLOBAL_OLD_HEADER_ID

Line 1495: RETURN OE_ORDER_UTIL.G_OLD_HEADER_REC.HEADER_ID;

1491: FUNCTION GET_GLOBAL_OLD_HEADER_ID
1492: RETURN NUMBER
1493: IS
1494: BEGIN
1495: RETURN OE_ORDER_UTIL.G_OLD_HEADER_REC.HEADER_ID;
1496: END GET_GLOBAL_OLD_HEADER_ID;
1497:
1498: END OE_ORDER_UTIL;

Line 1498: END OE_ORDER_UTIL;

1494: BEGIN
1495: RETURN OE_ORDER_UTIL.G_OLD_HEADER_REC.HEADER_ID;
1496: END GET_GLOBAL_OLD_HEADER_ID;
1497:
1498: END OE_ORDER_UTIL;