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 131: FND_MESSAGE.SET_NAME('GMP','PS_PASTDUE');

127: /* Use the hard coded value for bug 12399670 Vijay Induri */
128: X_workdate1 := TO_DATE ( (SYSDATE-(17*365)), 'DD/MM/YYYY HH24:MI:SS') ;
129:
130: X_workdate2 := TO_DATE(TO_CHAR(SYSDATE,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
131: FND_MESSAGE.SET_NAME('GMP','PS_PASTDUE');
132: X_period := FND_MESSAGE.GET;
133: IF (X_rows = 0) THEN
134: RETURN(X_rows);
135: END IF;

Line 132: X_period := FND_MESSAGE.GET;

128: X_workdate1 := TO_DATE ( (SYSDATE-(17*365)), 'DD/MM/YYYY HH24:MI:SS') ;
129:
130: X_workdate2 := TO_DATE(TO_CHAR(SYSDATE,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
131: FND_MESSAGE.SET_NAME('GMP','PS_PASTDUE');
132: X_period := FND_MESSAGE.GET;
133: IF (X_rows = 0) THEN
134: RETURN(X_rows);
135: END IF;
136:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

226: X_date1 := period_end_date_tab(X_j);
227: period_start_date_tab(X_i) := X_date1;
228: X_date2 := period_start_date_tab(X_i) + 28;
229: period_end_date_tab(X_i) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
230: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');
231: 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');
232: END LOOP;
233: ELSE
234: IF (X_no_days = 0 AND X_no_weeks = 0) THEN

Line 231: 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');

227: period_start_date_tab(X_i) := X_date1;
228: X_date2 := period_start_date_tab(X_i) + 28;
229: period_end_date_tab(X_i) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
230: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');
231: 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');
232: END LOOP;
233: ELSE
234: IF (X_no_days = 0 AND X_no_weeks = 0) THEN
235: X_mcount := 2;

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

248: X_date1 := period_end_date_tab(X_j);
249: period_start_date_tab(X_i) := X_date1;
250: X_date2 := period_start_date_tab(X_i) + 91;
251: period_end_date_tab(X_i) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
252: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');
253: 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');
254: END LOOP;
255: END IF;
256:

Line 253: 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');

249: period_start_date_tab(X_i) := X_date1;
250: X_date2 := period_start_date_tab(X_i) + 91;
251: period_end_date_tab(X_i) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
252: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');
253: 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');
254: END LOOP;
255: END IF;
256:
257: OPEN Cur_check_hdr;

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

1018: /* Use the hard coded value for bug 12399670 Vijay Induri */
1019: X_workdate1 := TO_DATE ( (SYSDATE-(17*365)), 'DD/MM/YYYY HH24:MI:SS') ;
1020:
1021: X_workdate2 := TO_DATE(TO_CHAR(SYSDATE,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
1022: FND_MESSAGE.SET_NAME('GMP','PS_PASTDUE');
1023: X_period := FND_MESSAGE.GET;
1024: IF (X_rows = 0) THEN
1025: RETURN(X_rows);
1026: END IF;

Line 1023: X_period := FND_MESSAGE.GET;

1019: X_workdate1 := TO_DATE ( (SYSDATE-(17*365)), 'DD/MM/YYYY HH24:MI:SS') ;
1020:
1021: X_workdate2 := TO_DATE(TO_CHAR(SYSDATE,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
1022: FND_MESSAGE.SET_NAME('GMP','PS_PASTDUE');
1023: X_period := FND_MESSAGE.GET;
1024: IF (X_rows = 0) THEN
1025: RETURN(X_rows);
1026: END IF;
1027:

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

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

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

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

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

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

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

1065: This change has been done to facilitate the translation of messages*/
1066:
1067: IF ( period_name = 'SUNDAY') THEN
1068: FND_MESSAGE.SET_NAME('GMP','PS_SUNDAY');
1069: period_name_tab(X_i) := FND_MESSAGE.GET;
1070: ELSIF ( period_name = 'MONDAY') THEN
1071: FND_MESSAGE.SET_NAME('GMP','PS_MONDAY');
1072: period_name_tab(X_i) := FND_MESSAGE.GET;
1073: ELSIF ( period_name = 'TUESDAY') THEN

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

1067: IF ( period_name = 'SUNDAY') THEN
1068: FND_MESSAGE.SET_NAME('GMP','PS_SUNDAY');
1069: period_name_tab(X_i) := FND_MESSAGE.GET;
1070: ELSIF ( period_name = 'MONDAY') THEN
1071: FND_MESSAGE.SET_NAME('GMP','PS_MONDAY');
1072: period_name_tab(X_i) := FND_MESSAGE.GET;
1073: ELSIF ( period_name = 'TUESDAY') THEN
1074: FND_MESSAGE.SET_NAME('GMP','PS_TUESDAY');
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_SUNDAY');
1069: period_name_tab(X_i) := FND_MESSAGE.GET;
1070: ELSIF ( period_name = 'MONDAY') THEN
1071: FND_MESSAGE.SET_NAME('GMP','PS_MONDAY');
1072: period_name_tab(X_i) := FND_MESSAGE.GET;
1073: ELSIF ( period_name = 'TUESDAY') THEN
1074: FND_MESSAGE.SET_NAME('GMP','PS_TUESDAY');
1075: period_name_tab(X_i) := FND_MESSAGE.GET;
1076: ELSIF ( period_name = 'WEDNESDAY') THEN

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

1070: ELSIF ( period_name = 'MONDAY') THEN
1071: FND_MESSAGE.SET_NAME('GMP','PS_MONDAY');
1072: period_name_tab(X_i) := FND_MESSAGE.GET;
1073: ELSIF ( period_name = 'TUESDAY') THEN
1074: FND_MESSAGE.SET_NAME('GMP','PS_TUESDAY');
1075: period_name_tab(X_i) := FND_MESSAGE.GET;
1076: ELSIF ( period_name = 'WEDNESDAY') THEN
1077: FND_MESSAGE.SET_NAME('GMP','PS_WEDNESDAY');
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_MONDAY');
1072: period_name_tab(X_i) := FND_MESSAGE.GET;
1073: ELSIF ( period_name = 'TUESDAY') THEN
1074: FND_MESSAGE.SET_NAME('GMP','PS_TUESDAY');
1075: period_name_tab(X_i) := FND_MESSAGE.GET;
1076: ELSIF ( period_name = 'WEDNESDAY') THEN
1077: FND_MESSAGE.SET_NAME('GMP','PS_WEDNESDAY');
1078: period_name_tab(X_i) := FND_MESSAGE.GET;
1079: ELSIF ( period_name = 'THURSDAY') THEN

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

1073: ELSIF ( period_name = 'TUESDAY') THEN
1074: FND_MESSAGE.SET_NAME('GMP','PS_TUESDAY');
1075: period_name_tab(X_i) := FND_MESSAGE.GET;
1076: ELSIF ( period_name = 'WEDNESDAY') THEN
1077: FND_MESSAGE.SET_NAME('GMP','PS_WEDNESDAY');
1078: period_name_tab(X_i) := FND_MESSAGE.GET;
1079: ELSIF ( period_name = 'THURSDAY') THEN
1080: FND_MESSAGE.SET_NAME('GMP','PS_THURSDAY');
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_TUESDAY');
1075: period_name_tab(X_i) := FND_MESSAGE.GET;
1076: ELSIF ( period_name = 'WEDNESDAY') THEN
1077: FND_MESSAGE.SET_NAME('GMP','PS_WEDNESDAY');
1078: period_name_tab(X_i) := FND_MESSAGE.GET;
1079: ELSIF ( period_name = 'THURSDAY') THEN
1080: FND_MESSAGE.SET_NAME('GMP','PS_THURSDAY');
1081: period_name_tab(X_i) := FND_MESSAGE.GET;
1082: ELSIF ( period_name = 'FRIDAY') THEN

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

1076: ELSIF ( period_name = 'WEDNESDAY') THEN
1077: FND_MESSAGE.SET_NAME('GMP','PS_WEDNESDAY');
1078: period_name_tab(X_i) := FND_MESSAGE.GET;
1079: ELSIF ( period_name = 'THURSDAY') THEN
1080: FND_MESSAGE.SET_NAME('GMP','PS_THURSDAY');
1081: period_name_tab(X_i) := FND_MESSAGE.GET;
1082: ELSIF ( period_name = 'FRIDAY') THEN
1083: FND_MESSAGE.SET_NAME('GMP','PS_FRIDAY');
1084: period_name_tab(X_i) := FND_MESSAGE.GET;

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

1077: FND_MESSAGE.SET_NAME('GMP','PS_WEDNESDAY');
1078: period_name_tab(X_i) := FND_MESSAGE.GET;
1079: ELSIF ( period_name = 'THURSDAY') THEN
1080: FND_MESSAGE.SET_NAME('GMP','PS_THURSDAY');
1081: period_name_tab(X_i) := FND_MESSAGE.GET;
1082: ELSIF ( period_name = 'FRIDAY') THEN
1083: FND_MESSAGE.SET_NAME('GMP','PS_FRIDAY');
1084: period_name_tab(X_i) := FND_MESSAGE.GET;
1085: ELSIF ( period_name = 'SATURDAY') THEN

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

1079: ELSIF ( period_name = 'THURSDAY') THEN
1080: FND_MESSAGE.SET_NAME('GMP','PS_THURSDAY');
1081: period_name_tab(X_i) := FND_MESSAGE.GET;
1082: ELSIF ( period_name = 'FRIDAY') THEN
1083: FND_MESSAGE.SET_NAME('GMP','PS_FRIDAY');
1084: period_name_tab(X_i) := FND_MESSAGE.GET;
1085: ELSIF ( period_name = 'SATURDAY') THEN
1086: FND_MESSAGE.SET_NAME('GMP','PS_SATURDAY');
1087: period_name_tab(X_i) := FND_MESSAGE.GET;

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

1080: FND_MESSAGE.SET_NAME('GMP','PS_THURSDAY');
1081: period_name_tab(X_i) := FND_MESSAGE.GET;
1082: ELSIF ( period_name = 'FRIDAY') THEN
1083: FND_MESSAGE.SET_NAME('GMP','PS_FRIDAY');
1084: period_name_tab(X_i) := FND_MESSAGE.GET;
1085: ELSIF ( period_name = 'SATURDAY') THEN
1086: FND_MESSAGE.SET_NAME('GMP','PS_SATURDAY');
1087: period_name_tab(X_i) := FND_MESSAGE.GET;
1088: END IF;

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

1082: ELSIF ( period_name = 'FRIDAY') THEN
1083: FND_MESSAGE.SET_NAME('GMP','PS_FRIDAY');
1084: period_name_tab(X_i) := FND_MESSAGE.GET;
1085: ELSIF ( period_name = 'SATURDAY') THEN
1086: FND_MESSAGE.SET_NAME('GMP','PS_SATURDAY');
1087: period_name_tab(X_i) := FND_MESSAGE.GET;
1088: END IF;
1089:
1090: END LOOP;

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

1083: FND_MESSAGE.SET_NAME('GMP','PS_FRIDAY');
1084: period_name_tab(X_i) := FND_MESSAGE.GET;
1085: ELSIF ( period_name = 'SATURDAY') THEN
1086: FND_MESSAGE.SET_NAME('GMP','PS_SATURDAY');
1087: period_name_tab(X_i) := FND_MESSAGE.GET;
1088: END IF;
1089:
1090: END LOOP;
1091: ELSE

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

1099: X_date1 := period_end_date_tab(X_j);
1100: period_start_date_tab(X_i) := X_date1;
1101: X_date2 := period_start_date_tab(X_i) + 7;
1102: period_end_date_tab(X_i) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
1103: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');
1104: period_name_tab(X_i) := FND_MESSAGE.GET||' '||TO_CHAR(X_date2,'WW');
1105: END LOOP;
1106: ELSE
1107: IF (X_no_days = 0) THEN

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

1100: period_start_date_tab(X_i) := X_date1;
1101: X_date2 := period_start_date_tab(X_i) + 7;
1102: period_end_date_tab(X_i) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
1103: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');
1104: period_name_tab(X_i) := FND_MESSAGE.GET||' '||TO_CHAR(X_date2,'WW');
1105: END LOOP;
1106: ELSE
1107: IF (X_no_days = 0) THEN
1108: X_wcount := 2;

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

1119: X_date1 := period_end_date_tab(X_j);
1120: period_start_date_tab(X_i) := X_date1;
1121: X_date2 := period_start_date_tab(X_i) + 28;
1122: period_end_date_tab(X_i) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
1123: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');
1124: 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');
1125: END LOOP;
1126: ELSE
1127: IF (X_no_days = 0 AND X_no_weeks = 0) THEN

Line 1124: 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');

1120: period_start_date_tab(X_i) := X_date1;
1121: X_date2 := period_start_date_tab(X_i) + 28;
1122: period_end_date_tab(X_i) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
1123: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');
1124: 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');
1125: END LOOP;
1126: ELSE
1127: IF (X_no_days = 0 AND X_no_weeks = 0) THEN
1128: X_mcount := 2;

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

1141: X_date1 := period_end_date_tab(X_j);
1142: period_start_date_tab(X_i) := X_date1;
1143: X_date2 := period_start_date_tab(X_i) + 91;
1144: period_end_date_tab(X_i) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
1145: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');
1146: 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');
1147: END LOOP;
1148: END IF;
1149:

Line 1146: 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');

1142: period_start_date_tab(X_i) := X_date1;
1143: X_date2 := period_start_date_tab(X_i) + 91;
1144: period_end_date_tab(X_i) := TO_DATE(TO_CHAR(X_date2,'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
1145: FND_MESSAGE.SET_NAME('GMP','PS_WEEK');
1146: 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');
1147: END LOOP;
1148: END IF;
1149:
1150: OPEN Cur_check_hdr;