DBA Data[Home] [Help]

APPS.PSB_WS_POSITION_LINE_L_PVT dependencies on FND_MSG_PUB

Line 56: FND_MSG_PUB.initialize ;

52: END IF;
53: --
54:
55: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
56: FND_MSG_PUB.initialize ;
57: END IF;
58: --
59: p_row_locked := FND_API.G_TRUE;
60: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 69: FND_MSG_PUB.Add;

65: FETCH C INTO Recinfo;
66: IF (C%NOTFOUND) then
67: CLOSE C;
68: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
69: FND_MSG_PUB.Add;
70: RAISE FND_API.G_EXC_ERROR ;
71: END IF;
72: CLOSE C;
73: --

Line 78: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

74: IF FND_API.To_Boolean ( p_commit ) THEN
75: COMMIT WORK;
76: END iF;
77: --
78: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
79: p_data => p_msg_data );
80: --
81: EXCEPTION
82: --

Line 87: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

83: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
84: ROLLBACK TO Lock_Row_Pvt ;
85: p_row_locked := FND_API.G_FALSE;
86: p_return_status := FND_API.G_RET_STS_ERROR;
87: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
88: p_data => p_msg_data );
89: WHEN FND_API.G_EXC_ERROR THEN
90: --
91: ROLLBACK TO Lock_Row_Pvt ;

Line 93: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

89: WHEN FND_API.G_EXC_ERROR THEN
90: --
91: ROLLBACK TO Lock_Row_Pvt ;
92: p_return_status := FND_API.G_RET_STS_ERROR;
93: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
94: p_data => p_msg_data );
95: --
96: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
97: --

Line 100: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

96: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
97: --
98: ROLLBACK TO Lock_Row_Pvt ;
99: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
100: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
101: p_data => p_msg_data );
102: --
103: WHEN OTHERS THEN
104: --

Line 108: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

104: --
105: ROLLBACK TO Lock_Row_Pvt ;
106: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
107: --
108: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
109: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
110: l_api_name);
111: END if;
112: --

Line 109: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

105: ROLLBACK TO Lock_Row_Pvt ;
106: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
107: --
108: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
109: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
110: l_api_name);
111: END if;
112: --
113: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 113: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

109: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
110: l_api_name);
111: END if;
112: --
113: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
114: p_data => p_msg_data );
115: --
116: END Lock_Row;
117: /* ----------------------------------------------------------------------- */