DBA Data[Home] [Help]

APPS.EGO_ITEM_ORG_ASSIGN_PVT dependencies on FND_MESSAGE

Line 63: FND_MESSAGE.SET_NAME('INV','INV_IOI_UNAPPROVED_ITEM_ORG');

59: x_msg_count := 0;
60:
61: IF p_master_status <> 'A' THEN
62: x_msg_count := x_msg_count + 1;
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;

Line 65: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);

61: IF p_master_status <> 'A' THEN
62: x_msg_count := x_msg_count + 1;
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:

Line 85: FND_MESSAGE.SET_NAME('INV','INV_TRACKING_OPM_BOM_ATTR');

81: p_tracking_quantity_ind = 'PS' AND
82: ( p_bom_enabled_flag = 'Y' OR p_bom_item_type IN (1,2)))
83: THEN
84: x_msg_count := x_msg_count + 1;
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;

Line 87: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);

83: THEN
84: x_msg_count := x_msg_count + 1;
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:

Line 104: FND_MESSAGE.SET_NAME('INV','INV_OS_ASMBLY_INVALID_ORG');

100: l_process_enabled_flag = 'N')) THEN
101: */
102: IF (NOT(l_process_enabled_flag = 'N')) THEN
103: x_msg_count := x_msg_count + 1;
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;

Line 106: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);

102: IF (NOT(l_process_enabled_flag = 'N')) THEN
103: x_msg_count := x_msg_count + 1;
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

Line 112: FND_MESSAGE.SET_NAME('INV','INV_OS_ASMBLY_TP_TIME_FENSE');

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');
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;

Line 114: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);

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');
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;

Line 119: FND_MESSAGE.SET_NAME('INV','INV_OS_ASMBLY_STD_COST_ORG');

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
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;

Line 121: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);

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
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;

Line 139: FND_MESSAGE.SET_NAME('INV','INV_OS_ASMBLY_INVALID_ORG');

135: l_process_enabled_flag = 'N')) THEN
136: */
137: IF (NOT(l_process_enabled_flag = 'N')) THEN
138: x_msg_count := x_msg_count + 1;
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;

Line 141: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);

137: IF (NOT(l_process_enabled_flag = 'N')) THEN
138: x_msg_count := x_msg_count + 1;
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;

Line 146: FND_MESSAGE.SET_NAME('INV','INV_OS_ASMBLY_STD_COST_ORG');

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
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;

Line 148: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);

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
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;

Line 160: FND_MESSAGE.SET_NAME('INV','INV_SEC_DEFAULT_NOT_NULL');

156: AND p_ont_pricing_qty_source = 'P') THEN
157:
158: IF p_secondary_default_ind IS NOT NULL THEN
159: x_msg_count := x_msg_count + 1;
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;

Line 162: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);

158: IF p_secondary_default_ind IS NOT NULL THEN
159: x_msg_count := x_msg_count + 1;
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:

Line 169: FND_MESSAGE.SET_NAME('INV','INV_SEC_UOM_IS_NOT_NULL');

165: END IF;
166:
167: IF p_secondary_uom_code IS NOT NULL THEN
168: x_msg_count := x_msg_count + 1;
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;

Line 171: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);

167: IF p_secondary_uom_code IS NOT NULL THEN
168: x_msg_count := x_msg_count + 1;
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:

Line 179: FND_MESSAGE.SET_NAME('INV','INV_UOM_DEV_IS_NOT_ZERO');

175:
176: IF ( p_dual_uom_deviation_high <> 0
177: OR p_dual_uom_deviation_low <> 0 )THEN
178: x_msg_count := x_msg_count + 1;
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;

Line 181: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);

177: OR p_dual_uom_deviation_low <> 0 )THEN
178: x_msg_count := x_msg_count + 1;
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;

Line 190: FND_MESSAGE.SET_NAME('INV','INV_REQUIRED_FIELDS');

186:
187: IF ( ( p_tracking_quantity_ind = 'PS' OR p_ont_pricing_qty_source = 'S')
188: AND ( p_secondary_default_ind IS NULL OR p_secondary_uom_code IS NULL ) )THEN
189: x_msg_count := x_msg_count + 1;
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;

Line 192: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);

188: AND ( p_secondary_default_ind IS NULL OR p_secondary_uom_code IS NULL ) )THEN
189: x_msg_count := x_msg_count + 1;
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:

Line 200: FND_MESSAGE.SET_NAME('INV','INV_TRACKING_OPM_BOM_ATTR');

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
199: x_msg_count := x_msg_count + 1;
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;

Line 202: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);

198: IF (p_bom_item_type IN (1,2) OR p_bom_enabled_flag = 'Y') THEN
199: x_msg_count := x_msg_count + 1;
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:

Line 209: FND_MESSAGE.SET_NAME('INV','INV_INVALID_TRACKING_QTY_IND');

205: END IF;
206:
207: IF p_serial_number_control_code > 1 THEN
208: x_msg_count := x_msg_count + 1;
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;

Line 211: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);

207: IF p_serial_number_control_code > 1 THEN
208: x_msg_count := x_msg_count + 1;
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;

Line 221: FND_MESSAGE.SET_NAME('INV','INV_SEC_DEFULT_IS_FIXED');

217: IF ( p_tracking_quantity_ind = 'P'
218: AND p_secondary_default_ind NOT IN ('D','N') ) THEN
219:
220: x_msg_count := x_msg_count + 1;
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;

Line 223: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);

219:
220: x_msg_count := x_msg_count + 1;
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:

Line 236: FND_MESSAGE.SET_NAME('INV','INV_UOM_DEV_IS_NOT_ZERO');

232: --{
233: IF ( p_dual_uom_deviation_high <> 0 OR p_dual_uom_deviation_low <> 0 )THEN
234: --{
235: x_msg_count := x_msg_count + 1;
236: FND_MESSAGE.SET_NAME('INV','INV_UOM_DEV_IS_NOT_ZERO');
237: IF NVL(p_context,'N') = 'N' THEN
238: --{
239: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
240: --}

Line 239: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);

235: x_msg_count := x_msg_count + 1;
236: FND_MESSAGE.SET_NAME('INV','INV_UOM_DEV_IS_NOT_ZERO');
237: IF NVL(p_context,'N') = 'N' THEN
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: --}

Line 262: FND_MESSAGE.SET_NAME('INV','INV_IOI_INVALID_TAX_CODE_ORG');

258: AND rownum = 1;
259: EXCEPTION
260: WHEN no_data_found THEN
261: x_msg_count := x_msg_count + 1;
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;

Line 264: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);

260: WHEN no_data_found THEN
261: x_msg_count := x_msg_count + 1;
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;

Line 284: FND_MESSAGE.SET_NAME('INV','INV_IOI_PUR_TAX_CODE');

280: AND rownum = 1;
281: EXCEPTION
282: WHEN no_data_found THEN
283: x_msg_count := x_msg_count + 1;
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;

Line 286: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);

282: WHEN no_data_found THEN
283: x_msg_count := x_msg_count + 1;
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;

Line 303: FND_MESSAGE.SET_NAME('INV','INV_IOI_BASE_ITEM_ID');

299: AND organization_id = p_organization_id;
300: EXCEPTION
301: WHEN NO_DATA_FOUND THEN
302: x_msg_count := x_msg_count + 1;
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;

Line 305: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);

301: WHEN NO_DATA_FOUND THEN
302: x_msg_count := x_msg_count + 1;
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;

Line 315: x_error_code := fnd_message.get;

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;
317: WHEN OTHERS THEN
318: x_return_status := l_ret_sts_unexp_error;
319: x_msg_count := x_msg_count + 1;

Line 590: EGO_Item_Msg.Add_Error_Text(x_msg_count,org_assign_rec.organization_code ||' : '||fnd_message.get);

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;
593: END IF;
594: WHEN OTHERS THEN