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_MESSAGE

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

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

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

84:
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

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

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

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

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);
105: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
106: fnd_message.set_token('TABLE', 'mtl_organizations', TRUE);
107: FND_MSG_PUB.ADD;

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

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

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

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

Line 106: fnd_message.set_token('TABLE', 'mtl_organizations', TRUE);

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

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

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);
121: FND_MSG_PUB.ADD;
122: RAISE EXCP_USER_DEFINED;
123: END IF;

Line 120: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_packlist_line_id', TRUE);

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

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

128:
129: EXCEPTION
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

Line 133: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_packlist_line_id', TRUE);

129: EXCEPTION
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');

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

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

Line 138: fnd_message.set_token('ERR_FIELD', 'p_picklist_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);
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;

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

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

Line 140: fnd_message.set_token('TABLE', 'csp_picklist_lines', TRUE);

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

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

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

Line 150: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_picklist_serial_lot_id', TRUE);

146:
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:

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

161:
162: EXCEPTION
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

Line 166: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_picklist_serial_lot_id', TRUE);

162: EXCEPTION
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');

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

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

Line 171: fnd_message.set_token('ERR_FIELD', '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);
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;

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

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

Line 173: fnd_message.set_token('TABLE', 'csp_picklist_serial_lots', TRUE);

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

Line 246: fnd_message.set_name('INV', 'INV-INVALID ACTION');

242: X_Msg_Count => l_msg_count,
243: X_Msg_Data => l_msg_data);
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;

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

243: X_Msg_Data => l_msg_data);
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: