DBA Data[Home] [Help]

APPS.OKC_DELIVERABLE_WF_PVT dependencies on FND_MSG_PUB

Line 715: FND_MSG_PUB.add;

711: WHEN OTHERS THEN
712: FND_MESSAGE.SET_NAME('OKC', 'OKC_CREATE_ADHOC_USER_FAILED');
713: FND_MESSAGE.set_token('USER_NAME',l_user_tbl(k));
714: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
715: FND_MSG_PUB.add;
716: RAISE FND_API.G_EXC_ERROR;
717: END;
718: END LOOP;
719:

Line 748: FND_MSG_PUB.add;

744: WHEN OTHERS THEN
745: FND_MESSAGE.SET_NAME('OKC','OKC_CREATE_ADHOC_ROLE_FAILED');
746: FND_MESSAGE.set_token('ROLE_NAME',l_external_role_name);
747: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
748: FND_MSG_PUB.add;
749: RAISE FND_API.G_EXC_ERROR;
750: END;
751:
752: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 792: FND_MSG_PUB.add;

788: WHEN OTHERS THEN
789: FND_MESSAGE.SET_NAME('OKC','OKC_CREATE_ADHOC_ROLE_FAILED');
790: FND_MESSAGE.set_token('ROLE_NAME',l_external_role_name);
791: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
792: FND_MSG_PUB.add;
793: RAISE FND_API.G_EXC_ERROR;
794: END;
795:
796: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1082: If ext_user_email%ISOPEN then
1083: CLOSE ext_user_email;
1084: End If;
1085:
1086: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
1087: , p_count => x_msg_count
1088: , p_data => x_msg_data );
1089:
1090: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error message count: '||to_char(x_msg_count));

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

1090: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error message count: '||to_char(x_msg_count));
1091:
1092: FOR i IN 1..x_msg_count LOOP
1093: FND_FILE.PUT_LINE(FND_FILE.LOG,
1094: 'Error message number '||i||': '||FND_MSG_PUB.get(p_msg_index => i,p_encoded => 'F'));
1095: END LOOP;
1096:
1097: if x_msg_count > 1 then
1098: x_msg_data := substr(FND_MSG_PUB.get(p_msg_index => x_msg_count,

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

1094: 'Error message number '||i||': '||FND_MSG_PUB.get(p_msg_index => i,p_encoded => 'F'));
1095: END LOOP;
1096:
1097: if x_msg_count > 1 then
1098: x_msg_data := substr(FND_MSG_PUB.get(p_msg_index => x_msg_count,
1099: p_encoded => 'F'),1,250);
1100:
1101: x_msg_count := 1;
1102: end if;

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

1127: x_return_status := G_RET_STS_UNEXP_ERROR ;
1128:
1129: /* commented to avoid display problem in OA page if there are more than
1130: one message in the stack.
1131: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1132: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1133: END IF;*/
1134: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1135: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module,'700: Leaving Deliverable Notifier with G_RET_STS_UNEXP_ERROR');

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

1128:
1129: /* commented to avoid display problem in OA page if there are more than
1130: one message in the stack.
1131: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1132: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1133: END IF;*/
1134: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1135: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module,'700: Leaving Deliverable Notifier with G_RET_STS_UNEXP_ERROR');
1136: END IF;