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_MSG_PUB

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 811: fnd_msg_pub.add;

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

Line 812: fnd_msg_pub.count_and_get ( p_count => x_msg_count

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

Line 817: fnd_msg_pub.count_and_get ( p_count => x_msg_count

813: , p_data => x_msg_data );
814:
815: when fnd_api.g_exc_unexpected_error then
816: x_return_status := fnd_api.g_ret_sts_unexp_error;
817: fnd_msg_pub.count_and_get ( p_count => x_msg_count
818: , p_data => x_msg_data );
819: when fnd_api.g_exc_error then
820: x_return_status := fnd_api.g_ret_sts_unexp_error;
821: fnd_msg_pub.count_and_get ( p_count => x_msg_count

Line 821: fnd_msg_pub.count_and_get ( p_count => x_msg_count

817: fnd_msg_pub.count_and_get ( p_count => x_msg_count
818: , p_data => x_msg_data );
819: when fnd_api.g_exc_error then
820: x_return_status := fnd_api.g_ret_sts_unexp_error;
821: fnd_msg_pub.count_and_get ( p_count => x_msg_count
822: , p_data => x_msg_data );
823:
824: when G_EXC_INVALID_SLOT_DURATION then
825: x_return_status := fnd_api.g_ret_sts_error ;

Line 827: fnd_msg_pub.add;

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

Line 828: fnd_msg_pub.count_and_get ( p_count => x_msg_count

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

Line 835: fnd_msg_pub.add;

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

Line 836: fnd_msg_pub.count_and_get ( p_count => x_msg_count

832: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
833: fnd_message.set_token('ERROR_CODE',sqlcode);
834: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
835: fnd_msg_pub.add;
836: fnd_msg_pub.count_and_get ( p_count => x_msg_count
837: , p_data => x_msg_data );
838: END get_available_time_slot;
839:
840: --*******************check valid resource ********************

Line 880: FND_MSG_PUB.initialize;

876: END IF;
877:
878: -- Initialize message list if p_init_msg_list is set to TRUE.
879: IF FND_API.to_Boolean( p_init_msg_list ) THEN
880: FND_MSG_PUB.initialize;
881: END IF;
882:
883: -- Call to check for required fields
884: IF not check_for_required_fields (p_resource_id =>p_resource_id,

Line 919: fnd_msg_pub.add;

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

Line 920: fnd_msg_pub.count_and_get ( p_count => x_msg_count

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

Line 925: fnd_msg_pub.count_and_get ( p_count => x_msg_count

921: , p_data => x_msg_data );
922:
923: when fnd_api.g_exc_unexpected_error then
924: x_return_status := fnd_api.g_ret_sts_unexp_error;
925: fnd_msg_pub.count_and_get ( p_count => x_msg_count
926: , p_data => x_msg_data );
927: when fnd_api.g_exc_error then
928: x_return_status := fnd_api.g_ret_sts_unexp_error;
929: fnd_msg_pub.count_and_get ( p_count => x_msg_count

Line 929: fnd_msg_pub.count_and_get ( p_count => x_msg_count

925: fnd_msg_pub.count_and_get ( p_count => x_msg_count
926: , p_data => x_msg_data );
927: when fnd_api.g_exc_error then
928: x_return_status := fnd_api.g_ret_sts_unexp_error;
929: fnd_msg_pub.count_and_get ( p_count => x_msg_count
930: , p_data => x_msg_data );
931:
932: when others then
933: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 937: fnd_msg_pub.add;

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

Line 938: fnd_msg_pub.count_and_get ( p_count => x_msg_count

934: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
935: fnd_message.set_token('ERROR_CODE',sqlcode);
936: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
937: fnd_msg_pub.add;
938: fnd_msg_pub.count_and_get ( p_count => x_msg_count
939: , p_data => x_msg_data );
940: END get_available_time;
941:
942: --

Line 987: FND_MSG_PUB.initialize;

983: END IF;
984:
985: -- Initialize message list if p_init_msg_list is set to TRUE.
986: IF FND_API.to_Boolean( p_init_msg_list ) THEN
987: FND_MSG_PUB.initialize;
988: END IF;
989:
990: -- Call to check for required fields
991: IF not check_for_required_fields (p_resource_id =>p_resource_id,

Line 1039: FND_MSG_PUB.Count_And_Get

1035:
1036: EXCEPTION
1037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1039: FND_MSG_PUB.Count_And_Get
1040: ( p_count => x_msg_count,
1041: p_data => x_msg_data
1042: );
1043: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN

Line 1047: fnd_msg_pub.add;

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

Line 1048: FND_MSG_PUB.Count_And_Get

1044: x_return_status := FND_API.G_RET_STS_ERROR ;
1045: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
1046: fnd_message.set_token('P_PARAMETER', l_parameters);
1047: fnd_msg_pub.add;
1048: FND_MSG_PUB.Count_And_Get
1049: (p_count => x_msg_count,
1050: p_data => x_msg_data
1051: );
1052: when fnd_api.g_exc_error then

Line 1054: fnd_msg_pub.count_and_get ( p_count => x_msg_count

1050: p_data => x_msg_data
1051: );
1052: when fnd_api.g_exc_error then
1053: x_return_status := fnd_api.g_ret_sts_unexp_error;
1054: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1055: , p_data => x_msg_data );
1056: WHEN OTHERS THEN
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1058: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');

Line 1061: fnd_msg_pub.add;

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

Line 1062: FND_MSG_PUB.Count_And_Get

1058: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
1059: fnd_message.set_token('ERROR_CODE',SQLCODE);
1060: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
1061: fnd_msg_pub.add;
1062: FND_MSG_PUB.Count_And_Get
1063: (p_count => x_msg_count,
1064: p_data => x_msg_data
1065: );
1066:

Line 1202: fnd_msg_pub.initialize;

1198:
1199: -- initialize message list if p_init_msg_list is set to true.
1200: if fnd_api.to_boolean ( p_init_msg_list )
1201: then
1202: fnd_msg_pub.initialize;
1203: end if;
1204:
1205: -- call to check for required fields
1206: if not check_for_required_fields

Line 1515: fnd_msg_pub.add;

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

Line 1516: FND_MSG_PUB.Count_And_Get

1512: -- end
1513: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
1514: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
1515: fnd_msg_pub.add;
1516: FND_MSG_PUB.Count_And_Get
1517: (p_count => x_msg_count,
1518: p_data => x_msg_data
1519: );
1520: end; --2

Line 1534: fnd_msg_pub.add;

1530: l_tbl.delete; -- to delete the record from TOR if no shift found
1531: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
1532: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
1533: fnd_message.set_token('P_RES_NAME', l_resource_name);
1534: fnd_msg_pub.add;
1535:
1536: FND_MSG_PUB.Count_And_Get
1537: (p_count => x_msg_count,
1538: p_data => x_msg_data

Line 1536: FND_MSG_PUB.Count_And_Get

1532: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
1533: fnd_message.set_token('P_RES_NAME', l_resource_name);
1534: fnd_msg_pub.add;
1535:
1536: FND_MSG_PUB.Count_And_Get
1537: (p_count => x_msg_count,
1538: p_data => x_msg_data
1539: );
1540: end; -- 1

Line 1552: fnd_msg_pub.add;

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

Line 1554: fnd_msg_pub.count_and_get( p_count => x_msg_count

1550: -- end
1551: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFT_CONSTR_FOUND');
1552: fnd_msg_pub.add;
1553:
1554: fnd_msg_pub.count_and_get( p_count => x_msg_count
1555: , p_data => x_msg_data );
1556: end if;
1557:
1558:

Line 1580: fnd_msg_pub.add;

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

Line 1581: fnd_msg_pub.count_and_get ( p_count => x_msg_count

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

Line 1586: fnd_msg_pub.count_and_get ( p_count => x_msg_count

1582: , p_data => x_msg_data );
1583:
1584: when fnd_api.g_exc_unexpected_error then
1585: x_return_status := fnd_api.g_ret_sts_unexp_error;
1586: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1587: , p_data => x_msg_data );
1588: when fnd_api.g_exc_error then
1589: x_return_status := fnd_api.g_ret_sts_unexp_error;
1590: fnd_msg_pub.count_and_get ( p_count => x_msg_count

Line 1590: fnd_msg_pub.count_and_get ( p_count => x_msg_count

1586: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1587: , p_data => x_msg_data );
1588: when fnd_api.g_exc_error then
1589: x_return_status := fnd_api.g_ret_sts_unexp_error;
1590: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1591: , p_data => x_msg_data );
1592:
1593: when others then
1594: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1598: fnd_msg_pub.count_and_get ( p_count => x_msg_count

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

Line 1784: fnd_msg_pub.initialize;

1780:
1781: -- initialize message list if p_init_msg_list is set to true.
1782: if fnd_api.to_boolean ( p_init_msg_list )
1783: then
1784: fnd_msg_pub.initialize;
1785: end if;
1786:
1787: -- call to check for required fields
1788: if not check_for_required_fields

Line 2238: fnd_msg_pub.add;

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

Line 2239: FND_MSG_PUB.Count_And_Get

2235: -- end
2236: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
2237: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
2238: fnd_msg_pub.add;
2239: FND_MSG_PUB.Count_And_Get
2240: (p_count => x_msg_count,
2241: p_data => x_msg_data
2242: );
2243: end; --2

Line 2256: fnd_msg_pub.add;

2252: l_tbl.delete; -- to delete the record from TOR if no shift found
2253: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
2254: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
2255: fnd_message.set_token('P_RES_NAME', l_resource_name);
2256: fnd_msg_pub.add;
2257:
2258: FND_MSG_PUB.Count_And_Get
2259: (p_count => x_msg_count,
2260: p_data => x_msg_data

Line 2258: FND_MSG_PUB.Count_And_Get

2254: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
2255: fnd_message.set_token('P_RES_NAME', l_resource_name);
2256: fnd_msg_pub.add;
2257:
2258: FND_MSG_PUB.Count_And_Get
2259: (p_count => x_msg_count,
2260: p_data => x_msg_data
2261: );
2262: end; -- 1

Line 2275: fnd_msg_pub.add;

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

Line 2277: fnd_msg_pub.count_and_get( p_count => x_msg_count

2273: -- end
2274: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFT_CONSTR_FOUND');
2275: fnd_msg_pub.add;
2276:
2277: fnd_msg_pub.count_and_get( p_count => x_msg_count
2278: , p_data => x_msg_data );
2279: end if;
2280:
2281:

Line 2304: fnd_msg_pub.add;

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

Line 2305: fnd_msg_pub.count_and_get ( p_count => x_msg_count

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

Line 2310: fnd_msg_pub.count_and_get ( p_count => x_msg_count

2306: , p_data => x_msg_data );
2307:
2308: when fnd_api.g_exc_unexpected_error then
2309: x_return_status := fnd_api.g_ret_sts_unexp_error;
2310: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2311: , p_data => x_msg_data );
2312: when fnd_api.g_exc_error then
2313: x_return_status := fnd_api.g_ret_sts_unexp_error;
2314: fnd_msg_pub.count_and_get ( p_count => x_msg_count

Line 2314: fnd_msg_pub.count_and_get ( p_count => x_msg_count

2310: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2311: , p_data => x_msg_data );
2312: when fnd_api.g_exc_error then
2313: x_return_status := fnd_api.g_ret_sts_unexp_error;
2314: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2315: , p_data => x_msg_data );
2316: when others then
2317: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2318: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');

Line 2321: fnd_msg_pub.count_and_get ( p_count => x_msg_count

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

Line 2364: FND_MSG_PUB.initialize;

2360: END IF;
2361:
2362: -- Initialize message list if p_init_msg_list is set to TRUE.
2363: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2364: FND_MSG_PUB.initialize;
2365: END IF;
2366:
2367: -- Call to check for required fields
2368: IF not check_for_required_fields (p_resource_id =>p_resource_id,

Line 2413: FND_MSG_PUB.Count_And_Get

2409:
2410: EXCEPTION
2411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2413: FND_MSG_PUB.Count_And_Get
2414: ( p_count => x_msg_count,
2415: p_data => x_msg_data
2416: );
2417: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN

Line 2421: fnd_msg_pub.add;

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

Line 2422: FND_MSG_PUB.Count_And_Get

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

Line 2431: fnd_msg_pub.add;

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

Line 2432: FND_MSG_PUB.Count_And_Get

2428: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2429: fnd_message.set_token('ERROR_CODE',SQLCODE);
2430: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2431: fnd_msg_pub.add;
2432: FND_MSG_PUB.Count_And_Get
2433: ( p_count => x_msg_count,
2434: p_data => x_msg_data
2435: );
2436:

Line 2625: FND_MSG_PUB.initialize;

2621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2622: END IF;
2623: -- Initialize message list if p_init_msg_list is set to TRUE.
2624: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2625: FND_MSG_PUB.initialize;
2626: END IF;
2627: -- Call to check for required fields
2628: IF not check_for_required_fields (p_resource_id =>p_resource_id,
2629: p_resource_type =>p_resource_type,

Line 2896: fnd_msg_pub.add;

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

Line 2897: FND_MSG_PUB.Count_And_Get

2893: x_return_status := FND_API.G_RET_STS_ERROR ;
2894: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
2895: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
2896: fnd_msg_pub.add;
2897: FND_MSG_PUB.Count_And_Get
2898: (p_count => x_msg_count,
2899: p_data => x_msg_data
2900: );
2901: end; --(2)

Line 2909: fnd_msg_pub.add;

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

Line 2910: FND_MSG_PUB.Count_And_Get

2906: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
2907: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
2908: fnd_message.set_token('P_RES_NAME', l_resource_name);
2909: fnd_msg_pub.add;
2910: FND_MSG_PUB.Count_And_Get
2911: (p_count => x_msg_count,
2912: p_data => x_msg_data
2913: );
2914: end; --(1)

Line 2932: FND_MSG_PUB.Count_And_Get

2928: end if;
2929: EXCEPTION
2930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2932: FND_MSG_PUB.Count_And_Get
2933: ( p_count => x_msg_count,
2934: p_data => x_msg_data
2935: );
2936: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN

Line 2940: fnd_msg_pub.add;

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

Line 2941: FND_MSG_PUB.Count_And_Get

2937: x_return_status := FND_API.G_RET_STS_ERROR ;
2938: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2939: fnd_message.set_token('P_PARAMETER', l_parameters);
2940: fnd_msg_pub.add;
2941: FND_MSG_PUB.Count_And_Get
2942: (p_count => x_msg_count,
2943: p_data => x_msg_data
2944: );
2945: when fnd_api.g_exc_error then

Line 2947: fnd_msg_pub.count_and_get ( p_count => x_msg_count

2943: p_data => x_msg_data
2944: );
2945: when fnd_api.g_exc_error then
2946: x_return_status := fnd_api.g_ret_sts_unexp_error;
2947: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2948: , p_data => x_msg_data );
2949: WHEN OTHERS THEN
2950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2951: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');

Line 2954: fnd_msg_pub.add;

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

Line 2955: FND_MSG_PUB.Count_And_Get

2951: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2952: fnd_message.set_token('ERROR_CODE',SQLCODE);
2953: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2954: fnd_msg_pub.add;
2955: FND_MSG_PUB.Count_And_Get
2956: (p_count => x_msg_count,
2957: p_data => x_msg_data
2958: );
2959:

Line 3038: FND_MSG_PUB.initialize;

3034: END IF;
3035:
3036: -- Initialize message list if p_init_msg_list is set to TRUE.
3037: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3038: FND_MSG_PUB.initialize;
3039: END IF;
3040:
3041: -- Initialize API return status to success
3042: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3059: FND_MSG_PUB.Count_And_Get

3055:
3056: EXCEPTION
3057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3059: FND_MSG_PUB.Count_And_Get
3060: ( p_count => x_msg_count,
3061: p_data => x_msg_data
3062: );
3063: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN

Line 3067: fnd_msg_pub.add;

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

Line 3068: FND_MSG_PUB.Count_And_Get

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

Line 3077: fnd_msg_pub.add;

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

Line 3078: FND_MSG_PUB.Count_And_Get

3074: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
3075: fnd_message.set_token('ERROR_CODE',SQLCODE);
3076: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
3077: fnd_msg_pub.add;
3078: FND_MSG_PUB.Count_And_Get
3079: ( p_count => x_msg_count,
3080: p_data => x_msg_data
3081: );
3082: