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