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.AMW_ORG_HIERARCHY_PKG dependencies on FND_CONCURRENT

Line 2938: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Warning: Cannot Associate Root Process');

2934: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
2935: RAISE FND_API.G_EXC_ERROR;
2936: END IF;
2937: if p_process_id = -1 OR p_process_id = -2 then
2938: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Warning: Cannot Associate Root Process');
2939: return;
2940: end if;
2941: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2942: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 2950: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Warning: No Organization filter found to proceed');

2946: open c3(p_process_id, p_org_range_from,p_org_range_to);
2947: fetch c3 bulk collect into l_audit_units_tbl;
2948: close c3;
2949: elsif p_org_name is null then
2950: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Warning: No Organization filter found to proceed');
2951: return;
2952: else
2953: open c2(p_process_id, p_org_name || '%');
2954: fetch c2 bulk collect into l_audit_units_tbl;

Line 3005: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Process cannot be associated to some organizations');

3001: -- Done associating...Commit here..
3002: COMMIT;
3003: END LOOP;
3004: if show_warning then
3005: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Process cannot be associated to some organizations');
3006: end if;
3007:
3008: -- update the org count..
3009: update amw_process AP

Line 3308: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);

3304: WHEN FND_API.G_EXC_ERROR THEN
3305: ROLLBACK;
3306: retcode := 2;
3307: errbuf := SUBSTR(SQLERRM,1,1000);
3308: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);
3309:
3310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3311: ROLLBACK;
3312: retcode := 2;

Line 3314: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);

3310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3311: ROLLBACK;
3312: retcode := 2;
3313: errbuf := SUBSTR(SQLERRM,1,1000);
3314: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);
3315:
3316: WHEN OTHERS THEN
3317: ROLLBACK;
3318: retcode := 2;

Line 3320: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);

3316: WHEN OTHERS THEN
3317: ROLLBACK;
3318: retcode := 2;
3319: errbuf := SUBSTR(SQLERRM,1,1000);
3320: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);
3321: END push_proc_org_srs;
3322:
3323:
3324: -- ****************************************************************************

Line 3482: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Warning: Cannot Associate Root Process');

3478:
3479:
3480: BEGIN
3481: IF to_number(p_process_id) = -1 OR to_number(p_process_id) = -2 then
3482: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Warning: Cannot Associate Root Process');
3483: return;
3484: end if;
3485: retcode := 0;
3486: errbuf := '';

Line 3573: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Process cannot be associated to some organizations');

3569: -- Done associating...Commit here..
3570: COMMIT;
3571: END LOOP;
3572: if show_warning then
3573: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Process cannot be associated to some organizations');
3574: end if;
3575:
3576: /* This block is to update the latest and approved risk control counts..*/
3577: l_sql_string := 'select organization_id, process_id from amw_process_organization where revision_number = 1' ||

Line 3745: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);

3741: EXCEPTION
3742: WHEN others THEN
3743: retcode :=2;
3744: errbuf :=SUBSTR(SQLERRM,1,1000);
3745: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);
3746: END push_proc_org_Conc_Request;
3747:
3748: -- ****************************************************************************
3749:

Line 7995: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);

7991: when others then
7992: rollback;
7993: retcode :=2;
7994: errbuf :=SUBSTR(SQLERRM,1,1000);
7995: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);
7996:
7997: end reset_count;
7998:
7999: procedure delete_activities(p_parent_process_id in number,

Line 8383: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Warning: Cannot Associate Root Process');

8379: RAISE FND_API.G_EXC_ERROR;
8380: END IF;
8381:
8382: IF p_process_id = -1 OR p_process_id = -2 THEN
8383: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Warning: Cannot Associate Root Process');
8384: RETURN;
8385: END IF;
8386:
8387: IF p_org_name IS NULL THEN

Line 8388: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Warning: No Organization filter found to proceed');

8384: RETURN;
8385: END IF;
8386:
8387: IF p_org_name IS NULL THEN
8388: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Warning: No Organization filter found to proceed');
8389: RETURN;
8390: ELSIF p_org_range_from IS NOT NULL and p_org_range_to IS NOT NULL then
8391: init;
8392: SELECT DISTINCT aauv.organization_id

Line 8492: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Process cannot be synchronized to some organizations');

8488: fnd_file.put_line(fnd_file.LOG, l_msg_data);
8489: END;
8490:
8491: if show_warning then
8492: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Process cannot be synchronized to some organizations');
8493: end if;
8494:
8495: IF p_sync_mode = 'Y' or p_sync_hierarchy = 'Y' then
8496:

Line 8538: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);

8534: WHEN FND_API.G_EXC_ERROR THEN
8535: ROLLBACK;
8536: retcode := 2;
8537: errbuf := SUBSTR(SQLERRM,1,1000);
8538: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);
8539:
8540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8541: ROLLBACK;
8542: retcode := 2;

Line 8544: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);

8540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8541: ROLLBACK;
8542: retcode := 2;
8543: errbuf := SUBSTR(SQLERRM,1,1000);
8544: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);
8545:
8546: WHEN OTHERS THEN
8547: ROLLBACK;
8548: retcode := 2;

Line 8550: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);

8546: WHEN OTHERS THEN
8547: ROLLBACK;
8548: retcode := 2;
8549: errbuf := SUBSTR(SQLERRM,1,1000);
8550: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);
8551: END sync_proc_org_srs;
8552:
8553: /** Following 2 functions added by dpatel on 8th Feb, 2006*/
8554: FUNCTION get_latest_conc_request (concur_prog_id number) RETURN NUMBER;

Line 8564: fnd_concurrent_requests

8560: BEGIN
8561: select
8562: request_id into p_request_id
8563: from
8564: fnd_concurrent_requests
8565: where
8566: CONCURRENT_PROGRAM_ID = concur_prog_id
8567: and last_update_date = (select max(last_update_date) from fnd_concurrent_requests where CONCURRENT_PROGRAM_ID = concur_prog_id)
8568: and phase_code<>'C';

Line 8567: and last_update_date = (select max(last_update_date) from fnd_concurrent_requests where CONCURRENT_PROGRAM_ID = concur_prog_id)

8563: from
8564: fnd_concurrent_requests
8565: where
8566: CONCURRENT_PROGRAM_ID = concur_prog_id
8567: and last_update_date = (select max(last_update_date) from fnd_concurrent_requests where CONCURRENT_PROGRAM_ID = concur_prog_id)
8568: and phase_code<>'C';
8569: return p_request_id;
8570: END get_latest_conc_request;
8571:

Line 8580: fnd_concurrent_programs

8576: BEGIN
8577: select
8578: concurrent_program_id into v_concurrent_program_id
8579: from
8580: fnd_concurrent_programs
8581: where CONCURRENT_PROGRAM_NAME = concur_prog_name;
8582: return v_concurrent_program_id;
8583: END get_concur_program_id;
8584: /** Block by dpatel ends */

Line 8675: fnd_concurrent_requests

8671: cursor c_current_requests(prog_id number) IS
8672: select
8673: request_id, argument1, argument2, argument3, argument4
8674: from
8675: fnd_concurrent_requests
8676: where
8677: CONCURRENT_PROGRAM_ID = prog_id
8678: and last_update_date < (select max(last_update_date) from fnd_concurrent_requests where CONCURRENT_PROGRAM_ID = prog_id)
8679: and phase_code<>'C';

Line 8678: and last_update_date < (select max(last_update_date) from fnd_concurrent_requests where CONCURRENT_PROGRAM_ID = prog_id)

8674: from
8675: fnd_concurrent_requests
8676: where
8677: CONCURRENT_PROGRAM_ID = prog_id
8678: and last_update_date < (select max(last_update_date) from fnd_concurrent_requests where CONCURRENT_PROGRAM_ID = prog_id)
8679: and phase_code<>'C';
8680: v_concurrent_program_id integer;
8681: same_request_exception exception;
8682: prior_process_id number;

Line 8697: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Warning: Cannot Associate Root Process');

8693: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
8694: RAISE FND_API.G_EXC_ERROR;
8695: END IF;
8696: if p_process_id = -1 OR p_process_id = -2 then
8697: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Warning: Cannot Associate Root Process');
8698: return;
8699: end if;
8700: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
8701: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 8752: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Warning: No Organization filter found to proceed');

8748: open c3(p_process_id, p_U_org_range_from,p_U_org_range_to);
8749: fetch c3 bulk collect into l_audit_units_tbl;
8750: close c3;
8751: elsif p_U_org_name is null then
8752: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Warning: No Organization filter found to proceed');
8753: return;
8754: else
8755: open c2(p_process_id, p_U_org_name || '%');
8756: fetch c2 bulk collect into l_audit_units_tbl;

Line 8811: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Process cannot be associated to some organizations');

8807: -- Done associating...Commit here..
8808: COMMIT;
8809: END LOOP;
8810: if show_warning then
8811: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Process cannot be associated to some organizations');
8812: end if;
8813: AMW_UTILITY_PVT.unset_appr_cache;
8814: END IF;
8815: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 8823: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',

8819: COMMIT;
8820: EXCEPTION
8821: WHEN same_request_exception THEN
8822: fnd_file.put_line(fnd_file.LOG, 'ERROR:'|| SQLERRM);
8823: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',
8824: 'There is already a concurrent process running for a similar process id.'||
8825: 'This concurrent request is also being run with the same value for parameter "Process id" '||
8826: ' and the parameter "Organization Name or Range" that the earlier concurrent program is running with. '
8827: );

Line 8832: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);

8828: WHEN FND_API.G_EXC_ERROR THEN
8829: ROLLBACK;
8830: retcode := 2;
8831: errbuf := SUBSTR(SQLERRM,1,1000);
8832: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);
8833:
8834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8835: ROLLBACK;
8836: retcode := 2;

Line 8838: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);

8834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8835: ROLLBACK;
8836: retcode := 2;
8837: errbuf := SUBSTR(SQLERRM,1,1000);
8838: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);
8839:
8840: WHEN OTHERS THEN
8841: ROLLBACK;
8842: retcode := 2;

Line 8844: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);

8840: WHEN OTHERS THEN
8841: ROLLBACK;
8842: retcode := 2;
8843: errbuf := SUBSTR(SQLERRM,1,1000);
8844: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);
8845: END push_proc_org_no_count;
8846:
8847: end AMW_ORG_HIERARCHY_PKG;