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 FND_API

Line 7: L_FND_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;

3:
4: L_FND_EXC_ERROR EXCEPTION;
5: L_FND_EXC_UNEXPECTED_ERROR EXCEPTION;
6:
7: L_FND_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
8: L_FND_RET_STS_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error;
9: L_FND_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
10:
11: line_number NUMBER := 0;

Line 8: L_FND_RET_STS_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error;

4: L_FND_EXC_ERROR EXCEPTION;
5: L_FND_EXC_UNEXPECTED_ERROR EXCEPTION;
6:
7: L_FND_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
8: L_FND_RET_STS_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error;
9: L_FND_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
10:
11: line_number NUMBER := 0;
12:

Line 9: L_FND_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;

5: L_FND_EXC_UNEXPECTED_ERROR EXCEPTION;
6:
7: L_FND_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
8: L_FND_RET_STS_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error;
9: L_FND_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
10:
11: line_number NUMBER := 0;
12:
13: -- Utility name : initbuildpackage

Line 101: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

97: x_msg_count OUT NOCOPY NUMBER,
98: x_msg_data OUT NOCOPY VARCHAR2)RETURN VARCHAR2 IS
99:
100: l_func_name CONSTANT VARCHAR2(30) := 'Build_Condition';
101: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
102: l_msg_count NUMBER;
103: l_msg_data VARCHAR2(2000);
104: l_debug_info VARCHAR2(200);
105: l_var_name VARCHAR2(15);

Line 139: x_return_status := FND_API.G_RET_STS_SUCCESS;

135:
136: BEGIN
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) ;

Line 192: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

188: x_msg_count => l_msg_count,
189: x_msg_data => l_msg_data);
190:
191: -- If any errors happen abort API.
192: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
193: RAISE L_FND_EXC_ERROR;
194: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
195: RAISE L_FND_EXC_UNEXPECTED_ERROR;
196: END IF;

Line 194: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

190:
191: -- If any errors happen abort API.
192: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
193: RAISE L_FND_EXC_ERROR;
194: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
195: RAISE L_FND_EXC_UNEXPECTED_ERROR;
196: END IF;
197:
198: l_condition_dsp := RTRIM(l_condition_dsp)||' '|| l_line_operator_dsp;

Line 243: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

239: x_msg_count => l_msg_count,
240: x_msg_data => l_msg_data);
241:
242: -- If any errors happen abort API.
243: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
244: RAISE L_FND_EXC_ERROR;
245: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
246: RAISE L_FND_EXC_UNEXPECTED_ERROR;
247: END IF;

Line 245: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

241:
242: -- If any errors happen abort API.
243: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
244: RAISE L_FND_EXC_ERROR;
245: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
246: RAISE L_FND_EXC_UNEXPECTED_ERROR;
247: END IF;
248: END IF;
249: END LOOP;

Line 259: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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:
263: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,

Line 273: x_return_status := FND_API.G_RET_STS_ERROR;

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;
276: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
277: p_count => x_msg_count,

Line 276: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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;
276: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
277: p_count => x_msg_count,
278: p_data => x_msg_data);
279: RETURN NULL;
280: WHEN L_FND_EXC_ERROR THEN

Line 324: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

320: x_msg_count OUT NOCOPY NUMBER,
321: x_msg_data OUT NOCOPY VARCHAR2)RETURN VARCHAR2 IS
322:
323: l_func_name CONSTANT VARCHAR2(30) := 'Build_FromClause';
324: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
325: l_msg_count NUMBER;
326: l_msg_data VARCHAR2(2000);
327: l_debug_info VARCHAR2(200);
328:

Line 357: x_return_status := FND_API.G_RET_STS_SUCCESS;

353:
354: BEGIN
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) ;

Line 434: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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:
438: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,

Line 448: x_return_status := FND_API.G_RET_STS_ERROR;

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;
451: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
452: p_count => x_msg_count,

Line 451: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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;
451: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
452: p_count => x_msg_count,
453: p_data => x_msg_data);
454: RETURN NULL;
455: WHEN L_FND_EXC_ERROR THEN

Line 486: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

482: --
483: -- Pre-reqs : None
484: -- Parameters :
485: -- IN : p_api_version IN NUMBER,
486: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
487: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
488: -- p_rule_id IN NUMBER
489: --
490: -- OUT x_return_status OUT NOCOPY VARCHAR2

Line 487: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

483: -- Pre-reqs : None
484: -- Parameters :
485: -- IN : p_api_version IN NUMBER,
486: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
487: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
488: -- p_rule_id IN NUMBER
489: --
490: -- OUT x_return_status OUT NOCOPY VARCHAR2
491: -- x_msg_count OUT NOCOPY NUMBER

Line 498: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

494: -- Version : Current version 1.0
495: --
496: -- Notes :
497: FUNCTION Build_Query(p_api_version IN NUMBER,
498: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
499: p_commit IN VARCHAR2 := FND_API.G_FALSE,
500: p_rule_id IN NUMBER,
501: x_return_status OUT NOCOPY VARCHAR2,
502: x_msg_count OUT NOCOPY NUMBER,

Line 499: p_commit IN VARCHAR2 := FND_API.G_FALSE,

495: --
496: -- Notes :
497: FUNCTION Build_Query(p_api_version IN NUMBER,
498: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
499: p_commit IN VARCHAR2 := FND_API.G_FALSE,
500: p_rule_id IN NUMBER,
501: x_return_status OUT NOCOPY VARCHAR2,
502: x_msg_count OUT NOCOPY NUMBER,
503: x_msg_data OUT NOCOPY VARCHAR2)RETURN VARCHAR2

Line 523: IF FND_API.to_Boolean(p_init_msg_list) THEN

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
524: FND_MSG_PUB.initialize;
525: END IF;
526:
527: -- Standard call to check for call compatibility

Line 528: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

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
532: RAISE L_FND_EXC_UNEXPECTED_ERROR;

Line 536: x_return_status := FND_API.G_RET_STS_SUCCESS;

532: RAISE L_FND_EXC_UNEXPECTED_ERROR;
533: END IF;
534:
535: -- Initialize API return status to success
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:
538: -- Check whether conditions exist for a given rule.
539: -- In case there is no condition created, skip the
540: -- build query execution

Line 563: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

559: x_msg_count => l_msg_count,
560: x_msg_data => l_msg_data);
561:
562: -- If any errors happen abort API.
563: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
564: RAISE L_FND_EXC_ERROR;
565: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
566: RAISE L_FND_EXC_UNEXPECTED_ERROR;
567: END IF;

Line 565: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

561:
562: -- If any errors happen abort API.
563: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
564: RAISE L_FND_EXC_ERROR;
565: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
566: RAISE L_FND_EXC_UNEXPECTED_ERROR;
567: END IF;
568:
569: l_debug_info := 'Call Build_Condition)';

Line 584: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

580: x_msg_count => l_msg_count,
581: x_msg_data => l_msg_data);
582:
583: -- If any errors happen abort API.
584: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
585: RAISE L_FND_EXC_ERROR;
586: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
587: RAISE L_FND_EXC_UNEXPECTED_ERROR;
588: END IF;

Line 586: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

582:
583: -- If any errors happen abort API.
584: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
585: RAISE L_FND_EXC_ERROR;
586: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
587: RAISE L_FND_EXC_UNEXPECTED_ERROR;
588: END IF;
589:
590: IF INSTR(UPPER(l_from_clause), 'WHERE') = 0 AND l_where_clause_cond IS NOT NULL THEN

Line 599: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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:
603: -- Standard End of Procedure/Function Logging

Line 614: x_return_status := FND_API.G_RET_STS_ERROR;

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;
617: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
618: p_count => x_msg_count,

Line 617: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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;
617: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
618: p_count => x_msg_count,
619: p_data => x_msg_data);
620: RETURN NULL;
621: WHEN FND_API.G_EXC_ERROR THEN

Line 621: WHEN FND_API.G_EXC_ERROR THEN

617: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
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;

Line 625: x_return_status := FND_API.G_RET_STS_ERROR;

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,
628: p_data => x_msg_data);
629: RETURN NULL;

Line 626: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
628: p_data => x_msg_data);
629: RETURN NULL;
630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

626: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
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;

Line 634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
637: p_data => x_msg_data);
638: RETURN NULL;

Line 635: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
637: p_data => x_msg_data);
638: RETURN NULL;
639: WHEN OTHERS THEN

Line 644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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(
646: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
647: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
648: p_procedure_name => l_api_name);

Line 650: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

646: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
647: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
648: p_procedure_name => l_api_name);
649: END IF;
650: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
651: p_count => x_msg_count,
652: p_data => x_msg_data);
653: RETURN NULL;
654: END Build_Query;

Line 695: x_return_status := FND_API.G_RET_STS_SUCCESS;

691:
692: BEGIN
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) ;

Line 741: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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:
745: -- Standard End of Procedure/Function Logging

Line 751: x_return_status := fnd_api.g_ret_sts_unexp_error;

747: p_procedure_name => l_func_name);
748:
749: EXCEPTION
750: WHEN OTHERS THEN
751: x_return_status := fnd_api.g_ret_sts_unexp_error;
752: END Build_SpecPackage;
753:
754: -- Utility name : Build_BodyPackage
755: -- Type : Private

Line 778: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

774: x_msg_count OUT NOCOPY NUMBER,
775: x_msg_data OUT NOCOPY VARCHAR2) IS
776:
777: l_func_name CONSTANT VARCHAR2(30) := 'Build_BodyPackage';
778: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
779: l_msg_count NUMBER;
780: l_msg_data VARCHAR2(2000);
781: l_debug_info VARCHAR2(200);
782:

Line 823: x_return_status := FND_API.G_RET_STS_SUCCESS;

819:
820: BEGIN
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) ;

Line 852: p_init_msg_list => FND_API.G_FALSE,

848: IF l_package_name IS NOT NULL THEN
849: -- This function will return the query which is built
850: -- based on the conditions from a given rule
851: l_query := Build_Query(p_api_version => 1.0,
852: p_init_msg_list => FND_API.G_FALSE,
853: p_commit => FND_API.G_FALSE,
854: p_rule_id => p_rule_id,
855: x_return_status => l_return_status,
856: x_msg_count => l_msg_count,

Line 853: p_commit => FND_API.G_FALSE,

849: -- This function will return the query which is built
850: -- based on the conditions from a given rule
851: l_query := Build_Query(p_api_version => 1.0,
852: p_init_msg_list => FND_API.G_FALSE,
853: p_commit => FND_API.G_FALSE,
854: p_rule_id => p_rule_id,
855: x_return_status => l_return_status,
856: x_msg_count => l_msg_count,
857: x_msg_data => l_msg_data);

Line 975: p_init_msg_list => fnd_api.g_false,

971: p_debug_info => l_debug_info);
972:
973: BEGIN
974: l_check_submit := INL_RULE_GRP.Check_Condition(p_api_version => 1.0,
975: p_init_msg_list => fnd_api.g_false,
976: p_commit => fnd_api.g_false,
977: p_ship_header_id => 1,
978: p_rule_package_name => l_package_name,
979: x_return_status => l_return_status,

Line 976: p_commit => fnd_api.g_false,

972:
973: BEGIN
974: l_check_submit := INL_RULE_GRP.Check_Condition(p_api_version => 1.0,
975: p_init_msg_list => fnd_api.g_false,
976: p_commit => fnd_api.g_false,
977: p_ship_header_id => 1,
978: p_rule_package_name => l_package_name,
979: x_return_status => l_return_status,
980: x_msg_count => l_msg_count,

Line 990: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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:
994: -- Standard End of Procedure/Function Logging

Line 1000: x_return_status := fnd_api.g_ret_sts_unexp_error;

996: p_procedure_name => l_func_name);
997:
998: EXCEPTION
999: WHEN OTHERS THEN
1000: x_return_status := fnd_api.g_ret_sts_unexp_error;
1001: END Build_BodyPackage;
1002:
1003: -- Utility name : Build_ConditionPackage
1004: -- Type : Private

Line 1010: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1006: -- It builds the package for Rule
1007: -- Pre-reqs : None
1008: -- Parameters :
1009: -- IN : p_api_version IN NUMBER,
1010: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1011: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1012: -- p_rule_id IN NUMBER
1013: --
1014: -- OUT x_message_name IN OUT NOCOPY VARCHAR2,

Line 1011: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

1007: -- Pre-reqs : None
1008: -- Parameters :
1009: -- IN : p_api_version IN NUMBER,
1010: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1011: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1012: -- p_rule_id IN NUMBER
1013: --
1014: -- OUT x_message_name IN OUT NOCOPY VARCHAR2,
1015: -- x_return_status OUT NOCOPY VARCHAR2

Line 1023: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1019: -- Version : Current version 1.0
1020: --
1021: -- Notes :
1022: PROCEDURE Build_ConditionPackage(p_api_version IN NUMBER,
1023: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1024: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1025: p_rule_id IN NUMBER,
1026: x_message_name IN OUT NOCOPY VARCHAR2,
1027: x_return_status OUT NOCOPY VARCHAR2,

Line 1024: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1020: --
1021: -- Notes :
1022: PROCEDURE Build_ConditionPackage(p_api_version IN NUMBER,
1023: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1024: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1025: p_rule_id IN NUMBER,
1026: x_message_name IN OUT NOCOPY VARCHAR2,
1027: x_return_status OUT NOCOPY VARCHAR2,
1028: x_msg_count OUT NOCOPY NUMBER,

Line 1033: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1029: x_msg_data OUT NOCOPY VARCHAR2)IS
1030:
1031: l_api_name CONSTANT VARCHAR2(30) := 'Build_ConditionPackage';
1032: l_api_version CONSTANT NUMBER := 1.0;
1033: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1034: l_msg_count NUMBER;
1035: l_msg_data VARCHAR2(2000);
1036: l_debug_info VARCHAR2(200);
1037:

Line 1048: IF FND_API.to_Boolean(p_init_msg_list) THEN

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
1049: FND_MSG_PUB.initialize;
1050: END IF;
1051:
1052: -- Standard call to check for call compatibility

Line 1053: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

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
1057: RAISE L_FND_EXC_UNEXPECTED_ERROR;

Line 1066: x_return_status := FND_API.G_RET_STS_SUCCESS;

1062: p_var_name => 'p_rule_id: ',
1063: p_var_value => p_rule_id);
1064:
1065: -- Initialize API return status to success
1066: x_return_status := FND_API.G_RET_STS_SUCCESS;
1067:
1068: SELECT r.rule_name, r.usage_code
1069: INTO l_rule_name, l_usage_code
1070: FROM inl_rules_vl r

Line 1097: IF l_return_status = fnd_api.g_ret_sts_error THEN

1093: x_msg_count => l_msg_count,
1094: x_msg_data => l_msg_data);
1095:
1096: -- If any errors happen abort API.
1097: IF l_return_status = fnd_api.g_ret_sts_error THEN
1098: RAISE L_FND_EXC_ERROR;
1099: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1100: RAISE L_FND_EXC_UNEXPECTED_ERROR;
1101: END IF;

Line 1099: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1095:
1096: -- If any errors happen abort API.
1097: IF l_return_status = fnd_api.g_ret_sts_error THEN
1098: RAISE L_FND_EXC_ERROR;
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,

Line 1114: IF l_return_status = fnd_api.g_ret_sts_error THEN

1110: x_msg_count => l_msg_count,
1111: x_msg_data => l_msg_data);
1112:
1113: -- If any errors happen abort API.
1114: IF l_return_status = fnd_api.g_ret_sts_error THEN
1115: RAISE L_FND_EXC_ERROR;
1116: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1117: RAISE L_FND_EXC_UNEXPECTED_ERROR;
1118: END IF;

Line 1116: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1112:
1113: -- If any errors happen abort API.
1114: IF l_return_status = fnd_api.g_ret_sts_error THEN
1115: RAISE L_FND_EXC_ERROR;
1116: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1117: RAISE L_FND_EXC_UNEXPECTED_ERROR;
1118: END IF;
1119: END IF;
1120:

Line 1122: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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:
1126: -- Standard End of Procedure/Function Logging

Line 1136: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
1138: p_data => x_msg_data);
1139: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
1140: -- Standard Unexpected Error Logging

Line 1144: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
1146: p_data => x_msg_data);
1147: WHEN OTHERS THEN
1148: -- Standard Unexpected Error Logging

Line 1156: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
1154: p_procedure_name => l_api_name) ;
1155: END IF;
1156: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1157: p_count => x_msg_count,
1158: p_data => x_msg_data);
1159:
1160: END Build_ConditionPackage;

Line 1169: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1165: -- Returns TRUE or FALSE depending on the validation status
1166: -- Pre-reqs : None
1167: -- Parameters :
1168: -- IN : p_api_version IN NUMBER
1169: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1170: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1171: -- p_rule_id IN NUMBER
1172: --
1173: -- OUT : x_message_name IN OUT NOCOPY VARCHAR2

Line 1170: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

1166: -- Pre-reqs : None
1167: -- Parameters :
1168: -- IN : p_api_version IN NUMBER
1169: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1170: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1171: -- p_rule_id IN NUMBER
1172: --
1173: -- OUT : x_message_name IN OUT NOCOPY VARCHAR2
1174: -- x_return_status OUT NOCOPY VARCHAR2

