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

687: --
688: -- Update return status to Success if there is atleast one available time slot
689: if x_shift.count = 0 then
690: x_return_status := fnd_api.g_ret_sts_error ;
691: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFT_CONSTR_FOUND');
692: --fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS_FOR_RESOURCE');
693: --fnd_message.set_token('P_RESOURCE_NAME', l_resource_name);
694: fnd_msg_pub.add;
695: fnd_msg_pub.count_and_get( p_count => x_msg_count

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

688: -- Update return status to Success if there is atleast one available time slot
689: if x_shift.count = 0 then
690: x_return_status := fnd_api.g_ret_sts_error ;
691: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFT_CONSTR_FOUND');
692: --fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS_FOR_RESOURCE');
693: --fnd_message.set_token('P_RESOURCE_NAME', l_resource_name);
694: fnd_msg_pub.add;
695: fnd_msg_pub.count_and_get( p_count => x_msg_count
696: , p_data => x_msg_data );

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

689: if x_shift.count = 0 then
690: x_return_status := fnd_api.g_ret_sts_error ;
691: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFT_CONSTR_FOUND');
692: --fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS_FOR_RESOURCE');
693: --fnd_message.set_token('P_RESOURCE_NAME', l_resource_name);
694: fnd_msg_pub.add;
695: fnd_msg_pub.count_and_get( p_count => x_msg_count
696: , p_data => x_msg_data );
697: end if;

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

705:
706: EXCEPTION
707: when g_exc_required_fields_null then
708: x_return_status := fnd_api.g_ret_sts_error ;
709: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
710: fnd_message.set_token('P_PARAMETER', l_parameters);
711: fnd_msg_pub.add;
712: fnd_msg_pub.count_and_get ( p_count => x_msg_count
713: , p_data => x_msg_data );

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

706: EXCEPTION
707: when g_exc_required_fields_null then
708: x_return_status := fnd_api.g_ret_sts_error ;
709: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
710: fnd_message.set_token('P_PARAMETER', l_parameters);
711: fnd_msg_pub.add;
712: fnd_msg_pub.count_and_get ( p_count => x_msg_count
713: , p_data => x_msg_data );
714:

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

718: , p_data => x_msg_data );
719:
720: when others then
721: x_return_status := fnd_api.g_ret_sts_unexp_error ;
722: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
723: fnd_message.set_token('ERROR_CODE',sqlcode);
724: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
725: fnd_msg_pub.count_and_get ( p_count => x_msg_count
726: , p_data => x_msg_data );

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

719:
720: when others then
721: x_return_status := fnd_api.g_ret_sts_unexp_error ;
722: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
723: fnd_message.set_token('ERROR_CODE',sqlcode);
724: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
725: fnd_msg_pub.count_and_get ( p_count => x_msg_count
726: , p_data => x_msg_data );
727: END get_available_time;

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

720: when others then
721: x_return_status := fnd_api.g_ret_sts_unexp_error ;
722: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
723: fnd_message.set_token('ERROR_CODE',sqlcode);
724: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
725: fnd_msg_pub.count_and_get ( p_count => x_msg_count
726: , p_data => x_msg_data );
727: END get_available_time;
728:

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

812: p_data => x_msg_data
813: );
814: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
815: x_return_status := FND_API.G_RET_STS_ERROR ;
816: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
817: fnd_message.set_token('P_PARAMETER', l_parameters);
818: fnd_msg_pub.add;
819: FND_MSG_PUB.Count_And_Get
820: (p_count => x_msg_count,

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

813: );
814: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
815: x_return_status := FND_API.G_RET_STS_ERROR ;
816: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
817: fnd_message.set_token('P_PARAMETER', l_parameters);
818: fnd_msg_pub.add;
819: FND_MSG_PUB.Count_And_Get
820: (p_count => x_msg_count,
821: p_data => x_msg_data

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

821: p_data => x_msg_data
822: );
823: WHEN OTHERS THEN
824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
825: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
826: fnd_message.set_token('ERROR_CODE',SQLCODE);
827: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
828: fnd_msg_pub.add;
829: FND_MSG_PUB.Count_And_Get

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

822: );
823: WHEN OTHERS THEN
824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
825: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
826: fnd_message.set_token('ERROR_CODE',SQLCODE);
827: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
828: fnd_msg_pub.add;
829: FND_MSG_PUB.Count_And_Get
830: (p_count => x_msg_count,

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

823: WHEN OTHERS THEN
824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
825: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
826: fnd_message.set_token('ERROR_CODE',SQLCODE);
827: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
828: fnd_msg_pub.add;
829: FND_MSG_PUB.Count_And_Get
830: (p_count => x_msg_count,
831: p_data => x_msg_data

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

1216: x_return_status := FND_API.G_RET_STS_ERROR ;
1217: -- Added for bug 3270116
1218: l_return_status := FND_API.G_RET_STS_ERROR ;
1219: -- end
1220: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
1221: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
1222: fnd_msg_pub.add;
1223: FND_MSG_PUB.Count_And_Get
1224: (p_count => x_msg_count,

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

1217: -- Added for bug 3270116
1218: l_return_status := FND_API.G_RET_STS_ERROR ;
1219: -- end
1220: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
1221: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
1222: fnd_msg_pub.add;
1223: FND_MSG_PUB.Count_And_Get
1224: (p_count => x_msg_count,
1225: p_data => x_msg_data

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

1233: -- as for this exception we want to handle it.
1234: -- For a resource, even if a single shift is returned for a search window
1235: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
1236: l_tbl.delete; -- to delete the record from TOR if no shift found
1237: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
1238: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
1239: fnd_message.set_token('P_RES_NAME', l_resource_name);
1240: fnd_msg_pub.add;
1241:

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

1234: -- For a resource, even if a single shift is returned for a search window
1235: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
1236: l_tbl.delete; -- to delete the record from TOR if no shift found
1237: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
1238: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
1239: fnd_message.set_token('P_RES_NAME', l_resource_name);
1240: fnd_msg_pub.add;
1241:
1242: FND_MSG_PUB.Count_And_Get

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

1235: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
1236: l_tbl.delete; -- to delete the record from TOR if no shift found
1237: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
1238: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
1239: fnd_message.set_token('P_RES_NAME', l_resource_name);
1240: fnd_msg_pub.add;
1241:
1242: FND_MSG_PUB.Count_And_Get
1243: (p_count => x_msg_count,

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

1254: x_return_status := fnd_api.g_ret_sts_error ;
1255: -- Added for bug 3270116
1256: l_return_status := FND_API.G_RET_STS_ERROR ;
1257: -- end
1258: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFT_CONSTR_FOUND');
1259: fnd_msg_pub.add;
1260:
1261: fnd_msg_pub.count_and_get( p_count => x_msg_count
1262: , p_data => x_msg_data );

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

1280: -- end
1281: EXCEPTION
1282: when g_exc_required_fields_null then
1283: x_return_status := fnd_api.g_ret_sts_error ;
1284: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
1285: fnd_message.set_token('P_PARAMETER', l_parameters);
1286: fnd_msg_pub.add;
1287: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1288: , p_data => x_msg_data );

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

1281: EXCEPTION
1282: when g_exc_required_fields_null then
1283: x_return_status := fnd_api.g_ret_sts_error ;
1284: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
1285: fnd_message.set_token('P_PARAMETER', l_parameters);
1286: fnd_msg_pub.add;
1287: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1288: , p_data => x_msg_data );
1289:

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

1292: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1293: , p_data => x_msg_data );
1294: when others then
1295: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1296: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
1297: fnd_message.set_token('ERROR_CODE',sqlcode);
1298: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
1299: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1300: , p_data => x_msg_data );

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

1293: , p_data => x_msg_data );
1294: when others then
1295: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1296: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
1297: fnd_message.set_token('ERROR_CODE',sqlcode);
1298: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
1299: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1300: , p_data => x_msg_data );
1301: --END;

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

1294: when others then
1295: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1296: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
1297: fnd_message.set_token('ERROR_CODE',sqlcode);
1298: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
1299: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1300: , p_data => x_msg_data );
1301: --END;
1302: END get_resource_shifts;

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

1873: x_return_status := FND_API.G_RET_STS_ERROR ;
1874: -- Added for bug 3270116
1875: l_return_status := FND_API.G_RET_STS_ERROR ;
1876: -- end
1877: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
1878: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
1879: fnd_msg_pub.add;
1880: FND_MSG_PUB.Count_And_Get
1881: (p_count => x_msg_count,

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

1874: -- Added for bug 3270116
1875: l_return_status := FND_API.G_RET_STS_ERROR ;
1876: -- end
1877: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
1878: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
1879: fnd_msg_pub.add;
1880: FND_MSG_PUB.Count_And_Get
1881: (p_count => x_msg_count,
1882: p_data => x_msg_data

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

1890: -- as for this exception we want to handle it.
1891: -- For a resource, even if a single shift is returned for a search window
1892: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
1893: l_tbl.delete; -- to delete the record from TOR if no shift found
1894: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
1895: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
1896: fnd_message.set_token('P_RES_NAME', l_resource_name);
1897: fnd_msg_pub.add;
1898:

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

1891: -- For a resource, even if a single shift is returned for a search window
1892: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
1893: l_tbl.delete; -- to delete the record from TOR if no shift found
1894: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
1895: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
1896: fnd_message.set_token('P_RES_NAME', l_resource_name);
1897: fnd_msg_pub.add;
1898:
1899: FND_MSG_PUB.Count_And_Get

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

1892: -- it will return 'S'. This is as per requirement from Field service and Gantt guys.
1893: l_tbl.delete; -- to delete the record from TOR if no shift found
1894: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
1895: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
1896: fnd_message.set_token('P_RES_NAME', l_resource_name);
1897: fnd_msg_pub.add;
1898:
1899: FND_MSG_PUB.Count_And_Get
1900: (p_count => x_msg_count,

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

1911: x_return_status := fnd_api.g_ret_sts_error ;
1912: -- Added for bug 3270116
1913: l_return_status := FND_API.G_RET_STS_ERROR ;
1914: -- end
1915: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFT_CONSTR_FOUND');
1916: fnd_msg_pub.add;
1917:
1918: fnd_msg_pub.count_and_get( p_count => x_msg_count
1919: , p_data => x_msg_data );

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

1938:
1939: EXCEPTION
1940: when g_exc_required_fields_null then
1941: x_return_status := fnd_api.g_ret_sts_error ;
1942: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
1943: fnd_message.set_token('P_PARAMETER', l_parameters);
1944: fnd_msg_pub.add;
1945: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1946: , p_data => x_msg_data );

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

1939: EXCEPTION
1940: when g_exc_required_fields_null then
1941: x_return_status := fnd_api.g_ret_sts_error ;
1942: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
1943: fnd_message.set_token('P_PARAMETER', l_parameters);
1944: fnd_msg_pub.add;
1945: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1946: , p_data => x_msg_data );
1947:

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

1950: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1951: , p_data => x_msg_data );
1952: when others then
1953: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1954: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
1955: fnd_message.set_token('ERROR_CODE',sqlcode);
1956: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
1957: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1958: , p_data => x_msg_data );

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

1951: , p_data => x_msg_data );
1952: when others then
1953: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1954: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
1955: fnd_message.set_token('ERROR_CODE',sqlcode);
1956: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
1957: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1958: , p_data => x_msg_data );
1959: --END;

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

1952: when others then
1953: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1954: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
1955: fnd_message.set_token('ERROR_CODE',sqlcode);
1956: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
1957: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1958: , p_data => x_msg_data );
1959: --END;
1960: END get_resource_shifts;

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

2352: END LOOP;
2353: exception
2354: when no_data_found then
2355: x_return_status := FND_API.G_RET_STS_ERROR ;
2356: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
2357: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
2358: fnd_msg_pub.add;
2359: FND_MSG_PUB.Count_And_Get
2360: (p_count => x_msg_count,

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

2353: exception
2354: when no_data_found then
2355: x_return_status := FND_API.G_RET_STS_ERROR ;
2356: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
2357: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
2358: fnd_msg_pub.add;
2359: FND_MSG_PUB.Count_And_Get
2360: (p_count => x_msg_count,
2361: p_data => x_msg_data

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

2364: end if; --(1)
2365: exception
2366: when no_data_found then
2367: x_return_status := FND_API.G_RET_STS_ERROR ;
2368: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
2369: fnd_message.set_token('P_RES_NAME', l_resource_name);
2370: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
2371: fnd_msg_pub.add;
2372: FND_MSG_PUB.Count_And_Get

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

2365: exception
2366: when no_data_found then
2367: x_return_status := FND_API.G_RET_STS_ERROR ;
2368: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
2369: fnd_message.set_token('P_RES_NAME', l_resource_name);
2370: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
2371: fnd_msg_pub.add;
2372: FND_MSG_PUB.Count_And_Get
2373: (p_count => x_msg_count,

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

2366: when no_data_found then
2367: x_return_status := FND_API.G_RET_STS_ERROR ;
2368: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
2369: fnd_message.set_token('P_RES_NAME', l_resource_name);
2370: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
2371: fnd_msg_pub.add;
2372: FND_MSG_PUB.Count_And_Get
2373: (p_count => x_msg_count,
2374: p_data => x_msg_data

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

2397: p_data => x_msg_data
2398: );
2399: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
2400: x_return_status := FND_API.G_RET_STS_ERROR ;
2401: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2402: fnd_message.set_token('P_PARAMETER', l_parameters);
2403: fnd_msg_pub.add;
2404: FND_MSG_PUB.Count_And_Get
2405: (p_count => x_msg_count,

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

2398: );
2399: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
2400: x_return_status := FND_API.G_RET_STS_ERROR ;
2401: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2402: fnd_message.set_token('P_PARAMETER', l_parameters);
2403: fnd_msg_pub.add;
2404: FND_MSG_PUB.Count_And_Get
2405: (p_count => x_msg_count,
2406: p_data => x_msg_data

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

2406: p_data => x_msg_data
2407: );
2408: WHEN OTHERS THEN
2409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2410: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2411: fnd_message.set_token('ERROR_CODE',SQLCODE);
2412: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2413: fnd_msg_pub.add;
2414: FND_MSG_PUB.Count_And_Get

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

2407: );
2408: WHEN OTHERS THEN
2409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2410: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2411: fnd_message.set_token('ERROR_CODE',SQLCODE);
2412: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2413: fnd_msg_pub.add;
2414: FND_MSG_PUB.Count_And_Get
2415: (p_count => x_msg_count,

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

2408: WHEN OTHERS THEN
2409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2410: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2411: fnd_message.set_token('ERROR_CODE',SQLCODE);
2412: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2413: fnd_msg_pub.add;
2414: FND_MSG_PUB.Count_And_Get
2415: (p_count => x_msg_count,
2416: p_data => x_msg_data

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

2499: p_data => x_msg_data
2500: );
2501: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
2502: x_return_status := FND_API.G_RET_STS_ERROR ;
2503: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2504: fnd_message.set_token('P_PARAMETER', l_parameters);
2505: fnd_msg_pub.add;
2506: FND_MSG_PUB.Count_And_Get
2507: (p_count => x_msg_count,

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

2500: );
2501: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN
2502: x_return_status := FND_API.G_RET_STS_ERROR ;
2503: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2504: fnd_message.set_token('P_PARAMETER', l_parameters);
2505: fnd_msg_pub.add;
2506: FND_MSG_PUB.Count_And_Get
2507: (p_count => x_msg_count,
2508: p_data => x_msg_data

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

2508: p_data => x_msg_data
2509: );
2510: WHEN OTHERS THEN
2511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2512: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2513: fnd_message.set_token('ERROR_CODE',SQLCODE);
2514: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2515: fnd_msg_pub.add;
2516: FND_MSG_PUB.Count_And_Get

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

2509: );
2510: WHEN OTHERS THEN
2511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2512: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2513: fnd_message.set_token('ERROR_CODE',SQLCODE);
2514: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2515: fnd_msg_pub.add;
2516: FND_MSG_PUB.Count_And_Get
2517: ( p_count => x_msg_count,

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

2510: WHEN OTHERS THEN
2511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2512: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2513: fnd_message.set_token('ERROR_CODE',SQLCODE);
2514: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2515: fnd_msg_pub.add;
2516: FND_MSG_PUB.Count_And_Get
2517: ( p_count => x_msg_count,
2518: p_data => x_msg_data