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

Line 51: RAISE Fnd_Api.G_EXC_ERROR;

47: x_object_id => l_object_id)
48: THEN
49: Fnd_Message.Set_Name('IBC', 'IBC_INVALID_FOLDER_NAME');
50: Fnd_Msg_Pub.ADD;
51: RAISE Fnd_Api.G_EXC_ERROR;
52: END IF;
53: END LOOP;
54:
55: -- Primary key validation check

Line 58: (px_Directory_Node_Rel_ID = FND_API.G_MISS_NUM))

54:
55: -- Primary key validation check
56:
57: IF ((px_Directory_Node_Rel_ID IS NULL) OR
58: (px_Directory_Node_Rel_ID = FND_API.G_MISS_NUM))
59: THEN
60: OPEN c2;
61: FETCH c2 INTO px_Directory_Node_Rel_ID;
62: CLOSE c2;

Line 80: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

76: px_Directory_Node_Rel_ID ,
77: p_CHILD_DIR_NODE_ID,
78: p_PARENT_DIR_NODE_ID,
79: p_OBJECT_VERSION_NUMBER,
80: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
81: p_creation_date),
82: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
83: NULL, FND_GLOBAL.user_id, p_created_by),
84: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

Line 82: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

78: p_PARENT_DIR_NODE_ID,
79: p_OBJECT_VERSION_NUMBER,
80: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
81: p_creation_date),
82: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
83: NULL, FND_GLOBAL.user_id, p_created_by),
84: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
85: p_last_update_date),
86: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 84: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

80: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
81: p_creation_date),
82: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
83: NULL, FND_GLOBAL.user_id, p_created_by),
84: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
85: p_last_update_date),
86: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
87: NULL, FND_GLOBAL.user_id, p_last_updated_by),
88: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

Line 86: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

82: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
83: NULL, FND_GLOBAL.user_id, p_created_by),
84: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
85: p_last_update_date),
86: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
87: NULL, FND_GLOBAL.user_id, p_last_updated_by),
88: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
89: NULL, FND_GLOBAL.login_id, p_last_update_login)
90: );

Line 88: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

84: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
85: p_last_update_date),
86: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
87: NULL, FND_GLOBAL.user_id, p_last_updated_by),
88: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
89: NULL, FND_GLOBAL.login_id, p_last_update_login)
90: );
91:
92: OPEN c;

Line 164: RAISE Fnd_Api.G_EXC_ERROR;

160: x_object_id => l_object_id)
161: THEN
162: Fnd_Message.Set_Name('IBC', 'IBC_INVALID_FOLDER_NAME');
163: Fnd_Msg_Pub.ADD;
164: RAISE Fnd_Api.G_EXC_ERROR;
165: END IF;
166: END LOOP;
167:
168: UPDATE IBC_DIRECTORY_NODE_RELS SET

Line 169: CHILD_DIR_NODE_ID = DECODE(p_CHILD_DIR_NODE_ID,FND_API.G_MISS_NUM,NULL,NULL,CHILD_DIR_NODE_ID,p_CHILD_DIR_NODE_ID),

165: END IF;
166: END LOOP;
167:
168: UPDATE IBC_DIRECTORY_NODE_RELS SET
169: CHILD_DIR_NODE_ID = DECODE(p_CHILD_DIR_NODE_ID,FND_API.G_MISS_NUM,NULL,NULL,CHILD_DIR_NODE_ID,p_CHILD_DIR_NODE_ID),
170: PARENT_DIR_NODE_ID = DECODE(p_PARENT_DIR_NODE_ID,FND_API.G_MISS_NUM,NULL,NULL,PARENT_DIR_NODE_ID,p_PARENT_DIR_NODE_ID),
171: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
172: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
173: NULL, SYSDATE, p_last_update_date),

Line 170: PARENT_DIR_NODE_ID = DECODE(p_PARENT_DIR_NODE_ID,FND_API.G_MISS_NUM,NULL,NULL,PARENT_DIR_NODE_ID,p_PARENT_DIR_NODE_ID),

166: END LOOP;
167:
168: UPDATE IBC_DIRECTORY_NODE_RELS SET
169: CHILD_DIR_NODE_ID = DECODE(p_CHILD_DIR_NODE_ID,FND_API.G_MISS_NUM,NULL,NULL,CHILD_DIR_NODE_ID,p_CHILD_DIR_NODE_ID),
170: PARENT_DIR_NODE_ID = DECODE(p_PARENT_DIR_NODE_ID,FND_API.G_MISS_NUM,NULL,NULL,PARENT_DIR_NODE_ID,p_PARENT_DIR_NODE_ID),
171: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
172: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
173: NULL, SYSDATE, p_last_update_date),
174: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,

Line 172: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,

