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

Line 33: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

29: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
30: fnd_message.set_token('ROUTINE', routine);
31: fnd_message.set_token('ERRNO', errcode);
32: fnd_message.set_token('REASON', errmsg);
33: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
34: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, routine, FALSE);
35: END IF;
36: fnd_message.raise_error;
37: END;

Line 34: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, routine, FALSE);

30: fnd_message.set_token('ROUTINE', routine);
31: fnd_message.set_token('ERRNO', errcode);
32: fnd_message.set_token('REASON', errmsg);
33: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
34: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, routine, FALSE);
35: END IF;
36: fnd_message.raise_error;
37: END;
38:

Line 132: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

128: l_del_org_id hr_operating_units.organization_id%TYPE;
129:
130: BEGIN
131:
132: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
133: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
134: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.begin',
135: 'Calling PL/SQL procedure '||
136: 'MO_GLOBAL.POPULATE_ORGS');

Line 133: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

129:
130: BEGIN
131:
132: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
133: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
134: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.begin',
135: 'Calling PL/SQL procedure '||
136: 'MO_GLOBAL.POPULATE_ORGS');
137: END IF;

Line 144: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

140: -- Initialize the count of the accessible operating units.
141: --
142: g_ou_count := 0;
143:
144: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
145: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
146: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.input_parameters',
147: 'p_org_id='||p_org_id_char||
148: ', p_sp_id='||p_sp_id_char);

Line 145: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

141: --
142: g_ou_count := 0;
143:
144: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
145: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
146: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.input_parameters',
147: 'p_org_id='||p_org_id_char||
148: ', p_sp_id='||p_sp_id_char);
149: END IF;

Line 171: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

167: , p_view_all_org
168: FROM per_security_profiles
169: WHERE security_profile_id = to_number(p_sp_id_char);
170:
171: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
172: FND_LOG.STRING(
173: FND_LOG.LEVEL_EVENT,
174: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.config',
175: 'per_security_profiles.security_profile_name=>'||l_sp_name||

Line 172: FND_LOG.STRING(

168: FROM per_security_profiles
169: WHERE security_profile_id = to_number(p_sp_id_char);
170:
171: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
172: FND_LOG.STRING(
173: FND_LOG.LEVEL_EVENT,
174: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.config',
175: 'per_security_profiles.security_profile_name=>'||l_sp_name||
176: ', per_security_profiles.business_group_id=>'||l_bg_id||

Line 173: FND_LOG.LEVEL_EVENT,

169: WHERE security_profile_id = to_number(p_sp_id_char);
170:
171: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
172: FND_LOG.STRING(
173: FND_LOG.LEVEL_EVENT,
174: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.config',
175: 'per_security_profiles.security_profile_name=>'||l_sp_name||
176: ', per_security_profiles.business_group_id=>'||l_bg_id||
177: ', per_security_profiles.view_all_organizations_flag=>'||is_view_all_org);

Line 184: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

180: IF (p_view_all_org = 'Y') THEN
181: IF (l_bg_id IS NOT NULL) THEN
182:
183: -- View all Within the Business Group Case
184: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
185: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
186: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.retrieve_orgs_c3_cursor',
187: 'Retrieving operating units using cursor c3 with arguments:'||
188: ' l_sp_name='||l_sp_name||

Line 185: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

181: IF (l_bg_id IS NOT NULL) THEN
182:
183: -- View all Within the Business Group Case
184: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
185: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
186: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.retrieve_orgs_c3_cursor',
187: 'Retrieving operating units using cursor c3 with arguments:'||
188: ' l_sp_name='||l_sp_name||
189: ', l_bg_id='||l_bg_id);

Line 204: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

200:
201: ELSE
202:
203: -- Global View all Case
204: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
205: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
206: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.retrieve_orgs_c4_cursor',
207: 'Retrieving operating units using cursor c4');
208: END IF;

Line 205: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

201: ELSE
202:
203: -- Global View all Case
204: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
205: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
206: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.retrieve_orgs_c4_cursor',
207: 'Retrieving operating units using cursor c4');
208: END IF;
209:

Line 224: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

220:
221: ELSE
222:
223: -- Security Profile based on list or hierarchy Case
224: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
225: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
226: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.retrieve_orgs_c1_cursor',
227: 'Retrieving operating units using cursor c1');
228: END IF;

Line 225: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

221: ELSE
222:
223: -- Security Profile based on list or hierarchy Case
224: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
225: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
226: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.retrieve_orgs_c1_cursor',
227: 'Retrieving operating units using cursor c1');
228: END IF;
229:

Line 246: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

242: -- SP ID is NULL and ORG ID is NOT NULL
243: --
244: ELSE
245: IF (p_org_id_char is NOT NULL) THEN
246: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
247: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
248: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.retrieve_orgs_c2_cursor',
249: 'Retrieving operating units using cursor c2');
250: END IF;

Line 247: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

243: --
244: ELSE
245: IF (p_org_id_char is NOT NULL) THEN
246: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
247: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
248: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.retrieve_orgs_c2_cursor',
249: 'Retrieving operating units using cursor c2');
250: END IF;
251:

Line 432: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

428: IF g_ou_count = 1 THEN
429: p_current_org_id := t_org_id(1);
430: END IF;
431:
432: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
433: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
434: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.temp_table_insert',
435: 'Inserted '||g_ou_count||' record(s) into MO_GLOB_ORG_ACCESS_TMP');
436: END IF;

Line 433: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

429: p_current_org_id := t_org_id(1);
430: END IF;
431:
432: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
433: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
434: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.temp_table_insert',
435: 'Inserted '||g_ou_count||' record(s) into MO_GLOB_ORG_ACCESS_TMP');
436: END IF;
437:

Line 438: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

434: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.temp_table_insert',
435: 'Inserted '||g_ou_count||' record(s) into MO_GLOB_ORG_ACCESS_TMP');
436: END IF;
437:
438: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
440: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.end',
441: 'Returning from PL/SQL procedure '||
442: 'MO_GLOBAL.POPULATE_ORGS: '||

Line 439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

435: 'Inserted '||g_ou_count||' record(s) into MO_GLOB_ORG_ACCESS_TMP');
436: END IF;
437:
438: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
440: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.end',
441: 'Returning from PL/SQL procedure '||
442: 'MO_GLOBAL.POPULATE_ORGS: '||
443: 'l_bg_id='||l_bg_id||

Line 452: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

448: END IF;
449:
450: EXCEPTION
451: WHEN OTHERS THEN
452: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
453: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
454: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.temp_table',
455: 'temporary table other exception raised sqlerrm'||
456: '=>'||sqlerrm);

Line 453: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

449:
450: EXCEPTION
451: WHEN OTHERS THEN
452: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
453: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
454: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.temp_table',
455: 'temporary table other exception raised sqlerrm'||
456: '=>'||sqlerrm);
457: END IF;

Line 476: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

472: -- since the repopulation fails because of the unique constraint
473: -- violation.
474: --
475:
476: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
477: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
478: 'fnd.plsql.MO_GLOBAL.DELETE_ORGS.begin',
479: 'Before flushing MO_GLOB_ORG_ACCESS_TMP');
480: END IF;

Line 477: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

473: -- violation.
474: --
475:
476: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
477: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
478: 'fnd.plsql.MO_GLOBAL.DELETE_ORGS.begin',
479: 'Before flushing MO_GLOB_ORG_ACCESS_TMP');
480: END IF;
481:

Line 494: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

490: else
491: DELETE FROM mo_glob_org_access_tmp;
492: end if;
493:
494: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
495: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
496: 'fnd.plsql.MO_GLOBAL.DELETE_ORGS.end',
497: 'MO_GLOB_ORG_ACCESS_TMP was flushed');
498: END IF;

Line 495: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

491: DELETE FROM mo_glob_org_access_tmp;
492: end if;
493:
494: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
495: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
496: 'fnd.plsql.MO_GLOBAL.DELETE_ORGS.end',
497: 'MO_GLOB_ORG_ACCESS_TMP was flushed');
498: END IF;
499:

Line 588: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

584: NO_ORG_ACCESS_FOUND EXCEPTION;
585: NO_APPL_NAME EXCEPTION;
586:
587: BEGIN
588: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
589: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
590: 'fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.begin',
591: 'Calling PL/SQL procedure MO_GLOBAL.SET_ORG_ACCESS:'||
592: ' p_org_id_char=>'||p_org_id_char||

Line 589: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

585: NO_APPL_NAME EXCEPTION;
586:
587: BEGIN
588: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
589: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
590: 'fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.begin',
591: 'Calling PL/SQL procedure MO_GLOBAL.SET_ORG_ACCESS:'||
592: ' p_org_id_char=>'||p_org_id_char||
593: ', p_sp_id_char=>'||p_sp_id_char||

Line 622: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

618: WHEN OTHERS THEN
619: generic_error('MO_GLOBAL.SET_ORG_ACCESS', sqlcode, sqlerrm);
620: END;
621:
622: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
623: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
624: 'fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.access_status',
625: 'Checking access status within PL/SQL procedure '||
626: 'MO_GLOBAL.SET_ORG_ACCESS: '||

Line 623: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

619: generic_error('MO_GLOBAL.SET_ORG_ACCESS', sqlcode, sqlerrm);
620: END;
621:
622: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
623: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
624: 'fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.access_status',
625: 'Checking access status within PL/SQL procedure '||
626: 'MO_GLOBAL.SET_ORG_ACCESS: '||
627: 'l_access_ctrl_enabled=>'||l_access_ctrl_enabled);

Line 634: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

630: --
631: -- Delete temporary table data first for all products access enabled or not
632: --
633: delete_orgs;
634: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
635: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
636: 'fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.after_delete',
637: 'Returning from PL/SQL procedure '||
638: 'MO_GLOBAL.DELETE_ORGS ');

Line 635: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

631: -- Delete temporary table data first for all products access enabled or not
632: --
633: delete_orgs;
634: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
635: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
636: 'fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.after_delete',
637: 'Returning from PL/SQL procedure '||
638: 'MO_GLOBAL.DELETE_ORGS ');
639: END IF;

Line 656: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

652: populate_orgs(l_org_id,
653: l_security_profile_id,
654: l_current_org_id,
655: l_view_all_orgs);
656: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
657: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
658: 'fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.After_Populate',
659: 'Returning from PL/SQL procedure '||
660: 'MO_GLOBAL.POPULATE_ORGS ');

Line 657: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

653: l_security_profile_id,
654: l_current_org_id,
655: l_view_all_orgs);
656: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
657: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
658: 'fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.After_Populate',
659: 'Returning from PL/SQL procedure '||
660: 'MO_GLOBAL.POPULATE_ORGS ');
661: END IF;

Line 696: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

692: END IF;
693: END IF;
694:
695: commit;
696: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
697: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
698: 'fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.end',
699: 'Calling PL/SQL procedure MO_GLOBAL.SET_ORG_ACCESS:'||
700: ' p_org_id_char=>'||p_org_id_char||

Line 697: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

693: END IF;
694:
695: commit;
696: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
697: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
698: 'fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.end',
699: 'Calling PL/SQL procedure MO_GLOBAL.SET_ORG_ACCESS:'||
700: ' p_org_id_char=>'||p_org_id_char||
701: ',p_sp_id_char=>'||p_sp_id_char||

Line 808: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

804: BEGIN
805: --
806: -- Check if multi-org is enabled
807: --
808: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
809: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
810: 'fnd.plsql.MO_GLOBAL.INIT.begin',
811: 'Calling PL/SQL procedure MO_GLOBAL.INIT');
812: END IF;

Line 809: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

805: --
806: -- Check if multi-org is enabled
807: --
808: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
809: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
810: 'fnd.plsql.MO_GLOBAL.INIT.begin',
811: 'Calling PL/SQL procedure MO_GLOBAL.INIT');
812: END IF;
813: IF is_multi_org_enabled = 'Y' THEN

Line 820: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

816: --
817: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL', l_security_profile_id);
818: fnd_profile.get('ORG_ID', l_org_id);
819:
820: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
821: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
822: 'fnd.plsql.MO_GLOBAL.INIT.config',
823: 'MO: Operating Unit=>'||l_org_id||
824: ', MO: Security Profile=>'||l_security_profile_id||

Line 821: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

817: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL', l_security_profile_id);
818: fnd_profile.get('ORG_ID', l_org_id);
819:
820: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
821: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
822: 'fnd.plsql.MO_GLOBAL.INIT.config',
823: 'MO: Operating Unit=>'||l_org_id||
824: ', MO: Security Profile=>'||l_security_profile_id||
825: ', p_appl_short_name=>'||p_appl_short_name);

Line 845: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

841: g_old_org_id:=l_org_id;
842: END IF;
843:
844: END IF; -- multi org is enabled
845: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
846: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
847: 'fnd.plsql.MO_GLOBAL.INIT.end',
848: 'Exiting PL/SQL procedure MO_GLOBAL.INIT');
849: END IF;

Line 846: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

842: END IF;
843:
844: END IF; -- multi org is enabled
845: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
846: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
847: 'fnd.plsql.MO_GLOBAL.INIT.end',
848: 'Exiting PL/SQL procedure MO_GLOBAL.INIT');
849: END IF;
850: EXCEPTION

Line 958: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

954:
955: l_ci_debug fnd_profile_option_values.profile_option_value%TYPE := NULL;
956:
957: BEGIN
958: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
959: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
960: 'fnd.plsql.MO_GLOBAL.INIT.config',
961: 'MO: Operating Unit=>'||p_org_id_char||
962: ',MO: Security Profile=>'||p_sp_id_char||

Line 959: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

955: l_ci_debug fnd_profile_option_values.profile_option_value%TYPE := NULL;
956:
957: BEGIN
958: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
959: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
960: 'fnd.plsql.MO_GLOBAL.INIT.config',
961: 'MO: Operating Unit=>'||p_org_id_char||
962: ',MO: Security Profile=>'||p_sp_id_char||
963: ',p_appl_short_name=>'||p_appl_short_name);

Line 975: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

971:
972: -- Set up the organization access list for Multi- Org Access Control
973: set_org_access(p_org_id_char,p_sp_id_char, p_appl_short_name);
974:
975: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
976: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
977: 'fnd.plsql.MO_GLOBAL.SET_ORG_CONTEXT.end',
978: 'Returning from PL/SQL procedure MO_GLOBAL.SET_ORG_CONTEXT');
979: END IF;

Line 976: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

972: -- Set up the organization access list for Multi- Org Access Control
973: set_org_access(p_org_id_char,p_sp_id_char, p_appl_short_name);
974:
975: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
976: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
977: 'fnd.plsql.MO_GLOBAL.SET_ORG_CONTEXT.end',
978: 'Returning from PL/SQL procedure MO_GLOBAL.SET_ORG_CONTEXT');
979: END IF;
980:

Line 1147: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1143: p_org_id NUMBER)
1144: IS
1145:
1146: BEGIN
1147: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1149: 'fnd.plsql.MO_GLOBAL.SET_POLICY_CONTEXT.begin',
1150: 'Calling PL/SQL procedure MO_GLOBAL.SET_POLICY_CONTEXT:'||
1151: ' p_access_mode=>'||p_access_mode||

Line 1148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1144: IS
1145:
1146: BEGIN
1147: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1149: 'fnd.plsql.MO_GLOBAL.SET_POLICY_CONTEXT.begin',
1150: 'Calling PL/SQL procedure MO_GLOBAL.SET_POLICY_CONTEXT:'||
1151: ' p_access_mode=>'||p_access_mode||
1152: ',p_org_id=>'||p_org_id);

Line 1258: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1254: --
1255: g_old_user_id:=sys_context('FND','USER_ID');
1256: g_old_resp_id:=sys_context('FND','RESP_ID');
1257:
1258: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1260: 'fnd.plsql.MO_GLOBAL.SET_POLICY_CONTEXT.end',
1261: 'Returning from PL/SQL prcedure MO_GLOBAL.SET_POLICY_CONTEXT');
1262: END IF;

Line 1259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1255: g_old_user_id:=sys_context('FND','USER_ID');
1256: g_old_resp_id:=sys_context('FND','RESP_ID');
1257:
1258: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1260: 'fnd.plsql.MO_GLOBAL.SET_POLICY_CONTEXT.end',
1261: 'Returning from PL/SQL prcedure MO_GLOBAL.SET_POLICY_CONTEXT');
1262: END IF;
1263:

Line 1340: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1336: BEGIN
1337: --
1338: -- Debug information
1339: --
1340: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1341: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1342: 'fnd.plsql.MO_GLOBAL.GET_VALID_ORG.begin',
1343: 'Calling PL/SQL function '||
1344: 'MO_GLOBAL.GET_VALID_ORG'||

Line 1341: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1337: --
1338: -- Debug information
1339: --
1340: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1341: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1342: 'fnd.plsql.MO_GLOBAL.GET_VALID_ORG.begin',
1343: 'Calling PL/SQL function '||
1344: 'MO_GLOBAL.GET_VALID_ORG'||
1345: ' p_org_id=>'||p_org_id);

Line 1382: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1378: IF (l_status = 'N') THEN
1379: --
1380: -- Debug information
1381: --
1382: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1383: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1384: 'fnd.plsql.MO_GLOBAL.GET_VALID_ORG.end',
1385: 'Returning from PL/SQL function '||
1386: 'MO_GLOBAL.GET_VALID_ORG:'||

Line 1383: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1379: --
1380: -- Debug information
1381: --
1382: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1383: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1384: 'fnd.plsql.MO_GLOBAL.GET_VALID_ORG.end',
1385: 'Returning from PL/SQL function '||
1386: 'MO_GLOBAL.GET_VALID_ORG:'||
1387: ' Returns NULL');

Line 1399: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1395: ELSE
1396: --
1397: -- Debug information
1398: --
1399: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1400: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1401: 'fnd.plsql.MO_GLOBAL.GET_VALID_ORG.end',
1402: 'Returning from PL/SQL function '||
1403: 'MO_GLOBAL.GET_VALID_ORG:'||

Line 1400: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1396: --
1397: -- Debug information
1398: --
1399: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1400: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1401: 'fnd.plsql.MO_GLOBAL.GET_VALID_ORG.end',
1402: 'Returning from PL/SQL function '||
1403: 'MO_GLOBAL.GET_VALID_ORG:'||
1404: ' Returns '||l_org_id);

Line 1601: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1597: END IF;
1598: ELSE
1599: return 'N';
1600:
1601: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1602: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1603: 'fnd.plsql.MO_GLOBAL.is_mo_init_done.begin',
1604: 'g_ou_count=>'||g_ou_count||
1605: ', g_access_mode=>'||g_access_mode||

Line 1602: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1598: ELSE
1599: return 'N';
1600:
1601: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1602: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1603: 'fnd.plsql.MO_GLOBAL.is_mo_init_done.begin',
1604: 'g_ou_count=>'||g_ou_count||
1605: ', g_access_mode=>'||g_access_mode||
1606: ', g_current_org_id=>'||g_current_org_id||

Line 1710: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1706: IS
1707:
1708: BEGIN
1709:
1710: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1711: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1712: 'fnd.plsql.MO_GLOBAL.SET_POLICY_CONTEXT_SERVER.begin',
1713: 'Calling PL/SQL procedure MO_GLOBAL.SET_POLICY_CONTEXT_SERVER:'||
1714: ' p_access_mode=>'||p_access_mode||

Line 1711: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1707:
1708: BEGIN
1709:
1710: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1711: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1712: 'fnd.plsql.MO_GLOBAL.SET_POLICY_CONTEXT_SERVER.begin',
1713: 'Calling PL/SQL procedure MO_GLOBAL.SET_POLICY_CONTEXT_SERVER:'||
1714: ' p_access_mode=>'||p_access_mode||
1715: ',p_org_id=>'||p_org_id);