DBA Data[Home] [Help]

APPS.CN_PROCESS_TAE_TRX_PUB dependencies on FND_API

Line 45: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

41: *-------------------------------------------------------------------------*/
42:
43: PROCEDURE Process_Trx_Records(
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
46: p_commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
48:
49: x_return_status OUT NOCOPY VARCHAR2,

Line 46: p_commit IN VARCHAR2 := FND_API.G_FALSE,

42:
43: PROCEDURE Process_Trx_Records(
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
46: p_commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
48:
49: x_return_status OUT NOCOPY VARCHAR2,
50: x_msg_count OUT NOCOPY NUMBER,

Line 47: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

43: PROCEDURE Process_Trx_Records(
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
46: p_commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
48:
49: x_return_status OUT NOCOPY VARCHAR2,
50: x_msg_count OUT NOCOPY NUMBER,
51: x_msg_data OUT NOCOPY VARCHAR2,

Line 93: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

89: -- Standard Start of API savepoint
90: SAVEPOINT process_trx_records;
91:
92: -- Standard call to check for call compatibility.
93: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
94: p_api_version ,
95: l_api_name,
96: G_PKG_NAME ) THEN
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

93: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
94: p_api_version ,
95: l_api_name,
96: G_PKG_NAME ) THEN
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: END IF;
99:
100: -- Initialize message list if p_init_msg_list is set to TRUE.
101: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 101: IF FND_API.to_Boolean( p_init_msg_list ) THEN

97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: END IF;
99:
100: -- Initialize message list if p_init_msg_list is set to TRUE.
101: IF FND_API.to_Boolean( p_init_msg_list ) THEN
102: FND_MSG_PUB.initialize;
103: END IF;
104:
105: -- Initialize API return status to success

Line 106: x_return_status := FND_API.G_RET_STS_SUCCESS;

102: FND_MSG_PUB.initialize;
103: END IF;
104:
105: -- Initialize API return status to success
106: x_return_status := FND_API.G_RET_STS_SUCCESS;
107:
108:
109: l_attempts := 1;
110: l_exceptions := FALSE;

Line 530: WHEN FND_API.G_EXC_ERROR THEN

526:
527: --dbms_output.put_line('After the UPDATE statement ');
528:
529: EXCEPTION
530: WHEN FND_API.G_EXC_ERROR THEN
531: ROLLBACK TO process_trx_records;
532: x_return_status := FND_API.G_RET_STS_ERROR ;
533: FND_MSG_PUB.Count_And_Get(
534: p_count => x_msg_count ,

Line 532: x_return_status := FND_API.G_RET_STS_ERROR ;

528:
529: EXCEPTION
530: WHEN FND_API.G_EXC_ERROR THEN
531: ROLLBACK TO process_trx_records;
532: x_return_status := FND_API.G_RET_STS_ERROR ;
533: FND_MSG_PUB.Count_And_Get(
534: p_count => x_msg_count ,
535: p_data => x_msg_data ,
536: p_encoded => FND_API.G_FALSE);

Line 536: p_encoded => FND_API.G_FALSE);

532: x_return_status := FND_API.G_RET_STS_ERROR ;
533: FND_MSG_PUB.Count_And_Get(
534: p_count => x_msg_count ,
535: p_data => x_msg_data ,
536: p_encoded => FND_API.G_FALSE);
537:
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: ROLLBACK TO process_trx_records;
540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

534: p_count => x_msg_count ,
535: p_data => x_msg_data ,
536: p_encoded => FND_API.G_FALSE);
537:
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: ROLLBACK TO process_trx_records;
540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
541: FND_MSG_PUB.Count_And_Get(
542: p_count => x_msg_count ,

Line 540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

536: p_encoded => FND_API.G_FALSE);
537:
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: ROLLBACK TO process_trx_records;
540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
541: FND_MSG_PUB.Count_And_Get(
542: p_count => x_msg_count ,
543: p_data => x_msg_data ,
544: p_encoded => FND_API.G_FALSE);

Line 544: p_encoded => FND_API.G_FALSE);

540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
541: FND_MSG_PUB.Count_And_Get(
542: p_count => x_msg_count ,
543: p_data => x_msg_data ,
544: p_encoded => FND_API.G_FALSE);
545:
546: WHEN OTHERS THEN
547: ROLLBACK TO process_trx_records;
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

544: p_encoded => FND_API.G_FALSE);
545:
546: WHEN OTHERS THEN
547: ROLLBACK TO process_trx_records;
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
549: IF FND_MSG_PUB.Check_Msg_Level(
550: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
551: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
552: END IF;

Line 556: p_encoded => FND_API.G_FALSE);

552: END IF;
553: FND_MSG_PUB.Count_And_Get(
554: p_count => x_msg_count ,
555: p_data => x_msg_data ,
556: p_encoded => FND_API.G_FALSE);
557:
558: END Process_Trx_Records;
559:
560: END CN_PROCESS_TAE_TRX_PUB;