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_MSG_PUB

Line 73: FND_MSG_PUB.initialize;

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:
76: -- Standard call to check for call compatibility.
77: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 89: FND_MSG_PUB.ADD;

85: -- validate p_organization_id
86: IF p_organization_id IS NULL THEN
87: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
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

Line 100: FND_MSG_PUB.ADD;

96: where organization_id = p_organization_id;
97: EXCEPTION
98: WHEN NO_DATA_FOUND THEN
99: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
100: FND_MSG_PUB.ADD;
101: RAISE EXCP_USER_DEFINED;
102: WHEN OTHERS THEN
103: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
104: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);

Line 107: FND_MSG_PUB.ADD;

103: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
104: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
105: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
106: fnd_message.set_token('TABLE', 'mtl_organizations', TRUE);
107: FND_MSG_PUB.ADD;
108: RAISE EXCP_USER_DEFINED;
109: END;
110: END IF;
111: NULL;

Line 121: FND_MSG_PUB.ADD;

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);
121: FND_MSG_PUB.ADD;
122: RAISE EXCP_USER_DEFINED;
123: END IF;
124: BEGIN
125: SELECT picklist_line_id INTO l_check_existence

Line 134: FND_MSG_PUB.ADD;

130: WHEN NO_DATA_FOUND THEN
131: -- the following error message needs to be changed to the appropriate one once Apps is up again.
132: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
133: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_packlist_line_id', TRUE);
134: FND_MSG_PUB.ADD;
135: RAISE EXCP_USER_DEFINED;
136: WHEN OTHERS THEN
137: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
138: fnd_message.set_token('ERR_FIELD', 'p_picklist_line_id', TRUE);

Line 141: FND_MSG_PUB.ADD;

137: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
138: fnd_message.set_token('ERR_FIELD', 'p_picklist_line_id', TRUE);
139: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
140: fnd_message.set_token('TABLE', 'csp_picklist_lines', TRUE);
141: FND_MSG_PUB.ADD;
142: RAISE EXCP_USER_DEFINED;
143: END;
144: END IF;
145: END IF;

Line 151: FND_MSG_PUB.ADD;

147: IF p_action_code IN (1, 2) THEN
148: IF px_PICKLIST_SERIAL_LOT_ID IS NULL THEN
149: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
150: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_picklist_serial_lot_id', TRUE);
151: FND_MSG_PUB.ADD;
152: RAISE EXCP_USER_DEFINED;
153: END IF;
154:
155: BEGIN

Line 167: FND_MSG_PUB.ADD;

163: WHEN NO_DATA_FOUND THEN
164: -- the following error message needs to be changed to the appropriate one once Apps is up again.
165: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
166: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_picklist_serial_lot_id', TRUE);
167: FND_MSG_PUB.ADD;
168: RAISE EXCP_USER_DEFINED;
169: WHEN OTHERS THEN
170: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
171: fnd_message.set_token('ERR_FIELD', 'px_picklist_serial_lot_id', TRUE);

Line 174: FND_MSG_PUB.ADD;

170: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
171: fnd_message.set_token('ERR_FIELD', 'px_picklist_serial_lot_id', TRUE);
172: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
173: fnd_message.set_token('TABLE', 'csp_picklist_serial_lots', TRUE);
174: FND_MSG_PUB.ADD;
175: RAISE EXCP_USER_DEFINED;
176: END;
177: END IF;
178:

Line 248: fnd_msg_pub.add;

244:
245: ELSE
246: fnd_message.set_name('INV', 'INV-INVALID ACTION');
247: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
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

Line 264: fnd_msg_pub.count_and_get

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:
268: --for debugging purpose

Line 275: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
276: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
277: ,X_MSG_COUNT => X_MSG_COUNT
278: ,X_MSG_DATA => X_MSG_DATA
279: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 285: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
286: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
287: ,X_MSG_COUNT => X_MSG_COUNT
288: ,X_MSG_DATA => X_MSG_DATA
289: ,X_RETURN_STATUS => X_RETURN_STATUS);