eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MMX_WRAPPER_PVT dependencies on FND_API

Line 283: x_return_status := FND_API.G_RET_STS_SUCCESS;

279: );
280:
281: BEGIN
282: SAVEPOINT sp_exec_min_max;
283: x_return_status := FND_API.G_RET_STS_SUCCESS;
284:
285: IF G_TRACE_ON = 1 THEN
286: print_debug('Starting Min-max planning with the following parameters: ' || fnd_global.local_chr(10)||
287: ' p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10)||

Line 371: RAISE fnd_api.g_exc_error;

367: print_debug('Exception: No category set exists for the passed Category set ID:'|| P_CAT_SET_ID
368: ,l_proc
369: , 9);
370: END IF;
371: RAISE fnd_api.g_exc_error;
372: END;
373: ELSE
374: l_mcat_struct := P_MCAT_STRUCT;
375: END IF;

Line 391: RAISE fnd_api.g_exc_error;

387: print_debug('Exception: No default category set exists'
388: ,l_proc
389: , 9);
390: END IF;
391: RAISE fnd_api.g_exc_error;
392: END;
393:
394: END IF;
395: IF G_TRACE_ON = 1 THEN

Line 417: RAISE fnd_api.g_exc_error;

413: print_debug('Exception: No Employee Exists for the passed in User Id: '|| P_USER_ID
414: ,l_proc
415: , 9);
416: END IF;
417: RAISE fnd_api.g_exc_error;
418: END;
419: ELSE
420: l_employee_id := P_EMPLOYEE_ID;
421: END IF;

Line 461: RAISE fnd_api.g_exc_error;

457: print_debug('Exception: No Default Delivery To Location Exists'
458: , l_proc
459: , 9);
460: END IF;
461: RAISE fnd_api.g_exc_error;
462: END;
463: ELSE
464: l_dd_loc_id := P_DD_LOC_ID;
465: END IF;

Line 528: RAISE fnd_api.g_exc_error;

524: print_debug('Exception: Organization Id '|| P_ORGANIZATION_ID ||' Passed in is invalid'
525: , l_proc
526: , 9);
527: END IF;
528: RAISE fnd_api.g_exc_error;
529: END;
530: IF G_TRACE_ON = 1 THEN
531: print_debug('Operating Unit is: ' || l_operating_unit
532: ,l_proc

Line 603: RAISE fnd_api.g_exc_error;

599: print_debug('Exception: No Encumbrance setup has been done for Organization Id '|| P_ORGANIZATION_ID ||' Passed'
600: , l_proc
601: , 9);
602: END IF;
603: RAISE fnd_api.g_exc_error;
604: END;
605: IF G_TRACE_ON = 1 THEN
606: print_debug('Encumbrance Flag is: ' || l_encum_flag
607: ,l_proc

Line 626: RAISE fnd_api.g_exc_error;

622: print_debug('Exception: Organization Id '||P_ORGANIZATION_ID||' Passed in does not exist'
623: ,l_proc
624: , 9);
625: END IF;
626: RAISE fnd_api.g_exc_error;
627: END;
628: IF G_TRACE_ON = 1 THEN
629: print_debug('Calendar Code and Exception Set Id are: ' || l_cal_code ||','|| l_exception_set_id
630: ,l_proc

Line 663: RAISE fnd_api.g_exc_error;

659: print_debug('Exception: The Lookup MTL_MINMAX_RPT_SORT_BY is not defined'
660: , l_proc
661: , 9);
662: END IF;
663: RAISE fnd_api.g_exc_error;
664: END;
665:
666: --
667: -- Validate P_SELECTION.

Line 682: RAISE fnd_api.g_exc_error;

678: print_debug('Exception: The Lookup MTL_MINMAX_RPT_SEL is not defined'
679: , l_proc
680: , 9);
681: END IF;
682: RAISE fnd_api.g_exc_error;
683: END;
684:
685: --
686: -- Set P_S_CUTOFF and P_D_CUTOFF to sysdate if they are null.

Line 711: RAISE fnd_api.g_exc_error;

707: print_debug('Exception: WIP_JOB_SCHEDULE_INTERFACE_S.NEXTVAL is not defined'
708: , l_proc
709: , 9);
710: END IF;
711: RAISE fnd_api.g_exc_error;
712: END;
713: IF G_TRACE_ON = 1 THEN
714: print_debug('WIP Batch Id is: ' || l_wip_batch_id
715: , l_proc

Line 737: RAISE fnd_api.g_exc_error;

733: print_debug('Exception: WSM_LOT_JOB_INTERFACE_S.NEXTVAL is not defined'
734: , l_proc
735: , 9);
736: END IF;
737: RAISE fnd_api.g_exc_error;
738: END;
739: IF G_TRACE_ON = 1 THEN
740: print_debug('OSFM Batch Id is: ' || l_osfm_batch_id
741: , l_proc

Line 794: RAISE fnd_api.g_exc_error;

790: , 9);
791: END IF;
792: fnd_message.set_name('INV','INV_MINMAX_NO_ITEM_SETUP');
793: fnd_msg_pub.add;
794: RAISE fnd_api.g_exc_error;
795: END IF;
796: ELSE
797: l_subinv_tbl := p_subinv_tbl;
798:

Line 856: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

852: , x_msg_data => l_msg_data
853: , p_osfm_batch_id => l_osfm_batch_id /* Added for Bug 6807835 */
854: );
855:
856: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
857: l_warn := 'W'; --Bug 4681032
858: IF G_TRACE_ON = 1 THEN
859: print_debug('INV_Minmax_PVT.run_min_max_plan failed with unexpected error '||
860: 'for subinventory '|| l_subinv_tbl(l_subinv_count) ||

Line 865: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

861: 'returning message: ' || l_msg_data
862: ,l_proc
863: , 9);
864: END IF;
865: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
866: l_warn := 'W'; --Bug 4681032
867: IF G_TRACE_ON = 1 THEN
868: print_debug('INV_Minmax_PVT.run_min_max_plan failed with expected error for subinventory '|| l_subinv_tbl(l_subinv_count) ||' returning message: ' || l_msg_data
869: ,l_proc

Line 927: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

923: , x_msg_data => l_msg_data
924: , p_osfm_batch_id => l_osfm_batch_id /* Added for Bug 6807835 */
925: );
926:
927: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
928: IF G_TRACE_ON = 1 THEN
929: print_debug('INV_Minmax_PVT.run_min_max_plan failed with unexpected error ' ||
930: 'returning message: ' || l_msg_data
931: ,l_proc

Line 934: RAISE fnd_api.g_exc_unexpected_error;

930: 'returning message: ' || l_msg_data
931: ,l_proc
932: , 9);
933: END IF;
934: RAISE fnd_api.g_exc_unexpected_error;
935: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
936: IF G_TRACE_ON = 1 THEN
937: print_debug('INV_Minmax_PVT.run_min_max_plan failed with expected error returning message: ' || l_msg_data
938: ,l_proc

Line 935: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

931: ,l_proc
932: , 9);
933: END IF;
934: RAISE fnd_api.g_exc_unexpected_error;
935: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
936: IF G_TRACE_ON = 1 THEN
937: print_debug('INV_Minmax_PVT.run_min_max_plan failed with expected error returning message: ' || l_msg_data
938: ,l_proc
939: , 9);

Line 941: RAISE fnd_api.g_exc_error;

937: print_debug('INV_Minmax_PVT.run_min_max_plan failed with expected error returning message: ' || l_msg_data
938: ,l_proc
939: , 9);
940: END IF;
941: RAISE fnd_api.g_exc_error;
942: ELSE
943: IF G_TRACE_ON = 1 THEN
944: print_debug('INV_Minmax_PVT.run_min_max_plan returned success'
945: ,l_proc

Line 1006: if x_return_status = FND_API.G_RET_STS_SUCCESS and l_warn='W' then

1002: END IF;
1003: /* End of Changes for Bug 6807835 */
1004:
1005: --Bug 4681032
1006: if x_return_status = FND_API.G_RET_STS_SUCCESS and l_warn='W' then
1007: x_return_status := 'W';
1008: end if;
1009: --Bug 4681032
1010:

Line 1013: WHEN fnd_api.g_exc_error THEN

1009: --Bug 4681032
1010:
1011:
1012: EXCEPTION
1013: WHEN fnd_api.g_exc_error THEN
1014: ROLLBACK TO sp_exec_min_max;
1015: x_return_status := fnd_api.g_ret_sts_error;
1016: fnd_msg_pub.count_and_get
1017: ( p_count => x_msg_count,

Line 1015: x_return_status := fnd_api.g_ret_sts_error;

1011:
1012: EXCEPTION
1013: WHEN fnd_api.g_exc_error THEN
1014: ROLLBACK TO sp_exec_min_max;
1015: x_return_status := fnd_api.g_ret_sts_error;
1016: fnd_msg_pub.count_and_get
1017: ( p_count => x_msg_count,
1018: p_data => x_msg_data
1019: );

Line 1021: WHEN fnd_api.g_exc_unexpected_error THEN

1017: ( p_count => x_msg_count,
1018: p_data => x_msg_data
1019: );
1020:
1021: WHEN fnd_api.g_exc_unexpected_error THEN
1022: ROLLBACK TO sp_exec_min_max;
1023: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1024: fnd_msg_pub.count_and_get
1025: ( p_count => x_msg_count,

Line 1023: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1019: );
1020:
1021: WHEN fnd_api.g_exc_unexpected_error THEN
1022: ROLLBACK TO sp_exec_min_max;
1023: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1024: fnd_msg_pub.count_and_get
1025: ( p_count => x_msg_count,
1026: p_data => x_msg_data
1027: );

Line 1031: x_return_status := fnd_api.g_ret_sts_unexp_error;

1027: );
1028:
1029: WHEN OTHERS THEN
1030: ROLLBACK TO sp_exec_min_max;
1031: x_return_status := fnd_api.g_ret_sts_unexp_error;
1032: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)THEN
1033: fnd_msg_pub.add_exc_msg
1034: ('INV_MMX_WRAPPER_PVT'
1035: ,l_proc

Line 1215: x_return_status := FND_API.G_RET_STS_SUCCESS;

1211: l_msg_count NUMBER;
1212:
1213: BEGIN
1214: SAVEPOINT sp_do_restock;
1215: x_return_status := FND_API.G_RET_STS_SUCCESS;
1216:
1217: --
1218: -- Initialize the Package variables.
1219: --

Line 1323: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1319: , x_ret_stat => l_return_status
1320: , x_ret_mesg => l_msg_data
1321: );
1322:
1323: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1324: IF G_TRACE_ON = 1 THEN
1325: print_debug('INV_Minmax_PVT.do_restock failed with unexpected error returning message: ' || l_msg_data
1326: , l_proc_name
1327: , 9);

Line 1329: RAISE fnd_api.g_exc_unexpected_error;

1325: print_debug('INV_Minmax_PVT.do_restock failed with unexpected error returning message: ' || l_msg_data
1326: , l_proc_name
1327: , 9);
1328: END IF;
1329: RAISE fnd_api.g_exc_unexpected_error;
1330: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1331: IF G_TRACE_ON = 1 THEN
1332: print_debug('INV_Minmax_PVT.do_restock failed with expected error returning message: ' || l_msg_data
1333: , l_proc_name

Line 1330: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1326: , l_proc_name
1327: , 9);
1328: END IF;
1329: RAISE fnd_api.g_exc_unexpected_error;
1330: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1331: IF G_TRACE_ON = 1 THEN
1332: print_debug('INV_Minmax_PVT.do_restock failed with expected error returning message: ' || l_msg_data
1333: , l_proc_name
1334: , 9);

Line 1336: RAISE fnd_api.g_exc_error;

1332: print_debug('INV_Minmax_PVT.do_restock failed with expected error returning message: ' || l_msg_data
1333: , l_proc_name
1334: , 9);
1335: END IF;
1336: RAISE fnd_api.g_exc_error;
1337: ELSE
1338: IF G_TRACE_ON = 1 THEN
1339: print_debug('INV_Minmax_PVT.do_restock returned success'
1340: , l_proc_name

Line 1346: WHEN fnd_api.g_exc_error THEN

1342: END IF;
1343: END IF;
1344:
1345: EXCEPTION
1346: WHEN fnd_api.g_exc_error THEN
1347: ROLLBACK TO sp_do_restock;
1348: x_return_status := fnd_api.g_ret_sts_error;
1349: fnd_msg_pub.count_and_get
1350: ( p_count => x_msg_count,

Line 1348: x_return_status := fnd_api.g_ret_sts_error;

1344:
1345: EXCEPTION
1346: WHEN fnd_api.g_exc_error THEN
1347: ROLLBACK TO sp_do_restock;
1348: x_return_status := fnd_api.g_ret_sts_error;
1349: fnd_msg_pub.count_and_get
1350: ( p_count => x_msg_count,
1351: p_data => x_msg_data
1352: );

Line 1354: WHEN fnd_api.g_exc_unexpected_error THEN

1350: ( p_count => x_msg_count,
1351: p_data => x_msg_data
1352: );
1353:
1354: WHEN fnd_api.g_exc_unexpected_error THEN
1355: ROLLBACK TO sp_do_restock;
1356: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1357: fnd_msg_pub.count_and_get
1358: ( p_count => x_msg_count,

Line 1356: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1352: );
1353:
1354: WHEN fnd_api.g_exc_unexpected_error THEN
1355: ROLLBACK TO sp_do_restock;
1356: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1357: fnd_msg_pub.count_and_get
1358: ( p_count => x_msg_count,
1359: p_data => x_msg_data
1360: );

Line 1364: x_return_status := fnd_api.g_ret_sts_unexp_error;

1360: );
1361:
1362: WHEN OTHERS THEN
1363: ROLLBACK TO sp_do_restock;
1364: x_return_status := fnd_api.g_ret_sts_unexp_error;
1365: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)THEN
1366: fnd_msg_pub.add_exc_msg
1367: ( G_PKG_NAME
1368: , l_proc_name

Line 1444: l_commit VARCHAR2(1) := FND_API.G_FALSE;

1440: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
1441: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
1442: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
1443: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
1444: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1445:
1446: BEGIN
1447: SAVEPOINT sp_get_move_order_info;
1448: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1448: l_return_status := FND_API.G_RET_STS_SUCCESS;

1444: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1445:
1446: BEGIN
1447: SAVEPOINT sp_get_move_order_info;
1448: l_return_status := FND_API.G_RET_STS_SUCCESS;
1449: IF G_TRACE_ON = 1 THEN
1450: print_debug ('Executing get_move_order_info with the following parameters: ' || fnd_global.local_chr(10) ||
1451: ' p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
1452: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||

Line 1479: l_trohdr_rec.db_flag := FND_API.G_TRUE;

1475: l_trohdr_rec.status_date := sysdate;
1476: l_trohdr_rec.to_subinventory_code := p_subinv;
1477: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT;
1478: l_trohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
1479: l_trohdr_rec.db_flag := FND_API.G_TRUE;
1480: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
1481: IF G_TRACE_ON = 1 THEN
1482: print_debug('Calling INV_Move_Order_PUB.Create_Move_Order_Header'
1483: , l_proc_name

Line 1488: p_init_msg_list => FND_API.G_FALSE,

1484: , 9);
1485: END IF;
1486: INV_Move_Order_PUB.Create_Move_Order_Header(
1487: p_api_version_number => 1,
1488: p_init_msg_list => FND_API.G_FALSE,
1489: p_return_values => FND_API.G_TRUE,
1490: p_commit => l_commit,
1491: x_return_status => l_return_status,
1492: x_msg_count => l_msg_count,

Line 1489: p_return_values => FND_API.G_TRUE,

1485: END IF;
1486: INV_Move_Order_PUB.Create_Move_Order_Header(
1487: p_api_version_number => 1,
1488: p_init_msg_list => FND_API.G_FALSE,
1489: p_return_values => FND_API.G_TRUE,
1490: p_commit => l_commit,
1491: x_return_status => l_return_status,
1492: x_msg_count => l_msg_count,
1493: x_msg_data => l_msg_data,

Line 1500: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1496: x_trohdr_rec => l_x_trohdr_rec,
1497: x_trohdr_val_rec => l_x_trohdr_val_rec
1498: );
1499:
1500: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1501: IF G_TRACE_ON = 1 THEN
1502: print_debug('INV_Move_Order_PUB.Create_Move_Order_Header failed with unexpected error returning message: ' || l_msg_data
1503: , l_proc_name
1504: , 9);

Line 1506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1502: print_debug('INV_Move_Order_PUB.Create_Move_Order_Header failed with unexpected error returning message: ' || l_msg_data
1503: , l_proc_name
1504: , 9);
1505: END IF;
1506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1507: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1508: IF G_TRACE_ON = 1 THEN
1509: print_debug('INV_Move_Order_PUB.Create_Move_Order_Header failed with expected error returning message: ' || l_msg_data
1510: , l_proc_name

Line 1507: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1503: , l_proc_name
1504: , 9);
1505: END IF;
1506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1507: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1508: IF G_TRACE_ON = 1 THEN
1509: print_debug('INV_Move_Order_PUB.Create_Move_Order_Header failed with expected error returning message: ' || l_msg_data
1510: , l_proc_name
1511: , 9);

Line 1513: RAISE FND_API.G_EXC_ERROR;

1509: print_debug('INV_Move_Order_PUB.Create_Move_Order_Header failed with expected error returning message: ' || l_msg_data
1510: , l_proc_name
1511: , 9);
1512: END IF;
1513: RAISE FND_API.G_EXC_ERROR;
1514: ELSE
1515: IF G_TRACE_ON = 1 THEN
1516: print_debug('INV_Move_Order_PUB.Create_Move_Order_Header returned success with header Id: ' || l_x_trohdr_rec.header_id
1517: , l_proc_name

Line 1535: WHEN fnd_api.g_exc_error THEN

1531: G_CURRENT_MO_LINE_NUM := G_CURRENT_MO_LINE_NUM + 1;
1532: x_move_order_header_ID := G_CURRENT_MO_HDR_ID;
1533: x_move_order_line_num := G_CURRENT_MO_LINE_NUM ;
1534: EXCEPTION
1535: WHEN fnd_api.g_exc_error THEN
1536: ROLLBACK TO sp_get_move_order_info;
1537: x_return_status := fnd_api.g_ret_sts_error;
1538: fnd_msg_pub.count_and_get
1539: ( p_count => x_msg_count,

Line 1537: x_return_status := fnd_api.g_ret_sts_error;

1533: x_move_order_line_num := G_CURRENT_MO_LINE_NUM ;
1534: EXCEPTION
1535: WHEN fnd_api.g_exc_error THEN
1536: ROLLBACK TO sp_get_move_order_info;
1537: x_return_status := fnd_api.g_ret_sts_error;
1538: fnd_msg_pub.count_and_get
1539: ( p_count => x_msg_count,
1540: p_data => x_msg_data
1541: );

Line 1543: WHEN fnd_api.g_exc_unexpected_error THEN

1539: ( p_count => x_msg_count,
1540: p_data => x_msg_data
1541: );
1542:
1543: WHEN fnd_api.g_exc_unexpected_error THEN
1544: ROLLBACK TO sp_get_move_order_info;
1545: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1546: fnd_msg_pub.count_and_get
1547: ( p_count => x_msg_count,

Line 1545: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1541: );
1542:
1543: WHEN fnd_api.g_exc_unexpected_error THEN
1544: ROLLBACK TO sp_get_move_order_info;
1545: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1546: fnd_msg_pub.count_and_get
1547: ( p_count => x_msg_count,
1548: p_data => x_msg_data
1549: );

Line 1553: x_return_status := fnd_api.g_ret_sts_unexp_error;

1549: );
1550:
1551: WHEN OTHERS THEN
1552: ROLLBACK TO sp_get_move_order_info;
1553: x_return_status := fnd_api.g_ret_sts_unexp_error;
1554: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)THEN
1555: fnd_msg_pub.add_exc_msg
1556: ( G_PKG_NAME
1557: , l_proc_name