APPS.OE_ACKNOWLEDGMENT_PUB dependencies on FND_API

Line 220: x_return_status := FND_API.G_RET_STS_SUCCESS;

216: x_is_delivery_required => l_is_delivery_reqd,
217: x_return_status => l_return_status
218: );
219: If nvl(l_is_delivery_reqd, 'N') = 'N' Then
220: x_return_status := FND_API.G_RET_STS_SUCCESS;
221: return;
222: End If;
223: END IF;
224: END IF;

Line 303: x_return_status := FND_API.G_RET_STS_SUCCESS;

299: -- The Business Event System is unlikely to return any errors
300: -- As long as the Raise can be submitted, any errors will be placed
301: -- on the WF_ERROR queue and a notification sent to SYSADMIN
302:
303: x_return_status := FND_API.G_RET_STS_SUCCESS;
304:
305: IF l_debug_level > 0 THEN
306: oe_debug_pub.add( 'EXITING RAISE_EVENT_FROM_OEOI' ) ;
307: END IF;

Line 313: x_return_status := FND_API.G_RET_STS_ERROR;

309: when others then
310: IF l_debug_level > 0 THEN
311: oe_debug_pub.add( 'ENCOUNTERED OTHERS EXCEPTION IN RAISE_EVENT_FROM_OEOI' ) ;
312: END IF;
313: x_return_status := FND_API.G_RET_STS_ERROR;
314: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
315: THEN
316: FND_MSG_PUB.Add_Exc_Msg
317: (G_PKG_NAME, 'OE_Acknowledgment_Pub.Raise_Event_From_Oeoi');

Line 510: x_return_status := FND_API.G_RET_STS_SUCCESS;

506: -- The Business Event System is unlikely to return any errors
507: -- As long as the Raise can be submitted, any errors will be placed
508: -- on the WF_ERROR queue and a notification sent to SYSADMIN
509:
510: x_return_status := FND_API.G_RET_STS_SUCCESS;
511:
512: IF l_debug_level > 0 THEN
513: oe_debug_pub.add( 'EXITING RAISE_EVENT_SHOWSO' ) ;
514: END IF;

Line 520: x_return_status := FND_API.G_RET_STS_ERROR;

516: when others then
517: IF l_debug_level > 0 THEN
518: oe_debug_pub.add( 'ENCOUNTERED OTHERS EXCEPTION IN RAISE_EVENT_SHOWSO: ' || sqlerrm) ;
519: END IF;
520: x_return_status := FND_API.G_RET_STS_ERROR;
521: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
522: THEN
523: FND_MSG_PUB.Add_Exc_Msg
524: (G_PKG_NAME, 'OE_Acknowledgment_Pub.Raise_Event_Showso');

Line 532: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

528: -- End of Procedure to raise 3a6 event}
529:
530: PROCEDURE Process_Acknowledgment
531: (p_api_version_number IN NUMBER
532: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
533:
534: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
535: OE_Order_Pub.G_MISS_HEADER_REC
536: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=

Line 616: IF NOT FND_API.Compatible_API_Call

612:
613: IF l_debug_level > 0 THEN
614: oe_debug_pub.add( 'Entering Process Acknowledgment');
615: END IF;
616: IF NOT FND_API.Compatible_API_Call
617: ( l_api_version_number
618: , p_api_version_number
619: , l_api_name
620: , G_PKG_NAME

Line 626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

622: THEN
623: IF l_debug_level > 0 THEN
624: oe_debug_pub.add( 'OEXPACKB COMPATIBLE_API_CALL' ) ;
625: END IF;
626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
627: END IF;
628:
629: IF l_debug_level > 0 THEN
630: oe_debug_pub.add( 'BEFORE CALLING PRIVATE ACKNOWLEDGMENT API' ) ;

Line 680: WHEN FND_API.G_EXC_ERROR THEN

676: END IF;
677:
678: EXCEPTION
679:
680: WHEN FND_API.G_EXC_ERROR THEN
681: IF l_debug_level > 0 THEN
682: oe_debug_pub.add( 'ENCOUNTERED ERROR EXCEPTION' ) ;
683: END IF;
684: x_return_status := FND_API.G_RET_STS_ERROR;

Line 684: x_return_status := FND_API.G_RET_STS_ERROR;

680: WHEN FND_API.G_EXC_ERROR THEN
681: IF l_debug_level > 0 THEN
682: oe_debug_pub.add( 'ENCOUNTERED ERROR EXCEPTION' ) ;
683: END IF;
684: x_return_status := FND_API.G_RET_STS_ERROR;
685:
686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
687: IF l_debug_level > 0 THEN
688: oe_debug_pub.add( 'ENCOUNTERED UNEXPECTED ERROR EXCEPTION' ) ;

Line 686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

682: oe_debug_pub.add( 'ENCOUNTERED ERROR EXCEPTION' ) ;
683: END IF;
684: x_return_status := FND_API.G_RET_STS_ERROR;
685:
686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
687: IF l_debug_level > 0 THEN
688: oe_debug_pub.add( 'ENCOUNTERED UNEXPECTED ERROR EXCEPTION' ) ;
689: END IF;
690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
687: IF l_debug_level > 0 THEN
688: oe_debug_pub.add( 'ENCOUNTERED UNEXPECTED ERROR EXCEPTION' ) ;
689: END IF;
690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
691:
692: WHEN OTHERS THEN
693: IF l_debug_level > 0 THEN
694: oe_debug_pub.add( 'ENCOUNTERED OTHERS ERROR EXCEPTION IN OE_ACKNOWLEDGMENT_PUB.PROCESS_ACKNOWLEDGMENT: '|| SQLERRM ) ;

Line 696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

692: WHEN OTHERS THEN
693: IF l_debug_level > 0 THEN
694: oe_debug_pub.add( 'ENCOUNTERED OTHERS ERROR EXCEPTION IN OE_ACKNOWLEDGMENT_PUB.PROCESS_ACKNOWLEDGMENT: '|| SQLERRM ) ;
695: END IF;
696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
697:
698: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
699: THEN
700: FND_MSG_PUB.Add_Exc_Msg

Line 788: x_return_status := FND_API.G_RET_STS_SUCCESS;

784: if sql%rowcount > 0 then
785: IF l_debug_level > 0 THEN
786: oe_debug_pub.add( 'INSERTED HEADER_ID => ' || P_HEADER_REC.HEADER_ID ) ;
787: END IF;
788: x_return_status := FND_API.G_RET_STS_SUCCESS;
789: else
790: IF l_debug_level > 0 THEN
791: oe_debug_pub.add( 'NOT INSERTED HEADER_ID => ' || P_HEADER_REC.HEADER_ID ) ;
792: END IF;

Line 793: x_return_status := FND_API.G_RET_STS_ERROR;

789: else
790: IF l_debug_level > 0 THEN
791: oe_debug_pub.add( 'NOT INSERTED HEADER_ID => ' || P_HEADER_REC.HEADER_ID ) ;
792: END IF;
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: end if;
795:
796: IF l_debug_level > 0 THEN
797: oe_debug_pub.add( 'EXITING: OEXPACK PROCEDURE INSERT_HEADER' ) ;

Line 837: x_return_status := FND_API.G_RET_STS_SUCCESS;

833: if sql%rowcount > 0 then
834: IF l_debug_level > 0 THEN
835: oe_debug_pub.add( 'INSERTED LINE_ID => ' || P_LINE_REC.LINE_ID ) ;
836: END IF;
837: x_return_status := FND_API.G_RET_STS_SUCCESS;
838: else
839: IF l_debug_level > 0 THEN
840: oe_debug_pub.add( 'NOT INSERTED LINE_ID => ' || P_LINE_REC.LINE_ID ) ;
841: END IF;

Line 842: x_return_status := FND_API.G_RET_STS_ERROR;

838: else
839: IF l_debug_level > 0 THEN
840: oe_debug_pub.add( 'NOT INSERTED LINE_ID => ' || P_LINE_REC.LINE_ID ) ;
841: END IF;
842: x_return_status := FND_API.G_RET_STS_ERROR;
843: end if;
844:
845: IF l_debug_level > 0 THEN
846: oe_debug_pub.add( 'EXITING: OEXPACK PROCEDURE INSERT_LINE' ) ;

Line 879: l_return_status Varchar2(1) := fnd_api.g_ret_sts_success;

875: l_line_count Number := 0;
876: l_order_source_id Number;
877: l_orig_sys_document_ref Varchar2(50);
878: l_change_sequence Varchar2(50);
879: l_return_status Varchar2(1) := fnd_api.g_ret_sts_success;
880: l_customer_key_profile VARCHAR2(1) := 'N';
881:
882:
883: -- { Start of Header Interface Cursor

Line 1078: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1074:
1075:
1076: PROCEDURE Process_Xml_Acknowledgment
1077: ( p_api_version_number IN NUMBER := 1,
1078: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1079: p_order_source_id IN NUMBER := G_XML_ORDER_SOURCE_ID,
1080: p_orig_sys_document_ref IN VARCHAR2,
1081: p_sold_to_org_id IN NUMBER,
1082: p_change_sequence IN VARCHAR2,

Line 1110: l_return_status Varchar2(1) := fnd_api.g_ret_sts_success;

1106: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
1107: l_header_id Number;
1108: l_header_last_ack_code Varchar2(30);
1109: l_reject_order Varchar2(1) := 'Y';
1110: l_return_status Varchar2(1) := fnd_api.g_ret_sts_success;
1111: l_line_id Number;
1112: l_line_ack_id Number;
1113: l_line_last_ack_code Varchar2(30);
1114: l_ind_cntr Number;

Line 1348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;--FND_API.G_RET_STS_SUCCESS;

1344: End If;
1345:
1346: Exception
1347: When Others Then
1348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;--FND_API.G_RET_STS_SUCCESS;
1349: IF l_debug_level > 0 THEN
1350: oe_debug_pub.add( 'QUERY FROM OE_ORDER_HEADERS_ALL TABLE FAILED. ACK. NOT SEND: ' || sqlerrm) ;
1351: END IF;
1352: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');

Line 1355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1351: END IF;
1352: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1353: fnd_message.set_token ('TABLE', 'oe_order_headers');
1354: oe_msg_pub.add;
1355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1356: --RETURN;
1357: End;
1358: -- End Header query}
1359:

Line 1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --FND_API.G_RET_STS_SUCCESS;

1440: Close Cancel_Line_Ack_Cur;
1441: End If;
1442: Exception
1443: When Others Then
1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --FND_API.G_RET_STS_SUCCESS;
1445: IF l_debug_level > 0 THEN
1446: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;
1447: END IF;
1448: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');

Line 1451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1447: END IF;
1448: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1449: fnd_message.set_token ('TABLE', 'oe_order_lines');
1450: oe_msg_pub.add;
1451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1452: --RETURN;
1453: End;
1454:
1455: End If;

Line 1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;--FND_API.G_RET_STS_SUCCESS;

1502:
1503: End If;
1504: Exception
1505: When Others Then
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;--FND_API.G_RET_STS_SUCCESS;
1507: IF l_debug_level > 0 THEN
1508: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;
1509: END IF;
1510: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');

Line 1513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1509: END IF;
1510: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1511: fnd_message.set_token ('TABLE', 'oe_order_lines');
1512: oe_msg_pub.add;
1513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1514: --RETURN;
1515: End;
1516: -- End Line query}
1517:

Line 1559: If l_return_status = fnd_api.g_ret_sts_unexp_error Then

1555: , p_reject_order => l_reject_order
1556: , p_ack_type => l_acknowledgment_type
1557: , x_return_status => l_return_status
1558: );
1559: If l_return_status = fnd_api.g_ret_sts_unexp_error Then
1560: raise fnd_api.g_exc_unexpected_error;
1561: Elsif l_return_status = fnd_api.g_ret_sts_error Then
1562: raise fnd_api.g_exc_error;
1563: End If;

Line 1560: raise fnd_api.g_exc_unexpected_error;

1556: , p_ack_type => l_acknowledgment_type
1557: , x_return_status => l_return_status
1558: );
1559: If l_return_status = fnd_api.g_ret_sts_unexp_error Then
1560: raise fnd_api.g_exc_unexpected_error;
1561: Elsif l_return_status = fnd_api.g_ret_sts_error Then
1562: raise fnd_api.g_exc_error;
1563: End If;
1564: -- End of Header data insert into ack header table}

Line 1561: Elsif l_return_status = fnd_api.g_ret_sts_error Then

1557: , x_return_status => l_return_status
1558: );
1559: If l_return_status = fnd_api.g_ret_sts_unexp_error Then
1560: raise fnd_api.g_exc_unexpected_error;
1561: Elsif l_return_status = fnd_api.g_ret_sts_error Then
1562: raise fnd_api.g_exc_error;
1563: End If;
1564: -- End of Header data insert into ack header table}
1565:

Line 1562: raise fnd_api.g_exc_error;

1558: );
1559: If l_return_status = fnd_api.g_ret_sts_unexp_error Then
1560: raise fnd_api.g_exc_unexpected_error;
1561: Elsif l_return_status = fnd_api.g_ret_sts_error Then
1562: raise fnd_api.g_exc_error;
1563: End If;
1564: -- End of Header data insert into ack header table}
1565:
1566: -- { Start of Line data insert into ack header table

Line 1577: If l_return_status = fnd_api.g_ret_sts_unexp_error Then

1573: , p_reject_order => l_reject_order
1574: , p_ack_type => l_acknowledgment_type
1575: , x_return_status => l_return_status
1576: );
1577: If l_return_status = fnd_api.g_ret_sts_unexp_error Then
1578: raise fnd_api.g_exc_unexpected_error;
1579: Elsif l_return_status = fnd_api.g_ret_sts_error Then
1580: raise fnd_api.g_exc_error;
1581: End If;

Line 1578: raise fnd_api.g_exc_unexpected_error;

1574: , p_ack_type => l_acknowledgment_type
1575: , x_return_status => l_return_status
1576: );
1577: If l_return_status = fnd_api.g_ret_sts_unexp_error Then
1578: raise fnd_api.g_exc_unexpected_error;
1579: Elsif l_return_status = fnd_api.g_ret_sts_error Then
1580: raise fnd_api.g_exc_error;
1581: End If;
1582: -- End of Line data insert into ack header table}

Line 1579: Elsif l_return_status = fnd_api.g_ret_sts_error Then

1575: , x_return_status => l_return_status
1576: );
1577: If l_return_status = fnd_api.g_ret_sts_unexp_error Then
1578: raise fnd_api.g_exc_unexpected_error;
1579: Elsif l_return_status = fnd_api.g_ret_sts_error Then
1580: raise fnd_api.g_exc_error;
1581: End If;
1582: -- End of Line data insert into ack header table}
1583:

Line 1580: raise fnd_api.g_exc_error;

1576: );
1577: If l_return_status = fnd_api.g_ret_sts_unexp_error Then
1578: raise fnd_api.g_exc_unexpected_error;
1579: Elsif l_return_status = fnd_api.g_ret_sts_error Then
1580: raise fnd_api.g_exc_error;
1581: End If;
1582: -- End of Line data insert into ack header table}
1583:
1584: END Process_Xml_Acknowledgment;

Line 1679: x_return_status := FND_API.G_RET_STS_SUCCESS;

1675: oe_debug_pub.add( 'IS DELIVERY REQUIRED' || X_IS_DELIVERY_REQUIRED ) ;
1676: END IF;
1677: END IF;
1678:
1679: x_return_status := FND_API.G_RET_STS_SUCCESS;
1680: IF l_debug_level > 0 THEN
1681: oe_debug_pub.add( 'OEXPACKB: EXITING IS_DELIVERY_REQUIRED' ) ;
1682: END IF;
1683: EXCEPTION

Line 1688: x_return_status := FND_API.G_RET_STS_ERROR;

1684: WHEN NO_DATA_FOUND THEN
1685: IF l_debug_level > 0 THEN
1686: oe_debug_pub.add( 'OEXPACKB: EXITING IS_DELIVERY_REQUIRED WITH NO_DATA_FOUND' ) ;
1687: END IF;
1688: x_return_status := FND_API.G_RET_STS_ERROR;
1689: -- start bug 3711152
1690: -- fnd_message.set_name ('ONT', 'OE_OI_TP_NOT_FOUND');
1691: -- fnd_message.set_token ('CUST_ID', p_customer_id);
1692: -- oe_msg_pub.add;

Line 1698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1694: WHEN OTHERS THEN
1695: IF l_debug_level > 0 THEN
1696: oe_debug_pub.add( 'OEXPACKB: EXITING IS_DELIVERY_REQUIRED WITH OTHERS' ) ;
1697: END IF;
1698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1699: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1700: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Is_Delivery_Required');
1701: END IF;
1702: IF l_debug_level > 0 THEN

Line 1730: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1726: -- changed for the header.
1727: -- 4. ....
1728: PROCEDURE Process_SSO
1729: ( p_api_version_number IN NUMBER :=1, -- GENESIS
1730: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1731: p_header_rec IN OE_Order_Pub.Header_Rec_Type,
1732: p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
1733: p_old_header_rec IN OE_Order_Pub.Header_Rec_Type,
1734: p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type,

Line 1872: x_return_status := FND_API.G_RET_STS_SUCCESS;

1868: -- No delivery is required so return, no further processing is required
1869: IF l_debug_level > 0 THEN
1870: oe_debug_pub.add( 'OEXPACKB: NO DELIVERY IS REQUIRED SO RETURN' ) ;
1871: END IF;
1872: x_return_status := FND_API.G_RET_STS_SUCCESS;
1873: return;
1874: end if;
1875: END IF; -- Order source Id
1876:

Line 2065: IF ( ( (l_line_tbl(i).operation IS NULL OR l_line_tbl(i).operation = FND_API.G_MISS_CHAR)

2061: IF j <> 0 THEN
2062: is_line_exists(p_line_tbl(j).line_id, l_lin_chk);
2063: END IF;
2064:
2065: IF ( ( (l_line_tbl(i).operation IS NULL OR l_line_tbl(i).operation = FND_API.G_MISS_CHAR)
2066: AND l_lin_chk = 'Y')
2067: OR (l_line_tbl(i).operation = Oe_Globals.G_OPR_UPDATE)
2068: )
2069: THEN

Line 2270: nvl(p_old_line_tbl(j).schedule_ship_date, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE)

2266: IF l_change_oqty_cso = 'Y' OR
2267: l_change_uom_cso = 'Y' OR
2268: l_change_usp_cso = 'Y' OR
2269: (l_change_ssdt_cso = 'Y' AND
2270: nvl(p_old_line_tbl(j).schedule_ship_date, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE)
2271: THEN
2272: l_apply_3a7_hold := TRUE;
2273: END IF;
2274: end if; -- j <> 0

Line 2474: AND nvl(l_header_rec.request_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) OR

2470: -- an exception is made for header-level cancellations
2471: IF l_is_delivery_required_cso = 'Y' THEN
2472: IF (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CHO
2473: AND OE_GLOBALS.Equal (l_header_rec.request_id, l_line_tbl(i).request_id)
2474: AND nvl(l_header_rec.request_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) OR
2475:
2476: (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CPO
2477: AND OE_GLOBALS.Equal (l_header_rec.request_id, l_line_tbl(i).request_id)
2478: AND nvl(l_header_rec.request_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) OR

Line 2478: AND nvl(l_header_rec.request_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) OR

2474: AND nvl(l_header_rec.request_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) OR
2475:
2476: (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CPO
2477: AND OE_GLOBALS.Equal (l_header_rec.request_id, l_line_tbl(i).request_id)
2478: AND nvl(l_header_rec.request_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) OR
2479:
2480: (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CPO
2481: AND nvl(l_header_rec.cancelled_flag,'N') = 'Y')
2482: THEN

Line 2519: , p_tp_check => FND_API.G_FALSE

2515: OE_Acknowledgment_PUB.Apply_3A7_Hold
2516: ( p_header_id => l_line_tbl(i).header_id
2517: , p_line_id => l_line_tbl(i).line_id
2518: , p_sold_to_org_id => l_line_tbl(i).sold_to_org_id
2519: , p_tp_check => FND_API.G_FALSE
2520: , x_return_status => l_return_status);
2521: IF l_debug_level > 0 THEN
2522: oe_debug_pub.add( 'Return status after call to apply_3a7_hold:' || l_return_status, 2 ) ;
2523: END IF;

Line 2562: If l_return_status = FND_API.G_RET_STS_SUCCESS Then

2558: p_itemkey => l_itemkey_sso,
2559: x_return_status => l_return_status
2560: );
2561: End If;
2562: If l_return_status = FND_API.G_RET_STS_SUCCESS Then
2563: l_header_req := 'D';
2564: End If;
2565: End If;
2566: -- Call insert routine to insert line_id and status info

Line 2629: If l_return_status = FND_API.G_RET_STS_SUCCESS Then

2625: x_return_status => l_return_status
2626: );
2627: -- End If;
2628: End If;
2629: If l_return_status = FND_API.G_RET_STS_SUCCESS Then
2630: l_header_req_cso := 'D';
2631: End If;
2632: End If;
2633: -- Call insert routine to insert line_id and status info

Line 2670: IF l_hold_result = FND_API.G_TRUE THEN

2666: , x_msg_data => l_msg_data
2667: , x_return_status => l_return_status
2668: );
2669:
2670: IF l_hold_result = FND_API.G_TRUE THEN
2671: IF l_debug_level > 0 THEN
2672: oe_debug_pub.add( 'Process SSO: Hold Already Applied On Header Id:'
2673: ||l_header_rec.header_id ||': Line_Id:'||l_line_tbl(i).line_id) ;
2674: oe_debug_pub.add( 'Change line status for 3A7');

Line 2724: if l_return_status = FND_API.G_RET_STS_SUCCESS Then

2720: p_itemkey => l_itemkey_sso,
2721: x_return_status => l_return_status
2722: );
2723: End If;
2724: if l_return_status = FND_API.G_RET_STS_SUCCESS Then
2725: l_header_req := 'D';
2726: end if;
2727: end if;
2728: if l_header_req_cso = 'Y' Then

Line 2745: if l_return_status = FND_API.G_RET_STS_SUCCESS Then

2741: x_return_status => l_return_status
2742: );
2743: -- End If;
2744: End If;
2745: if l_return_status = FND_API.G_RET_STS_SUCCESS Then
2746: l_header_req_cso := 'D';
2747: end if;
2748: end if;
2749: if l_header_req = 'D' then

Line 3022: If l_return_status <> FND_API.G_RET_STS_SUCCESS

3018: x_party_site_id => l_party_site_id,
3019: x_is_delivery_required => l_is_delivery_required,
3020: x_return_status => l_return_status
3021: );
3022: If l_return_status <> FND_API.G_RET_STS_SUCCESS
3023: Or l_is_delivery_required = 'N' Then
3024: fnd_file.put_line(FND_FILE.OUTPUT,'Show SO not enabled for TP: ' || p_customer_id);
3025: If l_debug_level > 0 THEN
3026: oe_debug_pub.add( 'CONC PGM NOT RAISING SSO EVENT FOR TP: '|| p_customer_id);

Line 3046: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3042: IF l_debug_level > 0 THEN
3043: oe_debug_pub.add( 'AFTER OE_ACKNOWLEDGMENT_PUB.RAISE_EVENT_SHOWSO API: RETURN STATUS:'||L_RETURN_STATUS , 2 ) ;
3044: END IF;
3045:
3046: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3047: fnd_file.put_line(FND_FILE.OUTPUT,'Not able to raise the event for Document Number : ' || l_order_rec.orig_sys_document_ref(i));
3048: fnd_file.put_line(FND_FILE.OUTPUT,'Error : ' || sqlerrm);
3049: l_return_status := FND_API.G_RET_STS_SUCCESS;
3050: ELSE

Line 3049: l_return_status := FND_API.G_RET_STS_SUCCESS;

3045:
3046: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3047: fnd_file.put_line(FND_FILE.OUTPUT,'Not able to raise the event for Document Number : ' || l_order_rec.orig_sys_document_ref(i));
3048: fnd_file.put_line(FND_FILE.OUTPUT,'Error : ' || sqlerrm);
3049: l_return_status := FND_API.G_RET_STS_SUCCESS;
3050: ELSE
3051: fnd_file.put_line(FND_FILE.OUTPUT,'Successfully raised the event for Document Number : ' ||l_order_rec.orig_sys_document_ref(i));
3052: END IF;
3053:

Line 3065: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3061: -- Exception Handling
3062: EXCEPTION
3063:
3064: WHEN OTHERS THEN
3065: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3066: IF l_debug_level > 0 THEN
3067: oe_debug_pub.add( 'WHEN OTHERS - EXITING OE_ACKNOWLEDGMENT_PUB.PROCESS_SSO_CONC_PGM' , 2 ) ;
3068: oe_debug_pub.add( 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE ) ;
3069: END IF;

Line 3147: x_return_status := FND_API.G_RET_STS_SUCCESS;

3143: IF p_order_source_id <> G_XML_ORDER_SOURCE_ID THEN
3144: IF l_debug_level > 0 THEN
3145: oe_debug_pub.add( 'LEAVING RAISE_EVENT_XMLINT FOR DISABLED ORDER SOURCE: '|| p_order_source_id ) ;
3146: END IF;
3147: x_return_status := FND_API.G_RET_STS_SUCCESS;
3148: return;
3149: END IF;
3150: ELSIF l_integ_profile = 'EDIXML' THEN
3151: IF p_order_source_id NOT IN (G_XML_ORDER_SOURCE_ID, OE_GLOBALS.G_ORDER_SOURCE_EDI) THEN

Line 3155: x_return_status := FND_API.G_RET_STS_SUCCESS;

3151: IF p_order_source_id NOT IN (G_XML_ORDER_SOURCE_ID, OE_GLOBALS.G_ORDER_SOURCE_EDI) THEN
3152: IF l_debug_level > 0 THEN
3153: oe_debug_pub.add( 'LEAVING RAISE_EVENT_XMLINT FOR DISABLED ORDER SOURCE: '|| p_order_source_id ) ;
3154: END IF;
3155: x_return_status := FND_API.G_RET_STS_SUCCESS;
3156: return;
3157: END IF;
3158: END IF;
3159:

Line 3178: IF FND_API.G_MISS_NUM IN (p_order_source_id, p_sold_to_org_id) THEN

3174:
3175: /* error checking primarily to guard against some OI cases where we
3176: get G_MISS_VALUES */
3177:
3178: IF FND_API.G_MISS_NUM IN (p_order_source_id, p_sold_to_org_id) THEN
3179: l_parameter_list.DELETE;
3180: x_return_status := FND_API.G_RET_STS_SUCCESS;
3181:
3182: IF l_debug_level > 0 THEN

Line 3180: x_return_status := FND_API.G_RET_STS_SUCCESS;

3176: get G_MISS_VALUES */
3177:
3178: IF FND_API.G_MISS_NUM IN (p_order_source_id, p_sold_to_org_id) THEN
3179: l_parameter_list.DELETE;
3180: x_return_status := FND_API.G_RET_STS_SUCCESS;
3181:
3182: IF l_debug_level > 0 THEN
3183: oe_debug_pub.add( 'NOT RAISING oracle.apps.ont.oi.xml_int.status without order source or sold to org id' ) ;
3184: oe_debug_pub.add( 'order source ' || p_order_source_id || ' or sold to org id' || p_sold_to_org_id ) ;

Line 3190: IF l_conc_request_id = FND_API.G_MISS_NUM THEN

3186: END IF;
3187: Return;
3188: END IF;
3189:
3190: IF l_conc_request_id = FND_API.G_MISS_NUM THEN
3191: l_conc_request_id := NULL;
3192: l_converted := l_converted || 'CONC_REQUEST_ID, ';
3193: END IF;
3194: IF l_header_id = FND_API.G_MISS_NUM THEN

Line 3194: IF l_header_id = FND_API.G_MISS_NUM THEN

3190: IF l_conc_request_id = FND_API.G_MISS_NUM THEN
3191: l_conc_request_id := NULL;
3192: l_converted := l_converted || 'CONC_REQUEST_ID, ';
3193: END IF;
3194: IF l_header_id = FND_API.G_MISS_NUM THEN
3195: l_header_id := NULL;
3196: l_converted := l_converted || 'HEADER_ID, ';
3197: END IF;
3198: IF l_org_id = FND_API.G_MISS_NUM THEN

Line 3198: IF l_org_id = FND_API.G_MISS_NUM THEN

3194: IF l_header_id = FND_API.G_MISS_NUM THEN
3195: l_header_id := NULL;
3196: l_converted := l_converted || 'HEADER_ID, ';
3197: END IF;
3198: IF l_org_id = FND_API.G_MISS_NUM THEN
3199:
3200: /* SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',
3201: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))) into l_org_id from DUAL; */
3202: l_org_id := MO_GLOBAL.Get_Current_Org_Id; --moac

Line 3210: IF l_doc_status = FND_API.G_RET_STS_SUCCESS THEN -- calls from Order Import Conc Pgm

3206: IF l_xmlg_icn IS NULL THEN
3207: l_xmlg_icn := l_eventkey; --reuse sequence value (mainly for generic OI)
3208: END IF;
3209:
3210: IF l_doc_status = FND_API.G_RET_STS_SUCCESS THEN -- calls from Order Import Conc Pgm
3211: l_doc_status := 'SUCCESS';
3212: l_processing_stage := 'IMPORT_SUCCESS';
3213: ELSIF l_doc_status IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN
3214: l_doc_status := 'ERROR';

Line 3213: ELSIF l_doc_status IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN

3209:
3210: IF l_doc_status = FND_API.G_RET_STS_SUCCESS THEN -- calls from Order Import Conc Pgm
3211: l_doc_status := 'SUCCESS';
3212: l_processing_stage := 'IMPORT_SUCCESS';
3213: ELSIF l_doc_status IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN
3214: l_doc_status := 'ERROR';
3215: l_processing_stage := 'IMPORT_FAILURE';
3216: END IF;
3217:

Line 3505: x_return_status := FND_API.G_RET_STS_SUCCESS;

3501: IF p_order_source_id <> G_XML_ORDER_SOURCE_ID OR
3502: l_processing_stage NOT IN ('IMPORT_SUCCESS', 'OUTBOUND_SENT') OR
3503: l_transaction_subtype = G_TRANSACTION_CBODO THEN
3504: l_parameter_list.DELETE;
3505: x_return_status := FND_API.G_RET_STS_SUCCESS;
3506:
3507: IF l_debug_level > 0 THEN
3508: oe_debug_pub.add( 'NOT RAISING oracle.apps.ont.oi.xml_int.status for this pre-110510 case' ) ;
3509: oe_debug_pub.add( 'EXITING RAISE_EVENT_XMLINT' ) ;

Line 3528: x_return_status := FND_API.G_RET_STS_SUCCESS;

3524:
3525:
3526: l_parameter_list.DELETE;
3527:
3528: x_return_status := FND_API.G_RET_STS_SUCCESS;
3529: EXCEPTION
3530: When Others Then
3531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3532: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 3531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3527:
3528: x_return_status := FND_API.G_RET_STS_SUCCESS;
3529: EXCEPTION
3530: When Others Then
3531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3532: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3533: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Xmlint');
3534: END IF;
3535: IF l_debug_level > 0 THEN

Line 3554: l_tp_check VARCHAR2(1) := nvl(p_tp_check, FND_API.G_TRUE);

3550: , p_tp_check IN VARCHAR2
3551: , x_return_status OUT NOCOPY VARCHAR2
3552: )
3553: IS
3554: l_tp_check VARCHAR2(1) := nvl(p_tp_check, FND_API.G_TRUE);
3555: l_msg_count NUMBER := 0;
3556: l_msg_data VARCHAR2(2000);
3557: l_return_status VARCHAR2(30) := fnd_api.g_ret_sts_success;
3558: l_hold_result VARCHAR2(30);

Line 3557: l_return_status VARCHAR2(30) := fnd_api.g_ret_sts_success;

3553: IS
3554: l_tp_check VARCHAR2(1) := nvl(p_tp_check, FND_API.G_TRUE);
3555: l_msg_count NUMBER := 0;
3556: l_msg_data VARCHAR2(2000);
3557: l_return_status VARCHAR2(30) := fnd_api.g_ret_sts_success;
3558: l_hold_result VARCHAR2(30);
3559: l_hold_source_rec OE_Holds_PVT.Hold_Source_REC_type;
3560: l_is_delivery_required_cso VARCHAR2(1) := 'N';
3561: l_hold_id NUMBER := 56;

Line 3572: IF l_tp_check = FND_API.G_TRUE THEN

3568: IF l_debug_level > 0 THEN
3569: oe_debug_pub.add( 'Entering Apply_3A7_Hold' ) ;
3570: END IF;
3571:
3572: IF l_tp_check = FND_API.G_TRUE THEN
3573: IF l_debug_level > 0 THEN
3574: oe_debug_pub.add( 'Before Calling OE_Acknowledgment_PUB.Is_Delivery_Required') ;
3575: END IF;
3576:

Line 3590: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

3586:
3587: IF l_debug_level > 0 THEN
3588: oe_debug_pub.add( 'After Calling OE_Acknowledgment_PUB.Is_Delivery_Required: is delivery required for 3a7 = ' || l_is_delivery_required_cso||': Return Status:'||l_return_status ) ;
3589: END IF;
3590: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3591: IF l_is_delivery_required_cso = 'Y' THEN
3592: IF l_debug_level > 0 THEN
3593: oe_debug_pub.add('3A7 enabled transaction. Hold should be applied');
3594: END IF;

Line 3627: IF l_hold_result = FND_API.G_TRUE THEN

3623: , x_return_status => l_return_status
3624: );
3625:
3626: -- Return with Success if this Hold Already exists on the order line
3627: IF l_hold_result = FND_API.G_TRUE THEN
3628: IF l_debug_level > 0 THEN
3629: oe_debug_pub.add( ' Hold Already Applied On Header Id:' || P_HEADER_ID||': Line_Id:'||p_line_id) ;
3630: END IF;
3631: RETURN ;

Line 3646: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

3642: l_hold_source_rec.header_id := p_header_id; -- Order Header
3643: l_hold_source_rec.line_id := p_line_id; -- Order line
3644: OE_Holds_PUB.Apply_Holds
3645: ( p_api_version => 1.0
3646: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
3647: , p_hold_source_rec => l_hold_source_rec
3648: , x_msg_count => l_msg_count
3649: , x_msg_data => l_msg_data
3650: , x_return_status => l_return_status

Line 3653: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3649: , x_msg_data => l_msg_data
3650: , x_return_status => l_return_status
3651: );
3652:
3653: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3654: RAISE FND_API.G_EXC_ERROR;
3655: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3657: END IF;

Line 3654: RAISE FND_API.G_EXC_ERROR;

3650: , x_return_status => l_return_status
3651: );
3652:
3653: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3654: RAISE FND_API.G_EXC_ERROR;
3655: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3657: END IF;
3658:

Line 3655: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3651: );
3652:
3653: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3654: RAISE FND_API.G_EXC_ERROR;
3655: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3657: END IF;
3658:
3659: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3652:
3653: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3654: RAISE FND_API.G_EXC_ERROR;
3655: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3657: END IF;
3658:
3659: x_return_status := FND_API.G_RET_STS_SUCCESS;
3660:

Line 3659: x_return_status := FND_API.G_RET_STS_SUCCESS;

3655: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3657: END IF;
3658:
3659: x_return_status := FND_API.G_RET_STS_SUCCESS;
3660:
3661: IF l_debug_level > 0 THEN
3662: oe_debug_pub.add( 'Applied 3a7 Hold On Header Id:' || P_HEADER_ID||':Line_Id:'||p_line_id , 3 ) ;
3663: END IF;

Line 3667: WHEN FND_API.G_EXC_ERROR THEN

3663: END IF;
3664:
3665: EXCEPTION
3666:
3667: WHEN FND_API.G_EXC_ERROR THEN
3668: IF l_debug_level > 0 THEN
3669: oe_debug_pub.add('In G_EXC_ERROR exception - Apply_3A7_hold');
3670: END IF;
3671: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3671: x_return_status := FND_API.G_RET_STS_ERROR;

3667: WHEN FND_API.G_EXC_ERROR THEN
3668: IF l_debug_level > 0 THEN
3669: oe_debug_pub.add('In G_EXC_ERROR exception - Apply_3A7_hold');
3670: END IF;
3671: x_return_status := FND_API.G_RET_STS_ERROR;
3672: OE_MSG_PUB.Count_And_Get
3673: ( p_count => l_msg_count,
3674: p_data => l_msg_data
3675: );

Line 3677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3673: ( p_count => l_msg_count,
3674: p_data => l_msg_data
3675: );
3676:
3677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3678: IF l_debug_level > 0 THEN
3679: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Apply_3A7_hold');
3680: END IF;
3681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3678: IF l_debug_level > 0 THEN
3679: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Apply_3A7_hold');
3680: END IF;
3681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3682: OE_MSG_PUB.Count_And_Get
3683: ( p_count => l_msg_count,
3684: p_data => l_msg_data
3685: );

Line 3691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3687: WHEN OTHERS THEN
3688: IF l_debug_level > 0 THEN
3689: oe_debug_pub.add('In when others exception - Apply_3A7_hold');
3690: END IF;
3691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3692: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3693: THEN
3694: FND_MSG_PUB.Add_Exc_Msg
3695: ( G_PKG_NAME

Line 3720: l_return_status VARCHAR2(30) := fnd_api.g_ret_sts_success;

3716: l_hold_id NUMBER := 56;
3717: l_hold_exists VARCHAR2(1);
3718: l_msg_count NUMBER := 0;
3719: l_msg_data VARCHAR2(2000);
3720: l_return_status VARCHAR2(30) := fnd_api.g_ret_sts_success;
3721: l_release_reason VARCHAR2(30);
3722: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
3723: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
3724: l_hold_result VARCHAR2(30);

Line 3749: IF l_hold_result = FND_API.G_TRUE THEN

3745: , x_return_status => l_return_status
3746: );
3747:
3748: -- Return with Success if this Hold exists on the order line
3749: IF l_hold_result = FND_API.G_TRUE THEN
3750: IF l_debug_level > 0 THEN
3751: oe_debug_pub.add( ' Hold Exists On Header Id:' || P_HEADER_ID||': Line_Id:'||p_line_id) ;
3752: END IF;
3753: l_hold_exists := 'Y';

Line 3776: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3772: , x_msg_data => l_msg_data
3773: , x_return_status => l_return_status
3774: );
3775:
3776: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3777: RAISE FND_API.G_EXC_ERROR;
3778: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3780: END IF;

Line 3777: RAISE FND_API.G_EXC_ERROR;

3773: , x_return_status => l_return_status
3774: );
3775:
3776: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3777: RAISE FND_API.G_EXC_ERROR;
3778: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3780: END IF;
3781: IF l_debug_level > 0 THEN

Line 3778: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3774: );
3775:
3776: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3777: RAISE FND_API.G_EXC_ERROR;
3778: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3780: END IF;
3781: IF l_debug_level > 0 THEN
3782: oe_debug_pub.add( 'Released 3a7 Hold On Header Id:' || P_HEADER_ID ||':Line_Id:'||p_line_id, 3 ) ;

Line 3779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3775:
3776: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3777: RAISE FND_API.G_EXC_ERROR;
3778: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3780: END IF;
3781: IF l_debug_level > 0 THEN
3782: oe_debug_pub.add( 'Released 3a7 Hold On Header Id:' || P_HEADER_ID ||':Line_Id:'||p_line_id, 3 ) ;
3783: END IF;

Line 3786: x_return_status := FND_API.G_RET_STS_SUCCESS;

3782: oe_debug_pub.add( 'Released 3a7 Hold On Header Id:' || P_HEADER_ID ||':Line_Id:'||p_line_id, 3 ) ;
3783: END IF;
3784:
3785: END IF; -- hold exists
3786: x_return_status := FND_API.G_RET_STS_SUCCESS;
3787: IF l_debug_level > 0 THEN
3788: oe_debug_pub.add( 'Exiting Release_3A7 Hold', 3 ) ;
3789: END IF;
3790:

Line 3793: WHEN FND_API.G_EXC_ERROR THEN

3789: END IF;
3790:
3791: EXCEPTION
3792:
3793: WHEN FND_API.G_EXC_ERROR THEN
3794: IF l_debug_level > 0 THEN
3795: oe_debug_pub.add('In G_EXC_ ERROR exception - Release_3A7_hold');
3796: END IF;
3797: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3797: x_return_status := FND_API.G_RET_STS_ERROR;

3793: WHEN FND_API.G_EXC_ERROR THEN
3794: IF l_debug_level > 0 THEN
3795: oe_debug_pub.add('In G_EXC_ ERROR exception - Release_3A7_hold');
3796: END IF;
3797: x_return_status := FND_API.G_RET_STS_ERROR;
3798: OE_MSG_PUB.Count_And_Get
3799: ( p_count => l_msg_count,
3800: p_data => l_msg_data
3801: );

Line 3803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3799: ( p_count => l_msg_count,
3800: p_data => l_msg_data
3801: );
3802:
3803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3804: IF l_debug_level > 0 THEN
3805: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Release_3A7_hold');
3806: END IF;
3807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3804: IF l_debug_level > 0 THEN
3805: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Release_3A7_hold');
3806: END IF;
3807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3808: OE_MSG_PUB.Count_And_Get
3809: ( p_count => l_msg_count,
3810: p_data => l_msg_data
3811: );

Line 3817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3813: WHEN OTHERS THEN
3814: IF l_debug_level > 0 THEN
3815: oe_debug_pub.add('In when others exception - Release_3A7_hold');
3816: END IF;
3817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3818: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3819: THEN
3820: FND_MSG_PUB.Add_Exc_Msg
3821: ( G_PKG_NAME

Line 3844: l_return_status VARCHAR2(30) := fnd_api.g_ret_sts_success;

3840: )
3841: IS
3842: l_msg_count NUMBER := 0;
3843: l_msg_data VARCHAR2(2000);
3844: l_return_status VARCHAR2(30) := fnd_api.g_ret_sts_success;
3845: l_release_3a7_hold_flag VARCHAR2(1) := 'N';
3846: --
3847: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3848: --

Line 3890: RAISE FND_API.G_EXC_ERROR;

3886: oe_debug_pub.add( '3A8 response received, columns does not match and qty <> 0, Raise an error', 3 ) ;
3887: END IF;
3888: FND_MESSAGE.SET_NAME('ONT', 'ONT_3A8_RESPONSE_COL_MISMATCH');
3889: OE_MSG_PUB.Add;
3890: RAISE FND_API.G_EXC_ERROR;
3891: END IF; -- check for columns
3892: END IF; -- check for independent/response 3A8
3893:
3894: IF l_release_3a7_hold_flag = 'Y' THEN

Line 3903: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3899: ( p_header_id => p_x_line_rec.header_id
3900: , p_line_id => p_x_line_rec.line_id
3901: , x_return_status => l_return_status
3902: );
3903: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3904: RAISE FND_API.G_EXC_ERROR;
3905: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3907: END IF;

Line 3904: RAISE FND_API.G_EXC_ERROR;

3900: , p_line_id => p_x_line_rec.line_id
3901: , x_return_status => l_return_status
3902: );
3903: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3904: RAISE FND_API.G_EXC_ERROR;
3905: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3907: END IF;
3908:

Line 3905: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3901: , x_return_status => l_return_status
3902: );
3903: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3904: RAISE FND_API.G_EXC_ERROR;
3905: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3907: END IF;
3908:
3909: END IF;

Line 3906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3902: );
3903: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3904: RAISE FND_API.G_EXC_ERROR;
3905: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3907: END IF;
3908:
3909: END IF;
3910:

Line 3911: x_return_status := FND_API.G_RET_STS_SUCCESS;

3907: END IF;
3908:
3909: END IF;
3910:
3911: x_return_status := FND_API.G_RET_STS_SUCCESS;
3912: IF l_debug_level > 0 THEN
3913: oe_debug_pub.add( 'Exiting Process_3A8', 3 ) ;
3914: END IF;
3915:

Line 3918: WHEN FND_API.G_EXC_ERROR THEN

3914: END IF;
3915:
3916: EXCEPTION
3917:
3918: WHEN FND_API.G_EXC_ERROR THEN
3919: IF l_debug_level > 0 THEN
3920: oe_debug_pub.add('In G_EXC_ ERROR exception - Process_3A8');
3921: END IF;
3922: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3922: x_return_status := FND_API.G_RET_STS_ERROR;

3918: WHEN FND_API.G_EXC_ERROR THEN
3919: IF l_debug_level > 0 THEN
3920: oe_debug_pub.add('In G_EXC_ ERROR exception - Process_3A8');
3921: END IF;
3922: x_return_status := FND_API.G_RET_STS_ERROR;
3923: OE_MSG_PUB.Count_And_Get
3924: ( p_count => l_msg_count,
3925: p_data => l_msg_data
3926: );

Line 3928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3924: ( p_count => l_msg_count,
3925: p_data => l_msg_data
3926: );
3927:
3928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3929: IF l_debug_level > 0 THEN
3930: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Process_3A8');
3931: END IF;
3932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3929: IF l_debug_level > 0 THEN
3930: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Process_3A8');
3931: END IF;
3932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3933: OE_MSG_PUB.Count_And_Get
3934: ( p_count => l_msg_count,
3935: p_data => l_msg_data
3936: );

Line 3942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3938: WHEN OTHERS THEN
3939: IF l_debug_level > 0 THEN
3940: oe_debug_pub.add('In when others exception - Process_3A8');
3941: END IF;
3942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3943: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3944: THEN
3945: FND_MSG_PUB.Add_Exc_Msg
3946: ( G_PKG_NAME

Line 4040: x_return_status := FND_API.G_RET_STS_SUCCESS;

4036: wf_event.raise( p_event_name => 'oracle.apps.ont.oi.cbod_out.confirm',
4037: p_event_key => l_eventkey,
4038: p_parameters => l_parameter_list);
4039:
4040: x_return_status := FND_API.G_RET_STS_SUCCESS;
4041: Else
4042: x_return_status := FND_API.G_RET_STS_ERROR;
4043: End If;
4044:

Line 4042: x_return_status := FND_API.G_RET_STS_ERROR;

4038: p_parameters => l_parameter_list);
4039:
4040: x_return_status := FND_API.G_RET_STS_SUCCESS;
4041: Else
4042: x_return_status := FND_API.G_RET_STS_ERROR;
4043: End If;
4044:
4045: l_parameter_list.DELETE;
4046:

Line 4050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4046:
4047: Exception
4048: When Others Then
4049: l_parameter_list.DELETE;
4050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4051:
4052: END Raise_CBOD_Out_Event;
4053:
4054: -- Procedure added for bug 9685021