Line 1182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1178: -- Version : Current version 1.0
1179: --
1180: -- Notes :
1181: FUNCTION Validate_Rules(p_api_version IN NUMBER,
1182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1183: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1184: p_rule_id IN NUMBER,
1185: x_message_name IN OUT NOCOPY VARCHAR2,
1186: x_return_status OUT NOCOPY VARCHAR2,

Line 1183: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1179: --
1180: -- Notes :
1181: FUNCTION Validate_Rules(p_api_version IN NUMBER,
1182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1183: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1184: p_rule_id IN NUMBER,
1185: x_message_name IN OUT NOCOPY VARCHAR2,
1186: x_return_status OUT NOCOPY VARCHAR2,
1187: x_msg_count OUT NOCOPY NUMBER,

Line 1294: IF FND_API.to_Boolean(p_init_msg_list) THEN

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
1295: FND_MSG_PUB.initialize;
1296: END IF;
1297:
1298: -- Standard call to check for call compatibility

Line 1299: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

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
1303: RAISE L_FND_EXC_UNEXPECTED_ERROR;

Line 1307: x_return_status := FND_API.G_RET_STS_SUCCESS;

1303: RAISE L_FND_EXC_UNEXPECTED_ERROR;
1304: END IF;
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: ',

Line 1556: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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:
1560: -- Standard End of Procedure/Function Logging

Line 1572: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
1574: p_data => x_msg_data);
1575: RETURN 'FALSE';
1576: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN

Line 1581: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
1583: p_data => x_msg_data);
1584: RETURN 'FALSE';
1585: WHEN OTHERS THEN

Line 1594: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
1592: p_procedure_name => l_api_name) ;
1593: END IF;
1594: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1595: p_count => x_msg_count,
1596: p_data => x_msg_data);
1597: RETURN 'FALSE';
1598: END Validate_Rules;

Line 1607: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1603: -- It drops the package created for Rule
1604: -- Pre-reqs : None
1605: -- Parameters :
1606: -- IN : p_api_version IN NUMBER,
1607: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1608: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1609: -- p_rule_id IN NUMBER
1610: --
1611: -- OUT x_return_status OUT NOCOPY VARCHAR2

Line 1608: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

1604: -- Pre-reqs : None
1605: -- Parameters :
1606: -- IN : p_api_version IN NUMBER,
1607: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1608: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1609: -- p_rule_id IN NUMBER
1610: --
1611: -- OUT x_return_status OUT NOCOPY VARCHAR2
1612: -- x_msg_count OUT NOCOPY NUMBER

Line 1619: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1615: -- Version : Current version 1.0
1616: --
1617: -- Notes :
1618: PROCEDURE Drop_ConditionPackage(p_api_version IN NUMBER,
1619: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1620: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1621: p_rule_id IN NUMBER,
1622: x_return_status OUT NOCOPY VARCHAR2,
1623: x_msg_count OUT NOCOPY NUMBER,

Line 1620: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1616: --
1617: -- Notes :
1618: PROCEDURE Drop_ConditionPackage(p_api_version IN NUMBER,
1619: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1620: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1621: p_rule_id IN NUMBER,
1622: x_return_status OUT NOCOPY VARCHAR2,
1623: x_msg_count OUT NOCOPY NUMBER,
1624: x_msg_data OUT NOCOPY VARCHAR2)IS

Line 1628: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1624: x_msg_data OUT NOCOPY VARCHAR2)IS
1625:
1626: l_api_name CONSTANT VARCHAR2(30) := 'Drop_ConditionPackage';
1627: l_api_version CONSTANT NUMBER := 1.0;
1628: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1629:
1630: l_exist_package_spec NUMBER;
1631: l_exist_package_body NUMBER;
1632: l_statement VARCHAR2(200);

Line 1641: IF FND_API.to_Boolean(p_init_msg_list) THEN

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
1642: FND_MSG_PUB.initialize;
1643: END IF;
1644:
1645: -- Standard call to check for call compatibility

Line 1646: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

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
1650: RAISE L_FND_EXC_UNEXPECTED_ERROR;

Line 1659: x_return_status := FND_API.G_RET_STS_SUCCESS;

1655: p_var_name => 'p_rule_id: ',
1656: p_var_value => p_rule_id);
1657:
1658: -- Initialize API return status to success
1659: x_return_status := FND_API.G_RET_STS_SUCCESS;
1660:
1661: SELECT package_name
1662: INTO l_package_name
1663: FROM inl_rules_vl

Line 1700: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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:
1704: -- Standard End of Procedure/Function Logging

Line 1714: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
1716: p_data => x_msg_data);
1717: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
1718: -- Standard Unexpected Error Logging

Line 1722: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
1724: p_data => x_msg_data);
1725: WHEN OTHERS THEN
1726: -- Standard Unexpected Error Logging

Line 1734: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
1732: p_procedure_name => l_api_name) ;
1733: END IF;
1734: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1735: p_count => x_msg_count,
1736: p_data => x_msg_data);
1737: END Drop_ConditionPackage;
1738: