eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on FND_MSG_PUB

Line 21: FND_MSG_PUB.Add;

17: IF (NVL(p_number,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN
18: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
19: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
20: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
21: FND_MSG_PUB.Add;
22: RAISE FND_API.G_EXC_ERROR;
23: END IF;
24: END Check_Reqd_Param_num;
25:

Line 42: FND_MSG_PUB.Add;

38: IF (NVL(p_variable,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
39: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
40: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
41: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
42: FND_MSG_PUB.Add;
43: RAISE FND_API.G_EXC_ERROR;
44: END IF;
45: END Check_Reqd_Param_char;
46:

Line 63: FND_MSG_PUB.Add;

59: IF (NVL(p_date,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN
60: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
61: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
62: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
63: FND_MSG_PUB.Add;
64: RAISE FND_API.G_EXC_ERROR;
65: END IF;
66: END Check_Reqd_Param_date;
67:

Line 103: FND_MSG_PUB.Add;

99:
100: IF ( p_stack_err_msg = TRUE ) THEN
101: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_REL_COMB');
102: FND_MESSAGE.SET_TOKEN('PARTY_REL_COMB',to_char(p_instance_id) ||','||p_party_source_table||','||to_char(p_party_id)||','||p_relationship_type||','||to_char(p_contact_ip_id));
103: FND_MSG_PUB.Add;
104: END IF;
105: RETURN l_return_value;
106: EXCEPTION
107: WHEN NO_DATA_FOUND THEN

Line 115: FND_MSG_PUB.Add;

111: l_return_value := TRUE;
112: IF ( p_stack_err_msg = TRUE ) THEN
113: FND_MESSAGE.SET_NAME('CSI','CSI_API_MANY_PTY_REL_COM_EXIST');
114: FND_MESSAGE.SET_TOKEN('PARTY_REL_COMB',to_char(p_instance_id) ||','||p_party_source_table||','|| to_char(p_party_id)||','||p_relationship_type||','|| to_char(p_contact_ip_id));
115: FND_MSG_PUB.Add;
116: END IF;
117: RETURN l_return_value;
118: END Is_Party_Rel_Comb_Exists;
119:

Line 140: FND_MSG_PUB.Add;

136: WHERE instance_party_id = p_Instance_party_id;
137: IF ( p_stack_err_msg = TRUE ) THEN
138: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
139: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_id);
140: FND_MSG_PUB.Add;
141: END IF;
142: RETURN l_return_value;
143: EXCEPTION
144: WHEN NO_DATA_FOUND THEN

Line 175: FND_MSG_PUB.Add;

171: l_return_value := FALSE;
172: IF ( p_stack_err_msg = TRUE ) THEN
173: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');
174: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
175: FND_MSG_PUB.Add;
176: END IF;
177: END IF;
178: CLOSE c1;
179: RETURN l_return_value;

Line 212: FND_MSG_PUB.Add;

208: l_return_value := FALSE;
209: IF ( p_stack_err_msg = TRUE ) THEN
210: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_SOURCE');
211: FND_MESSAGE.SET_TOKEN('PARTY_SOURCE_TABLE',p_party_source_table);
212: FND_MSG_PUB.Add;
213: END IF;
214: END IF;
215: CLOSE c1;
216: RETURN l_return_value;

Line 284: FND_MSG_PUB.Add;

280: l_return_value := FALSE;
281: IF ( p_stack_err_msg = TRUE ) THEN
282: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_SOURCE');
283: FND_MESSAGE.SET_TOKEN('PARTY_SOURCE_TABLE',p_party_source_table );
284: FND_MSG_PUB.Add;
285: END IF;
286: END IF;
287: RETURN l_return_value;
288: EXCEPTION

Line 294: FND_MSG_PUB.Add;

290: l_return_value := FALSE;
291: IF ( p_stack_err_msg = TRUE ) THEN
292: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_ID');
293: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
294: FND_MSG_PUB.Add;
295: END IF;
296: RETURN l_return_value;
297: END Is_Party_Valid;
298:

Line 344: FND_MSG_PUB.Add;

340: l_return_value := FALSE;
341: IF ( p_stack_err_msg = TRUE ) THEN
342: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_PARTY_TYPE_CODE');
343: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE',p_party_rel_type_code);
344: FND_MSG_PUB.Add;
345: END IF;
346: RETURN l_return_value;
347: END Is_Pty_Rel_type_Valid ;
348:

Line 412: FND_MSG_PUB.Add;

408: IF ( p_stack_err_msg = TRUE ) THEN
409: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_CONTACT_INFO');
410: FND_MESSAGE.SET_TOKEN('CONTACT_PARTY_ID',p_contact_party_id);
411: FND_MESSAGE.SET_TOKEN('CONTACT_SOURCE_TABLE',p_contact_source_table);
412: FND_MSG_PUB.Add;
413: END IF;
414: CLOSE C1;
415: RETURN l_return_value;
416: END IF;

Line 429: FND_MSG_PUB.Add;

425: IF ( p_stack_err_msg = TRUE ) THEN
426: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_CONTACT_INFO');
427: FND_MESSAGE.SET_TOKEN('CONTACT_PARTY_ID',p_contact_party_id);
428: FND_MESSAGE.SET_TOKEN('CONTACT_SOURCE_TABLE',p_contact_source_table);
429: FND_MSG_PUB.Add;
430: END IF;
431: CLOSE C2;
432: END IF;
433: ELSE

Line 469: FND_MSG_PUB.Add;

465: IF p_start_date > p_end_date THEN
466: l_return_value := FALSE;
467: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_START_DATE');
468: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);
469: FND_MSG_PUB.Add;
470: RETURN l_return_value;
471: END IF;
472: END IF;
473:

Line 480: FND_MSG_PUB.Add;

476: IF c1%NOTFOUND THEN
477: l_return_value := FALSE;
478: IF ( p_stack_err_msg = TRUE ) THEN
479: FND_MESSAGE.SET_NAME('CSI','CSI_API_INST_STARTDATE_NOT_EXT');
480: FND_MSG_PUB.Add;
481: END IF;
482: CLOSE c1;
483: RETURN l_return_value;
484: END IF;

Line 493: FND_MSG_PUB.Add;

489: l_return_value := FALSE;
490: IF ( p_stack_err_msg = TRUE ) THEN
491: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_START_DATE');
492: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);
493: FND_MSG_PUB.Add;
494: END IF;
495: END IF;
496: RETURN l_return_value;
497: END Is_StartDate_Valid;

Line 530: FND_MSG_PUB.Add;

526: IF p_end_date < sysdate THEN
527: l_return_value := FALSE;
528: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_END_DATE');
529: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
530: FND_MSG_PUB.Add;
531: RETURN l_return_value;
532: END IF;
533: END IF;
534:

Line 545: FND_MSG_PUB.Add;

541: l_return_value := FALSE;
542: IF ( p_stack_err_msg = TRUE ) THEN
543: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_END_DATE');
544: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
545: FND_MSG_PUB.Add;
546: END IF;
547: END IF;
548: END IF;
549: CLOSE c1;

Line 590: FND_MSG_PUB.Add;

586: IF p_end_date < sysdate THEN
587: l_return_value := FALSE;
588: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_END_DATE');
589: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
590: FND_MSG_PUB.Add;
591: RETURN l_return_value;
592: END IF;
593: END IF;
594:

Line 621: FND_MSG_PUB.Add;

617: l_return_value := FALSE;
618: IF ( p_stack_err_msg = TRUE ) THEN
619: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_END_DATE');
620: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
621: FND_MSG_PUB.Add;
622: END IF;
623: END IF;
624: END IF;
625: CLOSE c1;

Line 674: fnd_msg_pub.add;

670: IF l_transaction_date > p_end_date
671: THEN
672: fnd_message.set_name('CSI','CSI_HAS_TXNS');
673: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
674: fnd_msg_pub.add;
675: l_return_value := FALSE;
676: RETURN l_return_value;
677: END IF;
678:

Line 694: fnd_msg_pub.add;

690: IF l_transaction_date > p_end_date
691: THEN
692: fnd_message.set_name('CSI','CSI_HAS_TXNS');
693: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
694: fnd_msg_pub.add;
695: l_return_value := FALSE;
696: RETURN l_return_value;
697: END IF;
698: END IF;

Line 716: fnd_msg_pub.add;

712: IF l_transaction_date > p_end_date
713: THEN
714: fnd_message.set_name('CSI','CSI_HAS_TXNS');
715: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
716: fnd_msg_pub.add;
717: l_return_value := FALSE;
718: RETURN l_return_value;
719: END IF;
720: END IF;

Line 762: FND_MSG_PUB.Add;

758: IF C1%FOUND THEN
759: IF ( p_stack_err_msg = TRUE ) THEN
760: FND_MESSAGE.SET_NAME('CSI','CSI_API_OWNER_ALREADY_EXISTS');
761: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
762: FND_MSG_PUB.Add;
763: END IF;
764: ELSE
765: l_return_value := FALSE;
766: END IF;

Line 865: FND_MSG_PUB.Add;

861: IF ( p_stack_err_msg = TRUE ) THEN
862: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_ACCT_COM');
863: FND_MESSAGE.SET_TOKEN('ACCT_COMBINATION',p_instance_party_id ||', '
864: ||p_party_account_id ||', '||p_relationship_type);
865: FND_MSG_PUB.Add;
866: END IF;
867: RETURN l_return_value;
868: EXCEPTION
869: WHEN NO_DATA_FOUND THEN

Line 895: FND_MSG_PUB.Add;

891: and ((active_end_date is null) OR (active_end_date >= sysdate));
892: IF ( p_stack_err_msg = TRUE ) THEN
893: FND_MESSAGE.SET_NAME('CSI','CSI_API_IP_ACCOUNT_ID');
894: FND_MESSAGE.SET_TOKEN('IP_ACCOUNT_ID',p_ip_account_id);
895: FND_MSG_PUB.Add;
896: END IF;
897: RETURN l_return_value;
898: EXCEPTION
899: WHEN NO_DATA_FOUND THEN

Line 979: FND_MSG_PUB.Add;

975: WHEN NO_DATA_FOUND THEN
976: l_return_value := FALSE;
977: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
978: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_INSTANCE_PARTY_ID);
979: FND_MSG_PUB.Add;
980: END;
981: -- End addition for bug 3550541
982: ELSE
983: l_return_value := FALSE;

Line 987: FND_MSG_PUB.Add;

983: l_return_value := FALSE;
984: IF p_stack_err_msg = TRUE THEN
985: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
986: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_INSTANCE_PARTY_ID);
987: FND_MSG_PUB.Add;
988: END IF;
989: END IF;
990: RETURN l_return_value;
991: END Is_Inst_partyID_Valid;

Line 1056: FND_MSG_PUB.Add;

1052: WHEN NO_DATA_FOUND THEN
1053: l_return_value := FALSE;
1054: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
1055: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_id);
1056: FND_MSG_PUB.Add;
1057: -- Errored, No need to proceed further
1058: RETURN l_return_value;
1059: END;
1060: -- End addition for bug 3550541

Line 1066: FND_MSG_PUB.Add;

1062: l_return_value := FALSE;
1063: IF ( p_stack_err_msg = TRUE ) THEN
1064: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
1065: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_id);
1066: FND_MSG_PUB.Add;
1067: END IF;
1068: CLOSE C3;
1069: -- Errored, No need to proceed further
1070: RETURN l_return_value;

Line 1087: FND_MSG_PUB.Add;

1083: THEN
1084: FND_MESSAGE.SET_NAME('CSI','CSI_API_PTY_ACCT_HZ_PTY');
1085: FND_MESSAGE.SET_TOKEN('PARTY_ACCOUNT_ID',p_party_account_id);
1086: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_id);
1087: FND_MSG_PUB.Add;
1088: END IF;
1089: END IF;
1090: CLOSE c2;
1091: ELSE

Line 1101: FND_MSG_PUB.Add;

1097: IF ( p_stack_err_msg = TRUE )
1098: THEN
1099: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_ACCT_ID');
1100: FND_MESSAGE.SET_TOKEN('PARTY_ACCOUNT_ID',p_party_account_id);
1101: FND_MSG_PUB.Add;
1102: END IF;
1103: END IF;
1104: CLOSE c1;
1105: END IF;

Line 1138: FND_MSG_PUB.Add;

