APPS.OE_XML_PROCESS_UTIL dependencies on FND_API

Line 214: x_return_status := FND_API.G_RET_STS_SUCCESS;

210: From hr_all_organization_units hu, hr_locations hl
211: Where hl.location_id = hu.location_id
212: And hu.organization_id = p_site_use_id;
213:
214: x_return_status := FND_API.G_RET_STS_SUCCESS;
215:
216: Else
217:
218: Select /* MOAC_SQL_CHANGE */ Site.Location,

Line 254: x_return_status := FND_API.G_RET_STS_SUCCESS;

250: And Site.Site_Use_Id = p_site_use_id
251: And Acct_Site.Cust_Account_id = Cust_Accts.Cust_Account_id
252: And Party.Party_Id = Cust_Accts.Party_Id;
253:
254: x_return_status := FND_API.G_RET_STS_SUCCESS;
255:
256: End If;
257:
258: If l_debug_level > 0 Then

Line 268: x_return_status := FND_API.G_RET_STS_ERROR;

264: When Others Then
265: If l_debug_level > 0 Then
266: Oe_Debug_Pub.Add('Unable to derive address values for Ack');
267: End If;
268: x_return_status := FND_API.G_RET_STS_ERROR;
269:
270: End Get_Address_Details;
271:
272: Procedure Get_Contact_Details

Line 302: x_return_status := FND_API.G_RET_STS_SUCCESS;

298: And b.object_table_name = 'HZ_PARTIES'
299: And c.cust_account_id = p_cust_acct_id
300: And b.directional_flag = 'F';
301:
302: x_return_status := FND_API.G_RET_STS_SUCCESS;
303:
304: Exception
305:
306: When Others Then

Line 310: x_return_status := FND_API.G_RET_STS_ERROR;

306: When Others Then
307: If l_debug_level > 0 Then
308: Oe_Debug_Pub.Add('Unable to derive Contact info for Ack '||sqlerrm);
309: End If;
310: x_return_status := FND_API.G_RET_STS_ERROR;
311:
312: End Get_Contact_Details;
313:
314:

Line 439: x_result := FND_API.G_RET_STS_SUCCESS;

435:
436: -- { Start If p_ack_code
437: /* If p_ack_code = '0' Then
438: x_error_text := 'Accepted';
439: x_result := FND_API.G_RET_STS_SUCCESS;
440: IF l_debug_level > 0 THEN
441: oe_debug_pub.add( 'EXITING GET_PROCESSING_MSGS WITH ACCEPTED' ) ;
442: END IF;
443: Return;

Line 502: x_result := FND_API.G_RET_STS_SUCCESS;

498: l_error_text := 'Pending';
499: End If;
500: End If;
501: x_error_text := l_error_text;
502: x_result := FND_API.G_RET_STS_SUCCESS;
503: IF l_debug_level > 0 THEN
504: oe_debug_pub.add( 'EXITING GET_PROCESSING_MSGS' ) ;
505: END IF;
506: Exception

Line 511: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

507: When Others Then
508: IF l_debug_level > 0 THEN
509: oe_debug_pub.add( 'OTHERS ERROR IN GETTING ERROR MESSAGE. SQLERR: ' || SQLERRM ) ;
510: END IF;
511: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
512: IF l_debug_level > 0 THEN
513: oe_debug_pub.add( 'EXITING GET_PROCESSING_MSGS' ) ;
514: END IF;
515: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 865: --AND nvl(p_ordered_quantity, FND_API.G_MISS_NUM) <> 0

861: x_insert_flag := 'N';
862: ELSIF (nvl(p_line_ack_code,'0')= '2' OR nvl(p_shipment_ack_code,'0') = '2')
863: --AND nvl(p_response_profile,'N') = 'Y'
864: --AND nvl(p_response_flag,'N') = 'Y'
865: --AND nvl(p_ordered_quantity, FND_API.G_MISS_NUM) <> 0
866: THEN
867: x_insert_flag := 'N';
868: END IF;
869: END IF;