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

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

258: p_data => x_msg_data
259: );
260: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
261: x_return_status := FND_API.G_RET_STS_ERROR ;
262: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
263: fnd_message.set_token('P_PARAMETER', l_parameters);
264: fnd_msg_pub.add;
265: FND_MSG_PUB.Count_And_Get
266: (p_count => x_msg_count,

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

259: );
260: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
261: x_return_status := FND_API.G_RET_STS_ERROR ;
262: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
263: fnd_message.set_token('P_PARAMETER', l_parameters);
264: fnd_msg_pub.add;
265: FND_MSG_PUB.Count_And_Get
266: (p_count => x_msg_count,
267: p_data => x_msg_data

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

267: p_data => x_msg_data
268: );
269: WHEN OTHERS THEN
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
271: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
272: fnd_message.set_token('ERROR_CODE',SQLCODE);
273: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
274: fnd_msg_pub.add;
275: FND_MSG_PUB.Count_And_Get

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

268: );
269: WHEN OTHERS THEN
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
271: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
272: fnd_message.set_token('ERROR_CODE',SQLCODE);
273: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
274: fnd_msg_pub.add;
275: FND_MSG_PUB.Count_And_Get
276: ( p_count => x_msg_count,

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

269: WHEN OTHERS THEN
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
271: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
272: fnd_message.set_token('ERROR_CODE',SQLCODE);
273: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
274: fnd_msg_pub.add;
275: FND_MSG_PUB.Count_And_Get
276: ( p_count => x_msg_count,
277: p_data => x_msg_data

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

729: --
730: -- Update return status to Success if there is atleast one available time slot
731: if x_shift.count = 0 then
732: x_return_status := fnd_api.g_ret_sts_error ;
733: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFT_CONSTR_FOUND');
734: --fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS_FOR_RESOURCE');
735: --fnd_message.set_token('P_RESOURCE_NAME', l_resource_name);
736: fnd_msg_pub.add;
737: fnd_msg_pub.count_and_get( p_count => x_msg_count

Line 734: --fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS_FOR_RESOURCE');

730: -- Update return status to Success if there is atleast one available time slot
731: if x_shift.count = 0 then
732: x_return_status := fnd_api.g_ret_sts_error ;
733: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFT_CONSTR_FOUND');
734: --fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS_FOR_RESOURCE');
735: --fnd_message.set_token('P_RESOURCE_NAME', l_resource_name);
736: fnd_msg_pub.add;
737: fnd_msg_pub.count_and_get( p_count => x_msg_count
738: , p_data => x_msg_data );

Line 735: --fnd_message.set_token('P_RESOURCE_NAME', l_resource_name);

731: if x_shift.count = 0 then
732: x_return_status := fnd_api.g_ret_sts_error ;
733: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFT_CONSTR_FOUND');
734: --fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS_FOR_RESOURCE');
735: --fnd_message.set_token('P_RESOURCE_NAME', l_resource_name);
736: fnd_msg_pub.add;
737: fnd_msg_pub.count_and_get( p_count => x_msg_count
738: , p_data => x_msg_data );
739: end if;

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

747:
748: EXCEPTION
749: when g_exc_required_fields_null then
750: x_return_status := fnd_api.g_ret_sts_error ;
751: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
752: fnd_message.set_token('P_PARAMETER', l_parameters);
753: fnd_msg_pub.add;
754: fnd_msg_pub.count_and_get ( p_count => x_msg_count
755: , p_data => x_msg_data );

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

748: EXCEPTION
749: when g_exc_required_fields_null then
750: x_return_status := fnd_api.g_ret_sts_error ;
751: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
752: fnd_message.set_token('P_PARAMETER', l_parameters);
753: fnd_msg_pub.add;
754: fnd_msg_pub.count_and_get ( p_count => x_msg_count
755: , p_data => x_msg_data );
756:

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

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

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

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

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

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

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

854: p_data => x_msg_data
855: );
856: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
857: x_return_status := FND_API.G_RET_STS_ERROR ;
858: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
859: fnd_message.set_token('P_PARAMETER', l_parameters);
860: fnd_msg_pub.add;
861: FND_MSG_PUB.Count_And_Get
862: (p_count => x_msg_count,

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

855: );
856: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
857: x_return_status := FND_API.G_RET_STS_ERROR ;
858: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
859: fnd_message.set_token('P_PARAMETER', l_parameters);
860: fnd_msg_pub.add;
861: FND_MSG_PUB.Count_And_Get
862: (p_count => x_msg_count,
863: p_data => x_msg_data

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

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
872: (p_count => x_msg_count,

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
872: (p_count => x_msg_count,
873: p_data => x_msg_data

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

1261: x_return_status := FND_API.G_RET_STS_ERROR ;
1262: -- Added for bug 3270116
1263: l_return_status := FND_API.G_RET_STS_ERROR ;
1264: -- end
1265: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
1266: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
1267: fnd_msg_pub.add;
1268: FND_MSG_PUB.Count_And_Get
1269: (p_count => x_msg_count,

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

1262: -- Added for bug 3270116
1263: l_return_status := FND_API.G_RET_STS_ERROR ;
1264: -- end
1265: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
1266: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
1267: fnd_msg_pub.add;
1268: FND_MSG_PUB.Count_And_Get
1269: (p_count => x_msg_count,
1270: p_data => x_msg_data

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

1278: -- as for this exception we want to handle it.
1279: -- For a resource, even if a single shift is returned for a search window
1280: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
1281: l_tbl.delete; -- to delete the record from TOR if no shift found
1282: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
1283: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
1284: fnd_message.set_token('P_RES_NAME', l_resource_name);
1285: fnd_msg_pub.add;
1286:

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

1279: -- For a resource, even if a single shift is returned for a search window
1280: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
1281: l_tbl.delete; -- to delete the record from TOR if no shift found
1282: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
1283: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
1284: fnd_message.set_token('P_RES_NAME', l_resource_name);
1285: fnd_msg_pub.add;
1286:
1287: FND_MSG_PUB.Count_And_Get

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

1280: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
1281: l_tbl.delete; -- to delete the record from TOR if no shift found
1282: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
1283: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
1284: fnd_message.set_token('P_RES_NAME', l_resource_name);
1285: fnd_msg_pub.add;
1286:
1287: FND_MSG_PUB.Count_And_Get
1288: (p_count => x_msg_count,

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

1299: x_return_status := fnd_api.g_ret_sts_error ;
1300: -- Added for bug 3270116
1301: l_return_status := FND_API.G_RET_STS_ERROR ;
1302: -- end
1303: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFT_CONSTR_FOUND');
1304: fnd_msg_pub.add;
1305:
1306: fnd_msg_pub.count_and_get( p_count => x_msg_count
1307: , p_data => x_msg_data );

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

1325: -- end
1326: EXCEPTION
1327: when g_exc_required_fields_null then
1328: x_return_status := fnd_api.g_ret_sts_error ;
1329: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
1330: fnd_message.set_token('P_PARAMETER', l_parameters);
1331: fnd_msg_pub.add;
1332: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1333: , p_data => x_msg_data );

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

1326: EXCEPTION
1327: when g_exc_required_fields_null then
1328: x_return_status := fnd_api.g_ret_sts_error ;
1329: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
1330: fnd_message.set_token('P_PARAMETER', l_parameters);
1331: fnd_msg_pub.add;
1332: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1333: , p_data => x_msg_data );
1334:

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

1337: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1338: , p_data => x_msg_data );
1339: when others then
1340: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1341: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
1342: fnd_message.set_token('ERROR_CODE',sqlcode);
1343: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
1344: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1345: , p_data => x_msg_data );

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

1338: , p_data => x_msg_data );
1339: when others then
1340: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1341: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
1342: fnd_message.set_token('ERROR_CODE',sqlcode);
1343: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
1344: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1345: , p_data => x_msg_data );
1346: --END;

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

1339: when others then
1340: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1341: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
1342: fnd_message.set_token('ERROR_CODE',sqlcode);
1343: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
1344: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1345: , p_data => x_msg_data );
1346: --END;
1347: END get_resource_shifts;

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

1922: x_return_status := FND_API.G_RET_STS_ERROR ;
1923: -- Added for bug 3270116
1924: l_return_status := FND_API.G_RET_STS_ERROR ;
1925: -- end
1926: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
1927: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
1928: fnd_msg_pub.add;
1929: FND_MSG_PUB.Count_And_Get
1930: (p_count => x_msg_count,

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

1923: -- Added for bug 3270116
1924: l_return_status := FND_API.G_RET_STS_ERROR ;
1925: -- end
1926: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
1927: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
1928: fnd_msg_pub.add;
1929: FND_MSG_PUB.Count_And_Get
1930: (p_count => x_msg_count,
1931: p_data => x_msg_data

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

1939: -- as for this exception we want to handle it.
1940: -- For a resource, even if a single shift is returned for a search window
1941: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
1942: l_tbl.delete; -- to delete the record from TOR if no shift found
1943: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
1944: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
1945: fnd_message.set_token('P_RES_NAME', l_resource_name);
1946: fnd_msg_pub.add;
1947:

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

1940: -- For a resource, even if a single shift is returned for a search window
1941: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
1942: l_tbl.delete; -- to delete the record from TOR if no shift found
1943: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
1944: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
1945: fnd_message.set_token('P_RES_NAME', l_resource_name);
1946: fnd_msg_pub.add;
1947:
1948: FND_MSG_PUB.Count_And_Get

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

1941: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
1942: l_tbl.delete; -- to delete the record from TOR if no shift found
1943: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
1944: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
1945: fnd_message.set_token('P_RES_NAME', l_resource_name);
1946: fnd_msg_pub.add;
1947:
1948: FND_MSG_PUB.Count_And_Get
1949: (p_count => x_msg_count,

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

1961: x_return_status := fnd_api.g_ret_sts_error ;
1962: -- Added for bug 3270116
1963: l_return_status := FND_API.G_RET_STS_ERROR ;
1964: -- end
1965: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFT_CONSTR_FOUND');
1966: fnd_msg_pub.add;
1967:
1968: fnd_msg_pub.count_and_get( p_count => x_msg_count
1969: , p_data => x_msg_data );

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

1988:
1989: EXCEPTION
1990: when g_exc_required_fields_null then
1991: x_return_status := fnd_api.g_ret_sts_error ;
1992: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
1993: fnd_message.set_token('P_PARAMETER', l_parameters);
1994: fnd_msg_pub.add;
1995: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1996: , p_data => x_msg_data );

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

1989: EXCEPTION
1990: when g_exc_required_fields_null then
1991: x_return_status := fnd_api.g_ret_sts_error ;
1992: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
1993: fnd_message.set_token('P_PARAMETER', l_parameters);
1994: fnd_msg_pub.add;
1995: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1996: , p_data => x_msg_data );
1997:

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

2000: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2001: , p_data => x_msg_data );
2002: when others then
2003: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2004: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2005: fnd_message.set_token('ERROR_CODE',sqlcode);
2006: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
2007: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2008: , p_data => x_msg_data );

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

2001: , p_data => x_msg_data );
2002: when others then
2003: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2004: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2005: fnd_message.set_token('ERROR_CODE',sqlcode);
2006: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
2007: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2008: , p_data => x_msg_data );
2009: --END;

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

2002: when others then
2003: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2004: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2005: fnd_message.set_token('ERROR_CODE',sqlcode);
2006: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
2007: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2008: , p_data => x_msg_data );
2009: --END;
2010: END get_resource_shifts;

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

2402: END LOOP;
2403: exception
2404: when no_data_found then
2405: x_return_status := FND_API.G_RET_STS_ERROR ;
2406: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
2407: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
2408: fnd_msg_pub.add;
2409: FND_MSG_PUB.Count_And_Get
2410: (p_count => x_msg_count,

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

2403: exception
2404: when no_data_found then
2405: x_return_status := FND_API.G_RET_STS_ERROR ;
2406: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
2407: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
2408: fnd_msg_pub.add;
2409: FND_MSG_PUB.Count_And_Get
2410: (p_count => x_msg_count,
2411: p_data => x_msg_data

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

2414: end if; --(1)
2415: exception
2416: when no_data_found then
2417: x_return_status := FND_API.G_RET_STS_ERROR ;
2418: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
2419: fnd_message.set_token('P_RES_NAME', l_resource_name);
2420: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
2421: fnd_msg_pub.add;
2422: FND_MSG_PUB.Count_And_Get

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

2415: exception
2416: when no_data_found then
2417: x_return_status := FND_API.G_RET_STS_ERROR ;
2418: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
2419: fnd_message.set_token('P_RES_NAME', l_resource_name);
2420: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
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_SHIFT_DATE', l_shift_date);

2416: when no_data_found then
2417: x_return_status := FND_API.G_RET_STS_ERROR ;
2418: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
2419: fnd_message.set_token('P_RES_NAME', l_resource_name);
2420: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
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 2451: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');

2447: p_data => x_msg_data
2448: );
2449: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
2450: x_return_status := FND_API.G_RET_STS_ERROR ;
2451: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2452: fnd_message.set_token('P_PARAMETER', l_parameters);
2453: fnd_msg_pub.add;
2454: FND_MSG_PUB.Count_And_Get
2455: (p_count => x_msg_count,

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

2448: );
2449: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
2450: x_return_status := FND_API.G_RET_STS_ERROR ;
2451: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2452: fnd_message.set_token('P_PARAMETER', l_parameters);
2453: fnd_msg_pub.add;
2454: FND_MSG_PUB.Count_And_Get
2455: (p_count => x_msg_count,
2456: p_data => x_msg_data

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

2456: p_data => x_msg_data
2457: );
2458: WHEN OTHERS THEN
2459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2460: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2461: fnd_message.set_token('ERROR_CODE',SQLCODE);
2462: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2463: fnd_msg_pub.add;
2464: FND_MSG_PUB.Count_And_Get

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

2457: );
2458: WHEN OTHERS THEN
2459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2460: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2461: fnd_message.set_token('ERROR_CODE',SQLCODE);
2462: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2463: fnd_msg_pub.add;
2464: FND_MSG_PUB.Count_And_Get
2465: (p_count => x_msg_count,

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

2458: WHEN OTHERS THEN
2459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2460: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2461: fnd_message.set_token('ERROR_CODE',SQLCODE);
2462: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2463: fnd_msg_pub.add;
2464: FND_MSG_PUB.Count_And_Get
2465: (p_count => x_msg_count,
2466: p_data => x_msg_data

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

2549: p_data => x_msg_data
2550: );
2551: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
2552: x_return_status := FND_API.G_RET_STS_ERROR ;
2553: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2554: fnd_message.set_token('P_PARAMETER', l_parameters);
2555: fnd_msg_pub.add;
2556: FND_MSG_PUB.Count_And_Get
2557: (p_count => x_msg_count,

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

2550: );
2551: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
2552: x_return_status := FND_API.G_RET_STS_ERROR ;
2553: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2554: fnd_message.set_token('P_PARAMETER', l_parameters);
2555: fnd_msg_pub.add;
2556: FND_MSG_PUB.Count_And_Get
2557: (p_count => x_msg_count,
2558: p_data => x_msg_data

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

2558: p_data => x_msg_data
2559: );
2560: WHEN OTHERS THEN
2561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2562: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2563: fnd_message.set_token('ERROR_CODE',SQLCODE);
2564: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2565: fnd_msg_pub.add;
2566: FND_MSG_PUB.Count_And_Get

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

2559: );
2560: WHEN OTHERS THEN
2561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2562: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2563: fnd_message.set_token('ERROR_CODE',SQLCODE);
2564: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2565: fnd_msg_pub.add;
2566: FND_MSG_PUB.Count_And_Get
2567: ( p_count => x_msg_count,

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

2560: WHEN OTHERS THEN
2561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2562: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2563: fnd_message.set_token('ERROR_CODE',SQLCODE);
2564: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2565: fnd_msg_pub.add;
2566: FND_MSG_PUB.Count_And_Get
2567: ( p_count => x_msg_count,
2568: p_data => x_msg_data