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.WIP_SO_RESERVATIONS dependencies on FND_MSG_PUB

Line 47: fnd_msg_pub.initialize;

43:
44: BEGIN
45:
46: SAVEPOINT allocate_completion_to_so_0;
47: fnd_msg_pub.initialize;
48:
49: -------------------
50: -- Get reservation
51: -------------------

Line 134: fnd_msg_pub.add;

130: -- if item under lot control, there must be lot number
131: IF (l_transaction_tbl(i).lot_control_code = WIP_CONSTANTS.LOT
132: AND l_transaction_tbl(i).lot_number IS NULL) THEN
133: fnd_message.set_name('WIP', 'WIP_NO_LOT_NUMBER');
134: fnd_msg_pub.add;
135: RAISE fnd_api.g_exc_error;
136: END IF;
137:
138: IF (l_transaction_tbl(i).primary_quantity IS NULL

Line 141: fnd_msg_pub.add;

137:
138: IF (l_transaction_tbl(i).primary_quantity IS NULL
139: OR l_transaction_tbl(i).transaction_quantity IS NULL) THEN
140: fnd_message.set_name('WIP', 'WIP_ZERO_TRANSACTION_QUANTITY');
141: fnd_msg_pub.add;
142: RAISE fnd_api.g_exc_error;
143: END IF;
144:
145: -- Sales order specified in the form line

Line 255: fnd_msg_pub.add;

251: ELSE
252: /* ER 4163405: Replacing message WIP_SALES_ORDER_INCONSISTENCY with
253: the new message WIP_NO_SUPPLY_RESERVATIONS */
254: fnd_message.set_name('WIP', 'WIP_NO_SUPPLY_RESERVATIONS');
255: fnd_msg_pub.add;
256: RAISE fnd_api.g_exc_error;
257: END IF; -- reservation found for this completion
258: ELSE -- demand source not specified
259: WHILE (l_transaction_tbl(i).primary_quantity > 0) LOOP

Line 366: fnd_msg_pub.count_and_get(

362:
363: WHEN fnd_api.g_exc_error THEN
364: x_return_status := fnd_api.g_ret_sts_error;
365:
366: fnd_msg_pub.count_and_get(
367: p_encoded => fnd_api.g_false,
368: p_count => x_msg_count,
369: p_data => x_msg_data);
370:

Line 376: fnd_msg_pub.count_and_get(

372:
373: WHEN fnd_api.g_exc_unexpected_error THEN
374: x_return_status := fnd_api.g_ret_sts_unexp_error;
375:
376: fnd_msg_pub.count_and_get(
377: p_encoded => fnd_api.g_false,
378: p_count => x_msg_count,
379: p_data => x_msg_data);
380:

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

381: ROLLBACK TO SAVEPOINT allocate_completion_to_so_0;
382:
383: WHEN OTHERS THEN
384: x_return_status := fnd_api.g_ret_sts_unexp_error;
385: IF(fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
386: fnd_msg_pub.add_exc_msg (
387: g_package_name,
388: l_routine_name);
389: END IF;

Line 386: fnd_msg_pub.add_exc_msg (

382:
383: WHEN OTHERS THEN
384: x_return_status := fnd_api.g_ret_sts_unexp_error;
385: IF(fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
386: fnd_msg_pub.add_exc_msg (
387: g_package_name,
388: l_routine_name);
389: END IF;
390:

Line 391: fnd_msg_pub.count_and_get(

387: g_package_name,
388: l_routine_name);
389: END IF;
390:
391: fnd_msg_pub.count_and_get(
392: p_encoded => fnd_api.g_false,
393: p_count => x_msg_count,
394: p_data => x_msg_data);
395:

Line 468: fnd_msg_pub.initialize;

464: l_wip_entity_type number; /* Bug#4472589 */
465:
466: BEGIN
467: SAVEPOINT return_reservation_to_wip_0;
468: fnd_msg_pub.initialize;
469:
470: /* Fix for Bug#4472589. Sales Order functionality not present for EAM WO
471: * therefore no need to execute this procedure. just return back with valid
472: * status

Line 544: fnd_msg_pub.add;

540: -- if item under lot control, there must be lot number
541: IF(l_transaction_tbl(i).lot_control_code = WIP_CONSTANTS.LOT
542: AND l_transaction_tbl(i).lot_number IS NULL) THEN
543: fnd_message.set_name('WIP', 'WIP_NO_LOT_NUMBER');
544: fnd_msg_pub.add;
545: RAISE fnd_api.g_exc_error;
546: END IF;
547:
548: IF(l_transaction_tbl(i).demand_source_header_id IS NULL) THEN

Line 623: fnd_msg_pub.add;

619: if(l_valid_reservation) then
620: x_return_status := fnd_api.g_ret_sts_success;
621: else
622: fnd_message.set_name('WIP', 'WIP_NO_INVENTORY_RESERVATIONS');
623: fnd_msg_pub.add;
624: RAISE fnd_api.g_exc_error;
625: end if;
626:
627: EXCEPTION

Line 634: fnd_msg_pub.count_and_get(

630:
631: WHEN fnd_api.g_exc_error THEN
632: x_return_status := fnd_api.g_ret_sts_error;
633:
634: fnd_msg_pub.count_and_get(
635: p_encoded => fnd_api.g_false,
636: p_count => x_msg_count,
637: p_data => x_msg_data);
638:

Line 644: fnd_msg_pub.count_and_get(

640:
641: WHEN fnd_api.g_exc_unexpected_error THEN
642: x_return_status := fnd_api.g_ret_sts_unexp_error;
643:
644: fnd_msg_pub.count_and_get(
645: p_encoded => fnd_api.g_false,
646: p_count => x_msg_count,
647: p_data => x_msg_data);
648:

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

649: ROLLBACK TO SAVEPOINT return_reservation_to_wip_0;
650:
651: WHEN OTHERS THEN
652: x_return_status := fnd_api.g_ret_sts_unexp_error;
653: IF(fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
654: fnd_msg_pub.add_exc_msg (
655: g_package_name,
656: l_routine_name);
657: END IF;

Line 654: fnd_msg_pub.add_exc_msg (

650:
651: WHEN OTHERS THEN
652: x_return_status := fnd_api.g_ret_sts_unexp_error;
653: IF(fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
654: fnd_msg_pub.add_exc_msg (
655: g_package_name,
656: l_routine_name);
657: END IF;
658:

Line 659: fnd_msg_pub.count_and_get(

655: g_package_name,
656: l_routine_name);
657: END IF;
658:
659: fnd_msg_pub.count_and_get(
660: p_encoded => fnd_api.g_false,
661: p_count => x_msg_count,
662: p_data => x_msg_data);
663:

Line 736: fnd_msg_pub.add;

732: if(l_logLevel <= wip_constants.full_logging) then
733: wip_logger.log('no lot', l_return_status);
734: end if;
735: fnd_message.set_name('WIP', 'WIP_NO_LOT_NUMBER');
736: fnd_msg_pub.add;
737: RAISE fnd_api.g_exc_error;
738: END IF;
739:
740: IF (p_transaction_tbl(i).primary_quantity IS NULL OR

Line 748: fnd_msg_pub.add;

744: if(l_logLevel <= wip_constants.full_logging) then
745: wip_logger.log('no qty', l_return_status);
746: end if;
747: fnd_message.set_name('WIP', 'WIP_ZERO_TRANSACTION_QUANTITY');
748: fnd_msg_pub.add;
749: RAISE fnd_api.g_exc_error;
750: END IF;
751:
752: ----------------------------------

Line 798: fnd_msg_pub.add;

794: if(l_logLevel <= wip_constants.full_logging) then
795: wip_logger.log('Bad SO info or no open demand. Skipping reservation.', l_return_status);
796: end if;
797: /* fnd_message.set_name('WIP', 'WIP_INVALID_SO_TXN_INFO');
798: fnd_msg_pub.add;
799: RAISE fnd_api.g_exc_error; */
800: END;
801:
802: if (l_skip_flag = FALSE) then

Line 822: fnd_msg_pub.add;

818: fnd_message.set_name('WIP', 'QUANTITY_ERROR');
819: fnd_message.set_token(
820: token => 'ORDER_QUANTITY',
821: value => l_primary_open_quantity);
822: fnd_msg_pub.add;
823: RAISE fnd_api.g_exc_error;
824: */
825: END IF;
826:

Line 1026: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1022: end if;
1023:
1024: WHEN fnd_api.g_exc_error THEN
1025: x_return_status := fnd_api.g_ret_sts_error;
1026: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1027: p_count => x_msg_count,
1028: p_data => x_msg_data);
1029: rollback to transfer_flow_lines_0;
1030: if (l_logLevel <= wip_constants.trace_logging) then

Line 1039: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1035: end if;
1036:
1037: WHEN fnd_api.g_exc_unexpected_error THEN
1038: x_return_status := fnd_api.g_ret_sts_unexp_error;
1039: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1040: p_count => x_msg_count,
1041: p_data => x_msg_data);
1042: rollback to transfer_flow_lines_0;
1043: if (l_logLevel <= wip_constants.trace_logging) then

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

1048: end if;
1049:
1050: WHEN OTHERS THEN
1051: x_return_status := fnd_api.g_ret_sts_unexp_error;
1052: IF(fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1053: fnd_msg_pub.add_exc_msg (g_package_name,
1054: l_routine_name);
1055: END IF;
1056:

Line 1053: fnd_msg_pub.add_exc_msg (g_package_name,

1049:
1050: WHEN OTHERS THEN
1051: x_return_status := fnd_api.g_ret_sts_unexp_error;
1052: IF(fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1053: fnd_msg_pub.add_exc_msg (g_package_name,
1054: l_routine_name);
1055: END IF;
1056:
1057: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 1057: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1053: fnd_msg_pub.add_exc_msg (g_package_name,
1054: l_routine_name);
1055: END IF;
1056:
1057: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1058: p_count => x_msg_count,
1059: p_data => x_msg_data);
1060:
1061: rollback to transfer_flow_lines_0;

Line 1157: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1153: end if;
1154: rollback to complete_flow_sched_to_so_1;
1155: WHEN fnd_api.g_exc_error THEN
1156: x_return_status := fnd_api.g_ret_sts_error;
1157: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1158: p_count => x_msg_count,
1159: p_data => x_msg_data);
1160: if(x_msg_data is null and l_msg_data is not null) then
1161: x_msg_data := l_msg_data;

Line 1173: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1169: x_returnStatus => l_return_Status); --discard logging return status
1170: end if;
1171: WHEN fnd_api.g_exc_unexpected_error THEN
1172: x_return_status := fnd_api.g_ret_sts_unexp_error;
1173: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1174: p_count => x_msg_count,
1175: p_data => x_msg_data);
1176: rollback to complete_flow_sched_to_so_1;
1177: if(l_logLevel <= wip_constants.trace_logging) then

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

1181: x_returnStatus => l_return_Status); --discard logging return status
1182: end if;
1183: WHEN OTHERS THEN
1184: x_return_status := fnd_api.g_ret_sts_unexp_error;
1185: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1186: fnd_msg_pub.add_exc_msg (g_package_name,
1187: l_routine_name);
1188: END IF;
1189: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 1186: fnd_msg_pub.add_exc_msg (g_package_name,

1182: end if;
1183: WHEN OTHERS THEN
1184: x_return_status := fnd_api.g_ret_sts_unexp_error;
1185: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1186: fnd_msg_pub.add_exc_msg (g_package_name,
1187: l_routine_name);
1188: END IF;
1189: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1190: p_count => x_msg_count,

Line 1189: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1185: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1186: fnd_msg_pub.add_exc_msg (g_package_name,
1187: l_routine_name);
1188: END IF;
1189: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1190: p_count => x_msg_count,
1191: p_data => x_msg_data);
1192: rollback to complete_flow_sched_to_so_1;
1193: if(l_logLevel <= wip_constants.trace_logging) then

Line 1259: fnd_msg_pub.initialize;

1255:
1256:
1257: SAVEPOINT complete_flow_sched_to_so_0;
1258:
1259: fnd_msg_pub.initialize;
1260:
1261: ----------------------
1262: -- Get form txn lines
1263: ----------------------

Line 1313: fnd_msg_pub.count_and_get(

1309: EXCEPTION
1310: WHEN g_need_to_rollback_exception THEN
1311: ROLLBACK TO SAVEPOINT complete_flow_sched_to_so_0;
1312: /* Fix for Bug3035884 . Added following procedure call */
1313: fnd_msg_pub.count_and_get(
1314: p_encoded => fnd_api.g_false,
1315: p_count => x_msg_count,
1316: p_data => x_msg_data);
1317:

Line 1322: fnd_msg_pub.count_and_get(

1318: WHEN fnd_api.g_exc_error THEN
1319:
1320: x_return_status := fnd_api.g_ret_sts_error;
1321:
1322: fnd_msg_pub.count_and_get(
1323: p_encoded => fnd_api.g_false,
1324: p_count => x_msg_count,
1325: p_data => x_msg_data);
1326:

Line 1333: fnd_msg_pub.count_and_get(

1329: WHEN fnd_api.g_exc_unexpected_error THEN
1330:
1331: x_return_status := fnd_api.g_ret_sts_unexp_error;
1332:
1333: fnd_msg_pub.count_and_get(
1334: p_encoded => fnd_api.g_false,
1335: p_count => x_msg_count,
1336: p_data => x_msg_data);
1337:

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

1339:
1340: WHEN OTHERS THEN
1341:
1342: x_return_status := fnd_api.g_ret_sts_unexp_error;
1343: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1344: fnd_msg_pub.add_exc_msg (
1345: g_package_name,
1346: l_routine_name);
1347: END IF;

Line 1344: fnd_msg_pub.add_exc_msg (

1340: WHEN OTHERS THEN
1341:
1342: x_return_status := fnd_api.g_ret_sts_unexp_error;
1343: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1344: fnd_msg_pub.add_exc_msg (
1345: g_package_name,
1346: l_routine_name);
1347: END IF;
1348:

Line 1349: fnd_msg_pub.count_and_get(

1345: g_package_name,
1346: l_routine_name);
1347: END IF;
1348:
1349: fnd_msg_pub.count_and_get(
1350: p_encoded => fnd_api.g_false,
1351: p_count => x_msg_count,
1352: p_data => x_msg_data);
1353:

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

1381:
1382: EXCEPTION
1383: WHEN OTHERS THEN
1384: x_return_status := fnd_api.g_ret_sts_unexp_error;
1385: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1386: fnd_msg_pub.add_exc_msg(g_package_name, l_routine_name);
1387: END IF;
1388: fnd_msg_pub.count_and_get(
1389: p_count => x_msg_count,

Line 1386: fnd_msg_pub.add_exc_msg(g_package_name, l_routine_name);

1382: EXCEPTION
1383: WHEN OTHERS THEN
1384: x_return_status := fnd_api.g_ret_sts_unexp_error;
1385: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1386: fnd_msg_pub.add_exc_msg(g_package_name, l_routine_name);
1387: END IF;
1388: fnd_msg_pub.count_and_get(
1389: p_count => x_msg_count,
1390: p_data => x_msg_data);

Line 1388: fnd_msg_pub.count_and_get(

1384: x_return_status := fnd_api.g_ret_sts_unexp_error;
1385: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1386: fnd_msg_pub.add_exc_msg(g_package_name, l_routine_name);
1387: END IF;
1388: fnd_msg_pub.count_and_get(
1389: p_count => x_msg_count,
1390: p_data => x_msg_data);
1391:
1392: END split_order_line;

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

1505: WHEN OTHERS THEN
1506: IF (c_transaction_lines%ISOPEN) THEN
1507: CLOSE c_transaction_lines;
1508: END IF;
1509: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1510: fnd_msg_pub.add_exc_msg(g_package_name, l_routine_name);
1511: END IF;
1512:
1513: END get_transaction_lines;

Line 1510: fnd_msg_pub.add_exc_msg(g_package_name, l_routine_name);

1506: IF (c_transaction_lines%ISOPEN) THEN
1507: CLOSE c_transaction_lines;
1508: END IF;
1509: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1510: fnd_msg_pub.add_exc_msg(g_package_name, l_routine_name);
1511: END IF;
1512:
1513: END get_transaction_lines;
1514:

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

1605: WHEN OTHERS THEN
1606: IF (c_transaction_lines%ISOPEN) THEN
1607: CLOSE c_transaction_lines;
1608: END IF;
1609: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1610: fnd_msg_pub.add_exc_msg(g_package_name, l_routine_name);
1611: END IF;
1612:
1613: END get_transaction_lines;

Line 1610: fnd_msg_pub.add_exc_msg(g_package_name, l_routine_name);

1606: IF (c_transaction_lines%ISOPEN) THEN
1607: CLOSE c_transaction_lines;
1608: END IF;
1609: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1610: fnd_msg_pub.add_exc_msg(g_package_name, l_routine_name);
1611: END IF;
1612:
1613: END get_transaction_lines;
1614:

Line 1757: fnd_msg_pub.add;

1753: -- in the form is incorrect. error out and provide a good explanation
1754: -- to the user.
1755: WHEN NO_DATA_FOUND THEN
1756: fnd_message.set_name('WIP', 'WIP_INVALID_SO');
1757: fnd_msg_pub.add;
1758: RAISE fnd_api.g_exc_error;
1759:
1760: END;
1761:

Line 1841: FND_MSG_PUB.Add;

1837: , p_validation_flag => fnd_api.g_true
1838: );
1839: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1840: FND_MESSAGE.SET_NAME('INV','INV_UPD_RSV_FAILED');
1841: FND_MSG_PUB.Add;
1842: RAISE fnd_api.g_exc_unexpected_error;
1843: END IF ;
1844: else
1845:

Line 1871: fnd_msg_pub.add;

1867: END IF;
1868: END IF ;
1869:
1870: /* fnd_message.set_name('WIP', 'WIP_OVER_COMPLETE');
1871: fnd_msg_pub.add;
1872: RAISE fnd_api.g_exc_error; */
1873: x_query_reservation := 'Y';
1874:
1875: END IF; -- check transaction type

Line 1896: fnd_msg_pub.add;

1892: p_reservation_rec.subinventory_code) THEN
1893: fnd_message.set_name('WIP', 'WIP_INVALID_SUBINV');
1894: fnd_message.set_token('TXN_SUB', p_transaction_rec.subinventory_code);
1895: fnd_message.set_token('SO_SUB', p_reservation_rec.subinventory_code);
1896: fnd_msg_pub.add;
1897: RAISE fnd_api.g_exc_error;
1898: END IF;
1899:
1900:

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

1909: return FALSE;
1910:
1911: WHEN OTHERS THEN
1912: x_return_status := fnd_api.g_ret_sts_unexp_error;
1913: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1914: fnd_msg_pub.add_exc_msg(g_package_name, l_routine_name);
1915: END IF;
1916: return FALSE;
1917:

Line 1914: fnd_msg_pub.add_exc_msg(g_package_name, l_routine_name);

1910:
1911: WHEN OTHERS THEN
1912: x_return_status := fnd_api.g_ret_sts_unexp_error;
1913: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1914: fnd_msg_pub.add_exc_msg(g_package_name, l_routine_name);
1915: END IF;
1916: return FALSE;
1917:
1918: END validate_txn_line_against_rsv;

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

2014: EXCEPTION
2015: WHEN OTHERS THEN
2016: x_return_status := fnd_api.g_ret_sts_unexp_error;
2017:
2018: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2019: fnd_msg_pub.add_exc_msg(g_package_name, l_routine_name);
2020: END IF;
2021:
2022: END transfer_reservation;

Line 2019: fnd_msg_pub.add_exc_msg(g_package_name, l_routine_name);

2015: WHEN OTHERS THEN
2016: x_return_status := fnd_api.g_ret_sts_unexp_error;
2017:
2018: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2019: fnd_msg_pub.add_exc_msg(g_package_name, l_routine_name);
2020: END IF;
2021:
2022: END transfer_reservation;
2023:

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

2086:
2087: EXCEPTION
2088: when others then
2089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2090: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2091: FND_MSG_PUB.Add_Exc_Msg(g_package_name, l_api_name);
2092: END IF;
2093: FND_MSG_PUB.Count_And_Get(
2094: p_count => x_msg_count,

Line 2091: FND_MSG_PUB.Add_Exc_Msg(g_package_name, l_api_name);

2087: EXCEPTION
2088: when others then
2089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2090: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2091: FND_MSG_PUB.Add_Exc_Msg(g_package_name, l_api_name);
2092: END IF;
2093: FND_MSG_PUB.Count_And_Get(
2094: p_count => x_msg_count,
2095: p_data => x_msg_data

Line 2093: FND_MSG_PUB.Count_And_Get(

2089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2090: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2091: FND_MSG_PUB.Add_Exc_Msg(g_package_name, l_api_name);
2092: END IF;
2093: FND_MSG_PUB.Count_And_Get(
2094: p_count => x_msg_count,
2095: p_data => x_msg_data
2096: );
2097:

Line 2228: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2224: x_status := fnd_api.g_ret_sts_success;
2225:
2226: EXCEPTION
2227: WHEN others THEN
2228: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2229: p_count => x_msg_count,
2230: p_data => x_msg_data);
2231: x_status := fnd_api.g_ret_sts_error;
2232: IF (l_response_code = WIP_CONSTANTS.ALWAYS) THEN

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

2305: WHEN OTHERS THEN
2306: IF (c_move_transaction_lines%ISOPEN) THEN
2307: CLOSE c_move_transaction_lines;
2308: END IF;
2309: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2310: fnd_msg_pub.add_exc_msg(g_package_name, l_routine_name);
2311: END IF;
2312:
2313: END get_move_transaction_lines;

Line 2310: fnd_msg_pub.add_exc_msg(g_package_name, l_routine_name);

2306: IF (c_move_transaction_lines%ISOPEN) THEN
2307: CLOSE c_move_transaction_lines;
2308: END IF;
2309: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2310: fnd_msg_pub.add_exc_msg(g_package_name, l_routine_name);
2311: END IF;
2312:
2313: END get_move_transaction_lines;
2314:

Line 2371: fnd_msg_pub.initialize;

2367:
2368: Begin
2369: SAVEPOINT Relieve_Rsv_scrap_txn_sp;
2370:
2371: fnd_msg_pub.initialize;
2372:
2373: For current_job in wmti_disc_jobs(p_group_id)
2374: Loop
2375: l_wip_entity_id := current_job.wip_entity_id;

Line 2464: fnd_msg_pub.count_and_get(

2460: WHEN fnd_api.g_exc_error THEN
2461:
2462: x_return_status := fnd_api.g_ret_sts_error;
2463:
2464: fnd_msg_pub.count_and_get(
2465: p_encoded => fnd_api.g_false,
2466: p_count => x_msg_count,
2467: p_data => x_msg_data);
2468:

Line 2475: fnd_msg_pub.count_and_get(

2471: WHEN fnd_api.g_exc_unexpected_error THEN
2472:
2473: x_return_status := fnd_api.g_ret_sts_unexp_error;
2474:
2475: fnd_msg_pub.count_and_get(
2476: p_encoded => fnd_api.g_false,
2477: p_count => x_msg_count,
2478: p_data => x_msg_data);
2479:

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

2481:
2482: WHEN OTHERS THEN
2483:
2484: x_return_status := fnd_api.g_ret_sts_unexp_error;
2485: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
2486: fnd_msg_pub.add_exc_msg (
2487: g_package_name,
2488: l_routine_name);
2489: END IF;

Line 2486: fnd_msg_pub.add_exc_msg (

2482: WHEN OTHERS THEN
2483:
2484: x_return_status := fnd_api.g_ret_sts_unexp_error;
2485: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
2486: fnd_msg_pub.add_exc_msg (
2487: g_package_name,
2488: l_routine_name);
2489: END IF;
2490:

Line 2491: fnd_msg_pub.count_and_get(

2487: g_package_name,
2488: l_routine_name);
2489: END IF;
2490:
2491: fnd_msg_pub.count_and_get(
2492: p_encoded => fnd_api.g_false,
2493: p_count => x_msg_count,
2494: p_data => x_msg_data);
2495:

Line 2534: fnd_msg_pub.initialize;

2530: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
2531:
2532:
2533: BEGIN
2534: fnd_msg_pub.initialize;
2535: l_quantity_to_be_relieved := p_primary_quantity;
2536:
2537: -- dbms_output.put_line('l_quantity_to_be_relieved : '||l_quantity_to_be_relieved );
2538:

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

2626:
2627: EXCEPTION
2628: WHEN OTHERS THEN
2629: x_return_status := fnd_api.g_ret_sts_unexp_error;
2630: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2631: fnd_msg_pub.add_exc_msg(g_package_name, l_routine_name);
2632: END IF;
2633: END Relieve_wip_reservation;
2634:

Line 2631: fnd_msg_pub.add_exc_msg(g_package_name, l_routine_name);

2627: EXCEPTION
2628: WHEN OTHERS THEN
2629: x_return_status := fnd_api.g_ret_sts_unexp_error;
2630: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2631: fnd_msg_pub.add_exc_msg(g_package_name, l_routine_name);
2632: END IF;
2633: END Relieve_wip_reservation;
2634:
2635: -- Fixed bug 5471890. Need to create PL/SQL wrapper when calling inventory