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.CSD_REFURBISH_IRO_GRP dependencies on FND_MESSAGE

Line 90: Fnd_Message.Set_Name('CSD', 'CSD_PARTY_SITE_NOT_FOUND');

86: Where hcas.cust_acct_site_id = hcsu.cust_acct_site_id
87: And hcsu.site_use_id = p_cust_site_use_id ;
88: Exception
89: When No_Data_found then
90: Fnd_Message.Set_Name('CSD', 'CSD_PARTY_SITE_NOT_FOUND');
91: Fnd_Message.Set_Token('CUST_ACCT_SITE_ID', p_cust_site_use_id);
92: Fnd_Msg_Pub.Add;
93: If Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level Then
94: Fnd_Log.String(Fnd_Log.Level_Statement,C_Module , ' Party site id not found for customer acct site use id ' || p_cust_site_use_id );

Line 91: Fnd_Message.Set_Token('CUST_ACCT_SITE_ID', p_cust_site_use_id);

87: And hcsu.site_use_id = p_cust_site_use_id ;
88: Exception
89: When No_Data_found then
90: Fnd_Message.Set_Name('CSD', 'CSD_PARTY_SITE_NOT_FOUND');
91: Fnd_Message.Set_Token('CUST_ACCT_SITE_ID', p_cust_site_use_id);
92: Fnd_Msg_Pub.Add;
93: If Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level Then
94: Fnd_Log.String(Fnd_Log.Level_Statement,C_Module , ' Party site id not found for customer acct site use id ' || p_cust_site_use_id );
95: End If;

Line 120: Fnd_Message.Set_Name('CSD','CSD_PARTY_SITE_USE_NOT_FOUND');

116: Fnd_Log.String(Fnd_Log.Level_Statement,C_Module , ' Party id is found for party site id ' || x_party_site_id );
117: End If;
118: Exception
119: When No_Data_found then
120: Fnd_Message.Set_Name('CSD','CSD_PARTY_SITE_USE_NOT_FOUND');
121: Fnd_Message.Set_Token('PARTY_SITE_ID',l_Party_Site_Id);
122: Fnd_Msg_Pub.Add;
123: If Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level Then
124: Fnd_Log.String(Fnd_Log.Level_Statement,C_Module , ' Party id is not found for party site id ' || x_party_site_id );

Line 121: Fnd_Message.Set_Token('PARTY_SITE_ID',l_Party_Site_Id);

117: End If;
118: Exception
119: When No_Data_found then
120: Fnd_Message.Set_Name('CSD','CSD_PARTY_SITE_USE_NOT_FOUND');
121: Fnd_Message.Set_Token('PARTY_SITE_ID',l_Party_Site_Id);
122: Fnd_Msg_Pub.Add;
123: If Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level Then
124: Fnd_Log.String(Fnd_Log.Level_Statement,C_Module , ' Party id is not found for party site id ' || x_party_site_id );
125: End If;

Line 128: Fnd_Message.Set_Name('CSD','CSD_TOO_MANY_PARTY_LOCATIONS');

124: Fnd_Log.String(Fnd_Log.Level_Statement,C_Module , ' Party id is not found for party site id ' || x_party_site_id );
125: End If;
126: Raise FND_API.G_EXC_ERROR ;
127: When Too_Many_Rows Then
128: Fnd_Message.Set_Name('CSD','CSD_TOO_MANY_PARTY_LOCATIONS');
129: Fnd_Message.Set_Token('PARTY_SITE_ID',l_Party_Site_Id);
130: Fnd_Message.Set_Token('SITE_USE_TYPE',p_Site_Use_Type);
131: Fnd_Msg_Pub.Add;
132: If Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level Then

Line 129: Fnd_Message.Set_Token('PARTY_SITE_ID',l_Party_Site_Id);

125: End If;
126: Raise FND_API.G_EXC_ERROR ;
127: When Too_Many_Rows Then
128: Fnd_Message.Set_Name('CSD','CSD_TOO_MANY_PARTY_LOCATIONS');
129: Fnd_Message.Set_Token('PARTY_SITE_ID',l_Party_Site_Id);
130: Fnd_Message.Set_Token('SITE_USE_TYPE',p_Site_Use_Type);
131: Fnd_Msg_Pub.Add;
132: If Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level Then
133: Fnd_Log.String(Fnd_Log.Level_Statement,C_Module , ' Too many Party site use id are found for party site id ' || x_party_site_id );

Line 130: Fnd_Message.Set_Token('SITE_USE_TYPE',p_Site_Use_Type);

126: Raise FND_API.G_EXC_ERROR ;
127: When Too_Many_Rows Then
128: Fnd_Message.Set_Name('CSD','CSD_TOO_MANY_PARTY_LOCATIONS');
129: Fnd_Message.Set_Token('PARTY_SITE_ID',l_Party_Site_Id);
130: Fnd_Message.Set_Token('SITE_USE_TYPE',p_Site_Use_Type);
131: Fnd_Msg_Pub.Add;
132: If Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level Then
133: Fnd_Log.String(Fnd_Log.Level_Statement,C_Module , ' Too many Party site use id are found for party site id ' || x_party_site_id );
134: End If;

Line 543: Fnd_Message.Set_Name('CSD','CSD_IR1_AND_IR2_SAME');

539: 'Checking if parameters Req_Header_Id_In and Req_Header_Id_Out has same value');
540: End If;
541: -- Check if IR1 and IR2 are same
542: If p_Req_Header_Id_In = P_Req_header_id_Out Then
543: Fnd_Message.Set_Name('CSD','CSD_IR1_AND_IR2_SAME');
544: Fnd_Message.Set_Token('Req_Header_Id',p_Req_Header_Id_In);
545: Fnd_Msg_Pub.Add;
546: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then
547: Fnd_Log.String(Fnd_Log.Level_Procedure,C_Module || '.Val_IR1_and_IR2_are_same',

Line 544: Fnd_Message.Set_Token('Req_Header_Id',p_Req_Header_Id_In);

540: End If;
541: -- Check if IR1 and IR2 are same
542: If p_Req_Header_Id_In = P_Req_header_id_Out Then
543: Fnd_Message.Set_Name('CSD','CSD_IR1_AND_IR2_SAME');
544: Fnd_Message.Set_Token('Req_Header_Id',p_Req_Header_Id_In);
545: Fnd_Msg_Pub.Add;
546: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then
547: Fnd_Log.String(Fnd_Log.Level_Procedure,C_Module || '.Val_IR1_and_IR2_are_same',
548: 'Input parameters Req_Header_Id_In and Req_Header_Id_Out has same value');

Line 560: Fnd_Message.Set_Name('CSD','CSD_IO1_AND_IO2_SAME');

556: 'Checking if parameters ISO_Header_Id_In and ISO_Header_Id_Out has same value');
557: End If;
558: -- Check if IO1 and IO2 are same.
559: If P_ISO_header_id_in = P_ISO_header_id_Out Then
560: Fnd_Message.Set_Name('CSD','CSD_IO1_AND_IO2_SAME');
561: Fnd_Message.Set_Token('Order_Header_Id',p_ISO_Header_Id_In);
562: Fnd_Msg_Pub.Add;
563: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then
564: Fnd_Log.String(Fnd_Log.Level_Procedure,C_Module || '.Val_IO1_and_IO2_are_same',

Line 561: Fnd_Message.Set_Token('Order_Header_Id',p_ISO_Header_Id_In);

557: End If;
558: -- Check if IO1 and IO2 are same.
559: If P_ISO_header_id_in = P_ISO_header_id_Out Then
560: Fnd_Message.Set_Name('CSD','CSD_IO1_AND_IO2_SAME');
561: Fnd_Message.Set_Token('Order_Header_Id',p_ISO_Header_Id_In);
562: Fnd_Msg_Pub.Add;
563: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then
564: Fnd_Log.String(Fnd_Log.Level_Procedure,C_Module || '.Val_IO1_and_IO2_are_same',
565: 'Input parameters ISO_Header_Id_In and ISO_Header_Id_Out has same value');

Line 578: Fnd_Message.Set_Name('CSD','CSD_SR_REC_TYPE_REQ_COL_NULL');

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;
581: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then
582: Fnd_Log.String(Fnd_Log.Level_Procedure,C_Module || '.SR_Type_Validation','SR Type is Null') ;

Line 579: Fnd_Message.Set_Token('COLUMN_NAME',c_COl_SR_Type );

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;
581: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then
582: Fnd_Log.String(Fnd_Log.Level_Procedure,C_Module || '.SR_Type_Validation','SR Type is Null') ;
583: End If;

Line 596: Fnd_Message.Set_Name('CSD','CSD_SR_REC_TYPE_REQ_COL_NULL');

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 );
598: Fnd_Msg_Pub.Add;
599: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then
600: Fnd_Log.String(Fnd_Log.Level_Procedure,C_Module || '.SR_Severity_Validation','SR Severity is null' ) ;

Line 597: Fnd_Message.Set_Token('COLUMN_NAME',C_Col_SR_Severity );

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 );
598: Fnd_Msg_Pub.Add;
599: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then
600: Fnd_Log.String(Fnd_Log.Level_Procedure,C_Module || '.SR_Severity_Validation','SR Severity is null' ) ;
601: End If;

Line 630: Fnd_Message.Set_Name('CSD','CSD_RO_REC_TYPE_REQ_COL_NULL');

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 );
632: Fnd_Msg_Pub.Add;
633: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then
634: Fnd_Log.String(Fnd_Log.Level_Procedure,C_Module || '.Repair_Type_Validation','Repair Type is Null' ) ;

Line 631: Fnd_Message.Set_Token('COLUMN_NAME',C_Col_Repair_Type );

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 );
632: Fnd_Msg_Pub.Add;
633: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then
634: Fnd_Log.String(Fnd_Log.Level_Procedure,C_Module || '.Repair_Type_Validation','Repair Type is Null' ) ;
635: End If;

Line 667: Fnd_Message.Set_Name('CSD','CSD_SR_REC_TYPE_REQ_COL_NULL');

663: End If;
664: End;
665: --- Check if any of the defaulted values for required columns of SR Record type has null value.
666: If (l_inc_status_Id Is NULL ) Then
667: Fnd_Message.Set_Name('CSD','CSD_SR_REC_TYPE_REQ_COL_NULL');
668: Fnd_Message.Set_Token('COLUMN_NAME',C_Col_SR_Status );
669: Fnd_Msg_Pub.Add;
670: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then
671: Fnd_Log.String(Fnd_Log.Level_Procedure,C_Module || '.SR_Status_Validation','SR Status is NULL' ) ;

Line 668: Fnd_Message.Set_Token('COLUMN_NAME',C_Col_SR_Status );

664: End;
665: --- Check if any of the defaulted values for required columns of SR Record type has null value.
666: If (l_inc_status_Id Is NULL ) Then
667: Fnd_Message.Set_Name('CSD','CSD_SR_REC_TYPE_REQ_COL_NULL');
668: Fnd_Message.Set_Token('COLUMN_NAME',C_Col_SR_Status );
669: Fnd_Msg_Pub.Add;
670: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then
671: Fnd_Log.String(Fnd_Log.Level_Procedure,C_Module || '.SR_Status_Validation','SR Status is NULL' ) ;
672: End If;

Line 696: Fnd_Message.Set_Name('CSD','CSD_REPAIR_MODE_IS_NULL');

692: from csd_repair_types_vl
693: where repair_type_id = l_Repair_Type_Id ;
694: -- Check if Repair Mode is Null If Repair Mode is null then raise exception
695: If l_Repair_Mode Is Null Then
696: Fnd_Message.Set_Name('CSD','CSD_REPAIR_MODE_IS_NULL');
697: Fnd_Message.Set_Token('REPAIR_TYPE',l_Repair_Type_Name );
698: Fnd_Msg_Pub.Add;
699: If Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level Then
700: Fnd_Log.String(Fnd_Log.Level_Statement,C_Module || '.Repair_Type_Validation','Repair Mode is Null for repair type :' || l_Repair_Type_Name);

Line 697: Fnd_Message.Set_Token('REPAIR_TYPE',l_Repair_Type_Name );

693: where repair_type_id = l_Repair_Type_Id ;
694: -- Check if Repair Mode is Null If Repair Mode is null then raise exception
695: If l_Repair_Mode Is Null Then
696: Fnd_Message.Set_Name('CSD','CSD_REPAIR_MODE_IS_NULL');
697: Fnd_Message.Set_Token('REPAIR_TYPE',l_Repair_Type_Name );
698: Fnd_Msg_Pub.Add;
699: If Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level Then
700: Fnd_Log.String(Fnd_Log.Level_Statement,C_Module || '.Repair_Type_Validation','Repair Mode is Null for repair type :' || l_Repair_Type_Name);
701: End If;

Line 707: Fnd_Message.Set_Name('CSD','CSD_INVALID_REPAIR_TYPE');

703: Raise FND_API.G_EXC_ERROR ;
704: End If;
705: Exception
706: When No_Data_FOund Then
707: Fnd_Message.Set_Name('CSD','CSD_INVALID_REPAIR_TYPE');
708: Fnd_Msg_Pub.Add;
709: If Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level Then
710: Fnd_Log.String(Fnd_Log.Level_Statement,C_Module || '.Repair_Type_Validation','Repair Type Id is invalid');
711: End If;

Line 724: Fnd_Message.Set_Name('CSD','CSD_IR_IO_REC_NOT_FOUND');

720: Open Get_SRandRO_from_IRandISO_In(p_ISO_Header_Id_in , p_Req_Header_Id_IN ) ;
721: Fetch Get_SRandRO_from_IRandISO_In Into l_IRandISO_In_Rec ;
722: If Get_SRandRO_from_IRandISO_In%ROWCOUNT = 0 Then
723: --- Raise Exception and stop processing
724: Fnd_Message.Set_Name('CSD','CSD_IR_IO_REC_NOT_FOUND');
725: Fnd_Message.Set_Token('REQ_HDR_ID', p_Req_Header_Id_IN);
726: Fnd_Message.Set_Token('SO_HDR_ID', P_ISO_header_id_in);
727: Fnd_Msg_Pub.Add;
728: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then

Line 725: Fnd_Message.Set_Token('REQ_HDR_ID', p_Req_Header_Id_IN);

721: Fetch Get_SRandRO_from_IRandISO_In Into l_IRandISO_In_Rec ;
722: If Get_SRandRO_from_IRandISO_In%ROWCOUNT = 0 Then
723: --- Raise Exception and stop processing
724: Fnd_Message.Set_Name('CSD','CSD_IR_IO_REC_NOT_FOUND');
725: Fnd_Message.Set_Token('REQ_HDR_ID', p_Req_Header_Id_IN);
726: Fnd_Message.Set_Token('SO_HDR_ID', P_ISO_header_id_in);
727: Fnd_Msg_Pub.Add;
728: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then
729: Fnd_Log.String(Fnd_Log.Level_Procedure,C_Module || '.Records_Validation','no records are found for move in') ;

Line 726: Fnd_Message.Set_Token('SO_HDR_ID', P_ISO_header_id_in);

722: If Get_SRandRO_from_IRandISO_In%ROWCOUNT = 0 Then
723: --- Raise Exception and stop processing
724: Fnd_Message.Set_Name('CSD','CSD_IR_IO_REC_NOT_FOUND');
725: Fnd_Message.Set_Token('REQ_HDR_ID', p_Req_Header_Id_IN);
726: Fnd_Message.Set_Token('SO_HDR_ID', P_ISO_header_id_in);
727: Fnd_Msg_Pub.Add;
728: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then
729: Fnd_Log.String(Fnd_Log.Level_Procedure,C_Module || '.Records_Validation','no records are found for move in') ;
730: End If;

Line 737: Fnd_Message.Set_Name('CSD','CSD_IR_IO_MANY_REC_FOUND');

733: Elsif Get_SRandRO_from_IRandISO_In%ROWCOUNT > 1 Then
734: --- Check if more then one records(IO1/IR1) are found in the cursor result set
735: --- if so stop processing and raise error
736: --- Raise Exception and stop processing
737: Fnd_Message.Set_Name('CSD','CSD_IR_IO_MANY_REC_FOUND');
738: Fnd_Message.Set_Token('REQ_HDR_ID', p_Req_Header_Id_IN);
739: Fnd_Message.Set_Token('SO_HDR_ID', P_ISO_header_id_in);
740: Fnd_Msg_Pub.Add;
741: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then

Line 738: Fnd_Message.Set_Token('REQ_HDR_ID', p_Req_Header_Id_IN);

734: --- Check if more then one records(IO1/IR1) are found in the cursor result set
735: --- if so stop processing and raise error
736: --- Raise Exception and stop processing
737: Fnd_Message.Set_Name('CSD','CSD_IR_IO_MANY_REC_FOUND');
738: Fnd_Message.Set_Token('REQ_HDR_ID', p_Req_Header_Id_IN);
739: Fnd_Message.Set_Token('SO_HDR_ID', P_ISO_header_id_in);
740: Fnd_Msg_Pub.Add;
741: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then
742: Fnd_Log.String(Fnd_Log.Level_Procedure,C_Module || '.Records_Validation','too many move in records are found' ) ;

Line 739: Fnd_Message.Set_Token('SO_HDR_ID', P_ISO_header_id_in);

735: --- if so stop processing and raise error
736: --- Raise Exception and stop processing
737: Fnd_Message.Set_Name('CSD','CSD_IR_IO_MANY_REC_FOUND');
738: Fnd_Message.Set_Token('REQ_HDR_ID', p_Req_Header_Id_IN);
739: Fnd_Message.Set_Token('SO_HDR_ID', P_ISO_header_id_in);
740: Fnd_Msg_Pub.Add;
741: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then
742: Fnd_Log.String(Fnd_Log.Level_Procedure,C_Module || '.Records_Validation','too many move in records are found' ) ;
743: End If;

Line 747: Fnd_Message.Set_Name('CSD','CSD_SR_WORK_SUMMARY');

743: End If;
744: Raise FND_API.G_EXC_ERROR ;
745: End If;
746: -- Get SR Work Summary information from message dictionary
747: Fnd_Message.Set_Name('CSD','CSD_SR_WORK_SUMMARY');
748: Fnd_Message.Set_Token('PRODUCT', l_IRandISO_In_Rec.Concatenated_Segments || ' ');
749: l_Inc_Work_Summary := Fnd_Message.Get;
750: -- Check if Move_In item is serial controlled or not
751: If l_IRandISO_In_Rec.Serial_Number_Control_code = 1 Then

Line 748: Fnd_Message.Set_Token('PRODUCT', l_IRandISO_In_Rec.Concatenated_Segments || ' ');

744: Raise FND_API.G_EXC_ERROR ;
745: End If;
746: -- Get SR Work Summary information from message dictionary
747: Fnd_Message.Set_Name('CSD','CSD_SR_WORK_SUMMARY');
748: Fnd_Message.Set_Token('PRODUCT', l_IRandISO_In_Rec.Concatenated_Segments || ' ');
749: l_Inc_Work_Summary := Fnd_Message.Get;
750: -- Check if Move_In item is serial controlled or not
751: If l_IRandISO_In_Rec.Serial_Number_Control_code = 1 Then
752: l_IS_Move_In_Item_Serialized := 'N';

Line 749: l_Inc_Work_Summary := Fnd_Message.Get;

745: End If;
746: -- Get SR Work Summary information from message dictionary
747: Fnd_Message.Set_Name('CSD','CSD_SR_WORK_SUMMARY');
748: Fnd_Message.Set_Token('PRODUCT', l_IRandISO_In_Rec.Concatenated_Segments || ' ');
749: l_Inc_Work_Summary := Fnd_Message.Get;
750: -- Check if Move_In item is serial controlled or not
751: If l_IRandISO_In_Rec.Serial_Number_Control_code = 1 Then
752: l_IS_Move_In_Item_Serialized := 'N';
753: Else

Line 764: Fnd_Message.Set_Name('CSD','CSD_IR_IO_REC_NOT_FOUND');

760: Open Get_PrdTxn_from_IRandISO_Out(p_ISO_Header_Id_Out , p_Req_Header_Id_Out ) ;
761: Fetch Get_PrdTxn_from_IRandISO_Out Into l_IRandISO_Out_Rec ;
762: If Get_PrdTxn_from_IRandISO_Out %ROWCOUNT = 0 Then
763: --- Raise Exception and stop processing
764: Fnd_Message.Set_Name('CSD','CSD_IR_IO_REC_NOT_FOUND');
765: Fnd_Message.Set_Token('REQ_HDR_ID',p_Req_Header_Id_Out);
766: Fnd_Message.Set_Token('SO_HDR_ID',p_ISO_Header_Id_Out);
767: Fnd_Msg_Pub.Add;
768: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then

Line 765: Fnd_Message.Set_Token('REQ_HDR_ID',p_Req_Header_Id_Out);

761: Fetch Get_PrdTxn_from_IRandISO_Out Into l_IRandISO_Out_Rec ;
762: If Get_PrdTxn_from_IRandISO_Out %ROWCOUNT = 0 Then
763: --- Raise Exception and stop processing
764: Fnd_Message.Set_Name('CSD','CSD_IR_IO_REC_NOT_FOUND');
765: Fnd_Message.Set_Token('REQ_HDR_ID',p_Req_Header_Id_Out);
766: Fnd_Message.Set_Token('SO_HDR_ID',p_ISO_Header_Id_Out);
767: Fnd_Msg_Pub.Add;
768: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then
769: Fnd_Log.String(Fnd_Log.Level_Procedure, C_Module || '.Records_Validation','No move out records are found' ) ;

Line 766: Fnd_Message.Set_Token('SO_HDR_ID',p_ISO_Header_Id_Out);

762: If Get_PrdTxn_from_IRandISO_Out %ROWCOUNT = 0 Then
763: --- Raise Exception and stop processing
764: Fnd_Message.Set_Name('CSD','CSD_IR_IO_REC_NOT_FOUND');
765: Fnd_Message.Set_Token('REQ_HDR_ID',p_Req_Header_Id_Out);
766: Fnd_Message.Set_Token('SO_HDR_ID',p_ISO_Header_Id_Out);
767: Fnd_Msg_Pub.Add;
768: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then
769: Fnd_Log.String(Fnd_Log.Level_Procedure, C_Module || '.Records_Validation','No move out records are found' ) ;
770: End If;

Line 777: Fnd_Message.Set_Name('CSD','CSD_IR_IO_MANY_REC_FOUND');

773: Elsif Get_PrdTxn_from_IRandISO_Out%ROWCOUNT > 1 Then
774: --- Check if more then one records(IO2/IR2) are found in the cursor result set
775: --- if so stop processing and raise error
776: --- Raise Exception and stop processing
777: Fnd_Message.Set_Name('CSD','CSD_IR_IO_MANY_REC_FOUND');
778: Fnd_Message.Set_Token('REQ_HDR_ID', p_Req_Header_Id_Out);
779: Fnd_Message.Set_Token('SO_HDR_ID', p_ISO_Header_Id_Out);
780: Fnd_Msg_Pub.Add;
781: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then

Line 778: Fnd_Message.Set_Token('REQ_HDR_ID', p_Req_Header_Id_Out);

774: --- Check if more then one records(IO2/IR2) are found in the cursor result set
775: --- if so stop processing and raise error
776: --- Raise Exception and stop processing
777: Fnd_Message.Set_Name('CSD','CSD_IR_IO_MANY_REC_FOUND');
778: Fnd_Message.Set_Token('REQ_HDR_ID', p_Req_Header_Id_Out);
779: Fnd_Message.Set_Token('SO_HDR_ID', p_ISO_Header_Id_Out);
780: Fnd_Msg_Pub.Add;
781: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then
782: Fnd_Log.String(Fnd_Log.Level_Procedure,C_Module || '.Records_Validation','Too many move out records are found' ) ;

Line 779: Fnd_Message.Set_Token('SO_HDR_ID', p_ISO_Header_Id_Out);

775: --- if so stop processing and raise error
776: --- Raise Exception and stop processing
777: Fnd_Message.Set_Name('CSD','CSD_IR_IO_MANY_REC_FOUND');
778: Fnd_Message.Set_Token('REQ_HDR_ID', p_Req_Header_Id_Out);
779: Fnd_Message.Set_Token('SO_HDR_ID', p_ISO_Header_Id_Out);
780: Fnd_Msg_Pub.Add;
781: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then
782: Fnd_Log.String(Fnd_Log.Level_Procedure,C_Module || '.Records_Validation','Too many move out records are found' ) ;
783: End If;

Line 799: Fnd_Message.Set_Name('CSD','CSD_SR_NUM_ATTR_DIFFER');

795: If l_IS_Move_In_Item_Serialized <> l_IS_Move_Out_Item_Serialized Then
796: --- Raise Exception and stop processing
797: l_Item_In := l_IRandISO_In_Rec.Concatenated_Segments ;
798: l_Item_Out := l_IRandISO_Out_Rec.Concatenated_Segments ;
799: Fnd_Message.Set_Name('CSD','CSD_SR_NUM_ATTR_DIFFER');
800: Fnd_Message.Set_Token('ITEM_IN', l_Item_in);
801: Fnd_Message.Set_Token('ITEM_OUT', l_Item_Out);
802: Fnd_Msg_Pub.Add;
803: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then

Line 800: Fnd_Message.Set_Token('ITEM_IN', l_Item_in);

796: --- Raise Exception and stop processing
797: l_Item_In := l_IRandISO_In_Rec.Concatenated_Segments ;
798: l_Item_Out := l_IRandISO_Out_Rec.Concatenated_Segments ;
799: Fnd_Message.Set_Name('CSD','CSD_SR_NUM_ATTR_DIFFER');
800: Fnd_Message.Set_Token('ITEM_IN', l_Item_in);
801: Fnd_Message.Set_Token('ITEM_OUT', l_Item_Out);
802: Fnd_Msg_Pub.Add;
803: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then
804: Fnd_Log.String(Fnd_Log.Level_Procedure,C_Module || '.Serial_Control_Validation','Serial number attributes are different for items on IO1 and IO2 lines' ) ;

Line 801: Fnd_Message.Set_Token('ITEM_OUT', l_Item_Out);

797: l_Item_In := l_IRandISO_In_Rec.Concatenated_Segments ;
798: l_Item_Out := l_IRandISO_Out_Rec.Concatenated_Segments ;
799: Fnd_Message.Set_Name('CSD','CSD_SR_NUM_ATTR_DIFFER');
800: Fnd_Message.Set_Token('ITEM_IN', l_Item_in);
801: Fnd_Message.Set_Token('ITEM_OUT', l_Item_Out);
802: Fnd_Msg_Pub.Add;
803: If Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level Then
804: Fnd_Log.String(Fnd_Log.Level_Procedure,C_Module || '.Serial_Control_Validation','Serial number attributes are different for items on IO1 and IO2 lines' ) ;
805: End If;