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.IBE_CCTBOM_PVT dependencies on IBE_UTIL

Line 28: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

24: AND NVL(disable_date,sysdate) >=sysdate
25: AND NVL(effectivity_date,sysdate) <= sysdate;
26:
27: BEGIN
28: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
29: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: Validating model bundle, item_id='||p_model_id||',organization_id='||p_organization_id);
30: END IF;
31:
32: l_isModelBundle := FND_API.G_TRUE;

Line 29: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: Validating model bundle, item_id='||p_model_id||',organization_id='||p_organization_id);

25: AND NVL(effectivity_date,sysdate) <= sysdate;
26:
27: BEGIN
28: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
29: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: Validating model bundle, item_id='||p_model_id||',organization_id='||p_organization_id);
30: END IF;
31:
32: l_isModelBundle := FND_API.G_TRUE;
33: l_isEmptyModelItem := FND_API.G_TRUE; --gzhang 12/12/02, #2709735

Line 39: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

35: FOR option_class_rec IN l_option_class_csr LOOP
36:
37: IF option_class_rec.optional <> 2 OR option_class_rec.bom_item_type <> 2 THEN
38:
39: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
40: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle:'
41: ||option_class_rec.component_item_id||' is not a required optional class, optional='||option_class_rec.optional
42: ||',bom_item_type='||option_class_rec.bom_item_type);
43: END IF;

Line 40: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle:'

36:
37: IF option_class_rec.optional <> 2 OR option_class_rec.bom_item_type <> 2 THEN
38:
39: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
40: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle:'
41: ||option_class_rec.component_item_id||' is not a required optional class, optional='||option_class_rec.optional
42: ||',bom_item_type='||option_class_rec.bom_item_type);
43: END IF;
44:

Line 49: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

45: l_isModelBundle := FND_API.G_FALSE;
46:
47: ELSE
48: l_component_code := p_model_id || '-' || option_class_rec.component_item_id || '-%';
49: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
50: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: Looking for items with component code like '||l_component_code);
51: END IF;
52:
53: SELECT count(component_item_id) into l_total_component_items

Line 50: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: Looking for items with component code like '||l_component_code);

46:
47: ELSE
48: l_component_code := p_model_id || '-' || option_class_rec.component_item_id || '-%';
49: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
50: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: Looking for items with component code like '||l_component_code);
51: END IF;
52:
53: SELECT count(component_item_id) into l_total_component_items
54: FROM BOM_EXPLOSIONS

Line 68: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

64: AND component_code like l_component_code
65: AND NVL(disable_date,sysdate) >=sysdate
66: AND NVL(effectivity_date,sysdate) <= sysdate;
67:
68: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
69: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: Found '||l_total_component_items||' component item(s)');
70: END IF;
71: IF l_total_component_items = 1 THEN
72: SELECT component_item_id, optional into l_item_id,l_optional

Line 69: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: Found '||l_total_component_items||' component item(s)');

65: AND NVL(disable_date,sysdate) >=sysdate
66: AND NVL(effectivity_date,sysdate) <= sysdate;
67:
68: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
69: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: Found '||l_total_component_items||' component item(s)');
70: END IF;
71: IF l_total_component_items = 1 THEN
72: SELECT component_item_id, optional into l_item_id,l_optional
73: FROM BOM_EXPLOSIONS

Line 86: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

82: AND organization_id = p_organization_id
83: AND component_code like l_component_code
84: AND NVL(disable_date,sysdate) >=sysdate
85: AND NVL(effectivity_date,sysdate) <= sysdate;
86: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
87: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: item_id='||l_item_id||', optional='||l_optional);
88: END IF;
89: IF l_optional <> 1 THEN
90: l_isModelBundle := FND_API.G_FALSE;

Line 87: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: item_id='||l_item_id||', optional='||l_optional);

83: AND component_code like l_component_code
84: AND NVL(disable_date,sysdate) >=sysdate
85: AND NVL(effectivity_date,sysdate) <= sysdate;
86: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
87: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: item_id='||l_item_id||', optional='||l_optional);
88: END IF;
89: IF l_optional <> 1 THEN
90: l_isModelBundle := FND_API.G_FALSE;
91: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 91: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

87: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: item_id='||l_item_id||', optional='||l_optional);
88: END IF;
89: IF l_optional <> 1 THEN
90: l_isModelBundle := FND_API.G_FALSE;
91: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
92: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: component item(item_id='||l_item_id||') not optional, optional='||l_optional);
93: END IF;
94: END IF;
95: ELSE

Line 92: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: component item(item_id='||l_item_id||') not optional, optional='||l_optional);

88: END IF;
89: IF l_optional <> 1 THEN
90: l_isModelBundle := FND_API.G_FALSE;
91: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
92: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: component item(item_id='||l_item_id||') not optional, optional='||l_optional);
93: END IF;
94: END IF;
95: ELSE
96: l_isModelBundle := FND_API.G_FALSE;

Line 97: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

93: END IF;
94: END IF;
95: ELSE
96: l_isModelBundle := FND_API.G_FALSE;
97: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
98: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: optional class (item_id='||option_class_rec.component_item_id||') contains '||l_total_component_items||'(more than one or ZERO) items');
99: END IF;
100: END IF;
101: END IF;

Line 98: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: optional class (item_id='||option_class_rec.component_item_id||') contains '||l_total_component_items||'(more than one or ZERO) items');

94: END IF;
95: ELSE
96: l_isModelBundle := FND_API.G_FALSE;
97: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
98: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: optional class (item_id='||option_class_rec.component_item_id||') contains '||l_total_component_items||'(more than one or ZERO) items');
99: END IF;
100: END IF;
101: END IF;
102: l_isEmptyModelItem := FND_API.G_FALSE; --gzhang 12/12/02, #2709735

Line 113: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

109:
110: --gzhang 12/16/02, #2709735
111: IF l_isEmptyModelItem = FND_API.G_TRUE THEN
112: l_isModelBundle := FND_API.G_FALSE;
113: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
114: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: No child items found');
115: END IF;
116: END IF;
117:

Line 114: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: No child items found');

110: --gzhang 12/16/02, #2709735
111: IF l_isEmptyModelItem = FND_API.G_TRUE THEN
112: l_isModelBundle := FND_API.G_FALSE;
113: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
114: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: No child items found');
115: END IF;
116: END IF;
117:
118: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 118: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

114: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: No child items found');
115: END IF;
116: END IF;
117:
118: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
119: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: return '||l_isModelBundle);
120: END IF;
121: --gzhang 08/08/2002, bug#2488246
122: --IBE_UTIL.DISABLE_DEBUG;

Line 119: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: return '||l_isModelBundle);

115: END IF;
116: END IF;
117:
118: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
119: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: return '||l_isModelBundle);
120: END IF;
121: --gzhang 08/08/2002, bug#2488246
122: --IBE_UTIL.DISABLE_DEBUG;
123: RETURN l_isModelBundle;

Line 122: --IBE_UTIL.DISABLE_DEBUG;

118: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
119: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: return '||l_isModelBundle);
120: END IF;
121: --gzhang 08/08/2002, bug#2488246
122: --IBE_UTIL.DISABLE_DEBUG;
123: RETURN l_isModelBundle;
124: EXCEPTION
125: WHEN NO_DATA_FOUND THEN
126: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 126: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

122: --IBE_UTIL.DISABLE_DEBUG;
123: RETURN l_isModelBundle;
124: EXCEPTION
125: WHEN NO_DATA_FOUND THEN
126: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
127: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: NO_DATA_FOUND Exception, return F');
128: END IF;
129: --gzhang 08/08/2002, bug#2488246
130: --IBE_UTIL.DISABLE_DEBUG;

Line 127: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: NO_DATA_FOUND Exception, return F');

123: RETURN l_isModelBundle;
124: EXCEPTION
125: WHEN NO_DATA_FOUND THEN
126: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
127: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: NO_DATA_FOUND Exception, return F');
128: END IF;
129: --gzhang 08/08/2002, bug#2488246
130: --IBE_UTIL.DISABLE_DEBUG;
131: RETURN FND_API.G_FALSE;

Line 130: --IBE_UTIL.DISABLE_DEBUG;

126: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
127: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: NO_DATA_FOUND Exception, return F');
128: END IF;
129: --gzhang 08/08/2002, bug#2488246
130: --IBE_UTIL.DISABLE_DEBUG;
131: RETURN FND_API.G_FALSE;
132: WHEN OTHERS THEN
133: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
134: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: OTHERS Exception, return F');

Line 133: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

129: --gzhang 08/08/2002, bug#2488246
130: --IBE_UTIL.DISABLE_DEBUG;
131: RETURN FND_API.G_FALSE;
132: WHEN OTHERS THEN
133: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
134: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: OTHERS Exception, return F');
135: END IF;
136: --gzhang 08/08/2002, bug#2488246
137: --IBE_UTIL.DISABLE_DEBUG;

Line 134: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: OTHERS Exception, return F');

130: --IBE_UTIL.DISABLE_DEBUG;
131: RETURN FND_API.G_FALSE;
132: WHEN OTHERS THEN
133: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
134: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: OTHERS Exception, return F');
135: END IF;
136: --gzhang 08/08/2002, bug#2488246
137: --IBE_UTIL.DISABLE_DEBUG;
138: RETURN FND_API.G_FALSE;

Line 137: --IBE_UTIL.DISABLE_DEBUG;

133: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
134: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: OTHERS Exception, return F');
135: END IF;
136: --gzhang 08/08/2002, bug#2488246
137: --IBE_UTIL.DISABLE_DEBUG;
138: RETURN FND_API.G_FALSE;
139: END Validate_Model_Bundle;
140:
141:

Line 211: --ibe_util.enable_debug;

207: AND MSIV.organization_id = p_organization_id;
208:
209: BEGIN
210: --gzhang 08/08/2002, bug#2488246
211: --ibe_util.enable_debug;
212:
213: -- begin API body
214: l_return_status := FND_API.G_RET_STS_SUCCESS;
215: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 215: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

211: --ibe_util.enable_debug;
212:
213: -- begin API body
214: l_return_status := FND_API.G_RET_STS_SUCCESS;
215: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
216: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : p_model_id ='||p_model_id||', p_organization_id='||p_organization_id);
217: END IF;
218:
219: OPEN l_bom_item_type_csr;

Line 216: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : p_model_id ='||p_model_id||', p_organization_id='||p_organization_id);

212:
213: -- begin API body
214: l_return_status := FND_API.G_RET_STS_SUCCESS;
215: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
216: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : p_model_id ='||p_model_id||', p_organization_id='||p_organization_id);
217: END IF;
218:
219: OPEN l_bom_item_type_csr;
220: FETCH l_bom_item_type_csr INTO l_bom_item_type;

Line 228: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

224: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
225:
226: IF l_bom_item_type = 1 AND CZ_CF_API.UI_FOR_ITEM(p_model_id, p_organization_id, SYSDATE, 'DHTML', FND_API.G_MISS_NUM, l_resp_id, l_resp_appl_id) IS NULL THEN
227: -- Call BOM Explosion API
228: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
229: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle :Calling BOMPNORD.Bmxporder_Explode_For_Order()');
230: END IF;
231: Explode(p_validation_org => p_organization_id,
232: p_levels => 6, --??

Line 229: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle :Calling BOMPNORD.Bmxporder_Explode_For_Order()');

225:
226: IF l_bom_item_type = 1 AND CZ_CF_API.UI_FOR_ITEM(p_model_id, p_organization_id, SYSDATE, 'DHTML', FND_API.G_MISS_NUM, l_resp_id, l_resp_appl_id) IS NULL THEN
227: -- Call BOM Explosion API
228: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
229: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle :Calling BOMPNORD.Bmxporder_Explode_For_Order()');
230: END IF;
231: Explode(p_validation_org => p_organization_id,
232: p_levels => 6, --??
233: p_stdcompflag => 'ALL',

Line 240: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

236: x_msg_data => l_msg_data,
237: x_error_code => l_error_code,
238: x_return_status => l_return_status);
239: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
240: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
241: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : RAISE FND_API.G_RET_STS_UNEXP_ERROR');
242: END IF;
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 241: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : RAISE FND_API.G_RET_STS_UNEXP_ERROR');

237: x_error_code => l_error_code,
238: x_return_status => l_return_status);
239: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
240: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
241: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : RAISE FND_API.G_RET_STS_UNEXP_ERROR');
242: END IF;
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
245: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 245: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

241: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : RAISE FND_API.G_RET_STS_UNEXP_ERROR');
242: END IF;
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
245: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
246: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : RAISE FND_API.G_RET_STS_ERROR');
247: END IF;
248: RAISE FND_API.G_EXC_ERROR;
249: ELSE

Line 246: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : RAISE FND_API.G_RET_STS_ERROR');

242: END IF;
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
245: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
246: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : RAISE FND_API.G_RET_STS_ERROR');
247: END IF;
248: RAISE FND_API.G_EXC_ERROR;
249: ELSE
250: l_bundle := Validate_Model_Bundle(p_model_id,p_organization_id);

Line 252: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

248: RAISE FND_API.G_EXC_ERROR;
249: ELSE
250: l_bundle := Validate_Model_Bundle(p_model_id,p_organization_id);
251: IF l_bundle = FND_API.G_FALSE THEN
252: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
253: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : Model bundle ( item_id='||p_model_id||') is invalid. Incorrect BOM setup.');
254: END IF;
255: ELSE
256: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 253: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : Model bundle ( item_id='||p_model_id||') is invalid. Incorrect BOM setup.');

249: ELSE
250: l_bundle := Validate_Model_Bundle(p_model_id,p_organization_id);
251: IF l_bundle = FND_API.G_FALSE THEN
252: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
253: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : Model bundle ( item_id='||p_model_id||') is invalid. Incorrect BOM setup.');
254: END IF;
255: ELSE
256: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
257: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : valid model bundle, item_id='||p_model_id);

Line 256: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

252: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
253: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : Model bundle ( item_id='||p_model_id||') is invalid. Incorrect BOM setup.');
254: END IF;
255: ELSE
256: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
257: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : valid model bundle, item_id='||p_model_id);
258: END IF;
259: END IF;
260: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 257: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : valid model bundle, item_id='||p_model_id);

253: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : Model bundle ( item_id='||p_model_id||') is invalid. Incorrect BOM setup.');
254: END IF;
255: ELSE
256: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
257: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : valid model bundle, item_id='||p_model_id);
258: END IF;
259: END IF;
260: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
261: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : Validate_Model_Bundle('||p_model_id||','||p_organization_id||') returns '||l_bundle);

Line 260: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

256: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
257: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : valid model bundle, item_id='||p_model_id);
258: END IF;
259: END IF;
260: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
261: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : Validate_Model_Bundle('||p_model_id||','||p_organization_id||') returns '||l_bundle);
262: END IF;
263: END IF;
264: ELSE

Line 261: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : Validate_Model_Bundle('||p_model_id||','||p_organization_id||') returns '||l_bundle);

257: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : valid model bundle, item_id='||p_model_id);
258: END IF;
259: END IF;
260: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
261: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : Validate_Model_Bundle('||p_model_id||','||p_organization_id||') returns '||l_bundle);
262: END IF;
263: END IF;
264: ELSE
265: l_bundle := FND_API.G_FALSE;

Line 266: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

262: END IF;
263: END IF;
264: ELSE
265: l_bundle := FND_API.G_FALSE;
266: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
267: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : Item( item_id='||p_model_id||') is not a model bundle.');
268: END IF;
269: END IF;
270: return l_bundle;

Line 267: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : Item( item_id='||p_model_id||') is not a model bundle.');

263: END IF;
264: ELSE
265: l_bundle := FND_API.G_FALSE;
266: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
267: IBE_UTIL.debug(G_PKG_NAME||'.Is_Model_Bundle : Item( item_id='||p_model_id||') is not a model bundle.');
268: END IF;
269: END IF;
270: return l_bundle;
271: END Is_Model_Bundle;

Line 333: --ibe_util.enable_debug;

329:
330: BEGIN
331: --dbms_output.put_line('INSIDE LOAD COMPONENTS');
332: --gzhang 08/08/2002, bug#2488246
333: --ibe_util.enable_debug;
334: -- standard call to check for call compatibility
335: l_return_status := FND_API.G_RET_STS_SUCCESS;
336: IF NOT FND_API.Compatible_API_Call (l_api_version,
337: p_api_version,

Line 352: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

348:
349: -- initialize API return status to success
350: x_return_status := FND_API.G_RET_STS_SUCCESS;
351:
352: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
353: IBE_UTIL.debug(G_PKG_NAME||'.Load_Components');
354: -- begin API body
355: -- Call BOM Explosion API
356: IBE_UTIL.debug(G_PKG_NAME||'.Load_Components: Calling BOMPNORD.Bmxporder_Explode_For_Order()');

Line 353: IBE_UTIL.debug(G_PKG_NAME||'.Load_Components');

349: -- initialize API return status to success
350: x_return_status := FND_API.G_RET_STS_SUCCESS;
351:
352: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
353: IBE_UTIL.debug(G_PKG_NAME||'.Load_Components');
354: -- begin API body
355: -- Call BOM Explosion API
356: IBE_UTIL.debug(G_PKG_NAME||'.Load_Components: Calling BOMPNORD.Bmxporder_Explode_For_Order()');
357: IBE_UTIL.debug(G_PKG_NAME||'.Load_Components: BEFORE EXPLODE in LOAD');

Line 356: IBE_UTIL.debug(G_PKG_NAME||'.Load_Components: Calling BOMPNORD.Bmxporder_Explode_For_Order()');

352: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
353: IBE_UTIL.debug(G_PKG_NAME||'.Load_Components');
354: -- begin API body
355: -- Call BOM Explosion API
356: IBE_UTIL.debug(G_PKG_NAME||'.Load_Components: Calling BOMPNORD.Bmxporder_Explode_For_Order()');
357: IBE_UTIL.debug(G_PKG_NAME||'.Load_Components: BEFORE EXPLODE in LOAD');
358: END IF;
359:
360: Explode(p_validation_org => p_organization_id,

Line 357: IBE_UTIL.debug(G_PKG_NAME||'.Load_Components: BEFORE EXPLODE in LOAD');

353: IBE_UTIL.debug(G_PKG_NAME||'.Load_Components');
354: -- begin API body
355: -- Call BOM Explosion API
356: IBE_UTIL.debug(G_PKG_NAME||'.Load_Components: Calling BOMPNORD.Bmxporder_Explode_For_Order()');
357: IBE_UTIL.debug(G_PKG_NAME||'.Load_Components: BEFORE EXPLODE in LOAD');
358: END IF;
359:
360: Explode(p_validation_org => p_organization_id,
361: p_levels => 6, --??

Line 368: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

364: p_revdate => l_explosion_date,
365: x_msg_data => l_msg_data,
366: x_error_code => l_error_code,
367: x_return_status => l_return_status);
368: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
369: IBE_UTIL.debug(G_PKG_NAME||'.Load_Components: AFTER Explode reture status = '||l_return_status); --gzhang 05/24/2002 typo error
370: END IF;
371:
372: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 369: IBE_UTIL.debug(G_PKG_NAME||'.Load_Components: AFTER Explode reture status = '||l_return_status); --gzhang 05/24/2002 typo error

365: x_msg_data => l_msg_data,
366: x_error_code => l_error_code,
367: x_return_status => l_return_status);
368: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
369: IBE_UTIL.debug(G_PKG_NAME||'.Load_Components: AFTER Explode reture status = '||l_return_status); --gzhang 05/24/2002 typo error
370: END IF;
371:
372: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 402: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

398: AND DISABLE_DATE >= sysdate;
399:
400: -- end API body
401: --dbms_output.put_line('After select in load ');
402: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
403: IBE_UTIL.debug(G_PKG_NAME||'.Load_Components: After select in load');
404: END IF;
405:
406: -- standard call to get message count and if count is 1, get message info.

Line 403: IBE_UTIL.debug(G_PKG_NAME||'.Load_Components: After select in load');

399:
400: -- end API body
401: --dbms_output.put_line('After select in load ');
402: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
403: IBE_UTIL.debug(G_PKG_NAME||'.Load_Components: After select in load');
404: END IF;
405:
406: -- standard call to get message count and if count is 1, get message info.
407: FND_MSG_PUB.Count_And_Get

Line 413: --ibe_util.disable_debug;

409: p_count => x_msg_count,
410: p_data => x_msg_data
411: );
412: --gzhang 08/08/2002, bug#2488246
413: --ibe_util.disable_debug;
414: EXCEPTION
415: WHEN FND_API.G_EXC_ERROR THEN
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: FND_MSG_PUB.Count_And_Get

Line 423: --ibe_util.disable_debug;

419: p_count => x_msg_count,
420: p_data => x_msg_data
421: );
422: --gzhang 08/08/2002, bug#2488246
423: --ibe_util.disable_debug;
424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
426: FND_MSG_PUB.Count_And_Get
427: ( p_encoded => FND_API.G_FALSE,

Line 432: --ibe_util.disable_debug;

428: p_count => x_msg_count,
429: p_data => x_msg_data
430: );
431: --gzhang 08/08/2002, bug#2488246
432: --ibe_util.disable_debug;
433: WHEN OTHERS THEN
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
436: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

Line 453: --ibe_util.disable_debug;

449: p_count => x_msg_count,
450: p_data => x_msg_data
451: );
452: --gzhang 08/08/2002, bug#2488246
453: --ibe_util.disable_debug;
454: END Load_Components;
455:
456: /*----------------------------------------------------------------------
457: Procedure Name : Explode

Line 477: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

473: IS
474: l_group_id NUMBER; -- bom out param
475: BEGIN
476:
477: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
478: IBE_UTIL.debug(G_PKG_NAME||'.Explode: Inside EXPLODE before call itemid = '||p_top_item_id);
479: END IF;
480:
481: BOMPNORD.Bmxporder_Explode_For_Order(

Line 478: IBE_UTIL.debug(G_PKG_NAME||'.Explode: Inside EXPLODE before call itemid = '||p_top_item_id);

474: l_group_id NUMBER; -- bom out param
475: BEGIN
476:
477: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
478: IBE_UTIL.debug(G_PKG_NAME||'.Explode: Inside EXPLODE before call itemid = '||p_top_item_id);
479: END IF;
480:
481: BOMPNORD.Bmxporder_Explode_For_Order(
482: org_id => p_validation_org,

Line 495: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

491: user_id => 0,
492: commit_flag => 'Y',
493: err_msg => x_msg_data,
494: error_code => x_error_code);
495: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
496: IBE_UTIL.debug(G_PKG_NAME||'.Explode: Error Msg = '||x_msg_data);
497: IBE_UTIL.debug(G_PKG_NAME||'.Explode: Error_code = '|| x_error_code);
498: IBE_UTIL.debug(G_PKG_NAME||'.Explode: grp_id = '|| l_group_id);
499:

Line 496: IBE_UTIL.debug(G_PKG_NAME||'.Explode: Error Msg = '||x_msg_data);

492: commit_flag => 'Y',
493: err_msg => x_msg_data,
494: error_code => x_error_code);
495: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
496: IBE_UTIL.debug(G_PKG_NAME||'.Explode: Error Msg = '||x_msg_data);
497: IBE_UTIL.debug(G_PKG_NAME||'.Explode: Error_code = '|| x_error_code);
498: IBE_UTIL.debug(G_PKG_NAME||'.Explode: grp_id = '|| l_group_id);
499:
500: IBE_UTIL.debug(G_PKG_NAME||'.Explode: After calling bom Explode api');

Line 497: IBE_UTIL.debug(G_PKG_NAME||'.Explode: Error_code = '|| x_error_code);

493: err_msg => x_msg_data,
494: error_code => x_error_code);
495: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
496: IBE_UTIL.debug(G_PKG_NAME||'.Explode: Error Msg = '||x_msg_data);
497: IBE_UTIL.debug(G_PKG_NAME||'.Explode: Error_code = '|| x_error_code);
498: IBE_UTIL.debug(G_PKG_NAME||'.Explode: grp_id = '|| l_group_id);
499:
500: IBE_UTIL.debug(G_PKG_NAME||'.Explode: After calling bom Explode api');
501: END IF;

Line 498: IBE_UTIL.debug(G_PKG_NAME||'.Explode: grp_id = '|| l_group_id);

494: error_code => x_error_code);
495: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
496: IBE_UTIL.debug(G_PKG_NAME||'.Explode: Error Msg = '||x_msg_data);
497: IBE_UTIL.debug(G_PKG_NAME||'.Explode: Error_code = '|| x_error_code);
498: IBE_UTIL.debug(G_PKG_NAME||'.Explode: grp_id = '|| l_group_id);
499:
500: IBE_UTIL.debug(G_PKG_NAME||'.Explode: After calling bom Explode api');
501: END IF;
502:

Line 500: IBE_UTIL.debug(G_PKG_NAME||'.Explode: After calling bom Explode api');

496: IBE_UTIL.debug(G_PKG_NAME||'.Explode: Error Msg = '||x_msg_data);
497: IBE_UTIL.debug(G_PKG_NAME||'.Explode: Error_code = '|| x_error_code);
498: IBE_UTIL.debug(G_PKG_NAME||'.Explode: grp_id = '|| l_group_id);
499:
500: IBE_UTIL.debug(G_PKG_NAME||'.Explode: After calling bom Explode api');
501: END IF;
502:
503: IF x_error_code <> 0 THEN
504: --dbms_output.put_line('Error in BOM Explosion');

Line 505: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

501: END IF;
502:
503: IF x_error_code <> 0 THEN
504: --dbms_output.put_line('Error in BOM Explosion');
505: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
506: IBE_UTIL.debug('Error in BOM Explosion');
507: END IF;
508: IF x_msg_data is not null THEN
509: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 506: IBE_UTIL.debug('Error in BOM Explosion');

502:
503: IF x_error_code <> 0 THEN
504: --dbms_output.put_line('Error in BOM Explosion');
505: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
506: IBE_UTIL.debug('Error in BOM Explosion');
507: END IF;
508: IF x_msg_data is not null THEN
509: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
510: IBE_UTIL.debug(G_PKG_NAME||'.Explode: BOM msg name= ' || substr(x_msg_data, 1, 250));

Line 509: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

505: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
506: IBE_UTIL.debug('Error in BOM Explosion');
507: END IF;
508: IF x_msg_data is not null THEN
509: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
510: IBE_UTIL.debug(G_PKG_NAME||'.Explode: BOM msg name= ' || substr(x_msg_data, 1, 250));
511: END IF;
512:
513: -- girish from bom team told err_msg is msg name, track bug 1623728

Line 510: IBE_UTIL.debug(G_PKG_NAME||'.Explode: BOM msg name= ' || substr(x_msg_data, 1, 250));

506: IBE_UTIL.debug('Error in BOM Explosion');
507: END IF;
508: IF x_msg_data is not null THEN
509: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
510: IBE_UTIL.debug(G_PKG_NAME||'.Explode: BOM msg name= ' || substr(x_msg_data, 1, 250));
511: END IF;
512:
513: -- girish from bom team told err_msg is msg name, track bug 1623728
514: FND_MESSAGE.Set_Name('BOM', x_msg_data);

Line 523: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

519: END IF;
520:
521:
522: x_return_status := FND_API.G_RET_STS_SUCCESS;
523: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
524: IBE_UTIL.debug(G_PKG_NAME||'.Explode: Exiting Ibe_CctBom_Pvt.Explode');
525: END IF;
526:
527: EXCEPTION

Line 524: IBE_UTIL.debug(G_PKG_NAME||'.Explode: Exiting Ibe_CctBom_Pvt.Explode');

520:
521:
522: x_return_status := FND_API.G_RET_STS_SUCCESS;
523: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
524: IBE_UTIL.debug(G_PKG_NAME||'.Explode: Exiting Ibe_CctBom_Pvt.Explode');
525: END IF;
526:
527: EXCEPTION
528: WHEN FND_API.G_EXC_ERROR THEN