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 235: wf_event.AddParameterToList(p_name=> 'ORIG_SYS_DOCUMENT_REF',

231: l_user_key := p_orig_sys_document_ref || ',' || to_char(p_sold_to_org_id) || ',' || p_transaction_type;
232: End If;
233:
234:
235: wf_event.AddParameterToList(p_name=> 'ORIG_SYS_DOCUMENT_REF',
236: p_value=> p_orig_sys_document_ref,
237: p_parameterlist=> l_parameter_list);
238: wf_event.AddParameterToList(p_name=> 'PARAMETER3',
239: p_value=> p_transaction_type,

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

234:
235: wf_event.AddParameterToList(p_name=> 'ORIG_SYS_DOCUMENT_REF',
236: p_value=> p_orig_sys_document_ref,
237: p_parameterlist=> l_parameter_list);
238: wf_event.AddParameterToList(p_name=> 'PARAMETER3',
239: p_value=> p_transaction_type,
240: p_parameterlist=> l_parameter_list);
241: wf_event.AddParameterToList(p_name=> 'PARAMETER4',
242: p_value=> p_sold_to_org_id,

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

237: p_parameterlist=> l_parameter_list);
238: wf_event.AddParameterToList(p_name=> 'PARAMETER3',
239: p_value=> p_transaction_type,
240: p_parameterlist=> l_parameter_list);
241: wf_event.AddParameterToList(p_name=> 'PARAMETER4',
242: p_value=> p_sold_to_org_id,
243: p_parameterlist=> l_parameter_list);
244: wf_event.AddParameterToList(p_name=> 'PARAMETER7',
245: p_value=> p_change_sequence,

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

240: p_parameterlist=> l_parameter_list);
241: wf_event.AddParameterToList(p_name=> 'PARAMETER4',
242: p_value=> p_sold_to_org_id,
243: p_parameterlist=> l_parameter_list);
244: wf_event.AddParameterToList(p_name=> 'PARAMETER7',
245: p_value=> p_change_sequence,
246: p_parameterlist=> l_parameter_list);
247: wf_event.AddParameterToList(p_name=> 'START_FROM_FLOW',
248: p_value=> l_start_from_flow,

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

243: p_parameterlist=> l_parameter_list);
244: wf_event.AddParameterToList(p_name=> 'PARAMETER7',
245: p_value=> p_change_sequence,
246: p_parameterlist=> l_parameter_list);
247: wf_event.AddParameterToList(p_name=> 'START_FROM_FLOW',
248: p_value=> l_start_from_flow,
249: p_parameterlist=> l_parameter_list);
250: wf_event.AddParameterToList(p_name=> 'REQ_ID',
251: p_value=> p_request_id,

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

246: p_parameterlist=> l_parameter_list);
247: wf_event.AddParameterToList(p_name=> 'START_FROM_FLOW',
248: p_value=> l_start_from_flow,
249: p_parameterlist=> l_parameter_list);
250: wf_event.AddParameterToList(p_name=> 'REQ_ID',
251: p_value=> p_request_id,
252: p_parameterlist=> l_parameter_list);
253: wf_event.AddParameterToList(p_name=> 'ORDER_IMPORTED',
254: p_value=> p_order_imported,

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

249: p_parameterlist=> l_parameter_list);
250: wf_event.AddParameterToList(p_name=> 'REQ_ID',
251: p_value=> p_request_id,
252: p_parameterlist=> l_parameter_list);
253: wf_event.AddParameterToList(p_name=> 'ORDER_IMPORTED',
254: p_value=> p_order_imported,
255: p_parameterlist=> l_parameter_list);
256: wf_event.AddParameterToList(p_name=> 'USER_KEY',
257: p_value=> l_user_key,

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

252: p_parameterlist=> l_parameter_list);
253: wf_event.AddParameterToList(p_name=> 'ORDER_IMPORTED',
254: p_value=> p_order_imported,
255: p_parameterlist=> l_parameter_list);
256: wf_event.AddParameterToList(p_name=> 'USER_KEY',
257: p_value=> l_user_key,
258: p_parameterlist=> l_parameter_list);
259: wf_event.AddParameterToList(p_name=> 'ORG_ID',
260: p_value=> p_org_id,

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

255: p_parameterlist=> l_parameter_list);
256: wf_event.AddParameterToList(p_name=> 'USER_KEY',
257: p_value=> l_user_key,
258: p_parameterlist=> l_parameter_list);
259: wf_event.AddParameterToList(p_name=> 'ORG_ID',
260: p_value=> p_org_id,
261: p_parameterlist=> l_parameter_list);
262: wf_event.AddParameterToList(p_name=> 'PARAMETER5',
263: p_value=> p_xml_message_id,

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

258: p_parameterlist=> l_parameter_list);
259: wf_event.AddParameterToList(p_name=> 'ORG_ID',
260: p_value=> p_org_id,
261: p_parameterlist=> l_parameter_list);
262: wf_event.AddParameterToList(p_name=> 'PARAMETER5',
263: p_value=> p_xml_message_id,
264: p_parameterlist=> l_parameter_list);
265: wf_event.AddParameterToList(p_name=> 'ECX_PARTY_ID',
266: p_value=> l_party_id,

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

261: p_parameterlist=> l_parameter_list);
262: wf_event.AddParameterToList(p_name=> 'PARAMETER5',
263: p_value=> p_xml_message_id,
264: p_parameterlist=> l_parameter_list);
265: wf_event.AddParameterToList(p_name=> 'ECX_PARTY_ID',
266: p_value=> l_party_id,
267: p_parameterlist=> l_parameter_list);
268: wf_event.AddParameterToList(p_name=> 'ECX_PARTY_SITE_ID',
269: p_value=> l_party_site_id,

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

264: p_parameterlist=> l_parameter_list);
265: wf_event.AddParameterToList(p_name=> 'ECX_PARTY_ID',
266: p_value=> l_party_id,
267: p_parameterlist=> l_parameter_list);
268: wf_event.AddParameterToList(p_name=> 'ECX_PARTY_SITE_ID',
269: p_value=> l_party_site_id,
270: p_parameterlist=> l_parameter_list);
271: IF l_debug_level > 0 THEN
272: oe_debug_pub.add( 'BEFORE RAISE EVENT ORACLE.APPS.ONT.OI.PO_ACK.CREATE' ) ;

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

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

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

387: IF l_debug_level > 0 THEN
388: oe_debug_pub.add( 'AFTER GET_ORIG_SYS_DOCUMENT_REF => ' || L_ORIG_SYS_DOCUMENT_REF ) ;
389: END IF;
390:
391: wf_event.AddParameterToList(p_name=> 'ORG_ID',
392: p_value=> p_org_id,
393: p_parameterlist=> l_parameter_list);
394:
395: IF l_debug_level > 0 THEN

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

395: IF l_debug_level > 0 THEN
396: oe_debug_pub.add( 'AFTER ADDING ORG_ID PARAMETER..ORG_ID IS => ' || L_ORG_ID ) ;
397: END IF;
398:
399: wf_event.AddParameterToList(p_name=> 'HEADER_ID',
400: p_value=> p_header_id,
401: p_parameterlist=> l_parameter_list);
402: IF l_debug_level > 0 THEN
403: oe_debug_pub.add( 'AFTER ADDING HEADER_ID PARAMETER..HEADER_ID IS => ' || P_HEADER_ID ) ;

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

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

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

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

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

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

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

415: wf_event.AddParameterToList(p_name=> 'CUSTOMER_ID',
416: p_value=> p_customer_id,
417: p_parameterlist=> l_parameter_list);
418:
419: wf_event.AddParameterToList(p_name=> 'PARAMETER4',
420: p_value=> p_customer_id,
421: p_parameterlist=> l_parameter_list);
422:
423: wf_event.AddParameterToList(p_name=> 'PARAMETER7',

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

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

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

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

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

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

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

432: wf_event.AddParameterToList(p_name=> 'ECX_PARTY_SITE_ID',
433: p_value=> p_party_site_id,
434: p_parameterlist=> l_parameter_list);
435:
436: wf_event.AddParameterToList(p_name=> 'ECX_DOCUMENT_ID',
437: p_value=> p_itemkey,
438: p_parameterlist=> l_parameter_list);
439:
440: If l_transaction_type Is NULL Then

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

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

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

453: l_itemtype := OE_ORDER_IMPORT_WF.G_WFI_PROC;
454: Else
455: l_itemtype := p_itemtype;
456: End If;
457: wf_event.AddParameterToList(p_name=> 'START_FROM_FLOW',
458: p_value=> l_itemtype,
459: p_parameterlist=> l_parameter_list);
460:
461: IF l_debug_level > 0 THEN

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

463: END IF;
464:
465: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' THEN
466: IF l_itemtype = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM THEN
467: wf_event.AddParameterToList(p_name=> 'REQ_ID',
468: p_value=> p_request_id,
469: p_parameterlist=> l_parameter_list);
470: END IF;
471: END IF;

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

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

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

3161: END IF;
3162: END IF;
3163:
3164: -- order source
3165: wf_event.AddParameterToList(p_name=> 'ORDER_SOURCE_ID',
3166: p_value=> p_order_source_id,
3167: p_parameterlist=> l_parameter_list);
3168:
3169: -- item_type, item_key under which the inbound/outbound XML is being processed

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

3166: p_value=> p_order_source_id,
3167: p_parameterlist=> l_parameter_list);
3168:
3169: -- item_type, item_key under which the inbound/outbound XML is being processed
3170: wf_event.AddParameterToList(p_name=> 'WF_ITEM_TYPE',
3171: p_value=> p_itemtype,
3172: p_parameterlist=> l_parameter_list);
3173: wf_event.AddParameterToList(p_name=> 'WF_ITEM_KEY',
3174: p_value=> p_itemkey,

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

3169: -- item_type, item_key under which the inbound/outbound XML is being processed
3170: wf_event.AddParameterToList(p_name=> 'WF_ITEM_TYPE',
3171: p_value=> p_itemtype,
3172: p_parameterlist=> l_parameter_list);
3173: wf_event.AddParameterToList(p_name=> 'WF_ITEM_KEY',
3174: p_value=> p_itemkey,
3175: p_parameterlist=> l_parameter_list);
3176:
3177: wf_event.AddParameterToList(p_name=> 'SOLD_TO_ORG_ID',

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

3173: wf_event.AddParameterToList(p_name=> 'WF_ITEM_KEY',
3174: p_value=> p_itemkey,
3175: p_parameterlist=> l_parameter_list);
3176:
3177: wf_event.AddParameterToList(p_name=> 'SOLD_TO_ORG_ID',
3178: p_value=> p_sold_to_org_id,
3179: p_parameterlist=> l_parameter_list);
3180:
3181: wf_event.AddParameterToList(p_name=> 'PROCESSING_STAGE',

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

3177: wf_event.AddParameterToList(p_name=> 'SOLD_TO_ORG_ID',
3178: p_value=> p_sold_to_org_id,
3179: p_parameterlist=> l_parameter_list);
3180:
3181: wf_event.AddParameterToList(p_name=> 'PROCESSING_STAGE',
3182: p_value=> l_processing_stage,
3183: p_parameterlist=> l_parameter_list);
3184:
3185: wf_event.AddParameterToList(p_name=> 'CONC_REQUEST_ID',

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

3181: wf_event.AddParameterToList(p_name=> 'PROCESSING_STAGE',
3182: p_value=> l_processing_stage,
3183: p_parameterlist=> l_parameter_list);
3184:
3185: wf_event.AddParameterToList(p_name=> 'CONC_REQUEST_ID',
3186: p_value=> l_conc_request_id,
3187: p_parameterlist=> l_parameter_list);
3188:
3189: IF p_order_source_id <> G_XML_ORDER_SOURCE_ID THEN

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

3188:
3189: IF p_order_source_id <> G_XML_ORDER_SOURCE_ID THEN
3190: l_response_flag := NULL;
3191: END IF;
3192: wf_event.AddParameterToList(p_name=> 'RESPONSE_FLAG',
3193: p_value=> l_response_flag,
3194: p_parameterlist=> l_parameter_list);
3195:
3196: wf_event.AddParameterToList(p_name=> 'HEADER_ID',

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

3192: wf_event.AddParameterToList(p_name=> 'RESPONSE_FLAG',
3193: p_value=> l_response_flag,
3194: p_parameterlist=> l_parameter_list);
3195:
3196: wf_event.AddParameterToList(p_name=> 'HEADER_ID',
3197: p_value=> l_header_id,
3198: p_parameterlist=> l_parameter_list);
3199:
3200: END IF;

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

3216: , p_itemkey
3217: , 'PARAMETER5'
3218: );*/
3219:
3220: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_CONTROL_NUMBER',
3221: p_value=> l_xmlg_icn,
3222: p_parameterlist=> l_parameter_list);
3223:
3224:

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

3234: , p_itemkey
3235: , 'ECX_MSGID_ATTR'
3236: , TRUE
3237: );*/
3238: wf_event.AddParameterToList(p_name=> 'XMLG_MESSAGE_ID',
3239: p_value=> p_xmlg_msgid,
3240: p_parameterlist=> l_parameter_list);
3241:
3242: -- If the xml message id exists, then the document was successfully

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

3245: -- of these we populate the XMLG_INTERNAL_TXN_TYPE/SUBTYPE always (as it
3246: -- is part of the key for the history table),
3247: -- the other parameters are added in this code block
3248: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
3249: wf_event.AddParameterToList(p_name=> 'DOCUMENT_DIRECTION',
3250: p_value=> p_document_direction,
3251: p_parameterlist=> l_parameter_list);
3252:
3253: wf_event.AddParameterToList(p_name=> 'XMLG_DOCUMENT_ID',

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

3249: wf_event.AddParameterToList(p_name=> 'DOCUMENT_DIRECTION',
3250: p_value=> p_document_direction,
3251: p_parameterlist=> l_parameter_list);
3252:
3253: wf_event.AddParameterToList(p_name=> 'XMLG_DOCUMENT_ID',
3254: p_value=> p_xmlg_document_id,
3255: p_parameterlist=> l_parameter_list);
3256:
3257: wf_event.AddParameterToList(p_name=> 'TRADING_PARTNER_TYPE',

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

3253: wf_event.AddParameterToList(p_name=> 'XMLG_DOCUMENT_ID',
3254: p_value=> p_xmlg_document_id,
3255: p_parameterlist=> l_parameter_list);
3256:
3257: wf_event.AddParameterToList(p_name=> 'TRADING_PARTNER_TYPE',
3258: p_value=> p_xmlg_partner_type,
3259: p_parameterlist=> l_parameter_list);
3260:
3261: wf_event.AddParameterToList(p_name=> 'TRADING_PARTNER_ID',

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

3257: wf_event.AddParameterToList(p_name=> 'TRADING_PARTNER_TYPE',
3258: p_value=> p_xmlg_partner_type,
3259: p_parameterlist=> l_parameter_list);
3260:
3261: wf_event.AddParameterToList(p_name=> 'TRADING_PARTNER_ID',
3262: p_value=> p_xmlg_party_id,
3263: p_parameterlist=> l_parameter_list);
3264:
3265: wf_event.AddParameterToList(p_name=> 'TRADING_PARTNER_SITE',

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

3261: wf_event.AddParameterToList(p_name=> 'TRADING_PARTNER_ID',
3262: p_value=> p_xmlg_party_id,
3263: p_parameterlist=> l_parameter_list);
3264:
3265: wf_event.AddParameterToList(p_name=> 'TRADING_PARTNER_SITE',
3266: p_value=> p_xmlg_party_site_id,
3267: p_parameterlist=> l_parameter_list);
3268:
3269: -- start bug 4179657

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

3281: -- START CLN OPTIONAL PARAMS
3282: -----------------------------------------------------------
3283: --adding partner document number
3284:
3285: wf_event.AddParameterToList(p_name=> 'PARTNER_DOCUMENT_NO',
3286: p_value=> p_partner_document_num,
3287: p_parameterlist=> l_parameter_list);
3288: --adding document number
3289:

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

3286: p_value=> p_partner_document_num,
3287: p_parameterlist=> l_parameter_list);
3288: --adding document number
3289:
3290: wf_event.AddParameterToList(p_name=> 'DOCUMENT_NO',
3291: p_value=> l_document_num,
3292: p_parameterlist=> l_parameter_list);
3293:
3294: --adding message text

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

3292: p_parameterlist=> l_parameter_list);
3293:
3294: --adding message text
3295:
3296: wf_event.AddParameterToList(p_name=> 'MESSAGE_TEXT',
3297: p_value=> l_message_text,
3298: p_parameterlist=> l_parameter_list);
3299:
3300: IF OE_Code_Control.Code_Release_Level >= '110510' THEN

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

3305: l_order_processed_flag := 'N';
3306: -- end bug 4179657
3307: END IF;
3308:
3309: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_TXN_TYPE',
3310: p_value=> l_transaction_type,
3311: p_parameterlist=> l_parameter_list);
3312:
3313: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_TXN_SUBTYPE',

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

3309: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_TXN_TYPE',
3310: p_value=> l_transaction_type,
3311: p_parameterlist=> l_parameter_list);
3312:
3313: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_TXN_SUBTYPE',
3314: p_value=> l_transaction_subtype,
3315: p_parameterlist=> l_parameter_list);
3316:
3317: -- these changes for CLN, per bug 3103495

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

3318:
3319: -- We will use the OM_STATUS parameter to report ACTIVE SUCCESS ERROR statuses
3320: -- Since CLN does not support ACTIVE, we will change that value to SUCCESS for
3321: -- CLN's DOC_STATUS
3322: wf_event.AddParameterToList(p_name=> 'ONT_DOC_STATUS',
3323: p_value=> l_doc_status,
3324: p_parameterlist=> l_parameter_list);
3325:
3326:

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

3327: IF l_doc_status = 'ACTIVE' THEN
3328: l_doc_status := 'SUCCESS';
3329: END IF;
3330:
3331: wf_event.AddParameterToList(p_name=> 'DOCUMENT_STATUS',
3332: p_value=> l_doc_status,
3333: p_parameterlist=> l_parameter_list);
3334:
3335: -- We also need to publish a subscriber list

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

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;
3342: wf_event.AddParameterToList(p_name=> 'SUBSCRIBER_LIST',
3343: p_value=> l_subscriber_list,
3344: p_parameterlist=> l_parameter_list);
3345:
3346: wf_event.AddParameterToList(p_name=> 'DOCUMENT_REVISION_NO',

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

3342: wf_event.AddParameterToList(p_name=> 'SUBSCRIBER_LIST',
3343: p_value=> l_subscriber_list,
3344: p_parameterlist=> l_parameter_list);
3345:
3346: wf_event.AddParameterToList(p_name=> 'DOCUMENT_REVISION_NO',
3347: p_value=> p_change_sequence,
3348: p_parameterlist=> l_parameter_list);
3349:
3350: wf_event.AddParameterToList(p_name=> 'ORG_ID',

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

3346: wf_event.AddParameterToList(p_name=> 'DOCUMENT_REVISION_NO',
3347: p_value=> p_change_sequence,
3348: p_parameterlist=> l_parameter_list);
3349:
3350: wf_event.AddParameterToList(p_name=> 'ORG_ID',
3351: p_value=> l_org_id,
3352: p_parameterlist=> l_parameter_list);
3353:
3354:

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

3351: p_value=> l_org_id,
3352: p_parameterlist=> l_parameter_list);
3353:
3354:
3355: wf_event.AddParameterToList(p_name=> 'ORDER_TYPE_ID',
3356: p_value=> l_order_type_id,
3357: p_parameterlist=> l_parameter_list);
3358:
3359: If l_subscriber_list = 'DEFAULT' THEN

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

3356: p_value=> l_order_type_id,
3357: p_parameterlist=> l_parameter_list);
3358:
3359: If l_subscriber_list = 'DEFAULT' THEN
3360: wf_event.AddParameterToList(p_name=> 'LINE_IDS',
3361: p_value=> p_line_ids,
3362: p_parameterlist=> l_parameter_list);
3363: Else
3364: -- begin bug 4179657

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

3361: p_value=> p_line_ids,
3362: p_parameterlist=> l_parameter_list);
3363: Else
3364: -- begin bug 4179657
3365: wf_event.AddParameterToList(p_name=> 'ORDER_PROCESSED_FLAG',
3366: p_value=> l_order_processed_flag,
3367: p_parameterlist=> l_parameter_list);
3368: -- end bug 4179657
3369: End If;

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

3395: Return; -- thus we guarantee that old behaviour is preserved
3396: END IF;
3397: END IF;
3398:
3399: wf_event.raise( p_event_name => 'oracle.apps.ont.oi.xml_int.status',
3400: p_event_key => l_eventkey,
3401: p_parameters => l_parameter_list);
3402:
3403:

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

3890:
3891: l_user_key := p_orig_sys_document_ref || ',' || to_char(p_sold_to_org_id) || ',' || p_change_sequence || ',' || p_transaction_type;
3892:
3893: If p_confirmation_flag = '2' Then
3894: wf_event.AddParameterToList(p_name=> 'ORIG_SYS_DOCUMENT_REF',
3895: p_value=> p_orig_sys_document_ref,
3896: p_parameterlist=> l_parameter_list);
3897: wf_event.AddParameterToList(p_name=> 'PARAMETER4',
3898: p_value=> p_sold_to_org_id,

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

3893: If p_confirmation_flag = '2' Then
3894: wf_event.AddParameterToList(p_name=> 'ORIG_SYS_DOCUMENT_REF',
3895: p_value=> p_orig_sys_document_ref,
3896: p_parameterlist=> l_parameter_list);
3897: wf_event.AddParameterToList(p_name=> 'PARAMETER4',
3898: p_value=> p_sold_to_org_id,
3899: p_parameterlist=> l_parameter_list);
3900: wf_event.AddParameterToList(p_name=> 'PARAMETER5',
3901: p_value=> p_icn,

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

3896: p_parameterlist=> l_parameter_list);
3897: wf_event.AddParameterToList(p_name=> 'PARAMETER4',
3898: p_value=> p_sold_to_org_id,
3899: p_parameterlist=> l_parameter_list);
3900: wf_event.AddParameterToList(p_name=> 'PARAMETER5',
3901: p_value=> p_icn,
3902: p_parameterlist=> l_parameter_list);
3903: wf_event.AddParameterToList(p_name=> 'PARAMETER6',
3904: p_value=> p_cbod_message_text,

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

3899: p_parameterlist=> l_parameter_list);
3900: wf_event.AddParameterToList(p_name=> 'PARAMETER5',
3901: p_value=> p_icn,
3902: p_parameterlist=> l_parameter_list);
3903: wf_event.AddParameterToList(p_name=> 'PARAMETER6',
3904: p_value=> p_cbod_message_text,
3905: p_parameterlist=> l_parameter_list);
3906: wf_event.AddParameterToList(p_name=> 'USER_KEY',
3907: p_value=> l_user_key,

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

3902: p_parameterlist=> l_parameter_list);
3903: wf_event.AddParameterToList(p_name=> 'PARAMETER6',
3904: p_value=> p_cbod_message_text,
3905: p_parameterlist=> l_parameter_list);
3906: wf_event.AddParameterToList(p_name=> 'USER_KEY',
3907: p_value=> l_user_key,
3908: p_parameterlist=> l_parameter_list);
3909: wf_event.AddParameterToList(p_name=> 'ORG_ID',
3910: p_value=> p_org_id,

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

3905: p_parameterlist=> l_parameter_list);
3906: wf_event.AddParameterToList(p_name=> 'USER_KEY',
3907: p_value=> l_user_key,
3908: p_parameterlist=> l_parameter_list);
3909: wf_event.AddParameterToList(p_name=> 'ORG_ID',
3910: p_value=> p_org_id,
3911: p_parameterlist=> l_parameter_list);
3912: wf_event.AddParameterToList(p_name=> 'PARAMETER7',
3913: p_value=> p_change_sequence,

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

3908: p_parameterlist=> l_parameter_list);
3909: wf_event.AddParameterToList(p_name=> 'ORG_ID',
3910: p_value=> p_org_id,
3911: p_parameterlist=> l_parameter_list);
3912: wf_event.AddParameterToList(p_name=> 'PARAMETER7',
3913: p_value=> p_change_sequence,
3914: p_parameterlist=> l_parameter_list);
3915:
3916: SELECT OE_XML_MESSAGE_SEQ_S.nextval

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

3916: SELECT OE_XML_MESSAGE_SEQ_S.nextval
3917: INTO l_eventkey
3918: FROM dual;
3919:
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;