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

Line 41: IF (p_value = fnd_api.g_miss_num) THEN

37: */
38:
39: l_value := p_value;
40: IF (nvl(p_entity,'$$') = 'DLVB' and nvl(p_action,'$$')= 'CREATE') THEN
41: IF (p_value = fnd_api.g_miss_num) THEN
42: l_value := NULL;
43: END IF;
44: ELSE
45: IF (p_value = fnd_api.g_miss_num) THEN

Line 45: IF (p_value = fnd_api.g_miss_num) THEN

41: IF (p_value = fnd_api.g_miss_num) THEN
42: l_value := NULL;
43: END IF;
44: ELSE
45: IF (p_value = fnd_api.g_miss_num) THEN
46: l_value := NULL;
47: ELSIF (p_value IS NULL) THEN
48: l_value := fnd_api.g_miss_num;
49: END IF;

Line 48: l_value := fnd_api.g_miss_num;

44: ELSE
45: IF (p_value = fnd_api.g_miss_num) THEN
46: l_value := NULL;
47: ELSIF (p_value IS NULL) THEN
48: l_value := fnd_api.g_miss_num;
49: END IF;
50: END IF;
51:
52: /*

Line 95: IF (p_value = fnd_api.g_miss_char) THEN

91: */
92:
93: l_value := p_value;
94: IF (nvl(p_entity,'$$') = 'DLVB' and nvl(p_action,'$$')='CREATE') THEN
95: IF (p_value = fnd_api.g_miss_char) THEN
96: l_value := NULL;
97: END IF;
98: ELSE
99: IF (p_value = fnd_api.g_miss_char) THEN

Line 99: IF (p_value = fnd_api.g_miss_char) THEN

95: IF (p_value = fnd_api.g_miss_char) THEN
96: l_value := NULL;
97: END IF;
98: ELSE
99: IF (p_value = fnd_api.g_miss_char) THEN
100: l_value := NULL;
101: ELSIF (p_value IS NULL) THEN
102: l_value := fnd_api.g_miss_char;
103: END IF;

Line 102: l_value := fnd_api.g_miss_char;

98: ELSE
99: IF (p_value = fnd_api.g_miss_char) THEN
100: l_value := NULL;
101: ELSIF (p_value IS NULL) THEN
102: l_value := fnd_api.g_miss_char;
103: END IF;
104: END IF;
105: /*
106: IF l_debug_on THEN

Line 148: IF (p_value = fnd_api.g_miss_date) THEN

144: */
145:
146: l_value := p_value;
147: IF (nvl(p_entity,'$$') = 'DLVB' and nvl(p_action,'$$')='CREATE') THEN
148: IF (p_value = fnd_api.g_miss_date) THEN
149: l_value := NULL;
150: END IF;
151: ELSE
152: IF (p_value = fnd_api.g_miss_date) THEN

Line 152: IF (p_value = fnd_api.g_miss_date) THEN

148: IF (p_value = fnd_api.g_miss_date) THEN
149: l_value := NULL;
150: END IF;
151: ELSE
152: IF (p_value = fnd_api.g_miss_date) THEN
153: l_value := NULL;
154: ELSIF (p_value IS NULL) THEN
155: l_value := fnd_api.g_miss_date;
156: END IF;

Line 155: l_value := fnd_api.g_miss_date;

151: ELSE
152: IF (p_value = fnd_api.g_miss_date) THEN
153: l_value := NULL;
154: ELSIF (p_value IS NULL) THEN
155: l_value := fnd_api.g_miss_date;
156: END IF;
157: END IF;
158:
159: /*

Line 244: -- p_init_msg_list FND_API.G_TRUE to reset list

240: --========================================================================
241: -- PROCEDURE : Delivery_Action Wrapper API PUBLIC
242: --
243: -- PARAMETERS: p_api_version_number known api version error number
244: -- p_init_msg_list FND_API.G_TRUE to reset list
245: -- x_return_status return status
246: -- x_msg_count number of messages in the list
247: -- x_msg_data text of messages
248: -- p_action_prms Record of caller, phase, action_code and other

Line 261: p_commit IN VARCHAR2 , -- default fnd_api.g_false

257: --========================================================================
258: PROCEDURE Delivery_Action
259: ( p_api_version_number IN NUMBER,
260: p_init_msg_list IN VARCHAR2,
261: p_commit IN VARCHAR2 , -- default fnd_api.g_false
262: p_action_prms IN WSH_INTERFACE_EXT_GRP.del_action_parameters_rectype,
263: p_delivery_id_tab IN wsh_util_core.id_tab_type,
264: x_delivery_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.Del_Action_Out_Rec_Type,
265: x_return_status OUT NOCOPY VARCHAR2,

Line 282: p_commit => p_commit , -- default fnd_api.g_false

278:
279: WSH_INTERFACE_GRP.Delivery_Action
280: ( p_api_version_number => p_api_version_number,
281: p_init_msg_list => p_init_msg_list,
282: p_commit => p_commit , -- default fnd_api.g_false
283: p_action_prms => l_del_act_params_rectype,
284: p_delivery_id_tab => p_delivery_id_tab,
285: x_delivery_out_rec => l_Del_Act_Out_Rec_Type,
286: x_return_status => x_return_status,

Line 490: -- p_init_msg_list FND_API.G_TRUE to reset list

486: --========================================================================
487: -- PROCEDURE : Create_Update_Delivery Wrapper API PUBLIC
488: --
489: -- PARAMETERS: p_api_version_number known api version error buffer
490: -- p_init_msg_list FND_API.G_TRUE to reset list
491: -- x_return_status return status
492: -- x_msg_count number of messages in the list
493: -- x_msg_data text of messages
494: -- p_in_rec Record for caller, phase

Line 506: p_commit IN VARCHAR2 , -- default fnd_api.g_false

502: --========================================================================
503: PROCEDURE Create_Update_Delivery
504: ( p_api_version_number IN NUMBER,
505: p_init_msg_list IN VARCHAR2,
506: p_commit IN VARCHAR2 , -- default fnd_api.g_false
507: p_in_rec IN WSH_INTERFACE_EXT_GRP.Del_In_Rec_Type,
508: p_rec_attr_tab IN WSH_INTERFACE_EXT_GRP.Delivery_Attr_Tbl_Type,
509: x_del_out_rec_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.Del_Out_Tbl_Type,
510: x_return_status OUT NOCOPY VARCHAR2,

Line 529: p_commit => p_commit , -- default fnd_api.g_false

525: --
526: WSH_INTERFACE_GRP.Create_Update_Delivery(
527: p_api_version_number => p_api_version_number,
528: p_init_msg_list => p_init_msg_list,
529: p_commit => p_commit , -- default fnd_api.g_false
530: p_in_rec => l_Del_In_Rec_Type,
531: p_rec_attr_tab => l_Del_Attr_Tbl_Type,
532: x_del_out_rec_tab => l_Del_Out_Tbl_Type,
533: x_return_status => x_return_status,

Line 654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

650: --
651: WHEN OTHERS THEN
652: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_EXT_GRP.Delivery_Detail_Action');
653: ROLLBACK TO DEL_DETAIL_ACTION_WRAP_GRP;
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: --
656: END Delivery_Detail_Action;
657:
658:

Line 908: --bug # 6689448 (replenishment project): Valid values for replenishment flag are FND_API.G_MISS_CHAR/NULL/R/C only.

904: l_detailOutRecType wsh_glbl_var_strct_grp.detailOutRecType;
905:
906: BEGIN
907:
908: --bug # 6689448 (replenishment project): Valid values for replenishment flag are FND_API.G_MISS_CHAR/NULL/R/C only.
909: FOR i IN 1..p_detail_info_tab.COUNT LOOP
910: --{
911: IF ( (p_detail_info_tab(i).replenishment_status <> FND_API.G_MISS_CHAR)
912: AND (p_detail_info_tab(i).replenishment_status IS NOT NULL)

Line 911: IF ( (p_detail_info_tab(i).replenishment_status <> FND_API.G_MISS_CHAR)

907:
908: --bug # 6689448 (replenishment project): Valid values for replenishment flag are FND_API.G_MISS_CHAR/NULL/R/C only.
909: FOR i IN 1..p_detail_info_tab.COUNT LOOP
910: --{
911: IF ( (p_detail_info_tab(i).replenishment_status <> FND_API.G_MISS_CHAR)
912: AND (p_detail_info_tab(i).replenishment_status IS NOT NULL)
913: AND (p_detail_info_tab(i).replenishment_status <> 'R')
914: AND (p_detail_info_tab(i).replenishment_status <> 'C') )THEN
915: --{

Line 951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

947: --
948: EXCEPTION
949: WHEN OTHERS THEN
950: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail');
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
952: END Create_Update_Delivery_Detail;
953:
954:
955: Procedure Map_trip_act_params_rectype(

Line 1242: -- p_init_msg_list FND_API.G_TRUE to reset list

1238: --========================================================================
1239: -- PROCEDURE : Create_Update_Stop Wrapper API
1240: --
1241: -- PARAMETERS: p_api_version_number known api versionerror buffer
1242: -- p_init_msg_list FND_API.G_TRUE to reset list
1243: -- p_commit 'T'/'F'
1244: -- p_in_rec stopInRecType
1245: -- p_rec_attr_tab Table of Attributes for the stop entity
1246: -- p_stop_OUT_tab Table of Output Attributes for the stop entity

Line 1403: -- p_init_msg_list FND_API.G_TRUE to reset list

1399: --========================================================================
1400: -- PROCEDURE : Create_Update_Trip Wrapper API
1401: --
1402: -- PARAMETERS: p_api_version_number known api versionerror buffer
1403: -- p_init_msg_list FND_API.G_TRUE to reset list
1404: -- x_return_status return status
1405: -- x_msg_count number of messages in the list
1406: -- x_msg_data text of messages
1407: -- p_trip_info_tab Table of Attributes for the trip entity

Line 1592: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1588:
1589: PROCEDURE Get_Exceptions (
1590: -- Standard parameters
1591: p_api_version IN NUMBER,
1592: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1593: x_return_status OUT NOCOPY VARCHAR2,
1594: x_msg_count OUT NOCOPY NUMBER,
1595: x_msg_data OUT NOCOPY VARCHAR2,
1596:

Line 1620: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1616:
1617:
1618: PROCEDURE Exception_Action (
1619: p_api_version IN NUMBER,
1620: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1621: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1622: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1623: x_msg_count OUT NOCOPY NUMBER,
1624: x_msg_data OUT NOCOPY VARCHAR2,

Line 1621: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

1617:
1618: PROCEDURE Exception_Action (
1619: p_api_version IN NUMBER,
1620: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1621: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1622: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1623: x_msg_count OUT NOCOPY NUMBER,
1624: x_msg_data OUT NOCOPY VARCHAR2,
1625: x_return_status OUT NOCOPY VARCHAR2,

Line 1622: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1618: PROCEDURE Exception_Action (
1619: p_api_version IN NUMBER,
1620: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1621: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1622: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1623: x_msg_count OUT NOCOPY NUMBER,
1624: x_msg_data OUT NOCOPY VARCHAR2,
1625: x_return_status OUT NOCOPY VARCHAR2,
1626: