eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_BES_BO_GEN_PKG dependencies on FND_MSG_PUB

Line 102: FND_MSG_PUB.Reset;

98:
99: PROCEDURE logerr IS
100: l_msg_data VARCHAR2(2000);
101: BEGIN
102: FND_MSG_PUB.Reset;
103: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
104: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
105: END LOOP;
106: -- FND_MSG_PUB.Delete_Msg;

Line 103: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

99: PROCEDURE logerr IS
100: l_msg_data VARCHAR2(2000);
101: BEGIN
102: FND_MSG_PUB.Reset;
103: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
104: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
105: END LOOP;
106: -- FND_MSG_PUB.Delete_Msg;
107: END logerr;

Line 104: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

100: l_msg_data VARCHAR2(2000);
101: BEGIN
102: FND_MSG_PUB.Reset;
103: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
104: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
105: END LOOP;
106: -- FND_MSG_PUB.Delete_Msg;
107: END logerr;
108: **/

Line 106: -- FND_MSG_PUB.Delete_Msg;

102: FND_MSG_PUB.Reset;
103: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
104: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
105: END LOOP;
106: -- FND_MSG_PUB.Delete_Msg;
107: END logerr;
108: **/
109: ----------------------------------------------
110: /**

Line 118: FND_MSG_PUB.Reset;

114: ----------------------------------------------
115: FUNCTION logerror RETURN VARCHAR2 IS
116: l_msg_data VARCHAR2(2000);
117: BEGIN
118: FND_MSG_PUB.Reset;
119:
120: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
121: l_msg_data := l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
122: END LOOP;

Line 120: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

116: l_msg_data VARCHAR2(2000);
117: BEGIN
118: FND_MSG_PUB.Reset;
119:
120: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
121: l_msg_data := l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
122: END LOOP;
123: log(l_msg_data);
124: RETURN l_msg_data;

Line 121: l_msg_data := l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );

117: BEGIN
118: FND_MSG_PUB.Reset;
119:
120: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
121: l_msg_data := l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
122: END LOOP;
123: log(l_msg_data);
124: RETURN l_msg_data;
125: END logerror;

Line 149: FND_MSG_PUB.ADD;

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:
152: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
153: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

Line 150: FND_MSG_PUB.Reset;

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:
152: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
153: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
154: END LOOP;

Line 152: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

148: END IF;
149: FND_MSG_PUB.ADD;
150: FND_MSG_PUB.Reset;
151:
152: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
153: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
154: END LOOP;
155:
156: END mesglog;

Line 153: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

149: FND_MSG_PUB.ADD;
150: FND_MSG_PUB.Reset;
151:
152: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
153: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
154: END LOOP;
155:
156: END mesglog;
157:

Line 180: FND_MSG_PUB.ADD;

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:
183: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
184: out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

Line 181: FND_MSG_PUB.Reset;

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:
183: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
184: out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
185: END LOOP;

Line 183: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

179: END IF;
180: FND_MSG_PUB.ADD;
181: FND_MSG_PUB.Reset;
182:
183: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
184: out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
185: END LOOP;
186:
187: END mesgout;

Line 184: out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

180: FND_MSG_PUB.ADD;
181: FND_MSG_PUB.Reset;
182:
183: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
184: out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
185: END LOOP;
186:
187: END mesgout;
188:

Line 211: FND_MSG_PUB.ADD;

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:
214: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
215: outandlog(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

Line 212: FND_MSG_PUB.Reset;

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:
214: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
215: outandlog(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
216: END LOOP;

Line 214: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

210: END IF;
211: FND_MSG_PUB.ADD;
212: FND_MSG_PUB.Reset;
213:
214: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
215: outandlog(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
216: END LOOP;
217:
218: END mesgoutlog;

Line 215: outandlog(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

211: FND_MSG_PUB.ADD;
212: FND_MSG_PUB.Reset;
213:
214: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
215: outandlog(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
216: END LOOP;
217:
218: END mesgoutlog;
219: ---------------------------------------------------------------------

Line 1067: fnd_msg_pub.ADD;

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');
1071: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1073: fnd_msg_pub.ADD;

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;
1077: WHEN 'HZ_CITIZENSHIP' THEN

Line 1091: fnd_msg_pub.ADD;

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');
1095: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1097: fnd_msg_pub.ADD;

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;
1101: WHEN 'HZ_CODE_ASSIGNMENTS' THEN

Line 1115: fnd_msg_pub.ADD;

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');
1119: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1121: fnd_msg_pub.ADD;

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;
1125: WHEN 'HZ_CONTACT_POINTS' THEN

Line 1184: fnd_msg_pub.ADD;

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');
1188: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1190: fnd_msg_pub.ADD;

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;
1194: WHEN 'PERSON' THEN

Line 1234: fnd_msg_pub.ADD;

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');
1238: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1240: fnd_msg_pub.ADD;

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;
1244: WHEN 'ORG_CONTACT' THEN

Line 1297: fnd_msg_pub.ADD;

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');
1301: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1303: fnd_msg_pub.ADD;

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;
1307: WHEN 'PARTY_SITE' THEN

Line 1347: fnd_msg_pub.ADD;

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');
1351: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1353: fnd_msg_pub.ADD;

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;
1357: ELSE

Line 1362: fnd_msg_pub.ADD;

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');
1366: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1368: fnd_msg_pub.ADD;

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
1372: WHEN 'HZ_CONTACT_PREFERENCES' THEN

Line 1457: fnd_msg_pub.ADD;

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');
1461: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1463: fnd_msg_pub.ADD;

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
1467: WHEN 'HZ_CREDIT_RATINGS' THEN

Line 1481: fnd_msg_pub.ADD;

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');
1485: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1487: fnd_msg_pub.ADD;

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;
1491: WHEN 'HZ_CUST_ACCOUNT_ROLES' THEN

Line 1513: fnd_msg_pub.ADD;

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');
1517: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1519: fnd_msg_pub.ADD;

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
1523: WHEN 'HZ_CUST_ACCOUNTS' THEN

Line 1537: fnd_msg_pub.ADD;

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');
1541: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1543: fnd_msg_pub.ADD;

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
1547: WHEN 'HZ_CUST_ACCT_RELATE_ALL' THEN

Line 1561: fnd_msg_pub.ADD;

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');
1565: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1567: fnd_msg_pub.ADD;

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
1571: WHEN 'HZ_CUST_ACCT_SITES_ALL' THEN

Line 1585: fnd_msg_pub.ADD;

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');
1589: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1591: fnd_msg_pub.ADD;

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
1595: WHEN 'HZ_CUST_PROFILE_AMTS' THEN

Line 1608: fnd_msg_pub.ADD;

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');
1612: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1613: 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
1617: WHEN 'HZ_CUST_SITE_USES_ALL' THEN

Line 1632: fnd_msg_pub.ADD;

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');
1636: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1638: fnd_msg_pub.ADD;

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
1642: WHEN 'HZ_CUSTOMER_PROFILES' THEN

Line 1664: fnd_msg_pub.ADD;

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');
1668: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1670: fnd_msg_pub.ADD;

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
1674: WHEN 'HZ_EDUCATION' THEN

Line 1688: fnd_msg_pub.ADD;

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');
1692: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1694: fnd_msg_pub.ADD;

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
1698: WHEN 'HZ_EMPLOYMENT_HISTORY' THEN

Line 1712: fnd_msg_pub.ADD;

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');
1716: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1718: fnd_msg_pub.ADD;

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
1722: WHEN 'HZ_FINANCIAL_NUMBERS' THEN

Line 1736: fnd_msg_pub.ADD;

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');
1740: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1742: fnd_msg_pub.ADD;

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
1746: WHEN 'HZ_FINANCIAL_PROFILE' THEN

Line 1761: fnd_msg_pub.ADD;

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');
1765: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1767: fnd_msg_pub.ADD;

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
1771: WHEN 'HZ_FINANCIAL_REPORTS' THEN

Line 1785: fnd_msg_pub.ADD;

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');
1789: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1791: fnd_msg_pub.ADD;

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
1795: WHEN 'HZ_LOCATIONS' THEN

Line 1810: fnd_msg_pub.ADD;

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');
1814: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1816: fnd_msg_pub.ADD;

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
1820: WHEN 'HZ_ORG_CONTACT_ROLES' THEN

Line 1835: fnd_msg_pub.ADD;

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');
1839: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1841: fnd_msg_pub.ADD;

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
1845: WHEN 'HZ_ORG_CONTACTS' THEN

Line 1891: fnd_msg_pub.ADD;

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');
1895: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1897: fnd_msg_pub.ADD;

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
1901: WHEN 'HZ_ORGANIZATION_PROFILES' THEN

Line 1915: fnd_msg_pub.ADD;

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');
1919: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1921: fnd_msg_pub.ADD;

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
1925: WHEN 'HZ_PARTIES' THEN

Line 1984: fnd_msg_pub.ADD;

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');
1988: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 1990: fnd_msg_pub.ADD;

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
1994: WHEN 'HZ_PARTY_PREFERENCES' THEN

Line 2008: fnd_msg_pub.ADD;

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');
2012: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 2014: fnd_msg_pub.ADD;

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
2018: WHEN 'HZ_PARTY_SITE_USES' THEN

Line 2032: fnd_msg_pub.ADD;

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');
2036: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 2038: fnd_msg_pub.ADD;

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
2042: WHEN 'HZ_PARTY_SITES' THEN

Line 2079: fnd_msg_pub.ADD;

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');
2083: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 2085: fnd_msg_pub.ADD;

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
2089: WHEN 'HZ_PARTY_USG_ASSIGNMENTS' THEN

Line 2103: fnd_msg_pub.ADD;

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');
2107: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 2109: fnd_msg_pub.ADD;

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'
2113: WHEN 'HZ_PERSON_INTEREST' THEN

Line 2127: fnd_msg_pub.ADD;

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');
2131: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 2133: fnd_msg_pub.ADD;

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
2137: WHEN 'HZ_PERSON_LANGUAGE' THEN

Line 2151: fnd_msg_pub.ADD;

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');
2155: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 2157: fnd_msg_pub.ADD;

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
2161: WHEN 'HZ_PERSON_PROFILES' THEN

Line 2176: fnd_msg_pub.ADD;

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');
2180: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 2182: fnd_msg_pub.ADD;

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
2186: WHEN 'HZ_RELATIONSHIPS' THEN

Line 2215: fnd_msg_pub.ADD;

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');
2219: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 2221: fnd_msg_pub.ADD;

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
2225: WHEN 'HZ_ROLE_RESPONSIBILITY' THEN

Line 2239: fnd_msg_pub.ADD;

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');
2243: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 2245: fnd_msg_pub.ADD;

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
2249: WHEN 'HZ_WORK_CLASS' THEN

Line 2263: fnd_msg_pub.ADD;

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');
2267: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 2269: fnd_msg_pub.ADD;

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
2273: WHEN 'RA_CUST_RECEIPT_METHODS' THEN

Line 2295: fnd_msg_pub.ADD;

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');
2299: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 2301: fnd_msg_pub.ADD;

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
2305: -- For Bank Account Use

Line 2328: fnd_msg_pub.ADD;

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');
2332: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 2334: fnd_msg_pub.ADD;

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
2338: ELSE

Line 2342: fnd_msg_pub.ADD;

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');
2346: fnd_message.set_token('ENTITY_NAME' ,l_node_tbl(i).ENTITY_NAME);

Line 2347: 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: /*
2351: */

Line 2519: fnd_msg_pub.ADD;

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;
2523: li(' ');

Line 2548: fnd_msg_pub.ADD;

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;
2552: li(' ');

Line 2577: fnd_msg_pub.ADD;

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;
2581: li(' ');

Line 2606: fnd_msg_pub.ADD;

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;
2610: l_msg := l_procName||'()-';

Line 2719: fnd_msg_pub.ADD;

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;
2723: -- generate update statement for Org BO

Line 2746: fnd_msg_pub.ADD;

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
2750: li('IF P_BO_CODE ='''||G_PER_CUST_BO_CODE||''' THEN');

Line 2771: fnd_msg_pub.ADD;

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
2775: li('IF P_BO_CODE ='''||G_ORG_CUST_BO_CODE||''' THEN');

Line 2796: fnd_msg_pub.ADD;

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||'()-';
2800: writeDebugMesg(l_msg, l_gen_prefix);