DBA Data[Home] [Help]

APPS.CSP_TO_FORM_MOHEADERS dependencies on FND_MESSAGE

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

99:
100:
101: -- check p_action_code
102: IF p_action_code not in (0, 1, 2) THEN
103: fnd_message.set_name('INV', 'INV-INVALID ACTION');
104: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
105: fnd_msg_pub.add;
106: RAISE EXCP_USER_DEFINED;
107: END IF;

Line 104: fnd_message.set_token('ROUTINE', l_api_name, FALSE);

100:
101: -- check p_action_code
102: IF p_action_code not in (0, 1, 2) THEN
103: fnd_message.set_name('INV', 'INV-INVALID ACTION');
104: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
105: fnd_msg_pub.add;
106: RAISE EXCP_USER_DEFINED;
107: END IF;
108:

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

108:
109: IF p_action_code = 0 THEN
110: -- For inserting, we need to validate the header_id and the carrier.
111: IF nvl(p_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
112: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
113: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);
114: FND_MSG_PUB.ADD;
115: RAISE EXCP_USER_DEFINED;
116: ELSE

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

109: IF p_action_code = 0 THEN
110: -- For inserting, we need to validate the header_id and the carrier.
111: IF nvl(p_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
112: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
113: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);
114: FND_MSG_PUB.ADD;
115: RAISE EXCP_USER_DEFINED;
116: ELSE
117: -- First we need to validate whether the given header_id already exists in the csp_moveorder_headers.

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

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

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

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

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

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

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

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

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

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

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

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

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

139: RAISE EXCP_USER_DEFINED;
140:
141: END;
142: ELSE
143: fnd_message.set_name ('CSP', 'CSP_DUPLICATE_RECORD');
144: fnd_msg_pub.add;
145: RAISE EXCP_USER_DEFINED;
146: END IF;
147: CLOSE l_Get_Header_ID_Csr;

Line 161: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_CARRIER');

157: AND organization_id = (SELECT organization_id FROM mtl_txn_request_headers
158: WHERE header_id = p_header_id);
159: EXCEPTION
160: WHEN NO_DATA_FOUND THEN
161: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_CARRIER');
162: FND_MESSAGE.SET_TOKEN('CARRIER_CODE', p_carrier, FALSE);
163: FND_MSG_PUB.ADD;
164: RAISE EXCP_USER_DEFINED;
165: WHEN OTHERS THEN

Line 162: FND_MESSAGE.SET_TOKEN('CARRIER_CODE', p_carrier, FALSE);

158: WHERE header_id = p_header_id);
159: EXCEPTION
160: WHEN NO_DATA_FOUND THEN
161: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_CARRIER');
162: FND_MESSAGE.SET_TOKEN('CARRIER_CODE', p_carrier, FALSE);
163: FND_MSG_PUB.ADD;
164: RAISE EXCP_USER_DEFINED;
165: WHEN OTHERS THEN
166: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

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

Line 167: fnd_message.set_token('ERR_FIELD', 'p_carrier', FALSE);

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

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

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

Line 169: fnd_message.set_token('TABLE', 'ORG_FREIGHT_TL', FALSE);

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

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

194: END IF;
195:
196: ELSIF p_action_code = 1 THEN
197: IF nvl(p_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
198: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
199: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);
200: FND_MSG_PUB.ADD;
201: RAISE EXCP_USER_DEFINED;
202: ELSE

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

195:
196: ELSIF p_action_code = 1 THEN
197: IF nvl(p_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
198: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
199: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);
200: FND_MSG_PUB.ADD;
201: RAISE EXCP_USER_DEFINED;
202: ELSE
203: -- Validate whether the given header_id exists in the mtl_txn_request_headers table.

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

207: WHERE header_id = p_header_id;
208:
209: EXCEPTION
210: WHEN NO_DATA_FOUND THEN
211: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_MOVEORDER');
212: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_header_id), FALSE);
213: FND_MSG_PUB.ADD;
214: RAISE EXCP_USER_DEFINED;
215: WHEN OTHERS THEN

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

208:
209: EXCEPTION
210: WHEN NO_DATA_FOUND THEN
211: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_MOVEORDER');
212: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_header_id), FALSE);
213: FND_MSG_PUB.ADD;
214: RAISE EXCP_USER_DEFINED;
215: WHEN OTHERS THEN
216: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

212: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_header_id), FALSE);
213: FND_MSG_PUB.ADD;
214: RAISE EXCP_USER_DEFINED;
215: WHEN OTHERS THEN
216: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
217: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);
218: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
219: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_HEADERS', FALSE);
220: FND_MSG_PUB.ADD;

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

213: FND_MSG_PUB.ADD;
214: RAISE EXCP_USER_DEFINED;
215: WHEN OTHERS THEN
216: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
217: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);
218: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
219: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_HEADERS', FALSE);
220: FND_MSG_PUB.ADD;
221: RAISE EXCP_USER_DEFINED;

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

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

Line 219: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_HEADERS', FALSE);

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

Line 236: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_CARRIER');

232: AND organization_id = (SELECT organization_id FROM mtl_txn_request_headers
233: WHERE header_id = p_header_id);
234: EXCEPTION
235: WHEN NO_DATA_FOUND THEN
236: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_CARRIER');
237: FND_MESSAGE.SET_TOKEN('CARRIER_CODE', p_carrier, FALSE);
238: FND_MSG_PUB.ADD;
239: RAISE EXCP_USER_DEFINED;
240: WHEN OTHERS THEN

Line 237: FND_MESSAGE.SET_TOKEN('CARRIER_CODE', p_carrier, FALSE);

233: WHERE header_id = p_header_id);
234: EXCEPTION
235: WHEN NO_DATA_FOUND THEN
236: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_CARRIER');
237: FND_MESSAGE.SET_TOKEN('CARRIER_CODE', p_carrier, FALSE);
238: FND_MSG_PUB.ADD;
239: RAISE EXCP_USER_DEFINED;
240: WHEN OTHERS THEN
241: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

237: FND_MESSAGE.SET_TOKEN('CARRIER_CODE', p_carrier, FALSE);
238: FND_MSG_PUB.ADD;
239: RAISE EXCP_USER_DEFINED;
240: WHEN OTHERS THEN
241: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
242: fnd_message.set_token('ERR_FIELD', 'p_carrier', FALSE);
243: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
244: fnd_message.set_token('TABLE', 'ORG_FREIGHT_TL', FALSE);
245: FND_MSG_PUB.ADD;

Line 242: fnd_message.set_token('ERR_FIELD', 'p_carrier', FALSE);

238: FND_MSG_PUB.ADD;
239: RAISE EXCP_USER_DEFINED;
240: WHEN OTHERS THEN
241: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
242: fnd_message.set_token('ERR_FIELD', 'p_carrier', FALSE);
243: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
244: fnd_message.set_token('TABLE', 'ORG_FREIGHT_TL', FALSE);
245: FND_MSG_PUB.ADD;
246: RAISE EXCP_USER_DEFINED;

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

239: RAISE EXCP_USER_DEFINED;
240: WHEN OTHERS THEN
241: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
242: fnd_message.set_token('ERR_FIELD', 'p_carrier', FALSE);
243: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
244: fnd_message.set_token('TABLE', 'ORG_FREIGHT_TL', FALSE);
245: FND_MSG_PUB.ADD;
246: RAISE EXCP_USER_DEFINED;
247: END;

Line 244: fnd_message.set_token('TABLE', 'ORG_FREIGHT_TL', FALSE);

240: WHEN OTHERS THEN
241: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
242: fnd_message.set_token('ERR_FIELD', 'p_carrier', FALSE);
243: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
244: fnd_message.set_token('TABLE', 'ORG_FREIGHT_TL', FALSE);
245: FND_MSG_PUB.ADD;
246: RAISE EXCP_USER_DEFINED;
247: END;
248: END IF;

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

252: Open l_Get_Creation_Date_Csr;
253: Fetch l_Get_Creation_Date_Csr into l_creation_date;
254: If l_Get_Creation_Date_Csr%NOTFOUND Then
255: Close l_Get_Creation_Date_Csr;
256: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
257: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);
258: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
259: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_HEADERS', FALSE);
260: FND_MSG_PUB.ADD;

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

253: Fetch l_Get_Creation_Date_Csr into l_creation_date;
254: If l_Get_Creation_Date_Csr%NOTFOUND Then
255: Close l_Get_Creation_Date_Csr;
256: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
257: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);
258: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
259: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_HEADERS', FALSE);
260: FND_MSG_PUB.ADD;
261: RAISE EXCP_USER_DEFINED;

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

254: If l_Get_Creation_Date_Csr%NOTFOUND Then
255: Close l_Get_Creation_Date_Csr;
256: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
257: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);
258: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
259: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_HEADERS', FALSE);
260: FND_MSG_PUB.ADD;
261: RAISE EXCP_USER_DEFINED;
262: End if;

Line 259: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_HEADERS', FALSE);

255: Close l_Get_Creation_Date_Csr;
256: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
257: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);
258: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
259: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_HEADERS', FALSE);
260: FND_MSG_PUB.ADD;
261: RAISE EXCP_USER_DEFINED;
262: End if;
263: Close l_Get_Creation_Date_Csr;

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

267: l_last_update_date := sysdate;
268: END IF;
269: ELSE -- p_action_code = 2
270: IF nvl(p_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
271: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
272: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);
273: FND_MSG_PUB.ADD;
274: RAISE EXCP_USER_DEFINED;
275: ELSE

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

268: END IF;
269: ELSE -- p_action_code = 2
270: IF nvl(p_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
271: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
272: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);
273: FND_MSG_PUB.ADD;
274: RAISE EXCP_USER_DEFINED;
275: ELSE
276: -- Validate whether the given header_id exists in the mtl_txn_request_headers table.

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

280: WHERE header_id = p_header_id;
281:
282: EXCEPTION
283: WHEN NO_DATA_FOUND THEN
284: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_MOVEORDER');
285: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_header_id), FALSE);
286: FND_MSG_PUB.ADD;
287: RAISE EXCP_USER_DEFINED;
288: WHEN OTHERS THEN

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

281:
282: EXCEPTION
283: WHEN NO_DATA_FOUND THEN
284: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_MOVEORDER');
285: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_header_id), FALSE);
286: FND_MSG_PUB.ADD;
287: RAISE EXCP_USER_DEFINED;
288: WHEN OTHERS THEN
289: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

285: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_header_id), FALSE);
286: FND_MSG_PUB.ADD;
287: RAISE EXCP_USER_DEFINED;
288: WHEN OTHERS THEN
289: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
290: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);
291: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
292: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_HEADERS', FALSE);
293: FND_MSG_PUB.ADD;

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

286: FND_MSG_PUB.ADD;
287: RAISE EXCP_USER_DEFINED;
288: WHEN OTHERS THEN
289: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
290: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);
291: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
292: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_HEADERS', FALSE);
293: FND_MSG_PUB.ADD;
294: RAISE EXCP_USER_DEFINED;

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

287: RAISE EXCP_USER_DEFINED;
288: WHEN OTHERS THEN
289: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
290: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);
291: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
292: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_HEADERS', FALSE);
293: FND_MSG_PUB.ADD;
294: RAISE EXCP_USER_DEFINED;
295:

Line 292: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_HEADERS', FALSE);

288: WHEN OTHERS THEN
289: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
290: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);
291: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
292: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_HEADERS', FALSE);
293: FND_MSG_PUB.ADD;
294: RAISE EXCP_USER_DEFINED;
295:
296: END;

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

404: ,X_MSG_DATA => X_MSG_DATA
405: ,X_RETURN_STATUS => X_RETURN_STATUS);
406: WHEN OTHERS THEN
407: Rollback to Validate_And_Write_PUB;
408: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
409: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
410: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
411: fnd_msg_pub.add;
412: fnd_msg_pub.count_and_get

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

405: ,X_RETURN_STATUS => X_RETURN_STATUS);
406: WHEN OTHERS THEN
407: Rollback to Validate_And_Write_PUB;
408: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
409: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
410: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
411: fnd_msg_pub.add;
412: fnd_msg_pub.count_and_get
413: ( p_count => x_msg_count

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

406: WHEN OTHERS THEN
407: Rollback to Validate_And_Write_PUB;
408: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
409: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
410: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
411: fnd_msg_pub.add;
412: fnd_msg_pub.count_and_get
413: ( p_count => x_msg_count
414: , p_data => x_msg_data);