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.

[Home] [Help]

APPS.JTF_CALENDAR_PUB dependencies on FND_MSG_PUB

Line 210: FND_MSG_PUB.initialize;

206: END IF;
207:
208: -- Initialize message list if p_init_msg_list is set to TRUE.
209: IF FND_API.to_Boolean( p_init_msg_list ) THEN
210: FND_MSG_PUB.initialize;
211: END IF;
212:
213: -- Call to check for required fields
214: IF not check_for_required_fields (p_resource_id =>p_resource_id,

Line 256: FND_MSG_PUB.Count_And_Get

252:
253: EXCEPTION
254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
256: FND_MSG_PUB.Count_And_Get
257: ( p_count => x_msg_count,
258: p_data => x_msg_data
259: );
260: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN

Line 264: fnd_msg_pub.add;

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
268: );

Line 265: FND_MSG_PUB.Count_And_Get

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
268: );
269: WHEN OTHERS THEN

Line 274: fnd_msg_pub.add;

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
278: );

Line 275: FND_MSG_PUB.Count_And_Get

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
278: );
279:

Line 446: FND_MSG_PUB.initialize;

442: END IF;
443:
444: -- Initialize message list if p_init_msg_list is set to TRUE.
445: IF FND_API.to_Boolean( p_init_msg_list ) THEN
446: FND_MSG_PUB.initialize;
447: END IF;
448:
449: -- Call to check for required fields
450: IF not check_for_required_fields (p_resource_id =>p_resource_id,

Line 694: fnd_msg_pub.add;

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

Line 695: fnd_msg_pub.count_and_get( p_count => x_msg_count

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;
698:
699: -- Added sort by jawang on 06/27/2002

Line 711: fnd_msg_pub.add;

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:
715: when fnd_api.g_exc_unexpected_error then

Line 712: fnd_msg_pub.count_and_get ( p_count => x_msg_count

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:
715: when fnd_api.g_exc_unexpected_error then
716: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 717: fnd_msg_pub.count_and_get ( p_count => x_msg_count

713: , p_data => x_msg_data );
714:
715: when fnd_api.g_exc_unexpected_error then
716: x_return_status := fnd_api.g_ret_sts_unexp_error;
717: fnd_msg_pub.count_and_get ( p_count => x_msg_count
718: , p_data => x_msg_data );
719:
720: when others then
721: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 725: fnd_msg_pub.count_and_get ( p_count => x_msg_count

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

Line 774: FND_MSG_PUB.initialize;

770: END IF;
771:
772: -- Initialize message list if p_init_msg_list is set to TRUE.
773: IF FND_API.to_Boolean( p_init_msg_list ) THEN
774: FND_MSG_PUB.initialize;
775: END IF;
776:
777: -- Call to check for required fields
778: IF not check_for_required_fields (p_resource_id =>p_resource_id,

Line 810: FND_MSG_PUB.Count_And_Get

806:
807: EXCEPTION
808: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
810: FND_MSG_PUB.Count_And_Get
811: ( p_count => x_msg_count,
812: p_data => x_msg_data
813: );
814: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN

Line 818: fnd_msg_pub.add;

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
822: );

Line 819: FND_MSG_PUB.Count_And_Get

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
822: );
823: WHEN OTHERS THEN

Line 828: fnd_msg_pub.add;

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
832: );

Line 829: FND_MSG_PUB.Count_And_Get

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
832: );
833:

Line 949: fnd_msg_pub.initialize;

945:
946: -- initialize message list if p_init_msg_list is set to true.
947: if fnd_api.to_boolean ( p_init_msg_list )
948: then
949: fnd_msg_pub.initialize;
950: end if;
951:
952: -- call to check for required fields
953: if not JTF_CALENDAR_PUB.check_for_required_fields

Line 1222: fnd_msg_pub.add;

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
1226: );

Line 1223: FND_MSG_PUB.Count_And_Get

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
1226: );
1227: end; --2

Line 1240: fnd_msg_pub.add;

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,
1244: p_data => x_msg_data

Line 1242: FND_MSG_PUB.Count_And_Get

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,
1244: p_data => x_msg_data
1245: );
1246: end; -- 1

Line 1259: fnd_msg_pub.add;

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 );
1263: end if;

Line 1261: fnd_msg_pub.count_and_get( p_count => x_msg_count

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 );
1263: end if;
1264:
1265: -- Added sort by jawang on 06/27/2002

Line 1286: fnd_msg_pub.add;

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:
1290: when fnd_api.g_exc_unexpected_error then

Line 1287: fnd_msg_pub.count_and_get ( p_count => x_msg_count

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:
1290: when fnd_api.g_exc_unexpected_error then
1291: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1292: fnd_msg_pub.count_and_get ( p_count => x_msg_count

1288: , p_data => x_msg_data );
1289:
1290: when fnd_api.g_exc_unexpected_error then
1291: x_return_status := fnd_api.g_ret_sts_unexp_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');

Line 1299: fnd_msg_pub.count_and_get ( p_count => x_msg_count

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

Line 1460: fnd_msg_pub.initialize;

1456:
1457: -- initialize message list if p_init_msg_list is set to true.
1458: if fnd_api.to_boolean ( p_init_msg_list )
1459: then
1460: fnd_msg_pub.initialize;
1461: end if;
1462:
1463: -- call to check for required fields
1464: if not JTF_CALENDAR_PUB.check_for_required_fields

Line 1879: fnd_msg_pub.add;

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
1883: );

Line 1880: FND_MSG_PUB.Count_And_Get

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
1883: );
1884: end; --2

Line 1897: fnd_msg_pub.add;

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,
1901: p_data => x_msg_data

Line 1899: FND_MSG_PUB.Count_And_Get

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,
1901: p_data => x_msg_data
1902: );
1903: end; -- 1

Line 1916: fnd_msg_pub.add;

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 );
1920: end if;

Line 1918: fnd_msg_pub.count_and_get( p_count => x_msg_count

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 );
1920: end if;
1921:
1922: -- Added sort by jawang on 06/27/2002

Line 1944: fnd_msg_pub.add;

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:
1948: when fnd_api.g_exc_unexpected_error then

Line 1945: fnd_msg_pub.count_and_get ( p_count => x_msg_count

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:
1948: when fnd_api.g_exc_unexpected_error then
1949: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1950: fnd_msg_pub.count_and_get ( p_count => x_msg_count

1946: , p_data => x_msg_data );
1947:
1948: when fnd_api.g_exc_unexpected_error then
1949: x_return_status := fnd_api.g_ret_sts_unexp_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');

Line 1957: fnd_msg_pub.count_and_get ( p_count => x_msg_count

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

Line 2127: FND_MSG_PUB.initialize;

2123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2124: END IF;
2125: -- Initialize message list if p_init_msg_list is set to TRUE.
2126: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2127: FND_MSG_PUB.initialize;
2128: END IF;
2129: -- Call to check for required fields
2130: IF not check_for_required_fields (p_resource_id =>p_resource_id,
2131: p_resource_type =>p_resource_type,

Line 2358: fnd_msg_pub.add;

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
2362: );

Line 2359: FND_MSG_PUB.Count_And_Get

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
2362: );
2363: end; --(2)

Line 2371: fnd_msg_pub.add;

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
2375: );

Line 2372: FND_MSG_PUB.Count_And_Get

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
2375: );
2376: end; --(1)

Line 2395: FND_MSG_PUB.Count_And_Get

2391:
2392: EXCEPTION
2393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2395: FND_MSG_PUB.Count_And_Get
2396: ( p_count => x_msg_count,
2397: p_data => x_msg_data
2398: );
2399: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN

Line 2403: fnd_msg_pub.add;

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
2407: );

Line 2404: FND_MSG_PUB.Count_And_Get

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
2407: );
2408: WHEN OTHERS THEN

Line 2413: fnd_msg_pub.add;

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
2417: );

Line 2414: FND_MSG_PUB.Count_And_Get

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
2417: );
2418:

Line 2476: FND_MSG_PUB.initialize;

2472: END IF;
2473:
2474: -- Initialize message list if p_init_msg_list is set to TRUE.
2475: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2476: FND_MSG_PUB.initialize;
2477: END IF;
2478:
2479: -- Initialize API return status to success
2480: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2497: FND_MSG_PUB.Count_And_Get

2493:
2494: EXCEPTION
2495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2497: FND_MSG_PUB.Count_And_Get
2498: ( p_count => x_msg_count,
2499: p_data => x_msg_data
2500: );
2501: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN

Line 2505: fnd_msg_pub.add;

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
2509: );

Line 2506: FND_MSG_PUB.Count_And_Get

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
2509: );
2510: WHEN OTHERS THEN

Line 2515: fnd_msg_pub.add;

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
2519: );

Line 2516: FND_MSG_PUB.Count_And_Get

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
2519: );
2520: