81: IF (g_debug = 1) THEN
82: print_debug('no data found for the serial');
83: END IF;
84:
85: fnd_message.set_name('INV', 'INV_SER_NOTEXIST');
86: fnd_message.set_token('TOKEN', p_serial_number);
87: fnd_msg_pub.ADD;
88: RAISE serial_not_found;
89: END;
82: print_debug('no data found for the serial');
83: END IF;
84:
85: fnd_message.set_name('INV', 'INV_SER_NOTEXIST');
86: fnd_message.set_token('TOKEN', p_serial_number);
87: fnd_msg_pub.ADD;
88: RAISE serial_not_found;
89: END;
90:
177:
178: IF l_segments_dr.is_required(i) THEN
179: IF NOT p_attributes_tbl.EXISTS(SUBSTR(l_segments_dr.application_column_name(i)
180: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9)) THEN
181: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
182: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
183: fnd_msg_pub.ADD;
184:
185: IF g_debug = 1 THEN
178: IF l_segments_dr.is_required(i) THEN
179: IF NOT p_attributes_tbl.EXISTS(SUBSTR(l_segments_dr.application_column_name(i)
180: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9)) THEN
181: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
182: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
183: fnd_msg_pub.ADD;
184:
185: IF g_debug = 1 THEN
186: print_debug('Req segment is not populated');
251:
252: IF l_segments_dr.is_required(i) THEN
253: IF NOT p_attributes_tbl.EXISTS(SUBSTR(l_segments_dr.application_column_name(i)
254: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9)) THEN
255: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
256: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
257: fnd_msg_pub.ADD;
258: RAISE FND_API.G_EXC_ERROR;
259:
252: IF l_segments_dr.is_required(i) THEN
253: IF NOT p_attributes_tbl.EXISTS(SUBSTR(l_segments_dr.application_column_name(i)
254: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9)) THEN
255: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
256: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
257: fnd_msg_pub.ADD;
258: RAISE FND_API.G_EXC_ERROR;
259:
260: IF g_debug = 1 THEN
294: END IF;
295: END LOOP;
296:
297: IF l_chk_flag = 0 AND p_attributes_tbl(v_index1) IS NOT NULL THEN
298: fnd_message.set_name('INV', 'INV_WRONG_SEG_POPULATE');
299: fnd_message.set_token('SEGMENT', 'ATTRIBUTE' || v_index1);
300: fnd_message.set_token('CONTEXT', l_context);
301: fnd_msg_pub.ADD;
302: --print_debug('Error out. Correct segmenst are not populated ');
295: END LOOP;
296:
297: IF l_chk_flag = 0 AND p_attributes_tbl(v_index1) IS NOT NULL THEN
298: fnd_message.set_name('INV', 'INV_WRONG_SEG_POPULATE');
299: fnd_message.set_token('SEGMENT', 'ATTRIBUTE' || v_index1);
300: fnd_message.set_token('CONTEXT', l_context);
301: fnd_msg_pub.ADD;
302: --print_debug('Error out. Correct segmenst are not populated ');
303: RAISE FND_API.G_EXC_ERROR;
296:
297: IF l_chk_flag = 0 AND p_attributes_tbl(v_index1) IS NOT NULL THEN
298: fnd_message.set_name('INV', 'INV_WRONG_SEG_POPULATE');
299: fnd_message.set_token('SEGMENT', 'ATTRIBUTE' || v_index1);
300: fnd_message.set_token('CONTEXT', l_context);
301: fnd_msg_pub.ADD;
302: --print_debug('Error out. Correct segmenst are not populated ');
303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
401:
402: print_debug('Here are the error messages: ');
403: WHILE e < 5001
404: AND SUBSTR(error_msg, s, e) IS NOT NULL LOOP
405: fnd_message.set_name('INV', 'INV_FND_GENERIC_MSG');
406: fnd_message.set_token('MSG', SUBSTR(error_msg, s, e));
407: fnd_msg_pub.ADD;
408: print_debug(SUBSTR(error_msg, s, e));
409: s := s + 200;
402: print_debug('Here are the error messages: ');
403: WHILE e < 5001
404: AND SUBSTR(error_msg, s, e) IS NOT NULL LOOP
405: fnd_message.set_name('INV', 'INV_FND_GENERIC_MSG');
406: fnd_message.set_token('MSG', SUBSTR(error_msg, s, e));
407: fnd_msg_pub.ADD;
408: print_debug(SUBSTR(error_msg, s, e));
409: s := s + 200;
410: e := e + 200;