APPS.OE_UPDATE_ACK_UTIL dependencies on FND_API

Line 143: l_first_ack_date DATE := fnd_api.g_miss_date;

139: ,p_ack_code IN VARCHAR2
140: ) is
141:
142: l_api_name CONSTANT VARCHAR2(30) := 'Update_Line_Ack_First';
143: l_first_ack_date DATE := fnd_api.g_miss_date;
144: l_ack_code VARCHAR2(30);
145: l_header_id NUMBER;
146: BEGIN
147: begin

Line 388: l_return_status Varchar2(1) := FND_API.g_ret_sts_success;

384: And Acknowledgment_Flag Is Null
385: For Update;
386:
387: l_debug_level Constant Number := Oe_Debug_Pub.g_debug_level;
388: l_return_status Varchar2(1) := FND_API.g_ret_sts_success;
389:
390: l_sold_to_site_use_id Number;
391: l_sold_to_location Varchar2(40);
392: l_invoice_to_location Varchar2(40);

Line 438: x_return_status := FND_API.G_RET_STS_ERROR;

434: l_header_acks_rec.End_Customer_Site_Use_Id;
435:
436: If Header_Acks_Cur%NOTFOUND Then
437: Close Header_Acks_Cur;
438: x_return_status := FND_API.G_RET_STS_ERROR;
439: Return;
440: End If;
441:
442: -- Set the Org

Line 1093: x_return_status := FND_API.G_RET_STS_SUCCESS;

1089: Where Header_Id = p_header_id
1090: And Acknowledgment_flag Is Null;
1091:
1092:
1093: x_return_status := FND_API.G_RET_STS_SUCCESS;
1094:
1095: If l_debug_level > 0 Then
1096: Oe_Debug_Pub.Add('Exiting OE_Update_Ack_Util.write_ack_data_values');
1097: End If;

Line 1111: x_return_status := FND_API.G_RET_STS_ERROR;

1107: If l_debug_level > 0 Then
1108: Oe_Debug_Pub.Add('Others Exception in write_ack_data_values '||sqlerrm);
1109: End If;
1110:
1111: x_return_status := FND_API.G_RET_STS_ERROR;
1112:
1113: End write_ack_data_values;
1114:
1115:

Line 1237: If l_return_status = FND_API.G_RET_STS_SUCCESS Then

1233: (p_header_id => l_header_id,
1234: p_transaction_type => l_transaction_type,
1235: x_return_status => l_return_status);
1236:
1237: If l_return_status = FND_API.G_RET_STS_SUCCESS Then
1238: p_x_result := 'SUCCESS';
1239: fnd_message.set_name('ONT', 'OE_OI_OUTBOUND_TRIGGERED');
1240: fnd_message.set_token ('TRANSACTION', l_transaction_subtype);
1241: l_message_text := fnd_message.get;

Line 1375: x_return_status := FND_API.G_RET_STS_SUCCESS;

1371:
1372: l_parameter_list.DELETE;
1373: --Commit;
1374:
1375: x_return_status := FND_API.G_RET_STS_SUCCESS;
1376:
1377: /*
1378: OE_Acknowledgment_Pub.Raise_Event_XMLInt (
1379: p_order_source_id => p_order_source_id,

Line 1405: x_return_status := FND_API.G_RET_STS_ERROR;

1401:
1402: Exception
1403:
1404: When Others Then
1405: x_return_status := FND_API.G_RET_STS_ERROR;
1406: If l_debug_level > 0 Then
1407: Oe_Debug_Pub.Add('Others exception in Raise_Derive_Ack_Data_event');
1408: Oe_Debug_Pub.Add('Error: '||sqlerrm);
1409: End If;