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 160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

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

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

Line 204: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 239: when fnd_api.g_exc_unexpected_error then

235: where wip_entity_id = p_wip_entity_id
236: and repetitive_schedule_id = p_repetitive_schedule_id;
237: end if;
238: exception
239: when fnd_api.g_exc_unexpected_error then
240: ROLLBACK TO WIP_CANCEL_ALLOCS_START;
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: when others then
243: if(c_discLines%ISOPEN) then

Line 241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

237: end if;
238: exception
239: when fnd_api.g_exc_unexpected_error then
240: ROLLBACK TO WIP_CANCEL_ALLOCS_START;
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: when others then
243: if(c_discLines%ISOPEN) then
244: close c_discLines;
245: elsif(c_repLines%ISOPEN) then

Line 251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

247: elsif(c_flowLines%ISOPEN) then
248: close c_flowLines;
249: end if;
250: ROLLBACK TO WIP_CANCEL_ALLOCS_START;
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
253: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pub.cancel_allocations: ' || SQLERRM);
254: x_msg_data := fnd_message.get;
255: end cancel_allocations;

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

309:
310:
311: BEGIN
312: SAVEPOINT WIP_CANCEL_COMP_ALLOCS_START;
313: x_return_status := FND_API.G_RET_STS_SUCCESS; -- in case no open lines are found
314:
315: if (l_logLevel <= wip_constants.trace_logging) then
316: wip_logger.log('In wip_picking_pvt.cancel_comp_allocations', l_dummy);
317: end if;

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

353: close c_discLines;
354: elsif(c_repLines%ISOPEN) then
355: close c_repLines;
356: end if;
357: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
358: if(c_discLines%ISOPEN) then
359: close c_discLines;
360: elsif(c_repLines%ISOPEN) then
361: close c_repLines;

Line 363: raise FND_API.G_EXC_UNEXPECTED_ERROR;

359: close c_discLines;
360: elsif(c_repLines%ISOPEN) then
361: close c_repLines;
362: end if;
363: raise FND_API.G_EXC_UNEXPECTED_ERROR;
364: end if;
365:
366: --finally update backordered quantity to 0
367: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then

Line 382: when fnd_api.g_exc_unexpected_error then

378: and operation_seq_num = p_operation_seq_num
379: and inventory_item_id = p_inventory_item_id;
380: end if;
381: exception
382: when fnd_api.g_exc_unexpected_error then
383: ROLLBACK TO WIP_CANCEL_COMP_ALLOCS_START;
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
385: when others then
386: if(c_discLines%ISOPEN) then

Line 384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

380: end if;
381: exception
382: when fnd_api.g_exc_unexpected_error then
383: ROLLBACK TO WIP_CANCEL_COMP_ALLOCS_START;
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
385: when others then
386: if(c_discLines%ISOPEN) then
387: close c_discLines;
388: elsif(c_repLines%ISOPEN) then

Line 392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

388: elsif(c_repLines%ISOPEN) then
389: close c_repLines;
390: end if;
391: ROLLBACK TO WIP_CANCEL_COMP_ALLOCS_START;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
394: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pub.cancel_comp_allocations: ' || SQLERRM);
395: x_msg_data := fnd_message.get;
396: END cancel_comp_allocations;

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

475:
476:
477: BEGIN
478: SAVEPOINT WIP_REDUCE_COMP_ALLOCS_START;
479: x_return_status := FND_API.G_RET_STS_SUCCESS; -- in case no open lines are found
480: for i in 1..p_comp_tbl.COUNT LOOP /* Component Loop*/
481: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
482: open c_discLines(p_comp_tbl(i).wip_entity_id, p_comp_tbl(i).operation_seq_num, p_comp_tbl(i).inventory_item_id);
483: elsif(p_wip_entity_type = wip_constants.repetitive) then

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

513:
514: if (l_reductionQty = 0) then
515: exit ;
516: end if;
517: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
518: if(c_discLines%ISOPEN) then
519: close c_discLines;
520: elsif(c_repLines%ISOPEN) then
521: close c_repLines;

Line 523: raise FND_API.G_EXC_UNEXPECTED_ERROR;

519: close c_discLines;
520: elsif(c_repLines%ISOPEN) then
521: close c_repLines;
522: end if;
523: raise FND_API.G_EXC_UNEXPECTED_ERROR;
524: end if;
525:
526: end Loop; /* End of MO lines loop */
527:

Line 559: when fnd_api.g_exc_unexpected_error then

555: and inventory_item_id = p_comp_tbl(i).inventory_item_id;
556: end if;
557: end LOOP; /*End of component loop*/
558: exception
559: when fnd_api.g_exc_unexpected_error then
560: ROLLBACK TO WIP_REDUCE_COMP_ALLOCS_START;
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562: when others then
563: if(c_discLines%ISOPEN) then

Line 561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

557: end LOOP; /*End of component loop*/
558: exception
559: when fnd_api.g_exc_unexpected_error then
560: ROLLBACK TO WIP_REDUCE_COMP_ALLOCS_START;
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562: when others then
563: if(c_discLines%ISOPEN) then
564: close c_discLines;
565: elsif(c_repLines%ISOPEN) then

Line 569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

565: elsif(c_repLines%ISOPEN) then
566: close c_repLines;
567: end if;
568: ROLLBACK TO WIP_REDUCE_COMP_ALLOCS_START;
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
571: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pub.cancel_allocations: ' || SQLERRM);
572: x_msg_data := fnd_message.get;
573: END reduce_comp_allocations;

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

626: l_lineID NUMBER;
627: l_msgCount NUMBER;
628: BEGIN
629: SAVEPOINT WIP_UPDATE_ALLOCS_START;
630: x_return_status := FND_API.G_RET_STS_SUCCESS; -- in case no open lines are found
631: if(p_repetitive_schedule_id is null) then
632: open c_discLines;
633: else
634: open c_repLines;

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

646: p_op_seq_num => p_operation_seq_num,
647: x_msg_count => l_msgCount,
648: x_msg_data => x_msg_data,
649: x_return_status => x_return_status);
650: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
651: if(c_discLines%ISOPEN) then
652: close c_discLines;
653: elsif(c_repLines%ISOPEN) then
654: close c_repLines;

Line 656: raise FND_API.G_EXC_UNEXPECTED_ERROR;

652: close c_discLines;
653: elsif(c_repLines%ISOPEN) then
654: close c_repLines;
655: end if;
656: raise FND_API.G_EXC_UNEXPECTED_ERROR;
657: end if;
658: end loop;
659: if(c_discLines%ISOPEN) then
660: close c_discLines;

Line 666: when fnd_api.g_exc_unexpected_error then

662: close c_repLines;
663: end if;
664:
665: exception
666: when fnd_api.g_exc_unexpected_error then
667: ROLLBACK TO WIP_UPDATE_ALLOCS_START;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669: when others then
670: if(c_discLines%ISOPEN) then

Line 668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

664:
665: exception
666: when fnd_api.g_exc_unexpected_error then
667: ROLLBACK TO WIP_UPDATE_ALLOCS_START;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669: when others then
670: if(c_discLines%ISOPEN) then
671: close c_discLines;
672: elsif(c_repLines%ISOPEN) then

Line 676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

672: elsif(c_repLines%ISOPEN) then
673: close c_repLines;
674: end if;
675: ROLLBACK TO WIP_UPDATE_ALLOCS_START;
676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
677: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
678: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pub.update_allocation_op_seqs: ' || SQLERRM);
679: end update_allocation_op_seqs;
680:

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

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

Line 796: x_optimize_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

810: p_alt_rout_desig => p_alt_rout_desig,
811: x_comp_sql_tbl => l_comp_sql_tbl,
812: x_return_status => l_dummy,
813: x_msg_data => x_msg_data);
814: if(l_dummy <> FND_API.G_RET_STS_SUCCESS) then
815: x_explode_status := l_dummy;
816: x_optimize_status := FND_API.G_RET_STS_UNEXP_ERROR;
817: return;
818: end if;

Line 816: x_optimize_status := FND_API.G_RET_STS_UNEXP_ERROR;

812: x_return_status => l_dummy,
813: x_msg_data => x_msg_data);
814: if(l_dummy <> FND_API.G_RET_STS_SUCCESS) then
815: x_explode_status := l_dummy;
816: x_optimize_status := FND_API.G_RET_STS_UNEXP_ERROR;
817: return;
818: end if;
819:
820: x_explode_status := FND_API.G_RET_STS_SUCCESS;

Line 820: x_explode_status := FND_API.G_RET_STS_SUCCESS;

816: x_optimize_status := FND_API.G_RET_STS_UNEXP_ERROR;
817: return;
818: end if;
819:
820: x_explode_status := FND_API.G_RET_STS_SUCCESS;
821: if l_comp_sql_tbl.count <> x_comp_sql_tbl.count then
822: x_optimize_status := 'F';
823: end if;
824:

Line 851: x_optimize_status := FND_API.G_RET_STS_SUCCESS;

847: return;
848: end if;
849: end loop;
850:
851: x_optimize_status := FND_API.G_RET_STS_SUCCESS;
852:
853: end;
854:
855:

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

870: x_conc_req_id OUT NOCOPY NUMBER,
871: x_mo_req_number OUT NOCOPY VARCHAR2,
872: x_return_status OUT NOCOPY VARCHAR2,
873: x_msg_data OUT NOCOPY VARCHAR2) IS
874: l_explodeStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
875: l_explodeMessage VARCHAR2(2000);
876: l_lineCount NUMBER := 0;
877: l_lineCountHolder NUMBER;
878: l_pickStatus VARCHAR2(1) := 'N';

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

875: l_explodeMessage VARCHAR2(2000);
876: l_lineCount NUMBER := 0;
877: l_lineCountHolder NUMBER;
878: l_pickStatus VARCHAR2(1) := 'N';
879: l_backflushStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
880: l_optimizeStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
881: l_pickSetId NUMBER := 1;
882: l_itemID NUMBER;
883: l_operationSeqNum NUMBER;

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

876: l_lineCount NUMBER := 0;
877: l_lineCountHolder NUMBER;
878: l_pickStatus VARCHAR2(1) := 'N';
879: l_backflushStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
880: l_optimizeStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
881: l_pickSetId NUMBER := 1;
882: l_itemID NUMBER;
883: l_operationSeqNum NUMBER;
884: l_subinv VARCHAR2(10);

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

1250: p_alt_rout_desig => p_alloc_tbl(i).alt_rtg_dsg,
1251: x_comp_sql_tbl => l_flowCompTbl,
1252: x_return_status => l_dummy,
1253: x_msg_data => l_explodeMessage);
1254: if(l_dummy <> FND_API.G_RET_STS_SUCCESS) then
1255: l_explodeStatus := l_dummy;
1256: p_alloc_tbl(i).bill_seq_id := null; --reset the bill seq and org as the assy's bill could not be exploded
1257: P_alloc_tbl(i).bill_org_id := null;
1258: end if;

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

1271: x_comp_sql_tbl => l_flowCompTbl,
1272: x_explode_status => l_explodeStatus,
1273: x_optimize_status => l_optimizeStatus,
1274: x_msg_data => l_explodeMessage);
1275: if(l_explodeStatus <> FND_API.G_RET_STS_SUCCESS) then
1276: -- assy's bill could not be exploded, then reset the bill seq and org
1277: l_opt_cnt := 0;
1278: p_alloc_tbl(i).bill_seq_id := null;
1279: P_alloc_tbl(i).bill_org_id := null;

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

1276: -- assy's bill could not be exploded, then reset the bill seq and org
1277: l_opt_cnt := 0;
1278: p_alloc_tbl(i).bill_seq_id := null;
1279: P_alloc_tbl(i).bill_org_id := null;
1280: elsif (l_optimizeStatus <> FND_API.G_RET_STS_SUCCESS) then
1281: -- can not optimize, b/c bom is not the same for the group,
1282: -- reset counter, and proceed as normal(one record at a time)
1283: l_opt_cnt := 0;
1284:

Line 1323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1319:
1320: end if;
1321:
1322: else -- if(p_wip_entity_type = l_disc)
1323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1324: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
1325: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.allocate: invalid entity_type' );
1326: x_msg_data := fnd_message.get;
1327: return;

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

1413: p_linesRec => l_linesRec,
1414: x_return_status => x_return_status,
1415: x_msg_data => x_msg_data);
1416:
1417: if(x_return_status <> fnd_api.g_ret_sts_success) then
1418: raise FND_API.G_EXC_ERROR;
1419: end if;
1420:
1421: --we must do this check rather than supply types as a push component with a supply subinv provided only triggers a

Line 1418: raise FND_API.G_EXC_ERROR;

1414: x_return_status => x_return_status,
1415: x_msg_data => x_msg_data);
1416:
1417: if(x_return_status <> fnd_api.g_ret_sts_success) then
1418: raise FND_API.G_EXC_ERROR;
1419: end if;
1420:
1421: --we must do this check rather than supply types as a push component with a supply subinv provided only triggers a
1422: --sub transfer, not a wip issue

Line 1501: p_init_msg_lst => fnd_api.g_true,

1497: x_conc_req_id => x_conc_req_id,
1498: x_return_status => l_pickStatus,
1499: x_msg_data => x_msg_data,
1500: x_msg_count => l_msgCount,
1501: p_init_msg_lst => fnd_api.g_true,
1502: x_mo_line_errrec_tbl => x_MOLineErrTbl);
1503: fnd_file.put_line(which => fnd_file.log, buff => 'return status = ' ||l_pickStatus);
1504:
1505: if (l_logLevel <= wip_constants.trace_logging) then

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

1519:
1520: for i in x_MOLineErrTbl.FIRST..x_MOLineErrTbl.LAST
1521: loop
1522: if( x_MOLineErrTbl.exists(i) ) then
1523: if x_MOLineErrTbl(i).txn_source_id = FND_API.G_MISS_NUM then
1524: x_MOLineErrTbl(i).txn_source_id := null;
1525: end if;
1526: if x_MOLineErrTbl(i).txn_source_line_id = FND_API.G_MISS_NUM then
1527: x_MOLineErrTbl(i).txn_source_line_id := null;

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

1522: if( x_MOLineErrTbl.exists(i) ) then
1523: if x_MOLineErrTbl(i).txn_source_id = FND_API.G_MISS_NUM then
1524: x_MOLineErrTbl(i).txn_source_id := null;
1525: end if;
1526: if x_MOLineErrTbl(i).txn_source_line_id = FND_API.G_MISS_NUM then
1527: x_MOLineErrTbl(i).txn_source_line_id := null;
1528: end if;
1529: if x_MOLineErrTbl(i).inventory_item_id = FND_API.G_MISS_NUM then
1530: x_MOLineErrTbl(i).inventory_item_id := null;

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

1525: end if;
1526: if x_MOLineErrTbl(i).txn_source_line_id = FND_API.G_MISS_NUM then
1527: x_MOLineErrTbl(i).txn_source_line_id := null;
1528: end if;
1529: if x_MOLineErrTbl(i).inventory_item_id = FND_API.G_MISS_NUM then
1530: x_MOLineErrTbl(i).inventory_item_id := null;
1531: end if;
1532: if x_MOLineErrTbl(i).reference_id = FND_API.G_MISS_NUM then
1533: x_MOLineErrTbl(i).reference_id := null;

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

1528: end if;
1529: if x_MOLineErrTbl(i).inventory_item_id = FND_API.G_MISS_NUM then
1530: x_MOLineErrTbl(i).inventory_item_id := null;
1531: end if;
1532: if x_MOLineErrTbl(i).reference_id = FND_API.G_MISS_NUM then
1533: x_MOLineErrTbl(i).reference_id := null;
1534: end if;
1535: /* Bug 4917429 */
1536: if x_MOLineErrTbl(i).organization_id = FND_API.G_MISS_NUM then

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

1532: if x_MOLineErrTbl(i).reference_id = FND_API.G_MISS_NUM then
1533: x_MOLineErrTbl(i).reference_id := null;
1534: end if;
1535: /* Bug 4917429 */
1536: if x_MOLineErrTbl(i).organization_id = FND_API.G_MISS_NUM then
1537: x_MOLineErrTbl(i).organization_id := null;
1538: end if;
1539: /* Fix for bug 4917429: Print job name and item number to make
1540: the messages user-friendly */

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

1566: end loop;
1567: end if;
1568: end if; /* end of conc_req_id <> -1 condition */
1569: /*Fix for bug 8940535(FP 8557198), raise exception after error message are printed out in log*/
1570: if(l_pickStatus not in ('P','N', FND_API.G_RET_STS_SUCCESS)) then
1571: x_return_status := l_pickStatus;
1572: raise FND_API.G_EXC_ERROR;
1573: end if;
1574: end if; /* end of l_lineCount > 0 */

Line 1572: raise FND_API.G_EXC_ERROR;

1568: end if; /* end of conc_req_id <> -1 condition */
1569: /*Fix for bug 8940535(FP 8557198), raise exception after error message are printed out in log*/
1570: if(l_pickStatus not in ('P','N', FND_API.G_RET_STS_SUCCESS)) then
1571: x_return_status := l_pickStatus;
1572: raise FND_API.G_EXC_ERROR;
1573: end if;
1574: end if; /* end of l_lineCount > 0 */
1575:
1576: if (l_logLevel <= wip_constants.trace_logging) then

Line 1590: 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

1586: l_string2 := fnd_message.get;
1587: else
1588: l_string2 := ' ';
1589: end if;
1590: 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
1591: x_return_status := 'P'; --return partial status
1592: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
1593: fnd_message.set_token('MO_NUMBER',l_hdrRec.request_number);
1594: l_string1 := fnd_message.get;

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

1602: x_return_status := 'N';
1603: fnd_message.set_name('WIP','WIP_PICKING_NO_ALLOCATION');
1604: x_msg_data := fnd_message.get;
1605: else
1606: x_return_status := fnd_api.g_ret_sts_success; --above ifs test for other return statuses from inv call
1607: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
1608: fnd_message.set_token('MO_NUMBER',l_hdrRec.request_number);
1609: l_string1 := fnd_message.get;
1610: fnd_message.set_name('WIP','WIP_PICKING_SUCCESS_ALLOCATION');

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

1618: wip_logger.cleanup(l_dummy2);
1619: end if;
1620:
1621: exception
1622: when FND_API.G_EXC_ERROR then --msg_data, return_status set by inventory calls
1623: -- ROLLBACK TO WIP_ALLOCATE_PVT_START; -- Fix bug 4341138
1624: if (l_logLevel <= wip_constants.trace_logging) then
1625: wip_logger.log(x_msg_data, l_dummy2);
1626: wip_logger.cleanup(l_dummy2);

Line 1639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1635: wip_logger.cleanup(l_dummy2);
1636: end if;
1637: when others then
1638: -- ROLLBACK TO WIP_ALLOCATE_PVT_START; -- Fix bug 4341138
1639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1640: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
1641: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.allocate: ' || SQLERRM);
1642: x_msg_data := fnd_message.get;
1643: if (l_logLevel <= wip_constants.trace_logging) then

Line 1690: x_return_status := fnd_api.g_ret_sts_success;

1686: BEGIN
1687:
1688: SAVEPOINT GET_HDR_LINES_START;
1689: x_msg_data := NULL;
1690: x_return_status := fnd_api.g_ret_sts_success;
1691: p_hdrRec.created_by := l_userId;
1692: p_hdrRec.creation_date := l_sysDate;
1693: p_hdrRec.last_updated_by := l_userId;
1694: p_hdrRec.last_update_date := l_sysDate;

Line 1719: x_return_status := FND_API.G_RET_STS_ERROR;

1715:
1716: if(l_pick_grouping_rule_id IS NULL) then
1717: fnd_message.set_name('WIP','WIP_PICKING_EAM_PICKSLIP_ERROR');
1718: x_msg_data := fnd_message.get;
1719: x_return_status := FND_API.G_RET_STS_ERROR;
1720: raise FND_API.G_EXC_ERROR;
1721: else
1722: p_hdrRec.grouping_rule_id := l_pick_grouping_rule_id;
1723: end if;

Line 1720: raise FND_API.G_EXC_ERROR;

1716: if(l_pick_grouping_rule_id IS NULL) then
1717: fnd_message.set_name('WIP','WIP_PICKING_EAM_PICKSLIP_ERROR');
1718: x_msg_data := fnd_message.get;
1719: x_return_status := FND_API.G_RET_STS_ERROR;
1720: raise FND_API.G_EXC_ERROR;
1721: else
1722: p_hdrRec.grouping_rule_id := l_pick_grouping_rule_id;
1723: end if;
1724: else /* for other entity types, get the rule from the parameter passed to allocate() */

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

1800: end if;
1801:
1802: exception
1803:
1804: when FND_API.G_EXC_ERROR then /* return status and message_data are set at the place of raising this error */
1805: ROLLBACK TO GET_HDR_LINES_START;
1806: when others then
1807: ROLLBACK TO GET_HDR_LINES_START;
1808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1804: when FND_API.G_EXC_ERROR then /* return status and message_data are set at the place of raising this error */
1805: ROLLBACK TO GET_HDR_LINES_START;
1806: when others then
1807: ROLLBACK TO GET_HDR_LINES_START;
1808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1809: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
1810: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.get_HdrLinesRec: ' || SQLERRM);
1811: x_msg_data := fnd_message.get;
1812:

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

1830: x_return_status OUT NOCOPY VARCHAR2,
1831: x_msg_data OUT NOCOPY VARCHAR2) IS
1832: l_lineCount NUMBER := 0;
1833: l_pickStatus VARCHAR2(1) := 'N';
1834: l_backflushStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
1835: l_pickSetId NUMBER := 1;
1836: l_subinv VARCHAR2(10);
1837: l_locator NUMBER;
1838: l_uom VARCHAR2(4);

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

2078: p_hdrRec => l_hdrRec,
2079: p_linesRec => l_linesRec,
2080: x_return_status => x_return_status,
2081: x_msg_data => x_msg_data);
2082: if(x_return_status <> fnd_api.g_ret_sts_success) then
2083: raise FND_API.G_EXC_ERROR;
2084: end if;
2085: if (p_alloc_comp_tbl(i).requested_quantity IS NOT NULL) then
2086: if(p_alloc_comp_tbl(i).requested_quantity > l_linesRec.quantity) then /* Do not allow overpick */

Line 2083: raise FND_API.G_EXC_ERROR;

2079: p_linesRec => l_linesRec,
2080: x_return_status => x_return_status,
2081: x_msg_data => x_msg_data);
2082: if(x_return_status <> fnd_api.g_ret_sts_success) then
2083: raise FND_API.G_EXC_ERROR;
2084: end if;
2085: if (p_alloc_comp_tbl(i).requested_quantity IS NOT NULL) then
2086: if(p_alloc_comp_tbl(i).requested_quantity > l_linesRec.quantity) then /* Do not allow overpick */
2087: fnd_message.set_name('WIP','WIP_PICKING_OVERPICK_ERROR');

Line 2089: x_return_status := FND_API.G_RET_STS_ERROR;

2085: if (p_alloc_comp_tbl(i).requested_quantity IS NOT NULL) then
2086: if(p_alloc_comp_tbl(i).requested_quantity > l_linesRec.quantity) then /* Do not allow overpick */
2087: fnd_message.set_name('WIP','WIP_PICKING_OVERPICK_ERROR');
2088: x_msg_data := fnd_message.get;
2089: x_return_status := FND_API.G_RET_STS_ERROR;
2090: raise FND_API.G_EXC_ERROR;
2091: else
2092: l_linesRec.quantity := p_alloc_comp_tbl(i).requested_quantity;
2093: end if;

Line 2090: raise FND_API.G_EXC_ERROR;

2086: if(p_alloc_comp_tbl(i).requested_quantity > l_linesRec.quantity) then /* Do not allow overpick */
2087: fnd_message.set_name('WIP','WIP_PICKING_OVERPICK_ERROR');
2088: x_msg_data := fnd_message.get;
2089: x_return_status := FND_API.G_RET_STS_ERROR;
2090: raise FND_API.G_EXC_ERROR;
2091: else
2092: l_linesRec.quantity := p_alloc_comp_tbl(i).requested_quantity;
2093: end if;
2094:

Line 2127: p_init_msg_lst => fnd_api.g_true,

2123: x_conc_req_id => x_conc_req_id,
2124: x_return_status => l_pickStatus,
2125: x_msg_data => x_msg_data,
2126: x_msg_count => l_msgCount,
2127: p_init_msg_lst => fnd_api.g_true,
2128: x_mo_line_errrec_tbl => x_MOLineErrTbl); --bugfix 4435437
2129:
2130: if(l_pickStatus not in ('P','N',FND_API.G_RET_STS_SUCCESS)) then
2131: x_return_status := l_pickStatus;

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

2126: x_msg_count => l_msgCount,
2127: p_init_msg_lst => fnd_api.g_true,
2128: x_mo_line_errrec_tbl => x_MOLineErrTbl); --bugfix 4435437
2129:
2130: if(l_pickStatus not in ('P','N',FND_API.G_RET_STS_SUCCESS)) then
2131: x_return_status := l_pickStatus;
2132: raise FND_API.G_EXC_ERROR;
2133: end if;
2134: end if;

Line 2132: raise FND_API.G_EXC_ERROR;

2128: x_mo_line_errrec_tbl => x_MOLineErrTbl); --bugfix 4435437
2129:
2130: if(l_pickStatus not in ('P','N',FND_API.G_RET_STS_SUCCESS)) then
2131: x_return_status := l_pickStatus;
2132: raise FND_API.G_EXC_ERROR;
2133: end if;
2134: end if;
2135:
2136: if(nvl(p_print_pick_slip,'T') = 'T') then

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

2156: x_return_status := 'N';
2157: fnd_message.set_name('WIP','WIP_PICKING_NO_ALLOCATION');
2158: x_msg_data := fnd_message.get;
2159: else
2160: x_return_status := fnd_api.g_ret_sts_success; --above ifs test for other return statuses from inv call
2161: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
2162: fnd_message.set_token('MO_NUMBER',l_hdrRec.request_number);
2163: l_string1 := fnd_message.get;
2164: fnd_message.set_name('WIP','WIP_PICKING_SUCCESS_ALLOCATION');

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

2167: x_msg_data := fnd_message.get;
2168: end if;
2169: x_mo_req_number := l_hdrRec.request_number; /* Added as part of enhancement 2478446 */
2170: exception
2171: when FND_API.G_EXC_ERROR then --msg_data, return_status set by inventory calls
2172: ROLLBACK TO WIP_ALLOCATE_COMP_PVT_START;
2173: when RECORDS_LOCKED then
2174: ROLLBACK TO WIP_ALLOCATE_COMP_PVT_START;
2175: x_return_status := 'L';

Line 2180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2176: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
2177: x_msg_data := fnd_message.get;
2178: when others then
2179: ROLLBACK TO WIP_ALLOCATE_COMP_PVT_START;
2180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2181: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
2182: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.allocate: ' || SQLERRM);
2183: x_msg_data := fnd_message.get;
2184: end allocate_comp;

Line 2615: 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));

2611: fnd_file.put_line(which => fnd_file.output, buff => '');
2612: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
2613: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2614: for i in 1..l_msgCount loop
2615: 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));
2616: end loop;
2617: rollback to wip_allocate_concurrent;
2618: end allocate;
2619:

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

2662: /* fix for bug 4538135*/ p_txnFlag => true, /* ER 4369064 */
2663: x_compTbl => l_comp_sys_table,
2664: x_returnStatus => x_return_status);
2665:
2666: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2667: wip_utilities.get_message_stack(p_msg => x_msg_data,
2668: p_separator => ' ',
2669: p_delete_stack => fnd_api.g_true);
2670: return;

Line 2669: p_delete_stack => fnd_api.g_true);

2665:
2666: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2667: wip_utilities.get_message_stack(p_msg => x_msg_data,
2668: p_separator => ' ',
2669: p_delete_stack => fnd_api.g_true);
2670: return;
2671: end if;
2672:
2673: i := l_comp_sys_table.FIRST; -- get subscript of first element

Line 2725: x_return_status := FND_API.G_RET_STS_SUCCESS;

2721: and organization_id = v_organization_id
2722: and repetitive_schedule_id = v_repetitive_schedule_id
2723: and wip_supply_type in (wip_constants.op_pull, wip_constants.assy_pull);
2724: Begin
2725: x_return_status := FND_API.G_RET_STS_SUCCESS;
2726:
2727: l_logLevel := fnd_log.g_current_runtime_level;
2728: if (l_logLevel <= wip_constants.trace_logging) then
2729: wip_logger.log('In wip_picking_pvt.Post_Explosion_CleanUp():'

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

2777: p_supply_locator_id => l_supply_locator_id,
2778: x_return_status => x_return_status,
2779: x_msg_data => x_msg_data);
2780:
2781: if (x_return_status <> fnd_api.g_ret_sts_success) then
2782: if (l_logLevel <= wip_constants.trace_logging) then
2783: wip_logger.log('wip_picking_pvt.Post_Explosion_CleanUp: ' ||
2784: 'wip_picking_pub.Update_Requirement_SubinvLoc failed..', l_dummy2);
2785: end if;

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

2824: p_supply_locator_id => l_supply_locator_id,
2825: x_return_status => x_return_status,
2826: x_msg_data => x_msg_data);
2827:
2828: if (x_return_status <> fnd_api.g_ret_sts_success) then
2829: if (l_logLevel <= wip_constants.trace_logging) then
2830: wip_logger.log('wip_picking_pvt.Post_Explosion_CleanUp: ' ||
2831: 'wip_picking_pub.Update_Requirement_SubinvLoc failed..', l_dummy2);
2832: end if;

Line 2856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2852: wip_logger.log( x_msg_data, l_dummy2);
2853: wip_logger.cleanup(l_dummy2);
2854: end if;
2855: when others then
2856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2857: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
2858: fnd_message.set_token('ERROR_TEXT', 'WIP_EXPLODER_UTITLITIES.Post_Explosion_CleanUp:'
2859: || SQLERRM);
2860: x_msg_data := fnd_message.get;