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
219: fnd_msg_pub.Count_And_Get(p_count => x_msg_count
220: ,p_data => x_msg_data );
221: return;
222: end if;
223: l_attach_this_document := FALSE;
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 );
251: return;
252: end if;
253:
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:
282:
281:
282:
283: EXCEPTION
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:
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 );
297:
298:
299: WHEN OTHERS THEN
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;
305:
306: -- Get message count and data
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;
305:
306: -- Get message count and data
307: fnd_msg_pub.Count_And_Get(p_count => x_msg_count
303: fnd_msg_pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
304: end if;
305:
306: -- Get message count and data
307: fnd_msg_pub.Count_And_Get(p_count => x_msg_count
308: ,p_data => x_msg_data );
309:
310:
311:
365: oe_debug_pub.add( 'OFA:ADD_ATTACHMENTS_AUTOMATIC:AN EXCCEPTION HAS OCCURED' ) ;
366: END IF;
367:
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;
428: IF l_debug_level > 0 THEN
429: oe_debug_pub.add( 'OFA:CREATE_SHORT_TEXT_DOCUMENT:DOCUMENT TEXT IS NULL' ) ;
430: END IF;
431: fnd_message.set_name('FND', 'ATCHMT-NULL DOCUMENT');
432: fnd_msg_pub.add;
433: raise G_INVALID_PARAMETER_EXCEPTION;
434: end if;
435:
436: -- do the basic validations on security type
439: IF l_debug_level > 0 THEN
440: oe_debug_pub.add( 'OFA:CREATE_SHORT_TEXT_DOCUMENT:INVALID SECURITY COMBINATION' ) ;
441: END IF;
442: fnd_message.set_name('FND', 'SECURITY_TYPE_NULL');
443: fnd_msg_pub.add;
444: raise G_INVALID_PARAMETER_EXCEPTION;
445: end if;
446:
447: -- assign program update date to current date if this is a conc mgr call
468: oe_debug_pub.add( 'OFA:CREATE_SHORT_TEXT_DOCUMENT:INVALID CATEGORY ID' ) ;
469: END IF;
470: close C_CATEGORY;
471: fnd_message.set_name('FND', 'INVALID_DOCUMENT_CATEGORY');
472: fnd_msg_pub.add;
473: raise G_INVALID_PARAMETER_EXCEPTION;
474: else
475: close C_CATEGORY;
476: end if;
558: WHEN G_INVALID_PARAMETER_EXCEPTION THEN
559: IF l_debug_level > 0 THEN
560: oe_debug_pub.add( 'OFA:CREATE_SHORT_TEXT_DOCUMENT:AN INVALID PARAM EXCCEPTION HAS OCCURED' ) ;
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:
569: oe_debug_pub.add( 'OFA:CREATE_SHORT_TEXT_DOCUMENT:AN EXCCEPTION HAS OCCURED' ) ;
570: END IF;
571:
572: fnd_message.set_name('OE', 'CREATE_DOCUMENT_UNEXPECTED_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;
570: END IF;
571:
572: fnd_message.set_name('OE', 'CREATE_DOCUMENT_UNEXPECTED_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:
622: EXCEPTION
623: WHEN OTHERS THEN
624: /*
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: */