APPS.HZ_BES_BO_GEN_PKG dependencies on FND_MESSAGE

Line 142: FND_MESSAGE.SET_NAME('AR', p_message);

138: p_tkn2_name IN VARCHAR2 DEFAULT NULL,
139: p_tkn2_val IN VARCHAR2 DEFAULT NULL
140: ) IS
141: BEGIN
142: FND_MESSAGE.SET_NAME('AR', p_message);
143: IF (p_tkn1_name IS NOT NULL) THEN
144: fnd_message.set_token(p_tkn1_name, p_tkn1_val);
145: END IF;
146: IF (p_tkn2_name IS NOT NULL) THEN

Line 144: fnd_message.set_token(p_tkn1_name, p_tkn1_val);

140: ) IS
141: BEGIN
142: FND_MESSAGE.SET_NAME('AR', p_message);
143: IF (p_tkn1_name IS NOT NULL) THEN
144: fnd_message.set_token(p_tkn1_name, p_tkn1_val);
145: END IF;
146: IF (p_tkn2_name IS NOT NULL) THEN
147: fnd_message.set_token(p_tkn2_name, p_tkn2_val);
148: END IF;

Line 147: fnd_message.set_token(p_tkn2_name, p_tkn2_val);

143: IF (p_tkn1_name IS NOT NULL) THEN
144: fnd_message.set_token(p_tkn1_name, p_tkn1_val);
145: END IF;
146: IF (p_tkn2_name IS NOT NULL) THEN
147: fnd_message.set_token(p_tkn2_name, p_tkn2_val);
148: END IF;
149: FND_MSG_PUB.ADD;
150: FND_MSG_PUB.Reset;
151:

Line 173: FND_MESSAGE.SET_NAME('AR', p_message);

169: p_tkn2_name IN VARCHAR2 DEFAULT NULL,
170: p_tkn2_val IN VARCHAR2 DEFAULT NULL
171: ) IS
172: BEGIN
173: FND_MESSAGE.SET_NAME('AR', p_message);
174: IF (p_tkn1_name IS NOT NULL) THEN
175: fnd_message.set_token(p_tkn1_name, p_tkn1_val);
176: END IF;
177: IF (p_tkn2_name IS NOT NULL) THEN

Line 175: fnd_message.set_token(p_tkn1_name, p_tkn1_val);

171: ) IS
172: BEGIN
173: FND_MESSAGE.SET_NAME('AR', p_message);
174: IF (p_tkn1_name IS NOT NULL) THEN
175: fnd_message.set_token(p_tkn1_name, p_tkn1_val);
176: END IF;
177: IF (p_tkn2_name IS NOT NULL) THEN
178: fnd_message.set_token(p_tkn2_name, p_tkn2_val);
179: END IF;

Line 178: fnd_message.set_token(p_tkn2_name, p_tkn2_val);

174: IF (p_tkn1_name IS NOT NULL) THEN
175: fnd_message.set_token(p_tkn1_name, p_tkn1_val);
176: END IF;
177: IF (p_tkn2_name IS NOT NULL) THEN
178: fnd_message.set_token(p_tkn2_name, p_tkn2_val);
179: END IF;
180: FND_MSG_PUB.ADD;
181: FND_MSG_PUB.Reset;
182:

Line 204: FND_MESSAGE.SET_NAME('AR', p_message);

200: p_tkn2_name IN VARCHAR2 DEFAULT NULL,
201: p_tkn2_val IN VARCHAR2 DEFAULT NULL
202: ) IS
203: BEGIN
204: FND_MESSAGE.SET_NAME('AR', p_message);
205: IF (p_tkn1_name IS NOT NULL) THEN
206: fnd_message.set_token(p_tkn1_name, p_tkn1_val);
207: END IF;
208: IF (p_tkn2_name IS NOT NULL) THEN

Line 206: fnd_message.set_token(p_tkn1_name, p_tkn1_val);

202: ) IS
203: BEGIN
204: FND_MESSAGE.SET_NAME('AR', p_message);
205: IF (p_tkn1_name IS NOT NULL) THEN
206: fnd_message.set_token(p_tkn1_name, p_tkn1_val);
207: END IF;
208: IF (p_tkn2_name IS NOT NULL) THEN
209: fnd_message.set_token(p_tkn2_name, p_tkn2_val);
210: END IF;

Line 209: fnd_message.set_token(p_tkn2_name, p_tkn2_val);

205: IF (p_tkn1_name IS NOT NULL) THEN
206: fnd_message.set_token(p_tkn1_name, p_tkn1_val);
207: END IF;
208: IF (p_tkn2_name IS NOT NULL) THEN
209: fnd_message.set_token(p_tkn2_name, p_tkn2_val);
210: END IF;
211: FND_MSG_PUB.ADD;
212: FND_MSG_PUB.Reset;
213:

Line 1064: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1060: l2i(G_HZ_CERT_P);
1061: END IF;
1062: ELSE
1063: IF P_SQL_FOR = 'EVENT' THEN
1064: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1065: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1066: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1067: fnd_msg_pub.ADD;
1068: RAISE FND_API.G_EXC_ERROR;

Line 1065: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1061: END IF;
1062: ELSE
1063: IF P_SQL_FOR = 'EVENT' THEN
1064: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1065: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1066: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1067: fnd_msg_pub.ADD;
1068: RAISE FND_API.G_EXC_ERROR;
1069: ELSE

Line 1066: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

1062: ELSE
1063: IF P_SQL_FOR = 'EVENT' THEN
1064: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1065: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1066: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1067: fnd_msg_pub.ADD;
1068: RAISE FND_API.G_EXC_ERROR;
1069: ELSE
1070: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1070: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1066: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1067: fnd_msg_pub.ADD;
1068: RAISE FND_API.G_EXC_ERROR;
1069: ELSE
1070: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1071: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1072: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1073: fnd_msg_pub.ADD;
1074: RAISE FND_API.G_EXC_ERROR;

Line 1071: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1067: fnd_msg_pub.ADD;
1068: RAISE FND_API.G_EXC_ERROR;
1069: ELSE
1070: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1071: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1072: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1073: fnd_msg_pub.ADD;
1074: RAISE FND_API.G_EXC_ERROR;
1075: END IF;

Line 1072: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

1068: RAISE FND_API.G_EXC_ERROR;
1069: ELSE
1070: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1071: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1072: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1073: fnd_msg_pub.ADD;
1074: RAISE FND_API.G_EXC_ERROR;
1075: END IF;
1076: END IF;

Line 1088: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1084: l2i(G_HZ_CITIZEN_P);
1085: END IF;
1086: ELSE
1087: IF P_SQL_FOR = 'EVENT' THEN
1088: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1089: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1090: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1091: fnd_msg_pub.ADD;
1092: RAISE FND_API.G_EXC_ERROR;

Line 1089: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1085: END IF;
1086: ELSE
1087: IF P_SQL_FOR = 'EVENT' THEN
1088: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1089: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1090: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1091: fnd_msg_pub.ADD;
1092: RAISE FND_API.G_EXC_ERROR;
1093: ELSE

Line 1090: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

1086: ELSE
1087: IF P_SQL_FOR = 'EVENT' THEN
1088: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1089: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1090: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1091: fnd_msg_pub.ADD;
1092: RAISE FND_API.G_EXC_ERROR;
1093: ELSE
1094: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1094: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1090: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1091: fnd_msg_pub.ADD;
1092: RAISE FND_API.G_EXC_ERROR;
1093: ELSE
1094: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1095: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1096: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1097: fnd_msg_pub.ADD;
1098: RAISE FND_API.G_EXC_ERROR;

Line 1095: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1091: fnd_msg_pub.ADD;
1092: RAISE FND_API.G_EXC_ERROR;
1093: ELSE
1094: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1095: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1096: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1097: fnd_msg_pub.ADD;
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;

Line 1096: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

1092: RAISE FND_API.G_EXC_ERROR;
1093: ELSE
1094: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1095: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1096: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1097: fnd_msg_pub.ADD;
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;
1100: END IF;

Line 1112: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1108: l2i(G_HZ_CODE_ASSIGN_P);
1109: END IF;
1110: ELSE
1111: IF P_SQL_FOR = 'EVENT' THEN
1112: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1113: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1114: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1115: fnd_msg_pub.ADD;
1116: RAISE FND_API.G_EXC_ERROR;

Line 1113: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1109: END IF;
1110: ELSE
1111: IF P_SQL_FOR = 'EVENT' THEN
1112: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1113: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1114: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1115: fnd_msg_pub.ADD;
1116: RAISE FND_API.G_EXC_ERROR;
1117: ELSE

Line 1114: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

1110: ELSE
1111: IF P_SQL_FOR = 'EVENT' THEN
1112: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1113: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1114: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1115: fnd_msg_pub.ADD;
1116: RAISE FND_API.G_EXC_ERROR;
1117: ELSE
1118: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1118: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1114: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1115: fnd_msg_pub.ADD;
1116: RAISE FND_API.G_EXC_ERROR;
1117: ELSE
1118: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1119: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1120: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1121: fnd_msg_pub.ADD;
1122: RAISE FND_API.G_EXC_ERROR;

Line 1119: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1115: fnd_msg_pub.ADD;
1116: RAISE FND_API.G_EXC_ERROR;
1117: ELSE
1118: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1119: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1120: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1121: fnd_msg_pub.ADD;
1122: RAISE FND_API.G_EXC_ERROR;
1123: END IF;

Line 1120: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

1116: RAISE FND_API.G_EXC_ERROR;
1117: ELSE
1118: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1119: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1120: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1121: fnd_msg_pub.ADD;
1122: RAISE FND_API.G_EXC_ERROR;
1123: END IF;
1124: END IF;

Line 1181: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_BOCODE');

1177: l2i(G_CP_TLX);
1178: END IF;
1179: ELSE
1180: IF P_SQL_FOR = 'EVENT' THEN
1181: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_BOCODE');
1182: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1183: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1184: fnd_msg_pub.ADD;
1185: RAISE FND_API.G_EXC_ERROR;

Line 1182: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1178: END IF;
1179: ELSE
1180: IF P_SQL_FOR = 'EVENT' THEN
1181: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_BOCODE');
1182: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1183: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1184: fnd_msg_pub.ADD;
1185: RAISE FND_API.G_EXC_ERROR;
1186: ELSE

Line 1183: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);

1179: ELSE
1180: IF P_SQL_FOR = 'EVENT' THEN
1181: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_BOCODE');
1182: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1183: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1184: fnd_msg_pub.ADD;
1185: RAISE FND_API.G_EXC_ERROR;
1186: ELSE
1187: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_BOCODE');

Line 1187: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_BOCODE');

1183: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1184: fnd_msg_pub.ADD;
1185: RAISE FND_API.G_EXC_ERROR;
1186: ELSE
1187: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_BOCODE');
1188: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1189: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1190: fnd_msg_pub.ADD;
1191: RAISE FND_API.G_EXC_ERROR;

Line 1188: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1184: fnd_msg_pub.ADD;
1185: RAISE FND_API.G_EXC_ERROR;
1186: ELSE
1187: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_BOCODE');
1188: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1189: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1190: fnd_msg_pub.ADD;
1191: RAISE FND_API.G_EXC_ERROR;
1192: END IF;

Line 1189: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);

1185: RAISE FND_API.G_EXC_ERROR;
1186: ELSE
1187: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_BOCODE');
1188: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1189: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1190: fnd_msg_pub.ADD;
1191: RAISE FND_API.G_EXC_ERROR;
1192: END IF;
1193: END CASE;

Line 1231: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_BOCODE');

1227: l2i(G_CP_SMS);
1228: END IF;
1229: ELSE
1230: IF P_SQL_FOR = 'EVENT' THEN
1231: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_BOCODE');
1232: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1233: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1234: fnd_msg_pub.ADD;
1235: RAISE FND_API.G_EXC_ERROR;

Line 1232: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1228: END IF;
1229: ELSE
1230: IF P_SQL_FOR = 'EVENT' THEN
1231: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_BOCODE');
1232: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1233: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1234: fnd_msg_pub.ADD;
1235: RAISE FND_API.G_EXC_ERROR;
1236: ELSE

Line 1233: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);

1229: ELSE
1230: IF P_SQL_FOR = 'EVENT' THEN
1231: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_BOCODE');
1232: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1233: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1234: fnd_msg_pub.ADD;
1235: RAISE FND_API.G_EXC_ERROR;
1236: ELSE
1237: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_BOCODE');

Line 1237: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_BOCODE');

1233: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1234: fnd_msg_pub.ADD;
1235: RAISE FND_API.G_EXC_ERROR;
1236: ELSE
1237: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_BOCODE');
1238: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1239: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1240: fnd_msg_pub.ADD;
1241: RAISE FND_API.G_EXC_ERROR;

Line 1238: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1234: fnd_msg_pub.ADD;
1235: RAISE FND_API.G_EXC_ERROR;
1236: ELSE
1237: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_BOCODE');
1238: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1239: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1240: fnd_msg_pub.ADD;
1241: RAISE FND_API.G_EXC_ERROR;
1242: END IF;

Line 1239: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);

1235: RAISE FND_API.G_EXC_ERROR;
1236: ELSE
1237: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_BOCODE');
1238: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1239: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1240: fnd_msg_pub.ADD;
1241: RAISE FND_API.G_EXC_ERROR;
1242: END IF;
1243: END CASE;

Line 1294: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_BOCODE');

1290: l2i(G_CP_SMS);
1291: END IF;
1292: ELSE
1293: IF P_SQL_FOR = 'EVENT' THEN
1294: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_BOCODE');
1295: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1296: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1297: fnd_msg_pub.ADD;
1298: RAISE FND_API.G_EXC_ERROR;

Line 1295: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1291: END IF;
1292: ELSE
1293: IF P_SQL_FOR = 'EVENT' THEN
1294: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_BOCODE');
1295: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1296: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1297: fnd_msg_pub.ADD;
1298: RAISE FND_API.G_EXC_ERROR;
1299: ELSE

Line 1296: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);

1292: ELSE
1293: IF P_SQL_FOR = 'EVENT' THEN
1294: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_BOCODE');
1295: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1296: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1297: fnd_msg_pub.ADD;
1298: RAISE FND_API.G_EXC_ERROR;
1299: ELSE
1300: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_BOCODE');

Line 1300: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_BOCODE');

1296: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1297: fnd_msg_pub.ADD;
1298: RAISE FND_API.G_EXC_ERROR;
1299: ELSE
1300: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_BOCODE');
1301: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1302: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1303: fnd_msg_pub.ADD;
1304: RAISE FND_API.G_EXC_ERROR;

Line 1301: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1297: fnd_msg_pub.ADD;
1298: RAISE FND_API.G_EXC_ERROR;
1299: ELSE
1300: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_BOCODE');
1301: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1302: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1303: fnd_msg_pub.ADD;
1304: RAISE FND_API.G_EXC_ERROR;
1305: END IF;

Line 1302: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);

1298: RAISE FND_API.G_EXC_ERROR;
1299: ELSE
1300: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_BOCODE');
1301: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1302: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1303: fnd_msg_pub.ADD;
1304: RAISE FND_API.G_EXC_ERROR;
1305: END IF;
1306: END CASE;

Line 1344: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_BOCODE');

1340: l2i(G_CP_WEB);
1341: END IF;
1342: ELSE
1343: IF P_SQL_FOR = 'EVENT' THEN
1344: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_BOCODE');
1345: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1346: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1347: fnd_msg_pub.ADD;
1348: RAISE FND_API.G_EXC_ERROR;

Line 1345: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1341: END IF;
1342: ELSE
1343: IF P_SQL_FOR = 'EVENT' THEN
1344: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_BOCODE');
1345: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1346: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1347: fnd_msg_pub.ADD;
1348: RAISE FND_API.G_EXC_ERROR;
1349: ELSE

Line 1346: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);

1342: ELSE
1343: IF P_SQL_FOR = 'EVENT' THEN
1344: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_BOCODE');
1345: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1346: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1347: fnd_msg_pub.ADD;
1348: RAISE FND_API.G_EXC_ERROR;
1349: ELSE
1350: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_BOCODE');

Line 1350: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_BOCODE');

1346: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1347: fnd_msg_pub.ADD;
1348: RAISE FND_API.G_EXC_ERROR;
1349: ELSE
1350: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_BOCODE');
1351: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1352: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1353: fnd_msg_pub.ADD;
1354: RAISE FND_API.G_EXC_ERROR;

Line 1351: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1347: fnd_msg_pub.ADD;
1348: RAISE FND_API.G_EXC_ERROR;
1349: ELSE
1350: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_BOCODE');
1351: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1352: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1353: fnd_msg_pub.ADD;
1354: RAISE FND_API.G_EXC_ERROR;
1355: END IF;

Line 1352: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);

1348: RAISE FND_API.G_EXC_ERROR;
1349: ELSE
1350: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_BOCODE');
1351: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1352: fnd_message.set_token('BO_CODE' ,l_node_tbl(i).BO_CODE);
1353: fnd_msg_pub.ADD;
1354: RAISE FND_API.G_EXC_ERROR;
1355: END IF;
1356: END CASE;

Line 1359: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1355: END IF;
1356: END CASE;
1357: ELSE
1358: IF P_SQL_FOR = 'EVENT' THEN
1359: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1360: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1361: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1362: fnd_msg_pub.ADD;
1363: RAISE FND_API.G_EXC_ERROR;

Line 1360: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1356: END CASE;
1357: ELSE
1358: IF P_SQL_FOR = 'EVENT' THEN
1359: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1360: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1361: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1362: fnd_msg_pub.ADD;
1363: RAISE FND_API.G_EXC_ERROR;
1364: ELSE

Line 1361: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

1357: ELSE
1358: IF P_SQL_FOR = 'EVENT' THEN
1359: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1360: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1361: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1362: fnd_msg_pub.ADD;
1363: RAISE FND_API.G_EXC_ERROR;
1364: ELSE
1365: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1365: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1361: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1362: fnd_msg_pub.ADD;
1363: RAISE FND_API.G_EXC_ERROR;
1364: ELSE
1365: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1366: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1367: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1368: fnd_msg_pub.ADD;
1369: RAISE FND_API.G_EXC_ERROR;

Line 1366: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1362: fnd_msg_pub.ADD;
1363: RAISE FND_API.G_EXC_ERROR;
1364: ELSE
1365: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1366: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1367: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1368: fnd_msg_pub.ADD;
1369: RAISE FND_API.G_EXC_ERROR;
1370: END IF;

Line 1367: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

1363: RAISE FND_API.G_EXC_ERROR;
1364: ELSE
1365: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1366: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1367: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1368: fnd_msg_pub.ADD;
1369: RAISE FND_API.G_EXC_ERROR;
1370: END IF;
1371: END CASE; -- CP

Line 1454: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1450: l2i(G_HZ_CONT_PREF_CP);
1451: END IF;
1452: ELSE
1453: IF P_SQL_FOR = 'EVENT' THEN
1454: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1455: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1456: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1457: fnd_msg_pub.ADD;
1458: RAISE FND_API.G_EXC_ERROR;

Line 1455: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1451: END IF;
1452: ELSE
1453: IF P_SQL_FOR = 'EVENT' THEN
1454: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1455: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1456: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1457: fnd_msg_pub.ADD;
1458: RAISE FND_API.G_EXC_ERROR;
1459: ELSE

Line 1456: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

1452: ELSE
1453: IF P_SQL_FOR = 'EVENT' THEN
1454: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1455: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1456: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1457: fnd_msg_pub.ADD;
1458: RAISE FND_API.G_EXC_ERROR;
1459: ELSE
1460: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1460: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1456: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1457: fnd_msg_pub.ADD;
1458: RAISE FND_API.G_EXC_ERROR;
1459: ELSE
1460: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1461: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1462: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1463: fnd_msg_pub.ADD;
1464: RAISE FND_API.G_EXC_ERROR;

Line 1461: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1457: fnd_msg_pub.ADD;
1458: RAISE FND_API.G_EXC_ERROR;
1459: ELSE
1460: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1461: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1462: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1463: fnd_msg_pub.ADD;
1464: RAISE FND_API.G_EXC_ERROR;
1465: END IF;

Line 1462: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

1458: RAISE FND_API.G_EXC_ERROR;
1459: ELSE
1460: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1461: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1462: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1463: fnd_msg_pub.ADD;
1464: RAISE FND_API.G_EXC_ERROR;
1465: END IF;
1466: END CASE; --cpp

Line 1478: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1474: l2i(G_HZ_CREDIT_RATINGS_P);
1475: END IF;
1476: ELSE
1477: IF P_SQL_FOR = 'EVENT' THEN
1478: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1479: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1480: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1481: fnd_msg_pub.ADD;
1482: RAISE FND_API.G_EXC_ERROR;

Line 1479: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1475: END IF;
1476: ELSE
1477: IF P_SQL_FOR = 'EVENT' THEN
1478: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1479: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1480: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1481: fnd_msg_pub.ADD;
1482: RAISE FND_API.G_EXC_ERROR;
1483: ELSE

Line 1480: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

1476: ELSE
1477: IF P_SQL_FOR = 'EVENT' THEN
1478: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1479: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1480: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1481: fnd_msg_pub.ADD;
1482: RAISE FND_API.G_EXC_ERROR;
1483: ELSE
1484: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1484: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1480: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1481: fnd_msg_pub.ADD;
1482: RAISE FND_API.G_EXC_ERROR;
1483: ELSE
1484: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1485: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1486: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1487: fnd_msg_pub.ADD;
1488: RAISE FND_API.G_EXC_ERROR;

Line 1485: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1481: fnd_msg_pub.ADD;
1482: RAISE FND_API.G_EXC_ERROR;
1483: ELSE
1484: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1485: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1486: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1487: fnd_msg_pub.ADD;
1488: RAISE FND_API.G_EXC_ERROR;
1489: END IF;

Line 1486: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

1482: RAISE FND_API.G_EXC_ERROR;
1483: ELSE
1484: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1485: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1486: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1487: fnd_msg_pub.ADD;
1488: RAISE FND_API.G_EXC_ERROR;
1489: END IF;
1490: END IF;

Line 1510: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1506: l2i(G_HZ_CUST_ACCT_ROLES_AS);
1507: END IF;
1508: ELSE
1509: IF P_SQL_FOR = 'EVENT' THEN
1510: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1511: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1512: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1513: fnd_msg_pub.ADD;
1514: RAISE FND_API.G_EXC_ERROR;

Line 1511: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1507: END IF;
1508: ELSE
1509: IF P_SQL_FOR = 'EVENT' THEN
1510: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1511: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1512: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1513: fnd_msg_pub.ADD;
1514: RAISE FND_API.G_EXC_ERROR;
1515: ELSE

Line 1512: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

1508: ELSE
1509: IF P_SQL_FOR = 'EVENT' THEN
1510: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1511: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1512: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1513: fnd_msg_pub.ADD;
1514: RAISE FND_API.G_EXC_ERROR;
1515: ELSE
1516: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1516: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1512: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1513: fnd_msg_pub.ADD;
1514: RAISE FND_API.G_EXC_ERROR;
1515: ELSE
1516: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1517: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1518: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1519: fnd_msg_pub.ADD;
1520: RAISE FND_API.G_EXC_ERROR;

Line 1517: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1513: fnd_msg_pub.ADD;
1514: RAISE FND_API.G_EXC_ERROR;
1515: ELSE
1516: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1517: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1518: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1519: fnd_msg_pub.ADD;
1520: RAISE FND_API.G_EXC_ERROR;
1521: END IF;

Line 1518: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

1514: RAISE FND_API.G_EXC_ERROR;
1515: ELSE
1516: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1517: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1518: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1519: fnd_msg_pub.ADD;
1520: RAISE FND_API.G_EXC_ERROR;
1521: END IF;
1522: END CASE; -- cust_acct_roles

Line 1534: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1530: l2i(G_HZ_CUST_ACCTS_P);
1531: END IF;
1532: ELSE
1533: IF P_SQL_FOR = 'EVENT' THEN
1534: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1535: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1536: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1537: fnd_msg_pub.ADD;
1538: RAISE FND_API.G_EXC_ERROR;

Line 1535: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1531: END IF;
1532: ELSE
1533: IF P_SQL_FOR = 'EVENT' THEN
1534: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1535: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1536: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1537: fnd_msg_pub.ADD;
1538: RAISE FND_API.G_EXC_ERROR;
1539: ELSE

Line 1536: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

1532: ELSE
1533: IF P_SQL_FOR = 'EVENT' THEN
1534: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1535: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1536: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1537: fnd_msg_pub.ADD;
1538: RAISE FND_API.G_EXC_ERROR;
1539: ELSE
1540: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1540: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1536: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1537: fnd_msg_pub.ADD;
1538: RAISE FND_API.G_EXC_ERROR;
1539: ELSE
1540: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1541: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1542: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1543: fnd_msg_pub.ADD;
1544: RAISE FND_API.G_EXC_ERROR;

Line 1541: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1537: fnd_msg_pub.ADD;
1538: RAISE FND_API.G_EXC_ERROR;
1539: ELSE
1540: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1541: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1542: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1543: fnd_msg_pub.ADD;
1544: RAISE FND_API.G_EXC_ERROR;
1545: END IF;

Line 1542: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

1538: RAISE FND_API.G_EXC_ERROR;
1539: ELSE
1540: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1541: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1542: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1543: fnd_msg_pub.ADD;
1544: RAISE FND_API.G_EXC_ERROR;
1545: END IF;
1546: END IF; -- cust_acct

Line 1558: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1554: l2i(G_HZ_CUST_ACCT_REL_P);
1555: END IF;
1556: ELSE
1557: IF P_SQL_FOR = 'EVENT' THEN
1558: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1559: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1560: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1561: fnd_msg_pub.ADD;
1562: RAISE FND_API.G_EXC_ERROR;

Line 1559: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1555: END IF;
1556: ELSE
1557: IF P_SQL_FOR = 'EVENT' THEN
1558: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1559: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1560: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1561: fnd_msg_pub.ADD;
1562: RAISE FND_API.G_EXC_ERROR;
1563: ELSE

Line 1560: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

1556: ELSE
1557: IF P_SQL_FOR = 'EVENT' THEN
1558: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1559: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1560: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1561: fnd_msg_pub.ADD;
1562: RAISE FND_API.G_EXC_ERROR;
1563: ELSE
1564: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1564: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1560: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1561: fnd_msg_pub.ADD;
1562: RAISE FND_API.G_EXC_ERROR;
1563: ELSE
1564: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1565: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1566: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1567: fnd_msg_pub.ADD;
1568: RAISE FND_API.G_EXC_ERROR;

Line 1565: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1561: fnd_msg_pub.ADD;
1562: RAISE FND_API.G_EXC_ERROR;
1563: ELSE
1564: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1565: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1566: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1567: fnd_msg_pub.ADD;
1568: RAISE FND_API.G_EXC_ERROR;
1569: END IF;

Line 1566: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

1562: RAISE FND_API.G_EXC_ERROR;
1563: ELSE
1564: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1565: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1566: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1567: fnd_msg_pub.ADD;
1568: RAISE FND_API.G_EXC_ERROR;
1569: END IF;
1570: END IF; -- cust_acct_relate_all

Line 1582: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1578: l2i(G_HZ_CUST_ACCT_SITES_A);
1579: END IF;
1580: ELSE
1581: IF P_SQL_FOR = 'EVENT' THEN
1582: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1583: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1584: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1585: fnd_msg_pub.ADD;
1586: RAISE FND_API.G_EXC_ERROR;

Line 1583: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1579: END IF;
1580: ELSE
1581: IF P_SQL_FOR = 'EVENT' THEN
1582: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1583: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1584: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1585: fnd_msg_pub.ADD;
1586: RAISE FND_API.G_EXC_ERROR;
1587: ELSE

Line 1584: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

1580: ELSE
1581: IF P_SQL_FOR = 'EVENT' THEN
1582: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1583: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1584: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1585: fnd_msg_pub.ADD;
1586: RAISE FND_API.G_EXC_ERROR;
1587: ELSE
1588: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1588: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1584: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1585: fnd_msg_pub.ADD;
1586: RAISE FND_API.G_EXC_ERROR;
1587: ELSE
1588: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1589: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1590: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1591: fnd_msg_pub.ADD;
1592: RAISE FND_API.G_EXC_ERROR;

Line 1589: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1585: fnd_msg_pub.ADD;
1586: RAISE FND_API.G_EXC_ERROR;
1587: ELSE
1588: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1589: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1590: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1591: fnd_msg_pub.ADD;
1592: RAISE FND_API.G_EXC_ERROR;
1593: END IF;

Line 1590: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

1586: RAISE FND_API.G_EXC_ERROR;
1587: ELSE
1588: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1589: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1590: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1591: fnd_msg_pub.ADD;
1592: RAISE FND_API.G_EXC_ERROR;
1593: END IF;
1594: END IF; -- cust_acct_sites_all

Line 1606: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1602: l2i(G_HZ_CUST_PROF_AMTS_AP);
1603: END IF;
1604: ELSE
1605: IF P_SQL_FOR = 'EVENT' THEN
1606: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1607: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1608: fnd_msg_pub.ADD;
1609: RAISE FND_API.G_EXC_ERROR;
1610: ELSE

Line 1607: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1603: END IF;
1604: ELSE
1605: IF P_SQL_FOR = 'EVENT' THEN
1606: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1607: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1608: fnd_msg_pub.ADD;
1609: RAISE FND_API.G_EXC_ERROR;
1610: ELSE
1611: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1611: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1607: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1608: fnd_msg_pub.ADD;
1609: RAISE FND_API.G_EXC_ERROR;
1610: ELSE
1611: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1612: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1613: fnd_msg_pub.ADD;
1614: RAISE FND_API.G_EXC_ERROR;
1615: END IF;

Line 1612: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1608: fnd_msg_pub.ADD;
1609: RAISE FND_API.G_EXC_ERROR;
1610: ELSE
1611: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1612: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1613: fnd_msg_pub.ADD;
1614: RAISE FND_API.G_EXC_ERROR;
1615: END IF;
1616: END IF; -- cust_profile_amts

Line 1629: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1625: l2i(G_HZ_CUST_SITE_USES_AS);
1626: END IF;
1627: ELSE
1628: IF P_SQL_FOR = 'EVENT' THEN
1629: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1630: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1631: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1632: fnd_msg_pub.ADD;
1633: RAISE FND_API.G_EXC_ERROR;

Line 1630: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1626: END IF;
1627: ELSE
1628: IF P_SQL_FOR = 'EVENT' THEN
1629: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1630: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1631: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1632: fnd_msg_pub.ADD;
1633: RAISE FND_API.G_EXC_ERROR;
1634: ELSE

Line 1631: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

1627: ELSE
1628: IF P_SQL_FOR = 'EVENT' THEN
1629: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1630: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1631: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1632: fnd_msg_pub.ADD;
1633: RAISE FND_API.G_EXC_ERROR;
1634: ELSE
1635: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1635: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1631: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1632: fnd_msg_pub.ADD;
1633: RAISE FND_API.G_EXC_ERROR;
1634: ELSE
1635: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1636: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1637: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1638: fnd_msg_pub.ADD;
1639: RAISE FND_API.G_EXC_ERROR;

Line 1636: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1632: fnd_msg_pub.ADD;
1633: RAISE FND_API.G_EXC_ERROR;
1634: ELSE
1635: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1636: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1637: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1638: fnd_msg_pub.ADD;
1639: RAISE FND_API.G_EXC_ERROR;
1640: END IF;

Line 1637: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

1633: RAISE FND_API.G_EXC_ERROR;
1634: ELSE
1635: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1636: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1637: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1638: fnd_msg_pub.ADD;
1639: RAISE FND_API.G_EXC_ERROR;
1640: END IF;
1641: END IF; -- cust_site_uses

Line 1661: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1657: l2i(G_HZ_CUST_PROF_ASU);
1658: END IF;
1659: ELSE
1660: IF P_SQL_FOR = 'EVENT' THEN
1661: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1662: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1663: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1664: fnd_msg_pub.ADD;
1665: RAISE FND_API.G_EXC_ERROR;

Line 1662: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1658: END IF;
1659: ELSE
1660: IF P_SQL_FOR = 'EVENT' THEN
1661: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1662: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1663: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1664: fnd_msg_pub.ADD;
1665: RAISE FND_API.G_EXC_ERROR;
1666: ELSE

Line 1663: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

1659: ELSE
1660: IF P_SQL_FOR = 'EVENT' THEN
1661: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1662: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1663: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1664: fnd_msg_pub.ADD;
1665: RAISE FND_API.G_EXC_ERROR;
1666: ELSE
1667: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1667: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1663: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1664: fnd_msg_pub.ADD;
1665: RAISE FND_API.G_EXC_ERROR;
1666: ELSE
1667: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1668: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1669: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1670: fnd_msg_pub.ADD;
1671: RAISE FND_API.G_EXC_ERROR;

Line 1668: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1664: fnd_msg_pub.ADD;
1665: RAISE FND_API.G_EXC_ERROR;
1666: ELSE
1667: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1668: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1669: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1670: fnd_msg_pub.ADD;
1671: RAISE FND_API.G_EXC_ERROR;
1672: END IF;

Line 1669: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

1665: RAISE FND_API.G_EXC_ERROR;
1666: ELSE
1667: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1668: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1669: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1670: fnd_msg_pub.ADD;
1671: RAISE FND_API.G_EXC_ERROR;
1672: END IF;
1673: END CASE; -- cust_prof

Line 1685: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1681: l2i(G_HZ_EDU_P);
1682: END IF;
1683: ELSE
1684: IF P_SQL_FOR = 'EVENT' THEN
1685: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1686: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1687: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1688: fnd_msg_pub.ADD;
1689: RAISE FND_API.G_EXC_ERROR;

Line 1686: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1682: END IF;
1683: ELSE
1684: IF P_SQL_FOR = 'EVENT' THEN
1685: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1686: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1687: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1688: fnd_msg_pub.ADD;
1689: RAISE FND_API.G_EXC_ERROR;
1690: ELSE

Line 1687: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

1683: ELSE
1684: IF P_SQL_FOR = 'EVENT' THEN
1685: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1686: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1687: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1688: fnd_msg_pub.ADD;
1689: RAISE FND_API.G_EXC_ERROR;
1690: ELSE
1691: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1691: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1687: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1688: fnd_msg_pub.ADD;
1689: RAISE FND_API.G_EXC_ERROR;
1690: ELSE
1691: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1692: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1693: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1694: fnd_msg_pub.ADD;
1695: RAISE FND_API.G_EXC_ERROR;

Line 1692: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1688: fnd_msg_pub.ADD;
1689: RAISE FND_API.G_EXC_ERROR;
1690: ELSE
1691: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1692: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1693: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1694: fnd_msg_pub.ADD;
1695: RAISE FND_API.G_EXC_ERROR;
1696: END IF;

Line 1693: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

1689: RAISE FND_API.G_EXC_ERROR;
1690: ELSE
1691: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1692: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1693: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1694: fnd_msg_pub.ADD;
1695: RAISE FND_API.G_EXC_ERROR;
1696: END IF;
1697: END IF; -- edu

Line 1709: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1705: l2i(G_HZ_EMP_HIST_P);
1706: END IF;
1707: ELSE
1708: IF P_SQL_FOR = 'EVENT' THEN
1709: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1710: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1711: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1712: fnd_msg_pub.ADD;
1713: RAISE FND_API.G_EXC_ERROR;

Line 1710: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1706: END IF;
1707: ELSE
1708: IF P_SQL_FOR = 'EVENT' THEN
1709: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1710: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1711: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1712: fnd_msg_pub.ADD;
1713: RAISE FND_API.G_EXC_ERROR;
1714: ELSE

Line 1711: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

1707: ELSE
1708: IF P_SQL_FOR = 'EVENT' THEN
1709: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1710: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1711: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1712: fnd_msg_pub.ADD;
1713: RAISE FND_API.G_EXC_ERROR;
1714: ELSE
1715: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1715: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1711: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1712: fnd_msg_pub.ADD;
1713: RAISE FND_API.G_EXC_ERROR;
1714: ELSE
1715: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1716: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1717: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1718: fnd_msg_pub.ADD;
1719: RAISE FND_API.G_EXC_ERROR;

Line 1716: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1712: fnd_msg_pub.ADD;
1713: RAISE FND_API.G_EXC_ERROR;
1714: ELSE
1715: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1716: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1717: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1718: fnd_msg_pub.ADD;
1719: RAISE FND_API.G_EXC_ERROR;
1720: END IF;

Line 1717: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

1713: RAISE FND_API.G_EXC_ERROR;
1714: ELSE
1715: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1716: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1717: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1718: fnd_msg_pub.ADD;
1719: RAISE FND_API.G_EXC_ERROR;
1720: END IF;
1721: END IF; -- emp_hist

Line 1733: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1729: l2i(G_HZ_FIN_NUM_FR);
1730: END IF;
1731: ELSE
1732: IF P_SQL_FOR = 'EVENT' THEN
1733: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1734: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1735: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1736: fnd_msg_pub.ADD;
1737: RAISE FND_API.G_EXC_ERROR;

Line 1734: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1730: END IF;
1731: ELSE
1732: IF P_SQL_FOR = 'EVENT' THEN
1733: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1734: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1735: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1736: fnd_msg_pub.ADD;
1737: RAISE FND_API.G_EXC_ERROR;
1738: ELSE

Line 1735: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

1731: ELSE
1732: IF P_SQL_FOR = 'EVENT' THEN
1733: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1734: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1735: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1736: fnd_msg_pub.ADD;
1737: RAISE FND_API.G_EXC_ERROR;
1738: ELSE
1739: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1739: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1735: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1736: fnd_msg_pub.ADD;
1737: RAISE FND_API.G_EXC_ERROR;
1738: ELSE
1739: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1740: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1741: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1742: fnd_msg_pub.ADD;
1743: RAISE FND_API.G_EXC_ERROR;

Line 1740: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1736: fnd_msg_pub.ADD;
1737: RAISE FND_API.G_EXC_ERROR;
1738: ELSE
1739: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1740: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1741: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1742: fnd_msg_pub.ADD;
1743: RAISE FND_API.G_EXC_ERROR;
1744: END IF;

Line 1741: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

1737: RAISE FND_API.G_EXC_ERROR;
1738: ELSE
1739: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1740: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1741: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1742: fnd_msg_pub.ADD;
1743: RAISE FND_API.G_EXC_ERROR;
1744: END IF;
1745: END IF; -- fin_num

Line 1758: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1754: l2i(G_HZ_FIN_PROF_P);
1755: END IF;
1756: ELSE
1757: IF P_SQL_FOR = 'EVENT' THEN
1758: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1759: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1760: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1761: fnd_msg_pub.ADD;
1762: RAISE FND_API.G_EXC_ERROR;

Line 1759: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1755: END IF;
1756: ELSE
1757: IF P_SQL_FOR = 'EVENT' THEN
1758: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1759: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1760: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1761: fnd_msg_pub.ADD;
1762: RAISE FND_API.G_EXC_ERROR;
1763: ELSE

Line 1760: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

1756: ELSE
1757: IF P_SQL_FOR = 'EVENT' THEN
1758: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1759: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1760: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1761: fnd_msg_pub.ADD;
1762: RAISE FND_API.G_EXC_ERROR;
1763: ELSE
1764: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1764: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1760: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1761: fnd_msg_pub.ADD;
1762: RAISE FND_API.G_EXC_ERROR;
1763: ELSE
1764: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1765: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1766: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1767: fnd_msg_pub.ADD;
1768: RAISE FND_API.G_EXC_ERROR;

Line 1765: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1761: fnd_msg_pub.ADD;
1762: RAISE FND_API.G_EXC_ERROR;
1763: ELSE
1764: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1765: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1766: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1767: fnd_msg_pub.ADD;
1768: RAISE FND_API.G_EXC_ERROR;
1769: END IF;

Line 1766: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

1762: RAISE FND_API.G_EXC_ERROR;
1763: ELSE
1764: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1765: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1766: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1767: fnd_msg_pub.ADD;
1768: RAISE FND_API.G_EXC_ERROR;
1769: END IF;
1770: END IF; -- fin_prof

Line 1782: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1778: l2i(G_HZ_FIN_REP_P);
1779: END IF;
1780: ELSE
1781: IF P_SQL_FOR = 'EVENT' THEN
1782: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1783: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1784: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1785: fnd_msg_pub.ADD;
1786: RAISE FND_API.G_EXC_ERROR;

Line 1783: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1779: END IF;
1780: ELSE
1781: IF P_SQL_FOR = 'EVENT' THEN
1782: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1783: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1784: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1785: fnd_msg_pub.ADD;
1786: RAISE FND_API.G_EXC_ERROR;
1787: ELSE

Line 1784: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

1780: ELSE
1781: IF P_SQL_FOR = 'EVENT' THEN
1782: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1783: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1784: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1785: fnd_msg_pub.ADD;
1786: RAISE FND_API.G_EXC_ERROR;
1787: ELSE
1788: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1788: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1784: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1785: fnd_msg_pub.ADD;
1786: RAISE FND_API.G_EXC_ERROR;
1787: ELSE
1788: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1789: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1790: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1791: fnd_msg_pub.ADD;
1792: RAISE FND_API.G_EXC_ERROR;

Line 1789: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1785: fnd_msg_pub.ADD;
1786: RAISE FND_API.G_EXC_ERROR;
1787: ELSE
1788: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1789: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1790: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1791: fnd_msg_pub.ADD;
1792: RAISE FND_API.G_EXC_ERROR;
1793: END IF;

Line 1790: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

1786: RAISE FND_API.G_EXC_ERROR;
1787: ELSE
1788: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1789: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1790: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1791: fnd_msg_pub.ADD;
1792: RAISE FND_API.G_EXC_ERROR;
1793: END IF;
1794: END IF; -- fin_rep

Line 1807: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1803: l2i(G_HZ_LOC_PS);
1804: END IF;
1805: ELSE
1806: IF P_SQL_FOR = 'EVENT' THEN
1807: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1808: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1809: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1810: fnd_msg_pub.ADD;
1811: RAISE FND_API.G_EXC_ERROR;

Line 1808: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1804: END IF;
1805: ELSE
1806: IF P_SQL_FOR = 'EVENT' THEN
1807: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1808: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1809: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1810: fnd_msg_pub.ADD;
1811: RAISE FND_API.G_EXC_ERROR;
1812: ELSE

Line 1809: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

1805: ELSE
1806: IF P_SQL_FOR = 'EVENT' THEN
1807: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1808: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1809: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1810: fnd_msg_pub.ADD;
1811: RAISE FND_API.G_EXC_ERROR;
1812: ELSE
1813: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1813: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1809: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1810: fnd_msg_pub.ADD;
1811: RAISE FND_API.G_EXC_ERROR;
1812: ELSE
1813: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1814: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1815: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1816: fnd_msg_pub.ADD;
1817: RAISE FND_API.G_EXC_ERROR;

Line 1814: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1810: fnd_msg_pub.ADD;
1811: RAISE FND_API.G_EXC_ERROR;
1812: ELSE
1813: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1814: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1815: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1816: fnd_msg_pub.ADD;
1817: RAISE FND_API.G_EXC_ERROR;
1818: END IF;

Line 1815: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

1811: RAISE FND_API.G_EXC_ERROR;
1812: ELSE
1813: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1814: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1815: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1816: fnd_msg_pub.ADD;
1817: RAISE FND_API.G_EXC_ERROR;
1818: END IF;
1819: END IF; -- loc

Line 1832: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1828: l2i(G_HZ_ORG_CONT_ROLE_OC);
1829: END IF;
1830: ELSE
1831: IF P_SQL_FOR = 'EVENT' THEN
1832: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1833: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1834: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1835: fnd_msg_pub.ADD;
1836: RAISE FND_API.G_EXC_ERROR;

Line 1833: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1829: END IF;
1830: ELSE
1831: IF P_SQL_FOR = 'EVENT' THEN
1832: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1833: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1834: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1835: fnd_msg_pub.ADD;
1836: RAISE FND_API.G_EXC_ERROR;
1837: ELSE

Line 1834: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

1830: ELSE
1831: IF P_SQL_FOR = 'EVENT' THEN
1832: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1833: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1834: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1835: fnd_msg_pub.ADD;
1836: RAISE FND_API.G_EXC_ERROR;
1837: ELSE
1838: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1838: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1834: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1835: fnd_msg_pub.ADD;
1836: RAISE FND_API.G_EXC_ERROR;
1837: ELSE
1838: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1839: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1840: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1841: fnd_msg_pub.ADD;
1842: RAISE FND_API.G_EXC_ERROR;

Line 1839: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1835: fnd_msg_pub.ADD;
1836: RAISE FND_API.G_EXC_ERROR;
1837: ELSE
1838: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1839: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1840: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1841: fnd_msg_pub.ADD;
1842: RAISE FND_API.G_EXC_ERROR;
1843: END IF;

Line 1840: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

1836: RAISE FND_API.G_EXC_ERROR;
1837: ELSE
1838: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1839: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1840: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1841: fnd_msg_pub.ADD;
1842: RAISE FND_API.G_EXC_ERROR;
1843: END IF;
1844: END IF; -- cont_roles

Line 1888: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1884: END IF;
1885: */
1886: ELSE
1887: IF P_SQL_FOR = 'EVENT' THEN
1888: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1889: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1890: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1891: fnd_msg_pub.ADD;
1892: RAISE FND_API.G_EXC_ERROR;

Line 1889: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1885: */
1886: ELSE
1887: IF P_SQL_FOR = 'EVENT' THEN
1888: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1889: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1890: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1891: fnd_msg_pub.ADD;
1892: RAISE FND_API.G_EXC_ERROR;
1893: ELSE

Line 1890: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

1886: ELSE
1887: IF P_SQL_FOR = 'EVENT' THEN
1888: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1889: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1890: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1891: fnd_msg_pub.ADD;
1892: RAISE FND_API.G_EXC_ERROR;
1893: ELSE
1894: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1894: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1890: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1891: fnd_msg_pub.ADD;
1892: RAISE FND_API.G_EXC_ERROR;
1893: ELSE
1894: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1895: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1896: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1897: fnd_msg_pub.ADD;
1898: RAISE FND_API.G_EXC_ERROR;

Line 1895: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1891: fnd_msg_pub.ADD;
1892: RAISE FND_API.G_EXC_ERROR;
1893: ELSE
1894: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1895: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1896: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1897: fnd_msg_pub.ADD;
1898: RAISE FND_API.G_EXC_ERROR;
1899: END IF;

Line 1896: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

1892: RAISE FND_API.G_EXC_ERROR;
1893: ELSE
1894: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1895: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1896: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1897: fnd_msg_pub.ADD;
1898: RAISE FND_API.G_EXC_ERROR;
1899: END IF;
1900: END CASE; -- org_contact

Line 1912: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1908: l2i(G_HZ_ORG_PROF_P);
1909: END IF;
1910: ELSE
1911: IF P_SQL_FOR = 'EVENT' THEN
1912: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1913: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1914: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1915: fnd_msg_pub.ADD;
1916: RAISE FND_API.G_EXC_ERROR;

Line 1913: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1909: END IF;
1910: ELSE
1911: IF P_SQL_FOR = 'EVENT' THEN
1912: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1913: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1914: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1915: fnd_msg_pub.ADD;
1916: RAISE FND_API.G_EXC_ERROR;
1917: ELSE

Line 1914: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

1910: ELSE
1911: IF P_SQL_FOR = 'EVENT' THEN
1912: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1913: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1914: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1915: fnd_msg_pub.ADD;
1916: RAISE FND_API.G_EXC_ERROR;
1917: ELSE
1918: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1918: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1914: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1915: fnd_msg_pub.ADD;
1916: RAISE FND_API.G_EXC_ERROR;
1917: ELSE
1918: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1919: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1920: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1921: fnd_msg_pub.ADD;
1922: RAISE FND_API.G_EXC_ERROR;

Line 1919: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1915: fnd_msg_pub.ADD;
1916: RAISE FND_API.G_EXC_ERROR;
1917: ELSE
1918: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1919: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1920: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1921: fnd_msg_pub.ADD;
1922: RAISE FND_API.G_EXC_ERROR;
1923: END IF;

Line 1920: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

1916: RAISE FND_API.G_EXC_ERROR;
1917: ELSE
1918: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1919: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1920: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
1921: fnd_msg_pub.ADD;
1922: RAISE FND_API.G_EXC_ERROR;
1923: END IF;
1924: END IF; -- org_profiles

Line 1981: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

1977: l2i(G_HZ_PARTIES_OC);
1978: END IF;
1979: ELSE
1980: IF P_SQL_FOR = 'EVENT' THEN
1981: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1982: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1983: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1984: fnd_msg_pub.ADD;
1985: RAISE FND_API.G_EXC_ERROR;

Line 1982: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1978: END IF;
1979: ELSE
1980: IF P_SQL_FOR = 'EVENT' THEN
1981: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1982: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1983: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1984: fnd_msg_pub.ADD;
1985: RAISE FND_API.G_EXC_ERROR;
1986: ELSE

Line 1983: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

1979: ELSE
1980: IF P_SQL_FOR = 'EVENT' THEN
1981: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
1982: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1983: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1984: fnd_msg_pub.ADD;
1985: RAISE FND_API.G_EXC_ERROR;
1986: ELSE
1987: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 1987: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

1983: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1984: fnd_msg_pub.ADD;
1985: RAISE FND_API.G_EXC_ERROR;
1986: ELSE
1987: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1988: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1989: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1990: fnd_msg_pub.ADD;
1991: RAISE FND_API.G_EXC_ERROR;

Line 1988: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

1984: fnd_msg_pub.ADD;
1985: RAISE FND_API.G_EXC_ERROR;
1986: ELSE
1987: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1988: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1989: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1990: fnd_msg_pub.ADD;
1991: RAISE FND_API.G_EXC_ERROR;
1992: END IF;

Line 1989: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

1985: RAISE FND_API.G_EXC_ERROR;
1986: ELSE
1987: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
1988: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
1989: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
1990: fnd_msg_pub.ADD;
1991: RAISE FND_API.G_EXC_ERROR;
1992: END IF;
1993: END CASE; -- parties

Line 2005: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

2001: l2i(G_HZ_PARTY_PREF_P);
2002: END IF;
2003: ELSE
2004: IF P_SQL_FOR = 'EVENT' THEN
2005: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2006: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2007: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2008: fnd_msg_pub.ADD;
2009: RAISE FND_API.G_EXC_ERROR;

Line 2006: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2002: END IF;
2003: ELSE
2004: IF P_SQL_FOR = 'EVENT' THEN
2005: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2006: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2007: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2008: fnd_msg_pub.ADD;
2009: RAISE FND_API.G_EXC_ERROR;
2010: ELSE

Line 2007: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

2003: ELSE
2004: IF P_SQL_FOR = 'EVENT' THEN
2005: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2006: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2007: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2008: fnd_msg_pub.ADD;
2009: RAISE FND_API.G_EXC_ERROR;
2010: ELSE
2011: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 2011: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

2007: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2008: fnd_msg_pub.ADD;
2009: RAISE FND_API.G_EXC_ERROR;
2010: ELSE
2011: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2012: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2013: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2014: fnd_msg_pub.ADD;
2015: RAISE FND_API.G_EXC_ERROR;

Line 2012: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2008: fnd_msg_pub.ADD;
2009: RAISE FND_API.G_EXC_ERROR;
2010: ELSE
2011: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2012: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2013: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2014: fnd_msg_pub.ADD;
2015: RAISE FND_API.G_EXC_ERROR;
2016: END IF;

Line 2013: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

2009: RAISE FND_API.G_EXC_ERROR;
2010: ELSE
2011: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2012: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2013: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2014: fnd_msg_pub.ADD;
2015: RAISE FND_API.G_EXC_ERROR;
2016: END IF;
2017: END IF; -- party_pref

Line 2029: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

2025: l2i(G_HZ_PS_USE_PS);
2026: END IF;
2027: ELSE
2028: IF P_SQL_FOR = 'EVENT' THEN
2029: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2030: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2031: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2032: fnd_msg_pub.ADD;
2033: RAISE FND_API.G_EXC_ERROR;

Line 2030: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2026: END IF;
2027: ELSE
2028: IF P_SQL_FOR = 'EVENT' THEN
2029: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2030: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2031: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2032: fnd_msg_pub.ADD;
2033: RAISE FND_API.G_EXC_ERROR;
2034: ELSE

Line 2031: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

2027: ELSE
2028: IF P_SQL_FOR = 'EVENT' THEN
2029: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2030: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2031: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2032: fnd_msg_pub.ADD;
2033: RAISE FND_API.G_EXC_ERROR;
2034: ELSE
2035: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 2035: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

2031: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2032: fnd_msg_pub.ADD;
2033: RAISE FND_API.G_EXC_ERROR;
2034: ELSE
2035: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2036: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2037: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2038: fnd_msg_pub.ADD;
2039: RAISE FND_API.G_EXC_ERROR;

Line 2036: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2032: fnd_msg_pub.ADD;
2033: RAISE FND_API.G_EXC_ERROR;
2034: ELSE
2035: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2036: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2037: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2038: fnd_msg_pub.ADD;
2039: RAISE FND_API.G_EXC_ERROR;
2040: END IF;

Line 2037: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

2033: RAISE FND_API.G_EXC_ERROR;
2034: ELSE
2035: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2036: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2037: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2038: fnd_msg_pub.ADD;
2039: RAISE FND_API.G_EXC_ERROR;
2040: END IF;
2041: END IF; -- party_site_use

Line 2076: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

2072: END IF;
2073: */
2074: ELSE
2075: IF P_SQL_FOR = 'EVENT' THEN
2076: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2077: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2078: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2079: fnd_msg_pub.ADD;
2080: RAISE FND_API.G_EXC_ERROR;

Line 2077: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2073: */
2074: ELSE
2075: IF P_SQL_FOR = 'EVENT' THEN
2076: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2077: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2078: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2079: fnd_msg_pub.ADD;
2080: RAISE FND_API.G_EXC_ERROR;
2081: ELSE

Line 2078: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

2074: ELSE
2075: IF P_SQL_FOR = 'EVENT' THEN
2076: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2077: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2078: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2079: fnd_msg_pub.ADD;
2080: RAISE FND_API.G_EXC_ERROR;
2081: ELSE
2082: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 2082: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

2078: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2079: fnd_msg_pub.ADD;
2080: RAISE FND_API.G_EXC_ERROR;
2081: ELSE
2082: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2083: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2084: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2085: fnd_msg_pub.ADD;
2086: RAISE FND_API.G_EXC_ERROR;

Line 2083: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2079: fnd_msg_pub.ADD;
2080: RAISE FND_API.G_EXC_ERROR;
2081: ELSE
2082: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2083: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2084: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2085: fnd_msg_pub.ADD;
2086: RAISE FND_API.G_EXC_ERROR;
2087: END IF;

Line 2084: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

2080: RAISE FND_API.G_EXC_ERROR;
2081: ELSE
2082: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2083: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2084: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2085: fnd_msg_pub.ADD;
2086: RAISE FND_API.G_EXC_ERROR;
2087: END IF;
2088: END CASE; -- PS

Line 2100: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

2096: l2i(G_HZ_PARTY_USG_ASSIN_P);
2097: END IF;
2098: ELSE
2099: IF P_SQL_FOR = 'EVENT' THEN
2100: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2101: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2102: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2103: fnd_msg_pub.ADD;
2104: RAISE FND_API.G_EXC_ERROR;

Line 2101: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2097: END IF;
2098: ELSE
2099: IF P_SQL_FOR = 'EVENT' THEN
2100: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2101: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2102: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2103: fnd_msg_pub.ADD;
2104: RAISE FND_API.G_EXC_ERROR;
2105: ELSE

Line 2102: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

2098: ELSE
2099: IF P_SQL_FOR = 'EVENT' THEN
2100: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2101: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2102: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2103: fnd_msg_pub.ADD;
2104: RAISE FND_API.G_EXC_ERROR;
2105: ELSE
2106: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 2106: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

2102: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2103: fnd_msg_pub.ADD;
2104: RAISE FND_API.G_EXC_ERROR;
2105: ELSE
2106: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2107: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2108: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2109: fnd_msg_pub.ADD;
2110: RAISE FND_API.G_EXC_ERROR;

Line 2107: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2103: fnd_msg_pub.ADD;
2104: RAISE FND_API.G_EXC_ERROR;
2105: ELSE
2106: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2107: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2108: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2109: fnd_msg_pub.ADD;
2110: RAISE FND_API.G_EXC_ERROR;
2111: END IF;

Line 2108: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

2104: RAISE FND_API.G_EXC_ERROR;
2105: ELSE
2106: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2107: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2108: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2109: fnd_msg_pub.ADD;
2110: RAISE FND_API.G_EXC_ERROR;
2111: END IF;
2112: END IF; -- end of 'HZ_PARTY_USG_ASSIGNMENTS'

Line 2124: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

2120: l2i(G_HZ_PER_INT_P);
2121: END IF;
2122: ELSE
2123: IF P_SQL_FOR = 'EVENT' THEN
2124: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2125: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2126: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2127: fnd_msg_pub.ADD;
2128: RAISE FND_API.G_EXC_ERROR;

Line 2125: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2121: END IF;
2122: ELSE
2123: IF P_SQL_FOR = 'EVENT' THEN
2124: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2125: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2126: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2127: fnd_msg_pub.ADD;
2128: RAISE FND_API.G_EXC_ERROR;
2129: ELSE

Line 2126: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

2122: ELSE
2123: IF P_SQL_FOR = 'EVENT' THEN
2124: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2125: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2126: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2127: fnd_msg_pub.ADD;
2128: RAISE FND_API.G_EXC_ERROR;
2129: ELSE
2130: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 2130: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

2126: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2127: fnd_msg_pub.ADD;
2128: RAISE FND_API.G_EXC_ERROR;
2129: ELSE
2130: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2131: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2132: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2133: fnd_msg_pub.ADD;
2134: RAISE FND_API.G_EXC_ERROR;

Line 2131: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2127: fnd_msg_pub.ADD;
2128: RAISE FND_API.G_EXC_ERROR;
2129: ELSE
2130: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2131: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2132: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2133: fnd_msg_pub.ADD;
2134: RAISE FND_API.G_EXC_ERROR;
2135: END IF;

Line 2132: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

2128: RAISE FND_API.G_EXC_ERROR;
2129: ELSE
2130: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2131: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2132: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2133: fnd_msg_pub.ADD;
2134: RAISE FND_API.G_EXC_ERROR;
2135: END IF;
2136: END IF; -- per_int

Line 2148: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

2144: l2i(G_HZ_PER_LANG_P);
2145: END IF;
2146: ELSE
2147: IF P_SQL_FOR = 'EVENT' THEN
2148: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2149: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2150: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2151: fnd_msg_pub.ADD;
2152: RAISE FND_API.G_EXC_ERROR;

Line 2149: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2145: END IF;
2146: ELSE
2147: IF P_SQL_FOR = 'EVENT' THEN
2148: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2149: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2150: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2151: fnd_msg_pub.ADD;
2152: RAISE FND_API.G_EXC_ERROR;
2153: ELSE

Line 2150: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

2146: ELSE
2147: IF P_SQL_FOR = 'EVENT' THEN
2148: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2149: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2150: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2151: fnd_msg_pub.ADD;
2152: RAISE FND_API.G_EXC_ERROR;
2153: ELSE
2154: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 2154: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

2150: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2151: fnd_msg_pub.ADD;
2152: RAISE FND_API.G_EXC_ERROR;
2153: ELSE
2154: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2155: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2156: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2157: fnd_msg_pub.ADD;
2158: RAISE FND_API.G_EXC_ERROR;

Line 2155: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2151: fnd_msg_pub.ADD;
2152: RAISE FND_API.G_EXC_ERROR;
2153: ELSE
2154: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2155: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2156: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2157: fnd_msg_pub.ADD;
2158: RAISE FND_API.G_EXC_ERROR;
2159: END IF;

Line 2156: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

2152: RAISE FND_API.G_EXC_ERROR;
2153: ELSE
2154: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2155: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2156: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2157: fnd_msg_pub.ADD;
2158: RAISE FND_API.G_EXC_ERROR;
2159: END IF;
2160: END IF; --PL

Line 2173: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

2169: l2i(G_HZ_PER_PROF_P);
2170: END IF;
2171: ELSE
2172: IF P_SQL_FOR = 'EVENT' THEN
2173: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2174: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2175: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2176: fnd_msg_pub.ADD;
2177: RAISE FND_API.G_EXC_ERROR;

Line 2174: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2170: END IF;
2171: ELSE
2172: IF P_SQL_FOR = 'EVENT' THEN
2173: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2174: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2175: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2176: fnd_msg_pub.ADD;
2177: RAISE FND_API.G_EXC_ERROR;
2178: ELSE

Line 2175: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

2171: ELSE
2172: IF P_SQL_FOR = 'EVENT' THEN
2173: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2174: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2175: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2176: fnd_msg_pub.ADD;
2177: RAISE FND_API.G_EXC_ERROR;
2178: ELSE
2179: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 2179: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

2175: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2176: fnd_msg_pub.ADD;
2177: RAISE FND_API.G_EXC_ERROR;
2178: ELSE
2179: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2180: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2181: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2182: fnd_msg_pub.ADD;
2183: RAISE FND_API.G_EXC_ERROR;

Line 2180: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2176: fnd_msg_pub.ADD;
2177: RAISE FND_API.G_EXC_ERROR;
2178: ELSE
2179: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2180: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2181: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2182: fnd_msg_pub.ADD;
2183: RAISE FND_API.G_EXC_ERROR;
2184: END IF;

Line 2181: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

2177: RAISE FND_API.G_EXC_ERROR;
2178: ELSE
2179: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2180: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2181: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2182: fnd_msg_pub.ADD;
2183: RAISE FND_API.G_EXC_ERROR;
2184: END IF;
2185: END IF; -- per_prof

Line 2212: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

2208: l2i(G_HZ_REL_OC);
2209: END IF;
2210: ELSE
2211: IF P_SQL_FOR = 'EVENT' THEN
2212: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2213: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2214: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2215: fnd_msg_pub.ADD;
2216: RAISE FND_API.G_EXC_ERROR;

Line 2213: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2209: END IF;
2210: ELSE
2211: IF P_SQL_FOR = 'EVENT' THEN
2212: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2213: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2214: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2215: fnd_msg_pub.ADD;
2216: RAISE FND_API.G_EXC_ERROR;
2217: ELSE

Line 2214: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

2210: ELSE
2211: IF P_SQL_FOR = 'EVENT' THEN
2212: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2213: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2214: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2215: fnd_msg_pub.ADD;
2216: RAISE FND_API.G_EXC_ERROR;
2217: ELSE
2218: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 2218: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

2214: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2215: fnd_msg_pub.ADD;
2216: RAISE FND_API.G_EXC_ERROR;
2217: ELSE
2218: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2219: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2220: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2221: fnd_msg_pub.ADD;
2222: RAISE FND_API.G_EXC_ERROR;

Line 2219: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2215: fnd_msg_pub.ADD;
2216: RAISE FND_API.G_EXC_ERROR;
2217: ELSE
2218: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2219: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2220: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2221: fnd_msg_pub.ADD;
2222: RAISE FND_API.G_EXC_ERROR;
2223: END IF;

Line 2220: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

2216: RAISE FND_API.G_EXC_ERROR;
2217: ELSE
2218: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2219: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2220: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2221: fnd_msg_pub.ADD;
2222: RAISE FND_API.G_EXC_ERROR;
2223: END IF;
2224: END CASE; -- rel

Line 2236: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

2232: l2i(G_HZ_ROLE_RESP_AC);
2233: END IF;
2234: ELSE
2235: IF P_SQL_FOR = 'EVENT' THEN
2236: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2237: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2238: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2239: fnd_msg_pub.ADD;
2240: RAISE FND_API.G_EXC_ERROR;

Line 2237: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2233: END IF;
2234: ELSE
2235: IF P_SQL_FOR = 'EVENT' THEN
2236: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2237: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2238: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2239: fnd_msg_pub.ADD;
2240: RAISE FND_API.G_EXC_ERROR;
2241: ELSE

Line 2238: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

2234: ELSE
2235: IF P_SQL_FOR = 'EVENT' THEN
2236: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2237: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2238: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2239: fnd_msg_pub.ADD;
2240: RAISE FND_API.G_EXC_ERROR;
2241: ELSE
2242: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 2242: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

2238: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2239: fnd_msg_pub.ADD;
2240: RAISE FND_API.G_EXC_ERROR;
2241: ELSE
2242: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2243: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2244: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2245: fnd_msg_pub.ADD;
2246: RAISE FND_API.G_EXC_ERROR;

Line 2243: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2239: fnd_msg_pub.ADD;
2240: RAISE FND_API.G_EXC_ERROR;
2241: ELSE
2242: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2243: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2244: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2245: fnd_msg_pub.ADD;
2246: RAISE FND_API.G_EXC_ERROR;
2247: END IF;

Line 2244: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);

2240: RAISE FND_API.G_EXC_ERROR;
2241: ELSE
2242: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2243: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2244: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).BO_CODE);
2245: fnd_msg_pub.ADD;
2246: RAISE FND_API.G_EXC_ERROR;
2247: END IF;
2248: END IF; -- role_resp

Line 2260: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

2256: l2i(G_HZ_WORK_CLASS_EH);
2257: END IF;
2258: ELSE
2259: IF P_SQL_FOR = 'EVENT' THEN
2260: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2261: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2262: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2263: fnd_msg_pub.ADD;
2264: RAISE FND_API.G_EXC_ERROR;

Line 2261: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2257: END IF;
2258: ELSE
2259: IF P_SQL_FOR = 'EVENT' THEN
2260: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2261: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2262: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2263: fnd_msg_pub.ADD;
2264: RAISE FND_API.G_EXC_ERROR;
2265: ELSE

Line 2262: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

2258: ELSE
2259: IF P_SQL_FOR = 'EVENT' THEN
2260: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2261: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2262: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2263: fnd_msg_pub.ADD;
2264: RAISE FND_API.G_EXC_ERROR;
2265: ELSE
2266: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 2266: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

2262: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2263: fnd_msg_pub.ADD;
2264: RAISE FND_API.G_EXC_ERROR;
2265: ELSE
2266: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2267: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2268: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2269: fnd_msg_pub.ADD;
2270: RAISE FND_API.G_EXC_ERROR;

Line 2267: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2263: fnd_msg_pub.ADD;
2264: RAISE FND_API.G_EXC_ERROR;
2265: ELSE
2266: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2267: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2268: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2269: fnd_msg_pub.ADD;
2270: RAISE FND_API.G_EXC_ERROR;
2271: END IF;

Line 2268: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

2264: RAISE FND_API.G_EXC_ERROR;
2265: ELSE
2266: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2267: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2268: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2269: fnd_msg_pub.ADD;
2270: RAISE FND_API.G_EXC_ERROR;
2271: END IF;
2272: END IF; -- wrk_class

Line 2292: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

2288: l2i(G_CUST_RECEIPT_METHODS_ASU);
2289: END IF;
2290: ELSE
2291: IF P_SQL_FOR = 'EVENT' THEN
2292: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2293: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2294: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2295: fnd_msg_pub.ADD;
2296: RAISE FND_API.G_EXC_ERROR;

Line 2293: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2289: END IF;
2290: ELSE
2291: IF P_SQL_FOR = 'EVENT' THEN
2292: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2293: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2294: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2295: fnd_msg_pub.ADD;
2296: RAISE FND_API.G_EXC_ERROR;
2297: ELSE

Line 2294: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

2290: ELSE
2291: IF P_SQL_FOR = 'EVENT' THEN
2292: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2293: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2294: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2295: fnd_msg_pub.ADD;
2296: RAISE FND_API.G_EXC_ERROR;
2297: ELSE
2298: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 2298: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

2294: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2295: fnd_msg_pub.ADD;
2296: RAISE FND_API.G_EXC_ERROR;
2297: ELSE
2298: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2299: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2300: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2301: fnd_msg_pub.ADD;
2302: RAISE FND_API.G_EXC_ERROR;

Line 2299: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2295: fnd_msg_pub.ADD;
2296: RAISE FND_API.G_EXC_ERROR;
2297: ELSE
2298: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2299: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2300: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2301: fnd_msg_pub.ADD;
2302: RAISE FND_API.G_EXC_ERROR;
2303: END IF;

Line 2300: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

2296: RAISE FND_API.G_EXC_ERROR;
2297: ELSE
2298: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2299: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2300: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2301: fnd_msg_pub.ADD;
2302: RAISE FND_API.G_EXC_ERROR;
2303: END IF;
2304: END CASE; -- ra_cust

Line 2325: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');

2321: l2i(G_BANK_ACCT_USE_ASU);
2322: END IF;
2323: ELSE
2324: IF P_SQL_FOR = 'EVENT' THEN
2325: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2326: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2327: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2328: fnd_msg_pub.ADD;
2329: RAISE FND_API.G_EXC_ERROR;

Line 2326: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2322: END IF;
2323: ELSE
2324: IF P_SQL_FOR = 'EVENT' THEN
2325: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2326: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2327: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2328: fnd_msg_pub.ADD;
2329: RAISE FND_API.G_EXC_ERROR;
2330: ELSE

Line 2327: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

2323: ELSE
2324: IF P_SQL_FOR = 'EVENT' THEN
2325: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_PARENT');
2326: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2327: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2328: fnd_msg_pub.ADD;
2329: RAISE FND_API.G_EXC_ERROR;
2330: ELSE
2331: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

Line 2331: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');

2327: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2328: fnd_msg_pub.ADD;
2329: RAISE FND_API.G_EXC_ERROR;
2330: ELSE
2331: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2332: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2333: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2334: fnd_msg_pub.ADD;
2335: RAISE FND_API.G_EXC_ERROR;

Line 2332: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2328: fnd_msg_pub.ADD;
2329: RAISE FND_API.G_EXC_ERROR;
2330: ELSE
2331: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2332: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2333: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2334: fnd_msg_pub.ADD;
2335: RAISE FND_API.G_EXC_ERROR;
2336: END IF;

Line 2333: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);

2329: RAISE FND_API.G_EXC_ERROR;
2330: ELSE
2331: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_PARENT');
2332: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2333: fnd_message.set_token('PARENT_BO_CODE' ,l_node_tbl(i).PARENT_BO_CODE);
2334: fnd_msg_pub.ADD;
2335: RAISE FND_API.G_EXC_ERROR;
2336: END IF;
2337: END CASE; -- bank_assign

Line 2340: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_ENTITY');

2336: END IF;
2337: END CASE; -- bank_assign
2338: ELSE
2339: IF P_SQL_FOR = 'EVENT' THEN
2340: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_ENTITY');
2341: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2342: fnd_msg_pub.ADD;
2343: RAISE FND_API.G_EXC_ERROR;
2344: ELSE

Line 2341: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2337: END CASE; -- bank_assign
2338: ELSE
2339: IF P_SQL_FOR = 'EVENT' THEN
2340: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_BAD_ENTITY');
2341: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2342: fnd_msg_pub.ADD;
2343: RAISE FND_API.G_EXC_ERROR;
2344: ELSE
2345: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_ENTITY');

Line 2345: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_ENTITY');

2341: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2342: fnd_msg_pub.ADD;
2343: RAISE FND_API.G_EXC_ERROR;
2344: ELSE
2345: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_ENTITY');
2346: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2347: fnd_msg_pub.ADD;
2348: RAISE FND_API.G_EXC_ERROR;
2349: END IF;

Line 2346: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

2342: fnd_msg_pub.ADD;
2343: RAISE FND_API.G_EXC_ERROR;
2344: ELSE
2345: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_BAD_ENTITY');
2346: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);
2347: fnd_msg_pub.ADD;
2348: RAISE FND_API.G_EXC_ERROR;
2349: END IF;
2350: /*

Line 2517: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_DEL_ERROR');

2513: END IF;
2514: -- raise to calling program, in this case BOD API
2515: l_msg := 'error generating completeness del stmt for '||G_PER_BO_CODE||' BO';
2516: writeDebugMesg(l_msg||sqlerrm, l_gen_prefix);
2517: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_DEL_ERROR');
2518: fnd_message.set_token('BO_CODE', G_PER_BO_CODE);
2519: fnd_msg_pub.ADD;
2520: RAISE FND_API.G_EXC_ERROR;
2521: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2518: fnd_message.set_token('BO_CODE', G_PER_BO_CODE);

2514: -- raise to calling program, in this case BOD API
2515: l_msg := 'error generating completeness del stmt for '||G_PER_BO_CODE||' BO';
2516: writeDebugMesg(l_msg||sqlerrm, l_gen_prefix);
2517: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_DEL_ERROR');
2518: fnd_message.set_token('BO_CODE', G_PER_BO_CODE);
2519: fnd_msg_pub.ADD;
2520: RAISE FND_API.G_EXC_ERROR;
2521: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2522: END IF;

Line 2546: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_DEL_ERROR');

2542: END IF;
2543: -- raise to calling program, in this case BOD API
2544: l_msg := 'error generating completeness del stmt for '||G_ORG_BO_CODE||' ';
2545: writeDebugMesg(l_msg||sqlerrm, l_gen_prefix);
2546: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_DEL_ERROR');
2547: fnd_message.set_token('BO_CODE', G_ORG_BO_CODE);
2548: fnd_msg_pub.ADD;
2549: RAISE FND_API.G_EXC_ERROR;
2550: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2547: fnd_message.set_token('BO_CODE', G_ORG_BO_CODE);

2543: -- raise to calling program, in this case BOD API
2544: l_msg := 'error generating completeness del stmt for '||G_ORG_BO_CODE||' ';
2545: writeDebugMesg(l_msg||sqlerrm, l_gen_prefix);
2546: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_DEL_ERROR');
2547: fnd_message.set_token('BO_CODE', G_ORG_BO_CODE);
2548: fnd_msg_pub.ADD;
2549: RAISE FND_API.G_EXC_ERROR;
2550: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2551: END IF;

Line 2575: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_DEL_ERROR');

2571: END IF;
2572: -- raise to calling program, in this case BOD API
2573: l_msg := 'error generating completeness del stmt for '||G_PER_CUST_BO_CODE||' ';
2574: writeDebugMesg(l_msg||sqlerrm, l_gen_prefix);
2575: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_DEL_ERROR');
2576: fnd_message.set_token('BO_CODE', G_PER_CUST_BO_CODE);
2577: fnd_msg_pub.ADD;
2578: RAISE FND_API.G_EXC_ERROR;
2579: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2576: fnd_message.set_token('BO_CODE', G_PER_CUST_BO_CODE);

2572: -- raise to calling program, in this case BOD API
2573: l_msg := 'error generating completeness del stmt for '||G_PER_CUST_BO_CODE||' ';
2574: writeDebugMesg(l_msg||sqlerrm, l_gen_prefix);
2575: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_DEL_ERROR');
2576: fnd_message.set_token('BO_CODE', G_PER_CUST_BO_CODE);
2577: fnd_msg_pub.ADD;
2578: RAISE FND_API.G_EXC_ERROR;
2579: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2580: END IF;

Line 2604: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_DEL_ERROR');

2600: END IF;
2601: -- raise to calling program, in this case BOD API
2602: l_msg := 'error generating completeness del stmt for '||G_ORG_CUST_BO_CODE||' ';
2603: writeDebugMesg(l_msg||sqlerrm, l_gen_prefix);
2604: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_DEL_ERROR');
2605: fnd_message.set_token('BO_CODE', G_ORG_CUST_BO_CODE);
2606: fnd_msg_pub.ADD;
2607: RAISE FND_API.G_EXC_ERROR;
2608: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2605: fnd_message.set_token('BO_CODE', G_ORG_CUST_BO_CODE);

2601: -- raise to calling program, in this case BOD API
2602: l_msg := 'error generating completeness del stmt for '||G_ORG_CUST_BO_CODE||' ';
2603: writeDebugMesg(l_msg||sqlerrm, l_gen_prefix);
2604: fnd_message.set_name('AR', 'HZ_BES_BO_COMPLETE_DEL_ERROR');
2605: fnd_message.set_token('BO_CODE', G_ORG_CUST_BO_CODE);
2606: fnd_msg_pub.ADD;
2607: RAISE FND_API.G_EXC_ERROR;
2608: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2609: END IF;

Line 2717: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_UPDATE_ERROR');

2713: END IF;
2714: -- raise to calling program, in this case BOD API
2715: l_msg := 'error generating evt type upd stmt for '||G_PER_BO_CODE||' BO';
2716: writeDebugMesg(l_msg||sqlerrm, l_gen_prefix);
2717: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_UPDATE_ERROR');
2718: fnd_message.set_token('BO_CODE', G_PER_BO_CODE);
2719: fnd_msg_pub.ADD;
2720: RAISE FND_API.G_EXC_ERROR;
2721: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2718: fnd_message.set_token('BO_CODE', G_PER_BO_CODE);

2714: -- raise to calling program, in this case BOD API
2715: l_msg := 'error generating evt type upd stmt for '||G_PER_BO_CODE||' BO';
2716: writeDebugMesg(l_msg||sqlerrm, l_gen_prefix);
2717: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_UPDATE_ERROR');
2718: fnd_message.set_token('BO_CODE', G_PER_BO_CODE);
2719: fnd_msg_pub.ADD;
2720: RAISE FND_API.G_EXC_ERROR;
2721: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2722: END IF;

Line 2744: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_UPDATE_ERROR');

2740: END IF;
2741: -- raise to calling program, in this case BOD API
2742: l_msg := 'error generating evt type upd stmt for '||G_ORG_BO_CODE||' BO';
2743: writeDebugMesg(l_msg||sqlerrm, l_gen_prefix);
2744: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_UPDATE_ERROR');
2745: fnd_message.set_token('BO_CODE', G_ORG_BO_CODE);
2746: fnd_msg_pub.ADD;
2747: RAISE FND_API.G_EXC_ERROR;
2748: END IF;

Line 2745: fnd_message.set_token('BO_CODE', G_ORG_BO_CODE);

2741: -- raise to calling program, in this case BOD API
2742: l_msg := 'error generating evt type upd stmt for '||G_ORG_BO_CODE||' BO';
2743: writeDebugMesg(l_msg||sqlerrm, l_gen_prefix);
2744: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_UPDATE_ERROR');
2745: fnd_message.set_token('BO_CODE', G_ORG_BO_CODE);
2746: fnd_msg_pub.ADD;
2747: RAISE FND_API.G_EXC_ERROR;
2748: END IF;
2749: -- generate update statement for Person Customer BO

Line 2769: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_UPDATE_ERROR');

2765: END IF;
2766: -- raise to calling program, in this case BOD API
2767: l_msg := 'error generating evt type upd stmt for '||G_PER_CUST_BO_CODE||' BO';
2768: writeDebugMesg(l_msg||sqlerrm, l_gen_prefix);
2769: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_UPDATE_ERROR');
2770: fnd_message.set_token('BO_CODE', G_PER_CUST_BO_CODE);
2771: fnd_msg_pub.ADD;
2772: RAISE FND_API.G_EXC_ERROR;
2773: END IF;

Line 2770: fnd_message.set_token('BO_CODE', G_PER_CUST_BO_CODE);

2766: -- raise to calling program, in this case BOD API
2767: l_msg := 'error generating evt type upd stmt for '||G_PER_CUST_BO_CODE||' BO';
2768: writeDebugMesg(l_msg||sqlerrm, l_gen_prefix);
2769: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_UPDATE_ERROR');
2770: fnd_message.set_token('BO_CODE', G_PER_CUST_BO_CODE);
2771: fnd_msg_pub.ADD;
2772: RAISE FND_API.G_EXC_ERROR;
2773: END IF;
2774: -- generate update statement for Org Customer BO

Line 2794: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_UPDATE_ERROR');

2790: END IF;
2791: -- raise to calling program, in this case BOD API
2792: l_msg := 'error generating evt type upd stmt for '||G_ORG_CUST_BO_CODE||' BO';
2793: writeDebugMesg(l_msg||sqlerrm, l_gen_prefix);
2794: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_UPDATE_ERROR');
2795: fnd_message.set_token('BO_CODE', G_ORG_CUST_BO_CODE);
2796: fnd_msg_pub.ADD;
2797: RAISE FND_API.G_EXC_ERROR;
2798: END IF;

Line 2795: fnd_message.set_token('BO_CODE', G_ORG_CUST_BO_CODE);

2791: -- raise to calling program, in this case BOD API
2792: l_msg := 'error generating evt type upd stmt for '||G_ORG_CUST_BO_CODE||' BO';
2793: writeDebugMesg(l_msg||sqlerrm, l_gen_prefix);
2794: fnd_message.set_name('AR', 'HZ_BES_BO_EVTYPE_UPDATE_ERROR');
2795: fnd_message.set_token('BO_CODE', G_ORG_CUST_BO_CODE);
2796: fnd_msg_pub.ADD;
2797: RAISE FND_API.G_EXC_ERROR;
2798: END IF;
2799: l_msg := l_procName||'()-';