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_MSG_PUB

Line 111: fnd_msg_pub.initialize;

107: x_return_status := FND_API.G_RET_STS_SUCCESS;
108:
109: /* Initialize message list and count if needed */
110: IF p_init_msg_list THEN
111: fnd_msg_pub.initialize;
112: END IF;
113:
114: /* Make sure we are call compatible */
115: IF NOT FND_API.compatible_api_call ( GMP_CALENDAR_API.m_api_version

Line 169: FND_MSG_PUB.ADD;

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
173: x_return_status := FND_API.G_RET_STS_ERROR;

Line 176: FND_MSG_PUB.ADD;

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
180: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 182: FND_MSG_PUB.ADD;

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
186: x_return_status := FND_API.G_RET_STS_ERROR;

Line 188: FND_MSG_PUB.ADD;

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
192: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 194: FND_MSG_PUB.ADD;

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;
198:

Line 304: fnd_msg_pub.initialize;

300: x_return_status := FND_API.G_RET_STS_SUCCESS;
301:
302: /* Initialize message list and count if needed */
303: IF p_init_msg_list THEN
304: fnd_msg_pub.initialize;
305: END IF;
306:
307: /* Make sure we are call compatible */
308: IF NOT FND_API.compatible_api_call ( GMP_CALENDAR_API.m_api_version

Line 539: FND_MSG_PUB.ADD;

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: /* } */
543: END IF ;

Line 551: FND_MSG_PUB.ADD;

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:
555: FND_FILE.PUT_LINE(FND_FILE.LOG,'Completed '||l_api_name ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

Line 566: FND_MSG_PUB.ADD;

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;
570:

Line 574: FND_MSG_PUB.ADD;

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: /*
578: ==========================================================================

Line 681: FND_MSG_PUB.ADD;

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;
685: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enter Start Or End Date '||X_msg);

Line 687: FND_MSG_PUB.ADD;

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

Line 692: 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;
696: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Value '||X_field||'-'||X_value);

Line 700: FND_MSG_PUB.ADD;

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: /* *****************************************************************
704: Gantt Chart APIs

Line 772: fnd_msg_pub.initialize;

768: x_return_status := FND_API.G_RET_STS_SUCCESS;
769:
770: /* Initialize message list and count if needed */
771: IF p_init_msg_list THEN
772: fnd_msg_pub.initialize;
773: END IF;
774:
775: /* Make sure we are call compatible */
776: IF NOT FND_API.compatible_api_call ( GMP_CALENDAR_API.m_api_version

Line 816: FND_MSG_PUB.ADD;

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

Line 829: FND_MSG_PUB.ADD;

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

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

Line 839: 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 ;
843:

Line 904: fnd_msg_pub.initialize;

900: x_return_status := FND_API.G_RET_STS_SUCCESS;
901:
902: /* Initialize message list and count if needed */
903: IF p_init_msg_list THEN
904: fnd_msg_pub.initialize;
905: END IF;
906:
907: /* Make sure we are call compatible */
908: IF NOT FND_API.compatible_api_call ( GMP_CALENDAR_API.m_api_version

Line 940: FND_MSG_PUB.ADD;

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

Line 953: FND_MSG_PUB.ADD;

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

Line 958: 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 ;
962:

Line 1021: fnd_msg_pub.initialize;

1017: x_return_status := FND_API.G_RET_STS_SUCCESS;
1018:
1019: /* Initialize message list and count if needed */
1020: IF p_init_msg_list THEN
1021: fnd_msg_pub.initialize;
1022: END IF;
1023:
1024: /* Make sure we are call compatible */
1025: IF NOT FND_API.compatible_api_call ( GMP_CALENDAR_API.m_api_version

Line 1057: FND_MSG_PUB.ADD;

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

Line 1070: FND_MSG_PUB.ADD;

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

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

Line 1080: 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 ;
1084:

Line 1159: FND_MSG_PUB.ADD;

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

Line 1164: 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;
1168: FND_MESSAGE.SET_NAME('GMP','GMP_EDATE_AFTER_CAL_EDATE');

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

Line 1174: 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: /* ==========================================================================
1178: Procedure:

Line 1263: FND_MSG_PUB.ADD;

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

Line 1268: 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;
1272: FND_MESSAGE.SET_NAME('GMP','PS_INVALID_CALENDAR');

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

Line 1278: 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;
1282:

Line 1354: fnd_msg_pub.initialize;

1350: x_return_status := FND_API.G_RET_STS_SUCCESS;
1351:
1352: /* Initialize message list and count if needed */
1353: IF p_init_msg_list THEN
1354: fnd_msg_pub.initialize;
1355: END IF;
1356:
1357: /* Make sure we are call compatible */
1358: IF NOT FND_API.compatible_api_call ( GMP_CALENDAR_API.m_api_version

Line 1416: FND_MSG_PUB.ADD;

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
1420: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1423: FND_MSG_PUB.ADD;

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
1427: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1432: FND_MSG_PUB.ADD;

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
1436: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 1438: FND_MSG_PUB.ADD;

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 ;
1442:

Line 1558: fnd_msg_pub.initialize;

1554: x_return_status := FND_API.G_RET_STS_SUCCESS;
1555:
1556: /* Initialize message list and count if needed */
1557: IF p_init_msg_list THEN
1558: fnd_msg_pub.initialize;
1559: END IF;
1560:
1561: /* Make sure we are call compatible */
1562: IF NOT FND_API.compatible_api_call ( GMP_CALENDAR_API.m_api_version

Line 1645: FND_MSG_PUB.ADD;

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

Line 1651: FND_MSG_PUB.ADD;

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
1655: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1661: FND_MSG_PUB.ADD;

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;
1665: x_date := (sysdate - 9999 ) ;

Line 1668: FND_MSG_PUB.ADD;

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:
1672: END gmp_calendar_api ;