8465:
8466:
8467: IF l_party_id IS NOT NULL AND l_party_site_id IS NOT NULL THEN
8468:
8469: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_ID',
8470: p_value => l_party_id,
8471: p_parameterlist => l_msg_parameter_list);
8472: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_SITE_ID',
8473: p_value => l_party_site_id,
8468:
8469: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_ID',
8470: p_value => l_party_id,
8471: p_parameterlist => l_msg_parameter_list);
8472: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_SITE_ID',
8473: p_value => l_party_site_id,
8474: p_parameterlist => l_msg_parameter_list);
8475: WF_EVENT.AddParameterToList (p_name => 'DOCUMENT_ID',
8476: p_value => p_batch_id,
8471: p_parameterlist => l_msg_parameter_list);
8472: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_SITE_ID',
8473: p_value => l_party_site_id,
8474: p_parameterlist => l_msg_parameter_list);
8475: WF_EVENT.AddParameterToList (p_name => 'DOCUMENT_ID',
8476: p_value => p_batch_id,
8477: p_parameterlist => l_msg_parameter_list);
8478: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_TYPE',
8479: p_value => 'OZF',
8474: p_parameterlist => l_msg_parameter_list);
8475: WF_EVENT.AddParameterToList (p_name => 'DOCUMENT_ID',
8476: p_value => p_batch_id,
8477: p_parameterlist => l_msg_parameter_list);
8478: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_TYPE',
8479: p_value => 'OZF',
8480: p_parameterlist => l_msg_parameter_list);
8481: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_SUBTYPE',
8482: p_value => 'POSO',
8477: p_parameterlist => l_msg_parameter_list);
8478: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_TYPE',
8479: p_value => 'OZF',
8480: p_parameterlist => l_msg_parameter_list);
8481: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_SUBTYPE',
8482: p_value => 'POSO',
8483: p_parameterlist => l_msg_parameter_list);
8484: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER1',
8485: p_value => null,
8480: p_parameterlist => l_msg_parameter_list);
8481: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_SUBTYPE',
8482: p_value => 'POSO',
8483: p_parameterlist => l_msg_parameter_list);
8484: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER1',
8485: p_value => null,
8486: p_parameterlist => l_msg_parameter_list);
8487: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER2',
8488: p_value => null,
8483: p_parameterlist => l_msg_parameter_list);
8484: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER1',
8485: p_value => null,
8486: p_parameterlist => l_msg_parameter_list);
8487: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER2',
8488: p_value => null,
8489: p_parameterlist => l_msg_parameter_list);
8490: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER3',
8491: p_value => null,
8486: p_parameterlist => l_msg_parameter_list);
8487: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER2',
8488: p_value => null,
8489: p_parameterlist => l_msg_parameter_list);
8490: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER3',
8491: p_value => null,
8492: p_parameterlist => l_msg_parameter_list);
8493: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER4',
8494: p_value => null,
8489: p_parameterlist => l_msg_parameter_list);
8490: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER3',
8491: p_value => null,
8492: p_parameterlist => l_msg_parameter_list);
8493: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER4',
8494: p_value => null,
8495: p_parameterlist => l_msg_parameter_list);
8496: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER5',
8497: p_value => null,
8492: p_parameterlist => l_msg_parameter_list);
8493: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER4',
8494: p_value => null,
8495: p_parameterlist => l_msg_parameter_list);
8496: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER5',
8497: p_value => null,
8498: p_parameterlist => l_msg_parameter_list);
8499:
8500: WF_EVENT.AddParameterToList(p_name=>'ECX_DEBUG_LEVEL',
8496: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER5',
8497: p_value => null,
8498: p_parameterlist => l_msg_parameter_list);
8499:
8500: WF_EVENT.AddParameterToList(p_name=>'ECX_DEBUG_LEVEL',
8501: p_value=>'3',
8502: p_parameterlist=>l_msg_parameter_list);
8503:
8504: l_event_key := p_batch_id||'-POSO-'||to_char(sysdate,'MM/DD/YYYY HH:MI:SS');
8506: END IF;
8507: END IF;
8508: IF p_event_name = g_xml_data_process_event THEN
8509:
8510: WF_EVENT.AddParameterToList( p_name => 'OZF_RESALE_BATCH_ID',
8511: p_value => p_batch_id,
8512: p_parameterlist => l_msg_parameter_list);
8513:
8514: WF_EVENT.AddParameterToList( p_name => 'OZF_RESALE_BATCH_CALLER',
8510: WF_EVENT.AddParameterToList( p_name => 'OZF_RESALE_BATCH_ID',
8511: p_value => p_batch_id,
8512: p_parameterlist => l_msg_parameter_list);
8513:
8514: WF_EVENT.AddParameterToList( p_name => 'OZF_RESALE_BATCH_CALLER',
8515: p_value => 'XML',
8516: p_parameterlist => l_msg_parameter_list);
8517: IF p_event_name = g_xml_data_process_event THEN
8518: l_event_key := p_batch_id ||'-'||to_char(sysdate,'MM/DD/YYYY HH:MI:SS');
8525: --nepanda : Fix for Bug 12716192(13819601)
8526: OPEN get_batch_org_id ( p_batch_id );
8527: FETCH get_batch_org_id INTO l_org_id;
8528: CLOSE get_batch_org_id;
8529: WF_EVENT.AddParameterToList( p_name => 'OZF_RESALE_BATCH_ID',
8530: p_value => p_batch_id,
8531: p_parameterlist => l_msg_parameter_list);
8532:
8533: WF_EVENT.AddParameterToList( p_name => 'OZF_RESALE_BATCH_CALLER',
8529: WF_EVENT.AddParameterToList( p_name => 'OZF_RESALE_BATCH_ID',
8530: p_value => p_batch_id,
8531: p_parameterlist => l_msg_parameter_list);
8532:
8533: WF_EVENT.AddParameterToList( p_name => 'OZF_RESALE_BATCH_CALLER',
8534: p_value => 'WEBADI',
8535: p_parameterlist => l_msg_parameter_list);
8536:
8537: --//Bugfix : 10431933
8534: p_value => 'WEBADI',
8535: p_parameterlist => l_msg_parameter_list);
8536:
8537: --//Bugfix : 10431933
8538: WF_EVENT.AddParameterToList( p_name => 'OZF_USER_ID',
8539: p_value => l_user_id,
8540: p_parameterlist => l_msg_parameter_list);
8541:
8542:
8539: p_value => l_user_id,
8540: p_parameterlist => l_msg_parameter_list);
8541:
8542:
8543: WF_EVENT.AddParameterToList( p_name => 'OZF_RESPONSIBILITY_ID',
8544: p_value => l_resp_id,
8545: p_parameterlist => l_msg_parameter_list);
8546:
8547: WF_EVENT.AddParameterToList( p_name => 'OZF_APPLICATION_ID',
8543: WF_EVENT.AddParameterToList( p_name => 'OZF_RESPONSIBILITY_ID',
8544: p_value => l_resp_id,
8545: p_parameterlist => l_msg_parameter_list);
8546:
8547: WF_EVENT.AddParameterToList( p_name => 'OZF_APPLICATION_ID',
8548: p_value => l_appl_id,
8549: p_parameterlist => l_msg_parameter_list);
8550:
8551: -- nepanda : Fix for Bug 12716192(13819601)
8548: p_value => l_appl_id,
8549: p_parameterlist => l_msg_parameter_list);
8550:
8551: -- nepanda : Fix for Bug 12716192(13819601)
8552: WF_EVENT.AddParameterToList( p_name => 'OZF_BATCH_ORG_ID',
8553: p_value => l_org_id,
8554: p_parameterlist => l_msg_parameter_list);
8555: -- nepanda : Fix for Bug 12716192(13819601) commented extra set context
8556: -- FND_GLOBAL.APPS_INITIALIZE(l_user_id, l_resp_id, l_appl_id);
8563: END IF;
8564:
8565: IF p_event_name = g_xml_confirm_bod_event THEN
8566:
8567: WF_EVENT.AddParameterToList( p_name=>'ECX_TRANSACTION_TYPE',
8568: p_value=>'ECX',
8569: p_parameterlist=>l_msg_parameter_list);
8570:
8571: WF_EVENT.AddParameterToList( p_name=>'ECX_TRANSACTION_SUBTYPE',
8567: WF_EVENT.AddParameterToList( p_name=>'ECX_TRANSACTION_TYPE',
8568: p_value=>'ECX',
8569: p_parameterlist=>l_msg_parameter_list);
8570:
8571: WF_EVENT.AddParameterToList( p_name=>'ECX_TRANSACTION_SUBTYPE',
8572: p_value=>'CBODO',
8573: p_parameterlist=>l_msg_parameter_list);
8574:
8575:
8572: p_value=>'CBODO',
8573: p_parameterlist=>l_msg_parameter_list);
8574:
8575:
8576: WF_EVENT.AddParameterToList( p_name=>'CONFIRM_STATUSLVL',
8577: p_value=>'00',
8578: p_parameterlist=>l_msg_parameter_list);
8579:
8580: FND_MESSAGE.set_name('OZF', 'OZF_XML_CONFIRM_INBOUND');
8579:
8580: FND_MESSAGE.set_name('OZF', 'OZF_XML_CONFIRM_INBOUND');
8581: l_confirm_descrtn := FND_MESSAGE.get;
8582:
8583: WF_EVENT.AddParameterToList( p_name=>'CONFIRM_DESCRTN',
8584: p_value=>l_confirm_descrtn,
8585: p_parameterlist=>l_msg_parameter_list);
8586:
8587:
8584: p_value=>l_confirm_descrtn,
8585: p_parameterlist=>l_msg_parameter_list);
8586:
8587:
8588: WF_EVENT.AddParameterToList( p_name=>'ECX_DEBUG_LEVEL',
8589: p_value=>'3',
8590: p_parameterlist=>l_msg_parameter_list);
8591:
8592: WF_EVENT.AddParameterToList( p_name=>'ECX_DOCUMENT_ID',
8588: WF_EVENT.AddParameterToList( p_name=>'ECX_DEBUG_LEVEL',
8589: p_value=>'3',
8590: p_parameterlist=>l_msg_parameter_list);
8591:
8592: WF_EVENT.AddParameterToList( p_name=>'ECX_DOCUMENT_ID',
8593: p_value=>p_batch_id,
8594: p_parameterlist=>l_msg_parameter_list);
8595:
8596:
8597:
8598: l_event_key := p_batch_id||'CBODO';
8599: END IF;
8600:
8601: WF_EVENT.raise ( p_event_name => p_event_name,
8602: p_event_key => l_event_key,
8603: p_parameters => l_msg_parameter_list );
8604:
8605: END IF;