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.23.12020000.2 2012/07/03 10:00:14 amallik 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.23.12020000.2 2012/07/03 10:00:14 amallik 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 208: OE_Acknowledgment_Pub.Is_Delivery_Required

204: END IF;
205:
206: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
207: IF p_check_for_delivery = 'Y' THEN
208: OE_Acknowledgment_Pub.Is_Delivery_Required
209: (
210: p_customer_id => p_sold_to_org_id,
211: p_transaction_type => G_TRANSACTION_TYPE,
212: p_transaction_subtype => G_TRANSACTION_POA,

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

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');
318: END IF;
319:
320:
321: End Raise_Event_From_Oeoi;

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

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');
525: END IF;
526:
527: End Raise_Event_Showso;
528: -- End of Procedure to raise 3a6 event}

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

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

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

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
701: (G_PKG_NAME, 'OE_Acknowledgment_Pub.Process_Acknowledgment');
702: END IF;
703:
704:
705: END Process_Acknowledgment;

Line 2515: OE_Acknowledgment_PUB.Apply_3A7_Hold

2511:
2512: IF l_debug_level > 0 THEN
2513: oe_debug_pub.add( 'Calling OE_Acknowlegment_PUB.Apply_3A7_Hold', 2 ) ;
2514: END IF;
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

Line 2757: OE_Acknowledgment_Pub.Raise_Event_Showso

2753: IF l_debug_level > 0 THEN
2754: oe_debug_pub.add( 'Raising 3a6 event with itemkey: ' || l_itemkey_sso) ;
2755: END IF;
2756:
2757: OE_Acknowledgment_Pub.Raise_Event_Showso
2758: (p_header_id => l_header_rec.header_id,
2759: p_line_id => Null,
2760: p_customer_id => l_header_rec.sold_to_org_id,
2761: p_orig_sys_document_ref => l_header_rec.orig_sys_document_ref,

Line 2780: OE_Acknowledgment_Pub.Raise_Event_Showso

2776: IF l_debug_level > 0 THEN
2777: oe_debug_pub.add( 'Raising 3a7 event with itemkey: ' || l_itemkey_cso) ;
2778: END IF;
2779:
2780: OE_Acknowledgment_Pub.Raise_Event_Showso
2781: (p_header_id => l_header_rec.header_id,
2782: p_line_id => Null,
2783: p_customer_id => l_header_rec.sold_to_org_id,
2784: p_orig_sys_document_ref => l_header_rec.orig_sys_document_ref,

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

3000: -- Raise event for all orders fetched
3001: -----------------------------------------------------------
3002: FOR i IN 1..l_order_count LOOP
3003: IF l_debug_level > 0 THEN
3004: oe_debug_pub.add( 'BEFORE CALL TO OE_ACKNOWLEDGMENT_PUB.RAISE_EVENT_SHOWSO API: '||I , 2 ) ;
3005: oe_debug_pub.add( 'HEADER ID: '||L_ORDER_REC.HEADER_ID ( I ) , 1 ) ;
3006: oe_debug_pub.add( 'SOLD TO ORGID: '||L_ORDER_REC.SOLD_TO_ORG_ID ( I ) , 1 ) ;
3007: oe_debug_pub.add( 'SALES ORDER NUMBER: '||L_ORDER_REC.ORDER_NUMBER ( I ) , 1 ) ;
3008: oe_debug_pub.add( 'ORIG SYS DOCUMENT REF: '||L_ORDER_REC.ORIG_SYS_DOCUMENT_REF ( I ) , 1 ) ;

Line 3030: OE_ACKNOWLEDGMENT_PUB.Raise_Event_Showso (

3026: oe_debug_pub.add( 'CONC PGM NOT RAISING SSO EVENT FOR TP: '|| p_customer_id);
3027: End If;
3028: Else
3029:
3030: OE_ACKNOWLEDGMENT_PUB.Raise_Event_Showso (
3031: p_header_id => l_order_rec.header_id(i),
3032: p_line_id => null,
3033: p_customer_id => l_order_rec.sold_to_org_id(i),
3034: p_orig_sys_document_ref => l_order_rec.orig_sys_document_ref(i),

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

3039: p_request_id => l_request_id,
3040: p_org_id => l_order_rec.org_id(i),
3041: x_return_status => l_return_status );
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));

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

3054: End If;
3055: END LOOP;
3056: END IF;
3057: IF l_debug_level > 0 THEN
3058: oe_debug_pub.add( 'EXITING OE_ACKNOWLEDGMENT_PUB.PROCESS_SSO_CONC_PGM' , 2 ) ;
3059: END IF;
3060:
3061: -- Exception Handling
3062: EXCEPTION

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

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

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

3224: fnd_message.set_name ('ONT', 'OE_OI_IMPORT_SUCCESS_GEN');
3225: ELSIF l_processing_stage = 'IMPORT_FAILURE' THEN
3226: fnd_message.set_name ('ONT', 'OE_OI_IMPORT_FAILURE');
3227: END IF;
3228: l_txn_token := Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_subtype);
3229:
3230: If l_txn_token IS NOT NULL Then
3231: fnd_message.set_token ('TRANSACTION',l_txn_token || ' -');
3232: Else

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

3320: -----------------------------------------------------------------
3321: -- START CLN KEY PARAMS
3322: -----------------------------------------------------------------
3323:
3324: If ((l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_POI) OR
3325: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) OR
3326: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO) OR
3327: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_850) OR
3328: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_860) OR

Line 3325: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) OR

3321: -- START CLN KEY PARAMS
3322: -----------------------------------------------------------------
3323:
3324: If ((l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_POI) OR
3325: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) OR
3326: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO) OR
3327: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_850) OR
3328: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_860) OR
3329: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_GENERIC)) Then

Line 3326: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO) OR

3322: -----------------------------------------------------------------
3323:
3324: If ((l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_POI) OR
3325: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) OR
3326: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO) OR
3327: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_850) OR
3328: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_860) OR
3329: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_GENERIC)) Then
3330:

Line 3327: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_850) OR

3323:
3324: If ((l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_POI) OR
3325: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) OR
3326: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO) OR
3327: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_850) OR
3328: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_860) OR
3329: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_GENERIC)) Then
3330:
3331: /* l_internal_control_number := wf_engine.GetItemAttrNumber( p_itemtype

Line 3328: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_860) OR

3324: If ((l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_POI) OR
3325: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) OR
3326: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO) OR
3327: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_850) OR
3328: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_860) OR
3329: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_GENERIC)) Then
3330:
3331: /* l_internal_control_number := wf_engine.GetItemAttrNumber( p_itemtype
3332: , p_itemkey

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

3325: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) OR
3326: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO) OR
3327: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_850) OR
3328: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_860) OR
3329: (l_transaction_subtype = Oe_Acknowledgment_Pub.G_TRANSACTION_GENERIC)) Then
3330:
3331: /* l_internal_control_number := wf_engine.GetItemAttrNumber( p_itemtype
3332: , p_itemkey
3333: , 'PARAMETER5'

Line 3453: IF p_order_source_id = OE_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID

3449: p_parameterlist=> l_parameter_list);
3450:
3451: -- We also need to publish a subscriber list
3452: -- condition modified for bug 3433024
3453: IF p_order_source_id = OE_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID
3454: AND l_subscriber_list <> 'DEFAULT'
3455: AND l_processing_stage NOT IN ('OUTBOUND_TRIGGERED', 'OUTBOUND_SETUP') THEN
3456: l_subscriber_list := l_subscriber_list || ',CLN';
3457: END IF;

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

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:
3577: Is_Delivery_Required
3578: ( p_customer_id => p_sold_to_org_id,

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

3584: x_return_status => l_return_status
3585: );
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

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

3848: --
3849: BEGIN
3850:
3851: IF l_debug_level > 0 THEN
3852: oe_debug_pub.add( 'In OE_Acknowledgment_Pub.Process_3A8' , 3 ) ;
3853: END IF;
3854:
3855: /* 1) If independent 3A8 then release the hold.
3856: 2) If response 3A8 then

Line 4071: END OE_Acknowledgment_Pub;

4067: COMMIT;
4068: END;
4069:
4070:
4071: END OE_Acknowledgment_Pub;