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 204: fnd_msg_pub.initialize;

200: END IF;
201:
202: -- Initialize message list if p_init_msg_list is set to TRUE.
203: IF fnd_api.to_boolean(p_init_msg_list) THEN
204: fnd_msg_pub.initialize;
205: END IF;
206:
207: -- Initialize API return status to success
208: -- API body

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

217: WHEN NO_DATA_FOUND THEN
218: item_count := 0;
219: WHEN OTHERS THEN
220: --Bug 3153585:Raising exception to populate error message correctly.
221: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
222: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
223: END IF;
224:
225: RAISE fnd_api.g_exc_unexpected_error;

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

218: item_count := 0;
219: WHEN OTHERS THEN
220: --Bug 3153585:Raising exception to populate error message correctly.
221: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
222: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
223: END IF;
224:
225: RAISE fnd_api.g_exc_unexpected_error;
226: END;

Line 230: fnd_msg_pub.ADD;

226: END;
227:
228: IF (item_count = 0) THEN
229: fnd_message.set_name('INV', 'INV_INVALID_ORGANIZATION');
230: fnd_msg_pub.ADD;
231: --Bug 3153585:Raising exception to populate error message correctly.
232: RAISE fnd_api.g_exc_error;
233: END IF;
234:

Line 248: fnd_msg_pub.ADD;

244:
245: IF (l_serial_control_code = 1
246: AND is_serial_tagged(p_inventory_item_id,p_organization_id,NULL) = 1) THEN
247: fnd_message.set_name('INV', 'INV_ITEM_NOT_SERIAL_CONTROLLED');
248: fnd_msg_pub.ADD;
249: --Bug 3153585:Raising exception to populate error message correctly.
250: RAISE fnd_api.g_exc_error;
251: END IF;
252:

Line 264: fnd_msg_pub.ADD;

260: RAISE fnd_api.g_exc_error;
261: --Bug 3153585:Raising exception to populate error message correctly.
262: WHEN NO_DATA_FOUND THEN
263: fnd_message.set_name('INV', 'INV_INVALID_ITEM');
264: fnd_msg_pub.ADD;
265: --Bug 3153585:Raising exception to populate error message correctly.
266: RAISE fnd_api.g_exc_error;
267: WHEN OTHERS THEN
268: --Bug 3152585:Raising Exception to populate error message correctly.

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

265: --Bug 3153585:Raising exception to populate error message correctly.
266: RAISE fnd_api.g_exc_error;
267: WHEN OTHERS THEN
268: --Bug 3152585:Raising Exception to populate error message correctly.
269: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
270: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
271: END IF;
272:
273: RAISE fnd_api.g_exc_unexpected_error;

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

266: RAISE fnd_api.g_exc_error;
267: WHEN OTHERS THEN
268: --Bug 3152585:Raising Exception to populate error message correctly.
269: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
270: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
271: END IF;
272:
273: RAISE fnd_api.g_exc_unexpected_error;
274: END;

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

333: COMMIT WORK;
334: END IF;
335:
336: -- Standard call to get message count and if count is 1, get message info.
337: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
338: EXCEPTION
339: WHEN fnd_api.g_exc_error THEN
340: ROLLBACK TO apiinsertserial_apipub;
341: --Bug 3153585:Populating the message from the message stack

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

338: EXCEPTION
339: WHEN fnd_api.g_exc_error THEN
340: ROLLBACK TO apiinsertserial_apipub;
341: --Bug 3153585:Populating the message from the message stack
342: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
343: x_return_status := fnd_api.g_ret_sts_error;
344: WHEN fnd_api.g_exc_unexpected_error THEN
345: --Bug 3153585:Populating the message from the message stack
346: ROLLBACK TO apiinsertserial_apipub;

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

343: x_return_status := fnd_api.g_ret_sts_error;
344: WHEN fnd_api.g_exc_unexpected_error THEN
345: --Bug 3153585:Populating the message from the message stack
346: ROLLBACK TO apiinsertserial_apipub;
347: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
348: x_return_status := fnd_api.g_ret_sts_unexp_error;
349: WHEN OTHERS THEN
350: ROLLBACK TO apiinsertserial_apipub;
351:

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

348: x_return_status := fnd_api.g_ret_sts_unexp_error;
349: WHEN OTHERS THEN
350: ROLLBACK TO apiinsertserial_apipub;
351:
352: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
353: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
354: END IF;
355:
356: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

349: WHEN OTHERS THEN
350: ROLLBACK TO apiinsertserial_apipub;
351:
352: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
353: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
354: END IF;
355:
356: x_return_status := fnd_api.g_ret_sts_unexp_error;
357: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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

353: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
354: END IF;
355:
356: x_return_status := fnd_api.g_ret_sts_unexp_error;
357: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
358: END insertserial;
359:
360: -- 'Serial Tracking in WIP project. insert wip_entity_id, operation_seq_num and intraoperation_step_type
361: -- into MSN.

Line 493: fnd_msg_pub.initialize;

489: END IF;
490:
491: -- Initialize message list if p_init_msg_list is set to TRUE.
492: IF fnd_api.to_boolean(p_init_msg_list) THEN
493: fnd_msg_pub.initialize;
494: END IF;
495:
496: /** ssia we don't need this if condition **/
497: /*IF (p_transaction_action_id = 3 AND g_firstscan = FALSE) THEN*/

Line 514: fnd_msg_pub.ADD;

510: IF (l_serial_control_code = 1
511: AND is_serial_tagged(p_inventory_item_id,p_organization_id,NULL) = 1) THEN
512: -- invtrace('serial_control_code is 1.there is no serial control.');
513: fnd_message.set_name('INV', 'INV_ITEM_NOT_SERIAL_CONTROLLED');
514: fnd_msg_pub.ADD;
515: --Bug 3153585:Populating the message from the message stack
516: RAISE fnd_api.g_exc_error;
517: END IF;
518: EXCEPTION

Line 521: fnd_msg_pub.ADD;

517: END IF;
518: EXCEPTION
519: WHEN NO_DATA_FOUND THEN
520: fnd_message.set_name('INV', 'INV_INVALID_ITEM');
521: fnd_msg_pub.ADD;
522: RAISE fnd_api.g_exc_error;
523: END;
524:
525: SELECT mtl_gen_object_id_s.NEXTVAL

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

1272: COMMIT WORK;
1273: END IF;
1274:
1275: -- Standard call to get message count and if count is 1, get message info.
1276: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1277: EXCEPTION
1278: WHEN fnd_api.g_exc_error THEN
1279: ROLLBACK TO apiinsertserial_apipub;
1280: --Bug 3153585:Populating x_msg_data from message stack

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

1277: EXCEPTION
1278: WHEN fnd_api.g_exc_error THEN
1279: ROLLBACK TO apiinsertserial_apipub;
1280: --Bug 3153585:Populating x_msg_data from message stack
1281: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1282: x_return_status := fnd_api.g_ret_sts_error;
1283: WHEN OTHERS THEN
1284: ROLLBACK TO apiinsertserial_apipub;
1285:

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

1282: x_return_status := fnd_api.g_ret_sts_error;
1283: WHEN OTHERS THEN
1284: ROLLBACK TO apiinsertserial_apipub;
1285:
1286: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1287: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
1288: END IF;
1289:
1290: --Bug 3153585:Populating x_msg_data from message stack

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

1283: WHEN OTHERS THEN
1284: ROLLBACK TO apiinsertserial_apipub;
1285:
1286: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1287: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
1288: END IF;
1289:
1290: --Bug 3153585:Populating x_msg_data from message stack
1291: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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

1287: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
1288: END IF;
1289:
1290: --Bug 3153585:Populating x_msg_data from message stack
1291: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1292: x_return_status := fnd_api.g_ret_sts_unexp_error;
1293: END insertserial;
1294:
1295: -- Procedure insertSerial for Serial Blacklist

Line 1351: fnd_msg_pub.initialize;

1347: END IF;
1348:
1349: -- Initialize message list if p_init_msg_list is set to TRUE.
1350: IF fnd_api.to_boolean(p_init_msg_list) THEN
1351: fnd_msg_pub.initialize;
1352: END IF;
1353:
1354: -- Initialize API return status to success
1355: -- API body

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

1363: EXCEPTION
1364: WHEN NO_DATA_FOUND THEN
1365: item_count := 0;
1366: WHEN OTHERS THEN
1367: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1368: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insert_range_serial');
1369: END IF;
1370:
1371: RAISE fnd_api.g_exc_unexpected_error;

Line 1368: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insert_range_serial');

1364: WHEN NO_DATA_FOUND THEN
1365: item_count := 0;
1366: WHEN OTHERS THEN
1367: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1368: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insert_range_serial');
1369: END IF;
1370:
1371: RAISE fnd_api.g_exc_unexpected_error;
1372: END;

Line 1376: fnd_msg_pub.ADD;

1372: END;
1373:
1374: IF (item_count = 0) THEN
1375: fnd_message.set_name('INV', 'INVALID ORGANIZATION');
1376: fnd_msg_pub.ADD;
1377: RAISE fnd_api.g_exc_error;
1378: END IF;
1379:
1380: -- Block to check the Serial Control Code

Line 1390: fnd_msg_pub.ADD;

1386: AND organization_id = p_organization_id;
1387:
1388: IF (l_serial_control_code = 1) THEN
1389: fnd_message.set_name('INV', 'INV_ITEM_NOT_SERIAL_CONTROLLED');
1390: fnd_msg_pub.ADD;
1391: RAISE fnd_api.g_exc_error;
1392: END IF;
1393:
1394: l_current_status := nvl(p_current_status,1);

Line 1399: fnd_msg_pub.ADD;

1395: --bug10074753,we should populate the validate serial current status.
1396: IF(l_current_status NOT IN(1,3,4,5)) THEN
1397: fnd_message.set_name('INV', 'INV_SER_INVALID_STATUS');
1398: fnd_message.set_token('TOKEN',' ');
1399: fnd_msg_pub.ADD;
1400: RAISE fnd_api.g_exc_error;
1401: END IF;
1402:
1403: EXCEPTION

Line 1408: fnd_msg_pub.ADD;

1404: WHEN fnd_api.g_exc_error THEN
1405: RAISE fnd_api.g_exc_error;
1406: WHEN NO_DATA_FOUND THEN
1407: fnd_message.set_name('INV', 'INV_INVALID_ITEM');
1408: fnd_msg_pub.ADD;
1409: RAISE fnd_api.g_exc_error;
1410: WHEN OTHERS THEN
1411: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1412: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insert_range_serial');

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

1407: fnd_message.set_name('INV', 'INV_INVALID_ITEM');
1408: fnd_msg_pub.ADD;
1409: RAISE fnd_api.g_exc_error;
1410: WHEN OTHERS THEN
1411: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1412: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insert_range_serial');
1413: END IF;
1414:
1415: RAISE fnd_api.g_exc_unexpected_error;

Line 1412: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insert_range_serial');

1408: fnd_msg_pub.ADD;
1409: RAISE fnd_api.g_exc_error;
1410: WHEN OTHERS THEN
1411: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1412: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insert_range_serial');
1413: END IF;
1414:
1415: RAISE fnd_api.g_exc_unexpected_error;
1416: END;

Line 1426: fnd_msg_pub.ADD;

1422: --Check if the material status is serial control enabled.
1423: --If not then raise an error.
1424: IF (l_serial_status_control <> 1) THEN
1425: fnd_message.set_name('INV','INV_STATUS_NOT_APP'); --error messag
1426: fnd_msg_pub.ADD;
1427: RAISE fnd_api.g_exc_error;
1428: END IF;
1429:
1430: EXCEPTION

Line 1435: fnd_msg_pub.ADD;

1431: WHEN fnd_api.g_exc_error THEN
1432: RAISE fnd_api.g_exc_error;
1433: WHEN NO_DATA_FOUND THEN
1434: fnd_message.set_name('INV', 'INV_STATUS_NOT_APP');
1435: fnd_msg_pub.ADD;
1436: RAISE fnd_api.g_exc_error;
1437: WHEN OTHERS THEN
1438: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1439: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insert_range_serial');

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

1434: fnd_message.set_name('INV', 'INV_STATUS_NOT_APP');
1435: fnd_msg_pub.ADD;
1436: RAISE fnd_api.g_exc_error;
1437: WHEN OTHERS THEN
1438: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1439: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insert_range_serial');
1440: END IF;
1441: RAISE fnd_api.g_exc_unexpected_error;
1442: END;

Line 1439: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insert_range_serial');

1435: fnd_msg_pub.ADD;
1436: RAISE fnd_api.g_exc_error;
1437: WHEN OTHERS THEN
1438: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1439: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insert_range_serial');
1440: END IF;
1441: RAISE fnd_api.g_exc_unexpected_error;
1442: END;
1443: --bug10074736,we should make sure the validate lot number here.

Line 1457: fnd_msg_pub.ADD;

1453: AND lot_number = p_lot_number;
1454:
1455: IF (l_lot_exists = 0) THEN
1456: fnd_message.set_name('INV','INV_INVALID_LOT'); --error messag
1457: fnd_msg_pub.ADD;
1458: RAISE fnd_api.g_exc_error;
1459: END IF;
1460: END IF;
1461: EXCEPTION

Line 1467: fnd_msg_pub.ADD;

1463: RAISE fnd_api.g_exc_error;
1464: WHEN NO_DATA_FOUND THEN
1465: l_lot_exists := 0;
1466: fnd_message.set_name('INV','INV_INVALID_LOT'); --error messag
1467: fnd_msg_pub.ADD;
1468: RAISE fnd_api.g_exc_error;
1469: WHEN OTHERS THEN
1470: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1471: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insert_range_serial');

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

1466: fnd_message.set_name('INV','INV_INVALID_LOT'); --error messag
1467: fnd_msg_pub.ADD;
1468: RAISE fnd_api.g_exc_error;
1469: WHEN OTHERS THEN
1470: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1471: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insert_range_serial');
1472: END IF;
1473: RAISE fnd_api.g_exc_unexpected_error;
1474: END;

Line 1471: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insert_range_serial');

1467: fnd_msg_pub.ADD;
1468: RAISE fnd_api.g_exc_error;
1469: WHEN OTHERS THEN
1470: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1471: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insert_range_serial');
1472: END IF;
1473: RAISE fnd_api.g_exc_unexpected_error;
1474: END;
1475: --bug10074682,validate the from serial number and to serial number available.

Line 1479: fnd_msg_pub.ADD;

1475: --bug10074682,validate the from serial number and to serial number available.
1476: --Block for from serial number and to serial number validation,it should be varchar.
1477: IF nvl(p_fm_serial_number,'!@') = '!@' OR nvl(p_to_serial_number,'!@') = '!@' THEN
1478: fnd_message.set_name('INV','INVALID_SERIAL_NUMBER'); --error messag
1479: fnd_msg_pub.ADD;
1480: RAISE fnd_api.g_exc_error;
1481: END IF;
1482: -- get the number part of the from serial
1483: inv_validate.number_from_sequence(p_fm_serial_number, l_temp_prefix, l_from_ser_number);

Line 1491: fnd_msg_pub.ADD;

1487: l_range_numbers := l_to_ser_number - l_from_ser_number + 1;
1488: --bug10074682,from serial number and to serial number shoule be in sequence.
1489: IF l_range_numbers < 1 THEN --the range numbers with no sense,need enter the validate range nubmers
1490: fnd_message.set_name('INV','INVALID_SERIAL_NUMBER'); --error messag
1491: fnd_msg_pub.ADD;
1492: RAISE fnd_api.g_exc_error;
1493: END IF;
1494: FOR i IN 1 .. l_range_numbers LOOP
1495: l_cur_ser_number := l_from_ser_number + i - 1;

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

1561: IF fnd_api.to_boolean(p_commit) THEN
1562: COMMIT WORK;
1563: END IF;
1564: -- Standard call to get message count and if count is 1, get message info.
1565: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1566: EXCEPTION
1567: WHEN fnd_api.g_exc_error THEN
1568: ROLLBACK TO apiinsertserial_apipub;
1569: --Bug 3153585:Populating x_msg_data from message stack

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

1566: EXCEPTION
1567: WHEN fnd_api.g_exc_error THEN
1568: ROLLBACK TO apiinsertserial_apipub;
1569: --Bug 3153585:Populating x_msg_data from message stack
1570: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1571: x_return_status := fnd_api.g_ret_sts_error;
1572: WHEN OTHERS THEN
1573: ROLLBACK TO apiinsertserial_apipub;
1574:

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

1571: x_return_status := fnd_api.g_ret_sts_error;
1572: WHEN OTHERS THEN
1573: ROLLBACK TO apiinsertserial_apipub;
1574:
1575: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1576: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insert_range_serial');
1577: END IF;
1578:
1579: --Bug 3153585:Populating x_msg_data from message stack

Line 1576: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insert_range_serial');

1572: WHEN OTHERS THEN
1573: ROLLBACK TO apiinsertserial_apipub;
1574:
1575: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1576: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insert_range_serial');
1577: END IF;
1578:
1579: --Bug 3153585:Populating x_msg_data from message stack
1580: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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

1576: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insert_range_serial');
1577: END IF;
1578:
1579: --Bug 3153585:Populating x_msg_data from message stack
1580: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1581: x_return_status := fnd_api.g_ret_sts_unexp_error;
1582:
1583: END insert_range_serial;
1584:

Line 1656: fnd_msg_pub.initialize;

1652: END IF;
1653:
1654: -- Initialize message list if p_init_msg_list is set to TRUE.
1655: IF fnd_api.to_boolean(p_init_msg_list) THEN
1656: fnd_msg_pub.initialize;
1657: END IF;
1658:
1659: -- Initialize API return status to success
1660: x_return_status := fnd_api.g_ret_sts_success;

Line 1750: fnd_msg_pub.ADD;

1746: -- If any serial is in use, then discard the entire range insertion.
1747: IF is_serial_unique(p_org_id => p_organization_id, p_item_id => p_inventory_item_id, p_serial => l_cur_serial_number
1748: , x_proc_msg => l_msg_data) = 1 THEN
1749: fnd_message.set_name('INV', 'INV_SERIAL_USED');
1750: fnd_msg_pub.ADD;
1751: RAISE fnd_api.g_exc_error;
1752: ELSE
1753: -- invtrace('INV_SERIAL_NUMBER_PUB', 'insert_range_serial - 60');
1754: -- uniqueness check passed

Line 1800: fnd_msg_pub.ADD;

1796: );
1797:
1798: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1799: fnd_message.set_name('INV', 'INV_SERIAL');
1800: fnd_msg_pub.ADD;
1801: RAISE fnd_api.g_exc_unexpected_error;
1802: END IF;
1803: END IF;
1804: END IF;

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

1846: END IF;
1847:
1848: -- Standard call to get message count and if count is 1,
1849: -- get message info.
1850: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1851: EXCEPTION
1852: WHEN fnd_api.g_exc_error THEN
1853: ROLLBACK TO sp_insert_range_serial;
1854: x_return_status := fnd_api.g_ret_sts_error;

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

1851: EXCEPTION
1852: WHEN fnd_api.g_exc_error THEN
1853: ROLLBACK TO sp_insert_range_serial;
1854: x_return_status := fnd_api.g_ret_sts_error;
1855: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1856: WHEN fnd_api.g_exc_unexpected_error THEN
1857: ROLLBACK TO sp_insert_range_serial;
1858: x_return_status := fnd_api.g_ret_sts_unexp_error;
1859: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1855: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1856: WHEN fnd_api.g_exc_unexpected_error THEN
1857: ROLLBACK TO sp_insert_range_serial;
1858: x_return_status := fnd_api.g_ret_sts_unexp_error;
1859: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1860: WHEN OTHERS THEN
1861: ROLLBACK TO sp_insert_range_serial;
1862: x_return_status := fnd_api.g_ret_sts_unexp_error;
1863: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1859: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1860: WHEN OTHERS THEN
1861: ROLLBACK TO sp_insert_range_serial;
1862: x_return_status := fnd_api.g_ret_sts_unexp_error;
1863: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1864: END insert_range_serial;
1865:
1866: PROCEDURE updateserial(
1867: p_api_version IN NUMBER

Line 2027: fnd_msg_pub.initialize;

2023: END IF;
2024:
2025: -- Initialize message list if p_init_msg_list is set to TRUE.
2026: IF fnd_api.to_boolean(p_init_msg_list) THEN
2027: fnd_msg_pub.initialize;
2028: END IF;
2029:
2030: -- Initialize API return status to success
2031: x_return_status := fnd_api.g_ret_sts_success;

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

2372: COMMIT WORK;
2373: END IF;
2374:
2375: -- Standard call to get message count and if count is 1, get message info.
2376: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2377: EXCEPTION
2378: WHEN OTHERS THEN
2379: ROLLBACK TO apiupdateserial_apipub;
2380:

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

2377: EXCEPTION
2378: WHEN OTHERS THEN
2379: ROLLBACK TO apiupdateserial_apipub;
2380:
2381: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2382: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'updateSerial');
2383: END IF;
2384:
2385: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

2378: WHEN OTHERS THEN
2379: ROLLBACK TO apiupdateserial_apipub;
2380:
2381: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2382: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'updateSerial');
2383: END IF;
2384:
2385: x_return_status := fnd_api.g_ret_sts_unexp_error;
2386: END updateserial;

Line 2514: fnd_msg_pub.initialize;

2510: END IF;
2511:
2512: -- Initialize message list if p_init_msg_list is set to TRUE.
2513: IF fnd_api.to_boolean(p_init_msg_list) THEN
2514: fnd_msg_pub.initialize;
2515: END IF;
2516:
2517: -- Initialize API return status to success
2518:

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

3318: COMMIT WORK;
3319: END IF;
3320:
3321: -- Standard call to get message count and if count is 1, get message info.
3322: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_msg_data);
3323: x_msg_data := SUBSTR(l_msg_data, 0, 198);
3324: EXCEPTION
3325: WHEN OTHERS THEN
3326: ROLLBACK TO apiinsertserial_apipub;

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

3324: EXCEPTION
3325: WHEN OTHERS THEN
3326: ROLLBACK TO apiinsertserial_apipub;
3327:
3328: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3329: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertUnitTrx');
3330: END IF;
3331:
3332: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3325: WHEN OTHERS THEN
3326: ROLLBACK TO apiinsertserial_apipub;
3327:
3328: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3329: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertUnitTrx');
3330: END IF;
3331:
3332: x_return_status := fnd_api.g_ret_sts_unexp_error;
3333: END insertunittrx;

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

3448: COMMIT;
3449: EXCEPTION
3450: WHEN OTHERS THEN
3451: x_retcode := 2;
3452: x_errbuf := SUBSTR(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 250);
3453: ret := fnd_concurrent.set_completion_status('ERROR', v_mesg);
3454: RAISE;
3455: END generate_serials;
3456:

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

3737: END IF;
3738:
3739: x_return_status := FND_API.G_RET_STS_SUCCESS;
3740:
3741: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
3742:
3743: IF (l_debug = 1) THEN
3744: invtrace('VALIDATE_UPDATE_SERIAL_ATT:p_inventory_item_id='||p_inventory_item_id);
3745: invtrace('VALIDATE_UPDATE_SERIAL_ATT:p_organization_id='||p_organization_id);

Line 3955: fnd_msg_pub.ADD;

3951: fnd_message.set_name('INV', 'INV_LOT_SEL_DEFAULT_REQUIRED');
3952: fnd_message.set_token('ATTRNAME',l_attributes_name);
3953: fnd_message.set_token('CONTEXTCODE', v_contexts.context_code(i));
3954: fnd_message.set_token('SEGMENT', v_segments.application_column_name(j));
3955: fnd_msg_pub.ADD;
3956: END IF;
3957: END IF;
3958: END IF;
3959: EXIT when (Upper(v_colName) = Upper(g_serial_attributes_tbl(k).column_name));

Line 3986: fnd_msg_pub.ADD;

3982: x_return_status := FND_API.G_RET_STS_ERROR ;
3983: x_msg_data := fnd_flex_descval.error_message;
3984: fnd_message.set_name('INV', 'GENERIC');
3985: fnd_message.set_token('MSGBODY', x_msg_data );
3986: fnd_msg_pub.ADD;
3987: x_msg_count := nvl(x_msg_count,0) + 1 ;
3988: RAISE FND_API.G_EXC_ERROR;
3989: END IF;
3990: END IF; -- if l_context_value is not null

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

4073: EXCEPTION
4074: WHEN FND_API.G_EXC_ERROR THEN
4075: x_validation_status := l_validation_status;
4076: x_return_status := FND_API.G_RET_STS_ERROR;
4077: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4079: x_validation_status := l_validation_status;
4080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4081: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

4077: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4079: x_validation_status := l_validation_status;
4080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4081: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4082: WHEN OTHERS THEN
4083: x_validation_status := l_validation_status;
4084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4085: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

4081: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4082: WHEN OTHERS THEN
4083: x_validation_status := l_validation_status;
4084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4085: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4086: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Validate_Attributes');
4087: END IF;
4088: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4089: END validate_update_serial_att;

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

4082: WHEN OTHERS THEN
4083: x_validation_status := l_validation_status;
4084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4085: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4086: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Validate_Attributes');
4087: END IF;
4088: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4089: END validate_update_serial_att;
4090:

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

4084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4085: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4086: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Validate_Attributes');
4087: END IF;
4088: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4089: END validate_update_serial_att;
4090:
4091: FUNCTION SNGetMask(P_txn_act_id IN NUMBER,
4092: P_txn_src_type_id IN NUMBER,

Line 4172: FND_MSG_PUB.Add;

4168: END LOOP;
4169:
4170: IF x_to_status = 0 then
4171: FND_MESSAGE.SET_NAME('INV', 'INV_INLTIS_SNGETMASK');
4172: FND_MSG_PUB.Add;
4173: x_errorcode := 123;
4174: return(FALSE);
4175: ELSE
4176: return(TRUE);

Line 4630: --FND_MSG_PUB.ADD;

4626: elsif( p_curr_status = 3 ) THEN
4627: l_newStatus := 4;
4628: else
4629: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4630: --FND_MSG_PUB.ADD;
4631: return -1;
4632: end if;
4633: elsif( p_ser_num_ctrl_code = 6 ) THEN
4634: if( p_trx_src_type_id = 8 AND p_trx_action_id = 21 ) THEN

Line 4642: --FND_MSG_PUB.ADD;

4638: elsif( p_curr_status in (1, 3, 6) ) THEN
4639: l_newStatus := 4;
4640: else
4641: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4642: --FND_MSG_PUB.ADD;
4643: return -2;
4644: end if;
4645: end if;
4646: else -- p_isIssue is false;

Line 4655: --FND_MSG_PUB.ADD;

4651: if( (p_trx_src_type_id in (12, 7)) AND (p_curr_status in (5, 7))) THEN
4652: l_newStatus := 4;
4653: else
4654: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4655: --FND_MSG_PUB.ADD;
4656: return -3;
4657: end if;
4658: end if;
4659: elsif( p_ser_num_ctrl_code = 6 ) THEN

Line 4662: --FND_MSG_PUB.ADD;

4658: end if;
4659: elsif( p_ser_num_ctrl_code = 6 ) THEN
4660: if( p_last_trx_src_type_id = 12 AND p_curr_status = 1 AND l_isRestrictRcptSerial = 1 ) THEN
4661: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4662: --FND_MSG_PUB.ADD;
4663: return -1;
4664: elsif( (p_trx_src_type_id = 7 OR p_trx_action_id = 12) AND (p_curr_status in (5, 7 ))) THEN
4665: l_newStatus := 1;
4666: else

Line 4671: --FND_MSG_PUB.ADD;

4667: if( p_curr_status in (1, 4, 5, 6, 7 ) ) THEN
4668: l_newStatus := 1;
4669: else
4670: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4671: --FND_MSG_PUB.ADD;
4672: return -1;
4673: end if;
4674: end if;
4675: end if;

Line 4683: --FND_MSG_PUB.ADD;

4679: if( p_curr_status = 3 ) THEN
4680: l_newStatus := 3;
4681: else
4682: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4683: --FND_MSG_PUB.ADD;
4684: return -1;
4685: end if;
4686: end if;
4687: elsif( l_groupId = 3 ) THEN

Line 4698: --FND_MSG_PUB.ADD;

4694: l_newStatus := 5;
4695: end if;
4696: else
4697: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4698: --FND_MSG_PUB.ADD;
4699: return -1;
4700: end if;
4701: end if;
4702: else

Line 4708: --FND_MSG_PUB.ADD;

4704: if( p_curr_status in (1, 4, 5, 6, 7) ) THEN
4705: l_newStatus := 3;
4706: else
4707: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4708: --FND_MSG_PUB.ADD;
4709: return -1;
4710: end if;
4711: elsif( p_ser_num_ctrl_code = 6 ) THEN
4712: if( p_curr_status in (5,7) AND ( p_trx_src_type_id = 7 OR p_trx_action_id = 12) ) THEN

Line 4716: --FND_MSG_PUB.ADD;

4712: if( p_curr_status in (5,7) AND ( p_trx_src_type_id = 7 OR p_trx_action_id = 12) ) THEN
4713: l_newStatus := 1;
4714: else
4715: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4716: --FND_MSG_PUB.ADD;
4717: return -1;
4718: end if;
4719: end if;
4720: end if;

Line 4724: --FND_MSG_PUB.ADD;

4720: end if;
4721: elsif( l_groupId = 4 ) THEN
4722: if( p_curr_status <> 3 ) THEN
4723: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4724: --FND_MSG_PUB.ADD;
4725: return -1;
4726: end if;
4727: elsif( l_groupId = 5 ) THEN
4728: if( p_isIssue ) THEN

Line 4734: --FND_MSG_PUB.ADD;

4730: if( p_curr_status = 3 ) then
4731: l_newStatus := 4;
4732: else
4733: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4734: --FND_MSG_PUB.ADD;
4735: return -1;
4736: end if;
4737: end if;
4738: else

Line 4743: --FND_MSG_PUB.ADD;

4739: if( p_ser_num_ctrl_code in (2, 3, 5) ) THEN
4740: if( l_isRestrictRcptSerial = 1 AND p_trx_action_id = 27 AND
4741: p_curr_status = 4 AND p_last_trx_src_Type_id = 2 ) THEN
4742: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4743: --FND_MSG_PUB.ADD;
4744: return -1;
4745: end if;
4746: if( p_curr_status in (1, 4, 6)) THEN
4747: if( p_trx_action_id = 3 AND p_xfr_ser_num_ctrl_code = 6 ) THEN

Line 4758: --FND_MSG_PUB.ADD;

4754: (p_trx_src_type_id = 1 AND p_curr_status = 7 )) THEN
4755: l_newStatus := 3;
4756: else
4757: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4758: --FND_MSG_PUB.ADD;
4759: return -1;
4760: end if;
4761: end if;
4762: end if;

Line 4908: --FND_MSG_PUB.ADD;

4904: elsif( p_db_current_status in (1, 3, 6) ) THEN
4905: l_newStatus := 4;
4906: else
4907: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4908: --FND_MSG_PUB.ADD;
4909: l_retval := -902;
4910: end if;
4911: end if;
4912: else -- p_isIssue is false;

Line 4921: --FND_MSG_PUB.ADD;

4917: if( (p_trx_src_type_id in (12, 7)) AND (p_db_current_status in (5, 7))) THEN
4918: l_newStatus := 4;
4919: else
4920: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4921: --FND_MSG_PUB.ADD;
4922: l_retval := -903;
4923: end if;
4924: end if;
4925: elsif( p_ser_num_ctrl_code = 6 ) THEN

Line 4928: --FND_MSG_PUB.ADD;

4924: end if;
4925: elsif( p_ser_num_ctrl_code = 6 ) THEN
4926: if( p_db_lst_txn_src_type_id = 12 AND p_db_current_status = 1 AND l_isRestrictRcptSerial = 1 ) THEN
4927: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4928: --FND_MSG_PUB.ADD;
4929: l_retval := -904;
4930: elsif( (p_trx_src_type_id = 7 OR p_trx_action_id = 12) AND (p_db_current_status in (5, 7 ))) THEN
4931: l_newStatus := 1;
4932: else

Line 4937: --FND_MSG_PUB.ADD;

4933: if( p_db_current_status in (1, 4, 5, 6, 7 ) ) THEN
4934: l_newStatus := 1;
4935: else
4936: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4937: --FND_MSG_PUB.ADD;
4938: l_retval := -905;
4939: end if;
4940: end if;
4941: end if;

Line 4949: --FND_MSG_PUB.ADD;

4945: if( p_db_current_status = 3 ) THEN
4946: l_newStatus := 3;
4947: else
4948: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4949: --FND_MSG_PUB.ADD;
4950: l_retval := -906;
4951: end if;
4952: end if;
4953: elsif( l_groupId = 3 ) THEN

Line 4964: --FND_MSG_PUB.ADD;

4960: l_newStatus := 5;
4961: end if;
4962: else
4963: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4964: --FND_MSG_PUB.ADD;
4965: l_retval := -907;
4966: end if;
4967: end if;
4968: else

Line 4974: --FND_MSG_PUB.ADD;

4970: if( p_db_current_status in (1, 4, 5, 6, 7) ) THEN
4971: l_newStatus := 3;
4972: else
4973: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4974: --FND_MSG_PUB.ADD;
4975: l_retval := -908;
4976: end if;
4977: elsif( p_ser_num_ctrl_code = 6 ) THEN
4978: if( p_db_current_status in (5,7) AND ( p_trx_src_type_id = 7 OR p_trx_action_id = 12) ) THEN

Line 4982: --FND_MSG_PUB.ADD;

4978: if( p_db_current_status in (5,7) AND ( p_trx_src_type_id = 7 OR p_trx_action_id = 12) ) THEN
4979: l_newStatus := 1;
4980: else
4981: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4982: --FND_MSG_PUB.ADD;
4983: l_retval := -908;
4984: end if;
4985: end if;
4986: end if;

Line 4990: --FND_MSG_PUB.ADD;

4986: end if;
4987: elsif( l_groupId = 4 ) THEN
4988: if( p_db_current_status <> 3 ) THEN
4989: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
4990: --FND_MSG_PUB.ADD;
4991: l_retval := -909;
4992: end if;
4993: elsif( l_groupId = 5 ) THEN
4994: --dbms_output.put_line('standard group');

Line 5001: --FND_MSG_PUB.ADD;

4997: if( p_db_current_status = 3 ) then
4998: l_newStatus := 4;
4999: else
5000: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
5001: --FND_MSG_PUB.ADD;
5002: l_retval := -910;
5003: end if;
5004: end if;
5005: else

Line 5011: --FND_MSG_PUB.ADD;

5007: if( p_ser_num_ctrl_code in (2, 3, 5) ) THEN
5008: if( l_isRestrictRcptSerial = 1 AND p_trx_action_id = 27 AND
5009: p_db_current_status = 4 AND p_db_lst_txn_src_Type_id = 2 ) THEN
5010: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
5011: --FND_MSG_PUB.ADD;
5012: l_retval := -911;
5013: end if;
5014: if( p_db_current_status in (1, 4, 6)) THEN
5015: if( p_trx_action_id = 3 AND p_xfr_ser_num_ctrl_code = 6 ) THEN

Line 5026: --FND_MSG_PUB.ADD;

5022: (p_trx_src_type_id = 1 AND p_db_current_status = 7 )) THEN
5023: l_newStatus := 3;
5024: else
5025: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SERIAL');
5026: --FND_MSG_PUB.ADD;
5027: l_retval := -912;
5028: end if;
5029: end if;
5030: end if;

Line 5333: fnd_msg_pub.initialize;

5329: RAISE fnd_api.g_exc_unexpected_error;
5330: END IF;
5331: -- Initialize message list if p_init_msg_list is set to TRUE.
5332: IF fnd_api.to_boolean(p_init_msg_list) THEN
5333: fnd_msg_pub.initialize;
5334: END IF;
5335:
5336: -- Initialize API return status to success
5337:

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

6411: COMMIT WORK;
6412: END IF;
6413:
6414: -- Standard call to get message count and if count is 1, get message info.
6415: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_msg_data);
6416: x_msg_data := SUBSTR(l_msg_data, 0, 198);
6417: EXCEPTION
6418: WHEN OTHERS THEN
6419: ROLLBACK TO apiinsertserial_apipub;

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

6417: EXCEPTION
6418: WHEN OTHERS THEN
6419: ROLLBACK TO apiinsertserial_apipub;
6420:
6421: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6422: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertRangeUnitTrx');
6423: END IF;
6424:
6425: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

6418: WHEN OTHERS THEN
6419: ROLLBACK TO apiinsertserial_apipub;
6420:
6421: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6422: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertRangeUnitTrx');
6423: END IF;
6424:
6425: x_return_status := fnd_api.g_ret_sts_unexp_error;
6426: END insertRangeUnitTrx;

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

6559: END IF; --l_serial_control_code IN (1,6)
6560:
6561: EXCEPTION
6562: WHEN OTHERS THEN
6563: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6564: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'is_serial_controlled');
6565: IF l_debug = 1 THEN
6566: invtrace('Exception:'||SQLERRM);
6567: END IF;

Line 6564: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'is_serial_controlled');

6560:
6561: EXCEPTION
6562: WHEN OTHERS THEN
6563: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6564: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'is_serial_controlled');
6565: IF l_debug = 1 THEN
6566: invtrace('Exception:'||SQLERRM);
6567: END IF;
6568: