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_MERGE_V2PVT dependencies on FND_API

Line 76: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

72: application_id NUMBER
73: );
74:
75: PROCEDURE get_party_rec (
76: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
77: p_party_id IN NUMBER,
78: x_party_rec OUT NOCOPY hz_party_v2pub.party_rec_type,
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_msg_count OUT NOCOPY NUMBER,

Line 109: IF fnd_api.to_boolean(p_init_msg_list) THEN

105:
106: BEGIN
107:
108: --Initialize message list if p_init_msg_list is set to TRUE.
109: IF fnd_api.to_boolean(p_init_msg_list) THEN
110: fnd_msg_pub.initialize;
111: END IF;
112:
113: --Initialize API return status to success.

Line 114: x_return_status := fnd_api.g_ret_sts_success;

110: fnd_msg_pub.initialize;
111: END IF;
112:
113: --Initialize API return status to success.
114: x_return_status := fnd_api.g_ret_sts_success;
115:
116: --Check whether primary key has been passed in.
117: IF p_party_id IS NULL OR
118: p_party_id = fnd_api.g_miss_num THEN

Line 118: p_party_id = fnd_api.g_miss_num THEN

114: x_return_status := fnd_api.g_ret_sts_success;
115:
116: --Check whether primary key has been passed in.
117: IF p_party_id IS NULL OR
118: p_party_id = fnd_api.g_miss_num THEN
119: fnd_message.set_name( 'AR', 'HZ_API_MISSING_COLUMN' );
120: fnd_message.set_token( 'COLUMN', 'party_id' );
121: fnd_msg_pub.add;
122: RAISE fnd_api.g_exc_error;

Line 122: RAISE fnd_api.g_exc_error;

118: p_party_id = fnd_api.g_miss_num THEN
119: fnd_message.set_name( 'AR', 'HZ_API_MISSING_COLUMN' );
120: fnd_message.set_token( 'COLUMN', 'party_id' );
121: fnd_msg_pub.add;
122: RAISE fnd_api.g_exc_error;
123: END IF;
124:
125: x_party_rec.party_id := p_party_id;
126:

Line 215: p_encoded => FND_API.G_FALSE,

211: );
212:
213: --Standard call to get message count and if count is 1, get message info.
214: FND_MSG_PUB.Count_And_Get(
215: p_encoded => FND_API.G_FALSE,
216: p_count => x_msg_count,
217: p_data => x_msg_data );
218:
219: EXCEPTION

Line 220: WHEN FND_API.G_EXC_ERROR THEN

216: p_count => x_msg_count,
217: p_data => x_msg_data );
218:
219: EXCEPTION
220: WHEN FND_API.G_EXC_ERROR THEN
221: x_return_status := FND_API.G_RET_STS_ERROR;
222:
223: FND_MSG_PUB.Count_And_Get(
224: p_encoded => FND_API.G_FALSE,

Line 221: x_return_status := FND_API.G_RET_STS_ERROR;

217: p_data => x_msg_data );
218:
219: EXCEPTION
220: WHEN FND_API.G_EXC_ERROR THEN
221: x_return_status := FND_API.G_RET_STS_ERROR;
222:
223: FND_MSG_PUB.Count_And_Get(
224: p_encoded => FND_API.G_FALSE,
225: p_count => x_msg_count,

Line 224: p_encoded => FND_API.G_FALSE,

220: WHEN FND_API.G_EXC_ERROR THEN
221: x_return_status := FND_API.G_RET_STS_ERROR;
222:
223: FND_MSG_PUB.Count_And_Get(
224: p_encoded => FND_API.G_FALSE,
225: p_count => x_msg_count,
226: p_data => x_msg_data );
227:
228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

224: p_encoded => FND_API.G_FALSE,
225: p_count => x_msg_count,
226: p_data => x_msg_data );
227:
228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230:
231: FND_MSG_PUB.Count_And_Get(
232: p_encoded => FND_API.G_FALSE,

Line 229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

225: p_count => x_msg_count,
226: p_data => x_msg_data );
227:
228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230:
231: FND_MSG_PUB.Count_And_Get(
232: p_encoded => FND_API.G_FALSE,
233: p_count => x_msg_count,

Line 232: p_encoded => FND_API.G_FALSE,

228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230:
231: FND_MSG_PUB.Count_And_Get(
232: p_encoded => FND_API.G_FALSE,
233: p_count => x_msg_count,
234: p_data => x_msg_data );
235:
236: WHEN OTHERS THEN

Line 237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

233: p_count => x_msg_count,
234: p_data => x_msg_data );
235:
236: WHEN OTHERS THEN
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238:
239: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
240: fnd_message.set_token( 'ERROR' ,SQLERRM );
241: fnd_msg_pub.add;

Line 244: p_encoded => FND_API.G_FALSE,

240: fnd_message.set_token( 'ERROR' ,SQLERRM );
241: fnd_msg_pub.add;
242:
243: FND_MSG_PUB.Count_And_Get(
244: p_encoded => FND_API.G_FALSE,
245: p_count => x_msg_count,
246: p_data => x_msg_data );
247:
248: END get_party_rec;

Line 457: p_relationship_rec.end_date = FND_API.G_MISS_DATE

453:
454: -- default end date to 31-DEC-4712
455: IF p_relationship_rec.end_date IS NULL
456: OR
457: p_relationship_rec.end_date = FND_API.G_MISS_DATE
458: THEN
459: l_end_date := to_date('12/31/4712','MM/DD/YYYY');
460: ELSE
461: l_end_date := p_relationship_rec.end_date;

Line 849: p_init_msg_list => FND_API.G_FALSE,

845: l_hierarchy_rec.status := NVL(p_relationship_rec.status, 'A');
846: END IF;
847:
848: HZ_HIERARCHY_PUB.create_link(
849: p_init_msg_list => FND_API.G_FALSE,
850: p_hierarchy_node_rec => l_hierarchy_rec,
851: x_return_status => x_return_status,
852: x_msg_count => l_msg_count,
853: x_msg_data => l_msg_data

Line 1002: FND_API.G_FALSE,

998:
999: /*
1000: per HLD,mosr record should not be created for copy case, since old osr is still active
1001: hz_orig_system_ref_pvt.create_mosr_for_merge(
1002: FND_API.G_FALSE,
1003: 'HZ_PARTIES',
1004: l_party_rec.party_id,
1005: x_return_status,
1006: l_msg_count,

Line 1009: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1005: x_return_status,
1006: l_msg_count,
1007: l_msg_data);
1008:
1009: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1010: RAISE FND_API.G_EXC_ERROR;
1011: END IF;
1012: */
1013: x_party_id := l_party_rec.party_id;

Line 1010: RAISE FND_API.G_EXC_ERROR;

1006: l_msg_count,
1007: l_msg_data);
1008:
1009: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1010: RAISE FND_API.G_EXC_ERROR;
1011: END IF;
1012: */
1013: x_party_id := l_party_rec.party_id;
1014: x_party_number := l_party_rec.party_number;

Line 1051: OR l_end_date = FND_API.G_MISS_DATE

1047: l_record_locked := 'Y';
1048: END;
1049:
1050: IF l_end_date IS NULL
1051: OR l_end_date = FND_API.G_MISS_DATE
1052: THEN
1053: l_end_date := to_date('31-12-4712', 'DD-MM-YYYY');
1054: ELSIF l_end_date = sysdate THEN
1055: l_end_date := sysdate-1;

Line 1059: OR l_status = FND_API.G_MISS_CHAR

1055: l_end_date := sysdate-1;
1056: END IF;
1057:
1058: IF l_status IS NULL
1059: OR l_status = FND_API.G_MISS_CHAR
1060: THEN
1061: l_status := 'A';
1062: END IF;
1063:

Line 1107: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

1103:
1104:
1105:
1106: PROCEDURE create_relationship (
1107: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
1108: p_relationship_rec IN HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE,
1109: p_direction_code IN VARCHAR2,
1110: x_relationship_id OUT NOCOPY NUMBER,
1111: x_party_id OUT NOCOPY NUMBER,

Line 1127: IF FND_API.to_Boolean(p_init_msg_list) THEN

1123: -- Standard start of API savepoint
1124: SAVEPOINT create_relationship;
1125:
1126: -- Initialize message list if p_init_msg_list is set to TRUE.
1127: IF FND_API.to_Boolean(p_init_msg_list) THEN
1128: FND_MSG_PUB.initialize;
1129: END IF;
1130:
1131: -- Initialize API return status to success.

Line 1132: x_return_status := FND_API.G_RET_STS_SUCCESS;

1128: FND_MSG_PUB.initialize;
1129: END IF;
1130:
1131: -- Initialize API return status to success.
1132: x_return_status := FND_API.G_RET_STS_SUCCESS;
1133:
1134: /* SSM SST Integration and Extension
1135: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
1136:

Line 1166: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1162: x_party_id,
1163: x_party_number,
1164: x_return_status);
1165:
1166: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1167: -- Invoke business event system.
1168: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN --10168091
1169: HZ_BUSINESS_EVENT_V2PVT.create_relationship_event (
1170: l_rel_rec,

Line 1177: p_encoded => FND_API.G_FALSE,

1173: END IF;
1174:
1175: -- Standard call to get message count and if count is 1, get message info.
1176: FND_MSG_PUB.Count_And_Get(
1177: p_encoded => FND_API.G_FALSE,
1178: p_count => x_msg_count,
1179: p_data => x_msg_data);
1180:
1181: EXCEPTION

Line 1182: WHEN FND_API.G_EXC_ERROR THEN

1178: p_count => x_msg_count,
1179: p_data => x_msg_data);
1180:
1181: EXCEPTION
1182: WHEN FND_API.G_EXC_ERROR THEN
1183: ROLLBACK TO create_relationship;
1184: x_return_status := FND_API.G_RET_STS_ERROR;
1185: FND_MSG_PUB.Count_And_Get(
1186: p_encoded => FND_API.G_FALSE,

Line 1184: x_return_status := FND_API.G_RET_STS_ERROR;

1180:
1181: EXCEPTION
1182: WHEN FND_API.G_EXC_ERROR THEN
1183: ROLLBACK TO create_relationship;
1184: x_return_status := FND_API.G_RET_STS_ERROR;
1185: FND_MSG_PUB.Count_And_Get(
1186: p_encoded => FND_API.G_FALSE,
1187: p_count => x_msg_count,
1188: p_data => x_msg_data);

Line 1186: p_encoded => FND_API.G_FALSE,

1182: WHEN FND_API.G_EXC_ERROR THEN
1183: ROLLBACK TO create_relationship;
1184: x_return_status := FND_API.G_RET_STS_ERROR;
1185: FND_MSG_PUB.Count_And_Get(
1186: p_encoded => FND_API.G_FALSE,
1187: p_count => x_msg_count,
1188: p_data => x_msg_data);
1189:
1190:

Line 1191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1187: p_count => x_msg_count,
1188: p_data => x_msg_data);
1189:
1190:
1191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1192: ROLLBACK TO create_relationship;
1193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1194: FND_MSG_PUB.Count_And_Get(
1195: p_encoded => FND_API.G_FALSE,

Line 1193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1189:
1190:
1191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1192: ROLLBACK TO create_relationship;
1193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1194: FND_MSG_PUB.Count_And_Get(
1195: p_encoded => FND_API.G_FALSE,
1196: p_count => x_msg_count,
1197: p_data => x_msg_data);

Line 1195: p_encoded => FND_API.G_FALSE,

1191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1192: ROLLBACK TO create_relationship;
1193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1194: FND_MSG_PUB.Count_And_Get(
1195: p_encoded => FND_API.G_FALSE,
1196: p_count => x_msg_count,
1197: p_data => x_msg_data);
1198:
1199: WHEN OTHERS THEN

Line 1201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1197: p_data => x_msg_data);
1198:
1199: WHEN OTHERS THEN
1200: ROLLBACK TO create_relationship;
1201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1202: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1203: fnd_message.set_token('ERROR' ,SQLERRM);
1204: fnd_msg_pub.add;
1205: FND_MSG_PUB.Count_And_Get(

Line 1206: p_encoded => FND_API.G_FALSE,

1202: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1203: fnd_message.set_token('ERROR' ,SQLERRM);
1204: fnd_msg_pub.add;
1205: FND_MSG_PUB.Count_And_Get(
1206: p_encoded => FND_API.G_FALSE,
1207: p_count => x_msg_count,
1208: p_data => x_msg_data);
1209:
1210: END create_relationship;

Line 1213: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1209:
1210: END create_relationship;
1211:
1212: PROCEDURE get_relationship_rec (
1213: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1214: p_relationship_id IN NUMBER,
1215: p_directional_flag IN VARCHAR2 := 'F',
1216: x_rel_rec OUT NOCOPY HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE,
1217: x_direction_code OUT NOCOPY VARCHAR2,

Line 1230: IF FND_API.to_Boolean(p_init_msg_list) THEN

1226:
1227: BEGIN
1228:
1229: --Initialize message list if p_init_msg_list is set to TRUE.
1230: IF FND_API.to_Boolean(p_init_msg_list) THEN
1231: FND_MSG_PUB.initialize;
1232: END IF;
1233:
1234: --Initialize API return status to success.

Line 1235: x_return_status := FND_API.G_RET_STS_SUCCESS;

1231: FND_MSG_PUB.initialize;
1232: END IF;
1233:
1234: --Initialize API return status to success.
1235: x_return_status := FND_API.G_RET_STS_SUCCESS;
1236:
1237: --Check whether primary key has been passed in.
1238: IF p_relationship_id IS NULL OR
1239: p_relationship_id = FND_API.G_MISS_NUM THEN

Line 1239: p_relationship_id = FND_API.G_MISS_NUM THEN

1235: x_return_status := FND_API.G_RET_STS_SUCCESS;
1236:
1237: --Check whether primary key has been passed in.
1238: IF p_relationship_id IS NULL OR
1239: p_relationship_id = FND_API.G_MISS_NUM THEN
1240: fnd_message.set_name( 'AR', 'HZ_API_MISSING_COLUMN' );
1241: fnd_message.set_token( 'COLUMN', 'relationship_id' );
1242: fnd_msg_pub.add;
1243: RAISE FND_API.G_EXC_ERROR;

Line 1243: RAISE FND_API.G_EXC_ERROR;

1239: p_relationship_id = FND_API.G_MISS_NUM THEN
1240: fnd_message.set_name( 'AR', 'HZ_API_MISSING_COLUMN' );
1241: fnd_message.set_token( 'COLUMN', 'relationship_id' );
1242: fnd_msg_pub.add;
1243: RAISE FND_API.G_EXC_ERROR;
1244: END IF;
1245:
1246: x_rel_rec.relationship_id := p_relationship_id;
1247: IF p_directional_flag <> 'F'

Line 1334: l_party_id <> FND_API.G_MISS_NUM

1330: );
1331:
1332: IF l_party_id IS NOT NULL
1333: AND
1334: l_party_id <> FND_API.G_MISS_NUM
1335: THEN
1336: get_party_rec (
1337: p_party_id => l_party_id,
1338: x_party_rec => x_rel_rec.party_rec,

Line 1344: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1340: x_msg_count => x_msg_count,
1341: x_msg_data => x_msg_data
1342: );
1343:
1344: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1345: RAISE FND_API.G_EXC_ERROR;
1346: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1348: END IF;

Line 1345: RAISE FND_API.G_EXC_ERROR;

1341: x_msg_data => x_msg_data
1342: );
1343:
1344: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1345: RAISE FND_API.G_EXC_ERROR;
1346: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1348: END IF;
1349: END IF;

Line 1346: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1342: );
1343:
1344: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1345: RAISE FND_API.G_EXC_ERROR;
1346: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1348: END IF;
1349: END IF;
1350:

Line 1347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1343:
1344: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1345: RAISE FND_API.G_EXC_ERROR;
1346: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1348: END IF;
1349: END IF;
1350:
1351: --Standard call to get message count and if count is 1, get message info.

Line 1353: p_encoded => FND_API.G_FALSE,

1349: END IF;
1350:
1351: --Standard call to get message count and if count is 1, get message info.
1352: FND_MSG_PUB.Count_And_Get(
1353: p_encoded => FND_API.G_FALSE,
1354: p_count => x_msg_count,
1355: p_data => x_msg_data );
1356:
1357: EXCEPTION

Line 1358: WHEN FND_API.G_EXC_ERROR THEN

1354: p_count => x_msg_count,
1355: p_data => x_msg_data );
1356:
1357: EXCEPTION
1358: WHEN FND_API.G_EXC_ERROR THEN
1359: x_return_status := FND_API.G_RET_STS_ERROR;
1360:
1361: FND_MSG_PUB.Count_And_Get(
1362: p_encoded => FND_API.G_FALSE,

Line 1359: x_return_status := FND_API.G_RET_STS_ERROR;

1355: p_data => x_msg_data );
1356:
1357: EXCEPTION
1358: WHEN FND_API.G_EXC_ERROR THEN
1359: x_return_status := FND_API.G_RET_STS_ERROR;
1360:
1361: FND_MSG_PUB.Count_And_Get(
1362: p_encoded => FND_API.G_FALSE,
1363: p_count => x_msg_count,

Line 1362: p_encoded => FND_API.G_FALSE,

1358: WHEN FND_API.G_EXC_ERROR THEN
1359: x_return_status := FND_API.G_RET_STS_ERROR;
1360:
1361: FND_MSG_PUB.Count_And_Get(
1362: p_encoded => FND_API.G_FALSE,
1363: p_count => x_msg_count,
1364: p_data => x_msg_data );
1365:
1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1362: p_encoded => FND_API.G_FALSE,
1363: p_count => x_msg_count,
1364: p_data => x_msg_data );
1365:
1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1368:
1369: FND_MSG_PUB.Count_And_Get(
1370: p_encoded => FND_API.G_FALSE,

Line 1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1363: p_count => x_msg_count,
1364: p_data => x_msg_data );
1365:
1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1368:
1369: FND_MSG_PUB.Count_And_Get(
1370: p_encoded => FND_API.G_FALSE,
1371: p_count => x_msg_count,

Line 1370: p_encoded => FND_API.G_FALSE,

1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1368:
1369: FND_MSG_PUB.Count_And_Get(
1370: p_encoded => FND_API.G_FALSE,
1371: p_count => x_msg_count,
1372: p_data => x_msg_data );
1373:
1374: WHEN OTHERS THEN

Line 1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1371: p_count => x_msg_count,
1372: p_data => x_msg_data );
1373:
1374: WHEN OTHERS THEN
1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1376:
1377: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
1378: fnd_message.set_token( 'ERROR' ,SQLERRM );
1379: fnd_msg_pub.add;

Line 1382: p_encoded => FND_API.G_FALSE,

1378: fnd_message.set_token( 'ERROR' ,SQLERRM );
1379: fnd_msg_pub.add;
1380:
1381: FND_MSG_PUB.Count_And_Get(
1382: p_encoded => FND_API.G_FALSE,
1383: p_count => x_msg_count,
1384: p_data => x_msg_data );
1385:
1386:

Line 1450: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1446: p_org_contact_rec.party_rel_rec.party_rec.party_id := x_party_id;
1447: p_org_contact_rec.party_rel_rec.party_rec.party_number := x_party_number;
1448: p_org_contact_rec.party_rel_rec.relationship_id := x_party_rel_id;
1449:
1450: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1451: RAISE FND_API.G_EXC_ERROR;
1452: END IF;
1453:
1454: -- call table-handler.

Line 1451: RAISE FND_API.G_EXC_ERROR;

1447: p_org_contact_rec.party_rel_rec.party_rec.party_number := x_party_number;
1448: p_org_contact_rec.party_rel_rec.relationship_id := x_party_rel_id;
1449:
1450: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1451: RAISE FND_API.G_EXC_ERROR;
1452: END IF;
1453:
1454: -- call table-handler.
1455: HZ_ORG_CONTACTS_PKG.Insert_Row (

Line 1503: FND_API.G_FALSE,

1499: );
1500: /*
1501: per HLD,mosr record should not be created for copy case, since old osr is still active
1502: hz_orig_system_ref_pvt.create_mosr_for_merge(
1503: FND_API.G_FALSE,
1504: 'HZ_ORG_CONTACTS',
1505: p_org_contact_rec.org_contact_id,
1506: x_return_status,
1507: l_msg_count,

Line 1510: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1506: x_return_status,
1507: l_msg_count,
1508: l_msg_data);
1509:
1510: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1511: RAISE FND_API.G_EXC_ERROR;
1512: END IF;
1513: */
1514: x_org_contact_id := p_org_contact_rec.org_contact_id;

Line 1511: RAISE FND_API.G_EXC_ERROR;

1507: l_msg_count,
1508: l_msg_data);
1509:
1510: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1511: RAISE FND_API.G_EXC_ERROR;
1512: END IF;
1513: */
1514: x_org_contact_id := p_org_contact_rec.org_contact_id;
1515: END do_create_org_contact;

Line 1518: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

1514: x_org_contact_id := p_org_contact_rec.org_contact_id;
1515: END do_create_org_contact;
1516:
1517: PROCEDURE create_org_contact (
1518: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
1519: p_org_contact_rec IN HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE,
1520: p_direction_code IN VARCHAR2,
1521: x_org_contact_id OUT NOCOPY NUMBER,
1522: x_party_rel_id OUT NOCOPY NUMBER,

Line 1540: x_return_status := FND_API.G_RET_STS_SUCCESS;

1536: -- standard start of API savepoint
1537: SAVEPOINT create_org_contact;
1538:
1539: -- initialize API return status to success.
1540: x_return_status := FND_API.G_RET_STS_SUCCESS;
1541:
1542: -- call to business logic.
1543: do_create_org_contact(
1544: l_org_contact_rec,

Line 1553: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1549: x_party_id,
1550: x_party_number
1551: );
1552:
1553: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1554: -- Invoke business event system.
1555: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN --10168091
1556: HZ_BUSINESS_EVENT_V2PVT.create_org_contact_event (
1557: l_org_contact_rec );

Line 1566: p_encoded => FND_API.G_FALSE,

1562: HZ_DQM_SYNC.sync_contact(l_org_contact_rec.org_contact_id, 'C');
1563:
1564: -- standard call to get message count and if count is 1, get message info.
1565: FND_MSG_PUB.Count_And_Get(
1566: p_encoded => FND_API.G_FALSE,
1567: p_count => x_msg_count,
1568: p_data => x_msg_data);
1569:
1570:

Line 1572: WHEN FND_API.G_EXC_ERROR THEN

1568: p_data => x_msg_data);
1569:
1570:
1571: EXCEPTION
1572: WHEN FND_API.G_EXC_ERROR THEN
1573: ROLLBACK TO create_org_contact;
1574: x_return_status := FND_API.G_RET_STS_ERROR;
1575: FND_MSG_PUB.Count_And_Get(
1576: p_encoded => FND_API.G_FALSE,

Line 1574: x_return_status := FND_API.G_RET_STS_ERROR;

1570:
1571: EXCEPTION
1572: WHEN FND_API.G_EXC_ERROR THEN
1573: ROLLBACK TO create_org_contact;
1574: x_return_status := FND_API.G_RET_STS_ERROR;
1575: FND_MSG_PUB.Count_And_Get(
1576: p_encoded => FND_API.G_FALSE,
1577: p_count => x_msg_count,
1578: p_data => x_msg_data);

Line 1576: p_encoded => FND_API.G_FALSE,

1572: WHEN FND_API.G_EXC_ERROR THEN
1573: ROLLBACK TO create_org_contact;
1574: x_return_status := FND_API.G_RET_STS_ERROR;
1575: FND_MSG_PUB.Count_And_Get(
1576: p_encoded => FND_API.G_FALSE,
1577: p_count => x_msg_count,
1578: p_data => x_msg_data);
1579:
1580:

Line 1581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1577: p_count => x_msg_count,
1578: p_data => x_msg_data);
1579:
1580:
1581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1582: ROLLBACK TO create_org_contact;
1583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1584: FND_MSG_PUB.Count_And_Get(
1585: p_encoded => FND_API.G_FALSE,

Line 1583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1579:
1580:
1581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1582: ROLLBACK TO create_org_contact;
1583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1584: FND_MSG_PUB.Count_And_Get(
1585: p_encoded => FND_API.G_FALSE,
1586: p_count => x_msg_count,
1587: p_data => x_msg_data);

Line 1585: p_encoded => FND_API.G_FALSE,

1581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1582: ROLLBACK TO create_org_contact;
1583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1584: FND_MSG_PUB.Count_And_Get(
1585: p_encoded => FND_API.G_FALSE,
1586: p_count => x_msg_count,
1587: p_data => x_msg_data);
1588:
1589:

Line 1592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1588:
1589:
1590: WHEN OTHERS THEN
1591: ROLLBACK TO create_org_contact;
1592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1593: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1594: fnd_message.set_token('ERROR' ,SQLERRM);
1595: fnd_msg_pub.add;
1596: FND_MSG_PUB.Count_And_Get(

Line 1597: p_encoded => FND_API.G_FALSE,

1593: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1594: fnd_message.set_token('ERROR' ,SQLERRM);
1595: fnd_msg_pub.add;
1596: FND_MSG_PUB.Count_And_Get(
1597: p_encoded => FND_API.G_FALSE,
1598: p_count => x_msg_count,
1599: p_data => x_msg_data);
1600:
1601: END create_org_contact;

Line 1605: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1601: END create_org_contact;
1602:
1603:
1604: PROCEDURE get_org_contact_rec (
1605: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1606: p_org_contact_id IN NUMBER,
1607: x_org_contact_rec OUT NOCOPY HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE,
1608: x_direction_code OUT NOCOPY VARCHAR2,
1609: x_return_status OUT NOCOPY VARCHAR2,

Line 1621: IF FND_API.to_Boolean(p_init_msg_list) THEN

1617:
1618: BEGIN
1619:
1620: --Initialize message list if p_init_msg_list is set to TRUE.
1621: IF FND_API.to_Boolean(p_init_msg_list) THEN
1622: FND_MSG_PUB.initialize;
1623: END IF;
1624:
1625: --Initialize API return status to success.

Line 1626: x_return_status := FND_API.G_RET_STS_SUCCESS;

1622: FND_MSG_PUB.initialize;
1623: END IF;
1624:
1625: --Initialize API return status to success.
1626: x_return_status := FND_API.G_RET_STS_SUCCESS;
1627: --Check whether primary key has been passed in.
1628: IF p_org_contact_id IS NULL OR
1629: p_org_contact_id = FND_API.G_MISS_NUM THEN
1630: fnd_message.set_name( 'AR', 'HZ_API_MISSING_COLUMN' );

Line 1629: p_org_contact_id = FND_API.G_MISS_NUM THEN

1625: --Initialize API return status to success.
1626: x_return_status := FND_API.G_RET_STS_SUCCESS;
1627: --Check whether primary key has been passed in.
1628: IF p_org_contact_id IS NULL OR
1629: p_org_contact_id = FND_API.G_MISS_NUM THEN
1630: fnd_message.set_name( 'AR', 'HZ_API_MISSING_COLUMN' );
1631: fnd_message.set_token( 'COLUMN', 'org_contact_id' );
1632: fnd_msg_pub.add;
1633: RAISE FND_API.G_EXC_ERROR;

Line 1633: RAISE FND_API.G_EXC_ERROR;

1629: p_org_contact_id = FND_API.G_MISS_NUM THEN
1630: fnd_message.set_name( 'AR', 'HZ_API_MISSING_COLUMN' );
1631: fnd_message.set_token( 'COLUMN', 'org_contact_id' );
1632: fnd_msg_pub.add;
1633: RAISE FND_API.G_EXC_ERROR;
1634: END IF;
1635:
1636: x_org_contact_rec.org_contact_id := p_org_contact_id;
1637:

Line 1685: l_party_relationship_id <> FND_API.G_MISS_NUM

1681:
1682:
1683: IF l_party_relationship_id IS NOT NULL
1684: AND
1685: l_party_relationship_id <> FND_API.G_MISS_NUM
1686: THEN
1687: get_relationship_rec (
1688: p_relationship_id => l_party_relationship_id,
1689: p_directional_flag => 'F',

Line 1697: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1693: x_msg_count => x_msg_count,
1694: x_msg_data => x_msg_data
1695: );
1696:
1697: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1698: RAISE FND_API.G_EXC_ERROR;
1699: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1701: END IF;

Line 1698: RAISE FND_API.G_EXC_ERROR;

1694: x_msg_data => x_msg_data
1695: );
1696:
1697: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1698: RAISE FND_API.G_EXC_ERROR;
1699: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1701: END IF;
1702: END IF;

Line 1699: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1695: );
1696:
1697: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1698: RAISE FND_API.G_EXC_ERROR;
1699: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1701: END IF;
1702: END IF;
1703:

Line 1700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1696:
1697: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1698: RAISE FND_API.G_EXC_ERROR;
1699: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1701: END IF;
1702: END IF;
1703:
1704: --Standard call to get message count and if count is 1, get message info.

Line 1706: p_encoded => FND_API.G_FALSE,

1702: END IF;
1703:
1704: --Standard call to get message count and if count is 1, get message info.
1705: FND_MSG_PUB.Count_And_Get(
1706: p_encoded => FND_API.G_FALSE,
1707: p_count => x_msg_count,
1708: p_data => x_msg_data );
1709:
1710: EXCEPTION

Line 1711: WHEN FND_API.G_EXC_ERROR THEN

1707: p_count => x_msg_count,
1708: p_data => x_msg_data );
1709:
1710: EXCEPTION
1711: WHEN FND_API.G_EXC_ERROR THEN
1712: x_return_status := FND_API.G_RET_STS_ERROR;
1713:
1714: FND_MSG_PUB.Count_And_Get(
1715: p_encoded => FND_API.G_FALSE,

Line 1712: x_return_status := FND_API.G_RET_STS_ERROR;

1708: p_data => x_msg_data );
1709:
1710: EXCEPTION
1711: WHEN FND_API.G_EXC_ERROR THEN
1712: x_return_status := FND_API.G_RET_STS_ERROR;
1713:
1714: FND_MSG_PUB.Count_And_Get(
1715: p_encoded => FND_API.G_FALSE,
1716: p_count => x_msg_count,

Line 1715: p_encoded => FND_API.G_FALSE,

1711: WHEN FND_API.G_EXC_ERROR THEN
1712: x_return_status := FND_API.G_RET_STS_ERROR;
1713:
1714: FND_MSG_PUB.Count_And_Get(
1715: p_encoded => FND_API.G_FALSE,
1716: p_count => x_msg_count,
1717: p_data => x_msg_data );
1718:
1719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1715: p_encoded => FND_API.G_FALSE,
1716: p_count => x_msg_count,
1717: p_data => x_msg_data );
1718:
1719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1721:
1722: FND_MSG_PUB.Count_And_Get(
1723: p_encoded => FND_API.G_FALSE,

Line 1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1716: p_count => x_msg_count,
1717: p_data => x_msg_data );
1718:
1719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1721:
1722: FND_MSG_PUB.Count_And_Get(
1723: p_encoded => FND_API.G_FALSE,
1724: p_count => x_msg_count,

Line 1723: p_encoded => FND_API.G_FALSE,

1719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1721:
1722: FND_MSG_PUB.Count_And_Get(
1723: p_encoded => FND_API.G_FALSE,
1724: p_count => x_msg_count,
1725: p_data => x_msg_data );
1726:
1727: WHEN OTHERS THEN

Line 1728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1724: p_count => x_msg_count,
1725: p_data => x_msg_data );
1726:
1727: WHEN OTHERS THEN
1728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1729: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
1730: fnd_message.set_token( 'ERROR' ,SQLERRM );
1731: fnd_msg_pub.add;
1732: FND_MSG_PUB.Count_And_Get(

Line 1733: p_encoded => FND_API.G_FALSE,

1729: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
1730: fnd_message.set_token( 'ERROR' ,SQLERRM );
1731: fnd_msg_pub.add;
1732: FND_MSG_PUB.Count_And_Get(
1733: p_encoded => FND_API.G_FALSE,
1734: p_count => x_msg_count,
1735: p_data => x_msg_data );
1736:
1737: END get_org_contact_rec;

Line 1869: p_party_site_rec.status = FND_API.G_MISS_CHAR)/* AND

1865: -- For non-profile entities, the concept of select/de-select data-sources is obsoleted.
1866: -- There is no need to check if the data-source is selected.
1867:
1868: IF (NVL(p_party_site_rec.status, 'A') = 'A' OR
1869: p_party_site_rec.status = FND_API.G_MISS_CHAR)/* AND
1870: g_pst_is_datasource_selected = 'Y'*/
1871: THEN
1872: p_party_site_rec.identifying_address_flag := 'Y';
1873: ELSE

Line 1893: IF p_party_site_rec.party_site_id = FND_API.G_MISS_NUM THEN

1889: p_party_site_rec.party_site_id := l_party_site_id;
1890: p_party_site_rec.party_site_number := l_party_site_number;
1891:
1892: -- this is for orig_system_defaulting
1893: IF p_party_site_rec.party_site_id = FND_API.G_MISS_NUM THEN
1894: p_party_site_rec.party_site_id := NULL;
1895: END IF;
1896:
1897:

Line 1942: FND_API.G_FALSE,

1938: );
1939: /*
1940: per HLD,mosr record should not be created for copy case, since old osr is still active
1941: hz_orig_system_ref_pvt.create_mosr_for_merge(
1942: FND_API.G_FALSE,
1943: 'HZ_PARTY_SITES',
1944: p_party_site_rec.party_site_id,
1945: x_return_status,
1946: l_msg_count,

Line 1949: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1945: x_return_status,
1946: l_msg_count,
1947: l_msg_data);
1948:
1949: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1950: RAISE FND_API.G_EXC_ERROR;
1951: END IF;
1952: */
1953: x_party_site_id := p_party_site_rec.party_site_id;

Line 1950: RAISE FND_API.G_EXC_ERROR;

1946: l_msg_count,
1947: l_msg_data);
1948:
1949: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1950: RAISE FND_API.G_EXC_ERROR;
1951: END IF;
1952: */
1953: x_party_site_id := p_party_site_rec.party_site_id;
1954: x_party_site_number := p_party_site_rec.party_site_number;

Line 2078: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2074: -- body of public procedures
2075: ----------------------------
2076:
2077: PROCEDURE create_party_site (
2078: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2079: p_party_site_rec IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE,
2080: p_actual_cont_source IN VARCHAR2,
2081: x_party_site_id OUT NOCOPY NUMBER,
2082: x_party_site_number OUT NOCOPY VARCHAR2,

Line 2097: IF FND_API.to_Boolean(p_init_msg_list) THEN

2093: -- standard start of API savepoint
2094: SAVEPOINT create_party_site;
2095:
2096: -- initialize message list if p_init_msg_list is set to TRUE.
2097: IF FND_API.to_Boolean(p_init_msg_list) THEN
2098: FND_MSG_PUB.initialize;
2099: END IF;
2100:
2101: -- initialize API return status to success.

Line 2102: x_return_status := FND_API.G_RET_STS_SUCCESS;

2098: FND_MSG_PUB.initialize;
2099: END IF;
2100:
2101: -- initialize API return status to success.
2102: x_return_status := FND_API.G_RET_STS_SUCCESS;
2103:
2104: -- Bug 2197181: added for mix-n-match project. first load data
2105: -- sources for this entity.
2106: /*

Line 2124: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2120: x_party_site_number,
2121: x_return_status
2122: );
2123:
2124: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2125: -- Invoke business event system.
2126: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN --10168091
2127: HZ_BUSINESS_EVENT_V2PVT.create_party_site_event (
2128: l_party_site_rec );

Line 2137: p_encoded => FND_API.G_FALSE,

2133: HZ_DQM_SYNC.sync_party_site(l_party_site_rec.party_site_id,'C');
2134:
2135: -- standard call to get message count and if count is 1, get message info.
2136: FND_MSG_PUB.Count_And_Get(
2137: p_encoded => FND_API.G_FALSE,
2138: p_count => x_msg_count,
2139: p_data => x_msg_data);
2140:
2141: EXCEPTION

Line 2142: WHEN FND_API.G_EXC_ERROR THEN

2138: p_count => x_msg_count,
2139: p_data => x_msg_data);
2140:
2141: EXCEPTION
2142: WHEN FND_API.G_EXC_ERROR THEN
2143: ROLLBACK TO create_party_site;
2144: x_return_status := FND_API.G_RET_STS_ERROR;
2145: FND_MSG_PUB.Count_And_Get(
2146: p_encoded => FND_API.G_FALSE,

Line 2144: x_return_status := FND_API.G_RET_STS_ERROR;

2140:
2141: EXCEPTION
2142: WHEN FND_API.G_EXC_ERROR THEN
2143: ROLLBACK TO create_party_site;
2144: x_return_status := FND_API.G_RET_STS_ERROR;
2145: FND_MSG_PUB.Count_And_Get(
2146: p_encoded => FND_API.G_FALSE,
2147: p_count => x_msg_count,
2148: p_data => x_msg_data);

Line 2146: p_encoded => FND_API.G_FALSE,

2142: WHEN FND_API.G_EXC_ERROR THEN
2143: ROLLBACK TO create_party_site;
2144: x_return_status := FND_API.G_RET_STS_ERROR;
2145: FND_MSG_PUB.Count_And_Get(
2146: p_encoded => FND_API.G_FALSE,
2147: p_count => x_msg_count,
2148: p_data => x_msg_data);
2149:
2150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2146: p_encoded => FND_API.G_FALSE,
2147: p_count => x_msg_count,
2148: p_data => x_msg_data);
2149:
2150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2151: ROLLBACK TO create_party_site;
2152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2153: FND_MSG_PUB.Count_And_Get(
2154: p_encoded => FND_API.G_FALSE,

Line 2152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2148: p_data => x_msg_data);
2149:
2150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2151: ROLLBACK TO create_party_site;
2152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2153: FND_MSG_PUB.Count_And_Get(
2154: p_encoded => FND_API.G_FALSE,
2155: p_count => x_msg_count,
2156: p_data => x_msg_data);

Line 2154: p_encoded => FND_API.G_FALSE,

2150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2151: ROLLBACK TO create_party_site;
2152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2153: FND_MSG_PUB.Count_And_Get(
2154: p_encoded => FND_API.G_FALSE,
2155: p_count => x_msg_count,
2156: p_data => x_msg_data);
2157: WHEN OTHERS THEN
2158: ROLLBACK TO create_party_site;

Line 2159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2155: p_count => x_msg_count,
2156: p_data => x_msg_data);
2157: WHEN OTHERS THEN
2158: ROLLBACK TO create_party_site;
2159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2160: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2161: fnd_message.set_token('ERROR' ,SQLERRM);
2162: fnd_msg_pub.add;
2163: FND_MSG_PUB.Count_And_Get(

Line 2164: p_encoded => FND_API.G_FALSE,

2160: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2161: fnd_message.set_token('ERROR' ,SQLERRM);
2162: fnd_msg_pub.add;
2163: FND_MSG_PUB.Count_And_Get(
2164: p_encoded => FND_API.G_FALSE,
2165: p_count => x_msg_count,
2166: p_data => x_msg_data);
2167:
2168: END create_party_site;

Line 2172: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2168: END create_party_site;
2169:
2170:
2171: PROCEDURE get_party_site_rec (
2172: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2173: p_party_site_id IN NUMBER,
2174: x_party_site_rec OUT NOCOPY HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE,
2175: x_actual_cont_source OUT NOCOPY VARCHAR2,
2176: x_return_status OUT NOCOPY VARCHAR2,

Line 2188: IF FND_API.to_Boolean(p_init_msg_list) THEN

2184:
2185: BEGIN
2186:
2187: --Initialize message list if p_init_msg_list is set to TRUE.
2188: IF FND_API.to_Boolean(p_init_msg_list) THEN
2189: FND_MSG_PUB.initialize;
2190: END IF;
2191:
2192: --Initialize API return status to success.

Line 2193: x_return_status := FND_API.G_RET_STS_SUCCESS;

2189: FND_MSG_PUB.initialize;
2190: END IF;
2191:
2192: --Initialize API return status to success.
2193: x_return_status := FND_API.G_RET_STS_SUCCESS;
2194:
2195: --Check whether primary key has been passed in.
2196: IF p_party_site_id IS NULL OR
2197: p_party_site_id = FND_API.G_MISS_NUM THEN

Line 2197: p_party_site_id = FND_API.G_MISS_NUM THEN

2193: x_return_status := FND_API.G_RET_STS_SUCCESS;
2194:
2195: --Check whether primary key has been passed in.
2196: IF p_party_site_id IS NULL OR
2197: p_party_site_id = FND_API.G_MISS_NUM THEN
2198: fnd_message.set_name( 'AR', 'HZ_API_MISSING_COLUMN' );
2199: fnd_message.set_token( 'COLUMN', 'party_site_id' );
2200: fnd_msg_pub.add;
2201: RAISE FND_API.G_EXC_ERROR;

Line 2201: RAISE FND_API.G_EXC_ERROR;

2197: p_party_site_id = FND_API.G_MISS_NUM THEN
2198: fnd_message.set_name( 'AR', 'HZ_API_MISSING_COLUMN' );
2199: fnd_message.set_token( 'COLUMN', 'party_site_id' );
2200: fnd_msg_pub.add;
2201: RAISE FND_API.G_EXC_ERROR;
2202: END IF;
2203:
2204: x_party_site_rec.party_site_id := p_party_site_id;
2205:

Line 2248: p_encoded => FND_API.G_FALSE,

2244: );
2245:
2246: --Standard call to get message count and if count is 1, get message info.
2247: FND_MSG_PUB.Count_And_Get(
2248: p_encoded => FND_API.G_FALSE,
2249: p_count => x_msg_count,
2250: p_data => x_msg_data );
2251:
2252: EXCEPTION

Line 2253: WHEN FND_API.G_EXC_ERROR THEN

2249: p_count => x_msg_count,
2250: p_data => x_msg_data );
2251:
2252: EXCEPTION
2253: WHEN FND_API.G_EXC_ERROR THEN
2254: x_return_status := FND_API.G_RET_STS_ERROR;
2255:
2256: FND_MSG_PUB.Count_And_Get(
2257: p_encoded => FND_API.G_FALSE,

Line 2254: x_return_status := FND_API.G_RET_STS_ERROR;

2250: p_data => x_msg_data );
2251:
2252: EXCEPTION
2253: WHEN FND_API.G_EXC_ERROR THEN
2254: x_return_status := FND_API.G_RET_STS_ERROR;
2255:
2256: FND_MSG_PUB.Count_And_Get(
2257: p_encoded => FND_API.G_FALSE,
2258: p_count => x_msg_count,

Line 2257: p_encoded => FND_API.G_FALSE,

2253: WHEN FND_API.G_EXC_ERROR THEN
2254: x_return_status := FND_API.G_RET_STS_ERROR;
2255:
2256: FND_MSG_PUB.Count_And_Get(
2257: p_encoded => FND_API.G_FALSE,
2258: p_count => x_msg_count,
2259: p_data => x_msg_data );
2260:
2261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2257: p_encoded => FND_API.G_FALSE,
2258: p_count => x_msg_count,
2259: p_data => x_msg_data );
2260:
2261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2263:
2264: FND_MSG_PUB.Count_And_Get(
2265: p_encoded => FND_API.G_FALSE,

Line 2262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2258: p_count => x_msg_count,
2259: p_data => x_msg_data );
2260:
2261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2263:
2264: FND_MSG_PUB.Count_And_Get(
2265: p_encoded => FND_API.G_FALSE,
2266: p_count => x_msg_count,

Line 2265: p_encoded => FND_API.G_FALSE,

2261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2263:
2264: FND_MSG_PUB.Count_And_Get(
2265: p_encoded => FND_API.G_FALSE,
2266: p_count => x_msg_count,
2267: p_data => x_msg_data );
2268:
2269: WHEN OTHERS THEN

Line 2270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2266: p_count => x_msg_count,
2267: p_data => x_msg_data );
2268:
2269: WHEN OTHERS THEN
2270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2271: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
2272: fnd_message.set_token( 'ERROR' ,SQLERRM );
2273: fnd_msg_pub.add;
2274: FND_MSG_PUB.Count_And_Get(

Line 2275: p_encoded => FND_API.G_FALSE,

2271: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
2272: fnd_message.set_token( 'ERROR' ,SQLERRM );
2273: fnd_msg_pub.add;
2274: FND_MSG_PUB.Count_And_Get(
2275: p_encoded => FND_API.G_FALSE,
2276: p_count => x_msg_count,
2277: p_data => x_msg_data );
2278:
2279: END get_party_site_rec;

Line 2294: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,

2290:
2291: PROCEDURE do_create_cust_site_use (
2292: p_cust_site_use_rec IN OUT NOCOPY HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE,
2293: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
2294: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,
2295: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
2296: p_org_id IN NUMBER DEFAULT null,
2297: x_site_use_id OUT NOCOPY NUMBER,
2298: x_return_status IN OUT NOCOPY VARCHAR2

Line 2295: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,

2291: PROCEDURE do_create_cust_site_use (
2292: p_cust_site_use_rec IN OUT NOCOPY HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE,
2293: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
2294: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,
2295: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
2296: p_org_id IN NUMBER DEFAULT null,
2297: x_site_use_id OUT NOCOPY NUMBER,
2298: x_return_status IN OUT NOCOPY VARCHAR2
2299: );

Line 2403: FND_API.G_FALSE,

2399: );
2400: /*
2401: per HLD,mosr record should not be created for copy case, since old osr is still active
2402: hz_orig_system_ref_pvt.create_mosr_for_merge(
2403: FND_API.G_FALSE,
2404: 'HZ_CUST_ACCT_SITES_ALL',
2405: p_cust_acct_site_rec.cust_acct_site_id,
2406: x_return_status,
2407: l_msg_count,

Line 2409: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2405: p_cust_acct_site_rec.cust_acct_site_id,
2406: x_return_status,
2407: l_msg_count,
2408: l_msg_data);
2409: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2410: RAISE FND_API.G_EXC_ERROR;
2411: END IF;
2412: */
2413: x_cust_acct_site_id := p_cust_acct_site_rec.cust_acct_site_id;

Line 2410: RAISE FND_API.G_EXC_ERROR;

2406: x_return_status,
2407: l_msg_count,
2408: l_msg_data);
2409: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2410: RAISE FND_API.G_EXC_ERROR;
2411: END IF;
2412: */
2413: x_cust_acct_site_id := p_cust_acct_site_rec.cust_acct_site_id;
2414:

Line 2421: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,

2417:
2418: PROCEDURE do_create_cust_site_use (
2419: p_cust_site_use_rec IN OUT NOCOPY HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE,
2420: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
2421: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,
2422: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
2423: p_org_id IN NUMBER DEFAULT null,
2424: x_site_use_id OUT NOCOPY NUMBER,
2425: x_return_status IN OUT NOCOPY VARCHAR2

Line 2422: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,

2418: PROCEDURE do_create_cust_site_use (
2419: p_cust_site_use_rec IN OUT NOCOPY HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE,
2420: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
2421: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,
2422: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
2423: p_org_id IN NUMBER DEFAULT null,
2424: x_site_use_id OUT NOCOPY NUMBER,
2425: x_return_status IN OUT NOCOPY VARCHAR2
2426: ) IS

Line 2569: p_cust_site_use_rec.status = FND_API.G_MISS_CHAR

2565: ----Bug No. 5211233
2566:
2567: ELSIF p_cust_site_use_rec.status = 'A' OR
2568: p_cust_site_use_rec.status IS NULL OR
2569: p_cust_site_use_rec.status = FND_API.G_MISS_CHAR
2570: THEN
2571: l_flag := 'Y';
2572: ELSE
2573: l_flag := NULL;

Line 2583: IF p_create_profile = FND_API.G_TRUE THEN

2579: l_flag );
2580:
2581: END IF;
2582:
2583: IF p_create_profile = FND_API.G_TRUE THEN
2584:
2585: -- Create the profile for the site use
2586:
2587: p_customer_profile_rec.site_use_id := p_cust_site_use_rec.site_use_id;

Line 2603: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2599: x_msg_count => l_msg_count,
2600: x_msg_data => l_msg_data,
2601: x_cust_account_profile_id => l_cust_account_profile_id );
2602:
2603: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2604: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2605: RAISE FND_API.G_EXC_ERROR;
2606: ELSE
2607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2604: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2600: x_msg_data => l_msg_data,
2601: x_cust_account_profile_id => l_cust_account_profile_id );
2602:
2603: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2604: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2605: RAISE FND_API.G_EXC_ERROR;
2606: ELSE
2607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2608: END IF;

Line 2605: RAISE FND_API.G_EXC_ERROR;

2601: x_cust_account_profile_id => l_cust_account_profile_id );
2602:
2603: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2604: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2605: RAISE FND_API.G_EXC_ERROR;
2606: ELSE
2607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2608: END IF;
2609: END IF;

Line 2607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2603: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2604: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2605: RAISE FND_API.G_EXC_ERROR;
2606: ELSE
2607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2608: END IF;
2609: END IF;
2610:
2611: END IF;

Line 2615: FND_API.G_FALSE,

2611: END IF;
2612: /*
2613: per HLD,mosr record should not be created for copy case, since old osr is still active
2614: hz_orig_system_ref_pvt.create_mosr_for_merge(
2615: FND_API.G_FALSE,
2616: 'HZ_CUST_SITE_USES_ALL',
2617: p_cust_site_use_rec.site_use_id,
2618: x_return_status,
2619: l_msg_count,

Line 2621: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2617: p_cust_site_use_rec.site_use_id,
2618: x_return_status,
2619: l_msg_count,
2620: l_msg_data);
2621: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2622: RAISE FND_API.G_EXC_ERROR;
2623: END IF;
2624: */
2625: x_site_use_id := p_cust_site_use_rec.site_use_id;

Line 2622: RAISE FND_API.G_EXC_ERROR;

2618: x_return_status,
2619: l_msg_count,
2620: l_msg_data);
2621: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2622: RAISE FND_API.G_EXC_ERROR;
2623: END IF;
2624: */
2625: x_site_use_id := p_cust_site_use_rec.site_use_id;
2626:

Line 2663: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2659: -- public procedures and functions
2660: --------------------------------------
2661:
2662: PROCEDURE create_cust_acct_site (
2663: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2664: p_cust_acct_site_rec IN HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE,
2665: p_org_id IN NUMBER ,
2666: x_cust_acct_site_id OUT NOCOPY NUMBER,
2667: x_return_status OUT NOCOPY VARCHAR2,

Line 2682: IF FND_API.to_Boolean(p_init_msg_list) THEN

2678: SAVEPOINT create_cust_acct_site;
2679:
2680:
2681: -- Initialize message list if p_init_msg_list is set to TRUE.
2682: IF FND_API.to_Boolean(p_init_msg_list) THEN
2683: FND_MSG_PUB.initialize;
2684: END IF;
2685:
2686: -- Initialize API return status to success.

Line 2687: x_return_status := FND_API.G_RET_STS_SUCCESS;

2683: FND_MSG_PUB.initialize;
2684: END IF;
2685:
2686: -- Initialize API return status to success.
2687: x_return_status := FND_API.G_RET_STS_SUCCESS;
2688:
2689: -- Call to business logic.
2690: do_create_cust_acct_site (
2691: l_cust_acct_site_rec,

Line 2696: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2692: p_org_id,
2693: x_cust_acct_site_id,
2694: x_return_status );
2695:
2696: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2697: -- Invoke business event system.
2698: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN --10168091
2699: HZ_BUSINESS_EVENT_V2PVT.create_cust_acct_site_event (
2700: l_cust_acct_site_rec );

Line 2706: p_encoded => FND_API.G_FALSE,

2702: END IF;
2703:
2704: -- Standard call to get message count and if count is 1, get message info.
2705: FND_MSG_PUB.Count_And_Get(
2706: p_encoded => FND_API.G_FALSE,
2707: p_count => x_msg_count,
2708: p_data => x_msg_data );
2709:
2710:

Line 2712: WHEN FND_API.G_EXC_ERROR THEN

2708: p_data => x_msg_data );
2709:
2710:
2711: EXCEPTION
2712: WHEN FND_API.G_EXC_ERROR THEN
2713: ROLLBACK TO create_cust_acct_site;
2714: x_return_status := FND_API.G_RET_STS_ERROR;
2715:
2716: FND_MSG_PUB.Count_And_Get(

Line 2714: x_return_status := FND_API.G_RET_STS_ERROR;

2710:
2711: EXCEPTION
2712: WHEN FND_API.G_EXC_ERROR THEN
2713: ROLLBACK TO create_cust_acct_site;
2714: x_return_status := FND_API.G_RET_STS_ERROR;
2715:
2716: FND_MSG_PUB.Count_And_Get(
2717: p_encoded => FND_API.G_FALSE,
2718: p_count => x_msg_count,

Line 2717: p_encoded => FND_API.G_FALSE,

2713: ROLLBACK TO create_cust_acct_site;
2714: x_return_status := FND_API.G_RET_STS_ERROR;
2715:
2716: FND_MSG_PUB.Count_And_Get(
2717: p_encoded => FND_API.G_FALSE,
2718: p_count => x_msg_count,
2719: p_data => x_msg_data );
2720:
2721:

Line 2722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2718: p_count => x_msg_count,
2719: p_data => x_msg_data );
2720:
2721:
2722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2723: ROLLBACK TO create_cust_acct_site;
2724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2725:
2726: FND_MSG_PUB.Count_And_Get(

Line 2724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2720:
2721:
2722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2723: ROLLBACK TO create_cust_acct_site;
2724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2725:
2726: FND_MSG_PUB.Count_And_Get(
2727: p_encoded => FND_API.G_FALSE,
2728: p_count => x_msg_count,

Line 2727: p_encoded => FND_API.G_FALSE,

2723: ROLLBACK TO create_cust_acct_site;
2724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2725:
2726: FND_MSG_PUB.Count_And_Get(
2727: p_encoded => FND_API.G_FALSE,
2728: p_count => x_msg_count,
2729: p_data => x_msg_data );
2730:
2731: WHEN OTHERS THEN

Line 2733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2729: p_data => x_msg_data );
2730:
2731: WHEN OTHERS THEN
2732: ROLLBACK TO create_cust_acct_site;
2733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2734:
2735: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
2736: fnd_message.set_token( 'ERROR' ,SQLERRM );
2737: fnd_msg_pub.add;

Line 2740: p_encoded => FND_API.G_FALSE,

2736: fnd_message.set_token( 'ERROR' ,SQLERRM );
2737: fnd_msg_pub.add;
2738:
2739: FND_MSG_PUB.Count_And_Get(
2740: p_encoded => FND_API.G_FALSE,
2741: p_count => x_msg_count,
2742: p_data => x_msg_data );
2743:
2744:

Line 2748: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2744:
2745: END create_cust_acct_site;
2746:
2747: PROCEDURE create_cust_site_use (
2748: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2749: p_cust_site_use_rec IN HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE,
2750: p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
2751: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,
2752: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,

Line 2751: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,

2747: PROCEDURE create_cust_site_use (
2748: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2749: p_cust_site_use_rec IN HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE,
2750: p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
2751: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,
2752: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
2753: p_org_id IN NUMBER ,
2754: x_site_use_id OUT NOCOPY NUMBER,
2755: x_return_status OUT NOCOPY VARCHAR2,

Line 2752: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,

2748: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2749: p_cust_site_use_rec IN HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE,
2750: p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
2751: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,
2752: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
2753: p_org_id IN NUMBER ,
2754: x_site_use_id OUT NOCOPY NUMBER,
2755: x_return_status OUT NOCOPY VARCHAR2,
2756: x_msg_count OUT NOCOPY NUMBER,

Line 2771: IF FND_API.to_Boolean(p_init_msg_list) THEN

2767: -- Standard start of API savepoint
2768: SAVEPOINT create_cust_site_use;
2769:
2770: -- Initialize message list if p_init_msg_list is set to TRUE.
2771: IF FND_API.to_Boolean(p_init_msg_list) THEN
2772: FND_MSG_PUB.initialize;
2773: END IF;
2774:
2775: -- Initialize API return status to success.

Line 2776: x_return_status := FND_API.G_RET_STS_SUCCESS;

2772: FND_MSG_PUB.initialize;
2773: END IF;
2774:
2775: -- Initialize API return status to success.
2776: x_return_status := FND_API.G_RET_STS_SUCCESS;
2777:
2778: -- Call to business logic.
2779: do_create_cust_site_use (
2780: l_cust_site_use_rec,

Line 2788: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2784: p_org_id,
2785: x_site_use_id,
2786: x_return_status );
2787:
2788: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2789: -- Invoke business event system.
2790: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN --10168091
2791: HZ_BUSINESS_EVENT_V2PVT.create_cust_site_use_event (
2792: l_cust_site_use_rec,

Line 2801: p_encoded => FND_API.G_FALSE,

2797: END IF;
2798:
2799: -- Standard call to get message count and if count is 1, get message info.
2800: FND_MSG_PUB.Count_And_Get(
2801: p_encoded => FND_API.G_FALSE,
2802: p_count => x_msg_count,
2803: p_data => x_msg_data );
2804:
2805: EXCEPTION

Line 2806: WHEN FND_API.G_EXC_ERROR THEN

2802: p_count => x_msg_count,
2803: p_data => x_msg_data );
2804:
2805: EXCEPTION
2806: WHEN FND_API.G_EXC_ERROR THEN
2807: ROLLBACK TO create_cust_site_use;
2808: x_return_status := FND_API.G_RET_STS_ERROR;
2809:
2810: FND_MSG_PUB.Count_And_Get(

Line 2808: x_return_status := FND_API.G_RET_STS_ERROR;

2804:
2805: EXCEPTION
2806: WHEN FND_API.G_EXC_ERROR THEN
2807: ROLLBACK TO create_cust_site_use;
2808: x_return_status := FND_API.G_RET_STS_ERROR;
2809:
2810: FND_MSG_PUB.Count_And_Get(
2811: p_encoded => FND_API.G_FALSE,
2812: p_count => x_msg_count,

Line 2811: p_encoded => FND_API.G_FALSE,

2807: ROLLBACK TO create_cust_site_use;
2808: x_return_status := FND_API.G_RET_STS_ERROR;
2809:
2810: FND_MSG_PUB.Count_And_Get(
2811: p_encoded => FND_API.G_FALSE,
2812: p_count => x_msg_count,
2813: p_data => x_msg_data );
2814:
2815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2811: p_encoded => FND_API.G_FALSE,
2812: p_count => x_msg_count,
2813: p_data => x_msg_data );
2814:
2815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2816: ROLLBACK TO create_cust_site_use;
2817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2818:
2819: FND_MSG_PUB.Count_And_Get(

Line 2817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2813: p_data => x_msg_data );
2814:
2815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2816: ROLLBACK TO create_cust_site_use;
2817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2818:
2819: FND_MSG_PUB.Count_And_Get(
2820: p_encoded => FND_API.G_FALSE,
2821: p_count => x_msg_count,

Line 2820: p_encoded => FND_API.G_FALSE,

2816: ROLLBACK TO create_cust_site_use;
2817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2818:
2819: FND_MSG_PUB.Count_And_Get(
2820: p_encoded => FND_API.G_FALSE,
2821: p_count => x_msg_count,
2822: p_data => x_msg_data );
2823:
2824:

Line 2827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2823:
2824:
2825: WHEN OTHERS THEN
2826: ROLLBACK TO create_cust_site_use;
2827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2828:
2829: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
2830: fnd_message.set_token( 'ERROR' ,SQLERRM );
2831: fnd_msg_pub.add;

Line 2834: p_encoded => FND_API.G_FALSE,

2830: fnd_message.set_token( 'ERROR' ,SQLERRM );
2831: fnd_msg_pub.add;
2832:
2833: FND_MSG_PUB.Count_And_Get(
2834: p_encoded => FND_API.G_FALSE,
2835: p_count => x_msg_count,
2836: p_data => x_msg_data );
2837:
2838: END create_cust_site_use;

Line 3119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3115: --------------------------------------
3116: -- public procedures and functions
3117: --------------------------------------
3118: PROCEDURE create_customer_profile (
3119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3120: p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
3121: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
3122: x_cust_account_profile_id OUT NOCOPY NUMBER,
3123: x_return_status OUT NOCOPY VARCHAR2,

Line 3121: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,

3117: --------------------------------------
3118: PROCEDURE create_customer_profile (
3119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3120: p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
3121: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
3122: x_cust_account_profile_id OUT NOCOPY NUMBER,
3123: x_return_status OUT NOCOPY VARCHAR2,
3124: x_msg_count OUT NOCOPY NUMBER,
3125: x_msg_data OUT NOCOPY VARCHAR2

Line 3138: IF FND_API.to_Boolean(p_init_msg_list) THEN

3134: SAVEPOINT create_customer_profile;
3135:
3136:
3137: -- Initialize message list if p_init_msg_list is set to TRUE.
3138: IF FND_API.to_Boolean(p_init_msg_list) THEN
3139: FND_MSG_PUB.initialize;
3140: END IF;
3141:
3142: -- Initialize API return status to success.

Line 3143: x_return_status := FND_API.G_RET_STS_SUCCESS;

3139: FND_MSG_PUB.initialize;
3140: END IF;
3141:
3142: -- Initialize API return status to success.
3143: x_return_status := FND_API.G_RET_STS_SUCCESS;
3144:
3145: -- Call to business logic.
3146: do_create_customer_profile (
3147: l_customer_profile_rec,

Line 3152: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

3148: p_create_profile_amt,
3149: x_cust_account_profile_id,
3150: x_return_status );
3151:
3152: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3153: -- Invoke business event system.
3154: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN --10168091
3155: HZ_BUSINESS_EVENT_V2PVT.create_customer_profile_event (
3156: l_customer_profile_rec,

Line 3163: p_encoded => FND_API.G_FALSE,

3159: END IF;
3160:
3161: -- Standard call to get message count and if count is 1, get message info.
3162: FND_MSG_PUB.Count_And_Get(
3163: p_encoded => FND_API.G_FALSE,
3164: p_count => x_msg_count,
3165: p_data => x_msg_data );
3166:
3167:

Line 3169: WHEN FND_API.G_EXC_ERROR THEN

3165: p_data => x_msg_data );
3166:
3167:
3168: EXCEPTION
3169: WHEN FND_API.G_EXC_ERROR THEN
3170: ROLLBACK TO create_customer_profile;
3171: x_return_status := FND_API.G_RET_STS_ERROR;
3172:
3173: FND_MSG_PUB.Count_And_Get(

Line 3171: x_return_status := FND_API.G_RET_STS_ERROR;

3167:
3168: EXCEPTION
3169: WHEN FND_API.G_EXC_ERROR THEN
3170: ROLLBACK TO create_customer_profile;
3171: x_return_status := FND_API.G_RET_STS_ERROR;
3172:
3173: FND_MSG_PUB.Count_And_Get(
3174: p_encoded => FND_API.G_FALSE,
3175: p_count => x_msg_count,

Line 3174: p_encoded => FND_API.G_FALSE,

3170: ROLLBACK TO create_customer_profile;
3171: x_return_status := FND_API.G_RET_STS_ERROR;
3172:
3173: FND_MSG_PUB.Count_And_Get(
3174: p_encoded => FND_API.G_FALSE,
3175: p_count => x_msg_count,
3176: p_data => x_msg_data );
3177:
3178:

Line 3179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3175: p_count => x_msg_count,
3176: p_data => x_msg_data );
3177:
3178:
3179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3180: ROLLBACK TO create_customer_profile;
3181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3182:
3183: FND_MSG_PUB.Count_And_Get(

Line 3181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3177:
3178:
3179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3180: ROLLBACK TO create_customer_profile;
3181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3182:
3183: FND_MSG_PUB.Count_And_Get(
3184: p_encoded => FND_API.G_FALSE,
3185: p_count => x_msg_count,

Line 3184: p_encoded => FND_API.G_FALSE,

3180: ROLLBACK TO create_customer_profile;
3181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3182:
3183: FND_MSG_PUB.Count_And_Get(
3184: p_encoded => FND_API.G_FALSE,
3185: p_count => x_msg_count,
3186: p_data => x_msg_data );
3187:
3188:

Line 3191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3187:
3188:
3189: WHEN OTHERS THEN
3190: ROLLBACK TO create_customer_profile;
3191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3192:
3193: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
3194: fnd_message.set_token( 'ERROR' ,SQLERRM );
3195: fnd_msg_pub.add;

Line 3198: p_encoded => FND_API.G_FALSE,

3194: fnd_message.set_token( 'ERROR' ,SQLERRM );
3195: fnd_msg_pub.add;
3196:
3197: FND_MSG_PUB.Count_And_Get(
3198: p_encoded => FND_API.G_FALSE,
3199: p_count => x_msg_count,
3200: p_data => x_msg_data );
3201:
3202:

Line 3208: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3204:
3205:
3206:
3207: PROCEDURE create_cust_profile_amt (
3208: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3209: p_check_foreign_key IN VARCHAR2 := FND_API.G_TRUE,
3210: p_cust_profile_amt_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE,
3211: x_cust_acct_profile_amt_id OUT NOCOPY NUMBER,
3212: x_return_status OUT NOCOPY VARCHAR2,

Line 3209: p_check_foreign_key IN VARCHAR2 := FND_API.G_TRUE,

3205:
3206:
3207: PROCEDURE create_cust_profile_amt (
3208: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3209: p_check_foreign_key IN VARCHAR2 := FND_API.G_TRUE,
3210: p_cust_profile_amt_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE,
3211: x_cust_acct_profile_amt_id OUT NOCOPY NUMBER,
3212: x_return_status OUT NOCOPY VARCHAR2,
3213: x_msg_count OUT NOCOPY NUMBER,

Line 3226: IF FND_API.to_Boolean(p_init_msg_list) THEN

3222: -- Standard start of API savepoint
3223: SAVEPOINT create_cust_profile_amt;
3224:
3225: -- Initialize message list if p_init_msg_list is set to TRUE.
3226: IF FND_API.to_Boolean(p_init_msg_list) THEN
3227: FND_MSG_PUB.initialize;
3228: END IF;
3229:
3230: -- Initialize API return status to success.

Line 3231: x_return_status := FND_API.G_RET_STS_SUCCESS;

3227: FND_MSG_PUB.initialize;
3228: END IF;
3229:
3230: -- Initialize API return status to success.
3231: x_return_status := FND_API.G_RET_STS_SUCCESS;
3232:
3233: -- Call to business logic.
3234: do_create_cust_profile_amt (
3235: p_check_foreign_key,

Line 3240: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

3236: l_cust_profile_amt_rec,
3237: x_cust_acct_profile_amt_id,
3238: x_return_status );
3239:
3240: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3241: -- Invoke business event system.
3242: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN --10168091
3243: HZ_BUSINESS_EVENT_V2PVT.create_cust_profile_amt_event (
3244: l_cust_profile_amt_rec );

Line 3250: p_encoded => FND_API.G_FALSE,

3246: END IF;
3247:
3248: -- Standard call to get message count and if count is 1, get message info.
3249: FND_MSG_PUB.Count_And_Get(
3250: p_encoded => FND_API.G_FALSE,
3251: p_count => x_msg_count,
3252: p_data => x_msg_data );
3253:
3254:

Line 3256: WHEN FND_API.G_EXC_ERROR THEN

3252: p_data => x_msg_data );
3253:
3254:
3255: EXCEPTION
3256: WHEN FND_API.G_EXC_ERROR THEN
3257: ROLLBACK TO create_cust_profile_amt;
3258: x_return_status := FND_API.G_RET_STS_ERROR;
3259:
3260: FND_MSG_PUB.Count_And_Get(

Line 3258: x_return_status := FND_API.G_RET_STS_ERROR;

3254:
3255: EXCEPTION
3256: WHEN FND_API.G_EXC_ERROR THEN
3257: ROLLBACK TO create_cust_profile_amt;
3258: x_return_status := FND_API.G_RET_STS_ERROR;
3259:
3260: FND_MSG_PUB.Count_And_Get(
3261: p_encoded => FND_API.G_FALSE,
3262: p_count => x_msg_count,

Line 3261: p_encoded => FND_API.G_FALSE,

3257: ROLLBACK TO create_cust_profile_amt;
3258: x_return_status := FND_API.G_RET_STS_ERROR;
3259:
3260: FND_MSG_PUB.Count_And_Get(
3261: p_encoded => FND_API.G_FALSE,
3262: p_count => x_msg_count,
3263: p_data => x_msg_data );
3264:
3265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3261: p_encoded => FND_API.G_FALSE,
3262: p_count => x_msg_count,
3263: p_data => x_msg_data );
3264:
3265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3266: ROLLBACK TO create_cust_profile_amt;
3267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3268:
3269: FND_MSG_PUB.Count_And_Get(

Line 3267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3263: p_data => x_msg_data );
3264:
3265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3266: ROLLBACK TO create_cust_profile_amt;
3267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3268:
3269: FND_MSG_PUB.Count_And_Get(
3270: p_encoded => FND_API.G_FALSE,
3271: p_count => x_msg_count,

Line 3270: p_encoded => FND_API.G_FALSE,

3266: ROLLBACK TO create_cust_profile_amt;
3267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3268:
3269: FND_MSG_PUB.Count_And_Get(
3270: p_encoded => FND_API.G_FALSE,
3271: p_count => x_msg_count,
3272: p_data => x_msg_data );
3273:
3274: WHEN OTHERS THEN

Line 3276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3272: p_data => x_msg_data );
3273:
3274: WHEN OTHERS THEN
3275: ROLLBACK TO create_cust_profile_amt;
3276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3277:
3278: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
3279: fnd_message.set_token( 'ERROR' ,SQLERRM );
3280: fnd_msg_pub.add;

Line 3283: p_encoded => FND_API.G_FALSE,

3279: fnd_message.set_token( 'ERROR' ,SQLERRM );
3280: fnd_msg_pub.add;
3281:
3282: FND_MSG_PUB.Count_And_Get(
3283: p_encoded => FND_API.G_FALSE,
3284: p_count => x_msg_count,
3285: p_data => x_msg_data );
3286:
3287: END create_cust_profile_amt;

Line 3426: p_contact_point_rec.status = fnd_api.g_miss_char OR

3422: -- it is not visible, the flag must be reset to 'N'.
3423:
3424:
3425: IF p_contact_point_rec.status IS NULL OR
3426: p_contact_point_rec.status = fnd_api.g_miss_char OR
3427: p_contact_point_rec.status = 'A'
3428: THEN
3429: IF p_contact_point_rec.primary_flag = 'Y' THEN
3430: -- Bug 2197181: added for mix-n-match project

Line 3494: p_contact_point_rec.contact_point_purpose <> fnd_api.g_miss_char

3490: -- flag can be set to 'Y' only if the contact point will be visible.
3491: -- If it is not visible, the flag must be reset to 'N'.
3492:
3493: IF p_contact_point_rec.contact_point_purpose IS NOT NULL AND
3494: p_contact_point_rec.contact_point_purpose <> fnd_api.g_miss_char
3495: THEN
3496: IF p_contact_point_rec.primary_by_purpose = 'Y' THEN
3497: -- Bug 2197181: added for mix-n-match project
3498:

Line 3520: l_phone_rec.phone_country_code <> fnd_api.g_miss_char THEN

3516: --Start of bug 7299887
3517: -- Populate transposed_phone_number
3518: IF p_contact_point_rec.contact_point_type = 'PHONE' THEN
3519: IF l_phone_rec.phone_country_code IS NOT NULL AND
3520: l_phone_rec.phone_country_code <> fnd_api.g_miss_char THEN
3521:
3522: l_transposed_phone_number := l_phone_rec.phone_country_code;
3523: END IF;
3524:

Line 3526: l_phone_rec.phone_area_code <> fnd_api.g_miss_char THEN

3522: l_transposed_phone_number := l_phone_rec.phone_country_code;
3523: END IF;
3524:
3525: IF l_phone_rec.phone_area_code IS NOT NULL AND
3526: l_phone_rec.phone_area_code <> fnd_api.g_miss_char THEN
3527:
3528: l_transposed_phone_number := l_transposed_phone_number ||l_phone_rec.phone_area_code;
3529:
3530: END IF;

Line 3608: FND_API.G_FALSE,

3604: x_contact_point_id := p_contact_point_rec.contact_point_id;
3605: /*
3606: per HLD,mosr record should not be created for copy case, since old osr is still active
3607: hz_orig_system_ref_pvt.create_mosr_for_merge(
3608: FND_API.G_FALSE,
3609: 'HZ_CONTACT_POINTS',
3610: p_contact_point_rec.contact_point_id,
3611: x_return_status,
3612: l_msg_count,

Line 3615: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3611: x_return_status,
3612: l_msg_count,
3613: l_msg_data);
3614:
3615: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3616: RAISE FND_API.G_EXC_ERROR;
3617: END IF;
3618: */
3619: END do_create_contact_point;

Line 3616: RAISE FND_API.G_EXC_ERROR;

3612: l_msg_count,
3613: l_msg_data);
3614:
3615: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3616: RAISE FND_API.G_EXC_ERROR;
3617: END IF;
3618: */
3619: END do_create_contact_point;
3620:

Line 3635: l_contact_point_id := fnd_api.g_miss_num;

3631:
3632:
3633: -- Check during insert.
3634: IF p_contact_point_id IS NULL THEN
3635: l_contact_point_id := fnd_api.g_miss_num;
3636: ELSE
3637: l_contact_point_id := p_contact_point_id;
3638: END IF;
3639:

Line 3686: l_contact_point_id := FND_API.G_MISS_NUM;

3682:
3683:
3684: -- Check during insert.
3685: IF p_contact_point_id IS NULL THEN
3686: l_contact_point_id := FND_API.G_MISS_NUM;
3687: ELSE
3688: l_contact_point_id := p_contact_point_id;
3689: END IF;
3690:

Line 3709: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

3705: --------------------------------------
3706:
3707:
3708: PROCEDURE create_contact_point (
3709: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3710: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
3711: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := g_miss_edi_rec,
3712: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
3713: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,

Line 3738: x_return_status := fnd_api.g_ret_sts_success;

3734: -- Standard start of API savepoint
3735: SAVEPOINT create_contact_point;
3736:
3737: -- Initialize API return status to success.
3738: x_return_status := fnd_api.g_ret_sts_success;
3739:
3740: /* SSM SST Integration and Extension
3741: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
3742:

Line 3775: IF x_return_status = fnd_api.g_ret_sts_success THEN

3771: l_web_rec,
3772: x_contact_point_id,
3773: x_return_status);
3774:
3775: IF x_return_status = fnd_api.g_ret_sts_success THEN
3776: -- Invoke business event system.
3777: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN --10168091
3778: hz_business_event_v2pvt.create_contact_point_event(
3779: l_contact_point_rec,

Line 3794: p_encoded => fnd_api.g_false,

3790: hz_dqm_sync.sync_contact_point(l_contact_point_rec.contact_point_id, 'C');
3791:
3792: -- Standard call to get message count and if count is 1, get message info.
3793: fnd_msg_pub.count_and_get(
3794: p_encoded => fnd_api.g_false,
3795: p_count => x_msg_count,
3796: p_data => x_msg_data);
3797:
3798:

Line 3800: WHEN fnd_api.g_exc_error THEN

3796: p_data => x_msg_data);
3797:
3798:
3799: EXCEPTION
3800: WHEN fnd_api.g_exc_error THEN
3801: ROLLBACK TO create_contact_point;
3802: x_return_status := fnd_api.g_ret_sts_error;
3803:
3804: fnd_msg_pub.count_and_get(

Line 3802: x_return_status := fnd_api.g_ret_sts_error;

3798:
3799: EXCEPTION
3800: WHEN fnd_api.g_exc_error THEN
3801: ROLLBACK TO create_contact_point;
3802: x_return_status := fnd_api.g_ret_sts_error;
3803:
3804: fnd_msg_pub.count_and_get(
3805: p_encoded => fnd_api.g_false,
3806: p_count => x_msg_count,

Line 3805: p_encoded => fnd_api.g_false,

3801: ROLLBACK TO create_contact_point;
3802: x_return_status := fnd_api.g_ret_sts_error;
3803:
3804: fnd_msg_pub.count_and_get(
3805: p_encoded => fnd_api.g_false,
3806: p_count => x_msg_count,
3807: p_data => x_msg_data);
3808:
3809: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3809: WHEN fnd_api.g_exc_unexpected_error THEN

3805: p_encoded => fnd_api.g_false,
3806: p_count => x_msg_count,
3807: p_data => x_msg_data);
3808:
3809: WHEN fnd_api.g_exc_unexpected_error THEN
3810: ROLLBACK TO create_contact_point;
3811: x_return_status := fnd_api.g_ret_sts_unexp_error;
3812:
3813: fnd_msg_pub.count_and_get(

Line 3811: x_return_status := fnd_api.g_ret_sts_unexp_error;

3807: p_data => x_msg_data);
3808:
3809: WHEN fnd_api.g_exc_unexpected_error THEN
3810: ROLLBACK TO create_contact_point;
3811: x_return_status := fnd_api.g_ret_sts_unexp_error;
3812:
3813: fnd_msg_pub.count_and_get(
3814: p_encoded => fnd_api.g_false,
3815: p_count => x_msg_count,

Line 3814: p_encoded => fnd_api.g_false,

3810: ROLLBACK TO create_contact_point;
3811: x_return_status := fnd_api.g_ret_sts_unexp_error;
3812:
3813: fnd_msg_pub.count_and_get(
3814: p_encoded => fnd_api.g_false,
3815: p_count => x_msg_count,
3816: p_data => x_msg_data);
3817:
3818: WHEN OTHERS THEN

Line 3820: x_return_status := fnd_api.g_ret_sts_unexp_error;

3816: p_data => x_msg_data);
3817:
3818: WHEN OTHERS THEN
3819: ROLLBACK TO create_contact_point;
3820: x_return_status := fnd_api.g_ret_sts_unexp_error;
3821:
3822: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3823: fnd_message.set_token('ERROR' ,SQLERRM);
3824: fnd_msg_pub.add;

Line 3827: p_encoded => fnd_api.g_false,

3823: fnd_message.set_token('ERROR' ,SQLERRM);
3824: fnd_msg_pub.add;
3825:
3826: fnd_msg_pub.count_and_get(
3827: p_encoded => fnd_api.g_false,
3828: p_count => x_msg_count,
3829: p_data => x_msg_data);
3830:
3831: END create_contact_point;

Line 3835: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

3831: END create_contact_point;
3832:
3833:
3834: PROCEDURE get_contact_point_rec (
3835: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3836: p_contact_point_id IN NUMBER,
3837: x_contact_point_rec OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3838: x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3839: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,

Line 3854: x_return_status := fnd_api.g_ret_sts_success;

3850:
3851: BEGIN
3852:
3853: -- Initialize API return status to success.
3854: x_return_status := fnd_api.g_ret_sts_success;
3855:
3856: -- Check whether primary key has been passed in.
3857: IF p_contact_point_id IS NULL OR
3858: p_contact_point_id = FND_API.G_MISS_NUM THEN

Line 3858: p_contact_point_id = FND_API.G_MISS_NUM THEN

3854: x_return_status := fnd_api.g_ret_sts_success;
3855:
3856: -- Check whether primary key has been passed in.
3857: IF p_contact_point_id IS NULL OR
3858: p_contact_point_id = FND_API.G_MISS_NUM THEN
3859: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
3860: fnd_message.set_token('COLUMN', 'contact_point_id');
3861: fnd_msg_pub.add;
3862: RAISE fnd_api.g_exc_error;

Line 3862: RAISE fnd_api.g_exc_error;

3858: p_contact_point_id = FND_API.G_MISS_NUM THEN
3859: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
3860: fnd_message.set_token('COLUMN', 'contact_point_id');
3861: fnd_msg_pub.add;
3862: RAISE fnd_api.g_exc_error;
3863: END IF;
3864:
3865: x_contact_point_rec.contact_point_id := p_contact_point_id;
3866:

Line 3935: p_encoded => fnd_api.g_false,

3931:
3932:
3933: -- Standard call to get message count and if count is 1, get message info.
3934: fnd_msg_pub.count_and_get(
3935: p_encoded => fnd_api.g_false,
3936: p_count => x_msg_count,
3937: p_data => x_msg_data);
3938:
3939: EXCEPTION

Line 3940: WHEN fnd_api.g_exc_error THEN

3936: p_count => x_msg_count,
3937: p_data => x_msg_data);
3938:
3939: EXCEPTION
3940: WHEN fnd_api.g_exc_error THEN
3941: x_return_status := fnd_api.g_ret_sts_error;
3942:
3943: fnd_msg_pub.count_and_get(
3944: p_encoded => fnd_api.g_false,

Line 3941: x_return_status := fnd_api.g_ret_sts_error;

3937: p_data => x_msg_data);
3938:
3939: EXCEPTION
3940: WHEN fnd_api.g_exc_error THEN
3941: x_return_status := fnd_api.g_ret_sts_error;
3942:
3943: fnd_msg_pub.count_and_get(
3944: p_encoded => fnd_api.g_false,
3945: p_count => x_msg_count,

Line 3944: p_encoded => fnd_api.g_false,

3940: WHEN fnd_api.g_exc_error THEN
3941: x_return_status := fnd_api.g_ret_sts_error;
3942:
3943: fnd_msg_pub.count_and_get(
3944: p_encoded => fnd_api.g_false,
3945: p_count => x_msg_count,
3946: p_data => x_msg_data);
3947:
3948: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3948: WHEN fnd_api.g_exc_unexpected_error THEN

3944: p_encoded => fnd_api.g_false,
3945: p_count => x_msg_count,
3946: p_data => x_msg_data);
3947:
3948: WHEN fnd_api.g_exc_unexpected_error THEN
3949: x_return_status := fnd_api.g_ret_sts_unexp_error;
3950:
3951: fnd_msg_pub.count_and_get(
3952: p_encoded => fnd_api.g_false,

Line 3949: x_return_status := fnd_api.g_ret_sts_unexp_error;

3945: p_count => x_msg_count,
3946: p_data => x_msg_data);
3947:
3948: WHEN fnd_api.g_exc_unexpected_error THEN
3949: x_return_status := fnd_api.g_ret_sts_unexp_error;
3950:
3951: fnd_msg_pub.count_and_get(
3952: p_encoded => fnd_api.g_false,
3953: p_count => x_msg_count,

Line 3952: p_encoded => fnd_api.g_false,

3948: WHEN fnd_api.g_exc_unexpected_error THEN
3949: x_return_status := fnd_api.g_ret_sts_unexp_error;
3950:
3951: fnd_msg_pub.count_and_get(
3952: p_encoded => fnd_api.g_false,
3953: p_count => x_msg_count,
3954: p_data => x_msg_data);
3955:
3956: WHEN OTHERS THEN

Line 3957: x_return_status := fnd_api.g_ret_sts_unexp_error;

3953: p_count => x_msg_count,
3954: p_data => x_msg_data);
3955:
3956: WHEN OTHERS THEN
3957: x_return_status := fnd_api.g_ret_sts_unexp_error;
3958:
3959: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3960: fnd_message.set_token('ERROR' ,SQLERRM);
3961: fnd_msg_pub.add;

Line 3964: p_encoded => fnd_api.g_false,

3960: fnd_message.set_token('ERROR' ,SQLERRM);
3961: fnd_msg_pub.add;
3962:
3963: fnd_msg_pub.count_and_get(
3964: p_encoded => fnd_api.g_false,
3965: p_count => x_msg_count,
3966: p_data => x_msg_data);
3967:
3968: END get_contact_point_rec;

Line 4004: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4000: |
4001: +===========================================================================*/
4002:
4003: PROCEDURE get_party_site_use_rec (
4004: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4005: p_party_site_use_id IN NUMBER,
4006: x_party_site_use_rec OUT NOCOPY HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE,
4007: x_return_status OUT NOCOPY VARCHAR2,
4008: x_msg_count OUT NOCOPY NUMBER,

Line 4017: IF FND_API.to_Boolean(p_init_msg_list) THEN

4013:
4014: BEGIN
4015:
4016: --Initialize message list if p_init_msg_list is set to TRUE.
4017: IF FND_API.to_Boolean(p_init_msg_list) THEN
4018: FND_MSG_PUB.initialize;
4019: END IF;
4020:
4021: --Initialize API return status to success.

Line 4022: x_return_status := FND_API.G_RET_STS_SUCCESS;

4018: FND_MSG_PUB.initialize;
4019: END IF;
4020:
4021: --Initialize API return status to success.
4022: x_return_status := FND_API.G_RET_STS_SUCCESS;
4023:
4024: --Check whether primary key has been passed in.
4025: IF p_party_site_use_id IS NULL OR
4026: p_party_site_use_id = FND_API.G_MISS_NUM THEN

Line 4026: p_party_site_use_id = FND_API.G_MISS_NUM THEN

4022: x_return_status := FND_API.G_RET_STS_SUCCESS;
4023:
4024: --Check whether primary key has been passed in.
4025: IF p_party_site_use_id IS NULL OR
4026: p_party_site_use_id = FND_API.G_MISS_NUM THEN
4027: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
4028: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_party_site_use_id' );
4029: FND_MSG_PUB.ADD;
4030: RAISE FND_API.G_EXC_ERROR;

Line 4030: RAISE FND_API.G_EXC_ERROR;

4026: p_party_site_use_id = FND_API.G_MISS_NUM THEN
4027: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
4028: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_party_site_use_id' );
4029: FND_MSG_PUB.ADD;
4030: RAISE FND_API.G_EXC_ERROR;
4031: END IF;
4032:
4033: x_party_site_use_rec.party_site_use_id := p_party_site_use_id;
4034:

Line 4048: p_encoded => FND_API.G_FALSE,

4044: );
4045:
4046: --Standard call to get message count and if count is 1, get message info.
4047: FND_MSG_PUB.Count_And_Get(
4048: p_encoded => FND_API.G_FALSE,
4049: p_count => x_msg_count,
4050: p_data => x_msg_data );
4051:
4052: EXCEPTION

Line 4053: WHEN FND_API.G_EXC_ERROR THEN

4049: p_count => x_msg_count,
4050: p_data => x_msg_data );
4051:
4052: EXCEPTION
4053: WHEN FND_API.G_EXC_ERROR THEN
4054: x_return_status := FND_API.G_RET_STS_ERROR;
4055:
4056: FND_MSG_PUB.Count_And_Get(
4057: p_encoded => FND_API.G_FALSE,

Line 4054: x_return_status := FND_API.G_RET_STS_ERROR;

4050: p_data => x_msg_data );
4051:
4052: EXCEPTION
4053: WHEN FND_API.G_EXC_ERROR THEN
4054: x_return_status := FND_API.G_RET_STS_ERROR;
4055:
4056: FND_MSG_PUB.Count_And_Get(
4057: p_encoded => FND_API.G_FALSE,
4058: p_count => x_msg_count,

Line 4057: p_encoded => FND_API.G_FALSE,

4053: WHEN FND_API.G_EXC_ERROR THEN
4054: x_return_status := FND_API.G_RET_STS_ERROR;
4055:
4056: FND_MSG_PUB.Count_And_Get(
4057: p_encoded => FND_API.G_FALSE,
4058: p_count => x_msg_count,
4059: p_data => x_msg_data );
4060:
4061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4057: p_encoded => FND_API.G_FALSE,
4058: p_count => x_msg_count,
4059: p_data => x_msg_data );
4060:
4061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4063:
4064: FND_MSG_PUB.Count_And_Get(
4065: p_encoded => FND_API.G_FALSE,

Line 4062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4058: p_count => x_msg_count,
4059: p_data => x_msg_data );
4060:
4061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4063:
4064: FND_MSG_PUB.Count_And_Get(
4065: p_encoded => FND_API.G_FALSE,
4066: p_count => x_msg_count,

Line 4065: p_encoded => FND_API.G_FALSE,

4061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4063:
4064: FND_MSG_PUB.Count_And_Get(
4065: p_encoded => FND_API.G_FALSE,
4066: p_count => x_msg_count,
4067: p_data => x_msg_data );
4068:
4069: WHEN OTHERS THEN

Line 4070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4066: p_count => x_msg_count,
4067: p_data => x_msg_data );
4068:
4069: WHEN OTHERS THEN
4070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4071: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
4072: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
4073: FND_MSG_PUB.ADD;
4074: FND_MSG_PUB.Count_And_Get(

Line 4075: p_encoded => FND_API.G_FALSE,

4071: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
4072: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
4073: FND_MSG_PUB.ADD;
4074: FND_MSG_PUB.Count_And_Get(
4075: p_encoded => FND_API.G_FALSE,
4076: p_count => x_msg_count,
4077: p_data => x_msg_data );
4078:
4079: END get_party_site_use_rec;

Line 4147: RAISE FND_API.G_EXC_ERROR;

4143: WHEN OTHERS THEN
4144: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
4145: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');
4146: FND_MSG_PUB.ADD;
4147: RAISE FND_API.G_EXC_ERROR;
4148: END;
4149:
4150: IF l_rowid IS NOT NULL THEN
4151: UPDATE HZ_PARTY_SITE_USES

Line 4290: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4286: |
4287: +===========================================================================*/
4288:
4289: PROCEDURE create_party_site_use (
4290: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4291: p_party_site_use_rec IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE,
4292: x_party_site_use_id OUT NOCOPY NUMBER,
4293: x_return_status OUT NOCOPY VARCHAR2,
4294: x_msg_count OUT NOCOPY NUMBER,

Line 4308: IF FND_API.to_Boolean(p_init_msg_list) THEN

4304: -- standard start of API savepoint
4305: SAVEPOINT create_party_site_use;
4306:
4307: -- initialize message list if p_init_msg_list is set to TRUE.
4308: IF FND_API.to_Boolean(p_init_msg_list) THEN
4309: FND_MSG_PUB.initialize;
4310: END IF;
4311:
4312: -- initialize API return status to success.

Line 4313: x_return_status := FND_API.G_RET_STS_SUCCESS;

4309: FND_MSG_PUB.initialize;
4310: END IF;
4311:
4312: -- initialize API return status to success.
4313: x_return_status := FND_API.G_RET_STS_SUCCESS;
4314:
4315: -- call to business logic.
4316: do_create_party_site_use(
4317: l_party_site_use_rec,

Line 4322: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

4318: x_party_site_use_id,
4319: x_return_status
4320: );
4321:
4322: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
4323: -- Invoke business event system.
4324: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN --10168091
4325: HZ_BUSINESS_EVENT_V2PVT.create_party_site_use_event (
4326: l_party_site_use_rec );

Line 4332: p_encoded => FND_API.G_FALSE,

4328: END IF;
4329:
4330: -- standard call to get message count and if count is 1, get message info.
4331: FND_MSG_PUB.Count_And_Get(
4332: p_encoded => FND_API.G_FALSE,
4333: p_count => x_msg_count,
4334: p_data => x_msg_data);
4335:
4336:

Line 4338: WHEN FND_API.G_EXC_ERROR THEN

4334: p_data => x_msg_data);
4335:
4336:
4337: EXCEPTION
4338: WHEN FND_API.G_EXC_ERROR THEN
4339: ROLLBACK TO create_party_site_use;
4340: x_return_status := FND_API.G_RET_STS_ERROR;
4341: FND_MSG_PUB.Count_And_Get(
4342: p_encoded => FND_API.G_FALSE,

Line 4340: x_return_status := FND_API.G_RET_STS_ERROR;

4336:
4337: EXCEPTION
4338: WHEN FND_API.G_EXC_ERROR THEN
4339: ROLLBACK TO create_party_site_use;
4340: x_return_status := FND_API.G_RET_STS_ERROR;
4341: FND_MSG_PUB.Count_And_Get(
4342: p_encoded => FND_API.G_FALSE,
4343: p_count => x_msg_count,
4344: p_data => x_msg_data);

Line 4342: p_encoded => FND_API.G_FALSE,

4338: WHEN FND_API.G_EXC_ERROR THEN
4339: ROLLBACK TO create_party_site_use;
4340: x_return_status := FND_API.G_RET_STS_ERROR;
4341: FND_MSG_PUB.Count_And_Get(
4342: p_encoded => FND_API.G_FALSE,
4343: p_count => x_msg_count,
4344: p_data => x_msg_data);
4345:
4346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4342: p_encoded => FND_API.G_FALSE,
4343: p_count => x_msg_count,
4344: p_data => x_msg_data);
4345:
4346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4347: ROLLBACK TO create_party_site_use;
4348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4349: FND_MSG_PUB.Count_And_Get(
4350: p_encoded => FND_API.G_FALSE,

Line 4348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4344: p_data => x_msg_data);
4345:
4346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4347: ROLLBACK TO create_party_site_use;
4348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4349: FND_MSG_PUB.Count_And_Get(
4350: p_encoded => FND_API.G_FALSE,
4351: p_count => x_msg_count,
4352: p_data => x_msg_data);

Line 4350: p_encoded => FND_API.G_FALSE,

4346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4347: ROLLBACK TO create_party_site_use;
4348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4349: FND_MSG_PUB.Count_And_Get(
4350: p_encoded => FND_API.G_FALSE,
4351: p_count => x_msg_count,
4352: p_data => x_msg_data);
4353:
4354: WHEN OTHERS THEN

Line 4356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4352: p_data => x_msg_data);
4353:
4354: WHEN OTHERS THEN
4355: ROLLBACK TO create_party_site_use;
4356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4357: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4358: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4359: FND_MSG_PUB.ADD;
4360: FND_MSG_PUB.Count_And_Get(

Line 4361: p_encoded => FND_API.G_FALSE,

4357: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4358: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4359: FND_MSG_PUB.ADD;
4360: FND_MSG_PUB.Count_And_Get(
4361: p_encoded => FND_API.G_FALSE,
4362: p_count => x_msg_count,
4363: p_data => x_msg_data);
4364:
4365: