32: where APPLICATION_SHORT_NAME = upper(x_apps_name);
33:
34: exception
35: when others then
36: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
37: fnd_message.set_token('ROUTINE', 'Remove');
38: fnd_message.set_token('ERRNO', to_char(sqlcode));
39: fnd_message.set_token('REASON', sqlerrm);
40: app_exception.raise_exception(NULL, NULL,
33:
34: exception
35: when others then
36: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
37: fnd_message.set_token('ROUTINE', 'Remove');
38: fnd_message.set_token('ERRNO', to_char(sqlcode));
39: fnd_message.set_token('REASON', sqlerrm);
40: app_exception.raise_exception(NULL, NULL,
41: 'Exception in FND_PRODUCT_INITIALIZATION_PKG.REMOVE');
34: exception
35: when others then
36: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
37: fnd_message.set_token('ROUTINE', 'Remove');
38: fnd_message.set_token('ERRNO', to_char(sqlcode));
39: fnd_message.set_token('REASON', sqlerrm);
40: app_exception.raise_exception(NULL, NULL,
41: 'Exception in FND_PRODUCT_INITIALIZATION_PKG.REMOVE');
42: raise;
35: when others then
36: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
37: fnd_message.set_token('ROUTINE', 'Remove');
38: fnd_message.set_token('ERRNO', to_char(sqlcode));
39: fnd_message.set_token('REASON', sqlerrm);
40: app_exception.raise_exception(NULL, NULL,
41: 'Exception in FND_PRODUCT_INITIALIZATION_PKG.REMOVE');
42: raise;
43: end;
82: and RE_INIT_CONDITION = upper(x_condition);
83:
84: exception
85: when others then
86: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
87: fnd_message.set_token('ROUTINE', 'RemoveInitCondition');
88: fnd_message.set_token('ERRNO', to_char(sqlcode));
89: fnd_message.set_token('REASON', sqlerrm);
90: app_exception.raise_exception(NULL, NULL,
83:
84: exception
85: when others then
86: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
87: fnd_message.set_token('ROUTINE', 'RemoveInitCondition');
88: fnd_message.set_token('ERRNO', to_char(sqlcode));
89: fnd_message.set_token('REASON', sqlerrm);
90: app_exception.raise_exception(NULL, NULL,
91: 'Exception in FND_PRODUCT_INITIALIZATION_PKG.RemoveInitCondition');
84: exception
85: when others then
86: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
87: fnd_message.set_token('ROUTINE', 'RemoveInitCondition');
88: fnd_message.set_token('ERRNO', to_char(sqlcode));
89: fnd_message.set_token('REASON', sqlerrm);
90: app_exception.raise_exception(NULL, NULL,
91: 'Exception in FND_PRODUCT_INITIALIZATION_PKG.RemoveInitCondition');
92: raise;
85: when others then
86: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
87: fnd_message.set_token('ROUTINE', 'RemoveInitCondition');
88: fnd_message.set_token('ERRNO', to_char(sqlcode));
89: fnd_message.set_token('REASON', sqlerrm);
90: app_exception.raise_exception(NULL, NULL,
91: 'Exception in FND_PRODUCT_INITIALIZATION_PKG.RemoveInitCondition');
92: raise;
93: end;
132: and PRODUCT_DEPENDENCY = upper(x_dependency);
133:
134: exception
135: when others then
136: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
137: fnd_message.set_token('ROUTINE', 'RemoveDependency');
138: fnd_message.set_token('ERRNO', to_char(sqlcode));
139: fnd_message.set_token('REASON', sqlerrm);
140: app_exception.raise_exception(NULL, NULL,
133:
134: exception
135: when others then
136: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
137: fnd_message.set_token('ROUTINE', 'RemoveDependency');
138: fnd_message.set_token('ERRNO', to_char(sqlcode));
139: fnd_message.set_token('REASON', sqlerrm);
140: app_exception.raise_exception(NULL, NULL,
141: 'Exception in FND_PRODUCT_INITIALIZATION_PKG.RemoveDependency');
134: exception
135: when others then
136: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
137: fnd_message.set_token('ROUTINE', 'RemoveDependency');
138: fnd_message.set_token('ERRNO', to_char(sqlcode));
139: fnd_message.set_token('REASON', sqlerrm);
140: app_exception.raise_exception(NULL, NULL,
141: 'Exception in FND_PRODUCT_INITIALIZATION_PKG.RemoveDependency');
142: raise;
135: when others then
136: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
137: fnd_message.set_token('ROUTINE', 'RemoveDependency');
138: fnd_message.set_token('ERRNO', to_char(sqlcode));
139: fnd_message.set_token('REASON', sqlerrm);
140: app_exception.raise_exception(NULL, NULL,
141: 'Exception in FND_PRODUCT_INITIALIZATION_PKG.RemoveDependency');
142: raise;
143: end;
252: fnd_log.string(fnd_log.LEVEL_EXCEPTION,
253: 'PLSQL.FND.SECURITY.INIT.FND_INITIALIZATION_PKG',
254: 'Unable to fetch product dependency');
255: end if;
256: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
257: fnd_message.set_token('ROUTINE',sqlbuf);
258: fnd_message.set_token('ERRNO', to_char(sqlcode));
259: fnd_message.set_token('REASON', sqlerrm);
260: app_exception.raise_exception;
253: 'PLSQL.FND.SECURITY.INIT.FND_INITIALIZATION_PKG',
254: 'Unable to fetch product dependency');
255: end if;
256: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
257: fnd_message.set_token('ROUTINE',sqlbuf);
258: fnd_message.set_token('ERRNO', to_char(sqlcode));
259: fnd_message.set_token('REASON', sqlerrm);
260: app_exception.raise_exception;
261: end;
254: 'Unable to fetch product dependency');
255: end if;
256: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
257: fnd_message.set_token('ROUTINE',sqlbuf);
258: fnd_message.set_token('ERRNO', to_char(sqlcode));
259: fnd_message.set_token('REASON', sqlerrm);
260: app_exception.raise_exception;
261: end;
262:
255: end if;
256: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
257: fnd_message.set_token('ROUTINE',sqlbuf);
258: fnd_message.set_token('ERRNO', to_char(sqlcode));
259: fnd_message.set_token('REASON', sqlerrm);
260: app_exception.raise_exception;
261: end;
262:
263: i := 0;
412: fnd_log.string(fnd_log.LEVEL_EXCEPTION,
413: 'PLSQL.FND.SECURITY.INIT.FND_INITIALIZATION_PKG',
414: tmpbuf);
415: end if;
416: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
417: fnd_message.set_token('ROUTINE',sqlbuf);
418: fnd_message.set_token('ERRNO', to_char(sqlcode));
419: fnd_message.set_token('REASON', sqlerrm);
420: app_exception.raise_exception;
413: 'PLSQL.FND.SECURITY.INIT.FND_INITIALIZATION_PKG',
414: tmpbuf);
415: end if;
416: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
417: fnd_message.set_token('ROUTINE',sqlbuf);
418: fnd_message.set_token('ERRNO', to_char(sqlcode));
419: fnd_message.set_token('REASON', sqlerrm);
420: app_exception.raise_exception;
421: end;
414: tmpbuf);
415: end if;
416: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
417: fnd_message.set_token('ROUTINE',sqlbuf);
418: fnd_message.set_token('ERRNO', to_char(sqlcode));
419: fnd_message.set_token('REASON', sqlerrm);
420: app_exception.raise_exception;
421: end;
422:
415: end if;
416: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
417: fnd_message.set_token('ROUTINE',sqlbuf);
418: fnd_message.set_token('ERRNO', to_char(sqlcode));
419: fnd_message.set_token('REASON', sqlerrm);
420: app_exception.raise_exception;
421: end;
422:
423: if (init_function is not null) then
440: fnd_log.string(fnd_log.LEVEL_EXCEPTION,
441: 'PLSQL.FND.SECURITY.INIT.FND_INITIALIZATION_PKG',
442: tmpbuf);
443: end if;
444: fnd_message.set_name('FND', 'PRODUCT_INITIALIZATION_FAILED');
445: fnd_message.set_token('APPS', deparr(i));
446: fnd_message.set_token('ROUTINE', init_function);
447: fnd_message.set_token('SQLCODE', to_char(sqlcode));
448: fnd_message.set_token('SQLERROR', sqlerrm);
441: 'PLSQL.FND.SECURITY.INIT.FND_INITIALIZATION_PKG',
442: tmpbuf);
443: end if;
444: fnd_message.set_name('FND', 'PRODUCT_INITIALIZATION_FAILED');
445: fnd_message.set_token('APPS', deparr(i));
446: fnd_message.set_token('ROUTINE', init_function);
447: fnd_message.set_token('SQLCODE', to_char(sqlcode));
448: fnd_message.set_token('SQLERROR', sqlerrm);
449: app_exception.raise_exception;
442: tmpbuf);
443: end if;
444: fnd_message.set_name('FND', 'PRODUCT_INITIALIZATION_FAILED');
445: fnd_message.set_token('APPS', deparr(i));
446: fnd_message.set_token('ROUTINE', init_function);
447: fnd_message.set_token('SQLCODE', to_char(sqlcode));
448: fnd_message.set_token('SQLERROR', sqlerrm);
449: app_exception.raise_exception;
450: end;
443: end if;
444: fnd_message.set_name('FND', 'PRODUCT_INITIALIZATION_FAILED');
445: fnd_message.set_token('APPS', deparr(i));
446: fnd_message.set_token('ROUTINE', init_function);
447: fnd_message.set_token('SQLCODE', to_char(sqlcode));
448: fnd_message.set_token('SQLERROR', sqlerrm);
449: app_exception.raise_exception;
450: end;
451: end if;
444: fnd_message.set_name('FND', 'PRODUCT_INITIALIZATION_FAILED');
445: fnd_message.set_token('APPS', deparr(i));
446: fnd_message.set_token('ROUTINE', init_function);
447: fnd_message.set_token('SQLCODE', to_char(sqlcode));
448: fnd_message.set_token('SQLERROR', sqlerrm);
449: app_exception.raise_exception;
450: end;
451: end if;
452: i := i+1;
520: f_ludate,
521: f_luby);
522:
523: when others then
524: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
525: fnd_message.set_token('ROUTINE', 'Register');
526: fnd_message.set_token('ERRNO', to_char(sqlcode));
527: fnd_message.set_token('REASON', sqlerrm);
528: app_exception.raise_exception(NULL, NULL,
521: f_luby);
522:
523: when others then
524: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
525: fnd_message.set_token('ROUTINE', 'Register');
526: fnd_message.set_token('ERRNO', to_char(sqlcode));
527: fnd_message.set_token('REASON', sqlerrm);
528: app_exception.raise_exception(NULL, NULL,
529: 'Exception in FND_PRODUCT_INITIALIZATION_PKG.REGISTER');
522:
523: when others then
524: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
525: fnd_message.set_token('ROUTINE', 'Register');
526: fnd_message.set_token('ERRNO', to_char(sqlcode));
527: fnd_message.set_token('REASON', sqlerrm);
528: app_exception.raise_exception(NULL, NULL,
529: 'Exception in FND_PRODUCT_INITIALIZATION_PKG.REGISTER');
530: end;
523: when others then
524: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
525: fnd_message.set_token('ROUTINE', 'Register');
526: fnd_message.set_token('ERRNO', to_char(sqlcode));
527: fnd_message.set_token('REASON', sqlerrm);
528: app_exception.raise_exception(NULL, NULL,
529: 'Exception in FND_PRODUCT_INITIALIZATION_PKG.REGISTER');
530: end;
531: end Register;
574: exception
575: when dup_val_on_index then
576: null;
577: when others then
578: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
579: fnd_message.set_token('ROUTINE', 'AddDependency');
580: fnd_message.set_token('ERRNO', to_char(sqlcode));
581: fnd_message.set_token('REASON', sqlerrm);
582: app_exception.raise_exception(NULL, NULL,
575: when dup_val_on_index then
576: null;
577: when others then
578: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
579: fnd_message.set_token('ROUTINE', 'AddDependency');
580: fnd_message.set_token('ERRNO', to_char(sqlcode));
581: fnd_message.set_token('REASON', sqlerrm);
582: app_exception.raise_exception(NULL, NULL,
583: 'Exception in FND_PRODUCT_INITIALIZATION_PKG.AddDependency');
576: null;
577: when others then
578: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
579: fnd_message.set_token('ROUTINE', 'AddDependency');
580: fnd_message.set_token('ERRNO', to_char(sqlcode));
581: fnd_message.set_token('REASON', sqlerrm);
582: app_exception.raise_exception(NULL, NULL,
583: 'Exception in FND_PRODUCT_INITIALIZATION_PKG.AddDependency');
584: raise;
577: when others then
578: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
579: fnd_message.set_token('ROUTINE', 'AddDependency');
580: fnd_message.set_token('ERRNO', to_char(sqlcode));
581: fnd_message.set_token('REASON', sqlerrm);
582: app_exception.raise_exception(NULL, NULL,
583: 'Exception in FND_PRODUCT_INITIALIZATION_PKG.AddDependency');
584: raise;
585: end;
631: exception
632: when dup_val_on_index then
633: null;
634: when others then
635: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
636: fnd_message.set_token('ROUTINE', 'AddInitCondition');
637: fnd_message.set_token('ERRNO', to_char(sqlcode));
638: fnd_message.set_token('REASON', sqlerrm);
639: app_exception.raise_exception(NULL, NULL,
632: when dup_val_on_index then
633: null;
634: when others then
635: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
636: fnd_message.set_token('ROUTINE', 'AddInitCondition');
637: fnd_message.set_token('ERRNO', to_char(sqlcode));
638: fnd_message.set_token('REASON', sqlerrm);
639: app_exception.raise_exception(NULL, NULL,
640: 'Exception in FND_PRODUCT_INITIALIZATION_PKG.AddInitCondition');
633: null;
634: when others then
635: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
636: fnd_message.set_token('ROUTINE', 'AddInitCondition');
637: fnd_message.set_token('ERRNO', to_char(sqlcode));
638: fnd_message.set_token('REASON', sqlerrm);
639: app_exception.raise_exception(NULL, NULL,
640: 'Exception in FND_PRODUCT_INITIALIZATION_PKG.AddInitCondition');
641: end;
634: when others then
635: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
636: fnd_message.set_token('ROUTINE', 'AddInitCondition');
637: fnd_message.set_token('ERRNO', to_char(sqlcode));
638: fnd_message.set_token('REASON', sqlerrm);
639: app_exception.raise_exception(NULL, NULL,
640: 'Exception in FND_PRODUCT_INITIALIZATION_PKG.AddInitCondition');
641: end;
642: