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

Line 16: , p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

12: G_FILE_NAME CONSTANT VARCHAR2(30) := 'cspvppob.pls';
13:
14: PROCEDURE create_orders
15: ( p_api_version IN NUMBER
16: , p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
17: , p_commit IN VARCHAR2 := FND_API.G_FALSE
18: , p_organization_id NUMBER
19: , p_inventory_item_id NUMBER
20: , px_line_tbl CSP_PLANNED_ORDERS.Line_Tbl_Type

Line 17: , p_commit IN VARCHAR2 := FND_API.G_FALSE

13:
14: PROCEDURE create_orders
15: ( p_api_version IN NUMBER
16: , p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
17: , p_commit IN VARCHAR2 := FND_API.G_FALSE
18: , p_organization_id NUMBER
19: , p_inventory_item_id NUMBER
20: , px_line_tbl CSP_PLANNED_ORDERS.Line_Tbl_Type
21: , x_return_status OUT NOCOPY VARCHAR2

Line 27: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

23: , x_msg_data OUT NOCOPY VARCHAR2)
24: IS
25: l_api_version_number CONSTANT NUMBER := 1.0;
26: l_api_name CONSTANT VARCHAR2(30) := 'create_orders';
27: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
28: l_msg_count NUMBER;
29: l_msg_data VARCHAR2(2000);
30: l_line_tbl csp_planned_orders.line_tbl_type;
31: l_order_line_tbl csp_parts_requirement.line_tbl_type;

Line 112: x_return_status := FND_API.G_RET_STS_SUCCESS;

108:
109: BEGIN
110: SAVEPOINT Create_Orders_PUB;
111: -- initialize return status
112: x_return_status := FND_API.G_RET_STS_SUCCESS;
113: SELECT fnd_global.user_id INTO l_user_id from dual;
114:
115: l_line_tbl := px_line_tbl;
116: -- get ship to of warehouse

Line 234: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

230: x_return_status => l_return_status,
231: x_msg_count => l_msg_count,
232: x_msg_data => l_msg_data
233: );
234: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
235: RAISE FND_API.G_EXC_ERROR;
236: END If;
237: ELSE
238: begin

Line 235: RAISE FND_API.G_EXC_ERROR;

231: x_msg_count => l_msg_count,
232: x_msg_data => l_msg_data
233: );
234: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
235: RAISE FND_API.G_EXC_ERROR;
236: END If;
237: ELSE
238: begin
239: Select organization_id

Line 263: ,p_commit => FND_API.G_FALSE

259: l_Defective_parts_tbl(1).defective_quantity := l_line_tbl(I).quantity;
260: CSP_REPAIR_PO_GRP.CREATE_REPAIR_PO
261: (p_api_version => 1.0
262: ,p_Init_Msg_List => null
263: ,p_commit => FND_API.G_FALSE
264: ,P_repair_supplier_id => l_repair_supplier_id
265: ,P_repair_supplier_org_id => l_repair_supplier_org_id
266: ,P_repair_program => l_repair_program
267: ,P_dest_organization_id => p_organization_id

Line 278: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

274: ,x_return_status => l_Return_status
275: ,x_msg_count => l_msg_count
276: ,x_msg_data => l_msg_data
277: );
278: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
279: RAISE FND_API.G_EXC_ERROR;
280: END If;
281: ELSE
282: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIR_SUPPLIER_ORG');

Line 279: RAISE FND_API.G_EXC_ERROR;

275: ,x_msg_count => l_msg_count
276: ,x_msg_data => l_msg_data
277: );
278: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
279: RAISE FND_API.G_EXC_ERROR;
280: END If;
281: ELSE
282: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIR_SUPPLIER_ORG');
283: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_NAME', to_char(null), TRUE);

Line 397: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

393: ,x_return_status => l_return_status
394: ,x_msg_count => l_msg_count
395: ,x_msg_data => l_msg_data
396: );
397: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
398: RAISE FND_API.G_EXC_ERROR;
399: END IF;
400: END IF;
401:

Line 398: RAISE FND_API.G_EXC_ERROR;

394: ,x_msg_count => l_msg_count
395: ,x_msg_data => l_msg_data
396: );
397: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
398: RAISE FND_API.G_EXC_ERROR;
399: END IF;
400: END IF;
401:
402: IF (l_po_line_tbl.COUNT > 0) THEN

Line 414: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

410: ,x_msg_count => l_msg_count
411: ,x_msg_data => l_msg_data
412: );
413:
414: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
415: RAISE FND_API.G_EXC_ERROR;
416: END IF;
417: END IF;
418:

Line 415: RAISE FND_API.G_EXC_ERROR;

411: ,x_msg_data => l_msg_data
412: );
413:
414: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
415: RAISE FND_API.G_EXC_ERROR;
416: END IF;
417: END IF;
418:
419: COMMIT;

Line 421: WHEN FND_API.G_EXC_ERROR THEN

417: END IF;
418:
419: COMMIT;
420: EXCEPTION
421: WHEN FND_API.G_EXC_ERROR THEN
422: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
423: P_API_NAME => L_API_NAME
424: ,P_PKG_NAME => G_PKG_NAME
425: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

426: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
427: ,X_MSG_COUNT => X_MSG_COUNT
428: ,X_MSG_DATA => X_MSG_DATA
429: ,X_RETURN_STATUS => X_RETURN_STATUS);
430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
431: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
432: P_API_NAME => L_API_NAME
433: ,P_PKG_NAME => G_PKG_NAME
434: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 448: x_return_status := FND_API.G_RET_STS_ERROR;

444: FND_MSG_PUB.ADD;
445: fnd_msg_pub.count_and_get
446: ( p_count => x_msg_count
447: , p_data => x_msg_data);
448: x_return_status := FND_API.G_RET_STS_ERROR;
449:
450: END;
451: END;