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.INL_RULE_PVT dependencies on STANDARD

Line 141: -- Standard Beginning of Procedure/Function Logging

137:
138: -- Initialize return status to success
139: x_return_status := FND_API.G_RET_STS_SUCCESS;
140:
141: -- Standard Beginning of Procedure/Function Logging
142: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
143: p_procedure_name => l_func_name) ;
144: -- Logging variables
145: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

Line 258: -- Standard call to get message count and if count is 1, get message info.

254: END IF;
255:
256: l_condition_dsp := l_condition_dsp || ' AND ' || l_concat_id;
257:
258: -- Standard call to get message count and if count is 1, get message info.
259: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
260: p_count => x_msg_count,
261: p_data => x_msg_data);
262:

Line 270: -- Standard Expected Error Logging

266: RETURN l_condition_dsp;
267:
268: EXCEPTION
269: WHEN VALUE_ERROR THEN
270: -- Standard Expected Error Logging
271: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,
272: p_procedure_name => l_func_name);
273: x_return_status := FND_API.G_RET_STS_ERROR;
274: FND_MESSAGE.SET_NAME('INL', 'INL_ERR_COND_TOO_LONG');

Line 281: -- Standard Expected Error Logging

277: p_count => x_msg_count,
278: p_data => x_msg_data);
279: RETURN NULL;
280: WHEN L_FND_EXC_ERROR THEN
281: -- Standard Expected Error Logging
282: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,
283: p_procedure_name => l_func_name);
284: x_return_status := L_FND_RET_STS_ERROR;
285: RETURN NULL;

Line 287: -- Standard Unexpected Error Logging

283: p_procedure_name => l_func_name);
284: x_return_status := L_FND_RET_STS_ERROR;
285: RETURN NULL;
286: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
287: -- Standard Unexpected Error Logging
288: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
289: p_procedure_name => l_func_name) ;
290: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
291: RETURN NULL;

Line 293: -- Standard Unexpected Error Logging

289: p_procedure_name => l_func_name) ;
290: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
291: RETURN NULL;
292: WHEN OTHERS THEN
293: -- Standard Unexpected Error Logging
294: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
295: p_procedure_name => l_func_name) ;
296: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
297: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 359: -- Standard Beginning of Procedure/Function Logging

355:
356: -- Initialize return status to success
357: x_return_status := FND_API.G_RET_STS_SUCCESS;
358:
359: -- Standard Beginning of Procedure/Function Logging
360: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
361: p_procedure_name => l_func_name) ;
362: -- Logging variables
363: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

Line 433: -- Standard call to get message count and if count is 1, get message info.

429: END IF;
430:
431: l_from_clause := l_from_clause || l_where_clause;
432:
433: -- Standard call to get message count and if count is 1, get message info.
434: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
435: p_count => x_msg_count,
436: p_data => x_msg_data);
437:

Line 445: -- Standard Expected Error Logging

441: RETURN l_from_clause;
442:
443: EXCEPTION
444: WHEN VALUE_ERROR THEN
445: -- Standard Expected Error Logging
446: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,
447: p_procedure_name => l_func_name);
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: FND_MESSAGE.SET_NAME('INL', 'INL_ERR_COND_TOO_LONG');

Line 456: -- Standard Expected Error Logging

452: p_count => x_msg_count,
453: p_data => x_msg_data);
454: RETURN NULL;
455: WHEN L_FND_EXC_ERROR THEN
456: -- Standard Expected Error Logging
457: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,
458: p_procedure_name => l_func_name);
459: x_return_status := L_FND_RET_STS_ERROR;
460: RETURN NULL;

Line 462: -- Standard Unexpected Error Logging

458: p_procedure_name => l_func_name);
459: x_return_status := L_FND_RET_STS_ERROR;
460: RETURN NULL;
461: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
462: -- Standard Unexpected Error Logging
463: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
464: p_procedure_name => l_func_name) ;
465: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
466: RETURN NULL;

Line 468: -- Standard Unexpected Error Logging

464: p_procedure_name => l_func_name) ;
465: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
466: RETURN NULL;
467: WHEN OTHERS THEN
468: -- Standard Unexpected Error Logging
469: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
470: p_procedure_name => l_func_name) ;
471: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
472: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 518: -- Standard Beginning of Procedure/Function Logging

514: l_condition_count NUMBER;
515:
516: BEGIN
517:
518: -- Standard Beginning of Procedure/Function Logging
519: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
520: p_procedure_name => l_api_name) ;
521:
522: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 527: -- Standard call to check for call compatibility

523: IF FND_API.to_Boolean(p_init_msg_list) THEN
524: FND_MSG_PUB.initialize;
525: END IF;
526:
527: -- Standard call to check for call compatibility
528: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
529: p_caller_version_number => p_api_version,
530: p_api_name => l_api_name,
531: p_pkg_name => g_pkg_name ) THEN

Line 598: -- Standard call to get message count and if count is 1, get message info.

594: END IF;
595:
596: l_query := 'SELECT COUNT(1) ' || l_from_clause || l_where_clause_cond;
597:
598: -- Standard call to get message count and if count is 1, get message info.
599: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
600: p_count => x_msg_count,
601: p_data => x_msg_data);
602:

Line 603: -- Standard End of Procedure/Function Logging

599: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
600: p_count => x_msg_count,
601: p_data => x_msg_data);
602:
603: -- Standard End of Procedure/Function Logging
604: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
605: p_procedure_name => l_api_name);
606:
607: RETURN l_query;

Line 611: -- Standard Expected Error Logging

607: RETURN l_query;
608:
609: EXCEPTION
610: WHEN VALUE_ERROR THEN
611: -- Standard Expected Error Logging
612: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,
613: p_procedure_name => l_api_name);
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: FND_MESSAGE.SET_NAME('INL', 'INL_ERR_COND_TOO_LONG');

Line 622: -- Standard Expected Error Logging

618: p_count => x_msg_count,
619: p_data => x_msg_data);
620: RETURN NULL;
621: WHEN FND_API.G_EXC_ERROR THEN
622: -- Standard Expected Error Logging
623: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,
624: p_procedure_name => l_api_name);
625: x_return_status := FND_API.G_RET_STS_ERROR;
626: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 631: -- Standard Unexpected Error Logging

627: p_count => x_msg_count,
628: p_data => x_msg_data);
629: RETURN NULL;
630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
631: -- Standard Unexpected Error Logging
632: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
633: p_procedure_name => l_api_name);
634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
635: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 640: -- Standard Unexpected Error Logging

636: p_count => x_msg_count,
637: p_data => x_msg_data);
638: RETURN NULL;
639: WHEN OTHERS THEN
640: -- Standard Unexpected Error Logging
641: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
642: p_procedure_name => l_api_name);
643:
644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 697: -- Standard Beginning of Procedure/Function Logging

693:
694: -- Initialize return status to success
695: x_return_status := FND_API.G_RET_STS_SUCCESS;
696:
697: -- Standard Beginning of Procedure/Function Logging
698: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
699: p_procedure_name => l_func_name) ;
700: -- Logging variables
701: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

Line 740: -- Standard call to get message count and if count is 1, get message info.

736: IF c_package_status%FOUND THEN
737: x_message_name := 'INL_ERR_RULE_PACKAGE_FAILED' ;
738: END IF;
739:
740: -- Standard call to get message count and if count is 1, get message info.
741: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
742: p_count => x_msg_count,
743: p_data => x_msg_data);
744:

Line 745: -- Standard End of Procedure/Function Logging

741: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
742: p_count => x_msg_count,
743: p_data => x_msg_data);
744:
745: -- Standard End of Procedure/Function Logging
746: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
747: p_procedure_name => l_func_name);
748:
749: EXCEPTION

Line 825: -- Standard Beginning of Procedure/Function Logging

821:
822: -- Initialize return status to success
823: x_return_status := FND_API.G_RET_STS_SUCCESS;
824:
825: -- Standard Beginning of Procedure/Function Logging
826: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
827: p_procedure_name => l_func_name) ;
828: -- Logging variables
829: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

Line 989: -- Standard call to get message count and if count is 1, get message info.

985: END;
986: END IF;
987: -- End Bug 16758966
988:
989: -- Standard call to get message count and if count is 1, get message info.
990: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
991: p_count => x_msg_count,
992: p_data => x_msg_data);
993:

Line 994: -- Standard End of Procedure/Function Logging

990: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
991: p_count => x_msg_count,
992: p_data => x_msg_data);
993:
994: -- Standard End of Procedure/Function Logging
995: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
996: p_procedure_name => l_func_name);
997:
998: EXCEPTION

Line 1043: -- Standard Beginning of Procedure/Function Logging

1039: l_usage_code VARCHAR2(30);
1040:
1041: BEGIN
1042:
1043: -- Standard Beginning of Procedure/Function Logging
1044: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
1045: p_procedure_name => l_api_name) ;
1046:
1047: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1052: -- Standard call to check for call compatibility

1048: IF FND_API.to_Boolean(p_init_msg_list) THEN
1049: FND_MSG_PUB.initialize;
1050: END IF;
1051:
1052: -- Standard call to check for call compatibility
1053: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
1054: p_caller_version_number => p_api_version,
1055: p_api_name => l_api_name,
1056: p_pkg_name => g_pkg_name ) THEN

Line 1121: -- Standard call to get message count and if count is 1, get message info.

1117: RAISE L_FND_EXC_UNEXPECTED_ERROR;
1118: END IF;
1119: END IF;
1120:
1121: -- Standard call to get message count and if count is 1, get message info.
1122: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1123: p_count => x_msg_count,
1124: p_data => x_msg_data);
1125:

Line 1126: -- Standard End of Procedure/Function Logging

1122: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1123: p_count => x_msg_count,
1124: p_data => x_msg_data);
1125:
1126: -- Standard End of Procedure/Function Logging
1127: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
1128: p_procedure_name => l_api_name);
1129:
1130: EXCEPTION

Line 1132: -- Standard Expected Error Logging

1128: p_procedure_name => l_api_name);
1129:
1130: EXCEPTION
1131: WHEN L_FND_EXC_ERROR THEN
1132: -- Standard Expected Error Logging
1133: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,
1134: p_procedure_name => l_api_name);
1135: x_return_status := L_FND_RET_STS_ERROR;
1136: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 1140: -- Standard Unexpected Error Logging

1136: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1137: p_count => x_msg_count,
1138: p_data => x_msg_data);
1139: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
1140: -- Standard Unexpected Error Logging
1141: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
1142: p_procedure_name => l_api_name) ;
1143: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
1144: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 1148: -- Standard Unexpected Error Logging

1144: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1145: p_count => x_msg_count,
1146: p_data => x_msg_data);
1147: WHEN OTHERS THEN
1148: -- Standard Unexpected Error Logging
1149: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
1150: p_procedure_name => l_api_name) ;
1151: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
1152: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1289: -- Standard Beginning of Procedure/Function Logging

1285: l_right_attrs right_attrs;
1286:
1287: BEGIN
1288:
1289: -- Standard Beginning of Procedure/Function Logging
1290: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
1291: p_procedure_name => l_api_name) ;
1292:
1293: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1298: -- Standard call to check for call compatibility

1294: IF FND_API.to_Boolean(p_init_msg_list) THEN
1295: FND_MSG_PUB.initialize;
1296: END IF;
1297:
1298: -- Standard call to check for call compatibility
1299: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
1300: p_caller_version_number => p_api_version,
1301: p_api_name => l_api_name,
1302: p_pkg_name => g_pkg_name ) THEN

Line 1555: -- Standard call to get message count and if count is 1, get message info.

1551: p_procedure_name => l_api_name,
1552: p_var_name => 'l_return',
1553: p_var_value => l_return);
1554:
1555: -- Standard call to get message count and if count is 1, get message info.
1556: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1557: p_count => x_msg_count,
1558: p_data => x_msg_data);
1559:

Line 1560: -- Standard End of Procedure/Function Logging

1556: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1557: p_count => x_msg_count,
1558: p_data => x_msg_data);
1559:
1560: -- Standard End of Procedure/Function Logging
1561: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
1562: p_procedure_name => l_api_name);
1563:
1564: RETURN l_return;

Line 1568: -- Standard Expected Error Logging

1564: RETURN l_return;
1565:
1566: EXCEPTION
1567: WHEN L_FND_EXC_ERROR THEN
1568: -- Standard Expected Error Logging
1569: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,
1570: p_procedure_name => l_api_name);
1571: x_return_status := L_FND_RET_STS_ERROR;
1572: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 1577: -- Standard Unexpected Error Logging

1573: p_count => x_msg_count,
1574: p_data => x_msg_data);
1575: RETURN 'FALSE';
1576: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
1577: -- Standard Unexpected Error Logging
1578: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
1579: p_procedure_name => l_api_name) ;
1580: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
1581: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 1586: -- Standard Unexpected Error Logging

1582: p_count => x_msg_count,
1583: p_data => x_msg_data);
1584: RETURN 'FALSE';
1585: WHEN OTHERS THEN
1586: -- Standard Unexpected Error Logging
1587: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
1588: p_procedure_name => l_api_name) ;
1589: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
1590: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1636: -- Standard Beginning of Procedure/Function Logging

1632: l_statement VARCHAR2(200);
1633: l_package_name VARCHAR2(100);
1634:
1635: BEGIN
1636: -- Standard Beginning of Procedure/Function Logging
1637: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
1638: p_procedure_name => l_api_name) ;
1639:
1640: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1645: -- Standard call to check for call compatibility

1641: IF FND_API.to_Boolean(p_init_msg_list) THEN
1642: FND_MSG_PUB.initialize;
1643: END IF;
1644:
1645: -- Standard call to check for call compatibility
1646: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
1647: p_caller_version_number => p_api_version,
1648: p_api_name => l_api_name,
1649: p_pkg_name => g_pkg_name ) THEN

Line 1699: -- Standard call to get message count and if count is 1, get message info.

1695: EXECUTE IMMEDIATE l_statement;
1696: END IF;
1697: END IF;
1698:
1699: -- Standard call to get message count and if count is 1, get message info.
1700: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1701: p_count => x_msg_count,
1702: p_data => x_msg_data);
1703:

Line 1704: -- Standard End of Procedure/Function Logging

1700: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1701: p_count => x_msg_count,
1702: p_data => x_msg_data);
1703:
1704: -- Standard End of Procedure/Function Logging
1705: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
1706: p_procedure_name => l_api_name);
1707:
1708: EXCEPTION

Line 1710: -- Standard Expected Error Logging

1706: p_procedure_name => l_api_name);
1707:
1708: EXCEPTION
1709: WHEN L_FND_EXC_ERROR THEN
1710: -- Standard Expected Error Logging
1711: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,
1712: p_procedure_name => l_api_name);
1713: x_return_status := L_FND_RET_STS_ERROR;
1714: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 1718: -- Standard Unexpected Error Logging

1714: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1715: p_count => x_msg_count,
1716: p_data => x_msg_data);
1717: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
1718: -- Standard Unexpected Error Logging
1719: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
1720: p_procedure_name => l_api_name) ;
1721: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
1722: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 1726: -- Standard Unexpected Error Logging

1722: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1723: p_count => x_msg_count,
1724: p_data => x_msg_data);
1725: WHEN OTHERS THEN
1726: -- Standard Unexpected Error Logging
1727: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
1728: p_procedure_name => l_api_name) ;
1729: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
1730: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN