APPS.JTF_CALENDAR_PUB_24HR dependencies on FND_MSG_PUB

Line 388: FND_MSG_PUB.initialize;

384: END IF;
385:
386: -- Initialize message list if p_init_msg_list is set to TRUE.
387: IF FND_API.to_Boolean( p_init_msg_list ) THEN
388: FND_MSG_PUB.initialize;
389: END IF;
390:
391: -- Call to check for required fields
392: IF not check_for_required_fields (p_resource_id =>p_resource_id,

Line 744: fnd_msg_pub.add;

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

Line 745: fnd_msg_pub.count_and_get ( p_count => x_msg_count

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

Line 750: fnd_msg_pub.count_and_get ( p_count => x_msg_count

746: , p_data => x_msg_data );
747:
748: when fnd_api.g_exc_unexpected_error then
749: x_return_status := fnd_api.g_ret_sts_unexp_error;
750: fnd_msg_pub.count_and_get ( p_count => x_msg_count
751: , p_data => x_msg_data );
752: when fnd_api.g_exc_error then
753: x_return_status := fnd_api.g_ret_sts_unexp_error;
754: fnd_msg_pub.count_and_get ( p_count => x_msg_count

Line 754: fnd_msg_pub.count_and_get ( p_count => x_msg_count

750: fnd_msg_pub.count_and_get ( p_count => x_msg_count
751: , p_data => x_msg_data );
752: when fnd_api.g_exc_error then
753: x_return_status := fnd_api.g_ret_sts_unexp_error;
754: fnd_msg_pub.count_and_get ( p_count => x_msg_count
755: , p_data => x_msg_data );
756:
757: when G_EXC_INVALID_SLOT_DURATION then
758: x_return_status := fnd_api.g_ret_sts_error ;

Line 760: fnd_msg_pub.add;

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

Line 761: fnd_msg_pub.count_and_get ( p_count => x_msg_count

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

Line 768: fnd_msg_pub.add;

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

Line 769: fnd_msg_pub.count_and_get ( p_count => x_msg_count

765: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
766: fnd_message.set_token('ERROR_CODE',sqlcode);
767: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
768: fnd_msg_pub.add;
769: fnd_msg_pub.count_and_get ( p_count => x_msg_count
770: , p_data => x_msg_data );
771: END get_available_time_slot;
772:
773: --*******************check valid resource ********************

Line 813: FND_MSG_PUB.initialize;

809: END IF;
810:
811: -- Initialize message list if p_init_msg_list is set to TRUE.
812: IF FND_API.to_Boolean( p_init_msg_list ) THEN
813: FND_MSG_PUB.initialize;
814: END IF;
815:
816: -- Call to check for required fields
817: IF not check_for_required_fields (p_resource_id =>p_resource_id,

Line 852: fnd_msg_pub.add;

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

Line 853: fnd_msg_pub.count_and_get ( p_count => x_msg_count

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

Line 858: fnd_msg_pub.count_and_get ( p_count => x_msg_count

854: , p_data => x_msg_data );
855:
856: when fnd_api.g_exc_unexpected_error then
857: x_return_status := fnd_api.g_ret_sts_unexp_error;
858: fnd_msg_pub.count_and_get ( p_count => x_msg_count
859: , p_data => x_msg_data );
860: when fnd_api.g_exc_error then
861: x_return_status := fnd_api.g_ret_sts_unexp_error;
862: fnd_msg_pub.count_and_get ( p_count => x_msg_count

Line 862: fnd_msg_pub.count_and_get ( p_count => x_msg_count

858: fnd_msg_pub.count_and_get ( p_count => x_msg_count
859: , p_data => x_msg_data );
860: when fnd_api.g_exc_error then
861: x_return_status := fnd_api.g_ret_sts_unexp_error;
862: fnd_msg_pub.count_and_get ( p_count => x_msg_count
863: , p_data => x_msg_data );
864:
865: when others then
866: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 870: fnd_msg_pub.add;

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

Line 871: fnd_msg_pub.count_and_get ( p_count => x_msg_count

867: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
868: fnd_message.set_token('ERROR_CODE',sqlcode);
869: fnd_message.set_token('ERROR_MESSAGE',sqlerrm);
870: fnd_msg_pub.add;
871: fnd_msg_pub.count_and_get ( p_count => x_msg_count
872: , p_data => x_msg_data );
873: END get_available_time;
874:
875: --

Line 920: FND_MSG_PUB.initialize;

916: END IF;
917:
918: -- Initialize message list if p_init_msg_list is set to TRUE.
919: IF FND_API.to_Boolean( p_init_msg_list ) THEN
920: FND_MSG_PUB.initialize;
921: END IF;
922:
923: -- Call to check for required fields
924: IF not check_for_required_fields (p_resource_id =>p_resource_id,

Line 972: FND_MSG_PUB.Count_And_Get

968:
969: EXCEPTION
970: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
972: FND_MSG_PUB.Count_And_Get
973: ( p_count => x_msg_count,
974: p_data => x_msg_data
975: );
976: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN

Line 980: fnd_msg_pub.add;

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

Line 981: FND_MSG_PUB.Count_And_Get

977: x_return_status := FND_API.G_RET_STS_ERROR ;
978: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
979: fnd_message.set_token('P_PARAMETER', l_parameters);
980: fnd_msg_pub.add;
981: FND_MSG_PUB.Count_And_Get
982: (p_count => x_msg_count,
983: p_data => x_msg_data
984: );
985: when fnd_api.g_exc_error then

Line 987: fnd_msg_pub.count_and_get ( p_count => x_msg_count

983: p_data => x_msg_data
984: );
985: when fnd_api.g_exc_error then
986: x_return_status := fnd_api.g_ret_sts_unexp_error;
987: fnd_msg_pub.count_and_get ( p_count => x_msg_count
988: , p_data => x_msg_data );
989: WHEN OTHERS THEN
990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
991: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');

Line 994: fnd_msg_pub.add;

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

Line 995: FND_MSG_PUB.Count_And_Get

991: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
992: fnd_message.set_token('ERROR_CODE',SQLCODE);
993: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
994: fnd_msg_pub.add;
995: FND_MSG_PUB.Count_And_Get
996: (p_count => x_msg_count,
997: p_data => x_msg_data
998: );
999:

Line 1135: fnd_msg_pub.initialize;

1131:
1132: -- initialize message list if p_init_msg_list is set to true.
1133: if fnd_api.to_boolean ( p_init_msg_list )
1134: then
1135: fnd_msg_pub.initialize;
1136: end if;
1137:
1138: -- call to check for required fields
1139: if not check_for_required_fields

Line 1448: fnd_msg_pub.add;

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

Line 1449: FND_MSG_PUB.Count_And_Get

1445: -- end
1446: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
1447: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
1448: fnd_msg_pub.add;
1449: FND_MSG_PUB.Count_And_Get
1450: (p_count => x_msg_count,
1451: p_data => x_msg_data
1452: );
1453: end; --2

Line 1467: fnd_msg_pub.add;

1463: l_tbl.delete; -- to delete the record from TOR if no shift found
1464: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
1465: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
1466: fnd_message.set_token('P_RES_NAME', l_resource_name);
1467: fnd_msg_pub.add;
1468:
1469: FND_MSG_PUB.Count_And_Get
1470: (p_count => x_msg_count,
1471: p_data => x_msg_data

Line 1469: FND_MSG_PUB.Count_And_Get

1465: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
1466: fnd_message.set_token('P_RES_NAME', l_resource_name);
1467: fnd_msg_pub.add;
1468:
1469: FND_MSG_PUB.Count_And_Get
1470: (p_count => x_msg_count,
1471: p_data => x_msg_data
1472: );
1473: end; -- 1

Line 1485: fnd_msg_pub.add;

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

Line 1487: fnd_msg_pub.count_and_get( p_count => x_msg_count

1483: -- end
1484: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFT_CONSTR_FOUND');
1485: fnd_msg_pub.add;
1486:
1487: fnd_msg_pub.count_and_get( p_count => x_msg_count
1488: , p_data => x_msg_data );
1489: end if;
1490:
1491:

Line 1513: fnd_msg_pub.add;

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

Line 1514: fnd_msg_pub.count_and_get ( p_count => x_msg_count

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

Line 1519: fnd_msg_pub.count_and_get ( p_count => x_msg_count

1515: , p_data => x_msg_data );
1516:
1517: when fnd_api.g_exc_unexpected_error then
1518: x_return_status := fnd_api.g_ret_sts_unexp_error;
1519: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1520: , p_data => x_msg_data );
1521: when fnd_api.g_exc_error then
1522: x_return_status := fnd_api.g_ret_sts_unexp_error;
1523: fnd_msg_pub.count_and_get ( p_count => x_msg_count

Line 1523: fnd_msg_pub.count_and_get ( p_count => x_msg_count

1519: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1520: , p_data => x_msg_data );
1521: when fnd_api.g_exc_error then
1522: x_return_status := fnd_api.g_ret_sts_unexp_error;
1523: fnd_msg_pub.count_and_get ( p_count => x_msg_count
1524: , p_data => x_msg_data );
1525:
1526: when others then
1527: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1531: fnd_msg_pub.count_and_get ( p_count => x_msg_count

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

Line 1717: fnd_msg_pub.initialize;

1713:
1714: -- initialize message list if p_init_msg_list is set to true.
1715: if fnd_api.to_boolean ( p_init_msg_list )
1716: then
1717: fnd_msg_pub.initialize;
1718: end if;
1719:
1720: -- call to check for required fields
1721: if not check_for_required_fields

Line 2168: fnd_msg_pub.add;

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

Line 2169: FND_MSG_PUB.Count_And_Get

2165: -- end
2166: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
2167: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
2168: fnd_msg_pub.add;
2169: FND_MSG_PUB.Count_And_Get
2170: (p_count => x_msg_count,
2171: p_data => x_msg_data
2172: );
2173: end; --2

Line 2186: fnd_msg_pub.add;

2182: l_tbl.delete; -- to delete the record from TOR if no shift found
2183: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
2184: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
2185: fnd_message.set_token('P_RES_NAME', l_resource_name);
2186: fnd_msg_pub.add;
2187:
2188: FND_MSG_PUB.Count_And_Get
2189: (p_count => x_msg_count,
2190: p_data => x_msg_data

Line 2188: FND_MSG_PUB.Count_And_Get

2184: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
2185: fnd_message.set_token('P_RES_NAME', l_resource_name);
2186: fnd_msg_pub.add;
2187:
2188: FND_MSG_PUB.Count_And_Get
2189: (p_count => x_msg_count,
2190: p_data => x_msg_data
2191: );
2192: end; -- 1

Line 2205: fnd_msg_pub.add;

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

Line 2207: fnd_msg_pub.count_and_get( p_count => x_msg_count

2203: -- end
2204: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFT_CONSTR_FOUND');
2205: fnd_msg_pub.add;
2206:
2207: fnd_msg_pub.count_and_get( p_count => x_msg_count
2208: , p_data => x_msg_data );
2209: end if;
2210:
2211:

Line 2234: fnd_msg_pub.add;

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

Line 2235: fnd_msg_pub.count_and_get ( p_count => x_msg_count

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

Line 2240: fnd_msg_pub.count_and_get ( p_count => x_msg_count

2236: , p_data => x_msg_data );
2237:
2238: when fnd_api.g_exc_unexpected_error then
2239: x_return_status := fnd_api.g_ret_sts_unexp_error;
2240: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2241: , p_data => x_msg_data );
2242: when fnd_api.g_exc_error then
2243: x_return_status := fnd_api.g_ret_sts_unexp_error;
2244: fnd_msg_pub.count_and_get ( p_count => x_msg_count

Line 2244: fnd_msg_pub.count_and_get ( p_count => x_msg_count

2240: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2241: , p_data => x_msg_data );
2242: when fnd_api.g_exc_error then
2243: x_return_status := fnd_api.g_ret_sts_unexp_error;
2244: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2245: , p_data => x_msg_data );
2246: when others then
2247: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2248: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');

Line 2251: fnd_msg_pub.count_and_get ( p_count => x_msg_count

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

Line 2294: FND_MSG_PUB.initialize;

2290: END IF;
2291:
2292: -- Initialize message list if p_init_msg_list is set to TRUE.
2293: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2294: FND_MSG_PUB.initialize;
2295: END IF;
2296:
2297: -- Call to check for required fields
2298: IF not check_for_required_fields (p_resource_id =>p_resource_id,

Line 2343: FND_MSG_PUB.Count_And_Get

2339:
2340: EXCEPTION
2341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2343: FND_MSG_PUB.Count_And_Get
2344: ( p_count => x_msg_count,
2345: p_data => x_msg_data
2346: );
2347: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN

Line 2351: fnd_msg_pub.add;

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

Line 2352: FND_MSG_PUB.Count_And_Get

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

Line 2361: fnd_msg_pub.add;

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

Line 2362: FND_MSG_PUB.Count_And_Get

2358: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2359: fnd_message.set_token('ERROR_CODE',SQLCODE);
2360: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2361: fnd_msg_pub.add;
2362: FND_MSG_PUB.Count_And_Get
2363: ( p_count => x_msg_count,
2364: p_data => x_msg_data
2365: );
2366:

Line 2555: FND_MSG_PUB.initialize;

2551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2552: END IF;
2553: -- Initialize message list if p_init_msg_list is set to TRUE.
2554: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2555: FND_MSG_PUB.initialize;
2556: END IF;
2557: -- Call to check for required fields
2558: IF not check_for_required_fields (p_resource_id =>p_resource_id,
2559: p_resource_type =>p_resource_type,

Line 2826: fnd_msg_pub.add;

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

Line 2827: FND_MSG_PUB.Count_And_Get

2823: x_return_status := FND_API.G_RET_STS_ERROR ;
2824: fnd_message.set_name('JTF','JTF_CAL_NO_SHIFTS');
2825: fnd_message.set_token('P_CAL_NAME', l_calendar_name);
2826: fnd_msg_pub.add;
2827: FND_MSG_PUB.Count_And_Get
2828: (p_count => x_msg_count,
2829: p_data => x_msg_data
2830: );
2831: end; --(2)

Line 2839: fnd_msg_pub.add;

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

Line 2840: FND_MSG_PUB.Count_And_Get

2836: fnd_message.set_name('JTF','JTF_CAL_RES_NO_CAL');
2837: fnd_message.set_token('P_SHIFT_DATE', l_shift_date);
2838: fnd_message.set_token('P_RES_NAME', l_resource_name);
2839: fnd_msg_pub.add;
2840: FND_MSG_PUB.Count_And_Get
2841: (p_count => x_msg_count,
2842: p_data => x_msg_data
2843: );
2844: end; --(1)

Line 2862: FND_MSG_PUB.Count_And_Get

2858: end if;
2859: EXCEPTION
2860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2862: FND_MSG_PUB.Count_And_Get
2863: ( p_count => x_msg_count,
2864: p_data => x_msg_data
2865: );
2866: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN

Line 2870: fnd_msg_pub.add;

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

Line 2871: FND_MSG_PUB.Count_And_Get

2867: x_return_status := FND_API.G_RET_STS_ERROR ;
2868: fnd_message.set_name('JTF','JTF_CAL_REQUIRED_PARAMETERS');
2869: fnd_message.set_token('P_PARAMETER', l_parameters);
2870: fnd_msg_pub.add;
2871: FND_MSG_PUB.Count_And_Get
2872: (p_count => x_msg_count,
2873: p_data => x_msg_data
2874: );
2875: when fnd_api.g_exc_error then

Line 2877: fnd_msg_pub.count_and_get ( p_count => x_msg_count

2873: p_data => x_msg_data
2874: );
2875: when fnd_api.g_exc_error then
2876: x_return_status := fnd_api.g_ret_sts_unexp_error;
2877: fnd_msg_pub.count_and_get ( p_count => x_msg_count
2878: , p_data => x_msg_data );
2879: WHEN OTHERS THEN
2880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2881: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');

Line 2884: fnd_msg_pub.add;

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

Line 2885: FND_MSG_PUB.Count_And_Get

2881: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
2882: fnd_message.set_token('ERROR_CODE',SQLCODE);
2883: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
2884: fnd_msg_pub.add;
2885: FND_MSG_PUB.Count_And_Get
2886: (p_count => x_msg_count,
2887: p_data => x_msg_data
2888: );
2889:

Line 2968: FND_MSG_PUB.initialize;

2964: END IF;
2965:
2966: -- Initialize message list if p_init_msg_list is set to TRUE.
2967: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2968: FND_MSG_PUB.initialize;
2969: END IF;
2970:
2971: -- Initialize API return status to success
2972: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2989: FND_MSG_PUB.Count_And_Get

2985:
2986: EXCEPTION
2987: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2989: FND_MSG_PUB.Count_And_Get
2990: ( p_count => x_msg_count,
2991: p_data => x_msg_data
2992: );
2993: WHEN G_EXC_REQUIRED_FIELDS_NULL THEN

Line 2997: fnd_msg_pub.add;

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

Line 2998: FND_MSG_PUB.Count_And_Get

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

Line 3007: fnd_msg_pub.add;

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

Line 3008: FND_MSG_PUB.Count_And_Get

3004: fnd_message.set_name('JTF','JTF_CAL_UNEXPECTED_ERROR');
3005: fnd_message.set_token('ERROR_CODE',SQLCODE);
3006: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
3007: fnd_msg_pub.add;
3008: FND_MSG_PUB.Count_And_Get
3009: ( p_count => x_msg_count,
3010: p_data => x_msg_data
3011: );
3012: