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

Line 71: FND_MSG_PUB.initialize;

67: l_atr NUMBER := 0;
68:
69: BEGIN
70: -- initialize message list
71: FND_MSG_PUB.initialize;
72: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
73: p_api_version_number,
74: l_api_name,
75: G_PKG_NAME)

Line 83: FND_MSG_PUB.ADD;

79:
80: IF p_organization_id IS NULL THEN
81: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
82: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
83: FND_MSG_PUB.ADD;
84: ELSE
85: BEGIN
86: select organization_id into l_check_existence
87: from mtl_parameters

Line 92: FND_MSG_PUB.ADD;

88: where organization_id = p_organization_id;
89: EXCEPTION
90: WHEN NO_DATA_FOUND THEN
91: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
92: FND_MSG_PUB.ADD;
93: RAISE EXCP_USER_DEFINED;
94: WHEN OTHERS THEN
95: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
96: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);

Line 99: FND_MSG_PUB.ADD;

95: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
96: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
97: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
98: fnd_message.set_token('TABLE', 'MTL_ORGANIZATIONS', TRUE);
99: FND_MSG_PUB.ADD;
100: RAISE EXCP_USER_DEFINED;
101: END;
102: END IF;
103:

Line 107: FND_MSG_PUB.ADD;

103:
104: IF p_inventory_item_id IS NULL THEN
105: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
106: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_inventory_item_id ', TRUE);
107: FND_MSG_PUB.ADD;
108: RAISE EXCP_USER_DEFINED;
109: ELSE
110: BEGIN
111: -- validate whether the inventory_item_is exists in the given oranization_id

Line 119: fnd_msg_pub.add;

115: and organization_id = P_organization_id;
116: EXCEPTION
117: WHEN NO_DATA_FOUND THEN
118: fnd_message.set_name('INV', 'INV-NO ITEM RECROD');
119: fnd_msg_pub.add;
120: RAISE EXCP_USER_DEFINED;
121: WHEN OTHERS THEN
122: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
123: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);

Line 126: FND_MSG_PUB.ADD;

122: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
123: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);
124: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
125: fnd_message.set_token('TABLE', 'MTL_SYSTEM_ITEMS', TRUE);
126: FND_MSG_PUB.ADD;
127: RAISE EXCP_USER_DEFINED;
128: END;
129: END IF;
130:

Line 212: FND_MSG_PUB.ADD;

208: -- If the item is under serial control, we do not have to check its availability at subinventory and locator level.
209: -- The reason is that item_id (plus its serial number) should be unique under one organization.
210: IF l_serial_control_code = 1 THEN
211: fnd_message.set_name('INV', 'INV_ITEM_NOT_SERIAL_CONTROLLED');
212: FND_MSG_PUB.ADD;
213: RAISE EXCP_USER_DEFINED;
214: END IF;
215:
216: l_serial_control_code := 0; -- reset l_serial_control_code for reuse

Line 250: fnd_msg_pub.count_and_get

246: EXCEPTION
247: WHEN EXCP_USER_DEFINED THEN
248: x_return_status := FND_API.G_RET_STS_ERROR;
249: x_available_quantity := NULL;
250: fnd_msg_pub.count_and_get
251: ( p_count => x_msg_count
252: , p_data => x_msg_data
253: );
254:

Line 261: fnd_msg_pub.ADD;

257: x_msg_data := l_msg_data||'Return 0 quantity.';
258: x_available_quantity := NULL;
259: fnd_message.set_name('CSP', 'CSP_AVAIL_QTY');
260: fnd_message.set_token('ERROR', l_msg_data);
261: fnd_msg_pub.ADD;
262: fnd_msg_pub.count_and_get
263: ( p_count => x_msg_count
264: , p_data => x_msg_data
265: );

Line 262: fnd_msg_pub.count_and_get

258: x_available_quantity := NULL;
259: fnd_message.set_name('CSP', 'CSP_AVAIL_QTY');
260: fnd_message.set_token('ERROR', l_msg_data);
261: fnd_msg_pub.ADD;
262: fnd_msg_pub.count_and_get
263: ( p_count => x_msg_count
264: , p_data => x_msg_data
265: );
266: */

Line 269: fnd_msg_pub.count_and_get

265: );
266: */
267: WHEN FND_API.G_EXC_ERROR THEN
268: x_return_status := l_return_status;
269: fnd_msg_pub.count_and_get
270: ( p_count => x_msg_count
271: , p_data => x_msg_data );
272: x_available_quantity := NULL;
273:

Line 276: fnd_msg_pub.count_and_get

272: x_available_quantity := NULL;
273:
274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: fnd_msg_pub.count_and_get
277: ( p_count => x_msg_count
278: , p_data => x_msg_data );
279: x_available_quantity := NULL;
280:

Line 286: fnd_msg_pub.add;

282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
284: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
285: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
286: fnd_msg_pub.add;
287: fnd_msg_pub.count_and_get
288: ( p_count => x_msg_count
289: , p_data => x_msg_data);
290: x_available_quantity := NULL;

Line 287: fnd_msg_pub.count_and_get

283: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
284: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
285: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
286: fnd_msg_pub.add;
287: fnd_msg_pub.count_and_get
288: ( p_count => x_msg_count
289: , p_data => x_msg_data);
290: x_available_quantity := NULL;
291: