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 PVX_UTILITY_PVT

Line 123: l_lookup_exists := PVX_UTILITY_PVT.check_lookup_exists

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
126: ,p_lookup_code => p_lookup_code
127: );

Line 422: l_param_tbl_var PVX_UTILITY_PVT.log_params_tbl_type;

418: l_check_status VARCHAR2(1) :='N';
419: l_start_date DATE;
420: l_from_memb_type VARCHAR2(30);
421: l_to_memb_type VARCHAR2(30);
422: l_param_tbl_var PVX_UTILITY_PVT.log_params_tbl_type;
423: l_param_tbl_var1 PVX_UTILITY_PVT.log_params_tbl_type;
424: l_party_name VARCHAR2(360) ;
425: BEGIN
426: -- Standard Start of API savepoint

Line 423: l_param_tbl_var1 PVX_UTILITY_PVT.log_params_tbl_type;

419: l_start_date DATE;
420: l_from_memb_type VARCHAR2(30);
421: l_to_memb_type VARCHAR2(30);
422: l_param_tbl_var PVX_UTILITY_PVT.log_params_tbl_type;
423: l_param_tbl_var1 PVX_UTILITY_PVT.log_params_tbl_type;
424: l_party_name VARCHAR2(360) ;
425: BEGIN
426: -- Standard Start of API savepoint
427: SAVEPOINT Register_term_ptr_memb_type;

Line 445: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

441: END IF;
442: -- Debug Message
443:
444: IF (PV_DEBUG_HIGH_ON) THEN
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;

Line 452: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

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;
454: END IF;
455:
456: -- find out the existing the member type if its not passed in.. If its passed , validate it

Line 578: PVX_UTILITY_PVT.create_history_log

574:
575: l_param_tbl_var1(1).param_name := 'PARTNER_NAME';
576: l_param_tbl_var1(1).param_value := l_party_name;
577:
578: PVX_UTILITY_PVT.create_history_log
579: (
580: p_arc_history_for_entity_code => 'GENERAL'
581: , p_history_for_entity_id => subs.partner_id
582: , p_history_category_code => 'PARTNER'

Line 587: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50

583: , p_message_code => 'PV_GLOBAL_MB_TYPE_CHANGE'
584: , p_comments => null
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

Line 614: PVX_UTILITY_PVT.create_history_log

610: l_param_tbl_var(1).param_value := l_from_memb_type;
611: l_param_tbl_var(2).param_name := 'TO_MEMB_TYPE';
612: l_param_tbl_var(2).param_value := l_to_memb_type ;
613:
614: PVX_UTILITY_PVT.create_history_log
615: (
616: p_arc_history_for_entity_code => 'GENERAL'
617: , p_history_for_entity_id => subs.partner_id
618: , p_history_category_code => 'PARTNER'

Line 623: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50

619: , p_message_code => 'PV_MEMBER_TYPE_CHANGE'
620: , p_comments => null
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

Line 881: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

877: p_data => x_msg_data
878: );
879:
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;

Line 1006: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1002: FND_MSG_PUB.initialize;
1003: END IF;
1004: -- Debug Message
1005: IF (PV_DEBUG_HIGH_ON) THEN
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;

Line 1013: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

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;
1015: END IF;
1016:
1017: --terminate program memberships before terminating relationship

Line 1139: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1135: p_count => x_msg_count
1136: , p_data => x_msg_data
1137: );
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;

Line 1574: l_param_tbl_var PVX_UTILITY_PVT.log_params_tbl_type;

1570: ) IS
1571: l_api_version_number CONSTANT NUMBER := 1.0;
1572: l_api_name CONSTANT VARCHAR2(30) := 'update_partner_dtl';
1573: l_to_memb_type VARCHAR2(30);
1574: l_param_tbl_var PVX_UTILITY_PVT.log_params_tbl_type;
1575: l_param_tbl_var1 PVX_UTILITY_PVT.log_params_tbl_type;
1576: l_from_memb_type VARCHAR2(30);
1577: l_from_party_name VARCHAR2(360);
1578: l_to_party_name VARCHAR2(360);

Line 1575: l_param_tbl_var1 PVX_UTILITY_PVT.log_params_tbl_type;

1571: l_api_version_number CONSTANT NUMBER := 1.0;
1572: l_api_name CONSTANT VARCHAR2(30) := 'update_partner_dtl';
1573: l_to_memb_type VARCHAR2(30);
1574: l_param_tbl_var PVX_UTILITY_PVT.log_params_tbl_type;
1575: l_param_tbl_var1 PVX_UTILITY_PVT.log_params_tbl_type;
1576: l_from_memb_type VARCHAR2(30);
1577: l_from_party_name VARCHAR2(360);
1578: l_to_party_name VARCHAR2(360);
1579:

Line 1614: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1610: END IF;
1611: -- Debug Message
1612:
1613: IF (PV_DEBUG_HIGH_ON) THEN
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;

Line 1621: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

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;
1623: END IF;
1624:
1625: -- validate all the required in parameters

Line 1771: PVX_UTILITY_PVT.create_history_log

1767: l_param_tbl_var(2).param_name := 'TO_MEMB_TYPE';
1768: l_param_tbl_var(2).param_value := l_to_memb_type ;
1769:
1770:
1771: PVX_UTILITY_PVT.create_history_log
1772: (
1773: p_arc_history_for_entity_code => 'GENERAL'
1774: , p_history_for_entity_id => p_partner_id
1775: , p_history_category_code => 'PARTNER'

Line 1780: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50

1776: , p_message_code => 'PV_MEMBER_TYPE_CHANGE'
1777: , p_comments => null
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

Line 1811: PVX_UTILITY_PVT.create_history_log

1807:
1808: l_param_tbl_var1(2).param_name := 'TO_PARTNER_NAME';
1809: l_param_tbl_var1(2).param_value := l_to_party_name;
1810:
1811: PVX_UTILITY_PVT.create_history_log
1812: (
1813: p_arc_history_for_entity_code => 'GENERAL'
1814: , p_history_for_entity_id => p_partner_id
1815: , p_history_category_code => 'PARTNER'

Line 1820: , p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50

1816: , p_message_code => 'PV_GLOBAL_PARTNER_CHANGE'
1817: , p_comments => null
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

Line 1849: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1845: , p_data => x_msg_data
1846: );
1847:
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;