168: UPDATE IBC_DIRECTORY_NODE_RELS SET
169: CHILD_DIR_NODE_ID = DECODE(p_CHILD_DIR_NODE_ID,FND_API.G_MISS_NUM,NULL,NULL,CHILD_DIR_NODE_ID,p_CHILD_DIR_NODE_ID),
170: PARENT_DIR_NODE_ID = DECODE(p_PARENT_DIR_NODE_ID,FND_API.G_MISS_NUM,NULL,NULL,PARENT_DIR_NODE_ID,p_PARENT_DIR_NODE_ID),
171: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
172: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
173: NULL, SYSDATE, p_last_update_date),
174: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
175: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
176: p_last_updated_by),

Line 174: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,

170: PARENT_DIR_NODE_ID = DECODE(p_PARENT_DIR_NODE_ID,FND_API.G_MISS_NUM,NULL,NULL,PARENT_DIR_NODE_ID,p_PARENT_DIR_NODE_ID),
171: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
172: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
173: NULL, SYSDATE, p_last_update_date),
174: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
175: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
176: p_last_updated_by),
177: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
178: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

Line 177: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,

173: NULL, SYSDATE, p_last_update_date),
174: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
175: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
176: p_last_updated_by),
177: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
178: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
179: p_last_update_login)
180: WHERE Directory_Node_Rel_ID = p_Directory_Node_Rel_ID
181: AND object_version_number = DECODE(p_object_version_number,

Line 182: FND_API.G_MISS_NUM,object_version_number,

178: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
179: p_last_update_login)
180: WHERE Directory_Node_Rel_ID = p_Directory_Node_Rel_ID
181: AND object_version_number = DECODE(p_object_version_number,
182: FND_API.G_MISS_NUM,object_version_number,
183: NULL,object_version_number,
184: p_object_version_number);
185:
186: IF (SQL%NOTFOUND) THEN

Line 235: RAISE Fnd_Api.G_EXC_ERROR;

231: x_object_id => l_object_id)
232: THEN
233: Fnd_Message.Set_Name('IBC', 'IBC_INVALID_FOLDER_NAME');
234: Fnd_Msg_Pub.ADD;
235: RAISE Fnd_Api.G_EXC_ERROR;
236: END IF;
237: END LOOP;
238:
239: DECLARE

Line 260: FND_API.G_MISS_NUM,object_version_number,

256: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
257: FROM IBC_DIRECTORY_NODE_RELS
258: WHERE Directory_Node_Rel_ID = p_Directory_Node_Rel_ID
259: AND object_version_number = DECODE(object_version_number,
260: FND_API.G_MISS_NUM,object_version_number,
261: NULL,object_version_number,
262: object_version_number);
263:
264: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,

Line 269: p_CHILD_DIR_NODE_ID => nvl(p_child_dir_NODE_ID,FND_API.G_MISS_NUM),

265: db_user_id, db_last_update_date, p_upload_mode )) THEN
266:
267: Ibc_Directory_Node_Rels_Pkg.UPDATE_ROW (
268: p_DIRECTORY_NODE_REL_ID => p_DIRECTORY_NODE_REL_ID ,
269: p_CHILD_DIR_NODE_ID => nvl(p_child_dir_NODE_ID,FND_API.G_MISS_NUM),
270: p_PARENT_DIR_NODE_ID => nvl(p_pARENT_dir_NODE_ID,FND_API.G_MISS_NUM),
271: p_LAST_UPDATED_BY => l_user_id,
272: p_LAST_UPDATE_DATE => sysdate,
273: p_LAST_UPDATE_LOGIN => 0,

Line 270: p_PARENT_DIR_NODE_ID => nvl(p_pARENT_dir_NODE_ID,FND_API.G_MISS_NUM),

266:
267: Ibc_Directory_Node_Rels_Pkg.UPDATE_ROW (
268: p_DIRECTORY_NODE_REL_ID => p_DIRECTORY_NODE_REL_ID ,
269: p_CHILD_DIR_NODE_ID => nvl(p_child_dir_NODE_ID,FND_API.G_MISS_NUM),
270: p_PARENT_DIR_NODE_ID => nvl(p_pARENT_dir_NODE_ID,FND_API.G_MISS_NUM),
271: p_LAST_UPDATED_BY => l_user_id,
272: p_LAST_UPDATE_DATE => sysdate,
273: p_LAST_UPDATE_LOGIN => 0,
274: p_OBJECT_VERSION_NUMBER => NULL);

Line 313: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

309: ,x_return_status => x_return_status
310: ,x_msg_count => x_msg_count
311: ,x_msg_data => x_msg_data
312: );
313: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316: END;
317:

Line 314: RAISE FND_API.G_EXC_ERROR;

310: ,x_msg_count => x_msg_count
311: ,x_msg_data => x_msg_data
312: );
313: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316: END;
317:
318: END LOAD_ROW;