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

Line 75: x_return_status := FND_API.G_RET_STS_SUCCESS;

71: l_return_status VARCHAR2(1) := null;
72:
73: BEGIN
74: -- Initialize API return status to success
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76:
77: -- Standard call to check for call compatibility
78: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
79: G_PKG_NAME) THEN

Line 78: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

74: -- Initialize API return status to success
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76:
77: -- Standard call to check for call compatibility
78: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
79: G_PKG_NAME) THEN
80: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
81: END IF;
82:

Line 80: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

76:
77: -- Standard call to check for call compatibility
78: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
79: G_PKG_NAME) THEN
80: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
81: END IF;
82:
83: -- Initialize message list if p_init_msg_list is set to TRUE
84: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 84: IF FND_API.To_Boolean(p_init_msg_list) THEN

80: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
81: END IF;
82:
83: -- Initialize message list if p_init_msg_list is set to TRUE
84: IF FND_API.To_Boolean(p_init_msg_list) THEN
85: FND_MSG_PUB.Initialize;
86: END IF;
87:
88: CS_ASSIGN_RESOURCE_PKG.Assign_Resources

Line 103: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN

99: x_return_status => l_return_status,
100: x_msg_count => x_msg_count,
101: x_msg_data => x_msg_data
102: );
103: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
104: RAISE FND_API.G_EXC_ERROR;
105: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;

Line 104: RAISE FND_API.G_EXC_ERROR;

100: x_msg_count => x_msg_count,
101: x_msg_data => x_msg_data
102: );
103: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
104: RAISE FND_API.G_EXC_ERROR;
105: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108:

Line 105: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

101: x_msg_data => x_msg_data
102: );
103: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
104: RAISE FND_API.G_EXC_ERROR;
105: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108:
109: EXCEPTION

Line 106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

102: );
103: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
104: RAISE FND_API.G_EXC_ERROR;
105: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108:
109: EXCEPTION
110: WHEN FND_API.G_EXC_ERROR THEN

Line 110: WHEN FND_API.G_EXC_ERROR THEN

106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108:
109: EXCEPTION
110: WHEN FND_API.G_EXC_ERROR THEN
111: x_return_status := FND_API.G_RET_STS_ERROR;
112: FND_MSG_PUB.Count_And_Get
113: ( p_count => x_msg_count,
114: p_data => x_msg_data

Line 111: x_return_status := FND_API.G_RET_STS_ERROR;

107: END IF;
108:
109: EXCEPTION
110: WHEN FND_API.G_EXC_ERROR THEN
111: x_return_status := FND_API.G_RET_STS_ERROR;
112: FND_MSG_PUB.Count_And_Get
113: ( p_count => x_msg_count,
114: p_data => x_msg_data
115: );

Line 116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

112: FND_MSG_PUB.Count_And_Get
113: ( p_count => x_msg_count,
114: p_data => x_msg_data
115: );
116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
118: FND_MSG_PUB.Count_And_Get
119: ( p_count => x_msg_count,
120: p_data => x_msg_data

Line 117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

113: ( p_count => x_msg_count,
114: p_data => x_msg_data
115: );
116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
118: FND_MSG_PUB.Count_And_Get
119: ( p_count => x_msg_count,
120: p_data => x_msg_data
121: );

Line 123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 196: IF FND_API.To_Boolean(p_init_msg_list) THEN

192:
193: BEGIN
194:
195: -- Initialize message list if p_init_msg_list is set to TRUE
196: IF FND_API.To_Boolean(p_init_msg_list) THEN
197: FND_MSG_PUB.Initialize;
198: END IF;
199:
200: -- Initialize API return status to success

Line 201: x_return_status := FND_API.G_RET_STS_SUCCESS;

197: FND_MSG_PUB.Initialize;
198: END IF;
199:
200: -- Initialize API return status to success
201: x_return_status := FND_API.G_RET_STS_SUCCESS;
202: l_grp_return_status := FND_API.G_RET_STS_SUCCESS;
203: l_main_return_status := FND_API.G_RET_STS_SUCCESS;
204:
205: -- Set group_type as RS_GROUP always, if default_group_type profile is null

Line 202: l_grp_return_status := FND_API.G_RET_STS_SUCCESS;

198: END IF;
199:
200: -- Initialize API return status to success
201: x_return_status := FND_API.G_RET_STS_SUCCESS;
202: l_grp_return_status := FND_API.G_RET_STS_SUCCESS;
203: l_main_return_status := FND_API.G_RET_STS_SUCCESS;
204:
205: -- Set group_type as RS_GROUP always, if default_group_type profile is null
206: IF (l_sr_rec.group_type IS NULL) THEN

Line 203: l_main_return_status := FND_API.G_RET_STS_SUCCESS;

199:
200: -- Initialize API return status to success
201: x_return_status := FND_API.G_RET_STS_SUCCESS;
202: l_grp_return_status := FND_API.G_RET_STS_SUCCESS;
203: l_main_return_status := FND_API.G_RET_STS_SUCCESS;
204:
205: -- Set group_type as RS_GROUP always, if default_group_type profile is null
206: IF (l_sr_rec.group_type IS NULL) THEN
207: FND_PROFILE.Get('CS_SR_DEFAULT_GROUP_TYPE', l_default_group_type);

Line 243: IF (l_grp_return_status = FND_API.G_RET_STS_SUCCESS) THEN

239: x_territory_id => l_territory_id,
240: x_msg_count => x_msg_count,
241: x_msg_data => x_msg_data
242: );
243: IF (l_grp_return_status = FND_API.G_RET_STS_SUCCESS) THEN
244: IF (FND_PROFILE.VALUE('CS_SR_OWNER_AUTO_ASSIGN_LEVEL') = 'GROUP') THEN
245: x_owner_group_id := l_group_id;
246: x_territory_id := l_territory_id;
247: RETURN;

Line 256: x_return_status := FND_API.G_RET_STS_SUCCESS;

252: l_param_resource_type := 'RS_INDIVIDUAL';
253: l_update_own_flag := 'N';
254:
255: -- Initialize API return status to success
256: x_return_status := FND_API.G_RET_STS_SUCCESS;
257: l_own_return_status := FND_API.G_RET_STS_SUCCESS;
258:
259: CS_ASSIGN_RESOURCE_PKG.Assign_Owner
260: ( p_init_msg_list => p_init_msg_list,

Line 257: l_own_return_status := FND_API.G_RET_STS_SUCCESS;

253: l_update_own_flag := 'N';
254:
255: -- Initialize API return status to success
256: x_return_status := FND_API.G_RET_STS_SUCCESS;
257: l_own_return_status := FND_API.G_RET_STS_SUCCESS;
258:
259: CS_ASSIGN_RESOURCE_PKG.Assign_Owner
260: ( p_init_msg_list => p_init_msg_list,
261: p_commit => p_commit,

Line 274: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

270: x_msg_count => x_msg_count,
271: x_msg_data => x_msg_data
272: );
273: x_return_status := l_own_return_status ;
274: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
275: IF (l_owner_id IS NULL) THEN
276: FND_MSG_PUB.Initialize;
277: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
278: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);

Line 280: l_main_return_status := FND_API.G_RET_STS_SUCCESS;

276: FND_MSG_PUB.Initialize;
277: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
278: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
279: FND_MSG_PUB.Add;
280: l_main_return_status := FND_API.G_RET_STS_SUCCESS;
281: ELSE
282: l_update_own_flag := 'Y';
283: END IF;
284: ELSE

Line 288: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

284: ELSE
285: -- Check for Expected and Unexpected Error
286: -- For Expected Error the message stack is initialized.
287: -- For Unexpected Error only all the messages are shown
288: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
289: FND_MSG_PUB.Initialize; -- Uncommented for Bug 13696291
290: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
291: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
292: FND_MSG_PUB.Add;

Line 293: l_main_return_status := FND_API.G_RET_STS_ERROR;

289: FND_MSG_PUB.Initialize; -- Uncommented for Bug 13696291
290: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
291: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
292: FND_MSG_PUB.Add;
293: l_main_return_status := FND_API.G_RET_STS_ERROR;
294: ELSE
295: --FND_MSG_PUB.Initialize;
296: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
297: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);

Line 299: l_main_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

295: --FND_MSG_PUB.Initialize;
296: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
297: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
298: FND_MSG_PUB.Add;
299: l_main_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
300: END IF;
301: END IF;
302: END IF; /* group_type <> RS_TEAM */
303: ELSE /* l_group_id is not null */

Line 309: l_main_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

305: FND_MSG_PUB.Initialize; -- Uncommented for Bug 13696291
306: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_GROUP');
307: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
308: FND_MSG_PUB.Add;
309: l_main_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
310: END IF;
311: END IF; /* CS_SR_OWNER_AUTO_ASSIGN_LEVEL */
312: ELSE /* l_grp_return_status is not success */
313: -- Check for Expected and Unexpected Error

Line 316: IF (l_grp_return_status = FND_API.G_RET_STS_ERROR) THEN

312: ELSE /* l_grp_return_status is not success */
313: -- Check for Expected and Unexpected Error
314: -- For Expected Error the message stack is initialized.
315: -- For Unexpected Error only all the messages are shown
316: IF (l_grp_return_status = FND_API.G_RET_STS_ERROR) THEN
317: FND_MSG_PUB.Initialize; -- Uncommented for Bug 13696291
318: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_GROUP');
319: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
320: FND_MSG_PUB.Add;

Line 321: l_main_return_status := FND_API.G_RET_STS_ERROR;

317: FND_MSG_PUB.Initialize; -- Uncommented for Bug 13696291
318: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_GROUP');
319: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
320: FND_MSG_PUB.Add;
321: l_main_return_status := FND_API.G_RET_STS_ERROR;
322: ELSE
323: --FND_MSG_PUB.Initialize;
324: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_GROUP');
325: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

Line 327: l_main_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

323: --FND_MSG_PUB.Initialize;
324: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_GROUP');
325: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
326: FND_MSG_PUB.Add;
327: l_main_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328: END IF;
329: END IF; /* l_grp_return_status is not success */
330:
331: ELSE /* owner_group_id is not null, group has been assigned */

Line 336: x_return_status := FND_API.G_RET_STS_SUCCESS;

332: IF (l_default_group_type <> 'RS_TEAM') THEN
333: l_param_resource_type := 'RS_INDIVIDUAL';
334: l_update_own_flag := 'N';
335: -- Initialize API return status to success
336: x_return_status := FND_API.G_RET_STS_SUCCESS;
337: l_own_return_status := FND_API.G_RET_STS_SUCCESS;
338: l_group_id := p_service_request_rec.owner_group_id ;
339:
340: IF (FND_PROFILE.VALUE('CS_SR_OWNER_AUTO_ASSIGN_LEVEL') = 'GROUP') THEN

Line 337: l_own_return_status := FND_API.G_RET_STS_SUCCESS;

333: l_param_resource_type := 'RS_INDIVIDUAL';
334: l_update_own_flag := 'N';
335: -- Initialize API return status to success
336: x_return_status := FND_API.G_RET_STS_SUCCESS;
337: l_own_return_status := FND_API.G_RET_STS_SUCCESS;
338: l_group_id := p_service_request_rec.owner_group_id ;
339:
340: IF (FND_PROFILE.VALUE('CS_SR_OWNER_AUTO_ASSIGN_LEVEL') = 'GROUP') THEN
341: RETURN;

Line 359: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

355: x_msg_data => x_msg_data
356: );
357:
358: x_return_status := l_own_return_status ;
359: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
360: IF (l_owner_id IS NULL) THEN
361: FND_MSG_PUB.Initialize;
362: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
363: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);

Line 365: l_main_return_status := FND_API.G_RET_STS_SUCCESS;

361: FND_MSG_PUB.Initialize;
362: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
363: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
364: FND_MSG_PUB.Add;
365: l_main_return_status := FND_API.G_RET_STS_SUCCESS;
366: ELSE
367: l_update_own_flag := 'Y';
368: END IF;
369: ELSE

Line 370: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

366: ELSE
367: l_update_own_flag := 'Y';
368: END IF;
369: ELSE
370: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
371: FND_MSG_PUB.Initialize; -- Uncommented for Bug 13696291
372: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
373: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
374: FND_MSG_PUB.Add;

Line 375: l_main_return_status := FND_API.G_RET_STS_ERROR;

371: FND_MSG_PUB.Initialize; -- Uncommented for Bug 13696291
372: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
373: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
374: FND_MSG_PUB.Add;
375: l_main_return_status := FND_API.G_RET_STS_ERROR;
376: ELSE
377: --FND_MSG_PUB.Initialize;
378: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
379: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);

Line 381: l_main_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

377: --FND_MSG_PUB.Initialize;
378: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
379: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
380: FND_MSG_PUB.Add;
381: l_main_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: END IF;
383: END IF;
384: END IF; /* CS_SR_OWNER_AUTO_ASSIGN_LEVEL */
385: END IF; /* group_type <> RS_TEAM */

Line 410: IF (l_main_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

406:
407: END IF; /* l_update_grp_flag OR l_update_own_flag IS 'Y' */
408:
409: -- x_owner_group_id is added for ER# 2616902
410: IF (l_main_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
411: x_owner_id := NULL;
412: x_owner_type := NULL;
413: x_owner_group_id := l_group_id;
414: x_territory_id := l_territory_id;

Line 425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

421: x_return_status := l_main_return_status;
422: END IF;
423:
424: EXCEPTION
425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
427: FND_MSG_PUB.Count_And_Get
428: ( p_count => x_msg_count,
429: p_data => x_msg_data

Line 426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

422: END IF;
423:
424: EXCEPTION
425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
427: FND_MSG_PUB.Count_And_Get
428: ( p_count => x_msg_count,
429: p_data => x_msg_data
430: );

Line 433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

429: p_data => x_msg_data
430: );
431:
432: WHEN OTHERS THEN
433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
434: FND_MSG_PUB.Count_And_Get
435: ( p_count => x_msg_count,
436: p_data => x_msg_data
437: );

Line 443: ( p_init_msg_list IN varchar2 := fnd_api.g_false,

439: END Assign_Resources;
440:
441: -- This Procedure returns the Group if not passed.
442: PROCEDURE Assign_Group
443: ( p_init_msg_list IN varchar2 := fnd_api.g_false,
444: p_commit IN varchar2 := fnd_api.g_false,
445: p_incident_id IN number,
446: p_group_type IN varchar2,
447: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,

Line 444: p_commit IN varchar2 := fnd_api.g_false,

440:
441: -- This Procedure returns the Group if not passed.
442: PROCEDURE Assign_Group
443: ( p_init_msg_list IN varchar2 := fnd_api.g_false,
444: p_commit IN varchar2 := fnd_api.g_false,
445: p_incident_id IN number,
446: p_group_type IN varchar2,
447: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,
448: x_return_status OUT NOCOPY VARCHAR2,

Line 550: x_return_status := FND_API.G_RET_STS_SUCCESS;

546:
547:
548: BEGIN
549: -- Initialize API return status to success
550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551:
552: -- Assign the incident_id to a local variable
553: l_incident_id := p_incident_id;
554: -- Proceed only if incident_id is not null

Line 761: p_init_msg_list => FND_API.G_FALSE,

757: End If ;
758:
759: JTF_ASSIGN_PUB.GET_Assign_Resources
760: ( p_api_version => 1.0,
761: p_init_msg_list => FND_API.G_FALSE,
762: p_commit => 'F',
763: p_resource_id => NULL,
764: p_resource_type => l_resource_type,
765: p_role => NULL,

Line 798: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND

794: x_msg_count => x_msg_count,
795: x_msg_data => x_msg_data
796: );
797:
798: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND
799: l_Assign_Groups_tbl.COUNT > 0) THEN
800: Get_Sup_Usage_Group(l_Assign_Groups_tbl, x_resource_id, x_territory_id);
801: END IF;
802:

Line 828: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

824: == that contract preferred resource will work properly.
825: ===========================================================================================*/
826:
827: PROCEDURE Assign_Owner
828: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
829: p_commit IN VARCHAR2 := FND_API.G_FALSE,
830: p_incident_id IN NUMBER,
831: p_param_resource_type IN VARCHAR2,
832: p_group_id IN NUMBER,

Line 829: p_commit IN VARCHAR2 := FND_API.G_FALSE,

825: ===========================================================================================*/
826:
827: PROCEDURE Assign_Owner
828: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
829: p_commit IN VARCHAR2 := FND_API.G_FALSE,
830: p_incident_id IN NUMBER,
831: p_param_resource_type IN VARCHAR2,
832: p_group_id IN NUMBER,
833: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,

Line 978: x_return_status := FND_API.G_RET_STS_SUCCESS;

974:
975: BEGIN
976:
977: -- Initialize API return status to success
978: x_return_status := FND_API.G_RET_STS_SUCCESS;
979: -- Assign the incident_id to a local variable
980: l_incident_id := p_incident_id;
981:
982: -- Proceed only if incident_id is not null

Line 1179: p_init_msg_list => FND_API.G_FALSE,

1175: -- are always passed as Null and the Load Balancing will be done for all
1176: -- the resources with or without skills.
1177: JTF_ASSIGN_PUB.Get_Assign_Resources
1178: ( p_api_version => 1.0,
1179: p_init_msg_list => FND_API.G_FALSE,
1180: p_commit => 'F',
1181: p_resource_id => l_group_id,
1182: p_resource_type => l_param_resource_type,
1183: p_role => NULL,

Line 1216: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1212: x_msg_count => x_msg_count,
1213: x_msg_data => x_msg_data
1214: );
1215:
1216: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1217: p := l_Assign_Owner_tbl.FIRST ;
1218: IF (l_Assign_Owner_tbl.COUNT = 1 AND
1219: l_Assign_Owner_tbl(p).web_availability_flag = 'Y') THEN
1220: OPEN c_check_grp_res(l_group_id, l_Assign_Owner_tbl(p).resource_id);

Line 1333: IF (l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN

1329: x_msg_data => x_msg_data,
1330: x_territory_id => x_territory_id
1331: );
1332:
1333: IF (l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN
1334: /* due to TZ API error, but continue if resource is returned */
1335: IF (x_resource_id IS NOT NULL) THEN
1336: x_return_status := FND_API.G_RET_STS_SUCCESS;
1337: l_cal_load_return_sts := FND_API.G_RET_STS_SUCCESS;

Line 1336: x_return_status := FND_API.G_RET_STS_SUCCESS;

1332:
1333: IF (l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN
1334: /* due to TZ API error, but continue if resource is returned */
1335: IF (x_resource_id IS NOT NULL) THEN
1336: x_return_status := FND_API.G_RET_STS_SUCCESS;
1337: l_cal_load_return_sts := FND_API.G_RET_STS_SUCCESS;
1338: END IF;
1339: END IF;
1340:

Line 1337: l_cal_load_return_sts := FND_API.G_RET_STS_SUCCESS;

1333: IF (l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN
1334: /* due to TZ API error, but continue if resource is returned */
1335: IF (x_resource_id IS NOT NULL) THEN
1336: x_return_status := FND_API.G_RET_STS_SUCCESS;
1337: l_cal_load_return_sts := FND_API.G_RET_STS_SUCCESS;
1338: END IF;
1339: END IF;
1340:
1341: IF(l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1341: IF(l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN

1337: l_cal_load_return_sts := FND_API.G_RET_STS_SUCCESS;
1338: END IF;
1339: END IF;
1340:
1341: IF(l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN
1342: x_return_status := FND_API.G_RET_STS_ERROR ;
1343: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
1344: FND_MSG_PUB.Add;
1345: END IF;

Line 1342: x_return_status := FND_API.G_RET_STS_ERROR ;

1338: END IF;
1339: END IF;
1340:
1341: IF(l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN
1342: x_return_status := FND_API.G_RET_STS_ERROR ;
1343: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
1344: FND_MSG_PUB.Add;
1345: END IF;
1346: ELSE

Line 1361: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1357: END IF; -- l_incident_id and p_group_id is not null
1358: END Assign_Owner;
1359:
1360: PROCEDURE Calculate_Load
1361: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1362: p_incident_id IN NUMBER,
1363: p_incident_type_id IN NUMBER,
1364: p_incident_severity_id IN NUMBER,
1365: p_inv_item_id IN NUMBER,

Line 1533: x_return_status := FND_API.G_RET_STS_SUCCESS;

1529:
1530: BEGIN
1531:
1532: -- Initialize API return status to success
1533: x_return_status := FND_API.G_RET_STS_SUCCESS;
1534:
1535: -- Assigning type_id and severity_id to local variables so as to
1536: -- find the LB weights.
1537: l_incident_type_id := p_incident_type_id;

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

1688: ELSE
1689: l_time_lag := 0;
1690: END IF;
1691:
1692: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1693: FND_MESSAGE.Set_Name('CS', 'CS_TZ_API_ERR');
1694: FND_MSG_PUB.Add;
1695: EXIT ;
1696: END IF;

Line 1697: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1693: FND_MESSAGE.Set_Name('CS', 'CS_TZ_API_ERR');
1694: FND_MSG_PUB.Add;
1695: EXIT ;
1696: END IF;
1697: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1698: l_time_lag := abs(l_time_lag);
1699: ELSE
1700: l_time_lag := 0;
1701: END IF;

Line 1748: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1744: -- After the load for all resources are calculated find the
1745: -- resource with the max load.This is the winning resource to
1746: -- be returned
1747: -- If timezone API does not give error then proceed
1748: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1749: -- Changed index from i=0 to i=1 by pnkalari on 06/11/2002.
1750: --i := 0;
1751: -- Added this because if all the resource loads are 0,
1752: -- l_max_record_index is always the first resource.

Line 1792: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1788: x_resource_type := p_res_load_table(l_max_record_index).resource_type;
1789: x_territory_id := p_res_load_table(l_max_record_index).territory_id;
1790:
1791: IF (x_resource_id IS NOT NULL) THEN
1792: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1793: ELSIF (x_resource_id IS NULL) THEN
1794: x_return_status := FND_API.G_RET_STS_ERROR;
1795: END IF;
1796:

Line 1794: x_return_status := FND_API.G_RET_STS_ERROR;

1790:
1791: IF (x_resource_id IS NOT NULL) THEN
1792: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1793: ELSIF (x_resource_id IS NULL) THEN
1794: x_return_status := FND_API.G_RET_STS_ERROR;
1795: END IF;
1796:
1797: ELSE /* x_return_status = FND_API.G_RET_STS_SUCCESS */
1798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1797: ELSE /* x_return_status = FND_API.G_RET_STS_SUCCESS */

1793: ELSIF (x_resource_id IS NULL) THEN
1794: x_return_status := FND_API.G_RET_STS_ERROR;
1795: END IF;
1796:
1797: ELSE /* x_return_status = FND_API.G_RET_STS_SUCCESS */
1798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1799: END IF; /* x_return_status = FND_API.G_RET_STS_SUCCESS */
1800:
1801: END Calculate_Load;

Line 1798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1794: x_return_status := FND_API.G_RET_STS_ERROR;
1795: END IF;
1796:
1797: ELSE /* x_return_status = FND_API.G_RET_STS_SUCCESS */
1798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1799: END IF; /* x_return_status = FND_API.G_RET_STS_SUCCESS */
1800:
1801: END Calculate_Load;
1802:

Line 1799: END IF; /* x_return_status = FND_API.G_RET_STS_SUCCESS */

1795: END IF;
1796:
1797: ELSE /* x_return_status = FND_API.G_RET_STS_SUCCESS */
1798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1799: END IF; /* x_return_status = FND_API.G_RET_STS_SUCCESS */
1800:
1801: END Calculate_Load;
1802:
1803: END CS_ASSIGN_RESOURCE_PKG;