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

Line 129: FND_MESSAGE.SET_NAME('GMP','PS_PASTDUE');

125:
126: X_workdate1 := GMA_GLOBAL_GRP.SY$MIN_DATE;
127:
128: X_workdate2 := TO_DATE(TO_CHAR(SYSDATE,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
129: FND_MESSAGE.SET_NAME('GMP','PS_PASTDUE');
130: X_period := FND_MESSAGE.GET;
131: IF (X_rows = 0) THEN
132: RETURN(X_rows);
133: END IF;

Line 130: X_period := FND_MESSAGE.GET;

126: X_workdate1 := GMA_GLOBAL_GRP.SY$MIN_DATE;
127:
128: X_workdate2 := TO_DATE(TO_CHAR(SYSDATE,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
129: FND_MESSAGE.SET_NAME('GMP','PS_PASTDUE');
130: X_period := FND_MESSAGE.GET;
131: IF (X_rows = 0) THEN
132: RETURN(X_rows);
133: END IF;
134:

Line 147: FND_MESSAGE.SET_NAME('GMP','PS_PASTDUE');

143: X_no_days := X_no_days + 7 - X_n + 1;
144: X_tot_periods := X_no_days + X_no_weeks + X_no_4weeks + X_no_13weeks;
145: period_start_date_tab(1) := X_workdate1;
146: period_end_date_tab(1) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS'); /* yesterday */
147: FND_MESSAGE.SET_NAME('GMP','PS_PASTDUE');
148: period_name_tab(1) := FND_MESSAGE.GET;
149:
150: -- TKW 12/26/2003 B3337215 - Port B3306526 to 11.5.10L.
151: -- Modified following condition for the case X_no_days = 1 to work

Line 148: period_name_tab(1) := FND_MESSAGE.GET;

144: X_tot_periods := X_no_days + X_no_weeks + X_no_4weeks + X_no_13weeks;
145: period_start_date_tab(1) := X_workdate1;
146: period_end_date_tab(1) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS'); /* yesterday */
147: FND_MESSAGE.SET_NAME('GMP','PS_PASTDUE');
148: period_name_tab(1) := FND_MESSAGE.GET;
149:
150: -- TKW 12/26/2003 B3337215 - Port B3306526 to 11.5.10L.
151: -- Modified following condition for the case X_no_days = 1 to work
152: IF (X_no_days > 1) THEN

Line 173: FND_MESSAGE.SET_NAME('GMP','PS_SUNDAY');

169: /*B3021669 - Sowmya - GMP:GMP:DAYS OF THE WEEK UNTRANSLATED IN MPS MATERIAL ACTIVITY INQUIRY*/
170: /* Based on the period name the day will be picked from the message dictionary.
171: This change has been done to facilitate the translation of messages*/
172: IF ( period_name = 'SUNDAY') THEN
173: FND_MESSAGE.SET_NAME('GMP','PS_SUNDAY');
174: period_name_tab(X_i) := FND_MESSAGE.GET;
175: ELSIF ( period_name = 'MONDAY') THEN
176: FND_MESSAGE.SET_NAME('GMP','PS_MONDAY');
177: period_name_tab(X_i) := FND_MESSAGE.GET;

Line 174: period_name_tab(X_i) := FND_MESSAGE.GET;

170: /* Based on the period name the day will be picked from the message dictionary.
171: This change has been done to facilitate the translation of messages*/
172: IF ( period_name = 'SUNDAY') THEN
173: FND_MESSAGE.SET_NAME('GMP','PS_SUNDAY');
174: period_name_tab(X_i) := FND_MESSAGE.GET;
175: ELSIF ( period_name = 'MONDAY') THEN
176: FND_MESSAGE.SET_NAME('GMP','PS_MONDAY');
177: period_name_tab(X_i) := FND_MESSAGE.GET;
178: ELSIF ( period_name = 'TUESDAY') THEN

Line 176: FND_MESSAGE.SET_NAME('GMP','PS_MONDAY');

172: IF ( period_name = 'SUNDAY') THEN
173: FND_MESSAGE.SET_NAME('GMP','PS_SUNDAY');
174: period_name_tab(X_i) := FND_MESSAGE.GET;
175: ELSIF ( period_name = 'MONDAY') THEN
176: FND_MESSAGE.SET_NAME('GMP','PS_MONDAY');
177: period_name_tab(X_i) := FND_MESSAGE.GET;
178: ELSIF ( period_name = 'TUESDAY') THEN
179: FND_MESSAGE.SET_NAME('GMP','PS_TUESDAY');
180: period_name_tab(X_i) := FND_MESSAGE.GET;

Line 177: period_name_tab(X_i) := FND_MESSAGE.GET;

173: FND_MESSAGE.SET_NAME('GMP','PS_SUNDAY');
174: period_name_tab(X_i) := FND_MESSAGE.GET;
175: ELSIF ( period_name = 'MONDAY') THEN
176: FND_MESSAGE.SET_NAME('GMP','PS_MONDAY');
177: period_name_tab(X_i) := FND_MESSAGE.GET;
178: ELSIF ( period_name = 'TUESDAY') THEN
179: FND_MESSAGE.SET_NAME('GMP','PS_TUESDAY');
180: period_name_tab(X_i) := FND_MESSAGE.GET;
181: ELSIF ( period_name = 'WEDNESDAY') THEN

Line 179: FND_MESSAGE.SET_NAME('GMP','PS_TUESDAY');

175: ELSIF ( period_name = 'MONDAY') THEN
176: FND_MESSAGE.SET_NAME('GMP','PS_MONDAY');
177: period_name_tab(X_i) := FND_MESSAGE.GET;
178: ELSIF ( period_name = 'TUESDAY') THEN
179: FND_MESSAGE.SET_NAME('GMP','PS_TUESDAY');
180: period_name_tab(X_i) := FND_MESSAGE.GET;
181: ELSIF ( period_name = 'WEDNESDAY') THEN
182: FND_MESSAGE.SET_NAME('GMP','PS_WEDNESDAY');
183: period_name_tab(X_i) := FND_MESSAGE.GET;

Line 180: period_name_tab(X_i) := FND_MESSAGE.GET;

176: FND_MESSAGE.SET_NAME('GMP','PS_MONDAY');
177: period_name_tab(X_i) := FND_MESSAGE.GET;
178: ELSIF ( period_name = 'TUESDAY') THEN
179: FND_MESSAGE.SET_NAME('GMP','PS_TUESDAY');
180: period_name_tab(X_i) := FND_MESSAGE.GET;
181: ELSIF ( period_name = 'WEDNESDAY') THEN
182: FND_MESSAGE.SET_NAME('GMP','PS_WEDNESDAY');
183: period_name_tab(X_i) := FND_MESSAGE.GET;
184: ELSIF ( period_name = 'THURSDAY') THEN

Line 182: FND_MESSAGE.SET_NAME('GMP','PS_WEDNESDAY');

178: ELSIF ( period_name = 'TUESDAY') THEN
179: FND_MESSAGE.SET_NAME('GMP','PS_TUESDAY');
180: period_name_tab(X_i) := FND_MESSAGE.GET;
181: ELSIF ( period_name = 'WEDNESDAY') THEN
182: FND_MESSAGE.SET_NAME('GMP','PS_WEDNESDAY');
183: period_name_tab(X_i) := FND_MESSAGE.GET;
184: ELSIF ( period_name = 'THURSDAY') THEN
185: FND_MESSAGE.SET_NAME('GMP','PS_THURSDAY');
186: period_name_tab(X_i) := FND_MESSAGE.GET;

Line 183: period_name_tab(X_i) := FND_MESSAGE.GET;

179: FND_MESSAGE.SET_NAME('GMP','PS_TUESDAY');
180: period_name_tab(X_i) := FND_MESSAGE.GET;
181: ELSIF ( period_name = 'WEDNESDAY') THEN
182: FND_MESSAGE.SET_NAME('GMP','PS_WEDNESDAY');
183: period_name_tab(X_i) := FND_MESSAGE.GET;
184: ELSIF ( period_name = 'THURSDAY') THEN
185: FND_MESSAGE.SET_NAME('GMP','PS_THURSDAY');
186: period_name_tab(X_i) := FND_MESSAGE.GET;
187: ELSIF ( period_name = 'FRIDAY') THEN

Line 185: FND_MESSAGE.SET_NAME('GMP','PS_THURSDAY');

181: ELSIF ( period_name = 'WEDNESDAY') THEN
182: FND_MESSAGE.SET_NAME('GMP','PS_WEDNESDAY');
183: period_name_tab(X_i) := FND_MESSAGE.GET;
184: ELSIF ( period_name = 'THURSDAY') THEN
185: FND_MESSAGE.SET_NAME('GMP','PS_THURSDAY');
186: period_name_tab(X_i) := FND_MESSAGE.GET;
187: ELSIF ( period_name = 'FRIDAY') THEN
188: FND_MESSAGE.SET_NAME('GMP','PS_FRIDAY');
189: period_name_tab(X_i) := FND_MESSAGE.GET;

Line 186: period_name_tab(X_i) := FND_MESSAGE.GET;

182: FND_MESSAGE.SET_NAME('GMP','PS_WEDNESDAY');
183: period_name_tab(X_i) := FND_MESSAGE.GET;
184: ELSIF ( period_name = 'THURSDAY') THEN
185: FND_MESSAGE.SET_NAME('GMP','PS_THURSDAY');
186: period_name_tab(X_i) := FND_MESSAGE.GET;
187: ELSIF ( period_name = 'FRIDAY') THEN
188: FND_MESSAGE.SET_NAME('GMP','PS_FRIDAY');
189: period_name_tab(X_i) := FND_MESSAGE.GET;
190: ELSIF ( period_name = 'SATURDAY') THEN

Line 188: FND_MESSAGE.SET_NAME('GMP','PS_FRIDAY');

184: ELSIF ( period_name = 'THURSDAY') THEN
185: FND_MESSAGE.SET_NAME('GMP','PS_THURSDAY');
186: period_name_tab(X_i) := FND_MESSAGE.GET;
187: ELSIF ( period_name = 'FRIDAY') THEN
188: FND_MESSAGE.SET_NAME('GMP','PS_FRIDAY');
189: period_name_tab(X_i) := FND_MESSAGE.GET;
190: ELSIF ( period_name = 'SATURDAY') THEN
191: FND_MESSAGE.SET_NAME('GMP','PS_SATURDAY');
192: period_name_tab(X_i) := FND_MESSAGE.GET;

Line 189: period_name_tab(X_i) := FND_MESSAGE.GET;

185: FND_MESSAGE.SET_NAME('GMP','PS_THURSDAY');
186: period_name_tab(X_i) := FND_MESSAGE.GET;
187: ELSIF ( period_name = 'FRIDAY') THEN
188: FND_MESSAGE.SET_NAME('GMP','PS_FRIDAY');
189: period_name_tab(X_i) := FND_MESSAGE.GET;
190: ELSIF ( period_name = 'SATURDAY') THEN
191: FND_MESSAGE.SET_NAME('GMP','PS_SATURDAY');
192: period_name_tab(X_i) := FND_MESSAGE.GET;
193: END IF;

Line 191: FND_MESSAGE.SET_NAME('GMP','PS_SATURDAY');

187: ELSIF ( period_name = 'FRIDAY') THEN
188: FND_MESSAGE.SET_NAME('GMP','PS_FRIDAY');
189: period_name_tab(X_i) := FND_MESSAGE.GET;
190: ELSIF ( period_name = 'SATURDAY') THEN
191: FND_MESSAGE.SET_NAME('GMP','PS_SATURDAY');
192: period_name_tab(X_i) := FND_MESSAGE.GET;
193: END IF;
194:
195: END LOOP;

Line 192: period_name_tab(X_i) := FND_MESSAGE.GET;

188: FND_MESSAGE.SET_NAME('GMP','PS_FRIDAY');
189: period_name_tab(X_i) := FND_MESSAGE.GET;
190: ELSIF ( period_name = 'SATURDAY') THEN
191: FND_MESSAGE.SET_NAME('GMP','PS_SATURDAY');
192: period_name_tab(X_i) := FND_MESSAGE.GET;
193: END IF;
194:
195: END LOOP;
196: ELSE

Line 208: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');

204: X_date1 := period_end_date_tab(X_j);
205: period_start_date_tab(X_i) := X_date1;
206: X_date2 := period_start_date_tab(X_i) + 7;
207: period_end_date_tab(X_i) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
208: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');
209: period_name_tab(X_i) := FND_MESSAGE.GET||' '||TO_CHAR(X_date2,'WW');
210: END LOOP;
211: ELSE
212: IF (X_no_days = 0) THEN

Line 209: period_name_tab(X_i) := FND_MESSAGE.GET||' '||TO_CHAR(X_date2,'WW');

205: period_start_date_tab(X_i) := X_date1;
206: X_date2 := period_start_date_tab(X_i) + 7;
207: period_end_date_tab(X_i) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
208: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');
209: period_name_tab(X_i) := FND_MESSAGE.GET||' '||TO_CHAR(X_date2,'WW');
210: END LOOP;
211: ELSE
212: IF (X_no_days = 0) THEN
213: X_wcount := 2;

Line 228: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');

224: X_date1 := period_end_date_tab(X_j);
225: period_start_date_tab(X_i) := X_date1;
226: X_date2 := period_start_date_tab(X_i) + 28;
227: period_end_date_tab(X_i) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
228: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');
229: period_name_tab(X_i) := FND_MESSAGE.GET||' '||LPAD(TO_CHAR(TO_NUMBER(TO_CHAR(X_date1,'WW'))+1),2,'0')||'-'||TO_CHAR(X_date2,'WW');
230: END LOOP;
231: ELSE
232: IF (X_no_days = 0 AND X_no_weeks = 0) THEN

Line 229: period_name_tab(X_i) := FND_MESSAGE.GET||' '||LPAD(TO_CHAR(TO_NUMBER(TO_CHAR(X_date1,'WW'))+1),2,'0')||'-'||TO_CHAR(X_date2,'WW');

225: period_start_date_tab(X_i) := X_date1;
226: X_date2 := period_start_date_tab(X_i) + 28;
227: period_end_date_tab(X_i) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
228: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');
229: period_name_tab(X_i) := FND_MESSAGE.GET||' '||LPAD(TO_CHAR(TO_NUMBER(TO_CHAR(X_date1,'WW'))+1),2,'0')||'-'||TO_CHAR(X_date2,'WW');
230: END LOOP;
231: ELSE
232: IF (X_no_days = 0 AND X_no_weeks = 0) THEN
233: X_mcount := 2;

Line 250: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');

246: X_date1 := period_end_date_tab(X_j);
247: period_start_date_tab(X_i) := X_date1;
248: X_date2 := period_start_date_tab(X_i) + 91;
249: period_end_date_tab(X_i) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
250: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');
251: period_name_tab(X_i) := FND_MESSAGE.GET||' '||LPAD(TO_CHAR(TO_NUMBER(TO_CHAR(X_date1,'WW'))+1),2,'0')||'-'||TO_CHAR(X_date2,'WW');
252: END LOOP;
253: END IF;
254:

Line 251: period_name_tab(X_i) := FND_MESSAGE.GET||' '||LPAD(TO_CHAR(TO_NUMBER(TO_CHAR(X_date1,'WW'))+1),2,'0')||'-'||TO_CHAR(X_date2,'WW');

247: period_start_date_tab(X_i) := X_date1;
248: X_date2 := period_start_date_tab(X_i) + 91;
249: period_end_date_tab(X_i) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
250: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');
251: period_name_tab(X_i) := FND_MESSAGE.GET||' '||LPAD(TO_CHAR(TO_NUMBER(TO_CHAR(X_date1,'WW'))+1),2,'0')||'-'||TO_CHAR(X_date2,'WW');
252: END LOOP;
253: END IF;
254:
255: OPEN Cur_check_hdr;

Line 1016: FND_MESSAGE.SET_NAME('GMP','PS_PASTDUE');

1012:
1013: X_workdate1 := GMA_GLOBAL_GRP.SY$MIN_DATE;
1014:
1015: X_workdate2 := TO_DATE(TO_CHAR(SYSDATE,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
1016: FND_MESSAGE.SET_NAME('GMP','PS_PASTDUE');
1017: X_period := FND_MESSAGE.GET;
1018: IF (X_rows = 0) THEN
1019: RETURN(X_rows);
1020: END IF;

Line 1017: X_period := FND_MESSAGE.GET;

1013: X_workdate1 := GMA_GLOBAL_GRP.SY$MIN_DATE;
1014:
1015: X_workdate2 := TO_DATE(TO_CHAR(SYSDATE,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
1016: FND_MESSAGE.SET_NAME('GMP','PS_PASTDUE');
1017: X_period := FND_MESSAGE.GET;
1018: IF (X_rows = 0) THEN
1019: RETURN(X_rows);
1020: END IF;
1021:

Line 1035: FND_MESSAGE.SET_NAME('GMP','PS_PASTDUE');

1031: X_no_days := X_no_days + 7 - X_n + 1;
1032: X_tot_periods := X_no_days + X_no_weeks + X_no_4weeks + X_no_13weeks;
1033: period_start_date_tab(1) := X_workdate1;
1034: period_end_date_tab(1) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
1035: FND_MESSAGE.SET_NAME('GMP','PS_PASTDUE');
1036: period_name_tab(1) := FND_MESSAGE.GET;
1037:
1038: -- TKW 12/26/2003 B3337215 - Port B3306526 to 11.5.10L.
1039: -- Modified following condition for the case X_no_days = 1 to work

Line 1036: period_name_tab(1) := FND_MESSAGE.GET;

1032: X_tot_periods := X_no_days + X_no_weeks + X_no_4weeks + X_no_13weeks;
1033: period_start_date_tab(1) := X_workdate1;
1034: period_end_date_tab(1) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
1035: FND_MESSAGE.SET_NAME('GMP','PS_PASTDUE');
1036: period_name_tab(1) := FND_MESSAGE.GET;
1037:
1038: -- TKW 12/26/2003 B3337215 - Port B3306526 to 11.5.10L.
1039: -- Modified following condition for the case X_no_days = 1 to work
1040: IF (X_no_days > 1) THEN

Line 1062: FND_MESSAGE.SET_NAME('GMP','PS_SUNDAY');

1058: /* Based on the period name the day will be picked from the message dictionary.
1059: This change has been done to facilitate the translation of messages*/
1060:
1061: IF ( period_name = 'SUNDAY') THEN
1062: FND_MESSAGE.SET_NAME('GMP','PS_SUNDAY');
1063: period_name_tab(X_i) := FND_MESSAGE.GET;
1064: ELSIF ( period_name = 'MONDAY') THEN
1065: FND_MESSAGE.SET_NAME('GMP','PS_MONDAY');
1066: period_name_tab(X_i) := FND_MESSAGE.GET;

Line 1063: period_name_tab(X_i) := FND_MESSAGE.GET;

1059: This change has been done to facilitate the translation of messages*/
1060:
1061: IF ( period_name = 'SUNDAY') THEN
1062: FND_MESSAGE.SET_NAME('GMP','PS_SUNDAY');
1063: period_name_tab(X_i) := FND_MESSAGE.GET;
1064: ELSIF ( period_name = 'MONDAY') THEN
1065: FND_MESSAGE.SET_NAME('GMP','PS_MONDAY');
1066: period_name_tab(X_i) := FND_MESSAGE.GET;
1067: ELSIF ( period_name = 'TUESDAY') THEN

Line 1065: FND_MESSAGE.SET_NAME('GMP','PS_MONDAY');

1061: IF ( period_name = 'SUNDAY') THEN
1062: FND_MESSAGE.SET_NAME('GMP','PS_SUNDAY');
1063: period_name_tab(X_i) := FND_MESSAGE.GET;
1064: ELSIF ( period_name = 'MONDAY') THEN
1065: FND_MESSAGE.SET_NAME('GMP','PS_MONDAY');
1066: period_name_tab(X_i) := FND_MESSAGE.GET;
1067: ELSIF ( period_name = 'TUESDAY') THEN
1068: FND_MESSAGE.SET_NAME('GMP','PS_TUESDAY');
1069: period_name_tab(X_i) := FND_MESSAGE.GET;

Line 1066: period_name_tab(X_i) := FND_MESSAGE.GET;

1062: FND_MESSAGE.SET_NAME('GMP','PS_SUNDAY');
1063: period_name_tab(X_i) := FND_MESSAGE.GET;
1064: ELSIF ( period_name = 'MONDAY') THEN
1065: FND_MESSAGE.SET_NAME('GMP','PS_MONDAY');
1066: period_name_tab(X_i) := FND_MESSAGE.GET;
1067: ELSIF ( period_name = 'TUESDAY') THEN
1068: FND_MESSAGE.SET_NAME('GMP','PS_TUESDAY');
1069: period_name_tab(X_i) := FND_MESSAGE.GET;
1070: ELSIF ( period_name = 'WEDNESDAY') THEN

Line 1068: FND_MESSAGE.SET_NAME('GMP','PS_TUESDAY');

1064: ELSIF ( period_name = 'MONDAY') THEN
1065: FND_MESSAGE.SET_NAME('GMP','PS_MONDAY');
1066: period_name_tab(X_i) := FND_MESSAGE.GET;
1067: ELSIF ( period_name = 'TUESDAY') THEN
1068: FND_MESSAGE.SET_NAME('GMP','PS_TUESDAY');
1069: period_name_tab(X_i) := FND_MESSAGE.GET;
1070: ELSIF ( period_name = 'WEDNESDAY') THEN
1071: FND_MESSAGE.SET_NAME('GMP','PS_WEDNESDAY');
1072: period_name_tab(X_i) := FND_MESSAGE.GET;

Line 1069: period_name_tab(X_i) := FND_MESSAGE.GET;

1065: FND_MESSAGE.SET_NAME('GMP','PS_MONDAY');
1066: period_name_tab(X_i) := FND_MESSAGE.GET;
1067: ELSIF ( period_name = 'TUESDAY') THEN
1068: FND_MESSAGE.SET_NAME('GMP','PS_TUESDAY');
1069: period_name_tab(X_i) := FND_MESSAGE.GET;
1070: ELSIF ( period_name = 'WEDNESDAY') THEN
1071: FND_MESSAGE.SET_NAME('GMP','PS_WEDNESDAY');
1072: period_name_tab(X_i) := FND_MESSAGE.GET;
1073: ELSIF ( period_name = 'THURSDAY') THEN

Line 1071: FND_MESSAGE.SET_NAME('GMP','PS_WEDNESDAY');

1067: ELSIF ( period_name = 'TUESDAY') THEN
1068: FND_MESSAGE.SET_NAME('GMP','PS_TUESDAY');
1069: period_name_tab(X_i) := FND_MESSAGE.GET;
1070: ELSIF ( period_name = 'WEDNESDAY') THEN
1071: FND_MESSAGE.SET_NAME('GMP','PS_WEDNESDAY');
1072: period_name_tab(X_i) := FND_MESSAGE.GET;
1073: ELSIF ( period_name = 'THURSDAY') THEN
1074: FND_MESSAGE.SET_NAME('GMP','PS_THURSDAY');
1075: period_name_tab(X_i) := FND_MESSAGE.GET;

Line 1072: period_name_tab(X_i) := FND_MESSAGE.GET;

1068: FND_MESSAGE.SET_NAME('GMP','PS_TUESDAY');
1069: period_name_tab(X_i) := FND_MESSAGE.GET;
1070: ELSIF ( period_name = 'WEDNESDAY') THEN
1071: FND_MESSAGE.SET_NAME('GMP','PS_WEDNESDAY');
1072: period_name_tab(X_i) := FND_MESSAGE.GET;
1073: ELSIF ( period_name = 'THURSDAY') THEN
1074: FND_MESSAGE.SET_NAME('GMP','PS_THURSDAY');
1075: period_name_tab(X_i) := FND_MESSAGE.GET;
1076: ELSIF ( period_name = 'FRIDAY') THEN

Line 1074: FND_MESSAGE.SET_NAME('GMP','PS_THURSDAY');

1070: ELSIF ( period_name = 'WEDNESDAY') THEN
1071: FND_MESSAGE.SET_NAME('GMP','PS_WEDNESDAY');
1072: period_name_tab(X_i) := FND_MESSAGE.GET;
1073: ELSIF ( period_name = 'THURSDAY') THEN
1074: FND_MESSAGE.SET_NAME('GMP','PS_THURSDAY');
1075: period_name_tab(X_i) := FND_MESSAGE.GET;
1076: ELSIF ( period_name = 'FRIDAY') THEN
1077: FND_MESSAGE.SET_NAME('GMP','PS_FRIDAY');
1078: period_name_tab(X_i) := FND_MESSAGE.GET;

Line 1075: period_name_tab(X_i) := FND_MESSAGE.GET;

1071: FND_MESSAGE.SET_NAME('GMP','PS_WEDNESDAY');
1072: period_name_tab(X_i) := FND_MESSAGE.GET;
1073: ELSIF ( period_name = 'THURSDAY') THEN
1074: FND_MESSAGE.SET_NAME('GMP','PS_THURSDAY');
1075: period_name_tab(X_i) := FND_MESSAGE.GET;
1076: ELSIF ( period_name = 'FRIDAY') THEN
1077: FND_MESSAGE.SET_NAME('GMP','PS_FRIDAY');
1078: period_name_tab(X_i) := FND_MESSAGE.GET;
1079: ELSIF ( period_name = 'SATURDAY') THEN

Line 1077: FND_MESSAGE.SET_NAME('GMP','PS_FRIDAY');

1073: ELSIF ( period_name = 'THURSDAY') THEN
1074: FND_MESSAGE.SET_NAME('GMP','PS_THURSDAY');
1075: period_name_tab(X_i) := FND_MESSAGE.GET;
1076: ELSIF ( period_name = 'FRIDAY') THEN
1077: FND_MESSAGE.SET_NAME('GMP','PS_FRIDAY');
1078: period_name_tab(X_i) := FND_MESSAGE.GET;
1079: ELSIF ( period_name = 'SATURDAY') THEN
1080: FND_MESSAGE.SET_NAME('GMP','PS_SATURDAY');
1081: period_name_tab(X_i) := FND_MESSAGE.GET;

Line 1078: period_name_tab(X_i) := FND_MESSAGE.GET;

1074: FND_MESSAGE.SET_NAME('GMP','PS_THURSDAY');
1075: period_name_tab(X_i) := FND_MESSAGE.GET;
1076: ELSIF ( period_name = 'FRIDAY') THEN
1077: FND_MESSAGE.SET_NAME('GMP','PS_FRIDAY');
1078: period_name_tab(X_i) := FND_MESSAGE.GET;
1079: ELSIF ( period_name = 'SATURDAY') THEN
1080: FND_MESSAGE.SET_NAME('GMP','PS_SATURDAY');
1081: period_name_tab(X_i) := FND_MESSAGE.GET;
1082: END IF;

Line 1080: FND_MESSAGE.SET_NAME('GMP','PS_SATURDAY');

1076: ELSIF ( period_name = 'FRIDAY') THEN
1077: FND_MESSAGE.SET_NAME('GMP','PS_FRIDAY');
1078: period_name_tab(X_i) := FND_MESSAGE.GET;
1079: ELSIF ( period_name = 'SATURDAY') THEN
1080: FND_MESSAGE.SET_NAME('GMP','PS_SATURDAY');
1081: period_name_tab(X_i) := FND_MESSAGE.GET;
1082: END IF;
1083:
1084: END LOOP;

Line 1081: period_name_tab(X_i) := FND_MESSAGE.GET;

1077: FND_MESSAGE.SET_NAME('GMP','PS_FRIDAY');
1078: period_name_tab(X_i) := FND_MESSAGE.GET;
1079: ELSIF ( period_name = 'SATURDAY') THEN
1080: FND_MESSAGE.SET_NAME('GMP','PS_SATURDAY');
1081: period_name_tab(X_i) := FND_MESSAGE.GET;
1082: END IF;
1083:
1084: END LOOP;
1085: ELSE

Line 1097: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');

1093: X_date1 := period_end_date_tab(X_j);
1094: period_start_date_tab(X_i) := X_date1;
1095: X_date2 := period_start_date_tab(X_i) + 7;
1096: period_end_date_tab(X_i) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
1097: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');
1098: period_name_tab(X_i) := FND_MESSAGE.GET||' '||TO_CHAR(X_date2,'WW');
1099: END LOOP;
1100: ELSE
1101: IF (X_no_days = 0) THEN

Line 1098: period_name_tab(X_i) := FND_MESSAGE.GET||' '||TO_CHAR(X_date2,'WW');

1094: period_start_date_tab(X_i) := X_date1;
1095: X_date2 := period_start_date_tab(X_i) + 7;
1096: period_end_date_tab(X_i) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
1097: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');
1098: period_name_tab(X_i) := FND_MESSAGE.GET||' '||TO_CHAR(X_date2,'WW');
1099: END LOOP;
1100: ELSE
1101: IF (X_no_days = 0) THEN
1102: X_wcount := 2;

Line 1117: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');

1113: X_date1 := period_end_date_tab(X_j);
1114: period_start_date_tab(X_i) := X_date1;
1115: X_date2 := period_start_date_tab(X_i) + 28;
1116: period_end_date_tab(X_i) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
1117: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');
1118: period_name_tab(X_i) := FND_MESSAGE.GET||' '||LPAD(TO_CHAR(TO_NUMBER(TO_CHAR(X_date1,'WW'))+1),2,'0')||'-'||TO_CHAR(X_date2,'WW');
1119: END LOOP;
1120: ELSE
1121: IF (X_no_days = 0 AND X_no_weeks = 0) THEN

Line 1118: period_name_tab(X_i) := FND_MESSAGE.GET||' '||LPAD(TO_CHAR(TO_NUMBER(TO_CHAR(X_date1,'WW'))+1),2,'0')||'-'||TO_CHAR(X_date2,'WW');

1114: period_start_date_tab(X_i) := X_date1;
1115: X_date2 := period_start_date_tab(X_i) + 28;
1116: period_end_date_tab(X_i) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
1117: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');
1118: period_name_tab(X_i) := FND_MESSAGE.GET||' '||LPAD(TO_CHAR(TO_NUMBER(TO_CHAR(X_date1,'WW'))+1),2,'0')||'-'||TO_CHAR(X_date2,'WW');
1119: END LOOP;
1120: ELSE
1121: IF (X_no_days = 0 AND X_no_weeks = 0) THEN
1122: X_mcount := 2;

Line 1139: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');

1135: X_date1 := period_end_date_tab(X_j);
1136: period_start_date_tab(X_i) := X_date1;
1137: X_date2 := period_start_date_tab(X_i) + 91;
1138: period_end_date_tab(X_i) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
1139: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');
1140: period_name_tab(X_i) := FND_MESSAGE.GET||' '||LPAD(TO_CHAR(TO_NUMBER(TO_CHAR(X_date1,'WW'))+1),2,'0')||'-'||TO_CHAR(X_date2,'WW');
1141: END LOOP;
1142: END IF;
1143:

Line 1140: period_name_tab(X_i) := FND_MESSAGE.GET||' '||LPAD(TO_CHAR(TO_NUMBER(TO_CHAR(X_date1,'WW'))+1),2,'0')||'-'||TO_CHAR(X_date2,'WW');

1136: period_start_date_tab(X_i) := X_date1;
1137: X_date2 := period_start_date_tab(X_i) + 91;
1138: period_end_date_tab(X_i) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
1139: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');
1140: period_name_tab(X_i) := FND_MESSAGE.GET||' '||LPAD(TO_CHAR(TO_NUMBER(TO_CHAR(X_date1,'WW'))+1),2,'0')||'-'||TO_CHAR(X_date2,'WW');
1141: END LOOP;
1142: END IF;
1143:
1144: OPEN Cur_check_hdr;