eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMIVDBX dependencies on FND_API

Line 61: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

57: | |
58: +==========================================================================+ */
59: PROCEDURE header_insert
60: ( p_api_version IN NUMBER
61: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
62: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
63: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
64: , x_return_status OUT NOCOPY VARCHAR2
65: , x_msg_count OUT NOCOPY NUMBER

Line 62: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

58: +==========================================================================+ */
59: PROCEDURE header_insert
60: ( p_api_version IN NUMBER
61: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
62: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
63: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
64: , x_return_status OUT NOCOPY VARCHAR2
65: , x_msg_count OUT NOCOPY NUMBER
66: , x_msg_data OUT NOCOPY VARCHAR2

Line 63: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

59: PROCEDURE header_insert
60: ( p_api_version IN NUMBER
61: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
62: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
63: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
64: , x_return_status OUT NOCOPY VARCHAR2
65: , x_msg_count OUT NOCOPY NUMBER
66: , x_msg_data OUT NOCOPY VARCHAR2
67: , p_hdr_rec IN GMIVDX.hdr_type

Line 77: IF FND_API.to_boolean(p_init_msg_list) THEN

73:
74:
75: BEGIN
76:
77: IF FND_API.to_boolean(p_init_msg_list) THEN
78: FND_MSG_PUB.Initialize;
79: END IF;
80:
81: SAVEPOINT create_header;

Line 84: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

80:
81: SAVEPOINT create_header;
82:
83: -- Standard call to check for call compatibility.
84: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
85: p_api_version ,
86: l_api_name ,
87: G_PKG_NAME
88: ) THEN

Line 89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

85: p_api_version ,
86: l_api_name ,
87: G_PKG_NAME
88: ) THEN
89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
90: END IF;
91:
92: x_return_status :=FND_API.G_RET_STS_SUCCESS;
93:

Line 92: x_return_status :=FND_API.G_RET_STS_SUCCESS;

88: ) THEN
89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
90: END IF;
91:
92: x_return_status :=FND_API.G_RET_STS_SUCCESS;
93:
94: --assign the transfer id.
95: SELECT gmi_dxfr_transfer_id_s.nextval INTO x_hdr_row.transfer_id FROM DUAL;
96:

Line 248: WHEN FND_API.G_EXC_ERROR THEN

244:
245:
246: EXCEPTION
247:
248: WHEN FND_API.G_EXC_ERROR THEN
249: ROLLBACK to create_header;
250: x_return_status := FND_API.G_RET_STS_ERROR;
251: FND_MSG_PUB.Count_AND_GET
252: (p_count => x_msg_count, p_data => x_msg_data);

Line 250: x_return_status := FND_API.G_RET_STS_ERROR;

246: EXCEPTION
247:
248: WHEN FND_API.G_EXC_ERROR THEN
249: ROLLBACK to create_header;
250: x_return_status := FND_API.G_RET_STS_ERROR;
251: FND_MSG_PUB.Count_AND_GET
252: (p_count => x_msg_count, p_data => x_msg_data);
253:
254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

250: x_return_status := FND_API.G_RET_STS_ERROR;
251: FND_MSG_PUB.Count_AND_GET
252: (p_count => x_msg_count, p_data => x_msg_data);
253:
254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
255: ROLLBACK to create_header;
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257: FND_MSG_PUB.Count_AND_GET
258: (p_count => x_msg_count, p_data => x_msg_data);

Line 256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

252: (p_count => x_msg_count, p_data => x_msg_data);
253:
254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
255: ROLLBACK to create_header;
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257: FND_MSG_PUB.Count_AND_GET
258: (p_count => x_msg_count, p_data => x_msg_data);
259:
260: WHEN OTHERS THEN

Line 268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

264: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
265: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
266: FND_MSG_PUB.Add;
267: END IF;
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
269: FND_MSG_PUB.Count_AND_GET
270: (p_count => x_msg_count, p_data => x_msg_data);
271:
272: END header_insert;

Line 292: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

288: */
289:
290: PROCEDURE line_insert
291: ( p_api_version IN NUMBER
292: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
293: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
294: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
295: , x_return_status OUT NOCOPY VARCHAR2
296: , x_msg_count OUT NOCOPY NUMBER

Line 293: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

289:
290: PROCEDURE line_insert
291: ( p_api_version IN NUMBER
292: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
293: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
294: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
295: , x_return_status OUT NOCOPY VARCHAR2
296: , x_msg_count OUT NOCOPY NUMBER
297: , x_msg_data OUT NOCOPY VARCHAR2

Line 294: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

290: PROCEDURE line_insert
291: ( p_api_version IN NUMBER
292: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
293: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
294: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
295: , x_return_status OUT NOCOPY VARCHAR2
296: , x_msg_count OUT NOCOPY NUMBER
297: , x_msg_data OUT NOCOPY VARCHAR2
298: , p_hdr_row IN gmi_discrete_transfers%ROWTYPE

Line 309: IF FND_API.to_boolean(p_init_msg_list) THEN

305:
306:
307: BEGIN
308:
309: IF FND_API.to_boolean(p_init_msg_list) THEN
310: FND_MSG_PUB.Initialize;
311: END IF;
312:
313: SAVEPOINT create_line;

Line 316: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

312:
313: SAVEPOINT create_line;
314:
315: -- Standard call to check for call compatibility.
316: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
317: p_api_version ,
318: l_api_name ,
319: G_PKG_NAME
320: ) THEN

Line 321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

317: p_api_version ,
318: l_api_name ,
319: G_PKG_NAME
320: ) THEN
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322: END IF;
323:
324: x_return_status :=FND_API.G_RET_STS_SUCCESS;
325:

Line 324: x_return_status :=FND_API.G_RET_STS_SUCCESS;

320: ) THEN
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322: END IF;
323:
324: x_return_status :=FND_API.G_RET_STS_SUCCESS;
325:
326: x_line_row.transfer_id := p_hdr_row.transfer_id;
327:
328: --get the line id

Line 552: WHEN FND_API.G_EXC_ERROR THEN

548:
549:
550: EXCEPTION
551:
552: WHEN FND_API.G_EXC_ERROR THEN
553: ROLLBACK to create_line;
554: x_return_status := FND_API.G_RET_STS_ERROR;
555: FND_MSG_PUB.Count_AND_GET
556: (p_count => x_msg_count, p_data => x_msg_data);

Line 554: x_return_status := FND_API.G_RET_STS_ERROR;

550: EXCEPTION
551:
552: WHEN FND_API.G_EXC_ERROR THEN
553: ROLLBACK to create_line;
554: x_return_status := FND_API.G_RET_STS_ERROR;
555: FND_MSG_PUB.Count_AND_GET
556: (p_count => x_msg_count, p_data => x_msg_data);
557:
558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

554: x_return_status := FND_API.G_RET_STS_ERROR;
555: FND_MSG_PUB.Count_AND_GET
556: (p_count => x_msg_count, p_data => x_msg_data);
557:
558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
559: ROLLBACK to create_line;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: FND_MSG_PUB.Count_AND_GET
562: (p_count => x_msg_count, p_data => x_msg_data);

Line 560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

556: (p_count => x_msg_count, p_data => x_msg_data);
557:
558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
559: ROLLBACK to create_line;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: FND_MSG_PUB.Count_AND_GET
562: (p_count => x_msg_count, p_data => x_msg_data);
563:
564: WHEN OTHERS THEN

Line 572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

568: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
569: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
570: FND_MSG_PUB.Add;
571: END IF;
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
573: FND_MSG_PUB.Count_AND_GET
574: (p_count => x_msg_count, p_data => x_msg_data);
575:
576: END line_insert;

Line 597: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

593: +==========================================================================+
594: */
595: PROCEDURE lot_insert
596: ( p_api_version IN NUMBER
597: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
598: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
599: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
600: , x_return_status OUT NOCOPY VARCHAR2
601: , x_msg_count OUT NOCOPY NUMBER

Line 598: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

594: */
595: PROCEDURE lot_insert
596: ( p_api_version IN NUMBER
597: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
598: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
599: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
600: , x_return_status OUT NOCOPY VARCHAR2
601: , x_msg_count OUT NOCOPY NUMBER
602: , x_msg_data OUT NOCOPY VARCHAR2

Line 599: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

595: PROCEDURE lot_insert
596: ( p_api_version IN NUMBER
597: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
598: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
599: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
600: , x_return_status OUT NOCOPY VARCHAR2
601: , x_msg_count OUT NOCOPY NUMBER
602: , x_msg_data OUT NOCOPY VARCHAR2
603: , p_line_row IN gmi_discrete_transfer_lines%ROWTYPE

Line 613: IF FND_API.to_boolean(p_init_msg_list) THEN

609:
610:
611: BEGIN
612:
613: IF FND_API.to_boolean(p_init_msg_list) THEN
614: FND_MSG_PUB.Initialize;
615: END IF;
616:
617: SAVEPOINT create_lot;

Line 620: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

616:
617: SAVEPOINT create_lot;
618:
619: -- Standard call to check for call compatibility.
620: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
621: p_api_version ,
622: l_api_name ,
623: G_PKG_NAME
624: ) THEN

Line 625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

621: p_api_version ,
622: l_api_name ,
623: G_PKG_NAME
624: ) THEN
625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
626: END IF;
627:
628: x_return_status :=FND_API.G_RET_STS_SUCCESS;
629:

Line 628: x_return_status :=FND_API.G_RET_STS_SUCCESS;

624: ) THEN
625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
626: END IF;
627:
628: x_return_status :=FND_API.G_RET_STS_SUCCESS;
629:
630: x_lot_row.transfer_id := p_line_row.transfer_id;
631: x_lot_row.line_id := p_line_row.line_id;
632:

Line 713: WHEN FND_API.G_EXC_ERROR THEN

709:
710:
711: EXCEPTION
712:
713: WHEN FND_API.G_EXC_ERROR THEN
714: ROLLBACK to create_lot;
715: x_return_status := FND_API.G_RET_STS_ERROR;
716: FND_MSG_PUB.Count_AND_GET
717: (p_count => x_msg_count, p_data => x_msg_data);

Line 715: x_return_status := FND_API.G_RET_STS_ERROR;

711: EXCEPTION
712:
713: WHEN FND_API.G_EXC_ERROR THEN
714: ROLLBACK to create_lot;
715: x_return_status := FND_API.G_RET_STS_ERROR;
716: FND_MSG_PUB.Count_AND_GET
717: (p_count => x_msg_count, p_data => x_msg_data);
718:
719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

715: x_return_status := FND_API.G_RET_STS_ERROR;
716: FND_MSG_PUB.Count_AND_GET
717: (p_count => x_msg_count, p_data => x_msg_data);
718:
719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
720: ROLLBACK to create_lot;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722: FND_MSG_PUB.Count_AND_GET
723: (p_count => x_msg_count, p_data => x_msg_data);

Line 721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

717: (p_count => x_msg_count, p_data => x_msg_data);
718:
719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
720: ROLLBACK to create_lot;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722: FND_MSG_PUB.Count_AND_GET
723: (p_count => x_msg_count, p_data => x_msg_data);
724:
725: WHEN OTHERS THEN

Line 733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

729: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
730: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
731: FND_MSG_PUB.Add;
732: END IF;
733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
734: FND_MSG_PUB.Count_AND_GET
735: (p_count => x_msg_count, p_data => x_msg_data);
736:
737: END lot_insert;

Line 773: x_return_status :=FND_API.G_RET_STS_SUCCESS;

769: BEGIN
770:
771: SAVEPOINT get_doc_no;
772:
773: x_return_status :=FND_API.G_RET_STS_SUCCESS;
774:
775: l_doc_no := GMA_GLOBAL_GRP.Get_doc_no (p_doc_type,p_orgn_code);
776:
777: COMMIT;

Line 786: WHEN FND_API.G_EXC_ERROR THEN

782: (p_count => x_msg_count, p_data => x_msg_data);
783:
784: EXCEPTION
785:
786: WHEN FND_API.G_EXC_ERROR THEN
787: ROLLBACK to get_doc_no;
788: x_return_status := FND_API.G_RET_STS_ERROR;
789: FND_MSG_PUB.Count_AND_GET
790: (p_count => x_msg_count, p_data => x_msg_data);

Line 788: x_return_status := FND_API.G_RET_STS_ERROR;

784: EXCEPTION
785:
786: WHEN FND_API.G_EXC_ERROR THEN
787: ROLLBACK to get_doc_no;
788: x_return_status := FND_API.G_RET_STS_ERROR;
789: FND_MSG_PUB.Count_AND_GET
790: (p_count => x_msg_count, p_data => x_msg_data);
791:
792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

788: x_return_status := FND_API.G_RET_STS_ERROR;
789: FND_MSG_PUB.Count_AND_GET
790: (p_count => x_msg_count, p_data => x_msg_data);
791:
792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
793: ROLLBACK to get_doc_no;
794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
795: FND_MSG_PUB.Count_AND_GET
796: (p_count => x_msg_count, p_data => x_msg_data);

Line 794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

790: (p_count => x_msg_count, p_data => x_msg_data);
791:
792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
793: ROLLBACK to get_doc_no;
794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
795: FND_MSG_PUB.Count_AND_GET
796: (p_count => x_msg_count, p_data => x_msg_data);
797:
798: WHEN OTHERS THEN

Line 806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

802: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
803: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
804: FND_MSG_PUB.Add;
805: END IF;
806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
807: FND_MSG_PUB.Count_AND_GET
808: (p_count => x_msg_count, p_data => x_msg_data);
809:
810: END get_doc_no;