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.CSI_MASS_EDIT_PUB dependencies on HZ_PARTIES

Line 1457: AND PARTY_SOURCE_TABLE = 'HZ_PARTIES'

1453: SELECT TXN_LINE_DETAIL_ID FROM CSI_T_TXN_LINE_DETAILS CTLD, CSI_MASS_EDIT_ENTRIES_VL CMEE
1454: WHERE CTLD.TRANSACTION_LINE_ID = CMEE.TXN_LINE_ID
1455: AND CMEE.ENTRY_ID = p_entry_id
1456: AND INSTANCE_ID IS NULL)
1457: AND PARTY_SOURCE_TABLE = 'HZ_PARTIES'
1458: AND RELATIONSHIP_TYPE_CODE = 'OWNER'
1459: AND ROWNUM = 1;
1460:
1461: SELECT 'x' INTO l_old_owner

Line 1467: AND PARTY_SOURCE_TABLE = 'HZ_PARTIES'

1463: SELECT TXN_LINE_DETAIL_ID FROM CSI_T_TXN_LINE_DETAILS CTLD, CSI_MASS_EDIT_ENTRIES_VL CMEE
1464: WHERE CTLD.TRANSACTION_LINE_ID = CMEE.TXN_LINE_ID
1465: AND CMEE.ENTRY_ID = p_entry_id
1466: AND INSTANCE_ID IS NOT NULL)
1467: AND PARTY_SOURCE_TABLE = 'HZ_PARTIES'
1468: AND RELATIONSHIP_TYPE_CODE = 'OWNER'
1469: AND ROWNUM = 1;
1470:
1471: debug('l_old_owner type - ' || l_old_owner);

Line 1481: as the owner type is not HZ_PARTIES');

