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_GR_GEN_001 dependencies on FND_LOG

Line 21: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

17: p_message_name OUT NOCOPY VARCHAR2
18: ) RETURN BOOLEAN AS
19: BEGIN -- grdp_del_gac_hist
20: --
21: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
22: fnd_log.string (
23: fnd_log.level_procedure, g_module_head || 'grdp_del_gac_hist.begin',
24: 'In Params: p_person_id=>' || p_person_id || ';' ||
25: 'p_create_dt=>' || p_create_dt || ';' ||

Line 22: fnd_log.string (

18: ) RETURN BOOLEAN AS
19: BEGIN -- grdp_del_gac_hist
20: --
21: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
22: fnd_log.string (
23: fnd_log.level_procedure, g_module_head || 'grdp_del_gac_hist.begin',
24: 'In Params: p_person_id=>' || p_person_id || ';' ||
25: 'p_create_dt=>' || p_create_dt || ';' ||
26: 'p_grd_cal_type=>' || p_grd_cal_type || ';' ||

Line 23: fnd_log.level_procedure, g_module_head || 'grdp_del_gac_hist.begin',

19: BEGIN -- grdp_del_gac_hist
20: --
21: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
22: fnd_log.string (
23: fnd_log.level_procedure, g_module_head || 'grdp_del_gac_hist.begin',
24: 'In Params: p_person_id=>' || p_person_id || ';' ||
25: 'p_create_dt=>' || p_create_dt || ';' ||
26: 'p_grd_cal_type=>' || p_grd_cal_type || ';' ||
27: 'p_grd_ci_sequence_number=>' || p_grd_ci_sequence_number || ';' ||

Line 79: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

75: PRAGMA EXCEPTION_INIT (e_resource_busy_exception, -54);
76: --
77: BEGIN -- grdpl_del_if_not_locked
78: --
79: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
80: fnd_log.string (
81: fnd_log.level_procedure, g_module_head || 'grdpl_del_if_not_locked.begin',
82: 'In Params: pl_person_id=>' || pl_person_id || ';' ||
83: 'pl_create_dt=>' || pl_create_dt || ';' ||

Line 80: fnd_log.string (

76: --
77: BEGIN -- grdpl_del_if_not_locked
78: --
79: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
80: fnd_log.string (
81: fnd_log.level_procedure, g_module_head || 'grdpl_del_if_not_locked.begin',
82: 'In Params: pl_person_id=>' || pl_person_id || ';' ||
83: 'pl_create_dt=>' || pl_create_dt || ';' ||
84: 'pl_grd_cal_type=>' || pl_grd_cal_type || ';' ||

Line 81: fnd_log.level_procedure, g_module_head || 'grdpl_del_if_not_locked.begin',

77: BEGIN -- grdpl_del_if_not_locked
78: --
79: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
80: fnd_log.string (
81: fnd_log.level_procedure, g_module_head || 'grdpl_del_if_not_locked.begin',
82: 'In Params: pl_person_id=>' || pl_person_id || ';' ||
83: 'pl_create_dt=>' || pl_create_dt || ';' ||
84: 'pl_grd_cal_type=>' || pl_grd_cal_type || ';' ||
85: 'pl_grd_ci_sequence_number=>' || pl_grd_ci_sequence_number || ';' ||

Line 137: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

133: EXCEPTION
134: WHEN e_resource_busy_exception THEN
135: RETURN FALSE;
136: WHEN OTHERS THEN
137: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
138: fnd_log.string (
139: fnd_log.level_exception, g_module_head || 'grdpl_del_if_not_locked.e_resource_busy_exception',
140: 'Error: ' || SQLERRM
141: );

Line 138: fnd_log.string (

134: WHEN e_resource_busy_exception THEN
135: RETURN FALSE;
136: WHEN OTHERS THEN
137: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
138: fnd_log.string (
139: fnd_log.level_exception, g_module_head || 'grdpl_del_if_not_locked.e_resource_busy_exception',
140: 'Error: ' || SQLERRM
141: );
142: END IF;

Line 139: fnd_log.level_exception, g_module_head || 'grdpl_del_if_not_locked.e_resource_busy_exception',

135: RETURN FALSE;
136: WHEN OTHERS THEN
137: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
138: fnd_log.string (
139: fnd_log.level_exception, g_module_head || 'grdpl_del_if_not_locked.e_resource_busy_exception',
140: 'Error: ' || SQLERRM
141: );
142: END IF;
143: app_exception.raise_exception;

Line 184: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

180: --
181: END;
182: EXCEPTION
183: WHEN OTHERS THEN
184: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
185: fnd_log.string (
186: fnd_log.level_exception, g_module_head || 'grdp_del_gac_hist.exit_exception',
187: 'Error: ' || SQLERRM
188: );

Line 185: fnd_log.string (

181: END;
182: EXCEPTION
183: WHEN OTHERS THEN
184: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
185: fnd_log.string (
186: fnd_log.level_exception, g_module_head || 'grdp_del_gac_hist.exit_exception',
187: 'Error: ' || SQLERRM
188: );
189: END IF;

Line 186: fnd_log.level_exception, g_module_head || 'grdp_del_gac_hist.exit_exception',

182: EXCEPTION
183: WHEN OTHERS THEN
184: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
185: fnd_log.string (
186: fnd_log.level_exception, g_module_head || 'grdp_del_gac_hist.exit_exception',
187: 'Error: ' || SQLERRM
188: );
189: END IF;
190: app_exception.raise_exception;

Line 211: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

207: BEGIN -- grdp_del_gr_gac
208:
209: IGS_GE_GEN_003.SET_ORG_ID(); -- swaghmar, bug# 4951054
210: --
211: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
212: fnd_log.string (
213: fnd_log.level_procedure, g_module_head || 'grdp_del_gr_gac.begin',
214: 'In Params: p_grd_period=>' || p_grd_period || ';' ||
215: 'p_org_id=>' || p_org_id || ';'

Line 212: fnd_log.string (

208:
209: IGS_GE_GEN_003.SET_ORG_ID(); -- swaghmar, bug# 4951054
210: --
211: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
212: fnd_log.string (
213: fnd_log.level_procedure, g_module_head || 'grdp_del_gr_gac.begin',
214: 'In Params: p_grd_period=>' || p_grd_period || ';' ||
215: 'p_org_id=>' || p_org_id || ';'
216: );

Line 213: fnd_log.level_procedure, g_module_head || 'grdp_del_gr_gac.begin',

209: IGS_GE_GEN_003.SET_ORG_ID(); -- swaghmar, bug# 4951054
210: --
211: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
212: fnd_log.string (
213: fnd_log.level_procedure, g_module_head || 'grdp_del_gr_gac.begin',
214: 'In Params: p_grd_period=>' || p_grd_period || ';' ||
215: 'p_org_id=>' || p_org_id || ';'
216: );
217: END IF;

Line 310: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

306: --
307: v_person_id := v_gr_rec.person_id;
308: v_create_dt := v_gr_rec.create_dt;
309: --
310: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
311: fnd_log.string (
312: fnd_log.level_statement, g_module_head || 'grdp_del_gr_gac.c_gr_values',
313: 'person_id=>' || v_gr_rec.person_id || ';' ||
314: 'create_dt=>' || v_gr_rec.create_dt || ';'

Line 311: fnd_log.string (

307: v_person_id := v_gr_rec.person_id;
308: v_create_dt := v_gr_rec.create_dt;
309: --
310: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
311: fnd_log.string (
312: fnd_log.level_statement, g_module_head || 'grdp_del_gr_gac.c_gr_values',
313: 'person_id=>' || v_gr_rec.person_id || ';' ||
314: 'create_dt=>' || v_gr_rec.create_dt || ';'
315: );

Line 312: fnd_log.level_statement, g_module_head || 'grdp_del_gr_gac.c_gr_values',

308: v_create_dt := v_gr_rec.create_dt;
309: --
310: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
311: fnd_log.string (
312: fnd_log.level_statement, g_module_head || 'grdp_del_gr_gac.c_gr_values',
313: 'person_id=>' || v_gr_rec.person_id || ';' ||
314: 'create_dt=>' || v_gr_rec.create_dt || ';'
315: );
316: END IF;

Line 389: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

385: END;
386: --
387: EXCEPTION
388: WHEN OTHERS THEN
389: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
390: fnd_log.string (
391: fnd_log.level_exception, g_module_head || 'grdp_del_gr_gac.exit_exception',
392: 'Error: ' || SQLERRM
393: );

Line 390: fnd_log.string (

386: --
387: EXCEPTION
388: WHEN OTHERS THEN
389: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
390: fnd_log.string (
391: fnd_log.level_exception, g_module_head || 'grdp_del_gr_gac.exit_exception',
392: 'Error: ' || SQLERRM
393: );
394: END IF;

Line 391: fnd_log.level_exception, g_module_head || 'grdp_del_gr_gac.exit_exception',

387: EXCEPTION
388: WHEN OTHERS THEN
389: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
390: fnd_log.string (
391: fnd_log.level_exception, g_module_head || 'grdp_del_gr_gac.exit_exception',
392: 'Error: ' || SQLERRM
393: );
394: END IF;
395: app_exception.raise_exception;

Line 488: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

484: FUNCTION grdp_get_grad_name (p_person_id IN NUMBER)
485: RETURN VARCHAR2 AS
486: BEGIN
487: --
488: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
489: fnd_log.string (
490: fnd_log.level_procedure, g_module_head || 'grdp_get_grad_name.begin',
491: 'In Params: p_person_id=>' || p_person_id || ';'
492: );

Line 489: fnd_log.string (

485: RETURN VARCHAR2 AS
486: BEGIN
487: --
488: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
489: fnd_log.string (
490: fnd_log.level_procedure, g_module_head || 'grdp_get_grad_name.begin',
491: 'In Params: p_person_id=>' || p_person_id || ';'
492: );
493: END IF;

Line 490: fnd_log.level_procedure, g_module_head || 'grdp_get_grad_name.begin',

486: BEGIN
487: --
488: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
489: fnd_log.string (
490: fnd_log.level_procedure, g_module_head || 'grdp_get_grad_name.begin',
491: 'In Params: p_person_id=>' || p_person_id || ';'
492: );
493: END IF;
494: --

Line 519: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

515: RETURN VARCHAR2 AS
516: name_start VARCHAR2 (4);
517: BEGIN
518: --
519: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
520: fnd_log.string (
521: fnd_log.level_procedure, g_module_head || 'grdpl_surname_initcap.begin',
522: 'In Params: surname=>' || surname || ';'
523: );

Line 520: fnd_log.string (

516: name_start VARCHAR2 (4);
517: BEGIN
518: --
519: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
520: fnd_log.string (
521: fnd_log.level_procedure, g_module_head || 'grdpl_surname_initcap.begin',
522: 'In Params: surname=>' || surname || ';'
523: );
524: END IF;

Line 521: fnd_log.level_procedure, g_module_head || 'grdpl_surname_initcap.begin',

517: BEGIN
518: --
519: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
520: fnd_log.string (
521: fnd_log.level_procedure, g_module_head || 'grdpl_surname_initcap.begin',
522: 'In Params: surname=>' || surname || ';'
523: );
524: END IF;
525: --

Line 598: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

594: END;
595: --
596: EXCEPTION
597: WHEN OTHERS THEN
598: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
599: fnd_log.string (
600: fnd_log.level_exception, g_module_head || 'grdp_get_grad_name.exit_exception',
601: 'Error: ' || SQLERRM
602: );

Line 599: fnd_log.string (

595: --
596: EXCEPTION
597: WHEN OTHERS THEN
598: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
599: fnd_log.string (
600: fnd_log.level_exception, g_module_head || 'grdp_get_grad_name.exit_exception',
601: 'Error: ' || SQLERRM
602: );
603: END IF;

Line 600: fnd_log.level_exception, g_module_head || 'grdp_get_grad_name.exit_exception',

596: EXCEPTION
597: WHEN OTHERS THEN
598: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
599: fnd_log.string (
600: fnd_log.level_exception, g_module_head || 'grdp_get_grad_name.exit_exception',
601: 'Error: ' || SQLERRM
602: );
603: END IF;
604: app_exception.raise_exception;

Line 613: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

609: FUNCTION grdp_get_gr_ghl (p_person_id IN NUMBER, p_course_cd IN VARCHAR2)
610: RETURN VARCHAR2 AS
611: BEGIN -- grdp_get_gr_ghl
612: --
613: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
614: fnd_log.string (
615: fnd_log.level_procedure, g_module_head || 'grdp_get_gr_ghl.begin',
616: 'In Params: p_person_id=>' || p_person_id || ';' ||
617: 'p_course_cd=>' || p_course_cd || ';'

Line 614: fnd_log.string (

610: RETURN VARCHAR2 AS
611: BEGIN -- grdp_get_gr_ghl
612: --
613: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
614: fnd_log.string (
615: fnd_log.level_procedure, g_module_head || 'grdp_get_gr_ghl.begin',
616: 'In Params: p_person_id=>' || p_person_id || ';' ||
617: 'p_course_cd=>' || p_course_cd || ';'
618: );

Line 615: fnd_log.level_procedure, g_module_head || 'grdp_get_gr_ghl.begin',

611: BEGIN -- grdp_get_gr_ghl
612: --
613: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
614: fnd_log.string (
615: fnd_log.level_procedure, g_module_head || 'grdp_get_gr_ghl.begin',
616: 'In Params: p_person_id=>' || p_person_id || ';' ||
617: 'p_course_cd=>' || p_course_cd || ';'
618: );
619: END IF;

Line 667: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

663: END;
664: --
665: EXCEPTION
666: WHEN OTHERS THEN
667: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
668: fnd_log.string (
669: fnd_log.level_exception, g_module_head || 'grdp_get_gr_ghl.exit_exception',
670: 'Error: ' || SQLERRM
671: );

Line 668: fnd_log.string (

664: --
665: EXCEPTION
666: WHEN OTHERS THEN
667: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
668: fnd_log.string (
669: fnd_log.level_exception, g_module_head || 'grdp_get_gr_ghl.exit_exception',
670: 'Error: ' || SQLERRM
671: );
672: END IF;

Line 669: fnd_log.level_exception, g_module_head || 'grdp_get_gr_ghl.exit_exception',

665: EXCEPTION
666: WHEN OTHERS THEN
667: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
668: fnd_log.string (
669: fnd_log.level_exception, g_module_head || 'grdp_get_gr_ghl.exit_exception',
670: 'Error: ' || SQLERRM
671: );
672: END IF;
673: app_exception.raise_exception;

Line 722: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

718: p_new_comments igs_gr_awd_crmn.comments%TYPE
719: ) AS
720: BEGIN -- grdp_ins_gr_hist
721: --
722: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
723: fnd_log.string (
724: fnd_log.level_procedure, g_module_head || 'grdp_ins_gac_hist.begin',
725: 'In Params: p_person_id=>' || p_person_id || ';' ||
726: 'p_create_dt=>' || p_create_dt || ';' ||

Line 723: fnd_log.string (

719: ) AS
720: BEGIN -- grdp_ins_gr_hist
721: --
722: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
723: fnd_log.string (
724: fnd_log.level_procedure, g_module_head || 'grdp_ins_gac_hist.begin',
725: 'In Params: p_person_id=>' || p_person_id || ';' ||
726: 'p_create_dt=>' || p_create_dt || ';' ||
727: 'p_grd_cal_type=>' || p_grd_cal_type || ';' ||

Line 724: fnd_log.level_procedure, g_module_head || 'grdp_ins_gac_hist.begin',

720: BEGIN -- grdp_ins_gr_hist
721: --
722: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
723: fnd_log.string (
724: fnd_log.level_procedure, g_module_head || 'grdp_ins_gac_hist.begin',
725: 'In Params: p_person_id=>' || p_person_id || ';' ||
726: 'p_create_dt=>' || p_create_dt || ';' ||
727: 'p_grd_cal_type=>' || p_grd_cal_type || ';' ||
728: 'p_grd_ci_sequence_number=>' || p_grd_ci_sequence_number || ';' ||

Line 913: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

909: END;
910: --
911: EXCEPTION
912: WHEN OTHERS THEN
913: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
914: fnd_log.string (
915: fnd_log.level_exception, g_module_head || 'grdp_ins_gac_hist.exit_exception',
916: 'Error: ' || SQLERRM
917: );

Line 914: fnd_log.string (

910: --
911: EXCEPTION
912: WHEN OTHERS THEN
913: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
914: fnd_log.string (
915: fnd_log.level_exception, g_module_head || 'grdp_ins_gac_hist.exit_exception',
916: 'Error: ' || SQLERRM
917: );
918: END IF;

Line 915: fnd_log.level_exception, g_module_head || 'grdp_ins_gac_hist.exit_exception',

911: EXCEPTION
912: WHEN OTHERS THEN
913: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
914: fnd_log.string (
915: fnd_log.level_exception, g_module_head || 'grdp_ins_gac_hist.exit_exception',
916: 'Error: ' || SQLERRM
917: );
918: END IF;
919: app_exception.raise_exception;