APPS.CSP_RECEIVE_PVT dependencies on FND_MESSAGE

Line 64: fnd_message.set_name('CSP','CSP_RECEIPT_NUM_EXISTS');

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;

Line 65: fnd_message.set_token('RECEIPT',x_receipt_num,false);

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:

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

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(

Line 91: fnd_message.set_token('ROUTINE',l_api_name,false);

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

Line 92: fnd_message.set_token('SQLERRM',sqlerrm,false);

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

Line 132: fnd_message.set_name('CSP','CSP_INVALID_USER_ID');

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

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

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(

Line 256: fnd_message.set_token('ROUTINE',l_api_name,false);

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

Line 257: fnd_message.set_token('SQLERRM',sqlerrm,false);

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

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

513: ,X_MSG_COUNT => X_MSG_COUNT
514: ,X_MSG_DATA => X_MESSAGE
515: ,X_RETURN_STATUS => X_RETURN_STATUS);
516: WHEN OTHERS THEN
517: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
518: fnd_message.set_token('ROUTINE',l_api_name,false);
519: fnd_message.set_token('SQLERRM',sqlerrm,false);
520: fnd_msg_pub.add;
521: get_messages(x_msg_data);

Line 518: fnd_message.set_token('ROUTINE',l_api_name,false);

514: ,X_MSG_DATA => X_MESSAGE
515: ,X_RETURN_STATUS => X_RETURN_STATUS);
516: WHEN OTHERS THEN
517: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
518: fnd_message.set_token('ROUTINE',l_api_name,false);
519: fnd_message.set_token('SQLERRM',sqlerrm,false);
520: fnd_msg_pub.add;
521: get_messages(x_msg_data);
522: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 519: fnd_message.set_token('SQLERRM',sqlerrm,false);

515: ,X_RETURN_STATUS => X_RETURN_STATUS);
516: WHEN OTHERS THEN
517: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
518: fnd_message.set_token('ROUTINE',l_api_name,false);
519: fnd_message.set_token('SQLERRM',sqlerrm,false);
520: fnd_msg_pub.add;
521: get_messages(x_msg_data);
522: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
523: P_API_NAME => L_API_NAME

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

707: ,X_MSG_COUNT => X_MSG_COUNT
708: ,X_MSG_DATA => X_MSG_DATA
709: ,X_RETURN_STATUS => X_RETURN_STATUS);
710: WHEN OTHERS THEN
711: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
712: fnd_message.set_token('ROUTINE',l_api_name,false);
713: fnd_message.set_token('SQLERRM',sqlerrm,false);
714: fnd_msg_pub.add;
715: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 712: fnd_message.set_token('ROUTINE',l_api_name,false);

708: ,X_MSG_DATA => X_MSG_DATA
709: ,X_RETURN_STATUS => X_RETURN_STATUS);
710: WHEN OTHERS THEN
711: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
712: fnd_message.set_token('ROUTINE',l_api_name,false);
713: fnd_message.set_token('SQLERRM',sqlerrm,false);
714: fnd_msg_pub.add;
715: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
716: P_API_NAME => L_API_NAME

Line 713: fnd_message.set_token('SQLERRM',sqlerrm,false);

709: ,X_RETURN_STATUS => X_RETURN_STATUS);
710: WHEN OTHERS THEN
711: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
712: fnd_message.set_token('ROUTINE',l_api_name,false);
713: fnd_message.set_token('SQLERRM',sqlerrm,false);
714: fnd_msg_pub.add;
715: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
716: P_API_NAME => L_API_NAME
717: ,P_PKG_NAME => G_PKG_NAME

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

925: , l_rcv_transaction_rec.oe_order_line_id
926: , l_rcv_transaction_rec.from_organization_id);
927: EXCEPTION
928: WHEN OTHERS THEN
929: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
930: fnd_message.set_token('ROUTINE','rcv_receipts_query_sv.post_query',false);
931: fnd_message.set_token('SQLERRM',sqlerrm,false);
932: fnd_msg_pub.add;
933: get_messages(x_msg_data);

Line 930: fnd_message.set_token('ROUTINE','rcv_receipts_query_sv.post_query',false);

926: , l_rcv_transaction_rec.from_organization_id);
927: EXCEPTION
928: WHEN OTHERS THEN
929: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
930: fnd_message.set_token('ROUTINE','rcv_receipts_query_sv.post_query',false);
931: fnd_message.set_token('SQLERRM',sqlerrm,false);
932: fnd_msg_pub.add;
933: get_messages(x_msg_data);
934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 931: fnd_message.set_token('SQLERRM',sqlerrm,false);

927: EXCEPTION
928: WHEN OTHERS THEN
929: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
930: fnd_message.set_token('ROUTINE','rcv_receipts_query_sv.post_query',false);
931: fnd_message.set_token('SQLERRM',sqlerrm,false);
932: fnd_msg_pub.add;
933: get_messages(x_msg_data);
934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
935: END;

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

948: WHERE organization_id = l_to_org_id;
949:
950: EXCEPTION
951: WHEN OTHERS THEN
952: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
953: fnd_message.set_token('ROUTINE','get receiving flag',false);
954: fnd_message.set_token('SQLERRM',sqlerrm,false);
955: fnd_msg_pub.add;
956: get_messages(x_msg_data);

Line 953: fnd_message.set_token('ROUTINE','get receiving flag',false);

949:
950: EXCEPTION
951: WHEN OTHERS THEN
952: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
953: fnd_message.set_token('ROUTINE','get receiving flag',false);
954: fnd_message.set_token('SQLERRM',sqlerrm,false);
955: fnd_msg_pub.add;
956: get_messages(x_msg_data);
957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 954: fnd_message.set_token('SQLERRM',sqlerrm,false);

950: EXCEPTION
951: WHEN OTHERS THEN
952: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
953: fnd_message.set_token('ROUTINE','get receiving flag',false);
954: fnd_message.set_token('SQLERRM',sqlerrm,false);
955: fnd_msg_pub.add;
956: get_messages(x_msg_data);
957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
958: END;

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

1437: ,X_MSG_COUNT => X_MSG_COUNT
1438: ,X_MSG_DATA => X_MESSAGE
1439: ,X_RETURN_STATUS => X_RETURN_STATUS);
1440: WHEN OTHERS THEN
1441: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
1442: fnd_message.set_token('ROUTINE',l_api_name,false);
1443: fnd_message.set_token('SQLERRM',sqlerrm,false);
1444: fnd_msg_pub.add;
1445: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 1442: fnd_message.set_token('ROUTINE',l_api_name,false);

1438: ,X_MSG_DATA => X_MESSAGE
1439: ,X_RETURN_STATUS => X_RETURN_STATUS);
1440: WHEN OTHERS THEN
1441: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
1442: fnd_message.set_token('ROUTINE',l_api_name,false);
1443: fnd_message.set_token('SQLERRM',sqlerrm,false);
1444: fnd_msg_pub.add;
1445: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1446: P_API_NAME => L_API_NAME

Line 1443: fnd_message.set_token('SQLERRM',sqlerrm,false);

1439: ,X_RETURN_STATUS => X_RETURN_STATUS);
1440: WHEN OTHERS THEN
1441: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
1442: fnd_message.set_token('ROUTINE',l_api_name,false);
1443: fnd_message.set_token('SQLERRM',sqlerrm,false);
1444: fnd_msg_pub.add;
1445: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1446: P_API_NAME => L_API_NAME
1447: ,P_PKG_NAME => G_PKG_NAME

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

1912: ,X_MSG_COUNT => X_MSG_COUNT
1913: ,X_MSG_DATA => X_MESSAGE
1914: ,X_RETURN_STATUS => X_RETURN_STATUS);
1915: WHEN OTHERS THEN
1916: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
1917: fnd_message.set_token('ROUTINE',l_api_name,false);
1918: fnd_message.set_token('SQLERRM',sqlerrm,false);
1919: fnd_msg_pub.add;
1920: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 1917: fnd_message.set_token('ROUTINE',l_api_name,false);

1913: ,X_MSG_DATA => X_MESSAGE
1914: ,X_RETURN_STATUS => X_RETURN_STATUS);
1915: WHEN OTHERS THEN
1916: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
1917: fnd_message.set_token('ROUTINE',l_api_name,false);
1918: fnd_message.set_token('SQLERRM',sqlerrm,false);
1919: fnd_msg_pub.add;
1920: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1921: P_API_NAME => L_API_NAME

Line 1918: fnd_message.set_token('SQLERRM',sqlerrm,false);

1914: ,X_RETURN_STATUS => X_RETURN_STATUS);
1915: WHEN OTHERS THEN
1916: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
1917: fnd_message.set_token('ROUTINE',l_api_name,false);
1918: fnd_message.set_token('SQLERRM',sqlerrm,false);
1919: fnd_msg_pub.add;
1920: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1921: P_API_NAME => L_API_NAME
1922: ,P_PKG_NAME => G_PKG_NAME

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

2070: ,X_MSG_COUNT => X_MSG_COUNT
2071: ,X_MSG_DATA => X_MESSAGE
2072: ,X_RETURN_STATUS => X_RETURN_STATUS);
2073: WHEN OTHERS THEN
2074: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
2075: fnd_message.set_token('ROUTINE',l_api_name,false);
2076: fnd_message.set_token('SQLERRM',sqlerrm,false);
2077: fnd_msg_pub.add;
2078: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 2075: fnd_message.set_token('ROUTINE',l_api_name,false);

2071: ,X_MSG_DATA => X_MESSAGE
2072: ,X_RETURN_STATUS => X_RETURN_STATUS);
2073: WHEN OTHERS THEN
2074: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
2075: fnd_message.set_token('ROUTINE',l_api_name,false);
2076: fnd_message.set_token('SQLERRM',sqlerrm,false);
2077: fnd_msg_pub.add;
2078: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2079: P_API_NAME => L_API_NAME

Line 2076: fnd_message.set_token('SQLERRM',sqlerrm,false);

2072: ,X_RETURN_STATUS => X_RETURN_STATUS);
2073: WHEN OTHERS THEN
2074: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
2075: fnd_message.set_token('ROUTINE',l_api_name,false);
2076: fnd_message.set_token('SQLERRM',sqlerrm,false);
2077: fnd_msg_pub.add;
2078: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2079: P_API_NAME => L_API_NAME
2080: ,P_PKG_NAME => G_PKG_NAME

Line 2143: fnd_message.set_name('FND', 'TM-TIMEOUT');

2139: UTL_FILE.PUT_LINE(debug_handler,'l_message ' || l_message);
2140: UTL_FILE.FCLOSE(debug_handler);
2141: END IF;*/
2142: IF (rc = 1) THEN
2143: fnd_message.set_name('FND', 'TM-TIMEOUT');
2144: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2145: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2146: fnd_message.set_token('REQUEST', p_group_id);
2147: fnd_message.set_token('REASON', x_str);

Line 2144: FND_MESSAGE.set_name('FND','CONC-Error running standalone');

2140: UTL_FILE.FCLOSE(debug_handler);
2141: END IF;*/
2142: IF (rc = 1) THEN
2143: fnd_message.set_name('FND', 'TM-TIMEOUT');
2144: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2145: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2146: fnd_message.set_token('REQUEST', p_group_id);
2147: fnd_message.set_token('REASON', x_str);
2148: fnd_msg_pub.ADD;

Line 2145: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');

2141: END IF;*/
2142: IF (rc = 1) THEN
2143: fnd_message.set_name('FND', 'TM-TIMEOUT');
2144: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2145: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2146: fnd_message.set_token('REQUEST', p_group_id);
2147: fnd_message.set_token('REASON', x_str);
2148: fnd_msg_pub.ADD;
2149: x_return_status := fnd_api.g_ret_sts_error;

Line 2146: fnd_message.set_token('REQUEST', p_group_id);

2142: IF (rc = 1) THEN
2143: fnd_message.set_name('FND', 'TM-TIMEOUT');
2144: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2145: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2146: fnd_message.set_token('REQUEST', p_group_id);
2147: fnd_message.set_token('REASON', x_str);
2148: fnd_msg_pub.ADD;
2149: x_return_status := fnd_api.g_ret_sts_error;
2150: ELSIF (rc = 2) THEN

Line 2147: fnd_message.set_token('REASON', x_str);

2143: fnd_message.set_name('FND', 'TM-TIMEOUT');
2144: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2145: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2146: fnd_message.set_token('REQUEST', p_group_id);
2147: fnd_message.set_token('REASON', x_str);
2148: fnd_msg_pub.ADD;
2149: x_return_status := fnd_api.g_ret_sts_error;
2150: ELSIF (rc = 2) THEN
2151: fnd_message.set_name('FND', 'TM-SVC LOCK HANDLE FAILED');

Line 2151: fnd_message.set_name('FND', 'TM-SVC LOCK HANDLE FAILED');

2147: fnd_message.set_token('REASON', x_str);
2148: fnd_msg_pub.ADD;
2149: x_return_status := fnd_api.g_ret_sts_error;
2150: ELSIF (rc = 2) THEN
2151: fnd_message.set_name('FND', 'TM-SVC LOCK HANDLE FAILED');
2152: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2153: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2154: fnd_message.set_token('REQUEST', p_group_id);
2155: fnd_message.set_token('REASON', x_str);

Line 2152: FND_MESSAGE.set_name('FND','CONC-Error running standalone');

2148: fnd_msg_pub.ADD;
2149: x_return_status := fnd_api.g_ret_sts_error;
2150: ELSIF (rc = 2) THEN
2151: fnd_message.set_name('FND', 'TM-SVC LOCK HANDLE FAILED');
2152: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2153: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2154: fnd_message.set_token('REQUEST', p_group_id);
2155: fnd_message.set_token('REASON', x_str);
2156: fnd_msg_pub.ADD;

Line 2153: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');

2149: x_return_status := fnd_api.g_ret_sts_error;
2150: ELSIF (rc = 2) THEN
2151: fnd_message.set_name('FND', 'TM-SVC LOCK HANDLE FAILED');
2152: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2153: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2154: fnd_message.set_token('REQUEST', p_group_id);
2155: fnd_message.set_token('REASON', x_str);
2156: fnd_msg_pub.ADD;
2157: x_return_status := fnd_api.g_ret_sts_error;

Line 2154: fnd_message.set_token('REQUEST', p_group_id);

2150: ELSIF (rc = 2) THEN
2151: fnd_message.set_name('FND', 'TM-SVC LOCK HANDLE FAILED');
2152: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2153: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2154: fnd_message.set_token('REQUEST', p_group_id);
2155: fnd_message.set_token('REASON', x_str);
2156: fnd_msg_pub.ADD;
2157: x_return_status := fnd_api.g_ret_sts_error;
2158: ELSIF (rc = 3 or

Line 2155: fnd_message.set_token('REASON', x_str);

2151: fnd_message.set_name('FND', 'TM-SVC LOCK HANDLE FAILED');
2152: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2153: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2154: fnd_message.set_token('REQUEST', p_group_id);
2155: fnd_message.set_token('REASON', x_str);
2156: fnd_msg_pub.ADD;
2157: x_return_status := fnd_api.g_ret_sts_error;
2158: ELSIF (rc = 3 or
2159: (l_outcome IN ('WARNING', 'ERROR'))) THEN

Line 2168: FND_MESSAGE.set_name('CSP','CSP_PO_RECEIVE_ERROR');

2164: where BATCH_ID = p_group_id
2165: and TABLE_NAME = 'RCV_HEADERS_INTERFACE'
2166: and pie.interface_header_id = rhi.header_interface_id
2167: and PROCESSING_STATUS_CODE = 'ERROR' ;
2168: FND_MESSAGE.set_name('CSP','CSP_PO_RECEIVE_ERROR');
2169: fnd_message.set_token('ERROR_MESSAGE', po_message );
2170: fnd_msg_pub.ADD;
2171: x_return_status := fnd_api.g_ret_sts_error;
2172: Exception

Line 2169: fnd_message.set_token('ERROR_MESSAGE', po_message );

2165: and TABLE_NAME = 'RCV_HEADERS_INTERFACE'
2166: and pie.interface_header_id = rhi.header_interface_id
2167: and PROCESSING_STATUS_CODE = 'ERROR' ;
2168: FND_MESSAGE.set_name('CSP','CSP_PO_RECEIVE_ERROR');
2169: fnd_message.set_token('ERROR_MESSAGE', po_message );
2170: fnd_msg_pub.ADD;
2171: x_return_status := fnd_api.g_ret_sts_error;
2172: Exception
2173: when NO_DATA_FOUND THEN

Line 2260: FND_MESSAGE.set_name('FND','CONC-Error running standalone');

2256: END IF;
2257: IF (r_val20 IS NOT NULL) THEN
2258: x_str := x_str || ' ' || r_val20;
2259: END IF;
2260: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2261: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2262: fnd_message.set_token('REQUEST', p_group_id);
2263: fnd_message.set_token('REASON', x_str);
2264: fnd_msg_pub.ADD;

Line 2261: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');

2257: IF (r_val20 IS NOT NULL) THEN
2258: x_str := x_str || ' ' || r_val20;
2259: END IF;
2260: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2261: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2262: fnd_message.set_token('REQUEST', p_group_id);
2263: fnd_message.set_token('REASON', x_str);
2264: fnd_msg_pub.ADD;
2265: x_return_status := fnd_api.g_ret_sts_error;

Line 2262: fnd_message.set_token('REQUEST', p_group_id);

2258: x_str := x_str || ' ' || r_val20;
2259: END IF;
2260: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2261: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2262: fnd_message.set_token('REQUEST', p_group_id);
2263: fnd_message.set_token('REASON', x_str);
2264: fnd_msg_pub.ADD;
2265: x_return_status := fnd_api.g_ret_sts_error;
2266: END;

Line 2263: fnd_message.set_token('REASON', x_str);

2259: END IF;
2260: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2261: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2262: fnd_message.set_token('REQUEST', p_group_id);
2263: fnd_message.set_token('REASON', x_str);
2264: fnd_msg_pub.ADD;
2265: x_return_status := fnd_api.g_ret_sts_error;
2266: END;
2267: END IF;

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

2266: END;
2267: END IF;
2268: EXCEPTION
2269: WHEN OTHERS THEN
2270: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
2271: fnd_message.set_token('ROUTINE',l_api_name,FALSE);
2272: fnd_message.set_token('SQLERRM',sqlerrm,FALSE);
2273: fnd_msg_pub.add;
2274: x_return_status := fnd_api.g_ret_sts_unexp_error ;

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

2267: END IF;
2268: EXCEPTION
2269: WHEN OTHERS THEN
2270: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
2271: fnd_message.set_token('ROUTINE',l_api_name,FALSE);
2272: fnd_message.set_token('SQLERRM',sqlerrm,FALSE);
2273: fnd_msg_pub.add;
2274: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2275: END rcv_online_request;

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

2268: EXCEPTION
2269: WHEN OTHERS THEN
2270: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
2271: fnd_message.set_token('ROUTINE',l_api_name,FALSE);
2272: fnd_message.set_token('SQLERRM',sqlerrm,FALSE);
2273: fnd_msg_pub.add;
2274: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2275: END rcv_online_request;
2276: