APPS.OE_UPDATE_ACK_UTIL dependencies on FND_API

Line 144: l_first_ack_date DATE := fnd_api.g_miss_date;

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

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

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

Line 439: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1094: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1112: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1238: If l_return_status = FND_API.G_RET_STS_SUCCESS Then

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

Line 1376: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1406: x_return_status := FND_API.G_RET_STS_ERROR;

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