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.WSH_INTEGRATION dependencies on FND_API

Line 8: --Bug#5104847:Assigning default value FND_API.G_MISS_NUM to trx_id and trx_temp_id as

4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_INTEGRATION';
6:
7: -- Global variable holding transaction_id
8: --Bug#5104847:Assigning default value FND_API.G_MISS_NUM to trx_id and trx_temp_id as
9: -- WMS is not calling the API WSH_INTEGRATION.Set_Inv_PC_Attributes to set trx ids.
10: TYPE InvPCRecType IS RECORD
11: ( transaction_id NUMBER DEFAULT FND_API.G_MISS_NUM,
12: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM);

Line 11: ( transaction_id NUMBER DEFAULT FND_API.G_MISS_NUM,

7: -- Global variable holding transaction_id
8: --Bug#5104847:Assigning default value FND_API.G_MISS_NUM to trx_id and trx_temp_id as
9: -- WMS is not calling the API WSH_INTEGRATION.Set_Inv_PC_Attributes to set trx ids.
10: TYPE InvPCRecType IS RECORD
11: ( transaction_id NUMBER DEFAULT FND_API.G_MISS_NUM,
12: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM);
13:
14:
15: G_InvPCRec InvPCRecType;

Line 12: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM);

8: --Bug#5104847:Assigning default value FND_API.G_MISS_NUM to trx_id and trx_temp_id as
9: -- WMS is not calling the API WSH_INTEGRATION.Set_Inv_PC_Attributes to set trx ids.
10: TYPE InvPCRecType IS RECORD
11: ( transaction_id NUMBER DEFAULT FND_API.G_MISS_NUM,
12: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM);
13:
14:
15: G_InvPCRec InvPCRecType;
16:

Line 62: x_return_status := FND_API.G_RET_STS_ERROR;

58: IF ( p_in_attributes.source_code IS NULL )
59: THEN
60: x_msg_count := 1;
61: x_msg_data := 'INVALID SOURCE_CODE';
62: x_return_status := FND_API.G_RET_STS_ERROR;
63: END IF;
64:
65: IF l_debug_on THEN
66: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_DETAILS_VALIDATIONS.Get_Min_Max_Tolerance_Quantity');

Line 122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

118: END IF;
119:
120: EXCEPTION
121: WHEN OTHERS THEN
122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
123:
124: FND_MSG_PUB.Count_And_Get
125: ( p_count => x_msg_count
126: , p_data => x_msg_data

Line 127: ,p_encoded => FND_API.G_FALSE

123:
124: FND_MSG_PUB.Count_And_Get
125: ( p_count => x_msg_count
126: , p_data => x_msg_data
127: ,p_encoded => FND_API.G_FALSE
128: );
129:
130: IF l_debug_on THEN
131: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

Line 200: x_return_status := FND_API.G_RET_STS_ERROR;

196: IF ( p_in_attributes.source_code IS NULL )
197: THEN
198: x_msg_count := 1;
199: x_msg_data := 'INVALID SOURCE_CODE';
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: END IF;
202:
203: x_return_status := FND_API.G_RET_STS_SUCCESS;
204:

Line 203: x_return_status := FND_API.G_RET_STS_SUCCESS;

199: x_msg_data := 'INVALID SOURCE_CODE';
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: END IF;
202:
203: x_return_status := FND_API.G_RET_STS_SUCCESS;
204:
205: l_closing_fm_date := p_in_attributes.closing_fm_date;
206: l_closing_to_date := p_in_attributes.closing_to_date;
207: l_organization_id := p_in_attributes.organization_id;

Line 333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

329: END IF;
330:
331: EXCEPTION
332: WHEN OTHERS THEN
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
334:
335: FND_MSG_PUB.Count_And_Get
336: ( p_count => x_msg_count
337: , p_data => x_msg_data

Line 338: ,p_encoded => FND_API.G_FALSE

334:
335: FND_MSG_PUB.Count_And_Get
336: ( p_count => x_msg_count
337: , p_data => x_msg_data
338: ,p_encoded => FND_API.G_FALSE
339: );
340:
341: IF l_debug_on THEN
342: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

Line 378: x_return_status := FND_API.G_RET_STS_ERROR;

374: IF ( p_in_attributes.source_code IS NULL )
375: THEN
376: x_msg_count := 1;
377: x_msg_data := 'INVALID SOURCE_CODE';
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: END IF;
380:
381: x_return_status := FND_API.G_RET_STS_SUCCESS;
382:

Line 381: x_return_status := FND_API.G_RET_STS_SUCCESS;

377: x_msg_data := 'INVALID SOURCE_CODE';
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: END IF;
380:
381: x_return_status := FND_API.G_RET_STS_SUCCESS;
382:
383: l_line_id := p_in_attributes.line_id;
384:
385: BEGIN

Line 410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

406: p_out_attributes.nonintf_line_qty := l_nonintf_line_qty;
407:
408: EXCEPTION
409: WHEN OTHERS THEN
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
411:
412: FND_MSG_PUB.Count_And_Get
413: ( p_count => x_msg_count
414: , p_data => x_msg_data

Line 415: ,p_encoded => FND_API.G_FALSE

411:
412: FND_MSG_PUB.Count_And_Get
413: ( p_count => x_msg_count
414: , p_data => x_msg_data
415: ,p_encoded => FND_API.G_FALSE
416: );
417:
418: END Get_Nonintf_Shpg_Line_Qty;
419:

Line 478: x_return_status := FND_API.G_RET_STS_SUCCESS;

474: WSH_DEBUG_SV.log(l_module_name,'ship_model_id',p_backorder_rec.ship_model_id);
475: END IF;
476:
477:
478: x_return_status := FND_API.G_RET_STS_SUCCESS;
479:
480: -- Standard call to check for call compatibility
481: IF NOT FND_API.Compatible_API_Call
482: ( l_api_version_number

Line 481: IF NOT FND_API.Compatible_API_Call

477:
478: x_return_status := FND_API.G_RET_STS_SUCCESS;
479:
480: -- Standard call to check for call compatibility
481: IF NOT FND_API.Compatible_API_Call
482: ( l_api_version_number
483: , p_api_version_number
484: , l_api_name
485: , G_PKG_NAME

Line 488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

484: , l_api_name
485: , G_PKG_NAME
486: )
487: THEN
488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
489: END IF;
490:
491: -- Initialize message list.
492:

Line 493: IF FND_API.to_Boolean(p_init_msg_list) THEN

489: END IF;
490:
491: -- Initialize message list.
492:
493: IF FND_API.to_Boolean(p_init_msg_list) THEN
494: FND_MSG_PUB.initialize;
495: END IF;
496:
497:

Line 502: x_return_status := FND_API.G_RET_STS_ERROR;

498: IF ( p_source_code IS NULL ) OR (p_source_code <> 'INV' ) THEN
499:
500: x_msg_count := 1;
501: x_msg_data := 'INVALID SOURCE CODE';
502: x_return_status := FND_API.G_RET_STS_ERROR;
503:
504: ELSIF ( p_backorder_rec.move_order_line_id IS NULL AND p_backorder_rec.delivery_detail_id IS NULL )
505: OR ( p_backorder_rec.ship_set_id IS NULL AND p_backorder_rec.ship_model_id IS NULL ) THEN
506:

Line 509: x_return_status := FND_API.G_RET_STS_ERROR;

505: OR ( p_backorder_rec.ship_set_id IS NULL AND p_backorder_rec.ship_model_id IS NULL ) THEN
506:
507: x_msg_count := 1;
508: x_msg_data := 'INVALID RECORD';
509: x_return_status := FND_API.G_RET_STS_ERROR;
510:
511: ELSE
512:
513: l_cnt := G_BackorderRec_Tbl.LAST;

Line 656: x_return_status := FND_API.G_RET_STS_SUCCESS;

652: WSH_DEBUG_SV.log(l_module_name,'p_printer_name',p_printer_name);
653: WSH_DEBUG_SV.log(l_module_name,'p_enabled_flag',p_enabled_flag);
654: END IF;
655:
656: x_return_status := FND_API.G_RET_STS_SUCCESS;
657: l_application_id := p_application_id;
658:
659: trace('******** Mobile Printer Sign On **********');
660:

Line 675: x_return_status := fnd_api.g_ret_sts_error;

671: FND_MESSAGE.SET_NAME('WSH', 'WSH_PRINTER_NAME_REQUIRED');
672: FND_MSG_PUB.ADD;
673: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
674: , p_data => x_msg_data );
675: x_return_status := fnd_api.g_ret_sts_error;
676: IF l_debug_on THEN
677: wsh_debug_sv.pop(l_module_name,'RETURN');
678: END IF;
679:

Line 717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

713: FND_MESSAGE.SET_NAME('WSH', 'WSH_PRINTER_NOT_SIGNON');
714: FND_MSG_PUB.ADD;
715: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
716: , p_data => x_msg_data );
717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
718: IF l_debug_on THEN
719: wsh_debug_sv.pop(l_module_name,'RETURN');
720: END IF;
721: RETURN;

Line 937: WHEN fnd_api.g_exc_error THEN

933: wsh_debug_sv.pop(l_module_name);
934: wsh_debug_sv.stop_debug;
935: END IF;
936: EXCEPTION
937: WHEN fnd_api.g_exc_error THEN
938: trace(' Expected Error In '|| G_PKG_NAME||'.' || l_api_name);
939: trace('ERROR CODE = ' || SQLCODE);
940: trace('ERROR MESSAGE = ' || SQLERRM);
941: IF l_debug_on THEN

Line 947: WHEN fnd_api.g_exc_unexpected_error THEN

943: wsh_debug_sv.stop_debug;
944: END IF;
945: ROLLBACK;
946:
947: WHEN fnd_api.g_exc_unexpected_error THEN
948: trace(' Unexpected Error In '|| G_PKG_NAME||'.' || l_api_name);
949: trace('ERROR CODE = ' || SQLCODE);
950: trace('ERROR MESSAGE = ' || SQLERRM);
951: IF l_debug_on THEN

Line 983: x_return_status := FND_API.G_RET_STS_SUCCESS;

979: l_api_version_number CONSTANT NUMBER := 1.0;
980: l_api_name CONSTANT VARCHAR2(30):= 'Set_Inv_PC_Attributes';
981:
982: BEGIN
983: x_return_status := FND_API.G_RET_STS_SUCCESS;
984:
985: -- Standard call to check for call compatibility
986: IF NOT FND_API.Compatible_API_Call
987: ( l_api_version_number

Line 986: IF NOT FND_API.Compatible_API_Call

982: BEGIN
983: x_return_status := FND_API.G_RET_STS_SUCCESS;
984:
985: -- Standard call to check for call compatibility
986: IF NOT FND_API.Compatible_API_Call
987: ( l_api_version_number
988: , p_in_attributes.api_version_number
989: , l_api_name
990: , G_PKG_NAME

Line 993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

989: , l_api_name
990: , G_PKG_NAME
991: )
992: THEN
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: END IF;
995: IF ( p_in_attributes.source_code IS NULL ) OR (p_in_attributes.source_code
996: <> 'INV' ) THEN
997: x_msg_count := 1;

Line 999: x_return_status := FND_API.G_RET_STS_ERROR;

995: IF ( p_in_attributes.source_code IS NULL ) OR (p_in_attributes.source_code
996: <> 'INV' ) THEN
997: x_msg_count := 1;
998: x_msg_data := 'INVALID SOURCE CODE';
999: x_return_status := FND_API.G_RET_STS_ERROR;
1000: ELSE
1001: G_InvPCRec.transaction_id := p_in_attributes.transaction_id;
1002: G_InvPCRec.transaction_temp_id := p_in_attributes.transaction_temp_id;
1003: END IF;

Line 1028: x_return_status := FND_API.G_RET_STS_SUCCESS;

1024: x_msg_count OUT NOCOPY NUMBER,
1025: x_msg_data OUT NOCOPY VARCHAR2
1026: ) IS
1027: BEGIN
1028: x_return_status := FND_API.G_RET_STS_SUCCESS;
1029:
1030: p_out_attributes.transaction_id := G_InvPCRec.transaction_id;
1031: p_out_attributes.transaction_temp_id := G_InvPCRec.transaction_temp_id;
1032:

Line 1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1142:
1143: EXCEPTION
1144: WHEN OTHERS THEN
1145: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1147: wsh_util_core.add_message(x_return_status,l_module_name);
1148: IF l_debug_on THEN
1149: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1150: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1243:
1244: EXCEPTION
1245: WHEN OTHERS THEN
1246: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1248: wsh_util_core.add_message(x_return_status,l_module_name);
1249:
1250: IF l_debug_on THEN
1251: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

Line 1358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1354:
1355: EXCEPTION
1356: WHEN OTHERS THEN
1357: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1359: wsh_util_core.add_message(x_return_status,l_module_name);
1360:
1361: IF l_debug_on THEN
1362: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

Line 1465: x_return_status := FND_API.G_RET_STS_ERROR;

1461: END IF;
1462:
1463: IF l_attr_tab.COUNT > 1 THEN
1464: --{
1465: x_return_status := FND_API.G_RET_STS_ERROR;
1466: IF l_debug_on THEN
1467: --{
1468: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab.count for ''MATCH_GROUPS'' > 1 and hence exiting..');
1469: WSH_DEBUG_SV.pop(l_module_name);

Line 1529: x_return_status := FND_API.G_RET_STS_ERROR;

1525: END IF;
1526:
1527: EXCEPTION
1528: WHEN NO_DATA_FOUND THEN
1529: x_return_status := FND_API.G_RET_STS_ERROR;
1530: IF l_debug_on THEN
1531: --{
1532: WSH_DEBUG_SV.log(l_module_name, 'Delivery Detail doesnt exists in WDD', l_del_det_id);
1533: WSH_DEBUG_SV.pop(l_module_name);

Line 1539: x_return_status := FND_API.G_RET_STS_ERROR;

1535: END IF;
1536: RETURN;
1537:
1538: WHEN OTHERS THEN
1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540: IF l_debug_on THEN
1541: --{
1542: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1543: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1550: x_return_status := FND_API.G_RET_STS_ERROR;

1546: RETURN;
1547: END;
1548:
1549: ELSE -- Delivery Detail is Invalid
1550: x_return_status := FND_API.G_RET_STS_ERROR;
1551: IF l_debug_on THEN
1552: --{
1553: WSH_DEBUG_SV.logmsg(l_module_name,'Invalid Delivery_detail_id',l_del_det_id);
1554: WSH_DEBUG_SV.pop(l_module_name);

Line 1622: -- x_return_status -- Return Status [ Fnd api- Return Status: Sucess, Error , UnExpected Error ]

1618: -- Output :
1619: -- x_cancel_qty_allowed -- Qty. that is allowed to be Cancelled in Source Ordered Qty. UOM
1620: -- If there is No Qty. that can be cancelled, then this parameter will return 0 (Zero)
1621: --
1622: -- x_return_status -- Return Status [ Fnd api- Return Status: Sucess, Error , UnExpected Error ]
1623: -- x_msg_count,data -- Number of Messages, Message Data Stored
1624: PROCEDURE Get_Cancel_Qty_Allowed
1625: ( p_source_code IN VARCHAR2,
1626: p_source_line_id IN NUMBER,

Line 1664: x_return_status := FND_API.G_RET_STS_ERROR;

1660: IF ( p_source_code IS NULL )
1661: THEN
1662: x_msg_count := 1;
1663: x_msg_data := 'INVALID SOURCE_CODE';
1664: x_return_status := FND_API.G_RET_STS_ERROR;
1665: IF l_debug_on THEN
1666: WSH_DEBUG_SV.log(l_module_name,'Invalid source code: ', p_source_code);
1667: WSH_DEBUG_SV.pop(l_module_name);
1668: END IF;

Line 1672: x_return_status := FND_API.G_RET_STS_SUCCESS;

1668: END IF;
1669: return;
1670: END IF;
1671:
1672: x_return_status := FND_API.G_RET_STS_SUCCESS;
1673:
1674: BEGIN
1675: -- select stmt.
1676:

Line 1703: x_return_status := fnd_api.g_ret_sts_error;

1699: FND_MESSAGE.SET_NAME('WSH', 'WSH_LINE_CANCEL_NOT_ALLOWED');
1700: FND_MSG_PUB.ADD;
1701: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1702: , p_data => x_msg_data );
1703: x_return_status := fnd_api.g_ret_sts_error;
1704: return;
1705: END;
1706: --
1707: x_cancel_qty_allowed := l_cancel_qty_allowed;

Line 1743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1739: EXCEPTION
1740:
1741: WHEN OTHERS THEN
1742: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1744:
1745: FND_MSG_PUB.Count_And_Get
1746: ( p_count => x_msg_count
1747: , p_data => x_msg_data

Line 1748: ,p_encoded => FND_API.G_FALSE

1744:
1745: FND_MSG_PUB.Count_And_Get
1746: ( p_count => x_msg_count
1747: , p_data => x_msg_data
1748: ,p_encoded => FND_API.G_FALSE
1749: );
1750:
1751: IF l_debug_on THEN
1752: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||