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_LOG_PKG

Line 215: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','Event Name Assigned');

211: end if;
212: --Diagnostics End
213:
214: /* Insert into Temp tables for Further Processing */
215: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','Event Name Assigned');
216: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','CLOB Assignment Complete and insert being executed');
217:
218: INSERT INTO EDR_ERECORDS(EVENT_ID,
219: EVENT_NAME,

Line 216: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','CLOB Assignment Complete and insert being executed');

212: --Diagnostics End
213:
214: /* Insert into Temp tables for Further Processing */
215: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','Event Name Assigned');
216: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','CLOB Assignment Complete and insert being executed');
217:
218: INSERT INTO EDR_ERECORDS(EVENT_ID,
219: EVENT_NAME,
220: EVENT_KEY,

Line 246: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','Insertion Complete in EDR_ERECORDS');

242: p_audit_group,
243: l_transaction_audit_id);
244:
245:
246: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','Insertion Complete in EDR_ERECORDS');
247: -- Bug Fix 3143107
248: -- Removed Open Docement
249: -- Post document parameters
250: -- Change status

Line 269: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','Set the Document ID '||l_document_ID ||' as Event Parameter');

265: end if;
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

Line 271: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','Document ID added to event parameters ' );

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*/
275:

Line 279: wf_log_pkg.string(3, 'EDR_PSIG_rule.create_pageflow','Attachments added to event parameters ' );

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
283:

Line 287: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','AME Approver '||P_approverlist(i).occurrence||'-'||l_fnd_user);

283:
284: --Bug 2674799: start
285: --New AME approvers table has the WF Directory name of user.
286: l_fnd_user := P_approverList(i).name;
287: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','AME Approver '||P_approverlist(i).occurrence||'-'||l_fnd_user);
288: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','Figuring out overriding approver for '||l_fnd_user);
289: --Bug 4160412: Start
290: --Find the overriding details only if a user name is provided.
291: if length(l_fnd_user) > 0 and instr(l_fnd_user,'#') = 0 then

Line 288: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','Figuring out overriding approver for '||l_fnd_user);

284: --Bug 2674799: start
285: --New AME approvers table has the WF Directory name of user.
286: l_fnd_user := P_approverList(i).name;
287: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','AME Approver '||P_approverlist(i).occurrence||'-'||l_fnd_user);
288: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','Figuring out overriding approver for '||l_fnd_user);
289: --Bug 4160412: Start
290: --Find the overriding details only if a user name is provided.
291: if length(l_fnd_user) > 0 and instr(l_fnd_user,'#') = 0 then
292: EDR_STANDARD.FIND_WF_NTF_RECIPIENT(l_fnd_user,'EDRPSIGF','PSIG_EREC_MESSAGE_BLAF',

Line 323: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','Figured out overriding approver for '||l_fnd_user||' as '||l_overriding_approver);

319: );
320: end if;
321: --Diagnostics End
322:
323: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','Figured out overriding approver for '||l_fnd_user||' as '||l_overriding_approver);
324:
325: /* Insert into Temp tables for Further Processing */
326: SELECT EDR_ESIGNATURES_S.NEXTVAL into l_edr_signature_id from DUAL;
327: wf_log_pkg.string(3, 'EDR_PSIG_rule.create_pageflow','Signature Sequence Fetched '||l_edr_signature_id);

Line 327: wf_log_pkg.string(3, 'EDR_PSIG_rule.create_pageflow','Signature Sequence Fetched '||l_edr_signature_id);

323: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','Figured out overriding approver for '||l_fnd_user||' as '||l_overriding_approver);
324:
325: /* Insert into Temp tables for Further Processing */
326: SELECT EDR_ESIGNATURES_S.NEXTVAL into l_edr_signature_id from DUAL;
327: wf_log_pkg.string(3, 'EDR_PSIG_rule.create_pageflow','Signature Sequence Fetched '||l_edr_signature_id);
328:
329: INSERT into EDR_ESIGNATURES(SIGNATURE_ID,
330: EVENT_ID,
331: EVENT_NAME,

Line 363: wf_log_pkg.string(3, 'EDR_PSIG_rule.create_pageflow','Insert Complete into EDR_ESIGNATURES');

359: end if;
360: --Diagnostics End
361:
362:
363: wf_log_pkg.string(3, 'EDR_PSIG_rule.create_pageflow','Insert Complete into EDR_ESIGNATURES');
364: wf_log_pkg.string(3, 'EDR_PSIG_rule.create_pageflow','Requesting Signatures in PSIG evidance Store');
365:
366: --Bug 2674799: start
367: --Store the approver order number in EDR_PSIG_DETAILS

Line 364: wf_log_pkg.string(3, 'EDR_PSIG_rule.create_pageflow','Requesting Signatures in PSIG evidance Store');

360: --Diagnostics End
361:
362:
363: wf_log_pkg.string(3, 'EDR_PSIG_rule.create_pageflow','Insert Complete into EDR_ESIGNATURES');
364: wf_log_pkg.string(3, 'EDR_PSIG_rule.create_pageflow','Requesting Signatures in PSIG evidance Store');
365:
366: --Bug 2674799: start
367: --Store the approver order number in EDR_PSIG_DETAILS
368: --Bug 4160412: Start

Line 404: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','PSIG id for' ||l_fnd_user||' is '||l_signature_id);

400: );
401: end if;
402: --Diagnostics End
403:
404: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','PSIG id for' ||l_fnd_user||' is '||l_signature_id);
405:
406: /* Clear the entries */
407: l_overriding_comments:=NULL;
408: l_overriding_approver:=NULL;

Line 415: wf_log_pkg.string(3, 'EDR_PSIG_RULE.create_pageflow','AME Approver list inserted into temp table');

411: end loop;
412:
413: /* END Approver List */
414:
415: wf_log_pkg.string(3, 'EDR_PSIG_RULE.create_pageflow','AME Approver list inserted into temp table');
416: /*call Workflow dEfault Rule funciton */
417:
418: l_return_status:=WF_RULE.DEFAULT_RULE(p_subscription_guid=>p_subscription_guid,p_event=>p_eventP);
419:

Line 432: wf_log_pkg.string(3, 'EDR_PSIG_RULE.create_pageflow','COMMIT Completed in Create pageflow');

428: l_error_msg := p_eventP.GETERRORMESSAGE;
429: RAISE DEFAULT_RULE_ERROR;
430: ELSE
431: COMMIT;
432: wf_log_pkg.string(3, 'EDR_PSIG_RULE.create_pageflow','COMMIT Completed in Create pageflow');
433:
434: --Diagnostics Start
435: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
436: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_SUCCESS_EVT');

Line 506: wf_log_pkg.string(6,'in when others of create_pageflow'||l_error,l_error_msg||substr(l_error_stack,1,100));

502:
503: when others then
504: /* Udate workflow threshold to saved value */
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;

Line 648: wf_log_pkg.string(3, 'EDR_PSIG_RULE.STORE_ERECORD','Start of store erecord');

644: --Diagnostics End
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 */

Line 665: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','open document errored out with code '||l_error);

661: P_ERROR_MSG => l_error_msg);
662: -- Bug 3170251 : End
663:
664: IF l_error is NOT NULL THEN
665: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','open document errored out with code '||l_error);
666: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','open document Error Msg '||l_error_msg);
667: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Opened Document in eRecords Repository with Document ID '||l_document_id);
668: RAISE ERECORD_CREATION_ERROR;
669: END IF;

Line 666: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','open document Error Msg '||l_error_msg);

662: -- Bug 3170251 : End
663:
664: IF l_error is NOT NULL THEN
665: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','open document errored out with code '||l_error);
666: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','open document Error Msg '||l_error_msg);
667: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Opened Document in eRecords Repository with Document ID '||l_document_id);
668: RAISE ERECORD_CREATION_ERROR;
669: END IF;
670:

Line 667: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Opened Document in eRecords Repository with Document ID '||l_document_id);

663:
664: IF l_error is NOT NULL THEN
665: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','open document errored out with code '||l_error);
666: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','open document Error Msg '||l_error_msg);
667: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Opened Document in eRecords Repository with Document ID '||l_document_id);
668: RAISE ERECORD_CREATION_ERROR;
669: END IF;
670:
671: wf_log_pkg.string(3, 'EDR_PSIG_RULE.store_erecord','committing the transaction in store erecord');

Line 671: wf_log_pkg.string(3, 'EDR_PSIG_RULE.store_erecord','committing the transaction in store erecord');

667: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Opened Document in eRecords Repository with Document ID '||l_document_id);
668: RAISE ERECORD_CREATION_ERROR;
669: END IF;
670:
671: wf_log_pkg.string(3, 'EDR_PSIG_RULE.store_erecord','committing the transaction in store erecord');
672: commit;
673:
674: --Diagnostics Start
675: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 689: wf_log_pkg.string(3, 'EDR_PSIG_RULE.store_erecord','REDLINE_REQUIRED'||l_redline_required);

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:
693: -- Bug 3170251 : Start- if EREC_TEMPLATE TYPE isRTF then call EDR_XDOC_UTIL_PKG.GENERATE_ERECORD procedure.

Line 760: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code from PDF e-record generation process: '||l_error);

756: IF l_error = 10 THEN
757: -- This error means either the XSLFO for given template is missing i.e. due to
758: -- approval process missing or converision error OR Template is not uploaded
759: -- in the respective repository.
760: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code from PDF e-record generation process: '||l_error);
761: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg from PDF e-record generation process: '||l_error_msg);
762: RAISE ERECORD_GEN_XSLFOMISS_ERR;
763: END IF;
764:

Line 761: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg from PDF e-record generation process: '||l_error_msg);

757: -- This error means either the XSLFO for given template is missing i.e. due to
758: -- approval process missing or converision error OR Template is not uploaded
759: -- in the respective repository.
760: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code from PDF e-record generation process: '||l_error);
761: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg from PDF e-record generation process: '||l_error_msg);
762: RAISE ERECORD_GEN_XSLFOMISS_ERR;
763: END IF;
764:
765: IF l_error = 20 THEN

Line 766: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code from PDF e-record generation process: '||l_error);

762: RAISE ERECORD_GEN_XSLFOMISS_ERR;
763: END IF;
764:
765: IF l_error = 20 THEN
766: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code from PDF e-record generation process: '||l_error);
767: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg from PDF e-record generation process: '||l_error_msg);
768: RAISE ERECORD_CREATION_ERROR;
769: END IF;
770:

Line 767: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg from PDF e-record generation process: '||l_error_msg);

763: END IF;
764:
765: IF l_error = 20 THEN
766: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code from PDF e-record generation process: '||l_error);
767: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg from PDF e-record generation process: '||l_error_msg);
768: RAISE ERECORD_CREATION_ERROR;
769: END IF;
770:
771: IF l_error = 30 THEN

Line 772: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code from PDF e-record generation process: '||l_error);

768: RAISE ERECORD_CREATION_ERROR;
769: END IF;
770:
771: IF l_error = 30 THEN
772: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code from PDF e-record generation process: '||l_error);
773: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg from PDF e-record generation process: '||l_error_msg);
774: RAISE ERECORD_GEN_FATALERR;
775: END IF;
776:

Line 773: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg from PDF e-record generation process: '||l_error_msg);

769: END IF;
770:
771: IF l_error = 30 THEN
772: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code from PDF e-record generation process: '||l_error);
773: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg from PDF e-record generation process: '||l_error_msg);
774: RAISE ERECORD_GEN_FATALERR;
775: END IF;
776:
777: IF l_error = 40 THEN

Line 778: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code from PDF e-record generation process: '||l_error);

774: RAISE ERECORD_GEN_FATALERR;
775: END IF;
776:
777: IF l_error = 40 THEN
778: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code from PDF e-record generation process: '||l_error);
779: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg from PDF e-record generation process: '||l_error_msg);
780: RAISE ERECORD_GEN_XDOERR;
781: END IF;
782:

Line 779: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg from PDF e-record generation process: '||l_error_msg);

775: END IF;
776:
777: IF l_error = 40 THEN
778: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code from PDF e-record generation process: '||l_error);
779: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg from PDF e-record generation process: '||l_error_msg);
780: RAISE ERECORD_GEN_XDOERR;
781: END IF;
782:
783: IF l_error = 100 THEN

Line 784: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code from PDF e-record generation process: '||l_error);

780: RAISE ERECORD_GEN_XDOERR;
781: END IF;
782:
783: IF l_error = 100 THEN
784: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code from PDF e-record generation process: '||l_error);
785: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg from PDF e-record generation process: '||l_error_msg);
786: RAISE ERECORD_GEN_UNKNWN_ERR;
787: END IF;
788:

Line 785: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg from PDF e-record generation process: '||l_error_msg);

781: END IF;
782:
783: IF l_error = 100 THEN
784: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code from PDF e-record generation process: '||l_error);
785: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg from PDF e-record generation process: '||l_error_msg);
786: RAISE ERECORD_GEN_UNKNWN_ERR;
787: END IF;
788:
789: IF l_error = 505 THEN

Line 790: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code from PDF e-record generation process: '||l_error);

786: RAISE ERECORD_GEN_UNKNWN_ERR;
787: END IF;
788:
789: IF l_error = 505 THEN
790: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code from PDF e-record generation process: '||l_error);
791: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg from PDF e-record generation process: '||l_error_msg);
792: RAISE ERECORD_GEN_JSPMSNG_ERR;
793: END IF;
794:

Line 791: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg from PDF e-record generation process: '||l_error_msg);

787: END IF;
788:
789: IF l_error = 505 THEN
790: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code from PDF e-record generation process: '||l_error);
791: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg from PDF e-record generation process: '||l_error_msg);
792: RAISE ERECORD_GEN_JSPMSNG_ERR;
793: END IF;
794:
795: IF l_error = 500 THEN

Line 796: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code from PDF e-record generation process: '||l_error);

792: RAISE ERECORD_GEN_JSPMSNG_ERR;
793: END IF;
794:
795: IF l_error = 500 THEN
796: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code from PDF e-record generation process: '||l_error);
797: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg from PDF e-record generation process: '||l_error_msg);
798: RAISE ERECORD_GEN_JSPRQFAIL_ERR;
799: END IF;
800:

Line 797: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg from PDF e-record generation process: '||l_error_msg);

793: END IF;
794:
795: IF l_error = 500 THEN
796: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code from PDF e-record generation process: '||l_error);
797: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg from PDF e-record generation process: '||l_error_msg);
798: RAISE ERECORD_GEN_JSPRQFAIL_ERR;
799: END IF;
800:
801: /* Set the E-Record Notification Details to Message for PDF E-Records */

Line 868: wf_log_pkg.string(1, 'EDR_PSIG_RULE.store_erecord',' generate_ERecord for redline. Error '||l_error );

864: x_output_format => l_output_format,
865: x_error_code => l_error,
866: x_error_msg => l_error_msg);
867:
868: wf_log_pkg.string(1, 'EDR_PSIG_RULE.store_erecord',' generate_ERecord for redline. Error '||l_error );
869:
870: wf_log_pkg.string(1, 'EDR_PSIG_RULE.store_erecord',' generate_ERecord for redline. l_error_msg '||l_error_msg );
871:
872: dbms_lob.createtemporary(X_DIFF_XML,TRUE);

Line 870: wf_log_pkg.string(1, 'EDR_PSIG_RULE.store_erecord',' generate_ERecord for redline. l_error_msg '||l_error_msg );

866: x_error_msg => l_error_msg);
867:
868: wf_log_pkg.string(1, 'EDR_PSIG_RULE.store_erecord',' generate_ERecord for redline. Error '||l_error );
869:
870: wf_log_pkg.string(1, 'EDR_PSIG_RULE.store_erecord',' generate_ERecord for redline. l_error_msg '||l_error_msg );
871:
872: dbms_lob.createtemporary(X_DIFF_XML,TRUE);
873: dbms_lob.open( X_DIFF_XML, dbms_lob.lob_readwrite );
874:

Line 889: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Template Type : text ');

885: dbms_lob.close(X_DIFF_XML);
886: dbms_lob.freeTemporary(X_DIFF_XML );
887:
888: IF nvl(l_error,0) <> 0 THEN
889: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Template Type : text ');
890: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code '||l_error);
891: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);
892: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','eRecord generated');
893: RAISE ERECORD_GEN_XSLT_ERR;

Line 890: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code '||l_error);

886: dbms_lob.freeTemporary(X_DIFF_XML );
887:
888: IF nvl(l_error,0) <> 0 THEN
889: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Template Type : text ');
890: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code '||l_error);
891: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);
892: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','eRecord generated');
893: RAISE ERECORD_GEN_XSLT_ERR;
894: END IF;

Line 891: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);

887:
888: IF nvl(l_error,0) <> 0 THEN
889: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Template Type : text ');
890: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code '||l_error);
891: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);
892: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','eRecord generated');
893: RAISE ERECORD_GEN_XSLT_ERR;
894: END IF;
895:

Line 892: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','eRecord generated');

888: IF nvl(l_error,0) <> 0 THEN
889: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Template Type : text ');
890: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code '||l_error);
891: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);
892: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','eRecord generated');
893: RAISE ERECORD_GEN_XSLT_ERR;
894: END IF;
895:
896: IF l_error = 10 THEN

Line 900: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code XSL '||l_error);

896: IF l_error = 10 THEN
897: -- This error means either the XSLFO for given template is missing i.e. due to
898: -- approval process missing or converision error OR Template is not uploaded
899: -- in the respective repository.
900: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code XSL '||l_error);
901: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);
902: RAISE ERECORD_GEN_XSLFOMISS_ERR;
903: END IF;
904:

Line 901: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);

897: -- This error means either the XSLFO for given template is missing i.e. due to
898: -- approval process missing or converision error OR Template is not uploaded
899: -- in the respective repository.
900: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code XSL '||l_error);
901: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);
902: RAISE ERECORD_GEN_XSLFOMISS_ERR;
903: END IF;
904:
905: IF l_error = 20 THEN

Line 906: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code XSL'||l_error);

902: RAISE ERECORD_GEN_XSLFOMISS_ERR;
903: END IF;
904:
905: IF l_error = 20 THEN
906: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code XSL'||l_error);
907: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);
908: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','eRecord generated');
909: RAISE ERECORD_CREATION_ERROR;
910: END IF;

Line 907: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);

903: END IF;
904:
905: IF l_error = 20 THEN
906: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code XSL'||l_error);
907: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);
908: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','eRecord generated');
909: RAISE ERECORD_CREATION_ERROR;
910: END IF;
911:

Line 908: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','eRecord generated');

904:
905: IF l_error = 20 THEN
906: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code XSL'||l_error);
907: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);
908: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','eRecord generated');
909: RAISE ERECORD_CREATION_ERROR;
910: END IF;
911:
912: IF l_error = 30 THEN

Line 913: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code XSL'||l_error);

909: RAISE ERECORD_CREATION_ERROR;
910: END IF;
911:
912: IF l_error = 30 THEN
913: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code XSL'||l_error);
914: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);
915: RAISE ERECORD_GEN_FATALERR;
916: END IF;
917:

Line 914: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);

910: END IF;
911:
912: IF l_error = 30 THEN
913: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code XSL'||l_error);
914: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);
915: RAISE ERECORD_GEN_FATALERR;
916: END IF;
917:
918: IF l_error = 40 THEN

Line 919: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error CodeXSL '||l_error);

915: RAISE ERECORD_GEN_FATALERR;
916: END IF;
917:
918: IF l_error = 40 THEN
919: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error CodeXSL '||l_error);
920: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);
921: RAISE ERECORD_GEN_XDOERR;
922: END IF;
923:

Line 920: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);

916: END IF;
917:
918: IF l_error = 40 THEN
919: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error CodeXSL '||l_error);
920: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);
921: RAISE ERECORD_GEN_XDOERR;
922: END IF;
923:
924: IF l_error = 100 THEN

Line 925: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code XSL'||l_error);

921: RAISE ERECORD_GEN_XDOERR;
922: END IF;
923:
924: IF l_error = 100 THEN
925: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code XSL'||l_error);
926: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);
927: RAISE ERECORD_GEN_UNKNWN_ERR;
928: END IF;
929:

Line 926: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);

922: END IF;
923:
924: IF l_error = 100 THEN
925: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code XSL'||l_error);
926: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);
927: RAISE ERECORD_GEN_UNKNWN_ERR;
928: END IF;
929:
930: IF l_error = 505 THEN

Line 931: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code XSL'||l_error);

927: RAISE ERECORD_GEN_UNKNWN_ERR;
928: END IF;
929:
930: IF l_error = 505 THEN
931: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code XSL'||l_error);
932: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);
933: RAISE ERECORD_GEN_JSPMSNG_ERR;
934: END IF;
935:

Line 932: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);

928: END IF;
929:
930: IF l_error = 505 THEN
931: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code XSL'||l_error);
932: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);
933: RAISE ERECORD_GEN_JSPMSNG_ERR;
934: END IF;
935:
936: IF l_error = 500 THEN

Line 937: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code XSL'||l_error);

933: RAISE ERECORD_GEN_JSPMSNG_ERR;
934: END IF;
935:
936: IF l_error = 500 THEN
937: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code XSL'||l_error);
938: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);
939: RAISE ERECORD_GEN_JSPRQFAIL_ERR;
940: END IF;
941: END IF;

Line 938: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);

934: END IF;
935:
936: IF l_error = 500 THEN
937: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code XSL'||l_error);
938: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg '||l_error_msg);
939: RAISE ERECORD_GEN_JSPRQFAIL_ERR;
940: END IF;
941: END IF;
942: --Bug 4306292: End

Line 961: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','XSL Transformation Error Code '||l_error);

957: -- so for consistency we pass the text/plain document format.
958: l_output_format := WF_NOTIFICATION.doc_text;
959: -- Bug 4862464: End
960: IF nvl(l_error,0) <> 0 THEN
961: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','XSL Transformation Error Code '||l_error);
962: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','XSL Transformation Error Msg '||l_error_msg);
963: RAISE ERECORD_GEN_XSLT_ERR;
964: END IF;
965:

Line 962: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','XSL Transformation Error Msg '||l_error_msg);

958: l_output_format := WF_NOTIFICATION.doc_text;
959: -- Bug 4862464: End
960: IF nvl(l_error,0) <> 0 THEN
961: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','XSL Transformation Error Code '||l_error);
962: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','XSL Transformation Error Msg '||l_error_msg);
963: RAISE ERECORD_GEN_XSLT_ERR;
964: END IF;
965:
966: --Diagnostics Start

Line 985: wf_log_pkg.string(5, 'EDR_PSIG_RULE.store_erecord','Wrong Stylesheet Type ' || l_style_sheet_type );

981:
982:
983: -- Check if template type is one of the valid types.
984: IF ((UPPER(l_style_sheet_type) <> 'XSL') AND (UPPER(l_style_sheet_type) <> 'RTF')) THEN
985: wf_log_pkg.string(5, 'EDR_PSIG_RULE.store_erecord','Wrong Stylesheet Type ' || l_style_sheet_type );
986: RAISE ERECORD_UNKWN_TMPL_TYPE;
987: END IF;
988:
989: /* Get Payload Attributes required by Rule function */

Line 996: wf_log_pkg.string(3, 'EDR_PSIG_RULE.store_erecord','Posting Document in eRecords Repository');

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:
998: EDR_PSIG.updateDocument(P_DOCUMENT_ID => l_document_id,
999: P_PSIG_XML => L_XML_DOCUMENT,
1000: P_PSIG_DOCUMENT => L_EREC_OUTPUT,

Line 1010: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code during update document '||l_error);

1006: P_WF_NID => NULL,
1007: P_ERROR => l_error,
1008: P_ERROR_MSG => l_error_msg);
1009: IF l_error is NOT NULL THEN
1010: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code during update document '||l_error);
1011: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg during update document '||l_error_msg);
1012: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Updated Document in eRecords Repository with Document ID '||l_document_id);
1013: RAISE ERECORD_CREATION_ERROR;
1014: END IF;

Line 1011: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg during update document '||l_error_msg);

1007: P_ERROR => l_error,
1008: P_ERROR_MSG => l_error_msg);
1009: IF l_error is NOT NULL THEN
1010: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code during update document '||l_error);
1011: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg during update document '||l_error_msg);
1012: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Updated Document in eRecords Repository with Document ID '||l_document_id);
1013: RAISE ERECORD_CREATION_ERROR;
1014: END IF;
1015:

Line 1012: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Updated Document in eRecords Repository with Document ID '||l_document_id);

1008: P_ERROR_MSG => l_error_msg);
1009: IF l_error is NOT NULL THEN
1010: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code during update document '||l_error);
1011: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg during update document '||l_error_msg);
1012: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Updated Document in eRecords Repository with Document ID '||l_document_id);
1013: RAISE ERECORD_CREATION_ERROR;
1014: END IF;
1015:
1016: --Diagnostics Start

Line 1038: wf_log_pkg.string(1, 'EDR_PSIG_RULE.store_erecord','Before Moving attachments from Temp entity to eRecord '

1034: update fnd_attached_documents
1035: set pk1_value = l_document_id
1036: where entity_name = EDR_CONSTANTS_GRP.g_erecord_entity_name
1037: and pk1_value = p_edr_event_id; */
1038: wf_log_pkg.string(1, 'EDR_PSIG_RULE.store_erecord','Before Moving attachments from Temp entity to eRecord '
1039: ||'from '||p_edr_event_id||' to '||l_document_id);
1040:
1041: --Bug 4381237: Start
1042: --Change the call to EDR attachment API

Line 1067: wf_log_pkg.string(3, 'EDR_PSIG_RULE.store_erecord','After Moving attachments from Temp entity to eRecord '

1063: X_automatically_added_flag => 'N',
1064: X_from_category_id => null,
1065: X_to_category_id => null);
1066:
1067: wf_log_pkg.string(3, 'EDR_PSIG_RULE.store_erecord','After Moving attachments from Temp entity to eRecord '
1068: ||'from '||p_edr_event_id||' to '||l_document_id);
1069:
1070: wf_log_pkg.string(1, 'EDR_PSIG_RULE.store_erecord','Before Deleting attachments from Temp entity '
1071: ||'from '||p_edr_event_id);

Line 1070: wf_log_pkg.string(1, 'EDR_PSIG_RULE.store_erecord','Before Deleting attachments from Temp entity '

1066:
1067: wf_log_pkg.string(3, 'EDR_PSIG_RULE.store_erecord','After Moving attachments from Temp entity to eRecord '
1068: ||'from '||p_edr_event_id||' to '||l_document_id);
1069:
1070: wf_log_pkg.string(1, 'EDR_PSIG_RULE.store_erecord','Before Deleting attachments from Temp entity '
1071: ||'from '||p_edr_event_id);
1072:
1073:
1074: -- Bug 3863541 : Start

Line 1096: wf_log_pkg.string(3, 'EDR_PSIG_RULE.store_erecord','After Deleting attachments from Temp entity '

1092: --Bug 4381237: End
1093: X_automatically_added_flag => 'N');
1094: --Bug 3863541 : End
1095:
1096: wf_log_pkg.string(3, 'EDR_PSIG_RULE.store_erecord','After Deleting attachments from Temp entity '
1097: ||'from '||p_edr_event_id);
1098:
1099:
1100: --Diagnostics Start

Line 1120: wf_log_pkg.string(1, 'EDR_PSIG_RULE.store_erecord','eRecord Id added to payload: '||l_document_id);

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:
1122: --ER # 2966866 end
1123: /* Add Document Parameters */
1124: l_params(1).param_name:='PSIG_USER_KEY_LABEL';

Line 1163: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Posting Document Parameters');

1159: l_params(5).param_value := 'FND:entity=ERECORD'||'&'||'pk1name=DOCUMENT_ID'||'&'||'pk1value='||l_document_id;
1160:
1161: --Bug 4755255: End
1162:
1163: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Posting Document Parameters');
1164:
1165: EDR_PSIG.POSTDOCUMENTPARAMETER(P_DOCUMENT_ID => l_document_id,
1166: P_PARAMETERS => l_params,
1167: P_ERROR => l_error,

Line 1171: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code during posting doc params '||l_error);

1167: P_ERROR => l_error,
1168: P_ERROR_MSG => l_error_msg);
1169:
1170: IF l_error is NOT NULL THEN
1171: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code during posting doc params '||l_error);
1172: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg during posting doc params '||l_error_msg);
1173: RAISE ERECORD_PARAM_ERROR;
1174: END IF;
1175:

Line 1172: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg during posting doc params '||l_error_msg);

1168: P_ERROR_MSG => l_error_msg);
1169:
1170: IF l_error is NOT NULL THEN
1171: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code during posting doc params '||l_error);
1172: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Msg during posting doc params '||l_error_msg);
1173: RAISE ERECORD_PARAM_ERROR;
1174: END IF;
1175:
1176: --Diagnostics Start

Line 1199: wf_log_pkg.string(3, 'EDR_PSIG_RULE.store_erecord','Document Closed');

1195: --Bug 4150616: End
1196: EDR_PSIG.closeDocument(P_DOCUMENT_ID => l_document_id,
1197: P_ERROR => l_error,
1198: P_ERROR_MSG => l_error_msg);
1199: wf_log_pkg.string(3, 'EDR_PSIG_RULE.store_erecord','Document Closed');
1200:
1201: ELSIF p_esign_required = 'Y' THEN
1202: EDR_PSIG.CHANGEDOCUMENTSTATUS(P_DOCUMENT_ID => l_document_id,
1203: P_STATUS => 'ERROR',

Line 1206: wf_log_pkg.string(3, 'EDR_PSIG_RULE.store_erecord','Changed Document Status to an Intermediate Status');

1202: EDR_PSIG.CHANGEDOCUMENTSTATUS(P_DOCUMENT_ID => l_document_id,
1203: P_STATUS => 'ERROR',
1204: P_ERROR => L_ERROR,
1205: P_ERROR_MSG => l_error_msg);
1206: wf_log_pkg.string(3, 'EDR_PSIG_RULE.store_erecord','Changed Document Status to an Intermediate Status');
1207: END IF;
1208: -- END Bug Fix 3143107
1209:
1210: -- If everything went fine, commiting the ERECORD Contents by commiting this autonomous transaction

Line 1226: wf_log_pkg.string(3, 'EDR_PSIG_RULE.store_erecord','Store_erecord completed successfully');

1222: );
1223: end if;
1224: --Diagnostics End
1225:
1226: wf_log_pkg.string(3, 'EDR_PSIG_RULE.store_erecord','Store_erecord completed successfully');
1227:
1228: EXCEPTION
1229: when ERECORD_GENERATION_ERROR then
1230: ROLLBACK;

Line 1309: wf_log_pkg.string(5, 'EDR_PSIG_RULE.store_erecord','There is a fatal error during e-record creation using XDO API');

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');
1312: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1313: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');

Line 1742: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','Start of the rule function');

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
1745: IF l_eres_profile_value = 'Y' OR l_force_erecord = 'Y' THEN
1746: --Bug 4150616: End

Line 1758: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','AME transaction Type :'||l_ame_transaction_type );

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 );
1759:
1760: --Diagnostics Start
1761: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1762: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_START_EVT');

Line 1777: wf_log_pkg.string(1, 'EDR_PSIG_rule.psig_rule','Parent Event Name:'||l_parent_event);

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

Line 1782: wf_log_pkg.string(1, 'EDR_PSIG_rule.psig_rule','Parent Event Key:'||l_parent_key);

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
1785: l_parent_erecord_id := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_parent_erecord_id,p_event.Parameter_List);
1786:

Line 1787: wf_log_pkg.string(1, 'EDR_PSIG_rule.psig_rule','Parent eRecord ID:'||l_parent_erecord_id);

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
1790: --to make it an inter event. either the parent event name AND parent event
1791: --key have to be passed in the payload OR all three, to make this an inter

Line 1809: wf_log_pkg.string(1, 'EDR_PSIG_rule.psig_rule','Inter Event Mode: '||l_inter_event_mode);

1805: l_inter_event_mode := 'N';
1806:
1807: END IF;
1808:
1809: wf_log_pkg.string(1, 'EDR_PSIG_rule.psig_rule','Inter Event Mode: '||l_inter_event_mode);
1810:
1811: if (l_inter_event_mode = 'Y') then
1812: --Diagnostics Start
1813: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1905: wf_log_pkg.string(1, 'EDR_PSIG_rule.psig_rule','Relationship between parent and child:'||l_relationship);

1901: );
1902: end if;
1903: --Diagnostics End
1904:
1905: wf_log_pkg.string(1, 'EDR_PSIG_rule.psig_rule','Relationship between parent and child:'||l_relationship);
1906:
1907: --l_relationship can have three possible values
1908: --EVALUATE_NORMAL, IGNORE_SIGNATURE, ERECORD_ONLY
1909: end if;

Line 1942: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Application_id :'||l_application_id );

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 );
1943: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','event key :'||P_EVENT.getEventKey( ));
1944: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Trans Type :'||NVL(l_ame_transaction_type,P_EVENT.getEventName( )) );
1945:
1946: /* AME Enhancement Code. Determine if singature is need or not and also get approvers */

Line 1943: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','event key :'||P_EVENT.getEventKey( ));

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 );
1943: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','event key :'||P_EVENT.getEventKey( ));
1944: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Trans Type :'||NVL(l_ame_transaction_type,P_EVENT.getEventName( )) );
1945:
1946: /* AME Enhancement Code. Determine if singature is need or not and also get approvers */
1947: -- if the inter event mode is on and the relationship is ERECORD_ONLY then

Line 1944: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Trans Type :'||NVL(l_ame_transaction_type,P_EVENT.getEventName( )) );

1940: AND B.NAME=P_EVENT.getEventName( );
1941:
1942: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Application_id :'||l_application_id );
1943: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','event key :'||P_EVENT.getEventKey( ));
1944: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Trans Type :'||NVL(l_ame_transaction_type,P_EVENT.getEventName( )) );
1945:
1946: /* AME Enhancement Code. Determine if singature is need or not and also get approvers */
1947: -- if the inter event mode is on and the relationship is ERECORD_ONLY then
1948: -- also we need to go to AME to get the transaction type

Line 1994: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','eRecord id: '||l_edr_Event_id||' will be sent to ECX');

1990: delete edr_erecord_id_temp;
1991:
1992: SELECT EDR_ERECORDS_S.NEXTVAL into l_edr_Event_id from DUAL;
1993: INSERT into edr_erecord_id_temp (document_id) values (l_edr_Event_id);
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),

Line 2013: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','ecx inbound trig called');

2009: i_log_file => l_log_file,
2010: o_payload => l_erecord_data
2011: );
2012:
2013: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','ecx inbound trig called');
2014:
2015: --If it is set to 'N' then do not perform the XML to XML transformation.
2016: --Take the source XML as the target itself.
2017: elsif l_transform_xml = 'N' then

Line 2027: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','no ecx transformation required');

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:
2027: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','no ecx transformation required');
2028: else
2029: raise TRANSFORM_XML_VAR_ERROR;
2030: end if;
2031: --Bug 3893101: End

Line 2080: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','updated edr_final_xml_gt with the final xml');

2076: set event_xml = l_erecord_data
2077: where event_name = l_event_name
2078: and event_key = l_event_key;
2079:
2080: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','updated edr_final_xml_gt with the final xml');
2081: else
2082: --Diagnostics Start
2083: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2084: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_DATA_SOURCE_EVT');

Line 2105: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','no need to find out approvers form ame as interevent relationship forces erecord_only');

2101:
2102: -- Bug 2674799 : start
2103: if (l_inter_event_mode = 'Y' and l_relationship = EDR_CONSTANTS_GRP.g_erecord_only) then
2104: l_trans_value_only := 'Y';
2105: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','no need to find out approvers form ame as interevent relationship forces erecord_only');
2106: else
2107: EDR_UTILITIES.GET_APPROVERS(P_APPLICATION_ID => l_application_id,
2108: P_TRANSACTION_ID => p_event.getEventKey(),
2109: P_TRANSACTION_TYPE => NVL(l_ame_transaction_type,p_event.getEventName()),

Line 2113: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','called ame to get the approvers');

2109: P_TRANSACTION_TYPE => NVL(l_ame_transaction_type,p_event.getEventName()),
2110: X_approvers => approverList,
2111: X_rule_Ids => l_ruleids,
2112: X_rule_Descriptions => l_rulenames);
2113: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','called ame to get the approvers');
2114: END IF ;
2115: -- Bug 2674799: end
2116:
2117: -- Bug 4126932 : END

Line 2122: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','AME API Called. Total Approver '||approverlist.count);

2118:
2119: --clean up temp table
2120: delete from EDR_FINAL_XML_GT where event_name = l_event_name and event_key=l_event_key;
2121:
2122: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','AME API Called. Total Approver '||approverlist.count);
2123:
2124: -- get the Application Name
2125: select ltrim(rtrim(application_name)) into l_application_name
2126: from ame_Calling_Apps

Line 2270: wf_log_pkg.string(3, 'EDR_PSIG_rule.psig_rule','Get Only the input variables at txn level');

2266: -- event1=ERECORD_ONLY then we need to capture eRecord unconditionaly
2267: -- by setting l_erecord_required = 'Y' we will achieve this.
2268: --
2269: l_erecord_required := 'Y';
2270: wf_log_pkg.string(3, 'EDR_PSIG_rule.psig_rule','Get Only the input variables at txn level');
2271: end if;
2272: --ER # 2966866 end
2273:
2274: for i in 1..l_ruleids.count loop

Line 2283: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Rule_id: '||l_ruleids(i)||' Rule '||l_rulenames(i));

2279: else
2280: l_rule_id := l_ruleids(i);
2281: end if;
2282:
2283: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Rule_id: '||l_ruleids(i)||' Rule '||l_rulenames(i));
2284:
2285: -- Bug 3214495 : Start
2286:
2287: EDR_STANDARD.GET_AMERULE_INPUT_VARIABLES( transactiontypeid =>NVL(l_ame_transaction_type,P_EVENT.getEventName( )),

Line 2294: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','Total Input Values '||l_rulevalues.count );

2290: ameruleinputvalues=>l_rulevalues);
2291:
2292: -- Bug 3214495 : End
2293:
2294: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','Total Input Values '||l_rulevalues.count );
2295: if l_rulevalues.count > 0 then
2296: for i in 1..l_rulevalues.count loop
2297: if l_rulevalues(i).input_name = 'ESIG_REQUIRED' then
2298: l_rule_esign_required:=upper(l_rulevalues(i).input_value);

Line 2356: wf_log_pkg.string(3, 'EDR_PSIG_rule.psig_rule','Force Ereocrd setting style sheet and version');

2352: --Start Bug 5158772
2353: IF l_force_erecord = 'Y' then
2354: l_style_sheet := l_temp_style_sheet;
2355: l_style_sheet_ver := l_temp_style_sheet_ver;
2356: wf_log_pkg.string(3, 'EDR_PSIG_rule.psig_rule','Force Ereocrd setting style sheet and version');
2357: end if;
2358: --End Bug 5158772
2359: end loop;
2360:

Line 2377: wf_log_pkg.string(3, 'EDR_PSIG_rule.psig_rule','Inter Event Mode and No eSignature');

2373: l_style_sheet := l_temp_style_sheet;
2374: l_style_sheet_ver := l_temp_style_sheet_ver;
2375: -- Bug : 3499326 - end
2376:
2377: wf_log_pkg.string(3, 'EDR_PSIG_rule.psig_rule','Inter Event Mode and No eSignature');
2378: end if;
2379: --ER # 2966866 end
2380:
2381:

Line 2388: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Signature Required :'||l_esign_required);

2384: L_STYLE_SHEET_TYPE := UPPER(SUBSTR(L_STYLE_SHEET,LENGTH(L_STYLE_SHEET)-2,LENGTH(L_STYLE_SHEET)));
2385: -- Bug 3456399 : End
2386: --Bug: 3170251 : End
2387:
2388: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Signature Required :'||l_esign_required);
2389: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','eRecord Required :'||l_erecord_required);
2390: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Style Sheet :'||l_style_sheet);
2391: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','StyleSheet Version :'||l_style_sheet_ver);
2392: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','StyleSheet repository :'||l_style_sheet_repository);

Line 2389: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','eRecord Required :'||l_erecord_required);

2385: -- Bug 3456399 : End
2386: --Bug: 3170251 : End
2387:
2388: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Signature Required :'||l_esign_required);
2389: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','eRecord Required :'||l_erecord_required);
2390: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Style Sheet :'||l_style_sheet);
2391: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','StyleSheet Version :'||l_style_sheet_ver);
2392: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','StyleSheet repository :'||l_style_sheet_repository);
2393:

Line 2390: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Style Sheet :'||l_style_sheet);

2386: --Bug: 3170251 : End
2387:
2388: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Signature Required :'||l_esign_required);
2389: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','eRecord Required :'||l_erecord_required);
2390: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Style Sheet :'||l_style_sheet);
2391: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','StyleSheet Version :'||l_style_sheet_ver);
2392: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','StyleSheet repository :'||l_style_sheet_repository);
2393:
2394: --Diagnostics Start

Line 2391: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','StyleSheet Version :'||l_style_sheet_ver);

2387:
2388: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Signature Required :'||l_esign_required);
2389: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','eRecord Required :'||l_erecord_required);
2390: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Style Sheet :'||l_style_sheet);
2391: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','StyleSheet Version :'||l_style_sheet_ver);
2392: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','StyleSheet repository :'||l_style_sheet_repository);
2393:
2394: --Diagnostics Start
2395: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2392: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','StyleSheet repository :'||l_style_sheet_repository);

2388: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Signature Required :'||l_esign_required);
2389: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','eRecord Required :'||l_erecord_required);
2390: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Style Sheet :'||l_style_sheet);
2391: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','StyleSheet Version :'||l_style_sheet_ver);
2392: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','StyleSheet repository :'||l_style_sheet_repository);
2393:
2394: --Diagnostics Start
2395: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2396: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_PARAM_LIST_EVT');

Line 2436: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','XML Map Code :'||l_xml_map_code );

2432:
2433: l_audit_group := NVL(wf_event.getValueForParameter('EDR_AUDIT_GROUP',p_event.Parameter_List),
2434: P_EVENT.getEventName( ));
2435:
2436: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','XML Map Code :'||l_xml_map_code );
2437: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Audit Group :'||l_audit_group );
2438: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Setting ECX parameter');
2439:
2440: /* Set Additional Parameters required by Esignature */

Line 2437: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Audit Group :'||l_audit_group );

2433: l_audit_group := NVL(wf_event.getValueForParameter('EDR_AUDIT_GROUP',p_event.Parameter_List),
2434: P_EVENT.getEventName( ));
2435:
2436: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','XML Map Code :'||l_xml_map_code );
2437: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Audit Group :'||l_audit_group );
2438: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Setting ECX parameter');
2439:
2440: /* Set Additional Parameters required by Esignature */
2441: /* wf_event.AddParameterToList('SUB_GUID', p_subscription_guid,p_event.Parameter_List); Subscription ID */

Line 2438: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Setting ECX parameter');

2434: P_EVENT.getEventName( ));
2435:
2436: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','XML Map Code :'||l_xml_map_code );
2437: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Audit Group :'||l_audit_group );
2438: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Setting ECX parameter');
2439:
2440: /* Set Additional Parameters required by Esignature */
2441: /* wf_event.AddParameterToList('SUB_GUID', p_subscription_guid,p_event.Parameter_List); Subscription ID */
2442: wf_event.AddParameterToList('ECX_MAP_CODE', l_xml_map_code,p_event.Parameter_List); /* XML Map Code*/

Line 2469: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','ECX Parameter set have been set' );

2465:
2466: -- Bug 5158510 :start
2467: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_SIGNATURE_MODE, l_signature_mode,p_event.Parameter_List);
2468: -- Bug 5158510 :end
2469: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','ECX Parameter set have been set' );
2470:
2471: /* Generate XML Document */
2472: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','Calling ECX Standard package to generate XML' );
2473: -- Bug 3960236 : Start

Line 2472: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','Calling ECX Standard package to generate XML' );

2468: -- Bug 5158510 :end
2469: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','ECX Parameter set have been set' );
2470:
2471: /* Generate XML Document */
2472: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','Calling ECX Standard package to generate XML' );
2473: -- Bug 3960236 : Start
2474: -- Fetch the payload parameter
2475: L_XML_GENERATION_API := wf_event.getValueForParameter('XML_GENERATION_API',p_event.Parameter_List);
2476:

Line 2544: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','After Calling Snapshot to generate XML'||P_EVENT.getEventKey( ));

2540: --Commenting changes made for red lining.
2541:
2542: if ( nvl(l_redline_required,'N') = 'Y') then
2543: l_snapstatus:= PRE_TX_SNAPSHOT(l_edr_Event_id,l_xml_map_code,P_EVENT.getEventKey());
2544: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','After Calling Snapshot to generate XML'||P_EVENT.getEventKey( ));
2545: END IF;
2546: --Bug 4306292: End
2547: -- Bug 3761813 : end
2548:

Line 2550: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','eRecord id: '||l_edr_Event_id||' has been sent to ECX');

2546: --Bug 4306292: End
2547: -- Bug 3761813 : end
2548:
2549: INSERT into edr_erecord_id_temp (document_id) values (l_edr_Event_id);
2550: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','eRecord id: '||l_edr_Event_id||' has been sent to ECX');
2551:
2552: L_XML_DOCUMENT:=ECX_STANDARD.GENERATE(p_event_name => P_EVENT.getEventName(),
2553: p_event_key => P_EVENT.getEventKey(),
2554: p_parameter_list => p_event.Parameter_List);

Line 2573: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','XML Document Generated' );

2569:
2570: end if;
2571: --Bug 3667036 : End
2572:
2573: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','XML Document Generated' );
2574:
2575: --Bug 5724159 :Start
2576: --When the number of approvers is 0,Adhoc signer capability is ALL or ADHOC and the
2577: --Signature mode is SHORT,Error message needs to displayed. E-Record will not be captured in this scenario.

Line 2631: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','XML Document Set to event Data' );

2627: end if;
2628: --Bug 4306292: End
2629: --Bug 3761813 : end
2630:
2631: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','XML Document Set to event Data' );
2632:
2633: /* GET Approver List.
2634: ame_api.getAllApprovers(applicationIdIn=>l_application_Id,
2635: transactionIdIn=>P_EVENT.getEventKey( ),

Line 2862: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','Calling Page Flow Creation Procedure');

2858: wf_event.AddParameterToList('#WF_PAGEFLOW_ITEMPROCESS', l_wfprocess,p_event.Parameter_List); /* Page Flow Workflow process*/
2859: wf_event.AddParameterToList('#WF_PAGEFLOW_ITEMKEY', l_edr_event_id,p_event.Parameter_List); /* Item Key*/
2860:
2861: /* CAll Page Flow Creation API */
2862: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','Calling Page Flow Creation Procedure');
2863:
2864: --Diagnostics Start
2865: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2866: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_WF_PARAMS_EVT');

Line 2937: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','Page Flow Returned '||l_return_status);

2933: p_subscription_guid => p_subscription_guid,
2934: P_approverlist => approverList,
2935: P_ERR_CODE => l_error,
2936: P_ERR_MSG => l_error_msg);
2937: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','Page Flow Returned '||l_return_status);
2938:
2939: IF l_return_status = 'ERROR' OR L_ERROR is not null then
2940: raise PAGE_FLOW_FAILED;
2941: ELSE