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 AMW_UTILITY_PVT

Line 621: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

617: FND_MSG_PUB.initialize;
618: end if;
619:
620: if FND_GLOBAL.user_id is null then
621: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
622: raise FND_API.G_EXC_ERROR;
623: end if;
624:
625: -- find out if the latest revision for parent_id is approved or not.

Line 2873: and 'Y' = AMW_UTILITY_PVT.IS_ORG_REGISTERED(aauv.ORGANIZATION_ID)

2869: select aauv.organization_id,
2870: name
2871: from amw_audit_units_v aauv
2872: where NVL( AAUV.DATE_TO,SYSDATE ) >= SYSDATE
2873: and 'Y' = AMW_UTILITY_PVT.IS_ORG_REGISTERED(aauv.ORGANIZATION_ID)
2874: and aauv.organization_id not in(
2875: select distinct organization_id
2876: from amw_process_organization
2877: where process_id = pid

Line 2890: and 'Y' = AMW_UTILITY_PVT.IS_ORG_REGISTERED(aauv.ORGANIZATION_ID)

2886: select aauv.organization_id,
2887: name
2888: from amw_audit_units_v aauv
2889: where NVL( AAUV.DATE_TO,SYSDATE ) >= SYSDATE
2890: and 'Y' = AMW_UTILITY_PVT.IS_ORG_REGISTERED(aauv.ORGANIZATION_ID)
2891: and aauv.organization_id not in(
2892: select distinct organization_id
2893: from amw_process_organization
2894: where process_id = pid

Line 2934: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

2930:
2931: BEGIN
2932:
2933: IF FND_GLOBAL.User_Id IS NULL THEN
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');

Line 3795: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

3791: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3792: FND_MSG_PUB.initialize;
3793: END IF;
3794: IF FND_GLOBAL.User_Id IS NULL THEN
3795: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
3796: RAISE FND_API.G_EXC_ERROR;
3797: END IF;
3798:
3799:

Line 3917: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

3913: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3914: FND_MSG_PUB.initialize;
3915: END IF;
3916: IF FND_GLOBAL.User_Id IS NULL THEN
3917: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
3918: RAISE FND_API.G_EXC_ERROR;
3919: END IF;
3920:
3921: if( l_log_stmt_level >= l_curr_log_level ) then

Line 4053: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

4049: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4050: FND_MSG_PUB.initialize;
4051: END IF;
4052: IF FND_GLOBAL.User_Id IS NULL THEN
4053: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4054: RAISE FND_API.G_EXC_ERROR;
4055: END IF;
4056:
4057: -- Make sure latest revision of parent is existing in the organization..

Line 4202: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

4198: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4199: FND_MSG_PUB.initialize;
4200: END IF;
4201: IF FND_GLOBAL.User_Id IS NULL THEN
4202: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4203: RAISE FND_API.G_EXC_ERROR;
4204: END IF;
4205:
4206: -- Make sure latest revision of parent is existing in the organization..

Line 4302: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

4298: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4299: FND_MSG_PUB.initialize;
4300: END IF;
4301: IF FND_GLOBAL.User_Id IS NULL THEN
4302: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4303: RAISE FND_API.G_EXC_ERROR;
4304: END IF;
4305:
4306: -- Disassociation functionality is to delete the process as a child and mark the process as deleted

Line 4379: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

4375: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4376: FND_MSG_PUB.initialize;
4377: END IF;
4378: IF FND_GLOBAL.User_Id IS NULL THEN
4379: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4380: RAISE FND_API.G_EXC_ERROR;
4381: END IF;
4382:
4383: -- do the basic validation..i.e. the process can not be locked state..

Line 4463: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

4459: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4460: FND_MSG_PUB.initialize;
4461: END IF;
4462: IF FND_GLOBAL.User_Id IS NULL THEN
4463: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4464: RAISE FND_API.G_EXC_ERROR;
4465: END IF;
4466:
4467: -- Update the Risk Counts..

Line 4520: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

4516: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4517: FND_MSG_PUB.initialize;
4518: END IF;
4519: IF FND_GLOBAL.User_Id IS NULL THEN
4520: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4521: RAISE FND_API.G_EXC_ERROR;
4522: END IF;
4523:
4524: -- Update the Risk Counts..

Line 4578: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

4574: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4575: FND_MSG_PUB.initialize;
4576: END IF;
4577: IF FND_GLOBAL.User_Id IS NULL THEN
4578: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4579: RAISE FND_API.G_EXC_ERROR;
4580: END IF;
4581:
4582: -- insert the justification rows.

Line 4727: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

4723: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4724: FND_MSG_PUB.initialize;
4725: END IF;
4726: IF FND_GLOBAL.User_Id IS NULL THEN
4727: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4728: RAISE FND_API.G_EXC_ERROR;
4729: END IF;
4730:
4731: ret_value := 'N';

Line 4818: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

4814: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4815: FND_MSG_PUB.initialize;
4816: END IF;
4817: IF FND_GLOBAL.User_Id IS NULL THEN
4818: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4819: RAISE FND_API.G_EXC_ERROR;
4820: END IF;
4821:
4822: select process_org_rev_id

Line 5071: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

5067: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5068: FND_MSG_PUB.initialize;
5069: END IF;
5070: IF FND_GLOBAL.User_Id IS NULL THEN
5071: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
5072: RAISE FND_API.G_EXC_ERROR;
5073: END IF;
5074:
5075:

Line 5195: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

5191: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5192: FND_MSG_PUB.initialize;
5193: END IF;
5194: IF FND_GLOBAL.User_Id IS NULL THEN
5195: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
5196: RAISE FND_API.G_EXC_ERROR;
5197: END IF;
5198:
5199:

Line 7849: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

7845: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7846: FND_MSG_PUB.initialize;
7847: END IF;
7848: IF FND_GLOBAL.User_Id IS NULL THEN
7849: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
7850: RAISE FND_API.G_EXC_ERROR;
7851: END IF;
7852:
7853:

Line 8021: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

8017: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8018: FND_MSG_PUB.initialize;
8019: END IF;
8020: if FND_GLOBAL.user_id is null then
8021: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
8022: raise FND_API.G_EXC_ERROR;
8023: end if;
8024:
8025: --check if parent_process_id is null

Line 8090: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

8086: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8087: FND_MSG_PUB.initialize;
8088: END IF;
8089: if FND_GLOBAL.user_id is null then
8090: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
8091: raise FND_API.G_EXC_ERROR;
8092: end if;
8093:
8094: --check if parent_process_id is null

Line 8183: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

8179: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8180: FND_MSG_PUB.initialize;
8181: END IF;
8182: if FND_GLOBAL.user_id is null then
8183: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
8184: raise FND_API.G_EXC_ERROR;
8185: end if;
8186:
8187: while (true) loop

Line 8281: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

8277: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8278: FND_MSG_PUB.initialize;
8279: END IF;
8280: IF FND_GLOBAL.User_Id IS NULL THEN
8281: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
8282: RAISE FND_API.G_EXC_ERROR;
8283: END IF;
8284:
8285: -- update the latest denorm hierarchy..

Line 8378: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

8374: RETURN;
8375: END IF;
8376:
8377: IF FND_GLOBAL.User_Id IS NULL THEN
8378: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
8379: RAISE FND_API.G_EXC_ERROR;
8380: END IF;
8381:
8382: IF p_process_id = -1 OR p_process_id = -2 THEN

Line 8612: and 'Y' = AMW_UTILITY_PVT.IS_ORG_REGISTERED(aauv.ORGANIZATION_ID)

8608: select aauv.organization_id,
8609: name
8610: from amw_audit_units_v aauv
8611: where NVL( AAUV.DATE_TO,SYSDATE ) >= SYSDATE
8612: and 'Y' = AMW_UTILITY_PVT.IS_ORG_REGISTERED(aauv.ORGANIZATION_ID)
8613: and aauv.organization_id not in(
8614: select distinct organization_id
8615: from amw_process_organization
8616: where process_id = pid

Line 8629: and 'Y' = AMW_UTILITY_PVT.IS_ORG_REGISTERED(aauv.ORGANIZATION_ID)

8625: select aauv.organization_id,
8626: name
8627: from amw_audit_units_v aauv
8628: where NVL( AAUV.DATE_TO,SYSDATE ) >= SYSDATE
8629: and 'Y' = AMW_UTILITY_PVT.IS_ORG_REGISTERED(aauv.ORGANIZATION_ID)
8630: and aauv.organization_id not in(
8631: select distinct organization_id
8632: from amw_process_organization
8633: where process_id = pid

Line 8693: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

8689: l_assoc_app_prof varchar2(1);
8690: BEGIN
8691:
8692: IF FND_GLOBAL.User_Id IS NULL THEN
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');

Line 8762: AMW_UTILITY_PVT.cache_appr_options;

8758: end if;
8759: if l_audit_units_tbl.exists(1) then
8760: l_assoc_app_prof := fnd_profile.value('AMW_PROC_ORG_ASS_APPRV');
8761: IF l_assoc_app_prof = 'Y' THEN
8762: AMW_UTILITY_PVT.cache_appr_options;
8763: END IF;
8764: FOR orgid IN l_audit_units_tbl.first .. l_audit_units_tbl.last loop
8765: -- fnd_file.put_line(fnd_file.LOG, 'Associating to ' || l_audit_units_tbl(orgid).org_name );
8766: push_proc_per_org(

Line 8813: AMW_UTILITY_PVT.unset_appr_cache;

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
8816: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
8817: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.push_proc_org_no_count.End','END');