DBA Data[Home] [Help]

APPS.OKC_DELIVERABLE_WF_PVT dependencies on FND_MSG_PUB

Line 649: FND_MSG_PUB.add;

645: WHEN OTHERS THEN
646: FND_MESSAGE.SET_NAME('OKC', 'OKC_CREATE_ADHOC_USER_FAILED');
647: FND_MESSAGE.set_token('USER_NAME',l_user_tbl(k));
648: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
649: FND_MSG_PUB.add;
650: RAISE FND_API.G_EXC_ERROR;
651: END;
652: END LOOP;
653:

Line 682: FND_MSG_PUB.add;

678: WHEN OTHERS THEN
679: FND_MESSAGE.SET_NAME('OKC','OKC_CREATE_ADHOC_ROLE_FAILED');
680: FND_MESSAGE.set_token('ROLE_NAME',l_external_role_name);
681: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
682: FND_MSG_PUB.add;
683: RAISE FND_API.G_EXC_ERROR;
684: END;
685:
686: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 726: FND_MSG_PUB.add;

722: WHEN OTHERS THEN
723: FND_MESSAGE.SET_NAME('OKC','OKC_CREATE_ADHOC_ROLE_FAILED');
724: FND_MESSAGE.set_token('ROLE_NAME',l_external_role_name);
725: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
726: FND_MSG_PUB.add;
727: RAISE FND_API.G_EXC_ERROR;
728: END;
729:
730: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 945: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'

941: If ext_user_email%ISOPEN then
942: CLOSE ext_user_email;
943: End If;
944:
945: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
946: , p_count => x_msg_count
947: , p_data => x_msg_data );
948:
949: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error message count: '||to_char(x_msg_count));

Line 953: 'Error message number '||i||': '||FND_MSG_PUB.get(p_msg_index => i,p_encoded => 'F'));

949: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error message count: '||to_char(x_msg_count));
950:
951: FOR i IN 1..x_msg_count LOOP
952: FND_FILE.PUT_LINE(FND_FILE.LOG,
953: 'Error message number '||i||': '||FND_MSG_PUB.get(p_msg_index => i,p_encoded => 'F'));
954: END LOOP;
955:
956: if x_msg_count > 1 then
957: x_msg_data := substr(FND_MSG_PUB.get(p_msg_index => x_msg_count,

Line 957: x_msg_data := substr(FND_MSG_PUB.get(p_msg_index => x_msg_count,

953: 'Error message number '||i||': '||FND_MSG_PUB.get(p_msg_index => i,p_encoded => 'F'));
954: END LOOP;
955:
956: if x_msg_count > 1 then
957: x_msg_data := substr(FND_MSG_PUB.get(p_msg_index => x_msg_count,
958: p_encoded => 'F'),1,250);
959:
960: x_msg_count := 1;
961: end if;

Line 990: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

986: x_return_status := G_RET_STS_UNEXP_ERROR ;
987:
988: /* commented to avoid display problem in OA page if there are more than
989: one message in the stack.
990: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
991: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
992: END IF;*/
993: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
994: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module,'700: Leaving Deliverable Notifier with G_RET_STS_UNEXP_ERROR');

Line 991: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

987:
988: /* commented to avoid display problem in OA page if there are more than
989: one message in the stack.
990: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
991: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
992: END IF;*/
993: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
994: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module,'700: Leaving Deliverable Notifier with G_RET_STS_UNEXP_ERROR');
995: END IF;