APPS.PON_TCA_MERGE_PVT dependencies on PON_BIDDING_PARTIES

Line 3396: -- merge for Sourcing PON_BIDDING_PARTIES entity.

3392: -- Pre-reqs : Invitation List entries with the given trading_partner_contact_id
3393: -- (p_From_FK_id) must exists in the database
3394: --
3395: -- Function : This procedure will be attached to the TRADING_PARTNER_CONTACT_ID
3396: -- merge for Sourcing PON_BIDDING_PARTIES entity.
3397: --
3398: -- It will veto Party Merge if -
3399: -- p_From_FK_id and p_To_FK_id both are not Seller user party
3400: --

Line 3401: -- This will merge the all the PON_BIDDING_PARTIES records

3397: --
3398: -- It will veto Party Merge if -
3399: -- p_From_FK_id and p_To_FK_id both are not Seller user party
3400: --
3401: -- This will merge the all the PON_BIDDING_PARTIES records
3402: -- having TRADING_PARTNER_CONTACT_ID equals to p_From_FK_id
3403: -- to party id having value (p_To_FK_id)
3404: --
3405: -- Parameters:

Line 3488: -- PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_ID

3484:
3485: fnd_file.put_line (fnd_file.log, '20 : Buyer Merge - Error');
3486: --
3487: -- This can not happen in any normal scenario as
3488: -- PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_ID
3489: -- can never contain a buyer user id. Thus, raising a veto though
3490: -- it will possibly never be called
3491: --
3492: FND_MESSAGE.SET_NAME('AR', 'PON_TCA_MRG_ERR'); -- Need to put some Sourcing Specific Error Message

Line 3516: UPDATE PON_BIDDING_PARTIES

3512: --
3513: -- there is no chance of unique key constraint violation
3514: -- due to the following updates
3515: --
3516: UPDATE PON_BIDDING_PARTIES
3517: SET LAST_UPDATE_DATE = SYSDATE,
3518: LAST_UPDATED_BY = -1,
3519: TRADING_PARTNER_CONTACT_ID = p_To_FK_id,
3520: TRADING_PARTNER_CONTACT_NAME = l_person_name

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

3519: TRADING_PARTNER_CONTACT_ID = p_To_FK_id,
3520: TRADING_PARTNER_CONTACT_NAME = l_person_name
3521: WHERE TRADING_PARTNER_CONTACT_ID = p_From_FK_id;
3522:
3523: fnd_file.put_line (fnd_file.log, '50 : Seller Merge - Updated TRADING_PARTNER_CONTACT_IDs in PON_BIDDING_PARTIES: '||sql%rowcount||' rows');
3524:
3525: ELSIF (l_merge_scenario = G_IRRELEVANT) THEN
3526: --
3527: -- Nothing to do

Line 3558: -- merge for Sourcing PON_BIDDING_PARTIES entity.

3554: -- Pre-reqs : Invitation List entries with the given ack_partner_contact_id
3555: -- (p_From_FK_id) must exists in the database
3556: --
3557: -- Function : This procedure will be attached to the ACK_PARTNER_CONTACT_ID
3558: -- merge for Sourcing PON_BIDDING_PARTIES entity.
3559: --
3560: -- It will veto Party Merge if -
3561: -- p_From_FK_id and p_To_FK_id both are not Seller user party
3562: --

Line 3563: -- This will merge the all the PON_BIDDING_PARTIES records

3559: --
3560: -- It will veto Party Merge if -
3561: -- p_From_FK_id and p_To_FK_id both are not Seller user party
3562: --
3563: -- This will merge the all the PON_BIDDING_PARTIES records
3564: -- having ACK_PARTNER_CONTACT_ID equals to p_From_FK_id
3565: -- to party id having value (p_To_FK_id)
3566: --
3567: -- Parameters:

Line 3649: -- PON_BIDDING_PARTIES.ACK_PARTNER_CONTACT_ID

3645:
3646: fnd_file.put_line (fnd_file.log, '20 : Buyer or Incompatible Merge - Error');
3647: --
3648: -- This can not happen in any normal scenario as
3649: -- PON_BIDDING_PARTIES.ACK_PARTNER_CONTACT_ID
3650: -- can never contain a buyer user id. Thus, raising a veto though
3651: -- it will possibly never be called
3652: --
3653: FND_MESSAGE.SET_NAME('AR', 'PON_TCA_MRG_ERR'); -- Need to put some Sourcing Specific Error Message

Line 3677: UPDATE PON_BIDDING_PARTIES

3673: --
3674: -- there is no chance of unique key constraint violation
3675: -- due to the following updates
3676: --
3677: UPDATE PON_BIDDING_PARTIES
3678: SET LAST_UPDATE_DATE = SYSDATE,
3679: LAST_UPDATED_BY = -1,
3680: ACK_PARTNER_CONTACT_ID = p_To_FK_id,
3681: ACK_PARTNER_CONTACT_NAME = l_person_name

Line 3684: fnd_file.put_line (fnd_file.log, '50 : Seller Merge - Updated ACK_PARTNER_CONTACT_IDs in PON_BIDDING_PARTIES: '||sql%rowcount||' rows');

3680: ACK_PARTNER_CONTACT_ID = p_To_FK_id,
3681: ACK_PARTNER_CONTACT_NAME = l_person_name
3682: WHERE ACK_PARTNER_CONTACT_ID = p_From_FK_id;
3683:
3684: fnd_file.put_line (fnd_file.log, '50 : Seller Merge - Updated ACK_PARTNER_CONTACT_IDs in PON_BIDDING_PARTIES: '||sql%rowcount||' rows');
3685:
3686: ELSIF (l_merge_scenario = G_IRRELEVANT) THEN
3687: --
3688: -- Nothing to do