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.JTF_RS_TABLE_ATTRIBUTES_PUB dependencies on FND_API

Line 21: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

17: /* Procedure to create table attributes
18: based on input values passed by calling routines. */
19: PROCEDURE create_table_attribute
20: (P_API_VERSION IN NUMBER,
21: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE,
24: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE,
25: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT NULL,

Line 22: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

18: based on input values passed by calling routines. */
19: PROCEDURE create_table_attribute
20: (P_API_VERSION IN NUMBER,
21: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE,
24: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE,
25: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT NULL,
26: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT NULL,

Line 70: x_return_status := fnd_api.g_ret_sts_success;

66: BEGIN
67: --Standard Start of API SAVEPOINT
68: SAVEPOINT TABLE_ATTRIBUTE_SP;
69:
70: x_return_status := fnd_api.g_ret_sts_success;
71:
72: --Standard Call to check API compatibility
73: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
74: THEN

Line 73: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

69:
70: x_return_status := fnd_api.g_ret_sts_success;
71:
72: --Standard Call to check API compatibility
73: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
74: THEN
75: RAISE FND_API.G_EXC_ERROR;
76: END IF;
77:

Line 75: RAISE FND_API.G_EXC_ERROR;

71:
72: --Standard Call to check API compatibility
73: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
74: THEN
75: RAISE FND_API.G_EXC_ERROR;
76: END IF;
77:
78: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
79: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 79: IF FND_API.To_boolean(P_INIT_MSG_LIST)

75: RAISE FND_API.G_EXC_ERROR;
76: END IF;
77:
78: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
79: IF FND_API.To_boolean(P_INIT_MSG_LIST)
80: THEN
81: FND_MSG_PUB.Initialize;
82: END IF;
83:

Line 120: IF fnd_api.to_boolean (p_commit)

116: X_MSG_DATA := l_msg_data;
117:
118:
119: --standard commit
120: IF fnd_api.to_boolean (p_commit)
121: THEN
122: COMMIT WORK;
123: END IF;
124:

Line 128: WHEN fnd_api.g_exc_unexpected_error

124:
125: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
126:
127: EXCEPTION
128: WHEN fnd_api.g_exc_unexpected_error
129: THEN
130:
131: ROLLBACK TO TABLE_ATTRIBUTE_SP;
132: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 133: WHEN fnd_api.g_exc_error

129: THEN
130:
131: ROLLBACK TO TABLE_ATTRIBUTE_SP;
132: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
133: WHEN fnd_api.g_exc_error
134: THEN
135: ROLLBACK TO TABLE_ATTRIBUTE_SP;
136: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
137: WHEN OTHERS

Line 145: x_return_status := fnd_api.g_ret_sts_unexp_error;

141: fnd_message.set_token('P_SQLCODE',SQLCODE);
142: fnd_message.set_token('P_SQLERRM',SQLERRM);
143: fnd_message.set_token('P_API_NAME', l_api_name);
144: FND_MSG_PUB.add;
145: x_return_status := fnd_api.g_ret_sts_unexp_error;
146: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
147:
148: END create_table_attribute;
149:

Line 156: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

152: based on input values passed by calling routines. */
153:
154: PROCEDURE update_table_attribute
155: (P_API_VERSION IN NUMBER,
156: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
157: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
158: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
159: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
160: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 157: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

153:
154: PROCEDURE update_table_attribute
155: (P_API_VERSION IN NUMBER,
156: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
157: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
158: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
159: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
160: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE DEFAULT FND_API.G_MISS_CHAR,
161: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 159: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,

155: (P_API_VERSION IN NUMBER,
156: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
157: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
158: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
159: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
160: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE DEFAULT FND_API.G_MISS_CHAR,
161: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
163: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 160: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE DEFAULT FND_API.G_MISS_CHAR,

156: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
157: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
158: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
159: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
160: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE DEFAULT FND_API.G_MISS_CHAR,
161: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
163: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
164: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 161: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,

157: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
158: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
159: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
160: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE DEFAULT FND_API.G_MISS_CHAR,
161: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
163: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
164: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
165: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 163: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,

159: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
160: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE DEFAULT FND_API.G_MISS_CHAR,
161: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
163: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
164: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
165: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 164: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,

160: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE DEFAULT FND_API.G_MISS_CHAR,
161: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
163: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
164: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
165: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 165: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,

161: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
163: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
164: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
165: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 166: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,

162: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
163: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
164: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
165: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 167: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,

163: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
164: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
165: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 168: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,

164: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
165: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 169: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,

165: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 170: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,

166: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 171: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,

167: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 172: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,

168: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 173: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,

169: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 174: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,

170: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 175: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,

171: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
179: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 176: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,

172: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
179: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
180: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 177: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,

173: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
179: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
180: X_MSG_COUNT OUT NOCOPY NUMBER,
181: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 178: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,

174: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
179: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
180: X_MSG_COUNT OUT NOCOPY NUMBER,
181: X_MSG_DATA OUT NOCOPY VARCHAR2
182: )IS

Line 206: x_return_status := fnd_api.g_ret_sts_success;

202: BEGIN
203: --Standard Start of API SAVEPOINT
204: SAVEPOINT TABLE_ATTRIBUTE_SP;
205:
206: x_return_status := fnd_api.g_ret_sts_success;
207:
208: --Standard Call to check API compatibility
209: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
210: THEN

Line 209: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

205:
206: x_return_status := fnd_api.g_ret_sts_success;
207:
208: --Standard Call to check API compatibility
209: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
210: THEN
211: RAISE FND_API.G_EXC_ERROR;
212: END IF;
213:

Line 211: RAISE FND_API.G_EXC_ERROR;

207:
208: --Standard Call to check API compatibility
209: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
210: THEN
211: RAISE FND_API.G_EXC_ERROR;
212: END IF;
213:
214: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
215: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 215: IF FND_API.To_boolean(P_INIT_MSG_LIST)

211: RAISE FND_API.G_EXC_ERROR;
212: END IF;
213:
214: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
215: IF FND_API.To_boolean(P_INIT_MSG_LIST)
216: THEN
217: FND_MSG_PUB.Initialize;
218: END IF;
219:

Line 256: IF fnd_api.to_boolean (p_commit)

252: X_MSG_DATA := l_msg_data;
253: P_OBJECT_VERSION_NUM := l_object_version_number;
254:
255:
256: IF fnd_api.to_boolean (p_commit)
257: THEN
258: COMMIT WORK;
259: END IF;
260:

Line 264: WHEN fnd_api.g_exc_error

260:
261: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
262:
263: EXCEPTION
264: WHEN fnd_api.g_exc_error
265: THEN
266: ROLLBACK TO TABLE_ATTRIBUTE_SP;
267: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
268:

Line 269: WHEN fnd_api.g_exc_unexpected_error

265: THEN
266: ROLLBACK TO TABLE_ATTRIBUTE_SP;
267: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
268:
269: WHEN fnd_api.g_exc_unexpected_error
270: THEN
271: ROLLBACK TO TABLE_ATTRIBUTE_SP;
272: x_return_status := fnd_api.g_ret_sts_unexp_error;
273: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 272: x_return_status := fnd_api.g_ret_sts_unexp_error;

268:
269: WHEN fnd_api.g_exc_unexpected_error
270: THEN
271: ROLLBACK TO TABLE_ATTRIBUTE_SP;
272: x_return_status := fnd_api.g_ret_sts_unexp_error;
273: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
274: WHEN OTHERS
275: THEN
276: ROLLBACK TO TABLE_ATTRIBUTE_SP;

Line 282: x_return_status := fnd_api.g_ret_sts_unexp_error;

278: fnd_message.set_token('P_SQLCODE',SQLCODE);
279: fnd_message.set_token('P_SQLERRM',SQLERRM);
280: fnd_message.set_token('P_API_NAME',l_api_name);
281: FND_MSG_PUB.add;
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
283: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
284: END update_table_attribute;
285:
286:

Line 291: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

287: /* Procedure to delete the table attributes. */
288:
289: PROCEDURE delete_table_attribute
290: (P_API_VERSION IN NUMBER,
291: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
292: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
293: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
294: P_OBJECT_VERSION_NUM IN JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
295: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 292: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

288:
289: PROCEDURE delete_table_attribute
290: (P_API_VERSION IN NUMBER,
291: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
292: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
293: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
294: P_OBJECT_VERSION_NUM IN JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
295: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
296: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 319: x_return_status := fnd_api.g_ret_sts_success;

315: BEGIN
316: --Standard Start of API SAVEPOINT
317: SAVEPOINT TABLE_ATTRIBUTE_SP;
318:
319: x_return_status := fnd_api.g_ret_sts_success;
320:
321: --Standard Call to check API compatibility
322: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
323: THEN

Line 322: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

318:
319: x_return_status := fnd_api.g_ret_sts_success;
320:
321: --Standard Call to check API compatibility
322: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
323: THEN
324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
325: END IF;
326:

Line 324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

320:
321: --Standard Call to check API compatibility
322: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
323: THEN
324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
325: END IF;
326:
327: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
328: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 328: IF FND_API.To_boolean(P_INIT_MSG_LIST)

324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
325: END IF;
326:
327: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
328: IF FND_API.To_boolean(P_INIT_MSG_LIST)
329: THEN
330: FND_MSG_PUB.Initialize;
331: END IF;
332:

Line 349: IF fnd_api.to_boolean (p_commit)

345: X_RETURN_STATUS := l_return_status;
346: X_MSG_COUNT := l_msg_count;
347: X_MSG_DATA := l_msg_data;
348:
349: IF fnd_api.to_boolean (p_commit)
350: THEN
351: COMMIT WORK;
352: END IF;
353:

Line 357: WHEN fnd_api.g_exc_unexpected_error

353:
354: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
355:
356: EXCEPTION
357: WHEN fnd_api.g_exc_unexpected_error
358: THEN
359: ROLLBACK TO TABLE_ATTRIBUTE_SP;
360: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
361: WHEN fnd_api.g_exc_error

Line 361: WHEN fnd_api.g_exc_error

357: WHEN fnd_api.g_exc_unexpected_error
358: THEN
359: ROLLBACK TO TABLE_ATTRIBUTE_SP;
360: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
361: WHEN fnd_api.g_exc_error
362: THEN
363: ROLLBACK TO TABLE_ATTRIBUTE_SP;
364: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
365: WHEN OTHERS

Line 373: x_return_status := fnd_api.g_ret_sts_unexp_error;

369: fnd_message.set_token('P_SQLCODE',SQLCODE);
370: fnd_message.set_token('P_SQLERRM',SQLERRM);
371: fnd_message.set_token('P_API_NAME',l_api_name);
372: FND_MSG_PUB.add;
373: x_return_status := fnd_api.g_ret_sts_unexp_error;
374: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
375:
376: END delete_table_attribute;
377: