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.

[Home] [Help]

APPS.PON_NEGOTIATION_COPY_GRP dependencies on FND_GLOBAL

Line 1596: -- user id is derived from pon_auction_headers_all instead of using fnd_global.user_id

1592: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
1593: l_is_award_approval_reqd PON_AUCTION_HEADERS_ALL.AWARD_APPROVAL_FLAG%TYPE;
1594: l_style_id PON_AUCTION_HEADERS_ALL.STYLE_ID%TYPE;
1595: l_mgr_id FND_USER.USER_ID%TYPE;
1596: -- user id is derived from pon_auction_headers_all instead of using fnd_global.user_id
1597: l_user_id FND_USER.USER_ID%TYPE;
1598: l_user_name FND_USER.USER_NAME%TYPE;
1599:
1600: -- Bug:9954903-start

Line 1675: fnd_global.current_language,

1671: l_is_conc_call,
1672: p_source_auction_header_id,
1673: l_trading_partner_id,
1674: l_trading_partner_contact_id,
1675: fnd_global.current_language,
1676: l_user_id,
1677: l_doctype_id,
1678: g_conformed_doc_copy, -- fed copy is always like a active neg copy
1679: l_is_award_approval_reqd,

Line 1723: ARGUMENT5 => fnd_global.USER_ID,

1719: ARGUMENT1 => p_source_auction_header_id ,
1720: ARGUMENT2 => 'BUYER',
1721: ARGUMENT3 => l_pdfFileName,
1722: ARGUMENT4 => userenv('LANG'),
1723: ARGUMENT5 => fnd_global.USER_ID,
1724: ARGUMENT6 => fnd_global.user_name,
1725: ARGUMENT7 => 'N',
1726: ARGUMENT8 => 'STORE_CLM_PDF'
1727: );

Line 1724: ARGUMENT6 => fnd_global.user_name,

1720: ARGUMENT2 => 'BUYER',
1721: ARGUMENT3 => l_pdfFileName,
1722: ARGUMENT4 => userenv('LANG'),
1723: ARGUMENT5 => fnd_global.USER_ID,
1724: ARGUMENT6 => fnd_global.user_name,
1725: ARGUMENT7 => 'N',
1726: ARGUMENT8 => 'STORE_CLM_PDF'
1727: );
1728: if (l_return_value = 0) then

Line 4305: X_last_update_login => fnd_global.login_id, -- LAST_UPDATE_LOGIN

4301: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
4302: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE
4303: X_to_pk2_value => to_char(l_line_number(x)), -- PK1_VALUE
4304: X_created_by => p_user_id, -- CREATED_BY
4305: X_last_update_login => fnd_global.login_id, -- LAST_UPDATE_LOGIN
4306: X_orig_attach_doc_id => base_attach_rec.ATTACHED_DOCUMENT_ID
4307: );
4308: END LOOP;
4309:

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

4315: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
4316: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE
4317: X_to_pk2_value => to_char(l_line_number(x)),
4318: X_created_by => p_user_id, -- CREATED_BY
4319: X_last_update_login => fnd_global.login_id -- LAST_UPDATE_LOGIN
4320: );
4321:
4322: END IF; -- g_conformed_doc_copy if
4323: END IF;

Line 5841: fnd_global.login_id

5837: SYSDATE,
5838: p_user_id,
5839: SYSDATE,
5840: p_user_id,
5841: fnd_global.login_id
5842: FROM pon_auc_payments_shipments
5843: WHERE auction_header_id = p_source_auction_header_id
5844: AND line_number >= p_from_line_number
5845: AND line_number <= p_to_line_number

Line 5904: X_last_update_login => fnd_global.login_id, -- LAST_UPDATE_LOGIN

5900: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE
5901: X_to_pk2_value => to_char(payment_line_rec.dest_line_number), -- PK1_VALUE
5902: X_to_pk3_value => to_char(payment_line_rec.dest_payment_id), -- PK1_VALUE
5903: X_created_by => p_user_id, -- CREATED_BY
5904: X_last_update_login => fnd_global.login_id, -- LAST_UPDATE_LOGIN
5905: X_orig_attach_doc_id => base_attach_rec.ATTACHED_DOCUMENT_ID
5906: );
5907: END LOOP;
5908:

Line 5932: X_last_update_login => fnd_global.login_id, -- LAST_UPDATE_LOGIN

5928: X_to_pk1_value => to_char(payment_line_rec.dest_auc_id), -- PK1_VALUE
5929: X_to_pk2_value => to_char(payment_line_rec.dest_line_number), -- PK1_VALUE
5930: X_to_pk3_value => to_char(payment_line_rec.dest_payment_id), -- PK1_VALUE
5931: X_created_by => p_user_id, -- CREATED_BY
5932: X_last_update_login => fnd_global.login_id, -- LAST_UPDATE_LOGIN
5933: X_orig_attach_doc_id => base_attach_rec.ATTACHED_DOCUMENT_ID
5934: );
5935: END LOOP;
5936:

Line 5949: X_last_update_login => fnd_global.login_id

5945: X_to_pk1_value => to_char(payment_line_rec.dest_auc_id),
5946: X_to_pk2_value => to_char(payment_line_rec.dest_line_number),
5947: X_to_pk3_value => to_char(payment_line_rec.dest_payment_id),
5948: X_created_by => p_user_id,
5949: X_last_update_login => fnd_global.login_id
5950: );
5951:
5952: END IF; -- g_conformed_doc_copy
5953: g_err_loc := '4. After calling copy payments attachments';

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

11838: BEGIN
11839: SELECT FND_USER.EMPLOYEE_ID
11840: INTO l_auc_contact_id
11841: FROM FND_USER, HZ_RELATIONSHIPS
11842: WHERE FND_USER.USER_ID = FND_GLOBAL.USER_ID()
11843: AND HZ_RELATIONSHIPS.OBJECT_ID = l_site_id
11844: AND HZ_RELATIONSHIPS.SUBJECT_ID = FND_USER.PERSON_PARTY_ID
11845: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
11846: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'

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

11849: EXCEPTION
11850: WHEN OTHERS THEN
11851: l_auc_contact_id := NULL;
11852: -- Log Error
11853: LOG_MESSAGE('copy_negotiation','Could not determine contact_id for fnd_user_id ' || fnd_global.user_id());
11854: --
11855: -- The way I am adding this error may get changed in the future.
11856: -- So, please be aware of that
11857: FND_MESSAGE.SET_NAME('PON','PON_CONTRACT_COPY_ERR');

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

11854: --
11855: -- The way I am adding this error may get changed in the future.
11856: -- So, please be aware of that
11857: FND_MESSAGE.SET_NAME('PON','PON_CONTRACT_COPY_ERR');
11858: FND_MESSAGE.SET_TOKEN('REASON','Could not determine contact_id for fnd_user_id ' || fnd_global.user_id());
11859: FND_MSG_PUB.ADD;
11860: RAISE FND_API.G_EXC_ERROR;
11861: RETURN;
11862: END;

Line 11998: X_last_update_login => fnd_global.login_id, -- LAST_UPDATE_LOGIN

11994: X_from_pk1_value => base_attach_rec.pk1_value,
11995: X_to_entity_name => 'PON_AUCTION_HEADERS_ALL',
11996: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE
11997: X_created_by => p_user_id, -- CREATED_BY
11998: X_last_update_login => fnd_global.login_id, -- LAST_UPDATE_LOGIN
11999: X_orig_attach_doc_id => base_attach_rec.ATTACHED_DOCUMENT_ID
12000: );
12001: END LOOP;
12002:

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

12006: X_from_pk1_value => to_char(p_source_auction_header_id),
12007: X_to_entity_name => 'PON_AUCTION_HEADERS_ALL',
12008: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE
12009: X_created_by => p_user_id, -- CREATED_BY
12010: X_last_update_login => fnd_global.login_id -- LAST_UPDATE_LOGIN
12011: );
12012: END IF;
12013:
12014: --

Line 12455: fnd_global.login_id

12451: sysdate,
12452: p_user_id,
12453: sysdate,
12454: p_user_id,
12455: fnd_global.login_id
12456: from
12457: pon_price_elements price_elements,
12458: pon_large_neg_pf_values largeNegPFVal
12459: where

Line 12542: fnd_global.login_id

12538: sysdate,
12539: p_user_id,
12540: sysdate,
12541: p_user_id,
12542: fnd_global.login_id
12543: from pon_large_neg_pf_values p, pon_price_element_types_vl vl
12544: where
12545: p.auction_header_id = p_source_auction_hdr_id and
12546: p.price_element_type_id = vl.price_element_type_id and

Line 12609: fnd_global.login_id

12605: sysdate,
12606: p_user_id,
12607: sysdate,
12608: p_user_id,
12609: fnd_global.login_id
12610: from
12611: pon_price_elements price_elements,
12612: pon_bidding_parties bidding_parties
12613: where

Line 12798: fnd_global.login_id,

12794: p_user_id,
12795: SYSDATE,
12796: p_user_id,
12797: SYSDATE,
12798: fnd_global.login_id,
12799: sysdate + 7
12800: );
12801:
12802: LOG_MESSAGE('copy_negotiation','An error has occured during copy');

Line 12867: ,fnd_global.login_id -- last_update_login

12863: ,SYSDATE -- creation_date
12864: ,p_user_id -- created_by
12865: ,SYSDATE -- last_update_date
12866: ,p_user_id -- last_updated_by
12867: ,fnd_global.login_id -- last_update_login
12868: ,old_team.team_id -- orig_team_id
12869: ,old_team.instruction_text
12870: FROM
12871: pon_scoring_teams old_team

Line 12899: ,fnd_global.login_id -- last_update_login

12895: ,SYSDATE -- creation_date
12896: ,p_user_id -- created_by
12897: ,SYSDATE -- last_update_date
12898: ,p_user_id -- last_updated_by
12899: ,fnd_global.login_id -- last_update_login
12900: FROM
12901: pon_scoring_team_members old_members,
12902: pon_scoring_teams old_team,
12903: pon_scoring_teams new_team,

Line 12935: ,fnd_global.login_id -- last_update_login

12931: ,SYSDATE -- creation_date
12932: ,p_user_id -- created_by
12933: ,SYSDATE -- last_update_date
12934: ,p_user_id -- last_updated_by
12935: ,fnd_global.login_id -- last_update_login
12936: FROM
12937: pon_auction_sections new_sections
12938: ,pon_scoring_team_sections old_team_sections
12939: ,pon_scoring_teams new_team

Line 13204: fnd_global.login_id

13200: SYSDATE,
13201: p_user_id,
13202: SYSDATE,
13203: p_user_id,
13204: fnd_global.login_id
13205: FROM pon_evaluation_teams old_team
13206: WHERE old_team.auction_header_id = p_source_auction_header_id;
13207:
13208: -- Create the team members. Do not insert any team members who are not

Line 13231: fnd_global.login_id

13227: SYSDATE,
13228: p_user_id,
13229: SYSDATE,
13230: p_user_id,
13231: fnd_global.login_id
13232: FROM pon_evaluation_team_members old_members,
13233: pon_evaluation_teams old_team,
13234: pon_evaluation_teams new_team,
13235: pon_neg_team_members new_collab

Line 13263: fnd_global.login_id

13259: SYSDATE,
13260: p_user_id,
13261: SYSDATE,
13262: p_user_id,
13263: fnd_global.login_id
13264: FROM pon_auction_sections new_sections,
13265: pon_evaluation_team_sections old_team_sections,
13266: pon_evaluation_teams new_team
13267: WHERE new_sections.auction_header_id = p_auction_header_id

Line 13318: fnd_global.login_id,

13314: ATTR_INT_NAME,
13315: DATA_LEVEL_ID,
13316: SYSDATE,
13317: p_user_id,
13318: fnd_global.login_id,
13319: p_user_id,
13320: SYSDATE,
13321: MULTI_ROW_CODE,
13322: SECTION_ID

Line 13363: fnd_global.login_id,

13359: ATTR_INT_NAME,
13360: DATA_LEVEL_ID,
13361: SYSDATE,
13362: p_user_id,
13363: fnd_global.login_id,
13364: p_user_id,
13365: SYSDATE,
13366: MULTI_ROW_CODE,
13367: DECODE( B.SECTION_ID, NULL, NULL,

Line 13413: fnd_global.login_id,

13409: ATTR_INT_NAME,
13410: DATA_LEVEL_ID,
13411: SYSDATE,
13412: p_user_id,
13413: fnd_global.login_id,
13414: p_user_id,
13415: SYSDATE,
13416: MULTI_ROW_CODE,
13417: SECTION_ID

Line 13458: fnd_global.login_id,

13454: ATTR_INT_NAME,
13455: DATA_LEVEL_ID,
13456: SYSDATE,
13457: p_user_id,
13458: fnd_global.login_id,
13459: p_user_id,
13460: SYSDATE,
13461: MULTI_ROW_CODE,
13462: SECTION_ID

Line 13523: X_last_update_login => fnd_global.login_id, -- LAST_UPDATE_LOGIN

13519: X_to_pk1_value => p_to_pk1_value, -- PK1_VALUE
13520: X_to_pk2_value => p_to_pk2_value,
13521: X_to_pk3_value => p_to_pk3_value,
13522: X_created_by => p_created_by, -- CREATED_BY
13523: X_last_update_login => fnd_global.login_id, -- LAST_UPDATE_LOGIN
13524: X_orig_attach_doc_id => payments_orig_doc_id
13525: );
13526:
13527: ELSE

Line 13539: X_last_update_login => fnd_global.login_id, -- LAST_UPDATE_LOGIN

13535: X_to_pk1_value => p_to_pk1_value, -- PK1_VALUE
13536: X_to_pk2_value => p_to_pk2_value,
13537: X_to_pk3_value => p_to_pk3_value,
13538: X_created_by => p_created_by, -- CREATED_BY
13539: X_last_update_login => fnd_global.login_id, -- LAST_UPDATE_LOGIN
13540: X_orig_attach_doc_id => p_orig_attach_doc_id
13541: );
13542: END IF;
13543: