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 108: Raise FND_API.g_EXC_ERROR;

104: FND_MESSAGE.SET_NAME('INV','INV_OS_ASMBLY_INVALID_ORG');
105: IF NVL(p_context,'N') = 'N' THEN
106: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
107: END IF;
108: Raise FND_API.g_EXC_ERROR;
109: ELSIF ( l_trading_partner_org_flag = 'Y' AND
110: nvl(p_release_time_fence_code,-999999) <> 7) THEN
111: x_msg_count := x_msg_count + 1;
112: FND_MESSAGE.SET_NAME('INV','INV_OS_ASMBLY_TP_TIME_FENSE');

Line 116: Raise FND_API.g_EXC_ERROR;

112: FND_MESSAGE.SET_NAME('INV','INV_OS_ASMBLY_TP_TIME_FENSE');
113: IF NVL(p_context,'N') = 'N' THEN
114: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
115: END IF;
116: Raise FND_API.g_EXC_ERROR;
117: ELSIF ( l_primary_cost_method <> 1 ) THEN
118: x_msg_count := x_msg_count + 1;
119: FND_MESSAGE.SET_NAME('INV','INV_OS_ASMBLY_STD_COST_ORG');
120: IF NVL(p_context,'N') = 'N' THEN

Line 123: Raise FND_API.g_EXC_ERROR;

119: FND_MESSAGE.SET_NAME('INV','INV_OS_ASMBLY_STD_COST_ORG');
120: IF NVL(p_context,'N') = 'N' THEN
121: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
122: END IF;
123: Raise FND_API.g_EXC_ERROR;
124: END IF;
125: END IF;
126:
127: -- Organization specific validations for subcontracting component.

Line 143: Raise FND_API.g_EXC_ERROR;

139: FND_MESSAGE.SET_NAME('INV','INV_OS_ASMBLY_INVALID_ORG');
140: IF NVL(p_context,'N') = 'N' THEN
141: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
142: END IF;
143: Raise FND_API.g_EXC_ERROR;
144: ELSIF ( l_primary_cost_method <> 1 ) THEN
145: x_msg_count := x_msg_count + 1;
146: FND_MESSAGE.SET_NAME('INV','INV_OS_ASMBLY_STD_COST_ORG');
147: IF NVL(p_context,'N') = 'N' THEN

Line 150: Raise FND_API.g_EXC_ERROR;

146: FND_MESSAGE.SET_NAME('INV','INV_OS_ASMBLY_STD_COST_ORG');
147: IF NVL(p_context,'N') = 'N' THEN
148: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
149: END IF;
150: Raise FND_API.g_EXC_ERROR;
151: END IF;
152: END IF;
153:
154: -- Bug: 5017578 Org Specific Validations

Line 164: Raise FND_API.g_EXC_ERROR;

160: FND_MESSAGE.SET_NAME('INV','INV_SEC_DEFAULT_NOT_NULL');
161: IF NVL(p_context,'N') = 'N' THEN
162: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
163: END IF;
164: Raise FND_API.g_EXC_ERROR;
165: END IF;
166:
167: IF p_secondary_uom_code IS NOT NULL THEN
168: x_msg_count := x_msg_count + 1;

Line 173: Raise FND_API.g_EXC_ERROR;

169: FND_MESSAGE.SET_NAME('INV','INV_SEC_UOM_IS_NOT_NULL');
170: IF NVL(p_context,'N') = 'N' THEN
171: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
172: END IF;
173: Raise FND_API.g_EXC_ERROR;
174: END IF;
175:
176: IF ( p_dual_uom_deviation_high <> 0
177: OR p_dual_uom_deviation_low <> 0 )THEN

Line 183: Raise FND_API.g_EXC_ERROR;

179: FND_MESSAGE.SET_NAME('INV','INV_UOM_DEV_IS_NOT_ZERO');
180: IF NVL(p_context,'N') = 'N' THEN
181: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
182: END IF;
183: Raise FND_API.g_EXC_ERROR;
184: END IF;
185: END IF;
186:
187: IF ( ( p_tracking_quantity_ind = 'PS' OR p_ont_pricing_qty_source = 'S')

Line 194: Raise FND_API.g_EXC_ERROR;

190: FND_MESSAGE.SET_NAME('INV','INV_REQUIRED_FIELDS');
191: IF NVL(p_context,'N') = 'N' THEN
192: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
193: END IF;
194: Raise FND_API.g_EXC_ERROR;
195: END IF;
196:
197: IF ( p_tracking_quantity_ind = 'PS' ) THEN
198: IF (p_bom_item_type IN (1,2) OR p_bom_enabled_flag = 'Y') THEN

Line 204: Raise FND_API.g_EXC_ERROR;

200: FND_MESSAGE.SET_NAME('INV','INV_TRACKING_OPM_BOM_ATTR');
201: IF NVL(p_context,'N') = 'N' THEN
202: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
203: END IF;
204: Raise FND_API.g_EXC_ERROR;
205: END IF;
206:
207: IF p_serial_number_control_code > 1 THEN
208: x_msg_count := x_msg_count + 1;

Line 213: Raise FND_API.g_EXC_ERROR;

209: FND_MESSAGE.SET_NAME('INV','INV_INVALID_TRACKING_QTY_IND');
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: END IF;
216:
217: IF ( p_tracking_quantity_ind = 'P'

Line 225: Raise FND_API.g_EXC_ERROR;

221: FND_MESSAGE.SET_NAME('INV','INV_SEC_DEFULT_IS_FIXED');
222: IF NVL(p_context,'N') = 'N' THEN
223: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
224: END IF;
225: Raise FND_API.g_EXC_ERROR;
226: END IF;
227:
228: --Bug 5330093 Begin
229: -- Confirming if "Positive Deviation" and "Negative Deviation" are 0

Line 242: Raise FND_API.g_EXC_ERROR;

238: --{
239: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
240: --}
241: END IF;
242: Raise FND_API.g_EXC_ERROR;
243: --}
244: END IF;
245: --}
246: END IF;

Line 266: Raise FND_API.g_EXC_ERROR;

262: FND_MESSAGE.SET_NAME('INV','INV_IOI_INVALID_TAX_CODE_ORG');
263: IF NVL(p_context,'N') = 'N' THEN
264: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
265: END IF;
266: Raise FND_API.g_EXC_ERROR;
267: END;
268: END IF;
269:
270: --Bug 5662813

Line 288: Raise FND_API.g_EXC_ERROR;

284: FND_MESSAGE.SET_NAME('INV','INV_IOI_PUR_TAX_CODE');
285: IF NVL(p_context,'N') = 'N' THEN
286: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
287: END IF;
288: Raise FND_API.g_EXC_ERROR;
289: END;
290: END IF;
291:
292:

Line 307: Raise FND_API.g_EXC_ERROR;

303: FND_MESSAGE.SET_NAME('INV','INV_IOI_BASE_ITEM_ID');
304: IF NVL(p_context,'N') = 'N' THEN
305: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
306: END IF;
307: Raise FND_API.g_EXC_ERROR;
308: END;
309: END IF;
310:
311: EXCEPTION

Line 312: WHEN FND_API.g_EXC_ERROR THEN

308: END;
309: END IF;
310:
311: EXCEPTION
312: WHEN FND_API.g_EXC_ERROR THEN
313: x_return_status := l_ret_sts_error;
314: IF NVL(p_context,'N') = 'BOM' THEN
315: x_error_code := fnd_message.get;
316: END IF;

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

330: ,x_return_status OUT NOCOPY VARCHAR
331: ,x_msg_count OUT NOCOPY NUMBER)
332: IS
333: l_item_rec INV_ITEM_API.Item_rec_type := NULL;
334: l_return_status VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS;
335: l_sysdate DATE := SYSDATE;
336: l_rowid ROWID := NULL;
337: l_inv_id NUMBER := INV_ITEM_UTIL.g_Appl_Inst.inv;
338: l_error_table INV_ITEM_GRP.Error_tbl_type;

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

336: l_rowid ROWID := NULL;
337: l_inv_id NUMBER := INV_ITEM_UTIL.g_Appl_Inst.inv;
338: l_error_table INV_ITEM_GRP.Error_tbl_type;
339: l_error_index BINARY_INTEGER := 1;
340: l_ret_sts_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
341: l_ret_sts_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
342: l_item_org_valid VARCHAR2(1);
343: l_org_valid_count NUMBER;
344: l_item_id NUMBER;

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

337: l_inv_id NUMBER := INV_ITEM_UTIL.g_Appl_Inst.inv;
338: l_error_table INV_ITEM_GRP.Error_tbl_type;
339: l_error_index BINARY_INTEGER := 1;
340: l_ret_sts_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
341: l_ret_sts_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
342: l_item_org_valid VARCHAR2(1);
343: l_org_valid_count NUMBER;
344: l_item_id NUMBER;
345: l_master_status MTL_SYSTEM_ITEMS_B.APPROVAL_STATUS%TYPE;

Line 541: IF l_item_org_valid = FND_API.g_RET_STS_SUCCESS THEN

537: p_item_org_assign_tab(i).status := l_item_org_valid;
538: END IF;
539: END LOOP;
540:
541: IF l_item_org_valid = FND_API.g_RET_STS_SUCCESS THEN
542: INV_ITEM_PVT.CREATE_ITEM
543: (P_Item_Rec => l_Item_Rec
544: ,P_Item_Category_Struct_Id => NULL
545: ,P_Inv_Install => l_inv_id

Line 588: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

584: END IF;
585: END IF;
586:
587: EXCEPTION
588: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
589: x_msg_count := x_msg_count + 1;
590: EGO_Item_Msg.Add_Error_Text(x_msg_count,org_assign_rec.organization_code ||' : '||fnd_message.get);
591: IF l_return_status <> l_ret_sts_unexp_error THEN
592: l_return_status := l_ret_sts_error;