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;
739: IF x_return_status <> FND_API.g_ret_sts_success THEN
740: l_error_code := 'CN_HIER_FAIL_CREATE';
741: IF l_msg_count > 1 THEN
742: l_message :=
743: fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_FIRST);
744: END IF;
745: RAISE FND_API.g_exc_error;
746: END IF;
747: cn_message_pkg.debug('---- new edge created ');
1298: EXCEPTION
1299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1300: retcode := 2 ;
1301: cn_message_pkg.end_batch(l_process_audit_id);
1302: FND_MSG_PUB.count_and_get
1303: (p_count => l_msg_count ,
1304: p_data => errbuf ,
1305: p_encoded => FND_API.G_FALSE
1306: );
1311: retcode := 2 ;
1312: errbuf := fnd_program.message;
1313: ELSE
1314: retcode := 2 ;
1315: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1316: THEN
1317: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1318: END IF;
1319: FND_MSG_PUB.count_and_get
1313: ELSE
1314: retcode := 2 ;
1315: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1316: THEN
1317: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1318: END IF;
1319: FND_MSG_PUB.count_and_get
1320: (p_count => l_msg_count ,
1321: p_data => errbuf ,
1315: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1316: THEN
1317: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1318: END IF;
1319: FND_MSG_PUB.count_and_get
1320: (p_count => l_msg_count ,
1321: p_data => errbuf ,
1322: p_encoded => FND_API.G_FALSE
1323: );