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 2145: FROM MSC_TRADING_PARTNERS mtp,

2141: msts.TP_SITE_CODE,
2142: msts.LOCATION,
2143: msts.LONGITUDE,
2144: msts.LATITUDE
2145: FROM MSC_TRADING_PARTNERS mtp,
2146: MSC_ST_TRADING_PARTNER_SITES msts
2147: WHERE msts.PARTNER_TYPE= 3
2148: AND msts.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2149: AND mtp.SR_TP_ID= msts.SR_TP_ID

Line 2214: FROM MSC_TRADING_PARTNERS mtps,

2210: msta.LOCATION_CODE,
2211: msta.SR_TP_ID ORGANIZATION_ID,
2212: msta.LOCATION_ID PARTNER_SITE_ID,
2213: msta.SR_INSTANCE_ID
2214: FROM MSC_TRADING_PARTNERS mtps,
2215: MSC_ST_LOCATION_ASSOCIATIONS msta
2216: WHERE msta.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2217: AND msta.partner_type = 3
2218: AND msta.SR_INSTANCE_ID= mtps.SR_INSTANCE_ID

Line 2238: DELETE MSC_TRADING_PARTNERS

2234: -- Organization
2235:
2236: 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
2237:
2238: DELETE MSC_TRADING_PARTNERS
2239: WHERE sr_instance_id= MSC_CL_COLLECTION.v_instance_id
2240: AND partner_type=3
2241: AND nvl(ORG_SUPPLIER_MAPPED,'N') <> 'Y';
2242:

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

2239: WHERE sr_instance_id= MSC_CL_COLLECTION.v_instance_id
2240: AND partner_type=3
2241: AND nvl(ORG_SUPPLIER_MAPPED,'N') <> 'Y';
2242:
2243: -- MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_TRADING_PARTNERS', MSC_CL_COLLECTION.v_instance_id, NULL,
2244: -- 'AND PARTNER_TYPE=3');
2245:
2246: END IF;
2247:

Line 2253: 'UPDATE MSC_TRADING_PARTNERS '

2249:
2250: BEGIN
2251:
2252: lv_sql_stmt :=
2253: 'UPDATE MSC_TRADING_PARTNERS '
2254: ||' SET '
2255: ||' COMPANY_ID = :company_id,'
2256: ||' ORGANIZATION_CODE = :ORG_CODE,'
2257: ||' ORGANIZATION_TYPE = :ORG_TYPE,'

Line 2358: INSERT INTO MSC_TRADING_PARTNERS

2354:
2355:
2356: IF SQL%NOTFOUND THEN
2357:
2358: INSERT INTO MSC_TRADING_PARTNERS
2359: ( PARTNER_ID,
2360: /* SCE change starts */
2361: COMPANY_ID,
2362: /* SCE change ends */

Line 2413: ( MSC_Trading_Partners_S.NEXTVAL,

2409: LAST_UPDATED_BY,
2410: CREATION_DATE,
2411: CREATED_BY)
2412: VALUES
2413: ( MSC_Trading_Partners_S.NEXTVAL,
2414: /* SCE change starts */
2415: c_rec.company_id,
2416: /* SCE change ends */
2417: c_rec.ORGANIZATION_CODE,

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

2560:
2561: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2562: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2563: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRADING_PARTNER');
2564: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS');
2565: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2566:
2567: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2568: RAISE;

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

2572:
2573: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2574: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2575: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRADING_PARTNER');
2576: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS');
2577: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2578:
2579: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2580: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TP_ID');

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

2676:
2677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2678: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2679: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRADING_PARTNER');
2680: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS_SITES');
2681: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2682:
2683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2684: RAISE;

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

2688:
2689: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2690: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2691: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRADING_PARTNER');
2692: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS_SITES');
2693: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2694:
2695: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2696: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TP_SITE_ID');

Line 3765: from MSC_TRADING_PARTNERS mtp

3761: Cursor c5 IS
3762: SELECT distinct mst.Partner_Name, mst.Partner_Type
3763: FROM MSC_ST_TRADING_PARTNERS mst
3764: WHERE NOT EXISTS ( select 1
3765: from MSC_TRADING_PARTNERS mtp
3766: where mtp.Partner_Name= mst.Partner_Name
3767: and mtp.Partner_Type= mst.Partner_Type)
3768: AND mst.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
3769: AND mst.Partner_type IN (1,2)

Line 3791: from msc_trading_partners mtp

3787: MINUS
3788: SELECT decode(mtp.company_id,null, null, mtp.company_id) company_id,
3789: mtp.partner_name partner_name,
3790: mtp.partner_type partner_type
3791: from msc_trading_partners mtp
3792: where mtp.partner_type IN (1,2,4) --Vendor/Customer/Carrier
3793: ORDER BY partner_type,
3794: company_id1,
3795: partner_name ;

Line 3803: from MSC_TRADING_PARTNERS mtp

3799: decode(mc.company_id, MSC_CL_COLLECTION.G_MY_COMPANY_ID, -1, mc.company_id) company_id1
3800: FROM MSC_ST_TRADING_PARTNERS mst,
3801: MSC_COMPANIES MC
3802: WHERE EXISTS ( select 1
3803: from MSC_TRADING_PARTNERS mtp
3804: where mtp.sr_tp_id= mst.sr_tp_id
3805: and mtp.sr_instance_id= mst.sr_instance_id
3806: and mtp.Partner_Type= mst.Partner_Type
3807: and nvl(mtp.COMPANY_ID,MSC_CL_COLLECTION.G_MY_COMPANY_ID) = MC.COMPANY_ID

Line 3937: MSC_TRADING_PARTNERS mtp,

3933: mst.SR_INSTANCE_ID,
3934: mst.Partner_Type,
3935: mtp.PARTNER_ID
3936: FROM MSC_ST_TRADING_PARTNERS mst,
3937: MSC_TRADING_PARTNERS mtp,
3938: /* SCE Change starts */
3939: msc_companies mc
3940: /* SCE Change ends */
3941: WHERE NOT EXISTS( select 1

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

4125: --========== Same VENDOR/CUSTOMER with Changed Name ==========
4126: /*
4127: Commented out this piece of code because it does not work for a case where
4128: the Trading partner name is changed to a name which is already existing in
4129: the msc_trading_partners. This generates a lot of unique index violation
4130: of partner_name, partner_type
4131: This fix will be done with the enhancement: 2700654 */
4132:
4133: if (lv_control_flag = 1) then /* Added For Bug 6414426 */

Line 4137: FROM msc_trading_partners

4133: if (lv_control_flag = 1) then /* Added For Bug 6414426 */
4134: FOR c_rec IN c5_tpname LOOP
4135: SELECT count(*)
4136: INTO lv_partner_count
4137: FROM msc_trading_partners
4138: WHERE
4139: partner_name = c_rec.partner_name
4140: AND partner_type = c_rec.partner_type
4141: AND nvl(company_id, -1) = c_rec.company_id1;

Line 4151: UPDATE MSC_TRADING_PARTNERS mtp

4147:
4148: ELSE
4149: BEGIN
4150:
4151: UPDATE MSC_TRADING_PARTNERS mtp
4152: SET mtp.PARTNER_NAME= c_rec.PARTNER_NAME
4153: WHERE mtp.SR_TP_ID= c_rec.SR_TP_ID
4154: AND mtp.SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
4155: AND mtp.PARTNER_TYPE= c_rec.PARTNER_TYPE

Line 4166: FROM msc_trading_partners

4162: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'The value of partner name is: '|| c_rec.PARTNER_NAME);
4163: -- Fetch the Old Partner Id
4164: SELECT partner_id
4165: INTO lv_old_partner_id
4166: FROM msc_trading_partners
4167: WHERE
4168: sr_tp_id = c_rec.SR_TP_ID
4169: AND SR_INSTANCE_ID = c_rec.SR_INSTANCE_ID
4170: AND PARTNER_TYPE = c_rec.PARTNER_TYPE

Line 4177: FROM msc_trading_partners

4173: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'The old Partner_Id IS: ' || to_number(lv_old_partner_id));
4174: -- Fetch the New Partner Id
4175: SELECT partner_id
4176: INTO lv_new_partner_id
4177: FROM msc_trading_partners
4178: WHERE
4179: partner_name= c_rec.partner_name
4180: AND SR_INSTANCE_ID = c_rec.SR_INSTANCE_ID
4181: AND PARTNER_TYPE = c_rec.PARTNER_TYPE

Line 4186: /*DELETE FROM MSC_TRADING_PARTNERS

4182: AND nvl(company_id,-1) = c_rec.company_id1;
4183:
4184: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'The new Partner_Id IS: ' || to_number(lv_new_partner_id));
4185:
4186: /*DELETE FROM MSC_TRADING_PARTNERS
4187: WHERE SR_TP_ID = c_rec.SR_TP_ID
4188: AND SR_INSTANCE_ID = c_rec.SR_INSTANCE_ID
4189: AND PARTNER_TYPE = c_rec.PARTNER_TYPE;
4190:

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

4209:
4210: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4211: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4212: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS');
4213: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS');
4214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4215:
4216: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4217: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_TYPE');

Line 4246: INSERT INTO MSC_TRADING_PARTNERS

4242: FOR c_rec IN c5 LOOP
4243:
4244: BEGIN
4245:
4246: INSERT INTO MSC_TRADING_PARTNERS
4247: ( /* SCE Change starts */
4248: COMPANY_ID,
4249: /* SCE Change ends */
4250: PARTNER_NAME,

Line 4267: MSC_Trading_Partners_S.NEXTVAL,

4263: ( /* SCE Change starts */
4264: c_rec.COMPANY_ID1,
4265: /* SCE Change ends */
4266: c_rec.Partner_Name,
4267: MSC_Trading_Partners_S.NEXTVAL,
4268: MSC_Trading_Partners_S.NEXTVAL, -- dummy value to satisfy the unique constraint
4269: c_rec.Partner_Type,
4270: -1,
4271: -1,

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

4264: c_rec.COMPANY_ID1,
4265: /* SCE Change ends */
4266: c_rec.Partner_Name,
4267: MSC_Trading_Partners_S.NEXTVAL,
4268: MSC_Trading_Partners_S.NEXTVAL, -- dummy value to satisfy the unique constraint
4269: c_rec.Partner_Type,
4270: -1,
4271: -1,
4272: -1,

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

4286:
4287: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4288: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4289: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
4290: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS');
4291: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4292:
4293: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4294: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_NAME');

Line 4425: MSC_TRADING_PARTNERS mtp,

4421: mtp.PARTNER_ID,
4422: mst.AGGREGATE_DEMAND_FLAG,
4423: mst.CUST_ACCOUNT_NUMBER
4424: FROM MSC_ST_TRADING_PARTNERS mst,
4425: MSC_TRADING_PARTNERS mtp,
4426: MSC_COMPANIES mc
4427: WHERE NOT EXISTS( select 1
4428: from MSC_TP_ID_LID mtil
4429: where mst.SR_TP_ID= mtil.SR_TP_ID

Line 4905: UPDATE MSC_TRADING_PARTNERS mtp

4901: FOR c_rec IN c1 LOOP
4902:
4903: BEGIN
4904:
4905: UPDATE MSC_TRADING_PARTNERS mtp
4906: SET ORGANIZATION_CODE= c_rec.ORGANIZATION_CODE,
4907: SR_TP_ID= c_rec.SR_TP_ID,
4908: DISABLE_DATE= c_rec.Disable_Date,
4909: STATUS= c_rec.Status,

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

4939:
4940: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4941: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4942: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
4943: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS');
4944: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4945:
4946: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4947: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_TYPE');

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

4965:
4966: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4967: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4968: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
4969: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS');
4970: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4971:
4972: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4973: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_TYPE');