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_RM_RT_OP_DEP_PVT dependencies on FND_MSG_PUB

Line 381: FND_MSG_PUB.add;

377:
378: -- Check if a valid value is passed in p_route_id
379: IF ( p_route_id = FND_API.G_MISS_NUM OR p_route_id IS NULL ) THEN
380: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_ID_NULL' );
381: FND_MSG_PUB.add;
382: x_return_status := FND_API.G_RET_STS_ERROR;
383: RETURN;
384: END IF;
385:

Line 396: FND_MSG_PUB.ADD;

392: );
393:
394: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
395: FND_MESSAGE.SET_NAME('AHL',l_msg_data);
396: FND_MSG_PUB.ADD;
397: x_return_status := l_return_status;
398: RETURN;
399: END IF;
400:

Line 405: FND_MSG_PUB.add;

401: -- Check if at least one record is passed in p_x_rt_oper_dep_tbl
402: IF ( p_x_rt_oper_dep_tbl.count < 1 ) THEN
403: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
404: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || l_api_name );
405: FND_MSG_PUB.add;
406: x_return_status := FND_API.G_RET_STS_ERROR;
407: RETURN;
408: END IF;
409:

Line 418: FND_MSG_PUB.add;

414: p_x_rt_oper_dep_tbl(i).dml_operation <> 'D' ) THEN
415: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
416: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_dep_tbl(i).dml_operation );
417: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_dep_tbl(i) ) );
418: FND_MSG_PUB.add;
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: RETURN;
421: END IF;
422: -- Validation for Step,Operation Number and Status

Line 432: FND_MSG_PUB.add;

428: p_x_rt_oper_dep_tbl(i).from_op_number = FND_API.G_MISS_CHAR ) OR(p_x_rt_oper_dep_tbl(i).from_op_status IS NULL OR
429: p_x_rt_oper_dep_tbl(i).from_op_status = FND_API.G_MISS_CHAR ))
430: THEN
431: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_DEP_STEP_NUM_STA_MAN' );
432: FND_MSG_PUB.add;
433: x_return_status := FND_API.G_RET_STS_ERROR;
434: RETURN;
435: END IF;
436: END IF;

Line 447: FND_MSG_PUB.add;

443: p_x_rt_oper_dep_tbl(i).to_op_number = FND_API.G_MISS_CHAR ) OR(p_x_rt_oper_dep_tbl(i).to_op_status IS NULL OR
444: p_x_rt_oper_dep_tbl(i).to_op_status = FND_API.G_MISS_CHAR ))
445: THEN
446: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_DEP_STEP_NUM_STA_MAN' );
447: FND_MSG_PUB.add;
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: END IF;
450: END IF;
451:

Line 506: FND_MSG_PUB.ADD;

502: FND_MESSAGE.SET_NAME('AHL','AHL_RM_INV_ROUTE_OPER_ASSO');
503: FND_MESSAGE.SET_TOKEN('NUMBER', p_operation_number);
504: FND_MESSAGE.SET_TOKEN('STEP', p_operation_step);
505: FND_MESSAGE.SET_TOKEN('STATUS', p_operation_status);
506: FND_MSG_PUB.ADD;
507:
508: IF (G_DEBUG = 'Y') THEN
509: AHL_DEBUG_PUB.debug(G_PKG_NAME||'.'||l_api_name||': INVALID Operation Name , Operation Step and Status' );
510: END IF;

Line 573: FND_MSG_PUB.ADD;

569: EXCEPTION
570: WHEN l_cyclic_loop THEN
571: FND_MESSAGE.SET_NAME('AHL','AHL_RM_RT_OPSTEP_INVALID_CYC');
572: FND_MESSAGE.SET_TOKEN('RECORD',p_from_op_step ,false);
573: FND_MSG_PUB.ADD;
574: x_return_status := FND_API.G_RET_STS_ERROR;
575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
576: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 577: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

573: FND_MSG_PUB.ADD;
574: x_return_status := FND_API.G_RET_STS_ERROR;
575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
576: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
578: p_count => x_msg_count,
579: p_data => x_msg_data);
580:
581: WHEN FND_API.G_EXC_ERROR THEN

Line 583: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

579: p_data => x_msg_data);
580:
581: WHEN FND_API.G_EXC_ERROR THEN
582: X_return_status := FND_API.G_RET_STS_ERROR;
583: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
584: p_count => x_msg_count,
585: p_data => X_msg_data);
586: WHEN OTHERS THEN
587: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

584: p_count => x_msg_count,
585: p_data => X_msg_data);
586: WHEN OTHERS THEN
587: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
589: THEN
590: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RM_RT_OP_DEPEN_PVT',
591: p_procedure_name => 'VALIDATE_CYCLIC_DEPENDENCIES',
592: p_error_text => SUBSTR(SQLERRM,1,240));

Line 590: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RM_RT_OP_DEPEN_PVT',

586: WHEN OTHERS THEN
587: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
589: THEN
590: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RM_RT_OP_DEPEN_PVT',
591: p_procedure_name => 'VALIDATE_CYCLIC_DEPENDENCIES',
592: p_error_text => SUBSTR(SQLERRM,1,240));
593: END IF;
594: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 594: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

590: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RM_RT_OP_DEPEN_PVT',
591: p_procedure_name => 'VALIDATE_CYCLIC_DEPENDENCIES',
592: p_error_text => SUBSTR(SQLERRM,1,240));
593: END IF;
594: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
595: p_count => x_msg_count,
596: p_data => X_msg_data);
597:
598: END validate_cyclic_dependencies;

Line 700: FND_MSG_PUB.initialize;

696: END IF;
697:
698: -- Initialize message list if p_init_msg_list is set to TRUE.
699: IF FND_API.to_boolean( p_init_msg_list ) THEN
700: FND_MSG_PUB.initialize;
701: END IF;
702:
703: IF G_DEBUG = 'Y' THEN
704: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );

Line 774: FND_MSG_PUB.add;

770: IF (validate_oper_step%NOTFOUND)
771: THEN
772: FND_MESSAGE.set_name('AHL', 'AHL_RM_OPER_NOT_ASSO');
773: FND_MESSAGE.set_token( 'NUMBER', p_x_rt_oper_dep_tbl(i).from_op_number );
774: FND_MSG_PUB.add;
775: END IF;
776: CLOSE validate_oper_step;
777: END IF;
778:

Line 811: FND_MSG_PUB.add;

807: IF (validate_oper_step%NOTFOUND)
808: THEN
809: FND_MESSAGE.set_name('AHL', 'AHL_RM_OPER_NOT_ASSO');
810: FND_MESSAGE.set_token( 'NUMBER', p_x_rt_oper_dep_tbl(i).to_op_number );
811: FND_MSG_PUB.add;
812: END IF;
813: CLOSE validate_oper_step;
814: END IF;
815:

Line 846: FND_MSG_PUB.add;

842: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_dep_tbl(i).dependency_code );
843: ELSE
844: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_dep_tbl(i).dependency_mean );
845: END IF;
846: FND_MSG_PUB.add;
847: END IF;
848:
849: END IF;
850:

Line 856: FND_MSG_PUB.add;

852:
853: IF (p_x_rt_oper_dep_tbl(i).from_op_step = p_x_rt_oper_dep_tbl(i).to_op_step)
854: THEN
855: FND_MESSAGE.set_name('AHL', 'AHL_RM_DEP_SAME_OP');
856: FND_MSG_PUB.add;
857: END IF;
858:
859: END IF;
860:

Line 869: FND_MSG_PUB.add;

865: FETCH validate_depen_ovn INTO l_dummy;
866: IF (validate_depen_ovn%NOTFOUND)
867: THEN
868: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
869: FND_MSG_PUB.add;
870: END IF;
871: CLOSE validate_depen_ovn;
872: END IF;
873:

Line 875: l_msg_count := FND_MSG_PUB.count_msg;

871: CLOSE validate_depen_ovn;
872: END IF;
873:
874: -- Get all the error messages if any and raise the appropriate Exception
875: l_msg_count := FND_MSG_PUB.count_msg;
876: IF l_msg_count > 0 THEN
877: x_msg_count := l_msg_count;
878: RAISE FND_API.G_EXC_ERROR;
879: END IF;

Line 911: FND_MSG_PUB.add;

907: ELSE
908: FND_MESSAGE.set_token( 'FIELD1', l_res_max_duration );
909: FND_MESSAGE.set_token( 'FIELD2', l_route_time_span );
910: END IF;
911: FND_MSG_PUB.add;
912: END IF;
913:
914: END IF;
915:

Line 941: FND_MSG_PUB.add;

937: THEN
938: FND_MESSAGE.set_name('AHL', 'AHL_RM_DUP_DEPEND');
939: FND_MESSAGE.set_token( 'FROM_NUMBER', p_x_rt_oper_dep_tbl(i).from_op_number );
940: FND_MESSAGE.set_token( 'TO_NUMBER', p_x_rt_oper_dep_tbl(i).to_op_number );
941: FND_MSG_PUB.add;
942: RAISE FND_API.G_EXC_ERROR;
943: END IF;
944: CLOSE duplicate_depen;
945: END IF;

Line 993: FND_MSG_PUB.add;

989: THEN
990: FND_MESSAGE.set_name('AHL', 'AHL_RM_DUP_DEPEND');
991: FND_MESSAGE.set_token( 'FROM_NUMBER', p_x_rt_oper_dep_tbl(i).from_op_number );
992: FND_MESSAGE.set_token( 'TO_NUMBER', p_x_rt_oper_dep_tbl(i).to_op_number );
993: FND_MSG_PUB.add;
994: RAISE FND_API.G_EXC_ERROR;
995: END IF;
996: CLOSE duplicate_depen;
997:

Line 1108: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1104: EXCEPTION
1105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1106: ROLLBACK TO sp_process_rt_oper_dep_pvt;
1107: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1108: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1109: p_count => x_msg_count,
1110: p_data => x_msg_data);
1111:
1112: WHEN FND_API.G_EXC_ERROR THEN

Line 1115: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1111:
1112: WHEN FND_API.G_EXC_ERROR THEN
1113: ROLLBACK TO sp_process_rt_oper_dep_pvt;
1114: X_return_status := FND_API.G_RET_STS_ERROR;
1115: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1116: p_count => x_msg_count,
1117: p_data => X_msg_data);
1118: WHEN OTHERS THEN
1119: ROLLBACK TO sp_process_rt_oper_dep_pvt;

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

1118: WHEN OTHERS THEN
1119: ROLLBACK TO sp_process_rt_oper_dep_pvt;
1120: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1121:
1122: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1123: THEN
1124: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RM_RT_OP_DEP_PVT',
1125: p_procedure_name => 'PROCESS_RT_OPER_DEP',
1126: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1124: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RM_RT_OP_DEP_PVT',

1120: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1121:
1122: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1123: THEN
1124: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RM_RT_OP_DEP_PVT',
1125: p_procedure_name => 'PROCESS_RT_OPER_DEP',
1126: p_error_text => SUBSTR(SQLERRM,1,240));
1127: END IF;
1128: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

Line 1128: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1124: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RM_RT_OP_DEP_PVT',
1125: p_procedure_name => 'PROCESS_RT_OPER_DEP',
1126: p_error_text => SUBSTR(SQLERRM,1,240));
1127: END IF;
1128: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1129: p_count => x_msg_count,
1130: p_data => X_msg_data);
1131:
1132: