APPS.CCT_IH_PUB dependencies on FND_API

Line 34: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

30: BEGIN
31: -- Standard Start of API savepoint
32: SAVEPOINT OPEN_MEDIA_ITEM_PUB;
33: -- Standard call to check for call compatibility.
34: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
35: p_api_version ,
36: l_api_name ,
37: G_PKG_NAME )
38: THEN

Line 39: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

35: p_api_version ,
36: l_api_name ,
37: G_PKG_NAME )
38: THEN
39: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
40: END IF;
41: -- Initialize message list if p_init_msg_list is set to TRUE.
42: IF FND_API.To_Boolean( p_init_msg_list ) THEN
43: FND_MSG_PUB.initialize;

Line 42: IF FND_API.To_Boolean( p_init_msg_list ) THEN

38: THEN
39: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
40: END IF;
41: -- Initialize message list if p_init_msg_list is set to TRUE.
42: IF FND_API.To_Boolean( p_init_msg_list ) THEN
43: FND_MSG_PUB.initialize;
44: END IF;
45:
46: -- Initialize API return status to success

Line 47: x_return_status := FND_API.G_RET_STS_SUCCESS;

43: FND_MSG_PUB.initialize;
44: END IF;
45:
46: -- Initialize API return status to success
47: x_return_status := FND_API.G_RET_STS_SUCCESS;
48: x_msg_count := 0;
49: -- API body
50: JTF_IH_PUB_W.OPEN_MEDIAITEM
51: (p_api_version=> p_api_version,

Line 70: IF FND_API.To_Boolean( p_commit ) THEN

66: x_media_id=> x_media_id );
67:
68: -- End of API body.
69: -- Standard check of p_commit.
70: IF FND_API.To_Boolean( p_commit ) THEN
71: COMMIT WORK;
72: END IF;
73:
74: EXCEPTION

Line 76: WHEN FND_API.G_EXC_ERROR THEN

72: END IF;
73:
74: EXCEPTION
75:
76: WHEN FND_API.G_EXC_ERROR THEN
77: ROLLBACK TO OPEN_MEDIA_ITEM_PUB;
78: x_return_status := FND_API.G_RET_STS_ERROR ;
79: x_msg_count := 1;
80: x_err_num := SQLCODE;

Line 78: x_return_status := FND_API.G_RET_STS_ERROR ;

74: EXCEPTION
75:
76: WHEN FND_API.G_EXC_ERROR THEN
77: ROLLBACK TO OPEN_MEDIA_ITEM_PUB;
78: x_return_status := FND_API.G_RET_STS_ERROR ;
79: x_msg_count := 1;
80: x_err_num := SQLCODE;
81: x_err_msg := SUBSTR(SQLERRM, 1, 100);
82: x_msg_data := 'CCT_IH_PUB: CCT_ERROR '

Line 86: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

82: x_msg_data := 'CCT_IH_PUB: CCT_ERROR '
83: || ' ErrorCode = ' || x_err_num
84: || ' ErrorMsg = ' || x_err_msg;
85: --dbms_output.put_line(x_msg_data);
86: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
87: ROLLBACK TO OPEN_MEDIA_ITEM_PUB;
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
89: x_msg_count := 1;
90: x_err_num := SQLCODE;

Line 88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

84: || ' ErrorMsg = ' || x_err_msg;
85: --dbms_output.put_line(x_msg_data);
86: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
87: ROLLBACK TO OPEN_MEDIA_ITEM_PUB;
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
89: x_msg_count := 1;
90: x_err_num := SQLCODE;
91: x_err_msg := SUBSTR(SQLERRM, 1, 100);
92: x_msg_data := 'CCT_IH_PUB: CCT_ERROR '

Line 98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

94: || ' ErrorMsg = ' || x_err_msg;
95: --dbms_output.put_line(x_msg_data);
96: WHEN OTHERS THEN
97: ROLLBACK TO OPEN_MEDIA_ITEM_PUB;
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
99: x_msg_count := 1;
100: x_err_num := SQLCODE;
101: x_err_msg := SUBSTR(SQLERRM, 1, 100);
102: x_msg_data := 'CCT_IH_PUB: CCT_ERROR '