230: IF x_return_status <> FND_API.g_ret_sts_success THEN
231: l_error_code := 'CN_HIER_FAIL_CREATE';
232: IF l_msg_count > 1 THEN
233: l_message :=
234: fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_FIRST);
235: END IF;
236: RAISE FND_API.g_exc_error;
237: END IF;
238: END;
370: IF x_return_status <> FND_API.g_ret_sts_success THEN
371: l_error_code := 'CN_HIER_FAIL_CREATE';
372: IF l_msg_count > 1 THEN
373: l_message :=
374: fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_FIRST);
375: END IF;
376: RAISE FND_API.g_exc_error;
377: END IF;
378: END;
490: IF x_return_status <> FND_API.g_ret_sts_success THEN
491: l_error_code := 'CN_HIER_FAIL_CREATE';
492: IF l_msg_count > 1 THEN
493: l_message :=
494: fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_FIRST);
495: END IF;
496: RAISE FND_API.g_exc_error;
497: END IF;
498: END;
745: IF x_return_status <> FND_API.g_ret_sts_success THEN
746: l_error_code := 'CN_HIER_FAIL_CREATE';
747: IF l_msg_count > 1 THEN
748: l_message :=
749: fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_FIRST);
750: END IF;
751: RAISE FND_API.g_exc_error;
752: END IF;
753: cn_message_pkg.debug('---- new edge created ');
1304: EXCEPTION
1305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1306: retcode := 2 ;
1307: cn_message_pkg.end_batch(l_process_audit_id);
1308: FND_MSG_PUB.count_and_get
1309: (p_count => l_msg_count ,
1310: p_data => errbuf ,
1311: p_encoded => FND_API.G_FALSE
1312: );
1317: retcode := 2 ;
1318: errbuf := fnd_program.message;
1319: ELSE
1320: retcode := 2 ;
1321: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1322: THEN
1323: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1324: END IF;
1325: FND_MSG_PUB.count_and_get
1319: ELSE
1320: retcode := 2 ;
1321: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1322: THEN
1323: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1324: END IF;
1325: FND_MSG_PUB.count_and_get
1326: (p_count => l_msg_count ,
1327: p_data => errbuf ,
1321: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1322: THEN
1323: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1324: END IF;
1325: FND_MSG_PUB.count_and_get
1326: (p_count => l_msg_count ,
1327: p_data => errbuf ,
1328: p_encoded => FND_API.G_FALSE
1329: );