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.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_TRADING_PARTNERS

Line 2139: FROM MSC_TRADING_PARTNERS mtp,

2135: msts.TP_SITE_CODE,
2136: msts.LOCATION,
2137: msts.LONGITUDE,
2138: msts.LATITUDE
2139: FROM MSC_TRADING_PARTNERS mtp,
2140: MSC_ST_TRADING_PARTNER_SITES msts
2141: WHERE msts.PARTNER_TYPE= 3
2142: AND msts.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2143: AND mtp.SR_TP_ID= msts.SR_TP_ID

Line 2208: FROM MSC_TRADING_PARTNERS mtps,

2204: msta.LOCATION_CODE,
2205: msta.SR_TP_ID ORGANIZATION_ID,
2206: msta.LOCATION_ID PARTNER_SITE_ID,
2207: msta.SR_INSTANCE_ID
2208: FROM MSC_TRADING_PARTNERS mtps,
2209: MSC_ST_LOCATION_ASSOCIATIONS msta
2210: WHERE msta.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2211: AND msta.partner_type = 3
2212: AND msta.SR_INSTANCE_ID= mtps.SR_INSTANCE_ID

Line 2232: DELETE MSC_TRADING_PARTNERS

2228: -- Organization
2229:
2230: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh OR MSC_CL_COLLECTION.v_is_cont_refresh) THEN
2231:
2232: DELETE MSC_TRADING_PARTNERS
2233: WHERE sr_instance_id= MSC_CL_COLLECTION.v_instance_id
2234: AND partner_type=3
2235: AND nvl(ORG_SUPPLIER_MAPPED,'N') <> 'Y';
2236:

Line 2237: -- MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_TRADING_PARTNERS', MSC_CL_COLLECTION.v_instance_id, NULL,

2233: WHERE sr_instance_id= MSC_CL_COLLECTION.v_instance_id
2234: AND partner_type=3
2235: AND nvl(ORG_SUPPLIER_MAPPED,'N') <> 'Y';
2236:
2237: -- MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_TRADING_PARTNERS', MSC_CL_COLLECTION.v_instance_id, NULL,
2238: -- 'AND PARTNER_TYPE=3');
2239:
2240: END IF;
2241:

Line 2247: 'UPDATE MSC_TRADING_PARTNERS '

2243:
2244: BEGIN
2245:
2246: lv_sql_stmt :=
2247: 'UPDATE MSC_TRADING_PARTNERS '
2248: ||' SET '
2249: ||' COMPANY_ID = :company_id,'
2250: ||' ORGANIZATION_CODE = :ORG_CODE,'
2251: ||' ORGANIZATION_TYPE = :ORG_TYPE,'

Line 2350: INSERT INTO MSC_TRADING_PARTNERS

2346:
2347:
2348: IF SQL%NOTFOUND THEN
2349:
2350: INSERT INTO MSC_TRADING_PARTNERS
2351: ( PARTNER_ID,
2352: /* SCE change starts */
2353: COMPANY_ID,
2354: /* SCE change ends */

Line 2404: ( MSC_Trading_Partners_S.NEXTVAL,

2400: LAST_UPDATED_BY,
2401: CREATION_DATE,
2402: CREATED_BY)
2403: VALUES
2404: ( MSC_Trading_Partners_S.NEXTVAL,
2405: /* SCE change starts */
2406: c_rec.company_id,
2407: /* SCE change ends */
2408: c_rec.ORGANIZATION_CODE,

Line 2554: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS');

2550:
2551: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2552: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2553: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRADING_PARTNER');
2554: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS');
2555: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2556:
2557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2558: RAISE;

Line 2566: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS');

2562:
2563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2564: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2565: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRADING_PARTNER');
2566: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS');
2567: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2568:
2569: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2570: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TP_ID');

Line 2670: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS_SITES');

2666:
2667: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2668: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2669: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRADING_PARTNER');
2670: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS_SITES');
2671: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2672:
2673: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2674: RAISE;

Line 2682: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS_SITES');

2678:
2679: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2680: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2681: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRADING_PARTNER');
2682: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS_SITES');
2683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2684:
2685: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2686: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TP_SITE_ID');

Line 3755: from MSC_TRADING_PARTNERS mtp

3751: Cursor c5 IS
3752: SELECT distinct mst.Partner_Name, mst.Partner_Type
3753: FROM MSC_ST_TRADING_PARTNERS mst
3754: WHERE NOT EXISTS ( select 1
3755: from MSC_TRADING_PARTNERS mtp
3756: where mtp.Partner_Name= mst.Partner_Name
3757: and mtp.Partner_Type= mst.Partner_Type)
3758: AND mst.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
3759: AND mst.Partner_type IN (1,2)

Line 3781: from msc_trading_partners mtp

3777: MINUS
3778: SELECT decode(mtp.company_id,null, null, mtp.company_id) company_id,
3779: mtp.partner_name partner_name,
3780: mtp.partner_type partner_type
3781: from msc_trading_partners mtp
3782: where mtp.partner_type IN (1,2,4) --Vendor/Customer/Carrier
3783: ORDER BY partner_type,
3784: company_id1,
3785: partner_name ;

Line 3793: from MSC_TRADING_PARTNERS mtp

3789: decode(mc.company_id, MSC_CL_COLLECTION.G_MY_COMPANY_ID, -1, mc.company_id) company_id1
3790: FROM MSC_ST_TRADING_PARTNERS mst,
3791: MSC_COMPANIES MC
3792: WHERE EXISTS ( select 1
3793: from MSC_TRADING_PARTNERS mtp
3794: where mtp.sr_tp_id= mst.sr_tp_id
3795: and mtp.sr_instance_id= mst.sr_instance_id
3796: and mtp.Partner_Type= mst.Partner_Type
3797: and nvl(mtp.COMPANY_ID,MSC_CL_COLLECTION.G_MY_COMPANY_ID) = MC.COMPANY_ID

Line 3927: MSC_TRADING_PARTNERS mtp,

3923: mst.SR_INSTANCE_ID,
3924: mst.Partner_Type,
3925: mtp.PARTNER_ID
3926: FROM MSC_ST_TRADING_PARTNERS mst,
3927: MSC_TRADING_PARTNERS mtp,
3928: /* SCE Change starts */
3929: msc_companies mc
3930: /* SCE Change ends */
3931: WHERE NOT EXISTS( select 1

Line 4119: the msc_trading_partners. This generates a lot of unique index violation

4115: --========== Same VENDOR/CUSTOMER with Changed Name ==========
4116: /*
4117: Commented out this piece of code because it does not work for a case where
4118: the Trading partner name is changed to a name which is already existing in
4119: the msc_trading_partners. This generates a lot of unique index violation
4120: of partner_name, partner_type
4121: This fix will be done with the enhancement: 2700654 */
4122:
4123: if (lv_control_flag = 1) then /* Added For Bug 6414426 */

Line 4127: FROM msc_trading_partners

4123: if (lv_control_flag = 1) then /* Added For Bug 6414426 */
4124: FOR c_rec IN c5_tpname LOOP
4125: SELECT count(*)
4126: INTO lv_partner_count
4127: FROM msc_trading_partners
4128: WHERE
4129: partner_name = c_rec.partner_name
4130: AND partner_type = c_rec.partner_type
4131: AND nvl(company_id, -1) = c_rec.company_id1;

Line 4141: UPDATE MSC_TRADING_PARTNERS mtp

4137:
4138: ELSE
4139: BEGIN
4140:
4141: UPDATE MSC_TRADING_PARTNERS mtp
4142: SET mtp.PARTNER_NAME= c_rec.PARTNER_NAME
4143: WHERE mtp.SR_TP_ID= c_rec.SR_TP_ID
4144: AND mtp.SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
4145: AND mtp.PARTNER_TYPE= c_rec.PARTNER_TYPE

Line 4156: FROM msc_trading_partners

4152: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'The value of partner name is: '|| c_rec.PARTNER_NAME);
4153: -- Fetch the Old Partner Id
4154: SELECT partner_id
4155: INTO lv_old_partner_id
4156: FROM msc_trading_partners
4157: WHERE
4158: sr_tp_id = c_rec.SR_TP_ID
4159: AND SR_INSTANCE_ID = c_rec.SR_INSTANCE_ID
4160: AND PARTNER_TYPE = c_rec.PARTNER_TYPE

Line 4167: FROM msc_trading_partners

4163: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'The old Partner_Id IS: ' || to_number(lv_old_partner_id));
4164: -- Fetch the New Partner Id
4165: SELECT partner_id
4166: INTO lv_new_partner_id
4167: FROM msc_trading_partners
4168: WHERE
4169: partner_name= c_rec.partner_name
4170: AND SR_INSTANCE_ID = c_rec.SR_INSTANCE_ID
4171: AND PARTNER_TYPE = c_rec.PARTNER_TYPE

Line 4176: /*DELETE FROM MSC_TRADING_PARTNERS

4172: AND nvl(company_id,-1) = c_rec.company_id1;
4173:
4174: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'The new Partner_Id IS: ' || to_number(lv_new_partner_id));
4175:
4176: /*DELETE FROM MSC_TRADING_PARTNERS
4177: WHERE SR_TP_ID = c_rec.SR_TP_ID
4178: AND SR_INSTANCE_ID = c_rec.SR_INSTANCE_ID
4179: AND PARTNER_TYPE = c_rec.PARTNER_TYPE;
4180:

Line 4203: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS');

4199:
4200: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4201: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4202: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS');
4203: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS');
4204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4205:
4206: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4207: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_TYPE');

Line 4236: INSERT INTO MSC_TRADING_PARTNERS

4232: FOR c_rec IN c5 LOOP
4233:
4234: BEGIN
4235:
4236: INSERT INTO MSC_TRADING_PARTNERS
4237: ( /* SCE Change starts */
4238: COMPANY_ID,
4239: /* SCE Change ends */
4240: PARTNER_NAME,

Line 4257: MSC_Trading_Partners_S.NEXTVAL,

4253: ( /* SCE Change starts */
4254: c_rec.COMPANY_ID1,
4255: /* SCE Change ends */
4256: c_rec.Partner_Name,
4257: MSC_Trading_Partners_S.NEXTVAL,
4258: MSC_Trading_Partners_S.NEXTVAL, -- dummy value to satisfy the unique constraint
4259: c_rec.Partner_Type,
4260: -1,
4261: -1,

Line 4258: MSC_Trading_Partners_S.NEXTVAL, -- dummy value to satisfy the unique constraint

4254: c_rec.COMPANY_ID1,
4255: /* SCE Change ends */
4256: c_rec.Partner_Name,
4257: MSC_Trading_Partners_S.NEXTVAL,
4258: MSC_Trading_Partners_S.NEXTVAL, -- dummy value to satisfy the unique constraint
4259: c_rec.Partner_Type,
4260: -1,
4261: -1,
4262: -1,

Line 4280: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS');

4276:
4277: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4278: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4279: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
4280: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS');
4281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4282:
4283: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4284: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_NAME');

Line 4415: MSC_TRADING_PARTNERS mtp,

4411: mtp.PARTNER_ID,
4412: mst.AGGREGATE_DEMAND_FLAG,
4413: mst.CUST_ACCOUNT_NUMBER
4414: FROM MSC_ST_TRADING_PARTNERS mst,
4415: MSC_TRADING_PARTNERS mtp,
4416: MSC_COMPANIES mc
4417: WHERE NOT EXISTS( select 1
4418: from MSC_TP_ID_LID mtil
4419: where mst.SR_TP_ID= mtil.SR_TP_ID

Line 4895: UPDATE MSC_TRADING_PARTNERS mtp

4891: FOR c_rec IN c1 LOOP
4892:
4893: BEGIN
4894:
4895: UPDATE MSC_TRADING_PARTNERS mtp
4896: SET ORGANIZATION_CODE= c_rec.ORGANIZATION_CODE,
4897: SR_TP_ID= c_rec.SR_TP_ID,
4898: DISABLE_DATE= c_rec.Disable_Date,
4899: STATUS= c_rec.Status,

Line 4933: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS');

4929:
4930: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4931: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4932: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
4933: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS');
4934: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4935:
4936: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4937: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_TYPE');

Line 4959: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS');

4955:
4956: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4957: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4958: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
4959: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS');
4960: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4961:
4962: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4963: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_TYPE');