eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEU_MSG_PRODUCER_PUB dependencies on FND_API

Line 6: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2: /* $Header: IEUPMSGB.pls 120.0 2005/06/02 15:56:07 appldev noship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IEU_MSG_PRODUCER_PUB';
4: PROCEDURE SEND_PLAIN_TEXT_MSG (
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
7: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
8: p_application_id IN NUMBER,
9: p_resource_id IN NUMBER,
10: p_resource_type IN VARCHAR2 DEFAULT 'RS_INDIVIDUAL',

Line 7: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IEU_MSG_PRODUCER_PUB';
4: PROCEDURE SEND_PLAIN_TEXT_MSG (
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
7: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
8: p_application_id IN NUMBER,
9: p_resource_id IN NUMBER,
10: p_resource_type IN VARCHAR2 DEFAULT 'RS_INDIVIDUAL',
11: p_title IN VARCHAR2,

Line 57: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)

53: -- Ray Cardillo (06-15-201)
54:
55: Savepoint SEND_PLAIN_TEXT_PUB;
56:
57: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
58: then
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61:

Line 59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

55: Savepoint SEND_PLAIN_TEXT_PUB;
56:
57: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
58: then
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61:
62: IF fnd_api.to_boolean(p_init_msg_list)
63: then

Line 62: IF fnd_api.to_boolean(p_init_msg_list)

58: then
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61:
62: IF fnd_api.to_boolean(p_init_msg_list)
63: then
64: FND_MSG_PUB.initialize;
65: end if;
66:

Line 67: x_return_status := FND_API.G_RET_STS_SUCCESS;

63: then
64: FND_MSG_PUB.initialize;
65: end if;
66:
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: IF ( (p_api_version IS NULL) OR
70: (p_commit is NULL) OR
71: (p_application_id is NULL) OR

Line 100: x_return_status := FND_API.G_RET_STS_ERROR;

96: if p_body is null then
97: -- l_msg_param := l_msg_param||' p_body = ' || p_body ;
98: l_msg_param := l_msg_param||' P_BODY';
99: end if;
100: x_return_status := FND_API.G_RET_STS_ERROR;
101: fnd_message.set_name('IEU','IEU_UWQ_REQUIRED_PARAM_NULL');
102: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_MSG_PRODUCER_PUB.SEND_PLAIN_TEXT_MSG');
103: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_msg_param);
104: fnd_msg_pub.add;

Line 118: x_return_status := FND_API.G_RET_STS_ERROR;

114: if length(p_body) > b_max then
115: l_param_max := l_param_max||' LENGTH(P_BODY) = ' || LENGTH(P_BODY) || ' MAX for Body = ' || b_max ;
116: end if;
117:
118: x_return_status := FND_API.G_RET_STS_ERROR;
119: fnd_message.set_name('IEU','IEU_UWQ_PARAM_EXCEED_MAX');
120: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_MSG_PRODUCER_PUB.SEND_PLAIN_TEXT_MSG');
121: FND_MESSAGE.SET_TOKEN('IEU_UWQ_PARAM_MAX',l_param_max);
122: fnd_msg_pub.add;

Line 128: x_return_status := FND_API.G_RET_STS_ERROR;

124: END IF;
125:
126: IF p_resource_TYPE = 'RS_GROUP' or p_resource_TYPE = 'RS_TEAM'
127: THEN
128: x_return_status := FND_API.G_RET_STS_ERROR;
129: fnd_message.set_name('IEU','IEU_UWQ_INVALID_RESOURCE_TYPE');
130: FND_MESSAGE.SET_TOKEN('IEU_UWQ_RESOURCE_TYPE',P_RESOURCE_TYPE);
131: fnd_msg_pub.add;
132: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 135: if x_return_status = FND_API.G_RET_STS_ERROR THEN

131: fnd_msg_pub.add;
132: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
133: END IF;
134:
135: if x_return_status = FND_API.G_RET_STS_ERROR THEN
136: raise FND_API.G_EXC_ERROR;
137: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
138: raise FND_API.G_EXC_UNEXPECTED_ERROR;
139: END IF;

Line 136: raise FND_API.G_EXC_ERROR;

132: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
133: END IF;
134:
135: if x_return_status = FND_API.G_RET_STS_ERROR THEN
136: raise FND_API.G_EXC_ERROR;
137: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
138: raise FND_API.G_EXC_UNEXPECTED_ERROR;
139: END IF;
140:

Line 137: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

133: END IF;
134:
135: if x_return_status = FND_API.G_RET_STS_ERROR THEN
136: raise FND_API.G_EXC_ERROR;
137: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
138: raise FND_API.G_EXC_UNEXPECTED_ERROR;
139: END IF;
140:
141: select IEU_MSG_MESSAGES_S1.NEXTVAL into x_message_id from dual;

Line 138: raise FND_API.G_EXC_UNEXPECTED_ERROR;

134:
135: if x_return_status = FND_API.G_RET_STS_ERROR THEN
136: raise FND_API.G_EXC_ERROR;
137: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
138: raise FND_API.G_EXC_UNEXPECTED_ERROR;
139: END IF;
140:
141: select IEU_MSG_MESSAGES_S1.NEXTVAL into x_message_id from dual;
142: INSERT INTO

Line 180: IF FND_API.To_Boolean(p_commit) THEN

176: p_workitem_obj_code,
177: p_workitem_pk_id
178: );
179: -- Standard check of p_commit
180: IF FND_API.To_Boolean(p_commit) THEN
181: COMMIT WORK;
182: END IF;
183: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
184: -- Standard call to get message count and if count is 1, get message info

Line 186: WHEN FND_API.G_EXC_ERROR THEN

182: END IF;
183: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
184: -- Standard call to get message count and if count is 1, get message info
185: EXCEPTION
186: WHEN FND_API.G_EXC_ERROR THEN
187: ROLLBACK TO SEND_PLAIN_TEXT_PUB;
188: x_return_status := FND_API.G_RET_STS_ERROR;
189: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 188: x_return_status := FND_API.G_RET_STS_ERROR;

184: -- Standard call to get message count and if count is 1, get message info
185: EXCEPTION
186: WHEN FND_API.G_EXC_ERROR THEN
187: ROLLBACK TO SEND_PLAIN_TEXT_PUB;
188: x_return_status := FND_API.G_RET_STS_ERROR;
189: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: ROLLBACK TO SEND_PLAIN_TEXT_PUB;
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

186: WHEN FND_API.G_EXC_ERROR THEN
187: ROLLBACK TO SEND_PLAIN_TEXT_PUB;
188: x_return_status := FND_API.G_RET_STS_ERROR;
189: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: ROLLBACK TO SEND_PLAIN_TEXT_PUB;
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
193: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
194: WHEN OTHERS THEN

Line 192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

188: x_return_status := FND_API.G_RET_STS_ERROR;
189: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: ROLLBACK TO SEND_PLAIN_TEXT_PUB;
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
193: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
194: WHEN OTHERS THEN
195: ROLLBACK TO SEND_PLAIN_TEXT_PUB;
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
193: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
194: WHEN OTHERS THEN
195: ROLLBACK TO SEND_PLAIN_TEXT_PUB;
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
197: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
198: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
199: END IF;
200: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);