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_LOG

Line 6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

2: /* $Header: xleregvb.pls 120.8 2011/05/20 09:35:47 srsampat ship $ */
3: G_PKG_NAME VARCHAR2(30) := 'XLE_REGISTRATIONS_VAL_PVT';
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

3: G_PKG_NAME VARCHAR2(30) := 'XLE_REGISTRATIONS_VAL_PVT';
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'XLE.PLSQL.XLE_REGISTRATIONS_VAL_PVT';

Line 9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

5: G_CURRENT_RUNTIME_LEVEL NUMBER;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'XLE.PLSQL.XLE_REGISTRATIONS_VAL_PVT';
13: g_log_msg VARCHAR2(2000);

Line 10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'XLE.PLSQL.XLE_REGISTRATIONS_VAL_PVT';
13: g_log_msg VARCHAR2(2000);
14: -- Logging Infra

Line 11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'XLE.PLSQL.XLE_REGISTRATIONS_VAL_PVT';
13: g_log_msg VARCHAR2(2000);
14: -- Logging Infra
15: /*-----------------------------------------------------------

Line 70: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

66: l_source_table VARCHAR2(30);
67: l_registration_id NUMBER;
68: BEGIN
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;

Line 83: FND_LOG.STRING(G_LEVEL_STATEMENT,

79: x_msg_data := 'Mandatory parameter jurisdiction_id is not passed';
80: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
81: THEN
82: g_log_msg := 'Mandatory parameter jurisdiction_id is not passed';
83: FND_LOG.STRING(G_LEVEL_STATEMENT,
84: G_MODULE_NAME || l_api_name, g_log_msg);
85: END IF;
86: END IF;
87: IF x_return_status = FND_API.G_RET_STS_SUCCESS

Line 111: FND_LOG.STRING(G_LEVEL_STATEMENT,

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,
112: G_MODULE_NAME || l_api_name, g_log_msg);
113: END IF;
114: END IF;
115: END IF;

Line 134: FND_LOG.STRING(G_LEVEL_STATEMENT,

130: x_msg_data := 'Invalid jurisdiction_id passed';
131: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
132: THEN
133: g_log_msg := 'Invalid jurisdiction_id passed';
134: FND_LOG.STRING(G_LEVEL_STATEMENT,
135: G_MODULE_NAME || l_api_name, g_log_msg);
136: END IF;
137: END IF ;
138: END IF ;

Line 223: FND_LOG.STRING(G_LEVEL_STATEMENT,

219: WHEN FND_API.G_EXC_ERROR THEN
220: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
221: THEN
222: g_log_msg := SQLERRM;
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

Line 235: FND_LOG.STRING(G_LEVEL_STATEMENT,

231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
232: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
233: THEN
234: g_log_msg := SQLERRM;
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

Line 247: FND_LOG.STRING(G_LEVEL_STATEMENT,

243: WHEN OTHERS THEN
244: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
245: THEN
246: g_log_msg := SQLERRM;
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

Line 351: FND_LOG.STRING(G_LEVEL_STATEMENT,

347: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
348: THEN
349: g_log_msg := 'Check Algorithm failed for ' ||
350: p_registration_number;
351: FND_LOG.STRING(G_LEVEL_STATEMENT,
352: G_MODULE_NAME || l_api_name, g_log_msg);
353: END IF;
354: END IF;
355: ELSE

Line 361: FND_LOG.STRING(G_LEVEL_STATEMENT,

357: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
358: THEN
359: g_log_msg := 'Non numeric characters found in ' ||
360: p_registration_number;
361: FND_LOG.STRING(G_LEVEL_STATEMENT,
362: G_MODULE_NAME || l_api_name, g_log_msg);
363: END IF;
364: END IF;
365: /* Bug: 7609077 added the logic for taxpayer id starting with 'Y', 'Z' */

Line 398: FND_LOG.STRING(G_LEVEL_STATEMENT,

394: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
395: THEN
396: g_log_msg := 'Check Algorithm failed for ' ||
397: p_registration_number;
398: FND_LOG.STRING(G_LEVEL_STATEMENT,
399: G_MODULE_NAME || l_api_name, g_log_msg);
400: END IF;
401: END IF;
402: ELSE

Line 408: FND_LOG.STRING(G_LEVEL_STATEMENT,

404: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
405: THEN
406: g_log_msg := 'Non numeric characters found in ' ||
407: p_registration_number;
408: FND_LOG.STRING(G_LEVEL_STATEMENT,
409: G_MODULE_NAME || l_api_name, g_log_msg);
410: END IF;
411: END IF; /* end of numeric check */
412: ELSE

Line 428: FND_LOG.STRING(G_LEVEL_STATEMENT,

424: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
425: THEN
426: g_log_msg := 'Check Algorithm failed for ' ||
427: p_registration_number;
428: FND_LOG.STRING(G_LEVEL_STATEMENT,
429: G_MODULE_NAME || l_api_name, g_log_msg);
430: END IF;
431: END IF;
432: ELSE

Line 438: FND_LOG.STRING(G_LEVEL_STATEMENT,

434: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
435: THEN
436: g_log_msg := 'Non numeric characters found in ' ||
437: p_registration_number;
438: FND_LOG.STRING(G_LEVEL_STATEMENT,
439: G_MODULE_NAME || l_api_name, g_log_msg);
440: END IF;
441: END IF; /* end of numeric check */
442: END IF;

Line 485: FND_LOG.STRING(G_LEVEL_STATEMENT,

481: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
482: THEN
483: g_log_msg := 'Check Algorithm failed for ' ||
484: p_registration_number;
485: FND_LOG.STRING(G_LEVEL_STATEMENT,
486: G_MODULE_NAME || l_api_name, g_log_msg);
487: END IF;
488: END IF;
489: ELSIF l_check_digit = to_char((ceil(l_work_nif_d/10) *10) - l_work_nif_d)

Line 498: FND_LOG.STRING(G_LEVEL_STATEMENT,

494: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
495: THEN
496: g_log_msg := 'Check Algorithm failed for ' ||
497: p_registration_number;
498: FND_LOG.STRING(G_LEVEL_STATEMENT,
499: G_MODULE_NAME || l_api_name, g_log_msg);
500: END IF;
501: END IF;
502: ELSE

Line 508: FND_LOG.STRING(G_LEVEL_STATEMENT,

504: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
505: THEN
506: g_log_msg := 'Non numeric characters found in ' ||
507: p_registration_number;
508: FND_LOG.STRING(G_LEVEL_STATEMENT,
509: G_MODULE_NAME || l_api_name, g_log_msg);
510: END IF;
511: END IF; /* end of numeric check */
512: ELSE

Line 517: FND_LOG.STRING(G_LEVEL_STATEMENT,

513: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
514: THEN
515: g_log_msg := 'Reg number is not person and not a company '||
516: p_registration_number;
517: FND_LOG.STRING(G_LEVEL_STATEMENT,
518: G_MODULE_NAME || l_api_name, g_log_msg);
519: END IF;
520: x_return_status := FND_API.G_RET_STS_ERROR;
521: END IF; /* End of person or company check */

Line 527: FND_LOG.STRING(G_LEVEL_STATEMENT,

523: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
524: THEN
525: g_log_msg := 'Reg Num does not start with a valid character '||
526: p_registration_number;
527: FND_LOG.STRING(G_LEVEL_STATEMENT,
528: G_MODULE_NAME || l_api_name, g_log_msg);
529: END IF;
530: x_return_status := FND_API.G_RET_STS_ERROR;
531: END IF; /* does not start with a valid character */

Line 538: FND_LOG.STRING(G_LEVEL_STATEMENT,

534: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
535: THEN
536: g_log_msg := 'Reg Num failed length check '||
537: p_registration_number;
538: FND_LOG.STRING(G_LEVEL_STATEMENT,
539: G_MODULE_NAME || l_api_name, g_log_msg);
540: END IF;
541: END IF; /* end of length check */
542: IF x_return_status = FND_API.G_RET_STS_ERROR

Line 557: FND_LOG.STRING(G_LEVEL_STATEMENT,

553: WHEN FND_API.G_EXC_ERROR THEN
554: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
555: THEN
556: g_log_msg := SQLERRM;
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,

Line 571: FND_LOG.STRING(G_LEVEL_STATEMENT,

567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
568: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
569: THEN
570: g_log_msg := SQLERRM;
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,

Line 585: FND_LOG.STRING(G_LEVEL_STATEMENT,

581: WHEN OTHERS THEN
582: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
583: THEN
584: g_log_msg := SQLERRM;
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,

Line 789: FND_LOG.STRING(G_LEVEL_STATEMENT,

785: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
786: THEN
787: g_log_msg := ' Check algorithm not successfull for '||
788: p_registration_number;
789: FND_LOG.STRING(G_LEVEL_STATEMENT,
790: G_MODULE_NAME || l_api_name, g_log_msg);
791: END IF;
792: END IF;
793: ELSE

Line 799: FND_LOG.STRING(G_LEVEL_STATEMENT,

795: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
796: THEN
797: g_log_msg := 'Non numeric characters found ' ||
798: p_registration_number;
799: FND_LOG.STRING(G_LEVEL_STATEMENT,
800: G_MODULE_NAME || l_api_name, g_log_msg);
801: END IF;
802: END IF;
803: ELSE

Line 809: FND_LOG.STRING(G_LEVEL_STATEMENT,

805: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
806: THEN
807: g_log_msg := 'Reg Num failed length check '||
808: p_registration_number;
809: FND_LOG.STRING(G_LEVEL_STATEMENT,
810: G_MODULE_NAME || l_api_name, g_log_msg);
811: END IF;
812: END IF; /* of fail length check */
813: IF x_return_status = FND_API.G_RET_STS_ERROR

Line 828: FND_LOG.STRING(G_LEVEL_STATEMENT,

824: WHEN FND_API.G_EXC_ERROR THEN
825: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
826: THEN
827: g_log_msg := SQLERRM;
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,

Line 842: FND_LOG.STRING(G_LEVEL_STATEMENT,

838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
839: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
840: THEN
841: g_log_msg := SQLERRM;
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,

Line 856: FND_LOG.STRING(G_LEVEL_STATEMENT,

852: WHEN OTHERS THEN
853: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
854: THEN
855: g_log_msg := SQLERRM;
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,

Line 1194: FND_LOG.STRING(G_LEVEL_STATEMENT,

1190: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1191: THEN
1192: g_log_msg := 'Check Algorithm failed for '||
1193: p_registration_number;
1194: FND_LOG.STRING(G_LEVEL_STATEMENT,
1195: G_MODULE_NAME || l_api_name, g_log_msg);
1196: END IF;
1197: ELSE
1198: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1226: FND_LOG.STRING(G_LEVEL_STATEMENT,

1222: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1223: THEN
1224: g_log_msg := 'Registration number is of incorrect length '||
1225: p_registration_number;
1226: FND_LOG.STRING(G_LEVEL_STATEMENT,
1227: G_MODULE_NAME || l_api_name, g_log_msg);
1228: END IF;
1229: END IF;
1230:

Line 1246: FND_LOG.STRING(G_LEVEL_STATEMENT,

1242: WHEN FND_API.G_EXC_ERROR THEN
1243: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1244: THEN
1245: g_log_msg := SQLERRM;
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,

Line 1260: FND_LOG.STRING(G_LEVEL_STATEMENT,

1256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1257: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1258: THEN
1259: g_log_msg := SQLERRM;
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,

Line 1274: FND_LOG.STRING(G_LEVEL_STATEMENT,

1270: WHEN OTHERS THEN
1271: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1272: THEN
1273: g_log_msg := SQLERRM;
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,

Line 1342: FND_LOG.STRING(G_LEVEL_STATEMENT,

1338: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1339: THEN
1340: g_log_msg := 'Check Algorithm failed for '||
1341: p_registration_number;
1342: FND_LOG.STRING(G_LEVEL_STATEMENT,
1343: G_MODULE_NAME || l_api_name, g_log_msg);
1344: END IF;
1345: ELSE
1346: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1354: FND_LOG.STRING(G_LEVEL_STATEMENT,

1350: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1351: THEN
1352: g_log_msg := 'Incorrect length for reg number ' ||
1353: p_registration_number;
1354: FND_LOG.STRING(G_LEVEL_STATEMENT,
1355: G_MODULE_NAME || l_api_name, g_log_msg);
1356: END IF;
1357: END IF; -- Check length
1358: ELSE

Line 1364: FND_LOG.STRING(G_LEVEL_STATEMENT,

1360: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1361: THEN
1362: g_log_msg := 'Non numeric characters found in reg num '||
1363: p_registration_number;
1364: FND_LOG.STRING(G_LEVEL_STATEMENT,
1365: G_MODULE_NAME || l_api_name, g_log_msg);
1366: END IF;
1367: END IF ; -- Numeric Value check
1368: IF x_return_status = FND_API.G_RET_STS_ERROR

Line 1383: FND_LOG.STRING(G_LEVEL_STATEMENT,

1379: WHEN FND_API.G_EXC_ERROR THEN
1380: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1381: THEN
1382: g_log_msg := SQLERRM;
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,

Line 1397: FND_LOG.STRING(G_LEVEL_STATEMENT,

1393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1394: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1395: THEN
1396: g_log_msg := SQLERRM;
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,

Line 1411: FND_LOG.STRING(G_LEVEL_STATEMENT,

1407: WHEN OTHERS THEN
1408: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1409: THEN
1410: g_log_msg := SQLERRM;
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,

Line 1485: FND_LOG.STRING(G_LEVEL_STATEMENT,

1481: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1482: THEN
1483: g_log_msg := 'Check Algorithm failed for '||
1484: p_registration_number;
1485: FND_LOG.STRING(G_LEVEL_STATEMENT,
1486: G_MODULE_NAME || l_api_name, g_log_msg);
1487: END IF;
1488: ELSE
1489: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1497: FND_LOG.STRING(G_LEVEL_STATEMENT,

1493: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1494: THEN
1495: g_log_msg := 'Check length failed for '||
1496: p_registration_number;
1497: FND_LOG.STRING(G_LEVEL_STATEMENT,
1498: G_MODULE_NAME || l_api_name, g_log_msg);
1499: END IF;
1500: END IF; -- Check length
1501: ELSE

Line 1507: FND_LOG.STRING(G_LEVEL_STATEMENT,

1503: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1504: THEN
1505: g_log_msg := 'Non numeric characters found in '||
1506: p_registration_number;
1507: FND_LOG.STRING(G_LEVEL_STATEMENT,
1508: G_MODULE_NAME || l_api_name, g_log_msg);
1509: END IF;
1510: END IF ; -- Numeric Value check
1511: IF x_return_status = FND_API.G_RET_STS_ERROR

Line 1526: FND_LOG.STRING(G_LEVEL_STATEMENT,

1522: WHEN FND_API.G_EXC_ERROR THEN
1523: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1524: THEN
1525: g_log_msg := SQLERRM;
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,

Line 1540: FND_LOG.STRING(G_LEVEL_STATEMENT,

1536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1537: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1538: THEN
1539: g_log_msg := SQLERRM;
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,

Line 1554: FND_LOG.STRING(G_LEVEL_STATEMENT,

1550: WHEN OTHERS THEN
1551: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1552: THEN
1553: g_log_msg := SQLERRM;
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,

Line 1627: FND_LOG.STRING(G_LEVEL_STATEMENT,

1623: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1624: THEN
1625: g_log_msg := 'Check Algorithm failed for '||
1626: p_registration_number;
1627: FND_LOG.STRING(G_LEVEL_STATEMENT,
1628: G_MODULE_NAME || l_api_name, g_log_msg);
1629: END IF;
1630: ELSE
1631: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1639: FND_LOG.STRING(G_LEVEL_STATEMENT,

1635: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1636: THEN
1637: g_log_msg := 'Check length failed for '||
1638: p_registration_number;
1639: FND_LOG.STRING(G_LEVEL_STATEMENT,
1640: G_MODULE_NAME || l_api_name, g_log_msg);
1641: END IF;
1642: END IF; -- Check length
1643: ELSE

Line 1649: FND_LOG.STRING(G_LEVEL_STATEMENT,

1645: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1646: THEN
1647: g_log_msg := 'Non numeric characters found in ' ||
1648: p_registration_number;
1649: FND_LOG.STRING(G_LEVEL_STATEMENT,
1650: G_MODULE_NAME || l_api_name, g_log_msg);
1651: END IF;
1652: END IF;
1653: IF x_return_status = FND_API.G_RET_STS_ERROR

Line 1668: FND_LOG.STRING(G_LEVEL_STATEMENT,

1664: WHEN FND_API.G_EXC_ERROR THEN
1665: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1666: THEN
1667: g_log_msg := SQLERRM;
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,

Line 1682: FND_LOG.STRING(G_LEVEL_STATEMENT,

1678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1679: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1680: THEN
1681: g_log_msg := SQLERRM;
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,

Line 1696: FND_LOG.STRING(G_LEVEL_STATEMENT,

1692: WHEN OTHERS THEN
1693: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1694: THEN
1695: g_log_msg := SQLERRM;
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,

Line 1746: FND_LOG.STRING(G_LEVEL_STATEMENT,

1742: THEN
1743: g_log_msg := 'Failed length check or non numeric ' ||
1744: ' characters found ' ||
1745: p_registration_number;
1746: FND_LOG.STRING(G_LEVEL_STATEMENT,
1747: G_MODULE_NAME || l_api_name, g_log_msg);
1748: END IF;
1749: ELSIF p_registration_code = 'CPF'
1750: THEN

Line 1791: FND_LOG.STRING(G_LEVEL_STATEMENT,

1787: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1788: THEN
1789: g_log_msg := 'Check Algorithm failed for '||
1790: p_registration_number;
1791: FND_LOG.STRING(G_LEVEL_STATEMENT,
1792: G_MODULE_NAME || l_api_name, g_log_msg);
1793: END IF;
1794: ELSE
1795: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 1843: FND_LOG.STRING(G_LEVEL_STATEMENT,

1839: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1840: THEN
1841: g_log_msg := 'Check Algorithm failed for '||
1842: p_registration_number;
1843: FND_LOG.STRING(G_LEVEL_STATEMENT,
1844: G_MODULE_NAME || l_api_name, g_log_msg);
1845: END IF;
1846: ELSE
1847: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 1866: FND_LOG.STRING(G_LEVEL_STATEMENT,

1862: WHEN FND_API.G_EXC_ERROR THEN
1863: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1864: THEN
1865: g_log_msg := SQLERRM;
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,

Line 1880: FND_LOG.STRING(G_LEVEL_STATEMENT,

1876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1877: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1878: THEN
1879: g_log_msg := SQLERRM;
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,

Line 1894: FND_LOG.STRING(G_LEVEL_STATEMENT,

1890: WHEN OTHERS THEN
1891: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL)
1892: THEN
1893: g_log_msg := SQLERRM;
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,