376: );
377: END IF;
378:
379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
381: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
382:
383: WHEN FND_API.G_EXC_ERROR
384: THEN
377: END IF;
378:
379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
381: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
382:
383: WHEN FND_API.G_EXC_ERROR
384: THEN
385: g_log_msg := 'EXC_ERROR in GMF_transaction_accounts_PUB.get_accounts_po: ' || x_msg_data;
394:
395: x_return_status := FND_API.G_RET_STS_ERROR;
396: IF x_msg_data IS NULL
397: THEN
398: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
399: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
400: END IF;
401:
402: WHEN OTHERS THEN
395: x_return_status := FND_API.G_RET_STS_ERROR;
396: IF x_msg_data IS NULL
397: THEN
398: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
399: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
400: END IF;
401:
402: WHEN OTHERS THEN
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
400: END IF;
401:
402: WHEN OTHERS THEN
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
404: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
405: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
406:
407: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
408: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
401:
402: WHEN OTHERS THEN
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
404: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
405: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
406:
407: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
408: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
409: end if;
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
404: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
405: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
406:
407: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
408: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
409: end if;
410:
411: g_log_msg := 'In when-others. error: ' || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE;
404: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
405: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
406:
407: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
408: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
409: end if;
410:
411: g_log_msg := 'In when-others. error: ' || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE;
412: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
680: EXCEPTION
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
682: THEN
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
684: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
685: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
686:
687: g_log_msg := 'Exc_Unexpected_Error. Error: ' || x_msg_data;
688: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
682: THEN
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
684: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
685: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
686:
687: g_log_msg := 'Exc_Unexpected_Error. Error: ' || x_msg_data;
688: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
689: THEN
699: THEN
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: IF x_msg_data IS NULL
702: THEN
703: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
704: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
705: END IF;
706:
707: g_log_msg := 'EXC_ERROR. Error: ' || x_msg_data;
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: IF x_msg_data IS NULL
702: THEN
703: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
704: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
705: END IF;
706:
707: g_log_msg := 'EXC_ERROR. Error: ' || x_msg_data;
708: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
716:
717:
718: WHEN OTHERS THEN
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
720: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
721: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
722:
723: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
724: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
717:
718: WHEN OTHERS THEN
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
720: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
721: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
722:
723: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
724: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
725: end if;
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
720: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
721: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
722:
723: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
724: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
725: end if;
726:
727: g_log_msg := 'In when-others. Error: ' || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE;
720: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
721: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
722:
723: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
724: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
725: end if;
726:
727: g_log_msg := 'In when-others. Error: ' || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE;
728: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )