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

Line 167: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

163: EXCEPTION
164: WHEN INVALID_DATA_PASSED OR invalid_version THEN
165:
166: x_return_status := FND_API.G_RET_STS_ERROR;
167: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
168: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
169: FND_MSG_PUB.ADD;
170: RETURN FALSE ;
171:

Line 168: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

164: WHEN INVALID_DATA_PASSED OR invalid_version THEN
165:
166: x_return_status := FND_API.G_RET_STS_ERROR;
167: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
168: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
169: FND_MSG_PUB.ADD;
170: RETURN FALSE ;
171:
172: WHEN CALENDAR_REQUIRED THEN

Line 174: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');

170: RETURN FALSE ;
171:
172: WHEN CALENDAR_REQUIRED THEN
173: x_return_status := FND_API.G_RET_STS_ERROR;
174: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
175: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
176: FND_MSG_PUB.ADD;
177: RETURN FALSE ;
178:

Line 175: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);

171:
172: WHEN CALENDAR_REQUIRED THEN
173: x_return_status := FND_API.G_RET_STS_ERROR;
174: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
175: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
176: FND_MSG_PUB.ADD;
177: RETURN FALSE ;
178:
179: WHEN DATE_OUT_OF_CAL_RANGE THEN

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

177: RETURN FALSE ;
178:
179: WHEN DATE_OUT_OF_CAL_RANGE THEN
180: x_return_status := FND_API.G_RET_STS_SUCCESS;
181: FND_MESSAGE.SET_NAME('GMP','GMP_DATE_OUT_OF_CAL_RANGE');
182: FND_MSG_PUB.ADD;
183: RETURN TRUE;
184:
185: WHEN PS_INVALID_CALENDAR THEN

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

183: RETURN TRUE;
184:
185: WHEN PS_INVALID_CALENDAR THEN
186: x_return_status := FND_API.G_RET_STS_ERROR;
187: FND_MESSAGE.SET_NAME('GMP','PS_INVALID_CALENDAR');
188: FND_MSG_PUB.ADD;
189: RETURN FALSE ;
190:
191: WHEN OTHERS THEN

Line 192: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

188: FND_MSG_PUB.ADD;
189: RETURN FALSE ;
190:
191: WHEN OTHERS THEN
192: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
193: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
194: FND_MSG_PUB.ADD;
195: x_return_status := FND_API.g_ret_sts_unexp_error;
196: RETURN FALSE ;

Line 193: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

189: RETURN FALSE ;
190:
191: WHEN OTHERS THEN
192: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
193: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
194: FND_MSG_PUB.ADD;
195: x_return_status := FND_API.g_ret_sts_unexp_error;
196: RETURN FALSE ;
197: END is_working_day;

Line 537: FND_MESSAGE.SET_NAME('GMP','GMP_ENTER_START_OR_END_DATE');

533: p_output_tbl.DELETE ;
534: END IF ;
535:
536: ELSE
537: FND_MESSAGE.SET_NAME('GMP','GMP_ENTER_START_OR_END_DATE');
538: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
539: FND_MSG_PUB.ADD;
540: x_return_status := FND_API.G_RET_STS_ERROR;
541:

Line 538: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

534: END IF ;
535:
536: ELSE
537: FND_MESSAGE.SET_NAME('GMP','GMP_ENTER_START_OR_END_DATE');
538: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
539: FND_MSG_PUB.ADD;
540: x_return_status := FND_API.G_RET_STS_ERROR;
541:
542: /* } */

Line 550: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

546: ELSE
547: x_return_status := 'E';
548: X_msg := 'Calendar/Start or End Date ';
549: RAISE CALENDAR_REQUIRED;
550: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
551: FND_MSG_PUB.ADD;
552: END IF;
553: /* } */
554:

Line 564: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');

560: x_return_status := FND_API.G_RET_STS_ERROR;
561:
562: WHEN CALENDAR_REQUIRED THEN
563: x_return_status := FND_API.G_RET_STS_ERROR;
564: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
565: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
566: FND_MSG_PUB.ADD;
567:
568: WHEN ZERO_DURATION THEN

Line 565: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);

561:
562: WHEN CALENDAR_REQUIRED THEN
563: x_return_status := FND_API.G_RET_STS_ERROR;
564: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
565: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
566: FND_MSG_PUB.ADD;
567:
568: WHEN ZERO_DURATION THEN
569: NULL;

Line 572: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

568: WHEN ZERO_DURATION THEN
569: NULL;
570:
571: WHEN OTHERS THEN
572: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
573: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
574: FND_MSG_PUB.ADD;
575: x_return_status := FND_API.G_RET_STS_ERROR;
576: END get_contiguous_periods;

Line 573: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

569: NULL;
570:
571: WHEN OTHERS THEN
572: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
573: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
574: FND_MSG_PUB.ADD;
575: x_return_status := FND_API.G_RET_STS_ERROR;
576: END get_contiguous_periods;
577: /*

Line 680: FND_MESSAGE.SET_NAME('GMP','GMP_DATE_NOT_IN_CAL_RANGE');

676: EXCEPTION
677: WHEN GMP_DATE_NOT_IN_CAL_RANGE THEN
678: x_return_status := FND_API.G_RET_STS_ERROR;
679: FND_FILE.PUT_LINE(FND_FILE.LOG,'Date Passed is Out of Calendar Range '||X_msg);
680: FND_MESSAGE.SET_NAME('GMP','GMP_DATE_NOT_IN_CAL_RANGE');
681: FND_MSG_PUB.ADD;
682:
683: WHEN ENTER_START_OR_END_DATE THEN
684: x_return_status := FND_API.G_RET_STS_ERROR;

Line 686: FND_MESSAGE.SET_NAME('GMP','GMP_ENTER_START_OR_END_DATE');

682:
683: WHEN ENTER_START_OR_END_DATE THEN
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enter Start Or End Date '||X_msg);
686: FND_MESSAGE.SET_NAME('GMP','GMP_ENTER_START_OR_END_DATE');
687: FND_MSG_PUB.ADD;
688:
689: WHEN PS_INVALID_CALENDAR THEN
690: x_return_status := FND_API.G_RET_STS_ERROR;

Line 691: FND_MESSAGE.SET_NAME('GMP','PS_INVALID_CALENDAR');

687: FND_MSG_PUB.ADD;
688:
689: WHEN PS_INVALID_CALENDAR THEN
690: x_return_status := FND_API.G_RET_STS_ERROR;
691: FND_MESSAGE.SET_NAME('GMP','PS_INVALID_CALENDAR');
692: FND_MSG_PUB.ADD;
693:
694: WHEN INVALID_VALUE THEN
695: x_return_status := FND_API.G_RET_STS_ERROR;

Line 697: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');

693:
694: WHEN INVALID_VALUE THEN
695: x_return_status := FND_API.G_RET_STS_ERROR;
696: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);
697: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
698: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
699: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
700: FND_MSG_PUB.ADD;
701: END check_contig_periods;

Line 698: FND_MESSAGE.SET_TOKEN('FIELD',X_field);

694: WHEN INVALID_VALUE THEN
695: x_return_status := FND_API.G_RET_STS_ERROR;
696: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);
697: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
698: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
699: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
700: FND_MSG_PUB.ADD;
701: END check_contig_periods;
702:

Line 699: FND_MESSAGE.SET_TOKEN('VALUE',X_value);

695: x_return_status := FND_API.G_RET_STS_ERROR;
696: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);
697: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
698: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
699: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
700: FND_MSG_PUB.ADD;
701: END check_contig_periods;
702:
703: /* *****************************************************************

Line 815: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

811: ELSE
812: x_return_status := 'E';
813: X_msg := 'Calendar';
814: RAISE CALENDAR_REQUIRED;
815: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
816: FND_MSG_PUB.ADD;
817: END IF;
818:
819: FND_FILE.PUT_LINE(FND_FILE.LOG,'Completed '||l_api_name ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

Line 827: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');

823: x_return_status := FND_API.G_RET_STS_ERROR;
824:
825: WHEN CALENDAR_REQUIRED OR VALUE_REQUIRED THEN
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
828: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
829: FND_MSG_PUB.ADD;
830:
831: WHEN INVALID_CAL_RANGE THEN

Line 828: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);

824:
825: WHEN CALENDAR_REQUIRED OR VALUE_REQUIRED THEN
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
828: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
829: FND_MSG_PUB.ADD;
830:
831: WHEN INVALID_CAL_RANGE THEN
832: x_return_status := FND_API.G_RET_STS_ERROR;

Line 833: FND_MESSAGE.SET_NAME('GMP','MR_INV_CALENDAR_RANGE');

829: FND_MSG_PUB.ADD;
830:
831: WHEN INVALID_CAL_RANGE THEN
832: x_return_status := FND_API.G_RET_STS_ERROR;
833: FND_MESSAGE.SET_NAME('GMP','MR_INV_CALENDAR_RANGE');
834: FND_MSG_PUB.ADD;
835:
836: WHEN OTHERS THEN
837: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 837: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

833: FND_MESSAGE.SET_NAME('GMP','MR_INV_CALENDAR_RANGE');
834: FND_MSG_PUB.ADD;
835:
836: WHEN OTHERS THEN
837: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
838: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
839: FND_MSG_PUB.ADD;
840: x_return_status := FND_API.g_ret_sts_unexp_error;
841:

Line 838: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

834: FND_MSG_PUB.ADD;
835:
836: WHEN OTHERS THEN
837: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
838: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
839: FND_MSG_PUB.ADD;
840: x_return_status := FND_API.g_ret_sts_unexp_error;
841:
842: END get_all_dates ;

Line 939: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

935: ELSE
936: x_return_status := 'E';
937: X_msg := 'Calendar';
938: RAISE CALENDAR_REQUIRED;
939: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
940: FND_MSG_PUB.ADD;
941: END IF;
942:
943: FND_FILE.PUT_LINE(FND_FILE.LOG,'Completed '||l_api_name ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

Line 951: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');

947: x_return_status := FND_API.G_RET_STS_ERROR;
948:
949: WHEN CALENDAR_REQUIRED THEN
950: x_return_status := FND_API.G_RET_STS_ERROR;
951: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
952: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
953: FND_MSG_PUB.ADD;
954:
955: WHEN OTHERS THEN

Line 952: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);

948:
949: WHEN CALENDAR_REQUIRED THEN
950: x_return_status := FND_API.G_RET_STS_ERROR;
951: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
952: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
953: FND_MSG_PUB.ADD;
954:
955: WHEN OTHERS THEN
956: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 956: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

952: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
953: FND_MSG_PUB.ADD;
954:
955: WHEN OTHERS THEN
956: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
957: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
958: FND_MSG_PUB.ADD;
959: x_return_status := FND_API.g_ret_sts_unexp_error;
960:

Line 957: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

953: FND_MSG_PUB.ADD;
954:
955: WHEN OTHERS THEN
956: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
957: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
958: FND_MSG_PUB.ADD;
959: x_return_status := FND_API.g_ret_sts_unexp_error;
960:
961: END get_work_days ;

Line 1056: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1052: ELSE
1053: x_return_status := 'E';
1054: X_msg := 'Shopday Number';
1055: RAISE SHOPDAY_NUMBER_REQUIRED;
1056: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1057: FND_MSG_PUB.ADD;
1058: END IF;
1059:
1060: FND_FILE.PUT_LINE(FND_FILE.LOG,'Completed '||l_api_name ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

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

1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065:
1066: WHEN SHOPDAY_NUMBER_REQUIRED THEN
1067: x_return_status := FND_API.G_RET_STS_ERROR;
1068: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
1069: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1070: FND_MSG_PUB.ADD;
1071:
1072: WHEN INVALID_SHOPDAY THEN

Line 1069: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);

1065:
1066: WHEN SHOPDAY_NUMBER_REQUIRED THEN
1067: x_return_status := FND_API.G_RET_STS_ERROR;
1068: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
1069: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1070: FND_MSG_PUB.ADD;
1071:
1072: WHEN INVALID_SHOPDAY THEN
1073: x_return_status := FND_API.G_RET_STS_ERROR;

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

1070: FND_MSG_PUB.ADD;
1071:
1072: WHEN INVALID_SHOPDAY THEN
1073: x_return_status := FND_API.G_RET_STS_ERROR;
1074: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_SHOPDAY');
1075: FND_MSG_PUB.ADD;
1076:
1077: WHEN OTHERS THEN
1078: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 1078: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1074: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_SHOPDAY');
1075: FND_MSG_PUB.ADD;
1076:
1077: WHEN OTHERS THEN
1078: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1079: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1080: FND_MSG_PUB.ADD;
1081: x_return_status := FND_API.g_ret_sts_unexp_error;
1082:

Line 1079: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1075: FND_MSG_PUB.ADD;
1076:
1077: WHEN OTHERS THEN
1078: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1079: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1080: FND_MSG_PUB.ADD;
1081: x_return_status := FND_API.g_ret_sts_unexp_error;
1082:
1083: END get_workday_details ;

Line 1158: FND_MESSAGE.SET_NAME('GMP','GMP_SDATE_BEFORE_CAL_SDATE');

1154:
1155: EXCEPTION
1156: WHEN GMP_SDATE_BEFORE_CAL_SDATE THEN
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158: FND_MESSAGE.SET_NAME('GMP','GMP_SDATE_BEFORE_CAL_SDATE');
1159: FND_MSG_PUB.ADD;
1160:
1161: WHEN PS_INVALID_CALENDAR THEN
1162: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1163: FND_MESSAGE.SET_NAME('GMP','PS_INVALID_CALENDAR');

1159: FND_MSG_PUB.ADD;
1160:
1161: WHEN PS_INVALID_CALENDAR THEN
1162: x_return_status := FND_API.G_RET_STS_ERROR;
1163: FND_MESSAGE.SET_NAME('GMP','PS_INVALID_CALENDAR');
1164: FND_MSG_PUB.ADD;
1165:
1166: WHEN GMP_EDATE_AFTER_CAL_EDATE THEN
1167: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1168: FND_MESSAGE.SET_NAME('GMP','GMP_EDATE_AFTER_CAL_EDATE');

1164: FND_MSG_PUB.ADD;
1165:
1166: WHEN GMP_EDATE_AFTER_CAL_EDATE THEN
1167: x_return_status := FND_API.G_RET_STS_ERROR;
1168: FND_MESSAGE.SET_NAME('GMP','GMP_EDATE_AFTER_CAL_EDATE');
1169: FND_MSG_PUB.ADD;
1170:
1171: WHEN OTHERS THEN
1172: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 1172: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1168: FND_MESSAGE.SET_NAME('GMP','GMP_EDATE_AFTER_CAL_EDATE');
1169: FND_MSG_PUB.ADD;
1170:
1171: WHEN OTHERS THEN
1172: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1173: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1174: FND_MSG_PUB.ADD;
1175: x_return_status := FND_API.g_ret_sts_unexp_error;
1176: end check_cal_data;

Line 1173: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1169: FND_MSG_PUB.ADD;
1170:
1171: WHEN OTHERS THEN
1172: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1173: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1174: FND_MSG_PUB.ADD;
1175: x_return_status := FND_API.g_ret_sts_unexp_error;
1176: end check_cal_data;
1177: /* ==========================================================================

Line 1261: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');

1257:
1258: EXCEPTION
1259: WHEN VALUE_REQUIRED THEN
1260: x_return_status := FND_API.G_RET_STS_ERROR;
1261: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
1262: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1263: FND_MSG_PUB.ADD;
1264: --
1265: WHEN INVALID_CAL_RANGE THEN

Line 1262: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);

1258: EXCEPTION
1259: WHEN VALUE_REQUIRED THEN
1260: x_return_status := FND_API.G_RET_STS_ERROR;
1261: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
1262: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1263: FND_MSG_PUB.ADD;
1264: --
1265: WHEN INVALID_CAL_RANGE THEN
1266: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1267: FND_MESSAGE.SET_NAME('GMP','MR_INV_CALENDAR_RANGE');

1263: FND_MSG_PUB.ADD;
1264: --
1265: WHEN INVALID_CAL_RANGE THEN
1266: x_return_status := FND_API.G_RET_STS_ERROR;
1267: FND_MESSAGE.SET_NAME('GMP','MR_INV_CALENDAR_RANGE');
1268: FND_MSG_PUB.ADD;
1269: --
1270: WHEN PS_INVALID_CALENDAR THEN
1271: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1272: FND_MESSAGE.SET_NAME('GMP','PS_INVALID_CALENDAR');

1268: FND_MSG_PUB.ADD;
1269: --
1270: WHEN PS_INVALID_CALENDAR THEN
1271: x_return_status := FND_API.G_RET_STS_ERROR;
1272: FND_MESSAGE.SET_NAME('GMP','PS_INVALID_CALENDAR');
1273: FND_MSG_PUB.ADD;
1274: --
1275: WHEN OTHERS THEN
1276: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 1276: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1272: FND_MESSAGE.SET_NAME('GMP','PS_INVALID_CALENDAR');
1273: FND_MSG_PUB.ADD;
1274: --
1275: WHEN OTHERS THEN
1276: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1277: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1278: FND_MSG_PUB.ADD;
1279: x_return_status := FND_API.g_ret_sts_unexp_error;
1280:

Line 1277: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1273: FND_MSG_PUB.ADD;
1274: --
1275: WHEN OTHERS THEN
1276: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1277: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1278: FND_MSG_PUB.ADD;
1279: x_return_status := FND_API.g_ret_sts_unexp_error;
1280:
1281: end check_all_dates;

Line 1414: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1410: EXCEPTION
1411: WHEN INVALID_DATA_PASSED OR invalid_version THEN
1412:
1413: x_return_status := FND_API.G_RET_STS_ERROR;
1414: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1415: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1416: FND_MSG_PUB.ADD;
1417: RETURN FALSE ;
1418:

Line 1415: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1411: WHEN INVALID_DATA_PASSED OR invalid_version THEN
1412:
1413: x_return_status := FND_API.G_RET_STS_ERROR;
1414: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1415: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1416: FND_MSG_PUB.ADD;
1417: RETURN FALSE ;
1418:
1419: WHEN CALENDAR_REQUIRED THEN

Line 1421: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');

1417: RETURN FALSE ;
1418:
1419: WHEN CALENDAR_REQUIRED THEN
1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
1422: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1423: FND_MSG_PUB.ADD;
1424: RETURN FALSE ;
1425:

Line 1422: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);

1418:
1419: WHEN CALENDAR_REQUIRED THEN
1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
1422: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1423: FND_MSG_PUB.ADD;
1424: RETURN FALSE ;
1425:
1426: WHEN INVALID_VALUE THEN

Line 1429: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');

1425:
1426: WHEN INVALID_VALUE THEN
1427: x_return_status := FND_API.G_RET_STS_ERROR;
1428: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);
1429: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
1430: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
1431: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
1432: FND_MSG_PUB.ADD;
1433: RETURN FALSE ;

Line 1430: FND_MESSAGE.SET_TOKEN('FIELD',X_field);

1426: WHEN INVALID_VALUE THEN
1427: x_return_status := FND_API.G_RET_STS_ERROR;
1428: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);
1429: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
1430: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
1431: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
1432: FND_MSG_PUB.ADD;
1433: RETURN FALSE ;
1434:

Line 1431: FND_MESSAGE.SET_TOKEN('VALUE',X_value);

1427: x_return_status := FND_API.G_RET_STS_ERROR;
1428: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);
1429: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
1430: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
1431: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
1432: FND_MSG_PUB.ADD;
1433: RETURN FALSE ;
1434:
1435: WHEN OTHERS THEN

Line 1436: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1432: FND_MSG_PUB.ADD;
1433: RETURN FALSE ;
1434:
1435: WHEN OTHERS THEN
1436: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1437: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1438: FND_MSG_PUB.ADD;
1439: x_return_status := FND_API.g_ret_sts_unexp_error;
1440: RETURN FALSE ;

Line 1437: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1433: RETURN FALSE ;
1434:
1435: WHEN OTHERS THEN
1436: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1437: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1438: FND_MSG_PUB.ADD;
1439: x_return_status := FND_API.g_ret_sts_unexp_error;
1440: RETURN FALSE ;
1441: END IS_WORKING_DAYTIME ;

Line 1643: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1639: EXCEPTION
1640: WHEN INVALID_DATA_PASSED OR invalid_version THEN
1641: x_return_status := FND_API.G_RET_STS_ERROR;
1642: x_date := (sysdate - 9999 ) ;
1643: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1644: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1645: FND_MSG_PUB.ADD;
1646:
1647: WHEN CALENDAR_REQUIRED THEN

Line 1644: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1640: WHEN INVALID_DATA_PASSED OR invalid_version THEN
1641: x_return_status := FND_API.G_RET_STS_ERROR;
1642: x_date := (sysdate - 9999 ) ;
1643: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1644: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1645: FND_MSG_PUB.ADD;
1646:
1647: WHEN CALENDAR_REQUIRED THEN
1648: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1649: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');

1645: FND_MSG_PUB.ADD;
1646:
1647: WHEN CALENDAR_REQUIRED THEN
1648: x_return_status := FND_API.G_RET_STS_ERROR;
1649: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
1650: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1651: FND_MSG_PUB.ADD;
1652: x_date := (sysdate - 9999 ) ;
1653:

Line 1650: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);

1646:
1647: WHEN CALENDAR_REQUIRED THEN
1648: x_return_status := FND_API.G_RET_STS_ERROR;
1649: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
1650: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1651: FND_MSG_PUB.ADD;
1652: x_date := (sysdate - 9999 ) ;
1653:
1654: WHEN INVALID_VALUE THEN

Line 1658: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');

1654: WHEN INVALID_VALUE THEN
1655: x_return_status := FND_API.G_RET_STS_ERROR;
1656: x_date := (sysdate - 9999 ) ;
1657: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);
1658: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
1659: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
1660: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
1661: FND_MSG_PUB.ADD;
1662:

Line 1659: FND_MESSAGE.SET_TOKEN('FIELD',X_field);

1655: x_return_status := FND_API.G_RET_STS_ERROR;
1656: x_date := (sysdate - 9999 ) ;
1657: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);
1658: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
1659: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
1660: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
1661: FND_MSG_PUB.ADD;
1662:
1663: WHEN OTHERS THEN

Line 1660: FND_MESSAGE.SET_TOKEN('VALUE',X_value);

1656: x_date := (sysdate - 9999 ) ;
1657: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);
1658: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
1659: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
1660: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
1661: FND_MSG_PUB.ADD;
1662:
1663: WHEN OTHERS THEN
1664: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 1666: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1662:
1663: WHEN OTHERS THEN
1664: x_return_status := FND_API.g_ret_sts_unexp_error;
1665: x_date := (sysdate - 9999 ) ;
1666: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1667: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1668: FND_MSG_PUB.ADD;
1669:
1670: END get_nearest_workdaytime ;

Line 1667: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1663: WHEN OTHERS THEN
1664: x_return_status := FND_API.g_ret_sts_unexp_error;
1665: x_date := (sysdate - 9999 ) ;
1666: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1667: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1668: FND_MSG_PUB.ADD;
1669:
1670: END get_nearest_workdaytime ;
1671: