APPS.OE_ELECMSGS_PVT dependencies on FND_API

Line 494: x_return_status := FND_API.G_RET_STS_ERROR;

490: /* Validation to ensure that none of the primary key elements is NULL */
491: IF (p_order_source_id IS NULL OR p_sold_to_org_id IS NULL
492: OR p_orig_sys_document_ref IS NULL OR p_transaction_type IS NULL OR p_document_id IS NULL) THEN
493: --oe_debug_pub.add('Insufficient key params to insert,returning');
494: x_return_status := FND_API.G_RET_STS_ERROR;
495: return;
496: END IF;
497: --oe_debug_pub.add('before insert');
498:

Line 549: x_return_status := FND_API.G_RET_STS_SUCCESS;

545: p_header_id,
546: p_document_disposition,
547: p_last_update_itemkey
548: );
549: x_return_status := FND_API.G_RET_STS_SUCCESS;
550: IF l_debug_level > 0 THEN
551: oe_debug_pub.add('Insert succeeded'||SQL%ROWCOUNT||' de'||SQLERRM);
552: END IF;
553: EXCEPTION

Line 558: x_return_status := FND_API.G_RET_STS_ERROR;

554: WHEN DUP_VAL_ON_INDEX THEN
555: IF l_debug_level > 0 THEN
556: oe_debug_pub.add('DUPLICATE INDEX VALUE IN OEXVELMB.Create History Entry, update instead of insert'||SQLERRM);
557: END IF;
558: x_return_status := FND_API.G_RET_STS_ERROR;
559: WHEN OTHERS THEN
560: IF l_debug_level > 0 THEN
561: oe_debug_pub.add('OTHERS IN OEXVELMB.Create History Entry'||SQLERRM);
562: END IF;

Line 563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

559: WHEN OTHERS THEN
560: IF l_debug_level > 0 THEN
561: oe_debug_pub.add('OTHERS IN OEXVELMB.Create History Entry'||SQLERRM);
562: END IF;
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: END Create_History_Entry;
565:
566: PROCEDURE Update_History_Entry (
567: p_order_source_id IN NUMBER,

Line 596: x_return_status := FND_API.G_RET_STS_ERROR;

592: OR p_orig_sys_document_ref IS NULL OR p_transaction_type IS NULL OR p_document_id IS NULL) THEN
593: IF l_debug_level > 0 THEN
594: oe_debug_pub.add ('Electronic Messages: One or more key elements are null');
595: END IF;
596: x_return_status := FND_API.G_RET_STS_ERROR;
597: return;
598: END IF;
599:
600: /* Insertion -- what should the behaviour be if org_id is null */

Line 625: x_return_status := FND_API.G_RET_STS_SUCCESS;

621:
622: IF l_debug_level > 0 THEN
623: oe_debug_pub.add('Number of rows updated: ' || SQL%ROWCOUNT);
624: END IF;
625: x_return_status := FND_API.G_RET_STS_SUCCESS;
626:
627: EXCEPTION
628: WHEN OTHERS THEN
629: /* log appropriate debug/error messages and return */

Line 633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

629: /* log appropriate debug/error messages and return */
630: IF l_debug_level > 0 THEN
631: oe_debug_pub.add('OTHERS IN OEXVELMB.Update History Entry');
632: END IF;
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634:
635: END Update_History_Entry;
636:
637:

Line 1035: IF l_result = FND_API.G_RET_STS_ERROR THEN -- this return status indicates duplicate index value

1031: p_last_update_itemkey => l_curr_itemkey,
1032: x_return_status => l_result
1033: );
1034:
1035: IF l_result = FND_API.G_RET_STS_ERROR THEN -- this return status indicates duplicate index value
1036: IF OE_ELECMSGS_PVT.Find_History_Entry ( p_order_source_id => l_order_source_id,
1037: p_sold_to_org_id => l_sold_to_org_id,
1038: p_orig_sys_document_ref => l_orig_sys_document_ref,
1039: p_transaction_type => l_transaction_type,

Line 1101: --p_x_result := FND_API.G_RET_STS_UNEXP_ERROR;

1097: -- don't put the error activity call for exception management
1098: -- since it doesn't make sense here
1099: OE_STANDARD_WF.Save_Messages;
1100: OE_STANDARD_WF.Clear_Msg_Context;
1101: --p_x_result := FND_API.G_RET_STS_UNEXP_ERROR;
1102:
1103: raise;
1104:
1105:

Line 1232: IF l_sold_to_org_Id = FND_API.G_MISS_NUM THEN

1228: /* this code is no longer necessary as the sold_to_org_id will now be passed in (bug 3396735)
1229: IF p_customer_number IS NOT NULL THEN
1230:
1231: l_sold_to_org_id := OE_Value_To_Id.sold_to_org (p_sold_to_org => NULL,p_customer_number => p_customer_number);
1232: IF l_sold_to_org_Id = FND_API.G_MISS_NUM THEN
1233: IF l_debug_level > 0 THEN
1234: oe_debug_pub.add('Sold To Org Id cannot be derived - returning');
1235: END IF;
1236: retcode := 2;

Line 3138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3134: , 'ADD_ACCESS'
3135: );
3136: END IF;
3137:
3138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3139: END Add_Access;
3140:
3141:
3142: END OE_ELECMSGS_PVT;