APPS.INV_MGD_MVT_PURGE_TRANS dependencies on FND_API

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

58: --=======================================================================--
59:
60: PROCEDURE Purge_Movement_Transactions
61: ( p_api_version_number IN NUMBER
62: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
63: , p_legal_entity_id IN NUMBER
64: , p_zone_code IN VARCHAR2
65: , p_usage_type IN VARCHAR2
66: , p_stat_type IN VARCHAR2

Line 87: IF NOT FND_API.Compatible_API_Call

83: );
84: END IF;
85:
86: -- Standard call to check for call compatibility
87: IF NOT FND_API.Compatible_API_Call
88: ( l_api_version_number
89: , p_api_version_number
90: , l_procedure_name
91: , G_PKG_NAME

Line 94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

90: , l_procedure_name
91: , G_PKG_NAME
92: )
93: THEN
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END IF;
96:
97: -- Initialize message stack if required
98: IF FND_API.to_Boolean(p_init_msg_list)

Line 98: IF FND_API.to_Boolean(p_init_msg_list)

94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END IF;
96:
97: -- Initialize message stack if required
98: IF FND_API.to_Boolean(p_init_msg_list)
99: THEN
100: FND_MSG_PUB.initialize;
101: END IF;
102:

Line 103: x_return_status := FND_API.G_RET_STS_SUCCESS;/*bug #7499719 'Y' was hardcoded changed to standard*/

99: THEN
100: FND_MSG_PUB.initialize;
101: END IF;
102:
103: x_return_status := FND_API.G_RET_STS_SUCCESS;/*bug #7499719 'Y' was hardcoded changed to standard*/
104:
105: DELETE FROM MTL_MOVEMENT_STATISTICS
106: WHERE entity_org_id = p_legal_entity_id
107: AND upper(stat_type) like nvl(upper(p_stat_type),'%')

Line 131: x_return_status := FND_API.G_RET_STS_ERROR;/*bug #7499719 'Y' was hardcoded changed to standard*/

127: END IF;
128: EXCEPTION
129:
130: WHEN NO_DATA_FOUND THEN
131: x_return_status := FND_API.G_RET_STS_ERROR;/*bug #7499719 'Y' was hardcoded changed to standard*/
132: FND_MESSAGE.Set_Name('INV', 'INV_NO_DATA_TRANSACTIONS');
133: FND_MSG_PUB.Add;
134: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
135: THEN

Line 144: x_return_status :=FND_API.G_RET_STS_ERROR;/*bug #7499719 'Y' was hardcoded changed to standard*/

140: END IF;
141: RAISE g_no_data_transaction_exc;
142:
143: WHEN TOO_MANY_ROWS THEN
144: x_return_status :=FND_API.G_RET_STS_ERROR;/*bug #7499719 'Y' was hardcoded changed to standard*/
145: FND_MESSAGE.Set_Name('INV', 'INV_TOO_MANY_TRANSACTIONS');
146: FND_MSG_PUB.Add;
147: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
148: THEN

Line 156: WHEN FND_API.G_EXC_ERROR THEN

152: );
153: END IF;
154: RAISE g_too_many_transactions_exc;
155:
156: WHEN FND_API.G_EXC_ERROR THEN
157: x_return_status := FND_API.G_RET_STS_ERROR;
158: -- Get message count and data
159: FND_MSG_PUB.Count_And_Get
160: ( p_count => x_msg_count

Line 157: x_return_status := FND_API.G_RET_STS_ERROR;

153: END IF;
154: RAISE g_too_many_transactions_exc;
155:
156: WHEN FND_API.G_EXC_ERROR THEN
157: x_return_status := FND_API.G_RET_STS_ERROR;
158: -- Get message count and data
159: FND_MSG_PUB.Count_And_Get
160: ( p_count => x_msg_count
161: , p_data => x_msg_data

Line 164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

160: ( p_count => x_msg_count
161: , p_data => x_msg_data
162: );
163:
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
166: -- Get message count and data
167: FND_MSG_PUB.Count_And_Get
168: ( p_count => x_msg_count

Line 165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

161: , p_data => x_msg_data
162: );
163:
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
166: -- Get message count and data
167: FND_MSG_PUB.Count_And_Get
168: ( p_count => x_msg_count
169: , p_data => x_msg_data

Line 173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

169: , p_data => x_msg_data
170: );
171:
172: WHEN OTHERS THEN
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
174: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
175: THEN
176: FND_MSG_PUB.Add_Exc_Msg
177: ( G_PKG_NAME