APPS.RRS_SITES_PKG dependencies on FND_MSG_PUB

Line 58: FND_MSG_PUB.INITIALIZE ;

54:
55:
56: BEGIN
57:
58: FND_MSG_PUB.INITIALIZE ;
59: retcode := 'O' ;
60: errbuf := NULL ;
61:
62: IF p_batch_name IS NULL OR p_org_id IS NULL THEN

Line 64: FND_MSG_PUB.Add;

60: errbuf := NULL ;
61:
62: IF p_batch_name IS NULL OR p_org_id IS NULL THEN
63: FND_MESSAGE.Set_Name('RRS','RRS_INV_PARAMETER_PASSED');
64: FND_MSG_PUB.Add;
65: RAISE FND_API.G_EXC_ERROR;
66: END IF ;
67:
68: FOR rec IN UPDATE_ADDRESS_CUR LOOP

Line 115: FND_MSG_PUB.Add;

111: FND_MESSAGE.Set_Name('RRS', 'RRS_NAME_NUMBER_ERR');
112: FND_MESSAGE.Set_Token('NAME', rec.NAME);
113: FND_MESSAGE.Set_Token('NUMBER', rec.SITE_IDENTIFICATION_NUMBER);
114: FND_MESSAGE.Set_Token('MESSAGE', rec.ERROR_MESSAGE);
115: FND_MSG_PUB.Add;
116: END LOOP ;
117:
118: l_msg_count := FND_MSG_PUB.COUNT_MSG;
119:

Line 118: l_msg_count := FND_MSG_PUB.COUNT_MSG;

114: FND_MESSAGE.Set_Token('MESSAGE', rec.ERROR_MESSAGE);
115: FND_MSG_PUB.Add;
116: END LOOP ;
117:
118: l_msg_count := FND_MSG_PUB.COUNT_MSG;
119:
120: IF l_msg_count > 0 THEN
121: errbuf := 'E' ;
122: rollback to call_import ;

Line 135: errbuf := FND_MSG_PUB.GET;

131: END IF ;
132: EXCEPTION
133: WHEN FND_API.G_EXC_ERROR THEN
134: retcode := '2';
135: errbuf := FND_MSG_PUB.GET;
136: RETURN ;
137: WHEN OTHERS THEN
138: retcode := '2';
139: errbuf := SQLERRM;

Line 187: x_msg_count := FND_MSG_PUB.count_msg;

183: END IF;
184:
185: EXCEPTION
186: WHEN FND_API.G_EXC_ERROR THEN
187: x_msg_count := FND_MSG_PUB.count_msg;
188: x_return_status := FND_API.G_RET_STS_ERROR;
189: WHEN OTHERS THEN
190: x_msg_count := FND_MSG_PUB.count_msg;
191: x_return_status := FND_API.G_RET_STS_ERROR;

Line 190: x_msg_count := FND_MSG_PUB.count_msg;

186: WHEN FND_API.G_EXC_ERROR THEN
187: x_msg_count := FND_MSG_PUB.count_msg;
188: x_return_status := FND_API.G_RET_STS_ERROR;
189: WHEN OTHERS THEN
190: x_msg_count := FND_MSG_PUB.count_msg;
191: x_return_status := FND_API.G_RET_STS_ERROR;
192: END CREATE_PROPERTY_LOCATIONS_WRP ;
193:
194: PROCEDURE CREATE_PROPERTY_LOCATIONS_CONC

Line 223: FND_MSG_PUB.Add;

219:
220: -- Throw an error if the request could not be submitted.
221: IF x_request_id = 0 THEN
222: FND_MESSAGE.Set_Name('RRS','RRS_CON_REQUEST_FAILED');
223: FND_MSG_PUB.Add;
224: RAISE FND_API.G_EXC_ERROR;
225: END IF;
226: COMMIT ;
227:

Line 230: x_msg_count := FND_MSG_PUB.COUNT_MSG;

226: COMMIT ;
227:
228: EXCEPTION
229: WHEN FND_API.G_EXC_ERROR THEN
230: x_msg_count := FND_MSG_PUB.COUNT_MSG;
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: WHEN OTHERS THEN
233: x_return_status := 'E' ;
234: x_msg_count := FND_MSG_PUB.COUNT_MSG;

Line 234: x_msg_count := FND_MSG_PUB.COUNT_MSG;

230: x_msg_count := FND_MSG_PUB.COUNT_MSG;
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: WHEN OTHERS THEN
233: x_return_status := 'E' ;
234: x_msg_count := FND_MSG_PUB.COUNT_MSG;
235: END CREATE_PROPERTY_LOCATIONS_CONC ;
236:
237:
238: PROCEDURE DELETE_TEMPLATE