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_PICKING_PVT dependencies on FND_API

Line 49: raise fnd_api.G_EXC_UNEXPECTED_ERROR;

45: arg_alt_bom_desig => p_alternate_bom_designator,
46: arg_error_code => l_errCode,
47: arg_err_msg => x_msg_data);
48: if(l_errCode <> 0) then
49: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
50: else
51: x_return_status := fnd_api.g_ret_sts_success;
52: end if;
53:

Line 51: x_return_status := fnd_api.g_ret_sts_success;

47: arg_err_msg => x_msg_data);
48: if(l_errCode <> 0) then
49: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
50: else
51: x_return_status := fnd_api.g_ret_sts_success;
52: end if;
53:
54: FOR l_compRec IN c_components LOOP
55: update bom_explosions

Line 77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

73: if(c_lock%ISOPEN) then
74: close c_lock;
75: end if;
76: ROLLBACK TO WIP_EXPLODE_START;
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
79: fnd_message.set_token('ERROR_TEXT', SQLERRM);
80: /*This line is added as a fix for bug#2629809*/
81: x_msg_data := fnd_message.get;

Line 158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

154: wip_constants.lotbased,
155: wip_constants.repetitive,
156: wip_constants.flow,
157: wip_constants.eam)) then
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
160: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pub.Incorrect Entity type passed');
161: x_msg_data := fnd_message.get;
162: return ;

Line 167: x_return_status := FND_API.G_RET_STS_SUCCESS; -- in case no open lines are found

163: end if ;
164:
165: SAVEPOINT WIP_CANCEL_ALLOCS_START;
166:
167: x_return_status := FND_API.G_RET_STS_SUCCESS; -- in case no open lines are found
168: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
169: open c_discLines;
170: elsif(p_wip_entity_type = wip_constants.repetitive) then
171: open c_repLines;

Line 194: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

190: p_openQty => l_openQty,
191: x_return_status => x_return_status,
192: x_msg_data => x_msg_data);
193:
194: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
195: if(c_discLines%ISOPEN) then
196: close c_discLines;
197: elsif(c_repLines%ISOPEN) then
198: close c_repLines;

Line 202: raise FND_API.G_EXC_UNEXPECTED_ERROR;

198: close c_repLines;
199: elsif(c_flowLines%ISOPEN) then
200: close c_flowLines;
201: end if;
202: raise FND_API.G_EXC_UNEXPECTED_ERROR;
203: end if;
204: end loop;
205: if(c_discLines%ISOPEN) then
206: close c_discLines;

Line 225: when fnd_api.g_exc_unexpected_error then

221: where wip_entity_id = p_wip_entity_id
222: and repetitive_schedule_id = p_repetitive_schedule_id;
223: end if;
224: exception
225: when fnd_api.g_exc_unexpected_error then
226: ROLLBACK TO WIP_CANCEL_ALLOCS_START;
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: when others then
229: if(c_discLines%ISOPEN) then

Line 227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

223: end if;
224: exception
225: when fnd_api.g_exc_unexpected_error then
226: ROLLBACK TO WIP_CANCEL_ALLOCS_START;
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: when others then
229: if(c_discLines%ISOPEN) then
230: close c_discLines;
231: elsif(c_repLines%ISOPEN) then

Line 237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

233: elsif(c_flowLines%ISOPEN) then
234: close c_flowLines;
235: end if;
236: ROLLBACK TO WIP_CANCEL_ALLOCS_START;
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
239: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pub.cancel_allocations: ' || SQLERRM);
240: x_msg_data := fnd_message.get;
241: end cancel_allocations;

Line 299: x_return_status := FND_API.G_RET_STS_SUCCESS; -- in case no open lines are found

295:
296:
297: BEGIN
298: SAVEPOINT WIP_CANCEL_COMP_ALLOCS_START;
299: x_return_status := FND_API.G_RET_STS_SUCCESS; -- in case no open lines are found
300:
301: if (l_logLevel <= wip_constants.trace_logging) then
302: wip_logger.log('In wip_picking_pvt.cancel_comp_allocations', l_dummy);
303: end if;

Line 343: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

339: close c_discLines;
340: elsif(c_repLines%ISOPEN) then
341: close c_repLines;
342: end if;
343: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
344: if(c_discLines%ISOPEN) then
345: close c_discLines;
346: elsif(c_repLines%ISOPEN) then
347: close c_repLines;

Line 349: raise FND_API.G_EXC_UNEXPECTED_ERROR;

345: close c_discLines;
346: elsif(c_repLines%ISOPEN) then
347: close c_repLines;
348: end if;
349: raise FND_API.G_EXC_UNEXPECTED_ERROR;
350: end if;
351:
352: --finally update backordered quantity to 0
353: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then

Line 368: when fnd_api.g_exc_unexpected_error then

364: and operation_seq_num = p_operation_seq_num
365: and inventory_item_id = p_inventory_item_id;
366: end if;
367: exception
368: when fnd_api.g_exc_unexpected_error then
369: ROLLBACK TO WIP_CANCEL_COMP_ALLOCS_START;
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371: when others then
372: if(c_discLines%ISOPEN) then

Line 370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

366: end if;
367: exception
368: when fnd_api.g_exc_unexpected_error then
369: ROLLBACK TO WIP_CANCEL_COMP_ALLOCS_START;
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371: when others then
372: if(c_discLines%ISOPEN) then
373: close c_discLines;
374: elsif(c_repLines%ISOPEN) then

Line 378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

374: elsif(c_repLines%ISOPEN) then
375: close c_repLines;
376: end if;
377: ROLLBACK TO WIP_CANCEL_COMP_ALLOCS_START;
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
380: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pub.cancel_comp_allocations: ' || SQLERRM);
381: x_msg_data := fnd_message.get;
382: END cancel_comp_allocations;

Line 465: x_return_status := FND_API.G_RET_STS_SUCCESS; -- in case no open lines are found

461:
462:
463: BEGIN
464: SAVEPOINT WIP_REDUCE_COMP_ALLOCS_START;
465: x_return_status := FND_API.G_RET_STS_SUCCESS; -- in case no open lines are found
466: for i in 1..p_comp_tbl.COUNT LOOP /* Component Loop*/
467: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
468: open c_discLines(p_comp_tbl(i).wip_entity_id, p_comp_tbl(i).operation_seq_num, p_comp_tbl(i).inventory_item_id);
469: elsif(p_wip_entity_type = wip_constants.repetitive) then

Line 503: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

499:
500: if (l_reductionQty = 0) then
501: exit ;
502: end if;
503: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
504: if(c_discLines%ISOPEN) then
505: close c_discLines;
506: elsif(c_repLines%ISOPEN) then
507: close c_repLines;

Line 509: raise FND_API.G_EXC_UNEXPECTED_ERROR;

505: close c_discLines;
506: elsif(c_repLines%ISOPEN) then
507: close c_repLines;
508: end if;
509: raise FND_API.G_EXC_UNEXPECTED_ERROR;
510: end if;
511:
512: end Loop; /* End of MO lines loop */
513:

Line 545: when fnd_api.g_exc_unexpected_error then

541: and inventory_item_id = p_comp_tbl(i).inventory_item_id;
542: end if;
543: end LOOP; /*End of component loop*/
544: exception
545: when fnd_api.g_exc_unexpected_error then
546: ROLLBACK TO WIP_REDUCE_COMP_ALLOCS_START;
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
548: when others then
549: if(c_discLines%ISOPEN) then

Line 547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

543: end LOOP; /*End of component loop*/
544: exception
545: when fnd_api.g_exc_unexpected_error then
546: ROLLBACK TO WIP_REDUCE_COMP_ALLOCS_START;
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
548: when others then
549: if(c_discLines%ISOPEN) then
550: close c_discLines;
551: elsif(c_repLines%ISOPEN) then

Line 555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

551: elsif(c_repLines%ISOPEN) then
552: close c_repLines;
553: end if;
554: ROLLBACK TO WIP_REDUCE_COMP_ALLOCS_START;
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
557: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pub.cancel_allocations: ' || SQLERRM);
558: x_msg_data := fnd_message.get;
559: END reduce_comp_allocations;

Line 608: x_return_status := FND_API.G_RET_STS_SUCCESS; -- in case no open lines are found

604: l_lineID NUMBER;
605: l_msgCount NUMBER;
606: BEGIN
607: SAVEPOINT WIP_UPDATE_ALLOCS_START;
608: x_return_status := FND_API.G_RET_STS_SUCCESS; -- in case no open lines are found
609: if(p_repetitive_schedule_id is null) then
610: open c_discLines;
611: else
612: open c_repLines;

Line 628: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

624: p_op_seq_num => p_operation_seq_num,
625: x_msg_count => l_msgCount,
626: x_msg_data => x_msg_data,
627: x_return_status => x_return_status);
628: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
629: if(c_discLines%ISOPEN) then
630: close c_discLines;
631: elsif(c_repLines%ISOPEN) then
632: close c_repLines;

Line 634: raise FND_API.G_EXC_UNEXPECTED_ERROR;

630: close c_discLines;
631: elsif(c_repLines%ISOPEN) then
632: close c_repLines;
633: end if;
634: raise FND_API.G_EXC_UNEXPECTED_ERROR;
635: end if;
636: end loop;
637: if(c_discLines%ISOPEN) then
638: close c_discLines;

Line 644: when fnd_api.g_exc_unexpected_error then

640: close c_repLines;
641: end if;
642:
643: exception
644: when fnd_api.g_exc_unexpected_error then
645: ROLLBACK TO WIP_UPDATE_ALLOCS_START;
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
647: when others then
648: if(c_discLines%ISOPEN) then

Line 646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

642:
643: exception
644: when fnd_api.g_exc_unexpected_error then
645: ROLLBACK TO WIP_UPDATE_ALLOCS_START;
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
647: when others then
648: if(c_discLines%ISOPEN) then
649: close c_discLines;
650: elsif(c_repLines%ISOPEN) then

Line 654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

650: elsif(c_repLines%ISOPEN) then
651: close c_repLines;
652: end if;
653: ROLLBACK TO WIP_UPDATE_ALLOCS_START;
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
655: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
656: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pub.update_allocation_op_seqs: ' || SQLERRM);
657: end update_allocation_op_seqs;
658:

Line 772: if(l_dummy <> FND_API.G_RET_STS_SUCCESS) then

768: p_alt_rout_desig => p_alt_rout_desig,
769: x_comp_sql_tbl => x_comp_sql_tbl,
770: x_return_status => l_dummy,
771: x_msg_data => x_msg_data);
772: if(l_dummy <> FND_API.G_RET_STS_SUCCESS) then
773: x_explode_status := l_dummy;
774: x_optimize_status := FND_API.G_RET_STS_UNEXP_ERROR;
775: return;
776: end if;

Line 774: x_optimize_status := FND_API.G_RET_STS_UNEXP_ERROR;

770: x_return_status => l_dummy,
771: x_msg_data => x_msg_data);
772: if(l_dummy <> FND_API.G_RET_STS_SUCCESS) then
773: x_explode_status := l_dummy;
774: x_optimize_status := FND_API.G_RET_STS_UNEXP_ERROR;
775: return;
776: end if;
777:
778: explodeMultiLevel(p_organization_id => p_organization_id,

Line 792: if(l_dummy <> FND_API.G_RET_STS_SUCCESS) then

788: p_alt_rout_desig => p_alt_rout_desig,
789: x_comp_sql_tbl => l_comp_sql_tbl,
790: x_return_status => l_dummy,
791: x_msg_data => x_msg_data);
792: if(l_dummy <> FND_API.G_RET_STS_SUCCESS) then
793: x_explode_status := l_dummy;
794: x_optimize_status := FND_API.G_RET_STS_UNEXP_ERROR;
795: return;
796: end if;

Line 794: x_optimize_status := FND_API.G_RET_STS_UNEXP_ERROR;

790: x_return_status => l_dummy,
791: x_msg_data => x_msg_data);
792: if(l_dummy <> FND_API.G_RET_STS_SUCCESS) then
793: x_explode_status := l_dummy;
794: x_optimize_status := FND_API.G_RET_STS_UNEXP_ERROR;
795: return;
796: end if;
797:
798: x_explode_status := FND_API.G_RET_STS_SUCCESS;

Line 798: x_explode_status := FND_API.G_RET_STS_SUCCESS;

794: x_optimize_status := FND_API.G_RET_STS_UNEXP_ERROR;
795: return;
796: end if;
797:
798: x_explode_status := FND_API.G_RET_STS_SUCCESS;
799: if l_comp_sql_tbl.count <> x_comp_sql_tbl.count then
800: x_optimize_status := 'F';
801: end if;
802:

Line 829: x_optimize_status := FND_API.G_RET_STS_SUCCESS;

825: return;
826: end if;
827: end loop;
828:
829: x_optimize_status := FND_API.G_RET_STS_SUCCESS;
830:
831: end;
832:
833:

Line 852: l_explodeStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;

848: x_conc_req_id OUT NOCOPY NUMBER,
849: x_mo_req_number OUT NOCOPY VARCHAR2,
850: x_return_status OUT NOCOPY VARCHAR2,
851: x_msg_data OUT NOCOPY VARCHAR2) IS
852: l_explodeStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
853: l_explodeMessage VARCHAR2(2000);
854: l_lineCount NUMBER := 0;
855: l_lineCountHolder NUMBER;
856: l_pickStatus VARCHAR2(1) := 'N';

Line 857: l_backflushStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;

853: l_explodeMessage VARCHAR2(2000);
854: l_lineCount NUMBER := 0;
855: l_lineCountHolder NUMBER;
856: l_pickStatus VARCHAR2(1) := 'N';
857: l_backflushStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
858: l_optimizeStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
859: l_pickSetId NUMBER := 1;
860: l_itemID NUMBER;
861: l_operationSeqNum NUMBER;

