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_PC_FORM_PICKHEADERS dependencies on FND_MSG_PUB

Line 88: FND_MSG_PUB.initialize;

84: BEGIN
85: SAVEPOINT Validate_And_Write_PUB;
86: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
87: -- initialize message list
88: FND_MSG_PUB.initialize;
89: END IF;
90:
91: -- Standard call to check for call compatibility.
92: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 104: fnd_msg_pub.add;

100:
101: IF nvl(p_action_code, fnd_api.g_miss_num) NOT IN (0, 1, 2) THEN
102: fnd_message.set_name ('INV', 'INV-INVALID ACTION');
103: fnd_message.set_token ('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
104: fnd_msg_pub.add;
105: RAISE EXCP_USER_DEFINED;
106: END IF;
107:
108: IF p_action_code = 0 THEN

Line 118: fnd_msg_pub.add;

114: WHERE picklist_header_id = px_picklist_header_id
115: AND organization_id = p_organization_id;
116:
117: fnd_message.set_name ('CSP', 'CSP_DUPLICATE_RECORD');
118: fnd_msg_pub.add;
119: -- l_msg_data := 'Header ID '||px_picklist_header_id||' already exists. It is not allowed to create a new record again with this ID.';
120: RAISE EXCP_USER_DEFINED;
121: EXCEPTION
122: WHEN NO_DATA_FOUND THEN -- This is what we want!

Line 129: FND_MSG_PUB.ADD;

125: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
126: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);
127: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
128: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
129: FND_MSG_PUB.ADD;
130: RAISE EXCP_USER_DEFINED;
131: END;
132: END IF;
133:

Line 138: FND_MSG_PUB.ADD;

134: -- Validate the status against the lookup codes.
135: IF nvl(p_PICKLIST_STATUS, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
136: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
137: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_picklist_status', FALSE);
138: FND_MSG_PUB.ADD;
139: RAISE EXCP_USER_DEFINED;
140: ELSE
141: BEGIN
142: select distinct lookup_code into l_check_var

Line 150: fnd_msg_pub.add;

146: EXCEPTION
147: WHEN NO_DATA_FOUND THEN
148: fnd_message.set_name('CSP', 'CSP_INVALID_PICK_STATUS');
149: fnd_message.set_token('PICKLIST_STATUS', p_PICKLIST_STATUS, FALSE);
150: fnd_msg_pub.add;
151: RAISE EXCP_USER_DEFINED;
152: WHEN OTHERS THEN
153: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
154: fnd_message.set_token('ERR_FIELD', 'px_picklist_status', FALSE);

Line 157: FND_MSG_PUB.ADD;

153: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
154: fnd_message.set_token('ERR_FIELD', 'px_picklist_status', FALSE);
155: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
156: fnd_message.set_token('TABLE', 'FND_LOOKUPS', FALSE);
157: FND_MSG_PUB.ADD;
158: RAISE EXCP_USER_DEFINED;
159: END;
160: END IF;
161:

Line 166: FND_MSG_PUB.ADD;

162: --validation of organization_id
163: IF nvl(p_organization_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
164: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
165: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', FALSE);
166: FND_MSG_PUB.ADD;
167: RAISE EXCP_USER_DEFINED;
168: ELSE
169: BEGIN
170: select organization_id into l_check_existence

Line 176: FND_MSG_PUB.ADD;

172: where organization_id = p_organization_id;
173: EXCEPTION
174: WHEN NO_DATA_FOUND THEN
175: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
176: FND_MSG_PUB.ADD;
177: RAISE EXCP_USER_DEFINED;
178: WHEN OTHERS THEN
179: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
180: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);

Line 183: FND_MSG_PUB.ADD;

179: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
180: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);
181: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
182: fnd_message.set_token('TABLE', 'ORG_ORGANIZATION_DEFINITIONS', FALSE);
183: FND_MSG_PUB.ADD;
184: RAISE EXCP_USER_DEFINED;
185: END;
186: END IF;
187:

Line 217: FND_MSG_PUB.ADD;

213: -- which already exists because the picklist_header_id is a primary key.
214: IF nvl(px_picklist_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
215: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
216: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_picklist_header_id', FALSE);
217: FND_MSG_PUB.ADD;
218: RAISE EXCP_USER_DEFINED;
219: ELSE
220: BEGIN
221: select picklist_header_id into l_check_existence

Line 228: FND_MSG_PUB.ADD;

224: EXCEPTION
225: WHEN NO_DATA_FOUND THEN
226: fnd_message.set_name('CSP', 'CSP_INVALID_PICKLIST_HEADER');
227: fnd_message.set_token ('HEADER_ID', to_char(px_picklist_header_id), FALSE);
228: FND_MSG_PUB.ADD;
229: RAISE EXCP_USER_DEFINED;
230: WHEN OTHERS THEN
231: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
232: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);

Line 235: FND_MSG_PUB.ADD;

231: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
232: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);
233: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
234: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
235: FND_MSG_PUB.ADD;
236: RAISE EXCP_USER_DEFINED;
237: END;
238: END IF;
239:

Line 251: fnd_msg_pub.add;

247: EXCEPTION
248: WHEN NO_DATA_FOUND THEN
249: fnd_message.set_name('CSP', 'CSP_INVALID_PICK_STATUS');
250: fnd_message.set_token('PICKLIST_STATUS', p_PICKLIST_STATUS, FALSE);
251: fnd_msg_pub.add;
252: RAISE EXCP_USER_DEFINED;
253: WHEN OTHERS THEN
254: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
255: fnd_message.set_token('ERR_FIELD', 'px_picklist_status', FALSE);

Line 258: FND_MSG_PUB.ADD;

254: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
255: fnd_message.set_token('ERR_FIELD', 'px_picklist_status', FALSE);
256: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
257: fnd_message.set_token('TABLE', 'FND_LOOKUPS', FALSE);
258: FND_MSG_PUB.ADD;
259: RAISE EXCP_USER_DEFINED;
260: END;
261: END IF;
262:

Line 272: FND_MSG_PUB.ADD;

268: where organization_id = p_organization_id;
269: EXCEPTION
270: WHEN NO_DATA_FOUND THEN
271: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
272: FND_MSG_PUB.ADD;
273: RAISE EXCP_USER_DEFINED;
274: WHEN OTHERS THEN
275: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
276: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);

Line 279: FND_MSG_PUB.ADD;

275: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
276: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);
277: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
278: fnd_message.set_token('TABLE', 'MTL_PARAMETERS', FALSE);
279: FND_MSG_PUB.ADD;
280: RAISE EXCP_USER_DEFINED;
281: END;
282: END IF;
283:

Line 294: FND_MSG_PUB.ADD;

290: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
291: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);
292: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
293: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
294: FND_MSG_PUB.ADD;
295: RAISE EXCP_USER_DEFINED;
296: End if;
297: Close l_Get_Creation_Date_Csr;
298: End if;

Line 308: FND_MSG_PUB.ADD;

304: ELSE -- p_action_code = 2
305: IF nvl(px_picklist_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
306: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
307: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_picklist_header_id', FALSE);
308: FND_MSG_PUB.ADD;
309: RAISE EXCP_USER_DEFINED;
310: ELSE
311: BEGIN
312: select picklist_header_id/0 into l_check_existence

Line 319: fnd_msg_pub.add;

315: EXCEPTION
316: WHEN NO_DATA_FOUND THEN
317: fnd_message.set_name('CSP', 'CSP_INVALID_PICKLIST_HEADER');
318: fnd_message.set_token ('HEADER_ID', to_char(px_picklist_header_id), FALSE);
319: fnd_msg_pub.add;
320: RAISE EXCP_USER_DEFINED;
321: WHEN OTHERS THEN
322: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
323: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);

Line 326: FND_MSG_PUB.ADD;

322: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
323: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);
324: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
325: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
326: FND_MSG_PUB.ADD;
327: RAISE EXCP_USER_DEFINED;
328: END;
329: END IF;
330:

Line 418: fnd_msg_pub.count_and_get

414: EXCEPTION
415: WHEN EXCP_USER_DEFINED THEN
416: Rollback to Validate_And_Write_PUB;
417: x_return_status := FND_API.G_RET_STS_ERROR;
418: fnd_msg_pub.count_and_get
419: ( p_count => x_msg_count
420: , p_data => x_msg_data);
421:
422: --for debugging purpose

Line 429: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 439: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
436: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
437: P_API_NAME => L_API_NAME
438: ,P_PKG_NAME => G_PKG_NAME
439: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
440: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
441: ,X_MSG_COUNT => X_MSG_COUNT
442: ,X_MSG_DATA => X_MSG_DATA
443: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 449: fnd_msg_pub.add;

445: Rollback to Validate_And_Write_PUB;
446: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
447: fnd_message.set_token ('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
448: fnd_message.set_token ('SQLERRM', sqlerrm, FALSE);
449: fnd_msg_pub.add;
450: fnd_msg_pub.count_and_get
451: ( p_count => x_msg_count
452: , p_data => x_msg_data);
453: x_return_status := fnd_api.g_ret_sts_error;

Line 450: fnd_msg_pub.count_and_get

446: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
447: fnd_message.set_token ('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
448: fnd_message.set_token ('SQLERRM', sqlerrm, FALSE);
449: fnd_msg_pub.add;
450: fnd_msg_pub.count_and_get
451: ( p_count => x_msg_count
452: , p_data => x_msg_data);
453: x_return_status := fnd_api.g_ret_sts_error;
454: