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

Line 100: x_return_status := FND_API.g_ret_sts_success;

96: AND ENABLED_FLAG = 'Y'
97: AND ATTR_CODE =attr_cd;
98:
99: BEGIN
100: x_return_status := FND_API.g_ret_sts_success;
101: OPEN memb_csr( p_member_type );
102: FETCH memb_csr INTO l_value;
103: CLOSE memb_csr;
104: IF l_value IS NULL THEN

Line 105: x_return_status := FND_API.g_ret_sts_error;

101: OPEN memb_csr( p_member_type );
102: FETCH memb_csr INTO l_value;
103: CLOSE memb_csr;
104: IF l_value IS NULL THEN
105: x_return_status := FND_API.g_ret_sts_error;
106: FND_MESSAGE.set_name('PV', 'PV_INVALID_MEMBER_TYPE');
107: FND_MESSAGE.set_token('MEMBER_TYPE',p_member_type );
108: FND_MSG_PUB.add;
109: END IF;

Line 121: x_return_status := FND_API.g_ret_sts_success;

117: )
118: IS
119: l_lookup_exists VARCHAR2(1);
120: BEGIN
121: x_return_status := FND_API.g_ret_sts_success;
122: --validate lookup
123: l_lookup_exists := PVX_UTILITY_PVT.check_lookup_exists
124: ( p_lookup_table_name => 'PV_LOOKUPS'
125: ,p_lookup_type => p_lookup_type

Line 128: IF NOT FND_API.to_boolean(l_lookup_exists) THEN

124: ( p_lookup_table_name => 'PV_LOOKUPS'
125: ,p_lookup_type => p_lookup_type
126: ,p_lookup_code => p_lookup_code
127: );
128: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
129: x_return_status := FND_API.g_ret_sts_error;
130: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
131: FND_MESSAGE.set_token('LOOKUP_TYPE',p_lookup_type );
132: FND_MESSAGE.set_token('LOOKUP_CODE', p_lookup_code );

Line 129: x_return_status := FND_API.g_ret_sts_error;

125: ,p_lookup_type => p_lookup_type
126: ,p_lookup_code => p_lookup_code
127: );
128: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
129: x_return_status := FND_API.g_ret_sts_error;
130: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
131: FND_MESSAGE.set_token('LOOKUP_TYPE',p_lookup_type );
132: FND_MESSAGE.set_token('LOOKUP_CODE', p_lookup_code );
133: FND_MSG_PUB.add;

Line 201: x_return_status := FND_API.g_ret_sts_success;

197: WHERE partner_id=ptr_id
198: AND STATUS='A';
199:
200: BEGIN
201: x_return_status := FND_API.g_ret_sts_success;
202: --validate lookup
203: IF p_partner_id is NULL THEN
204: l_is_valid :='N';
205: ELSE

Line 214: x_return_status := FND_API.g_ret_sts_error;

210: l_is_valid:='N';
211: END IF;
212: END IF;
213: IF l_is_valid='N' THEN
214: x_return_status := FND_API.g_ret_sts_error;
215: FND_MESSAGE.set_name('PV', 'PV_NO_PARTNER_ID');
216: FND_MESSAGE.set_token('ID',p_partner_id );
217: FND_MSG_PUB.add;
218: END IF;

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

241: --------------------------------------------------------------------------
242: PROCEDURE Register_term_ptr_memb_type
243: (
244: p_api_version_number IN NUMBER
245: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
246: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
247: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
248: ,p_partner_id IN NUMBER
249: ,p_current_memb_type IN VARCHAR2 DEFAULT NULL

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

242: PROCEDURE Register_term_ptr_memb_type
243: (
244: p_api_version_number IN NUMBER
245: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
246: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
247: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
248: ,p_partner_id IN NUMBER
249: ,p_current_memb_type IN VARCHAR2 DEFAULT NULL
250: ,p_new_memb_type IN VARCHAR2

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

243: (
244: p_api_version_number IN NUMBER
245: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
246: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
247: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
248: ,p_partner_id IN NUMBER
249: ,p_current_memb_type IN VARCHAR2 DEFAULT NULL
250: ,p_new_memb_type IN VARCHAR2
251: ,p_global_ptr_id IN NUMBER DEFAULT NULL

Line 429: IF NOT FND_API.Compatible_API_Call

425: BEGIN
426: -- Standard Start of API savepoint
427: SAVEPOINT Register_term_ptr_memb_type;
428: -- Standard call to check for call compatibility.
429: IF NOT FND_API.Compatible_API_Call
430: ( l_api_version_number
431: ,p_api_version_number
432: ,l_api_name
433: ,G_PKG_NAME

Line 436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

432: ,l_api_name
433: ,G_PKG_NAME
434: )
435: THEN
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437: END IF ;
438: -- Initialize message list if p_init_msg_list is set to TRUE.
439: IF FND_API.to_Boolean( p_init_msg_list ) THEN
440: FND_MSG_PUB.initialize;

Line 439: IF FND_API.to_Boolean( p_init_msg_list ) THEN

435: THEN
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437: END IF ;
438: -- Initialize message list if p_init_msg_list is set to TRUE.
439: IF FND_API.to_Boolean( p_init_msg_list ) THEN
440: FND_MSG_PUB.initialize;
441: END IF;
442: -- Debug Message
443:

Line 449: x_return_status := FND_API.G_RET_STS_SUCCESS;

445: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
446: END IF;
447:
448: -- Initialize API return status to SUCCESS
449: x_return_status := FND_API.G_RET_STS_SUCCESS;
450: -- Validate Environment
451: IF FND_GLOBAL.USER_ID IS NULL THEN
452: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
453: RAISE FND_API.G_EXC_ERROR;

Line 453: RAISE FND_API.G_EXC_ERROR;

449: x_return_status := FND_API.G_RET_STS_SUCCESS;
450: -- Validate Environment
451: IF FND_GLOBAL.USER_ID IS NULL THEN
452: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
453: RAISE FND_API.G_EXC_ERROR;
454: END IF;
455:
456: -- find out the existing the member type if its not passed in.. If its passed , validate it
457: IF p_current_memb_type is NULL THEN

Line 469: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

465: p_lookup_type => 'PV_MEMBER_TYPE_CODE'
466: ,p_lookup_code => p_current_memb_type
467: ,x_return_status => x_return_status
468: );
469: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
470: RAISE FND_API.G_EXC_ERROR;
471: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
473: END IF;

Line 470: RAISE FND_API.G_EXC_ERROR;

466: ,p_lookup_code => p_current_memb_type
467: ,x_return_status => x_return_status
468: );
469: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
470: RAISE FND_API.G_EXC_ERROR;
471: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
473: END IF;
474: */

Line 471: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

467: ,x_return_status => x_return_status
468: );
469: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
470: RAISE FND_API.G_EXC_ERROR;
471: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
473: END IF;
474: */
475: Validate_member_type

Line 472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

468: );
469: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
470: RAISE FND_API.G_EXC_ERROR;
471: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
473: END IF;
474: */
475: Validate_member_type
476: (

Line 480: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

476: (
477: p_member_type => p_current_memb_type
478: ,x_return_status => x_return_status
479: );
480: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
481: RAISE FND_API.G_EXC_ERROR;
482: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;

Line 481: RAISE FND_API.G_EXC_ERROR;

477: p_member_type => p_current_memb_type
478: ,x_return_status => x_return_status
479: );
480: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
481: RAISE FND_API.G_EXC_ERROR;
482: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485: l_current_memb_type:=p_current_memb_type;

Line 482: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

478: ,x_return_status => x_return_status
479: );
480: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
481: RAISE FND_API.G_EXC_ERROR;
482: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485: l_current_memb_type:=p_current_memb_type;
486: END IF;

Line 483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

479: );
480: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
481: RAISE FND_API.G_EXC_ERROR;
482: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485: l_current_memb_type:=p_current_memb_type;
486: END IF;
487:

Line 514: p_init_msg_list => FND_API.g_false

510: --terminate the relationship between the subsidiary and global
511:
512: HZ_RELATIONSHIP_V2PUB.update_relationship
513: (
514: p_init_msg_list => FND_API.g_false
515: ,p_relationship_rec => l_relationship_rec
516: ,p_object_version_number => subs.object_version_number
517: ,p_party_object_version_number => l_party_obj_ver_number
518: ,x_return_status => x_return_status

Line 522: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

518: ,x_return_status => x_return_status
519: ,x_msg_count => x_msg_count
520: ,x_msg_data => x_msg_data
521: );
522: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
523: RAISE FND_API.G_EXC_ERROR;
524: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: END IF;

Line 523: RAISE FND_API.G_EXC_ERROR;

519: ,x_msg_count => x_msg_count
520: ,x_msg_data => x_msg_data
521: );
522: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
523: RAISE FND_API.G_EXC_ERROR;
524: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: END IF;
527: --update the attribute value to STANDARD

Line 524: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

520: ,x_msg_data => x_msg_data
521: );
522: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
523: RAISE FND_API.G_EXC_ERROR;
524: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: END IF;
527: --update the attribute value to STANDARD
528: l_attr_value_tbl_type(1).attr_value:='STANDARD';

Line 525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

521: );
522: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
523: RAISE FND_API.G_EXC_ERROR;
524: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: END IF;
527: --update the attribute value to STANDARD
528: l_attr_value_tbl_type(1).attr_value:='STANDARD';
529: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value

Line 532: ,p_init_msg_list => FND_API.g_false

528: l_attr_value_tbl_type(1).attr_value:='STANDARD';
529: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value
530: (
531: p_api_version_number => 1.0
532: ,p_init_msg_list => FND_API.g_false
533: ,p_commit => FND_API.g_false
534: ,p_validation_level => FND_API.g_valid_level_full
535: ,x_return_status => x_return_status
536: ,x_msg_count => x_msg_count

Line 533: ,p_commit => FND_API.g_false

529: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value
530: (
531: p_api_version_number => 1.0
532: ,p_init_msg_list => FND_API.g_false
533: ,p_commit => FND_API.g_false
534: ,p_validation_level => FND_API.g_valid_level_full
535: ,x_return_status => x_return_status
536: ,x_msg_count => x_msg_count
537: ,x_msg_data => x_msg_data

Line 534: ,p_validation_level => FND_API.g_valid_level_full

530: (
531: p_api_version_number => 1.0
532: ,p_init_msg_list => FND_API.g_false
533: ,p_commit => FND_API.g_false
534: ,p_validation_level => FND_API.g_valid_level_full
535: ,x_return_status => x_return_status
536: ,x_msg_count => x_msg_count
537: ,x_msg_data => x_msg_data
538: ,p_attribute_id => 6

Line 544: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

540: ,p_entity_id => subs.partner_id
541: ,p_version => subs.version
542: ,p_attr_val_tbl => l_attr_value_tbl_type
543: );
544: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
545: RAISE FND_API.G_EXC_ERROR;
546: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
548: END IF;

Line 545: RAISE FND_API.G_EXC_ERROR;

541: ,p_version => subs.version
542: ,p_attr_val_tbl => l_attr_value_tbl_type
543: );
544: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
545: RAISE FND_API.G_EXC_ERROR;
546: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
548: END IF;
549:

Line 546: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

542: ,p_attr_val_tbl => l_attr_value_tbl_type
543: );
544: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
545: RAISE FND_API.G_EXC_ERROR;
546: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
548: END IF;
549:
550: --send notification to the subsidiary partner that their member type changed

Line 547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

543: );
544: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
545: RAISE FND_API.G_EXC_ERROR;
546: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
548: END IF;
549:
550: --send notification to the subsidiary partner that their member type changed
551: PV_PG_NOTIF_UTILITY_PVT.Send_Workflow_Notification

Line 554: , p_init_msg_list => FND_API.G_FALSE

550: --send notification to the subsidiary partner that their member type changed
551: PV_PG_NOTIF_UTILITY_PVT.Send_Workflow_Notification
552: (
553: p_api_version_number => 1.0
554: , p_init_msg_list => FND_API.G_FALSE
555: , p_commit => FND_API.G_FALSE
556: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
557: , p_context_id => p_partner_id -- context id is global partner_id when change to memb type is subsidiary
558: , p_context_code => 'SUBSIDIARY'

Line 555: , p_commit => FND_API.G_FALSE

551: PV_PG_NOTIF_UTILITY_PVT.Send_Workflow_Notification
552: (
553: p_api_version_number => 1.0
554: , p_init_msg_list => FND_API.G_FALSE
555: , p_commit => FND_API.G_FALSE
556: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
557: , p_context_id => p_partner_id -- context id is global partner_id when change to memb type is subsidiary
558: , p_context_code => 'SUBSIDIARY'
559: , p_target_ctgry => 'PARTNER'

Line 556: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

552: (
553: p_api_version_number => 1.0
554: , p_init_msg_list => FND_API.G_FALSE
555: , p_commit => FND_API.G_FALSE
556: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
557: , p_context_id => p_partner_id -- context id is global partner_id when change to memb type is subsidiary
558: , p_context_code => 'SUBSIDIARY'
559: , p_target_ctgry => 'PARTNER'
560: , p_target_ctgry_pt_id => subs.partner_id

Line 589: , p_init_msg_list => FND_API.g_false

585: , p_partner_id => subs.partner_id
586: , p_access_level_flag => 'P'
587: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50
588: , p_log_params_tbl => l_param_tbl_var1
589: , p_init_msg_list => FND_API.g_false
590: , p_commit => FND_API.G_FALSE
591: , x_return_status => x_return_status
592: , x_msg_count => x_msg_count
593: , x_msg_data => x_msg_data

Line 590: , p_commit => FND_API.G_FALSE

586: , p_access_level_flag => 'P'
587: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50
588: , p_log_params_tbl => l_param_tbl_var1
589: , p_init_msg_list => FND_API.g_false
590: , p_commit => FND_API.G_FALSE
591: , x_return_status => x_return_status
592: , x_msg_count => x_msg_count
593: , x_msg_data => x_msg_data
594: );

Line 595: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

591: , x_return_status => x_return_status
592: , x_msg_count => x_msg_count
593: , x_msg_data => x_msg_data
594: );
595: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
596: RAISE FND_API.G_EXC_ERROR;
597: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
599: END IF;

Line 596: RAISE FND_API.G_EXC_ERROR;

592: , x_msg_count => x_msg_count
593: , x_msg_data => x_msg_data
594: );
595: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
596: RAISE FND_API.G_EXC_ERROR;
597: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
599: END IF;
600:

Line 597: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

593: , x_msg_data => x_msg_data
594: );
595: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
596: RAISE FND_API.G_EXC_ERROR;
597: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
599: END IF;
600:
601: -- write to the subsidiary history log that membertype of the subsidiary changed to standard.

Line 598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

594: );
595: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
596: RAISE FND_API.G_EXC_ERROR;
597: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
599: END IF;
600:
601: -- write to the subsidiary history log that membertype of the subsidiary changed to standard.
602: OPEN get_memb_csr('SUBSIDIARY') ;

Line 625: , p_init_msg_list => FND_API.g_false

621: , p_partner_id => subs.partner_id
622: , p_access_level_flag => 'P'
623: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50
624: , p_log_params_tbl => l_param_tbl_var
625: , p_init_msg_list => FND_API.g_false
626: , p_commit => FND_API.G_FALSE
627: , x_return_status => x_return_status
628: , x_msg_count => x_msg_count
629: , x_msg_data => x_msg_data

Line 626: , p_commit => FND_API.G_FALSE

622: , p_access_level_flag => 'P'
623: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50
624: , p_log_params_tbl => l_param_tbl_var
625: , p_init_msg_list => FND_API.g_false
626: , p_commit => FND_API.G_FALSE
627: , x_return_status => x_return_status
628: , x_msg_count => x_msg_count
629: , x_msg_data => x_msg_data
630: );

Line 631: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

627: , x_return_status => x_return_status
628: , x_msg_count => x_msg_count
629: , x_msg_data => x_msg_data
630: );
631: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
632: RAISE FND_API.G_EXC_ERROR;
633: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: END IF;

Line 632: RAISE FND_API.G_EXC_ERROR;

628: , x_msg_count => x_msg_count
629: , x_msg_data => x_msg_data
630: );
631: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
632: RAISE FND_API.G_EXC_ERROR;
633: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: END IF;
636:

Line 633: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

629: , x_msg_data => x_msg_data
630: );
631: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
632: RAISE FND_API.G_EXC_ERROR;
633: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: END IF;
636:
637:

Line 634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

630: );
631: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
632: RAISE FND_API.G_EXC_ERROR;
633: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: END IF;
636:
637:
638: END LOOP;

Line 644: ,p_init_msg_list => FND_API.g_false

640: l_attr_value_tbl_type(1).attr_value:='STANDARD';
641: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value
642: (
643: p_api_version_number => 1.0
644: ,p_init_msg_list => FND_API.g_false
645: ,p_commit => FND_API.g_false
646: ,p_validation_level => FND_API.g_valid_level_full
647: ,x_return_status => x_return_status
648: ,x_msg_count => x_msg_count

Line 645: ,p_commit => FND_API.g_false

641: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value
642: (
643: p_api_version_number => 1.0
644: ,p_init_msg_list => FND_API.g_false
645: ,p_commit => FND_API.g_false
646: ,p_validation_level => FND_API.g_valid_level_full
647: ,x_return_status => x_return_status
648: ,x_msg_count => x_msg_count
649: ,x_msg_data => x_msg_data

Line 646: ,p_validation_level => FND_API.g_valid_level_full

642: (
643: p_api_version_number => 1.0
644: ,p_init_msg_list => FND_API.g_false
645: ,p_commit => FND_API.g_false
646: ,p_validation_level => FND_API.g_valid_level_full
647: ,x_return_status => x_return_status
648: ,x_msg_count => x_msg_count
649: ,x_msg_data => x_msg_data
650: ,p_attribute_id => 6

Line 656: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

652: ,p_entity_id => p_partner_id
653: ,p_version => l_version
654: ,p_attr_val_tbl => l_attr_value_tbl_type
655: );
656: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
657: RAISE FND_API.G_EXC_ERROR;
658: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
660: END IF;

Line 657: RAISE FND_API.G_EXC_ERROR;

653: ,p_version => l_version
654: ,p_attr_val_tbl => l_attr_value_tbl_type
655: );
656: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
657: RAISE FND_API.G_EXC_ERROR;
658: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
660: END IF;
661: ELSIF l_current_memb_type='SUBSIDIARY' THEN

Line 658: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

654: ,p_attr_val_tbl => l_attr_value_tbl_type
655: );
656: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
657: RAISE FND_API.G_EXC_ERROR;
658: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
660: END IF;
661: ELSIF l_current_memb_type='SUBSIDIARY' THEN
662:

Line 659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

655: );
656: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
657: RAISE FND_API.G_EXC_ERROR;
658: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
660: END IF;
661: ELSIF l_current_memb_type='SUBSIDIARY' THEN
662:
663: --get the relationship_id

Line 680: p_init_msg_list => FND_API.g_false

676: IF l_relationship_id IS NOT NULL THEN
677:
678: HZ_RELATIONSHIP_V2PUB.update_relationship
679: (
680: p_init_msg_list => FND_API.g_false
681: ,p_relationship_rec => l_relationship_rec
682: ,p_object_version_number => l_object_version_number
683: ,p_party_object_version_number => l_party_obj_ver_number
684: ,x_return_status => x_return_status

Line 688: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

684: ,x_return_status => x_return_status
685: ,x_msg_count => x_msg_count
686: ,x_msg_data => x_msg_data
687: );
688: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
689: RAISE FND_API.G_EXC_ERROR;
690: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
692: END IF;

Line 689: RAISE FND_API.G_EXC_ERROR;

685: ,x_msg_count => x_msg_count
686: ,x_msg_data => x_msg_data
687: );
688: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
689: RAISE FND_API.G_EXC_ERROR;
690: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
692: END IF;
693: END IF;

Line 690: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

686: ,x_msg_data => x_msg_data
687: );
688: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
689: RAISE FND_API.G_EXC_ERROR;
690: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
692: END IF;
693: END IF;
694: --also update the attr_value to STANDARD

Line 691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

687: );
688: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
689: RAISE FND_API.G_EXC_ERROR;
690: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
692: END IF;
693: END IF;
694: --also update the attr_value to STANDARD
695:

Line 706: ,p_init_msg_list => FND_API.g_false

