DBA Data[Home] [Help]

APPS.HZ_ORGANIZATION_INFO_V2PUB dependencies on FND_MSG_PUB

Line 235: FND_MSG_PUB.ADD;

231: )
232: THEN
233: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
234: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_FINANCIAL_REPORTS');
235: FND_MSG_PUB.ADD;
236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238:
239: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 246: FND_MSG_PUB.ADD;

242: WHEN NO_DATA_FOUND THEN
243: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
244: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_FINANCIAL_REPORTS');
245: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_financial_report_rec.financial_report_id ), 'null' ) );
246: FND_MSG_PUB.ADD;
247: RAISE FND_API.G_EXC_ERROR;
248: END;
249:
250: -- validate financial report record

Line 466: FND_MSG_PUB.ADD;

462: )
463: THEN
464: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
465: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_FINANCIAL_NUMBERS');
466: FND_MSG_PUB.ADD;
467: RAISE FND_API.G_EXC_ERROR;
468: END IF;
469:
470: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 477: FND_MSG_PUB.ADD;

473: WHEN NO_DATA_FOUND THEN
474: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
475: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_FINANCIAL_NUMBERS');
476: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_financial_number_rec.financial_number_id ), 'null' ) );
477: FND_MSG_PUB.ADD;
478: RAISE FND_API.G_EXC_ERROR;
479: END;
480:
481: -- validate financial number record

Line 598: FND_MSG_PUB.initialize;

594: SAVEPOINT create_financial_report;
595:
596: --Initialize message list if p_init_msg_list is set to TRUE.
597: IF FND_API.to_Boolean(p_init_msg_list) THEN
598: FND_MSG_PUB.initialize;
599: END IF;
600:
601: --Initialize API return status to success.
602: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 663: FND_MSG_PUB.Count_And_Get(

659: END IF;
660: END IF;
661:
662: --Standard call to get message count and if count is 1, get message info.
663: FND_MSG_PUB.Count_And_Get(
664: p_encoded => FND_API.G_FALSE,
665: p_count => x_msg_count,
666: p_data => x_msg_data);
667:

Line 672: FND_MSG_PUB.Count_And_Get(

668: EXCEPTION
669: WHEN FND_API.G_EXC_ERROR THEN
670: ROLLBACK TO create_financial_report;
671: x_return_status := FND_API.G_RET_STS_ERROR;
672: FND_MSG_PUB.Count_And_Get(
673: p_encoded => FND_API.G_FALSE,
674: p_count => x_msg_count,
675: p_data => x_msg_data);
676:

Line 680: FND_MSG_PUB.Count_And_Get(

676:
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
678: ROLLBACK TO create_financial_report;
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: FND_MSG_PUB.Count_And_Get(
681: p_encoded => FND_API.G_FALSE,
682: p_count => x_msg_count,
683: p_data => x_msg_data);
684:

Line 690: FND_MSG_PUB.ADD;

686: ROLLBACK TO create_financial_report;
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
688: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
689: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
690: FND_MSG_PUB.ADD;
691: FND_MSG_PUB.Count_And_Get(
692: p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,
694: p_data => x_msg_data);

Line 691: FND_MSG_PUB.Count_And_Get(

687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
688: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
689: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
690: FND_MSG_PUB.ADD;
691: FND_MSG_PUB.Count_And_Get(
692: p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,
694: p_data => x_msg_data);
695:

Line 753: FND_MSG_PUB.initialize;

749: SAVEPOINT update_financial_report;
750:
751: --Initialize message list if p_init_msg_list is set to TRUE.
752: IF FND_API.to_Boolean(p_init_msg_list) THEN
753: FND_MSG_PUB.initialize;
754: END IF;
755:
756: --Initialize API return status to success.
757: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 820: FND_MSG_PUB.Count_And_Get(

816: END IF;
817:
818: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
819: --Standard call to get message count and if count is 1, get message info.
820: FND_MSG_PUB.Count_And_Get(
821: p_encoded => FND_API.G_FALSE,
822: p_count => x_msg_count,
823: p_data => x_msg_data);
824:

Line 830: FND_MSG_PUB.Count_And_Get(

826: WHEN FND_API.G_EXC_ERROR THEN
827: ROLLBACK TO update_financial_report;
828: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
829: x_return_status := FND_API.G_RET_STS_ERROR;
830: FND_MSG_PUB.Count_And_Get(
831: p_encoded => FND_API.G_FALSE,
832: p_count => x_msg_count,
833: p_data => x_msg_data);
834:

Line 839: FND_MSG_PUB.Count_And_Get(

835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
836: ROLLBACK TO update_financial_report;
837: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: FND_MSG_PUB.Count_And_Get(
840: p_encoded => FND_API.G_FALSE,
841: p_count => x_msg_count,
842: p_data => x_msg_data);
843:

Line 850: FND_MSG_PUB.ADD;

846: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
848: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
849: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
850: FND_MSG_PUB.ADD;
851: FND_MSG_PUB.Count_And_Get(
852: p_encoded => FND_API.G_FALSE,
853: p_count => x_msg_count,
854: p_data => x_msg_data);

Line 851: FND_MSG_PUB.Count_And_Get(

847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
848: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
849: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
850: FND_MSG_PUB.ADD;
851: FND_MSG_PUB.Count_And_Get(
852: p_encoded => FND_API.G_FALSE,
853: p_count => x_msg_count,
854: p_data => x_msg_data);
855:

Line 904: FND_MSG_PUB.initialize;

900: BEGIN
901:
902: --Initialize message list if p_init_msg_list is set to TRUE.
903: IF FND_API.to_Boolean(p_init_msg_list) THEN
904: FND_MSG_PUB.initialize;
905: END IF;
906:
907: --Initialize API return status to success.
908: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 915: FND_MSG_PUB.ADD;

911: IF p_financial_report_id IS NULL OR
912: p_financial_report_id = FND_API.G_MISS_NUM THEN
913: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
914: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'financial_report_id' );
915: FND_MSG_PUB.ADD;
916: RAISE FND_API.G_EXC_ERROR;
917: END IF;
918:
919: -- The p_financial_report_rec.financial_report_id must be initiated to p_financial_report_id

Line 954: FND_MSG_PUB.Count_And_Get(

950: x_created_by_module => p_financial_report_rec.created_by_module
951: );
952:
953: --Standard call to get message count and if count is 1, get message info.
954: FND_MSG_PUB.Count_And_Get(
955: p_encoded => FND_API.G_FALSE,
956: p_count => x_msg_count,
957: p_data => x_msg_data );
958:

Line 963: FND_MSG_PUB.Count_And_Get(

959: EXCEPTION
960: WHEN FND_API.G_EXC_ERROR THEN
961: x_return_status := FND_API.G_RET_STS_ERROR;
962:
963: FND_MSG_PUB.Count_And_Get(
964: p_encoded => FND_API.G_FALSE,
965: p_count => x_msg_count,
966: p_data => x_msg_data );
967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 970: FND_MSG_PUB.Count_And_Get(

966: p_data => x_msg_data );
967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
969:
970: FND_MSG_PUB.Count_And_Get(
971: p_encoded => FND_API.G_FALSE,
972: p_count => x_msg_count,
973: p_data => x_msg_data );
974:

Line 980: FND_MSG_PUB.ADD;

976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
977:
978: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
979: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
980: FND_MSG_PUB.ADD;
981:
982: FND_MSG_PUB.Count_And_Get(
983: p_encoded => FND_API.G_FALSE,
984: p_count => x_msg_count,

Line 982: FND_MSG_PUB.Count_And_Get(

978: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
979: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
980: FND_MSG_PUB.ADD;
981:
982: FND_MSG_PUB.Count_And_Get(
983: p_encoded => FND_API.G_FALSE,
984: p_count => x_msg_count,
985: p_data => x_msg_data );
986:

Line 1043: FND_MSG_PUB.initialize;

1039: SAVEPOINT create_financial_number;
1040:
1041: --Initialize message list if p_init_msg_list is set to TRUE.
1042: IF FND_API.to_Boolean(p_init_msg_list) THEN
1043: FND_MSG_PUB.initialize;
1044: END IF;
1045:
1046: --Initialize API return status to success.
1047: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1090: FND_MSG_PUB.Count_And_Get(

1086: END IF;
1087: END IF;
1088:
1089: --Standard call to get message count and if count is 1, get message info.
1090: FND_MSG_PUB.Count_And_Get(
1091: p_encoded => FND_API.G_FALSE,
1092: p_count => x_msg_count,
1093: p_data => x_msg_data);
1094:

Line 1099: FND_MSG_PUB.Count_And_Get(

1095: EXCEPTION
1096: WHEN FND_API.G_EXC_ERROR THEN
1097: ROLLBACK TO create_financial_number;
1098: x_return_status := FND_API.G_RET_STS_ERROR;
1099: FND_MSG_PUB.Count_And_Get(
1100: p_encoded => FND_API.G_FALSE,
1101: p_count => x_msg_count,
1102: p_data => x_msg_data);
1103:

Line 1107: FND_MSG_PUB.Count_And_Get(

1103:
1104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1105: ROLLBACK TO create_financial_number;
1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1107: FND_MSG_PUB.Count_And_Get(
1108: p_encoded => FND_API.G_FALSE,
1109: p_count => x_msg_count,
1110: p_data => x_msg_data);
1111:

Line 1117: FND_MSG_PUB.ADD;

1113: ROLLBACK TO create_financial_number;
1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1116: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1117: FND_MSG_PUB.ADD;
1118: FND_MSG_PUB.Count_And_Get(
1119: p_encoded => FND_API.G_FALSE,
1120: p_count => x_msg_count,
1121: p_data => x_msg_data);

Line 1118: FND_MSG_PUB.Count_And_Get(

1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1116: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1117: FND_MSG_PUB.ADD;
1118: FND_MSG_PUB.Count_And_Get(
1119: p_encoded => FND_API.G_FALSE,
1120: p_count => x_msg_count,
1121: p_data => x_msg_data);
1122:

Line 1180: FND_MSG_PUB.initialize;

1176: SAVEPOINT update_financial_number;
1177:
1178: --Initialize message list if p_init_msg_list is set to TRUE.
1179: IF FND_API.to_Boolean(p_init_msg_list) THEN
1180: FND_MSG_PUB.initialize;
1181: END IF;
1182:
1183: --Initialize API return status to success.
1184: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1235: FND_MSG_PUB.Count_And_Get(

1231: END IF;
1232: END IF;
1233:
1234: --Standard call to get message count and if count is 1, get message info.
1235: FND_MSG_PUB.Count_And_Get(
1236: p_encoded => FND_API.G_FALSE,
1237: p_count => x_msg_count,
1238: p_data => x_msg_data);
1239:

Line 1244: FND_MSG_PUB.Count_And_Get(

1240: EXCEPTION
1241: WHEN FND_API.G_EXC_ERROR THEN
1242: ROLLBACK TO update_financial_number;
1243: x_return_status := FND_API.G_RET_STS_ERROR;
1244: FND_MSG_PUB.Count_And_Get(
1245: p_encoded => FND_API.G_FALSE,
1246: p_count => x_msg_count,
1247: p_data => x_msg_data);
1248:

Line 1252: FND_MSG_PUB.Count_And_Get(

1248:
1249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1250: ROLLBACK TO update_financial_number;
1251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1252: FND_MSG_PUB.Count_And_Get(
1253: p_encoded => FND_API.G_FALSE,
1254: p_count => x_msg_count,
1255: p_data => x_msg_data);
1256:

Line 1262: FND_MSG_PUB.ADD;

1258: ROLLBACK TO update_financial_number;
1259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1260: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1261: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1262: FND_MSG_PUB.ADD;
1263: FND_MSG_PUB.Count_And_Get(
1264: p_encoded => FND_API.G_FALSE,
1265: p_count => x_msg_count,
1266: p_data => x_msg_data);

Line 1263: FND_MSG_PUB.Count_And_Get(

1259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1260: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1261: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1262: FND_MSG_PUB.ADD;
1263: FND_MSG_PUB.Count_And_Get(
1264: p_encoded => FND_API.G_FALSE,
1265: p_count => x_msg_count,
1266: p_data => x_msg_data);
1267:

Line 1316: FND_MSG_PUB.initialize;

1312: BEGIN
1313:
1314: --Initialize message list if p_init_msg_list is set to TRUE.
1315: IF FND_API.to_Boolean(p_init_msg_list) THEN
1316: FND_MSG_PUB.initialize;
1317: END IF;
1318:
1319: --Initialize API return status to success.
1320: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1327: FND_MSG_PUB.ADD;

1323: IF p_financial_number_id IS NULL OR
1324: p_financial_number_id = FND_API.G_MISS_NUM THEN
1325: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1326: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'financial_number_id' );
1327: FND_MSG_PUB.ADD;
1328: RAISE FND_API.G_EXC_ERROR;
1329: END IF;
1330:
1331: -- The p_financial_number_rec.financial_number_id must be initiated to p_financial_number_id

Line 1349: FND_MSG_PUB.Count_And_Get(

1345:
1346: );
1347:
1348: --Standard call to get message count and if count is 1, get message info.
1349: FND_MSG_PUB.Count_And_Get(
1350: p_encoded => FND_API.G_FALSE,
1351: p_count => x_msg_count,
1352: p_data => x_msg_data );
1353:

Line 1358: FND_MSG_PUB.Count_And_Get(

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

Line 1365: FND_MSG_PUB.Count_And_Get(

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

Line 1375: FND_MSG_PUB.ADD;

1371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1372:
1373: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1374: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1375: FND_MSG_PUB.ADD;
1376:
1377: FND_MSG_PUB.Count_And_Get(
1378: p_encoded => FND_API.G_FALSE,
1379: p_count => x_msg_count,

Line 1377: FND_MSG_PUB.Count_And_Get(

1373: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1374: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1375: FND_MSG_PUB.ADD;
1376:
1377: FND_MSG_PUB.Count_And_Get(
1378: p_encoded => FND_API.G_FALSE,
1379: p_count => x_msg_count,
1380: p_data => x_msg_data );
1381: