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.EDR_PSIG_RULE dependencies on WF_EVENT

Line 145: p_eventP in out NOCOPY wf_event_t,

141: ( p_event_id in number,
142: p_map_code in varchar2,
143: p_ame_transaction_type in varchar2,
144: p_audit_group in varchar2,
145: p_eventP in out NOCOPY wf_event_t,
146: p_subscription_guid in raw,
147: P_approverlist in EDR_UTILITIES.approvers_Table,
148: P_ERR_CODE out NOCOPY varchar2,
149: P_ERR_MSG out NOCOPY varchar2

Line 165: l_event wf_event_t;

161: l_itemkey varchar2(240);
162: aname varchar2(240);
163: avalue varchar2(4000);
164: lparam wf_parameter_list_t;
165: l_event wf_event_t;
166: l_return_status varchar2(240);
167: l_document_id number;
168: l_error number;
169: l_error_msg varchar2(4000);

Line 191: l_event_user_key_label := wf_event.getValueForParameter('PSIG_USER_KEY_LABEL',p_eventP.Parameter_List);

187: /* Update workflow threshold to default threshold */
188: WF_ENGINE.THRESHOLD := 50;
189:
190: /* Get Payload Attributes required by Rule function */
191: l_event_user_key_label := wf_event.getValueForParameter('PSIG_USER_KEY_LABEL',p_eventP.Parameter_List);
192: l_event_user_key_value := wf_event.getValueForParameter('PSIG_USER_KEY_VALUE',p_eventP.Parameter_List);
193: l_transaction_audit_id := wf_event.getValueForParameter('PSIG_TRANSACTION_AUDIT_ID',p_eventP.Parameter_List);
194: l_requester := wf_event.getValueForParameter('#WF_SIGN_REQUESTER',p_eventP.Parameter_List);
195: wf_event.AddParameterToList('#FROM_ROLE', l_requester,p_eventP.Parameter_List); /* From Role */

Line 192: l_event_user_key_value := wf_event.getValueForParameter('PSIG_USER_KEY_VALUE',p_eventP.Parameter_List);

188: WF_ENGINE.THRESHOLD := 50;
189:
190: /* Get Payload Attributes required by Rule function */
191: l_event_user_key_label := wf_event.getValueForParameter('PSIG_USER_KEY_LABEL',p_eventP.Parameter_List);
192: l_event_user_key_value := wf_event.getValueForParameter('PSIG_USER_KEY_VALUE',p_eventP.Parameter_List);
193: l_transaction_audit_id := wf_event.getValueForParameter('PSIG_TRANSACTION_AUDIT_ID',p_eventP.Parameter_List);
194: l_requester := wf_event.getValueForParameter('#WF_SIGN_REQUESTER',p_eventP.Parameter_List);
195: wf_event.AddParameterToList('#FROM_ROLE', l_requester,p_eventP.Parameter_List); /* From Role */
196:

Line 193: l_transaction_audit_id := wf_event.getValueForParameter('PSIG_TRANSACTION_AUDIT_ID',p_eventP.Parameter_List);

189:
190: /* Get Payload Attributes required by Rule function */
191: l_event_user_key_label := wf_event.getValueForParameter('PSIG_USER_KEY_LABEL',p_eventP.Parameter_List);
192: l_event_user_key_value := wf_event.getValueForParameter('PSIG_USER_KEY_VALUE',p_eventP.Parameter_List);
193: l_transaction_audit_id := wf_event.getValueForParameter('PSIG_TRANSACTION_AUDIT_ID',p_eventP.Parameter_List);
194: l_requester := wf_event.getValueForParameter('#WF_SIGN_REQUESTER',p_eventP.Parameter_List);
195: wf_event.AddParameterToList('#FROM_ROLE', l_requester,p_eventP.Parameter_List); /* From Role */
196:
197: /* Temp Table Insertion */

Line 194: l_requester := wf_event.getValueForParameter('#WF_SIGN_REQUESTER',p_eventP.Parameter_List);

190: /* Get Payload Attributes required by Rule function */
191: l_event_user_key_label := wf_event.getValueForParameter('PSIG_USER_KEY_LABEL',p_eventP.Parameter_List);
192: l_event_user_key_value := wf_event.getValueForParameter('PSIG_USER_KEY_VALUE',p_eventP.Parameter_List);
193: l_transaction_audit_id := wf_event.getValueForParameter('PSIG_TRANSACTION_AUDIT_ID',p_eventP.Parameter_List);
194: l_requester := wf_event.getValueForParameter('#WF_SIGN_REQUESTER',p_eventP.Parameter_List);
195: wf_event.AddParameterToList('#FROM_ROLE', l_requester,p_eventP.Parameter_List); /* From Role */
196:
197: /* Temp Table Insertion */
198: l_event_name:=P_eventP.getEventName( );

Line 195: wf_event.AddParameterToList('#FROM_ROLE', l_requester,p_eventP.Parameter_List); /* From Role */

191: l_event_user_key_label := wf_event.getValueForParameter('PSIG_USER_KEY_LABEL',p_eventP.Parameter_List);
192: l_event_user_key_value := wf_event.getValueForParameter('PSIG_USER_KEY_VALUE',p_eventP.Parameter_List);
193: l_transaction_audit_id := wf_event.getValueForParameter('PSIG_TRANSACTION_AUDIT_ID',p_eventP.Parameter_List);
194: l_requester := wf_event.getValueForParameter('#WF_SIGN_REQUESTER',p_eventP.Parameter_List);
195: wf_event.AddParameterToList('#FROM_ROLE', l_requester,p_eventP.Parameter_List); /* From Role */
196:
197: /* Temp Table Insertion */
198: l_event_name:=P_eventP.getEventName( );
199: l_event_key:=P_eventP.getEventKey( );

Line 254: l_document_id := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_erecord_id_attr,p_eventP.Parameter_List);

250: -- Change status
251: -- Now this part will be handeled in PSIG_RULE for Both eRecord Only
252: -- and eSignature Required scenarios
253: --
254: l_document_id := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_erecord_id_attr,p_eventP.Parameter_List);
255: --Diagnostics Start
256: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
257: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_EREC_EVT');
258: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);

Line 270: wf_event.AddParameterToList('PSIG_DOCUMENT_ID', l_document_id,p_eventP.Parameter_List); /* Document_ID*/

266: --Diagnostics End
267:
268:
269: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','Set the Document ID '||l_document_ID ||' as Event Parameter');
270: wf_event.AddParameterToList('PSIG_DOCUMENT_ID', l_document_id,p_eventP.Parameter_List); /* Document_ID*/
271: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','Document ID added to event parameters ' );
272:
273: /* 24-FEB-2003: CJ : add the attachment item attribute to the workflow so that the attachments
274: of the eRecord show up in the workflow notification sent out to the signer*/

Line 278: wf_event.AddParameterToList('#ATTACHMENTS', 'FND:entity=ERECORD'||'&'||'pk1name=DOCUMENT_ID'||'&'||'pk1value='||l_document_id,p_eventP.Parameter_List);

274: of the eRecord show up in the workflow notification sent out to the signer*/
275:
276:
277: /* Attachments_ID*/
278: wf_event.AddParameterToList('#ATTACHMENTS', 'FND:entity=ERECORD'||'&'||'pk1name=DOCUMENT_ID'||'&'||'pk1value='||l_document_id,p_eventP.Parameter_List);
279: wf_log_pkg.string(3, 'EDR_PSIG_rule.create_pageflow','Attachments added to event parameters ' );
280: /* 24-FEB-2003: CJ: end */
281:
282: for i in 1 .. P_approverlist.count loop

Line 459: wf_event.setErrorInfo(p_eventP,'ERROR');

455:
456: /* Update workflow threshold to saved value */
457: WF_ENGINE.THRESHOLD := l_cur_threshold;
458: Wf_Core.Context('EDR_PSIG_RULE', 'CREATE_PAGEFLOW', p_eventP.getEventName(), p_subscription_guid);
459: wf_event.setErrorInfo(p_eventP,'ERROR');
460: ROLLBACK;
461: p_err_code:=l_error;
462: p_err_msg:=l_error_msg;
463:

Line 483: wf_event.setErrorInfo(p_eventP,'ERROR');

479: when DEFAULT_RULE_ERROR then
480: /* Update workflow threshold to saved value */
481: WF_ENGINE.THRESHOLD := l_cur_threshold;
482: Wf_Core.Context('EDR_PSIG_RULE', 'CREATE_PAGEFLOW', p_eventP.getEventName(), p_subscription_guid);
483: wf_event.setErrorInfo(p_eventP,'ERROR');
484: ROLLBACK;
485: p_err_code:=l_error;
486: p_err_msg:= l_error_msg;
487:

Line 509: wf_event.setErrorInfo(p_eventP,'ERROR');

505: Wf_Core.get_ERROR(l_error,l_error_msg,l_error_stack);
506: wf_log_pkg.string(6,'in when others of create_pageflow'||l_error,l_error_msg||substr(l_error_stack,1,100));
507: WF_ENGINE.THRESHOLD := l_cur_threshold;
508: Wf_Core.Context('EDR_PSIG_RULE', 'CREATE_PAGEFLOW', p_eventP.getEventName(), p_subscription_guid);
509: wf_event.setErrorInfo(p_eventP,'ERROR');
510: ROLLBACK;
511: p_err_code:=l_error;
512: p_err_msg:=l_error_msg;
513: --Diagnostics Start

Line 558: x_event in out NOCOPY wf_event_t

554: p_application_code VARCHAR2,
555: p_edr_event_id NUMBER,
556: p_esign_required VARCHAR2,
557: p_subscription_guid RAW,
558: x_event in out NOCOPY wf_event_t
559: ) IS PRAGMA AUTONOMOUS_TRANSACTION;
560: l_XML_DOCUMENT CLOB ;
561: l_EREC_OUTPUT CLOB;
562: l_EREC_OUTPUT_CH VARCHAR2(512);

Line 616: l_force_erecord := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_FORCE_ERECORD,x_event.Parameter_List);

612: BEGIN
613:
614: --Bug 4150616: Start
615: --Fetch the value of FORCE_ERECORD from the event payload.
616: l_force_erecord := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_FORCE_ERECORD,x_event.Parameter_List);
617:
618: --Fetch the value of FORCE_ERECORD_USED from the event payload.
619: l_force_erecord_used := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_FORCE_ERECORD_USED,x_event.Parameter_List);
620: --Bug 4150616: End

Line 619: l_force_erecord_used := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_FORCE_ERECORD_USED,x_event.Parameter_List);

615: --Fetch the value of FORCE_ERECORD from the event payload.
616: l_force_erecord := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_FORCE_ERECORD,x_event.Parameter_List);
617:
618: --Fetch the value of FORCE_ERECORD_USED from the event payload.
619: l_force_erecord_used := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_FORCE_ERECORD_USED,x_event.Parameter_List);
620: --Bug 4150616: End
621:
622: --Bug 4074173 : start
623: l_approved := false;

Line 649: l_requester := wf_event.getValueForParameter('#WF_SIGN_REQUESTER',x_event.Parameter_List);

645:
646: /* Only eRecord Required. Generate the eRecord output Output and post it in temp tables */
647: L_EREC_OUTPUT:=P_XML_DOCUMENT;
648: wf_log_pkg.string(3, 'EDR_PSIG_RULE.STORE_ERECORD','Start of store erecord');
649: l_requester := wf_event.getValueForParameter('#WF_SIGN_REQUESTER',x_event.Parameter_List);
650:
651: --Bug 3170251 : Start- EREC_TEMPLATE TYPE from Workflow
652: /* Find the Style Sheet Type from Workflow Parameter EREC_TEMPLATE_TYPE */
653: l_style_sheet_type := wf_event.getValueForParameter('EREC_TEMPLATE_TYPE',x_event.Parameter_List);

Line 653: l_style_sheet_type := wf_event.getValueForParameter('EREC_TEMPLATE_TYPE',x_event.Parameter_List);

649: l_requester := wf_event.getValueForParameter('#WF_SIGN_REQUESTER',x_event.Parameter_List);
650:
651: --Bug 3170251 : Start- EREC_TEMPLATE TYPE from Workflow
652: /* Find the Style Sheet Type from Workflow Parameter EREC_TEMPLATE_TYPE */
653: l_style_sheet_type := wf_event.getValueForParameter('EREC_TEMPLATE_TYPE',x_event.Parameter_List);
654: -- Bug 3170251 : End
655:
656: -- Bug 3170251 : Start- Open the PSIG document, to get the l_document_id value for use in XDOC
657: EDR_PSIG.openDocument(P_PSIG_XML => p_xml_document,

Line 688: l_redline_required := wf_event.getValueForParameter('REDLINE_REQUIRED',x_event.Parameter_List);

684: end if;
685: --Diagnostics End
686:
687: -- Bug 3761813 : start
688: l_redline_required := wf_event.getValueForParameter('REDLINE_REQUIRED',x_event.Parameter_List);
689: wf_log_pkg.string(3, 'EDR_PSIG_RULE.store_erecord','REDLINE_REQUIRED'||l_redline_required);
690: -- Bug 3761813 : end
691:
692:

Line 699: l_source_application_type := wf_event.getValueForParameter('#WF_SOURCE_APPLICATION_TYPE',x_event.Parameter_List);

695: IF (UPPER(l_style_sheet_type) = 'RTF') THEN
696:
697: --Bug 2637353: Start
698: --Check if source application type is "MSCA".
699: l_source_application_type := wf_event.getValueForParameter('#WF_SOURCE_APPLICATION_TYPE',x_event.Parameter_List);
700: if(l_source_application_type = 'MSCA') then
701: raise MSCA_TMPL_ERROR;
702: END IF;
703: --Bug 2637353: End

Line 990: l_event_user_key_label := wf_event.getValueForParameter('PSIG_USER_KEY_LABEL',x_event.Parameter_List);

986: RAISE ERECORD_UNKWN_TMPL_TYPE;
987: END IF;
988:
989: /* Get Payload Attributes required by Rule function */
990: l_event_user_key_label := wf_event.getValueForParameter('PSIG_USER_KEY_LABEL',x_event.Parameter_List);
991: l_event_user_key_value := wf_event.getValueForParameter('PSIG_USER_KEY_VALUE',x_event.Parameter_List);
992: l_source_application := wf_event.getValueForParameter('#WF_SOURCE_APPLICATION_TYPE',x_event.Parameter_List);
993: l_requester := wf_event.getValueForParameter('#WF_SIGN_REQUESTER',x_event.Parameter_List);
994:

Line 991: l_event_user_key_value := wf_event.getValueForParameter('PSIG_USER_KEY_VALUE',x_event.Parameter_List);

987: END IF;
988:
989: /* Get Payload Attributes required by Rule function */
990: l_event_user_key_label := wf_event.getValueForParameter('PSIG_USER_KEY_LABEL',x_event.Parameter_List);
991: l_event_user_key_value := wf_event.getValueForParameter('PSIG_USER_KEY_VALUE',x_event.Parameter_List);
992: l_source_application := wf_event.getValueForParameter('#WF_SOURCE_APPLICATION_TYPE',x_event.Parameter_List);
993: l_requester := wf_event.getValueForParameter('#WF_SIGN_REQUESTER',x_event.Parameter_List);
994:
995: /* Call Repository API's */

Line 992: l_source_application := wf_event.getValueForParameter('#WF_SOURCE_APPLICATION_TYPE',x_event.Parameter_List);

988:
989: /* Get Payload Attributes required by Rule function */
990: l_event_user_key_label := wf_event.getValueForParameter('PSIG_USER_KEY_LABEL',x_event.Parameter_List);
991: l_event_user_key_value := wf_event.getValueForParameter('PSIG_USER_KEY_VALUE',x_event.Parameter_List);
992: l_source_application := wf_event.getValueForParameter('#WF_SOURCE_APPLICATION_TYPE',x_event.Parameter_List);
993: l_requester := wf_event.getValueForParameter('#WF_SIGN_REQUESTER',x_event.Parameter_List);
994:
995: /* Call Repository API's */
996: wf_log_pkg.string(3, 'EDR_PSIG_RULE.store_erecord','Posting Document in eRecords Repository');

Line 993: l_requester := wf_event.getValueForParameter('#WF_SIGN_REQUESTER',x_event.Parameter_List);

989: /* Get Payload Attributes required by Rule function */
990: l_event_user_key_label := wf_event.getValueForParameter('PSIG_USER_KEY_LABEL',x_event.Parameter_List);
991: l_event_user_key_value := wf_event.getValueForParameter('PSIG_USER_KEY_VALUE',x_event.Parameter_List);
992: l_source_application := wf_event.getValueForParameter('#WF_SOURCE_APPLICATION_TYPE',x_event.Parameter_List);
993: l_requester := wf_event.getValueForParameter('#WF_SIGN_REQUESTER',x_event.Parameter_List);
994:
995: /* Call Repository API's */
996: wf_log_pkg.string(3, 'EDR_PSIG_RULE.store_erecord','Posting Document in eRecords Repository');
997:

Line 1117: wf_event.AddParameterToList('#ERECORD_ID',

1113:
1114:
1115: /* 20-OCT-2003: srpuri : end */
1116: --ER # 2966866 start
1117: wf_event.AddParameterToList('#ERECORD_ID',
1118: l_document_id,
1119: x_event.Parameter_List);
1120: wf_log_pkg.string(1, 'EDR_PSIG_RULE.store_erecord','eRecord Id added to payload: '||l_document_id);
1121:

Line 1232: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');

1228: EXCEPTION
1229: when ERECORD_GENERATION_ERROR then
1230: ROLLBACK;
1231: Wf_Core.Context('EDR_PSIG_RULE', 'STORE_ERECORD', x_event.getEventName(), p_subscription_guid);
1232: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1233: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1234: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1235: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1236: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_RULE');

Line 1251: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');

1247: APP_EXCEPTION.RAISE_EXCEPTION;
1248: when ERECORD_CREATION_ERROR then
1249: ROLLBACK;
1250: Wf_Core.Context('EDR_PSIG_RULE', 'STORE_ERECORD', x_event.getEventName(), p_subscription_guid);
1251: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1252: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1253: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1254: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1255: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');

Line 1270: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');

1266: APP_EXCEPTION.RAISE_EXCEPTION;
1267: when ERECORD_PARAM_ERROR then
1268: ROLLBACK;
1269: Wf_Core.Context('EDR_PSIG_RULE', 'STORE_ERECORD', x_event.getEventName(), p_subscription_guid);
1270: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1271: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1272: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1273: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1274: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');

Line 1290: Wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR XSLFO MISSING');

1286: -- Bug 3170251 : Start - Added following new exceptions for error handling
1287: when ERECORD_GEN_XSLFOMISS_ERR then
1288: ROLLBACK;
1289: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1290: Wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR XSLFO MISSING');
1291: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_XSLFO_MISSING_ERR');
1292: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);
1293: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);
1294: --Diagnostics Start

Line 1307: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');

1303:
1304: when ERECORD_GEN_FATALERR then
1305: ROLLBACK;
1306: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1307: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1308:
1309: wf_log_pkg.string(5, 'EDR_PSIG_RULE.store_erecord','There is a fatal error during e-record creation using XDO API');
1310:
1311: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

Line 1329: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');

1325: APP_EXCEPTION.RAISE_EXCEPTION;
1326: when ERECORD_GEN_UNKNWN_ERR then
1327: ROLLBACK;
1328: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1329: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1330: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1331: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1332: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1333: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');

Line 1348: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR IN XDO');

1344: APP_EXCEPTION.RAISE_EXCEPTION;
1345: when ERECORD_GEN_XDOERR then
1346: ROLLBACK;
1347: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1348: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR IN XDO');
1349: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_XDO_ERR');
1350: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);
1351: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);
1352:

Line 1366: wf_event.setErrorInfo(x_event,SQLERRM || 'Unknown Template Type'|| l_style_sheet_type);

1362: APP_EXCEPTION.RAISE_EXCEPTION;
1363: when ERECORD_UNKWN_TMPL_TYPE then
1364: ROLLBACK;
1365: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1366: wf_event.setErrorInfo(x_event,SQLERRM || 'Unknown Template Type'|| l_style_sheet_type);
1367: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_TMPL_TYPE_ERR');
1368: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);
1369: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);
1370:

Line 1385: Wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR JSP MISSING');

1381:
1382: when ERECORD_GEN_JSPMSNG_ERR then
1383: ROLLBACK;
1384: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1385: Wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR JSP MISSING');
1386: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_JSP_MISSING_ERR');
1387:
1388: --Diagnostics Start
1389: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1401: Wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR JSP UTL_HTTP REQUEST FAILED');

1397: APP_EXCEPTION.RAISE_EXCEPTION;
1398: when ERECORD_GEN_JSPRQFAIL_ERR then
1399: ROLLBACK;
1400: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1401: Wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR JSP UTL_HTTP REQUEST FAILED');
1402: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_JSPREQFAIL_ERR');
1403:
1404: --Diagnostics Start
1405: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1420: Wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR : XSLT Transformation error');

1416: -- Bug 3390571 : Start
1417: when ERECORD_GEN_XSLT_ERR then
1418: ROLLBACK;
1419: wf_core.context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1420: Wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR : XSLT Transformation error');
1421: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_XSLTTRANS_ERR');
1422: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);
1423: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);
1424: --Diagnostics Start

Line 1454: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');

1450:
1451: when OTHERS then
1452: ROLLBACK;
1453: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1454: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1455: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1456: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1457: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1458: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');

Line 1482: p_event in out NOCOPY wf_event_t)

1478: */
1479:
1480:
1481: function psig_rule(p_subscription_guid in raw,
1482: p_event in out NOCOPY wf_event_t)
1483:
1484: return varchar2
1485:
1486: is

Line 1710: wf_event.AddParameterToList('EDR_AME_TRANSACTION_TYPE',

1706: -- srpuri: We still need to copy parameters whatever workflow can copy.
1707: l_return_status := wf_rule.setParametersIntoParameterList(p_subscription_guid,p_event);
1708: l_temp_value := EDR_INDEXED_XML_UTIL.GET_WF_PARAMS('EDR_AME_TRANSACTION_TYPE',p_subscription_guid);
1709: if(l_temp_value is not null) then
1710: wf_event.AddParameterToList('EDR_AME_TRANSACTION_TYPE',
1711: l_temp_value,
1712: p_event.Parameter_List);
1713: end if;
1714: l_temp_value := EDR_INDEXED_XML_UTIL.GET_WF_PARAMS('EDR_XML_MAP_CODE',p_subscription_guid);

Line 1716: wf_event.AddParameterToList('EDR_XML_MAP_CODE',

1712: p_event.Parameter_List);
1713: end if;
1714: l_temp_value := EDR_INDEXED_XML_UTIL.GET_WF_PARAMS('EDR_XML_MAP_CODE',p_subscription_guid);
1715: if(l_temp_value is not null) then
1716: wf_event.AddParameterToList('EDR_XML_MAP_CODE',
1717: l_temp_value,
1718: p_event.Parameter_List);
1719: end if;
1720: l_temp_value := EDR_INDEXED_XML_UTIL.GET_WF_PARAMS(EDR_CONSTANTS_GRP.G_FORCE_ERECORD,p_subscription_guid);

Line 1723: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_FORCE_ERECORD,

1719: end if;
1720: l_temp_value := EDR_INDEXED_XML_UTIL.GET_WF_PARAMS(EDR_CONSTANTS_GRP.G_FORCE_ERECORD,p_subscription_guid);
1721:
1722: if(l_temp_value is not null) then
1723: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_FORCE_ERECORD,
1724: l_temp_value,
1725: p_event.Parameter_List);
1726: end if;
1727: -- Bug 5639849: Ends

Line 1733: l_force_erecord := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_FORCE_ERECORD,p_event.Parameter_List);

1729: --Fetch the value of the ERES profile option.
1730: l_eres_profile_value := fnd_profile.value('EDR_ERES_ENABLED');
1731:
1732: --Fetch the value of FORCE_ERECORD.
1733: l_force_erecord := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_FORCE_ERECORD,p_event.Parameter_List);
1734:
1735: --Convert it to upper case for ease in verification later in the code.
1736: l_force_erecord := upper(l_force_erecord);
1737: --Bug 4150616: End

Line 1740: l_source_application_type := wf_event.getValueForParameter('#WF_SOURCE_APPLICATION_TYPE',p_event.Parameter_List);

1736: l_force_erecord := upper(l_force_erecord);
1737: --Bug 4150616: End
1738: --Bug 5891879: Start
1739: --Read the source application type
1740: l_source_application_type := wf_event.getValueForParameter('#WF_SOURCE_APPLICATION_TYPE',p_event.Parameter_List);
1741: --Bug 5891879 : End
1742: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','Start of the rule function');
1743:
1744: --Bug 4150616: Start

Line 1754: l_ame_transaction_type := NVL(wf_event.getValueForParameter('EDR_AME_TRANSACTION_TYPE',p_event.Parameter_List),

1750: --Bug 4160412: End
1751:
1752: --IF l_return_status='SUCCESS' THEN
1753: /* Check for User Defined Parameters. We only require AME parameter for now */
1754: l_ame_transaction_type := NVL(wf_event.getValueForParameter('EDR_AME_TRANSACTION_TYPE',p_event.Parameter_List),
1755: P_EVENT.getEventName());
1756: -- END IF;
1757:
1758: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','AME transaction Type :'||l_ame_transaction_type );

Line 1776: l_parent_event := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_parent_event_name ,p_event.Parameter_List);

1772:
1773: --ER # 2966866 start
1774:
1775: --get the PARENT_EVENT_NAME parameter
1776: l_parent_event := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_parent_event_name ,p_event.Parameter_List);
1777: wf_log_pkg.string(1, 'EDR_PSIG_rule.psig_rule','Parent Event Name:'||l_parent_event);
1778:
1779: --get the PARENT_EVENT_KEY parameter
1780: l_parent_key := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_parent_event_key,p_event.Parameter_List);

Line 1780: l_parent_key := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_parent_event_key,p_event.Parameter_List);

1776: l_parent_event := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_parent_event_name ,p_event.Parameter_List);
1777: wf_log_pkg.string(1, 'EDR_PSIG_rule.psig_rule','Parent Event Name:'||l_parent_event);
1778:
1779: --get the PARENT_EVENT_KEY parameter
1780: l_parent_key := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_parent_event_key,p_event.Parameter_List);
1781:
1782: wf_log_pkg.string(1, 'EDR_PSIG_rule.psig_rule','Parent Event Key:'||l_parent_key);
1783:
1784: --get the PARENT_ERECORD_ID parameter

Line 1785: l_parent_erecord_id := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_parent_erecord_id,p_event.Parameter_List);

1781:
1782: wf_log_pkg.string(1, 'EDR_PSIG_rule.psig_rule','Parent Event Key:'||l_parent_key);
1783:
1784: --get the PARENT_ERECORD_ID parameter
1785: l_parent_erecord_id := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_parent_erecord_id,p_event.Parameter_List);
1786:
1787: wf_log_pkg.string(1, 'EDR_PSIG_rule.psig_rule','Parent eRecord ID:'||l_parent_erecord_id);
1788:
1789: --find out if the requisite parameters are passed in the payload so as

Line 1843: from wf_events a, wf_event_subscriptions b

1839: -- present for the parent event
1840: --
1841:
1842: select count(*) INTO l_no_enabled_eres_sub
1843: from wf_events a, wf_event_subscriptions b
1844: where a.GUID = b.EVENT_FILTER_GUID
1845: and a.name = l_parent_event
1846: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
1847: --Bug No 4912782- Start

Line 1861: from wf_events a, wf_event_subscriptions b

1857: -- for parent event. if more than one ERES subscription is ENABLED
1858: -- Raise Multiple ERES Subscriptions error
1859: --
1860: select count(*) INTO l_no_enabled_eres_sub
1861: from wf_events a, wf_event_subscriptions b
1862: where a.GUID = b.EVENT_FILTER_GUID
1863: and a.name = l_parent_event
1864: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
1865: and b.STATUS = 'ENABLED'

Line 1918: from wf_events a, wf_event_subscriptions b

1914: -- for current event. if more than one ERES subscription is ENABLED
1915: -- Raise Multiple ERES Subscriptions error
1916: --
1917: select count(*) INTO l_no_enabled_eres_sub
1918: from wf_events a, wf_event_subscriptions b
1919: where a.GUID = b.EVENT_FILTER_GUID
1920: and a.name = p_event.event_name
1921: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
1922: and b.STATUS = 'ENABLED'

Line 1938: FROM FND_APPLICATION A, WF_EVENTS B

1934: /* Select APPLICATION_ID of the Event. This is required by AME. Assumption made here
1935: is OWNER_TAG will always be set to application Short Name */
1936:
1937: SELECT application_id,APPLICATION_SHORT_NAME into l_application_id,l_application_code
1938: FROM FND_APPLICATION A, WF_EVENTS B
1939: WHERE A.APPLICATION_SHORT_NAME = B.OWNER_TAG
1940: AND B.NAME=P_EVENT.getEventName( );
1941:
1942: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Application_id :'||l_application_id );

Line 1960: l_xml_map_code := NVL(wf_event.getValueForParameter('EDR_XML_MAP_CODE',p_event.Parameter_List),

1956: --Obtain event details
1957: l_event_data:=p_event.getEventData();
1958: l_event_name:=p_event.getEventName();
1959: l_event_key:=p_event.getEventKey();
1960: l_xml_map_code := NVL(wf_event.getValueForParameter('EDR_XML_MAP_CODE',p_event.Parameter_List),
1961: P_EVENT.getEventName( ));
1962:
1963:
1964: --Insert into temp table. This is done because a handle to a CLOB created through JDBC

Line 1998: l_transform_xml := NVL(wf_event.getValueForParameter('TRANSFORM_XML',p_event.Parameter_List),

1994: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','eRecord id: '||l_edr_Event_id||' will be sent to ECX');
1995:
1996: --Bug 3893101: Start
1997: --Obtain the value of transform xml parameter.
1998: l_transform_xml := NVL(wf_event.getValueForParameter('TRANSFORM_XML',p_event.Parameter_List),
1999: 'Y');
2000: --If it is set to 'Y' then generate the XML as required.
2001: if l_transform_xml = 'Y' then
2002: --Generate the customised Erecord using XML Gateway

Line 2022: l_attachment_string_details := wf_event.getValueForParameter('EDR_PSIG_ATTACHMENT',p_event.Parameter_List);

2018: --We need to recreate the event CLOB in another XML CLOB as
2019: --the CLOB obtained from the event definition cannot be modified.
2020: DBMS_LOB.CREATETEMPORARY(l_erecord_data, TRUE, DBMS_LOB.SESSION);
2021: DBMS_LOB.COPY(l_erecord_data,l_event_data,DBMS_LOB.GETLENGTH(l_event_data));
2022: l_attachment_string_details := wf_event.getValueForParameter('EDR_PSIG_ATTACHMENT',p_event.Parameter_List);
2023: if l_attachment_string_details is not null then
2024: EDR_ATTACHMENTS_GRP.ADD_ERP_ATTACH(p_attachment_string => l_attachment_string_details);
2025: end if;
2026:

Line 2154: l_source_application_type := wf_event.getValueForParameter('#WF_SOURCE_APPLICATION_TYPE',p_event.Parameter_List);

2150: FALSE
2151: );
2152: end if;
2153: --Diagnostics End
2154: l_source_application_type := wf_event.getValueForParameter('#WF_SOURCE_APPLICATION_TYPE',p_event.Parameter_List);
2155: -- Bug 3214495 : Start
2156:
2157: EDR_STANDARD.GET_AMERULE_INPUT_VARIABLES
2158: (transactiontypeid => NVL(l_ame_transaction_type,P_EVENT.getEventName()),

Line 2234: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_FORCE_ERECORD_USED, 'Y',p_event.Parameter_List);

2230: --Bug 4543216: End
2231: l_lite_mode := true;
2232: ELSIF l_force_erecord = 'Y' then
2233: --Add the parameter into the event list.
2234: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_FORCE_ERECORD_USED, 'Y',p_event.Parameter_List);
2235: --Bug 4150616: End
2236: --Bug 5724159 : Start
2237: --The Control should not return back without generating E-Record
2238: /* ELSE*/

Line 2433: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_FORCE_ERECORD_USED,'Y',p_event.Parameter_List);

2429: --turn is added to the doc params which indicates that the e-record is being
2430: --created because FORCE_ERECORD is set to Y.
2431: --This parameter is named "FORCE_ERECORD_USED".
2432: if l_eres_profile_value = 'N' OR (upper(l_esign_required) = 'N' and upper(l_erecord_required) = 'N') then
2433: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_FORCE_ERECORD_USED,'Y',p_event.Parameter_List);
2434: end if;
2435: --Bug 4150616: End
2436:
2437: l_audit_group := NVL(wf_event.getValueForParameter('EDR_AUDIT_GROUP',p_event.Parameter_List),

Line 2437: l_audit_group := NVL(wf_event.getValueForParameter('EDR_AUDIT_GROUP',p_event.Parameter_List),

2433: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_FORCE_ERECORD_USED,'Y',p_event.Parameter_List);
2434: end if;
2435: --Bug 4150616: End
2436:
2437: l_audit_group := NVL(wf_event.getValueForParameter('EDR_AUDIT_GROUP',p_event.Parameter_List),
2438: P_EVENT.getEventName( ));
2439:
2440: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','XML Map Code :'||l_xml_map_code );
2441: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Audit Group :'||l_audit_group );

Line 2445: /* wf_event.AddParameterToList('SUB_GUID', p_subscription_guid,p_event.Parameter_List); Subscription ID */

2441: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Audit Group :'||l_audit_group );
2442: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Setting ECX parameter');
2443:
2444: /* Set Additional Parameters required by Esignature */
2445: /* wf_event.AddParameterToList('SUB_GUID', p_subscription_guid,p_event.Parameter_List); Subscription ID */
2446: wf_event.AddParameterToList('ECX_MAP_CODE', l_xml_map_code,p_event.Parameter_List); /* XML Map Code*/
2447: wf_event.AddParameterToList('ECX_DOCUMENT_ID', P_EVENT.getEventKey( ),p_event.Parameter_List); /* XML Document ID*/
2448: wf_event.AddParameterToList('TEXT_XSLNAME', l_style_sheet,p_event.Parameter_List); /* Style Sheet*/
2449: wf_event.AddParameterToList('TEXT_XSLVERSION', l_style_sheet_ver,p_event.Parameter_List); /* Style Sheet*/

Line 2446: wf_event.AddParameterToList('ECX_MAP_CODE', l_xml_map_code,p_event.Parameter_List); /* XML Map Code*/

2442: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Setting ECX parameter');
2443:
2444: /* Set Additional Parameters required by Esignature */
2445: /* wf_event.AddParameterToList('SUB_GUID', p_subscription_guid,p_event.Parameter_List); Subscription ID */
2446: wf_event.AddParameterToList('ECX_MAP_CODE', l_xml_map_code,p_event.Parameter_List); /* XML Map Code*/
2447: wf_event.AddParameterToList('ECX_DOCUMENT_ID', P_EVENT.getEventKey( ),p_event.Parameter_List); /* XML Document ID*/
2448: wf_event.AddParameterToList('TEXT_XSLNAME', l_style_sheet,p_event.Parameter_List); /* Style Sheet*/
2449: wf_event.AddParameterToList('TEXT_XSLVERSION', l_style_sheet_ver,p_event.Parameter_List); /* Style Sheet*/
2450: wf_event.AddParameterToList('HTML_XSLNAME', NULL,p_event.Parameter_List); /* Style Sheet*/

Line 2447: wf_event.AddParameterToList('ECX_DOCUMENT_ID', P_EVENT.getEventKey( ),p_event.Parameter_List); /* XML Document ID*/

2443:
2444: /* Set Additional Parameters required by Esignature */
2445: /* wf_event.AddParameterToList('SUB_GUID', p_subscription_guid,p_event.Parameter_List); Subscription ID */
2446: wf_event.AddParameterToList('ECX_MAP_CODE', l_xml_map_code,p_event.Parameter_List); /* XML Map Code*/
2447: wf_event.AddParameterToList('ECX_DOCUMENT_ID', P_EVENT.getEventKey( ),p_event.Parameter_List); /* XML Document ID*/
2448: wf_event.AddParameterToList('TEXT_XSLNAME', l_style_sheet,p_event.Parameter_List); /* Style Sheet*/
2449: wf_event.AddParameterToList('TEXT_XSLVERSION', l_style_sheet_ver,p_event.Parameter_List); /* Style Sheet*/
2450: wf_event.AddParameterToList('HTML_XSLNAME', NULL,p_event.Parameter_List); /* Style Sheet*/
2451: wf_event.AddParameterToList('HTML_XSLVERSION', NULL,p_event.Parameter_List); /* Style Sheet*/

Line 2448: wf_event.AddParameterToList('TEXT_XSLNAME', l_style_sheet,p_event.Parameter_List); /* Style Sheet*/

2444: /* Set Additional Parameters required by Esignature */
2445: /* wf_event.AddParameterToList('SUB_GUID', p_subscription_guid,p_event.Parameter_List); Subscription ID */
2446: wf_event.AddParameterToList('ECX_MAP_CODE', l_xml_map_code,p_event.Parameter_List); /* XML Map Code*/
2447: wf_event.AddParameterToList('ECX_DOCUMENT_ID', P_EVENT.getEventKey( ),p_event.Parameter_List); /* XML Document ID*/
2448: wf_event.AddParameterToList('TEXT_XSLNAME', l_style_sheet,p_event.Parameter_List); /* Style Sheet*/
2449: wf_event.AddParameterToList('TEXT_XSLVERSION', l_style_sheet_ver,p_event.Parameter_List); /* Style Sheet*/
2450: wf_event.AddParameterToList('HTML_XSLNAME', NULL,p_event.Parameter_List); /* Style Sheet*/
2451: wf_event.AddParameterToList('HTML_XSLVERSION', NULL,p_event.Parameter_List); /* Style Sheet*/
2452: wf_event.AddParameterToList('APPLICATION_CODE', lower(l_application_code),p_event.Parameter_List); /* Style Sheet*/

Line 2449: wf_event.AddParameterToList('TEXT_XSLVERSION', l_style_sheet_ver,p_event.Parameter_List); /* Style Sheet*/

2445: /* wf_event.AddParameterToList('SUB_GUID', p_subscription_guid,p_event.Parameter_List); Subscription ID */
2446: wf_event.AddParameterToList('ECX_MAP_CODE', l_xml_map_code,p_event.Parameter_List); /* XML Map Code*/
2447: wf_event.AddParameterToList('ECX_DOCUMENT_ID', P_EVENT.getEventKey( ),p_event.Parameter_List); /* XML Document ID*/
2448: wf_event.AddParameterToList('TEXT_XSLNAME', l_style_sheet,p_event.Parameter_List); /* Style Sheet*/
2449: wf_event.AddParameterToList('TEXT_XSLVERSION', l_style_sheet_ver,p_event.Parameter_List); /* Style Sheet*/
2450: wf_event.AddParameterToList('HTML_XSLNAME', NULL,p_event.Parameter_List); /* Style Sheet*/
2451: wf_event.AddParameterToList('HTML_XSLVERSION', NULL,p_event.Parameter_List); /* Style Sheet*/
2452: wf_event.AddParameterToList('APPLICATION_CODE', lower(l_application_code),p_event.Parameter_List); /* Style Sheet*/
2453: wf_event.AddParameterToList('EDR_SIGN_REQUIRED', l_esign_required,p_event.Parameter_List); /* Signature Required*/

Line 2450: wf_event.AddParameterToList('HTML_XSLNAME', NULL,p_event.Parameter_List); /* Style Sheet*/

2446: wf_event.AddParameterToList('ECX_MAP_CODE', l_xml_map_code,p_event.Parameter_List); /* XML Map Code*/
2447: wf_event.AddParameterToList('ECX_DOCUMENT_ID', P_EVENT.getEventKey( ),p_event.Parameter_List); /* XML Document ID*/
2448: wf_event.AddParameterToList('TEXT_XSLNAME', l_style_sheet,p_event.Parameter_List); /* Style Sheet*/
2449: wf_event.AddParameterToList('TEXT_XSLVERSION', l_style_sheet_ver,p_event.Parameter_List); /* Style Sheet*/
2450: wf_event.AddParameterToList('HTML_XSLNAME', NULL,p_event.Parameter_List); /* Style Sheet*/
2451: wf_event.AddParameterToList('HTML_XSLVERSION', NULL,p_event.Parameter_List); /* Style Sheet*/
2452: wf_event.AddParameterToList('APPLICATION_CODE', lower(l_application_code),p_event.Parameter_List); /* Style Sheet*/
2453: wf_event.AddParameterToList('EDR_SIGN_REQUIRED', l_esign_required,p_event.Parameter_List); /* Signature Required*/
2454: wf_event.AddParameterToList('EDR_EREC_REQUIRED', l_erecord_required,p_event.Parameter_List); /* eRecord Required*/

Line 2451: wf_event.AddParameterToList('HTML_XSLVERSION', NULL,p_event.Parameter_List); /* Style Sheet*/

2447: wf_event.AddParameterToList('ECX_DOCUMENT_ID', P_EVENT.getEventKey( ),p_event.Parameter_List); /* XML Document ID*/
2448: wf_event.AddParameterToList('TEXT_XSLNAME', l_style_sheet,p_event.Parameter_List); /* Style Sheet*/
2449: wf_event.AddParameterToList('TEXT_XSLVERSION', l_style_sheet_ver,p_event.Parameter_List); /* Style Sheet*/
2450: wf_event.AddParameterToList('HTML_XSLNAME', NULL,p_event.Parameter_List); /* Style Sheet*/
2451: wf_event.AddParameterToList('HTML_XSLVERSION', NULL,p_event.Parameter_List); /* Style Sheet*/
2452: wf_event.AddParameterToList('APPLICATION_CODE', lower(l_application_code),p_event.Parameter_List); /* Style Sheet*/
2453: wf_event.AddParameterToList('EDR_SIGN_REQUIRED', l_esign_required,p_event.Parameter_List); /* Signature Required*/
2454: wf_event.AddParameterToList('EDR_EREC_REQUIRED', l_erecord_required,p_event.Parameter_List); /* eRecord Required*/
2455: --Bug 3761813 : start

Line 2452: wf_event.AddParameterToList('APPLICATION_CODE', lower(l_application_code),p_event.Parameter_List); /* Style Sheet*/

2448: wf_event.AddParameterToList('TEXT_XSLNAME', l_style_sheet,p_event.Parameter_List); /* Style Sheet*/
2449: wf_event.AddParameterToList('TEXT_XSLVERSION', l_style_sheet_ver,p_event.Parameter_List); /* Style Sheet*/
2450: wf_event.AddParameterToList('HTML_XSLNAME', NULL,p_event.Parameter_List); /* Style Sheet*/
2451: wf_event.AddParameterToList('HTML_XSLVERSION', NULL,p_event.Parameter_List); /* Style Sheet*/
2452: wf_event.AddParameterToList('APPLICATION_CODE', lower(l_application_code),p_event.Parameter_List); /* Style Sheet*/
2453: wf_event.AddParameterToList('EDR_SIGN_REQUIRED', l_esign_required,p_event.Parameter_List); /* Signature Required*/
2454: wf_event.AddParameterToList('EDR_EREC_REQUIRED', l_erecord_required,p_event.Parameter_List); /* eRecord Required*/
2455: --Bug 3761813 : start
2456: wf_event.AddParameterToList('REDLINE_REQUIRED', nvl(l_redline_required,'N'),p_event.Parameter_List); /* redline Required*/

Line 2453: wf_event.AddParameterToList('EDR_SIGN_REQUIRED', l_esign_required,p_event.Parameter_List); /* Signature Required*/

2449: wf_event.AddParameterToList('TEXT_XSLVERSION', l_style_sheet_ver,p_event.Parameter_List); /* Style Sheet*/
2450: wf_event.AddParameterToList('HTML_XSLNAME', NULL,p_event.Parameter_List); /* Style Sheet*/
2451: wf_event.AddParameterToList('HTML_XSLVERSION', NULL,p_event.Parameter_List); /* Style Sheet*/
2452: wf_event.AddParameterToList('APPLICATION_CODE', lower(l_application_code),p_event.Parameter_List); /* Style Sheet*/
2453: wf_event.AddParameterToList('EDR_SIGN_REQUIRED', l_esign_required,p_event.Parameter_List); /* Signature Required*/
2454: wf_event.AddParameterToList('EDR_EREC_REQUIRED', l_erecord_required,p_event.Parameter_List); /* eRecord Required*/
2455: --Bug 3761813 : start
2456: wf_event.AddParameterToList('REDLINE_REQUIRED', nvl(l_redline_required,'N'),p_event.Parameter_List); /* redline Required*/
2457: --Bug 3761813 : END

Line 2454: wf_event.AddParameterToList('EDR_EREC_REQUIRED', l_erecord_required,p_event.Parameter_List); /* eRecord Required*/

2450: wf_event.AddParameterToList('HTML_XSLNAME', NULL,p_event.Parameter_List); /* Style Sheet*/
2451: wf_event.AddParameterToList('HTML_XSLVERSION', NULL,p_event.Parameter_List); /* Style Sheet*/
2452: wf_event.AddParameterToList('APPLICATION_CODE', lower(l_application_code),p_event.Parameter_List); /* Style Sheet*/
2453: wf_event.AddParameterToList('EDR_SIGN_REQUIRED', l_esign_required,p_event.Parameter_List); /* Signature Required*/
2454: wf_event.AddParameterToList('EDR_EREC_REQUIRED', l_erecord_required,p_event.Parameter_List); /* eRecord Required*/
2455: --Bug 3761813 : start
2456: wf_event.AddParameterToList('REDLINE_REQUIRED', nvl(l_redline_required,'N'),p_event.Parameter_List); /* redline Required*/
2457: --Bug 3761813 : END
2458:

Line 2456: wf_event.AddParameterToList('REDLINE_REQUIRED', nvl(l_redline_required,'N'),p_event.Parameter_List); /* redline Required*/

2452: wf_event.AddParameterToList('APPLICATION_CODE', lower(l_application_code),p_event.Parameter_List); /* Style Sheet*/
2453: wf_event.AddParameterToList('EDR_SIGN_REQUIRED', l_esign_required,p_event.Parameter_List); /* Signature Required*/
2454: wf_event.AddParameterToList('EDR_EREC_REQUIRED', l_erecord_required,p_event.Parameter_List); /* eRecord Required*/
2455: --Bug 3761813 : start
2456: wf_event.AddParameterToList('REDLINE_REQUIRED', nvl(l_redline_required,'N'),p_event.Parameter_List); /* redline Required*/
2457: --Bug 3761813 : END
2458:
2459: -- Bug 3161859 : Start
2460: -- this parameter would be used to show whether or not to display

Line 2462: wf_event.AddParameterToList('EDR_CHANGE_SIGNERS', l_change_signer,p_event.Parameter_List); /* Change Signer Required*/

2458:
2459: -- Bug 3161859 : Start
2460: -- this parameter would be used to show whether or not to display
2461: -- the Update Signer button wouuld be enabled or disabled
2462: wf_event.AddParameterToList('EDR_CHANGE_SIGNERS', l_change_signer,p_event.Parameter_List); /* Change Signer Required*/
2463: -- Bug 3161859 : End
2464:
2465: -- Bug 3170251 : Start - Store EREC_TEMPLATE_TYPE in the event parameter list so that its available throughout
2466: -- the rule function and pageflow till the workflow is alive for this event

Line 2467: wf_event.AddParameterToList('EREC_TEMPLATE_TYPE', l_style_sheet_type,p_event.Parameter_List); /* Template Type */

2463: -- Bug 3161859 : End
2464:
2465: -- Bug 3170251 : Start - Store EREC_TEMPLATE_TYPE in the event parameter list so that its available throughout
2466: -- the rule function and pageflow till the workflow is alive for this event
2467: wf_event.AddParameterToList('EREC_TEMPLATE_TYPE', l_style_sheet_type,p_event.Parameter_List); /* Template Type */
2468: -- Bug 3170251 : End
2469:
2470: -- Bug 5158510 :start
2471: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_SIGNATURE_MODE, l_signature_mode,p_event.Parameter_List);

Line 2471: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_SIGNATURE_MODE, l_signature_mode,p_event.Parameter_List);

2467: wf_event.AddParameterToList('EREC_TEMPLATE_TYPE', l_style_sheet_type,p_event.Parameter_List); /* Template Type */
2468: -- Bug 3170251 : End
2469:
2470: -- Bug 5158510 :start
2471: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_SIGNATURE_MODE, l_signature_mode,p_event.Parameter_List);
2472: -- Bug 5158510 :end
2473: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','ECX Parameter set have been set' );
2474:
2475: /* Generate XML Document */

Line 2479: L_XML_GENERATION_API := wf_event.getValueForParameter('XML_GENERATION_API',p_event.Parameter_List);

2475: /* Generate XML Document */
2476: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','Calling ECX Standard package to generate XML' );
2477: -- Bug 3960236 : Start
2478: -- Fetch the payload parameter
2479: L_XML_GENERATION_API := wf_event.getValueForParameter('XML_GENERATION_API',p_event.Parameter_List);
2480:
2481: -- Bug 3960236 : end
2482: --Bug 3667036 : Start
2483: --if event data is not null then don't call XML gateway again

Line 2519: l_attachment_string_details := wf_event.getValueForParameter('EDR_PSIG_ATTACHMENT',p_event.Parameter_List);

2515:
2516: INSERT into edr_erecord_id_temp (document_id) values (l_edr_Event_id);
2517:
2518: --Obtain the attachment string parameter.
2519: l_attachment_string_details := wf_event.getValueForParameter('EDR_PSIG_ATTACHMENT',p_event.Parameter_List);
2520:
2521: --If the attachment string exists then call the attachment API to create the attachments.
2522: if l_attachment_string_details is not null then
2523: EDR_ATTACHMENTS_GRP.ADD_ERP_ATTACH(p_attachment_string => l_attachment_string_details);

Line 2687: wf_event.AddParameterToList

2683: l_voting_regime := 'X';
2684: end if;
2685:
2686: --set the voting regime on the workflow attribute
2687: wf_event.AddParameterToList
2688: ('AME_VOTING_REGIME', l_voting_regime,p_event.Parameter_List);
2689:
2690: end if;
2691: --Bug 4577122: End

Line 2721: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_SIGNATURE_MODE, l_signature_mode,p_event.Parameter_List);

2717: end if;
2718: --Diagnostics End
2719:
2720: l_einitials_defer_mode := 'Y';
2721: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_SIGNATURE_MODE, l_signature_mode,p_event.Parameter_List);
2722: l_approver_count := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_APPROVER_COUNT,p_event.Parameter_List);
2723: l_approver_list := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_APPROVER_LIST,p_event.Parameter_List);
2724:
2725: --If approver_count and approving users are set, then raise an exception.

Line 2722: l_approver_count := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_APPROVER_COUNT,p_event.Parameter_List);

2718: --Diagnostics End
2719:
2720: l_einitials_defer_mode := 'Y';
2721: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_SIGNATURE_MODE, l_signature_mode,p_event.Parameter_List);
2722: l_approver_count := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_APPROVER_COUNT,p_event.Parameter_List);
2723: l_approver_list := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_APPROVER_LIST,p_event.Parameter_List);
2724:
2725: --If approver_count and approving users are set, then raise an exception.
2726: if l_approver_count is not null and l_approver_list is not null then

Line 2723: l_approver_list := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_APPROVER_LIST,p_event.Parameter_List);

2719:
2720: l_einitials_defer_mode := 'Y';
2721: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_SIGNATURE_MODE, l_signature_mode,p_event.Parameter_List);
2722: l_approver_count := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_APPROVER_COUNT,p_event.Parameter_List);
2723: l_approver_list := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_APPROVER_LIST,p_event.Parameter_List);
2724:
2725: --If approver_count and approving users are set, then raise an exception.
2726: if l_approver_count is not null and l_approver_list is not null then
2727: RAISE APPROVING_USERS_PARAMS_ERR;

Line 2766: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_DO_RESPS_EXIST,'Y',p_event.Parameter_List);

2762: approverlist := L_CUSTOM_APPROVER_LIST;
2763:
2764: for l_list_count in 1..approverlist.count loop
2765: if instr(approverlist(l_list_count).name,'#') = 1 then
2766: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_DO_RESPS_EXIST,'Y',p_event.Parameter_List);
2767: l_einitials_defer_mode := 'N';
2768: exit;
2769: end if;
2770: end loop;

Line 2822: l_eres_defer_mode := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_DEFERRED_PARAM,p_event.Parameter_List);

2818: end if;
2819:
2820: --Evaluate the einitials deferred mode variable.
2821: if l_einitials_defer_mode = 'Y' then
2822: l_eres_defer_mode := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_DEFERRED_PARAM,p_event.Parameter_List);
2823: if l_eres_defer_mode is null or l_eres_defer_mode <> 'Y' then
2824: l_einitials_defer_mode := 'N';
2825: end if;
2826: END IF;

Line 2842: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_EINITIALS_DEFER_MODE,l_einitials_defer_mode,p_event.Parameter_List);

2838: end if;
2839: --Diagnostics End
2840:
2841: --Add the e-initials deferred mode variable to the event.
2842: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_EINITIALS_DEFER_MODE,l_einitials_defer_mode,p_event.Parameter_List);
2843: END IF;
2844: --Bug 4160412: End
2845:
2846:

Line 2858: from wf_event_subscriptions

2854: P_EVENT.SETCORRELATIONID(l_edr_event_id);
2855: /* Select the workflow process for the subscription */
2856: select wf_process_type,wf_process_name
2857: into l_wftype, l_wfprocess
2858: from wf_event_subscriptions
2859: where guid = p_subscription_guid;
2860:
2861: wf_event.AddParameterToList('#WF_PAGEFLOW_ITEMTYPE', l_wftype,p_event.Parameter_List); /* Page Flow Workflow type*/
2862: wf_event.AddParameterToList('#WF_PAGEFLOW_ITEMPROCESS', l_wfprocess,p_event.Parameter_List); /* Page Flow Workflow process*/

Line 2861: wf_event.AddParameterToList('#WF_PAGEFLOW_ITEMTYPE', l_wftype,p_event.Parameter_List); /* Page Flow Workflow type*/

2857: into l_wftype, l_wfprocess
2858: from wf_event_subscriptions
2859: where guid = p_subscription_guid;
2860:
2861: wf_event.AddParameterToList('#WF_PAGEFLOW_ITEMTYPE', l_wftype,p_event.Parameter_List); /* Page Flow Workflow type*/
2862: wf_event.AddParameterToList('#WF_PAGEFLOW_ITEMPROCESS', l_wfprocess,p_event.Parameter_List); /* Page Flow Workflow process*/
2863: wf_event.AddParameterToList('#WF_PAGEFLOW_ITEMKEY', l_edr_event_id,p_event.Parameter_List); /* Item Key*/
2864:
2865: /* CAll Page Flow Creation API */

Line 2862: wf_event.AddParameterToList('#WF_PAGEFLOW_ITEMPROCESS', l_wfprocess,p_event.Parameter_List); /* Page Flow Workflow process*/

2858: from wf_event_subscriptions
2859: where guid = p_subscription_guid;
2860:
2861: wf_event.AddParameterToList('#WF_PAGEFLOW_ITEMTYPE', l_wftype,p_event.Parameter_List); /* Page Flow Workflow type*/
2862: wf_event.AddParameterToList('#WF_PAGEFLOW_ITEMPROCESS', l_wfprocess,p_event.Parameter_List); /* Page Flow Workflow process*/
2863: wf_event.AddParameterToList('#WF_PAGEFLOW_ITEMKEY', l_edr_event_id,p_event.Parameter_List); /* Item Key*/
2864:
2865: /* CAll Page Flow Creation API */
2866: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','Calling Page Flow Creation Procedure');

Line 2863: wf_event.AddParameterToList('#WF_PAGEFLOW_ITEMKEY', l_edr_event_id,p_event.Parameter_List); /* Item Key*/

2859: where guid = p_subscription_guid;
2860:
2861: wf_event.AddParameterToList('#WF_PAGEFLOW_ITEMTYPE', l_wftype,p_event.Parameter_List); /* Page Flow Workflow type*/
2862: wf_event.AddParameterToList('#WF_PAGEFLOW_ITEMPROCESS', l_wfprocess,p_event.Parameter_List); /* Page Flow Workflow process*/
2863: wf_event.AddParameterToList('#WF_PAGEFLOW_ITEMKEY', l_edr_event_id,p_event.Parameter_List); /* Item Key*/
2864:
2865: /* CAll Page Flow Creation API */
2866: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','Calling Page Flow Creation Procedure');
2867:

Line 2885: l_child_erecord_ids := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_CHILD_ERECORD_IDS,p_event.Parameter_List);

2881: --Diagnostics End
2882:
2883: --Bug 4122622: Start
2884: --Obtain the value of the comma separated child e-record ID string.
2885: l_child_erecord_ids := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_CHILD_ERECORD_IDS,p_event.Parameter_List);
2886:
2887: --Set the approriate flags based on this value.
2888: if l_child_erecord_ids is not null then
2889: if instr(l_child_erecord_ids,',') > 0 then

Line 2928: wf_event.AddParameterToList('RELATED_ERECORDS',l_url,p_event.Parameter_List);

2924: '&relatedERecordType=CHILD&fromNotifPG=Y&eRecordId='||l_child_erecord_ids;
2925:
2926: end if;
2927:
2928: wf_event.AddParameterToList('RELATED_ERECORDS',l_url,p_event.Parameter_List);
2929:
2930: --Bug 4122622: End;
2931:
2932: l_return_status:= CREATE_PAGEFLOW(p_event_id => l_edr_event_id,

Line 3015: wf_event.setErrorInfo(p_event,SQLERRM || 'ERROR');

3011: return EDR_CONSTANTS_GRP.g_error_status;
3012:
3013: when PAGE_FLOW_FAILED then
3014: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', p_event.getEventName(), p_subscription_guid);
3015: wf_event.setErrorInfo(p_event,SQLERRM || 'ERROR');
3016: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
3017: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
3018: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
3019: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_RULE');

Line 3205: wf_event.setErrorInfo(p_event,SQLERRM || 'ERROR');

3201: --Bug 5724159 :End
3202:
3203: when others then
3204: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', p_event.getEventName(), p_subscription_guid);
3205: wf_event.setErrorInfo(p_event,SQLERRM || 'ERROR');
3206: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
3207: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
3208: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
3209: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_RULE');