DBA Data[Home] [Help]

APPS.FEM_DIM_UTILS_PVT dependencies on FND_MSG_PUB

Line 838: FND_MSG_PUB.initialize ;

834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
835: END IF;
836:
837: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
838: FND_MSG_PUB.initialize ;
839: END IF;
840:
841: p_return_status := FND_API.G_RET_STS_SUCCESS ;
842:

Line 905: FND_MSG_PUB.add;

901: IF l_dummy = 1 THEN
902:
903: FND_MESSAGE.SET_NAME('FEM', 'FEM_DHM_DUP_OBJECT_NAME');
904: FND_MESSAGE.SET_TOKEN('OBJECT_NAME', l_member_name );
905: FND_MSG_PUB.add;
906:
907: END IF;
908: END IF;
909:

Line 950: FND_MSG_PUB.add;

946: IF l_dummy = 2 THEN
947:
948: FND_MESSAGE.SET_NAME('FEM','FEM_DHM_DUP_OBJECT_NAME');
949: FND_MESSAGE.SET_TOKEN('OBJECT_NAME', 'Member Display Code');
950: FND_MSG_PUB.add;
951:
952: END IF;
953:
954: END IF;

Line 964: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

960: IF l_dummy <> 0 THEN
961: raise FND_API.G_EXC_ERROR;
962: END IF;
963:
964: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
965: p_data => p_msg_data );
966:
967: EXCEPTION
968:

Line 972: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

968:
969: WHEN FND_API.G_EXC_ERROR THEN
970:
971: p_return_status := FND_API.G_RET_STS_ERROR;
972: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
973: p_data => p_msg_data );
974:
975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
976:

Line 978: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

974:
975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
976:
977: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
979: p_data => p_msg_data );
980:
981: WHEN OTHERS THEN
982:

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

981: WHEN OTHERS THEN
982:
983: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
984:
985: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
986: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
987: l_api_name);
988: END IF;
989:

Line 986: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

982:
983: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
984:
985: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
986: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
987: l_api_name);
988: END IF;
989:
990: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 990: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

986: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
987: l_api_name);
988: END IF;
989:
990: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
991: p_data => p_msg_data );
992:
993: END Check_Unique_Member;
994: /*---------------------------------------------------------------------------*/

Line 1054: FND_MSG_PUB.initialize ;

1050:
1051: l_member_id := p_member_id;
1052:
1053: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1054: FND_MSG_PUB.initialize ;
1055: END IF;
1056: --
1057: p_return_status := FND_API.G_RET_STS_SUCCESS ;
1058:

Line 5007: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

5003: IF FND_API.To_Boolean ( p_commit ) THEN
5004: COMMIT WORK;
5005: END iF;
5006: --
5007: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5008: p_data => p_msg_data );
5009: --
5010: EXCEPTION
5011: --

Line 5017: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

5013: WHEN FND_API.G_EXC_ERROR THEN
5014: --
5015: ROLLBACK TO Insert_Row_Pvt ;
5016: p_return_status := FND_API.G_RET_STS_ERROR;
5017: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5018: p_data => p_msg_data );
5019: --
5020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5021: --

Line 5024: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

5020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5021: --
5022: ROLLBACK TO Insert_Row_Pvt ;
5023: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5024: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5025: p_data => p_msg_data );
5026: --
5027: WHEN OTHERS THEN
5028:

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

5028:
5029: ROLLBACK TO Insert_Row_Pvt ;
5030: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5031: --
5032: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5033: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5034: l_api_name);
5035: END IF;
5036: --

Line 5033: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

5029: ROLLBACK TO Insert_Row_Pvt ;
5030: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5031: --
5032: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5033: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5034: l_api_name);
5035: END IF;
5036: --
5037: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 5037: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

5033: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5034: l_api_name);
5035: END IF;
5036: --
5037: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5038: p_data => p_msg_data );
5039: -- End of bug 3901421: Add the proper error handling message
5040: --
5041: END Member_Insert_Row;

Line 5086: FND_MSG_PUB.initialize ;

5082: SAVEPOINT Update_Row_Pvt ;
5083: --
5084:
5085: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
5086: FND_MSG_PUB.initialize ;
5087: END IF;
5088: --
5089: p_return_status := FND_API.G_RET_STS_SUCCESS ;
5090:

Line 8939: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

8935: IF FND_API.To_Boolean ( p_commit ) THEN
8936: COMMIT WORK;
8937: END iF;
8938: --
8939: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
8940: p_data => p_msg_data );
8941: --
8942: EXCEPTION
8943: --

Line 8948: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

8944: WHEN FND_API.G_EXC_ERROR THEN
8945: --
8946: ROLLBACK TO Update_Row_Pvt ;
8947: p_return_status := FND_API.G_RET_STS_ERROR;
8948: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
8949: p_data => p_msg_data );
8950: --
8951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8952: --

Line 8955: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

8951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8952: --
8953: ROLLBACK TO Update_Row_Pvt ;
8954: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8955: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
8956: p_data => p_msg_data );
8957: --
8958: WHEN OTHERS THEN
8959: --

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

8959: --
8960: ROLLBACK TO Update_Row_Pvt ;
8961: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8962: -- Bug 39014213901421: Add Message
8963: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8964: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
8965: l_api_name);
8966: END IF;
8967: --

Line 8964: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

8960: ROLLBACK TO Update_Row_Pvt ;
8961: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8962: -- Bug 39014213901421: Add Message
8963: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8964: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
8965: l_api_name);
8966: END IF;
8967: --
8968: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 8968: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

8964: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
8965: l_api_name);
8966: END IF;
8967: --
8968: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
8969: p_data => p_msg_data );
8970: --
8971: END Member_Update_Row;
8972: /*---------------------------------------------------------------------------*/

Line 9003: FND_MSG_PUB.initialize ;

8999: --
9000: SAVEPOINT Delete_Row_Pvt ;
9001:
9002: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
9003: FND_MSG_PUB.initialize ;
9004: END IF;
9005: --
9006: p_return_status := FND_API.G_RET_STS_SUCCESS ;
9007:

Line 9260: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

9256: IF FND_API.To_Boolean ( p_commit ) THEN
9257: COMMIT WORK;
9258: END IF;
9259: --
9260: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
9261: p_data => p_msg_data );
9262: --
9263: EXCEPTION
9264: --

Line 9269: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

9265: WHEN FND_API.G_EXC_ERROR THEN
9266: --
9267: ROLLBACK TO Delete_Row_Pvt ;
9268: p_return_status := FND_API.G_RET_STS_ERROR;
9269: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
9270: p_data => p_msg_data );
9271: --
9272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9273: --

Line 9276: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

9272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9273: --
9274: ROLLBACK TO Delete_Row_Pvt ;
9275: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9276: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
9277: p_data => p_msg_data );
9278: --
9279: WHEN OTHERS THEN
9280: --

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

9280: --
9281: ROLLBACK TO Delete_Row_Pvt ;
9282: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9283: --
9284: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9285: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
9286: 'Member_Delete_Row') ;
9287: END IF;
9288: --

Line 9285: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

9281: ROLLBACK TO Delete_Row_Pvt ;
9282: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9283: --
9284: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9285: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
9286: 'Member_Delete_Row') ;
9287: END IF;
9288: --
9289: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 9289: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

9285: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
9286: 'Member_Delete_Row') ;
9287: END IF;
9288: --
9289: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
9290: p_data => p_msg_data );
9291: --
9292: END Member_Delete_Row;
9293: /*---------------------------------------------------------------------------*/

Line 9615: FND_MSG_PUB.initialize ;

9611: SAVEPOINT Insert_Row_Pvt ;
9612: --
9613:
9614: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
9615: FND_MSG_PUB.initialize ;
9616: END IF;
9617: --
9618: p_return_status := FND_API.G_RET_STS_SUCCESS ;
9619:

Line 9771: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

9767: IF FND_API.To_Boolean ( p_commit ) THEN
9768: COMMIT WORK;
9769: END iF;
9770: --
9771: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
9772: p_data => p_msg_data );
9773: --
9774: EXCEPTION
9775: --

Line 9786: FND_MSG_PUB.ADD;

9782: -- is not allowed
9783: IF(l_multi_assgn_error = 'Y') THEN
9784: FND_MESSAGE.SET_NAME('FEM', 'FEM_DHM_DUP_ATTR_CHECK');
9785: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', l_attribute_name);
9786: FND_MSG_PUB.ADD;
9787: END IF;
9788: -- End Bug#3848813
9789:
9790: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 9790: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

9786: FND_MSG_PUB.ADD;
9787: END IF;
9788: -- End Bug#3848813
9789:
9790: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
9791: p_data => p_msg_data );
9792: --
9793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9794: --

Line 9797: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

9793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9794: --
9795: ROLLBACK TO Insert_Row_Pvt ;
9796: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9797: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
9798: p_data => p_msg_data );
9799: --
9800:
9801: WHEN OTHERS THEN

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

9805:
9806: -- Start Bug#3848813: For cases where unique constraint
9807: -- is violated
9808:
9809: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9810: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
9811: l_api_name);
9812: END IF;
9813:

Line 9810: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

9806: -- Start Bug#3848813: For cases where unique constraint
9807: -- is violated
9808:
9809: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9810: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
9811: l_api_name);
9812: END IF;
9813:
9814: -- End Bug#3848813

Line 9818: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

9814: -- End Bug#3848813
9815:
9816: --
9817: --
9818: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
9819: p_data => p_msg_data );
9820:
9821: END Attribute_Insert_Row;
9822: /*---------------------------------------------------------------------------*/

Line 9868: FND_MSG_PUB.initialize ;

9864: SAVEPOINT Update_Row_Pvt ;
9865: --
9866:
9867: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
9868: FND_MSG_PUB.initialize ;
9869: END IF;
9870: --
9871: p_return_status := FND_API.G_RET_STS_SUCCESS ;
9872:

Line 9961: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

9957: IF FND_API.To_Boolean ( p_commit ) THEN
9958: COMMIT WORK;
9959: END iF;
9960: --
9961: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
9962: p_data => p_msg_data );
9963: --
9964: EXCEPTION
9965: --

Line 9970: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

9966: WHEN FND_API.G_EXC_ERROR THEN
9967: --
9968: ROLLBACK TO Update_Row_Pvt ;
9969: p_return_status := FND_API.G_RET_STS_ERROR;
9970: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
9971: p_data => p_msg_data );
9972: --
9973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9974: --

Line 9977: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

9973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9974: --
9975: ROLLBACK TO Update_Row_Pvt ;
9976: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9977: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
9978: p_data => p_msg_data );
9979: --
9980:
9981: WHEN OTHERS THEN

Line 9988: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

9984: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9985: --
9986:
9987: --
9988: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
9989: p_data => p_msg_data );
9990:
9991:
9992: END Attribute_Update_Row;

Line 10025: FND_MSG_PUB.initialize ;

10021: --
10022: SAVEPOINT Delete_Row_Pvt ;
10023:
10024: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
10025: FND_MSG_PUB.initialize ;
10026: END IF;
10027: --
10028: p_return_status := FND_API.G_RET_STS_SUCCESS ;
10029:

Line 10124: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

10120: IF FND_API.To_Boolean ( p_commit ) THEN
10121: COMMIT WORK;
10122: END iF;
10123: --
10124: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
10125: p_data => p_msg_data );
10126: --
10127: EXCEPTION
10128: --

Line 10133: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

10129: WHEN FND_API.G_EXC_ERROR THEN
10130: --
10131: ROLLBACK TO Delete_Row_Pvt ;
10132: p_return_status := FND_API.G_RET_STS_ERROR;
10133: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
10134: p_data => p_msg_data );
10135: --
10136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10137: --

Line 10140: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

10136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10137: --
10138: ROLLBACK TO Delete_Row_Pvt ;
10139: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10140: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
10141: p_data => p_msg_data );
10142: --
10143:
10144: WHEN OTHERS THEN

Line 10151: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

10147: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10148: --
10149:
10150: --
10151: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
10152: p_data => p_msg_data );
10153:
10154: END Attribute_Delete_Row;
10155: /*---------------------------------------------------------------------------*/

Line 10348: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

10344: --Bug 4370100
10345:
10346: WHEN OTHERS THEN
10347:
10348: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
10349: l_api_name);
10350:
10351:
10352: END Get_Dim_Member_Id;

Line 10400: FND_MSG_PUB.ADD;

10396: WHERE dimension_varchar_label = 'UOM';
10397:
10398: IF l_uom_code IS NULL THEN
10399: FND_MESSAGE.SET_NAME('FEM','FEM_DHM_COST_OBJ_UOM_ERROR');
10400: FND_MSG_PUB.ADD;
10401: RAISE FND_API.G_EXC_ERROR;
10402: END IF;
10403:
10404: END IF;

Line 10508: FND_MSG_PUB.initialize;

10504:
10505: SAVEPOINT Create_Comp_Dim_Mem_Pvt;
10506:
10507: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
10508: FND_MSG_PUB.initialize;
10509: END IF;
10510:
10511: p_return_status := FND_API.G_RET_STS_SUCCESS;
10512:

Line 10575: FND_MSG_PUB.ADD;

10571: WHERE dimension_varchar_label = 'UOM';
10572:
10573: IF l_uom_code IS NULL THEN
10574: FND_MESSAGE.SET_NAME('FEM','FEM_DHM_COST_OBJ_UOM_ERROR');
10575: FND_MSG_PUB.ADD;
10576: RAISE FND_API.G_EXC_ERROR;
10577: END IF;
10578:
10579: END IF;

Line 11101: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

11097: WHEN FND_API.G_EXC_ERROR THEN
11098:
11099: ROLLBACK TO Create_Comp_Dim_Mem_Pvt ;
11100: p_return_status := FND_API.G_RET_STS_ERROR;
11101: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
11102: p_data => p_msg_data );
11103:
11104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11105:

Line 11108: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

11104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11105:
11106: ROLLBACK TO Create_Comp_Dim_Mem_Pvt ;
11107: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11108: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
11109: p_data => p_msg_data );
11110:
11111: WHEN OTHERS THEN
11112:

Line 11115: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

11111: WHEN OTHERS THEN
11112:
11113: ROLLBACK TO Create_Comp_Dim_Mem_Pvt ;
11114: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11115: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
11116: p_data => p_msg_data );
11117:
11118: END Create_Comp_Dim_Member;
11119: /*---------------------------------------------------------------------------*/

Line 11214: FND_MSG_PUB.initialize ;

11210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
11211: END IF;
11212:
11213: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
11214: FND_MSG_PUB.initialize ;
11215: END IF;
11216:
11217: x_return_status := FND_API.G_RET_STS_SUCCESS;
11218:

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

11297: END IF;
11298:
11299: -- End Bug#4096945
11300:
11301: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
11302: p_data => x_msg_data );
11303:
11304:
11305:

Line 11312: IF (FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR))

11308: WHEN FND_API.G_EXC_ERROR THEN
11309:
11310: x_return_status := FND_API.G_RET_STS_ERROR;
11311:
11312: IF (FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR))
11313: THEN
11314:
11315: IF (l_exception_type = l_expt_dates_check)
11316: THEN

Line 11336: FND_MSG_PUB.ADD;

11332: END IF;
11333:
11334: -- End Bug#4096945
11335:
11336: FND_MSG_PUB.ADD;
11337: END IF;
11338:
11339: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
11340: p_data => x_msg_data );

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

11335:
11336: FND_MSG_PUB.ADD;
11337: END IF;
11338:
11339: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
11340: p_data => x_msg_data );
11341:
11342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11343:

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

11342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11343:
11344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11345:
11346: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
11347: p_data => x_msg_data );
11348:
11349: WHEN OTHERS THEN
11350:

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

11349: WHEN OTHERS THEN
11350:
11351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11352:
11353: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11354: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
11355: l_api_name);
11356: END IF;
11357:

Line 11354: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

11350:
11351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11352:
11353: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11354: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
11355: l_api_name);
11356: END IF;
11357:
11358: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

11354: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
11355: l_api_name);
11356: END IF;
11357:
11358: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
11359: p_data => x_msg_data );
11360:
11361: IF chk_ovrlp%ISOPEN THEN
11362: CLOSE chk_ovrlp;