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 98: FND_MESSAGE.SET_NAME('INV','INV_OS_ASMBLY_INVALID_ORG');

94: IF (NOT( l_eam_enabled_flag = 'N' AND
95: l_wms_enabled_flag = 'N' AND
96: l_process_enabled_flag = 'N')) THEN
97: x_msg_count := x_msg_count + 1;
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;

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

96: l_process_enabled_flag = 'N')) THEN
97: x_msg_count := x_msg_count + 1;
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

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

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

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

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

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

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

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

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

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

123: IF (NOT( l_eam_enabled_flag = 'N' AND
124: l_wms_enabled_flag = 'N' AND
125: l_process_enabled_flag = 'N')) THEN
126: x_msg_count := x_msg_count + 1;
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;

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

125: l_process_enabled_flag = 'N')) THEN
126: x_msg_count := x_msg_count + 1;
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;

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

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

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

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

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

144: AND p_ont_pricing_qty_source = 'P') THEN
145:
146: IF p_secondary_default_ind IS NOT NULL THEN
147: x_msg_count := x_msg_count + 1;
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;

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

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

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

153: END IF;
154:
155: IF p_secondary_uom_code IS NOT NULL THEN
156: x_msg_count := x_msg_count + 1;
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;

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

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

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

163:
164: IF ( p_dual_uom_deviation_high <> 0
165: OR p_dual_uom_deviation_low <> 0 )THEN
166: x_msg_count := x_msg_count + 1;
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;

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

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

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

174:
175: IF ( ( p_tracking_quantity_ind = 'PS' OR p_ont_pricing_qty_source = 'S')
176: AND ( p_secondary_default_ind IS NULL OR p_secondary_uom_code IS NULL ) )THEN
177: x_msg_count := x_msg_count + 1;
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;

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

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

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

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

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

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

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

193: END IF;
194:
195: IF p_serial_number_control_code > 1 THEN
196: x_msg_count := x_msg_count + 1;
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;

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

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

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

205: IF ( p_tracking_quantity_ind = 'P'
206: AND p_secondary_default_ind NOT IN ('D','N') ) THEN
207:
208: x_msg_count := x_msg_count + 1;
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;

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

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

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

220: --{
221: IF ( p_dual_uom_deviation_high <> 0 OR p_dual_uom_deviation_low <> 0 )THEN
222: --{
223: x_msg_count := x_msg_count + 1;
224: FND_MESSAGE.SET_NAME('INV','INV_UOM_DEV_IS_NOT_ZERO');
225: IF NVL(p_context,'N') = 'N' THEN
226: --{
227: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);
228: --}

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

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

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

246: AND rownum = 1;
247: EXCEPTION
248: WHEN no_data_found THEN
249: x_msg_count := x_msg_count + 1;
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;

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

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

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

268: AND rownum = 1;
269: EXCEPTION
270: WHEN no_data_found THEN
271: x_msg_count := x_msg_count + 1;
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;

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

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

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

287: AND organization_id = p_organization_id;
288: EXCEPTION
289: WHEN NO_DATA_FOUND THEN
290: x_msg_count := x_msg_count + 1;
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;

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

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

Line 303: x_error_code := fnd_message.get;

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;
305: WHEN OTHERS THEN
306: x_return_status := l_ret_sts_unexp_error;
307: x_msg_count := x_msg_count + 1;

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

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;
572: END IF;
573: WHEN OTHERS THEN