DBA Data[Home] [Help]

APPS.GMO_LABEL_MGMT_GRP dependencies on FND_MSG_PUB

Line 75: FND_MSG_PUB.initialize;

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

Line 205: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 ;
209: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 209: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 ;
213: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 213: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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 );
217: ROLLBACK;

Line 214: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

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 );
217: ROLLBACK;
218: END PRINT_LABEL;

Line 216: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
217: ROLLBACK;
218: END PRINT_LABEL;
219:
220: -- Start of comments

Line 289: FND_MSG_PUB.initialize;

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,
293: X_CREATED_BY => L_CREATED_BY,

Line 380: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 ;
384: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 384: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 ;
388: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 388: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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 );
392: x_print_status:='ERROR';

Line 389: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

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 );
392: x_print_status:='ERROR';
393: END;

Line 391: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
392: x_print_status:='ERROR';
393: END;
394:
395: -- Start of comments

Line 439: FND_MSG_PUB.initialize;

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,
443: X_CREATED_BY => L_CREATED_BY,

Line 464: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
468: WHEN OTHERS THEN

Line 467: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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
471: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 470: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_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 );
474:

Line 471: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

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 );
474:
475: END;

Line 473: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
474:
475: END;
476:
477: -- Start of comments

Line 545: FND_MSG_PUB.initialize;

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
549: From GMO_LABEL_HISTORY A, GMO_LABEL_HISTORY_DTL B

Line 563: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
567: WHEN OTHERS THEN

Line 566: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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
570: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 569: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_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 );
573:

Line 570: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

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 );
573:
574: END;

Line 572: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
573:
574: END;
575:
576: end GMO_LABEL_MGMT_GRP;