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

Line 117: x_return_status := fnd_api.g_ret_sts_success;

113:
114: -- This is the fetch loop
115: x_status_data_count := 0;
116: i := 0;
117: x_return_status := fnd_api.g_ret_sts_success;
118: LOOP
119: -- Fetch the rows into the buffer, and also check for the exit
120: -- condition from the loop.
121: IF DBMS_SQL.FETCH_ROWS(l_CursorID) = 0 THEN

Line 160: WHEN FND_API.G_EXC_ERROR THEN

156: END LOOP;
157: END IF;
158:
159: EXCEPTION
160: WHEN FND_API.G_EXC_ERROR THEN
161: x_return_status := FND_API.G_RET_STS_ERROR;
162: -- Close the cursor.
163: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
164:

Line 161: x_return_status := FND_API.G_RET_STS_ERROR;

157: END IF;
158:
159: EXCEPTION
160: WHEN FND_API.G_EXC_ERROR THEN
161: x_return_status := FND_API.G_RET_STS_ERROR;
162: -- Close the cursor.
163: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
164:
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

161: x_return_status := FND_API.G_RET_STS_ERROR;
162: -- Close the cursor.
163: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
164:
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: -- Close the cursor.
168: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
169:

Line 166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

162: -- Close the cursor.
163: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
164:
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: -- Close the cursor.
168: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
169:
170: WHEN OTHERS THEN

Line 171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

167: -- Close the cursor.
168: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
169:
170: WHEN OTHERS THEN
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: IF (FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
173: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, c_api_name);
174: END IF;
175: -- Close the cursor.

Line 329: x_return_status := fnd_api.g_ret_sts_success;

325: l_loop_index := l_task_count_table.NEXT(l_loop_index);
326: END LOOP;
327: END IF;
328:
329: x_return_status := fnd_api.g_ret_sts_success;
330:
331: EXCEPTION
332: WHEN FND_API.G_EXC_ERROR THEN
333: x_return_status := FND_API.G_RET_STS_ERROR;

Line 332: WHEN FND_API.G_EXC_ERROR THEN

328:
329: x_return_status := fnd_api.g_ret_sts_success;
330:
331: EXCEPTION
332: WHEN FND_API.G_EXC_ERROR THEN
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: -- Close the cursor.
335: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
336:

Line 333: x_return_status := FND_API.G_RET_STS_ERROR;

329: x_return_status := fnd_api.g_ret_sts_success;
330:
331: EXCEPTION
332: WHEN FND_API.G_EXC_ERROR THEN
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: -- Close the cursor.
335: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
336:
337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

333: x_return_status := FND_API.G_RET_STS_ERROR;
334: -- Close the cursor.
335: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
336:
337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: -- Close the cursor.
340: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
341:

Line 338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

334: -- Close the cursor.
335: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
336:
337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: -- Close the cursor.
340: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
341:
342: WHEN OTHERS THEN

Line 343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

339: -- Close the cursor.
340: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
341:
342: WHEN OTHERS THEN
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: IF (FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
345: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, c_api_name);
346: END IF;
347: -- Close the cursor.

Line 876: x_return_status := fnd_api.g_ret_sts_success;

872:
873:
874: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
875: BEGIN
876: x_return_status := fnd_api.g_ret_sts_success;
877: x_task_id := p_task_id;
878:
879: --dbms_output.put_line('in task_mani');
880:

Line 897: RAISE fnd_api.g_exc_error;

893: fnd_message.set_name('WMS', 'WMS_TASK_STATUS_CHG_NOTALLOWED');
894: fnd_message.set_token('FROM_STATUS', from_status_code);
895: fnd_message.set_token('TO_STATUS', to_status_code);
896: fnd_msg_pub.add;
897: RAISE fnd_api.g_exc_error;
898: END IF;
899:
900: --dbms_output.put_line('pass validate');
901:

Line 1132: WHEN fnd_api.g_exc_error THEN

1128: END IF;
1129: END IF;
1130:
1131: EXCEPTION
1132: WHEN fnd_api.g_exc_error THEN
1133: x_return_status := fnd_api.g_ret_sts_error ;
1134: inv_rsv_trigger_global.g_from_trigger := FALSE;
1135:
1136: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1133: x_return_status := fnd_api.g_ret_sts_error ;

1129: END IF;
1130:
1131: EXCEPTION
1132: WHEN fnd_api.g_exc_error THEN
1133: x_return_status := fnd_api.g_ret_sts_error ;
1134: inv_rsv_trigger_global.g_from_trigger := FALSE;
1135:
1136: WHEN fnd_api.g_exc_unexpected_error THEN
1137: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1136: WHEN fnd_api.g_exc_unexpected_error THEN

1132: WHEN fnd_api.g_exc_error THEN
1133: x_return_status := fnd_api.g_ret_sts_error ;
1134: inv_rsv_trigger_global.g_from_trigger := FALSE;
1135:
1136: WHEN fnd_api.g_exc_unexpected_error THEN
1137: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1138: inv_rsv_trigger_global.g_from_trigger := FALSE;
1139:
1140: WHEN OTHERS THEN

Line 1137: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1133: x_return_status := fnd_api.g_ret_sts_error ;
1134: inv_rsv_trigger_global.g_from_trigger := FALSE;
1135:
1136: WHEN fnd_api.g_exc_unexpected_error THEN
1137: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1138: inv_rsv_trigger_global.g_from_trigger := FALSE;
1139:
1140: WHEN OTHERS THEN
1141: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1141: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1137: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1138: inv_rsv_trigger_global.g_from_trigger := FALSE;
1139:
1140: WHEN OTHERS THEN
1141: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1142: inv_rsv_trigger_global.g_from_trigger := FALSE;
1143:
1144: IF (fnd_msg_pub.check_msg_level
1145: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN