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.HZ_COPY_REL_PVT dependencies on FND_MSG_PUB

Line 55: FND_MSG_PUB.Reset;

51: PROCEDURE logerror(SQLERRM VARCHAR2 DEFAULT NULL)
52: IS
53: l_msg_data VARCHAR2(2000);
54: BEGIN
55: FND_MSG_PUB.Reset;
56: log('---------------------------');
57: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
58: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
59: END LOOP;

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

53: l_msg_data VARCHAR2(2000);
54: BEGIN
55: FND_MSG_PUB.Reset;
56: log('---------------------------');
57: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
58: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
59: END LOOP;
60: IF (SQLERRM IS NOT NULL) THEN
61: l_msg_data := l_msg_data || SQLERRM;

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

54: BEGIN
55: FND_MSG_PUB.Reset;
56: log('---------------------------');
57: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
58: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
59: END LOOP;
60: IF (SQLERRM IS NOT NULL) THEN
61: l_msg_data := l_msg_data || SQLERRM;
62: END IF;

Line 142: FND_MSG_PUB.ADD;

138: OR description = p_lookup_description);
139: IF l_count <> 0
140: THEN
141: FND_MESSAGE.SET_NAME('AR', 'HZ_REL_TYPE_ROLE_MEANING_ERR');
142: FND_MSG_PUB.ADD;
143: x_return_status := fnd_api.g_ret_sts_error;
144: ELSE
145: BEGIN
146: FND_LOOKUP_VALUES_PKG.INSERT_ROW(

Line 186: FND_MSG_PUB.ADD;

182: WHEN OTHERS THEN
183: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
184: FND_MESSAGE.SET_TOKEN('PROC' ,'CREATE_LOOKUP');
185: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
186: FND_MSG_PUB.ADD;
187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
188: END;
189: END IF;
190:

Line 574: --FND_MSG_PUB.ADD;

570:
571: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
572: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_RELATIONSHIP_V2PUB.CREATE_RELATIONSHIP');
573: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
574: --FND_MSG_PUB.ADD;
575: l_message_text := FND_MESSAGE.GET;
576: log(l_message_text);
577:
578: log('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');

Line 595: FND_MSG_PUB.ADD;

591: THEN
592: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
593: FND_MESSAGE.SET_TOKEN('PROC' ,'COPY_RELATIONSHIPS');
594: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
595: FND_MSG_PUB.ADD;
596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
597: END copy_relationships ;
598:
599:

Line 788: FND_MSG_PUB.ADD;

784: THEN
785: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
786: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_RELATIONSHIP_TYPE_V2PUB.CREATE_RELATIONSHIP_TYPE');
787: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
788: FND_MSG_PUB.ADD;
789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
790: END IF;
791:
792: END LOOP;

Line 800: FND_MSG_PUB.COUNT_AND_GET(

796:
797:
798: EXCEPTION
799: WHEN CREATE_LOOKUP_EXCEPTION THEN
800: FND_MSG_PUB.COUNT_AND_GET(
801: p_encoded => FND_API.G_FALSE,
802: p_count => x_msg_count,
803: p_data => x_msg_data
804: );

Line 809: FND_MSG_PUB.ADD;

805: WHEN OTHERS THEN
806: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
807: FND_MESSAGE.SET_TOKEN('PROC' ,'COPY_SELECTED_PHRASE_PAIR');
808: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
809: FND_MSG_PUB.ADD;
810: FND_MSG_PUB.COUNT_AND_GET(
811: p_encoded => FND_API.G_FALSE,
812: p_count => x_msg_count,
813: p_data => x_msg_data

Line 810: FND_MSG_PUB.COUNT_AND_GET(

806: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
807: FND_MESSAGE.SET_TOKEN('PROC' ,'COPY_SELECTED_PHRASE_PAIR');
808: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
809: FND_MSG_PUB.ADD;
810: FND_MSG_PUB.COUNT_AND_GET(
811: p_encoded => FND_API.G_FALSE,
812: p_count => x_msg_count,
813: p_data => x_msg_data
814: );

Line 926: -- FND_MSG_PUB.ADD;

922:
923: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
924: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_RELATIONSHIP_V2PUB.CREATE_RELATIONSHIP');
925: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
926: -- FND_MSG_PUB.ADD;
927: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
928: l_message_text := FND_MESSAGE.GET;
929: log(l_message_text);
930:

Line 950: FND_MSG_PUB.ADD;

946: WHEN OTHERS THEN
947: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
948: FND_MESSAGE.SET_TOKEN('PROC' ,'CREATE_HIERARCHY');
949: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
950: FND_MSG_PUB.ADD;
951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
952: END create_hierarchy;
953:
954:

Line 1159: FND_MSG_PUB.ADD;

1155: THEN
1156: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
1157: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_RELATIONSHIP_TYPE_V2PUB.CREATE_RELATIONSHIP_TYPE');
1158: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1159: FND_MSG_PUB.ADD;
1160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1161: END IF;
1162:
1163: END LOOP;

Line 1170: FND_MSG_PUB.Count_And_Get(

1166: EXCEPTION
1167: WHEN CREATE_LOOKUP_EXCEPTION THEN
1168: ROLLBACK TO copy_rel_type_only;
1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170: FND_MSG_PUB.Count_And_Get(
1171: p_encoded => FND_API.G_FALSE,
1172: p_count => x_msg_count,
1173: p_data => x_msg_data);
1174:

Line 1182: FND_MSG_PUB.ADD;

1178: x_return_status := FND_API.G_RET_STS_ERROR;
1179: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
1180: FND_MESSAGE.SET_TOKEN('PROC' ,'COPY_REL_TYPE_ONLY');
1181: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1182: FND_MSG_PUB.ADD;
1183: FND_MSG_PUB.Count_And_Get(
1184: p_encoded => FND_API.G_FALSE,
1185: p_count => x_msg_count,
1186: p_data => x_msg_data);

Line 1183: FND_MSG_PUB.Count_And_Get(

1179: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
1180: FND_MESSAGE.SET_TOKEN('PROC' ,'COPY_REL_TYPE_ONLY');
1181: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1182: FND_MSG_PUB.ADD;
1183: FND_MSG_PUB.Count_And_Get(
1184: p_encoded => FND_API.G_FALSE,
1185: p_count => x_msg_count,
1186: p_data => x_msg_data);
1187:

Line 1279: FND_MSG_PUB.ADD;

1275: x_return_status := FND_API.G_RET_STS_ERROR;
1276: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
1277: FND_MESSAGE.SET_TOKEN('PROC' ,'COPY_REL_TYPE_AND_ALL_RELS');
1278: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1279: FND_MSG_PUB.ADD;
1280: FND_MSG_PUB.Count_And_Get(
1281: p_encoded => FND_API.G_FALSE,
1282: p_count => x_msg_count,
1283: p_data => x_msg_data);

Line 1280: FND_MSG_PUB.Count_And_Get(

1276: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
1277: FND_MESSAGE.SET_TOKEN('PROC' ,'COPY_REL_TYPE_AND_ALL_RELS');
1278: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1279: FND_MSG_PUB.ADD;
1280: FND_MSG_PUB.Count_And_Get(
1281: p_encoded => FND_API.G_FALSE,
1282: p_count => x_msg_count,
1283: p_data => x_msg_data);
1284:

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

1284:
1285:
1286: -- LOG MESSAGE TO FILE
1287: /*
1288: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1289: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1290: END LOOP;
1291: */
1292: logerror;

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

1285:
1286: -- LOG MESSAGE TO FILE
1287: /*
1288: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1289: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1290: END LOOP;
1291: */
1292: logerror;
1293: FND_MESSAGE.CLEAR;

Line 1336: FND_MSG_PUB.ADD;

1332: -- COMPLAIN IF IT DOES NOT RETURN A PROPER REQUEST ID.
1333: IF l_request_id = 0
1334: THEN
1335: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
1336: FND_MSG_PUB.ADD;
1337: RAISE FND_API.G_EXC_ERROR;
1338: END IF;
1339:
1340: x_request_id := l_request_id;

Line 1350: FND_MSG_PUB.ADD;

1346: x_return_status := FND_API.G_RET_STS_ERROR;
1347: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
1348: FND_MESSAGE.SET_TOKEN('PROC' ,'SUBMIT_COPY_REL_TYPE_RELS_CONC');
1349: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1350: FND_MSG_PUB.ADD;
1351: FND_MSG_PUB.Count_And_Get(
1352: p_encoded => FND_API.G_FALSE,
1353: p_count => x_msg_count,
1354: p_data => x_msg_data);

Line 1351: FND_MSG_PUB.Count_And_Get(

1347: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
1348: FND_MESSAGE.SET_TOKEN('PROC' ,'SUBMIT_COPY_REL_TYPE_RELS_CONC');
1349: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1350: FND_MSG_PUB.ADD;
1351: FND_MSG_PUB.Count_And_Get(
1352: p_encoded => FND_API.G_FALSE,
1353: p_count => x_msg_count,
1354: p_data => x_msg_data);
1355:

Line 1465: FND_MSG_PUB.ADD;

1461: x_return_status := FND_API.G_RET_STS_ERROR;
1462: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
1463: FND_MESSAGE.SET_TOKEN('PROC' ,'COPY_HIERARCHY');
1464: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1465: FND_MSG_PUB.ADD;
1466: FND_MSG_PUB.Count_And_Get(
1467: p_encoded => FND_API.G_FALSE,
1468: p_count => x_msg_count,
1469: p_data => x_msg_data);

Line 1466: FND_MSG_PUB.Count_And_Get(

1462: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
1463: FND_MESSAGE.SET_TOKEN('PROC' ,'COPY_HIERARCHY');
1464: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1465: FND_MSG_PUB.ADD;
1466: FND_MSG_PUB.Count_And_Get(
1467: p_encoded => FND_API.G_FALSE,
1468: p_count => x_msg_count,
1469: p_data => x_msg_data);
1470:

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

1469: p_data => x_msg_data);
1470:
1471: -- LOG MESSAGE TO FILE
1472: /*
1473: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1474: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1475: END LOOP;
1476: */
1477: logerror;

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

1470:
1471: -- LOG MESSAGE TO FILE
1472: /*
1473: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1474: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1475: END LOOP;
1476: */
1477: logerror;
1478:

Line 1518: FND_MSG_PUB.ADD;

1514: -- COMPLAIN IF IT DOES NOT RETURN A PROPER REQUEST ID.
1515: IF l_request_id = 0
1516: THEN
1517: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
1518: FND_MSG_PUB.ADD;
1519: RAISE FND_API.G_EXC_ERROR;
1520: END IF;
1521:
1522: x_request_id := l_request_id;

Line 1532: FND_MSG_PUB.ADD;

1528: x_return_status := FND_API.G_RET_STS_ERROR;
1529: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
1530: FND_MESSAGE.SET_TOKEN('PROC' ,'SUBMIT_COPY_HIERARCHY_CONC');
1531: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1532: FND_MSG_PUB.ADD;
1533: FND_MSG_PUB.Count_And_Get(
1534: p_encoded => FND_API.G_FALSE,
1535: p_count => x_msg_count,
1536: p_data => x_msg_data);

Line 1533: FND_MSG_PUB.Count_And_Get(

1529: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
1530: FND_MESSAGE.SET_TOKEN('PROC' ,'SUBMIT_COPY_HIERARCHY_CONC');
1531: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1532: FND_MSG_PUB.ADD;
1533: FND_MSG_PUB.Count_And_Get(
1534: p_encoded => FND_API.G_FALSE,
1535: p_count => x_msg_count,
1536: p_data => x_msg_data);
1537: END submit_copy_hierarchy_conc ;

Line 1715: FND_MSG_PUB.ADD;

1711: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1712: FND_MESSAGE.SET_NAME('AR', 'HZ_CONVERT_REL_API_ERROR');
1713: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_HIERARCHY_PUB.CREATE_LINK');
1714: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1715: FND_MSG_PUB.ADD;
1716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1717:
1718: ROLLBACK TO convert_rel_type ;
1719:

Line 1819: FND_MSG_PUB.ADD;

1815: x_return_status := FND_API.G_RET_STS_ERROR;
1816: FND_MESSAGE.SET_NAME('AR', 'HZ_CONVERT_REL_API_ERROR');
1817: FND_MESSAGE.SET_TOKEN('PROC' ,'CONVERT_REL_TYPE');
1818: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1819: FND_MSG_PUB.ADD;
1820: FND_MSG_PUB.Count_And_Get(
1821: p_encoded => FND_API.G_FALSE,
1822: p_count => l_msg_count,
1823: p_data => l_msg_data);

Line 1820: FND_MSG_PUB.Count_And_Get(

1816: FND_MESSAGE.SET_NAME('AR', 'HZ_CONVERT_REL_API_ERROR');
1817: FND_MESSAGE.SET_TOKEN('PROC' ,'CONVERT_REL_TYPE');
1818: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1819: FND_MSG_PUB.ADD;
1820: FND_MSG_PUB.Count_And_Get(
1821: p_encoded => FND_API.G_FALSE,
1822: p_count => l_msg_count,
1823: p_data => l_msg_data);
1824:

Line 1867: FND_MSG_PUB.ADD;

1863: -- COMPLAIN IF IT DOES NOT RETURN A PROPER REQUEST ID.
1864: IF l_request_id = 0
1865: THEN
1866: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
1867: FND_MSG_PUB.ADD;
1868: RAISE FND_API.G_EXC_ERROR;
1869: END IF;
1870:
1871: x_request_id := l_request_id;

Line 1880: FND_MSG_PUB.ADD;

1876: x_return_status := FND_API.G_RET_STS_ERROR;
1877: FND_MESSAGE.SET_NAME('AR', 'HZ_CONVERT_REL_API_ERROR');
1878: FND_MESSAGE.SET_TOKEN('PROC' ,'SUBMIT_CONVERT_REL_TYPE_CONC');
1879: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1880: FND_MSG_PUB.ADD;
1881: FND_MSG_PUB.Count_And_Get(
1882: p_encoded => FND_API.G_FALSE,
1883: p_count => x_msg_count,
1884: p_data => x_msg_data);

Line 1881: FND_MSG_PUB.Count_And_Get(

1877: FND_MESSAGE.SET_NAME('AR', 'HZ_CONVERT_REL_API_ERROR');
1878: FND_MESSAGE.SET_TOKEN('PROC' ,'SUBMIT_CONVERT_REL_TYPE_CONC');
1879: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1880: FND_MSG_PUB.ADD;
1881: FND_MSG_PUB.Count_And_Get(
1882: p_encoded => FND_API.G_FALSE,
1883: p_count => x_msg_count,
1884: p_data => x_msg_data);
1885: