APPS.OE_ACKNOWLEDGMENT_PUB dependencies on FND_API

Line 215: x_return_status := FND_API.G_RET_STS_SUCCESS;

211: x_is_delivery_required => l_is_delivery_reqd,
212: x_return_status => l_return_status
213: );
214: If nvl(l_is_delivery_reqd, 'N') = 'N' Then
215: x_return_status := FND_API.G_RET_STS_SUCCESS;
216: return;
217: End If;
218: END IF;
219: END IF;

Line 298: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 308: x_return_status := FND_API.G_RET_STS_ERROR;

304: when others then
305: IF l_debug_level > 0 THEN
306: oe_debug_pub.add( 'ENCOUNTERED OTHERS EXCEPTION IN RAISE_EVENT_FROM_OEOI' ) ;
307: END IF;
308: x_return_status := FND_API.G_RET_STS_ERROR;
309: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
310: THEN
311: FND_MSG_PUB.Add_Exc_Msg
312: (G_PKG_NAME, 'OE_Acknowledgment_Pub.Raise_Event_From_Oeoi');

Line 505: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 515: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

523: -- End of Procedure to raise 3a6 event}
524:
525: PROCEDURE Process_Acknowledgment
526: (p_api_version_number IN NUMBER
527: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
528:
529: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
530: OE_Order_Pub.G_MISS_HEADER_REC
531: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=

Line 611: IF NOT FND_API.Compatible_API_Call

607:
608: IF l_debug_level > 0 THEN
609: oe_debug_pub.add( 'Entering Process Acknowledgment');
610: END IF;
611: IF NOT FND_API.Compatible_API_Call
612: ( l_api_version_number
613: , p_api_version_number
614: , l_api_name
615: , G_PKG_NAME

Line 621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

617: THEN
618: IF l_debug_level > 0 THEN
619: oe_debug_pub.add( 'OEXPACKB COMPATIBLE_API_CALL' ) ;
620: END IF;
621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
622: END IF;
623:
624: IF l_debug_level > 0 THEN
625: oe_debug_pub.add( 'BEFORE CALLING PRIVATE ACKNOWLEDGMENT API' ) ;

Line 675: WHEN FND_API.G_EXC_ERROR THEN

671: END IF;
672:
673: EXCEPTION
674:
675: WHEN FND_API.G_EXC_ERROR THEN
676: IF l_debug_level > 0 THEN
677: oe_debug_pub.add( 'ENCOUNTERED ERROR EXCEPTION' ) ;
678: END IF;
679: x_return_status := FND_API.G_RET_STS_ERROR;

Line 679: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
682: IF l_debug_level > 0 THEN
683: oe_debug_pub.add( 'ENCOUNTERED UNEXPECTED ERROR EXCEPTION' ) ;
684: END IF;
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
686:
687: WHEN OTHERS THEN
688: IF l_debug_level > 0 THEN
689: oe_debug_pub.add( 'ENCOUNTERED OTHERS ERROR EXCEPTION IN OE_ACKNOWLEDGMENT_PUB.PROCESS_ACKNOWLEDGMENT: '|| SQLERRM ) ;

Line 691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 783: x_return_status := FND_API.G_RET_STS_SUCCESS;

779: if sql%rowcount > 0 then
780: IF l_debug_level > 0 THEN
781: oe_debug_pub.add( 'INSERTED HEADER_ID => ' || P_HEADER_REC.HEADER_ID ) ;
782: END IF;
783: x_return_status := FND_API.G_RET_STS_SUCCESS;
784: else
785: IF l_debug_level > 0 THEN
786: oe_debug_pub.add( 'NOT INSERTED HEADER_ID => ' || P_HEADER_REC.HEADER_ID ) ;
787: END IF;

Line 788: x_return_status := FND_API.G_RET_STS_ERROR;

784: else
785: IF l_debug_level > 0 THEN
786: oe_debug_pub.add( 'NOT INSERTED HEADER_ID => ' || P_HEADER_REC.HEADER_ID ) ;
787: END IF;
788: x_return_status := FND_API.G_RET_STS_ERROR;
789: end if;
790:
791: IF l_debug_level > 0 THEN
792: oe_debug_pub.add( 'EXITING: OEXPACK PROCEDURE INSERT_HEADER' ) ;

Line 832: x_return_status := FND_API.G_RET_STS_SUCCESS;

828: if sql%rowcount > 0 then
829: IF l_debug_level > 0 THEN
830: oe_debug_pub.add( 'INSERTED LINE_ID => ' || P_LINE_REC.LINE_ID ) ;
831: END IF;
832: x_return_status := FND_API.G_RET_STS_SUCCESS;
833: else
834: IF l_debug_level > 0 THEN
835: oe_debug_pub.add( 'NOT INSERTED LINE_ID => ' || P_LINE_REC.LINE_ID ) ;
836: END IF;

Line 837: x_return_status := FND_API.G_RET_STS_ERROR;

833: else
834: IF l_debug_level > 0 THEN
835: oe_debug_pub.add( 'NOT INSERTED LINE_ID => ' || P_LINE_REC.LINE_ID ) ;
836: END IF;
837: x_return_status := FND_API.G_RET_STS_ERROR;
838: end if;
839:
840: IF l_debug_level > 0 THEN
841: oe_debug_pub.add( 'EXITING: OEXPACK PROCEDURE INSERT_LINE' ) ;

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

870: l_line_count Number := 0;
871: l_order_source_id Number;
872: l_orig_sys_document_ref Varchar2(50);
873: l_change_sequence Varchar2(50);
874: l_return_status Varchar2(1) := fnd_api.g_ret_sts_success;
875: l_customer_key_profile VARCHAR2(1) := 'N';
876:
877:
878: -- { Start of Header Interface Cursor

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

1069:
1070:
1071: PROCEDURE Process_Xml_Acknowledgment
1072: ( p_api_version_number IN NUMBER := 1,
1073: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1074: p_order_source_id IN NUMBER := G_XML_ORDER_SOURCE_ID,
1075: p_orig_sys_document_ref IN VARCHAR2,
1076: p_sold_to_org_id IN NUMBER,
1077: p_change_sequence IN VARCHAR2,

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

1101: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
1102: l_header_id Number;
1103: l_header_last_ack_code Varchar2(30);
1104: l_reject_order Varchar2(1) := 'Y';
1105: l_return_status Varchar2(1) := fnd_api.g_ret_sts_success;
1106: l_line_id Number;
1107: l_line_ack_id Number;
1108: l_line_last_ack_code Varchar2(30);
1109: l_ind_cntr Number;

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

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

Line 1350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1346: END IF;
1347: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1348: fnd_message.set_token ('TABLE', 'oe_order_headers');
1349: oe_msg_pub.add;
1350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1351: --RETURN;
1352: End;
1353: -- End Header query}
1354:

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

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

Line 1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1442: END IF;
1443: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1444: fnd_message.set_token ('TABLE', 'oe_order_lines');
1445: oe_msg_pub.add;
1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1447: --RETURN;
1448: End;
1449:
1450: End If;

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

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

Line 1508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1504: END IF;
1505: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1506: fnd_message.set_token ('TABLE', 'oe_order_lines');
1507: oe_msg_pub.add;
1508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1509: --RETURN;
1510: End;
1511: -- End Line query}
1512:

Line 1554: If l_return_status = fnd_api.g_ret_sts_unexp_error Then

1550: , p_reject_order => l_reject_order
1551: , p_ack_type => l_acknowledgment_type
1552: , x_return_status => l_return_status
1553: );
1554: If l_return_status = fnd_api.g_ret_sts_unexp_error Then
1555: raise fnd_api.g_exc_unexpected_error;
1556: Elsif l_return_status = fnd_api.g_ret_sts_error Then
1557: raise fnd_api.g_exc_error;
1558: End If;

Line 1555: raise fnd_api.g_exc_unexpected_error;

1551: , p_ack_type => l_acknowledgment_type
1552: , x_return_status => l_return_status
1553: );
1554: If l_return_status = fnd_api.g_ret_sts_unexp_error Then
1555: raise fnd_api.g_exc_unexpected_error;
1556: Elsif l_return_status = fnd_api.g_ret_sts_error Then
1557: raise fnd_api.g_exc_error;
1558: End If;
1559: -- End of Header data insert into ack header table}

Line 1556: Elsif l_return_status = fnd_api.g_ret_sts_error Then

1552: , x_return_status => l_return_status
1553: );
1554: If l_return_status = fnd_api.g_ret_sts_unexp_error Then
1555: raise fnd_api.g_exc_unexpected_error;
1556: Elsif l_return_status = fnd_api.g_ret_sts_error Then
1557: raise fnd_api.g_exc_error;
1558: End If;
1559: -- End of Header data insert into ack header table}
1560:

Line 1557: raise fnd_api.g_exc_error;

1553: );
1554: If l_return_status = fnd_api.g_ret_sts_unexp_error Then
1555: raise fnd_api.g_exc_unexpected_error;
1556: Elsif l_return_status = fnd_api.g_ret_sts_error Then
1557: raise fnd_api.g_exc_error;
1558: End If;
1559: -- End of Header data insert into ack header table}
1560:
1561: -- { Start of Line data insert into ack header table

Line 1572: If l_return_status = fnd_api.g_ret_sts_unexp_error Then

1568: , p_reject_order => l_reject_order
1569: , p_ack_type => l_acknowledgment_type
1570: , x_return_status => l_return_status
1571: );
1572: If l_return_status = fnd_api.g_ret_sts_unexp_error Then
1573: raise fnd_api.g_exc_unexpected_error;
1574: Elsif l_return_status = fnd_api.g_ret_sts_error Then
1575: raise fnd_api.g_exc_error;
1576: End If;

Line 1573: raise fnd_api.g_exc_unexpected_error;

1569: , p_ack_type => l_acknowledgment_type
1570: , x_return_status => l_return_status
1571: );
1572: If l_return_status = fnd_api.g_ret_sts_unexp_error Then
1573: raise fnd_api.g_exc_unexpected_error;
1574: Elsif l_return_status = fnd_api.g_ret_sts_error Then
1575: raise fnd_api.g_exc_error;
1576: End If;
1577: -- End of Line data insert into ack header table}

Line 1574: Elsif l_return_status = fnd_api.g_ret_sts_error Then

1570: , x_return_status => l_return_status
1571: );
1572: If l_return_status = fnd_api.g_ret_sts_unexp_error Then
1573: raise fnd_api.g_exc_unexpected_error;
1574: Elsif l_return_status = fnd_api.g_ret_sts_error Then
1575: raise fnd_api.g_exc_error;
1576: End If;
1577: -- End of Line data insert into ack header table}
1578:

Line 1575: raise fnd_api.g_exc_error;

1571: );
1572: If l_return_status = fnd_api.g_ret_sts_unexp_error Then
1573: raise fnd_api.g_exc_unexpected_error;
1574: Elsif l_return_status = fnd_api.g_ret_sts_error Then
1575: raise fnd_api.g_exc_error;
1576: End If;
1577: -- End of Line data insert into ack header table}
1578:
1579: END Process_Xml_Acknowledgment;

Line 1674: x_return_status := FND_API.G_RET_STS_SUCCESS;

1670: oe_debug_pub.add( 'IS DELIVERY REQUIRED' || X_IS_DELIVERY_REQUIRED ) ;
1671: END IF;
1672: END IF;
1673:
1674: x_return_status := FND_API.G_RET_STS_SUCCESS;
1675: IF l_debug_level > 0 THEN
1676: oe_debug_pub.add( 'OEXPACKB: EXITING IS_DELIVERY_REQUIRED' ) ;
1677: END IF;
1678: EXCEPTION

Line 1683: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1689: WHEN OTHERS THEN
1690: IF l_debug_level > 0 THEN
1691: oe_debug_pub.add( 'OEXPACKB: EXITING IS_DELIVERY_REQUIRED WITH OTHERS' ) ;
1692: END IF;
1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1694: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1695: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Is_Delivery_Required');
1696: END IF;
1697: IF l_debug_level > 0 THEN

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

1721: -- changed for the header.
1722: -- 4. ....
1723: PROCEDURE Process_SSO
1724: ( p_api_version_number IN NUMBER :=1, -- GENESIS
1725: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1726: p_header_rec IN OE_Order_Pub.Header_Rec_Type,
1727: p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
1728: p_old_header_rec IN OE_Order_Pub.Header_Rec_Type,
1729: p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type,

Line 1860: x_return_status := FND_API.G_RET_STS_SUCCESS;

1856: -- No delivery is required so return, no further processing is required
1857: IF l_debug_level > 0 THEN
1858: oe_debug_pub.add( 'OEXPACKB: NO DELIVERY IS REQUIRED SO RETURN' ) ;
1859: END IF;
1860: x_return_status := FND_API.G_RET_STS_SUCCESS;
1861: return;
1862: end if;
1863: END IF; -- Order source Id
1864:

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

2186: IF l_change_oqty_cso = 'Y' OR
2187: l_change_uom_cso = 'Y' OR
2188: l_change_usp_cso = 'Y' OR
2189: (l_change_ssdt_cso = 'Y' AND
2190: nvl(p_old_line_tbl(j).schedule_ship_date, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE)
2191: THEN
2192: l_apply_3a7_hold := TRUE;
2193: END IF;
2194: end if; -- j <> 0

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

2354: -- an exception is made for header-level cancellations
2355: IF l_is_delivery_required_cso = 'Y' THEN
2356: IF (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CHO
2357: AND OE_GLOBALS.Equal (l_header_rec.request_id, l_line_tbl(i).request_id)
2358: AND nvl(l_header_rec.request_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) OR
2359:
2360: (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CPO
2361: AND OE_GLOBALS.Equal (l_header_rec.request_id, l_line_tbl(i).request_id)
2362: AND nvl(l_header_rec.request_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) OR

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

2358: AND nvl(l_header_rec.request_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) OR
2359:
2360: (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CPO
2361: AND OE_GLOBALS.Equal (l_header_rec.request_id, l_line_tbl(i).request_id)
2362: AND nvl(l_header_rec.request_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) OR
2363:
2364: (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CPO
2365: AND nvl(l_header_rec.cancelled_flag,'N') = 'Y')
2366: THEN

Line 2403: , p_tp_check => FND_API.G_FALSE

2399: OE_Acknowledgment_PUB.Apply_3A7_Hold
2400: ( p_header_id => l_line_tbl(i).header_id
2401: , p_line_id => l_line_tbl(i).line_id
2402: , p_sold_to_org_id => l_line_tbl(i).sold_to_org_id
2403: , p_tp_check => FND_API.G_FALSE
2404: , x_return_status => l_return_status);
2405: IF l_debug_level > 0 THEN
2406: oe_debug_pub.add( 'Return status after call to apply_3a7_hold:' || l_return_status, 2 ) ;
2407: END IF;

Line 2446: If l_return_status = FND_API.G_RET_STS_SUCCESS Then

2442: p_itemkey => l_itemkey_sso,
2443: x_return_status => l_return_status
2444: );
2445: End If;
2446: If l_return_status = FND_API.G_RET_STS_SUCCESS Then
2447: l_header_req := 'D';
2448: End If;
2449: End If;
2450: -- Call insert routine to insert line_id and status info

Line 2513: If l_return_status = FND_API.G_RET_STS_SUCCESS Then

2509: x_return_status => l_return_status
2510: );
2511: -- End If;
2512: End If;
2513: If l_return_status = FND_API.G_RET_STS_SUCCESS Then
2514: l_header_req_cso := 'D';
2515: End If;
2516: End If;
2517: -- Call insert routine to insert line_id and status info

Line 2554: IF l_hold_result = FND_API.G_TRUE THEN

2550: , x_msg_data => l_msg_data
2551: , x_return_status => l_return_status
2552: );
2553:
2554: IF l_hold_result = FND_API.G_TRUE THEN
2555: IF l_debug_level > 0 THEN
2556: oe_debug_pub.add( 'Process SSO: Hold Already Applied On Header Id:'
2557: ||l_header_rec.header_id ||': Line_Id:'||l_line_tbl(i).line_id) ;
2558: oe_debug_pub.add( 'Change line status for 3A7');

Line 2608: if l_return_status = FND_API.G_RET_STS_SUCCESS Then

2604: p_itemkey => l_itemkey_sso,
2605: x_return_status => l_return_status
2606: );
2607: End If;
2608: if l_return_status = FND_API.G_RET_STS_SUCCESS Then
2609: l_header_req := 'D';
2610: end if;
2611: end if;
2612: if l_header_req_cso = 'Y' Then

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: if l_header_req = 'D' then

Line 2906: If l_return_status <> FND_API.G_RET_STS_SUCCESS

2902: x_party_site_id => l_party_site_id,
2903: x_is_delivery_required => l_is_delivery_required,
2904: x_return_status => l_return_status
2905: );
2906: If l_return_status <> FND_API.G_RET_STS_SUCCESS
2907: Or l_is_delivery_required = 'N' Then
2908: fnd_file.put_line(FND_FILE.OUTPUT,'Show SO not enabled for TP: ' || p_customer_id);
2909: If l_debug_level > 0 THEN
2910: oe_debug_pub.add( 'CONC PGM NOT RAISING SSO EVENT FOR TP: '|| p_customer_id);

Line 2930: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2926: IF l_debug_level > 0 THEN
2927: oe_debug_pub.add( 'AFTER OE_ACKNOWLEDGMENT_PUB.RAISE_EVENT_SHOWSO API: RETURN STATUS:'||L_RETURN_STATUS , 2 ) ;
2928: END IF;
2929:
2930: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2931: fnd_file.put_line(FND_FILE.OUTPUT,'Not able to raise the event for Document Number : ' || l_order_rec.orig_sys_document_ref(i));
2932: fnd_file.put_line(FND_FILE.OUTPUT,'Error : ' || sqlerrm);
2933: l_return_status := FND_API.G_RET_STS_SUCCESS;
2934: ELSE

Line 2933: l_return_status := FND_API.G_RET_STS_SUCCESS;

2929:
2930: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2931: fnd_file.put_line(FND_FILE.OUTPUT,'Not able to raise the event for Document Number : ' || l_order_rec.orig_sys_document_ref(i));
2932: fnd_file.put_line(FND_FILE.OUTPUT,'Error : ' || sqlerrm);
2933: l_return_status := FND_API.G_RET_STS_SUCCESS;
2934: ELSE
2935: fnd_file.put_line(FND_FILE.OUTPUT,'Successfully raised the event for Document Number : ' ||l_order_rec.orig_sys_document_ref(i));
2936: END IF;
2937:

Line 2949: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2945: -- Exception Handling
2946: EXCEPTION
2947:
2948: WHEN OTHERS THEN
2949: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2950: IF l_debug_level > 0 THEN
2951: oe_debug_pub.add( 'WHEN OTHERS - EXITING OE_ACKNOWLEDGMENT_PUB.PROCESS_SSO_CONC_PGM' , 2 ) ;
2952: oe_debug_pub.add( 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE ) ;
2953: END IF;

Line 3031: x_return_status := FND_API.G_RET_STS_SUCCESS;

3027: IF p_order_source_id <> G_XML_ORDER_SOURCE_ID THEN
3028: IF l_debug_level > 0 THEN
3029: oe_debug_pub.add( 'LEAVING RAISE_EVENT_XMLINT FOR DISABLED ORDER SOURCE: '|| p_order_source_id ) ;
3030: END IF;
3031: x_return_status := FND_API.G_RET_STS_SUCCESS;
3032: return;
3033: END IF;
3034: ELSIF l_integ_profile = 'EDIXML' THEN
3035: IF p_order_source_id NOT IN (G_XML_ORDER_SOURCE_ID, OE_GLOBALS.G_ORDER_SOURCE_EDI) THEN

Line 3039: x_return_status := FND_API.G_RET_STS_SUCCESS;

3035: IF p_order_source_id NOT IN (G_XML_ORDER_SOURCE_ID, OE_GLOBALS.G_ORDER_SOURCE_EDI) THEN
3036: IF l_debug_level > 0 THEN
3037: oe_debug_pub.add( 'LEAVING RAISE_EVENT_XMLINT FOR DISABLED ORDER SOURCE: '|| p_order_source_id ) ;
3038: END IF;
3039: x_return_status := FND_API.G_RET_STS_SUCCESS;
3040: return;
3041: END IF;
3042: END IF;
3043:

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

3058:
3059: /* error checking primarily to guard against some OI cases where we
3060: get G_MISS_VALUES */
3061:
3062: IF FND_API.G_MISS_NUM IN (p_order_source_id, p_sold_to_org_id) THEN
3063: l_parameter_list.DELETE;
3064: x_return_status := FND_API.G_RET_STS_SUCCESS;
3065:
3066: IF l_debug_level > 0 THEN

Line 3064: x_return_status := FND_API.G_RET_STS_SUCCESS;

3060: get G_MISS_VALUES */
3061:
3062: IF FND_API.G_MISS_NUM IN (p_order_source_id, p_sold_to_org_id) THEN
3063: l_parameter_list.DELETE;
3064: x_return_status := FND_API.G_RET_STS_SUCCESS;
3065:
3066: IF l_debug_level > 0 THEN
3067: oe_debug_pub.add( 'NOT RAISING oracle.apps.ont.oi.xml_int.status without order source or sold to org id' ) ;
3068: oe_debug_pub.add( 'order source ' || p_order_source_id || ' or sold to org id' || p_sold_to_org_id ) ;

Line 3074: IF l_conc_request_id = FND_API.G_MISS_NUM THEN

3070: END IF;
3071: Return;
3072: END IF;
3073:
3074: IF l_conc_request_id = FND_API.G_MISS_NUM THEN
3075: l_conc_request_id := NULL;
3076: l_converted := l_converted || 'CONC_REQUEST_ID, ';
3077: END IF;
3078: IF l_header_id = FND_API.G_MISS_NUM THEN

Line 3078: IF l_header_id = FND_API.G_MISS_NUM THEN

3074: IF l_conc_request_id = FND_API.G_MISS_NUM THEN
3075: l_conc_request_id := NULL;
3076: l_converted := l_converted || 'CONC_REQUEST_ID, ';
3077: END IF;
3078: IF l_header_id = FND_API.G_MISS_NUM THEN
3079: l_header_id := NULL;
3080: l_converted := l_converted || 'HEADER_ID, ';
3081: END IF;
3082: IF l_org_id = FND_API.G_MISS_NUM THEN

Line 3082: IF l_org_id = FND_API.G_MISS_NUM THEN

3078: IF l_header_id = FND_API.G_MISS_NUM THEN
3079: l_header_id := NULL;
3080: l_converted := l_converted || 'HEADER_ID, ';
3081: END IF;
3082: IF l_org_id = FND_API.G_MISS_NUM THEN
3083:
3084: /* SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',
3085: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))) into l_org_id from DUAL; */
3086: l_org_id := MO_GLOBAL.Get_Current_Org_Id; --moac

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

3090: IF l_xmlg_icn IS NULL THEN
3091: l_xmlg_icn := l_eventkey; --reuse sequence value (mainly for generic OI)
3092: END IF;
3093:
3094: IF l_doc_status = FND_API.G_RET_STS_SUCCESS THEN -- calls from Order Import Conc Pgm
3095: l_doc_status := 'SUCCESS';
3096: l_processing_stage := 'IMPORT_SUCCESS';
3097: ELSIF l_doc_status IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN
3098: l_doc_status := 'ERROR';

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

3093:
3094: IF l_doc_status = FND_API.G_RET_STS_SUCCESS THEN -- calls from Order Import Conc Pgm
3095: l_doc_status := 'SUCCESS';
3096: l_processing_stage := 'IMPORT_SUCCESS';
3097: ELSIF l_doc_status IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN
3098: l_doc_status := 'ERROR';
3099: l_processing_stage := 'IMPORT_FAILURE';
3100: END IF;
3101:

Line 3389: x_return_status := FND_API.G_RET_STS_SUCCESS;

3385: IF p_order_source_id <> G_XML_ORDER_SOURCE_ID OR
3386: l_processing_stage NOT IN ('IMPORT_SUCCESS', 'OUTBOUND_SENT') OR
3387: l_transaction_subtype = G_TRANSACTION_CBODO THEN
3388: l_parameter_list.DELETE;
3389: x_return_status := FND_API.G_RET_STS_SUCCESS;
3390:
3391: IF l_debug_level > 0 THEN
3392: oe_debug_pub.add( 'NOT RAISING oracle.apps.ont.oi.xml_int.status for this pre-110510 case' ) ;
3393: oe_debug_pub.add( 'EXITING RAISE_EVENT_XMLINT' ) ;

Line 3412: x_return_status := FND_API.G_RET_STS_SUCCESS;

3408:
3409:
3410: l_parameter_list.DELETE;
3411:
3412: x_return_status := FND_API.G_RET_STS_SUCCESS;
3413: EXCEPTION
3414: When Others Then
3415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3416: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 3415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3411:
3412: x_return_status := FND_API.G_RET_STS_SUCCESS;
3413: EXCEPTION
3414: When Others Then
3415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3416: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3417: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Xmlint');
3418: END IF;
3419: IF l_debug_level > 0 THEN

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

3434: , p_tp_check IN VARCHAR2
3435: , x_return_status OUT NOCOPY VARCHAR2
3436: )
3437: IS
3438: l_tp_check VARCHAR2(1) := nvl(p_tp_check, FND_API.G_TRUE);
3439: l_msg_count NUMBER := 0;
3440: l_msg_data VARCHAR2(2000);
3441: l_return_status VARCHAR2(30) := fnd_api.g_ret_sts_success;
3442: l_hold_result VARCHAR2(30);

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

3437: IS
3438: l_tp_check VARCHAR2(1) := nvl(p_tp_check, FND_API.G_TRUE);
3439: l_msg_count NUMBER := 0;
3440: l_msg_data VARCHAR2(2000);
3441: l_return_status VARCHAR2(30) := fnd_api.g_ret_sts_success;
3442: l_hold_result VARCHAR2(30);
3443: l_hold_source_rec OE_Holds_PVT.Hold_Source_REC_type;
3444: l_is_delivery_required_cso VARCHAR2(1) := 'N';
3445: l_hold_id NUMBER := 56;

Line 3456: IF l_tp_check = FND_API.G_TRUE THEN

3452: IF l_debug_level > 0 THEN
3453: oe_debug_pub.add( 'Entering Apply_3A7_Hold' ) ;
3454: END IF;
3455:
3456: IF l_tp_check = FND_API.G_TRUE THEN
3457: IF l_debug_level > 0 THEN
3458: oe_debug_pub.add( 'Before Calling OE_Acknowledgment_PUB.Is_Delivery_Required') ;
3459: END IF;
3460:

Line 3474: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

3470:
3471: IF l_debug_level > 0 THEN
3472: 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 ) ;
3473: END IF;
3474: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3475: IF l_is_delivery_required_cso = 'Y' THEN
3476: IF l_debug_level > 0 THEN
3477: oe_debug_pub.add('3A7 enabled transaction. Hold should be applied');
3478: END IF;

Line 3511: IF l_hold_result = FND_API.G_TRUE THEN

3507: , x_return_status => l_return_status
3508: );
3509:
3510: -- Return with Success if this Hold Already exists on the order line
3511: IF l_hold_result = FND_API.G_TRUE THEN
3512: IF l_debug_level > 0 THEN
3513: oe_debug_pub.add( ' Hold Already Applied On Header Id:' || P_HEADER_ID||': Line_Id:'||p_line_id) ;
3514: END IF;
3515: RETURN ;

Line 3530: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

3526: l_hold_source_rec.header_id := p_header_id; -- Order Header
3527: l_hold_source_rec.line_id := p_line_id; -- Order line
3528: OE_Holds_PUB.Apply_Holds
3529: ( p_api_version => 1.0
3530: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
3531: , p_hold_source_rec => l_hold_source_rec
3532: , x_msg_count => l_msg_count
3533: , x_msg_data => l_msg_data
3534: , x_return_status => l_return_status

Line 3537: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3533: , x_msg_data => l_msg_data
3534: , x_return_status => l_return_status
3535: );
3536:
3537: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3538: RAISE FND_API.G_EXC_ERROR;
3539: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3541: END IF;

Line 3538: RAISE FND_API.G_EXC_ERROR;

3534: , x_return_status => l_return_status
3535: );
3536:
3537: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3538: RAISE FND_API.G_EXC_ERROR;
3539: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3541: END IF;
3542:

Line 3539: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3535: );
3536:
3537: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3538: RAISE FND_API.G_EXC_ERROR;
3539: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3541: END IF;
3542:
3543: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3536:
3537: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3538: RAISE FND_API.G_EXC_ERROR;
3539: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3541: END IF;
3542:
3543: x_return_status := FND_API.G_RET_STS_SUCCESS;
3544:

Line 3543: x_return_status := FND_API.G_RET_STS_SUCCESS;

3539: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3541: END IF;
3542:
3543: x_return_status := FND_API.G_RET_STS_SUCCESS;
3544:
3545: IF l_debug_level > 0 THEN
3546: oe_debug_pub.add( 'Applied 3a7 Hold On Header Id:' || P_HEADER_ID||':Line_Id:'||p_line_id , 3 ) ;
3547: END IF;

Line 3551: WHEN FND_API.G_EXC_ERROR THEN

3547: END IF;
3548:
3549: EXCEPTION
3550:
3551: WHEN FND_API.G_EXC_ERROR THEN
3552: IF l_debug_level > 0 THEN
3553: oe_debug_pub.add('In G_EXC_ERROR exception - Apply_3A7_hold');
3554: END IF;
3555: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3555: x_return_status := FND_API.G_RET_STS_ERROR;

3551: WHEN FND_API.G_EXC_ERROR THEN
3552: IF l_debug_level > 0 THEN
3553: oe_debug_pub.add('In G_EXC_ERROR exception - Apply_3A7_hold');
3554: END IF;
3555: x_return_status := FND_API.G_RET_STS_ERROR;
3556: OE_MSG_PUB.Count_And_Get
3557: ( p_count => l_msg_count,
3558: p_data => l_msg_data
3559: );

Line 3561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3557: ( p_count => l_msg_count,
3558: p_data => l_msg_data
3559: );
3560:
3561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3562: IF l_debug_level > 0 THEN
3563: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Apply_3A7_hold');
3564: END IF;
3565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3562: IF l_debug_level > 0 THEN
3563: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Apply_3A7_hold');
3564: END IF;
3565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3566: OE_MSG_PUB.Count_And_Get
3567: ( p_count => l_msg_count,
3568: p_data => l_msg_data
3569: );

Line 3575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3571: WHEN OTHERS THEN
3572: IF l_debug_level > 0 THEN
3573: oe_debug_pub.add('In when others exception - Apply_3A7_hold');
3574: END IF;
3575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3576: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3577: THEN
3578: FND_MSG_PUB.Add_Exc_Msg
3579: ( G_PKG_NAME

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

3600: l_hold_id NUMBER := 56;
3601: l_hold_exists VARCHAR2(1);
3602: l_msg_count NUMBER := 0;
3603: l_msg_data VARCHAR2(2000);
3604: l_return_status VARCHAR2(30) := fnd_api.g_ret_sts_success;
3605: l_release_reason VARCHAR2(30);
3606: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
3607: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
3608: l_hold_result VARCHAR2(30);

Line 3633: IF l_hold_result = FND_API.G_TRUE THEN

3629: , x_return_status => l_return_status
3630: );
3631:
3632: -- Return with Success if this Hold exists on the order line
3633: IF l_hold_result = FND_API.G_TRUE THEN
3634: IF l_debug_level > 0 THEN
3635: oe_debug_pub.add( ' Hold Exists On Header Id:' || P_HEADER_ID||': Line_Id:'||p_line_id) ;
3636: END IF;
3637: l_hold_exists := 'Y';

Line 3660: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3656: , x_msg_data => l_msg_data
3657: , x_return_status => l_return_status
3658: );
3659:
3660: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3661: RAISE FND_API.G_EXC_ERROR;
3662: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3664: END IF;

Line 3661: RAISE FND_API.G_EXC_ERROR;

3657: , x_return_status => l_return_status
3658: );
3659:
3660: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3661: RAISE FND_API.G_EXC_ERROR;
3662: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3664: END IF;
3665: IF l_debug_level > 0 THEN

Line 3662: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3658: );
3659:
3660: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3661: RAISE FND_API.G_EXC_ERROR;
3662: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3664: END IF;
3665: IF l_debug_level > 0 THEN
3666: oe_debug_pub.add( 'Released 3a7 Hold On Header Id:' || P_HEADER_ID ||':Line_Id:'||p_line_id, 3 ) ;

Line 3663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3659:
3660: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3661: RAISE FND_API.G_EXC_ERROR;
3662: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3664: END IF;
3665: IF l_debug_level > 0 THEN
3666: oe_debug_pub.add( 'Released 3a7 Hold On Header Id:' || P_HEADER_ID ||':Line_Id:'||p_line_id, 3 ) ;
3667: END IF;

Line 3670: x_return_status := FND_API.G_RET_STS_SUCCESS;

3666: oe_debug_pub.add( 'Released 3a7 Hold On Header Id:' || P_HEADER_ID ||':Line_Id:'||p_line_id, 3 ) ;
3667: END IF;
3668:
3669: END IF; -- hold exists
3670: x_return_status := FND_API.G_RET_STS_SUCCESS;
3671: IF l_debug_level > 0 THEN
3672: oe_debug_pub.add( 'Exiting Release_3A7 Hold', 3 ) ;
3673: END IF;
3674:

Line 3677: WHEN FND_API.G_EXC_ERROR THEN

3673: END IF;
3674:
3675: EXCEPTION
3676:
3677: WHEN FND_API.G_EXC_ERROR THEN
3678: IF l_debug_level > 0 THEN
3679: oe_debug_pub.add('In G_EXC_ ERROR exception - Release_3A7_hold');
3680: END IF;
3681: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3681: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3683: ( p_count => l_msg_count,
3684: p_data => l_msg_data
3685: );
3686:
3687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3688: IF l_debug_level > 0 THEN
3689: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Release_3A7_hold');
3690: END IF;
3691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3688: IF l_debug_level > 0 THEN
3689: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Release_3A7_hold');
3690: END IF;
3691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3692: OE_MSG_PUB.Count_And_Get
3693: ( p_count => l_msg_count,
3694: p_data => l_msg_data
3695: );

Line 3701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3697: WHEN OTHERS THEN
3698: IF l_debug_level > 0 THEN
3699: oe_debug_pub.add('In when others exception - Release_3A7_hold');
3700: END IF;
3701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3702: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3703: THEN
3704: FND_MSG_PUB.Add_Exc_Msg
3705: ( G_PKG_NAME

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

3724: )
3725: IS
3726: l_msg_count NUMBER := 0;
3727: l_msg_data VARCHAR2(2000);
3728: l_return_status VARCHAR2(30) := fnd_api.g_ret_sts_success;
3729: l_release_3a7_hold_flag VARCHAR2(1) := 'N';
3730: --
3731: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3732: --

Line 3774: RAISE FND_API.G_EXC_ERROR;

3770: oe_debug_pub.add( '3A8 response received, columns does not match and qty <> 0, Raise an error', 3 ) ;
3771: END IF;
3772: FND_MESSAGE.SET_NAME('ONT', 'ONT_3A8_RESPONSE_COL_MISMATCH');
3773: OE_MSG_PUB.Add;
3774: RAISE FND_API.G_EXC_ERROR;
3775: END IF; -- check for columns
3776: END IF; -- check for independent/response 3A8
3777:
3778: IF l_release_3a7_hold_flag = 'Y' THEN

Line 3787: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3783: ( p_header_id => p_x_line_rec.header_id
3784: , p_line_id => p_x_line_rec.line_id
3785: , x_return_status => l_return_status
3786: );
3787: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3788: RAISE FND_API.G_EXC_ERROR;
3789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3791: END IF;

Line 3788: RAISE FND_API.G_EXC_ERROR;

3784: , p_line_id => p_x_line_rec.line_id
3785: , x_return_status => l_return_status
3786: );
3787: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3788: RAISE FND_API.G_EXC_ERROR;
3789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3791: END IF;
3792:

Line 3789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3785: , x_return_status => l_return_status
3786: );
3787: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3788: RAISE FND_API.G_EXC_ERROR;
3789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3791: END IF;
3792:
3793: END IF;

Line 3790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3786: );
3787: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3788: RAISE FND_API.G_EXC_ERROR;
3789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3791: END IF;
3792:
3793: END IF;
3794:

Line 3795: x_return_status := FND_API.G_RET_STS_SUCCESS;

3791: END IF;
3792:
3793: END IF;
3794:
3795: x_return_status := FND_API.G_RET_STS_SUCCESS;
3796: IF l_debug_level > 0 THEN
3797: oe_debug_pub.add( 'Exiting Process_3A8', 3 ) ;
3798: END IF;
3799:

Line 3802: WHEN FND_API.G_EXC_ERROR THEN

3798: END IF;
3799:
3800: EXCEPTION
3801:
3802: WHEN FND_API.G_EXC_ERROR THEN
3803: IF l_debug_level > 0 THEN
3804: oe_debug_pub.add('In G_EXC_ ERROR exception - Process_3A8');
3805: END IF;
3806: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3806: x_return_status := FND_API.G_RET_STS_ERROR;

3802: WHEN FND_API.G_EXC_ERROR THEN
3803: IF l_debug_level > 0 THEN
3804: oe_debug_pub.add('In G_EXC_ ERROR exception - Process_3A8');
3805: END IF;
3806: x_return_status := FND_API.G_RET_STS_ERROR;
3807: OE_MSG_PUB.Count_And_Get
3808: ( p_count => l_msg_count,
3809: p_data => l_msg_data
3810: );

Line 3812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3808: ( p_count => l_msg_count,
3809: p_data => l_msg_data
3810: );
3811:
3812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3813: IF l_debug_level > 0 THEN
3814: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Process_3A8');
3815: END IF;
3816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3813: IF l_debug_level > 0 THEN
3814: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Process_3A8');
3815: END IF;
3816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3817: OE_MSG_PUB.Count_And_Get
3818: ( p_count => l_msg_count,
3819: p_data => l_msg_data
3820: );

Line 3826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3822: WHEN OTHERS THEN
3823: IF l_debug_level > 0 THEN
3824: oe_debug_pub.add('In when others exception - Process_3A8');
3825: END IF;
3826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3827: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3828: THEN
3829: FND_MSG_PUB.Add_Exc_Msg
3830: ( G_PKG_NAME

Line 3924: x_return_status := FND_API.G_RET_STS_SUCCESS;

3920: wf_event.raise( p_event_name => 'oracle.apps.ont.oi.cbod_out.confirm',
3921: p_event_key => l_eventkey,
3922: p_parameters => l_parameter_list);
3923:
3924: x_return_status := FND_API.G_RET_STS_SUCCESS;
3925: Else
3926: x_return_status := FND_API.G_RET_STS_ERROR;
3927: End If;
3928:

Line 3926: x_return_status := FND_API.G_RET_STS_ERROR;

3922: p_parameters => l_parameter_list);
3923:
3924: x_return_status := FND_API.G_RET_STS_SUCCESS;
3925: Else
3926: x_return_status := FND_API.G_RET_STS_ERROR;
3927: End If;
3928:
3929: l_parameter_list.DELETE;
3930:

Line 3934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3930:
3931: Exception
3932: When Others Then
3933: l_parameter_list.DELETE;
3934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3935:
3936: END Raise_CBOD_Out_Event;
3937:
3938: END OE_Acknowledgment_Pub;