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.EGO_PUB_WS_VS dependencies on EGO_PUB_WS_UTIL

Line 158: EGO_PUB_WS_UTIL.Populate_Input_Identifier( p_session_id => p_session_id,

154: debug(1, l_proc_name||'id is valid');
155: EXCEPTION
156: WHEN NO_DATA_FOUND THEN
157: l_index := get_max_input_identifier(p_session_id);
158: EGO_PUB_WS_UTIL.Populate_Input_Identifier( p_session_id => p_session_id,
159: p_input_id => l_index,
160: p_param_name => 'ValueSetId',
161: p_param_value => l_vs_id
162: );

Line 164: EGO_PUB_WS_UTIL.Log_Error( p_session_id => p_session_id,

160: p_param_name => 'ValueSetId',
161: p_param_value => l_vs_id
162: );
163:
164: EGO_PUB_WS_UTIL.Log_Error( p_session_id => p_session_id,
165: p_input_id => l_index,
166: p_err_code => 'EGO_INVALID_VS_ID',
167: p_err_message => 'Invalid Value Set Id');
168:

Line 187: EGO_PUB_WS_UTIL.Populate_Input_Identifier( p_session_id => p_session_id,

183: x_vs_name := l_vs_name;
184: EXCEPTION
185: WHEN NO_DATA_FOUND THEN
186: l_index := get_max_input_identifier(p_session_id);
187: EGO_PUB_WS_UTIL.Populate_Input_Identifier( p_session_id => p_session_id,
188: p_input_id => l_index,
189: p_param_name => 'ValueSetName',
190: p_param_value => l_vs_name
191: );

Line 193: EGO_PUB_WS_UTIL.Log_Error( p_session_id => p_session_id,

189: p_param_name => 'ValueSetName',
190: p_param_value => l_vs_name
191: );
192:
193: EGO_PUB_WS_UTIL.Log_Error( p_session_id => p_session_id,
194: p_input_id => l_index,
195: p_err_code => 'EGO_INVALID_VS_NAME',
196: p_err_message => 'Invalid Value Set Name');
197: debug(1, l_proc_name||'Invalid value set name');

Line 216: EGO_PUB_WS_UTIL.Populate_Input_Identifier( p_session_id => p_session_id,

212: AND
213: p_vs_id <> l_vs_id THEN
214: l_index := get_max_input_identifier(p_session_id);
215:
216: EGO_PUB_WS_UTIL.Populate_Input_Identifier( p_session_id => p_session_id,
217: p_input_id => l_index,
218: p_param_name => 'ValueSetId',
219: p_param_value => l_vs_id
220: );

Line 222: EGO_PUB_WS_UTIL.Populate_Input_Identifier( p_session_id => p_session_id,

218: p_param_name => 'ValueSetId',
219: p_param_value => l_vs_id
220: );
221:
222: EGO_PUB_WS_UTIL.Populate_Input_Identifier( p_session_id => p_session_id,
223: p_input_id => l_index,
224: p_param_name => 'ValueSetName',
225: p_param_value => l_vs_name
226: );

Line 229: EGO_PUB_WS_UTIL.Log_Error( p_session_id => p_session_id,

225: p_param_value => l_vs_name
226: );
227:
228:
229: EGO_PUB_WS_UTIL.Log_Error( p_session_id => p_session_id,
230: p_input_id => l_index,
231: p_err_code => 'EGO_INVALID_VS_ID_COMBO',
232: p_err_message => 'Invalid Value Set Id name combination'
233: );

Line 254: EGO_PUB_WS_UTIL.Populate_Input_Identifier( p_session_id => p_session_id,

250: WHEN NO_DATA_FOUND THEN
251:
252: l_index := get_max_input_identifier(p_session_id);
253:
254: EGO_PUB_WS_UTIL.Populate_Input_Identifier( p_session_id => p_session_id,
255: p_input_id => l_index,
256: p_param_name => 'ValueSetId',
257: p_param_value => l_vs_id
258: );

Line 260: EGO_PUB_WS_UTIL.Populate_Input_Identifier( p_session_id => p_session_id,

256: p_param_name => 'ValueSetId',
257: p_param_value => l_vs_id
258: );
259:
260: EGO_PUB_WS_UTIL.Populate_Input_Identifier( p_session_id => p_session_id,
261: p_input_id => l_index,
262: p_param_name => 'ValueSetVersion',
263: p_param_value => l_vs_version
264: );

Line 267: EGO_PUB_WS_UTIL.Log_Error( p_session_id => p_session_id,

263: p_param_value => l_vs_version
264: );
265:
266:
267: EGO_PUB_WS_UTIL.Log_Error( p_session_id => p_session_id,
268: p_input_id => l_index,
269: p_err_code => 'EGO_INVALID_VS_VERSION',
270: p_err_message => 'Invalid Value Set Version'
271: );

Line 436: l_mode := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'MODE', NULL, NULL);

432:
433: ---
434: --- identify web service invocation mode
435: ---
436: l_mode := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'MODE', NULL, NULL);
437: debug(1, l_proc_name||'Finish fetch mode=>'||l_mode);
438:
439: l_batch_id := NULL;
440: IF l_mode = 'BATCH' THEN

Line 454: EGO_PUB_WS_UTIL.Init_Security(p_session_id, l_web_service_name);

450:
451: ---
452: --- Initialize FND security
453: ---
454: EGO_PUB_WS_UTIL.Init_Security(p_session_id, l_web_service_name);
455: debug(2,l_proc_name||'Check access and initialize security');
456:
457:
458: FOR rec_get_vs_to_explode IN cur_get_vs_to_explode

Line 571: l_xpath_expr EGO_PUB_WS_UTIL.xpath_expr_array_type;

567: l_config_option VARCHAR2(100);
568: l_language_search_str VARCHAR2(1000);
569:
570: --array to store XML path expressions to retrieve single-value params
571: l_xpath_expr EGO_PUB_WS_UTIL.xpath_expr_array_type;
572:
573: --array to store single_value parameter names
574: l_param_names EGO_PUB_WS_UTIL.parameter_name_array_type;
575: l_proc_name VARCHAR2(50) := 'Create_Params_Value_Set=>';

Line 574: l_param_names EGO_PUB_WS_UTIL.parameter_name_array_type;

570: --array to store XML path expressions to retrieve single-value params
571: l_xpath_expr EGO_PUB_WS_UTIL.xpath_expr_array_type;
572:
573: --array to store single_value parameter names
574: l_param_names EGO_PUB_WS_UTIL.parameter_name_array_type;
575: l_proc_name VARCHAR2(50) := 'Create_Params_Value_Set=>';
576: l_trigger_import VARCHAR2(1) := NULL;
577: l_return_payload VARCHAR2(10) := NULL;
578: l_explode_child_vs VARCHAR2(10) := NULL;

Line 597: l_mode := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'MODE', NULL, NULL);

593: WHERE PARAMETER_NAME = 'MODE'
594: AND session_id = p_session_id;
595: */
596:
597: l_mode := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'MODE', NULL, NULL);
598: g_mode := l_mode;
599: debug(1, l_proc_name||'Finish fetch mode=>'||l_mode);
600:
601: --get invocation mode for the web service

Line 648: l_trigger_import := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id => p_session_id,

644: l_web_service_name);
645: debug(3, l_proc_name||'Inserted CHILD_VALUESETS=>'||l_explode_child_vs);
646:
647:
648: l_trigger_import := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id => p_session_id,
649: p_param_name => EGO_PUB_WS_UTIL.G_TRIGGER_IMPORT_PARAM,
650: p_batch_id => l_batch_id,
651: p_mode => 'BATCH'
652: );

Line 649: p_param_name => EGO_PUB_WS_UTIL.G_TRIGGER_IMPORT_PARAM,

645: debug(3, l_proc_name||'Inserted CHILD_VALUESETS=>'||l_explode_child_vs);
646:
647:
648: l_trigger_import := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id => p_session_id,
649: p_param_name => EGO_PUB_WS_UTIL.G_TRIGGER_IMPORT_PARAM,
650: p_batch_id => l_batch_id,
651: p_mode => 'BATCH'
652: );
653:

Line 673: l_publish_sync := EGO_PUB_WS_UTIL.Get_Char_Param_Value ( p_session_id => p_session_id,

669: l_web_service_name);
670:
671: debug(3, l_proc_name||'Inserted TRIGGER_IMPORT=>'||NVL(l_trigger_import,'N'));
672:
673: l_publish_sync := EGO_PUB_WS_UTIL.Get_Char_Param_Value ( p_session_id => p_session_id,
674: p_param_name => EGO_PUB_WS_UTIL.G_SYNC_PARAM,
675: p_batch_id => l_batch_id,
676: p_mode => 'BATCH'
677: );

Line 674: p_param_name => EGO_PUB_WS_UTIL.G_SYNC_PARAM,

670:
671: debug(3, l_proc_name||'Inserted TRIGGER_IMPORT=>'||NVL(l_trigger_import,'N'));
672:
673: l_publish_sync := EGO_PUB_WS_UTIL.Get_Char_Param_Value ( p_session_id => p_session_id,
674: p_param_name => EGO_PUB_WS_UTIL.G_SYNC_PARAM,
675: p_batch_id => l_batch_id,
676: p_mode => 'BATCH'
677: );
678: IF l_publish_sync = 'PUBLISH' THEN

Line 695: EGO_PUB_WS_UTIL.G_SYNC_PARAM,

691: created_by,
692: web_service_name)
693: VALUES (p_session_id,
694: p_session_id,
695: EGO_PUB_WS_UTIL.G_SYNC_PARAM,
696: 2,
697: l_publish_sync,
698: sysdate,
699: fnd_global.user_id,

Line 736: l_param_names := EGO_PUB_WS_UTIL.parameter_name_array_type();

732: -- AND STORE THEM IN TABLE EGO_PUB_WS_CONFIG
733: --
734:
735: --initialize arrays of parameter names
736: l_param_names := EGO_PUB_WS_UTIL.parameter_name_array_type();
737: EGO_PUB_WS_UTIL.Get_Parameter_Names(l_web_service_name, l_param_names);
738: debug(3, l_proc_name||'Finish fetch param names');
739:
740: l_xpath_expr := EGO_PUB_WS_UTIL.xpath_expr_array_type();

Line 737: EGO_PUB_WS_UTIL.Get_Parameter_Names(l_web_service_name, l_param_names);

733: --
734:
735: --initialize arrays of parameter names
736: l_param_names := EGO_PUB_WS_UTIL.parameter_name_array_type();
737: EGO_PUB_WS_UTIL.Get_Parameter_Names(l_web_service_name, l_param_names);
738: debug(3, l_proc_name||'Finish fetch param names');
739:
740: l_xpath_expr := EGO_PUB_WS_UTIL.xpath_expr_array_type();
741: EGO_PUB_WS_UTIL.Get_Xpath_Expr(l_web_service_name, l_xpath_expr);

Line 740: l_xpath_expr := EGO_PUB_WS_UTIL.xpath_expr_array_type();

736: l_param_names := EGO_PUB_WS_UTIL.parameter_name_array_type();
737: EGO_PUB_WS_UTIL.Get_Parameter_Names(l_web_service_name, l_param_names);
738: debug(3, l_proc_name||'Finish fetch param names');
739:
740: l_xpath_expr := EGO_PUB_WS_UTIL.xpath_expr_array_type();
741: EGO_PUB_WS_UTIL.Get_Xpath_Expr(l_web_service_name, l_xpath_expr);
742: debug(5, l_proc_name||'Finish fetch param XML tags');
743:
744: --retrieve all single-value parameters of interest from XML

Line 741: EGO_PUB_WS_UTIL.Get_Xpath_Expr(l_web_service_name, l_xpath_expr);

737: EGO_PUB_WS_UTIL.Get_Parameter_Names(l_web_service_name, l_param_names);
738: debug(3, l_proc_name||'Finish fetch param names');
739:
740: l_xpath_expr := EGO_PUB_WS_UTIL.xpath_expr_array_type();
741: EGO_PUB_WS_UTIL.Get_Xpath_Expr(l_web_service_name, l_xpath_expr);
742: debug(5, l_proc_name||'Finish fetch param XML tags');
743:
744: --retrieve all single-value parameters of interest from XML
745: --and store them in table EGO_PUB_WS_CONFIG

Line 749: l_config_option := upper(EGO_PUB_WS_UTIL.Get_ODI_Input_Parameter(p_session_id, l_xpath_expr(position)));

745: --and store them in table EGO_PUB_WS_CONFIG
746: FOR position IN 1..l_param_names.COUNT
747: LOOP
748:
749: l_config_option := upper(EGO_PUB_WS_UTIL.Get_ODI_Input_Parameter(p_session_id, l_xpath_expr(position)));
750: debug(5, l_proc_name||'counter=>'||position||'Finish fetch config option=>'||l_config_option);
751:
752: --if parameter is not provided, assume a default value of 'Y' (Yes)
753:

Line 778: EGO_PUB_WS_UTIL.Create_Fnd_Security(p_session_id,

774: END LOOP;
775: END IF;
776:
777: debug(5, l_proc_name||'start security option');
778: EGO_PUB_WS_UTIL.Create_Fnd_Security(p_session_id,
779: l_mode,
780: l_batch_id,
781: l_web_service_name
782: );

Line 792: l_language_search_str := EGO_PUB_WS_UTIL.Get_Language_Search_Str(l_web_service_name);

788:
789: --- this may not be required for Value Sets
790: ---
791: --RETRIEVING LIST OF LANGUAGES
792: l_language_search_str := EGO_PUB_WS_UTIL.Get_Language_Search_Str(l_web_service_name);
793: debug(7, l_proc_name||'Finish language search'||l_language_search_str);
794:
795: --Inserts language options in Config table
796: EGO_PUB_WS_UTIL.Config_Languages( p_session_id,

Line 796: EGO_PUB_WS_UTIL.Config_Languages( p_session_id,

792: l_language_search_str := EGO_PUB_WS_UTIL.Get_Language_Search_Str(l_web_service_name);
793: debug(7, l_proc_name||'Finish language search'||l_language_search_str);
794:
795: --Inserts language options in Config table
796: EGO_PUB_WS_UTIL.Config_Languages( p_session_id,
797: l_language_search_str,
798: l_web_service_name
799: );
800: debug(7, l_proc_name||'Finish config language');

Line 992: l_mode := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'MODE', NULL, NULL);

988: debug(1,l_proc_name||'start');
989:
990:
991: --identify web service invocation mode
992: l_mode := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'MODE', NULL, NULL);
993: debug(1, l_proc_name||'Finish fetch mode=>'||l_mode);
994:
995: --populate odi input table depending on mode from different data sources
996: CASE

Line 1173: EGO_PUB_WS_UTIL.Write_Errors_ToBatFwk ( p_session_id => p_session_id , p_batch_id => p_batch_id);

1169: l_proc_name VARCHAR2(50) := 'Write_Error_Entites_ToBatFwk=>';
1170:
1171: BEGIN
1172:
1173: EGO_PUB_WS_UTIL.Write_Errors_ToBatFwk ( p_session_id => p_session_id , p_batch_id => p_batch_id);
1174:
1175: END Write_Error_Entites_ToBatFwk;
1176:
1177:

Line 1236: l_child_vs_param := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'CHILD_VALUESETS', NULL, NULL);

1232:
1233:
1234: debug(5, l_proc_name||'call fetch CHILD_VALUESETS batch, mode=>'||g_batch_id||','||g_mode);
1235:
1236: l_child_vs_param := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'CHILD_VALUESETS', NULL, NULL);
1237: debug(1, l_proc_name||'Finish fetch CHILD_VALUESETS=>'||l_child_vs_param);
1238:
1239: IF l_child_vs_param = 'TRUE' THEN
1240: ---