DBA Data[Home] [Help]

APPS.INV_SERIAL_NUMBER_ATTR dependencies on FND_MSG_PUB

Line 87: fnd_msg_pub.ADD;

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:
91: -- Initialize savepoint

Line 183: fnd_msg_pub.ADD;

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');
187: END IF;

Line 257: fnd_msg_pub.ADD;

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
261: print_debug('Req segment is not populated');

Line 301: fnd_msg_pub.ADD;

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

Line 394: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

390:
391: EXCEPTION
392: WHEN serial_not_found THEN
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
395:
396: WHEN errors_received THEN
397: x_return_status := FND_API.G_RET_STS_ERROR;
398: error_msg := fnd_flex_descval.error_message;

Line 407: fnd_msg_pub.ADD;

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;
411: END LOOP;

Line 414: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

410: e := e + 200;
411: END LOOP;
412:
413: ROLLBACK TO get_serial_attr_information;
414: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
415: WHEN FND_API.G_EXC_ERROR THEN
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: ROLLBACK TO get_serial_attr_information;
418: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 418: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

414: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
415: WHEN FND_API.G_EXC_ERROR THEN
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: ROLLBACK TO get_serial_attr_information;
418: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: ROLLBACK TO get_serial_attr_information;
422: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 422: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

418: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: ROLLBACK TO get_serial_attr_information;
422: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
423: WHEN OTHERS THEN
424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
425: ROLLBACK TO get_serial_attr_information;
426: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 426: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

422: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
423: WHEN OTHERS THEN
424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
425: ROLLBACK TO get_serial_attr_information;
426: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
427: print_debug('Error ' || SQLERRM);
428: END Update_Serial_number_attr;
429:
430: END INV_SERIAL_NUMBER_ATTR;