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.IGS_SC_GRANTS_PVT dependencies on FND_LOG

Line 23: gmaheswa 26-Jul-2005 Fnd Logging

19: Who When What
20: -----------------------------------------------------------
21: Arkadi Tereshenkov Apr-10-2002 New Package created.
22: mmkumar 05-Jul-2005 Changed the build grant
23: gmaheswa 26-Jul-2005 Fnd Logging
24: ******************************************************************/
25:
26:
27: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGS_SC_GRANTS_PVT';

Line 172: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

168: l_final_result := l_final_result || p_char;
169: END IF;
170: END IF;
171:
172: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
173: l_label := 'igs.plsql.igs_sc_grants_pvt.handler.end';
174: l_debug_str := 'Final Result :'|| l_final_result;
175: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
176: END IF;

Line 175: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

171:
172: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
173: l_label := 'igs.plsql.igs_sc_grants_pvt.handler.end';
174: l_debug_str := 'Final Result :'|| l_final_result;
175: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
176: END IF;
177:
178: END handler;
179:

Line 306: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

302: l_api_name CONSTANT VARCHAR2(30) := 'CHECK_GRANT_TEXT';
303: l_val NUMBER(20);
304: l_select_text VARCHAR(32000);
305: BEGIN
306: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
307: l_label := 'igs.plsql.igs_sc_grants_pvt.check_grant_text.begin';
308: l_debug_str := 'Table Name: '||p_table_name||','||'Select Text: '||p_select_text;
309: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
310: END IF;

Line 309: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

305: BEGIN
306: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
307: l_label := 'igs.plsql.igs_sc_grants_pvt.check_grant_text.begin';
308: l_debug_str := 'Table Name: '||p_table_name||','||'Select Text: '||p_select_text;
309: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
310: END IF;
311:
312: l_select_text := replace_string(ltrim(p_select_text),':PARTY_ID','igs_sc_vars.get_partyid');
313:

Line 318: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

314: l_select_text := replace_string(ltrim(l_select_text),':USER_ID','igs_sc_vars.get_userid');
315:
316: l_select_text := replace_string(ltrim(l_select_text),':TBL_ALIAS','tstal');
317:
318: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
319: l_label := 'igs.plsql.igs_sc_grants_pvt.check_grant_text.before_execute';
320: l_debug_str := 'Final Select: '||'SELECT 1 FROM ('||' SELECT 1 FROM '||p_table_name||' WHERE '||l_select_text||' )';
321: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
322: END IF;

Line 321: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

317:
318: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
319: l_label := 'igs.plsql.igs_sc_grants_pvt.check_grant_text.before_execute';
320: l_debug_str := 'Final Select: '||'SELECT 1 FROM ('||' SELECT 1 FROM '||p_table_name||' WHERE '||l_select_text||' )';
321: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
322: END IF;
323:
324: -- EXECUTE IMMEDIATE 'SELECT count(*) FROM ('||' SELECT 1 FROM '||p_table_name||' WHERE '||l_select_text||' )'
325: --simrans change

Line 335: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

331: EXCEPTION
332: WHEN OTHERS THEN
333:
334: -- add error to the stack and return false
335: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
336: l_label := 'igs.plsql.igs_sc_grants_pvt.check_grant_text.execption';
337: l_debug_str := 'Exception: '||SQLERRM;
338: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
339: END IF;

Line 338: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

334: -- add error to the stack and return false
335: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
336: l_label := 'igs.plsql.igs_sc_grants_pvt.check_grant_text.execption';
337: l_debug_str := 'Exception: '||SQLERRM;
338: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
339: END IF;
340:
341: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
342:

Line 538: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

534: x_where_clause:= generate_grant (
535: p_object_name => p_object_name,
536: p_function_type => p_function_type);
537:
538: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
539: l_label := 'igs.plsql.igs_sc_grants_pvt.generate_grant';
540: l_debug_str := 'Table Name: '||p_object_name||','||' Function type: '||p_function_type||','
541: ||'Pridicate Where Clause: '||x_where_clause;
542: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

Line 542: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

538: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
539: l_label := 'igs.plsql.igs_sc_grants_pvt.generate_grant';
540: l_debug_str := 'Table Name: '||p_object_name||','||' Function type: '||p_function_type||','
541: ||'Pridicate Where Clause: '||x_where_clause;
542: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
543: END IF;
544:
545: -- API body
546:

Line 568: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

564: x_return_status := FND_API.G_RET_STS_ERROR;
565: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
566: p_data => x_msg_data );
567:
568: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
569: l_label := 'igs.plsql.igs_sc_grants_pvt.generate_grant.ex_error';
570: l_debug_str := 'Handled Exception: Table Name: '||p_object_name||','||' Function type: '||p_function_type||','
571: ||'Error Message: '||x_msg_data;
572: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

Line 572: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

568: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
569: l_label := 'igs.plsql.igs_sc_grants_pvt.generate_grant.ex_error';
570: l_debug_str := 'Handled Exception: Table Name: '||p_object_name||','||' Function type: '||p_function_type||','
571: ||'Error Message: '||x_msg_data;
572: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
573: END IF;
574:
575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
576:

Line 581: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
579: p_data => x_msg_data );
580:
581: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
582: l_label := 'igs.plsql.igs_sc_grants_pvt.generate_grant.ex_un';
583: l_debug_str := 'Unhandled Exception: Table Name: '||p_object_name||','||' Function type: '||p_function_type||','
584: ||'Error Message: '||x_msg_data;
585: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

Line 585: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

581: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
582: l_label := 'igs.plsql.igs_sc_grants_pvt.generate_grant.ex_un';
583: l_debug_str := 'Unhandled Exception: Table Name: '||p_object_name||','||' Function type: '||p_function_type||','
584: ||'Error Message: '||x_msg_data;
585: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
586: END IF;
587:
588: WHEN OTHERS THEN
589:

Line 598: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

594: END IF;
595: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
596: p_data => x_msg_data );
597:
598: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
599: l_label := 'igs.plsql.igs_sc_grants_pvt.generate_grant.ex_other';
600: l_debug_str := 'Other Exceptions: Table Name: '||p_object_name||','||' Function type: '||p_function_type||','
601: ||'Error Message: '||x_msg_data;
602: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

Line 602: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

598: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
599: l_label := 'igs.plsql.igs_sc_grants_pvt.generate_grant.ex_other';
600: l_debug_str := 'Other Exceptions: Table Name: '||p_object_name||','||' Function type: '||p_function_type||','
601: ||'Error Message: '||x_msg_data;
602: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
603: END IF;
604:
605: END generate_grant;
606:

Line 670: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

666: l_table_column VARCHAR2(30);
667:
668: BEGIN
669:
670: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
671: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant.begin';
672: l_debug_str := 'Grant ID: '||p_grants_rec.grant_id||','||' Grant text: '||p_grants_rec.grant_text;
673: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
674: END IF;

Line 673: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

669:
670: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
671: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant.begin';
672: l_debug_str := 'Grant ID: '||p_grants_rec.grant_id||','||' Grant text: '||p_grants_rec.grant_text;
673: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
674: END IF;
675:
676: onlyZTypeAttributes := TRUE;
677:

Line 713: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

709: --code added by mmkumar ends
710:
711: FOR c_grant_cond_rec IN c_grant_cond(p_grants_rec.grant_id) LOOP
712:
713: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
714: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant.grant_cond_loop';
715: l_debug_str := 'Condition Number: '||c_grant_cond_rec.grant_cond_num||','||'Object Attribute ID: '||c_grant_cond_rec.obj_attrib_id
716: ||','||'User Attrib ID: '||c_grant_cond_rec.user_attrib_id||','||'Condition Text Value: '||c_grant_cond_rec.text_value;
717: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

Line 717: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

713: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
714: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant.grant_cond_loop';
715: l_debug_str := 'Condition Number: '||c_grant_cond_rec.grant_cond_num||','||'Object Attribute ID: '||c_grant_cond_rec.obj_attrib_id
716: ||','||'User Attrib ID: '||c_grant_cond_rec.user_attrib_id||','||'Condition Text Value: '||c_grant_cond_rec.text_value;
717: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
718: END IF;
719:
720: Put_Log_Msg ('| Condition found: '||c_grant_cond_rec.grant_cond_num,0);
721:

Line 759: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

755:
756: CLOSE c_obj_attrib;
757:
758: Put_Log_Msg ('| Attribute fetched: '||l_obj_attrib.obj_attrib_id||' '||l_obj_attrib.obj_attrib_type ,0);
759: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
760: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant.grant_attrib';
761: l_debug_str := 'Attribute fetched: '||l_obj_attrib.obj_attrib_id||','||l_obj_attrib.obj_attrib_type ;
762: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
763: END IF;

Line 762: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

758: Put_Log_Msg ('| Attribute fetched: '||l_obj_attrib.obj_attrib_id||' '||l_obj_attrib.obj_attrib_type ,0);
759: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
760: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant.grant_attrib';
761: l_debug_str := 'Attribute fetched: '||l_obj_attrib.obj_attrib_id||','||l_obj_attrib.obj_attrib_type ;
762: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
763: END IF;
764:
765: --code added by mmkumar
766: l_grant_cond(c_grant_cond_rec.grant_cond_num).z_typ_flag := l_obj_attrib.NULL_ALLOW_FLAG;

Line 844: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

840: RAISE FND_API.G_EXC_ERROR;
841:
842: END IF;
843:
844: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
845: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant.condition_text';
846: l_debug_str := 'Attribute condition: '||l_grant_cond(c_grant_cond_rec.grant_cond_num).cond_text ;
847: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
848: END IF;

Line 847: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

843:
844: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
845: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant.condition_text';
846: l_debug_str := 'Attribute condition: '||l_grant_cond(c_grant_cond_rec.grant_cond_num).cond_text ;
847: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
848: END IF;
849:
850: Put_Log_Msg ('| Attribute condition: '|| l_grant_cond(c_grant_cond_rec.grant_cond_num).cond_text,0);
851:

Line 867: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

863: CLOSE c_user_attrib;
864:
865: Put_Log_Msg ('| User Attribute found: '|| l_grant_cond(c_grant_cond_rec.grant_cond_num).user_attrib_id ,0);
866:
867: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
868: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant.user_attrib';
869: l_debug_str := ' User Attribute found: '||l_grant_cond(c_grant_cond_rec.grant_cond_num).user_attrib_id ;
870: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
871: END IF;

Line 870: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

866:
867: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
868: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant.user_attrib';
869: l_debug_str := ' User Attribute found: '||l_grant_cond(c_grant_cond_rec.grant_cond_num).user_attrib_id ;
870: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
871: END IF;
872:
873:
874: -- If dynamic attribute - get value for dynamic C - constant, S - static, D - dynamic

Line 935: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

931: ELSE
932: NULL;
933: END IF;
934:
935: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
936: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant.Obj_select_1';
937: l_debug_str := ' Object select NULL, and Z type attrib. Condition text '||l_grant_cond(c_grant_cond_rec.grant_cond_num).cond_text ;
938: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
939: END IF;

Line 938: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

934:
935: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
936: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant.Obj_select_1';
937: l_debug_str := ' Object select NULL, and Z type attrib. Condition text '||l_grant_cond(c_grant_cond_rec.grant_cond_num).cond_text ;
938: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
939: END IF;
940:
941:
942: ELSE

Line 981: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

977: l_obj_const||' '||l_grant_cond(c_grant_cond_rec.grant_cond_num).condition||' '||l_usr_const||l_post_grant;
978:
979: END IF;
980:
981: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
982: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant.Obj_select_2';
983: l_debug_str := ' Object select is NULL. Non Z. Grant condition text '||l_grant_cond(c_grant_cond_rec.grant_cond_num).cond_text ;
984: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
985: END IF;

Line 984: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

980:
981: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
982: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant.Obj_select_2';
983: l_debug_str := ' Object select is NULL. Non Z. Grant condition text '||l_grant_cond(c_grant_cond_rec.grant_cond_num).cond_text ;
984: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
985: END IF;
986: END IF; --mmkumar
987: ELSE --Object select is not null
988:

