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

Line 48: x_return_status := FND_API.G_RET_STS_SUCCESS;

44: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
45: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
46:
47: BEGIN
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49: select iem_agents_s1.nextval into l_agent_account_id
50: from dual;
51: INSERT INTO IEM_AGENTS (
52: AGENT_ID ,

Line 82: decode(p_SIGNATURE,FND_API.G_MISS_CHAR,NULL,p_signature),

78: (
79: l_AGENT_ACCOUNT_ID ,
80: p_EMAIL_ACCOUNT_ID ,
81: p_resource_id ,
82: decode(p_SIGNATURE,FND_API.G_MISS_CHAR,NULL,p_signature),
83: decode(p_CREATED_BY,null,-1,p_CREATED_BY),
84: sysdate,
85: decode(p_LAST_UPDATED_BY,null,-1,p_LAST_UPDATED_BY),
86: sysdate,

Line 108: p_init_msg_list => FND_API.G_FALSE,

104:
105: --Insert into Comp_Rt-Stats for Client cache to update.
106: --No error handling here.
107: IEM_COMP_RT_STATS_PVT.create_item(p_api_version_number =>1.0,
108: p_init_msg_list => FND_API.G_FALSE,
109: p_commit => FND_API.G_FALSE,
110: p_type => 'AGENT_ACCOUNT',
111: p_param => 'CREATE',
112: p_value => l_agent_account_id,

Line 109: p_commit => FND_API.G_FALSE,

105: --Insert into Comp_Rt-Stats for Client cache to update.
106: --No error handling here.
107: IEM_COMP_RT_STATS_PVT.create_item(p_api_version_number =>1.0,
108: p_init_msg_list => FND_API.G_FALSE,
109: p_commit => FND_API.G_FALSE,
110: p_type => 'AGENT_ACCOUNT',
111: p_param => 'CREATE',
112: p_value => l_agent_account_id,
113: x_return_status => l_stat,

Line 123: WHEN FND_API.G_EXC_ERROR THEN

119: ( p_count => x_msg_count,
120: p_data => x_msg_data
121: );
122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: x_return_status := FND_API.G_RET_STS_ERROR ;
125: FND_MSG_PUB.Count_And_Get
126: ( p_count => x_msg_count,
127: p_data => x_msg_data

Line 124: x_return_status := FND_API.G_RET_STS_ERROR ;

120: p_data => x_msg_data
121: );
122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: x_return_status := FND_API.G_RET_STS_ERROR ;
125: FND_MSG_PUB.Count_And_Get
126: ( p_count => x_msg_count,
127: p_data => x_msg_data
128: );

Line 129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

125: FND_MSG_PUB.Count_And_Get
126: ( p_count => x_msg_count,
127: p_data => x_msg_data
128: );
129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
131: FND_MSG_PUB.Count_And_Get
132: ( p_count => x_msg_count,
133: p_data => x_msg_data

Line 130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

126: ( p_count => x_msg_count,
127: p_data => x_msg_data
128: );
129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
131: FND_MSG_PUB.Count_And_Get
132: ( p_count => x_msg_count,
133: p_data => x_msg_data
134: );

Line 136: x_return_status := FND_API.G_RET_STS_ERROR;

132: ( p_count => x_msg_count,
133: p_data => x_msg_data
134: );
135: WHEN OTHERS THEN
136: x_return_status := FND_API.G_RET_STS_ERROR;
137: IF FND_MSG_PUB.Check_Msg_Level
138: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
139: THEN
140: FND_MSG_PUB.Add_Exc_Msg

Line 171: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

167: l_data varchar2(300);
168:
169: BEGIN
170: -- Standard call to check for call compatibility.
171: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
172: p_api_version_number,
173: l_api_name,
174: G_PKG_NAME)
175: THEN

Line 176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

172: p_api_version_number,
173: l_api_name,
174: G_PKG_NAME)
175: THEN
176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
177: END IF;
178: x_return_status := FND_API.G_RET_STS_SUCCESS;
179:
180: select agent_id into l_agent_id

Line 178: x_return_status := FND_API.G_RET_STS_SUCCESS;

174: G_PKG_NAME)
175: THEN
176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
177: END IF;
178: x_return_status := FND_API.G_RET_STS_SUCCESS;
179:
180: select agent_id into l_agent_id
181: from IEM_AGENTS
182: where resource_id=p_resource_id

Line 192: p_init_msg_list => FND_API.G_FALSE,

188:
189: --Insert into Comp_Rt-Stats for Client cache to update.
190: --No error handling here.
191: IEM_COMP_RT_STATS_PVT.create_item(p_api_version_number =>1.0,
192: p_init_msg_list => FND_API.G_FALSE,
193: p_commit => FND_API.G_FALSE,
194: p_type => 'AGENT_ACCOUNT',
195: p_param => 'DELETE',
196: p_value => l_agent_id,

Line 193: p_commit => FND_API.G_FALSE,

189: --Insert into Comp_Rt-Stats for Client cache to update.
190: --No error handling here.
191: IEM_COMP_RT_STATS_PVT.create_item(p_api_version_number =>1.0,
192: p_init_msg_list => FND_API.G_FALSE,
193: p_commit => FND_API.G_FALSE,
194: p_type => 'AGENT_ACCOUNT',
195: p_param => 'DELETE',
196: p_value => l_agent_id,
197: x_return_status => l_stat,

Line 202: IF FND_API.To_Boolean(p_commit) THEN

198: x_msg_count => l_count,
199: x_msg_data => l_data);
200:
201: -- Standard Check Of p_commit.
202: IF FND_API.To_Boolean(p_commit) THEN
203: COMMIT WORK;
204: END IF;
205: -- Standard callto get message count and if count is 1, get message info.
206: FND_MSG_PUB.Count_And_Get

Line 211: WHEN FND_API.G_EXC_ERROR THEN

207: ( p_count => x_msg_count,
208: p_data => x_msg_data
209: );
210: EXCEPTION
211: WHEN FND_API.G_EXC_ERROR THEN
212: ROLLBACK TO delete_item_PVT;
213: x_return_status := FND_API.G_RET_STS_ERROR ;
214: FND_MSG_PUB.Count_And_Get
215: ( p_count => x_msg_count,

Line 213: x_return_status := FND_API.G_RET_STS_ERROR ;

209: );
210: EXCEPTION
211: WHEN FND_API.G_EXC_ERROR THEN
212: ROLLBACK TO delete_item_PVT;
213: x_return_status := FND_API.G_RET_STS_ERROR ;
214: FND_MSG_PUB.Count_And_Get
215: ( p_count => x_msg_count,
216: p_data => x_msg_data
217: );

Line 218: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

214: FND_MSG_PUB.Count_And_Get
215: ( p_count => x_msg_count,
216: p_data => x_msg_data
217: );
218: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
219: ROLLBACK TO delete_item_PVT;
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
221: FND_MSG_PUB.Count_And_Get
222: ( p_count => x_msg_count,

Line 220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

216: p_data => x_msg_data
217: );
218: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
219: ROLLBACK TO delete_item_PVT;
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
221: FND_MSG_PUB.Count_And_Get
222: ( p_count => x_msg_count,
223: p_data => x_msg_data
224: );

Line 227: x_return_status := FND_API.G_RET_STS_ERROR;

223: p_data => x_msg_data
224: );
225: WHEN OTHERS THEN
226: ROLLBACK TO delete_item_PVT;
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: IF FND_MSG_PUB.Check_Msg_Level
229: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
230: THEN
231: FND_MSG_PUB.Add_Exc_Msg

Line 270: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

266: BEGIN
267:
268: SAVEPOINT create_agntacct_by_agent_PVT;
269: -- Standard call to check for call compatibility.
270: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
271: p_api_version_number,
272: l_api_name,
273: G_PKG_NAME)
274: THEN

Line 275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

271: p_api_version_number,
272: l_api_name,
273: G_PKG_NAME)
274: THEN
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277:
278: -- Initialize message list if p_init_msg_list is set to TRUE.
279: IF FND_API.to_Boolean( p_init_msg_list )

Line 279: IF FND_API.to_Boolean( p_init_msg_list )

275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277:
278: -- Initialize message list if p_init_msg_list is set to TRUE.
279: IF FND_API.to_Boolean( p_init_msg_list )
280: THEN
281: FND_MSG_PUB.initialize;
282: END IF;
283:

Line 284: x_return_status := FND_API.G_RET_STS_SUCCESS;

280: THEN
281: FND_MSG_PUB.initialize;
282: END IF;
283:
284: x_return_status := FND_API.G_RET_STS_SUCCESS;
285:
286: FOR i in 1..p_in_resource_tbl.count() LOOP
287:
288: SELECT USER_ID, USER_NAME, SOURCE_LAST_NAME || ', ' || SOURCE_FIRST_NAME as RESOURCE_NAME

Line 304: P_Init_Msg_List => FND_API.G_FALSE,

300: l_data_change := true;
301:
302: /*JTF_RS_RESOURCE_VALUES_PUB.CREATE_RS_RESOURCE_VALUES(
303: P_Api_Version => 1.0,
304: P_Init_Msg_List => FND_API.G_FALSE,
305: P_Commit => FND_API.G_FALSE,
306: P_resource_id => p_in_resource_tbl(i),
307: p_resource_param_id => 1,
308: p_value => 'IEM_DEFAULT_VALUE',

Line 305: P_Commit => FND_API.G_FALSE,

301:
302: /*JTF_RS_RESOURCE_VALUES_PUB.CREATE_RS_RESOURCE_VALUES(
303: P_Api_Version => 1.0,
304: P_Init_Msg_List => FND_API.G_FALSE,
305: P_Commit => FND_API.G_FALSE,
306: P_resource_id => p_in_resource_tbl(i),
307: p_resource_param_id => 1,
308: p_value => 'IEM_DEFAULT_VALUE',
309: P_value_type => p_email_account_id,

Line 371: x_return_status := FND_API.G_RET_STS_ERROR;

367:
368: END LOOP;
369:
370: if l_error_username is not null then
371: x_return_status := FND_API.G_RET_STS_ERROR;
372: l_error_username := RTRIM(l_error_username, ', ');
373:
374: if l_error_agent_count > 20 then
375: l_error_username := l_error_username || '...';

Line 386: IF FND_API.To_Boolean(p_commit) THEN

382: x_return_status := 'N'; -- indicate no data change
383: end if;
384:
385: -- Standard Check Of p_commit.
386: IF FND_API.To_Boolean(p_commit) THEN
387: COMMIT WORK;
388: END IF;
389: -- Standard callto get message count and if count is 1, get message info.
390: FND_MSG_PUB.Count_And_Get

Line 397: WHEN FND_API.G_EXC_ERROR THEN

393: );
394: EXCEPTION
395:
396:
397: WHEN FND_API.G_EXC_ERROR THEN
398: ROLLBACK TO create_agntacct_by_agent_PVT;
399: x_return_status := FND_API.G_RET_STS_ERROR ;
400: FND_MSG_PUB.Count_And_Get
401: ( p_count => x_msg_count,

Line 399: x_return_status := FND_API.G_RET_STS_ERROR ;

395:
396:
397: WHEN FND_API.G_EXC_ERROR THEN
398: ROLLBACK TO create_agntacct_by_agent_PVT;
399: x_return_status := FND_API.G_RET_STS_ERROR ;
400: FND_MSG_PUB.Count_And_Get
401: ( p_count => x_msg_count,
402: p_data => x_msg_data
403: );

Line 404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

400: FND_MSG_PUB.Count_And_Get
401: ( p_count => x_msg_count,
402: p_data => x_msg_data
403: );
404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
405: ROLLBACK TO create_agntacct_by_agent_PVT;
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
407: FND_MSG_PUB.Count_And_Get
408: ( p_count => x_msg_count,

Line 406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

402: p_data => x_msg_data
403: );
404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
405: ROLLBACK TO create_agntacct_by_agent_PVT;
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
407: FND_MSG_PUB.Count_And_Get
408: ( p_count => x_msg_count,
409: p_data => x_msg_data
410: );

Line 413: x_return_status := FND_API.G_RET_STS_ERROR;

409: p_data => x_msg_data
410: );
411: WHEN OTHERS THEN
412: ROLLBACK TO create_agntacct_by_agent_PVT;
413: x_return_status := FND_API.G_RET_STS_ERROR;
414: IF FND_MSG_PUB.Check_Msg_Level
415: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
416: THEN
417: FND_MSG_PUB.Add_Exc_Msg

Line 470: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

466:
467: BEGIN
468: SAVEPOINT delete_agntacct_by_agent_PVT;
469: -- Standard call to check for call compatibility.
470: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
471: p_api_version_number,
472: l_api_name,
473: G_PKG_NAME)
474: THEN

Line 475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

471: p_api_version_number,
472: l_api_name,
473: G_PKG_NAME)
474: THEN
475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
476: END IF;
477:
478: -- Initialize message list if p_init_msg_list is set to TRUE.
479: IF FND_API.to_Boolean( p_init_msg_list )

Line 479: IF FND_API.to_Boolean( p_init_msg_list )

475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
476: END IF;
477:
478: -- Initialize message list if p_init_msg_list is set to TRUE.
479: IF FND_API.to_Boolean( p_init_msg_list )
480: THEN
481: FND_MSG_PUB.initialize;
482: END IF;
483:

Line 484: x_return_status := FND_API.G_RET_STS_SUCCESS;

480: THEN
481: FND_MSG_PUB.initialize;
482: END IF;
483:
484: x_return_status := FND_API.G_RET_STS_SUCCESS;
485:
486:
487: FOR i in 1..p_out_resource_tbl.count() LOOP
488:

Line 550: P_Init_Msg_List => FND_API.G_FALSE,

546: where value_type=p_email_account_id and resource_id=p_out_resource_tbl(i) and value='IEM_DEFAULT_VALUE';
547:
548: JTF_RS_RESOURCE_VALUES_PUB.DELETE_RS_RESOURCE_VALUES(
549: P_Api_Version => 1.0,
550: P_Init_Msg_List => FND_API.G_FALSE,
551: P_Commit => FND_API.G_FALSE,
552: p_resource_param_value_id => l_resource_param_value_id,
553: p_object_version_number => l_object_version_number,
554: X_Return_Status => l_return_status,

Line 551: P_Commit => FND_API.G_FALSE,

547:
548: JTF_RS_RESOURCE_VALUES_PUB.DELETE_RS_RESOURCE_VALUES(
549: P_Api_Version => 1.0,
550: P_Init_Msg_List => FND_API.G_FALSE,
551: P_Commit => FND_API.G_FALSE,
552: p_resource_param_value_id => l_resource_param_value_id,
553: p_object_version_number => l_object_version_number,
554: X_Return_Status => l_return_status,
555: X_Msg_Count => l_msg_count,

Line 582: x_return_status := FND_API.G_RET_STS_ERROR;

578: END LOOP;
579:
580:
581: if l_error_username is not null then
582: x_return_status := FND_API.G_RET_STS_ERROR;
583: l_error_username := RTRIM(l_error_username, ', ');
584:
585: if l_error_agent_count > 20 then
586: l_error_username := l_error_username || '...';

Line 596: x_return_status := FND_API.G_RET_STS_ERROR ;

592:
593: end if;
594:
595: if l_error_username1 is not null then
596: x_return_status := FND_API.G_RET_STS_ERROR ;
597: l_error_username1 := RTRIM(l_error_username1, ', ');
598:
599: if l_error_agent_count1 > 20 then
600: l_error_username1 := l_error_username1 || '...';

Line 612: x_return_status := FND_API.G_RET_STS_ERROR;

608: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
609: end if;
610:
611: if l_error_username2 is not null then
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: l_error_username2 := RTRIM(l_error_username2, ', ');
614:
615: if l_error_agent_count2 > 20 then
616: l_error_username2 := l_error_username2 || '...';

Line 632: IF FND_API.To_Boolean(p_commit) THEN

628: x_return_status := 'N'; -- indicate no change in data
629: end if;
630:
631: -- Standard Check Of p_commit.
632: IF FND_API.To_Boolean(p_commit) THEN
633: COMMIT WORK;
634: END IF;
635: -- Standard callto get message count and if count is 1, get message info.
636: FND_MSG_PUB.Count_And_Get

Line 641: WHEN FND_API.G_EXC_ERROR THEN

637: ( p_count => x_msg_count,
638: p_data => x_msg_data
639: );
640: EXCEPTION
641: WHEN FND_API.G_EXC_ERROR THEN
642: ROLLBACK TO delete_agntacct_by_agent_PVT;
643: x_return_status := FND_API.G_RET_STS_ERROR ;
644: FND_MSG_PUB.Count_And_Get
645: ( p_count => x_msg_count,

Line 643: x_return_status := FND_API.G_RET_STS_ERROR ;

639: );
640: EXCEPTION
641: WHEN FND_API.G_EXC_ERROR THEN
642: ROLLBACK TO delete_agntacct_by_agent_PVT;
643: x_return_status := FND_API.G_RET_STS_ERROR ;
644: FND_MSG_PUB.Count_And_Get
645: ( p_count => x_msg_count,
646: p_data => x_msg_data
647: );

Line 648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

644: FND_MSG_PUB.Count_And_Get
645: ( p_count => x_msg_count,
646: p_data => x_msg_data
647: );
648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
649: ROLLBACK TO delete_agntacct_by_agent_PVT;
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
651: FND_MSG_PUB.Count_And_Get
652: ( p_count => x_msg_count,

Line 650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

646: p_data => x_msg_data
647: );
648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
649: ROLLBACK TO delete_agntacct_by_agent_PVT;
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
651: FND_MSG_PUB.Count_And_Get
652: ( p_count => x_msg_count,
653: p_data => x_msg_data
654: );

Line 657: x_return_status := FND_API.G_RET_STS_ERROR;

653: p_data => x_msg_data
654: );
655: WHEN OTHERS THEN
656: ROLLBACK TO delete_agntacct_by_agent_PVT;
657: x_return_status := FND_API.G_RET_STS_ERROR;
658: IF FND_MSG_PUB.Check_Msg_Level
659: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
660: THEN
661: FND_MSG_PUB.Add_Exc_Msg

Line 694: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

690:
691: BEGIN
692: SAVEPOINT agntacct_by_agent_wrap;
693: -- Standard call to check for call compatibility.
694: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
695: p_api_version_number,
696: l_api_name,
697: G_PKG_NAME)
698: THEN

Line 699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

695: p_api_version_number,
696: l_api_name,
697: G_PKG_NAME)
698: THEN
699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
700: END IF;
701:
702: -- Initialize message list if p_init_msg_list is set to TRUE.
703: IF FND_API.to_Boolean( p_init_msg_list )

Line 703: IF FND_API.to_Boolean( p_init_msg_list )

699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
700: END IF;
701:
702: -- Initialize message list if p_init_msg_list is set to TRUE.
703: IF FND_API.to_Boolean( p_init_msg_list )
704: THEN
705: FND_MSG_PUB.initialize;
706: END IF;
707:

Line 708: x_return_status := FND_API.G_RET_STS_SUCCESS;

704: THEN
705: FND_MSG_PUB.initialize;
706: END IF;
707:
708: x_return_status := FND_API.G_RET_STS_SUCCESS;
709:
710: -- Check for existence of database link
711:
712: -- Assign agents to account

Line 725: x_return_status := FND_API.G_RET_STS_ERROR ;

721:
722: IF l_return_status='N' THEN
723: l_return_status1 := 'N';
724: ELSIF l_return_status<>'S' and l_return_status<>'N' THEN
725: x_return_status := FND_API.G_RET_STS_ERROR ;
726: FND_MSG_PUB.Count_And_Get
727: ( p_count => x_msg_count,
728: p_data => x_msg_data
729: );

Line 745: x_return_status := FND_API.G_RET_STS_ERROR ;

741:
742: IF l_return_status='N'and l_return_status1='N' THEN
743: x_return_status := 'N';
744: ELSIF l_return_status<>'S' and l_return_status<>'N' THEN
745: x_return_status := FND_API.G_RET_STS_ERROR ;
746: FND_MSG_PUB.Count_And_Get
747: ( p_count => x_msg_count,
748: p_data => x_msg_data
749: );

Line 754: IF FND_API.To_Boolean(p_commit) THEN

750: END IF;
751:
752:
753: -- Standard Check Of p_commit.
754: IF FND_API.To_Boolean(p_commit) THEN
755: COMMIT WORK;
756: END IF;
757: -- Standard callto get message count and if count is 1, get message info.
758: FND_MSG_PUB.Count_And_Get

Line 767: x_return_status := FND_API.G_RET_STS_ERROR ;

763: WHEN NO_DATA_FOUND THEN
764: ROLLBACK TO agntacct_by_agent_wrap;
765: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_ACCOUNT_NOT_FOUND');
766: FND_MSG_PUB.Add;
767: x_return_status := FND_API.G_RET_STS_ERROR ;
768: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
769:
770: WHEN FND_API.G_EXC_ERROR THEN
771: ROLLBACK TO agntacct_by_agent_wrap;

Line 770: WHEN FND_API.G_EXC_ERROR THEN

766: FND_MSG_PUB.Add;
767: x_return_status := FND_API.G_RET_STS_ERROR ;
768: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
769:
770: WHEN FND_API.G_EXC_ERROR THEN
771: ROLLBACK TO agntacct_by_agent_wrap;
772: x_return_status := FND_API.G_RET_STS_ERROR ;
773: FND_MSG_PUB.Count_And_Get
774: ( p_count => x_msg_count,

Line 772: x_return_status := FND_API.G_RET_STS_ERROR ;

768: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
769:
770: WHEN FND_API.G_EXC_ERROR THEN
771: ROLLBACK TO agntacct_by_agent_wrap;
772: x_return_status := FND_API.G_RET_STS_ERROR ;
773: FND_MSG_PUB.Count_And_Get
774: ( p_count => x_msg_count,
775: p_data => x_msg_data
776: );

Line 777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

773: FND_MSG_PUB.Count_And_Get
774: ( p_count => x_msg_count,
775: p_data => x_msg_data
776: );
777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
778: ROLLBACK TO agntacct_by_agent_wrap;
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
780: FND_MSG_PUB.Count_And_Get
781: ( p_count => x_msg_count,

Line 779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

775: p_data => x_msg_data
776: );
777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
778: ROLLBACK TO agntacct_by_agent_wrap;
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
780: FND_MSG_PUB.Count_And_Get
781: ( p_count => x_msg_count,
782: p_data => x_msg_data
783: );

Line 786: x_return_status := FND_API.G_RET_STS_ERROR;

782: p_data => x_msg_data
783: );
784: WHEN OTHERS THEN
785: ROLLBACK TO agntacct_by_agent_wrap;
786: x_return_status := FND_API.G_RET_STS_ERROR;
787: IF FND_MSG_PUB.Check_Msg_Level
788: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
789: THEN
790: FND_MSG_PUB.Add_Exc_Msg

Line 836: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

832: BEGIN
833:
834: SAVEPOINT create_agntacct_by_account_PVT;
835: -- Standard call to check for call compatibility.
836: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
837: p_api_version_number,
838: l_api_name,
839: G_PKG_NAME)
840: THEN

Line 841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

837: p_api_version_number,
838: l_api_name,
839: G_PKG_NAME)
840: THEN
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: END IF;
843:
844: -- Initialize message list if p_init_msg_list is set to TRUE.
845: IF FND_API.to_Boolean( p_init_msg_list )

Line 845: IF FND_API.to_Boolean( p_init_msg_list )

841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: END IF;
843:
844: -- Initialize message list if p_init_msg_list is set to TRUE.
845: IF FND_API.to_Boolean( p_init_msg_list )
846: THEN
847: FND_MSG_PUB.initialize;
848: END IF;
849:

Line 850: x_return_status := FND_API.G_RET_STS_SUCCESS;

846: THEN
847: FND_MSG_PUB.initialize;
848: END IF;
849:
850: x_return_status := FND_API.G_RET_STS_SUCCESS;
851:
852: SELECT USER_ID, USER_NAME, SOURCE_LAST_NAME || ', ' || SOURCE_FIRST_NAME as RESOURCE_NAME
853: INTO l_user_id, l_user_name, l_res_name
854: FROM JTF_RS_RESOURCE_EXTNS

Line 893: P_Init_Msg_List => FND_API.G_FALSE,

889:
890:
891: /* JTF_RS_RESOURCE_VALUES_PUB.CREATE_RS_RESOURCE_VALUES(
892: P_Api_Version => 1.0,
893: P_Init_Msg_List => FND_API.G_FALSE,
894: P_Commit => FND_API.G_FALSE,
895: P_resource_id => p_resource_id,
896: p_resource_param_id => 1,
897: p_value => 'IEM_DEFAULT_VALUE',

Line 894: P_Commit => FND_API.G_FALSE,

890:
891: /* JTF_RS_RESOURCE_VALUES_PUB.CREATE_RS_RESOURCE_VALUES(
892: P_Api_Version => 1.0,
893: P_Init_Msg_List => FND_API.G_FALSE,
894: P_Commit => FND_API.G_FALSE,
895: P_resource_id => p_resource_id,
896: p_resource_param_id => 1,
897: p_value => 'IEM_DEFAULT_VALUE',
898: P_value_type => p_in_email_account_tbl(i),

Line 960: x_return_status := FND_API.G_RET_STS_ERROR;

956: end if; -- l_account_count = 1
957: END LOOP;
958:
959: if l_error_email_user is not null then
960: x_return_status := FND_API.G_RET_STS_ERROR;
961: l_error_email_user := RTRIM(l_error_email_user, ', ');
962:
963: if l_error_account_count > 5 then
964: l_error_email_user := l_error_email_user || '...';

Line 975: IF FND_API.To_Boolean(p_commit) THEN

971: x_return_status := 'N'; -- indicate no data change
972: end if;
973:
974: -- Standard Check Of p_commit.
975: IF FND_API.To_Boolean(p_commit) THEN
976: COMMIT WORK;
977: END IF;
978: -- Standard callto get message count and if count is 1, get message info.
979: FND_MSG_PUB.Count_And_Get

Line 988: x_return_status := FND_API.G_RET_STS_ERROR ;

984: WHEN USER_NULL_ERROR THEN
985: ROLLBACK TO create_agntacct_by_account_PVT;
986: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_AGENT_USER_NULL');
987: FND_MSG_PUB.Add;
988: x_return_status := FND_API.G_RET_STS_ERROR ;
989: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
990:
991: WHEN RESOURCE_INACTIVE_ERROR THEN
992: ROLLBACK TO create_agntacct_by_account_PVT;

Line 995: x_return_status := FND_API.G_RET_STS_ERROR ;

991: WHEN RESOURCE_INACTIVE_ERROR THEN
992: ROLLBACK TO create_agntacct_by_account_PVT;
993: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_RESOURCE_INACTIVE');
994: FND_MSG_PUB.Add;
995: x_return_status := FND_API.G_RET_STS_ERROR ;
996: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
997:
998: WHEN FND_API.G_EXC_ERROR THEN
999: ROLLBACK TO create_agntacct_by_account_PVT;

Line 998: WHEN FND_API.G_EXC_ERROR THEN

994: FND_MSG_PUB.Add;
995: x_return_status := FND_API.G_RET_STS_ERROR ;
996: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
997:
998: WHEN FND_API.G_EXC_ERROR THEN
999: ROLLBACK TO create_agntacct_by_account_PVT;
1000: x_return_status := FND_API.G_RET_STS_ERROR ;
1001: FND_MSG_PUB.Count_And_Get
1002: ( p_count => x_msg_count,

Line 1000: x_return_status := FND_API.G_RET_STS_ERROR ;

996: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
997:
998: WHEN FND_API.G_EXC_ERROR THEN
999: ROLLBACK TO create_agntacct_by_account_PVT;
1000: x_return_status := FND_API.G_RET_STS_ERROR ;
1001: FND_MSG_PUB.Count_And_Get
1002: ( p_count => x_msg_count,
1003: p_data => x_msg_data
1004: );

Line 1005: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1001: FND_MSG_PUB.Count_And_Get
1002: ( p_count => x_msg_count,
1003: p_data => x_msg_data
1004: );
1005: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1006: ROLLBACK TO create_agntacct_by_account_PVT;
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1008: FND_MSG_PUB.Count_And_Get
1009: ( p_count => x_msg_count,

Line 1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1003: p_data => x_msg_data
1004: );
1005: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1006: ROLLBACK TO create_agntacct_by_account_PVT;
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1008: FND_MSG_PUB.Count_And_Get
1009: ( p_count => x_msg_count,
1010: p_data => x_msg_data
1011: );

Line 1014: x_return_status := FND_API.G_RET_STS_ERROR;

1010: p_data => x_msg_data
1011: );
1012: WHEN OTHERS THEN
1013: ROLLBACK TO create_agntacct_by_account_PVT;
1014: x_return_status := FND_API.G_RET_STS_ERROR;
1015: IF FND_MSG_PUB.Check_Msg_Level
1016: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1017: THEN
1018: FND_MSG_PUB.Add_Exc_Msg

Line 1071: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1067:
1068: BEGIN
1069: SAVEPOINT delete_agntacct_by_account_PVT;
1070: -- Standard call to check for call compatibility.
1071: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1072: p_api_version_number,
1073: l_api_name,
1074: G_PKG_NAME)
1075: THEN

Line 1076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1072: p_api_version_number,
1073: l_api_name,
1074: G_PKG_NAME)
1075: THEN
1076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1077: END IF;
1078:
1079: -- Initialize message list if p_init_msg_list is set to TRUE.
1080: IF FND_API.to_Boolean( p_init_msg_list )

Line 1080: IF FND_API.to_Boolean( p_init_msg_list )

1076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1077: END IF;
1078:
1079: -- Initialize message list if p_init_msg_list is set to TRUE.
1080: IF FND_API.to_Boolean( p_init_msg_list )
1081: THEN
1082: FND_MSG_PUB.initialize;
1083: END IF;
1084:

Line 1085: x_return_status := FND_API.G_RET_STS_SUCCESS;

1081: THEN
1082: FND_MSG_PUB.initialize;
1083: END IF;
1084:
1085: x_return_status := FND_API.G_RET_STS_SUCCESS;
1086:
1087: SELECT USER_ID, USER_NAME, SOURCE_LAST_NAME || ', ' || SOURCE_FIRST_NAME as RESOURCE_NAME
1088: INTO l_user_id, l_user_name, l_res_name
1089: FROM JTF_RS_RESOURCE_EXTNS

Line 1161: P_Init_Msg_List => FND_API.G_FALSE,

1157: where value_type=p_out_email_account_tbl(i) and resource_id=p_resource_id and value='IEM_DEFAULT_VALUE';
1158:
1159: JTF_RS_RESOURCE_VALUES_PUB.DELETE_RS_RESOURCE_VALUES(
1160: P_Api_Version => 1.0,
1161: P_Init_Msg_List => FND_API.G_FALSE,
1162: P_Commit => FND_API.G_FALSE,
1163: p_resource_param_value_id => l_resource_param_value_id,
1164: p_object_version_number => l_object_version_number,
1165: X_Return_Status => l_return_status,

Line 1162: P_Commit => FND_API.G_FALSE,

1158:
1159: JTF_RS_RESOURCE_VALUES_PUB.DELETE_RS_RESOURCE_VALUES(
1160: P_Api_Version => 1.0,
1161: P_Init_Msg_List => FND_API.G_FALSE,
1162: P_Commit => FND_API.G_FALSE,
1163: p_resource_param_value_id => l_resource_param_value_id,
1164: p_object_version_number => l_object_version_number,
1165: X_Return_Status => l_return_status,
1166: X_Msg_Count => l_msg_count,

Line 1191: x_return_status := FND_API.G_RET_STS_ERROR;

1187: end if; -- l_account_count=0
1188: END LOOP;
1189:
1190: if l_error_email_user is not null then
1191: x_return_status := FND_API.G_RET_STS_ERROR;
1192: l_error_email_user := RTRIM(l_error_email_user, ', ');
1193:
1194: if l_error_account_count > 5 then
1195: l_error_email_user := l_error_email_user || '...';

Line 1205: x_return_status := FND_API.G_RET_STS_ERROR ;

1201:
1202: end if;
1203:
1204: if l_error_email_user1 is not null then
1205: x_return_status := FND_API.G_RET_STS_ERROR ;
1206: l_error_email_user1 := RTRIM(l_error_email_user1, ', ');
1207:
1208: if l_error_account_count1 > 5 then
1209: l_error_email_user1 := l_error_email_user1 || '...';

Line 1220: x_return_status := FND_API.G_RET_STS_ERROR;

1216: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1217: end if;
1218:
1219: if l_error_email_user2 is not null then
1220: x_return_status := FND_API.G_RET_STS_ERROR;
1221: l_error_email_user2 := RTRIM(l_error_email_user2, ', ');
1222:
1223: if l_error_account_count2 > 5 then
1224: l_error_email_user2 := l_error_email_user2 || '...';

Line 1239: IF FND_API.To_Boolean(p_commit) THEN

1235: x_return_status := 'N'; -- indicate no change in data
1236: end if;
1237:
1238: -- Standard Check Of p_commit.
1239: IF FND_API.To_Boolean(p_commit) THEN
1240: COMMIT WORK;
1241: END IF;
1242: -- Standard callto get message count and if count is 1, get message info.
1243: FND_MSG_PUB.Count_And_Get

Line 1248: WHEN FND_API.G_EXC_ERROR THEN

1244: ( p_count => x_msg_count,
1245: p_data => x_msg_data
1246: );
1247: EXCEPTION
1248: WHEN FND_API.G_EXC_ERROR THEN
1249: ROLLBACK TO delete_agntacct_by_account_PVT;
1250: x_return_status := FND_API.G_RET_STS_ERROR ;
1251: FND_MSG_PUB.Count_And_Get
1252: ( p_count => x_msg_count,

Line 1250: x_return_status := FND_API.G_RET_STS_ERROR ;

1246: );
1247: EXCEPTION
1248: WHEN FND_API.G_EXC_ERROR THEN
1249: ROLLBACK TO delete_agntacct_by_account_PVT;
1250: x_return_status := FND_API.G_RET_STS_ERROR ;
1251: FND_MSG_PUB.Count_And_Get
1252: ( p_count => x_msg_count,
1253: p_data => x_msg_data
1254: );

Line 1255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1251: FND_MSG_PUB.Count_And_Get
1252: ( p_count => x_msg_count,
1253: p_data => x_msg_data
1254: );
1255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1256: ROLLBACK TO delete_agntacct_by_account_PVT;
1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1258: FND_MSG_PUB.Count_And_Get
1259: ( p_count => x_msg_count,

Line 1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1253: p_data => x_msg_data
1254: );
1255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1256: ROLLBACK TO delete_agntacct_by_account_PVT;
1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1258: FND_MSG_PUB.Count_And_Get
1259: ( p_count => x_msg_count,
1260: p_data => x_msg_data
1261: );

Line 1264: x_return_status := FND_API.G_RET_STS_ERROR;

1260: p_data => x_msg_data
1261: );
1262: WHEN OTHERS THEN
1263: ROLLBACK TO delete_agntacct_by_account_PVT;
1264: x_return_status := FND_API.G_RET_STS_ERROR;
1265: IF FND_MSG_PUB.Check_Msg_Level
1266: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1267: THEN
1268: FND_MSG_PUB.Add_Exc_Msg

Line 1305: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1301:
1302: BEGIN
1303: SAVEPOINT agntacct_by_account_wrap;
1304: -- Standard call to check for call compatibility.
1305: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1306: p_api_version_number,
1307: l_api_name,
1308: G_PKG_NAME)
1309: THEN

Line 1310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1306: p_api_version_number,
1307: l_api_name,
1308: G_PKG_NAME)
1309: THEN
1310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1311: END IF;
1312:
1313: -- Initialize message list if p_init_msg_list is set to TRUE.
1314: IF FND_API.to_Boolean( p_init_msg_list )

Line 1314: IF FND_API.to_Boolean( p_init_msg_list )

1310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1311: END IF;
1312:
1313: -- Initialize message list if p_init_msg_list is set to TRUE.
1314: IF FND_API.to_Boolean( p_init_msg_list )
1315: THEN
1316: FND_MSG_PUB.initialize;
1317: END IF;
1318:

Line 1319: x_return_status := FND_API.G_RET_STS_SUCCESS;

1315: THEN
1316: FND_MSG_PUB.initialize;
1317: END IF;
1318:
1319: x_return_status := FND_API.G_RET_STS_SUCCESS;
1320:
1321: -- Assign agents to account
1322: iem_agent_act_pvt.create_agntacct_by_account (p_api_version_number =>1.0,
1323: P_Init_Msg_List =>'F',

Line 1334: x_return_status := FND_API.G_RET_STS_ERROR ;

1330:
1331: IF l_return_status = 'N' THEN
1332: l_return_status1:='N';
1333: ELSIF l_return_status<>'S' and l_return_status<>'N' THEN
1334: x_return_status := FND_API.G_RET_STS_ERROR ;
1335: FND_MSG_PUB.Count_And_Get
1336: ( p_count => x_msg_count,
1337: p_data => x_msg_data
1338: );

Line 1354: x_return_status := FND_API.G_RET_STS_ERROR ;

1350:
1351: IF l_return_status='N'and l_return_status1='N' THEN
1352: x_return_status := 'N';
1353: ELSIF l_return_status<>'S' and l_return_status<>'N' THEN
1354: x_return_status := FND_API.G_RET_STS_ERROR ;
1355: FND_MSG_PUB.Count_And_Get
1356: ( p_count => x_msg_count,
1357: p_data => x_msg_data
1358: );

Line 1363: IF FND_API.To_Boolean(p_commit) THEN

1359: END IF;
1360:
1361:
1362: -- Standard Check Of p_commit.
1363: IF FND_API.To_Boolean(p_commit) THEN
1364: COMMIT WORK;
1365: END IF;
1366: -- Standard callto get message count and if count is 1, get message info.
1367: FND_MSG_PUB.Count_And_Get

Line 1375: x_return_status := FND_API.G_RET_STS_ERROR ;

1371: EXCEPTION
1372:
1373: WHEN DB_LINK_NOT_FOUND THEN
1374: ROLLBACK TO agntacct_by_account_wrap;
1375: x_return_status := FND_API.G_RET_STS_ERROR ;
1376: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1377:
1378: WHEN FND_API.G_EXC_ERROR THEN
1379: ROLLBACK TO agntacct_by_account_wrap;

Line 1378: WHEN FND_API.G_EXC_ERROR THEN

1374: ROLLBACK TO agntacct_by_account_wrap;
1375: x_return_status := FND_API.G_RET_STS_ERROR ;
1376: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1377:
1378: WHEN FND_API.G_EXC_ERROR THEN
1379: ROLLBACK TO agntacct_by_account_wrap;
1380: x_return_status := FND_API.G_RET_STS_ERROR ;
1381: FND_MSG_PUB.Count_And_Get
1382: ( p_count => x_msg_count,

Line 1380: x_return_status := FND_API.G_RET_STS_ERROR ;

1376: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1377:
1378: WHEN FND_API.G_EXC_ERROR THEN
1379: ROLLBACK TO agntacct_by_account_wrap;
1380: x_return_status := FND_API.G_RET_STS_ERROR ;
1381: FND_MSG_PUB.Count_And_Get
1382: ( p_count => x_msg_count,
1383: p_data => x_msg_data
1384: );

Line 1385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1381: FND_MSG_PUB.Count_And_Get
1382: ( p_count => x_msg_count,
1383: p_data => x_msg_data
1384: );
1385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1386: ROLLBACK TO agntacct_by_account_wrap;
1387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1388: FND_MSG_PUB.Count_And_Get
1389: ( p_count => x_msg_count,

Line 1387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1383: p_data => x_msg_data
1384: );
1385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1386: ROLLBACK TO agntacct_by_account_wrap;
1387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1388: FND_MSG_PUB.Count_And_Get
1389: ( p_count => x_msg_count,
1390: p_data => x_msg_data
1391: );

Line 1394: x_return_status := FND_API.G_RET_STS_ERROR;

1390: p_data => x_msg_data
1391: );
1392: WHEN OTHERS THEN
1393: ROLLBACK TO agntacct_by_account_wrap;
1394: x_return_status := FND_API.G_RET_STS_ERROR;
1395: IF FND_MSG_PUB.Check_Msg_Level
1396: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1397: THEN
1398: FND_MSG_PUB.Add_Exc_Msg