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.AHL_ENIGMA_ROUTE_OP_PUB dependencies on FND_MSG_PUB

Line 159: FND_MSG_PUB.INITIALIZE;

155:
156: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
157: IF FND_API.TO_BOOLEAN(p_init_msg_list)
158: THEN
159: FND_MSG_PUB.INITIALIZE;
160: END IF;
161:
162: -- initialise it only if it is a OA Adapter !
163: fnd_global.APPS_INITIALIZE (1003259,62211, 867);

Line 333: FND_MSG_PUB.ADD;

329: -- Validate if the Enigma Route Id is null throw an error if the id is null.
330: IF (p_enigma_route_rec.route_ID IS NULL OR p_enigma_route_rec.ROUTE_ID = FND_API.G_MISS_CHAR)
331: THEN
332: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_ROUTE_ID_NULL');
333: FND_MSG_PUB.ADD;
334: RAISE FND_API.G_EXC_ERROR;
335: END IF;
336:
337: -- Calling the procedure to process the route and operation details passing the input record

Line 360: x_msg_count := FND_MSG_PUB.count_msg;

356: );
357:
358:
359: -- Check Error Message stack.
360: x_msg_count := FND_MSG_PUB.count_msg;
361: IF x_msg_count > 0
362: THEN
363: RAISE FND_API.G_EXC_ERROR;
364: END IF;

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

369: COMMIT WORK;
370: END IF;
371:
372: -- Standard call to get message count and if count is 1, get message info
373: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
374: p_data => x_msg_data,
375: p_encoded => fnd_api.g_false );
376:
377: EXCEPTION

Line 381: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

377: EXCEPTION
378: WHEN FND_API.G_EXC_ERROR THEN
379: x_return_status := FND_API.G_RET_STS_ERROR;
380: Rollback to Process_Route_Operations_SP;
381: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
382: p_data => x_msg_data,
383: p_encoded => fnd_api.g_false);
384:
385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 388: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

384:
385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: Rollback to Process_Route_Operations_SP;
388: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
389: p_data => x_msg_data,
390: p_encoded => fnd_api.g_false);
391:
392: WHEN OTHERS THEN

Line 395: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

391:
392: WHEN OTHERS THEN
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: Rollback to Process_Route_Operations_SP;
395: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
396: THEN
397: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
398: p_procedure_name => 'Process_Route_Operations',
399: p_error_text => SUBSTR(SQLERRM,1,240));

Line 397: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: Rollback to Process_Route_Operations_SP;
395: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
396: THEN
397: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
398: p_procedure_name => 'Process_Route_Operations',
399: p_error_text => SUBSTR(SQLERRM,1,240));
400: END IF;
401: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 401: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

397: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
398: p_procedure_name => 'Process_Route_Operations',
399: p_error_text => SUBSTR(SQLERRM,1,240));
400: END IF;
401: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
402: p_data => x_msg_data,
403: p_encoded => fnd_api.g_false);
404:
405: END Process_Route_Operations;

Line 470: FND_MSG_PUB.INITIALIZE;

466:
467: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
468: IF FND_API.TO_BOOLEAN(p_init_msg_list)
469: THEN
470: FND_MSG_PUB.INITIALIZE;
471: END IF;
472:
473: -- Log API entry point
474: IF (l_log_procedure >= l_log_current_level) THEN

Line 536: FND_MSG_PUB.ADD;

532: THEN
533: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_DML');
534: FND_MESSAGE.SET_TOKEN('FIELD', p_enigma_route_rec.change_flag);
535: FND_MESSAGE.SET_TOKEN('RECORD', p_enigma_route_rec.route_id);
536: FND_MSG_PUB.ADD;
537: RAISE FND_API.G_EXC_ERROR;
538: END IF;
539:
540: -- When all clear, process the route rec by checking the change_flag (DML Operation).

Line 707: FND_MSG_PUB.ADD;

703: END IF;
704: ELSE
705: -- Raise an error if the route is not found in CMRO..
706: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_ROUTE_DONOT_EXIST');
707: FND_MSG_PUB.ADD;
708: CLOSE get_latest_route_rev;
709: RAISE FND_API.G_EXC_ERROR;
710: END IF; -- Cursor
711: CLOSE get_latest_route_rev;

Line 1230: FND_MSG_PUB.ADD;

1226:
1227: IF (p_pub_date IS NULL AND p_pub_date = FND_API.G_MISS_DATE)
1228: THEN
1229: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_PUB_DATE_NULL');
1230: FND_MSG_PUB.ADD;
1231: END IF;
1232:
1233: -- Validate is context is Null and If so throw an error
1234: IF (p_context IS NULL AND p_context = FND_API.G_MISS_CHAR)

Line 1237: FND_MSG_PUB.ADD;

1233: -- Validate is context is Null and If so throw an error
1234: IF (p_context IS NULL AND p_context = FND_API.G_MISS_CHAR)
1235: THEN
1236: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_CONTEXT_NULL');
1237: FND_MSG_PUB.ADD;
1238: END IF;
1239:
1240: -- Validate is Enigma_Id is Null and If so throw an error
1241: IF (p_enigma_route_rec.enigma_ID IS NULL AND p_enigma_route_rec.enigma_ID = FND_API.G_MISS_CHAR)

Line 1244: FND_MSG_PUB.ADD;

1240: -- Validate is Enigma_Id is Null and If so throw an error
1241: IF (p_enigma_route_rec.enigma_ID IS NULL AND p_enigma_route_rec.enigma_ID = FND_API.G_MISS_CHAR)
1242: THEN
1243: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_ENIGMA_ID_NULL');
1244: FND_MSG_PUB.ADD;
1245: END IF;
1246:
1247: -- Check the error stack and raise error messages , if any
1248: x_msg_count := FND_MSG_PUB.count_msg;

Line 1248: x_msg_count := FND_MSG_PUB.count_msg;

1244: FND_MSG_PUB.ADD;
1245: END IF;
1246:
1247: -- Check the error stack and raise error messages , if any
1248: x_msg_count := FND_MSG_PUB.count_msg;
1249: IF x_msg_count > 0
1250: THEN
1251: RAISE FND_API.G_EXC_ERROR;
1252: END IF;

Line 1476: FND_MSG_PUB.ADD;

1472: ELSE
1473: CLOSE get_latest_route_rev;
1474: -- Raise an error if the route is not found in CMRO..
1475: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_ROUTE_DONOT_EXIST1');
1476: FND_MSG_PUB.ADD;
1477: RAISE FND_API.G_EXC_ERROR;
1478: END IF; -- Cursor
1479: CLOSE get_latest_route_rev;
1480: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 1512: FND_MSG_PUB.ADD;

1508:
1509: IF (p_pub_date IS NULL AND p_pub_date = FND_API.G_MISS_DATE)
1510: THEN
1511: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_PUB_DATE_NULL');
1512: FND_MSG_PUB.ADD;
1513: END IF;
1514:
1515: -- Validate is context is Null and If so throw an error
1516: IF (p_context IS NULL AND p_context = FND_API.G_MISS_CHAR)

Line 1519: FND_MSG_PUB.ADD;

1515: -- Validate is context is Null and If so throw an error
1516: IF (p_context IS NULL AND p_context = FND_API.G_MISS_CHAR)
1517: THEN
1518: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_CONTEXT_NULL');
1519: FND_MSG_PUB.ADD;
1520: END IF;
1521:
1522: -- Validate is Enigma_Id is Null and If so throw an error
1523: IF (p_enigma_route_rec.enigma_ID IS NULL AND p_enigma_route_rec.enigma_ID = FND_API.G_MISS_CHAR)

Line 1526: FND_MSG_PUB.ADD;

1522: -- Validate is Enigma_Id is Null and If so throw an error
1523: IF (p_enigma_route_rec.enigma_ID IS NULL AND p_enigma_route_rec.enigma_ID = FND_API.G_MISS_CHAR)
1524: THEN
1525: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_ENIGMA_ID_NULL');
1526: FND_MSG_PUB.ADD;
1527: END IF;
1528:
1529: -- Check the error stack and raise error messages , if any
1530: x_msg_count := FND_MSG_PUB.count_msg;

Line 1530: x_msg_count := FND_MSG_PUB.count_msg;

1526: FND_MSG_PUB.ADD;
1527: END IF;
1528:
1529: -- Check the error stack and raise error messages , if any
1530: x_msg_count := FND_MSG_PUB.count_msg;
1531: IF x_msg_count > 0
1532: THEN
1533: RAISE FND_API.G_EXC_ERROR;
1534: END IF;

Line 1892: x_msg_count := FND_MSG_PUB.count_msg;

1888:
1889: END IF; -- status check 'C'
1890:
1891: -- Check Error Message stack.
1892: x_msg_count := FND_MSG_PUB.count_msg;
1893: IF x_msg_count > 0
1894: THEN
1895: RAISE FND_API.G_EXC_ERROR;
1896: END IF;

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

1901: COMMIT WORK;
1902: END IF;
1903:
1904: -- Standard call to get message count and if count is 1, get message info
1905: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1906: p_data => x_msg_data,
1907: p_encoded => fnd_api.g_false );
1908:
1909: EXCEPTION

Line 1913: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1909: EXCEPTION
1910: WHEN FND_API.G_EXC_ERROR THEN
1911: x_return_status := FND_API.G_RET_STS_ERROR;
1912: Rollback to Process_Route_Details_SP;
1913: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1914: p_data => x_msg_data,
1915: p_encoded => fnd_api.g_false);
1916:
1917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1920: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1916:
1917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1919: Rollback to Process_Route_Details_SP;
1920: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1921: p_data => x_msg_data,
1922: p_encoded => fnd_api.g_false);
1923:
1924: WHEN OTHERS THEN

Line 1927: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1923:
1924: WHEN OTHERS THEN
1925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1926: Rollback to Process_Route_Details_SP;
1927: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1928: THEN
1929: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1930: p_procedure_name => 'Process_Route_Details',
1931: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1929: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

1925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1926: Rollback to Process_Route_Details_SP;
1927: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1928: THEN
1929: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1930: p_procedure_name => 'Process_Route_Details',
1931: p_error_text => SUBSTR(SQLERRM,1,240));
1932: END IF;
1933: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1933: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1929: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1930: p_procedure_name => 'Process_Route_Details',
1931: p_error_text => SUBSTR(SQLERRM,1,240));
1932: END IF;
1933: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1934: p_data => x_msg_data,
1935: p_encoded => fnd_api.g_false);
1936:
1937: END Process_Route_Details;

Line 2012: FND_MSG_PUB.INITIALIZE;

2008:
2009: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
2010: IF FND_API.TO_BOOLEAN(p_init_msg_list)
2011: THEN
2012: FND_MSG_PUB.INITIALIZE;
2013: END IF;
2014:
2015: -- initialise it only if it is a OA Adapter !
2016: fnd_global.APPS_INITIALIZE (1003259,62211, 867);

Line 2077: FND_MSG_PUB.ADD;

2073: THEN
2074: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_DML');
2075: FND_MESSAGE.SET_TOKEN('FIELD', p_enigma_op_tbl(i).change_flag);
2076: FND_MESSAGE.SET_TOKEN('RECORD', p_enigma_op_tbl(i).operation_id);
2077: FND_MSG_PUB.ADD;
2078: RAISE FND_API.G_EXC_ERROR;
2079: END IF;
2080:
2081: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 2096: FND_MSG_PUB.ADD;

2092: -- Vefify is the operation_id null, if so throw an error .
2093: IF ( p_enigma_op_tbl(i).operation_id IS NULL OR p_enigma_op_tbl(i).operation_id = FND_API.G_MISS_CHAR)
2094: THEN
2095: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_OPER_ID_NULL');
2096: FND_MSG_PUB.ADD;
2097: RAISE FND_API.G_EXC_ERROR;
2098: END IF;
2099:
2100: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 2245: FND_MSG_PUB.ADD;

2241: ELSE
2242: -- If the operation is not found, then raise an error
2243: CLOSE get_latest_oper_rev;
2244: FND_MESSAGE.SET_NAME('AHL', 'AHL_ENIGMA_OPER_DONOT_EXIST');
2245: FND_MSG_PUB.ADD;
2246: RAISE FND_API.G_EXC_ERROR;
2247: END IF; -- Cursor Found
2248: END IF; -- Change Flag "D"
2249:

Line 2382: FND_MSG_PUB.ADD;

2378:
2379: IF (p_enigma_op_tbl(i).operation_id IS NULL AND p_enigma_op_tbl(i).operation_id = FND_API.G_MISS_DATE)
2380: THEN
2381: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_OPER_ID_NULL');
2382: FND_MSG_PUB.ADD;
2383: END IF;
2384:
2385: IF (p_context IS NULL AND p_context = FND_API.G_MISS_DATE)
2386: THEN

Line 2388: FND_MSG_PUB.ADD;

2384:
2385: IF (p_context IS NULL AND p_context = FND_API.G_MISS_DATE)
2386: THEN
2387: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_CONTEXT_NULL');
2388: FND_MSG_PUB.ADD;
2389: END IF;
2390:
2391: -- Check the error stack and raise error messages , if any
2392: x_msg_count := FND_MSG_PUB.count_msg;

Line 2392: x_msg_count := FND_MSG_PUB.count_msg;

2388: FND_MSG_PUB.ADD;
2389: END IF;
2390:
2391: -- Check the error stack and raise error messages , if any
2392: x_msg_count := FND_MSG_PUB.count_msg;
2393: IF x_msg_count > 0
2394: THEN
2395: RAISE FND_API.G_EXC_ERROR;
2396: END IF;

Line 2503: FND_MSG_PUB.ADD;

2499: -- Do the mandatory validations
2500: IF (p_enigma_op_tbl(i).operation_id IS NULL AND p_enigma_op_tbl(i).operation_id = FND_API.G_MISS_DATE)
2501: THEN
2502: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_OPER_ID_NULL');
2503: FND_MSG_PUB.ADD;
2504: END IF;
2505:
2506: IF (p_context IS NULL AND p_context = FND_API.G_MISS_DATE)
2507: THEN

Line 2509: FND_MSG_PUB.ADD;

2505:
2506: IF (p_context IS NULL AND p_context = FND_API.G_MISS_DATE)
2507: THEN
2508: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_CONTEXT_NULL');
2509: FND_MSG_PUB.ADD;
2510: END IF;
2511:
2512: -- Check the error stack and raise error messages , if any
2513: x_msg_count := FND_MSG_PUB.count_msg;

Line 2513: x_msg_count := FND_MSG_PUB.count_msg;

2509: FND_MSG_PUB.ADD;
2510: END IF;
2511:
2512: -- Check the error stack and raise error messages , if any
2513: x_msg_count := FND_MSG_PUB.count_msg;
2514: IF x_msg_count > 0
2515: THEN
2516: RAISE FND_API.G_EXC_ERROR;
2517: END IF;

Line 2692: FND_MSG_PUB.ADD;

2688: ELSE
2689: -- If the operation is not found, then raise an error
2690: CLOSE get_latest_oper_rev;
2691: FND_MESSAGE.SET_NAME('AHL', 'AHL_ENIGMA_OPER_DONOT_EXIST');
2692: FND_MSG_PUB.ADD;
2693: RAISE FND_API.G_EXC_ERROR;
2694: END IF; -- Cursor Found
2695: END IF; -- Change Flag "U"
2696:

Line 2943: x_msg_count := FND_MSG_PUB.count_msg;

2939: END LOOP;
2940: END IF; -- Oper Tbl Count
2941:
2942: -- Check Error Message stack.
2943: x_msg_count := FND_MSG_PUB.count_msg;
2944: IF x_msg_count > 0
2945: THEN
2946: RAISE FND_API.G_EXC_ERROR;
2947: END IF;

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

2952: COMMIT WORK;
2953: END IF;
2954:
2955: -- Standard call to get message count and if count is 1, get message info
2956: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2957: p_data => x_msg_data,
2958: p_encoded => fnd_api.g_false );
2959:
2960: EXCEPTION

Line 2964: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2960: EXCEPTION
2961: WHEN FND_API.G_EXC_ERROR THEN
2962: x_return_status := FND_API.G_RET_STS_ERROR;
2963: Rollback to Process_OP_Details_SP;
2964: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2965: p_data => x_msg_data,
2966: p_encoded => fnd_api.g_false);
2967:
2968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2971: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2967:
2968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2970: Rollback to Process_OP_Details_SP;
2971: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2972: p_data => x_msg_data,
2973: p_encoded => fnd_api.g_false);
2974:
2975: WHEN OTHERS THEN

Line 2978: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2974:
2975: WHEN OTHERS THEN
2976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2977: Rollback to Process_OP_Details_SP;
2978: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2979: THEN
2980: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2981: p_procedure_name => 'Process_OP_Details_SP',
2982: p_error_text => SUBSTR(SQLERRM,1,240));

Line 2980: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

2976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2977: Rollback to Process_OP_Details_SP;
2978: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2979: THEN
2980: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2981: p_procedure_name => 'Process_OP_Details_SP',
2982: p_error_text => SUBSTR(SQLERRM,1,240));
2983: END IF;
2984: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 2984: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2980: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2981: p_procedure_name => 'Process_OP_Details_SP',
2982: p_error_text => SUBSTR(SQLERRM,1,240));
2983: END IF;
2984: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2985: p_data => x_msg_data,
2986: p_encoded => fnd_api.g_false);
2987:
2988:

Line 3023: FND_MSG_PUB.add;

3019:
3020:
3021: IF p_file_name IS NULL THEN
3022: FND_MESSAGE.set_name( 'AHL','AHL_COM_REQD_PARAM_MISSING' );
3023: FND_MSG_PUB.add;
3024: x_return_status := FND_API.G_RET_STS_ERROR;
3025:
3026: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3027: fnd_log.string

Line 3074: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3070:
3071: EXCEPTION
3072: WHEN OTHERS THEN
3073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3074: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3075: THEN
3076: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
3077: p_procedure_name => 'UPLOAD_REVISION_REPORT',
3078: p_error_text => SUBSTR(SQLERRM,1,240));

Line 3076: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

3072: WHEN OTHERS THEN
3073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3074: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3075: THEN
3076: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
3077: p_procedure_name => 'UPLOAD_REVISION_REPORT',
3078: p_error_text => SUBSTR(SQLERRM,1,240));
3079:
3080: END IF;