DBA Data[Home] [Help]

APPS.CSD_REPAIRS_GRP dependencies on FND_MSG_PUB

Line 138: FND_MSG_PUB.initialize;

134: --
135: -- Initialize message list if p_init_msg_list is set to TRUE.
136: IF FND_API.to_Boolean(p_init_msg_list)
137: THEN
138: FND_MSG_PUB.initialize;
139: END IF;
140: -- Initialize API return status to success
141: x_return_status := FND_API.G_RET_STS_SUCCESS;
142: --

Line 262: FND_MSG_PUB.Count_And_Get

258: THEN
259: COMMIT WORK;
260: END IF;
261: -- Standard call to get message count and if count is 1, get message info.
262: FND_MSG_PUB.Count_And_Get
263: (p_count => x_msg_count,
264: p_data => x_msg_data
265: );
266: --

Line 272: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

268: WHEN FND_API.G_EXC_ERROR THEN
269: JTF_PLSQL_API.HANDLE_EXCEPTIONS
270: (P_API_NAME => L_API_NAME
271: ,P_PKG_NAME => G_PKG_NAME
272: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
273: ,P_PACKAGE_TYPE => '_GRP'
274: ,X_MSG_COUNT => X_MSG_COUNT
275: ,X_MSG_DATA => X_MSG_DATA
276: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 283: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: JTF_PLSQL_API.HANDLE_EXCEPTIONS
281: (P_API_NAME => L_API_NAME
282: ,P_PKG_NAME => G_PKG_NAME
283: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
284: ,P_PACKAGE_TYPE => '_GRP'
285: ,X_MSG_COUNT => X_MSG_COUNT
286: ,X_MSG_DATA => X_MSG_DATA
287: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 402: FND_MSG_PUB.initialize;

398: --
399: -- Initialize message list if p_init_msg_list is set to TRUE.
400: IF FND_API.to_Boolean( p_init_msg_list )
401: THEN
402: FND_MSG_PUB.initialize;
403: END IF;
404: -- Initialize API return status to success
405: x_return_status := FND_API.G_RET_STS_SUCCESS;
406: --

Line 518: FND_MSG_PUB.Count_And_Get

514: THEN
515: COMMIT WORK;
516: END IF;
517: -- Standard call to get message count and if count is 1, get message info.
518: FND_MSG_PUB.Count_And_Get
519: (p_count => x_msg_count,
520: p_data => x_msg_data
521: );
522: --

Line 528: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

524: WHEN FND_API.G_EXC_ERROR THEN
525: JTF_PLSQL_API.HANDLE_EXCEPTIONS
526: (P_API_NAME => L_API_NAME
527: ,P_PKG_NAME => G_PKG_NAME
528: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
529: ,P_PACKAGE_TYPE => '_GRP'
530: ,X_MSG_COUNT => X_MSG_COUNT
531: ,X_MSG_DATA => X_MSG_DATA
532: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 539: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
536: JTF_PLSQL_API.HANDLE_EXCEPTIONS
537: (P_API_NAME => L_API_NAME
538: ,P_PKG_NAME => G_PKG_NAME
539: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
540: ,P_PACKAGE_TYPE => '_GRP'
541: ,X_MSG_COUNT => X_MSG_COUNT
542: ,X_MSG_DATA => X_MSG_DATA
543: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 790: FND_MSG_PUB.Count_And_Get

786: --
787: -- travi commit;
788: --
789: -- Standard call to get message count and if count is 1, get message info.
790: FND_MSG_PUB.Count_And_Get
791: (p_count => x_msg_count,
792: p_data => x_msg_data
793: );
794: --

Line 800: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

796: WHEN FND_API.G_EXC_ERROR THEN
797: JTF_PLSQL_API.HANDLE_EXCEPTIONS
798: (P_API_NAME => L_API_NAME
799: ,P_PKG_NAME => G_PKG_NAME
800: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
801: ,P_PACKAGE_TYPE => '_GRP'
802: ,X_MSG_COUNT => X_MSG_COUNT
803: ,X_MSG_DATA => X_MSG_DATA
804: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 811: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
808: JTF_PLSQL_API.HANDLE_EXCEPTIONS
809: (P_API_NAME => L_API_NAME
810: ,P_PKG_NAME => G_PKG_NAME
811: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
812: ,P_PACKAGE_TYPE => '_GRP'
813: ,X_MSG_COUNT => X_MSG_COUNT
814: ,X_MSG_DATA => X_MSG_DATA
815: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1023: FND_MSG_PUB.Count_And_Get

1019: --
1020: -- travi commit;
1021: --
1022: -- Standard call to get message count and if count is 1, get message info.
1023: FND_MSG_PUB.Count_And_Get
1024: (p_count => x_msg_count,
1025: p_data => x_msg_data
1026: );
1027: --

Line 1033: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1029: WHEN FND_API.G_EXC_ERROR THEN
1030: JTF_PLSQL_API.HANDLE_EXCEPTIONS
1031: (P_API_NAME => L_API_NAME
1032: ,P_PKG_NAME => G_PKG_NAME
1033: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1034: ,P_PACKAGE_TYPE => '_GRP'
1035: ,X_MSG_COUNT => X_MSG_COUNT
1036: ,X_MSG_DATA => X_MSG_DATA
1037: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1044: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1041: JTF_PLSQL_API.HANDLE_EXCEPTIONS
1042: (P_API_NAME => L_API_NAME
1043: ,P_PKG_NAME => G_PKG_NAME
1044: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1045: ,P_PACKAGE_TYPE => '_GRP'
1046: ,X_MSG_COUNT => X_MSG_COUNT
1047: ,X_MSG_DATA => X_MSG_DATA
1048: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1144: FND_MSG_PUB.initialize;

1140: -- Initialize message list if p_init_msg_list is set to TRUE.
1141: ---------------------------------------------------------------
1142: IF FND_API.to_Boolean(p_init_msg_list)
1143: THEN
1144: FND_MSG_PUB.initialize;
1145: END IF;
1146:
1147: --------------------------------------------
1148: -- Initialize API return status to success

Line 1379: FND_MSG_PUB.Count_And_Get

1375:
1376: ---------------------------------------------------------------------------
1377: -- Standard call to get message count and if count is 1, get message info.
1378: ---------------------------------------------------------------------------
1379: FND_MSG_PUB.Count_And_Get
1380: (p_count => x_msg_count,
1381: p_data => x_msg_data);
1382:
1383: EXCEPTION

Line 1387: FND_MSG_PUB.Count_And_Get

1383: EXCEPTION
1384: WHEN FND_API.G_EXC_ERROR THEN
1385: x_return_status := FND_API.G_RET_STS_ERROR ;
1386: ROLLBACK TO UPDATE_GRP_APPV_STATUS;
1387: FND_MSG_PUB.Count_And_Get
1388: (p_count => x_msg_count,
1389: p_data => x_msg_data );
1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1393: FND_MSG_PUB.Count_And_Get

1389: p_data => x_msg_data );
1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1392: ROLLBACK TO UPDATE_GRP_APPV_STATUS;
1393: FND_MSG_PUB.Count_And_Get
1394: ( p_count => x_msg_count,
1395: p_data => x_msg_data );
1396: WHEN OTHERS THEN
1397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1399: IF FND_MSG_PUB.Check_Msg_Level

1395: p_data => x_msg_data );
1396: WHEN OTHERS THEN
1397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1398: ROLLBACK TO UPDATE_GRP_APPV_STATUS;
1399: IF FND_MSG_PUB.Check_Msg_Level
1400: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1401: THEN
1402: FND_MSG_PUB.Add_Exc_Msg
1403: (G_PKG_NAME ,

Line 1400: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1396: WHEN OTHERS THEN
1397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1398: ROLLBACK TO UPDATE_GRP_APPV_STATUS;
1399: IF FND_MSG_PUB.Check_Msg_Level
1400: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1401: THEN
1402: FND_MSG_PUB.Add_Exc_Msg
1403: (G_PKG_NAME ,
1404: l_api_name );

Line 1402: FND_MSG_PUB.Add_Exc_Msg

1398: ROLLBACK TO UPDATE_GRP_APPV_STATUS;
1399: IF FND_MSG_PUB.Check_Msg_Level
1400: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1401: THEN
1402: FND_MSG_PUB.Add_Exc_Msg
1403: (G_PKG_NAME ,
1404: l_api_name );
1405: END IF;
1406: FND_MSG_PUB.Count_And_Get

Line 1406: FND_MSG_PUB.Count_And_Get

1402: FND_MSG_PUB.Add_Exc_Msg
1403: (G_PKG_NAME ,
1404: l_api_name );
1405: END IF;
1406: FND_MSG_PUB.Count_And_Get
1407: (p_count => x_msg_count,
1408: p_data => x_msg_data );
1409:
1410: END Update_Group_Approval_Status;

Line 1492: FND_MSG_PUB.initialize;

1488: -- Initialize message list if p_init_msg_list is set to TRUE.
1489: ---------------------------------------------------------------
1490: IF FND_API.to_Boolean(p_init_msg_list)
1491: THEN
1492: FND_MSG_PUB.initialize;
1493: END IF;
1494:
1495: --------------------------------------------
1496: -- Initialize API return status to success

Line 1727: FND_MSG_PUB.Count_And_Get

1723:
1724: ---------------------------------------------------------------------------
1725: -- Standard call to get message count and if count is 1, get message info.
1726: ---------------------------------------------------------------------------
1727: FND_MSG_PUB.Count_And_Get
1728: (p_count => x_msg_count,
1729: p_data => x_msg_data
1730: );
1731:

Line 1736: FND_MSG_PUB.Count_And_Get

1732: EXCEPTION
1733: WHEN FND_API.G_EXC_ERROR THEN
1734: x_return_status := FND_API.G_RET_STS_ERROR ;
1735: ROLLBACK TO UPDATE_GRP_REJT_STATUS;
1736: FND_MSG_PUB.Count_And_Get
1737: (p_count => x_msg_count,
1738: p_data => x_msg_data );
1739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1742: FND_MSG_PUB.Count_And_Get

1738: p_data => x_msg_data );
1739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1741: ROLLBACK TO UPDATE_GRP_REJT_STATUS;
1742: FND_MSG_PUB.Count_And_Get
1743: ( p_count => x_msg_count,
1744: p_data => x_msg_data );
1745: WHEN OTHERS THEN
1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1748: IF FND_MSG_PUB.Check_Msg_Level

1744: p_data => x_msg_data );
1745: WHEN OTHERS THEN
1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1747: ROLLBACK TO UPDATE_GRP_REJT_STATUS;
1748: IF FND_MSG_PUB.Check_Msg_Level
1749: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1750: THEN
1751: FND_MSG_PUB.Add_Exc_Msg
1752: (G_PKG_NAME ,

Line 1749: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1745: WHEN OTHERS THEN
1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1747: ROLLBACK TO UPDATE_GRP_REJT_STATUS;
1748: IF FND_MSG_PUB.Check_Msg_Level
1749: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1750: THEN
1751: FND_MSG_PUB.Add_Exc_Msg
1752: (G_PKG_NAME ,
1753: l_api_name );

Line 1751: FND_MSG_PUB.Add_Exc_Msg

1747: ROLLBACK TO UPDATE_GRP_REJT_STATUS;
1748: IF FND_MSG_PUB.Check_Msg_Level
1749: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1750: THEN
1751: FND_MSG_PUB.Add_Exc_Msg
1752: (G_PKG_NAME ,
1753: l_api_name );
1754: END IF;
1755: FND_MSG_PUB.Count_And_Get

Line 1755: FND_MSG_PUB.Count_And_Get

1751: FND_MSG_PUB.Add_Exc_Msg
1752: (G_PKG_NAME ,
1753: l_api_name );
1754: END IF;
1755: FND_MSG_PUB.Count_And_Get
1756: (p_count => x_msg_count,
1757: p_data => x_msg_data );
1758:
1759: --