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_MSG_PUB

Line 50: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

46:
47: --
48: -- This procedure is used for existence checking for party of type person.
49: --
50: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
51: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
52: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
53:
54:

Line 51: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

47: --
48: -- This procedure is used for existence checking for party of type person.
49: --
50: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
51: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
52: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
53:
54:
55: --=============================================================================

Line 52: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

48: -- This procedure is used for existence checking for party of type person.
49: --
50: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
51: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
52: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
53:
54:
55: --=============================================================================
56: -- Start of Comment

Line 254: FND_MSG_PUB.initialize;

250:
251: -- Initialize message list if p_init_msg_list is set to TRUE.
252: IF FND_API.to_Boolean( p_init_msg_list )
253: THEN
254: FND_MSG_PUB.initialize;
255: END IF;
256:
257:
258: x_return_status := FND_API.g_ret_sts_success;

Line 267: FND_MSG_PUB.add;

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:
271: if p_rec.EMAIL_ADDRESS is not null THEN

Line 327: FND_MSG_PUB.add;

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
331: WHEN FND_API.g_exc_error THEN

Line 333: FND_MSG_PUB.count_and_get(

329: end if;
330: EXCEPTION
331: WHEN FND_API.g_exc_error THEN
332: x_return_status := FND_API.g_ret_sts_error;
333: FND_MSG_PUB.count_and_get(
334: p_encoded => FND_API.g_false,
335: p_count => x_msg_count,
336: p_data => x_msg_data
337: );

Line 341: FND_MSG_PUB.count_and_get(

337: );
338:
339: WHEN FND_API.g_exc_unexpected_error THEN
340: x_return_status := FND_API.g_ret_sts_unexp_error ;
341: FND_MSG_PUB.count_and_get(
342: p_encoded => FND_API.g_false,
343: p_count => x_msg_count,
344: p_data => x_msg_data
345: );

Line 347: FND_MSG_PUB.count_and_get(

343: p_count => x_msg_count,
344: p_data => x_msg_data
345: );
346: WHEN others THEN
347: FND_MSG_PUB.count_and_get(
348: p_encoded => FND_API.g_false,
349: p_count => x_msg_count,
350: p_data => x_msg_data
351: );

Line 507: FND_MSG_PUB.initialize;

503:
504: -- Initialize message list if p_init_msg_list is set to TRUE.
505: IF FND_API.to_Boolean( p_init_msg_list )
506: THEN
507: FND_MSG_PUB.initialize;
508: END IF;
509:
510: -- RETURN;
511: x_return_status := FND_API.g_ret_sts_success;

Line 673: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

669:
670: /*
671: if x_msg_count > 1 then
672: FOR i IN 1..x_msg_count LOOP
673: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
674: x_tmp_var1 := x_tmp_var1 || ' '|| x_tmp_var;
675: END LOOP;
676: x_msg_data := x_tmp_var1;
677: end if;

Line 694: FND_MSG_PUB.add;

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;
698: elsif x_return_status = FND_API.g_ret_sts_error THEN

Line 763: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

759: );
760: /*
761: if x_msg_count > 1 then
762: FOR i IN 1..x_msg_count LOOP
763: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
764: x_tmp_var1 := x_tmp_var1 || ' '|| x_tmp_var;
765: END LOOP;
766: x_msg_data := x_tmp_var1;
767: END IF;

Line 774: FND_MSG_PUB.add;

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
778: RAISE FND_API.g_exc_error;

Line 861: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

857:
858: /*
859: if x_msg_count > 1 then
860: FOR i IN 1..x_msg_count LOOP
861: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
862: x_tmp_var1 := x_tmp_var1 || ' '|| x_tmp_var;
863: END LOOP;
864: x_msg_data := x_tmp_var1;
865: END IF;

Line 872: FND_MSG_PUB.add;

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
876: RAISE FND_API.g_exc_error;

Line 921: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

917: );
918: /*
919: if x_msg_count > 1 then
920: FOR i IN 1..x_msg_count LOOP
921: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
922: x_tmp_var1 := x_tmp_var1 || ' '|| x_tmp_var;
923: END LOOP;
924: x_msg_data := x_tmp_var1;
925: END IF;

Line 931: FND_MSG_PUB.add;

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
935: RAISE FND_API.g_exc_error;

Line 987: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

983:
984: /*
985: if x_msg_count > 1 then
986: FOR i IN 1..x_msg_count LOOP
987: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
988: x_tmp_var1 := x_tmp_var1 || ' '|| x_tmp_var;
989: END LOOP;
990: x_msg_data := x_tmp_var1;
991: END IF;

Line 997: FND_MSG_PUB.add;

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
1001: RAISE FND_API.g_exc_error;

Line 1027: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1023:
1024: /*
1025: if x_msg_count > 1 then
1026: FOR i IN 1..x_msg_count LOOP
1027: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1028: x_tmp_var1 := x_tmp_var1 || ' '|| x_tmp_var;
1029: END LOOP;
1030: x_msg_data := x_tmp_var1;
1031: END IF;

Line 1037: FND_MSG_PUB.add;

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
1041: RAISE FND_API.g_exc_error;

Line 1098: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1094:
1095: /*
1096: if x_msg_count > 1 then
1097: FOR i IN 1..x_msg_count LOOP
1098: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1099: x_tmp_var1 := x_tmp_var1 || ' '|| x_tmp_var;
1100: END LOOP;
1101: x_msg_data := x_tmp_var1;
1102: END IF;

Line 1108: FND_MSG_PUB.add;

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
1112: RAISE FND_API.g_exc_error;

Line 1137: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1133:
1134: /*
1135: if x_msg_count > 1 then
1136: FOR i IN 1..x_msg_count LOOP
1137: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1138: x_tmp_var1 := x_tmp_var1 || ' '|| x_tmp_var;
1139: END LOOP;
1140: x_msg_data := x_tmp_var1;
1141: END IF;

Line 1147: FND_MSG_PUB.add;

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
1151: RAISE FND_API.g_exc_error;

Line 1209: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1205: x_contact_point_id);
1206: /*
1207: if x_msg_count > 1 then
1208: FOR i IN 1..x_msg_count LOOP
1209: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1210: x_tmp_var1 := x_tmp_var1 || ' '|| x_tmp_var;
1211: END LOOP;
1212: x_msg_data := x_tmp_var1;
1213: END IF;

Line 1220: FND_MSG_PUB.add;

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
1224: RAISE FND_API.g_exc_error;

Line 1274: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1270: x_contact_point_id);
1271: /*
1272: if x_msg_count > 1 then
1273: FOR i IN 1..x_msg_count LOOP
1274: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1275: x_tmp_var1 := x_tmp_var1 || ' '|| x_tmp_var;
1276: END LOOP;
1277: x_msg_data := x_tmp_var1;
1278: END IF;

Line 1284: FND_MSG_PUB.add;

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
1288: RAISE FND_API.g_exc_error;

Line 1426: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1422: x_person_profile_id);
1423: /*
1424: if x_msg_count > 1 then
1425: FOR i IN 1..x_msg_count LOOP
1426: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1427: x_tmp_var1 := x_tmp_var1 || ' '|| x_tmp_var;
1428: END LOOP;
1429: x_msg_data := x_tmp_var1;
1430: END IF;

Line 1437: FND_MSG_PUB.add;

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
1441: RAISE FND_API.g_exc_error;

Line 1493: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1489:
1490: /*
1491: if x_msg_count > 1 then
1492: FOR i IN 1..x_msg_count LOOP
1493: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1494: x_tmp_var1 := x_tmp_var1 || ' '|| x_tmp_var;
1495: END LOOP;
1496: x_msg_data := x_tmp_var1;
1497: END IF;

Line 1504: FND_MSG_PUB.add;

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
1508: RAISE FND_API.g_exc_error;

Line 1583: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1579:
1580: /*
1581: if x_msg_count > 1 then
1582: FOR i IN 1..x_msg_count LOOP
1583: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1584: x_tmp_var1 := x_tmp_var1 || ' '|| x_tmp_var;
1585: END LOOP;
1586: x_msg_data := x_tmp_var1;
1587: END IF;

Line 1609: FND_MSG_PUB.add;

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
1613: RAISE FND_API.g_exc_error;

Line 1635: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1631:
1632: /*
1633: if x_msg_count > 1 then
1634: FOR i IN 1..x_msg_count LOOP
1635: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1636: x_tmp_var1 := x_tmp_var1 || ' '|| x_tmp_var;
1637: END LOOP;
1638: x_msg_data := x_tmp_var1;
1639: END IF;

Line 1645: FND_MSG_PUB.add;

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
1649: RAISE FND_API.g_exc_error;

Line 1705: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1701: x_contact_point_id);
1702: /*
1703: if x_msg_count > 1 then
1704: FOR i IN 1..x_msg_count LOOP
1705: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1706: x_tmp_var1 := x_tmp_var1 || ' '|| x_tmp_var;
1707: END LOOP;
1708: x_msg_data := x_tmp_var1;
1709: END IF;

Line 1715: FND_MSG_PUB.add;

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
1719: RAISE FND_API.g_exc_error;

Line 1772: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1768:
1769: /*
1770: if x_msg_count > 1 then
1771: FOR i IN 1..x_msg_count LOOP
1772: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1773: x_tmp_var1 := x_tmp_var1 || ' '|| x_tmp_var;
1774: END LOOP;
1775: x_msg_data := x_tmp_var1;
1776: END IF;

Line 1782: FND_MSG_PUB.add;

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
1786: RAISE FND_API.g_exc_error;

Line 1795: FND_MSG_PUB.count_and_get(

1791: end if; -- b2c
1792: EXCEPTION
1793: WHEN FND_API.g_exc_error THEN
1794: x_return_status := FND_API.g_ret_sts_error;
1795: FND_MSG_PUB.count_and_get(
1796: p_encoded => FND_API.g_false,
1797: p_count => x_msg_count,
1798: p_data => x_msg_data
1799: );

Line 1803: FND_MSG_PUB.count_and_get(

1799: );
1800:
1801: WHEN FND_API.g_exc_unexpected_error THEN
1802: x_return_status := FND_API.g_ret_sts_unexp_error ;
1803: FND_MSG_PUB.count_and_get(
1804: p_encoded => FND_API.g_false,
1805: p_count => x_msg_count,
1806: p_data => x_msg_data
1807: );

Line 1811: FND_MSG_PUB.count_and_get(

1807: );
1808:
1809: WHEN OTHERS THEN
1810: x_return_status := FND_API.g_ret_sts_unexp_error ;
1811: FND_MSG_PUB.count_and_get(
1812: p_encoded => FND_API.g_false,
1813: p_count => x_msg_count,
1814: p_data => x_msg_data
1815: );

Line 2421: FND_MSG_PUB.initialize;

2417:
2418: -- Initialize message list if p_init_msg_list is set to TRUE.
2419: IF FND_API.to_Boolean( p_init_msg_list )
2420: THEN
2421: FND_MSG_PUB.initialize;
2422: END IF;
2423:
2424: x_return_status := FND_API.g_ret_sts_success;
2425: /*

Line 2637: FOR i IN 1 .. FND_MSG_PUB.count_msg LOOP

2633: AMS_Utility_PVT.Debug_Message('Error');
2634: END IF;*/
2635: Write_log(L_API_NAME, 'Error');
2636: /*
2637: FOR i IN 1 .. FND_MSG_PUB.count_msg LOOP
2638: -- AMS_Utility_PVT.Debug_Message(FND_MSG_PUB.get(i, FND_API.g_false));
2639: END LOOP;
2640: */
2641: RAISE FND_API.g_exc_error;

Line 2638: -- AMS_Utility_PVT.Debug_Message(FND_MSG_PUB.get(i, FND_API.g_false));

2634: END IF;*/
2635: Write_log(L_API_NAME, 'Error');
2636: /*
2637: FOR i IN 1 .. FND_MSG_PUB.count_msg LOOP
2638: -- AMS_Utility_PVT.Debug_Message(FND_MSG_PUB.get(i, FND_API.g_false));
2639: END LOOP;
2640: */
2641: RAISE FND_API.g_exc_error;
2642: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 2649: /*FOR i IN 1 .. FND_MSG_PUB.count_msg LOOP

2645: AMS_Utility_PVT.Debug_Message('Unexp Error');
2646: END IF;
2647: */
2648: Write_log(L_API_NAME, 'Unexp Error');
2649: /*FOR i IN 1 .. FND_MSG_PUB.count_msg LOOP
2650: AMS_Utility_PVT.Debug_Message(FND_MSG_PUB.get(i, FND_API.g_false));
2651: END LOOP; */
2652: RAISE FND_API.g_exc_unexpected_error;
2653: end if;

Line 2650: AMS_Utility_PVT.Debug_Message(FND_MSG_PUB.get(i, FND_API.g_false));

2646: END IF;
2647: */
2648: Write_log(L_API_NAME, 'Unexp Error');
2649: /*FOR i IN 1 .. FND_MSG_PUB.count_msg LOOP
2650: AMS_Utility_PVT.Debug_Message(FND_MSG_PUB.get(i, FND_API.g_false));
2651: END LOOP; */
2652: RAISE FND_API.g_exc_unexpected_error;
2653: end if;
2654: /*

Line 2694: FND_MSG_PUB.count_and_get(

2690: EXCEPTION
2691: WHEN FND_API.g_exc_error THEN
2692: rollback to Register_get_party_id_PVT;
2693: x_return_status := FND_API.g_ret_sts_error;
2694: FND_MSG_PUB.count_and_get(
2695: p_encoded => FND_API.g_false,
2696: p_count => x_msg_count,
2697: p_data => x_msg_data
2698: );

Line 2703: FND_MSG_PUB.count_and_get(

2699:
2700: WHEN FND_API.g_exc_unexpected_error THEN
2701: rollback to Register_get_party_id_PVT;
2702: x_return_status := FND_API.g_ret_sts_unexp_error ;
2703: FND_MSG_PUB.count_and_get(
2704: p_encoded => FND_API.g_false,
2705: p_count => x_msg_count,
2706: p_data => x_msg_data
2707: );

Line 2712: FND_MSG_PUB.count_and_get(

2708:
2709: WHEN OTHERS THEN
2710: rollback to Register_get_party_id_PVT;
2711: x_return_status := FND_API.g_ret_sts_unexp_error ;
2712: FND_MSG_PUB.count_and_get(
2713: p_encoded => FND_API.g_false,
2714: p_count => x_msg_count,
2715: p_data => x_msg_data
2716: );