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.EGO_ITEM_ORG_ASSIGN_PVT dependencies on FND_API

Line 48: l_ret_sts_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'

44:
45:
46: l_error_table INV_ITEM_GRP.Error_tbl_type;
47: l_error_index BINARY_INTEGER := 1;
48: l_ret_sts_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
49: l_ret_sts_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
50: l_eam_enabled_flag VARCHAR2(1) := 'N';
51: l_wms_enabled_flag VARCHAR2(1) := 'N';
52: l_process_enabled_flag VARCHAR2(1) := 'N';

Line 49: l_ret_sts_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'

45:
46: l_error_table INV_ITEM_GRP.Error_tbl_type;
47: l_error_index BINARY_INTEGER := 1;
48: l_ret_sts_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
49: l_ret_sts_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
50: l_eam_enabled_flag VARCHAR2(1) := 'N';
51: l_wms_enabled_flag VARCHAR2(1) := 'N';
52: l_process_enabled_flag VARCHAR2(1) := 'N';
53: l_primary_cost_method NUMBER := 0;

Line 58: x_return_status := FND_API.g_RET_STS_SUCCESS;

54: l_trading_partner_org_flag VARCHAR2(1) := 'N';
55: l_exists NUMBER;
56:
57: BEGIN
58: x_return_status := FND_API.g_RET_STS_SUCCESS;
59: x_msg_count := 0;
60:
61: IF p_master_status <> 'A' THEN
62: x_msg_count := x_msg_count + 1;

Line 67: Raise FND_API.g_EXC_ERROR;

63: FND_MESSAGE.SET_NAME('INV','INV_IOI_UNAPPROVED_ITEM_ORG');
64: IF NVL(p_context,'N') = 'N' THEN
65: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
66: END IF;
67: Raise FND_API.g_EXC_ERROR;
68: END IF;
69:
70: OPEN org_parameters(p_organization_id);
71: FETCH org_parameters

Line 89: Raise FND_API.g_EXC_ERROR;

85: FND_MESSAGE.SET_NAME('INV','INV_TRACKING_OPM_BOM_ATTR');
86: IF NVL(p_context,'N') = 'N' THEN
87: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
88: END IF;
89: Raise FND_API.g_EXC_ERROR;
90: END IF;
91:
92: -- Organization specific validations for Outsourced Assembly
93: IF ( p_outsourced_assembly = 1) THEN

Line 102: Raise FND_API.g_EXC_ERROR;

98: FND_MESSAGE.SET_NAME('INV','INV_OS_ASMBLY_INVALID_ORG');
99: IF NVL(p_context,'N') = 'N' THEN
100: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
101: END IF;
102: Raise FND_API.g_EXC_ERROR;
103: ELSIF ( l_trading_partner_org_flag = 'Y' AND
104: nvl(p_release_time_fence_code,-999999) <> 7) THEN
105: x_msg_count := x_msg_count + 1;
106: FND_MESSAGE.SET_NAME('INV','INV_OS_ASMBLY_TP_TIME_FENSE');

Line 110: Raise FND_API.g_EXC_ERROR;

106: FND_MESSAGE.SET_NAME('INV','INV_OS_ASMBLY_TP_TIME_FENSE');
107: IF NVL(p_context,'N') = 'N' THEN
108: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
109: END IF;
110: Raise FND_API.g_EXC_ERROR;
111: ELSIF ( l_primary_cost_method <> 1 ) THEN
112: x_msg_count := x_msg_count + 1;
113: FND_MESSAGE.SET_NAME('INV','INV_OS_ASMBLY_STD_COST_ORG');
114: IF NVL(p_context,'N') = 'N' THEN

Line 117: Raise FND_API.g_EXC_ERROR;

113: FND_MESSAGE.SET_NAME('INV','INV_OS_ASMBLY_STD_COST_ORG');
114: IF NVL(p_context,'N') = 'N' THEN
115: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
116: END IF;
117: Raise FND_API.g_EXC_ERROR;
118: END IF;
119: END IF;
120:
121: -- Organization specific validations for subcontracting component.

Line 131: Raise FND_API.g_EXC_ERROR;

127: FND_MESSAGE.SET_NAME('INV','INV_OS_ASMBLY_INVALID_ORG');
128: IF NVL(p_context,'N') = 'N' THEN
129: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
130: END IF;
131: Raise FND_API.g_EXC_ERROR;
132: ELSIF ( l_primary_cost_method <> 1 ) THEN
133: x_msg_count := x_msg_count + 1;
134: FND_MESSAGE.SET_NAME('INV','INV_OS_ASMBLY_STD_COST_ORG');
135: IF NVL(p_context,'N') = 'N' THEN

Line 138: Raise FND_API.g_EXC_ERROR;

134: FND_MESSAGE.SET_NAME('INV','INV_OS_ASMBLY_STD_COST_ORG');
135: IF NVL(p_context,'N') = 'N' THEN
136: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
137: END IF;
138: Raise FND_API.g_EXC_ERROR;
139: END IF;
140: END IF;
141:
142: -- Bug: 5017578 Org Specific Validations

Line 152: Raise FND_API.g_EXC_ERROR;

148: FND_MESSAGE.SET_NAME('INV','INV_SEC_DEFAULT_NOT_NULL');
149: IF NVL(p_context,'N') = 'N' THEN
150: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
151: END IF;
152: Raise FND_API.g_EXC_ERROR;
153: END IF;
154:
155: IF p_secondary_uom_code IS NOT NULL THEN
156: x_msg_count := x_msg_count + 1;

Line 161: Raise FND_API.g_EXC_ERROR;

157: FND_MESSAGE.SET_NAME('INV','INV_SEC_UOM_IS_NOT_NULL');
158: IF NVL(p_context,'N') = 'N' THEN
159: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
160: END IF;
161: Raise FND_API.g_EXC_ERROR;
162: END IF;
163:
164: IF ( p_dual_uom_deviation_high <> 0
165: OR p_dual_uom_deviation_low <> 0 )THEN

Line 171: Raise FND_API.g_EXC_ERROR;

167: FND_MESSAGE.SET_NAME('INV','INV_UOM_DEV_IS_NOT_ZERO');
168: IF NVL(p_context,'N') = 'N' THEN
169: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
170: END IF;
171: Raise FND_API.g_EXC_ERROR;
172: END IF;
173: END IF;
174:
175: IF ( ( p_tracking_quantity_ind = 'PS' OR p_ont_pricing_qty_source = 'S')

Line 182: Raise FND_API.g_EXC_ERROR;

178: FND_MESSAGE.SET_NAME('INV','INV_REQUIRED_FIELDS');
179: IF NVL(p_context,'N') = 'N' THEN
180: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
181: END IF;
182: Raise FND_API.g_EXC_ERROR;
183: END IF;
184:
185: IF ( p_tracking_quantity_ind = 'PS' ) THEN
186: IF (p_bom_item_type IN (1,2) OR p_bom_enabled_flag = 'Y') THEN

Line 192: Raise FND_API.g_EXC_ERROR;

188: FND_MESSAGE.SET_NAME('INV','INV_TRACKING_OPM_BOM_ATTR');
189: IF NVL(p_context,'N') = 'N' THEN
190: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
191: END IF;
192: Raise FND_API.g_EXC_ERROR;
193: END IF;
194:
195: IF p_serial_number_control_code > 1 THEN
196: x_msg_count := x_msg_count + 1;

Line 201: Raise FND_API.g_EXC_ERROR;

197: FND_MESSAGE.SET_NAME('INV','INV_INVALID_TRACKING_QTY_IND');
198: IF NVL(p_context,'N') = 'N' THEN
199: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
200: END IF;
201: Raise FND_API.g_EXC_ERROR;
202: END IF;
203: END IF;
204:
205: IF ( p_tracking_quantity_ind = 'P'

Line 213: Raise FND_API.g_EXC_ERROR;

209: FND_MESSAGE.SET_NAME('INV','INV_SEC_DEFULT_IS_FIXED');
210: IF NVL(p_context,'N') = 'N' THEN
211: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
212: END IF;
213: Raise FND_API.g_EXC_ERROR;
214: END IF;
215:
216: --Bug 5330093 Begin
217: -- Confirming if "Positive Deviation" and "Negative Deviation" are 0

Line 230: Raise FND_API.g_EXC_ERROR;

226: --{
227: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
228: --}
229: END IF;
230: Raise FND_API.g_EXC_ERROR;
231: --}
232: END IF;
233: --}
234: END IF;

Line 254: Raise FND_API.g_EXC_ERROR;

250: FND_MESSAGE.SET_NAME('INV','INV_IOI_INVALID_TAX_CODE_ORG');
251: IF NVL(p_context,'N') = 'N' THEN
252: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
253: END IF;
254: Raise FND_API.g_EXC_ERROR;
255: END;
256: END IF;
257:
258: --Bug 5662813

Line 276: Raise FND_API.g_EXC_ERROR;

272: FND_MESSAGE.SET_NAME('INV','INV_IOI_PUR_TAX_CODE');
273: IF NVL(p_context,'N') = 'N' THEN
274: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
275: END IF;
276: Raise FND_API.g_EXC_ERROR;
277: END;
278: END IF;
279:
280:

Line 295: Raise FND_API.g_EXC_ERROR;

291: FND_MESSAGE.SET_NAME('INV','INV_IOI_BASE_ITEM_ID');
292: IF NVL(p_context,'N') = 'N' THEN
293: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
294: END IF;
295: Raise FND_API.g_EXC_ERROR;
296: END;
297: END IF;
298:
299: EXCEPTION

Line 300: WHEN FND_API.g_EXC_ERROR THEN

296: END;
297: END IF;
298:
299: EXCEPTION
300: WHEN FND_API.g_EXC_ERROR THEN
301: x_return_status := l_ret_sts_error;
302: IF NVL(p_context,'N') = 'BOM' THEN
303: x_error_code := fnd_message.get;
304: END IF;

Line 322: l_return_status VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS;

318: ,x_return_status OUT NOCOPY VARCHAR
319: ,x_msg_count OUT NOCOPY NUMBER)
320: IS
321: l_item_rec INV_ITEM_API.Item_rec_type := NULL;
322: l_return_status VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS;
323: l_sysdate DATE := SYSDATE;
324: l_rowid ROWID := NULL;
325: l_inv_id NUMBER := INV_ITEM_UTIL.g_Appl_Inst.inv;
326: l_error_table INV_ITEM_GRP.Error_tbl_type;

Line 328: l_ret_sts_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'

324: l_rowid ROWID := NULL;
325: l_inv_id NUMBER := INV_ITEM_UTIL.g_Appl_Inst.inv;
326: l_error_table INV_ITEM_GRP.Error_tbl_type;
327: l_error_index BINARY_INTEGER := 1;
328: l_ret_sts_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
329: l_ret_sts_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
330: l_item_org_valid VARCHAR2(1);
331: l_org_valid_count NUMBER;
332: l_item_id NUMBER;

Line 329: l_ret_sts_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'

325: l_inv_id NUMBER := INV_ITEM_UTIL.g_Appl_Inst.inv;
326: l_error_table INV_ITEM_GRP.Error_tbl_type;
327: l_error_index BINARY_INTEGER := 1;
328: l_ret_sts_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
329: l_ret_sts_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
330: l_item_org_valid VARCHAR2(1);
331: l_org_valid_count NUMBER;
332: l_item_id NUMBER;
333: l_master_status MTL_SYSTEM_ITEMS_B.APPROVAL_STATUS%TYPE;

Line 521: IF l_item_org_valid = FND_API.g_RET_STS_SUCCESS THEN

517: p_item_org_assign_tab(i).status := l_item_org_valid;
518: END IF;
519: END LOOP;
520:
521: IF l_item_org_valid = FND_API.g_RET_STS_SUCCESS THEN
522: INV_ITEM_PVT.CREATE_ITEM
523: (P_Item_Rec => l_Item_Rec
524: ,P_Item_Category_Struct_Id => NULL
525: ,P_Inv_Install => l_inv_id

Line 567: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

563: END IF;
564: END IF;
565:
566: EXCEPTION
567: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
568: x_msg_count := x_msg_count + 1;
569: EGO_Item_Msg.Add_Error_Text(x_msg_count,org_assign_rec.organization_code ||' : '||fnd_message.get);
570: IF l_return_status <> l_ret_sts_unexp_error THEN
571: l_return_status := l_ret_sts_error;