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.JTF_UM_WF_DELEGATION_PVT dependencies on JTF_DEBUG_PUB

Line 28: l_is_debug_parameter_on boolean := JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME);

24: *
25: */
26:
27: MODULE_NAME CONSTANT VARCHAR2(50) := 'JTF.UM.PLSQL.JTF_UM_WF_DELEGATION_PVT';
28: l_is_debug_parameter_on boolean := JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME);
29:
30: procedure has_admin_enrollment (
31: p_subscription_id in number,
32: p_user_id in number,

Line 45: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

41: l_principal_name JTF_AUTH_PRINCIPALS_B.PRINCIPAL_NAME%TYPE;
42:
43: BEGIN
44:
45: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
46: p_message => l_procedure_name
47: );
48:
49: if (JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then

Line 49: if (JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then

45: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
46: p_message => l_procedure_name
47: );
48:
49: if (JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then
50: /* Bug #3468334 */
51: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
52: p_message => 'p_subscription_id:' || p_subscription_id || '+' || 'p_user_id:' || p_user_id
53: );

Line 51: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

47: );
48:
49: if (JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then
50: /* Bug #3468334 */
51: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
52: p_message => 'p_subscription_id:' || p_subscription_id || '+' || 'p_user_id:' || p_user_id
53: );
54: end if;
55:

Line 83: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,

79:
80: END LOOP;
81: CLOSE FIND_SUB_ROLES;
82:
83: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
84: p_message => l_procedure_name
85: );
86:
87: END has_admin_enrollment;

Line 128: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

124: x_return_result boolean := false;
125:
126: begin
127:
128: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
129: p_message => l_procedure_name
130: );
131:
132: if ( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then

Line 132: if ( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then

128: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
129: p_message => l_procedure_name
130: );
131:
132: if ( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then
133: /* Bug #3468334 changed -- */
134: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
135: p_message => 'p_subscription_id:' || p_subscription_id || '+' || 'p_user_id:' || p_user_id
136: );

Line 134: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

130: );
131:
132: if ( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then
133: /* Bug #3468334 changed -- */
134: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
135: p_message => 'p_subscription_id:' || p_subscription_id || '+' || 'p_user_id:' || p_user_id
136: );
137: end if;
138:

Line 167: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,

163: x_result := true;
164:
165: END IF;
166:
167: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
168: p_message => l_procedure_name
169: );
170:
171: end can_delegate;

Line 212: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (p_module => MODULE_NAME,

208: and nvl (effective_end_date, sysdate + 1) > sysdate;
209:
210: begin
211:
212: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (p_module => MODULE_NAME,
213: p_message => l_procedure_name);
214:
215: if ( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then
216: /* Bug #3468334 changed -- */

Line 215: if ( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then

211:
212: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (p_module => MODULE_NAME,
213: p_message => l_procedure_name);
214:
215: if ( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then
216: /* Bug #3468334 changed -- */
217: JTF_DEBUG_PUB.LOG_PARAMETERS (p_module => MODULE_NAME,
218: p_message => 'p_subscription_id:' || p_subscription_id || '+' || 'p_usertype_id:' || p_usertype_id);
219: end if;

Line 217: JTF_DEBUG_PUB.LOG_PARAMETERS (p_module => MODULE_NAME,

213: p_message => l_procedure_name);
214:
215: if ( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then
216: /* Bug #3468334 changed -- */
217: JTF_DEBUG_PUB.LOG_PARAMETERS (p_module => MODULE_NAME,
218: p_message => 'p_subscription_id:' || p_subscription_id || '+' || 'p_usertype_id:' || p_usertype_id);
219: end if;
220:
221: x_result := false;

Line 231: JTF_DEBUG_PUB.LOG_EXITING_METHOD (p_module => MODULE_NAME,

227: if (l_sub_flag = 'DELEGATION') or (l_sub_flag = 'DELEGATION_SELFSERVICE') then
228: x_result := true;
229: END IF;
230:
231: JTF_DEBUG_PUB.LOG_EXITING_METHOD (p_module => MODULE_NAME,
232: p_message => l_procedure_name);
233:
234: end can_enrollment_delegate;
235:

Line 310: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

306: l_procedure_name CONSTANT varchar2(30) := 'has_delegation_role';
307: l_delegation_role_id number;
308: BEGIN
309:
310: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
311: p_message => l_procedure_name
312: );
313:
314: if( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then

Line 314: if( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then

310: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
311: p_message => l_procedure_name
312: );
313:
314: if( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then
315: /* Bug #3468334 changed -- */
316: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
317: p_message => 'p_subscription_id:' || p_subscription_id || '+' || 'p_user_id:' || p_user_id
318: );

Line 316: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

312: );
313:
314: if( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then
315: /* Bug #3468334 changed -- */
316: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
317: p_message => 'p_subscription_id:' || p_subscription_id || '+' || 'p_user_id:' || p_user_id
318: );
319: end if;
320:

Line 323: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,

319: end if;
320:
321: IF NOT JTF_UM_UTIL_PVT.VALIDATE_USER_ID(p_user_id) THEN
322:
323: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
324: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id')
325: );
326:
327: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id'));

Line 324: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id')

320:
321: IF NOT JTF_UM_UTIL_PVT.VALIDATE_USER_ID(p_user_id) THEN
322:
323: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
324: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id')
325: );
326:
327: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id'));
328:

Line 327: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id'));

323: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
324: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id')
325: );
326:
327: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id'));
328:
329: END IF;
330:
331: IF NOT JTF_UM_UTIL_PVT.VALIDATE_SUBSCRIPTION_ID(p_subscription_id) THEN

Line 333: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,

329: END IF;
330:
331: IF NOT JTF_UM_UTIL_PVT.VALIDATE_SUBSCRIPTION_ID(p_subscription_id) THEN
332:
333: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
334: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id')
335: );
336:
337: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id'));

Line 334: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id')

330:
331: IF NOT JTF_UM_UTIL_PVT.VALIDATE_SUBSCRIPTION_ID(p_subscription_id) THEN
332:
333: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
334: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id')
335: );
336:
337: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id'));
338:

Line 337: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id'));

333: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
334: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id')
335: );
336:
337: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id'));
338:
339:
340: END IF;
341:

Line 357: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,

353: p_auth_principal_id => l_delegation_role_id
354: );
355: END IF;
356:
357: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
358: p_message => l_procedure_name
359: );
360:
361: END has_delegation_role;

Line 422: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

418: ORDER BY EFFECTIVE_END_DATE DESC;
419:
420: BEGIN
421:
422: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
423: p_message => l_procedure_name
424: );
425:
426:

Line 427: if ( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then

423: p_message => l_procedure_name
424: );
425:
426:
427: if ( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then
428: /* Bug #3468334 changed */
429: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
430: p_message => 'p_subscription_id:' || p_subscription_id || '+' || 'p_grant_delegation_flag:' || JTF_DBSTRING_UTILS.getBooleanString(p_grant_delegation_flag) || '+' || 'p_user_id:' || p_user_id
431: );

Line 429: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

425:
426:
427: if ( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then
428: /* Bug #3468334 changed */
429: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
430: p_message => 'p_subscription_id:' || p_subscription_id || '+' || 'p_grant_delegation_flag:' || JTF_DBSTRING_UTILS.getBooleanString(p_grant_delegation_flag) || '+' || 'p_user_id:' || p_user_id
431: );
432: end if;
433:

Line 439: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,

435: FETCH FIND_ACTIVATION_MODE INTO l_activation_mode;
436: CLOSE FIND_ACTIVATION_MODE;
437:
438: IF l_activation_mode IS NULL THEN
439: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
440: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('JTA_UM_UT_ENROLL_NO_ASGN')
441: );
442:
443: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('JTA_UM_UT_ENROLL_NO_ASGN'));

Line 440: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('JTA_UM_UT_ENROLL_NO_ASGN')

436: CLOSE FIND_ACTIVATION_MODE;
437:
438: IF l_activation_mode IS NULL THEN
439: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
440: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('JTA_UM_UT_ENROLL_NO_ASGN')
441: );
442:
443: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('JTA_UM_UT_ENROLL_NO_ASGN'));
444: END IF;

Line 443: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('JTA_UM_UT_ENROLL_NO_ASGN'));

439: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
440: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('JTA_UM_UT_ENROLL_NO_ASGN')
441: );
442:
443: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('JTA_UM_UT_ENROLL_NO_ASGN'));
444: END IF;
445:
446:
447: -- Check if an enrollment is IMPLICIT or EXPLICIT

Line 723: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,

719: END IF;
720:
721: END IF;
722:
723: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
724: p_message => l_procedure_name
725: );
726:
727: END get_checkbox_status;

Line 828: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

824: l_usertype_id number;
825:
826: BEGIN
827:
828: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
829: p_message => l_procedure_name
830: );
831:
832: if ( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then

Line 832: if ( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then

828: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
829: p_message => l_procedure_name
830: );
831:
832: if ( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then
833: /* Bug #3468334 changed */
834: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
835: p_message => 'p_reg_id:' || p_reg_id || '+' || 'p_user_id:' || p_user_id
836: );

Line 834: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

830: );
831:
832: if ( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then
833: /* Bug #3468334 changed */
834: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
835: p_message => 'p_reg_id:' || p_reg_id || '+' || 'p_user_id:' || p_user_id
836: );
837: end if;
838: OPEN FIND_DELEGATION_FLAG;

Line 871: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,

867: END IF;
868:
869: CLOSE FIND_DELEGATION_FLAG;
870:
871: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
872: p_message => l_procedure_name
873: );
874:
875:

Line 917: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

913: l_procedure_name CONSTANT varchar2(30) := 'get_checkbox_status_reg';
914:
915: BEGIN
916:
917: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
918: p_message => l_procedure_name
919: );
920:
921:

Line 931: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,

927: p_usertype_id => p_usertype_id,
928: x_result => x_result
929: );
930:
931: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
932: p_message => l_procedure_name
933: );
934:
935: END get_checkbox_status_reg;

Line 980: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

976:
977: BEGIN
978:
979:
980: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
981: p_message => l_procedure_name
982: );
983:
984:

Line 1000: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,

996: p_usertype_id => p_usertype_id,
997: x_result => x_checkbox_code
998: );
999:
1000: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
1001: p_message => l_procedure_name
1002: );
1003:
1004:

Line 1051: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

1047: l_approval_required boolean;
1048:
1049: BEGIN
1050:
1051: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1052: p_message => l_procedure_name
1053: );
1054:
1055: if ( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then

Line 1055: if ( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then

1051: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1052: p_message => l_procedure_name
1053: );
1054:
1055: if ( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then
1056: /* Bug #3468334 changed -- */
1057: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
1058: p_message => 'p_subscription_id:'|| p_subscription_id || '+' || 'p_approval_id:' || p_approval_id
1059: || '+' || 'p_activation_mode:' || p_activation_mode || '+' || 'p_is_admin:' || p_is_admin || '+' || 'p_can_assign:' || p_can_assign

Line 1057: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

1053: );
1054:
1055: if ( JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME) ) then
1056: /* Bug #3468334 changed -- */
1057: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
1058: p_message => 'p_subscription_id:'|| p_subscription_id || '+' || 'p_approval_id:' || p_approval_id
1059: || '+' || 'p_activation_mode:' || p_activation_mode || '+' || 'p_is_admin:' || p_is_admin || '+' || 'p_can_assign:' || p_can_assign
1060: );
1061: end if;

Line 1104: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,

1100: END IF;
1101:
1102: END IF;
1103:
1104: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
1105: p_message => l_procedure_name
1106: );
1107:
1108: IF l_approval_required THEN