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.

[Home] [Help]

APPS.EGO_PUB_WS_ICC dependencies on EGO_PUB_WS_UTIL

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

126: L_PROC_NAME := ' Validate_ICC=> ';
127: --debug(L_PROC_NAME||' Start');
128: --debug(L_PROC_NAME||' p_session_id: '||p_session_id||' ,p_icc_id: '||p_icc_id||' ,p_icc_name: '||p_icc_name||' ,p_icc_ver_id: '||p_icc_ver_id);
129:
130: l_mode := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'MODE', NULL, NULL);
131: --debug(L_PROC_NAME||' MODE: '||l_mode);
132:
133: /* SOAPUI inserts '?' for null values and
134: in create_entities_icc procedure we read null or non-existant tag as '-1' */

Line 172: l_index := EGO_PUB_WS_UTIL.get_max_input_identifier(p_session_id);

168: EXCEPTION
169: WHEN NO_DATA_FOUND
170: THEN
171: --debug(L_PROC_NAME||' icc_name not found for p_icc_id: '||p_icc_id);
172: l_index := EGO_PUB_WS_UTIL.get_max_input_identifier(p_session_id);
173:
174: EGO_PUB_WS_UTIL.Populate_Input_Identifier( p_session_id => p_session_id,
175: p_input_id => l_index,
176: p_param_name => 'ICCId',

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

170: THEN
171: --debug(L_PROC_NAME||' icc_name not found for p_icc_id: '||p_icc_id);
172: l_index := EGO_PUB_WS_UTIL.get_max_input_identifier(p_session_id);
173:
174: EGO_PUB_WS_UTIL.Populate_Input_Identifier( p_session_id => p_session_id,
175: p_input_id => l_index,
176: p_param_name => 'ICCId',
177: p_param_value => p_icc_id);
178:

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

175: p_input_id => l_index,
176: p_param_name => 'ICCId',
177: p_param_value => p_icc_id);
178:
179: EGO_PUB_WS_UTIL.Log_Error( p_session_id => p_session_id,
180: p_input_id => l_index,
181: p_err_code => 'EGO_INVALID_ICC_ID',
182: p_err_message => 'Invalid Item Catalog Category ID.
183: The ICC Id entered by user is invalid in input XML.');

Line 205: l_index := EGO_PUB_WS_UTIL.get_max_input_identifier(p_session_id);

201: EXCEPTION
202: WHEN NO_DATA_FOUND
203: THEN
204: --debug(L_PROC_NAME||' icc_id not found for p_icc_name: '||p_icc_name);
205: l_index := EGO_PUB_WS_UTIL.get_max_input_identifier(p_session_id);
206:
207: EGO_PUB_WS_UTIL.Populate_Input_Identifier( p_session_id => p_session_id,
208: p_input_id => l_index,
209: p_param_name => 'ICCName',

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

203: THEN
204: --debug(L_PROC_NAME||' icc_id not found for p_icc_name: '||p_icc_name);
205: l_index := EGO_PUB_WS_UTIL.get_max_input_identifier(p_session_id);
206:
207: EGO_PUB_WS_UTIL.Populate_Input_Identifier( p_session_id => p_session_id,
208: p_input_id => l_index,
209: p_param_name => 'ICCName',
210: p_param_value => p_icc_name);
211:

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

208: p_input_id => l_index,
209: p_param_name => 'ICCName',
210: p_param_value => p_icc_name);
211:
212: EGO_PUB_WS_UTIL.Log_Error( p_session_id => p_session_id,
213: p_input_id => l_index,
214: p_err_code => 'EGO_INVALID_ICC_NAME',
215: p_err_message => 'Invalid Item Catalog Category Name.
216: The ICC Name entered by user is invalid. ');

Line 240: l_index := EGO_PUB_WS_UTIL.get_max_input_identifier(p_session_id);

236:
237: /* If version exists but is a past effective version, then log the error */
238: IF (l_end_date IS NOT NULL AND (l_end_date < SYSDATE)) THEN
239: --debug(L_PROC_NAME||'Versions with past end date cannot be synced');
240: l_index := EGO_PUB_WS_UTIL.get_max_input_identifier(p_session_id);
241:
242: EGO_PUB_WS_UTIL.Populate_Input_Identifier( p_session_id => p_session_id,
243: p_input_id => l_index,
244: p_param_name => 'ICCId',

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

238: IF (l_end_date IS NOT NULL AND (l_end_date < SYSDATE)) THEN
239: --debug(L_PROC_NAME||'Versions with past end date cannot be synced');
240: l_index := EGO_PUB_WS_UTIL.get_max_input_identifier(p_session_id);
241:
242: EGO_PUB_WS_UTIL.Populate_Input_Identifier( p_session_id => p_session_id,
243: p_input_id => l_index,
244: p_param_name => 'ICCId',
245: p_param_value => p_icc_id);
246:

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

243: p_input_id => l_index,
244: p_param_name => 'ICCId',
245: p_param_value => p_icc_id);
246:
247: EGO_PUB_WS_UTIL.Populate_Input_Identifier( p_session_id => p_session_id,
248: p_input_id => l_index,
249: p_param_name => 'ICCVer',
250: p_param_value => p_icc_ver_id);
251:

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

248: p_input_id => l_index,
249: p_param_name => 'ICCVer',
250: p_param_value => p_icc_ver_id);
251:
252: EGO_PUB_WS_UTIL.Log_Error( p_session_id => p_session_id,
253: p_input_id => l_index,
254: p_err_code => 'EGO_PAST_VER_NOT_SYNC',
255: p_err_message => 'Unable to publish versions with an invalid effective date.
256: User is trying to sync past effective ICC versions.');

Line 267: l_index := EGO_PUB_WS_UTIL.get_max_input_identifier(p_session_id);

263: WHEN NO_DATA_FOUND
264: THEN
265: /* When the version itself does not exist for that icc */
266: --debug(L_PROC_NAME||'Invalid ICC Version');
267: l_index := EGO_PUB_WS_UTIL.get_max_input_identifier(p_session_id);
268:
269: EGO_PUB_WS_UTIL.Populate_Input_Identifier( p_session_id => p_session_id,
270: p_input_id => l_index,
271: p_param_name => 'ICCId',

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

265: /* When the version itself does not exist for that icc */
266: --debug(L_PROC_NAME||'Invalid ICC Version');
267: l_index := EGO_PUB_WS_UTIL.get_max_input_identifier(p_session_id);
268:
269: EGO_PUB_WS_UTIL.Populate_Input_Identifier( p_session_id => p_session_id,
270: p_input_id => l_index,
271: p_param_name => 'ICCId',
272: p_param_value => p_icc_id);
273:

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

270: p_input_id => l_index,
271: p_param_name => 'ICCId',
272: p_param_value => p_icc_id);
273:
274: EGO_PUB_WS_UTIL.Populate_Input_Identifier( p_session_id => p_session_id,
275: p_input_id => l_index,
276: p_param_name => 'ICCVer',
277: p_param_value => p_icc_ver_id);
278:

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

275: p_input_id => l_index,
276: p_param_name => 'ICCVer',
277: p_param_value => p_icc_ver_id);
278:
279: EGO_PUB_WS_UTIL.Log_Error( p_session_id => p_session_id,
280: p_input_id => l_index,
281: p_err_code => 'EGO_INVALID_ICC_VER',
282: p_err_message => 'Invalid Item Catalog Category Version.
283: The ICC Version Number entered by user is invalid. ');

Line 480: l_xpath_expr EGO_PUB_WS_UTIL.xpath_expr_array_type;

476: l_trigger_import VARCHAR2(1);
477: l_publish_sync VARCHAR2(10);
478:
479: --array to store XML path expressions to retrieve single-value params
480: l_xpath_expr EGO_PUB_WS_UTIL.xpath_expr_array_type;
481:
482: --array to store single_value parameter names
483: l_param_names EGO_PUB_WS_UTIL.parameter_name_array_type;
484:

Line 483: l_param_names EGO_PUB_WS_UTIL.parameter_name_array_type;

479: --array to store XML path expressions to retrieve single-value params
480: l_xpath_expr EGO_PUB_WS_UTIL.xpath_expr_array_type;
481:
482: --array to store single_value parameter names
483: l_param_names EGO_PUB_WS_UTIL.parameter_name_array_type;
484:
485: L_PROC_NAME VARCHAR2(50);
486: BEGIN
487:

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

488: L_PROC_NAME := ' Create_Params_ICC=> ';
489: --debug(L_PROC_NAME||' Start');
490: --debug(L_PROC_NAME||' Parameters - p_session_id: '||p_session_id);
491:
492: l_mode := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'MODE', NULL, NULL);
493: --debug(L_PROC_NAME||'Param Value of MODE: '||l_mode);
494:
495: --get web service name
496: SELECT WEB_SERVICE_NAME

Line 508: l_batch_id := EGO_PUB_WS_UTIL.Get_Numeric_Param_Value(p_session_id, 'BATCH_ID', NULL, NULL);

504: IF l_mode = 'BATCH' THEN
505: /*BATCH_ID param is available only in ego_pub_ws_config and not in ego_pub_bat_params_b.
506: The Batch UI does not insert this param. The ServiceUtil inserts it into ego_pub_ws_config.
507: Hence for fetching the BATCH_ID, we are passing the mode as NULL.*/
508: l_batch_id := EGO_PUB_WS_UTIL.Get_Numeric_Param_Value(p_session_id, 'BATCH_ID', NULL, NULL);
509: --debug(L_PROC_NAME||'Batch_Id: '||l_batch_id);
510:
511: /* In Batch Mode, the following parameters have to be taken from EGO_PUB_BAT_PARAMS_B table
512: PARENTICCS,CHILDICCS,TRIGGER_IMPORT(aka LAUNCH_SYNC_CONC_PROG),SYNC (aka BATCH_PROCESS_TYPE)

Line 518: --debug(L_PROC_NAME||'Batch Mode Calling EGO_PUB_WS_UTIL.Get_Parameter_Names procedure');

514: USERDEFATTRGRPS,VALUESETS,ICCVERSIONS, TRANSATTRS,ICCPAGES,ICCFUNCTIONS,ICCSTRUCTURE, RETURN_PAYLOAD
515: */
516:
517: --initialize arrays of parameter names
518: --debug(L_PROC_NAME||'Batch Mode Calling EGO_PUB_WS_UTIL.Get_Parameter_Names procedure');
519: l_param_names := EGO_PUB_WS_UTIL.parameter_name_array_type();
520: EGO_PUB_WS_UTIL.Get_Parameter_Names(l_web_service_name, l_param_names);
521: --debug(L_PROC_NAME||'Batch Mode, Returned from EGO_PUB_WS_UTIL.Get_Parameter_Names procedure, l_param_names.count: '||l_param_names.count);
522:

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

515: */
516:
517: --initialize arrays of parameter names
518: --debug(L_PROC_NAME||'Batch Mode Calling EGO_PUB_WS_UTIL.Get_Parameter_Names procedure');
519: l_param_names := EGO_PUB_WS_UTIL.parameter_name_array_type();
520: EGO_PUB_WS_UTIL.Get_Parameter_Names(l_web_service_name, l_param_names);
521: --debug(L_PROC_NAME||'Batch Mode, Returned from EGO_PUB_WS_UTIL.Get_Parameter_Names procedure, l_param_names.count: '||l_param_names.count);
522:
523:

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

516:
517: --initialize arrays of parameter names
518: --debug(L_PROC_NAME||'Batch Mode Calling EGO_PUB_WS_UTIL.Get_Parameter_Names procedure');
519: l_param_names := EGO_PUB_WS_UTIL.parameter_name_array_type();
520: EGO_PUB_WS_UTIL.Get_Parameter_Names(l_web_service_name, l_param_names);
521: --debug(L_PROC_NAME||'Batch Mode, Returned from EGO_PUB_WS_UTIL.Get_Parameter_Names procedure, l_param_names.count: '||l_param_names.count);
522:
523:
524: --retrieve all single-value parameters of interest from EGO_PUB_BAT_PARAMS_B table

Line 521: --debug(L_PROC_NAME||'Batch Mode, Returned from EGO_PUB_WS_UTIL.Get_Parameter_Names procedure, l_param_names.count: '||l_param_names.count);

517: --initialize arrays of parameter names
518: --debug(L_PROC_NAME||'Batch Mode Calling EGO_PUB_WS_UTIL.Get_Parameter_Names procedure');
519: l_param_names := EGO_PUB_WS_UTIL.parameter_name_array_type();
520: EGO_PUB_WS_UTIL.Get_Parameter_Names(l_web_service_name, l_param_names);
521: --debug(L_PROC_NAME||'Batch Mode, Returned from EGO_PUB_WS_UTIL.Get_Parameter_Names procedure, l_param_names.count: '||l_param_names.count);
522:
523:
524: --retrieve all single-value parameters of interest from EGO_PUB_BAT_PARAMS_B table
525: --and store them in table EGO_PUB_WS_CONFIG

Line 555: l_param_parent_hier := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id => p_session_id,

551:
552: /* The below insert statements take care of the params that have to be taken from EGO_PUB_BAT_PARAMS_B table*/
553:
554: /* Batch Mode param PublishParent will be inserted into ego_pub_ws_config as PARENTICCS */
555: l_param_parent_hier := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id => p_session_id,
556: p_param_name => 'PublishParent',
557: p_batch_id => l_batch_id,
558: p_mode => 'BATCH'
559: );

Line 586: l_param_child_hier := EGO_PUB_WS_UTIL.Get_Char_Param_Value ( p_session_id => p_session_id,

582: END;
583:
584:
585: /* Batch Mode param PublishChild will be inserted into ego_pub_ws_config as CHILDICCS */
586: l_param_child_hier := EGO_PUB_WS_UTIL.Get_Char_Param_Value ( p_session_id => p_session_id,
587: p_param_name => 'PublishChild',
588: p_batch_id => l_batch_id,
589: p_mode => 'BATCH'
590: );

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

606: G_CURRENT_USER_ID,
607: l_web_service_name);
608:
609: /* Batch Mode param Launch Sync Program will be inserted into ego_pub_ws_config as TRIGGER_IMPORT */
610: l_trigger_import := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id => p_session_id,
611: p_param_name => EGO_PUB_WS_UTIL.G_TRIGGER_IMPORT_PARAM,
612: p_batch_id => l_batch_id,
613: p_mode => 'BATCH'
614: );

Line 611: p_param_name => EGO_PUB_WS_UTIL.G_TRIGGER_IMPORT_PARAM,

607: l_web_service_name);
608:
609: /* Batch Mode param Launch Sync Program will be inserted into ego_pub_ws_config as TRIGGER_IMPORT */
610: l_trigger_import := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id => p_session_id,
611: p_param_name => EGO_PUB_WS_UTIL.G_TRIGGER_IMPORT_PARAM,
612: p_batch_id => l_batch_id,
613: p_mode => 'BATCH'
614: );
615:

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

631: l_web_service_name);
632:
633:
634: /* Batch Mode param BATCH_PROCESS_TYPE=PUBLISH/SYNC will be inserted into ego_pub_ws_config as SYNC=Y/N */
635: l_publish_sync := EGO_PUB_WS_UTIL.Get_Char_Param_Value ( p_session_id => p_session_id,
636: p_param_name => EGO_PUB_WS_UTIL.G_SYNC_PARAM,
637: p_batch_id => l_batch_id,
638: p_mode => 'BATCH'
639: );

Line 636: p_param_name => EGO_PUB_WS_UTIL.G_SYNC_PARAM,

632:
633:
634: /* Batch Mode param BATCH_PROCESS_TYPE=PUBLISH/SYNC will be inserted into ego_pub_ws_config as SYNC=Y/N */
635: l_publish_sync := EGO_PUB_WS_UTIL.Get_Char_Param_Value ( p_session_id => p_session_id,
636: p_param_name => EGO_PUB_WS_UTIL.G_SYNC_PARAM,
637: p_batch_id => l_batch_id,
638: p_mode => 'BATCH'
639: );
640: IF l_publish_sync = 'PUBLISH' THEN

Line 673: --debug(L_PROC_NAME||'List Mode, Calling EGO_PUB_WS_UTIL.Get_Parameter_Names procedure');

669: -- AND STORE THEM IN TABLE EGO_PUB_WS_CONFIG
670: --
671:
672: --initialize arrays of parameter names
673: --debug(L_PROC_NAME||'List Mode, Calling EGO_PUB_WS_UTIL.Get_Parameter_Names procedure');
674: l_param_names := EGO_PUB_WS_UTIL.parameter_name_array_type();
675: EGO_PUB_WS_UTIL.Get_Parameter_Names(l_web_service_name, l_param_names);
676: --debug(L_PROC_NAME||'List Mode, Returned from EGO_PUB_WS_UTIL.Get_Parameter_Names procedure, l_param_names.count: '||l_param_names.count);
677:

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

670: --
671:
672: --initialize arrays of parameter names
673: --debug(L_PROC_NAME||'List Mode, Calling EGO_PUB_WS_UTIL.Get_Parameter_Names procedure');
674: l_param_names := EGO_PUB_WS_UTIL.parameter_name_array_type();
675: EGO_PUB_WS_UTIL.Get_Parameter_Names(l_web_service_name, l_param_names);
676: --debug(L_PROC_NAME||'List Mode, Returned from EGO_PUB_WS_UTIL.Get_Parameter_Names procedure, l_param_names.count: '||l_param_names.count);
677:
678:

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

671:
672: --initialize arrays of parameter names
673: --debug(L_PROC_NAME||'List Mode, Calling EGO_PUB_WS_UTIL.Get_Parameter_Names procedure');
674: l_param_names := EGO_PUB_WS_UTIL.parameter_name_array_type();
675: EGO_PUB_WS_UTIL.Get_Parameter_Names(l_web_service_name, l_param_names);
676: --debug(L_PROC_NAME||'List Mode, Returned from EGO_PUB_WS_UTIL.Get_Parameter_Names procedure, l_param_names.count: '||l_param_names.count);
677:
678:
679: --debug(L_PROC_NAME||'List Mode, Calling EGO_PUB_WS_UTIL.Get_Xpath_Expr procedure');

Line 676: --debug(L_PROC_NAME||'List Mode, Returned from EGO_PUB_WS_UTIL.Get_Parameter_Names procedure, l_param_names.count: '||l_param_names.count);

672: --initialize arrays of parameter names
673: --debug(L_PROC_NAME||'List Mode, Calling EGO_PUB_WS_UTIL.Get_Parameter_Names procedure');
674: l_param_names := EGO_PUB_WS_UTIL.parameter_name_array_type();
675: EGO_PUB_WS_UTIL.Get_Parameter_Names(l_web_service_name, l_param_names);
676: --debug(L_PROC_NAME||'List Mode, Returned from EGO_PUB_WS_UTIL.Get_Parameter_Names procedure, l_param_names.count: '||l_param_names.count);
677:
678:
679: --debug(L_PROC_NAME||'List Mode, Calling EGO_PUB_WS_UTIL.Get_Xpath_Expr procedure');
680: l_xpath_expr := EGO_PUB_WS_UTIL.xpath_expr_array_type();

Line 679: --debug(L_PROC_NAME||'List Mode, Calling EGO_PUB_WS_UTIL.Get_Xpath_Expr procedure');

675: EGO_PUB_WS_UTIL.Get_Parameter_Names(l_web_service_name, l_param_names);
676: --debug(L_PROC_NAME||'List Mode, Returned from EGO_PUB_WS_UTIL.Get_Parameter_Names procedure, l_param_names.count: '||l_param_names.count);
677:
678:
679: --debug(L_PROC_NAME||'List Mode, Calling EGO_PUB_WS_UTIL.Get_Xpath_Expr procedure');
680: l_xpath_expr := EGO_PUB_WS_UTIL.xpath_expr_array_type();
681: EGO_PUB_WS_UTIL.Get_Xpath_Expr(l_web_service_name, l_xpath_expr);
682: --debug(L_PROC_NAME||'List Mode, Returned from EGO_PUB_WS_UTIL.Get_Xpath_Expr procedure, l_xpath_expr.count: '||l_xpath_expr.count);
683:

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

676: --debug(L_PROC_NAME||'List Mode, Returned from EGO_PUB_WS_UTIL.Get_Parameter_Names procedure, l_param_names.count: '||l_param_names.count);
677:
678:
679: --debug(L_PROC_NAME||'List Mode, Calling EGO_PUB_WS_UTIL.Get_Xpath_Expr procedure');
680: l_xpath_expr := EGO_PUB_WS_UTIL.xpath_expr_array_type();
681: EGO_PUB_WS_UTIL.Get_Xpath_Expr(l_web_service_name, l_xpath_expr);
682: --debug(L_PROC_NAME||'List Mode, Returned from EGO_PUB_WS_UTIL.Get_Xpath_Expr procedure, l_xpath_expr.count: '||l_xpath_expr.count);
683:
684: --retrieve all single-value parameters of interest from XML

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

677:
678:
679: --debug(L_PROC_NAME||'List Mode, Calling EGO_PUB_WS_UTIL.Get_Xpath_Expr procedure');
680: l_xpath_expr := EGO_PUB_WS_UTIL.xpath_expr_array_type();
681: EGO_PUB_WS_UTIL.Get_Xpath_Expr(l_web_service_name, l_xpath_expr);
682: --debug(L_PROC_NAME||'List Mode, Returned from EGO_PUB_WS_UTIL.Get_Xpath_Expr procedure, l_xpath_expr.count: '||l_xpath_expr.count);
683:
684: --retrieve all single-value parameters of interest from XML
685: --and store them in table EGO_PUB_WS_CONFIG

Line 682: --debug(L_PROC_NAME||'List Mode, Returned from EGO_PUB_WS_UTIL.Get_Xpath_Expr procedure, l_xpath_expr.count: '||l_xpath_expr.count);

678:
679: --debug(L_PROC_NAME||'List Mode, Calling EGO_PUB_WS_UTIL.Get_Xpath_Expr procedure');
680: l_xpath_expr := EGO_PUB_WS_UTIL.xpath_expr_array_type();
681: EGO_PUB_WS_UTIL.Get_Xpath_Expr(l_web_service_name, l_xpath_expr);
682: --debug(L_PROC_NAME||'List Mode, Returned from EGO_PUB_WS_UTIL.Get_Xpath_Expr procedure, l_xpath_expr.count: '||l_xpath_expr.count);
683:
684: --retrieve all single-value parameters of interest from XML
685: --and store them in table EGO_PUB_WS_CONFIG
686: FOR position IN 1..l_param_names.COUNT

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

686: FOR position IN 1..l_param_names.COUNT
687: LOOP
688: --debug(L_PROC_NAME||'List Mode, Inside For Loop on l_param_names.count, position: '||position||' ,l_xpath_expr: '||l_xpath_expr(position));
689:
690: l_config_option := upper(EGO_PUB_WS_UTIL.Get_ODI_Input_Parameter(p_session_id, l_xpath_expr(position)));
691: --debug(L_PROC_NAME||'List Mode, l_config_option: '||l_config_option);
692:
693: --if parameter is not provided, assume a default value of 'TRUE'
694:

Line 745: --debug(L_PROC_NAME||'calling EGO_PUB_WS_UTIL.Create_Fnd_Security procedure');

741: sysdate,
742: G_CURRENT_USER_ID,
743: l_web_service_name);
744:
745: --debug(L_PROC_NAME||'calling EGO_PUB_WS_UTIL.Create_Fnd_Security procedure');
746: EGO_PUB_WS_UTIL.Create_Fnd_Security(p_session_id,
747: l_mode,
748: l_batch_id,
749: l_web_service_name

Line 746: EGO_PUB_WS_UTIL.Create_Fnd_Security(p_session_id,

742: G_CURRENT_USER_ID,
743: l_web_service_name);
744:
745: --debug(L_PROC_NAME||'calling EGO_PUB_WS_UTIL.Create_Fnd_Security procedure');
746: EGO_PUB_WS_UTIL.Create_Fnd_Security(p_session_id,
747: l_mode,
748: l_batch_id,
749: l_web_service_name
750: );

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

753: -- AND STORE THEM IN TABLE EGO_PUB_WS_CONFIG
754: --
755:
756: --RETRIEVING LIST OF LANGUAGES
757: l_language_search_str := EGO_PUB_WS_UTIL.Get_Language_Search_Str(l_web_service_name);
758:
759: --Inserts language options in Config table
760: --debug(L_PROC_NAME||'calling EGO_PUB_WS_UTIL.Config_Languages procedure');
761: EGO_PUB_WS_UTIL.Config_Languages( p_session_id,

Line 760: --debug(L_PROC_NAME||'calling EGO_PUB_WS_UTIL.Config_Languages procedure');

756: --RETRIEVING LIST OF LANGUAGES
757: l_language_search_str := EGO_PUB_WS_UTIL.Get_Language_Search_Str(l_web_service_name);
758:
759: --Inserts language options in Config table
760: --debug(L_PROC_NAME||'calling EGO_PUB_WS_UTIL.Config_Languages procedure');
761: EGO_PUB_WS_UTIL.Config_Languages( p_session_id,
762: l_language_search_str,
763: l_web_service_name);
764:

Line 761: EGO_PUB_WS_UTIL.Config_Languages( p_session_id,

757: l_language_search_str := EGO_PUB_WS_UTIL.Get_Language_Search_Str(l_web_service_name);
758:
759: --Inserts language options in Config table
760: --debug(L_PROC_NAME||'calling EGO_PUB_WS_UTIL.Config_Languages procedure');
761: EGO_PUB_WS_UTIL.Config_Languages( p_session_id,
762: l_language_search_str,
763: l_web_service_name);
764:
765: --debug(L_PROC_NAME||' End');

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

1166: L_PROC_NAME := ' Create_Entities_ICC=> ';
1167: --debug(L_PROC_NAME||' Start');
1168: --debug(L_PROC_NAME||' Parameters - p_session_id: '||p_session_id);
1169:
1170: l_mode := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'MODE', NULL, NULL);
1171: --debug(L_PROC_NAME||'MODE: '||l_mode);
1172:
1173: --populate odi input table ego_pub_ws_entities depending on mode from different data sources (i.e.) batch, list
1174: CASE

Line 1178: l_batch_id := EGO_PUB_WS_UTIL.Get_Numeric_Param_Value(p_session_id,'BATCH_ID', NULL, NULL);

1174: CASE
1175:
1176: --if mode is batch, get information from publication framework using batch_id
1177: WHEN l_mode = 'BATCH' THEN
1178: l_batch_id := EGO_PUB_WS_UTIL.Get_Numeric_Param_Value(p_session_id,'BATCH_ID', NULL, NULL);
1179: --debug(L_PROC_NAME||'Batch_Id: '||l_batch_id);
1180:
1181: --retrieving all ICCs in batch from publication framework entity tables
1182: --and inserting data into ODI metadata input table ego_pub_ws_entities

Line 1318: l_param_parent_hier := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'PARENTICCS', NULL, NULL);

1314: and insert into ego_pub_ws_entities table */
1315:
1316: /* In Create_Params_ICC() procedure, we have dumped config params in both modes (batch,list) into EGO_PUB_WS_CONFIG table.
1317: So, now while fetching the PARENTICCS,CHILDICCS params, we can just get from this table without reference to any mode*/
1318: l_param_parent_hier := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'PARENTICCS', NULL, NULL);
1319: l_param_child_hier := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'CHILDICCS', NULL, NULL);
1320: --debug(L_PROC_NAME||'l_param_parent_hier: '||l_param_parent_hier||' ,l_param_child_hier: '||l_param_child_hier);
1321:
1322: -- bug 12377269. added UPPER

Line 1319: l_param_child_hier := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'CHILDICCS', NULL, NULL);

1315:
1316: /* In Create_Params_ICC() procedure, we have dumped config params in both modes (batch,list) into EGO_PUB_WS_CONFIG table.
1317: So, now while fetching the PARENTICCS,CHILDICCS params, we can just get from this table without reference to any mode*/
1318: l_param_parent_hier := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'PARENTICCS', NULL, NULL);
1319: l_param_child_hier := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'CHILDICCS', NULL, NULL);
1320: --debug(L_PROC_NAME||'l_param_parent_hier: '||l_param_parent_hier||' ,l_param_child_hier: '||l_param_child_hier);
1321:
1322: -- bug 12377269. added UPPER
1323: IF ( (Nvl(upper(l_param_parent_hier),'FALSE')='TRUE') OR (Nvl(upper(l_param_child_hier),'FALSE')='TRUE')) THEN

Line 1707: l_param_vs := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'VALUESETS', NULL, NULL);

1703: only when Publish Valuesets config param is set to Yes.
1704: For both modes - batch and list, VALUESETS param has been added to EGO_PUB_WS_CONFIG table in Create_params_ICC procedure.
1705: So, we don't differentiate the mode while fetching this param below*/
1706:
1707: l_param_vs := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'VALUESETS', NULL, NULL);
1708: --debug(L_PROC_NAME||' l_param_vs: '||l_param_vs);
1709:
1710: IF l_param_vs = G_CHAR_TRUE THEN
1711: --debug(L_PROC_NAME||' Calling EGO_PUB_WS_AG.Explode_Attribute_Group');

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

1949: Create_Entities_ICC(p_session_id);
1950: --debug(L_PROC_NAME||'Returned from Create_Entities_ICC procedure');
1951:
1952: --Explode ICCs to get associated AGs
1953: l_mode := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'MODE', NULL, NULL);
1954: --debug(L_PROC_NAME||'Mode: '||l_mode);
1955:
1956: IF l_mode = 'LIST' THEN
1957: l_param_ag := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'USERDEFATTRGRPS', NULL, l_mode);

Line 1957: l_param_ag := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'USERDEFATTRGRPS', NULL, l_mode);

1953: l_mode := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'MODE', NULL, NULL);
1954: --debug(L_PROC_NAME||'Mode: '||l_mode);
1955:
1956: IF l_mode = 'LIST' THEN
1957: l_param_ag := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'USERDEFATTRGRPS', NULL, l_mode);
1958: --debug(L_PROC_NAME||'List mode, l_param_ag: '||l_param_ag );
1959: ELSIF l_mode = 'BATCH' THEN
1960: l_batch_id := EGO_PUB_WS_UTIL.Get_Numeric_Param_Value(p_session_id,'BATCH_ID', NULL, NULL);
1961: --debug(L_PROC_NAME||'Batch mode, l_batch_id: '||l_batch_id);

Line 1960: l_batch_id := EGO_PUB_WS_UTIL.Get_Numeric_Param_Value(p_session_id,'BATCH_ID', NULL, NULL);

1956: IF l_mode = 'LIST' THEN
1957: l_param_ag := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'USERDEFATTRGRPS', NULL, l_mode);
1958: --debug(L_PROC_NAME||'List mode, l_param_ag: '||l_param_ag );
1959: ELSIF l_mode = 'BATCH' THEN
1960: l_batch_id := EGO_PUB_WS_UTIL.Get_Numeric_Param_Value(p_session_id,'BATCH_ID', NULL, NULL);
1961: --debug(L_PROC_NAME||'Batch mode, l_batch_id: '||l_batch_id);
1962: l_param_ag := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'USERDEFATTRGRPS', NULL, NULL);
1963: --debug(L_PROC_NAME||'Batch mode, l_param_ag: '||l_param_ag );
1964: END IF;

Line 1962: l_param_ag := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'USERDEFATTRGRPS', NULL, NULL);

1958: --debug(L_PROC_NAME||'List mode, l_param_ag: '||l_param_ag );
1959: ELSIF l_mode = 'BATCH' THEN
1960: l_batch_id := EGO_PUB_WS_UTIL.Get_Numeric_Param_Value(p_session_id,'BATCH_ID', NULL, NULL);
1961: --debug(L_PROC_NAME||'Batch mode, l_batch_id: '||l_batch_id);
1962: l_param_ag := EGO_PUB_WS_UTIL.Get_Char_Param_Value(p_session_id, 'USERDEFATTRGRPS', NULL, NULL);
1963: --debug(L_PROC_NAME||'Batch mode, l_param_ag: '||l_param_ag );
1964: END IF;
1965:
1966: /* check for the explosion of the immediate child entity only. In this case, check if AG have to be

Line 1989: generic procedure Write_Errors_ToBatFwk in EGO_PUB_WS_UTIL. This is because for the versioned

1985: END Preprocess_Input_ICC;
1986:
1987:
1988: /* Writing an ICC specific Write_Errors_ToBatFwk procedure as below instead of calling the
1989: generic procedure Write_Errors_ToBatFwk in EGO_PUB_WS_UTIL. This is because for the versioned
1990: ICCs, we create two records - an ICC record with version as null and a second record with
1991: version populated. To handle this difference in representing entities, we need to code
1992: Write_Errors_ToBatFwk() specific to ICC
1993:

Line 1995: with EGO_PUB_WS_UTIL.Write_Errors_ToBatFwk().

1991: version populated. To handle this difference in representing entities, we need to code
1992: Write_Errors_ToBatFwk() specific to ICC
1993:
1994: At a later point in time (post 12.2), review the feasibility of merging this procedure
1995: with EGO_PUB_WS_UTIL.Write_Errors_ToBatFwk().
1996: It can be done by changing the code of EGO_PUB_WS_UTIL.Write_Errors_ToBatFwk() to handle
1997: - CURSOR c_pub_ws_entities changes
1998: - handling update of EGO_PUBLICATION_BATCH_GT seperately differently than AG,VS using a IF-ELSE condition.
1999: - in ODI pkg EGO_SYNCICCDETAILS , procedure Write_Errors_ToBatFwk() make a call to the procedure in EGO_PUB_WS_UTIL

Line 1996: It can be done by changing the code of EGO_PUB_WS_UTIL.Write_Errors_ToBatFwk() to handle

1992: Write_Errors_ToBatFwk() specific to ICC
1993:
1994: At a later point in time (post 12.2), review the feasibility of merging this procedure
1995: with EGO_PUB_WS_UTIL.Write_Errors_ToBatFwk().
1996: It can be done by changing the code of EGO_PUB_WS_UTIL.Write_Errors_ToBatFwk() to handle
1997: - CURSOR c_pub_ws_entities changes
1998: - handling update of EGO_PUBLICATION_BATCH_GT seperately differently than AG,VS using a IF-ELSE condition.
1999: - in ODI pkg EGO_SYNCICCDETAILS , procedure Write_Errors_ToBatFwk() make a call to the procedure in EGO_PUB_WS_UTIL
2000: */

Line 1999: - in ODI pkg EGO_SYNCICCDETAILS , procedure Write_Errors_ToBatFwk() make a call to the procedure in EGO_PUB_WS_UTIL

1995: with EGO_PUB_WS_UTIL.Write_Errors_ToBatFwk().
1996: It can be done by changing the code of EGO_PUB_WS_UTIL.Write_Errors_ToBatFwk() to handle
1997: - CURSOR c_pub_ws_entities changes
1998: - handling update of EGO_PUBLICATION_BATCH_GT seperately differently than AG,VS using a IF-ELSE condition.
1999: - in ODI pkg EGO_SYNCICCDETAILS , procedure Write_Errors_ToBatFwk() make a call to the procedure in EGO_PUB_WS_UTIL
2000: */
2001:
2002: /* Algorithm of Write_Errors_ToBatFwk in EGO_PUB_WS_UTIL
2003: 1) Select value of trigger_import param

Line 2002: /* Algorithm of Write_Errors_ToBatFwk in EGO_PUB_WS_UTIL

1998: - handling update of EGO_PUBLICATION_BATCH_GT seperately differently than AG,VS using a IF-ELSE condition.
1999: - in ODI pkg EGO_SYNCICCDETAILS , procedure Write_Errors_ToBatFwk() make a call to the procedure in EGO_PUB_WS_UTIL
2000: */
2001:
2002: /* Algorithm of Write_Errors_ToBatFwk in EGO_PUB_WS_UTIL
2003: 1) Select value of trigger_import param
2004: 2) loop on systems
2005: 2.1 check for invalid sys
2006: 2.1.1 if valid sys then