DBA Data[Home] [Help]

APPS.HZ_ORGANIZATION_INFO_V2PUB dependencies on FND_MESSAGE

Line 233: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

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;

Line 234: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_FINANCIAL_REPORTS');

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:

Line 243: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

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;

Line 244: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_FINANCIAL_REPORTS');

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;

Line 245: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_financial_report_rec.financial_report_id ), 'null' ) );

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:

Line 464: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

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;

Line 465: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_FINANCIAL_NUMBERS');

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:

Line 474: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

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;

Line 475: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_FINANCIAL_NUMBERS');

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;

Line 476: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_financial_number_rec.financial_number_id ), 'null' ) );

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:

Line 688: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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,

Line 689: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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,

Line 848: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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,

Line 849: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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,

Line 913: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

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;

Line 914: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'financial_report_id' );

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:

Line 978: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

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(

Line 979: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

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,

Line 1115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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,

Line 1116: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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,

Line 1260: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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,

Line 1261: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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,

Line 1325: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

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;

Line 1326: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'financial_number_id' );

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:

Line 1373: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

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(

Line 1374: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

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,