Line 858: l_optimizeStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;

854: l_lineCount NUMBER := 0;
855: l_lineCountHolder NUMBER;
856: l_pickStatus VARCHAR2(1) := 'N';
857: l_backflushStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
858: l_optimizeStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
859: l_pickSetId NUMBER := 1;
860: l_itemID NUMBER;
861: l_operationSeqNum NUMBER;
862: l_subinv VARCHAR2(10);

Line 1229: if(l_dummy <> FND_API.G_RET_STS_SUCCESS) then

1225: p_alt_rout_desig => p_alloc_tbl(i).alt_rtg_dsg,
1226: x_comp_sql_tbl => l_flowCompTbl,
1227: x_return_status => l_dummy,
1228: x_msg_data => l_explodeMessage);
1229: if(l_dummy <> FND_API.G_RET_STS_SUCCESS) then
1230: l_explodeStatus := l_dummy;
1231: p_alloc_tbl(i).bill_seq_id := null; --reset the bill seq and org as the assy's bill could not be exploded
1232: P_alloc_tbl(i).bill_org_id := null;
1233: end if;

Line 1250: if(l_explodeStatus <> FND_API.G_RET_STS_SUCCESS) then

1246: x_comp_sql_tbl => l_flowCompTbl,
1247: x_explode_status => l_explodeStatus,
1248: x_optimize_status => l_optimizeStatus,
1249: x_msg_data => l_explodeMessage);
1250: if(l_explodeStatus <> FND_API.G_RET_STS_SUCCESS) then
1251: -- assy's bill could not be exploded, then reset the bill seq and org
1252: l_opt_cnt := 0;
1253: p_alloc_tbl(i).bill_seq_id := null;
1254: P_alloc_tbl(i).bill_org_id := null;

Line 1255: elsif (l_optimizeStatus <> FND_API.G_RET_STS_SUCCESS) then

1251: -- assy's bill could not be exploded, then reset the bill seq and org
1252: l_opt_cnt := 0;
1253: p_alloc_tbl(i).bill_seq_id := null;
1254: P_alloc_tbl(i).bill_org_id := null;
1255: elsif (l_optimizeStatus <> FND_API.G_RET_STS_SUCCESS) then
1256: -- can not optimize, b/c bom is not the same for the group,
1257: -- reset counter, and proceed as normal(one record at a time)
1258: l_opt_cnt := 0;
1259:

Line 1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1294:
1295: end if;
1296:
1297: else -- if(p_wip_entity_type = l_disc)
1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
1300: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.allocate: invalid entity_type' );
1301: x_msg_data := fnd_message.get;
1302: return;

Line 1392: if(x_return_status <> fnd_api.g_ret_sts_success) then

1388: p_linesRec => l_linesRec,
1389: x_return_status => x_return_status,
1390: x_msg_data => x_msg_data);
1391:
1392: if(x_return_status <> fnd_api.g_ret_sts_success) then
1393: raise FND_API.G_EXC_ERROR;
1394: end if;
1395:
1396: --we must do this check rather than supply types as a push component with a supply subinv provided only triggers a

Line 1393: raise FND_API.G_EXC_ERROR;

1389: x_return_status => x_return_status,
1390: x_msg_data => x_msg_data);
1391:
1392: if(x_return_status <> fnd_api.g_ret_sts_success) then
1393: raise FND_API.G_EXC_ERROR;
1394: end if;
1395:
1396: --we must do this check rather than supply types as a push component with a supply subinv provided only triggers a
1397: --sub transfer, not a wip issue

Line 1476: p_init_msg_lst => fnd_api.g_true,

1472: x_conc_req_id => x_conc_req_id,
1473: x_return_status => l_pickStatus,
1474: x_msg_data => x_msg_data,
1475: x_msg_count => l_msgCount,
1476: p_init_msg_lst => fnd_api.g_true,
1477: x_mo_line_errrec_tbl => x_MOLineErrTbl);
1478: fnd_file.put_line(which => fnd_file.log, buff => 'return status = ' ||l_pickStatus);
1479:
1480: if (l_logLevel <= wip_constants.trace_logging) then

Line 1484: if(l_pickStatus not in ('P','N', FND_API.G_RET_STS_SUCCESS)) then

1480: if (l_logLevel <= wip_constants.trace_logging) then
1481: wip_logger.log('returned status from call to inv_wip_picking_pvt.release_pick_batch() = ' || l_pickStatus || ';total=' || p_alloc_tbl.COUNT, l_dummy2);
1482: end if;
1483:
1484: if(l_pickStatus not in ('P','N', FND_API.G_RET_STS_SUCCESS)) then
1485: x_return_status := l_pickStatus;
1486: raise FND_API.G_EXC_ERROR;
1487: end if;
1488:

Line 1486: raise FND_API.G_EXC_ERROR;

1482: end if;
1483:
1484: if(l_pickStatus not in ('P','N', FND_API.G_RET_STS_SUCCESS)) then
1485: x_return_status := l_pickStatus;
1486: raise FND_API.G_EXC_ERROR;
1487: end if;
1488:
1489: --bugfix 4435437
1490: /* if thru srs, print the records that errored out and set the global variable so that we can

Line 1503: if x_MOLineErrTbl(i).txn_source_id = FND_API.G_MISS_NUM then

1499:
1500: for i in x_MOLineErrTbl.FIRST..x_MOLineErrTbl.LAST
1501: loop
1502: if( x_MOLineErrTbl.exists(i) ) then
1503: if x_MOLineErrTbl(i).txn_source_id = FND_API.G_MISS_NUM then
1504: x_MOLineErrTbl(i).txn_source_id := null;
1505: end if;
1506: if x_MOLineErrTbl(i).txn_source_line_id = FND_API.G_MISS_NUM then
1507: x_MOLineErrTbl(i).txn_source_line_id := null;

Line 1506: if x_MOLineErrTbl(i).txn_source_line_id = FND_API.G_MISS_NUM then

1502: if( x_MOLineErrTbl.exists(i) ) then
1503: if x_MOLineErrTbl(i).txn_source_id = FND_API.G_MISS_NUM then
1504: x_MOLineErrTbl(i).txn_source_id := null;
1505: end if;
1506: if x_MOLineErrTbl(i).txn_source_line_id = FND_API.G_MISS_NUM then
1507: x_MOLineErrTbl(i).txn_source_line_id := null;
1508: end if;
1509: if x_MOLineErrTbl(i).inventory_item_id = FND_API.G_MISS_NUM then
1510: x_MOLineErrTbl(i).inventory_item_id := null;

Line 1509: if x_MOLineErrTbl(i).inventory_item_id = FND_API.G_MISS_NUM then

1505: end if;
1506: if x_MOLineErrTbl(i).txn_source_line_id = FND_API.G_MISS_NUM then
1507: x_MOLineErrTbl(i).txn_source_line_id := null;
1508: end if;
1509: if x_MOLineErrTbl(i).inventory_item_id = FND_API.G_MISS_NUM then
1510: x_MOLineErrTbl(i).inventory_item_id := null;
1511: end if;
1512: if x_MOLineErrTbl(i).reference_id = FND_API.G_MISS_NUM then
1513: x_MOLineErrTbl(i).reference_id := null;

Line 1512: if x_MOLineErrTbl(i).reference_id = FND_API.G_MISS_NUM then

1508: end if;
1509: if x_MOLineErrTbl(i).inventory_item_id = FND_API.G_MISS_NUM then
1510: x_MOLineErrTbl(i).inventory_item_id := null;
1511: end if;
1512: if x_MOLineErrTbl(i).reference_id = FND_API.G_MISS_NUM then
1513: x_MOLineErrTbl(i).reference_id := null;
1514: end if;
1515: /* Bug 4917429 */
1516: if x_MOLineErrTbl(i).organization_id = FND_API.G_MISS_NUM then

Line 1516: if x_MOLineErrTbl(i).organization_id = FND_API.G_MISS_NUM then

1512: if x_MOLineErrTbl(i).reference_id = FND_API.G_MISS_NUM then
1513: x_MOLineErrTbl(i).reference_id := null;
1514: end if;
1515: /* Bug 4917429 */
1516: if x_MOLineErrTbl(i).organization_id = FND_API.G_MISS_NUM then
1517: x_MOLineErrTbl(i).organization_id := null;
1518: end if;
1519: /* Fix for bug 4917429: Print job name and item number to make
1520: the messages user-friendly */

Line 1565: if((l_pickStatus = 'P') OR l_explodeStatus <> fnd_api.g_ret_sts_success) then --if either the issue or backflush partially allocated, or one or more flow assemblies' bill could not be exploded

1561: l_string2 := fnd_message.get;
1562: else
1563: l_string2 := ' ';
1564: end if;
1565: if((l_pickStatus = 'P') OR l_explodeStatus <> fnd_api.g_ret_sts_success) then --if either the issue or backflush partially allocated, or one or more flow assemblies' bill could not be exploded
1566: x_return_status := 'P'; --return partial status
1567: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
1568: fnd_message.set_token('MO_NUMBER',l_hdrRec.request_number);
1569: l_string1 := fnd_message.get;

Line 1581: x_return_status := fnd_api.g_ret_sts_success; --above ifs test for other return statuses from inv call

1577: x_return_status := 'N';
1578: fnd_message.set_name('WIP','WIP_PICKING_NO_ALLOCATION');
1579: x_msg_data := fnd_message.get;
1580: else
1581: x_return_status := fnd_api.g_ret_sts_success; --above ifs test for other return statuses from inv call
1582: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
1583: fnd_message.set_token('MO_NUMBER',l_hdrRec.request_number);
1584: l_string1 := fnd_message.get;
1585: fnd_message.set_name('WIP','WIP_PICKING_SUCCESS_ALLOCATION');

Line 1597: when FND_API.G_EXC_ERROR then --msg_data, return_status set by inventory calls

1593: wip_logger.cleanup(l_dummy2);
1594: end if;
1595:
1596: exception
1597: when FND_API.G_EXC_ERROR then --msg_data, return_status set by inventory calls
1598: -- ROLLBACK TO WIP_ALLOCATE_PVT_START; -- Fix bug 4341138
1599: if (l_logLevel <= wip_constants.trace_logging) then
1600: wip_logger.log(x_msg_data, l_dummy2);
1601: wip_logger.cleanup(l_dummy2);

Line 1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1610: wip_logger.cleanup(l_dummy2);
1611: end if;
1612: when others then
1613: -- ROLLBACK TO WIP_ALLOCATE_PVT_START; -- Fix bug 4341138
1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1615: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
1616: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.allocate: ' || SQLERRM);
1617: x_msg_data := fnd_message.get;
1618: if (l_logLevel <= wip_constants.trace_logging) then

Line 1665: x_return_status := fnd_api.g_ret_sts_success;

1661: BEGIN
1662:
1663: SAVEPOINT GET_HDR_LINES_START;
1664: x_msg_data := NULL;
1665: x_return_status := fnd_api.g_ret_sts_success;
1666: p_hdrRec.created_by := l_userId;
1667: p_hdrRec.creation_date := l_sysDate;
1668: p_hdrRec.last_updated_by := l_userId;
1669: p_hdrRec.last_update_date := l_sysDate;

Line 1694: x_return_status := FND_API.G_RET_STS_ERROR;

1690:
1691: if(l_pick_grouping_rule_id IS NULL) then
1692: fnd_message.set_name('WIP','WIP_PICKING_EAM_PICKSLIP_ERROR');
1693: x_msg_data := fnd_message.get;
1694: x_return_status := FND_API.G_RET_STS_ERROR;
1695: raise FND_API.G_EXC_ERROR;
1696: else
1697: p_hdrRec.grouping_rule_id := l_pick_grouping_rule_id;
1698: end if;

Line 1695: raise FND_API.G_EXC_ERROR;

1691: if(l_pick_grouping_rule_id IS NULL) then
1692: fnd_message.set_name('WIP','WIP_PICKING_EAM_PICKSLIP_ERROR');
1693: x_msg_data := fnd_message.get;
1694: x_return_status := FND_API.G_RET_STS_ERROR;
1695: raise FND_API.G_EXC_ERROR;
1696: else
1697: p_hdrRec.grouping_rule_id := l_pick_grouping_rule_id;
1698: end if;
1699: else /* for other entity types, get the rule from the parameter passed to allocate() */

Line 1766: when FND_API.G_EXC_ERROR then /* return status and message_data are set at the place of raising this error */

1762: */
1763: p_linesRec.revision := null;
1764: exception
1765:
1766: when FND_API.G_EXC_ERROR then /* return status and message_data are set at the place of raising this error */
1767: ROLLBACK TO GET_HDR_LINES_START;
1768: when others then
1769: ROLLBACK TO GET_HDR_LINES_START;
1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1766: when FND_API.G_EXC_ERROR then /* return status and message_data are set at the place of raising this error */
1767: ROLLBACK TO GET_HDR_LINES_START;
1768: when others then
1769: ROLLBACK TO GET_HDR_LINES_START;
1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1771: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
1772: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.get_HdrLinesRec: ' || SQLERRM);
1773: x_msg_data := fnd_message.get;
1774:

Line 1796: l_backflushStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;

1792: x_return_status OUT NOCOPY VARCHAR2,
1793: x_msg_data OUT NOCOPY VARCHAR2) IS
1794: l_lineCount NUMBER := 0;
1795: l_pickStatus VARCHAR2(1) := 'N';
1796: l_backflushStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
1797: l_pickSetId NUMBER := 1;
1798: l_subinv VARCHAR2(10);
1799: l_locator NUMBER;
1800: l_uom VARCHAR2(4);

Line 2044: if(x_return_status <> fnd_api.g_ret_sts_success) then

2040: p_hdrRec => l_hdrRec,
2041: p_linesRec => l_linesRec,
2042: x_return_status => x_return_status,
2043: x_msg_data => x_msg_data);
2044: if(x_return_status <> fnd_api.g_ret_sts_success) then
2045: raise FND_API.G_EXC_ERROR;
2046: end if;
2047: if (p_alloc_comp_tbl(i).requested_quantity IS NOT NULL) then
2048: if(p_alloc_comp_tbl(i).requested_quantity > l_linesRec.quantity) then /* Do not allow overpick */

Line 2045: raise FND_API.G_EXC_ERROR;

2041: p_linesRec => l_linesRec,
2042: x_return_status => x_return_status,
2043: x_msg_data => x_msg_data);
2044: if(x_return_status <> fnd_api.g_ret_sts_success) then
2045: raise FND_API.G_EXC_ERROR;
2046: end if;
2047: if (p_alloc_comp_tbl(i).requested_quantity IS NOT NULL) then
2048: if(p_alloc_comp_tbl(i).requested_quantity > l_linesRec.quantity) then /* Do not allow overpick */
2049: fnd_message.set_name('WIP','WIP_PICKING_OVERPICK_ERROR');

Line 2051: x_return_status := FND_API.G_RET_STS_ERROR;

2047: if (p_alloc_comp_tbl(i).requested_quantity IS NOT NULL) then
2048: if(p_alloc_comp_tbl(i).requested_quantity > l_linesRec.quantity) then /* Do not allow overpick */
2049: fnd_message.set_name('WIP','WIP_PICKING_OVERPICK_ERROR');
2050: x_msg_data := fnd_message.get;
2051: x_return_status := FND_API.G_RET_STS_ERROR;
2052: raise FND_API.G_EXC_ERROR;
2053: else
2054: l_linesRec.quantity := p_alloc_comp_tbl(i).requested_quantity;
2055: end if;

Line 2052: raise FND_API.G_EXC_ERROR;

2048: if(p_alloc_comp_tbl(i).requested_quantity > l_linesRec.quantity) then /* Do not allow overpick */
2049: fnd_message.set_name('WIP','WIP_PICKING_OVERPICK_ERROR');
2050: x_msg_data := fnd_message.get;
2051: x_return_status := FND_API.G_RET_STS_ERROR;
2052: raise FND_API.G_EXC_ERROR;
2053: else
2054: l_linesRec.quantity := p_alloc_comp_tbl(i).requested_quantity;
2055: end if;
2056:

Line 2089: p_init_msg_lst => fnd_api.g_true,

2085: x_conc_req_id => x_conc_req_id,
2086: x_return_status => l_pickStatus,
2087: x_msg_data => x_msg_data,
2088: x_msg_count => l_msgCount,
2089: p_init_msg_lst => fnd_api.g_true,
2090: x_mo_line_errrec_tbl => x_MOLineErrTbl); --bugfix 4435437
2091:
2092: if(l_pickStatus not in ('P','N',FND_API.G_RET_STS_SUCCESS)) then
2093: x_return_status := l_pickStatus;

Line 2092: if(l_pickStatus not in ('P','N',FND_API.G_RET_STS_SUCCESS)) then

2088: x_msg_count => l_msgCount,
2089: p_init_msg_lst => fnd_api.g_true,
2090: x_mo_line_errrec_tbl => x_MOLineErrTbl); --bugfix 4435437
2091:
2092: if(l_pickStatus not in ('P','N',FND_API.G_RET_STS_SUCCESS)) then
2093: x_return_status := l_pickStatus;
2094: raise FND_API.G_EXC_ERROR;
2095: end if;
2096: end if;

Line 2094: raise FND_API.G_EXC_ERROR;

2090: x_mo_line_errrec_tbl => x_MOLineErrTbl); --bugfix 4435437
2091:
2092: if(l_pickStatus not in ('P','N',FND_API.G_RET_STS_SUCCESS)) then
2093: x_return_status := l_pickStatus;
2094: raise FND_API.G_EXC_ERROR;
2095: end if;
2096: end if;
2097:
2098: if(nvl(p_print_pick_slip,'T') = 'T') then

Line 2122: x_return_status := fnd_api.g_ret_sts_success; --above ifs test for other return statuses from inv call

2118: x_return_status := 'N';
2119: fnd_message.set_name('WIP','WIP_PICKING_NO_ALLOCATION');
2120: x_msg_data := fnd_message.get;
2121: else
2122: x_return_status := fnd_api.g_ret_sts_success; --above ifs test for other return statuses from inv call
2123: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
2124: fnd_message.set_token('MO_NUMBER',l_hdrRec.request_number);
2125: l_string1 := fnd_message.get;
2126: fnd_message.set_name('WIP','WIP_PICKING_SUCCESS_ALLOCATION');

Line 2133: when FND_API.G_EXC_ERROR then --msg_data, return_status set by inventory calls

2129: x_msg_data := fnd_message.get;
2130: end if;
2131: x_mo_req_number := l_hdrRec.request_number; /* Added as part of enhancement 2478446 */
2132: exception
2133: when FND_API.G_EXC_ERROR then --msg_data, return_status set by inventory calls
2134: ROLLBACK TO WIP_ALLOCATE_COMP_PVT_START;
2135: when RECORDS_LOCKED then
2136: ROLLBACK TO WIP_ALLOCATE_COMP_PVT_START;
2137: x_return_status := 'L';

Line 2142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2138: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
2139: x_msg_data := fnd_message.get;
2140: when others then
2141: ROLLBACK TO WIP_ALLOCATE_COMP_PVT_START;
2142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2143: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
2144: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.allocate: ' || SQLERRM);
2145: x_msg_data := fnd_message.get;
2146: end allocate_comp;

Line 2510: fnd_file.put_line(which => fnd_file.output, buff => fnd_msg_pub.get(p_msg_index => l_msgCount - i + 1, p_encoded => fnd_api.g_false));

2506: fnd_file.put_line(which => fnd_file.output, buff => '');
2507: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
2508: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2509: for i in 1..l_msgCount loop
2510: fnd_file.put_line(which => fnd_file.output, buff => fnd_msg_pub.get(p_msg_index => l_msgCount - i + 1, p_encoded => fnd_api.g_false));
2511: end loop;
2512: rollback to wip_allocate_concurrent;
2513: end allocate;
2514:

Line 2561: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

2557: /* fix for bug 4538135*/ p_txnFlag => true, /* ER 4369064 */
2558: x_compTbl => l_comp_sys_table,
2559: x_returnStatus => x_return_status);
2560:
2561: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2562: wip_utilities.get_message_stack(p_msg => x_msg_data,
2563: p_separator => ' ',
2564: p_delete_stack => fnd_api.g_true);
2565: return;

Line 2564: p_delete_stack => fnd_api.g_true);

2560:
2561: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2562: wip_utilities.get_message_stack(p_msg => x_msg_data,
2563: p_separator => ' ',
2564: p_delete_stack => fnd_api.g_true);
2565: return;
2566: end if;
2567:
2568: i := l_comp_sys_table.FIRST; -- get subscript of first element

Line 2620: x_return_status := FND_API.G_RET_STS_SUCCESS;

2616: and organization_id = v_organization_id
2617: and repetitive_schedule_id = v_repetitive_schedule_id
2618: and wip_supply_type in (wip_constants.op_pull, wip_constants.assy_pull);
2619: Begin
2620: x_return_status := FND_API.G_RET_STS_SUCCESS;
2621:
2622: l_logLevel := fnd_log.g_current_runtime_level;
2623: if (l_logLevel <= wip_constants.trace_logging) then
2624: wip_logger.log('In wip_picking_pvt.Post_Explosion_CleanUp():'

Line 2676: if (x_return_status <> fnd_api.g_ret_sts_success) then

2672: p_supply_locator_id => l_supply_locator_id,
2673: x_return_status => x_return_status,
2674: x_msg_data => x_msg_data);
2675:
2676: if (x_return_status <> fnd_api.g_ret_sts_success) then
2677: if (l_logLevel <= wip_constants.trace_logging) then
2678: wip_logger.log('wip_picking_pvt.Post_Explosion_CleanUp: ' ||
2679: 'wip_picking_pub.Update_Requirement_SubinvLoc failed..', l_dummy2);
2680: end if;

Line 2723: if (x_return_status <> fnd_api.g_ret_sts_success) then

2719: p_supply_locator_id => l_supply_locator_id,
2720: x_return_status => x_return_status,
2721: x_msg_data => x_msg_data);
2722:
2723: if (x_return_status <> fnd_api.g_ret_sts_success) then
2724: if (l_logLevel <= wip_constants.trace_logging) then
2725: wip_logger.log('wip_picking_pvt.Post_Explosion_CleanUp: ' ||
2726: 'wip_picking_pub.Update_Requirement_SubinvLoc failed..', l_dummy2);
2727: end if;

Line 2751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2747: wip_logger.log( x_msg_data, l_dummy2);
2748: wip_logger.cleanup(l_dummy2);
2749: end if;
2750: when others then
2751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2752: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
2753: fnd_message.set_token('ERROR_TEXT', 'WIP_EXPLODER_UTITLITIES.Post_Explosion_CleanUp:'
2754: || SQLERRM);
2755: x_msg_data := fnd_message.get;