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_MESSAGE

Line 141: FND_MESSAGE.SET_NAME('AR', 'HZ_REL_TYPE_ROLE_MEANING_ERR');

137: AND (meaning = p_lookup_meaning
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

Line 183: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');

179: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
180: );
181: EXCEPTION
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;

Line 184: FND_MESSAGE.SET_TOKEN('PROC' ,'CREATE_LOOKUP');

180: );
181: EXCEPTION
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;

Line 185: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

181: EXCEPTION
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;

Line 571: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');

567: log('object id -- ' || p_relationship_rec.object_id );
568:
569: log('NEWLINE');
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;

Line 572: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_RELATIONSHIP_V2PUB.CREATE_RELATIONSHIP');

568:
569: log('NEWLINE');
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);

Line 573: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

569: log('NEWLINE');
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:

Line 575: l_message_text := FND_MESSAGE.GET;

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('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');
579: log('NEWLINE');

Line 592: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');

588:
589: EXCEPTION
590: WHEN OTHERS
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;

Line 593: FND_MESSAGE.SET_TOKEN('PROC' ,'COPY_RELATIONSHIPS');

589: EXCEPTION
590: WHEN OTHERS
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 ;

Line 594: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

590: WHEN OTHERS
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:

Line 785: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');

781:
782: -- RAISE HELL WHEN return status is not success
783: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
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;

Line 786: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_RELATIONSHIP_TYPE_V2PUB.CREATE_RELATIONSHIP_TYPE');

782: -- RAISE HELL WHEN return status is not success
783: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
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;

Line 787: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

783: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
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:

Line 806: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');

802: p_count => x_msg_count,
803: p_data => x_msg_data
804: );
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(

Line 807: FND_MESSAGE.SET_TOKEN('PROC' ,'COPY_SELECTED_PHRASE_PAIR');

803: p_data => x_msg_data
804: );
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,

Line 808: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

804: );
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,

Line 923: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');

919: log('object id -- ' || p_relationship_rec.object_id );
920:
921: log('NEWLINE');
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;

Line 924: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_RELATIONSHIP_V2PUB.CREATE_RELATIONSHIP');

920:
921: log('NEWLINE');
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;

Line 925: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

921: log('NEWLINE');
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);

Line 928: l_message_text := FND_MESSAGE.GET;

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:
931: log('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');
932: log('NEWLINE');

Line 947: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');

943:
944:
945: EXCEPTION
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;

Line 948: FND_MESSAGE.SET_TOKEN('PROC' ,'CREATE_HIERARCHY');

944:
945: EXCEPTION
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;

Line 949: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

945: EXCEPTION
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:

Line 1156: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');

1152: x_msg_count,x_msg_data);
1153: -- RAISE HELL WHEN return status is not success
1154: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
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;

Line 1157: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_RELATIONSHIP_TYPE_V2PUB.CREATE_RELATIONSHIP_TYPE');

1153: -- RAISE HELL WHEN return status is not success
1154: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
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;

Line 1158: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

1154: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
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:

Line 1179: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');

1175:
1176: WHEN OTHERS THEN
1177: rollback to copy_rel_type_only ;
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(

Line 1180: FND_MESSAGE.SET_TOKEN('PROC' ,'COPY_REL_TYPE_ONLY');

1176: WHEN OTHERS THEN
1177: rollback to copy_rel_type_only ;
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,

Line 1181: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

1177: rollback to copy_rel_type_only ;
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,

Line 1276: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');

1272: WHEN OTHERS
1273: THEN
1274: ROLLBACK TO copy_rel_type_and_all_rels ;
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(

Line 1277: FND_MESSAGE.SET_TOKEN('PROC' ,'COPY_REL_TYPE_AND_ALL_RELS');

1273: THEN
1274: ROLLBACK TO copy_rel_type_and_all_rels ;
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,

Line 1278: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

1274: ROLLBACK TO copy_rel_type_and_all_rels ;
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,

Line 1293: FND_MESSAGE.CLEAR;

1289: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1290: END LOOP;
1291: */
1292: logerror;
1293: FND_MESSAGE.CLEAR;
1294:
1295: -- Bug 3651949: let concurrent program error out.
1296: Retcode := 2;
1297:

Line 1335: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');

1331: TO_CHAR(p_rel_valid_date, 'DD-MON-YY'));
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:

Line 1347: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');

1343: EXCEPTION
1344: WHEN OTHERS
1345: THEN
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(

Line 1348: FND_MESSAGE.SET_TOKEN('PROC' ,'SUBMIT_COPY_REL_TYPE_RELS_CONC');

1344: WHEN OTHERS
1345: THEN
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,

Line 1349: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

1345: THEN
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,

Line 1462: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');

1458: THEN
1459: -- rollback if you get this far
1460: rollback to copy_hierarchy ;
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(

Line 1463: FND_MESSAGE.SET_TOKEN('PROC' ,'COPY_HIERARCHY');

1459: -- rollback if you get this far
1460: rollback to copy_hierarchy ;
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,

Line 1464: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

1460: rollback to copy_hierarchy ;
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,

Line 1517: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');

1513:
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:

Line 1529: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');

1525: EXCEPTION
1526: WHEN OTHERS
1527: THEN
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(

Line 1530: FND_MESSAGE.SET_TOKEN('PROC' ,'SUBMIT_COPY_HIERARCHY_CONC');

1526: WHEN OTHERS
1527: THEN
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,

Line 1531: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

1527: THEN
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,

Line 1712: FND_MESSAGE.SET_NAME('AR', 'HZ_CONVERT_REL_API_ERROR');

1708: );
1709:
1710: -- RAISE HELL WHEN return status is not success
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;

Line 1713: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_HIERARCHY_PUB.CREATE_LINK');

1709:
1710: -- RAISE HELL WHEN return status is not success
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:

Line 1714: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

1710: -- RAISE HELL WHEN return status is not success
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 ;

Line 1767: FND_MESSAGE.SET_NAME('AR', 'HZ_CIRCULAR_REL_EXIST_FMT1');

1763: FROM ar_lookups
1764: WHERE lookup_type = 'HZ_RELATIONSHIP_TYPE'
1765: AND lookup_code = p_rel_type;
1766:
1767: FND_MESSAGE.SET_NAME('AR', 'HZ_CIRCULAR_REL_EXIST_FMT1');
1768: FND_MESSAGE.SET_TOKEN('RELTYPE' , l_meaning);
1769:
1770: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET()||fnd_global.NEWLINE);
1771:

Line 1768: FND_MESSAGE.SET_TOKEN('RELTYPE' , l_meaning);

1764: WHERE lookup_type = 'HZ_RELATIONSHIP_TYPE'
1765: AND lookup_code = p_rel_type;
1766:
1767: FND_MESSAGE.SET_NAME('AR', 'HZ_CIRCULAR_REL_EXIST_FMT1');
1768: FND_MESSAGE.SET_TOKEN('RELTYPE' , l_meaning);
1769:
1770: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET()||fnd_global.NEWLINE);
1771:
1772: FOR i IN 1..g_message_fmt1.COUNT LOOP

Line 1770: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET()||fnd_global.NEWLINE);

1766:
1767: FND_MESSAGE.SET_NAME('AR', 'HZ_CIRCULAR_REL_EXIST_FMT1');
1768: FND_MESSAGE.SET_TOKEN('RELTYPE' , l_meaning);
1769:
1770: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET()||fnd_global.NEWLINE);
1771:
1772: FOR i IN 1..g_message_fmt1.COUNT LOOP
1773: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, i||' : ');
1774: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, g_message_fmt1(i)||fnd_global.NEWLINE);

Line 1779: FND_MESSAGE.SET_NAME('AR', 'HZ_CIRCULAR_REL_EXIST_FMT2');

1775: END LOOP;
1776:
1777: -- prepare log file
1778: --
1779: FND_MESSAGE.SET_NAME('AR', 'HZ_CIRCULAR_REL_EXIST_FMT2');
1780: FND_MESSAGE.SET_TOKEN('RELTYPE' , p_rel_type);
1781:
1782: log('===================================================================');
1783: log(fnd_global.NEWLINE||fnd_global.NEWLINE||FND_MESSAGE.GET()||fnd_global.NEWLINE);

Line 1780: FND_MESSAGE.SET_TOKEN('RELTYPE' , p_rel_type);

1776:
1777: -- prepare log file
1778: --
1779: FND_MESSAGE.SET_NAME('AR', 'HZ_CIRCULAR_REL_EXIST_FMT2');
1780: FND_MESSAGE.SET_TOKEN('RELTYPE' , p_rel_type);
1781:
1782: log('===================================================================');
1783: log(fnd_global.NEWLINE||fnd_global.NEWLINE||FND_MESSAGE.GET()||fnd_global.NEWLINE);
1784:

Line 1783: log(fnd_global.NEWLINE||fnd_global.NEWLINE||FND_MESSAGE.GET()||fnd_global.NEWLINE);

1779: FND_MESSAGE.SET_NAME('AR', 'HZ_CIRCULAR_REL_EXIST_FMT2');
1780: FND_MESSAGE.SET_TOKEN('RELTYPE' , p_rel_type);
1781:
1782: log('===================================================================');
1783: log(fnd_global.NEWLINE||fnd_global.NEWLINE||FND_MESSAGE.GET()||fnd_global.NEWLINE);
1784:
1785: FOR i IN 1..g_message_fmt2.COUNT LOOP
1786: log(i||' : ');
1787: log(g_message_fmt2(i)||fnd_global.NEWLINE);

Line 1816: FND_MESSAGE.SET_NAME('AR', 'HZ_CONVERT_REL_API_ERROR');

1812: -- rollback if this happens
1813: rollback to convert_rel_type ;
1814:
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(

Line 1817: FND_MESSAGE.SET_TOKEN('PROC' ,'CONVERT_REL_TYPE');

1813: rollback to convert_rel_type ;
1814:
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,

Line 1818: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

1814:
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,

Line 1826: FND_MESSAGE.CLEAR;

1822: p_count => l_msg_count,
1823: p_data => l_msg_data);
1824:
1825: logerror;
1826: FND_MESSAGE.CLEAR;
1827:
1828: -- Bug 3615970: point 6
1829: Retcode := 2;
1830:

Line 1866: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');

1862:
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:

Line 1877: FND_MESSAGE.SET_NAME('AR', 'HZ_CONVERT_REL_API_ERROR');

1873: EXCEPTION
1874: WHEN OTHERS
1875: THEN
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(

Line 1878: FND_MESSAGE.SET_TOKEN('PROC' ,'SUBMIT_CONVERT_REL_TYPE_CONC');

1874: WHEN OTHERS
1875: THEN
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,

Line 1879: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

1875: THEN
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,