eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_CONSTRUCTION_EST_PVT dependencies on FND_MSG_PUB

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

252: WHEN FND_API.G_EXC_ERROR THEN
253: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
254: x_return_status := FND_API.G_RET_STS_ERROR;
255: debug('FND_API.G_EXC_ERROR Error in API - EXPLODE_INITIAL_ESTIMATE');
256: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
257: p_data => x_msg_data);
258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
259: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
259: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - EXPLODE_INITIAL_ESTIMATE');
262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
263: p_data => x_msg_data);
264: WHEN OTHERS THEN
265: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

264: WHEN OTHERS THEN
265: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267: debug('OTHERS Error in API - EXPLODE_INITIAL_ESTIMATE');
268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
269: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'EXPLODE_INITIAL_ESTIMATE');
270: END IF;
271: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
272: p_data => x_msg_data);

Line 269: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'EXPLODE_INITIAL_ESTIMATE');

265: ROLLBACK TO EXPLODE_INITIAL_ESTIMATE;
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267: debug('OTHERS Error in API - EXPLODE_INITIAL_ESTIMATE');
268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
269: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'EXPLODE_INITIAL_ESTIMATE');
270: END IF;
271: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
272: p_data => x_msg_data);
273:

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

267: debug('OTHERS Error in API - EXPLODE_INITIAL_ESTIMATE');
268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
269: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'EXPLODE_INITIAL_ESTIMATE');
270: END IF;
271: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
272: p_data => x_msg_data);
273:
274: END EXPLODE_INITIAL_ESTIMATE;
275:

Line 297: --FND_MSG_PUB.ADD;

293: IF (p_work_order_line_id IS NULL) THEN
294: --FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
295: --FND_MESSAGE.SET_TOKEN('PARAMETER', 'ORGANIZATION_ID');
296: --FND_MESSAGE.SET_TOKEN('VALUE', p_parent_wo_line_rec.ORGANIZATION_ID);
297: --FND_MSG_PUB.ADD;
298: RAISE FND_API.G_EXC_ERROR;
299: END IF;
300:
301: EAM_CE_WORK_ORDER_LINES_PKG.DELETE_ROW(

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

313: WHEN FND_API.G_EXC_ERROR THEN
314: ROLLBACK TO DELETE_WO_LINE;
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: debug('FND_API.G_EXC_ERROR Error in API - DELETE_WO_LINE');
317: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
318: p_data => x_msg_data);
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: ROLLBACK TO DELETE_WO_LINE;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: ROLLBACK TO DELETE_WO_LINE;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - DELETE_WO_LINE');
323: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
324: p_data => x_msg_data);
325: WHEN OTHERS THEN
326: ROLLBACK TO DELETE_WO_LINE;
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

325: WHEN OTHERS THEN
326: ROLLBACK TO DELETE_WO_LINE;
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328: debug('OTHERS Error in API - DELETE_WO_LINE');
329: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
330: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'DELETE_WO_LINE');
331: END IF;
332: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
333: p_data => x_msg_data);

Line 330: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'DELETE_WO_LINE');

326: ROLLBACK TO DELETE_WO_LINE;
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328: debug('OTHERS Error in API - DELETE_WO_LINE');
329: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
330: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'DELETE_WO_LINE');
331: END IF;
332: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
333: p_data => x_msg_data);
334: END DELETE_WO_LINE;

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

328: debug('OTHERS Error in API - DELETE_WO_LINE');
329: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
330: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'DELETE_WO_LINE');
331: END IF;
332: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
333: p_data => x_msg_data);
334: END DELETE_WO_LINE;
335:
336: PROCEDURE INSERT_PARENT_WO_LINE(

Line 392: FND_MSG_PUB.ADD;

388: IF (p_parent_wo_line_rec.ORGANIZATION_ID IS NULL) THEN
389: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
390: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ORGANIZATION_ID');
391: FND_MESSAGE.SET_TOKEN('VALUE', p_parent_wo_line_rec.ORGANIZATION_ID);
392: FND_MSG_PUB.ADD;
393: RAISE FND_API.G_EXC_ERROR;
394: END IF;
395:
396: IF (p_estimate_id IS NULL) THEN

Line 400: FND_MSG_PUB.ADD;

396: IF (p_estimate_id IS NULL) THEN
397: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
398: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ESTIMATE_NUMBER');
399: FND_MESSAGE.SET_TOKEN('VALUE', p_estimate_id);
400: FND_MSG_PUB.ADD;
401: RAISE FND_API.G_EXC_ERROR;
402: END IF;
403:
404: -- If the parent details already exist, update the estimate

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

746: WHEN FND_API.G_EXC_ERROR THEN
747: ROLLBACK TO INSERT_PARENT_WO_LINE;
748: debug('FND_API.G_EXC_ERROR Error in API - INSERT_PARENT_WO_LINE');
749: x_return_status := FND_API.G_RET_STS_ERROR;
750: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
751: p_data => x_msg_data);
752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
753: ROLLBACK TO INSERT_PARENT_WO_LINE;
754: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - INSERT_PARENT_WO_LINE');

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

752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
753: ROLLBACK TO INSERT_PARENT_WO_LINE;
754: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - INSERT_PARENT_WO_LINE');
755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
756: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
757: p_data => x_msg_data);
758: WHEN OTHERS THEN
759: ROLLBACK TO INSERT_PARENT_WO_LINE;
760: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - INSERT_PARENT_WO_LINE');

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

758: WHEN OTHERS THEN
759: ROLLBACK TO INSERT_PARENT_WO_LINE;
760: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - INSERT_PARENT_WO_LINE');
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
762: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
763: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INSERT_PARENT_WO_LINE');
764: END IF;
765: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
766: p_data => x_msg_data);

Line 763: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INSERT_PARENT_WO_LINE');

759: ROLLBACK TO INSERT_PARENT_WO_LINE;
760: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - INSERT_PARENT_WO_LINE');
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
762: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
763: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INSERT_PARENT_WO_LINE');
764: END IF;
765: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
766: p_data => x_msg_data);
767: END INSERT_PARENT_WO_LINE;

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

761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
762: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
763: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INSERT_PARENT_WO_LINE');
764: END IF;
765: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
766: p_data => x_msg_data);
767: END INSERT_PARENT_WO_LINE;
768:
769: PROCEDURE EXPLODE_STD_OP(

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

970: WHEN FND_API.G_EXC_ERROR THEN
971: --ROLLBACK TO EXPLODE_STD_OP;
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: debug('FND_API.G_EXC_ERROR Error in API - EXPLODE_STD_OP');
974: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
975: p_data => x_msg_data);
976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
977: -- ROLLBACK TO EXPLODE_STD_OP;
978: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - EXPLODE_STD_OP');

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

976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
977: -- ROLLBACK TO EXPLODE_STD_OP;
978: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API - EXPLODE_STD_OP');
979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
980: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
981: p_data => x_msg_data);
982: WHEN OTHERS THEN
983: -- ROLLBACK TO EXPLODE_STD_OP;
984: debug('OTHERS Error in API - EXPLODE_STD_OP');

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

982: WHEN OTHERS THEN
983: -- ROLLBACK TO EXPLODE_STD_OP;
984: debug('OTHERS Error in API - EXPLODE_STD_OP');
985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
986: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
987: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'EXPLODE_STD_OP');
988: END IF;
989: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
990: p_data => x_msg_data);

Line 987: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'EXPLODE_STD_OP');

983: -- ROLLBACK TO EXPLODE_STD_OP;
984: debug('OTHERS Error in API - EXPLODE_STD_OP');
985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
986: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
987: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'EXPLODE_STD_OP');
988: END IF;
989: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
990: p_data => x_msg_data);
991: END EXPLODE_STD_OP;

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

985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
986: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
987: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'EXPLODE_STD_OP');
988: END IF;
989: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
990: p_data => x_msg_data);
991: END EXPLODE_STD_OP;
992:
993:

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

1330: WHEN FND_API.G_EXC_ERROR THEN
1331: ROLLBACK TO INSERT_ALL_WO_LINES;
1332: debug('FND_API.G_EXC_ERROR Error in API INSERT_ALL_WO_LINES');
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1335: p_data => x_msg_data);
1336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1337: ROLLBACK TO INSERT_ALL_WO_LINES;
1338: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API INSERT_ALL_WO_LINES');

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

1336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1337: ROLLBACK TO INSERT_ALL_WO_LINES;
1338: debug('FND_API.G_EXC_UNEXPECTED_ERROR Error in API INSERT_ALL_WO_LINES');
1339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1340: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1341: p_data => x_msg_data);
1342: WHEN OTHERS THEN
1343: ROLLBACK TO INSERT_ALL_WO_LINES;
1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1342: WHEN OTHERS THEN
1343: ROLLBACK TO INSERT_ALL_WO_LINES;
1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1345: debug('OTHERS Error in API INSERT_ALL_WO_LINES');
1346: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1347: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INSERT_ALL_WO_LINES');
1348: END IF;
1349: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1350: p_data => x_msg_data);

Line 1347: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INSERT_ALL_WO_LINES');

1343: ROLLBACK TO INSERT_ALL_WO_LINES;
1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1345: debug('OTHERS Error in API INSERT_ALL_WO_LINES');
1346: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1347: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INSERT_ALL_WO_LINES');
1348: END IF;
1349: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1350: p_data => x_msg_data);
1351: END INSERT_ALL_WO_LINES;

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

1345: debug('OTHERS Error in API INSERT_ALL_WO_LINES');
1346: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1347: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INSERT_ALL_WO_LINES');
1348: END IF;
1349: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1350: p_data => x_msg_data);
1351: END INSERT_ALL_WO_LINES;
1352:
1353: PROCEDURE EXPLODE_CE_ACTIVITIES(

Line 1960: FND_MSG_PUB.INITIALIZE;

1956: END IF;
1957:
1958: --Initialize message list if p_init_msg_list is set to TRUE.
1959: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
1960: FND_MSG_PUB.INITIALIZE;
1961: END IF;
1962:
1963: --Initialize API return status to success
1964: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2015: FND_MSG_PUB.ADD;

2011: EXCEPTION
2012: WHEN OTHERS THEN
2013: FND_MESSAGE.SET_NAME('EAM','EAM_INVALID_CU_ID');
2014: FND_MESSAGE.SET_TOKEN('CU_ID', px_cu_tbl(l_index).CU_ID);
2015: FND_MSG_PUB.ADD;
2016: RAISE FND_API.G_EXC_ERROR;
2017: END;
2018: END LOOP;
2019: END IF;

Line 2024: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

2020: EXCEPTION
2021: WHEN FND_API.G_EXC_ERROR THEN
2022: ROLLBACK TO GET_CU_RECS;
2023: x_return_status := FND_API.G_RET_STS_ERROR;
2024: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2025: p_count => x_msg_count,
2026: p_data => x_msg_data);
2027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2028: ROLLBACK TO GET_CU_RECS;

Line 2030: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

2026: p_data => x_msg_data);
2027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2028: ROLLBACK TO GET_CU_RECS;
2029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2030: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2031: p_count => x_msg_count,
2032: p_data => x_msg_data);
2033: WHEN OTHERS THEN
2034: ROLLBACK TO GET_CU_RECS;

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

2032: p_data => x_msg_data);
2033: WHEN OTHERS THEN
2034: ROLLBACK TO GET_CU_RECS;
2035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2036: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2037: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2038: END IF;
2039: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2040: p_count => x_msg_count,

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

2033: WHEN OTHERS THEN
2034: ROLLBACK TO GET_CU_RECS;
2035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2036: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2037: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2038: END IF;
2039: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2040: p_count => x_msg_count,
2041: p_data => x_msg_data);

Line 2039: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

2035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2036: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2037: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2038: END IF;
2039: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2040: p_count => x_msg_count,
2041: p_data => x_msg_data);
2042: END GET_CU_RECS;
2043:

Line 2085: FND_MSG_PUB.INITIALIZE;

2081: END IF;
2082:
2083: --Initialize message list if p_init_msg_list is set to TRUE.
2084: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
2085: FND_MSG_PUB.INITIALIZE;
2086: END IF;
2087:
2088: --Initialize API return status to success
2089: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2173: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

2169: EXCEPTION
2170: WHEN FND_API.G_EXC_ERROR THEN
2171: ROLLBACK TO GET_CU_ACTIVITIES;
2172: x_return_status := FND_API.G_RET_STS_ERROR;
2173: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2174: p_count => x_msg_count,
2175: p_data => x_msg_data);
2176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2177: ROLLBACK TO GET_CU_ACTIVITIES;

Line 2179: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

2175: p_data => x_msg_data);
2176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2177: ROLLBACK TO GET_CU_ACTIVITIES;
2178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2179: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2180: p_count => x_msg_count,
2181: p_data => x_msg_data);
2182: WHEN OTHERS THEN
2183: ROLLBACK TO GET_CU_ACTIVITIES;

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

2181: p_data => x_msg_data);
2182: WHEN OTHERS THEN
2183: ROLLBACK TO GET_CU_ACTIVITIES;
2184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2185: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2186: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2187: END IF;
2188: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2189: p_count => x_msg_count,

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

2182: WHEN OTHERS THEN
2183: ROLLBACK TO GET_CU_ACTIVITIES;
2184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2185: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2186: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2187: END IF;
2188: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2189: p_count => x_msg_count,
2190: p_data => x_msg_data);

Line 2188: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

2184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2185: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2186: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2187: END IF;
2188: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2189: p_count => x_msg_count,
2190: p_data => x_msg_data);
2191: END GET_CU_ACTIVITIES;
2192:

Line 2225: FND_MSG_PUB.INITIALIZE;

2221: END IF;
2222:
2223: --Initialize message list if p_init_msg_list is set to TRUE.
2224: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
2225: FND_MSG_PUB.INITIALIZE;
2226: END IF;
2227:
2228: --Initialize API return status to success
2229: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2256: FND_MSG_PUB.ADD;

2252: IF (px_estimate_rec.ORGANIZATION_ID IS NULL) THEN
2253: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2254: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ORGANIZATION_ID');
2255: FND_MESSAGE.SET_TOKEN('VALUE', px_estimate_rec.ORGANIZATION_ID);
2256: FND_MSG_PUB.ADD;
2257: RAISE FND_API.G_EXC_ERROR;
2258: END IF;
2259:
2260: IF (px_estimate_rec.ESTIMATE_NUMBER IS NULL) THEN

Line 2264: FND_MSG_PUB.ADD;

2260: IF (px_estimate_rec.ESTIMATE_NUMBER IS NULL) THEN
2261: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2262: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ESTIMATE_NUMBER');
2263: FND_MESSAGE.SET_TOKEN('VALUE', px_estimate_rec.ESTIMATE_NUMBER);
2264: FND_MSG_PUB.ADD;
2265: RAISE FND_API.G_EXC_ERROR;
2266: ELSE
2267: BEGIN
2268: SELECT 'Y'

Line 2280: FND_MSG_PUB.ADD;

2276: END;
2277: IF l_estimate_exist = 'Y' THEN
2278: FND_MESSAGE.SET_NAME('EAM','EAM_ESTIMATE_NAME_UNIQUE');
2279: FND_MESSAGE.SET_TOKEN('ESTIMATE_NAME', px_estimate_rec.ESTIMATE_NUMBER);
2280: FND_MSG_PUB.ADD;
2281: RAISE FND_API.G_EXC_ERROR;
2282: END IF;
2283: END IF;
2284:

Line 2334: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

2330: EXCEPTION
2331: WHEN FND_API.G_EXC_ERROR THEN
2332: ROLLBACK TO CREATE_ESTIMATE;
2333: x_return_status := FND_API.G_RET_STS_ERROR;
2334: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2335: p_count => x_msg_count,
2336: p_data => x_msg_data);
2337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2338: ROLLBACK TO CREATE_ESTIMATE;

Line 2340: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

2336: p_data => x_msg_data);
2337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2338: ROLLBACK TO CREATE_ESTIMATE;
2339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2340: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2341: p_count => x_msg_count,
2342: p_data => x_msg_data);
2343: WHEN OTHERS THEN
2344: ROLLBACK TO CREATE_ESTIMATE;

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

2342: p_data => x_msg_data);
2343: WHEN OTHERS THEN
2344: ROLLBACK TO CREATE_ESTIMATE;
2345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2346: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2347: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2348: END IF;
2349: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2350: p_count => x_msg_count,

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

2343: WHEN OTHERS THEN
2344: ROLLBACK TO CREATE_ESTIMATE;
2345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2346: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2347: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2348: END IF;
2349: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2350: p_count => x_msg_count,
2351: p_data => x_msg_data);

Line 2349: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

2345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2346: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2347: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2348: END IF;
2349: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2350: p_count => x_msg_count,
2351: p_data => x_msg_data);
2352: END CREATE_ESTIMATE;
2353:

Line 2391: FND_MSG_PUB.INITIALIZE;

2387: END IF;
2388:
2389: --Initialize message list if p_init_msg_list is set to TRUE.
2390: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
2391: FND_MSG_PUB.INITIALIZE;
2392: END IF;
2393:
2394: --Initialize API return status to success
2395: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2422: FND_MSG_PUB.ADD;

2418: IF (p_estimate_rec.ESTIMATE_ID IS NULL) THEN
2419: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2420: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ESTIMATE_ID');
2421: FND_MESSAGE.SET_TOKEN('VALUE', p_estimate_rec.ESTIMATE_ID);
2422: FND_MSG_PUB.ADD;
2423: RAISE FND_API.G_EXC_ERROR;
2424: END IF;
2425:
2426: IF (p_estimate_rec.ORGANIZATION_ID IS NULL) THEN

Line 2430: FND_MSG_PUB.ADD;

2426: IF (p_estimate_rec.ORGANIZATION_ID IS NULL) THEN
2427: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2428: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ORGANIZATION_ID');
2429: FND_MESSAGE.SET_TOKEN('VALUE', p_estimate_rec.ORGANIZATION_ID);
2430: FND_MSG_PUB.ADD;
2431: RAISE FND_API.G_EXC_ERROR;
2432: END IF;
2433:
2434: IF (p_estimate_rec.ESTIMATE_NUMBER IS NULL) THEN

Line 2438: FND_MSG_PUB.ADD;

2434: IF (p_estimate_rec.ESTIMATE_NUMBER IS NULL) THEN
2435: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2436: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ESTIMATE_NUMBER');
2437: FND_MESSAGE.SET_TOKEN('VALUE', p_estimate_rec.ESTIMATE_NUMBER);
2438: FND_MSG_PUB.ADD;
2439: RAISE FND_API.G_EXC_ERROR;
2440: ELSE
2441: BEGIN
2442: SELECT 'Y'

Line 2455: FND_MSG_PUB.ADD;

2451: END;
2452: IF l_estimate_exist = 'Y' THEN
2453: FND_MESSAGE.SET_NAME('EAM','EAM_ESTIMATE_NAME_UNIQUE');
2454: FND_MESSAGE.SET_TOKEN('ESTIMATE_NAME', p_estimate_rec.ESTIMATE_NUMBER);
2455: FND_MSG_PUB.ADD;
2456: RAISE FND_API.G_EXC_ERROR;
2457: END IF;
2458: END IF;
2459:

Line 2503: FND_MSG_PUB.Add;

2499:
2500: IF (not l_validate) THEN
2501: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_DESC_FLEX');
2502: FND_MESSAGE.SET_TOKEN('ERROR_MSG', x_error_message);
2503: FND_MSG_PUB.Add;
2504: RAISE FND_API.G_EXC_ERROR;
2505: END IF;
2506:
2507:

Line 2555: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

2551: EXCEPTION
2552: WHEN FND_API.G_EXC_ERROR THEN
2553: ROLLBACK TO UPDATE_ESTIMATE;
2554: x_return_status := FND_API.G_RET_STS_ERROR;
2555: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2556: p_count => x_msg_count,
2557: p_data => x_msg_data);
2558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2559: ROLLBACK TO UPDATE_ESTIMATE;

Line 2561: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

2557: p_data => x_msg_data);
2558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2559: ROLLBACK TO UPDATE_ESTIMATE;
2560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2561: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2562: p_count => x_msg_count,
2563: p_data => x_msg_data);
2564: WHEN OTHERS THEN
2565: ROLLBACK TO UPDATE_ESTIMATE;

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

2563: p_data => x_msg_data);
2564: WHEN OTHERS THEN
2565: ROLLBACK TO UPDATE_ESTIMATE;
2566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2567: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2568: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2569: END IF;
2570: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2571: p_count => x_msg_count,

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

2564: WHEN OTHERS THEN
2565: ROLLBACK TO UPDATE_ESTIMATE;
2566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2567: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2568: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2569: END IF;
2570: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2571: p_count => x_msg_count,
2572: p_data => x_msg_data);

Line 2570: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

2566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2567: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2568: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2569: END IF;
2570: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2571: p_count => x_msg_count,
2572: p_data => x_msg_data);
2573: END UPDATE_ESTIMATE;
2574:

Line 2616: FND_MSG_PUB.INITIALIZE;

2612: END IF;
2613:
2614: --Initialize message list if p_init_msg_list is set to TRUE.
2615: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
2616: FND_MSG_PUB.INITIALIZE;
2617: END IF;
2618:
2619: --Initialize API return status to success
2620: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2658: FND_MSG_PUB.ADD;

2654: --Validate Construction Estimate ID exist
2655: IF p_ce_id IS NULL THEN
2656: FND_MESSAGE.SET_NAME('EAM','EAM_INVALID_CE_ID');
2657: FND_MESSAGE.SET_TOKEN('CE_ID', p_ce_id);
2658: FND_MSG_PUB.ADD;
2659: RAISE FND_API.G_EXC_ERROR;
2660: END IF;
2661:
2662: BEGIN

Line 2673: FND_MSG_PUB.ADD;

2669: EXCEPTION
2670: WHEN OTHERS THEN
2671: FND_MESSAGE.SET_NAME('EAM','EAM_INVALID_CE_ID');
2672: FND_MESSAGE.SET_TOKEN('CE_ID', p_ce_id);
2673: FND_MSG_PUB.ADD;
2674: RAISE FND_API.G_EXC_ERROR;
2675: END;
2676:
2677: IF px_activities_tbl.COUNT > 0 THEN

Line 2685: FND_MSG_PUB.ADD;

2681: IF (px_activities_tbl(l_index).ORGANIZATION_ID IS NOT NULL AND px_activities_tbl(l_index).ORGANIZATION_ID <> l_organization_id) THEN
2682: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2683: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ORGANIZATION_ID');
2684: FND_MESSAGE.SET_TOKEN('VALUE', px_activities_tbl(l_index).ORGANIZATION_ID);
2685: FND_MSG_PUB.ADD;
2686: RAISE FND_API.G_EXC_ERROR;
2687: END IF;
2688:
2689: IF (px_activities_tbl(l_index).ESTIMATE_ID IS NOT NULL AND px_activities_tbl(l_index).ESTIMATE_ID <> l_ce_id) THEN

Line 2693: FND_MSG_PUB.ADD;

2689: IF (px_activities_tbl(l_index).ESTIMATE_ID IS NOT NULL AND px_activities_tbl(l_index).ESTIMATE_ID <> l_ce_id) THEN
2690: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2691: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ESTIMATE_ID');
2692: FND_MESSAGE.SET_TOKEN('VALUE', px_activities_tbl(l_index).ESTIMATE_ID);
2693: FND_MSG_PUB.ADD;
2694: RAISE FND_API.G_EXC_ERROR;
2695: END IF;
2696:
2697: l_cu_id := px_activities_tbl(l_index).CU_ID;

Line 2703: FND_MSG_PUB.ADD;

2699: IF (px_activities_tbl(l_index).CU_QTY IS NULL OR px_activities_tbl(l_index).CU_QTY < 1) THEN
2700: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2701: FND_MESSAGE.SET_TOKEN('PARAMETER', 'CU_QTY');
2702: FND_MESSAGE.SET_TOKEN('VALUE', px_activities_tbl(l_index).CU_QTY);
2703: FND_MSG_PUB.ADD;
2704: RAISE FND_API.G_EXC_ERROR;
2705: END IF;
2706: l_cu_qty := px_activities_tbl(l_index).CU_QTY;
2707:

Line 2712: FND_MSG_PUB.ADD;

2708: /*IF (px_activities_tbl(l_index).ACCT_CLASS_CODE IS NULL) THEN
2709: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2710: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ACCT_CLASS_CODE');
2711: FND_MESSAGE.SET_TOKEN('VALUE', px_activities_tbl(l_index).ACCT_CLASS_CODE);
2712: FND_MSG_PUB.ADD;
2713: RAISE FND_API.G_EXC_ERROR;
2714: END IF;*/
2715: l_acct_class_code := px_activities_tbl(l_index).ACCT_CLASS_CODE;
2716:

Line 2721: FND_MSG_PUB.ADD;

2717: IF (px_activities_tbl(l_index).ACTIVITY_ID IS NULL) THEN
2718: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2719: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ACTIVITY_ID');
2720: FND_MESSAGE.SET_TOKEN('VALUE', px_activities_tbl(l_index).ACTIVITY_ID);
2721: FND_MSG_PUB.ADD;
2722: RAISE FND_API.G_EXC_ERROR;
2723: END IF;
2724: l_activity_id := px_activities_tbl(l_index).ACTIVITY_ID;
2725:

Line 2730: FND_MSG_PUB.ADD;

2726: IF (px_activities_tbl(l_index).ACTIVITY_QTY IS NULL) THEN
2727: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2728: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ACTIVITY_QTY');
2729: FND_MESSAGE.SET_TOKEN('VALUE', px_activities_tbl(l_index).ACTIVITY_QTY);
2730: FND_MSG_PUB.ADD;
2731: RAISE FND_API.G_EXC_ERROR;
2732: END IF;
2733: l_activity_qty := px_activities_tbl(l_index).ACTIVITY_QTY;
2734:

Line 2741: FND_MSG_PUB.ADD;

2737: IF (px_activities_tbl(l_index).RESOURCE_MULTIPLIER IS NULL) THEN
2738: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
2739: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RESOURCE_MULTIPLIER');
2740: FND_MESSAGE.SET_TOKEN('VALUE', px_activities_tbl(l_index).RESOURCE_MULTIPLIER);
2741: FND_MSG_PUB.ADD;
2742: RAISE FND_API.G_EXC_ERROR;
2743: END IF;
2744: l_resource_multiplier := px_activities_tbl(l_index).RESOURCE_MULTIPLIER;
2745: l_est_association_id := NULL;

Line 2784: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

2780: EXCEPTION
2781: WHEN FND_API.G_EXC_ERROR THEN
2782: ROLLBACK TO SET_ACTIVITIES_FOR_CE;
2783: x_return_status := FND_API.G_RET_STS_ERROR;
2784: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2785: p_count => x_msg_count,
2786: p_data => x_msg_data);
2787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2788: ROLLBACK TO SET_ACTIVITIES_FOR_CE;

Line 2790: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

2786: p_data => x_msg_data);
2787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2788: ROLLBACK TO SET_ACTIVITIES_FOR_CE;
2789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2790: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2791: p_count => x_msg_count,
2792: p_data => x_msg_data);
2793: WHEN OTHERS THEN
2794: ROLLBACK TO SET_ACTIVITIES_FOR_CE;

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

2792: p_data => x_msg_data);
2793: WHEN OTHERS THEN
2794: ROLLBACK TO SET_ACTIVITIES_FOR_CE;
2795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2796: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2797: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2798: END IF;
2799: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2800: p_count => x_msg_count,

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

2793: WHEN OTHERS THEN
2794: ROLLBACK TO SET_ACTIVITIES_FOR_CE;
2795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2796: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2797: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2798: END IF;
2799: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2800: p_count => x_msg_count,
2801: p_data => x_msg_data);

Line 2799: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

2795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2796: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2797: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2798: END IF;
2799: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2800: p_count => x_msg_count,
2801: p_data => x_msg_data);
2802: END SET_ACTIVITIES_FOR_CE;
2803:

Line 3121: FND_MSG_PUB.ADD;

3117: ELSE
3118: --Unsupported group option
3119: FND_MESSAGE.SET_NAME('EAM','EAM_UNSUPPORTED_GROUP_OPTION');
3120: FND_MESSAGE.SET_TOKEN('OPTION', p_group_option);
3121: FND_MSG_PUB.ADD;
3122: RAISE FND_API.G_EXC_ERROR;
3123: END IF;
3124: END GET_CE_WO_LNS_BY_GROUP_OPT;
3125:

Line 3181: FND_MSG_PUB.ADD;

3177: AND p_group_option <> 'Construction Unit' THEN
3178: --Unsupported group option
3179: FND_MESSAGE.SET_NAME('EAM','EAM_UNSUPPORTED_GROUP_OPTION');
3180: FND_MESSAGE.SET_TOKEN('OPTION', p_group_option);
3181: FND_MSG_PUB.ADD;
3182: RAISE FND_API.G_EXC_ERROR;
3183: END IF;
3184: END IF;
3185: END LOOP;

Line 3407: FND_MSG_PUB.ADD;

3403: ELSE
3404: --Unsupported group option
3405: FND_MESSAGE.SET_NAME('EAM','EAM_UNSUPPORTED_GROUP_OPTION');
3406: FND_MESSAGE.SET_TOKEN('OPTION', p_group_option);
3407: FND_MSG_PUB.ADD;
3408: RAISE FND_API.G_EXC_ERROR;
3409: END IF;
3410: END LOOP;
3411: END IF;

Line 3443: FND_MSG_PUB.INITIALIZE;

3439: END IF;
3440:
3441: --Initialize message list if p_init_msg_list is set to TRUE.
3442: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
3443: FND_MSG_PUB.INITIALIZE;
3444: END IF;
3445:
3446: --Initialize API return status to success
3447: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3494: FND_MSG_PUB.ADD;

3490: WHEN OTHERS THEN
3491: --Unsupported group option
3492: FND_MESSAGE.SET_NAME('EAM','EAM_ERROR_DERIVE_GROUP_OPTION');
3493: FND_MESSAGE.SET_TOKEN('OPTION_ID', p_ce_wo_defaults.GROUPING_OPTION);
3494: FND_MSG_PUB.ADD;
3495: RAISE FND_API.G_EXC_ERROR;
3496: END;
3497:
3498: IF l_group_option = 'None'

Line 3524: FND_MSG_PUB.ADD;

3520: ELSE
3521: --Unsupported group option
3522: FND_MESSAGE.SET_NAME('EAM','EAM_UNSUPPORTED_GROUP_OPTION');
3523: FND_MESSAGE.SET_TOKEN('OPTION', l_group_option);
3524: FND_MSG_PUB.ADD;
3525: RAISE FND_API.G_EXC_ERROR;
3526: END IF;
3527:
3528: --Now update the wo lines

Line 3614: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

3610: EXCEPTION
3611: WHEN FND_API.G_EXC_ERROR THEN
3612: ROLLBACK TO UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3613: x_return_status := FND_API.G_RET_STS_ERROR;
3614: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3615: p_count => x_msg_count,
3616: p_data => x_msg_data);
3617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3618: ROLLBACK TO UPDATE_CE_WO_LNS_BY_GROUP_OPT;

Line 3620: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

3616: p_data => x_msg_data);
3617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3618: ROLLBACK TO UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3620: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3621: p_count => x_msg_count,
3622: p_data => x_msg_data);
3623: WHEN OTHERS THEN
3624: ROLLBACK TO UPDATE_CE_WO_LNS_BY_GROUP_OPT;

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

3622: p_data => x_msg_data);
3623: WHEN OTHERS THEN
3624: ROLLBACK TO UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3626: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3627: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3628: END IF;
3629: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3630: p_count => x_msg_count,

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

3623: WHEN OTHERS THEN
3624: ROLLBACK TO UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3626: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3627: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3628: END IF;
3629: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3630: p_count => x_msg_count,
3631: p_data => x_msg_data);

Line 3629: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

3625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3626: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3627: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3628: END IF;
3629: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3630: p_count => x_msg_count,
3631: p_data => x_msg_data);
3632: END UPDATE_CE_WO_LNS_BY_GROUP_OPT;
3633:

Line 3803: FND_MSG_PUB.initialize;

3799: -- Initialize message list if p_init_msg_list is set to TRUE
3800: -------------------------------------------------------------------------
3801: --dbms_output.put_line('2');
3802: IF FND_API.to_Boolean(p_init_msg_list) THEN
3803: FND_MSG_PUB.initialize;
3804: END IF;
3805:
3806:
3807: -------------------------------------------------------------------------

Line 4031: FND_MSG_pub.add;

4027: --EAM_CONSTRUCTION_MESSAGE_PVT.debug(l_msg_data);
4028: l_api_message := 'Populate_WO returned error';
4029: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4030: FND_MESSAGE.set_token('TEXT', l_api_message);
4031: FND_MSG_pub.add;
4032: RAISE FND_API.g_exc_error;
4033: END IF;
4034:
4035: l_eam_wo_tbl(1) := l_eam_wo_rec;

Line 4169: FND_MSG_pub.add;

4165: --EAM_CONSTRUCTION_MESSAGE_PVT.debug(l_msg_data);
4166: l_api_message := 'Populate_WO returned error';
4167: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4168: FND_MESSAGE.set_token('TEXT', l_api_message);
4169: FND_MSG_pub.add;
4170: RAISE FND_API.g_exc_error;
4171: END IF;
4172:
4173:

Line 4223: FND_MSG_pub.add;

4219: --EAM_CONSTRUCTION_MESSAGE_PVT.debug(l_msg_data);
4220: l_api_message := 'POPULATE_OPERATION returned error';
4221: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4222: FND_MESSAGE.set_token('TEXT', l_api_message);
4223: FND_MSG_pub.add;
4224: RAISE FND_API.g_exc_error;
4225: END IF;
4226:
4227:

Line 4258: FND_MSG_pub.add;

4254: --EAM_CONSTRUCTION_MESSAGE_PVT.debug(l_msg_data);
4255: l_api_message := 'POPULATE_RESOURCE returned error';
4256: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4257: FND_MESSAGE.set_token('TEXT', l_api_message);
4258: FND_MSG_pub.add;
4259: RAISE FND_API.g_exc_error;
4260: END IF;
4261:
4262:

Line 4293: FND_MSG_pub.add;

4289: --EAM_CONSTRUCTION_MESSAGE_PVT.debug(l_msg_data);
4290: l_api_message := 'POPULATE_MATERIAL returned error';
4291: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4292: FND_MESSAGE.set_token('TEXT', l_api_message);
4293: FND_MSG_pub.add;
4294: RAISE FND_API.g_exc_error;
4295: END IF;
4296:
4297:

Line 4328: FND_MSG_pub.add;

4324: --EAM_CONSTRUCTION_MESSAGE_PVT.debug(l_msg_data);
4325: l_api_message := 'POPULATE_MATERIAL returned error';
4326: --FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
4327: FND_MESSAGE.set_token('TEXT', l_api_message);
4328: FND_MSG_pub.add;
4329: RAISE FND_API.g_exc_error;
4330: END IF;
4331:
4332:

Line 4443: fnd_msg_pub.count_and_get

4439: x_return_status := fnd_api.g_ret_sts_error;
4440: --dbms_output.put_line('exzc');
4441:
4442: -- Get message count and data
4443: fnd_msg_pub.count_and_get
4444: ( p_count => x_msg_count
4445: , p_data => x_msg_data
4446: );
4447: --

Line 4454: fnd_msg_pub.count_and_get

4450: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4451: --dbms_output.put_line('unex');
4452:
4453: -- Get message count and data
4454: fnd_msg_pub.count_and_get
4455: ( p_count => x_msg_count
4456: , p_data => x_msg_data
4457: );
4458: --

Line 4464: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

4460: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4461: --dbms_output.put_line('others' || l_stmt_num);
4462: --
4463: ROLLBACK TO CREATE_CU_WORKORDERS;
4464: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4465: THEN
4466: fnd_msg_pub.add_exc_msg
4467: ( 'EAM_CONSTRUCTION_EST_PVT'
4468: , 'Create_CU_Workorders : l_stmt_num - '||to_char(l_stmt_num)

Line 4466: fnd_msg_pub.add_exc_msg

4462: --
4463: ROLLBACK TO CREATE_CU_WORKORDERS;
4464: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4465: THEN
4466: fnd_msg_pub.add_exc_msg
4467: ( 'EAM_CONSTRUCTION_EST_PVT'
4468: , 'Create_CU_Workorders : l_stmt_num - '||to_char(l_stmt_num)
4469: );
4470:

Line 4473: fnd_msg_pub.count_and_get

4469: );
4470:
4471: END IF;
4472: -- Get message count and data
4473: fnd_msg_pub.count_and_get
4474: ( p_count => x_msg_count
4475: , p_data => x_msg_data
4476: );
4477: END CREATE_CU_WORKORDERS;

Line 4502: fnd_msg_pub.initialize;

4498:
4499: x_return_status := fnd_api.g_ret_sts_success;
4500:
4501: IF fnd_api.to_Boolean(p_init_msg_list) then
4502: fnd_msg_pub.initialize;
4503: end if;
4504:
4505: /* Is this the parent WO record */
4506: /* Not a parent WO record */

Line 4603: FND_MSG_PUB.Count_And_Get (

4599: l_stmt_num := 80;
4600: x_eam_wo_rec := l_eam_wo_rec;
4601:
4602: -- Standard Call to get message count and if count = 1, get message info
4603: FND_MSG_PUB.Count_And_Get (
4604: p_count => x_msg_count,
4605: p_data => x_msg_data );
4606:
4607: -- Print messages to log file

Line 4615: fnd_msg_pub.count_and_get

4611: WHEN fnd_api.g_exc_error THEN
4612: x_return_status := fnd_api.g_ret_sts_error;
4613:
4614: -- Get message count and data
4615: fnd_msg_pub.count_and_get
4616: ( p_count => x_msg_count
4617: , p_data => x_msg_data
4618: );
4619:

Line 4624: fnd_msg_pub.count_and_get

4620: WHEN fnd_api.g_exc_unexpected_error THEN
4621: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4622:
4623: -- Get message count and data
4624: fnd_msg_pub.count_and_get
4625: ( p_count => x_msg_count
4626: , p_data => x_msg_data
4627: );
4628: --

Line 4631: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

4627: );
4628: --
4629: WHEN OTHERS THEN
4630: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4631: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4632: THEN
4633: fnd_msg_pub.add_exc_msg
4634: ( 'EAM_CONSTRUCTION_EST_PVT'
4635: , 'Populate_WO : Statement - '|| to_char(l_stmt_num)

Line 4633: fnd_msg_pub.add_exc_msg

4629: WHEN OTHERS THEN
4630: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4631: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4632: THEN
4633: fnd_msg_pub.add_exc_msg
4634: ( 'EAM_CONSTRUCTION_EST_PVT'
4635: , 'Populate_WO : Statement - '|| to_char(l_stmt_num)
4636: );
4637:

Line 4641: fnd_msg_pub.count_and_get

4637:
4638: END IF;
4639:
4640: -- Get message count and data
4641: fnd_msg_pub.count_and_get
4642: ( p_count => x_msg_count
4643: , p_data => x_msg_data
4644: );
4645:

Line 4663: fnd_msg_pub.initialize;

4659: l_stmt_num NUMBER := 0;
4660: BEGIN
4661:
4662: IF fnd_api.to_Boolean(p_init_msg_list) then
4663: fnd_msg_pub.initialize;
4664: end if;
4665:
4666: x_return_status := fnd_api.g_ret_sts_success;
4667:

Line 4687: FND_MSG_PUB.Count_And_Get (

4683: x_eam_op_rec := l_eam_op_rec;
4684:
4685:
4686: -- Standard Call to get message count and if count = 1, get message info
4687: FND_MSG_PUB.Count_And_Get (
4688: p_count => x_msg_count,
4689: p_data => x_msg_data );
4690:
4691: -- Print messages to log file

Line 4699: fnd_msg_pub.count_and_get

4695: WHEN fnd_api.g_exc_error THEN
4696: x_return_status := fnd_api.g_ret_sts_error;
4697:
4698: -- Get message count and data
4699: fnd_msg_pub.count_and_get
4700: ( p_count => x_msg_count
4701: , p_data => x_msg_data
4702: );
4703:

Line 4708: fnd_msg_pub.count_and_get

4704: WHEN fnd_api.g_exc_unexpected_error THEN
4705: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4706:
4707: -- Get message count and data
4708: fnd_msg_pub.count_and_get
4709: ( p_count => x_msg_count
4710: , p_data => x_msg_data
4711: );
4712: --

Line 4716: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

4712: --
4713: WHEN OTHERS THEN
4714: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4715: --EAM_CONSTRUCTION_MESSAGE_PVT.DEBUG('EAM_CONSTRUCTION_EST_PVT.POPULATE_OPERATION: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
4716: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4717: THEN
4718: fnd_msg_pub.add_exc_msg
4719: ( 'EAM_CONSTRUCTION_EST_PVT'
4720: , 'Populate_WO : Statement - '|| to_char(l_stmt_num)

Line 4718: fnd_msg_pub.add_exc_msg

4714: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4715: --EAM_CONSTRUCTION_MESSAGE_PVT.DEBUG('EAM_CONSTRUCTION_EST_PVT.POPULATE_OPERATION: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
4716: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4717: THEN
4718: fnd_msg_pub.add_exc_msg
4719: ( 'EAM_CONSTRUCTION_EST_PVT'
4720: , 'Populate_WO : Statement - '|| to_char(l_stmt_num)
4721: );
4722:

Line 4726: fnd_msg_pub.count_and_get

4722:
4723: END IF;
4724:
4725: -- Get message count and data
4726: fnd_msg_pub.count_and_get
4727: ( p_count => x_msg_count
4728: , p_data => x_msg_data
4729: );
4730:

Line 4748: fnd_msg_pub.initialize;

4744: l_autocharge NUMBER;
4745: BEGIN
4746:
4747: IF fnd_api.to_Boolean(p_init_msg_list) then
4748: fnd_msg_pub.initialize;
4749: end if;
4750:
4751: x_return_status := fnd_api.g_ret_sts_success;
4752:

Line 4796: FND_MSG_PUB.Count_And_Get (

4792:
4793: x_eam_res_rec := l_eam_res_rec;
4794:
4795: -- Standard Call to get message count and if count = 1, get message info
4796: FND_MSG_PUB.Count_And_Get (
4797: p_count => x_msg_count,
4798: p_data => x_msg_data );
4799:
4800: -- Print messages to log file

Line 4808: fnd_msg_pub.count_and_get

4804: WHEN fnd_api.g_exc_error THEN
4805: x_return_status := fnd_api.g_ret_sts_error;
4806:
4807: -- Get message count and data
4808: fnd_msg_pub.count_and_get
4809: ( p_count => x_msg_count
4810: , p_data => x_msg_data
4811: );
4812:

Line 4817: fnd_msg_pub.count_and_get

4813: WHEN fnd_api.g_exc_unexpected_error THEN
4814: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4815:
4816: -- Get message count and data
4817: fnd_msg_pub.count_and_get
4818: ( p_count => x_msg_count
4819: , p_data => x_msg_data
4820: );
4821: --

Line 4825: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

4821: --
4822: WHEN OTHERS THEN
4823: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4824: --EAM_CONSTRUCTION_MESSAGE_PVT.DEBUG('EAM_CONSTRUCTION_EST_PVT.POPULATE_RESOURCE: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
4825: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4826: THEN
4827: fnd_msg_pub.add_exc_msg
4828: ( 'EAM_CONSTRUCTION_EST_PVT'
4829: , 'POPULATE_RESOURCE : Statement - '|| to_char(l_stmt_num)

Line 4827: fnd_msg_pub.add_exc_msg

4823: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4824: --EAM_CONSTRUCTION_MESSAGE_PVT.DEBUG('EAM_CONSTRUCTION_EST_PVT.POPULATE_RESOURCE: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
4825: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4826: THEN
4827: fnd_msg_pub.add_exc_msg
4828: ( 'EAM_CONSTRUCTION_EST_PVT'
4829: , 'POPULATE_RESOURCE : Statement - '|| to_char(l_stmt_num)
4830: );
4831:

Line 4835: fnd_msg_pub.count_and_get

4831:
4832: END IF;
4833:
4834: -- Get message count and data
4835: fnd_msg_pub.count_and_get
4836: ( p_count => x_msg_count
4837: , p_data => x_msg_data
4838: );
4839:

Line 4858: fnd_msg_pub.initialize;

4854: l_stmt_num NUMBER := 0;
4855: BEGIN
4856:
4857: IF fnd_api.to_Boolean(p_init_msg_list) then
4858: fnd_msg_pub.initialize;
4859: end if;
4860:
4861: x_return_status := fnd_api.g_ret_sts_success;
4862:

Line 4909: FND_MSG_PUB.Count_And_Get (

4905: x_eam_mat_rec := l_eam_mat_rec;
4906: x_eam_direct_rec := l_eam_direct_rec;
4907:
4908: -- Standard Call to get message count and if count = 1, get message info
4909: FND_MSG_PUB.Count_And_Get (
4910: p_count => x_msg_count,
4911: p_data => x_msg_data );
4912:
4913: -- Print messages to log file

Line 4921: fnd_msg_pub.count_and_get

4917: WHEN fnd_api.g_exc_error THEN
4918: x_return_status := fnd_api.g_ret_sts_error;
4919:
4920: -- Get message count and data
4921: fnd_msg_pub.count_and_get
4922: ( p_count => x_msg_count
4923: , p_data => x_msg_data
4924: );
4925:

Line 4930: fnd_msg_pub.count_and_get

4926: WHEN fnd_api.g_exc_unexpected_error THEN
4927: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4928:
4929: -- Get message count and data
4930: fnd_msg_pub.count_and_get
4931: ( p_count => x_msg_count
4932: , p_data => x_msg_data
4933: );
4934: --

Line 4938: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

4934: --
4935: WHEN OTHERS THEN
4936: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4937: --EAM_CONSTRUCTION_MESSAGE_PVT.DEBUG('EAM_CONSTRUCTION_EST_PVT.POPULATE_RESOURCE: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
4938: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4939: THEN
4940: fnd_msg_pub.add_exc_msg
4941: ( 'EAM_CONSTRUCTION_EST_PVT'
4942: , 'POPULATE_RESOURCE : Statement - '|| to_char(l_stmt_num)

Line 4940: fnd_msg_pub.add_exc_msg

4936: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4937: --EAM_CONSTRUCTION_MESSAGE_PVT.DEBUG('EAM_CONSTRUCTION_EST_PVT.POPULATE_RESOURCE: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
4938: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4939: THEN
4940: fnd_msg_pub.add_exc_msg
4941: ( 'EAM_CONSTRUCTION_EST_PVT'
4942: , 'POPULATE_RESOURCE : Statement - '|| to_char(l_stmt_num)
4943: );
4944:

Line 4948: fnd_msg_pub.count_and_get

4944:
4945: END IF;
4946:
4947: -- Get message count and data
4948: fnd_msg_pub.count_and_get
4949: ( p_count => x_msg_count
4950: , p_data => x_msg_data
4951: );
4952:

Line 5005: FND_MSG_PUB.ADD;

5001: IF (p_org_id IS NULL) THEN
5002: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
5003: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ORGANIZATION_ID');
5004: FND_MESSAGE.SET_TOKEN('VALUE', p_org_id);
5005: FND_MSG_PUB.ADD;
5006: RAISE FND_API.G_EXC_ERROR;
5007: END IF;
5008:
5009: IF (p_src_estimate_id IS NULL) THEN

Line 5013: FND_MSG_PUB.ADD;

5009: IF (p_src_estimate_id IS NULL) THEN
5010: FND_MESSAGE.SET_NAME('EAM','EAM_EA_INVALID_PARAM');
5011: FND_MESSAGE.SET_TOKEN('PARAMETER', 'ESTIMATE_ID');
5012: FND_MESSAGE.SET_TOKEN('VALUE', p_src_estimate_id);
5013: FND_MSG_PUB.ADD;
5014: RAISE FND_API.G_EXC_ERROR;
5015: END IF;
5016:
5017: -- Fetch the Estimates Cursor

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

5307: EXCEPTION
5308: WHEN FND_API.G_EXC_ERROR THEN
5309: ROLLBACK TO COPY_EST_WORKBENCH;
5310: x_return_status := FND_API.G_RET_STS_ERROR;
5311: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5312: p_data => x_msg_data);
5313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5314: ROLLBACK TO COPY_EST_WORKBENCH;
5315:

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

5313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5314: ROLLBACK TO COPY_EST_WORKBENCH;
5315:
5316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5317: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5318: p_data => x_msg_data);
5319: WHEN OTHERS THEN
5320: ROLLBACK TO COPY_EST_WORKBENCH;
5321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5318: p_data => x_msg_data);
5319: WHEN OTHERS THEN
5320: ROLLBACK TO COPY_EST_WORKBENCH;
5321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5322: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5323: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'COPY_EST_WORKBENCH');
5324: END IF;
5325: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5326: p_data => x_msg_data);

Line 5323: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'COPY_EST_WORKBENCH');

5319: WHEN OTHERS THEN
5320: ROLLBACK TO COPY_EST_WORKBENCH;
5321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5322: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5323: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'COPY_EST_WORKBENCH');
5324: END IF;
5325: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5326: p_data => x_msg_data);
5327: END COPY_EST_WORKBENCH;

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

5321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5322: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5323: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'COPY_EST_WORKBENCH');
5324: END IF;
5325: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5326: p_data => x_msg_data);
5327: END COPY_EST_WORKBENCH;
5328:
5329: End EAM_CONSTRUCTION_EST_PVT;