DBA Data[Home] [Help]

APPS.AST_WEBSWITCH_PVT dependencies on FND_MSG_PUB

Line 58: FND_MSG_PUB.initialize;

54: END IF;
55:
56: -- Check p_init_msg_list
57: IF FND_API.to_Boolean( p_init_msg_list ) THEN
58: FND_MSG_PUB.initialize;
59: END IF;
60:
61: -- Implementation of User Hooks
62: /* Copy all parameters to local variables to be passed to Pre, Post and Business APIs */

Line 254: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

250: CLOSE c2;
251:
252:
253: -- Success Message
254: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
255: THEN
256: FND_MESSAGE.Set_Name('ast', 'API_ROWS_UPDATED');
257: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
258: FND_MESSAGE.Set_Token('NUMBER', 1, FALSE);

Line 259: FND_MSG_PUB.Add;

255: THEN
256: FND_MESSAGE.Set_Name('ast', 'API_ROWS_UPDATED');
257: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
258: FND_MESSAGE.Set_Token('NUMBER', 1, FALSE);
259: FND_MSG_PUB.Add;
260: END IF;
261:
262:
263: -- Success Message

Line 264: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) and

260: END IF;
261:
262:
263: -- Success Message
264: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) and
265: x_return_status = FND_API.G_RET_STS_SUCCESS
266: THEN
267: FND_MESSAGE.Set_Name('ast', 'API_SUCCESS');
268: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);

Line 269: FND_MSG_PUB.Add;

265: x_return_status = FND_API.G_RET_STS_SUCCESS
266: THEN
267: FND_MESSAGE.Set_Name('ast', 'API_SUCCESS');
268: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
269: FND_MSG_PUB.Add;
270: END IF;
271: -- END of API body
272:
273: /* Vertical Post Processing section - mandatory */

Line 312: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

308: COMMIT WORK;
309: END IF;
310:
311: -- Debug Message
312: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
313: THEN
314: FND_MESSAGE.Set_Name('ast', 'Pvt WebAssist API: End');
315: FND_MSG_PUB.Add;
316: END IF;

Line 315: FND_MSG_PUB.Add;

311: -- Debug Message
312: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
313: THEN
314: FND_MESSAGE.Set_Name('ast', 'Pvt WebAssist API: End');
315: FND_MSG_PUB.Add;
316: END IF;
317:
318: -- Standard call to get message count and IF count is 1, get message info.
319: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 319: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

315: FND_MSG_PUB.Add;
316: END IF;
317:
318: -- Standard call to get message count and IF count is 1, get message info.
319: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
320: p_data => x_msg_data );
321:
322:
323: --

Line 333: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

329:
330: ROLLBACK TO Create_WebSwitch_PUB;
331: x_return_status := FND_API.G_RET_STS_ERROR ;
332:
333: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
334: p_data => x_msg_data );
335:
336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
337:

Line 341: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

337:
338: ROLLBACK TO Create_WebSwitch_PUB;
339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
340:
341: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
342: p_data => x_msg_data );
343:
344: WHEN OTHERS THEN
345:

Line 349: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

345:
346: ROLLBACK TO Create_WebSwitch_PUB;
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
348:
349: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
350: THEN
351: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
352: END IF;
353:

Line 351: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
348:
349: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
350: THEN
351: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
352: END IF;
353:
354: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
355: p_data => x_msg_data );

Line 354: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

350: THEN
351: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
352: END IF;
353:
354: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
355: p_data => x_msg_data );
356:
357: END;
358:

Line 396: FND_MSG_PUB.initialize;

392: END IF;
393:
394: -- Check p_init_msg_list
395: IF FND_API.to_Boolean( p_init_msg_list ) THEN
396: FND_MSG_PUB.initialize;
397: END IF;
398:
399: -- Implementation of User Hooks
400: /* Copy all parameters to local variables to be passed to Pre, Post and Business APIs */

Line 510: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

506: AND switch_data_id = p_switch_data_rec.switch_data_id;
507:
508:
509: -- Success Message
510: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
511: THEN
512: FND_MESSAGE.Set_Name('ast', 'API_ROWS_UPDATED');
513: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
514: FND_MESSAGE.Set_Token('NUMBER', 1, FALSE);

Line 515: FND_MSG_PUB.Add;

511: THEN
512: FND_MESSAGE.Set_Name('ast', 'API_ROWS_UPDATED');
513: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
514: FND_MESSAGE.Set_Token('NUMBER', 1, FALSE);
515: FND_MSG_PUB.Add;
516: END IF;
517:
518:
519: -- Success Message

Line 520: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) and

516: END IF;
517:
518:
519: -- Success Message
520: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) and
521: x_return_status = FND_API.G_RET_STS_SUCCESS
522: THEN
523: FND_MESSAGE.Set_Name('ast', 'API_SUCCESS');
524: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);

Line 525: FND_MSG_PUB.Add;

521: x_return_status = FND_API.G_RET_STS_SUCCESS
522: THEN
523: FND_MESSAGE.Set_Name('ast', 'API_SUCCESS');
524: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
525: FND_MSG_PUB.Add;
526: END IF;
527: -- END of API body
528:
529:

Line 569: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

565: COMMIT WORK;
566: END IF;
567:
568: -- Debug Message
569: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
570: THEN
571: FND_MESSAGE.Set_Name('ast', 'Pvt WebAssist API: End');
572: FND_MSG_PUB.Add;
573: END IF;

Line 572: FND_MSG_PUB.Add;

568: -- Debug Message
569: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
570: THEN
571: FND_MESSAGE.Set_Name('ast', 'Pvt WebAssist API: End');
572: FND_MSG_PUB.Add;
573: END IF;
574:
575: -- Standard call to get message count and IF count is 1, get message info.
576: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 576: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

572: FND_MSG_PUB.Add;
573: END IF;
574:
575: -- Standard call to get message count and IF count is 1, get message info.
576: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
577: p_data => x_msg_data );
578:
579:
580: --

Line 590: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

586:
587: ROLLBACK TO Update_WebSwitch_PVT;
588: x_return_status := FND_API.G_RET_STS_ERROR ;
589:
590: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
591: p_data => x_msg_data );
592:
593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
594:

Line 598: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

594:
595: ROLLBACK TO Update_WebSwitch_PVT;
596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
597:
598: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
599: p_data => x_msg_data );
600:
601: WHEN OTHERS THEN
602:

Line 606: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

602:
603: ROLLBACK TO Update_WebSwitch_PVT;
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
605:
606: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
607: THEN
608: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
609: END IF;
610:

Line 608: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
605:
606: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
607: THEN
608: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
609: END IF;
610:
611: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
612: p_data => x_msg_data );

Line 611: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

607: THEN
608: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
609: END IF;
610:
611: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
612: p_data => x_msg_data );
613:
614: END;
615:

Line 652: FND_MSG_PUB.initialize;

648: END IF;
649:
650: -- Check p_init_msg_list
651: IF FND_API.to_Boolean( p_init_msg_list ) THEN
652: FND_MSG_PUB.initialize;
653: END IF;
654:
655: -- Implementation of User Hooks
656: /* Copy all parameters to local variables to be passed to Pre, Post and Business APIs */

Line 726: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

722: END;
723:
724:
725: -- Success Message
726: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
727: THEN
728: FND_MESSAGE.Set_Name('ast', 'API_ROWS_UPDATED');
729: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
730: FND_MESSAGE.Set_Token('NUMBER', 1, FALSE);

Line 731: FND_MSG_PUB.Add;

727: THEN
728: FND_MESSAGE.Set_Name('ast', 'API_ROWS_UPDATED');
729: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
730: FND_MESSAGE.Set_Token('NUMBER', 1, FALSE);
731: FND_MSG_PUB.Add;
732: END IF;
733:
734: /* Vertical Post Processing section - mandatory */
735: IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V' ) ) THEN

Line 770: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) and

766: END IF;
767: END IF;
768:
769: -- Success Message
770: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) and
771: x_return_status = FND_API.G_RET_STS_SUCCESS
772: THEN
773: FND_MESSAGE.Set_Name('ast', 'API_SUCCESS');
774: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);

Line 775: FND_MSG_PUB.Add;

771: x_return_status = FND_API.G_RET_STS_SUCCESS
772: THEN
773: FND_MESSAGE.Set_Name('ast', 'API_SUCCESS');
774: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
775: FND_MSG_PUB.Add;
776: END IF;
777: -- END of API body
778:
779:

Line 787: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

783: COMMIT WORK;
784: END IF;
785:
786: -- Debug Message
787: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
788: THEN
789: FND_MESSAGE.Set_Name('ast', 'Pvt WebAssist API: End');
790: FND_MSG_PUB.Add;
791: END IF;

Line 790: FND_MSG_PUB.Add;

786: -- Debug Message
787: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
788: THEN
789: FND_MESSAGE.Set_Name('ast', 'Pvt WebAssist API: End');
790: FND_MSG_PUB.Add;
791: END IF;
792:
793: -- Standard call to get message count and IF count is 1, get message info.
794: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 794: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

790: FND_MSG_PUB.Add;
791: END IF;
792:
793: -- Standard call to get message count and IF count is 1, get message info.
794: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
795: p_data => x_msg_data );
796:
797:
798: --

Line 808: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

804:
805: ROLLBACK TO Lock_WebSwitch_PVT;
806: x_return_status := FND_API.G_RET_STS_ERROR ;
807:
808: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
809: p_data => x_msg_data );
810:
811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
812:

Line 816: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

812:
813: ROLLBACK TO Lock_WebSwitch_PVT;
814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
815:
816: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
817: p_data => x_msg_data );
818:
819: WHEN OTHERS THEN
820:

Line 824: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

820:
821: ROLLBACK TO Lock_WebSwitch_PVT;
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
823:
824: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
825: THEN
826: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
827: END IF;
828:

Line 826: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
823:
824: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
825: THEN
826: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
827: END IF;
828:
829: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
830: p_data => x_msg_data );

Line 829: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

825: THEN
826: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
827: END IF;
828:
829: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
830: p_data => x_msg_data );
831:
832: END;
833:

Line 871: FND_MSG_PUB.initialize;

867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
868: END IF;
869: -- Check p_init_msg_list
870: IF FND_API.to_Boolean( p_init_msg_list ) THEN
871: FND_MSG_PUB.initialize;
872: END IF;
873:
874: -- Implementation of User Hooks
875: /* Copy all parameters to local variables to be passed to Pre, Post and Business APIs */

Line 932: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

928: END IF;
929:
930:
931: -- Success Message
932: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
933: THEN
934: FND_MESSAGE.Set_Name('ast', 'API_ROWS_UPDATED');
935: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
936: FND_MESSAGE.Set_Token('NUMBER', 1, FALSE);

Line 937: FND_MSG_PUB.Add;

933: THEN
934: FND_MESSAGE.Set_Name('ast', 'API_ROWS_UPDATED');
935: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
936: FND_MESSAGE.Set_Token('NUMBER', 1, FALSE);
937: FND_MSG_PUB.Add;
938: END IF;
939:
940:
941: -- Success Message

Line 942: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) and

938: END IF;
939:
940:
941: -- Success Message
942: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) and
943: x_return_status = FND_API.G_RET_STS_SUCCESS
944: THEN
945: FND_MESSAGE.Set_Name('ast', 'API_SUCCESS');
946: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);

Line 947: FND_MSG_PUB.Add;

943: x_return_status = FND_API.G_RET_STS_SUCCESS
944: THEN
945: FND_MESSAGE.Set_Name('ast', 'API_SUCCESS');
946: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
947: FND_MSG_PUB.Add;
948: END IF;
949: -- END of API body
950:
951: /* Vertical Post Processing section - mandatory */

Line 990: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

986: COMMIT WORK;
987: END IF;
988:
989: -- Debug Message
990: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
991: THEN
992: FND_MESSAGE.Set_Name('ast', 'Pvt WebAssist API: End');
993: FND_MSG_PUB.Add;
994: END IF;

Line 993: FND_MSG_PUB.Add;

989: -- Debug Message
990: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
991: THEN
992: FND_MESSAGE.Set_Name('ast', 'Pvt WebAssist API: End');
993: FND_MSG_PUB.Add;
994: END IF;
995:
996: -- Standard call to get message count and IF count is 1, get message info.
997: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 997: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

993: FND_MSG_PUB.Add;
994: END IF;
995:
996: -- Standard call to get message count and IF count is 1, get message info.
997: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
998: p_data => x_msg_data );
999:
1000:
1001: --

Line 1011: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1007:
1008: ROLLBACK TO Delete_WebSwitch_PUB;
1009: x_return_status := FND_API.G_RET_STS_ERROR ;
1010:
1011: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1012: p_data => x_msg_data );
1013:
1014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1015:

Line 1019: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1015:
1016: ROLLBACK TO Delete_WebSwitch_PUB;
1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1018:
1019: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1020: p_data => x_msg_data );
1021:
1022: WHEN OTHERS THEN
1023:

Line 1027: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1023:
1024: ROLLBACK TO Delete_WebSwitch_PUB;
1025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1026:
1027: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1028: THEN
1029: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1030: END IF;
1031:

Line 1029: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1026:
1027: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1028: THEN
1029: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1030: END IF;
1031:
1032: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1033: p_data => x_msg_data );

Line 1032: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1028: THEN
1029: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1030: END IF;
1031:
1032: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1033: p_data => x_msg_data );
1034:
1035: END;
1036: