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.PON_NEGOTIATION_COPY_GRP dependencies on FND_USER

Line 792: FROM FND_USER

788: --
789: BEGIN
790: SELECT USER_NAME
791: INTO l_tpc_name
792: FROM FND_USER
793: WHERE USER_ID = l_user_id;
794: EXCEPTION
795: WHEN NO_DATA_FOUND THEN
796: -- The way I am adding this error may get changed in the future.

Line 6199: FND_USER U,

6195: l_modified_flag,
6196: l_last_notif_date,
6197: l_auc_business_group_id
6198: FROM PON_NEG_TEAM_MEMBERS PNTM,
6199: FND_USER U,
6200: PER_ALL_PEOPLE_F P,
6201: PER_ALL_ASSIGNMENTS_F A,
6202: PER_ALL_POSITIONS S,
6203: PON_AUCTION_HEADERS_ALL AH,

Line 6468: FND_USER U, PER_ALL_PEOPLE_F P

6464: INTO
6465: l_full_name
6466: FROM (SELECT PNTM.USER_ID, P.FULL_NAME
6467: FROM PON_NEG_TEAM_MEMBERS PNTM,
6468: FND_USER U, PER_ALL_PEOPLE_F P
6469: WHERE U.USER_ID = PNTM.USER_ID
6470: AND PNTM.AUCTION_HEADER_ID = p_source_auction_header_id
6471: AND PNTM.MEMBER_TYPE = 'N'
6472: AND P.PERSON_ID = U.EMPLOYEE_ID

Line 6476: FND_USER U, PER_ALL_PEOPLE_F P

6472: AND P.PERSON_ID = U.EMPLOYEE_ID
6473: MINUS
6474: SELECT PNTM.USER_ID, P.FULL_NAME
6475: FROM PON_NEG_TEAM_MEMBERS PNTM,
6476: FND_USER U, PER_ALL_PEOPLE_F P
6477: WHERE U.USER_ID = PNTM.USER_ID
6478: AND PNTM.AUCTION_HEADER_ID = p_auction_header_id
6479: AND P.PERSON_ID = U.EMPLOYEE_ID);
6480:

Line 10486: SELECT FND_USER.EMPLOYEE_ID

10482: -- This logic of getting the contact id is based on the PON_SOURCING_OPENAPI_GRP
10483: -- API which is simpler version of the UserInfoVO
10484: --
10485: BEGIN
10486: SELECT FND_USER.EMPLOYEE_ID
10487: INTO l_auc_contact_id
10488: FROM FND_USER, HZ_RELATIONSHIPS
10489: WHERE FND_USER.USER_ID = FND_GLOBAL.USER_ID()
10490: AND HZ_RELATIONSHIPS.OBJECT_ID = l_site_id

Line 10488: FROM FND_USER, HZ_RELATIONSHIPS

10484: --
10485: BEGIN
10486: SELECT FND_USER.EMPLOYEE_ID
10487: INTO l_auc_contact_id
10488: FROM FND_USER, HZ_RELATIONSHIPS
10489: WHERE FND_USER.USER_ID = FND_GLOBAL.USER_ID()
10490: AND HZ_RELATIONSHIPS.OBJECT_ID = l_site_id
10491: AND HZ_RELATIONSHIPS.SUBJECT_ID = FND_USER.PERSON_PARTY_ID
10492: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'

Line 10489: WHERE FND_USER.USER_ID = FND_GLOBAL.USER_ID()

10485: BEGIN
10486: SELECT FND_USER.EMPLOYEE_ID
10487: INTO l_auc_contact_id
10488: FROM FND_USER, HZ_RELATIONSHIPS
10489: WHERE FND_USER.USER_ID = FND_GLOBAL.USER_ID()
10490: AND HZ_RELATIONSHIPS.OBJECT_ID = l_site_id
10491: AND HZ_RELATIONSHIPS.SUBJECT_ID = FND_USER.PERSON_PARTY_ID
10492: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
10493: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'

Line 10491: AND HZ_RELATIONSHIPS.SUBJECT_ID = FND_USER.PERSON_PARTY_ID

10487: INTO l_auc_contact_id
10488: FROM FND_USER, HZ_RELATIONSHIPS
10489: WHERE FND_USER.USER_ID = FND_GLOBAL.USER_ID()
10490: AND HZ_RELATIONSHIPS.OBJECT_ID = l_site_id
10491: AND HZ_RELATIONSHIPS.SUBJECT_ID = FND_USER.PERSON_PARTY_ID
10492: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
10493: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
10494: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE
10495: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE;

Line 10500: LOG_MESSAGE('copy_negotiation','Could not determine contact_id for fnd_user_id ' || fnd_global.user_id());

10496: EXCEPTION
10497: WHEN OTHERS THEN
10498: l_auc_contact_id := NULL;
10499: -- Log Error
10500: LOG_MESSAGE('copy_negotiation','Could not determine contact_id for fnd_user_id ' || fnd_global.user_id());
10501: --
10502: -- The way I am adding this error may get changed in the future.
10503: -- So, please be aware of that
10504: FND_MESSAGE.SET_NAME('PON','PON_CONTRACT_COPY_ERR');

Line 10505: FND_MESSAGE.SET_TOKEN('REASON','Could not determine contact_id for fnd_user_id ' || fnd_global.user_id());

10501: --
10502: -- The way I am adding this error may get changed in the future.
10503: -- So, please be aware of that
10504: FND_MESSAGE.SET_NAME('PON','PON_CONTRACT_COPY_ERR');
10505: FND_MESSAGE.SET_TOKEN('REASON','Could not determine contact_id for fnd_user_id ' || fnd_global.user_id());
10506: FND_MSG_PUB.ADD;
10507: RAISE FND_API.G_EXC_ERROR;
10508: RETURN;
10509: END;