1105: v_week_name Varchar2(100) ;
1106: BEGIN
1107:
1108: IF v_week_number = 1 then
1109: fnd_message.set_name('RLM','RLM_FIRST_WEEK');
1110: v_week_name :=fnd_message.get;
1111: ELSIF
1112: v_week_number = 2 then
1113: fnd_message.set_name('RLM','RLM_SECOND_WEEK');
1106: BEGIN
1107:
1108: IF v_week_number = 1 then
1109: fnd_message.set_name('RLM','RLM_FIRST_WEEK');
1110: v_week_name :=fnd_message.get;
1111: ELSIF
1112: v_week_number = 2 then
1113: fnd_message.set_name('RLM','RLM_SECOND_WEEK');
1114: v_week_name :=fnd_message.get;
1109: fnd_message.set_name('RLM','RLM_FIRST_WEEK');
1110: v_week_name :=fnd_message.get;
1111: ELSIF
1112: v_week_number = 2 then
1113: fnd_message.set_name('RLM','RLM_SECOND_WEEK');
1114: v_week_name :=fnd_message.get;
1115: ELSIF
1116: v_week_number = 3 then
1117: fnd_message.set_name('RLM','RLM_THIRD_WEEK');
1110: v_week_name :=fnd_message.get;
1111: ELSIF
1112: v_week_number = 2 then
1113: fnd_message.set_name('RLM','RLM_SECOND_WEEK');
1114: v_week_name :=fnd_message.get;
1115: ELSIF
1116: v_week_number = 3 then
1117: fnd_message.set_name('RLM','RLM_THIRD_WEEK');
1118: v_week_name :=fnd_message.get;
1113: fnd_message.set_name('RLM','RLM_SECOND_WEEK');
1114: v_week_name :=fnd_message.get;
1115: ELSIF
1116: v_week_number = 3 then
1117: fnd_message.set_name('RLM','RLM_THIRD_WEEK');
1118: v_week_name :=fnd_message.get;
1119: ELSIF
1120: v_week_number = 4 then
1121: fnd_message.set_name('RLM','RLM_FOURTH_WEEK');
1114: v_week_name :=fnd_message.get;
1115: ELSIF
1116: v_week_number = 3 then
1117: fnd_message.set_name('RLM','RLM_THIRD_WEEK');
1118: v_week_name :=fnd_message.get;
1119: ELSIF
1120: v_week_number = 4 then
1121: fnd_message.set_name('RLM','RLM_FOURTH_WEEK');
1122: v_week_name :=fnd_message.get;
1117: fnd_message.set_name('RLM','RLM_THIRD_WEEK');
1118: v_week_name :=fnd_message.get;
1119: ELSIF
1120: v_week_number = 4 then
1121: fnd_message.set_name('RLM','RLM_FOURTH_WEEK');
1122: v_week_name :=fnd_message.get;
1123: ELSIF
1124: v_week_number = 5 then
1125: fnd_message.set_name('RLM','RLM_FIFTH_WEEK');
1118: v_week_name :=fnd_message.get;
1119: ELSIF
1120: v_week_number = 4 then
1121: fnd_message.set_name('RLM','RLM_FOURTH_WEEK');
1122: v_week_name :=fnd_message.get;
1123: ELSIF
1124: v_week_number = 5 then
1125: fnd_message.set_name('RLM','RLM_FIFTH_WEEK');
1126: v_week_name :=fnd_message.get;
1121: fnd_message.set_name('RLM','RLM_FOURTH_WEEK');
1122: v_week_name :=fnd_message.get;
1123: ELSIF
1124: v_week_number = 5 then
1125: fnd_message.set_name('RLM','RLM_FIFTH_WEEK');
1126: v_week_name :=fnd_message.get;
1127: ELSIF
1128: v_week_number = 6 then
1129: fnd_message.set_name('RLM','RLM_SIXTH_WEEK');
1122: v_week_name :=fnd_message.get;
1123: ELSIF
1124: v_week_number = 5 then
1125: fnd_message.set_name('RLM','RLM_FIFTH_WEEK');
1126: v_week_name :=fnd_message.get;
1127: ELSIF
1128: v_week_number = 6 then
1129: fnd_message.set_name('RLM','RLM_SIXTH_WEEK');
1130: v_week_name :=fnd_message.get;
1125: fnd_message.set_name('RLM','RLM_FIFTH_WEEK');
1126: v_week_name :=fnd_message.get;
1127: ELSIF
1128: v_week_number = 6 then
1129: fnd_message.set_name('RLM','RLM_SIXTH_WEEK');
1130: v_week_name :=fnd_message.get;
1131: ELSIF
1132: v_week_number = 7 then
1133: fnd_message.set_name('RLM','RLM_SEVENTH_WEEK');
1126: v_week_name :=fnd_message.get;
1127: ELSIF
1128: v_week_number = 6 then
1129: fnd_message.set_name('RLM','RLM_SIXTH_WEEK');
1130: v_week_name :=fnd_message.get;
1131: ELSIF
1132: v_week_number = 7 then
1133: fnd_message.set_name('RLM','RLM_SEVENTH_WEEK');
1134: v_week_name :=fnd_message.get;
1129: fnd_message.set_name('RLM','RLM_SIXTH_WEEK');
1130: v_week_name :=fnd_message.get;
1131: ELSIF
1132: v_week_number = 7 then
1133: fnd_message.set_name('RLM','RLM_SEVENTH_WEEK');
1134: v_week_name :=fnd_message.get;
1135: ELSIF
1136: v_week_number = 8 then
1137: fnd_message.set_name('RLM','RLM_EIGHTH_WEEK');
1130: v_week_name :=fnd_message.get;
1131: ELSIF
1132: v_week_number = 7 then
1133: fnd_message.set_name('RLM','RLM_SEVENTH_WEEK');
1134: v_week_name :=fnd_message.get;
1135: ELSIF
1136: v_week_number = 8 then
1137: fnd_message.set_name('RLM','RLM_EIGHTH_WEEK');
1138: v_week_name :=fnd_message.get;
1133: fnd_message.set_name('RLM','RLM_SEVENTH_WEEK');
1134: v_week_name :=fnd_message.get;
1135: ELSIF
1136: v_week_number = 8 then
1137: fnd_message.set_name('RLM','RLM_EIGHTH_WEEK');
1138: v_week_name :=fnd_message.get;
1139: ELSIF
1140: v_week_number = 9 then
1141: fnd_message.set_name('RLM','RLM_NINTH_WEEK');
1134: v_week_name :=fnd_message.get;
1135: ELSIF
1136: v_week_number = 8 then
1137: fnd_message.set_name('RLM','RLM_EIGHTH_WEEK');
1138: v_week_name :=fnd_message.get;
1139: ELSIF
1140: v_week_number = 9 then
1141: fnd_message.set_name('RLM','RLM_NINTH_WEEK');
1142: v_week_name :=fnd_message.get;
1137: fnd_message.set_name('RLM','RLM_EIGHTH_WEEK');
1138: v_week_name :=fnd_message.get;
1139: ELSIF
1140: v_week_number = 9 then
1141: fnd_message.set_name('RLM','RLM_NINTH_WEEK');
1142: v_week_name :=fnd_message.get;
1143: ELSIF
1144: v_week_number = 10 then
1145: fnd_message.set_name('RLM','RLM_TENTH_WEEK');
1138: v_week_name :=fnd_message.get;
1139: ELSIF
1140: v_week_number = 9 then
1141: fnd_message.set_name('RLM','RLM_NINTH_WEEK');
1142: v_week_name :=fnd_message.get;
1143: ELSIF
1144: v_week_number = 10 then
1145: fnd_message.set_name('RLM','RLM_TENTH_WEEK');
1146: v_week_name :=fnd_message.get;
1141: fnd_message.set_name('RLM','RLM_NINTH_WEEK');
1142: v_week_name :=fnd_message.get;
1143: ELSIF
1144: v_week_number = 10 then
1145: fnd_message.set_name('RLM','RLM_TENTH_WEEK');
1146: v_week_name :=fnd_message.get;
1147: ELSIF
1148: v_week_number = 11 then
1149: fnd_message.set_name('RLM','RLM_ELEVENTH_WEEK');
1142: v_week_name :=fnd_message.get;
1143: ELSIF
1144: v_week_number = 10 then
1145: fnd_message.set_name('RLM','RLM_TENTH_WEEK');
1146: v_week_name :=fnd_message.get;
1147: ELSIF
1148: v_week_number = 11 then
1149: fnd_message.set_name('RLM','RLM_ELEVENTH_WEEK');
1150: v_week_name :=fnd_message.get;
1145: fnd_message.set_name('RLM','RLM_TENTH_WEEK');
1146: v_week_name :=fnd_message.get;
1147: ELSIF
1148: v_week_number = 11 then
1149: fnd_message.set_name('RLM','RLM_ELEVENTH_WEEK');
1150: v_week_name :=fnd_message.get;
1151: ELSIF
1152: v_week_number = 12 then
1153: fnd_message.set_name('RLM','RLM_TWELFTH_WEEK');
1146: v_week_name :=fnd_message.get;
1147: ELSIF
1148: v_week_number = 11 then
1149: fnd_message.set_name('RLM','RLM_ELEVENTH_WEEK');
1150: v_week_name :=fnd_message.get;
1151: ELSIF
1152: v_week_number = 12 then
1153: fnd_message.set_name('RLM','RLM_TWELFTH_WEEK');
1154: v_week_name :=fnd_message.get;
1149: fnd_message.set_name('RLM','RLM_ELEVENTH_WEEK');
1150: v_week_name :=fnd_message.get;
1151: ELSIF
1152: v_week_number = 12 then
1153: fnd_message.set_name('RLM','RLM_TWELFTH_WEEK');
1154: v_week_name :=fnd_message.get;
1155: ELSIF
1156: v_week_number = 13 then
1157: fnd_message.set_name('RLM','RLM_THIRTEENTH_WEEK');
1150: v_week_name :=fnd_message.get;
1151: ELSIF
1152: v_week_number = 12 then
1153: fnd_message.set_name('RLM','RLM_TWELFTH_WEEK');
1154: v_week_name :=fnd_message.get;
1155: ELSIF
1156: v_week_number = 13 then
1157: fnd_message.set_name('RLM','RLM_THIRTEENTH_WEEK');
1158: v_week_name :=fnd_message.get;
1153: fnd_message.set_name('RLM','RLM_TWELFTH_WEEK');
1154: v_week_name :=fnd_message.get;
1155: ELSIF
1156: v_week_number = 13 then
1157: fnd_message.set_name('RLM','RLM_THIRTEENTH_WEEK');
1158: v_week_name :=fnd_message.get;
1159: ELSE
1160: RETURN(NULL);
1161: END IF ;
1154: v_week_name :=fnd_message.get;
1155: ELSIF
1156: v_week_number = 13 then
1157: fnd_message.set_name('RLM','RLM_THIRTEENTH_WEEK');
1158: v_week_name :=fnd_message.get;
1159: ELSE
1160: RETURN(NULL);
1161: END IF ;
1162: RETURN (v_week_name);