DBA Data[Home] [Help]

APPS.PV_PARTNER_ATTR_LOAD_PUB dependencies on FND_MSG_PUB

Line 971: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_index));

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));
972: l_errors_tbl(l_error_count) := substrb(fnd_message.get, 1, 1000);
973: l_error_count := l_error_count +1;
974: --dbms_output.put_line('Error Details: ');
975: --dbms_output.put_line(substr(apps.fnd_message.get,1,254));

Line 1015: FND_MSG_PUB.count_and_get (

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
1019: );

Line 1023: FND_MSG_PUB.count_and_get (

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
1027: );

Line 1033: FND_MSG_PUB.count_and_get (

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
1037: );

Line 1047: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_index));

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));
1048: l_errors_tbl(l_error_count) := substrb(fnd_message.get, 1, 1000);
1049: l_error_count := l_error_count +1;
1050: --dbms_output.put_line('Error Details: ');
1051: --dbms_output.put_line(substr(apps.fnd_message.get,1,254));

Line 1254: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1250: OPEN c_prtnr_prfls;
1251: FETCH c_prtnr_prfls INTO l_prtnr_prfls_rec;
1252: IF c_prtnr_prfls%NOTFOUND THEN
1253: CLOSE c_prtnr_prfls;
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;

Line 1256: FND_MSG_PUB.add;

1252: IF c_prtnr_prfls%NOTFOUND THEN
1253: CLOSE c_prtnr_prfls;
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;

Line 1553: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));

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;
1556: --dbms_output.put_line(substr(apps.fnd_message.get,1,254));
1557: -- END LOOP;

Line 1610: FND_MSG_PUB.count_and_get (

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
1614: );

Line 1618: FND_MSG_PUB.count_and_get (

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
1622: );

Line 1626: FND_MSG_PUB.count_and_get (

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
1630: );

Line 1635: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_index));

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;
1638: --dbms_output.put_line(substr(apps.fnd_message.get,1,254));
1639: END LOOP;

Line 1671: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_index));

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;
1674: --dbms_output.put_line(substr(apps.fnd_message.get,1,254));
1675: END LOOP;

Line 1706: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_index));

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;
1709: --dbms_output.put_line(substr(apps.fnd_message.get,1,254));
1710: END LOOP;

Line 2099: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

2095: WHEN OTHERS THEN
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);

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: