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_CON_PKG dependencies on FND_API

Line 211: p_init_msg_list => fnd_api.g_false,

207:
208: CS_Assign_Resource_CON_PKG.Assign_ServiceRequest_Main
209: ( p_api_name => 'Assign_ServiceRequest_Main',
210: p_api_version => 1.0 ,
211: p_init_msg_list => fnd_api.g_false,
212: p_commit => fnd_api.g_false,
213: p_incident_id => l_incident_id,
214: p_object_version_number => l_object_version_number,
215: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 212: p_commit => fnd_api.g_false,

208: CS_Assign_Resource_CON_PKG.Assign_ServiceRequest_Main
209: ( p_api_name => 'Assign_ServiceRequest_Main',
210: p_api_version => 1.0 ,
211: p_init_msg_list => fnd_api.g_false,
212: p_commit => fnd_api.g_false,
213: p_incident_id => l_incident_id,
214: p_object_version_number => l_object_version_number,
215: p_last_updated_by => FND_GLOBAL.USER_ID,
216: p_service_request_rec => l_sr_rec,

Line 260: x_return_status := FND_API.G_RET_STS_SUCCESS;

256: l_sr_rec CS_ServiceRequest_PVT.service_request_rec_type DEFAULT p_service_request_rec;
257:
258: BEGIN
259: -- Initialize API return status to success
260: x_return_status := FND_API.G_RET_STS_SUCCESS;
261:
262: -- Standard call to check for call compatibility
263: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
264: G_PKG_NAME) THEN

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

259: -- Initialize API return status to success
260: x_return_status := FND_API.G_RET_STS_SUCCESS;
261:
262: -- Standard call to check for call compatibility
263: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
264: G_PKG_NAME) THEN
265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
266: END IF;
267:

Line 265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

261:
262: -- Standard call to check for call compatibility
263: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
264: G_PKG_NAME) THEN
265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
266: END IF;
267:
268: -- Initialize message list if p_init_msg_list is set to TRUE
269: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 269: IF FND_API.To_Boolean(p_init_msg_list) THEN

265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
266: END IF;
267:
268: -- Initialize message list if p_init_msg_list is set to TRUE
269: IF FND_API.To_Boolean(p_init_msg_list) THEN
270: FND_MSG_PUB.Initialize;
271: END IF;
272:
273: IF (p_incident_id IS NOT NULL) THEN

Line 357: IF FND_API.To_Boolean(p_init_msg_list) THEN

353: WHERE instance_id = p_subcomponent_id;
354:
355: BEGIN
356: -- Initialize message list if p_init_msg_list is set to TRUE
357: IF FND_API.To_Boolean(p_init_msg_list) THEN
358: FND_MSG_PUB.Initialize;
359: END IF;
360:
361: -- Initialize API return status to success

Line 362: x_return_status := FND_API.G_RET_STS_SUCCESS;

358: FND_MSG_PUB.Initialize;
359: END IF;
360:
361: -- Initialize API return status to success
362: x_return_status := FND_API.G_RET_STS_SUCCESS;
363: l_grp_return_status := FND_API.G_RET_STS_SUCCESS;
364: l_main_return_status := FND_API.G_RET_STS_SUCCESS;
365:
366: -- if default_group_type profile is null, set default to RS_GROUP for API always

Line 363: l_grp_return_status := FND_API.G_RET_STS_SUCCESS;

359: END IF;
360:
361: -- Initialize API return status to success
362: x_return_status := FND_API.G_RET_STS_SUCCESS;
363: l_grp_return_status := FND_API.G_RET_STS_SUCCESS;
364: l_main_return_status := FND_API.G_RET_STS_SUCCESS;
365:
366: -- if default_group_type profile is null, set default to RS_GROUP for API always
367: IF (l_sr_rec.group_type IS NULL) THEN

Line 364: l_main_return_status := FND_API.G_RET_STS_SUCCESS;

360:
361: -- Initialize API return status to success
362: x_return_status := FND_API.G_RET_STS_SUCCESS;
363: l_grp_return_status := FND_API.G_RET_STS_SUCCESS;
364: l_main_return_status := FND_API.G_RET_STS_SUCCESS;
365:
366: -- if default_group_type profile is null, set default to RS_GROUP for API always
367: IF (l_sr_rec.group_type IS NULL) THEN
368: FND_PROFILE.Get('CS_SR_DEFAULT_GROUP_TYPE', l_default_group_type);

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

401: x_territory_id => l_territory_id,
402: x_msg_count => x_msg_count,
403: x_msg_data => x_msg_data
404: );
405: IF (l_grp_return_status = FND_API.G_RET_STS_SUCCESS) THEN
406: IF (FND_PROFILE.VALUE('CS_SR_OWNER_AUTO_ASSIGN_LEVEL') = 'GROUP') THEN
407: x_owner_group_id := l_group_id;
408: IF (l_group_id IS NOT NULL) THEN
409: l_update_grp_flag := 'Y';

Line 421: x_return_status := FND_API.G_RET_STS_SUCCESS;

417: IF (l_default_group_type <> 'RS_TEAM') THEN
418: l_param_resource_type := 'RS_INDIVIDUAL';
419: l_update_own_flag := 'N';
420: -- Initialize API return status to success
421: x_return_status := FND_API.G_RET_STS_SUCCESS;
422: l_own_return_status := FND_API.G_RET_STS_SUCCESS;
423:
424: CS_ASSIGN_RESOURCE_CON_PKG.Assign_Owner
425: (p_init_msg_list => p_init_msg_list,

Line 422: l_own_return_status := FND_API.G_RET_STS_SUCCESS;

418: l_param_resource_type := 'RS_INDIVIDUAL';
419: l_update_own_flag := 'N';
420: -- Initialize API return status to success
421: x_return_status := FND_API.G_RET_STS_SUCCESS;
422: l_own_return_status := FND_API.G_RET_STS_SUCCESS;
423:
424: CS_ASSIGN_RESOURCE_CON_PKG.Assign_Owner
425: (p_init_msg_list => p_init_msg_list,
426: p_commit => p_commit,

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

435: x_msg_count => x_msg_count,
436: x_msg_data => x_msg_data
437: );
438: x_return_status := l_own_return_status ;
439: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
440: IF (l_owner_id IS NULL) THEN
441: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
442: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
443: l_msg := fnd_message.get ;

Line 445: l_main_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

441: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
442: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
443: l_msg := fnd_message.get ;
444: fnd_file.put_line(fnd_file.log,' ' || l_msg);
445: l_main_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
446: ELSE
447: l_update_own_flag := 'Y';
448: END IF;
449: ELSE

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

449: ELSE
450: -- Check for Expected and Unexpected Error
451: -- For Expected Error the message stack is initialized.
452: -- For Unexpected Error only all the messages are shown
453: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
454: FND_MSG_PUB.Initialize;
455: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
456: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
457: l_msg := fnd_message.get ;

Line 459: l_main_return_status := FND_API.G_RET_STS_ERROR;

455: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
456: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
457: l_msg := fnd_message.get ;
458: fnd_file.put_line(fnd_file.log,' ' || l_msg);
459: l_main_return_status := FND_API.G_RET_STS_ERROR;
460: ELSE
461: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
462: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
463: l_msg := fnd_message.get ;

Line 465: l_main_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

461: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
462: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
463: l_msg := fnd_message.get ;
464: fnd_file.put_line(fnd_file.log,' ' || l_msg);
465: l_main_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
466: END IF;
467: END IF;
468: END IF; /* group_type <> RS_TEAM */
469: ELSE /* l_group_id is not null */

Line 474: l_main_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

470: -- Print all the error messages
471: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_GROUP');
472: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
473: fnd_file.put_line(fnd_file.log,' ' || l_msg);
474: l_main_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
475: END IF;
476: END IF; /* CS_SR_OWNER_AUTO_ASSIGN_LEVEL */
477: ELSE /* l_grp_return_status is not success */
478: -- Check for Expected and Unexpected Error

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

477: ELSE /* l_grp_return_status is not success */
478: -- Check for Expected and Unexpected Error
479: -- For Expected Error the message stack is initialized.
480: -- For Unexpected Error only all the messages are shown
481: IF (l_grp_return_status = FND_API.G_RET_STS_ERROR) THEN
482: FND_MSG_PUB.Initialize;
483: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
484: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
485: l_msg := fnd_message.get ;

Line 487: l_main_return_status := FND_API.G_RET_STS_ERROR;

483: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
484: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
485: l_msg := fnd_message.get ;
486: fnd_file.put_line(fnd_file.log,' ' || l_msg);
487: l_main_return_status := FND_API.G_RET_STS_ERROR;
488: ELSE
489: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_GROUP');
490: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
491: l_msg := fnd_message.get ;

Line 493: l_main_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

489: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_GROUP');
490: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
491: l_msg := fnd_message.get ;
492: fnd_file.put_line(fnd_file.log,' ' || l_msg);
493: l_main_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
494: END IF;
495: END IF; /* l_grp_return_status is not success */
496:
497: ELSE /* owner_group_id is not null, group has been assigned */

Line 502: x_return_status := FND_API.G_RET_STS_SUCCESS;

498: IF (l_default_group_type <> 'RS_TEAM') THEN
499: l_param_resource_type := 'RS_INDIVIDUAL';
500: l_update_own_flag := 'N';
501: -- Initialize API return status to success
502: x_return_status := FND_API.G_RET_STS_SUCCESS;
503: l_own_return_status := FND_API.G_RET_STS_SUCCESS;
504: l_group_id := p_service_request_rec.owner_group_id ;
505:
506: IF (FND_PROFILE.VALUE('CS_SR_OWNER_AUTO_ASSIGN_LEVEL') = 'GROUP') THEN

Line 503: l_own_return_status := FND_API.G_RET_STS_SUCCESS;

499: l_param_resource_type := 'RS_INDIVIDUAL';
500: l_update_own_flag := 'N';
501: -- Initialize API return status to success
502: x_return_status := FND_API.G_RET_STS_SUCCESS;
503: l_own_return_status := FND_API.G_RET_STS_SUCCESS;
504: l_group_id := p_service_request_rec.owner_group_id ;
505:
506: IF (FND_PROFILE.VALUE('CS_SR_OWNER_AUTO_ASSIGN_LEVEL') = 'GROUP') THEN
507: x_owner_group_id := l_group_id;

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

521: x_msg_count => x_msg_count,
522: x_msg_data => x_msg_data
523: );
524: x_return_status := l_own_return_status ;
525: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
526: IF (l_owner_id IS NULL) THEN
527: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
528: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
529: l_msg := fnd_message.get ;

Line 531: l_main_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

527: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
528: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
529: l_msg := fnd_message.get ;
530: fnd_file.put_line(fnd_file.log,' ' || l_msg);
531: l_main_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: ELSE
533: l_update_own_flag := 'Y';
534: END IF;
535: ELSE

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

532: ELSE
533: l_update_own_flag := 'Y';
534: END IF;
535: ELSE
536: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
537: FND_MSG_PUB.Initialize;
538: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
539: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
540: l_msg := fnd_message.get ;

Line 542: l_main_return_status := FND_API.G_RET_STS_ERROR;

538: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
539: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
540: l_msg := fnd_message.get ;
541: fnd_file.put_line(fnd_file.log,' ' || l_msg);
542: l_main_return_status := FND_API.G_RET_STS_ERROR;
543: ELSE
544: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
545: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
546: l_msg := fnd_message.get ;

Line 548: l_main_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

544: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
545: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
546: l_msg := fnd_message.get ;
547: fnd_file.put_line(fnd_file.log,' ' || l_msg);
548: l_main_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: END IF;
550: END IF;
551: END IF; /* CS_SR_OWNER_AUTO_ASSIGN_LEVEL */
552: END IF; /* group_type <> RS_TEAM */

Line 585: p_validation_level => fnd_api.g_valid_level_none,

581: CS_ServiceRequest_pvt.Update_ServiceRequest(
582: p_api_version => 4.0,
583: p_init_msg_list => 'T',
584: p_commit => 'T',
585: p_validation_level => fnd_api.g_valid_level_none,
586: x_return_status => l_return_status,
587: x_msg_count => l_msg_count,
588: x_msg_data => l_msg_data,
589: p_request_id => p_incident_id,

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

604: );
605:
606: END;
607: END IF;
608: IF (l_main_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
609: x_owner_id := NULL;
610: x_owner_type := NULL;
611: x_owner_group_id := l_group_id;
612: x_return_status := l_main_return_status;

Line 625: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

621:
622: END Assign_Resources;
623:
624: PROCEDURE Assign_Group
625: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
626: p_commit IN VARCHAR2 := fnd_api.g_false,
627: p_incident_id IN NUMBER,
628: p_group_type IN VARCHAR2,
629: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,

Line 626: p_commit IN VARCHAR2 := fnd_api.g_false,

622: END Assign_Resources;
623:
624: PROCEDURE Assign_Group
625: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
626: p_commit IN VARCHAR2 := fnd_api.g_false,
627: p_incident_id IN NUMBER,
628: p_group_type IN VARCHAR2,
629: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,
630: x_return_status OUT NOCOPY VARCHAR2,

Line 724: x_return_status := FND_API.G_RET_STS_SUCCESS;

720: WHERE party_id = p_customer_id;
721:
722: BEGIN
723: -- Initialize API return status to success
724: x_return_status := FND_API.G_RET_STS_SUCCESS;
725:
726: l_incident_id := p_incident_id;
727: l_cust_prod_id := l_sr_rec.customer_product_id;
728:

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

940: x_msg_count => x_msg_count,
941: x_msg_data => x_msg_data
942: );
943:
944: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
945: IF (l_Assign_Groups_tbl.COUNT > 0) THEN
946: CS_ASSIGN_RESOURCE_PKG.Get_Sup_Usage_Group(
947: l_Assign_Groups_tbl, x_resource_id, x_territory_id);
948: END IF;

Line 974: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

970: == First record of the p_res_load_table is not been left blank, so
971: == that contract preferred resource will work properly.
972: ===========================================================================================*/
973: PROCEDURE Assign_Owner
974: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
975: p_commit IN VARCHAR2 := fnd_api.g_false,
976: p_incident_id IN NUMBER,
977: p_param_resource_type IN VARCHAR2,
978: p_group_id IN NUMBER,

Line 975: p_commit IN VARCHAR2 := fnd_api.g_false,

971: == that contract preferred resource will work properly.
972: ===========================================================================================*/
973: PROCEDURE Assign_Owner
974: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
975: p_commit IN VARCHAR2 := fnd_api.g_false,
976: p_incident_id IN NUMBER,
977: p_param_resource_type IN VARCHAR2,
978: p_group_id IN NUMBER,
979: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,

Line 1105: x_return_status := FND_API.G_RET_STS_SUCCESS;

1101: WHERE party_id = p_customer_id;
1102:
1103: BEGIN
1104: -- Initialize API return status to success
1105: x_return_status := FND_API.G_RET_STS_SUCCESS;
1106:
1107: l_incident_id := p_incident_id;
1108: l_cust_prod_id := l_sr_rec.customer_product_id;
1109: -- if incident_id is not null proceed, otherwise exit API

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

1317: x_msg_count => x_msg_count,
1318: x_msg_data => x_msg_data
1319: );
1320:
1321: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1322: p := l_Assign_Owner_tbl.FIRST ;
1323: if (l_Assign_Owner_tbl.count = 1 AND
1324: l_Assign_Owner_tbl(p).web_availability_flag = 'Y') then
1325: OPEN c_check_grp_res(l_group_id, l_Assign_Owner_tbl(p).resource_id);

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

1396: x_msg_data => x_msg_data,
1397: x_territory_id => x_territory_id
1398: );
1399:
1400: IF (l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN
1401: /* due to TZ API error, but continue if resource is returned */
1402: IF (x_resource_id IS NOT NULL) THEN
1403: x_return_status := FND_API.G_RET_STS_SUCCESS;
1404: l_cal_load_return_sts := FND_API.G_RET_STS_SUCCESS;

Line 1403: x_return_status := FND_API.G_RET_STS_SUCCESS;

1399:
1400: IF (l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN
1401: /* due to TZ API error, but continue if resource is returned */
1402: IF (x_resource_id IS NOT NULL) THEN
1403: x_return_status := FND_API.G_RET_STS_SUCCESS;
1404: l_cal_load_return_sts := FND_API.G_RET_STS_SUCCESS;
1405: END IF;
1406: END IF;
1407:

Line 1404: l_cal_load_return_sts := FND_API.G_RET_STS_SUCCESS;

1400: IF (l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN
1401: /* due to TZ API error, but continue if resource is returned */
1402: IF (x_resource_id IS NOT NULL) THEN
1403: x_return_status := FND_API.G_RET_STS_SUCCESS;
1404: l_cal_load_return_sts := FND_API.G_RET_STS_SUCCESS;
1405: END IF;
1406: END IF;
1407:
1408: IF (l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN

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

1404: l_cal_load_return_sts := FND_API.G_RET_STS_SUCCESS;
1405: END IF;
1406: END IF;
1407:
1408: IF (l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN
1409: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
1410: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
1411: l_msg := fnd_message.get ;
1412: fnd_file.put_line(fnd_file.log,' ' || l_msg);

Line 1413: x_return_status := FND_API.G_RET_STS_ERROR ;

1409: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
1410: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
1411: l_msg := fnd_message.get ;
1412: fnd_file.put_line(fnd_file.log,' ' || l_msg);
1413: x_return_status := FND_API.G_RET_STS_ERROR ;
1414: END IF;
1415: ELSE
1416: IF (l_resource_load_tbl.COUNT = 1) THEN
1417: l := l_resource_load_tbl.FIRST;

Line 1431: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1427: END Assign_Owner;
1428:
1429: -- Added parameter p_inv_cat_id by pnkalari on 06/11/2002.
1430: PROCEDURE Calculate_Load
1431: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1432: p_incident_id IN NUMBER,
1433: p_incident_type_id IN NUMBER,
1434: p_incident_severity_id IN NUMBER,
1435: p_inv_item_id IN NUMBER,

Line 1600: x_return_status := FND_API.G_RET_STS_SUCCESS;

1596: WHERE resource_id = p_resource_id;
1597:
1598: BEGIN
1599: -- Initialize API return status to success
1600: x_return_status := FND_API.G_RET_STS_SUCCESS;
1601:
1602: l_incident_type_id := p_incident_type_id;
1603: l_incident_severity_id := p_incident_severity_id;
1604:

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

1757: ELSE
1758: l_time_lag := 0;
1759: END IF;
1760:
1761: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1762: FND_MESSAGE.Set_Name('CS', 'CS_TZ_API_ERR');
1763: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
1764: l_msg := fnd_message.get ;
1765: fnd_file.put_line(fnd_file.log,' ' || l_msg);

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

1765: fnd_file.put_line(fnd_file.log,' ' || l_msg);
1766: EXIT ;
1767: END IF;
1768:
1769: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1770: l_time_lag := abs(l_time_lag);
1771: ELSE
1772: l_time_lag := 0;
1773: END IF;

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

1816: -- resource with the max load.This is the winning resource to
1817: -- be returned
1818: -- If timezone API does not give error then proceed
1819:
1820: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1821: --i := 0;
1822: -- Added this because if all the resource loads are 0,
1823: -- l_max_record_index is always the first resource.
1824: l_max_record_index := p_res_load_table.FIRST;

Line 1860: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1856: x_resource_id := p_res_load_table(l_max_record_index).resource_id;
1857: x_resource_type := p_res_load_table(l_max_record_index).resource_type;
1858: x_territory_id := p_res_load_table(l_max_record_index).territory_id;
1859: IF (x_resource_id IS NOT NULL) THEN
1860: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1861: ELSIF(x_resource_id IS NULL) THEN
1862: x_return_status := FND_API.G_RET_STS_ERROR;
1863: END IF;
1864: ELSE -- x_return_status is success loop

Line 1862: x_return_status := FND_API.G_RET_STS_ERROR;

1858: x_territory_id := p_res_load_table(l_max_record_index).territory_id;
1859: IF (x_resource_id IS NOT NULL) THEN
1860: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1861: ELSIF(x_resource_id IS NULL) THEN
1862: x_return_status := FND_API.G_RET_STS_ERROR;
1863: END IF;
1864: ELSE -- x_return_status is success loop
1865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1866: END IF;

Line 1865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1861: ELSIF(x_resource_id IS NULL) THEN
1862: x_return_status := FND_API.G_RET_STS_ERROR;
1863: END IF;
1864: ELSE -- x_return_status is success loop
1865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1866: END IF;
1867:
1868: END Calculate_Load;
1869: