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.

[Home] [Help]

APPS.HZ_CUST_ACCOUNT_V2PUB dependencies on HZ_CUST_ACCT_RELATE

Line 1006: * HZ_CUST_ACCT_RELATE_PKG.Insert_Row

1002: * Private procedure to create relationship between two customer accounts.
1003: *
1004: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1005: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_acct_relate
1006: * HZ_CUST_ACCT_RELATE_PKG.Insert_Row
1007: *
1008: * ARGUMENTS
1009: * IN/OUT:
1010: * p_cust_acct_relate_rec Customer account relate record.

Line 1045: l_customer_reciprocal_flag HZ_CUST_ACCT_RELATE.customer_reciprocal_flag%TYPE;

1041: l_msg_data VARCHAR2(2000);
1042: l_return_status VARCHAR2(1);
1043:
1044: l_cust_acct_relate_rec CUST_ACCT_RELATE_REC_TYPE;
1045: l_customer_reciprocal_flag HZ_CUST_ACCT_RELATE.customer_reciprocal_flag%TYPE;
1046: BEGIN
1047:
1048: -- Debug info.
1049: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1076: END IF;
1077:
1078: -- Debug info.
1079: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1080: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Insert_Row (+)',
1081: p_prefix=>l_debug_prefix,
1082: p_msg_level=>fnd_log.level_procedure);
1083: END IF;
1084:

Line 1086: HZ_CUST_ACCT_RELATE_PKG.Insert_Row (

1082: p_msg_level=>fnd_log.level_procedure);
1083: END IF;
1084:
1085: -- Call table-handler.
1086: HZ_CUST_ACCT_RELATE_PKG.Insert_Row (
1087: X_CUST_ACCOUNT_ID => p_cust_acct_relate_rec.cust_account_id,
1088: X_RELATED_CUST_ACCOUNT_ID => p_cust_acct_relate_rec.related_cust_account_id,
1089: X_RELATIONSHIP_TYPE => p_cust_acct_relate_rec.relationship_type,
1090: X_COMMENTS => p_cust_acct_relate_rec.comments,

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

1116: );
1117:
1118: -- Debug info.
1119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1120: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Insert_Row (-)',
1121: p_prefix=>l_debug_prefix,
1122: p_msg_level=>fnd_log.level_procedure);
1123: END IF;
1124:

Line 1146: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489

1142: END IF;
1143:
1144: SELECT CUST_ACCT_RELATE_ID, CUSTOMER_RECIPROCAL_FLAG -- Bug 4529413
1145: INTO l_cust_acct_relate_id, l_customer_reciprocal_flag
1146: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489
1147: WHERE CUST_ACCOUNT_ID = p_cust_acct_relate_rec.related_cust_account_id
1148: AND RELATED_CUST_ACCOUNT_ID = p_cust_acct_relate_rec.cust_account_id
1149: --Bug 2985448.
1150: AND STATUS='A'

Line 1157: UPDATE HZ_CUST_ACCT_RELATE_ALL

1153: -- reciprocal relationship exist, update its reciprocal flag.
1154: -- customer_reciprocal_flag is NOT NULL column.
1155:
1156: IF l_customer_reciprocal_flag <> 'Y' THEN
1157: UPDATE HZ_CUST_ACCT_RELATE_ALL
1158: SET CUSTOMER_RECIPROCAL_FLAG = 'Y'
1159: WHERE CUST_ACCT_RELATE_ID = l_cust_acct_relate_id; -- Bug 4529413
1160: END IF;
1161:

Line 1204: * HZ_CUST_ACCT_RELATE_PKG.Update_Row

1200: * Private procedure to update relationship between two customer accounts.
1201: *
1202: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1203: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_acct_relate
1204: * HZ_CUST_ACCT_RELATE_PKG.Update_Row
1205: *
1206: * ARGUMENTS
1207: * IN/OUT:
1208: * p_cust_acct_relate_rec Customer account relate record.

Line 1245: l_cust_account_id HZ_CUST_ACCT_RELATE.cust_account_id%TYPE;

1241: l_rowid ROWID := NULL;
1242: l_object_version_number NUMBER;
1243:
1244: -- Bug 3449118
1245: l_cust_account_id HZ_CUST_ACCT_RELATE.cust_account_id%TYPE;
1246: l_related_cust_account_id HZ_CUST_ACCT_RELATE.related_cust_account_id%TYPE;
1247: l_status HZ_CUST_ACCT_RELATE.status%TYPE;
1248: l_cust_acct_relate_id HZ_CUST_ACCT_RELATE.cust_acct_relate_id%TYPE; -- Bug 4529413
1249: l_count NUMBER;

Line 1246: l_related_cust_account_id HZ_CUST_ACCT_RELATE.related_cust_account_id%TYPE;

1242: l_object_version_number NUMBER;
1243:
1244: -- Bug 3449118
1245: l_cust_account_id HZ_CUST_ACCT_RELATE.cust_account_id%TYPE;
1246: l_related_cust_account_id HZ_CUST_ACCT_RELATE.related_cust_account_id%TYPE;
1247: l_status HZ_CUST_ACCT_RELATE.status%TYPE;
1248: l_cust_acct_relate_id HZ_CUST_ACCT_RELATE.cust_acct_relate_id%TYPE; -- Bug 4529413
1249: l_count NUMBER;
1250:

Line 1247: l_status HZ_CUST_ACCT_RELATE.status%TYPE;

1243:
1244: -- Bug 3449118
1245: l_cust_account_id HZ_CUST_ACCT_RELATE.cust_account_id%TYPE;
1246: l_related_cust_account_id HZ_CUST_ACCT_RELATE.related_cust_account_id%TYPE;
1247: l_status HZ_CUST_ACCT_RELATE.status%TYPE;
1248: l_cust_acct_relate_id HZ_CUST_ACCT_RELATE.cust_acct_relate_id%TYPE; -- Bug 4529413
1249: l_count NUMBER;
1250:
1251: BEGIN

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

1244: -- Bug 3449118
1245: l_cust_account_id HZ_CUST_ACCT_RELATE.cust_account_id%TYPE;
1246: l_related_cust_account_id HZ_CUST_ACCT_RELATE.related_cust_account_id%TYPE;
1247: l_status HZ_CUST_ACCT_RELATE.status%TYPE;
1248: l_cust_acct_relate_id HZ_CUST_ACCT_RELATE.cust_acct_relate_id%TYPE; -- Bug 4529413
1249: l_count NUMBER;
1250:
1251: BEGIN
1252:

Line 1271: FROM HZ_CUST_ACCT_RELATE

1267: ORG_ID
1268: INTO l_cust_acct_relate_id,
1269: l_object_version_number,
1270: p_cust_acct_relate_rec.org_id -- Bug 3456489
1271: FROM HZ_CUST_ACCT_RELATE
1272: WHERE CUST_ACCOUNT_ID = p_cust_acct_relate_rec.cust_account_id AND
1273: RELATED_CUST_ACCOUNT_ID = p_cust_acct_relate_rec.related_cust_account_id AND
1274: --Bug 2985448.
1275: STATUS='A' AND

Line 1295: FROM HZ_CUST_ACCT_RELATE

1291:
1292: BEGIN
1293: SELECT CUST_ACCT_RELATE_ID
1294: INTO l_cust_acct_relate_id
1295: FROM HZ_CUST_ACCT_RELATE
1296: WHERE ROWID = p_rowid;
1297:
1298: EXCEPTION
1299: WHEN NO_DATA_FOUND THEN

Line 1323: FROM HZ_CUST_ACCT_RELATE_ALL

1319: l_cust_account_id,
1320: l_related_cust_account_id,
1321: l_status,
1322: p_cust_acct_relate_rec.org_id -- Bug 3456489
1323: FROM HZ_CUST_ACCT_RELATE_ALL
1324: WHERE CUST_ACCT_RELATE_ID = l_cust_acct_relate_id
1325: FOR UPDATE NOWAIT;
1326:
1327: -- cust_account_id is not updateable.

Line 1356: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489

1352: l_status = 'I'
1353: THEN
1354: SELECT COUNT(*)
1355: INTO l_count
1356: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489
1357: WHERE CUST_ACCOUNT_ID = l_cust_account_id AND
1358: RELATED_CUST_ACCOUNT_ID = l_related_cust_account_id AND
1359: STATUS = 'A' AND
1360: ORG_ID = p_cust_acct_relate_rec.org_id; -- Bug 3456489

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

1386: l_object_version_number IS NOT NULL AND
1387: p_object_version_number = l_object_version_number ) )
1388: THEN
1389: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1390: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_acct_relate' );
1391: FND_MSG_PUB.ADD;
1392: RAISE FND_API.G_EXC_ERROR;
1393: END IF;
1394:

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

1408: END IF;
1409:
1410: -- Debug info.
1411: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1412: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Update_Row (+)',
1413: p_prefix=>l_debug_prefix,
1414: p_msg_level=>fnd_log.level_procedure);
1415: END IF;
1416:

Line 1418: HZ_CUST_ACCT_RELATE_PKG.Update_Row (

1414: p_msg_level=>fnd_log.level_procedure);
1415: END IF;
1416:
1417: -- Call table-handler.
1418: HZ_CUST_ACCT_RELATE_PKG.Update_Row (
1419: X_CUST_ACCT_RELATE_ID => l_cust_acct_relate_id,
1420: X_CUST_ACCOUNT_ID => p_cust_acct_relate_rec.cust_account_id,
1421: X_RELATED_CUST_ACCOUNT_ID => p_cust_acct_relate_rec.related_cust_account_id,
1422: X_RELATIONSHIP_TYPE => p_cust_acct_relate_rec.relationship_type,

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

1447: );
1448:
1449: -- Debug info.
1450: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1451: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Update_Row (-)',
1452: p_prefix=>l_debug_prefix,
1453: p_msg_level=>fnd_log.level_procedure);
1454: END IF;
1455:

Line 2669: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(

2665: END IF;
2666:
2667: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2668: -- populate function for integration service
2669: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(
2670: p_operation => 'I',
2671: p_cust_acct_relate_id => l_cust_acct_relate_rec.cust_acct_relate_id);
2672: END IF;
2673: END IF;

Line 2890: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(

2886: END IF;
2887:
2888: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2889: -- populate function for integration service
2890: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(
2891: p_operation => 'U',
2892: p_cust_acct_relate_id => l_cust_acct_relate_rec.cust_acct_relate_id);
2893: END IF;
2894: END IF;

Line 3116: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(

3112: END IF;
3113:
3114: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3115: -- populate function for integration service
3116: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(
3117: p_operation => 'U',
3118: p_cust_acct_relate_id => l_cust_acct_relate_rec.cust_acct_relate_id);
3119: END IF;
3120: END IF;

Line 3237: * HZ_CUST_ACCT_RELATE_PKG.Select_Row

3233: * DESCRIPTION
3234: * Gets customer account relationship record
3235: *
3236: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
3237: * HZ_CUST_ACCT_RELATE_PKG.Select_Row
3238: *
3239: * ARGUMENTS
3240: * IN:
3241: * p_init_msg_list Initialize message stack if it is set to

Line 3261: * Called the overloaded procedure hz_cust_acct_relate_pkg.

3257: * MODIFICATION HISTORY
3258: *
3259: * 07-23-2001 Jianying Huang o Created.
3260: * 04-21-2004 Rajib Ranjan Borah o Bug 3449118. Added the parameter p_rowid.
3261: * Called the overloaded procedure hz_cust_acct_relate_pkg.
3262: * select_row with rowid as parameter in case rowid
3263: * is passed to this procedure.
3264: * 12-MAY-2005 Rajib Ranjan Borah o TCA SSA Uptake (Bug 3456489)
3265: * 12-AUG-2005 Idris Ali o Bug 4529413:Added parameter cust_acct_relate_id to get_cust_acct_relate

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

3322: x_cust_acct_relate_rec.cust_acct_relate_id := p_cust_acct_relate_id;
3323:
3324: -- Debug info.
3325: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3326: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Select_Row (+)',
3327: p_prefix=>l_debug_prefix,
3328: p_msg_level=>fnd_log.level_procedure);
3329: END IF;
3330:

Line 3334: HZ_CUST_ACCT_RELATE_PKG.Select_Row (

3330:
3331: -- Call table-handler.
3332: IF p_rowid IS NULL /* Bug 3449118 */
3333: THEN
3334: HZ_CUST_ACCT_RELATE_PKG.Select_Row (
3335: X_CUST_ACCOUNT_ID => x_cust_acct_relate_rec.cust_account_id,
3336: X_RELATED_CUST_ACCOUNT_ID => x_cust_acct_relate_rec.related_cust_account_id,
3337: X_RELATIONSHIP_TYPE => x_cust_acct_relate_rec.relationship_type,
3338: X_COMMENTS => x_cust_acct_relate_rec.comments,

Line 3367: HZ_CUST_ACCT_RELATE_PKG.Select_Row (

3363: );
3364:
3365: ELSE
3366:
3367: HZ_CUST_ACCT_RELATE_PKG.Select_Row (
3368: X_CUST_ACCOUNT_ID => x_cust_acct_relate_rec.cust_account_id,
3369: X_RELATED_CUST_ACCOUNT_ID => x_cust_acct_relate_rec.related_cust_account_id,
3370: X_RELATIONSHIP_TYPE => x_cust_acct_relate_rec.relationship_type,
3371: X_COMMENTS => x_cust_acct_relate_rec.comments,

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

3399:
3400:
3401: -- Debug info.
3402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3403: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Select_Row (-)',
3404: p_prefix=>l_debug_prefix,
3405: p_msg_level=>fnd_log.level_procedure);
3406: END IF;
3407: