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.JTF_TERR_SERVICE_PUB dependencies on FND_API

Line 71: -- p_init_msg_list IN varchar2 optional --default = fnd_api.g_false

67: -- parameters :
68: --
69: -- IN:
70: -- p_api_version_number IN number required
71: -- p_init_msg_list IN varchar2 optional --default = fnd_api.g_false
72: -- p_commit IN varchar2 optional --default = fnd_api.g_false
73: -- p_Org_Id IN number required
74: -- p_TerrServReq_Rec IN JTF_Serv_Req_rec_type
75: -- p_Resource_Type IN varchar2

Line 72: -- p_commit IN varchar2 optional --default = fnd_api.g_false

68: --
69: -- IN:
70: -- p_api_version_number IN number required
71: -- p_init_msg_list IN varchar2 optional --default = fnd_api.g_false
72: -- p_commit IN varchar2 optional --default = fnd_api.g_false
73: -- p_Org_Id IN number required
74: -- p_TerrServReq_Rec IN JTF_Serv_Req_rec_type
75: -- p_Resource_Type IN varchar2
76: -- p_Role IN varchar2

Line 94: p_init_msg_list IN varchar2 := fnd_api.g_false,

90: --
91: -- end of comments
92: procedure Get_WinningTerrMembers
93: ( p_api_version_number IN number,
94: p_init_msg_list IN varchar2 := fnd_api.g_false,
95: p_TerrServReq_Rec IN JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type,
96: p_Resource_Type IN varchar2,
97: p_Role IN varchar2,
98: p_plan_start_date IN DATE DEFAULT NULL,

Line 122: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

118: 'Start of the procedure jtf_terr_service_pub.get_winningterrmembers');
119: END IF;
120:
121: -- Standard call to check for call compatibility.
122: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
123: p_api_version_number,
124: l_api_name,
125: G_PKG_NAME)
126: THEN

Line 127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

123: p_api_version_number,
124: l_api_name,
125: G_PKG_NAME)
126: THEN
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129:
130: -- Initialize message list if p_init_msg_list is set to TRUE.
131: IF FND_API.to_Boolean( p_init_msg_list )

Line 131: IF FND_API.to_Boolean( p_init_msg_list )

127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129:
130: -- Initialize message list if p_init_msg_list is set to TRUE.
131: IF FND_API.to_Boolean( p_init_msg_list )
132: THEN
133: FND_MSG_PUB.initialize;
134: END IF;
135:

Line 138: x_return_status := FND_API.G_RET_STS_SUCCESS;

134: END IF;
135:
136: --
137: -- API body
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: -- debug message
141: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
142: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 407: , DECODE(p_TerrServReq_Rec.DAY_OF_WEEK,FND_API.G_MISS_CHAR,null,

403: UNION ALL
404: SELECT 'DAY_OF_WEEK' attribute_name
405: ,null num_value
406: --,p_TerrServReq_Rec.DAY_OF_WEEK char_value
407: , DECODE(p_TerrServReq_Rec.DAY_OF_WEEK,FND_API.G_MISS_CHAR,null,
408: p_TerrServReq_Rec.DAY_OF_WEEK) char_value
409: ,null date_value
410: FROM DUAL
411: UNION ALL

Line 415: , DECODE(p_TerrServReq_Rec.TIME_OF_DAY,FND_API.G_MISS_CHAR,null,

411: UNION ALL
412: SELECT 'TIME_OF_DAY' attribute_name
413: , null num_value
414: --, p_TerrServReq_Rec.TIME_OF_DAY char_value
415: , DECODE(p_TerrServReq_Rec.TIME_OF_DAY,FND_API.G_MISS_CHAR,null,
416: p_TerrServReq_Rec.TIME_OF_DAY) char_value
417: ,null date_value
418: FROM DUAL
419: UNION ALL

Line 498: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

494: ,x_return_status => x_return_status
495: ,x_msg_count => x_msg_count
496: ,x_msg_data => x_msg_data);
497:
498: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
499: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
500: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
501: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
502: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');

Line 504: RAISE FND_API.G_EXC_ERROR;

500: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
501: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
502: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
503: END IF;
504: RAISE FND_API.G_EXC_ERROR;
505: END IF;
506:
507: -- debug message
508: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 528: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

524: ,x_msg_count => x_msg_count
525: ,x_msg_data => x_msg_data
526: ,x_winners_rec => lx_winners_rec);
527:
528: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
529: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
530: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
531: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
532: 'API JTY_ASSIGN_REALTIME_PUB.process_winners has failed');

Line 534: RAISE FND_API.G_EXC_ERROR;

530: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
531: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
532: 'API JTY_ASSIGN_REALTIME_PUB.process_winners has failed');
533: END IF;
534: RAISE FND_API.G_EXC_ERROR;
535: END IF;
536:
537: -- debug message
538: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 580: WHEN FND_API.G_EXC_ERROR THEN

576: 'End of the procedure jtf_terr_service_pub.get_winningterrmembers');
577: END IF;
578:
579: EXCEPTION
580: WHEN FND_API.G_EXC_ERROR THEN
581: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
582: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
583: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.g_exc_error',
584: substr(x_msg_data, 1, 4000));

Line 588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

584: substr(x_msg_data, 1, 4000));
585: END IF;
586:
587: WHEN OTHERS THEN
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
589: x_msg_data := SQLCODE || ' : ' || SQLERRM;
590: x_msg_count := 1;
591: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
592: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 611: -- p_init_msg_list IN varchar2 optional --default = fnd_api.g_false

607: -- parameters :
608: --
609: -- IN:
610: -- p_api_version_number IN number required
611: -- p_init_msg_list IN varchar2 optional --default = fnd_api.g_false
612: -- p_commit IN varchar2 optional --default = fnd_api.g_false
613: -- p_Org_Id IN number required
614: -- p_TerrSrvTask_Rec IN JTF_srv_Task_rec_type
615: -- p_Resource_Type IN varchar2

Line 612: -- p_commit IN varchar2 optional --default = fnd_api.g_false

608: --
609: -- IN:
610: -- p_api_version_number IN number required
611: -- p_init_msg_list IN varchar2 optional --default = fnd_api.g_false
612: -- p_commit IN varchar2 optional --default = fnd_api.g_false
613: -- p_Org_Id IN number required
614: -- p_TerrSrvTask_Rec IN JTF_srv_Task_rec_type
615: -- p_Resource_Type IN varchar2
616: -- p_Role IN varchar2

Line 639: p_init_msg_list IN varchar2 := fnd_api.g_false,

635: --
636: -- end of comments
637: procedure Get_WinningTerrMembers
638: ( p_api_version_number IN number,
639: p_init_msg_list IN varchar2 := fnd_api.g_false,
640: p_TerrSrvTask_Rec IN JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type,
641: p_Resource_Type IN varchar2,
642: p_Role IN varchar2,
643: p_plan_start_date IN DATE DEFAULT NULL,

Line 666: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

662: 'Start of the procedure jtf_terr_service_pub.get_winningterrmembers');
663: END IF;
664:
665: -- Standard call to check for call compatibility.
666: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
667: p_api_version_number,
668: l_api_name,
669: G_PKG_NAME)
670: THEN

Line 671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

667: p_api_version_number,
668: l_api_name,
669: G_PKG_NAME)
670: THEN
671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
672: END IF;
673:
674: -- Initialize message list if p_init_msg_list is set to TRUE.
675: IF FND_API.to_Boolean( p_init_msg_list )

Line 675: IF FND_API.to_Boolean( p_init_msg_list )

671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
672: END IF;
673:
674: -- Initialize message list if p_init_msg_list is set to TRUE.
675: IF FND_API.to_Boolean( p_init_msg_list )
676: THEN
677: FND_MSG_PUB.initialize;
678: END IF;
679:

Line 683: x_return_status := FND_API.G_RET_STS_SUCCESS;

679:
680: --
681: -- API body
682: --
683: x_return_status := FND_API.G_RET_STS_SUCCESS;
684:
685: -- debug message
686: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
687: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 972: , DECODE(p_TerrSrvTask_Rec.DAY_OF_WEEK,FND_API.G_MISS_CHAR,null,

968: UNION ALL
969: SELECT 'DAY_OF_WEEK' attribute_name
970: ,null num_value
971: --,p_TerrSrvTask_Rec.DAY_OF_WEEK char_value
972: , DECODE(p_TerrSrvTask_Rec.DAY_OF_WEEK,FND_API.G_MISS_CHAR,null,
973: p_TerrSrvTask_Rec.DAY_OF_WEEK) char_value
974: ,null date_value
975: FROM DUAL
976: UNION ALL

Line 980: ,DECODE(p_TerrSrvTask_Rec.TIME_OF_DAY ,FND_API.G_MISS_CHAR,null,

976: UNION ALL
977: SELECT 'TIME_OF_DAY' attribute_name
978: ,null num_value
979: --,p_TerrSrvTask_Rec.TIME_OF_DAY char_value
980: ,DECODE(p_TerrSrvTask_Rec.TIME_OF_DAY ,FND_API.G_MISS_CHAR,null,
981: p_TerrSrvTask_Rec.TIME_OF_DAY ) char_value
982: ,null date_value
983: FROM DUAL
984: UNION ALL

Line 1067: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1063: ,x_return_status => x_return_status
1064: ,x_msg_count => x_msg_count
1065: ,x_msg_data => x_msg_data);
1066:
1067: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1068: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1069: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1070: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
1071: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');

Line 1073: RAISE FND_API.G_EXC_ERROR;

1069: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1070: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
1071: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
1072: END IF;
1073: RAISE FND_API.G_EXC_ERROR;
1074: END IF;
1075:
1076: -- debug message
1077: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1097: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1093: ,x_msg_count => x_msg_count
1094: ,x_msg_data => x_msg_data
1095: ,x_winners_rec => lx_winners_rec);
1096:
1097: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1098: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1099: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1100: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
1101: 'API JTY_ASSIGN_REALTIME_PUB.process_winners has failed');

Line 1103: RAISE FND_API.G_EXC_ERROR;

1099: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1100: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
1101: 'API JTY_ASSIGN_REALTIME_PUB.process_winners has failed');
1102: END IF;
1103: RAISE FND_API.G_EXC_ERROR;
1104: END IF;
1105:
1106: -- debug message
1107: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1149: WHEN FND_API.G_EXC_ERROR THEN

1145: 'End of the procedure jtf_terr_service_pub.get_winningterrmembers');
1146: END IF;
1147:
1148: EXCEPTION
1149: WHEN FND_API.G_EXC_ERROR THEN
1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1151: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1152: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1153: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.g_exc_error',

Line 1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1146: END IF;
1147:
1148: EXCEPTION
1149: WHEN FND_API.G_EXC_ERROR THEN
1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1151: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1152: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1153: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.g_exc_error',
1154: substr(x_msg_data, 1, 4000));

Line 1158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1154: substr(x_msg_data, 1, 4000));
1155: END IF;
1156:
1157: WHEN OTHERS THEN
1158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1159: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1160: x_msg_count := 1;
1161: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1162: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,