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 WF_EVENT

Line 240: wf_event.AddParameterToList(p_name=> 'ORIG_SYS_DOCUMENT_REF',

236: l_user_key := p_orig_sys_document_ref || ',' || to_char(p_sold_to_org_id) || ',' || p_transaction_type;
237: End If;
238:
239:
240: wf_event.AddParameterToList(p_name=> 'ORIG_SYS_DOCUMENT_REF',
241: p_value=> p_orig_sys_document_ref,
242: p_parameterlist=> l_parameter_list);
243: wf_event.AddParameterToList(p_name=> 'PARAMETER3',
244: p_value=> p_transaction_type,

Line 243: wf_event.AddParameterToList(p_name=> 'PARAMETER3',

239:
240: wf_event.AddParameterToList(p_name=> 'ORIG_SYS_DOCUMENT_REF',
241: p_value=> p_orig_sys_document_ref,
242: p_parameterlist=> l_parameter_list);
243: wf_event.AddParameterToList(p_name=> 'PARAMETER3',
244: p_value=> p_transaction_type,
245: p_parameterlist=> l_parameter_list);
246: wf_event.AddParameterToList(p_name=> 'PARAMETER4',
247: p_value=> p_sold_to_org_id,

Line 246: wf_event.AddParameterToList(p_name=> 'PARAMETER4',

242: p_parameterlist=> l_parameter_list);
243: wf_event.AddParameterToList(p_name=> 'PARAMETER3',
244: p_value=> p_transaction_type,
245: p_parameterlist=> l_parameter_list);
246: wf_event.AddParameterToList(p_name=> 'PARAMETER4',
247: p_value=> p_sold_to_org_id,
248: p_parameterlist=> l_parameter_list);
249: wf_event.AddParameterToList(p_name=> 'PARAMETER7',
250: p_value=> p_change_sequence,

Line 249: wf_event.AddParameterToList(p_name=> 'PARAMETER7',

245: p_parameterlist=> l_parameter_list);
246: wf_event.AddParameterToList(p_name=> 'PARAMETER4',
247: p_value=> p_sold_to_org_id,
248: p_parameterlist=> l_parameter_list);
249: wf_event.AddParameterToList(p_name=> 'PARAMETER7',
250: p_value=> p_change_sequence,
251: p_parameterlist=> l_parameter_list);
252: wf_event.AddParameterToList(p_name=> 'START_FROM_FLOW',
253: p_value=> l_start_from_flow,

Line 252: wf_event.AddParameterToList(p_name=> 'START_FROM_FLOW',

248: p_parameterlist=> l_parameter_list);
249: wf_event.AddParameterToList(p_name=> 'PARAMETER7',
250: p_value=> p_change_sequence,
251: p_parameterlist=> l_parameter_list);
252: wf_event.AddParameterToList(p_name=> 'START_FROM_FLOW',
253: p_value=> l_start_from_flow,
254: p_parameterlist=> l_parameter_list);
255: wf_event.AddParameterToList(p_name=> 'REQ_ID',
256: p_value=> p_request_id,

Line 255: wf_event.AddParameterToList(p_name=> 'REQ_ID',

251: p_parameterlist=> l_parameter_list);
252: wf_event.AddParameterToList(p_name=> 'START_FROM_FLOW',
253: p_value=> l_start_from_flow,
254: p_parameterlist=> l_parameter_list);
255: wf_event.AddParameterToList(p_name=> 'REQ_ID',
256: p_value=> p_request_id,
257: p_parameterlist=> l_parameter_list);
258: wf_event.AddParameterToList(p_name=> 'ORDER_IMPORTED',
259: p_value=> p_order_imported,

Line 258: wf_event.AddParameterToList(p_name=> 'ORDER_IMPORTED',

254: p_parameterlist=> l_parameter_list);
255: wf_event.AddParameterToList(p_name=> 'REQ_ID',
256: p_value=> p_request_id,
257: p_parameterlist=> l_parameter_list);
258: wf_event.AddParameterToList(p_name=> 'ORDER_IMPORTED',
259: p_value=> p_order_imported,
260: p_parameterlist=> l_parameter_list);
261: wf_event.AddParameterToList(p_name=> 'USER_KEY',
262: p_value=> l_user_key,

Line 261: wf_event.AddParameterToList(p_name=> 'USER_KEY',

257: p_parameterlist=> l_parameter_list);
258: wf_event.AddParameterToList(p_name=> 'ORDER_IMPORTED',
259: p_value=> p_order_imported,
260: p_parameterlist=> l_parameter_list);
261: wf_event.AddParameterToList(p_name=> 'USER_KEY',
262: p_value=> l_user_key,
263: p_parameterlist=> l_parameter_list);
264: wf_event.AddParameterToList(p_name=> 'ORG_ID',
265: p_value=> p_org_id,

Line 264: wf_event.AddParameterToList(p_name=> 'ORG_ID',

260: p_parameterlist=> l_parameter_list);
261: wf_event.AddParameterToList(p_name=> 'USER_KEY',
262: p_value=> l_user_key,
263: p_parameterlist=> l_parameter_list);
264: wf_event.AddParameterToList(p_name=> 'ORG_ID',
265: p_value=> p_org_id,
266: p_parameterlist=> l_parameter_list);
267: wf_event.AddParameterToList(p_name=> 'PARAMETER5',
268: p_value=> p_xml_message_id,

Line 267: wf_event.AddParameterToList(p_name=> 'PARAMETER5',

263: p_parameterlist=> l_parameter_list);
264: wf_event.AddParameterToList(p_name=> 'ORG_ID',
265: p_value=> p_org_id,
266: p_parameterlist=> l_parameter_list);
267: wf_event.AddParameterToList(p_name=> 'PARAMETER5',
268: p_value=> p_xml_message_id,
269: p_parameterlist=> l_parameter_list);
270: wf_event.AddParameterToList(p_name=> 'ECX_PARTY_ID',
271: p_value=> l_party_id,

Line 270: wf_event.AddParameterToList(p_name=> 'ECX_PARTY_ID',

266: p_parameterlist=> l_parameter_list);
267: wf_event.AddParameterToList(p_name=> 'PARAMETER5',
268: p_value=> p_xml_message_id,
269: p_parameterlist=> l_parameter_list);
270: wf_event.AddParameterToList(p_name=> 'ECX_PARTY_ID',
271: p_value=> l_party_id,
272: p_parameterlist=> l_parameter_list);
273: wf_event.AddParameterToList(p_name=> 'ECX_PARTY_SITE_ID',
274: p_value=> l_party_site_id,

Line 273: wf_event.AddParameterToList(p_name=> 'ECX_PARTY_SITE_ID',

269: p_parameterlist=> l_parameter_list);
270: wf_event.AddParameterToList(p_name=> 'ECX_PARTY_ID',
271: p_value=> l_party_id,
272: p_parameterlist=> l_parameter_list);
273: wf_event.AddParameterToList(p_name=> 'ECX_PARTY_SITE_ID',
274: p_value=> l_party_site_id,
275: p_parameterlist=> l_parameter_list);
276: IF l_debug_level > 0 THEN
277: oe_debug_pub.add( 'BEFORE RAISE EVENT ORACLE.APPS.ONT.OI.PO_ACK.CREATE' ) ;

Line 279: wf_event.raise( p_event_name => l_event_name,

275: p_parameterlist=> l_parameter_list);
276: IF l_debug_level > 0 THEN
277: oe_debug_pub.add( 'BEFORE RAISE EVENT ORACLE.APPS.ONT.OI.PO_ACK.CREATE' ) ;
278: END IF;
279: wf_event.raise( p_event_name => l_event_name,
280: p_event_key => l_itemkey,
281: p_parameters => l_parameter_list);
282: --p_send_date => l_send_date);
283:

Line 396: wf_event.AddParameterToList(p_name=> 'ORG_ID',

392: IF l_debug_level > 0 THEN
393: oe_debug_pub.add( 'AFTER GET_ORIG_SYS_DOCUMENT_REF => ' || L_ORIG_SYS_DOCUMENT_REF ) ;
394: END IF;
395:
396: wf_event.AddParameterToList(p_name=> 'ORG_ID',
397: p_value=> p_org_id,
398: p_parameterlist=> l_parameter_list);
399:
400: IF l_debug_level > 0 THEN

Line 404: wf_event.AddParameterToList(p_name=> 'HEADER_ID',

400: IF l_debug_level > 0 THEN
401: oe_debug_pub.add( 'AFTER ADDING ORG_ID PARAMETER..ORG_ID IS => ' || L_ORG_ID ) ;
402: END IF;
403:
404: wf_event.AddParameterToList(p_name=> 'HEADER_ID',
405: p_value=> p_header_id,
406: p_parameterlist=> l_parameter_list);
407: IF l_debug_level > 0 THEN
408: oe_debug_pub.add( 'AFTER ADDING HEADER_ID PARAMETER..HEADER_ID IS => ' || P_HEADER_ID ) ;

Line 410: wf_event.AddParameterToList(p_name=> 'ORIG_SYS_DOCUMENT_REF',

406: p_parameterlist=> l_parameter_list);
407: IF l_debug_level > 0 THEN
408: oe_debug_pub.add( 'AFTER ADDING HEADER_ID PARAMETER..HEADER_ID IS => ' || P_HEADER_ID ) ;
409: END IF;
410: wf_event.AddParameterToList(p_name=> 'ORIG_SYS_DOCUMENT_REF',
411: p_value=> l_orig_sys_document_ref,
412: p_parameterlist=> l_parameter_list);
413:
414: wf_event.AddParameterToList(p_name=> 'LINE_ID',

Line 414: wf_event.AddParameterToList(p_name=> 'LINE_ID',

410: wf_event.AddParameterToList(p_name=> 'ORIG_SYS_DOCUMENT_REF',
411: p_value=> l_orig_sys_document_ref,
412: p_parameterlist=> l_parameter_list);
413:
414: wf_event.AddParameterToList(p_name=> 'LINE_ID',
415: p_value=> p_line_id,
416: p_parameterlist=> l_parameter_list);
417: IF l_debug_level > 0 THEN
418: oe_debug_pub.add( 'AFTER ADDING LINE_ID PARAMETER..LINE_ID IS => ' || P_LINE_ID ) ;

Line 420: wf_event.AddParameterToList(p_name=> 'CUSTOMER_ID',

416: p_parameterlist=> l_parameter_list);
417: IF l_debug_level > 0 THEN
418: oe_debug_pub.add( 'AFTER ADDING LINE_ID PARAMETER..LINE_ID IS => ' || P_LINE_ID ) ;
419: END IF;
420: wf_event.AddParameterToList(p_name=> 'CUSTOMER_ID',
421: p_value=> p_customer_id,
422: p_parameterlist=> l_parameter_list);
423:
424: wf_event.AddParameterToList(p_name=> 'PARAMETER4',

Line 424: wf_event.AddParameterToList(p_name=> 'PARAMETER4',

420: wf_event.AddParameterToList(p_name=> 'CUSTOMER_ID',
421: p_value=> p_customer_id,
422: p_parameterlist=> l_parameter_list);
423:
424: wf_event.AddParameterToList(p_name=> 'PARAMETER4',
425: p_value=> p_customer_id,
426: p_parameterlist=> l_parameter_list);
427:
428: wf_event.AddParameterToList(p_name=> 'PARAMETER7',

Line 428: wf_event.AddParameterToList(p_name=> 'PARAMETER7',

424: wf_event.AddParameterToList(p_name=> 'PARAMETER4',
425: p_value=> p_customer_id,
426: p_parameterlist=> l_parameter_list);
427:
428: wf_event.AddParameterToList(p_name=> 'PARAMETER7',
429: p_value=> p_change_sequence,
430: p_parameterlist=> l_parameter_list);
431:
432:

Line 433: wf_event.AddParameterToList(p_name=> 'ECX_PARTY_ID',

429: p_value=> p_change_sequence,
430: p_parameterlist=> l_parameter_list);
431:
432:
433: wf_event.AddParameterToList(p_name=> 'ECX_PARTY_ID',
434: p_value=> p_party_id,
435: p_parameterlist=> l_parameter_list);
436:
437: wf_event.AddParameterToList(p_name=> 'ECX_PARTY_SITE_ID',

Line 437: wf_event.AddParameterToList(p_name=> 'ECX_PARTY_SITE_ID',

433: wf_event.AddParameterToList(p_name=> 'ECX_PARTY_ID',
434: p_value=> p_party_id,
435: p_parameterlist=> l_parameter_list);
436:
437: wf_event.AddParameterToList(p_name=> 'ECX_PARTY_SITE_ID',
438: p_value=> p_party_site_id,
439: p_parameterlist=> l_parameter_list);
440:
441: wf_event.AddParameterToList(p_name=> 'ECX_DOCUMENT_ID',

Line 441: wf_event.AddParameterToList(p_name=> 'ECX_DOCUMENT_ID',

437: wf_event.AddParameterToList(p_name=> 'ECX_PARTY_SITE_ID',
438: p_value=> p_party_site_id,
439: p_parameterlist=> l_parameter_list);
440:
441: wf_event.AddParameterToList(p_name=> 'ECX_DOCUMENT_ID',
442: p_value=> p_itemkey,
443: p_parameterlist=> l_parameter_list);
444:
445: If l_transaction_type Is NULL Then

Line 449: wf_event.AddParameterToList(p_name=> 'PARAMETER3',

445: If l_transaction_type Is NULL Then
446: l_transaction_type := G_TRANSACTION_SSO; -- we default to SSO, but it can also be passed in as CSO
447: End If;
448:
449: wf_event.AddParameterToList(p_name=> 'PARAMETER3',
450: p_value=> l_transaction_type,
451: p_parameterlist=> l_parameter_list);
452:
453: IF l_debug_level > 0 THEN

Line 462: wf_event.AddParameterToList(p_name=> 'START_FROM_FLOW',

458: l_itemtype := OE_ORDER_IMPORT_WF.G_WFI_PROC;
459: Else
460: l_itemtype := p_itemtype;
461: End If;
462: wf_event.AddParameterToList(p_name=> 'START_FROM_FLOW',
463: p_value=> l_itemtype,
464: p_parameterlist=> l_parameter_list);
465:
466: IF l_debug_level > 0 THEN

Line 472: wf_event.AddParameterToList(p_name=> 'REQ_ID',

468: END IF;
469:
470: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' THEN
471: IF l_itemtype = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM THEN
472: wf_event.AddParameterToList(p_name=> 'REQ_ID',
473: p_value=> p_request_id,
474: p_parameterlist=> l_parameter_list);
475: END IF;
476: END IF;

Line 490: wf_event.raise( p_event_name => 'oracle.apps.ont.oi.show_so.create',

486:
487: IF l_debug_level > 0 THEN
488: oe_debug_pub.add( 'BEFORE RAISE EVENT ORACLE.APPS.ONT.OI.SHOW_SO.CREATE' ) ;
489: END IF;
490: wf_event.raise( p_event_name => 'oracle.apps.ont.oi.show_so.create',
491: p_event_key => l_itemkey,
492: p_parameters => l_parameter_list);
493:
494: l_parameter_list.DELETE;

Line 3281: wf_event.AddParameterToList(p_name=> 'ORDER_SOURCE_ID',

3277: END IF;
3278: END IF;
3279:
3280: -- order source
3281: wf_event.AddParameterToList(p_name=> 'ORDER_SOURCE_ID',
3282: p_value=> p_order_source_id,
3283: p_parameterlist=> l_parameter_list);
3284:
3285: -- item_type, item_key under which the inbound/outbound XML is being processed

Line 3286: wf_event.AddParameterToList(p_name=> 'WF_ITEM_TYPE',

3282: p_value=> p_order_source_id,
3283: p_parameterlist=> l_parameter_list);
3284:
3285: -- item_type, item_key under which the inbound/outbound XML is being processed
3286: wf_event.AddParameterToList(p_name=> 'WF_ITEM_TYPE',
3287: p_value=> p_itemtype,
3288: p_parameterlist=> l_parameter_list);
3289: wf_event.AddParameterToList(p_name=> 'WF_ITEM_KEY',
3290: p_value=> p_itemkey,

Line 3289: wf_event.AddParameterToList(p_name=> 'WF_ITEM_KEY',

3285: -- item_type, item_key under which the inbound/outbound XML is being processed
3286: wf_event.AddParameterToList(p_name=> 'WF_ITEM_TYPE',
3287: p_value=> p_itemtype,
3288: p_parameterlist=> l_parameter_list);
3289: wf_event.AddParameterToList(p_name=> 'WF_ITEM_KEY',
3290: p_value=> p_itemkey,
3291: p_parameterlist=> l_parameter_list);
3292:
3293: wf_event.AddParameterToList(p_name=> 'SOLD_TO_ORG_ID',

Line 3293: wf_event.AddParameterToList(p_name=> 'SOLD_TO_ORG_ID',

3289: wf_event.AddParameterToList(p_name=> 'WF_ITEM_KEY',
3290: p_value=> p_itemkey,
3291: p_parameterlist=> l_parameter_list);
3292:
3293: wf_event.AddParameterToList(p_name=> 'SOLD_TO_ORG_ID',
3294: p_value=> p_sold_to_org_id,
3295: p_parameterlist=> l_parameter_list);
3296:
3297: wf_event.AddParameterToList(p_name=> 'PROCESSING_STAGE',

Line 3297: wf_event.AddParameterToList(p_name=> 'PROCESSING_STAGE',

3293: wf_event.AddParameterToList(p_name=> 'SOLD_TO_ORG_ID',
3294: p_value=> p_sold_to_org_id,
3295: p_parameterlist=> l_parameter_list);
3296:
3297: wf_event.AddParameterToList(p_name=> 'PROCESSING_STAGE',
3298: p_value=> l_processing_stage,
3299: p_parameterlist=> l_parameter_list);
3300:
3301: wf_event.AddParameterToList(p_name=> 'CONC_REQUEST_ID',

Line 3301: wf_event.AddParameterToList(p_name=> 'CONC_REQUEST_ID',

3297: wf_event.AddParameterToList(p_name=> 'PROCESSING_STAGE',
3298: p_value=> l_processing_stage,
3299: p_parameterlist=> l_parameter_list);
3300:
3301: wf_event.AddParameterToList(p_name=> 'CONC_REQUEST_ID',
3302: p_value=> l_conc_request_id,
3303: p_parameterlist=> l_parameter_list);
3304:
3305: IF p_order_source_id <> G_XML_ORDER_SOURCE_ID THEN

Line 3308: wf_event.AddParameterToList(p_name=> 'RESPONSE_FLAG',

3304:
3305: IF p_order_source_id <> G_XML_ORDER_SOURCE_ID THEN
3306: l_response_flag := NULL;
3307: END IF;
3308: wf_event.AddParameterToList(p_name=> 'RESPONSE_FLAG',
3309: p_value=> l_response_flag,
3310: p_parameterlist=> l_parameter_list);
3311:
3312: wf_event.AddParameterToList(p_name=> 'HEADER_ID',

Line 3312: wf_event.AddParameterToList(p_name=> 'HEADER_ID',

3308: wf_event.AddParameterToList(p_name=> 'RESPONSE_FLAG',
3309: p_value=> l_response_flag,
3310: p_parameterlist=> l_parameter_list);
3311:
3312: wf_event.AddParameterToList(p_name=> 'HEADER_ID',
3313: p_value=> l_header_id,
3314: p_parameterlist=> l_parameter_list);
3315:
3316: END IF;

Line 3336: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_CONTROL_NUMBER',

3332: , p_itemkey
3333: , 'PARAMETER5'
3334: );*/
3335:
3336: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_CONTROL_NUMBER',
3337: p_value=> l_xmlg_icn,
3338: p_parameterlist=> l_parameter_list);
3339:
3340:

Line 3354: wf_event.AddParameterToList(p_name=> 'XMLG_MESSAGE_ID',

3350: , p_itemkey
3351: , 'ECX_MSGID_ATTR'
3352: , TRUE
3353: );*/
3354: wf_event.AddParameterToList(p_name=> 'XMLG_MESSAGE_ID',
3355: p_value=> p_xmlg_msgid,
3356: p_parameterlist=> l_parameter_list);
3357:
3358: -- If the xml message id exists, then the document was successfully

Line 3365: wf_event.AddParameterToList(p_name=> 'DOCUMENT_DIRECTION',

3361: -- of these we populate the XMLG_INTERNAL_TXN_TYPE/SUBTYPE always (as it
3362: -- is part of the key for the history table),
3363: -- the other parameters are added in this code block
3364: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
3365: wf_event.AddParameterToList(p_name=> 'DOCUMENT_DIRECTION',
3366: p_value=> p_document_direction,
3367: p_parameterlist=> l_parameter_list);
3368:
3369: wf_event.AddParameterToList(p_name=> 'XMLG_DOCUMENT_ID',

Line 3369: wf_event.AddParameterToList(p_name=> 'XMLG_DOCUMENT_ID',

3365: wf_event.AddParameterToList(p_name=> 'DOCUMENT_DIRECTION',
3366: p_value=> p_document_direction,
3367: p_parameterlist=> l_parameter_list);
3368:
3369: wf_event.AddParameterToList(p_name=> 'XMLG_DOCUMENT_ID',
3370: p_value=> p_xmlg_document_id,
3371: p_parameterlist=> l_parameter_list);
3372:
3373: wf_event.AddParameterToList(p_name=> 'TRADING_PARTNER_TYPE',

Line 3373: wf_event.AddParameterToList(p_name=> 'TRADING_PARTNER_TYPE',

3369: wf_event.AddParameterToList(p_name=> 'XMLG_DOCUMENT_ID',
3370: p_value=> p_xmlg_document_id,
3371: p_parameterlist=> l_parameter_list);
3372:
3373: wf_event.AddParameterToList(p_name=> 'TRADING_PARTNER_TYPE',
3374: p_value=> p_xmlg_partner_type,
3375: p_parameterlist=> l_parameter_list);
3376:
3377: wf_event.AddParameterToList(p_name=> 'TRADING_PARTNER_ID',

Line 3377: wf_event.AddParameterToList(p_name=> 'TRADING_PARTNER_ID',

3373: wf_event.AddParameterToList(p_name=> 'TRADING_PARTNER_TYPE',
3374: p_value=> p_xmlg_partner_type,
3375: p_parameterlist=> l_parameter_list);
3376:
3377: wf_event.AddParameterToList(p_name=> 'TRADING_PARTNER_ID',
3378: p_value=> p_xmlg_party_id,
3379: p_parameterlist=> l_parameter_list);
3380:
3381: wf_event.AddParameterToList(p_name=> 'TRADING_PARTNER_SITE',

Line 3381: wf_event.AddParameterToList(p_name=> 'TRADING_PARTNER_SITE',

3377: wf_event.AddParameterToList(p_name=> 'TRADING_PARTNER_ID',
3378: p_value=> p_xmlg_party_id,
3379: p_parameterlist=> l_parameter_list);
3380:
3381: wf_event.AddParameterToList(p_name=> 'TRADING_PARTNER_SITE',
3382: p_value=> p_xmlg_party_site_id,
3383: p_parameterlist=> l_parameter_list);
3384:
3385: -- start bug 4179657

Line 3401: wf_event.AddParameterToList(p_name=> 'PARTNER_DOCUMENT_NO',

3397: -- START CLN OPTIONAL PARAMS
3398: -----------------------------------------------------------
3399: --adding partner document number
3400:
3401: wf_event.AddParameterToList(p_name=> 'PARTNER_DOCUMENT_NO',
3402: p_value=> p_partner_document_num,
3403: p_parameterlist=> l_parameter_list);
3404: --adding document number
3405:

Line 3406: wf_event.AddParameterToList(p_name=> 'DOCUMENT_NO',

3402: p_value=> p_partner_document_num,
3403: p_parameterlist=> l_parameter_list);
3404: --adding document number
3405:
3406: wf_event.AddParameterToList(p_name=> 'DOCUMENT_NO',
3407: p_value=> l_document_num,
3408: p_parameterlist=> l_parameter_list);
3409:
3410: --adding message text

Line 3412: wf_event.AddParameterToList(p_name=> 'MESSAGE_TEXT',

3408: p_parameterlist=> l_parameter_list);
3409:
3410: --adding message text
3411:
3412: wf_event.AddParameterToList(p_name=> 'MESSAGE_TEXT',
3413: p_value=> l_message_text,
3414: p_parameterlist=> l_parameter_list);
3415:
3416: IF OE_Code_Control.Code_Release_Level >= '110510' THEN

Line 3425: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_TXN_TYPE',

3421: l_order_processed_flag := 'N';
3422: -- end bug 4179657
3423: END IF;
3424:
3425: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_TXN_TYPE',
3426: p_value=> l_transaction_type,
3427: p_parameterlist=> l_parameter_list);
3428:
3429: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_TXN_SUBTYPE',

Line 3429: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_TXN_SUBTYPE',

3425: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_TXN_TYPE',
3426: p_value=> l_transaction_type,
3427: p_parameterlist=> l_parameter_list);
3428:
3429: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_TXN_SUBTYPE',
3430: p_value=> l_transaction_subtype,
3431: p_parameterlist=> l_parameter_list);
3432:
3433: -- these changes for CLN, per bug 3103495

Line 3438: wf_event.AddParameterToList(p_name=> 'ONT_DOC_STATUS',

3434:
3435: -- We will use the OM_STATUS parameter to report ACTIVE SUCCESS ERROR statuses
3436: -- Since CLN does not support ACTIVE, we will change that value to SUCCESS for
3437: -- CLN's DOC_STATUS
3438: wf_event.AddParameterToList(p_name=> 'ONT_DOC_STATUS',
3439: p_value=> l_doc_status,
3440: p_parameterlist=> l_parameter_list);
3441:
3442:

Line 3447: wf_event.AddParameterToList(p_name=> 'DOCUMENT_STATUS',

3443: IF l_doc_status = 'ACTIVE' THEN
3444: l_doc_status := 'SUCCESS';
3445: END IF;
3446:
3447: wf_event.AddParameterToList(p_name=> 'DOCUMENT_STATUS',
3448: p_value=> l_doc_status,
3449: p_parameterlist=> l_parameter_list);
3450:
3451: -- We also need to publish a subscriber list

Line 3458: wf_event.AddParameterToList(p_name=> 'SUBSCRIBER_LIST',

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;
3458: wf_event.AddParameterToList(p_name=> 'SUBSCRIBER_LIST',
3459: p_value=> l_subscriber_list,
3460: p_parameterlist=> l_parameter_list);
3461:
3462: wf_event.AddParameterToList(p_name=> 'DOCUMENT_REVISION_NO',

Line 3462: wf_event.AddParameterToList(p_name=> 'DOCUMENT_REVISION_NO',

3458: wf_event.AddParameterToList(p_name=> 'SUBSCRIBER_LIST',
3459: p_value=> l_subscriber_list,
3460: p_parameterlist=> l_parameter_list);
3461:
3462: wf_event.AddParameterToList(p_name=> 'DOCUMENT_REVISION_NO',
3463: p_value=> p_change_sequence,
3464: p_parameterlist=> l_parameter_list);
3465:
3466: wf_event.AddParameterToList(p_name=> 'ORG_ID',

Line 3466: wf_event.AddParameterToList(p_name=> 'ORG_ID',

3462: wf_event.AddParameterToList(p_name=> 'DOCUMENT_REVISION_NO',
3463: p_value=> p_change_sequence,
3464: p_parameterlist=> l_parameter_list);
3465:
3466: wf_event.AddParameterToList(p_name=> 'ORG_ID',
3467: p_value=> l_org_id,
3468: p_parameterlist=> l_parameter_list);
3469:
3470:

Line 3471: wf_event.AddParameterToList(p_name=> 'ORDER_TYPE_ID',

3467: p_value=> l_org_id,
3468: p_parameterlist=> l_parameter_list);
3469:
3470:
3471: wf_event.AddParameterToList(p_name=> 'ORDER_TYPE_ID',
3472: p_value=> l_order_type_id,
3473: p_parameterlist=> l_parameter_list);
3474:
3475: If l_subscriber_list = 'DEFAULT' THEN

Line 3476: wf_event.AddParameterToList(p_name=> 'LINE_IDS',

3472: p_value=> l_order_type_id,
3473: p_parameterlist=> l_parameter_list);
3474:
3475: If l_subscriber_list = 'DEFAULT' THEN
3476: wf_event.AddParameterToList(p_name=> 'LINE_IDS',
3477: p_value=> p_line_ids,
3478: p_parameterlist=> l_parameter_list);
3479: Else
3480: -- begin bug 4179657

Line 3481: wf_event.AddParameterToList(p_name=> 'ORDER_PROCESSED_FLAG',

3477: p_value=> p_line_ids,
3478: p_parameterlist=> l_parameter_list);
3479: Else
3480: -- begin bug 4179657
3481: wf_event.AddParameterToList(p_name=> 'ORDER_PROCESSED_FLAG',
3482: p_value=> l_order_processed_flag,
3483: p_parameterlist=> l_parameter_list);
3484: -- end bug 4179657
3485: End If;

Line 3515: wf_event.raise( p_event_name => 'oracle.apps.ont.oi.xml_int.status',

3511: Return; -- thus we guarantee that old behaviour is preserved
3512: END IF;
3513: END IF;
3514:
3515: wf_event.raise( p_event_name => 'oracle.apps.ont.oi.xml_int.status',
3516: p_event_key => l_eventkey,
3517: p_parameters => l_parameter_list);
3518:
3519:

Line 4010: wf_event.AddParameterToList(p_name=> 'ORIG_SYS_DOCUMENT_REF',

4006:
4007: l_user_key := p_orig_sys_document_ref || ',' || to_char(p_sold_to_org_id) || ',' || p_change_sequence || ',' || p_transaction_type;
4008:
4009: If p_confirmation_flag = '2' Then
4010: wf_event.AddParameterToList(p_name=> 'ORIG_SYS_DOCUMENT_REF',
4011: p_value=> p_orig_sys_document_ref,
4012: p_parameterlist=> l_parameter_list);
4013: wf_event.AddParameterToList(p_name=> 'PARAMETER4',
4014: p_value=> p_sold_to_org_id,

Line 4013: wf_event.AddParameterToList(p_name=> 'PARAMETER4',

4009: If p_confirmation_flag = '2' Then
4010: wf_event.AddParameterToList(p_name=> 'ORIG_SYS_DOCUMENT_REF',
4011: p_value=> p_orig_sys_document_ref,
4012: p_parameterlist=> l_parameter_list);
4013: wf_event.AddParameterToList(p_name=> 'PARAMETER4',
4014: p_value=> p_sold_to_org_id,
4015: p_parameterlist=> l_parameter_list);
4016: wf_event.AddParameterToList(p_name=> 'PARAMETER5',
4017: p_value=> p_icn,

Line 4016: wf_event.AddParameterToList(p_name=> 'PARAMETER5',

4012: p_parameterlist=> l_parameter_list);
4013: wf_event.AddParameterToList(p_name=> 'PARAMETER4',
4014: p_value=> p_sold_to_org_id,
4015: p_parameterlist=> l_parameter_list);
4016: wf_event.AddParameterToList(p_name=> 'PARAMETER5',
4017: p_value=> p_icn,
4018: p_parameterlist=> l_parameter_list);
4019: wf_event.AddParameterToList(p_name=> 'PARAMETER6',
4020: p_value=> p_cbod_message_text,

Line 4019: wf_event.AddParameterToList(p_name=> 'PARAMETER6',

4015: p_parameterlist=> l_parameter_list);
4016: wf_event.AddParameterToList(p_name=> 'PARAMETER5',
4017: p_value=> p_icn,
4018: p_parameterlist=> l_parameter_list);
4019: wf_event.AddParameterToList(p_name=> 'PARAMETER6',
4020: p_value=> p_cbod_message_text,
4021: p_parameterlist=> l_parameter_list);
4022: wf_event.AddParameterToList(p_name=> 'USER_KEY',
4023: p_value=> l_user_key,

Line 4022: wf_event.AddParameterToList(p_name=> 'USER_KEY',

4018: p_parameterlist=> l_parameter_list);
4019: wf_event.AddParameterToList(p_name=> 'PARAMETER6',
4020: p_value=> p_cbod_message_text,
4021: p_parameterlist=> l_parameter_list);
4022: wf_event.AddParameterToList(p_name=> 'USER_KEY',
4023: p_value=> l_user_key,
4024: p_parameterlist=> l_parameter_list);
4025: wf_event.AddParameterToList(p_name=> 'ORG_ID',
4026: p_value=> p_org_id,

Line 4025: wf_event.AddParameterToList(p_name=> 'ORG_ID',

4021: p_parameterlist=> l_parameter_list);
4022: wf_event.AddParameterToList(p_name=> 'USER_KEY',
4023: p_value=> l_user_key,
4024: p_parameterlist=> l_parameter_list);
4025: wf_event.AddParameterToList(p_name=> 'ORG_ID',
4026: p_value=> p_org_id,
4027: p_parameterlist=> l_parameter_list);
4028: wf_event.AddParameterToList(p_name=> 'PARAMETER7',
4029: p_value=> p_change_sequence,

Line 4028: wf_event.AddParameterToList(p_name=> 'PARAMETER7',

4024: p_parameterlist=> l_parameter_list);
4025: wf_event.AddParameterToList(p_name=> 'ORG_ID',
4026: p_value=> p_org_id,
4027: p_parameterlist=> l_parameter_list);
4028: wf_event.AddParameterToList(p_name=> 'PARAMETER7',
4029: p_value=> p_change_sequence,
4030: p_parameterlist=> l_parameter_list);
4031:
4032: SELECT OE_XML_MESSAGE_SEQ_S.nextval

Line 4036: wf_event.raise( p_event_name => 'oracle.apps.ont.oi.cbod_out.confirm',

4032: SELECT OE_XML_MESSAGE_SEQ_S.nextval
4033: INTO l_eventkey
4034: FROM dual;
4035:
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;