DBA Data[Home] [Help]

APPS.IGC_CC_PO_LINES_ALL_PVT dependencies on FND_API

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

11: +=======================================================================*/
12: PROCEDURE Insert_Row
13: (
14: p_api_version IN NUMBER,
15: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
16: p_commit IN VARCHAR2 := FND_API.G_FALSE,
17: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
18: x_return_status OUT NOCOPY VARCHAR2,
19: x_msg_count OUT NOCOPY NUMBER,

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

12: PROCEDURE Insert_Row
13: (
14: p_api_version IN NUMBER,
15: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
16: p_commit IN VARCHAR2 := FND_API.G_FALSE,
17: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
18: x_return_status OUT NOCOPY VARCHAR2,
19: x_msg_count OUT NOCOPY NUMBER,
20: x_msg_data OUT NOCOPY VARCHAR2,

Line 17: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

13: (
14: p_api_version IN NUMBER,
15: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
16: p_commit IN VARCHAR2 := FND_API.G_FALSE,
17: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
18: x_return_status OUT NOCOPY VARCHAR2,
19: x_msg_count OUT NOCOPY NUMBER,
20: x_msg_data OUT NOCOPY VARCHAR2,
21: ---------------------------------------------

Line 33: IF NOT FND_API.Compatible_API_Call ( l_api_version,

29: BEGIN
30:
31: SAVEPOINT Insert_Row_Pvt ;
32:
33: IF NOT FND_API.Compatible_API_Call ( l_api_version,
34: p_api_version,
35: l_api_name,
36: G_PKG_NAME )
37: THEN

Line 38: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

34: p_api_version,
35: l_api_name,
36: G_PKG_NAME )
37: THEN
38: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
39: END IF;
40:
41:
42: IF FND_API.to_Boolean ( p_init_msg_list )

Line 42: IF FND_API.to_Boolean ( p_init_msg_list )

38: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
39: END IF;
40:
41:
42: IF FND_API.to_Boolean ( p_init_msg_list )
43: THEN
44: FND_MSG_PUB.initialize ;
45: END IF;
46:

Line 47: x_return_status := FND_API.G_RET_STS_SUCCESS ;

43: THEN
44: FND_MSG_PUB.initialize ;
45: END IF;
46:
47: x_return_status := FND_API.G_RET_STS_SUCCESS ;
48:
49: INSERT INTO po_lines_all (
50: po_line_id,
51: last_update_date,

Line 282: IF FND_API.To_Boolean ( p_commit )

278: p_po_lines_rec.task_id,
279: p_po_lines_rec.expiration_date,
280: p_po_lines_rec.tax_code_id);
281:
282: IF FND_API.To_Boolean ( p_commit )
283: THEN
284: COMMIT WORK;
285: END IF;
286:

Line 292: WHEN FND_API.G_EXC_ERROR

288: p_data => x_msg_data );
289:
290: EXCEPTION
291:
292: WHEN FND_API.G_EXC_ERROR
293: THEN
294:
295: ROLLBACK TO Insert_Row_Pvt ;
296: x_return_status := FND_API.G_RET_STS_ERROR;

Line 296: x_return_status := FND_API.G_RET_STS_ERROR;

292: WHEN FND_API.G_EXC_ERROR
293: THEN
294:
295: ROLLBACK TO Insert_Row_Pvt ;
296: x_return_status := FND_API.G_RET_STS_ERROR;
297: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
298: p_data => x_msg_data );
299:
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

296: x_return_status := FND_API.G_RET_STS_ERROR;
297: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
298: p_data => x_msg_data );
299:
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
301: THEN
302: ROLLBACK TO Insert_Row_Pvt ;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

299:
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
301: THEN
302: ROLLBACK TO Insert_Row_Pvt ;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
305: p_data => x_msg_data );
306:
307: WHEN OTHERS

Line 310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

306:
307: WHEN OTHERS
308: THEN
309: ROLLBACK TO Insert_Row_Pvt ;
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311:
312: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
313: THEN
314: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

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

326: +==========================================================================*/
327: PROCEDURE Update_Row
328: (
329: p_api_version IN NUMBER,
330: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
331: p_commit IN VARCHAR2 := FND_API.G_FALSE,
332: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
333: x_return_status OUT NOCOPY VARCHAR2,
334: x_msg_count OUT NOCOPY NUMBER,

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

327: PROCEDURE Update_Row
328: (
329: p_api_version IN NUMBER,
330: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
331: p_commit IN VARCHAR2 := FND_API.G_FALSE,
332: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
333: x_return_status OUT NOCOPY VARCHAR2,
334: x_msg_count OUT NOCOPY NUMBER,
335: x_msg_data OUT NOCOPY VARCHAR2,

Line 332: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

328: (
329: p_api_version IN NUMBER,
330: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
331: p_commit IN VARCHAR2 := FND_API.G_FALSE,
332: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
333: x_return_status OUT NOCOPY VARCHAR2,
334: x_msg_count OUT NOCOPY NUMBER,
335: x_msg_data OUT NOCOPY VARCHAR2,
336: ---------------------------------------------

Line 349: IF NOT FND_API.Compatible_API_Call ( l_api_version,

345: BEGIN
346:
347: SAVEPOINT Update_Row_Pvt ;
348:
349: IF NOT FND_API.Compatible_API_Call ( l_api_version,
350: p_api_version,
351: l_api_name,
352: G_PKG_NAME )
353: THEN

Line 354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

350: p_api_version,
351: l_api_name,
352: G_PKG_NAME )
353: THEN
354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
355: END IF;
356:
357:
358: IF FND_API.to_Boolean ( p_init_msg_list )

Line 358: IF FND_API.to_Boolean ( p_init_msg_list )

354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
355: END IF;
356:
357:
358: IF FND_API.to_Boolean ( p_init_msg_list )
359: THEN
360: FND_MSG_PUB.initialize ;
361: END IF;
362:

Line 363: x_return_status := FND_API.G_RET_STS_SUCCESS ;

359: THEN
360: FND_MSG_PUB.initialize ;
361: END IF;
362:
363: x_return_status := FND_API.G_RET_STS_SUCCESS ;
364:
365: /* update */
366:
367: UPDATE po_lines_all

Line 488: IF FND_API.To_Boolean ( p_commit )

484: RAISE NO_DATA_FOUND ;
485: END IF;
486:
487:
488: IF FND_API.To_Boolean ( p_commit )
489: THEN
490: COMMIT WORK;
491: END IF;
492:

Line 498: WHEN FND_API.G_EXC_ERROR

494: p_data => x_msg_data );
495:
496: EXCEPTION
497:
498: WHEN FND_API.G_EXC_ERROR
499: THEN
500: ROLLBACK TO Update_Row_Pvt ;
501: x_return_status := FND_API.G_RET_STS_ERROR;
502:

Line 501: x_return_status := FND_API.G_RET_STS_ERROR;

497:
498: WHEN FND_API.G_EXC_ERROR
499: THEN
500: ROLLBACK TO Update_Row_Pvt ;
501: x_return_status := FND_API.G_RET_STS_ERROR;
502:
503: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
504: p_data => x_msg_data );
505:

Line 506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

502:
503: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
504: p_data => x_msg_data );
505:
506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
507: THEN
508:
509: ROLLBACK TO Update_Row_Pvt ;
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
507: THEN
508:
509: ROLLBACK TO Update_Row_Pvt ;
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
512: p_data => x_msg_data );
513:
514: WHEN OTHERS

Line 518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

514: WHEN OTHERS
515: THEN
516:
517: ROLLBACK TO Update_Row_Pvt ;
518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
519:
520: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
521: THEN
522: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,