DBA Data[Home] [Help]

APPS.INV_RSV_DETAIL_STAGE_PVT dependencies on FND_MSG_PUB

Line 759: fnd_msg_pub.ADD;

755: IF (l_debug = 1) THEN
756: debug_print(' return error from query reservation: '||l_return_status);
757: END IF;
758: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
759: fnd_msg_pub.ADD;
760: RAISE fnd_api.g_exc_unexpected_error;
761: END IF;
762:
763: IF l_mtl_reservation_count > 0 THEN

Line 1024: fnd_msg_pub.ADD;

1020: IF (l_debug = 1) THEN
1021: debug_print('return error from update reservation: '||l_return_status);
1022: END IF;
1023: fnd_message.set_name('INV', 'INV_UPD_RSV_FAILED');
1024: fnd_msg_pub.ADD;
1025: RAISE fnd_api.g_exc_unexpected_error;
1026: END IF;
1027: END IF; --IF l_remaining_reservation_qty >= l_mtl_reservation_non_staged(i).reservation_quantity
1028:

Line 1148: fnd_msg_pub.ADD;

1144: IF (l_debug = 1) THEN
1145: debug_print('return error from query reservation: '||l_return_status);
1146: END IF;
1147: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
1148: fnd_msg_pub.ADD;
1149: RAISE fnd_api.g_exc_unexpected_error;
1150: END IF;
1151:
1152: IF (l_debug = 1) THEN

Line 1180: fnd_msg_pub.ADD;

1176: IF (l_debug = 1) THEN
1177: debug_print(' return error from query reservation: '||l_return_status);
1178: END IF;
1179: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
1180: fnd_msg_pub.ADD;
1181: RAISE fnd_api.g_exc_unexpected_error;
1182: END IF;
1183:
1184: l_mtl_reservation_det_qty := l_mtl_reservation_detailed(1) ;

Line 1212: fnd_msg_pub.ADD;

1208: IF (l_debug = 1) THEN
1209: debug_print('return error from update reservation: '||l_return_status);
1210: END IF;
1211: fnd_message.set_name('INV', 'INV_UPD_RSV_FAILED');
1212: fnd_msg_pub.ADD;
1213: RAISE fnd_api.g_exc_unexpected_error;
1214: END IF;
1215:
1216: IF (l_debug = 1) THEN

Line 1258: fnd_msg_pub.ADD;

1254: IF (l_debug = 1) THEN
1255: debug_print(' return error from query reservation: '||l_return_status);
1256: END IF;
1257: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
1258: fnd_msg_pub.ADD;
1259: RAISE fnd_api.g_exc_unexpected_error;
1260: END IF;
1261:
1262: l_mtl_reservation_staged := l_mtl_reservation_detailed(1) ;

Line 1291: fnd_msg_pub.ADD;

1287: IF (l_debug = 1) THEN
1288: debug_print('return error from update reservation: '||l_return_status);
1289: END IF;
1290: fnd_message.set_name('INV', 'INV_UPD_RSV_FAILED');
1291: fnd_msg_pub.ADD;
1292: RAISE fnd_api.g_exc_unexpected_error;
1293: END IF;
1294:
1295: END IF; --IF l_det_res_id IS NOT NULL THEN

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

1305: x_return_status := fnd_api.g_ret_sts_error;
1306: IF (l_debug = 1) THEN
1307: debug_print('Error occurred in Process Reservation : '||l_return_status);
1308: END IF;
1309: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1310:
1311:
1312: WHEN fnd_api.g_exc_unexpected_error THEN
1313: ROLLBACK TO process_reservation_ds;

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

1314: x_return_status := fnd_api.g_ret_sts_unexp_error;
1315: IF (l_debug = 1) THEN
1316: debug_print('Unexpected error occurred in Process Reservation : '||l_return_status);
1317: END IF;
1318: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1319:
1320: WHEN OTHERS THEN
1321: ROLLBACK TO process_reservation_ds;
1322: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1322: x_return_status := fnd_api.g_ret_sts_unexp_error;
1323: IF (l_debug = 1) THEN
1324: debug_print('Unexpected error occurred in Process Reservation : '||l_return_status);
1325: END IF;
1326: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1327:
1328: END process_reservation;
1329:
1330: END inv_rsv_detail_stage_pvt;