DBA Data[Home] [Help]

APPS.RLM_COMP_SCH_TO_DEMAND_SV dependencies on FND_MESSAGE

Line 1109: fnd_message.set_name('RLM','RLM_FIRST_WEEK');

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');

Line 1110: v_week_name :=fnd_message.get;

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;

Line 1113: fnd_message.set_name('RLM','RLM_SECOND_WEEK');

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');

Line 1114: v_week_name :=fnd_message.get;

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;

Line 1117: fnd_message.set_name('RLM','RLM_THIRD_WEEK');

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');

Line 1118: v_week_name :=fnd_message.get;

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;

Line 1121: fnd_message.set_name('RLM','RLM_FOURTH_WEEK');

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');

Line 1122: v_week_name :=fnd_message.get;

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;

Line 1125: fnd_message.set_name('RLM','RLM_FIFTH_WEEK');

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');

Line 1126: v_week_name :=fnd_message.get;

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;

Line 1129: fnd_message.set_name('RLM','RLM_SIXTH_WEEK');

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');

Line 1130: v_week_name :=fnd_message.get;

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;

Line 1133: fnd_message.set_name('RLM','RLM_SEVENTH_WEEK');

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');

Line 1134: v_week_name :=fnd_message.get;

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;

Line 1137: fnd_message.set_name('RLM','RLM_EIGHTH_WEEK');

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');

Line 1138: v_week_name :=fnd_message.get;

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;

Line 1141: fnd_message.set_name('RLM','RLM_NINTH_WEEK');

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');

Line 1142: v_week_name :=fnd_message.get;

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;

Line 1145: fnd_message.set_name('RLM','RLM_TENTH_WEEK');

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');

Line 1146: v_week_name :=fnd_message.get;

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;

Line 1149: fnd_message.set_name('RLM','RLM_ELEVENTH_WEEK');

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');

Line 1150: v_week_name :=fnd_message.get;

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;

Line 1153: fnd_message.set_name('RLM','RLM_TWELFTH_WEEK');

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');

Line 1154: v_week_name :=fnd_message.get;

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;

Line 1157: fnd_message.set_name('RLM','RLM_THIRTEENTH_WEEK');

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 ;

Line 1158: v_week_name :=fnd_message.get;

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);