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

Line 21: p_commit in varchar2 default fnd_api.G_FALSE,

17: p_pk3_value in varchar2 default null,
18: p_pk4_value in varchar2 default null,
19: p_pk5_value in varchar2 default null,
20: p_automatic_flag in varchar2 default 'N',
21: p_commit in varchar2 default fnd_api.G_FALSE,
22: p_document_id in number,
23: x_attachment_id out NOCOPY /* file.sql.39 change */ number,
24: x_return_status out NOCOPY /* file.sql.39 change */ varchar2,
25: x_msg_count out NOCOPY /* file.sql.39 change */ number,

Line 70: if not fnd_api.compatible_api_call( l_api_version

66: END IF;
67:
68: -- Standard call to check for call compatibility
69: -----------------------------------------------------------------------
70: if not fnd_api.compatible_api_call( l_api_version
71: , p_api_version
72: , l_api_name
73: , G_PKG_NAME
74: ) then

Line 75: raise fnd_api.G_EXC_UNEXPECTED_ERROR;

71: , p_api_version
72: , l_api_name
73: , G_PKG_NAME
74: ) then
75: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
76: end if;
77:
78: -- we need to attach the documents only if it is not already attached
79: --------------------------------------------------------------------------

Line 136: p_commit in varchar2 default fnd_api.G_FALSE,

132: p_pk4_value in varchar2 default null,
133: p_pk5_value in varchar2 default null,
134: p_process_flag in varchar2 default G_RETURN_ON_ERROR,
135: p_automatic_attachment in varchar2 default 'N',
136: p_commit in varchar2 default fnd_api.G_FALSE,
137: p_document_tbl in out NOCOPY /* file.sql.39 change */ Documet_Tbl_Type,
138: x_return_status out NOCOPY /* file.sql.39 change */ varchar2,
139: x_msg_count out NOCOPY /* file.sql.39 change */ number,
140: x_msg_data out NOCOPY /* file.sql.39 change */ varchar2

Line 169: if not fnd_api.compatible_api_call( l_api_version

165: BEGIN
166:
167: -- Standard call to check for call compatibility
168: -----------------------------------------------------------------------
169: if not fnd_api.compatible_api_call( l_api_version
170: , p_api_version
171: , l_api_name
172: , G_PKG_NAME
173: ) then

Line 174: raise fnd_api.G_EXC_UNEXPECTED_ERROR;

170: , p_api_version
171: , l_api_name
172: , G_PKG_NAME
173: ) then
174: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
175: end if;
176:
177:
178:

Line 214: if (l_return_status <> fnd_api.G_RET_STS_SUCCESS) then

210: x_return_status => l_return_status,
211: x_msg_count => l_msg_count,
212: x_msg_data => l_msg_data
213: );
214: if (l_return_status <> fnd_api.G_RET_STS_SUCCESS) then
215: if (p_process_flag = G_RETURN_ON_ERROR) then
216: -- terminate process
217: x_return_status := l_return_status;
218: -- Get message count and data

Line 246: x_return_status := fnd_api.G_RET_STS_ERROR;

242: end if;
243:
244: if (l_attach_this_document = FALSE AND p_process_flag = G_RETURN_ON_ERROR) then
245: -- terminate process
246: x_return_status := fnd_api.G_RET_STS_ERROR;
247: -- add the error message
248: -- Get message count and data
249: fnd_msg_pub.Count_And_Get(p_count => x_msg_count
250: ,p_data => x_msg_data );

Line 277: x_return_status := fnd_api.G_RET_STS_SUCCESS;

273: end if;
274: -- end of loop
275: --------------
276: end loop;
277: x_return_status := fnd_api.G_RET_STS_SUCCESS;
278: fnd_msg_pub.count_and_get( p_count => x_msg_count,
279: p_data => x_msg_data
280: );
281:

Line 288: x_return_status := fnd_api.G_RET_STS_ERROR;

284: WHEN G_INVALID_PARAMETER_EXCEPTION THEN
285: fnd_msg_pub.count_and_get( p_count => x_msg_count,
286: p_data => x_msg_data
287: );
288: x_return_status := fnd_api.G_RET_STS_ERROR;
289:
290: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
291:
292: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

Line 290: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

286: p_data => x_msg_data
287: );
288: x_return_status := fnd_api.G_RET_STS_ERROR;
289:
290: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
291:
292: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
293:
294: -- Get message count and data

Line 292: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;

288: x_return_status := fnd_api.G_RET_STS_ERROR;
289:
290: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
291:
292: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR ;
293:
294: -- Get message count and data
295: fnd_msg_pub.Count_And_Get(p_count => x_msg_count
296: ,p_data => x_msg_data );

Line 300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

296: ,p_data => x_msg_data );
297:
298:
299: WHEN OTHERS THEN
300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
301:
302: if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) then
303: fnd_msg_pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
304: end if;

Line 325: p_commit in varchar2 default fnd_api.G_FALSE,

321: p_pk2_value in varchar2 default null,
322: p_pk3_value in varchar2 default null,
323: p_pk4_value in varchar2 default null,
324: p_pk5_value in varchar2 default null,
325: p_commit in varchar2 default fnd_api.G_FALSE,
326: x_attachment_count out NOCOPY /* file.sql.39 change */ number,
327: x_return_status out NOCOPY /* file.sql.39 change */ varchar2,
328: x_msg_count out NOCOPY /* file.sql.39 change */ number,
329: x_msg_data out NOCOPY /* file.sql.39 change */ varchar2

Line 372: x_return_status := fnd_api.G_RET_STS_ERROR;

368: fnd_message.set_name('OE', 'OE_APPLY_ATTACHMENT_EXCEPTION');
369: fnd_msg_pub.count_and_get( p_count => x_msg_count,
370: p_data => x_msg_data
371: );
372: x_return_status := fnd_api.G_RET_STS_ERROR;
373: END Add_Attachments_Automatic;
374:
375: --------------------------------------------------------------------------------------
376: PROCEDURE Create_Short_Text_Document

Line 389: p_commit in varchar2 default fnd_api.G_FALSE,

385: p_publish_flag in varchar2 default 'Y',
386: p_usage_type in varchar2,
387: p_start_date_active in date default sysdate,
388: p_end_date_active in date default null,
389: p_commit in varchar2 default fnd_api.G_FALSE,
390: x_document_id out NOCOPY /* file.sql.39 change */ number,
391: x_return_status out NOCOPY /* file.sql.39 change */ varchar2,
392: x_msg_count out NOCOPY /* file.sql.39 change */ number,
393: x_msg_data out NOCOPY /* file.sql.39 change */ varchar2

Line 549: if(p_commit = fnd_api.G_TRUE) then

545: );
546:
547: -- if commit is requested then commit the work
548: ----------------------------------------------
549: if(p_commit = fnd_api.G_TRUE) then
550: commit;
551: end if;
552: IF l_debug_level > 0 THEN
553: oe_debug_pub.add( 'OFA:CREATE_SHORT_TEXT_DOCUMENT:END' ) ;

Line 565: x_return_status := fnd_api.G_RET_STS_ERROR;

561: END IF;
562: fnd_msg_pub.count_and_get( p_count => x_msg_count,
563: p_data => x_msg_data
564: );
565: x_return_status := fnd_api.G_RET_STS_ERROR;
566:
567: WHEN OTHERS THEN
568: IF l_debug_level > 0 THEN
569: oe_debug_pub.add( 'OFA:CREATE_SHORT_TEXT_DOCUMENT:AN EXCCEPTION HAS OCCURED' ) ;

Line 577: x_return_status := fnd_api.G_RET_STS_ERROR;

573: fnd_msg_pub.add;
574: fnd_msg_pub.count_and_get( p_count => x_msg_count,
575: p_data => x_msg_data
576: );
577: x_return_status := fnd_api.G_RET_STS_ERROR;
578:
579: END Create_Short_Text_Document;
580:
581:

Line 629: x_return_status := fnd_api.G_RET_STS_ERROR;

625: fnd_message.set_name('OE', 'OE_COPY_ATTACHMENT_EXCEPTION');
626: fnd_msg_pub.count_and_get( p_count => x_msg_count,
627: p_data => x_msg_data
628: );
629: x_return_status := fnd_api.G_RET_STS_ERROR;
630: */
631: null;
632: END Copy_Attachments;
633: