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 742: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');

738:
739: EXCEPTION
740: when g_exc_required_fields_null then
741: x_return_status := fnd_api.g_ret_sts_error ;
742: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
743: fnd_message.set_token('P_PARAMETER', l_parameters);
744: fnd_msg_pub.add;
745: fnd_msg_pub.count_and_get ( p_count => x_msg_count
746: , p_data => x_msg_data );

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

739: EXCEPTION
740: when g_exc_required_fields_null then
741: x_return_status := fnd_api.g_ret_sts_error ;
742: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
743: fnd_message.set_token('P_PARAMETER', l_parameters);
744: fnd_msg_pub.add;
745: fnd_msg_pub.count_and_get ( p_count => x_msg_count
746: , p_data => x_msg_data );
747:

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

755: , p_data => x_msg_data );
756:
757: when G_EXC_INVALID_SLOT_DURATION then
758: x_return_status := fnd_api.g_ret_sts_error ;
759: fnd_message.set_name('JTF','JTF_CAL_INVALID_DURATION');
760: fnd_msg_pub.add;
761: fnd_msg_pub.count_and_get ( p_count => x_msg_count
762: , p_data => x_msg_data );
763: when others then

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

761: fnd_msg_pub.count_and_get ( p_count => x_msg_count
762: , p_data => x_msg_data );
763: when others then
764: x_return_status := fnd_api.g_ret_sts_unexp_error ;
765: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
766: fnd_message.set_token('ERROR_CODE',sqlcode);
767: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
768: fnd_msg_pub.add;
769: fnd_msg_pub.count_and_get ( p_count => x_msg_count

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

762: , p_data => x_msg_data );
763: when others then
764: x_return_status := fnd_api.g_ret_sts_unexp_error ;
765: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
766: fnd_message.set_token('ERROR_CODE',sqlcode);
767: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
768: fnd_msg_pub.add;
769: fnd_msg_pub.count_and_get ( p_count => x_msg_count
770: , p_data => x_msg_data );

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

763: when others then
764: x_return_status := fnd_api.g_ret_sts_unexp_error ;
765: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
766: fnd_message.set_token('ERROR_CODE',sqlcode);
767: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
768: fnd_msg_pub.add;
769: fnd_msg_pub.count_and_get ( p_count => x_msg_count
770: , p_data => x_msg_data );
771: END get_available_time_slot;

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

846:
847: EXCEPTION
848: when g_exc_required_fields_null then
849: x_return_status := fnd_api.g_ret_sts_error ;
850: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
851: fnd_message.set_token('P_PARAMETER', l_parameters);
852: fnd_msg_pub.add;
853: fnd_msg_pub.count_and_get ( p_count => x_msg_count
854: , p_data => x_msg_data );

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

847: EXCEPTION
848: when g_exc_required_fields_null then
849: x_return_status := fnd_api.g_ret_sts_error ;
850: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
851: fnd_message.set_token('P_PARAMETER', l_parameters);
852: fnd_msg_pub.add;
853: fnd_msg_pub.count_and_get ( p_count => x_msg_count
854: , p_data => x_msg_data );
855:

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

863: , p_data => x_msg_data );
864:
865: when others then
866: x_return_status := fnd_api.g_ret_sts_unexp_error ;
867: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
868: fnd_message.set_token('ERROR_CODE',sqlcode);
869: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
870: fnd_msg_pub.add;
871: fnd_msg_pub.count_and_get ( p_count => x_msg_count

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

864:
865: when others then
866: x_return_status := fnd_api.g_ret_sts_unexp_error ;
867: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
868: fnd_message.set_token('ERROR_CODE',sqlcode);
869: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
870: fnd_msg_pub.add;
871: fnd_msg_pub.count_and_get ( p_count => x_msg_count
872: , p_data => x_msg_data );

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

865: when others then
866: x_return_status := fnd_api.g_ret_sts_unexp_error ;
867: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
868: fnd_message.set_token('ERROR_CODE',sqlcode);
869: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
870: fnd_msg_pub.add;
871: fnd_msg_pub.count_and_get ( p_count => x_msg_count
872: , p_data => x_msg_data );
873: END get_available_time;

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

974: p_data => x_msg_data
975: );
976: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
977: x_return_status := FND_API.G_RET_STS_ERROR ;
978: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
979: fnd_message.set_token('P_PARAMETER', l_parameters);
980: fnd_msg_pub.add;
981: FND_MSG_PUB.Count_And_Get
982: (p_count => x_msg_count,

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

975: );
976: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
977: x_return_status := FND_API.G_RET_STS_ERROR ;
978: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
979: fnd_message.set_token('P_PARAMETER', l_parameters);
980: fnd_msg_pub.add;
981: FND_MSG_PUB.Count_And_Get
982: (p_count => x_msg_count,
983: p_data => x_msg_data

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

987: fnd_msg_pub.count_and_get ( p_count => x_msg_count
988: , p_data => x_msg_data );
989: WHEN OTHERS THEN
990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
991: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
992: fnd_message.set_token('ERROR_CODE',SQLCODE);
993: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
994: fnd_msg_pub.add;
995: FND_MSG_PUB.Count_And_Get

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

988: , p_data => x_msg_data );
989: WHEN OTHERS THEN
990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
991: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
992: fnd_message.set_token('ERROR_CODE',SQLCODE);
993: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
994: fnd_msg_pub.add;
995: FND_MSG_PUB.Count_And_Get
996: (p_count => x_msg_count,

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

989: WHEN OTHERS THEN
990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
991: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
992: fnd_message.set_token('ERROR_CODE',SQLCODE);
993: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
994: fnd_msg_pub.add;
995: FND_MSG_PUB.Count_And_Get
996: (p_count => x_msg_count,
997: p_data => x_msg_data

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

1442: x_return_status := FND_API.G_RET_STS_ERROR ;
1443: -- Added for bug 3270116
1444: l_return_status := FND_API.G_RET_STS_ERROR ;
1445: -- end
1446: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
1447: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
1448: fnd_msg_pub.add;
1449: FND_MSG_PUB.Count_And_Get
1450: (p_count => x_msg_count,

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

1443: -- Added for bug 3270116
1444: l_return_status := FND_API.G_RET_STS_ERROR ;
1445: -- end
1446: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
1447: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
1448: fnd_msg_pub.add;
1449: FND_MSG_PUB.Count_And_Get
1450: (p_count => x_msg_count,
1451: p_data => x_msg_data

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

1460: -- as for this exception we want to handle it.
1461: -- For a resource, even if a single shift is returned for a search window
1462: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
1463: l_tbl.delete; -- to delete the record from TOR if no shift found
1464: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
1465: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
1466: fnd_message.set_token('P_RES_NAME', l_resource_name);
1467: fnd_msg_pub.add;
1468:

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

1461: -- For a resource, even if a single shift is returned for a search window
1462: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
1463: l_tbl.delete; -- to delete the record from TOR if no shift found
1464: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
1465: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
1466: fnd_message.set_token('P_RES_NAME', l_resource_name);
1467: fnd_msg_pub.add;
1468:
1469: FND_MSG_PUB.Count_And_Get

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

1462: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
1463: l_tbl.delete; -- to delete the record from TOR if no shift found
1464: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
1465: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
1466: fnd_message.set_token('P_RES_NAME', l_resource_name);
1467: fnd_msg_pub.add;
1468:
1469: FND_MSG_PUB.Count_And_Get
1470: (p_count => x_msg_count,

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

1480: x_return_status := fnd_api.g_ret_sts_error ;
1481: -- Added for bug 3270116
1482: l_return_status := FND_API.G_RET_STS_ERROR ;
1483: -- end
1484: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFT_CONSTR_FOUND');
1485: fnd_msg_pub.add;
1486:
1487: fnd_msg_pub.count_and_get( p_count => x_msg_count
1488: , p_data => x_msg_data );

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

1507: -- end
1508: EXCEPTION
1509: when g_exc_required_fields_null then
1510: x_return_status := fnd_api.g_ret_sts_error ;
1511: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
1512: fnd_message.set_token('P_PARAMETER', l_parameters);
1513: fnd_msg_pub.add;
1514: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1515: , p_data => x_msg_data );

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

1508: EXCEPTION
1509: when g_exc_required_fields_null then
1510: x_return_status := fnd_api.g_ret_sts_error ;
1511: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
1512: fnd_message.set_token('P_PARAMETER', l_parameters);
1513: fnd_msg_pub.add;
1514: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1515: , p_data => x_msg_data );
1516:

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

1524: , p_data => x_msg_data );
1525:
1526: when others then
1527: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1528: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
1529: fnd_message.set_token('ERROR_CODE',sqlcode);
1530: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
1531: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1532: , p_data => x_msg_data );

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

1525:
1526: when others then
1527: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1528: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
1529: fnd_message.set_token('ERROR_CODE',sqlcode);
1530: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
1531: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1532: , p_data => x_msg_data );
1533: END get_resource_shifts;

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

1526: when others then
1527: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1528: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
1529: fnd_message.set_token('ERROR_CODE',sqlcode);
1530: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
1531: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1532: , p_data => x_msg_data );
1533: END get_resource_shifts;
1534: --

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

2162: x_return_status := FND_API.G_RET_STS_ERROR ;
2163: -- Added for bug 3270116
2164: l_return_status := FND_API.G_RET_STS_ERROR ;
2165: -- end
2166: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
2167: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
2168: fnd_msg_pub.add;
2169: FND_MSG_PUB.Count_And_Get
2170: (p_count => x_msg_count,

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

2163: -- Added for bug 3270116
2164: l_return_status := FND_API.G_RET_STS_ERROR ;
2165: -- end
2166: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
2167: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
2168: fnd_msg_pub.add;
2169: FND_MSG_PUB.Count_And_Get
2170: (p_count => x_msg_count,
2171: p_data => x_msg_data

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

2179: -- as for this exception we want to handle it.
2180: -- For a resource, even if a single shift is returned in the search window
2181: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
2182: l_tbl.delete; -- to delete the record from TOR if no shift found
2183: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
2184: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
2185: fnd_message.set_token('P_RES_NAME', l_resource_name);
2186: fnd_msg_pub.add;
2187:

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

2180: -- For a resource, even if a single shift is returned in the search window
2181: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
2182: l_tbl.delete; -- to delete the record from TOR if no shift found
2183: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
2184: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
2185: fnd_message.set_token('P_RES_NAME', l_resource_name);
2186: fnd_msg_pub.add;
2187:
2188: FND_MSG_PUB.Count_And_Get

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

2181: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
2182: l_tbl.delete; -- to delete the record from TOR if no shift found
2183: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
2184: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
2185: fnd_message.set_token('P_RES_NAME', l_resource_name);
2186: fnd_msg_pub.add;
2187:
2188: FND_MSG_PUB.Count_And_Get
2189: (p_count => x_msg_count,

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

2200: x_return_status := fnd_api.g_ret_sts_error ;
2201: -- Added for bug 3270116
2202: l_return_status := FND_API.G_RET_STS_ERROR ;
2203: -- end
2204: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFT_CONSTR_FOUND');
2205: fnd_msg_pub.add;
2206:
2207: fnd_msg_pub.count_and_get( p_count => x_msg_count
2208: , p_data => x_msg_data );

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

2228:
2229: EXCEPTION
2230: when g_exc_required_fields_null then
2231: x_return_status := fnd_api.g_ret_sts_error ;
2232: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2233: fnd_message.set_token('P_PARAMETER', l_parameters);
2234: fnd_msg_pub.add;
2235: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2236: , p_data => x_msg_data );

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

2229: EXCEPTION
2230: when g_exc_required_fields_null then
2231: x_return_status := fnd_api.g_ret_sts_error ;
2232: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2233: fnd_message.set_token('P_PARAMETER', l_parameters);
2234: fnd_msg_pub.add;
2235: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2236: , p_data => x_msg_data );
2237:

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

2244: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2245: , p_data => x_msg_data );
2246: when others then
2247: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2248: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2249: fnd_message.set_token('ERROR_CODE',sqlcode);
2250: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
2251: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2252: , p_data => x_msg_data );

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

2245: , p_data => x_msg_data );
2246: when others then
2247: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2248: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2249: fnd_message.set_token('ERROR_CODE',sqlcode);
2250: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
2251: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2252: , p_data => x_msg_data );
2253:

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

2246: when others then
2247: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2248: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2249: fnd_message.set_token('ERROR_CODE',sqlcode);
2250: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
2251: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2252: , p_data => x_msg_data );
2253:
2254: --END;

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

2345: p_data => x_msg_data
2346: );
2347: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
2348: x_return_status := FND_API.G_RET_STS_ERROR ;
2349: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2350: fnd_message.set_token('P_PARAMETER', l_parameters);
2351: fnd_msg_pub.add;
2352: FND_MSG_PUB.Count_And_Get
2353: (p_count => x_msg_count,

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

2346: );
2347: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
2348: x_return_status := FND_API.G_RET_STS_ERROR ;
2349: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2350: fnd_message.set_token('P_PARAMETER', l_parameters);
2351: fnd_msg_pub.add;
2352: FND_MSG_PUB.Count_And_Get
2353: (p_count => x_msg_count,
2354: p_data => x_msg_data

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

2354: p_data => x_msg_data
2355: );
2356: WHEN OTHERS THEN
2357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2358: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2359: fnd_message.set_token('ERROR_CODE',SQLCODE);
2360: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2361: fnd_msg_pub.add;
2362: FND_MSG_PUB.Count_And_Get

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

2355: );
2356: WHEN OTHERS THEN
2357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2358: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2359: fnd_message.set_token('ERROR_CODE',SQLCODE);
2360: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2361: fnd_msg_pub.add;
2362: FND_MSG_PUB.Count_And_Get
2363: ( p_count => x_msg_count,

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

2356: WHEN OTHERS THEN
2357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2358: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2359: fnd_message.set_token('ERROR_CODE',SQLCODE);
2360: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2361: fnd_msg_pub.add;
2362: FND_MSG_PUB.Count_And_Get
2363: ( p_count => x_msg_count,
2364: p_data => x_msg_data

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

2820:
2821: exception
2822: when no_data_found then
2823: x_return_status := FND_API.G_RET_STS_ERROR ;
2824: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
2825: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
2826: fnd_msg_pub.add;
2827: FND_MSG_PUB.Count_And_Get
2828: (p_count => x_msg_count,

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

2821: exception
2822: when no_data_found then
2823: x_return_status := FND_API.G_RET_STS_ERROR ;
2824: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
2825: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
2826: fnd_msg_pub.add;
2827: FND_MSG_PUB.Count_And_Get
2828: (p_count => x_msg_count,
2829: p_data => x_msg_data

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

2832: end if; --(1)
2833: exception
2834: when no_data_found then
2835: x_return_status := FND_API.G_RET_STS_ERROR ;
2836: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
2837: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
2838: fnd_message.set_token('P_RES_NAME', l_resource_name);
2839: fnd_msg_pub.add;
2840: FND_MSG_PUB.Count_And_Get

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

2833: exception
2834: when no_data_found then
2835: x_return_status := FND_API.G_RET_STS_ERROR ;
2836: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
2837: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
2838: fnd_message.set_token('P_RES_NAME', l_resource_name);
2839: fnd_msg_pub.add;
2840: FND_MSG_PUB.Count_And_Get
2841: (p_count => x_msg_count,

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

2834: when no_data_found then
2835: x_return_status := FND_API.G_RET_STS_ERROR ;
2836: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
2837: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
2838: fnd_message.set_token('P_RES_NAME', l_resource_name);
2839: fnd_msg_pub.add;
2840: FND_MSG_PUB.Count_And_Get
2841: (p_count => x_msg_count,
2842: p_data => x_msg_data

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

2864: p_data => x_msg_data
2865: );
2866: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
2867: x_return_status := FND_API.G_RET_STS_ERROR ;
2868: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2869: fnd_message.set_token('P_PARAMETER', l_parameters);
2870: fnd_msg_pub.add;
2871: FND_MSG_PUB.Count_And_Get
2872: (p_count => x_msg_count,

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

2865: );
2866: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
2867: x_return_status := FND_API.G_RET_STS_ERROR ;
2868: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2869: fnd_message.set_token('P_PARAMETER', l_parameters);
2870: fnd_msg_pub.add;
2871: FND_MSG_PUB.Count_And_Get
2872: (p_count => x_msg_count,
2873: p_data => x_msg_data

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

2877: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2878: , p_data => x_msg_data );
2879: WHEN OTHERS THEN
2880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2881: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2882: fnd_message.set_token('ERROR_CODE',SQLCODE);
2883: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2884: fnd_msg_pub.add;
2885: FND_MSG_PUB.Count_And_Get

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

2878: , p_data => x_msg_data );
2879: WHEN OTHERS THEN
2880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2881: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2882: fnd_message.set_token('ERROR_CODE',SQLCODE);
2883: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2884: fnd_msg_pub.add;
2885: FND_MSG_PUB.Count_And_Get
2886: (p_count => x_msg_count,

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

2879: WHEN OTHERS THEN
2880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2881: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2882: fnd_message.set_token('ERROR_CODE',SQLCODE);
2883: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2884: fnd_msg_pub.add;
2885: FND_MSG_PUB.Count_And_Get
2886: (p_count => x_msg_count,
2887: p_data => x_msg_data

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

2991: p_data => x_msg_data
2992: );
2993: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
2994: x_return_status := FND_API.G_RET_STS_ERROR ;
2995: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2996: fnd_message.set_token('P_PARAMETER', l_parameters);
2997: fnd_msg_pub.add;
2998: FND_MSG_PUB.Count_And_Get
2999: (p_count => x_msg_count,

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

2992: );
2993: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
2994: x_return_status := FND_API.G_RET_STS_ERROR ;
2995: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2996: fnd_message.set_token('P_PARAMETER', l_parameters);
2997: fnd_msg_pub.add;
2998: FND_MSG_PUB.Count_And_Get
2999: (p_count => x_msg_count,
3000: p_data => x_msg_data

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

3000: p_data => x_msg_data
3001: );
3002: WHEN OTHERS THEN
3003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3004: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
3005: fnd_message.set_token('ERROR_CODE',SQLCODE);
3006: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
3007: fnd_msg_pub.add;
3008: FND_MSG_PUB.Count_And_Get

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

3001: );
3002: WHEN OTHERS THEN
3003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3004: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
3005: fnd_message.set_token('ERROR_CODE',SQLCODE);
3006: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
3007: fnd_msg_pub.add;
3008: FND_MSG_PUB.Count_And_Get
3009: ( p_count => x_msg_count,

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

3002: WHEN OTHERS THEN
3003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3004: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
3005: fnd_message.set_token('ERROR_CODE',SQLCODE);
3006: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
3007: fnd_msg_pub.add;
3008: FND_MSG_PUB.Count_And_Get
3009: ( p_count => x_msg_count,
3010: p_data => x_msg_data