145: );
146:
147: IF (p_receive_tbl (l_index).routing_header_id = -1)
148: THEN
149: fnd_message.set_name ('CSD', 'CSD_AUTO_RECV_NOT_POSSIBLE');
150: fnd_msg_pub.ADD;
151: RAISE fnd_api.g_exc_error;
152: END IF;
153:
1126: 'receiving processor, error[' || l_MESSAGE || ']'
1127: );
1128: END LOOP;
1129: END IF;
1130: --FND_MESSAGE.SET_NAME('CSD', 'CSD_RECEIVE_ERROR');
1131: --FND_MSG_PUB.ADD;
1132: --RAISE FND_API.G_EXC_ERROR;
1133: END IF;
1134:
1155: END IF;
1156:
1157: IF (check_group_id (p_request_group_id))
1158: THEN
1159: fnd_message.set_name ('FND', 'TM-TIMEOUT');
1160: l_str1 := fnd_message.get;
1161: fnd_message.CLEAR;
1162: -- use rcv_all_rcvoltm to get translated message
1163: fnd_message.set_name ('PO', 'RCV_ALL_RCVOLTM');
1156:
1157: IF (check_group_id (p_request_group_id))
1158: THEN
1159: fnd_message.set_name ('FND', 'TM-TIMEOUT');
1160: l_str1 := fnd_message.get;
1161: fnd_message.CLEAR;
1162: -- use rcv_all_rcvoltm to get translated message
1163: fnd_message.set_name ('PO', 'RCV_ALL_RCVOLTM');
1164: l_str2 := fnd_message.get;
1157: IF (check_group_id (p_request_group_id))
1158: THEN
1159: fnd_message.set_name ('FND', 'TM-TIMEOUT');
1160: l_str1 := fnd_message.get;
1161: fnd_message.CLEAR;
1162: -- use rcv_all_rcvoltm to get translated message
1163: fnd_message.set_name ('PO', 'RCV_ALL_RCVOLTM');
1164: l_str2 := fnd_message.get;
1165: fnd_message.CLEAR;
1159: fnd_message.set_name ('FND', 'TM-TIMEOUT');
1160: l_str1 := fnd_message.get;
1161: fnd_message.CLEAR;
1162: -- use rcv_all_rcvoltm to get translated message
1163: fnd_message.set_name ('PO', 'RCV_ALL_RCVOLTM');
1164: l_str2 := fnd_message.get;
1165: fnd_message.CLEAR;
1166: fnd_message.set_name ('FND', 'CONC-ERROR RUNNING STANDALONE');
1167: fnd_message.set_token ('PROGRAM', l_str2);
1160: l_str1 := fnd_message.get;
1161: fnd_message.CLEAR;
1162: -- use rcv_all_rcvoltm to get translated message
1163: fnd_message.set_name ('PO', 'RCV_ALL_RCVOLTM');
1164: l_str2 := fnd_message.get;
1165: fnd_message.CLEAR;
1166: fnd_message.set_name ('FND', 'CONC-ERROR RUNNING STANDALONE');
1167: fnd_message.set_token ('PROGRAM', l_str2);
1168: fnd_message.set_token ('REQUEST', p_request_group_id);
1161: fnd_message.CLEAR;
1162: -- use rcv_all_rcvoltm to get translated message
1163: fnd_message.set_name ('PO', 'RCV_ALL_RCVOLTM');
1164: l_str2 := fnd_message.get;
1165: fnd_message.CLEAR;
1166: fnd_message.set_name ('FND', 'CONC-ERROR RUNNING STANDALONE');
1167: fnd_message.set_token ('PROGRAM', l_str2);
1168: fnd_message.set_token ('REQUEST', p_request_group_id);
1169: fnd_message.set_token ('REASON', l_str1);
1162: -- use rcv_all_rcvoltm to get translated message
1163: fnd_message.set_name ('PO', 'RCV_ALL_RCVOLTM');
1164: l_str2 := fnd_message.get;
1165: fnd_message.CLEAR;
1166: fnd_message.set_name ('FND', 'CONC-ERROR RUNNING STANDALONE');
1167: fnd_message.set_token ('PROGRAM', l_str2);
1168: fnd_message.set_token ('REQUEST', p_request_group_id);
1169: fnd_message.set_token ('REASON', l_str1);
1170: --fnd_message.show;
1163: fnd_message.set_name ('PO', 'RCV_ALL_RCVOLTM');
1164: l_str2 := fnd_message.get;
1165: fnd_message.CLEAR;
1166: fnd_message.set_name ('FND', 'CONC-ERROR RUNNING STANDALONE');
1167: fnd_message.set_token ('PROGRAM', l_str2);
1168: fnd_message.set_token ('REQUEST', p_request_group_id);
1169: fnd_message.set_token ('REASON', l_str1);
1170: --fnd_message.show;
1171: fnd_msg_pub.ADD;
1164: l_str2 := fnd_message.get;
1165: fnd_message.CLEAR;
1166: fnd_message.set_name ('FND', 'CONC-ERROR RUNNING STANDALONE');
1167: fnd_message.set_token ('PROGRAM', l_str2);
1168: fnd_message.set_token ('REQUEST', p_request_group_id);
1169: fnd_message.set_token ('REASON', l_str1);
1170: --fnd_message.show;
1171: fnd_msg_pub.ADD;
1172: x_return_status := fnd_api.g_ret_sts_error;
1165: fnd_message.CLEAR;
1166: fnd_message.set_name ('FND', 'CONC-ERROR RUNNING STANDALONE');
1167: fnd_message.set_token ('PROGRAM', l_str2);
1168: fnd_message.set_token ('REQUEST', p_request_group_id);
1169: fnd_message.set_token ('REASON', l_str1);
1170: --fnd_message.show;
1171: fnd_msg_pub.ADD;
1172: x_return_status := fnd_api.g_ret_sts_error;
1173: END IF;
1166: fnd_message.set_name ('FND', 'CONC-ERROR RUNNING STANDALONE');
1167: fnd_message.set_token ('PROGRAM', l_str2);
1168: fnd_message.set_token ('REQUEST', p_request_group_id);
1169: fnd_message.set_token ('REASON', l_str1);
1170: --fnd_message.show;
1171: fnd_msg_pub.ADD;
1172: x_return_status := fnd_api.g_ret_sts_error;
1173: END IF;
1174: ELSIF (l_Ret_code = 2)
1189: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1190: THEN
1191: fnd_log.STRING (fnd_log.level_statement,
1192: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1193: 'Adding FND message, groupid['
1194: || TO_CHAR (p_request_group_id)
1195: || ']'
1196: );
1197: END IF;
1195: || ']'
1196: );
1197: END IF;
1198:
1199: fnd_message.set_name ('FND', 'TM-SVC LOCK HANDLE FAILED');
1200: l_str1 := fnd_message.get;
1201: fnd_message.CLEAR;
1202: fnd_message.set_name ('PO', 'RCV_ALL_RCVOLTM');
1203: l_str2 := fnd_message.get;
1196: );
1197: END IF;
1198:
1199: fnd_message.set_name ('FND', 'TM-SVC LOCK HANDLE FAILED');
1200: l_str1 := fnd_message.get;
1201: fnd_message.CLEAR;
1202: fnd_message.set_name ('PO', 'RCV_ALL_RCVOLTM');
1203: l_str2 := fnd_message.get;
1204: fnd_message.CLEAR;
1197: END IF;
1198:
1199: fnd_message.set_name ('FND', 'TM-SVC LOCK HANDLE FAILED');
1200: l_str1 := fnd_message.get;
1201: fnd_message.CLEAR;
1202: fnd_message.set_name ('PO', 'RCV_ALL_RCVOLTM');
1203: l_str2 := fnd_message.get;
1204: fnd_message.CLEAR;
1205: fnd_message.set_name ('FND', 'CONC-ERROR RUNNING STANDALONE');
1198:
1199: fnd_message.set_name ('FND', 'TM-SVC LOCK HANDLE FAILED');
1200: l_str1 := fnd_message.get;
1201: fnd_message.CLEAR;
1202: fnd_message.set_name ('PO', 'RCV_ALL_RCVOLTM');
1203: l_str2 := fnd_message.get;
1204: fnd_message.CLEAR;
1205: fnd_message.set_name ('FND', 'CONC-ERROR RUNNING STANDALONE');
1206: fnd_message.set_token ('PROGRAM', l_str2);
1199: fnd_message.set_name ('FND', 'TM-SVC LOCK HANDLE FAILED');
1200: l_str1 := fnd_message.get;
1201: fnd_message.CLEAR;
1202: fnd_message.set_name ('PO', 'RCV_ALL_RCVOLTM');
1203: l_str2 := fnd_message.get;
1204: fnd_message.CLEAR;
1205: fnd_message.set_name ('FND', 'CONC-ERROR RUNNING STANDALONE');
1206: fnd_message.set_token ('PROGRAM', l_str2);
1207: fnd_message.set_token ('REQUEST', p_request_group_id);
1200: l_str1 := fnd_message.get;
1201: fnd_message.CLEAR;
1202: fnd_message.set_name ('PO', 'RCV_ALL_RCVOLTM');
1203: l_str2 := fnd_message.get;
1204: fnd_message.CLEAR;
1205: fnd_message.set_name ('FND', 'CONC-ERROR RUNNING STANDALONE');
1206: fnd_message.set_token ('PROGRAM', l_str2);
1207: fnd_message.set_token ('REQUEST', p_request_group_id);
1208: fnd_message.set_token ('REASON', l_str1);
1201: fnd_message.CLEAR;
1202: fnd_message.set_name ('PO', 'RCV_ALL_RCVOLTM');
1203: l_str2 := fnd_message.get;
1204: fnd_message.CLEAR;
1205: fnd_message.set_name ('FND', 'CONC-ERROR RUNNING STANDALONE');
1206: fnd_message.set_token ('PROGRAM', l_str2);
1207: fnd_message.set_token ('REQUEST', p_request_group_id);
1208: fnd_message.set_token ('REASON', l_str1);
1209:
1202: fnd_message.set_name ('PO', 'RCV_ALL_RCVOLTM');
1203: l_str2 := fnd_message.get;
1204: fnd_message.CLEAR;
1205: fnd_message.set_name ('FND', 'CONC-ERROR RUNNING STANDALONE');
1206: fnd_message.set_token ('PROGRAM', l_str2);
1207: fnd_message.set_token ('REQUEST', p_request_group_id);
1208: fnd_message.set_token ('REASON', l_str1);
1209:
1210: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
1203: l_str2 := fnd_message.get;
1204: fnd_message.CLEAR;
1205: fnd_message.set_name ('FND', 'CONC-ERROR RUNNING STANDALONE');
1206: fnd_message.set_token ('PROGRAM', l_str2);
1207: fnd_message.set_token ('REQUEST', p_request_group_id);
1208: fnd_message.set_token ('REASON', l_str1);
1209:
1210: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
1211: THEN
1204: fnd_message.CLEAR;
1205: fnd_message.set_name ('FND', 'CONC-ERROR RUNNING STANDALONE');
1206: fnd_message.set_token ('PROGRAM', l_str2);
1207: fnd_message.set_token ('REQUEST', p_request_group_id);
1208: fnd_message.set_token ('REASON', l_str1);
1209:
1210: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
1211: THEN
1212: fnd_log.MESSAGE (fnd_log.level_error,
1353: THEN
1354: l_str1 := l_str1 || r_val20;
1355: END IF;
1356:
1357: FND_MESSAGE.SET_NAME('CSD','CSD_AUTO_RCV_ERROR');
1358: FND_MESSAGE.SET_TOKEN('RCV_ERROR',l_Str1);
1359: FND_MSG_PUB.add;
1360:
1361: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1354: l_str1 := l_str1 || r_val20;
1355: END IF;
1356:
1357: FND_MESSAGE.SET_NAME('CSD','CSD_AUTO_RCV_ERROR');
1358: FND_MESSAGE.SET_TOKEN('RCV_ERROR',l_Str1);
1359: FND_MSG_PUB.add;
1360:
1361: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1362: THEN