Line 1006: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

1002: ELSE
1003: NULL;
1004: END IF;
1005:
1006: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1007: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant.Obj_select_3';
1008: l_debug_str := ' Object select NOT NULL, and Z type attrib. Condition text '||l_grant_cond(c_grant_cond_rec.grant_cond_num).cond_text ;
1009: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1010: END IF;

Line 1009: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

1005:
1006: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1007: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant.Obj_select_3';
1008: l_debug_str := ' Object select NOT NULL, and Z type attrib. Condition text '||l_grant_cond(c_grant_cond_rec.grant_cond_num).cond_text ;
1009: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1010: END IF;
1011:
1012: ELSE
1013: -- its not Z

Line 1035: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

1031: ELSE
1032: l_grant_cond(c_grant_cond_rec.grant_cond_num).cond_text := l_grant_cond(c_grant_cond_rec.grant_cond_num).cond_text||')';
1033: END IF;
1034:
1035: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1036: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant.Obj_select_4';
1037: l_debug_str := ' Object select NOT NULL, and Non Z type attrib. Condition text '||l_grant_cond(c_grant_cond_rec.grant_cond_num).cond_text ;
1038: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1039: END IF;

Line 1038: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

1034:
1035: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1036: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant.Obj_select_4';
1037: l_debug_str := ' Object select NOT NULL, and Non Z type attrib. Condition text '||l_grant_cond(c_grant_cond_rec.grant_cond_num).cond_text ;
1038: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1039: END IF;
1040: END IF; --mmkumar
1041: END IF;
1042:

Line 1074: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

1070: END LOOP;
1071:
1072: l_bodmas_grant_text := getBodmasCondition(l_grant_text);
1073:
1074: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1075: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant.bodmas_return_1';
1076: l_debug_str := ' Grant text after Bodmas call '||l_bodmas_grant_text ;
1077: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1078: END IF;

Line 1077: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

1073:
1074: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1075: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant.bodmas_return_1';
1076: l_debug_str := ' Grant text after Bodmas call '||l_bodmas_grant_text ;
1077: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1078: END IF;
1079:
1080: -- Analize grant structure and construct grant, example "(:1 AND (:2 OR :3))"
1081: l_cur_pos :=1;

Line 1136: --gmaheswa fnd logging

1132: --END IF; --mmkumar
1133:
1134: --code added by mmkumar ends
1135:
1136: --gmaheswa fnd logging
1137: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1138: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant_end';
1139: l_debug_str := 'Final where Clause: Table Name: '||p_group_rec.table_name||','||'Pridicate Where: '||l_statment;
1140: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

Line 1137: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

1133:
1134: --code added by mmkumar ends
1135:
1136: --gmaheswa fnd logging
1137: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1138: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant_end';
1139: l_debug_str := 'Final where Clause: Table Name: '||p_group_rec.table_name||','||'Pridicate Where: '||l_statment;
1140: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1141: END IF;

Line 1140: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

1136: --gmaheswa fnd logging
1137: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1138: l_label := 'igs.plsql.igs_sc_grants_pvt.build_grant_end';
1139: l_debug_str := 'Final where Clause: Table Name: '||p_group_rec.table_name||','||'Pridicate Where: '||l_statment;
1140: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1141: END IF;
1142:
1143:
1144:

Line 1272: --gmaheswa fnd logging

1268:
1269:
1270: BEGIN
1271:
1272: --gmaheswa fnd logging
1273: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1274: l_label := 'igs.plsql.igs_sc_grants_pvt.generate_grant.local';
1275: l_debug_str := 'Table Name: '||p_object_name||','||'Function Type: '||p_function_type;
1276: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

Line 1273: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

1269:
1270: BEGIN
1271:
1272: --gmaheswa fnd logging
1273: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1274: l_label := 'igs.plsql.igs_sc_grants_pvt.generate_grant.local';
1275: l_debug_str := 'Table Name: '||p_object_name||','||'Function Type: '||p_function_type;
1276: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1277: END IF;

Line 1276: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

1272: --gmaheswa fnd logging
1273: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1274: l_label := 'igs.plsql.igs_sc_grants_pvt.generate_grant.local';
1275: l_debug_str := 'Table Name: '||p_object_name||','||'Function Type: '||p_function_type;
1276: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1277: END IF;
1278:
1279: g_alias_number :=0;
1280: l_user_id := igs_sc_vars.get_userid;

Line 1355: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

1351: -- Nothing is granted for a group. Apply default policy
1352:
1353: -- Default policy G - grant all, R - restrict all
1354: IF l_group_rec.default_policy_type ='G' THEN
1355: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1356: l_label := 'igs.plsql.igs_sc_grants_pvt.generate_grant.default1';
1357: l_debug_str := 'Table Name: '||p_object_name||','||'Function Type: '||p_function_type||','||' User ID: '
1358: ||l_user_id||','||'Default Policy: G';
1359: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

Line 1359: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

1355: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1356: l_label := 'igs.plsql.igs_sc_grants_pvt.generate_grant.default1';
1357: l_debug_str := 'Table Name: '||p_object_name||','||'Function Type: '||p_function_type||','||' User ID: '
1358: ||l_user_id||','||'Default Policy: G';
1359: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1360: END IF;
1361: RETURN '';
1362:
1363: ELSE

Line 1364: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

1360: END IF;
1361: RETURN '';
1362:
1363: ELSE
1364: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1365: l_label := 'igs.plsql.igs_sc_grants_pvt.generate_grant.default2';
1366: l_debug_str := 'Table Name: '||p_object_name||','||'Function Type: '||p_function_type||','||' User ID: '
1367: ||l_user_id||','||'Default Policy: R';
1368: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

Line 1368: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

1364: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1365: l_label := 'igs.plsql.igs_sc_grants_pvt.generate_grant.default2';
1366: l_debug_str := 'Table Name: '||p_object_name||','||'Function Type: '||p_function_type||','||' User ID: '
1367: ||l_user_id||','||'Default Policy: R';
1368: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1369: END IF;
1370:
1371: RETURN '1=2';
1372:

Line 1378: --gmaheswa fnd logging

1374:
1375:
1376: END IF;
1377:
1378: --gmaheswa fnd logging
1379: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1380: l_label := 'igs.plsql.igs_sc_grants_pvt.generate_grant.final_return';
1381: l_debug_str := 'Table Name: '||p_object_name||','||'Function Type: '||p_function_type||','||' User ID: '
1382: ||l_user_id||','||'Final Select: '||l_statment;

Line 1379: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

1375:
1376: END IF;
1377:
1378: --gmaheswa fnd logging
1379: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1380: l_label := 'igs.plsql.igs_sc_grants_pvt.generate_grant.final_return';
1381: l_debug_str := 'Table Name: '||p_object_name||','||'Function Type: '||p_function_type||','||' User ID: '
1382: ||l_user_id||','||'Final Select: '||l_statment;
1383: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

Line 1383: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

1379: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1380: l_label := 'igs.plsql.igs_sc_grants_pvt.generate_grant.final_return';
1381: l_debug_str := 'Table Name: '||p_object_name||','||'Function Type: '||p_function_type||','||' User ID: '
1382: ||l_user_id||','||'Final Select: '||l_statment;
1383: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1384: END IF;
1385:
1386:
1387: RETURN l_statment;

Line 2056: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2052:
2053: RETURN BOOLEAN IS
2054: l_select_text VARCHAR2(32000);
2055: BEGIN
2056: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2057: l_label := 'igs.plsql.igs_sc_grants_pvt.check_attrib_text';
2058: l_debug_str := 'Table Name: '||p_table_name||','||'Select Text: '||p_select_text||','||'Object Attribute Type: '||p_obj_attrib_type;
2059: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2060: END IF;

Line 2059: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

2055: BEGIN
2056: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2057: l_label := 'igs.plsql.igs_sc_grants_pvt.check_attrib_text';
2058: l_debug_str := 'Table Name: '||p_table_name||','||'Select Text: '||p_select_text||','||'Object Attribute Type: '||p_obj_attrib_type;
2059: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2060: END IF;
2061:
2062: IF p_obj_attrib_type = 'F' THEN
2063: