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.MSD_DEM_EVENT dependencies on MSD_DEM_EVENT

Line 1: PACKAGE BODY MSD_DEM_EVENT AS

1: PACKAGE BODY MSD_DEM_EVENT AS
2: /* $Header: msddemevntb.pls 120.2.12010000.3 2008/09/05 09:03:13 nallkuma ship $ */
3:
4:
5: /* Private Function - Added for creating the SOP component user in Demantra */

Line 91: log ('msd_dem_event.user_change - Profile MSD_DEM_SCHEMA is not set.');

87: log_debug ('Schema: ' || x_schema);
88:
89: IF (x_schema IS NULL)
90: THEN
91: log ('msd_dem_event.user_change - Profile MSD_DEM_SCHEMA is not set.');
92: log_debug ('msd_dem_event.user_change - Profile MSD_DEM_SCHEMA is not set.');
93: RETURN SUCCESS;
94: ELSE
95: OPEN c_is_mdp_matrix_present (x_schema);

Line 92: log_debug ('msd_dem_event.user_change - Profile MSD_DEM_SCHEMA is not set.');

88:
89: IF (x_schema IS NULL)
90: THEN
91: log ('msd_dem_event.user_change - Profile MSD_DEM_SCHEMA is not set.');
92: log_debug ('msd_dem_event.user_change - Profile MSD_DEM_SCHEMA is not set.');
93: RETURN SUCCESS;
94: ELSE
95: OPEN c_is_mdp_matrix_present (x_schema);
96: FETCH c_is_mdp_matrix_present INTO x_table_name;

Line 101: log ('msd_dem_event.user_change - Profile MSD_DEM_SCHEMA is incorrectly set or Demantra schema is not installed.');

97: CLOSE c_is_mdp_matrix_present;
98:
99: IF (x_table_name IS NULL)
100: THEN
101: log ('msd_dem_event.user_change - Profile MSD_DEM_SCHEMA is incorrectly set or Demantra schema is not installed.');
102: log_debug ('msd_dem_event.user_change - Profile MSD_DEM_SCHEMA is incorrectly set or Demantra schema is not installed.');
103: RETURN SUCCESS;
104: END IF;
105: END IF;

Line 102: log_debug ('msd_dem_event.user_change - Profile MSD_DEM_SCHEMA is incorrectly set or Demantra schema is not installed.');

98:
99: IF (x_table_name IS NULL)
100: THEN
101: log ('msd_dem_event.user_change - Profile MSD_DEM_SCHEMA is incorrectly set or Demantra schema is not installed.');
102: log_debug ('msd_dem_event.user_change - Profile MSD_DEM_SCHEMA is incorrectly set or Demantra schema is not installed.');
103: RETURN SUCCESS;
104: END IF;
105: END IF;
106: --Bug#7140524

Line 142: log_debug('Exiting msd_dem_event.user_change: Unknown Event');

138: log_debug ('Old User Name: ' || x_old_name);
139: END IF;
140:
141: ELSE
142: log_debug('Exiting msd_dem_event.user_change: Unknown Event');
143: RETURN SUCCESS;
144: END IF;
145:
146: /*** END- Get the user name from the event ***/

Line 162: , 'msd_dem_event.user_change'

158: log_debug ('Unable to get user id for user name = ' || x_curr_name);
159: --Bug#7140524 : returning success in case user id not found, so that workflow calling this method will proceed without erroring out
160: return SUCCESS;
161: /*return ( handleError ( PKG_NAME
162: , 'msd_dem_event.user_change'
163: , p_event
164: , p_subscription_guid
165: , ERROR
166: ));*/

Line 296: , 'msd_dem_event.user_change'

292: when others then
293: log_debug (substr(SQLERRM,1,150));
294: log ('Query on user_id ' || to_char(userid) || ' failed. Please ignore if not an Demand Management User.');
295: return ( handleError ( PKG_NAME
296: , 'msd_dem_event.user_change'
297: , p_event
298: , p_subscription_guid
299: , ERROR
300: ));

Line 509: , 'msd_dem_event.user_change'

505: WHEN NO_DATA_FOUND THEN
506: log_debug ('excep no data');
507: LOG('No rows returned');
508: return ( handleError ( PKG_NAME
509: , 'msd_dem_event.user_change'
510: , p_event
511: , p_subscription_guid
512: , ERROR
513: ));

Line 516: , 'msd_dem_event.user_change'

512: , ERROR
513: ));
514: WHEN OTHERS THEN
515: return ( handleError ( PKG_NAME
516: , 'msd_dem_event.user_change'
517: , p_event
518: , p_subscription_guid
519: , ERROR
520: ));

Line 645: log_debug('Exiting msd_dem_event.user_change: Unknown Event');

641: log_debug ('Old User Name: ' || x_old_name);
642: END IF;
643:
644: ELSE
645: log_debug('Exiting msd_dem_event.user_change: Unknown Event');
646: RETURN SUCCESS;
647: END IF;
648:
649: /*** END- Get the user name from the event ***/

Line 665: , 'msd_dem_event.user_change'

661: log_debug ('Unable to get user id for user name = ' || x_curr_name);
662: --Bug#7140524 : returning success in case user id not found, so that workflow calling this method will proceed without erroring out
663: return SUCCESS;
664: /*return ( handleError ( PKG_NAME
665: , 'msd_dem_event.user_change'
666: , p_event
667: , p_subscription_guid
668: , ERROR
669: ));*/

Line 799: , 'msd_dem_event.user_change'

795: when others then
796: log_debug (substr(SQLERRM,1,150));
797: log ('Query on user_id ' || to_char(userid) || ' failed. Please ignore if not an Sales and Operations Planning User.');
798: return ( handleError ( PKG_NAME
799: , 'msd_dem_event.user_change'
800: , p_event
801: , p_subscription_guid
802: , ERROR
803: ));

Line 1018: , 'msd_dem_event.user_change'

1014: WHEN NO_DATA_FOUND THEN
1015: log_debug ('excep no data');
1016: LOG('No rows returned');
1017: return ( handleError ( PKG_NAME
1018: , 'msd_dem_event.user_change'
1019: , p_event
1020: , p_subscription_guid
1021: , ERROR
1022: ));

Line 1025: , 'msd_dem_event.user_change'

1021: , ERROR
1022: ));
1023: WHEN OTHERS THEN
1024: return ( handleError ( PKG_NAME
1025: , 'msd_dem_event.user_change'
1026: , p_event
1027: , p_subscription_guid
1028: , ERROR
1029: ));

Line 1033: end msd_dem_event;

1029: ));
1030:
1031: END SOP_USER_CHANGE;
1032:
1033: end msd_dem_event;