eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ACKNOWLEDGMENT_PUB dependencies on OE_ACKNOWLEDGMENT_PUB

Line 1: PACKAGE BODY OE_Acknowledgment_Pub AS

1: PACKAGE BODY OE_Acknowledgment_Pub AS
2: /* $Header: OEXPACKB.pls 120.9 2007/12/24 04:35:37 snimmaga ship $ */
3:
4: /* -----------------------------------------------------------------
5: -- API name OE_Acknowledgment_Pub

Line 5: -- API name OE_Acknowledgment_Pub

1: PACKAGE BODY OE_Acknowledgment_Pub AS
2: /* $Header: OEXPACKB.pls 120.9 2007/12/24 04:35:37 snimmaga ship $ */
3:
4: /* -----------------------------------------------------------------
5: -- API name OE_Acknowledgment_Pub
6: --
7: -- Type Public
8: -- Function
9: --

Line 25: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Acknowledgment_Pub';

21: */
22:
23: -- Global constant holding the package name
24:
25: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Acknowledgment_Pub';
26:
27: -- { Start of the data type declaration for the Bulk Collect
28: -- DATA TYPES (RECORD/TABLE TYPES)
29:

Line 203: OE_Acknowledgment_Pub.Is_Delivery_Required

199: END IF;
200:
201: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
202: IF p_check_for_delivery = 'Y' THEN
203: OE_Acknowledgment_Pub.Is_Delivery_Required
204: (
205: p_customer_id => p_sold_to_org_id,
206: p_transaction_type => G_TRANSACTION_TYPE,
207: p_transaction_subtype => G_TRANSACTION_POA,

Line 312: (G_PKG_NAME, 'OE_Acknowledgment_Pub.Raise_Event_From_Oeoi');

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');
313: END IF;
314:
315:
316: End Raise_Event_From_Oeoi;

Line 519: (G_PKG_NAME, 'OE_Acknowledgment_Pub.Raise_Event_Showso');

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');
520: END IF;
521:
522: End Raise_Event_Showso;
523: -- End of Procedure to raise 3a6 event}

Line 689: oe_debug_pub.add( 'ENCOUNTERED OTHERS ERROR EXCEPTION IN OE_ACKNOWLEDGMENT_PUB.PROCESS_ACKNOWLEDGMENT: '|| SQLERRM ) ;

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 ) ;
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)

Line 696: (G_PKG_NAME, 'OE_Acknowledgment_Pub.Process_Acknowledgment');

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
696: (G_PKG_NAME, 'OE_Acknowledgment_Pub.Process_Acknowledgment');
697: END IF;
698:
699:
700: END Process_Acknowledgment;

Line 2399: OE_Acknowledgment_PUB.Apply_3A7_Hold

2395:
2396: IF l_debug_level > 0 THEN
2397: oe_debug_pub.add( 'Calling OE_Acknowlegment_PUB.Apply_3A7_Hold', 2 ) ;
2398: END IF;
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

Line 2641: OE_Acknowledgment_Pub.Raise_Event_Showso

2637: IF l_debug_level > 0 THEN
2638: oe_debug_pub.add( 'Raising 3a6 event with itemkey: ' || l_itemkey_sso) ;
2639: END IF;
2640:
2641: OE_Acknowledgment_Pub.Raise_Event_Showso
2642: (p_header_id => l_header_rec.header_id,
2643: p_line_id => Null,
2644: p_customer_id => l_header_rec.sold_to_org_id,
2645: p_orig_sys_document_ref => l_header_rec.orig_sys_document_ref,

Line 2664: OE_Acknowledgment_Pub.Raise_Event_Showso

2660: IF l_debug_level > 0 THEN
2661: oe_debug_pub.add( 'Raising 3a7 event with itemkey: ' || l_itemkey_cso) ;
2662: END IF;
2663:
2664: OE_Acknowledgment_Pub.Raise_Event_Showso
2665: (p_header_id => l_header_rec.header_id,
2666: p_line_id => Null,
2667: p_customer_id => l_header_rec.sold_to_org_id,
2668: p_orig_sys_document_ref => l_header_rec.orig_sys_document_ref,

Line 2888: oe_debug_pub.add( 'BEFORE CALL TO OE_ACKNOWLEDGMENT_PUB.RAISE_EVENT_SHOWSO API: '||I , 2 ) ;

2884: -- Raise event for all orders fetched
2885: -----------------------------------------------------------
2886: FOR i IN 1..l_order_count LOOP
2887: IF l_debug_level > 0 THEN
2888: oe_debug_pub.add( 'BEFORE CALL TO OE_ACKNOWLEDGMENT_PUB.RAISE_EVENT_SHOWSO API: '||I , 2 ) ;
2889: oe_debug_pub.add( 'HEADER ID: '||L_ORDER_REC.HEADER_ID ( I ) , 1 ) ;
2890: oe_debug_pub.add( 'SOLD TO ORGID: '||L_ORDER_REC.SOLD_TO_ORG_ID ( I ) , 1 ) ;
2891: oe_debug_pub.add( 'SALES ORDER NUMBER: '||L_ORDER_REC.ORDER_NUMBER ( I ) , 1 ) ;
2892: oe_debug_pub.add( 'ORIG SYS DOCUMENT REF: '||L_ORDER_REC.ORIG_SYS_DOCUMENT_REF ( I ) , 1 ) ;

Line 2914: OE_ACKNOWLEDGMENT_PUB.Raise_Event_Showso (

2910: oe_debug_pub.add( 'CONC PGM NOT RAISING SSO EVENT FOR TP: '|| p_customer_id);
2911: End If;
2912: Else
2913:
2914: OE_ACKNOWLEDGMENT_PUB.Raise_Event_Showso (
2915: p_header_id => l_order_rec.header_id(i),
2916: p_line_id => null,
2917: p_customer_id => l_order_rec.sold_to_org_id(i),
2918: p_orig_sys_document_ref => l_order_rec.orig_sys_document_ref(i),

Line 2927: oe_debug_pub.add( 'AFTER OE_ACKNOWLEDGMENT_PUB.RAISE_EVENT_SHOWSO API: RETURN STATUS:'||L_RETURN_STATUS , 2 ) ;

2923: p_request_id => l_request_id,
2924: p_org_id => l_order_rec.org_id(i),
2925: x_return_status => l_return_status );
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));

Line 2942: oe_debug_pub.add( 'EXITING OE_ACKNOWLEDGMENT_PUB.PROCESS_SSO_CONC_PGM' , 2 ) ;

2938: End If;
2939: END LOOP;
2940: END IF;
2941: IF l_debug_level > 0 THEN
2942: oe_debug_pub.add( 'EXITING OE_ACKNOWLEDGMENT_PUB.PROCESS_SSO_CONC_PGM' , 2 ) ;
2943: END IF;
2944:
2945: -- Exception Handling
2946: EXCEPTION

Line 2951: oe_debug_pub.add( 'WHEN OTHERS - EXITING OE_ACKNOWLEDGMENT_PUB.PROCESS_SSO_CONC_PGM' , 2 ) ;

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;
2954: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2955: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'process_sso_conc_pgm');

Line 3112: l_txn_token := Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_subtype);

3108: fnd_message.set_name ('ONT', 'OE_OI_IMPORT_SUCCESS_GEN');
3109: ELSIF l_processing_stage = 'IMPORT_FAILURE' THEN
3110: fnd_message.set_name ('ONT', 'OE_OI_IMPORT_FAILURE');
3111: END IF;
3112: l_txn_token := Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_subtype);
3113:
3114: If l_txn_token IS NOT NULL Then
3115: fnd_message.set_token ('TRANSACTION',l_txn_token || ' -');
3116: Else

Line 3208: If ((l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_POI) OR

3204: -----------------------------------------------------------------
3205: -- START CLN KEY PARAMS
3206: -----------------------------------------------------------------
3207:
3208: If ((l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_POI) OR
3209: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) OR
3210: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO) OR
3211: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_850) OR
3212: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_860) OR

Line 3209: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) OR

3205: -- START CLN KEY PARAMS
3206: -----------------------------------------------------------------
3207:
3208: If ((l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_POI) OR
3209: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) OR
3210: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO) OR
3211: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_850) OR
3212: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_860) OR
3213: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_GENERIC)) Then

Line 3210: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO) OR

3206: -----------------------------------------------------------------
3207:
3208: If ((l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_POI) OR
3209: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) OR
3210: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO) OR
3211: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_850) OR
3212: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_860) OR
3213: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_GENERIC)) Then
3214:

Line 3211: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_850) OR

3207:
3208: If ((l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_POI) OR
3209: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) OR
3210: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO) OR
3211: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_850) OR
3212: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_860) OR
3213: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_GENERIC)) Then
3214:
3215: /* l_internal_control_number := wf_engine.GetItemAttrNumber( p_itemtype

Line 3212: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_860) OR

3208: If ((l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_POI) OR
3209: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) OR
3210: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO) OR
3211: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_850) OR
3212: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_860) OR
3213: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_GENERIC)) Then
3214:
3215: /* l_internal_control_number := wf_engine.GetItemAttrNumber( p_itemtype
3216: , p_itemkey

Line 3213: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_GENERIC)) Then

3209: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) OR
3210: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO) OR
3211: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_850) OR
3212: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_860) OR
3213: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_GENERIC)) Then
3214:
3215: /* l_internal_control_number := wf_engine.GetItemAttrNumber( p_itemtype
3216: , p_itemkey
3217: , 'PARAMETER5'

Line 3337: IF p_order_source_id = OE_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID

3333: p_parameterlist=> l_parameter_list);
3334:
3335: -- We also need to publish a subscriber list
3336: -- condition modified for bug 3433024
3337: IF p_order_source_id = OE_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID
3338: AND l_subscriber_list <> 'DEFAULT'
3339: AND l_processing_stage NOT IN ('OUTBOUND_TRIGGERED', 'OUTBOUND_SETUP') THEN
3340: l_subscriber_list := l_subscriber_list || ',CLN';
3341: END IF;

Line 3458: oe_debug_pub.add( 'Before Calling OE_Acknowledgment_PUB.Is_Delivery_Required') ;

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:
3461: Is_Delivery_Required
3462: ( p_customer_id => p_sold_to_org_id,

Line 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 ) ;

3468: x_return_status => l_return_status
3469: );
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

Line 3736: oe_debug_pub.add( 'In OE_Acknowledgment_Pub.Process_3A8' , 3 ) ;

3732: --
3733: BEGIN
3734:
3735: IF l_debug_level > 0 THEN
3736: oe_debug_pub.add( 'In OE_Acknowledgment_Pub.Process_3A8' , 3 ) ;
3737: END IF;
3738:
3739: /* 1) If independent 3A8 then release the hold.
3740: 2) If response 3A8 then

Line 3938: END OE_Acknowledgment_Pub;

3934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3935:
3936: END Raise_CBOD_Out_Event;
3937:
3938: END OE_Acknowledgment_Pub;