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

Line 14: -- p_validation_level to fnd_api.g_valid_level_none when making the procedure call. However, it is your

10: -- klou 01/28/00 Created.
11: --
12: -- NOTES: If validations have been done in the precedent procedure from which this one is being called, doing a
13: -- full validation here is unnecessary. To avoid repeating the same validations, you can set the
14: -- p_validation_level to fnd_api.g_valid_level_none when making the procedure call. However, it is your
15: -- responsibility to make sure all proper validations have been done before calling this procedure.
16: -- You are recommended to let this procedure handle the validations if you are not sure.
17: --
18: -- NOTES: This procedure does not consider the fnd_api.g_miss_num and fnd_api.g_miss_char.

Line 18: -- NOTES: This procedure does not consider the fnd_api.g_miss_num and fnd_api.g_miss_char.

14: -- p_validation_level to fnd_api.g_valid_level_none when making the procedure call. However, it is your
15: -- responsibility to make sure all proper validations have been done before calling this procedure.
16: -- You are recommended to let this procedure handle the validations if you are not sure.
17: --
18: -- NOTES: This procedure does not consider the fnd_api.g_miss_num and fnd_api.g_miss_char.
19: --
20: -- CAUTIONS: This procedure *ALWAYS* calls other procedures with validation_level set to FND_API.G_VALID_LEVEL_NONE.
21: -- If you do not do your own validations before calling this procedure, you should set the p_validation_level
22: -- to FND_API.G_VALID_LEVEL_FULL when making the call.

Line 20: -- CAUTIONS: This procedure ALWAYS calls other procedures with validation_level set to FND_API.G_VALID_LEVEL_NONE.

16: -- You are recommended to let this procedure handle the validations if you are not sure.
17: --
18: -- NOTES: This procedure does not consider the fnd_api.g_miss_num and fnd_api.g_miss_char.
19: --
20: -- CAUTIONS: This procedure *ALWAYS* calls other procedures with validation_level set to FND_API.G_VALID_LEVEL_NONE.
21: -- If you do not do your own validations before calling this procedure, you should set the p_validation_level
22: -- to FND_API.G_VALID_LEVEL_FULL when making the call.
23: --
24: -- End of Comments

Line 22: -- to FND_API.G_VALID_LEVEL_FULL when making the call.

18: -- NOTES: This procedure does not consider the fnd_api.g_miss_num and fnd_api.g_miss_char.
19: --
20: -- CAUTIONS: This procedure *ALWAYS* calls other procedures with validation_level set to FND_API.G_VALID_LEVEL_NONE.
21: -- If you do not do your own validations before calling this procedure, you should set the p_validation_level
22: -- to FND_API.G_VALID_LEVEL_FULL when making the call.
23: --
24: -- End of Comments
25:
26: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_Pick_SL_Util';

Line 33: P_Init_Msg_List IN VARCHAR2 := FND_API.G_TRUE,

29: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
30:
31: PROCEDURE Validate_And_Write (
32: P_Api_Version_Number IN NUMBER,
33: P_Init_Msg_List IN VARCHAR2 := FND_API.G_TRUE,
34: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
35: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36: p_action_code IN NUMBER,
37: px_PICKLIST_SERIAL_LOT_ID IN OUT NOCOPY NUMBER,

Line 34: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

30:
31: PROCEDURE Validate_And_Write (
32: P_Api_Version_Number IN NUMBER,
33: P_Init_Msg_List IN VARCHAR2 := FND_API.G_TRUE,
34: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
35: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36: p_action_code IN NUMBER,
37: px_PICKLIST_SERIAL_LOT_ID IN OUT NOCOPY NUMBER,
38: p_CREATED_BY IN NUMBER,

Line 35: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

31: PROCEDURE Validate_And_Write (
32: P_Api_Version_Number IN NUMBER,
33: P_Init_Msg_List IN VARCHAR2 := FND_API.G_TRUE,
34: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
35: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36: p_action_code IN NUMBER,
37: px_PICKLIST_SERIAL_LOT_ID IN OUT NOCOPY NUMBER,
38: p_CREATED_BY IN NUMBER,
39: p_CREATION_DATE IN DATE,

Line 61: l_commit VARCHAR2(1) := FND_API.G_FALSE;

57: l_msg_data VARCHAR2(300);
58: l_check_existence NUMBER := 0;
59: l_return_status VARCHAR2(1);
60: l_msg_count NUMBER := 0;
61: l_commit VARCHAR2(1) := FND_API.G_FALSE;
62: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
63: EXCP_USER_DEFINED EXCEPTION;
64:
65: -- customers declarations

Line 62: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;

58: l_check_existence NUMBER := 0;
59: l_return_status VARCHAR2(1);
60: l_msg_count NUMBER := 0;
61: l_commit VARCHAR2(1) := FND_API.G_FALSE;
62: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
63: EXCP_USER_DEFINED EXCEPTION;
64:
65: -- customers declarations
66: l_picklist_Serial_Lot_ID NUMBER := NULL;

Line 71: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

67: l_psl_rec csp_pick_serial_lots_PVT.psl_Rec_Type;
68:
69: BEGIN
70: SAVEPOINT Validate_And_Write_PUB;
71: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
72: -- initialize message list
73: FND_MSG_PUB.initialize;
74: END IF;
75:

Line 77: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

73: FND_MSG_PUB.initialize;
74: END IF;
75:
76: -- Standard call to check for call compatibility.
77: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
78: p_api_version_number,
79: l_api_name,
80: G_PKG_NAME)
81: THEN

Line 82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

78: p_api_version_number,
79: l_api_name,
80: G_PKG_NAME)
81: THEN
82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
83: END IF;
84:
85: -- validate p_organization_id
86: IF p_organization_id IS NULL THEN

Line 92: IF p_validation_level = fnd_api.g_valid_level_full THEN

88: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
89: FND_MSG_PUB.ADD;
90: RAISE EXCP_USER_DEFINED;
91: ELSE
92: IF p_validation_level = fnd_api.g_valid_level_full THEN
93: BEGIN
94: select organization_id into l_check_existence
95: from mtl_parameters
96: where organization_id = p_organization_id;

Line 116: IF p_validation_level = fnd_api.g_valid_level_full THEN

112: END IF;
113:
114:
115: IF p_action_code IN (0, 1) THEN
116: IF p_validation_level = fnd_api.g_valid_level_full THEN
117: -- valide packlist_line_id
118: IF p_picklist_line_id IS NULL THEN
119: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
120: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_packlist_line_id', TRUE);

Line 252: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

248: fnd_msg_pub.add;
249: RAISE EXCP_USER_DEFINED;
250: END IF;
251:
252: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
253: RAISE FND_API.G_EXC_ERROR;
254: ELSE
255: x_return_status := fnd_api.g_ret_sts_success;
256: px_PICKLIST_SERIAL_LOT_ID := l_picklist_serial_lot_id;

Line 253: RAISE FND_API.G_EXC_ERROR;

249: RAISE EXCP_USER_DEFINED;
250: END IF;
251:
252: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
253: RAISE FND_API.G_EXC_ERROR;
254: ELSE
255: x_return_status := fnd_api.g_ret_sts_success;
256: px_PICKLIST_SERIAL_LOT_ID := l_picklist_serial_lot_id;
257: IF fnd_api.to_boolean(p_commit) THEN

Line 255: x_return_status := fnd_api.g_ret_sts_success;

251:
252: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
253: RAISE FND_API.G_EXC_ERROR;
254: ELSE
255: x_return_status := fnd_api.g_ret_sts_success;
256: px_PICKLIST_SERIAL_LOT_ID := l_picklist_serial_lot_id;
257: IF fnd_api.to_boolean(p_commit) THEN
258: commit work;
259: END IF;

Line 257: IF fnd_api.to_boolean(p_commit) THEN

253: RAISE FND_API.G_EXC_ERROR;
254: ELSE
255: x_return_status := fnd_api.g_ret_sts_success;
256: px_PICKLIST_SERIAL_LOT_ID := l_picklist_serial_lot_id;
257: IF fnd_api.to_boolean(p_commit) THEN
258: commit work;
259: END IF;
260: END IF;
261: EXCEPTION

Line 263: x_return_status := FND_API.G_RET_STS_ERROR;

259: END IF;
260: END IF;
261: EXCEPTION
262: WHEN EXCP_USER_DEFINED THEN
263: x_return_status := FND_API.G_RET_STS_ERROR;
264: fnd_msg_pub.count_and_get
265: ( p_count => x_msg_count
266: , p_data => x_msg_data);
267:

Line 271: WHEN FND_API.G_EXC_ERROR THEN

267:
268: --for debugging purpose
269: -- x_msg_data := l_msg_data;
270:
271: WHEN FND_API.G_EXC_ERROR THEN
272: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
273: P_API_NAME => L_API_NAME
274: ,P_PKG_NAME => G_PKG_NAME
275: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

277: ,X_MSG_COUNT => X_MSG_COUNT
278: ,X_MSG_DATA => X_MSG_DATA
279: ,X_RETURN_STATUS => X_RETURN_STATUS);
280:
281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
282: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
283: P_API_NAME => L_API_NAME
284: ,P_PKG_NAME => G_PKG_NAME
285: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR