229: p_object_version_number = l_object_version_number
230: )
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;
230: )
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;
240:
241: EXCEPTION
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;
240:
241: EXCEPTION
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;
241: EXCEPTION
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:
460: p_object_version_number = l_object_version_number
461: )
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;
461: )
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;
471:
472: EXCEPTION
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;
471:
472: EXCEPTION
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;
472: EXCEPTION
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:
684:
685: WHEN OTHERS THEN
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,
685: WHEN OTHERS THEN
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,
844: WHEN OTHERS THEN
845: ROLLBACK TO update_financial_report;
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,
845: ROLLBACK TO update_financial_report;
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,
909:
910: --Check whether primary key has been passed in.
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;
910: --Check whether primary key has been passed in.
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:
974:
975: WHEN OTHERS THEN
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(
975: WHEN OTHERS THEN
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,
1111:
1112: WHEN OTHERS THEN
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,
1112: WHEN OTHERS THEN
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,
1256:
1257: WHEN OTHERS THEN
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,
1257: WHEN OTHERS THEN
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,
1321:
1322: --Check whether primary key has been passed in.
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;
1322: --Check whether primary key has been passed in.
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:
1369:
1370: WHEN OTHERS THEN
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(
1370: WHEN OTHERS THEN
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,