702: l_attr_value_tbl_type(1).attr_value:='STANDARD';
703: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value
704: (
705: p_api_version_number => 1.0
706: ,p_init_msg_list => FND_API.g_false
707: ,p_commit => FND_API.g_false
708: ,p_validation_level => FND_API.g_valid_level_full
709: ,x_return_status => x_return_status
710: ,x_msg_count => x_msg_count

Line 707: ,p_commit => FND_API.g_false

703: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value
704: (
705: p_api_version_number => 1.0
706: ,p_init_msg_list => FND_API.g_false
707: ,p_commit => FND_API.g_false
708: ,p_validation_level => FND_API.g_valid_level_full
709: ,x_return_status => x_return_status
710: ,x_msg_count => x_msg_count
711: ,x_msg_data => x_msg_data

Line 708: ,p_validation_level => FND_API.g_valid_level_full

704: (
705: p_api_version_number => 1.0
706: ,p_init_msg_list => FND_API.g_false
707: ,p_commit => FND_API.g_false
708: ,p_validation_level => FND_API.g_valid_level_full
709: ,x_return_status => x_return_status
710: ,x_msg_count => x_msg_count
711: ,x_msg_data => x_msg_data
712: ,p_attribute_id => 6

Line 719: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

715: ,p_version => l_version
716: ,p_attr_val_tbl => l_attr_value_tbl_type
717: );
718:
719: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
720: RAISE FND_API.G_EXC_ERROR;
721: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
723: END IF;

Line 720: RAISE FND_API.G_EXC_ERROR;

716: ,p_attr_val_tbl => l_attr_value_tbl_type
717: );
718:
719: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
720: RAISE FND_API.G_EXC_ERROR;
721: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
723: END IF;
724:

Line 721: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

717: );
718:
719: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
720: RAISE FND_API.G_EXC_ERROR;
721: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
723: END IF;
724:
725: END IF; --end of if else for l_current_memb_type

Line 722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

718:
719: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
720: RAISE FND_API.G_EXC_ERROR;
721: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
723: END IF;
724:
725: END IF; --end of if else for l_current_memb_type
726:

Line 737: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

733: p_lookup_type => 'PV_MEMBER_TYPE_CODE'
734: ,p_lookup_code => p_new_memb_type
735: ,x_return_status => x_return_status
736: );
737: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
738: RAISE FND_API.G_EXC_ERROR;
739: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
741: END IF;

Line 738: RAISE FND_API.G_EXC_ERROR;

734: ,p_lookup_code => p_new_memb_type
735: ,x_return_status => x_return_status
736: );
737: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
738: RAISE FND_API.G_EXC_ERROR;
739: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
741: END IF;
742: */

Line 739: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

735: ,x_return_status => x_return_status
736: );
737: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
738: RAISE FND_API.G_EXC_ERROR;
739: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
741: END IF;
742: */
743:

Line 740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

736: );
737: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
738: RAISE FND_API.G_EXC_ERROR;
739: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
741: END IF;
742: */
743:
744: Validate_member_type

Line 749: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

745: (
746: p_member_type => p_new_memb_type
747: ,x_return_status => x_return_status
748: );
749: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
750: RAISE FND_API.G_EXC_ERROR;
751: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
753: END IF;

Line 750: RAISE FND_API.G_EXC_ERROR;

746: p_member_type => p_new_memb_type
747: ,x_return_status => x_return_status
748: );
749: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
750: RAISE FND_API.G_EXC_ERROR;
751: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
753: END IF;
754: --update/insert the attributes table only if its null or the one in the db is not equal to the one thats passed in

Line 751: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

747: ,x_return_status => x_return_status
748: );
749: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
750: RAISE FND_API.G_EXC_ERROR;
751: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
753: END IF;
754: --update/insert the attributes table only if its null or the one in the db is not equal to the one thats passed in
755: IF ( l_current_memb_type<>p_new_memb_type OR l_current_memb_type IS NULL ) THEN

Line 752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

748: );
749: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
750: RAISE FND_API.G_EXC_ERROR;
751: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
753: END IF;
754: --update/insert the attributes table only if its null or the one in the db is not equal to the one thats passed in
755: IF ( l_current_memb_type<>p_new_memb_type OR l_current_memb_type IS NULL ) THEN
756: --if the attribute val for this attribute is being created for the first time pass version as zero.

Line 766: ,p_init_msg_list => FND_API.g_false

762:
763: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value
764: (
765: p_api_version_number => 1.0
766: ,p_init_msg_list => FND_API.g_false
767: ,p_commit => FND_API.g_false
768: ,p_validation_level => FND_API.g_valid_level_full
769: ,x_return_status => x_return_status
770: ,x_msg_count => x_msg_count

Line 767: ,p_commit => FND_API.g_false

763: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value
764: (
765: p_api_version_number => 1.0
766: ,p_init_msg_list => FND_API.g_false
767: ,p_commit => FND_API.g_false
768: ,p_validation_level => FND_API.g_valid_level_full
769: ,x_return_status => x_return_status
770: ,x_msg_count => x_msg_count
771: ,x_msg_data => x_msg_data

Line 768: ,p_validation_level => FND_API.g_valid_level_full

764: (
765: p_api_version_number => 1.0
766: ,p_init_msg_list => FND_API.g_false
767: ,p_commit => FND_API.g_false
768: ,p_validation_level => FND_API.g_valid_level_full
769: ,x_return_status => x_return_status
770: ,x_msg_count => x_msg_count
771: ,x_msg_data => x_msg_data
772: ,p_attribute_id => 6

Line 778: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

774: ,p_entity_id => p_partner_id
775: ,p_version => l_version
776: ,p_attr_val_tbl => l_attr_value_tbl_type
777: );
778: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
779: RAISE FND_API.G_EXC_ERROR;
780: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
782: END IF;

Line 779: RAISE FND_API.G_EXC_ERROR;

775: ,p_version => l_version
776: ,p_attr_val_tbl => l_attr_value_tbl_type
777: );
778: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
779: RAISE FND_API.G_EXC_ERROR;
780: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
782: END IF;
783: --only if the new memb type is SUBSIADIARY, you need to create a new relationship

Line 780: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

776: ,p_attr_val_tbl => l_attr_value_tbl_type
777: );
778: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
779: RAISE FND_API.G_EXC_ERROR;
780: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
782: END IF;
783: --only if the new memb type is SUBSIADIARY, you need to create a new relationship
784: IF p_new_memb_type='SUBSIDIARY' THEN

Line 781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

777: );
778: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
779: RAISE FND_API.G_EXC_ERROR;
780: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
782: END IF;
783: --only if the new memb type is SUBSIADIARY, you need to create a new relationship
784: IF p_new_memb_type='SUBSIDIARY' THEN
785: l_check_status := isRecordExists(p_partner_id);

Line 821: p_init_msg_list => FND_API.G_FALSE

817: -- Create the relationship.
818:
819: HZ_RELATIONSHIP_V2PUB.create_relationship
820: (
821: p_init_msg_list => FND_API.G_FALSE
822: ,p_relationship_rec => l_relationship_rec
823: ,x_relationship_id => l_memb_rel_id
824: ,x_party_id => l_memb_party_id
825: ,x_party_number => l_memb_party_number

Line 832: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

828: ,x_msg_data => x_msg_data
829: ,p_create_org_contact => 'N'
830: );
831:
832: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
833: RAISE FND_API.G_EXC_ERROR;
834: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
836: END IF;

Line 833: RAISE FND_API.G_EXC_ERROR;

829: ,p_create_org_contact => 'N'
830: );
831:
832: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
833: RAISE FND_API.G_EXC_ERROR;
834: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
836: END IF;
837:

Line 834: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

830: );
831:
832: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
833: RAISE FND_API.G_EXC_ERROR;
834: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
836: END IF;
837:
838: PV_PG_NOTIF_UTILITY_PVT.Send_Workflow_Notification

Line 835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

831:
832: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
833: RAISE FND_API.G_EXC_ERROR;
834: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
836: END IF;
837:
838: PV_PG_NOTIF_UTILITY_PVT.Send_Workflow_Notification
839: (

Line 841: , p_init_msg_list => FND_API.G_FALSE

837:
838: PV_PG_NOTIF_UTILITY_PVT.Send_Workflow_Notification
839: (
840: p_api_version_number => 1.0
841: , p_init_msg_list => FND_API.G_FALSE
842: , p_commit => FND_API.G_FALSE
843: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
844: , p_context_id => p_partner_id-- partner id of the subsidiary partner
845: , p_context_code => 'PARTNER'

Line 842: , p_commit => FND_API.G_FALSE

838: PV_PG_NOTIF_UTILITY_PVT.Send_Workflow_Notification
839: (
840: p_api_version_number => 1.0
841: , p_init_msg_list => FND_API.G_FALSE
842: , p_commit => FND_API.G_FALSE
843: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
844: , p_context_id => p_partner_id-- partner id of the subsidiary partner
845: , p_context_code => 'PARTNER'
846: , p_target_ctgry => 'PARTNER'

Line 843: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

839: (
840: p_api_version_number => 1.0
841: , p_init_msg_list => FND_API.G_FALSE
842: , p_commit => FND_API.G_FALSE
843: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
844: , p_context_id => p_partner_id-- partner id of the subsidiary partner
845: , p_context_code => 'PARTNER'
846: , p_target_ctgry => 'PARTNER'
847: , p_target_ctgry_pt_id => p_global_ptr_id -- global partner_id

Line 858: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

854: , x_msg_data => x_msg_data
855: );
856:
857:
858: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
859: RAISE FND_API.G_EXC_ERROR;
860: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
862: END IF;

Line 859: RAISE FND_API.G_EXC_ERROR;

855: );
856:
857:
858: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
859: RAISE FND_API.G_EXC_ERROR;
860: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
862: END IF;
863: ELSE

Line 860: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

856:
857:
858: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
859: RAISE FND_API.G_EXC_ERROR;
860: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
862: END IF;
863: ELSE
864: --raise error if the global is invalid

Line 861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

857:
858: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
859: RAISE FND_API.G_EXC_ERROR;
860: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
862: END IF;
863: ELSE
864: --raise error if the global is invalid
865: FND_MESSAGE.set_name('PV', 'PV_GLOBAL_PARTNER_ID_INVALID');

Line 867: RAISE FND_API.G_EXC_ERROR;

863: ELSE
864: --raise error if the global is invalid
865: FND_MESSAGE.set_name('PV', 'PV_GLOBAL_PARTNER_ID_INVALID');
866: FND_MSG_PUB.add;
867: RAISE FND_API.G_EXC_ERROR;
868: END IF;-- global exists
869: END IF; --end of iif to check whether the subsidiary already has an active relationship with a global
870: END IF;--if new memb type is subsidiary
871: END IF;--end of if , if the current member type and new member type are not equal

Line 884: IF FND_API.to_Boolean( p_commit ) THEN

880: IF (PV_DEBUG_HIGH_ON) THEN
881: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
882: END IF;
883:
884: IF FND_API.to_Boolean( p_commit ) THEN
885: COMMIT WORK;
886: END IF;
887:
888: EXCEPTION

Line 889: WHEN FND_API.G_EXC_ERROR THEN

885: COMMIT WORK;
886: END IF;
887:
888: EXCEPTION
889: WHEN FND_API.G_EXC_ERROR THEN
890: ROLLBACK TO Register_term_ptr_memb_type;
891: x_return_status := FND_API.G_RET_STS_ERROR;
892: -- Standard call to get message count and if count=1, get the message
893: FND_MSG_PUB.Count_And_Get (

Line 891: x_return_status := FND_API.G_RET_STS_ERROR;

887:
888: EXCEPTION
889: WHEN FND_API.G_EXC_ERROR THEN
890: ROLLBACK TO Register_term_ptr_memb_type;
891: x_return_status := FND_API.G_RET_STS_ERROR;
892: -- Standard call to get message count and if count=1, get the message
893: FND_MSG_PUB.Count_And_Get (
894: p_encoded => FND_API.G_FALSE,
895: p_count => x_msg_count,

Line 894: p_encoded => FND_API.G_FALSE,

890: ROLLBACK TO Register_term_ptr_memb_type;
891: x_return_status := FND_API.G_RET_STS_ERROR;
892: -- Standard call to get message count and if count=1, get the message
893: FND_MSG_PUB.Count_And_Get (
894: p_encoded => FND_API.G_FALSE,
895: p_count => x_msg_count,
896: p_data => x_msg_data
897: );
898:

Line 899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

895: p_count => x_msg_count,
896: p_data => x_msg_data
897: );
898:
899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
900: ROLLBACK TO Register_term_ptr_memb_type;
901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
902: -- Standard call to get message count and if count=1, get the message
903: FND_MSG_PUB.Count_And_Get (

Line 901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

897: );
898:
899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
900: ROLLBACK TO Register_term_ptr_memb_type;
901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
902: -- Standard call to get message count and if count=1, get the message
903: FND_MSG_PUB.Count_And_Get (
904: p_encoded => FND_API.G_FALSE,
905: p_count => x_msg_count,

Line 904: p_encoded => FND_API.G_FALSE,

900: ROLLBACK TO Register_term_ptr_memb_type;
901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
902: -- Standard call to get message count and if count=1, get the message
903: FND_MSG_PUB.Count_And_Get (
904: p_encoded => FND_API.G_FALSE,
905: p_count => x_msg_count,
906: p_data => x_msg_data
907: );
908:

Line 911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

907: );
908:
909: WHEN OTHERS THEN
910: ROLLBACK TO Register_term_ptr_memb_type;
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
912: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
913: THEN
914: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
915: END IF;

Line 918: p_encoded => FND_API.G_FALSE,

914: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
915: END IF;
916: -- Standard call to get message count and if count=1, get the message
917: FND_MSG_PUB.Count_And_Get (
918: p_encoded => FND_API.G_FALSE,
919: p_count => x_msg_count,
920: p_data => x_msg_data
921: );
922: END Register_term_ptr_memb_type;

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

946: --------------------------------------------------------------------------
947: PROCEDURE Process_ptr_member_type
948: (
949: p_api_version_number IN NUMBER
950: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
951: , p_commit IN VARCHAR2 := FND_API.G_FALSE
952: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
953: , p_partner_id IN NUMBER
954: , p_chg_from_memb_type IN VARCHAR2 DEFAULT NULL

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

947: PROCEDURE Process_ptr_member_type
948: (
949: p_api_version_number IN NUMBER
950: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
951: , p_commit IN VARCHAR2 := FND_API.G_FALSE
952: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
953: , p_partner_id IN NUMBER
954: , p_chg_from_memb_type IN VARCHAR2 DEFAULT NULL
955: , p_chg_to_memb_type IN VARCHAR2

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

948: (
949: p_api_version_number IN NUMBER
950: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
951: , p_commit IN VARCHAR2 := FND_API.G_FALSE
952: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
953: , p_partner_id IN NUMBER
954: , p_chg_from_memb_type IN VARCHAR2 DEFAULT NULL
955: , p_chg_to_memb_type IN VARCHAR2
956: , p_chg_to_global_ptr_id IN NUMBER DEFAULT NULL

Line 991: IF NOT FND_API.Compatible_API_Call

987: */
988: -- Standard Start of API savepoint
989: SAVEPOINT Process_ptr_member_type;
990: -- Standard call to check for call compatibility.
991: IF NOT FND_API.Compatible_API_Call
992: ( l_api_version_number
993: ,p_api_version_number
994: ,l_api_name
995: ,G_PKG_NAME

Line 998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

994: ,l_api_name
995: ,G_PKG_NAME
996: )
997: THEN
998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
999: END IF;
1000: -- Initialize message list if p_init_msg_list is set to TRUE.
1001: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1002: FND_MSG_PUB.initialize;

Line 1001: IF FND_API.to_Boolean( p_init_msg_list ) THEN

997: THEN
998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
999: END IF;
1000: -- Initialize message list if p_init_msg_list is set to TRUE.
1001: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1002: FND_MSG_PUB.initialize;
1003: END IF;
1004: -- Debug Message
1005: IF (PV_DEBUG_HIGH_ON) THEN

Line 1010: x_return_status := FND_API.G_RET_STS_SUCCESS;

1006: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1007: END IF;
1008:
1009: -- Initialize API return status to SUCCESS
1010: x_return_status := FND_API.G_RET_STS_SUCCESS;
1011: -- Validate Environment
1012: IF FND_GLOBAL.USER_ID IS NULL THEN
1013: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1014: RAISE FND_API.G_EXC_ERROR;

Line 1014: RAISE FND_API.G_EXC_ERROR;

1010: x_return_status := FND_API.G_RET_STS_SUCCESS;
1011: -- Validate Environment
1012: IF FND_GLOBAL.USER_ID IS NULL THEN
1013: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1014: RAISE FND_API.G_EXC_ERROR;
1015: END IF;
1016:
1017: --terminate program memberships before terminating relationship
1018: PV_PG_MEMBERSHIPS_PVT.Terminate_ptr_memberships

Line 1021: ,p_init_msg_list => FND_API.G_FALSE

1017: --terminate program memberships before terminating relationship
1018: PV_PG_MEMBERSHIPS_PVT.Terminate_ptr_memberships
1019: (
1020: p_api_version_number => 1.0
1021: ,p_init_msg_list => FND_API.G_FALSE
1022: ,p_commit => FND_API.G_FALSE
1023: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1024: ,p_partner_id => p_partner_id
1025: ,p_memb_type => p_chg_from_memb_type

Line 1022: ,p_commit => FND_API.G_FALSE

1018: PV_PG_MEMBERSHIPS_PVT.Terminate_ptr_memberships
1019: (
1020: p_api_version_number => 1.0
1021: ,p_init_msg_list => FND_API.G_FALSE
1022: ,p_commit => FND_API.G_FALSE
1023: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1024: ,p_partner_id => p_partner_id
1025: ,p_memb_type => p_chg_from_memb_type
1026: ,p_status_reason_code => 'MEMBER_TYPE_CHANGE' -- pass 'MEMBER_TYPE_CHANGE' if it is happening because of member type change -- it validates against PV_MEMB_STATUS_REASON_CODE

Line 1023: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1019: (
1020: p_api_version_number => 1.0
1021: ,p_init_msg_list => FND_API.G_FALSE
1022: ,p_commit => FND_API.G_FALSE
1023: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1024: ,p_partner_id => p_partner_id
1025: ,p_memb_type => p_chg_from_memb_type
1026: ,p_status_reason_code => 'MEMBER_TYPE_CHANGE' -- pass 'MEMBER_TYPE_CHANGE' if it is happening because of member type change -- it validates against PV_MEMB_STATUS_REASON_CODE
1027: ,p_comments => 'Membership terminated by system as member type is changed'

Line 1032: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1028: ,x_return_status => x_return_status
1029: ,x_msg_count => x_msg_count
1030: ,x_msg_data => x_msg_data
1031: );
1032: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1033: RAISE FND_API.G_EXC_ERROR;
1034: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1036: END IF;

Line 1033: RAISE FND_API.G_EXC_ERROR;

1029: ,x_msg_count => x_msg_count
1030: ,x_msg_data => x_msg_data
1031: );
1032: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1033: RAISE FND_API.G_EXC_ERROR;
1034: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1036: END IF;
1037:

Line 1034: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1030: ,x_msg_data => x_msg_data
1031: );
1032: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1033: RAISE FND_API.G_EXC_ERROR;
1034: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1036: END IF;
1037:
1038: -- Call register terminate API with p_new_memb_type as null

Line 1035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1031: );
1032: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1033: RAISE FND_API.G_EXC_ERROR;
1034: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1036: END IF;
1037:
1038: -- Call register terminate API with p_new_memb_type as null
1039: l_chg_from_memb_type := p_chg_from_memb_type;

Line 1049: ,p_init_msg_list => FND_API.G_FALSE

1045:
1046: Register_term_ptr_memb_type
1047: (
1048: p_api_version_number => 1.0
1049: ,p_init_msg_list => FND_API.G_FALSE
1050: ,p_commit => FND_API.G_FALSE
1051: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1052: ,p_partner_id => p_partner_id
1053: ,p_current_memb_type => l_chg_from_memb_type

Line 1050: ,p_commit => FND_API.G_FALSE

1046: Register_term_ptr_memb_type
1047: (
1048: p_api_version_number => 1.0
1049: ,p_init_msg_list => FND_API.G_FALSE
1050: ,p_commit => FND_API.G_FALSE
1051: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1052: ,p_partner_id => p_partner_id
1053: ,p_current_memb_type => l_chg_from_memb_type
1054: ,p_new_memb_type => null

Line 1051: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1047: (
1048: p_api_version_number => 1.0
1049: ,p_init_msg_list => FND_API.G_FALSE
1050: ,p_commit => FND_API.G_FALSE
1051: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1052: ,p_partner_id => p_partner_id
1053: ,p_current_memb_type => l_chg_from_memb_type
1054: ,p_new_memb_type => null
1055: ,p_global_ptr_id => null

Line 1060: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1056: ,x_return_status => x_return_status
1057: ,x_msg_count => x_msg_count
1058: ,x_msg_data => x_msg_data
1059: );
1060: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1061: RAISE FND_API.G_EXC_ERROR;
1062: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1064: END IF;

Line 1061: RAISE FND_API.G_EXC_ERROR;

1057: ,x_msg_count => x_msg_count
1058: ,x_msg_data => x_msg_data
1059: );
1060: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1061: RAISE FND_API.G_EXC_ERROR;
1062: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1064: END IF;
1065:

Line 1062: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1058: ,x_msg_data => x_msg_data
1059: );
1060: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1061: RAISE FND_API.G_EXC_ERROR;
1062: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1064: END IF;
1065:
1066: -- Call register terminate API with p_new_memb_type with the new member type

Line 1063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1059: );
1060: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1061: RAISE FND_API.G_EXC_ERROR;
1062: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1064: END IF;
1065:
1066: -- Call register terminate API with p_new_memb_type with the new member type
1067: -- since the p_chg_from_memb_type would have got changed by now because of the above call,

Line 1078: ,p_init_msg_list => FND_API.G_FALSE

1074: IF ( l_current_memb_type<> p_chg_to_memb_type OR l_current_memb_type IS NULL ) THEN
1075: Register_term_ptr_memb_type
1076: (
1077: p_api_version_number => 1.0
1078: ,p_init_msg_list => FND_API.G_FALSE
1079: ,p_commit => FND_API.G_FALSE
1080: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1081: ,p_partner_id => p_partner_id
1082: ,p_current_memb_type => l_current_memb_type

Line 1079: ,p_commit => FND_API.G_FALSE

1075: Register_term_ptr_memb_type
1076: (
1077: p_api_version_number => 1.0
1078: ,p_init_msg_list => FND_API.G_FALSE
1079: ,p_commit => FND_API.G_FALSE
1080: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1081: ,p_partner_id => p_partner_id
1082: ,p_current_memb_type => l_current_memb_type
1083: ,p_new_memb_type => p_chg_to_memb_type

Line 1080: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1076: (
1077: p_api_version_number => 1.0
1078: ,p_init_msg_list => FND_API.G_FALSE
1079: ,p_commit => FND_API.G_FALSE
1080: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1081: ,p_partner_id => p_partner_id
1082: ,p_current_memb_type => l_current_memb_type
1083: ,p_new_memb_type => p_chg_to_memb_type
1084: ,p_global_ptr_id => p_chg_to_global_ptr_id

Line 1089: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1085: ,x_return_status => x_return_status
1086: ,x_msg_count => x_msg_count
1087: ,x_msg_data => x_msg_data
1088: );
1089: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1090: RAISE FND_API.G_EXC_ERROR;
1091: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1093: END IF;

Line 1090: RAISE FND_API.G_EXC_ERROR;

1086: ,x_msg_count => x_msg_count
1087: ,x_msg_data => x_msg_data
1088: );
1089: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1090: RAISE FND_API.G_EXC_ERROR;
1091: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1093: END IF;
1094: END IF;

Line 1091: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1087: ,x_msg_data => x_msg_data
1088: );
1089: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1090: RAISE FND_API.G_EXC_ERROR;
1091: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1093: END IF;
1094: END IF;
1095: --also terminate all the program memberships

Line 1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1088: );
1089: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1090: RAISE FND_API.G_EXC_ERROR;
1091: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1093: END IF;
1094: END IF;
1095: --also terminate all the program memberships
1096:

Line 1108: , p_init_msg_list => FND_API.G_FALSE

1104: IF l_chg_from_memb_type IS NOT NULL AND p_chg_to_memb_type IS NOT NULL THEN
1105: PV_PG_NOTIF_UTILITY_PVT.Send_Workflow_Notification
1106: (
1107: p_api_version_number => 1.0
1108: , p_init_msg_list => FND_API.G_FALSE
1109: , p_commit => FND_API.G_FALSE
1110: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1111: , p_context_id => l_context_id -- context id is global partner_id when change to memb type is subsidiary
1112: , p_context_code => l_chg_from_memb_type

Line 1109: , p_commit => FND_API.G_FALSE

1105: PV_PG_NOTIF_UTILITY_PVT.Send_Workflow_Notification
1106: (
1107: p_api_version_number => 1.0
1108: , p_init_msg_list => FND_API.G_FALSE
1109: , p_commit => FND_API.G_FALSE
1110: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1111: , p_context_id => l_context_id -- context id is global partner_id when change to memb type is subsidiary
1112: , p_context_code => l_chg_from_memb_type
1113: , p_target_ctgry => 'PARTNER'

Line 1110: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

1106: (
1107: p_api_version_number => 1.0
1108: , p_init_msg_list => FND_API.G_FALSE
1109: , p_commit => FND_API.G_FALSE
1110: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1111: , p_context_id => l_context_id -- context id is global partner_id when change to memb type is subsidiary
1112: , p_context_code => l_chg_from_memb_type
1113: , p_target_ctgry => 'PARTNER'
1114: , p_target_ctgry_pt_id => p_partner_id

Line 1123: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1119: , x_return_status => x_return_status
1120: , x_msg_count => x_msg_count
1121: , x_msg_data => x_msg_data
1122: );
1123: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1124: RAISE FND_API.G_EXC_ERROR;
1125: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1127: END IF;

Line 1124: RAISE FND_API.G_EXC_ERROR;

1120: , x_msg_count => x_msg_count
1121: , x_msg_data => x_msg_data
1122: );
1123: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1124: RAISE FND_API.G_EXC_ERROR;
1125: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1127: END IF;
1128: END IF;

Line 1125: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1121: , x_msg_data => x_msg_data
1122: );
1123: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1124: RAISE FND_API.G_EXC_ERROR;
1125: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1127: END IF;
1128: END IF;
1129:

Line 1126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1122: );
1123: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1124: RAISE FND_API.G_EXC_ERROR;
1125: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1127: END IF;
1128: END IF;
1129:
1130:

Line 1142: IF FND_API.to_Boolean( p_commit ) THEN

1138: IF (PV_DEBUG_HIGH_ON) THEN
1139: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1140: END IF;
1141:
1142: IF FND_API.to_Boolean( p_commit ) THEN
1143: COMMIT WORK;
1144: END IF;
1145:
1146: EXCEPTION

Line 1147: WHEN FND_API.G_EXC_ERROR THEN

1143: COMMIT WORK;
1144: END IF;
1145:
1146: EXCEPTION
1147: WHEN FND_API.G_EXC_ERROR THEN
1148: ROLLBACK TO Process_ptr_member_type;
1149: x_return_status := FND_API.G_RET_STS_ERROR;
1150: -- Standard call to get message count and if count=1, get the message
1151: FND_MSG_PUB.Count_And_Get (

Line 1149: x_return_status := FND_API.G_RET_STS_ERROR;

1145:
1146: EXCEPTION
1147: WHEN FND_API.G_EXC_ERROR THEN
1148: ROLLBACK TO Process_ptr_member_type;
1149: x_return_status := FND_API.G_RET_STS_ERROR;
1150: -- Standard call to get message count and if count=1, get the message
1151: FND_MSG_PUB.Count_And_Get (
1152: p_encoded => FND_API.G_FALSE,
1153: p_count => x_msg_count,

Line 1152: p_encoded => FND_API.G_FALSE,

1148: ROLLBACK TO Process_ptr_member_type;
1149: x_return_status := FND_API.G_RET_STS_ERROR;
1150: -- Standard call to get message count and if count=1, get the message
1151: FND_MSG_PUB.Count_And_Get (
1152: p_encoded => FND_API.G_FALSE,
1153: p_count => x_msg_count,
1154: p_data => x_msg_data
1155: );
1156:

Line 1157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1153: p_count => x_msg_count,
1154: p_data => x_msg_data
1155: );
1156:
1157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1158: ROLLBACK TO Process_ptr_member_type;
1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1160: -- Standard call to get message count and if count=1, get the message
1161: FND_MSG_PUB.Count_And_Get (

Line 1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1155: );
1156:
1157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1158: ROLLBACK TO Process_ptr_member_type;
1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1160: -- Standard call to get message count and if count=1, get the message
1161: FND_MSG_PUB.Count_And_Get (
1162: p_encoded => FND_API.G_FALSE,
1163: p_count => x_msg_count,

Line 1162: p_encoded => FND_API.G_FALSE,

1158: ROLLBACK TO Process_ptr_member_type;
1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1160: -- Standard call to get message count and if count=1, get the message
1161: FND_MSG_PUB.Count_And_Get (
1162: p_encoded => FND_API.G_FALSE,
1163: p_count => x_msg_count,
1164: p_data => x_msg_data
1165: );
1166:

Line 1169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1165: );
1166:
1167: WHEN OTHERS THEN
1168: ROLLBACK TO Process_ptr_member_type;
1169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1170: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1171: THEN
1172: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1173: END IF;

Line 1176: p_encoded => FND_API.G_FALSE,

1172: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1173: END IF;
1174: -- Standard call to get message count and if count=1, get the message
1175: FND_MSG_PUB.Count_And_Get (
1176: p_encoded => FND_API.G_FALSE,
1177: p_count => x_msg_count,
1178: p_data => x_msg_data
1179: );
1180: END Process_ptr_member_type;

Line 1433: ,p_init_msg_list => FND_API.g_false

1429: l_attr_value_tbl_type(1).attr_value:='STANDARD';
1430: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value
1431: (
1432: p_api_version_number => 1.0
1433: ,p_init_msg_list => FND_API.g_false
1434: ,p_commit => FND_API.g_false
1435: ,p_validation_level => FND_API.g_valid_level_full
1436: ,x_return_status => x_return_status
1437: ,x_msg_count => x_msg_count

Line 1434: ,p_commit => FND_API.g_false

1430: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value
1431: (
1432: p_api_version_number => 1.0
1433: ,p_init_msg_list => FND_API.g_false
1434: ,p_commit => FND_API.g_false
1435: ,p_validation_level => FND_API.g_valid_level_full
1436: ,x_return_status => x_return_status
1437: ,x_msg_count => x_msg_count
1438: ,x_msg_data => x_msg_data

Line 1435: ,p_validation_level => FND_API.g_valid_level_full

1431: (
1432: p_api_version_number => 1.0
1433: ,p_init_msg_list => FND_API.g_false
1434: ,p_commit => FND_API.g_false
1435: ,p_validation_level => FND_API.g_valid_level_full
1436: ,x_return_status => x_return_status
1437: ,x_msg_count => x_msg_count
1438: ,x_msg_data => x_msg_data
1439: ,p_attribute_id => 6

Line 1458: , p_init_msg_list => FND_API.G_FALSE

1454: --call terminate ptr memberships api to terminate all program memberships
1455: PV_PG_MEMBERSHIPS_PVT.Terminate_ptr_memberships
1456: (
1457: p_api_version_number => 1.0
1458: , p_init_msg_list => FND_API.G_FALSE
1459: , p_commit => FND_API.G_FALSE
1460: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1461: , p_partner_id => rec.partner_id
1462: , p_memb_type => null

Line 1459: , p_commit => FND_API.G_FALSE

1455: PV_PG_MEMBERSHIPS_PVT.Terminate_ptr_memberships
1456: (
1457: p_api_version_number => 1.0
1458: , p_init_msg_list => FND_API.G_FALSE
1459: , p_commit => FND_API.G_FALSE
1460: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1461: , p_partner_id => rec.partner_id
1462: , p_memb_type => null
1463: , p_status_reason_code => 'PTR_INACTIVE'

Line 1460: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

1456: (
1457: p_api_version_number => 1.0
1458: , p_init_msg_list => FND_API.G_FALSE
1459: , p_commit => FND_API.G_FALSE
1460: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1461: , p_partner_id => rec.partner_id
1462: , p_memb_type => null
1463: , p_status_reason_code => 'PTR_INACTIVE'
1464: , p_comments => null

Line 1490: , p_init_msg_list => FND_API.G_FALSE

1486: IF rec.attr_value <> 'GLOBAL' THEN
1487: Process_ptr_member_type
1488: (
1489: p_api_version_number => 1.0
1490: , p_init_msg_list => FND_API.G_FALSE
1491: , p_commit => FND_API.G_FALSE
1492: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1493: , p_partner_id => rec.global_partner_id
1494: , p_chg_from_memb_type => rec.attr_value

Line 1491: , p_commit => FND_API.G_FALSE

1487: Process_ptr_member_type
1488: (
1489: p_api_version_number => 1.0
1490: , p_init_msg_list => FND_API.G_FALSE
1491: , p_commit => FND_API.G_FALSE
1492: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1493: , p_partner_id => rec.global_partner_id
1494: , p_chg_from_memb_type => rec.attr_value
1495: , p_chg_to_memb_type => 'GLOBAL'

Line 1492: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

1488: (
1489: p_api_version_number => 1.0
1490: , p_init_msg_list => FND_API.G_FALSE
1491: , p_commit => FND_API.G_FALSE
1492: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1493: , p_partner_id => rec.global_partner_id
1494: , p_chg_from_memb_type => rec.attr_value
1495: , p_chg_to_memb_type => 'GLOBAL'
1496: , p_chg_to_global_ptr_id => null

Line 1519: ,p_init_msg_list => FND_API.g_false

1515: l_attr_value_tbl_type(1).attr_value:='SUBSIDIARY';
1516: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value
1517: (
1518: p_api_version_number => 1.0
1519: ,p_init_msg_list => FND_API.g_false
1520: ,p_commit => FND_API.g_false
1521: ,p_validation_level => FND_API.g_valid_level_full
1522: ,x_return_status => x_return_status
1523: ,x_msg_count => x_msg_count

Line 1520: ,p_commit => FND_API.g_false

1516: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value
1517: (
1518: p_api_version_number => 1.0
1519: ,p_init_msg_list => FND_API.g_false
1520: ,p_commit => FND_API.g_false
1521: ,p_validation_level => FND_API.g_valid_level_full
1522: ,x_return_status => x_return_status
1523: ,x_msg_count => x_msg_count
1524: ,x_msg_data => x_msg_data

Line 1521: ,p_validation_level => FND_API.g_valid_level_full

1517: (
1518: p_api_version_number => 1.0
1519: ,p_init_msg_list => FND_API.g_false
1520: ,p_commit => FND_API.g_false
1521: ,p_validation_level => FND_API.g_valid_level_full
1522: ,x_return_status => x_return_status
1523: ,x_msg_count => x_msg_count
1524: ,x_msg_data => x_msg_data
1525: ,p_attribute_id => 6

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

1553:
1554: PROCEDURE update_partner_dtl
1555: (
1556: p_api_version_number IN NUMBER
1557: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1558: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1559: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1560: , p_partner_id IN NUMBER
1561: , p_old_partner_status IN VARCHAR2

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

1554: PROCEDURE update_partner_dtl
1555: (
1556: p_api_version_number IN NUMBER
1557: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1558: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1559: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1560: , p_partner_id IN NUMBER
1561: , p_old_partner_status IN VARCHAR2
1562: , p_new_partner_status IN VARCHAR2

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

1555: (
1556: p_api_version_number IN NUMBER
1557: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1558: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1559: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1560: , p_partner_id IN NUMBER
1561: , p_old_partner_status IN VARCHAR2
1562: , p_new_partner_status IN VARCHAR2
1563: , p_chg_from_memb_type IN VARCHAR2

Line 1598: IF NOT FND_API.Compatible_API_Call

1594: BEGIN
1595: -- Standard Start of API savepoint
1596: SAVEPOINT update_partner_dtl ;
1597: -- Standard call to check for call compatibility.
1598: IF NOT FND_API.Compatible_API_Call
1599: ( l_api_version_number
1600: ,p_api_version_number
1601: ,l_api_name
1602: ,G_PKG_NAME

Line 1605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1601: ,l_api_name
1602: ,G_PKG_NAME
1603: )
1604: THEN
1605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1606: END IF;
1607: -- Initialize message list if p_init_msg_list is set to TRUE.
1608: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1609: FND_MSG_PUB.initialize;

Line 1608: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1604: THEN
1605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1606: END IF;
1607: -- Initialize message list if p_init_msg_list is set to TRUE.
1608: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1609: FND_MSG_PUB.initialize;
1610: END IF;
1611: -- Debug Message
1612:

Line 1618: x_return_status := FND_API.G_RET_STS_SUCCESS;

1614: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1615: END IF;
1616:
1617: -- Initialize API return status to SUCCESS
1618: x_return_status := FND_API.G_RET_STS_SUCCESS;
1619: -- Validate Environment
1620: IF FND_GLOBAL.USER_ID IS NULL THEN
1621: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1622: RAISE FND_API.G_EXC_ERROR;

Line 1622: RAISE FND_API.G_EXC_ERROR;

1618: x_return_status := FND_API.G_RET_STS_SUCCESS;
1619: -- Validate Environment
1620: IF FND_GLOBAL.USER_ID IS NULL THEN
1621: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1622: RAISE FND_API.G_EXC_ERROR;
1623: END IF;
1624:
1625: -- validate all the required in parameters
1626: IF ( p_partner_id IS NULL OR p_partner_id = FND_API.G_MISS_NUM ) THEN

Line 1626: IF ( p_partner_id IS NULL OR p_partner_id = FND_API.G_MISS_NUM ) THEN

1622: RAISE FND_API.G_EXC_ERROR;
1623: END IF;
1624:
1625: -- validate all the required in parameters
1626: IF ( p_partner_id IS NULL OR p_partner_id = FND_API.G_MISS_NUM ) THEN
1627: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1628: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'PARTNER_ID' );
1629: FND_MSG_PUB.add;
1630: RAISE FND_API.G_EXC_ERROR;

Line 1630: RAISE FND_API.G_EXC_ERROR;

1626: IF ( p_partner_id IS NULL OR p_partner_id = FND_API.G_MISS_NUM ) THEN
1627: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1628: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'PARTNER_ID' );
1629: FND_MSG_PUB.add;
1630: RAISE FND_API.G_EXC_ERROR;
1631: END IF;
1632: IF ( p_old_partner_status = FND_API.G_MISS_CHAR OR p_old_partner_status is NULL ) THEN
1633: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1634: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'OLD PARTNER STATUS' );

Line 1632: IF ( p_old_partner_status = FND_API.G_MISS_CHAR OR p_old_partner_status is NULL ) THEN

1628: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'PARTNER_ID' );
1629: FND_MSG_PUB.add;
1630: RAISE FND_API.G_EXC_ERROR;
1631: END IF;
1632: IF ( p_old_partner_status = FND_API.G_MISS_CHAR OR p_old_partner_status is NULL ) THEN
1633: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1634: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'OLD PARTNER STATUS' );
1635: FND_MSG_PUB.add;
1636: RAISE FND_API.G_EXC_ERROR;

Line 1636: RAISE FND_API.G_EXC_ERROR;

1632: IF ( p_old_partner_status = FND_API.G_MISS_CHAR OR p_old_partner_status is NULL ) THEN
1633: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1634: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'OLD PARTNER STATUS' );
1635: FND_MSG_PUB.add;
1636: RAISE FND_API.G_EXC_ERROR;
1637: END IF;
1638: IF ( p_new_partner_status = FND_API.G_MISS_CHAR OR p_new_partner_status is NULL ) THEN
1639: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1640: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'NEW PARTNER STATUS' );

Line 1638: IF ( p_new_partner_status = FND_API.G_MISS_CHAR OR p_new_partner_status is NULL ) THEN

1634: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'OLD PARTNER STATUS' );
1635: FND_MSG_PUB.add;
1636: RAISE FND_API.G_EXC_ERROR;
1637: END IF;
1638: IF ( p_new_partner_status = FND_API.G_MISS_CHAR OR p_new_partner_status is NULL ) THEN
1639: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1640: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'NEW PARTNER STATUS' );
1641: FND_MSG_PUB.add;
1642: RAISE FND_API.G_EXC_ERROR;

Line 1642: RAISE FND_API.G_EXC_ERROR;

1638: IF ( p_new_partner_status = FND_API.G_MISS_CHAR OR p_new_partner_status is NULL ) THEN
1639: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1640: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'NEW PARTNER STATUS' );
1641: FND_MSG_PUB.add;
1642: RAISE FND_API.G_EXC_ERROR;
1643: END IF;
1644: IF ( p_new_partner_status = 'A' ) THEN
1645: IF ( p_chg_from_memb_type IS NULL OR p_chg_from_memb_type = FND_API.G_MISS_CHAR ) THEN
1646: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');

Line 1645: IF ( p_chg_from_memb_type IS NULL OR p_chg_from_memb_type = FND_API.G_MISS_CHAR ) THEN

1641: FND_MSG_PUB.add;
1642: RAISE FND_API.G_EXC_ERROR;
1643: END IF;
1644: IF ( p_new_partner_status = 'A' ) THEN
1645: IF ( p_chg_from_memb_type IS NULL OR p_chg_from_memb_type = FND_API.G_MISS_CHAR ) THEN
1646: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1647: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'CHANGE_FROM_MEMBER_TYPE' );
1648: FND_MSG_PUB.add;
1649: RAISE FND_API.G_EXC_ERROR;

Line 1649: RAISE FND_API.G_EXC_ERROR;

1645: IF ( p_chg_from_memb_type IS NULL OR p_chg_from_memb_type = FND_API.G_MISS_CHAR ) THEN
1646: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1647: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'CHANGE_FROM_MEMBER_TYPE' );
1648: FND_MSG_PUB.add;
1649: RAISE FND_API.G_EXC_ERROR;
1650: END IF;
1651:
1652: IF ( p_chg_to_memb_type IS NULL OR p_chg_to_memb_type = FND_API.G_MISS_CHAR ) THEN
1653: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');

Line 1652: IF ( p_chg_to_memb_type IS NULL OR p_chg_to_memb_type = FND_API.G_MISS_CHAR ) THEN

1648: FND_MSG_PUB.add;
1649: RAISE FND_API.G_EXC_ERROR;
1650: END IF;
1651:
1652: IF ( p_chg_to_memb_type IS NULL OR p_chg_to_memb_type = FND_API.G_MISS_CHAR ) THEN
1653: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1654: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'CHANGE_TO_MEMBER_TYPE' );
1655: FND_MSG_PUB.add;
1656: RAISE FND_API.G_EXC_ERROR;

Line 1656: RAISE FND_API.G_EXC_ERROR;

1652: IF ( p_chg_to_memb_type IS NULL OR p_chg_to_memb_type = FND_API.G_MISS_CHAR ) THEN
1653: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1654: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'CHANGE_TO_MEMBER_TYPE' );
1655: FND_MSG_PUB.add;
1656: RAISE FND_API.G_EXC_ERROR;
1657: END IF;
1658: IF ( p_chg_to_memb_type ='SUBSIDIARY' AND ( p_new_global_ptr_id IS NULL OR p_new_global_ptr_id = FND_API.G_MISS_NUM) ) THEN
1659: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1660: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'NEW GlOBAL PARTNER ID' );

Line 1658: IF ( p_chg_to_memb_type ='SUBSIDIARY' AND ( p_new_global_ptr_id IS NULL OR p_new_global_ptr_id = FND_API.G_MISS_NUM) ) THEN

1654: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'CHANGE_TO_MEMBER_TYPE' );
1655: FND_MSG_PUB.add;
1656: RAISE FND_API.G_EXC_ERROR;
1657: END IF;
1658: IF ( p_chg_to_memb_type ='SUBSIDIARY' AND ( p_new_global_ptr_id IS NULL OR p_new_global_ptr_id = FND_API.G_MISS_NUM) ) THEN
1659: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1660: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'NEW GlOBAL PARTNER ID' );
1661: FND_MSG_PUB.add;
1662: RAISE FND_API.G_EXC_ERROR;

Line 1662: RAISE FND_API.G_EXC_ERROR;

1658: IF ( p_chg_to_memb_type ='SUBSIDIARY' AND ( p_new_global_ptr_id IS NULL OR p_new_global_ptr_id = FND_API.G_MISS_NUM) ) THEN
1659: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1660: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'NEW GlOBAL PARTNER ID' );
1661: FND_MSG_PUB.add;
1662: RAISE FND_API.G_EXC_ERROR;
1663: IF ( p_chg_from_memb_type ='SUBSIDIARY'AND ( p_old_global_ptr_id IS NULL OR p_old_global_ptr_id = FND_API.G_MISS_NUM ) ) THEN
1664: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1665: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'OLD GlOBAL PARTNER ID' );
1666: FND_MSG_PUB.add;

Line 1663: IF ( p_chg_from_memb_type ='SUBSIDIARY'AND ( p_old_global_ptr_id IS NULL OR p_old_global_ptr_id = FND_API.G_MISS_NUM ) ) THEN

1659: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1660: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'NEW GlOBAL PARTNER ID' );
1661: FND_MSG_PUB.add;
1662: RAISE FND_API.G_EXC_ERROR;
1663: IF ( p_chg_from_memb_type ='SUBSIDIARY'AND ( p_old_global_ptr_id IS NULL OR p_old_global_ptr_id = FND_API.G_MISS_NUM ) ) THEN
1664: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1665: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'OLD GlOBAL PARTNER ID' );
1666: FND_MSG_PUB.add;
1667: RAISE FND_API.G_EXC_ERROR;

Line 1667: RAISE FND_API.G_EXC_ERROR;

1663: IF ( p_chg_from_memb_type ='SUBSIDIARY'AND ( p_old_global_ptr_id IS NULL OR p_old_global_ptr_id = FND_API.G_MISS_NUM ) ) THEN
1664: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1665: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'OLD GlOBAL PARTNER ID' );
1666: FND_MSG_PUB.add;
1667: RAISE FND_API.G_EXC_ERROR;
1668: END IF;
1669: END IF;
1670: END IF;
1671:

Line 1676: ,p_init_msg_list => FND_API.G_FALSE

1672: IF ( p_old_partner_status <> p_new_partner_status and p_new_partner_status ='I' ) THEN
1673: PV_PG_MEMBERSHIPS_PVT.Terminate_ptr_memberships
1674: (
1675: p_api_version_number => 1.0
1676: ,p_init_msg_list => FND_API.G_FALSE
1677: ,p_commit => FND_API.G_FALSE
1678: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1679: ,p_partner_id => p_partner_id
1680: ,p_memb_type => null

Line 1677: ,p_commit => FND_API.G_FALSE

1673: PV_PG_MEMBERSHIPS_PVT.Terminate_ptr_memberships
1674: (
1675: p_api_version_number => 1.0
1676: ,p_init_msg_list => FND_API.G_FALSE
1677: ,p_commit => FND_API.G_FALSE
1678: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1679: ,p_partner_id => p_partner_id
1680: ,p_memb_type => null
1681: ,p_status_reason_code => 'PTR_INACTIVE' -- it validates against PV_MEMB_STATUS_REASON_CODE

Line 1678: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1674: (
1675: p_api_version_number => 1.0
1676: ,p_init_msg_list => FND_API.G_FALSE
1677: ,p_commit => FND_API.G_FALSE
1678: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1679: ,p_partner_id => p_partner_id
1680: ,p_memb_type => null
1681: ,p_status_reason_code => 'PTR_INACTIVE' -- it validates against PV_MEMB_STATUS_REASON_CODE
1682: ,p_comments => null

Line 1687: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1683: ,x_return_status => x_return_status
1684: ,x_msg_count => x_msg_count
1685: ,x_msg_data => x_msg_data
1686: );
1687: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1688: RAISE FND_API.G_EXC_ERROR;
1689: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1691: END IF;

Line 1688: RAISE FND_API.G_EXC_ERROR;

1684: ,x_msg_count => x_msg_count
1685: ,x_msg_data => x_msg_data
1686: );
1687: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1688: RAISE FND_API.G_EXC_ERROR;
1689: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1691: END IF;
1692:

Line 1689: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1685: ,x_msg_data => x_msg_data
1686: );
1687: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1688: RAISE FND_API.G_EXC_ERROR;
1689: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1691: END IF;
1692:
1693: Register_term_ptr_memb_type

Line 1690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1686: );
1687: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1688: RAISE FND_API.G_EXC_ERROR;
1689: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1691: END IF;
1692:
1693: Register_term_ptr_memb_type
1694: (

Line 1696: , p_init_msg_list => FND_API.G_FALSE

1692:
1693: Register_term_ptr_memb_type
1694: (
1695: p_api_version_number => 1.0
1696: , p_init_msg_list => FND_API.G_FALSE
1697: , p_commit => FND_API.G_FALSE
1698: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1699: , p_partner_id => p_partner_id
1700: , p_current_memb_type => null

Line 1697: , p_commit => FND_API.G_FALSE

1693: Register_term_ptr_memb_type
1694: (
1695: p_api_version_number => 1.0
1696: , p_init_msg_list => FND_API.G_FALSE
1697: , p_commit => FND_API.G_FALSE
1698: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1699: , p_partner_id => p_partner_id
1700: , p_current_memb_type => null
1701: , p_new_memb_type => null

Line 1698: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

1694: (
1695: p_api_version_number => 1.0
1696: , p_init_msg_list => FND_API.G_FALSE
1697: , p_commit => FND_API.G_FALSE
1698: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1699: , p_partner_id => p_partner_id
1700: , p_current_memb_type => null
1701: , p_new_memb_type => null
1702: , p_global_ptr_id => null

Line 1707: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1703: , x_return_status => x_return_status
1704: , x_msg_count => x_msg_count
1705: , x_msg_data => x_msg_data
1706: );
1707: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1708: RAISE FND_API.G_EXC_ERROR;
1709: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1711: END IF;

Line 1708: RAISE FND_API.G_EXC_ERROR;

1704: , x_msg_count => x_msg_count
1705: , x_msg_data => x_msg_data
1706: );
1707: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1708: RAISE FND_API.G_EXC_ERROR;
1709: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1711: END IF;
1712:

Line 1709: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1705: , x_msg_data => x_msg_data
1706: );
1707: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1708: RAISE FND_API.G_EXC_ERROR;
1709: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1711: END IF;
1712:
1713: -- changed by paul on 28may04 as after discussion with Ravi and Karen

Line 1710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1706: );
1707: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1708: RAISE FND_API.G_EXC_ERROR;
1709: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1711: END IF;
1712:
1713: -- changed by paul on 28may04 as after discussion with Ravi and Karen
1714: -- to revoke responsibilities when partner is inactivated

Line 1717: ,p_init_msg_list => FND_API.G_FALSE

1713: -- changed by paul on 28may04 as after discussion with Ravi and Karen
1714: -- to revoke responsibilities when partner is inactivated
1715: Pv_User_Resp_Pvt.revoke_default_resp (
1716: p_api_version_number => 1.0
1717: ,p_init_msg_list => FND_API.G_FALSE
1718: ,p_commit => FND_API.G_FALSE
1719: ,x_return_status => x_return_status
1720: ,x_msg_count => x_msg_count
1721: ,x_msg_data => x_msg_data

Line 1718: ,p_commit => FND_API.G_FALSE

1714: -- to revoke responsibilities when partner is inactivated
1715: Pv_User_Resp_Pvt.revoke_default_resp (
1716: p_api_version_number => 1.0
1717: ,p_init_msg_list => FND_API.G_FALSE
1718: ,p_commit => FND_API.G_FALSE
1719: ,x_return_status => x_return_status
1720: ,x_msg_count => x_msg_count
1721: ,x_msg_data => x_msg_data
1722: ,p_partner_id => p_partner_id

Line 1725: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1721: ,x_msg_data => x_msg_data
1722: ,p_partner_id => p_partner_id
1723: );
1724:
1725: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1726: RAISE FND_API.G_EXC_ERROR;
1727: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1729: END IF;

Line 1726: RAISE FND_API.G_EXC_ERROR;

1722: ,p_partner_id => p_partner_id
1723: );
1724:
1725: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1726: RAISE FND_API.G_EXC_ERROR;
1727: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1729: END IF;
1730:

Line 1727: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1723: );
1724:
1725: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1726: RAISE FND_API.G_EXC_ERROR;
1727: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1729: END IF;
1730:
1731: ELSE

Line 1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1724:
1725: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1726: RAISE FND_API.G_EXC_ERROR;
1727: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1729: END IF;
1730:
1731: ELSE
1732:

Line 1737: , p_init_msg_list => FND_API.G_FALSE

1733: IF( p_new_partner_status ='A' and ( p_chg_from_memb_type <> p_chg_to_memb_type ) or ( p_old_global_ptr_id <> p_new_global_ptr_id and p_chg_to_memb_type ='SUBSIDIARY' ) ) THEN
1734: Process_ptr_member_type
1735: (
1736: p_api_version_number => 1.0
1737: , p_init_msg_list => FND_API.G_FALSE
1738: , p_commit => FND_API.G_FALSE
1739: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1740: , p_partner_id => p_partner_id
1741: , p_chg_from_memb_type => p_chg_from_memb_type

Line 1738: , p_commit => FND_API.G_FALSE

1734: Process_ptr_member_type
1735: (
1736: p_api_version_number => 1.0
1737: , p_init_msg_list => FND_API.G_FALSE
1738: , p_commit => FND_API.G_FALSE
1739: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1740: , p_partner_id => p_partner_id
1741: , p_chg_from_memb_type => p_chg_from_memb_type
1742: , p_chg_to_memb_type => p_chg_to_memb_type

Line 1739: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

1735: (
1736: p_api_version_number => 1.0
1737: , p_init_msg_list => FND_API.G_FALSE
1738: , p_commit => FND_API.G_FALSE
1739: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1740: , p_partner_id => p_partner_id
1741: , p_chg_from_memb_type => p_chg_from_memb_type
1742: , p_chg_to_memb_type => p_chg_to_memb_type
1743: , p_chg_to_global_ptr_id => p_new_global_ptr_id

Line 1749: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1745: , x_msg_count => x_msg_count
1746: , x_msg_data => x_msg_data
1747: );
1748:
1749: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1750: RAISE FND_API.G_EXC_ERROR;
1751: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1753: END IF;

Line 1750: RAISE FND_API.G_EXC_ERROR;

1746: , x_msg_data => x_msg_data
1747: );
1748:
1749: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1750: RAISE FND_API.G_EXC_ERROR;
1751: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1753: END IF;
1754: IF p_chg_from_memb_type<>p_chg_to_memb_type THEN

Line 1751: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1747: );
1748:
1749: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1750: RAISE FND_API.G_EXC_ERROR;
1751: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1753: END IF;
1754: IF p_chg_from_memb_type<>p_chg_to_memb_type THEN
1755: --set the message the member type has been changed.

Line 1752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1748:
1749: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1750: RAISE FND_API.G_EXC_ERROR;
1751: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1753: END IF;
1754: IF p_chg_from_memb_type<>p_chg_to_memb_type THEN
1755: --set the message the member type has been changed.
1756: -- call the history log api.

Line 1782: , p_init_msg_list => FND_API.g_false

1778: , p_partner_id => p_partner_id
1779: , p_access_level_flag => 'P'
1780: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50
1781: , p_log_params_tbl => l_param_tbl_var
1782: , p_init_msg_list => FND_API.g_false
1783: , p_commit => FND_API.G_FALSE
1784: , x_return_status => x_return_status
1785: , x_msg_count => x_msg_count
1786: , x_msg_data => x_msg_data

Line 1783: , p_commit => FND_API.G_FALSE

1779: , p_access_level_flag => 'P'
1780: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50
1781: , p_log_params_tbl => l_param_tbl_var
1782: , p_init_msg_list => FND_API.g_false
1783: , p_commit => FND_API.G_FALSE
1784: , x_return_status => x_return_status
1785: , x_msg_count => x_msg_count
1786: , x_msg_data => x_msg_data
1787: );

Line 1788: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1784: , x_return_status => x_return_status
1785: , x_msg_count => x_msg_count
1786: , x_msg_data => x_msg_data
1787: );
1788: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1789: RAISE FND_API.G_EXC_ERROR;
1790: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1792: END IF;

Line 1789: RAISE FND_API.G_EXC_ERROR;

1785: , x_msg_count => x_msg_count
1786: , x_msg_data => x_msg_data
1787: );
1788: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1789: RAISE FND_API.G_EXC_ERROR;
1790: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1792: END IF;
1793:

Line 1790: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1786: , x_msg_data => x_msg_data
1787: );
1788: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1789: RAISE FND_API.G_EXC_ERROR;
1790: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1792: END IF;
1793:
1794: ELSIF p_chg_from_memb_type=p_chg_to_memb_type AND p_old_global_ptr_id <> p_new_global_ptr_id and p_chg_to_memb_type ='SUBSIDIARY' THEN

Line 1791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1787: );
1788: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1789: RAISE FND_API.G_EXC_ERROR;
1790: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1792: END IF;
1793:
1794: ELSIF p_chg_from_memb_type=p_chg_to_memb_type AND p_old_global_ptr_id <> p_new_global_ptr_id and p_chg_to_memb_type ='SUBSIDIARY' THEN
1795: --set the message that the subsidiary partners global organisation has changed.

Line 1822: , p_init_msg_list => FND_API.g_false

1818: , p_partner_id => p_partner_id
1819: , p_access_level_flag => 'P'
1820: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50
1821: , p_log_params_tbl => l_param_tbl_var1
1822: , p_init_msg_list => FND_API.g_false
1823: , p_commit => FND_API.G_FALSE
1824: , x_return_status => x_return_status
1825: , x_msg_count => x_msg_count
1826: , x_msg_data => x_msg_data

Line 1823: , p_commit => FND_API.G_FALSE

1819: , p_access_level_flag => 'P'
1820: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50
1821: , p_log_params_tbl => l_param_tbl_var1
1822: , p_init_msg_list => FND_API.g_false
1823: , p_commit => FND_API.G_FALSE
1824: , x_return_status => x_return_status
1825: , x_msg_count => x_msg_count
1826: , x_msg_data => x_msg_data
1827: );

Line 1829: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1825: , x_msg_count => x_msg_count
1826: , x_msg_data => x_msg_data
1827: );
1828:
1829: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1830: RAISE FND_API.G_EXC_ERROR;
1831: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1833: END IF;

Line 1830: RAISE FND_API.G_EXC_ERROR;

1826: , x_msg_data => x_msg_data
1827: );
1828:
1829: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1830: RAISE FND_API.G_EXC_ERROR;
1831: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1833: END IF;
1834:

Line 1831: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1827: );
1828:
1829: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1830: RAISE FND_API.G_EXC_ERROR;
1831: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1833: END IF;
1834:
1835: END IF;

Line 1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1828:
1829: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1830: RAISE FND_API.G_EXC_ERROR;
1831: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1833: END IF;
1834:
1835: END IF;
1836:

Line 1852: IF FND_API.to_Boolean( p_commit ) THEN

1848: IF (PV_DEBUG_HIGH_ON) THEN
1849: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1850: END IF;
1851:
1852: IF FND_API.to_Boolean( p_commit ) THEN
1853: COMMIT WORK;
1854: END IF;
1855:
1856: EXCEPTION

Line 1857: WHEN FND_API.G_EXC_ERROR THEN

1853: COMMIT WORK;
1854: END IF;
1855:
1856: EXCEPTION
1857: WHEN FND_API.G_EXC_ERROR THEN
1858: ROLLBACK TO update_partner_dtl;
1859: x_return_status := FND_API.G_RET_STS_ERROR;
1860: -- Standard call to get message count and if count=1, get the message
1861: FND_MSG_PUB.Count_And_Get (

Line 1859: x_return_status := FND_API.G_RET_STS_ERROR;

1855:
1856: EXCEPTION
1857: WHEN FND_API.G_EXC_ERROR THEN
1858: ROLLBACK TO update_partner_dtl;
1859: x_return_status := FND_API.G_RET_STS_ERROR;
1860: -- Standard call to get message count and if count=1, get the message
1861: FND_MSG_PUB.Count_And_Get (
1862: p_encoded => FND_API.G_FALSE,
1863: p_count => x_msg_count,

Line 1862: p_encoded => FND_API.G_FALSE,

1858: ROLLBACK TO update_partner_dtl;
1859: x_return_status := FND_API.G_RET_STS_ERROR;
1860: -- Standard call to get message count and if count=1, get the message
1861: FND_MSG_PUB.Count_And_Get (
1862: p_encoded => FND_API.G_FALSE,
1863: p_count => x_msg_count,
1864: p_data => x_msg_data
1865: );
1866:

Line 1867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1863: p_count => x_msg_count,
1864: p_data => x_msg_data
1865: );
1866:
1867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1868: ROLLBACK TO update_partner_dtl;
1869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1870: -- Standard call to get message count and if count=1, get the message
1871: FND_MSG_PUB.Count_And_Get (

Line 1869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1865: );
1866:
1867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1868: ROLLBACK TO update_partner_dtl;
1869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,

Line 1872: p_encoded => FND_API.G_FALSE,

1868: ROLLBACK TO update_partner_dtl;
1869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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 1879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1875: );
1876:
1877: WHEN OTHERS THEN
1878: ROLLBACK TO update_partner_dtl;
1879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1880: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1881: THEN
1882: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1883: END IF;

Line 1886: p_encoded => FND_API.G_FALSE,

1882: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1883: END IF;
1884: -- Standard call to get message count and if count=1, get the message
1885: FND_MSG_PUB.Count_And_Get (
1886: p_encoded => FND_API.G_FALSE,
1887: p_count => x_msg_count,
1888: p_data => x_msg_data
1889: );
1890: