DBA Data[Home] [Help]

APPS.CSD_REPAIRS_GRP dependencies on FND_MSG_PUB

Line 137: FND_MSG_PUB.initialize;

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

Line 260: FND_MSG_PUB.Count_And_Get

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

Line 270: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 281: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

Line 399: FND_MSG_PUB.initialize;

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

Line 514: FND_MSG_PUB.Count_And_Get

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

Line 524: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 535: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

Line 786: FND_MSG_PUB.Count_And_Get

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

Line 796: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 807: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

Line 1019: FND_MSG_PUB.Count_And_Get

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

Line 1029: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 1040: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

Line 1140: FND_MSG_PUB.initialize;

1136: -- Initialize message list if p_init_msg_list is set to TRUE.
1137: ---------------------------------------------------------------
1138: IF FND_API.to_Boolean(p_init_msg_list)
1139: THEN
1140: FND_MSG_PUB.initialize;
1141: END IF;
1142:
1143: --------------------------------------------
1144: -- Initialize API return status to success

Line 1375: FND_MSG_PUB.Count_And_Get

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

Line 1383: FND_MSG_PUB.Count_And_Get

1379: EXCEPTION
1380: WHEN FND_API.G_EXC_ERROR THEN
1381: x_return_status := FND_API.G_RET_STS_ERROR ;
1382: ROLLBACK TO UPDATE_GRP_APPV_STATUS;
1383: FND_MSG_PUB.Count_And_Get
1384: (p_count => x_msg_count,
1385: p_data => x_msg_data );
1386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1389: FND_MSG_PUB.Count_And_Get

1385: p_data => x_msg_data );
1386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1388: ROLLBACK TO UPDATE_GRP_APPV_STATUS;
1389: FND_MSG_PUB.Count_And_Get
1390: ( p_count => x_msg_count,
1391: p_data => x_msg_data );
1392: WHEN OTHERS THEN
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1395: IF FND_MSG_PUB.Check_Msg_Level

1391: p_data => x_msg_data );
1392: WHEN OTHERS THEN
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1394: ROLLBACK TO UPDATE_GRP_APPV_STATUS;
1395: IF FND_MSG_PUB.Check_Msg_Level
1396: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1397: THEN
1398: FND_MSG_PUB.Add_Exc_Msg
1399: (G_PKG_NAME ,

Line 1396: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1392: WHEN OTHERS THEN
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1394: ROLLBACK TO UPDATE_GRP_APPV_STATUS;
1395: IF FND_MSG_PUB.Check_Msg_Level
1396: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1397: THEN
1398: FND_MSG_PUB.Add_Exc_Msg
1399: (G_PKG_NAME ,
1400: l_api_name );

Line 1398: FND_MSG_PUB.Add_Exc_Msg

1394: ROLLBACK TO UPDATE_GRP_APPV_STATUS;
1395: IF FND_MSG_PUB.Check_Msg_Level
1396: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1397: THEN
1398: FND_MSG_PUB.Add_Exc_Msg
1399: (G_PKG_NAME ,
1400: l_api_name );
1401: END IF;
1402: FND_MSG_PUB.Count_And_Get

Line 1402: FND_MSG_PUB.Count_And_Get

1398: FND_MSG_PUB.Add_Exc_Msg
1399: (G_PKG_NAME ,
1400: l_api_name );
1401: END IF;
1402: FND_MSG_PUB.Count_And_Get
1403: (p_count => x_msg_count,
1404: p_data => x_msg_data );
1405:
1406: END Update_Group_Approval_Status;

Line 1488: FND_MSG_PUB.initialize;

1484: -- Initialize message list if p_init_msg_list is set to TRUE.
1485: ---------------------------------------------------------------
1486: IF FND_API.to_Boolean(p_init_msg_list)
1487: THEN
1488: FND_MSG_PUB.initialize;
1489: END IF;
1490:
1491: --------------------------------------------
1492: -- Initialize API return status to success

Line 1723: FND_MSG_PUB.Count_And_Get

1719:
1720: ---------------------------------------------------------------------------
1721: -- Standard call to get message count and if count is 1, get message info.
1722: ---------------------------------------------------------------------------
1723: FND_MSG_PUB.Count_And_Get
1724: (p_count => x_msg_count,
1725: p_data => x_msg_data
1726: );
1727:

Line 1732: FND_MSG_PUB.Count_And_Get

1728: EXCEPTION
1729: WHEN FND_API.G_EXC_ERROR THEN
1730: x_return_status := FND_API.G_RET_STS_ERROR ;
1731: ROLLBACK TO UPDATE_GRP_REJT_STATUS;
1732: FND_MSG_PUB.Count_And_Get
1733: (p_count => x_msg_count,
1734: p_data => x_msg_data );
1735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1738: FND_MSG_PUB.Count_And_Get

1734: p_data => x_msg_data );
1735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1737: ROLLBACK TO UPDATE_GRP_REJT_STATUS;
1738: FND_MSG_PUB.Count_And_Get
1739: ( p_count => x_msg_count,
1740: p_data => x_msg_data );
1741: WHEN OTHERS THEN
1742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1744: IF FND_MSG_PUB.Check_Msg_Level

1740: p_data => x_msg_data );
1741: WHEN OTHERS THEN
1742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1743: ROLLBACK TO UPDATE_GRP_REJT_STATUS;
1744: IF FND_MSG_PUB.Check_Msg_Level
1745: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1746: THEN
1747: FND_MSG_PUB.Add_Exc_Msg
1748: (G_PKG_NAME ,

Line 1745: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1741: WHEN OTHERS THEN
1742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1743: ROLLBACK TO UPDATE_GRP_REJT_STATUS;
1744: IF FND_MSG_PUB.Check_Msg_Level
1745: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1746: THEN
1747: FND_MSG_PUB.Add_Exc_Msg
1748: (G_PKG_NAME ,
1749: l_api_name );

Line 1747: FND_MSG_PUB.Add_Exc_Msg

1743: ROLLBACK TO UPDATE_GRP_REJT_STATUS;
1744: IF FND_MSG_PUB.Check_Msg_Level
1745: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1746: THEN
1747: FND_MSG_PUB.Add_Exc_Msg
1748: (G_PKG_NAME ,
1749: l_api_name );
1750: END IF;
1751: FND_MSG_PUB.Count_And_Get

Line 1751: FND_MSG_PUB.Count_And_Get

1747: FND_MSG_PUB.Add_Exc_Msg
1748: (G_PKG_NAME ,
1749: l_api_name );
1750: END IF;
1751: FND_MSG_PUB.Count_And_Get
1752: (p_count => x_msg_count,
1753: p_data => x_msg_data );
1754:
1755: --