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.AMS_REGISTRANTS_PVT dependencies on FND_MESSAGE

Line 266: FND_MESSAGE.set_name('AMS', 'AMS_NO_NAME_PROVIDED');

262: p_first_name => p_rec.first_name,
263: p_last_name => p_rec.last_name
264: );
265: else
266: FND_MESSAGE.set_name('AMS', 'AMS_NO_NAME_PROVIDED');
267: FND_MSG_PUB.add;
268: RAISE FND_API.g_exc_error;
269: end if;
270:

Line 326: FND_MESSAGE.set_name('AMS', 'AMS_NO_EMAIL_PROVIDED');

322: END LOOP;
323: close email_exists;
324: end if;
325: else
326: FND_MESSAGE.set_name('AMS', 'AMS_NO_EMAIL_PROVIDED');
327: FND_MSG_PUB.add;
328: RAISE FND_API.g_exc_error;
329: end if;
330: EXCEPTION

Line 692: FND_MESSAGE.set_name('AMS', 'ORGANIZATION_CREATE_FAILURE');

688: , 'ROW'
689: , 'ORG - ' || substr(org_rec.organization_name,1,25) || '- ERROR-' || substr(x_msg_data,1,180)
690: );
691: /*
692: FND_MESSAGE.set_name('AMS', 'ORGANIZATION_CREATE_FAILURE');
693: FND_MESSAGE.Set_Token('ROW', 'ORG - ' || substr(org_rec.organization_name,1,25) || '- ERROR-' || substr(x_msg_data,1,180));
694: FND_MSG_PUB.add;
695: */
696: if x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 693: FND_MESSAGE.Set_Token('ROW', 'ORG - ' || substr(org_rec.organization_name,1,25) || '- ERROR-' || substr(x_msg_data,1,180));

689: , 'ORG - ' || substr(org_rec.organization_name,1,25) || '- ERROR-' || substr(x_msg_data,1,180)
690: );
691: /*
692: FND_MESSAGE.set_name('AMS', 'ORGANIZATION_CREATE_FAILURE');
693: FND_MESSAGE.Set_Token('ROW', 'ORG - ' || substr(org_rec.organization_name,1,25) || '- ERROR-' || substr(x_msg_data,1,180));
694: FND_MSG_PUB.add;
695: */
696: if x_return_status = FND_API.g_ret_sts_unexp_error THEN
697: RAISE FND_API.g_exc_unexpected_error;

Line 772: FND_MESSAGE.set_name('AMS', 'AMS_CREATE_PERSON_FAILED');

768: */
769:
770: if x_return_status <> 'S' then
771: --errbuf := 'PERSON - '||substr(person_rec.person_first_name,1,20)||substr(person_rec.person_last_name,1,20)||'- ERROR-'||substr(x_msg_data,1,160);
772: FND_MESSAGE.set_name('AMS', 'AMS_CREATE_PERSON_FAILED');
773: FND_MESSAGE.Set_Token('ROW', 'PERSON - '||substr(person_rec.person_first_name,1,20)||substr(person_rec.person_last_name,1,20)||'- ERROR-'||substr(x_msg_data,1,160));
774: FND_MSG_PUB.add;
775: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
776: RAISE FND_API.g_exc_unexpected_error;

Line 773: FND_MESSAGE.Set_Token('ROW', 'PERSON - '||substr(person_rec.person_first_name,1,20)||substr(person_rec.person_last_name,1,20)||'- ERROR-'||substr(x_msg_data,1,160));

769:
770: if x_return_status <> 'S' then
771: --errbuf := 'PERSON - '||substr(person_rec.person_first_name,1,20)||substr(person_rec.person_last_name,1,20)||'- ERROR-'||substr(x_msg_data,1,160);
772: FND_MESSAGE.set_name('AMS', 'AMS_CREATE_PERSON_FAILED');
773: FND_MESSAGE.Set_Token('ROW', 'PERSON - '||substr(person_rec.person_first_name,1,20)||substr(person_rec.person_last_name,1,20)||'- ERROR-'||substr(x_msg_data,1,160));
774: FND_MSG_PUB.add;
775: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
776: RAISE FND_API.g_exc_unexpected_error;
777: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

Line 870: FND_MESSAGE.set_name('AMS', 'AMS_ORG_CONTACT_FAILURE');

866: */
867:
868: if x_return_status <> 'S' then
869: --errbuf := 'ORG CONTACT - '||substr(person_rec.person_first_name,1,20)||substr(person_rec.person_last_name,1,20)||'- ERROR-'||substr(x_msg_data,1,160);
870: FND_MESSAGE.set_name('AMS', 'AMS_ORG_CONTACT_FAILURE');
871: FND_MESSAGE.Set_Token('ROW', 'ORG CONTACT - '||substr(person_rec.person_first_name,1,20)||substr(person_rec.person_last_name,1,20)||'- ERROR-'||substr(x_msg_data,1,160));
872: FND_MSG_PUB.add;
873: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
874: RAISE FND_API.g_exc_unexpected_error;

Line 871: FND_MESSAGE.Set_Token('ROW', 'ORG CONTACT - '||substr(person_rec.person_first_name,1,20)||substr(person_rec.person_last_name,1,20)||'- ERROR-'||substr(x_msg_data,1,160));

867:
868: if x_return_status <> 'S' then
869: --errbuf := 'ORG CONTACT - '||substr(person_rec.person_first_name,1,20)||substr(person_rec.person_last_name,1,20)||'- ERROR-'||substr(x_msg_data,1,160);
870: FND_MESSAGE.set_name('AMS', 'AMS_ORG_CONTACT_FAILURE');
871: FND_MESSAGE.Set_Token('ROW', 'ORG CONTACT - '||substr(person_rec.person_first_name,1,20)||substr(person_rec.person_last_name,1,20)||'- ERROR-'||substr(x_msg_data,1,160));
872: FND_MSG_PUB.add;
873: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
874: RAISE FND_API.g_exc_unexpected_error;
875: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

Line 929: FND_MESSAGE.set_name('AMS', 'AMS_LOCATION_CREATE_FAILURE');

925: END IF;
926: */
927: if x_return_status <> 'S' then
928: --errbuf := 'LOCATION - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
929: FND_MESSAGE.set_name('AMS', 'AMS_LOCATION_CREATE_FAILURE');
930: FND_MESSAGE.Set_Token('ROW', 'LOCATION - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
931: FND_MSG_PUB.add;
932: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
933: RAISE FND_API.g_exc_unexpected_error;

Line 930: FND_MESSAGE.Set_Token('ROW', 'LOCATION - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));

926: */
927: if x_return_status <> 'S' then
928: --errbuf := 'LOCATION - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
929: FND_MESSAGE.set_name('AMS', 'AMS_LOCATION_CREATE_FAILURE');
930: FND_MESSAGE.Set_Token('ROW', 'LOCATION - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
931: FND_MSG_PUB.add;
932: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
933: RAISE FND_API.g_exc_unexpected_error;
934: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

Line 995: FND_MESSAGE.set_name('AMS', 'AMS_PART_SITE_CREATION_FAILURE');

991: END IF;
992: */
993: if x_return_status <> 'S' then
994: --errbuf := 'PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
995: FND_MESSAGE.set_name('AMS', 'AMS_PART_SITE_CREATION_FAILURE');
996: FND_MESSAGE.Set_Token('ROW','PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
997: FND_MSG_PUB.add;
998: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
999: RAISE FND_API.g_exc_unexpected_error;

Line 996: FND_MESSAGE.Set_Token('ROW','PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));

992: */
993: if x_return_status <> 'S' then
994: --errbuf := 'PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
995: FND_MESSAGE.set_name('AMS', 'AMS_PART_SITE_CREATION_FAILURE');
996: FND_MESSAGE.Set_Token('ROW','PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
997: FND_MSG_PUB.add;
998: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
999: RAISE FND_API.g_exc_unexpected_error;
1000: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

Line 1035: FND_MESSAGE.set_name('AMS', 'AMS_PART_SITE_CREATION_FAILURE');

1031: END IF;
1032: */
1033: if x_return_status <> 'S' then
1034: --errbuf := 'PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
1035: FND_MESSAGE.set_name('AMS', 'AMS_PART_SITE_CREATION_FAILURE');
1036: FND_MESSAGE.Set_Token('ROW','PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
1037: FND_MSG_PUB.add;
1038: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1039: RAISE FND_API.g_exc_unexpected_error;

Line 1036: FND_MESSAGE.Set_Token('ROW','PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));

1032: */
1033: if x_return_status <> 'S' then
1034: --errbuf := 'PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
1035: FND_MESSAGE.set_name('AMS', 'AMS_PART_SITE_CREATION_FAILURE');
1036: FND_MESSAGE.Set_Token('ROW','PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
1037: FND_MSG_PUB.add;
1038: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1039: RAISE FND_API.g_exc_unexpected_error;
1040: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

Line 1106: FND_MESSAGE.set_name('AMS', 'AMS_PSITE_CONTACT_CREATE_FAILURE');

1102: END IF;
1103: */
1104: if x_return_status <> 'S' then
1105: --errbuf := 'CONT PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
1106: FND_MESSAGE.set_name('AMS', 'AMS_PSITE_CONTACT_CREATE_FAILURE');
1107: FND_MESSAGE.Set_Token('ROW','CONT PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
1108: FND_MSG_PUB.add;
1109: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1110: RAISE FND_API.g_exc_unexpected_error;

Line 1107: FND_MESSAGE.Set_Token('ROW','CONT PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));

1103: */
1104: if x_return_status <> 'S' then
1105: --errbuf := 'CONT PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
1106: FND_MESSAGE.set_name('AMS', 'AMS_PSITE_CONTACT_CREATE_FAILURE');
1107: FND_MESSAGE.Set_Token('ROW','CONT PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
1108: FND_MSG_PUB.add;
1109: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1110: RAISE FND_API.g_exc_unexpected_error;
1111: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

Line 1145: FND_MESSAGE.set_name('AMS', 'AMS_PART_SITE_CREATION_FAILURE');

1141: END IF;
1142: */
1143: if x_return_status <> 'S' then
1144: --errbuf := 'PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
1145: FND_MESSAGE.set_name('AMS', 'AMS_PART_SITE_CREATION_FAILURE');
1146: FND_MESSAGE.Set_Token('ROW','PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
1147: FND_MSG_PUB.add;
1148: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1149: RAISE FND_API.g_exc_unexpected_error;

Line 1146: FND_MESSAGE.Set_Token('ROW','PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));

1142: */
1143: if x_return_status <> 'S' then
1144: --errbuf := 'PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
1145: FND_MESSAGE.set_name('AMS', 'AMS_PART_SITE_CREATION_FAILURE');
1146: FND_MESSAGE.Set_Token('ROW','PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
1147: FND_MSG_PUB.add;
1148: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1149: RAISE FND_API.g_exc_unexpected_error;
1150: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

Line 1218: FND_MESSAGE.set_name('AMS', 'AMS_CONTACT_PHONE_ERROR');

1214: */
1215:
1216: if x_return_status <> 'S' then
1217: --errbuf := 'PHONE - '||substr(x_phone_number,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
1218: FND_MESSAGE.set_name('AMS', 'AMS_CONTACT_PHONE_ERROR');
1219: FND_MESSAGE.Set_Token('ROW','PHONE - '||substr(x_phone_number,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
1220: FND_MSG_PUB.add;
1221: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1222: RAISE FND_API.g_exc_unexpected_error;

Line 1219: FND_MESSAGE.Set_Token('ROW','PHONE - '||substr(x_phone_number,1,25)||'- ERROR-'||substr(x_msg_data,1,180));

1215:
1216: if x_return_status <> 'S' then
1217: --errbuf := 'PHONE - '||substr(x_phone_number,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
1218: FND_MESSAGE.set_name('AMS', 'AMS_CONTACT_PHONE_ERROR');
1219: FND_MESSAGE.Set_Token('ROW','PHONE - '||substr(x_phone_number,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
1220: FND_MSG_PUB.add;
1221: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1222: RAISE FND_API.g_exc_unexpected_error;
1223: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

Line 1282: FND_MESSAGE.set_name('AMS', 'AMS_CONTACT_EMAIL_ERROR');

1278: END IF;
1279: */
1280: if x_return_status <> 'S' then
1281: --errbuf := 'EMAIL - '||substr(x_email_address,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
1282: FND_MESSAGE.set_name('AMS', 'AMS_CONTACT_EMAIL_ERROR');
1283: FND_MESSAGE.Set_Token('ROW','EMAIL - '||substr(x_email_address,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
1284: FND_MSG_PUB.add;
1285: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1286: RAISE FND_API.g_exc_unexpected_error;

Line 1283: FND_MESSAGE.Set_Token('ROW','EMAIL - '||substr(x_email_address,1,25)||'- ERROR-'||substr(x_msg_data,1,180));

1279: */
1280: if x_return_status <> 'S' then
1281: --errbuf := 'EMAIL - '||substr(x_email_address,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
1282: FND_MESSAGE.set_name('AMS', 'AMS_CONTACT_EMAIL_ERROR');
1283: FND_MESSAGE.Set_Token('ROW','EMAIL - '||substr(x_email_address,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
1284: FND_MSG_PUB.add;
1285: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1286: RAISE FND_API.g_exc_unexpected_error;
1287: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

Line 1435: FND_MESSAGE.set_name('AMS', 'AMS_PERSON_ERROR');

1431: */
1432:
1433: if x_return_status <> 'S' then
1434: --errbuf := 'PERSON - '||substr(person_rec.person_first_name,1,20)||substr(person_rec.person_last_name,1,20)||'- ERROR-'||substr(x_msg_data,1,160);
1435: FND_MESSAGE.set_name('AMS', 'AMS_PERSON_ERROR');
1436: FND_MESSAGE.Set_Token('ROW','PERSON - '||substr(person_rec.person_first_name,1,20)||substr(person_rec.person_last_name,1,20)||'- ERROR-'||substr(x_msg_data,1,160));
1437: FND_MSG_PUB.add;
1438: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1439: RAISE FND_API.g_exc_unexpected_error;

Line 1436: FND_MESSAGE.Set_Token('ROW','PERSON - '||substr(person_rec.person_first_name,1,20)||substr(person_rec.person_last_name,1,20)||'- ERROR-'||substr(x_msg_data,1,160));

1432:
1433: if x_return_status <> 'S' then
1434: --errbuf := 'PERSON - '||substr(person_rec.person_first_name,1,20)||substr(person_rec.person_last_name,1,20)||'- ERROR-'||substr(x_msg_data,1,160);
1435: FND_MESSAGE.set_name('AMS', 'AMS_PERSON_ERROR');
1436: FND_MESSAGE.Set_Token('ROW','PERSON - '||substr(person_rec.person_first_name,1,20)||substr(person_rec.person_last_name,1,20)||'- ERROR-'||substr(x_msg_data,1,160));
1437: FND_MSG_PUB.add;
1438: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1439: RAISE FND_API.g_exc_unexpected_error;
1440: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

Line 1502: FND_MESSAGE.set_name('AMS', 'AMS_LOCATION_ERROR');

1498: */
1499:
1500: if x_return_status <> 'S' then
1501: --errbuf := 'LOCATION - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
1502: FND_MESSAGE.set_name('AMS', 'AMS_LOCATION_ERROR');
1503: FND_MESSAGE.Set_Token('ROW','LOCATION - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
1504: FND_MSG_PUB.add;
1505: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1506: RAISE FND_API.g_exc_unexpected_error;

Line 1503: FND_MESSAGE.Set_Token('ROW','LOCATION - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));

1499:
1500: if x_return_status <> 'S' then
1501: --errbuf := 'LOCATION - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
1502: FND_MESSAGE.set_name('AMS', 'AMS_LOCATION_ERROR');
1503: FND_MESSAGE.Set_Token('ROW','LOCATION - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
1504: FND_MSG_PUB.add;
1505: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1506: RAISE FND_API.g_exc_unexpected_error;
1507: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

Line 1607: FND_MESSAGE.set_name('AMS', 'AMS_PSITE_ERROR');

1603: Write_log(L_API_NAME, 'Error Creating Site');
1604:
1605:
1606: --errbuf := 'PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
1607: FND_MESSAGE.set_name('AMS', 'AMS_PSITE_ERROR');
1608: FND_MESSAGE.Set_Token('ROW','PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
1609: FND_MSG_PUB.add;
1610: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1611: RAISE FND_API.g_exc_unexpected_error;

Line 1608: FND_MESSAGE.Set_Token('ROW','PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));

1604:
1605:
1606: --errbuf := 'PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
1607: FND_MESSAGE.set_name('AMS', 'AMS_PSITE_ERROR');
1608: FND_MESSAGE.Set_Token('ROW','PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
1609: FND_MSG_PUB.add;
1610: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1611: RAISE FND_API.g_exc_unexpected_error;
1612: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

Line 1643: FND_MESSAGE.set_name('AMS', 'AMS_PART_SITE_CREATION_FAILURE');

1639: END IF;
1640: */
1641: if x_return_status <> 'S' then
1642: --errbuf := 'PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
1643: FND_MESSAGE.set_name('AMS', 'AMS_PART_SITE_CREATION_FAILURE');
1644: FND_MESSAGE.Set_Token('ROW','PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
1645: FND_MSG_PUB.add;
1646: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1647: RAISE FND_API.g_exc_unexpected_error;

Line 1644: FND_MESSAGE.Set_Token('ROW','PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));

1640: */
1641: if x_return_status <> 'S' then
1642: --errbuf := 'PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
1643: FND_MESSAGE.set_name('AMS', 'AMS_PART_SITE_CREATION_FAILURE');
1644: FND_MESSAGE.Set_Token('ROW','PSITE - '||substr(location_rec.address1,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
1645: FND_MSG_PUB.add;
1646: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1647: RAISE FND_API.g_exc_unexpected_error;
1648: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

Line 1713: FND_MESSAGE.set_name('AMS', 'AMS_CONTACT_PHONE_ERROR');

1709: END IF;
1710: */
1711: if x_return_status <> 'S' then
1712: --errbuf := 'PHONE - '||substr(x_phone_number,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
1713: FND_MESSAGE.set_name('AMS', 'AMS_CONTACT_PHONE_ERROR');
1714: FND_MESSAGE.Set_Token('ROW','PHONE - '||substr(x_phone_number,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
1715: FND_MSG_PUB.add;
1716: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1717: RAISE FND_API.g_exc_unexpected_error;

Line 1714: FND_MESSAGE.Set_Token('ROW','PHONE - '||substr(x_phone_number,1,25)||'- ERROR-'||substr(x_msg_data,1,180));

1710: */
1711: if x_return_status <> 'S' then
1712: --errbuf := 'PHONE - '||substr(x_phone_number,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
1713: FND_MESSAGE.set_name('AMS', 'AMS_CONTACT_PHONE_ERROR');
1714: FND_MESSAGE.Set_Token('ROW','PHONE - '||substr(x_phone_number,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
1715: FND_MSG_PUB.add;
1716: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1717: RAISE FND_API.g_exc_unexpected_error;
1718: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

Line 1780: FND_MESSAGE.set_name('AMS', 'AMS_CONTACT_EMAIL_ERROR');

1776: END IF;
1777: */
1778: if x_return_status <> 'S' then
1779: --errbuf := 'EMAIL - '||substr(x_email_address,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
1780: FND_MESSAGE.set_name('AMS', 'AMS_CONTACT_EMAIL_ERROR');
1781: FND_MESSAGE.Set_Token('ROW','EMAIL - '||substr(x_email_address,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
1782: FND_MSG_PUB.add;
1783: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1784: RAISE FND_API.g_exc_unexpected_error;

Line 1781: FND_MESSAGE.Set_Token('ROW','EMAIL - '||substr(x_email_address,1,25)||'- ERROR-'||substr(x_msg_data,1,180));

1777: */
1778: if x_return_status <> 'S' then
1779: --errbuf := 'EMAIL - '||substr(x_email_address,1,25)||'- ERROR-'||substr(x_msg_data,1,180);
1780: FND_MESSAGE.set_name('AMS', 'AMS_CONTACT_EMAIL_ERROR');
1781: FND_MESSAGE.Set_Token('ROW','EMAIL - '||substr(x_email_address,1,25)||'- ERROR-'||substr(x_msg_data,1,180));
1782: FND_MSG_PUB.add;
1783: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1784: RAISE FND_API.g_exc_unexpected_error;
1785: ELSIF x_return_status = FND_API.g_ret_sts_error THEN