APPS.CSP_TO_FORM_MOLINES dependencies on FND_MESSAGE

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

103: END IF;
104:
105: --validating p_action_code
106: IF nvl(p_action_code, fnd_api.g_miss_num) NOT IN (0, 1, 2) THEN
107: fnd_message.set_name ('INV', 'INV-INVALID ACTION');
108: fnd_message.set_token ('ROUTINE', l_pkg_api_name, FALSE);
109: fnd_msg_pub.add;
110: RAISE EXCP_USER_DEFINED;
111: END IF;

Line 108: fnd_message.set_token ('ROUTINE', l_pkg_api_name, FALSE);

104:
105: --validating p_action_code
106: IF nvl(p_action_code, fnd_api.g_miss_num) NOT IN (0, 1, 2) THEN
107: fnd_message.set_name ('INV', 'INV-INVALID ACTION');
108: fnd_message.set_token ('ROUTINE', l_pkg_api_name, FALSE);
109: fnd_msg_pub.add;
110: RAISE EXCP_USER_DEFINED;
111: END IF;
112:

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

112:
113: IF p_action_code = 0 THEN
114: -- check p_header_id and p_line_id. if null return an error.
115: IF nvl(p_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
116: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
117: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);
118: FND_MSG_PUB.ADD;
119: RAISE EXCP_USER_DEFINED;
120: ELSE

Line 117: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);

113: IF p_action_code = 0 THEN
114: -- check p_header_id and p_line_id. if null return an error.
115: IF nvl(p_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
116: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
117: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);
118: FND_MSG_PUB.ADD;
119: RAISE EXCP_USER_DEFINED;
120: ELSE
121: -- validate where the header_id already exists.

Line 128: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_MOVEORDER');

124: FROM mtl_txn_request_headers --csp_moveorder_headers
125: WHERE header_id = p_header_id;
126: EXCEPTION
127: WHEN NO_DATA_FOUND THEN
128: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_MOVEORDER');
129: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_header_id), FALSE);
130: FND_MSG_PUB.ADD;
131: RAISE EXCP_USER_DEFINED;
132: WHEN OTHERS THEN

Line 129: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_header_id), FALSE);

125: WHERE header_id = p_header_id;
126: EXCEPTION
127: WHEN NO_DATA_FOUND THEN
128: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_MOVEORDER');
129: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_header_id), FALSE);
130: FND_MSG_PUB.ADD;
131: RAISE EXCP_USER_DEFINED;
132: WHEN OTHERS THEN
133: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

129: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_header_id), FALSE);
130: FND_MSG_PUB.ADD;
131: RAISE EXCP_USER_DEFINED;
132: WHEN OTHERS THEN
133: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
134: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);
135: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
136: fnd_message.set_token('TABLE', 'MTL_TXN_REQUEST_HEADERS', FALSE);
137: FND_MSG_PUB.ADD;

Line 134: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);

130: FND_MSG_PUB.ADD;
131: RAISE EXCP_USER_DEFINED;
132: WHEN OTHERS THEN
133: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
134: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);
135: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
136: fnd_message.set_token('TABLE', 'MTL_TXN_REQUEST_HEADERS', FALSE);
137: FND_MSG_PUB.ADD;
138: RAISE EXCP_USER_DEFINED;

Line 135: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);

131: RAISE EXCP_USER_DEFINED;
132: WHEN OTHERS THEN
133: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
134: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);
135: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
136: fnd_message.set_token('TABLE', 'MTL_TXN_REQUEST_HEADERS', FALSE);
137: FND_MSG_PUB.ADD;
138: RAISE EXCP_USER_DEFINED;
139: END;

Line 136: fnd_message.set_token('TABLE', 'MTL_TXN_REQUEST_HEADERS', FALSE);

132: WHEN OTHERS THEN
133: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
134: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);
135: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
136: fnd_message.set_token('TABLE', 'MTL_TXN_REQUEST_HEADERS', FALSE);
137: FND_MSG_PUB.ADD;
138: RAISE EXCP_USER_DEFINED;
139: END;
140:

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

140:
141: END IF;
142:
143: IF nvl(p_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
144: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
145: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_line_id', FALSE);
146: FND_MSG_PUB.ADD;
147: RAISE EXCP_USER_DEFINED;
148: ELSE

Line 145: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_line_id', FALSE);

141: END IF;
142:
143: IF nvl(p_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
144: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
145: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_line_id', FALSE);
146: FND_MSG_PUB.ADD;
147: RAISE EXCP_USER_DEFINED;
148: ELSE
149: -- First check whether the line id already exists.

Line 160: FND_MESSAGE.SET_NAME('CSP', 'CSP_MOLINE_NO_EXIST');

156: WHERE line_id = p_line_id
157: AND header_id = p_header_id;
158: EXCEPTION
159: WHEN NO_DATA_FOUND THEN
160: FND_MESSAGE.SET_NAME('CSP', 'CSP_MOLINE_NO_EXIST');
161: FND_MESSAGE.SET_TOKEN('LINE_ID', to_char(p_line_id), FALSE);
162: FND_MSG_PUB.ADD;
163: RAISE EXCP_USER_DEFINED;
164: WHEN OTHERS THEN

Line 161: FND_MESSAGE.SET_TOKEN('LINE_ID', to_char(p_line_id), FALSE);

157: AND header_id = p_header_id;
158: EXCEPTION
159: WHEN NO_DATA_FOUND THEN
160: FND_MESSAGE.SET_NAME('CSP', 'CSP_MOLINE_NO_EXIST');
161: FND_MESSAGE.SET_TOKEN('LINE_ID', to_char(p_line_id), FALSE);
162: FND_MSG_PUB.ADD;
163: RAISE EXCP_USER_DEFINED;
164: WHEN OTHERS THEN
165: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

161: FND_MESSAGE.SET_TOKEN('LINE_ID', to_char(p_line_id), FALSE);
162: FND_MSG_PUB.ADD;
163: RAISE EXCP_USER_DEFINED;
164: WHEN OTHERS THEN
165: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
166: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
167: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
168: fnd_message.set_token('TABLE', 'MTL_TXN_REQUEST_LINES', FALSE);
169: FND_MSG_PUB.ADD;

Line 166: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);

162: FND_MSG_PUB.ADD;
163: RAISE EXCP_USER_DEFINED;
164: WHEN OTHERS THEN
165: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
166: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
167: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
168: fnd_message.set_token('TABLE', 'MTL_TXN_REQUEST_LINES', FALSE);
169: FND_MSG_PUB.ADD;
170: RAISE EXCP_USER_DEFINED;

Line 167: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);

163: RAISE EXCP_USER_DEFINED;
164: WHEN OTHERS THEN
165: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
166: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
167: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
168: fnd_message.set_token('TABLE', 'MTL_TXN_REQUEST_LINES', FALSE);
169: FND_MSG_PUB.ADD;
170: RAISE EXCP_USER_DEFINED;
171: END;

Line 168: fnd_message.set_token('TABLE', 'MTL_TXN_REQUEST_LINES', FALSE);

164: WHEN OTHERS THEN
165: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
166: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
167: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
168: fnd_message.set_token('TABLE', 'MTL_TXN_REQUEST_LINES', FALSE);
169: FND_MSG_PUB.ADD;
170: RAISE EXCP_USER_DEFINED;
171: END;
172: ELSE

Line 173: fnd_message.set_name ('CSP', 'CSP_DUPLICATE_RECORD');

169: FND_MSG_PUB.ADD;
170: RAISE EXCP_USER_DEFINED;
171: END;
172: ELSE
173: fnd_message.set_name ('CSP', 'CSP_DUPLICATE_RECORD');
174: fnd_msg_pub.add;
175: RAISE EXCP_USER_DEFINED;
176: END IF;
177: CLOSE l_Get_Line_ID_Csr;

Line 188: FND_MESSAGE.SET_NAME('JTF', 'JTF_TASK_INVALID_TASK_ID');

184: FROM jtf_tasks_vl
185: WHERE task_id = p_task_id;
186: EXCEPTION
187: WHEN NO_DATA_FOUND THEN
188: FND_MESSAGE.SET_NAME('JTF', 'JTF_TASK_INVALID_TASK_ID');
189: FND_MESSAGE.SET_TOKEN('P_TASK_ID', to_char(p_task_id), FALSE);
190: FND_MSG_PUB.ADD;
191: RAISE EXCP_USER_DEFINED;
192: WHEN OTHERS THEN

Line 189: FND_MESSAGE.SET_TOKEN('P_TASK_ID', to_char(p_task_id), FALSE);

185: WHERE task_id = p_task_id;
186: EXCEPTION
187: WHEN NO_DATA_FOUND THEN
188: FND_MESSAGE.SET_NAME('JTF', 'JTF_TASK_INVALID_TASK_ID');
189: FND_MESSAGE.SET_TOKEN('P_TASK_ID', to_char(p_task_id), FALSE);
190: FND_MSG_PUB.ADD;
191: RAISE EXCP_USER_DEFINED;
192: WHEN OTHERS THEN
193: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

189: FND_MESSAGE.SET_TOKEN('P_TASK_ID', to_char(p_task_id), FALSE);
190: FND_MSG_PUB.ADD;
191: RAISE EXCP_USER_DEFINED;
192: WHEN OTHERS THEN
193: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
194: fnd_message.set_token('ERR_FIELD', 'p_task_id', FALSE);
195: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
196: fnd_message.set_token('TABLE', 'JTF_TASKS_TL', FALSE);
197: FND_MSG_PUB.ADD;

Line 194: fnd_message.set_token('ERR_FIELD', 'p_task_id', FALSE);

190: FND_MSG_PUB.ADD;
191: RAISE EXCP_USER_DEFINED;
192: WHEN OTHERS THEN
193: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
194: fnd_message.set_token('ERR_FIELD', 'p_task_id', FALSE);
195: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
196: fnd_message.set_token('TABLE', 'JTF_TASKS_TL', FALSE);
197: FND_MSG_PUB.ADD;
198: RAISE EXCP_USER_DEFINED;

Line 195: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);

191: RAISE EXCP_USER_DEFINED;
192: WHEN OTHERS THEN
193: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
194: fnd_message.set_token('ERR_FIELD', 'p_task_id', FALSE);
195: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
196: fnd_message.set_token('TABLE', 'JTF_TASKS_TL', FALSE);
197: FND_MSG_PUB.ADD;
198: RAISE EXCP_USER_DEFINED;
199: END;

Line 196: fnd_message.set_token('TABLE', 'JTF_TASKS_TL', FALSE);

192: WHEN OTHERS THEN
193: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
194: fnd_message.set_token('ERR_FIELD', 'p_task_id', FALSE);
195: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
196: fnd_message.set_token('TABLE', 'JTF_TASKS_TL', FALSE);
197: FND_MSG_PUB.ADD;
198: RAISE EXCP_USER_DEFINED;
199: END;
200: END IF;

Line 212: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_TASK_ASSIGNMENT');

208: WHERE task_assignment_id = p_task_assignment_id
209: AND task_id = p_task_id;
210: EXCEPTION
211: WHEN NO_DATA_FOUND THEN
212: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_TASK_ASSIGNMENT');
213: FND_MESSAGE.SET_TOKEN('ASSIGNMENT_ID', to_char(p_task_assignment_id), FALSE);
214: FND_MESSAGE.SET_TOKEN('TASK_ID', to_char(p_task_id), FALSE);
215: FND_MSG_PUB.ADD;
216: RAISE EXCP_USER_DEFINED;