1477:
1478: EXCEPTION
1479: WHEN OTHERS THEN
1480: debug('The Batch doesn not qualify for system mass update
1481: as the owner type is not HZ_PARTIES');
1482: l_perform_system_mu := 'N';
1483: END;
1484:
1485: -- The processing of systems must proceed only if the owner type is HZ_PARTIES

Line 1485: -- The processing of systems must proceed only if the owner type is HZ_PARTIES

1481: as the owner type is not HZ_PARTIES');
1482: l_perform_system_mu := 'N';
1483: END;
1484:
1485: -- The processing of systems must proceed only if the owner type is HZ_PARTIES
1486: IF l_batch_type in ('XFER') AND l_system_cascade = 'Y' AND l_perform_system_mu = 'Y' THEN
1487: IF n_instance_tbl.count > 0 THEN
1488:
1489: -- Call the PROCESS_SYSTEM_MASS_UPDATE to

Line 2372: hz_parties party,

2368: party.party_number PartyNumber
2369: FROM csi_t_txn_line_details tld,
2370: csi_t_party_details tp,
2371: csi_t_party_accounts ta,
2372: hz_parties party,
2373: hz_cust_accounts account
2374: WHERE tld.txn_line_detail_id = tp.txn_line_detail_id
2375: AND tld.transaction_line_id = p_transaction_line_id
2376: AND tld.INSTANCE_ID IS NULL

Line 2381: AND tp.party_source_table = 'HZ_PARTIES';

2377: AND tp.txn_party_detail_id = ta.txn_party_detail_id
2378: AND tp.party_source_id = party.party_id
2379: AND ta.account_id = account.cust_account_id
2380: AND tp.relationship_type_code = 'OWNER'
2381: AND tp.party_source_table = 'HZ_PARTIES';
2382: -- Bug 7350165
2383: -- CURSOR mu_customer_id_csr (p_party_id IN NUMBER, p_account_number IN NUMBER) IS
2384: -- SELECT CUST_ACCOUNT_ID CUSTOMER_ID
2385: -- FROM HZ_CUST_ACCOUNTS

Line 3453: nvl(l_instance.OWNER_PARTY_TYPE, fnd_api.g_miss_char) <> 'HZ_PARTIES' AND

3449: END IF;
3450:
3451: --Validating Owner party
3452: IF(l_instance.OWNER_ID IS NULL AND
3453: nvl(l_instance.OWNER_PARTY_TYPE, fnd_api.g_miss_char) <> 'HZ_PARTIES' AND
3454: nvl(l_instance.INTERNALLY_OWNED, 'N') = 'N') THEN
3455: IF(l_instance.OWNER_PARTY_NUM IS NOT NULL AND l_instance.OWNER_NAME IS NOT NULL) THEN
3456: debug_out('In the uploaded create record #' || xls_idx ||
3457: '. For Employee/Vendor party type, Invalid Value(s) or invaid ' ||

Line 3484: IF(l_instance.OWNER_ID IS NULL AND l_instance.OWNER_PARTY_TYPE = 'HZ_PARTIES') THEN

3480: ELSE
3481: debug('Validation for Owner details is not required.');
3482: END IF;
3483:
3484: IF(l_instance.OWNER_ID IS NULL AND l_instance.OWNER_PARTY_TYPE = 'HZ_PARTIES') THEN
3485: IF(l_instance.OWNER_PARTY_NUM IS NULL) THEN
3486: debug_out('In the uploaded create record #' || xls_idx ||
3487: '. Value not entered for column: Owner Party Num.');
3488: isRecValid := false;

Line 3502: ELSIF(l_instance.OWNER_PARTY_TYPE = 'HZ_PARTIES') THEN

3498: IF(l_instance.OWNER_ACCOUNT_NUMBER IS NOT NULL) THEN
3499: debug_out('In the uploaded create record #' || xls_idx ||
3500: '. Invalid value for column: Owner Account Number');
3501: isRecValid := false;
3502: ELSIF(l_instance.OWNER_PARTY_TYPE = 'HZ_PARTIES') THEN
3503: debug_out('In the uploaded create record #' || xls_idx ||
3504: '. Value not entered for Mandatory column: Owner Account Number.');
3505: isRecValid := false;
3506: END IF;

Line 3527: AND l_instance.ASSOCIATE_BILL_TO_PARTY_TYPE <> 'HZ_PARTIES') THEN

3523:
3524: --Validating Bill To Party
3525: IF(l_instance.ASSOCIATE_BILL_TO_PARTY_ID IS NULL
3526: AND l_instance.ASSOCIATE_BILL_TO_PARTY_TYPE IS NOT NULL
3527: AND l_instance.ASSOCIATE_BILL_TO_PARTY_TYPE <> 'HZ_PARTIES') THEN
3528: IF(l_instance.ASSOCIATE_BILL_TO_PARTY_NUMBER IS NOT NULL
3529: AND l_instance.ASSOCIATE_BILL_TO_PARTY_NAME IS NOT NULL) THEN
3530: debug_out('In the uploaded create record #' || xls_idx ||
3531: '. For Employee/Vendor party type, invalid Value(s) ' ||

Line 3553: AND l_instance.ASSOCIATE_BILL_TO_PARTY_TYPE = 'HZ_PARTIES'

3549: END IF;
3550: END IF;
3551:
3552: IF(l_instance.ASSOCIATE_BILL_TO_PARTY_ID IS NULL
3553: AND l_instance.ASSOCIATE_BILL_TO_PARTY_TYPE = 'HZ_PARTIES'
3554: AND l_instance.ASSOCIATE_BILL_TO_PARTY_NUMBER IS NOT NULL) THEN
3555: debug_out('In the uploaded create record #' || xls_idx ||
3556: '. Invalid value entered for column: Associate Bill To Party Number.');
3557: isRecValid := false;

Line 3580: AND l_instance.ASSOCIATE_SHIP_TO_PARTY_TYPE <> 'HZ_PARTIES') THEN

3576:
3577: --Validating Ship To Party
3578: IF(l_instance.ASSOCIATE_SHIP_TO_PARTY_ID IS NULL
3579: AND l_instance.ASSOCIATE_SHIP_TO_PARTY_TYPE IS NOT NULL
3580: AND l_instance.ASSOCIATE_SHIP_TO_PARTY_TYPE <> 'HZ_PARTIES') THEN
3581: IF(l_instance.ASSOCIATE_SHIP_TO_PARTY_NUMBER IS NOT NULL
3582: AND l_instance.ASSOCIATE_SHIP_TO_PARTY_NAME IS NOT NULL) THEN
3583: debug_out('In the uploaded update record #' || xls_idx ||
3584: '. For Employee/Vendor party type, Invalid Value(s) or invaid' ||

Line 3606: AND l_instance.ASSOCIATE_SHIP_TO_PARTY_TYPE = 'HZ_PARTIES'

3602: END IF;
3603: END IF;
3604:
3605: IF(l_instance.ASSOCIATE_SHIP_TO_PARTY_ID IS NULL
3606: AND l_instance.ASSOCIATE_SHIP_TO_PARTY_TYPE = 'HZ_PARTIES'
3607: AND l_instance.ASSOCIATE_SHIP_TO_PARTY_NUMBER IS NOT NULL) THEN
3608: debug_out('In the uploaded update record #' || xls_idx ||
3609: '. Invalid value entered for column: Associate Ship To Party Number.');
3610: isRecValid := false;

Line 3947: c_party_tbl(party_idx).party_source_table := 'HZ_PARTIES';

3943: WHEN others THEN
3944: raise fnd_api.g_exc_error;
3945: END;
3946:
3947: c_party_tbl(party_idx).party_source_table := 'HZ_PARTIES';
3948: c_party_tbl(party_idx).party_id := l_internal_party_id;
3949: --Added for Bug 10414679
3950: l_log_tbl(inst_idx).INTERNALLY_OWNED := 'Y';
3951: l_log_tbl(inst_idx).OWNER_PARTY_NUM := ' ';

Line 3966: IF l_instance.OWNER_PARTY_TYPE = 'HZ_PARTIES' THEN

3962: l_log_tbl(inst_idx).OWNER_PARTY_NUM := l_instance.OWNER_PARTY_NUM;
3963: l_log_tbl(inst_idx).OWNER_NAME := l_instance.OWNER_NAME;
3964:
3965: --Account Record
3966: IF l_instance.OWNER_PARTY_TYPE = 'HZ_PARTIES' THEN
3967: debug('Populating owner account details.');
3968: account_idx := account_idx + 1;
3969: c_account_tbl(account_idx).ip_account_id := fnd_api.g_miss_num;
3970: c_account_tbl(account_idx).instance_party_id := fnd_api.g_miss_num;

Line 4696: nvl(l_instance.OWNER_PARTY_TYPE, fnd_api.g_miss_char) <> 'HZ_PARTIES') THEN

4692: xls_idx := xls_idx + 1;
4693:
4694: --Validating Owner party
4695: IF(l_instance.OWNER_ID IS NULL AND
4696: nvl(l_instance.OWNER_PARTY_TYPE, fnd_api.g_miss_char) <> 'HZ_PARTIES') THEN
4697: IF(l_instance.OWNER_PARTY_NUM IS NOT NULL AND l_instance.OWNER_NAME IS NOT NULL) THEN
4698: debug_out('In the uploaded update record #' || xls_idx ||
4699: '. For Employee/Vendor party type, invalid Value(s) or invaid combination of' ||
4700: ' values for columns: Owner Party Num, Owner Name.');

Line 4715: IF(l_instance.OWNER_ID IS NULL AND l_instance.OWNER_PARTY_TYPE = 'HZ_PARTIES') THEN

4711: END IF;
4712: END IF;
4713: END IF;
4714:
4715: IF(l_instance.OWNER_ID IS NULL AND l_instance.OWNER_PARTY_TYPE = 'HZ_PARTIES') THEN
4716: IF(l_instance.OWNER_PARTY_NUM IS NULL) THEN
4717: debug_out('In the uploaded update record #' || xls_idx ||
4718: '. Value not entered for column: Owner Party Num.');
4719: isRecValid := false;

Line 4761: AND l_instance.ASSOCIATE_BILL_TO_PARTY_TYPE <> 'HZ_PARTIES') THEN

4757:
4758: --Validating Bill To Party
4759: IF(l_instance.ASSOCIATE_BILL_TO_PARTY_ID IS NULL
4760: AND l_instance.ASSOCIATE_BILL_TO_PARTY_TYPE IS NOT NULL
4761: AND l_instance.ASSOCIATE_BILL_TO_PARTY_TYPE <> 'HZ_PARTIES') THEN
4762: IF(l_instance.ASSOCIATE_BILL_TO_PARTY_NUMBER IS NOT NULL
4763: AND l_instance.ASSOCIATE_BILL_TO_PARTY_NAME IS NOT NULL) THEN
4764: debug_out('In the uploaded update record #' || xls_idx ||
4765: '. For Employee/Vendor party type, invalid Value(s) ' ||

Line 4787: AND l_instance.ASSOCIATE_BILL_TO_PARTY_TYPE = 'HZ_PARTIES'

4783: END IF;
4784: END IF;
4785:
4786: IF(l_instance.ASSOCIATE_BILL_TO_PARTY_ID IS NULL
4787: AND l_instance.ASSOCIATE_BILL_TO_PARTY_TYPE = 'HZ_PARTIES'
4788: AND l_instance.ASSOCIATE_BILL_TO_PARTY_NUMBER IS NOT NULL) THEN
4789: debug_out('In the uploaded update record #' || xls_idx ||
4790: '. Invalid value entered for column: Associate Bill To Party Number.');
4791: isRecValid := false;

Line 4815: AND l_instance.ASSOCIATE_SHIP_TO_PARTY_TYPE <> 'HZ_PARTIES') THEN

