60: RAISE;
61: END;
62:
63: IF (l_receipt_exists = 1) THEN
64: fnd_message.set_name('CSP','CSP_RECEIPT_NUM_EXISTS');
65: fnd_message.set_token('RECEIPT',x_receipt_num,false);
66: fnd_msg_pub.add;
67: RAISE FND_API.G_EXC_ERROR;
68: END IF;
61: END;
62:
63: IF (l_receipt_exists = 1) THEN
64: fnd_message.set_name('CSP','CSP_RECEIPT_NUM_EXISTS');
65: fnd_message.set_token('RECEIPT',x_receipt_num,false);
66: fnd_msg_pub.add;
67: RAISE FND_API.G_EXC_ERROR;
68: END IF;
69:
86: ,X_MSG_COUNT => X_MSG_COUNT
87: ,X_MSG_DATA => X_MSG_DATA
88: ,X_RETURN_STATUS => X_RETURN_STATUS);
89: WHEN OTHERS THEN
90: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
91: fnd_message.set_token('ROUTINE',l_api_name,false);
92: fnd_message.set_token('SQLERRM',sqlerrm,false);
93: fnd_msg_pub.add;
94: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
87: ,X_MSG_DATA => X_MSG_DATA
88: ,X_RETURN_STATUS => X_RETURN_STATUS);
89: WHEN OTHERS THEN
90: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
91: fnd_message.set_token('ROUTINE',l_api_name,false);
92: fnd_message.set_token('SQLERRM',sqlerrm,false);
93: fnd_msg_pub.add;
94: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
95: P_API_NAME => L_API_NAME
88: ,X_RETURN_STATUS => X_RETURN_STATUS);
89: WHEN OTHERS THEN
90: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
91: fnd_message.set_token('ROUTINE',l_api_name,false);
92: fnd_message.set_token('SQLERRM',sqlerrm,false);
93: fnd_msg_pub.add;
94: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
95: P_API_NAME => L_API_NAME
96: ,P_PKG_NAME => G_PKG_NAME
128: /* get user id */
129:
130: FND_PROFILE.GET('USER_ID', X_user_id);
131: if X_user_id is null then
132: fnd_message.set_name('CSP','CSP_INVALID_USER_ID');
133: fnd_msg_pub.add;
134: return False;
135: end if;
136: BEGIN
251: ,X_MSG_DATA => X_MSG_DATA
252: ,X_RETURN_STATUS => X_RETURN_STATUS);
253: return FALSE;
254: WHEN OTHERS THEN
255: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
256: fnd_message.set_token('ROUTINE',l_api_name,false);
257: fnd_message.set_token('SQLERRM',sqlerrm,false);
258: fnd_msg_pub.add;
259: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
252: ,X_RETURN_STATUS => X_RETURN_STATUS);
253: return FALSE;
254: WHEN OTHERS THEN
255: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
256: fnd_message.set_token('ROUTINE',l_api_name,false);
257: fnd_message.set_token('SQLERRM',sqlerrm,false);
258: fnd_msg_pub.add;
259: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
260: P_API_NAME => L_API_NAME
253: return FALSE;
254: WHEN OTHERS THEN
255: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
256: fnd_message.set_token('ROUTINE',l_api_name,false);
257: fnd_message.set_token('SQLERRM',sqlerrm,false);
258: fnd_msg_pub.add;
259: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
260: P_API_NAME => L_API_NAME
261: ,P_PKG_NAME => G_PKG_NAME
618: po_moac_utils_pvt.set_org_context(l_org_org_id);
619: end if;
620:
621: WHEN OTHERS THEN
622: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
623: fnd_message.set_token('ROUTINE',l_api_name,false);
624: fnd_message.set_token('SQLERRM',sqlerrm,false);
625: fnd_msg_pub.add;
626: get_messages(x_msg_data);
619: end if;
620:
621: WHEN OTHERS THEN
622: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
623: fnd_message.set_token('ROUTINE',l_api_name,false);
624: fnd_message.set_token('SQLERRM',sqlerrm,false);
625: fnd_msg_pub.add;
626: get_messages(x_msg_data);
627: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
620:
621: WHEN OTHERS THEN
622: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
623: fnd_message.set_token('ROUTINE',l_api_name,false);
624: fnd_message.set_token('SQLERRM',sqlerrm,false);
625: fnd_msg_pub.add;
626: get_messages(x_msg_data);
627: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
628: P_API_NAME => L_API_NAME
821: ,X_MSG_COUNT => X_MSG_COUNT
822: ,X_MSG_DATA => X_MSG_DATA
823: ,X_RETURN_STATUS => X_RETURN_STATUS);
824: WHEN OTHERS THEN
825: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
826: fnd_message.set_token('ROUTINE',l_api_name,false);
827: fnd_message.set_token('SQLERRM',sqlerrm,false);
828: fnd_msg_pub.add;
829: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
822: ,X_MSG_DATA => X_MSG_DATA
823: ,X_RETURN_STATUS => X_RETURN_STATUS);
824: WHEN OTHERS THEN
825: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
826: fnd_message.set_token('ROUTINE',l_api_name,false);
827: fnd_message.set_token('SQLERRM',sqlerrm,false);
828: fnd_msg_pub.add;
829: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
830: P_API_NAME => L_API_NAME
823: ,X_RETURN_STATUS => X_RETURN_STATUS);
824: WHEN OTHERS THEN
825: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
826: fnd_message.set_token('ROUTINE',l_api_name,false);
827: fnd_message.set_token('SQLERRM',sqlerrm,false);
828: fnd_msg_pub.add;
829: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
830: P_API_NAME => L_API_NAME
831: ,P_PKG_NAME => G_PKG_NAME
1039: , l_rcv_transaction_rec.oe_order_line_id
1040: , l_rcv_transaction_rec.from_organization_id);
1041: EXCEPTION
1042: WHEN OTHERS THEN
1043: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
1044: fnd_message.set_token('ROUTINE','rcv_receipts_query_sv.post_query',false);
1045: fnd_message.set_token('SQLERRM',sqlerrm,false);
1046: fnd_msg_pub.add;
1047: get_messages(x_msg_data);
1040: , l_rcv_transaction_rec.from_organization_id);
1041: EXCEPTION
1042: WHEN OTHERS THEN
1043: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
1044: fnd_message.set_token('ROUTINE','rcv_receipts_query_sv.post_query',false);
1045: fnd_message.set_token('SQLERRM',sqlerrm,false);
1046: fnd_msg_pub.add;
1047: get_messages(x_msg_data);
1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1041: EXCEPTION
1042: WHEN OTHERS THEN
1043: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
1044: fnd_message.set_token('ROUTINE','rcv_receipts_query_sv.post_query',false);
1045: fnd_message.set_token('SQLERRM',sqlerrm,false);
1046: fnd_msg_pub.add;
1047: get_messages(x_msg_data);
1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1049: END;
1062: WHERE organization_id = l_to_org_id;
1063:
1064: EXCEPTION
1065: WHEN OTHERS THEN
1066: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
1067: fnd_message.set_token('ROUTINE','get receiving flag',false);
1068: fnd_message.set_token('SQLERRM',sqlerrm,false);
1069: fnd_msg_pub.add;
1070: get_messages(x_msg_data);
1063:
1064: EXCEPTION
1065: WHEN OTHERS THEN
1066: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
1067: fnd_message.set_token('ROUTINE','get receiving flag',false);
1068: fnd_message.set_token('SQLERRM',sqlerrm,false);
1069: fnd_msg_pub.add;
1070: get_messages(x_msg_data);
1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1064: EXCEPTION
1065: WHEN OTHERS THEN
1066: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
1067: fnd_message.set_token('ROUTINE','get receiving flag',false);
1068: fnd_message.set_token('SQLERRM',sqlerrm,false);
1069: fnd_msg_pub.add;
1070: get_messages(x_msg_data);
1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1072: END;
1551: ,X_MSG_COUNT => X_MSG_COUNT
1552: ,X_MSG_DATA => X_MESSAGE
1553: ,X_RETURN_STATUS => X_RETURN_STATUS);
1554: WHEN OTHERS THEN
1555: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
1556: fnd_message.set_token('ROUTINE',l_api_name,false);
1557: fnd_message.set_token('SQLERRM',sqlerrm,false);
1558: fnd_msg_pub.add;
1559: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1552: ,X_MSG_DATA => X_MESSAGE
1553: ,X_RETURN_STATUS => X_RETURN_STATUS);
1554: WHEN OTHERS THEN
1555: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
1556: fnd_message.set_token('ROUTINE',l_api_name,false);
1557: fnd_message.set_token('SQLERRM',sqlerrm,false);
1558: fnd_msg_pub.add;
1559: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1560: P_API_NAME => L_API_NAME
1553: ,X_RETURN_STATUS => X_RETURN_STATUS);
1554: WHEN OTHERS THEN
1555: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
1556: fnd_message.set_token('ROUTINE',l_api_name,false);
1557: fnd_message.set_token('SQLERRM',sqlerrm,false);
1558: fnd_msg_pub.add;
1559: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1560: P_API_NAME => L_API_NAME
1561: ,P_PKG_NAME => G_PKG_NAME
2026: ,X_MSG_COUNT => X_MSG_COUNT
2027: ,X_MSG_DATA => X_MESSAGE
2028: ,X_RETURN_STATUS => X_RETURN_STATUS);
2029: WHEN OTHERS THEN
2030: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
2031: fnd_message.set_token('ROUTINE',l_api_name,false);
2032: fnd_message.set_token('SQLERRM',sqlerrm,false);
2033: fnd_msg_pub.add;
2034: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2027: ,X_MSG_DATA => X_MESSAGE
2028: ,X_RETURN_STATUS => X_RETURN_STATUS);
2029: WHEN OTHERS THEN
2030: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
2031: fnd_message.set_token('ROUTINE',l_api_name,false);
2032: fnd_message.set_token('SQLERRM',sqlerrm,false);
2033: fnd_msg_pub.add;
2034: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2035: P_API_NAME => L_API_NAME
2028: ,X_RETURN_STATUS => X_RETURN_STATUS);
2029: WHEN OTHERS THEN
2030: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
2031: fnd_message.set_token('ROUTINE',l_api_name,false);
2032: fnd_message.set_token('SQLERRM',sqlerrm,false);
2033: fnd_msg_pub.add;
2034: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2035: P_API_NAME => L_API_NAME
2036: ,P_PKG_NAME => G_PKG_NAME
2184: ,X_MSG_COUNT => X_MSG_COUNT
2185: ,X_MSG_DATA => X_MESSAGE
2186: ,X_RETURN_STATUS => X_RETURN_STATUS);
2187: WHEN OTHERS THEN
2188: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
2189: fnd_message.set_token('ROUTINE',l_api_name,false);
2190: fnd_message.set_token('SQLERRM',sqlerrm,false);
2191: fnd_msg_pub.add;
2192: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2185: ,X_MSG_DATA => X_MESSAGE
2186: ,X_RETURN_STATUS => X_RETURN_STATUS);
2187: WHEN OTHERS THEN
2188: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
2189: fnd_message.set_token('ROUTINE',l_api_name,false);
2190: fnd_message.set_token('SQLERRM',sqlerrm,false);
2191: fnd_msg_pub.add;
2192: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2193: P_API_NAME => L_API_NAME
2186: ,X_RETURN_STATUS => X_RETURN_STATUS);
2187: WHEN OTHERS THEN
2188: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
2189: fnd_message.set_token('ROUTINE',l_api_name,false);
2190: fnd_message.set_token('SQLERRM',sqlerrm,false);
2191: fnd_msg_pub.add;
2192: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2193: P_API_NAME => L_API_NAME
2194: ,P_PKG_NAME => G_PKG_NAME
2258: 'l_message = ' || l_message);
2259: end if;
2260:
2261: IF (rc = 1) THEN
2262: fnd_message.set_name('FND', 'TM-TIMEOUT');
2263: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2264: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2265: fnd_message.set_token('REQUEST', p_group_id);
2266: fnd_message.set_token('REASON', x_str);
2259: end if;
2260:
2261: IF (rc = 1) THEN
2262: fnd_message.set_name('FND', 'TM-TIMEOUT');
2263: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2264: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2265: fnd_message.set_token('REQUEST', p_group_id);
2266: fnd_message.set_token('REASON', x_str);
2267: fnd_msg_pub.ADD;
2260:
2261: IF (rc = 1) THEN
2262: fnd_message.set_name('FND', 'TM-TIMEOUT');
2263: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2264: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2265: fnd_message.set_token('REQUEST', p_group_id);
2266: fnd_message.set_token('REASON', x_str);
2267: fnd_msg_pub.ADD;
2268: x_return_status := fnd_api.g_ret_sts_error;
2261: IF (rc = 1) THEN
2262: fnd_message.set_name('FND', 'TM-TIMEOUT');
2263: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2264: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2265: fnd_message.set_token('REQUEST', p_group_id);
2266: fnd_message.set_token('REASON', x_str);
2267: fnd_msg_pub.ADD;
2268: x_return_status := fnd_api.g_ret_sts_error;
2269: ELSIF (rc = 2) THEN
2262: fnd_message.set_name('FND', 'TM-TIMEOUT');
2263: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2264: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2265: fnd_message.set_token('REQUEST', p_group_id);
2266: fnd_message.set_token('REASON', x_str);
2267: fnd_msg_pub.ADD;
2268: x_return_status := fnd_api.g_ret_sts_error;
2269: ELSIF (rc = 2) THEN
2270: fnd_message.set_name('FND', 'TM-SVC LOCK HANDLE FAILED');
2266: fnd_message.set_token('REASON', x_str);
2267: fnd_msg_pub.ADD;
2268: x_return_status := fnd_api.g_ret_sts_error;
2269: ELSIF (rc = 2) THEN
2270: fnd_message.set_name('FND', 'TM-SVC LOCK HANDLE FAILED');
2271: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2272: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2273: fnd_message.set_token('REQUEST', p_group_id);
2274: fnd_message.set_token('REASON', x_str);
2267: fnd_msg_pub.ADD;
2268: x_return_status := fnd_api.g_ret_sts_error;
2269: ELSIF (rc = 2) THEN
2270: fnd_message.set_name('FND', 'TM-SVC LOCK HANDLE FAILED');
2271: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2272: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2273: fnd_message.set_token('REQUEST', p_group_id);
2274: fnd_message.set_token('REASON', x_str);
2275: fnd_msg_pub.ADD;
2268: x_return_status := fnd_api.g_ret_sts_error;
2269: ELSIF (rc = 2) THEN
2270: fnd_message.set_name('FND', 'TM-SVC LOCK HANDLE FAILED');
2271: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2272: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2273: fnd_message.set_token('REQUEST', p_group_id);
2274: fnd_message.set_token('REASON', x_str);
2275: fnd_msg_pub.ADD;
2276: x_return_status := fnd_api.g_ret_sts_error;
2269: ELSIF (rc = 2) THEN
2270: fnd_message.set_name('FND', 'TM-SVC LOCK HANDLE FAILED');
2271: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2272: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2273: fnd_message.set_token('REQUEST', p_group_id);
2274: fnd_message.set_token('REASON', x_str);
2275: fnd_msg_pub.ADD;
2276: x_return_status := fnd_api.g_ret_sts_error;
2277: ELSIF (rc = 3 or (l_outcome IN ('WARNING', 'ERROR'))) THEN
2270: fnd_message.set_name('FND', 'TM-SVC LOCK HANDLE FAILED');
2271: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2272: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2273: fnd_message.set_token('REQUEST', p_group_id);
2274: fnd_message.set_token('REASON', x_str);
2275: fnd_msg_pub.ADD;
2276: x_return_status := fnd_api.g_ret_sts_error;
2277: ELSIF (rc = 3 or (l_outcome IN ('WARNING', 'ERROR'))) THEN
2278: BEGIN
2284: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
2285: 'po_message = ' || po_message);
2286: end if;
2287:
2288: FND_MESSAGE.set_name('CSP', 'CSP_ATP');
2289: fnd_message.set_token('ERROR', po_message);
2290: fnd_msg_pub.ADD;
2291: x_return_status := fnd_api.g_ret_sts_error;
2292: Exception
2285: 'po_message = ' || po_message);
2286: end if;
2287:
2288: FND_MESSAGE.set_name('CSP', 'CSP_ATP');
2289: fnd_message.set_token('ERROR', po_message);
2290: fnd_msg_pub.ADD;
2291: x_return_status := fnd_api.g_ret_sts_error;
2292: Exception
2293: when NO_DATA_FOUND THEN
2368: else
2369: l_message := x_str;
2370: end if;
2371:
2372: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2373: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2374: fnd_message.set_token('REQUEST', p_group_id);
2375: fnd_message.set_token('REASON', l_message);
2376: fnd_msg_pub.ADD;
2369: l_message := x_str;
2370: end if;
2371:
2372: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2373: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2374: fnd_message.set_token('REQUEST', p_group_id);
2375: fnd_message.set_token('REASON', l_message);
2376: fnd_msg_pub.ADD;
2377: x_return_status := fnd_api.g_ret_sts_error;
2370: end if;
2371:
2372: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2373: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2374: fnd_message.set_token('REQUEST', p_group_id);
2375: fnd_message.set_token('REASON', l_message);
2376: fnd_msg_pub.ADD;
2377: x_return_status := fnd_api.g_ret_sts_error;
2378: END;
2371:
2372: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2373: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2374: fnd_message.set_token('REQUEST', p_group_id);
2375: fnd_message.set_token('REASON', l_message);
2376: fnd_msg_pub.ADD;
2377: x_return_status := fnd_api.g_ret_sts_error;
2378: END;
2379: END IF;
2378: END;
2379: END IF;
2380: EXCEPTION
2381: WHEN OTHERS THEN
2382: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
2383: fnd_message.set_token('ROUTINE',l_api_name,FALSE);
2384: fnd_message.set_token('SQLERRM',sqlerrm,FALSE);
2385: fnd_msg_pub.add;
2386: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2379: END IF;
2380: EXCEPTION
2381: WHEN OTHERS THEN
2382: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
2383: fnd_message.set_token('ROUTINE',l_api_name,FALSE);
2384: fnd_message.set_token('SQLERRM',sqlerrm,FALSE);
2385: fnd_msg_pub.add;
2386: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2387: END rcv_online_request;
2380: EXCEPTION
2381: WHEN OTHERS THEN
2382: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
2383: fnd_message.set_token('ROUTINE',l_api_name,FALSE);
2384: fnd_message.set_token('SQLERRM',sqlerrm,FALSE);
2385: fnd_msg_pub.add;
2386: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2387: END rcv_online_request;
2388: