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_MSG_PUB

Line 38: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ; -- temp call to initialize the

34: PROCEDURE log_msg(p_msg_text IN VARCHAR2);
35:
36: /* Global variables */
37: G_PKG_NAME CONSTANT VARCHAR2(30) :='GMIVDBX';
38: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ; -- temp call to initialize the
39: -- msg level threshhold gobal
40: -- variable.
41: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere
42: -- to decide to log a debug msg.

Line 41: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere

37: G_PKG_NAME CONSTANT VARCHAR2(30) :='GMIVDBX';
38: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ; -- temp call to initialize the
39: -- msg level threshhold gobal
40: -- variable.
41: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere
42: -- to decide to log a debug msg.
43:
44:
45: /* +==========================================================================+

Line 78: FND_MSG_PUB.Initialize;

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;
82:

Line 238: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

234: , x_hdr_row.delete_mark
235: , x_hdr_row.text_code
236: );
237:
238: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
239: log_msg('Inserted 1 record in gmi_discrete_transfers');
240: END IF;
241:
242: FND_MSG_PUB.Count_AND_GET

Line 242: FND_MSG_PUB.Count_AND_GET

238: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
239: log_msg('Inserted 1 record in gmi_discrete_transfers');
240: END IF;
241:
242: FND_MSG_PUB.Count_AND_GET
243: (p_count => x_msg_count, p_data => x_msg_data);
244:
245:
246: EXCEPTION

Line 251: FND_MSG_PUB.Count_AND_GET

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
255: ROLLBACK to create_header;

Line 257: FND_MSG_PUB.Count_AND_GET

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
261: ROLLBACK to create_header;

Line 266: FND_MSG_PUB.Add;

262: IF (SQLCODE IS NOT NULL) THEN
263: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_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);

Line 269: FND_MSG_PUB.Count_AND_GET

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;
273:

Line 310: FND_MSG_PUB.Initialize;

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;
314:

Line 542: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

538: , x_line_row.delete_mark
539: , x_line_row.text_code
540: );
541:
542: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
543: log_msg('Inserted 1 record in gmi_discrete_transfer_lines');
544: END IF;
545:
546: FND_MSG_PUB.Count_AND_GET

Line 546: FND_MSG_PUB.Count_AND_GET

542: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
543: log_msg('Inserted 1 record in gmi_discrete_transfer_lines');
544: END IF;
545:
546: FND_MSG_PUB.Count_AND_GET
547: (p_count => x_msg_count, p_data => x_msg_data);
548:
549:
550: EXCEPTION

Line 555: FND_MSG_PUB.Count_AND_GET

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
559: ROLLBACK to create_line;

Line 561: FND_MSG_PUB.Count_AND_GET

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
565: ROLLBACK to create_line;

Line 570: FND_MSG_PUB.Add;

566: IF (SQLCODE IS NOT NULL) THEN
567: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_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);

Line 573: FND_MSG_PUB.Count_AND_GET

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;
577:

Line 614: FND_MSG_PUB.Initialize;

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;
618:

Line 702: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

698: , x_lot_row.delete_mark
699: , x_lot_row.text_code
700: );
701:
702: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
703: log_msg('Inserted 1 record in gmi_discrete_transfer_lots');
704: END IF;
705:
706: FND_MSG_PUB.Count_AND_GET

Line 706: FND_MSG_PUB.Count_AND_GET

702: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
703: log_msg('Inserted 1 record in gmi_discrete_transfer_lots');
704: END IF;
705:
706: FND_MSG_PUB.Count_AND_GET
707: (p_count => x_msg_count, p_data => x_msg_data);
708:
709:
710:

Line 716: FND_MSG_PUB.Count_AND_GET

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
720: ROLLBACK to create_lot;

Line 722: FND_MSG_PUB.Count_AND_GET

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
726: ROLLBACK to create_lot;

Line 731: FND_MSG_PUB.Add;

727: IF (SQLCODE IS NOT NULL) THEN
728: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_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);

Line 734: FND_MSG_PUB.Count_AND_GET

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;
738:

Line 781: FND_MSG_PUB.Count_AND_GET

777: COMMIT;
778:
779: return l_doc_no;
780:
781: FND_MSG_PUB.Count_AND_GET
782: (p_count => x_msg_count, p_data => x_msg_data);
783:
784: EXCEPTION
785:

Line 789: FND_MSG_PUB.Count_AND_GET

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
793: ROLLBACK to get_doc_no;

Line 795: FND_MSG_PUB.Count_AND_GET

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
799: ROLLBACK to get_doc_no;

Line 804: FND_MSG_PUB.Add;

800: IF (SQLCODE IS NOT NULL) THEN
801: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_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);

Line 807: FND_MSG_PUB.Count_AND_GET

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;
811:

Line 817: FND_MSG_PUB.Add;

813: BEGIN
814:
815: FND_MESSAGE.SET_NAME('GMI','GMI_DEBUG_API');
816: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
817: FND_MSG_PUB.Add;
818:
819: END log_msg ;
820:
821: END GMIVDBX;