Line 213: FND_MESSAGE.SET_TOKEN('ASSIGNMENT_ID', to_char(p_task_assignment_id), FALSE);

209: AND task_id = p_task_id;
210: EXCEPTION
211: WHEN NO_DATA_FOUND THEN
212: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_TASK_ASSIGNMENT');
213: FND_MESSAGE.SET_TOKEN('ASSIGNMENT_ID', to_char(p_task_assignment_id), FALSE);
214: FND_MESSAGE.SET_TOKEN('TASK_ID', to_char(p_task_id), FALSE);
215: FND_MSG_PUB.ADD;
216: RAISE EXCP_USER_DEFINED;
217: WHEN OTHERS THEN

Line 214: FND_MESSAGE.SET_TOKEN('TASK_ID', to_char(p_task_id), FALSE);

210: EXCEPTION
211: WHEN NO_DATA_FOUND THEN
212: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_TASK_ASSIGNMENT');
213: FND_MESSAGE.SET_TOKEN('ASSIGNMENT_ID', to_char(p_task_assignment_id), FALSE);
214: FND_MESSAGE.SET_TOKEN('TASK_ID', to_char(p_task_id), FALSE);
215: FND_MSG_PUB.ADD;
216: RAISE EXCP_USER_DEFINED;
217: WHEN OTHERS THEN
218: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

214: FND_MESSAGE.SET_TOKEN('TASK_ID', to_char(p_task_id), FALSE);
215: FND_MSG_PUB.ADD;
216: RAISE EXCP_USER_DEFINED;
217: WHEN OTHERS THEN
218: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
219: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
220: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
221: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
222: FND_MSG_PUB.ADD;

Line 219: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);

215: FND_MSG_PUB.ADD;
216: RAISE EXCP_USER_DEFINED;
217: WHEN OTHERS THEN
218: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
219: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
220: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
221: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
222: FND_MSG_PUB.ADD;
223: RAISE EXCP_USER_DEFINED;

Line 220: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);

216: RAISE EXCP_USER_DEFINED;
217: WHEN OTHERS THEN
218: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
219: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
220: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
221: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
222: FND_MSG_PUB.ADD;
223: RAISE EXCP_USER_DEFINED;
224: END;

Line 221: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);

217: WHEN OTHERS THEN
218: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
219: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
220: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
221: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
222: FND_MSG_PUB.ADD;
223: RAISE EXCP_USER_DEFINED;
224: END;
225: ELSE

Line 232: FND_MESSAGE.SET_NAME('JTF', 'JTF_TASK_INV_TK_ASS');

228: FROM jtf_task_assignments
229: WHERE task_assignment_id = p_task_assignment_id;
230: EXCEPTION
231: WHEN NO_DATA_FOUND THEN
232: FND_MESSAGE.SET_NAME('JTF', 'JTF_TASK_INV_TK_ASS');
233: FND_MESSAGE.SET_TOKEN('P_TASK_ASSIGNMENT_ID', to_char(p_task_assignment_id), FALSE);
234: FND_MSG_PUB.ADD;
235: RAISE EXCP_USER_DEFINED;
236: WHEN OTHERS THEN

Line 233: FND_MESSAGE.SET_TOKEN('P_TASK_ASSIGNMENT_ID', to_char(p_task_assignment_id), FALSE);

229: WHERE task_assignment_id = p_task_assignment_id;
230: EXCEPTION
231: WHEN NO_DATA_FOUND THEN
232: FND_MESSAGE.SET_NAME('JTF', 'JTF_TASK_INV_TK_ASS');
233: FND_MESSAGE.SET_TOKEN('P_TASK_ASSIGNMENT_ID', to_char(p_task_assignment_id), FALSE);
234: FND_MSG_PUB.ADD;
235: RAISE EXCP_USER_DEFINED;
236: WHEN OTHERS THEN
237: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

233: FND_MESSAGE.SET_TOKEN('P_TASK_ASSIGNMENT_ID', to_char(p_task_assignment_id), FALSE);
234: FND_MSG_PUB.ADD;
235: RAISE EXCP_USER_DEFINED;
236: WHEN OTHERS THEN
237: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
238: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
239: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
240: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
241: FND_MSG_PUB.ADD;

Line 238: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);

234: FND_MSG_PUB.ADD;
235: RAISE EXCP_USER_DEFINED;
236: WHEN OTHERS THEN
237: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
238: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
239: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
240: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
241: FND_MSG_PUB.ADD;
242: RAISE EXCP_USER_DEFINED;

Line 239: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);

235: RAISE EXCP_USER_DEFINED;
236: WHEN OTHERS THEN
237: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
238: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
239: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
240: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
241: FND_MSG_PUB.ADD;
242: RAISE EXCP_USER_DEFINED;
243: END;

Line 240: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);

236: WHEN OTHERS THEN
237: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
238: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
239: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
240: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
241: FND_MSG_PUB.ADD;
242: RAISE EXCP_USER_DEFINED;
243: END;
244: END IF;

Line 255: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_INCIDENT_ID');

251: FROM cs_incidents_all
252: WHERE incident_id = p_incident_id;
253: EXCEPTION
254: WHEN NO_DATA_FOUND THEN
255: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_INCIDENT_ID');
256: FND_MESSAGE.SET_TOKEN('INCIDENT_ID', to_char(p_incident_id), FALSE);
257: FND_MSG_PUB.ADD;
258: RAISE EXCP_USER_DEFINED;
259: WHEN OTHERS THEN

Line 256: FND_MESSAGE.SET_TOKEN('INCIDENT_ID', to_char(p_incident_id), FALSE);

252: WHERE incident_id = p_incident_id;
253: EXCEPTION
254: WHEN NO_DATA_FOUND THEN
255: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_INCIDENT_ID');
256: FND_MESSAGE.SET_TOKEN('INCIDENT_ID', to_char(p_incident_id), FALSE);
257: FND_MSG_PUB.ADD;
258: RAISE EXCP_USER_DEFINED;
259: WHEN OTHERS THEN
260: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

256: FND_MESSAGE.SET_TOKEN('INCIDENT_ID', to_char(p_incident_id), FALSE);
257: FND_MSG_PUB.ADD;
258: RAISE EXCP_USER_DEFINED;
259: WHEN OTHERS THEN
260: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
261: fnd_message.set_token('ERR_FIELD', 'p_incident_id', FALSE);
262: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
263: fnd_message.set_token('TABLE', 'CS_INCIDENTS_ALL', FALSE);
264: FND_MSG_PUB.ADD;

Line 261: fnd_message.set_token('ERR_FIELD', 'p_incident_id', FALSE);

257: FND_MSG_PUB.ADD;
258: RAISE EXCP_USER_DEFINED;
259: WHEN OTHERS THEN
260: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
261: fnd_message.set_token('ERR_FIELD', 'p_incident_id', FALSE);
262: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
263: fnd_message.set_token('TABLE', 'CS_INCIDENTS_ALL', FALSE);
264: FND_MSG_PUB.ADD;
265: RAISE EXCP_USER_DEFINED;

Line 262: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);

258: RAISE EXCP_USER_DEFINED;
259: WHEN OTHERS THEN
260: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
261: fnd_message.set_token('ERR_FIELD', 'p_incident_id', FALSE);
262: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
263: fnd_message.set_token('TABLE', 'CS_INCIDENTS_ALL', FALSE);
264: FND_MSG_PUB.ADD;
265: RAISE EXCP_USER_DEFINED;
266: END;

Line 263: fnd_message.set_token('TABLE', 'CS_INCIDENTS_ALL', FALSE);

259: WHEN OTHERS THEN
260: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
261: fnd_message.set_token('ERR_FIELD', 'p_incident_id', FALSE);
262: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
263: fnd_message.set_token('TABLE', 'CS_INCIDENTS_ALL', FALSE);
264: FND_MSG_PUB.ADD;
265: RAISE EXCP_USER_DEFINED;
266: END;
267: END IF;

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

288: END IF;
289:
290: ELSIF p_action_code = 1 THEN
291: IF nvl(p_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
292: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
293: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_line_id', FALSE);
294: FND_MSG_PUB.ADD;
295: RAISE EXCP_USER_DEFINED;
296: ELSE

Line 293: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_line_id', FALSE);

289:
290: ELSIF p_action_code = 1 THEN
291: IF nvl(p_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
292: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
293: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_line_id', FALSE);
294: FND_MSG_PUB.ADD;
295: RAISE EXCP_USER_DEFINED;
296: ELSE
297: BEGIN

Line 303: FND_MESSAGE.SET_NAME('CSP', 'CSP_MOLINE_NO_EXIST');

299: FROM csp_moveorder_lines
300: WHERE line_id = p_line_id;
301: EXCEPTION
302: WHEN NO_DATA_FOUND THEN
303: FND_MESSAGE.SET_NAME('CSP', 'CSP_MOLINE_NO_EXIST');
304: FND_MESSAGE.SET_TOKEN('LINE_ID', to_char(p_line_id), FALSE);
305: FND_MSG_PUB.ADD;
306: RAISE EXCP_USER_DEFINED;
307: WHEN OTHERS THEN

Line 304: FND_MESSAGE.SET_TOKEN('LINE_ID', to_char(p_line_id), FALSE);

300: WHERE line_id = p_line_id;
301: EXCEPTION
302: WHEN NO_DATA_FOUND THEN
303: FND_MESSAGE.SET_NAME('CSP', 'CSP_MOLINE_NO_EXIST');
304: FND_MESSAGE.SET_TOKEN('LINE_ID', to_char(p_line_id), FALSE);
305: FND_MSG_PUB.ADD;
306: RAISE EXCP_USER_DEFINED;
307: WHEN OTHERS THEN
308: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

304: FND_MESSAGE.SET_TOKEN('LINE_ID', to_char(p_line_id), FALSE);
305: FND_MSG_PUB.ADD;
306: RAISE EXCP_USER_DEFINED;
307: WHEN OTHERS THEN
308: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
309: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
310: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
311: fnd_message.set_token('TABLE', 'CSP_MOVERDER_LINES', FALSE);
312: FND_MSG_PUB.ADD;

Line 309: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);

305: FND_MSG_PUB.ADD;
306: RAISE EXCP_USER_DEFINED;
307: WHEN OTHERS THEN
308: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
309: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
310: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
311: fnd_message.set_token('TABLE', 'CSP_MOVERDER_LINES', FALSE);
312: FND_MSG_PUB.ADD;
313: RAISE EXCP_USER_DEFINED;

Line 310: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);

306: RAISE EXCP_USER_DEFINED;
307: WHEN OTHERS THEN
308: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
309: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
310: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
311: fnd_message.set_token('TABLE', 'CSP_MOVERDER_LINES', FALSE);
312: FND_MSG_PUB.ADD;
313: RAISE EXCP_USER_DEFINED;
314: END;

Line 311: fnd_message.set_token('TABLE', 'CSP_MOVERDER_LINES', FALSE);

307: WHEN OTHERS THEN
308: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
309: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
310: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
311: fnd_message.set_token('TABLE', 'CSP_MOVERDER_LINES', FALSE);
312: FND_MSG_PUB.ADD;
313: RAISE EXCP_USER_DEFINED;
314: END;
315: END IF;

Line 326: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_MOVEORDER');

322: FROM csp_moveorder_headers
323: WHERE header_id = p_header_id;
324: EXCEPTION
325: WHEN NO_DATA_FOUND THEN
326: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_MOVEORDER');
327: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_header_id), FALSE);
328: FND_MSG_PUB.ADD;
329: RAISE EXCP_USER_DEFINED;
330: WHEN OTHERS THEN

Line 327: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_header_id), FALSE);

323: WHERE header_id = p_header_id;
324: EXCEPTION
325: WHEN NO_DATA_FOUND THEN
326: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_MOVEORDER');
327: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_header_id), FALSE);
328: FND_MSG_PUB.ADD;
329: RAISE EXCP_USER_DEFINED;
330: WHEN OTHERS THEN
331: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

327: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_header_id), FALSE);
328: FND_MSG_PUB.ADD;
329: RAISE EXCP_USER_DEFINED;
330: WHEN OTHERS THEN
331: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
332: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);
333: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
334: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);
335: FND_MSG_PUB.ADD;

Line 332: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);

328: FND_MSG_PUB.ADD;
329: RAISE EXCP_USER_DEFINED;
330: WHEN OTHERS THEN
331: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
332: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);
333: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
334: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);
335: FND_MSG_PUB.ADD;
336: RAISE EXCP_USER_DEFINED;

Line 333: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);

329: RAISE EXCP_USER_DEFINED;
330: WHEN OTHERS THEN
331: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
332: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);
333: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
334: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);
335: FND_MSG_PUB.ADD;
336: RAISE EXCP_USER_DEFINED;
337: END;

Line 334: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);

330: WHEN OTHERS THEN
331: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
332: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);
333: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
334: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);
335: FND_MSG_PUB.ADD;
336: RAISE EXCP_USER_DEFINED;
337: END;
338: END IF;

Line 348: FND_MESSAGE.SET_NAME('JTF', 'JTF_TASK_INVALID_TASK_ID');

344: FROM jtf_tasks_vl
345: WHERE task_id = l_task_id;
346: EXCEPTION
347: WHEN NO_DATA_FOUND THEN
348: FND_MESSAGE.SET_NAME('JTF', 'JTF_TASK_INVALID_TASK_ID');
349: FND_MESSAGE.SET_TOKEN('P_TASK_ID', to_char(p_task_id), FALSE);
350: FND_MSG_PUB.ADD;
351: RAISE EXCP_USER_DEFINED;
352: WHEN OTHERS THEN

Line 349: FND_MESSAGE.SET_TOKEN('P_TASK_ID', to_char(p_task_id), FALSE);

345: WHERE task_id = l_task_id;
346: EXCEPTION
347: WHEN NO_DATA_FOUND THEN
348: FND_MESSAGE.SET_NAME('JTF', 'JTF_TASK_INVALID_TASK_ID');
349: FND_MESSAGE.SET_TOKEN('P_TASK_ID', to_char(p_task_id), FALSE);
350: FND_MSG_PUB.ADD;
351: RAISE EXCP_USER_DEFINED;
352: WHEN OTHERS THEN
353: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

349: FND_MESSAGE.SET_TOKEN('P_TASK_ID', to_char(p_task_id), FALSE);
350: FND_MSG_PUB.ADD;
351: RAISE EXCP_USER_DEFINED;
352: WHEN OTHERS THEN
353: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
354: fnd_message.set_token('ERR_FIELD', 'p_task_id', FALSE);
355: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
356: fnd_message.set_token('TABLE', 'JTF_TASKS_TL', FALSE);
357: FND_MSG_PUB.ADD;

Line 354: fnd_message.set_token('ERR_FIELD', 'p_task_id', FALSE);

350: FND_MSG_PUB.ADD;
351: RAISE EXCP_USER_DEFINED;
352: WHEN OTHERS THEN
353: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
354: fnd_message.set_token('ERR_FIELD', 'p_task_id', FALSE);
355: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
356: fnd_message.set_token('TABLE', 'JTF_TASKS_TL', FALSE);
357: FND_MSG_PUB.ADD;
358: RAISE EXCP_USER_DEFINED;

Line 355: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);

351: RAISE EXCP_USER_DEFINED;
352: WHEN OTHERS THEN
353: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
354: fnd_message.set_token('ERR_FIELD', 'p_task_id', FALSE);
355: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
356: fnd_message.set_token('TABLE', 'JTF_TASKS_TL', FALSE);
357: FND_MSG_PUB.ADD;
358: RAISE EXCP_USER_DEFINED;
359: END;

Line 356: fnd_message.set_token('TABLE', 'JTF_TASKS_TL', FALSE);

352: WHEN OTHERS THEN
353: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
354: fnd_message.set_token('ERR_FIELD', 'p_task_id', FALSE);
355: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
356: fnd_message.set_token('TABLE', 'JTF_TASKS_TL', FALSE);
357: FND_MSG_PUB.ADD;
358: RAISE EXCP_USER_DEFINED;
359: END;
360:

Line 374: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_TASK_ASSIGNMENT');

370: WHERE task_assignment_id = l_task_assignment_id
371: AND task_id = l_task_id;
372: EXCEPTION
373: WHEN NO_DATA_FOUND THEN
374: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_TASK_ASSIGNMENT');
375: FND_MESSAGE.SET_TOKEN('ASSIGNMENT_ID', to_char(l_task_assignment_id), FALSE);
376: FND_MESSAGE.SET_TOKEN('TASK_ID', to_char(l_task_id), FALSE);
377: FND_MSG_PUB.ADD;
378: RAISE EXCP_USER_DEFINED;

Line 375: FND_MESSAGE.SET_TOKEN('ASSIGNMENT_ID', to_char(l_task_assignment_id), FALSE);

371: AND task_id = l_task_id;
372: EXCEPTION
373: WHEN NO_DATA_FOUND THEN
374: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_TASK_ASSIGNMENT');
375: FND_MESSAGE.SET_TOKEN('ASSIGNMENT_ID', to_char(l_task_assignment_id), FALSE);
376: FND_MESSAGE.SET_TOKEN('TASK_ID', to_char(l_task_id), FALSE);
377: FND_MSG_PUB.ADD;
378: RAISE EXCP_USER_DEFINED;
379: WHEN OTHERS THEN

Line 376: FND_MESSAGE.SET_TOKEN('TASK_ID', to_char(l_task_id), FALSE);

372: EXCEPTION
373: WHEN NO_DATA_FOUND THEN
374: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_TASK_ASSIGNMENT');
375: FND_MESSAGE.SET_TOKEN('ASSIGNMENT_ID', to_char(l_task_assignment_id), FALSE);
376: FND_MESSAGE.SET_TOKEN('TASK_ID', to_char(l_task_id), FALSE);
377: FND_MSG_PUB.ADD;
378: RAISE EXCP_USER_DEFINED;
379: WHEN OTHERS THEN
380: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

376: FND_MESSAGE.SET_TOKEN('TASK_ID', to_char(l_task_id), FALSE);
377: FND_MSG_PUB.ADD;
378: RAISE EXCP_USER_DEFINED;
379: WHEN OTHERS THEN
380: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
381: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
382: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
383: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
384: FND_MSG_PUB.ADD;

Line 381: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);

377: FND_MSG_PUB.ADD;
378: RAISE EXCP_USER_DEFINED;
379: WHEN OTHERS THEN
380: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
381: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
382: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
383: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
384: FND_MSG_PUB.ADD;
385: RAISE EXCP_USER_DEFINED;

Line 382: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);

378: RAISE EXCP_USER_DEFINED;
379: WHEN OTHERS THEN
380: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
381: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
382: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
383: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
384: FND_MSG_PUB.ADD;
385: RAISE EXCP_USER_DEFINED;
386: END;

Line 383: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);

379: WHEN OTHERS THEN
380: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
381: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
382: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
383: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
384: FND_MSG_PUB.ADD;
385: RAISE EXCP_USER_DEFINED;
386: END;
387: END IF;

Line 408: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_TASK_ASSIGNMENT');

404: WHERE task_assignment_id = p_task_assignment_id
405: AND task_id = l_task_id;
406: EXCEPTION
407: WHEN NO_DATA_FOUND THEN
408: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_TASK_ASSIGNMENT');
409: FND_MESSAGE.SET_TOKEN('ASSIGNMENT_ID', to_char(p_task_assignment_id), FALSE);
410: FND_MESSAGE.SET_TOKEN('TASK_ID', to_char(l_task_id), FALSE);
411: FND_MSG_PUB.ADD;
412: RAISE EXCP_USER_DEFINED;

Line 409: FND_MESSAGE.SET_TOKEN('ASSIGNMENT_ID', to_char(p_task_assignment_id), FALSE);

405: AND task_id = l_task_id;
406: EXCEPTION
407: WHEN NO_DATA_FOUND THEN
408: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_TASK_ASSIGNMENT');
409: FND_MESSAGE.SET_TOKEN('ASSIGNMENT_ID', to_char(p_task_assignment_id), FALSE);
410: FND_MESSAGE.SET_TOKEN('TASK_ID', to_char(l_task_id), FALSE);
411: FND_MSG_PUB.ADD;
412: RAISE EXCP_USER_DEFINED;
413: WHEN OTHERS THEN

Line 410: FND_MESSAGE.SET_TOKEN('TASK_ID', to_char(l_task_id), FALSE);

406: EXCEPTION
407: WHEN NO_DATA_FOUND THEN
408: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_TASK_ASSIGNMENT');
409: FND_MESSAGE.SET_TOKEN('ASSIGNMENT_ID', to_char(p_task_assignment_id), FALSE);
410: FND_MESSAGE.SET_TOKEN('TASK_ID', to_char(l_task_id), FALSE);
411: FND_MSG_PUB.ADD;
412: RAISE EXCP_USER_DEFINED;
413: WHEN OTHERS THEN
414: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

410: FND_MESSAGE.SET_TOKEN('TASK_ID', to_char(l_task_id), FALSE);
411: FND_MSG_PUB.ADD;
412: RAISE EXCP_USER_DEFINED;
413: WHEN OTHERS THEN
414: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
415: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
416: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
417: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
418: FND_MSG_PUB.ADD;

Line 415: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);

411: FND_MSG_PUB.ADD;
412: RAISE EXCP_USER_DEFINED;
413: WHEN OTHERS THEN
414: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
415: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
416: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
417: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
418: FND_MSG_PUB.ADD;
419: RAISE EXCP_USER_DEFINED;

Line 416: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);

412: RAISE EXCP_USER_DEFINED;
413: WHEN OTHERS THEN
414: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
415: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
416: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
417: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
418: FND_MSG_PUB.ADD;
419: RAISE EXCP_USER_DEFINED;
420: END;

Line 417: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);

413: WHEN OTHERS THEN
414: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
415: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
416: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
417: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
418: FND_MSG_PUB.ADD;
419: RAISE EXCP_USER_DEFINED;
420: END;
421: ELSE

Line 428: FND_MESSAGE.SET_NAME('JTF', 'JTF_TASK_INV_TK_ASS');

424: FROM jtf_task_assignments
425: WHERE task_assignment_id = p_task_assignment_id;
426: EXCEPTION
427: WHEN NO_DATA_FOUND THEN
428: FND_MESSAGE.SET_NAME('JTF', 'JTF_TASK_INV_TK_ASS');
429: FND_MESSAGE.SET_TOKEN('P_TASK_ASSIGNMENT_ID', to_char(p_task_assignment_id), FALSE);
430: FND_MSG_PUB.ADD;
431: RAISE EXCP_USER_DEFINED;
432: WHEN OTHERS THEN

Line 429: FND_MESSAGE.SET_TOKEN('P_TASK_ASSIGNMENT_ID', to_char(p_task_assignment_id), FALSE);

425: WHERE task_assignment_id = p_task_assignment_id;
426: EXCEPTION
427: WHEN NO_DATA_FOUND THEN
428: FND_MESSAGE.SET_NAME('JTF', 'JTF_TASK_INV_TK_ASS');
429: FND_MESSAGE.SET_TOKEN('P_TASK_ASSIGNMENT_ID', to_char(p_task_assignment_id), FALSE);
430: FND_MSG_PUB.ADD;
431: RAISE EXCP_USER_DEFINED;
432: WHEN OTHERS THEN
433: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

429: FND_MESSAGE.SET_TOKEN('P_TASK_ASSIGNMENT_ID', to_char(p_task_assignment_id), FALSE);
430: FND_MSG_PUB.ADD;
431: RAISE EXCP_USER_DEFINED;
432: WHEN OTHERS THEN
433: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
434: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
435: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
436: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
437: FND_MSG_PUB.ADD;

Line 434: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);

430: FND_MSG_PUB.ADD;
431: RAISE EXCP_USER_DEFINED;
432: WHEN OTHERS THEN
433: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
434: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
435: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
436: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
437: FND_MSG_PUB.ADD;
438: RAISE EXCP_USER_DEFINED;

Line 435: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);

431: RAISE EXCP_USER_DEFINED;
432: WHEN OTHERS THEN
433: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
434: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
435: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
436: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
437: FND_MSG_PUB.ADD;
438: RAISE EXCP_USER_DEFINED;
439: END;

Line 436: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);

432: WHEN OTHERS THEN
433: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
434: fnd_message.set_token('ERR_FIELD', 'p_task_assignment_id', FALSE);
435: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
436: fnd_message.set_token('TABLE', 'JTF_TASK_ASSIGNMENTS', FALSE);
437: FND_MSG_PUB.ADD;
438: RAISE EXCP_USER_DEFINED;
439: END;
440: END IF;

Line 451: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_INCIDENT_ID');

447: FROM cs_incidents_all
448: WHERE incident_id = p_incident_id;
449: EXCEPTION
450: WHEN NO_DATA_FOUND THEN
451: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_INCIDENT_ID');
452: FND_MESSAGE.SET_TOKEN('INCIDENT_ID', to_char(p_incident_id), FALSE);
453: FND_MSG_PUB.ADD;
454: RAISE EXCP_USER_DEFINED;
455: WHEN OTHERS THEN

Line 452: FND_MESSAGE.SET_TOKEN('INCIDENT_ID', to_char(p_incident_id), FALSE);

448: WHERE incident_id = p_incident_id;
449: EXCEPTION
450: WHEN NO_DATA_FOUND THEN
451: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_INCIDENT_ID');
452: FND_MESSAGE.SET_TOKEN('INCIDENT_ID', to_char(p_incident_id), FALSE);
453: FND_MSG_PUB.ADD;
454: RAISE EXCP_USER_DEFINED;
455: WHEN OTHERS THEN
456: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

452: FND_MESSAGE.SET_TOKEN('INCIDENT_ID', to_char(p_incident_id), FALSE);
453: FND_MSG_PUB.ADD;
454: RAISE EXCP_USER_DEFINED;
455: WHEN OTHERS THEN
456: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
457: fnd_message.set_token('ERR_FIELD', 'p_incident_id', FALSE);
458: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
459: fnd_message.set_token('TABLE', 'CS_INCIDENTS_ALL', FALSE);
460: FND_MSG_PUB.ADD;

Line 457: fnd_message.set_token('ERR_FIELD', 'p_incident_id', FALSE);

453: FND_MSG_PUB.ADD;
454: RAISE EXCP_USER_DEFINED;
455: WHEN OTHERS THEN
456: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
457: fnd_message.set_token('ERR_FIELD', 'p_incident_id', FALSE);
458: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
459: fnd_message.set_token('TABLE', 'CS_INCIDENTS_ALL', FALSE);
460: FND_MSG_PUB.ADD;
461: RAISE EXCP_USER_DEFINED;

Line 458: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);

454: RAISE EXCP_USER_DEFINED;
455: WHEN OTHERS THEN
456: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
457: fnd_message.set_token('ERR_FIELD', 'p_incident_id', FALSE);
458: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
459: fnd_message.set_token('TABLE', 'CS_INCIDENTS_ALL', FALSE);
460: FND_MSG_PUB.ADD;
461: RAISE EXCP_USER_DEFINED;
462: END;

Line 459: fnd_message.set_token('TABLE', 'CS_INCIDENTS_ALL', FALSE);

455: WHEN OTHERS THEN
456: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
457: fnd_message.set_token('ERR_FIELD', 'p_incident_id', FALSE);
458: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
459: fnd_message.set_token('TABLE', 'CS_INCIDENTS_ALL', FALSE);
460: FND_MSG_PUB.ADD;
461: RAISE EXCP_USER_DEFINED;
462: END;
463: END IF;

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

467: Open l_Get_Creation_Date_Csr;
468: Fetch l_Get_Creation_Date_Csr into l_creation_date;
469: If l_Get_Creation_Date_Csr%NOTFOUND Then
470: Close l_Get_Creation_Date_Csr;
471: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
472: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);
473: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
474: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);
475: FND_MSG_PUB.ADD;

Line 472: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);

468: Fetch l_Get_Creation_Date_Csr into l_creation_date;
469: If l_Get_Creation_Date_Csr%NOTFOUND Then
470: Close l_Get_Creation_Date_Csr;
471: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
472: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);
473: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
474: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);
475: FND_MSG_PUB.ADD;
476: RAISE EXCP_USER_DEFINED;

Line 473: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);

469: If l_Get_Creation_Date_Csr%NOTFOUND Then
470: Close l_Get_Creation_Date_Csr;
471: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
472: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);
473: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
474: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);
475: FND_MSG_PUB.ADD;
476: RAISE EXCP_USER_DEFINED;
477: End if;

Line 474: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);

470: Close l_Get_Creation_Date_Csr;
471: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
472: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);
473: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
474: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);
475: FND_MSG_PUB.ADD;
476: RAISE EXCP_USER_DEFINED;
477: End if;
478: Close l_Get_Creation_Date_Csr;

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

482: l_last_update_date := sysdate;
483: END IF;
484: ELSE -- p_action_code = 2
485: IF nvl(p_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
486: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
487: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_line_id', FALSE);
488: FND_MSG_PUB.ADD;
489: RAISE EXCP_USER_DEFINED;
490: ELSE

Line 487: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_line_id', FALSE);

483: END IF;
484: ELSE -- p_action_code = 2
485: IF nvl(p_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
486: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
487: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_line_id', FALSE);
488: FND_MSG_PUB.ADD;
489: RAISE EXCP_USER_DEFINED;
490: ELSE
491: BEGIN

Line 497: FND_MESSAGE.SET_NAME('CSP', 'CSP_MOLINE_NO_EXIST');

493: FROM csp_moveorder_lines
494: WHERE line_id = p_line_id;
495: EXCEPTION
496: WHEN NO_DATA_FOUND THEN
497: FND_MESSAGE.SET_NAME('CSP', 'CSP_MOLINE_NO_EXIST');
498: FND_MESSAGE.SET_TOKEN('LINE_ID', to_char(p_line_id), FALSE);
499: FND_MSG_PUB.ADD;
500: RAISE EXCP_USER_DEFINED;
501: WHEN OTHERS THEN

Line 498: FND_MESSAGE.SET_TOKEN('LINE_ID', to_char(p_line_id), FALSE);

494: WHERE line_id = p_line_id;
495: EXCEPTION
496: WHEN NO_DATA_FOUND THEN
497: FND_MESSAGE.SET_NAME('CSP', 'CSP_MOLINE_NO_EXIST');
498: FND_MESSAGE.SET_TOKEN('LINE_ID', to_char(p_line_id), FALSE);
499: FND_MSG_PUB.ADD;
500: RAISE EXCP_USER_DEFINED;
501: WHEN OTHERS THEN
502: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

498: FND_MESSAGE.SET_TOKEN('LINE_ID', to_char(p_line_id), FALSE);
499: FND_MSG_PUB.ADD;
500: RAISE EXCP_USER_DEFINED;
501: WHEN OTHERS THEN
502: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
503: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
504: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
505: fnd_message.set_token('TABLE', 'CSP_MOVERDER_LINES', FALSE);
506: FND_MSG_PUB.ADD;

Line 503: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);

499: FND_MSG_PUB.ADD;
500: RAISE EXCP_USER_DEFINED;
501: WHEN OTHERS THEN
502: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
503: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
504: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
505: fnd_message.set_token('TABLE', 'CSP_MOVERDER_LINES', FALSE);
506: FND_MSG_PUB.ADD;
507: RAISE EXCP_USER_DEFINED;

Line 504: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);

500: RAISE EXCP_USER_DEFINED;
501: WHEN OTHERS THEN
502: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
503: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
504: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
505: fnd_message.set_token('TABLE', 'CSP_MOVERDER_LINES', FALSE);
506: FND_MSG_PUB.ADD;
507: RAISE EXCP_USER_DEFINED;
508: END;

Line 505: fnd_message.set_token('TABLE', 'CSP_MOVERDER_LINES', FALSE);

501: WHEN OTHERS THEN
502: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
503: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
504: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
505: fnd_message.set_token('TABLE', 'CSP_MOVERDER_LINES', FALSE);
506: FND_MSG_PUB.ADD;
507: RAISE EXCP_USER_DEFINED;
508: END;
509: END IF;

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

614: ,X_MSG_DATA => X_MSG_DATA
615: ,X_RETURN_STATUS => X_RETURN_STATUS);
616: WHEN OTHERS THEN
617: Rollback to Validate_And_Write_PUB;
618: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
619: fnd_message.set_token ('ROUTINE', l_pkg_api_name, FALSE);
620: fnd_message.set_token ('SQLERRM', sqlerrm, FALSE);
621: fnd_msg_pub.add;
622: fnd_msg_pub.count_and_get

Line 619: fnd_message.set_token ('ROUTINE', l_pkg_api_name, FALSE);

615: ,X_RETURN_STATUS => X_RETURN_STATUS);
616: WHEN OTHERS THEN
617: Rollback to Validate_And_Write_PUB;
618: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
619: fnd_message.set_token ('ROUTINE', l_pkg_api_name, FALSE);
620: fnd_message.set_token ('SQLERRM', sqlerrm, FALSE);
621: fnd_msg_pub.add;
622: fnd_msg_pub.count_and_get
623: ( p_count => x_msg_count

Line 620: fnd_message.set_token ('SQLERRM', sqlerrm, FALSE);

616: WHEN OTHERS THEN
617: Rollback to Validate_And_Write_PUB;
618: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
619: fnd_message.set_token ('ROUTINE', l_pkg_api_name, FALSE);
620: fnd_message.set_token ('SQLERRM', sqlerrm, FALSE);
621: fnd_msg_pub.add;
622: fnd_msg_pub.count_and_get
623: ( p_count => x_msg_count
624: , p_data => x_msg_data);