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 128: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

124: AND RESP_ID = FND_GLOBAL.RESP_ID;
125:
126: BEGIN
127:
128: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
129: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
130: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.begin',
131: 'Calling PL/SQL procedure '||
132: 'MO_GLOBAL.POPULATE_ORGS');

Line 129: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 141: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 168: FND_LOG.STRING(

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

Line 169: FND_LOG.LEVEL_EVENT,

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

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

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

Line 181: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

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

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

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

Line 201: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

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

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

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

Line 221: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

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

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

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

Line 243: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

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

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

365: IF g_ou_count = 1 THEN
366: p_current_org_id := t_org_id(1);
367: END IF;
368:
369: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
370: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
371: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.temp_table_insert',
372: 'Inserted '||g_ou_count||' record(s) into MO_GLOB_ORG_ACCESS_TMP');
373: END IF;

Line 370: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

366: p_current_org_id := t_org_id(1);
367: END IF;
368:
369: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
370: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
371: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.temp_table_insert',
372: 'Inserted '||g_ou_count||' record(s) into MO_GLOB_ORG_ACCESS_TMP');
373: END IF;
374:

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

371: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.temp_table_insert',
372: 'Inserted '||g_ou_count||' record(s) into MO_GLOB_ORG_ACCESS_TMP');
373: END IF;
374:
375: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
376: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
377: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.end',
378: 'Returning from PL/SQL procedure '||
379: 'MO_GLOBAL.POPULATE_ORGS: '||

Line 376: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

372: 'Inserted '||g_ou_count||' record(s) into MO_GLOB_ORG_ACCESS_TMP');
373: END IF;
374:
375: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
376: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
377: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.end',
378: 'Returning from PL/SQL procedure '||
379: 'MO_GLOBAL.POPULATE_ORGS: '||
380: 'l_bg_id='||l_bg_id||

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

385: END IF;
386:
387: EXCEPTION
388: WHEN OTHERS THEN
389: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
390: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
391: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.temp_table',
392: 'temporary table other exception raised sqlerrm'||
393: '=>'||sqlerrm);

Line 390: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

386:
387: EXCEPTION
388: WHEN OTHERS THEN
389: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
390: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
391: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.temp_table',
392: 'temporary table other exception raised sqlerrm'||
393: '=>'||sqlerrm);
394: END IF;

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

409: -- since the repopulation fails because of the unique constraint
410: -- violation.
411: --
412:
413: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
414: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
415: 'fnd.plsql.MO_GLOBAL.DELETE_ORGS.begin',
416: 'Before flushing MO_GLOB_ORG_ACCESS_TMP');
417: END IF;

Line 414: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

410: -- violation.
411: --
412:
413: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
414: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
415: 'fnd.plsql.MO_GLOBAL.DELETE_ORGS.begin',
416: 'Before flushing MO_GLOB_ORG_ACCESS_TMP');
417: END IF;
418:

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

417: END IF;
418:
419: DELETE FROM mo_glob_org_access_tmp;
420:
421: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
422: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
423: 'fnd.plsql.MO_GLOBAL.DELETE_ORGS.end',
424: 'MO_GLOB_ORG_ACCESS_TMP was flushed');
425: END IF;

Line 422: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

418:
419: DELETE FROM mo_glob_org_access_tmp;
420:
421: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
422: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
423: 'fnd.plsql.MO_GLOBAL.DELETE_ORGS.end',
424: 'MO_GLOB_ORG_ACCESS_TMP was flushed');
425: END IF;
426:

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

512: NO_ORG_ACCESS_FOUND EXCEPTION;
513: NO_APPL_NAME EXCEPTION;
514:
515: BEGIN
516: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
517: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
518: 'fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.begin',
519: 'Calling PL/SQL procedure MO_GLOBAL.SET_ORG_ACCESS:'||
520: ' p_org_id_char=>'||p_org_id_char||

Line 517: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

513: NO_APPL_NAME EXCEPTION;
514:
515: BEGIN
516: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
517: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
518: 'fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.begin',
519: 'Calling PL/SQL procedure MO_GLOBAL.SET_ORG_ACCESS:'||
520: ' p_org_id_char=>'||p_org_id_char||
521: ', p_sp_id_char=>'||p_sp_id_char||

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

546: WHEN OTHERS THEN
547: generic_error('MO_GLOBAL.SET_ORG_ACCESS', sqlcode, sqlerrm);
548: END;
549:
550: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
552: 'fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.access_status',
553: 'Checking access status within PL/SQL procedure '||
554: 'MO_GLOBAL.SET_ORG_ACCESS: '||

Line 551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

547: generic_error('MO_GLOBAL.SET_ORG_ACCESS', sqlcode, sqlerrm);
548: END;
549:
550: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
552: 'fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.access_status',
553: 'Checking access status within PL/SQL procedure '||
554: 'MO_GLOBAL.SET_ORG_ACCESS: '||
555: 'l_access_ctrl_enabled=>'||l_access_ctrl_enabled);

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

558: --
559: -- Delete temporary table data first for all products access enabled or not
560: --
561: delete_orgs;
562: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
563: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
564: 'fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.after_delete',
565: 'Returning from PL/SQL procedure '||
566: 'MO_GLOBAL.DELETE_ORGS ');

Line 563: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

559: -- Delete temporary table data first for all products access enabled or not
560: --
561: delete_orgs;
562: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
563: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
564: 'fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.after_delete',
565: 'Returning from PL/SQL procedure '||
566: 'MO_GLOBAL.DELETE_ORGS ');
567: END IF;

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

580: populate_orgs(l_org_id,
581: l_security_profile_id,
582: l_current_org_id,
583: l_view_all_orgs);
584: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
585: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
586: 'fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.After_Populate',
587: 'Returning from PL/SQL procedure '||
588: 'MO_GLOBAL.POPULATE_ORGS ');

Line 585: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

581: l_security_profile_id,
582: l_current_org_id,
583: l_view_all_orgs);
584: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
585: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
586: 'fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.After_Populate',
587: 'Returning from PL/SQL procedure '||
588: 'MO_GLOBAL.POPULATE_ORGS ');
589: END IF;

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

620: END IF;
621: END IF;
622:
623: commit;
624: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
625: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
626: 'fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.end',
627: 'Calling PL/SQL procedure MO_GLOBAL.SET_ORG_ACCESS:'||
628: ' p_org_id_char=>'||p_org_id_char||

Line 625: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

621: END IF;
622:
623: commit;
624: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
625: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
626: 'fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.end',
627: 'Calling PL/SQL procedure MO_GLOBAL.SET_ORG_ACCESS:'||
628: ' p_org_id_char=>'||p_org_id_char||
629: ',p_sp_id_char=>'||p_sp_id_char||

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

709: BEGIN
710: --
711: -- Check if multi-org is enabled
712: --
713: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
714: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
715: 'fnd.plsql.MO_GLOBAL.INIT.begin',
716: 'Calling PL/SQL procedure MO_GLOBAL.INIT');
717: END IF;

Line 714: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

710: --
711: -- Check if multi-org is enabled
712: --
713: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
714: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
715: 'fnd.plsql.MO_GLOBAL.INIT.begin',
716: 'Calling PL/SQL procedure MO_GLOBAL.INIT');
717: END IF;
718: IF is_multi_org_enabled = 'Y' THEN

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

721: --
722: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL', l_security_profile_id);
723: fnd_profile.get('ORG_ID', l_org_id);
724:
725: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
726: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
727: 'fnd.plsql.MO_GLOBAL.INIT.config',
728: 'MO: Operating Unit=>'||l_org_id||
729: ', MO: Security Profile=>'||l_security_profile_id||

Line 726: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

722: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL', l_security_profile_id);
723: fnd_profile.get('ORG_ID', l_org_id);
724:
725: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
726: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
727: 'fnd.plsql.MO_GLOBAL.INIT.config',
728: 'MO: Operating Unit=>'||l_org_id||
729: ', MO: Security Profile=>'||l_security_profile_id||
730: ', p_appl_short_name=>'||p_appl_short_name);

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

746: g_old_org_id:=l_org_id;
747: END IF;
748:
749: END IF; -- multi org is enabled
750: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
751: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
752: 'fnd.plsql.MO_GLOBAL.INIT.end',
753: 'Exiting PL/SQL procedure MO_GLOBAL.INIT');
754: END IF;

Line 751: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

747: END IF;
748:
749: END IF; -- multi org is enabled
750: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
751: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
752: 'fnd.plsql.MO_GLOBAL.INIT.end',
753: 'Exiting PL/SQL procedure MO_GLOBAL.INIT');
754: END IF;
755: EXCEPTION

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

847:
848: l_ci_debug fnd_profile_option_values.profile_option_value%TYPE := NULL;
849:
850: BEGIN
851: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
852: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
853: 'fnd.plsql.MO_GLOBAL.INIT.config',
854: 'MO: Operating Unit=>'||p_org_id_char||
855: ',MO: Security Profile=>'||p_sp_id_char||

Line 852: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

848: l_ci_debug fnd_profile_option_values.profile_option_value%TYPE := NULL;
849:
850: BEGIN
851: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
852: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
853: 'fnd.plsql.MO_GLOBAL.INIT.config',
854: 'MO: Operating Unit=>'||p_org_id_char||
855: ',MO: Security Profile=>'||p_sp_id_char||
856: ',p_appl_short_name=>'||p_appl_short_name);

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

864:
865: -- Set up the organization access list for Multi- Org Access Control
866: set_org_access(p_org_id_char,p_sp_id_char, p_appl_short_name);
867:
868: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
869: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
870: 'fnd.plsql.MO_GLOBAL.SET_ORG_CONTEXT.end',
871: 'Returning from PL/SQL procedure MO_GLOBAL.SET_ORG_CONTEXT');
872: END IF;

Line 869: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

865: -- Set up the organization access list for Multi- Org Access Control
866: set_org_access(p_org_id_char,p_sp_id_char, p_appl_short_name);
867:
868: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
869: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
870: 'fnd.plsql.MO_GLOBAL.SET_ORG_CONTEXT.end',
871: 'Returning from PL/SQL procedure MO_GLOBAL.SET_ORG_CONTEXT');
872: END IF;
873:

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

1008: p_org_id NUMBER)
1009: IS
1010:
1011: BEGIN
1012: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1013: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1014: 'fnd.plsql.MO_GLOBAL.SET_POLICY_CONTEXT.begin',
1015: 'Calling PL/SQL procedure MO_GLOBAL.SET_POLICY_CONTEXT:'||
1016: ' p_access_mode=>'||p_access_mode||

Line 1013: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1009: IS
1010:
1011: BEGIN
1012: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1013: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1014: 'fnd.plsql.MO_GLOBAL.SET_POLICY_CONTEXT.begin',
1015: 'Calling PL/SQL procedure MO_GLOBAL.SET_POLICY_CONTEXT:'||
1016: ' p_access_mode=>'||p_access_mode||
1017: ',p_org_id=>'||p_org_id);

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

1119: --
1120: g_old_user_id:=sys_context('FND','USER_ID');
1121: g_old_resp_id:=sys_context('FND','RESP_ID');
1122:
1123: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1124: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1125: 'fnd.plsql.MO_GLOBAL.SET_POLICY_CONTEXT.end',
1126: 'Returning from PL/SQL prcedure MO_GLOBAL.SET_POLICY_CONTEXT');
1127: END IF;

Line 1124: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1120: g_old_user_id:=sys_context('FND','USER_ID');
1121: g_old_resp_id:=sys_context('FND','RESP_ID');
1122:
1123: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1124: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1125: 'fnd.plsql.MO_GLOBAL.SET_POLICY_CONTEXT.end',
1126: 'Returning from PL/SQL prcedure MO_GLOBAL.SET_POLICY_CONTEXT');
1127: END IF;
1128:

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

1201: BEGIN
1202: --
1203: -- Debug information
1204: --
1205: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1206: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1207: 'fnd.plsql.MO_GLOBAL.GET_VALID_ORG.begin',
1208: 'Calling PL/SQL function '||
1209: 'MO_GLOBAL.GET_VALID_ORG'||

Line 1206: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1202: --
1203: -- Debug information
1204: --
1205: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1206: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1207: 'fnd.plsql.MO_GLOBAL.GET_VALID_ORG.begin',
1208: 'Calling PL/SQL function '||
1209: 'MO_GLOBAL.GET_VALID_ORG'||
1210: ' p_org_id=>'||p_org_id);

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

1243: IF (l_status = 'N') THEN
1244: --
1245: -- Debug information
1246: --
1247: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1248: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1249: 'fnd.plsql.MO_GLOBAL.GET_VALID_ORG.end',
1250: 'Returning from PL/SQL function '||
1251: 'MO_GLOBAL.GET_VALID_ORG:'||

Line 1248: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1244: --
1245: -- Debug information
1246: --
1247: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1248: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1249: 'fnd.plsql.MO_GLOBAL.GET_VALID_ORG.end',
1250: 'Returning from PL/SQL function '||
1251: 'MO_GLOBAL.GET_VALID_ORG:'||
1252: ' Returns NULL');

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

1260: ELSE
1261: --
1262: -- Debug information
1263: --
1264: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1265: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1266: 'fnd.plsql.MO_GLOBAL.GET_VALID_ORG.end',
1267: 'Returning from PL/SQL function '||
1268: 'MO_GLOBAL.GET_VALID_ORG:'||

Line 1265: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1261: --
1262: -- Debug information
1263: --
1264: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1265: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1266: 'fnd.plsql.MO_GLOBAL.GET_VALID_ORG.end',
1267: 'Returning from PL/SQL function '||
1268: 'MO_GLOBAL.GET_VALID_ORG:'||
1269: ' Returns '||l_org_id);

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

1462: END IF;
1463: ELSE
1464: return 'N';
1465:
1466: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1467: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1468: 'fnd.plsql.MO_GLOBAL.is_mo_init_done.begin',
1469: 'g_ou_count=>'||g_ou_count||
1470: ', g_access_mode=>'||g_access_mode||

Line 1467: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1463: ELSE
1464: return 'N';
1465:
1466: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1467: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1468: 'fnd.plsql.MO_GLOBAL.is_mo_init_done.begin',
1469: 'g_ou_count=>'||g_ou_count||
1470: ', g_access_mode=>'||g_access_mode||
1471: ', g_current_org_id=>'||g_current_org_id||

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

1560: IS
1561:
1562: BEGIN
1563:
1564: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1565: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1566: 'fnd.plsql.MO_GLOBAL.SET_POLICY_CONTEXT_SERVER.begin',
1567: 'Calling PL/SQL procedure MO_GLOBAL.SET_POLICY_CONTEXT_SERVER:'||
1568: ' p_access_mode=>'||p_access_mode||

Line 1565: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1561:
1562: BEGIN
1563:
1564: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1565: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1566: 'fnd.plsql.MO_GLOBAL.SET_POLICY_CONTEXT_SERVER.begin',
1567: 'Calling PL/SQL procedure MO_GLOBAL.SET_POLICY_CONTEXT_SERVER:'||
1568: ' p_access_mode=>'||p_access_mode||
1569: ',p_org_id=>'||p_org_id);