DBA Data[Home] [Help]

APPS.IEX_WF_DEL_STATUS_PUB dependencies on FND_MSG_PUB

Line 58: FND_MSG_PUB.initialize;

54:
55: -- Initialize message list if p_init_msg_list is set to TRUE.
56: IF FND_API.to_Boolean( p_init_msg_list )
57: THEN
58: FND_MSG_PUB.initialize;
59: END IF;
60:
61: -- Debug Message
62: -- IF PG_DEBUG < 10 THEN

Line 64: IEX_DEBUG_PUB.logMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Public API: ' || l_api_name || ' start');

60:
61: -- Debug Message
62: -- IF PG_DEBUG < 10 THEN
63: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
64: IEX_DEBUG_PUB.logMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Public API: ' || l_api_name || ' start');
65: IEX_DEBUG_PUB.logMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
66: END IF;
67: -- Initialize API return status to SUCCESS
68: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 65: IEX_DEBUG_PUB.logMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

61: -- Debug Message
62: -- IF PG_DEBUG < 10 THEN
63: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
64: IEX_DEBUG_PUB.logMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Public API: ' || l_api_name || ' start');
65: IEX_DEBUG_PUB.logMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
66: END IF;
67: -- Initialize API return status to SUCCESS
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:

Line 125: IEX_DEBUG_PUB.logMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'PUB: ' || l_api_name || ' end');

121:
122: -- Debug Message
123: -- IF PG_DEBUG < 10 THEN
124: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
125: IEX_DEBUG_PUB.logMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'PUB: ' || l_api_name || ' end');
126: IEX_DEBUG_PUB.logMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
127: END IF;
128:
129: -- Standard call to get message count and if count is 1, get message info.

Line 126: IEX_DEBUG_PUB.logMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

122: -- Debug Message
123: -- IF PG_DEBUG < 10 THEN
124: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
125: IEX_DEBUG_PUB.logMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'PUB: ' || l_api_name || ' end');
126: IEX_DEBUG_PUB.logMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
127: END IF;
128:
129: -- Standard call to get message count and if count is 1, get message info.
130: FND_MSG_PUB.Count_And_Get

Line 130: FND_MSG_PUB.Count_And_Get

126: IEX_DEBUG_PUB.logMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
127: END IF;
128:
129: -- Standard call to get message count and if count is 1, get message info.
130: FND_MSG_PUB.Count_And_Get
131: ( p_count => x_msg_count,
132: p_data => x_msg_data
133: );
134:

Line 139: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

135: EXCEPTION
136: WHEN FND_API.G_EXC_ERROR THEN
137: ROLLBACK TO START_WORKFLOW;
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
141: ROLLBACK TO START_WORKFLOW;
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 143: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

139: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
141: ROLLBACK TO START_WORKFLOW;
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
144: WHEN OTHERS THEN
145: ROLLBACK TO START_WORKFLOW;
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
147: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 147: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

143: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
144: WHEN OTHERS THEN
145: ROLLBACK TO START_WORKFLOW;
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
147: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
148: THEN
149: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
150: END IF;
151: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

145: ROLLBACK TO START_WORKFLOW;
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
147: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
148: THEN
149: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
150: END IF;
151: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
152: ----------------------------------
153: END start_workflow;

Line 151: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

147: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
148: THEN
149: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
150: END IF;
151: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
152: ----------------------------------
153: END start_workflow;
154:
155: ----------- procedure update_approval_status -----------------------------