1134: l_return_value := FALSE;
1135: IF ( p_stack_err_msg = TRUE ) THEN
1136: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ACCOUNT_TYPE');
1137: FND_MESSAGE.SET_TOKEN('IP_RELATIONSHIP_TYPE_CODE',p_acct_rel_type_code);
1138: FND_MSG_PUB.Add;
1139: END IF;
1140: END IF;
1141: CLOSE c1;
1142: RETURN l_return_value;

Line 1173: FND_MSG_PUB.Add;

1169: IF p_start_date > p_end_date THEN
1170: l_return_value := FALSE;
1171: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_START_DATE');
1172: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);
1173: FND_MSG_PUB.Add;
1174: RETURN l_return_value;
1175: END IF;
1176: END IF;
1177:

Line 1185: FND_MSG_PUB.Add;

1181: l_return_value := FALSE;
1182: IF ( p_stack_err_msg = TRUE ) THEN
1183: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_PTY_START_DATE');
1184: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);
1185: FND_MSG_PUB.Add;
1186: END IF;
1187: CLOSE c1;
1188: RETURN l_return_value;
1189: END IF;

Line 1200: FND_MSG_PUB.Add;

1196: l_return_value := FALSE;
1197: IF ( p_stack_err_msg = TRUE ) THEN
1198: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_START_DATE');
1199: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);
1200: FND_MSG_PUB.Add;
1201: END IF;
1202: END IF;
1203: RETURN l_return_value;
1204:

Line 1236: FND_MSG_PUB.Add;

1232: IF p_end_date < sysdate THEN
1233: l_return_value := FALSE;
1234: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_END_DATE');
1235: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
1236: FND_MSG_PUB.Add;
1237: RETURN l_return_value;
1238: END IF;
1239: END IF;
1240:

Line 1250: FND_MSG_PUB.Add;

1246: l_return_value := FALSE;
1247: IF ( p_stack_err_msg = TRUE ) THEN
1248: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_END_DATE');
1249: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
1250: FND_MSG_PUB.Add;
1251: END IF;
1252: END IF;
1253: END IF;
1254: CLOSE c1;

Line 1295: FND_MSG_PUB.Add;

1291: THEN
1292: l_return_value := FALSE;
1293: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_END_DATE');
1294: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
1295: FND_MSG_PUB.Add;
1296: l_return_value := FALSE;
1297: RETURN l_return_value;
1298: END IF;
1299: END IF;

Line 1317: fnd_msg_pub.add;

1313: IF l_transaction_date > p_end_date
1314: THEN
1315: fnd_message.set_name('CSI','CSI_HAS_TXNS');
1316: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
1317: fnd_msg_pub.add;
1318: l_return_value := FALSE;
1319: RETURN l_return_value;
1320: END IF;
1321: END IF;

Line 1334: FND_MSG_PUB.Add;

1330: l_return_value := FALSE;
1331: IF ( p_stack_err_msg = TRUE ) THEN
1332: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_END_DATE');
1333: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
1334: FND_MSG_PUB.Add;
1335: END IF;
1336: END IF;
1337: END IF;
1338: CLOSE c1;

Line 1409: FND_MSG_PUB.Add;

1405: l_return_value := FALSE;
1406: IF ( p_stack_err_msg = TRUE ) THEN
1407: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_INST_START_DATE');
1408: FND_MESSAGE.SET_TOKEN('ENTITY','VERSION LABEL');
1409: FND_MSG_PUB.Add;
1410: END IF;
1411: CLOSE c1;
1412: RETURN l_return_value;
1413: END IF;

Line 1420: FND_MSG_PUB.Add;

1416: ( p_datetimestamp > l_instance_end_date)) THEN
1417: l_return_value := FALSE;
1418: IF ( p_stack_err_msg = TRUE ) THEN
1419: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_TIMESTAMP');
1420: FND_MSG_PUB.Add;
1421: END IF;
1422: END IF;
1423: RETURN l_return_value;
1424:

Line 1467: FND_MSG_PUB.Add;

1463: and ((active_end_date is null) OR (active_end_date >= sysdate));
1464: IF ( p_stack_err_msg = TRUE ) THEN
1465: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_VER_LABEL_ID');
1466: FND_MESSAGE.SET_TOKEN('VERSION_LABEL_ID',p_version_label_id);
1467: FND_MSG_PUB.Add;
1468: END IF;
1469: RETURN l_return_value;
1470: EXCEPTION
1471: WHEN NO_DATA_FOUND THEN

Line 1538: FND_MSG_PUB.Add;

1534:
1535: IF ( p_stack_err_msg = TRUE ) THEN
1536: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_INST_ASSET_ID');
1537: FND_MESSAGE.SET_TOKEN('INSTANCE_ASSET_ID',p_instance_asset_id);
1538: FND_MSG_PUB.Add;
1539: END IF;
1540: RETURN l_return_value;
1541: EXCEPTION
1542: WHEN NO_DATA_FOUND THEN

Line 1577: FND_MSG_PUB.Add;

1573: l_return_value := FALSE;
1574: IF ( p_stack_err_msg = TRUE ) THEN
1575: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_UPDATE_STATUS');
1576: FND_MESSAGE.SET_TOKEN('UPDATE_STATUS',p_update_status);
1577: FND_MSG_PUB.Add;
1578: END IF;
1579: END IF;
1580: CLOSE c1;
1581: RETURN l_return_value;

Line 1602: FND_MSG_PUB.Add;

1598: IF (NVL(p_asset_quantity,-1) <= 0 ) THEN
1599: l_return_status := FALSE;
1600: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ASSET_QTY');
1601: FND_MESSAGE.SET_TOKEN('QUANTITY',p_asset_quantity);
1602: FND_MSG_PUB.Add;
1603: END IF;
1604:
1605: RETURN l_return_status;
1606:

Line 1655: FND_MSG_PUB.Add;

1651: l_return_value := FALSE;
1652: IF ( p_stack_err_msg = TRUE ) THEN
1653: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_COMB');
1654: FND_MESSAGE.SET_TOKEN('ASSET_COMBINATION',p_asset_id||'-'||p_book_type_code);
1655: FND_MSG_PUB.Add;
1656: END IF;
1657: RETURN l_return_value;
1658: END Is_Asset_Comb_Valid;
1659:

Line 1687: FND_MSG_PUB.Add;

1683: l_return_value := FALSE;
1684: IF ( p_stack_err_msg = TRUE ) THEN
1685: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_LOCATION');
1686: FND_MESSAGE.SET_TOKEN('ASSET_LOCATION_ID',p_location_id);
1687: FND_MSG_PUB.Add;
1688: END IF;
1689: RETURN l_return_value;
1690: END Is_Asset_Location_Valid;
1691:

Line 1768: FND_MSG_PUB.Add;

1764: l_return_value := FALSE;
1765: IF ( p_stack_err_msg = TRUE ) THEN
1766: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_BILL_TO_ADD_ID');
1767: FND_MESSAGE.SET_TOKEN('BILL_TO_ADD_ID',p_bill_to_add_id );
1768: FND_MSG_PUB.Add;
1769: END IF;
1770: RETURN l_return_value;
1771:
1772: END Is_bill_to_add_valid;

Line 1800: FND_MSG_PUB.Add;

1796: l_return_value := FALSE;
1797: IF ( p_stack_err_msg = TRUE ) THEN
1798: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_SHIP_TO_ADD_ID');
1799: FND_MESSAGE.SET_TOKEN('SHIP_TO_ADD_ID',p_ship_to_add_id );
1800: FND_MSG_PUB.Add;
1801: END IF;
1802: RETURN l_return_value;
1803:
1804: END Is_ship_to_add_valid;

Line 1835: FND_MSG_PUB.Add;

1831: and ((active_end_date is null) OR (active_end_date > sysdate));
1832: IF ( p_stack_err_msg = TRUE ) THEN
1833: FND_MESSAGE.SET_NAME('CSI','CSI_API_DUP_ACCT_TYPE');
1834: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE',p_relationship_type);
1835: FND_MSG_PUB.Add;
1836: END IF;
1837:
1838: -- Vaidate if owner accounts are created, the party is also an owner
1839: l_party_relation := CSI_Instance_parties_vld_pvt.Get_Party_relation

Line 1846: FND_MSG_PUB.Add;

1842: IF ((p_relationship_type = 'OWNER')
1843: AND (l_party_relation <> 'OWNER')) THEN
1844: IF ( p_stack_err_msg = TRUE ) THEN
1845: FND_MESSAGE.SET_NAME('CSI','CSI_OWNER_ACCT_REQ_OWNER_PTY');
1846: FND_MSG_PUB.Add;
1847: END IF;
1848: END IF;
1849: RETURN l_return_value;
1850: EXCEPTION

Line 1880: FND_MSG_PUB.Add;

1876:
1877: l_return_value := FALSE;
1878: IF ( p_stack_err_msg = TRUE ) THEN
1879: FND_MESSAGE.SET_NAME('CSI','CSI_API_PTY_CONTACT_EXISTS');
1880: FND_MSG_PUB.Add;
1881: END IF;
1882: RETURN l_return_value;
1883: EXCEPTION
1884: WHEN NO_DATA_FOUND THEN

Line 1891: FND_MSG_PUB.Add;

1887: WHEN TOO_MANY_ROWS THEN
1888: l_return_value := FALSE;
1889: IF ( p_stack_err_msg = TRUE ) THEN
1890: FND_MESSAGE.SET_NAME('CSI','CSI_API_PTY_CONTACT_EXISTS');
1891: FND_MSG_PUB.Add;
1892: END IF;
1893: RETURN l_return_value;
1894: END Is_Party_Contact_Exists;
1895:

Line 1919: FND_MSG_PUB.Add;

1915: WHEN NO_DATA_FOUND THEN
1916: IF ( p_stack_err_msg = TRUE ) THEN
1917: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
1918: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_id);
1919: FND_MSG_PUB.Add;
1920: END IF;
1921: RETURN NULL;
1922: END Get_Party_relation;
1923:

Line 2003: FND_MSG_PUB.Add;

1999: WHEN NO_DATA_FOUND THEN
2000: IF ( p_stack_err_msg = TRUE ) THEN
2001: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
2002: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_id);
2003: FND_MSG_PUB.Add;
2004: END IF;
2005: RETURN FALSE;
2006: END Get_Party_Record;
2007:

Line 2254: FND_MSG_PUB.initialize;

2250: END IF;
2251:
2252: -- Initialize message list if p_init_msg_list is set to TRUE.
2253: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2254: FND_MSG_PUB.initialize;
2255: END IF;
2256:
2257: -- Initialize API return status to success
2258: -- Verify if the Party rel combination exists

Line 2310: x_msg_data := FND_MSG_PUB.GET(

2306: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2307: l_msg_index := 1;
2308: l_msg_count := x_msg_count;
2309: WHILE l_msg_count > 0 LOOP
2310: x_msg_data := FND_MSG_PUB.GET(
2311: l_msg_index,
2312: FND_API.G_FALSE);
2313: csi_gen_utility_pvt.put_line( 'message data = Error from csi_party_relationships_pvt.expire_inst_party_account');
2314: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);

Line 2348: FND_MSG_PUB.Count_And_Get

2344: END IF;
2345:
2346:
2347: -- Standard call to get message count and if count is get message info.
2348: FND_MSG_PUB.Count_And_Get
2349: (p_count => x_msg_count ,
2350: p_data => x_msg_data );
2351:
2352: EXCEPTION

Line 2356: FND_MSG_PUB.Count_And_Get

2352: EXCEPTION
2353: WHEN FND_API.G_EXC_ERROR THEN
2354: -- ROLLBACK TO Transfer_Party_Rules;
2355: x_return_status := FND_API.G_RET_STS_ERROR ;
2356: FND_MSG_PUB.Count_And_Get
2357: ( p_count => x_msg_count,
2358: p_data => x_msg_data );
2359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2360: -- ROLLBACK TO Transfer_Party_Rules;

Line 2362: FND_MSG_PUB.Count_And_Get

2358: p_data => x_msg_data );
2359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2360: -- ROLLBACK TO Transfer_Party_Rules;
2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2362: FND_MSG_PUB.Count_And_Get
2363: ( p_count => x_msg_count,
2364: p_data => x_msg_data );
2365: WHEN OTHERS THEN
2366: -- ROLLBACK TO Transfer_Party_Rules;

Line 2368: IF FND_MSG_PUB.Check_Msg_Level

2364: p_data => x_msg_data );
2365: WHEN OTHERS THEN
2366: -- ROLLBACK TO Transfer_Party_Rules;
2367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2368: IF FND_MSG_PUB.Check_Msg_Level
2369: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2370: THEN
2371: FND_MSG_PUB.Add_Exc_Msg
2372: ( g_pkg_name, l_api_name );

Line 2369: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2365: WHEN OTHERS THEN
2366: -- ROLLBACK TO Transfer_Party_Rules;
2367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2368: IF FND_MSG_PUB.Check_Msg_Level
2369: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2370: THEN
2371: FND_MSG_PUB.Add_Exc_Msg
2372: ( g_pkg_name, l_api_name );
2373: END IF;

Line 2371: FND_MSG_PUB.Add_Exc_Msg

2367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2368: IF FND_MSG_PUB.Check_Msg_Level
2369: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2370: THEN
2371: FND_MSG_PUB.Add_Exc_Msg
2372: ( g_pkg_name, l_api_name );
2373: END IF;
2374: FND_MSG_PUB.Count_And_Get
2375: ( p_count => x_msg_count,

Line 2374: FND_MSG_PUB.Count_And_Get

2370: THEN
2371: FND_MSG_PUB.Add_Exc_Msg
2372: ( g_pkg_name, l_api_name );
2373: END IF;
2374: FND_MSG_PUB.Count_And_Get
2375: ( p_count => x_msg_count,
2376: p_data => x_msg_data );
2377:
2378: END Transfer_Party_Rules;

Line 2414: FND_MSG_PUB.Add;

2410: IF ( p_stack_err_msg = TRUE ) THEN
2411: FND_MESSAGE.SET_NAME('CSI','CSI_API_PREFERRED_PTY_EXISTS');
2412: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
2413: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',p_relationship_type);
2414: FND_MSG_PUB.Add;
2415: END IF;
2416: ELSE
2417: l_return_value := FALSE;
2418: END IF;

Line 2466: FND_MSG_PUB.Add;

2462: IF ( p_stack_err_msg = TRUE ) THEN
2463: FND_MESSAGE.SET_NAME('CSI','CSI_API_PRIMARY_PTY_EXISTS');
2464: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
2465: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',p_relationship_type);
2466: FND_MSG_PUB.Add;
2467: END IF;
2468: ELSE
2469: l_return_value := FALSE;
2470: END IF;

Line 2514: FND_MSG_PUB.Add;

2510: IF ( p_stack_err_msg = TRUE ) THEN
2511: FND_MESSAGE.SET_NAME('CSI','CSI_API_PREFERRED_PTY_EXISTS');
2512: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
2513: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',p_relationship_type);
2514: FND_MSG_PUB.Add;
2515: END IF;
2516: ELSE
2517: l_return_value := FALSE;
2518: END IF;

Line 2564: FND_MSG_PUB.Add;

2560: IF ( p_stack_err_msg = TRUE ) THEN
2561: FND_MESSAGE.SET_NAME('CSI','CSI_API_PRIMARY_PTY_EXISTS');
2562: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
2563: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',p_relationship_type);
2564: FND_MSG_PUB.Add;
2565: END IF;
2566: ELSE
2567: l_return_value := FALSE;
2568: END IF;