[Home] [Help]
211: IF x_rowid IS NULL THEN
212: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
213: FND_MESSAGE.SET_TOKEN('RECORD',p_table_name);
214: FND_MESSAGE.SET_TOKEN('ID',p_col_id);
215: FND_MSG_PUB.ADD;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: ELSE
218: IF TO_CHAR(x_last_update_date,'DD-MON-YYYY HH:MI:SS') <>
219: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
219: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
220: THEN
221: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
222: FND_MESSAGE.SET_TOKEN('TABLE', p_table_name);
223: FND_MSG_PUB.ADD;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: END IF;
226: END IF;
227: END;
249: ELSE
250: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
251: FND_MESSAGE.SET_TOKEN('RECORD','HZ_ORG_CONTACTS');
252: FND_MESSAGE.SET_TOKEN('ID',p_org_contact_id);
253: FND_MSG_PUB.ADD;
254: x_return_status := FND_API.G_RET_STS_ERROR;
255: END IF;
256: CLOSE cu_org_contact_update;
257: EXCEPTION
260: CLOSE cu_org_contact_update;
261: END IF;
262: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
263: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
264: FND_MSG_PUB.ADD;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: END;
267:
268:
673: x_msg_data => x_msg_data );
674:
675: IF x_msg_count > 1 THEN
676: FOR i IN 1..x_msg_count LOOP
677: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
678: tmp_var1 := tmp_var1 || ' '|| tmp_var;
679: END LOOP;
680: x_msg_data := tmp_var1;
681: END IF;
768: x_msg_data => x_msg_data );
769:
770: IF x_msg_count > 1 THEN
771: FOR i IN 1..x_msg_count LOOP
772: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
773: tmp_var1 := tmp_var1 || ' '|| tmp_var;
774: END LOOP;
775: x_msg_data := tmp_var1;
776: END IF;
800: x_msg_data => x_msg_data);
801:
802: IF x_msg_count > 1 THEN
803: FOR i IN 1..x_msg_count LOOP
804: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
805: tmp_var1 := tmp_var1 || ' '|| tmp_var;
806: END LOOP;
807: x_msg_data := tmp_var1;
808: END IF;
889: x_contact_point_id := i_contact_point_id;
890:
891: IF x_msg_count > 1 THEN
892: FOR i IN 1..x_msg_count LOOP
893: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
894: tmp_var1 := tmp_var1 || ' '|| tmp_var;
895: END LOOP;
896: x_msg_data := tmp_var1;
897: END IF;
953: );
954:
955: IF x_msg_count > 1 THEN
956: FOR i IN 1..x_msg_count LOOP
957: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
958: tmp_var1 := tmp_var1 || ' '|| tmp_var;
959: END LOOP;
960: x_msg_data := tmp_var1;
961: END IF;
1358: x_msg_data => x_msg_data );
1359:
1360: IF x_msg_count > 1 THEN
1361: FOR i IN 1..x_msg_count LOOP
1362: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1363: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1364: END LOOP;
1365: x_msg_data := tmp_var1;
1366: END IF;
1381: );
1382:
1383: IF x_msg_count > 1 THEN
1384: FOR i IN 1..x_msg_count LOOP
1385: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1386: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1387: END LOOP;
1388: x_msg_data := tmp_var1;
1389: END IF;
1414: x_msg_data => x_msg_data );
1415:
1416: IF x_msg_count > 1 THEN
1417: FOR i IN 1..x_msg_count LOOP
1418: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1419: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1420: END LOOP;
1421: x_msg_data := tmp_var1;
1422: END IF;
1442: x_msg_data => x_msg_data );
1443:
1444: IF x_msg_count > 1 THEN
1445: FOR i IN 1..x_msg_count LOOP
1446: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1447: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1448: END LOOP;
1449: x_msg_data := tmp_var1;
1450: END IF;
1468: x_msg_data => x_msg_data );
1469:
1470: IF x_msg_count > 1 THEN
1471: FOR i IN 1..x_msg_count LOOP
1472: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1473: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1474: END LOOP;
1475: x_msg_data := tmp_var1;
1476: END IF;
1509: );
1510:
1511: IF x_msg_count > 1 THEN
1512: FOR i IN 1..x_msg_count LOOP
1513: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1514: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1515: END LOOP;
1516: x_msg_data := tmp_var1;
1517: END IF;
1537: x_msg_data => x_msg_data);
1538:
1539: IF x_msg_count > 1 THEN
1540: FOR i IN 1..x_msg_count LOOP
1541: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1542: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1543: END LOOP;
1544: x_msg_data := tmp_var1;
1545: END IF;
1630: x_msg_data => x_msg_data );
1631:
1632: IF x_msg_count > 1 THEN
1633: FOR i IN 1..x_msg_count LOOP
1634: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1635: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1636: END LOOP;
1637: x_msg_data := tmp_var1;
1638: END IF;
1661: );
1662:
1663: IF x_msg_count > 1 THEN
1664: FOR i IN 1..x_msg_count LOOP
1665: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1666: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1667: END LOOP;
1668: x_msg_data := tmp_var1;
1669: END IF;
1705:
1706:
1707: IF x_msg_count > 1 THEN
1708: FOR i IN 1..x_msg_count LOOP
1709: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1710: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1711: END LOOP;
1712: x_msg_data := tmp_var1;
1713: END IF;
1746: x_msg_data => x_msg_data );
1747:
1748: IF x_msg_count > 1 THEN
1749: FOR i IN 1..x_msg_count LOOP
1750: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1751: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1752: END LOOP;
1753: x_msg_data := tmp_var1;
1754: END IF;
1767: );
1768:
1769: IF x_msg_count > 1 THEN
1770: FOR i IN 1..x_msg_count LOOP
1771: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1772: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1773: END LOOP;
1774: x_msg_data := tmp_var1;
1775: END IF;