APPS.ASO_ORDER_FEEDBACK_UPDATE_PVT dependencies on FND_API

Line 29: -- Default = FND_API.G_FALSE

25: --
26: -- Standard IN Parameters:
27: -- p_api_version IN NUMBER Required
28: -- p_init_msg_list IN VARCHAR2 Optional
29: -- Default = FND_API.G_FALSE
30: -- p_commit IN VARCHAR2 Optional
31: -- Default = FND_API.G_FALSE
32: --
33: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:

Line 31: -- Default = FND_API.G_FALSE

27: -- p_api_version IN NUMBER Required
28: -- p_init_msg_list IN VARCHAR2 Optional
29: -- Default = FND_API.G_FALSE
30: -- p_commit IN VARCHAR2 Optional
31: -- Default = FND_API.G_FALSE
32: --
33: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
34: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
35: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

107:
108: PROCEDURE UPDATE_NOTICE
109: (
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
114: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
115: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

108: PROCEDURE UPDATE_NOTICE
109: (
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
114: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
115: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
116: p_header_rec IN OE_Order_PUB.Header_Rec_Type :=

Line 212: IF NOT FND_API.Compatible_API_Call (l_api_version ,

208: SAVEPOINT UPDATE_NOTICE_PVT;
209:
210: -- Standard call to check for call compatibility.
211:
212: IF NOT FND_API.Compatible_API_Call (l_api_version ,
213: p_api_version ,
214: l_api_name ,
215: G_PKG_NAME )
216: THEN

Line 217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

213: p_api_version ,
214: l_api_name ,
215: G_PKG_NAME )
216: THEN
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: END IF;
219:
220: -- Initialize message list if p_init_msg_list is set to TRUE.
221:

Line 222: IF FND_API.to_Boolean( p_init_msg_list ) THEN

218: END IF;
219:
220: -- Initialize message list if p_init_msg_list is set to TRUE.
221:
222: IF FND_API.to_Boolean( p_init_msg_list ) THEN
223: FND_MSG_PUB.initialize;
224: END IF;
225:
226: -- Initialize API return status to success

Line 228: x_return_status := FND_API.G_RET_STS_SUCCESS;

224: END IF;
225:
226: -- Initialize API return status to success
227:
228: x_return_status := FND_API.G_RET_STS_SUCCESS;
229:
230: -- UPDATE_NOTICE API specific input parameter validation logic
231: -- none
232:

Line 317: IF FND_API.To_Boolean( p_commit ) THEN

313: -- End of API Body
314:
315: -- Standard check of p_commit.
316:
317: IF FND_API.To_Boolean( p_commit ) THEN
318: COMMIT WORK;
319: END IF;
320:
321: -- Standard call to get message count and if count is 1, get message info.

Line 330: WHEN FND_API.G_EXC_ERROR THEN

326: );
327:
328: EXCEPTION
329:
330: WHEN FND_API.G_EXC_ERROR THEN
331: ROLLBACK TO UPDATE_NOTICE_PVT;
332: x_return_status := FND_API.G_RET_STS_ERROR ;
333: FND_MSG_PUB.Count_And_Get
334: (p_count => x_msg_count ,

Line 332: x_return_status := FND_API.G_RET_STS_ERROR ;

328: EXCEPTION
329:
330: WHEN FND_API.G_EXC_ERROR THEN
331: ROLLBACK TO UPDATE_NOTICE_PVT;
332: x_return_status := FND_API.G_RET_STS_ERROR ;
333: FND_MSG_PUB.Count_And_Get
334: (p_count => x_msg_count ,
335: p_data => x_msg_data
336: );

Line 337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

333: FND_MSG_PUB.Count_And_Get
334: (p_count => x_msg_count ,
335: p_data => x_msg_data
336: );
337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
338: ROLLBACK TO UPDATE_NOTICE_PVT;
339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
340: FND_MSG_PUB.Count_And_Get
341: (p_count => x_msg_count ,

Line 339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

335: p_data => x_msg_data
336: );
337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
338: ROLLBACK TO UPDATE_NOTICE_PVT;
339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
340: FND_MSG_PUB.Count_And_Get
341: (p_count => x_msg_count ,
342: p_data => x_msg_data
343: );

Line 346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

342: p_data => x_msg_data
343: );
344: WHEN OTHERS THEN
345: ROLLBACK TO UPDATE_NOTICE_PVT;
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
347: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
348: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
349: END IF;
350: FND_MSG_PUB.Count_And_Get

Line 949: l_semi_processed_flag := FND_API.G_TRUE;

945:
946: i := p_line_tbl_type.FIRST;
947: WHILE i IS NOT NULL LOOP
948: if p_line_tbl_type(i).semi_processed_flag then
949: l_semi_processed_flag := FND_API.G_TRUE;
950: elsif p_line_tbl_type(i).semi_processed_flag is null then
951: l_semi_processed_flag := NULL;
952: else
953: l_semi_processed_flag := FND_API.G_FALSE;

Line 953: l_semi_processed_flag := FND_API.G_FALSE;

949: l_semi_processed_flag := FND_API.G_TRUE;
950: elsif p_line_tbl_type(i).semi_processed_flag is null then
951: l_semi_processed_flag := NULL;
952: else
953: l_semi_processed_flag := FND_API.G_FALSE;
954: end if;
955:
956: l_line_type := SYSTEM.ASO_Line_Type
957: ( p_line_tbl_type(i).accounting_rule_id

Line 1864: if p_commit = FND_API.G_TRUE then

1860: ASO_CRM_Recipients(l_mprop.recipient_list);
1861: else
1862: queue_name := ASO_QUEUE.ASO_OF_EXCP_Q;
1863: l_mprop.recipient_list(0) := sys.aq$_agent(p_app_short_name, NULL, NULL);
1864: if p_commit = FND_API.G_TRUE then
1865: l_eopt.visibility := dbms_aq.IMMEDIATE;
1866: else
1867: l_eopt.visibility := dbms_aq.ON_COMMIT;
1868: end if;