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_PARTNER_ATTR_LOAD_PUB dependencies on FND_API

Line 951: p_init_msg_list => FND_API.G_FALSE,

947:
948:
949: HZ_CUST_ACCOUNT_V2PUB.create_cust_account
950: (
951: p_init_msg_list => FND_API.G_FALSE,
952: p_cust_account_rec => l_account_rec,
953: p_organization_rec => l_organization_rec,
954: p_customer_profile_rec => l_cust_profile_rec,
955: p_create_profile_amt => FND_API.G_TRUE,

Line 955: p_create_profile_amt => FND_API.G_TRUE,

951: p_init_msg_list => FND_API.G_FALSE,
952: p_cust_account_rec => l_account_rec,
953: p_organization_rec => l_organization_rec,
954: p_customer_profile_rec => l_cust_profile_rec,
955: p_create_profile_amt => FND_API.G_TRUE,
956: x_cust_account_id => l_cust_account_id,
957: x_account_number => l_account_number,
958: x_party_id => l_party_id,
959: x_party_number => l_party_number,

Line 967: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

963: x_msg_data => l_msg_data
964: );
965:
966:
967: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
968: --dbms_output.put_line('Error Occured: ');
969: --dbms_output.put_line('Error: ' || l_msg_data);
970: FOR l_msg_index IN 1..l_msg_count LOOP
971: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_index));

Line 994: ,p_init_msg_list => FND_API.G_FALSE

990:
991: begin
992: PV_PARTNER_UTIL_PVT.Create_Relationship(
993: p_api_version_number => 1.0
994: ,p_init_msg_list => FND_API.G_FALSE
995: ,p_commit => FND_API.G_FALSE
996: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
997: ,x_return_status => l_return_status
998: ,x_msg_data => l_msg_data

Line 995: ,p_commit => FND_API.G_FALSE

991: begin
992: PV_PARTNER_UTIL_PVT.Create_Relationship(
993: p_api_version_number => 1.0
994: ,p_init_msg_list => FND_API.G_FALSE
995: ,p_commit => FND_API.G_FALSE
996: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
997: ,x_return_status => l_return_status
998: ,x_msg_data => l_msg_data
999: ,x_msg_count => l_msg_count

Line 996: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

992: PV_PARTNER_UTIL_PVT.Create_Relationship(
993: p_api_version_number => 1.0
994: ,p_init_msg_list => FND_API.G_FALSE
995: ,p_commit => FND_API.G_FALSE
996: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
997: ,x_return_status => l_return_status
998: ,x_msg_data => l_msg_data
999: ,x_msg_count => l_msg_count
1000: ,p_party_id => l_party_id

Line 1013: WHEN FND_API.g_exc_error THEN

1009: );
1010:
1011: EXCEPTION
1012:
1013: WHEN FND_API.g_exc_error THEN
1014: l_return_status := FND_API.g_ret_sts_error;
1015: FND_MSG_PUB.count_and_get (
1016: p_encoded => FND_API.g_false
1017: ,p_count => l_msg_count

Line 1014: l_return_status := FND_API.g_ret_sts_error;

1010:
1011: EXCEPTION
1012:
1013: WHEN FND_API.g_exc_error THEN
1014: l_return_status := FND_API.g_ret_sts_error;
1015: FND_MSG_PUB.count_and_get (
1016: p_encoded => FND_API.g_false
1017: ,p_count => l_msg_count
1018: ,p_data => l_msg_data

Line 1016: p_encoded => FND_API.g_false

1012:
1013: WHEN FND_API.g_exc_error THEN
1014: l_return_status := FND_API.g_ret_sts_error;
1015: FND_MSG_PUB.count_and_get (
1016: p_encoded => FND_API.g_false
1017: ,p_count => l_msg_count
1018: ,p_data => l_msg_data
1019: );
1020: --dbms_output.put_line('Message : ' || l_msg_data );

Line 1021: WHEN FND_API.g_exc_unexpected_error THEN

1017: ,p_count => l_msg_count
1018: ,p_data => l_msg_data
1019: );
1020: --dbms_output.put_line('Message : ' || l_msg_data );
1021: WHEN FND_API.g_exc_unexpected_error THEN
1022: l_return_status := FND_API.g_ret_sts_unexp_error ;
1023: FND_MSG_PUB.count_and_get (
1024: p_encoded => FND_API.g_false
1025: ,p_count => l_msg_count

Line 1022: l_return_status := FND_API.g_ret_sts_unexp_error ;

1018: ,p_data => l_msg_data
1019: );
1020: --dbms_output.put_line('Message : ' || l_msg_data );
1021: WHEN FND_API.g_exc_unexpected_error THEN
1022: l_return_status := FND_API.g_ret_sts_unexp_error ;
1023: FND_MSG_PUB.count_and_get (
1024: p_encoded => FND_API.g_false
1025: ,p_count => l_msg_count
1026: ,p_data => l_msg_data

Line 1024: p_encoded => FND_API.g_false

1020: --dbms_output.put_line('Message : ' || l_msg_data );
1021: WHEN FND_API.g_exc_unexpected_error THEN
1022: l_return_status := FND_API.g_ret_sts_unexp_error ;
1023: FND_MSG_PUB.count_and_get (
1024: p_encoded => FND_API.g_false
1025: ,p_count => l_msg_count
1026: ,p_data => l_msg_data
1027: );
1028: --dbms_output.put_line('Message : ' || l_msg_data );

Line 1032: l_return_status := FND_API.g_ret_sts_unexp_error ;

1028: --dbms_output.put_line('Message : ' || l_msg_data );
1029:
1030: WHEN OTHERS THEN
1031: --dbms_output.put_line('Exception ' || sqlerrm);
1032: l_return_status := FND_API.g_ret_sts_unexp_error ;
1033: FND_MSG_PUB.count_and_get (
1034: p_encoded => FND_API.g_false
1035: ,p_count => l_msg_count
1036: ,p_data => l_msg_data

Line 1034: p_encoded => FND_API.g_false

1030: WHEN OTHERS THEN
1031: --dbms_output.put_line('Exception ' || sqlerrm);
1032: l_return_status := FND_API.g_ret_sts_unexp_error ;
1033: FND_MSG_PUB.count_and_get (
1034: p_encoded => FND_API.g_false
1035: ,p_count => l_msg_count
1036: ,p_data => l_msg_data
1037: );
1038:

Line 1043: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1039: END;
1040: --dbms_output.put_line('Return status for Create_Rela : ' || l_return_status);
1041: --dbms_output.put_line('Message: ' || l_msg_data);
1042:
1043: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1044: --dbms_output.put_line('Error Occured: ');
1045: --dbms_output.put_line('Error: ' || l_msg_data);
1046: FOR l_msg_index IN 1..l_msg_count LOOP
1047: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_index));

Line 1258: RAISE FND_API.g_exc_error;

1254: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1255: FND_MESSAGE.set_name('PV', 'PV_NO_RECORD_FOUND');
1256: FND_MSG_PUB.add;
1257: END IF;
1258: RAISE FND_API.g_exc_error;
1259: END IF;
1260: CLOSE c_prtnr_prfls;
1261:
1262: IF p_prtnr_prfls_rec.partner_id is null THEN

Line 1538: ,p_init_msg_list => FND_API.g_true

1534: --dbms_output.put_line('Calling upsert for : ' || l_attribute_id);
1535: --dbms_output.put_line('ATTR VALUE EXTN: ' || l_partner_types_tbl(1).attr_value_extn);
1536: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value (
1537: p_api_version_number=> 1.0
1538: ,p_init_msg_list => FND_API.g_true
1539: ,p_commit => FND_API.g_false
1540: ,p_validation_level => FND_API.g_valid_level_full
1541: ,x_return_status => l_return_status
1542: ,x_msg_count => l_msg_count

Line 1539: ,p_commit => FND_API.g_false

1535: --dbms_output.put_line('ATTR VALUE EXTN: ' || l_partner_types_tbl(1).attr_value_extn);
1536: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value (
1537: p_api_version_number=> 1.0
1538: ,p_init_msg_list => FND_API.g_true
1539: ,p_commit => FND_API.g_false
1540: ,p_validation_level => FND_API.g_valid_level_full
1541: ,x_return_status => l_return_status
1542: ,x_msg_count => l_msg_count
1543: ,x_msg_data => l_msg_data

Line 1540: ,p_validation_level => FND_API.g_valid_level_full

1536: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value (
1537: p_api_version_number=> 1.0
1538: ,p_init_msg_list => FND_API.g_true
1539: ,p_commit => FND_API.g_false
1540: ,p_validation_level => FND_API.g_valid_level_full
1541: ,x_return_status => l_return_status
1542: ,x_msg_count => l_msg_count
1543: ,x_msg_data => l_msg_data
1544: ,p_attribute_id => l_attribute_id

Line 1551: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1547: ,p_version => l_version
1548: ,p_attr_val_tbl => l_partner_types_tbl
1549: );
1550:
1551: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1552: --FOR l_msg_index IN 1..l_msg_count LOOP
1553: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));
1554: l_errors_tbl(l_error_count) := substrb(fnd_message.get, 1, 1000);
1555: l_error_count := l_error_count +1;

Line 1598: ,p_init_msg_list => FND_API.g_true

1594:
1595: l_complete_prtnr_prfls_rec.partner_level := l_new_partner_level_id;
1596: PVX_PRTNR_PRFLS_PVT.Update_Prtnr_Prfls(
1597: p_api_version => 1.0
1598: ,p_init_msg_list => FND_API.g_true
1599: ,p_commit => FND_API.g_false
1600: ,p_validation_level => FND_API.g_valid_level_full
1601: ,x_return_status => l_return_status
1602: ,x_msg_count => l_msg_count

Line 1599: ,p_commit => FND_API.g_false

1595: l_complete_prtnr_prfls_rec.partner_level := l_new_partner_level_id;
1596: PVX_PRTNR_PRFLS_PVT.Update_Prtnr_Prfls(
1597: p_api_version => 1.0
1598: ,p_init_msg_list => FND_API.g_true
1599: ,p_commit => FND_API.g_false
1600: ,p_validation_level => FND_API.g_valid_level_full
1601: ,x_return_status => l_return_status
1602: ,x_msg_count => l_msg_count
1603: ,x_msg_data => l_msg_data

Line 1600: ,p_validation_level => FND_API.g_valid_level_full

1596: PVX_PRTNR_PRFLS_PVT.Update_Prtnr_Prfls(
1597: p_api_version => 1.0
1598: ,p_init_msg_list => FND_API.g_true
1599: ,p_commit => FND_API.g_false
1600: ,p_validation_level => FND_API.g_valid_level_full
1601: ,x_return_status => l_return_status
1602: ,x_msg_count => l_msg_count
1603: ,x_msg_data => l_msg_data
1604: ,p_prtnr_prfls_rec => l_complete_prtnr_prfls_rec);

Line 1608: WHEN FND_API.g_exc_error THEN

1604: ,p_prtnr_prfls_rec => l_complete_prtnr_prfls_rec);
1605:
1606: EXCEPTION
1607:
1608: WHEN FND_API.g_exc_error THEN
1609: l_return_status := FND_API.g_ret_sts_error;
1610: FND_MSG_PUB.count_and_get (
1611: p_encoded => FND_API.g_false
1612: ,p_count => l_msg_count

Line 1609: l_return_status := FND_API.g_ret_sts_error;

1605:
1606: EXCEPTION
1607:
1608: WHEN FND_API.g_exc_error THEN
1609: l_return_status := FND_API.g_ret_sts_error;
1610: FND_MSG_PUB.count_and_get (
1611: p_encoded => FND_API.g_false
1612: ,p_count => l_msg_count
1613: ,p_data => l_msg_data

Line 1611: p_encoded => FND_API.g_false

1607:
1608: WHEN FND_API.g_exc_error THEN
1609: l_return_status := FND_API.g_ret_sts_error;
1610: FND_MSG_PUB.count_and_get (
1611: p_encoded => FND_API.g_false
1612: ,p_count => l_msg_count
1613: ,p_data => l_msg_data
1614: );
1615: --dbms_output.put_line('Message : ' || l_msg_data );

Line 1616: WHEN FND_API.g_exc_unexpected_error THEN

1612: ,p_count => l_msg_count
1613: ,p_data => l_msg_data
1614: );
1615: --dbms_output.put_line('Message : ' || l_msg_data );
1616: WHEN FND_API.g_exc_unexpected_error THEN
1617: l_return_status := FND_API.g_ret_sts_unexp_error ;
1618: FND_MSG_PUB.count_and_get (
1619: p_encoded => FND_API.g_false
1620: ,p_count => l_msg_count

Line 1617: l_return_status := FND_API.g_ret_sts_unexp_error ;

1613: ,p_data => l_msg_data
1614: );
1615: --dbms_output.put_line('Message : ' || l_msg_data );
1616: WHEN FND_API.g_exc_unexpected_error THEN
1617: l_return_status := FND_API.g_ret_sts_unexp_error ;
1618: FND_MSG_PUB.count_and_get (
1619: p_encoded => FND_API.g_false
1620: ,p_count => l_msg_count
1621: ,p_data => l_msg_data

Line 1619: p_encoded => FND_API.g_false

1615: --dbms_output.put_line('Message : ' || l_msg_data );
1616: WHEN FND_API.g_exc_unexpected_error THEN
1617: l_return_status := FND_API.g_ret_sts_unexp_error ;
1618: FND_MSG_PUB.count_and_get (
1619: p_encoded => FND_API.g_false
1620: ,p_count => l_msg_count
1621: ,p_data => l_msg_data
1622: );
1623: --dbms_output.put_line('Message : ' || l_msg_data );

Line 1625: l_return_status := FND_API.g_ret_sts_unexp_error ;

1621: ,p_data => l_msg_data
1622: );
1623: --dbms_output.put_line('Message : ' || l_msg_data );
1624: WHEN OTHERS THEN
1625: l_return_status := FND_API.g_ret_sts_unexp_error ;
1626: FND_MSG_PUB.count_and_get (
1627: p_encoded => FND_API.g_false
1628: ,p_count => l_msg_count
1629: ,p_data => l_msg_data

Line 1627: p_encoded => FND_API.g_false

1623: --dbms_output.put_line('Message : ' || l_msg_data );
1624: WHEN OTHERS THEN
1625: l_return_status := FND_API.g_ret_sts_unexp_error ;
1626: FND_MSG_PUB.count_and_get (
1627: p_encoded => FND_API.g_false
1628: ,p_count => l_msg_count
1629: ,p_data => l_msg_data
1630: );
1631: END;

Line 1633: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1629: ,p_data => l_msg_data
1630: );
1631: END;
1632:
1633: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1634: FOR l_msg_index IN 1..l_msg_count LOOP
1635: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_index));
1636: l_errors_tbl(l_error_count) := substrb(fnd_message.get, 1, 1000);
1637: l_error_count := l_error_count +1;

Line 1655: p_init_msg_list => FND_API.g_true,

1651:
1652: PV_TERR_ASSIGN_PUB.Update_Channel_Team
1653: (
1654: p_api_version_number => 1.0,
1655: p_init_msg_list => FND_API.g_true,
1656: p_commit => FND_API.g_false,
1657: p_validation_level => FND_API.g_valid_level_full,
1658: x_return_status => l_return_status,
1659: x_msg_count => l_msg_count,

Line 1656: p_commit => FND_API.g_false,

1652: PV_TERR_ASSIGN_PUB.Update_Channel_Team
1653: (
1654: p_api_version_number => 1.0,
1655: p_init_msg_list => FND_API.g_true,
1656: p_commit => FND_API.g_false,
1657: p_validation_level => FND_API.g_valid_level_full,
1658: x_return_status => l_return_status,
1659: x_msg_count => l_msg_count,
1660: x_msg_data => l_msg_data,

Line 1657: p_validation_level => FND_API.g_valid_level_full,

1653: (
1654: p_api_version_number => 1.0,
1655: p_init_msg_list => FND_API.g_true,
1656: p_commit => FND_API.g_false,
1657: p_validation_level => FND_API.g_valid_level_full,
1658: x_return_status => l_return_status,
1659: x_msg_count => l_msg_count,
1660: x_msg_data => l_msg_data,
1661: p_partner_id => p_entity_id,

Line 1669: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1665: p_upd_prtnr_qflr_flg_rec => l_prtnr_qflr_flg_rec,
1666: x_prtnr_access_id_tbl => l_prtnr_access_id_tbl
1667: );
1668:
1669: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1670: FOR l_msg_index IN 1..l_msg_count LOOP
1671: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_index));
1672: l_errors_tbl(l_error_count) := substrb(fnd_message.get, 1, 1000);
1673: l_error_count := l_error_count +1;

Line 1698: p_init_msg_list => FND_API.g_true,

1694: p_access_level_flag => 'V',
1695: p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50,
1696: p_comments => Null,
1697: p_log_params_tbl => l_log_params_tbl,
1698: p_init_msg_list => FND_API.g_true,
1699: p_commit => FND_API.g_false,
1700: x_return_status => l_return_status,
1701: x_msg_count => l_msg_count,
1702: x_msg_data => l_msg_data

Line 1699: p_commit => FND_API.g_false,

1695: p_interaction_level => PVX_Utility_PVT.G_INTERACTION_LEVEL_50,
1696: p_comments => Null,
1697: p_log_params_tbl => l_log_params_tbl,
1698: p_init_msg_list => FND_API.g_true,
1699: p_commit => FND_API.g_false,
1700: x_return_status => l_return_status,
1701: x_msg_count => l_msg_count,
1702: x_msg_data => l_msg_data
1703: );

Line 1704: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1700: x_return_status => l_return_status,
1701: x_msg_count => l_msg_count,
1702: x_msg_data => l_msg_data
1703: );
1704: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1705: FOR l_msg_index IN 1..l_msg_count LOOP
1706: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_index));
1707: l_errors_tbl(l_error_count) := substrb(fnd_message.get, 1, 1000);
1708: l_error_count := l_error_count +1;

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

1740: -- End of Comments
1741: PROCEDURE Load_Partners
1742: (
1743: p_api_version_number IN NUMBER
1744: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1745: ,p_mode IN VARCHAR2
1746: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1747: ,x_return_status OUT NOCOPY VARCHAR2
1748: ,x_msg_data OUT NOCOPY VARCHAR2

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

1742: (
1743: p_api_version_number IN NUMBER
1744: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1745: ,p_mode IN VARCHAR2
1746: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1747: ,x_return_status OUT NOCOPY VARCHAR2
1748: ,x_msg_data OUT NOCOPY VARCHAR2
1749: ,x_msg_count OUT NOCOPY NUMBER
1750: ,p_partner_details_tbl IN partner_details_tbl_type

Line 2100: utl_file.put_line(L_LOG_FILE,Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,1000));

2096: --dbms_output.put_line('Exception Occured ' || SQLERRM);
2097: ROLLBACK;
2098: utl_file.put_line(L_LOG_FILE,SQLERRM);
2099: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
2100: utl_file.put_line(L_LOG_FILE,Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,1000));
2101: --dbms_output.put_line('error handling ');
2102: END LOOP;
2103: utl_file.fclose(l_log_file);
2104: