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 367: RAISE fnd_api.g_exc_error;

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

Line 387: RAISE fnd_api.g_exc_error;

383: print_debug('Exception: No default category set exists'
384: ,l_proc
385: , 9);
386: END IF;
387: RAISE fnd_api.g_exc_error;
388: END;
389:
390: END IF;
391: IF G_TRACE_ON = 1 THEN

Line 413: RAISE fnd_api.g_exc_error;

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

Line 457: RAISE fnd_api.g_exc_error;

453: print_debug('Exception: No Default Delivery To Location Exists'
454: , l_proc
455: , 9);
456: END IF;
457: RAISE fnd_api.g_exc_error;
458: END;
459: ELSE
460: l_dd_loc_id := P_DD_LOC_ID;
461: END IF;

Line 524: RAISE fnd_api.g_exc_error;

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

Line 599: RAISE fnd_api.g_exc_error;

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

Line 622: RAISE fnd_api.g_exc_error;

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

Line 659: RAISE fnd_api.g_exc_error;

655: print_debug('Exception: The Lookup MTL_MINMAX_RPT_SORT_BY is not defined'
656: , l_proc
657: , 9);
658: END IF;
659: RAISE fnd_api.g_exc_error;
660: END;
661:
662: --
663: -- Validate P_SELECTION.

Line 678: RAISE fnd_api.g_exc_error;

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

Line 707: RAISE fnd_api.g_exc_error;

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

Line 733: RAISE fnd_api.g_exc_error;

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

Line 790: RAISE fnd_api.g_exc_error;

786: , 9);
787: END IF;
788: fnd_message.set_name('INV','INV_MINMAX_NO_ITEM_SETUP');
789: fnd_msg_pub.add;
790: RAISE fnd_api.g_exc_error;
791: END IF;
792: ELSE
793: l_subinv_tbl := p_subinv_tbl;
794:

Line 852: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 861: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

857: 'returning message: ' || l_msg_data
858: ,l_proc
859: , 9);
860: END IF;
861: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
862: l_warn := 'W'; --Bug 4681032
863: IF G_TRACE_ON = 1 THEN
864: 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
865: ,l_proc

Line 923: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 930: RAISE fnd_api.g_exc_unexpected_error;

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

Line 931: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 937: RAISE fnd_api.g_exc_error;

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

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

998: END IF;
999: /* End of Changes for Bug 6807835 */
1000:
1001: --Bug 4681032
1002: if x_return_status = FND_API.G_RET_STS_SUCCESS and l_warn='W' then
1003: x_return_status := 'W';
1004: end if;
1005: --Bug 4681032
1006:

Line 1009: WHEN fnd_api.g_exc_error THEN

1005: --Bug 4681032
1006:
1007:
1008: EXCEPTION
1009: WHEN fnd_api.g_exc_error THEN
1010: ROLLBACK TO sp_exec_min_max;
1011: x_return_status := fnd_api.g_ret_sts_error;
1012: fnd_msg_pub.count_and_get
1013: ( p_count => x_msg_count,

Line 1011: x_return_status := fnd_api.g_ret_sts_error;

1007:
1008: EXCEPTION
1009: WHEN fnd_api.g_exc_error THEN
1010: ROLLBACK TO sp_exec_min_max;
1011: x_return_status := fnd_api.g_ret_sts_error;
1012: fnd_msg_pub.count_and_get
1013: ( p_count => x_msg_count,
1014: p_data => x_msg_data
1015: );

Line 1017: WHEN fnd_api.g_exc_unexpected_error THEN

1013: ( p_count => x_msg_count,
1014: p_data => x_msg_data
1015: );
1016:
1017: WHEN fnd_api.g_exc_unexpected_error THEN
1018: ROLLBACK TO sp_exec_min_max;
1019: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1020: fnd_msg_pub.count_and_get
1021: ( p_count => x_msg_count,

Line 1019: x_return_status := fnd_api.g_ret_sts_unexp_error ;

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

Line 1027: x_return_status := fnd_api.g_ret_sts_unexp_error;

1023: );
1024:
1025: WHEN OTHERS THEN
1026: ROLLBACK TO sp_exec_min_max;
1027: x_return_status := fnd_api.g_ret_sts_unexp_error;
1028: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)THEN
1029: fnd_msg_pub.add_exc_msg
1030: ('INV_MMX_WRAPPER_PVT'
1031: ,l_proc

Line 1211: x_return_status := FND_API.G_RET_STS_SUCCESS;

1207: l_msg_count NUMBER;
1208:
1209: BEGIN
1210: SAVEPOINT sp_do_restock;
1211: x_return_status := FND_API.G_RET_STS_SUCCESS;
1212:
1213: --
1214: -- Initialize the Package variables.
1215: --

Line 1319: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1325: RAISE fnd_api.g_exc_unexpected_error;

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

Line 1326: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1332: RAISE fnd_api.g_exc_error;

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

Line 1342: WHEN fnd_api.g_exc_error THEN

1338: END IF;
1339: END IF;
1340:
1341: EXCEPTION
1342: WHEN fnd_api.g_exc_error THEN
1343: ROLLBACK TO sp_do_restock;
1344: x_return_status := fnd_api.g_ret_sts_error;
1345: fnd_msg_pub.count_and_get
1346: ( p_count => x_msg_count,

Line 1344: x_return_status := fnd_api.g_ret_sts_error;

1340:
1341: EXCEPTION
1342: WHEN fnd_api.g_exc_error THEN
1343: ROLLBACK TO sp_do_restock;
1344: x_return_status := fnd_api.g_ret_sts_error;
1345: fnd_msg_pub.count_and_get
1346: ( p_count => x_msg_count,
1347: p_data => x_msg_data
1348: );

Line 1350: WHEN fnd_api.g_exc_unexpected_error THEN

1346: ( p_count => x_msg_count,
1347: p_data => x_msg_data
1348: );
1349:
1350: WHEN fnd_api.g_exc_unexpected_error THEN
1351: ROLLBACK TO sp_do_restock;
1352: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1353: fnd_msg_pub.count_and_get
1354: ( p_count => x_msg_count,

Line 1352: x_return_status := fnd_api.g_ret_sts_unexp_error ;

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

Line 1360: x_return_status := fnd_api.g_ret_sts_unexp_error;

1356: );
1357:
1358: WHEN OTHERS THEN
1359: ROLLBACK TO sp_do_restock;
1360: x_return_status := fnd_api.g_ret_sts_unexp_error;
1361: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)THEN
1362: fnd_msg_pub.add_exc_msg
1363: ( G_PKG_NAME
1364: , l_proc_name

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

1436: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
1437: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
1438: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
1439: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
1440: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1441:
1442: BEGIN
1443: SAVEPOINT sp_get_move_order_info;
1444: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1444: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 1484: p_init_msg_list => FND_API.G_FALSE,

1480: , 9);
1481: END IF;
1482: INV_Move_Order_PUB.Create_Move_Order_Header(
1483: p_api_version_number => 1,
1484: p_init_msg_list => FND_API.G_FALSE,
1485: p_return_values => FND_API.G_TRUE,
1486: p_commit => l_commit,
1487: x_return_status => l_return_status,
1488: x_msg_count => l_msg_count,

Line 1485: p_return_values => FND_API.G_TRUE,

1481: END IF;
1482: INV_Move_Order_PUB.Create_Move_Order_Header(
1483: p_api_version_number => 1,
1484: p_init_msg_list => FND_API.G_FALSE,
1485: p_return_values => FND_API.G_TRUE,
1486: p_commit => l_commit,
1487: x_return_status => l_return_status,
1488: x_msg_count => l_msg_count,
1489: x_msg_data => l_msg_data,

Line 1496: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1503: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1509: RAISE FND_API.G_EXC_ERROR;

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

Line 1531: WHEN fnd_api.g_exc_error THEN

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

Line 1533: x_return_status := fnd_api.g_ret_sts_error;

1529: x_move_order_line_num := G_CURRENT_MO_LINE_NUM ;
1530: EXCEPTION
1531: WHEN fnd_api.g_exc_error THEN
1532: ROLLBACK TO sp_get_move_order_info;
1533: x_return_status := fnd_api.g_ret_sts_error;
1534: fnd_msg_pub.count_and_get
1535: ( p_count => x_msg_count,
1536: p_data => x_msg_data
1537: );

Line 1539: WHEN fnd_api.g_exc_unexpected_error THEN

1535: ( p_count => x_msg_count,
1536: p_data => x_msg_data
1537: );
1538:
1539: WHEN fnd_api.g_exc_unexpected_error THEN
1540: ROLLBACK TO sp_get_move_order_info;
1541: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1542: fnd_msg_pub.count_and_get
1543: ( p_count => x_msg_count,

Line 1541: x_return_status := fnd_api.g_ret_sts_unexp_error ;

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

Line 1549: x_return_status := fnd_api.g_ret_sts_unexp_error;

1545: );
1546:
1547: WHEN OTHERS THEN
1548: ROLLBACK TO sp_get_move_order_info;
1549: x_return_status := fnd_api.g_ret_sts_unexp_error;
1550: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)THEN
1551: fnd_msg_pub.add_exc_msg
1552: ( G_PKG_NAME
1553: , l_proc_name