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_MESSAGE

Line 81: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
78: END IF;
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

Line 82: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);

78: END IF;
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

Line 91: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');

87: from mtl_parameters
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');

Line 95: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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);
97: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
98: fnd_message.set_token('TABLE', 'MTL_ORGANIZATIONS', TRUE);
99: FND_MSG_PUB.ADD;

Line 96: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);

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);
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;

Line 97: fnd_message.set_token('ROUTINE', l_api_name, TRUE);

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);
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;

Line 98: fnd_message.set_token('TABLE', 'MTL_ORGANIZATIONS', TRUE);

94: WHEN OTHERS THEN
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;

Line 105: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

101: END;
102: END IF;
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

Line 106: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_inventory_item_id ', TRUE);

102: END IF;
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

Line 118: fnd_message.set_name('INV', 'INV-NO ITEM RECROD');

114: where inventory_item_id = p_inventory_item_id
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');

Line 122: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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);
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;

Line 123: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);

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);
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;

Line 124: fnd_message.set_token('ROUTINE', l_api_name, TRUE);

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);
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;

Line 125: fnd_message.set_token('TABLE', 'MTL_SYSTEM_ITEMS', TRUE);

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);
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;

Line 211: fnd_message.set_name('INV', 'INV_ITEM_NOT_SERIAL_CONTROLLED');

207: -- serial number = not null
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:

Line 259: fnd_message.set_name('CSP', 'CSP_AVAIL_QTY');

255: /* WHEN EXCP_INVALID_ITEMS THEN
256: x_return_status := FND_API.G_RET_STS_SUCCESS;
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

Line 260: fnd_message.set_token('ERROR', l_msg_data);

256: x_return_status := FND_API.G_RET_STS_SUCCESS;
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

Line 283: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

279: x_available_quantity := NULL;
280:
281: WHEN OTHERS THEN
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

Line 284: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);

280:
281: WHEN OTHERS THEN
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

Line 285: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);

281: WHEN OTHERS THEN
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);