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.OZF_APPROVAL_PVT dependencies on FND_API

Line 57: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

53: -- NOTES
54: ---------------------------------------------------------------------
55: PROCEDURE Update_User_Action(
56: p_api_version IN NUMBER
57: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
58: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
59:
60: ,x_return_status OUT NOCOPY VARCHAR2
61: ,x_msg_data OUT NOCOPY VARCHAR2

Line 58: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

54: ---------------------------------------------------------------------
55: PROCEDURE Update_User_Action(
56: p_api_version IN NUMBER
57: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
58: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
59:
60: ,x_return_status OUT NOCOPY VARCHAR2
61: ,x_msg_data OUT NOCOPY VARCHAR2
62: ,x_msg_count OUT NOCOPY NUMBER

Line 151: IF NOT FND_API.Compatible_API_Call (

147: BEGIN
148: -- Standard begin of API savepoint
149: SAVEPOINT Update_User_Action_PVT;
150: -- Standard call to check for call compatibility.
151: IF NOT FND_API.Compatible_API_Call (
152: l_api_version,
153: p_api_version,
154: l_api_name,
155: G_PKG_NAME)

Line 157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

153: p_api_version,
154: l_api_name,
155: G_PKG_NAME)
156: THEN
157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
158: END IF;
159: -- Debug Message
160: IF G_DEBUG THEN
161: ozf_utility_pvt.debug_message( l_api_name||': Start');

Line 164: IF FND_API.To_Boolean (p_init_msg_list) THEN

160: IF G_DEBUG THEN
161: ozf_utility_pvt.debug_message( l_api_name||': Start');
162: END IF;
163: --Initialize message list if p_init_msg_list is TRUE.
164: IF FND_API.To_Boolean (p_init_msg_list) THEN
165: FND_MSG_PUB.initialize;
166: END IF;
167: -- Initialize API return status to sucess
168: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 168: x_return_status := FND_API.G_RET_STS_SUCCESS;

164: IF FND_API.To_Boolean (p_init_msg_list) THEN
165: FND_MSG_PUB.initialize;
166: END IF;
167: -- Initialize API return status to sucess
168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169:
170:
171: --Check if InComing User is Super User or Not
172: if p_approval_rec.object_type = 'SPECIAL_PRICE' then

Line 198: p_encoded => FND_API.G_FALSE,

194: FETCH csr_count_approvers INTO l_approver_rec_count ;
195: CLOSE csr_count_approvers;
196: if l_approver_rec_count = 0 then
197: FND_MSG_PUB.Count_And_Get (
198: p_encoded => FND_API.G_FALSE,
199: p_count => x_msg_count,
200: p_data => x_msg_data
201: );
202:

Line 260: ,p_init_msg_list => FND_API.G_FALSE

256:
257: -- Add_Access - List Approvers sent from Get_Approvers api
258: Add_Access(
259: p_api_version => p_api_version
260: ,p_init_msg_list => FND_API.G_FALSE
261: ,p_commit => FND_API.G_FALSE
262: ,p_validation_level => p_validation_level
263: ,x_return_status => x_return_status
264: ,x_msg_data => x_msg_data

Line 261: ,p_commit => FND_API.G_FALSE

257: -- Add_Access - List Approvers sent from Get_Approvers api
258: Add_Access(
259: p_api_version => p_api_version
260: ,p_init_msg_list => FND_API.G_FALSE
261: ,p_commit => FND_API.G_FALSE
262: ,p_validation_level => p_validation_level
263: ,x_return_status => x_return_status
264: ,x_msg_data => x_msg_data
265: ,x_msg_count => x_msg_count

Line 269: IF x_return_status = FND_API.g_ret_sts_error THEN

265: ,x_msg_count => x_msg_count
266: ,p_approval_rec => p_approval_rec
267: ,p_approvers => l_approvers_tbl );
268:
269: IF x_return_status = FND_API.g_ret_sts_error THEN
270: RAISE FND_API.g_exc_error;
271: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
272: RAISE FND_API.g_exc_unexpected_error;
273: END IF;

Line 270: RAISE FND_API.g_exc_error;

266: ,p_approval_rec => p_approval_rec
267: ,p_approvers => l_approvers_tbl );
268:
269: IF x_return_status = FND_API.g_ret_sts_error THEN
270: RAISE FND_API.g_exc_error;
271: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
272: RAISE FND_API.g_exc_unexpected_error;
273: END IF;
274:

Line 271: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

267: ,p_approvers => l_approvers_tbl );
268:
269: IF x_return_status = FND_API.g_ret_sts_error THEN
270: RAISE FND_API.g_exc_error;
271: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
272: RAISE FND_API.g_exc_unexpected_error;
273: END IF;
274:
275: -- Update approval access table to revoke access

Line 272: RAISE FND_API.g_exc_unexpected_error;

268:
269: IF x_return_status = FND_API.g_ret_sts_error THEN
270: RAISE FND_API.g_exc_error;
271: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
272: RAISE FND_API.g_exc_unexpected_error;
273: END IF;
274:
275: -- Update approval access table to revoke access
276: UPDATE ozf_approval_access

Line 397: ,p_init_msg_list => FND_API.G_FALSE

393: END IF;
394: -- Revoke_Access - Revoke acces to previous appprovers in the chain
395: Revoke_Access(
396: p_api_version => p_api_version
397: ,p_init_msg_list => FND_API.G_FALSE
398: ,p_validation_level => p_validation_level
399: ,x_return_status => x_return_status
400: ,x_msg_data => x_msg_data
401: ,x_msg_count => x_msg_count

Line 405: IF x_return_status = FND_API.g_ret_sts_error THEN

401: ,x_msg_count => x_msg_count
402: ,p_object_type => p_approval_rec.object_type
403: ,p_object_id => p_approval_rec.object_id);
404:
405: IF x_return_status = FND_API.g_ret_sts_error THEN
406: RAISE FND_API.g_exc_error;
407: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
408: RAISE FND_API.g_exc_unexpected_error;
409: END IF;

Line 406: RAISE FND_API.g_exc_error;

402: ,p_object_type => p_approval_rec.object_type
403: ,p_object_id => p_approval_rec.object_id);
404:
405: IF x_return_status = FND_API.g_ret_sts_error THEN
406: RAISE FND_API.g_exc_error;
407: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
408: RAISE FND_API.g_exc_unexpected_error;
409: END IF;
410:

Line 407: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

403: ,p_object_id => p_approval_rec.object_id);
404:
405: IF x_return_status = FND_API.g_ret_sts_error THEN
406: RAISE FND_API.g_exc_error;
407: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
408: RAISE FND_API.g_exc_unexpected_error;
409: END IF;
410:
411:

Line 408: RAISE FND_API.g_exc_unexpected_error;

404:
405: IF x_return_status = FND_API.g_ret_sts_error THEN
406: RAISE FND_API.g_exc_error;
407: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
408: RAISE FND_API.g_exc_unexpected_error;
409: END IF;
410:
411:
412: IF l_min_reassign_level <> 0 THEN

Line 428: p_encoded => FND_API.G_FALSE,

424: ozf_utility_pvt.debug_message( l_api_name||': End');
425: END IF;
426: --Standard call to get message count and if count=1, get the message
427: FND_MSG_PUB.Count_And_Get (
428: p_encoded => FND_API.G_FALSE,
429: p_count => x_msg_count,
430: p_data => x_msg_data
431: );
432: EXCEPTION

Line 433: WHEN FND_API.G_EXC_ERROR THEN

429: p_count => x_msg_count,
430: p_data => x_msg_data
431: );
432: EXCEPTION
433: WHEN FND_API.G_EXC_ERROR THEN
434: ROLLBACK TO Update_User_Action_PVT;
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: -- Standard call to get message count and if count=1, get the message
437: FND_MSG_PUB.Count_And_Get (

Line 435: x_return_status := FND_API.G_RET_STS_ERROR;

431: );
432: EXCEPTION
433: WHEN FND_API.G_EXC_ERROR THEN
434: ROLLBACK TO Update_User_Action_PVT;
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: -- Standard call to get message count and if count=1, get the message
437: FND_MSG_PUB.Count_And_Get (
438: p_encoded => FND_API.G_FALSE,
439: p_count => x_msg_count,

Line 438: p_encoded => FND_API.G_FALSE,

434: ROLLBACK TO Update_User_Action_PVT;
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: -- Standard call to get message count and if count=1, get the message
437: FND_MSG_PUB.Count_And_Get (
438: p_encoded => FND_API.G_FALSE,
439: p_count => x_msg_count,
440: p_data => x_msg_data
441: );
442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

438: p_encoded => FND_API.G_FALSE,
439: p_count => x_msg_count,
440: p_data => x_msg_data
441: );
442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
443: ROLLBACK TO Update_User_Action_PVT;
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445: -- Standard call to get message count and if count=1, get the message
446: FND_MSG_PUB.Count_And_Get (

Line 444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

440: p_data => x_msg_data
441: );
442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
443: ROLLBACK TO Update_User_Action_PVT;
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445: -- Standard call to get message count and if count=1, get the message
446: FND_MSG_PUB.Count_And_Get (
447: p_encoded => FND_API.G_FALSE,
448: p_count => x_msg_count,

Line 447: p_encoded => FND_API.G_FALSE,

443: ROLLBACK TO Update_User_Action_PVT;
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445: -- Standard call to get message count and if count=1, get the message
446: FND_MSG_PUB.Count_And_Get (
447: p_encoded => FND_API.G_FALSE,
448: p_count => x_msg_count,
449: p_data => x_msg_data
450: );
451: WHEN OTHERS THEN

Line 453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

449: p_data => x_msg_data
450: );
451: WHEN OTHERS THEN
452: ROLLBACK TO Update_User_Action_PVT;
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
454: IF OZF_UNEXP_ERROR_ON
455: THEN
456: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
457: END IF;

Line 460: p_encoded => FND_API.G_FALSE,

456: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
457: END IF;
458: -- Standard call to get message count and if count=1, get the message
459: FND_MSG_PUB.Count_And_Get (
460: p_encoded => FND_API.G_FALSE,
461: p_count => x_msg_count,
462: p_data => x_msg_data
463: );
464: --

Line 476: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

472: -- NOTES
473: ---------------------------------------------------------------------
474: PROCEDURE Get_Approvers(
475: p_api_version IN NUMBER
476: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
477: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
478:
479: ,x_return_status OUT NOCOPY VARCHAR2
480: ,x_msg_data OUT NOCOPY VARCHAR2

Line 477: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

473: ---------------------------------------------------------------------
474: PROCEDURE Get_Approvers(
475: p_api_version IN NUMBER
476: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
477: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
478:
479: ,x_return_status OUT NOCOPY VARCHAR2
480: ,x_msg_data OUT NOCOPY VARCHAR2
481: ,x_msg_count OUT NOCOPY NUMBER

Line 512: IF NOT FND_API.Compatible_API_Call (

508:
509: -- Standard begin of API savepoint
510: SAVEPOINT Get_Approvers_PVT;
511: -- Standard call to check for call compatibility.
512: IF NOT FND_API.Compatible_API_Call (
513: l_api_version,
514: p_api_version,
515: l_api_name,
516: G_PKG_NAME)

Line 518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

514: p_api_version,
515: l_api_name,
516: G_PKG_NAME)
517: THEN
518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
519: END IF;
520: -- Debug Message
521: IF G_DEBUG THEN
522: ozf_utility_pvt.debug_message( l_api_name||': Start');

Line 525: IF FND_API.To_Boolean (p_init_msg_list) THEN

521: IF G_DEBUG THEN
522: ozf_utility_pvt.debug_message( l_api_name||': Start');
523: END IF;
524: --Initialize message list if p_init_msg_list is TRUE.
525: IF FND_API.To_Boolean (p_init_msg_list) THEN
526: FND_MSG_PUB.initialize;
527: END IF;
528: -- Initialize API return status to sucess
529: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 529: x_return_status := FND_API.G_RET_STS_SUCCESS;

525: IF FND_API.To_Boolean (p_init_msg_list) THEN
526: FND_MSG_PUB.initialize;
527: END IF;
528: -- Initialize API return status to sucess
529: x_return_status := FND_API.G_RET_STS_SUCCESS;
530:
531: OPEN csr_approver_level (l_object_type, l_object_id);
532: FETCH csr_approver_level INTO l_approver_level;
533: CLOSE csr_approver_level;

Line 608: x_return_status := FND_API.g_ret_sts_error;

604: -- raise error if resource is null
605: IF l_resource_id IS NULL THEN
606: IF OZF_ERROR_ON THEN
607: ozf_utility_pvt.error_message('OZF_APPROVER_NOT_RESOURCE');
608: x_return_status := FND_API.g_ret_sts_error;
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611: END IF;
612: */

Line 609: RAISE FND_API.G_EXC_ERROR;

605: IF l_resource_id IS NULL THEN
606: IF OZF_ERROR_ON THEN
607: ozf_utility_pvt.error_message('OZF_APPROVER_NOT_RESOURCE');
608: x_return_status := FND_API.g_ret_sts_error;
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611: END IF;
612: */
613:

Line 639: p_encoded => FND_API.G_FALSE,

635: END IF;
636: */
637: --Standard call to get message count and if count=1, get the message
638: FND_MSG_PUB.Count_And_Get (
639: p_encoded => FND_API.G_FALSE,
640: p_count => x_msg_count,
641: p_data => x_msg_data
642: );
643: EXCEPTION

Line 644: WHEN FND_API.G_EXC_ERROR THEN

640: p_count => x_msg_count,
641: p_data => x_msg_data
642: );
643: EXCEPTION
644: WHEN FND_API.G_EXC_ERROR THEN
645: ROLLBACK TO Get_Approvers_PVT;
646: x_return_status := FND_API.G_RET_STS_ERROR;
647: -- Standard call to get message count and if count=1, get the message
648: FND_MSG_PUB.Count_And_Get (

Line 646: x_return_status := FND_API.G_RET_STS_ERROR;

642: );
643: EXCEPTION
644: WHEN FND_API.G_EXC_ERROR THEN
645: ROLLBACK TO Get_Approvers_PVT;
646: x_return_status := FND_API.G_RET_STS_ERROR;
647: -- Standard call to get message count and if count=1, get the message
648: FND_MSG_PUB.Count_And_Get (
649: p_encoded => FND_API.G_FALSE,
650: p_count => x_msg_count,

Line 649: p_encoded => FND_API.G_FALSE,

645: ROLLBACK TO Get_Approvers_PVT;
646: x_return_status := FND_API.G_RET_STS_ERROR;
647: -- Standard call to get message count and if count=1, get the message
648: FND_MSG_PUB.Count_And_Get (
649: p_encoded => FND_API.G_FALSE,
650: p_count => x_msg_count,
651: p_data => x_msg_data
652: );
653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

649: p_encoded => FND_API.G_FALSE,
650: p_count => x_msg_count,
651: p_data => x_msg_data
652: );
653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
654: ROLLBACK TO Get_Approvers_PVT;
655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
656: -- Standard call to get message count and if count=1, get the message
657: FND_MSG_PUB.Count_And_Get (

Line 655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

651: p_data => x_msg_data
652: );
653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
654: ROLLBACK TO Get_Approvers_PVT;
655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
656: -- Standard call to get message count and if count=1, get the message
657: FND_MSG_PUB.Count_And_Get (
658: p_encoded => FND_API.G_FALSE,
659: p_count => x_msg_count,

Line 658: p_encoded => FND_API.G_FALSE,

654: ROLLBACK TO Get_Approvers_PVT;
655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
656: -- Standard call to get message count and if count=1, get the message
657: FND_MSG_PUB.Count_And_Get (
658: p_encoded => FND_API.G_FALSE,
659: p_count => x_msg_count,
660: p_data => x_msg_data
661: );
662: WHEN OTHERS THEN

Line 664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

660: p_data => x_msg_data
661: );
662: WHEN OTHERS THEN
663: ROLLBACK TO Get_Approvers_PVT;
664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
665: IF OZF_UNEXP_ERROR_ON
666: THEN
667: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
668: END IF;

Line 671: p_encoded => FND_API.G_FALSE,

667: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
668: END IF;
669: -- Standard call to get message count and if count=1, get the message
670: FND_MSG_PUB.Count_And_Get (
671: p_encoded => FND_API.G_FALSE,
672: p_count => x_msg_count,
673: p_data => x_msg_data
674: );
675: --

Line 689: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

685: -- NOTES
686: ---------------------------------------------------------------------
687: PROCEDURE Add_Access(
688: p_api_version IN NUMBER
689: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
690: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
691: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
692:
693: ,x_msg_data OUT NOCOPY VARCHAR2

Line 690: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

686: ---------------------------------------------------------------------
687: PROCEDURE Add_Access(
688: p_api_version IN NUMBER
689: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
690: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
691: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
692:
693: ,x_msg_data OUT NOCOPY VARCHAR2
694: ,x_msg_count OUT NOCOPY NUMBER

Line 691: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

687: PROCEDURE Add_Access(
688: p_api_version IN NUMBER
689: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
690: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
691: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
692:
693: ,x_msg_data OUT NOCOPY VARCHAR2
694: ,x_msg_count OUT NOCOPY NUMBER
695: ,x_return_status OUT NOCOPY VARCHAR2

Line 714: IF NOT FND_API.Compatible_API_Call (

710: BEGIN
711: -- Standard begin of API savepoint
712: SAVEPOINT Add_Access_PVT;
713: -- Standard call to check for call compatibility.
714: IF NOT FND_API.Compatible_API_Call (
715: l_api_version,
716: p_api_version,
717: l_api_name,
718: G_PKG_NAME)

Line 720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

716: p_api_version,
717: l_api_name,
718: G_PKG_NAME)
719: THEN
720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
721: END IF;
722: -- Debug Message
723: IF G_DEBUG THEN
724: ozf_utility_pvt.debug_message( l_api_name||': Start');

Line 727: IF FND_API.To_Boolean (p_init_msg_list) THEN

723: IF G_DEBUG THEN
724: ozf_utility_pvt.debug_message( l_api_name||': Start');
725: END IF;
726: --Initialize message list if p_init_msg_list is TRUE.
727: IF FND_API.To_Boolean (p_init_msg_list) THEN
728: FND_MSG_PUB.initialize;
729: END IF;
730: -- Initialize API return status to sucess
731: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 731: x_return_status := FND_API.G_RET_STS_SUCCESS;

727: IF FND_API.To_Boolean (p_init_msg_list) THEN
728: FND_MSG_PUB.initialize;
729: END IF;
730: -- Initialize API return status to sucess
731: x_return_status := FND_API.G_RET_STS_SUCCESS;
732:
733: -- Get Primary Key
734: OPEN c_id;
735: FETCH c_id INTO l_approval_access_id;

Line 741: x_return_status := FND_API.g_ret_sts_error;

737:
738: IF p_approval_rec.object_type IS NULL THEN
739: IF OZF_ERROR_ON THEN
740: ozf_utility_pvt.error_message('OZF_OBJECT_TYPE_NOT_FOUND');
741: x_return_status := FND_API.g_ret_sts_error;
742: RAISE FND_API.G_EXC_ERROR;
743: END IF;
744: END IF;
745:

Line 742: RAISE FND_API.G_EXC_ERROR;

738: IF p_approval_rec.object_type IS NULL THEN
739: IF OZF_ERROR_ON THEN
740: ozf_utility_pvt.error_message('OZF_OBJECT_TYPE_NOT_FOUND');
741: x_return_status := FND_API.g_ret_sts_error;
742: RAISE FND_API.G_EXC_ERROR;
743: END IF;
744: END IF;
745:
746: IF p_approval_rec.object_id IS NULL THEN

Line 749: x_return_status := FND_API.g_ret_sts_error;

745:
746: IF p_approval_rec.object_id IS NULL THEN
747: IF OZF_ERROR_ON THEN
748: ozf_utility_pvt.error_message('OZF_OBJECT_ID_NOT_FOUND');
749: x_return_status := FND_API.g_ret_sts_error;
750: RAISE FND_API.G_EXC_ERROR;
751: END IF;
752: END IF;
753:

Line 750: RAISE FND_API.G_EXC_ERROR;

746: IF p_approval_rec.object_id IS NULL THEN
747: IF OZF_ERROR_ON THEN
748: ozf_utility_pvt.error_message('OZF_OBJECT_ID_NOT_FOUND');
749: x_return_status := FND_API.g_ret_sts_error;
750: RAISE FND_API.G_EXC_ERROR;
751: END IF;
752: END IF;
753:
754: -- Validate if the approvers record is valid

Line 759: x_return_status := FND_API.g_ret_sts_error;

755: FOR i in 1..p_approvers.count LOOP
756: IF p_approvers(i).approver_type <> 'USER' and p_approvers(i).approver_type <> 'PERSON' THEN
757: IF OZF_ERROR_ON THEN
758: ozf_utility_pvt.error_message('OZF_APPROVER_NOT_USER');
759: x_return_status := FND_API.g_ret_sts_error;
760: RAISE FND_API.G_EXC_ERROR;
761: END IF;
762: END IF;
763: --IF NOT resource_valid(p_approvers(i).approver_id) THEN

Line 760: RAISE FND_API.G_EXC_ERROR;

756: IF p_approvers(i).approver_type <> 'USER' and p_approvers(i).approver_type <> 'PERSON' THEN
757: IF OZF_ERROR_ON THEN
758: ozf_utility_pvt.error_message('OZF_APPROVER_NOT_USER');
759: x_return_status := FND_API.g_ret_sts_error;
760: RAISE FND_API.G_EXC_ERROR;
761: END IF;
762: END IF;
763: --IF NOT resource_valid(p_approvers(i).approver_id) THEN
764: -- IF OZF_ERROR_ON THEN

Line 766: -- x_return_status := FND_API.g_ret_sts_error;

762: END IF;
763: --IF NOT resource_valid(p_approvers(i).approver_id) THEN
764: -- IF OZF_ERROR_ON THEN
765: -- ozf_utility_pvt.error_message('OZF_APPROVER_NOT_RESOURCE');
766: -- x_return_status := FND_API.g_ret_sts_error;
767: -- RAISE FND_API.G_EXC_ERROR;
768: -- END IF;
769: --END IF;
770: IF p_approvers(i).approver_level IS NULL THEN

Line 767: -- RAISE FND_API.G_EXC_ERROR;

763: --IF NOT resource_valid(p_approvers(i).approver_id) THEN
764: -- IF OZF_ERROR_ON THEN
765: -- ozf_utility_pvt.error_message('OZF_APPROVER_NOT_RESOURCE');
766: -- x_return_status := FND_API.g_ret_sts_error;
767: -- RAISE FND_API.G_EXC_ERROR;
768: -- END IF;
769: --END IF;
770: IF p_approvers(i).approver_level IS NULL THEN
771: IF OZF_ERROR_ON THEN

Line 773: x_return_status := FND_API.g_ret_sts_error;

769: --END IF;
770: IF p_approvers(i).approver_level IS NULL THEN
771: IF OZF_ERROR_ON THEN
772: ozf_utility_pvt.error_message('OZF_APPROVAL_LEVEL_NOT_FOUND');
773: x_return_status := FND_API.g_ret_sts_error;
774: RAISE FND_API.G_EXC_ERROR;
775: END IF;
776: END IF;
777: END LOOP;

Line 774: RAISE FND_API.G_EXC_ERROR;

770: IF p_approvers(i).approver_level IS NULL THEN
771: IF OZF_ERROR_ON THEN
772: ozf_utility_pvt.error_message('OZF_APPROVAL_LEVEL_NOT_FOUND');
773: x_return_status := FND_API.g_ret_sts_error;
774: RAISE FND_API.G_EXC_ERROR;
775: END IF;
776: END IF;
777: END LOOP;
778:

Line 821: x_return_status := FND_API.g_ret_sts_error;

817: EXCEPTION
818: WHEN OTHERS THEN
819: IF OZF_ERROR_ON THEN
820: ozf_utility_pvt.error_message('OZF_APPROVAL_ACCESS_INSERT_ERR');
821: x_return_status := FND_API.g_ret_sts_error;
822: RAISE FND_API.G_EXC_ERROR;
823: END IF;
824: END;
825: END LOOP;

Line 822: RAISE FND_API.G_EXC_ERROR;

818: WHEN OTHERS THEN
819: IF OZF_ERROR_ON THEN
820: ozf_utility_pvt.error_message('OZF_APPROVAL_ACCESS_INSERT_ERR');
821: x_return_status := FND_API.g_ret_sts_error;
822: RAISE FND_API.G_EXC_ERROR;
823: END IF;
824: END;
825: END LOOP;
826:

Line 828: IF FND_API.To_Boolean ( p_commit ) THEN

824: END;
825: END LOOP;
826:
827: --Standard check of commit
828: IF FND_API.To_Boolean ( p_commit ) THEN
829: COMMIT WORK;
830: END IF;
831: -- Debug Message
832: IF G_DEBUG THEN

Line 837: p_encoded => FND_API.G_FALSE,

833: ozf_utility_pvt.debug_message( l_api_name||': End');
834: END IF;
835: --Standard call to get message count and if count=1, get the message
836: FND_MSG_PUB.Count_And_Get (
837: p_encoded => FND_API.G_FALSE,
838: p_count => x_msg_count,
839: p_data => x_msg_data
840: );
841: EXCEPTION

Line 842: WHEN FND_API.G_EXC_ERROR THEN

838: p_count => x_msg_count,
839: p_data => x_msg_data
840: );
841: EXCEPTION
842: WHEN FND_API.G_EXC_ERROR THEN
843: ROLLBACK TO Add_Access_PVT;
844: x_return_status := FND_API.G_RET_STS_ERROR;
845: -- Standard call to get message count and if count=1, get the message
846: FND_MSG_PUB.Count_And_Get (

Line 844: x_return_status := FND_API.G_RET_STS_ERROR;

840: );
841: EXCEPTION
842: WHEN FND_API.G_EXC_ERROR THEN
843: ROLLBACK TO Add_Access_PVT;
844: x_return_status := FND_API.G_RET_STS_ERROR;
845: -- Standard call to get message count and if count=1, get the message
846: FND_MSG_PUB.Count_And_Get (
847: p_encoded => FND_API.G_FALSE,
848: p_count => x_msg_count,

Line 847: p_encoded => FND_API.G_FALSE,

843: ROLLBACK TO Add_Access_PVT;
844: x_return_status := FND_API.G_RET_STS_ERROR;
845: -- Standard call to get message count and if count=1, get the message
846: FND_MSG_PUB.Count_And_Get (
847: p_encoded => FND_API.G_FALSE,
848: p_count => x_msg_count,
849: p_data => x_msg_data
850: );
851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

847: p_encoded => FND_API.G_FALSE,
848: p_count => x_msg_count,
849: p_data => x_msg_data
850: );
851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
852: ROLLBACK TO Add_Access_PVT;
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: -- Standard call to get message count and if count=1, get the message
855: FND_MSG_PUB.Count_And_Get (

Line 853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

849: p_data => x_msg_data
850: );
851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
852: ROLLBACK TO Add_Access_PVT;
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: -- Standard call to get message count and if count=1, get the message
855: FND_MSG_PUB.Count_And_Get (
856: p_encoded => FND_API.G_FALSE,
857: p_count => x_msg_count,

Line 856: p_encoded => FND_API.G_FALSE,

852: ROLLBACK TO Add_Access_PVT;
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: -- Standard call to get message count and if count=1, get the message
855: FND_MSG_PUB.Count_And_Get (
856: p_encoded => FND_API.G_FALSE,
857: p_count => x_msg_count,
858: p_data => x_msg_data
859: );
860: WHEN OTHERS THEN

Line 862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

858: p_data => x_msg_data
859: );
860: WHEN OTHERS THEN
861: ROLLBACK TO Add_Access_PVT;
862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
863: IF OZF_UNEXP_ERROR_ON
864: THEN
865: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
866: END IF;

Line 869: p_encoded => FND_API.G_FALSE,

865: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
866: END IF;
867: -- Standard call to get message count and if count=1, get the message
868: FND_MSG_PUB.Count_And_Get (
869: p_encoded => FND_API.G_FALSE,
870: p_count => x_msg_count,
871: p_data => x_msg_data
872: );
873: --

Line 888: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

884: -- NOTES
885: ---------------------------------------------------------------------
886: PROCEDURE Revoke_Access (
887: p_api_version IN NUMBER
888: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
889: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
890: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
891:
892: ,x_return_status OUT NOCOPY VARCHAR2

Line 889: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

885: ---------------------------------------------------------------------
886: PROCEDURE Revoke_Access (
887: p_api_version IN NUMBER
888: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
889: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
890: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
891:
892: ,x_return_status OUT NOCOPY VARCHAR2
893: ,x_msg_data OUT NOCOPY VARCHAR2

Line 890: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

886: PROCEDURE Revoke_Access (
887: p_api_version IN NUMBER
888: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
889: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
890: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
891:
892: ,x_return_status OUT NOCOPY VARCHAR2
893: ,x_msg_data OUT NOCOPY VARCHAR2
894: ,x_msg_count OUT NOCOPY NUMBER

Line 915: IF NOT FND_API.Compatible_API_Call (

911: BEGIN
912: -- Standard begin of API savepoint
913: SAVEPOINT Revoke_Access_PVT;
914: -- Standard call to check for call compatibility.
915: IF NOT FND_API.Compatible_API_Call (
916: l_api_version,
917: p_api_version,
918: l_api_name,
919: G_PKG_NAME)

Line 921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

917: p_api_version,
918: l_api_name,
919: G_PKG_NAME)
920: THEN
921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
922: END IF;
923: -- Debug Message
924: IF G_DEBUG THEN
925: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

Line 930: IF FND_API.To_Boolean (p_init_msg_list) THEN

926: FND_MESSAGE.Set_Token('TEXT',l_api_name||': Start');
927: FND_MSG_PUB.Add;
928: END IF;
929: --Initialize message list if p_init_msg_list is TRUE.
930: IF FND_API.To_Boolean (p_init_msg_list) THEN
931: FND_MSG_PUB.initialize;
932: END IF;
933: -- Initialize API return status to sucess
934: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 934: x_return_status := FND_API.G_RET_STS_SUCCESS;

930: IF FND_API.To_Boolean (p_init_msg_list) THEN
931: FND_MSG_PUB.initialize;
932: END IF;
933: -- Initialize API return status to sucess
934: x_return_status := FND_API.G_RET_STS_SUCCESS;
935:
936: -- Update records in ozf_approval_access_all to revoke access
937: OPEN csr_curr_approvers(p_object_type, p_object_id);
938: LOOP

Line 953: IF FND_API.To_Boolean ( p_commit ) THEN

949: END LOOP;
950: CLOSE csr_curr_approvers;
951:
952: --Standard check of commit
953: IF FND_API.To_Boolean ( p_commit ) THEN
954: COMMIT WORK;
955: END IF;
956: -- Debug Message
957: IF G_DEBUG THEN

Line 962: p_encoded => FND_API.G_FALSE,

958: ozf_utility_pvt.debug_message( l_api_name||': End');
959: END IF;
960: --Standard call to get message count and if count=1, get the message
961: FND_MSG_PUB.Count_And_Get (
962: p_encoded => FND_API.G_FALSE,
963: p_count => x_msg_count,
964: p_data => x_msg_data
965: );
966: EXCEPTION

Line 967: WHEN FND_API.G_EXC_ERROR THEN

963: p_count => x_msg_count,
964: p_data => x_msg_data
965: );
966: EXCEPTION
967: WHEN FND_API.G_EXC_ERROR THEN
968: ROLLBACK TO Revoke_Access_PVT;
969: x_return_status := FND_API.G_RET_STS_ERROR;
970: -- Standard call to get message count and if count=1, get the message
971: FND_MSG_PUB.Count_And_Get (

Line 969: x_return_status := FND_API.G_RET_STS_ERROR;

965: );
966: EXCEPTION
967: WHEN FND_API.G_EXC_ERROR THEN
968: ROLLBACK TO Revoke_Access_PVT;
969: x_return_status := FND_API.G_RET_STS_ERROR;
970: -- Standard call to get message count and if count=1, get the message
971: FND_MSG_PUB.Count_And_Get (
972: p_encoded => FND_API.G_FALSE,
973: p_count => x_msg_count,

Line 972: p_encoded => FND_API.G_FALSE,

968: ROLLBACK TO Revoke_Access_PVT;
969: x_return_status := FND_API.G_RET_STS_ERROR;
970: -- Standard call to get message count and if count=1, get the message
971: FND_MSG_PUB.Count_And_Get (
972: p_encoded => FND_API.G_FALSE,
973: p_count => x_msg_count,
974: p_data => x_msg_data
975: );
976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

972: p_encoded => FND_API.G_FALSE,
973: p_count => x_msg_count,
974: p_data => x_msg_data
975: );
976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
977: ROLLBACK TO Revoke_Access_PVT;
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
979: -- Standard call to get message count and if count=1, get the message
980: FND_MSG_PUB.Count_And_Get (

Line 978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

974: p_data => x_msg_data
975: );
976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
977: ROLLBACK TO Revoke_Access_PVT;
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
979: -- Standard call to get message count and if count=1, get the message
980: FND_MSG_PUB.Count_And_Get (
981: p_encoded => FND_API.G_FALSE,
982: p_count => x_msg_count,

Line 981: p_encoded => FND_API.G_FALSE,

977: ROLLBACK TO Revoke_Access_PVT;
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
979: -- Standard call to get message count and if count=1, get the message
980: FND_MSG_PUB.Count_And_Get (
981: p_encoded => FND_API.G_FALSE,
982: p_count => x_msg_count,
983: p_data => x_msg_data
984: );
985: WHEN OTHERS THEN

Line 987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

983: p_data => x_msg_data
984: );
985: WHEN OTHERS THEN
986: ROLLBACK TO Revoke_Access_PVT;
987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
988: IF OZF_UNEXP_ERROR_ON
989: THEN
990: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
991: END IF;

Line 994: p_encoded => FND_API.G_FALSE,

990: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
991: END IF;
992: -- Standard call to get message count and if count=1, get the message
993: FND_MSG_PUB.Count_And_Get (
994: p_encoded => FND_API.G_FALSE,
995: p_count => x_msg_count,
996: p_data => x_msg_data
997: );
998: --

Line 1147: x_return_status := FND_API.g_ret_sts_error;

1143: IF l_event = 'NOTFOUND' THEN
1144: IF OZF_ERROR_ON THEN
1145: ozf_utility_pvt.error_message('OZF_WF_EVENT_NAME_NULL', 'NAME', p_event_name);
1146: END IF;
1147: x_return_status := FND_API.g_ret_sts_error;
1148: RAISE FND_API.G_EXC_ERROR;
1149: END IF;
1150:
1151: l_parameter_t.setName('OBJECT_TYPE');

Line 1148: RAISE FND_API.G_EXC_ERROR;

1144: IF OZF_ERROR_ON THEN
1145: ozf_utility_pvt.error_message('OZF_WF_EVENT_NAME_NULL', 'NAME', p_event_name);
1146: END IF;
1147: x_return_status := FND_API.g_ret_sts_error;
1148: RAISE FND_API.G_EXC_ERROR;
1149: END IF;
1150:
1151: l_parameter_t.setName('OBJECT_TYPE');
1152: l_parameter_t.setValue(p_approval_rec.object_type);

Line 1174: WHEN FND_API.G_EXC_ERROR THEN

1170: p_parameters => l_parameter_list,
1171: p_event_data => NULL);
1172:
1173: EXCEPTION
1174: WHEN FND_API.G_EXC_ERROR THEN
1175: ROLLBACK TO Raise_Event_PVT;
1176: x_return_status := FND_API.G_RET_STS_ERROR;
1177: -- Standard call to get message count and if count=1, get the message
1178: FND_MSG_PUB.Count_And_Get (

Line 1176: x_return_status := FND_API.G_RET_STS_ERROR;

1172:
1173: EXCEPTION
1174: WHEN FND_API.G_EXC_ERROR THEN
1175: ROLLBACK TO Raise_Event_PVT;
1176: x_return_status := FND_API.G_RET_STS_ERROR;
1177: -- Standard call to get message count and if count=1, get the message
1178: FND_MSG_PUB.Count_And_Get (
1179: p_encoded => FND_API.G_FALSE,
1180: p_count => x_msg_count,

Line 1179: p_encoded => FND_API.G_FALSE,

1175: ROLLBACK TO Raise_Event_PVT;
1176: x_return_status := FND_API.G_RET_STS_ERROR;
1177: -- Standard call to get message count and if count=1, get the message
1178: FND_MSG_PUB.Count_And_Get (
1179: p_encoded => FND_API.G_FALSE,
1180: p_count => x_msg_count,
1181: p_data => x_msg_data
1182: );
1183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1179: p_encoded => FND_API.G_FALSE,
1180: p_count => x_msg_count,
1181: p_data => x_msg_data
1182: );
1183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1184: ROLLBACK TO Raise_Event_PVT;
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186: -- Standard call to get message count and if count=1, get the message
1187: FND_MSG_PUB.Count_And_Get (

Line 1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1181: p_data => x_msg_data
1182: );
1183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1184: ROLLBACK TO Raise_Event_PVT;
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186: -- Standard call to get message count and if count=1, get the message
1187: FND_MSG_PUB.Count_And_Get (
1188: p_encoded => FND_API.G_FALSE,
1189: p_count => x_msg_count,

Line 1188: p_encoded => FND_API.G_FALSE,

1184: ROLLBACK TO Raise_Event_PVT;
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186: -- Standard call to get message count and if count=1, get the message
1187: FND_MSG_PUB.Count_And_Get (
1188: p_encoded => FND_API.G_FALSE,
1189: p_count => x_msg_count,
1190: p_data => x_msg_data
1191: );
1192: WHEN OTHERS THEN

Line 1194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1190: p_data => x_msg_data
1191: );
1192: WHEN OTHERS THEN
1193: ROLLBACK TO Raise_Event_PVT;
1194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1195: IF OZF_UNEXP_ERROR_ON
1196: THEN
1197: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1198: END IF;

Line 1201: p_encoded => FND_API.G_FALSE,

1197: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1198: END IF;
1199: -- Standard call to get message count and if count=1, get the message
1200: FND_MSG_PUB.Count_And_Get (
1201: p_encoded => FND_API.G_FALSE,
1202: p_count => x_msg_count,
1203: p_data => x_msg_data
1204: );
1205: --

Line 1220: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1216: -- NOTES
1217: ---------------------------------------------------------------------
1218: PROCEDURE Send_Notification (
1219: p_api_version IN NUMBER
1220: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1221: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1222: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1223:
1224: ,x_return_status OUT NOCOPY VARCHAR2

Line 1221: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1217: ---------------------------------------------------------------------
1218: PROCEDURE Send_Notification (
1219: p_api_version IN NUMBER
1220: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1221: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1222: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1223:
1224: ,x_return_status OUT NOCOPY VARCHAR2
1225: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1222: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

1218: PROCEDURE Send_Notification (
1219: p_api_version IN NUMBER
1220: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1221: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1222: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1223:
1224: ,x_return_status OUT NOCOPY VARCHAR2
1225: ,x_msg_data OUT NOCOPY VARCHAR2
1226: ,x_msg_count OUT NOCOPY NUMBER

Line 1319: IF NOT FND_API.Compatible_API_Call (

1315: BEGIN
1316: -- Standard begin of API savepoint
1317: SAVEPOINT Send_Notification_PVT;
1318: -- Standard call to check for call compatibility.
1319: IF NOT FND_API.Compatible_API_Call (
1320: l_api_version,
1321: p_api_version,
1322: l_api_name,
1323: G_PKG_NAME)

Line 1325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1321: p_api_version,
1322: l_api_name,
1323: G_PKG_NAME)
1324: THEN
1325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1326: END IF;
1327: -- Debug Message
1328: IF G_DEBUG THEN
1329: ozf_utility_pvt.debug_message( l_api_name||': Start');

Line 1332: IF FND_API.To_Boolean (p_init_msg_list) THEN

1328: IF G_DEBUG THEN
1329: ozf_utility_pvt.debug_message( l_api_name||': Start');
1330: END IF;
1331: --Initialize message list if p_init_msg_list is TRUE.
1332: IF FND_API.To_Boolean (p_init_msg_list) THEN
1333: FND_MSG_PUB.initialize;
1334: END IF;
1335: -- Initialize API return status to sucess
1336: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1336: x_return_status := FND_API.G_RET_STS_SUCCESS;

1332: IF FND_API.To_Boolean (p_init_msg_list) THEN
1333: FND_MSG_PUB.initialize;
1334: END IF;
1335: -- Initialize API return status to sucess
1336: x_return_status := FND_API.G_RET_STS_SUCCESS;
1337:
1338: IF l_user_role is null THEN
1339: l_user_role := '%';
1340: ELSE

Line 1507: IF FND_API.To_Boolean ( p_commit ) THEN

1503: where object_type = l_object_type
1504: and object_id = l_object_id);
1505:
1506: --Standard check of commit
1507: IF FND_API.To_Boolean ( p_commit ) THEN
1508: COMMIT WORK;
1509: END IF;
1510:
1511: -- Debug Message

Line 1517: p_encoded => FND_API.G_FALSE,

1513: ozf_utility_pvt.debug_message( l_api_name||': End');
1514: END IF;
1515: --Standard call to get message count and if count=1, get the message
1516: FND_MSG_PUB.Count_And_Get (
1517: p_encoded => FND_API.G_FALSE,
1518: p_count => x_msg_count,
1519: p_data => x_msg_data
1520: );
1521: EXCEPTION

Line 1522: WHEN FND_API.G_EXC_ERROR THEN

1518: p_count => x_msg_count,
1519: p_data => x_msg_data
1520: );
1521: EXCEPTION
1522: WHEN FND_API.G_EXC_ERROR THEN
1523: ROLLBACK TO Send_Notification_PVT;
1524: x_return_status := FND_API.G_RET_STS_ERROR;
1525: -- Standard call to get message count and if count=1, get the message
1526: FND_MSG_PUB.Count_And_Get (

Line 1524: x_return_status := FND_API.G_RET_STS_ERROR;

1520: );
1521: EXCEPTION
1522: WHEN FND_API.G_EXC_ERROR THEN
1523: ROLLBACK TO Send_Notification_PVT;
1524: x_return_status := FND_API.G_RET_STS_ERROR;
1525: -- Standard call to get message count and if count=1, get the message
1526: FND_MSG_PUB.Count_And_Get (
1527: p_encoded => FND_API.G_FALSE,
1528: p_count => x_msg_count,

Line 1527: p_encoded => FND_API.G_FALSE,

1523: ROLLBACK TO Send_Notification_PVT;
1524: x_return_status := FND_API.G_RET_STS_ERROR;
1525: -- Standard call to get message count and if count=1, get the message
1526: FND_MSG_PUB.Count_And_Get (
1527: p_encoded => FND_API.G_FALSE,
1528: p_count => x_msg_count,
1529: p_data => x_msg_data
1530: );
1531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1527: p_encoded => FND_API.G_FALSE,
1528: p_count => x_msg_count,
1529: p_data => x_msg_data
1530: );
1531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1532: ROLLBACK TO Send_Notification_PVT;
1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1534: -- Standard call to get message count and if count=1, get the message
1535: FND_MSG_PUB.Count_And_Get (

Line 1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1529: p_data => x_msg_data
1530: );
1531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1532: ROLLBACK TO Send_Notification_PVT;
1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1534: -- Standard call to get message count and if count=1, get the message
1535: FND_MSG_PUB.Count_And_Get (
1536: p_encoded => FND_API.G_FALSE,
1537: p_count => x_msg_count,

Line 1536: p_encoded => FND_API.G_FALSE,

1532: ROLLBACK TO Send_Notification_PVT;
1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1534: -- Standard call to get message count and if count=1, get the message
1535: FND_MSG_PUB.Count_And_Get (
1536: p_encoded => FND_API.G_FALSE,
1537: p_count => x_msg_count,
1538: p_data => x_msg_data
1539: );
1540: WHEN OTHERS THEN

Line 1543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1539: );
1540: WHEN OTHERS THEN
1541: -- ozf_utility_pvt.debug_message('Error OTHERS >>>>>>>>> ' || substr(sqlerrm,1,140));
1542: ROLLBACK TO Send_Notification_PVT;
1543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1544: IF OZF_UNEXP_ERROR_ON
1545: THEN
1546: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1547: END IF;

Line 1550: p_encoded => FND_API.G_FALSE,

1546: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1547: END IF;
1548: -- Standard call to get message count and if count=1, get the message
1549: FND_MSG_PUB.Count_And_Get (
1550: p_encoded => FND_API.G_FALSE,
1551: p_count => x_msg_count,
1552: p_data => x_msg_data
1553: );
1554: --

Line 1571: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1567: -- 1. object_version_number will be set to 1.
1568: ---------------------------------------------------------------------
1569: PROCEDURE Process_User_Action (
1570: p_api_version IN NUMBER
1571: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1572: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1573: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1574:
1575: ,x_return_status OUT NOCOPY VARCHAR2

Line 1572: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1568: ---------------------------------------------------------------------
1569: PROCEDURE Process_User_Action (
1570: p_api_version IN NUMBER
1571: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1572: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1573: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1574:
1575: ,x_return_status OUT NOCOPY VARCHAR2
1576: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1573: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

1569: PROCEDURE Process_User_Action (
1570: p_api_version IN NUMBER
1571: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1572: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1573: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1574:
1575: ,x_return_status OUT NOCOPY VARCHAR2
1576: ,x_msg_data OUT NOCOPY VARCHAR2
1577: ,x_msg_count OUT NOCOPY NUMBER

Line 1596: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

1592: l_user_callback_api varchar2(240);
1593: l_benefit_id number;
1594: l_partner_id number;
1595: l_final_approval_flag varchar2(1) := 'N';
1596: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1597:
1598: CURSOR csr_forward_reassign (p_request_id in number , p_object_type in varchar2) IS
1599: select nvl(approval_level,1) + 1
1600: from ozf_approval_access

Line 1616: IF NOT FND_API.Compatible_API_Call (

1612: BEGIN
1613: -- Standard begin of API savepoint
1614: SAVEPOINT Process_User_Action_PVT;
1615: -- Standard call to check for call compatibility.
1616: IF NOT FND_API.Compatible_API_Call (
1617: l_api_version,
1618: p_api_version,
1619: l_api_name,
1620: G_PKG_NAME)

Line 1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1618: p_api_version,
1619: l_api_name,
1620: G_PKG_NAME)
1621: THEN
1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1623: END IF;
1624: -- Debug Message
1625: IF G_DEBUG THEN
1626: ozf_utility_pvt.debug_message( l_api_name||': Start');

Line 1629: IF FND_API.To_Boolean (p_init_msg_list) THEN

1625: IF G_DEBUG THEN
1626: ozf_utility_pvt.debug_message( l_api_name||': Start');
1627: END IF;
1628: --Initialize message list if p_init_msg_list is TRUE.
1629: IF FND_API.To_Boolean (p_init_msg_list) THEN
1630: FND_MSG_PUB.initialize;
1631: END IF;
1632: -- Initialize API return status to sucess
1633: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1633: x_return_status := FND_API.G_RET_STS_SUCCESS;

1629: IF FND_API.To_Boolean (p_init_msg_list) THEN
1630: FND_MSG_PUB.initialize;
1631: END IF;
1632: -- Initialize API return status to sucess
1633: x_return_status := FND_API.G_RET_STS_SUCCESS;
1634:
1635:
1636: /*
1637: Action Code will be Notify when , the Final Approval has Happened

Line 1690: x_return_status := FND_API.g_ret_sts_error;

1686: -- Raise error if no approvers are sent for reassignment.
1687: IF l_approvers_tbl.count = 0 THEN
1688: IF OZF_ERROR_ON THEN
1689: ozf_utility_pvt.error_message('OZF_NO_APPR_FOUND_FOR_FORWARD');
1690: x_return_status := FND_API.g_ret_sts_error;
1691: RAISE FND_API.G_EXC_ERROR;
1692: END IF;
1693: END IF;
1694: END IF;

Line 1691: RAISE FND_API.G_EXC_ERROR;

1687: IF l_approvers_tbl.count = 0 THEN
1688: IF OZF_ERROR_ON THEN
1689: ozf_utility_pvt.error_message('OZF_NO_APPR_FOUND_FOR_FORWARD');
1690: x_return_status := FND_API.g_ret_sts_error;
1691: RAISE FND_API.G_EXC_ERROR;
1692: END IF;
1693: END IF;
1694: END IF;
1695:

Line 1703: ,p_init_msg_list => FND_API.G_FALSE

1699:
1700: -- Update_User_Action - Update the user action in approval table
1701: Update_User_Action(
1702: p_api_version => p_api_version
1703: ,p_init_msg_list => FND_API.G_FALSE
1704: ,p_validation_level => p_validation_level
1705: ,x_return_status => l_return_status
1706: ,x_msg_data => x_msg_data
1707: ,x_msg_count => x_msg_count

Line 1710: IF l_return_status = FND_API.g_ret_sts_error THEN

1706: ,x_msg_data => x_msg_data
1707: ,x_msg_count => x_msg_count
1708: ,p_approval_rec => p_approval_rec);
1709:
1710: IF l_return_status = FND_API.g_ret_sts_error THEN
1711: RAISE FND_API.g_exc_error;
1712: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1713: RAISE FND_API.g_exc_unexpected_error;
1714: END IF;

Line 1711: RAISE FND_API.g_exc_error;

1707: ,x_msg_count => x_msg_count
1708: ,p_approval_rec => p_approval_rec);
1709:
1710: IF l_return_status = FND_API.g_ret_sts_error THEN
1711: RAISE FND_API.g_exc_error;
1712: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1713: RAISE FND_API.g_exc_unexpected_error;
1714: END IF;
1715:

Line 1712: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1708: ,p_approval_rec => p_approval_rec);
1709:
1710: IF l_return_status = FND_API.g_ret_sts_error THEN
1711: RAISE FND_API.g_exc_error;
1712: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1713: RAISE FND_API.g_exc_unexpected_error;
1714: END IF;
1715:
1716: IF p_approval_rec.action_code = 'REJECT' OR p_approval_rec.action_code = 'RETURN' THEN

Line 1713: RAISE FND_API.g_exc_unexpected_error;

1709:
1710: IF l_return_status = FND_API.g_ret_sts_error THEN
1711: RAISE FND_API.g_exc_error;
1712: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1713: RAISE FND_API.g_exc_unexpected_error;
1714: END IF;
1715:
1716: IF p_approval_rec.action_code = 'REJECT' OR p_approval_rec.action_code = 'RETURN' THEN
1717: l_final_approval_flag := 'Y';

Line 1734: ,p_init_msg_list => FND_API.G_FALSE

1730:
1731: -- Get_Approvers - List of Approvers or Default Approver
1732: Get_Approvers(
1733: p_api_version => p_api_version
1734: ,p_init_msg_list => FND_API.G_FALSE
1735: ,p_validation_level => p_validation_level
1736: ,x_return_status => l_return_status
1737: ,x_msg_data => x_msg_data
1738: ,x_msg_count => x_msg_count

Line 1743: IF l_return_status = FND_API.g_ret_sts_error THEN

1739: ,p_approval_rec => p_approval_rec
1740: ,x_approvers => l_approvers_tbl
1741: ,x_final_approval_flag => l_final_approval_flag);
1742:
1743: IF l_return_status = FND_API.g_ret_sts_error THEN
1744: RAISE FND_API.g_exc_error;
1745: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1746: RAISE FND_API.g_exc_unexpected_error;
1747: END IF;

Line 1744: RAISE FND_API.g_exc_error;

1740: ,x_approvers => l_approvers_tbl
1741: ,x_final_approval_flag => l_final_approval_flag);
1742:
1743: IF l_return_status = FND_API.g_ret_sts_error THEN
1744: RAISE FND_API.g_exc_error;
1745: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1746: RAISE FND_API.g_exc_unexpected_error;
1747: END IF;
1748: END IF;

Line 1745: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1741: ,x_final_approval_flag => l_final_approval_flag);
1742:
1743: IF l_return_status = FND_API.g_ret_sts_error THEN
1744: RAISE FND_API.g_exc_error;
1745: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1746: RAISE FND_API.g_exc_unexpected_error;
1747: END IF;
1748: END IF;
1749:

Line 1746: RAISE FND_API.g_exc_unexpected_error;

1742:
1743: IF l_return_status = FND_API.g_ret_sts_error THEN
1744: RAISE FND_API.g_exc_error;
1745: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1746: RAISE FND_API.g_exc_unexpected_error;
1747: END IF;
1748: END IF;
1749:
1750: -- Add access to users who have approval privileges

Line 1765: ,p_init_msg_list => FND_API.G_FALSE

1761: if l_approvers_tbl(1).approver_id is not null then
1762: -- Add_Access - List Approvers sent from Get_Approvers api
1763: Add_Access(
1764: p_api_version => p_api_version
1765: ,p_init_msg_list => FND_API.G_FALSE
1766: ,p_commit => FND_API.G_FALSE
1767: ,p_validation_level => p_validation_level
1768: ,x_return_status => l_return_status
1769: ,x_msg_data => x_msg_data

Line 1766: ,p_commit => FND_API.G_FALSE

1762: -- Add_Access - List Approvers sent from Get_Approvers api
1763: Add_Access(
1764: p_api_version => p_api_version
1765: ,p_init_msg_list => FND_API.G_FALSE
1766: ,p_commit => FND_API.G_FALSE
1767: ,p_validation_level => p_validation_level
1768: ,x_return_status => l_return_status
1769: ,x_msg_data => x_msg_data
1770: ,x_msg_count => x_msg_count

Line 1774: IF l_return_status = FND_API.g_ret_sts_error THEN

1770: ,x_msg_count => x_msg_count
1771: ,p_approval_rec => p_approval_rec
1772: ,p_approvers => l_approvers_tbl );
1773:
1774: IF l_return_status = FND_API.g_ret_sts_error THEN
1775: RAISE FND_API.g_exc_error;
1776: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1777: RAISE FND_API.g_exc_unexpected_error;
1778: END IF;

Line 1775: RAISE FND_API.g_exc_error;

1771: ,p_approval_rec => p_approval_rec
1772: ,p_approvers => l_approvers_tbl );
1773:
1774: IF l_return_status = FND_API.g_ret_sts_error THEN
1775: RAISE FND_API.g_exc_error;
1776: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1777: RAISE FND_API.g_exc_unexpected_error;
1778: END IF;
1779: END IF; --End if some Approver is found

Line 1776: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1772: ,p_approvers => l_approvers_tbl );
1773:
1774: IF l_return_status = FND_API.g_ret_sts_error THEN
1775: RAISE FND_API.g_exc_error;
1776: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1777: RAISE FND_API.g_exc_unexpected_error;
1778: END IF;
1779: END IF; --End if some Approver is found
1780:

Line 1777: RAISE FND_API.g_exc_unexpected_error;

1773:
1774: IF l_return_status = FND_API.g_ret_sts_error THEN
1775: RAISE FND_API.g_exc_error;
1776: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1777: RAISE FND_API.g_exc_unexpected_error;
1778: END IF;
1779: END IF; --End if some Approver is found
1780:
1781: END IF;

Line 1834: p_init_msg_list => FND_API.g_false,

1830:
1831: -- Call PRM api to send notification based on setups
1832: PV_BENFT_STATUS_CHANGE.status_change_raise(
1833: p_api_version_number => p_api_version,
1834: p_init_msg_list => FND_API.g_false,
1835: p_commit => FND_API.g_false,
1836: p_validation_level => p_validation_level,
1837: p_event_name => l_event_name,
1838: p_benefit_id => l_benefit_id,

Line 1835: p_commit => FND_API.g_false,

1831: -- Call PRM api to send notification based on setups
1832: PV_BENFT_STATUS_CHANGE.status_change_raise(
1833: p_api_version_number => p_api_version,
1834: p_init_msg_list => FND_API.g_false,
1835: p_commit => FND_API.g_false,
1836: p_validation_level => p_validation_level,
1837: p_event_name => l_event_name,
1838: p_benefit_id => l_benefit_id,
1839: p_entity_id => p_approval_rec.object_id,

Line 1853: IF l_return_status = FND_API.g_ret_sts_error THEN

1849: IF G_DEBUG THEN
1850: ozf_utility_pvt.debug_message( 'Raise Notification Event ' || x_return_status );
1851: END IF;
1852:
1853: IF l_return_status = FND_API.g_ret_sts_error THEN
1854: RAISE FND_API.g_exc_error;
1855: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1856: RAISE FND_API.g_exc_unexpected_error;
1857: END IF;

Line 1854: RAISE FND_API.g_exc_error;

1850: ozf_utility_pvt.debug_message( 'Raise Notification Event ' || x_return_status );
1851: END IF;
1852:
1853: IF l_return_status = FND_API.g_ret_sts_error THEN
1854: RAISE FND_API.g_exc_error;
1855: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1856: RAISE FND_API.g_exc_unexpected_error;
1857: END IF;
1858:

Line 1855: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1851: END IF;
1852:
1853: IF l_return_status = FND_API.g_ret_sts_error THEN
1854: RAISE FND_API.g_exc_error;
1855: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1856: RAISE FND_API.g_exc_unexpected_error;
1857: END IF;
1858:
1859: */

Line 1856: RAISE FND_API.g_exc_unexpected_error;

1852:
1853: IF l_return_status = FND_API.g_ret_sts_error THEN
1854: RAISE FND_API.g_exc_error;
1855: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1856: RAISE FND_API.g_exc_unexpected_error;
1857: END IF;
1858:
1859: */
1860: --Standard check of commit

Line 1861: IF FND_API.To_Boolean ( p_commit ) THEN

1857: END IF;
1858:
1859: */
1860: --Standard check of commit
1861: IF FND_API.To_Boolean ( p_commit ) THEN
1862: COMMIT WORK;
1863: END IF;
1864:
1865: x_final_approval_flag := l_final_approval_flag;

Line 1872: p_encoded => FND_API.G_FALSE,

1868: ozf_utility_pvt.debug_message( l_api_name||': End');
1869: END IF;
1870: --Standard call to get message count and if count=1, get the message
1871: FND_MSG_PUB.Count_And_Get (
1872: p_encoded => FND_API.G_FALSE,
1873: p_count => x_msg_count,
1874: p_data => x_msg_data
1875: );
1876:

Line 1878: WHEN FND_API.G_EXC_ERROR THEN

1874: p_data => x_msg_data
1875: );
1876:
1877: EXCEPTION
1878: WHEN FND_API.G_EXC_ERROR THEN
1879: ROLLBACK TO Process_User_Action_PVT;
1880: x_return_status := FND_API.G_RET_STS_ERROR;
1881: -- Standard call to get message count and if count=1, get the message
1882: FND_MSG_PUB.Count_And_Get (

Line 1880: x_return_status := FND_API.G_RET_STS_ERROR;

1876:
1877: EXCEPTION
1878: WHEN FND_API.G_EXC_ERROR THEN
1879: ROLLBACK TO Process_User_Action_PVT;
1880: x_return_status := FND_API.G_RET_STS_ERROR;
1881: -- Standard call to get message count and if count=1, get the message
1882: FND_MSG_PUB.Count_And_Get (
1883: p_encoded => FND_API.G_FALSE,
1884: p_count => x_msg_count,

Line 1883: p_encoded => FND_API.G_FALSE,

1879: ROLLBACK TO Process_User_Action_PVT;
1880: x_return_status := FND_API.G_RET_STS_ERROR;
1881: -- Standard call to get message count and if count=1, get the message
1882: FND_MSG_PUB.Count_And_Get (
1883: p_encoded => FND_API.G_FALSE,
1884: p_count => x_msg_count,
1885: p_data => x_msg_data
1886: );
1887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1883: p_encoded => FND_API.G_FALSE,
1884: p_count => x_msg_count,
1885: p_data => x_msg_data
1886: );
1887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1888: ROLLBACK TO Process_User_Action_PVT;
1889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1890: -- Standard call to get message count and if count=1, get the message
1891: FND_MSG_PUB.Count_And_Get (

Line 1889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1885: p_data => x_msg_data
1886: );
1887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1888: ROLLBACK TO Process_User_Action_PVT;
1889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1890: -- Standard call to get message count and if count=1, get the message
1891: FND_MSG_PUB.Count_And_Get (
1892: p_encoded => FND_API.G_FALSE,
1893: p_count => x_msg_count,

Line 1892: p_encoded => FND_API.G_FALSE,

1888: ROLLBACK TO Process_User_Action_PVT;
1889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1890: -- Standard call to get message count and if count=1, get the message
1891: FND_MSG_PUB.Count_And_Get (
1892: p_encoded => FND_API.G_FALSE,
1893: p_count => x_msg_count,
1894: p_data => x_msg_data
1895: );
1896: WHEN OTHERS THEN

Line 1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1894: p_data => x_msg_data
1895: );
1896: WHEN OTHERS THEN
1897: ROLLBACK TO Process_User_Action_PVT;
1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1899: IF OZF_UNEXP_ERROR_ON
1900: THEN
1901: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1902: END IF;

Line 1905: p_encoded => FND_API.G_FALSE,

1901: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1902: END IF;
1903: -- Standard call to get message count and if count=1, get the message
1904: FND_MSG_PUB.Count_And_Get (
1905: p_encoded => FND_API.G_FALSE,
1906: p_count => x_msg_count,
1907: p_data => x_msg_data
1908: );
1909: --

Line 1948: p_init_msg_list => FND_API.G_FALSE,

1944: l_approver_id := 1000196;
1945:
1946: OZF_APPROVAL_PVT.Process_User_Action (
1947: p_api_version => 1.0,
1948: p_init_msg_list => FND_API.G_FALSE,
1949: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1950: x_return_status => l_return_status,
1951: x_msg_count => l_msg_count,
1952: x_msg_data => l_msg_data,

Line 1949: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1945:
1946: OZF_APPROVAL_PVT.Process_User_Action (
1947: p_api_version => 1.0,
1948: p_init_msg_list => FND_API.G_FALSE,
1949: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1950: x_return_status => l_return_status,
1951: x_msg_count => l_msg_count,
1952: x_msg_data => l_msg_data,
1953: p_approval_rec => l_approval_rec,

Line 1992: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1988: -- NOTES
1989: ---------------------------------------------------------------------
1990: PROCEDURE Process_SD_Approval (
1991: p_api_version IN NUMBER
1992: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1993: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1994: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1995: ,p_object_id IN NUMBER
1996: ,p_action_code IN VARCHAR2

Line 1993: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1989: ---------------------------------------------------------------------
1990: PROCEDURE Process_SD_Approval (
1991: p_api_version IN NUMBER
1992: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1993: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1994: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1995: ,p_object_id IN NUMBER
1996: ,p_action_code IN VARCHAR2
1997: ,x_return_status OUT NOCOPY VARCHAR2

Line 1994: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

1990: PROCEDURE Process_SD_Approval (
1991: p_api_version IN NUMBER
1992: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1993: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1994: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1995: ,p_object_id IN NUMBER
1996: ,p_action_code IN VARCHAR2
1997: ,x_return_status OUT NOCOPY VARCHAR2
1998: ,x_msg_count OUT NOCOPY NUMBER

Line 2005: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

2001: IS
2002: l_api_name CONSTANT VARCHAR2(80) := 'Process_SD_Approval';
2003: l_api_version CONSTANT NUMBER := 1.0;
2004: l_event_key VARCHAR2(240);
2005: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2006: l_approvers_tbl ame_util.approversTable2;
2007: l_approval_completeYN VARCHAR2(20) := ame_util.booleanFalse;
2008: l_orig_system_id NUMBER;
2009: l_orig_system VARCHAR2(30);

Line 2048: IF NOT FND_API.Compatible_API_Call (

2044: BEGIN
2045: -- Standard begin of API savepoint
2046: SAVEPOINT Process_SD_Approval;
2047: -- Standard call to check for call compatibility.
2048: IF NOT FND_API.Compatible_API_Call (
2049: l_api_version,
2050: p_api_version,
2051: l_api_name,
2052: G_PKG_NAME)

Line 2054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2050: p_api_version,
2051: l_api_name,
2052: G_PKG_NAME)
2053: THEN
2054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2055: END IF;
2056: -- Debug Message
2057: IF G_DEBUG THEN
2058: ozf_utility_pvt.debug_message( l_api_name||': Start');

Line 2061: IF FND_API.To_Boolean (p_init_msg_list) THEN

2057: IF G_DEBUG THEN
2058: ozf_utility_pvt.debug_message( l_api_name||': Start');
2059: END IF;
2060: --Initialize message list if p_init_msg_list is TRUE.
2061: IF FND_API.To_Boolean (p_init_msg_list) THEN
2062: FND_MSG_PUB.initialize;
2063: END IF;
2064: -- Initialize API return status to sucess
2065: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2065: x_return_status := FND_API.G_RET_STS_SUCCESS;

2061: IF FND_API.To_Boolean (p_init_msg_list) THEN
2062: FND_MSG_PUB.initialize;
2063: END IF;
2064: -- Initialize API return status to sucess
2065: x_return_status := FND_API.G_RET_STS_SUCCESS;
2066: -- If action code is SUBMIT get the approver list from AME setup
2067: -- and populate OZF_SD_REQUEST_ACCESS table
2068: IF (p_action_code = 'SUBMIT') THEN
2069: IF G_DEBUG THEN

Line 2133: IF l_return_status = FND_API.g_ret_sts_error THEN

2129: ,p_approver_flag => l_approver_flag
2130: ,x_return_status => l_return_status
2131: ,x_msg_data => x_msg_data
2132: ,x_msg_count => x_msg_count);
2133: IF l_return_status = FND_API.g_ret_sts_error THEN
2134: RAISE FND_API.g_exc_error;
2135: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2136: RAISE FND_API.g_exc_unexpected_error;
2137: END IF;

Line 2134: RAISE FND_API.g_exc_error;

2130: ,x_return_status => l_return_status
2131: ,x_msg_data => x_msg_data
2132: ,x_msg_count => x_msg_count);
2133: IF l_return_status = FND_API.g_ret_sts_error THEN
2134: RAISE FND_API.g_exc_error;
2135: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2136: RAISE FND_API.g_exc_unexpected_error;
2137: END IF;
2138: END IF;

Line 2135: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2131: ,x_msg_data => x_msg_data
2132: ,x_msg_count => x_msg_count);
2133: IF l_return_status = FND_API.g_ret_sts_error THEN
2134: RAISE FND_API.g_exc_error;
2135: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2136: RAISE FND_API.g_exc_unexpected_error;
2137: END IF;
2138: END IF;
2139: -- Reset the variable value to 'Y'

Line 2136: RAISE FND_API.g_exc_unexpected_error;

2132: ,x_msg_count => x_msg_count);
2133: IF l_return_status = FND_API.g_ret_sts_error THEN
2134: RAISE FND_API.g_exc_error;
2135: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2136: RAISE FND_API.g_exc_unexpected_error;
2137: END IF;
2138: END IF;
2139: -- Reset the variable value to 'Y'
2140: l_insert_mode := 'N';

Line 2185: IF l_return_status = FND_API.g_ret_sts_error THEN

2181: ,p_approver_flag => l_approver_flag
2182: ,x_return_status => l_return_status
2183: ,x_msg_data => x_msg_data
2184: ,x_msg_count => x_msg_count);
2185: IF l_return_status = FND_API.g_ret_sts_error THEN
2186: RAISE FND_API.g_exc_error;
2187: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2188: RAISE FND_API.g_exc_unexpected_error;
2189: END IF;

Line 2186: RAISE FND_API.g_exc_error;

2182: ,x_return_status => l_return_status
2183: ,x_msg_data => x_msg_data
2184: ,x_msg_count => x_msg_count);
2185: IF l_return_status = FND_API.g_ret_sts_error THEN
2186: RAISE FND_API.g_exc_error;
2187: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2188: RAISE FND_API.g_exc_unexpected_error;
2189: END IF;
2190: END IF;

Line 2187: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2183: ,x_msg_data => x_msg_data
2184: ,x_msg_count => x_msg_count);
2185: IF l_return_status = FND_API.g_ret_sts_error THEN
2186: RAISE FND_API.g_exc_error;
2187: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2188: RAISE FND_API.g_exc_unexpected_error;
2189: END IF;
2190: END IF;
2191: IF G_DEBUG THEN

Line 2188: RAISE FND_API.g_exc_unexpected_error;

2184: ,x_msg_count => x_msg_count);
2185: IF l_return_status = FND_API.g_ret_sts_error THEN
2186: RAISE FND_API.g_exc_error;
2187: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2188: RAISE FND_API.g_exc_unexpected_error;
2189: END IF;
2190: END IF;
2191: IF G_DEBUG THEN
2192: ozf_utility_pvt.debug_message('Add_SD_Access is ended for default approver: '||x_return_status);

Line 2207: IF FND_API.To_Boolean ( p_commit ) THEN

2203: ,x_msg_data => x_msg_data
2204: ,x_msg_count => x_msg_count);
2205:
2206: --Standard check of commit
2207: IF FND_API.To_Boolean ( p_commit ) THEN
2208: COMMIT WORK;
2209: END IF;
2210: -- Debug Message
2211: IF G_DEBUG THEN

Line 2216: p_encoded => FND_API.G_FALSE,

2212: ozf_utility_pvt.debug_message( l_api_name||': End');
2213: END IF;
2214: --Standard call to get message count and if count=1, get the message
2215: FND_MSG_PUB.Count_And_Get (
2216: p_encoded => FND_API.G_FALSE,
2217: p_count => x_msg_count,
2218: p_data => x_msg_data
2219: );
2220:

Line 2222: WHEN FND_API.G_EXC_ERROR THEN

2218: p_data => x_msg_data
2219: );
2220:
2221: EXCEPTION
2222: WHEN FND_API.G_EXC_ERROR THEN
2223: ROLLBACK TO Process_SD_Approval;
2224: x_return_status := FND_API.G_RET_STS_ERROR;
2225: -- Standard call to get message count and if count=1, get the message
2226: FND_MSG_PUB.Count_And_Get (

Line 2224: x_return_status := FND_API.G_RET_STS_ERROR;

2220:
2221: EXCEPTION
2222: WHEN FND_API.G_EXC_ERROR THEN
2223: ROLLBACK TO Process_SD_Approval;
2224: x_return_status := FND_API.G_RET_STS_ERROR;
2225: -- Standard call to get message count and if count=1, get the message
2226: FND_MSG_PUB.Count_And_Get (
2227: p_encoded => FND_API.G_FALSE,
2228: p_count => x_msg_count,

Line 2227: p_encoded => FND_API.G_FALSE,

2223: ROLLBACK TO Process_SD_Approval;
2224: x_return_status := FND_API.G_RET_STS_ERROR;
2225: -- Standard call to get message count and if count=1, get the message
2226: FND_MSG_PUB.Count_And_Get (
2227: p_encoded => FND_API.G_FALSE,
2228: p_count => x_msg_count,
2229: p_data => x_msg_data
2230: );
2231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2227: p_encoded => FND_API.G_FALSE,
2228: p_count => x_msg_count,
2229: p_data => x_msg_data
2230: );
2231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2232: ROLLBACK TO Process_SD_Approval;
2233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2234: -- Standard call to get message count and if count=1, get the message
2235: FND_MSG_PUB.Count_And_Get (

Line 2233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2229: p_data => x_msg_data
2230: );
2231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2232: ROLLBACK TO Process_SD_Approval;
2233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2234: -- Standard call to get message count and if count=1, get the message
2235: FND_MSG_PUB.Count_And_Get (
2236: p_encoded => FND_API.G_FALSE,
2237: p_count => x_msg_count,

Line 2236: p_encoded => FND_API.G_FALSE,

2232: ROLLBACK TO Process_SD_Approval;
2233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2234: -- Standard call to get message count and if count=1, get the message
2235: FND_MSG_PUB.Count_And_Get (
2236: p_encoded => FND_API.G_FALSE,
2237: p_count => x_msg_count,
2238: p_data => x_msg_data
2239: );
2240: WHEN OTHERS THEN

Line 2242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2238: p_data => x_msg_data
2239: );
2240: WHEN OTHERS THEN
2241: ROLLBACK TO Process_SD_Approval;
2242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2243: IF OZF_UNEXP_ERROR_ON
2244: THEN
2245: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2246: END IF;

Line 2249: p_encoded => FND_API.G_FALSE,

2245: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2246: END IF;
2247: -- Standard call to get message count and if count=1, get the message
2248: FND_MSG_PUB.Count_And_Get (
2249: p_encoded => FND_API.G_FALSE,
2250: p_count => x_msg_count,
2251: p_data => x_msg_data
2252: );
2253: --

Line 2271: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2267: -- NOTES
2268: ---------------------------------------------------------------------
2269: PROCEDURE Get_All_Approvers(
2270: p_api_version IN NUMBER
2271: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2272: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2273: ,p_transaction_id IN VARCHAR2
2274: ,p_transaction_type_key IN VARCHAR2
2275: ,x_approvers OUT NOCOPY ame_util.approversTable2

Line 2272: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

2268: ---------------------------------------------------------------------
2269: PROCEDURE Get_All_Approvers(
2270: p_api_version IN NUMBER
2271: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2272: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2273: ,p_transaction_id IN VARCHAR2
2274: ,p_transaction_type_key IN VARCHAR2
2275: ,x_approvers OUT NOCOPY ame_util.approversTable2
2276: ,x_approval_flag OUT NOCOPY VARCHAR2

Line 2292: IF NOT FND_API.Compatible_API_Call (

2288:
2289: -- Standard begin of API savepoint
2290: SAVEPOINT Get_All_Approvers;
2291: -- Standard call to check for call compatibility.
2292: IF NOT FND_API.Compatible_API_Call (
2293: l_api_version,
2294: p_api_version,
2295: l_api_name,
2296: G_PKG_NAME)

Line 2298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2294: p_api_version,
2295: l_api_name,
2296: G_PKG_NAME)
2297: THEN
2298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2299: END IF;
2300: -- Debug Message
2301: IF G_DEBUG THEN
2302: ozf_utility_pvt.debug_message( l_api_name||': Start');

Line 2305: IF FND_API.To_Boolean (p_init_msg_list) THEN

2301: IF G_DEBUG THEN
2302: ozf_utility_pvt.debug_message( l_api_name||': Start');
2303: END IF;
2304: --Initialize message list if p_init_msg_list is TRUE.
2305: IF FND_API.To_Boolean (p_init_msg_list) THEN
2306: FND_MSG_PUB.initialize;
2307: END IF;
2308: -- Initialize API return status to sucess
2309: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2309: x_return_status := FND_API.G_RET_STS_SUCCESS;

2305: IF FND_API.To_Boolean (p_init_msg_list) THEN
2306: FND_MSG_PUB.initialize;
2307: END IF;
2308: -- Initialize API return status to sucess
2309: x_return_status := FND_API.G_RET_STS_SUCCESS;
2310: ame_api2.getAllApprovers7
2311: (applicationIdIn => l_application_id
2312: ,transactionTypeIn => p_transaction_type_key
2313: ,transactionIdIn => p_transaction_id

Line 2320: p_encoded => FND_API.G_FALSE,

2316:
2317: -- Debug Message
2318: --Standard call to get message count and if count=1, get the message
2319: FND_MSG_PUB.Count_And_Get (
2320: p_encoded => FND_API.G_FALSE,
2321: p_count => x_msg_count,
2322: p_data => x_msg_data
2323: );
2324: EXCEPTION

Line 2325: WHEN FND_API.G_EXC_ERROR THEN

2321: p_count => x_msg_count,
2322: p_data => x_msg_data
2323: );
2324: EXCEPTION
2325: WHEN FND_API.G_EXC_ERROR THEN
2326: ROLLBACK TO Get_All_Approvers;
2327: x_return_status := FND_API.G_RET_STS_ERROR;
2328: -- Standard call to get message count and if count=1, get the message
2329: FND_MSG_PUB.Count_And_Get (

Line 2327: x_return_status := FND_API.G_RET_STS_ERROR;

2323: );
2324: EXCEPTION
2325: WHEN FND_API.G_EXC_ERROR THEN
2326: ROLLBACK TO Get_All_Approvers;
2327: x_return_status := FND_API.G_RET_STS_ERROR;
2328: -- Standard call to get message count and if count=1, get the message
2329: FND_MSG_PUB.Count_And_Get (
2330: p_encoded => FND_API.G_FALSE,
2331: p_count => x_msg_count,

Line 2330: p_encoded => FND_API.G_FALSE,

2326: ROLLBACK TO Get_All_Approvers;
2327: x_return_status := FND_API.G_RET_STS_ERROR;
2328: -- Standard call to get message count and if count=1, get the message
2329: FND_MSG_PUB.Count_And_Get (
2330: p_encoded => FND_API.G_FALSE,
2331: p_count => x_msg_count,
2332: p_data => x_msg_data
2333: );
2334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2330: p_encoded => FND_API.G_FALSE,
2331: p_count => x_msg_count,
2332: p_data => x_msg_data
2333: );
2334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2335: ROLLBACK TO Get_All_Approvers;
2336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2337: -- Standard call to get message count and if count=1, get the message
2338: FND_MSG_PUB.Count_And_Get (

Line 2336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2332: p_data => x_msg_data
2333: );
2334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2335: ROLLBACK TO Get_All_Approvers;
2336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2337: -- Standard call to get message count and if count=1, get the message
2338: FND_MSG_PUB.Count_And_Get (
2339: p_encoded => FND_API.G_FALSE,
2340: p_count => x_msg_count,

Line 2339: p_encoded => FND_API.G_FALSE,

2335: ROLLBACK TO Get_All_Approvers;
2336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2337: -- Standard call to get message count and if count=1, get the message
2338: FND_MSG_PUB.Count_And_Get (
2339: p_encoded => FND_API.G_FALSE,
2340: p_count => x_msg_count,
2341: p_data => x_msg_data
2342: );
2343: WHEN OTHERS THEN

Line 2345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2341: p_data => x_msg_data
2342: );
2343: WHEN OTHERS THEN
2344: ROLLBACK TO Get_All_Approvers;
2345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2346: IF OZF_UNEXP_ERROR_ON
2347: THEN
2348: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2349: END IF;

Line 2352: p_encoded => FND_API.G_FALSE,

2348: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2349: END IF;
2350: -- Standard call to get message count and if count=1, get the message
2351: FND_MSG_PUB.Count_And_Get (
2352: p_encoded => FND_API.G_FALSE,
2353: p_count => x_msg_count,
2354: p_data => x_msg_data
2355: );
2356: --

Line 2375: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2371: -- NOTES
2372: ---------------------------------------------------------------------
2373: PROCEDURE Add_SD_Access(
2374: p_api_version IN NUMBER
2375: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2376: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2377: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2378: ,p_request_header_id IN NUMBER
2379: ,p_user_id IN NUMBER

Line 2376: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

2372: ---------------------------------------------------------------------
2373: PROCEDURE Add_SD_Access(
2374: p_api_version IN NUMBER
2375: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2376: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2377: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2378: ,p_request_header_id IN NUMBER
2379: ,p_user_id IN NUMBER
2380: ,p_resource_id IN NUMBER

Line 2377: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

2373: PROCEDURE Add_SD_Access(
2374: p_api_version IN NUMBER
2375: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2376: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2377: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2378: ,p_request_header_id IN NUMBER
2379: ,p_user_id IN NUMBER
2380: ,p_resource_id IN NUMBER
2381: ,p_person_id IN NUMBER DEFAULT NULL

Line 2416: IF NOT FND_API.Compatible_API_Call (

2412: BEGIN
2413: -- Standard begin of API savepoint
2414: SAVEPOINT Add_SD_Access1;
2415: -- Standard call to check for call compatibility.
2416: IF NOT FND_API.Compatible_API_Call (
2417: l_api_version,
2418: p_api_version,
2419: l_api_name,
2420: G_PKG_NAME)

Line 2422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2418: p_api_version,
2419: l_api_name,
2420: G_PKG_NAME)
2421: THEN
2422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2423: END IF;
2424: -- Debug Message
2425: IF G_DEBUG THEN
2426: ozf_utility_pvt.debug_message( l_api_name||': Start');

Line 2429: IF FND_API.To_Boolean (p_init_msg_list) THEN

2425: IF G_DEBUG THEN
2426: ozf_utility_pvt.debug_message( l_api_name||': Start');
2427: END IF;
2428: --Initialize message list if p_init_msg_list is TRUE.
2429: IF FND_API.To_Boolean (p_init_msg_list) THEN
2430: FND_MSG_PUB.initialize;
2431: END IF;
2432: -- Initialize API return status to sucess
2433: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2433: x_return_status := FND_API.G_RET_STS_SUCCESS;

2429: IF FND_API.To_Boolean (p_init_msg_list) THEN
2430: FND_MSG_PUB.initialize;
2431: END IF;
2432: -- Initialize API return status to sucess
2433: x_return_status := FND_API.G_RET_STS_SUCCESS;
2434:
2435: -- do required validation
2436: -- If request_header_id is null
2437: -- If both user_id and resource_id are null

Line 2443: x_return_status := FND_API.g_ret_sts_error;

2439: -- Set the appropriate return status and raise an exception
2440: IF (p_request_header_id IS NULL) THEN
2441: IF OZF_ERROR_ON THEN
2442: ozf_utility_pvt.error_message('OZF_SD_REQUEST_HEADER_ID_NULL');
2443: x_return_status := FND_API.g_ret_sts_error;
2444: RAISE FND_API.G_EXC_ERROR;
2445: END IF;
2446: END IF;
2447:

Line 2444: RAISE FND_API.G_EXC_ERROR;

2440: IF (p_request_header_id IS NULL) THEN
2441: IF OZF_ERROR_ON THEN
2442: ozf_utility_pvt.error_message('OZF_SD_REQUEST_HEADER_ID_NULL');
2443: x_return_status := FND_API.g_ret_sts_error;
2444: RAISE FND_API.G_EXC_ERROR;
2445: END IF;
2446: END IF;
2447:
2448: IF (p_user_id IS NULL AND p_resource_id IS NULL) THEN

Line 2451: x_return_status := FND_API.g_ret_sts_error;

2447:
2448: IF (p_user_id IS NULL AND p_resource_id IS NULL) THEN
2449: IF OZF_ERROR_ON THEN
2450: ozf_utility_pvt.error_message('OZF_SD_USER_RESOURCE_ID_NULL');
2451: x_return_status := FND_API.g_ret_sts_error;
2452: RAISE FND_API.G_EXC_ERROR;
2453: END IF;
2454: END IF;
2455:

Line 2452: RAISE FND_API.G_EXC_ERROR;

2448: IF (p_user_id IS NULL AND p_resource_id IS NULL) THEN
2449: IF OZF_ERROR_ON THEN
2450: ozf_utility_pvt.error_message('OZF_SD_USER_RESOURCE_ID_NULL');
2451: x_return_status := FND_API.g_ret_sts_error;
2452: RAISE FND_API.G_EXC_ERROR;
2453: END IF;
2454: END IF;
2455:
2456: IF (p_owner_flag IS NULL AND p_approver_flag IS NULL) THEN

Line 2459: x_return_status := FND_API.g_ret_sts_error;

2455:
2456: IF (p_owner_flag IS NULL AND p_approver_flag IS NULL) THEN
2457: IF OZF_ERROR_ON THEN
2458: ozf_utility_pvt.error_message('OZF_SD_OWNER_APPROVER_NULL');
2459: x_return_status := FND_API.g_ret_sts_error;
2460: RAISE FND_API.G_EXC_ERROR;
2461: END IF;
2462: END IF;
2463:

Line 2460: RAISE FND_API.G_EXC_ERROR;

2456: IF (p_owner_flag IS NULL AND p_approver_flag IS NULL) THEN
2457: IF OZF_ERROR_ON THEN
2458: ozf_utility_pvt.error_message('OZF_SD_OWNER_APPROVER_NULL');
2459: x_return_status := FND_API.g_ret_sts_error;
2460: RAISE FND_API.G_EXC_ERROR;
2461: END IF;
2462: END IF;
2463:
2464: -- Get user_id or resource_id for Admin's action i.e. change of owner/assignee

Line 2494: x_return_status := FND_API.g_ret_sts_error;

2490:
2491: IF (l_access_rec.USER_ID IS NULL OR l_access_rec.RESOURCE_ID IS NULL) THEN
2492: IF OZF_ERROR_ON THEN
2493: ozf_utility_pvt.error_message('OZF_SD_USER_IS_NOT_RESOURCE');
2494: x_return_status := FND_API.g_ret_sts_error;
2495: RAISE FND_API.G_EXC_ERROR;
2496: END IF;
2497: END IF;
2498:

Line 2495: RAISE FND_API.G_EXC_ERROR;

2491: IF (l_access_rec.USER_ID IS NULL OR l_access_rec.RESOURCE_ID IS NULL) THEN
2492: IF OZF_ERROR_ON THEN
2493: ozf_utility_pvt.error_message('OZF_SD_USER_IS_NOT_RESOURCE');
2494: x_return_status := FND_API.g_ret_sts_error;
2495: RAISE FND_API.G_EXC_ERROR;
2496: END IF;
2497: END IF;
2498:
2499:

Line 2524: IF x_return_status = FND_API.g_ret_sts_error THEN

2520: ,p_access_rec => l_access_rec
2521: ,x_return_status => x_return_status
2522: ,x_msg_data => x_msg_data
2523: ,x_msg_count => x_msg_count);
2524: IF x_return_status = FND_API.g_ret_sts_error THEN
2525: RAISE FND_API.g_exc_error;
2526: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2527: RAISE FND_API.g_exc_unexpected_error;
2528: END IF;

Line 2525: RAISE FND_API.g_exc_error;

2521: ,x_return_status => x_return_status
2522: ,x_msg_data => x_msg_data
2523: ,x_msg_count => x_msg_count);
2524: IF x_return_status = FND_API.g_ret_sts_error THEN
2525: RAISE FND_API.g_exc_error;
2526: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2527: RAISE FND_API.g_exc_unexpected_error;
2528: END IF;
2529: -- Debug Message

Line 2526: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

2522: ,x_msg_data => x_msg_data
2523: ,x_msg_count => x_msg_count);
2524: IF x_return_status = FND_API.g_ret_sts_error THEN
2525: RAISE FND_API.g_exc_error;
2526: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2527: RAISE FND_API.g_exc_unexpected_error;
2528: END IF;
2529: -- Debug Message
2530: IF G_DEBUG THEN

Line 2527: RAISE FND_API.g_exc_unexpected_error;

2523: ,x_msg_count => x_msg_count);
2524: IF x_return_status = FND_API.g_ret_sts_error THEN
2525: RAISE FND_API.g_exc_error;
2526: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2527: RAISE FND_API.g_exc_unexpected_error;
2528: END IF;
2529: -- Debug Message
2530: IF G_DEBUG THEN
2531: ozf_utility_pvt.debug_message( l_api_name||': End');

Line 2535: p_encoded => FND_API.G_FALSE,

2531: ozf_utility_pvt.debug_message( l_api_name||': End');
2532: END IF;
2533: --Standard call to get message count and if count=1, get the message
2534: FND_MSG_PUB.Count_And_Get (
2535: p_encoded => FND_API.G_FALSE,
2536: p_count => x_msg_count,
2537: p_data => x_msg_data
2538: );
2539: EXCEPTION

Line 2540: WHEN FND_API.G_EXC_ERROR THEN

2536: p_count => x_msg_count,
2537: p_data => x_msg_data
2538: );
2539: EXCEPTION
2540: WHEN FND_API.G_EXC_ERROR THEN
2541: ROLLBACK TO Add_SD_Access1;
2542: x_return_status := FND_API.G_RET_STS_ERROR;
2543: -- Standard call to get message count and if count=1, get the message
2544: FND_MSG_PUB.Count_And_Get (

Line 2542: x_return_status := FND_API.G_RET_STS_ERROR;

2538: );
2539: EXCEPTION
2540: WHEN FND_API.G_EXC_ERROR THEN
2541: ROLLBACK TO Add_SD_Access1;
2542: x_return_status := FND_API.G_RET_STS_ERROR;
2543: -- Standard call to get message count and if count=1, get the message
2544: FND_MSG_PUB.Count_And_Get (
2545: p_encoded => FND_API.G_FALSE,
2546: p_count => x_msg_count,

Line 2545: p_encoded => FND_API.G_FALSE,

2541: ROLLBACK TO Add_SD_Access1;
2542: x_return_status := FND_API.G_RET_STS_ERROR;
2543: -- Standard call to get message count and if count=1, get the message
2544: FND_MSG_PUB.Count_And_Get (
2545: p_encoded => FND_API.G_FALSE,
2546: p_count => x_msg_count,
2547: p_data => x_msg_data
2548: );
2549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2545: p_encoded => FND_API.G_FALSE,
2546: p_count => x_msg_count,
2547: p_data => x_msg_data
2548: );
2549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2550: ROLLBACK TO Add_SD_Access1;
2551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2552: -- Standard call to get message count and if count=1, get the message
2553: FND_MSG_PUB.Count_And_Get (

Line 2551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2547: p_data => x_msg_data
2548: );
2549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2550: ROLLBACK TO Add_SD_Access1;
2551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2552: -- Standard call to get message count and if count=1, get the message
2553: FND_MSG_PUB.Count_And_Get (
2554: p_encoded => FND_API.G_FALSE,
2555: p_count => x_msg_count,

Line 2554: p_encoded => FND_API.G_FALSE,

2550: ROLLBACK TO Add_SD_Access1;
2551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2552: -- Standard call to get message count and if count=1, get the message
2553: FND_MSG_PUB.Count_And_Get (
2554: p_encoded => FND_API.G_FALSE,
2555: p_count => x_msg_count,
2556: p_data => x_msg_data
2557: );
2558: WHEN OTHERS THEN

Line 2560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2556: p_data => x_msg_data
2557: );
2558: WHEN OTHERS THEN
2559: ROLLBACK TO Add_SD_Access1;
2560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2561: IF OZF_UNEXP_ERROR_ON
2562: THEN
2563: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2564: END IF;

Line 2567: p_encoded => FND_API.G_FALSE,

2563: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2564: END IF;
2565: -- Standard call to get message count and if count=1, get the message
2566: FND_MSG_PUB.Count_And_Get (
2567: p_encoded => FND_API.G_FALSE,
2568: p_count => x_msg_count,
2569: p_data => x_msg_data
2570: );
2571: --

Line 2590: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2586: -- NOTES
2587: ---------------------------------------------------------------------
2588: PROCEDURE Add_SD_Access(
2589: p_api_version IN NUMBER
2590: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2591: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2592: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2593: ,p_access_rec IN sd_access_rec_type
2594: ,x_return_status OUT NOCOPY VARCHAR2

Line 2591: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

2587: ---------------------------------------------------------------------
2588: PROCEDURE Add_SD_Access(
2589: p_api_version IN NUMBER
2590: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2591: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2592: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2593: ,p_access_rec IN sd_access_rec_type
2594: ,x_return_status OUT NOCOPY VARCHAR2
2595: ,x_msg_count OUT NOCOPY NUMBER

Line 2592: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

2588: PROCEDURE Add_SD_Access(
2589: p_api_version IN NUMBER
2590: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2591: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2592: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2593: ,p_access_rec IN sd_access_rec_type
2594: ,x_return_status OUT NOCOPY VARCHAR2
2595: ,x_msg_count OUT NOCOPY NUMBER
2596: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2633: IF NOT FND_API.Compatible_API_Call (

2629: BEGIN
2630: -- Standard begin of API savepoint
2631: SAVEPOINT Add_SD_Access2;
2632: -- Standard call to check for call compatibility.
2633: IF NOT FND_API.Compatible_API_Call (
2634: l_api_version,
2635: p_api_version,
2636: l_api_name,
2637: G_PKG_NAME)

Line 2639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2635: p_api_version,
2636: l_api_name,
2637: G_PKG_NAME)
2638: THEN
2639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2640: END IF;
2641: -- Debug Message
2642: IF G_DEBUG THEN
2643: ozf_utility_pvt.debug_message( l_api_name||': Start');

Line 2646: IF FND_API.To_Boolean (p_init_msg_list) THEN

2642: IF G_DEBUG THEN
2643: ozf_utility_pvt.debug_message( l_api_name||': Start');
2644: END IF;
2645: --Initialize message list if p_init_msg_list is TRUE.
2646: IF FND_API.To_Boolean (p_init_msg_list) THEN
2647: FND_MSG_PUB.initialize;
2648: END IF;
2649:
2650: -- Initialize API return status to sucess

Line 2651: x_return_status := FND_API.G_RET_STS_SUCCESS;

2647: FND_MSG_PUB.initialize;
2648: END IF;
2649:
2650: -- Initialize API return status to sucess
2651: x_return_status := FND_API.G_RET_STS_SUCCESS;
2652:
2653: -- check for approver record
2654: IF (p_access_rec.APPROVER_FLAG = 'Y') THEN
2655: OPEN CSR_EXISTING_OWNER_APPROVER (p_access_rec.REQUEST_HEADER_ID, p_access_rec.RESOURCE_ID);

Line 2782: x_return_status := FND_API.g_ret_sts_error;

2778: EXCEPTION
2779: WHEN OTHERS THEN
2780: IF OZF_ERROR_ON THEN
2781: ozf_utility_pvt.error_message('OZF_SD_REQ_ACCESS_INSERT_ERR');
2782: x_return_status := FND_API.g_ret_sts_error;
2783: RAISE FND_API.G_EXC_ERROR;
2784: END IF;
2785: END;
2786: END IF;

Line 2783: RAISE FND_API.G_EXC_ERROR;

2779: WHEN OTHERS THEN
2780: IF OZF_ERROR_ON THEN
2781: ozf_utility_pvt.error_message('OZF_SD_REQ_ACCESS_INSERT_ERR');
2782: x_return_status := FND_API.g_ret_sts_error;
2783: RAISE FND_API.G_EXC_ERROR;
2784: END IF;
2785: END;
2786: END IF;
2787: --Standard check of commit

Line 2788: IF FND_API.To_Boolean ( p_commit ) THEN

2784: END IF;
2785: END;
2786: END IF;
2787: --Standard check of commit
2788: IF FND_API.To_Boolean ( p_commit ) THEN
2789: COMMIT WORK;
2790: END IF;
2791: -- Debug Message
2792: IF G_DEBUG THEN

Line 2797: p_encoded => FND_API.G_FALSE,

2793: ozf_utility_pvt.debug_message( l_api_name||': End');
2794: END IF;
2795: --Standard call to get message count and if count=1, get the message
2796: FND_MSG_PUB.Count_And_Get (
2797: p_encoded => FND_API.G_FALSE,
2798: p_count => x_msg_count,
2799: p_data => x_msg_data
2800: );
2801: EXCEPTION

Line 2802: WHEN FND_API.G_EXC_ERROR THEN

2798: p_count => x_msg_count,
2799: p_data => x_msg_data
2800: );
2801: EXCEPTION
2802: WHEN FND_API.G_EXC_ERROR THEN
2803: ROLLBACK TO Add_SD_Access2;
2804: x_return_status := FND_API.G_RET_STS_ERROR;
2805: -- Standard call to get message count and if count=1, get the message
2806: FND_MSG_PUB.Count_And_Get (

Line 2804: x_return_status := FND_API.G_RET_STS_ERROR;

2800: );
2801: EXCEPTION
2802: WHEN FND_API.G_EXC_ERROR THEN
2803: ROLLBACK TO Add_SD_Access2;
2804: x_return_status := FND_API.G_RET_STS_ERROR;
2805: -- Standard call to get message count and if count=1, get the message
2806: FND_MSG_PUB.Count_And_Get (
2807: p_encoded => FND_API.G_FALSE,
2808: p_count => x_msg_count,

Line 2807: p_encoded => FND_API.G_FALSE,

2803: ROLLBACK TO Add_SD_Access2;
2804: x_return_status := FND_API.G_RET_STS_ERROR;
2805: -- Standard call to get message count and if count=1, get the message
2806: FND_MSG_PUB.Count_And_Get (
2807: p_encoded => FND_API.G_FALSE,
2808: p_count => x_msg_count,
2809: p_data => x_msg_data
2810: );
2811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2807: p_encoded => FND_API.G_FALSE,
2808: p_count => x_msg_count,
2809: p_data => x_msg_data
2810: );
2811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2812: ROLLBACK TO Add_SD_Access2;
2813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2814: -- Standard call to get message count and if count=1, get the message
2815: FND_MSG_PUB.Count_And_Get (

Line 2813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2809: p_data => x_msg_data
2810: );
2811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2812: ROLLBACK TO Add_SD_Access2;
2813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2814: -- Standard call to get message count and if count=1, get the message
2815: FND_MSG_PUB.Count_And_Get (
2816: p_encoded => FND_API.G_FALSE,
2817: p_count => x_msg_count,

Line 2816: p_encoded => FND_API.G_FALSE,

2812: ROLLBACK TO Add_SD_Access2;
2813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2814: -- Standard call to get message count and if count=1, get the message
2815: FND_MSG_PUB.Count_And_Get (
2816: p_encoded => FND_API.G_FALSE,
2817: p_count => x_msg_count,
2818: p_data => x_msg_data
2819: );
2820: WHEN OTHERS THEN

Line 2822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2818: p_data => x_msg_data
2819: );
2820: WHEN OTHERS THEN
2821: ROLLBACK TO Add_SD_Access2;
2822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2823: IF OZF_UNEXP_ERROR_ON
2824: THEN
2825: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2826: END IF;

Line 2829: p_encoded => FND_API.G_FALSE,

2825: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2826: END IF;
2827: -- Standard call to get message count and if count=1, get the message
2828: FND_MSG_PUB.Count_And_Get (
2829: p_encoded => FND_API.G_FALSE,
2830: p_count => x_msg_count,
2831: p_data => x_msg_data
2832: );
2833: --

Line 2873: x_return_status := FND_API.G_RET_STS_SUCCESS;

2869: IF G_DEBUG THEN
2870: ozf_utility_pvt.debug_message( l_api_name||': Start');
2871: END IF;
2872: -- Initialize API return status to sucess
2873: x_return_status := FND_API.G_RET_STS_SUCCESS;
2874:
2875: l_event := Check_Event(l_sd_event_name);
2876: IF l_event = 'NOTFOUND' THEN
2877: IF OZF_ERROR_ON THEN

Line 2880: x_return_status := FND_API.g_ret_sts_error;

2876: IF l_event = 'NOTFOUND' THEN
2877: IF OZF_ERROR_ON THEN
2878: ozf_utility_pvt.error_message('OZF_WF_EVENT_NAME_NULL', 'NAME', l_sd_event_name);
2879: END IF;
2880: x_return_status := FND_API.g_ret_sts_error;
2881: RAISE FND_API.G_EXC_ERROR;
2882: END IF;
2883:
2884: l_parameter_t.setName('OBJECT_ID');

Line 2881: RAISE FND_API.G_EXC_ERROR;

2877: IF OZF_ERROR_ON THEN
2878: ozf_utility_pvt.error_message('OZF_WF_EVENT_NAME_NULL', 'NAME', l_sd_event_name);
2879: END IF;
2880: x_return_status := FND_API.g_ret_sts_error;
2881: RAISE FND_API.G_EXC_ERROR;
2882: END IF;
2883:
2884: l_parameter_t.setName('OBJECT_ID');
2885: l_parameter_t.setValue(p_object_id);

Line 2907: p_encoded => FND_API.G_FALSE,

2903: ozf_utility_pvt.debug_message( l_api_name||': End');
2904: END IF;
2905: --Standard call to get message count and if count=1, get the message
2906: FND_MSG_PUB.Count_And_Get (
2907: p_encoded => FND_API.G_FALSE,
2908: p_count => x_msg_count,
2909: p_data => x_msg_data
2910: );
2911:

Line 2913: WHEN FND_API.G_EXC_ERROR THEN

2909: p_data => x_msg_data
2910: );
2911:
2912: EXCEPTION
2913: WHEN FND_API.G_EXC_ERROR THEN
2914: ROLLBACK TO Raise_SD_Event;
2915: x_return_status := FND_API.G_RET_STS_ERROR;
2916: -- Standard call to get message count and if count=1, get the message
2917: FND_MSG_PUB.Count_And_Get (

Line 2915: x_return_status := FND_API.G_RET_STS_ERROR;

2911:
2912: EXCEPTION
2913: WHEN FND_API.G_EXC_ERROR THEN
2914: ROLLBACK TO Raise_SD_Event;
2915: x_return_status := FND_API.G_RET_STS_ERROR;
2916: -- Standard call to get message count and if count=1, get the message
2917: FND_MSG_PUB.Count_And_Get (
2918: p_encoded => FND_API.G_FALSE,
2919: p_count => x_msg_count,

Line 2918: p_encoded => FND_API.G_FALSE,

2914: ROLLBACK TO Raise_SD_Event;
2915: x_return_status := FND_API.G_RET_STS_ERROR;
2916: -- Standard call to get message count and if count=1, get the message
2917: FND_MSG_PUB.Count_And_Get (
2918: p_encoded => FND_API.G_FALSE,
2919: p_count => x_msg_count,
2920: p_data => x_msg_data
2921: );
2922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2918: p_encoded => FND_API.G_FALSE,
2919: p_count => x_msg_count,
2920: p_data => x_msg_data
2921: );
2922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2923: ROLLBACK TO Raise_SD_Event;
2924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2925: -- Standard call to get message count and if count=1, get the message
2926: FND_MSG_PUB.Count_And_Get (

Line 2924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2920: p_data => x_msg_data
2921: );
2922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2923: ROLLBACK TO Raise_SD_Event;
2924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2925: -- Standard call to get message count and if count=1, get the message
2926: FND_MSG_PUB.Count_And_Get (
2927: p_encoded => FND_API.G_FALSE,
2928: p_count => x_msg_count,

Line 2927: p_encoded => FND_API.G_FALSE,

2923: ROLLBACK TO Raise_SD_Event;
2924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2925: -- Standard call to get message count and if count=1, get the message
2926: FND_MSG_PUB.Count_And_Get (
2927: p_encoded => FND_API.G_FALSE,
2928: p_count => x_msg_count,
2929: p_data => x_msg_data
2930: );
2931: WHEN OTHERS THEN

Line 2933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2929: p_data => x_msg_data
2930: );
2931: WHEN OTHERS THEN
2932: ROLLBACK TO Raise_SD_Event;
2933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2934: IF OZF_UNEXP_ERROR_ON
2935: THEN
2936: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2937: END IF;

Line 2940: p_encoded => FND_API.G_FALSE,

2936: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2937: END IF;
2938: -- Standard call to get message count and if count=1, get the message
2939: FND_MSG_PUB.Count_And_Get (
2940: p_encoded => FND_API.G_FALSE,
2941: p_count => x_msg_count,
2942: p_data => x_msg_data
2943: );
2944: --

Line 2961: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2957: -- NOTES
2958: ---------------------------------------------------------------------
2959: PROCEDURE Send_SD_Notification (
2960: p_api_version IN NUMBER
2961: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2962: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2963: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2964: ,p_object_id IN NUMBER
2965: ,p_action_code IN VARCHAR2

Line 2962: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

2958: ---------------------------------------------------------------------
2959: PROCEDURE Send_SD_Notification (
2960: p_api_version IN NUMBER
2961: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2962: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2963: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2964: ,p_object_id IN NUMBER
2965: ,p_action_code IN VARCHAR2
2966: ,x_return_status OUT NOCOPY VARCHAR2

Line 2963: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

2959: PROCEDURE Send_SD_Notification (
2960: p_api_version IN NUMBER
2961: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2962: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2963: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2964: ,p_object_id IN NUMBER
2965: ,p_action_code IN VARCHAR2
2966: ,x_return_status OUT NOCOPY VARCHAR2
2967: ,x_msg_data OUT NOCOPY VARCHAR2

Line 3090: IF NOT FND_API.Compatible_API_Call (

3086: BEGIN
3087: -- Standard begin of API savepoint
3088: SAVEPOINT Send_SD_Notification;
3089: -- Standard call to check for call compatibility.
3090: IF NOT FND_API.Compatible_API_Call (
3091: l_api_version,
3092: p_api_version,
3093: l_api_name,
3094: G_PKG_NAME)

Line 3096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3092: p_api_version,
3093: l_api_name,
3094: G_PKG_NAME)
3095: THEN
3096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3097: END IF;
3098: -- Debug Message
3099: IF G_DEBUG THEN
3100: ozf_utility_pvt.debug_message( l_api_name||': Start');

Line 3103: IF FND_API.To_Boolean (p_init_msg_list) THEN

3099: IF G_DEBUG THEN
3100: ozf_utility_pvt.debug_message( l_api_name||': Start');
3101: END IF;
3102: --Initialize message list if p_init_msg_list is TRUE.
3103: IF FND_API.To_Boolean (p_init_msg_list) THEN
3104: FND_MSG_PUB.initialize;
3105: END IF;
3106: -- Initialize API return status to sucess
3107: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3107: x_return_status := FND_API.G_RET_STS_SUCCESS;

3103: IF FND_API.To_Boolean (p_init_msg_list) THEN
3104: FND_MSG_PUB.initialize;
3105: END IF;
3106: -- Initialize API return status to sucess
3107: x_return_status := FND_API.G_RET_STS_SUCCESS;
3108:
3109: IF G_DEBUG THEN
3110: ozf_utility_pvt.debug_message( 'Construct the message for request_header_id: '||p_object_id);
3111: END IF;

Line 3310: IF FND_API.To_Boolean ( p_commit ) THEN

3306: ozf_utility_pvt.debug_message('Sent notification to role: ' || l_adhoc_role);
3307: ozf_utility_pvt.debug_message('Using message: ' || l_item_name || '. Notify id: ' || l_group_notify_id );
3308: END IF;
3309: --Standard check of commit
3310: IF FND_API.To_Boolean ( p_commit ) THEN
3311: COMMIT WORK;
3312: END IF;
3313:
3314: -- Debug Message

Line 3320: p_encoded => FND_API.G_FALSE,

3316: ozf_utility_pvt.debug_message( l_api_name||': End');
3317: END IF;
3318: --Standard call to get message count and if count=1, get the message
3319: FND_MSG_PUB.Count_And_Get (
3320: p_encoded => FND_API.G_FALSE,
3321: p_count => x_msg_count,
3322: p_data => x_msg_data
3323: );
3324: EXCEPTION

Line 3325: WHEN FND_API.G_EXC_ERROR THEN

3321: p_count => x_msg_count,
3322: p_data => x_msg_data
3323: );
3324: EXCEPTION
3325: WHEN FND_API.G_EXC_ERROR THEN
3326: ROLLBACK TO Send_SD_Notification;
3327: x_return_status := FND_API.G_RET_STS_ERROR;
3328: -- Standard call to get message count and if count=1, get the message
3329: FND_MSG_PUB.Count_And_Get (

Line 3327: x_return_status := FND_API.G_RET_STS_ERROR;

3323: );
3324: EXCEPTION
3325: WHEN FND_API.G_EXC_ERROR THEN
3326: ROLLBACK TO Send_SD_Notification;
3327: x_return_status := FND_API.G_RET_STS_ERROR;
3328: -- Standard call to get message count and if count=1, get the message
3329: FND_MSG_PUB.Count_And_Get (
3330: p_encoded => FND_API.G_FALSE,
3331: p_count => x_msg_count,

Line 3330: p_encoded => FND_API.G_FALSE,

3326: ROLLBACK TO Send_SD_Notification;
3327: x_return_status := FND_API.G_RET_STS_ERROR;
3328: -- Standard call to get message count and if count=1, get the message
3329: FND_MSG_PUB.Count_And_Get (
3330: p_encoded => FND_API.G_FALSE,
3331: p_count => x_msg_count,
3332: p_data => x_msg_data
3333: );
3334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3330: p_encoded => FND_API.G_FALSE,
3331: p_count => x_msg_count,
3332: p_data => x_msg_data
3333: );
3334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3335: ROLLBACK TO Send_SD_Notification;
3336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3337: -- Standard call to get message count and if count=1, get the message
3338: FND_MSG_PUB.Count_And_Get (

Line 3336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3332: p_data => x_msg_data
3333: );
3334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3335: ROLLBACK TO Send_SD_Notification;
3336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3337: -- Standard call to get message count and if count=1, get the message
3338: FND_MSG_PUB.Count_And_Get (
3339: p_encoded => FND_API.G_FALSE,
3340: p_count => x_msg_count,

Line 3339: p_encoded => FND_API.G_FALSE,

3335: ROLLBACK TO Send_SD_Notification;
3336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3337: -- Standard call to get message count and if count=1, get the message
3338: FND_MSG_PUB.Count_And_Get (
3339: p_encoded => FND_API.G_FALSE,
3340: p_count => x_msg_count,
3341: p_data => x_msg_data
3342: );
3343: WHEN OTHERS THEN

Line 3345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3341: p_data => x_msg_data
3342: );
3343: WHEN OTHERS THEN
3344: ROLLBACK TO Send_SD_Notification;
3345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3346: IF OZF_UNEXP_ERROR_ON
3347: THEN
3348: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3349: END IF;

Line 3352: p_encoded => FND_API.G_FALSE,

3348: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3349: END IF;
3350: -- Standard call to get message count and if count=1, get the message
3351: FND_MSG_PUB.Count_And_Get (
3352: p_encoded => FND_API.G_FALSE,
3353: p_count => x_msg_count,
3354: p_data => x_msg_data
3355: );
3356: --