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_REPAIR_HISTORY_PVT dependencies on FND_MESSAGE

Line 94: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');

90: IF FND_GLOBAL.User_Id IS NULL
91: THEN
92: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
93: THEN
94: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
95: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
96: FND_MSG_PUB.ADD;
97: END IF;
98: RAISE FND_API.G_EXC_ERROR;

Line 95: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

91: THEN
92: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
93: THEN
94: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
95: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
96: FND_MSG_PUB.ADD;
97: END IF;
98: RAISE FND_API.G_EXC_ERROR;
99: END IF;

Line 534: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_UPDATE_TARGET');

530:
531: If ( C_Get_repair_history%NOTFOUND) Then
532: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
533: THEN
534: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_UPDATE_TARGET');
535: FND_MESSAGE.Set_Token ('INFO', 'repair_history', FALSE);
536: FND_MSG_PUB.Add;
537: END IF;
538: raise FND_API.G_EXC_ERROR;

Line 535: FND_MESSAGE.Set_Token ('INFO', 'repair_history', FALSE);

531: If ( C_Get_repair_history%NOTFOUND) Then
532: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
533: THEN
534: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_UPDATE_TARGET');
535: FND_MESSAGE.Set_Token ('INFO', 'repair_history', FALSE);
536: FND_MSG_PUB.Add;
537: END IF;
538: raise FND_API.G_EXC_ERROR;
539: END IF;

Line 550: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_ID');

546: If (l_tar_REPH_rec.last_update_date is NULL or
547: l_tar_REPH_rec.last_update_date = FND_API.G_MISS_Date ) Then
548: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
549: THEN
550: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_ID');
551: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
552: FND_MSG_PUB.ADD;
553: END IF;
554: raise FND_API.G_EXC_ERROR;

Line 551: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

547: l_tar_REPH_rec.last_update_date = FND_API.G_MISS_Date ) Then
548: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
549: THEN
550: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_ID');
551: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
552: FND_MSG_PUB.ADD;
553: END IF;
554: raise FND_API.G_EXC_ERROR;
555: End if;

Line 560: FND_MESSAGE.Set_Name('CSD', 'API_RECORD_CHANGED');

556: -- Check Whether record has been changed by someone else
557: If (l_tar_REPH_rec.last_update_date <> l_ref_REPH_rec.last_update_date) Then
558: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
559: THEN
560: FND_MESSAGE.Set_Name('CSD', 'API_RECORD_CHANGED');
561: FND_MESSAGE.Set_Token('INFO', 'repair_history', FALSE);
562: FND_MSG_PUB.ADD;
563: END IF;
564: raise FND_API.G_EXC_ERROR;

Line 561: FND_MESSAGE.Set_Token('INFO', 'repair_history', FALSE);

557: If (l_tar_REPH_rec.last_update_date <> l_ref_REPH_rec.last_update_date) Then
558: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
559: THEN
560: FND_MESSAGE.Set_Name('CSD', 'API_RECORD_CHANGED');
561: FND_MESSAGE.Set_Token('INFO', 'repair_history', FALSE);
562: FND_MSG_PUB.ADD;
563: END IF;
564: raise FND_API.G_EXC_ERROR;
565: End if;

Line 3968: a repair history row, and then construct the appropriate text using fnd_messages,

3964: END Validate_repair_history;
3965:
3966: /*
3967: This function will start with a basic sql query that will get the details of
3968: a repair history row, and then construct the appropriate text using fnd_messages,
3969: the repair history event code, and the parameters stored in the repair history table.
3970: */
3971: FUNCTION GET_HISTORY_DETAIL(p_repair_history_id IN NUMBER)
3972: RETURN VARCHAR2

Line 4152: fnd_message.set_name('CSD','CSD_ATTACHMENTS_COPIED');

4148: if (l_ref_REPH_rec.event_code = 'SLT') then
4149: -- standard naming in fnd_new_messages for Attachments message
4150: --ATTACHMENTS_PARAMC2 based on paramc2 value:'Y' => 'Attachments Copied
4151: --'else 'Attachments Not Copied'
4152: fnd_message.set_name('CSD','CSD_ATTACHMENTS_COPIED');
4153: l_attachments_copied := FND_MESSAGE.GET;
4154: fnd_message.set_name('CSD','CSD_ATTACHMENTS_NOT_COPIED');
4155: l_attachments_not_copied := FND_MESSAGE.GET;
4156: end if;

Line 4153: l_attachments_copied := FND_MESSAGE.GET;

4149: -- standard naming in fnd_new_messages for Attachments message
4150: --ATTACHMENTS_PARAMC2 based on paramc2 value:'Y' => 'Attachments Copied
4151: --'else 'Attachments Not Copied'
4152: fnd_message.set_name('CSD','CSD_ATTACHMENTS_COPIED');
4153: l_attachments_copied := FND_MESSAGE.GET;
4154: fnd_message.set_name('CSD','CSD_ATTACHMENTS_NOT_COPIED');
4155: l_attachments_not_copied := FND_MESSAGE.GET;
4156: end if;
4157:

Line 4154: fnd_message.set_name('CSD','CSD_ATTACHMENTS_NOT_COPIED');

4150: --ATTACHMENTS_PARAMC2 based on paramc2 value:'Y' => 'Attachments Copied
4151: --'else 'Attachments Not Copied'
4152: fnd_message.set_name('CSD','CSD_ATTACHMENTS_COPIED');
4153: l_attachments_copied := FND_MESSAGE.GET;
4154: fnd_message.set_name('CSD','CSD_ATTACHMENTS_NOT_COPIED');
4155: l_attachments_not_copied := FND_MESSAGE.GET;
4156: end if;
4157:
4158:

Line 4155: l_attachments_not_copied := FND_MESSAGE.GET;

4151: --'else 'Attachments Not Copied'
4152: fnd_message.set_name('CSD','CSD_ATTACHMENTS_COPIED');
4153: l_attachments_copied := FND_MESSAGE.GET;
4154: fnd_message.set_name('CSD','CSD_ATTACHMENTS_NOT_COPIED');
4155: l_attachments_not_copied := FND_MESSAGE.GET;
4156: end if;
4157:
4158:
4159: -- standard naming in fnd_new_messages for activity details

Line 4160: fnd_message.set_name('CSD','CSD_ACTIVITY_DETAIL_' || l_ref_REPH_rec.EVENT_CODE);

4156: end if;
4157:
4158:
4159: -- standard naming in fnd_new_messages for activity details
4160: fnd_message.set_name('CSD','CSD_ACTIVITY_DETAIL_' || l_ref_REPH_rec.EVENT_CODE);
4161:
4162: -- set the tokens for each respective event --
4163:
4164: --RMA Received

Line 4166: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

4162: -- set the tokens for each respective event --
4163:
4164: --RMA Received
4165: if (l_ref_REPH_rec.event_code = 'RR') then
4166: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4167: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4168: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4169: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4170: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name);

Line 4167: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );

4163:
4164: --RMA Received
4165: if (l_ref_REPH_rec.event_code = 'RR') then
4166: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4167: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4168: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4169: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4170: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name);
4171: --Repair Job Completed

Line 4168: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

4164: --RMA Received
4165: if (l_ref_REPH_rec.event_code = 'RR') then
4166: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4167: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4168: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4169: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4170: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name);
4171: --Repair Job Completed
4172: elsif (l_ref_REPH_rec.event_code = 'JC') then

Line 4169: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );

4165: if (l_ref_REPH_rec.event_code = 'RR') then
4166: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4167: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4168: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4169: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4170: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name);
4171: --Repair Job Completed
4172: elsif (l_ref_REPH_rec.event_code = 'JC') then
4173: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

Line 4170: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name);

4166: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4167: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4168: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4169: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4170: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name);
4171: --Repair Job Completed
4172: elsif (l_ref_REPH_rec.event_code = 'JC') then
4173: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4174: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

Line 4173: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

4169: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4170: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name);
4171: --Repair Job Completed
4172: elsif (l_ref_REPH_rec.event_code = 'JC') then
4173: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4174: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4175: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4176:
4177: --Only show PARAMN5 if PARAMN6 > 1

Line 4174: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

4170: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name);
4171: --Repair Job Completed
4172: elsif (l_ref_REPH_rec.event_code = 'JC') then
4173: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4174: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4175: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4176:
4177: --Only show PARAMN5 if PARAMN6 > 1
4178: if (l_ref_REPH_rec.PARAMN6 > 1) then

Line 4175: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );

4171: --Repair Job Completed
4172: elsif (l_ref_REPH_rec.event_code = 'JC') then
4173: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4174: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4175: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4176:
4177: --Only show PARAMN5 if PARAMN6 > 1
4178: if (l_ref_REPH_rec.PARAMN6 > 1) then
4179: FND_MESSAGE.SET_TOKEN('QTY_PARAMN5_6' , l_ref_REPH_rec.PARAMN5 );

Line 4179: FND_MESSAGE.SET_TOKEN('QTY_PARAMN5_6' , l_ref_REPH_rec.PARAMN5 );

4175: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4176:
4177: --Only show PARAMN5 if PARAMN6 > 1
4178: if (l_ref_REPH_rec.PARAMN6 > 1) then
4179: FND_MESSAGE.SET_TOKEN('QTY_PARAMN5_6' , l_ref_REPH_rec.PARAMN5 );
4180: else
4181: FND_MESSAGE.SET_TOKEN('QTY_PARAMN5_6' , l_ref_REPH_rec.PARAMN6 );
4182: end if;
4183:

Line 4181: FND_MESSAGE.SET_TOKEN('QTY_PARAMN5_6' , l_ref_REPH_rec.PARAMN6 );

4177: --Only show PARAMN5 if PARAMN6 > 1
4178: if (l_ref_REPH_rec.PARAMN6 > 1) then
4179: FND_MESSAGE.SET_TOKEN('QTY_PARAMN5_6' , l_ref_REPH_rec.PARAMN5 );
4180: else
4181: FND_MESSAGE.SET_TOKEN('QTY_PARAMN5_6' , l_ref_REPH_rec.PARAMN6 );
4182: end if;
4183:
4184: --Shipment
4185: elsif (l_ref_REPH_rec.event_code = 'PS') then

Line 4186: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

4182: end if;
4183:
4184: --Shipment
4185: elsif (l_ref_REPH_rec.event_code = 'PS') then
4186: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4187: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4188: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4189: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4190: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );

Line 4187: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );

4183:
4184: --Shipment
4185: elsif (l_ref_REPH_rec.event_code = 'PS') then
4186: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4187: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4188: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4189: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4190: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4191: --Status Changed

Line 4188: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );

4184: --Shipment
4185: elsif (l_ref_REPH_rec.event_code = 'PS') then
4186: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4187: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4188: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4189: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4190: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4191: --Status Changed
4192: elsif (l_ref_REPH_rec.event_code = 'SC') then

Line 4189: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );

4185: elsif (l_ref_REPH_rec.event_code = 'PS') then
4186: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4187: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4188: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4189: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4190: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4191: --Status Changed
4192: elsif (l_ref_REPH_rec.event_code = 'SC') then
4193:

Line 4190: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );

4186: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4187: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4188: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4189: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4190: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4191: --Status Changed
4192: elsif (l_ref_REPH_rec.event_code = 'SC') then
4193:
4194: --get flow status meaning

Line 4198: FND_MESSAGE.SET_TOKEN('OLD_STATUS_PARAMC2' , l_status_meaning );

4194: --get flow status meaning
4195: Open c_get_status_meaning(l_ref_REPH_rec.PARAMC2, 'CSD_REPAIR_FLOW_STATUS' );
4196: FETCH c_get_status_meaning into l_status_meaning;
4197: Close c_get_status_meaning;
4198: FND_MESSAGE.SET_TOKEN('OLD_STATUS_PARAMC2' , l_status_meaning );
4199:
4200: --get flow status meaning
4201: Open c_get_status_meaning(l_ref_REPH_rec.PARAMC1, 'CSD_REPAIR_FLOW_STATUS');
4202: FETCH c_get_status_meaning into l_status_meaning;

Line 4204: FND_MESSAGE.SET_TOKEN('NEW_STATUS_PARAMC1' , l_status_meaning );

4200: --get flow status meaning
4201: Open c_get_status_meaning(l_ref_REPH_rec.PARAMC1, 'CSD_REPAIR_FLOW_STATUS');
4202: FETCH c_get_status_meaning into l_status_meaning;
4203: Close c_get_status_meaning;
4204: FND_MESSAGE.SET_TOKEN('NEW_STATUS_PARAMC1' , l_status_meaning );
4205:
4206: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4207: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4208: --WIP Job Created

Line 4206: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );

4202: FETCH c_get_status_meaning into l_status_meaning;
4203: Close c_get_status_meaning;
4204: FND_MESSAGE.SET_TOKEN('NEW_STATUS_PARAMC1' , l_status_meaning );
4205:
4206: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4207: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4208: --WIP Job Created
4209: elsif (l_ref_REPH_rec.event_code = 'JS') then
4210: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

Line 4207: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );

4203: Close c_get_status_meaning;
4204: FND_MESSAGE.SET_TOKEN('NEW_STATUS_PARAMC1' , l_status_meaning );
4205:
4206: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4207: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4208: --WIP Job Created
4209: elsif (l_ref_REPH_rec.event_code = 'JS') then
4210: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4211: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );

Line 4210: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

4206: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4207: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4208: --WIP Job Created
4209: elsif (l_ref_REPH_rec.event_code = 'JS') then
4210: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4211: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4212: FND_MESSAGE.SET_TOKEN('PARAMN5' , l_ref_REPH_rec.PARAMN5 );
4213: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4214: --RMA Serial Number Changed

Line 4211: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );

4207: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4208: --WIP Job Created
4209: elsif (l_ref_REPH_rec.event_code = 'JS') then
4210: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4211: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4212: FND_MESSAGE.SET_TOKEN('PARAMN5' , l_ref_REPH_rec.PARAMN5 );
4213: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4214: --RMA Serial Number Changed
4215: elsif (l_ref_REPH_rec.event_code = 'RSC') then

Line 4212: FND_MESSAGE.SET_TOKEN('PARAMN5' , l_ref_REPH_rec.PARAMN5 );

4208: --WIP Job Created
4209: elsif (l_ref_REPH_rec.event_code = 'JS') then
4210: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4211: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4212: FND_MESSAGE.SET_TOKEN('PARAMN5' , l_ref_REPH_rec.PARAMN5 );
4213: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4214: --RMA Serial Number Changed
4215: elsif (l_ref_REPH_rec.event_code = 'RSC') then
4216: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

Line 4213: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );

4209: elsif (l_ref_REPH_rec.event_code = 'JS') then
4210: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4211: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4212: FND_MESSAGE.SET_TOKEN('PARAMN5' , l_ref_REPH_rec.PARAMN5 );
4213: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4214: --RMA Serial Number Changed
4215: elsif (l_ref_REPH_rec.event_code = 'RSC') then
4216: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4217: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );

Line 4216: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

4212: FND_MESSAGE.SET_TOKEN('PARAMN5' , l_ref_REPH_rec.PARAMN5 );
4213: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4214: --RMA Serial Number Changed
4215: elsif (l_ref_REPH_rec.event_code = 'RSC') then
4216: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4217: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4218: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4219: FND_MESSAGE.SET_TOKEN('PARAMN2' , l_ref_REPH_rec.PARAMN2 );
4220: --Shipment Serial Number Changed

Line 4217: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );

4213: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4214: --RMA Serial Number Changed
4215: elsif (l_ref_REPH_rec.event_code = 'RSC') then
4216: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4217: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4218: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4219: FND_MESSAGE.SET_TOKEN('PARAMN2' , l_ref_REPH_rec.PARAMN2 );
4220: --Shipment Serial Number Changed
4221: elsif (l_ref_REPH_rec.event_code = 'SSC') then

Line 4218: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );

4214: --RMA Serial Number Changed
4215: elsif (l_ref_REPH_rec.event_code = 'RSC') then
4216: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4217: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4218: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4219: FND_MESSAGE.SET_TOKEN('PARAMN2' , l_ref_REPH_rec.PARAMN2 );
4220: --Shipment Serial Number Changed
4221: elsif (l_ref_REPH_rec.event_code = 'SSC') then
4222: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

Line 4219: FND_MESSAGE.SET_TOKEN('PARAMN2' , l_ref_REPH_rec.PARAMN2 );

4215: elsif (l_ref_REPH_rec.event_code = 'RSC') then
4216: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4217: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4218: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4219: FND_MESSAGE.SET_TOKEN('PARAMN2' , l_ref_REPH_rec.PARAMN2 );
4220: --Shipment Serial Number Changed
4221: elsif (l_ref_REPH_rec.event_code = 'SSC') then
4222: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4223: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );

Line 4222: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

4218: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4219: FND_MESSAGE.SET_TOKEN('PARAMN2' , l_ref_REPH_rec.PARAMN2 );
4220: --Shipment Serial Number Changed
4221: elsif (l_ref_REPH_rec.event_code = 'SSC') then
4222: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4223: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4224: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4225: --Inspection Performed
4226: elsif (l_ref_REPH_rec.event_code = 'IP') then

Line 4223: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );

4219: FND_MESSAGE.SET_TOKEN('PARAMN2' , l_ref_REPH_rec.PARAMN2 );
4220: --Shipment Serial Number Changed
4221: elsif (l_ref_REPH_rec.event_code = 'SSC') then
4222: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4223: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4224: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4225: --Inspection Performed
4226: elsif (l_ref_REPH_rec.event_code = 'IP') then
4227: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

Line 4224: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );

4220: --Shipment Serial Number Changed
4221: elsif (l_ref_REPH_rec.event_code = 'SSC') then
4222: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4223: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4224: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4225: --Inspection Performed
4226: elsif (l_ref_REPH_rec.event_code = 'IP') then
4227: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4228: FND_MESSAGE.SET_TOKEN('PARAMN3' , l_ref_REPH_rec.PARAMN3 );

Line 4227: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

4223: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4224: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4225: --Inspection Performed
4226: elsif (l_ref_REPH_rec.event_code = 'IP') then
4227: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4228: FND_MESSAGE.SET_TOKEN('PARAMN3' , l_ref_REPH_rec.PARAMN3 );
4229: FND_MESSAGE.SET_TOKEN('PARAMN4' , l_ref_REPH_rec.PARAMN4 );
4230: --Repair Order Split
4231: elsif (l_ref_REPH_rec.event_code = 'SLT') then

Line 4228: FND_MESSAGE.SET_TOKEN('PARAMN3' , l_ref_REPH_rec.PARAMN3 );

4224: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4225: --Inspection Performed
4226: elsif (l_ref_REPH_rec.event_code = 'IP') then
4227: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4228: FND_MESSAGE.SET_TOKEN('PARAMN3' , l_ref_REPH_rec.PARAMN3 );
4229: FND_MESSAGE.SET_TOKEN('PARAMN4' , l_ref_REPH_rec.PARAMN4 );
4230: --Repair Order Split
4231: elsif (l_ref_REPH_rec.event_code = 'SLT') then
4232: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

Line 4229: FND_MESSAGE.SET_TOKEN('PARAMN4' , l_ref_REPH_rec.PARAMN4 );

4225: --Inspection Performed
4226: elsif (l_ref_REPH_rec.event_code = 'IP') then
4227: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4228: FND_MESSAGE.SET_TOKEN('PARAMN3' , l_ref_REPH_rec.PARAMN3 );
4229: FND_MESSAGE.SET_TOKEN('PARAMN4' , l_ref_REPH_rec.PARAMN4 );
4230: --Repair Order Split
4231: elsif (l_ref_REPH_rec.event_code = 'SLT') then
4232: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4233: FND_MESSAGE.SET_TOKEN('PARAMN1' , l_ref_REPH_rec.PARAMN1 );

Line 4232: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

4228: FND_MESSAGE.SET_TOKEN('PARAMN3' , l_ref_REPH_rec.PARAMN3 );
4229: FND_MESSAGE.SET_TOKEN('PARAMN4' , l_ref_REPH_rec.PARAMN4 );
4230: --Repair Order Split
4231: elsif (l_ref_REPH_rec.event_code = 'SLT') then
4232: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4233: FND_MESSAGE.SET_TOKEN('PARAMN1' , l_ref_REPH_rec.PARAMN1 );
4234: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4235:
4236: --ATTACHMENTS_PARAMC2 based on paramc2 value:'Y' => 'Attachments Copied'

Line 4233: FND_MESSAGE.SET_TOKEN('PARAMN1' , l_ref_REPH_rec.PARAMN1 );

4229: FND_MESSAGE.SET_TOKEN('PARAMN4' , l_ref_REPH_rec.PARAMN4 );
4230: --Repair Order Split
4231: elsif (l_ref_REPH_rec.event_code = 'SLT') then
4232: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4233: FND_MESSAGE.SET_TOKEN('PARAMN1' , l_ref_REPH_rec.PARAMN1 );
4234: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4235:
4236: --ATTACHMENTS_PARAMC2 based on paramc2 value:'Y' => 'Attachments Copied'
4237: --else 'Attachments Not Copied'

Line 4234: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );

4230: --Repair Order Split
4231: elsif (l_ref_REPH_rec.event_code = 'SLT') then
4232: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4233: FND_MESSAGE.SET_TOKEN('PARAMN1' , l_ref_REPH_rec.PARAMN1 );
4234: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4235:
4236: --ATTACHMENTS_PARAMC2 based on paramc2 value:'Y' => 'Attachments Copied'
4237: --else 'Attachments Not Copied'
4238: if (l_ref_REPH_rec.PARAMC2 = 'Y') then

Line 4239: FND_MESSAGE.SET_TOKEN('ATTACHMENTS_PARAMC2' , l_attachments_copied );

4235:
4236: --ATTACHMENTS_PARAMC2 based on paramc2 value:'Y' => 'Attachments Copied'
4237: --else 'Attachments Not Copied'
4238: if (l_ref_REPH_rec.PARAMC2 = 'Y') then
4239: FND_MESSAGE.SET_TOKEN('ATTACHMENTS_PARAMC2' , l_attachments_copied );
4240: else
4241: FND_MESSAGE.SET_TOKEN('ATTACHMENTS_PARAMC2' , l_attachments_not_copied );
4242: end if;
4243:

Line 4241: FND_MESSAGE.SET_TOKEN('ATTACHMENTS_PARAMC2' , l_attachments_not_copied );

4237: --else 'Attachments Not Copied'
4238: if (l_ref_REPH_rec.PARAMC2 = 'Y') then
4239: FND_MESSAGE.SET_TOKEN('ATTACHMENTS_PARAMC2' , l_attachments_copied );
4240: else
4241: FND_MESSAGE.SET_TOKEN('ATTACHMENTS_PARAMC2' , l_attachments_not_copied );
4242: end if;
4243:
4244: --Estimate Status Updated
4245: elsif (l_ref_REPH_rec.event_code = 'ESU') then

Line 4250: FND_MESSAGE.SET_TOKEN('OLD_STATUS_PARAMC2' , l_status_meaning );

4246: --get status meaning
4247: Open c_get_status_meaning(l_ref_REPH_rec.PARAMC2, 'CSD_APPROVAL_STATUS');
4248: FETCH c_get_status_meaning into l_status_meaning;
4249: Close c_get_status_meaning;
4250: FND_MESSAGE.SET_TOKEN('OLD_STATUS_PARAMC2' , l_status_meaning );
4251:
4252: --get status meaning
4253: Open c_get_status_meaning(l_ref_REPH_rec.PARAMC1, 'CSD_APPROVAL_STATUS');
4254: FETCH c_get_status_meaning into l_status_meaning;

Line 4256: FND_MESSAGE.SET_TOKEN('NEW_STATUS_PARAMC1' , l_status_meaning );

4252: --get status meaning
4253: Open c_get_status_meaning(l_ref_REPH_rec.PARAMC1, 'CSD_APPROVAL_STATUS');
4254: FETCH c_get_status_meaning into l_status_meaning;
4255: Close c_get_status_meaning;
4256: FND_MESSAGE.SET_TOKEN('NEW_STATUS_PARAMC1' , l_status_meaning );
4257:
4258: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4259: FND_MESSAGE.SET_TOKEN('PARAMN2' , l_ref_REPH_rec.PARAMN2 );
4260: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );

Line 4258: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );

4254: FETCH c_get_status_meaning into l_status_meaning;
4255: Close c_get_status_meaning;
4256: FND_MESSAGE.SET_TOKEN('NEW_STATUS_PARAMC1' , l_status_meaning );
4257:
4258: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4259: FND_MESSAGE.SET_TOKEN('PARAMN2' , l_ref_REPH_rec.PARAMN2 );
4260: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4261: --Charges Manually Updated for RO
4262: elsif (l_ref_REPH_rec.event_code = 'CM') then

Line 4259: FND_MESSAGE.SET_TOKEN('PARAMN2' , l_ref_REPH_rec.PARAMN2 );

4255: Close c_get_status_meaning;
4256: FND_MESSAGE.SET_TOKEN('NEW_STATUS_PARAMC1' , l_status_meaning );
4257:
4258: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4259: FND_MESSAGE.SET_TOKEN('PARAMN2' , l_ref_REPH_rec.PARAMN2 );
4260: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4261: --Charges Manually Updated for RO
4262: elsif (l_ref_REPH_rec.event_code = 'CM') then
4263: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );

Line 4260: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );

4256: FND_MESSAGE.SET_TOKEN('NEW_STATUS_PARAMC1' , l_status_meaning );
4257:
4258: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4259: FND_MESSAGE.SET_TOKEN('PARAMN2' , l_ref_REPH_rec.PARAMN2 );
4260: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4261: --Charges Manually Updated for RO
4262: elsif (l_ref_REPH_rec.event_code = 'CM') then
4263: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4264: --Default Contract Updated

Line 4263: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );

4259: FND_MESSAGE.SET_TOKEN('PARAMN2' , l_ref_REPH_rec.PARAMN2 );
4260: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4261: --Charges Manually Updated for RO
4262: elsif (l_ref_REPH_rec.event_code = 'CM') then
4263: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4264: --Default Contract Updated
4265: elsif (l_ref_REPH_rec.event_code = 'CONU') then
4266: FND_MESSAGE.SET_TOKEN('PARAMC10' , l_ref_REPH_rec.PARAMC10 );
4267: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

Line 4266: FND_MESSAGE.SET_TOKEN('PARAMC10' , l_ref_REPH_rec.PARAMC10 );

4262: elsif (l_ref_REPH_rec.event_code = 'CM') then
4263: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4264: --Default Contract Updated
4265: elsif (l_ref_REPH_rec.event_code = 'CONU') then
4266: FND_MESSAGE.SET_TOKEN('PARAMC10' , l_ref_REPH_rec.PARAMC10 );
4267: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4268: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4269: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4270: --Job Submitted

Line 4267: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

4263: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4264: --Default Contract Updated
4265: elsif (l_ref_REPH_rec.event_code = 'CONU') then
4266: FND_MESSAGE.SET_TOKEN('PARAMC10' , l_ref_REPH_rec.PARAMC10 );
4267: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4268: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4269: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4270: --Job Submitted
4271: elsif (l_ref_REPH_rec.event_code = 'JSU') then

Line 4268: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

4264: --Default Contract Updated
4265: elsif (l_ref_REPH_rec.event_code = 'CONU') then
4266: FND_MESSAGE.SET_TOKEN('PARAMC10' , l_ref_REPH_rec.PARAMC10 );
4267: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4268: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4269: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4270: --Job Submitted
4271: elsif (l_ref_REPH_rec.event_code = 'JSU') then
4272: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

Line 4269: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );

4265: elsif (l_ref_REPH_rec.event_code = 'CONU') then
4266: FND_MESSAGE.SET_TOKEN('PARAMC10' , l_ref_REPH_rec.PARAMC10 );
4267: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4268: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4269: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4270: --Job Submitted
4271: elsif (l_ref_REPH_rec.event_code = 'JSU') then
4272: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4273: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );

Line 4272: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

4268: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4269: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4270: --Job Submitted
4271: elsif (l_ref_REPH_rec.event_code = 'JSU') then
4272: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4273: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4274: FND_MESSAGE.SET_TOKEN('PARAMN5' , l_ref_REPH_rec.PARAMN5 );
4275: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4276: FND_MESSAGE.SET_TOKEN('PARAMN6' , l_ref_REPH_rec.PARAMN6 );

Line 4273: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );

4269: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4270: --Job Submitted
4271: elsif (l_ref_REPH_rec.event_code = 'JSU') then
4272: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4273: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4274: FND_MESSAGE.SET_TOKEN('PARAMN5' , l_ref_REPH_rec.PARAMN5 );
4275: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4276: FND_MESSAGE.SET_TOKEN('PARAMN6' , l_ref_REPH_rec.PARAMN6 );
4277: FND_MESSAGE.SET_TOKEN('PARAMN7' , l_ref_REPH_rec.PARAMN7 );

Line 4274: FND_MESSAGE.SET_TOKEN('PARAMN5' , l_ref_REPH_rec.PARAMN5 );

4270: --Job Submitted
4271: elsif (l_ref_REPH_rec.event_code = 'JSU') then
4272: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4273: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4274: FND_MESSAGE.SET_TOKEN('PARAMN5' , l_ref_REPH_rec.PARAMN5 );
4275: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4276: FND_MESSAGE.SET_TOKEN('PARAMN6' , l_ref_REPH_rec.PARAMN6 );
4277: FND_MESSAGE.SET_TOKEN('PARAMN7' , l_ref_REPH_rec.PARAMN7 );
4278: --Job Completed Alert

Line 4275: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

4271: elsif (l_ref_REPH_rec.event_code = 'JSU') then
4272: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4273: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4274: FND_MESSAGE.SET_TOKEN('PARAMN5' , l_ref_REPH_rec.PARAMN5 );
4275: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4276: FND_MESSAGE.SET_TOKEN('PARAMN6' , l_ref_REPH_rec.PARAMN6 );
4277: FND_MESSAGE.SET_TOKEN('PARAMN7' , l_ref_REPH_rec.PARAMN7 );
4278: --Job Completed Alert
4279: elsif (l_ref_REPH_rec.event_code = 'JCA') then

Line 4276: FND_MESSAGE.SET_TOKEN('PARAMN6' , l_ref_REPH_rec.PARAMN6 );

4272: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4273: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4274: FND_MESSAGE.SET_TOKEN('PARAMN5' , l_ref_REPH_rec.PARAMN5 );
4275: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4276: FND_MESSAGE.SET_TOKEN('PARAMN6' , l_ref_REPH_rec.PARAMN6 );
4277: FND_MESSAGE.SET_TOKEN('PARAMN7' , l_ref_REPH_rec.PARAMN7 );
4278: --Job Completed Alert
4279: elsif (l_ref_REPH_rec.event_code = 'JCA') then
4280: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

Line 4277: FND_MESSAGE.SET_TOKEN('PARAMN7' , l_ref_REPH_rec.PARAMN7 );

4273: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4274: FND_MESSAGE.SET_TOKEN('PARAMN5' , l_ref_REPH_rec.PARAMN5 );
4275: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4276: FND_MESSAGE.SET_TOKEN('PARAMN6' , l_ref_REPH_rec.PARAMN6 );
4277: FND_MESSAGE.SET_TOKEN('PARAMN7' , l_ref_REPH_rec.PARAMN7 );
4278: --Job Completed Alert
4279: elsif (l_ref_REPH_rec.event_code = 'JCA') then
4280: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4281: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

Line 4280: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

4276: FND_MESSAGE.SET_TOKEN('PARAMN6' , l_ref_REPH_rec.PARAMN6 );
4277: FND_MESSAGE.SET_TOKEN('PARAMN7' , l_ref_REPH_rec.PARAMN7 );
4278: --Job Completed Alert
4279: elsif (l_ref_REPH_rec.event_code = 'JCA') then
4280: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4281: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4282: --Sales Order Received
4283: elsif (l_ref_REPH_rec.event_code = 'RRI') then
4284: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

Line 4281: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

4277: FND_MESSAGE.SET_TOKEN('PARAMN7' , l_ref_REPH_rec.PARAMN7 );
4278: --Job Completed Alert
4279: elsif (l_ref_REPH_rec.event_code = 'JCA') then
4280: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4281: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4282: --Sales Order Received
4283: elsif (l_ref_REPH_rec.event_code = 'RRI') then
4284: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4285: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

Line 4284: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

4280: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4281: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4282: --Sales Order Received
4283: elsif (l_ref_REPH_rec.event_code = 'RRI') then
4284: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4285: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4286: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4287: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4288: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );

Line 4285: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

4281: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4282: --Sales Order Received
4283: elsif (l_ref_REPH_rec.event_code = 'RRI') then
4284: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4285: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4286: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4287: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4288: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4289: --Sales Order Completed

Line 4286: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );

4282: --Sales Order Received
4283: elsif (l_ref_REPH_rec.event_code = 'RRI') then
4284: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4285: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4286: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4287: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4288: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4289: --Sales Order Completed
4290: elsif (l_ref_REPH_rec.event_code = 'PSI') then

Line 4287: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );

4283: elsif (l_ref_REPH_rec.event_code = 'RRI') then
4284: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4285: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4286: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4287: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4288: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4289: --Sales Order Completed
4290: elsif (l_ref_REPH_rec.event_code = 'PSI') then
4291: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

Line 4288: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );

4284: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4285: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4286: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4287: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4288: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4289: --Sales Order Completed
4290: elsif (l_ref_REPH_rec.event_code = 'PSI') then
4291: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4292: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

Line 4291: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

4287: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4288: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4289: --Sales Order Completed
4290: elsif (l_ref_REPH_rec.event_code = 'PSI') then
4291: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4292: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4293: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4294: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4295: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );

Line 4292: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

4288: FND_MESSAGE.SET_TOKEN('QUANTITY' , l_ref_REPH_rec.QUANTITY );
4289: --Sales Order Completed
4290: elsif (l_ref_REPH_rec.event_code = 'PSI') then
4291: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4292: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4293: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4294: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4295: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4296: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );

Line 4293: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );

4289: --Sales Order Completed
4290: elsif (l_ref_REPH_rec.event_code = 'PSI') then
4291: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4292: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4293: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4294: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4295: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4296: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4297: --Repair Order Owner Updated

Line 4294: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );

4290: elsif (l_ref_REPH_rec.event_code = 'PSI') then
4291: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4292: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4293: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4294: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4295: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4296: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4297: --Repair Order Owner Updated
4298: elsif (l_ref_REPH_rec.event_code = 'DROC') then

Line 4295: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );

4291: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4292: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4293: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4294: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4295: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4296: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4297: --Repair Order Owner Updated
4298: elsif (l_ref_REPH_rec.event_code = 'DROC') then
4299: fnd_message.set_token('PARAMC1',l_ref_REPH_rec.PARAMC1);

Line 4296: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );

4292: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4293: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4294: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4295: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4296: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4297: --Repair Order Owner Updated
4298: elsif (l_ref_REPH_rec.event_code = 'DROC') then
4299: fnd_message.set_token('PARAMC1',l_ref_REPH_rec.PARAMC1);
4300: fnd_message.set_token('PARAMC2',l_ref_REPH_rec.PARAMC2);

Line 4299: fnd_message.set_token('PARAMC1',l_ref_REPH_rec.PARAMC1);

4295: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4296: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4297: --Repair Order Owner Updated
4298: elsif (l_ref_REPH_rec.event_code = 'DROC') then
4299: fnd_message.set_token('PARAMC1',l_ref_REPH_rec.PARAMC1);
4300: fnd_message.set_token('PARAMC2',l_ref_REPH_rec.PARAMC2);
4301: fnd_message.set_token('CREATED_BY',l_user_name);
4302: --Service Request Status Updated
4303: elsif (l_ref_REPH_rec.event_code = 'SRU') then

Line 4300: fnd_message.set_token('PARAMC2',l_ref_REPH_rec.PARAMC2);

4296: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4297: --Repair Order Owner Updated
4298: elsif (l_ref_REPH_rec.event_code = 'DROC') then
4299: fnd_message.set_token('PARAMC1',l_ref_REPH_rec.PARAMC1);
4300: fnd_message.set_token('PARAMC2',l_ref_REPH_rec.PARAMC2);
4301: fnd_message.set_token('CREATED_BY',l_user_name);
4302: --Service Request Status Updated
4303: elsif (l_ref_REPH_rec.event_code = 'SRU') then
4304: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

Line 4301: fnd_message.set_token('CREATED_BY',l_user_name);

4297: --Repair Order Owner Updated
4298: elsif (l_ref_REPH_rec.event_code = 'DROC') then
4299: fnd_message.set_token('PARAMC1',l_ref_REPH_rec.PARAMC1);
4300: fnd_message.set_token('PARAMC2',l_ref_REPH_rec.PARAMC2);
4301: fnd_message.set_token('CREATED_BY',l_user_name);
4302: --Service Request Status Updated
4303: elsif (l_ref_REPH_rec.event_code = 'SRU') then
4304: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4305: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

Line 4304: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

4300: fnd_message.set_token('PARAMC2',l_ref_REPH_rec.PARAMC2);
4301: fnd_message.set_token('CREATED_BY',l_user_name);
4302: --Service Request Status Updated
4303: elsif (l_ref_REPH_rec.event_code = 'SRU') then
4304: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4305: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4306: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4307: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4308: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );

Line 4305: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

4301: fnd_message.set_token('CREATED_BY',l_user_name);
4302: --Service Request Status Updated
4303: elsif (l_ref_REPH_rec.event_code = 'SRU') then
4304: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4305: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4306: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4307: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4308: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4309: --RO Type Updated

Line 4306: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );

4302: --Service Request Status Updated
4303: elsif (l_ref_REPH_rec.event_code = 'SRU') then
4304: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4305: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4306: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4307: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4308: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4309: --RO Type Updated
4310: elsif (l_ref_REPH_rec.event_code = 'RTU') then

Line 4307: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );

4303: elsif (l_ref_REPH_rec.event_code = 'SRU') then
4304: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4305: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4306: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4307: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4308: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4309: --RO Type Updated
4310: elsif (l_ref_REPH_rec.event_code = 'RTU') then
4311: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );

Line 4308: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );

4304: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4305: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4306: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4307: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4308: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4309: --RO Type Updated
4310: elsif (l_ref_REPH_rec.event_code = 'RTU') then
4311: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4312: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );

Line 4311: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );

4307: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4308: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4309: --RO Type Updated
4310: elsif (l_ref_REPH_rec.event_code = 'RTU') then
4311: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4312: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4313: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4314: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4315: --Repair Order Alert

Line 4312: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );

4308: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4309: --RO Type Updated
4310: elsif (l_ref_REPH_rec.event_code = 'RTU') then
4311: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4312: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4313: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4314: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4315: --Repair Order Alert
4316: elsif (l_ref_REPH_rec.event_code = 'OA') then

Line 4313: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

4309: --RO Type Updated
4310: elsif (l_ref_REPH_rec.event_code = 'RTU') then
4311: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4312: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4313: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4314: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4315: --Repair Order Alert
4316: elsif (l_ref_REPH_rec.event_code = 'OA') then
4317: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

Line 4314: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );

4310: elsif (l_ref_REPH_rec.event_code = 'RTU') then
4311: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4312: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4313: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4314: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4315: --Repair Order Alert
4316: elsif (l_ref_REPH_rec.event_code = 'OA') then
4317: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4318: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

Line 4317: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

4313: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4314: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4315: --Repair Order Alert
4316: elsif (l_ref_REPH_rec.event_code = 'OA') then
4317: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4318: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4319: --Task Created
4320: elsif (l_ref_REPH_rec.event_code = 'TC') then
4321: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

Line 4318: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

4314: FND_MESSAGE.SET_TOKEN('CREATED_BY' , l_user_name );
4315: --Repair Order Alert
4316: elsif (l_ref_REPH_rec.event_code = 'OA') then
4317: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4318: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4319: --Task Created
4320: elsif (l_ref_REPH_rec.event_code = 'TC') then
4321: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4322: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );

Line 4321: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

4317: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4318: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4319: --Task Created
4320: elsif (l_ref_REPH_rec.event_code = 'TC') then
4321: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4322: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );
4323: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4324: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4325: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );

Line 4322: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );

4318: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4319: --Task Created
4320: elsif (l_ref_REPH_rec.event_code = 'TC') then
4321: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4322: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );
4323: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4324: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4325: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4326: --Task Owner Updated

Line 4323: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );

4319: --Task Created
4320: elsif (l_ref_REPH_rec.event_code = 'TC') then
4321: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4322: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );
4323: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4324: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4325: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4326: --Task Owner Updated
4327: elsif (l_ref_REPH_rec.event_code = 'TOC') then

Line 4324: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );

4320: elsif (l_ref_REPH_rec.event_code = 'TC') then
4321: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4322: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );
4323: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4324: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4325: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4326: --Task Owner Updated
4327: elsif (l_ref_REPH_rec.event_code = 'TOC') then
4328: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

Line 4325: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );

4321: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4322: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );
4323: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4324: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4325: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4326: --Task Owner Updated
4327: elsif (l_ref_REPH_rec.event_code = 'TOC') then
4328: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4329: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );

Line 4328: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

4324: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4325: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4326: --Task Owner Updated
4327: elsif (l_ref_REPH_rec.event_code = 'TOC') then
4328: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4329: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );
4330: FND_MESSAGE.SET_TOKEN('PARAMC9' , l_ref_REPH_rec.PARAMC9 );
4331: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4332: --Task Status Updated

Line 4329: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );

4325: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4326: --Task Owner Updated
4327: elsif (l_ref_REPH_rec.event_code = 'TOC') then
4328: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4329: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );
4330: FND_MESSAGE.SET_TOKEN('PARAMC9' , l_ref_REPH_rec.PARAMC9 );
4331: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4332: --Task Status Updated
4333: elsif (l_ref_REPH_rec.event_code = 'TSC') then

Line 4330: FND_MESSAGE.SET_TOKEN('PARAMC9' , l_ref_REPH_rec.PARAMC9 );

4326: --Task Owner Updated
4327: elsif (l_ref_REPH_rec.event_code = 'TOC') then
4328: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4329: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );
4330: FND_MESSAGE.SET_TOKEN('PARAMC9' , l_ref_REPH_rec.PARAMC9 );
4331: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4332: --Task Status Updated
4333: elsif (l_ref_REPH_rec.event_code = 'TSC') then
4334: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

Line 4331: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );

4327: elsif (l_ref_REPH_rec.event_code = 'TOC') then
4328: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4329: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );
4330: FND_MESSAGE.SET_TOKEN('PARAMC9' , l_ref_REPH_rec.PARAMC9 );
4331: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4332: --Task Status Updated
4333: elsif (l_ref_REPH_rec.event_code = 'TSC') then
4334: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4335: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );

Line 4334: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

4330: FND_MESSAGE.SET_TOKEN('PARAMC9' , l_ref_REPH_rec.PARAMC9 );
4331: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4332: --Task Status Updated
4333: elsif (l_ref_REPH_rec.event_code = 'TSC') then
4334: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4335: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );
4336: FND_MESSAGE.SET_TOKEN('PARAMC8' , l_ref_REPH_rec.PARAMC8 );
4337: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4338: --Task Assignee Updated

Line 4335: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );

4331: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4332: --Task Status Updated
4333: elsif (l_ref_REPH_rec.event_code = 'TSC') then
4334: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4335: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );
4336: FND_MESSAGE.SET_TOKEN('PARAMC8' , l_ref_REPH_rec.PARAMC8 );
4337: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4338: --Task Assignee Updated
4339: elsif (l_ref_REPH_rec.event_code = 'TAC') then

Line 4336: FND_MESSAGE.SET_TOKEN('PARAMC8' , l_ref_REPH_rec.PARAMC8 );

4332: --Task Status Updated
4333: elsif (l_ref_REPH_rec.event_code = 'TSC') then
4334: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4335: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );
4336: FND_MESSAGE.SET_TOKEN('PARAMC8' , l_ref_REPH_rec.PARAMC8 );
4337: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4338: --Task Assignee Updated
4339: elsif (l_ref_REPH_rec.event_code = 'TAC') then
4340: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

Line 4337: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );

4333: elsif (l_ref_REPH_rec.event_code = 'TSC') then
4334: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4335: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );
4336: FND_MESSAGE.SET_TOKEN('PARAMC8' , l_ref_REPH_rec.PARAMC8 );
4337: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4338: --Task Assignee Updated
4339: elsif (l_ref_REPH_rec.event_code = 'TAC') then
4340: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4341: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );

Line 4340: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

4336: FND_MESSAGE.SET_TOKEN('PARAMC8' , l_ref_REPH_rec.PARAMC8 );
4337: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4338: --Task Assignee Updated
4339: elsif (l_ref_REPH_rec.event_code = 'TAC') then
4340: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4341: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );
4342: FND_MESSAGE.SET_TOKEN('PARAMC9' , l_ref_REPH_rec.PARAMC9 );
4343: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4344: --Customer Approved

Line 4341: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );

4337: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4338: --Task Assignee Updated
4339: elsif (l_ref_REPH_rec.event_code = 'TAC') then
4340: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4341: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );
4342: FND_MESSAGE.SET_TOKEN('PARAMC9' , l_ref_REPH_rec.PARAMC9 );
4343: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4344: --Customer Approved
4345: elsif (l_ref_REPH_rec.event_code = 'A') then

Line 4342: FND_MESSAGE.SET_TOKEN('PARAMC9' , l_ref_REPH_rec.PARAMC9 );

4338: --Task Assignee Updated
4339: elsif (l_ref_REPH_rec.event_code = 'TAC') then
4340: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4341: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );
4342: FND_MESSAGE.SET_TOKEN('PARAMC9' , l_ref_REPH_rec.PARAMC9 );
4343: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4344: --Customer Approved
4345: elsif (l_ref_REPH_rec.event_code = 'A') then
4346: --get status meaning

Line 4343: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );

4339: elsif (l_ref_REPH_rec.event_code = 'TAC') then
4340: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4341: FND_MESSAGE.SET_TOKEN('PARAMC7' , l_ref_REPH_rec.PARAMC7 );
4342: FND_MESSAGE.SET_TOKEN('PARAMC9' , l_ref_REPH_rec.PARAMC9 );
4343: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4344: --Customer Approved
4345: elsif (l_ref_REPH_rec.event_code = 'A') then
4346: --get status meaning
4347: Open c_get_status_meaning(l_ref_REPH_rec.PARAMC2, 'CSD_APPROVAL_STATUS');

Line 4350: FND_MESSAGE.SET_TOKEN('OLD_STATUS_PARAMC2' , l_ref_REPH_rec.PARAMC2 );

4346: --get status meaning
4347: Open c_get_status_meaning(l_ref_REPH_rec.PARAMC2, 'CSD_APPROVAL_STATUS');
4348: FETCH c_get_status_meaning into l_status_meaning;
4349: Close c_get_status_meaning;
4350: FND_MESSAGE.SET_TOKEN('OLD_STATUS_PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4351:
4352: --get flow status meaning
4353: Open c_get_status_meaning(l_ref_REPH_rec.PARAMC1,'CSD_APPROVAL_STATUS' );
4354: FETCH c_get_status_meaning into l_status_meaning;

Line 4356: FND_MESSAGE.SET_TOKEN('NEW_STATUS_PARAMC1' , l_ref_REPH_rec.PARAMC1 );

4352: --get flow status meaning
4353: Open c_get_status_meaning(l_ref_REPH_rec.PARAMC1,'CSD_APPROVAL_STATUS' );
4354: FETCH c_get_status_meaning into l_status_meaning;
4355: Close c_get_status_meaning;
4356: FND_MESSAGE.SET_TOKEN('NEW_STATUS_PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4357:
4358: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4359: --Customer Rejected
4360: elsif (l_ref_REPH_rec.event_code = 'R') then

Line 4358: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );

4354: FETCH c_get_status_meaning into l_status_meaning;
4355: Close c_get_status_meaning;
4356: FND_MESSAGE.SET_TOKEN('NEW_STATUS_PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4357:
4358: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4359: --Customer Rejected
4360: elsif (l_ref_REPH_rec.event_code = 'R') then
4361:
4362: --get status meaning

Line 4366: FND_MESSAGE.SET_TOKEN('OLD_STATUS_PARAMC2' , l_status_meaning );

4362: --get status meaning
4363: Open c_get_status_meaning(l_ref_REPH_rec.PARAMC2, 'CSD_APPROVAL_STATUS');
4364: FETCH c_get_status_meaning into l_status_meaning;
4365: Close c_get_status_meaning;
4366: FND_MESSAGE.SET_TOKEN('OLD_STATUS_PARAMC2' , l_status_meaning );
4367:
4368: --get flow status meaning
4369: Open c_get_status_meaning(l_ref_REPH_rec.PARAMC1,'CSD_APPROVAL_STATUS' );
4370: FETCH c_get_status_meaning into l_status_meaning;

Line 4372: FND_MESSAGE.SET_TOKEN('NEW_STATUS_PARAMC1' , l_status_meaning);

4368: --get flow status meaning
4369: Open c_get_status_meaning(l_ref_REPH_rec.PARAMC1,'CSD_APPROVAL_STATUS' );
4370: FETCH c_get_status_meaning into l_status_meaning;
4371: Close c_get_status_meaning;
4372: FND_MESSAGE.SET_TOKEN('NEW_STATUS_PARAMC1' , l_status_meaning);
4373:
4374: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4375:
4376: -- START bug#13698799 auto create ro, parent ro

Line 4374: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );

4370: FETCH c_get_status_meaning into l_status_meaning;
4371: Close c_get_status_meaning;
4372: FND_MESSAGE.SET_TOKEN('NEW_STATUS_PARAMC1' , l_status_meaning);
4373:
4374: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4375:
4376: -- START bug#13698799 auto create ro, parent ro
4377: --Repair Order Creation
4378: elsif (l_ref_REPH_rec.event_code = 'ROC') then

Line 4379: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

4375:
4376: -- START bug#13698799 auto create ro, parent ro
4377: --Repair Order Creation
4378: elsif (l_ref_REPH_rec.event_code = 'ROC') then
4379: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4380: open c_get_status_meaning(l_ref_REPH_rec.PARAMC2, 'CSD_REPAIR_FLOW_STATUS' );
4381: FETCH c_get_status_meaning into l_status_meaning;
4382: Close c_get_status_meaning;
4383: FND_MESSAGE.SET_TOKEN('FLOW_STATUS_PARAMC2' , l_status_meaning );

Line 4383: FND_MESSAGE.SET_TOKEN('FLOW_STATUS_PARAMC2' , l_status_meaning );

4379: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4380: open c_get_status_meaning(l_ref_REPH_rec.PARAMC2, 'CSD_REPAIR_FLOW_STATUS' );
4381: FETCH c_get_status_meaning into l_status_meaning;
4382: Close c_get_status_meaning;
4383: FND_MESSAGE.SET_TOKEN('FLOW_STATUS_PARAMC2' , l_status_meaning );
4384: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4385: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4386: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4387: FND_MESSAGE.SET_TOKEN('QTY' , l_ref_REPH_rec.QUANTITY);

Line 4384: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );

4380: open c_get_status_meaning(l_ref_REPH_rec.PARAMC2, 'CSD_REPAIR_FLOW_STATUS' );
4381: FETCH c_get_status_meaning into l_status_meaning;
4382: Close c_get_status_meaning;
4383: FND_MESSAGE.SET_TOKEN('FLOW_STATUS_PARAMC2' , l_status_meaning );
4384: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4385: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4386: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4387: FND_MESSAGE.SET_TOKEN('QTY' , l_ref_REPH_rec.QUANTITY);
4388: open c_get_repair_number(l_ref_REPH_rec.repair_line_id);

Line 4385: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );

4381: FETCH c_get_status_meaning into l_status_meaning;
4382: Close c_get_status_meaning;
4383: FND_MESSAGE.SET_TOKEN('FLOW_STATUS_PARAMC2' , l_status_meaning );
4384: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4385: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4386: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4387: FND_MESSAGE.SET_TOKEN('QTY' , l_ref_REPH_rec.QUANTITY);
4388: open c_get_repair_number(l_ref_REPH_rec.repair_line_id);
4389: FETCH c_get_repair_number into l_repair_number;

Line 4386: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );

4382: Close c_get_status_meaning;
4383: FND_MESSAGE.SET_TOKEN('FLOW_STATUS_PARAMC2' , l_status_meaning );
4384: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4385: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4386: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4387: FND_MESSAGE.SET_TOKEN('QTY' , l_ref_REPH_rec.QUANTITY);
4388: open c_get_repair_number(l_ref_REPH_rec.repair_line_id);
4389: FETCH c_get_repair_number into l_repair_number;
4390: Close c_get_repair_number;

Line 4387: FND_MESSAGE.SET_TOKEN('QTY' , l_ref_REPH_rec.QUANTITY);

4383: FND_MESSAGE.SET_TOKEN('FLOW_STATUS_PARAMC2' , l_status_meaning );
4384: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4385: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4386: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4387: FND_MESSAGE.SET_TOKEN('QTY' , l_ref_REPH_rec.QUANTITY);
4388: open c_get_repair_number(l_ref_REPH_rec.repair_line_id);
4389: FETCH c_get_repair_number into l_repair_number;
4390: Close c_get_repair_number;
4391: FND_MESSAGE.SET_TOKEN('REPAIR_NUMBER' , l_repair_number);

Line 4391: FND_MESSAGE.SET_TOKEN('REPAIR_NUMBER' , l_repair_number);

4387: FND_MESSAGE.SET_TOKEN('QTY' , l_ref_REPH_rec.QUANTITY);
4388: open c_get_repair_number(l_ref_REPH_rec.repair_line_id);
4389: FETCH c_get_repair_number into l_repair_number;
4390: Close c_get_repair_number;
4391: FND_MESSAGE.SET_TOKEN('REPAIR_NUMBER' , l_repair_number);
4392: --Component Repair Order Creation
4393: elsif (l_ref_REPH_rec.event_code = 'CROC') then
4394: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4395: open c_get_status_meaning(l_ref_REPH_rec.PARAMC2, 'CSD_REPAIR_FLOW_STATUS' );

Line 4394: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

4390: Close c_get_repair_number;
4391: FND_MESSAGE.SET_TOKEN('REPAIR_NUMBER' , l_repair_number);
4392: --Component Repair Order Creation
4393: elsif (l_ref_REPH_rec.event_code = 'CROC') then
4394: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4395: open c_get_status_meaning(l_ref_REPH_rec.PARAMC2, 'CSD_REPAIR_FLOW_STATUS' );
4396: FETCH c_get_status_meaning into l_status_meaning;
4397: Close c_get_status_meaning;
4398: FND_MESSAGE.SET_TOKEN('COMP_STATUS_PARAMC2' , l_status_meaning );

Line 4398: FND_MESSAGE.SET_TOKEN('COMP_STATUS_PARAMC2' , l_status_meaning );

4394: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4395: open c_get_status_meaning(l_ref_REPH_rec.PARAMC2, 'CSD_REPAIR_FLOW_STATUS' );
4396: FETCH c_get_status_meaning into l_status_meaning;
4397: Close c_get_status_meaning;
4398: FND_MESSAGE.SET_TOKEN('COMP_STATUS_PARAMC2' , l_status_meaning );
4399: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4400: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4401: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4402: FND_MESSAGE.SET_TOKEN('QTY' , l_ref_REPH_rec.QUANTITY);

Line 4399: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );

4395: open c_get_status_meaning(l_ref_REPH_rec.PARAMC2, 'CSD_REPAIR_FLOW_STATUS' );
4396: FETCH c_get_status_meaning into l_status_meaning;
4397: Close c_get_status_meaning;
4398: FND_MESSAGE.SET_TOKEN('COMP_STATUS_PARAMC2' , l_status_meaning );
4399: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4400: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4401: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4402: FND_MESSAGE.SET_TOKEN('QTY' , l_ref_REPH_rec.QUANTITY);
4403: -- END bug#13698799 auto create ro, parent ro

Line 4400: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );

4396: FETCH c_get_status_meaning into l_status_meaning;
4397: Close c_get_status_meaning;
4398: FND_MESSAGE.SET_TOKEN('COMP_STATUS_PARAMC2' , l_status_meaning );
4399: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4400: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4401: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4402: FND_MESSAGE.SET_TOKEN('QTY' , l_ref_REPH_rec.QUANTITY);
4403: -- END bug#13698799 auto create ro, parent ro
4404: -- service warranty contract.

Line 4401: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );

4397: Close c_get_status_meaning;
4398: FND_MESSAGE.SET_TOKEN('COMP_STATUS_PARAMC2' , l_status_meaning );
4399: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4400: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4401: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4402: FND_MESSAGE.SET_TOKEN('QTY' , l_ref_REPH_rec.QUANTITY);
4403: -- END bug#13698799 auto create ro, parent ro
4404: -- service warranty contract.
4405: elsif (l_ref_REPH_rec.event_code = 'WI') then

Line 4402: FND_MESSAGE.SET_TOKEN('QTY' , l_ref_REPH_rec.QUANTITY);

4398: FND_MESSAGE.SET_TOKEN('COMP_STATUS_PARAMC2' , l_status_meaning );
4399: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4400: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4401: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4402: FND_MESSAGE.SET_TOKEN('QTY' , l_ref_REPH_rec.QUANTITY);
4403: -- END bug#13698799 auto create ro, parent ro
4404: -- service warranty contract.
4405: elsif (l_ref_REPH_rec.event_code = 'WI') then
4406: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

Line 4406: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );

4402: FND_MESSAGE.SET_TOKEN('QTY' , l_ref_REPH_rec.QUANTITY);
4403: -- END bug#13698799 auto create ro, parent ro
4404: -- service warranty contract.
4405: elsif (l_ref_REPH_rec.event_code = 'WI') then
4406: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4407: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4408: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4409: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4410: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );

Line 4407: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );

4403: -- END bug#13698799 auto create ro, parent ro
4404: -- service warranty contract.
4405: elsif (l_ref_REPH_rec.event_code = 'WI') then
4406: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4407: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4408: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4409: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4410: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4411: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );

Line 4408: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );

4404: -- service warranty contract.
4405: elsif (l_ref_REPH_rec.event_code = 'WI') then
4406: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4407: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4408: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4409: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4410: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4411: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4412: end if;

Line 4409: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );

4405: elsif (l_ref_REPH_rec.event_code = 'WI') then
4406: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4407: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4408: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4409: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4410: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4411: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4412: end if;
4413: -- get the message string and return it --

Line 4410: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );

4406: FND_MESSAGE.SET_TOKEN('PARAMC1' , l_ref_REPH_rec.PARAMC1 );
4407: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4408: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4409: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4410: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4411: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4412: end if;
4413: -- get the message string and return it --
4414: l_repair_detail := FND_MESSAGE.GET;

Line 4411: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );

4407: FND_MESSAGE.SET_TOKEN('PARAMC2' , l_ref_REPH_rec.PARAMC2 );
4408: FND_MESSAGE.SET_TOKEN('PARAMC3' , l_ref_REPH_rec.PARAMC3 );
4409: FND_MESSAGE.SET_TOKEN('PARAMC4' , l_ref_REPH_rec.PARAMC4 );
4410: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4411: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4412: end if;
4413: -- get the message string and return it --
4414: l_repair_detail := FND_MESSAGE.GET;
4415: return l_repair_detail;

Line 4414: l_repair_detail := FND_MESSAGE.GET;

4410: FND_MESSAGE.SET_TOKEN('PARAMC5' , l_ref_REPH_rec.PARAMC5 );
4411: FND_MESSAGE.SET_TOKEN('PARAMC6' , l_ref_REPH_rec.PARAMC6 );
4412: end if;
4413: -- get the message string and return it --
4414: l_repair_detail := FND_MESSAGE.GET;
4415: return l_repair_detail;
4416:
4417: END GET_HISTORY_DETAIL;
4418: