1: PACKAGE BODY AZW_UTIL as
2: /* $Header: AZWUTILB.pls 115.12 2003/04/08 08:50:27 sbandi ship $: */
3:
4: -- UpdateDocUrl
5: -- Called by AIWStart
53: WHEN OTHERS THEN
54: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
55: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
56: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
57: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
58: fnd_message.set_token('AZW_ERROR_STMT','select process_version from wf_process_activities');
59: APP_EXCEPTION.RAISE_EXCEPTION;
60: END;
61:
74: WHEN OTHERS THEN
75: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
76: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
77: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
78: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
79: fnd_message.set_token('AZW_ERROR_STMT','select type from wf_activities');
80: APP_EXCEPTION.RAISE_EXCEPTION;
81: END;
82:
93: WHEN OTHERS THEN
94: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
95: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
96: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
97: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
98: fnd_message.set_token('AZW_ERROR_STMT','select message from wf_activities');
99: APP_EXCEPTION.RAISE_EXCEPTION;
100: END;
101:
109: WHEN OTHERS THEN
110: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
111: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
112: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
113: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
114: fnd_message.set_token('AZW_ERROR_STMT','cursor c_apps_c');
115: APP_EXCEPTION.RAISE_EXCEPTION;
116: END;
117:
125: WHEN OTHERS THEN
126: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
127: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
128: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
129: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
130: fnd_message.set_token('AZW_ERROR_STMT','cursor c_target_c');
131: APP_EXCEPTION.RAISE_EXCEPTION;
132: END;
133:
145: WHEN OTHERS THEN
146: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
147: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
148: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
149: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
150: fnd_message.set_token('AZW_ERROR_STMT','update wf_message_attribute');
151: APP_EXCEPTION.RAISE_EXCEPTION;
152: END;
153: end if;
162: WHEN OTHERS THEN
163: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
164: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
165: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
166: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
167: fnd_message.set_token('AZW_ERROR_STMT','cursor c_act_c');
168: APP_EXCEPTION.RAISE_EXCEPTION;
169: End UpdateDocUrl;
170:
205: WHEN OTHERS THEN
206: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
207: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
208: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
209: fnd_message.set_token('AZW_ERROR_PROC','azw_util.IsProductInstalled');
210: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
211: APP_EXCEPTION.RAISE_EXCEPTION;
212: END IsProductInstalled;
213:
342:
343: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
344: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
345: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
346: fnd_message.set_token('AZW_ERROR_PROC','azw_util.validate_opm_context');
347: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
348: APP_EXCEPTION.RAISE_EXCEPTION;
349:
350: END validate_opm_context;
502: WHEN OTHERS THEN
503: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
504: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
505: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
506: fnd_message.set_token('AZW_ERROR_PROC','azw_util.Callback');
507: fnd_message.set_token('AZW_ERROR_STMT','Call to CheckContext');
508: APP_EXCEPTION.RAISE_EXCEPTION;
509: END Callback;
510:
571: result := SQLERRM;
572:
573: END PreviousStep;
574:
575: end AZW_UTIL;
576: