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

Line 809: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');

805:
806: EXCEPTION
807: when g_exc_required_fields_null then
808: x_return_status := fnd_api.g_ret_sts_error ;
809: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
810: fnd_message.set_token('P_PARAMETER', l_parameters);
811: fnd_msg_pub.add;
812: fnd_msg_pub.count_and_get ( p_count => x_msg_count
813: , p_data => x_msg_data );

Line 810: fnd_message.set_token('P_PARAMETER', l_parameters);

806: EXCEPTION
807: when g_exc_required_fields_null then
808: x_return_status := fnd_api.g_ret_sts_error ;
809: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
810: fnd_message.set_token('P_PARAMETER', l_parameters);
811: fnd_msg_pub.add;
812: fnd_msg_pub.count_and_get ( p_count => x_msg_count
813: , p_data => x_msg_data );
814:

Line 826: fnd_message.set_name('JTF','JTF_CAL_INVALID_DURATION');

822: , p_data => x_msg_data );
823:
824: when G_EXC_INVALID_SLOT_DURATION then
825: x_return_status := fnd_api.g_ret_sts_error ;
826: fnd_message.set_name('JTF','JTF_CAL_INVALID_DURATION');
827: fnd_msg_pub.add;
828: fnd_msg_pub.count_and_get ( p_count => x_msg_count
829: , p_data => x_msg_data );
830: when others then

Line 832: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');

828: fnd_msg_pub.count_and_get ( p_count => x_msg_count
829: , p_data => x_msg_data );
830: when others then
831: x_return_status := fnd_api.g_ret_sts_unexp_error ;
832: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
833: fnd_message.set_token('ERROR_CODE',sqlcode);
834: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
835: fnd_msg_pub.add;
836: fnd_msg_pub.count_and_get ( p_count => x_msg_count

Line 833: fnd_message.set_token('ERROR_CODE',sqlcode);

829: , p_data => x_msg_data );
830: when others then
831: x_return_status := fnd_api.g_ret_sts_unexp_error ;
832: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
833: fnd_message.set_token('ERROR_CODE',sqlcode);
834: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
835: fnd_msg_pub.add;
836: fnd_msg_pub.count_and_get ( p_count => x_msg_count
837: , p_data => x_msg_data );

Line 834: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);

830: when others then
831: x_return_status := fnd_api.g_ret_sts_unexp_error ;
832: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
833: fnd_message.set_token('ERROR_CODE',sqlcode);
834: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
835: fnd_msg_pub.add;
836: fnd_msg_pub.count_and_get ( p_count => x_msg_count
837: , p_data => x_msg_data );
838: END get_available_time_slot;

Line 917: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');

913:
914: EXCEPTION
915: when g_exc_required_fields_null then
916: x_return_status := fnd_api.g_ret_sts_error ;
917: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
918: fnd_message.set_token('P_PARAMETER', l_parameters);
919: fnd_msg_pub.add;
920: fnd_msg_pub.count_and_get ( p_count => x_msg_count
921: , p_data => x_msg_data );

Line 918: fnd_message.set_token('P_PARAMETER', l_parameters);

914: EXCEPTION
915: when g_exc_required_fields_null then
916: x_return_status := fnd_api.g_ret_sts_error ;
917: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
918: fnd_message.set_token('P_PARAMETER', l_parameters);
919: fnd_msg_pub.add;
920: fnd_msg_pub.count_and_get ( p_count => x_msg_count
921: , p_data => x_msg_data );
922:

Line 934: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');

930: , p_data => x_msg_data );
931:
932: when others then
933: x_return_status := fnd_api.g_ret_sts_unexp_error ;
934: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
935: fnd_message.set_token('ERROR_CODE',sqlcode);
936: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
937: fnd_msg_pub.add;
938: fnd_msg_pub.count_and_get ( p_count => x_msg_count

Line 935: fnd_message.set_token('ERROR_CODE',sqlcode);

931:
932: when others then
933: x_return_status := fnd_api.g_ret_sts_unexp_error ;
934: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
935: fnd_message.set_token('ERROR_CODE',sqlcode);
936: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
937: fnd_msg_pub.add;
938: fnd_msg_pub.count_and_get ( p_count => x_msg_count
939: , p_data => x_msg_data );

Line 936: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);

932: when others then
933: x_return_status := fnd_api.g_ret_sts_unexp_error ;
934: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
935: fnd_message.set_token('ERROR_CODE',sqlcode);
936: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
937: fnd_msg_pub.add;
938: fnd_msg_pub.count_and_get ( p_count => x_msg_count
939: , p_data => x_msg_data );
940: END get_available_time;

Line 1045: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');

1041: p_data => x_msg_data
1042: );
1043: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
1044: x_return_status := FND_API.G_RET_STS_ERROR ;
1045: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
1046: fnd_message.set_token('P_PARAMETER', l_parameters);
1047: fnd_msg_pub.add;
1048: FND_MSG_PUB.Count_And_Get
1049: (p_count => x_msg_count,

Line 1046: fnd_message.set_token('P_PARAMETER', l_parameters);

1042: );
1043: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
1044: x_return_status := FND_API.G_RET_STS_ERROR ;
1045: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
1046: fnd_message.set_token('P_PARAMETER', l_parameters);
1047: fnd_msg_pub.add;
1048: FND_MSG_PUB.Count_And_Get
1049: (p_count => x_msg_count,
1050: p_data => x_msg_data

Line 1058: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');

1054: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1055: , p_data => x_msg_data );
1056: WHEN OTHERS THEN
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1058: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
1059: fnd_message.set_token('ERROR_CODE',SQLCODE);
1060: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
1061: fnd_msg_pub.add;
1062: FND_MSG_PUB.Count_And_Get

Line 1059: fnd_message.set_token('ERROR_CODE',SQLCODE);

1055: , p_data => x_msg_data );
1056: WHEN OTHERS THEN
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1058: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
1059: fnd_message.set_token('ERROR_CODE',SQLCODE);
1060: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
1061: fnd_msg_pub.add;
1062: FND_MSG_PUB.Count_And_Get
1063: (p_count => x_msg_count,

Line 1060: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);

1056: WHEN OTHERS THEN
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1058: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
1059: fnd_message.set_token('ERROR_CODE',SQLCODE);
1060: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
1061: fnd_msg_pub.add;
1062: FND_MSG_PUB.Count_And_Get
1063: (p_count => x_msg_count,
1064: p_data => x_msg_data

Line 1513: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');

1509: x_return_status := FND_API.G_RET_STS_ERROR ;
1510: -- Added for bug 3270116
1511: l_return_status := FND_API.G_RET_STS_ERROR ;
1512: -- end
1513: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
1514: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
1515: fnd_msg_pub.add;
1516: FND_MSG_PUB.Count_And_Get
1517: (p_count => x_msg_count,

Line 1514: fnd_message.set_token('P_CAL_NAME', l_calendar_name);

1510: -- Added for bug 3270116
1511: l_return_status := FND_API.G_RET_STS_ERROR ;
1512: -- end
1513: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
1514: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
1515: fnd_msg_pub.add;
1516: FND_MSG_PUB.Count_And_Get
1517: (p_count => x_msg_count,
1518: p_data => x_msg_data

Line 1531: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');

1527: -- as for this exception we want to handle it.
1528: -- For a resource, even if a single shift is returned for a search window
1529: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
1530: l_tbl.delete; -- to delete the record from TOR if no shift found
1531: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
1532: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
1533: fnd_message.set_token('P_RES_NAME', l_resource_name);
1534: fnd_msg_pub.add;
1535:

Line 1532: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);

1528: -- For a resource, even if a single shift is returned for a search window
1529: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
1530: l_tbl.delete; -- to delete the record from TOR if no shift found
1531: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
1532: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
1533: fnd_message.set_token('P_RES_NAME', l_resource_name);
1534: fnd_msg_pub.add;
1535:
1536: FND_MSG_PUB.Count_And_Get

Line 1533: fnd_message.set_token('P_RES_NAME', l_resource_name);

1529: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
1530: l_tbl.delete; -- to delete the record from TOR if no shift found
1531: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
1532: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
1533: fnd_message.set_token('P_RES_NAME', l_resource_name);
1534: fnd_msg_pub.add;
1535:
1536: FND_MSG_PUB.Count_And_Get
1537: (p_count => x_msg_count,

Line 1551: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFT_CONSTR_FOUND');

1547: x_return_status := fnd_api.g_ret_sts_error ;
1548: -- Added for bug 3270116
1549: l_return_status := FND_API.G_RET_STS_ERROR ;
1550: -- end
1551: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFT_CONSTR_FOUND');
1552: fnd_msg_pub.add;
1553:
1554: fnd_msg_pub.count_and_get( p_count => x_msg_count
1555: , p_data => x_msg_data );

Line 1578: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');

1574: -- end
1575: EXCEPTION
1576: when g_exc_required_fields_null then
1577: x_return_status := fnd_api.g_ret_sts_error ;
1578: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
1579: fnd_message.set_token('P_PARAMETER', l_parameters);
1580: fnd_msg_pub.add;
1581: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1582: , p_data => x_msg_data );

Line 1579: fnd_message.set_token('P_PARAMETER', l_parameters);

1575: EXCEPTION
1576: when g_exc_required_fields_null then
1577: x_return_status := fnd_api.g_ret_sts_error ;
1578: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
1579: fnd_message.set_token('P_PARAMETER', l_parameters);
1580: fnd_msg_pub.add;
1581: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1582: , p_data => x_msg_data );
1583:

Line 1595: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');

1591: , p_data => x_msg_data );
1592:
1593: when others then
1594: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1595: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
1596: fnd_message.set_token('ERROR_CODE',sqlcode);
1597: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
1598: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1599: , p_data => x_msg_data );

Line 1596: fnd_message.set_token('ERROR_CODE',sqlcode);

1592:
1593: when others then
1594: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1595: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
1596: fnd_message.set_token('ERROR_CODE',sqlcode);
1597: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
1598: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1599: , p_data => x_msg_data );
1600: END get_resource_shifts;

Line 1597: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);

1593: when others then
1594: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1595: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
1596: fnd_message.set_token('ERROR_CODE',sqlcode);
1597: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
1598: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1599: , p_data => x_msg_data );
1600: END get_resource_shifts;
1601: --

Line 2236: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');

2232: x_return_status := FND_API.G_RET_STS_ERROR ;
2233: -- Added for bug 3270116
2234: l_return_status := FND_API.G_RET_STS_ERROR ;
2235: -- end
2236: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
2237: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
2238: fnd_msg_pub.add;
2239: FND_MSG_PUB.Count_And_Get
2240: (p_count => x_msg_count,

Line 2237: fnd_message.set_token('P_CAL_NAME', l_calendar_name);

2233: -- Added for bug 3270116
2234: l_return_status := FND_API.G_RET_STS_ERROR ;
2235: -- end
2236: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
2237: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
2238: fnd_msg_pub.add;
2239: FND_MSG_PUB.Count_And_Get
2240: (p_count => x_msg_count,
2241: p_data => x_msg_data

Line 2253: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');

2249: -- as for this exception we want to handle it.
2250: -- For a resource, even if a single shift is returned in the search window
2251: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
2252: l_tbl.delete; -- to delete the record from TOR if no shift found
2253: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
2254: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
2255: fnd_message.set_token('P_RES_NAME', l_resource_name);
2256: fnd_msg_pub.add;
2257:

Line 2254: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);

2250: -- For a resource, even if a single shift is returned in the search window
2251: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
2252: l_tbl.delete; -- to delete the record from TOR if no shift found
2253: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
2254: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
2255: fnd_message.set_token('P_RES_NAME', l_resource_name);
2256: fnd_msg_pub.add;
2257:
2258: FND_MSG_PUB.Count_And_Get

Line 2255: fnd_message.set_token('P_RES_NAME', l_resource_name);

2251: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
2252: l_tbl.delete; -- to delete the record from TOR if no shift found
2253: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
2254: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
2255: fnd_message.set_token('P_RES_NAME', l_resource_name);
2256: fnd_msg_pub.add;
2257:
2258: FND_MSG_PUB.Count_And_Get
2259: (p_count => x_msg_count,

Line 2274: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFT_CONSTR_FOUND');

2270: x_return_status := fnd_api.g_ret_sts_error ;
2271: -- Added for bug 3270116
2272: l_return_status := FND_API.G_RET_STS_ERROR ;
2273: -- end
2274: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFT_CONSTR_FOUND');
2275: fnd_msg_pub.add;
2276:
2277: fnd_msg_pub.count_and_get( p_count => x_msg_count
2278: , p_data => x_msg_data );

Line 2302: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');

2298:
2299: EXCEPTION
2300: when g_exc_required_fields_null then
2301: x_return_status := fnd_api.g_ret_sts_error ;
2302: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2303: fnd_message.set_token('P_PARAMETER', l_parameters);
2304: fnd_msg_pub.add;
2305: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2306: , p_data => x_msg_data );

Line 2303: fnd_message.set_token('P_PARAMETER', l_parameters);

2299: EXCEPTION
2300: when g_exc_required_fields_null then
2301: x_return_status := fnd_api.g_ret_sts_error ;
2302: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2303: fnd_message.set_token('P_PARAMETER', l_parameters);
2304: fnd_msg_pub.add;
2305: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2306: , p_data => x_msg_data );
2307:

Line 2318: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');

2314: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2315: , p_data => x_msg_data );
2316: when others then
2317: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2318: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2319: fnd_message.set_token('ERROR_CODE',sqlcode);
2320: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
2321: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2322: , p_data => x_msg_data );

Line 2319: fnd_message.set_token('ERROR_CODE',sqlcode);

2315: , p_data => x_msg_data );
2316: when others then
2317: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2318: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2319: fnd_message.set_token('ERROR_CODE',sqlcode);
2320: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
2321: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2322: , p_data => x_msg_data );
2323:

Line 2320: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);

2316: when others then
2317: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2318: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2319: fnd_message.set_token('ERROR_CODE',sqlcode);
2320: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
2321: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2322: , p_data => x_msg_data );
2323:
2324: --END;

Line 2419: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');

2415: p_data => x_msg_data
2416: );
2417: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
2418: x_return_status := FND_API.G_RET_STS_ERROR ;
2419: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2420: fnd_message.set_token('P_PARAMETER', l_parameters);
2421: fnd_msg_pub.add;
2422: FND_MSG_PUB.Count_And_Get
2423: (p_count => x_msg_count,

Line 2420: fnd_message.set_token('P_PARAMETER', l_parameters);

2416: );
2417: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
2418: x_return_status := FND_API.G_RET_STS_ERROR ;
2419: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2420: fnd_message.set_token('P_PARAMETER', l_parameters);
2421: fnd_msg_pub.add;
2422: FND_MSG_PUB.Count_And_Get
2423: (p_count => x_msg_count,
2424: p_data => x_msg_data

Line 2428: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');

2424: p_data => x_msg_data
2425: );
2426: WHEN OTHERS THEN
2427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2428: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2429: fnd_message.set_token('ERROR_CODE',SQLCODE);
2430: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2431: fnd_msg_pub.add;
2432: FND_MSG_PUB.Count_And_Get

Line 2429: fnd_message.set_token('ERROR_CODE',SQLCODE);

2425: );
2426: WHEN OTHERS THEN
2427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2428: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2429: fnd_message.set_token('ERROR_CODE',SQLCODE);
2430: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2431: fnd_msg_pub.add;
2432: FND_MSG_PUB.Count_And_Get
2433: ( p_count => x_msg_count,

Line 2430: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);

2426: WHEN OTHERS THEN
2427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2428: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2429: fnd_message.set_token('ERROR_CODE',SQLCODE);
2430: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2431: fnd_msg_pub.add;
2432: FND_MSG_PUB.Count_And_Get
2433: ( p_count => x_msg_count,
2434: p_data => x_msg_data

Line 2894: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');

2890:
2891: exception
2892: when no_data_found then
2893: x_return_status := FND_API.G_RET_STS_ERROR ;
2894: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
2895: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
2896: fnd_msg_pub.add;
2897: FND_MSG_PUB.Count_And_Get
2898: (p_count => x_msg_count,

Line 2895: fnd_message.set_token('P_CAL_NAME', l_calendar_name);

2891: exception
2892: when no_data_found then
2893: x_return_status := FND_API.G_RET_STS_ERROR ;
2894: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
2895: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
2896: fnd_msg_pub.add;
2897: FND_MSG_PUB.Count_And_Get
2898: (p_count => x_msg_count,
2899: p_data => x_msg_data

Line 2906: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');

2902: end if; --(1)
2903: exception
2904: when no_data_found then
2905: x_return_status := FND_API.G_RET_STS_ERROR ;
2906: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
2907: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
2908: fnd_message.set_token('P_RES_NAME', l_resource_name);
2909: fnd_msg_pub.add;
2910: FND_MSG_PUB.Count_And_Get

Line 2907: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);

2903: exception
2904: when no_data_found then
2905: x_return_status := FND_API.G_RET_STS_ERROR ;
2906: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
2907: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
2908: fnd_message.set_token('P_RES_NAME', l_resource_name);
2909: fnd_msg_pub.add;
2910: FND_MSG_PUB.Count_And_Get
2911: (p_count => x_msg_count,

Line 2908: fnd_message.set_token('P_RES_NAME', l_resource_name);

2904: when no_data_found then
2905: x_return_status := FND_API.G_RET_STS_ERROR ;
2906: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
2907: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
2908: fnd_message.set_token('P_RES_NAME', l_resource_name);
2909: fnd_msg_pub.add;
2910: FND_MSG_PUB.Count_And_Get
2911: (p_count => x_msg_count,
2912: p_data => x_msg_data

Line 2938: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');

2934: p_data => x_msg_data
2935: );
2936: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
2937: x_return_status := FND_API.G_RET_STS_ERROR ;
2938: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2939: fnd_message.set_token('P_PARAMETER', l_parameters);
2940: fnd_msg_pub.add;
2941: FND_MSG_PUB.Count_And_Get
2942: (p_count => x_msg_count,

Line 2939: fnd_message.set_token('P_PARAMETER', l_parameters);

2935: );
2936: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
2937: x_return_status := FND_API.G_RET_STS_ERROR ;
2938: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2939: fnd_message.set_token('P_PARAMETER', l_parameters);
2940: fnd_msg_pub.add;
2941: FND_MSG_PUB.Count_And_Get
2942: (p_count => x_msg_count,
2943: p_data => x_msg_data

Line 2951: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');

2947: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2948: , p_data => x_msg_data );
2949: WHEN OTHERS THEN
2950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2951: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2952: fnd_message.set_token('ERROR_CODE',SQLCODE);
2953: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2954: fnd_msg_pub.add;
2955: FND_MSG_PUB.Count_And_Get

Line 2952: fnd_message.set_token('ERROR_CODE',SQLCODE);

2948: , p_data => x_msg_data );
2949: WHEN OTHERS THEN
2950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2951: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2952: fnd_message.set_token('ERROR_CODE',SQLCODE);
2953: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2954: fnd_msg_pub.add;
2955: FND_MSG_PUB.Count_And_Get
2956: (p_count => x_msg_count,

Line 2953: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);

2949: WHEN OTHERS THEN
2950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2951: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2952: fnd_message.set_token('ERROR_CODE',SQLCODE);
2953: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2954: fnd_msg_pub.add;
2955: FND_MSG_PUB.Count_And_Get
2956: (p_count => x_msg_count,
2957: p_data => x_msg_data

Line 3065: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');

3061: p_data => x_msg_data
3062: );
3063: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
3064: x_return_status := FND_API.G_RET_STS_ERROR ;
3065: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
3066: fnd_message.set_token('P_PARAMETER', l_parameters);
3067: fnd_msg_pub.add;
3068: FND_MSG_PUB.Count_And_Get
3069: (p_count => x_msg_count,

Line 3066: fnd_message.set_token('P_PARAMETER', l_parameters);

3062: );
3063: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
3064: x_return_status := FND_API.G_RET_STS_ERROR ;
3065: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
3066: fnd_message.set_token('P_PARAMETER', l_parameters);
3067: fnd_msg_pub.add;
3068: FND_MSG_PUB.Count_And_Get
3069: (p_count => x_msg_count,
3070: p_data => x_msg_data

Line 3074: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');

3070: p_data => x_msg_data
3071: );
3072: WHEN OTHERS THEN
3073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3074: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
3075: fnd_message.set_token('ERROR_CODE',SQLCODE);
3076: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
3077: fnd_msg_pub.add;
3078: FND_MSG_PUB.Count_And_Get

Line 3075: fnd_message.set_token('ERROR_CODE',SQLCODE);

3071: );
3072: WHEN OTHERS THEN
3073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3074: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
3075: fnd_message.set_token('ERROR_CODE',SQLCODE);
3076: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
3077: fnd_msg_pub.add;
3078: FND_MSG_PUB.Count_And_Get
3079: ( p_count => x_msg_count,

Line 3076: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);

3072: WHEN OTHERS THEN
3073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3074: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
3075: fnd_message.set_token('ERROR_CODE',SQLCODE);
3076: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
3077: fnd_msg_pub.add;
3078: FND_MSG_PUB.Count_And_Get
3079: ( p_count => x_msg_count,
3080: p_data => x_msg_data