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 dependencies on FND_MESSAGE

Line 40: fnd_message.set_name('EDR','EDR_PSIG_TIMEZONE_ERROR');

36:
37: /* Bug Fix 3225490 . Added new or condition to check null value for edr_timezone */
38: IF (l_edr_timezone <> l_server_timezone) or (l_server_timezone is NULL) or (l_edr_timezone is NULL) THEN
39: /*end of bug fix 3225490 */
40: fnd_message.set_name('EDR','EDR_PSIG_TIMEZONE_ERROR');
41: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_TIMEZONE_ERROR');
42: X_ERROR_MSG:= fnd_message.get();
43: X_TIMEZONE:=NULL;
44: END IF;

Line 41: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_TIMEZONE_ERROR');

37: /* Bug Fix 3225490 . Added new or condition to check null value for edr_timezone */
38: IF (l_edr_timezone <> l_server_timezone) or (l_server_timezone is NULL) or (l_edr_timezone is NULL) THEN
39: /*end of bug fix 3225490 */
40: fnd_message.set_name('EDR','EDR_PSIG_TIMEZONE_ERROR');
41: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_TIMEZONE_ERROR');
42: X_ERROR_MSG:= fnd_message.get();
43: X_TIMEZONE:=NULL;
44: END IF;
45: X_TIMEZONE := L_EDR_TIMEZONE;

Line 42: X_ERROR_MSG:= fnd_message.get();

38: IF (l_edr_timezone <> l_server_timezone) or (l_server_timezone is NULL) or (l_edr_timezone is NULL) THEN
39: /*end of bug fix 3225490 */
40: fnd_message.set_name('EDR','EDR_PSIG_TIMEZONE_ERROR');
41: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_TIMEZONE_ERROR');
42: X_ERROR_MSG:= fnd_message.get();
43: X_TIMEZONE:=NULL;
44: END IF;
45: X_TIMEZONE := L_EDR_TIMEZONE;
46: END VERIFY_TIMEZONE;

Line 69: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');

65: END IF;
66: CLOSE C1;
67: EXCEPTION
68: WHEN DOCUMENT_NOT_FOUND THEN
69: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');
70: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');
71: X_ERROR_MSG:= fnd_message.get();
72: CLOSE c1;
73: WHEN OTHERS then

Line 70: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');

66: CLOSE C1;
67: EXCEPTION
68: WHEN DOCUMENT_NOT_FOUND THEN
69: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');
70: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');
71: X_ERROR_MSG:= fnd_message.get();
72: CLOSE c1;
73: WHEN OTHERS then
74: X_ERROR:=SQLCODE;

Line 71: X_ERROR_MSG:= fnd_message.get();

67: EXCEPTION
68: WHEN DOCUMENT_NOT_FOUND THEN
69: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');
70: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');
71: X_ERROR_MSG:= fnd_message.get();
72: CLOSE c1;
73: WHEN OTHERS then
74: X_ERROR:=SQLCODE;
75: X_ERROR_MSG:=SQLERRM;

Line 96: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNATURE');

92: END IF;
93: CLOSE C1;
94: EXCEPTION
95: WHEN DOCUMENT_NOT_FOUND THEN
96: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNATURE');
97: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNATURE');
98: X_ERROR_MSG:= fnd_message.get();
99: CLOSE c1;
100: WHEN OTHERS then

Line 97: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNATURE');

93: CLOSE C1;
94: EXCEPTION
95: WHEN DOCUMENT_NOT_FOUND THEN
96: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNATURE');
97: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNATURE');
98: X_ERROR_MSG:= fnd_message.get();
99: CLOSE c1;
100: WHEN OTHERS then
101: X_ERROR:=SQLCODE;

Line 98: X_ERROR_MSG:= fnd_message.get();

94: EXCEPTION
95: WHEN DOCUMENT_NOT_FOUND THEN
96: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNATURE');
97: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNATURE');
98: X_ERROR_MSG:= fnd_message.get();
99: CLOSE c1;
100: WHEN OTHERS then
101: X_ERROR:=SQLCODE;
102: X_ERROR_MSG:=SQLERRM;

Line 126: fnd_message.set_name('EDR','EDR_PSIG_INVALID_USER');

122: RAISE EDR_INVALID_USER;
123: END IF;
124: EXCEPTION
125: WHEN EDR_INVALID_USER THEN
126: fnd_message.set_name('EDR','EDR_PSIG_INVALID_USER');
127: fnd_message.set_token('USER',P_USER);
128: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_USER');
129: X_ERROR_MSG:= fnd_message.get();
130:

Line 127: fnd_message.set_token('USER',P_USER);

123: END IF;
124: EXCEPTION
125: WHEN EDR_INVALID_USER THEN
126: fnd_message.set_name('EDR','EDR_PSIG_INVALID_USER');
127: fnd_message.set_token('USER',P_USER);
128: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_USER');
129: X_ERROR_MSG:= fnd_message.get();
130:
131: WHEN OTHERS then

Line 128: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_USER');

124: EXCEPTION
125: WHEN EDR_INVALID_USER THEN
126: fnd_message.set_name('EDR','EDR_PSIG_INVALID_USER');
127: fnd_message.set_token('USER',P_USER);
128: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_USER');
129: X_ERROR_MSG:= fnd_message.get();
130:
131: WHEN OTHERS then
132: X_ERROR:=SQLCODE;

Line 129: X_ERROR_MSG:= fnd_message.get();

125: WHEN EDR_INVALID_USER THEN
126: fnd_message.set_name('EDR','EDR_PSIG_INVALID_USER');
127: fnd_message.set_token('USER',P_USER);
128: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_USER');
129: X_ERROR_MSG:= fnd_message.get();
130:
131: WHEN OTHERS then
132: X_ERROR:=SQLCODE;
133: X_ERROR_MSG:=SQLERRM;

Line 428: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_DOCFORMAT');

424: l_doc_format:=WF_NOTIFICATION.doc_text;
425: elsif ( P_PSIG_DOCUMENTFORMAT = 'HTML' or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_html) THEN
426: l_doc_format:=WF_NOTIFICATION.doc_html;
427: else
428: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_DOCFORMAT');
429: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_WFNTF_FORMAT');
430: P_ERROR_MSG:= fnd_message.get();
431: RAISE EDR_GENERIC_ERROR;
432: end if;

Line 429: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_WFNTF_FORMAT');

425: elsif ( P_PSIG_DOCUMENTFORMAT = 'HTML' or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_html) THEN
426: l_doc_format:=WF_NOTIFICATION.doc_html;
427: else
428: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_DOCFORMAT');
429: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_WFNTF_FORMAT');
430: P_ERROR_MSG:= fnd_message.get();
431: RAISE EDR_GENERIC_ERROR;
432: end if;
433: /* End Bug Fix 3142631*/

Line 430: P_ERROR_MSG:= fnd_message.get();

426: l_doc_format:=WF_NOTIFICATION.doc_html;
427: else
428: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_DOCFORMAT');
429: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_WFNTF_FORMAT');
430: P_ERROR_MSG:= fnd_message.get();
431: RAISE EDR_GENERIC_ERROR;
432: end if;
433: /* End Bug Fix 3142631*/
434:

Line 449: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_ERROR');

445: wf_notification.writetoclob(l_document,l_msg);
446: end loop;
447: EXCEPTION
448: WHEN OTHERS then
449: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_ERROR');
450: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_WFNTF_ERROR');
451: P_ERROR_MSG:= fnd_message.get();
452: RAISE EDR_GENERIC_ERROR;
453: END;

Line 450: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_WFNTF_ERROR');

446: end loop;
447: EXCEPTION
448: WHEN OTHERS then
449: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_ERROR');
450: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_WFNTF_ERROR');
451: P_ERROR_MSG:= fnd_message.get();
452: RAISE EDR_GENERIC_ERROR;
453: END;
454: end if;

Line 451: P_ERROR_MSG:= fnd_message.get();

447: EXCEPTION
448: WHEN OTHERS then
449: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_ERROR');
450: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_WFNTF_ERROR');
451: P_ERROR_MSG:= fnd_message.get();
452: RAISE EDR_GENERIC_ERROR;
453: END;
454: end if;
455:

Line 763: fnd_message.set_name('EDR','EDR_PSIG_DOC_SIGNATURES');

759: FETCH C1 into l_count;
760: CLOSE C1;
761:
762: IF l_count > 0 THEN
763: fnd_message.set_name('EDR','EDR_PSIG_DOC_SIGNATURES');
764: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DOC_SIGNATURES');
765: P_ERROR_MSG:= fnd_message.get();
766: RAISE EDR_GENERIC_ERROR;
767: END IF;

Line 764: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DOC_SIGNATURES');

760: CLOSE C1;
761:
762: IF l_count > 0 THEN
763: fnd_message.set_name('EDR','EDR_PSIG_DOC_SIGNATURES');
764: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DOC_SIGNATURES');
765: P_ERROR_MSG:= fnd_message.get();
766: RAISE EDR_GENERIC_ERROR;
767: END IF;
768: END IF;

Line 765: P_ERROR_MSG:= fnd_message.get();

761:
762: IF l_count > 0 THEN
763: fnd_message.set_name('EDR','EDR_PSIG_DOC_SIGNATURES');
764: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DOC_SIGNATURES');
765: P_ERROR_MSG:= fnd_message.get();
766: RAISE EDR_GENERIC_ERROR;
767: END IF;
768: END IF;
769:

Line 791: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');

787: EXCEPTION
788: WHEN EDR_GENERIC_ERROR then
789: NULL;
790: WHEN EDR_INVALID_DOC_TRAN then
791: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');
792: fnd_message.set_token('FROM',l_status);
793: fnd_message.set_token('TO',p_status);
794: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
795: P_ERROR_MSG:= fnd_message.get();

Line 792: fnd_message.set_token('FROM',l_status);

788: WHEN EDR_GENERIC_ERROR then
789: NULL;
790: WHEN EDR_INVALID_DOC_TRAN then
791: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');
792: fnd_message.set_token('FROM',l_status);
793: fnd_message.set_token('TO',p_status);
794: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
795: P_ERROR_MSG:= fnd_message.get();
796: WHEN EDR_INVALID_DOC_STATUS then

Line 793: fnd_message.set_token('TO',p_status);

789: NULL;
790: WHEN EDR_INVALID_DOC_TRAN then
791: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');
792: fnd_message.set_token('FROM',l_status);
793: fnd_message.set_token('TO',p_status);
794: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
795: P_ERROR_MSG:= fnd_message.get();
796: WHEN EDR_INVALID_DOC_STATUS then
797: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_STATUS');

Line 794: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');

790: WHEN EDR_INVALID_DOC_TRAN then
791: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');
792: fnd_message.set_token('FROM',l_status);
793: fnd_message.set_token('TO',p_status);
794: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
795: P_ERROR_MSG:= fnd_message.get();
796: WHEN EDR_INVALID_DOC_STATUS then
797: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_STATUS');
798: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_STATUS');

Line 795: P_ERROR_MSG:= fnd_message.get();

791: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');
792: fnd_message.set_token('FROM',l_status);
793: fnd_message.set_token('TO',p_status);
794: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
795: P_ERROR_MSG:= fnd_message.get();
796: WHEN EDR_INVALID_DOC_STATUS then
797: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_STATUS');
798: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_STATUS');
799: P_ERROR_MSG:= fnd_message.get();

Line 797: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_STATUS');

793: fnd_message.set_token('TO',p_status);
794: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
795: P_ERROR_MSG:= fnd_message.get();
796: WHEN EDR_INVALID_DOC_STATUS then
797: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_STATUS');
798: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_STATUS');
799: P_ERROR_MSG:= fnd_message.get();
800: WHEN OTHERS then
801: P_ERROR:=SQLCODE;

Line 798: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_STATUS');

794: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
795: P_ERROR_MSG:= fnd_message.get();
796: WHEN EDR_INVALID_DOC_STATUS then
797: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_STATUS');
798: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_STATUS');
799: P_ERROR_MSG:= fnd_message.get();
800: WHEN OTHERS then
801: P_ERROR:=SQLCODE;
802: P_ERROR_MSG:=SQLERRM;

Line 799: P_ERROR_MSG:= fnd_message.get();

795: P_ERROR_MSG:= fnd_message.get();
796: WHEN EDR_INVALID_DOC_STATUS then
797: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_STATUS');
798: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_STATUS');
799: P_ERROR_MSG:= fnd_message.get();
800: WHEN OTHERS then
801: P_ERROR:=SQLCODE;
802: P_ERROR_MSG:=SQLERRM;
803: END changeDocumentstatus;

Line 887: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_DOCFORMAT');

883: l_doc_format:=WF_NOTIFICATION.doc_text;
884: elsif ( P_PSIG_DOCUMENTFORMAT = 'HTML' or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_html) THEN
885: l_doc_format:=WF_NOTIFICATION.doc_html;
886: else
887: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_DOCFORMAT');
888: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_WFNTF_FORMAT');
889: P_ERROR_MSG:= fnd_message.get();
890: RAISE EDR_GENERIC_ERROR;
891: end if;

Line 888: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_WFNTF_FORMAT');

884: elsif ( P_PSIG_DOCUMENTFORMAT = 'HTML' or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_html) THEN
885: l_doc_format:=WF_NOTIFICATION.doc_html;
886: else
887: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_DOCFORMAT');
888: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_WFNTF_FORMAT');
889: P_ERROR_MSG:= fnd_message.get();
890: RAISE EDR_GENERIC_ERROR;
891: end if;
892:

Line 889: P_ERROR_MSG:= fnd_message.get();

885: l_doc_format:=WF_NOTIFICATION.doc_html;
886: else
887: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_DOCFORMAT');
888: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_WFNTF_FORMAT');
889: P_ERROR_MSG:= fnd_message.get();
890: RAISE EDR_GENERIC_ERROR;
891: end if;
892:
893: /* End Bug Fix 3142631*/

Line 909: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_ERROR');

905: wf_notification.writetoclob(l_document,l_msg);
906: end loop;
907: EXCEPTION
908: WHEN OTHERS then
909: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_ERROR');
910: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_WFNTF_ERROR');
911: P_ERROR_MSG:= fnd_message.get();
912: RAISE EDR_GENERIC_ERROR;
913: END;

Line 910: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_WFNTF_ERROR');

906: end loop;
907: EXCEPTION
908: WHEN OTHERS then
909: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_ERROR');
910: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_WFNTF_ERROR');
911: P_ERROR_MSG:= fnd_message.get();
912: RAISE EDR_GENERIC_ERROR;
913: END;
914: end if;

Line 911: P_ERROR_MSG:= fnd_message.get();

907: EXCEPTION
908: WHEN OTHERS then
909: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_ERROR');
910: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_WFNTF_ERROR');
911: P_ERROR_MSG:= fnd_message.get();
912: RAISE EDR_GENERIC_ERROR;
913: END;
914: end if;
915: /* Recieve the CLOB */

Line 945: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');

941: EXCEPTION
942: WHEN EDR_GENERIC_ERROR then
943: NULL;
944: WHEN EDR_INVALID_DOC_TRAN then
945: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');
946: fnd_message.set_token('FROM',l_status);
947: fnd_message.set_token('TO','COMPLETE');
948: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
949: P_ERROR_MSG:= fnd_message.get();

Line 946: fnd_message.set_token('FROM',l_status);

942: WHEN EDR_GENERIC_ERROR then
943: NULL;
944: WHEN EDR_INVALID_DOC_TRAN then
945: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');
946: fnd_message.set_token('FROM',l_status);
947: fnd_message.set_token('TO','COMPLETE');
948: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
949: P_ERROR_MSG:= fnd_message.get();
950: WHEN EDR_INVALID_DOC_STATUS then

Line 947: fnd_message.set_token('TO','COMPLETE');

943: NULL;
944: WHEN EDR_INVALID_DOC_TRAN then
945: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');
946: fnd_message.set_token('FROM',l_status);
947: fnd_message.set_token('TO','COMPLETE');
948: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
949: P_ERROR_MSG:= fnd_message.get();
950: WHEN EDR_INVALID_DOC_STATUS then
951: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_STATUS');

Line 948: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');

944: WHEN EDR_INVALID_DOC_TRAN then
945: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');
946: fnd_message.set_token('FROM',l_status);
947: fnd_message.set_token('TO','COMPLETE');
948: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
949: P_ERROR_MSG:= fnd_message.get();
950: WHEN EDR_INVALID_DOC_STATUS then
951: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_STATUS');
952: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_STATUS');

Line 949: P_ERROR_MSG:= fnd_message.get();

945: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');
946: fnd_message.set_token('FROM',l_status);
947: fnd_message.set_token('TO','COMPLETE');
948: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
949: P_ERROR_MSG:= fnd_message.get();
950: WHEN EDR_INVALID_DOC_STATUS then
951: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_STATUS');
952: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_STATUS');
953: P_ERROR_MSG:= fnd_message.get();

Line 951: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_STATUS');

947: fnd_message.set_token('TO','COMPLETE');
948: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
949: P_ERROR_MSG:= fnd_message.get();
950: WHEN EDR_INVALID_DOC_STATUS then
951: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_STATUS');
952: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_STATUS');
953: P_ERROR_MSG:= fnd_message.get();
954: WHEN OTHERS then
955: P_ERROR:=SQLCODE;

Line 952: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_STATUS');

948: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
949: P_ERROR_MSG:= fnd_message.get();
950: WHEN EDR_INVALID_DOC_STATUS then
951: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_STATUS');
952: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_STATUS');
953: P_ERROR_MSG:= fnd_message.get();
954: WHEN OTHERS then
955: P_ERROR:=SQLCODE;
956: P_ERROR_MSG:=SQLERRM;

Line 953: P_ERROR_MSG:= fnd_message.get();

949: P_ERROR_MSG:= fnd_message.get();
950: WHEN EDR_INVALID_DOC_STATUS then
951: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_STATUS');
952: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_STATUS');
953: P_ERROR_MSG:= fnd_message.get();
954: WHEN OTHERS then
955: P_ERROR:=SQLCODE;
956: P_ERROR_MSG:=SQLERRM;
957:

Line 1005: fnd_message.set_name('EDR','EDR_PSIG_DOC_SIGNATURES');

1001: FETCH C1 into l_count;
1002: CLOSE C1;
1003:
1004: IF l_count > 0 THEN
1005: fnd_message.set_name('EDR','EDR_PSIG_DOC_SIGNATURES');
1006: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DOC_SIGNATURES');
1007: P_ERROR_MSG:= fnd_message.get();
1008: RAISE EDR_GENERIC_ERROR;
1009: END IF;

Line 1006: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DOC_SIGNATURES');

1002: CLOSE C1;
1003:
1004: IF l_count > 0 THEN
1005: fnd_message.set_name('EDR','EDR_PSIG_DOC_SIGNATURES');
1006: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DOC_SIGNATURES');
1007: P_ERROR_MSG:= fnd_message.get();
1008: RAISE EDR_GENERIC_ERROR;
1009: END IF;
1010:

Line 1007: P_ERROR_MSG:= fnd_message.get();

1003:
1004: IF l_count > 0 THEN
1005: fnd_message.set_name('EDR','EDR_PSIG_DOC_SIGNATURES');
1006: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DOC_SIGNATURES');
1007: P_ERROR_MSG:= fnd_message.get();
1008: RAISE EDR_GENERIC_ERROR;
1009: END IF;
1010:
1011: /* Document Exist */

Line 1025: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');

1021: EXCEPTION
1022: WHEN EDR_GENERIC_ERROR then
1023: NULL;
1024: WHEN EDR_INVALID_DOC_TRAN then
1025: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');
1026: fnd_message.set_token('FROM',l_status);
1027: fnd_message.set_token('TO','COMPLETE');
1028: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
1029: P_ERROR_MSG:= fnd_message.get();

Line 1026: fnd_message.set_token('FROM',l_status);

1022: WHEN EDR_GENERIC_ERROR then
1023: NULL;
1024: WHEN EDR_INVALID_DOC_TRAN then
1025: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');
1026: fnd_message.set_token('FROM',l_status);
1027: fnd_message.set_token('TO','COMPLETE');
1028: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
1029: P_ERROR_MSG:= fnd_message.get();
1030: WHEN OTHERS then

Line 1027: fnd_message.set_token('TO','COMPLETE');

1023: NULL;
1024: WHEN EDR_INVALID_DOC_TRAN then
1025: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');
1026: fnd_message.set_token('FROM',l_status);
1027: fnd_message.set_token('TO','COMPLETE');
1028: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
1029: P_ERROR_MSG:= fnd_message.get();
1030: WHEN OTHERS then
1031: P_ERROR:=SQLCODE;

Line 1028: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');

1024: WHEN EDR_INVALID_DOC_TRAN then
1025: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');
1026: fnd_message.set_token('FROM',l_status);
1027: fnd_message.set_token('TO','COMPLETE');
1028: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
1029: P_ERROR_MSG:= fnd_message.get();
1030: WHEN OTHERS then
1031: P_ERROR:=SQLCODE;
1032: P_ERROR_MSG:=SQLERRM;

Line 1029: P_ERROR_MSG:= fnd_message.get();

1025: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');
1026: fnd_message.set_token('FROM',l_status);
1027: fnd_message.set_token('TO','COMPLETE');
1028: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
1029: P_ERROR_MSG:= fnd_message.get();
1030: WHEN OTHERS then
1031: P_ERROR:=SQLCODE;
1032: P_ERROR_MSG:=SQLERRM;
1033: END closeDocument;

Line 1084: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');

1080: EXCEPTION
1081: WHEN EDR_GENERIC_ERROR then
1082: NULL;
1083: WHEN EDR_INVALID_DOC_TRAN then
1084: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');
1085: fnd_message.set_token('FROM',l_status);
1086: fnd_message.set_token('TO','CANCEL');
1087: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
1088: P_ERROR_MSG:= fnd_message.get();

Line 1085: fnd_message.set_token('FROM',l_status);

1081: WHEN EDR_GENERIC_ERROR then
1082: NULL;
1083: WHEN EDR_INVALID_DOC_TRAN then
1084: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');
1085: fnd_message.set_token('FROM',l_status);
1086: fnd_message.set_token('TO','CANCEL');
1087: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
1088: P_ERROR_MSG:= fnd_message.get();
1089: WHEN OTHERS then

Line 1086: fnd_message.set_token('TO','CANCEL');

1082: NULL;
1083: WHEN EDR_INVALID_DOC_TRAN then
1084: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');
1085: fnd_message.set_token('FROM',l_status);
1086: fnd_message.set_token('TO','CANCEL');
1087: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
1088: P_ERROR_MSG:= fnd_message.get();
1089: WHEN OTHERS then
1090: P_ERROR:=SQLCODE;

Line 1087: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');

1083: WHEN EDR_INVALID_DOC_TRAN then
1084: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');
1085: fnd_message.set_token('FROM',l_status);
1086: fnd_message.set_token('TO','CANCEL');
1087: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
1088: P_ERROR_MSG:= fnd_message.get();
1089: WHEN OTHERS then
1090: P_ERROR:=SQLCODE;
1091: P_ERROR_MSG:=SQLERRM;

Line 1088: P_ERROR_MSG:= fnd_message.get();

1084: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOC_TRAN');
1085: fnd_message.set_token('FROM',l_status);
1086: fnd_message.set_token('TO','CANCEL');
1087: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOC_TRAN');
1088: P_ERROR_MSG:= fnd_message.get();
1089: WHEN OTHERS then
1090: P_ERROR:=SQLCODE;
1091: P_ERROR_MSG:=SQLERRM;
1092: END cancelDocument;

Line 1214: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNATURE_SEQ');

1210: IF (P_SIGNATURE_SEQUENCE is null ) then
1211: select (nvl(max(signature_sequence),0) +1) into l_signer_seq from edr_psig_details
1212: where document_id = P_DOCUMENT_ID;
1213: ELSIF ( P_SIGNATURE_SEQUENCE <= 0) THEN
1214: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNATURE_SEQ');
1215: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNATURE_SEQ');
1216: P_ERROR_MSG:= fnd_message.get();
1217: RAISE EDR_GENERIC_ERROR;
1218: ELSE

Line 1215: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNATURE_SEQ');

1211: select (nvl(max(signature_sequence),0) +1) into l_signer_seq from edr_psig_details
1212: where document_id = P_DOCUMENT_ID;
1213: ELSIF ( P_SIGNATURE_SEQUENCE <= 0) THEN
1214: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNATURE_SEQ');
1215: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNATURE_SEQ');
1216: P_ERROR_MSG:= fnd_message.get();
1217: RAISE EDR_GENERIC_ERROR;
1218: ELSE
1219: l_signer_seq := P_SIGNATURE_SEQUENCE;

Line 1216: P_ERROR_MSG:= fnd_message.get();

1212: where document_id = P_DOCUMENT_ID;
1213: ELSIF ( P_SIGNATURE_SEQUENCE <= 0) THEN
1214: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNATURE_SEQ');
1215: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNATURE_SEQ');
1216: P_ERROR_MSG:= fnd_message.get();
1217: RAISE EDR_GENERIC_ERROR;
1218: ELSE
1219: l_signer_seq := P_SIGNATURE_SEQUENCE;
1220: END IF;

Line 1225: fnd_message.set_name('EDR','EDR_PSIG_INVALID_ADHOC_STATUS');

1221: --verify the adhoc status value if its not null
1222: --adhoc status should be ADDED or DELETED only
1223: IF (P_ADHOC_STATUS is not null) then
1224: IF (P_ADHOC_STATUS not in ('ADDED','DELETED') ) then
1225: fnd_message.set_name('EDR','EDR_PSIG_INVALID_ADHOC_STATUS');
1226: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_ADHOC_STATUS');
1227: P_ERROR_MSG:= fnd_message.get();
1228: RAISE EDR_GENERIC_ERROR;
1229: END IF;

Line 1226: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_ADHOC_STATUS');

1222: --adhoc status should be ADDED or DELETED only
1223: IF (P_ADHOC_STATUS is not null) then
1224: IF (P_ADHOC_STATUS not in ('ADDED','DELETED') ) then
1225: fnd_message.set_name('EDR','EDR_PSIG_INVALID_ADHOC_STATUS');
1226: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_ADHOC_STATUS');
1227: P_ERROR_MSG:= fnd_message.get();
1228: RAISE EDR_GENERIC_ERROR;
1229: END IF;
1230: END IF;

Line 1227: P_ERROR_MSG:= fnd_message.get();

1223: IF (P_ADHOC_STATUS is not null) then
1224: IF (P_ADHOC_STATUS not in ('ADDED','DELETED') ) then
1225: fnd_message.set_name('EDR','EDR_PSIG_INVALID_ADHOC_STATUS');
1226: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_ADHOC_STATUS');
1227: P_ERROR_MSG:= fnd_message.get();
1228: RAISE EDR_GENERIC_ERROR;
1229: END IF;
1230: END IF;
1231:

Line 1300: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');

1296: NULL;
1297: WHEN TIMEZONE_ERROR then
1298: NULL;
1299: WHEN EDR_INVALID_SIGN_REQUEST then
1300: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');
1301: fnd_message.set_token('STATUS',L_STATUS);
1302: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');
1303: P_ERROR_MSG:= fnd_message.get();
1304: WHEN EDR_DUPLICATE_SIGNER then

Line 1301: fnd_message.set_token('STATUS',L_STATUS);

1297: WHEN TIMEZONE_ERROR then
1298: NULL;
1299: WHEN EDR_INVALID_SIGN_REQUEST then
1300: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');
1301: fnd_message.set_token('STATUS',L_STATUS);
1302: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');
1303: P_ERROR_MSG:= fnd_message.get();
1304: WHEN EDR_DUPLICATE_SIGNER then
1305: fnd_message.set_name('EDR','EDR_PSIG_DUPLICATE_SIGNER');

Line 1302: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');

1298: NULL;
1299: WHEN EDR_INVALID_SIGN_REQUEST then
1300: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');
1301: fnd_message.set_token('STATUS',L_STATUS);
1302: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');
1303: P_ERROR_MSG:= fnd_message.get();
1304: WHEN EDR_DUPLICATE_SIGNER then
1305: fnd_message.set_name('EDR','EDR_PSIG_DUPLICATE_SIGNER');
1306: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DUPLICATE_SIGNER');

Line 1303: P_ERROR_MSG:= fnd_message.get();

1299: WHEN EDR_INVALID_SIGN_REQUEST then
1300: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');
1301: fnd_message.set_token('STATUS',L_STATUS);
1302: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');
1303: P_ERROR_MSG:= fnd_message.get();
1304: WHEN EDR_DUPLICATE_SIGNER then
1305: fnd_message.set_name('EDR','EDR_PSIG_DUPLICATE_SIGNER');
1306: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DUPLICATE_SIGNER');
1307: P_ERROR_MSG:= fnd_message.get();

Line 1305: fnd_message.set_name('EDR','EDR_PSIG_DUPLICATE_SIGNER');

1301: fnd_message.set_token('STATUS',L_STATUS);
1302: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');
1303: P_ERROR_MSG:= fnd_message.get();
1304: WHEN EDR_DUPLICATE_SIGNER then
1305: fnd_message.set_name('EDR','EDR_PSIG_DUPLICATE_SIGNER');
1306: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DUPLICATE_SIGNER');
1307: P_ERROR_MSG:= fnd_message.get();
1308: WHEN OTHERS then
1309: P_ERROR:=SQLCODE;

Line 1306: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DUPLICATE_SIGNER');

1302: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');
1303: P_ERROR_MSG:= fnd_message.get();
1304: WHEN EDR_DUPLICATE_SIGNER then
1305: fnd_message.set_name('EDR','EDR_PSIG_DUPLICATE_SIGNER');
1306: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DUPLICATE_SIGNER');
1307: P_ERROR_MSG:= fnd_message.get();
1308: WHEN OTHERS then
1309: P_ERROR:=SQLCODE;
1310: P_ERROR_MSG:=SQLERRM;

Line 1307: P_ERROR_MSG:= fnd_message.get();

1303: P_ERROR_MSG:= fnd_message.get();
1304: WHEN EDR_DUPLICATE_SIGNER then
1305: fnd_message.set_name('EDR','EDR_PSIG_DUPLICATE_SIGNER');
1306: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DUPLICATE_SIGNER');
1307: P_ERROR_MSG:= fnd_message.get();
1308: WHEN OTHERS then
1309: P_ERROR:=SQLCODE;
1310: P_ERROR_MSG:=SQLERRM;
1311: END requestSignature;

Line 1419: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGN_POST');

1415: -- IF P_ORIGINAL_RECIPIENT is NULL THEN
1416: OPEN C1;
1417: FETCH C1 into l_signature_id;
1418: IF c1%NOTFOUND THEN
1419: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGN_POST');
1420: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGN_POST');
1421: P_ERROR_MSG:= fnd_message.get();
1422: RAISE EDR_GENERIC_ERROR;
1423: END IF;

Line 1420: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGN_POST');

1416: OPEN C1;
1417: FETCH C1 into l_signature_id;
1418: IF c1%NOTFOUND THEN
1419: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGN_POST');
1420: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGN_POST');
1421: P_ERROR_MSG:= fnd_message.get();
1422: RAISE EDR_GENERIC_ERROR;
1423: END IF;
1424: CLOSE C1;

Line 1421: P_ERROR_MSG:= fnd_message.get();

1417: FETCH C1 into l_signature_id;
1418: IF c1%NOTFOUND THEN
1419: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGN_POST');
1420: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGN_POST');
1421: P_ERROR_MSG:= fnd_message.get();
1422: RAISE EDR_GENERIC_ERROR;
1423: END IF;
1424: CLOSE C1;
1425:

Line 1439: fnd_message.set_name('EDR','EDR_PSIG_PENDING_SIGNATURE');

1435: and document_id = P_DOCUMENT_ID
1436: and adhoc_status <> 'DELETED';
1437:
1438: IF (l_pending_count > 0) THEN
1439: fnd_message.set_name('EDR','EDR_PSIG_PENDING_SIGNATURE');
1440: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_PENDING_SIGNATURE');
1441: P_ERROR_MSG:= fnd_message.get();
1442: RAISE EDR_GENERIC_ERROR;
1443: END IF;

Line 1440: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_PENDING_SIGNATURE');

1436: and adhoc_status <> 'DELETED';
1437:
1438: IF (l_pending_count > 0) THEN
1439: fnd_message.set_name('EDR','EDR_PSIG_PENDING_SIGNATURE');
1440: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_PENDING_SIGNATURE');
1441: P_ERROR_MSG:= fnd_message.get();
1442: RAISE EDR_GENERIC_ERROR;
1443: END IF;
1444: -- we need to update the WHO columns also

Line 1441: P_ERROR_MSG:= fnd_message.get();

1437:
1438: IF (l_pending_count > 0) THEN
1439: fnd_message.set_name('EDR','EDR_PSIG_PENDING_SIGNATURE');
1440: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_PENDING_SIGNATURE');
1441: P_ERROR_MSG:= fnd_message.get();
1442: RAISE EDR_GENERIC_ERROR;
1443: END IF;
1444: -- we need to update the WHO columns also
1445:

Line 1494: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');

1490: NULL;
1491: WHEN TIMEZONE_ERROR then
1492: NULL;
1493: WHEN EDR_INVALID_SIGN_REQUEST then
1494: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');
1495: fnd_message.set_token('STATUS',L_STATUS);
1496: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');
1497: P_ERROR_MSG:= fnd_message.get();
1498: WHEN EDR_DUPLICATE_SIGNER then

Line 1495: fnd_message.set_token('STATUS',L_STATUS);

1491: WHEN TIMEZONE_ERROR then
1492: NULL;
1493: WHEN EDR_INVALID_SIGN_REQUEST then
1494: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');
1495: fnd_message.set_token('STATUS',L_STATUS);
1496: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');
1497: P_ERROR_MSG:= fnd_message.get();
1498: WHEN EDR_DUPLICATE_SIGNER then
1499: fnd_message.set_name('EDR','EDR_PSIG_DUPLICATE_SIGNER');

Line 1496: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');

1492: NULL;
1493: WHEN EDR_INVALID_SIGN_REQUEST then
1494: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');
1495: fnd_message.set_token('STATUS',L_STATUS);
1496: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');
1497: P_ERROR_MSG:= fnd_message.get();
1498: WHEN EDR_DUPLICATE_SIGNER then
1499: fnd_message.set_name('EDR','EDR_PSIG_DUPLICATE_SIGNER');
1500: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DUPLICATE_SIGNER');

Line 1497: P_ERROR_MSG:= fnd_message.get();

1493: WHEN EDR_INVALID_SIGN_REQUEST then
1494: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');
1495: fnd_message.set_token('STATUS',L_STATUS);
1496: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');
1497: P_ERROR_MSG:= fnd_message.get();
1498: WHEN EDR_DUPLICATE_SIGNER then
1499: fnd_message.set_name('EDR','EDR_PSIG_DUPLICATE_SIGNER');
1500: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DUPLICATE_SIGNER');
1501: P_ERROR_MSG:= fnd_message.get();

Line 1499: fnd_message.set_name('EDR','EDR_PSIG_DUPLICATE_SIGNER');

1495: fnd_message.set_token('STATUS',L_STATUS);
1496: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');
1497: P_ERROR_MSG:= fnd_message.get();
1498: WHEN EDR_DUPLICATE_SIGNER then
1499: fnd_message.set_name('EDR','EDR_PSIG_DUPLICATE_SIGNER');
1500: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DUPLICATE_SIGNER');
1501: P_ERROR_MSG:= fnd_message.get();
1502: WHEN OTHERS then
1503: P_ERROR:=SQLCODE;

Line 1500: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DUPLICATE_SIGNER');

1496: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGN_REQUEST');
1497: P_ERROR_MSG:= fnd_message.get();
1498: WHEN EDR_DUPLICATE_SIGNER then
1499: fnd_message.set_name('EDR','EDR_PSIG_DUPLICATE_SIGNER');
1500: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DUPLICATE_SIGNER');
1501: P_ERROR_MSG:= fnd_message.get();
1502: WHEN OTHERS then
1503: P_ERROR:=SQLCODE;
1504: P_ERROR_MSG:=SQLERRM;

Line 1501: P_ERROR_MSG:= fnd_message.get();

1497: P_ERROR_MSG:= fnd_message.get();
1498: WHEN EDR_DUPLICATE_SIGNER then
1499: fnd_message.set_name('EDR','EDR_PSIG_DUPLICATE_SIGNER');
1500: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DUPLICATE_SIGNER');
1501: P_ERROR_MSG:= fnd_message.get();
1502: WHEN OTHERS then
1503: P_ERROR:=SQLCODE;
1504: P_ERROR_MSG:=SQLERRM;
1505:

Line 1538: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNID');

1534: /* Check if Signature Row Exist */
1535: OPEN C1;
1536: FETCH C1 into l_document_id,l_sig_status;
1537: IF c1%NOTFOUND THEN
1538: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNID');
1539: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNID');
1540: P_ERROR_MSG:= fnd_message.get();
1541: RAISE EDR_GENERIC_ERROR;
1542: END IF;

Line 1539: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNID');

1535: OPEN C1;
1536: FETCH C1 into l_document_id,l_sig_status;
1537: IF c1%NOTFOUND THEN
1538: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNID');
1539: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNID');
1540: P_ERROR_MSG:= fnd_message.get();
1541: RAISE EDR_GENERIC_ERROR;
1542: END IF;
1543: CLOSE C1;

Line 1540: P_ERROR_MSG:= fnd_message.get();

1536: FETCH C1 into l_document_id,l_sig_status;
1537: IF c1%NOTFOUND THEN
1538: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNID');
1539: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNID');
1540: P_ERROR_MSG:= fnd_message.get();
1541: RAISE EDR_GENERIC_ERROR;
1542: END IF;
1543: CLOSE C1;
1544: /* Check if it's the row is in PENDING */

Line 1546: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');

1542: END IF;
1543: CLOSE C1;
1544: /* Check if it's the row is in PENDING */
1545: IF l_sig_status = 'COMPLETE' THEN
1546: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
1547: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
1548: P_ERROR_MSG:= fnd_message.get();
1549: RAISE EDR_GENERIC_ERROR;
1550: END IF;

Line 1547: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');

1543: CLOSE C1;
1544: /* Check if it's the row is in PENDING */
1545: IF l_sig_status = 'COMPLETE' THEN
1546: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
1547: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
1548: P_ERROR_MSG:= fnd_message.get();
1549: RAISE EDR_GENERIC_ERROR;
1550: END IF;
1551:

Line 1548: P_ERROR_MSG:= fnd_message.get();

1544: /* Check if it's the row is in PENDING */
1545: IF l_sig_status = 'COMPLETE' THEN
1546: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
1547: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
1548: P_ERROR_MSG:= fnd_message.get();
1549: RAISE EDR_GENERIC_ERROR;
1550: END IF;
1551:
1552: /* Check if document is existing */

Line 1585: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');

1581: EXCEPTION
1582: WHEN EDR_GENERIC_ERROR then
1583: NULL;
1584: WHEN EDR_INVALID_DOC_TRAN then
1585: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
1586: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
1587: P_ERROR_MSG:= fnd_message.get();
1588: WHEN OTHERS then
1589: P_ERROR:=SQLCODE;

Line 1586: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');

1582: WHEN EDR_GENERIC_ERROR then
1583: NULL;
1584: WHEN EDR_INVALID_DOC_TRAN then
1585: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
1586: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
1587: P_ERROR_MSG:= fnd_message.get();
1588: WHEN OTHERS then
1589: P_ERROR:=SQLCODE;
1590: P_ERROR_MSG:=SQLERRM;

Line 1587: P_ERROR_MSG:= fnd_message.get();

1583: NULL;
1584: WHEN EDR_INVALID_DOC_TRAN then
1585: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
1586: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
1587: P_ERROR_MSG:= fnd_message.get();
1588: WHEN OTHERS then
1589: P_ERROR:=SQLCODE;
1590: P_ERROR_MSG:=SQLERRM;
1591: END cancelSignature;

Line 1663: fnd_message.set_name('EDR','EDR_PSIG_DOC_CLOSED');

1659: end if;
1660:
1661: EXCEPTION
1662: WHEN DOCUMENT_CLOSE_ERROR then
1663: fnd_message.set_name('EDR','EDR_PSIG_DOC_CLOSED');
1664: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DOC_CLOSED');
1665: P_ERROR_MSG:= fnd_message.get();
1666: WHEN NO_DATA_FOUND then
1667: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');

Line 1664: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DOC_CLOSED');

1660:
1661: EXCEPTION
1662: WHEN DOCUMENT_CLOSE_ERROR then
1663: fnd_message.set_name('EDR','EDR_PSIG_DOC_CLOSED');
1664: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DOC_CLOSED');
1665: P_ERROR_MSG:= fnd_message.get();
1666: WHEN NO_DATA_FOUND then
1667: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');
1668: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');

Line 1665: P_ERROR_MSG:= fnd_message.get();

1661: EXCEPTION
1662: WHEN DOCUMENT_CLOSE_ERROR then
1663: fnd_message.set_name('EDR','EDR_PSIG_DOC_CLOSED');
1664: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DOC_CLOSED');
1665: P_ERROR_MSG:= fnd_message.get();
1666: WHEN NO_DATA_FOUND then
1667: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');
1668: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');
1669: P_ERROR_MSG:= fnd_message.get();

Line 1667: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');

1663: fnd_message.set_name('EDR','EDR_PSIG_DOC_CLOSED');
1664: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DOC_CLOSED');
1665: P_ERROR_MSG:= fnd_message.get();
1666: WHEN NO_DATA_FOUND then
1667: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');
1668: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');
1669: P_ERROR_MSG:= fnd_message.get();
1670: WHEN OTHERS then
1671: P_ERROR:=SQLCODE;

Line 1668: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');

1664: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DOC_CLOSED');
1665: P_ERROR_MSG:= fnd_message.get();
1666: WHEN NO_DATA_FOUND then
1667: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');
1668: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');
1669: P_ERROR_MSG:= fnd_message.get();
1670: WHEN OTHERS then
1671: P_ERROR:=SQLCODE;
1672: P_ERROR_MSG:=SQLERRM;

Line 1669: P_ERROR_MSG:= fnd_message.get();

1665: P_ERROR_MSG:= fnd_message.get();
1666: WHEN NO_DATA_FOUND then
1667: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');
1668: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');
1669: P_ERROR_MSG:= fnd_message.get();
1670: WHEN OTHERS then
1671: P_ERROR:=SQLCODE;
1672: P_ERROR_MSG:=SQLERRM;
1673: END postDocumentParameter;

Line 1691: fnd_message.set_name('EDR','EDR_PSIG_OBSOLETE_CALL');

1687: i number;
1688: l_parameter_id NUMBER;
1689: L_ROWID ROWID;
1690: BEGIN
1691: fnd_message.set_name('EDR','EDR_PSIG_OBSOLETE_CALL');
1692: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_OBSOLETE_CALL');
1693: P_ERROR_MSG:= fnd_message.get();
1694:
1695: END deleteDocumentParameter;

Line 1692: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_OBSOLETE_CALL');

1688: l_parameter_id NUMBER;
1689: L_ROWID ROWID;
1690: BEGIN
1691: fnd_message.set_name('EDR','EDR_PSIG_OBSOLETE_CALL');
1692: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_OBSOLETE_CALL');
1693: P_ERROR_MSG:= fnd_message.get();
1694:
1695: END deleteDocumentParameter;
1696:

Line 1693: P_ERROR_MSG:= fnd_message.get();

1689: L_ROWID ROWID;
1690: BEGIN
1691: fnd_message.set_name('EDR','EDR_PSIG_OBSOLETE_CALL');
1692: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_OBSOLETE_CALL');
1693: P_ERROR_MSG:= fnd_message.get();
1694:
1695: END deleteDocumentParameter;
1696:
1697:

Line 1708: fnd_message.set_name('EDR','EDR_PSIG_OBSOLETE_CALL');

1704: P_ERROR_MSG OUT NOCOPY VARCHAR2
1705: )
1706: IS
1707: BEGIN
1708: fnd_message.set_name('EDR','EDR_PSIG_OBSOLETE_CALL');
1709: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_OBSOLETE_CALL');
1710: P_ERROR_MSG:= fnd_message.get();END deleteAllDocumentParams;
1711:
1712: /* Post Signature Parameters */

Line 1709: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_OBSOLETE_CALL');

1705: )
1706: IS
1707: BEGIN
1708: fnd_message.set_name('EDR','EDR_PSIG_OBSOLETE_CALL');
1709: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_OBSOLETE_CALL');
1710: P_ERROR_MSG:= fnd_message.get();END deleteAllDocumentParams;
1711:
1712: /* Post Signature Parameters */
1713:

Line 1710: P_ERROR_MSG:= fnd_message.get();END deleteAllDocumentParams;

1706: IS
1707: BEGIN
1708: fnd_message.set_name('EDR','EDR_PSIG_OBSOLETE_CALL');
1709: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_OBSOLETE_CALL');
1710: P_ERROR_MSG:= fnd_message.get();END deleteAllDocumentParams;
1711:
1712: /* Post Signature Parameters */
1713:
1714:

Line 1788: fnd_message.set_name('EDR','EDR_PSIG_DOC_CLOSED');

1784: end if;
1785:
1786: EXCEPTION
1787: WHEN DOCUMENT_CLOSE_ERROR then
1788: fnd_message.set_name('EDR','EDR_PSIG_DOC_CLOSED');
1789: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DOC_CLOSED');
1790: P_ERROR_MSG:= fnd_message.get();
1791: WHEN NO_DATA_FOUND then
1792: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');

Line 1789: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DOC_CLOSED');

1785:
1786: EXCEPTION
1787: WHEN DOCUMENT_CLOSE_ERROR then
1788: fnd_message.set_name('EDR','EDR_PSIG_DOC_CLOSED');
1789: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DOC_CLOSED');
1790: P_ERROR_MSG:= fnd_message.get();
1791: WHEN NO_DATA_FOUND then
1792: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');
1793: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');

Line 1790: P_ERROR_MSG:= fnd_message.get();

1786: EXCEPTION
1787: WHEN DOCUMENT_CLOSE_ERROR then
1788: fnd_message.set_name('EDR','EDR_PSIG_DOC_CLOSED');
1789: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DOC_CLOSED');
1790: P_ERROR_MSG:= fnd_message.get();
1791: WHEN NO_DATA_FOUND then
1792: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');
1793: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');
1794: P_ERROR_MSG:= fnd_message.get();

Line 1792: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');

1788: fnd_message.set_name('EDR','EDR_PSIG_DOC_CLOSED');
1789: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DOC_CLOSED');
1790: P_ERROR_MSG:= fnd_message.get();
1791: WHEN NO_DATA_FOUND then
1792: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');
1793: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');
1794: P_ERROR_MSG:= fnd_message.get();
1795: WHEN OTHERS then
1796: P_ERROR:=SQLCODE;

Line 1793: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');

1789: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_DOC_CLOSED');
1790: P_ERROR_MSG:= fnd_message.get();
1791: WHEN NO_DATA_FOUND then
1792: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');
1793: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');
1794: P_ERROR_MSG:= fnd_message.get();
1795: WHEN OTHERS then
1796: P_ERROR:=SQLCODE;
1797: P_ERROR_MSG:=SQLERRM;

Line 1794: P_ERROR_MSG:= fnd_message.get();

1790: P_ERROR_MSG:= fnd_message.get();
1791: WHEN NO_DATA_FOUND then
1792: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');
1793: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');
1794: P_ERROR_MSG:= fnd_message.get();
1795: WHEN OTHERS then
1796: P_ERROR:=SQLCODE;
1797: P_ERROR_MSG:=SQLERRM;
1798:

Line 1812: fnd_message.set_name('EDR','EDR_PSIG_OBSOLETE_CALL');

1808: P_ERROR_MSG OUT NOCOPY VARCHAR2
1809: )
1810: IS
1811: BEGIN
1812: fnd_message.set_name('EDR','EDR_PSIG_OBSOLETE_CALL');
1813: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_OBSOLETE_CALL');
1814: P_ERROR_MSG:= fnd_message.get();
1815: END deleteSignatureParameter;
1816:

Line 1813: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_OBSOLETE_CALL');

1809: )
1810: IS
1811: BEGIN
1812: fnd_message.set_name('EDR','EDR_PSIG_OBSOLETE_CALL');
1813: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_OBSOLETE_CALL');
1814: P_ERROR_MSG:= fnd_message.get();
1815: END deleteSignatureParameter;
1816:
1817: /* Delete All Signature Parameters */

Line 1814: P_ERROR_MSG:= fnd_message.get();

1810: IS
1811: BEGIN
1812: fnd_message.set_name('EDR','EDR_PSIG_OBSOLETE_CALL');
1813: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_OBSOLETE_CALL');
1814: P_ERROR_MSG:= fnd_message.get();
1815: END deleteSignatureParameter;
1816:
1817: /* Delete All Signature Parameters */
1818:

Line 1828: fnd_message.set_name('EDR','EDR_PSIG_OBSOLETE_CALL');

1824: )
1825: IS
1826:
1827: BEGIN
1828: fnd_message.set_name('EDR','EDR_PSIG_OBSOLETE_CALL');
1829: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_OBSOLETE_CALL');
1830: P_ERROR_MSG:= fnd_message.get();
1831: END deleteAllSignatureParams;
1832:

Line 1829: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_OBSOLETE_CALL');

1825: IS
1826:
1827: BEGIN
1828: fnd_message.set_name('EDR','EDR_PSIG_OBSOLETE_CALL');
1829: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_OBSOLETE_CALL');
1830: P_ERROR_MSG:= fnd_message.get();
1831: END deleteAllSignatureParams;
1832:
1833: /* Get Document Details */

Line 1830: P_ERROR_MSG:= fnd_message.get();

1826:
1827: BEGIN
1828: fnd_message.set_name('EDR','EDR_PSIG_OBSOLETE_CALL');
1829: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_OBSOLETE_CALL');
1830: P_ERROR_MSG:= fnd_message.get();
1831: END deleteAllSignatureParams;
1832:
1833: /* Get Document Details */
1834:

Line 1959: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');

1955: close SIGN_DETAILS;
1956:
1957: EXCEPTION
1958: WHEN NO_DATA_FOUND then
1959: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');
1960: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');
1961: P_ERROR_MSG:= fnd_message.get();
1962:
1963: WHEN OTHERS then

Line 1960: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');

1956:
1957: EXCEPTION
1958: WHEN NO_DATA_FOUND then
1959: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');
1960: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');
1961: P_ERROR_MSG:= fnd_message.get();
1962:
1963: WHEN OTHERS then
1964: P_ERROR:=SQLCODE;

Line 1961: P_ERROR_MSG:= fnd_message.get();

1957: EXCEPTION
1958: WHEN NO_DATA_FOUND then
1959: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');
1960: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');
1961: P_ERROR_MSG:= fnd_message.get();
1962:
1963: WHEN OTHERS then
1964: P_ERROR:=SQLCODE;
1965: P_ERROR_MSG:=SQLERRM;

Line 2052: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNID');

2048: close SIG_PARAMS;
2049:
2050: EXCEPTION
2051: WHEN NO_DATA_FOUND then
2052: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNID');
2053: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNID');
2054: P_ERROR_MSG:= fnd_message.get();
2055: WHEN OTHERS then
2056: P_ERROR:=SQLCODE;

Line 2053: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNID');

2049:
2050: EXCEPTION
2051: WHEN NO_DATA_FOUND then
2052: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNID');
2053: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNID');
2054: P_ERROR_MSG:= fnd_message.get();
2055: WHEN OTHERS then
2056: P_ERROR:=SQLCODE;
2057: P_ERROR_MSG:=SQLERRM;

Line 2054: P_ERROR_MSG:= fnd_message.get();

2050: EXCEPTION
2051: WHEN NO_DATA_FOUND then
2052: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNID');
2053: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNID');
2054: P_ERROR_MSG:= fnd_message.get();
2055: WHEN OTHERS then
2056: P_ERROR:=SQLCODE;
2057: P_ERROR_MSG:=SQLERRM;
2058: END getSignatureDetails;

Line 2115: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');

2111: CLOSE c1;
2112: X_ERROR := 0;
2113: EXCEPTION
2114: WHEN DOCUMENT_NOT_FOUND THEN
2115: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');
2116: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');
2117: X_ERROR_MSG:= fnd_message.get();
2118: CLOSE c1;
2119: WHEN OTHERS then

Line 2116: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');

2112: X_ERROR := 0;
2113: EXCEPTION
2114: WHEN DOCUMENT_NOT_FOUND THEN
2115: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');
2116: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');
2117: X_ERROR_MSG:= fnd_message.get();
2118: CLOSE c1;
2119: WHEN OTHERS then
2120: X_ERROR:=SQLCODE;

Line 2117: X_ERROR_MSG:= fnd_message.get();

2113: EXCEPTION
2114: WHEN DOCUMENT_NOT_FOUND THEN
2115: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');
2116: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');
2117: X_ERROR_MSG:= fnd_message.get();
2118: CLOSE c1;
2119: WHEN OTHERS then
2120: X_ERROR:=SQLCODE;
2121: X_ERROR_MSG:=SQLERRM;

Line 2145: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNATURE');

2141: CLOSE C1;
2142: X_ERROR := 0;
2143: EXCEPTION
2144: WHEN DOCUMENT_NOT_FOUND THEN
2145: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNATURE');
2146: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNATURE');
2147: X_ERROR_MSG:= fnd_message.get();
2148: CLOSE c1;
2149: WHEN OTHERS then

Line 2146: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNATURE');

2142: X_ERROR := 0;
2143: EXCEPTION
2144: WHEN DOCUMENT_NOT_FOUND THEN
2145: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNATURE');
2146: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNATURE');
2147: X_ERROR_MSG:= fnd_message.get();
2148: CLOSE c1;
2149: WHEN OTHERS then
2150: X_ERROR:=SQLCODE;

Line 2147: X_ERROR_MSG:= fnd_message.get();

2143: EXCEPTION
2144: WHEN DOCUMENT_NOT_FOUND THEN
2145: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNATURE');
2146: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNATURE');
2147: X_ERROR_MSG:= fnd_message.get();
2148: CLOSE c1;
2149: WHEN OTHERS then
2150: X_ERROR:=SQLCODE;
2151: X_ERROR_MSG:=SQLERRM;

Line 2176: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNID');

2172: /* Check if Signature Row Exist */
2173: OPEN C1;
2174: FETCH C1 into l_document_id,l_sig_status, l_adhoc_status;
2175: IF c1%NOTFOUND THEN
2176: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNID');
2177: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNID');
2178: X_ERROR_MSG:= fnd_message.get();
2179: RAISE EDR_GENERIC_ERROR;
2180: END IF;

Line 2177: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNID');

2173: OPEN C1;
2174: FETCH C1 into l_document_id,l_sig_status, l_adhoc_status;
2175: IF c1%NOTFOUND THEN
2176: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNID');
2177: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNID');
2178: X_ERROR_MSG:= fnd_message.get();
2179: RAISE EDR_GENERIC_ERROR;
2180: END IF;
2181: CLOSE C1;

Line 2178: X_ERROR_MSG:= fnd_message.get();

2174: FETCH C1 into l_document_id,l_sig_status, l_adhoc_status;
2175: IF c1%NOTFOUND THEN
2176: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNID');
2177: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNID');
2178: X_ERROR_MSG:= fnd_message.get();
2179: RAISE EDR_GENERIC_ERROR;
2180: END IF;
2181: CLOSE C1;
2182:

Line 2185: fnd_message.set_name('EDR','EDR_PSIG_NOT_ADHOC_SIGNER');

2181: CLOSE C1;
2182:
2183: /* Check if the user is adhoc */
2184: IF (l_adhoc_status <> 'ADDED') THEN
2185: fnd_message.set_name('EDR','EDR_PSIG_NOT_ADHOC_SIGNER');
2186: x_error :=fnd_message.get_number('EDR','EDR_PSIG_NOT_ADHOC_SIGNER');
2187: X_ERROR_MSG:= fnd_message.get();
2188: RAISE EDR_GENERIC_ERROR;
2189: END IF;

Line 2186: x_error :=fnd_message.get_number('EDR','EDR_PSIG_NOT_ADHOC_SIGNER');

2182:
2183: /* Check if the user is adhoc */
2184: IF (l_adhoc_status <> 'ADDED') THEN
2185: fnd_message.set_name('EDR','EDR_PSIG_NOT_ADHOC_SIGNER');
2186: x_error :=fnd_message.get_number('EDR','EDR_PSIG_NOT_ADHOC_SIGNER');
2187: X_ERROR_MSG:= fnd_message.get();
2188: RAISE EDR_GENERIC_ERROR;
2189: END IF;
2190:

Line 2187: X_ERROR_MSG:= fnd_message.get();

2183: /* Check if the user is adhoc */
2184: IF (l_adhoc_status <> 'ADDED') THEN
2185: fnd_message.set_name('EDR','EDR_PSIG_NOT_ADHOC_SIGNER');
2186: x_error :=fnd_message.get_number('EDR','EDR_PSIG_NOT_ADHOC_SIGNER');
2187: X_ERROR_MSG:= fnd_message.get();
2188: RAISE EDR_GENERIC_ERROR;
2189: END IF;
2190:
2191: /* Check if it's the row is in PENDING */

Line 2193: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');

2189: END IF;
2190:
2191: /* Check if it's the row is in PENDING */
2192: IF l_sig_status = 'COMPLETE' THEN
2193: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
2194: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
2195: X_ERROR_MSG:= fnd_message.get();
2196: RAISE EDR_GENERIC_ERROR;
2197: END IF;

Line 2194: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');

2190:
2191: /* Check if it's the row is in PENDING */
2192: IF l_sig_status = 'COMPLETE' THEN
2193: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
2194: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
2195: X_ERROR_MSG:= fnd_message.get();
2196: RAISE EDR_GENERIC_ERROR;
2197: END IF;
2198:

Line 2195: X_ERROR_MSG:= fnd_message.get();

2191: /* Check if it's the row is in PENDING */
2192: IF l_sig_status = 'COMPLETE' THEN
2193: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
2194: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
2195: X_ERROR_MSG:= fnd_message.get();
2196: RAISE EDR_GENERIC_ERROR;
2197: END IF;
2198:
2199: /* Check if document is existing */

Line 2224: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');

2220: WHEN EDR_GENERIC_ERROR then
2221: NULL;
2222:
2223: WHEN EDR_INVALID_DOC_TRAN then
2224: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
2225: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
2226: X_ERROR_MSG:= fnd_message.get();
2227:
2228: WHEN OTHERS then

Line 2225: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');

2221: NULL;
2222:
2223: WHEN EDR_INVALID_DOC_TRAN then
2224: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
2225: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
2226: X_ERROR_MSG:= fnd_message.get();
2227:
2228: WHEN OTHERS then
2229: X_ERROR:=SQLCODE;

Line 2226: X_ERROR_MSG:= fnd_message.get();

2222:
2223: WHEN EDR_INVALID_DOC_TRAN then
2224: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
2225: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
2226: X_ERROR_MSG:= fnd_message.get();
2227:
2228: WHEN OTHERS then
2229: X_ERROR:=SQLCODE;
2230: X_ERROR_MSG:=SQLERRM;

Line 2257: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNID');

2253: /* Check if Signature Row Exist */
2254: OPEN C1;
2255: FETCH C1 into l_document_id,l_sig_status;
2256: IF c1%NOTFOUND THEN
2257: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNID');
2258: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNID');
2259: X_ERROR_MSG:= fnd_message.get();
2260: RAISE EDR_GENERIC_ERROR;
2261: END IF;

Line 2258: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNID');

2254: OPEN C1;
2255: FETCH C1 into l_document_id,l_sig_status;
2256: IF c1%NOTFOUND THEN
2257: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNID');
2258: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNID');
2259: X_ERROR_MSG:= fnd_message.get();
2260: RAISE EDR_GENERIC_ERROR;
2261: END IF;
2262: CLOSE C1;

Line 2259: X_ERROR_MSG:= fnd_message.get();

2255: FETCH C1 into l_document_id,l_sig_status;
2256: IF c1%NOTFOUND THEN
2257: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNID');
2258: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNID');
2259: X_ERROR_MSG:= fnd_message.get();
2260: RAISE EDR_GENERIC_ERROR;
2261: END IF;
2262: CLOSE C1;
2263:

Line 2266: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');

2262: CLOSE C1;
2263:
2264: /* Check if it's the row is in PENDING */
2265: IF l_sig_status = 'COMPLETE' THEN
2266: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
2267: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
2268: X_ERROR_MSG:= fnd_message.get();
2269: RAISE EDR_GENERIC_ERROR;
2270: END IF;

Line 2267: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');

2263:
2264: /* Check if it's the row is in PENDING */
2265: IF l_sig_status = 'COMPLETE' THEN
2266: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
2267: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
2268: X_ERROR_MSG:= fnd_message.get();
2269: RAISE EDR_GENERIC_ERROR;
2270: END IF;
2271:

Line 2268: X_ERROR_MSG:= fnd_message.get();

2264: /* Check if it's the row is in PENDING */
2265: IF l_sig_status = 'COMPLETE' THEN
2266: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
2267: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
2268: X_ERROR_MSG:= fnd_message.get();
2269: RAISE EDR_GENERIC_ERROR;
2270: END IF;
2271:
2272: /* Check if document is existing */

Line 2287: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNATURE_SEQ');

2283: RAISE EDR_INVALID_DOC_TRAN;
2284: END IF;
2285:
2286: IF ( P_SIGNATURE_SEQUENCE <= 0) THEN
2287: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNATURE_SEQ');
2288: X_ERROR:= fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNATURE_SEQ');
2289: X_ERROR_MSG:= fnd_message.get();
2290: RAISE EDR_GENERIC_ERROR;
2291: END IF;

Line 2288: X_ERROR:= fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNATURE_SEQ');

2284: END IF;
2285:
2286: IF ( P_SIGNATURE_SEQUENCE <= 0) THEN
2287: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNATURE_SEQ');
2288: X_ERROR:= fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNATURE_SEQ');
2289: X_ERROR_MSG:= fnd_message.get();
2290: RAISE EDR_GENERIC_ERROR;
2291: END IF;
2292:

Line 2289: X_ERROR_MSG:= fnd_message.get();

2285:
2286: IF ( P_SIGNATURE_SEQUENCE <= 0) THEN
2287: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNATURE_SEQ');
2288: X_ERROR:= fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNATURE_SEQ');
2289: X_ERROR_MSG:= fnd_message.get();
2290: RAISE EDR_GENERIC_ERROR;
2291: END IF;
2292:
2293: /* Document Exist */

Line 2307: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');

2303: WHEN EDR_GENERIC_ERROR then
2304: NULL;
2305:
2306: WHEN EDR_INVALID_DOC_TRAN then
2307: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
2308: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
2309: X_ERROR_MSG:= fnd_message.get();
2310:
2311: WHEN OTHERS then

Line 2308: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');

2304: NULL;
2305:
2306: WHEN EDR_INVALID_DOC_TRAN then
2307: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
2308: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
2309: X_ERROR_MSG:= fnd_message.get();
2310:
2311: WHEN OTHERS then
2312: X_ERROR:=SQLCODE;

Line 2309: X_ERROR_MSG:= fnd_message.get();

2305:
2306: WHEN EDR_INVALID_DOC_TRAN then
2307: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
2308: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
2309: X_ERROR_MSG:= fnd_message.get();
2310:
2311: WHEN OTHERS then
2312: X_ERROR:=SQLCODE;
2313: X_ERROR_MSG:=SQLERRM;

Line 2337: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNID');

2333: /* Check if Signature Row Exist */
2334: OPEN C1;
2335: FETCH C1 into l_document_id,l_sig_status;
2336: IF c1%NOTFOUND THEN
2337: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNID');
2338: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNID');
2339: X_ERROR_MSG:= fnd_message.get();
2340: RAISE EDR_GENERIC_ERROR;
2341: END IF;

Line 2338: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNID');

2334: OPEN C1;
2335: FETCH C1 into l_document_id,l_sig_status;
2336: IF c1%NOTFOUND THEN
2337: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNID');
2338: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNID');
2339: X_ERROR_MSG:= fnd_message.get();
2340: RAISE EDR_GENERIC_ERROR;
2341: END IF;
2342: CLOSE C1;

Line 2339: X_ERROR_MSG:= fnd_message.get();

2335: FETCH C1 into l_document_id,l_sig_status;
2336: IF c1%NOTFOUND THEN
2337: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNID');
2338: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNID');
2339: X_ERROR_MSG:= fnd_message.get();
2340: RAISE EDR_GENERIC_ERROR;
2341: END IF;
2342: CLOSE C1;
2343:

Line 2346: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');

2342: CLOSE C1;
2343:
2344: /* Check if it's the row is in PENDING */
2345: IF l_sig_status = 'COMPLETE' THEN
2346: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
2347: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
2348: X_ERROR_MSG:= fnd_message.get();
2349: RAISE EDR_GENERIC_ERROR;
2350: END IF;

Line 2347: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');

2343:
2344: /* Check if it's the row is in PENDING */
2345: IF l_sig_status = 'COMPLETE' THEN
2346: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
2347: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
2348: X_ERROR_MSG:= fnd_message.get();
2349: RAISE EDR_GENERIC_ERROR;
2350: END IF;
2351:

Line 2348: X_ERROR_MSG:= fnd_message.get();

2344: /* Check if it's the row is in PENDING */
2345: IF l_sig_status = 'COMPLETE' THEN
2346: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
2347: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
2348: X_ERROR_MSG:= fnd_message.get();
2349: RAISE EDR_GENERIC_ERROR;
2350: END IF;
2351:
2352: /* Check if document is existing */

Line 2368: fnd_message.set_name('EDR','EDR_PSIG_INVALID_ADHOC_STATUS');

2364: END IF;
2365:
2366: --adhoc status should be ADDED or DELETED only
2367: IF (P_ADHOC_STATUS not in ('ADDED','DELETED') ) then
2368: fnd_message.set_name('EDR','EDR_PSIG_INVALID_ADHOC_STATUS');
2369: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_ADHOC_STATUS');
2370: X_ERROR_MSG:= fnd_message.get();
2371: RAISE EDR_GENERIC_ERROR;
2372: END IF;

Line 2369: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_ADHOC_STATUS');

2365:
2366: --adhoc status should be ADDED or DELETED only
2367: IF (P_ADHOC_STATUS not in ('ADDED','DELETED') ) then
2368: fnd_message.set_name('EDR','EDR_PSIG_INVALID_ADHOC_STATUS');
2369: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_ADHOC_STATUS');
2370: X_ERROR_MSG:= fnd_message.get();
2371: RAISE EDR_GENERIC_ERROR;
2372: END IF;
2373: /* Document Exist */

Line 2370: X_ERROR_MSG:= fnd_message.get();

2366: --adhoc status should be ADDED or DELETED only
2367: IF (P_ADHOC_STATUS not in ('ADDED','DELETED') ) then
2368: fnd_message.set_name('EDR','EDR_PSIG_INVALID_ADHOC_STATUS');
2369: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_ADHOC_STATUS');
2370: X_ERROR_MSG:= fnd_message.get();
2371: RAISE EDR_GENERIC_ERROR;
2372: END IF;
2373: /* Document Exist */
2374: UPDATE EDR_PSIG_DETAILS

Line 2387: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');

2383: WHEN EDR_GENERIC_ERROR then
2384: NULL;
2385:
2386: WHEN EDR_INVALID_DOC_TRAN then
2387: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
2388: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
2389: X_ERROR_MSG:= fnd_message.get();
2390:
2391: WHEN OTHERS then

Line 2388: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');

2384: NULL;
2385:
2386: WHEN EDR_INVALID_DOC_TRAN then
2387: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
2388: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
2389: X_ERROR_MSG:= fnd_message.get();
2390:
2391: WHEN OTHERS then
2392: X_ERROR:=SQLCODE;

Line 2389: X_ERROR_MSG:= fnd_message.get();

2385:
2386: WHEN EDR_INVALID_DOC_TRAN then
2387: fnd_message.set_name('EDR','EDR_PSIG_SIGN_COMPLETE');
2388: X_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_SIGN_COMPLETE');
2389: X_ERROR_MSG:= fnd_message.get();
2390:
2391: WHEN OTHERS then
2392: X_ERROR:=SQLCODE;
2393: X_ERROR_MSG:=SQLERRM;

Line 2428: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');

2424: from edr_psig_documents
2425: where document_id = p_document_id;
2426: exception
2427: WHEN NO_DATA_FOUND then
2428: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');
2429: X_ERROR_CODE:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');
2430: X_ERROR_MSG:= fnd_message.get();
2431: WHEN OTHERS then
2432: X_ERROR_CODE:=SQLCODE;

Line 2429: X_ERROR_CODE:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');

2425: where document_id = p_document_id;
2426: exception
2427: WHEN NO_DATA_FOUND then
2428: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');
2429: X_ERROR_CODE:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');
2430: X_ERROR_MSG:= fnd_message.get();
2431: WHEN OTHERS then
2432: X_ERROR_CODE:=SQLCODE;
2433: X_ERROR_MSG:=SQLERRM;

Line 2430: X_ERROR_MSG:= fnd_message.get();

2426: exception
2427: WHEN NO_DATA_FOUND then
2428: fnd_message.set_name('EDR','EDR_PSIG_INVALID_DOCUMENT');
2429: X_ERROR_CODE:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_DOCUMENT');
2430: X_ERROR_MSG:= fnd_message.get();
2431: WHEN OTHERS then
2432: X_ERROR_CODE:=SQLCODE;
2433: X_ERROR_MSG:=SQLERRM;
2434: END getERecordXML;

Line 2487: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

2483:
2484: EXCEPTION
2485: WHEN OTHERS THEN
2486: ROLLBACK TO PSIG_USER_DETAILS;
2487: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
2488: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2489: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG');
2490: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','UPDATE_PSIG_USER_DETAILS');
2491: RAISE;

Line 2488: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

2484: EXCEPTION
2485: WHEN OTHERS THEN
2486: ROLLBACK TO PSIG_USER_DETAILS;
2487: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
2488: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2489: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG');
2490: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','UPDATE_PSIG_USER_DETAILS');
2491: RAISE;
2492:

Line 2489: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG');

2485: WHEN OTHERS THEN
2486: ROLLBACK TO PSIG_USER_DETAILS;
2487: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
2488: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2489: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG');
2490: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','UPDATE_PSIG_USER_DETAILS');
2491: RAISE;
2492:
2493: END UPDATE_PSIG_USER_DETAILS;

Line 2490: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','UPDATE_PSIG_USER_DETAILS');

2486: ROLLBACK TO PSIG_USER_DETAILS;
2487: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
2488: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2489: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG');
2490: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','UPDATE_PSIG_USER_DETAILS');
2491: RAISE;
2492:
2493: END UPDATE_PSIG_USER_DETAILS;
2494:

Line 3208: FND_MESSAGE.SET_NAME('EDR','EDR_EVENT_XML_EVENT_NAME_ERR');

3204: X_FINAL_XML := null;
3205:
3206: WHEN INVALID_EVENT_NAME_ERROR THEN
3207:
3208: FND_MESSAGE.SET_NAME('EDR','EDR_EVENT_XML_EVENT_NAME_ERR');
3209:
3210: --Diagnostics Start
3211: if FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
3212: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

Line 3222: FND_MESSAGE.SET_NAME('EDR','EDR_EVENT_XML_EVENT_KEY_ERR');

3218: APP_EXCEPTION.RAISE_EXCEPTION;
3219: --Diagnostics End
3220:
3221: WHEN INVALID_EVENT_KEY_ERROR THEN
3222: FND_MESSAGE.SET_NAME('EDR','EDR_EVENT_XML_EVENT_KEY_ERR');
3223:
3224: --Diagnostics Start
3225: if FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
3226: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

Line 3236: FND_MESSAGE.SET_NAME('EDR','EDR_EVENT_XML_PARAMS_ERR');

3232: APP_EXCEPTION.RAISE_EXCEPTION;
3233: --Diagnostics End
3234:
3235: WHEN INVALID_PARAMS_ERROR THEN
3236: FND_MESSAGE.SET_NAME('EDR','EDR_EVENT_XML_PARAMS_ERR');
3237:
3238: --Diagnostics Start
3239: if FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
3240: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

Line 3252: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

3248:
3249: WHEN OTHERS THEN
3250:
3251: --Diagnostics Start
3252: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
3253: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
3254: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG');
3255: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_EVENT_XML');
3256: if FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then

Line 3253: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

3249: WHEN OTHERS THEN
3250:
3251: --Diagnostics Start
3252: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
3253: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
3254: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG');
3255: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_EVENT_XML');
3256: if FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
3257: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

Line 3254: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG');

3250:
3251: --Diagnostics Start
3252: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
3253: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
3254: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG');
3255: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_EVENT_XML');
3256: if FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
3257: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3258: 'edr.plsql.EDR_PSIG.GET_EVENT_XML',

Line 3255: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_EVENT_XML');

3251: --Diagnostics Start
3252: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
3253: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
3254: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG');
3255: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_EVENT_XML');
3256: if FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
3257: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3258: 'edr.plsql.EDR_PSIG.GET_EVENT_XML',
3259: FALSE