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.SOA_GENERATE dependencies on WF_CORE

Line 180: p_err_message := wf_core.translate('WF_WS_MISSING_CLASS_ID');

176:
177: begin
178: if (p_base_class_id is null ) then
179: p_err_code := -1;
180: p_err_message := wf_core.translate('WF_WS_MISSING_CLASS_ID');
181: raise program_exit;
182: end if;
183:
184: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 198: wf_core.token('BaseClassId',p_base_class_id);

194: close c_class_name;
195:
196: if c_class_rec.l_count = 0 then
197: p_err_code := -1;
198: wf_core.token('BaseClassId',p_base_class_id);
199: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');
200: raise program_exit;
201: end if;
202:

Line 199: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');

195:
196: if c_class_rec.l_count = 0 then
197: p_err_code := -1;
198: wf_core.token('BaseClassId',p_base_class_id);
199: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');
200: raise program_exit;
201: end if;
202:
203: for c1 in c_methods(p_base_class_id)

Line 221: wf_core.token('BaseClassId',p_base_class_id);

217: when program_exit then
218: raise program_exit;
219: when others then
220: p_err_code := -1;
221: wf_core.token('BaseClassId',p_base_class_id);
222: wf_core.token('BaseClassName', p_base_class_name);
223: wf_core.token('FunctionId',c1.function_id);
224: wf_core.token('SqlErr',SQLERRM);
225: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');

Line 222: wf_core.token('BaseClassName', p_base_class_name);

218: raise program_exit;
219: when others then
220: p_err_code := -1;
221: wf_core.token('BaseClassId',p_base_class_id);
222: wf_core.token('BaseClassName', p_base_class_name);
223: wf_core.token('FunctionId',c1.function_id);
224: wf_core.token('SqlErr',SQLERRM);
225: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');
226: raise program_exit;

Line 223: wf_core.token('FunctionId',c1.function_id);

219: when others then
220: p_err_code := -1;
221: wf_core.token('BaseClassId',p_base_class_id);
222: wf_core.token('BaseClassName', p_base_class_name);
223: wf_core.token('FunctionId',c1.function_id);
224: wf_core.token('SqlErr',SQLERRM);
225: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');
226: raise program_exit;
227: end;

Line 224: wf_core.token('SqlErr',SQLERRM);

220: p_err_code := -1;
221: wf_core.token('BaseClassId',p_base_class_id);
222: wf_core.token('BaseClassName', p_base_class_name);
223: wf_core.token('FunctionId',c1.function_id);
224: wf_core.token('SqlErr',SQLERRM);
225: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');
226: raise program_exit;
227: end;
228:

Line 225: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');

221: wf_core.token('BaseClassId',p_base_class_id);
222: wf_core.token('BaseClassName', p_base_class_name);
223: wf_core.token('FunctionId',c1.function_id);
224: wf_core.token('SqlErr',SQLERRM);
225: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');
226: raise program_exit;
227: end;
228:
229: end loop;

Line 231: wf_core.token('BaseClassId',p_base_class_id);

227: end;
228:
229: end loop;
230:
231: wf_core.token('BaseClassId',p_base_class_id);
232: wf_core.token('BaseClassName', p_base_class_name);
233: if (public_method_count = 0 ) then
234: x_derived_class_id := -1;
235: p_err_code := -1;

Line 232: wf_core.token('BaseClassName', p_base_class_name);

228:
229: end loop;
230:
231: wf_core.token('BaseClassId',p_base_class_id);
232: wf_core.token('BaseClassName', p_base_class_name);
233: if (public_method_count = 0 ) then
234: x_derived_class_id := -1;
235: p_err_code := -1;
236: p_err_message := wf_core.translate('WF_WS_NO_PUBLIC_METHODS');

Line 236: p_err_message := wf_core.translate('WF_WS_NO_PUBLIC_METHODS');

232: wf_core.token('BaseClassName', p_base_class_name);
233: if (public_method_count = 0 ) then
234: x_derived_class_id := -1;
235: p_err_code := -1;
236: p_err_message := wf_core.translate('WF_WS_NO_PUBLIC_METHODS');
237: raise program_exit;
238: elsif ( public_method_count > 0 ) then
239: p_err_code := 0;
240: p_err_message := wf_core.translate('WF_WS_SUCCESS');

Line 240: p_err_message := wf_core.translate('WF_WS_SUCCESS');

236: p_err_message := wf_core.translate('WF_WS_NO_PUBLIC_METHODS');
237: raise program_exit;
238: elsif ( public_method_count > 0 ) then
239: p_err_code := 0;
240: p_err_message := wf_core.translate('WF_WS_SUCCESS');
241: end if;
242:
243: exception
244: when program_exit then

Line 248: wf_core.token('BaseClassId',p_base_class_id);

244: when program_exit then
245: null;
246: when others then
247: p_err_code := -1;
248: wf_core.token('BaseClassId',p_base_class_id);
249: wf_core.token('BaseClassName', p_base_class_name);
250: wf_core.token('SqlErr',SQLERRM);
251: p_err_message := wf_core.translate('WF_WS_CLASS_DERIVED');
252: end create_class_derived_entry;

Line 249: wf_core.token('BaseClassName', p_base_class_name);

245: null;
246: when others then
247: p_err_code := -1;
248: wf_core.token('BaseClassId',p_base_class_id);
249: wf_core.token('BaseClassName', p_base_class_name);
250: wf_core.token('SqlErr',SQLERRM);
251: p_err_message := wf_core.translate('WF_WS_CLASS_DERIVED');
252: end create_class_derived_entry;
253:

Line 250: wf_core.token('SqlErr',SQLERRM);

246: when others then
247: p_err_code := -1;
248: wf_core.token('BaseClassId',p_base_class_id);
249: wf_core.token('BaseClassName', p_base_class_name);
250: wf_core.token('SqlErr',SQLERRM);
251: p_err_message := wf_core.translate('WF_WS_CLASS_DERIVED');
252: end create_class_derived_entry;
253:
254:

Line 251: p_err_message := wf_core.translate('WF_WS_CLASS_DERIVED');

247: p_err_code := -1;
248: wf_core.token('BaseClassId',p_base_class_id);
249: wf_core.token('BaseClassName', p_base_class_name);
250: wf_core.token('SqlErr',SQLERRM);
251: p_err_message := wf_core.translate('WF_WS_CLASS_DERIVED');
252: end create_class_derived_entry;
253:
254:
255: /**

Line 305: p_err_message := wf_core.translate('WF_WS_MISSING_CLASS_FUNC_ID');

301:
302:
303: if ( (p_base_class_id is null) or (p_base_function_id is null)) then
304: p_err_code := -1;
305: p_err_message := wf_core.translate('WF_WS_MISSING_CLASS_FUNC_ID');
306: raise program_exit;
307: end if;
308:
309:

Line 321: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');

317: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'oracle.apps.fnd.wf.ws.create_derived_entry', 'Base Class ID='||p_base_class_id||' does not exist');
318: end if;
319:
320: p_err_code := -1;
321: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');
322: raise program_exit;
323:
324: elsif c_base_class_entry%FOUND then
325:

Line 342: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_MISMATCH');

338: end if;
339:
340: if ( c_base_function_entry_rec.irep_class_id <> p_base_class_id ) then
341: p_err_code :=-1;
342: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_MISMATCH');
343: raise program_exit;
344: end if;
345:
346: if ( c_base_class_entry_rec.scope_type = 'PUBLIC' AND c_base_function_entry_rec.irep_scope = 'PUBLIC' ) then

Line 362: p_err_message := wf_core.translate('WF_WS_XMLG_OUTBOUND');

358: end if;
359:
360:
361: p_err_code :=-1;
362: p_err_message := wf_core.translate('WF_WS_XMLG_OUTBOUND');
363: raise ignore_rec;
364: end if;
365:
366: /**

Line 556: p_err_message :=wf_core.translate('WF_WS_XMLG_INVALID_ENTRY');

552: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'oracle.apps.fnd.wf.ws.create_derived_entry', 'Invalid Function Name does not have : ');
553: end if;
554:
555: p_err_code := -1;
556: p_err_message :=wf_core.translate('WF_WS_XMLG_INVALID_ENTRY');
557: end if;
558:
559: elsif ( c_base_class_entry_rec.class_type = 'SERVICEBEAN' or c_base_class_entry_rec.class_type = 'WSDL' or
560: c_base_class_entry_rec.class_type = 'PLSQL' or c_base_class_entry_rec.class_type = 'CONCURRENTPROGRAM' or

Line 579: p_err_message :=wf_core.translate('WF_WS_MISSING_IREP_METHOD_NAME');

575: --dbms_output.put_line('I_Operation='||i_operation||'x');
576: --dbms_output.put_line('I_Operation length='||length(i_operation)||'x');
577: if ( (i_operation is null ) or (length(i_operation) is NULL ) ) then
578: p_err_code := -1;
579: p_err_message :=wf_core.translate('WF_WS_MISSING_IREP_METHOD_NAME');
580: raise program_exit;
581: end if;
582:
583: create_class_entry_detail

Line 676: p_err_message := wf_core.translate('WF_WS_NOT_PUBLIC');

672: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'oracle.apps.fnd.wf.ws.create_derived_entry', 'ClassID,FunctionID:'||c_base_class_entry_rec.class_id||','||c_base_function_entry_rec.function_id||' Not a public interface/method to be exposed');
673: end if;
674:
675: p_err_code := -1;
676: p_err_message := wf_core.translate('WF_WS_NOT_PUBLIC');
677: raise program_exit;
678: end if;
679: else
680: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 685: p_err_message := wf_core.translate('WF_WS_BASE_FUNC_NOT_EXIST');

681: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'oracle.apps.fnd.wf.ws.create_derived_entry', ' No records found for FunctionID='||c_base_function_entry_rec.function_id);
682: end if;
683:
684: p_err_code := -1;
685: p_err_message := wf_core.translate('WF_WS_BASE_FUNC_NOT_EXIST');
686: raise program_exit;
687: end if;
688:
689: close c_base_function_entry;

Line 695: wf_core.token('ClassId',p_base_class_id);

691:
692: close c_base_class_entry;
693:
694: p_err_code := 0;
695: wf_core.token('ClassId',p_base_class_id);
696: p_err_message :=wf_core.translate('WF_WS_SUCCESS');
697:
698: exception
699: when ignore_rec then

Line 696: p_err_message :=wf_core.translate('WF_WS_SUCCESS');

692: close c_base_class_entry;
693:
694: p_err_code := 0;
695: wf_core.token('ClassId',p_base_class_id);
696: p_err_message :=wf_core.translate('WF_WS_SUCCESS');
697:
698: exception
699: when ignore_rec then
700: raise ignore_rec;

Line 705: p_err_message :=wf_core.translate('WF_WS_GENERIC_CLASS_ERROR')||'Error in Creating Derived Entry for Base FUNCTION_ID='||p_base_function_id||SQLERRM;

701: when program_exit then
702: raise program_exit;
703: when others then
704: p_err_code := -1;
705: p_err_message :=wf_core.translate('WF_WS_GENERIC_CLASS_ERROR')||'Error in Creating Derived Entry for Base FUNCTION_ID='||p_base_function_id||SQLERRM;
706: raise program_exit;
707: end create_function_derived_entry;
708:
709: procedure create_class_entry_detail

Line 765: p_err_message := wf_core.translate('WF_WS_CLASS_NAME_IS_NULL');

761: begin
762:
763: if ( (p_class_name is null) or (p_base_class_id is null) ) then
764: p_err_code := -1;
765: p_err_message := wf_core.translate('WF_WS_CLASS_NAME_IS_NULL');
766: raise program_exit;
767: end if;
768:
769: open c_derived_class(p_class_name,p_entry_type);

Line 862: p_err_message := wf_core.translate('WF_WS_CLASS_INSERT')||SQLERRM;

858: when program_exit then
859: raise program_exit;
860: when others then
861: p_err_code := -1;
862: p_err_message := wf_core.translate('WF_WS_CLASS_INSERT')||SQLERRM;
863: end;
864:
865: p_class_id_out := l_class_id;
866:

Line 913: p_err_message := wf_core.translate('WF_WS_CLASS_UPDATE')||SQLERRM;

909: when program_exit then
910: raise program_exit;
911: when others then
912: p_err_code := -1;
913: p_err_message := wf_core.translate('WF_WS_CLASS_UPDATE')||SQLERRM;
914: end;
915:
916: p_class_id_out := c_derived_class_rec.class_id;
917: end if;

Line 922: p_err_message := wf_core.translate('WF_WS_SUCCESS');

918:
919: close c_derived_class;
920:
921: p_err_code := 0;
922: p_err_message := wf_core.translate('WF_WS_SUCCESS');
923: exception
924: when program_exit then
925: raise program_exit;
926: when others then

Line 928: wf_core.token('BaseClassName',p_class_name);

924: when program_exit then
925: raise program_exit;
926: when others then
927: p_err_code := -1;
928: wf_core.token('BaseClassName',p_class_name);
929: wf_core.token('SqlErr',SQLERRM);
930: p_err_message := wf_core.translate('WF_WS_CLASS_CREATE');
931: raise program_exit;
932: end create_class_entry_detail;

Line 929: wf_core.token('SqlErr',SQLERRM);

925: raise program_exit;
926: when others then
927: p_err_code := -1;
928: wf_core.token('BaseClassName',p_class_name);
929: wf_core.token('SqlErr',SQLERRM);
930: p_err_message := wf_core.translate('WF_WS_CLASS_CREATE');
931: raise program_exit;
932: end create_class_entry_detail;
933:

Line 930: p_err_message := wf_core.translate('WF_WS_CLASS_CREATE');

926: when others then
927: p_err_code := -1;
928: wf_core.token('BaseClassName',p_class_name);
929: wf_core.token('SqlErr',SQLERRM);
930: p_err_message := wf_core.translate('WF_WS_CLASS_CREATE');
931: raise program_exit;
932: end create_class_entry_detail;
933:
934:

Line 1183: p_err_message := wf_core.translate('WF_WS_SUCCESS');

1179:
1180: close c_derived_method;
1181:
1182: p_err_code := 0;
1183: p_err_message := wf_core.translate('WF_WS_SUCCESS');
1184: exception
1185: when program_exit then
1186: raise program_exit;
1187: when others then

Line 1189: wf_core.token('FunctionName',p_function_name);

1185: when program_exit then
1186: raise program_exit;
1187: when others then
1188: p_err_code := -1;
1189: wf_core.token('FunctionName',p_function_name);
1190: wf_core.token('BaseFunctionId',p_base_function_id);
1191: wf_core.token('DerivedClassId',p_irep_class_id);
1192: wf_core.token('SqlErr',SQLERRM);
1193: p_err_message := wf_core.translate('WF_WS_FUNCTION_CREATE');

Line 1190: wf_core.token('BaseFunctionId',p_base_function_id);

1186: raise program_exit;
1187: when others then
1188: p_err_code := -1;
1189: wf_core.token('FunctionName',p_function_name);
1190: wf_core.token('BaseFunctionId',p_base_function_id);
1191: wf_core.token('DerivedClassId',p_irep_class_id);
1192: wf_core.token('SqlErr',SQLERRM);
1193: p_err_message := wf_core.translate('WF_WS_FUNCTION_CREATE');
1194: raise program_exit;

Line 1191: wf_core.token('DerivedClassId',p_irep_class_id);

1187: when others then
1188: p_err_code := -1;
1189: wf_core.token('FunctionName',p_function_name);
1190: wf_core.token('BaseFunctionId',p_base_function_id);
1191: wf_core.token('DerivedClassId',p_irep_class_id);
1192: wf_core.token('SqlErr',SQLERRM);
1193: p_err_message := wf_core.translate('WF_WS_FUNCTION_CREATE');
1194: raise program_exit;
1195: end create_function_entry_detail;

Line 1192: wf_core.token('SqlErr',SQLERRM);

1188: p_err_code := -1;
1189: wf_core.token('FunctionName',p_function_name);
1190: wf_core.token('BaseFunctionId',p_base_function_id);
1191: wf_core.token('DerivedClassId',p_irep_class_id);
1192: wf_core.token('SqlErr',SQLERRM);
1193: p_err_message := wf_core.translate('WF_WS_FUNCTION_CREATE');
1194: raise program_exit;
1195: end create_function_entry_detail;
1196:

Line 1193: p_err_message := wf_core.translate('WF_WS_FUNCTION_CREATE');

1189: wf_core.token('FunctionName',p_function_name);
1190: wf_core.token('BaseFunctionId',p_base_function_id);
1191: wf_core.token('DerivedClassId',p_irep_class_id);
1192: wf_core.token('SqlErr',SQLERRM);
1193: p_err_message := wf_core.translate('WF_WS_FUNCTION_CREATE');
1194: raise program_exit;
1195: end create_function_entry_detail;
1196:
1197: procedure create_function_lang_entries

Line 1244: p_err_message := wf_core.translate('WF_WS_SUCCESS');

1240: p_err_message
1241: );
1242: end loop;
1243: p_err_code := 0;
1244: p_err_message := wf_core.translate('WF_WS_SUCCESS');
1245:
1246: exception
1247: when program_exit then
1248: raise program_exit;

Line 1251: wf_core.token('BaseFunctionId',p_base_function_id);

1247: when program_exit then
1248: raise program_exit;
1249: when others then
1250: p_err_code := -1;
1251: wf_core.token('BaseFunctionId',p_base_function_id);
1252: wf_core.token('DerivedFunctionId',p_function_id);
1253: wf_core.token('DerivedFunctionName',p_function_name);
1254: wf_core.token('SqlErr',SQLERRM);
1255: p_err_message := wf_core.translate('WF_WS_FUNC_LANG_ENTRIES');

Line 1252: wf_core.token('DerivedFunctionId',p_function_id);

1248: raise program_exit;
1249: when others then
1250: p_err_code := -1;
1251: wf_core.token('BaseFunctionId',p_base_function_id);
1252: wf_core.token('DerivedFunctionId',p_function_id);
1253: wf_core.token('DerivedFunctionName',p_function_name);
1254: wf_core.token('SqlErr',SQLERRM);
1255: p_err_message := wf_core.translate('WF_WS_FUNC_LANG_ENTRIES');
1256: raise program_exit;

Line 1253: wf_core.token('DerivedFunctionName',p_function_name);

1249: when others then
1250: p_err_code := -1;
1251: wf_core.token('BaseFunctionId',p_base_function_id);
1252: wf_core.token('DerivedFunctionId',p_function_id);
1253: wf_core.token('DerivedFunctionName',p_function_name);
1254: wf_core.token('SqlErr',SQLERRM);
1255: p_err_message := wf_core.translate('WF_WS_FUNC_LANG_ENTRIES');
1256: raise program_exit;
1257: end create_function_lang_entries;

Line 1254: wf_core.token('SqlErr',SQLERRM);

1250: p_err_code := -1;
1251: wf_core.token('BaseFunctionId',p_base_function_id);
1252: wf_core.token('DerivedFunctionId',p_function_id);
1253: wf_core.token('DerivedFunctionName',p_function_name);
1254: wf_core.token('SqlErr',SQLERRM);
1255: p_err_message := wf_core.translate('WF_WS_FUNC_LANG_ENTRIES');
1256: raise program_exit;
1257: end create_function_lang_entries;
1258:

Line 1255: p_err_message := wf_core.translate('WF_WS_FUNC_LANG_ENTRIES');

1251: wf_core.token('BaseFunctionId',p_base_function_id);
1252: wf_core.token('DerivedFunctionId',p_function_id);
1253: wf_core.token('DerivedFunctionName',p_function_name);
1254: wf_core.token('SqlErr',SQLERRM);
1255: p_err_message := wf_core.translate('WF_WS_FUNC_LANG_ENTRIES');
1256: raise program_exit;
1257: end create_function_lang_entries;
1258:
1259:

Line 1351: p_err_message :=wf_core.translate('WF_WS_SUCCESS');

1347: end if;
1348:
1349: close c_function_language;
1350:
1351: p_err_message :=wf_core.translate('WF_WS_SUCCESS');
1352: p_err_code :=0;
1353: exception
1354: when program_exit then
1355: raise program_exit;

Line 1358: wf_core.token('DerivedFunctionName', p_function_name);

1354: when program_exit then
1355: raise program_exit;
1356: when others then
1357: p_err_code := -1;
1358: wf_core.token('DerivedFunctionName', p_function_name);
1359: wf_core.token('DerivedFunctionId',p_function_id);
1360: wf_core.token('Lang',p_language);
1361: wf_core.token('SqlErr',SQLERRM);
1362: p_err_message := wf_core.translate('WF_WS_FUNC_LANG');

Line 1359: wf_core.token('DerivedFunctionId',p_function_id);

1355: raise program_exit;
1356: when others then
1357: p_err_code := -1;
1358: wf_core.token('DerivedFunctionName', p_function_name);
1359: wf_core.token('DerivedFunctionId',p_function_id);
1360: wf_core.token('Lang',p_language);
1361: wf_core.token('SqlErr',SQLERRM);
1362: p_err_message := wf_core.translate('WF_WS_FUNC_LANG');
1363: raise program_exit;

Line 1360: wf_core.token('Lang',p_language);

1356: when others then
1357: p_err_code := -1;
1358: wf_core.token('DerivedFunctionName', p_function_name);
1359: wf_core.token('DerivedFunctionId',p_function_id);
1360: wf_core.token('Lang',p_language);
1361: wf_core.token('SqlErr',SQLERRM);
1362: p_err_message := wf_core.translate('WF_WS_FUNC_LANG');
1363: raise program_exit;
1364: end create_function_language;

Line 1361: wf_core.token('SqlErr',SQLERRM);

1357: p_err_code := -1;
1358: wf_core.token('DerivedFunctionName', p_function_name);
1359: wf_core.token('DerivedFunctionId',p_function_id);
1360: wf_core.token('Lang',p_language);
1361: wf_core.token('SqlErr',SQLERRM);
1362: p_err_message := wf_core.translate('WF_WS_FUNC_LANG');
1363: raise program_exit;
1364: end create_function_language;
1365:

Line 1362: p_err_message := wf_core.translate('WF_WS_FUNC_LANG');

1358: wf_core.token('DerivedFunctionName', p_function_name);
1359: wf_core.token('DerivedFunctionId',p_function_id);
1360: wf_core.token('Lang',p_language);
1361: wf_core.token('SqlErr',SQLERRM);
1362: p_err_message := wf_core.translate('WF_WS_FUNC_LANG');
1363: raise program_exit;
1364: end create_function_language;
1365:
1366: procedure create_class_language

Line 1459: p_err_message :=wf_core.translate('WF_WS_SUCCESS');

1455: end if;
1456:
1457: close c_class_language;
1458:
1459: p_err_message :=wf_core.translate('WF_WS_SUCCESS');
1460: p_err_code :=0;
1461: exception
1462: when program_exit then
1463: raise program_exit;

Line 1466: wf_core.token('DerivedClassName', p_derived_class_name);

1462: when program_exit then
1463: raise program_exit;
1464: when others then
1465: p_err_code := -1;
1466: wf_core.token('DerivedClassName', p_derived_class_name);
1467: wf_core.token('DerivedClassId',p_class_id);
1468: wf_core.token('Lang',p_language);
1469: wf_core.token('SqlErr',SQLERRM);
1470: p_err_message := wf_core.translate('WF_WS_CLASS_LANG');

Line 1467: wf_core.token('DerivedClassId',p_class_id);

1463: raise program_exit;
1464: when others then
1465: p_err_code := -1;
1466: wf_core.token('DerivedClassName', p_derived_class_name);
1467: wf_core.token('DerivedClassId',p_class_id);
1468: wf_core.token('Lang',p_language);
1469: wf_core.token('SqlErr',SQLERRM);
1470: p_err_message := wf_core.translate('WF_WS_CLASS_LANG');
1471: raise program_exit;

Line 1468: wf_core.token('Lang',p_language);

1464: when others then
1465: p_err_code := -1;
1466: wf_core.token('DerivedClassName', p_derived_class_name);
1467: wf_core.token('DerivedClassId',p_class_id);
1468: wf_core.token('Lang',p_language);
1469: wf_core.token('SqlErr',SQLERRM);
1470: p_err_message := wf_core.translate('WF_WS_CLASS_LANG');
1471: raise program_exit;
1472: end create_class_language;

Line 1469: wf_core.token('SqlErr',SQLERRM);

1465: p_err_code := -1;
1466: wf_core.token('DerivedClassName', p_derived_class_name);
1467: wf_core.token('DerivedClassId',p_class_id);
1468: wf_core.token('Lang',p_language);
1469: wf_core.token('SqlErr',SQLERRM);
1470: p_err_message := wf_core.translate('WF_WS_CLASS_LANG');
1471: raise program_exit;
1472: end create_class_language;
1473:

Line 1470: p_err_message := wf_core.translate('WF_WS_CLASS_LANG');

1466: wf_core.token('DerivedClassName', p_derived_class_name);
1467: wf_core.token('DerivedClassId',p_class_id);
1468: wf_core.token('Lang',p_language);
1469: wf_core.token('SqlErr',SQLERRM);
1470: p_err_message := wf_core.translate('WF_WS_CLASS_LANG');
1471: raise program_exit;
1472: end create_class_language;
1473:
1474:

Line 1525: p_err_message := wf_core.translate('WF_WS_SUCCESS');

1521: );
1522: end loop;
1523:
1524: p_err_code := 0;
1525: p_err_message := wf_core.translate('WF_WS_SUCCESS');
1526:
1527: exception
1528: when program_exit then
1529: raise program_exit;

Line 1532: wf_core.token('DerivedClassName', p_derived_class_name);

1528: when program_exit then
1529: raise program_exit;
1530: when others then
1531: p_err_code := -1;
1532: wf_core.token('DerivedClassName', p_derived_class_name);
1533: wf_core.token('DerivedClassId',p_class_id);
1534: wf_core.token('SqlErr',SQLERRM);
1535: p_err_message := wf_core.translate('WF_WS_CLASS_LANG_ENTRIES');
1536: raise program_exit;

Line 1533: wf_core.token('DerivedClassId',p_class_id);

1529: raise program_exit;
1530: when others then
1531: p_err_code := -1;
1532: wf_core.token('DerivedClassName', p_derived_class_name);
1533: wf_core.token('DerivedClassId',p_class_id);
1534: wf_core.token('SqlErr',SQLERRM);
1535: p_err_message := wf_core.translate('WF_WS_CLASS_LANG_ENTRIES');
1536: raise program_exit;
1537: end create_class_lang_entries;

Line 1534: wf_core.token('SqlErr',SQLERRM);

1530: when others then
1531: p_err_code := -1;
1532: wf_core.token('DerivedClassName', p_derived_class_name);
1533: wf_core.token('DerivedClassId',p_class_id);
1534: wf_core.token('SqlErr',SQLERRM);
1535: p_err_message := wf_core.translate('WF_WS_CLASS_LANG_ENTRIES');
1536: raise program_exit;
1537: end create_class_lang_entries;
1538:

Line 1535: p_err_message := wf_core.translate('WF_WS_CLASS_LANG_ENTRIES');

1531: p_err_code := -1;
1532: wf_core.token('DerivedClassName', p_derived_class_name);
1533: wf_core.token('DerivedClassId',p_class_id);
1534: wf_core.token('SqlErr',SQLERRM);
1535: p_err_message := wf_core.translate('WF_WS_CLASS_LANG_ENTRIES');
1536: raise program_exit;
1537: end create_class_lang_entries;
1538:
1539: procedure create_xmlg_schema

Line 1587: p_err_message := wf_core.translate('WF_WS_SUCCESS');

1583: p_clob := i_tmp;
1584: dbms_lob.freetemporary(i_tmp);
1585:
1586: p_err_code := 0;
1587: p_err_message := wf_core.translate('WF_WS_SUCCESS');
1588: exception
1589: when program_exit then
1590: raise program_exit;
1591: when others then

Line 1593: wf_core.token('InterfaceName',p_port_type);

1589: when program_exit then
1590: raise program_exit;
1591: when others then
1592: p_err_code := -1;
1593: wf_core.token('InterfaceName',p_port_type);
1594: wf_core.token('SqlErr',SQLERRM);
1595: p_err_message := wf_core.translate('WF_WS_XMLG_SCHEMA');
1596: raise program_exit;
1597: end create_xmlg_schema;

Line 1594: wf_core.token('SqlErr',SQLERRM);

1590: raise program_exit;
1591: when others then
1592: p_err_code := -1;
1593: wf_core.token('InterfaceName',p_port_type);
1594: wf_core.token('SqlErr',SQLERRM);
1595: p_err_message := wf_core.translate('WF_WS_XMLG_SCHEMA');
1596: raise program_exit;
1597: end create_xmlg_schema;
1598:

Line 1595: p_err_message := wf_core.translate('WF_WS_XMLG_SCHEMA');

1591: when others then
1592: p_err_code := -1;
1593: wf_core.token('InterfaceName',p_port_type);
1594: wf_core.token('SqlErr',SQLERRM);
1595: p_err_message := wf_core.translate('WF_WS_XMLG_SCHEMA');
1596: raise program_exit;
1597: end create_xmlg_schema;
1598:
1599:

Line 1617: p_err_message := wf_core.translate('WF_WS_SUCCESS');

1613: p_new_name := l_var;
1614: end if;
1615:
1616: p_err_code := 0;
1617: p_err_message := wf_core.translate('WF_WS_SUCCESS');
1618: exception
1619: when program_exit then
1620: raise program_exit;
1621: when others then

Line 1623: wf_core.token('Name',p_name);

1619: when program_exit then
1620: raise program_exit;
1621: when others then
1622: p_err_code := -1;
1623: wf_core.token('Name',p_name);
1624: wf_core.token('SqlErr',SQLERRM);
1625: p_err_message := wf_core.translate('WF_WS_XMLG_NS');
1626: raise program_exit;
1627: end to_upper;

Line 1624: wf_core.token('SqlErr',SQLERRM);

1620: raise program_exit;
1621: when others then
1622: p_err_code := -1;
1623: wf_core.token('Name',p_name);
1624: wf_core.token('SqlErr',SQLERRM);
1625: p_err_message := wf_core.translate('WF_WS_XMLG_NS');
1626: raise program_exit;
1627: end to_upper;
1628:

Line 1625: p_err_message := wf_core.translate('WF_WS_XMLG_NS');

1621: when others then
1622: p_err_code := -1;
1623: wf_core.token('Name',p_name);
1624: wf_core.token('SqlErr',SQLERRM);
1625: p_err_message := wf_core.translate('WF_WS_XMLG_NS');
1626: raise program_exit;
1627: end to_upper;
1628:
1629:

Line 1664: wf_core.token('GetRootElement mapCode', p_map_code);

1660:
1661: exception
1662: when others then
1663: p_err_code := -1;
1664: wf_core.token('GetRootElement mapCode', p_map_code);
1665: wf_core.token('SqlErr',SQLERRM);
1666: p_err_message := wf_core.translate('WF_WS_MODULE_FAILED');
1667: raise program_exit;
1668: end get_root_element;

Line 1665: wf_core.token('SqlErr',SQLERRM);

1661: exception
1662: when others then
1663: p_err_code := -1;
1664: wf_core.token('GetRootElement mapCode', p_map_code);
1665: wf_core.token('SqlErr',SQLERRM);
1666: p_err_message := wf_core.translate('WF_WS_MODULE_FAILED');
1667: raise program_exit;
1668: end get_root_element;
1669:

Line 1666: p_err_message := wf_core.translate('WF_WS_MODULE_FAILED');

1662: when others then
1663: p_err_code := -1;
1664: wf_core.token('GetRootElement mapCode', p_map_code);
1665: wf_core.token('SqlErr',SQLERRM);
1666: p_err_message := wf_core.translate('WF_WS_MODULE_FAILED');
1667: raise program_exit;
1668: end get_root_element;
1669:
1670: procedure create_object_derived_entry

Line 1708: p_err_message := wf_core.translate('WF_WS_MISSING_CLASS_ID');

1704: begin
1705:
1706: if (p_base_object_id is null ) then
1707: p_err_code := -1;
1708: p_err_message := wf_core.translate('WF_WS_MISSING_CLASS_ID');
1709: raise program_exit;
1710: end if;
1711:
1712: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 1727: --wf_core.token('BaseClassId',p_base_class_id);

1723:
1724: if c_object_rec.l_count = 0 then
1725: p_err_code := -1;
1726: --todo create new token
1727: --wf_core.token('BaseClassId',p_base_class_id);
1728: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');
1729: raise program_exit;
1730: end if;
1731:

Line 1728: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');

1724: if c_object_rec.l_count = 0 then
1725: p_err_code := -1;
1726: --todo create new token
1727: --wf_core.token('BaseClassId',p_base_class_id);
1728: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');
1729: raise program_exit;
1730: end if;
1731:
1732: for c1 in c_methods(p_base_object_id)

Line 1752: --wf_core.token('BaseClassId',p_base_object_id);

1748: raise program_exit;
1749: when others then
1750: p_err_code := -1;
1751: --todo create new tokens
1752: --wf_core.token('BaseClassId',p_base_object_id);
1753: --wf_core.token('BaseClassName', p_base_object_name);
1754: --wf_core.token('FunctionId',c1.function_id);
1755: --wf_core.token('SqlErr',SQLERRM);
1756: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');

Line 1753: --wf_core.token('BaseClassName', p_base_object_name);

1749: when others then
1750: p_err_code := -1;
1751: --todo create new tokens
1752: --wf_core.token('BaseClassId',p_base_object_id);
1753: --wf_core.token('BaseClassName', p_base_object_name);
1754: --wf_core.token('FunctionId',c1.function_id);
1755: --wf_core.token('SqlErr',SQLERRM);
1756: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');
1757: raise program_exit;

Line 1754: --wf_core.token('FunctionId',c1.function_id);

1750: p_err_code := -1;
1751: --todo create new tokens
1752: --wf_core.token('BaseClassId',p_base_object_id);
1753: --wf_core.token('BaseClassName', p_base_object_name);
1754: --wf_core.token('FunctionId',c1.function_id);
1755: --wf_core.token('SqlErr',SQLERRM);
1756: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');
1757: raise program_exit;
1758: end;

Line 1755: --wf_core.token('SqlErr',SQLERRM);

1751: --todo create new tokens
1752: --wf_core.token('BaseClassId',p_base_object_id);
1753: --wf_core.token('BaseClassName', p_base_object_name);
1754: --wf_core.token('FunctionId',c1.function_id);
1755: --wf_core.token('SqlErr',SQLERRM);
1756: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');
1757: raise program_exit;
1758: end;
1759:

Line 1756: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');

1752: --wf_core.token('BaseClassId',p_base_object_id);
1753: --wf_core.token('BaseClassName', p_base_object_name);
1754: --wf_core.token('FunctionId',c1.function_id);
1755: --wf_core.token('SqlErr',SQLERRM);
1756: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');
1757: raise program_exit;
1758: end;
1759:
1760: end loop;

Line 1762: wf_core.token('BaseClassId',p_base_object_id);

1758: end;
1759:
1760: end loop;
1761:
1762: wf_core.token('BaseClassId',p_base_object_id);
1763: wf_core.token('BaseClassName', p_base_object_name);
1764: if (method_count = 0 ) then
1765: p_err_code := -1;
1766: p_err_message := wf_core.translate('WF_WS_NO_BASE_METHODS');

Line 1763: wf_core.token('BaseClassName', p_base_object_name);

1759:
1760: end loop;
1761:
1762: wf_core.token('BaseClassId',p_base_object_id);
1763: wf_core.token('BaseClassName', p_base_object_name);
1764: if (method_count = 0 ) then
1765: p_err_code := -1;
1766: p_err_message := wf_core.translate('WF_WS_NO_BASE_METHODS');
1767: elsif ( method_count > 0 ) then

Line 1766: p_err_message := wf_core.translate('WF_WS_NO_BASE_METHODS');

1762: wf_core.token('BaseClassId',p_base_object_id);
1763: wf_core.token('BaseClassName', p_base_object_name);
1764: if (method_count = 0 ) then
1765: p_err_code := -1;
1766: p_err_message := wf_core.translate('WF_WS_NO_BASE_METHODS');
1767: elsif ( method_count > 0 ) then
1768: p_err_code := 0;
1769: p_err_message := wf_core.translate('WF_WS_SUCCESS');
1770: end if;

Line 1769: p_err_message := wf_core.translate('WF_WS_SUCCESS');

1765: p_err_code := -1;
1766: p_err_message := wf_core.translate('WF_WS_NO_BASE_METHODS');
1767: elsif ( method_count > 0 ) then
1768: p_err_code := 0;
1769: p_err_message := wf_core.translate('WF_WS_SUCCESS');
1770: end if;
1771:
1772: exception
1773: when program_exit then

Line 1777: wf_core.token('BaseClassId',p_base_object_id);

1773: when program_exit then
1774: null;
1775: when others then
1776: p_err_code := -1;
1777: wf_core.token('BaseClassId',p_base_object_id);
1778: wf_core.token('BaseClassName', p_base_object_name);
1779: wf_core.token('SqlErr',SQLERRM);
1780: p_err_message := wf_core.translate('WF_WS_CLASS_DERIVED');
1781: end create_object_derived_entry;

Line 1778: wf_core.token('BaseClassName', p_base_object_name);

1774: null;
1775: when others then
1776: p_err_code := -1;
1777: wf_core.token('BaseClassId',p_base_object_id);
1778: wf_core.token('BaseClassName', p_base_object_name);
1779: wf_core.token('SqlErr',SQLERRM);
1780: p_err_message := wf_core.translate('WF_WS_CLASS_DERIVED');
1781: end create_object_derived_entry;
1782:

Line 1779: wf_core.token('SqlErr',SQLERRM);

1775: when others then
1776: p_err_code := -1;
1777: wf_core.token('BaseClassId',p_base_object_id);
1778: wf_core.token('BaseClassName', p_base_object_name);
1779: wf_core.token('SqlErr',SQLERRM);
1780: p_err_message := wf_core.translate('WF_WS_CLASS_DERIVED');
1781: end create_object_derived_entry;
1782:
1783: /**

Line 1780: p_err_message := wf_core.translate('WF_WS_CLASS_DERIVED');

1776: p_err_code := -1;
1777: wf_core.token('BaseClassId',p_base_object_id);
1778: wf_core.token('BaseClassName', p_base_object_name);
1779: wf_core.token('SqlErr',SQLERRM);
1780: p_err_message := wf_core.translate('WF_WS_CLASS_DERIVED');
1781: end create_object_derived_entry;
1782:
1783: /**
1784: Procedure for creating a Derived Entry for all functions of a base Object Entry

Line 1834: p_err_message := wf_core.translate('WF_WS_MISSING_CLASS_FUNC_ID');

1830:
1831:
1832: if ( (p_base_object_id is null) or (p_base_function_id is null)) then
1833: p_err_code := -1;
1834: p_err_message := wf_core.translate('WF_WS_MISSING_CLASS_FUNC_ID');
1835: raise program_exit;
1836: end if;
1837:
1838:

Line 1850: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');

1846: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'oracle.apps.fnd.wf.ws.create.obj.function.derived.entry', 'Base Object ID='||p_base_object_id||' does not exist');
1847: end if;
1848:
1849: p_err_code := -1;
1850: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');
1851: raise program_exit;
1852:
1853: elsif c_base_object_entry%FOUND then
1854:

Line 1871: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_MISMATCH');

1867: end if;
1868:
1869: if ( c_base_function_entry_rec.irep_class_id <> p_base_object_id ) then
1870: p_err_code :=-1;
1871: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_MISMATCH');
1872: raise program_exit;
1873: end if;
1874:
1875: if ( c_base_object_entry_rec.irep_scope = 'PUBLIC' AND c_base_function_entry_rec.irep_scope = 'PUBLIC' ) then

Line 1897: p_err_message :=wf_core.translate('WF_WS_MISSING_IREP_METHOD_NAME');

1893: --dbms_output.put_line('I_Operation='||i_operation||'x');
1894: --dbms_output.put_line('I_Operation length='||length(i_operation)||'x');
1895: if ( (i_operation is null ) or (length(i_operation) is NULL ) ) then
1896: p_err_code := -1;
1897: p_err_message :=wf_core.translate('WF_WS_MISSING_IREP_METHOD_NAME');
1898: raise program_exit;
1899: end if;
1900:
1901:

Line 1996: p_err_message := wf_core.translate('WF_WS_NOT_PUBLIC');

1992: ||c_base_object_entry_rec.object_id||','||c_base_function_entry_rec.function_id||' Not a public interface/method to be exposed');
1993: end if;
1994:
1995: p_err_code := -1;
1996: p_err_message := wf_core.translate('WF_WS_NOT_PUBLIC');
1997: raise program_exit;
1998: end if;
1999: else
2000: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2005: p_err_message := wf_core.translate('WF_WS_BASE_FUNC_NOT_EXIST');

2001: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'oracle.apps.fnd.wf.ws.create.obj.function.derived.entry', ' No records found for FunctionID='||c_base_function_entry_rec.function_id);
2002: end if;
2003:
2004: p_err_code := -1;
2005: p_err_message := wf_core.translate('WF_WS_BASE_FUNC_NOT_EXIST');
2006: raise program_exit;
2007: end if;
2008:
2009: close c_base_function_entry;

Line 2016: --wf_core.token('ClassId',p_base_class_id);

2012: close c_base_object_entry;
2013:
2014: p_err_code := 0;
2015: --todo create new token
2016: --wf_core.token('ClassId',p_base_class_id);
2017: p_err_message :=wf_core.translate('WF_WS_SUCCESS');
2018:
2019: exception
2020: when ignore_rec then

Line 2017: p_err_message :=wf_core.translate('WF_WS_SUCCESS');

2013:
2014: p_err_code := 0;
2015: --todo create new token
2016: --wf_core.token('ClassId',p_base_class_id);
2017: p_err_message :=wf_core.translate('WF_WS_SUCCESS');
2018:
2019: exception
2020: when ignore_rec then
2021: raise ignore_rec;

Line 2026: p_err_message :=wf_core.translate('WF_WS_GENERIC_CLASS_ERROR')||'Error in Creating Derived Entry for Base FUNCTION_ID='||p_base_function_id||SQLERRM;

2022: when program_exit then
2023: raise program_exit;
2024: when others then
2025: p_err_code := -1;
2026: p_err_message :=wf_core.translate('WF_WS_GENERIC_CLASS_ERROR')||'Error in Creating Derived Entry for Base FUNCTION_ID='||p_base_function_id||SQLERRM;
2027: raise program_exit;
2028: end create_obj_func_derived_entry;
2029:
2030:

Line 2063: p_err_message := wf_core.translate('WF_WS_MISSING_CLASS_FUNC_ID');

2059:
2060:
2061: if ( p_base_object_id is null) then
2062: p_err_code := -1;
2063: p_err_message := wf_core.translate('WF_WS_MISSING_CLASS_FUNC_ID');
2064: raise program_exit;
2065: end if;
2066:
2067:

Line 2079: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');

2075: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'oracle.apps.fnd.wf.ws.create_object_function_base_entry', 'Base Object ID='||p_base_object_id||' does not exist');
2076: end if;
2077:
2078: p_err_code := -1;
2079: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');
2080: raise program_exit;
2081:
2082: elsif c_base_object_entry%FOUND then
2083:

Line 2103: p_err_message :=wf_core.translate('WF_WS_MISSING_IREP_METHOD_NAME');

2099:
2100: --dbms_output.put_line('Function ='||p_function_name);
2101: if ( (p_function_name is null ) or (length(p_function_name) is NULL ) ) then
2102: p_err_code := -1;
2103: p_err_message :=wf_core.translate('WF_WS_MISSING_IREP_METHOD_NAME');
2104: raise program_exit;
2105: end if;
2106:
2107:

Line 2199: p_err_message := wf_core.translate('WF_WS_NOT_PUBLIC');

2195: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'oracle.apps.fnd.wf.ws.create_object_function_base_entry', 'objectID:'||c_base_object_entry_rec.object_id||' Not a public interface to be exposed');
2196: end if;
2197:
2198: p_err_code := -1;
2199: p_err_message := wf_core.translate('WF_WS_NOT_PUBLIC');
2200: raise program_exit;
2201: end if;
2202:
2203:

Line 2210: --wf_core.token('BaseClassId',p_base_object_id);

2206: close c_base_object_entry;
2207:
2208: p_err_code := 0;
2209: -- todo create new tokens for successful message.
2210: --wf_core.token('BaseClassId',p_base_object_id);
2211: --p_err_message :=wf_core.translate('WF_WS_SUCCESS');
2212:
2213: exception
2214: when ignore_rec then

Line 2211: --p_err_message :=wf_core.translate('WF_WS_SUCCESS');

2207:
2208: p_err_code := 0;
2209: -- todo create new tokens for successful message.
2210: --wf_core.token('BaseClassId',p_base_object_id);
2211: --p_err_message :=wf_core.translate('WF_WS_SUCCESS');
2212:
2213: exception
2214: when ignore_rec then
2215: raise ignore_rec;

Line 2220: p_err_message :=wf_core.translate('WF_WS_GENERIC_object_ERROR')||'Error in Creating Base Entry for Base object_ID='||p_base_object_id||SQLERRM;

2216: when program_exit then
2217: raise program_exit;
2218: when others then
2219: p_err_code := -1;
2220: p_err_message :=wf_core.translate('WF_WS_GENERIC_object_ERROR')||'Error in Creating Base Entry for Base object_ID='||p_base_object_id||SQLERRM;
2221: raise program_exit;
2222: end create_obj_function_base_entry;
2223:
2224: end SOA_GENERATE;