DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_COPY_GRP dependencies on FND_GLOBAL

Line 3368: X_last_update_login => fnd_global.login_id -- LAST_UPDATE_LOGIN

3364: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
3365: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE
3366: X_to_pk2_value => to_char(l_line_number(x)),
3367: X_created_by => p_user_id, -- CREATED_BY
3368: X_last_update_login => fnd_global.login_id -- LAST_UPDATE_LOGIN
3369: );
3370:
3371: END IF;
3372:

Line 4791: fnd_global.login_id

4787: SYSDATE,
4788: p_user_id,
4789: SYSDATE,
4790: p_user_id,
4791: fnd_global.login_id
4792: FROM pon_auc_payments_shipments
4793: WHERE auction_header_id = p_source_auction_header_id
4794: AND line_number >= p_from_line_number
4795: AND line_number <= p_to_line_number

Line 4820: X_last_update_login => fnd_global.login_id

4816: X_to_pk1_value => to_char(payment_line_rec.dest_auc_id),
4817: X_to_pk2_value => to_char(payment_line_rec.dest_line_number),
4818: X_to_pk3_value => to_char(payment_line_rec.dest_payment_id),
4819: X_created_by => p_user_id,
4820: X_last_update_login => fnd_global.login_id
4821: );
4822: g_err_loc := '4. After calling copy payments attachments';
4823: LOG_MESSAGE('copy_negotiation','After copying attachments for payments. Source id='||payment_line_rec.source_payment_id);
4824: LOG_MESSAGE('copy_negotiation','After copying attachments for payments. Destination id='||payment_line_rec.dest_payment_id);

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 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;

Line 10612: X_last_update_login => fnd_global.login_id -- LAST_UPDATE_LOGIN

10608: X_from_pk1_value => to_char(p_source_auction_header_id),
10609: X_to_entity_name => 'PON_AUCTION_HEADERS_ALL',
10610: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE
10611: X_created_by => p_user_id, -- CREATED_BY
10612: X_last_update_login => fnd_global.login_id -- LAST_UPDATE_LOGIN
10613: );
10614: --
10615: -- Line Attachments will be copied in COPY_LINES procedure
10616: --

Line 11014: fnd_global.login_id

11010: sysdate,
11011: p_user_id,
11012: sysdate,
11013: p_user_id,
11014: fnd_global.login_id
11015: from
11016: pon_price_elements price_elements,
11017: pon_large_neg_pf_values largeNegPFVal
11018: where

Line 11101: fnd_global.login_id

11097: sysdate,
11098: p_user_id,
11099: sysdate,
11100: p_user_id,
11101: fnd_global.login_id
11102: from pon_large_neg_pf_values p, pon_price_element_types_vl vl
11103: where
11104: p.auction_header_id = p_source_auction_hdr_id and
11105: p.price_element_type_id = vl.price_element_type_id and

Line 11168: fnd_global.login_id

11164: sysdate,
11165: p_user_id,
11166: sysdate,
11167: p_user_id,
11168: fnd_global.login_id
11169: from
11170: pon_price_elements price_elements,
11171: pon_bidding_parties bidding_parties
11172: where

Line 11355: fnd_global.login_id,

11351: p_user_id,
11352: SYSDATE,
11353: p_user_id,
11354: SYSDATE,
11355: fnd_global.login_id,
11356: sysdate + 7
11357: );
11358:
11359: LOG_MESSAGE('copy_negotiation','An error has occured during copy');

Line 11424: ,fnd_global.login_id -- last_update_login

11420: ,SYSDATE -- creation_date
11421: ,p_user_id -- created_by
11422: ,SYSDATE -- last_update_date
11423: ,p_user_id -- last_updated_by
11424: ,fnd_global.login_id -- last_update_login
11425: ,old_team.team_id -- orig_team_id
11426: ,old_team.instruction_text
11427: FROM
11428: pon_scoring_teams old_team

Line 11456: ,fnd_global.login_id -- last_update_login

11452: ,SYSDATE -- creation_date
11453: ,p_user_id -- created_by
11454: ,SYSDATE -- last_update_date
11455: ,p_user_id -- last_updated_by
11456: ,fnd_global.login_id -- last_update_login
11457: FROM
11458: pon_scoring_team_members old_members,
11459: pon_scoring_teams old_team,
11460: pon_scoring_teams new_team,

Line 11492: ,fnd_global.login_id -- last_update_login

11488: ,SYSDATE -- creation_date
11489: ,p_user_id -- created_by
11490: ,SYSDATE -- last_update_date
11491: ,p_user_id -- last_updated_by
11492: ,fnd_global.login_id -- last_update_login
11493: FROM
11494: pon_auction_sections new_sections
11495: ,pon_scoring_team_sections old_team_sections
11496: ,pon_scoring_teams new_team