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;
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;
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;
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;
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;
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;
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;
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 536: x_return_status := FND_API.G_RET_STS_SUCCESS;

532: WHERE party_id = p_customer_id;
533:
534: BEGIN
535: -- Initialize API return status to success
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:
538: -- Assign the incident_id to a local variable
539: l_incident_id := p_incident_id;
540: -- Proceed only if incident_id is not null

Line 691: p_init_msg_list => FND_API.G_FALSE,

687: END IF;
688:
689: JTF_ASSIGN_PUB.GET_Assign_Resources
690: ( p_api_version => 1.0,
691: p_init_msg_list => FND_API.G_FALSE,
692: p_commit => 'F',
693: p_resource_id => NULL,
694: p_resource_type => l_resource_type,
695: p_role => NULL,

Line 727: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND

723: x_msg_count => x_msg_count,
724: x_msg_data => x_msg_data
725: );
726:
727: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND
728: l_Assign_Groups_tbl.COUNT > 0) THEN
729: Get_Sup_Usage_Group(l_Assign_Groups_tbl, x_resource_id, x_territory_id);
730: END IF;
731:

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

753: == that contract preferred resource will work properly.
754: ===========================================================================================*/
755:
756: PROCEDURE Assign_Owner
757: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
758: p_commit IN VARCHAR2 := FND_API.G_FALSE,
759: p_incident_id IN NUMBER,
760: p_param_resource_type IN VARCHAR2,
761: p_group_id IN NUMBER,

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

754: ===========================================================================================*/
755:
756: PROCEDURE Assign_Owner
757: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
758: p_commit IN VARCHAR2 := FND_API.G_FALSE,
759: p_incident_id IN NUMBER,
760: p_param_resource_type IN VARCHAR2,
761: p_group_id IN NUMBER,
762: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,

Line 871: x_return_status := FND_API.G_RET_STS_SUCCESS;

867:
868: BEGIN
869:
870: -- Initialize API return status to success
871: x_return_status := FND_API.G_RET_STS_SUCCESS;
872: -- Assign the incident_id to a local variable
873: l_incident_id := p_incident_id;
874:
875: -- Proceed only if incident_id is not null

Line 1013: p_init_msg_list => FND_API.G_FALSE,

1009: -- are always passed as Null and the Load Balancing will be done for all
1010: -- the resources with or without skills.
1011: JTF_ASSIGN_PUB.Get_Assign_Resources
1012: ( p_api_version => 1.0,
1013: p_init_msg_list => FND_API.G_FALSE,
1014: p_commit => 'F',
1015: p_resource_id => l_group_id,
1016: p_resource_type => l_param_resource_type,
1017: p_role => NULL,

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

1045: x_msg_count => x_msg_count,
1046: x_msg_data => x_msg_data
1047: );
1048:
1049: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1050: p := l_Assign_Owner_tbl.FIRST ;
1051: IF (l_Assign_Owner_tbl.COUNT = 1 AND
1052: l_Assign_Owner_tbl(p).web_availability_flag = 'Y') THEN
1053: OPEN c_check_grp_res(l_group_id, l_Assign_Owner_tbl(p).resource_id);

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

1122: x_msg_data => x_msg_data,
1123: x_territory_id => x_territory_id
1124: );
1125:
1126: IF (l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN
1127: /* due to TZ API error, but continue if resource is returned */
1128: IF (x_resource_id IS NOT NULL) THEN
1129: x_return_status := FND_API.G_RET_STS_SUCCESS;
1130: l_cal_load_return_sts := FND_API.G_RET_STS_SUCCESS;

Line 1129: x_return_status := FND_API.G_RET_STS_SUCCESS;

1125:
1126: IF (l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN
1127: /* due to TZ API error, but continue if resource is returned */
1128: IF (x_resource_id IS NOT NULL) THEN
1129: x_return_status := FND_API.G_RET_STS_SUCCESS;
1130: l_cal_load_return_sts := FND_API.G_RET_STS_SUCCESS;
1131: END IF;
1132: END IF;
1133:

Line 1130: l_cal_load_return_sts := FND_API.G_RET_STS_SUCCESS;

1126: IF (l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN
1127: /* due to TZ API error, but continue if resource is returned */
1128: IF (x_resource_id IS NOT NULL) THEN
1129: x_return_status := FND_API.G_RET_STS_SUCCESS;
1130: l_cal_load_return_sts := FND_API.G_RET_STS_SUCCESS;
1131: END IF;
1132: END IF;
1133:
1134: IF(l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN

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

1130: l_cal_load_return_sts := FND_API.G_RET_STS_SUCCESS;
1131: END IF;
1132: END IF;
1133:
1134: IF(l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN
1135: x_return_status := FND_API.G_RET_STS_ERROR ;
1136: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
1137: FND_MSG_PUB.Add;
1138: END IF;

Line 1135: x_return_status := FND_API.G_RET_STS_ERROR ;

1131: END IF;
1132: END IF;
1133:
1134: IF(l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN
1135: x_return_status := FND_API.G_RET_STS_ERROR ;
1136: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
1137: FND_MSG_PUB.Add;
1138: END IF;
1139: ELSE

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

1150: END IF; -- l_incident_id and p_group_id is not null
1151: END Assign_Owner;
1152:
1153: PROCEDURE Calculate_Load
1154: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1155: p_incident_id IN NUMBER,
1156: p_incident_type_id IN NUMBER,
1157: p_incident_severity_id IN NUMBER,
1158: p_inv_item_id IN NUMBER,

Line 1326: x_return_status := FND_API.G_RET_STS_SUCCESS;

1322:
1323: BEGIN
1324:
1325: -- Initialize API return status to success
1326: x_return_status := FND_API.G_RET_STS_SUCCESS;
1327:
1328: -- Assigning type_id and severity_id to local variables so as to
1329: -- find the LB weights.
1330: l_incident_type_id := p_incident_type_id;

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

1481: ELSE
1482: l_time_lag := 0;
1483: END IF;
1484:
1485: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1486: FND_MESSAGE.Set_Name('CS', 'CS_TZ_API_ERR');
1487: FND_MSG_PUB.Add;
1488: EXIT ;
1489: END IF;

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

1486: FND_MESSAGE.Set_Name('CS', 'CS_TZ_API_ERR');
1487: FND_MSG_PUB.Add;
1488: EXIT ;
1489: END IF;
1490: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1491: l_time_lag := abs(l_time_lag);
1492: ELSE
1493: l_time_lag := 0;
1494: END IF;

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

1537: -- After the load for all resources are calculated find the
1538: -- resource with the max load.This is the winning resource to
1539: -- be returned
1540: -- If timezone API does not give error then proceed
1541: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1542: -- Changed index from i=0 to i=1 by pnkalari on 06/11/2002.
1543: --i := 0;
1544: -- Added this because if all the resource loads are 0,
1545: -- l_max_record_index is always the first resource.

Line 1585: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1581: x_resource_type := p_res_load_table(l_max_record_index).resource_type;
1582: x_territory_id := p_res_load_table(l_max_record_index).territory_id;
1583:
1584: IF (x_resource_id IS NOT NULL) THEN
1585: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1586: ELSIF (x_resource_id IS NULL) THEN
1587: x_return_status := FND_API.G_RET_STS_ERROR;
1588: END IF;
1589:

Line 1587: x_return_status := FND_API.G_RET_STS_ERROR;

1583:
1584: IF (x_resource_id IS NOT NULL) THEN
1585: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1586: ELSIF (x_resource_id IS NULL) THEN
1587: x_return_status := FND_API.G_RET_STS_ERROR;
1588: END IF;
1589:
1590: ELSE /* x_return_status = FND_API.G_RET_STS_SUCCESS */
1591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1586: ELSIF (x_resource_id IS NULL) THEN
1587: x_return_status := FND_API.G_RET_STS_ERROR;
1588: END IF;
1589:
1590: ELSE /* x_return_status = FND_API.G_RET_STS_SUCCESS */
1591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1592: END IF; /* x_return_status = FND_API.G_RET_STS_SUCCESS */
1593:
1594: END Calculate_Load;

Line 1591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1587: x_return_status := FND_API.G_RET_STS_ERROR;
1588: END IF;
1589:
1590: ELSE /* x_return_status = FND_API.G_RET_STS_SUCCESS */
1591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1592: END IF; /* x_return_status = FND_API.G_RET_STS_SUCCESS */
1593:
1594: END Calculate_Load;
1595:

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

1588: END IF;
1589:
1590: ELSE /* x_return_status = FND_API.G_RET_STS_SUCCESS */
1591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1592: END IF; /* x_return_status = FND_API.G_RET_STS_SUCCESS */
1593:
1594: END Calculate_Load;
1595:
1596: END CS_ASSIGN_RESOURCE_PKG;