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

Line 73: FND_MSG_PUB.Initialize;

69: x_return_status := FND_API.G_RET_STS_SUCCESS;
70: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
71: IF FND_API.to_boolean(p_init_msg_list)
72: THEN
73: FND_MSG_PUB.Initialize;
74: END IF;
75: IF p_jurisdiction_id IS NULL
76: THEN
77: -- this is a development error

Line 107: FND_MSG_PUB.Add;

103: IF Nvl( p_registration_id, -99) <> l_registration_id
104: THEN
105: x_return_status := FND_API.G_RET_STS_ERROR;
106: FND_MESSAGE.SET_NAME('XLE', 'XLE_REG_NUM_DUPLICATE_WARN');
107: FND_MSG_PUB.Add;
108: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
109: THEN
110: g_log_msg := 'RegNumber is not unique ' || p_registration_number;
111: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 215: FND_MSG_PUB.Count_And_Get

211: x_msg_data,
212: x_msg_count);
213: END IF; -- Check country code
214: END IF; -- Reg Code and Number provided
215: FND_MSG_PUB.Count_And_Get
216: (p_count => x_msg_count,
217: p_data => x_msg_data);
218: EXCEPTION
219: WHEN FND_API.G_EXC_ERROR THEN

Line 227: FND_MSG_PUB.Count_And_Get

223: FND_LOG.STRING(G_LEVEL_STATEMENT,
224: G_MODULE_NAME || l_api_name, g_log_msg);
225: END IF;
226: x_return_status := FND_API.G_RET_STS_ERROR ;
227: FND_MSG_PUB.Count_And_Get
228: ( p_count => x_msg_count,
229: p_data => x_msg_data
230: );
231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 239: FND_MSG_PUB.Count_And_Get

235: FND_LOG.STRING(G_LEVEL_STATEMENT,
236: G_MODULE_NAME || l_api_name, g_log_msg);
237: END IF;
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
239: FND_MSG_PUB.Count_And_Get
240: ( p_count => x_msg_count,
241: p_data => x_msg_data
242: );
243: WHEN OTHERS THEN

Line 251: IF FND_MSG_PUB.Check_Msg_Level

247: FND_LOG.STRING(G_LEVEL_STATEMENT,
248: G_MODULE_NAME || l_api_name, g_log_msg);
249: END IF;
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
251: IF FND_MSG_PUB.Check_Msg_Level
252: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
253: THEN
254: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
255: l_api_name);

Line 252: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

248: G_MODULE_NAME || l_api_name, g_log_msg);
249: END IF;
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
251: IF FND_MSG_PUB.Check_Msg_Level
252: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
253: THEN
254: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
255: l_api_name);
256: END IF;

Line 254: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
251: IF FND_MSG_PUB.Check_Msg_Level
252: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
253: THEN
254: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
255: l_api_name);
256: END IF;
257: FND_MSG_PUB.Count_And_Get
258: ( p_count => x_msg_count,

Line 257: FND_MSG_PUB.Count_And_Get

253: THEN
254: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
255: l_api_name);
256: END IF;
257: FND_MSG_PUB.Count_And_Get
258: ( p_count => x_msg_count,
259: p_data => x_msg_data
260: );
261: END Validate_Reg_Number;

Line 547: FND_MSG_PUB.Add;

543: THEN
544: FND_MESSAGE.SET_NAME('XLE', 'XLE_INVALID_REG_NUM_ERR');
545: FND_MESSAGE.SET_TOKEN('REG_CODE', p_registration_code);
546: FND_MESSAGE.SET_TOKEN('REG_NUM', p_registration_number);
547: FND_MSG_PUB.Add;
548: END IF;
549: FND_MSG_PUB.Count_And_Get
550: (p_count => x_msg_count,
551: p_data => x_msg_data);

Line 549: FND_MSG_PUB.Count_And_Get

545: FND_MESSAGE.SET_TOKEN('REG_CODE', p_registration_code);
546: FND_MESSAGE.SET_TOKEN('REG_NUM', p_registration_number);
547: FND_MSG_PUB.Add;
548: END IF;
549: FND_MSG_PUB.Count_And_Get
550: (p_count => x_msg_count,
551: p_data => x_msg_data);
552: EXCEPTION
553: WHEN FND_API.G_EXC_ERROR THEN

Line 561: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

557: FND_LOG.STRING(G_LEVEL_STATEMENT,
558: G_MODULE_NAME || l_api_name, g_log_msg);
559: END IF;
560: x_return_status := FND_API.G_RET_STS_ERROR ;
561: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
562: l_api_name);
563: FND_MSG_PUB.Count_And_Get
564: ( p_count => x_msg_count,
565: p_data => x_msg_data

Line 563: FND_MSG_PUB.Count_And_Get

559: END IF;
560: x_return_status := FND_API.G_RET_STS_ERROR ;
561: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
562: l_api_name);
563: FND_MSG_PUB.Count_And_Get
564: ( p_count => x_msg_count,
565: p_data => x_msg_data
566: );
567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 575: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

571: FND_LOG.STRING(G_LEVEL_STATEMENT,
572: G_MODULE_NAME || l_api_name, g_log_msg);
573: END IF;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
575: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
576: l_api_name);
577: FND_MSG_PUB.Count_And_Get
578: ( p_count => x_msg_count,
579: p_data => x_msg_data

Line 577: FND_MSG_PUB.Count_And_Get

573: END IF;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
575: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
576: l_api_name);
577: FND_MSG_PUB.Count_And_Get
578: ( p_count => x_msg_count,
579: p_data => x_msg_data
580: );
581: WHEN OTHERS THEN

Line 589: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

585: FND_LOG.STRING(G_LEVEL_STATEMENT,
586: G_MODULE_NAME || l_api_name, g_log_msg);
587: END IF;
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
589: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
590: l_api_name);
591: FND_MSG_PUB.Count_And_Get
592: ( p_count => x_msg_count,
593: p_data => x_msg_data

Line 591: FND_MSG_PUB.Count_And_Get

587: END IF;
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
589: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
590: l_api_name);
591: FND_MSG_PUB.Count_And_Get
592: ( p_count => x_msg_count,
593: p_data => x_msg_data
594: );
595: END do_es_regnum_validations;

Line 818: FND_MSG_PUB.Add;

814: THEN
815: FND_MESSAGE.SET_NAME('XLE', 'XLE_INVALID_REG_NUM_ERR');
816: FND_MESSAGE.SET_TOKEN('REG_CODE', p_registration_code);
817: FND_MESSAGE.SET_TOKEN('REG_NUM', p_registration_number);
818: FND_MSG_PUB.Add;
819: END IF;
820: FND_MSG_PUB.Count_And_Get
821: (p_count => x_msg_count,
822: p_data => x_msg_data);

Line 820: FND_MSG_PUB.Count_And_Get

816: FND_MESSAGE.SET_TOKEN('REG_CODE', p_registration_code);
817: FND_MESSAGE.SET_TOKEN('REG_NUM', p_registration_number);
818: FND_MSG_PUB.Add;
819: END IF;
820: FND_MSG_PUB.Count_And_Get
821: (p_count => x_msg_count,
822: p_data => x_msg_data);
823: EXCEPTION
824: WHEN FND_API.G_EXC_ERROR THEN

Line 832: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

828: FND_LOG.STRING(G_LEVEL_STATEMENT,
829: G_MODULE_NAME || l_api_name, g_log_msg);
830: END IF;
831: x_return_status := FND_API.G_RET_STS_ERROR ;
832: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
833: l_api_name);
834: FND_MSG_PUB.Count_And_Get
835: ( p_count => x_msg_count,
836: p_data => x_msg_data

Line 834: FND_MSG_PUB.Count_And_Get

830: END IF;
831: x_return_status := FND_API.G_RET_STS_ERROR ;
832: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
833: l_api_name);
834: FND_MSG_PUB.Count_And_Get
835: ( p_count => x_msg_count,
836: p_data => x_msg_data
837: );
838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 846: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

842: FND_LOG.STRING(G_LEVEL_STATEMENT,
843: G_MODULE_NAME || l_api_name, g_log_msg);
844: END IF;
845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
846: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
847: l_api_name);
848: FND_MSG_PUB.Count_And_Get
849: ( p_count => x_msg_count,
850: p_data => x_msg_data

Line 848: FND_MSG_PUB.Count_And_Get

844: END IF;
845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
846: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
847: l_api_name);
848: FND_MSG_PUB.Count_And_Get
849: ( p_count => x_msg_count,
850: p_data => x_msg_data
851: );
852: WHEN OTHERS THEN

Line 860: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

856: FND_LOG.STRING(G_LEVEL_STATEMENT,
857: G_MODULE_NAME || l_api_name, g_log_msg);
858: END IF;
859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
860: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
861: l_api_name);
862: FND_MSG_PUB.Count_And_Get
863: ( p_count => x_msg_count,
864: p_data => x_msg_data

Line 862: FND_MSG_PUB.Count_And_Get

858: END IF;
859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
860: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
861: l_api_name);
862: FND_MSG_PUB.Count_And_Get
863: ( p_count => x_msg_count,
864: p_data => x_msg_data
865: );
866: END do_pt_regnum_validations;

Line 1236: FND_MSG_PUB.Add;

1232: THEN
1233: FND_MESSAGE.SET_NAME('XLE', 'XLE_INVALID_REG_NUM_ERR');
1234: FND_MESSAGE.SET_TOKEN('REG_CODE', p_registration_code);
1235: FND_MESSAGE.SET_TOKEN('REG_NUM', p_registration_number);
1236: FND_MSG_PUB.Add;
1237: END IF;
1238: FND_MSG_PUB.Count_And_Get
1239: (p_count => x_msg_count,
1240: p_data => x_msg_data);

Line 1238: FND_MSG_PUB.Count_And_Get

1234: FND_MESSAGE.SET_TOKEN('REG_CODE', p_registration_code);
1235: FND_MESSAGE.SET_TOKEN('REG_NUM', p_registration_number);
1236: FND_MSG_PUB.Add;
1237: END IF;
1238: FND_MSG_PUB.Count_And_Get
1239: (p_count => x_msg_count,
1240: p_data => x_msg_data);
1241: EXCEPTION
1242: WHEN FND_API.G_EXC_ERROR THEN

Line 1250: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1246: FND_LOG.STRING(G_LEVEL_STATEMENT,
1247: G_MODULE_NAME || l_api_name, g_log_msg);
1248: END IF;
1249: x_return_status := FND_API.G_RET_STS_ERROR ;
1250: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1251: l_api_name);
1252: FND_MSG_PUB.Count_And_Get
1253: ( p_count => x_msg_count,
1254: p_data => x_msg_data

Line 1252: FND_MSG_PUB.Count_And_Get

1248: END IF;
1249: x_return_status := FND_API.G_RET_STS_ERROR ;
1250: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1251: l_api_name);
1252: FND_MSG_PUB.Count_And_Get
1253: ( p_count => x_msg_count,
1254: p_data => x_msg_data
1255: );
1256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1264: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1260: FND_LOG.STRING(G_LEVEL_STATEMENT,
1261: G_MODULE_NAME || l_api_name, g_log_msg);
1262: END IF;
1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1264: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1265: l_api_name);
1266: FND_MSG_PUB.Count_And_Get
1267: ( p_count => x_msg_count,
1268: p_data => x_msg_data

Line 1266: FND_MSG_PUB.Count_And_Get

1262: END IF;
1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1264: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1265: l_api_name);
1266: FND_MSG_PUB.Count_And_Get
1267: ( p_count => x_msg_count,
1268: p_data => x_msg_data
1269: );
1270: WHEN OTHERS THEN

Line 1278: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1274: FND_LOG.STRING(G_LEVEL_STATEMENT,
1275: G_MODULE_NAME || l_api_name, g_log_msg);
1276: END IF;
1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1278: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1279: l_api_name);
1280: FND_MSG_PUB.Count_And_Get
1281: ( p_count => x_msg_count,
1282: p_data => x_msg_data

Line 1280: FND_MSG_PUB.Count_And_Get

1276: END IF;
1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1278: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1279: l_api_name);
1280: FND_MSG_PUB.Count_And_Get
1281: ( p_count => x_msg_count,
1282: p_data => x_msg_data
1283: );
1284: END do_it_regnum_validations;

Line 1373: FND_MSG_PUB.Add;

1369: THEN
1370: FND_MESSAGE.SET_NAME('XLE', 'XLE_INVALID_REG_NUM_ERR');
1371: FND_MESSAGE.SET_TOKEN('REG_CODE', p_registration_code);
1372: FND_MESSAGE.SET_TOKEN('REG_NUM', p_registration_number);
1373: FND_MSG_PUB.Add;
1374: END IF;
1375: FND_MSG_PUB.Count_And_Get
1376: (p_count => x_msg_count,
1377: p_data => x_msg_data);

Line 1375: FND_MSG_PUB.Count_And_Get

1371: FND_MESSAGE.SET_TOKEN('REG_CODE', p_registration_code);
1372: FND_MESSAGE.SET_TOKEN('REG_NUM', p_registration_number);
1373: FND_MSG_PUB.Add;
1374: END IF;
1375: FND_MSG_PUB.Count_And_Get
1376: (p_count => x_msg_count,
1377: p_data => x_msg_data);
1378: EXCEPTION
1379: WHEN FND_API.G_EXC_ERROR THEN

Line 1387: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1383: FND_LOG.STRING(G_LEVEL_STATEMENT,
1384: G_MODULE_NAME || l_api_name, g_log_msg);
1385: END IF;
1386: x_return_status := FND_API.G_RET_STS_ERROR ;
1387: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1388: l_api_name);
1389: FND_MSG_PUB.Count_And_Get
1390: ( p_count => x_msg_count,
1391: p_data => x_msg_data

Line 1389: FND_MSG_PUB.Count_And_Get

1385: END IF;
1386: x_return_status := FND_API.G_RET_STS_ERROR ;
1387: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1388: l_api_name);
1389: FND_MSG_PUB.Count_And_Get
1390: ( p_count => x_msg_count,
1391: p_data => x_msg_data
1392: );
1393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1401: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1397: FND_LOG.STRING(G_LEVEL_STATEMENT,
1398: G_MODULE_NAME || l_api_name, g_log_msg);
1399: END IF;
1400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1401: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1402: l_api_name);
1403: FND_MSG_PUB.Count_And_Get
1404: ( p_count => x_msg_count,
1405: p_data => x_msg_data

Line 1403: FND_MSG_PUB.Count_And_Get

1399: END IF;
1400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1401: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1402: l_api_name);
1403: FND_MSG_PUB.Count_And_Get
1404: ( p_count => x_msg_count,
1405: p_data => x_msg_data
1406: );
1407: WHEN OTHERS THEN

Line 1415: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1411: FND_LOG.STRING(G_LEVEL_STATEMENT,
1412: G_MODULE_NAME || l_api_name, g_log_msg);
1413: END IF;
1414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1415: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1416: l_api_name);
1417: FND_MSG_PUB.Count_And_Get
1418: ( p_count => x_msg_count,
1419: p_data => x_msg_data

Line 1417: FND_MSG_PUB.Count_And_Get

1413: END IF;
1414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1415: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1416: l_api_name);
1417: FND_MSG_PUB.Count_And_Get
1418: ( p_count => x_msg_count,
1419: p_data => x_msg_data
1420: );
1421: END do_ar_regnum_validations;

Line 1516: FND_MSG_PUB.Add;

1512: THEN
1513: FND_MESSAGE.SET_NAME('XLE', 'XLE_INVALID_REG_NUM_ERR');
1514: FND_MESSAGE.SET_TOKEN('REG_CODE', p_registration_code);
1515: FND_MESSAGE.SET_TOKEN('REG_NUM', p_registration_number);
1516: FND_MSG_PUB.Add;
1517: END IF;
1518: FND_MSG_PUB.Count_And_Get
1519: (p_count => x_msg_count,
1520: p_data => x_msg_data);

Line 1518: FND_MSG_PUB.Count_And_Get

1514: FND_MESSAGE.SET_TOKEN('REG_CODE', p_registration_code);
1515: FND_MESSAGE.SET_TOKEN('REG_NUM', p_registration_number);
1516: FND_MSG_PUB.Add;
1517: END IF;
1518: FND_MSG_PUB.Count_And_Get
1519: (p_count => x_msg_count,
1520: p_data => x_msg_data);
1521: EXCEPTION
1522: WHEN FND_API.G_EXC_ERROR THEN

Line 1530: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1526: FND_LOG.STRING(G_LEVEL_STATEMENT,
1527: G_MODULE_NAME || l_api_name, g_log_msg);
1528: END IF;
1529: x_return_status := FND_API.G_RET_STS_ERROR ;
1530: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1531: l_api_name);
1532: FND_MSG_PUB.Count_And_Get
1533: ( p_count => x_msg_count,
1534: p_data => x_msg_data

Line 1532: FND_MSG_PUB.Count_And_Get

1528: END IF;
1529: x_return_status := FND_API.G_RET_STS_ERROR ;
1530: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1531: l_api_name);
1532: FND_MSG_PUB.Count_And_Get
1533: ( p_count => x_msg_count,
1534: p_data => x_msg_data
1535: );
1536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1544: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1540: FND_LOG.STRING(G_LEVEL_STATEMENT,
1541: G_MODULE_NAME || l_api_name, g_log_msg);
1542: END IF;
1543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1544: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1545: l_api_name);
1546: FND_MSG_PUB.Count_And_Get
1547: ( p_count => x_msg_count,
1548: p_data => x_msg_data

Line 1546: FND_MSG_PUB.Count_And_Get

1542: END IF;
1543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1544: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1545: l_api_name);
1546: FND_MSG_PUB.Count_And_Get
1547: ( p_count => x_msg_count,
1548: p_data => x_msg_data
1549: );
1550: WHEN OTHERS THEN

Line 1558: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1554: FND_LOG.STRING(G_LEVEL_STATEMENT,
1555: G_MODULE_NAME || l_api_name, g_log_msg);
1556: END IF;
1557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1558: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1559: l_api_name);
1560: FND_MSG_PUB.Count_And_Get
1561: ( p_count => x_msg_count,
1562: p_data => x_msg_data

Line 1560: FND_MSG_PUB.Count_And_Get

1556: END IF;
1557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1558: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1559: l_api_name);
1560: FND_MSG_PUB.Count_And_Get
1561: ( p_count => x_msg_count,
1562: p_data => x_msg_data
1563: );
1564: END do_cl_regnum_validations;

Line 1658: FND_MSG_PUB.Add;

1654: THEN
1655: FND_MESSAGE.SET_NAME('XLE', 'XLE_INVALID_REG_NUM_ERR');
1656: FND_MESSAGE.SET_TOKEN('REG_CODE', p_registration_code);
1657: FND_MESSAGE.SET_TOKEN('REG_NUM', p_registration_number);
1658: FND_MSG_PUB.Add;
1659: END IF;
1660: FND_MSG_PUB.Count_And_Get
1661: (p_count => x_msg_count,
1662: p_data => x_msg_data);

Line 1660: FND_MSG_PUB.Count_And_Get

1656: FND_MESSAGE.SET_TOKEN('REG_CODE', p_registration_code);
1657: FND_MESSAGE.SET_TOKEN('REG_NUM', p_registration_number);
1658: FND_MSG_PUB.Add;
1659: END IF;
1660: FND_MSG_PUB.Count_And_Get
1661: (p_count => x_msg_count,
1662: p_data => x_msg_data);
1663: EXCEPTION
1664: WHEN FND_API.G_EXC_ERROR THEN

Line 1672: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1668: FND_LOG.STRING(G_LEVEL_STATEMENT,
1669: G_MODULE_NAME || l_api_name, g_log_msg);
1670: END IF;
1671: x_return_status := FND_API.G_RET_STS_ERROR ;
1672: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1673: l_api_name);
1674: FND_MSG_PUB.Count_And_Get
1675: ( p_count => x_msg_count,
1676: p_data => x_msg_data

Line 1674: FND_MSG_PUB.Count_And_Get

1670: END IF;
1671: x_return_status := FND_API.G_RET_STS_ERROR ;
1672: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1673: l_api_name);
1674: FND_MSG_PUB.Count_And_Get
1675: ( p_count => x_msg_count,
1676: p_data => x_msg_data
1677: );
1678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1686: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1682: FND_LOG.STRING(G_LEVEL_STATEMENT,
1683: G_MODULE_NAME || l_api_name, g_log_msg);
1684: END IF;
1685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1686: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1687: l_api_name);
1688: FND_MSG_PUB.Count_And_Get
1689: ( p_count => x_msg_count,
1690: p_data => x_msg_data

Line 1688: FND_MSG_PUB.Count_And_Get

1684: END IF;
1685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1686: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1687: l_api_name);
1688: FND_MSG_PUB.Count_And_Get
1689: ( p_count => x_msg_count,
1690: p_data => x_msg_data
1691: );
1692: WHEN OTHERS THEN

Line 1700: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1696: FND_LOG.STRING(G_LEVEL_STATEMENT,
1697: G_MODULE_NAME || l_api_name, g_log_msg);
1698: END IF;
1699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1700: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1701: l_api_name);
1702: FND_MSG_PUB.Count_And_Get
1703: ( p_count => x_msg_count,
1704: p_data => x_msg_data

Line 1702: FND_MSG_PUB.Count_And_Get

1698: END IF;
1699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1700: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1701: l_api_name);
1702: FND_MSG_PUB.Count_And_Get
1703: ( p_count => x_msg_count,
1704: p_data => x_msg_data
1705: );
1706: END do_co_regnum_validations;

Line 1855: FND_MSG_PUB.Add;

1851: THEN
1852: FND_MESSAGE.SET_NAME('XLE', 'XLE_INVALID_REG_NUM_ERR');
1853: FND_MESSAGE.SET_TOKEN('REG_CODE', p_registration_code);
1854: FND_MESSAGE.SET_TOKEN('REG_NUM', p_registration_number);
1855: FND_MSG_PUB.Add;
1856: END IF;
1857: FND_MSG_PUB.Count_And_Get
1858: (p_count => x_msg_count,
1859: p_data => x_msg_data);

Line 1857: FND_MSG_PUB.Count_And_Get

1853: FND_MESSAGE.SET_TOKEN('REG_CODE', p_registration_code);
1854: FND_MESSAGE.SET_TOKEN('REG_NUM', p_registration_number);
1855: FND_MSG_PUB.Add;
1856: END IF;
1857: FND_MSG_PUB.Count_And_Get
1858: (p_count => x_msg_count,
1859: p_data => x_msg_data);
1860: END IF;
1861: EXCEPTION

Line 1870: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1866: FND_LOG.STRING(G_LEVEL_STATEMENT,
1867: G_MODULE_NAME || l_api_name, g_log_msg);
1868: END IF;
1869: x_return_status := FND_API.G_RET_STS_ERROR ;
1870: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1871: l_api_name);
1872: FND_MSG_PUB.Count_And_Get
1873: ( p_count => x_msg_count,
1874: p_data => x_msg_data

Line 1872: FND_MSG_PUB.Count_And_Get

1868: END IF;
1869: x_return_status := FND_API.G_RET_STS_ERROR ;
1870: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1871: l_api_name);
1872: FND_MSG_PUB.Count_And_Get
1873: ( p_count => x_msg_count,
1874: p_data => x_msg_data
1875: );
1876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1884: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1880: FND_LOG.STRING(G_LEVEL_STATEMENT,
1881: G_MODULE_NAME || l_api_name, g_log_msg);
1882: END IF;
1883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1884: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1885: l_api_name);
1886: FND_MSG_PUB.Count_And_Get
1887: ( p_count => x_msg_count,
1888: p_data => x_msg_data

Line 1886: FND_MSG_PUB.Count_And_Get

1882: END IF;
1883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1884: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1885: l_api_name);
1886: FND_MSG_PUB.Count_And_Get
1887: ( p_count => x_msg_count,
1888: p_data => x_msg_data
1889: );
1890: WHEN OTHERS THEN

Line 1898: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1894: FND_LOG.STRING(G_LEVEL_STATEMENT,
1895: G_MODULE_NAME || l_api_name, g_log_msg);
1896: END IF;
1897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1898: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1899: l_api_name);
1900: FND_MSG_PUB.Count_And_Get
1901: ( p_count => x_msg_count,
1902: p_data => x_msg_data

Line 1900: FND_MSG_PUB.Count_And_Get

1896: END IF;
1897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1898: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1899: l_api_name);
1900: FND_MSG_PUB.Count_And_Get
1901: ( p_count => x_msg_count,
1902: p_data => x_msg_data
1903: );
1904: END do_br_regnum_validations;