DBA Data[Home] [Help]

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 335: fnd_msg_pub.initialize;

331: x_return_status := FND_API.G_RET_STS_SUCCESS;
332:
333: /* Initialize message list and count if needed */
334: IF p_init_msg_list THEN
335: fnd_msg_pub.initialize;
336: END IF;
337:
338: /* Make sure we are call compatible */
339: IF NOT FND_API.compatible_api_call ( GMP_CALENDAR_API.m_api_version

Line 385: FND_MSG_PUB.ADD;

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:
389: ELSE

Line 394: FND_MSG_PUB.ADD;

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 */
398: -- log_message('Passed remaining_duration: '||remaining_duration);

Line 614: FND_MSG_PUB.ADD;

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

Line 630: FND_MSG_PUB.ADD;

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

Line 638: FND_MSG_PUB.ADD;

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

Line 745: FND_MSG_PUB.ADD;

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

Line 751: FND_MSG_PUB.ADD;

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

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

Line 764: FND_MSG_PUB.ADD;

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

Line 836: fnd_msg_pub.initialize;

832: x_return_status := FND_API.G_RET_STS_SUCCESS;
833:
834: /* Initialize message list and count if needed */
835: IF p_init_msg_list THEN
836: fnd_msg_pub.initialize;
837: END IF;
838:
839: /* Make sure we are call compatible */
840: IF NOT FND_API.compatible_api_call ( GMP_CALENDAR_API.m_api_version

Line 880: FND_MSG_PUB.ADD;

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

Line 893: FND_MSG_PUB.ADD;

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

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

Line 903: 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 ;
907:

Line 968: fnd_msg_pub.initialize;

964: x_return_status := FND_API.G_RET_STS_SUCCESS;
965:
966: /* Initialize message list and count if needed */
967: IF p_init_msg_list THEN
968: fnd_msg_pub.initialize;
969: END IF;
970:
971: /* Make sure we are call compatible */
972: IF NOT FND_API.compatible_api_call ( GMP_CALENDAR_API.m_api_version

Line 1004: FND_MSG_PUB.ADD;

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

Line 1017: FND_MSG_PUB.ADD;

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

Line 1022: 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 ;
1026:

Line 1085: fnd_msg_pub.initialize;

1081: x_return_status := FND_API.G_RET_STS_SUCCESS;
1082:
1083: /* Initialize message list and count if needed */
1084: IF p_init_msg_list THEN
1085: fnd_msg_pub.initialize;
1086: END IF;
1087:
1088: /* Make sure we are call compatible */
1089: IF NOT FND_API.compatible_api_call ( GMP_CALENDAR_API.m_api_version

Line 1121: FND_MSG_PUB.ADD;

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

Line 1134: FND_MSG_PUB.ADD;

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

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

Line 1144: 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 ;
1148:

Line 1223: FND_MSG_PUB.ADD;

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

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

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

Line 1238: 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: /* ==========================================================================
1242: Procedure:

Line 1327: FND_MSG_PUB.ADD;

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

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

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

Line 1342: 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;
1346:

Line 1421: fnd_msg_pub.initialize;

1417: x_return_status := FND_API.G_RET_STS_SUCCESS;
1418:
1419: /* Initialize message list and count if needed */
1420: IF p_init_msg_list THEN
1421: fnd_msg_pub.initialize;
1422: END IF;
1423:
1424: /* Make sure we are call compatible */
1425: IF NOT FND_API.compatible_api_call ( GMP_CALENDAR_API.m_api_version

Line 1483: FND_MSG_PUB.ADD;

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

Line 1490: FND_MSG_PUB.ADD;

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

Line 1499: FND_MSG_PUB.ADD;

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

Line 1505: FND_MSG_PUB.ADD;

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

Line 1626: fnd_msg_pub.initialize;

1622: x_return_status := FND_API.G_RET_STS_SUCCESS;
1623:
1624: /* Initialize message list and count if needed */
1625: IF p_init_msg_list THEN
1626: fnd_msg_pub.initialize;
1627: END IF;
1628:
1629: /* Make sure we are call compatible */
1630: IF NOT FND_API.compatible_api_call ( GMP_CALENDAR_API.m_api_version

Line 1713: FND_MSG_PUB.ADD;

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

Line 1719: FND_MSG_PUB.ADD;

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

Line 1729: FND_MSG_PUB.ADD;

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

Line 1736: FND_MSG_PUB.ADD;

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:
1740:

Line 2041: FND_MSG_PUB.ADD;

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