APPS.IEM_ROUTE_PUB dependencies on FND_API

Line 16: -- Fixed GSCC warning: NOCOPY, FND_API.G_MISS...

12: -- Liang Xia 06/05/2002 Added Dynamic Route function
13: -- Liang Xia 08/06/2002 Changed jtf_rs_roles_vl to jtf_rs_roles_b, jtf_rs_group_members_vl to jtf_rs_group_members for
14: -- performance issue.
15: -- Liang Xia 11/12/2002 Added All_email tag, which overwrite the rules
16: -- Fixed GSCC warning: NOCOPY, FND_API.G_MISS...
17: -- Liang Xia 11/26/2002 Not to route groups that are expired.
18: -- Liang Xia 09/24/2003 Not to route groups that don't have 'Call Center' usage
19: -- Liang Xia 08/24/2004 Tar 4021452.999/bug 3855036.
20: -- Do not Auto-Route to agent if the agent has been auto-routed, but requeued the message

Line 379: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

375: l_msg_id VARCHAR2(15);
376: l_count NUMBER := 0;
377:
378: l_result VARCHAR2(256);
379: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
380: l_msg_count NUMBER := 0;
381: l_msg_data VARCHAR2(2000);
382:
383: logMessage varchar2(2000);

Line 393: IF NOT FND_API.Compatible_API_Call(

389:
390: --Standard begin of API savepoint
391: SAVEPOINT Route_PUB;
392: -- Standard call to check for call compatibility.
393: IF NOT FND_API.Compatible_API_Call(
394: l_api_version_number,
395: p_api_version_number,
396: l_api_name,
397: G_PKG_NAME)

Line 399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

395: p_api_version_number,
396: l_api_name,
397: G_PKG_NAME)
398: THEN
399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
400: END IF;
401: -- Initialize message list if p_init_msg_list is set to TRUE.
402: IF FND_API.to_Boolean( p_init_msg_list ) THEN
403: FND_MSG_PUB.initialize;

Line 402: IF FND_API.to_Boolean( p_init_msg_list ) THEN

398: THEN
399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
400: END IF;
401: -- Initialize message list if p_init_msg_list is set to TRUE.
402: IF FND_API.to_Boolean( p_init_msg_list ) THEN
403: FND_MSG_PUB.initialize;
404: END IF;
405:
406: -- Initialize API return status to SUCCESS

Line 407: x_return_status := FND_API.G_RET_STS_SUCCESS;

403: FND_MSG_PUB.initialize;
404: END IF;
405:
406: -- Initialize API return status to SUCCESS
407: x_return_status := FND_API.G_RET_STS_SUCCESS;
408:
409: --=================--
410: -- Begining of API --
411: --=================--

Line 470: p_init_msg_list => FND_API.G_FALSE,

466: -- begin PROCEDURE processing
467: BEGIN
468: IEM_ROUTE_RUN_PROC_PVT.run_Procedure(
469: p_api_version_number =>P_Api_Version_Number,
470: p_init_msg_list => FND_API.G_FALSE,
471: p_commit => P_Commit,
472: p_procedure_name => procedureName,
473: p_key_value => p_keyVals_tbl,
474: p_param_type => returnParamType,

Line 480: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

476: x_return_status => l_return_status,
477: x_msg_count => l_msg_count,
478: x_msg_data => l_msg_data);
479:
480: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
481: if l_log_enabled then
482: logMessage := '[ERROR when execute procedure for RouteID: '||v_routes.route_id ||']';
483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.DYNAMIC_ROUTE', logMessage);
484: end if;

Line 641: If FND_API.To_Boolean(p_commit) then

637: --End of API--
638: --==========--
639:
640: --Standard check of p_commit
641: If FND_API.To_Boolean(p_commit) then
642: COMMIT WORK;
643: End if;
644:
645: --Standard call to get message count and if count is 1 then get message info

Line 649: WHEN FND_API.G_EXC_ERROR THEN

645: --Standard call to get message count and if count is 1 then get message info
646: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
647:
648: EXCEPTION
649: WHEN FND_API.G_EXC_ERROR THEN
650: Rollback to Route_PUB;
651: x_return_status := FND_API.G_RET_STS_ERROR;
652:
653: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 651: x_return_status := FND_API.G_RET_STS_ERROR;

647:
648: EXCEPTION
649: WHEN FND_API.G_EXC_ERROR THEN
650: Rollback to Route_PUB;
651: x_return_status := FND_API.G_RET_STS_ERROR;
652:
653: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
654:
655: if l_exception_log then

Line 660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

656: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Execution Error';
657: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.EXEC_ERROR', errorMessage);
658: end if;
659:
660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
661: Rollback to Route_PUB;
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
664: if l_exception_log then

Line 662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

658: end if;
659:
660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
661: Rollback to Route_PUB;
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
664: if l_exception_log then
665: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Unexpected Execution Error';
666: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.UNEXP_EXEC_ERROR', errorMessage);

Line 671: x_return_status := FND_API.G_RET_STS_ERROR;

667: end if;
668:
669: WHEN OTHERS THEN
670: Rollback to Route_PUB;
671: x_return_status := FND_API.G_RET_STS_ERROR;
672: IF fnd_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
673: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
674: END IF;
675: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 688: x_value VARCHAR(256):=''; --FND_API.G_MISS_CHAR;

684: function get_key_value ( p_keyVals_tbl IN keyVals_tbl_type,
685: p_key_name IN VARCHAR2 )
686: return VARCHAR2
687: is
688: x_value VARCHAR(256):=''; --FND_API.G_MISS_CHAR;
689: begin
690: if p_keyVals_tbl.count <> 0 then
691: for i in 1..p_keyVals_tbl.count loop
692: if p_keyVals_tbl(i).key = p_key_name then