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

Line 480: l_return_status:=FND_API.G_RET_STS_SUCCESS;

476: END LOOP;
477: CLOSE custom_attribs;
478: END IF;
479:
480: l_return_status:=FND_API.G_RET_STS_SUCCESS;
481: FOR I IN 1..g_party_custom_procs.COUNT LOOP
482: l_proc_name := g_party_custom_procs(I);
483: l_attr_name := g_party_custom_attrs(I);
484:

Line 580: RAISE FND_API.G_EXC_ERROR;

576: FND_MESSAGE.SET_TOKEN('ENTITY' ,'PARTY');
577: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attr_name);
578: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
579: FND_MSG_PUB.ADD;
580: RAISE FND_API.G_EXC_ERROR;
581: */
582: END;
583: END IF;
584: END LOOP;

Line 588: WHEN FND_API.G_EXC_ERROR THEN

584: END LOOP;
585:
586: RETURN l_party_search_rec;
587: EXCEPTION
588: WHEN FND_API.G_EXC_ERROR THEN
589: RAISE FND_API.G_EXC_ERROR;
590: WHEN OTHERS THEN
591: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
592: FND_MESSAGE.SET_TOKEN('PROC' ,'get_party_rec');

Line 589: RAISE FND_API.G_EXC_ERROR;

585:
586: RETURN l_party_search_rec;
587: EXCEPTION
588: WHEN FND_API.G_EXC_ERROR THEN
589: RAISE FND_API.G_EXC_ERROR;
590: WHEN OTHERS THEN
591: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
592: FND_MESSAGE.SET_TOKEN('PROC' ,'get_party_rec');
593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

591: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
592: FND_MESSAGE.SET_TOKEN('PROC' ,'get_party_rec');
593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
594: FND_MSG_PUB.ADD;
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596: END;
597:
598:
599: FUNCTION get_party_site_rec (

Line 663: l_return_status:=FND_API.G_RET_STS_SUCCESS;

659:
660: l_sql VARCHAR2(255);
661:
662: BEGIN
663: l_return_status:=FND_API.G_RET_STS_SUCCESS;
664: OPEN c_party_site;
665: FETCH c_party_site INTO l_party_site_search_rec.ADDRESS1
666: ,l_party_site_search_rec.ADDRESS2
667: ,l_party_site_search_rec.ADDRESS3

Line 730: l_return_status:=FND_API.G_RET_STS_SUCCESS;

726: END LOOP;
727: CLOSE custom_attribs;
728: END IF;
729:
730: l_return_status:=FND_API.G_RET_STS_SUCCESS;
731: FOR I IN 1..g_ps_custom_procs.COUNT LOOP
732: l_proc_name := g_ps_custom_procs(I);
733: l_attr_name := g_ps_custom_attrs(I);
734:

Line 823: RAISE FND_API.G_EXC_ERROR;

819: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR');
820: FND_MESSAGE.SET_TOKEN('ENTITY' ,'PARTY_SITES');
821: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attr_name);
822: FND_MSG_PUB.ADD;
823: RAISE FND_API.G_EXC_ERROR;
824: */
825: END;
826: END IF;
827: END LOOP;

Line 831: WHEN FND_API.G_EXC_ERROR THEN

827: END LOOP;
828:
829: RETURN l_party_site_search_rec;
830: EXCEPTION
831: WHEN FND_API.G_EXC_ERROR THEN
832: RAISE FND_API.G_EXC_ERROR;
833: WHEN OTHERS THEN
834: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
835: FND_MESSAGE.SET_TOKEN('PROC' ,'get_party_site_rec');

Line 832: RAISE FND_API.G_EXC_ERROR;

828:
829: RETURN l_party_site_search_rec;
830: EXCEPTION
831: WHEN FND_API.G_EXC_ERROR THEN
832: RAISE FND_API.G_EXC_ERROR;
833: WHEN OTHERS THEN
834: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
835: FND_MESSAGE.SET_TOKEN('PROC' ,'get_party_site_rec');
836: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

834: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
835: FND_MESSAGE.SET_TOKEN('PROC' ,'get_party_site_rec');
836: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
837: FND_MSG_PUB.ADD;
838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
839:
840: END;
841:
842:

Line 916: l_return_status:=FND_API.G_RET_STS_SUCCESS;

912:
913: l_sql VARCHAR2(255);
914:
915: BEGIN
916: l_return_status:=FND_API.G_RET_STS_SUCCESS;
917: OPEN c_org_contact;
918: FETCH c_org_contact INTO l_contact_search_rec.CONTACT_NUMBER
919: ,l_contact_search_rec.DECISION_MAKER_FLAG
920: ,l_contact_search_rec.JOB_TITLE

Line 983: l_return_status:=FND_API.G_RET_STS_SUCCESS;

979: END LOOP;
980: CLOSE custom_attribs;
981: END IF;
982:
983: l_return_status:=FND_API.G_RET_STS_SUCCESS;
984: FOR I IN 1..g_cont_custom_procs.COUNT LOOP
985: l_proc_name := g_cont_custom_procs(I);
986: l_attr_name := g_cont_custom_attrs(I);
987:

Line 1076: RAISE FND_API.G_EXC_ERROR;

1072: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR');
1073: FND_MESSAGE.SET_TOKEN('ENTITY' ,'CONTACT');
1074: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attr_name);
1075: FND_MSG_PUB.ADD;
1076: RAISE FND_API.G_EXC_ERROR;
1077: */
1078: END;
1079: END IF;
1080: END LOOP;

Line 1084: WHEN FND_API.G_EXC_ERROR THEN

1080: END LOOP;
1081:
1082: RETURN l_contact_search_rec;
1083: EXCEPTION
1084: WHEN FND_API.G_EXC_ERROR THEN
1085: RAISE FND_API.G_EXC_ERROR;
1086: WHEN OTHERS THEN
1087: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
1088: FND_MESSAGE.SET_TOKEN('PROC' ,'get_contact_Rec');

Line 1085: RAISE FND_API.G_EXC_ERROR;

1081:
1082: RETURN l_contact_search_rec;
1083: EXCEPTION
1084: WHEN FND_API.G_EXC_ERROR THEN
1085: RAISE FND_API.G_EXC_ERROR;
1086: WHEN OTHERS THEN
1087: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
1088: FND_MESSAGE.SET_TOKEN('PROC' ,'get_contact_Rec');
1089: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1087: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
1088: FND_MESSAGE.SET_TOKEN('PROC' ,'get_contact_Rec');
1089: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1090: FND_MSG_PUB.ADD;
1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1092:
1093: END;
1094:
1095:

Line 1151: l_return_status:=FND_API.G_RET_STS_SUCCESS;

1147:
1148: l_sql VARCHAR2(255);
1149:
1150: BEGIN
1151: l_return_status:=FND_API.G_RET_STS_SUCCESS;
1152:
1153: OPEN cpt;
1154: FETCH cpt INTO l_contact_pt_search_rec.CONTACT_POINT_TYPE
1155: ,l_contact_pt_search_rec.CONTENT_SOURCE_TYPE

Line 1212: l_return_status:=FND_API.G_RET_STS_SUCCESS;

1208: END LOOP;
1209: CLOSE custom_attribs;
1210: END IF;
1211:
1212: l_return_status:=FND_API.G_RET_STS_SUCCESS;
1213: FOR I IN 1..g_cpt_custom_procs.COUNT LOOP
1214: l_proc_name := g_cpt_custom_procs(I);
1215: l_attr_name := g_cpt_custom_attrs(I);
1216:

Line 1307: RAISE FND_API.G_EXC_ERROR;

1303: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR');
1304: FND_MESSAGE.SET_TOKEN('ENTITY' ,'CONTACT POINTS');
1305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attr_name);
1306: FND_MSG_PUB.ADD;
1307: RAISE FND_API.G_EXC_ERROR;
1308: */
1309: END;
1310: END IF;
1311: END LOOP;

Line 1315: WHEN FND_API.G_EXC_ERROR THEN

1311: END LOOP;
1312:
1313: RETURN l_contact_pt_search_rec;
1314: EXCEPTION
1315: WHEN FND_API.G_EXC_ERROR THEN
1316: RAISE FND_API.G_EXC_ERROR;
1317: WHEN OTHERS THEN
1318: RAISE;
1319: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');

Line 1316: RAISE FND_API.G_EXC_ERROR;

1312:
1313: RETURN l_contact_pt_search_rec;
1314: EXCEPTION
1315: WHEN FND_API.G_EXC_ERROR THEN
1316: RAISE FND_API.G_EXC_ERROR;
1317: WHEN OTHERS THEN
1318: RAISE;
1319: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
1320: FND_MESSAGE.SET_TOKEN('PROC' ,'get_contact_point_rec');

Line 1323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1319: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
1320: FND_MESSAGE.SET_TOKEN('PROC' ,'get_contact_point_rec');
1321: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1322: FND_MSG_PUB.ADD;
1323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1324:
1325: END;
1326:
1327: FUNCTION get_account_info(

Line 1371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1367: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1368: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_account_info');
1369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1370: FND_MSG_PUB.ADD;
1371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1372: END get_account_info;
1373:
1374: FUNCTION get_known_as (
1375: p_party_id IN NUMBER,

Line 1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1402: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1403: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_known_as');
1404: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1405: FND_MSG_PUB.ADD;
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407: END get_known_as;
1408:
1409: FUNCTION get_address (
1410: p_party_site_id IN NUMBER,

Line 1443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1439: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1440: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_address');
1441: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1442: FND_MSG_PUB.ADD;
1443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1444: END get_address;
1445:
1446: FUNCTION get_contact_name (
1447: p_org_contact_id IN NUMBER,

Line 1479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1475: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1476: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_address');
1477: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1478: FND_MSG_PUB.ADD;
1479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1480: END get_contact_name;
1481:
1482: FUNCTION get_phone_number (
1483: p_contact_pt_id IN NUMBER,

Line 1531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1527: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1528: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_phone_number');
1529: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1530: FND_MSG_PUB.ADD;
1531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1532: END get_phone_number;
1533:
1534: -- this will return the concaternation of the
1535: -- orig sytem and the orig system reference

Line 1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1625: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1626: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.GET_SSM_MAPPINGS');
1627: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1628: FND_MSG_PUB.ADD;
1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1630: END get_ssm_mappings ;
1631:
1632: END;