DBA Data[Home] [Help]

APPS.HZ_GNR_UTIL_PKG dependencies on FND_MSG_PUB

Line 198: l_message_count := fnd_msg_pub.count_msg();

194: OR p_new_location_rec.timezone_id = fnd_api.g_miss_num)
195: )
196: THEN
197:
198: l_message_count := fnd_msg_pub.count_msg();
199: hz_timezone_pub.get_timezone_id(
200: p_api_version => 1.0,
201: p_init_msg_list => FND_API.G_FALSE,
202: p_postal_code => p_new_location_rec.postal_code,

Line 215: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);

211: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
212: -- we don't raise error
213: p_new_location_rec.timezone_id := fnd_api.g_miss_num;
214: FOR i IN 1..(l_msg_count - l_message_count) LOOP
215: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);
216: END LOOP;
217: l_return_status := FND_API.G_RET_STS_SUCCESS;
218: END IF;
219: END IF;

Line 385: fnd_msg_pub.add;

381: WHEN OTHERS THEN
382: /*
383: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
384: fnd_message.set_token('TABLE', 'HZ_PARTIES');
385: fnd_msg_pub.add;
386: */
387: CLOSE c1;
388: -- RAISE fnd_api.g_exc_error;
389: END;

Line 1379: FND_MSG_PUB.Reset;

1375:
1376: PROCEDURE logerr IS
1377: l_msg_data VARCHAR2(2000);
1378: BEGIN
1379: FND_MSG_PUB.Reset;
1380: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1381: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1382: END LOOP;
1383: -- FND_MSG_PUB.Delete_Msg;

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

1376: PROCEDURE logerr IS
1377: l_msg_data VARCHAR2(2000);
1378: BEGIN
1379: FND_MSG_PUB.Reset;
1380: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1381: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1382: END LOOP;
1383: -- FND_MSG_PUB.Delete_Msg;
1384: END logerr;

Line 1381: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

1377: l_msg_data VARCHAR2(2000);
1378: BEGIN
1379: FND_MSG_PUB.Reset;
1380: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1381: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1382: END LOOP;
1383: -- FND_MSG_PUB.Delete_Msg;
1384: END logerr;
1385: ----------------------------------------------

Line 1383: -- FND_MSG_PUB.Delete_Msg;

1379: FND_MSG_PUB.Reset;
1380: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1381: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1382: END LOOP;
1383: -- FND_MSG_PUB.Delete_Msg;
1384: END logerr;
1385: ----------------------------------------------
1386: /**
1387: * Function to fetch messages of the stack and log the error

Line 1394: FND_MSG_PUB.Reset;

1390: ----------------------------------------------
1391: FUNCTION logerror RETURN VARCHAR2 IS
1392: l_msg_data VARCHAR2(2000);
1393: BEGIN
1394: FND_MSG_PUB.Reset;
1395:
1396: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1397: l_msg_data := l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1398: END LOOP;

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

1392: l_msg_data VARCHAR2(2000);
1393: BEGIN
1394: FND_MSG_PUB.Reset;
1395:
1396: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1397: l_msg_data := l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1398: END LOOP;
1399: log(l_msg_data);
1400: RETURN l_msg_data;

Line 1397: l_msg_data := l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );

1393: BEGIN
1394: FND_MSG_PUB.Reset;
1395:
1396: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1397: l_msg_data := l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1398: END LOOP;
1399: log(l_msg_data);
1400: RETURN l_msg_data;
1401: END logerror;

Line 1426: FND_MSG_PUB.ADD;

1422: END IF;
1423: IF (p_tkn2_name IS NOT NULL) THEN
1424: fnd_message.set_token(p_tkn2_name, p_tkn2_val);
1425: END IF;
1426: FND_MSG_PUB.ADD;
1427: FND_MSG_PUB.Reset;
1428:
1429: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1430: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

Line 1427: FND_MSG_PUB.Reset;

1423: IF (p_tkn2_name IS NOT NULL) THEN
1424: fnd_message.set_token(p_tkn2_name, p_tkn2_val);
1425: END IF;
1426: FND_MSG_PUB.ADD;
1427: FND_MSG_PUB.Reset;
1428:
1429: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1430: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1431: END LOOP;

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

1425: END IF;
1426: FND_MSG_PUB.ADD;
1427: FND_MSG_PUB.Reset;
1428:
1429: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1430: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1431: END LOOP;
1432: --hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,G_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));
1433: hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,FND_API.G_RET_STS_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));

Line 1430: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

1426: FND_MSG_PUB.ADD;
1427: FND_MSG_PUB.Reset;
1428:
1429: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1430: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1431: END LOOP;
1432: --hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,G_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));
1433: hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,FND_API.G_RET_STS_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));
1434: END mesglog;

Line 1432: --hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,G_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));

1428:
1429: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1430: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1431: END LOOP;
1432: --hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,G_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));
1433: hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,FND_API.G_RET_STS_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));
1434: END mesglog;
1435: ----------------------------------------------
1436: FUNCTION getQuery(

Line 1433: hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,FND_API.G_RET_STS_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));

1429: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1430: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1431: END LOOP;
1432: --hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,G_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));
1433: hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,FND_API.G_RET_STS_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));
1434: END mesglog;
1435: ----------------------------------------------
1436: FUNCTION getQuery(
1437: p_map_dtls_tbl IN maploc_rec_tbl_type,

Line 1833: FND_MSG_PUB.ADD;

1829: );
1830: END IF;
1831: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_ADDRESS');
1832: FND_MESSAGE.SET_TOKEN('P_MISSING_ELEMENTS', l_missing_elements);
1833: FND_MSG_PUB.ADD;
1834: RETURN l_addr_val_status;
1835: -- If validation level is WARNING, check the minimum parameters passed.
1836: -- If yes, set the addr_val_status to 'W' and return status to 'S'
1837: -- If not, set the message with the missing parameters

Line 1891: -- FND_MSG_PUB.ADD;

1887: END IF;
1888: -- ELSE
1889: -- FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NULL_ADDRESS');
1890: -- FND_MESSAGE.SET_TOKEN('P_MISSING_ELEMENTS', l_missing_elements);
1891: -- FND_MSG_PUB.ADD;
1892: -- x_status := l_addr_val_status;
1893: -- IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1894: -- hz_utility_v2pub.debug
1895: -- (p_message => 'Please enter required address elements : '||l_missing_elements,

Line 1941: FND_MSG_PUB.ADD;

1937: x_status := fnd_api.g_ret_sts_success;
1938: ELSE
1939: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NULL_ADDRESS');
1940: FND_MESSAGE.SET_TOKEN('P_MISSING_ELEMENTS', l_missing_elements);
1941: FND_MSG_PUB.ADD;
1942: -- hk_debugl('Please enter required address elements: '|| l_missing_elements);
1943: -- hk_debugl('l_addr_val_status : '|| l_addr_val_status);
1944: x_status := l_addr_val_status;
1945: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 2269: FND_MSG_PUB.ADD;

2265: WHEN NO_DATA_FOUND THEN
2266: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2267: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');
2268: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));
2269: FND_MSG_PUB.ADD;
2270: x_status := FND_API.G_RET_STS_ERROR;
2271: END; -- end of SELECT
2272:
2273: ELSE -- do not lock the location record

Line 2298: FND_MSG_PUB.ADD;

2294: WHEN NO_DATA_FOUND THEN
2295: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2296: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');
2297: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));
2298: FND_MSG_PUB.ADD;
2299: x_status := FND_API.G_RET_STS_ERROR;
2300: END; -- end of SELECT ;
2301: END IF;
2302: