APPS.FND_SEQ_CATEGORIES_PKG dependencies on FND_MESSAGE

Line 42: fnd_message.set_name('FND', 'UNIQUE-DUPLICATE CODE');

38:
39: BEGIN
40:
41: IF is_dublicate_cat(x_application_id,x_category_code) = 1 THEN
42: fnd_message.set_name('FND', 'UNIQUE-DUPLICATE CODE');
43: app_exception.raise_exception;
44: END IF;
45:
46:

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

47: EXCEPTION
48: WHEN app_exceptions.application_exception THEN
49: RAISE;
50: WHEN OTHERS THEN
51: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
52: fnd_message.set_token('ROUTINE',
53: 'FND_SEQ_CATEGORIES_PKG.check_unique_cat');
54: fnd_message.set_token('ERRNO',SQLCODE);
55: fnd_message.set_token('REASON',SQLERRM);

Line 52: fnd_message.set_token('ROUTINE',

48: WHEN app_exceptions.application_exception THEN
49: RAISE;
50: WHEN OTHERS THEN
51: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
52: fnd_message.set_token('ROUTINE',
53: 'FND_SEQ_CATEGORIES_PKG.check_unique_cat');
54: fnd_message.set_token('ERRNO',SQLCODE);
55: fnd_message.set_token('REASON',SQLERRM);
56: RAISE;

Line 54: fnd_message.set_token('ERRNO',SQLCODE);

50: WHEN OTHERS THEN
51: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
52: fnd_message.set_token('ROUTINE',
53: 'FND_SEQ_CATEGORIES_PKG.check_unique_cat');
54: fnd_message.set_token('ERRNO',SQLCODE);
55: fnd_message.set_token('REASON',SQLERRM);
56: RAISE;
57:
58:

Line 55: fnd_message.set_token('REASON',SQLERRM);

51: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
52: fnd_message.set_token('ROUTINE',
53: 'FND_SEQ_CATEGORIES_PKG.check_unique_cat');
54: fnd_message.set_token('ERRNO',SQLCODE);
55: fnd_message.set_token('REASON',SQLERRM);
56: RAISE;
57:
58:
59: END check_unique_cat;

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

86: EXCEPTION
87: WHEN app_exceptions.application_exception THEN
88: RAISE;
89: WHEN OTHERS THEN
90: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
91: fnd_message.set_token('ROUTINE',
92: 'FND_SEQ_CATEGORIES_PKG.insert_cat');
93: fnd_message.set_token('ERRNO',SQLCODE);
94: fnd_message.set_token('REASON',SQLERRM);

Line 91: fnd_message.set_token('ROUTINE',

87: WHEN app_exceptions.application_exception THEN
88: RAISE;
89: WHEN OTHERS THEN
90: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
91: fnd_message.set_token('ROUTINE',
92: 'FND_SEQ_CATEGORIES_PKG.insert_cat');
93: fnd_message.set_token('ERRNO',SQLCODE);
94: fnd_message.set_token('REASON',SQLERRM);
95: RAISE;

Line 93: fnd_message.set_token('ERRNO',SQLCODE);

89: WHEN OTHERS THEN
90: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
91: fnd_message.set_token('ROUTINE',
92: 'FND_SEQ_CATEGORIES_PKG.insert_cat');
93: fnd_message.set_token('ERRNO',SQLCODE);
94: fnd_message.set_token('REASON',SQLERRM);
95: RAISE;
96:
97: END insert_cat;

Line 94: fnd_message.set_token('REASON',SQLERRM);

90: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
91: fnd_message.set_token('ROUTINE',
92: 'FND_SEQ_CATEGORIES_PKG.insert_cat');
93: fnd_message.set_token('ERRNO',SQLCODE);
94: fnd_message.set_token('REASON',SQLERRM);
95: RAISE;
96:
97: END insert_cat;
98:

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

118: EXCEPTION
119: WHEN app_exceptions.application_exception THEN
120: RAISE;
121: WHEN OTHERS THEN
122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
123: fnd_message.set_token('ROUTINE',
124: 'FND_SEQ_CATEGORIES_PKG.update_cat');
125: fnd_message.set_token('ERRNO',SQLCODE);
126: fnd_message.set_token('REASON',SQLERRM);

Line 123: fnd_message.set_token('ROUTINE',

119: WHEN app_exceptions.application_exception THEN
120: RAISE;
121: WHEN OTHERS THEN
122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
123: fnd_message.set_token('ROUTINE',
124: 'FND_SEQ_CATEGORIES_PKG.update_cat');
125: fnd_message.set_token('ERRNO',SQLCODE);
126: fnd_message.set_token('REASON',SQLERRM);
127:

Line 125: fnd_message.set_token('ERRNO',SQLCODE);

121: WHEN OTHERS THEN
122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
123: fnd_message.set_token('ROUTINE',
124: 'FND_SEQ_CATEGORIES_PKG.update_cat');
125: fnd_message.set_token('ERRNO',SQLCODE);
126: fnd_message.set_token('REASON',SQLERRM);
127:
128: END update_cat;
129:

Line 126: fnd_message.set_token('REASON',SQLERRM);

122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
123: fnd_message.set_token('ROUTINE',
124: 'FND_SEQ_CATEGORIES_PKG.update_cat');
125: fnd_message.set_token('ERRNO',SQLCODE);
126: fnd_message.set_token('REASON',SQLERRM);
127:
128: END update_cat;
129:
130: