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

709: WHERE party_id = p_customer_id;
710:
711: BEGIN
712: -- Initialize API return status to success
713: x_return_status := FND_API.G_RET_STS_SUCCESS;
714:
715: l_incident_id := p_incident_id;
716: l_cust_prod_id := l_sr_rec.customer_product_id;
717:

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

893: x_msg_count => x_msg_count,
894: x_msg_data => x_msg_data
895: );
896:
897: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
898: IF (l_Assign_Groups_tbl.COUNT > 0) THEN
899: CS_ASSIGN_RESOURCE_PKG.Get_Sup_Usage_Group(
900: l_Assign_Groups_tbl, x_resource_id, x_territory_id);
901: END IF;

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

923: == First record of the p_res_load_table is not been left blank, so
924: == that contract preferred resource will work properly.
925: ===========================================================================================*/
926: PROCEDURE Assign_Owner
927: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
928: p_commit IN VARCHAR2 := fnd_api.g_false,
929: p_incident_id IN NUMBER,
930: p_param_resource_type IN VARCHAR2,
931: p_group_id IN NUMBER,

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

924: == that contract preferred resource will work properly.
925: ===========================================================================================*/
926: PROCEDURE Assign_Owner
927: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
928: p_commit IN VARCHAR2 := fnd_api.g_false,
929: p_incident_id IN NUMBER,
930: p_param_resource_type IN VARCHAR2,
931: p_group_id IN NUMBER,
932: p_service_request_rec IN CS_ServiceRequest_pvt.service_request_rec_type,

Line 1049: x_return_status := FND_API.G_RET_STS_SUCCESS;

1045: WHERE party_id = p_customer_id;
1046:
1047: BEGIN
1048: -- Initialize API return status to success
1049: x_return_status := FND_API.G_RET_STS_SUCCESS;
1050:
1051: l_incident_id := p_incident_id;
1052: l_cust_prod_id := l_sr_rec.customer_product_id;
1053: -- if incident_id is not null proceed, otherwise exit API

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

1224: x_msg_count => x_msg_count,
1225: x_msg_data => x_msg_data
1226: );
1227:
1228: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1229: p := l_Assign_Owner_tbl.FIRST ;
1230: if (l_Assign_Owner_tbl.count = 1 AND
1231: l_Assign_Owner_tbl(p).web_availability_flag = 'Y') then
1232: OPEN c_check_grp_res(l_group_id, l_Assign_Owner_tbl(p).resource_id);

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

1303: x_msg_data => x_msg_data,
1304: x_territory_id => x_territory_id
1305: );
1306:
1307: IF (l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN
1308: /* due to TZ API error, but continue if resource is returned */
1309: IF (x_resource_id IS NOT NULL) THEN
1310: x_return_status := FND_API.G_RET_STS_SUCCESS;
1311: l_cal_load_return_sts := FND_API.G_RET_STS_SUCCESS;

Line 1310: x_return_status := FND_API.G_RET_STS_SUCCESS;

1306:
1307: IF (l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN
1308: /* due to TZ API error, but continue if resource is returned */
1309: IF (x_resource_id IS NOT NULL) THEN
1310: x_return_status := FND_API.G_RET_STS_SUCCESS;
1311: l_cal_load_return_sts := FND_API.G_RET_STS_SUCCESS;
1312: END IF;
1313: END IF;
1314:

Line 1311: l_cal_load_return_sts := FND_API.G_RET_STS_SUCCESS;

1307: IF (l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN
1308: /* due to TZ API error, but continue if resource is returned */
1309: IF (x_resource_id IS NOT NULL) THEN
1310: x_return_status := FND_API.G_RET_STS_SUCCESS;
1311: l_cal_load_return_sts := FND_API.G_RET_STS_SUCCESS;
1312: END IF;
1313: END IF;
1314:
1315: IF (l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN

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

1311: l_cal_load_return_sts := FND_API.G_RET_STS_SUCCESS;
1312: END IF;
1313: END IF;
1314:
1315: IF (l_cal_load_return_sts <> FND_API.G_RET_STS_SUCCESS) THEN
1316: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
1317: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
1318: l_msg := fnd_message.get ;
1319: fnd_file.put_line(fnd_file.log,' ' || l_msg);

Line 1320: x_return_status := FND_API.G_RET_STS_ERROR ;

1316: FND_MESSAGE.Set_Name('CS', 'CS_API_NO_OWNER');
1317: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
1318: l_msg := fnd_message.get ;
1319: fnd_file.put_line(fnd_file.log,' ' || l_msg);
1320: x_return_status := FND_API.G_RET_STS_ERROR ;
1321: END IF;
1322: ELSE
1323: IF (l_resource_load_tbl.COUNT = 1) THEN
1324: l := l_resource_load_tbl.FIRST;

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

1334: END Assign_Owner;
1335:
1336: -- Added parameter p_inv_cat_id by pnkalari on 06/11/2002.
1337: PROCEDURE Calculate_Load
1338: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1339: p_incident_id IN NUMBER,
1340: p_incident_type_id IN NUMBER,
1341: p_incident_severity_id IN NUMBER,
1342: p_inv_item_id IN NUMBER,

Line 1507: x_return_status := FND_API.G_RET_STS_SUCCESS;

1503: WHERE resource_id = p_resource_id;
1504:
1505: BEGIN
1506: -- Initialize API return status to success
1507: x_return_status := FND_API.G_RET_STS_SUCCESS;
1508:
1509: l_incident_type_id := p_incident_type_id;
1510: l_incident_severity_id := p_incident_severity_id;
1511:

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

1664: ELSE
1665: l_time_lag := 0;
1666: END IF;
1667:
1668: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1669: FND_MESSAGE.Set_Name('CS', 'CS_TZ_API_ERR');
1670: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
1671: l_msg := fnd_message.get ;
1672: fnd_file.put_line(fnd_file.log,' ' || l_msg);

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

1672: fnd_file.put_line(fnd_file.log,' ' || l_msg);
1673: EXIT ;
1674: END IF;
1675:
1676: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1677: l_time_lag := abs(l_time_lag);
1678: ELSE
1679: l_time_lag := 0;
1680: END IF;

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

1723: -- resource with the max load.This is the winning resource to
1724: -- be returned
1725: -- If timezone API does not give error then proceed
1726:
1727: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1728: --i := 0;
1729: -- Added this because if all the resource loads are 0,
1730: -- l_max_record_index is always the first resource.
1731: l_max_record_index := p_res_load_table.FIRST;

Line 1767: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1763: x_resource_id := p_res_load_table(l_max_record_index).resource_id;
1764: x_resource_type := p_res_load_table(l_max_record_index).resource_type;
1765: x_territory_id := p_res_load_table(l_max_record_index).territory_id;
1766: IF (x_resource_id IS NOT NULL) THEN
1767: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1768: ELSIF(x_resource_id IS NULL) THEN
1769: x_return_status := FND_API.G_RET_STS_ERROR;
1770: END IF;
1771: ELSE -- x_return_status is success loop

Line 1769: x_return_status := FND_API.G_RET_STS_ERROR;

1765: x_territory_id := p_res_load_table(l_max_record_index).territory_id;
1766: IF (x_resource_id IS NOT NULL) THEN
1767: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1768: ELSIF(x_resource_id IS NULL) THEN
1769: x_return_status := FND_API.G_RET_STS_ERROR;
1770: END IF;
1771: ELSE -- x_return_status is success loop
1772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1773: END IF;

Line 1772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1768: ELSIF(x_resource_id IS NULL) THEN
1769: x_return_status := FND_API.G_RET_STS_ERROR;
1770: END IF;
1771: ELSE -- x_return_status is success loop
1772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1773: END IF;
1774:
1775: END Calculate_Load;
1776: