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_BULK_ASSIGN dependencies on IGS_SC_BULK_ASSIGN

Line 1: PACKAGE BODY IGS_SC_BULK_ASSIGN AS

1: PACKAGE BODY IGS_SC_BULK_ASSIGN AS
2: /* $Header: IGSSC07B.pls 120.7 2006/02/02 07:10:55 skpandey noship $ */
3:
4:
5:

Line 12: l_prog_label CONSTANT VARCHAR2(500) :='igs.plsql.igs_sc_bulk_assign';

8: l_usrroles_array StrArray;
9: l_startdate_array DateArray;
10: l_enddate_array DateArray;
11:
12: l_prog_label CONSTANT VARCHAR2(500) :='igs.plsql.igs_sc_bulk_assign';
13: l_label VARCHAR2(4000);
14: l_debug_str VARCHAR2(32000);
15:
16:

Line 40: l_label := 'igs.plsql.igs_sc_bulk_assign.PopulateRolesArray';

36:
37: BEGIN
38: /* Debug */
39: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
40: l_label := 'igs.plsql.igs_sc_bulk_assign.PopulateRolesArray';
41: l_debug_str := 'Entering PopulateRolesArray. EncdStr is ' || EncdStr;
42: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
43: END IF;
44:

Line 74: l_label := 'igs.plsql.igs_sc_bulk_assign.PopulateRolesArray';

70: l_array_index := l_array_index +1;
71: L_End_Count := INSTR(L_Param_Str,'\:\');
72:
73: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
74: l_label := 'igs.plsql.igs_sc_bulk_assign.PopulateRolesArray';
75: l_debug_str := 'Inside PopulateRolesArray. l_Rec_Str: '||l_Rec_Str|| ', l_End_Rec_Count: '||l_End_Rec_Count||
76: ', l_Param_Str: '||l_Param_Str|| ', l_array_index: '||l_array_index;
77: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
78: END IF;

Line 83: l_label := 'igs.plsql.igs_sc_bulk_assign.PopulateRolesArray';

79:
80: END LOOP;
81: /* Debug */
82: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
83: l_label := 'igs.plsql.igs_sc_bulk_assign.PopulateRolesArray';
84: l_debug_str := 'Exiting PopulateRolesArray.';
85: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
86: END IF;
87:

Line 113: l_label := 'igs.plsql.igs_sc_bulk_assign.getTokens';

109:
110: BEGIN
111: /* Debug */
112: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
113: l_label := 'igs.plsql.igs_sc_bulk_assign.getTokens';
114: l_debug_str := 'Entering getTokens. EncdStr is ' || EncdStr||', l_array_index is ' || l_array_index;
115: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
116: END IF;
117:

Line 124: l_label := 'igs.plsql.igs_sc_bulk_assign.getTokens';

120: l_array_index := 1;
121:
122:
123: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
124: l_label := 'igs.plsql.igs_sc_bulk_assign.getTokens';
125: l_debug_str := 'Inside getTokens. L_Param_Str is'||L_Param_Str|| ', L_End_Count is '||L_End_Count;
126: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
127: END IF;
128:

Line 140: l_label := 'igs.plsql.igs_sc_bulk_assign.getTokens';

136:
137: END LOOP;
138: /* Debug */
139: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
140: l_label := 'igs.plsql.igs_sc_bulk_assign.getTokens';
141: l_debug_str := 'Exiting getTokens. Returning l_tokenArray(1)= ' ||l_tokenArray(1);
142: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
143: END IF;
144:

Line 175: l_label := 'igs.plsql.igs_sc_bulk_assign.BulkSecAssignment';

171:
172: BEGIN
173: /* Debug */
174: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
175: l_label := 'igs.plsql.igs_sc_bulk_assign.BulkSecAssignment';
176: l_debug_str := 'Entering BulkSecAssignment parameter values:'||
177: 'Org Unit: '||orgUnitStr||','||
178: 'Location: '||locStr||','||
179: 'Program Type: '||pgmStr||','||

Line 191: l_label := 'igs.plsql.igs_sc_bulk_assign.BulkSecAssignment';

187: orgUnitStr,locStr,pgmStr,unitMdStr,userRolesStr_one,userRolesStr_two,prsnGrpStr);
188:
189: /* Debug */
190: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
191: l_label := 'igs.plsql.igs_sc_bulk_assign.BulkSecAssignment';
192: l_debug_str := 'Exiting BulkSecAssignment. retValue is '||retValue;
193: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
194: END IF;
195:

Line 330: l_label := 'igs.plsql.igs_sc_bulk_assign.assign_user_attributes';

326: );
327:
328: /* Debug */
329: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
330: l_label := 'igs.plsql.igs_sc_bulk_assign.assign_user_attributes';
331: l_debug_str := 'Entering assign_user_attributes parameter values:'||
332: 'Org Unit: '||P_ORGUNIT_STR||','||
333: 'Location: '||P_LOCATIONS_STR||','||
334: 'Program Type: '||P_PGMTYPES_STR||','||

Line 380: l_label := 'igs.plsql.igs_sc_bulk_assign.assign_user_attributes';

376: /* get the person id corresponding to user belonging to the grp and assigned them following attributes */
377: l_select :=igs_pe_dynamic_persid_group.get_dynamic_sql(l_GrpId, l_status, l_group_type);
378:
379: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
380: l_label := 'igs.plsql.igs_sc_bulk_assign.assign_user_attributes';
381: l_debug_str := 'Person Group Array. Dynamic Person Group select is '||l_select ;
382: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
383: END IF;
384:

Line 427: l_label := 'igs.plsql.igs_sc_bulk_assign.assign_user_attributes';

423: OPEN DUP_ORGUNIT_CHECK_C(r_rec_query.Person_id,l_org_unit_array(i),'EMPLOYEE_OF','F');
424: FETCH DUP_ORGUNIT_CHECK_C INTO l_DupId;
425:
426: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
427: l_label := 'igs.plsql.igs_sc_bulk_assign.assign_user_attributes';
428: l_debug_str := 'Inside assign_user_attributes. l_org_unit_array(i) is '||l_org_unit_array(i) ;
429: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
430: END IF;
431:

Line 482: l_label := 'igs.plsql.igs_sc_bulk_assign.assign_user_attributes';

478: OPEN IGS_SC_DUP_C(r_rec_query.Person_id,6,l_locations_array(i));
479: FETCH IGS_SC_DUP_C INTO l_DupId;
480:
481: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
482: l_label := 'igs.plsql.igs_sc_bulk_assign.assign_user_attributes';
483: l_debug_str := 'Inside assign_user_attributes. l_locations_array(i) is '||l_locations_array(i) ;
484: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
485: END IF;
486:

Line 507: l_label := 'igs.plsql.igs_sc_bulk_assign.assign_user_attributes';

503: OPEN IGS_SC_DUP_C(r_rec_query.Person_id,7,l_pgmtypes_array(i));
504: FETCH IGS_SC_DUP_C INTO l_DupId;
505:
506: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
507: l_label := 'igs.plsql.igs_sc_bulk_assign.assign_user_attributes';
508: l_debug_str := 'Inside assign_user_attributes. l_pgmtypes_array(i) is '||l_pgmtypes_array(i) ;
509: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
510: END IF;
511:

Line 532: l_label := 'igs.plsql.igs_sc_bulk_assign.assign_user_attributes';

528: OPEN IGS_SC_DUP_C(r_rec_query.Person_id,8,l_unitmd_array(i));
529: FETCH IGS_SC_DUP_C INTO l_DupId;
530:
531: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
532: l_label := 'igs.plsql.igs_sc_bulk_assign.assign_user_attributes';
533: l_debug_str := 'Inside assign_user_attributes. l_unitmd_array(i) is '||l_unitmd_array(i) ;
534: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
535: END IF;
536:

Line 586: l_label := 'igs.plsql.igs_sc_bulk_assign.assign_user_attributes';

582: OPEN GET_ROLE_NAME_C(l_usrroles_array(i));
583: FETCH GET_ROLE_NAME_C INTO l_role_name;
584:
585: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
586: l_label := 'igs.plsql.igs_sc_bulk_assign.assign_user_attributes';
587: l_debug_str := 'Inside assign_user_attributes. l_usrroles_array(i) is '||l_usrroles_array(i) ;
588: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
589: END IF;
590:

Line 668: l_label := 'igs.plsql.igs_sc_bulk_assign.assign_user_attributes';

664: CLOSE c_cur_query;
665: END LOOP;
666: /* Debug */
667: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
668: l_label := 'igs.plsql.igs_sc_bulk_assign.assign_user_attributes';
669: l_debug_str := 'Exiting assign_user_attributes.';
670: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
671: END IF;
672:

Line 681: l_label := 'igs.plsql.igs_sc_bulk_assign.assign_user_attributes';

677: EXCEPTION
678: WHEN NO_DATA_FOUND THEN
679: /* Debug */
680: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
681: l_label := 'igs.plsql.igs_sc_bulk_assign.assign_user_attributes';
682: l_debug_str := 'NO_DATA_FOUND exception in assign_user_attributes.'||SQLERRM;
683: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
684: END IF;
685: --Enable Business Event before quiting Bulk Process

Line 708: l_label := 'igs.plsql.igs_sc_bulk_assign.assign_user_attributes';

704:
705: WHEN OTHERS THEN
706: /* Debug */
707: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
708: l_label := 'igs.plsql.igs_sc_bulk_assign.assign_user_attributes';
709: l_debug_str := 'Exception in assign_user_attributes.'||SQLERRM;
710: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
711: END IF;
712:

Line 735: END IGS_SC_BULK_ASSIGN;

731: END IF;
732:
733: END Assign_User_attributes;
734:
735: END IGS_SC_BULK_ASSIGN;
736: