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_TCA_MERGE_PVT dependencies on PON_OPTIMIZE_CONSTRAINTS

Line 4181: -- merge for Sourcing PON_OPTIMIZE_CONSTRAINTS entity.

4177: -- Pre-reqs : Optimization Scenario with the given trading_partner_contact_id
4178: -- (p_From_FK_id) must exists in the database
4179: --
4180: -- Function : This procedure will be attached to the TRADING_PARTNER_CONTACT_ID
4181: -- merge for Sourcing PON_OPTIMIZE_CONSTRAINTS entity.
4182: --
4183: -- It will veto Party Merge if -
4184: -- p_From_FK_id and p_To_FK_id both are not Seller user party
4185: --

Line 4186: -- This will merge the all the PON_OPTIMIZE_CONSTRAINTS records

4182: --
4183: -- It will veto Party Merge if -
4184: -- p_From_FK_id and p_To_FK_id both are not Seller user party
4185: --
4186: -- This will merge the all the PON_OPTIMIZE_CONSTRAINTS records
4187: -- having TRADING_PARTNER_CONTACT_ID equals to p_From_FK_id
4188: -- to party id having value (p_To_FK_id)
4189: --
4190: -- Parameters:

Line 4271: -- PON_OPTIMIZE_CONSTRAINTS.TRADING_PARTNER_CONTACT_ID

4267:
4268: fnd_file.put_line (fnd_file.log, '20 : Buyer or Incompatible Merge - Error');
4269: --
4270: -- This can not happen in any normal scenario as
4271: -- PON_OPTIMIZE_CONSTRAINTS.TRADING_PARTNER_CONTACT_ID
4272: -- can never contain a buyer user id. Thus, raising a veto though
4273: -- it will possibly never be called
4274: --
4275: FND_MESSAGE.SET_NAME('AR', 'PON_TCA_MRG_ERR'); -- Need to put some Sourcing Specific Error Message

Line 4287: UPDATE PON_OPTIMIZE_CONSTRAINTS

4283: --
4284: -- there is no chance of unique key constraint violation
4285: -- due to the following updates
4286: --
4287: UPDATE PON_OPTIMIZE_CONSTRAINTS
4288: SET LAST_UPDATE_DATE = SYSDATE,
4289: LAST_UPDATED_BY = -1,
4290: TRADING_PARTNER_CONTACT_ID = p_To_FK_id
4291: WHERE TRADING_PARTNER_CONTACT_ID = p_From_FK_id;

Line 4293: fnd_file.put_line (fnd_file.log, '50 : Seller Merge - Updated TRADING_PARTNER_CONTACT_IDs in PON_OPTIMIZE_CONSTRAINTS: '||sql%rowcount||' rows');

4289: LAST_UPDATED_BY = -1,
4290: TRADING_PARTNER_CONTACT_ID = p_To_FK_id
4291: WHERE TRADING_PARTNER_CONTACT_ID = p_From_FK_id;
4292:
4293: fnd_file.put_line (fnd_file.log, '50 : Seller Merge - Updated TRADING_PARTNER_CONTACT_IDs in PON_OPTIMIZE_CONSTRAINTS: '||sql%rowcount||' rows');
4294:
4295: ELSIF (l_merge_scenario = G_IRRELEVANT) THEN
4296: --
4297: -- Nothing to do