DBA Data[Home] [Help]

APPS.CSD_REFURBISH_IRO_GRP dependencies on FND_PROFILE

Line 576: FND_PROFILE.Get('CSD_IRO_DEFAULT_SR_TYPE',l_Inc_Type_Id);

572: Fnd_Log.String(Fnd_Log.Level_Statement,C_Module || '.SR_Record_Default_values',
573: 'Getting default values for SR record from profile options');
574: End If;
575: -- get SR Type Id value from profile, this is a required field if not set raise error message.
576: FND_PROFILE.Get('CSD_IRO_DEFAULT_SR_TYPE',l_Inc_Type_Id);
577: If ( l_inc_type_id Is NULL ) Then
578: Fnd_Message.Set_Name('CSD','CSD_SR_REC_TYPE_REQ_COL_NULL');
579: Fnd_Message.Set_Token('COLUMN_NAME',c_COl_SR_Type );
580: Fnd_Msg_Pub.Add;

Line 593: FND_PROFILE.Get('CSD_IRO_DEFAULT_SR_SEVERITY',l_Inc_Severity_Id);

589: Fnd_Log.String(Fnd_Log.Level_Statement,C_Module || '.SR_Type_Validation','SR TYpe id is :' || l_Inc_Type_Id ) ;
590: End If;
591: End If;
592:
593: FND_PROFILE.Get('CSD_IRO_DEFAULT_SR_SEVERITY',l_Inc_Severity_Id);
594: -- Check if SR Severity Id is NULL, If so raise error
595: If (l_inc_severity_id Is NULL) Then
596: Fnd_Message.Set_Name('CSD','CSD_SR_REC_TYPE_REQ_COL_NULL');
597: Fnd_Message.Set_Token('COLUMN_NAME',C_Col_SR_Severity );

Line 613: FND_PROFILE.Get('CSD_OM_DEFAULT_SR_URGENCY',l_Inc_Urgency_Id);

609: End If;
610: End If;
611:
612: -- DO not have to verify if value is null, as it is not a required column
613: FND_PROFILE.Get('CSD_OM_DEFAULT_SR_URGENCY',l_Inc_Urgency_Id);
614: --l_inc_work_summary := 'Internal Refurbish repair orders from internal sales orders for product : ' ;
615: -- Getting value from INC_DEFAULT_INCIDENT_OWNER since this profile is used to get value in UI
616: -- also CSD_OM_DEFAULT_SR_OWNER is incorrectly defined.
617: -- This is to fix bug 3395281 saupadhy

Line 618: --l_sr_owner_id := FND_PROFILE.value('CSD_OM_DEFAULT_SR_OWNER');

614: --l_inc_work_summary := 'Internal Refurbish repair orders from internal sales orders for product : ' ;
615: -- Getting value from INC_DEFAULT_INCIDENT_OWNER since this profile is used to get value in UI
616: -- also CSD_OM_DEFAULT_SR_OWNER is incorrectly defined.
617: -- This is to fix bug 3395281 saupadhy
618: --l_sr_owner_id := FND_PROFILE.value('CSD_OM_DEFAULT_SR_OWNER');
619: FND_PROFILE.Get('INC_DEFAULT_INCIDENT_OWNER',l_Sr_Owner_Id);
620: If Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level Then
621: Fnd_Log.String(Fnd_Log.Level_Statement,C_Module || '.SR_Owner_Id_value',
622: 'Default value for SR Owner Id is :' ||l_sr_owner_id );

Line 619: FND_PROFILE.Get('INC_DEFAULT_INCIDENT_OWNER',l_Sr_Owner_Id);

615: -- Getting value from INC_DEFAULT_INCIDENT_OWNER since this profile is used to get value in UI
616: -- also CSD_OM_DEFAULT_SR_OWNER is incorrectly defined.
617: -- This is to fix bug 3395281 saupadhy
618: --l_sr_owner_id := FND_PROFILE.value('CSD_OM_DEFAULT_SR_OWNER');
619: FND_PROFILE.Get('INC_DEFAULT_INCIDENT_OWNER',l_Sr_Owner_Id);
620: If Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level Then
621: Fnd_Log.String(Fnd_Log.Level_Statement,C_Module || '.SR_Owner_Id_value',
622: 'Default value for SR Owner Id is :' ||l_sr_owner_id );
623: End If;

Line 625: FND_PROFILE.GET('CSD_DEFAULT_REPAIR_ORG',l_Default_RO_Org_ID);

621: Fnd_Log.String(Fnd_Log.Level_Statement,C_Module || '.SR_Owner_Id_value',
622: 'Default value for SR Owner Id is :' ||l_sr_owner_id );
623: End If;
624: --Bug# 4000602 saupadhy DBI changes 11/05/2004
625: FND_PROFILE.GET('CSD_DEFAULT_REPAIR_ORG',l_Default_RO_Org_ID);
626:
627: FND_PROFILE.Get('CSD_IRO_REPAIR_TYPE',l_Repair_Type_Id);
628: --- Check if Default values for RO exist
629: If (l_Repair_Type_id Is Null) Then

Line 627: FND_PROFILE.Get('CSD_IRO_REPAIR_TYPE',l_Repair_Type_Id);

623: End If;
624: --Bug# 4000602 saupadhy DBI changes 11/05/2004
625: FND_PROFILE.GET('CSD_DEFAULT_REPAIR_ORG',l_Default_RO_Org_ID);
626:
627: FND_PROFILE.Get('CSD_IRO_REPAIR_TYPE',l_Repair_Type_Id);
628: --- Check if Default values for RO exist
629: If (l_Repair_Type_id Is Null) Then
630: Fnd_Message.Set_Name('CSD','CSD_RO_REC_TYPE_REQ_COL_NULL');
631: Fnd_Message.Set_Token('COLUMN_NAME',C_Col_Repair_Type );

Line 658: --l_inc_status_id := FND_PROFILE.value('CSD_OM_DEFAULT_SR_STATUS');

654: 'Seeded SR status was found and its value is :' ||l_inc_status_Id );
655: End If;
656: Exception
657: When No_Data_Found Then
658: --l_inc_status_id := FND_PROFILE.value('CSD_OM_DEFAULT_SR_STATUS');
659: FND_PROFILE.Get('CSD_OM_DEFAULT_SR_STATUS',l_Inc_Status_Id);
660: If Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level Then
661: Fnd_Log.String(Fnd_Log.Level_Statement,C_Module || '.SR_Status_Id_value',
662: 'Seeded SR status was not found, so getting value from profile option and its value is :' ||l_inc_status_Id );

Line 659: FND_PROFILE.Get('CSD_OM_DEFAULT_SR_STATUS',l_Inc_Status_Id);

655: End If;
656: Exception
657: When No_Data_Found Then
658: --l_inc_status_id := FND_PROFILE.value('CSD_OM_DEFAULT_SR_STATUS');
659: FND_PROFILE.Get('CSD_OM_DEFAULT_SR_STATUS',l_Inc_Status_Id);
660: If Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level Then
661: Fnd_Log.String(Fnd_Log.Level_Statement,C_Module || '.SR_Status_Id_value',
662: 'Seeded SR status was not found, so getting value from profile option and its value is :' ||l_inc_status_Id );
663: End If;