eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_SERIAL_NUMBER_PUB dependencies on FND_MSG_PUB

Line 172: fnd_msg_pub.initialize;

168: END IF;
169:
170: -- Initialize message list if p_init_msg_list is set to TRUE.
171: IF fnd_api.to_boolean(p_init_msg_list) THEN
172: fnd_msg_pub.initialize;
173: END IF;
174:
175: -- Initialize API return status to success
176: -- API body

Line 189: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

185: WHEN NO_DATA_FOUND THEN
186: item_count := 0;
187: WHEN OTHERS THEN
188: --Bug 3153585:Raising exception to populate error message correctly.
189: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
190: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
191: END IF;
192:
193: RAISE fnd_api.g_exc_unexpected_error;

Line 190: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');

186: item_count := 0;
187: WHEN OTHERS THEN
188: --Bug 3153585:Raising exception to populate error message correctly.
189: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
190: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
191: END IF;
192:
193: RAISE fnd_api.g_exc_unexpected_error;
194: END;

Line 198: fnd_msg_pub.ADD;

194: END;
195:
196: IF (item_count = 0) THEN
197: fnd_message.set_name('INV', 'INV_INVALID_ORGANIZATION');
198: fnd_msg_pub.ADD;
199: --Bug 3153585:Raising exception to populate error message correctly.
200: RAISE fnd_api.g_exc_error;
201: END IF;
202:

Line 215: fnd_msg_pub.ADD;

211: AND organization_id = p_organization_id;
212:
213: IF (l_serial_control_code = 1) THEN
214: fnd_message.set_name('INV', 'INV_ITEM_NOT_SERIAL_CONTROLLED');
215: fnd_msg_pub.ADD;
216: --Bug 3153585:Raising exception to populate error message correctly.
217: RAISE fnd_api.g_exc_error;
218: END IF;
219:

Line 231: fnd_msg_pub.ADD;

227: RAISE fnd_api.g_exc_error;
228: --Bug 3153585:Raising exception to populate error message correctly.
229: WHEN NO_DATA_FOUND THEN
230: fnd_message.set_name('INV', 'INV_INVALID_ITEM');
231: fnd_msg_pub.ADD;
232: --Bug 3153585:Raising exception to populate error message correctly.
233: RAISE fnd_api.g_exc_error;
234: WHEN OTHERS THEN
235: --Bug 3152585:Raising Exception to populate error message correctly.

Line 236: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

232: --Bug 3153585:Raising exception to populate error message correctly.
233: RAISE fnd_api.g_exc_error;
234: WHEN OTHERS THEN
235: --Bug 3152585:Raising Exception to populate error message correctly.
236: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
237: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
238: END IF;
239:
240: RAISE fnd_api.g_exc_unexpected_error;

Line 237: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');

233: RAISE fnd_api.g_exc_error;
234: WHEN OTHERS THEN
235: --Bug 3152585:Raising Exception to populate error message correctly.
236: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
237: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
238: END IF;
239:
240: RAISE fnd_api.g_exc_unexpected_error;
241: END;

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

300: COMMIT WORK;
301: END IF;
302:
303: -- Standard call to get message count and if count is 1, get message info.
304: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
305: EXCEPTION
306: WHEN fnd_api.g_exc_error THEN
307: ROLLBACK TO apiinsertserial_apipub;
308: --Bug 3153585:Populating the message from the message stack

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

305: EXCEPTION
306: WHEN fnd_api.g_exc_error THEN
307: ROLLBACK TO apiinsertserial_apipub;
308: --Bug 3153585:Populating the message from the message stack
309: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
310: x_return_status := fnd_api.g_ret_sts_error;
311: WHEN fnd_api.g_exc_unexpected_error THEN
312: --Bug 3153585:Populating the message from the message stack
313: ROLLBACK TO apiinsertserial_apipub;

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

310: x_return_status := fnd_api.g_ret_sts_error;
311: WHEN fnd_api.g_exc_unexpected_error THEN
312: --Bug 3153585:Populating the message from the message stack
313: ROLLBACK TO apiinsertserial_apipub;
314: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
315: x_return_status := fnd_api.g_ret_sts_unexp_error;
316: WHEN OTHERS THEN
317: ROLLBACK TO apiinsertserial_apipub;
318:

Line 319: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

315: x_return_status := fnd_api.g_ret_sts_unexp_error;
316: WHEN OTHERS THEN
317: ROLLBACK TO apiinsertserial_apipub;
318:
319: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
320: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
321: END IF;
322:
323: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 320: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');

316: WHEN OTHERS THEN
317: ROLLBACK TO apiinsertserial_apipub;
318:
319: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
320: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
321: END IF;
322:
323: x_return_status := fnd_api.g_ret_sts_unexp_error;
324: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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

320: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
321: END IF;
322:
323: x_return_status := fnd_api.g_ret_sts_unexp_error;
324: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
325: END insertserial;
326:
327: -- 'Serial Tracking in WIP project. insert wip_entity_id, operation_seq_num and intraoperation_step_type
328: -- into MSN.

Line 460: fnd_msg_pub.initialize;

456: END IF;
457:
458: -- Initialize message list if p_init_msg_list is set to TRUE.
459: IF fnd_api.to_boolean(p_init_msg_list) THEN
460: fnd_msg_pub.initialize;
461: END IF;
462:
463: /** ssia we don't need this if condition **/
464: /*IF (p_transaction_action_id = 3 AND g_firstscan = FALSE) THEN*/

Line 480: fnd_msg_pub.ADD;

476: -- invtrace('serial_number_control_code is ' || l_serial_control_code);
477: IF (l_serial_control_code = 1) THEN
478: -- invtrace('serial_control_code is 1.there is no serial control.');
479: fnd_message.set_name('INV', 'INV_ITEM_NOT_SERIAL_CONTROLLED');
480: fnd_msg_pub.ADD;
481: --Bug 3153585:Populating the message from the message stack
482: RAISE fnd_api.g_exc_error;
483: END IF;
484: EXCEPTION

Line 487: fnd_msg_pub.ADD;

483: END IF;
484: EXCEPTION
485: WHEN NO_DATA_FOUND THEN
486: fnd_message.set_name('INV', 'INV_INVALID_ITEM');
487: fnd_msg_pub.ADD;
488: RAISE fnd_api.g_exc_error;
489: END;
490:
491: SELECT mtl_gen_object_id_s.NEXTVAL

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

1238: COMMIT WORK;
1239: END IF;
1240:
1241: -- Standard call to get message count and if count is 1, get message info.
1242: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1243: EXCEPTION
1244: WHEN fnd_api.g_exc_error THEN
1245: ROLLBACK TO apiinsertserial_apipub;
1246: --Bug 3153585:Populating x_msg_data from message stack

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

1243: EXCEPTION
1244: WHEN fnd_api.g_exc_error THEN
1245: ROLLBACK TO apiinsertserial_apipub;
1246: --Bug 3153585:Populating x_msg_data from message stack
1247: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1248: x_return_status := fnd_api.g_ret_sts_error;
1249: WHEN OTHERS THEN
1250: ROLLBACK TO apiinsertserial_apipub;
1251:

Line 1252: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1248: x_return_status := fnd_api.g_ret_sts_error;
1249: WHEN OTHERS THEN
1250: ROLLBACK TO apiinsertserial_apipub;
1251:
1252: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1253: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
1254: END IF;
1255:
1256: --Bug 3153585:Populating x_msg_data from message stack

Line 1253: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');

1249: WHEN OTHERS THEN
1250: ROLLBACK TO apiinsertserial_apipub;
1251:
1252: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1253: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
1254: END IF;
1255:
1256: --Bug 3153585:Populating x_msg_data from message stack
1257: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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

1253: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
1254: END IF;
1255:
1256: --Bug 3153585:Populating x_msg_data from message stack
1257: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1258: x_return_status := fnd_api.g_ret_sts_unexp_error;
1259: END insertserial;
1260:
1261: PROCEDURE insert_range_serial(

Line 1331: fnd_msg_pub.initialize;

1327: END IF;
1328:
1329: -- Initialize message list if p_init_msg_list is set to TRUE.
1330: IF fnd_api.to_boolean(p_init_msg_list) THEN
1331: fnd_msg_pub.initialize;
1332: END IF;
1333:
1334: -- Initialize API return status to success
1335: x_return_status := fnd_api.g_ret_sts_success;

Line 1419: fnd_msg_pub.ADD;

1415: -- If any serial is in use, then discard the entire range insertion.
1416: IF is_serial_unique(p_org_id => p_organization_id, p_item_id => p_inventory_item_id, p_serial => l_cur_serial_number
1417: , x_proc_msg => l_msg_data) = 1 THEN
1418: fnd_message.set_name('INV', 'INV_SERIAL_USED');
1419: fnd_msg_pub.ADD;
1420: RAISE fnd_api.g_exc_error;
1421: ELSE
1422: -- invtrace('INV_SERIAL_NUMBER_PUB', 'insert_range_serial - 60');
1423: -- uniqueness check passed

Line 1469: fnd_msg_pub.ADD;

1465: );
1466:
1467: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1468: fnd_message.set_name('INV', 'INV_SERIAL');
1469: fnd_msg_pub.ADD;
1470: RAISE fnd_api.g_exc_unexpected_error;
1471: END IF;
1472: END IF;
1473: END IF;

Line 1519: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1515: END IF;
1516:
1517: -- Standard call to get message count and if count is 1,
1518: -- get message info.
1519: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1520: EXCEPTION
1521: WHEN fnd_api.g_exc_error THEN
1522: ROLLBACK TO sp_insert_range_serial;
1523: x_return_status := fnd_api.g_ret_sts_error;

Line 1524: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1520: EXCEPTION
1521: WHEN fnd_api.g_exc_error THEN
1522: ROLLBACK TO sp_insert_range_serial;
1523: x_return_status := fnd_api.g_ret_sts_error;
1524: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1525: WHEN fnd_api.g_exc_unexpected_error THEN
1526: ROLLBACK TO sp_insert_range_serial;
1527: x_return_status := fnd_api.g_ret_sts_unexp_error;
1528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1524: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1525: WHEN fnd_api.g_exc_unexpected_error THEN
1526: ROLLBACK TO sp_insert_range_serial;
1527: x_return_status := fnd_api.g_ret_sts_unexp_error;
1528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1529: WHEN OTHERS THEN
1530: ROLLBACK TO sp_insert_range_serial;
1531: x_return_status := fnd_api.g_ret_sts_unexp_error;
1532: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1532: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1529: WHEN OTHERS THEN
1530: ROLLBACK TO sp_insert_range_serial;
1531: x_return_status := fnd_api.g_ret_sts_unexp_error;
1532: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1533: END insert_range_serial;
1534:
1535: PROCEDURE updateserial(
1536: p_api_version IN NUMBER

Line 1696: fnd_msg_pub.initialize;

1692: END IF;
1693:
1694: -- Initialize message list if p_init_msg_list is set to TRUE.
1695: IF fnd_api.to_boolean(p_init_msg_list) THEN
1696: fnd_msg_pub.initialize;
1697: END IF;
1698:
1699: -- Initialize API return status to success
1700: x_return_status := fnd_api.g_ret_sts_success;

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

2041: COMMIT WORK;
2042: END IF;
2043:
2044: -- Standard call to get message count and if count is 1, get message info.
2045: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2046: EXCEPTION
2047: WHEN OTHERS THEN
2048: ROLLBACK TO apiupdateserial_apipub;
2049:

Line 2050: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2046: EXCEPTION
2047: WHEN OTHERS THEN
2048: ROLLBACK TO apiupdateserial_apipub;
2049:
2050: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2051: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'updateSerial');
2052: END IF;
2053:
2054: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2051: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'updateSerial');

2047: WHEN OTHERS THEN
2048: ROLLBACK TO apiupdateserial_apipub;
2049:
2050: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2051: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'updateSerial');
2052: END IF;
2053:
2054: x_return_status := fnd_api.g_ret_sts_unexp_error;
2055: END updateserial;

Line 2183: fnd_msg_pub.initialize;

2179: END IF;
2180:
2181: -- Initialize message list if p_init_msg_list is set to TRUE.
2182: IF fnd_api.to_boolean(p_init_msg_list) THEN
2183: fnd_msg_pub.initialize;
2184: END IF;
2185:
2186: -- Initialize API return status to success
2187:

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

2987: COMMIT WORK;
2988: END IF;
2989:
2990: -- Standard call to get message count and if count is 1, get message info.
2991: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_msg_data);
2992: x_msg_data := SUBSTR(l_msg_data, 0, 198);
2993: EXCEPTION
2994: WHEN OTHERS THEN
2995: ROLLBACK TO apiinsertserial_apipub;

Line 2997: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2993: EXCEPTION
2994: WHEN OTHERS THEN
2995: ROLLBACK TO apiinsertserial_apipub;
2996:
2997: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2998: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertUnitTrx');
2999: END IF;
3000:
3001: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2998: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertUnitTrx');

2994: WHEN OTHERS THEN
2995: ROLLBACK TO apiinsertserial_apipub;
2996:
2997: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2998: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertUnitTrx');
2999: END IF;
3000:
3001: x_return_status := fnd_api.g_ret_sts_unexp_error;
3002: END insertunittrx;

Line 3121: x_errbuf := SUBSTR(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 250);

3117: COMMIT;
3118: EXCEPTION
3119: WHEN OTHERS THEN
3120: x_retcode := 2;
3121: x_errbuf := SUBSTR(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 250);
3122: ret := fnd_concurrent.set_completion_status('ERROR', v_mesg);
3123: RAISE;
3124: END generate_serials;
3125:

Line 3384: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

3380: END IF;
3381:
3382: x_return_status := FND_API.G_RET_STS_SUCCESS;
3383:
3384: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3385:
3386: IF (l_debug = 1) THEN
3387: invtrace('VALIDATE_UPDATE_SERIAL_ATT:p_inventory_item_id='||p_inventory_item_id);
3388: invtrace('VALIDATE_UPDATE_SERIAL_ATT:p_organization_id='||p_organization_id);

Line 3590: fnd_msg_pub.ADD;

3586: fnd_message.set_name('INV', 'INV_LOT_SEL_DEFAULT_REQUIRED');
3587: fnd_message.set_token('ATTRNAME',l_attributes_name);
3588: fnd_message.set_token('CONTEXTCODE', v_contexts.context_code(i));
3589: fnd_message.set_token('SEGMENT', v_segments.application_column_name(j));
3590: fnd_msg_pub.ADD;
3591: END IF;
3592: END IF;
3593: END IF;
3594: EXIT when (Upper(v_colName) = Upper(g_serial_attributes_tbl(k).column_name));

Line 3621: fnd_msg_pub.ADD;

3617: x_return_status := FND_API.G_RET_STS_ERROR ;
3618: x_msg_data := fnd_flex_descval.error_message;
3619: fnd_message.set_name('INV', 'GENERIC');
3620: fnd_message.set_token('MSGBODY', x_msg_data );
3621: fnd_msg_pub.ADD;
3622: x_msg_count := nvl(x_msg_count,0) + 1 ;
3623: RAISE FND_API.G_EXC_ERROR;
3624: END IF;
3625: END IF; -- if l_context_value is not null

Line 3696: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

3692: EXCEPTION
3693: WHEN FND_API.G_EXC_ERROR THEN
3694: x_validation_status := l_validation_status;
3695: x_return_status := FND_API.G_RET_STS_ERROR;
3696: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3698: x_validation_status := l_validation_status;
3699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3700: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 3700: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

3696: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3698: x_validation_status := l_validation_status;
3699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3700: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3701: WHEN OTHERS THEN
3702: x_validation_status := l_validation_status;
3703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3704: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 3704: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3700: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3701: WHEN OTHERS THEN
3702: x_validation_status := l_validation_status;
3703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3704: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3705: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Validate_Attributes');
3706: END IF;
3707: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3708: END validate_update_serial_att;

Line 3705: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Validate_Attributes');

3701: WHEN OTHERS THEN
3702: x_validation_status := l_validation_status;
3703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3704: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3705: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Validate_Attributes');
3706: END IF;
3707: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3708: END validate_update_serial_att;
3709:

Line 3707: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

3703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3704: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3705: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Validate_Attributes');
3706: END IF;
3707: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3708: END validate_update_serial_att;
3709:
3710: FUNCTION SNGetMask(P_txn_act_id IN NUMBER,
3711: P_txn_src_type_id IN NUMBER,

Line 3789: FND_MSG_PUB.Add;

3785: END LOOP;
3786:
3787: IF x_to_status = 0 then
3788: FND_MESSAGE.SET_NAME('INV', 'INV_INLTIS_SNGETMASK');
3789: FND_MSG_PUB.Add;
3790: x_errorcode := 123;
3791: return(FALSE);
3792: ELSE
3793: return(TRUE);

Line 4243: --FND_MSG_PUB.ADD;

4239: elsif( p_curr_status = 3 ) THEN
4240: l_newStatus := 4;
4241: else
4242: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4243: --FND_MSG_PUB.ADD;
4244: return -1;
4245: end if;
4246: elsif( p_ser_num_ctrl_code = 6 ) THEN
4247: if( p_trx_src_type_id = 8 AND p_trx_action_id = 21 ) THEN

Line 4255: --FND_MSG_PUB.ADD;

4251: elsif( p_curr_status in (1, 3, 6) ) THEN
4252: l_newStatus := 4;
4253: else
4254: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4255: --FND_MSG_PUB.ADD;
4256: return -2;
4257: end if;
4258: end if;
4259: else -- p_isIssue is false;

Line 4268: --FND_MSG_PUB.ADD;

4264: if( (p_trx_src_type_id in (12, 7)) AND (p_curr_status in (5, 7))) THEN
4265: l_newStatus := 4;
4266: else
4267: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4268: --FND_MSG_PUB.ADD;
4269: return -3;
4270: end if;
4271: end if;
4272: elsif( p_ser_num_ctrl_code = 6 ) THEN

Line 4275: --FND_MSG_PUB.ADD;

4271: end if;
4272: elsif( p_ser_num_ctrl_code = 6 ) THEN
4273: if( p_last_trx_src_type_id = 12 AND p_curr_status = 1 AND l_isRestrictRcptSerial = 1 ) THEN
4274: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4275: --FND_MSG_PUB.ADD;
4276: return -1;
4277: elsif( (p_trx_src_type_id = 7 OR p_trx_action_id = 12) AND (p_curr_status in (5, 7 ))) THEN
4278: l_newStatus := 1;
4279: else

Line 4284: --FND_MSG_PUB.ADD;

4280: if( p_curr_status in (1, 4, 5, 6, 7 ) ) THEN
4281: l_newStatus := 1;
4282: else
4283: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4284: --FND_MSG_PUB.ADD;
4285: return -1;
4286: end if;
4287: end if;
4288: end if;

Line 4296: --FND_MSG_PUB.ADD;

4292: if( p_curr_status = 3 ) THEN
4293: l_newStatus := 3;
4294: else
4295: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4296: --FND_MSG_PUB.ADD;
4297: return -1;
4298: end if;
4299: end if;
4300: elsif( l_groupId = 3 ) THEN

Line 4311: --FND_MSG_PUB.ADD;

4307: l_newStatus := 5;
4308: end if;
4309: else
4310: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4311: --FND_MSG_PUB.ADD;
4312: return -1;
4313: end if;
4314: end if;
4315: else

Line 4321: --FND_MSG_PUB.ADD;

4317: if( p_curr_status in (1, 4, 5, 6, 7) ) THEN
4318: l_newStatus := 3;
4319: else
4320: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4321: --FND_MSG_PUB.ADD;
4322: return -1;
4323: end if;
4324: elsif( p_ser_num_ctrl_code = 6 ) THEN
4325: if( p_curr_status in (5,7) AND ( p_trx_src_type_id = 7 OR p_trx_action_id = 12) ) THEN

Line 4329: --FND_MSG_PUB.ADD;

4325: if( p_curr_status in (5,7) AND ( p_trx_src_type_id = 7 OR p_trx_action_id = 12) ) THEN
4326: l_newStatus := 1;
4327: else
4328: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4329: --FND_MSG_PUB.ADD;
4330: return -1;
4331: end if;
4332: end if;
4333: end if;

Line 4337: --FND_MSG_PUB.ADD;

4333: end if;
4334: elsif( l_groupId = 4 ) THEN
4335: if( p_curr_status <> 3 ) THEN
4336: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4337: --FND_MSG_PUB.ADD;
4338: return -1;
4339: end if;
4340: elsif( l_groupId = 5 ) THEN
4341: if( p_isIssue ) THEN

Line 4347: --FND_MSG_PUB.ADD;

4343: if( p_curr_status = 3 ) then
4344: l_newStatus := 4;
4345: else
4346: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4347: --FND_MSG_PUB.ADD;
4348: return -1;
4349: end if;
4350: end if;
4351: else

Line 4356: --FND_MSG_PUB.ADD;

4352: if( p_ser_num_ctrl_code in (2, 3, 5) ) THEN
4353: if( l_isRestrictRcptSerial = 1 AND p_trx_action_id = 27 AND
4354: p_curr_status = 4 AND p_last_trx_src_Type_id = 2 ) THEN
4355: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4356: --FND_MSG_PUB.ADD;
4357: return -1;
4358: end if;
4359: if( p_curr_status in (1, 4, 6)) THEN
4360: if( p_trx_action_id = 3 AND p_xfr_ser_num_ctrl_code = 6 ) THEN

Line 4371: --FND_MSG_PUB.ADD;

4367: (p_trx_src_type_id = 1 AND p_curr_status = 7 )) THEN
4368: l_newStatus := 3;
4369: else
4370: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4371: --FND_MSG_PUB.ADD;
4372: return -1;
4373: end if;
4374: end if;
4375: end if;

Line 4521: --FND_MSG_PUB.ADD;

4517: elsif( p_db_current_status in (1, 3, 6) ) THEN
4518: l_newStatus := 4;
4519: else
4520: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4521: --FND_MSG_PUB.ADD;
4522: l_retval := -902;
4523: end if;
4524: end if;
4525: else -- p_isIssue is false;

Line 4534: --FND_MSG_PUB.ADD;

4530: if( (p_trx_src_type_id in (12, 7)) AND (p_db_current_status in (5, 7))) THEN
4531: l_newStatus := 4;
4532: else
4533: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4534: --FND_MSG_PUB.ADD;
4535: l_retval := -903;
4536: end if;
4537: end if;
4538: elsif( p_ser_num_ctrl_code = 6 ) THEN

Line 4541: --FND_MSG_PUB.ADD;

4537: end if;
4538: elsif( p_ser_num_ctrl_code = 6 ) THEN
4539: if( p_db_lst_txn_src_type_id = 12 AND p_db_current_status = 1 AND l_isRestrictRcptSerial = 1 ) THEN
4540: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4541: --FND_MSG_PUB.ADD;
4542: l_retval := -904;
4543: elsif( (p_trx_src_type_id = 7 OR p_trx_action_id = 12) AND (p_db_current_status in (5, 7 ))) THEN
4544: l_newStatus := 1;
4545: else

Line 4550: --FND_MSG_PUB.ADD;

4546: if( p_db_current_status in (1, 4, 5, 6, 7 ) ) THEN
4547: l_newStatus := 1;
4548: else
4549: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4550: --FND_MSG_PUB.ADD;
4551: l_retval := -905;
4552: end if;
4553: end if;
4554: end if;

Line 4562: --FND_MSG_PUB.ADD;

4558: if( p_db_current_status = 3 ) THEN
4559: l_newStatus := 3;
4560: else
4561: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4562: --FND_MSG_PUB.ADD;
4563: l_retval := -906;
4564: end if;
4565: end if;
4566: elsif( l_groupId = 3 ) THEN

Line 4577: --FND_MSG_PUB.ADD;

4573: l_newStatus := 5;
4574: end if;
4575: else
4576: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4577: --FND_MSG_PUB.ADD;
4578: l_retval := -907;
4579: end if;
4580: end if;
4581: else

Line 4587: --FND_MSG_PUB.ADD;

4583: if( p_db_current_status in (1, 4, 5, 6, 7) ) THEN
4584: l_newStatus := 3;
4585: else
4586: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4587: --FND_MSG_PUB.ADD;
4588: l_retval := -908;
4589: end if;
4590: elsif( p_ser_num_ctrl_code = 6 ) THEN
4591: if( p_db_current_status in (5,7) AND ( p_trx_src_type_id = 7 OR p_trx_action_id = 12) ) THEN

Line 4595: --FND_MSG_PUB.ADD;

4591: if( p_db_current_status in (5,7) AND ( p_trx_src_type_id = 7 OR p_trx_action_id = 12) ) THEN
4592: l_newStatus := 1;
4593: else
4594: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4595: --FND_MSG_PUB.ADD;
4596: l_retval := -908;
4597: end if;
4598: end if;
4599: end if;

Line 4603: --FND_MSG_PUB.ADD;

4599: end if;
4600: elsif( l_groupId = 4 ) THEN
4601: if( p_db_current_status <> 3 ) THEN
4602: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4603: --FND_MSG_PUB.ADD;
4604: l_retval := -909;
4605: end if;
4606: elsif( l_groupId = 5 ) THEN
4607: --dbms_output.put_line('standard group');

Line 4614: --FND_MSG_PUB.ADD;

4610: if( p_db_current_status = 3 ) then
4611: l_newStatus := 4;
4612: else
4613: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4614: --FND_MSG_PUB.ADD;
4615: l_retval := -910;
4616: end if;
4617: end if;
4618: else

Line 4624: --FND_MSG_PUB.ADD;

4620: if( p_ser_num_ctrl_code in (2, 3, 5) ) THEN
4621: if( l_isRestrictRcptSerial = 1 AND p_trx_action_id = 27 AND
4622: p_db_current_status = 4 AND p_db_lst_txn_src_Type_id = 2 ) THEN
4623: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4624: --FND_MSG_PUB.ADD;
4625: l_retval := -911;
4626: end if;
4627: if( p_db_current_status in (1, 4, 6)) THEN
4628: if( p_trx_action_id = 3 AND p_xfr_ser_num_ctrl_code = 6 ) THEN

Line 4639: --FND_MSG_PUB.ADD;

4635: (p_trx_src_type_id = 1 AND p_db_current_status = 7 )) THEN
4636: l_newStatus := 3;
4637: else
4638: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4639: --FND_MSG_PUB.ADD;
4640: l_retval := -912;
4641: end if;
4642: end if;
4643: end if;

Line 4946: fnd_msg_pub.initialize;

4942: RAISE fnd_api.g_exc_unexpected_error;
4943: END IF;
4944: -- Initialize message list if p_init_msg_list is set to TRUE.
4945: IF fnd_api.to_boolean(p_init_msg_list) THEN
4946: fnd_msg_pub.initialize;
4947: END IF;
4948:
4949: -- Initialize API return status to success
4950:

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

6008: COMMIT WORK;
6009: END IF;
6010:
6011: -- Standard call to get message count and if count is 1, get message info.
6012: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_msg_data);
6013: x_msg_data := SUBSTR(l_msg_data, 0, 198);
6014: EXCEPTION
6015: WHEN OTHERS THEN
6016: ROLLBACK TO apiinsertserial_apipub;

Line 6018: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

6014: EXCEPTION
6015: WHEN OTHERS THEN
6016: ROLLBACK TO apiinsertserial_apipub;
6017:
6018: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6019: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertRangeUnitTrx');
6020: END IF;
6021:
6022: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 6019: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertRangeUnitTrx');

6015: WHEN OTHERS THEN
6016: ROLLBACK TO apiinsertserial_apipub;
6017:
6018: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6019: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertRangeUnitTrx');
6020: END IF;
6021:
6022: x_return_status := fnd_api.g_ret_sts_unexp_error;
6023: END insertRangeUnitTrx;