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_BULK_CONFIG_UTIL dependencies on OE_BULK_CONFIG_UTIL

Line 1: PACKAGE BODY OE_BULK_CONFIG_UTIL AS

1: PACKAGE BODY OE_BULK_CONFIG_UTIL AS
2: /* $Header: OEBUCFGB.pls 120.0.12010000.4 2008/11/26 01:55:09 smusanna noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_BULK_CONFIG_UTIL';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_BULK_CONFIG_UTIL';

1: PACKAGE BODY OE_BULK_CONFIG_UTIL AS
2: /* $Header: OEBUCFGB.pls 120.0.12010000.4 2008/11/26 01:55:09 smusanna noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_BULK_CONFIG_UTIL';
5:
6:
7: /* -----------------------------------------------------------
8: --

Line 17: ,p_config_rec IN OUT NOCOPY OE_BULK_CONFIG_UTIL.CONFIG_REC_TYPE

13:
14: PROCEDURE Extend_Line_Rec
15: (p_count IN NUMBER
16: ,p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
17: ,p_config_rec IN OUT NOCOPY OE_BULK_CONFIG_UTIL.CONFIG_REC_TYPE
18: )
19: IS
20: --
21: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 26: oe_debug_pub.add( 'ENTERING OE_BULK_CONFIG_UTIL.Extend_Line_Rec ') ;

22: --
23: BEGIN
24:
25: IF l_debug_level > 0 THEN
26: oe_debug_pub.add( 'ENTERING OE_BULK_CONFIG_UTIL.Extend_Line_Rec ') ;
27: END IF;
28:
29: p_line_rec.ATO_LINE_ID.extend(p_count - p_line_rec.ATO_LINE_ID.count);
30: p_line_rec.BOOKED_FLAG.extend(p_count - p_line_rec.BOOKED_FLAG.count);

Line 75: oe_debug_pub.add( 'EXITING OE_BULK_CONFIG_UTIL.Extend_Line_Rec ') ;

71: p_config_rec.bom_item_type.extend(p_count - p_config_rec.bom_item_type.count );
72: p_config_rec.replenish_to_order_flag.extend(p_count - p_config_rec.replenish_to_order_flag.count );
73:
74: IF l_debug_level > 0 THEN
75: oe_debug_pub.add( 'EXITING OE_BULK_CONFIG_UTIL.Extend_Line_Rec ') ;
76: END IF;
77:
78:
79: EXCEPTION

Line 95: ,p_config_rec IN OE_BULK_CONFIG_UTIL.CONFIG_REC_TYPE

91:
92:
93: PROCEDURE Print_Line_Rec
94: ( p_line_rec IN OE_WSH_BULK_GRP.LINE_REC_TYPE
95: ,p_config_rec IN OE_BULK_CONFIG_UTIL.CONFIG_REC_TYPE
96: )
97: IS
98: --
99: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 104: oe_debug_pub.add( 'ENTERING OE_BULK_CONFIG_UTIL.Print_Line_Rec ') ;

100: --
101: BEGIN
102:
103: IF l_debug_level > 0 THEN
104: oe_debug_pub.add( 'ENTERING OE_BULK_CONFIG_UTIL.Print_Line_Rec ') ;
105: END IF;
106:
107:
108: IF l_debug_level > 0 THEN

Line 163: oe_debug_pub.add( 'EXITING OE_BULK_CONFIG_UTIL.Print_Line_Rec ') ;

159: END LOOP;
160: END IF;
161:
162: IF l_debug_level > 0 THEN
163: oe_debug_pub.add( 'EXITING OE_BULK_CONFIG_UTIL.Print_Line_Rec ') ;
164: END IF;
165:
166:
167: EXCEPTION

Line 184: l_config_rec OE_BULK_CONFIG_UTIL.CONFIG_REC_TYPE;

180: PROCEDURE Print_Line_Rec
181: ( p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE )
182: IS
183:
184: l_config_rec OE_BULK_CONFIG_UTIL.CONFIG_REC_TYPE;
185:
186: BEGIN
187:
188: Extend_Line_Rec( p_count => p_line_rec.line_id.count,

Line 227: oe_debug_pub.add( 'ENTERING OE_BULK_CONFIG_UTIL.Message_From_Cz ') ;

223:
224: BEGIN
225:
226: IF l_debug_level > 0 THEN
227: oe_debug_pub.add( 'ENTERING OE_BULK_CONFIG_UTIL.Message_From_Cz ') ;
228: END IF;
229: x_return_status := FND_API.G_RET_STS_SUCCESS;
230:
231: OPEN messages(l_config_header_id, l_config_rev_nbr);

Line 263: oe_debug_pub.add( 'EXITING OE_BULK_CONFIG_UTIL.Message_From_Cz ') ;

259:
260: END IF;
261:
262: IF l_debug_level > 0 THEN
263: oe_debug_pub.add( 'EXITING OE_BULK_CONFIG_UTIL.Message_From_Cz ') ;
264: END IF;
265:
266:
267: EXCEPTION

Line 425: oe_debug_pub.add('ENTERING OE_BULK_CONFIG_UTIL.CREATE_HDR_XML' , 1);

421: --
422: BEGIN
423:
424: IF l_debug_level > 0 THEN
425: oe_debug_pub.add('ENTERING OE_BULK_CONFIG_UTIL.CREATE_HDR_XML' , 1);
426: END IF;
427:
428: -- now set the values from model_rec and org_id
429: l_context_org_id := OE_BULK_ORDER_PVT.G_ITEM_ORG;

Line 505: OE_Bulk_Config_Util.Get_Config_Effective_Date

501: ELSE
502: param_value(18) := 'FALSE';
503: END IF;
504:
505: OE_Bulk_Config_Util.Get_Config_Effective_Date
506: ( p_book_flag => p_line_rec.booked_flag(p_line_index)
507: ,x_old_behavior => l_old_behavior
508: ,x_config_effective_date => l_config_effective_date
509: ,x_return_status => l_return_status);

Line 647: oe_debug_pub.add('ENTERING OE_BULK_CONFIG_UTIL.SEND_INPUT_XML' , 1);

643: --
644: BEGIN
645:
646: IF l_debug_level > 0 THEN
647: oe_debug_pub.add('ENTERING OE_BULK_CONFIG_UTIL.SEND_INPUT_XML' , 1);
648: oe_debug_pub.add('UIMANAGER URL: ' || L_URL , 2 );
649: END IF;
650: x_return_status := FND_API.G_RET_STS_SUCCESS;
651:

Line 757: oe_debug_pub.add('EXITING OE_BULK_CONFIG_UTIL.SEND_INPUT_XML' , 1);

753: -- if everything ok, set out values
754: x_out_xml_msg := l_long_xml;
755:
756: IF l_debug_level > 0 THEN
757: oe_debug_pub.add('EXITING OE_BULK_CONFIG_UTIL.SEND_INPUT_XML' , 1);
758: END IF;
759:
760: EXCEPTION
761: WHEN FND_API.G_EXC_ERROR THEN

Line 1055: oe_debug_pub.add('EXITING OE_BULK_CONFIG_UTIL.PARSE_OUTPUT_XML' , 1);

1051: x_valid_config := nvl(l_valid_config, 'FALSE');
1052:
1053:
1054: IF l_debug_level > 0 THEN
1055: oe_debug_pub.add('EXITING OE_BULK_CONFIG_UTIL.PARSE_OUTPUT_XML' , 1);
1056: END IF;
1057:
1058: EXCEPTION
1059: WHEN FND_API.G_EXC_ERROR THEN

Line 1106: oe_debug_pub.add( 'ENTERING OE_BULK_CONFIG_UTIL.Validate_Config_Attributes ') ;

1102: l_attribute VARCHAR2(30);
1103:
1104: BEGIN
1105: IF l_debug_level > 0 THEN
1106: oe_debug_pub.add( 'ENTERING OE_BULK_CONFIG_UTIL.Validate_Config_Attributes ') ;
1107: END IF;
1108:
1109: -- Validate Required Attributes
1110: IF nvl(p_use_configurator, 'N') = 'Y' THEN

Line 1200: oe_debug_pub.add( 'EXITING OE_BULK_CONFIG_UTIL.Validate_Config_Attributes ') ;

1196:
1197: END IF; -- Use configurator
1198:
1199: IF l_debug_level > 0 THEN
1200: oe_debug_pub.add( 'EXITING OE_BULK_CONFIG_UTIL.Validate_Config_Attributes ') ;
1201: END IF;
1202:
1203: EXCEPTION
1204: WHEN FND_API.G_EXC_ERROR THEN

Line 1207: oe_debug_pub.add('AN EXC ERROR RAISED IN OE_BULK_CONFIG_UTIL.Validate_Config_Attributes', 1);

1203: EXCEPTION
1204: WHEN FND_API.G_EXC_ERROR THEN
1205: p_line_rec.lock_control(p_line_index) := -99;
1206: IF l_debug_level > 0 THEN
1207: oe_debug_pub.add('AN EXC ERROR RAISED IN OE_BULK_CONFIG_UTIL.Validate_Config_Attributes', 1);
1208: END IF;
1209:
1210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1211: IF l_debug_level > 0 THEN

Line 1249: oe_debug_pub.add( 'ENTERING OE_BULK_CONFIG_UTIL.Load_Item_Attributes ') ;

1245: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1246:
1247: BEGIN
1248: IF l_debug_level > 0 THEN
1249: oe_debug_pub.add( 'ENTERING OE_BULK_CONFIG_UTIL.Load_Item_Attributes ') ;
1250: END IF;
1251:
1252: -- Load item cache and Get the index
1253: -- l_index := OE_Bulk_Cache.Load_Item(l_line_rec.inventory_item_id(p_index),

Line 1302: oe_debug_pub.add( 'EXITING OE_BULK_CONFIG_UTIL.Load_Item_Attributes ') ;

1298: END IF;
1299:
1300:
1301: IF l_debug_level > 0 THEN
1302: oe_debug_pub.add( 'EXITING OE_BULK_CONFIG_UTIL.Load_Item_Attributes ') ;
1303: END IF;
1304:
1305: EXCEPTION
1306:

Line 1372: oe_debug_pub.add( 'ENTERING OE_BULK_CONFIG_UTIL.Validate_Configuration ') ;

1368:
1369: BEGIN
1370:
1371: IF l_debug_level > 0 THEN
1372: oe_debug_pub.add( 'ENTERING OE_BULK_CONFIG_UTIL.Validate_Configuration ') ;
1373: END IF;
1374:
1375: l_book_flag := p_line_rec.booked_flag(p_line_index);
1376: l_qty_match_flag := p_line_rec.cz_qty_match_flag(p_line_index);

Line 1575: oe_debug_pub.add('EXITING OE_BULK_CONFIG_UTIL.CONFIGURATOR_VALIDATION' , 1);

1571: END IF; -- if skip batch val
1572:
1573:
1574: IF l_debug_level > 0 THEN
1575: oe_debug_pub.add('EXITING OE_BULK_CONFIG_UTIL.CONFIGURATOR_VALIDATION' , 1);
1576: END IF;
1577:
1578:
1579: EXCEPTION

Line 1591: oe_debug_pub.add('Others Error, OE_BULK_CONFIG_UTIL.Validate_Configuration');

1587: p_line_rec.lock_control(p_line_index) := -99;
1588:
1589: WHEN OTHERS THEN
1590: IF l_debug_level > 0 THEN
1591: oe_debug_pub.add('Others Error, OE_BULK_CONFIG_UTIL.Validate_Configuration');
1592: oe_debug_pub.add(substr(sqlerrm,1,240));
1593: END IF;
1594:
1595: OE_BULK_MSG_PUB.Add_Exc_Msg

Line 1690: l_config_rec OE_BULK_CONFIG_UTIL.CONFIG_REC_TYPE;

1686: AND l.top_model_line_ref = l.orig_sys_line_ref;
1687:
1688:
1689: l_line_rec OE_WSH_BULK_GRP.LINE_REC_TYPE;
1690: l_config_rec OE_BULK_CONFIG_UTIL.CONFIG_REC_TYPE;
1691: I NUMBER;
1692:
1693: l_Need_Bom_Explosion VARCHAR2(1) := 'N';
1694:

Line 1708: oe_debug_pub.add( 'ENTERING OE_BULK_CONFIG_UTIL.Pre_Process_Configurator ') ;

1704:
1705:
1706: BEGIN
1707: IF l_debug_level > 0 THEN
1708: oe_debug_pub.add( 'ENTERING OE_BULK_CONFIG_UTIL.Pre_Process_Configurator ') ;
1709: END IF;
1710:
1711: -- Load the cursor into l_line_rec
1712: IF nvl(p_validate_configurations, 'N') = 'Y' THEN

Line 2073: oe_debug_pub.add( 'EXITING OE_BULK_CONFIG_UTIL.Pre_Process_Configurator ') ;

2069:
2070: END IF;
2071:
2072: IF l_debug_level > 0 THEN
2073: oe_debug_pub.add( 'EXITING OE_BULK_CONFIG_UTIL.Pre_Process_Configurator ') ;
2074: END IF;
2075:
2076: EXCEPTION
2077: WHEN NO_DATA_FOUND THEN

Line 2079: oe_debug_pub.add('NO DATA FOUND in OE_BULK_CONFIG_UTIL.Pre_Process_Configurator ' , 1);

2075:
2076: EXCEPTION
2077: WHEN NO_DATA_FOUND THEN
2078: IF l_debug_level > 0 THEN
2079: oe_debug_pub.add('NO DATA FOUND in OE_BULK_CONFIG_UTIL.Pre_Process_Configurator ' , 1);
2080: END IF;
2081:
2082: WHEN OTHERS THEN
2083:

Line 2091: oe_debug_pub.add('Others Error, OE_BULK_CONFIG_UTIL.Pre_Process_Configurator');

2087: CLOSE c_line_config2;
2088: END IF;
2089:
2090: IF l_debug_level > 0 THEN
2091: oe_debug_pub.add('Others Error, OE_BULK_CONFIG_UTIL.Pre_Process_Configurator');
2092: oe_debug_pub.add(substr(sqlerrm,1,240));
2093: END IF;
2094:
2095: OE_BULK_MSG_PUB.Add_Exc_Msg

Line 2212: l_config_rec OE_BULK_CONFIG_UTIL.CONFIG_REC_TYPE;

2208: decode(item_type_code,'MODEL',item_type_code,'XXX'),
2209: l.component_code;
2210:
2211: l_line_rec OE_WSH_BULK_GRP.LINE_REC_TYPE;
2212: l_config_rec OE_BULK_CONFIG_UTIL.CONFIG_REC_TYPE;
2213: I NUMBER;
2214: l_curr_model_index NUMBER;
2215: l_curr_ato_index NUMBER;
2216:

Line 2234: oe_debug_pub.add( 'ENTERING OE_BULK_CONFIG_UTIL.Pre_Process_Bom ', 1) ;

2230:
2231:
2232: BEGIN
2233: IF l_debug_level > 0 THEN
2234: oe_debug_pub.add( 'ENTERING OE_BULK_CONFIG_UTIL.Pre_Process_Bom ', 1) ;
2235: END IF;
2236:
2237: -----------------------------------------------------------------
2238: -- Load this cursor into Line Rec (OE_WSH_BULK_GRP.line_rec_type)

Line 2925: oe_debug_pub.add( 'EXITING OE_BULK_CONFIG_UTIL.Pre_Process_Bom ', 1) ;

2921: END IF; -- Use Configutor
2922:
2923:
2924: IF l_debug_level > 0 THEN
2925: oe_debug_pub.add( 'EXITING OE_BULK_CONFIG_UTIL.Pre_Process_Bom ', 1) ;
2926: END IF;
2927:
2928: EXCEPTION
2929:

Line 2932: oe_debug_pub.add('NO DATA FOUND in OE_BULK_CONFIG_UTIL.Pre_Process_Bom ' , 1);

2928: EXCEPTION
2929:
2930: WHEN NO_DATA_FOUND THEN
2931: IF l_debug_level > 0 THEN
2932: oe_debug_pub.add('NO DATA FOUND in OE_BULK_CONFIG_UTIL.Pre_Process_Bom ' , 1);
2933: END IF;
2934:
2935: WHEN OTHERS THEN
2936:

Line 2944: oe_debug_pub.add('Others Error, OE_BULK_CONFIG_UTIL.Pre_Process_Bom');

2940: CLOSE c_line_bom2;
2941: END IF;
2942:
2943: IF l_debug_level > 0 THEN
2944: oe_debug_pub.add('Others Error, OE_BULK_CONFIG_UTIL.Pre_Process_Bom');
2945: oe_debug_pub.add(substr(sqlerrm,1,240));
2946: END IF;
2947:
2948: OE_BULK_MSG_PUB.Add_Exc_Msg

Line 2979: oe_debug_pub.add( 'ENTERING OE_BULK_CONFIG_UTIL.Pre_Process ') ;

2975: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2976:
2977: BEGIN
2978: IF l_debug_level > 0 THEN
2979: oe_debug_pub.add( 'ENTERING OE_BULK_CONFIG_UTIL.Pre_Process ') ;
2980: oe_debug_pub.add( ' Use Configurator :'|| p_use_configurator );
2981: END IF;
2982:
2983: IF nvl(p_use_configurator, 'N') = 'Y' THEN

Line 3107: oe_debug_pub.add( 'EXITING OE_BULK_CONFIG_UTIL.Pre_Process ') ;

3103:
3104: END IF;
3105:
3106: IF l_debug_level > 0 THEN
3107: oe_debug_pub.add( 'EXITING OE_BULK_CONFIG_UTIL.Pre_Process ') ;
3108: END IF;
3109:
3110:
3111:

Line 3115: oe_debug_pub.add('NO DATA FOUND in OE_BULK_CONFIG_UTIL.Pre_Process ' , 1);

3111:
3112: EXCEPTION
3113: WHEN NO_DATA_FOUND THEN
3114: IF l_debug_level > 0 THEN
3115: oe_debug_pub.add('NO DATA FOUND in OE_BULK_CONFIG_UTIL.Pre_Process ' , 1);
3116: END IF;
3117:
3118: WHEN OTHERS THEN
3119: IF l_debug_level > 0 THEN

Line 3120: oe_debug_pub.add('Others Error, OE_BULK_CONFIG_UTIL.Pre_Process');

3116: END IF;
3117:
3118: WHEN OTHERS THEN
3119: IF l_debug_level > 0 THEN
3120: oe_debug_pub.add('Others Error, OE_BULK_CONFIG_UTIL.Pre_Process');
3121: oe_debug_pub.add(substr(sqlerrm,1,240));
3122: END IF;
3123:
3124: OE_BULK_MSG_PUB.Add_Exc_Msg

Line 3160: oe_debug_pub.add( 'ENTERING OE_BULK_CONFIG_UTIL.Delete_Configurations ') ;

3156:
3157:
3158: BEGIN
3159: IF l_debug_level > 0 THEN
3160: oe_debug_pub.add( 'ENTERING OE_BULK_CONFIG_UTIL.Delete_Configurations ') ;
3161: END IF;
3162:
3163: -- initialize return status to success
3164: x_return_status := fnd_api.g_ret_sts_success;

Line 3228: oe_debug_pub.add( 'EXITING OE_BULK_CONFIG_UTIL.Delete_Configurations ') ;

3224: END LOOP;
3225: END LOOP;
3226:
3227: IF l_debug_level > 0 THEN
3228: oe_debug_pub.add( 'EXITING OE_BULK_CONFIG_UTIL.Delete_Configurations ') ;
3229: END IF;
3230:
3231:
3232: EXCEPTION

Line 3236: oe_debug_pub.add('Others Error, OE_BULK_CONFIG_UTIL.Delete_Configurations');

3232: EXCEPTION
3233:
3234: WHEN OTHERS THEN
3235: IF l_debug_level > 0 THEN
3236: oe_debug_pub.add('Others Error, OE_BULK_CONFIG_UTIL.Delete_Configurations');
3237: oe_debug_pub.add(substr(sqlerrm,1,240));
3238: END IF;
3239:
3240: OE_BULK_MSG_PUB.Add_Exc_Msg

Line 3253: END OE_BULK_CONFIG_UTIL;

3249: END Delete_Configurations;
3250:
3251:
3252:
3253: END OE_BULK_CONFIG_UTIL;