DBA Data[Home] [Help]

APPS.FND_PRODUCT_INITIALIZATION_PKG dependencies on FND_MESSAGE

Line 36: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

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,

Line 37: fnd_message.set_token('ROUTINE', 'Remove');

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');

Line 38: fnd_message.set_token('ERRNO', to_char(sqlcode));

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;

Line 39: fnd_message.set_token('REASON', sqlerrm);

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;

Line 86: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

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,

Line 87: fnd_message.set_token('ROUTINE', 'RemoveInitCondition');

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');

Line 88: fnd_message.set_token('ERRNO', to_char(sqlcode));

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;

Line 89: fnd_message.set_token('REASON', sqlerrm);

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;

Line 136: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

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,

Line 137: fnd_message.set_token('ROUTINE', 'RemoveDependency');

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');

Line 138: fnd_message.set_token('ERRNO', to_char(sqlcode));

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;

Line 139: fnd_message.set_token('REASON', sqlerrm);

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;

Line 256: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

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;

Line 257: fnd_message.set_token('ROUTINE',sqlbuf);

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;

Line 258: fnd_message.set_token('ERRNO', to_char(sqlcode));

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:

Line 259: fnd_message.set_token('REASON', sqlerrm);

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;

Line 416: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

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;

Line 417: fnd_message.set_token('ROUTINE',sqlbuf);

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;

Line 418: fnd_message.set_token('ERRNO', to_char(sqlcode));

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:

Line 419: fnd_message.set_token('REASON', sqlerrm);

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

Line 444: fnd_message.set_name('FND', 'PRODUCT_INITIALIZATION_FAILED');

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);

Line 445: fnd_message.set_token('APPS', deparr(i));

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;

Line 446: fnd_message.set_token('ROUTINE', init_function);

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;

Line 447: fnd_message.set_token('SQLCODE', to_char(sqlcode));

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;

Line 448: fnd_message.set_token('SQLERROR', sqlerrm);

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;

Line 524: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

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,

Line 525: fnd_message.set_token('ROUTINE', 'Register');

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');

Line 526: fnd_message.set_token('ERRNO', to_char(sqlcode));

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;

Line 527: fnd_message.set_token('REASON', sqlerrm);

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;

Line 578: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

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,

Line 579: fnd_message.set_token('ROUTINE', 'AddDependency');

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');

Line 580: fnd_message.set_token('ERRNO', to_char(sqlcode));

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;

Line 581: fnd_message.set_token('REASON', sqlerrm);

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;

Line 635: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

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,

Line 636: fnd_message.set_token('ROUTINE', 'AddInitCondition');

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');

Line 637: fnd_message.set_token('ERRNO', to_char(sqlcode));

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;

Line 638: fnd_message.set_token('REASON', sqlerrm);

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: