APPS.IEM_MC_PUB dependencies on IEM_MC_PARAMETERS

Line 106: SAVEPOINT IEM_MC_PARAMETERS;

102:
103:
104: BEGIN
105:
106: SAVEPOINT IEM_MC_PARAMETERS;
107:
108:
109: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
110: then

Line 142: select IEM_MC_PARAMETERS_S1.NEXTVAL into x_mc_parameters_id from sys.dual;

138: l_mes_document_id := p_mes_document_id;
139: l_mes_category_id := p_mes_category_id;
140: l_interaction_id := p_interaction_id;
141:
142: select IEM_MC_PARAMETERS_S1.NEXTVAL into x_mc_parameters_id from sys.dual;
143:
144: insert into IEM_MC_PARAMETERS
145: (
146: MC_PARAMETER_ID,

Line 144: insert into IEM_MC_PARAMETERS

140: l_interaction_id := p_interaction_id;
141:
142: select IEM_MC_PARAMETERS_S1.NEXTVAL into x_mc_parameters_id from sys.dual;
143:
144: insert into IEM_MC_PARAMETERS
145: (
146: MC_PARAMETER_ID,
147: ACTION,
148: MASTER_ACCOUNT_ID,

Line 228: ROLLBACK TO IEM_MC_PARAMETERS;

224:
225:
226: EXCEPTION
227: WHEN FND_API.G_EXC_ERROR THEN
228: ROLLBACK TO IEM_MC_PARAMETERS;
229:
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: FND_MSG_PUB.Count_And_Get(
232: p_count => x_msg_count,

Line 243: ROLLBACK TO IEM_MC_PARAMETERS;

239: x_msg_data := x_msg_data || ',' || l_msg_data;
240: END LOOP;
241:
242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
243: ROLLBACK TO IEM_MC_PARAMETERS;
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
245: FND_MSG_PUB.Count_And_Get
246: (
247: p_count => x_msg_count,

Line 257: ROLLBACK TO IEM_MC_PARAMETERS;

253: x_msg_data := x_msg_data || ',' || l_msg_data;
254: END LOOP;
255:
256: WHEN OTHERS THEN
257: ROLLBACK TO IEM_MC_PARAMETERS;
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259:
260: FND_MSG_PUB.Count_And_Get (
261: p_count => x_msg_count,

Line 341: select IEM_MC_PARAMETERS_S1.NEXTVAL into x_mc_parameters_id from sys.dual;

337: l_action := 'reply';
338: END IF;
339:
340:
341: select IEM_MC_PARAMETERS_S1.NEXTVAL into x_mc_parameters_id from sys.dual;
342:
343: insert into IEM_MC_PARAMETERS
344: (
345: MC_PARAMETER_ID,

Line 343: insert into IEM_MC_PARAMETERS

339:
340:
341: select IEM_MC_PARAMETERS_S1.NEXTVAL into x_mc_parameters_id from sys.dual;
342:
343: insert into IEM_MC_PARAMETERS
344: (
345: MC_PARAMETER_ID,
346: ACTION,
347: MASTER_ACCOUNT_ID,

Line 438: ROLLBACK TO IEM_MC_PARAMETERS;

434: x_msg_data := x_msg_data || ',' || l_msg_data;
435: END LOOP;
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: ROLLBACK TO IEM_MC_PARAMETERS;
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440: FND_MSG_PUB.Count_And_Get
441: (
442: p_count => x_msg_count,