4811:
4812: --Validating Ship To Party
4813: IF(l_instance.ASSOCIATE_SHIP_TO_PARTY_ID IS NULL
4814: AND l_instance.ASSOCIATE_SHIP_TO_PARTY_TYPE IS NOT NULL
4815: AND l_instance.ASSOCIATE_SHIP_TO_PARTY_TYPE <> 'HZ_PARTIES') THEN
4816: IF(l_instance.ASSOCIATE_SHIP_TO_PARTY_NUMBER IS NOT NULL
4817: AND l_instance.ASSOCIATE_SHIP_TO_PARTY_NAME IS NOT NULL) THEN
4818: debug_out('In the uploaded update record #' || xls_idx ||
4819: '. For Employee/Vendor party type, Invalid Value(s) or invaid' ||

Line 4841: AND l_instance.ASSOCIATE_SHIP_TO_PARTY_TYPE = 'HZ_PARTIES'

4837: END IF;
4838: END IF;
4839:
4840: IF(l_instance.ASSOCIATE_SHIP_TO_PARTY_ID IS NULL
4841: AND l_instance.ASSOCIATE_SHIP_TO_PARTY_TYPE = 'HZ_PARTIES'
4842: AND l_instance.ASSOCIATE_SHIP_TO_PARTY_NUMBER IS NOT NULL) THEN
4843: debug_out('In the uploaded update record #' || xls_idx ||
4844: '. Invalid value entered for column: Associate Ship To Party Number.');
4845: isRecValid := false;

Line 4913: FROM csi_systems_vl sys, HZ_PARTIES hzp, HZ_CUST_ACCOUNTS acct,

4909: SELECT system_id
4910: INTO l_cust_sys_id
4911: FROM
4912: ( SELECT sys.system_id
4913: FROM csi_systems_vl sys, HZ_PARTIES hzp, HZ_CUST_ACCOUNTS acct,
4914: CSI_LOOKUPS LK
4915: WHERE sys.CUSTOMER_ID = acct.CUST_ACCOUNT_ID
4916: and acct.PARTY_ID = hzp.PARTY_ID
4917: and acct.account_number = l_instance.OWNER_ACCOUNT_NUMBER

Line 4923: FROM csi_systems_vl sys, HZ_PARTIES hzp, HZ_CUST_ACCOUNTS acct,

4919: and LK.LOOKUP_TYPE (+) = 'CSI_SYSTEM_TYPE'
4920: and sys.name = l_instance.SYSTEM_NAME
4921: UNION
4922: SELECT sys.system_id
4923: FROM csi_systems_vl sys, HZ_PARTIES hzp, HZ_CUST_ACCOUNTS acct,
4924: HZ_CUST_ACCT_RELATE_ALL acctall, CSI_LOOKUPS LK
4925: WHERE sys.CUSTOMER_ID = acctall.RELATED_CUST_ACCOUNT_ID
4926: and sys.CUSTOMER_ID = acct.CUST_ACCOUNT_ID
4927: and acct.PARTY_ID = hzp.PARTY_ID

Line 5534: IF l_instance.OWNER_PARTY_TYPE = 'HZ_PARTIES'

5530: u_party_tbl(party_idx).party_source_table := l_instance.OWNER_PARTY_TYPE;
5531: u_party_tbl(party_idx).party_id := l_instance.OWNER_ID;
5532: u_party_tbl(party_idx).CASCADE_OWNERSHIP_FLAG := l_instance.CASCADE_UPDATE;
5533: --Account Record
5534: IF l_instance.OWNER_PARTY_TYPE = 'HZ_PARTIES'
5535: AND nvl(l_internal_party_id, fnd_api.g_miss_num) <>
5536: nvl(l_instance.OWNER_ID, fnd_api.g_miss_num) THEN
5537: debug('Populating owner account details.');
5538: account_idx := account_idx + 1;

Line 6289: 'HZ_PARTIES',

6285: BEGIN
6286: UPDATE csi_webadi_staging cws SET OWNER_ID =
6287: (
6288: decode(cws.OWNER_PARTY_TYPE,
6289: 'HZ_PARTIES',
6290: (SELECT party_id FROM hz_parties WHERE party_number = cws.OWNER_PARTY_NUM),
6291: 'EMPLOYEE',
6292: (SELECT employee_id FROM per_employees_current_x
6293: WHERE employee_num = cws.OWNER_PARTY_NUM

Line 6290: (SELECT party_id FROM hz_parties WHERE party_number = cws.OWNER_PARTY_NUM),

6286: UPDATE csi_webadi_staging cws SET OWNER_ID =
6287: (
6288: decode(cws.OWNER_PARTY_TYPE,
6289: 'HZ_PARTIES',
6290: (SELECT party_id FROM hz_parties WHERE party_number = cws.OWNER_PARTY_NUM),
6291: 'EMPLOYEE',
6292: (SELECT employee_id FROM per_employees_current_x
6293: WHERE employee_num = cws.OWNER_PARTY_NUM
6294: AND full_name = cws.OWNER_NAME),

Line 6317: 'HZ_PARTIES',

6313: BEGIN
6314: UPDATE csi_webadi_staging cws SET ASSOCIATE_BILL_TO_PARTY_ID =
6315: (
6316: decode(cws.ASSOCIATE_BILL_TO_PARTY_TYPE,
6317: 'HZ_PARTIES',
6318: (SELECT party_id FROM hz_parties
6319: WHERE party_number = cws.ASSOCIATE_BILL_TO_PARTY_NUMBER),
6320: 'EMPLOYEE',
6321: (SELECT employee_id FROM per_employees_current_x

Line 6318: (SELECT party_id FROM hz_parties

6314: UPDATE csi_webadi_staging cws SET ASSOCIATE_BILL_TO_PARTY_ID =
6315: (
6316: decode(cws.ASSOCIATE_BILL_TO_PARTY_TYPE,
6317: 'HZ_PARTIES',
6318: (SELECT party_id FROM hz_parties
6319: WHERE party_number = cws.ASSOCIATE_BILL_TO_PARTY_NUMBER),
6320: 'EMPLOYEE',
6321: (SELECT employee_id FROM per_employees_current_x
6322: WHERE employee_num = cws.ASSOCIATE_BILL_TO_PARTY_NUMBER

Line 6347: 'HZ_PARTIES',

6343: BEGIN
6344: UPDATE csi_webadi_staging cws SET ASSOCIATE_SHIP_TO_PARTY_ID =
6345: (
6346: decode(cws.ASSOCIATE_SHIP_TO_PARTY_TYPE,
6347: 'HZ_PARTIES',
6348: (SELECT party_id FROM hz_parties
6349: WHERE party_number = cws.ASSOCIATE_SHIP_TO_PARTY_NUMBER),
6350: 'EMPLOYEE',
6351: (SELECT employee_id FROM per_employees_current_x

Line 6348: (SELECT party_id FROM hz_parties

6344: UPDATE csi_webadi_staging cws SET ASSOCIATE_SHIP_TO_PARTY_ID =
6345: (
6346: decode(cws.ASSOCIATE_SHIP_TO_PARTY_TYPE,
6347: 'HZ_PARTIES',
6348: (SELECT party_id FROM hz_parties
6349: WHERE party_number = cws.ASSOCIATE_SHIP_TO_PARTY_NUMBER),
6350: 'EMPLOYEE',
6351: (SELECT employee_id FROM per_employees_current_x
6352: WHERE employee_num = cws.ASSOCIATE_SHIP_TO_PARTY_NUMBER