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.HZ_CUST_ACCOUNT_V2PUB dependencies on HZ_CUST_ACCT_RELATE

Line 1023: * HZ_CUST_ACCT_RELATE_PKG.Insert_Row

1019: * Private procedure to create relationship between two customer accounts.
1020: *
1021: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1022: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_acct_relate
1023: * HZ_CUST_ACCT_RELATE_PKG.Insert_Row
1024: *
1025: * ARGUMENTS
1026: * IN/OUT:
1027: * p_cust_acct_relate_rec Customer account relate record.

Line 1062: l_customer_reciprocal_flag HZ_CUST_ACCT_RELATE.customer_reciprocal_flag%TYPE;

1058: l_msg_data VARCHAR2(2000);
1059: l_return_status VARCHAR2(1);
1060:
1061: l_cust_acct_relate_rec CUST_ACCT_RELATE_REC_TYPE;
1062: l_customer_reciprocal_flag HZ_CUST_ACCT_RELATE.customer_reciprocal_flag%TYPE;
1063: BEGIN
1064:
1065: -- Debug info.
1066: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1097: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Insert_Row (+)',

1093: END IF;
1094:
1095: -- Debug info.
1096: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1097: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Insert_Row (+)',
1098: p_prefix=>l_debug_prefix,
1099: p_msg_level=>fnd_log.level_procedure);
1100: END IF;
1101:

Line 1103: HZ_CUST_ACCT_RELATE_PKG.Insert_Row (

1099: p_msg_level=>fnd_log.level_procedure);
1100: END IF;
1101:
1102: -- Call table-handler.
1103: HZ_CUST_ACCT_RELATE_PKG.Insert_Row (
1104: X_CUST_ACCOUNT_ID => p_cust_acct_relate_rec.cust_account_id,
1105: X_RELATED_CUST_ACCOUNT_ID => p_cust_acct_relate_rec.related_cust_account_id,
1106: X_RELATIONSHIP_TYPE => p_cust_acct_relate_rec.relationship_type,
1107: X_COMMENTS => p_cust_acct_relate_rec.comments,

Line 1137: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Insert_Row (-)',

1133: );
1134:
1135: -- Debug info.
1136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1137: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Insert_Row (-)',
1138: p_prefix=>l_debug_prefix,
1139: p_msg_level=>fnd_log.level_procedure);
1140: END IF;
1141:

Line 1163: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489

1159: END IF;
1160:
1161: SELECT CUST_ACCT_RELATE_ID, CUSTOMER_RECIPROCAL_FLAG -- Bug 4529413
1162: INTO l_cust_acct_relate_id, l_customer_reciprocal_flag
1163: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489
1164: WHERE CUST_ACCOUNT_ID = p_cust_acct_relate_rec.related_cust_account_id
1165: AND RELATED_CUST_ACCOUNT_ID = p_cust_acct_relate_rec.cust_account_id
1166: --Bug 2985448.
1167: AND STATUS='A'

Line 1174: UPDATE HZ_CUST_ACCT_RELATE_ALL

1170: -- reciprocal relationship exist, update its reciprocal flag.
1171: -- customer_reciprocal_flag is NOT NULL column.
1172:
1173: IF l_customer_reciprocal_flag <> 'Y' THEN
1174: UPDATE HZ_CUST_ACCT_RELATE_ALL
1175: SET CUSTOMER_RECIPROCAL_FLAG = 'Y'
1176: WHERE CUST_ACCT_RELATE_ID = l_cust_acct_relate_id; -- Bug 4529413
1177: END IF;
1178:

Line 1221: * HZ_CUST_ACCT_RELATE_PKG.Update_Row

1217: * Private procedure to update relationship between two customer accounts.
1218: *
1219: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1220: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_acct_relate
1221: * HZ_CUST_ACCT_RELATE_PKG.Update_Row
1222: *
1223: * ARGUMENTS
1224: * IN/OUT:
1225: * p_cust_acct_relate_rec Customer account relate record.

Line 1262: l_cust_account_id HZ_CUST_ACCT_RELATE.cust_account_id%TYPE;

1258: l_rowid ROWID := NULL;
1259: l_object_version_number NUMBER;
1260:
1261: -- Bug 3449118
1262: l_cust_account_id HZ_CUST_ACCT_RELATE.cust_account_id%TYPE;
1263: l_related_cust_account_id HZ_CUST_ACCT_RELATE.related_cust_account_id%TYPE;
1264: l_status HZ_CUST_ACCT_RELATE.status%TYPE;
1265: l_cust_acct_relate_id HZ_CUST_ACCT_RELATE.cust_acct_relate_id%TYPE; -- Bug 4529413
1266: l_count NUMBER;

Line 1263: l_related_cust_account_id HZ_CUST_ACCT_RELATE.related_cust_account_id%TYPE;

1259: l_object_version_number NUMBER;
1260:
1261: -- Bug 3449118
1262: l_cust_account_id HZ_CUST_ACCT_RELATE.cust_account_id%TYPE;
1263: l_related_cust_account_id HZ_CUST_ACCT_RELATE.related_cust_account_id%TYPE;
1264: l_status HZ_CUST_ACCT_RELATE.status%TYPE;
1265: l_cust_acct_relate_id HZ_CUST_ACCT_RELATE.cust_acct_relate_id%TYPE; -- Bug 4529413
1266: l_count NUMBER;
1267:

Line 1264: l_status HZ_CUST_ACCT_RELATE.status%TYPE;

1260:
1261: -- Bug 3449118
1262: l_cust_account_id HZ_CUST_ACCT_RELATE.cust_account_id%TYPE;
1263: l_related_cust_account_id HZ_CUST_ACCT_RELATE.related_cust_account_id%TYPE;
1264: l_status HZ_CUST_ACCT_RELATE.status%TYPE;
1265: l_cust_acct_relate_id HZ_CUST_ACCT_RELATE.cust_acct_relate_id%TYPE; -- Bug 4529413
1266: l_count NUMBER;
1267:
1268: BEGIN

Line 1265: l_cust_acct_relate_id HZ_CUST_ACCT_RELATE.cust_acct_relate_id%TYPE; -- Bug 4529413

1261: -- Bug 3449118
1262: l_cust_account_id HZ_CUST_ACCT_RELATE.cust_account_id%TYPE;
1263: l_related_cust_account_id HZ_CUST_ACCT_RELATE.related_cust_account_id%TYPE;
1264: l_status HZ_CUST_ACCT_RELATE.status%TYPE;
1265: l_cust_acct_relate_id HZ_CUST_ACCT_RELATE.cust_acct_relate_id%TYPE; -- Bug 4529413
1266: l_count NUMBER;
1267:
1268: BEGIN
1269:

Line 1288: FROM HZ_CUST_ACCT_RELATE

1284: ORG_ID
1285: INTO l_cust_acct_relate_id,
1286: l_object_version_number,
1287: p_cust_acct_relate_rec.org_id -- Bug 3456489
1288: FROM HZ_CUST_ACCT_RELATE
1289: WHERE CUST_ACCOUNT_ID = p_cust_acct_relate_rec.cust_account_id AND
1290: RELATED_CUST_ACCOUNT_ID = p_cust_acct_relate_rec.related_cust_account_id AND
1291: --Bug 2985448.
1292: STATUS='A' AND

Line 1312: FROM HZ_CUST_ACCT_RELATE

1308:
1309: BEGIN
1310: SELECT CUST_ACCT_RELATE_ID
1311: INTO l_cust_acct_relate_id
1312: FROM HZ_CUST_ACCT_RELATE
1313: WHERE ROWID = p_rowid;
1314:
1315: EXCEPTION
1316: WHEN NO_DATA_FOUND THEN

Line 1340: FROM HZ_CUST_ACCT_RELATE_ALL

1336: l_cust_account_id,
1337: l_related_cust_account_id,
1338: l_status,
1339: p_cust_acct_relate_rec.org_id -- Bug 3456489
1340: FROM HZ_CUST_ACCT_RELATE_ALL
1341: WHERE CUST_ACCT_RELATE_ID = l_cust_acct_relate_id
1342: FOR UPDATE NOWAIT;
1343:
1344: -- cust_account_id is not updateable.

Line 1373: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489

1369: l_status = 'I'
1370: THEN
1371: SELECT COUNT(*)
1372: INTO l_count
1373: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489
1374: WHERE CUST_ACCOUNT_ID = l_cust_account_id AND
1375: RELATED_CUST_ACCOUNT_ID = l_related_cust_account_id AND
1376: STATUS = 'A' AND
1377: ORG_ID = p_cust_acct_relate_rec.org_id; -- Bug 3456489

Line 1407: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_acct_relate' );

1403: l_object_version_number IS NOT NULL AND
1404: p_object_version_number = l_object_version_number ) )
1405: THEN
1406: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1407: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_acct_relate' );
1408: FND_MSG_PUB.ADD;
1409: RAISE FND_API.G_EXC_ERROR;
1410: END IF;
1411:

Line 1429: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Update_Row (+)',

1425: END IF;
1426:
1427: -- Debug info.
1428: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1429: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Update_Row (+)',
1430: p_prefix=>l_debug_prefix,
1431: p_msg_level=>fnd_log.level_procedure);
1432: END IF;
1433:

Line 1435: HZ_CUST_ACCT_RELATE_PKG.Update_Row (

1431: p_msg_level=>fnd_log.level_procedure);
1432: END IF;
1433:
1434: -- Call table-handler.
1435: HZ_CUST_ACCT_RELATE_PKG.Update_Row (
1436: X_CUST_ACCT_RELATE_ID => l_cust_acct_relate_id,
1437: X_CUST_ACCOUNT_ID => p_cust_acct_relate_rec.cust_account_id,
1438: X_RELATED_CUST_ACCOUNT_ID => p_cust_acct_relate_rec.related_cust_account_id,
1439: X_RELATIONSHIP_TYPE => p_cust_acct_relate_rec.relationship_type,

Line 1468: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Update_Row (-)',

1464: );
1465:
1466: -- Debug info.
1467: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1468: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Update_Row (-)',
1469: p_prefix=>l_debug_prefix,
1470: p_msg_level=>fnd_log.level_procedure);
1471: END IF;
1472:

Line 2702: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(

2698: END IF;
2699:
2700: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2701: -- populate function for integration service
2702: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(
2703: p_operation => 'I',
2704: p_cust_acct_relate_id => l_cust_acct_relate_rec.cust_acct_relate_id);
2705: END IF;
2706: END IF;

Line 2923: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(

2919: END IF;
2920:
2921: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2922: -- populate function for integration service
2923: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(
2924: p_operation => 'U',
2925: p_cust_acct_relate_id => l_old_cust_acct_relate_rec.cust_acct_relate_id); --bug 8654754. cust_acct_relate_id has no value in relate rec. Old rec got the value from the get API.
2926:
2927: END IF;

Line 3150: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(

3146: END IF;
3147:
3148: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3149: -- populate function for integration service
3150: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(
3151: p_operation => 'U',
3152: p_cust_acct_relate_id => l_old_cust_acct_relate_rec.cust_acct_relate_id); --bug 8654754. cust_acct_relate_id has no value in relate rec. Old rec got the value from the get API.
3153:
3154: END IF;

Line 3272: * HZ_CUST_ACCT_RELATE_PKG.Select_Row

3268: * DESCRIPTION
3269: * Gets customer account relationship record
3270: *
3271: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
3272: * HZ_CUST_ACCT_RELATE_PKG.Select_Row
3273: *
3274: * ARGUMENTS
3275: * IN:
3276: * p_init_msg_list Initialize message stack if it is set to

Line 3296: * Called the overloaded procedure hz_cust_acct_relate_pkg.

3292: * MODIFICATION HISTORY
3293: *
3294: * 07-23-2001 Jianying Huang o Created.
3295: * 04-21-2004 Rajib Ranjan Borah o Bug 3449118. Added the parameter p_rowid.
3296: * Called the overloaded procedure hz_cust_acct_relate_pkg.
3297: * select_row with rowid as parameter in case rowid
3298: * is passed to this procedure.
3299: * 12-MAY-2005 Rajib Ranjan Borah o TCA SSA Uptake (Bug 3456489)
3300: * 12-AUG-2005 Idris Ali o Bug 4529413:Added parameter cust_acct_relate_id to get_cust_acct_relate

Line 3361: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Select_Row (+)',

3357: x_cust_acct_relate_rec.cust_acct_relate_id := p_cust_acct_relate_id;
3358:
3359: -- Debug info.
3360: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3361: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Select_Row (+)',
3362: p_prefix=>l_debug_prefix,
3363: p_msg_level=>fnd_log.level_procedure);
3364: END IF;
3365:

Line 3369: HZ_CUST_ACCT_RELATE_PKG.Select_Row (

3365:
3366: -- Call table-handler.
3367: IF p_rowid IS NULL /* Bug 3449118 */
3368: THEN
3369: HZ_CUST_ACCT_RELATE_PKG.Select_Row (
3370: X_CUST_ACCOUNT_ID => x_cust_acct_relate_rec.cust_account_id,
3371: X_RELATED_CUST_ACCOUNT_ID => x_cust_acct_relate_rec.related_cust_account_id,
3372: X_RELATIONSHIP_TYPE => x_cust_acct_relate_rec.relationship_type,
3373: X_COMMENTS => x_cust_acct_relate_rec.comments,

Line 3402: HZ_CUST_ACCT_RELATE_PKG.Select_Row (

3398: );
3399:
3400: ELSE
3401:
3402: HZ_CUST_ACCT_RELATE_PKG.Select_Row (
3403: X_CUST_ACCOUNT_ID => x_cust_acct_relate_rec.cust_account_id,
3404: X_RELATED_CUST_ACCOUNT_ID => x_cust_acct_relate_rec.related_cust_account_id,
3405: X_RELATIONSHIP_TYPE => x_cust_acct_relate_rec.relationship_type,
3406: X_COMMENTS => x_cust_acct_relate_rec.comments,

Line 3438: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Select_Row (-)',

3434:
3435:
3436: -- Debug info.
3437: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3438: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Select_Row (-)',
3439: p_prefix=>l_debug_prefix,
3440: p_msg_level=>fnd_log.level_procedure);
3441: END IF;
3442: