DBA Data[Home] [Help]

APPS.GMS_WF_PKG dependencies on GMS_ERROR_PKG

Line 2189: gms_error_pkg.gms_message(x_err_name => 'GMS_UNEXPECTED_ERROR',

2185: -- Added Exception for Bug:2662848
2186:
2187: Exception
2188: when OTHERS then
2189: gms_error_pkg.gms_message(x_err_name => 'GMS_UNEXPECTED_ERROR',
2190: x_token_name1 => 'SQLCODE',
2191: x_token_val1 => sqlcode,
2192: x_token_name2 => 'SQLERRM',
2193: x_token_val2 => sqlerrm,

Line 2282: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024

2278: pragma exception_init(WF_API_EXCEPTION, -20002);
2279:
2280: begin
2281:
2282: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024
2283:
2284: IF L_DEBUG = 'Y' THEN
2285: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - start', 'C');
2286: END IF;

Line 2285: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - start', 'C');

2281:
2282: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024
2283:
2284: IF L_DEBUG = 'Y' THEN
2285: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - start', 'C');
2286: END IF;
2287:
2288: -- Start of code added for Bug 1868293
2289: l_offset_days := p_offset_days;

Line 2296: gms_error_pkg.gms_debug('Profile GMS_NOTIFICATION_OFFSET_DAYS is undefined', 'C');

2292: FND_PROFILE.GET('GMS_NOTIFICATION_OFFSET_DAYS',l_offset_days);
2293:
2294: If l_offset_days IS NULL Then
2295: IF L_DEBUG = 'Y' THEN
2296: gms_error_pkg.gms_debug('Profile GMS_NOTIFICATION_OFFSET_DAYS is undefined', 'C');
2297: END IF;
2298: Elsif (l_offset_days < 0) Then
2299: IF L_DEBUG = 'Y' THEN
2300: gms_error_pkg.gms_debug('Invalid value for Profile GMS_NOTIFICATION_OFFSET_DAYS', 'C');

Line 2300: gms_error_pkg.gms_debug('Invalid value for Profile GMS_NOTIFICATION_OFFSET_DAYS', 'C');

2296: gms_error_pkg.gms_debug('Profile GMS_NOTIFICATION_OFFSET_DAYS is undefined', 'C');
2297: END IF;
2298: Elsif (l_offset_days < 0) Then
2299: IF L_DEBUG = 'Y' THEN
2300: gms_error_pkg.gms_debug('Invalid value for Profile GMS_NOTIFICATION_OFFSET_DAYS', 'C');
2301: END IF;
2302: End If;
2303: End If;
2304:

Line 2308: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - Offset Days = '||to_char(l_offset_days), 'C');

2304:
2305:
2306: If (l_offset_days >= 0) Then -- End of code added for Bug 1868293
2307: IF L_DEBUG = 'Y' THEN
2308: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - Offset Days = '||to_char(l_offset_days), 'C');
2309: END IF;
2310:
2311: open c1;
2312: loop

Line 2349: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - role_name = '||l_role_name, 'C');

2345: l_role_name := l_award_id||'-'||l_report_id; -- change from l_report_name bug 2282107
2346: l_role_name_disp:= l_role_name ;
2347:
2348: IF L_DEBUG = 'Y' THEN
2349: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - role_name = '||l_role_name, 'C');
2350: END IF;
2351: --start bug fix 2204122--
2352: --Commented the following line as this is called from procedure call_gms_debug--
2353: --gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - user_roles = '||l_user_roles, 'C');

Line 2353: --gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - user_roles = '||l_user_roles, 'C');

2349: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - role_name = '||l_role_name, 'C');
2350: END IF;
2351: --start bug fix 2204122--
2352: --Commented the following line as this is called from procedure call_gms_debug--
2353: --gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - user_roles = '||l_user_roles, 'C');
2354: gms_client_extn_budget_wf.call_gms_debug(p_user_roles => l_user_roles
2355: ,p_disp_text =>'GMS_WF_PKG.SCHEDULE_NOTIFICATION - user_roles = ') ;
2356: --end bug fix 2204122--
2357:

Line 2373: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - created adhoc role', 'C');

2369: then
2370: NULL;
2371: end;
2372: IF L_DEBUG = 'Y' THEN
2373: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - created adhoc role', 'C');
2374: END IF;
2375: ----------------------------------------------------------------------------
2376:
2377: wf_directory.RemoveUsersFromAdhocRole(role_name => l_role_name);

Line 2380: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - removed users from adhoc role', 'C');

2376:
2377: wf_directory.RemoveUsersFromAdhocRole(role_name => l_role_name);
2378:
2379: IF L_DEBUG = 'Y' THEN
2380: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - removed users from adhoc role', 'C');
2381: END IF;
2382:
2383: begin
2384: --start bug fix 2204122--

Line 2400: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - added users to adhoc role', 'C');

2396: NULL;
2397: end;
2398:
2399: IF L_DEBUG = 'Y' THEN
2400: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - added users to adhoc role', 'C');
2401: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - Calling start_report_wf_process...', 'C');
2402: END IF;
2403:
2404: gms_wf_pkg.start_report_wf_process(

Line 2401: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - Calling start_report_wf_process...', 'C');

2397: end;
2398:
2399: IF L_DEBUG = 'Y' THEN
2400: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - added users to adhoc role', 'C');
2401: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - Calling start_report_wf_process...', 'C');
2402: END IF;
2403:
2404: gms_wf_pkg.start_report_wf_process(
2405: x_award_id => l_award_id,

Line 2417: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - After start_report_wf_process...', 'C');

2413: x_err_code => l_err_code,
2414: x_err_stage => l_err_stage);
2415:
2416: IF L_DEBUG = 'Y' THEN
2417: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - After start_report_wf_process...', 'C');
2418: END IF;
2419: --start bug fix 2204122--
2420: --As new set of userid's will get stored in l_user_roles. reinitializing the variable--
2421: l_user_roles := NULL ;

Line 2432: gms_error_pkg.gms_debug('Invalid value for Profile GMS_NOTIFICATION_OFFSET_DAYS', 'C');

2428: -- Added RETCODE and ERRBUF for Bug:2464800
2429: ERRBUF := 'The following error occured : '||sqlerrm;
2430: RETCODE := '2';
2431: IF L_DEBUG = 'Y' THEN
2432: gms_error_pkg.gms_debug('Invalid value for Profile GMS_NOTIFICATION_OFFSET_DAYS', 'C');
2433: END IF;
2434:
2435: when others
2436: then

Line 2549: gms_error_pkg.gms_message(x_err_name => 'GMS_START_INSTALL_WF_FAIL',

2545: -- wf_engine.threshold := l_wf_threshold_orig;
2546:
2547: if l_err_code <> 0
2548: then
2549: gms_error_pkg.gms_message(x_err_name => 'GMS_START_INSTALL_WF_FAIL',
2550: x_err_code => l_err_code,
2551: x_err_buff => l_err_stage);
2552:
2553: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2782: gms_error_pkg.gms_message(x_err_name => 'GMS_UNEXPECTED_ERROR',

2778: -- Added Exception for Bug:2662848
2779:
2780: exception
2781: when OTHERS then
2782: gms_error_pkg.gms_message(x_err_name => 'GMS_UNEXPECTED_ERROR',
2783: x_token_name1 => 'SQLCODE',
2784: x_token_val1 => sqlcode,
2785: x_token_name2 => 'SQLERRM',
2786: x_token_val2 => sqlerrm,

Line 3233: gms_error_pkg.gms_message(x_err_name => 'GMS_UNEXPECTED_ERROR',

3229: itemkey => itemkey );
3230: -- Added Exception for Bug:2662848
3231: EXCEPTION
3232: when OTHERS then
3233: gms_error_pkg.gms_message(x_err_name => 'GMS_UNEXPECTED_ERROR',
3234: x_token_name1 => 'SQLCODE',
3235: x_token_val1 => sqlcode,
3236: x_token_name2 => 'SQLERRM',
3237: x_token_val2 => sqlerrm,

Line 3302: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024

3298: WF_API_EXCEPTION EXCEPTION;
3299: PRAGMA EXCEPTION_INIT(WF_API_EXCEPTION, -20002);
3300:
3301: BEGIN
3302: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024
3303:
3304: l_offset_days := p_offset_days;
3305:
3306: -- If the value of the parameter passed from the concurrent request is null then pick up the value

Line 3402: gms_error_pkg.gms_debug('Invalid value for Profile GMS_NOTIFICATION_OFFSET_DAYS', 'C');

3398: -- Added RETCODE and ERRBUF for Bug:2464800
3399: RETCODE := '2';
3400: ERRBUF := 'The following error occured : '||sqlerrm;
3401: IF L_DEBUG = 'Y' THEN
3402: gms_error_pkg.gms_debug('Invalid value for Profile GMS_NOTIFICATION_OFFSET_DAYS', 'C');
3403: END IF;
3404: WHEN OTHERS THEN
3405: -- Changed RETCODE to 2 for Bug:2464800
3406: RETCODE := '2';