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

Line 23: g_ret_success varchar2(1) := FND_API.G_RET_STS_SUCCESS;

19: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
20: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
21: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
22:
23: g_ret_success varchar2(1) := FND_API.G_RET_STS_SUCCESS;
24: g_ret_error varchar2(1) := FND_API.G_RET_STS_ERROR;
25: g_ret_unexpected varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
26:
27: PROCEDURE get_available_supply_demand (

Line 24: g_ret_error varchar2(1) := FND_API.G_RET_STS_ERROR;

20: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
21: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
22:
23: g_ret_success varchar2(1) := FND_API.G_RET_STS_SUCCESS;
24: g_ret_error varchar2(1) := FND_API.G_RET_STS_ERROR;
25: g_ret_unexpected varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
26:
27: PROCEDURE get_available_supply_demand (
28: x_return_status OUT NOCOPY VARCHAR2 ,

Line 25: g_ret_unexpected varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

21: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
22:
23: g_ret_success varchar2(1) := FND_API.G_RET_STS_SUCCESS;
24: g_ret_error varchar2(1) := FND_API.G_RET_STS_ERROR;
25: g_ret_unexpected varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
26:
27: PROCEDURE get_available_supply_demand (
28: x_return_status OUT NOCOPY VARCHAR2 ,
29: x_msg_count OUT NOCOPY NUMBER ,

Line 49: p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

45: p_lpn_id IN NUMBER ,
46: p_project_id IN NUMBER default null ,
47: p_task_id IN NUMBER default null ,
48: p_api_version_number IN NUMBER default 1.0 ,
49: p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
50: )
51:
52: IS
53: /* API version stored locally */

Line 68: x_return_status := FND_API.G_RET_STS_SUCCESS;

64: l_item_id wip_discrete_jobs.primary_item_id%TYPE; --bug 4633035
65:
66: BEGIN
67:
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70: l_stmt_num := 10;
71: /* Initialize message list if p_init_msg_list is set to TRUE. */
72: IF FND_API.to_Boolean( p_init_msg_lst ) THEN

Line 72: IF FND_API.to_Boolean( p_init_msg_lst ) THEN

68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70: l_stmt_num := 10;
71: /* Initialize message list if p_init_msg_list is set to TRUE. */
72: IF FND_API.to_Boolean( p_init_msg_lst ) THEN
73: FND_MSG_PUB.initialize;
74: /* Message list enabled....-- EVENT */
75: --logging
76: end if;

Line 80: IF NOT FND_API.Compatible_API_Call( l_api_version,

76: end if;
77:
78: l_stmt_num := 20;
79: /* Check for the API compatibilty */
80: IF NOT FND_API.Compatible_API_Call( l_api_version,
81: p_api_version_number,
82: g_pkg_name,
83: l_api_name
84: )

Line 88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

84: )
85: THEN
86: --logging here...
87: /* Incompatible versions...*/
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90:
91: l_stmt_num := 30;
92: SELECT WDJ.NET_QUANTITY,WDJ.PRIMARY_ITEM_ID

Line 106: x_return_status := FND_API.G_RET_STS_SUCCESS;

102: and organization_id=p_organization_id;
103:
104: x_source_uom_code := x_source_primary_uom_code;
105:
106: x_return_status := FND_API.G_RET_STS_SUCCESS;
107:
108: EXCEPTION
109: when no_data_found then
110: x_return_status := fnd_api.g_ret_sts_error;

Line 110: x_return_status := fnd_api.g_ret_sts_error;

106: x_return_status := FND_API.G_RET_STS_SUCCESS;
107:
108: EXCEPTION
109: when no_data_found then
110: x_return_status := fnd_api.g_ret_sts_error;
111: x_msg_data := 'No job with the given wip_entity_id found';
112: WHEN FND_API.G_EXC_ERROR THEN
113: x_return_status := G_RET_ERROR ;
114:

Line 112: WHEN FND_API.G_EXC_ERROR THEN

108: EXCEPTION
109: when no_data_found then
110: x_return_status := fnd_api.g_ret_sts_error;
111: x_msg_data := 'No job with the given wip_entity_id found';
112: WHEN FND_API.G_EXC_ERROR THEN
113: x_return_status := G_RET_ERROR ;
114:
115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
116: x_return_status := G_RET_UNEXPECTED ;

Line 115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

111: x_msg_data := 'No job with the given wip_entity_id found';
112: WHEN FND_API.G_EXC_ERROR THEN
113: x_return_status := G_RET_ERROR ;
114:
115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
116: x_return_status := G_RET_UNEXPECTED ;
117: x_msg_data := SUBSTR('WSM_RESERVATIONS_GRP.validate_supply_demand: Unexpected error: '||SQLERRM, 1, 500);
118:
119: WHEN OTHERS THEN

Line 121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

117: x_msg_data := SUBSTR('WSM_RESERVATIONS_GRP.validate_supply_demand: Unexpected error: '||SQLERRM, 1, 500);
118:
119: WHEN OTHERS THEN
120: /* handle it... */
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
122: x_msg_data := SUBSTR('WSM_RESERVATIONS_GRP.get_available_supply_demand: Unexpexted error: '||SQLERRM, 1, 500);
123:
124: END;
125:

Line 141: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

137: , p_supply_demand_line_detail IN NUMBER
138: , p_demand_ship_date IN DATE
139: , p_expected_receipt_date IN DATE
140: , p_api_version_number IN NUMBER default 1.0
141: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
142: )
143: IS
144:
145: l_scheduled_completion_date DATE;

Line 163: x_return_status := FND_API.G_RET_STS_SUCCESS;

159: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
160:
161: BEGIN
162:
163: x_return_status := FND_API.G_RET_STS_SUCCESS;
164:
165: l_stmt_num := 10;
166: /* Initialize message list if p_init_msg_list is set to TRUE. */
167: IF FND_API.to_Boolean( p_init_msg_lst ) THEN

Line 167: IF FND_API.to_Boolean( p_init_msg_lst ) THEN

163: x_return_status := FND_API.G_RET_STS_SUCCESS;
164:
165: l_stmt_num := 10;
166: /* Initialize message list if p_init_msg_list is set to TRUE. */
167: IF FND_API.to_Boolean( p_init_msg_lst ) THEN
168: FND_MSG_PUB.initialize;
169: /* Message list enabled....-- EVENT */
170: --logging
171: end if;

Line 175: IF NOT FND_API.Compatible_API_Call( l_api_version,

171: end if;
172:
173: l_stmt_num := 20;
174: /* Check for the API compatibilty */
175: IF NOT FND_API.Compatible_API_Call( l_api_version,
176: p_api_version_number,
177: g_pkg_name,
178: l_api_name
179: )

Line 183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

179: )
180: THEN
181: --logging here...
182: /* Incompatible versions...*/
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: END IF;
185:
186: l_stmt_num := 30;
187: select

Line 250: x_return_status := FND_API.G_RET_STS_SUCCESS;

246: );
247: END IF;
248: end if;
249:
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251:
252: EXCEPTION
253: WHEN NO_DATA_FOUND THEN
254: x_return_status := G_RET_ERROR;

Line 256: WHEN FND_API.G_EXC_ERROR THEN

252: EXCEPTION
253: WHEN NO_DATA_FOUND THEN
254: x_return_status := G_RET_ERROR;
255:
256: WHEN FND_API.G_EXC_ERROR THEN
257: x_return_status := G_RET_ERROR ;
258:
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: x_return_status := G_RET_UNEXPECTED ;

Line 259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

255:
256: WHEN FND_API.G_EXC_ERROR THEN
257: x_return_status := G_RET_ERROR ;
258:
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: x_return_status := G_RET_UNEXPECTED ;
261: x_msg_data := SUBSTR('WSM_RESERVATIONS_GRP.validate_supply_demand: Unexpected error: '||SQLERRM, 1, 500);
262: WHEN OTHERS THEN
263: /* handle it... */