121: EXCEPTION
122: WHEN NO_DATA_FOUND THEN
123: NULL;
124: /*
125: FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
126: FND_MESSAGE.SET_TOKEN('VALUE', IC_ITEM_ID);
127: FND_MESSAGE.SET_TOKEN('VSET_ID', '103099');
128: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
129: return FALSE; */
122: WHEN NO_DATA_FOUND THEN
123: NULL;
124: /*
125: FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
126: FND_MESSAGE.SET_TOKEN('VALUE', IC_ITEM_ID);
127: FND_MESSAGE.SET_TOKEN('VSET_ID', '103099');
128: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
129: return FALSE; */
130: END;
123: NULL;
124: /*
125: FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
126: FND_MESSAGE.SET_TOKEN('VALUE', IC_ITEM_ID);
127: FND_MESSAGE.SET_TOKEN('VSET_ID', '103099');
128: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
129: return FALSE; */
130: END;
131: END IF;
124: /*
125: FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
126: FND_MESSAGE.SET_TOKEN('VALUE', IC_ITEM_ID);
127: FND_MESSAGE.SET_TOKEN('VSET_ID', '103099');
128: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
129: return FALSE; */
130: END;
131: END IF;
132:
146: FROM oe_order_lines_all
147: WHERE line_id = TO_NUMBER(ic_order_line_id);
148: EXCEPTION
149: WHEN NO_DATA_FOUND THEN
150: fnd_message.set_name('FND', 'FLEX-BUILD INVALID VALUE');
151: fnd_message.set_token('VALUE', ic_order_line_id);
152: fnd_message.set_token('VSET_ID', '000000');
153: fb_error_msg := fnd_message.get_encoded;
154: RETURN FALSE;
147: WHERE line_id = TO_NUMBER(ic_order_line_id);
148: EXCEPTION
149: WHEN NO_DATA_FOUND THEN
150: fnd_message.set_name('FND', 'FLEX-BUILD INVALID VALUE');
151: fnd_message.set_token('VALUE', ic_order_line_id);
152: fnd_message.set_token('VSET_ID', '000000');
153: fb_error_msg := fnd_message.get_encoded;
154: RETURN FALSE;
155: END;
148: EXCEPTION
149: WHEN NO_DATA_FOUND THEN
150: fnd_message.set_name('FND', 'FLEX-BUILD INVALID VALUE');
151: fnd_message.set_token('VALUE', ic_order_line_id);
152: fnd_message.set_token('VSET_ID', '000000');
153: fb_error_msg := fnd_message.get_encoded;
154: RETURN FALSE;
155: END;
156: END IF;
149: WHEN NO_DATA_FOUND THEN
150: fnd_message.set_name('FND', 'FLEX-BUILD INVALID VALUE');
151: fnd_message.set_token('VALUE', ic_order_line_id);
152: fnd_message.set_token('VSET_ID', '000000');
153: fb_error_msg := fnd_message.get_encoded;
154: RETURN FALSE;
155: END;
156: END IF;
157:
176:
177: print_debug('Found v_acrual_acct: ' || v_order_type_cogs, l_function_name);
178: EXCEPTION
179: WHEN NO_DATA_FOUND THEN
180: fnd_message.set_name('FND', 'FLEX-BUILD INVALID VALUE');
181: fnd_message.set_token('VALUE', ic_order_type_id);
182: fnd_message.set_token('VSET_ID', '103100');
183: fb_error_msg := fnd_message.get_encoded;
184: RETURN FALSE;
177: print_debug('Found v_acrual_acct: ' || v_order_type_cogs, l_function_name);
178: EXCEPTION
179: WHEN NO_DATA_FOUND THEN
180: fnd_message.set_name('FND', 'FLEX-BUILD INVALID VALUE');
181: fnd_message.set_token('VALUE', ic_order_type_id);
182: fnd_message.set_token('VSET_ID', '103100');
183: fb_error_msg := fnd_message.get_encoded;
184: RETURN FALSE;
185: END;
178: EXCEPTION
179: WHEN NO_DATA_FOUND THEN
180: fnd_message.set_name('FND', 'FLEX-BUILD INVALID VALUE');
181: fnd_message.set_token('VALUE', ic_order_type_id);
182: fnd_message.set_token('VSET_ID', '103100');
183: fb_error_msg := fnd_message.get_encoded;
184: RETURN FALSE;
185: END;
186: ELSE
179: WHEN NO_DATA_FOUND THEN
180: fnd_message.set_name('FND', 'FLEX-BUILD INVALID VALUE');
181: fnd_message.set_token('VALUE', ic_order_type_id);
182: fnd_message.set_token('VSET_ID', '103100');
183: fb_error_msg := fnd_message.get_encoded;
184: RETURN FALSE;
185: END;
186: ELSE
187: l_err_pt := '20.5';
196:
197: print_debug('Found v_order_type_cogs: ' || v_order_type_cogs, l_function_name);
198: EXCEPTION
199: WHEN NO_DATA_FOUND THEN
200: fnd_message.set_name('FND', 'FLEX-BUILD INVALID VALUE');
201: fnd_message.set_token('VALUE', ic_order_type_id);
202: fnd_message.set_token('VSET_ID', '103100');
203: fb_error_msg := fnd_message.get_encoded;
204: RETURN FALSE;
197: print_debug('Found v_order_type_cogs: ' || v_order_type_cogs, l_function_name);
198: EXCEPTION
199: WHEN NO_DATA_FOUND THEN
200: fnd_message.set_name('FND', 'FLEX-BUILD INVALID VALUE');
201: fnd_message.set_token('VALUE', ic_order_type_id);
202: fnd_message.set_token('VSET_ID', '103100');
203: fb_error_msg := fnd_message.get_encoded;
204: RETURN FALSE;
205: END;
198: EXCEPTION
199: WHEN NO_DATA_FOUND THEN
200: fnd_message.set_name('FND', 'FLEX-BUILD INVALID VALUE');
201: fnd_message.set_token('VALUE', ic_order_type_id);
202: fnd_message.set_token('VSET_ID', '103100');
203: fb_error_msg := fnd_message.get_encoded;
204: RETURN FALSE;
205: END;
206: END IF;
199: WHEN NO_DATA_FOUND THEN
200: fnd_message.set_name('FND', 'FLEX-BUILD INVALID VALUE');
201: fnd_message.set_token('VALUE', ic_order_type_id);
202: fnd_message.set_token('VSET_ID', '103100');
203: fb_error_msg := fnd_message.get_encoded;
204: RETURN FALSE;
205: END;
206: END IF;
207: END IF;
220: WHERE organization_id = ic_to_inv_organization_id;
221: EXCEPTION
222: WHEN NO_DATA_FOUND THEN
223: NULL;
224: /* FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
225: FND_MESSAGE.SET_TOKEN('VALUE', IC_SELL_OPER_UNIT);
226: FND_MESSAGE.SET_TOKEN('VSET_ID', '103101');
227: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
228: return FALSE;*/
221: EXCEPTION
222: WHEN NO_DATA_FOUND THEN
223: NULL;
224: /* FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
225: FND_MESSAGE.SET_TOKEN('VALUE', IC_SELL_OPER_UNIT);
226: FND_MESSAGE.SET_TOKEN('VSET_ID', '103101');
227: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
228: return FALSE;*/
229: END;
222: WHEN NO_DATA_FOUND THEN
223: NULL;
224: /* FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
225: FND_MESSAGE.SET_TOKEN('VALUE', IC_SELL_OPER_UNIT);
226: FND_MESSAGE.SET_TOKEN('VSET_ID', '103101');
227: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
228: return FALSE;*/
229: END;
230: END IF;
223: NULL;
224: /* FND_MESSAGE.SET_NAME('FND', 'FLEX-BUILD INVALID VALUE');
225: FND_MESSAGE.SET_TOKEN('VALUE', IC_SELL_OPER_UNIT);
226: FND_MESSAGE.SET_TOKEN('VSET_ID', '103101');
227: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
228: return FALSE;*/
229: END;
230: END IF;
231:
343: );
344: print_debug('fnd_flex_ext.get_ccid returned' || TO_CHAR(v_ccid), l_function_name);
345:
346: IF (v_ccid = 0) THEN
347: fb_error_msg := SUBSTR(fnd_message.get_encoded, 1, 240);
348: print_debug('fnd_flex_ext.get_ccid returned no ccid.', l_function_name);
349: RETURN FALSE;
350: END IF;
351: END IF;
361: EXCEPTION
362: WHEN OTHERS THEN
363: l_err_pt := '53';
364: print_debug('Unexpected error at l_err_pt: ' || l_err_pt, l_function_name);
365: fnd_message.set_name('INV', 'INV_UNHANDLED_ERR');
366: fnd_message.set_token('ENTITY1', l_function_name);
367: v_buffer := TO_CHAR(SQLCODE) || ' ' || SUBSTR(SQLERRM, 1, 150);
368: fnd_message.set_token('ENTITY2', v_buffer);
369: fb_error_msg := SUBSTR(fnd_message.get_encoded, 1, 240);
362: WHEN OTHERS THEN
363: l_err_pt := '53';
364: print_debug('Unexpected error at l_err_pt: ' || l_err_pt, l_function_name);
365: fnd_message.set_name('INV', 'INV_UNHANDLED_ERR');
366: fnd_message.set_token('ENTITY1', l_function_name);
367: v_buffer := TO_CHAR(SQLCODE) || ' ' || SUBSTR(SQLERRM, 1, 150);
368: fnd_message.set_token('ENTITY2', v_buffer);
369: fb_error_msg := SUBSTR(fnd_message.get_encoded, 1, 240);
370: print_debug('Error message: ' || fb_error_msg, l_function_name);
364: print_debug('Unexpected error at l_err_pt: ' || l_err_pt, l_function_name);
365: fnd_message.set_name('INV', 'INV_UNHANDLED_ERR');
366: fnd_message.set_token('ENTITY1', l_function_name);
367: v_buffer := TO_CHAR(SQLCODE) || ' ' || SUBSTR(SQLERRM, 1, 150);
368: fnd_message.set_token('ENTITY2', v_buffer);
369: fb_error_msg := SUBSTR(fnd_message.get_encoded, 1, 240);
370: print_debug('Error message: ' || fb_error_msg, l_function_name);
371: RETURN FALSE;
372: END generate_cogs;
365: fnd_message.set_name('INV', 'INV_UNHANDLED_ERR');
366: fnd_message.set_token('ENTITY1', l_function_name);
367: v_buffer := TO_CHAR(SQLCODE) || ' ' || SUBSTR(SQLERRM, 1, 150);
368: fnd_message.set_token('ENTITY2', v_buffer);
369: fb_error_msg := SUBSTR(fnd_message.get_encoded, 1, 240);
370: print_debug('Error message: ' || fb_error_msg, l_function_name);
371: RETURN FALSE;
372: END generate_cogs;
373: