DBA Data[Home] [Help]

APPS.AHL_ENIGMA_ROUTE_OP_PUB dependencies on FND_MESSAGE

Line 332: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_ROUTE_ID_NULL');

328: -- Process the incoming enigma record.
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:

Line 533: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_DML');

529:
530: -- Verify if the Change flag is right...
531: IF (p_enigma_route_rec.change_flag NOT IN ( 'C', 'D', 'U'))
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;

Line 534: FND_MESSAGE.SET_TOKEN('FIELD', p_enigma_route_rec.change_flag);

530: -- Verify if the Change flag is right...
531: IF (p_enigma_route_rec.change_flag NOT IN ( 'C', 'D', 'U'))
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;

Line 535: FND_MESSAGE.SET_TOKEN('RECORD', p_enigma_route_rec.route_id);

531: IF (p_enigma_route_rec.change_flag NOT IN ( 'C', 'D', 'U'))
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:

Line 706: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_ROUTE_DONOT_EXIST');

702:
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

Line 1229: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_PUB_DATE_NULL');

1225: END IF;
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

Line 1236: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_CONTEXT_NULL');

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)
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

Line 1243: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_ENIGMA_ID_NULL');

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)
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

Line 1475: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_ROUTE_DONOT_EXIST1');

1471: END IF; -- Status check
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;

Line 1511: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_PUB_DATE_NULL');

1507: -- Validate is publish_date is Null and If so throw an error
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

Line 1518: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_CONTEXT_NULL');

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)
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

Line 1525: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_ENIGMA_ID_NULL');

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)
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

Line 2074: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_DML');

2070:
2071: -- Verify if the Change flag is right...
2072: IF (p_enigma_op_tbl(i).change_flag NOT IN ( 'C', 'D', 'U'))
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;

Line 2075: FND_MESSAGE.SET_TOKEN('FIELD', p_enigma_op_tbl(i).change_flag);

2071: -- Verify if the Change flag is right...
2072: IF (p_enigma_op_tbl(i).change_flag NOT IN ( 'C', 'D', 'U'))
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;

Line 2076: FND_MESSAGE.SET_TOKEN('RECORD', p_enigma_op_tbl(i).operation_id);

2072: IF (p_enigma_op_tbl(i).change_flag NOT IN ( 'C', 'D', 'U'))
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:

Line 2095: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_OPER_ID_NULL');

2091:
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:

Line 2244: FND_MESSAGE.SET_NAME('AHL', 'AHL_ENIGMA_OPER_DONOT_EXIST');

2240: END IF;
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"

Line 2381: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_OPER_ID_NULL');

2377: -- Do the mandatory validations
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)

Line 2387: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_CONTEXT_NULL');

2383: END IF;
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

Line 2502: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_OPER_ID_NULL');

2498:
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)

Line 2508: FND_MESSAGE.Set_Name('AHL','AHL_ENIGMA_CONTEXT_NULL');

2504: END IF;
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

Line 2691: FND_MESSAGE.SET_NAME('AHL', 'AHL_ENIGMA_OPER_DONOT_EXIST');

2687: END IF;
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"

Line 3022: FND_MESSAGE.set_name( 'AHL','AHL_COM_REQD_PARAM_MISSING' );

3018: END IF;
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