DBA Data[Home] [Help]

APPS.JTF_TASK_RESOURCES_PVT dependencies on FND_MSG_PUB

Line 63: fnd_msg_pub.add;

59: THEN
60: x_return_status := fnd_api.g_ret_sts_unexp_error;
61: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_ID');
62: fnd_message.set_token('TASK_TEMPLATE_ID',P_TASK_TEMPLATE_ID);
63: fnd_msg_pub.add;
64:
65:
66: END IF;
67:

Line 110: fnd_msg_pub.add;

106: THEN
107: x_return_status := fnd_api.g_ret_sts_unexp_error;
108: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TYPE_ID');
109: fnd_message.set_token('TASK_TYPE_ID',P_TASK_TYPE_ID);
110: fnd_msg_pub.add;
111:
112:
113: END IF;
114:

Line 280: fnd_msg_pub.add ;

276: IF rr_cur3%notfound THEN
277:
278: x_return_status := fnd_api.g_ret_sts_unexp_error ;
279: fnd_message.set_name('JTF' ,'JTF_TASK_INSERTING_RESOURCE') ;
280: fnd_msg_pub.add ;
281: raise fnd_api.g_exc_unexpected_error ;
282:
283: ELSE
284:

Line 293: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,

289: when fnd_api.g_exc_unexpected_error then
290:
291: rollback to create_task_resource_pvt ;
292: x_return_status := fnd_api.g_ret_sts_unexp_error ;
293: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,
294: p_data => x_msg_data );
295: when others then
296:
297: rollback to create_task_resource_pvt ;

Line 300: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,

296:
297: rollback to create_task_resource_pvt ;
298: x_return_status := fnd_api.g_ret_sts_unexp_error ;
299:
300: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,
301: p_data => x_msg_data );
302: END;
303:
304:

Line 427: fnd_msg_pub.add ;

423: fetch trsr_get_cur into task_res ;
424:
425: if trsr_get_cur%notfound then
426: fnd_message.set_name( 'JTF', 'JTF_TASK_INV_RES_REQ_ID') ;
427: fnd_msg_pub.add ;
428: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
429: raise fnd_api.g_exc_unexpected_error ;
430: end if ;
431:

Line 534: -- fnd_msg_pub.count_and_get( p_count => x_msg_count ,

530: if fnd_api.to_boolean(p_commit) then
531: commit work ;
532: end if ;
533:
534: -- fnd_msg_pub.count_and_get( p_count => x_msg_count ,
535: --p_data => x_msg_data ) ;
536:
537:
538: exception

Line 546: fnd_msg_pub.add ;

542: end if ;
543: rollback to update_task_resource_pvt ;
544: fnd_message.set_name( 'JTF', 'JTF_TASK_UPD_RES_REQ_ID') ;
545: fnd_message.set_token('RESOURCE_REQ_ID',P_RESOURCE_REQ_ID);
546: fnd_msg_pub.add ;
547: x_return_status := fnd_api.g_ret_sts_unexp_error ;
548: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,
549: p_data => x_msg_data );
550: when others then

Line 548: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,

544: fnd_message.set_name( 'JTF', 'JTF_TASK_UPD_RES_REQ_ID') ;
545: fnd_message.set_token('RESOURCE_REQ_ID',P_RESOURCE_REQ_ID);
546: fnd_msg_pub.add ;
547: x_return_status := fnd_api.g_ret_sts_unexp_error ;
548: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,
549: p_data => x_msg_data );
550: when others then
551: if trsr_get_cur%isopen then
552: close trsr_get_cur ;

Line 557: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,

553: end if ;
554: rollback to update_task_resource_pvt ;
555: x_return_status := fnd_api.g_ret_sts_unexp_error ;
556:
557: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,
558: p_data => x_msg_data );
559: end ;
560:
561:

Line 626: fnd_msg_pub.add ;

622: fetch c_res_req_del into x ;
623:
624: if c_res_req_del%found then
625: fnd_message.set_name( 'JTF', 'JTF_TASK_DELETING_RES_REQ_ID') ;
626: fnd_msg_pub.add ;
627: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
628: raise fnd_api.g_exc_unexpected_error ;
629: close c_res_req_del ;
630:

Line 644: fnd_msg_pub.count_and_get( p_count => x_msg_count ,

640: if fnd_api.to_boolean(p_commit) then
641: commit work ;
642: end if ;
643:
644: fnd_msg_pub.count_and_get( p_count => x_msg_count ,
645: p_data => x_msg_data ) ;
646:
647:
648: exception

Line 652: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,

648: exception
649: when fnd_api.g_exc_unexpected_error then
650: rollback to delete_task_resource_pvt ;
651: x_return_status := fnd_api.g_ret_sts_unexp_error ;
652: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,
653: p_data => x_msg_data );
654:
655:
656: when others then

Line 660: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,

656: when others then
657: rollback to delete_task_resource_pvt;
658: x_return_status := fnd_api.g_ret_sts_unexp_error ;
659:
660: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,
661: p_data => x_msg_data );
662: end ;
663:
664:

Line 1009: FND_MSG_PUB.Count_And_Get

1005: exception
1006:
1007: WHEN FND_API.G_EXC_ERROR THEN
1008: x_return_status := FND_API.G_RET_STS_ERROR ;
1009: FND_MSG_PUB.Count_And_Get
1010:
1011: (p_count => x_msg_count ,
1012: p_data => x_msg_data
1013: );

Line 1017: FND_MSG_PUB.Count_And_Get

1013: );
1014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1015:
1016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1017: FND_MSG_PUB.Count_And_Get
1018: (p_count => x_msg_count ,
1019: p_data => x_msg_data
1020: );
1021: WHEN OTHERS THEN

Line 1025: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1021: WHEN OTHERS THEN
1022:
1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1024:
1025: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1026: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1027: END IF;
1028: FND_MSG_PUB.Count_And_Get
1029: (p_count => x_msg_count ,

Line 1026: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);

1022:
1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1024:
1025: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1026: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1027: END IF;
1028: FND_MSG_PUB.Count_And_Get
1029: (p_count => x_msg_count ,
1030: p_data => x_msg_data

Line 1028: FND_MSG_PUB.Count_And_Get

1024:
1025: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1026: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1027: END IF;
1028: FND_MSG_PUB.Count_And_Get
1029: (p_count => x_msg_count ,
1030: p_data => x_msg_data
1031: );
1032: