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.GMO_LABEL_MGMT_GRP dependencies on FND_API

Line 70: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, GMO_LABEL_MGMT_GRP.G_PKG_NAME)

66: l_api_name constant VARCHAR2(30) :='PRINT_LABEL';
67: l_exit boolean:=true;
68:
69: BEGIN
70: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, GMO_LABEL_MGMT_GRP.G_PKG_NAME)
71: THEN
72: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
73: END IF;
74: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 72: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

68:
69: BEGIN
70: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, GMO_LABEL_MGMT_GRP.G_PKG_NAME)
71: THEN
72: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
73: END IF;
74: IF FND_API.to_Boolean(p_init_msg_list) THEN
75: FND_MSG_PUB.initialize;
76: END IF;

Line 74: IF FND_API.to_Boolean(p_init_msg_list) THEN

70: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, GMO_LABEL_MGMT_GRP.G_PKG_NAME)
71: THEN
72: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
73: END IF;
74: IF FND_API.to_Boolean(p_init_msg_list) THEN
75: FND_MSG_PUB.initialize;
76: END IF;
77:
78: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 78: x_return_status := FND_API.G_RET_STS_SUCCESS;

74: IF FND_API.to_Boolean(p_init_msg_list) THEN
75: FND_MSG_PUB.initialize;
76: END IF;
77:
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79:
80: /* Insert master row into GMO_LABEL_HISTORY */
81: OPEN C_LABEL_HISTORY_S;
82: fetch C_LABEL_HISTORY_S into l_label_id;

Line 203: WHEN FND_API.G_EXC_ERROR THEN

199: x_Label_id:=L_LABEL_ID;
200:
201: commit;
202: EXCEPTION
203: WHEN FND_API.G_EXC_ERROR THEN
204: x_return_status := FND_API.G_RET_STS_ERROR ;
205: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
206: ROLLBACK;
207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 204: x_return_status := FND_API.G_RET_STS_ERROR ;

200:
201: commit;
202: EXCEPTION
203: WHEN FND_API.G_EXC_ERROR THEN
204: x_return_status := FND_API.G_RET_STS_ERROR ;
205: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
206: ROLLBACK;
207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

203: WHEN FND_API.G_EXC_ERROR THEN
204: x_return_status := FND_API.G_RET_STS_ERROR ;
205: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
206: ROLLBACK;
207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
209: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
210: ROLLBACK;
211: WHEN OTHERS THEN

Line 208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

204: x_return_status := FND_API.G_RET_STS_ERROR ;
205: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
206: ROLLBACK;
207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
209: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
210: ROLLBACK;
211: WHEN OTHERS THEN
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
209: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
210: ROLLBACK;
211: WHEN OTHERS THEN
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
213: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
214: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
215: END IF;
216: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 283: IF NOT fnd_api.Compatible_API_Call (p_api_version, p_api_version, l_api_name, G_PKG_NAME )

279: CURSOR C_LABEL_DTL IS
280: select LABEL_TYPE from GMO_LABEL_HISTORY_DTL
281: where label_id=P_LABEL_ID;
282: BEGIN
283: IF NOT fnd_api.Compatible_API_Call (p_api_version, p_api_version, l_api_name, G_PKG_NAME )
284: THEN
285: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
286: END IF;
287:

Line 285: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

281: where label_id=P_LABEL_ID;
282: BEGIN
283: IF NOT fnd_api.Compatible_API_Call (p_api_version, p_api_version, l_api_name, G_PKG_NAME )
284: THEN
285: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
286: END IF;
287:
288: IF FND_API.to_Boolean( p_init_msg_list ) THEN
289: FND_MSG_PUB.initialize;

Line 288: IF FND_API.to_Boolean( p_init_msg_list ) THEN

284: THEN
285: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
286: END IF;
287:
288: IF FND_API.to_Boolean( p_init_msg_list ) THEN
289: FND_MSG_PUB.initialize;
290: END IF;
291: x_return_status := FND_API.G_RET_STS_SUCCESS;
292: GMO_UTILITIEs.GET_WHO_COLUMNS(X_CREATION_DATE =>L_CREATION_DATE,

Line 291: x_return_status := FND_API.G_RET_STS_SUCCESS;

287:
288: IF FND_API.to_Boolean( p_init_msg_list ) THEN
289: FND_MSG_PUB.initialize;
290: END IF;
291: x_return_status := FND_API.G_RET_STS_SUCCESS;
292: GMO_UTILITIEs.GET_WHO_COLUMNS(X_CREATION_DATE =>L_CREATION_DATE,
293: X_CREATED_BY => L_CREATED_BY,
294: X_LAST_UPDATE_DATE =>L_LAST_UPDATE_DATE,
295: X_LAST_UPDATED_BY =>L_LAST_UPDATED_BY,

Line 378: WHEN FND_API.G_EXC_ERROR THEN

374: END;
375: x_print_status:= L_LABEL_STATUS;
376: END IF;
377: EXCEPTION
378: WHEN FND_API.G_EXC_ERROR THEN
379: x_return_status := FND_API.G_RET_STS_ERROR ;
380: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
381: x_print_status:='ERROR';
382: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 379: x_return_status := FND_API.G_RET_STS_ERROR ;

375: x_print_status:= L_LABEL_STATUS;
376: END IF;
377: EXCEPTION
378: WHEN FND_API.G_EXC_ERROR THEN
379: x_return_status := FND_API.G_RET_STS_ERROR ;
380: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
381: x_print_status:='ERROR';
382: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 382: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

378: WHEN FND_API.G_EXC_ERROR THEN
379: x_return_status := FND_API.G_RET_STS_ERROR ;
380: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
381: x_print_status:='ERROR';
382: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
384: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
385: x_print_status:='ERROR';
386: WHEN OTHERS THEN

Line 383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

379: x_return_status := FND_API.G_RET_STS_ERROR ;
380: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
381: x_print_status:='ERROR';
382: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
384: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
385: x_print_status:='ERROR';
386: WHEN OTHERS THEN
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
384: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
385: x_print_status:='ERROR';
386: WHEN OTHERS THEN
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
388: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
389: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
390: END IF;
391: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 434: IF NOT fnd_api.Compatible_API_Call ( p_api_version, p_api_version, l_api_name, G_PKG_NAME )

430: l_api_version constant number:= 1.0;
431: l_api_name VARCHAR2(50) :='CANCEL_LABEL';
432:
433: BEGIN
434: IF NOT fnd_api.Compatible_API_Call ( p_api_version, p_api_version, l_api_name, G_PKG_NAME )
435: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
436: END IF;
437:
438: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 435: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

431: l_api_name VARCHAR2(50) :='CANCEL_LABEL';
432:
433: BEGIN
434: IF NOT fnd_api.Compatible_API_Call ( p_api_version, p_api_version, l_api_name, G_PKG_NAME )
435: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
436: END IF;
437:
438: IF FND_API.to_Boolean( p_init_msg_list ) THEN
439: FND_MSG_PUB.initialize;

Line 438: IF FND_API.to_Boolean( p_init_msg_list ) THEN

434: IF NOT fnd_api.Compatible_API_Call ( p_api_version, p_api_version, l_api_name, G_PKG_NAME )
435: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
436: END IF;
437:
438: IF FND_API.to_Boolean( p_init_msg_list ) THEN
439: FND_MSG_PUB.initialize;
440: END IF;
441: x_return_status := FND_API.G_RET_STS_SUCCESS;
442: GMO_UTILITIEs.GET_WHO_COLUMNS(X_CREATION_DATE =>L_CREATION_DATE,

Line 441: x_return_status := FND_API.G_RET_STS_SUCCESS;

437:
438: IF FND_API.to_Boolean( p_init_msg_list ) THEN
439: FND_MSG_PUB.initialize;
440: END IF;
441: x_return_status := FND_API.G_RET_STS_SUCCESS;
442: GMO_UTILITIEs.GET_WHO_COLUMNS(X_CREATION_DATE =>L_CREATION_DATE,
443: X_CREATED_BY => L_CREATED_BY,
444: X_LAST_UPDATE_DATE =>L_LAST_UPDATE_DATE,
445: X_LAST_UPDATED_BY =>L_LAST_UPDATED_BY,

Line 462: WHEN FND_API.G_EXC_ERROR THEN

458: WMS_LABEL_ID=NULL
459: where
460: label_id=P_LABEL_ID;
461: EXCEPTION
462: WHEN FND_API.G_EXC_ERROR THEN
463: x_return_status := FND_API.G_RET_STS_ERROR ;
464: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 463: x_return_status := FND_API.G_RET_STS_ERROR ;

459: where
460: label_id=P_LABEL_ID;
461: EXCEPTION
462: WHEN FND_API.G_EXC_ERROR THEN
463: x_return_status := FND_API.G_RET_STS_ERROR ;
464: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
467: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

461: EXCEPTION
462: WHEN FND_API.G_EXC_ERROR THEN
463: x_return_status := FND_API.G_RET_STS_ERROR ;
464: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
467: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
468: WHEN OTHERS THEN
469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

462: WHEN FND_API.G_EXC_ERROR THEN
463: x_return_status := FND_API.G_RET_STS_ERROR ;
464: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
467: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
468: WHEN OTHERS THEN
469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
470: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
467: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
468: WHEN OTHERS THEN
469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
470: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
471: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
472: END IF;
473: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 540: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )

536: l_api_version constant number:= 1.0;
537: l_api_name VARCHAR2(50) :='GET_PRINT_COUNT';
538:
539: BEGIN
540: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
541: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
542: END IF;
543:
544: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 541: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

537: l_api_name VARCHAR2(50) :='GET_PRINT_COUNT';
538:
539: BEGIN
540: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
541: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
542: END IF;
543:
544: IF FND_API.to_Boolean( p_init_msg_list ) THEN
545: FND_MSG_PUB.initialize;

Line 544: IF FND_API.to_Boolean( p_init_msg_list ) THEN

540: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
541: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
542: END IF;
543:
544: IF FND_API.to_Boolean( p_init_msg_list ) THEN
545: FND_MSG_PUB.initialize;
546: END IF;
547: Select Count(*) into x_print_count
548: --Bug 4912228: Start

Line 561: WHEN FND_API.G_EXC_ERROR THEN

557: --Bug 5146629: end
558: and A.WMS_BUSINESSFLOW_TRANS_ID=P_TRANSACTION_ID
559: and B.LABEL_TYPE=P_LABEL_TYPE;
560: EXCEPTION
561: WHEN FND_API.G_EXC_ERROR THEN
562: x_return_status := FND_API.G_RET_STS_ERROR ;
563: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 562: x_return_status := FND_API.G_RET_STS_ERROR ;

558: and A.WMS_BUSINESSFLOW_TRANS_ID=P_TRANSACTION_ID
559: and B.LABEL_TYPE=P_LABEL_TYPE;
560: EXCEPTION
561: WHEN FND_API.G_EXC_ERROR THEN
562: x_return_status := FND_API.G_RET_STS_ERROR ;
563: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
566: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

560: EXCEPTION
561: WHEN FND_API.G_EXC_ERROR THEN
562: x_return_status := FND_API.G_RET_STS_ERROR ;
563: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
566: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
567: WHEN OTHERS THEN
568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

561: WHEN FND_API.G_EXC_ERROR THEN
562: x_return_status := FND_API.G_RET_STS_ERROR ;
563: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
566: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
567: WHEN OTHERS THEN
568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
569: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
566: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
567: WHEN OTHERS THEN
568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
569: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
570: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
571: END IF;
572: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );