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 INL_LOGGING_PVT

Line 142: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,

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,
146: p_procedure_name => l_func_name,

Line 145: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

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,
146: p_procedure_name => l_func_name,
147: p_var_name => 'p_rule_id',
148: p_var_value => p_rule_id);
149:

Line 158: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

154: IF NVL(l_conditions.LAST, 0) > 0 THEN
155:
156: FOR i IN NVL(l_conditions.FIRST, 0)..NVL(l_conditions.LAST, 0)
157: LOOP
158: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
159: p_procedure_name => l_func_name,
160: p_var_name => 'c_conditions(' || i ||').condition_id',
161: p_var_value => l_conditions(i).condition_id);
162:

Line 263: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,

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:
263: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
264: p_procedure_name => l_func_name);
265:
266: RETURN l_condition_dsp;
267:

Line 271: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,

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');
275: FND_MSG_PUB.ADD;

Line 282: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,

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;
286: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN

Line 288: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_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;
292: WHEN OTHERS THEN

Line 294: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_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
298: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

Line 360: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,

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,
364: p_procedure_name => l_func_name,

Line 363: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

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,
364: p_procedure_name => l_func_name,
365: p_var_name => 'p_rule_id',
366: p_var_value => p_rule_id);
367:

Line 377: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

373: INTO l_usage_code
374: FROM inl_rules_vl
375: WHERE rule_id = p_rule_id;
376:
377: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
378: p_procedure_name => l_func_name,
379: p_var_name => 'l_usage_code',
380: p_var_value => l_usage_code);
381:

Line 387: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

383: l_from_clause := ' FROM ';
384: FOR i IN NVL(l_cond_tables.FIRST, 0)..NVL(l_cond_tables.LAST, 0)
385: LOOP
386:
387: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
388: p_procedure_name => l_func_name,
389: p_var_name => 'l_cond_tables(' || i ||').source_table_name',
390: p_var_value => l_cond_tables(i).from_table_name);
391:

Line 438: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,

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:
438: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
439: p_procedure_name => l_func_name);
440:
441: RETURN l_from_clause;
442:

Line 446: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,

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');
450: FND_MSG_PUB.ADD;

Line 457: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,

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;
461: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN

Line 463: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_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;
467: WHEN OTHERS THEN

Line 469: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_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
473: FND_MSG_PUB.Add_Exc_Msg (p_pkg_name => g_pkg_name,

Line 519: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,

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.
523: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 551: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

547: RETURN NULL;
548: END IF;
549:
550: -- Logging variables
551: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
552: p_procedure_name => l_api_name,
553: p_var_name => 'p_rule_id',
554: p_var_value => p_rule_id);
555:

Line 570: INL_LOGGING_PVT.Log_Statement (

566: RAISE L_FND_EXC_UNEXPECTED_ERROR;
567: END IF;
568:
569: l_debug_info := 'Call Build_Condition)';
570: INL_LOGGING_PVT.Log_Statement (
571: p_module_name => g_module_name,
572: p_procedure_name => l_api_name,
573: p_debug_info => l_debug_info);
574:

Line 604: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,

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;
608:

Line 612: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,

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');
616: FND_MSG_PUB.ADD;

Line 623: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,

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,
627: p_count => x_msg_count,

Line 632: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,

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,
636: p_count => x_msg_count,

Line 641: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,

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 ;
645: IF FND_MSG_PUB.Check_Msg_Level(

Line 698: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,

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,
702: p_procedure_name => l_func_name,

Line 701: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

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,
702: p_procedure_name => l_func_name,
703: p_var_name => 'p_rule_id',
704: p_var_value => p_rule_id);
705:

Line 746: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,

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
750: WHEN OTHERS THEN

Line 826: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,

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,
830: p_procedure_name => l_func_name,

Line 829: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

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,
830: p_procedure_name => l_func_name,
831: p_var_name => 'p_rule_id',
832: p_var_value => p_rule_id);
833:

Line 962: INL_LOGGING_PVT.Log_Statement (

958: END IF;
959:
960: -- Bug 16758966
961: l_debug_info := 'Package is compiled successfully, it will validate in runtime';
962: INL_LOGGING_PVT.Log_Statement (
963: p_module_name => g_module_name,
964: p_procedure_name => l_func_name,
965: p_debug_info => l_debug_info);
966:

Line 969: INL_LOGGING_PVT.Log_Statement(p_module_name => g_module_name,

965: p_debug_info => l_debug_info);
966:
967: IF x_message_name IS NULL THEN
968: l_debug_info := 'Validate Condition. Call INL_RULE_GRP.Check_Condition.';
969: INL_LOGGING_PVT.Log_Statement(p_module_name => g_module_name,
970: p_procedure_name => l_func_name,
971: p_debug_info => l_debug_info);
972:
973: BEGIN

Line 995: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,

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
999: WHEN OTHERS THEN

Line 1044: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,

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.
1048: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1060: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

1056: p_pkg_name => g_pkg_name ) THEN
1057: RAISE L_FND_EXC_UNEXPECTED_ERROR;
1058: END IF;
1059:
1060: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1061: p_procedure_name => l_api_name,
1062: p_var_name => 'p_rule_id: ',
1063: p_var_value => p_rule_id);
1064:

Line 1073: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

1069: INTO l_rule_name, l_usage_code
1070: FROM inl_rules_vl r
1071: WHERE r.rule_id = p_rule_id;
1072:
1073: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1074: p_procedure_name => l_api_name,
1075: p_var_name => 'l_usage_code: ',
1076: p_var_value => l_usage_code);
1077:

Line 1086: INL_LOGGING_PVT.Log_Statement(p_module_name => g_module_name,

1082: WHERE package_name IS NULL
1083: AND rule_id = p_rule_id;
1084: END IF;
1085:
1086: INL_LOGGING_PVT.Log_Statement(p_module_name => g_module_name,
1087: p_procedure_name => l_api_name,
1088: p_debug_info => 'Building INL_RULE_' || p_rule_id ||'_PVT - Package Specification');
1089:
1090: Build_SpecPackage(p_rule_id,

Line 1103: INL_LOGGING_PVT.Log_Statement(p_module_name => g_module_name,

1099: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1100: RAISE L_FND_EXC_UNEXPECTED_ERROR;
1101: END IF;
1102:
1103: INL_LOGGING_PVT.Log_Statement(p_module_name => g_module_name,
1104: p_procedure_name => l_api_name,
1105: p_debug_info => 'Building INL_RULE_' || p_rule_id ||'_PVT - Package Body');
1106:
1107: Build_BodyPackage(p_rule_id => p_rule_id,

Line 1127: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,

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
1131: WHEN L_FND_EXC_ERROR THEN

Line 1133: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_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,
1137: p_count => x_msg_count,

Line 1141: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,

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,
1145: p_count => x_msg_count,

Line 1149: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,

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
1153: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

Line 1290: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,

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.
1294: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1309: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

1305:
1306: -- Initialize API return status to success
1307: x_return_status := FND_API.G_RET_STS_SUCCESS;
1308:
1309: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1310: p_procedure_name => l_api_name,
1311: p_var_name => 'p_rule_id: ',
1312: p_var_value => p_rule_id);
1313:

Line 1329: INL_LOGGING_PVT.Log_Statement(p_module_name => g_module_name,

1325: END IF;
1326:
1327: IF l_return = 'TRUE' THEN
1328: l_debug_info := 'Validate parentheses.';
1329: INL_LOGGING_PVT.Log_Statement(p_module_name => g_module_name,
1330: p_procedure_name => l_api_name,
1331: p_debug_info => l_debug_info);
1332:
1333: -- Validate parentheses

Line 1389: INL_LOGGING_PVT.Log_Statement(p_module_name => g_module_name,

1385: END IF;
1386: END IF;
1387:
1388: l_debug_info := 'Validate incorrect positioning of left and right parentheses.';
1389: INL_LOGGING_PVT.Log_Statement(p_module_name => g_module_name,
1390: p_procedure_name => l_api_name,
1391: p_debug_info => l_debug_info);
1392:
1393: IF l_return = 'TRUE' THEN

Line 1425: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1421: END IF;
1422: END IF;
1423:
1424: l_debug_info := 'Validate logical operators.';
1425: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1426: p_procedure_name => l_api_name,
1427: p_debug_info => l_debug_info);
1428:
1429: -- Check if condition has wrong number of logical operators

Line 1504: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

1500: IF l_return = 'TRUE' AND l_right_attrs(i).right_entity_code = 'EXPR' THEN -- Validate db function
1501: -- Validate if the function is valid
1502: l_db_function := NVL(SUBSTR(l_right_attr_exp,1,INSTR(l_right_attr_exp, '(')-1),l_right_attr_exp);
1503:
1504: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1505: p_procedure_name => l_api_name,
1506: p_var_name => 'l_db_function: ',
1507: p_var_value => l_db_function);
1508:

Line 1515: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

1511: FROM user_objects
1512: WHERE object_name = l_db_function
1513: AND object_type = 'FUNCTION';
1514:
1515: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1516: p_procedure_name => l_api_name,
1517: p_var_name => 'l_valid_function: ',
1518: p_var_value => l_valid_function);
1519:

Line 1550: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

1546: END IF;
1547: END LOOP;
1548: END IF;
1549:
1550: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1551: p_procedure_name => l_api_name,
1552: p_var_name => 'l_return',
1553: p_var_value => l_return);
1554:

Line 1561: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,

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;
1565:

Line 1569: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,

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,
1573: p_count => x_msg_count,

Line 1578: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,

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,
1582: p_count => x_msg_count,

Line 1587: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,

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
1591: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

Line 1637: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,

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.
1641: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1653: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

1649: p_pkg_name => g_pkg_name ) THEN
1650: RAISE L_FND_EXC_UNEXPECTED_ERROR;
1651: END IF;
1652:
1653: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1654: p_procedure_name => l_api_name,
1655: p_var_name => 'p_rule_id: ',
1656: p_var_value => p_rule_id);
1657:

Line 1705: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,

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
1709: WHEN L_FND_EXC_ERROR THEN

Line 1711: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_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,
1715: p_count => x_msg_count,

Line 1719: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,

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,
1723: p_count => x_msg_count,

Line 1727: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,

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
1731: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,