DBA Data[Home] [Help]

APPS.IGS_SC_BULK_ASSIGN dependencies on FND_LOG

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

35: -- This will have the current array index
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;

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

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:
45:
46: L_Param_Str := EncdStr;

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

69: l_Param_Str := SUBSTR(L_Param_Str,L_End_Count+3);
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);

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

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;
79:
80: END LOOP;
81: /* Debug */

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

78: END IF;
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;

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

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:
88: END PopulateRolesArray;
89:

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

108: l_array_index binary_integer;
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;

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

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:
118: L_Param_Str := EncdStr;
119: L_End_Count := INSTR(L_Param_Str,'\:\');

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

119: L_End_Count := INSTR(L_Param_Str,'\:\');
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;

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

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:
129: WHILE L_Param_Str IS NOT NULL LOOP
130: l_tokenArray.EXTEND(1);

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

135: L_End_Count := INSTR(L_Param_Str,'\:\');
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;

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

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:
145: RETURN l_tokenArray;
146: End getTokens;

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

170: ------------------------------------------------------------------
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||','||

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

180: 'Unit Mode: '||unitMdStr||','||
181: 'User Roles Str1: '||userRolesStr_one||','||
182: 'User Roles Str2: '||userRolesStr_two||','||
183: 'Person Group: '||prsnGrpStr;
184: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
185: END IF;
186: retValue := fnd_request.submit_request('IGS','IGSSCJ01','Bulk Security Attributes Assignment',NULL,false,
187: orgUnitStr,locStr,pgmStr,unitMdStr,userRolesStr_one,userRolesStr_two,prsnGrpStr);
188:

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

186: retValue := fnd_request.submit_request('IGS','IGSSCJ01','Bulk Security Attributes Assignment',NULL,false,
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;

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

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:
196: END BulkSecAssignment;
197:

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

325: P_TURNOFF => 'Y'
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||','||

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

335: 'Unit Mode: '||P_UNITMODE_STR||','||
336: 'User Roles Str1: '||P_USERROLES_STR_ONE||','||
337: 'User Roles Str2: '||P_USERROLES_STR_TWO||','||
338: 'Person Group: '||P_PRSNGRP_STR;
339: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
340: END IF;
341:
342: RETCODE :=0;
343: /* Now we have all the person Grp Code */

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

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

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

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:
385: IF l_status <> 'S' THEN
386: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_QUERY');

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

422: /* First check whether this attribute already exist */
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;

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

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:
432: IF DUP_ORGUNIT_CHECK_C%NOTFOUND THEN
433:

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

477: /* First check that user does not have this attribute already assigned */
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;

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

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:
487: IF IGS_SC_DUP_C%NOTFOUND THEN
488: IGS_SC_PER_ATTR_VALS_PKG.INSERT_ROW(

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

502: LOOP
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;

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

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:
512: IF IGS_SC_DUP_C%NOTFOUND THEN
513: IGS_SC_PER_ATTR_VALS_PKG.INSERT_ROW(

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

527: LOOP
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;

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

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:
537: IF IGS_SC_DUP_C%NOTFOUND THEN
538: IGS_SC_PER_ATTR_VALS_PKG.INSERT_ROW(

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

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

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

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:
591: CLOSE GET_ROLE_NAME_C;
592:

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

663: END LOOP; -- c_cur_query
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;

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

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:
673: --Enable Business Event before quiting Bulk Process
674: IGS_PE_GEN_003.TURNOFF_TCA_BE (

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

676: );
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;

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

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
686: IGS_PE_GEN_003.TURNOFF_TCA_BE (
687: P_TURNOFF => 'N'

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

703: END IF;
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;

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

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:
713: --Enable Business Event before quiting Bulk Process
714: IGS_PE_GEN_003.TURNOFF_TCA_BE (