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 384: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

380: IF c_return_status = FALSE then
381: x_return_status := 'E';
382: X_msg := 'Calendar/Start or End Date ';
383: RAISE CALENDAR_REQUIRED;
384: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
385: FND_MSG_PUB.ADD;
386: END IF ;
387: END IF;
388:

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

389: ELSE
390: x_return_status := 'E';
391: X_msg := 'Calendar/Start or End Date ';
392: RAISE CALENDAR_REQUIRED;
393: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
394: FND_MSG_PUB.ADD;
395: END IF;
396:
397: remaining_duration := CEIL(p_duration * 3600) ; /* B3361082 */

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

608:
609: END LOOP ;
610:
611: ELSE
612: FND_MESSAGE.SET_NAME('GMP','GMP_ENTER_START_OR_END_DATE');
613: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
614: FND_MSG_PUB.ADD;
615: x_return_status := FND_API.G_RET_STS_ERROR;
616:

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

609: END LOOP ;
610:
611: ELSE
612: FND_MESSAGE.SET_NAME('GMP','GMP_ENTER_START_OR_END_DATE');
613: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
614: FND_MSG_PUB.ADD;
615: x_return_status := FND_API.G_RET_STS_ERROR;
616:
617: /* } */

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

624: x_return_status := FND_API.G_RET_STS_ERROR;
625:
626: WHEN CALENDAR_REQUIRED THEN
627: x_return_status := FND_API.G_RET_STS_ERROR;
628: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
629: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
630: FND_MSG_PUB.ADD;
631:
632: WHEN ZERO_DURATION THEN

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

625:
626: WHEN CALENDAR_REQUIRED THEN
627: x_return_status := FND_API.G_RET_STS_ERROR;
628: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
629: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
630: FND_MSG_PUB.ADD;
631:
632: WHEN ZERO_DURATION THEN
633: NULL;

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

632: WHEN ZERO_DURATION THEN
633: NULL;
634:
635: WHEN OTHERS THEN
636: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
637: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
638: FND_MSG_PUB.ADD;
639: x_return_status := FND_API.G_RET_STS_ERROR;
640: END get_contiguous_periods;

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

633: NULL;
634:
635: WHEN OTHERS THEN
636: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
637: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
638: FND_MSG_PUB.ADD;
639: x_return_status := FND_API.G_RET_STS_ERROR;
640: END get_contiguous_periods;
641: /*

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

740: EXCEPTION
741: WHEN GMP_DATE_NOT_IN_CAL_RANGE THEN
742: x_return_status := FND_API.G_RET_STS_ERROR;
743: FND_FILE.PUT_LINE(FND_FILE.LOG,'Date Passed is Out of Calendar Range '||X_msg);
744: FND_MESSAGE.SET_NAME('GMP','GMP_DATE_NOT_IN_CAL_RANGE');
745: FND_MSG_PUB.ADD;
746:
747: WHEN ENTER_START_OR_END_DATE THEN
748: x_return_status := FND_API.G_RET_STS_ERROR;

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

746:
747: WHEN ENTER_START_OR_END_DATE THEN
748: x_return_status := FND_API.G_RET_STS_ERROR;
749: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enter Start Or End Date '||X_msg);
750: FND_MESSAGE.SET_NAME('GMP','GMP_ENTER_START_OR_END_DATE');
751: FND_MSG_PUB.ADD;
752:
753: WHEN PS_INVALID_CALENDAR THEN
754: x_return_status := FND_API.G_RET_STS_ERROR;

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

751: FND_MSG_PUB.ADD;
752:
753: WHEN PS_INVALID_CALENDAR THEN
754: x_return_status := FND_API.G_RET_STS_ERROR;
755: FND_MESSAGE.SET_NAME('GMP','PS_INVALID_CALENDAR');
756: FND_MSG_PUB.ADD;
757:
758: WHEN INVALID_VALUE THEN
759: x_return_status := FND_API.G_RET_STS_ERROR;

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

757:
758: WHEN INVALID_VALUE THEN
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);
761: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
762: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
763: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
764: FND_MSG_PUB.ADD;
765: END check_contig_periods;

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

758: WHEN INVALID_VALUE THEN
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);
761: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
762: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
763: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
764: FND_MSG_PUB.ADD;
765: END check_contig_periods;
766:

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

759: x_return_status := FND_API.G_RET_STS_ERROR;
760: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);
761: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
762: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
763: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
764: FND_MSG_PUB.ADD;
765: END check_contig_periods;
766:
767: /* *****************************************************************

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

875: ELSE
876: x_return_status := 'E';
877: X_msg := 'Calendar';
878: RAISE CALENDAR_REQUIRED;
879: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
880: FND_MSG_PUB.ADD;
881: END IF;
882:
883: FND_FILE.PUT_LINE(FND_FILE.LOG,'Completed '||l_api_name ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

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

887: x_return_status := FND_API.G_RET_STS_ERROR;
888:
889: WHEN CALENDAR_REQUIRED OR VALUE_REQUIRED THEN
890: x_return_status := FND_API.G_RET_STS_ERROR;
891: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
892: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
893: FND_MSG_PUB.ADD;
894:
895: WHEN INVALID_CAL_RANGE THEN

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

888:
889: WHEN CALENDAR_REQUIRED OR VALUE_REQUIRED THEN
890: x_return_status := FND_API.G_RET_STS_ERROR;
891: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
892: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
893: FND_MSG_PUB.ADD;
894:
895: WHEN INVALID_CAL_RANGE THEN
896: x_return_status := FND_API.G_RET_STS_ERROR;

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

893: FND_MSG_PUB.ADD;
894:
895: WHEN INVALID_CAL_RANGE THEN
896: x_return_status := FND_API.G_RET_STS_ERROR;
897: FND_MESSAGE.SET_NAME('GMP','MR_INV_CALENDAR_RANGE');
898: FND_MSG_PUB.ADD;
899:
900: WHEN OTHERS THEN
901: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

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

897: FND_MESSAGE.SET_NAME('GMP','MR_INV_CALENDAR_RANGE');
898: FND_MSG_PUB.ADD;
899:
900: WHEN OTHERS THEN
901: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
902: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
903: FND_MSG_PUB.ADD;
904: x_return_status := FND_API.g_ret_sts_unexp_error;
905:

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

898: FND_MSG_PUB.ADD;
899:
900: WHEN OTHERS THEN
901: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
902: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
903: FND_MSG_PUB.ADD;
904: x_return_status := FND_API.g_ret_sts_unexp_error;
905:
906: END get_all_dates ;

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

999: ELSE
1000: x_return_status := 'E';
1001: X_msg := 'Calendar';
1002: RAISE CALENDAR_REQUIRED;
1003: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1004: FND_MSG_PUB.ADD;
1005: END IF;
1006:
1007: FND_FILE.PUT_LINE(FND_FILE.LOG,'Completed '||l_api_name ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

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

1011: x_return_status := FND_API.G_RET_STS_ERROR;
1012:
1013: WHEN CALENDAR_REQUIRED THEN
1014: x_return_status := FND_API.G_RET_STS_ERROR;
1015: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
1016: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1017: FND_MSG_PUB.ADD;
1018:
1019: WHEN OTHERS THEN

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

1012:
1013: WHEN CALENDAR_REQUIRED THEN
1014: x_return_status := FND_API.G_RET_STS_ERROR;
1015: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
1016: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1017: FND_MSG_PUB.ADD;
1018:
1019: WHEN OTHERS THEN
1020: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

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

1016: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1017: FND_MSG_PUB.ADD;
1018:
1019: WHEN OTHERS THEN
1020: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1021: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1022: FND_MSG_PUB.ADD;
1023: x_return_status := FND_API.g_ret_sts_unexp_error;
1024:

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

1017: FND_MSG_PUB.ADD;
1018:
1019: WHEN OTHERS THEN
1020: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1021: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1022: FND_MSG_PUB.ADD;
1023: x_return_status := FND_API.g_ret_sts_unexp_error;
1024:
1025: END get_work_days ;

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

1116: ELSE
1117: x_return_status := 'E';
1118: X_msg := 'Shopday Number';
1119: RAISE SHOPDAY_NUMBER_REQUIRED;
1120: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1121: FND_MSG_PUB.ADD;
1122: END IF;
1123:
1124: FND_FILE.PUT_LINE(FND_FILE.LOG,'Completed '||l_api_name ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

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

1128: x_return_status := FND_API.G_RET_STS_ERROR;
1129:
1130: WHEN SHOPDAY_NUMBER_REQUIRED THEN
1131: x_return_status := FND_API.G_RET_STS_ERROR;
1132: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
1133: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1134: FND_MSG_PUB.ADD;
1135:
1136: WHEN INVALID_SHOPDAY THEN

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

1129:
1130: WHEN SHOPDAY_NUMBER_REQUIRED THEN
1131: x_return_status := FND_API.G_RET_STS_ERROR;
1132: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
1133: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1134: FND_MSG_PUB.ADD;
1135:
1136: WHEN INVALID_SHOPDAY THEN
1137: x_return_status := FND_API.G_RET_STS_ERROR;

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

1134: FND_MSG_PUB.ADD;
1135:
1136: WHEN INVALID_SHOPDAY THEN
1137: x_return_status := FND_API.G_RET_STS_ERROR;
1138: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_SHOPDAY');
1139: FND_MSG_PUB.ADD;
1140:
1141: WHEN OTHERS THEN
1142: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

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

1138: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_SHOPDAY');
1139: FND_MSG_PUB.ADD;
1140:
1141: WHEN OTHERS THEN
1142: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1143: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1144: FND_MSG_PUB.ADD;
1145: x_return_status := FND_API.g_ret_sts_unexp_error;
1146:

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

1139: FND_MSG_PUB.ADD;
1140:
1141: WHEN OTHERS THEN
1142: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1143: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1144: FND_MSG_PUB.ADD;
1145: x_return_status := FND_API.g_ret_sts_unexp_error;
1146:
1147: END get_workday_details ;

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

1218:
1219: EXCEPTION
1220: WHEN GMP_SDATE_BEFORE_CAL_SDATE THEN
1221: x_return_status := FND_API.G_RET_STS_ERROR;
1222: FND_MESSAGE.SET_NAME('GMP','GMP_SDATE_BEFORE_CAL_SDATE');
1223: FND_MSG_PUB.ADD;
1224:
1225: WHEN PS_INVALID_CALENDAR THEN
1226: x_return_status := FND_API.G_RET_STS_ERROR;

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

1223: FND_MSG_PUB.ADD;
1224:
1225: WHEN PS_INVALID_CALENDAR THEN
1226: x_return_status := FND_API.G_RET_STS_ERROR;
1227: FND_MESSAGE.SET_NAME('GMP','PS_INVALID_CALENDAR');
1228: FND_MSG_PUB.ADD;
1229:
1230: WHEN GMP_EDATE_AFTER_CAL_EDATE THEN
1231: x_return_status := FND_API.G_RET_STS_ERROR;

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

1228: FND_MSG_PUB.ADD;
1229:
1230: WHEN GMP_EDATE_AFTER_CAL_EDATE THEN
1231: x_return_status := FND_API.G_RET_STS_ERROR;
1232: FND_MESSAGE.SET_NAME('GMP','GMP_EDATE_AFTER_CAL_EDATE');
1233: FND_MSG_PUB.ADD;
1234:
1235: WHEN OTHERS THEN
1236: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

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

1232: FND_MESSAGE.SET_NAME('GMP','GMP_EDATE_AFTER_CAL_EDATE');
1233: FND_MSG_PUB.ADD;
1234:
1235: WHEN OTHERS THEN
1236: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1237: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1238: FND_MSG_PUB.ADD;
1239: x_return_status := FND_API.g_ret_sts_unexp_error;
1240: end check_cal_data;

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

1233: FND_MSG_PUB.ADD;
1234:
1235: WHEN OTHERS THEN
1236: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1237: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1238: FND_MSG_PUB.ADD;
1239: x_return_status := FND_API.g_ret_sts_unexp_error;
1240: end check_cal_data;
1241: /* ==========================================================================

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

1321:
1322: EXCEPTION
1323: WHEN VALUE_REQUIRED THEN
1324: x_return_status := FND_API.G_RET_STS_ERROR;
1325: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
1326: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1327: FND_MSG_PUB.ADD;
1328: --
1329: WHEN INVALID_CAL_RANGE THEN

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

1322: EXCEPTION
1323: WHEN VALUE_REQUIRED THEN
1324: x_return_status := FND_API.G_RET_STS_ERROR;
1325: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
1326: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1327: FND_MSG_PUB.ADD;
1328: --
1329: WHEN INVALID_CAL_RANGE THEN
1330: x_return_status := FND_API.G_RET_STS_ERROR;

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

1327: FND_MSG_PUB.ADD;
1328: --
1329: WHEN INVALID_CAL_RANGE THEN
1330: x_return_status := FND_API.G_RET_STS_ERROR;
1331: FND_MESSAGE.SET_NAME('GMP','MR_INV_CALENDAR_RANGE');
1332: FND_MSG_PUB.ADD;
1333: --
1334: WHEN PS_INVALID_CALENDAR THEN
1335: x_return_status := FND_API.G_RET_STS_ERROR;

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

1332: FND_MSG_PUB.ADD;
1333: --
1334: WHEN PS_INVALID_CALENDAR THEN
1335: x_return_status := FND_API.G_RET_STS_ERROR;
1336: FND_MESSAGE.SET_NAME('GMP','PS_INVALID_CALENDAR');
1337: FND_MSG_PUB.ADD;
1338: --
1339: WHEN OTHERS THEN
1340: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

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

1336: FND_MESSAGE.SET_NAME('GMP','PS_INVALID_CALENDAR');
1337: FND_MSG_PUB.ADD;
1338: --
1339: WHEN OTHERS THEN
1340: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1341: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1342: FND_MSG_PUB.ADD;
1343: x_return_status := FND_API.g_ret_sts_unexp_error;
1344:

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

1337: FND_MSG_PUB.ADD;
1338: --
1339: WHEN OTHERS THEN
1340: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1341: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1342: FND_MSG_PUB.ADD;
1343: x_return_status := FND_API.g_ret_sts_unexp_error;
1344:
1345: end check_all_dates;

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

1477: EXCEPTION
1478: WHEN INVALID_DATA_PASSED OR invalid_version THEN
1479:
1480: x_return_status := FND_API.G_RET_STS_ERROR;
1481: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1482: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1483: FND_MSG_PUB.ADD;
1484: RETURN FALSE ;
1485:

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

1478: WHEN INVALID_DATA_PASSED OR invalid_version THEN
1479:
1480: x_return_status := FND_API.G_RET_STS_ERROR;
1481: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1482: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1483: FND_MSG_PUB.ADD;
1484: RETURN FALSE ;
1485:
1486: WHEN CALENDAR_REQUIRED THEN

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

1484: RETURN FALSE ;
1485:
1486: WHEN CALENDAR_REQUIRED THEN
1487: x_return_status := FND_API.G_RET_STS_ERROR;
1488: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
1489: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1490: FND_MSG_PUB.ADD;
1491: RETURN FALSE ;
1492:

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

1485:
1486: WHEN CALENDAR_REQUIRED THEN
1487: x_return_status := FND_API.G_RET_STS_ERROR;
1488: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
1489: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1490: FND_MSG_PUB.ADD;
1491: RETURN FALSE ;
1492:
1493: WHEN INVALID_VALUE THEN

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

1492:
1493: WHEN INVALID_VALUE THEN
1494: x_return_status := FND_API.G_RET_STS_ERROR;
1495: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);
1496: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
1497: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
1498: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
1499: FND_MSG_PUB.ADD;
1500: RETURN FALSE ;

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

1493: WHEN INVALID_VALUE THEN
1494: x_return_status := FND_API.G_RET_STS_ERROR;
1495: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);
1496: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
1497: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
1498: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
1499: FND_MSG_PUB.ADD;
1500: RETURN FALSE ;
1501:

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

1494: x_return_status := FND_API.G_RET_STS_ERROR;
1495: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);
1496: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
1497: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
1498: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
1499: FND_MSG_PUB.ADD;
1500: RETURN FALSE ;
1501:
1502: WHEN OTHERS THEN

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

1499: FND_MSG_PUB.ADD;
1500: RETURN FALSE ;
1501:
1502: WHEN OTHERS THEN
1503: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1504: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1505: FND_MSG_PUB.ADD;
1506: x_return_status := FND_API.g_ret_sts_unexp_error;
1507: RETURN FALSE ;

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

1500: RETURN FALSE ;
1501:
1502: WHEN OTHERS THEN
1503: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1504: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1505: FND_MSG_PUB.ADD;
1506: x_return_status := FND_API.g_ret_sts_unexp_error;
1507: RETURN FALSE ;
1508: END IS_WORKING_DAYTIME ;

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

1707: EXCEPTION
1708: WHEN INVALID_DATA_PASSED OR invalid_version THEN
1709: x_return_status := FND_API.G_RET_STS_ERROR;
1710: x_date := (sysdate - 9999 ) ;
1711: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1712: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1713: FND_MSG_PUB.ADD;
1714:
1715: WHEN CALENDAR_REQUIRED THEN

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

1708: WHEN INVALID_DATA_PASSED OR invalid_version THEN
1709: x_return_status := FND_API.G_RET_STS_ERROR;
1710: x_date := (sysdate - 9999 ) ;
1711: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1712: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1713: FND_MSG_PUB.ADD;
1714:
1715: WHEN CALENDAR_REQUIRED THEN
1716: x_return_status := FND_API.G_RET_STS_ERROR;

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

1713: FND_MSG_PUB.ADD;
1714:
1715: WHEN CALENDAR_REQUIRED THEN
1716: x_return_status := FND_API.G_RET_STS_ERROR;
1717: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
1718: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1719: FND_MSG_PUB.ADD;
1720: x_date := (sysdate - 9999 ) ;
1721:

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

1714:
1715: WHEN CALENDAR_REQUIRED THEN
1716: x_return_status := FND_API.G_RET_STS_ERROR;
1717: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
1718: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1719: FND_MSG_PUB.ADD;
1720: x_date := (sysdate - 9999 ) ;
1721:
1722: WHEN INVALID_VALUE THEN

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

1722: WHEN INVALID_VALUE THEN
1723: x_return_status := FND_API.G_RET_STS_ERROR;
1724: x_date := (sysdate - 9999 ) ;
1725: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);
1726: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
1727: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
1728: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
1729: FND_MSG_PUB.ADD;
1730:

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

1723: x_return_status := FND_API.G_RET_STS_ERROR;
1724: x_date := (sysdate - 9999 ) ;
1725: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);
1726: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
1727: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
1728: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
1729: FND_MSG_PUB.ADD;
1730:
1731: WHEN OTHERS THEN

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

1724: x_date := (sysdate - 9999 ) ;
1725: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);
1726: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
1727: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
1728: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
1729: FND_MSG_PUB.ADD;
1730:
1731: WHEN OTHERS THEN
1732: x_return_status := FND_API.g_ret_sts_unexp_error;

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

1730:
1731: WHEN OTHERS THEN
1732: x_return_status := FND_API.g_ret_sts_unexp_error;
1733: x_date := (sysdate - 9999 ) ;
1734: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1735: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1736: FND_MSG_PUB.ADD;
1737:
1738: END get_nearest_workdaytime ;

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

1731: WHEN OTHERS THEN
1732: x_return_status := FND_API.g_ret_sts_unexp_error;
1733: x_date := (sysdate - 9999 ) ;
1734: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1735: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1736: FND_MSG_PUB.ADD;
1737:
1738: END get_nearest_workdaytime ;
1739:

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

2035: EXCEPTION
2036: WHEN NO_DATA_FOUND THEN
2037: return_status := FALSE;
2038: WHEN OTHERS THEN
2039: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2040: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2041: FND_MSG_PUB.ADD;
2042: return_status := FALSE;
2043:

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

2036: WHEN NO_DATA_FOUND THEN
2037: return_status := FALSE;
2038: WHEN OTHERS THEN
2039: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2040: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2041: FND_MSG_PUB.ADD;
2042: return_status := FALSE;
2043:
2044: END retrieve_calendar_detail;